Season plans
One row per season and category: buy, planned sell-through, price, cost, average discount and drop. The output is units sold, revenue, cost and margin.
What the template is for
Seasonal collection planning and checking the season plan against actuals as sales progress.
- What one row is
- one row = season × category
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Season code | season | Text | yes | a code like AW26 or SS27 from the season reference |
| Category | category | List value | yes | a value from the category reference |
| Buy, units | buy | Integer | yes | an integer not below 0 |
| Planned sell-through, % | st | Number | yes | from 0 to 100 |
| Price excl. VAT | price | Number | yes | a number not below 0 |
| Unit cost excl. VAT | cost | Number | yes | a number not below 0 |
| Average discount, % | md | Number | yes | from 0 to 100 |
| Drop | drop | List value | yes | drop1, drop2 or drop3 |
| Units sold | sold | Integer | yes | calculated: buy × sell-through ÷ 100 |
| Revenue, thousand | revenue | Number | yes | calculated: sold × price × (1 − discount ÷ 100) ÷ 1000 |
| Cost of sales, thousand | cogs | Number | yes | calculated: sold × cost ÷ 1000 |
| Gross margin, % | gm | Number | yes | calculated: (revenue − cost) ÷ revenue × 100 |
Example rows
| Season code | Category | Buy, units | Planned sell-through, % | Price excl. VAT | Unit cost excl. VAT | Average discount, % | Drop | Units sold | Revenue, thousand | Cost of sales, thousand | Gross margin, % |
|---|---|---|---|---|---|---|---|---|---|---|---|
| AW26 | women | 5,200 | 78 | 8,900 | 3,000 | 14 | drop1 | 4,056 | 31,045 | 12,168 | 60.8 |
| AW26 | men | 2,600 | 80 | 9,400 | 3,400 | 12 | drop1 | 2,080 | 17,206 | 7,072 | 58.9 |
| AW26 | kids | 1,800 | 72 | 3,600 | 1,300 | 16 | drop2 | 1,296 | 3,919 | 1,685 | 57 |
| SS27 | women | 6,100 | 74 | 6,900 | 2,200 | 18 | drop1 | 4,514 | 25,540 | 9,931 | 61.1 |
The example data is illustrative: an exercise, replace it with your own.
Note
Unsold stock does not vanish: it goes to a sale or carries into the next season, so average discount and sell-through must agree. Take season and drop periods from the season reference. The example data is illustrative: an exercise, not a norm or an industry benchmark.
How to open the file
The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.
Calculations that use these fields
- Season matrix: product season × sales month and stock against the window
- Collection plan in value
- Season result: from gross sales to contribution
- Buying budget by category and weeks of supply
- Weekly markdown ladder: discount steps and an ending-stock goal
- Clearance scenarios compared by goal
- Forecast of a new item from analogs
- Open-to-buy (OTB) for the season
Documents that need this data
- Collection calendar (critical path) and lead time
- Budget: P&L, cash, purchase, marketing, payroll and CAPEX budgets
- Assortment matrix and assortment plan
- Business plan of a brand and a retailer: sections, assumptions, presenting to an investor and a bank
- Dynamic pricing: elasticity by segment, brand constraints, an optimal clearance path and the Thompson bandit
- Demand forecasting: smoothing, seasonal indices, analogs and error control
- Holt-Winters, seasonal decomposition and Croston: forecasting with trend, season and intermittent demand
- Markdown mathematics: steps, leftovers, timing and liquidation
- Open-to-buy budget (OTB)
- Job profiles: merchandiser and collection product manager — what they count, which documents they make, how the week works
- The six-month merchandise plan and model stock: sales, coverage, safety stock, purchases by month
- Sports and technical clothing: fabrics, finishing, tests, the season and the price of a functional fabric