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 | ||||||||||
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
