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,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 places, e.g. 1.25. List variable expenses before fixed expense.)

ATLANTA COMPANY
Manufacturing Overhead Budget
[Entry field with correct answer]

December 31, 2017
For the Quarter Ending December 31, 2017
For the Year Ending December 31, 2017
Quarter
1
2
3
4
Year
[Entry field with correct answer]

Fixed Costs
Total Pounds Needed for Production
Total Variable
Supervisory Salaries
Desired Ending Materials
Direct Materials Per Unit
Total Manufacturing Overhead
Variable Costs
Direct Materials Purchases
Indirect Materials
Indirect Labor
Units to be Produced
Maintenance
Total Materials Required
Total Fixed
Beginning Direct Materials
Depreciation
[Entry field with correct answer]
    
    Total Manufacturing Overhead
    Variable Costs
    Total Pounds Needed for Production
    Direct Materials Purchases
    Total Fixed
    Total Variable
    Total Materials Required
    Units to be Produced
    Beginning Direct Materials
    Depreciation
    Desired Ending Materials
    Indirect Materials
    Direct Materials Per Unit
    Fixed Costs
    Indirect Labor
    Maintenance
    Supervisory Salaries
$
$
$
$
$
[Entry field with correct answer]
    
    Maintenance
    Indirect Labor
    Fixed Costs
    Total Materials Required
    Total Pounds Needed for Production
    Total Variable
    Direct Materials Per Unit
    Total Manufacturing Overhead
    Beginning Direct Materials
    Indirect Materials
    Desired Ending Materials
    Units to be Produced
    Supervisory Salaries
    Depreciation
    Total Fixed
    Variable Costs
    Direct Materials Purchases
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
    
    Indirect Labor
    Units to be Produced
    Total Variable
    Variable Costs
    Maintenance
    Beginning Direct Materials
    Depreciation
    Supervisory Salaries
    Total Manufacturing Overhead
    Desired Ending Materials
    Total Fixed
    Total Materials Required
    Direct Materials Per Unit
    Total Pounds Needed for Production
    Indirect Materials
    Direct Materials Purchases
    Fixed Costs
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
    
    Total Materials Required
    Total Variable
    Total Pounds Needed for Production
    Fixed Costs
    Units to be Produced
    Variable Costs
    Beginning Direct Materials
    Depreciation
    Desired Ending Materials
    Supervisory Salaries
    Direct Materials Purchases
    Direct Materials Per Unit
    Indirect Labor
    Maintenance
    Indirect Materials
    Total Fixed
    Total Manufacturing Overhead
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]

Total Pounds Needed for Production
Variable Costs
Total Manufacturing Overhead
Fixed Costs
Maintenance
Beginning Direct Materials
Depreciation
Desired Ending Materials
Total Materials Required
Supervisory Salaries
Indirect Labor
Indirect Materials
Total Variable
Total Fixed
Units to be Produced
Direct Materials Per Unit
Direct Materials Purchases
[Entry field with correct answer]
    
    Total Variable
    Maintenance
    Total Fixed
    Total Manufacturing Overhead
    Total Materials Required
    Supervisory Salaries
    Total Pounds Needed for Production
    Units to be Produced
    Variable Costs
    Beginning Direct Materials
    Depreciation
    Desired Ending Materials
    Direct Materials Purchases
    Direct Materials Per Unit
    Fixed Costs
    Indirect Labor
    Indirect Materials
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
    
    Indirect Materials
    Indirect Labor
    Direct Materials Per Unit
    Total Variable
    Total Manufacturing Overhead
    Supervisory Salaries
    Total Materials Required
    Direct Materials Purchases
    Depreciation
    Total Fixed
    Maintenance
    Total Pounds Needed for Production
    Units to be Produced
    Variable Costs
    Desired Ending Materials
    Beginning Direct Materials
    Fixed Costs
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
    
    Fixed Costs
    Depreciation
    Direct Materials Per Unit
    Desired Ending Materials
    Beginning Direct Materials
    Total Manufacturing Overhead
    Direct Materials Purchases
    Indirect Labor
    Total Pounds Needed for Production
    Total Materials Required
    Indirect Materials
    Maintenance
    Supervisory Salaries
    Total Fixed
    Total Variable
    Units to be Produced
    Variable Costs
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
    
    Total Materials Required
    Beginning Direct Materials
    Total Fixed
    Depreciation
    Total Pounds Needed for Production
    Indirect Labor
    Direct Materials Purchases
    Total Variable
    Variable Costs
    Total Manufacturing Overhead
    Fixed Costs
    Supervisory Salaries
    Desired Ending Materials
    Units to be Produced
    Direct Materials Per Unit
    Indirect Materials
    Maintenance
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]

