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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Stock at the start of the first month | units | 2,400 | The actual stock in the warehouse and stores in units on the day the plan starts. The example value is illustrative. |
| Cost of a unit | ₽ | 900 | The 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 display | units | 30 | How many models must be shown in every point regardless of sales. The example value is illustrative. |
| Depth: units of a model per point | units | 3 | How 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 points | units | 6 | The number of stores, windows or warehouse points where the display minimum is held. The example value is illustrative. |
| Safety stock | % of month sales | 10 | The 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 plan | units | 1,100 | Expected 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
| Step | Formula |
|---|---|
| Display minimum | width × depth × points |
| Model stock | B = sales × coverage + minimum + share of sales |
| End stock | equals the model stock of the next month |
| Purchase | R = max(0; sales + losses + end stock − start stock) |
| Left to place | max(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
- Start stock
- Sales
- Purchase
Data as a table
| Month | Start stock | Sales | Purchase |
|---|---|---|---|
| September | 2,400 | 1,200 | 2,220 |
| October | 3,420 | 1,800 | 2,840 |
| November | 4,440 | 2,600 | 3,150 |
| December | 4,960 | 3,400 | 2,320 |
| January | 3,840 | 2,200 | 1,460 |
| February | 3,060 | 1,400 | 890 |
- Ordered
- Still to place
Data as a table
| Measure | Ordered | Still to place |
|---|---|---|
| September | 2,000 | 220 |
| October | 2,500 | 340 |
| November | 1,500 | 1,650 |
| December | 0 | 2,320 |
| January | 0 | 1,460 |
| February | 0 | 890 |
The plan by month
| Month | Sales | Model at start | Start stock | End stock | Purchase | Ordered | Left |
|---|---|---|---|---|---|---|---|
| September | 1,200 | 2,580 | 2,400 | 3,420 | 2,220 | 2,000 | 220 |
| October | 1,800 | 3,420 | 3,420 | 4,440 | 2,840 | 2,500 | 340 |
| November | 2,600 | 4,440 | 4,440 | 4,960 | 3,150 | 1,500 | 1,650 |
| December | 3,400 | 4,960 | 4,960 | 3,840 | 2,320 | 0 | 2,320 |
| January | 2,200 | 3,840 | 3,840 | 3,060 | 1,460 | 0 | 1,460 |
| February | 1,400 | 3,060 | 3,060 | 2,520 | 890 | 0 | 890 |
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.