Exercise 23-11

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

Units to be produced (by quarters): 10,700, 12,400, 14,700, 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.70. Fixed overhead costs per quarter: supervisory salaries $37,280; depreciation $18,330; and maintenance $13,020.

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, 2017 For the Quarter Ending December 31, 2017 December 31, 2017 Quarter 1 2 3 4 Year Supervisory Salaries Desired Ending Materials Variable Costs Indirect Labor Depreciation Total Variable Direct Materials Per Unit Beginning Direct Materials Total Manufacturing Overhead Indirect Materials Direct Materials Purchases Total Fixed Fixed Costs Units to be Produced Maintenance Total Materials Required Total Pounds Needed for Production Indirect Materials Desired Ending Materials Total Manufacturing Overhead Maintenance Supervisory Salaries Total Variable Total Fixed Direct Materials Purchases Direct Materials Per Unit Depreciation Total Materials Required Total Pounds Needed for Production Units to be Produced Fixed Costs Variable Costs Beginning Direct Materials Indirect Labor $ $ $ $ $ Units to be Produced Fixed Costs Variable Costs Total Variable Direct Materials Per Unit Direct Materials Purchases Indirect Materials Total Pounds Needed for Production Beginning Direct Materials Maintenance Supervisory Salaries Indirect Labor Depreciation Desired Ending Materials Total Manufacturing Overhead Total Fixed Total Materials Required Direct Materials Purchases Fixed Costs Units to be Produced Supervisory Salaries Direct Materials Per Unit Depreciation Total Fixed Indirect Labor Variable Costs Maintenance Total Manufacturing Overhead Total Variable Indirect Materials Beginning Direct Materials Total Materials Required Desired Ending Materials Total Pounds Needed for Production Total Fixed Units to be Produced Desired Ending Materials Total Pounds Needed for Production Total Materials Required Beginning Direct Materials Total Manufacturing Overhead Fixed Costs Depreciation Variable Costs Indirect Labor Direct Materials Purchases Direct Materials Per Unit Indirect Materials Total Variable Maintenance Supervisory Salaries Depreciation Total Materials Required Beginning Direct Materials Total Manufacturing Overhead Maintenance Direct Materials Purchases Desired Ending Materials Indirect Materials Indirect Labor Total Fixed Total Pounds Needed for Production Supervisory Salaries Units to be Produced Total Variable Variable Costs Direct Materials Per Unit Fixed Costs Depreciation Variable Costs Fixed Costs Desired Ending Materials Maintenance Direct Materials Purchases Total Manufacturing Overhead Direct Materials Per Unit Total Materials Required Indirect Labor Indirect Materials Supervisory Salaries Total Fixed Total Variable Units to be Produced Total Pounds Needed for Production Beginning Direct Materials Beginning Direct Materials Depreciation Direct Materials Per Unit Supervisory Salaries Desired Ending Materials Variable Costs Total Materials Required Total Pounds Needed for Production Total Manufacturing Overhead Direct Materials Purchases Fixed Costs Total Variable Total Fixed Units to be Produced Indirect Labor Indirect Materials Maintenance Maintenance Beginning Direct Materials Total Pounds Needed for Production Supervisory Salaries Depreciation Fixed Costs Desired Ending Materials Total Fixed Indirect Labor Variable Costs Direct Materials Per Unit Indirect Materials Total Manufacturing Overhead Total Materials Required Total Variable Units to be Produced Direct Materials Purchases Total Fixed Supervisory Salaries Indirect Materials Units to be Produced Variable Costs Total Variable Total Pounds Needed for Production Total Manufacturing Overhead Desired Ending Materials Depreciation Total Materials Required Fixed Costs Maintenance Beginning Direct Materials Direct Materials Per Unit Direct Materials Purchases Indirect Labor Supervisory Salaries Total Fixed Indirect Labor Total Pounds Needed for Production Total Variable Total Manufacturing Overhead Total Materials Required Fixed Costs Desired Ending Materials Units to be Produced Maintenance Indirect Materials Variable Costs Depreciation Direct Materials Per Unit Beginning Direct Materials Direct Materials Purchases $ $ $ $ $ Direct labor hours Manufacturing overhead rate per direct labor hour $

LINK TO TEXT

Question Attempts: Unlimited SAVE FOR LATER SUBMIT ANSWER