Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

2. Change all of the numbers in the data area of your worksheet so that it looks

ID: 2554713 • Letter: 2

Question

2. Change all of the numbers in the data area of your worksheet so that it looks like this: ?? 1 Chapter 2: Applying Excel 4 Allocatlon base Machine-houre 5800,400 5 Eatimated manufacturing overhead co6t ? Estimated total amount of the allocation base 7 Actual manufacturing overhead coet 70maching- houre 5784.300 Actual total amount of the allocation base machine- 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.) 920l per machine- hour redetermined owerhead S b) By how much is the manufacturing overhead underapplied or overapplied? erhead

Explanation / Answer



Answer to Part 1 Estimated Manufacturing Overheads 800400 Estimated total amount of the allocation base 87000 Predetermined Overhead rate (800400/87000) 9.2