In: Accounting
Zippy Shoe Co. uses a periodic inventory system. Zippy purchased 415 pairs of shoes at $71 each in June, 980 pairs in August at $73 each, and 640 pairs in December at $76 each. Zippy sold 1,895 pairs of shoes during the year.
Required: Calculate the company's ending inventory and cost of goods sold using the each of following inventory costing methods.
FIFO
LIFO
Weighted Average
Solution:
| FIFO | LIFO | Weighted average | |
| Cost of goods sold | $139,005 | $139,705 | $139,349.40 |
| Cost of Ending inventory | $10,640 | $9,940 | $10,295.60 |
Workings:
| Units | Cost per unit | Value | |
| Beginning Balance | $0 | ||
| Purchases | |||
| 415 | $71 | $29,465 | |
| 980 | $73 | $71,540 | |
| 640 | $76 | $48,640 | |
| Total | 2,035 | $149,645 |
.
| Average Cost of Inventory | ||
| Units | (A) | 2,035 |
| Total Cost | (B) | $149,645 |
| Average Cost | (C=B/A) | $73.54 |
| FIFO | ||||
| Total Units Available for sale | 2,035 | |||
| Units Sold | 1,895 | |||
| Closing Stock in Units | 140 | |||
| Value of Ending Inventory | 140 | @ | $76 | $10,640 |
| Cost of Goods sold | Purchase + Opening Stock - Closing Stock | $149,645 - $10,640 | $139,005 | |
| LIFO | ||||
| Total Units Available for sale | 2,035 | |||
| Units Sold | 1,895 | |||
| Closing Stock in Units | 140 | |||
| Vale of Ending Inventory | 140 | @ | $71 | $9,940 |
| Cost of Goods sold | Purchase + Opening Stock - Closing Stock | $149,645 - $9,940 | $139,705 | |
| Weighted Average method | ||||
| Total Units Available for sale | 2,035 | |||
| Units Sold | 1,895 | |||
| Closing Stock in Units | 140 | |||
| Value of Ending Inventory | 140 | @ | $73.54 | $10,295.60 |
| Cost of Goods sold | Purchase + Opening Stock - Closing Stock = $149,645-$10,295.60 | $139,349.40 |
Please rate positive and comment in case of any doubt. I would be happy to help you further.