CHECK FIGURES: Conversion: si.27 per EU 4/30 EBWIP S128,097 .Part 1: Prepare acomplete (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 isposted in the Excel folder under Assignments. -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: REQUIREDELEMENTS: You must include the required elements listed below or you will receive a zero on your assignment. Data block page .Production Report with cell referencing from data block page and other parts of the Report NED Your 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. Try including only the data necessary. Let cxcel do the work for you. Include a heading and time period here so you can cell reference these to the report. You 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 dothe work for you. Example format Excel Report Format posted to Blackboard in Assignments Excel folder. There is no data block page example in this report format. You will need to create your own data block format we 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. CclLRefatencing: Use 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 page and cell referenced to any formula in your production report. Do not typsinamy pereantages direstly Heading: Use the following statement heading for your SUPREME MANUFACTURING Mixing Department Production Report For the Month Ended April 30, 2017