Distributor Stock Replenishment: The DRR Min–Max Method That Ends Stock-Outs (2026)

Quick answer: Distributor stock replenishment sets a minimum and maximum stock level for every distributor × SKU from real offtake. DRR = average monthly offtake over the last six months ÷ selling days. Minimum stock = (billing cycle days − 1) × DRR, and maximum = billing cycle days × DRR. When stock falls below the minimum, reorder up to the maximum.

Key takeaways

• Most stock-outs and most overstock come from the same cause: distributors order by gut feel and month-end pressure instead of actual offtake.

• DRR-based min–max replaces guesswork with three numbers per SKU: baseline, DRR and billing cycle.

• Automatic replenishment orders should respect credit limits, order whole cartons and raise only one line per SKU per cycle.

• Track phasing compliance as a manager KPI, or the plan will be overridden by month-end loading.

What is distributor stock replenishment (stock phasing)?

Distributor stock replenishment, also called stock phasing, is the practice of spreading a distributor's purchases evenly across the month so that the stock in their godown always covers the next billing cycle, and no more. The alternative, common across Indian FMCG, dairy and agri distribution, is loading: pushing large primary orders in the last week to hit a monthly target. Loading creates a burst of primary sales, followed by weeks of dead stock, near-expiry write-offs and blocked working capital.

A phased plan answers one question for each distributor and each SKU: how much should be on the shelf today, and when does the next order need to go?

Why distributors run out and overstock at the same time

If you look at a typical distributor's stock report, you will usually see both problems in the same godown:

• Fast movers run out because reorders are placed only when the salesman notices empty racks.

• Slow movers pile up because they were pushed during last month's scheme or target closing.

• No one sees offtake. The company sees primary billing; the distributor sees what went out of the godown; neither turns it into a reorder point.

• Credit blocks the urgent order. When cash is tied up in slow stock, the order for the fast mover is held at the credit-limit check.

A min–max method fixes the first two directly and eases the other two, because stock that matches demand frees up both cash and credit.

How do you calculate DRR, minimum and maximum stock?

Step 1: Calculate the baseline offtake

Baseline = average monthly offtake for that distributor × SKU over the last six complete months. Six months smooths out one-off spikes such as a festival or a single bulk order, while staying recent enough to reflect current demand. For a new SKU or new distributor with no history, use an opening baseline agreed with the area manager until real data builds up.

Step 2: Convert baseline to DRR (daily rate of sale)

DRR = baseline ÷ selling days in the month. Use selling days, not calendar days. A market that is closed on Sundays and public holidays has roughly 25–26 selling days, and dividing by 30 understates daily demand.

Step 3: Set minimum and maximum stock

• Minimum stock = (billing cycle days − 1) × DRR

• Maximum stock = billing cycle days × DRR

The billing cycle is how often the distributor is normally billed for that SKU, for example every 7 days. The minimum leaves one day of buffer for the order to be approved and delivered; the maximum is one full cycle of demand.

Step 4: Calculate the order quantity

When stock falls below the minimum, order enough to reach the maximum, rounded up to whole cartons. No distributor wants loose units on a primary order, and no plant wants to pick them.

Worked example

A distributor sells a 100 g spice pack, packed 48 to a carton, on a 7-day billing cycle.

1. Offtake over the last six complete months averages 2,600 packs per month.

2. The market has 26 selling days, so DRR = 2,600 ÷ 26 = 100 packs per day.

3. Minimum = (7 − 1) × 100 = 600 packs. Maximum = 7 × 100 = 700 packs.

4. Tonight's closing stock is 520 packs, which is below the minimum, so an order is due.

5. Gap to maximum = 700 − 520 = 180 packs = 3.75 cartons, rounded up to 4 cartons (192 packs).

Without phasing, this SKU would likely have run out in five days, while a slow-moving SKU in the same godown sat at twice its maximum.

Want this for your own distributors? Book a 30-minute walkthrough and we'll work out min–max levels for a sample of your top SKUs.

Which replenishment statuses should you track?

Every distributor × SKU should carry one clear status, so that a sales officer can scan a list instead of reading a stock ledger:

• Order due: stock is below the minimum and nothing is on order.

• On order: an order has been raised and is in the approval or delivery pipeline.

• On track: stock is between the minimum and maximum.

• Excess: stock is above the maximum; stop pushing this SKU.

• No data: there is not enough history or no baseline is set, so the setup needs attention.

Can a DMS raise replenishment orders automatically?

Calculating distributor stock replenishment levels in Excel is a good start, but it breaks down beyond a few distributors because the numbers go stale within days. In SalesPort DMS, stock phasing runs on its own:

• Nightly snapshots recalculate baseline, DRR, minimum, maximum and status for every distributor × SKU.

• A 30-minute check raises one automatic primary order per distributor when SKUs fall below minimum, with one line per SKU per cycle so the same need is never ordered twice.

• Credit-limit aware ordering: the order is checked against the distributor's credit limit and ERP outstanding before it is raised.

• Recommended purchase orders can be accepted, dismissed or regenerated by the distributor or the sales team if you prefer a human in the loop.

• Immediate refresh: when the billing cycle or baseline is changed, the snapshot updates straight away instead of waiting for the next night.

Distributors see the same numbers read-only in a My Phasing view on the dealer portal and the Distributor App, so the company and the distributor work from one shared plan.

Billing control: stop loading at the approval step

Even with good recommendations, a large manual order can still arrive at month-end. Phasing-aware approval handles this. When the company approves a primary order, the system previews a split: SKUs within the phasing plan are billed and pushed to the ERP (for example SAP Business One), and the excess is held back as a remainder. The distributor gets the stock they need; the extra load waits for the next cycle.

Make phasing compliance a manager KPI

Replenishment plans fail when the people who own the monthly target are not measured on phasing. Two practices keep the plan intact:

• Weekly phasing bands on monthly targets, with lower and upper limits per week, so 25% of the month's sales are expected in each week rather than 60% in the last one.

• Dealer phasing compliance rolled up to SO, ASM and RSM, and weighted in their incentive scorecard. (See our guide to sales target cascade and incentive calculation.)

Setup checklist

1. List every active distributor × SKU combination you want to phase. Start with your top 20% of SKUs by value.

2. Agree the billing cycle per distributor (7, 10 or 15 days are typical).

3. Load six months of clean offtake history, or set opening baselines for new SKUs.

4. Bulk-upload the setup from Excel or CSV rather than keying it in.

5. Decide per distributor: fully automatic orders, or recommended orders with approval.

6. Confirm that credit limits and outstanding balances sync from the ERP every day.

7. Review "Excess" and "No data" lists weekly for the first two months.

What mistakes should you avoid with stock phasing?

• Using primary sales as offtake. Primary billing measures what you pushed, not what the market bought. Use secondary or godown-out data.

• Dividing by 30. Use selling days, or DRR will understate demand.

• Phasing everything on day one. Start with fast movers, where stock-outs cost the most.

• Ignoring expiry. For short shelf-life products, pair phasing with FEFO, expiry-aware inventory so the maximum never exceeds what can be sold before expiry.

See stock phasing on your own data

SalesPort runs distributor stock replenishment alongside orders, schemes, receivables and field sales in one distributor management system, with SAP Business One integration built in. Schedule a walkthrough and we will model min–max levels for a sample of your distributors.