Syntha Lab RU

Buyer and category manager

Stock, buying budget, assortment, sizes, allocation, replenishment, margin and discounts.

For retail

Open interactively →

Route steps

  1. Quick business check: two periods
    From basic figures of two periods calculates gross margin, operating profitability, turnover, days of inventory, receivables and payables, the cash cycle, the share of returns and old stock and shows which way each moved.
  2. Days of inventory and excess stock
    Shows how many days of sales sit in stock for each category, how much money is frozen above target, and what carrying that excess costs. For seasonal businesses first calculate average stock in Average stock for the year: here you enter the average stock of each category for the period, and categories are compared with each other.
  3. 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.
  4. 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.
  5. ABC analysis of the range
    Splits styles or groups into A, B and C by contribution to revenue or margin: what feeds the business, the middle, and what can be cut.
  6. Size curve: how to split a buy across sizes
    Uses sales by size to compute each size’s share and splits the quantity to buy across sizes. Compares with a flat split and shows how many units would end up in the wrong sizes.
  7. Allocation of stock across stores
    Splits an incoming run across stores in proportion to their sales taking existing stock and capacity into account, keeping part at the warehouse for replenishment.
  8. Size-run completeness and core sizes
    Finds the core sizes of a style, shows whether the run is intact, how many weeks of sales each size covers and which sizes to top up or redistribute.
  9. Reorder point and safety stock
    Calculates the stock level at which to reorder, how much safety stock to hold and how much to order now for an item or group.
  10. Reorder from early sales
    Builds a season forecast from the first weeks of sales and the cumulative curve of past seasons, estimates the reorder needed (low, central and high) and calculates the profit of the reorder lot including the rush surcharge and the minimum lot.
  11. Season sell-through pace and leftover risk
    From sales so far shows the sold share, stock in weeks, the forecast leftover at season end and the pace needed to reach the target.
  12. Initial and maintained margin
    Shows how much margin you planned at the ticket price and how much remained after markdowns and discounts: initial and maintained margin, markdown share and gross margin by category.
  13. Weekly markdown ladder: discount steps and an ending-stock goal
    Compares three scenarios to the end of the season: keep the price, cut in steps, or one deep cut at the end. Shows the ending stock, the result including the clearance of leftovers, the exit price and warns when a discount does not pay back.
  14. Elasticity from a past promotion
    Derives price elasticity from your sales before and during a promotion, shows a range from two observations, the sales growth needed to pay back, the result of the promotion in profit and the size of the dip after it.

Documents for this route

Other routes for this audience