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

Units to be produced (by quarters): 10,100, 12,300, 14,500, 16,200. Direct labor: Time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.80; indirect labor $1.30; and maintenance $0.70. Fixed overhead costs per quarter: supervisory salaries $38,410; depreciation $19,790; and maintenance $14,080.

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