WHAT IF ANALYSIS DATA ( Z ~` Excel File ) . CHECK FIGURE: [1/31/19 Total cost transferred out to next dept.: $674.500 The "What If" part of the assignment will help you determine whether you have correctly used cell referencing in your spreadsheets . In your data block page make the following changes : 1 . Beginning inventory for WIP , January I is 2, 000 units ; 100%' complete as to material costs and 75%/ complete as to conversion costs . (' This is December 3 1 , 2018 ending inventory from the previous report that you just completed which becomes January 1 , 2019 beginning inventory in this report . ) Ending WIP inventory , January 31 , 2019 is 3, 000 units ; 100% complete as to material costs and 20'" complete as to conversion costs . 3 . Units started into production for January are 10, 000 . Carryover the material and conversion costs assigned to the ending WIP 12 /31 / 18 ( from the previous report ; as the beginning ( January 2019) WIP inventory costs . Costs added during January are : $510, 0.00 for materials and $40, 500 for Conversion . Change the date in the heading to be*" For the Month Ended January 31 , 2019 * Four spreadsheets should automatically recalculate using the new data . You should not have to change any of the cell references or formulas for either of your statements . ( If you do_ then you have done the cell referencing incorrectly . ) You are only changing the Data Block page .E F H Dala BLOCK ! Company Hame* Name of Department Date \\Production dale :" 10 1 1 12 13 14 15 16\\ Goal dale ! IT 18 10 75 Data Block Production Report +Quantity schedule and Equivalent Units Quantity Schedule Units to be accounted for: Work in process, Beginning 3.000 Started into production 5,000 Total units 8.000 Equivalent Units (EU) Materials Conversion Units accounted for as follows: Transferred to packing. From beginning inventory 3.000 1,500 Started & completed this month 3,000 3.000 3.000 Work in process, Ending 2.000 2.000 1,500 Total units and Equivalents units of production 8.000 5.000 6.000 Costs per Equivalent Unit Total costs Materials Conversion Whole units Work in process, Beginning $129,000 Cost added by the department $280.000 $250.000 $30.000 Total cost $409 000 Equivalents units of production 5,000 6.000 cost per equivalent unit $50 $5 Costs Reconciliation Equivalent Units (EU) Total cost Materials Conversion Costs accounted for as follows: Transferred to packing From beginning inventory. Cost in the beginning inventory Cost to complete these units $129,000 $122,000 $7,000 Material SO Conversion $7,500 $7,500 Total costs $136,500 Started and completed this month $165,000 $150.000 $15,000 Total costs transferred $301,500 Work in process, Ending Material $100,000 $100.000 Conversion $7,500 $7,500 Total work in process $107,500 Total cost accounted for $409,000