Chapter 2: 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 Enter a formula into each of the cells marked with a ? below Computation of the predetermined overhead rate Estimated manufacturing overhead cost Machine-hours $300,000 75,000 machine-hours $290,000 68,000 machine-hours 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