Syntha Lab RU

The six-month plan and model stock: stock = sales × coverage + safety, purchases by month

From sales by month, coverage (in months of sales, in steps by season), the display minimum (width × depth × the number of points) and a share of sales for the spread it counts the model stock at the start of each month. It takes the end stock equal to the model stock of the next month and counts the purchase of the month in units and at cost. It subtracts what is already ordered and shows what is left to place, over-ordering, the average stock, weeks of cover and turnover.

Buying budget and cash For whom: Planners, category managers, buyers and CFOs who turn seasonal demand into a delivery schedule.

Calculate on your data →

At a glance

What question does it answer?
How many units to buy and in which months so that there is a model stock before each month, how much can still be placed and whether there is over-ordering.
What data is needed?
Sales by month, losses and what is already ordered in units.
How to read the result?
Example on the default values (autumn–winter, six months, start stock 2,400): purchases for the period 12,880 units (RUB 11.6 million), already ordered 6,000 units, still to place 6,880 units; display minimum 540 units; average stock 3,697 units, cover 7.6 weeks, turnover 3.41 times. Example on the default values: Purchases for the period, units: 12,880; Purchases for the period, at cost: RUB 11.6 million; Already ordered, units: 6,000; Still to place, units: 6,880. The figures are illustrative: enter your own to see your result.

Why and how to reason

A purchase budget in money tells how much to spend but not how many units to bring and when so that the display does not empty before the peak and goods do not lie after it. A six-month plan in units does it in three steps. First the model stock at the start of a month: the month’s sales multiplied by coverage plus safety stock, which consists of the display minimum (width × depth × the number of points) and a share of sales for the spread. Then the end stock of a month is taken equal to the model stock of the next month, so the months are linked in a chain. Finally the purchase of a month equals sales plus losses plus the end stock minus the start stock, and it is never negative. At the default values in September the model is 1,200 × 1.6 + 540 + 120 = 2,580 units, the end stock 3,420, the purchase 1,200 + 3,420 − 2,400 = 2,220 units; over six months the purchase is 12,880 units.

When to use it

Apply before placing orders for a season and in the monthly review with actuals. It fits lines with seasonal demand and a known delivery schedule. It does not replace the purchase budget in money: reconcile the result with OTB and stock-to-sales. For footwear depth by size matters more, for accessories coverage is longer, for children’s the peaks are by 1 September and New Year; the parameters of each category are their own.

How to read the result

Look at where the purchase is highest: that month requires an order in advance. The line “still to place” shows how much more can be ordered; “ordered beyond the need” shows over-ordering and it must be removed before the season. The difference between the actual stock and the model at the start signals a shortage or an excess already today. Compare weeks of cover and turnover with the category target. If the stock is above the model the purchase is zero and the remainder is visible in the table: it must be redistributed or included in the price reduction plan. Then reconcile the purchase in money with the budget. Turn the result into an order by month and agree it with the supplier in advance.

Common mistakes

One coverage is set for the whole season. The display minimum is counted as saleable stock. What is ordered is not subtracted. The sales of the month beyond the horizon are taken as zero, so the end stock of the last month is understated. The plan is not updated with actuals: the error accumulates from month to month. Also: counting cover in weeks without checking that the sales pace is taken over the same period.

What data is needed?

  • Sales by month, losses and what is already ordered in units.
  • Coverage by month (in steps) and the display minimum: width, depth, the number of points.
  • The start stock, the safety percentage, the cost and the sales of the month after the plan.

Inputs

FieldUnitValue in the exampleMeaning
Stock at the start of the first monthunits2,400The actual stock in the warehouse and stores in units on the day the plan starts. The example value is illustrative.
Cost of a unit₽900The average cost of a unit without VAT for converting units into money and reconciling with the purchase budget. For footwear, accessories and children’s take your own. The example value is illustrative.
Width: models in the displayunits30How many models must be shown in every point regardless of sales. The example value is illustrative.
Depth: units of a model per pointunits3How many units of one model lie at a point so that the display is not empty: the size run or the minimum. The example value is illustrative.
Display pointsunits6The number of stores, windows or warehouse points where the display minimum is held. The example value is illustrative.
Safety stock% of month sales10The share of the month’s sales held beyond the display minimum for the spread of demand and lead time. The example value is illustrative.
Sales of the month after the planunits1,100Expected sales of the month beyond the horizon: the end stock of the last month depends on it. Coverage is taken as in the last month. The example value is illustrative.

