Green Forest Inc. had the following purchases and sales in October.
| Date | Units | Cost | Total | Sales Price | ||
| Oct 1 | Beginning Balance | 20 | 29 | $580 | ||
| Oct 5 | Purchase | 45 | 23 | $1,035 | ||
| Oct 10 | Purchase | 90 | 26 | $2,340 | ||
| Oct 13 | Sale | 25 | $55 | |||
| Oct 20 | Sale | 65 | $55 | |||
| Oct 23 | Purchase | 65 | 28 | $1,820 | ||
| Oct 30 | Sale | 25 | $55 | |||
Create a perpetual inventory record and calculate the Cost of Goods Sold for the month, Ending inventory balance, and Gross Profit 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 |
| Oct 1 | |||||||||
| Oct 5 | |||||||||
| Oct 5 | |||||||||
| Oct 5 | |||||||||
| Oct 10 | |||||||||
| Oct 10 | |||||||||
| Oct 10 | |||||||||
| Oct 13 | |||||||||
| Oct 13 | |||||||||
| Oct 13 | |||||||||
| Oct 20 | |||||||||
| Oct 20 | |||||||||
| Oct 20 | |||||||||
| Oct 23 | |||||||||
| Oct 23 | |||||||||
| Oct 23 | |||||||||
| Oct 30 | |||||||||
| Oct 30 | |||||||||
| Oct 30 | |||||||||
End of the month totals:
| Cost of Goods Sold | $ |
| Ending Inventory | $ |
| Gross Profit | $ |