Chapter $3$: Applying Excel

Data

Allocation base

Estimated manufacturing overhead cost

$\backslash$table$[[$Machine$-$hours$],[$$$300,000,],[75,000,$machine$-$hours$],[$$$290,000,],[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

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

$?$

$?$ machine$-$hours

$?$ per machine$-$hour

Actual total amount of the allocation base

Manufacturing overhead applied

Underapplied $($overapplied$)$ manufacturing

Chapter $3$: Applying Excel

Data

Allocation base

Estimated manufacturing overhead cost

$\backslash$table$[[$Machine$-$hours$],[$$$300,000$ overhead

$?$ per machine$-$hour

$?$ machine$-$hours

$\backslash$table$[[?$