Prepare the manufacturing overhead budget for the year

Reference no: EM13582973

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

Units to be produced (by quarters): 10,900, 12,800, 14,200, 16,300.

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,720; depreciation $18,980; and maintenance $14,220.

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, 2014
	Quarter
	1	2	3	4	Year
Beginning Direct MaterialsDepreciationDesired Ending MaterialsDirect Materials Per UnitDirect Materials PurchasesFixed CostsIndirect LaborIndirect MaterialsMaintenanceSupervisory SalariesTotal FixedTotal Manufacturing OverheadTotal Materials RequiredTotal Pounds Needed for ProductionTotal VariableUnits to be ProducedVariable Costs
Beginning Direct MaterialsDepreciationDesired Ending MaterialsDirect Materials Per UnitDirect Materials PurchasesFixed CostsIndirect LaborIndirect MaterialsMaintenanceSupervisory SalariesTotal FixedTotal Manufacturing OverheadTotal Materials RequiredTotal Pounds Needed for ProductionTotal VariableUnits to be ProducedVariable Costs	$	$	$	$	$
Beginning Direct MaterialsDepreciationDesired Ending MaterialsDirect Materials Per UnitDirect Materials PurchasesFixed CostsIndirect LaborIndirect MaterialsMaintenanceSupervisory SalariesTotal FixedTotal Manufacturing OverheadTotal Materials RequiredTotal Pounds Needed for ProductionTotal VariableUnits to be ProducedVariable Costs
Beginning Direct MaterialsDepreciationDesired Ending MaterialsDirect Materials Per UnitDirect Materials PurchasesFixed CostsIndirect LaborIndirect MaterialsMaintenanceSupervisory SalariesTotal FixedTotal Manufacturing OverheadTotal Materials RequiredTotal Pounds Needed for ProductionTotal VariableUnits to be ProducedVariable Costs
Beginning Direct MaterialsDepreciationDesired Ending MaterialsDirect Materials Per UnitDirect Materials PurchasesFixed CostsIndirect LaborIndirect MaterialsMaintenanceSupervisory SalariesTotal FixedTotal Manufacturing OverheadTotal Materials RequiredTotal Pounds Needed for ProductionTotal VariableUnits to be ProducedVariable Costs
Beginning Direct MaterialsDepreciationDesired Ending MaterialsDirect Materials Per UnitDirect Materials PurchasesFixed CostsIndirect LaborIndirect MaterialsMaintenanceSupervisory SalariesTotal FixedTotal Manufacturing OverheadTotal Materials RequiredTotal Pounds Needed for ProductionTotal VariableUnits to be ProducedVariable Costs
Beginning Direct MaterialsDepreciationDesired Ending MaterialsDirect Materials Per UnitDirect Materials PurchasesFixed CostsIndirect LaborIndirect MaterialsMaintenanceSupervisory SalariesTotal FixedTotal Manufacturing OverheadTotal Materials RequiredTotal Pounds Needed for ProductionTotal VariableUnits to be ProducedVariable Costs
Beginning Direct MaterialsDepreciationDesired Ending MaterialsDirect Materials Per UnitDirect Materials PurchasesFixed CostsIndirect LaborIndirect MaterialsMaintenanceSupervisory SalariesTotal FixedTotal Manufacturing OverheadTotal Materials RequiredTotal Pounds Needed for ProductionTotal VariableUnits to be ProducedVariable Costs
Beginning Direct MaterialsDepreciationDesired Ending MaterialsDirect Materials Per UnitDirect Materials PurchasesFixed CostsIndirect LaborIndirect MaterialsMaintenanceSupervisory SalariesTotal FixedTotal Manufacturing OverheadTotal Materials RequiredTotal Pounds Needed for ProductionTotal VariableUnits to be ProducedVariable Costs
Beginning Direct MaterialsDepreciationDesired Ending MaterialsDirect Materials Per UnitDirect Materials PurchasesFixed CostsIndirect LaborIndirect MaterialsMaintenanceSupervisory SalariesTotal FixedTotal Manufacturing OverheadTotal Materials RequiredTotal Pounds Needed for ProductionTotal VariableUnits to be ProducedVariable Costs
Beginning Direct MaterialsDepreciationDesired Ending MaterialsDirect Materials Per UnitDirect Materials PurchasesFixed CostsIndirect LaborIndirect MaterialsMaintenanceSupervisory SalariesTotal FixedTotal Manufacturing OverheadTotal Materials RequiredTotal Pounds Needed for ProductionTotal VariableUnits to be ProducedVariable Costs	$	$	$	$	$

Direct labor hours
Manufacturing overhead rate per direct labor hour					$

Reference no: EM13582973

Questions Cloud

Brummitt corporation is working on its direct labor budget : brummitt corporation is working on its direct labor budget for the next two months. each unit of output requires 0.05

The amount at of atmospheric pollutants in a certain : the amount at of atmospheric pollutants in a certain mountain valley grown according to a natural growth model in such

Outdoor livings management is starting a continuous : outdoor livings management is starting a continuous inprovement policy that requires a 10 reduction in standard costs

Why separate the traceable fixed costs from the common : why separate the traceable fixed costs from the common fixed costs? what is meant by a traceable fixed cost of a

Prepare the manufacturing overhead budget for the year : atlanta company is preparing its manufacturing overhead budget for 2014. relevant data consist of the following.units

Consider the cascade of two 300l tanks shown in the figure : consider the cascade of two 300l tanks shown in the figure below. suppose that tank 1 initially contains 300litres of

Hannon corporation produces high-performance rotors it : 1 mussatto corporation produces snowboards. the following per unit cost information is available direct materials 16

However the drivers skid marks at the accident scene : a driver involved in an accident claims he was going only 42 mph. when police tested his car they found that when his

Prepare an incremental analysis for the special order round : leno company manufactures toasters. for the first 8 months of 2014 the company reported the following operating results

User Account

All Pages