For an irrigation hose distributor, a stockout just before the local selling season is different from a quiet-week stockout. A single annual average can hide the weeks when demand accelerates. Conversely, buying to the peak every month can leave excess stock after the season ends.
A practical replenishment plan puts demand, usable inventory and expected arrivals on the same weekly timeline. Its job is to reveal when a purchasing decision is needed. Physical storage conditions and stock rotation remain important, but they do not answer that timing question.
Plan at the level customers actually order
Build the forecast around orderable product variants. Separate sizes, constructions and pressure classes that cannot substitute for one another. Combining every blue layflat hose into one total can hide a shortage in the size customers need most.
Choose a consistent planning unit. If purchases are in rolls and sales are recorded in meters, convert using each item's confirmed supplied length. Maintain the roll count as well, because a meter total alone does not describe full-roll availability. For cut-length business, include the continuous-length constraints explained in the coil allocation guide.
Separate observed sales from expected demand
Sales history is a starting point, not a complete demand record. A week with no stock may show low sales even when customers wanted more. Record known lost orders or backorders separately instead of interpreting a stockout as a fall in demand.
Review comparable weeks from earlier seasons alongside current distributor orders and local project schedules. Keep exceptional tenders, promotions and new-customer launches visible as separate assumptions. Avoid applying the same percentage increase to every SKU when the change affects only one part of the range.
Decide how firm orders interact with the forecast. One practical method uses confirmed orders plus a forecast for additional, uncommitted demand. Under that method, an order already included in the committed column must be removed from the residual forecast. Other planning systems consume forecast automatically; document which convention your team uses.
Define the whole replenishment window
The relevant lead time ends when stock is released for sale at your warehouse, not when it leaves the factory. Include the confirmed production schedule, dispatch preparation, transit, customs handling and receiving release. Use current order information and your own delivery history rather than a generic transit estimate.
For a weekly review process, also consider the time until the next purchasing review. A decision postponed for a week moves the next possible arrival. The planning horizon should be long enough to show that effect, including any predictable peak in demand before replenishment can become available.
A six-week example with a visible decision point
This fictional example uses meters of one approved hose SKU. Opening saleable inventory is 1,800 m. A confirmed 1,000 m receipt is expected to be released at the start of Week 3. Demand already combines firm orders and the remaining forecast without double-counting. The distributor has selected a 400 m planning buffer for this example; it is not a recommended stock level or a statistical service guarantee.
| Week | Opening balance | Released receipt | Planned demand | Projected closing balance |
|---|---|---|---|---|
| 1 | 1,800 m | 0 m | 250 m | 1,550 m |
| 2 | 1,550 m | 0 m | 300 m | 1,250 m |
| 3 | 1,250 m | 1,000 m | 450 m | 1,800 m |
| 4 | 1,800 m | 0 m | 500 m | 1,300 m |
| 5 | 1,300 m | 0 m | 550 m | 750 m |
| 6 | 750 m | 0 m | 600 m | 150 m |
Closing balance = opening balance + released receipts − planned demand. The following week starts with the previous closing balance. Week 6 ends 250 m below the selected buffer. That gap is a signal to review the plan; it is not automatically the purchase-order quantity.
If a new order placed now can become saleable only at the start of Week 7, it cannot protect the Week 6 buffer. The team must examine confirmed earlier supply, an approved branch transfer, revised customer scheduling or acceptance of the lower buffer. None of those actions justifies substituting an unapproved hose.
Size the order beyond the first shortfall
Extend the timeline through the weeks that the new receipt must cover. Then evaluate the desired closing stock, confirmed later receipts, minimum order quantity and permitted packing increments. Rounding a shortage up to one roll solves a packing constraint; it does not prove that the resulting stock will last until the next delivery.
Keep blocked stock and uncertain arrivals separate from the base case. If goods are awaiting inspection, they are not yet saleable. If an arrival date is tentative, show a delayed-arrival scenario rather than treating it as guaranteed. Check timing inside the week as well: a receipt on Friday cannot fulfill an order promised for Monday merely because both sit in the same spreadsheet column.
Use three short scenarios at each review
- Current plan: the latest demand assumptions and confirmed release dates.
- Higher demand: a clearly stated increase for the affected items and weeks, not the entire catalog by default.
- Late receipt: the same demand with a specific incoming shipment moved to a later release date.
Record the first week below the chosen buffer and the first projected shortage in each case. Assign an owner to the next action and give it a decision date. A useful weekly review changes an order, a promise or an assumption; it does more than update spreadsheet colors.
Close the loop after the season
Compare forecast with actual demand by SKU and week. Separate errors caused by a missed sales assumption from those caused by late supply, stock holds or inaccurate opening balances. Retain the explanations with the data so next season's planner does not repeat the same correction blindly.
Review leftover stock against realistic future demand before expanding the range. Product data discipline matters here: the catalog record checklist helps keep similar variants distinct across sales and purchasing.
Frequently asked questions
Is a fixed number of weeks of stock enough?
It may serve as a rough indicator, but it can miss changing weekly demand and delivery uncertainty. Use the time-based projection to see whether the chosen coverage protects the specific peak you expect.
Should the buffer be identical for all hose sizes?
Not necessarily. Demand variability, replenishment options and the consequences of a shortage differ. Select and review the policy for each planning group using your own records.
What should a seasonal purchasing discussion include?
Send SUNHOSE the approved products, quantities by required arrival period, destination and packaging needs. Review the current range and request a supply discussion; confirm actual availability and dates before relying on them in the plan.
