can someone help me fix the mistake i made in the problem M9-5 (Algo) Preparing a Flexible Budget [LO 9-2]Evanson Company expects to produce 564,000 units of their product during the year. Monthly production is expected to range from40,000 to 80,000 units. The company has budgeted manufacturing costs per unit to be as follows:Direct materialsDirect laborVariable manufacturing overheadFixed manufacturing overheadActivity levelFinished unitsVariable costsPrepare a flexible manufacturing budget using 20,000 unit increments.Answer is complete but not entirely correct.Evanson CompanyMonthly Flexible Manufacturing BudgetDirect materialsDirect laborOverheadTotal variable costsFixed costsTotal fixed costsTotal costs20,000$20$400,000$420,000440,000$1,260,000141,000$ 1,401,0002122340.00080,000800,000 $1,600,000840,0001,680,000880,0001,760,000$2,520,000$5,040,000141,000141,000$ 2,661,000$ 5,181,000

MANUFACTURING OH BUDGETManufacturing OH Budget is the Management Estimation of Manufacturing OH Cost…

M9-5 (Algo) Preparing a Flexible Budget [LO 9-2] Evanson Company expects to produce 564,000 units of their product during the year. Monthly production is expected to range from 40,000 to 80,000 units. The company has budgeted manufacturing costs per unit to be as follows: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Activity level Finished units Prepare a flexible manufacturing budget using 20,000 unit increments. Answer is complete but not entirely correct. Evanson Company Monthly Flexible Manufacturing Budget Variable costs Direct materials Direct labor Overhead Total variable costs Fixed costs Total fixed costs Total costs 20,000 $20 $400,000$ 420,000 440,000 $1,260,000 141,000 $ 1,401,000 21 22 3 40.000 80,000 800,000 $1,600,000 840,000 1,680,000 880,000 1,760,000 $2,520,000 $5,040,000 141,000 141,000 $ 2,661,000$ 5,181,000

M9-5 (Algo) Preparing a Flexible Budget [LO 9-2] Evanson Company expects to produce 564,000 units of their product during the year. Monthly production is expected to range from 40,000 to 80,000 units. The company has budgeted manufacturing costs per unit to be as follows: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Activity level Finished units Prepare a flexible manufacturing budget using 20,000 unit increments. Answer is complete but not entirely correct. Evanson Company Monthly Flexible Manufacturing Budget Variable costs Direct materials Direct labor Overhead Total variable costs Fixed costs Total fixed costs Total costs 20,000 $20 $400,000$ 420,000 440,000 $1,260,000 141,000 $ 1,401,000 21 22 3 40.000 80,000 800,000 $1,600,000 840,000 1,680,000 880,000 1,760,000 $2,520,000 $5,040,000 141,000 141,000 $ 2,661,000$ 5,181,000

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 13CE: Nashler Company has the following budgeted variable costs per unit produced: Budgeted fixed overhead...

See similar textbooks

Similar questions

Cold X, Inc. uses this information when preparing their flexible budget: direct materials of $2 per unit, direct labor of $3 per unit, and manufacturing overhead of $1 per unit. Fixed costs are $35,000. What would be the budgeted amounts for 20,000 and 25,000 units?
Use the following information for Exercises 9-50 and 9-51: Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for 475, and the S12L5 sells for 300. Projected sales (number of speakers) for the coming 5 quarters are as follows: The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Exercise 9-50 Sales Budget Refer to the information regarding Stillwater Designs above. Required: 1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales by product and in total for each time period. 2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?
Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: Four welding units, with a lease cost of 12,000 per year per unit Six welding employees each paid a salary of 50,000 per year (A total of 9,000 welding hours are supplied by the six workers.) Welding supplies: 300 per job Welding hours: Three hours used per job During the year, the activity operated at 90 percent of capacity and incurred the actual activity and resource costs, shown on page 676. Lease cost: 48,000 Salaries: 315,000 Parts and supplies: 805,000 Required: 1. Prepare a flexible budget formula for the welding activity using welding hours as the driver. 2. Prepare a performance report for the welding activity. 3. What if welders were hired through outsourcing and paid 30 per hour (the welding equipment is provided by Foy)? Repeat Requirement 1 for the outsourcing case.
Aspen Enterprises makes award pins for various events. Budget information regarding the current period is: A fraternity with which Aspen has a long relationship approached Aspen with a special order for 6,000 pins at a price of $2.75 per pin. Variable costs will be the same as the current production, and the special order will not impact the rest of the companys orders. However, Aspen is operating at capacity and will incur an additional $5,000 in fixed manufacturing overhead if the order is accepted. Based on this information, what is the differential income (loss) associated with accepting the special order?
Nashler Company has the following budgeted variable costs per unit produced: Budgeted fixed overhead costs per month include supervision of 98,000, depreciation of 76,000, and other overhead of 245,000. Required: 1. Prepare a flexible budget for all costs of production for the following levels of production: 160,000 units, 170,000 units, and 175,000 units. 2. What is the per-unit total product cost for each of the production levels from Requirement 1? (Round each unit cost to the nearest cent.) 3. What if Nashler Companys cost of maintenance rose to 0.22 per unit? How would that affect the unit product costs calculated in Requirement 2?
Each unit requires direct labor of 4.1 hours. The labor rate is $13.75 per hour and next years production is estimated at 75,000 units. What is the amount to be included in next years direct labor budget?
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.
Judges Gavel uses this information when preparing their flexible budget: direct materials of $3 per unit, direct labor of $2.50 per unit, and manufacturing overhead of $1.25 per unit. Fixed costs are $49,000. What would be the budgeted amounts for 33,000 and 35,000 units?
Starburst Inc. has the following items and amounts as part of its master budget at the 10,000-unit level of sales and production: Determine the total dollar amounts for the above items that would appear in a flexible budget at the following volume levels, assuming that both levels are within the relevant range: a. 8,000-unit level of sales and production b. 12,000-unit level of sales and production (Hint: You must first determine the unit selling price and certain unit costs.)
Refer 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.
Using the following per-unit and total amounts, prepare a flexible budget at the 14,000-, 15,000-, and 16,000-unit levels of production and sales for Natural Products Inc.: