Course contents
Practitioner · Course 4: Markdown, Promotion and Terminal Stock · Lesson 5 of 5

Building a complete markdown and terminal stock worksheet

Level: PractitionerTime: 45 minutesOrder used: domestic (Cedar & Co.'s own illustrative T-shirt style, combining a forecast-based buy with a smaller replenishment order)Tool: Markdown and terminal stock worksheet
For a buyer or planner assembling markdown timing, promotion sizing and terminal stock into one complete check for a single style. You need lessons T20-C04-L01 through L04. Figures are Cedar & Co.'s own clearly-labelled illustrative domestic figures.
BuyerCedar & Co.
StyleDomestic T-shirt, hybrid: 6,000 forecast plus 1,000 replenishment
Cost and shop priceCost USD 6.50, shop price USD 14.90
Midpoint checkpoint3,000 of 7,000 sold, behind the 3,500 planned
What this lesson measuresHow the four checks combine into one buy-and-pricing decision for a single style
02Opening

This page explains how a buyer brings markdown timing, promotion sizing and terminal stock together into one check for a single style

This page is for a buyer or planner who must judge a single style's own health across a season, not just one number in isolation. At work, a person can check sell-through, or a promotion's own profit, or end-of-season stock, each in a separate spreadsheet, without seeing how they fit together into one decision for the same style. This lesson mainly teaches the money flow: it brings Cedar & Co.'s own hybrid domestic style through all four checks from this course, in order, on one worksheet.

Cedar & Co. buys a domestic T-shirt style with a hybrid structure: 6,000 pieces against its own forecast, plus a smaller 1,000-piece replenishment order held back until early sales are known. This lesson follows that style from its midpoint sell-through check, through a possible promotion, to its own markdown decision, and finally to its end-of-season stock. Without this skill, a buyer treats each of these checks as a separate task instead of one connected story about a single style.

03Before you start

What you need, and what this lesson does not cover

You need: lessons T20-C04-L01 through L04, which cover markdown timing, promotion sizing, terminal stock and recovering value from unused material separately.

By the end of this lesson you can:

  • run a style through all four checks from this course, in the right order, on one worksheet;
  • decide, at a midpoint checkpoint, whether a style needs a markdown, a promotion, or neither;
  • carry a style's own hybrid replenishment decision through to its end-of-season stock rate;
  • state how the four checks depend on each other rather than standing alone;
  • avoid treating a single style's own season as four unrelated numbers instead of one connected story.

Not covered here: this is the final lesson of Course 4; Course 5 moves upstream to how a retail price is first set.

04Key terms

Words you will meet in this lesson

TermMeaning
MarkdownA reduction in the shop price of goods that have not sold as forecast, used to clear the remaining stock.
Sell-through rateThe share of stock actually sold within a planned period, used to judge whether a forecast was right.
Stock coverThe number of weeks a brand's current stock is expected to last before it runs out, given its normal sales rate.
Open-to-buyA retailer's season budget minus its committed spend: the amount still available to commit to any range.
MarginProfit divided by the selling price, shown as a percentage of what a company sells for.
ForecastA company's own estimate of what it expects to sell, used to decide how much to produce before any specific sale exists.
05Teaching
The rule

A single style's own season is one connected story: a midpoint check decides on a markdown or promotion, and a hybrid buy's own replenishment decision feeds directly into its end-of-season stock

The four checks from this course are not four separate tools for four separate styles; they are four points on the same style's own timeline. A midpoint sell-through check decides whether a style needs a markdown or could instead support a promotion. For a hybrid style, that same checkpoint also decides how much of the remaining replenishment to commit. Whatever is bought or held back then shapes the end-of-season stock rate that finally judges the whole season's own buy.

Cedar & Co.'s own sell-through at the midpoint of its hybrid T-shirt style: 3,000 / 7,000 = 43%
What you meet in real life

A complete worksheet takes different shapes depending on how many checks a single style's own season actually needs

A buyer meets several shapes of this combined check across a normal working year, and each depends on how far behind or ahead of plan a style runs.

What can differThe shapes you will meetWhy it matters
A style that stays on plan all seasonSell-through tracks the target closely throughout; no markdown or promotion is needed, and the replenishment order runs as planned.Not every style needs all four checks in a single season; a healthy style may only need the final end-of-season stock check.
A style behind plan at the midpointThe midpoint check triggers a markdown decision, as in lesson T20-C04-L01, and the replenishment portion is trimmed to reduce further risk.A markdown decision and a hybrid replenishment decision are made from the same midpoint numbers, not as two separate exercises.
A style on plan but with room to growThe midpoint check instead supports a promotion, as in lesson T20-C04-L02, to build extra volume while sell-through is still healthy.The same checkpoint that could trigger a markdown can instead support a promotion, depending on which side of the target the style sits.
A style with unused raw material once replenishment is trimmedCutting the replenishment portion, as in lesson T20-C04-L04, can leave a mill holding material that still needs a recovery decision.A single buyer's own mid-season decision can create a recovery decision further up the chain, showing how connected the four checks really are.
The case we follow

Cedar & Co. checks its hybrid T-shirt style at the midpoint and carries the result through to the end of the season

Cedar & Co. buys 6,000 pieces of a domestic T-shirt style against its own forecast, plus a 1,000-piece replenishment order held back until early sales are known, a hybrid total of 7,000 pieces if the replenishment is fully committed. At the midpoint, 3,000 pieces have sold against a planned 3,500, a sell-through of 43% versus a 50% target.

Cedar & Co.'s own hybrid style at the midpoint: sold compared with plannedPlanned: 3,500 pieces (50%)Actual: 3,000 pieces (43%)
Cedar & Co.'s own style is 7 percentage points behind its midpoint target. The worksheet's next step decides what that gap means for the replenishment order and for a possible markdown.
The worked number

Carrying the midpoint result through the replenishment decision to the end-of-season stock rate

Cedar & Co.'s own decision on the 1,000-piece replenishment, trimmed by half given the weak midpoint sell-through: 1,000 x 50% = 500 pieces committed
Cedar & Co.'s own revised total buy: 6,000 + 500 = 6,500 pieces
Assuming the same pace continues, Cedar & Co.'s own projected pieces sold by season end: 3,000 x 2 = 6,000 pieces
Cedar & Co.'s own projected end-of-season stock rate on the revised 6,500-piece buy: (6,500 - 6,000) / 6,500 = 7.7%

Trimming the replenishment order to 500 pieces, based on the weak midpoint check, brings the projected end-of-season stock rate down to 7.7%, closer to Cedar & Co.'s own 5% target than the 12.5% the uncorrected buy produced in lesson T20-C04-L03. The four checks work together: the midpoint sell-through informs the replenishment decision, and the replenishment decision shapes the final end-of-season stock rate.

The method

Five steps to run a single style through all four checks on one complete worksheet

  1. Check sell-through at the midpoint against the planned target, as in lesson T20-C04-L01.
  2. Decide whether the midpoint gap calls for a markdown, as in lesson T20-C04-L01, or supports a promotion, as in lesson T20-C04-L02.
  3. Commit or trim any remaining hybrid replenishment based on that same midpoint result.
  4. Recover value from any raw material left unused if the replenishment is trimmed, as in lesson T20-C04-L04.
  5. Calculate the projected end-of-season stock rate on the revised total buy, as in lesson T20-C04-L03, to judge the whole season.
The trap

A common mistake is running each of the four checks in isolation, without carrying one result into the next

A common mistake is treating sell-through, promotion sizing, replenishment and end-of-season stock as four separate exercises on four separate days, rather than one connected worksheet. What this costs a buyer who gets it wrong is a missed correction: a markdown decision made without also trimming the hybrid replenishment repeats the same overbuy the markdown was meant to fix, and an end-of-season stock check run without any reference at all to the midpoint decision cannot properly explain why the season ended the way it did. The four checks are only as useful as the connections a buyer actually draws between them, on one worksheet rather than four separate ones.

End-of-season stock rate with the connected worksheet compared with an unconnected buyConnected worksheet: replenishment trimmed at the midpoint7.7% end-of-season stock rateUnconnected buy: replenishment left unchanged12.5% end-of-season stock rate
Connecting the midpoint check to the replenishment decision nearly halves the end-of-season stock rate. Running the checks in isolation would have missed this correction entirely.
06In plain words

A single style's own season is one connected story, not four separate numbers. A midpoint sell-through check decides on a markdown or a promotion, and for a hybrid style, that same check decides how much replenishment to commit. Whatever is bought then shapes the end-of-season stock rate that judges the whole season. Running each check in isolation, without carrying one result into the next, misses corrections a buyer could otherwise make in time, such as trimming a replenishment order before it becomes next season's own overbuy.

07Quick check
  • A midpoint sell-through check decides between a markdown, a promotion, or no action at all.
  • For a hybrid style, the same midpoint result also decides how much replenishment to commit.
  • Trimming replenishment based on a weak midpoint check lowers the projected end-of-season stock rate.
  • Cutting replenishment can create a recovery decision further up the chain, for a mill or factory.
  • The four checks from this course connect into one worksheet, not four separate exercises.
  • Running the checks in isolation misses corrections a connected worksheet would catch.
08Workplace scenario

Cedar & Co.'s planner asks whether the replenishment order should still go ahead in full after the weak midpoint check

At the midpoint, Cedar & Co.'s domestic T-shirt style is behind plan. A junior colleague has already placed the 1,000-piece replenishment order in full, arguing that the original forecast should be trusted until the season actually ends.

  • Cedar & Co.'s style: 3,000 of 7,000 possible pieces sold at the midpoint (43%), against a planned 3,500 (50%).
  • A full 1,000-piece replenishment would bring the total buy to 7,000 pieces.
  • At the current pace, Cedar & Co. projects about 6,000 pieces sold by season end.
  • Trimming the replenishment to 500 pieces would bring the projected end-of-season stock rate to 7.7%, against 12.5% if the full 1,000 pieces are committed.

Here is the note the planner actually sent Cedar & Co.'s buyer:

Replenishment decision note. Midpoint sell-through 43%, against a planned 50%. Full 1,000-piece replenishment already placed. Recommend review before shipment: trimmed replenishment would lower the projected end-of-season stock rate from 12.5% to 7.7%.

Should Cedar & Co. reduce the replenishment order now, before it ships, or let the full 1,000 pieces go ahead as already placed? Decide before opening the answer.

Show decision

Reduce the replenishment order to about 500 pieces before it ships. Two facts already in the note decide this.

First, the midpoint sell-through of 43% is already behind the 50% target, the same signal that triggers a markdown or a replenishment review in lesson T20-C04-L01. Trusting the original forecast without adjustment ignores exactly the information a midpoint check exists to provide.

Second, the trimmed replenishment brings the projected end-of-season stock rate down to 7.7%, much closer to Cedar & Co.'s own 5% target than the 12.5% a full, unadjusted replenishment would produce. The correction is available now, before shipment, at no extra cost beyond adjusting a quantity not yet shipped.

Cedar & Co. should reduce the replenishment order to about 500 pieces now, using the midpoint check to correct the buy while there is still time, rather than letting the original forecast run unchecked to season end.

09What it costs

What letting the full replenishment ship instead of trimming it would cost Cedar & Co. in tied-up stock value

Using Cedar & Co.'s own illustrative cost price of USD 6.50 a piece:

Projected end-of-season stock under the trimmed 6,500-piece buy: 6,500 - 6,000 = 500 pieces
Projected end-of-season stock under the full, unadjusted 7,000-piece buy, at the same 6,000 pieces sold: 7,000 - 6,000 = 1,000 pieces
Extra pieces left unsold if the replenishment ships in full instead of being trimmed: 1,000 - 500 = 500 pieces
Cost price value of those extra unsold pieces: 500 x 6.50 = USD 3,250

Letting the full replenishment ship unadjusted would leave an extra USD 3,250 tied up in unsold stock compared with trimming it at the midpoint, cash that the connected worksheet would have protected.

10Working template

Markdown and terminal stock worksheet: run one style through all four checks in order

Open the course workbook's "Complete check" sheet. It draws the midpoint sell-through, the markdown or promotion decision, the replenishment commitment and the projected end-of-season stock rate into one row per style, so a buyer sees the whole season's own story at once.

[Download the Markdown and terminal stock worksheet](../../templates/T20-C04-markdown-and-terminal-stock-worksheet.xlsx)

Download the Markdown and terminal stock worksheet (Excel)

11Check yourself

1. A hybrid style has a 4,000-piece forecast buy plus an 800-piece replenishment option. At the midpoint, 1,600 of the 4,000 forecast pieces have sold, against a planned 2,000. Should the full replenishment ship?

2. Why do the four checks from this course need to be connected on one worksheet rather than run as separate exercises?

12Glossary
ENARFRTRMeaning
Markdownتخفيض السعرDémarqueİndirim (markdown)A reduction in the shop price of goods that have not sold as forecast, used to clear the remaining stock.
Sell-through rateمعدل البيع الفعليTaux d'écoulementSatış oranıThe share of stock actually sold within a planned period, used to judge whether a forecast was right.
Stock coverتغطية المخزونCouverture de stockStok kapsama süresiThe number of weeks a brand's current stock is expected to last before it runs out, given its normal sales rate.
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.
MarginالهامشMargeMarjProfit divided by the selling price, shown as a percentage of what a company sells for.
Forecastالتوقع (توقع المبيعات)Prévision (prévision des ventes)Tahmin (satış tahmini)A company's own estimate of what it expects to sell, used to decide how much to produce before any specific sale exists.
13Next

Setting an initial retail price that supports the season's own margin target

You now know how to bring markdown timing, promotion sizing and terminal stock together for one style. Course 5 moves upstream, to how a retail price is first set so it can support the whole chain you have just learned to manage. Back to the course map

14Ladder

RecognizeTell a connected worksheet decision apart from four isolated checks on the same style.
ConnectSee how a midpoint sell-through check feeds into a hybrid replenishment decision.
CompareWeigh the end-of-season stock rate a connected worksheet produces against an unconnected buy.
DecideJudge whether Cedar & Co. should trim its own replenishment order before it ships.