Chapter $3$: Applying Excel: Exercise $($Part $2$ of $2)$

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

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 $77,000$ machine$-$hours, but keep everything the same as in Requirement $2.$ The data area of your worksheet should now look like this:

$($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 $78,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 $$591,000$ to $$593,600.$ The data area of your worksheet should now look like this:

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

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