How it is calculated

StepFormula
Display minimumwidth × depth × points
Model stockB = sales × coverage + minimum + share of sales
End stockequals the model stock of the next month
PurchaseR = max(0; sales + losses + end stock − start stock)
Left to placemax(0; purchase − ordered)

Worked numbers

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

Purchases for the period, units
12,880
Purchases for the period, at cost
11.6 m ₽
Already ordered, units
6,000
Still to place, units
6,880
Ordered beyond the need, units
0Over-ordering: more is ordered than the month needs.
Display minimum, units
540Width × depth × points: goods on the shelf that are not sold off fully.
Model stock at the start of the first month, units
2,580
Actual stock against the model at the start
−180A minus means a shortage against the model, a plus an excess.
Average stock, units
3,697
Weeks of cover by the average stock
7.6
Turnover for the period, times
3.41
Peak of stock at the start of a month, units
4,960The peak month: December.
Months with no purchase and excess stock
0
Stock at the start of the month, sales and purchases, units
Line chart: Start stock: 2,400 → 3,060; Sales: 1,200 → 1,400; Purchase: 2,220 → 89001,0002,0003,0004,0005,000SeptemberNovemberJanuaryFebruaryStart stock, September: 2,400Start stock, October: 3,420Start stock, November: 4,440Start stock, December: 4,960Start stock, January: 3,840Start stock, February: 3,060Sales, September: 1,200Sales, October: 1,800Sales, November: 2,600Sales, December: 3,400Sales, January: 2,200Sales, February: 1,400Purchase, September: 2,220Purchase, October: 2,840Purchase, November: 3,150Purchase, December: 2,320Purchase, January: 1,460Purchase, February: 890unitsMonth
  • Start stock
  • Sales
  • Purchase
Data as a table
MonthStart stockSalesPurchase
September2,4001,2002,220
October3,4201,8002,840
November4,4402,6003,150
December4,9603,4002,320
January3,8402,2001,460
February3,0601,400890
Purchases by month: ordered and still to place, units
Bar chart: September 2,000, October 2,500, November 1,500, December 0, January 0, February 001,0002,0003,0004,000SeptemberSeptemberOrdered: 2,000Still to place: 2202,220OctoberOctoberOrdered: 2,500Still to place: 3402,840NovemberNovemberOrdered: 1,500Still to place: 1,6503,150DecemberDecemberStill to place: 2,3202,320JanuaryJanuaryStill to place: 1,4601,460FebruaryFebruaryStill to place: 890890units
  • Ordered
  • Still to place
Data as a table
MeasureOrderedStill to place
September2,000220
October2,500340
November1,5001,650
December02,320
January01,460
February0890

The plan by month

MonthSalesModel at startStart stockEnd stockPurchaseOrderedLeft
September1,2002,5802,4003,4202,2202,000220
October1,8003,4203,4204,4402,8402,500340
November2,6004,4404,4404,9603,1501,5001,650
December3,4004,9604,9603,8402,32002,320
January2,2003,8403,8403,0601,46001,460
February1,4003,0603,0602,5208900890

The model: the stock at the start of a month equals the month’s sales times coverage plus safety stock; the end stock equals the model stock of the next month, so the months are linked in a chain. A purchase is never negative: if the stock is above the model the purchase is zero and the remainder is visible in the table. Set coverage in steps by season and reconcile the result with the purchase budget in money (OTB, stock-to-sales). For footwear depth by size matters more, for accessories coverage is longer, for children’s the peaks are by 1 September and New Year.

Nuances and limits

  • One coverage for the whole season: a shortage before the peak and an excess after it.
  • Counting the display minimum as saleable stock: it piles up on the shelf.
  • Not subtracting what has been ordered: over-ordering appears.

Terms used

Calculate on your data →