Syntha Lab RU

Order path: confirmation, fill rate and lost sales

By units reconciles “ordered, confirmed, delivered, accepted”: the confirmation rate (CONF), fulfillment of what was confirmed, unit fill rate overall and on time, where most is lost and what the shortfall and lateness cost. OTIF by orders alongside.

Order size and break-even For whom: Planners, buyers and heads of purchasing and logistics when reviewing order fulfillment.

Calculate on your data →

At a glance

What question does it answer?
How much of what was ordered is confirmed, delivered and accepted, where most is lost and what it costs.
What data is needed?
By supplier: ordered, confirmed, delivered, accepted, late and the delay in days.
How to read the result?
On the default data (three suppliers, 20,000 pcs) CONF is 90.5%, delivered to confirmed 93.9%, unit fill rate 85% and on time 74.5%, accepted to ordered 80.75% (16,150 pcs). Most units are lost at the stage “not confirmed”: 1,900. The shortfall of 3,850 pcs costs 3,465,000 at 25% recovered and a margin of 1,200, lateness 180,000. Order OTIF is 72.9% (62 of 85 orders), below the unit fill rate. The worst is Factory C: 71.25% accepted. Example on the default values: CONF: confirmed ÷ ordered: 90.5%; Delivered ÷ confirmed: 93.9%; Unit fill rate: delivered ÷ ordered: 85%; On-time fill rate: delivered on time ÷ ordered: 74.5%. The figures are illustrative: enter your own to see your result.

Why and how to reason

An order at a factory passes four points: ordered, confirmed, delivered, accepted. At each point a part is lost, and for different reasons: not confirmed, not shipped, defects at receiving. If you look only at the result “accepted ÷ ordered” you see the problem but not the place. The calculation splits the path into steps: confirmation (CONF) 18,100 ÷ 20,000 = 90.5%, execution of the confirmed 17,000 ÷ 18,100 = 93.9%, accepted 16,150 ÷ 20,000 = 80.8%. Then it turns losses into money: 3,850 units did not reach the customer, a quarter of them were replaced from another source, so the loss is 3,850 × 0.75 × 1,200 = 3.47 million. Delays cost separately: 22,500 unit-days × 8 = 180 thousand. The costliest step is the 1,900 unconfirmed units.

When to use it

Use it after a seasonal buy or mid-season to decide with whom to continue, where to ask for confirmation earlier and where to build a buffer. Do not use it on a small number of orders. Assumptions: figures are in units, confirmed is not above ordered, delivered is not above confirmed, accepted and late are not above delivered; lost margin per unit is constant.

How to read the result

Find the step with the largest loss: here it is confirmation (1,900 units), not defects and not delivery. So the talk with the factory should begin with mandatory confirmation before payment, not with penalties for defects. Compare fill rate by units (85%) and on time (74.5%): the difference shows the cost of delays, which is often confused with short delivery. The worst supplier by acceptance to order (71%) is a candidate for replacement or a smaller volume. OTIF by orders (72.9%) sits alongside but is computed on a different basis, so do not compare directly.

Common mistakes

Typical trap: entering numbers in roubles or orders rather than units, confusing “delivered” and “accepted”, ignoring the share replaced from another source, judging a factory by one season. Check that the chain of numbers declines from left to right. Do not mix partial deliveries with delays: for late units enter the real average delay, not the planned one.

What data is needed?

  • By supplier: ordered, confirmed, delivered, accepted, late and the delay in days.
  • Optionally: the number of orders and of orders on time and in full.
  • Lost margin per unit, loss per day of lateness and the share recovered elsewhere.

Inputs

FieldUnitValue in the exampleMeaning
Lost margin per unit short₽1,200Margin excl. VAT lost when a unit is not on the shelf. The example value is illustrative.
Loss per unit per day of lateness₽8The seasonal loss of sales or the price of speeding up per unit per day; your estimate. The example value is illustrative.
Share of the shortfall recovered elsewhere%25Bought from another supplier, taken from stock, moved the sale. The example value is illustrative.

How it is calculated

StepFormula
CONF and fulfilmentconfirmed ÷ ordered; delivered ÷ confirmed
Fill ratedelivered ÷ ordered; on time: (delivered − late) ÷ ordered
Shortfall price(ordered − accepted) × (1 − recovered elsewhere) × lost margin
Lateness pricesum (late units × delay × loss per unit-day)

Worked numbers

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

CONF: confirmed ÷ ordered
90.5 %The share of the order the supplier confirmed before dispatch: lost at the reply stage.
Delivered ÷ confirmed
93.9 %Fulfilment of its own confirmation: lost in production and delivery.
Unit fill rate: delivered ÷ ordered
85 %The share of ordered units that reached the warehouse. Not equal to order OTIF.
On-time fill rate: delivered on time ÷ ordered
74.5 %Units that arrived on time ÷ ordered.
Accepted ÷ ordered
80.8 %The whole chain: how much of what was ordered became good stock.
Order OTIF: on time and in full at once
72.9 %Orders on time and in full ÷ all orders: counts the whole order, hence below the unit fill rate.
Where most is lost
1,900 · not confirmed
Did not arrive good: ordered − accepted, units
3,850Includes what the supplier did not confirm, did not deliver and what was rejected at receiving (defects, wrong items, shortage): these are units not available for sale. Lost margin is counted on them.
Price of the shortfall
3.47 m ₽Units × (1 − recovered share) × lost margin.
Price of lateness
180,000 ₽Late units × days × loss per unit-day.
Worst supplier by accepted to ordered
71.3 % · Factory C

Suppliers: order path

SupplierCONFDelivered ÷ confirmedFill rateAccepted ÷ orderedOrder OTIFLoss price
Factory A92 %92.4 %85 %83 %77.5 %1.62 m ₽
Factory B98.3 %94.9 %93.3 %83.3 %64 %989,600 ₽
Factory C75 %96.7 %72.5 %71.3 %75 %1.04 m ₽

Most units are lost at the stage “not confirmed”: 1,900 of 20,000 ordered. For the reason open the worst supplier’s row: for “Factory C” 71.3 % of the order was accepted.

Unit fill rate and order OTIF answer different questions: the first is about volume, the second about orders without a single miss. Fix the meaning of “on time”, “in full” and the tolerance in the contract; there is no single standard in Russia, the target is yours. Amounts excl. VAT.

Nuances and limits

  • Unit fill rate and order OTIF are not the same: agree which measure goes into the contract.
  • Take the confirmation against the latest version of the order, not the first.
  • Count accepted after receiving: wrong items and defects are not included.
  • The price of losses depends on your margin and season: enter your own values.

Terms used

Calculate on your data →