please follow steps on first picture. thanks

DIRECTIONS Now that you have completed the production cost report, the controller would like you to do a few more tasks. Use the space at the left to document your responses. 1) Record the journal entry that needs to be made to reflect the units completed and transferred out of the Blending Dept. during the month 2) In addition to the transferred in costs, the Forming Dept. showed the following costs per equivalent unit on their May production cost report: Direct Material Cost/EU = $1.50 Conversion Cost/EU= $0.60 The controller wants to know the cost of making one unit of product in May, from START TO FINISH. Show your calculations by listing each of the costs per EU from all of the departments that make up the total cost. FORMAT the cost per unit in dollars and cents and HIGHLIGHT the total cost per unit (use the spilling paint bucket button to fill in the cell with neon yellow color.) 3) During the month Henkel sold 180,000 of the units it produced during May at a sales price of $30 per unit. Operating expenses for the month totaled $525,000. The controller would like you to prepare a draft of the company's income statement. She would like you to include information about the gross profit per unit, as well as the total for the month. Make sure you format everything in dollars and cents. | ) At the beginning of May, the company had no Finished Goods inventory and no WIP in the Forming Department. All units transferred out of the Blending Dept. in May also made it completely through the Forming Dept. in May. The controller would like you to prepare an analysis of the company's ending WIP and FG inventory at May 31. The controller wants to know the following: a) How many units are in each Department's WIP? b) What is the cost balance for each Department's WIP? c) How many units are in Finished Goods Inventory? d) What is the total cost balance in Finished Goods Inventory? 5) Although the production manager said that the units in WIP at the end of May were 80% of the way through the process, the controller knows that figure is somewhat subjective. She has talked to the assistant production manager, who believes the units were only about 60% complete. She wants you to run your spreadsheet using 60% as the percent of completion to see what impact the estimate has on A) total cost per unit, and B) the company's income statement for the month. If 60% is used as the percentage of completion, would operating income be higher or lower, and by how much? How could managers inflate earnings? IMPORTANT: BEFORE doing this analysis, copy your May production cost report worksheet to a new tab and rename it "What-if 60%?" To do this, right click on the May tab at the bottom of the screen and choose "move or copy" then check the box, "make a copy". Then right click on the new copied spreadsheet and choose "rename". Finally, check the Grading Rubric worksheet to make sure you have completed all requirements. Then save your file and send it to the TA. The subject line of the email should be the same as the file name. 1) Journal entry needed 2) Total cost per unit: 31 Henkel Industries Income Statement For the Month Endin May 31 Per unit Total Units Cost Inventory Analysis WIP. Blending WIP. Forming Finished Goods SA) Total cost per unit SB Income Statement For the Month Ending May 31 Per unit Total Difference in operating income: Increase or Decrease when 60% is used? Briefly explain the reason for the difference. Also, managers want to inflate earnings in a particular period, what can they do? Comien Ruudet Information about it Units in Bening WIP Started Limits in de WIP 25000 220000 10000 Production Cost Baper din Romania HOW OF LIMITS Posial nits AMEL Units for Regin 25000 Started into 220000 Total units to 2450 Percentaje completion Die Cher 100 Units Counter for Cated and transferred MP Total units accounted for 215.000 0005 245.000 2050025 10.00 245.000 205.000 24.000 219.000 S 15 110 78.900 TA PM Samen Corts in Beginning we DM in WP Conversion costs in bering WIP Com information for the current month OM DER DOO ROW OF COSTS Cotton for ch Total cost to account for 11 1.151230 65.000 JOS 101615015 2003 112100 LISAD 120 5 200,00 Cost per equieren 310 C. anni LEP Tochter 129521 23 2202210 157200 1216 LOO 160 MO