In: Accounting
During July, the following costs were incurred:
Materials (30,000 units) $24,900
Labour and overheads $20,075
At the beginning of July, there were 15,000 units of work in
progress valued as follows:
Materials (100% complete) $9,000
Labour and overheads (40% complete) $1,250
At the end of July, there were 5,000 units of work-in-progress.
They were 100% complete for materials
and 50% complete for labour and overheads.
Using both FIFO approach and Weighted Average approach:
(a) calculate how many units were completed during July
(b) calculate the cost per unit
(c) value the finished items and the closing work-in-progress
(d) prepare a Process Account. (Note: assume no losses)
Solution - FIFO Approach:
a.
| Computation of Equivalent unit (FIFO) | |||
| Particulars | Physical units | Material | Conversion |
| Units to be accounted for: | |||
| Beginning WIP Inventory | 15000 | ||
| Units started this period | 30000 | ||
| Total unit to be accounted for | 45000 | ||
| Units Accounted for: | |||
| Units completed and transferred out | |||
| From beginning inventory Material - 0% Conversion - 60% |
15000 | 0 | 9000 |
| Started and completed currently | 25000 | 25000 | 25000 |
| Units in ending WIP Material - 100% Conversion - 50% |
5000 | 5000 | 2500 |
| Total units accounted for | 45000 | 30000 | 36500 |
b.
| Computation of Cost per Equivalent unit | |||
| Particulars | Total cost | Material | Conversion |
| Current period cost | $44,975.00 | $24,900.00 | $20,075.00 |
| Equivalent units | 30000 | 36500 | |
| Cost per equivalent unit | $0.83 | $0.55 | |
c.
| Producton cost report - FIFO | |||
| Particulars | Total cost | Material | Conversion |
| Cost Accounted for : | |||
| Cost assigned to unit transferred out: | |||
| Cost from beginning WIP Inventory | $10,250 | $9,000 | $1,250 |
| Current cost added to complete beginning WIP: | |||
| Material | $0 | $0 | |
| Conversion (9000 * $0.55) | $4,950 | $4,950 | |
| Total Cost from beginning inventory | $15,200 | $9,000 | $6,200 |
| Current cost of unit started and completed: | |||
| Material (25000*$0.83) | $20,750 | $20,750 | |
| Conversion (25000*$0.55) | $13,750 | $13,750 | |
| Total cost of unit started and completed | $34,500 | $20,750 | $13,750 |
| Total cost of unit transferred out | $49,700 | $29,750 | $19,950 |
| Cost assigned to ending WIP: | |||
| Material (5000*$0.83) | $4,150 | $4,150 | |
| Conversion (2500*$0.55) | $1,375 | $1,375 | |
| Total ending WIP inventory | $5,525 | $4,150 | $1,375 |
| Total cost accounted for | $55,225 | $33,900 | $21,325 |
Value of finished items = $49,700
Value of closing WIP = $5,525
d.
| Work In Process Accounts | |||
| Particulars | Debit | Particulars | Credit |
| Beginning balance | $10,250.00 | Completed units | $49,700.00 |
| Direct material | $24,900.00 | Ending balance | $5,525.00 |
| Labor and overhead | $20,075.00 | ||
| Total | $55,225.00 | Total | $55,225.00 |
Solution - Weighted Average Approach:
a.
| Computation of Equivalent unit of Production - Weighted Average | |||
| Particulars | Physical Units | Material | Conversion (Labor + Overhead) |
| Unit completed & Transferred out | 40000 | 40000 | 40000 |
| Closing WIP: | 5000 | ||
| Material (100%) | 5000 | ||
| Conversion (50%) | 2500 | ||
| Equivalent units of production | 45000 | 45000 | 42500 |
b.
| Computation of Cost per equivalent unit of Production - Weighted Average | ||
| Particulars | Material | Conversion (Labor + Overhead) |
| Opening WIP | $9,000.00 | $1,250.00 |
| Cost Added during period | $24,900.00 | $20,075.00 |
| Total cost to be accounted for | $33,900.00 | $21,325.00 |
| Equivalent units of production | 45000 | 42500 |
| Cost per Equivalent unit | $0.7533 | $0.5018 |
c.
| Computation of Cost of ending WIP and units completed & transferred out - Weighted Average | |||
| Particulars | Material | Conversion (Labor + Overhead) | Total |
| Equivalent unit of Ending WIP | 5000 | 2500 | |
| Cost per equivalent unit | $0.7533 | $0.5018 | |
| Cost of Ending WIP (Equivalent unit * Cost per equivalent unit) | $3,767 | $1,254 | $5,021 |
| Units completed and transferred | 40000 | 40000 | |
| Cost of units completed & Transferred (Unit completed * cost per equivalent unit) | $30,133 | $20,071 | $50,204 |
Value of finished items = $50,204
Value of closing WIP = $5,021
d.
| Work In Process Accounts | |||
| Particulars | Debit | Particulars | Credit |
| Beginning balance | $10,250.00 | Completed units | $50,204.00 |
| Direct material | $24,900.00 | Ending balance | $5,021.00 |
| Labor and overhead | $20,075.00 | ||
| Total | $55,225.00 | Total | $55,225.00 |