Lost Sales Value

1) Meaning

Lost Sales Value is the monetary value of sales that could not be realized because products were out of stock or otherwise unavailable when customers wanted them.

It quantifies the financial impact of stockouts, beyond just percentages (like Stockout Rate or Fill Rate).

• High Lost Sales Value → major revenue leakage and dissatisfied customers.
• Low Lost Sales Value → good inventory and demand planning.

---

2) Formula

There are two common ways to calculate it:

1. Based on demand shortfall:

$\text{Lost Sales Value} = \text{Unfulfilled Units} \times \text{Unit Selling Price}$

2. Based on total potential sales:

$\text{Lost Sales Value} = (\text{Total Demand Value} – \text{Actual Sales Value})$

Where:

• Total Demand Value = Demand Units × Selling Price
• Actual Sales Value = Fulfilled Units × Selling Price

---

3) Example

• A customer wants 500 units of a product.
• You only have 450 units in stock, so 50 units go unfilled.
• Each unit sells for $20.

$\text{Lost Sales Value} = 50 \times 20 = \$1,000$

So, the company lost $1,000 in revenue due to the stockout.

---

4) Why it matters

• Revenue impact: Directly shows how much money you’re losing.
• Customer loyalty: Frequent lost sales push customers to competitors.
• Decision-making: Helps balance inventory cost vs. service level.
• Prioritization: Identifies which products’ stockouts hurt the business most (e.g., high-margin SKUs).

---

5) Ways to reduce Lost Sales Value

• Demand forecasting improvement (time series models: ARIMA, Prophet, LSTM).
• Safety stock policies for high-demand/high-margin products.
• Supplier collaboration to reduce lead times.
• Inventory optimization (ABC/XYZ analysis, multi-echelon planning).
• Real-time monitoring of sales and stock.

---

6) Relationship with other metrics

• Stockout Rate (%) → how often shortages happen.
• Fill Rate (%) → how much demand is fulfilled.
• Lost Sales Value ($) → how much revenue is actually lost.

Example:

• Stockout Rate = 5%
• Fill Rate = 95%
• Lost Sales Value = $50,000

This shows both the service level issue (5% shortages) and the financial impact ($50k lost).

---

Bottom line:
Lost Sales Value measures the revenue lost due to stockouts or unfulfilled demand. It complements service-level metrics by translating shortages into dollar impact, making it essential for profitability and inventory strategy decisions.