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

$\backslash$table$[[,$A$,$B$,$C$],[1,$Chapter $3$: Applying Excel,,$],[2,,,],[3,$Data,$\backslash$table$[[$Machine$-],[$hours$]],],[4,$Allocation base,$$561,600,],[5,\backslash$table$[[$Estimated manufacturing overhead$],[$cost$]],72,000,\backslash$table$[[$machine$-],[$hours$]]],[7,\backslash$table$[[$Estimated total amount of the$],[$allocation base$]],$$$542,100,],[,\backslash$table$[[$Actual manufacturing overhead$],[$cost$]],73\mathrm{.}000,$machine$-],[,,,]]$

If your formulas are correct, you should get the correct answers to the following questions.

$($a$)$ What is the Predetermined overhead rate?

$($b$)$ By how much is the manufacturing overhead underapplied or overapplied?

$3.$ Either print or make a copy of your worksheet in your workbook before proceeding. You will need to refer back to this worksheet.

Change the estimated amount of the allocation base to $78,000$ machine$-$hours, but keep everything the same as in Requirement $2.$ The data area of your worksheet should now look like this:

$\backslash$table$[[,$A$,$B$,$C$],[1,$Chapter $3$: Applying Excel,,$],[2,,,],[3,$Data,$\backslash$table$[[$Machine$-],[$hours$]],],[4,$Allocation base,$$561,600,],[5,\backslash$table$[[$Estimated manufacturing overhead$],[$cost$]],78,000,\backslash$table$[[$machine$-],[$hours$]]],[7,\backslash$table$[[$Estimated total amount of the$],[$allocation base$]],$$$542,100,],[8,\backslash$table$[[$Actual manufacturing overhead$],[$Cost$]],73\mathrm{.}000,$machine$-],[,$Actual total amount of the,,$]]$

$($a$)$ By how much is the manufacturing overhead underapplied or overapplied?

$($b$)$ Which of the following is NOT a reason why the amount of underapplied $($overapplied$)$ manufacturing overhead is different from Requirement $2$ above?

$4.$ Change the estimated amount of the allocation base back to $72,000$ machine$-$hours, so the data area of you worksheet looks exactly the same as in Requirement $2.$ Now change the actual manufacturing overhead cost from $$542,100$ to $$540,800.$ The data area of your worksheet should now look like this:

$\backslash$table$[[,$A$,$B$,$C$],[1,$Chapter $3$: Applying Excel,,$],[2,,,],[3,$Data,$\backslash$table$[[$Machine$-],[$hours$]],],[4,$Allocation base,$$561,600,],[5,\backslash$table$[[$Estimated manufacturing overhead$],[$cost$]],72,000,\backslash$table$[[$machine$-],[$hours$]]],[7,\backslash$table$[[$Estimated total amount of the$],[$allocation base$]],$$$540,800,],[8,\backslash$table$[[$Actual manufacturing overhead$],[$cost$]],73\mathrm{.}000,$machine$-]]$

$($a$)$ By how much is the manufacturing overhead underapplied or overapplied?

$($b$)$ Why is the underapplied $($overapplied$)$ manufacturing overhead different from Requirement $2$ above?