In: Accounting
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods
The units of an item available for sale during the year were as follows:
Jan. 1 | Inventory | 10 | units at $26 | $260 |
Aug. 7 | Purchase | 15 | units at $28 | 420 |
Dec. 11 | Purchase | 10 | units at $29 | 290 |
35 | units | $970 |
There are 16 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out (FIFO) method; (b) the last-in, first-out (LIFO) method; and (c) the weighted average cost method (round per unit cost to two decimal places and your final answer to the nearest whole dollar).
FIFO | ||||
Date | Particulars | Units | Cost per Unit | Total Cost |
Jan 1 | Beginning Inventory | 10 | 26.0 | 260 |
Aug 7 | Purchase | 15 | 28 | 420 |
Dec 11 | Purchase | 10 | 29.00 | 290 |
Cost of Goods Available for Sale | 35 | 970 | ||
Less: Ending Inventory (10*29+6*28) | 16 | 458 | ||
Cost of Goods Sold | 19 | 512 | ||
LIFO (Periodic) | ||||
Date | Particulars | Units | Cost per Unit | Total Cost |
Jan 1 | Beginning Inventory | 10 | 26.0 | 260 |
Aug 7 | Purchase | 15 | 28 | 420 |
Dec 11 | Purchase | 10 | 29.00 | 290 |
Cost of Goods Available for Sale | 35 | 970 | ||
Less: Ending Inventory (10*26+6*28) | 16 | 428 | ||
Cost of Goods Sold | 19 | 542 | ||
Average Cost method | ||||
Date | Particulars | Units | Cost per Unit | Total Cost |
Jan 1 | Beginning Inventory | 10 | 26.0 | 260 |
Aug 7 | Purchase | 15 | 28 | 420 |
Dec 11 | Purchase | 10 | 29.00 | 290 |
Cost of Goods Available for Sale | 35 | 970 | ||
Less: Ending Inventory | 16 | 27.714 | 443 | |
Cost of Goods Sold | 19 | 527 |