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 |