In: Accounting
Prepare a Production Cost Report: FIFO Method
(LO 8-2, 4, 5)
Lansing, Inc. provides the following information for one of its department’s operations for June (no new material is added in Department T):
WIP inventory—Department T
Beginning inventory (15,000 units, 60% complete with respect to
Department T costs)
Transferred-in costs (from Department S) $ 116,000
Department T conversion costs 53,150
Current work (35,000 units started)
Prior department costs 280,000
Department T costs 209,050
The ending inventory has 5,000 units, which are 20 percent complete
with respect to Department T costs and 100 percent complete for
prior department costs.
Required
Prepare a production cost report using FIFO.
| Reconciliation of Units (Step 1) | |||||
| % already completed | % completed this period | ||||
| Units | Departments S | Departments T | Departments S | Departments T | |
| Beginning WIP | 15000 | 100% | 60% | 0 | 40% |
| Units introduced | 35000 | ||||
| Total Units to be accounted for | 50000 | ||||
| Completed and Transferred unit | 45000 | 0 | 0 | 100% | 100% |
| Ending WIP | 5000 | 0 | 0 | 100% | 20% |
| Equivalent Units ( Step 20 | |||||
| Department S | Department T | ||||
| Units Transferred | Total Units: | % completed this period | Equivalent Units | % completed this period | Equivalent Units |
| From WIP | 15000 | 0 | 0 | 40% | 6000 |
| From units started / introduced | 30000 | 100% | 30000 | 100% | 30000 |
| TOTAL | 45000 | 30000 | 36000 | ||
| Department S | Department T | ||||
| Ending WIP | Total Units: | % completed this period | Equivalent Units | % completed this period | Equivalent Units |
| TOTAL | 5000 | 100% | 5000 | 20% | 1000 |
| TOTAL EUP | 50000 | 35000 | 37000 | ||
| Cost per Equivalent unit and cost to be accounted for (Step 3) | |||
| Department S | Department T | Total | |
| Cost incurred in current period | 280000 | 209050 | 489050 |
| Total Equivalent Units | 35000 | 37000 | |
| Cost per equivalent units | 8 | 5.65 | |
| Cost of Beginning WIP | 116000 | 53150 | 169150 |
| Total cost to be accounted for | 658200 | ||
| Cost Report (Step 4) | |||||
| Cost of | Units Transferred | 45000 | units | ||
| Equivalent Units | Cost per Equivalent Units | Cost of Units Transferred | Total | ||
| A | From Beginning WIP: | ||||
| Department S | 8 | 0 | |||
| Department T | 6000 | 5.65 | 33900 | 33900 | |
| B | From units started & completed | ||||
| Department S | 30000 | 8 | 240000 | ||
| Department T | 30000 | 5.65 | 169500 | 409500 | |
| C = A + B | 443400 | ||||
| D | Cost of Beginning WIP | 169150 | |||
| E = C + D | Total Cost of Units Transferred | 612550 | |||
| Cost of | Ending WIP | ||||
| Equivalent Units | Cost per Equivalent Units | 5000 | units | ||
| F | Department S | 5000 | 8 | 40000 | |
| G | Department T | 1000 | 5.65 | 5650 | |
| H = F + G | Total Cost of Ending WIP | 45650 | |||
| I = E + H | Total Cost accounted for | 658200 | |||
| J | Rounding Off Differences | 0 | |||
| K = I + J | Total cost to be accounted for [equals to computed in STEP 3] | 658200 | |||