Part The GreenEarth Aluminum Company uses a process cost accounting system to record the costs of manufacturing rolled aluminum. The manufacturing process consists of three processes. The beginning balance of the goods-in-process inventory of one of the processes (the rolling department) on September 1, 2021 and debits to the account for September are summarized below: Beginning balance-5,100 units, 1/3 completed for conversion: Direct materials (5,100 x 38.70) Conversion costs (5,100 x 1/3 x 11.72) Total beginning balance $ 197,370 19,924 217,294 Additional debits during the month: Costs from Smelting Department (162,000 units) Direct Labor Factory Overhead 6,240,000 765,800 1,144,000 During the month of September, the 5,100 units in process at the beginning of the month were completed, and of the 162,000 units entering the department from Smelting, all were completed except 5,400 units that were 4/5 completed for conversion (hint--remember the materials are the items transferred from the Smelting Department). REQUIRED: Using Excel, prepare a Cost of Production Report, and answer the following: 1. Determine the number of units transferred to the next department during September. 2. Compute the EUP for materials and for conversion costs for September. 3. Calculate the unit costs for materials and conversion for September. 4. Determine the amount of costs to be assigned to the units transferred to the next department from the rolling department. 5. Determine the dollar amount of ending W-1-P inventory as of the end of September