Working with stock in a chain
Transfers, top-up by size, defects and a price comparison with the market.
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. - 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. - 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. - 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. - 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.
Documents for this route
- Allocation and replenishment
- Label launch: from an idea to the first sales — stages, documents, calculations in order and readiness criteria
- Color and materials: lab dips, metamerism, hand feel, lab tests, acceptance
- Accounting for defects, mis-sorts and stock losses: acts, liable parties, corporate income tax
- Stock turnover and dead stock
- The factory under a magnifier: price by article, single-supplier risk, cost of quality, yield and money in the workshop
- ABC-XYZ and Pareto: calculation, thresholds, link to safety stock and the range
- AQL and batch quality inspection