The following transactions occurred for the month of May.
| Date | Units | Cost | Total | Sales Price | ||
| 1-May | Beginning Balance | 75 | 14 | $1,050 | ||
| 2-May | Purchase | 85 | 12 | $1,020 | ||
| 3-May | Purchase | 60 | 10 | $600 | ||
| 10-May | Sale | 105 | $30 | |||
| 15-May | Purchase | 45 | 18 | $810 | ||
| 17-May | Sale | 55 | $30 | |||
| 30-May | Sale | 80 | $30 | |||
Create a perpetual inventory record then calculate the Cost of Goods Sold, Ending inventory, and Gross Profit for the month under LIFO
| Purchases | Cost of Goods Sold | Inventory on Hand | |||||||
|---|---|---|---|---|---|---|---|---|---|
| Dates | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost |
| May 1 | |||||||||
| May 2 | |||||||||
| May 2 | |||||||||
| May 2 | |||||||||
| May 3 | |||||||||
| May 3 | |||||||||
| May 3 | |||||||||
| May 10 | |||||||||
| May 10 | |||||||||
| May 10 | |||||||||
| May 15 | |||||||||
| May 15 | |||||||||
| May 15 | |||||||||
| May 17 | |||||||||
| May 17 | |||||||||
| May 17 | |||||||||
| May 30 | |||||||||
| May 30 | |||||||||
| May 30 | |||||||||
End of the month totals
| Cost of Goods Sold | $ |
| Ending Inventory | $ |
| Gross Profit | $ |