Analyse the sales pattern per item
Forecast sheet for dry goods, 180 items, 24 months of history
Trade
So safety stock gets estimated on the high side.Open agent
Enlarge demo
Developed in Germany · Hosted in the EU or on-premises
Delivered together with
The target cover is set once for the whole product group, usually based on the worst delivery anyone can remember. Anyone who wants to change it has to calculate two figures separately: the replenishment lead time from recent deliveries and the safety stock from sales variability and lead time variability. With 180 items per product group, someone does the maths for the twenty most important and never for the rest.
180
items planned
That is how many lines one buyer manages in the dry goods product group.
28 days
blanket target cover
Fast movers and seasonal items are set to the same cover.
11 days
measured replenishment lead time
That is how long the last 24 deliveries took on average to reach the dock.
64,000 euros
tied-up capital
Eleven days of replenishment and four days of safety stock cover demand; the remaining 13 days of cover sit on the shelf as stock.
The 20% less excess stock comes from the 180 items that run on four weeks of target cover, even though replenishment lead time and calculated safety stock together cover fifteen days and sales have been stable for eight months.
The 20% reduction in excess stock is this agent's headline figure. The 180 planned items and the eleven-day replenishment lead time represent an ordinary dry goods product group; none of it was measured.
Purchasing decides on every order; the agent supplies the demand forecast, the safety stock and a proposal for each item.
Forecast sheet for dry goods, 180 items, 24 months of history
Item TS-40118 pasta 500 g: target cover 28 days, replenishment lead time 11 days, safety stock 4 days
Proposal list with 52 lines, 12 of them with a changed quantity
It presents quantity, date and the resulting cover. Every line is approved in the ERP by the buyer who manages the product group.
It works with the lead times of the last 24 deliveries. Purchasing weighs that against what was agreed in the annual review.
The secondary placement for week 40 multiplies demand for two weeks. Until the date is booked, it plans on baseline demand, and purchasing adds the promotional quantity by hand.
Connected systems
ERP merchandise management
SCM procurement
sales planning
Operations
Deployment model
Data processing
Responsible teams
How quickly is the Inventory Optimisation Agent ready to use?
Where is the data processed?
Where does the figure “20% less excess stock” come from?
All agents
20%
less planning effort
HR department, store management
15%
better purchasing terms
Purchasing, supply chain
3 to 8%
revenue growth
Management, category management
5 to 15%
higher margin
Category management, controlling
60%
less preparation time
Executive board, management
60%
less reporting effort
Branch Management, Management