Calculation guide
Expected lost contribution = Stockout probability / 100 × Units short if stockout occurs × Unfilled demand permanently lost / 100 × Unit contribution margin
Inputs
Stockout probability
Example entry 25 %. Allowed range 0 to 100.
Units short if stockout occurs
Example entry 100. Use whole numbers.
Unfilled demand permanently lost
Example entry 60 %. Allowed range 0 to 100.
Unit contribution margin
Example entry 15 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Stockout probability | 25% |
| Units short if stockout occurs | 100 |
| Unfilled demand permanently lost | 60% |
| Unit contribution margin | 15 |
| Result | Value |
|---|---|
| Expected lost contribution | 225 |
Calculation steps
Expected lost contribution = (((((Stockout probability ÷ 100) × Units short if stockout occurs) × Unfilled demand permanently lost) ÷ 100) × Unit contribution margin)
(((((25 ÷ 100) × 100) × 60) ÷ 100) × 15) = 225
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Stockout probability | 25% | 28% | Expected lost contribution | 225 | 252 |
| Units short if stockout occurs | 100 | 110 | Expected lost contribution | 225 | 247.5 |
| Unfilled demand permanently lost | 60% | 66% | Expected lost contribution | 225 | 247.5 |
| Unit contribution margin | 15 | 17 | Expected lost contribution | 225 | 255 |
