4. Change the estimated total amount of the allocation base back to 83,000 machine-hours, so that the data area of you workshe looks exactly the same as in Requirement 2. Now change the actual manufacturing overhead cost from $637,900 to $633,100. TH data area of your worksheet should now look like this: B A 1 Chapter 3: Applying Excel N 3 3 4 5 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 6 Machine-hours $ 655,700 83,000 machine-hours $ 633,100 78,000 machine-hours 7 8 (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead 2. Change all of the numbers in the data area of your worksheet so that it looks like this: B 1 Chapter 3: Applying Excel HNM in N00 $ Data Allocation base Estimated manufacturing overhead cost Estimated total amount of the allocation base 7 Actual manufacturing overhead cost Actual total amount of the allocation base Machine-hours 655,700 83,000 machine-hours 637,900 78,000 machine-hours If your formulas are correct, you should get the correct answers to the following questions. (a) What is the Predetermined overhead rate? (Round your answer to 2 decimal places.) Predetermined overhead rate per machine-hour (b) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead 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 total amount of the allocation base to 79,000 machine-hours, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this: A B 1 Chapter 3: Applying Excel 2 3 Data 4 Allocation base 5 6 Estimated manufacturing overhead cost Estimated total amount of the allocation base Actual manufacturing overhead cost Actual total amount of the allocation base Machine-hours $ 655,700 79,000 machine-hours $ 637.900 78,000 machine-hours 7 8 (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead