Course contents
Practitioner · Course 1: Retail Maths · Lesson 5 of 5

Building a complete retail maths reference sheet

Level: FoundationTime: 45 minutesOrder used: A (the T-shirt, sourced directly from Delta Garments by Cedar & Co., sold through its own shops and wholesale to smaller local shops)Tool: Retail maths reference workbook
For a buyer, retail planner, or new entrant to retail who needs to assemble margin, markup, sell-through rate, stock cover, average selling price and like-for-like growth into one complete reference sheet for a single style. Lessons T20-C01-L01 to L04 are useful but not required. Figures are teaching examples in US dollars.
FactoryDelta Garments
Domestic orderSame 15,000-piece T-shirt style, bought at FOB USD 3.20
Domestic buyerCedar & Co., 12 shops plus wholesale (hybrid)
Shop priceUSD 19.90, Cedar & Co.'s own shop price
Season outcome15,000 of 15,000 pieces sold: 12,000 full price, 3,000 markdown
What this lesson measuresAll six calculations assembled into one sheet
02Opening

This page explains how to assemble margin, markup, sell-through rate, stock cover, average selling price and like-for-like growth into one complete reference sheet for a single style

This page is for a buyer, a retail planner, or a new entrant to retail who needs every retail calculation from this course sitting together against one style, so that no single figure has to be looked up from a separate note. This lesson mainly teaches the money flow: it takes Cedar & Co.'s own hybrid domestic business, its 12 own shops together with wholesale sales to smaller local shops, and closes out a full season with all six calculations recorded in one place.

Cedar & Co. buys the same 15,000-piece T-shirt style directly from Delta Garments at FOB USD 3.20 and sells it at its own shop price of USD 19.90, both through its own 12 shops and wholesale to a small number of local shops, a hybrid selling model. By the end of the season, every piece has sold. A buyer closing out this style needs margin, markup, sell-through rate, stock cover, average selling price and like-for-like growth all in one place to write a season report that stands on its own.

03Before you start

What you need, and what this lesson does not cover

You need: no previous lesson, though lessons T20-C01-L01 to T20-C01-L04 cover each calculation in this lesson in more depth and are a useful start. Order A's own fixed FOB price of USD 3.20 and Cedar & Co.'s own shop price of USD 19.90 are enough to begin.

By the end of this lesson you can:

  • list all six retail maths calculations covered across this course and the single question each one answers;
  • calculate all six on one style from a single season's own closing sales data;
  • assemble the six calculations into one reference sheet that closes out a season without needing a separate note for any single figure;
  • explain why a hybrid selling model still uses the exact same six calculations as a wholesale-only or shop-only business;
  • state which of the six calculations change during a season and which stay fixed once cost and shop price are set.

Not covered here: any new calculation beyond the five introduced in lessons T20-C01-L01 to T20-C01-L04; this lesson only assembles them together.

04Key terms

Words you will meet in this lesson

TermMeaning
MarginProfit divided by the selling price, shown as a percentage of what a company sells for.
MarkupProfit divided by the cost, shown as a percentage of what a company paid.
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.
Average selling priceThe total money taken from a style's sales divided by the number of pieces sold, once full-price and markdown sales are both counted.
Like-for-like growthThe change in sales of the same style, in the same set of stores, between two comparable periods, excluding any stores opened or closed since the last comparison.
05Teaching
The rule

A complete reference sheet records all six calculations from one closing set of sales data, so a season report never needs a second document

Margin, markup, sell-through rate, stock cover, average selling price and like-for-like growth can all be calculated from the same small set of closing figures: cost, shop price, order quantity, pieces sold at each price, weeks elapsed, and a comparable earlier period's own pieces sold in the same store base. A complete reference sheet lays out all six side by side, so a buyer closing a season never has to search a separate note to answer a question one of the other five could have answered from the start.

Cedar & Co.'s own margin, unchanged since lesson T20-C01-L03: 16.70 / 19.90 = 83.9%
What you meet in real life

The same six calculations apply whether a business sells through one route to market or several at once

What can differThe shapes you will meetWhy it matters
A hybrid domestic business selling through its own shops and wholesale togetherCedar & Co. sells the same style through its own 12 shops and wholesale to smaller local shops, but calculates margin, markup and average selling price once against its own selling price, since the hybrid model does not change the calculations themselves.A hybrid selling model changes how many routes a buyer must track sell-through rate and like-for-like growth across, but not the underlying formula for any of the six calculations.
An export retailer buying wholesale, as covered earlier in this courseFairway Stores buys Order A wholesale from Northline Apparel and runs the same six calculations against its own higher cost and identical shop price.The same six-part reference sheet applies to an export retailer exactly as it does to a domestic hybrid buyer, once each company's own cost and selling price are entered.
A season that closes with all stock sold, no leftoverCedar & Co.'s season on this style closes with all 15,000 pieces sold, giving a sell-through rate of 100% and a stock cover of zero weeks remaining.A sell-through rate of 100% at season close is the sign of a season that matched its own forecast, worth recording as a benchmark for planning the next season's order quantity.
A season compared against the previous year for like-for-like growthCedar & Co. compares this season's total of 15,000 pieces sold in its own 12 shops against 13,500 pieces of a comparable style sold in the same 12 shops last season.Like-for-like growth belongs on the same reference sheet as the other five calculations, since a buyer closing a season needs to know both how the season performed and how it compares with the year before.
The case we follow

