LIFO Method | |||||||||
Date | Purchase | Cost of Goods Sold | Inventory | ||||||
Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | |
Jan.1 | 4000 | 40 | 160000 | ||||||
Apr. 19 | 2500 | 40 | 100000 | 1500 | 40 | 60000 | |||
Jun. 20 | 4500 | 44 | 198000 | 1500 | 40 | 60000 | |||
4500 | 44 | 198000 | |||||||
Sep. 2 | 500 | 40 | 20000 | ||||||
4500 | 44 | 198000 | 1000 | 40 | 40000 | ||||
No. 15 | 2000 | 46 | 92000 | 1000 | 40 | 40000 | |||
2000 | 46 | 92000 | |||||||
Dec. 31 | 290000 | 318000 | 132000 | ||||||
FIFO Method | |||||||||
Date | Purchase | Cost of Goods Sold | Inventory | ||||||
Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | |
Jan.1 | 4000 | 40 | 160000 | ||||||
Apr. 19 | 2500 | 40 | 100000 | 1500 | 40 | 60000 | |||
Jun. 20 | 4500 | 44 | 198000 | 1500 | 40 | 60000 | |||
4500 | 44 | 198000 | |||||||
Sep. 2 | 1500 | 40 | 60000 | ||||||
3500 | 44 | 154000 | 1000 | 44 | 44000 | ||||
No. 15 | 2000 | 46 | 92000 | 1000 | 44 | 44000 | |||
2000 | 46 | 92000 | |||||||
Dec. 31 | 290000 | 314000 | 136000 | ||||||
Weighted Average Cost Method | |||||||||
Date | Purchase | Cost of Goods Sold | Inventory | ||||||
Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | |
Jan.1 | 4000 | 40 | 160000 | ||||||
Apr. 19 | 2500 | 40 | 100000 | 1500 | 40 | 60000 | |||
Jun. 20 | 4500 | 44 | 198000 | 6000 | 43 | 258000 | |||
Sep. 2 | 5000 | 43 | 215000 | 1000 | 43 | 43000 | |||
No. 15 | 2000 | 46 | 92000 | 3000 | 45 | 135000 | |||
Dec. 31 | 290000 | 315000 | 135000 |
Perpetual Investory ng LIED 200 4,500 5,000 2,000 145 The tim p ul investory wym the...