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 $38 | $380 | 
| Aug. 7 | Purchase | 20 | units at $39 | 780 | 
| Dec. 11 | Purchase | 14 | units at $41 | 574 | 
| 44 | units | $1,734 | ||
There are 20 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).
| a. | First-in, first-out (FIFO) | |
| b. | Last-in, first-out (LIFO) | |
| c. | Weighted average cost | 
| Ans. a | Periodic FIFO: | ||||
| Date | Units | Rate | Total | ||
| 11-Dec | 14 | $41.00 | $574 | ||
| 7-Aug | 6 | $39.00 | $234 | ||
| Ending inventory | 20 | $808 | |||
| *In FIFO method the units that have purchased first, are released the first one and the ending inventory | |||||
| units remain from the last purchases. | |||||
| Ans. b | Periodic LIFO: | ||||
| Date | Units | Rate | Total | ||
| 1-Jan | 10 | $38.00 | $380 | ||
| 7-Aug | 10 | $39.00 | $390 | ||
| Ending inventory | 20 | $770 | |||
| *In LIFO method the units that have purchased last, are released the first one and ending inventory units | |||||
| remain from the first purchase. | |||||
| Ans. C | Available for sale | ||||
| Date | Units | Rate | Total | ||
| 1-Jan | 10 | $38.00 | $380 | ||
| 7-Aug | 20 | $39.00 | $780 | ||
| 11-Dec | 14 | $41.00 | $574 | ||
| Cost of goods available for sale | 44 | $1,734 | |||
| Weighted average cost: | |||||
| Average cost per unit = Total cost of goods available for sale / Total units available | |||||
| $1,734 / 44 | |||||
| $39.41 | per unit | ||||
| Ending inventory = Average cost per unit * Ending inventory units | |||||
| $39.41 * 20 | |||||
| $788 | |||||