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 +ACCTZOT EXCEL ASSIGNMENT # 1 Spring 2019 REQUIREMENTS :` Part 1 : Prepare a complete ( including cost reconciliation ; FIFO production report using the data from the Problem Data File . Use the Report Format for the structure of the report that is posted in the Excel # 1 folder .* Part 2 : Complete the " What If Analysis" using the What If Analysis Data in the Problem Data File . No Graph is required for this assignment . NOTE : REQUIRED ELEMENTS . You must include the required elements listed below or you will receive a ZERO on your assignment and you will be subject to the*" drop one letter grade " policy at the end of the Semester . Data block page Production Report with cell referencing from data block page and other parts of the Report . Do not type numbers directly into the Report . All amounts must be supported by cell referencing or formulas using cell referencing . GENERAL INFORMATION : Data Block Page !` Four first step is to set up a Data Block page . Most of the given data listed in your* problem should be put in the Data Block , including the percentages of completion . Let excel do the work for you . Include a heading and time period here so you can call reference these to the report . Units Started & Completed :" You will need to calculate the units started and completed either in your data block page of in your production report . You may do it either place . Just be sure to use a formula and cell references to calculate this number so it will recalculate automatically when you do the "What If" portion of the assignment later ( This is your second file ) . Do not calculate the number on your calculator and then type in the result . Again , let excel doCell Referencing : Lise cell references from the data block and from the previously* completed report parts to prepare your production report . All percentages should be in your data block pace and cell referenced to any formula in your production report . In "n't THRIVE In any percentages directly into the production report . Heading . Lise the following statement heading for your report. SCHRADER CELLARS. Fermentation Department Production Report For the Month Ended December 31 , 2018 Be sure your heading does not extend beyond the last column of data so Your report will be centered on the page and your heading will be centered over the report . Label each part of the production report as it is done in the example report format . (If using the report format posted to ED in the Excel & I folder , then most of the formatting and headings have been prepared for You_ You will still need to type in the Company' three* part heading above in the data block and cell reference it to the Report ." SAVING YOUR FILES . Save the original file according to the following name format . Original data File : [ Your Last Name , First Name Initial ; Excel# ! . For Example : Smith Excell* Is or Smith . Excell.*lex ( depending on which version of Microsoft you are Using ] . Save the what if file according to the following name format . Widen the original file and save it under the new following name format ." What If data file : ! Your last name , First name initial ) , EXCEL IF # ! For Example : Smith ExcelIF I.* Is or Smith ! ExcelIF I.*Is* [depending on which version of Microsoft you are usingi . You will be using this file to make changes to the data block Page only . Your report should automatically update for the new data . SUBMISSION INSTRUCTIONS : Put a foster on each page in the bottom right- hand corner which includes Your name and LID`. If you are using the posted report format file then I have already created a faster_ just insert your name and LILY . You will submit both 1 2 ; files to ED . Follow the instructions on ED for submitting, both Your Files . DO NOT CLICK SUBMIT UNTIL YOU HAVE ATTACHED BOTH FILES TO THE BO ASSIGNMENT SITE . You will need to attach one file , then add another file attachment before you submit the excel files to DO . You can click the save button first , then check to be sure both files are listed under " Attached Files . " The original file should contain the following separate sheets within the excel workbook Data Black page with the original problem data 2 . Production Report for Schrader Cellars . ( dated December 3 1, 20181ACCEZOT EXCEL ASSIGNMENT # 1 Spring 2010 REQUIREMENTS :` Part 1 : Prepare a complete (including cost reconciliation ; FIFO production report using the data from the Problem Data File . LIKE the Report Format for the structure of the report that is posted in the Excel # 1 folder .* Part 2 : Complete the " What If Analysis " using the What If Analysis Data in the Problem Data File . NO Graph is required for this assignment . NOTE : REQUIRED ELEMENTS : "I'ou must include the required elements listed below or you will receive & ZERO On Your assignment and you will be subject to the "drop one letter grade " policy at the End of the Semester . Data black page Production Report with cell referencing from data black page and other parts of the Report . DO nat type numbers directly into the Report . All amounts must be supported by cell referencing or formulas using cell referencing* GENERAL INFORMATION : Data Black Pace :` Your first step is to set up a Data Block pace . Most of the given data listed in your* problem should be put in the Data Block , including the percentages of completion . Let excel do the work for you . Include a heading and time period here so you can cell reference these to the report . Inits Started*& Completed :* "I'm will need to calculate the units started and completed either in your data block page or in your production report . You may do it either place . Just be sure to use a formula and cell references to calculate this number so it will recalculate automatically when you do the " What If" portion of the assignment later ! This is your second file ) . Do not* calculate the number on your calculator and then type in the result . Again , let excel do the work for you . Production REGION .` Example format. EXCEL Report Format posted to Blackboard Excel # 1 folder . There is no data block pace example in this report format . You will need to create your own data black format I've will work on this in the excel work sessions ) . Put the entire production* report on one page as is shown in the example Report Format .The what if file should contain the following separate sheets within the excel workbook ! Data black page with the " What If Analysis "data . Production Report for Schrader Cellars ( dated January 31, 2014) Give Your work frequently! DO not be the next person telling horror Stories about lost Walk ! Hack Up Your work on a disk ! Do not fail to do this ! There have been many Students over the Years that have had to redo an Entire assignment because of a lack of' a backup copy of failing to save their work frequently, while they were working on it .Schrader 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 ( grapes ) are added at the beginning of the fermenting process and at the end of the packaging process ( bottles ) . Conversion costs are added evenly throughout cach process . Data from the month of December for the Fermenting Department are below . Beginning work in process inventory* Units in beginning work in process inventory 3, 000 gallons Materials costs $122, 000 Conversion costs $7,000 Percentage complete with respect to materials 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 75% 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 [2ND Excel File!: CHECK FIGURE: 111131119 Total cost transferred out to next d t.: 67 51111 The \"What 11'" part of the assignment will help you detemiine whether you have correctly used cell referencing in your spreadsheets. In your data block page make the following changes: 1. .455\" 5. 6. Beginning inventory for WIP, January 1 is 2,0011 units; 1oo% complete as to material costs and 15% complete as to conversion costs. (This is December 31, 2018 ending inventory om the previous report that you just cmnpleted which becomes January 1, 21119 beginning inventory in this report.) Ending W]? inventory, January 31, 21119 is 3,001} units; 100% complete as to material costs and 211% complete as to conversion costs. Units started into production for January are 1111,0111}. Carryoverthe material and conversion costs assigned to the ending WIP 12131113 {from the previous report} as the beginning [January 21119) WIP inventory costs. Costs added during January are: $510,1J011 for materials and $413,501] for conversion. Chan thedateinthe ' tobe \"For the Month EndedJ 31 21119\". Your 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 dothen you have done the cell referencing incorrectly.) You are only changing the Data Block page