Partl 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 in April, 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 by the company accountant as follows: Equivalent Units of Production for April-Blending Dept. To process units started and completed in April (17,800 - 4,200) 13,600 To process units in inventory at April 30 (6,400 x 3/5) 3,840 Equivalent Units of Production for April 17,440 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: 1. Using Excel, compute the number of physical units to be accounted for during the period and show how those physical units are accounted for. 2. 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 Process Cost System Template 4 3 Units to account for: Beginning W-I-P 5 Units Started in production Total units to account for 5 7 9 a Units accounted for: Transferred to next department 10 Ending W-I-P Total units accounted for 12 13 14 Materials Conversion 15 Computation of EUP: 16 17 Units finished and transferred 10 Work on units in ending W-I-P 19 EUP 20