Accounting Question Brief Exercise 21-4

GundyCompany expects to produce1,238,400units of Product XX in 2012. Monthly production is expected to range from84,840to128,260units. Budgeted variable manufacturing costs per unit are: direct materials $4, direct labor $7, and overhead $11. Budgeted fixed manufacturing costs per unit for depreciation are $6and for supervision are $2.

Prepare a flexible manufacturing budget for the relevant range value using21,710unit increments.(List variable costs before fixed costs.)

Please Fill in the numbers.

GUNDY COMPANY Monthly Flexible Manufacturing Budget For the Year 2012
DepreciationTotal Variable CostsFixed CostsTotal Fixed CostsActivity LevelDirect LaborDirect MaterialsSupervisionOverheadTotal CostsFinished UnitsVariable Costs
Direct MaterialsTotal CostsActivity LevelFinished UnitsTotal Fixed CostsSupervisionTotal Variable CostsDirect LaborOverheadVariable CostsDepreciationFixed Costs
DepreciationVariable CostsOverheadTotal Fixed CostsTotal Variable CostsDirect LaborFixed CostsDirect MaterialsFinished UnitsSupervisionActivity LevelTotal Costs
DepreciationTotal Fixed CostsSupervisionVariable CostsFixed CostsTotal CostsTotal Variable CostsActivity LevelDirect LaborDirect MaterialsOverheadFinished Units	$	$	$
Direct LaborDirect MaterialsTotal Variable CostsOverheadActivity LevelVariable CostsDepreciationFinished UnitsFixed CostsSupervisionTotal Fixed CostsTotal Costs
DepreciationOverheadActivity LevelTotal CostsFinished UnitsFixed CostsTotal Variable CostsDirect LaborVariable CostsSupervisionDirect MaterialsTotal Fixed Costs
Total Fixed CostsTotal CostsTotal Variable CostsDirect MaterialsActivity LevelOverheadSupervisionVariable CostsFixed CostsDepreciationDirect LaborFinished Units	$	$	$
Fixed CostsTotal Variable CostsTotal CostsDirect LaborDirect MaterialsVariable CostsTotal Fixed CostsActivity LevelDepreciationFinished UnitsOverheadSupervision
Total Variable CostsSupervisionDepreciationTotal CostsTotal Fixed CostsActivity LevelVariable CostsFinished UnitsDirect LaborFixed CostsDirect MaterialsOverhead
DepreciationDirect LaborTotal Variable CostsTotal Fixed CostsOverheadVariable CostsSupervisionTotal CostsDirect MaterialsActivity LevelFinished UnitsFixed Costs
Variable CostsDirect MaterialsActivity LevelDirect LaborFinished UnitsFixed CostsDepreciationOverheadSupervisionTotal Variable CostsTotal CostsTotal Fixed Costs
SupervisionVariable CostsFinished UnitsTotal Fixed CostsTotal CostsDepreciationActivity LevelTotal Variable CostsOverheadDirect LaborFixed CostsDirect Materials	$	$	$