Hong Life CalculatorsUnderstanding the out-of-stock cancellation loss calculator — concept and principle
When a seller cancels orders because an item is out of stock, the damage goes beyond the missing sale. Marketplaces may charge penalties or require compensation, the profit on the order is gone, and some disappointed customers never come back. This calculator adds those three costs together so online sellers can see what stockouts really cost and how much better inventory planning is worth.
How it is calculated
- Direct cost = cancelled orders × (penalty or compensation per order + lost profit per order).
- Lost future value = cancelled orders × share of customers lost for good × future value of a customer.
- Total loss = direct cost + lost future value.
Penalty is any fee, coupon or compensation paid per cancelled order. Lost profit is the profit you would have made on that order. Future value is the profit a retained customer would bring in later purchases. The calculator works with any currency.
The principle
A stockout creates an immediate loss and a delayed one. The immediate part is easy to see: compensation paid and profit not earned. The delayed part is customer lifetime value that disappears when a buyer switches to a competitor. Multiplying the number of affected customers by the probability that they leave and by what they would have been worth gives the expected value of that loss. Research on customer loyalty has long shown that keeping customers is worth far more than one transaction suggests.
Worked example
- Inputs: 20 cancelled orders, penalty $5, lost profit $8, 30% of customers lost, future value $60.
- Direct cost = 20 × ($5 + $8) = $260.
- Customers lost = 20 × 0.30 = 6; lost future value = 6 × $60 = $360.
- Total loss = $260 + $360 = $620.00.
How to read the result
Divide the total by the number of cancelled orders to get the cost per stockout, here $31. Compare it with the cost of holding extra safety stock or of switching to a faster supplier. In this example more than half of the loss is future value, which means the real cost of stockouts is much larger than the penalties in your marketplace report. Repeated cancellations can also affect seller ratings, which this calculator does not include.
Common mistakes
- Using revenue per order instead of profit as the lost profit.
- Counting future value as total future revenue rather than profit.
- Guessing the lost-customer share too high or too low without data on repeat purchases.
- Forgetting that some customers will reorder after a restock.
Frequently asked questions
How do I estimate the future value of a customer?
Use average gross profit per order × expected number of future orders. Your order history for repeat buyers is the best data source.
How can I reduce cancellation losses?
Sync stock across sales channels, keep safety stock for best sellers, set realistic lead times and contact affected customers quickly with an alternative.
Sources: Frederick F. Reichheld, The Loyalty Effect (Harvard Business School Press, 1996)