In: Accounting
The Lippert Company uses the perpetual inventory system. The following July data are for an item in Lippert's inventory:
| July | 1 | Beginning inventory | 60 | units @ | $11 | per unit |
| 10 | Purchased | 80 | units @ | $12 | per unit | |
| 15 | Sold | 90 | units @ | |||
| 26 | Purchased | 55 | units @ | $13 | per unit |
Calculate the cost of goods sold for the July 15 sale using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods.
Round your final answers to the nearest dollar. For weighted-average cost, do not round the weighted-average unit cost
Cost of goods sold for July 15 sale =
| FIFO | LIFO | Weighted Average | |
| Cost of Goods Sold | $ 1,020 | $ 1,070 | $ 1,041 |
Working
| Units | Cost per unit | value | |
| Beginning Balance | 60 | $ 11.00 | $ 660 |
| Purchases | |||
| 80 | $ 12.00 | $ 960 | |
| Total | 140 | $ 1,620 |
.
| Average Cost of Inventory | ||
| Units | (A) | 140 |
| Total Cost | (B) | $ 1,620 |
| Average Cost | (C=B/A) | $ 11.5714 |
.
| FIFO | ||||
| Total Units Available for sale | 140 | |||
| Units Sold | 90 | |||
| Closing Stock in Units | 50 | |||
| Valuation | ||||
| Ending Inventory | 50 | @ | $ 12.00 | $ 600 |
| 0 | @ | $ 25.00 | $ 0 | |
| Value Of Ending Inventory | $ 600 | |||
| Cost of Goods sold | $ 1,020 | |||
| LIFO | ||||
| Total Units Available for sale | 140 | |||
| Units Sold | 90 | |||
| Closing Stock in Units | 50 | |||
| Valuation | ||||
| Ending Inventory | 50 | @ | $ 11.00 | $ 550 |
| 0 | @ | $ 24.00 | $ 0 | |
| Value Of Ending Inventory | $ 550 | |||
| Cost of Goods sold | 1620 minus 550 | $ 1,070 | ||
| Weighted Average method | ||||
| Total Units Available for sale | 140 | |||
| Units Sold | 90 | |||
| Closing Stock in Units | 50 | |||
| Valuation | ||||
| Ending Inventory | 50 | @ | $ 11.5714 | $ 579 |
| Value Of Ending Inventory | $ 579 | |||
| Cost of Goods sold | (Total Purchase and opening stock Minus Closing Stock) | $ 1,041 | ||