Change all of the numbers in the data area of your worksheet so that it looks like this:

If your formulas are correct, you should get the correct answers to the following questions.
(a) What is the predetermined overhead rate?
Predetermined overhead rate ______________ per machine-hour
(b) By how much is the manufacturing overhead under applied or over applied?
Manufacturing overhead

Transcribed Image Text:

A 1 Chapter 3: Applying Excel 3 Data 4 Allocation base Machine-hours 5 Estimated manufacturing overhead cost $210,000 machine- hours 6 Estimated total amount of the allocation base 42,000 7 Actual manufacturing overhead cost $212,700 machine- hours 8 Actual total amount of the allocation base 35,000 9.