The six-month merchandise plan and model stock: sales, coverage, safety stock, purchases by month
How to build a six-month plan in units: sales by month, a model stock at the start of each month as sales multiplied by coverage plus safety stock, the end stock equal to the next month’s model stock, and a purchase that closes the difference. The plan decides how much and when to order and is reconciled with the purchase budget and stock-to-sales in money.
Why this document
A purchase budget in money does not answer how many units to order and in which months, and does not protect against gaps in display and overstock before price cuts. A six-month plan with a model stock turns seasonal demand into a delivery schedule. The planner, the category manager, the buyer and the CFO read this document before placing the orders for a season. It gives an order: sales, coverage by month, safety stock, purchase and reconciliation with the budget. Without it deliveries go in equal parts and do not match the demand peak.
At a glance
- What is this document and why is it needed?
- How to build a six-month plan in units: sales by month, a model stock at the start of each month as sales multiplied by coverage plus safety stock, the end stock equal to the next month’s model stock, and a purchase that closes the difference. The plan decides how much and when to order and is reconciled with the purchase budget and stock-to-sales in money.
- Who owns the document and how often is it rebuilt?
- The planner and the category manager keep the plan, the buyer places orders, the CFO reconciles it with the budget; reviewed monthly with actuals and before every season.
- What mistakes are the most common?
- Brand: one coverage is set for the whole season → a shortage before the peak and an excess after it → set coverage in steps by month. Retail: the display minimum is counted as saleable stock → it freezes on the shelf and accumulates → show it as a separate line and do not charge it to sales. Brand: what has been ordered is not subtracted → the order is duplicated and over-ordering appears → keep the sum that can still be placed.
For whom
- Brand
- A brand builds the plan for production and reorders: deliveries to the warehouse and to wholesale partners, production times and minimum batches. The main things: a delivery schedule for the demand peak and a reserve for a reorder that can be made faster than the lead time of the main order.
- Retail
- A retailer builds the plan by category, stores and months: what to receive into the warehouse and the stores and when. The main things: the display minimum in the store (width × depth), coverage by month and a reconciliation of what is ordered with the need so as not to top up for the season and not to hold stock after it.
What it consists of
Rows of the six-month plan
- Sales by month (units): from the forecast and the history of past seasons with calendar corrections; losses and write-offs (defects, returns to the supplier, shrinkage); stock at the start and at the end of the month; the purchase (receipts).
- The month purchase = sales + losses + end stock − start stock; the end stock of a month equals the model stock at the start of the next: the chain links the months and does not allow the figures to be set independently.
Model stock
- The model stock at the start of a month = the month sales × coverage + safety stock; coverage is set in months of sales and changed by season (steps): larger before the peak and at the start of the season, smaller as it ends.
- Safety stock consists of the display minimum (the number of models × depth per model × the number of points) and a share of sales for the spread of demand and lead time; goods in the display minimum are not sold off fully, they keep the range on the shelf.
Width, depth, steps and the calendar
- Width: the number of models in the display; depth: units of one model per point; steps: coverage by month; the Russian calendar sets the peaks: the heating season and cold weather for outerwear, 1 September for children’s, 23 February for men’s, 8 March for women’s and gifts; put these dates into sales, not into coverage.
Link to the budget and reconciliation
- The plan in units is multiplied by cost and reconciled with the purchase budget (OTB) and stock-to-sales in money: a gap above the tolerance means that coverage, sales or the purchase price were chosen inconsistently.
- What is ordered earlier is subtracted from the need: what remains is the sum that can still be placed; if more is ordered than needed this is over-ordering and it must be seen before the season and not after it.
What each side does
- Brand: calculates the plan by channels and partners, sets a delivery schedule with a reserve for reorders and agrees minimum batches with the factory.
- Brand: on the actuals of the month recalculates sales and the nearest receipts and reports the changes to the factory and partners.
- Retail: calculates the plan by categories and stores, determines the display minimum and places orders on schedule.
- Retail: reconciles receipts with the plan and monitors the stock above the model: the excess goes to redistribution or to the price reduction plan.
Where the data comes from
| Data source | Fields |
|---|---|
| Forecast and sales history | units by months and stores, the peak calendar, losses and write-offs |
| Stock and orders | start stock, orders by month, lead times |
| Display and budget | width, depth, number of points, cost, the purchase budget |
How to build it step by step
- Step 1: Brand: collect sales by month (units) from the forecast and past seasons and mark the calendar peaks.
- Step 2: Set coverage by month (steps): larger before the peak, smaller towards the end of the season.
- Step 3: Retail: count the display minimum: the number of models × depth × the number of points; add a share of sales for the spread.
- Step 4: Count the model stock at the start of each month and the end stock as the model stock of the next month.
- Step 5: Count the month purchase: sales + losses + end stock − start stock; negative values mean an excess.
- Step 6: Subtract what has been ordered and get the sum that can still be placed; check months with over-ordering.
- Step 7: Brand: reconcile the purchase in money with the budget and stock-to-sales; in case of a gap review coverage or sales.
- Step 8: Retail: update the plan with actuals once a month and recalculate receipts; record the plan version.
Formulas
| Measure | Formulas | Note |
|---|---|---|
| Model stock at the start of a month | B_m = S_m × k_m + (W × D × P + z × S_m) | S_m: month sales, k_m: coverage in months, W: the number of models (width), D: units per model per point (depth), P: the number of points, z: the share of sales for the spread. |
| The month purchase | R_m = max(0; S_m + L_m + B_{m+1} − start stock) | L_m: losses and write-offs; B_{m+1}: the model stock of the next month as the end stock; the start stock of the first month: the actual. |
| Weeks of cover | Weeks = average stock / (Σ S_m / 26) | Six months are about 26 weeks; compare with the category target. |
Formulas in notation
- Model stock
B_m = S_m·k_m + W·D·P + z·S_m, E_m = B_{m+1}
B_m: the stock at the start of the month; E_m: the end stock; k_m: coverage; W·D·P: the display minimum; z: the share for the spread.- Purchase
R_m = max(0; S_m + L_m + E_m − I_m), I_{m+1} = I_m + R_m − S_m − L_m
I_m: the actual stock at the start of the month; L_m: losses. If the purchase is zero the remainder is above the model.
Worked example
An autumn-winter plan in units: start stock 2,400, display minimum 30 models × 3 × 6 points, safety 10% of sales, cost RUB 900; sales, coverage and what is ordered are conditional
| Month | Sales, units | Start stock, units | End stock, units | Purchase, units | Ordered, units | Still to place, units |
|---|---|---|---|---|---|---|
| September | 1,200 | 2,400 | 3,420 | 2,220 | 2,000 | 220 |
| October | 1,800 | 3,420 | 4,440 | 2,840 | 2,500 | 340 |
| November | 2,600 | 4,440 | 4,960 | 3,150 | 1,500 | 1,650 |
| December | 3,400 | 4,960 | 3,840 | 2,320 | 0 | 2,320 |
| January | 2,200 | 3,840 | 3,060 | 1,460 | 0 | 1,460 |
| February | 1,400 | 3,060 | 2,520 | 890 | 0 | 890 |
The numbers are conditional; the same values come from the “Six-month plan and model stock” calculation. The purchase peaks in November, before the December peak: coverage there is higher; by February purchases and stock fall together with sales.
Figures
- 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 |
Start-of-month stock, sales and purchase. Stock grows towards the peak of sales through coverage, the purchase runs ahead of sales and falls towards the end of the season.
- 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 |
Purchases by month: already ordered and still to place. What is ordered in season batches covers the start of the season; the peak must be covered by reorders.
Specifics by category
- Apparel
- Apparel: coverage is large before the seasonal peak and falls towards its end; the size depth (S–XL) goes into “depth”: count the display minimum by size run and not by the model as a whole.
- Footwear
- Footwear: depth by size matters more: a pair of a size that is missing is not replaced by another; safety stock for fast sizes is higher, at the edges lower; coverage is higher because of long lead times.
- Accessories
- Accessories: a low unit price, a long tail and low seasonality, so coverage is longer and the display minimum makes up a large share of stock; the plan is simpler but depends more on gift peaks.
- Kids
- Kids: a peak by 1 September and by New Year, a child’s growth breaks the size curve, so depth by size and a mid-season refresh of stock matter more, and the certificate under TR CU 007/2011 is needed before purchase.
- Men
- Men: demand is steadier and the peaks before 23 February are sharper; width is smaller, depth in basic items larger, safety stock can be kept lower.
- Women
- Women: more models and fewer repeats, a peak before 8 March and the holidays; width is higher, depth per model smaller, and the reserve for reorders and the delivery schedule matter more.
Common mistakes
- Brand: one coverage is set for the whole season → a shortage before the peak and an excess after it → set coverage in steps by month.
- Retail: the display minimum is counted as saleable stock → it freezes on the shelf and accumulates → show it as a separate line and do not charge it to sales.
- Brand: what has been ordered is not subtracted → the order is duplicated and over-ordering appears → keep the sum that can still be placed.
- Retail: the plan in units is not linked with the budget in money → the gap is seen after the season → reconcile the purchase in money with OTB and stock-to-sales.
- The plan is not updated with actuals → the error accumulates from month to month → recalculate with actuals once a month.
Russian specifics
- Brand: the legislation does not set rules for calculating a six-month plan and model stock; it is a management method, the parameters are set by the strategy and the data of the company.
- Retail: the dates of peaks in Russia (cold weather and the heating season, 1 September, 23 February, 8 March, New Year) are taken from the collection calendar; times differ by region.
- Brand: children’s clothing and footwear need a conformity document under TR CU 007/2011 before being offered for sale: the time of issue goes into the delivery schedule. Rule: CU Commission decision 797 of 23.09.2011: TR CU 007/2011 on safety of products for children and adolescents (Customs Union Commission Decision of 23.09.2011 No. 797).
- Retail: light-industry goods under mandatory marking are received into the warehouse with codes; the dates of waves and stock under decrees No. 1956 and No. 2129 affect the delivery schedule. Rule: Decree 1956 of 31.12.2019: Government Decree of 31.12.2019 No. 1956 (marking rules for light-industry goods).