W W 2 E xcel Template sigment.Chou () Protected View Excel Search File Home Insert Page Layout Formulas Data Review View Help DVMO Label QuickBooks 0 PROTECTED VIEW Bewe e s from the Wernet can contain Viruses. Unless you need to edit, in safe to stay in Protected View Enable Editing F33 X Equivalent Units A B C D 1 E3-11 Compute equivalent units, unit costsand costs assigned 2 The Polishing Department of Major Company has the following production and manufacturing cost data for September 3. Materials are entered at the beginning of the process. Production: Beginning inventory 1,800 units that are 100% complete as to materials and 30% complete as to conversion costs; units started during the period ar 42,900; ending inventory of 5,000 units 10% complete as to conversion costs. Manufacturing costs: Beginning inventory costs, comprised of $20,000 of materials and $43,180 of conversion costs, material costs added in Polishing during the month, $175,800, labor and overhead applied in Polishing during the month, $125,680 and $257,140, respectively, 13 Instructions 14 (a) Compute the equivalent units of production for materials and conversion costs for the month of September. 15 (b) Compute the unit costs for materials and conversion costs for the month 16 (0) Determine the costs to be assigned the units transferred out and in process 17 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?", 21(a) Compute the equivalent units of production for materials and conversion costs for the month of September Physica Units Valve Value Work in process, September 1 Units started into production Value Units transferred out work inre entender T0.7 0.10 CO VALA AutoSave OD R A M Excel TemplateAssignment_Cho3 (1) Protected View Excel Search File Home Insert Page Layout Formulas Data Review View Help DYMO Label QuickBooks PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. F33 f Equivalent Units JK Units transferred out Value Work in process, September 30L Value Equivalent Units Conversion Materials Costs Value Value Value Value Units transferred out Work in process, September 30 41(b) Compute the unit costs for materials and conversion costs for the month. Direct Materials Value Conversion Costs Value Total Work in process, September 1 Costs added to production during September Total costs Value Value 51(c) Determine the costs to be assigned to the units transferred out and in process. Costs accounted for 55 se Transferred out Work in process, September 30 71870-11 C03 Type here to search @elem Home Insert Page Layout Formulas Data Review View HelpDYMO Label QuickBooks ROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View 1 x for equivalent Units Enable Editing Direct Materials Value Conversion Costs Value Total Work in process, September 1 Costs added to production during September Total costs Value Value Value Value (c) Determine the costs to be assigned to the units transferred out and in process. Costs accounted for Transferred out Work in process, September 30 Materials Conversion costs Total costs Value Value OSS SSS 61 After you have completed the requirements of E3-11, consider this additional question 651. Assume that 3,750 units remained in ending work in process and total conversion costs added during September changed to $359,695 66 Show the impact of this change on the calculation of equivalent units, unit cost, and on the cost reconciliation schedule (Round calculation of cost per equivalent units to 3 decimal points) 103.7 03-11C031 u O Type here to search 011 e 09