Tech, ExplainedE-commerce, travel and logistics
Part

Demand forecasting and replenishment

Ordering more before it runs out.

INSIDE: SUPPLY-CHAIN PLANNINGHOW IT WORKS · SUNFLOWER OIL POUCHES IN A SUPERMARKET IN INDOREForecast: 40 pouchesa day; a deliverytakes 3 daysThe safety stock is30 pouchesReorder point: 40 × 3+ 30 = 150 pouchesWednesday evening:140 pouchesin the store,none on the wayOrder one week'ssales, 280, roundedup to 24 cartons of12 = 288ALSO TALKS TOWarehouse management system (WMS)↗ LOGISTICS AND SUPPLY CHAININSIDE: SUPPLY-CHAIN PLANNINGHOW IT WORKS · SUNFLOWER OIL POUCHES IN ASUPERMARKET IN INDOREForecast: 40 pouchesa day; a deliverytakes 3 daysThe safety stockis 30 pouchesReorder point: 40 × 3 +30 = 150 pouchesWednesday evening: 140pouches in the store,none on the wayOrder one week's sales,280, rounded up to 24cartons of 12 = 288ALSO TALKS TOWarehouse management system (WMS)↗ LOGISTICS AND SUPPLY CHAININSIDE: SUPPLY-CHAIN PLANNING · SUNFLOWER OILPOUCHES IN A SUPERMARKET IN INDOREForecast: 40 pouches a day; a deliverytakes 3 days↓The safety stock is 30 pouches↓Reorder point: 40 × 3 + 30 = 150 pouches↓Wednesday evening: 140 pouches in thestore, none on the way↓Order one week's sales, 280, rounded upto 24 cartons of 12 = 288ALSO TALKS TOWarehouse management system (WMS)↗ LOGISTICS AND SUPPLY CHAIN
For sunflower oil in an Indore supermarket, a forecast of 40 pouches a day, a 3-day delivery and 30 pouches of safety stock set a reorder point of 150, and an order of 288 pouches goes to the warehouse.
opens a page inside this one a page in the same scene a page in another scene a concept page a label only, with no page

Demand forecasting and replenishment is the part of supply-chain planning that predicts how many units of each item will sell in each shop or warehouse, and orders more before the item runs out. Replenishment means restocking. The software does this for every item in every location, every day. A large retailer may have 20,000 items in 500 stores, so it must make about one crore of these decisions each day.

The forecast comes first. The software reads each item's past daily sales in each store. These are time series data, numbers recorded one after another over time. It also reads the things that change sales: festivals, the day of the week, the weather, promotions and price changes. From these it makes a demand forecast for each of the coming days.

Then it decides when to order and how much. Two numbers matter. The lead time is how long a new delivery takes to arrive. The safety stock is a small extra amount kept in case sales are higher than forecast or a delivery is late. The software orders when the stock in the store, plus the stock already on its way, falls below the sales expected during the lead time plus the safety stock. This level is called the reorder point.

Take, for example, one-litre pouches of sunflower oil in a supermarket in Indore. The forecast says that the store will sell 40 pouches a day this week. A delivery from the chain's warehouse takes 3 days. The safety stock is set at 30 pouches. So the reorder point is 40 × 3 + 30 = 150 pouches. On Wednesday evening, the store has 140 pouches and none on the way. That is below 150, so the software places an order. It orders enough for one week of sales, which is 280 pouches. It rounds this up to 288, because the pouches come in cartons of 12. The order goes to the chain's warehouse management system (WMS), which tells a worker which cartons to pick.

Without forecasting, a store employee orders by looking at the shelf. The store then runs out before festivals and holds too much stock in quiet weeks. Running out loses sales. Holding too much ties up money and shelf space, and food items may pass their expiry date.

This part belongs to supply-chain planning software. Quick-commerce apps use the same method hour by hour, for each dark store, a small warehouse that serves only delivery orders.

Tech, Explained is a part of ingrid.fyi. Every page explains one piece of technology in plain words.