Guide · inventory costing for small businesses

FIFO vs moving average cost

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)

What the cost method decides

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.

FIFO: first in, first out

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.

Moving average and weighted average

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.

Worked example: one item, two purchases, two sales

A shop sells a box of wood screws at 4.00. In March:

DateMovementUnitsUnit priceValue
1 MarchOpening stock1002.00200.00
5 MarchPurchase2002.30460.00
12 MarchSale150
20 MarchPurchase1002.60260.00
28 MarchSale180

FIFO

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.

Moving average

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.

Weighted average (once, at the end of March)

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.

MarchFIFOMoving averageWeighted average
Sales (330 × 4.00)1,320.001,320.001,320.00
Cost of goods sold738.00754.80759.00
Gross profit582.00565.20561.00
Stock at 31 March (70 units)182.00165.20161.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.

And LIFO?

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.

Which method should a small business use?

There are several cost methods from which to choose. For most shops the choice is between FIFO and an average.

FIFOMoving average
What the software keepsEvery purchase lot and the quantity left in itOne quantity and one value per item
Check by handFollow the lots, oldest firstOne division after each purchase
Rising pricesLower cost of goods sold, higher profit and stock valueBetween the old and the new prices
A price that jumps onceShows when the cheap lots run outSpread over the units on hand at once
Allowed under IAS 2YesYes (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.

Cost in Golden Inventory System 5

System 5 uses the moving average cost. It does not offer FIFO.

Questions

Does FIFO mean I must sell the oldest units first?

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.

Is the moving average allowed under IFRS?

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.

Why did my average cost jump?

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.

Which method gives the lower tax?

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.

What happens to the average when stock falls to zero?

The last cost stays on the item. The next receiving starts the average again from its own price.

The average cost, kept for you

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.