Concept explainers
Preparing an operating budget—direct materials, direct labor, and manufacturing
Learning Objective
3
3rd Qtr.
OH
$255.00
Grady, Inc manufactures model airplane kits and projects production at 650,500,450, and 600 kits for the next four quarters. Direct materials are 4 ounces of plastic per kit and the plastic costs $1 per ounce. Indirect materials are considered insignificant and are not included in the budgeting process. Beginning Raw Materials Inventory is 850 ounces, and the company desires to end each quarter with 10% of the materials needed for the next quarter's production. Grady desires a balance of 200 ounces in Raw Materials Inventory at the end of the fourth quarter. Each kit requires 0.10 hours of direct labor at an average cost of $10 per hour. Manufacturing overhead is allocated using direct labor hours as the allocation base. Variable overhead is $0.20 per kit, and fixed overhead is $165 per quarter. Prepare Grady's direct materials budget, direct labor budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for production, budgeted overhead costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number.
Note: Exercise E22-24 must be completed before attempting Exercise E22-20.
Want to see the full answer?
Check out a sample textbook solutionChapter 22 Solutions
Horngren's Accounting: The Managerial Chapters, Student Value Edition (12th Edition)
- Refer to Cornerstone Exercise 8.1, through Requirement 1. FlashKick requires ending inventory of product to equal 20 percent of the next months unit sales. Beginning inventory in January was 3,100 practice soccer balls and 400 match soccer balls. Required: 1. Construct a production budget for each of the two product lines for FlashKick Company for the first three months of the coming year. 2. What if FlashKick wanted a production budget for the two product lines for the month of April? What additional information would you need to prepare this budget? FlashKick Company manufactures and sells soccer balls for teams of children in elementary and high school. FlashKicks best-selling lines are the practice ball line (durable soccer balls for training and practice) and the match ball line (high-performance soccer balls used in games). In the first four months of next year, FlashKick expects to sell the following: Required: 1. Construct a sales budget for FlashKick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter. 2. What if FlashKick added a third linetournament quality soccer balls that were expected to take 40 percent of the units sold of the match balls and would have a selling price of 45 each in January and February, and 48 each in March? Prepare a sales budget for Flash- Kick for the first three months of the coming year. Show total sales for each product line by month and in total for the first quarter.arrow_forwardRefer to Cornerstone Exercise 8.6. Required: 1. Calculate the total budgeted cost of units produced for Play-Disc for the coming year. Show the cost of direct materials, direct labor, and overhead. 2. Prepare a cost of goods sold budget for Play-Disc for the year. 3. What if the beginning inventory of finished goods was 75,200 (for 16,000 units)? How would that affect the cost of goods sold budget? (Assume Play-Disc uses the FIFO method.) Play-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.arrow_forwardStudent question Garden Sales, Incorporated, sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: Budgeted monthly absorption costing income statements for April–July are: April May June July Sales $ 730,000 $ 910,000 $ 610,000 $ 520,000 Cost of goods sold 511,000 637,000 427,000 364,000 Gross margin 219,000 273,000 183,000 156,000 Selling and administrative expenses: Selling expense 91,000 110,000 72,000 52,000 Administrative expense* 50,500 68,800 44,600 49,000 Total selling and administrative expenses 141,500 178,800 116,600 101,000 Net operating income $ 77,500 $ 94,200 $ 66,400 $ 55,000 *Includes $33,000 of depreciation each month. Sales are 20% for cash and 80% on account. Sales…arrow_forward
- Question Content Area I AM NEEDING THE PICTURES ANWSERED THE PASSAGE IS JUST FOR ASSISTANCE TO ANSWER THE QUESTIONS Question Content Area LearnCo LearnCo manufactures and sells one product, an abacus for classroom use, with two models, the Basic model and the Deluxe model. The company began operations on January 1, 20Y1, and is planning for 20Y2, its second year of operations, by preparing budgets from its master budget. The company is trying to decide how many units to manufacture, how much it might spend on direct materials and direct labor, and what their factory overhead expenses might be. In addition, the company is interested in budgeting for selling and administrative costs, and in creating a budgeted income statement showing a prediction of net income for 20Y2. You have been asked to assist the controller of LearnCo in preparing the 20Y2 budgets. Sales Budget The sales budget often uses the prior year’s sales as a starting point, and then sales quantities are revised…arrow_forwardCompleting a comprehensive budgeting problem—manufacturing company The Gerard Tire Company, manufactures racing tires for bicycles. Gerard sells tires for $90 each. Gerard is planning for the next year by developing a master budget by quarters. Gerard’s balance sheet for December 31, 2018, follows: Other data for Gerard Tire Company: Budgeted sales are 1,500 tires for the first quarter and expected to increase by 200 tires per quarter. Cash sales are expected to be 10% of total sales, with the remaining 90% of sales on account. Finished Goods Inventory on December 31, 2018, consists of 300 tires at $33 each. Desired ending Finished Goods Inventory is 30% of the next quarter’s sales; first quarter sales for 2020 are expected to be 2,300 tires. FIFO inventory costing method is used. Raw Materials Inventory on December 31, 2018, consists of 600 pounds of rubber compound used to manufacture the tires. Direct materials requirements are 2 pounds of a rubber compound per tire. The cost of…arrow_forward7. Question Content Area Direct Materials Purchases Budget: Direct Labor Budget Crescent Company produces stuffed toy animals; one of these is “Arabeau the Cow.” Each Arabeau takes 0.20 yard of fabric (white with irregular black splotches) and 10 ounces of polyfiberfill. Fabric costs $3.40 per yard and polyfiberfill is $0.05 per ounce. Crescent has budgeted production of Arabeaus for the next four months as follows: Units October 41,000 November 80,000 December 60,000 January 40,000 Inventory policy requires that sufficient fabric be in ending monthly inventory to satisfy 20 percent of the following month’s production needs and sufficient polyfiberfill be in inventory to satisfy 40 percent of the following month’s production needs. Inventory of fabric and polyfiberfill at the beginning of October equals exactly the amount needed to satisfy the inventory policy. Each Arabeau produced requires (on average) 0.10 direct labor hour. The average cost of direct labor is $15…arrow_forward
- BUS 203: INTRODUCTION TO COST AND MANAGEMENT ACCOUNTING PROJECT: CASH BUDGETING ASSOCIATE DEGREE YEAR 2: SEMESTER 1 (2020/21)Ronstadt Limited’s budget for the four months from January to April includes the following data:1. MonthSalesMaterialsWagesOverheads $000$000$000$000January615115.030360February636120.033390March690135.036420April684130.040425 2. One-third of sales revenue is received one month after sale and the remainder is received two months after sale. The sales in the previous two months were: November $600 000; December $540 000.3. One-quarter of purchases of materials are paid for in the month of purchase. The remainder are paid for two months later. Purchases in the previous two months were: November $108 000; December $106 000.4. Two-thirds of the wages are paid in the month in which they are earned, and the balance is paid in the following month. The wages for the previous December amounted to $30 000.5. One-half of the overhead expenditure is paid in the month in…arrow_forwardPreparing an operating budget—sa1es, production, direct materials direct labor, overhead, COGS, and S&A expense budgets The Langley Batting Company manufactures Wood baseball bats. Langley’s two primary products are a youth bat, designed for children and young teens, and an adult but, designed for high school and college-aged players. Langler sells the bats to sporting goods stores, and all sales are on account. The youth bat sells for $40 the adult bat sells for $65 Langley’s highest sales volume is in the first three months of the year as retailers prepare for the spring baseball season. Langley’s balance sheet for December 31, 2018, follows: Other data for Langley Batting Company for the first quarter of 2019: Budgeted sales are 1, 200 youth bats and 2 600 adult bats. Finished Goods Inventory on December 31, 2018, consists of 300 youth bats at $14 each and 950 adult bats at $18 each. Desired ending Finished Goods Inventory is 350 youth bats and 300 adult bats; FIFO inventory…arrow_forwardPlease prepare a consolidated budget pivot table in Excel by budget class and year. Please upload your excel document. Budget Class – Staff Costs • Salary of the Project Manager @ USD 5,000 per month. • Salary of the Admin Finance Officer @ USD 3,500 per month. • Salary of Admin. & Finance Assistant @USD 1,000 per month • Salary of Driver @USD 500 per month Budget Class – Equipment & Furniture Cost of the office equipment and furniture required for the project is USD 30,000 for three years to be procured during the 1st year of the project. Budget Class – Operating Costs (training) Two trainers are required for each training. Each training lasts for 5 days. The total number of participants for each training is 30. • DSA/ ticket cost of each participant @ USD1, 000 per training. • Total number of 5-day trainings planned for each year is 4. • Fee for Trainer @ USD 2,000 per training. • Cost of logistic arrangements for each training @ USD 10,000. In addition to the main direct…arrow_forward
- 5. Question Content Area Cash Budget Janet Wooster owns a retail store that sells new and used sporting equipment. Janet has requested a cash budget for October. After examining the records of the company, you find the following: Cash balance on October 1 is $1,110. Actual sales for August and September are as follows: August September Cash sales $6,000 $4,500 Credit sales 59,000 61,000 Total sales $65,000 $65,500 Credit sales are collected over a three-month period: 40 percent in the month of sale, 36 percent in the next month, and 22 percent in the second month after the sale. The remaining sales are uncollectible. Inventory purchases average 70 percent of a month’s total sales. Of those purchases, 45 percent are paid for in the month of purchase. The remaining 55 percent are paid for in the following month. Salaries and wages total $3,850 per month. Rent is $3,150 per month. Taxes to be paid in October are $1,635. Janet…arrow_forwardPlease help Multiple Choice question Sevenbergen Corporation makes one product and has provided the following information to help prepare the master budget for the next four months of operations: Budgeted selling price per unit $ 92 Budgeted unit sales (all on credit): July 9,000 August 11,300 September 10,400 October 10,800 Raw materials requirement per unit of output 4 pounds Raw materials cost $ 1.00 per pound Direct labor requirement per unit of output 2.8 direct labor-hours Direct labor wage rate $ 22.00 per direct labor-hour Variable selling and administrative expense $ 1.50 per unit sold Fixed selling and administrative expense $ 70,000 per month Credit sales are collected: 40% in the month of the sale 60% in the following month Raw materials purchases are paid: 30% in the month of purchase 70% in the following month The ending finished goods inventory should equal 20% of the following month's sales. The ending raw materials inventory should…arrow_forwardthis is actually a budgeting lesson. Beginning inventory 4.000 unit Ending inventory 3.500 unit The lack will be allocated to the 5 months (Jan, Feb, March, April dan May). Arrange production budget with a policy that accentuate production stability!arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub