In: Accounting
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
| Solution: | |||||||||
| Moving Average cost method - perpetual inventory | |||||||||
| Date | Purchases | Sales | Balance | ||||||
| Unit | Rate | Cost | Unit | Rate | Cost | Unit | Rate | Cost | |
| Nov 1, | 330 | $12 | $3,960 | ||||||
| Nov 15, | 480 | $14 | $6,720 | 810 | $13.19 | $10,680 | |||
| Nov 19, | 610 | $13.19 | $8,046 | 200 | $13.19 | $2,638 | |||
| Nov , 23 | 360 | $16 | $5,760 | 560 | $15 | $8,398 | |||
| Cost of goods sold = $8,046 | |||||||||
| Ending Inventory = $8,398 | |||||||||
| FIFO method - perpetual inventory | |||||||||
| Date | Purchases | Sales | Balance | ||||||
| Unit | Rate | Cost | Unit | Rate | Cost | Unit | Rate | Cost | |
| Nov 1, | 330 | $12 | $3,960 | ||||||
| Nov 15, | 480 | $14 | $6,720 | 330 | $12 | $3,960 | |||
| 480 | $14 | $6,720 | |||||||
| Nov 19, | 330 | $12 | $3,960 | ||||||
| 280 | $14 | $3,920 | 200 | $14 | $2,800 | ||||
| Nov , 23 | 360 | $16 | $5,760 | 200 | $14 | $2,800 | |||
| 360 | $16 | $5,760 | |||||||
| Cost of goods sold = $3,960 + $3,920 = $7,880 | |||||||||
| Ending Inventory = $2,800 + $5,760 = $8,560 | |||||||||
| Please upvote , if found the answer useful. | |||||||||
| For any clarification, Feel free to reach at comment Section |