FIFO costs each sale at the price of the oldest units you still have. Moving average costs each sale at the average price of everything on hand, and works out a new average after every purchase. When purchase prices rise, FIFO shows a lower cost of goods sold, a higher profit and a higher stock value.
Moving average cost = (stock value + new purchase) ÷ (units on hand + units bought)The cost of inventory may be determined on a moving average, first-in, first-out (FIFO), or last-in, first-out (LIFO) basis. The costing method used to value inventory is the main costing topic, because the method used has a large impact on the level of reported profit.
Every unit you buy has a cost. When it is sold, that cost moves to the cost of goods sold; while it waits, it is part of the stock value. The method decides which purchase price goes where. If you always paid the same price, every method would give the same answer: the methods differ only when prices change.
First-in, first out assumes goods first produced or acquired are the first ones sold (the oldest stock is sold first). Each purchase stays a separate lot with its own price. A sale uses up the oldest lot, then the next one. What is left on the shelf is valued at the latest prices.
FIFO shows higher profits in periods of rising costs: the cheap old units go to the cost of goods sold, and the expensive new ones stay in stock.
The moving average method keeps one cost per item. Each receiving adds its units and its value, and the item gets a new average cost. A sale takes units out at that average and does not change it.
The weighted-average costing method is calculated exactly as its name says: it is a weighted average of the prices in stock. It uses the average cost of a pool of goods available for sale during the period. The difference is the timing: the weighted average is worked out once, at the end of the period, while the moving average changes at every purchase.
A shop sells a box of wood screws at 4.00. In March:
| Date | Movement | Units | Unit price | Value |
|---|---|---|---|---|
| 1 March | Opening stock | 100 | 2.00 | 200.00 |
| 5 March | Purchase | 200 | 2.30 | 460.00 |
| 12 March | Sale | 150 | ||
| 20 March | Purchase | 100 | 2.60 | 260.00 |
| 28 March | Sale | 180 |
The sale of 12 March takes the 100 old units at 2.00 and 50 of the new ones at 2.30: 200.00 + 115.00 = 315.00. The sale of 28 March takes the other 150 units at 2.30 and 30 at 2.60: 345.00 + 78.00 = 423.00. The cost of goods sold is 738.00, and the 70 units left are worth 70 × 2.60 = 182.00.
After 5 March: 300 units worth 660.00, an average of 2.20. The sale of 150 costs 150 × 2.20 = 330.00 and leaves 150 units worth 330.00. After 20 March: 250 units worth 590.00, an average of 2.36. The sale of 180 costs 180 × 2.36 = 424.80. The cost of goods sold is 754.80, and the 70 units left are worth 165.20.
All the goods available: 400 units worth 920.00, an average of 2.30. The 330 units sold cost 759.00 and the 70 left are worth 161.00.
| March | FIFO | Moving average | Weighted average |
|---|---|---|---|
| Sales (330 × 4.00) | 1,320.00 | 1,320.00 | 1,320.00 |
| Cost of goods sold | 738.00 | 754.80 | 759.00 |
| Gross profit | 582.00 | 565.20 | 561.00 |
| Stock at 31 March (70 units) | 182.00 | 165.20 | 161.00 |
In every column, the cost of goods sold plus the closing stock is 920.00: the same money, split in a different place. With rising prices FIFO puts 16.80 more into this month's profit than the moving average. If prices fall, the order turns round.
To see what the profit means for each unit of stock, try the GMROI calculator or the markup vs margin calculator.
Last-in, first-out assumes goods first produced or acquired are the last ones sold (the newest stock is sold first). LIFO reduces taxes payable in periods of rising costs, because the expensive new units go to the cost of goods sold first.
LIFO is an accepted inventory accounting method in the US only. The international standard for inventories (IAS 2) allows FIFO and weighted average cost, and not LIFO. A small shop outside the US can leave it aside.
There are several cost methods from which to choose. For most shops the choice is between FIFO and an average.
| FIFO | Moving average | |
|---|---|---|
| What the software keeps | Every purchase lot and the quantity left in it | One quantity and one value per item |
| Check by hand | Follow the lots, oldest first | One division after each purchase |
| Rising prices | Lower cost of goods sold, higher profit and stock value | Between the old and the new prices |
| A price that jumps once | Shows when the cheap lots run out | Spread over the units on hand at once |
| Allowed under IAS 2 | Yes | Yes (a weighted average formula) |
Another factor to consider is that the method chosen should be simple enough for easy checking on a regular basis. The average wins there: one number per item, and anyone can recalculate it.
The cost method is not the order on the shelf. FIFO tends to follow the physical flow of goods better, especially when spoilage or expiry is a concern, but you can value stock at an average and still sell the oldest milk first. FIFO is a useful inventory management technique to use in the handling of stock on your shelves, whatever method the books use.
Keep the method you choose. We believe an entity may switch cost flow methods if the change is considered preferable, but the change and its effect must be explained in the accounts, and some tax offices want to approve it first. Ask your accountant before you change.
System 5 uses the moving average cost. It does not offer FIFO.
No. FIFO is a rule for the cost, not for the shelf. You can rotate stock oldest first with any cost method, and you should for anything that expires.
Yes. IAS 2 allows the weighted average cost formula, worked out either over a period or after each delivery. The moving average is the second form.
A receiving at a higher price, or at a wrong price, changes the average of all units on hand at once. Check the price of the last receiving first.
With rising prices, the method with the higher cost of goods sold gives the lower profit, so the average gives less tax than FIFO. The tax rules of your country decide which methods you may use.
The last cost stays on the item. The next receiving starts the average again from its own price.
Golden Inventory System 5 is a Windows program that you pay for once: $99 for up to 5 users, $199 for any number. Every receiving updates the cost, and the profit report uses it.