Omnichannel: the store as a warehouse and a pickup point
Click and collect, ship from store and stock visibility.
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. - 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. - 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.
Documents for this route
- Omnichannel: OMS, ship-from-store, BOPIS and unified stock
- Fashion tech: digital product passport, RFID, AR try-on, 3D design
- Merchandise stock balance
- Excel for retail, part I: lookup by key, pivot tables and data validation
- AI in fashion and analytics: where to apply it, where not, how to check the result, which data are needed and which errors occur. A memo and a checklist
- Management balance sheet
- Business plan of a brand and a retailer: sections, assumptions, presenting to an investor and a bank
- Capital: WACC, ROIC, dividends and reinvestment