Forecast from Your Own Sales
Build the forecast separately for each SKU using your own completed sales history. Choose comparable periods: for example, the same months last year, or recent months when the product had similar pricing, promotion and availability. Do not fill gaps with a market average. If a cushion sold 24 units across 12 days when it was in stock, its observed rate was 2 units per available day; a 30-day comparable period would indicate 60 units before adjusting for differences in timing or promotion.
Treat stockouts and returns as separate adjustments. A zero-sales day when the SKU was unavailable is not a zero-demand day. Record available days and estimate demand from selling days, while flagging estimates created from limited availability. Keep ordered units, delivered units and returned units distinct: returned or cancelled orders should not inflate realized revenue, but returned stock may become available again only after inspection and processing.
Backtest the method against earlier completed months: make the forecast using only information available then, compare it with what actually happened, and publish the error. ORVX forecasts a coming period’s revenue from a store’s own completed months by arithmetic and reports that backtested error; it does not claim that taking a particular replenishment action will produce a result.
Set Reorder Points with Lead Time and Safety Stock
A reorder point is the inventory level that triggers a purchase review: expected demand during supplier lead time plus safety stock. Expected lead-time demand is your average daily unit demand multiplied by the full time from placing an order to having sellable stock available. Safety stock is the buffer for demand running above that expectation or supply arriving late.
For illustration only, if a lamp sells 4 units per day, the end-to-end lead time is 20 days, and safety stock is 30 units, the reorder point is (4 × 20) + 30 = 110 units. Count supplier processing, pickup, linehaul, customs clearance, final delivery and receiving or inspection, not just the supplier’s stated transit time.
Location and route change the assumption. A domestic supplier may avoid border clearance; an overseas shipment may involve port or airport handling and customs before Canadian delivery. Recheck lead times by supplier and route, then test the arithmetic in the free reorder point calculator.
Worked example with sample numbers
This example is illustrative. It uses sample numbers for a home decor store selling in Canada. They are made up to show the method, they are not a benchmark, and your own figures will differ.
Formula: Reorder point = daily units x (lead time + safety days).
| Input | Value |
|---|---|
| Units sold per day | 12 |
| Supplier lead time in days | 30 |
| Safety cover in days | 6 |
| Reorder at | 12 x (30 + 6) = 432 units |
| Cash tied up at cost | C$24282.68 |
Run the same sum with your own numbers in the free calculator, or browse guides for sellers in Canada and more home decor guides.
General information only: tax, duty and import rules change and depend on your situation, so check with an accountant or the official source before acting.
Eligible Shopify stores can see these numbers for their own store through the Founding 10,000 offer.
How to Read the Worked Example
Read the worked calculation from left to right, keeping each figure tied to its purpose. Demand is the expected unit usage for the planning period. Lead time then converts that demand into the quantity likely to sell while a supplier order is in transit. Safety stock is a separate buffer for demand or delivery uncertainty; it is not additional forecasted demand.
The reorder point combines lead-time demand and safety stock. It answers, “At what inventory position should I review or place an order?” Compare it with available stock plus confirmed incoming units, rather than with on-hand stock alone. When that position reaches the reorder point, the calculation signals a review; it does not decide that a purchase must be made.
Order quantity answers a different question: how many units to buy after deciding to replenish. Read it against supplier minimums, pack sizes, storage limits and available cash. The inventory reorder calculator can help check the arithmetic, but the store still decides whether the calculated quantity fits its purchasing rules.
Measure the Cash Cost of Holding Stock
Inventory value describes what the stock is worth in your records, usually units on hand multiplied by the recorded unit cost. It is useful for viewing the total balance by SKU or collection, but it does not show the cash required to acquire each item.
Landed cost is the per-unit acquisition cost after supplier price and applicable inbound costs such as freight, duty and brokerage. Use it when comparing SKUs with different sourcing economics. Cash tied up is the amount committed to stock: for on-hand units, units multiplied by landed unit cost. Include open purchase commitments separately so incoming stock is not confused with inventory already received.
For illustration only, 40 lamps at a $32 landed cost tie up $1,280. Add a sell-through status based on your chosen review window, then investigate slow or unsold stock before committing more cash. ORVX reports remaining stock value and dead stock from your store’s numbers.
| SKU | Units on hand | Landed unit cost | Committed cash | Sell-through status |
|---|---|---|---|---|
| Lamp A | 40 | $32 | $1,280 | Fast |
| Vase B | 25 | $18 | $450 | Slow |
| Rug C | 10 | $95 | $950 | No recent sales |
Plan for Seasonal Peaks Across Canada
Seasonality should come from your store’s own history, not a general assumption about Canadian home decor demand. Compare completed sales for the same SKU across comparable periods and mark the months when demand repeatedly rises or falls. Check units sold, not only revenue, so a price change does not look like a demand spike. Treat one unusual promotion, stockout or late shipment as an exception to investigate rather than automatic evidence of a seasonal pattern.
Once you identify a likely peak, work backward from the date you need stock available. Add supplier production and processing time, transit time, customs or receiving time where applicable, and a buffer for uncertainty. A supplier’s quoted lead time is not the same as the date inventory is ready to sell. Destination, freight method and order cutoffs can change the usable timeline. The inventory reorder calculator can help check the arithmetic.
Keep two quantities visible: build stock for the seasonal peak and regular replenishment for normal sales. The build quantity covers the expected temporary lift and should have a planned drawdown date; regular replenishment continues at the normal reorder trigger. This separation helps prevent peak inventory from being mistaken for everyday demand or repeatedly reordered after the season ends.
Choose the Measure That Triggers Action
Each measure answers a different action question. Forecast demand estimates the units likely to sell in the coming period, so use it when deciding how much stock the season may require. Reorder point signals when to review a purchase based on lead-time demand and the planned buffer. Safety stock is the reserve itself: when it is being consumed, investigate the cause and supplier timing before treating every unit as a reorder. Inventory value shows how much cash is tied up in stock, making it useful when working-capital exposure is the concern. Available cash sets the spending limit; it cannot tell you whether demand justifies the purchase.
Review them in sequence rather than ranking them. Compare forecast demand with on-hand and incoming units, check whether the SKU has reached its reorder point, then inspect whether safety stock remains. Next, look at inventory value and your cash plan. A lamp can need replenishment while cash is constrained, or cash can be available while slow-moving stock already ties up funds. The inventory reorder calculator can support the unit-level review; your cash records complete the decision. ORVX can also report remaining stock value and dead stock, helping separate a genuine supply gap from money already committed to products that are not moving.
A workable Canadian inventory plan connects the forecast to local lead times, uses safety stock for uncertainty and makes the cash consequence visible. Reorder points help decide when to buy; inventory value and landed cost show what that decision commits. Review each measure at the SKU level and update the inputs when sales patterns, suppliers or freight routes change.
Sources
- GST/HST provincial rates table (Canada Revenue Agency, checked 26 October 2026).
How this page was made: drafted with AI from a brief, then checked by automated rules for arithmetic, sources and duplication. The sample numbers were calculated, not reported.