Syntha Lab RU

Open-to-buy (OTB) by category and month

One row per category and month: sales plan, price reductions, weeks of cover, opening stock and orders. The output is OTB at retail and at cost.

Layouts for documents 11 columns 5 example rows

Download CSV ↓

What the template is for

The monthly OTB refresh and an over-buying check by category.

What one row is
one row = category × month

Columns

ColumnCodeTypeRequiredValidation rule
MonthmonthTextyesmonth as YYYY-MM
CategorycategoryList valueyesa value from the category reference
Planned sales, thousand, excl. VATsalesNumberyesa number not below 0
Planned price reductions, thousandmarkdownNumberyesa number not below 0
Target weeks of cover at the endcoverNumberyesa number not below 0
Closing stock, thousand (retail)endNumberyescalculated: sales × weeks of cover ÷ 4.3
Opening stock, thousand (retail)beginNumberyesa number not below 0
On order, not received, thousand (retail)onorderNumberyesa number not below 0
OTB, thousand (retail)otbNumberyescalculated: sales + reductions + closing stock − opening stock − orders; a negative value means over-buying
Initial markup margin IMU, %imuNumberyesfrom 0 to 100
OTB, thousand (at cost)otbCostNumberyescalculated: OTB × (1 − IMU ÷ 100)

Example rows

MonthCategoryPlanned sales, thousand, excl. VATPlanned price reductions, thousandTarget weeks of cover at the endClosing stock, thousand (retail)Opening stock, thousand (retail)On order, not received, thousand (retail)OTB, thousand (retail)Initial markup margin IMU, %OTB, thousand (at cost)
2027-02women9,8001,200818,23321,0006,5001,73358728
2027-02men4,40045088,1868,8003,0001,23657531
2027-02kids2,10030062,9303,3001,50053055238
2027-03women12,4001,500823,07017,5005,20014,270585,993
2027-03men5,600600810,4197,9002,4006,319572,717

The example data is illustrative: an exercise, replace it with your own.

Note

Use the IMU of each category, not a chain average. Convert opening stock and orders to one base (retail) before the calculation. 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 →