Chapter $3$: Applying Excel

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

Enter a formula into each of the cells marked with a $?$ below

Computation of the predetermined overhead rate

Estimated manufacturing overhead cost $?$

Estimated total amount of the allocation base $?$ machine$-$hours

Predetermined overhead rate $?$ per machine$-$hour

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 $?$ per machine$-$hour

Actual total amount of the allocation base $?$ machine$-$hours

Manufacturing overhead applied $?$

Underapplied $($overapplied$)$ manufacturing overhead $?$