One data set, five answers
A distributor of commercial ceiling fans has this activity during a year:
| Date | Event | Units | Unit cost |
|---|---|---|---|
| January 1 | On hand | 1,000 | 40 |
| March 10 | Purchase | 3,000 | 44 |
| May 22 | Sale | 3,500 | |
| August 4 | Purchase | 3,000 | 50 |
| November 15 | Sale | 2,500 |
Goods available cost 322,000 for 7,000 units (40,000 + 132,000 + 150,000), and 1,000 units remain at year end.
| Method | Ending inventory | Cost of goods sold |
|---|---|---|
| FIFO, either system | 1,000 x 50 = 50,000 | 272,000 |
| Moving average, perpetual | 1,000 x 49 = 49,000 | 273,000 |
| Weighted average, periodic | 1,000 x 46 = 46,000 | 276,000 |
| LIFO, perpetual | 500 x 40 + 500 x 50 = 45,000 | 277,000 |
| LIFO, periodic | 1,000 x 40 = 40,000 | 282,000 |
Workings:
- Weighted average: 322,000 / 7,000 = 46 a unit.
- Moving average: after March, 4,000 units cost 172,000, or 43 each. The May sale leaves 500 units costing 21,500. August adds 3,000 units, giving 3,500 units costing 171,500, or 49 each.
- Perpetual LIFO: the May sale takes all 3,000 March units and 500 January units, leaving 500 at 40. The November sale takes 2,500 August units, leaving 500 at 50.
- Periodic LIFO: the 1,000 units left are costed from the oldest layer, the January units at 40.