80.2K

Verified Solution

Link Copied!

2. Change all of the numbers in the data area of your worksheet so that it looks like this: A B C 1 Chapter 3: Applying Excel 2 3 Data 4 Allocation base Machine-hours + 5 Estimated manufacturing overhead cost $ 396,800 67 Estimated total amount of the allocation base 7 Actual manufacturing overhead cost $ 385,200 8 Actual total amount of the allocation base 64,000 machine-hours 63,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 Change the estimated total amount of the allocation base to 62,000 machine-hours, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this: A 1 Chapter 3: Applying Excel B C 2 3 Data 4 Allocation base Machine-hours 5 Estimated manufacturing overhead cost $ 396,800 6 Estimated total amount of the allocation base 7 Actual manufacturing overhead cost $ 385,200 B Actual total amount of the allocation base 62,000 machine-hours 63,000 machine-hours: (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead 4. Change the estimated total amount of the allocation base back to 64,000 machine-hours, so that the data area of you worksheet looks exactly the same as in Requirement 2. Now change the actual manufacturing overhead cost from $385,200 to $391,400. The data area of your worksheet should now look like this: A Chapter 3: Applying Excel 1 2 3 Data 4 Allocation base 5 Estimated manufacturing overhead cost 6 Estimated total amount of the allocation base 7 Actual manufacturing overhead cost B Actual total amount of the allocation base B C Machine-hours 396,800 64,000 machine-hours $ 391,400 63,000 machine-hours (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead

Answer & Explanation Solved by verified expert

See Answer