Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following.

Units to be produced (by quarters): 10,100, 12,900, 14,700, 16,500.

Direct labor: Time is 1.6 hours per unit.

Variable overhead costs per direct labor hour: indirect materials $0.90; indirect labor $1.30; and maintenance $0.60.

Fixed overhead costs per quarter: supervisory salaries $36,450; depreciation $17,160; and maintenance $14,110.

Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal places, e.g. 1.25. List variable expenses before fixed expense.)

ATLANTA COMPANY Manufacturing Overhead Budget For the Year Ending December 31, 2020December 31, 2020For the Quarter Ending December 31, 2020
	Quarter
		1		2		3		4		Year
Indirect LaborIndirect MaterialsDirect Materials PurchasesTotal FixedBeginning Direct MaterialsDesired Ending MaterialsDepreciationTotal Pounds Needed for ProductionSupervisory SalariesMaintenanceDirect Materials Per UnitTotal VariableUnits to be ProducedFixed CostsVariable CostsTotal Materials RequiredTotal Manufacturing Overhead
DepreciationTotal VariableBeginning Direct MaterialsMaintenanceDesired Ending MaterialsUnits to be ProducedTotal Pounds Needed for ProductionSupervisory SalariesFixed CostsIndirect LaborDirect Materials PurchasesDirect Materials Per UnitTotal FixedTotal Manufacturing OverheadTotal Materials RequiredIndirect MaterialsVariable Costs		$		$		$		$		$
DepreciationTotal VariableDesired Ending MaterialsTotal FixedFixed CostsMaintenanceDirect Materials PurchasesUnits to be ProducedDirect Materials Per UnitTotal Manufacturing OverheadIndirect LaborIndirect MaterialsSupervisory SalariesBeginning Direct MaterialsVariable CostsTotal Materials RequiredTotal Pounds Needed for Production
Total Pounds Needed for ProductionTotal Manufacturing OverheadFixed CostsDirect Materials PurchasesUnits to be ProducedDepreciationMaintenanceIndirect LaborIndirect MaterialsBeginning Direct MaterialsDirect Materials Per UnitDesired Ending MaterialsTotal VariableTotal FixedSupervisory SalariesVariable CostsTotal Materials Required
Total Pounds Needed for ProductionDepreciationIndirect LaborFixed CostsDirect Materials Per UnitBeginning Direct MaterialsTotal VariableUnits to be ProducedIndirect MaterialsMaintenanceVariable CostsTotal Manufacturing OverheadSupervisory SalariesDirect Materials PurchasesTotal Materials RequiredTotal FixedDesired Ending Materials
MaintenanceIndirect LaborUnits to be ProducedSupervisory SalariesBeginning Direct MaterialsIndirect MaterialsVariable CostsDepreciationDirect Materials PurchasesTotal Pounds Needed for ProductionFixed CostsTotal FixedTotal Materials RequiredTotal Manufacturing OverheadDirect Materials Per UnitDesired Ending MaterialsTotal Variable
Direct Materials PurchasesTotal FixedTotal VariableTotal Materials RequiredDepreciationIndirect LaborDirect Materials Per UnitBeginning Direct MaterialsMaintenanceTotal Manufacturing OverheadSupervisory SalariesFixed CostsVariable CostsDesired Ending MaterialsUnits to be ProducedIndirect MaterialsTotal Pounds Needed for Production
Variable CostsDepreciationIndirect LaborTotal VariableSupervisory SalariesUnits to be ProducedMaintenanceDesired Ending MaterialsDirect Materials PurchasesTotal Manufacturing OverheadTotal Pounds Needed for ProductionIndirect MaterialsBeginning Direct MaterialsFixed CostsTotal Materials RequiredTotal FixedDirect Materials Per Unit
DepreciationTotal VariableUnits to be ProducedIndirect LaborIndirect MaterialsTotal Materials RequiredMaintenanceSupervisory SalariesDirect Materials PurchasesVariable CostsTotal Pounds Needed for ProductionDesired Ending MaterialsDirect Materials Per UnitBeginning Direct MaterialsFixed CostsTotal FixedTotal Manufacturing Overhead
Units to be ProducedTotal FixedFixed CostsDirect Materials Per UnitTotal Pounds Needed for ProductionMaintenanceTotal VariableTotal Manufacturing OverheadDirect Materials PurchasesIndirect MaterialsDepreciationIndirect LaborDesired Ending MaterialsBeginning Direct MaterialsVariable CostsSupervisory SalariesTotal Materials Required
Total Materials RequiredFixed CostsIndirect MaterialsTotal Pounds Needed for ProductionDirect Materials Per UnitUnits to be ProducedDesired Ending MaterialsDirect Materials PurchasesTotal VariableBeginning Direct MaterialsVariable CostsTotal FixedIndirect LaborMaintenanceTotal Manufacturing OverheadSupervisory SalariesDepreciation		$		$		$		$		$
Direct labor hours
Manufacturing overhead rate per direct labor hour										$

eTextbook and Media

Save for Later

Attempts: 0 of 3 used

Submit Answer