Demand Planning for Canadian SMBs: A Practical Starting Point That Does Not Require New Software
This article walks Canadian SMBs through building a simple, spreadsheet-based demand planning model using real lead times, safety stock calculations, and reorder points.
This article walks Canadian SMBs through building a simple, spreadsheet-based demand planning model using real lead times, safety stock calculations, and reorder points. It grounds the topic in current Canadian trade conditions including cross-border logistics complexity, currency exposure, and seasonal shipping variability. Logisrch is positioned as the partner that bridges the gap between a solid demand model and reliable freight execution.
It grounds the topic in current Canadian trade conditions including cross-border logistics complexity, currency exposure, and seasonal shipping variability. Logisrch is positioned as the partner that bridges the gap between a solid demand model and reliable freight execution.
BLOG
Introduction:
Here is how most Canadian importers manage inventory: gut feel, last year's numbers, and a standing order that gets adjusted when something runs short. It works. Until it does not.
A clothing importer in Mississauga ran out of their best-selling winter jacket line in early November last year. They had ordered what they ordered the previous season, adjusted up by 10 percent, same as always. Their manufacturer in Vietnam quoted a 6-week lead time on the reorder. February delivery. The season was gone.
Demand planning is not about predicting the future. It is about building a process that fails less often, and recovers faster when it does.
Why Most SMB Demand Problems Start with the Wrong Lead Time
Here is the honest version of an ocean freight timeline for someone importing into Canada from Asia.
Transit from Shanghai to Vancouver runs 18 to 22 days. Add 5 to 7 days for booking and loading. Customs clearance at the Canadian port takes 2 to 4 days on a clean shipment. Final delivery into Ontario: another 3 to 5 days. You are looking at 28 to 38 days, and that is the smooth version.
Add a vessel substitution, a CBSA examination, or short-shipped cargo and you are at 45 to 50 days without a lot of warning. If your spreadsheet assumes 30 days, you have a shortage built into your next order before you have placed it.
The first real step in demand planning is replacing your estimated lead time with your actual one. Pull your last 8 to 10 shipments, calculate the real door-to-door time, average it, and add a buffer based on how variable those lead times actually are. That single adjustment changes the shape of your entire inventory picture.
Building a Demand Planning Model for Canadian SMBs
You do not need an ERP. You do not need a planning platform. A spreadsheet with four inputs gets you further than most small businesses in Canada are right now.
Historical sales by month: Pull 18 to 24 months of sales data by SKU or product group. Look for seasonal patterns. A food importer in Toronto might see a Q4 spike, a January dip, and a March recovery. That pattern tells you when to order, not just how much.
Actual lead time by supplier: Track from order placement to arrival at your facility, using your last 6 to 10 shipments per supplier. The gap between quoted transit time and real door-to-door delivery is often 7 to 10 days. That gap is your planning risk.
Safety stock: Your buffer above average demand. A working formula: (maximum daily sales multiplied by maximum lead time) minus (average daily sales multiplied by average lead time). If the number is close to zero, your exposure is high.
Reorder point: The stock level that triggers your next order. Formula: (average daily sales multiplied by average lead time) plus your safety stock. When you hit this number, place the order.
A buyer at a consumer goods company outside Hamilton set this up in a single afternoon after two back-to-back stockouts of their top SKU. They have not stocked out since.
Where Canadian Importers Run Into Trouble
Standard demand models are built for predictable costs and stable lead times. Importing to Canada from Asia or the US does not work that way right now.
Exchange rate exposure is part of the picture. If your supplier invoices in USD and you sell in CAD, every movement in the exchange rate changes your landed cost. A product that cost CAD $4.20 per unit when the dollar sat at 0.75 costs CAD $4.55 at 0.69. Across a 2,000-unit reorder, that is an extra $700 you did not budget for, and it compounds if you are doing this monthly. Businesses importing in USD should monitor exchange rate trends published by the Bank of Canada .
Lead times are also seasonal. Capacity out of Asia tightens before Chinese New Year. Container availability through Vancouver gets strained in the fall. Cross-border trucking from the US slows around the holiday period.Importers should also stay informed about customs requirements through the Canada Border Services Agency (CBSA) . Build those patterns into your planning, not as fixed dates, but as a 7 to 10 day buffer adjustment in the months you know are difficult.
Demand itself is less stable than it was a few years ago. A foodservice importer in Toronto saw their restaurant client orders drop 30 percent in Q1 2025 after US tariff announcements created spending hesitation across their customer base. Their supply chain was built for steady volumes. When orders recovered in Q2, they were sitting short on product they could not get in fast enough.
The Part That Actually Requires Outside Help
You can build the demand model yourself. The spreadsheet work is manageable.
What is harder is the execution side. Finding a freight forwarder in the GTA who will accommodate a partial shipment when you need to pull a reorder forward by two weeks. Working with a customs broker who knows your HS codes and has a CBSA relationship that keeps clearances moving. Knowing which routing options out of Asia give you flexibility when your lead time buffer disappears.
Demand planning tells you what you need and when. Freight forwarding in Canada gets it there. The two have to work together, and for a lot of importing businesses in Toronto and across the GTA, there is a gap between them.
The businesses that came through supply chain disruptions in 2025 without catastrophic shortages were not the ones with the best planning software. Most were on spreadsheets. They had their lead times right, and they had logistics partners they could actually call.
Where to Start
Pull your last 18 months of sales data. Then calculate your actual average lead time from your last 8 shipments per supplier, using real door-to-door numbers rather than the carrier's quoted transit time. Set a reorder point for your top 5 SKUs. That covers 80 percent of your inventory exposure with about half a day of work.
Review it every quarter. Update the lead time number when something in your supply chain changes. Build the habit before you build the system.
Cross-border logistics in Canada will keep throwing surprises. The businesses that absorb them are not the ones that predicted every disruption. They are the ones that planned around realistic numbers and had logistics partners executing against them.
Logisrch works with Canadian SMBs, GTA importers, and cross-border freight operators to match and connect businesses with the right freight and logistics service providers for their specific supply chain situation. If your demand model is solid but your freight execution is still creating uncertainty, contact us at info@logisrch.com. That is the problem we help solve.
FAQ
Quick Answers to Common Questions
Demand planning is the process of estimating future product demand so businesses can maintain the right inventory levels, avoid stockouts, and reduce excess inventory costs.
Yes. Many Canadian SMBs can build an effective demand planning process using spreadsheets, historical sales data, supplier lead times, safety stock calculations, and reorder points before investing in advanced planning software.
Lead times determine how long it takes for inventory to arrive after an order is placed. Inaccurate lead time assumptions can lead to stock shortages, excess inventory, and disrupted customer service.
Canadian importers often face variable lead times, exchange rate fluctuations, seasonal shipping constraints, customs clearance delays, and changing market demand, all of which can impact forecast accuracy.
Freight forwarders help businesses execute inventory plans by coordinating transportation, managing shipment schedules, and providing routing flexibility when supply chain disruptions occur.