Buying budget by category and weeks of supply
For each category calculates planned receipts: planned sales, target ending stock in weeks of sales and markdowns minus opening stock, then subtracts orders already placed. Shows where you can buy more and where you have bought above plan.
At a glance
- What question does it answer?
- In which categories you can still buy and in which you have bought above plan, and how many forward weeks of stock there are.
- What data is needed?
- Planned sales and next period’s sales by category.
- How to read the result?
- A negative buying budget for a category means over-buying: orders above plan must be cut or moved. Forward weeks of stock shows how long goods last on the forecast, not on past sales. Turn the total into cash in “Open-to-buy (OTB)”. Example on the default values: 26 weeks with a target of 8 weeks of ending stock: planned receipts are RUB 136.85m at selling price, RUB 63m is already ordered and RUB 73.85m can still be bought. No category is over-bought. If a category is over-bought, cancel part of the orders not yet confirmed. For payment money convert the sum into cost in “Open-to-buy (OTB) for the season” and the cash flow.
Why and how to reason
A total buying budget can be spent in the wrong places, so it is computed by category: each has its own sales, markdowns, stock. The logic is the same as in OTB but per category. Planned receipts = sales + markdowns + ending stock - opening stock. Ending stock is set in weeks of future sales: next period sales / weeks x number of weeks. Then what has been ordered is subtracted.
Forward weeks are needed because the season-end stock must feed the next period’s sales: eight weeks for outerwear, for accessories it may be more or less, so the target can be set individually.
Example. Outerwear: ending stock 52 / 26 x 8 = RUB 16 m. Receipts 48 + 6 + 16 - 14 = RUB 56 m. Ordered RUB 20 m, so RUB 36 m can still be bought. Across all four categories receipts are RUB 136.8 m, ordered RUB 63 m, OTB RUB 73.8 m.
When to use it
It fits in category buying planning and in mid-season revision, to determine where to buy more and where to stop. Assumption: all amounts on one valuation (at cost or at selling price). It does not replace size and style split within a category. For categories with a long lead time the ending stock is higher, set it individually.
How to read the result
A positive budget means you can buy more, a negative one means more has been bought than planned (overbuying). There is no overbuying in the example. See where the remaining budget is large: direct buying there if the category sells well. Categories where the budget is small while sales grow may run out of goods. Compare the sum across categories with the total OTB. Decision: allocate additional buying across categories taking sales and margin into account and revisit orders where overbought. Highlight categories where the budget is large and turnover high: direct reorders there first. Check categories with a small budget and high sales for shortage. Reconcile the reorder total with cash.
Common mistakes
The usual mistakes: mixing amounts at cost and at selling price; using last period’s sales instead of next period’s; taking uniform weeks for categories with different turnover; ignoring goods in transit. Also: spending the entire budget at once. Also: leaving the ending stock the same for all categories.
What data is needed?
- Planned sales and next period’s sales by category.
- Planned markdowns, opening stock and orders already placed.
- Target ending stock in weeks: general and, if needed, its own by category.
- Where to take it: sales plan by category from the approved budget; opening stock from warehouse and store balances at selling price (1C, WMS); already ordered from the supplier order register converted to selling price; planned price reductions from the discount plan. The target weeks of stock from each category’s turnover history.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Weeks in the plan period | weeks | 26 | Length of the planning period in weeks; it sets the weekly sales pace and the ending stock. |
| Target ending stock, forward weeks of sales | weeks | 8 | A category’s own target is set in the table; this is the default. |
How it is calculated
| Step | Formula |
|---|---|
| Ending stock | Next period sales ÷ weeks × target weeks |
| Planned receipts | Sales + markdowns + ending stock − opening stock |
| OTB | Planned receipts − already ordered |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Planned receipts
- 136.8 m ₽Sales + markdowns + ending stock − opening stock.
- Already ordered
- 63 m ₽
- Open to buy (OTB)
- 73.8 m ₽
- Categories over-bought
- 0
By category
| Category | Stock now, weeks | Ending target, weeks | Receipts | Open to buy |
|---|---|---|---|---|
| Outerwear | 7 | 8 | 56 m ₽ | 36 m ₽ |
| Knitwear | 7.8 | 8 | 33.2 m ₽ | 18.2 m ₽ |
| Dresses | 5.6 | 6 | 30.5 m ₽ | 9.46 m ₽ |
| Accessories | 9.8 | 10 | 17.2 m ₽ | 10.2 m ₽ |
Amounts here are at selling price; for cash to pay convert to cost in “Open-to-buy (OTB)” and “Cash flow”.
Nuances and limits
- Do not mix bases: here everything is at selling price, cash to pay is calculated at cost.
- Weeks targets differ by category: forward stock is not the same for outerwear and accessories.
- All amounts here are at selling price excl. VAT: do not mix them with supplier invoices at cost.
- Target weeks differ by category: outerwear and accessories hold more stock than basics.