Syntha Lab RU

Inventory valuation: FIFO, average and retail method

Compares three ways to value stock and the cost of goods sold on the same batches: write-off from the earliest (FIFO), weighted average and the retail method. Shows the difference in gross profit and stock, marks the method of the accounting policy and the age of the FIFO remainder.

Stock and turnover For whom: Accountants, finance directors and controllers who compare inventory valuation methods.

Calculate on your data →

At a glance

What question does it answer?
How the valuation method (FIFO, average, retail prices) changes the cost of goods sold, the stock and the gross profit.
What data is needed?
Batches: quantity, purchase and retail price excl. VAT.
How to read the result?
First the gross profit spread between methods, then the row of the accounting-policy method. Read the warnings about different batch markups and discounts before drawing conclusions. Example on the default values: FIFO: cost of goods sold: RUB 196,000; FIFO: stock at cost: RUB 154,000; Average: cost of goods sold: RUB 210,000; Average: stock at cost: RUB 140,000. The figures are illustrative: enter your own to see your result.

Why and how to reason

The valuation method changes the cost of goods sold and the stock on the same batches. In the example there are three batches of 100 units at 1,000, 1,200 and RUB 1,300, 180 units sold for RUB 376,000: FIFO gives a cost of 196,000 and a stock of 154,000, the average 210,000 and 140,000, the retail method 188,000 and 162,000; the gross profit spread is RUB 22,000.

When to use it

Apply to understand how much profit depends on the method, when changing the accounting policy and before closing a period. The method itself is approved by the accounting policy, the calculation only compares.

How to read the result

Read the profit spread and the row of the accounting-policy method; the warnings about different batch markups and discounts matter more than the figures.

Common mistakes

Methods are mixed in managerial and accounting records, the retail method is applied with different batch markups, revaluation is not reflected.

What data is needed?

  • Batches: quantity, purchase and retail price excl. VAT.
  • The quantity sold and revenue excl. VAT.
  • The method of the accounting policy.

Inputs

FieldUnitValue in the exampleMeaning
Sold over the period, unitspcs180How many units were written off for sale. Not above the sum of batches. The example value is illustrative.
Sales revenue at retail prices excl. VAT₽376,000The actual revenue of the units sold excl. VAT. For the retail method: if there were discounts it is below the retail value by the price list. The example value is illustrative.
Method of the accounting policyFIFOThe method fixed by the accounting policy. Check it against the organization policy and with an accountant: the calculation only compares methods.

How it is calculated

StepFormula
FIFOwrite-off from the earliest batches; the remainder at the prices of the latest batches
Weighted averageaverage price = sum(quantity × price) ÷ sum of quantity; cost of goods sold = sold × average
Retail pricesK = cost of available ÷ retail value of available; stock = (retail value of available − sales revenue) × K
Cost of goods sold and profitcost of goods sold = cost of available − stock; gross profit = revenue − cost of goods sold

Worked numbers

Default values from the app; in the interactive version you enter your own.

FIFO: cost of goods sold
196,000 ₽
FIFO: stock at cost
154,000 ₽
Average: cost of goods sold
210,000 ₽Average price 1,166.67 ₽ per unit.
Average: stock at cost
140,000 ₽
Retail method: cost of goods sold
188,000 ₽Cost-to-retail ratio 0.5.
Retail method: stock at cost
162,000 ₽
Gross profit spread between methods
22,000 ₽
Gross profit by the accounting-policy method
180,000 ₽
Stock, units
120
Average age of the FIFO remainder, days
batch ages not given
Cost of goods sold and stock by method, thousand RUB
Bar chart: FIFO 196, average 210, retail prices 188050100150200250FIFOFIFOCost of goods sold: 196196Stock: 154154averageaverageCost of goods sold: 210210Stock: 140140retail pricesretail pricesCost of goods sold: 188188Stock: 162162
  • Cost of goods sold
  • Stock
Data as a table
MeasureCost of goods soldStock
FIFO196154
average210140
retail prices188162

Three methods on the same batches

MethodCost of goods soldStockGross profitGross marginAccounting policy
FIFO196,000 ₽154,000 ₽180,000 ₽47.9 %yes
average210,000 ₽140,000 ₽166,000 ₽44.1 %—
retail prices188,000 ₽162,000 ₽188,000 ₽50 %—

The cost-to-retail ratio of the batches differs by 8.1 p.p.: the retail method gives an average over all batches and smooths different markups, apply it when markups are close.

Method of the accounting policy: FIFO. A managerial calculation by another method must not replace accounting: methods cannot be mixed in accounting.

The gross profit spread between methods is 22,000 ₽: the stock valuation differs by the same amount. The total cost of batches 350,000 ₽ does not depend on the method.

What to do with the result: check the method against the accounting policy (the accounting standard on inventory allows FIFO, average and specific identification) and verify with an accountant; when purchase prices rise FIFO shows more profit than the average.

A typical mistake: mixing methods in managerial and accounting records, applying the retail method with different batch markups and not reflecting revaluation.

Nuances and limits

  • Mixing methods in managerial and accounting records.
  • Applying the retail method with different batch markups.
  • Not reflecting revaluation.

Terms used

Calculate on your data →