Buying budget and cash
How much more you can buy this season and whether cash covers the payments.
About the topic
OTB (open-to-buy) is the buying budget: how much more goods you can order for a period without exceeding planned sales, planned markdowns and the target ending stock. “Open” here means “not yet spent”: part of the budget is already taken by orders, part is free for in-season reorders. The topic is for the buyer who decides how much to take, the product director who splits the budget across categories, and the finance person who checks whether cash will cover supplier payments.
The logic is simple if you see a balance in it. What must leave the warehouse: sales plus markdowns (a markdown also “eats” rubles off the shelf). What must remain: the target ending stock. What you already have: opening stock and goods already ordered. The shortfall is the budget. Illustrative example at selling prices without VAT: season sales plan RUB 100 million, planned markdowns 15 million, target ending stock 30 million, opening stock 25 million, already on order 10 million. Buying budget = 100 + 15 + 30 − 25 − 10 = RUB 110 million at selling price. To get the amount to pay, convert to cost through the initial markup: at a 60% markup on price, cost is 40% of price, that is RUB 44 million. That is what will actually go to suppliers.
Why it is easy to go wrong here: mixing units. The sales plan is usually at selling price, factory orders at cost, and they cannot be added. The second trap is forgetting markdowns: without the 15 million of markdowns the budget is understated by the same amount, and the season ends in either shortage or overload. The third is counting as “ordered” what can still be canceled: the free budget looks smaller than it is.
The budget is not calculated once. First for the season as a whole, then by category with cover in weeks: 10 weeks for dresses, 6 for basic T-shirts, and the sum need not match the total, so it is reconciled. During the season the budget is revised on actual sales: if a week beats plan, reorders open; if it misses, the rest is closed to new orders.
Where to start: take the sales plan and planned markdowns, balances and orders in one unit, calculate the budget, split by category and check by month whether cash will cover payments. This check is separate because the buying budget can be fine while a cash gap still appears because of payment terms.
Key ideas
Budget as a balance: what leaves, what must remain, what is there
Each term moves the budget in its own direction, not only the sales plan. A category: sales RUB 60 million, markdowns 9, target ending stock 21, opening stock 18, on order 20. Budget 60 + 9 + 21 − 18 − 20 = 52 million. If the supplier moved a 12 million shipment to the next period, “on order” drops to 8 and the budget rises to 64: the figure depends on someone else’s delivery dates.
Selling price and cost
The link also works in reverse: payments give the volume at shelf prices. We pay RUB 50 million at an IMU of 55%: that is 50 / 0.45 = about 111 million at selling prices. If the factory raised its price by 8% and the price tags stayed, the cost share rises from 45% to 48.6%, IMU falls to 51.4%, and the same 111 million of sales brings less gross profit.
Weeks of supply (WOS)
WOS shows for how many weeks of sales the stock lasts. A balance of RUB 3.6 million at sales of RUB 0.3 million a week gives 12 weeks. For dresses the norm may be 10, for basic T-shirts 6: it is a risk setting, not a law.
Free and committed parts of the budget
Part of the budget is committed in advance (say 70%), the rest is kept for reorders based on sales. Of RUB 44 million, 30%, that is 13.2 million, is held in reserve. The reserve is there to profit from hits, not only to guard against misses.
Cash separately from budget
A budget in order does not guarantee cash in the right month: a 30% prepayment and the balance at shipment fall in months before sales revenue arrives. So payments are laid out on a calendar and compared with receipts.
The buying plan goes backwards from revenue
The order is derived by a chain: plan revenue 110.0 m RUB, minus the non-seasonal revenue leaves the seasonal 98.0 m RUB; it is divided by the markup coefficient and by one minus the discount to get the cost of goods sold 49.9 m RUB; Sell-through before the sale gives the delivery 58.4 m RUB, cancellation gives the order 63.5 m RUB. Each assumption is visible on its own and open to challenge.
Formula: Order = cost before the sale ÷ sell-through before the sale ÷ (1 − cancellation)
What to do: If the order does not fit the budget, change the plan growth or discounts and record the reason; Sell-through is not fitted to the wanted order.
Think first: Season sell-through came out at 85.3%. What does a value above 100% mean?
Answer: The plan requires selling more than is delivered: revenue is overstated, the markup understated or the discounts too deep.
The markup coefficient is not the markup percent
The coefficient is the price excl. VAT divided by cost: 2.4 is a markup of 140%. If the percent is put into the formula, cost comes out several times lower than the real one. The effective discount of the plan 18.1% is counted from the same coefficient.
Formula: Coefficient = price ÷ cost; markup % = (coefficient − 1) × 100
What to do: Record in the reference which markup you store: the coefficient or the percent.
The receipts tape turns the budget into a schedule by week
The target at the end of the week equals the forecast of the next W weeks; the receipt covers the difference from stock and orders in transit. On illustrative data 920 units are received over eight weeks, the order is due in week 1.
Formula: Receipt = max(0; target − stock before receipt); order week = receipt week − lead time
What to do: Start with the receipts that are already too late to order and compare the sums with the budget remainder.
The budget is split by marginal return
A rouble of purchase gives diminishing profit: on illustrative parameters the optimum gives 0.13 m RUB more than last year shares.
Formula: GM′(x) = (a ÷ b) × e^(−x ÷ b)
What to do: Estimate the parameters over two or three seasons and limit the category minimum.
How to work through it
- Fix the period and the unit: all amounts at selling price without VAT.
- Collect the sales plan, planned markdowns and the target ending stock.
- Subtract opening stock and orders already placed: you get the open budget at selling price.
- Convert to cost via the initial markup and cross-check against actual factory prices.
- Split by category with weeks of supply and reconcile the sum with the total budget.
- Keep a reserve for reorders and define the rule: who opens it and when.
- Check payments by month in the cash flow.
- Recalculate every one to two weeks on actual sales.
Where to start
First the seasonal buying budget, then the split by category with weeks of stock, then opening stock to sales and the merchandise plan traffic light; finally check supplier payments in the monthly cash flow. Calculations of the topic in order: “Open-to-buy (OTB) for the season”, “Buying budget by category and weeks of supply”, “Opening stock: stock-to-sales and the monthly buying budget”, “Merchandise plan traffic light”, “The six-month plan and model stock: stock = sales × coverage + safety, purchases by month”, “Buying plan from revenue backwards: revenue → cost → order”, “Weekly receipts from target weeks of supply (WOS)”, “Buy budget allocation by marginal return”. See also (their primary topic is another one): “Monthly cash flow and cash gap”.
Calculations in this topic
Open-to-buy (OTB) for the season
Calculates how much more you can buy for the season given planned sales, markdowns and target ending stock, net of orders already placed.
How much more can be bought for the season without exceeding the sales plan, markdowns and target ending stock.
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.
In which categories you can still buy and in which you have bought above plan, and how many forward weeks of stock there are.
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.
How much goods to add each month if stock is set as a multiple of sales.
Merchandise plan traffic light
Compares actuals with the plan on key merchandise-plan metrics and colors each green, amber or red by your thresholds. Shows what to look at first. The default thresholds are neutral (“an example”): there is no single Russian benchmark, set them from your own past seasons and targets.
Which plan metrics are already outside the tolerated deviation and where to look first.
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.
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.
Buying plan from revenue backwards: revenue → cost → order
Goes from the net revenue forecast of the current season to the order for the next one: adds the plan growth, subtracts the non-seasonal revenue (old seasons, future ones, consignment, made to order), turns the seasonal revenue into cost of goods sold through the markup coefficient and the period discount, then through Sell-through at cost and the cancellation rate into delivery and order. Shows the effective discount of the plan. The stock under this budget is counted in the “Open-to-buy” calculation; here we answer how large the order must be for the plan revenue to add up.
How large the order must be for the plan revenue to add up at your markup, discounts, sell-through and cancellation, and what effective discount the plan holds.
Weekly receipts from target weeks of supply (WOS)
A weekly receipts tape: at the end of each week the stock must cover the forecast sales of the next W weeks. Counts how much to receive each week allowing for stock and orders in transit, and when to order given the lead time.
How much to receive each week and when to order for the end-of-week stock to cover the sales W weeks ahead.
Buy budget allocation by marginal return
Spreads the buying budget across categories in steps: each next step goes where the marginal return (the growth of gross profit per rouble of purchase) is higher. Compares the result with the split by last year’s shares.
How to spread the budget so that the last rouble gives the same profit in all categories.
Monthly cash flow and cash gap
From monthly receipts and payments calculates the cash balance, the tightest month and the shortfall against a safe minimum.
In which month cash falls below the safe minimum and how much must be raised or deferred.
Self-check questions
- Are all terms of the budget in one unit, at selling price without VAT?
- Are planned markdowns included in the budget?
- Is the target ending stock justified, not taken “as last year”?
- Are orders that can still be canceled counted separately?
- Does the initial markup match actual prices, not the company average?
- Does the sum by category match the total or is the gap explained?
- Is there a reserve for reorders and a rule for opening it?
- Are supplier payments laid out by month and checked against receipts?
- Is the budget revised on actual sales, not once a season?
Knowledge check
Multiple-choice questions. The correct answer and the explanation follow each question.
The markup on a product is 150% of cost. What is the margin on the selling price excluding VAT?
- A. 150%
- B. 60%
- C. 40%
- D. 66.7%
Correct answer: B. 60%. With a cost of 100 the price is 100 × (1 + 1.5) = 250, margin 150 / 250 = 60%. Markup is counted on cost, margin on price: so 150% and 60% describe the same price. 40% is the share of cost in the price (100 / 250), not the margin. 66.7% comes from dividing cost by the markup (100 / 150).
March: sales RUB 6 million, discounts 5% of sales, on order RUB 3 million, opening stock RUB 14 million. April sales are RUB 8 million and the opening stock of a month is planned as 2.5 times that month sales. What is the March purchase budget at retail?
- A. RUB 4.3 million
- B. RUB 9.0 million
- C. RUB 12.3 million
- D. RUB 9.3 million
Correct answer: D. RUB 9.3 million. Closing stock for March = opening stock for April = 2.5 × 8 = RUB 20 million. Purchases = sales + discounts + closing stock − opening stock − on order = 6 + 0.3 + 20 − 14 − 3 = RUB 9.3 million. 4.3 comes from applying the 2.5 ratio to March sales (closing stock 15). 9.0 is the calculation without discounts. 12.3 is the calculation without subtracting what is already on order.
Season sales are RUB 80 million, discounts 10% of sales, the target closing stock RUB 18 million, the opening stock RUB 22 million. Orders of RUB 50 million are placed, RUB 6 million of them can still be canceled. How much purchase budget is free if cancellable orders are not counted as committed?
- A. RUB 40 million
- B. RUB 34 million
- C. RUB 46 million
- D. RUB 28 million
Correct answer: A. RUB 40 million. Budget = 80 + 8 + 18 − 22 − (50 − 6) = 84 − 44 = RUB 40 million. The cancellable RUB 6 million can return to the free budget, so only 44 counts as committed. 34 comes from counting all 50 as committed. 46 comes from subtracting the cancellable part twice (50 − 2 × 6 = 38). 28 comes from adding the cancellable part to what is placed (50 + 6).
What does the order start from when counted backwards from revenue?
- A. The stock in the warehouse
- B. A competitor price
- C. The revenue forecast and the plan growth from which the non-seasonal part is subtracted
- D. The number of stores
Correct answer: C. The revenue forecast and the plan growth from which the non-seasonal part is subtracted. Stock and orders in transit are subtracted by the OTB calculation; the plan chain starts from revenue. Covered in: The buying plan goes backwards from revenue.
The markup coefficient is 2.4. What is the markup in percent?
- A. 140%
- B. 240%
- C. 2%
- D. Cannot be determined
Correct answer: A. 140%. Markup = (coefficient − 1) × 100. Covered in: The markup coefficient is not the markup percent.
How to determine the order week in the receipts tape?
- A. The receipt week plus the lead time
- B. The first week of the season
- C. The receipt week minus the lead time
- D. The week of maximum sales
Correct answer: C. The receipt week minus the lead time. The order must be placed a lead time before the receipt. Covered in: The receipts tape turns the budget into a schedule by week.
What does the equalization of the marginal return between categories mean?
- A. The last rouble of the budget gives the same profit in all categories
- B. All categories get the same share
- C. The profit of categories is the same
- D. The budget is not spent
Correct answer: A. The last rouble of the budget gives the same profit in all categories. This spreads the budget optimally under diminishing returns. Covered in: The budget is split by marginal return.
Common mistakes
Mistake: Mixing selling price and cost
What it costs: The budget is off by a factor of 2–3
How to avoid: Convert via markup once and explicitly.
Mistake: Leaving out markdowns
What it costs: Sales plan not covered by goods and the season ends in shortage or overload
How to avoid: Keep markdowns in the budget formula.
Mistake: Counting cancellable orders as committed
What it costs: Free budget understated, hits missed
How to avoid: A separate line for “can be canceled”.
Mistake: Not checking the payment calendar
What it costs: Budget fine but no cash in the payment month
How to avoid: Always check the flow.
Mistake: Revising once a season
What it costs: Plan error accumulates and shows up too late
How to avoid: Recalculate every one to two weeks.
Substituting the markup percent for the coefficient
What it looks like (illustrative figures): Cost comes out several times lower, the order is understated.
Not subtracting the non-seasonal revenue
What it looks like (illustrative figures): The order also covers what will sell from old seasons and consignment.
One target W for the whole year
What it looks like (illustrative figures): It falls short in the peak and stock sits outside it.
Russia and the EAEU
In Russian practice sales plans and budgets are usually kept at selling price without VAT, and purchases at cost without VAT: under the general tax system VAT is deductible, under the simplified system (USN) input VAT raises the purchase cost, so the tax regime changes the real cost of a shipment. The main VAT rate from 01.01.2026 is 22%; for children’s goods a 10% rate is possible when confirmed (Article 164 of the Tax Code, changes by Law 218-FZ): check the list before calculating the budget for a children’s collection.
Payment terms depend on the scheme. A 30–50% prepayment with the balance at shipment is common with factories; large chains and marketplaces pay with a deferral; take the specific terms from your contract. Electronic document flow and the universal transfer document (UPD) record when title passes, and it is what triggers payment.
For marked goods, add time to receive codes in the Chestny ZNAK system to the order lead time: goods without a code cannot be put into circulation. Orders from abroad also depend on the exchange rate and customs clearance: recalculate the ruble budget at the rate on the payment date and provide for duty and import VAT as a separate line. The key rate affects the cost of money frozen in stock, but its value changes, so take the current one.
The budget formula does not depend on the country; taxes and payment currency differ. For reference: VAT rates by country are on the page “EAEU and CIS countries” (as of 14.11.2026); so the same shelf price gives a different revenue net of VAT and the buying budget in each country must be converted at its own rate. Goods imported from other union countries bear VAT at the place of destination, with an import declaration and supporting documents (Treaty on the EAEU, Annex 18): build the lead time and documents into the payment schedule. Payments to a supplier in a national currency need the rate on the payment date; decide in advance which rate you use.
Categories and audiences
- Apparel
- In apparel the budget is split by seasons and sales stages: before the sale, in the sale, after it. A large share of the winter collection buy falls in early summer, so payments come well before sales. A reserve for reorders is especially valuable for basic T-shirts and knitwear.
- Footwear
- In footwear the order is placed as full size runs and cartons, so there is less flexibility for reorders and minimum quantities are higher. The free budget is smaller, an error in the main order costs more. Hold the reserve for the popular sizes.
- Accessories
- Accessories are bought in smaller lots and more often, the purchase price is lower and the reorder lead time shorter. The budget is easier to keep flexible, but the gifting season needs its own line: stock for December and 8 March has to be built in advance.
- Kids
- In children’s wear the budget is tied to the school season and growth: buying peaks in June–July for sales before 1 September, then drops sharply. Sizes do not carry over to the next year, so ending stock is set more cautiously than in adult categories.
- Men
- In the men’s line part of the budget can be tied down by an agreement with the supplier on reordering basics (shirts, jeans) on the same terms: then the reserve works as a right to reorder. For example, of RUB 44 million, 20%, that is 8.8 million, goes into the reserve for basics, while seasonal outerwear is placed almost entirely in the first order: reordering coats in January is too late.
- Women
- In the women’s line reordering is often limited by fabric and color: the factory buys material for the first batch, and the free budget can really be spent only where fabric is left over or a reorder window is confirmed. Set the reserve not for the category as a whole but for styles with a verified reorder option, otherwise the money exists on paper and there is nothing to order with it.
Questions this topic answers
- How much more can we buy for the season?
- Is there enough cash for supplier payments?
- Have we exceeded the markdown plan and target ending stock?
- How much of the budget is still free to buy in-season and how much is already committed to orders?
Key measures and terms
Study first
What next
Related: “Forecast and budget”, “Assortment and sizes”, “Range: width, depth and price tiers”.
Documents on this topic
- Budget: P&L, cash, purchase, marketing, payroll and CAPEX budgets
- Open-to-buy budget (OTB)
- Retail math by segment: IMU, MMU, markdowns, sell-through, GMROI, turnover
- Optimization of range and allocation: knapsack by budget and shelf, marginal stock allocation, the transport problem
- The six-month merchandise plan and model stock: sales, coverage, safety stock, purchases by month
- Excel for retail, part II: ABC analysis and the open-to-buy (OTB) budget in a spreadsheet
- A buying plan from revenue backwards: revenue, cost, delivery, order and the recalculation rules
- A data cube for planning: measures, dimensions, grain and the season calendar
- The weekly buying tape: weeks of supply, clean rate of sale, safety stock and the season reforecast
- Stock and assortment: inventory valuation, carrying cost, money in transit, budget by category, sizes, clusters and the SKU tail