Green Forest Inc. had the following purchases and sales in October.
| Date | Units | Cost | Total | Sales Price | ||
| Oct 1 | Beginning Balance | 25 | 25 | $625 | ||
| Oct 5 | Purchase | 45 | 28 | $1,260 | ||
| Oct 10 | Purchase | 105 | 29 | $3,045 | ||
| Oct 13 | Sale | 40 | $45 | |||
| Oct 20 | Sale | 65 | $45 | |||
| Oct 23 | Purchase | 65 | 20 | $1,300 | ||
| Oct 30 | Sale | 25 | $45 | |||
Create a perpetual inventory record and calculate the Cost of Goods Sold for the month, Ending inventory balance, and Gross Profit under Weighted Average. Do not round the unit cost. Do round total costs to the nearest cent on each transaction.
| 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 10 | |||||||||
| Oct 13 | |||||||||
| Oct 20 | |||||||||
| Oct 23 | |||||||||
| Oct 30 | |||||||||
End of the month totals:
| Cost of Goods Sold | $ |
| Ending Inventory | $ |
| Gross Profit | $ |