Elite Pavers Company manufactures one product using a weighted average process costing system. For the current period:

• Beginning work-in-process (WIP) inventory consisted of 50,000 units with a total cost of $158,000. The $158,000 included materials costs of (use the last 5 digits of your student ID), with the remainder being conversion costs.
• As of the beginning of the period, the beginning WIP units were 35% complete with regard to materials and 25% complete as to conversion costs).
• During the period an additional 200,000 units were started into production and costs added during the period were $560,000 of materials and $225,000 of conversion costs.
• Ending work-in-process consisted of 65,000 units that were 60% complete with regard to materials and 30% complete with regard to conversion costs.

Required

Compute the following, in the spaces indicated in the provided spreadsheet:

1. Compute the number of units completed and transferred out of WIP. (1 point)

2. Compute equivalent units of production for materials and for conversion costs (1 point)

3. Compute the costs per equivalent unit for materials and for conversion costs. (1 point)

4. Assign costs to units completed and transferred out and to units remaining in ending WIP inventory (1 point)

5. Complete the Cost Reconciliation Report presented in the spreadsheet. (1 point)

6. Spreadsheet correctly recomputes when the number of units of beginning WIP is changed

(5 points)

92719 is last 5 digits

B D E F G H 1 ] K L M N o P 1 Compute the number of units completed and transferred out to Finished Goods (1 point) 2 Compute equivalent units of production for materials and for conversion costs (1 point) Materials Conversion Units completed Ending WIP Total 3 Compute the costs per equivalent unit for materials and for conversion costs (1 point) Materials Conversion 4 Assign costs to units completed and transferred to Finished Goods and to units in ending work-in-process (1 point) Units completed and transferred to Finished Goods Ending work-in-process 5 5 1 : 2 3 4 Beginning Work-in-Process 50.000 5 Ending Work-in-Process 65,000 6 Units started during the period 200,000 7 8 completion: Materials Conversion 9 10 11 Beginning Work-in-Process 35 25% 12 Ending Work-in-Process 60% 30% 13 14 Materials Conversion 15 Beginning Work-in-Process $ 92.719 $ 65.281 16 Costs added during the period S 560,000 $ 225,000 17 18 ts of your student number 19 (when you enter student ID in cell C15, an amount will appear in cell D15, 20 such that the sum of cells C15 and D15 equal $158,000. 21 Do not hard code or input a value in D15) 22 23 24 25 2 26 27 29 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 Complete the Cost Reconciliation Report as indicated below (1 point) Costs to be accounted for Cost of beginning WIP Costs added during the period Total Costs to be accounted for Costs accounted for Cost of ending WIP Cost of units transferred out Total costs accounted for 47 49 Sheet1 + 1