Green Forest Inc. had the following purchases and sales in October.
| Date | Units | Cost | Total | Sales Price | ||
| Oct 1 | Beginning Balance | 30 | 23 | $690 | ||
| Oct 5 | Purchase | 50 | 28 | $1,400 | ||
| Oct 10 | Purchase | 95 | 24 | $2,280 | ||
| Oct 13 | Sale | 50 | $55 | |||
| Oct 20 | Sale | 45 | $55 | |||
| Oct 23 | Purchase | 65 | 22 | $1,430 | ||
| Oct 30 | Sale | 45 | $55 | |||
Create a perpetual inventory record and calculate the Cost of Goods Sold for the month, Ending inventory balance, and Gross Profit under FIFO.
| 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 | $ |