please help. I will give a thumbs up i'm so lost.

also, if you could also please explain cell referencing thay would be great.

the highlighted parts of the data block page need to be filled in correctly as well.

i will post the instructions right here in case there is confusion

instructions:

E3 214 ,E, | el * No Spac.. Heading 1 Heading 2 Normal Find Replace Select Titin Dictate Sort Paragraph Styles Editing Voice Sensitivity ORIGINAL PROBLEM DATA (1ST Excel File): CHECK FIGURES: Conversion: $1.27 per EU 8/31/2021 EB WIP $128,097 Supreme Manufacturing was founded over 35 years ago in East Brunswick, NJ. Supreme's Muy Refresco de Tropical line of Horchata, Tamarindo, and Jamaica drinks are lovingly re-created from Latino recipes handed down through the generations. The Muy Refresco de Tropical line uses only natural cinnamon, vanilla, rice, tamarind root, and hibiscus flower, and is sweetened only ith all-natural cane sugar. A long-time cultural favorite, the popularity of Horchata, Tamarindo, and Jamaicas has exploded in recent years. This is due to both the general market's exposure to aguas frescas, and the rapid growth of the Latino market's population and buying power. The U.S. Latino population is currently growing faster than the general market with growth of 43% over the last 10 years-or 16.3% of the entire U.S. population. Along with this growth, a new awareness of the potential health dangers of processed, sugary foods has emerged across all markets. Muy Refresco de Tropical's natural ingredients and real cane sugar mean they're free of fat, cholesterol, caffeine, lactose, and gluten. Supreme's Horchata, Tamarindo, and Jamaica: a naturally delicious, healthier alternative to today's sugary sodas. Each flavor is available in 64 fl. oz. bottles and sold for $12 each. The first stage in the production process is carried out in the Mixing Department, which removes foreign matter from the raw materials and mixes them in the proper proportions in large vats. The company uses the FIFO method in its process costing system. Production data for the month of August appears below: Production data: Focus m 64F 11:14 PM 10/572021 WHAT IF ANALYSIS DATA (2ND Excel File): CHECK FIGURE: Material: $2.98 per EU 09/30/2021 Total cost transferred out to next dept.: $948,526 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, September 1 is 40,000 units; 75% complete as to material costs and 75% complete as to conversion costs. (This is August 31, 2021 ending inventory from the previous report which becomes September 1, 2021 beginning inventory in this report.) 2. Ending WIP inventory, September 30, 2021 is 20,000 units; 80% complete as to material costs and 75% complete as to conversion costs. 3. Units started into production for September are 200,000. 4. Carryover the material and conversion costs assigned to the ending WIP 8/31/2021 (from the August report) as the beginning WIP inventory prior period costs. (Material Costs $90,000 and Conversion Costs: $38,097.) 5. Costs added during September are: $613,880 for materials and S274,300 for conversion 6. Change the date in the heading to be "For the Month Ended September 30, 2021". 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 do then you have done the cell referencing incorrectly.) You are only changing the Data Block page. B D F Prior Period Percent Materials Conversion 90% 80%? Current Period Percent Materials Conversion ? 30,000 200,000 A 1 Data Block: 2 3 SUPREME MANUFACTURING 4 Mixing Department Production Report 5 FIFO Cost Processing 6 For the Month Ended August 31, 2021 7 8 Production data: 9 Units in process, beginning 10 Units started into production 11 Units completed & transferred 12 Units in process, ending 13 14 15 16 17 Cost data: 18 Work in process inventory, beginning 19 20 Cost added during month: 21 22 40,000 100% 75% 100% 75% Materials Conversion $ 67,800 $ 30,200 $ 579,000 $ 248,900 2 3 B D E F G H Type Company Name Here or link from Data Block Type Name of Report Here or link from Data Block 4 Type which process costing method is being used or link from Data Block Type Time Period Report Covers Here or link from Data Block 6 7 Quantity Schedule and Equivalent Units 8 9 Quantity 10 Schedule 11 Units to be accounted for: 12 Work in process, beginning 13 Started into production 14 Total units 15 Equivalent Units (EU) 17 Materials Conversion 18 Units accounted for as follows: 19 Transferred to packaging: 20 From beginning inventory 21 Started & completed this month Data Block Production Report 16 + B F H C D E F G Equivalent Units (EU) Materials Conversion 20 16 17 18 Units accounted for as follows: 19 Transferred to packaging: From beginning inventory 21 Started & completed this month 22 Work in process, ending 23 Total units and equivalent 24 units of production 25 26 Costs per Equivalent Unit 27 28 29 Work in process, beginning 30 Cost added by the department 31 Total cost 32 33 Equivalent units of production 34 Cost per equivalent unit Total Cost Materials Conversion Whole Unit Equivalent Units (above) Materials Conversion Total Cost 36 Cost Reconciliation 37 38 39 Cost accounted for as follows: 40 Transferred to packaging: 41 From the beginning inventory: 42 Cost in the beginning inventory 43 Cost to complete these units: 44 Materials 45 Conversion 46 Total cost 47 Started and completed this month 48 Total cost transferred 49 Work in process, ending: 50 Materials 51 Conversion 52 Total work in process 53 Total cost accounted for 54 55 EXCEL ASSIGNMENT #1 REQUIREMENTS: Part 1: Prepare a complete (including cost reconciliation) FIFO production report using the data from the Problem Data File. Use the Report Format template file 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: The data block page has been mostly set up for you in the template file. You will need to complete it for a couple numbers and percentages. Most of the given data listed in your data problem file should already be input in the Data Block of the template file. Let excel do the work for you. You can cell reference the company name, title of the report, report method, and the time period the report covers to the report on the second sheet within the workbook (the Production Report)