Gundy Company expects to produce1,281,600units of Product XX in 2017. Monthly production is expected to range from81,500to113,700units. 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 $5and for supervision are $3.

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

GUNDY COMPANY Monthly Flexible Manufacturing Budget For the Year 2017
Total Variable CostsDirect LaborSupervisionActivity LevelTotal CostsVariable CostsTotal Fixed CostsDirect MaterialsDepreciationOverheadFinished UnitsFixed Costs
Fixed CostsVariable CostsDirect LaborFinished UnitsDepreciationDirect MaterialsOverheadTotal Variable CostsSupervisionActivity LevelTotal CostsTotal Fixed Costs
Finished UnitsDirect LaborFixed CostsTotal Variable CostsActivity LevelOverheadTotal Fixed CostsVariable CostsSupervisionDepreciationDirect MaterialsTotal Costs
DepreciationOverheadFixed CostsSupervisionDirect LaborDirect MaterialsVariable CostsFinished UnitsTotal CostsActivity LevelTotal Fixed CostsTotal Variable Costs	$	$	$
Total Variable CostsFixed CostsOverheadVariable CostsTotal CostsFinished UnitsSupervisionActivity LevelTotal Fixed CostsDepreciationDirect LaborDirect Materials
Total Fixed CostsFinished UnitsDepreciationOverheadFixed CostsDirect MaterialsDirect LaborSupervisionTotal CostsTotal Variable CostsVariable CostsActivity Level
OverheadFinished UnitsDepreciationTotal Variable CostsSupervisionTotal CostsVariable CostsActivity LevelFixed CostsTotal Fixed CostsDirect MaterialsDirect Labor	$	$	$
Variable CostsTotal Variable CostsFinished UnitsTotal Fixed CostsDepreciationDirect LaborTotal CostsActivity LevelDirect MaterialsFixed CostsOverheadSupervision
Fixed CostsVariable CostsActivity LevelTotal Variable CostsFinished UnitsDepreciationOverheadSupervisionDirect LaborTotal CostsDirect MaterialsTotal Fixed Costs
DepreciationFinished UnitsFixed CostsDirect LaborVariable CostsDirect MaterialsTotal Fixed CostsOverheadSupervisionTotal CostsTotal Variable CostsActivity Level
DepreciationDirect LaborTotal Variable CostsTotal CostsDirect MaterialsTotal Fixed CostsVariable CostsActivity LevelFinished UnitsOverheadFixed CostsSupervision
Fixed CostsDirect LaborTotal Variable CostsOverheadDirect MaterialsFinished UnitsSupervisionActivity LevelVariable CostsTotal CostsTotal Fixed CostsDepreciation	$	$	$

See question attached.

Gundy Company expects to produce 1,281,600 units of Product XX in 2017. Monthly production is expected to range from 81,500 to 113,700 units. 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 $5 and for supervision are $3. Prepare a flexible manufacturing budget for the relevant range value using 16,100 unit increments. (List variable costs before fixed costs.) GUNDY COMPANY Monthly Flexible Manufacturing Budget For the Year 2017 $ $ $ $ $ $ $ $ $