art l 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 goods-in- process inventory of one of the processes (the rolling department) on September 1, 2018 and debits to the account for September are summarized below Beginning balance-5,100 units, 1/3 completed: 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 (hint-remember the materials are the items transferred from the REQUIRED: Using Excel complete 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-I-P inventory as of the end of September Part Il Gougem Oil Company processes gasoline. At April 1 of the current year 4,200 units were 2/3 completed in the Blending Department. During April, 20,000 units were transferred into the Blending Department from the Refining Department. During April the units in process at the beginning of the month were completed. Of the 20,000 units entering the department, all were completed except 6,400 units that were 2/5 completed. The equivalent units for conversion costs for April for the Blending Department was computed as follows: Equivalent Units of Production for April-Blending Dept. To process units started and completed in April (17,800-4,200) To process units in inventory at April 30 (6,400 x 3/5) Equivalent Units of Production for April 13,600 3,840 1244 The CEO has become aware that you are taking a managerial accounting course and would like you to review the work done by the Gougem staff in computing EUP. Please complete the following Using Excel, compute the number of physical units to be accounted for during the period and show how those physical units are accounted for Using Excel, list any errors that you find in the calculation of EUP shown above. If no errors are found write "no errors". If you find any errors prepare a corrected computation of EUP showing all work. Be sure to include your name on your Excel document 1. 2