The PVC Company manufactures a high-quality plastic pipe that goes through three processing stages prior to completion.
Information on work in the first department, Cooking, is given below for May:
Pounds in process, May 1: materials
100% complete; conversion 90% complete 82,000
Pounds started into production during May 470,000
Pounds completed and transferred to
the next department ?
Pounds in process, May 31:
materials 70% complete; conversion 30% complete 42,000
Work in process inventory, May 1:
Materials cost $ 152,300
Conversion cost $ 52,300
Cost added during May:
Materials cost $ 791,650
Conversion cost $ 287,390
The company uses the weighted-average method.
1. Compute the equivalent units of production.
Equivalent units of production
2. Compute the costs per equivalent unit for the month. (Round your answers to 2 decimal places. Omit the "$" sign in your response.)
Cost per equivalent unit $
3. Determine the cost of ending work in process inventory and of the units transferred out to the next department. (Omit the "$" sign in your response.)
Materials Conversion Total
Cost of ending work in process inventory $
Cost of units completed and transferred out $
4. Prepare a cost reconciliation report for the month. (Omit the "$" sign in your response.)
Costs to be accounted for:
Cost of beginning work in process inventory $
Cost added to production during the period
Total cost to be accounted for $
Costs accounted for as follows:
Costs of ending work in process inventory $
Costs of units completed and transferred out
Total cost accounted for $
Your tutorial is attached in Excel. Click in cells to see computations. This is now a template that you can use for similar problems.