Gundy Company expects to produce 1,308,000 units of Product XX in 2020. Monthly production is expected to range from 73,000 to 113,000 units. Budgeted variable manufacturing costs per unit are direct materials $5, direct labor $7, and overhead $9. Budgeted fixed manufacturing costs per unit for depreciation are $5 and for supervision are $3 when 93,000 units are produced in a month. Prepare a flexible manufacturing budget for the relevant range value using 20,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 Variable CostsTotal CostsFixed CostsDirect LaborDirect MaterialsFinished UnitsActivity LevelDepreciationVariable CostsTotal Fixed CostsOverheadSupervision
Select a budget item OverheadVariable CostsFixed CostsTotal Variable CostsTotal Fixed CostsDepreciationDirect LaborActivity LevelDirect MaterialsSupervisionTotal CostsFinished Units	Enter a number		Enter a number		Enter an amount
Select an opening name for section one Finished UnitsTotal Fixed CostsTotal CostsFixed CostsTotal Variable CostsDirect MaterialsDirect LaborActivity LevelOverheadDepreciationSupervisionVariable Costs
Select a budget item Variable CostsDirect MaterialsFixed CostsSupervisionTotal Fixed CostsTotal CostsOverheadDepreciationDirect LaborTotal Variable CostsActivity LevelFinished Units	$Enter a dollar amount		$Enter a dollar amount		$Enter a dollar amount
Select a budget item Total CostsFinished UnitsOverheadTotal Fixed CostsVariable CostsTotal Variable CostsActivity LevelFixed CostsSupervisionDirect MaterialsDirect LaborDepreciation	Enter a dollar amount		Enter a dollar amount		Enter a dollar amount
Select a budget item Finished UnitsTotal Variable CostsDirect LaborActivity LevelFixed CostsDirect MaterialsDepreciationOverheadTotal Fixed CostsSupervisionTotal CostsVariable Costs	Enter a dollar amount		Enter a dollar amount		Enter a dollar amount
Select a closing name for section one SupervisionTotal Fixed CostsTotal CostsDepreciationActivity LevelDirect MaterialsVariable CostsOverheadFinished UnitsTotal Variable CostsFixed CostsDirect Labor	$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 DepreciationTotal CostsSupervisionOverheadActivity LevelFinished UnitsDirect MaterialsFixed CostsTotal Variable CostsDirect LaborVariable CostsTotal Fixed Costs
Select a budget item Direct LaborTotal Fixed CostsTotal Variable CostsSupervisionOverheadVariable CostsFixed CostsActivity LevelDirect MaterialsTotal CostsFinished UnitsDepreciation	Enter a dollar amount		Enter a dollar amount		Enter a dollar amount
Select a budget item Variable CostsSupervisionTotal Fixed CostsActivity LevelDirect MaterialsDirect LaborFinished UnitsOverheadTotal Variable CostsFixed CostsDepreciationTotal Costs	Enter a dollar amount		Enter a dollar amount		Enter a dollar amount
Select a closing name for section two Finished UnitsDirect MaterialsSupervisionDepreciationActivity LevelOverheadFixed CostsTotal CostsVariable CostsTotal Fixed CostsDirect LaborTotal Variable Costs	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 Activity LevelVariable CostsTotal Variable CostsSupervisionFinished UnitsDirect LaborDirect MaterialsTotal Fixed CostsFixed CostsOverheadTotal CostsDepreciation	$Enter a total dollar amount		$Enter a total dollar amount		$Enter a total dollar amount