Cedar & Co. closes its season on the domestic hybrid T-shirt style and completes a full six-part reference sheet

Cedar & Co. buys the full 15,000 pieces directly from Delta Garments at USD 3.20 per piece and sells at its own shop price of USD 19.90 across its 12 own shops and wholesale to smaller local shops. By season close, all 15,000 pieces have sold: 12,000 at the full shop price and 3,000 at a markdown price of USD 15.92. In its own 12 shops alone, Cedar & Co. sold a comparable style last season at 13,500 pieces over the same period, illustrative sales figures kept for teaching purposes only. Cedar & Co.'s own buyer pulls every figure from this one season into a single reference sheet.

Cedar & Co., complete reference sheet, season closeMargin 83.9% Markup 521.9% Sell-through 100.0%Stock cover 0.0 weeks Average selling price USD 19.10Like-for-like growth, own shops: 11.1%
All six calculations from the course sit on one reference sheet for the same style. A buyer reading this sheet can answer any of the six questions without opening a second document.
The worked number

All six calculations, assembled from one season's own closing figures

Margin: (19.90 - 3.20) / 19.90 = 83.9%
Markup: (19.90 - 3.20) / 3.20 = 521.9%
Sell-through rate at season close: 15,000 / 15,000 = 100.0%
Stock cover once all stock is sold: 0 / (15,000 / 20) = 0.0 weeks
Average selling price: (12,000 x 19.90 + 3,000 x 15.92) / 15,000 = USD 19.10
Like-for-like growth in Cedar & Co.'s own 12 shops: (15,000 - 13,500) / 13,500 = 11.1%

Every one of the six figures comes from the same season's own closing data, and each answers a different question a buyer needs closed out: how much profit against cost and against selling price, how completely the stock sold, how many weeks of cover remain, what customers actually paid on average, and how this season compares with the last one in the same shops.

The method

Six steps to build a complete reference sheet at season close

  1. Record the style's own cost and shop price, then calculate margin and markup from them.
  2. Record the order quantity and total pieces sold, then calculate sell-through rate.
  3. Record weeks elapsed and remaining stock, then calculate stock cover.
  4. Record pieces sold at each price charged, then calculate average selling price.
  5. Record the same style's own pieces sold in the same store base last season, then calculate like-for-like growth.
  6. Assemble all six figures on one sheet so the season can be closed without a second document.
The trap

A common mistake is closing a season report with only two or three of the six calculations, leaving the reference sheet incomplete for the next buyer who reads it

A common mistake is recording margin, markup and sell-through rate at season close, since those three are the easiest to reach for, and leaving out stock cover, average selling price and like-for-like growth simply because the season has already ended and the season itself feels finished. A season report missing average selling price hides how much markdown activity actually happened; a report missing like-for-like growth leaves the next buyer unable to judge whether the season's order quantity should rise or fall for next year. What this costs a buying team is real: a buyer planning next season's order quantity, working from an incomplete reference sheet, has to reconstruct the missing figures from raw sales data all over again, work the complete sheet would have already done.

Incomplete reference sheet against complete reference sheetIncomplete: margin, markup, sell-through onlyMissing ASP, cover, like-for-likeComplete: all six calculations recordedEvery question a buyer needs answered is already on the sheet
An incomplete reference sheet leaves half of the six questions unanswered. A complete sheet closes the season once, so the next buyer never has to reconstruct the missing figures.
06In plain words

A complete retail maths reference sheet records margin, markup, sell-through rate, stock cover, average selling price and like-for-like growth together, from the same closing set of sales data. Margin and markup are fixed once cost and shop price are set; sell-through rate, stock cover and average selling price move throughout the season and are worth recording at the point the season closes; like-for-like growth compares this season with a comparable earlier period in the same stores. A hybrid business selling through more than one route to market at once uses exactly the same six calculations as a business with only one route, since the formulas themselves never change, only how many times each one must be run.

07Quick check
  • Margin and markup are fixed once cost and shop price are set; they do not move during the season.
  • Sell-through rate, stock cover and average selling price are worth recording at the exact point a season closes.
  • Like-for-like growth needs a comparable earlier period in the same fixed store base to mean anything.
  • A hybrid selling model uses the same six calculations as any other business, run once for each route to market.
  • A complete reference sheet lets the next buyer plan the following season without reconstructing any missing figure from raw sales data.
