Hello! Can somebody please help me with this? Thank you in advance I really appreciate it.
SCHRADER CELLARS ORIGINAL PROBLEM DATA ( IST Excel File )* CHECK FIGURES . Conversion : $5. 10 per FIT 12/31 Ending Balance WHIP $107. 5010Schrader Cellars uses the FIFO method in its two department process costing system! " Fermenting ( grape sorting is part of the fermentation process ) and Packaging . Direct materials [rapes ) are added at the beginning of the fermenting process and at the end of the packaging* process ( bottles ) . Conversion costs are added evenly throughout each process . Data from the month of December for the Fermenting Department are below . Beginning work in process inventory* [Inits in beginning work in process inventory 3,000 gallons Materials costs $122, 000 Conversion costs $7, 000 Percentage complete with respect to materials 10.0 %/} Percentage complete with respect to conversion [Inits started into production during the month 5,000 gallons Materials costs added during the month $250.000 Conversion costs added during the month $30. 000 Ending work in process inventory* [Inits in ending work in process 2,000 gallons Percentage complete with respect to materials 10.0%/} Percentage complete with respect to conversion REQUIRED . 1 . Prepare a FIFO production report for the Fermentation Department for Schrader Cellars for the month ended December 31 , 2018 .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 +C II Quantity Schedule and Equivalent Units Quantity Schedule 10 Units to be accounted for: 11 Work in process, beginning 12 Started into production 13 Total units 14 15 Equivalent Units (EU) 16 Materials Conversion 17 Units accounted for as follows: 18 Transferred to packaging: 19 From beginning inventory 20 Started & completed this month 21 Work in process, ending 22 Total units and equivalent 23 units of production 24 25 Costs per Equivalent Unit 26 27 Total Cost Materials Conversion Whole Unit 28 Work in process, beginning 29 Cost added by the department 30 Total cost 31 32 Equivalent units of production 33 Cost per equivalent unit 34 35 Cost Reconciliation 36 Equivalent Units (above) 37 Total Cost Materials Conversion 38 Cost accounted for as follows: 39 Transferred to packaging: From the beginning inventory: Cost in the beginning inventory Cost to complete these units Materials Conversion 45 Total cost 46 Started and completed this month 47 Total cost transferred 48 Work in process, ending 49 Materials 50 Conversion 51 Total work in process 52 Total cost accounted for Data Block Production Report +