Collection plan in value
From the collection grid (styles, depth, prices and cost) computes revenue, margin and leftover at a given sell-through and markdown, and checks that depth per style is not too small.
At a glance
- What question does it answer?
- What revenue, profit and leftover the grid yields at a given sell-through and markdown.
- What data is needed?
- Categories: number of styles, units per style, price and cost.
- How to read the result?
- Compare revenue with the “ideal” (at full price) and margin after markdowns. The depth warning shows categories where units per style are below the factory minimum. Example on the default values: Four categories give planned revenue of RUB 37,478,400 and gross profit of RUB 20,151,600 (margin 53.8%). Leftovers at cost are RUB 1,925,200 and revenue is 80% of what selling everything at full price would give. The depth of trousers and skirts is below the minimum run of 100 units per model. If depth is below the minimum run, cut the number of models or enlarge the run of best sellers. Next: “Collection break-even and order size” and “Post-season review by category”.
Why and how to reason
A collection in money is built bottom-up: how many styles in each category, how many units per style (depth), price, cost. Category units = styles x depth. But not everything sells at full price: part will go on markdown, part will remain. So revenue = units x price x (full-price share + markdown share x (1 - markdown depth)).
The “full price” and “markdown” shares together are below 100%: the rest stays unsold, and that is leftover at cost.
Example. Outerwear: 8 styles x 220 = 1,760 units. Full-price share 65%, markdown 25% at depth 40%: factor 0.65 + 0.25 x 0.6 = 0.80. Revenue 1,760 x 9,800 x 0.8 = RUB 13.8 m. Across four categories RUB 37.5 m with 44 styles, gross profit RUB 20.2 m (margin 53.8%), leftover at cost RUB 1.9 m.
When to use it
It comes in handy when planning a collection, while the number of styles and depth can still change. It helps see whether the assortment pays and whether some styles are too small. It does not replace buying by size or OTB. Assumption: sell-through and markdown depth are the same across categories. If they differ, calculate categories separately. Recalculate after each change to the number of styles.
How to read the result
Look at the margin and “revenue to full price” (80% in the example): the lower, the more is lost to markdowns. Leftover at cost is frozen cash. Check the minimum-run flags: a style with depth below the factory minimum is costly per unit. Decision: remove or merge small styles, shift depth toward strong categories, reprice where margin is below target. Then reconcile the total with the sales plan. If revenue to full price is below 80% and leftover is large, cut depth or the number of styles. It is worth checking the opposite too: a run that is too small raises the style’s cost above plan.
Common mistakes
Counting all units as sold at full price; using a markdown depth that will not suffice; ignoring leftover; giving every style the same depth. Also: taking the price with VAT. Also: leaving no allowance for reordering bestsellers, so strong styles run out early and weak ones stay in the warehouse to the end of the season.
What data is needed?
- Categories: number of styles, units per style, price and cost.
- Shares sold at full price and on markdown, markdown depth, minimum run per style.
- Where to take it: models and units per model from the collection plan and factory orders; price and cost from the price list and costing; the full-price and clearance shares and discount depth from past seasons’ results (your company may name the sales stages differently: before sale, in sale, leftovers after). The minimum run from the factory terms.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Sold at full price | % of the run | 65 | The share of the run sold at full price. Together with the share below it must not exceed 100%. |
| Sold on markdown | % of the run | 25 | The share of the run sold on markdown; the rest up to 100% is unsold. |
| Markdown depth | % | 40 | Average markdown depth on the units sold on markdown, off the full price. |
| Minimum run per style | units | 100 | The factory minimum or a sensible minimum for a style: below it the style is costly or unprofitable. |
How it is calculated
| Step | Formula |
|---|---|
| Category revenue | Units × price × (full-price share + markdown share × (1 − markdown)) |
| Profit | Revenue − cost of goods sold |
| Leftover | Units × cost × unsold share |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Planned revenue
- 37.5 m ₽After the full-price share and markdowns.
- Gross profit
- 20.2 m ₽
- Margin
- 53.8 %
- Leftover at cost
- 1.93 m ₽
- Styles / units
- 44 / 7,060
- Revenue vs full price
- 80 %How much of the “ideal” revenue you get after markdowns and leftover.
By category
| Category | Units | Revenue | Profit | Leftover |
|---|---|---|---|---|
| Outerwear | 1,760 | 13.8 m ₽ | 6.99 m ₽ | 756,800 ₽ |
| Dresses | 2,240 | 11.5 m ₽ | 6.43 m ₽ | 560,000 ₽ |
| Knitwear | 2,160 | 8.47 m ₽ | 4.77 m ₽ | 410,400 ₽ |
| Trousers and skirts | 900 | 3.74 m ₽ | 1.96 m ₽ | 198,000 ₽ |
Depth is below the 100-unit minimum per style: Trousers and skirts. Either cut the number of styles or enlarge the run of bestsellers.
Nuances and limits
- Sell-through shares are the same for all categories: they differ for new styles and basics, calculate separately.
- The clearance shares are the same for all categories: novelties and basics differ, adjust by hand.
- Discount depth is the season average, not the maximum on the tag.