In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 300,000 units of the standard model and 140,000 units of the deluxe model during the coming year. The standard model requires 0.05 direct labor hour per unit, and the deluxe model requires 0.08. The controller has developed the following cost formulas for each of the four overhead items:
Cost Formula
Maintenance$34,600 + $1.25 DLH
Power$0.50 DLH
Indirect labor$68,500 + $2.30 DLH
Rent$31,100
Required:
1. Prepare an overhead budget for the expected activity level for the coming year.
2. Prepare an overhead budget that reflects production that is 10 percent higher than expected (for both products).
3. Prepare an overhead budget for production that is 20 percent lower than expected.
At Normal Production | |||||
Units | DLH per unit | Total DLH | |||
Standard Model | 300000 | 0.05 | 15000 | ||
Deluxe Model | 140000 | 0.08 | 11200 | ||
26200 | |||||
Overhead Budget | |||||
Per DLH | |||||
Budgeted DLH | 26200 | ||||
Variable Costs | |||||
Maintenance | $ 1.25 | $ 32,750.00 | |||
Power | $ 0.50 | $ 13,100.00 | |||
Indirect Labor | $ 2.30 | $ 60,260.00 | |||
Total Variable Cost | $ 106,110.00 | ||||
Fixed Costs | |||||
Maintenance | $ 34,600.00 | ||||
Indirect Labor | $ 68,500.00 | ||||
Rent | $ 31,100.00 | ||||
Total Fixed Costs | $ 134,200.00 | ||||
Total OH costs | $ 240,310.00 |
At 10% Higher Production Level | |||||
Units | DLH per unit | Total DLH | |||
Standard Model | 330000 | 0.05 | 16500 | ||
Deluxe Model | 154000 | 0.08 | 12320 | ||
28820 | |||||
Overhead Budget | |||||
Per DLH | |||||
Budgeted DLH | 28820 | ||||
Variable Costs | |||||
Maintenance | $ 1.25 | $ 36,025.00 | |||
Power | $ 0.50 | $ 14,410.00 | |||
Indirect Labor | $ 2.30 | $ 66,286.00 | |||
Total Variable Cost | $ 116,721.00 | ||||
Fixed Costs | |||||
Maintenance | $ 34,600.00 | ||||
Indirect Labor | $ 68,500.00 | ||||
Rent | $ 31,100.00 | ||||
Total Fixed Costs | $ 134,200.00 | ||||
Total OH costs | $ 250,921.00 |
At 20% Lower Production Level | |||||
Units | DLH per unit | Total DLH | |||
Standard Model | 240000 | 0.05 | 12000 | ||
Deluxe Model | 112000 | 0.08 | 8960 | ||
20960 | |||||
Overhead Budget | |||||
Per DLH | |||||
Budgeted DLH | 20960 | ||||
Variable Costs | |||||
Maintenance | $ 1.25 | $ 26,200.00 | |||
Power | $ 0.50 | $ 10,480.00 | |||
Indirect Labor | $ 2.30 | $ 48,208.00 | |||
Total Variable Cost | $ 84,888.00 | ||||
Fixed Costs | |||||
Maintenance | $ 34,600.00 | ||||
Indirect Labor | $ 68,500.00 | ||||
Rent | $ 31,100.00 | ||||
Total Fixed Costs | $ 134,200.00 | ||||
Total OH costs | $ 219,088.00 |
In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget...
In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 300,000 units of the standard model and 140,000 units of the deluxe model during the coming year. The standard model requires 0.05 direct labor hour per unit, and the deluxe model requires 0.08. The controller has developed the following cost formulas for each...
In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 400,000 units of the standard model and 140,000 units of the deluxe model during the coming year. The standard model requires 0.10 direct labor hour per unit, and the deluxe model requires 0.16. The controller has developed the following cost formulas for each...
Flexible Budget In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 400,000 units of the standard model and 140,000 units of the deluxe model during the coming year. The standard model requires 0.05 direct labor hour per unit, and the deluxe model requires 0.08. The controller has developed the following cost formulas...
Flexible Budget In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 300,000 units of the standard model and 120,000 units of the deluxe model during the coming year. The standard model requires 0.05 direct labor hour per unit, and the deluxe model requires 0.08. The controller has developed the following cost formulas...
Flexible Budget In an attempt to improve budgeting, the controller for Meliore, Inc., has developed a flexible budget for overhead costs. Meliore, Inc., makes two types of products, the standard model and the deluxe model. Meliore expects to produce 400,000 units of the standard model and 140,000 units of the deluxe model during the coming year. The standard model requires 0.10 direct labor hour per unit, and the deluxe model requires 0.16. The controller has developed the following cost formulas...
Larry Miller, controller for Kipling Company, has been instructed to develop a flexible budget for overhead costs. The company produces two types of frozen desserts: Icey and Tasty. The two desserts use common raw materials in different proportions. The company expects to produce 200,000 gallons of each product during the coming year. Icey requires 0.25 direct labor hour per gallon and Tasty requires 0.30. Larry has developed the following fixed and variable costs for each of the four overhead items:...
Montgomery Company has developed the following flexible budget formulas for its four overhead items: Variable rate per Overhead item Fixed Cost direct labor hour Maintenance $10,000 $ 3.00 Power $ 1,500 $ 0.30 Indirect labor cost $12.00 Equipment lease $ 7,000 Total $18,500 $15.30 Montgomery normally produces 15,000 units (each unit requires 0.30 direct labor hours); however this year 19,000 units were produced with the following actual costs: Overhead item Actual costs Maintenance...
(a) Prepare a monthly manufacturing overhead flexible budget for each increment of 2,100 direct labor hours over the relevant range for the year ending December 31, 2020. (List variable costs before fixed costs.) (b) Prepare a flexible budget report for October. (List variable costs before fixed costs.) Marigold Company estimates that 372,900 direct labor hours will be worked during the coming year, 2020, in the Packaging Department. On this basis, the following budgeted manufacturing overhead cost data are computed for...
Montgomery Company has developed the following flexible budget formulas for its four overhead items: Fixed Cost $10,000 $ 1,500 Overhead item Maintenance Power Indirect labor cost Equipment lease Total Variable rate per direct labor hour $ 3.00 $ 0.30 $12.00 $_7,000 $18,500 $15.30 Montgomery normally produces 15,000 units (each unit requires 0.30 direct labor hours); however this year 19,000 units were produced with the following actual costs: Overhead item Maintenance Power Indirect labor cost Equipment lease Total costs Actual costs...
(b) Prepare a flexible budget report for October. (List variable costs before fixed costs.) BUMBLEBEE COMPANY Packaging Department Manufacturing Overhead Flexible Budget Report For the Month Ended October 31, 2020 Difference Favorable Unfavorable Neither Favorable nor Unfavorable Budget Actual Costs Bumblebee Company estimates that 387,400 direct labor hours will be worked during the coming year, 2020, in the Packaging Department. On this basis, the following budgeted manufacturing overhead cost data are computed for the year. Fixed Overhead Costs Variable Overhead...