The pump manufacturer holds 2,300 compact pumps, 20 days of supply. Delivery on time and in full is still only 84 percent. More stock has not bought better service, because nobody decided how much stock each family needs.
Agree the service level first
Sales and operations agree a service level per make to stock family. For compact pumps: 95 percent per replenishment cycle. The service level sets the safety factor: 1.65 for 95 percent, about 2.05 for 98 percent, about 2.33 for 99 percent.
Higher service is possible. It just costs more stock, and the decision should be taken with that cost visible.
Safety stock from the forecast error
Safety stock protects against the difference between forecast and actual demand during the replenishment lead time:
safety stock = safety factor × standard deviation of the forecast error × square root of the lead time in months
For compact pumps the standard deviation of the monthly forecast error over six months is 142 units, the lead time is half a month:
1.65 × 142 × √0.5 = 165 units
The error comes from the accuracy measurement, so better forecasts directly lower the stock.
Cycle stock from the batch size
Compact pumps are replenished every two weeks in batches of 1,150 units. On average half a batch is in stock: 575 units.
Target against actual
- Target: 165 + 575 = 740 units
- Demand per working day: 115 units
- Target in days: 6.4 days
- Actual: 2,300 units, 20 days
- Excess: 1,560 units, at a unit cost of EUR 520 about EUR 811,200
The excess is not spread evenly. Most of it sits in slow variants with less than one month of sales in the last year. It gets an owner and a plan: sell, rework or scrap.
Three kinds of stock
- Safety and cycle stock protect service. Calculated and reviewed monthly.
- Seasonal or pre-build stock levels the load ahead of a peak. Decided in the executive review, with an end date.
- Excess and obsolete stock has no purpose. Owner and plan.
In the example, the pre-build of up to 500 compact pumps for the May peak is good stock. It is decided, priced and ends in May. The 1,560 units in slow variants are not.
Measure delivery against the request date
Service is measured on time and in full against the date the customer requested, not against a date confirmed later. Confirmed dates make every delivery look punctual and hide the real problem.
Review the targets
Targets change when demand, error or lead time change. Recalculate monthly for the main families and quarterly for the rest. A target written once and never touched becomes another habit.