PROJECT OVERVIEVw 2 4 Henkel Industries produces its product in two sequential departments: Blending and Forming. 5 The old controller, who has just retired, has been manually preparing the production cost reports 6 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., 8 when the monthly information is dropped into Data area of the worksheet (the data area is shown 9 as a blue box). The controller has provided you with a basic template, but needs to you finish the 10 spreadsheet by adding formulas and cell references as needed. The only place she ever wants to 11 type in numbers is in the blue box. Although there are two departments, the controller wants you 12 to focus your attention on the Blending department until she is sure that your spreadsheet will 13provide accurate information. 14 15 16 Before you begin to formulate the May spreadsheet, youll need to get production and cost data for the month of May. Some of the information can be found on last month 's manually-prepared production cost report, while other pieces of information can be found in the May general ledger 220,000 units were started during During your In addition the production supervisor has already reported that 18 | May and that 30,000 units were 80% of the way completed at the end of the month. initial plant tour, you found out that all of the direct materials were added at the very beginning of 20 the Blending process 21 22 Once you finish the spreadsheet, the controller has more questions and tasks for you (see the 23 Additional Analysis worksheet after you have completed the May Production Cost Report). 24 25 26 27 28 29 30 31 32 STEP-BY-STEP INSTRUCTIONS 33 1) Fill in the information about units and percentages of completion in the May blue box. FORMAT 34 percentages as percentages (not decimals), 35 36 2) Fill in the cost information in the Mav blue box. (Hint: Gather from PROJECT OVERVIEVw 2 4 Henkel Industries produces its product in two sequential departments: Blending and Forming. 5 The old controller, who has just retired, has been manually preparing the production cost reports 6 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., 8 when the monthly information is dropped into Data area of the worksheet (the data area is shown 9 as a blue box). The controller has provided you with a basic template, but needs to you finish the 10 spreadsheet by adding formulas and cell references as needed. The only place she ever wants to 11 type in numbers is in the blue box. Although there are two departments, the controller wants you 12 to focus your attention on the Blending department until she is sure that your spreadsheet will 13provide accurate information. 14 15 16 Before you begin to formulate the May spreadsheet, youll need to get production and cost data for the month of May. Some of the information can be found on last month 's manually-prepared production cost report, while other pieces of information can be found in the May general ledger 220,000 units were started during During your In addition the production supervisor has already reported that 18 | May and that 30,000 units were 80% of the way completed at the end of the month. initial plant tour, you found out that all of the direct materials were added at the very beginning of 20 the Blending process 21 22 Once you finish the spreadsheet, the controller has more questions and tasks for you (see the 23 Additional Analysis worksheet after you have completed the May Production Cost Report). 24 25 26 27 28 29 30 31 32 STEP-BY-STEP INSTRUCTIONS 33 1) Fill in the information about units and percentages of completion in the May blue box. FORMAT 34 percentages as percentages (not decimals), 35 36 2) Fill in the cost information in the Mav blue box. (Hint: Gather from
