Inventory valuation calculator: weighted average and FIFO

The same purchases and sales, valued both ways, so the difference to profit is plain.

Why the method changes profit

When the same item is bought at different prices, the cost of each unit sold has to be decided. Weighted average costs every unit at the average price of everything bought. First in, first out (FIFO) assumes the oldest units leave first, so the cost of sales uses the older prices and the stock left on the shelf carries the newest. When prices are rising, FIFO gives a lower cost of sales, a higher profit and a higher stock value; weighted average sits between.

A worked example

100 units bought at SAR 10, then 100 at 12, then 50 at 15; 180 sold.

Weighted average cost: 2,950 ÷ 25011.80 a unit
Weighted average: cost of sales, 180 × 11.802,124.00
Weighted average: closing stock, 70 × 11.80826.00
FIFO: cost of sales, 100 × 10 + 80 × 121,960.00
FIFO: closing stock, 20 × 12 + 50 × 15990.00

Which method is allowed

IFRS (IAS 2), which Saudi Arabia applies through SOCPA and the other Gulf states apply directly, allows FIFO and weighted average and not LIFO. A business uses the same method for items of a similar nature, and changes it only when the change gives more reliable information. Costs are recorded without input VAT that can be recovered.

Questions

What is the weighted average cost method?

Every unit is costed at the total cost of the purchases divided by the units bought. 250 units costing 2,950 in all are 11.80 each, whichever are sold.

What is FIFO?

First in, first out: the units sold are costed at the oldest purchase prices first, and the closing stock at the newest.

Is LIFO allowed in Saudi Arabia?

No. IFRS, which applies in Saudi Arabia and across the Gulf, does not permit last in, first out.

Which method gives a higher profit?

When purchase prices are rising, FIFO: the older, cheaper units go to cost of sales. When prices fall, the reverse.

Does the app do this automatically?

Yes. Aqid ERP keeps a weighted-average cost per item and warehouse, updated with each receipt, and posts the cost of sales with each invoice.

Your first compliant invoice is minutes away

Start now for free No credit card needed — invoice in minutes