Tell me what you want to do & Cut Aria 10 A A BE Copy ER Wrap Text General Paste B Format Painter U A Merge & Center Conditional Format as Cel Clipboard Formatting ~ Table . Style Font Alignment Number Styles 24 X fx A B C D E F G Chapter 3: Applying Excel H Data Allocation base Machine-hours Estimated manufacturing overhead cost $300,000 Estimated total amount of the allocation base 75,000 machine-hours Actual manufacturing overhead cost $290,000 Actual total amount of the allocation base 68,000 machine-hours 0 Enter a formula into each of the cells marked with a ? below Computation of the predetermined overhead rate Estimated manufacturing overhead cost $300,000 4 Estimated total amount of the allocation base 75,000 machine-hours 5 Predetermined overhead rate $4.00 per machine-hour 6 7 Computation of underapplied or overapplied manufacturing overhead 8 Actual manufacturing overhead cost $ 290,000 9 Manufacturing overhead cost applied to Work in Process during the year: 10 Predetermined overhead rate $4.00 per machine-hour 21 Actual total amount of the allocation base 68,000 machine-hours 12 Manufacturing overhead applied $ 272,000 $ 18,000 23 Underapplied (overapplied) manufacturing overhead 24 25 26 27 28 29 30 31 Chapter 3 FormRequired information Change the estimated total amount of the allocation base to 60,000 machine-hours, but keep everything the same as F 2 2. The data area of your worksheet should now look like this: A B C 1 Chapter 3: Applying Excel 2 3 Data 4 Allocation base Machine-hours nces 5 Estimated manufacturing overhead cost $ 408,000 6 Estimated total amount of the allocation base 60,000 machine-hours 7 Actual manufacturing overhead cost $ 394,900 8 Actual total amount of the allocation base 61,000 machine-hours (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead Prey 2 of 6 Next >2 Application Assignment i Saved The notion to the shannon in the antimata total am int at Required information 4. Change the estimated total amount of the allocation base back to 68,000 machine-hours, so that the data area of you workshee 2 of 2 looks exactly the same as in Requirement 2. Now change the actual manufacturing overhead cost from $394,900 to $392,600. The data area of your worksheet should now look like this: A B its 1 Chapter 3: Applying Excel 2 eBook 3 Data 4 Allocation base Machine-hours eferences 5 Estimated manufacturing overhead cost $ 408,000 6 Estimated total amount of the allocation base 68,000 machine-hours 7 Actual manufacturing overhead cost $ 392,600 8 Actual total amount of the allocation base 61,000 machine-hours (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead Mc Graw Hill (DOLL Q Search L