See problem in attached Word document. The results in Excel would be ideal so I can see and duplicate the calculations.

Handout Problem 5-2 Clearwater Paper Company manufactures rolled finished paper. Following is the information relative to the departmental costs and production: Cooking: Costs: Units: Beginning WIP: Direct materials Conversion Costs incurred during June 2010: Direct materials Conversion Beginning WIP Units completed Ending WIP 100% complete for materials 50% complete for conversion $20,000 $20,000 $80,000 $20,000 10,000 60,000 12,000 Coating: Costs: Beginning WIP: Transferred in Direct materials Conversion Costs incurred during June 2010: Transferred in Direct materials Conversion $25,000 $20,000 $4,000 ? $42,000 $6,000 Units: Beginning WIP 10,000 Completed 62,000 Ending WIP: 50% complete for both materials and conversion 1 Drying: Costs: Beginning WIP: Transferred in Direct materials Conversion Cost incurred during June 2010: Transferred in Direct materials Conversion costs Units: $35,000 $0 $25,000 ? $15,000 $30,000 Beginning WIP 15,000 Completed 70,000 Ending WIP: ? 80% for conversion, 0% for direct materials Required: 1. Compute equivalent units for each department. 2. Compute cost per unit for each department. 3. Price out the ending inventories for each department.(Reconciliation) 2