RFID payback: stock accuracy, availability, stock counts
Adds up the annual RFID effect from three sources: the margin from higher goods availability, the saved hours of stock counts and the reduced losses. Compares with the first-year costs (tags, equipment, operation), counts the payback period, the annual effect net of recurring costs and the number of tags at which the investment breaks even. Tags are bought every year for new goods, so the recurring part is shown separately.
At a glance
- What question does it answer?
- Whether RFID tags pay back: the effect, the costs and the time.
- What data is needed?
- Revenue, availability growth, margin.
- How to read the result?
- Compare the payback with the effect after the first year: tags recur. Example on the default values: Annual effect: RUB 4.9 million; Of them the margin from availability: RUB 3 million; Of them labor saving: RUB 700,000; Of them loss reduction: RUB 1.2 million. The figures are illustrative: enter your own to see your result.
Why and how to reason
The RFID effect has three parts: margin from availability 3.0 m RUB, labor 0.7 m RUB, losses 1.2 m RUB, 4.9 m RUB a year in total. First-year costs are 3.6 m RUB, payback 8.8 months; but tags recur and after the first year the effect is 2.5 m RUB.
When to use it
Before a pilot and buying equipment.
How to read the result
The payback and the effect after the first year; the break-even number of tags.
Common mistakes
Availability growth from a supplier estimate, low-margin goods with tags, processes without receiving discipline.
What data is needed?
- Revenue, availability growth, margin.
- Stock count hours, losses, tag and equipment prices.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Revenue of the tagged goods per year | ₽ | 300,000,000 | The annual revenue excl. VAT of the assortment you tag. The example value is illustrative. |
| Growth of goods availability | % | 2.5 | By how many percent of revenue it grows from fewer empty shelves and accurate stock: measure it in a pilot. The example value is illustrative. |
| Margin | % | 40 | Gross margin of revenue excl. VAT by the definition of the metric passport. The example value is illustrative. |
| Stock count hours per year now | h | 2,000 | The hours of stock recounts that RFID will cut almost completely. The example value is illustrative. |
| Cost of an hour | ₽ | 350 | An hour of work with contributions. The example value is illustrative. |
| Reduction of losses (shrink) | % | 0.4 | By how many percent of revenue the losses from theft and record errors fall. The example value is illustrative. |
| Tags per year | pcs | 400,000 | How many units of goods you tag per year. The example value is illustrative. |
| Tag price | ₽ | 6 | Enter your price: it depends on the tag type and the volume. The example value is illustrative. |
| Equipment (one-off) | ₽ | 1,200,000 | Readers, printers, integration with the accounting system. The example value is illustrative. |
| Operation per year | ₽ | 0 | Support, replacing readers, training. Empty = 0. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Margin from availability | 300 m ₽ × 2.5% × 40% = 3 m ₽ |
| Labor | 2,000 h × 350 ₽ = 700,000 ₽ |
| Losses | 300 m ₽ × 0.4% = 1.2 m ₽ |
| First-year costs | tags × price + equipment + operation |
| Payback | first-year costs ÷ the annual effect × 12 |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Annual effect
- 4.9 m ₽Margin from availability + labor + loss reduction.
- Of them the margin from availability
- 3 m ₽
- Of them labor saving
- 700,000 ₽
- Of them loss reduction
- 1.2 m ₽
- First-year costs
- 3.6 m ₽Tags + equipment + operation.
- Payback period
- 8.8 monthsFirst-year costs ÷ the annual effect × 12.
- Effect after the first year net of tags and operation
- 2.5 m ₽The annual effect − tags − operation: this is how each next year looks.
- Equipment payback on the recurring effect
- 5.8 months
- Break-even number of tags per year
- 616,667
Data as a table
| Measure | Amount |
|---|---|
| Availability | 3 |
| Labor | 0.7 |
| Losses | 1.2 |
| First-year costs | 3.6 |
What to do with the result: run a pilot in 2–3 stores and recalculate with the measured availability growth and stock accuracy (the “Stock accuracy” calculation); check the compatibility of tags with labeling with the supplier.
A typical mistake: counting the effect without regard to processes (tags will not replace receiving discipline) and tagging low-margin items. Prices of tags and readers are entered by you.
Nuances and limits
- Believing availability growth without a pilot.
- Tagging low-margin goods.
- Not counting recurring tags.