The language of commerce: order, stock, reports
For directors and heads of buying, sales and analytics: from terms and orders to stock, re-assortment, season results and customers.
Route steps
- 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. - 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 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. - 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. - 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. - 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. - 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. - 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. - 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. - 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. - 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. - 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.
Documents for this route
- Merchandise stock balance
- Accessories line economics: bags, jewelry, hats and belts
- Allocation and replenishment
- Cohort analysis: retention table, curve, LTV forecast and RFM as mathematics
- CRM analytics: RFM, cohorts, retention, LTV/CAC, loyalty
- Cutting and fabric consumption: the marker, material utilization, losses and a check of the factory norm
- Label launch: from an idea to the first sales — stages, documents, calculations in order and readiness criteria
- Management report pack