B A 1 Chapter 4: Applying Excel 2 3 Data 4 Allocation base 5 Estimated manufacturing overhead cost 6 Estimated total amount of the allocation base 7 Adual manufacturing overhead cost & Actual total amount of the allocation base Machine hours $300,000 75,000 machine-hours $290,000 68,000 machine-hours ? ? machine-hours ? per machine-hour 10 Enter a fomnule into each of the cells marked with a ? below 11 12 Computation of the predetermined overhead rato 13 Estimated manufacturing overhead cost 14 Estimated total amount of the allocation base 15 Predetermined overhead rate 16 17 Computation of underapplied or ovorapplied manufacturing overhead 13 Actual manufacturing overhead cost 19 Manufacturing overhead cost applied to Work in Process during the year. 20 Predetermined overhead rate 21 Actual total amount of the allocation base Manufacturing overhead applied 23 Underapplied (overapplied) manufacturing overhead * Chapter For Filed in Chapter Form Chapter 4 ? ? per machine-hour ? machine-hours ? 24 1 Required information Chapter 4: Applying Excel The Chapter 4 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. Part 1 of 4 Chapter 4: Applying Excel: Excel Worksheet (Part 1 of 2) 25 points Download the Applying Excel form and enter formulas in all cells that contain question marks. eBook Print References For example, in cell B26 enter the formula "= B17". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the numbers in Review Problem 1. The LIFO inventory flow assumption is used throughout the problem. Check your worksheet by changing the units sold in the Data to 6,000 for Year 2. The cost of goods sold under absorption costing for Year 2 should now be $240,000. If it isn't, check cell C41. The formula in this cell should be =IF(C26