please complete all parts and number 1

QuickBooks File Home Insert Page Layout Formulas Data Review View HelpDYMO Label 017 1 for A B C D E F G H I J 1 E9-11 prepare a manufacturing overhead budget for the year 2 Atlanta Company is preparing its manufacturing overhead budget for 2017. Relevant data 3 consist of the following. K L M Units to be produced (by quarters): 10,000, 12,000, 14,000, 16,000 Direct labor time is 1.5 hour per unit Variable overhead costs per direct labor hour: Indirect materials $0.80; indirect labor $1.20, and maintenance $0.50. Fixed overhead costs per quarter. supervisory salaries $35,000; depreciation $15,000; and maintenance $12,000. 11 12 Instructions 13 Prepare the manufacturing overhead budget for the year, showing quarterly data 14 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". ATLANTA COMPANY Manufacturing Overhead Budget For the Year Ending December 31, 2017 Quarter Year 25 26 27 ? 23 Variable costs 24 Indirect materials ($0.80/hour) Indirect labor ($1.20/hour) Maintenance ($0.50/hour) Total variable 28 Fixed costs 29 Supervisory salaries Value Value Value 30 Depreciation Value Value Value 31 Maintenance Value Value Value Total fxed 17 17 09: 2 9: 469-11 P9-1A P9SA CD Value Value Value 321 Home Insert Page Layout Formulas Data Review View HelpDYMO Label QuickBooks File 017 Year 24 ? ATLANTA COMPANY Manufacturing Overhead Budget For the Year Ending December 31, 2017 Quarter 234 23 Variable costs Indirect materials ($0.80/hour) ? ? ? 25 Indirect labor ($1.20/hour) 26 Maintenance ($0.50/hour) ? Total variable ? ? ? 28 Fixed costs 29 Supervisory salaries Value Value Value Value Depreciation Value Value Value Value 31 Maintenance Value Value Value Value Total fxed 7 7 2 33 Total manufacturing overhead ? ? 30 72 34 Value 1.5 Value 1.5 35 Units to be produced Value Value 36 Direct labor hours per unit 1.5 1.5 37 Total direct labor hours ? 38 39 Manufacturing overhead rate per direct labor hour Assume that the direct labor required per unit changed to 1.75 hour per unit and the variable overhead costs for indirect labor changed to $1.10. Revise the Manufacturing Overhead Budget to reflect these changes. 19: 2 9: 419.11 29.1A P9-5A C09 Ready