Inventory
Weighted average cost vs FIFO: which fits your stock?
Three deliveries at rising prices, costed both ways, and why the shelf follows a different rule from the books.
Weighted average cost gives every kilo you use the same price, blended from everything you bought. FIFO, first in, first out, charges the oldest purchases first, so when prices rise it shows lower cost of sales and higher stock value. IFRS allows both, and over time both charge exactly what you paid.
What is weighted average cost?
Add up what you paid for everything you hold and divide by the quantity. Each delivery joins the total, so the average moves a little with every bill. Whatever you use or sell goes out at the current average, whichever bag the team opened.
In the example from our inventory management guide, a roastery holds 40 kg of green coffee at AED 50.00 a kilo and buys 60 kg more at AED 53.11. The 100 kg cost 2,000.00 + 3,186.60 = AED 5,186.60, an average of AED 51.87 a kilo.
What is FIFO?
FIFO keeps each delivery as its own layer, at its own price. What you use is costed from the oldest layer first, then from the next. What's left on the books is always your most recent buying, at the prices you paid.
Weighted average cost vs FIFO: a worked example
Take the same roastery and add a third, dearer delivery before anything is roasted: 20 kg at AED 57.17. Then the roaster uses 80 kg. The figures are invented, and amounts are in AED.
| Delivery | Quantity | Price per kg | Cost |
|---|---|---|---|
| First | 40 kg | 50.00 | 2,000.00 |
| Second | 60 kg | 53.11 | 3,186.60 |
| Third | 20 kg | 57.17 | 1,143.40 |
| Total | 120 kg | 52.75 average | 6,330.00 |
| Line | Weighted average | FIFO |
|---|---|---|
| Cost of the 80 kg used | 4,220.00 | 4,124.40 |
| Value of the 40 kg left | 2,110.00 | 2,205.60 |
| Total | 6,330.00 | 6,330.00 |
| Cost per kg used | 52.75 | 51.56 |
On the average, all 80 kg go out at 52.75. On FIFO, the first 40 kg go out at 50.00 and the next 40 at 53.11: 2,000.00 + 2,124.40 = 4,124.40. What FIFO leaves is the newest coffee, 20 kg at 53.11 and 20 kg at 57.17, worth 1,062.20 + 1,143.40 = 2,205.60.
Both columns add up to the 6,330.00 the roastery paid. The method only changes when the spending shows up as cost. Here FIFO reports 95.60 less cost this month and 95.60 more in stock, which becomes cost later, when the dearer coffee is roasted.
The gap follows the coffee into the roaster. With a roast loss of 15.4%, the 80 kg come out as 67.68 kg, at 62.35 a kilo on the average or 60.94 on FIFO. Your bag and cup costs start from that figure.
Which method shows more profit when prices rise or fall?
When prices rise, FIFO. It charges the older, cheaper stock first, so cost of sales is lower and gross profit higher. The stock on your balance sheet stays close to today's prices.
When prices fall, the opposite happens: FIFO charges the older, dearer stock first and shows less profit. The weighted average smooths both, because each new price mixes with what you already hold.
Neither is more accurate. The difference is timing, and it grows when prices move fast and stock sits longer.
Which method fits your business?
- Fast-moving perishables. Milk, pastries, fresh juice. Stock turns over in days, so the two methods give almost the same figure. Pick the simpler one.
- Stock that gets mixed. Green coffee tipped into one bin, sugar, syrup in bulk. No one can say which delivery a kilo came from, so an average describes it best.
- Prices that swing. An average moves gently, so recipe costs and menu prices don't jump with every bill. FIFO shows a new price only once the older layers are used up, and then all at once.
- Slow stock in a rising market. If an item sits for months while prices climb, FIFO keeps its value close to what it would cost to buy today. On an average, old prices linger in the value.
- Simplicity. One cost per item, updated by every bill, is easy to read, check and explain. FIFO means keeping every layer and costing from the right one, which is fine in software and painful in a spreadsheet.
For most cafés and roasteries the weighted average is the practical choice. FIFO is worth the extra work where stock is slow and prices move a lot.
Is FIFO costing the same as first in, first out on the shelf?
No. FIFO costing decides which price you use. Rotation decides which bag you pick up.
On the shelf, the better rule is first expiry, first out: use what expires soonest, even if it arrived last. A business on weighted average should still rotate by date, and a business on FIFO can still pull a short-dated case forward.
The lot links the two. Keep each delivery as a lot with its date, cost and expiry. You can then rotate by date and trace a problem to its delivery, while still costing on an average.
Rotation is easier when you aren't overstocked, and the reorder point calculator helps you set how much to hold. A regular stock count then checks the quantities every valuation rests on.
What do accounting standards in the UAE allow?
UAE businesses report under IFRS, the international accounting standards, or its lighter version for smaller companies, IFRS for SMEs. Both allow FIFO and weighted average cost for stock that is interchangeable, and neither allows LIFO, last in, first out. IAS 2, the IFRS standard on inventories, also asks for items that aren't interchangeable, such as a machine with its own serial number, to be costed one by one.
Consistency matters as much as the choice. Use the same method for all stock of a similar nature and use. A different location alone isn't a reason to use another.
Switching later is a change of accounting policy, which needs a good reason and an explanation in your accounts. So choose once, on purpose, and tell your accountant which method you chose.
Seyaqi costs stock on a weighted average across dated lots, updated by every bill. Each lot keeps its own date, cost and expiry, and you're warned before it expires.
The shelf can then run first expiry, first out, while the books carry one current cost per item. Each roast batch carries its loss inside the cost. See how Seyaqi runs stock, or get a quote.
General information as of November 2026, not tax or legal advice. Official source: IAS 2 Inventories, IFRS Foundation.
Common questions
Is FIFO or weighted average better for a café?
Weighted average suits most cafés: it is simpler to run and keeps recipe costs steady. The difference is small anyway, because milk, pastries and coffee turn over in days. Either way, rotate the shelf by expiry date.
Is LIFO allowed in the UAE?
No. UAE businesses report under IFRS, and neither full IFRS nor IFRS for SMEs allows LIFO (last in, first out). For stock that is interchangeable, the permitted cost formulas are FIFO and weighted average.
How do you calculate weighted average cost?
Divide the total cost of the stock you hold by the quantity. For example, 40 kg at AED 50.00 plus 60 kg at AED 53.11 is 100 kg costing AED 5,186.60, or AED 51.87 a kilo. Recalculate after every delivery.
Does the stock costing method change my VAT?
No. VAT is charged on what you sell and reclaimed, where recoverable, on what you buy, at the invoice amounts. The costing method only changes how stock and cost of sales are valued in your accounts.
Every number in your business, in context.
Seyaqi runs stock, production, purchasing, sales, people and the books in one system, with an AI Advisor that reads it all every night and tells you what needs you.
Read next
- Inventory How to run a stock count you can trust, step by step Freeze the place, count blind, recount the big gaps, and give every difference a name before you post a single dirham. 6 min read
- Inventory Inventory management for small businesses in the UAE Four questions every stock record must answer, how to answer them place by place and lot by lot, and the signs yours have stopped telling the truth. 5 min read
- Finance Aged receivables report: how to read it and collect What the age columns tell you, and a weekly routine that turns overdue invoices into cash. 4 min read