Cutting inventory variance at a multi-depot builders' merchant in Toronto (2026)

The verdict in three sentences

A builders' merchant with 4 depots and 12,000 SKUs running a 6% inventory variance loses hundreds of thousands of dollars a year in missing goods, stockouts and dead stock. Custom stock software at USD 38,000 to 87,000 (EUR 35,000 to 80,000), built on barcode scanning, traceable inter-depot transfers and automatic replenishment, brings variance below 1.5%. The first visible effect is dead stock down 18% in year one, freeing cash from the second quarter.

Where the 6% variance comes from

In a multi-depot merchant, variance rarely comes from theft. It comes from counter sales keyed on the wrong SKU, depot transfers done by truck without a system record, job-site returns never put back into stock and mishandled units (pallet, bundle, linear foot, each).

On USD 3.8M of valued stock, a 6% variance means USD 228,000 of uncertain value. Brought down to 1.5%, it falls to USD 57,000.

Budget and features by tier

Off-the-shelf lumber and building supply ERPs cover invoicing, but their stock modules are often designed around a single yard. Custom development plugs into the existing ERP and handles field logistics.

Automatic replenishment computes a reorder point per SKU and per depot from the last 12 months of sales and supplier lead time. It first proposes a transfer from an overstocked depot before placing a purchase order, which attacks dead stock directly.

The rollout plan across four depots

Start with the smallest depot to validate screens with warehouse staff, then roll out one depot every 3 weeks. Run a full opening count in each depot at cutover, then switch to cycle counting: 300 SKUs per week covers all 12,000 SKUs twice a year, with more frequent counts on the 1,500 A-class items. Train counter staff first, since that is where a quarter of the variance is created.

Mini case study

Ryan, operations director of a builders' merchant with four depots across the Greater Toronto Area (Etobicoke, Scarborough, Mississauga, Vaughan), manages USD 3.8M of stock and 12,000 SKUs with a 6% variance. He invests USD 74,000 in the advanced tier, USD 16,300 in terminals and USD 8,700 in labeling, or USD 99,000. After one year, variance drops to 1.8%, or USD 160,000 of value made reliable. Dead stock, valued at USD 650,000, falls by 18%, freeing USD 117,000 of cash. At a 5% annual carrying cost, that is USD 5,850 of recurring savings, and avoided stockouts on A-class items bring roughly USD 43,000 of margin. The project pays back in under 14 months.

FAQ

Do we need to replace our ERP?

No in most cases. The stock software connects to the ERP through an API or file exchange, and the ERP keeps invoicing and accounting.

How many scanners do 4 depots need?

Plan 4 to 6 terminals per depot depending on floor area and docks, so 16 to 24 in total, at USD 650 to 1,000 each.

How do you label bulk products like sand or aggregates?

You label the location rather than the product. Staff scan the storage bay and enter the quantity in tonnes or cubic yards.

How quickly does inventory variance fall?

First effects appear 2 to 3 months after cutover. Variance below 2% is achievable in 9 to 12 months with regular cycle counts.

Does the software work in outdoor yards without coverage?

Yes, in offline mode: scans are stored on the device and synced as soon as Wi-Fi or LTE returns, usually in under a minute.

Let's scope your project. Kolonell builds your multi-depot stock software connected to your ERP, with an indicative budget of USD 38,000 to 87,000 and a first depot live in 10 to 12 weeks. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.