This requires you to evaluate and comment on an equivalent units of production (EUP) calculation

need help with this Lab

please show calculations

Part I 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. Process Cost System Template Units to account for: Beginning W-I-P Units Started in production Total units to account for Units accounted for: Transferred to next department Ending W-I-P Total units accounted for Computation of EUP: Materials Conversion Units finished and transferred Work on units in ending W-I-P EUP