Tell me what you want to do & Cut Aria 10 A A BE Copy ER Wrap Text General Paste B Format Painter U A Merge & Center Conditional Format as Cel Clipboard Formatting ~ Table . Style Font Alignment Number Styles 24 X fx A B C D E F G Chapter 3: Applying Excel H Data Allocation base Machine-hours Estimated manufacturing overhead cost $300,000 Estimated total amount of the allocation base 75,000 machine-hours Actual manufacturing overhead cost $290,000 Actual total amount of the allocation base 68,000 machine-hours 0 Enter a formula into each of the cells marked with a ? below Computation of the predetermined overhead rate Estimated manufacturing overhead cost $300,000 4 Estimated total amount of the allocation base 75,000 machine-hours 5 Predetermined overhead rate $4.00 per machine-hour 6 7 Computation of underapplied or overapplied manufacturing overhead 8 Actual manufacturing overhead cost $ 290,000 9 Manufacturing overhead cost applied to Work in Process during the year: 10 Predetermined overhead rate $4.00 per machine-hour 21 Actual total amount of the allocation base 68,000 machine-hours 12 Manufacturing overhead applied $ 272,000 $ 18,000 23 Underapplied (overapplied) manufacturing overhead 24 25 26 27 28 29 30 31 Chapter 3 Form2 Chapter 3: Applying Excel: Exercise (Part 2 of 2) 2. Change all of the numbers in the data area of your worksheet so that it looks like this: art 2 of 2 A B C 1 Chapter 3: Applying Excel 2 ints 3 Data 1 Allocation base Machine-hours 5 eBook Estimated manufacturing overhead cost $ 408,000 6 Estimated total amount of the allocation base 68,000 machine-hours References Actual manufacturing overhead cost 69 394,900 8 Actual total amount of the allocation base 61,000 | machine-hours If your formulas are correct, you should get the correct answers to the following questions. (a) What is the Predetermined overhead rate? (Round your answer to 2 decimal places.) Predetermined overhead rate per machine-hour Mc 2 Next > Graw