Course contents
Practitioner · Course 3: Forecasting and Phasing · Lesson 3 of 5

Adjusting a forecast once real sales data starts coming in

Level: PractitionerTime: 45 minutesOrder used: Order A's own T-shirt style, sold domestically by Cedar & Co. against a standing forecastTool: Forecasting and phasing worksheet
For a domestic Make to Stock buyer or planner re-forecasting a standing order once real in-season sales data exists. Lessons 3.1 and 3.2 are useful background, not required. Cedar & Co.'s sales figures are a teaching example, not reported company data.
BuyerCedar & Co., a domestic MTS brand with 12 shops
StyleA basic T-shirt, similar to Order A
Original standing forecast1,200 pieces, season's first four weeks
Real sales after two weeks760 pieces, ahead of the forecast's own pace
What this lesson setsWhether and how to adjust the forecast mid-season
Not set hereWeighing the cost of a wrong forecast either way (lesson 3.4)
02Opening

This page explains how a Make to Stock buyer re-forecasts a standing order once real in-season sales data starts to arrive, instead of holding the original forecast unchanged all season

This page explains re-forecasting: comparing a style's own real early-season sales against its original standing forecast, and adjusting the remaining season's production plan once a genuine gap appears. It is for a Make to Stock buyer or planner running a standing forecast that its own factory produces against continuously through a season.

At work, a domestic buyer such as Cedar & Co. sets a standing forecast before a season starts and reorders against it continuously as the season runs. Real sales rarely match a forecast exactly from the first week; the real question is not whether the forecast was perfectly right, but whether the gap between the forecast and real early sales is large enough, and consistent enough, to justify changing the plan for the rest of the season. Holding an original forecast unchanged once real sales clearly show a different pattern is a real problem: it wastes the very early sales data a Make to Stock model is meant to use. This lesson gives you the method for deciding when and how to adjust a standing forecast once real sales data exists.

03Before you start

You need: lessons 3.1 and 3.2's forecasting and phasing method are useful background but not required.

By the end of this lesson you can:

  • state why a standing forecast is checked against real early-season sales rather than held unchanged for the whole season;
  • calculate whether an early sales gap is large enough to justify a re-forecast, rather than ordinary week-to-week variation;
  • apply the method for adjusting the remaining season's forecast once a genuine gap is confirmed;
  • read the forecasting and phasing worksheet's re-forecast column and say what triggers it;
  • avoid the common mistake of re-forecasting from a single unusually strong or weak week instead of a sustained pattern.

Not covered here: building the original standing forecast from sales history (lesson 3.1); the cost of a forecast that stays wrong in either direction (lesson 3.4).

04Key terms
TermMeaning
Standing forecastThe demand estimate an MTS buyer, like Cedar & Co., builds its own regular orders against, rather than placing one order at a time.
Re-forecastUpdating the remaining part of a season's forecast once real sales data shows a sustained gap from the original estimate.
Sales gapThe difference between a style's own real recorded sales and what its standing forecast predicted for the same period.
Sustained patternA sales gap that continues across more than one recording period, rather than appearing in a single week only.
Reorder pointThe quantity of stock remaining at which a Make to Stock buyer places its next production order against the standing forecast.
BiasA forecast that is consistently too high or too low in the same direction across several periods, rather than randomly off in either direction.
05Teaching
The rule

A standing forecast is re-forecast once real sales show a sustained gap from the original estimate, not held unchanged for the whole season regardless of real results

A standing forecast is the starting estimate a Make to Stock buyer orders against, but it is not fixed for an entire season. Once real recorded sales show a sales gap from that estimate that continues across more than one period, a genuinely sustained pattern rather than one unusual week, the remaining part of the season's forecast is re-forecast to reflect what is actually happening. A gap in one single week, without a second week confirming it, is ordinary variation, not yet a reason to change the plan.

Standing forecastoriginal estimate Real saleseach period Sustained gap?re-forecast if yes
A standing forecast is compared against real sales each period, and only a sustained gap across more than one period triggers a re-forecast. One unusual week alone is ordinary variation, not evidence the original estimate was wrong.
What you meet in real life

Re-forecasting applies wherever real sales data exists, but how much room there is to act on it differs by model

What can differThe shapes you will meetWhy it matters
Domestic, Make to Stock, continuousCedar & Co. checks its own standing forecast against real weekly sales across its 12 shops and re-forecasts the remaining season once a two-week gap is confirmed.A Make to Stock buyer has the continuous sales data a re-forecast needs, since it sells and restocks throughout the season rather than after one shipment.
Export, Make to Order, single orderNorthline Apparel's Order A confirms one quantity before production starts, with far less scope to re-forecast mid-order once fabric and cutting are already committed.A Make to Order order has much less room to change mid-production; re-forecasting there mainly informs the next order, not the current one.
A gap in one week onlyA single unusually strong week driven by a one-off local event, followed by a return to the original forecast's own pace the next week.A one-week gap without a second period confirming it is ordinary variation, not a signal to re-forecast the rest of the season.
A gap that shows real biasReal sales run consistently above the standing forecast for three straight weeks, a genuine, sustained pattern rather than noise.A sustained gap across multiple periods is the specific condition that justifies changing the remaining season's plan.
The case we follow