Direct Materials Per Unit
Total Manufacturing Overhead
Total Materials Required
Supervisory Salaries
Indirect Labor
Variable Costs
Depreciation
Desired Ending Materials
Beginning Direct Materials
Total Pounds Needed for Production
Fixed Costs
Total Fixed
Total Variable
Units to be Produced
Maintenance
Direct Materials Purchases
Indirect Materials
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]

Direct labor hours
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
[Entry field with correct answer]
Manufacturing overhead rate per direct labor hour $

Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
1 2 3 4 year
Variable costs
indirect materials 0.7 10920 12705 14910 17850 56385
indirect labor 1.3 20280 23595 27690 33150 104715
maintenance 0.7 10920 12705 14910 17850 56385
total variable 2.7 42120 49005 57510 68850 217485
fixed costs
Supervisory salaries 36,850 36,850 36,850 36,850 147,400
Depreciation 17,390 17,390 17,390 17,390 69,560
maintenance 14,220 14,220 14,220 14,220 56,880
total fixed 68,460 68,460 68,460 68,460 273,840
total manufacturing overhead 110,580 117,465 125,970 137,310 491,325
Direct labor hours 15600 18150 21300 25500 80550
Manufacturing overhead rate 6.10
per direct labor hour
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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,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...
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.70 Utilities 0.20 Fixed overhead costs per month are Supervision $4,100, Depreciation $1,900, and Property Taxes $700. The company believes it will normally operate in a range of 7,300–10,900 direct labor hours per month. Prepare a monthly manufacturing overhead flexible budget for 2017 for the expected range of activity, using...
Bumblebee Company estimates that 379,500 direct labor hours will be worked during the coming year, 2017,...
Bumblebee Company estimates that 379,500 direct labor hours will be worked during the coming year, 2017, in the Packaging Department. On this basis, the budgeted manufacturing overhead cost data are computed for the year. Fixed Overhead Costs Variable Overhead Costs Supervision $94,440 Indirect labor $174,570 Depreciation 73,320 Indirect materials 75,900 Insurance 25,560 Repairs 53,130 Rent 21,120 Utilities 94,875 Property taxes 20,880 Lubricants 37,950 $235,320 $436,425 It is estimated that direct labor hours worked each month will range from 24,900 to...
The Charade Corporation is preparing its Manufacturing Overhead budget for the fourth quarter of the year....
The Charade Corporation is preparing its Manufacturing Overhead budget for the fourth quarter of the year. The budgeted variable manufacturing overhead is $5.00 per direct labor-hour; the budgeted fixed manufacturing overhead is $75,000 per month, of which $15,000 is factory depreciation. If the budgeted cash disbursements for manufacturing overhead for December total $105,000, then the budgeted direct labor-hours for December must be: Multiple Choice 6,000 direct labor-hours 21,000 direct labor-hours 9,000 direct labor-hours 3,000 direct labor-hours The usual starting point...
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...
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 8,000 hours of productive capacity in the department: Variable overhead costs:    Indirect factory labor $78,400    Power and light 2,960    Indirect materials 25,600       Total variable overhead cost $106,960 Fixed overhead costs:    Supervisory salaries $37,440    Depreciation of plant and equipment 23,530    Insurance and property taxes 14,970       Total fixed overhead cost 75,940 Total factory...
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT