In: Accounting
Jordana Woolens is a manufacturer of wool cloth. The information for March is as follows:
| Beginning work in process | 10,000 units | 
| Units started | 20,000 units | 
| Units completed | 25,000 units | 
|  |  | 
| Beginning work-in-process direct materials | $ 6,000 | 
| Beginning work-in-process conversion | $ 2,600 | 
| Direct materials added during month | $30,000 | 
| Direct manufacturing labor during month | $12,000 | 
| Factory overhead | $ 5,000 | 
Beginning work in process was 50% complete for conversion cost and 100% complete for DM. All conversion costs are incurred evenly throughout the process. Ending work in process was 60% complete for Conversion cost and 100% complete for DM.
Required: Prepare a production cost worksheet using the FIFO method.
My format of answer maybe diferent than what you have
Solution
| Cost report [Including Reconciliation] | |||||
| Cost of | Units Transferred | 25,000.00 | units | ||
| Equivalent Units [Step 2] | Cost per Equivalent Units [Step 3] | Cost of Units Transferred | TOTAL | ||
| A | From Beginning WIP: | ||||
| Material | - | $ 1.50 | $ 0 | ||
| Conversion | 5,000 | $ 0.74 | $ 3,696 | $ 3,696 | |
| B | From units started & completed | ||||
| Material | 15,000 | $ 1.50 | $ 22,500 | ||
| Conversion | 15,000 | $ 0.74 | $ 11,087 | $ 33,587 | |
| C=A+B | Total | $ 37,283 | |||
| D | Cost of Beginning WIP | $ 8,600 | |||
| E=C+D | Total Cost of Units transferred | $ 45,883 | |||
| Cost of | Ending WIP | 5,000.00 | units | ||
| Equivalent Units [Step 2] | Cost per Equivalent Units [Step 3] | Cost of Ending WIP | TOTAL | ||
| F | Material | 5,000 | $ 1.50 | $ 7,500 | |
| G | Conversion | 3,000 | $ 0.74 | $ 2,217 | |
| H = F + G | Total Cost of Ending WIP | $ 9,717 | |||
| I = E + H | Total Cost accounted for | $ 55,600 | |||
| J | Rounding Off Differences | $ 0 | |||
| K = I + J | Total cost to be accounted for [equals to computed in STEP 3] | $ 55,600 | 
Working
| STEP 1 (FIFO) | |||||
| Reconciliation of Units | |||||
| Units | % already completed | % completed this period | |||
| Material | Conversion | Material | Conversion | ||
| Beginning WIP | 10,000 | 100% | 50% | 0% | 50% | 
| Units introduced | 20,000 | ||||
| Total units to be accounted for | 30,000 | ||||
| Completed and Transferred unit | 25,000 | 0% | 0% | 100% | 100% | 
| Ending WIP | 5,000 | 0% | 0% | 100% | 60% | 
| STEP 2 (FIFO) | |||||
| Equivalent Units | |||||
| Total Units | Material | Conversion | |||
| Units Transferred: | % completed this period | Equivalent Units | % completed this period | Equivalent Units | |
| From WIP | 10,000 | 0% | - | 50% | 5,000 | 
| From units started/Introduced | 15,000 | 100% | 15,000 | 100% | 15,000 | 
| Total | 25,000 | 15,000 | 20,000 | ||
| Total Units | Material | Conversion | |||
| Ending WIP | % completed this period | Equivalent Units | % completed this period | Equivalent Units | |
| Total | 5,000 | 100% | 5,000 | 60% | 3,000 | 
| Total EUP | 30,000 | 20,000 | 23,000 | 
| STEP 3 | |||
| Cost per Equivalent Units AND Cost to be accounted for | |||
| Material | Conversion | TOTAL | |
| Cost incurred in Current Period | $ 30,000 | $ 17,000 | $ 47,000 | 
| Total Equivalent Units | 20,000 | 23,000 | |
| Cost per Equivalent Units | $ 1.50 | $ 0.74 | $ 2.24 | 
| Cost of Beginning WIP | $ 8,600 | ||
| Total cost to be accounted for | $ 55,600 |