In: Accounting
|
|
|
Part 1
Available for sale | Cost of goods sold | Ending Inventory | |||||||
Date | Units | Unit cost | Total Cost | Units | Unit cost | Total Cost | Units | Unit Cost | Total Cost |
Nov-01 | 8 | 6.00 | 48.00 | ||||||
Nov-04 | 18 | 6.50 | 117.00 | 8 | 6.00 | 48.00 | |||
18 | 6.50 | 117.00 | |||||||
Nov-07 | 20 | 7.00 | 140.00 | 8 | 6.00 | 48.00 | |||
18 | 6.50 | 117.00 | |||||||
20 | 7.00 | 140.00 | |||||||
Nov-10 | 8 | 6.00 | 48.00 | 18 | 6.50 | 117.00 | |||
20 | 7.00 | 140.00 | |||||||
Nov-12 | 18 | 6.50 | 117.00 | ||||||
12 | 7.00 | 84.00 | 8 | 7.00 | 56.00 | ||||
Total | 249.00 | 8 | 56.00 |
FIFO | |
Cost of goods sold | $249 |
Ending inventory | $56 |
Part 2
Available for sale | Cost of goods sold | Ending Inventory | |||||||
Date | Units | Unit cost | Total Cost | Units | Unit cost | Total Cost | Units | Unit Cost | Total Cost |
Nov-01 | 8 | 6.00 | 48 | ||||||
Nov-04 | 18 | 6.50 | 117.00 | 26 | 6.35 | 165 | |||
Nov-07 | 20 | 7.00 | 140.00 | 46 | 6.63 | 305 | |||
Nov-10 | 8 | 6.63 | 53 | 38 | 6.63 | 252 | |||
Nov-12 | 30 | 6.63 | 199 | 8 | 6.63 | 53 | |||
Total | 252 | 8 | 53 |
Weighted average | |
Cost of goods sold | $252 |
Ending inventory | $53 |