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 | 4 | units at $31 | $124 |
| Aug. 7 | Purchase | 20 | units at $33 | 660 |
| Dec. 11 | Purchase | 13 | units at $35 | 455 |
| 37 | units | $1,239 | ||
There are 17 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 | $ |
a. FIFO Method
| Units | Rate | Amount | |
| Balance from August 7 purchase | 4 | $ 33 | $ 132 |
| Balance from Dec 11 purchase | 13 | $ 35 | $ 455 |
| Ending inventory | 17 | $ 587 |
b. LIFO Method
| Units | Rate | Amount | |
| Balance from August 7 purchase | 13 | $ 33 | $ 429 |
| Balance from beginning inventory | 4 | $ 31 | $ 124 |
| Ending inventory | 17 | $ 553 |
c. Weighted average cost
| Weighted average cost per unit = Cost of goods available for sale / Number of units available for sale |
| Weighted average cost per unit = $1,239 / 37 |
| Weighted average cost per unit = $33.49 |
| Ending inventory = 17*$33.49 |
| Ending inventory = $569 |
You can reach me over comment box, if you have any doubts.
please rate this answer