08Workplace scenario

A new buyer at Cedar & Co. is handed only a margin and markup note from the previous season and must decide whether it is enough to plan next season's order quantity

Cedar & Co. hires a new buyer to plan next season's T-shirt order. The only document handed over from the previous buyer is a short note stating the style's own margin and markup. The new buyer needs to decide the order quantity for next season and has three days before the decision is due.

Here is the note the new buyer was given:

Handover note, domestic T-shirt style. Margin: 83.9%. Markup: 521.9%. No further figures recorded.

Is this note enough for the new buyer to plan next season's order quantity? Decide before opening the answer.

Show decision

No, the note is not enough, based on what margin and markup can and cannot show.

First, margin and markup only describe profit against cost and against selling price; neither says anything about how many pieces sold, how fast they sold, or how the style compares with last season. Planning an order quantity needs sell-through rate, to judge whether last season's quantity was right, and like-for-like growth, to judge whether demand is rising or falling.

Second, without average selling price and stock cover from the previous season, the new buyer cannot tell whether the previous order needed a heavy markdown to clear, which would argue for a smaller order quantity next season, or sold through cleanly, which would argue for holding the quantity steady or raising it.

The new buyer should request the complete reference sheet, or rebuild it from raw sales data, covering all six calculations, before committing to next season's order quantity.

09What it costs

What planning from an incomplete reference sheet costs a buying team's own next-season order quantity

Using Cedar & Co.'s own complete season figures:

Sell-through rate the incomplete note does not show: 15,000 / 15,000 = 100.0%
Like-for-like growth the incomplete note does not show: (15,000 - 13,500) / 13,500 = 11.1%
If the new buyer holds the order quantity flat at 15,000 pieces despite 11.1% genuine growth, pieces of likely unmet demand next season: 15,000 x 0.111 = about 1,665 pieces

A new buyer working only from margin and markup has no way to see that this season's style sold through completely and grew 11.1% like-for-like in Cedar & Co.'s own shops, evidence that would support raising the order quantity for next season. Holding the order quantity flat, in the absence of that evidence, risks under-ordering by around 1,665 pieces against the demand the previous season's own figures already showed.

10Working template

Retail maths reference workbook: the complete reference sheet, drawing all five other sheets into one style-level summary

Open the course workbook's "Complete reference sheet" sheet. It draws figures from the "Core retail maths", "Sell-through and stock cover", "Markup, margin and ASP" and "Like-for-like growth" sheets into one combined view for a single style: margin, markup, sell-through rate, stock cover, average selling price and like-for-like growth, all calculated automatically from the same inputs. Enter a different style's own season figures to close out any order with one complete sheet.

[Download the Retail maths reference workbook](../../templates/T20-C01-retail-maths-reference-workbook.xlsx)

Download the Retail maths reference workbook (Excel)

11Check yourself

1. A season shows margin 83.9%, markup 521.9%, sell-through rate 100.0%, stock cover 0.0 weeks, average selling price USD 19.10, and like-for-like growth of 11.1%. Which figure tells a buyer whether to raise next season's order quantity?

2. A style sold through completely last season (sell-through rate 100.0%) but showed a like-for-like decline of 6.0% against the season before. What does this suggest for next season's order quantity?

12Glossary
ENARFRTRMeaning
MarginالهامشMargeMarjProfit divided by the selling price, shown as a percentage of what a company sells for.
Markupالزيادة على التكلفةMajoration (marge sur coût)Kâr yüzdesi (markup)Profit divided by the cost, shown as a percentage of what a company paid.
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.
Average selling priceمتوسط سعر البيعPrix de vente moyenOrtalama satış fiyatıThe total money taken from a style's sales divided by the number of pieces sold, once full-price and markdown sales are both counted.
Like-for-like growthنمو المتاجر القائمةCroissance à magasins comparablesAynı mağaza büyümesiThe change in sales of the same style, in the same set of stores, between two comparable periods, excluding any stores opened or closed since the last comparison.
13Next

Course 2: the next course in Track 20, Retail Planning

You now have a complete retail maths reference sheet covering margin, markup, sell-through rate, stock cover, average selling price and like-for-like growth. The next course in Track 20 builds on these six calculations for full season and range planning. Back to the course map

14Ladder

RecognizeName all six retail maths calculations covered across this course and the question each one answers.
ConnectSee how all six calculations draw from the same closing set of sales data for one style.
CompareWeigh an incomplete reference sheet with only two or three figures against a complete six-part sheet.
DecideJudge whether a complete reference sheet supports raising, holding, or lowering next season's order quantity.