Syntha Lab RU

Opening stock: stock-to-sales and the monthly buying budget

Sets the planned opening stock of each month as a multiple of planned sales (the stock-to-sales ratio) and then calculates the month’s buying budget: sales plus markdowns plus closing stock minus opening stock minus what is already on order. Catches months where the buy turns negative.

Buying budget and cash For whom: Retail buyers, planners and finance staff.

Calculate on your data →

At a glance

What question does it answer?
How much goods to add each month if stock is set as a multiple of sales.
What data is needed?
Opening stock of the first month and the stock-to-sales ratio.
How to read the result?
Six months of sales of 33m at retail with a ratio of 3 (2 in December) give a buying budget of 23.38m (9.82m at cost with a 58% markup). The peak month is October: 7.7m. In February the buy turns negative (−2.23m): opening stock is already above the need and there is nothing to buy. Example on the default values: Buying budget for the period, retail — 23.4 m RUB; Buying budget for the period, at cost — 9.82 m RUB; Planned sales for the period — 33 m RUB; Months with a negative buy — 1.

Why and how to reason

Stock at the start of a month is planned not by eye but as a multiple of sales: how many months of sales should be in the warehouse. That is the stock-to-sales ratio. Then the month’s purchase budget follows from the balance: what must be at month end (stock at the start of the next) plus sales and markdowns minus what is already there and already ordered. Purchase = sales + markdowns + closing stock − opening stock − on order. Example: October, sales 5 million, markdowns 4% (200 thousand), closing stock 19.5 million (November sales 6.5 million × 3), opening stock 15 million, on order 2 million. Purchase 5 + 0.2 + 19.5 − 15 − 2 = RUB 7.7 million at retail, the peak. The whole period (September–February) is 23.38 million at retail, 9.82 million at cost at an initial margin of 58%. February goes negative: stock is too large relative to sales.

When to use it

It is useful when drawing up the season purchase plan to check you are not overbuying in weak months. The ratio is set by category and season from history: high before the peak, low after. It does not fit goods with very different cycles (short-lived hits) nor without a monthly sales plan. Retail values excl. VAT: cost is obtained by multiplying by (1 − initial margin).

How to read the result

Watch months with purchases below zero: they mean stock is excessive and nothing needs buying that month, and part of what is on hand will go to clearance. Here February is −2.23 million: a ratio of 3 at low sales is too high. The budget without negative months (25.6 million) shows the honest purchase total if you cannot return excess. The purchase peak tells when money is needed: October 7.7 million. Compare the average ratio of 2.8 with your norm. It is worth checking stock-to-sales ratios against turnover by category and adjust them before the next cycle: a fast-turning category can run a lower ratio than a slow one.

Common mistakes

The usual mistakes: ignoring what is already ordered; taking sales at cost and stock at retail; setting one ratio for the whole year; forgetting markdowns (they reduce stock at retail). A negative purchase does not mean a return to the supplier, only reduced orders. Do not mix planned sales with and without VAT: use values excluding VAT.

What data is needed?

  • Opening stock of the first month and the stock-to-sales ratio.
  • By month: planned sales, markdowns, on-order; optionally the month’s ratio.
  • Closing stock and initial markup for conversion into cost.

Inputs

FieldUnitValue in the exampleMeaning
Opening stock of the first month, at retail excl. VAT₽11,000,000Actual stock in retail prices excl. VAT. For the following months stock is set by the ratio.
Default stock-to-sales ratio×3How many times the opening stock exceeds the month’s sales. Choose from your own history: it differs by category. The default is set for apparel; for footwear, accessories and children’s take your own data.
Closing stock of the last month, at retail₽4,000,000The target stock at the end of the period. Empty: last month’s sales × its ratio.
Initial margin: the share of the selling price excl. VAT not taken by cost%58Margin on the selling price, not markup on cost: a markup of 140% corresponds to a margin of 58.3%. For converting the budget to cost. Empty: cost not calculated.

How it is calculated

StepFormula
Opening stockfirst month: actual; then the month’s sales × the stock-to-sales ratio
Closing stockequals the next month’s opening stock
Month’s buysales + markdowns + closing stock − opening stock − already on order
To costretail buy × (1 − initial margin); this is margin on price, not markup on cost

Worked numbers

Default values from the app; in the interactive version you enter your own.

Buying budget for the period, retail
23.4 m ₽
Buying budget for the period, at cost
9.82 m ₽
Planned sales for the period
33 m ₽
Months with a negative buy
1Opening stock is already above the need: nothing to buy, a sale or a carry-over is needed.
Buying budget without negative months
25.6 m ₽A buy cannot take back excess stock: a negative month does not reduce buying in other months. This is what can really be ordered; the gap to the total above is excess stock that has to be sold, not “saved”.
Peak buying month
7.7 m ₽ · October
Average stock-to-sales ratio
2.79×

Stock and buying plan by month

MonthSalesOpening stockClosing stockMarkdownsOn orderBuyStock ÷ sales
September4 m ₽11 m ₽15 m ₽120,000 ₽3 m ₽5.12 m ₽2.75
October5 m ₽15 m ₽19.5 m ₽200,000 ₽2 m ₽7.7 m ₽3
November6.5 m ₽19.5 m ₽18 m ₽390,000 ₽1 m ₽4.39 m ₽3
December9 m ₽18 m ₽15 m ₽900,000 ₽0 ₽6.9 m ₽2
January5 m ₽15 m ₽10.5 m ₽1 m ₽0 ₽1.5 m ₽3
February3.5 m ₽10.5 m ₽4 m ₽770,000 ₽0 ₽−2.23 m ₽3

The total of 23.4 m ₽ is reduced by negative months (−2.23 m ₽): the minus of one month does not offset buying in another. What can really be ordered is 25.6 m ₽, and the excess stock of 2.23 m ₽ has to be sold or carried over.

“February”: buy −2.23 m ₽, that is, stock above plan. Check what is on order and the ratio.

Choose the stock-to-sales ratio from your own history and categories: it is lower for basics and higher for seasonal items before the peak. The method complements the season buying budget: the sum of months should reconcile with it.

Nuances and limits

  • Choose the ratio from your own history and by category.
  • The sum of the months should reconcile with the season buying budget.
  • The method is not suitable for tax accounting: it is a management estimate.

Terms used

Calculate on your data →