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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Sold over the period, units | pcs | 180 | How 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,000 | The 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 policy | FIFO | The 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
| Step | Formula |
|---|---|
| FIFO | write-off from the earliest batches; the remainder at the prices of the latest batches |
| Weighted average | average price = sum(quantity × price) ÷ sum of quantity; cost of goods sold = sold × average |
| Retail prices | K = cost of available ÷ retail value of available; stock = (retail value of available − sales revenue) × K |
| Cost of goods sold and profit | cost 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
- Stock
Data as a table
| Measure | Cost of goods sold | Stock |
|---|---|---|
| FIFO | 196 | 154 |
| average | 210 | 140 |
| retail prices | 188 | 162 |
Three methods on the same batches
| Method | Cost of goods sold | Stock | Gross profit | Gross margin | Accounting policy |
|---|---|---|---|---|---|
| FIFO | 196,000 ₽ | 154,000 ₽ | 180,000 ₽ | 47.9 % | yes |
| average | 210,000 ₽ | 140,000 ₽ | 166,000 ₽ | 44.1 % | — |
| retail prices | 188,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.