From the product card to ready reports
How many SKUs and cards, what quality they have and whether the data is enough for standard reports.
Route steps
- 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. - 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. - 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. - 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. - 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. - 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. - 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. - 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. - 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. - 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.
Documents for this route
- Assortment matrix and assortment plan
- Systems and data: 1C and ERP, PIM and MDM, BI, integrations (e-document exchange, marking, marketplace API), cost of ownership and data quality
- Fashion business IT architecture
- Label launch: from an idea to the first sales — stages, documents, calculations in order and readiness criteria
- Customers’ personal data: Federal Law 152-FZ for a brand and a retailer. Grounds and consents, storage, localization, loyalty, mailings, liability
- Price list and costing (landed cost)
- Management report pack
- S&OP: cycle and documents