Cedar & Co. checks its basic T-shirt's real sales against its 1,200-piece standing forecast after the first two weeks of the season

Cedar & Co. set a standing forecast of 1,200 pieces for the first four weeks of the season for a basic T-shirt style similar in construction to Order A. After two weeks, real sales across its 12 shops total 760 pieces, ahead of the pace the four-week forecast assumed. Cedar & Co.'s buyer checks whether this two-week result is a sustained pattern or ordinary variation before deciding whether to re-forecast the remaining two weeks of the period.

QuestionHolding the original forecast unchangedChecking real sales against the forecast
What does week 3 and 4 production assume?The original 1,200-piece pace, regardless of what the first two weeks actually showedWhatever the real two-week result indicates about the remaining weeks
What happens if real demand is genuinely running ahead?Shops likely run short in weeks 3 and 4, since production was never adjustedThe remaining weeks' production is sized to the real, confirmed pace
What happens if the fast two weeks do not continue?No difference, since the plan was never adjusted in the first placeA re-forecast made too early on too little data could overcommit stock
The worked number

Cedar & Co.'s style is selling at a pace of 380 pieces per week, ahead of the 300-piece weekly pace its original forecast assumed

Cedar & Co.'s buyer compares the real two-week sales rate against the standing forecast's own implied weekly rate to size the sales gap.

Original standing forecast, 4 weeks: 1,200 pieces
Forecast's own implied weekly rate: 1,200 ÷ 4 = 300 pieces per week
Real sales, first 2 weeks: 760 pieces
Real weekly rate: 760 ÷ 2 = 380 pieces per week
Weekly sales gap: 380 − 300 = 80 pieces per week ahead of forecast
Forecast rate300 pieces/week Real rate380 pieces/week (+80)
Real sales of 380 pieces per week run a confirmed 80 pieces per week ahead of the original 300-piece forecast rate. Because this gap holds across both of the first two weeks, it is a sustained pattern rather than a single-week spike.
The method

Five steps that decide whether, and how, to re-forecast a standing forecast once real sales data exists

  1. Calculate the standing forecast's own implied rate for the period being checked. Divide the total forecast by the number of weeks it covers.
  2. Calculate the real sales rate for the same weeks from actual recorded sales. Use the same period length as the forecast rate for a fair comparison.
  3. Confirm the gap holds across more than one period before treating it as sustained. A single week's gap alone is not yet evidence of a genuine pattern.
  4. Apply the confirmed real rate to the remaining weeks of the period to re-forecast them. The re-forecast uses the real, confirmed rate, not the original assumed rate.
  5. Record the re-forecast and the sales data behind it before it changes a production order. A re-forecast without its own recorded evidence cannot be checked later against what actually happens next.
The trap

A common mistake is re-forecasting from a single unusually strong or weak week instead of a sustained pattern across more than one period

A common mistake is treating one strong week as proof the whole season's forecast is wrong and re-forecasting immediately, before a second week confirms whether the pattern actually continues. If Cedar & Co. had re-forecast its remaining two weeks after only week 1's own result, without waiting to see whether week 2 confirmed the same pace, a one-off strong week driven by a local event could have led to an over-committed production order for weeks 3 and 4, with any excess resolved only through a later markdown.

06In plain words

A standing forecast is a starting estimate, not a fixed number a buyer must live with for a whole season regardless of what real sales show. Once real sales are recorded, they should be compared against the forecast's own rate for the same period. If the gap between real sales and the forecast holds across more than one period, it is a genuine, sustained pattern, and the remaining part of the season should be re-forecast using the real, confirmed rate instead of the original assumed one. A gap in a single week alone is ordinary variation and is not yet a reason to change the plan.

07Quick check
  • A standing forecast is re-forecast once real sales show a sustained gap across more than one period, not held unchanged all season.
  • The forecast's own implied weekly rate and the real weekly rate are compared over the same period length for a fair check.
  • Cedar & Co.'s style ran at 380 pieces per week against a forecast rate of 300 pieces per week, an 80-piece weekly gap.
  • A gap must hold across more than one period before it counts as a sustained pattern rather than ordinary variation.
  • Re-forecasting from a single unusual week risks an over-committed or under-committed production order for the rest of the season.
08Workplace scenario

Cedar & Co.'s buyer must decide the production order for weeks 3 and 4 after the confirmed two-week sales gap

Cedar & Co.'s buyer has confirmed real sales running at 380 pieces per week against the original 300-piece forecast rate, holding across both of the first two weeks.

  • The original standing forecast planned 600 pieces of production for weeks 3 and 4 combined, at the original 300-piece weekly rate.
  • The confirmed real rate of 380 pieces per week, if it continues, implies 760 pieces of demand across weeks 3 and 4.
  • Cedar & Co.'s own factory relationship with Delta Garments can produce an increased quantity for weeks 3 and 4 if the order is placed now, before the current production slot closes.
