In: Accounting
Perpetual Inventory Using LIFO
Beginning inventory, purchases, and sales for Item CZ83 are as follows:
| January 1 | Inventory | 96 units @ $16 | |
| 5 | Sale | 77 units | |
| 11 | Purchase | 107 units @ $20 | |
| 21 | Sale | 90 units |
Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of merchandise sold on January 21 and (b) the inventory on January 31.
| a. Cost of merchandise sold on January 21 | $ |
| b. Inventory on January 31 | $ |
| a. | Cost of Merchandise sold on January 21 | = | $ 1,800 | |||||||
| b. | Inventory on january 31 | = | $ 644 | |||||||
| Workings: | ||||||||||
| Purchases | Cost of goods sold | Inventory on hand | ||||||||
| LIFO | Quantity | Cost per unit | Total cost | Quantity | Cost per unit | Total cost | Quantity | Cost per unit | Total cost | |
| Beginning Balance | 96 | $ 16 | $ 1,536 | |||||||
| Jan-05 | 77 | $ 16 | $ 1,232 | 19 | $ 16 | $ 304 | ||||
| Jan-11 | 107 | $ 20 | $ 2,140 | 19 | $ 16 | $ 304 | ||||
| 107 | $ 20 | $ 2,140 | ||||||||
| Jan-21 | 90 | $ 20 | $ 1,800 | 19 | $ 16 | $ 304 | ||||
| 17 | $ 20 | $ 340 | ||||||||
| Totals | 107 | $ 2,140 | 167 | $ 3,032 | 36 | $ 644 |
If it is helpful, please rate the answer and if any doubt arises let me know