Distributor sourcingMulti-SKU purchase requestsLot and specification reviewReplenishment planning

Distributor Replenishment Forecast Review Worksheet

Cosmetic ingredient demand planning starts with orders, receipts and open commitments. Review the assumptions behind a distributor replenishment forecast.

Start with the uncertainty behind each number

A forecast row is an estimate made for a decision. Start with the market or customer group, the specific item revision and pack unit, the week or month concerned and the source of the estimate. A repeat buyer's reorder pattern, a first sampling program and a planned distributor launch carry different evidence. Give each its own row even if the same product code appears. When a total changes, the individual rows help you explain whether a customer moved, canceled or increased a requirement.

Use plain words for the evidence stage. “Requested,” “included in our internal estimate” and “confirmed on order” can all refer to the same physical units. Include the reference to an accepted order if it exists, then show how much of the total it already covers. GS1's logistics interoperability model distinguishes forecasts for planning from instructions that release a specific logistics action. Its distinction makes a good starting point when partners receive the same worksheet at different stages.

Make the demand and the purchase commitment reconcile

In a fictional example, the purchasing team projects demand for 72 cases during March in one market. A confirmed purchase order already covers 48 of those cases, leaving a forecast balance of 24. If the team sends a worksheet with “72 forecast” and “48 on order” without a relationship between them, a supplier could reasonably read 120 cases of demand. State that the 48 is included. A note such as “March total 72 cases, 48 on confirmed line, 24 for review” carries the arithmetic and the decision together.

Orders should be marked against the periods they will realistically cover for planning. If an accepted order moves out of the need window, keep its order status and record which demand window it can support. The change may create a timing gap even though the projected need and total ordered quantity stay constant. Record requested arrival, acknowledged milestone and arrival at the named destination in separate fields. An agreed delivery rule can define handover responsibilities and risk. The actual purchase and logistics records supply dates for the forecast.

Build a rolling window around real decision dates

Choose the earliest decision for each row and the person who can make it. Procurement might need a pack confirmation before issuing a line item. Quality might need a lot document before an alternative can count toward the plan. A partner might need to confirm the destination handling contact before organizing freight. Keep the date when a decision is required independent from the date when customers need the goods.

A three-period view is enough for many discussions. Show what the team needs to act on now, what it can review next and what it is observing later. Use actual dates so the periods still make sense when the worksheet is forwarded. As a period closes, preserve what the team expected and compare it with the outcome. Record any forecast basis that changed, such as a moved start date or a downstream approval that remained open.

Check the effect of time and pack changes separately

Consider a second fictional row where 18 cases are projected for a seasonal order, with another 12 possible if a distributor wins an additional account. Record 18 as the base planning figure and the 12 as a linked scenario. If the buyer learns that a different pack count is more practical at the receiving site, review how the change affects both the order unit and the count of usable units. Verify that both teams refer to the same pack revision before using the converted total.

A split option can be planned without assuming it will be offered. Add a line stating which need dates, pack configurations and lot approvals would make a split workable, then note the decision required from the relevant team. Give each future shipment its own reference if confirmed. If every customer must receive the same accepted lot, that constraint belongs next to the scenario so it can be reviewed before alternate stock is counted.

Measure whether the forecast improves your decisions

At the end of a period, compare the last forecast shared before the decision deadline with the actual quantity the group requested. Track the date the difference first became known. A recurring one-week shift may matter more to Procurement and QA than a large quantity difference tied to a one-time event. Record both order and actual receipt timing if you need to study where changes occur.

Review cancellations and missed release windows as separate explanations. If a customer moved a launch, update the event assumption in the next cycle. If late received paperwork prevented allocation, improve the handoff date and owner. Use a short recurring review with each partner only when there is a decision to make. Smaller accounts can keep a dated file and note changes by exception.

Share a version that partners can act on

Put a reference and revision date in the file and keep one row for each destination market, item revision, trade unit and need period. Record projected total, confirmed quantity already included, forecast balance, date or acceptance constraints, decision owner and the next review date. A compact change note can state which rows moved and who should recheck them. Share aggregate quantities if a customer's name is unnecessary for the decision.

When requesting a distributor replenishment review, include the part of the horizon you want assessed and the items that require current confirmation. Ask for a dated response scoped to the stated units, destination and intended timing. Record any accepted allocation with its own order or allocation reference. As the next forecast is released, link the confirmed line to the new revision so the same quantity remains visible without being counted again.

References for this page

Start a distributor inquiry

Include your destination market, business use, item or pack references, planned quantity units and the evidence needed before acceptance.