Syntha Lab RU

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.

Layouts for documents 12 columns 4 example rows

Download CSV ↓

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

ColumnCodeTypeRequiredValidation rule
Season codeseasonTextyesa code like AW26 or SS27 from the season reference
CategorycategoryList valueyesa value from the category reference
Buy, unitsbuyIntegeryesan integer not below 0
Planned sell-through, %stNumberyesfrom 0 to 100
Price excl. VATpriceNumberyesa number not below 0
Unit cost excl. VATcostNumberyesa number not below 0
Average discount, %mdNumberyesfrom 0 to 100
DropdropList valueyesdrop1, drop2 or drop3
Units soldsoldIntegeryescalculated: buy × sell-through ÷ 100
Revenue, thousandrevenueNumberyescalculated: sold × price × (1 − discount ÷ 100) ÷ 1000
Cost of sales, thousandcogsNumberyescalculated: sold × cost ÷ 1000
Gross margin, %gmNumberyescalculated: (revenue − cost) ÷ revenue × 100

Example rows

Season codeCategoryBuy, unitsPlanned sell-through, %Price excl. VATUnit cost excl. VATAverage discount, %DropUnits soldRevenue, thousandCost of sales, thousandGross margin, %
AW26women5,200788,9003,00014drop14,05631,04512,16860.8
AW26men2,600809,4003,40012drop12,08017,2067,07258.9
AW26kids1,800723,6001,30016drop21,2963,9191,68557
SS27women6,100746,9002,20018drop14,51425,5409,93161.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

Documents that need this data

Download CSV ↓ Open interactively →