Question

Gundy Company expects to produce 1,310,400 units of Product XX in 2020. Monthly production is expected to range from 83,000 to 113,000 units. Budgeted variable manufacturing costs per unit are direct materials $4, direct labor $8, and overhead $11. Budgeted fixed manufacturing costs per unit for depreciation are $4 and for supervision are $2.

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

GUNDY COMPANY Monthly Flexible Manufacturing Budget For the Year 2020
Select an opening flexible manufacturing budget item                                                          Total CostsDepreciationSupervisionFinished UnitsTotal Fixed CostsOverheadDirect MaterialsFixed CostsActivity LevelVariable CostsDirect LaborTotal Variable Costs
Select a budget item                                                          Direct MaterialsTotal CostsSupervisionTotal Fixed CostsFixed CostsDirect LaborOverheadActivity LevelTotal Variable CostsVariable CostsDepreciationFinished Units	Enter a number		Enter a number		Enter an amount
Select an opening name for section one                                                          SupervisionActivity LevelFinished UnitsVariable CostsTotal CostsFixed CostsOverheadTotal Fixed CostsDirect LaborTotal Variable CostsDepreciationDirect Materials
Select a budget item                                                          Direct LaborDirect MaterialsTotal Variable CostsTotal CostsVariable CostsOverheadSupervisionActivity LevelFixed CostsFinished UnitsTotal Fixed CostsDepreciation	$Enter a dollar amount		$Enter a dollar amount		$Enter a dollar amount
Select a budget item                                                          Total Variable CostsDirect LaborDepreciationTotal Fixed CostsFixed CostsTotal CostsActivity LevelOverheadFinished UnitsSupervisionDirect MaterialsVariable Costs	Enter a dollar amount		Enter a dollar amount		Enter a dollar amount
Select a budget item                                                          Total Variable CostsTotal Fixed CostsTotal CostsDepreciationActivity LevelOverheadDirect MaterialsVariable CostsFixed CostsFinished UnitsDirect LaborSupervision	Enter a dollar amount		Enter a dollar amount		Enter a dollar amount
Select a closing name for section one                                                          Variable CostsSupervisionOverheadTotal Variable CostsFinished UnitsFixed CostsDirect MaterialsDepreciationTotal Fixed CostsDirect LaborActivity LevelTotal Costs	$Enter a total amount for section one		$Enter a total amount for section one		$Enter a total amount for section one
Select an opening name for section two                                                          Activity LevelFixed CostsDirect MaterialsTotal Variable CostsDirect LaborVariable CostsFinished UnitsTotal Fixed CostsSupervisionDepreciationTotal CostsOverhead
Select a budget item                                                          Direct MaterialsDepreciationTotal Fixed CostsDirect LaborVariable CostsTotal Variable CostsSupervisionActivity LevelOverheadFinished UnitsTotal CostsFixed Costs	Enter a dollar amount		Enter a dollar amount		Enter a dollar amount
Select a budget item                                                          Fixed CostsSupervisionDepreciationTotal Fixed CostsVariable CostsTotal CostsDirect MaterialsActivity LevelFinished UnitsOverheadDirect LaborTotal Variable Costs	Enter a dollar amount		Enter a dollar amount		Enter a dollar amount
Select a closing name for section two                                                          Total Variable CostsFixed CostsDirect LaborVariable CostsFinished UnitsSupervisionDirect MaterialsTotal CostsActivity LevelTotal Fixed CostsDepreciationOverhead	Enter a total amount for section two		Enter a total amount for section two		Enter a total amount for section two
Select a closing flexible manufacturing budget item                                                          Finished UnitsTotal Fixed CostsDepreciationDirect MaterialsOverheadActivity LevelSupervisionVariable CostsTotal Variable CostsFixed CostsDirect LaborTotal Costs	$Enter a total dollar amount		$Enter a total dollar amount		$Enter a total dollar amount

Answer 1