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? (Round your answer to 2 decimal places.)

(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 total amount of the allocation base to 91,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?

2. Change all of the numbers in the data area of your worksheet so that it looks like this: B A A 1 Chapter 3: Applying Excel 2 3 3 Data 4 Allocation base 5 Estimated manufacturing overhead cost 6 Estimated tatalanunt of the allocation base 7 Actual manufacturing overhead cost 8 Actualtatal amount of the allocation base 4. Change the estimated total amount of the allocation base back to 98,000 machine-hours, so that the data area of you worksheet looks exectly the same as in Requirement 2 Now chenge the actuel manufacturing overheed cost from $908 800 to $904700 The data area of your worksheet should now look like this: C Machine-hours $ 891,800 99,000 machine hours $ 800,000 100,000 machine-hours 1 Chapter 3: Applying Excel 1 2 2 3 Data 4 Allocation base 5 Estimated manufacturing overhead cost 6 Estiraled total amount of the allocation base 7 Actual manufactura overhead cout 7 8 Actual total amount of the allocation base Machno-hours $ 891 800 90,000 machine louis $ 904,700 100,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.) redetermine anthrad rate per machine-hour la) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead (b) By how much is the manufacturing overhead underappiled or overappiled? manufacturing overhead 3. Either print or make a copy of your worksheet in your workbook before proceeding. You will need to refer beck to this worksheet Change the estimated lotal amount or the allocation base to 91000 machine-hours, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this: C A 1 Chapter 3: Applying Excel 1 2 3 Data 4 Alocation base 5 5 Estimated manuriacturing overhead cast 6 Estimated lotal amount of the allocation base 7 7 Actual manufacturing overhead cost 8 Actuallolalaround of the localion base Machine-hours S S 091 ADO 91 000 tracines s 900,800 100.000 tracin (al By how much is the manufacturing overhead underappiled or overapplled? lacturing overhead