Question

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

Atlanta Company is preparing its manufacturing overhead budget for 2017. Relevant data consist of the following. Units to be produced (by quarters): 10,200, 12,100, 15,000, 16,700. 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,280; depreciation $18,600; and maintenance $15,000.

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.)

Homework Answers

Answer #1
ATLANTA COMPANY
Manufacturing Overhead Budget
For the Year Ending December 31, 2017
1 2 3 4 Year
Variable Costs
Indirect Materials 14688 17424 21600 24048 77760
Indirect Labor 21216 25168 31200 34736 112320
Maintenance 9792 11616 14400 16032 51840
Total Variable 45696 54208 67200 74816 241920
Fixed Costs
Supervisory Salaries 36280 36280 36280 36280 145120
Depreciation 18600 18600 18600 18600 74400
Maintenance 15000 15000 15000 15000 60000
Total Fixed 69880 69880 69880 69880 279520
Total Manufacturing Overhead 115576 124088 137080 144696 521440
Direct labor hours 16320 19360 24000 26720 86400
Manufacturing overhead rate per direct labor hour 6.04
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Atlanta Company is preparing its manufacturing overhead budget for 2017. Relevant data consist of the following....
Atlanta Company is preparing its manufacturing overhead budget for 2017. Relevant data consist of the following. Units to be produced (by quarters): 10,400, 12,100, 14,200, 17,000. Direct labor: Time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.70; indirect labor $1.30; and maintenance $0.70. Fixed overhead costs per quarter: supervisory salaries $36,850; depreciation $17,390; and maintenance $14,220. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal...
Chubbs Inc.’s manufacturing overhead budget for the first quarter of 2020 contained the following data. Variable...
Chubbs Inc.’s manufacturing overhead budget for the first quarter of 2020 contained the following data. Variable Costs Fixed Costs Indirect materials $11,200 Supervisory salaries $36,300 Indirect labor 10,200 Depreciation 6,200 Utilities 7,700 Property taxes and insurance 7,100 Maintenance 6,000 Maintenance 4,000 Actual variable costs were indirect materials $14,800, indirect labor $9,300, utilities $9,500, and maintenance $5,200. Actual fixed costs equaled budgeted costs except for property taxes and insurance, which were $9,200. The actual activity level equaled the budgeted level. All...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.30 Indirect materials 0.80 Utilities 0.30 Fixed overhead costs per month are Supervision $4,300, Depreciation $2,000, and Property Taxes $600. The company believes it will normally operate in a range of 6,100–10,000 direct labor hours per month. Assume that in July 2020, Myers Company incurs the following manufacturing overhead costs. Variable Costs Fixed...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.00 Indirect materials 0.90 Utilities 0.40 Fixed overhead costs per month are Supervision $3,700, Depreciation $1,700, and Property Taxes $800. The company believes it will normally operate in a range of 5,700–9,300 direct labor hours per month. Assume that in July 2020, Myers Company incurs the following manufacturing overhead costs. Variable Costs Fixed...
Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press...
Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 13,000 hours of productive capacity in the department: Variable overhead cost:    Indirect factory labor $93,600    Power and light 5,720    Indirect materials 35,100       Total variable overhead cost $134,420 Fixed overhead cost:    Supervisory salaries $47,050    Depreciation of plant and equipment 29,570    Insurance and property taxes 18,820       Total fixed overhead cost 95,440 Total factory...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing...
Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours. Variable manufacturing overhead costs per direct labor hour are as follows. Indirect labor $1.10 Indirect materials 0.60 Utilities 0.40 Fixed overhead costs per month are Supervision $3,900, Depreciation $1,200, and Property Taxes $500. The company believes it will normally operate in a range of 7,400–11,300 direct labor hours per month. Assume that in July 2017, Myers Company incurs the following manufacturing overhead costs. Variable Costs Fixed...
Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press...
Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 11,000 hours of productive capacity in the department: Variable overhead costs:    Indirect factory labor $106,700    Power and light 4,400    Indirect materials 29,700       Total variable overhead cost $140,800 Fixed overhead costs:    Supervisory salaries $49,280    Depreciation of plant and equipment 30,980    Insurance and property taxes 19,710       Total fixed overhead cost 99,970 Total factory...
Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press...
Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 16,000 hours of productive capacity in the department: Variable overhead costs:    Indirect factory labor $152,000    Power and light 7,200    Indirect materials 46,400       Total variable overhead cost $205,600 Fixed overhead costs:    Supervisory salaries $71,960    Depreciation of plant and equipment 45,230    Insurance and property taxes 28,780       Total fixed overhead cost 145,970 Total factory...
Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press...
Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 16,000 hours of productive capacity in the department: Variable overhead costs:    Indirect factory labor $137,600    Power and light 5,600    Indirect materials 35,200       Total variable overhead cost $178,400 Fixed overhead costs:    Supervisory salaries $62,440    Depreciation of plant and equipment 39,250    Insurance and property taxes 24,980       Total fixed overhead cost 126,670 Total factory...
Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press...
Flexible Overhead Budget Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 14,000 hours of productive capacity in the department: Variable overhead costs:    Indirect factory labor $124,600    Power and light 4,900    Indirect materials 46,200       Total variable overhead cost $175,700 Fixed overhead costs:    Supervisory salaries $61,490    Depreciation of plant and equipment 38,650    Insurance and property taxes 24,600       Total fixed overhead cost 124,740 Total factory...