Course contents
Practitioner · Course 2: Open-to-Buy and WSSI · Lesson 5 of 5

Building a complete open-to-buy and WSSI worksheet

Level: PractitionerTime: 50 minutesOrder used: A (the T-shirt, Cedar & Co.'s own domestic hybrid buying plan)Tool: Open-to-buy and WSSI worksheet
For a domestic retail buyer who must combine open-to-buy and a WSSI into one working check for a season. You need lessons T20-C02-L01 through T20-C02-L04. Figures are teaching examples in US dollars.
RetailerCedar & Co., 12 shops, hybrid Make to Stock and Make to Order buying
Domestic orderEquivalent-value reorder and top-up lot from Delta Garments
Season budgetUSD 40,000, illustrative for this lesson
Committed spend before this checkUSD 22,000 committed, USD 4,000 already reordered in lesson T20-C02-L03
BuyerOmar, owner of Cedar & Co.
What this lesson measuresWhether a season's open-to-buy and its WSSI agree with each other
02Opening

This page explains how open-to-buy and a WSSI are checked together in one worksheet before a season is confirmed

This page is for a domestic retail buyer who has to combine open-to-buy and a weekly sales, stock and intake plan into one working check, rather than treating the two as separate exercises. At work, a buyer who checks open-to-buy and a WSSI in isolation can approve a season budget that looks fine on its own, and a weekly stock plan that looks fine on its own, without noticing the two disagree about how much stock the season actually needs. This lesson mainly teaches the decision flow: it shows how Cedar & Co.'s hybrid buying, part Make to Stock reorder, part Make to Order top-up, is checked as one complete picture before the season is confirmed.

Cedar & Co. set a season budget of USD 40,000, has committed USD 22,000, and placed a further USD 4,000 reorder once early sales beat forecast, leaving USD 14,000 of open-to-buy. Its own WSSI plans a four-week phase built around that reorder. Without this skill, Omar might treat the open-to-buy figure and the WSSI as two separate checks, missing a week where the WSSI's own intake requirement would use more of the remaining USD 14,000 than the season budget can actually support.

03Before you start

What you need, and what this lesson does not cover

You need: lessons T20-C02-L01 through T20-C02-L04, which build open-to-buy, the WSSI, forecast adjustment and commitment checks separately.

By the end of this lesson you can:

  • combine a season's own open-to-buy with its WSSI in one worksheet;
  • check that a WSSI's own planned intake, valued in money, still fits inside remaining open-to-buy;
  • read a hybrid plan that mixes a Make to Stock reorder with a Make to Order top-up;
  • identify the single week where a combined check would fail before it happens;
  • state the full set of figures a buyer reviews before confirming a season's own buying plan.

Not covered here: this is the course's final lesson; course T20-C03 moves to forecasting and phasing a season's sales in more detail.

04Key terms

Words you will meet in this lesson

TermMeaning
Open-to-buyA retailer's season budget minus its committed spend: the amount still available to commit to any range.
WSSIA weekly sales, stock and intake plan: the week-by-week table a retailer builds once open-to-buy is approved.
IntakeNew stock arriving into a retailer's own stockroom or distribution centre in a given week, from a confirmed order.
Hybrid selling modelA brand that sells through more than one route to market at once, for example wholesale and its own direct retail, often at different prices.
Committed spendThe value of purchase orders a retailer has already confirmed against its season budget.
Season budgetThe total amount a retailer plans to spend buying stock for one season, set before it sees every brand's final range.
05Teaching
The rule

A complete check combines open-to-buy and the WSSI so neither is approved without the other agreeing

A season's own buying plan is not complete until its open-to-buy figure and its WSSI agree with each other: the money the season budget allows must be enough to pay for the stock the WSSI's own intake plan says the retailer needs to arrive. Checking either one alone can miss a mismatch the other would have caught; a WSSI can plan an intake the remaining open-to-buy cannot actually afford, and an open-to-buy figure can look comfortable while ignoring which week the money is actually needed in.

Cedar & Co.'s own open-to-buy remaining after this season's reorder: 18,000 - 4,000 = USD 14,000
What you meet in real life

A combined open-to-buy and WSSI check behaves differently depending on how a retailer's buying is structured

A buyer meets several shapes of combined check across a normal working year, and reading each one correctly stops open-to-buy and the WSSI being approved as if they were unrelated numbers.

What can differThe shapes you will meetWhy it matters
A pure Make to Stock seasonA domestic retailer plans its entire WSSI against one forecast, reordering from Delta Garments only as stock runs down.Open-to-buy and the WSSI move together naturally, since every reorder in the WSSI is also a committed spend against open-to-buy.
A pure Make to Order seasonNorthline Apparel confirms Order A's own full run with Delta Garments once, then builds a WSSI around fixed delivery weeks.Open-to-buy is committed in full at confirmation; the WSSI then only has to match delivery weeks to the season's own sales plan.
A hybrid season, part reorder, part top-upCedar & Co. reorders against its own forecast, then adds a further Make to Order top-up once early sales beat forecast.Each part draws down the same open-to-buy separately, so the combined check must add both parts together, not treat them as two separate budgets.
A season nearing its own open-to-buy limitCedar & Co.'s remaining USD 14,000 open-to-buy is close to what a later WSSI week's own intake would cost.A combined check catches this before the week arrives; checking the WSSI alone, without open-to-buy, would miss it entirely.
The case we follow

Omar checks whether Cedar & Co.'s own WSSI, valued in money, still fits inside the season's remaining open-to-buy

Cedar & Co. has USD 14,000 of open-to-buy remaining after its earlier reorder. Its own WSSI for the season's next phase plans a further intake of 1,800 pieces at Cedar & Co.'s own buying cost of USD 8.00 per piece. Before confirming this phase with Delta Garments, Omar checks the intake's own money value against the open-to-buy that actually remains.

Cedar & Co.: open-to-buy compared with the WSSI's own planned intake valueOpen-to-buy, USD 14,000Planned intake value, USD 14,400Over by 400
The WSSI's own planned intake of 1,800 pieces is worth USD 14,400, USD 400 more than Cedar & Co.'s remaining open-to-buy. A WSSI that looks fine in pieces alone still has to be checked in money against open-to-buy.
The worked number

The WSSI's own planned intake, valued in money, is USD 400 more than the open-to-buy that remains

WSSI's own planned intake: 1,800 pieces
Value of that intake at USD 8.00 per piece: 1,800 x 8.00 = USD 14,400
Cedar & Co.'s own open-to-buy remaining: USD 14,000
Amount the WSSI's own intake exceeds open-to-buy by: 14,400 - 14,000 = USD 400

Cedar & Co. can reduce the planned intake to 1,750 pieces (USD 14,000 divided by USD 8.00), request a small season budget increase, or reallocate open-to-buy from a weaker style to cover the USD 400 gap. What a combined check makes clear is that this WSSI, exactly as planned in pieces, cannot be paid for entirely from the open-to-buy Cedar & Co. actually has left.

The method

Five steps a buyer follows to build one complete open-to-buy and WSSI check for a season

  1. Total the season budget and every committed spend, including any mid-season reorders, to find open-to-buy.
  2. Total the WSSI's own planned intake across the phase being checked, in pieces.
  3. Value that planned intake in money, at the buying cost per piece.
  4. Compare the intake's own money value against the open-to-buy that remains, not the piece count alone.
  5. Adjust the WSSI, the open-to-buy, or both together, until the two figures agree before confirming the phase with the factory.
The trap

A common mistake is approving a WSSI in pieces without checking whether its own money value still fits open-to-buy

A common mistake is a buyer approving a WSSI because its own piece counts look sensible against expected sales, without converting that plan into money and checking it against open-to-buy. A WSSI is a plan for stock, but stock still has to be paid for, and a plan that makes sense in pieces can still cost more than the season budget has left. What this costs a retailer that gets it wrong is real: Cedar & Co. could confirm the full 1,800-piece intake with Delta Garments, discover the USD 400 shortfall only once the invoice arrives, and be forced into exactly the kind of late, rushed budget request this whole course has shown how to avoid. The same mistake, repeated across every phase of a hybrid season without a combined check, quietly compounds; each phase's own small, unnoticed gap adds to the next, until a buyer who trusted piece counts alone finds the season's true open-to-buy already spent well before the season itself has ended.

Two approval methods compared against Cedar & Co.'s own USD 14,000 open-to-buyPieces checked alone: shortfall discovered only at invoice400 short, found lateMoney value checked against open-to-buy before confirmingGap found early
Checking the WSSI's own money value against open-to-buy before confirming catches the USD 400 gap while it can still be fixed. Approving pieces alone finds the same gap only once the factory's invoice arrives.
06In plain words

Open-to-buy and a WSSI are not two separate checks; they describe the same season's own money and stock, and a complete plan needs both to agree. A WSSI's own planned intake, valued in money at the buying cost per piece, has to fit inside the open-to-buy that actually remains once every reorder and top-up is counted. A buyer who checks piece counts against expected sales, without also checking their money value against open-to-buy, can approve a plan that looks sensible right up until the factory's own invoice shows it was not affordable.

07Quick check
  • A complete season check compares the WSSI's own planned intake, valued in money, against remaining open-to-buy.
  • Open-to-buy already reflects every committed spend, including mid-season reorders and top-ups.
  • A hybrid season draws down the same open-to-buy from more than one source, reorders and top-ups together.
  • A WSSI that looks sensible in pieces can still cost more than the season budget has left, once valued in money.
  • Reducing planned intake, increasing the season budget, or reallocating open-to-buy are all ways to close a gap.
  • Checking money value against open-to-buy before confirming with the factory catches a shortfall while it can still be fixed.
08Workplace scenario

Omar must decide how to close the gap between Cedar & Co.'s own WSSI and its remaining open-to-buy

Cedar & Co.'s WSSI plans an intake of 1,800 pieces for the season's next phase, worth USD 14,400 at Cedar & Co.'s own buying cost of USD 8.00 per piece. Cedar & Co. has USD 14,000 of open-to-buy remaining after its earlier reorder. Delta Garments needs Omar's decision this week to schedule cutting for the phase.

Here is the combined check Omar actually wrote before replying to Delta Garments:

Combined check. WSSI planned intake: 1,800 pieces. Value at USD 8.00 per piece: USD 14,400. Open-to-buy remaining: USD 14,000. Gap: USD 400. Delta Garments needs a decision this week.

Can Omar confirm the full 1,800-piece intake this week without any change? Decide before opening the answer.

Show decision

No, not without a change. Two figures in Omar's own combined check decide this.

First, the WSSI's own planned intake is worth USD 14,400. That is 1,800 pieces at Cedar & Co.'s own buying cost of USD 8.00 per piece.

Second, Cedar & Co.'s own open-to-buy remaining is USD 14,000. The planned intake's own money value is USD 400 more than that.

Omar's options are to reduce the confirmed intake to 1,750 pieces, so its money value fits exactly inside the USD 14,000 open-to-buy, to request a USD 400 season budget increase before replying to Delta Garments, or to reallocate USD 400 of open-to-buy from a weaker style already committed. Confirming the full 1,800 pieces without one of those three steps would overbuy Cedar & Co.'s own season budget by USD 400.

09What it costs

What confirming the full WSSI without checking open-to-buy would cost Cedar & Co.

Using this lesson's own illustrative figures:

WSSI's own planned intake value: USD 14,400
Cedar & Co.'s own open-to-buy remaining: USD 14,000
Amount the season budget would be overbought by, if confirmed in full: 14,400 - 14,000 = USD 400

A USD 400 overbuy against a USD 40,000 season budget is a 1% overrun, small enough that it could easily be missed if the WSSI and open-to-buy are never checked against each other. Across a season with several such phases, each carrying its own small, unchecked gap, the combined overrun can grow into a real shortfall discovered only when the season's own open-to-buy runs out earlier than planned.

10Working template

Open-to-buy and WSSI worksheet: the complete check that combines both sheets into one season view

Open the course workbook's "Complete profitability" sheet, which draws figures from the "Open-to-buy" and "WSSI" sheets into one combined check: it values the WSSI's own planned intake in money and compares that value against remaining open-to-buy automatically, flagging any phase that does not fit before the factory is asked to confirm anything.

[Download the Open-to-buy and WSSI worksheet](../../templates/T20-C02-open-to-buy-and-wssi-worksheet.xlsx)

Download the Open-to-buy and WSSI worksheet (Excel)

11Check yourself

1. Why is a WSSI checked against open-to-buy in money, not only in pieces?

2. A WSSI plans an intake of 900 pieces at a buying cost of USD 6.00 per piece. Open-to-buy remaining is USD 5,000. Does the plan fit?

12Glossary
ENARFRTRMeaning
Open-to-buyالرصيد المتاح للشراءBudget disponible (open-to-buy)Alıma açık bütçe (open-to-buy)A retailer's season budget minus its committed spend: the amount still available to commit to any range.
WSSIWSSIPlan hebdomadaire ventes, stock et réassort (WSSI)WSSIA weekly sales, stock and intake plan: the week-by-week table a retailer builds once open-to-buy is approved.
IntakeالواردArrivageMal girişi (intake)New stock arriving into a retailer's own stockroom or distribution centre in a given week, from a confirmed order.
Hybrid selling modelنموذج بيع مختلطModèle de vente hybrideKarma satış modeliA brand that sells through more than one route to market at once, for example wholesale and its own direct retail, often at different prices.
Committed spendالإنفاق الملتزم بهDépenses engagéesTaahhüt edilen harcamaThe value of purchase orders a retailer has already confirmed against its season budget.
Season budgetميزانية الموسمBudget de saisonSezon bütçesiThe total amount a retailer plans to spend buying stock for one season, set before it sees every brand's final range.
13Next

Lesson 3.1: Forecasting a style's own sales from history, not guesswork

This is the last lesson of Course 2. You can now check open-to-buy and a WSSI together as one plan. The next course moves to building the sales forecast that a WSSI's own planned sales come from. Back to the course map

14Ladder

RecognizeTell a WSSI checked in pieces alone apart from one checked in money against open-to-buy.
ConnectSee how a hybrid season's reorders and top-ups all draw down the same open-to-buy.
CompareWeigh a WSSI's own planned intake value against the open-to-buy that actually remains.
DecideJudge whether a season's own combined plan can be confirmed, adjusted, or needs more budget.