Does the replenishment system have to automatically create an order?

Automatic validation depends on the reliability of the recommendations, supply constraints and stock risk. The planner must be able to review assumptions and exceptions, and the allowed limits for automation are determined by measured errors.

How to deal with days when the goods were not available?

Such a period cannot be considered a normal selling signal. The model must know the state of availability and, where possible, estimate the lost demand. Otherwise, after each shortage, the system may recommend an even smaller amount.

Can one KPI measure the quality of a supplement?

No. At least the sides of scarcity and surplus together must be looked at. By reducing scarcity alone, one can simply fill stores with too much stock, and by reducing the stock alone, make accessibility worse.

How do you include a supplier in the plan that delivers less than ordered?

Separately, the quantity ordered, confirmed and actually received is recorded. Another replenishment offer is based on expected receipt and supplier's execution history, and an unresolved shortfall is passed on to the planner. Increasing the order amount alone without evaluating the supplier's capacity may not be effective.

Grocery store replenishment planning system

How the solution works

Sales history adjusted by promotions and past shortfall
Demand for next supply comparable to available and incoming stock
Quantity is restricted to packaging, capacity and pre-market capability
The planner confirms the exceptions and passes the replenishment order

Key challenges

The addition plan confuses low demand with a past shortage

Solution capabilities

Demand Signal

The forecast separates the base sales rate from stock, season and known periods of scarcity.

Stock position

Before the quantity is recommended, it is assessed who is already in the store and who will arrive before the next addition.

Limits of Addition

The quantity is limited by packaging, shelf capacity, supply schedule and validity logic.

Recommended quantity

Each recommendation must show the most important reason and allow the responsible employee to manage exceptions.

Business context

The addition plan confuses low demand with a past shortage: Sales history is used in the replenishment plan without distinction of periods when proper stock was not available. Demand unsatisfied recommended even lower quantity or surplus is generated for other goods.
Everyday shopper more often finds regular goods: The addition plan must distinguish low demand from the period when the item simply did not exist. After evaluating the flaws and validity, it is possible to more accurately combine availability with non-sale risk. This is important in keeping the buyer's habit of putting the cart in the same store.

Core features

Demand Signal
Stock position
Limits of Addition
Recommended quantity

Key integrations

Point-of-sale system (POS): Sales history and actual sales rate.
Reserve system: Balance, reserve and reservations along the way.
Pricing and stock system: Future promotions and their periods.
Supply or ERP system: Supply schedule, packaging and order restrictions.
Validity and batch system: The risk of short-term stocks when it is needed for planning.

Potential impact (%)

The ranges indicate an illustrative relative change in the metric under the stated assumptions. Results depend on the starting position and actual use of the solution. Percentages for different metrics must not be added together.

Time of lack of goods in the store

2–12%Decreasing

This illustrative scenario assumes that 10-30% of the metric is attributable to addressable planning and execution shortcomings. That share is assumed to fall by 20-40%. Company data is needed to verify both the addressable share and the resulting change.

The hours or days are compared when the active item did not have a sellable balance, normalizing by range.

Share of surplus store stock value

2–12%Decreasing

This illustrative scenario assumes that 10-30% of the metric is attributable to addressable planning and execution shortcomings. That share is assumed to fall by 20-40%. Company data is needed to verify both the addressable share and the resulting change.

The value assigned to the surplus stock is divided by the total value of stocks in the same category and multiplied by 100. The surplus threshold is determined by the amount of days in the stock agreed and the uniform valuation date.

Purchases lost due to lack of store supplies

3–14%Decreasing

The sample scenario affects 15-35% of the indicator associated with the problem being addressed. This proportion is assumed to be reduced by 20-40%. The company data checks both the volume and the change achieved.

Estimates of recorded unsatisfied queries and sales during comparable periods of availability of goods; estimates are separated from registered losses.

Conditional calculation scenarios. The assumptions have not been validated against client measurements.

When this solution is relevant

Many store and SKU combinations
Significant shortages of both goods and surplus stocks
Frequent promotions and seasonal peaks
Reliable sales, balances and supply data are available

Implementation requirements

Actual supply schedules, pack sizes and periods of shortage are prepared for the addition of shops. Validity and location restrictions are linked to the quantities offered, and the conditions for automatic approval are determined by the measured reliability of the recommendations.

Further development options

Automatic validation of verified addition recommendations
Evaluation of the stock-short validity interaction