0.57 Question 7 View Policies Show Attempt History Current Attempt in Progress Your answer is partially correct. Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following. Units to be produced (by quarters): 10,600, 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.80; indirect labor $1.30; and maintenance $0.70. Fixed overhead costs per quarter: supervisory salaries $37,020; depreciation $19,700; and maintenance $13,530, 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, 2020 Quarter 1 2 3 Variable Costs Indirect Materials $ 8480 $ 9920 $ 11760 $ Indirect Labor 13780 16120 19110 Maintenance 7420 8680 10290 Total Variable 29680 34720 41160 Fixed Costs Supervisory Salaries 37020 37020 37020 Depreciation 19700 19700 19700 Maintenance 13530 13530 13530 Total Fixed 70250 70250 70250 Total Manufacturing Overhead $ 99930 $ 104970 111410 $ ATLANTA COMPANY Hanufacturing Overhead Budget or the Year Ending December 31, 2020 Quarter 2 3 4 Year 9920 $ 11760 $ 13040 $ 43200 16120 19110 21190 70200 8680 10290 11410 37800 34720 41160 45640 151200 37020 37020 37020 1480880 19700 19700 19700 78800 13530 13530 13530 54120 70250 70250 70250 281000 104970 $ 111410 $ 115890 $ 432200 Variable Costs 9920 $ 8480 $ $ 11760 Indirect Materials 13780 16120 Indirect Labor 19110 7420 8680 Maintenance 10290 Total Variable 29680 34720 41160 Fixed Costs Supervisory Salaries 37020 37020 37020 Depreciation 19700 19700 19700 Maintenance 13530 13530 13530 Total Fixed 4 70250 70250 70250 Total Manufacturing Overhead $ 99930 104970 $ 111410 $ Direct labor hours 16960 19840 23520 Manufacturing overhead rate per direct labor hour 11760 13040 43200 $ A 9920 A 21190 70200 16120 19110 8680 10290 11410 37800 41160 45640 34720 151200 37020 37020 37020 1480880 19700 19700 19700 78800 13530 13530 13530 54120 70250 70250 70250 281000 111410 104970 $ 115890 8 432200 19840 23520 26080 86400 5