KPI dictionary
Each measure in one definition: formula, unit, aggregation rule, source system, owning role and frequency.
Stock turnover
Cost of goods sold for the period ÷ average stock at cost for the same period; the annual value comes only from an explicit scale to a year (× 365 ÷ days in the period)
Days of inventory
A historical measure: average stock at cost for the period ÷ (sales at cost for the same period ÷ days in the period). It looks back; for a forward view use “Weeks of supply”
Weeks of supply
A forward-looking measure: current available units ÷ forecast weekly sales (if there is no forecast, average sales of the last 4–8 weeks). It looks ahead on today’s stock; the historical measure on average stock is “Days of inventory”
Average stock
Average of stock at the end of several months (or weeks) at cost
GMROI: gross margin return on inventory
Gross profit for the period ÷ average stock at cost for the same period; periods of different length are compared only after an explicit scale to a year
Excess stock
Actual stock − (sales ÷ days × target days of inventory), at cost
Sell-through
Net units sold ÷ the approved available-quantity base for the same slice (by default the “received” basis; see the separate measure from opening stock)
Full-price share
Revenue excl. VAT at full price ÷ total revenue excl. VAT
In-stock rate
Days the item was available ÷ days it was meant to sell
Fill rate
Units shipped ÷ units ordered, with no time condition (the same by lines or orders if agreed so); “on time” is counted separately, OTIF is counted by orders
On time and in full (OTIF)
Orders delivered on time and in full ÷ all orders in the period; the level (order by default), the delivery window and the quantity tolerance are fixed in advance
Inventory record accuracy (IRA)
Items whose book and physical counts match ÷ items counted
Shrink
(Book stock − physical stock) at cost ÷ revenue excl. VAT for the period. The single Lab basis is revenue; against cost of sales it is for reference only
Sell-through from opening stock
Cumulative units sold ÷ (opening stock + reorders). A different basis from the basic sell-through: do not compare the figures
Lost sales from stock-outs
Expected demand on out-of-stock days × price excl. VAT
Broken size-run share
Style-store pairs missing several sizes in a row ÷ all pairs with stock
Return rate
Units returned ÷ units sold for the same sales slice
Gross margin
(Revenue excl. VAT − cost of goods sold) ÷ revenue excl. VAT
CM1: contribution after cost of goods and commissions
Revenue after buyout − cost of goods − commissions and payment − write-off of non-purchased goods
CM2: contribution after logistics and returns
CM1 − logistics and handling of orders − returns − storage and packing
CM3: contribution after marketing
CM2 − marketing and acquisition (fixed costs are not included)
Markup
(Price excl. VAT − cost) ÷ cost; margin = markup ÷ (1 + markup)
Initial margin (IMU)
(Selling price excl. VAT − cost) ÷ selling price excl. VAT, before markdowns. This is margin (on price), not markup (on cost); the Lab calculations call the field “initial margin”
Maintained margin (MMU)
(Actual revenue excl. VAT − cost) ÷ actual revenue excl. VAT, after markdowns
Effective discount
1 − actual price excl. VAT ÷ price before discounts; weighted by pre-discount revenue
Average unit retail (AUR)
Revenue excl. VAT ÷ units sold
Revenue excl. VAT
Sum of receipts net of returns, excl. VAT
Store traffic
Number of entries from counters over the period
Store conversion
Receipts ÷ visitors for the same period and store
Average transaction value
Revenue excl. VAT ÷ number of receipts
Units per transaction (UPT)
Units sold ÷ number of receipts
Revenue per m²
Monthly revenue excl. VAT ÷ sales area, m²
Comparable sales (LFL)
Revenue of stores open in both periods ÷ their revenue in the prior period − 1
Payroll share of revenue
Store payroll with contributions ÷ revenue excl. VAT
Revenue per labor hour
Revenue excl. VAT ÷ worked hours of floor staff
Full-time equivalents (FTE)
Worked hours ÷ standard hours per full-time position in the period
GMROF: gross margin per m²
Annual gross margin ÷ sales area, m²
Rent share of revenue
Rent with service charges ÷ revenue excl. VAT
Store contribution
Revenue excl. VAT − cost of goods − direct store costs
CAC: customer acquisition cost
Acquisition spend in the period ÷ new customers in the same period
LTV: customer lifetime value
Customer margin over lifetime = revenue per customer × margin × number of periods (by cohort)
ROMI
(Margin from ad orders − ad spend) ÷ ad spend
ROAS
Revenue from ad orders ÷ ad spend. The unit is always a ratio ×: 7.5× means 7.5 roubles of revenue per 1 rouble of ads; percentages in Lab are for ROMI only
DRR: ad cost ratio
Ad spend ÷ revenue (purchased orders, excl. VAT)
Net ROAS and Contribution ROAS
Net ROAS = revenue × buyout ÷ ad spend; Contribution ROAS = (revenue × buyout − variable costs) ÷ ad spend. A ratio ×; 1.0 for Contribution ROAS means break-even
CTR
Clicks ÷ impressions
CPC: cost per click
Ad spend ÷ clicks
CPO: cost per order
Ad spend ÷ orders from ads
Customer retention
Customers who bought at both the start and the end of the period ÷ customers at the start
Repeat customer share
Customers with two or more purchases in the period ÷ all customers who bought
Customer churn
Customers who did not buy within the dormancy window ÷ customers at the start of the window
NPS
Promoters share − detractors share, in points (recompute from answer counts)
Receipts with an identified customer
Receipts carrying a customer or card number ÷ all receipts
Customer database completeness
Customers with a verified phone or email ÷ all customers in the database
Purchase rate
Units kept ÷ units ordered
Platform take rate
All platform deductions (commission, logistics, storage) ÷ selling price excl. VAT
Platform GMV
Value of purchased goods through the platform, incl. VAT, after cancellations and returns
Open-to-buy (OTB)
Planned sales + planned markdowns + ending stock − opening stock − already on order, at retail; at cost: × (1 − initial margin)
Cost of goods sold (COGS)
Cost of units sold in the period (stock on hand excluded)
EBITDA
Operating profit + depreciation
Operating costs
Rent + payroll + marketing + other costs below gross profit
Operating cash flow
Cash from customers − payments to suppliers, staff, taxes and rent
Cash conversion cycle
DIO + DSO − DPO
DIO: days of inventory
Average stock ÷ cost of goods sold × 365 (for a year; for another period the number of days in it replaces 365)
DSO: days of receivables
Average receivables ÷ revenue × 365; receivables and revenue on one basis (both excl. VAT or both incl. VAT: in the “Cash conversion cycle” calculation revenue is taken incl. VAT if receivables include VAT)
DPO: days of payables
Average payables ÷ cost of goods sold × 365 (for a year; for another period the number of days in it replaces 365)
Working capital (trade)
Stock + receivables − payables, as in the “Cash conversion cycle”. In the management balance sheet and covenants the definition is wider: see “Net working capital (balance sheet)”
Net working capital (balance sheet)
Receivables + stock net of the reserve + supplier advances − payables − owed to staff − loyalty liabilities; the definition of the “Management balance sheet”, the same is used by covenants
Minimum cash balance
Lowest balance on accounts over the weeks of the 13-week plan
Overdue receivables share
Overdue customer invoices ÷ total receivables
NPV
Σ period cash flow ÷ (1 + rate)^period, including the investment
IRR
The rate at which the project’s NPV equals zero
ROIC
Operating profit after tax ÷ invested capital
Break-even point in units
Fixed costs ÷ contribution per unit (price − variable cost per unit), in units of the batch; the “Break-even point” calculation counts in units
Break-even revenue
Fixed costs ÷ contribution margin share of revenue, in RUB of revenue; counted in the “Store economics” calculation
Actual vs plan variance
(Actual − plan) ÷ plan for the same slice and period
Forecast error (WAPE)
Σ |actual − forecast| ÷ Σ actual over the slice
Forecast bias
Σ (forecast − actual) ÷ Σ actual over the slice: plus means over-forecast, minus under-forecast; the sign is the same everywhere
Mean absolute percentage error (MAPE)
Mean over periods of |actual − forecast| ÷ actual; periods with zero actual are excluded, so for rare sizes and accessories with zeros the measure misleads: use WAPE
Tracking signal
Σ (forecast − actual) ÷ mean absolute error over the same periods; a drift shows when the modulus stays above 4 for long
Coefficient of variation of demand (CV)
Sample standard deviation (divisor n − 1) of sales by period ÷ mean, in percent; Lab limits for XYZ: X up to 30%, Y up to 60%, then Z
Safety stock
z × √((lead time + review period) × demand spread² + mean demand² × lead-time spread²); z comes from the cycle service level or from the fill rate solution
Cycle service level
The probability that demand does not exceed stock over the order cycle: Φ(z); it is not the fill rate
Economic order quantity (EOQ)
√(2 × annual demand × cost per order ÷ (holding rate × price)); the minimum lot, the pack multiple and price breaks shift the recommended size
Critical ratio of the buy
Cu ÷ (Cu + Co): margin on a unit not sold ÷ (it plus the loss on a leftover unit); the buying quantity is the demand quantile at that level
Test p-value
The probability of seeing such a gap or a larger one if there is no effect: 2 × (1 − Φ(|z|)); shown as “<0.05%” when below the display limit; judge the effect size by the interval
MIRR: modified internal rate of return
(Future value of positive flows at the reinvestment rate ÷ present value of negative flows at the finance rate)^(1 ÷ n) − 1
DSCR: debt service coverage
Bank: (EBITDA − tax) ÷ (interest + principal repaid); cautious: also minus the increase in working capital and CAPEX in the numerator. Always state the definition
ICR: interest coverage
EBITDA ÷ interest payable for the period
Landed cost per unit
(Factory price + freight + insurance + duty + fees + delivery to the warehouse) ÷ units. Import VAT is shown separately and is not in the cost (a payer reclaims it); with no right to reclaim it is added to the cost
Allowable cost
Shelf price ÷ (1 + VAT) × (1 − retailer margin) × (1 − brand margin)
Defects in sales
Defective units (returned for a defect and found) ÷ units sold in the period
Defect rate at inspection
Defective units ÷ units inspected at receiving (defects in sales are counted on units sold: the “Defects in sales” measure)
Factory capacity load
Order minutes at standard times ÷ available factory minutes per month
Lead time
Days from order placement to warehouse receipt; watch both the median and the worst quartile
Share of orders with mismatches
Orders with a quantity, price or terms mismatch between buying, warehouse and finance ÷ all orders
Sell-through at cost
Cost of goods sold for the slice ÷ delivered at cost over the whole time of the season goods; the denominator is not filtered by the season calendar
Order cancellation rate
1 − delivered ÷ ordered; the gaps “ordered → confirmed” and “confirmed → delivered” are named separately
Markup coefficient
Price excl. VAT ÷ cost; markup percent = (coefficient − 1) × 100
Plan growth over the forecast
Net revenue of the plan ÷ net revenue of the forecast − 1
Cost of quality to revenue
(Prevention + appraisal + internal failure + external failure) ÷ revenue for the period
Supplier concentration index (HHI)
The sum of squared supplier shares of the buy by value; effective number of suppliers = 1 ÷ HHI
Half delivery date
The date when the cumulative delivery at purchase prices reached 50% of the confirmed; shown in days from the first delivery
Stock roll-forward gap
|Actual − expected end| ÷ (beginning + receipts); expected end = beginning + receipts − sales + returns − transfers − write-offs + adjustments at one date
Warehouse place utilization
Stored stock in units ÷ (places × units per place); the design one is counted on the peak stock, the current one on the average
Inventory carrying cost rate
Capital + storage + insurance and shrink + obsolescence + handling, % of the stock cost per year
Normalized rate of sale
The average over clean weeks: weekly sales ÷ in-stock days × 7; weeks with a promotion and low availability are excluded
Store productivity index
Store sales per m² ÷ network sales per m² (mature stores)