Calculations
Calculation models: the question each answers, the data needed, how to read the result, worked numbers.
Revenue, profit and costs
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.
Profit and loss statement and profitability
From revenue to net profit: gross profit, costs, earnings before depreciation (EBITDA), operating and net profit, profitability and each line’s share of revenue.
Fixed and variable costs, margin of safety
Splits costs into variable (rising with revenue) and fixed, calculates break-even revenue, margin of safety and shows how strongly profit reacts to a change in sales.
Revenue analysis: price, volume and mix
Splits the deviation of revenue from plan into three causes: price change, volume change and change in the product mix. Answers why revenue did not match.
Gross-margin bridge by cause
Splits the change in gross margin between two periods by cause: price and discounts, channel mix, reserve, cost, freight. Shows each cause in margin points and in money and what remains unexplained.
Profit bridge: full-price sales growth and flow-through
Shows what the next period’s profit is made of: full-price sales growth is multiplied by the share that reaches profit (flow-through), then cost growth is subtracted and savings added. If the actual profit is known, it computes the actual share.
Management balance sheet from the P&L and turnover figures
From the P&L, the inventory, receivable and payable days and the opening balance sheet builds the closing balance sheet: cash by the indirect method, assets, liabilities, equity; checks that it ties, shows net working capital and net debt and compares the calculated cash with the actual.
Price and volume indices: Laspeyres, Paasche, Fisher and the chain index
From the prices and quantities of a group of goods in two (or three) periods calculates the Laspeyres, Paasche and Fisher price indices, the volume indices, splits the revenue growth in roubles into price growth and volume growth (real growth) and compares the chain index over three periods with the direct one.
Overheads by product and responsibility center: three allocation keys
Splits the common pool of overheads across lines (products, categories, channels or financial responsibility centers) with three keys: by revenue, by units and by cost driver (orders, shipment lines, hours). Shows each line’s profit under each key and which lines change sign: the allocation key can make a line “loss-making” or “profitable” without a rouble of real saving.
Loss map: where a brand loses money and how much of it can be recovered
From a list of loss lines (base, loss rate, the share that can really be recovered) calculates the loss of each line in money, its share in total losses and in revenue, compares losses with EBITDA, shows the concentration (the three main lines), the recoverable part and the EBITDA after recovery and, with a target margin, whether recovery closes the gap to the target. Ranks the lines by size so you start with the main one.
Season result: from gross sales to contribution
Lays out the season result as a ladder: gross sales at list price, discounts, returns, net sales, cost of goods, gross margin, write-offs, selling costs. Shows how many margin points discounts ate. Fits a brand, a category and a retailer; check the names of the rungs against your own reporting.
Categories: contribution to growth and margin, this year versus last
Shows which categories raised or dropped sales and how many points of growth each gave, and splits the change in the total margin into a mix effect (category shares shifted) and a rate effect (margin within categories changed).
Brand history by season: growth, discounts, margin and sell-through
Builds a history report for a brand or category: net sales, discount depth, gross margin and sell-through by season, and compares each season with the same season a year earlier and the last year with the previous one.
Stock and turnover
Average stock for the year and turnover
Calculates average stock from monthly balances, turnover and days of inventory and shows how far a one-date balance distorts the picture in a seasonal business.
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.
Stock age and price-reduction provision
Splits stock by age, shows the share of old goods, the expected loss on clearance and the cost of holding the stock.
GMROI: gross profit per unit of stock
Compares categories by return on stock: gross profit per unit of money invested in stock, and turnover. Shows what earns and what only freezes cash.
GMROI: margin and turnover levers
Splits GMROI (gross profit per rouble of average stock at cost) into margin and turnover and shows what a margin point, faster turnover and a smaller stock would give. You enter the target yourself.
Inventory write-down: cost against net realizable value
For stock groups compares cost with net realizable value (expected price less costs to sell), calculates the write-down, stock at the lower of the two and how much to add to the reserve already created.
Inventory carrying cost rate
Builds a single inventory carrying cost rate from five components (capital, storage, insurance and shrink, obsolescence, handling) and converts it into roubles per unit and per average stock. This rate is used by the order size, carry-over and discount-versus-holding calculations.
Inventory valuation: FIFO, average and retail method
Compares three ways to value stock and the cost of goods sold on the same batches: write-off from the earliest (FIFO), weighted average and the retail method. Shows the difference in gross profit and stock, marks the method of the accounting policy and the age of the FIFO remainder.
Pipeline inventory and tied-up cash
Counts how much money is tied up while the goods are on the way and in production: payments to the supplier go before the receipt, and the weighted time from payment to receipt is longer than the physical transit. Shows the annual cost of capital and the saving from cutting the term.
Cash conversion cycle and working capital
Shows how many days money lives in stock and receivables net of supplier credit, and how much capital it freezes.
Stock record accuracy and the cost of mismatches
From a sample count it calculates record accuracy by lines and by value, the net balance of mismatches and estimates the lost revenue from “phantom” stock: an item is on record but not on the shelf.
Transfers between points: surplus, need and the gain against a discount
From the stock and selling speed of each point (a store or a warehouse) finds where there is a surplus above the required cover and where a shortage, picks transfers with lot multiples and compares the cost of moving with the discount that would have to be given to clear the surplus on the spot.
Defects: losses, supplier recovery and a reserve
By category counts the defect rate, the loss at cost, the proceeds from selling defective items (second grade), the supplier’s recovery, the net loss and an estimate of a reserve for the next period. Shows where defects cost most.
Buying budget and cash
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.
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.
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.
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.
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.
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.
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.
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.
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.
Season, price and discounts
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.
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.
Post-season review by category
After the season shows what sold at full price, how much went on markdown, the margin that was left and how much money sits in leftovers. A basis for the next buy.
Promo discount: the sales lift that makes it pay
Shows how much more you must sell for a promo discount not to reduce profit, and compares promo discount depths. Cutting the price of leftovers at season end needs a different calculation: it looks at the stock, not at the sales lift.
Control week: full-price sell-through
At the control week of the season, separates what sold at full price from what sold on discount, calculates sell-through from the on-hand stock at the start of the season, compares it with your goal and red line, shows the pace to the season goal and suggests: revisit the price-cut schedule, hold or consider a reorder.
Reference sell-through curve: season-end projection and gap
Takes the curve of past seasons (what share of the final sell-through was reached by each week), divides the current sell-through by it and gets the season-end projection instead of a straight-line pace. Compares the projection with the plan: the gap in percentage points and in pieces of under-sale, a signal “ahead”, “on track” or “behind” and the last week when a decision can still work. It complements “Sell-through” (pace and stock projection) and “Control week”: here the shape of the season comes from your own history.
Price-cut trigger rules by item
Applies a rule to each item: if the stock coverage in weeks is above the threshold and the item has been on the shelf long enough, it goes into the price cut, and the depth depends on the coverage tier (for example, 12–16 weeks minus 20%, 16–24 minus 30%, above 24 minus 40%). Novelties, bestsellers and the core range go into exceptions. Shows the label and tier for each item, the number of items and the stock sum in the cut. It is a selection rule in practice; the dates and depth by scenario are counted by the “Discount ladder” and “Sale stages”.
Price, markup and margin
Converts markup, margin and shelf price into each other including VAT and shows the profit left per unit.
Price position among competitors
Compares your price with prices of similar items: median, range, rank and gap. Shows whether you are expensive or cheap for the market and which price falls inside the corridor.
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.
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.
Promotion result: incremental profit
Compares the profit of a promotion with the profit you would have had without it and subtracts cannibalization, pull-forward demand and costs. Shows the required and actual sales growth, the baseline cushion and the sensitivity to its estimate.
Clearance scenarios compared by goal
Compares several price-reduction scenarios (at most two steps in each) by three goals: the result including leftovers, sales volume and capital tied up in stock. The demand model is the same as in “Weekly markdown ladder”, so with the same data the results match. This is a Syntha Lab model, not a forecast.
Season stages: BS, IS, AS, SO
Splits a season into four stages (before the sale, in the sale, after it, the final clearance): sales, share of the stage, discount depth, gross margin, stock at the end of the stage and cover. Shows how much the season earned at full price, how much it gave away in discounts and where the leftover remained.
Season result: from gross sales to contribution
Lays out the season result as a ladder: gross sales at list price, discounts, returns, net sales, cost of goods, gross margin, write-offs, selling costs. Shows how many margin points discounts ate. Fits a brand, a category and a retailer; check the names of the rungs against your own reporting.
Sell-through by delivery: speed and time to sell out
Compares the deliveries (drops) of a season: what share of each delivery is sold and what share at full price, at what speed it sells and in how many weeks it will finish at the current pace. Shows which delivery has become heavy.
SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale
Ranks SKUs by net sales, assigns class A, B or C by the cumulative share and compares it with sell-through. A bestseller is class A with a high sell-through, a slow seller is one with a low sell-through, “no-sale” is a SKU with no sales. You set the thresholds; the calculation shows the quartiles of your data as a hint.
New and carryover: share, return per SKU, sell-through and margin
Compares groups of SKUs of a season, for example new items, carryover (carried over from past seasons) and basics: the share in the range and in sales, sales per SKU, sell-through and margin. Shows which group gives a return above its share in the range.
Price monitoring by SKU: index to the market, position and price-scraping freshness
From a table of prices collected by scraping competitors calculates for each SKU the market median and minimum, your price index, your place among the competitors and the status against the corridor. Excludes stale data and SKUs with too few competitors from the total so that the index is not built on noise.
Season matrix: product season × sales month and stock against the window
From 12 months of sales in four groups (SS, AW, leftovers of past seasons, core) calculates the share of seasonal goods and leftovers by month and calendar season, how much of its sales each season makes inside its own window and whether the window is enough to sell the stock.
Assortment and sizes
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.
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.
Size curve by store cluster and pack composition
Splits the buy across store clusters and sizes using each cluster’s past sales, picks the composition of a ready pack (prepack) for the cluster’s curve, rounds the buy to whole packs and shows how many pieces end up in the wrong sizes. Compares a pack per cluster with one pack for the whole chain, and picking to order with a ready pack.
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.
Size recommendation: payback of the tool
Calculates whether an online size-recommendation tool (a widget, a measurement-based hint, a size chart) pays back: how many size returns it removes, what one return costs, the net effect per month and the payback of the launch cost. Shows the reduction in returns at which the tool breaks even.
ABC-XYZ matrix: a SKU’s contribution to sales and demand stability
From a table of SKU sales over several periods splits them into classes A, B, C by contribution to sales and X, Y, Z by demand stability (the coefficient of variation), shows the matrix of sales shares and the number of SKUs and suggests a stock policy for each SKU.
Choosing items under the buying budget and the shelf: a greedy set and an exact scan
From a list of items (each taken whole) chooses the set with the highest expected margin under the buying budget and shelf limits: a greedy set by margin per unit of scarcity and the exact set by scan, the gap between them, the use of the budget and the shelf and the value of an extra 10% of budget.
Swimwear and lingerie: returns by size run, hygiene write-offs and margin per ordered unit
From the price, the cost, the channel commission, the logistics and a table of size groups (share of orders and share of returns) it counts the weighted return rate and the margin per ordered unit including returned goods that cannot be resold (the hygiene liner is removed, the item has been worn). It shows the loss caused by returns, returns in units, the return rate at which the margin falls to zero and the size groups that pull the margin down. Check the requirements for returning lingerie and swimwear and the list of items that cannot be resold after a return against the current sales rules; the share that cannot be resold and all default values are illustrative.
Store clusters: productivity and mix profile
Groups stores by the productivity index (sales per m² to the network average) and by the similarity of the category profile to the network profile. The result is clusters A, B, D and the “special profile” flag for the size curve, display and replenishment.
Cost of assortment complexity: the SKU tail
For assortment bands (by revenue) counts the contribution, the fixed cost per SKU and the net result; shows what is better: to cut a band or to keep it if part of its sales moves to the remaining SKUs.
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.
SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale
Ranks SKUs by net sales, assigns class A, B or C by the cumulative share and compares it with sell-through. A bestseller is class A with a high sell-through, a slow seller is one with a low sell-through, “no-sale” is a SKU with no sales. You set the thresholds; the calculation shows the quartiles of your data as a hint.
Replenishment and stock cover
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.
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.
Safety stock by fill rate and lead-time variability
Counts safety stock in two ways: by cycle service level (the probability of not running out) and by fill rate (what part of demand is met from the shelf), with demand and lead-time variability; shows reorder points and the money in stock.
Intermittent demand: Croston and SBA for rare sizes and accessories
From a series of sales with many zero periods estimates the expected demand per period by the Croston method or its SBA correction, sets the demand class (smooth, erratic, intermittent, lumpy), compares the accuracy with simple smoothing and shows the expected demand over the lead time.
Initial allocation of a new item without history
Spreads the first batch of a new item across stores of three grades with a central reserve for top-ups: the grade weight, the minimum display, rounding by the largest remainder. Shows the allocation per store and the actual reserve.
Safety stock from forecast error
Counts safety stock from the forecast accuracy rather than the demand scatter: the weekly error from WAPE, the accumulation of the error over the lead time and review with the correlation of weeks, the service level. Shows the bounds for independent and fully linked errors.
Normalized rate of sale
Cleans the rate of sale: divides weekly sales by in-stock days, excludes promotion weeks and weeks with few in-stock days, counts the base rate, the promotion uplift, the cover of stock and the XYZ stability class.
Does moving stock between stores pay back
Identifies donors and recipients by cover to the season end, the pieces to move, the gain per piece (with sale probabilities), the total result including fixed costs and the break-even transport cost.
First order and reserve for reorders
Calculates what share of the plan to order at once and how much capacity to keep for a reorder after the first sales. Compares the expected profit, leftover and lost sales of a two-stage order with a single large order. The logic is our own: demand is given by scenarios, early sales remove part of the uncertainty, a reorder costs more and is limited by capacity.
Transfers between points: surplus, need and the gain against a discount
From the stock and selling speed of each point (a store or a warehouse) finds where there is a surplus above the required cover and where a shortage, picks transfers with lot multiples and compares the cost of moving with the discount that would have to be given to clear the surplus on the spot.
Replenishment by size: what and how much to send to stores by size
From the stock, the goods in transit and the sales of each “store × size” cell calculates the target stock in weeks of cover with a minimum display, the need rounded up to the pack multiple and distributes the limited warehouse across sizes: cells with the lowest cover first. Shows how much to send and what the warehouse lacks.
EOQ: economic order quantity with a minimum lot and volume discounts
Finds the order size at which ordering and holding costs together are lowest, tests volume price breaks, respects the minimum lot and the pack multiple, and shows annual costs and the saving against your size.
Store and chain
Store economics
From traffic and conversion to store profit: revenue, break-even, rent share and payback of the investment.
Store comparison across the chain
Puts stores side by side: revenue per m² and per employee, rent share, store profit. Shows which stores carry the chain and which lose money.
Store indicators: ticket, conversion, space, staff
For each store calculates average ticket, units per ticket, average unit price, conversion, sales per m² and per employee and comparable growth, and shows which stores lag.
Store benchmark: expected sales from area and traffic
From a table of stores it fits the model “sales = a + b₁ × area + b₂ × traffic” by least squares, counts the expected sales of each store and the deviation of the actual from the expected. Stores below the deviation threshold are marked as underperforming; for a new place the expected sales can be obtained from its area and traffic. It shows the quality of the model (R²) and warns about a small chain and a strong link of area with traffic.
Sales equation: traffic, conversion, units per receipt, price per unit
Splits the change in a store’s sales between two periods into four causes: how many people entered, what share bought, how many units per receipt and the price per unit. Sales = traffic × conversion × units per receipt (UPT) × price per unit (AUR). Shows what exactly pulls sales up or down.
Plan versus actual by store: pace, period forecast, required daily pace
Compares the actual to date with the plan for the whole period and with the pace-plan for the same number of days, forecasts the end of the period at the current pace and calculates how much must be sold a day to reach the plan. Shows which stores lag behind the pace and by how much.
Receipt structure: ticket bands, average ticket, UPT and contribution to sales
Splits receipts into amount bands: how many receipts and what share of sales fall into each, the average ticket, units per receipt and the price per unit. Shows which receipts the revenue rests on and where the median receipt lies.
Discounted receipts: share, depth and the ticket with a discount versus full price
Shows what share of receipts goes with a discount, the average depth of the discount in those receipts, how discounts eat into the list price and how a discounted receipt differs from a full-price one, including at list price. Helps see which purchases the discounts rest on.
Forecast and budget
Sales forecast: method, horizon, error
Builds a forecast from sales history using four methods, shows each method’s error on past data and suggests which is more reliable for your series.
Sales plan by store
Splits the chain’s revenue plan across stores: growth of existing stores, new stores ramping up, closures and partial years. Shows the total against last year and against the target.
Brand order book versus the season plan
Checks confirmed and expected buyer orders against the season target: plan coverage, weighted forecast, gap and dependence on the largest customer.
Annual budget by month
From last year’s revenue, growth and cost structure builds a monthly income and expense budget: revenue, gross profit, EBITDA and the months in which the business goes into the red.
Income and expense budget: plan versus actual
Combines plan and actual of the profit and loss statement, shows variances by line and what drove the profit.
Zero-based budget: cost packages, priority and the effect of cut-off by level
Takes cost packages with priority, cost and effect, funds the mandatory ones and then by priority up to the limit, shows the cut-off line, the money saved and the effect of the cut packages; the table compares budget levels from 100% to 70% of the request.
Seasonal buying: critical ratio and the optimal quantity under normal demand
Finds the buying quantity of a seasonal item that maximizes expected profit when demand is given by a mean and a spread: the critical ratio, the stock-out probability, expected leftovers and lost sales, the gain against your plan.
Season Monte Carlo: the probability of meeting margin and profit
Plays the season many times with random demand and cost (with a fixed seed, the result is reproducible) and shows the probability of meeting the margin and profit targets, profit percentiles, the average tail of bad seasons, the stock-out probability and the expected leftover.
Holt-Winters: a forecast with trend and seasonality, error on held-out periods
From a series of sales by period builds a forecast with level, trend and seasonal indices (additive or multiplicative), picks the smoothing parameters, tests the accuracy on the last held-out periods (WAPE, bias, a comparison with the naive seasonal forecast) and shows an approximate band.
Forecast value added by stage and the price of error in roubles: the season assortment
For groups of the assortment compares three forecasts of one season: naive (a repeat of the last season), a model (statistics or AI) and the result after manual adjustments. Counts the WAPE and bias of each stage, the value added of each step (FVA) and turns the error into roubles: over-forecast costs a markdown and holding, under-forecast costs lost margin. The definitions of WAPE, bias and FVA are given in the “Forecast accuracy by week” calculation (fcdash); here the point is the price of error and the stages.
In-season reforecast
Adjusts the forecast of the rest of the season by how the actual is going: the more weeks have passed, the more weight the ratio of the actual to the plan to date gets. Shows the season forecast, the deviation from the plan and the change in the rest.
Seasonality indices from history
Counts 12 monthly seasonality indices from sales over 2–3 years: each month is divided by the monthly average of its year, the indices are averaged and brought to a sum of 12. Shows the span of seasonality and spreads the annual plan across months.
Weather adjustment of demand
By weeks builds the link of category sales with the temperature deviation from the norm (a least squares line), estimates its reliability and recalculates the forecast for the expected temperature deviation.
Top-down vs bottom-up forecast reconciliation
Reconciles the category forecast (top-down) and the sum of the SKU forecasts (bottom-up): the scale, the bias of SKU forecasts and the reconciled SKUs at a given trust in the category level. Shows how much more optimistic the SKU forecasts are than the category.
Management balance sheet from the P&L and turnover figures
From the P&L, the inventory, receivable and payable days and the opening balance sheet builds the closing balance sheet: cash by the indirect method, assets, liabilities, equity; checks that it ties, shows net working capital and net debt and compares the calculated cash with the actual.
Overheads by product and responsibility center: three allocation keys
Splits the common pool of overheads across lines (products, categories, channels or financial responsibility centers) with three keys: by revenue, by units and by cost driver (orders, shipment lines, hours). Shows each line’s profit under each key and which lines change sign: the allocation key can make a line “loss-making” or “profitable” without a rouble of real saving.
Taxes and VAT
VAT for a period: charged, deductible, payable
Calculates VAT on sales, input VAT on purchases and the amount payable or refundable, plus the tax burden on revenue.
Tax regime: simplified or general system
Compares tax under the simplified regime on income, the simplified regime on income minus expenses, and the general system (corporate income tax) for your revenue and costs, and shows the point at which the better option changes.
VAT threshold on the simplified regime: when you start paying and which rate is better
From monthly income shows the month you pass the VAT exemption threshold and compares VAT at the special 5% or 7% rate (no deduction) with the general 22% rate (input VAT deducted). Finds the point where the options are equal.
Input VAT split and the 5% rule
Splits the input VAT on common costs between the deduction and cost (in tax accounting) in proportion to taxable and exempt shipments, adds the VAT on costs of only taxable and only exempt operations and checks whether the costs of exempt operations fit into the “five percent” threshold. The threshold is entered by you with a date.
Investment and store openings
Investment project: NPV, IRR and payback
Appraises a project from its cash flows: opening a store, launching a collection, buying equipment. Calculates net present value, internal rate of return and payback.
Cannibalization on a store opening: the chain’s net gain
Compares the sales of neighboring stores before and after a new store opens with an adjustment for the growth of control stores, calculates the neighbors’ loss, the cannibalization rate, the net sales gain and the new store’s contribution with and without the loss.
WACC: cost of capital, ROIC against WACC and economic profit
Calculates the weighted average cost of capital from the shares, the cost of equity and debt after tax, then compares it with ROIC and finds economic profit (EVA); the table shows how WACC and EVA change at another debt share.
Store economics
From traffic and conversion to store profit: revenue, break-even, rent share and payback of the investment.
Lease under FSBU 25: liability, right of use and moving rent below EBITDA
Computes for a premises lease the present value of payments (the liability), the right-of-use asset, interest and depreciation by year and shows how much EBITDA grows with the same cash flow because the rent moves from operating costs into depreciation and interest. Needed by a retailer when opening a store, by a brand with retail and in a talk with a bank about covenants.
Platforms and marketplaces
Marketplace unit economics and break-even price
Calculates what is left per sold unit after commission, logistics, storage, advertising, returns and tax, and at what price and ad spend a sale breaks even.
Returns: what they cost and how they hit margin
Calculates the loss from returns: reverse logistics, resale at a discount, write-off, lost profit. Shows the maximum return rate at which profit is zero.
Returns policy: effect on profit
Compares profit under the current and a new returns policy (a fee for a return, a period, rules) with your estimate of the change in demand and in the return share. Shows the cost of returns from trying several sizes (bracketing) and the order-change threshold beyond which the new policy does not pay.
Contribution levels CM1–CM3 by channel with buyout
For sales channels (site, platforms, partners) calculates contribution step by step: CM1 after cost of goods and commissions on what was bought, CM2 after logistics and handling of orders and returns, CM3 after marketing. Shows contribution per order and the allowable marketing per order.
Platform report reconciliation: deductions by item, payout and the difference from the records
Compares the platform report for the period with your records: checks the arithmetic of the report (revenue minus deductions equals the payout), reconciles revenue, commission by rate, logistics by the number of orders and returns, storage, fines, advertising and other with the expected, shows the items outside the tolerance, the difference between the report payout and the receipt on the account and the sum worth claiming.
Platform warehouse or own warehouse (FBO and FBS): the full cost of an ordered unit and the storage term
Compares two schemes for one product: the platform warehouse (storage, acceptance and logistics at the platform) and your own warehouse (your picking and your own storage, platform delivery). Calculates profit per ordered unit with returns, storage by day and the cost of money in stock, finds the storage term up to which the platform warehouse scheme pays, the money in stock and the monthly profit in each scheme.
A niche and an item on a platform: capacity, competition, the newcomer’s expected sales, a pilot batch and the entry point
From a table of niches (demand per month, the number of sellers with sales, the share of the ten leaders, price, cost) it counts the capacity of the niche, the share of an average seller and the expected sales of a new seller, the size of the pilot batch, the profit of the pilot and the time to sell out, the entry point (how many units a month are needed for the contribution to cover the fixed costs of an item) and the decision “go, test or no”. Take demand and the number of sellers from the platform’s analytics, set the platform’s holdbacks and advertising as one share: the exact figure comes from the “Marketplace unit economics” calculation.
Marketplace logistics from dimensions: from liters to the cost of an order
Turns the package dimensions into volume in liters, then into direct logistics by the platform tariff (a base for the first liter, a price for each next one, warehouse and localization coefficients) and adds the reverse logistics of non-redeemed orders. Shows the cost per order, per redeemed unit and the share of the price, and how it grows as the redemption rate falls. Enter the tariff yourself on the date of the calculation: it changes several times a year.
Supply size and frequency to a marketplace warehouse
Picks the size of a supply to the marketplace warehouse at which the sum of supply and storage costs is lowest: the platform storage fee and the cost of tied-up money give the daily holding cost of a unit, the fixed cost of a supply is spread over the frequency. Shows the size, the cover in days, the number of supplies per year and the annual costs, takes the minimum lot and the storage period without the paid zone into account.
Tax on marketplace turnover by regime (a guide, needs a specialist check)
Compares the tax and the remainder after tax per one redeemed unit when selling through a platform by regime: the simplified system with the “income” object, with the “income minus costs” object and the general system (VAT and corporate income tax). Tax is counted from the selling price to the buyer, not from the platform payout. You enter all rates yourself as guide values on a date; the calculation does not replace an accountant and gives no legal conclusions.
Size recommendation: payback of the tool
Calculates whether an online size-recommendation tool (a widget, a measurement-based hint, a size chart) pays back: how many size returns it removes, what one return costs, the net effect per month and the payback of the launch cost. Shows the reduction in returns at which the tool breaks even.
Platform commission increase: profit loss and price rise
Shows how much monthly profit a commission increase will take, how far to raise the price to keep the money margin or the margin share per unit, and what pays more at your elasticity: absorb it, raise the price to break-even or stop at the optimal rise. A table for 1–5 pp of growth is below. The notice of changed terms is covered in “Platform notice period”.
Footwear returns: reasons, reverse logistics, the share back on sale and the loss
Splits footwear returns by reason (size, defect, did not like), calculates reverse logistics and handling, what share went back on sale as new and at a reduced price (worn returns), how much is lost on the price reduction and write-offs and what one return costs.
Cost and price
Unit cost from the bill of materials
Builds the unit cost from a bill of materials: materials with waste, operations by factory minutes, overhead, defects, samples, logistics and duty. Then builds the price up to the shelf and shows where each rouble comes from.
Cost and price: from fabric to the shelf
Builds the unit cost from line items and the price chain: brand wholesale price, retail excl. VAT, shelf price.
Allowable cost from the shelf price
Works from the market back to the factory: from the shelf price, the retailer margin and the brand’s target margin it computes the cost you can afford and the gap against today’s cost.
Price, markup and margin
Converts markup, margin and shelf price into each other including VAT and shows the profit left per unit.
Price position among competitors
Compares your price with prices of similar items: median, range, rank and gap. Shows whether you are expensive or cheap for the market and which price falls inside the corridor.
Supplier terms: total cost of buying per unit of demand
Compares 2-4 suppliers not by list price but by total cost: minimum order and excess, a discount or retro bonus, prepayment and credit (cost of money), defects and returns, shortfall, consignment. Ranks with a risk premium.
Pocket price: what the brand keeps from a delivery after all concessions
For each set of terms (a customer, a contract) deducts line by line from the list price the on-invoice discount, retro bonus, marketing development funds (MDF), listing fee, deductions and penalties and the early-payment discount, and shows the pocket price, the leakage from list and the pocket margin. Compares the terms with each other.
Elasticity from a price and sales table: log-log regression with an interval
From a table of prices and sales over equal periods estimates the price elasticity of demand by least squares in logarithms, shows the confidence interval, the goodness of fit, the forecast of sales and gross profit at a new price and the profit-maximizing price.
Price for a country: from the target margin and commission to the shelf price in the local currency, an exchange rate reserve and a discount reserve
From the unit costs, the target margin, the channel commission, the country VAT, the rate, the exchange rate reserve and the rounding step it counts the shelf price in the local currency for each country in the table, including a duty if the goods come from a third country. It shows the margin now and after an exchange rate shift, the premium to the Russian price (gray re-export is possible if the price is below the Russian one) and the discount reserve down to the minimum margin. The channel commission is set by a field: suppose 15%, take it from the offer.
Technical clothing: the price of materials by layer, finishing, batch tests and the permissible price of the shell fabric
From a table of layers and trims (quantity, cutting reserve, price per unit), the finishing of the fabric, the batch tests and the labor it counts the cost per garment, the price without VAT and on the shelf, the share of the shell fabric in the cost and the premium that a functional fabric gives against an ordinary one. It shows at what price of the shell fabric the margin falls to the minimum. The default values are illustrative: take the prices of fabrics, membranes and insulation from your own quotes and the test reports from the laboratory.
Denim: fabric consumption with shrinkage, the garment price by stage and the cost of defects at washing
The fabric consumption at the finished size, the shrinkage in length and width, other fabric losses, the price per meter and the cost of the stages with a defect rate (cutting, sewing with trims, washing, finishing, packing) give the fabric consumption with the shrinkage allowance. From them the garment price after each stage, the contribution of defects to the price, the shelf price and the price of one point of shrinkage are counted. It shows why a garment costs more than the sum of operations: a defect at a late stage carries all the price already invested. Shrinkage and defects depend on the fabric, the washing and the factory: put in the results of a trial batch; the default values are illustrative.
Knitwear: yarn consumption, knitting and dyeing waste, the garment price by stage and a gauge-change scenario
The weight of the finished garment, the yarn count and ply, the losses at knitting, cutting and dyeing, the price of yarn, dyeing and operations give the length and the weight of the yarn bought and the waste. From them the cost per garment by stage (yarn, dyeing, knitting, assembly, finishing, trims), the shelf price and the price of a kilogram of finished knitwear are counted. The scenario shows what a finer gauge or a yarn with a different count gives: the weight and the knitting price change and the cost is counted again. The default values are illustrative: take yarn and knitting prices from your own quotes and losses from a trial batch.
Jewelry: cost by metal, fineness and stones, the price and the metal price at which the margin falls to the minimum
From the weight of an item, the fineness, the price of pure metal, the production losses, the stones, the labor and the fees it counts the weight of pure metal and of the metal bought with losses, the cost by item, the price without VAT and on the shelf, the share of metal and stones, the price per gram of the item and the sensitivity to the metal price: by how much the cost and the price change when the quotation shifts and at what metal price the margin falls to the minimum. Check the rules of accounting for precious metals and stones, assay hallmarking, marking and reporting in the state control system against the current norms; the default values are illustrative.
Optimal price from elasticity and cost
Finds the price giving the highest profit at a constant demand elasticity: from cost, the share of fees and acquiring, and the elasticity it counts the price excl. VAT and on the shelf, the volume and the profit against the current price. Takes the shelf price corridor into account (competitors, thresholds). At an absolute elasticity of one or less there is no interior optimum, and the calculation says so. Optionally checks the elasticity against two observations and warns if the optimum lies outside the observed price range. The elasticity is estimated by the “Demand elasticity” and “Elasticity from points” calculations: here it is used.
Regional price zones: profit from different prices
Compares the profit at different prices in two or three zones (regions, formats, channels) and at one common price. For each zone from its elasticity and cost it counts its own price and profit, finds the best single price on a grid and shows the zones’ gain in roubles and percent. Checks the spillover: if the price gap exceeds the cost of shipping or of the customer’s trip, the zones will not hold. It complements the price corridors by country and channel: here are different elasticities inside one country.
Acceptable price range from a survey (price sensitivity meter)
Builds the acceptable price range from the answers of customers to four questions: at what price the item is “too cheap” (raises doubt about quality), “cheap”, “expensive” and “too expensive” (you would not buy). From the cumulative shares over a price grid it finds four points: the lower bound of acceptability (PMC), the optimal point (OPP), the indifference point (IPP) and the upper bound (PME). The acceptable price range lies between PMC and PME. It is a method of price perception, not of market prices: market prices are counted by “Price ladder” and “Price monitoring”, the survey sample size by “Survey sample size”.
Launch price: skimming vs penetration
Compares two launch price strategies by the willingness to pay of different customer groups. A single price: the best of the groups’ maximum prices, selling to the groups whose willingness is not below the price. Skimming: first a high price, then steps down, each step taking new customers. Counts the profit of a single price, the profit of your step scheme with a share of customers who wait for the cut, the upper bound of ideal steps, the best schemes of one, two and three steps and the share of waiting customers at which the steps stop winning. For limited collections and drops; on marketplaces price transparency makes steps work worse. In-season prices are counted by the “Discount ladder” and “Scarcity and drops”.
Comparing quotes: CMT, FOB, full package
Brings factory quotes in different “packages” (cut and make only, with materials, full package) to one basis: the item price in your warehouse with brand materials, losses, logistics, one-off costs and the cost of money. Shows the gap to the target cost.
Price monitoring by SKU: index to the market, position and price-scraping freshness
From a table of prices collected by scraping competitors calculates for each SKU the market median and minimum, your price index, your place among the competitors and the status against the corridor. Excludes stale data and SKUs with too few competitors from the total so that the index is not built on noise.
Price increase: volume, margin and notice period
Plans a price rise: the new price incl. VAT, the margin gain, volume loss at your elasticity, the profit result, the tolerable volume fall and elasticity, the model’s optimal rise and a table by rise size. Checks whether the days to the date cover the contract’s notice period.
Production and import
Cut-and-make price from factory minutes (CM)
From factory capacity and costs to the cost of a minute, the cut-and-make price of an item, capacity in units and the lead time of an order. Method: cost per minute × standard time of the item.
Material use and cutting waste
Calculates material cost per unit and per order including cutting waste and defects, how many meters to buy and how much money goes to waste.
Marker: efficiency and the price of a percentage point
From the pattern area in CAD and the marker length and width, calculates marker and fabric utilization, use per piece, the cost of losses and the price of one percentage point of efficiency.
Production load plan
Matches orders against factory capacity: how many standard minutes are needed, how many available, load, the timing of each order and how many extra workers or overtime hours are required.
Landed cost of an imported item
Adds supplier price, exchange rate, freight, insurance, duty and fees into the full cost of a unit in your warehouse and shows how the exchange rate moves it.
Landed cost by style: spreading the shipment
Splits the shared shipment costs (freight, broker, storage, tests, delivery) across styles by a chosen key (weight, volume, value or pieces), calculates duty on the customs value rather than the FOB price and shows import VAT separately. Gives the landed cost per piece and the markup over the factory price for each style.
Exchange rate and duty scenario: what happens to margin
Shows how a higher exchange rate or duty changes cost and margin, the rate at which margin falls to the target, and how far the price must rise to keep it.
Collection FX risk: cost in a foreign currency, payment horizon, hedge
By payment stages to the factory calculates the cost of the collection in roubles at the current rate and with a hedge, the effect of a rate shift on the open part (up and down) on cost and margin, the critical rate down to the target margin and the price rise needed to keep margin in roubles.
Time standard of a garment by operation: labor cost, sewing price and a check against the factory
From a list of operations (operative time, repeats, grade) calculates the standard minutes per garment with allowances, the labor cost at the given hourly cost and norm attainment, the factory overhead and profit, the calculated sewing price and the cost of a standard minute, garments per worker per shift and the share of the longest operations; checks the calculated price against the factory quote and shows how many minutes are built into it.
Line balance: takt, sewers per operation, bottleneck and shift output
From the operation times (standard minutes per garment) calculates the takt for the target output and the sewers needed and, with a given number of sewers, allocates places to operations, finds the bottleneck, the shift output, the balance efficiency and the shortfall against the target; shows which stations idle and which hold back the flow.
Fabric use by marker: material utilization, losses and their price in roubles
From the area of pieces by size, the size ratio in the marker, the fabric width and the marker efficiency calculates the marker length and the consumption norm per garment with end losses, shrinkage and fabric defects, the overall material utilization, the cost of fabric and losses per garment and per lot, the price of one percentage point of marker efficiency and checks it against the norm declared by the factory.
Container demurrage and standing: the sum for a delay, the price per garment and the payback of speeding up
From the days at the terminal and outside it, the free days and the rate steps it counts demurrage (stepped) and detention. It shows the sum for standing, the price per garment and its share of the garment’s cost, the cost of money for the days of standing and the price of the next day. It answers whether a paid speed-up (advance filing of documents, an urgent broker) pays off and at what delay. Set the rates and the free days from the carrier’s offer; the default values are illustrative.
A materials order from the swatch and trim card: need with losses and shrinkage, packing, minimum lot, surplus and order date
From the number of garments and a table of materials (consumption per garment, losses, shrinkage, price, packing, minimum lot, lead time) it counts the need for every item, the order allowing for the roll and the minimum lot, the surplus and its cost, the cost of materials per garment and the week by which the order must be placed. It shows where the minimum lot exceeds the need and pays for a surplus. Set the prices, packing and lead times from supplier offers; the default values are illustrative.
Fabric specification: density and roll weight, meters per kilogram, width after shrinkage against the marker, purchase consumption and garments per roll
From the width, the surface density, the roll length, the shrinkage in length and in width and the consumption by the marker it counts the weight of a running meter and of a roll, meters per kilogram, the roll area, the price per kilogram and per square meter (if the fabric is sold by meters), the density in ounces per square yard, the width after shrinkage and the margin against the marker width, the purchase consumption with shrinkage and the number of garments per roll. It helps to compare a supplier’s offer by meters and by kilograms and to check that the marker still fits the width after shrinkage. The default values are illustrative.
A trial batch at a supplier: when the trial pays off, what a mistake without it costs and at what probability of defects it breaks even
From the size of the full order, the unit price, the prepayment, the size and markup of the trial batch, the trial costs, the delay, the probability of detecting a problem and a table of supplier classes (probability of failure and the loss share) it counts what the trial costs, what losses it prevents and at what probability of defects it pays off. It suits China and any other country: take the full unit cost with logistics and duty from the “Full cost of an imported garment” calculation.
Combined duty rate and import VAT
Counts the import duty for a rate of the form “% of customs value but not less than EUR per kg” (or the sum of both parts), shows which part of the rate applies, the break-even point by value, import VAT and the full cost per piece. All rates and the exchange rate are entered by you with a date: the calculation does not know HS codes.
LCL vs full container: break-even volume
Compares the cost of delivering a shipment as less-than-container load (a rate per cubic meter plus consolidation) and as a full container (the rate plus extra costs), finds the volume at which the container becomes cheaper and counts the cost per piece. Extra waiting days for a consolidated load can be included. Rates are entered in one currency.
Packing density: cartons, volumetric weight, container load
From the carton size and the pieces in it counts how many cartons and pieces fit into a container, the chargeable weight (the greater of actual and volumetric) and the freight cost per piece. Compares with vacuum packing that compresses the carton volume and shows the gain.
Parallel import economics: price vs official and a reserve for detention
A probabilistic model of a shipment imported in parallel: the expected margin taking into account the probability of detention and the loss on detention (including the cost of money over the term), the discount to the official price and the break-even probability of detention. The full cost per piece is taken, for example, from the “Combined duty rate” calculation.
Customs value and Incoterms
Shows which costs are added to the contract price in the customs value for the chosen delivery terms, including materials supplied to the factory. Then duty, import VAT, cost per piece with brand materials and sensitivity to freight. The exchange rate and the full import cost without brand materials are in “Landed cost of an imported item”.
Order size and break-even
Collection break-even and order size
Calculates how many units you must sell to recover development and launch, and shows profit at different sell-through of the run.
How much to order under uncertain demand
Compares order sizes by expected profit: ordering less than demand loses sales, ordering more leaves stock that clears at a lower price.
Unit price by run tiers and the minimum run
Compares run options with different factory prices: cost, unsold stock and profit. Shows at which run it pays to order and when a cheap price for a big run turns into frozen stock.
First order and reserve for reorders
Calculates what share of the plan to order at once and how much capacity to keep for a reorder after the first sales. Compares the expected profit, leftover and lost sales of a two-stage order with a single large order. The logic is our own: demand is given by scenarios, early sales remove part of the uncertainty, a reorder costs more and is limited by capacity.
Trade fair and pre-order: payback and batch risk
Two questions of wholesale. Whether taking part in a trade fair or showroom pays back: orders from contacts against the cost of taking part and the break-even number of orders. Whether to launch a batch on pre-orders: how many units are confirmed, whether they cover the factory minimum, how much money depends on free sales and what the result is.
Starter brand model: first batch and cash to start
Calculates the economics of a new brand from zero: net price and unit margin, break-even sales per month, the minimum first batch, the peak cash need and the result of the first batch by month. Samples, launch and fixed costs are entered separately so you can see what eats the start.
Order path: confirmation, fill rate and lost sales
By units reconciles “ordered, confirmed, delivered, accepted”: the confirmation rate (CONF), fulfillment of what was confirmed, unit fill rate overall and on time, where most is lost and what the shortfall and lateness cost. OTIF by orders alongside.
Micro-batch versus large: fixed costs, experience curve, break point
Compares the unit cost and margin of a micro-batch and a large batch of one style: fixed costs for patterns and setup are spread over the batch, labor falls along the experience curve, material is dearer in a small batch. Finds the smallest batch from which margin reaches your target.
Label launch readiness: stages, critical tasks, the blocking stage and how many tasks are missing
From a table of stages (how many tasks, how many done, how many of them are critical and how many critical are done) and a readiness threshold it counts which stages are ready, which stage blocks moving on and how many tasks are missing before it is ready. A stage is ready only when all critical tasks are done and not less than the threshold of the others. The calculation shows the order of work, not the quality of execution: “done” is marked by you.
Yield cascade across stages
Multiplies the yields of four stages (cutting, sewing, quality control, packing) into a rolled yield, counts how many pieces to launch to get the required number of good ones and the cost of losses at each stage at the accumulated cost. Compares with a variant in which part of the QC rejects can be reworked.
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.
Order entry: a check of MOQ, multiples, the delivery window and payment
Checks an order to a supplier before entry: the minimum lots by SKU, the multiple of the size run or box, the minimum order amount, whether the delivery falls into the window before the sales start and the payment schedule (prepayment and the balance). Suggests corrected quantities.
Seasonal buying: critical ratio and the optimal quantity under normal demand
Finds the buying quantity of a seasonal item that maximizes expected profit when demand is given by a mean and a spread: the critical ratio, the stock-out probability, expected leftovers and lost sales, the gain against your plan.
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.
Collection and range
Collection plan in value
From the collection grid (styles, depth, prices and cost) computes revenue, margin and leftover at a given sell-through and markdown, and checks that depth per style is not too small.
Cost of a sample and tech pack: development cost of a style
Adds up the development cost of one style by stage (tech pack, patterns, prototype, fit sample, pre-production sample), calculates the development cost per launched and per successful style and shows what cutting the number of styles in development would give. Enter stage prices from contracts and invoices.
Collection mix: core, fashion, image
For collection roles (core, fashion, image or your own) calculates the share of the buy, planned revenue and margin, turnover and the money at risk in leftovers, and compares the shares with your target ranges and the margin with your target. Thresholds are editable: there is no single norm for the mix.
The trend share in the matrix and its life window: the share ceiling, the test batch, the chase order and the “rising / falling” signal
From the number of SKUs and the budget of the matrix, the trend SKUs and their budget it counts the shares and compares them with your ceiling; from the expected trend life, the lead time to the shelf, the test weeks and the reorder lead time it counts the selling window and the chase window; from the result of the test batch (sold, %) and the fading of the rate it determines the chase order in units and money; from a series of a signal index (queries, mentions, test sales) it determines the growth rate per week and shows whether the trend rises, falls or stands. It gives the decision: chase or not. The share ceiling, the life window and the test threshold are set by your policy, the calculation has no universal values; the default values are illustrative.
Payback of the digital sample (3D): savings on physical samples, weeks and the return period
From the number of styles, the rounds of the physical sample, the price of a sample and the share of rounds that 3D replaces counts the savings on physical samples per season, the costs of the digital sample and the license, the weeks saved on the critical path and the payback of the one-off investment. Shows the threshold: at what replacement share the digital sample is cheaper than the physical one.
Collection gates (stage-gate): a funnel of hypotheses, the price of a hit, the saving against “everything into a trial” and the stop rule of the pilot batch
From the number of ideas, the cost of the stages per model and the share of models passing each gate (idea, tech pack, sample, pilot batch) it counts how many models reach a hit, how much is spent in all, what one hit costs, what part of the spend went to rejected models and how much the gates save against “all ideas go to the end”. Separately it counts the stop rule of the pilot batch: the sales threshold at the control week, the loss on stopping and the loss avoided by not scaling blindly. Take the pass shares from past seasons; here illustrative.
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.
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.
Post-season review by category
After the season shows what sold at full price, how much went on markdown, the margin that was left and how much money sits in leftovers. A basis for the next buy.
Size curve by store cluster and pack composition
Splits the buy across store clusters and sizes using each cluster’s past sales, picks the composition of a ready pack (prepack) for the cluster’s curve, rounds the buy to whole packs and shows how many pieces end up in the wrong sizes. Compares a pack per cluster with one pack for the whole chain, and picking to order with a ready pack.
SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale
Ranks SKUs by net sales, assigns class A, B or C by the cumulative share and compares it with sell-through. A bestseller is class A with a high sell-through, a slow seller is one with a low sell-through, “no-sale” is a SKU with no sales. You set the thresholds; the calculation shows the quartiles of your data as a hint.
Categories: contribution to growth and margin, this year versus last
Shows which categories raised or dropped sales and how many points of growth each gave, and splits the change in the total margin into a mix effect (category shares shifted) and a rate effect (margin within categories changed).
New and carryover: share, return per SKU, sell-through and margin
Compares groups of SKUs of a season, for example new items, carryover (carried over from past seasons) and basics: the share in the range and in sales, sales per SKU, sell-through and margin. Shows which group gives a return above its share in the range.
ABC-XYZ matrix: a SKU’s contribution to sales and demand stability
From a table of SKU sales over several periods splits them into classes A, B, C by contribution to sales and X, Y, Z by demand stability (the coefficient of variation), shows the matrix of sales shares and the number of SKUs and suggests a stock policy for each SKU.
Choosing items under the buying budget and the shelf: a greedy set and an exact scan
From a list of items (each taken whole) chooses the set with the highest expected margin under the buying budget and shelf limits: a greedy set by margin per unit of scarcity and the exact set by scan, the gap between them, the use of the budget and the shelf and the value of an extra 10% of budget.
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.
Channels: wholesale, retail, platforms
Margin by sales channel
Compares how much money is left per unit in wholesale, own retail, marketplace and website after fees, logistics, returns and advertising.
Cost to serve an online order
Gathers the costs of warehouse, delivery, returns, payment, support and marketing and shows what it costs to serve one order, what share of revenue that is and what margin remains after serving.
Franchise: brand income and partner payback
Calculates the partner store’s profit and payback and the brand’s income from the store: upfront fee, royalty and the supply markup less support. Shows whether payback fits the contract term.
Price corridor: prices by country and channel on one basis, gray flow and an exchange-rate shift
Brings the existing shelf prices in different countries and channels to one basis (excluding VAT, in roubles), counts the index to the base price, shows which markets are outside the set corridor, whether there is a gap at which resale between markets pays and what happens to the index when the local currency weakens. The difference from the “price for a country” calculation: that one builds a price from margin and commission, this one checks the consistency of prices already set.
Marketplace unit economics and break-even price
Calculates what is left per sold unit after commission, logistics, storage, advertising, returns and tax, and at what price and ad spend a sale breaks even.
Promo discount: the sales lift that makes it pay
Shows how much more you must sell for a promo discount not to reduce profit, and compares promo discount depths. Cutting the price of leftovers at season end needs a different calculation: it looks at the stock, not at the sales lift.
Stacking: total discount and order of application
Combines a shelf discount, a promo code and points or cashback into one total discount, shows the unit price and margin, the “ceiling” of the total discount at your minimum margin and the difference between orders of application.
Contribution levels CM1–CM3 by channel with buyout
For sales channels (site, platforms, partners) calculates contribution step by step: CM1 after cost of goods and commissions on what was bought, CM2 after logistics and handling of orders and returns, CM3 after marketing. Shows contribution per order and the allowable marketing per order.
Wholesale terms and credit
Wholesale terms: wholesale discount, prepayment, credit
Compares offers to buyers with different discount, prepayment and credit: how much the brand really gets once the cost of capital and the risk of non-payment are counted.
Wholesale customer: profit after terms
Calculates what the brand really earns from a wholesale customer after discounts, returns, markdown support, the cost of credit and acquisition spend, and at what minimum order the customer covers those costs.
Cost of payment terms, deductions and factoring
Compares three ways to get paid for a wholesale shipment: wait out the credit, give a discount for fast payment or sell the invoice to a factor. Shows what credit and buyer deductions cost and what price uplift they call for.
End-to-end cash gap: from the factory deposit to the buyer’s money
Calculates for how many days the brand’s cash is “frozen” from the factory deposit to the buyer’s payment, what amount is needed at the peak and what financing the gap costs.
Early-payment discount: annual rate
Turns a term such as “2% if paid within 10 days, full term 30” into an equivalent annual rate and compares it with the cost of your money. Shows the buyer’s gain and the price of the discount for the seller in money.
Customer credit limit and wholesale receivables aging
Shows for each wholesale customer how much has been shipped on credit, how much of the limit is used, how much debt is overdue and what doubtful-debt reserve to create by age group. The reserve rates are editable.
A brand inside a multi-brand retailer: share of space and sales, margin and a decision
For brands inside one retailer calculates the share of sales and the share of space, margin including markdown support, sell-through, turnover and GMROI and suggests a decision: expand, keep or cut the brand; gives a space guide by margin share.
Transfer price and producer or importer markup: range and tax
Finds the transfer price range between a producer (importer) and an affiliated seller: from below by the minimum markup on full cost, from above by the buyer’s minimum margin and by comparable deals; shows profit and tax by link at your price and at the range edges.
Agreement zone and the price of refusal: how strong your alternative is and how hard you can push
For a deal in which you pay the counterparty (buying from a factory, a platform commission in rubles per unit) calculates your price limit from the best alternative with switching costs, the counterparty’s limit from its costs and alternative load, the width of the agreement zone, your surplus share at the offered price, the price of refusal for both sides in money per year and the price worth asking to take the share of surplus you need. Shows whose alternative is stronger and where to move the negotiation.
Concession matrix: what to give first to get what you need and what it costs
From a list of concessions you can offer a partner (paying earlier, a volume commitment, a forecast, a lot size, prepayment, exclusivity) calculates the cost of each to you and the value to the partner with different cost of money, ranks them by “value to him ÷ cost to you”, builds the order of giving until the value covers what you ask and shows the net gain. Separately gives equivalents: how many days of deferral one percent of discount is worth and how many percent of discount a deferral is worth.
Brand scorecard for a buyer: weighted criteria, stop criteria and a decision by thresholds
From a table of criteria (weight, a score from 0 to 5 for each of the two brands, a minimum per criterion) it counts a total out of 100, the number of triggered stop criteria, the difference between the brands and a decision by thresholds: into the order, a trial order or decline. It shows on which criteria the brand loses most points so you know what to bargain over. The buyer sets the scores from their own data and samples: the calculation only adds up judgments and does not replace them.
Tender bid floor and reduction from the starting price
From cost and the target margin counts the lowest bid price and the permissible reduction from the starting maximum price, adds the cost of the bid and performance security and shows at which reduction the tightened requirements switch on. Percentages, terms and thresholds are entered by you with a check date.
Buyer’s retro bonus: tiers, marginal discount and the risk of buying up to a threshold
From turnover tiers and rates counts the bonus under a retroactive scheme (the tier rate on the whole turnover) or a stepped one, shows how much is missing to the next tier, the bonus increase and the marginal discount on the last roubles of turnover, and the bonus reserve from the forecast. Tiers and rates are entered by you from the contract.
Trade fair and pre-order: payback and batch risk
Two questions of wholesale. Whether taking part in a trade fair or showroom pays back: orders from contacts against the cost of taking part and the break-even number of orders. Whether to launch a batch on pre-orders: how many units are confirmed, whether they cover the factory minimum, how much money depends on free sales and what the result is.
Co-funding a promotion with a platform or partner: the brand’s share
Calculates whether a promotion pays at your share of the discount: the margin gain, the brand’s costs, the partner’s share and the maximum brand share at which the promotion still breaks even. Enter your own terms: the platform does not insert other people’s offers.
Pocket price: what the brand keeps from a delivery after all concessions
For each set of terms (a customer, a contract) deducts line by line from the list price the on-invoice discount, retro bonus, marketing development funds (MDF), listing fee, deductions and penalties and the early-payment discount, and shows the pocket price, the leakage from list and the pocket margin. Compares the terms with each other.
Cash and working capital
Cash conversion cycle and working capital
Shows how many days money lives in stock and receivables net of supplier credit, and how much capital it freezes.
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.
Covenant check: headroom to breach and EBITDA −X%
Calculates debt ÷ EBITDA, interest cover, DSCR, the current ratio and equity to assets, compares them with the contract thresholds, shows by how many percent EBITDA can fall before the first breach and which covenants break when EBITDA falls by X%.
Lease or buy: present value after tax and the break-even rate
Compares buying equipment (warehouse, workshop, shop) and leasing with a buyout by the present value of costs after corporate income tax, calculates the effective lease rate, the discount rate at which the schemes are equal and cumulative costs by month.
Loan: payment schedule, overpayment and the effective rate
Builds an annuity or declining-balance payment schedule with a principal grace period, calculates the overpayment, compares it with the other payment type and finds the effective rate with fees.
Financial condition: ratios and the Altman model
Computes liquidity, stability, interest cover, debt to EBITDA and profitability from the balance sheet and the income statement, compares them with your thresholds and shows the Altman model value with its zone (safe, gray, distress). Helps to see the weak spot before a conversation with a bank or a supplier.
Debt capacity: the largest loan for a target debt service coverage (DSCR)
From the cash flow available for debt service (CFADS: EBITDA minus taxes, the growth of working capital and maintenance capex) and a target DSCR it finds the largest annual payment, and from it the largest loan at your rate and term. It compares with the limit from the covenant “net debt ÷ EBITDA”, shows the DSCR for the loan you want to take, the repayment schedule and how much loan a mistaken reliance on EBITDA would give.
Credit line limit for the seasonal peak and its cost
From the monthly cash flow before the loan it finds the cumulative position, the peak deficit and the peak month, counts the limit as the peak plus a reserve, the interest for the period on the debt balance and the fee on the unused part. It compares with the cost of a permanent loan for the peak amount and shows what part of the limit you use on average.
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.
Early-payment discount: annual rate
Turns a term such as “2% if paid within 10 days, full term 30” into an equivalent annual rate and compares it with the cost of your money. Shows the buyer’s gain and the price of the discount for the seller in money.
Management balance sheet from the P&L and turnover figures
From the P&L, the inventory, receivable and payable days and the opening balance sheet builds the closing balance sheet: cash by the indirect method, assets, liabilities, equity; checks that it ties, shows net working capital and net debt and compares the calculated cash with the actual.
Investment in collections and projects
Investment project: NPV, IRR and payback
Appraises a project from its cash flows: opening a store, launching a collection, buying equipment. Calculates net present value, internal rate of return and payback.
Collection break-even and order size
Calculates how many units you must sell to recover development and launch, and shows profit at different sell-through of the run.
WACC: cost of capital, ROIC against WACC and economic profit
Calculates the weighted average cost of capital from the shares, the cost of equity and debt after tax, then compares it with ROIC and finds economic profit (EVA); the table shows how WACC and EVA change at another debt share.
Advertising and customer acquisition
CAC and LTV: quick acquisition check
Calculates what a new customer costs to acquire, how much profit they bring over their lifetime and how fast marketing spend pays back. A quick estimate on averages; for the exact payback use Customer cohort.
Advertising: ROAS, ad share and ROMI on margin
Compares the actual return on advertising with the allowable: shows ROAS, ad share, ROMI on margin, break-even and target ad share and ad share allowing for the purchase rate.
Customer cohort: payback period and retention
For a cohort of customers calculates cumulative margin by month, CAC payback period, LTV for the period and the LTV to CAC ratio.
Target ad-cost ratio and acquisition payback
Computes the target ad-cost ratio (DRR) from the margin before advertising, the share of fixed costs and the desired profit and compares it with the actual one. Separately estimates the CAC payback and the 12-month LTV; the traffic light works only on your thresholds.
Annual media plan: budget by channel and month, orders, revenue, margin after marketing, ad-cost share and payback
From the annual budget, channel shares and the cost of an order in each channel, month weights, the average order, returns, margin and the delay of the effect it spreads the budget by channels and months, counts orders, revenue ex-VAT after returns, margin after marketing, the ad-cost share, ROMI and the month when the cumulative margin covers the cumulative budget. All numbers follow from your assumptions: this is a teaching frame, not a forecast of advertising return.
Content and SMM: reach, engagement, the price of a contact and an order by format, content payback
From the number of posts per month, their production and promotion, reach, engagements and clicks counts for each format and for all content: engagement rate (ER), the price of a thousand reach, of an engagement, a click and a kept order, the margin of orders and the payback. Shows which format gives reach and which orders, and at what number of orders the content pays back.
Maximum bid for marketplace ads
Answers how much you can pay for a click: the contribution per click equals the share of clicks that reached an order times the redemption rate times the contribution of a redeemed order before advertising. It is the break-even bid; the allowed bid is what remains if you keep a set share of that contribution. If the platform charges per thousand impressions, it counts the bid per click from CPM and CTR and the ad cost ratio at it.
Cohort retention: curve, churn and cohort LTV
For cohorts of customers (the month of the first purchase) it builds the retention curve: what share came back in the 1st, 2nd, 3rd and 4th period after the first purchase. It compares cohorts by LTV over a common horizon and shows which cohort brought more valuable customers.
Influencer campaign: full cost with ad marking and payback
Adds the fee, the customer’s taxes and contributions, non-deductible VAT, the advertising data operator (ORD), time for approvals and gifts, then calculates orders, returns, customer acquisition cost (CAC), the ad cost ratio, payback and the maximum fee. Shows how much marking and taxes add to the campaign and compares compliance costs with the expected fine.
Order data quality
Cost of order mismatches and payback of the fix
Estimates the yearly cost of mismatches in order data (people’s time, returns, discounts) and how fast fixing the process pays back.
Starter brand model: first batch and cash to start
Calculates the economics of a new brand from zero: net price and unit margin, break-even sales per month, the minimum first batch, the peak cash need and the result of the first batch by month. Samples, launch and fixed costs are entered separately so you can see what eats the start.
Label launch readiness: stages, critical tasks, the blocking stage and how many tasks are missing
From a table of stages (how many tasks, how many done, how many of them are critical and how many critical are done) and a readiness threshold it counts which stages are ready, which stage blocks moving on and how many tasks are missing before it is ready. A stage is ready only when all critical tasks are done and not less than the threshold of the others. The calculation shows the order of work, not the quality of execution: “done” is marked by you.
Markdown and exit price
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.
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.
Clearance scenarios compared by goal
Compares several price-reduction scenarios (at most two steps in each) by three goals: the result including leftovers, sales volume and capital tied up in stock. The demand model is the same as in “Weekly markdown ladder”, so with the same data the results match. This is a Syntha Lab model, not a forecast.
Carry stock over to the next season or clear it now
Compares the expected revenue per unit of leftover stock in two options: clear now (a share at the current price, the rest as a lot) and carry over (to the next season at its price and sales share, with the risk of obsolescence and the cost of storage and capital). Shows the decision, the break-even price of the next season and the break-even obsolescence risk, and the sensitivity of the difference to the risk and the sales share. Count the storage cost from a rate in percent per year (storage and capital calculations).
Markdown grid: when and how deep
Searches the week from which to cut the price and the depth of the cut and finds the combination with the highest profit by the end of the horizon. The base sales rate decays week by week, after the cut it grows by the elasticity, sales are limited by stock, and the stock left at the end goes as a lot. Compares the best combination with “no cut” and shows which combination is needed for the stock not to exceed the target. It complements the “Discount ladder” and “Markdown scenarios”: those have three set scenarios, here the timing and depth are searched.
Liquidation channels for leftover stock
Compares how much money per unit of leftover stock each channel gives: own sale, outlet, a lot to a wholesale stock buyer, marketplace. From the channel price (a share of the full price), the share of stock that really sells, costs (commissions, returns), logistics and the term it counts the net return and its present value at the capital rate. Ranks the channels and counts the total return on the stock at your split between channels. It does not replace the price-cut scenarios in one channel (“Markdown scenarios”): here different channels are compared.
Broken size run: what to mark down and how deep
Shows how a broken run slows a style down and what to do about it. From the size curve and the stock by size it counts the demand coverage by sizes in stock, the effective rate, the weeks to sell each size, the tail sizes and the depth of the price cut needed for the tail to clear by the target term. So the price cut is targeted: for two sizes, not for the whole style. It complements “Size run” (completeness of the run) and the “Discount ladder”.
Brand-funded markdown support
Counts what share of the loss from a price cut the brand takes on so that the retailer keeps its target margin. The retailer’s loss per unit is the shelf price minus the discounted price; support is a share of that loss on the units sold. Shows the minimum share for the target margin, the support in roubles on the batch, the retailer’s and brand’s margin per unit before and after and the support ceiling beyond which the brand goes negative. It complements “Co-funded promotion” and “Real purchase price”: here is the calculation of the support share for a price cut in particular.
Cross-price elasticity: demand shift between price tiers
Shows the full effect of a change in the price of one item on the profit of two neighboring tiers, for example “good” and “better”. The volume of item A changes by its own elasticity, that of item B by the cross elasticity: a positive sign means substitutes, a negative one complements. Compares the full result with the “only A” estimate and counts the cross elasticity at which the price cut stops paying off. This is not an elasticity estimate but an effect calculation with known coefficients: they are estimated by the “Demand elasticity” and “Elasticity from points” calculations, and a new item with cannibalization is counted by “Cannibalization”.
Promotion result: incremental profit
Compares the profit of a promotion with the profit you would have had without it and subtracts cannibalization, pull-forward demand and costs. Shows the required and actual sales growth, the baseline cushion and the sensitivity to its estimate.
Discounted receipts: share, depth and the ticket with a discount versus full price
Shows what share of receipts goes with a discount, the average depth of the discount in those receipts, how discounts eat into the list price and how a discounted receipt differs from a full-price one, including at list price. Helps see which purchases the discounts rest on.
Season stages: BS, IS, AS, SO
Splits a season into four stages (before the sale, in the sale, after it, the final clearance): sales, share of the stage, discount depth, gross margin, stock at the end of the stage and cover. Shows how much the season earned at full price, how much it gave away in discounts and where the leftover remained.
Elasticity from a price and sales table: log-log regression with an interval
From a table of prices and sales over equal periods estimates the price elasticity of demand by least squares in logarithms, shows the confidence interval, the goodness of fit, the forecast of sales and gross profit at a new price and the profit-maximizing price.
Size runs, stores and range in season
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.
Does moving stock between stores pay back
Identifies donors and recipients by cover to the season end, the pieces to move, the gain per piece (with sale probabilities), the total result including fixed costs and the break-even transport cost.
Net effect of a new item: cannibalization
Compares the margin gained from a new item with the margin lost on neighboring items after launch (adjusted for the overall trend in control stores). Shows the net effect on the category and the cannibalization share.
Size demand corrected for stock-outs
Restores the true size curve: divides the sales of each size by the days it was in stock. Shows which sizes are understated in the curve by sales, how many units were lost and how to split the purchase.
Size recommendation: payback of the tool
Calculates whether an online size-recommendation tool (a widget, a measurement-based hint, a size chart) pays back: how many size returns it removes, what one return costs, the net effect per month and the payback of the launch cost. Shows the reduction in returns at which the tool breaks even.
Size curve by store cluster and pack composition
Splits the buy across store clusters and sizes using each cluster’s past sales, picks the composition of a ready pack (prepack) for the cluster’s curve, rounds the buy to whole packs and shows how many pieces end up in the wrong sizes. Compares a pack per cluster with one pack for the whole chain, and picking to order with a ready pack.
Replenishment by size: what and how much to send to stores by size
From the stock, the goods in transit and the sales of each “store × size” cell calculates the target stock in weeks of cover with a minimum display, the need rounded up to the pack multiple and distributes the limited warehouse across sizes: cells with the lowest cover first. Shows how much to send and what the warehouse lacks.
Transfers between points: surplus, need and the gain against a discount
From the stock and selling speed of each point (a store or a warehouse) finds where there is a surplus above the required cover and where a shortage, picks transfers with lot multiples and compares the cost of moving with the discount that would have to be given to clear the surplus on the spot.
Swimwear and lingerie: returns by size run, hygiene write-offs and margin per ordered unit
From the price, the cost, the channel commission, the logistics and a table of size groups (share of orders and share of returns) it counts the weighted return rate and the margin per ordered unit including returned goods that cannot be resold (the hygiene liner is removed, the item has been worn). It shows the loss caused by returns, returns in units, the return rate at which the margin falls to zero and the size groups that pull the margin down. Check the requirements for returning lingerie and swimwear and the list of items that cannot be resold after a return against the current sales rules; the share that cannot be resold and all default values are illustrative.
Stock accuracy, shrink and availability
Stock record accuracy and the cost of mismatches
From a sample count it calculates record accuracy by lines and by value, the net balance of mismatches and estimates the lost revenue from “phantom” stock: an item is on record but not on the shelf.
Stock shrink: share, threshold and cost to profit
From book and counted stock by store it calculates shrink, its share of revenue, the comparison with your threshold and what part of gross profit it eats. Shows the worst store and a breakdown by cause.
Availability and lost revenue
Calculates the share of days an item could be bought, estimates lost sales, revenue and margin by item (adjusted for substitution) and, for wholesale, the shares of order lines and pieces filled.
Defects: losses, supplier recovery and a reserve
By category counts the defect rate, the loss at cost, the proceeds from selling defective items (second grade), the supplier’s recovery, the net loss and an estimate of a reserve for the next period. Shows where defects cost most.
Footwear returns: reasons, reverse logistics, the share back on sale and the loss
Splits footwear returns by reason (size, defect, did not like), calculates reverse logistics and handling, what share went back on sale as new and at a reduced price (worn returns), how much is lost on the price reduction and write-offs and what one return costs.
Safety stock by fill rate and lead-time variability
Counts safety stock in two ways: by cycle service level (the probability of not running out) and by fill rate (what part of demand is met from the shelf), with demand and lead-time variability; shows reorder points and the money in stock.
Checking an AI forecast against a naive baseline: WAPE, bias, improvement, share of periods and the gain net of costs
From a series of actual sales and an AI forecast for the same past periods it builds a naive forecast (the value of the period t − lag: last week or the same period of the last season) and compares with it. It counts the WAPE and the bias of the AI forecast and of the naive one, the improvement against the baseline, the share of periods where the AI is more accurate, whether the improvement threshold is passed, the saved error in units and the gain in money net of the cost of the tool. It answers whether the AI forecast deserves more trust than a simple rule. The forecast must have been made before the fact and not fitted; the default data are illustrative.
Choosing a factory and quality
Factory scorecard
Compares 2–4 factories on the same criteria: a weighted score, red flags and the gap between first and second place. A red flag outranks the sum: a factory with a great price and failing quality must not win.
Comparing quotes: CMT, FOB, full package
Brings factory quotes in different “packages” (cut and make only, with materials, full package) to one basis: the item price in your warehouse with brand materials, losses, logistics, one-off costs and the cost of money. Shows the gap to the target cost.
Sampling inspection and cost of defects
Shows how likely a lot is to pass inspection under a “sample n, accept c” plan at the real defect rate, how many defective items reach the customer and what that costs; you can compare with a tighter sample.
Far and near factory: break-even premium
Calculates how much more the nearer factory may cost than the far one for the switch to still pay: savings on money in transit, on markdowns from a later decision, on freight and delay risk. The result is sensitive to the unsold share, so a range is shown.
Air or sea: does speeding up pay
Compares the air-freight surcharge with the margin it protects and the cash it frees earlier. Finds the number of delay days at which air pays.
Control chart: the defect share (p) and the means of measurements (X̄ and S) with rules and Cpk
From batches builds a control chart of the share of defects or returns (p) or a chart of the means and the spread of measurements (X̄ and S), calculates the center line and the 3σ limits, finds signals by four rules and from the mean charts calculates the capability indices Cp and Cpk against your tolerance. The limits can be recalculated without the points beyond the limits.
Should-cost vs the factory quote
Builds a “justified” sewing price from your own norms: materials with waste, trims and packing, time by time study (SAM) at the factory rate, overheads on labor and the factory profit. Compares it with the quote and shows the gap in money and percent, the profit the factory builds in at your norms and, if the factory disclosed the price breakdown, the article with the largest gap to negotiate.
Supplier concentration risk (HHI) and expected loss
From the suppliers’ shares of the buy counts the Herfindahl–Hirschman index (HHI) and the effective number of suppliers, the expected margin loss if the largest fails (probability × share × margin × share of the season without supply) and compares it with the cost of a second source: the price surcharge on the moved volume.
Cost of quality: prevention, appraisal, internal and external failure
Adds the four categories of quality cost, shows the cost of poor quality (COPQ: internal and external failure), the share of quality cost in revenue and the shares of the categories. Estimates whether extra prevention pays off at the expected reduction of defects: the annual effect, ROI and payback.
Customer-supplied material vs factory-bought
Compares two ways to supply fabric for a piece: the factory buys it itself and charges a markup, or you hand the fabric to the factory (a customer-supplied scheme) and bear logistics, the cost of paying early, insurance and possible losses above the norm. Shows the saving per piece and the break-even factory markup.
Supplier terms: total cost of buying per unit of demand
Compares 2-4 suppliers not by list price but by total cost: minimum order and excess, a discount or retro bonus, prepayment and credit (cost of money), defects and returns, shortfall, consignment. Ranks with a risk premium.
Order path: confirmation, fill rate and lost sales
By units reconciles “ordered, confirmed, delivered, accepted”: the confirmation rate (CONF), fulfillment of what was confirmed, unit fill rate overall and on time, where most is lost and what the shortfall and lateness cost. OTIF by orders alongside.
Micro-batch versus large: fixed costs, experience curve, break point
Compares the unit cost and margin of a micro-batch and a large batch of one style: fixed costs for patterns and setup are spread over the batch, labor falls along the experience curve, material is dearer in a small batch. Finds the smallest batch from which margin reaches your target.
Denim: fabric consumption with shrinkage, the garment price by stage and the cost of defects at washing
The fabric consumption at the finished size, the shrinkage in length and width, other fabric losses, the price per meter and the cost of the stages with a defect rate (cutting, sewing with trims, washing, finishing, packing) give the fabric consumption with the shrinkage allowance. From them the garment price after each stage, the contribution of defects to the price, the shelf price and the price of one point of shrinkage are counted. It shows why a garment costs more than the sum of operations: a defect at a late stage carries all the price already invested. Shrinkage and defects depend on the fabric, the washing and the factory: put in the results of a trial batch; the default values are illustrative.
A materials order from the swatch and trim card: need with losses and shrinkage, packing, minimum lot, surplus and order date
From the number of garments and a table of materials (consumption per garment, losses, shrinkage, price, packing, minimum lot, lead time) it counts the need for every item, the order allowing for the roll and the minimum lot, the surplus and its cost, the cost of materials per garment and the week by which the order must be placed. It shows where the minimum lot exceeds the need and pays for a surplus. Set the prices, packing and lead times from supplier offers; the default values are illustrative.
A trial batch at a supplier: when the trial pays off, what a mistake without it costs and at what probability of defects it breaks even
From the size of the full order, the unit price, the prepayment, the size and markup of the trial batch, the trial costs, the delay, the probability of detecting a problem and a table of supplier classes (probability of failure and the loss share) it counts what the trial costs, what losses it prevents and at what probability of defects it pays off. It suits China and any other country: take the full unit cost with logistics and duty from the “Full cost of an imported garment” calculation.
Collection calendar and materials
Collection calendar: critical path and slack
Finds the longest chain of stages from idea to warehouse, shows which stages have float and compares the path with the buffer and the date goods are needed in the warehouse. Negative slack says how many days must be squeezed.
Color and fabric MOQ
Shows how many pieces a color needs to use up the minimum fabric run, how much fabric and money is left over and what each color costs: with leftovers, with a small-run surcharge or whether to merge colors.
Material unification: SKUs per fabric
Calculates how many SKUs share one fabric, how many fabrics are used in all and which of them need less than the supplier’s minimum order (excess meters and their cost). Shows how many fabrics would be enough at your target of SKUs per fabric.
Carbon estimate per item: emissions by stage
Estimates greenhouse-gas emissions per item as the sum of “quantity × factor” over stages: materials, sewing, transport, packaging. You enter the factors yourself and name the source; the values in the example are illustrative, they are not taken from a reference.
Work in progress and Little’s law
By Little’s law (pieces in progress = daily output × cycle time) counts work in progress in pieces and in money by the degree of completion, the annual cost of capital in it and the money released if the cycle is shortened by a given number of days.
Marker: efficiency and the price of a percentage point
From the pattern area in CAD and the marker length and width, calculates marker and fabric utilization, use per piece, the cost of losses and the price of one percentage point of efficiency.
Cost of a sample and tech pack: development cost of a style
Adds up the development cost of one style by stage (tech pack, patterns, prototype, fit sample, pre-production sample), calculates the development cost per launched and per successful style and shows what cutting the number of styles in development would give. Enter stage prices from contracts and invoices.
Technical clothing: the price of materials by layer, finishing, batch tests and the permissible price of the shell fabric
From a table of layers and trims (quantity, cutting reserve, price per unit), the finishing of the fabric, the batch tests and the labor it counts the cost per garment, the price without VAT and on the shelf, the share of the shell fabric in the cost and the premium that a functional fabric gives against an ordinary one. It shows at what price of the shell fabric the margin falls to the minimum. The default values are illustrative: take the prices of fabrics, membranes and insulation from your own quotes and the test reports from the laboratory.
Knitwear: yarn consumption, knitting and dyeing waste, the garment price by stage and a gauge-change scenario
The weight of the finished garment, the yarn count and ply, the losses at knitting, cutting and dyeing, the price of yarn, dyeing and operations give the length and the weight of the yarn bought and the waste. From them the cost per garment by stage (yarn, dyeing, knitting, assembly, finishing, trims), the shelf price and the price of a kilogram of finished knitwear are counted. The scenario shows what a finer gauge or a yarn with a different count gives: the weight and the knitting price change and the cost is counted again. The default values are illustrative: take yarn and knitting prices from your own quotes and losses from a trial batch.
Payback of the digital sample (3D): savings on physical samples, weeks and the return period
From the number of styles, the rounds of the physical sample, the price of a sample and the share of rounds that 3D replaces counts the savings on physical samples per season, the costs of the digital sample and the license, the weeks saved on the critical path and the payback of the one-off investment. Shows the threshold: at what replacement share the digital sample is cheaper than the physical one.
Collection gates (stage-gate): a funnel of hypotheses, the price of a hit, the saving against “everything into a trial” and the stop rule of the pilot batch
From the number of ideas, the cost of the stages per model and the share of models passing each gate (idea, tech pack, sample, pilot batch) it counts how many models reach a hit, how much is spent in all, what one hit costs, what part of the spend went to rejected models and how much the gates save against “all ideas go to the end”. Separately it counts the stop rule of the pilot batch: the sales threshold at the control week, the loss on stopping and the loss avoided by not scaling blindly. Take the pass shares from past seasons; here illustrative.
Customs and regulation
Checklist of RF and EAEU rules for apparel
By age, garment layer and code shows which technical regulation applies, how conformity is confirmed, what the label must carry and from when the item is marked. A reference, not legal advice: check against the current edition.
Compliance and marking costs
Adds documents per style (declaration or certificate) and marking per piece, and shows cost per piece and its share of the price. You enter service prices from your own quotes.
Customs value and Incoterms
Shows which costs are added to the contract price in the customs value for the chosen delivery terms, including materials supplied to the factory. Then duty, import VAT, cost per piece with brand materials and sensitivity to freight. The exchange rate and the full import cost without brand materials are in “Landed cost of an imported item”.
EU rules for exporters: dates and preparation
EU apparel rule dates (ban on destroying unsold goods, digital passport, producer responsibility, forced labor) marked for your company size, and a checklist of data to collect early. Next to it: storing leftovers instead of destroying versus clearance.
Readiness for EU requirements: scores by block, hours and cost to close, an illustrative EPR fee per item
Splits the preparation for selling in the EU into weighted blocks: item data, traceability, chain check, a responsible person, claims, leftovers. For each block you set readiness, a stop minimum and hours of work from scratch. The calculation gives a total score, the blocks below the minimum, the hours and cost of closing the gaps and an illustrative extended-producer-responsibility fee per item. It is a planning tool for preparation, not a legal assessment: check the deadlines and duties of the EU acts against their text (see the calculation “EU rules for exporters”).
Mark or sell off leftovers without a code
Compares three ways for leftovers without a code: mark and sell, sell off at a discount before the deadline and write off the rest, or write everything off. Calculates the marking cost per unit, capacity to the deadline, expected fine, the maximum marking cost and the price below which marking does not pay. You enter the fine and prices yourself.
Light-industry marking waves: dates and leftovers
A reference for the four waves of marking clothing, footwear and textiles: basis, start, deadlines for selling and marking leftovers, what applies on 13.11.2026 and the fines. The 30.11.2026 deadline belongs to the fourth wave. Pick a wave.
Customers and loyalty
RFM segments from your customer table
Splits customers by recency, number of purchases and amount into segments, shows the share of customers and revenue in each and whom to win back first. Everything runs in the browser; the table goes nowhere.
Repeat purchases: what extra points of return are worth
Shows how much extra gross profit a year comes from raising the share of returning customers by a set number of percentage points, what one point is worth and how much can be spent on retention.
Loyalty program economics
Compares the profit from members’ extra purchases with the cost of rewards and running. Allows for part of the member gap not being created by the program, shows the reward rate at which the program breaks even and the points that remain a liability.
Customer concentration: share of the largest
From a list of customers and their revenue computes the share of the largest, the top N and all the rest, the concentration index and the effective number of customers, and what happens to revenue and contribution if part of the top-N revenue leaves.
Lapsed-customer threshold from repurchase gaps
Derives the threshold from your data and not from a round number: takes the gaps between repeat purchases and finds the period within which a set share of repeats falls (80% by default). A customer with no purchase for longer than the threshold is “sleeping”, longer than the threshold times a multiplier (2 by default) is “lost”. If you enter customers by the recency of the last purchase, shows the shares of active, sleeping and lost customers and the number of customers for a win-back campaign.
NPS confidence interval and significance
NPS is the difference between the shares of promoters and detractors, and it has a spread that depends on the sample size. The calculation gives NPS with a confidence interval and compares two periods: whether the change is significant or just survey noise. It also shows the minimum difference that can be noticed at all at your sample sizes.
Customer base: active, repeat, new and returning
Shows the health of the base over a period: how many customers came back, how many left, the share of new and repeat buyers and how the ticket and revenue per customer differ for new and returning ones. You set what “active” and “repeat” mean, so the figures are comparable only inside your company.
Cohort retention: curve, churn and cohort LTV
For cohorts of customers (the month of the first purchase) it builds the retention curve: what share came back in the 1st, 2nd, 3rd and 4th period after the first purchase. It compares cohorts by LTV over a common horizon and shows which cohort brought more valuable customers.
Customer segment migration: where the value flows
For your segments (for example from RFM), ordered from the best to the worst, it counts how many customers moved up, stayed or moved down a step over a period and what it cost in money. Shows where the base loses value and what one step down costs.
Win-back of lapsed customers: campaign payback and break-even response
Calculates whether a campaign to win back lapsed customers pays off: how many respond, how much margin is left after the discount, what part would have bought anyway and at what response the campaign breaks even. The discount and the response are your numbers.
CRM coverage: how many sales and customers you can see and reach
Shows what share of receipts and revenue is tied to a customer (card, phone), what part of the base consented to advertising messages and how much of it can actually be reached. Without this, conclusions about customers rest on a smaller part of sales.
Bonus points liability and breakage
From points issued, redeemed and expired calculates the points balance, the obligation to members at face value, the historical breakage of a closed cohort, the reserve allowing for expected breakage, the cost of the program in revenue and the addition to the reserve already created.
Survey sample size and margin of error: how many answers are needed and what can be read by segment
From the confidence level, the tolerable margin, the expected share, the size of the base, the effect of quotas and the response rate counts how many answers are needed, how many invitations to send and what it costs. For an already collected sample shows the margin of the overall estimate and of each segment: a segment several times smaller gives a wide interval.
Marketing budget and testing impact
Marketing budget from a revenue goal
Works backwards from a revenue goal: needed orders and visits, the allowable cost of a visit, the acquisition and brand budget and its share of revenue. Shows whether your cost of a visit pays back at your margin.
Channel incrementality: test against control
Compares the revenue of a group with ads on against a similar group without them. Shows incremental revenue, incremental return and profit after spend, and compares with the ad platform’s last-click report.
A/B test on proportions: sample size, duration and reading the result
In the “Plan” mode counts how many visitors each group needs and how many days the test must run to notice a given conversion lift with the required power; in the “Result” mode tests the significance of the difference, shows the confidence interval of the difference and the smallest noticeable difference.
Multiple regression: the contribution of price, discount and traffic to sales
From a table of periods estimates how sales depend on up to three factors at once (for example price, discount depth, traffic): coefficients with confidence intervals and p-values, R², a check of the factors’ interdependence (VIF), the effect of a one-standard-deviation shift of a factor and a forecast at given values with a band.
Bayesian estimate of a rate: buyout or conversion of a new style from a small sample
Combines your prior estimate of a rate (by category or past styles) with a small number of observations: shows the posterior rate, the interval, the probability of exceeding a target, the weight of the data against the prior, a comparison with the ordinary Wilson interval and the expected range of successes in the next trials.
Segment size: TAM, SAM and SOM in two ways (top-down by shares and bottom-up from the budget)
From a table of segments (how many people, what share buys the category, what share is in your price segment and reachable by your channels, how many units a year) it counts TAM (the whole category), SAM (your segment) and SOM in two ways: by a share of SAM and by the number of clients the budget brings. The calculated SOM is the smaller of the two; the calculation shows the gap between the estimates, the demand in units and checks it against the first batch. This is an order-of-magnitude estimate, not a forecast: every share is set by you.
Path attribution models: last click, first, linear, position-based and time-decay
Splits the value of orders between channels in five ways from a table of customer paths: last click, first click, linear, position-based 40/20/40 and time-decay by the age of a touch. Shows each channel’s value in each model and the gap between them: where it is large, the assessment of the channel depends on the choice of model and cannot be decided by it alone. Attribution divides credit but does not prove causality; the proof of causality is a test against a control.
Advertising adstock and half-life
Advertising works not only in the week of the show: the rest of the effect carries over to the following weeks. The calculation accumulates spend by the rule “accumulated effect = the week’s spend + carry-over share × the past accumulated effect”, gives the half-life and the full effect of a rouble, and, if there are sales, picks the carry-over share by search so that the regression of sales on the accumulated effect explains most. Use it together with the response curve of the channel.
Optimal marketing budget allocation across channels
Splits the budget between channels so that profit is highest: each channel’s response grows ever more slowly with spend (a saturation curve with two parameters from the response curve fit), and each next step of budget goes to the channel with the highest marginal return. It stops when a rouble no longer pays back: the remaining money is not spent. Shows the budget by channel, the profit, the gain over an equal split and the marginal return.
Price test: profit per visitor and significance
Compares two price levels by profit per visitor and not by the number of orders: the expensive variant almost always gets fewer orders but may earn more. Counts the conversion, profit per visitor and the significance of the difference both by conversion and by profit, and suggests the decision. The test should be run on your own site: platforms restrict A/B tests of price.
Promo code: payback with self-selection
Splits orders with a code into “would have bought anyway” and truly additional ones, calculates the code’s profit, the discount lost on “own” buyers and the threshold share of “would have bought anyway” above which the code loses money.
First-order discount: CAC and LTV
Calculates the margin of a discounted first order, repeat purchases over 90 and 180 days, the acquisition cost and the customer payback period; compares with spending the same money without a discount if you have a control group.
Target ad-cost ratio and acquisition payback
Computes the target ad-cost ratio (DRR) from the margin before advertising, the share of fixed costs and the desired profit and compares it with the actual one. Separately estimates the CAC payback and the 12-month LTV; the traffic light works only on your thresholds.
Annual media plan: budget by channel and month, orders, revenue, margin after marketing, ad-cost share and payback
From the annual budget, channel shares and the cost of an order in each channel, month weights, the average order, returns, margin and the delay of the effect it spreads the budget by channels and months, counts orders, revenue ex-VAT after returns, margin after marketing, the ad-cost share, ROMI and the month when the cumulative margin covers the cumulative budget. All numbers follow from your assumptions: this is a teaching frame, not a forecast of advertising return.
Content and SMM: reach, engagement, the price of a contact and an order by format, content payback
From the number of posts per month, their production and promotion, reach, engagements and clicks counts for each format and for all content: engagement rate (ER), the price of a thousand reach, of an engagement, a click and a kept order, the margin of orders and the payback. Shows which format gives reach and which orders, and at what number of orders the content pays back.
Owner’s cash and management dashboard
Owner dashboard: 10 indicators and a traffic light
Compares key business indicators with plan, colors the deviation as a traffic light with your tolerance and points to where to work out the cause. The set of indicators is a platform suggestion, replace it with your own.
Profit versus cash: where the difference went
Lays out the path from profit to the change in cash: depreciation, growth in stock, receivables and payables, equipment purchases, loans. Shows which line ate the cash despite a positive profit.
Overdraft, factoring or inventory loan: which is cheaper
Compares three ways to cover a cash need for a term by total cost with fees and by effective annual rate. Bank terms are individual: enter rates from your own offers.
Two-way profit sensitivity: price, volume and cost in pairs
Builds a profit table for simultaneous shifts of two factors (price and volume, price and cost, volume and cost), shows how many cells fall into a loss, the lowest and highest profit and by how much each factor must shift for profit to reach zero.
How much the owner can withdraw: reserve, tax, payout
Counts the safe payout from free cash and not from profit: cash plus the operating flow for 12 months minus debt service, capex, the tax reserve and a minimum balance in months of expenses. Checks the limit by net assets, counts the dividend tax by a progressive scale entered by you and the amount in hand. It requires a check by a tax and corporate law specialist.
Customer credit limit and wholesale receivables aging
Shows for each wholesale customer how much has been shipped on credit, how much of the limit is used, how much debt is overdue and what doubtful-debt reserve to create by age group. The reserve rates are editable.
Gross-margin bridge by cause
Splits the change in gross margin between two periods by cause: price and discounts, channel mix, reserve, cost, freight. Shows each cause in margin points and in money and what remains unexplained.
Profit bridge: full-price sales growth and flow-through
Shows what the next period’s profit is made of: full-price sales growth is multiplied by the share that reaches profit (flow-through), then cost growth is subtracted and savings added. If the actual profit is known, it computes the actual share.
Covenant check: headroom to breach and EBITDA −X%
Calculates debt ÷ EBITDA, interest cover, DSCR, the current ratio and equity to assets, compares them with the contract thresholds, shows by how many percent EBITDA can fall before the first breach and which covenants break when EBITDA falls by X%.
Zero-based budget: cost packages, priority and the effect of cut-off by level
Takes cost packages with priority, cost and effect, funds the mandatory ones and then by priority up to the limit, shows the cut-off line, the money saved and the effect of the cut packages; the table compares budget levels from 100% to 70% of the request.
Financial condition: ratios and the Altman model
Computes liquidity, stability, interest cover, debt to EBITDA and profitability from the balance sheet and the income statement, compares them with your thresholds and shows the Altman model value with its zone (safe, gray, distress). Helps to see the weak spot before a conversation with a bank or a supplier.
Overheads by product and responsibility center: three allocation keys
Splits the common pool of overheads across lines (products, categories, channels or financial responsibility centers) with three keys: by revenue, by units and by cost driver (orders, shipment lines, hours). Shows each line’s profit under each key and which lines change sign: the allocation key can make a line “loss-making” or “profitable” without a rouble of real saving.
Hiring and onboarding: the price of a hire, the ramp-up curve and the payback month of an employee
Adds up the one-off hiring costs (sourcing, interviews, equipment, vacancy losses) and the monthly curve: the new employee’s output grows, the mentor’s hours fall. Shows what the output shortfall costs, how much is invested by the deepest point, in which month the hire pays back and how much is lost if some leave in the first months.
Discount mechanics and the promotion calendar
Multi-buy: effective discount and basket
Converts “2 for 1”, “second at a discount”, “3 for 2” and a set into an effective discount per piece. Shows the basket margin before and after, how many pieces per basket are needed for the same margin and the average basket after.
Stacking: total discount and order of application
Combines a shelf discount, a promo code and points or cashback into one total discount, shows the unit price and margin, the “ceiling” of the total discount at your minimum margin and the difference between orders of application.
Frequent promotions: reference price and waiting for discounts
A simple model: the more often and the deeper the promotions, the lower the price a customer treats as normal and the more purchases move into promotions. Compares profit under the current and the proposed policy and shows what volume growth is needed to offset the lost price.
Co-funding a promotion with a platform or partner: the brand’s share
Calculates whether a promotion pays at your share of the discount: the margin gain, the brand’s costs, the partner’s share and the maximum brand share at which the promotion still breaks even. Enter your own terms: the platform does not insert other people’s offers.
Promotion calendar and discount budget
Turns a monthly promotion plan into a discount budget in money, calculates the maintained margin of the plan and the permitted depth at your target, and flags months overloaded with promotions and months below the target margin.
Promotions: planning and evaluation
Promotion result: incremental profit
Compares the profit of a promotion with the profit you would have had without it and subtracts cannibalization, pull-forward demand and costs. Shows the required and actual sales growth, the baseline cushion and the sensitivity to its estimate.
Post-promotion dip and pull-forward demand
From weeks before, during and after a promotion, estimates the baseline, the uplift, the post-promotion dip and the share of uplift eaten by the dip. Shows how many weeks it took sales to return to baseline and suggests a gap before the next promotion.
Control group: promotion effect (difference-in-differences)
Compares stores or regions in a promotion with similar ones without it, before and after. Shows the effect of the promotion in pieces and percent, a rough interval from the pre-promotion spread, a “parallel trends” check before the promotion and the result in money.
Promo code: payback with self-selection
Splits orders with a code into “would have bought anyway” and truly additional ones, calculates the code’s profit, the discount lost on “own” buyers and the threshold share of “would have bought anyway” above which the code loses money.
First-order discount: CAC and LTV
Calculates the margin of a discounted first order, repeat purchases over 90 and 180 days, the acquisition cost and the customer payback period; compares with spending the same money without a discount if you have a control group.
Promotion post-mortem: plan, actual and verdict
Matches plan and actual on six indicators, takes into account the baseline method and what was measured, and gives a “repeat, change or stop” verdict with a list of measurement errors. Do it 2–4 weeks after the promotion ends, when the dip is visible.
Promo effect without a control group: a baseline from last year
Estimates how much would have sold without the promotion when there is no control group. Takes last year’s sales in the same weeks as the promotion and multiplies by the trend growth: this year’s sales outside the promotion against last year’s for the same weeks. From the baseline it gets the promotion uplift, the promotion profit and the break-even volume, and optionally takes the post-promotion dip into account and gives a single result “promotion plus dip”. It complements “Promotion payback” (it needs a known “without the promotion”) and “Difference in differences” (a control group is needed): here is a way to get “without the promotion” from last year.
Promo item selection under a margin-loss budget
Selects which items to put into a promotion so as to free as much cash tied up in stock as possible under a given margin-loss budget. For each item it counts the stock coverage in weeks, the extra pieces from the discount by its elasticity (not above the stock), the capital freed at cost and the margin lost on the volume that would have sold anyway. The priority is the capital freed per rouble of lost margin; items are taken by priority until the budget is exhausted. It complements “Item selection for buying” and “ABC by sales”: those choose the buy and classes, here is a selection for a promotion by stock and elasticity.
Range: width, depth and price tiers
Width and depth: budget, models and pieces
Turns a buying budget into a number of models (width) and pieces per model and per size-by-color cell (depth). Shows how many models the budget can carry at a minimum depth, what stock will be left at the end of the season and how many weeks of sales sit in stock.
Price tiers: good, better, best
Calculates the average price and unit margin for a split of sales across tiers and shows the effect of shifting part of sales one tier up. Checks whether the step between tiers is noticeable to a customer.
Forecast of a new item from analogs
A new model has no history, so its sales are estimated from your past analogs, adjusted for price, store reach and seasonal level. Gives expected weekly sales, a range from the spread of the analogs and pieces over the horizon.
Product classifier check
Shows how fully the required attributes of a product table (group, category, season, size, color, fibre content) are filled, how many duplicates there are and which attributes fall below your target. Without a single classification, analytics does not add up.
Category roles: traffic driver, profit core, image
Assigns each category a role from two indices: sales density (share of sales ÷ share of area) and margin (category margin ÷ average margin). A traffic driver brings sales at a modest margin, the profit core gives both, image gives margin at a low return per meter, review lags on both. You set the index thresholds.
A brand inside a multi-brand retailer: share of space and sales, margin and a decision
For brands inside one retailer calculates the share of sales and the share of space, margin including markdown support, sell-through, turnover and GMROI and suggests a decision: expand, keep or cut the brand; gives a space guide by margin share.
Collection mix: core, fashion, image
For collection roles (core, fashion, image or your own) calculates the share of the buy, planned revenue and margin, turnover and the money at risk in leftovers, and compares the shares with your target ranges and the margin with your target. Thresholds are editable: there is no single norm for the mix.
The trend share in the matrix and its life window: the share ceiling, the test batch, the chase order and the “rising / falling” signal
From the number of SKUs and the budget of the matrix, the trend SKUs and their budget it counts the shares and compares them with your ceiling; from the expected trend life, the lead time to the shelf, the test weeks and the reorder lead time it counts the selling window and the chase window; from the result of the test batch (sold, %) and the fading of the rate it determines the chase order in units and money; from a series of a signal index (queries, mentions, test sales) it determines the growth rate per week and shows whether the trend rises, falls or stands. It gives the decision: chase or not. The share ceiling, the life window and the test threshold are set by your policy, the calculation has no universal values; the default values are illustrative.
Brand scorecard for a buyer: weighted criteria, stop criteria and a decision by thresholds
From a table of criteria (weight, a score from 0 to 5 for each of the two brands, a minimum per criterion) it counts a total out of 100, the number of triggered stop criteria, the difference between the brands and a decision by thresholds: into the order, a trial order or decline. It shows on which criteria the brand loses most points so you know what to bargain over. The buyer sets the scores from their own data and samples: the calculation only adds up judgments and does not replace them.
A niche and an item on a platform: capacity, competition, the newcomer’s expected sales, a pilot batch and the entry point
From a table of niches (demand per month, the number of sellers with sales, the share of the ten leaders, price, cost) it counts the capacity of the niche, the share of an average seller and the expected sales of a new seller, the size of the pilot batch, the profit of the pilot and the time to sell out, the entry point (how many units a month are needed for the contribution to cover the fixed costs of an item) and the decision “go, test or no”. Take demand and the number of sellers from the platform’s analytics, set the platform’s holdbacks and advertising as one share: the exact figure comes from the “Marketplace unit economics” calculation.
Store format, rent and the fate of a store
Store format: flagship, corner, pop-up, outlet
Puts store formats on one scale: monthly contribution, payback, profit over the life of the store and return per unit of money invested. A short-lived pop-up and a five-year flagship are compared by the same rule.
Rent: fixed rate or a percentage of turnover
Compares two ways of paying for a store: a fixed rent and a percentage of turnover with a guaranteed minimum. Finds the turnover at which the payments are equal and the store’s break-even turnover under each option.
Chain pilot: the effect against control stores
Checks that a new display, seller uniform or price gave an effect rather than the season: compares the change in sales in pilot stores with the change in control stores. Shows the effect in percent, an interval from the spread across stores and the profit of the pilot.
Close the store or keep it
A store that loses money on the report may still cover shared costs. The calculation compares the store’s contribution up to the end of the lease with closing it: exit costs and the margin on sales that stay in the network (the website and neighboring stores).
The ramp-up curve of a new store
From the shares of mature sales in the first months of a new store it fits the curve s(t) = 1 − (1 − s₀) × e^(−t/τ): the starting share s₀ and the speed of reaching maturity τ. It shows the month of reaching 90% of mature sales, the break-even month and the monthly forecast with the cumulative result and the payback of investment for a new point based on mature analogs.
Optimal store area with diminishing returns
Assumes sales grow more slowly than area: sales = k × area^α with α < 1, while the area costs grow in proportion. Finds the area at which profit is the highest, the sales and the sales density at it, the profit at your current area and the sensitivity of the optimum to the rate per m². Shows the profit curve.
Affordable rent: how much a store can pay for premises
From your margin, payroll, other costs and target profit calculates the rent ceiling as a percentage of revenue, in money and per meter, compares it with the lease and shows at what revenue the current rent is affordable and at what the store breaks even.
Cannibalization on a store opening: the chain’s net gain
Compares the sales of neighboring stores before and after a new store opens with an adjustment for the growth of control stores, calculates the neighbors’ loss, the cannibalization rate, the net sales gain and the new store’s contribution with and without the loss.
Lease under FSBU 25: liability, right of use and moving rent below EBITDA
Computes for a premises lease the present value of payments (the liability), the right-of-use asset, interest and depreciation by year and shows how much EBITDA grows with the same cash flow because the rent moves from operating costs into depreciation and interest. Needed by a retailer when opening a store, by a brand with retail and in a talk with a bank about covenants.
Capital, multi-brand and the planning cycle
DuPont: return on equity through three levers
Splits return on equity (ROE) into three factors: net profit margin, asset turnover and financial leverage. Compares two periods and shows which lever added or took away points of ROE.
Commission or buyout: what pays the brand and the multi-brand store
Compares two ways of supplying a multi-brand store: a buyout of the batch at the wholesale price and commission (money after the sale, the leftover is returned). Shows the brand’s and the store’s profit at different sold shares and the share at which commission becomes better.
S&OP: forecast bias, error and the balance of demand and supply
For the monthly sales and operations planning cycle: reconciles the forecast with actual (bias, WAPE, tracking signal) and the supply plan with the demand plan. Shows whether the team overstates the forecast, where the error is large and when supply does not cover demand.
Consolidation of two entities: eliminating turnover and unrealized profit
Adds up the P&L and balance sheets of two group entities and eliminates intra-group turnover, mutual balances and unrealized profit in the buyer’s stock; shows consolidated revenue, EBITDA, profit, assets and equity and checks that the consolidated balance sheet ties.
Covenant check: headroom to breach and EBITDA −X%
Calculates debt ÷ EBITDA, interest cover, DSCR, the current ratio and equity to assets, compares them with the contract thresholds, shows by how many percent EBITDA can fall before the first breach and which covenants break when EBITDA falls by X%.
WACC: cost of capital, ROIC against WACC and economic profit
Calculates the weighted average cost of capital from the shares, the cost of equity and debt after tax, then compares it with ROIC and finds economic profit (EVA); the table shows how WACC and EVA change at another debt share.
Transfer price and producer or importer markup: range and tax
Finds the transfer price range between a producer (importer) and an affiliated seller: from below by the minimum markup on full cost, from above by the buyer’s minimum margin and by comparable deals; shows profit and tax by link at your price and at the range edges.
Lease or buy: present value after tax and the break-even rate
Compares buying equipment (warehouse, workshop, shop) and leasing with a buyout by the present value of costs after corporate income tax, calculates the effective lease rate, the discount rate at which the schemes are equal and cumulative costs by month.
Loan: payment schedule, overpayment and the effective rate
Builds an annuity or declining-balance payment schedule with a principal grace period, calculates the overpayment, compares it with the other payment type and finds the effective rate with fees.
Financial condition: ratios and the Altman model
Computes liquidity, stability, interest cover, debt to EBITDA and profitability from the balance sheet and the income statement, compares them with your thresholds and shows the Altman model value with its zone (safe, gray, distress). Helps to see the weak spot before a conversation with a bank or a supplier.
Overheads by product and responsibility center: three allocation keys
Splits the common pool of overheads across lines (products, categories, channels or financial responsibility centers) with three keys: by revenue, by units and by cost driver (orders, shipment lines, hours). Shows each line’s profit under each key and which lines change sign: the allocation key can make a line “loss-making” or “profitable” without a rouble of real saving.
Lease under FSBU 25: liability, right of use and moving rent below EBITDA
Computes for a premises lease the present value of payments (the liability), the right-of-use asset, interest and depreciation by year and shows how much EBITDA grows with the same cash flow because the rent moves from operating costs into depreciation and interest. Needed by a retailer when opening a store, by a brand with retail and in a talk with a bank about covenants.
Advertising return and reading market figures
Channel response curve: where advertising stops paying back
From several pairs of “budget and channel revenue” fits a saturating curve, shows how close you are to the ceiling, how much the last unit of money brings and at which budget the marginal return equals the cost.
How to read market figures: bringing estimates to one basis
Different sources give different market sizes because they count differently: with or without VAT, by orders or by what was bought, not the whole market. The calculation brings your estimates to one basis (excl. VAT, bought-out, the whole market) and shows how much of the spread the method explains.
Luxury and premium: scarcity, drops and the client ladder
Drop and scarcity: run size, sell-out and leftover
Compares a limited release (a drop) with a regular one on expected profit. For each it calculates the optimal run size under uncertain demand, the probability of selling out and the expected leftover. Shows whether the price premium pays for the smaller volume.
Client ladder: entry item and climbing
A premium brand customer starts with an affordable item and then climbs the steps. The calculation counts revenue and margin per customer over the horizon, the payback of acquisition and how much the brand can lose on the entry item for the sake of later purchases.
Counterfeits and the gray market: lost margin, customer complaints, the cost of protection, payback and the needed reduction of losses
From an estimate of counterfeits and the volume of authentic goods outside your channels it counts how much margin a brand loses in a year, what customer complaints about fakes cost, what a protection program costs (marketplace monitoring, takedowns, an authenticity layer on the item) and whether it pays back at a given reduction of losses. The main result: what share of the losses protection must remove to pay for itself. The volumes of counterfeits and the gray market are estimated by you: this is an estimate from monitoring, not a fact.
Sustainability: resale, rental and the product passport
Brand resale: buy-back, processing and resale
Calculates the economics of one item in the secondary market: what you pay the customer, what inspection, cleaning and repair cost, what you sell it for and what is left after commission and returns. Shows the item margin, the impact on new sales and the payback of the launch.
Clothing rental: how many times an item must be rented
Calculates the economics of an item that is rented rather than sold: the contribution from one rental after cleaning and commission, wear and the cost of money tied up in the item, profit over its life and the number of rentals after which the item has paid back. Checks that the number of rentals a year fits in the calendar.
Cost of certification per unit: what a voluntary standard costs and when it pays back
From a list of voluntary certification costs (one-off payments with a validity period, annual payments, tests, team time) calculates the annual cost of the program and the cost per unit at your volume, adds the premium on the price of certified material, shows the share in price and the price premium at which certification pays back, the sensitivity to volume and how many units are needed for the program cost per unit to fall below a given bar.
Product life cycle: emissions by five stages and per wear, a comparison of variants and the number of wears for parity
Extends the emissions estimate to the life of the item: material, production and transport are taken per unit (from the calculation “Carbon estimate per item” or from the supplier), while use (washing and drying) and end of life (disposal or recycling) are counted here. For several item variants it shows emissions over the life and per wear and how many wears a more durable variant needs to match the base. Enter your own factors and name the source: the example values are illustrative and not taken from a reference.
Packaging environmental fee
Counts the extended producer responsibility fee by kind of packaging: mass in tonnes × rate per tonne × recycling target, less the share you recycle yourself. Shows the fee in money, per piece and the structure by material. Rates and targets are entered by you at the calculation date.
Warranty and repair reserve
Counts the number of warranty claims, the cost of repairs and of replacing pieces, the reserve per sold piece and as a percent of revenue and the gain from raising the share of repairable ones. Shows when repair costs more than replacement.
Carbon estimate per item: emissions by stage
Estimates greenhouse-gas emissions per item as the sum of “quantity × factor” over stages: materials, sewing, transport, packaging. You enter the factors yourself and name the source; the values in the example are illustrative, they are not taken from a reference.
CRM and the customer base: retention, segments, win-back
Customer base: active, repeat, new and returning
Shows the health of the base over a period: how many customers came back, how many left, the share of new and repeat buyers and how the ticket and revenue per customer differ for new and returning ones. You set what “active” and “repeat” mean, so the figures are comparable only inside your company.
Cohort retention: curve, churn and cohort LTV
For cohorts of customers (the month of the first purchase) it builds the retention curve: what share came back in the 1st, 2nd, 3rd and 4th period after the first purchase. It compares cohorts by LTV over a common horizon and shows which cohort brought more valuable customers.
Customer segment migration: where the value flows
For your segments (for example from RFM), ordered from the best to the worst, it counts how many customers moved up, stayed or moved down a step over a period and what it cost in money. Shows where the base loses value and what one step down costs.
Win-back of lapsed customers: campaign payback and break-even response
Calculates whether a campaign to win back lapsed customers pays off: how many respond, how much margin is left after the discount, what part would have bought anyway and at what response the campaign breaks even. The discount and the response are your numbers.
CRM coverage: how many sales and customers you can see and reach
Shows what share of receipts and revenue is tied to a customer (card, phone), what part of the base consented to advertising messages and how much of it can actually be reached. Without this, conclusions about customers rest on a smaller part of sales.
Bonus points liability and breakage
From points issued, redeemed and expired calculates the points balance, the obligation to members at face value, the historical breakage of a closed cohort, the reserve allowing for expected breakage, the cost of the program in revenue and the addition to the reserve already created.
Survey sample size and margin of error: how many answers are needed and what can be read by segment
From the confidence level, the tolerable margin, the expected share, the size of the base, the effect of quotas and the response rate counts how many answers are needed, how many invitations to send and what it costs. For an already collected sample shows the margin of the overall estimate and of each segment: a segment several times smaller gives a wide interval.
CRM message frequency: return against unsubscribes
Finds the number of messages per month at which profit per subscriber is highest: the return grows ever more slowly with frequency and runs into a ceiling, while each message costs money to send and gives a share of unsubscribes, and an unsubscribed customer loses their future margin. Shows the optimal frequency, the profit per subscriber and for the whole base at the optimum and at your current frequency, and a table by frequency.
Referral program payback
Counts whether the reward for an invited friend pays back: from all who came by the link it subtracts the fraudulent ones (self-referrals, fake), then those who would have come without a reward, and compares the margin of the rest (over the customer lifetime) with the rewards paid to all legitimate ones. Shows the profit, the return, the cost of an acquired customer and the break-even reward.
Store sales and receipts: traffic, conversion, ticket
Sales equation: traffic, conversion, units per receipt, price per unit
Splits the change in a store’s sales between two periods into four causes: how many people entered, what share bought, how many units per receipt and the price per unit. Sales = traffic × conversion × units per receipt (UPT) × price per unit (AUR). Shows what exactly pulls sales up or down.
Plan versus actual by store: pace, period forecast, required daily pace
Compares the actual to date with the plan for the whole period and with the pace-plan for the same number of days, forecasts the end of the period at the current pace and calculates how much must be sold a day to reach the plan. Shows which stores lag behind the pace and by how much.
Receipt structure: ticket bands, average ticket, UPT and contribution to sales
Splits receipts into amount bands: how many receipts and what share of sales fall into each, the average ticket, units per receipt and the price per unit. Shows which receipts the revenue rests on and where the median receipt lies.
Discounted receipts: share, depth and the ticket with a discount versus full price
Shows what share of receipts goes with a discount, the average depth of the discount in those receipts, how discounts eat into the list price and how a discounted receipt differs from a full-price one, including at list price. Helps see which purchases the discounts rest on.
Day-of-week and hour indices for schedules
Shows how many times sales on each day of the week are above or below the average day: an index of 1.2 means a fifth above the average. Built from the weeks in the table (untick holiday weeks), optionally also by hour. Needed for the schedule of promotions and mailings (days with an index above one) and as an input to the staffing calculation.
Market basket affinity: support, confidence, lift
From the number of receipts with each item and with both at once, counts for pairs of items the support (how often the pair occurs), the confidence (what share of those who bought A also took B) and the lift (how many times more often the pair occurs than with an independent choice). Ranks the pairs by lift among those with enough data and suggests what to do: a bundle, adjacent placement or nothing.
Season results: brand, category, SKU
Season result: from gross sales to contribution
Lays out the season result as a ladder: gross sales at list price, discounts, returns, net sales, cost of goods, gross margin, write-offs, selling costs. Shows how many margin points discounts ate. Fits a brand, a category and a retailer; check the names of the rungs against your own reporting.
Season stages: BS, IS, AS, SO
Splits a season into four stages (before the sale, in the sale, after it, the final clearance): sales, share of the stage, discount depth, gross margin, stock at the end of the stage and cover. Shows how much the season earned at full price, how much it gave away in discounts and where the leftover remained.
Sell-through by delivery: speed and time to sell out
Compares the deliveries (drops) of a season: what share of each delivery is sold and what share at full price, at what speed it sells and in how many weeks it will finish at the current pace. Shows which delivery has become heavy.
SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale
Ranks SKUs by net sales, assigns class A, B or C by the cumulative share and compares it with sell-through. A bestseller is class A with a high sell-through, a slow seller is one with a low sell-through, “no-sale” is a SKU with no sales. You set the thresholds; the calculation shows the quartiles of your data as a hint.
Categories: contribution to growth and margin, this year versus last
Shows which categories raised or dropped sales and how many points of growth each gave, and splits the change in the total margin into a mix effect (category shares shifted) and a rate effect (margin within categories changed).
New and carryover: share, return per SKU, sell-through and margin
Compares groups of SKUs of a season, for example new items, carryover (carried over from past seasons) and basics: the share in the range and in sales, sales per SKU, sell-through and margin. Shows which group gives a return above its share in the range.
Brand history by season: growth, discounts, margin and sell-through
Builds a history report for a brand or category: net sales, discount depth, gross margin and sell-through by season, and compares each season with the same season a year earlier and the last year with the previous one.
Season matrix: product season × sales month and stock against the window
From 12 months of sales in four groups (SS, AW, leftovers of past seasons, core) calculates the share of seasonal goods and leftovers by month and calendar season, how much of its sales each season makes inside its own window and whether the window is enough to sell the stock.
Checking an AI forecast against a naive baseline: WAPE, bias, improvement, share of periods and the gain net of costs
From a series of actual sales and an AI forecast for the same past periods it builds a naive forecast (the value of the period t − lag: last week or the same period of the last season) and compares with it. It counts the WAPE and the bias of the AI forecast and of the naive one, the improvement against the baseline, the share of periods where the AI is more accurate, whether the improvement threshold is passed, the saved error in units and the gain in money net of the cost of the tool. It answers whether the AI forecast deserves more trust than a simple rule. The forecast must have been made before the fact and not fitted; the default data are illustrative.
Working with stock: transfers, top-up, defects, prices, order entry
Transfers between points: surplus, need and the gain against a discount
From the stock and selling speed of each point (a store or a warehouse) finds where there is a surplus above the required cover and where a shortage, picks transfers with lot multiples and compares the cost of moving with the discount that would have to be given to clear the surplus on the spot.
Replenishment by size: what and how much to send to stores by size
From the stock, the goods in transit and the sales of each “store × size” cell calculates the target stock in weeks of cover with a minimum display, the need rounded up to the pack multiple and distributes the limited warehouse across sizes: cells with the lowest cover first. Shows how much to send and what the warehouse lacks.
Defects: losses, supplier recovery and a reserve
By category counts the defect rate, the loss at cost, the proceeds from selling defective items (second grade), the supplier’s recovery, the net loss and an estimate of a reserve for the next period. Shows where defects cost most.
Price monitoring by SKU: index to the market, position and price-scraping freshness
From a table of prices collected by scraping competitors calculates for each SKU the market median and minimum, your price index, your place among the competitors and the status against the corridor. Excludes stale data and SKUs with too few competitors from the total so that the index is not built on noise.
Order entry: a check of MOQ, multiples, the delivery window and payment
Checks an order to a supplier before entry: the minimum lots by SKU, the multiple of the size run or box, the minimum order amount, whether the delivery falls into the window before the sales start and the payment schedule (prepayment and the balance). Suggests corrected quantities.
Footwear returns: reasons, reverse logistics, the share back on sale and the loss
Splits footwear returns by reason (size, defect, did not like), calculates reverse logistics and handling, what share went back on sale as new and at a reduced price (worn returns), how much is lost on the price reduction and write-offs and what one return costs.
EOQ: economic order quantity with a minimum lot and volume discounts
Finds the order size at which ordering and holding costs together are lowest, tests volume price breaks, respects the minimum lot and the pack multiple, and shows annual costs and the saving against your size.
Allocating a stock among stores: by demand and limits against the proportional
Allocates the warehouse stock among stores: first the display minimum, then one pack at a time to the store with the lowest cover while the cover is below the target and there is room. Compares with allocation proportional to demand: cover, the number of stores below target and the expected lost sales over the horizon.
Platforms and the platform economy law
Platform commission increase: profit loss and price rise
Shows how much monthly profit a commission increase will take, how far to raise the price to keep the money margin or the margin share per unit, and what pays more at your elasticity: absorb it, raise the price to break-even or stop at the optimal rise. A table for 1–5 pp of growth is below. The notice of changed terms is covered in “Platform notice period”.
Platform notice period: can you adapt in time
Compares the period the platform gave you with the legal minimum under the platform economy law, shows how many days remain before the change takes effect and whether they are enough to reprice, rebuy and rework advertising. A reference to Arts. 9, 12 and 14 of Law 289-FZ.
Contract with a platform: what to check under the platform economy law
A table of points to find in a marketplace contract (Lamoda and others), showing which follow directly from Law 289-FZ and which remain commercial terms. Pick a group of questions or see everything.
Marking and trading leftovers
Light-industry marking waves: dates and leftovers
A reference for the four waves of marking clothing, footwear and textiles: basis, start, deadlines for selling and marking leftovers, what applies on 13.11.2026 and the fines. The 30.11.2026 deadline belongs to the fourth wave. Pick a wave.
The marking code chain: from factory to till
Shows the steps of a marking code for your role: what to do, what most often breaks and where costs build up. The steps follow the general code workflow; details for your group: check the rules of the marking system.
Mark or sell off leftovers without a code
Compares three ways for leftovers without a code: mark and sell, sell off at a discount before the deadline and write off the rest, or write everything off. Calculates the marking cost per unit, capacity to the deadline, expected fine, the maximum marking cost and the price below which marking does not pay. You enter the fine and prices yourself.
Advertising, influencers and ad marking (ERIR)
Influencer campaign: full cost with ad marking and payback
Adds the fee, the customer’s taxes and contributions, non-deductible VAT, the advertising data operator (ORD), time for approvals and gifts, then calculates orders, returns, customer acquisition cost (CAC), the ad cost ratio, payback and the maximum fee. Shows how much marking and taxes add to the campaign and compares compliance costs with the expected fine.
Advertising marking: what to check in a campaign
A checklist under Art. 18.1 of the Advertising Law: erid, ORD, ERIR, deadlines, liability and the specifics of influencers, targeting and public channels. Pick the ad format.
The legal minimum of a brand
Price increase: volume, margin and notice period
Plans a price rise: the new price incl. VAT, the margin gain, volume loss at your elasticity, the profit result, the tolerable volume fall and elasticity, the model’s optimal rise and a table by rise size. Checks whether the days to the date cover the contract’s notice period.
Trademark: cost of protection against revenue at risk
Compares the cost of registering and maintaining a trademark with the expected loss it removes: losing the name, rebranding and counterfeits. Calculates cost per year, the expected effect, the multiple and the probability threshold at which protection pays. You enter the fees and all probabilities yourself.
Returns and exchange: the window and refund period under consumer law
A reference to Arts. 25, 26.1, 18 and 22 of the consumer protection law: within how many days a purchase may be returned or exchanged in a store and in a distance sale, what changes without written return information and how soon the money is refunded. Pick the channel, quality and information.
Brand contracts: what to put in writing
A list of terms worth fixing in a contract with a supplier, distributor, commission agent, licensee or a cut-make-trim contract, tied to chapters of the Civil Code. A contract with a platform is covered in “Contract with a platform”.
Business form and regime at the start: sole proprietor or LLC, self-employment, automated simplified, simplified and general, and what is left to the owner
From the money from customers for the year, the costs, payroll and rates it counts for nine options (self-employed, a sole proprietor and an LLC on the simplified “income”, on “income minus costs”, on the automated simplified regime, on the general system) the tax, contributions, VAT and the tax on dividends, checks the admission against the limits (income, employees, resale for the self-employed) and shows what is left to the owner. It counts the start of a small brand or store: for the full load of a company with deductions and import VAT see the “Tax load” calculation. The rates and limits are set by fields and are illustrative: check them against the norms in force and with an accountant.
Warehouse, fulfillment and the last mile
Own warehouse or 3PL: cost per order and break-even volume
Adds up fixed and variable costs of receiving, storage, picking, packing and returns for your own warehouse and for a logistics operator (3PL), shows the cost of an order and of a unit, the volume at which each option wins and how the difference changes when volume grows or falls.
Warehouse flows: hours, staff and load by sale stage (BS, IS, AS, SO)
Calculates labor on the warehouse flows (receiving and putaway, picking and packing, returns) and shows how many people are needed in a normal month and at each stage of a sale period: before the sale (BS), in the sale (IS), after it (AS) and in the final clearance of leftovers (SO). Shows the peak, the staffing gap and the cost of an order at the peak.
Last mile by delivery type: courier, pickup point, post
Compares delivery types to the customer by the full cost to you: the carrier’s rate minus the customer’s fee, the return leg and the margin lost on refused parcels. Shows the weighted cost of an order, its share of the basket and margin, the lead time and the gain from shifting a share of orders to a cheaper type.
Split shipments: the cost of several parcels versus consolidation
Shows what it costs to ship an order in several parcels from different places (the second parcel, customer contacts) and compares it with gathering the order in one place (moving goods and the risk of losing the order while waiting).
Delivery promise and conversion: what pays for a fast promise
Compares options of a promised delivery time (tomorrow, 2–3 days, a week) by contribution to profit: orders at your conversion minus the cost of keeping the promise. Shows the best option and the conversion at which a fast option matches the slow one.
Warehouse capacity for the peak: places, area, utilization
From the average stock and the seasonal peak coefficient it counts the peak stock, the required number of pallet or bin places at the target utilization and the area with aisles, then with a growth margin. It shows the warehouse utilization in the low season and warns if the utilization at the peak is above 90% when the warehouse work slows down.
RFID payback: stock accuracy, availability, stock counts
Adds up the annual RFID effect from three sources: the margin from higher goods availability, the saved hours of stock counts and the reduced losses. Compares with the first-year costs (tags, equipment, operation), counts the payback period, the annual effect net of recurring costs and the number of tags at which the investment breaks even. Tags are bought every year for new goods, so the recurring part is shown separately.
Returns processing: cost and restocking
Counts what one return costs: receiving, inspection and packing plus the part of the price that will not come back because some items go to B-grade at a discount and some to scrap. From this it gets the loss per return and per month, the cost of the capital frozen for the time until the return to sale, and how much shortening this time saves.
Warehouse slotting by ABC: a shorter picking path
Compares the average picking path with a random layout (goods spread evenly over zones) and with an ABC layout (fast goods closer to the exit). From the share of time spent walking it gets the picking time saving, the hours and rubles per year and the payback of the re-slotting costs.
Store staff and productivity
Payroll and the full cost of a store employee
Adds salary, the variable part, social insurance contributions (with the contribution base limit and, optionally, a reduced rate), the injury contribution and other costs per employee; shows the employer’s cost of an employee, the store payroll, its share of revenue and per square meter.
Traffic-based staffing: people per shift and per month
Converts traffic by part of the day and day type into staff workload (serving visitors and working at the till), finds how many people are needed in each part of the day, and calculates shift hours a month, headcount, labor cost and revenue per labor hour.
Cost of staff turnover: what replacing a seller costs
Adds the direct and hidden costs of replacing one employee (recruiting, training, vacancy, reaching full productivity), multiplies by the number leaving in a year and shows what pay rise would pay back if it lowers turnover.
Cost of a motivation scheme: a percentage of sales or a bonus for the plan
Compares two bonus schemes for a store: a percentage of all sales and a percentage of sales above the plan. Shows the cost with contributions, the margin gain at the expected sales growth, the growth at which the scheme pays back and the loss at zero effect.
Queue M/M/c: how many tills and assistants are needed at the peak
From the number of customers per hour and the service time calculates the load, the probability of waiting (the Erlang C formula), the average wait, the queue length and the share of customers served within the target time; scans the number of tills and finds the minimum for the target and the number with the lowest cost of staff and waiting.
Store grades: payroll by level, a bonus with a payment threshold, share of revenue and the cost of a growth step
From a ladder of grades (headcount, salary, bonus share) counts the store payroll with bonus and insurance contributions at the given plan completion, the payroll share of revenue, the average cost of an employee, the cost of a growth step between neighboring grades, the bonus share of payroll and the saving when the plan is missed. Compares with the target payroll share if you set one.
Hiring and onboarding: the price of a hire, the ramp-up curve and the payback month of an employee
Adds up the one-off hiring costs (sourcing, interviews, equipment, vacancy losses) and the monthly curve: the new employee’s output grows, the mentor’s hours fall. Shows what the output shortfall costs, how much is invested by the deepest point, in which month the hire pays back and how much is lost if some leave in the first months.
Shift planning against the hourly need and the payroll budget
From the need for people for each hour and a set of shift templates (start hour, length, hourly rate) it picks the numbers of shifts per template with the minimum cost at which every hour is covered. It shows person-hours, the cost of the day, the overlap above the need, the uncovered hours, the weekly load and the full-time equivalent, and checks the shift length and the break. It requires a check by a labor-law specialist.
Full cost of the premises and display
Full cost of the premises: per square meter, per fixture and per linear meter
Collects rent (fixed and a percentage of turnover), service charges, utilities, security and cleaning and staff, spreads them over a sales square meter, a fixture and a linear meter of display and compares with revenue and margin. Shows the revenue per meter needed for the store not to lose money.
Display: productivity of a linear meter and of facings by zone
Compares store zones by revenue and margin per linear meter and per facing, shows the index (share of sales ÷ share of space), the best and worst zones and estimates whether moving meters from a weak zone to a strong one pays when returns diminish.
Store payback: ramp-up and rent holiday by month
Builds the store’s cash flow by month: revenue rises from a starting level to the plan over a given number of months, no rent is paid in the rent holiday. Shows the payback month, the cumulative result, the depth of the dip and the payback without the ramp-up.
Affordable rent: how much a store can pay for premises
From your margin, payroll, other costs and target profit calculates the rent ceiling as a percentage of revenue, in money and per meter, compares it with the lease and shows at what revenue the current rent is affordable and at what the store breaks even.
Planogram: slots, display stock, cover, turnover and the meters needed by category
For each category counts how many items fit on the display (slots), what stock stands on display, how many weeks of sales it covers, how fast it turns and how many meters are needed at the target cover. Shows the surplus and deficit of meters, how many can be moved, how often to replenish, revenue and margin per meter and the return on display stock (GMROI).
Lease under FSBU 25: liability, right of use and moving rent below EBITDA
Computes for a premises lease the present value of payments (the liability), the right-of-use asset, interest and depreciation by year and shows how much EBITDA grows with the same cash flow because the rent moves from operating costs into depreciation and interest. Needed by a retailer when opening a store, by a brand with retail and in a talk with a bank about covenants.
Usable hall area, running meters and display capacity: coverage of the need, density, sales per meter and zone rotation
From the hall area, the service zones (fitting rooms, till, stock on the floor) and the share of aisles it counts the usable selling area; from a table of fixtures (rails, racks, tables, shelves with the number, the display meters and the density) it counts the running meters and the display capacity in units and compares it with what must be shown. It gives the coverage, the surplus or the shortage, the density per square meter, the sales per square and per running meter a month and, from the zone rotation cycle, the number of zones per week, the hours of work and their cost. Set the density per running meter from your own planograms; the default values are illustrative.
Omnichannel: click and collect and ship from store
Click and collect: the economics against delivery
Compares an order collected in store with a delivered order: the cost of picking and handing over in the store, the cost of uncollected orders, the saving on delivery and the margin of add-on sales when the customer comes to the store. Shows the gain per order and per month, the staff workload and the needed share of add-on sales.
Ship from store or from the warehouse: order cost and the value of the saved stock
Compares picking and shipping an online order from a store and from the warehouse: costs, cancellations and reassignment. Adds the benefit: sales that would otherwise be lost for lack of goods at the warehouse and discounts avoided. Shows the gain per order and per month and the share of saved sales needed.
Inventory visibility: how many sales a single stock view of stores and warehouse brings back
Estimates what part of online orders lost to “out of stock” at the warehouse can be won back by showing and offering goods from stores: allowing for how often they are there, how accurate the records are and whether the customer agrees to collection or delivery from a store. Gives the sensitivity to customer acceptance.
Scenarios and plan stress test
Plan scenarios: base, optimistic, pessimistic
Compares the profit and cash of a plan in the base case and in two or three of your scenarios: price, volume, exchange rate, returns, discount depth, customers’ payment terms. You set the scenario shifts yourself in the table.
Plan sensitivity and breaking point
Moves one factor at a time (price, volume, exchange rate, returns, discount, variable and fixed costs) in both directions, ranks them by effect on profit (tornado) and finds how far each must worsen for the plan profit to reach zero.
Hypothesis register and prioritization: what to do first with limited hours and money
From a register of hypotheses (effect, confidence, cost, working hours, time to effect) calculates the expected net result of each hypothesis after cost and the return per hour, drops those whose effect comes after the horizon or does not repay the cost and builds a plan in descending return per hour while the team hours and the budget last. Shows which hypotheses made it, which did not because of capacity and what part of the effect arrives in the first 72 hours.
Exchange rate and duty scenario: what happens to margin
Shows how a higher exchange rate or duty changes cost and margin, the rate at which margin falls to the target, and how far the price must rise to keep it.
Clearance scenarios compared by goal
Compares several price-reduction scenarios (at most two steps in each) by three goals: the result including leftovers, sales volume and capital tied up in stock. The demand model is the same as in “Weekly markdown ladder”, so with the same data the results match. This is a Syntha Lab model, not a forecast.
Season Monte Carlo: the probability of meeting margin and profit
Plays the season many times with random demand and cost (with a fixed seed, the result is reproducible) and shows the probability of meeting the margin and profit targets, profit percentiles, the average tail of bad seasons, the stock-out probability and the expected leftover.
Two-way profit sensitivity: price, volume and cost in pairs
Builds a profit table for simultaneous shifts of two factors (price and volume, price and cost, volume and cost), shows how many cells fall into a loss, the lowest and highest profit and by how much each factor must shift for profit to reach zero.
The 13-week cash plan
The 13-week cash plan: balance, gap and stress
Week by week calculates the cash balance from receipts and payments, finds the first week below the minimum balance and the size of the gap, then repeats the calculation with delayed and short customer receipts.
Unified tax account calendar: the month’s payment, what to deposit and penalties
Spreads the year’s taxes and contributions into one payment by month, shows the heaviest month, how much must be deposited on the unified tax account by the due date given the balance and what the penalty on an arrear comes to at a given key rate and number of days late. Helps put tax dates into the cash plan.
A 13-week cash plan with levers: when the reserve breaks and what holds it
Spreads the brand’s cash over 13 weeks: the path without measures at a given weekly outflow, the path with the expected effect of levers (one-off receipts and weekly effects times probability, less cost) and a conservative path with a shortfall allowance. Shows the week when cash falls below the reserve in each path, the lowest balance, the strongest lever and how much is missing to the reserve if only part of the measures works.
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.
End-to-end cash gap: from the factory deposit to the buyer’s money
Calculates for how many days the brand’s cash is “frozen” from the factory deposit to the buyer’s payment, what amount is needed at the peak and what financing the gap costs.
Profit versus cash: where the difference went
Lays out the path from profit to the change in cash: depreciation, growth in stock, receivables and payables, equipment purchases, loans. Shows which line ate the cash despite a positive profit.
Tax load and regime
Total tax load: simplified on income, on income minus costs, and the general system
A full annual calculation for a company: income or corporate income tax, VAT (with a deduction or at the special rate above the threshold), employer contributions and input VAT not accepted for deduction. Shows profit after taxes for each regime and the break-even of the two simplified regimes. The sweep of cost shares and the point where the regime changes: the “Regime borders” calculation.
Regime borders: at what cost share the better regime changes
For your data sweeps the share of purchases and other costs in the money from customers and shows which regime leaves more after taxes at each share. Finds the border where the general system overtakes the best simplified-regime option.
Payroll contributions: the general tariff and the SME tariff
Calculates employer contributions for the year at the general tariff and at the reduced SME tariff, month by month with the single base limit, and shows the difference, the effective rate and the employer’s cost of an employee at several pay levels.
Sole proprietor contributions and simplified tax
Counts the fixed contributions of a sole proprietor for themselves and the contribution on income above a threshold, the tax under the simplified system on income reduced by contributions (with a limit if there are employees) or on income minus costs with the minimum tax, and the total burden in percent and money. Amounts, rates and limits are entered by you with a date.
Tax regime: simplified or general system
Compares tax under the simplified regime on income, the simplified regime on income minus expenses, and the general system (corporate income tax) for your revenue and costs, and shows the point at which the better option changes.
VAT threshold on the simplified regime: when you start paying and which rate is better
From monthly income shows the month you pass the VAT exemption threshold and compares VAT at the special 5% or 7% rate (no deduction) with the general 22% rate (input VAT deducted). Finds the point where the options are equal.
Transfer price and producer or importer markup: range and tax
Finds the transfer price range between a producer (importer) and an affiliated seller: from below by the minimum markup on full cost, from above by the buyer’s minimum margin and by comparable deals; shows profit and tax by link at your price and at the range edges.
Unified tax account calendar: the month’s payment, what to deposit and penalties
Spreads the year’s taxes and contributions into one payment by month, shows the heaviest month, how much must be deposited on the unified tax account by the due date given the balance and what the penalty on an arrear comes to at a given key rate and number of days late. Helps put tax dates into the cash plan.
Business form and regime at the start: sole proprietor or LLC, self-employment, automated simplified, simplified and general, and what is left to the owner
From the money from customers for the year, the costs, payroll and rates it counts for nine options (self-employed, a sole proprietor and an LLC on the simplified “income”, on “income minus costs”, on the automated simplified regime, on the general system) the tax, contributions, VAT and the tax on dividends, checks the admission against the limits (income, employees, resale for the self-employed) and shows what is left to the owner. It counts the start of a small brand or store: for the full load of a company with deductions and import VAT see the “Tax load” calculation. The rates and limits are set by fields and are illustrative: check them against the norms in force and with an accountant.
Business valuation and raising capital
Valuation by comparable multiples: EV/sales and EV/EBITDA
Turns revenue and EBITDA into enterprise value (EV) at your own multiples (low and high), deducts net debt and shows the equity value, the contribution of each method and the price of a stake.
Valuation by cash flows: mini DCF
Brings the free cash flows of the coming years and the terminal value to today at your rate, deducts net debt and shows the enterprise and equity values, the share of terminal value and the sensitivity to the rate and growth.
A round: stakes, price per share and dilution
From the pre-money valuation, the investment amount and the option pool finds the post-money valuation, the investor’s stake, the share price and each holder’s new stake, and the dilution.
Runway: how many months the cash lasts
From cash, revenue, margin, fixed costs and revenue growth calculates the monthly cash flow, the month the cash runs out, the lowest balance, the month of operating break-even and how much to raise to keep a reserve.
EBITDA normalization for a business valuation
Brings the reported EBITDA to a “market” one: adds one-off expenses and the owner salary above the market, subtracts one-off income and the benefit of related-party rent below the market. Counts the normalized EBITDA, the enterprise value at your multiple and the difference from a valuation on the reported EBITDA, and shows separately the result for the adjustments confirmed by documents only.
Brand valuation by the relief-from-royalty method
Values a brand as the present value of the royalty the company does not pay because it owns the brand: the revenue of the forecast years is multiplied by the royalty rate and by one minus tax, then discounted; after the forecast a terminal value is added. Shows the value of the flow, the terminal part and the total, the share of the brand in the enterprise value and the sensitivity to the discount rate. It requires a check by a valuer.
Convertible instrument: conversion price and dilution
For an investment under a convertible instrument (SAFE or a convertible loan) finds the effective valuation at conversion as the smaller of the cap and the new round valuation less the discount, the investor share at conversion, his share after the new round and the founders share before and after. It shows what worked: the cap or the discount. It requires a check by a lawyer.
Investment project: NPV, IRR and payback
Appraises a project from its cash flows: opening a store, launching a collection, buying equipment. Calculates net present value, internal rate of return and payback.
WACC: cost of capital, ROIC against WACC and economic profit
Calculates the weighted average cost of capital from the shares, the cost of equity and debt after tax, then compares it with ROIC and finds economic profit (EVA); the table shows how WACC and EVA change at another debt share.
A payment abroad, import and export to the EAEU
A payment to a foreign supplier: full cost, timing and exchange-rate risk
Compares ways to pay an invoice: the bank’s or agent’s rate against the official one, commission, a fixed fee, how many days money is in transit and how many days the rate stays unfixed. Shows the full cost of the payment, the price of time and the amount at risk if the rate moves.
Import from the EAEU or from a third country: duty, VAT and the full cost
Compares the cost of the same goods from a supplier in the EAEU and from a supplier in a third country: duty, import VAT, broker fees, delivery and the cost of money frozen in VAT. Finds the EAEU supplier price at which the two paths are equal.
Export to the EAEU: zero VAT, refund and the price of waiting
Shows how an export sale to an EAEU country differs from a sale in Russia for a VAT payer: the input VAT on the goods is not credited in the usual way but waits for the zero rate to be confirmed. Counts the amount waiting, the price of waiting and the document costs.
Export outside the EAEU: price, currency revenue, VAT refund
Converts the currency price into roubles with the bank fee, subtracts export costs, the cost of waiting for the input VAT refund and the buyer’s payment delay, and shows the margin per unit and per shipment, the break-even rate and the margin when the rate moves. The refund and repatriation terms are entered by you.
Landed cost of an imported item
Adds supplier price, exchange rate, freight, insurance, duty and fees into the full cost of a unit in your warehouse and shows how the exchange rate moves it.
Customs value and Incoterms
Shows which costs are added to the contract price in the customs value for the chosen delivery terms, including materials supplied to the factory. Then duty, import VAT, cost per piece with brand materials and sensitivity to freight. The exchange rate and the full import cost without brand materials are in “Landed cost of an imported item”.
Collection FX risk: cost in a foreign currency, payment horizon, hedge
By payment stages to the factory calculates the cost of the collection in roubles at the current rate and with a hedge, the effect of a rate shift on the open part (up and down) on cost and margin, the critical rate down to the target margin and the price rise needed to keep margin in roubles.
Price corridor: prices by country and channel on one basis, gray flow and an exchange-rate shift
Brings the existing shelf prices in different countries and channels to one basis (excluding VAT, in roubles), counts the index to the base price, shows which markets are outside the set corridor, whether there is a gap at which resale between markets pays and what happens to the index when the local currency weakens. The difference from the “price for a country” calculation: that one builds a price from margin and commission, this one checks the consistency of prices already set.
A trial batch at a supplier: when the trial pays off, what a mistake without it costs and at what probability of defects it breaks even
From the size of the full order, the unit price, the prepayment, the size and markup of the trial batch, the trial costs, the delay, the probability of detecting a problem and a table of supplier classes (probability of failure and the loss share) it counts what the trial costs, what losses it prevents and at what probability of defects it pays off. It suits China and any other country: take the full unit cost with logistics and duty from the “Full cost of an imported garment” calculation.
Site economics and the funnel
The site funnel: from visit to payment and money per visit
From visits and the shares of carts, checkouts and payments calculates orders, conversion, contribution and profit per visit, the maximum price of a visit and which stage gives the most orders for one point of improvement.
What a rise in conversion and order value gives: effect on profit and the price of the change
Compares scenarios: a rise in conversion, a rise in order value and the possible rise of returns with it. Shows the profit of each scenario against the base and by how many percent conversion or order value must rise to pay for the monthly price of the change.
Acquisition payback with returns
Counts in how many months the customer’s contribution (the first order and repeat purchases) covers the acquisition cost, once returns and variable costs are included. Shows the gap against a “naive” calculation without returns and the maximum acquisition cost for your payback term.
Abandoned cart recovery: payback of the chain
Counts the economics of one abandoned-cart reminder chain: how many carts are abandoned, how many can be reached (there is consent and a contact), how many return, how many of them would have ordered anyway, and what profit remains after the margin, redemption and the cost of the chain. Shows the payback, the cost of a recovered order and the minimum response at which the chain pays back.
Free shipping threshold
Compares profit at two free shipping thresholds by the distribution of checks and not by the average check: how many orders stop being free and how much money that saves, what share of customers from the band under the new threshold will add items to reach it (catch-up) and what margin this gives, how many orders are lost because of the new delivery fee. Runs through the thresholds at band boundaries and shows the best.
Payment fees and instalment payback
Adds the fees of payment methods into an average rate for your payment mix and shows what it costs per order and per month. Separately assesses the instalment: the fee is charged on the whole order while the check and conversion grow. Finds the growth in conversion at which the instalment pays back and compares it with the expected one. Take the rates from contracts: they change.
CAC and LTV: quick acquisition check
Calculates what a new customer costs to acquire, how much profit they bring over their lifetime and how fast marketing spend pays back. A quick estimate on averages; for the exact payback use Customer cohort.
Collection lifecycle and the critical path
Supplier OTIF and the lead-time stack
From supplier orders calculates the share on time, in full and both (OTIF), perfect orders, the worst supplier, average lead time planned and actual and by stage, and which stage used up the time buffer.
Collection calendar: critical path and slack
Finds the longest chain of stages from idea to warehouse, shows which stages have float and compares the path with the buffer and the date goods are needed in the warehouse. Negative slack says how many days must be squeezed.
Collection gates (stage-gate): a funnel of hypotheses, the price of a hit, the saving against “everything into a trial” and the stop rule of the pilot batch
From the number of ideas, the cost of the stages per model and the share of models passing each gate (idea, tech pack, sample, pilot batch) it counts how many models reach a hit, how much is spent in all, what one hit costs, what part of the spend went to rejected models and how much the gates save against “all ideas go to the end”. Separately it counts the stop rule of the pilot batch: the sales threshold at the control week, the loss on stopping and the loss avoided by not scaling blindly. Take the pass shares from past seasons; here illustrative.
The planning calendar
Season calendar counted back from the shelf date
From the days to the shelf date and the chain of stages (development, samples, order, production, transit, customs and marking, warehouse) calculates the path length, the latest start day, the slack in the normal and the worst case and the cost of lateness in season margin.
Buying plan adherence: receipts, sales and stock
Compares plan and actual of receipts and sales at cost by period, shows the adherence of buying and sales, how far the closing stock moved from plan, what that is in days of sales and which periods exceeded your tolerance.
Promotion calendar and discount budget
Turns a monthly promotion plan into a discount budget in money, calculates the maintained margin of the plan and the permitted depth at your target, and flags months overloaded with promotions and months below the target margin.
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.
Master data: SKU, SKU, barcode
SKUs, barcodes and the labor of product cards
From the number of styles, colors and sizes calculates the number of SKUs and GTIN codes, how many cards must be created in a season, how many hours and roubles it costs and what one more color across all styles adds.
The marking code chain: from factory to till
Shows the steps of a marking code for your role: what to do, what most often breaks and where costs build up. The steps follow the general code workflow; details for your group: check the rules of the marking system.
Systems landscape and data exchange
Stock sync latency: the price of stale data
From the number of orders, the share of orders on low-stock SKUs and the sync interval calculates how many orders a month sell what is already gone, what it costs and whether more frequent refresh pays back.
E-documents against paper: document time, errors and money
Compares paper and electronic exchange of transfer documents, acts and waybills: hours and roubles a month for handling, errors and delivery and the effect of faster document flow on payment.
Stock record accuracy and the cost of mismatches
From a sample count it calculates record accuracy by lines and by value, the net balance of mismatches and estimates the lost revenue from “phantom” stock: an item is on record but not on the shelf.
Data quality and data owners
Completeness and quality of product master data
From the number of SKUs, filled cards, duplicates, invalid barcodes and stale records calculates four quality dimensions, an overall score by your weights and the cost of errors as a range.
Stock roll-forward reconciliation: beginning + receipts − outflows = end
Checks the stock movement invariant: the beginning stock plus receipts, minus sales, plus returns, minus transfers and write-offs, plus adjustments must give the ending stock. Counts the gap against the actual in units, in percent of turnover and in rubles, compares it with the tolerance and hints at which line and sign to look at first.
Sales reconciliation: till, ledger, acquiring and payout
Reconciles the net sales at the till (gross minus returns and discounts) with the amount in the ledger, and the expected non-cash receipt (non-cash sales minus the acquiring fee) with the real receipts on the account. It accounts for the settlement lag, shows the gaps, compares with the tolerance and counts the effective fee that explains the difference with the bank.
Stock record accuracy and the cost of mismatches
From a sample count it calculates record accuracy by lines and by value, the net balance of mismatches and estimates the lost revenue from “phantom” stock: an item is on record but not on the shelf.
Stock sync latency: the price of stale data
From the number of orders, the share of orders on low-stock SKUs and the sync interval calculates how many orders a month sell what is already gone, what it costs and whether more frequent refresh pays back.
KPI dictionary and common definitions
Forecast accuracy by week: window, bias and forecast value added
From weekly forecast and actual for a SKU or a group calculates the WAPE error and the bias overall and in a rolling window, the tracking signal, the comparison with a naive forecast (last week’s actual) and weeks with an error above your tolerance.
Driver decomposition of change (LMDI)
Decomposes the change between two periods of a metric that equals a product of factors (revenue = traffic × conversion × units per receipt × price) into the contributions of each factor. The logarithmic mean method gives contributions that add up to the change with no remainder and does not depend on the order of factors. It shows the contribution in money and in shares of the change and ranks the factors.
S&OP: forecast bias, error and the balance of demand and supply
For the monthly sales and operations planning cycle: reconciles the forecast with actual (bias, WAPE, tracking signal) and the supply plan with the demand plan. Shows whether the team overstates the forecast, where the error is large and when supply does not cover demand.
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.
Supplier OTIF and the lead-time stack
From supplier orders calculates the share on time, in full and both (OTIF), perfect orders, the worst supplier, average lead time planned and actual and by stage, and which stage used up the time buffer.
Forecast value added by stage and the price of error in roubles: the season assortment
For groups of the assortment compares three forecasts of one season: naive (a repeat of the last season), a model (statistics or AI) and the result after manual adjustments. Counts the WAPE and bias of each stage, the value added of each step (FVA) and turns the error into roubles: over-forecast costs a markdown and holding, under-forecast costs lost margin. The definitions of WAPE, bias and FVA are given in the “Forecast accuracy by week” calculation (fcdash); here the point is the price of error and the stages.
Data model of standard reports
Data readiness for standard reports
From a list of data fields with your weights and availability shows how much of the data exists for four reports (brand history, the SKU report, carryover, season results) and which field to close first.
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.