Planning Inventory for a Seasonal Demand Curve

You plan inventory for a seasonal demand curve by shaping the forecast so each planning bucket carries its real expected demand, then building ahead of the peak so finished stock accumulates while capacity is free, and reading the projection to confirm the pre-build clears the peak weeks before they breach the buffer. In EDGEBIC by User Solutions the projected available balance nets that shaped forecast against your supply bucket by bucket, so the peak weeks that will fall short show red before they arrive, and you can test whether a build-ahead plan actually covers them. This post walks the seasonal plan from forecast shape to pre-build to verification.

Seasonal planning sits inside the wider replenishment and capacity picture. For the demand and buffer mechanics, read forecasting and replenishment explained, and for the capacity side of a seasonal peak, see seasonal capacity planning. This post stays on the inventory decision: shaping demand and building ahead. Inventory and forecasting features vary by installation, so check which planning capabilities your build exposes.

Shape the Forecast to the Curve, Not to an Average

A seasonal part has demand that rises and falls across the year: quiet months, a ramp, a peak, a fall-off. The first planning mistake is flattening that into an annual average, because the average is wrong in both directions. It overstates the quiet months, tying up stock you do not need, and understates the peak, hiding the shortage that matters most.

Planning starts by shaping the forecast so each planning bucket carries its own expected demand. The peak buckets hold the high numbers, the off-season buckets hold the low numbers, and the ramp buckets hold the climb between them. Enter demand per bucket rather than as one figure spread evenly, so the projection reads the real curve. Walk the entry in how to enter a demand forecast.

With the curve entered, the projection nets it against supply and shows the balance following the same shape: comfortable off-season, dropping through the ramp, and breaching the buffer in the peak. That forward view is the seasonal plan made visible. The below-safety buckets in the peak are the weeks you have to cover, and they are only visible because the forecast is shaped rather than averaged.

Why the Peak Forces a Build-Ahead

The reason a seasonal part needs special planning is that the peak usually demands more units than in-season capacity can produce. If demand triples for three months but the line can only produce its normal rate, then reordering during the season runs straight into a capacity wall: the work centers become the constraint exactly when demand is highest, and stock runs short no matter how quickly you trigger a reorder.

Building ahead solves this by moving production into the quiet months. The line has spare capacity off-season, so you run replenishment jobs early, let the finished units accumulate in stock, and draw from that stock when demand climbs. The pre-build converts idle off-season capacity into peak-season inventory. The quiet months absorb the production the peak months cannot.

This is where the projected balance and the schedule meet. The projection tells you which peak buckets breach the buffer and by how much; the schedule tells you whether build-ahead jobs can complete before those buckets. A build-to-stock job replenishes inventory on its completion date, so the pre-build jobs have to finish in the pre-season weeks for their supply to be on the shelf when the ramp hits.

Size the Pre-Build to the Buckets That Breach

Building ahead is only right if it is sized to the real shortfall, and the projection gives you exactly that. Read the peak weeks that show red, note how far each falls below the buffer, and add up the shortfall across the peak. That total, plus enough to keep the buffer intact through the fall-off, is the size of the build-ahead.

Size it too small and the projection still shows red in the deepest peak weeks; the pre-build lifted the balance but not above the buffer. Size it too large and you carry finished stock well past the season, tying up cash in inventory that drains slowly through the off-season. The projection shows both outcomes, so you tune the pre-build to the curve rather than to a comfortable round number. The same discipline that sizes a safety buffer to real variability sizes a pre-build to the real peak.

Spread the build-ahead across the quiet weeks rather than piling it into one job, so it fits the spare capacity you actually have. Each job's completion has to land before the peak bucket it is meant to cover, so a series of smaller pre-builds finishing across the pre-season weeks usually beats one large job that finishes late.

A Worked Example: A Three-Month Peak

Take a finished product with a sharp season. Off-season demand is 40 a week; the peak, weeks 20 through 32, runs 120 a week. The line produces 60 a week comfortably, safety stock is 150, and on-hand entering the year is 400.

Shape the forecast to the curve and the projection walks the balance down through the ramp and into the peak. In-season capacity of 60 against peak demand of 120 loses 60 a week, so once the peak starts the balance falls fast: it breaches the 150 buffer a couple of weeks into the peak and would run negative before the season ends. Those red weeks are the shortfall the plan cannot cover in-season.

Add up the peak shortfall: roughly 60 a week short across the thirteen-week peak is about 780 units the season cannot self-produce. So plan build-ahead jobs across the quiet weeks before week 20, when the line has spare capacity above the 40-a-week off-season demand. Run enough pre-build to bank around 780 finished units by week 19, spread over several jobs so each fits the free capacity. As each job completes in the pre-season weeks, the projection nets its finished units in, and the peak weeks that were red rise back above the buffer. The stock built in the quiet months carries the peak the line could not.

Now the check: confirm every pre-build job completes before the peak week it covers. A job that slips into week 22 arrives during the peak, when capacity is already the constraint, so its units land too late. Pull those completions into the pre-season weeks and the projection clears; leave them late and the deepest peak weeks stay red.

Verifying the Seasonal Plan Holds

A seasonal plan is trustworthy when the projection shows no below-safety buckets across the peak after the pre-build supply is netted in. Read the calendar and matrix across the whole curve: the ramp should stay above the buffer as build-ahead stock accumulates, the peak should hold as that stock is drawn down, and the fall-off should not leave a mountain of finished goods that drains for months. If a peak week still shows red, either the pre-build is undersized or a build-ahead job completes too late; if the off-season is buried in stock, the pre-build overshot.

Reading the whole curve at once is the point of shaping the forecast in the first place. For where seasonal planning sits in the wider workflow, start from the EDGEBIC planning guide, and to read the metrics that summarize coverage through a season, see reading days of cover in production planning.