Chapter 3: Applying Excel Data Allocation base Estimated manufacturing overhead cost Estimated total amount of the allocation base Actual manufacturing overhead cost Actual total amount of the allocation base Machine-hours $300,000 $290,000 machine-hours 68,000 machine-hours Req. 1: Enter 60,000 machine hours in the estimated total amount of the allocation base cell in the data section at the left. If your formulas are correct the predetermined overhead rate should now be $5.00 per machine-hour. If not, go back to the formulas page, make corrections, press the copy formulas button, and recheck your answers until they are correct. When correct, answer the questions below. How much is the underapplied or overapplied manufacturing overhead? Computation of the predetermined overhead rate Estimated manufacturing overhead cost Estimated total amount of the allocation base Predetermined overhead rate Computation of underapplied or overapplied manufacturing overhead Actual manufacturing overhead cost Manufacturing overhead cost applied to Work in Process during the year: Predetermined overhead rate Actual total amount of the allocation base Manufacturing overhead applied Underapplied (overapplied) manufacturing overhead machine-hours per machine-hour per machine-hour machine-hours Did it change? Why or why not?