Calculation guide
Sell forecast demand, recover a salvage amount on surplus and incur holding costs on that surplus.
Expected surplus units = max(0,Supplier minimum units − Forecast units sold). Net surplus cost = Expected surplus units × (Purchase cost per unit + Holding cost per surplus unit − Surplus recovery per unit)
Inputs
Forecast units sold
Example entry 80. Use whole numbers.
Supplier minimum units
Example entry 100. Use whole numbers.
Purchase cost per unit
Example entry 10 (in the selected currency).
Surplus recovery per unit
Example entry 3 (in the selected currency).
Holding cost per surplus unit
Example entry 1 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Forecast units sold | 80 |
| Supplier minimum units | 100 |
| Purchase cost per unit | 10 |
| Surplus recovery per unit | 3 |
| Holding cost per surplus unit | 1 |
| Result | Value |
|---|---|
| Expected surplus units | 20 |
| Net surplus cost | 160 |
Calculation steps
Expected surplus units = max(0, (Supplier minimum units − Forecast units sold))
max(0, (100 − 80)) = 20
Net surplus cost = (Expected surplus units × ((Purchase cost per unit + Holding cost per surplus unit) − Surplus recovery per unit))
(20 × ((10 + 1) − 3)) = 160
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 |
|---|---|---|---|---|---|
| Forecast units sold | 80 | 88 | Expected surplus units | 20 | 12 |
| Supplier minimum units | 100 | 110 | Expected surplus units | 20 | 30 |
| Purchase cost per unit | 10 | 11 | Net surplus cost | 160 | 180 |
| Surplus recovery per unit | 3 | 4 | Net surplus cost | 160 | 140 |
| Holding cost per surplus unit | 1 | 2 | Net surplus cost | 160 | 180 |