Cedar & Co., buyer's note: "Real sales have run at 380 pieces per week for two straight weeks against a 300-piece forecast rate. Should the weeks 3 and 4 order stay at the original 600 pieces, or move to the re-forecast 760 pieces implied by the confirmed real rate?"

Should Cedar & Co. place the weeks 3 and 4 order at the original 600 pieces, or at the re-forecast 760 pieces? Decide before you open the answer.

Show decision

At the re-forecast 760 pieces. The 80-piece weekly gap has held across both of the first two weeks, meeting the sustained-pattern condition; this is not a single-week spike being mistaken for a genuine trend.

First, why the original 600-piece figure is now out of date. The 600-piece plan for weeks 3 and 4 assumed the original 300-piece weekly rate, a rate the confirmed two-week real result has already exceeded consistently, not just once.

Second, why re-forecasting now, rather than waiting, matters. Cedar & Co.'s production slot for weeks 3 and 4 is still open; re-forecasting before it closes lets the order reflect the confirmed real rate, while waiting risks placing the outdated 600-piece order and running short mid-period.

Cedar & Co. should place the weeks 3 and 4 order at 760 pieces, the re-forecast figure built from the confirmed real rate, and continue checking real sales against this new rate as the remaining weeks unfold. Lesson 3.4 covers what a forecast that stays wrong in either direction actually costs.

09What it costs

Holding the outdated 600-piece order instead of re-forecasting to 760 pieces risks a 160-piece stockout across weeks 3 and 4

Framed in lost sales rather than a single penalty figure: the gap between the outdated order and the re-forecast figure is the stock Cedar & Co. would be missing if real demand continues at its confirmed rate.

Re-forecast quantity for weeks 3 and 4: 760 pieces
Outdated original order for weeks 3 and 4: 600 pieces
Shortfall if the outdated order is not re-forecast: 760 − 600 = 160 pieces
Lost sales value at Cedar & Co.'s own shop price, similar to Order A's own 19.90: 160 × 19.90 = USD 3,184

A 160-piece shortfall against confirmed real demand, left unaddressed because the original forecast was never checked against real sales, converts directly into approximately USD 3,184 of lost sales across weeks 3 and 4 alone, without counting any shops running short of the style for customers who might otherwise have returned later in the season.

10Working template

Forecasting and phasing worksheet: the re-forecast column this lesson fills

The workbook's "Re-forecast" sheet takes the original standing forecast's own weekly rate, compares it against real sales entered period by period, flags whether the gap has held for more than one period, and calculates a re-forecast quantity for the remaining weeks once the sustained-pattern condition is met.

Cedar & Co.'s own rows record the 300-piece forecast rate against 380-piece real weeks 1 and 2, with the sheet flagging a sustained gap and calculating the 760-piece re-forecast for weeks 3 and 4.

Download the Forecasting and phasing worksheet (Excel)

11Check yourself

1. Why is a standing forecast re-forecast only once a sales gap holds across more than one period, not after a single strong or weak week?

2. Cedar & Co.'s style sold 760 pieces in the first two weeks against a 1,200-piece, four-week forecast. What is the real weekly sales gap?

3. After confirming an 80-piece weekly sales gap across two straight weeks, what should Cedar & Co. do for the weeks 3 and 4 production order?

12Glossary
ENARFRTRMeaning
Standing forecastتوقعات ثابتةPrévision permanenteSürekli tahminThe demand estimate an MTS buyer, like Cedar & Co., builds its own regular orders against, rather than placing one order at a time.
Re-forecastإعادة التوقعReprévisionYeniden tahminUpdating the remaining part of a season's forecast once real sales data shows a sustained gap from the original estimate.
Sales gapفجوة المبيعاتÉcart de ventesSatış farkıThe difference between a style's own real recorded sales and what its standing forecast predicted for the same period.
Sustained patternنمط مستمرSchéma soutenuSürekli örüntüA sales gap that continues across more than one recording period, rather than appearing in a single week only.
Reorder pointنقطة إعادة الطلبPoint de recommandeYeniden sipariş noktasıThe quantity of stock remaining at which a Make to Stock buyer places its next production order against the standing forecast.
BiasالانحيازBiaisSapma (yanlılık)A forecast that is consistently too high or too low in the same direction across several periods, rather than randomly off in either direction.
13Next

Lesson 3.4: The real cost of a forecast that is wrong in either direction

You now know how to adjust a forecast once real sales data starts coming in. The next lesson quantifies what a forecast that is wrong in either direction, too high or too low, actually costs. Back to the course map

14Ladder

RecognizeTell a sustained sales gap held across more than one period apart from ordinary single-week variation.
ConnectSee how Cedar & Co.'s confirmed 380-piece weekly rate replaces the original 300-piece rate for the remaining weeks.
CompareTell a Make to Stock buyer's continuous re-forecasting apart from a Make to Order buyer's single confirmed order.
DecideRe-forecast the remaining weeks at the confirmed real rate once a gap holds across more than one period.