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

Reading terminal stock and what it says about a season's own planning

Level: PractitionerTime: 45 minutesOrder used: domestic (Cedar & Co.'s own illustrative T-shirt style, Make to Stock from its own forecast, bought from Delta Garments on 60-day open account)Tool: Markdown and terminal stock worksheet
For a domestic buyer or planner reading a season's own end-of-season stock to judge whether the original buy was right. You need lesson T20-C04-L01. Figures are Cedar & Co.'s own clearly-labelled illustrative domestic figures, not the fixed master export orders.
BuyerCedar & Co., Make to Stock
StyleDomestic T-shirt, 6,000 pieces from Delta Garments
Cost and shop priceCost USD 6.50, shop price USD 14.90
Season end5,250 sold, 750 still unsold
TargetNo more than 5% unsold at season end
What this lesson measuresWhat unsold season-end stock says about the original buy's own accuracy
02Opening

This page explains how to read the stock still unsold at the end of a season as feedback on the accuracy of the original buy

This page is for a domestic buyer or planner closing out a season who must judge what the stock still on the shelf actually says. At work, a person can treat unsold stock at season end only as a clearance problem to mark down and forget, without asking what it reveals about how the original buy was set. This lesson mainly teaches the information flow: it works out, using Cedar & Co.'s own illustrative domestic figures, exactly how much a season's own leftover stock says the original buy overshot actual demand.

Cedar & Co. buys 6,000 pieces of a domestic T-shirt style from Delta Garments, on its own forecast, for its own 12 shops. When the season closes, 750 pieces remain unsold. Read on its own, that number only says stock is left; read against the target and the actual demand the season revealed, it says how much the next buy should change. Without this skill, a buyer repeats the same overbuy every season, discovering it only after the stock has already piled up.

03Before you start

What you need, and what this lesson does not cover

You need: lesson T20-C04-L01, which shows how to calculate a sell-through rate and compare it against a target.

By the end of this lesson you can:

  • calculate the stock still unsold at the end of a season as a rate against the total units bought;
  • compare that rate against a target to judge whether the original buy overshot actual demand;
  • calculate the buy quantity that would have hit the target, given the demand the season actually revealed;
  • state why end-of-season stock is a different measurement from a mid-season sell-through check;
  • avoid treating end-of-season stock only as something to clear, without feeding it back into the next buy.

Not covered here: how to recover value from stock, or the raw material behind it, once it will not sell as first planned, covered in the next lesson of this course (lesson T20-C04-L04).

04Key terms

Words you will meet in this lesson

TermMeaning
Sell-through rateThe share of stock actually sold within a planned period, used to judge whether a forecast was right.
ForecastA company's own estimate of what it expects to sell, used to decide how much to produce before any specific sale exists.
Stock coverThe number of weeks a brand's current stock is expected to last before it runs out, given its normal sales rate.
MarginProfit divided by the selling price, shown as a percentage of what a company sells for.
Shop priceThe price the customer pays at the till. Also called the retail price.
05Teaching
The rule

The stock still unsold when a season closes, measured as a share of the total units bought, tells a buyer how far the original buy overshot actual demand

Stock still unsold at the end of a planned selling season is a different measurement from a mid-season sell-through check: it is the season's own final verdict, not a projection. Measured as a rate, units still unsold divided by units originally bought, it can be compared directly against a target rate a buyer sets for how much leftover stock a normal season should carry. A rate above that target does not just mean stock needs clearing; it means the buy itself was set higher than actual demand supported, and the next buy for that style should be corrected down.

Cedar & Co.'s own end-of-season stock rate on its domestic T-shirt style: 750 / 6,000 = 12.5%
What you meet in real life

End-of-season stock takes different shapes depending on the order's own model and how it was bought

A buyer meets several shapes of this measurement across a normal working year, and each depends on how the style was bought and replenished.

What can differThe shapes you will meetWhy it matters
Domestic Make to Stock style bought against a standing forecastCedar & Co. buys its own T-shirt style once against a forecast, and whatever remains when the season closes is the full end-of-season stock.A single forecast-based buy carries the whole risk of an inaccurate forecast, with no later shipment to correct it before season end.
Export hybrid order with pre-booked and replenishment volumeAn export buyer such as Fairway Stores can trim an order's own replenishment portion mid-season, so end-of-season stock reflects a partly corrected buy, not the original forecast alone.A hybrid order's end-of-season stock rate is a weaker signal of the original forecast's own accuracy, since part of the buy was already adjusted.
A style restocked continuously from a rolling standing forecastA core style with its own continuous replenishment cycle has no single season end at all, so end-of-season stock does not apply to it in the same way.Not every style closes a season; a continuously restocked style is judged on its own stock cover, not an end-of-season rate.
A style deliberately overbought to guarantee availability for a key accountA buyer may accept a higher end-of-season stock rate on purpose for a style it cannot risk running out of for an important customer.A high end-of-season stock rate is not automatically a mistake; it can be a deliberate trade-off the buyer should record as such, not confuse with a genuine forecast error.
The case we follow

Cedar & Co. closes its own domestic T-shirt style's season with 750 of 6,000 pieces still unsold

Cedar & Co. buys 6,000 pieces of a domestic T-shirt style from Delta Garments on its own forecast, at a cost of USD 6.50 a piece, selling at a shop price of USD 14.90. Cedar & Co.'s own target is no more than 5% of units bought left unsold at season end. When the season closes, 5,250 pieces have sold and 750 remain.

Cedar & Co.'s own buy at season end: pieces sold compared with pieces still unsold5,250 pieces sold750 left
750 of the 6,000 pieces bought are still unsold when the season closes. On its own, this number only says stock is left; the target rate is what turns it into a verdict on the original buy.
The worked number

Comparing the end-of-season stock rate against the target, and calculating the buy that would have hit it

Cedar & Co.'s own end-of-season stock rate: 750 / 6,000 = 12.5%
The buy quantity that would have hit Cedar & Co.'s own 5% target, given the 5,250 pieces actual demand revealed: 5,250 / (1 - 5%) = 5,526 pieces
Units Cedar & Co. bought beyond that corrected quantity: 6,000 - 5,526 = 474 pieces

Cedar & Co.'s own 12.5% end-of-season stock rate is more than double its own 5% target, and the corrected buy calculation shows the original order overshot actual demand by about 474 pieces. That gap, not the raw 750 pieces left over, is the number that should adjust the next season's own buy for this style.

The method

Four steps to read a season's own end-of-season stock as feedback on the original buy

  1. Record the total units bought and the units actually sold by the time the season closes.
  2. Calculate the end-of-season stock rate as units unsold divided by units bought.
  3. Compare that rate against a target rate the buyer sets for a normal season.
  4. Calculate the buy quantity that would have hit the target, given the demand the season actually revealed, and use the gap to correct the next buy.
The trap

A common mistake is treating end-of-season stock only as something to clear, without feeding it back into the next buy

A common mistake is marking down the stock left at season end and moving on, without asking what the leftover quantity says about the accuracy of the original buy. What this costs a buyer who gets it wrong is a repeated overbuy: the same style, or a similar one, is bought at the same inflated quantity next season, and the same share ends up unsold again, season after season, because the forecast error was never actually corrected. A related mistake is treating every high end-of-season stock rate as a forecast failure, without checking whether it was a deliberate trade-off to guarantee availability.

Actual buy compared with the buy the season's own demand actually supportedActual buy, repeated unchanged next season6,000 pieces boughtCorrected buy, matching the season's own actual demand5,526 pieces bought
Repeating the unchanged 6,000-piece buy next season would repeat the same overbuy. The corrected 5,526-piece buy is what the season's own actual demand, not the original forecast, actually supported.
06In plain words

Stock still unsold when a season closes is the season's own final verdict on the original buy, not just something left to clear. Measured as a rate against the total units bought and compared against a target, it shows how far the buy overshot the demand the season actually revealed. The corrected buy quantity for next time is calculated from the actual demand, not the original forecast, and the gap between the two is what should change. Treating leftover stock only as a clearance problem, without feeding that gap back into the next buy, repeats the same overbuy every season.

07Quick check
  • End-of-season stock rate is units still unsold divided by units originally bought.
  • A rate above a buyer's own target signals the original buy overshot actual demand.
  • The corrected buy quantity is calculated from the demand the season actually revealed, not the original forecast.
  • End-of-season stock is a season's own final verdict, different from a mid-season sell-through check.
  • A rolling replenishment style has no single season end, so this measurement does not apply to it.
  • A high end-of-season stock rate can be a deliberate trade-off for availability, not always a forecast error.
08Workplace scenario

Omar, the owner of Cedar & Co., reviews the season-end stock report and asks whether next season's buy should change

At season end, Cedar & Co.'s planner brings Omar the closing report on the domestic T-shirt style. A junior colleague has already suggested simply marking down the 750 remaining pieces and repeating the same 6,000-piece buy next season, since the style still sold reasonably well overall.

  • Cedar & Co. bought 6,000 pieces; 5,250 sold; 750 remain unsold at season end, a 12.5% end-of-season stock rate.
  • Cedar & Co.'s own target for this kind of style is no more than 5% left unsold at season end.
  • The buy quantity that would have hit the 5% target, given the 5,250 pieces of actual demand, is 5,526 pieces.
  • Repeating the unchanged 6,000-piece buy next season would repeat the same roughly 474-piece overbuy, assuming similar demand.

Here is the closing report line the planner actually brought to Omar:

Season-end stock report, domestic T-shirt style. Bought 6,000 pieces. Sold 5,250. Unsold at season end: 750 (12.5%). Target: 5% or below. Recommendation needed on next season's own buy quantity for this style.

Should Cedar & Co. reduce next season's buy for this style, and if so, to what quantity? Decide before opening the answer.

Show decision

Yes, reduce the buy to about 5,526 pieces, not repeat 6,000. Two facts already in the report decide this.

First, the 12.5% end-of-season stock rate is more than double Cedar & Co.'s own 5% target. A gap this size is not ordinary season-to-season variation; it is a signal that the original 6,000-piece buy was set well above what the season's own actual demand supported.

Second, the corrected quantity is calculated directly from the demand the season actually revealed, 5,250 pieces sold, not from the original forecast that produced the 6,000-piece buy. Repeating the unchanged 6,000-piece buy would repeat the same overbuy, assuming similar demand next season, and leave the same roughly 474 pieces unsold again.

Cedar & Co. should set next season's buy at about 5,526 pieces for this style, using the season's own actual demand as the corrected basis, rather than marking down the leftover stock and repeating the original forecast unchanged.

09What it costs

What the uncorrected overbuy ties up in stock value, compared with the corrected buy

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

Cost price value of Cedar & Co.'s own actual 750-piece terminal stock: 750 x 6.50 = USD 4,875
Units still unsold under the corrected 5,526-piece buy, at the same 5% target rate: 5,526 x 5% = 276 pieces
Cost price value of that corrected, smaller leftover stock: 276 x 6.50 = USD 1,794
Extra cash Cedar & Co. ties up in stock by repeating the uncorrected 6,000-piece buy: 4,875 - 1,794 = USD 3,081

Repeating the uncorrected buy ties up an extra USD 3,081 in unsold stock compared with the corrected buy, cash that stays on the shelf instead of funding the next season's own new styles.

10Working template

Markdown and terminal stock worksheet: turn end-of-season stock into a corrected buy quantity

Open the course workbook's "Terminal stock" sheet. It records units bought and units sold by season end, calculates the end-of-season stock rate against a target, and works out the buy quantity that would have hit the target given the demand the season actually revealed.

[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. An export style was bought at 4,000 pieces; 3,760 sold by season end, leaving 240 unsold. The buyer's own target is 4% left unsold. Does this style's end-of-season stock signal an overbuy?

2. Why is end-of-season stock a different measurement from the mid-season sell-through check covered in lesson T20-C04-L01?

12Glossary
ENARFRTRMeaning
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.
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.
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.
MarginالهامشMargeMarjProfit divided by the selling price, shown as a percentage of what a company sells for.
Shop priceسعر المحلPrix boutique (prix de détail)Mağaza fiyatıThe price the customer pays at the till. Also called the retail price.
13Next

Lesson 4.4: Recovering value from stock that did not sell as planned

You now know how to read the stock still unsold at season end as feedback on a buy's own accuracy. The next lesson looks at how to recover value from stock, or the raw material behind it, once it is clear it will not sell as first planned. Back to the course map

14Ladder

RecognizeTell a season's own final end-of-season stock rate apart from a mid-season sell-through check.
ConnectSee how the end-of-season stock rate turns into a corrected buy quantity for next time.
CompareWeigh the cash tied up by an uncorrected buy against the cash the corrected buy would tie up.
DecideJudge how much Cedar & Co. should change next season's buy for its own T-shirt style.