Compute the ending inventory using the FIFO and the weighted average method below. These are the same transactions used in week 3 homework: units price 1-Jan Beginning inventory 3,500 $3.00
| There are two problems this week. Click on the tab at the bottom of the spreadsheet to see problem 2. | |||||||||||||
| Compute the ending inventory using the FIFO and the weighted average method below. These are the same transactions used in week 3 homework: | |||||||||||||
| units | price | ||||||||||||
| 1-Jan | Beginning inventory | 3,500 | $ 3.00 | ||||||||||
| 14-Jan | Bought | 1,500 | $ 3.15 | ||||||||||
| 5-Feb | Sold | 1,000 | |||||||||||
| 22-Feb | Bought | 2,000 | $ 3.20 | ||||||||||
| 7-Mar | Sold | 1,500 | |||||||||||
| 15-Mar | Sold | 2,000 | |||||||||||
| 5-Apr | Bought | 1,000 | $ 3.25 | ||||||||||
| 10-Apr | Sold | 800 | |||||||||||
| 12-Apr | Sold | 800 | |||||||||||
| 22-Apr | Sold | 500 | |||||||||||
| 4-May | Sold | 600 | |||||||||||
| 10-May | Bought | 2,000 | $ 3.30 | ||||||||||
| 25-May | Sold | 500 | |||||||||||
| FIFO method (scroll down for Weighted Average entry area) | |||||||||||||
| Purchased | Sold | Balance | |||||||||||
| Date | units | cost | total | units | cost | total | units | cost | total | ||||
| 1-Jan | 3500 | $ 3.00 | $ 10,500.00 | ||||||||||
| Weighted Average Method | |||||||||||||
| Purchased | Sold | Balance | |||||||||||
| Date | units | cost | total | units | cost | total | units | cost | total | ||||
| 1-Jan | 3500 | $ 3.000 | $ 10,500.00 | ||||||||||