merchmix

Publish Date :

Grocery and FMCG: Replenishment Without Waste

Grocery replenishment needs to match the quantity customers can buy within the stock’s usable selling life, not just the next delivery slot. Core Plus supports refill quantities, coverage rules and source constraints. A short review cycle is useful only when arrival, pack size and current usable stock are counted on the same basis.

A young grocery planner checking sealed chilled stock and a rotation clipboard in a retail store.
Editorial illustration of the retail planning decision.

THE MERCHMIX DECISION / Core Plus

A case size can turn a precise need into a fresh exposure.

Check usable arrival, short selling life and feasible packs together.

Independent worked retail example. Quantities are planning assumptions, with financial amounts shown in US dollars. Proposed changes remain subject to review.

merchmix.Core Plus / commercial review
Establish the basisCurrent assumptions

A case size can turn a precise need into a fresh exposure.

Usable arrival tomorrow / two selling daysProduct condition and operational date controls remain authoritative.
Carry to arrival10 unitsThirty held less today’s twenty sales
Original receipt60 unitsReceipt proposed, not received
After arrival70 unitsOne common usable-stock basis
Demand inside the window40 units
Beyond assumed window30 units
Demand rate20 / day
Projected remaining30 units
Remaining at cost$120
Independent pack and demand comparisonSixty incoming leaves thirty

Thirty incoming would match the base need but is not a twelve-unit case quantity. Compare the feasible packs, another delivery and authorised buffers; no receipt or disposal is executed.

Establish tomorrow’s usable stock

Today’s twenty sales leave ten before receipt.

THE KEY IDEA

Check usable arrival, short selling life and feasible packs together.

A weekly total can hide a daily waste problem

A grocery line can look adequately covered for the week while carrying more short-life stock than it can sell before its operational cutoff. Increasing every refill to avoid an empty shelf can move the problem from availability to disposal. A smaller order is not automatically better either if the next usable arrival comes too late.

Core Plus brings sales velocity, stock coverage, minimums, maximums and replenishment guardrails into the quantity review. For short-life merchandise, the retailer must also supply an authoritative usable-stock and date basis. This article does not claim automatic batch-expiry control or a guaranteed waste-reduction model.

Planning and product referencesMerchmix Core Plus: product scope

Count the usable portion of the stock first

The independent example concerns a chilled line with thirty usable units and expected demand of twenty per day. The next replenishment becomes usable tomorrow morning. A proposed sixty-unit receipt would therefore arrive after today’s twenty sales, alongside ten carried units.

Assume the carried units and receipt can be sold during the next two selling days under the retailer’s accepted operating rules. This is a planning constraint, not food-safety advice or a claim about any product’s labelled life. Actual condition, storage and date controls take precedence over the forecast.

Calculate the receipt against the remaining window

At tomorrow’s arrival, ten carried units plus sixty incoming give seventy. Expected sales over the two-day window are forty, leaving thirty beyond that window if the forecast holds. At an assumed $4 cost, $120 of stock cost is exposed; it is not a recognised write-off or a confirmed loss.

A requirement of thirty incoming units would instead combine with the ten carried units to match forty expected sales. That calculation does not yet select a feasible order. The supplier’s pack size, next delivery, presentation need and any authorised buffer still matter before a refill is accepted.

THE FIGURES BEHIND THE DECISION

A case size can turn a precise need into a fresh exposure. Check usable arrival, short selling life and feasible packs together.
Receipt comparisonAvailable after arrivalTwo-day demandBeyond window
Original 60 units70 units40 units30 units
Three cases / 36 units46 units40 units6 units
Same receipt / softer demand46 units32 units14 units

Carry to arrival = 30 less 20 = 10. Three cases add 36; 46 less 40 = 6. At sixteen a day, 46 less 32 = 14.

Respect the pack instead of rounding away the problem

Assume the receipt must use twelve-unit cases. Thirty units cannot be ordered on that basis. Two cases give 24 incoming, making 34 available against forty expected sales. Three cases give 36 incoming, making 46 available and leaving six beyond the assumed window.

The worked comparison makes the trade-off visible rather than declaring either pack choice optimal. Six units at $4 represent $24 at cost. A different pack, an earlier intervening delivery or a revised selling assumption might change the decision; those options need operational confirmation rather than an optimistic rounding rule.

THE PLANNING REFERENCERead the allocation and replenishment guide

Test a demand change before releasing the refill

If the two-day demand is sixteen per day rather than twenty, the 36-unit receipt plus ten carried units leaves fourteen after 32 expected sales. That is $56 at cost, not the original six-unit exposure. The sensitivity concerns demand after arrival; today’s twenty-unit assumption stays unchanged.

Core Plus supports the refill and coverage review, but an ordinary cover target cannot override a usable-life constraint. Keep the base and softer scenario separate. Do not silently revise the carried quantity as well as the demand rate, or the comparison will stop explaining why the proposed receipt changed.

Separate shelf execution from the external receipt

An empty facing can coexist with stock in the back room. Confirm whether the task is to move usable stock onto the shelf, replenish from a distribution centre or place another supplier order. They have different sources, lead times and authority. A new external commitment may not solve today’s shelf gap.

The allocator or replenishment owner should inspect the source reserve and competing stores before accepting a quantity. Keep declared stock, usable stock and expected arrivals distinct. Core Plus supports the commercial stock decision; physical handling and product-condition rules remain with the retailer’s operational process.

SignalMerchmix workspaceDecision to review
Establish tomorrow’s usable stockCore Plus / decision reviewToday’s twenty sales leave ten before receipt.
Inspect the original receiptCore Plus / decision reviewSixty incoming would leave thirty beyond the window.
Compare feasible packsCore Plus / decision reviewThree cases give thirty-six incoming and six projected remaining.

Review availability and waste on the same scope

After the selling window, compare actual receipt, usable units, sales, date-related withdrawals and any unmet demand estimate for this line. Do not celebrate a smaller order if it merely displaced waste with an avoidable shelf gap. Equally, a full shelf is not success if its stock could never sell in time.

Merchmix Core Plus makes the refill quantity review part of the stock workflow. In this example the useful decision is between feasible packs within a short window, with six or fourteen projected units still requiring attention. No receipt, disposal or live stock change is performed by the article.

BEFORE THE NEXT DECISION

  • Evidence owner

    Confirm scope, timestamps and the independent assumptions.

  • Commercial owner

    Check the customer opportunity, cost and competing commitments.

  • Decision owner

    Record the accepted response and the next review point.

Common questions

Is the $120 a confirmed write-off?

No. It is the cost of thirty units projected beyond the assumed selling window.

Why not order thirty units?

The example requires twelve-unit cases, so thirty is not a feasible case quantity.

Does Core Plus enforce expiry dates here?

No automatic batch-expiry or food-safety control is asserted.

Why is tomorrow’s opening ten units?

Today’s assumed twenty sales reduce thirty usable units to ten before arrival.

Is the smallest pack choice always best?

No. Demand, availability, another usable delivery and operating constraints need review.

core plus

Today’s twenty sales leave ten before receipt.

Explore

Continue reading: Seasonal usable-window planning

Read the retail planning glossary

FROM THE ARTICLE TO YOUR OWN RETAIL PLAN

Review the decision.
See the workflow.

Bring your planning questions to a demo, or explore a proof of concept on your own data.

Book a demo Explore the proof of concept