Quick answer
To forecast inventory for Metro, use point-of-sale sell-through and store-level velocity as your demand signal, then time replenishment to Metro's reorder cadence and your production lead time. Connecting Metro data to a live model turns sell-through into a cash-aware plan.
What Metro data brings to inventory forecasting
Metro is a major Canadian grocery and pharmacy retailer concentrated in Quebec and Ontario, reporting POS sell-through per store.
Forecasting for Metro centers on regional Canadian velocity, with replenishment timed to resets and cross-border production lead times factored into cash.
| Metro data | What it drives in the forecast |
|---|---|
| POS sell-through by store | Baseline demand velocity |
| Active store / door count | Total demand scale |
| Retailer POs / EDI | Replenishment orders |
| DC / on-shelf inventory | Channel coverage |
Sell-in versus sell-through
The number that matters is not what the retailer ordered (sell-in) but what shoppers actually buy (sell-through). Forecast weekly velocity per store, multiply by active doors, and plan replenishment to the retailer's reorder cadence and your production lead time.
Formula: Weeks of supply at retail = units on shelf and in the retailer's DCs / average weekly sell-through (units per store per week x active stores). Replenishment timing works back from the retailer's reorder cadence and your production lead time.
Weak sell-through means markdowns, deductions, and no reorder; strong sell-through you cannot fulfill risks the relationship. Forecast to sell-through and hold safety stock for replenishment.
From Metro data to a cash-aware forecast
Retail sell-through is only actionable when it connects to what you must produce and the cash it consumes. Drivepoint pulls Metro data through its Metro integration into a live, Excel-native model, turning store-level velocity into forward weeks of supply, replenishment timing, and the cash each production run requires.
For a wholesale brand, that connection answers the real question before you commit a purchase order: can we afford it? It is the same discipline that turned an Oats Overnight timing decision into a $4M EBITDA gain. For the underlying method, see our guide to retail demand planning software.