Syntha Lab RU

Availability and lost revenue

Calculates the share of days an item could be bought, estimates lost sales, revenue and margin by item (adjusted for substitution) and, for wholesale, the shares of order lines and pieces filled.

Stock accuracy, shrink and availability For whom: Buyers, category managers and wholesale sales directors.

Calculate on your data →

At a glance

What question does it answer?
How often the item could be bought and how much revenue and margin we lost without it.
What data is needed?
By item: days in the period, days with stock, sold on those days, price.
How to read the result?
Look at class A items separately: an assortment average hides holes. The pace uses only days with stock, otherwise demand is understated. High availability with a large stock is overstock. Example on the default values: Availability (item-days) — 83.6%; Lost sales — 133 pcs; Lost revenue — RUB 637,755; Lost margin — RUB 378,590.

Why and how to reason

No goods, no sale, and that loss is invisible in reports. So availability is computed: the share of days when the item could be bought = days in stock / days in the period. Lost sales are estimated from the pace on in-stock days: sold / days in stock x days out of stock. Part of buyers will take a substitute, so we multiply by (1 - substitution).

Money is lost twice: revenue and margin. For decisions margin matters more because it shows how much was not earned.

Example. Jacket A: sold 216 in 72 days in stock, that is 3 a day; there were 18 days out of stock. With 15% substitution the loss is 3 x 18 x 0.85 = 45.9 units, margin 45.9 x (6,800 - 2,900) = RUB 179 k. Across four items availability is 83.6%, lost revenue RUB 638 k, margin RUB 379 k. For wholesale: 104 lines of 120 fulfilled on time = 86.7%, units 88.8%.

When to use it

Reach for it for bestsellers and basics where shortages lead to lost sales, and for wholesale deliveries. Assumption: demand on out-of-stock days would have been the same as on in-stock days. For seasonal goods this is not so, take data from nearby weeks. The substitution share is entered by you and strongly affects the result. For wholesale use fill rate by lines and by units.

How to read the result

Compare availability with the threshold you consider normal (for a basic item it is usually higher than for a seasonal one). Items with the largest lost margin are first candidates for safety stock and buying priority. Fill rate below 90% for wholesale risks losing the buyer. Decision: revisit safety stock and replenishment frequency for the most expensive items, agree lead times with suppliers, measure availability monthly. Determine where shortage comes from buying and where from logistics: the decisions differ. For the most expensive items build a simple plan: safety stock, replenishment frequency, owner. Make sure higher availability is not paid for with excess stock of other items.

Common mistakes

Computing lost sales from the average pace including out-of-stock days; setting substitution at 0 or 100; not noticing that stock was in the warehouse, not on the shelf; mixing fill rate by lines and OTIF. Also: measuring availability at end of day.

What data is needed?

  • By item: days in the period, days with stock, sold on those days, price.
  • Substitution share: an owner’s estimate; your own availability threshold (empty by default).
  • For wholesale: order lines and pieces ordered and filled.

Inputs

FieldUnitValue in the exampleMeaning
Your availability threshold%—Below this availability the measure is flagged. There is no single standard in Russia: set your own by item class (usually higher for the fastest sellers than for the tail). Empty: no flag.
Substitution share%15What part of customers takes another size or style and does not leave. An owner’s estimate: replace with yours; empty: 0.
Order lines ordered (wholesale)lines120How many wholesale lines the customer ordered over the period. Empty: availability by lines is not calculated.
Order lines filled on timelines104How many of them were filled on time. Not above the lines ordered.
Pieces orderedpcs5,200How many pieces were ordered. Empty: availability by pieces is not calculated.
Pieces shipped on timepcs4,620How many pieces were shipped on time. Not above the amount ordered.

How it is calculated

StepFormula
Availabilitydays with stock ÷ days in the period
Lost pieces(sold ÷ days with stock) × days out of stock × (1 − substitution)
On-time fillfilled on time ÷ ordered (by lines or by pieces); a separate measure: without the time condition it would be fill rate, on whole orders OTIF

Worked numbers

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

Availability (item-days)
83.6 %Days with stock ÷ all days across items. Set the warning threshold in the field above; there is no single standard in Russia.
Lost sales
133 pcs
Lost revenue
637,755 ₽
Lost margin
378,590 ₽Items without a cost are left out of lost margin (their lost revenue stays in the line above).
Biggest loss on
179,010 ₽ · Jacket A
On-time fill by lines
86.7 %Order lines filled on time ÷ lines ordered. Fill rate in Lab is counted without a time condition (shipped ÷ ordered), so the on-time measure is named separately; OTIF is counted on whole orders (the “Supplier OTIF and lead-time stack” calculation).
On-time fill by pieces
88.8 %Pieces shipped on time ÷ pieces ordered. Not the same as unit fill rate without a time condition (shipped ÷ ordered) or order OTIF. Agree with the chain what exactly is counted: lines, pieces, time.

Availability and losses by item

ItemAvailabilityPace, pcs a dayDays out of stockLost, pcsLost revenueLost margin
Jacket A80 %31845.9312,120 ₽179,010 ₽
Dress B90 %2915.364,260 ₽38,250 ₽
T-shirt C98 %528.512,750 ₽8,330 ₽
Trousers D67 %2.53063.8248,625 ₽153,000 ₽

High availability with a large stock is overstock, not good work. Reconcile stock on record with stock on the shelf: phantom stock hides unavailability (see “Stock record accuracy”).

Nuances and limits

  • Do not compute the pace over all days: days without stock give zero.
  • Do not confuse stock on record with stock on the shelf.
  • Lost revenue is an estimate, not a fact.
  • Items without a unit cost are left out of lost margin: fill in the column, otherwise the total is incomplete.

Terms used

Calculate on your data →