please help fill out these production reports using Weighted Average and FIFO Methods. provide excel formulas, rather than final values. thank you

Henkel Industries produces its product in two sequential departments: Blending and Forming. The old controller, who has just retired, has been manually preparing the production cost reports each month. The new controller would like you, as an intern, to develop an Excel production cost report for the month of MAY that will automatically calculate the cost per equivalent unit, etc., when the monthly information is dropped into Data area of the worksheet (the data area is shown as a blue box). The controller has provided you with a basic template, but needs to you finish the spreadsheet by adding formulas and cell references as needed. The only place she ever wants to type in numbers is in the blue box. Although there are two departments, the controller wants you to focus your attention on the Blending department until she is sure that your spreadsheet will provide accurate information. The controller has asked that you prepare production cost reports under both the Weighted Average Cost Method and the FIFO Method, so that the company can determine how to best assign costs to units produced. Before you begin to formulate the May spreadsheet, you'll need to get production and cost data for the month of May. Some of the information can be found on last month's (April's) manually-prepared production cost report, while other pieces of information can be found in the May general ledger. Ending inventory from April was 100% complete with respect to materials and 60% complete with respect to labor and overhead. In addition, the production supervisor has already reported that 220,000 units were started during May and 35,000 units were still in production, 80% of the way completed at the end of the month. During your initial plant tour, you found out that all of the direct materials were added at the very beginning of the Blending process. Once you finish the spreadsheet, the controller has more questions and tasks for you (see the Additional Analysis worksheet after you have completed the May Production Cost Report under both the Weighted Average and FIFO methods.). EXCEL HINTS " "Copy and pasto" as much as possible rather than typing in nimbers aliss mumbers fropely, eic) Adidisionat mothin Bientine Deal Misatieli inlandirs Carrerseioe Ciome Fimits CattemieniCans? 1 This is a data tab only - no work required on this page! 2 May Journal Entries - Partial list 3) 4 WIP-Blending 5 Raw materials inventory 6 (to record DM traced to the Blending Dept) Henkel Industries produces its product in two sequential departments: Blending and Forming. The old controller, who has just retired, has been manually preparing the production cost reports each month. The new controller would like you, as an intern, to develop an Excel production cost report for the month of MAY that will automatically calculate the cost per equivalent unit, etc., when the monthly information is dropped into Data area of the worksheet (the data area is shown as a blue box). The controller has provided you with a basic template, but needs to you finish the spreadsheet by adding formulas and cell references as needed. The only place she ever wants to type in numbers is in the blue box. Although there are two departments, the controller wants you to focus your attention on the Blending department until she is sure that your spreadsheet will provide accurate information. The controller has asked that you prepare production cost reports under both the Weighted Average Cost Method and the FIFO Method, so that the company can determine how to best assign costs to units produced. Before you begin to formulate the May spreadsheet, you'll need to get production and cost data for the month of May. Some of the information can be found on last month's (April's) manually-prepared production cost report, while other pieces of information can be found in the May general ledger. Ending inventory from April was 100% complete with respect to materials and 60% complete with respect to labor and overhead. In addition, the production supervisor has already reported that 220,000 units were started during May and 35,000 units were still in production, 80% of the way completed at the end of the month. During your initial plant tour, you found out that all of the direct materials were added at the very beginning of the Blending process. Once you finish the spreadsheet, the controller has more questions and tasks for you (see the Additional Analysis worksheet after you have completed the May Production Cost Report under both the Weighted Average and FIFO methods.). EXCEL HINTS " "Copy and pasto" as much as possible rather than typing in nimbers aliss mumbers fropely, eic) Adidisionat mothin Bientine Deal Misatieli inlandirs Carrerseioe Ciome Fimits CattemieniCans? 1 This is a data tab only - no work required on this page! 2 May Journal Entries - Partial list 3) 4 WIP-Blending 5 Raw materials inventory 6 (to record DM traced to the Blending Dept)