Retail replenishment

Fresh-product order quantities were evaluated against demand scenarios and expiry-aware stock flow, then compared in stores under different ordering policies.

Industry: Retail / Fresh products
Decision family: Inventory control
Evaluation scope: In-store validation

Customer identity and identifying operational details are withheld.

The operating decision

Short shelf life and demand swings create a recurring trade-off between empty shelves, discarded products and sales opportunity.

Inputs: Sales history · Weather and promotions · Item and store traits · Stock by remaining shelf life · Customer purchase behavior assumptions
Decision: Order quantity per item · Priority among waste, profit and stock-outs
Constraints: Lead time · Minimum order units · Delivery cycle · Remaining shelf life

How it is approached

Prepare demand scenarios
Use sales history and item and store information to represent several plausible demand situations.
Replay expiry-aware stock flow
Model inbound stock, customer choice, sales and expiry day by day, keeping the real ordering conditions in the evaluation.
Choose the operating objective
Compare order candidates under different priorities, then review their stock-out and waste trade-off against the store’s chosen objective.

Demand scenarios. Store stock flow. One ordering decision.

Demand scenarios

A demand distribution from sales, weather, promotions and store traits, drawn as many cases

Order candidates

Order quantities tried item by item, kept only if they respect order units, deliveries and shelf life

Store digital twin

Customer choice: Purchase odds by remaining shelf life
Stock flow: Stock by expiry date, replayed day by day
Real constraints: Lead time · minimum order · order cycle

Order quantity → daily sales · waste · stock-outs · stock

Waste vs. stock-out frontier

Order strategies computed with different objective weights

The store's objective

1Least wasteUnits discarded after expiry
2Most profitLowest waste cost + lost sales
3Fewest stock-outsDays that end with zero stock

Final order

A retail ordering structure: demand scenarios and shelf-life stock flow reveal the trade-off between waste and stock-outs. The frontier illustrates strategies, not measured results.Scroll to explore the diagram ↔

Original in-store comparison of waste and stock-outs. — Original in-store evaluation. Orange: manual ordering; purple: optimized ordering; large dots: item averages. Axes show waste units and stock-out count.

Second original in-store waste and stock-out comparison. — The source compares periods at the same store under similar demand. Period differences remain a limit on interpretation.

In-store validation

Validation & scope

The source includes in-store policy comparisons with manual and existing automated ordering. The manual comparison used a similar-demand period, while the automated comparison alternated policies and included period and demand differences. Lower stock-outs can raise waste, so each baseline and store condition must be read separately.