Question
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,
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 $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started