Open calculator ↗

Minimum order quantity versus dead stock cost · Calculation guide

Buy the greater of forecast demand and supplier minimum.

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

InputValue
Forecast units sold80
Supplier minimum units100
Purchase cost per unit10
Surplus recovery per unit3
Holding cost per surplus unit1
ResultValue
Expected surplus units20
Net surplus cost160

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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Forecast units sold8088Expected surplus units2012
Supplier minimum units100110Expected surplus units2030
Purchase cost per unit1011Net surplus cost160180
Surplus recovery per unit34Net surplus cost160140
Holding cost per surplus unit12Net surplus cost160180
Minimum order quantity versus dead stock cost →

Sources