Inventory is both asset and liability. Forecasting errors can lead to understocking critical items or overstocking dead inventory that drains capital. This blog walks through a cautionary tale from a glass distributor whose poor forecasting resulted in major fulfillment issues.
The Incident: Stockout of Standard Tempered Units During Peak Season
A glass distributor serving the residential market in the US ran out of standard 3/8” tempered glass sheets—used in more than half of their cut-to-size orders—during peak homebuilding season.
The forecast model had underestimated demand by 27%, relying on historical averages instead of adjusting for regional construction booms and new marketing campaigns launched by channel partners.
What Went Wrong
The forecasting model didn’t factor in real-time construction permit data
Seasonal buying patterns were treated as static year over year
No buffer stock had been allocated for promotional order spikes
Impact
Over 120 orders delayed, with several cancellations
$95,000 in lost revenue and expedited shipping costs
Several long-time fabricators moved orders to competing suppliers
What Changed
Forecasting Model Augmented With External Indicators
The model now pulls data from building permits, lead funnel conversions, and channel marketing activities.
Dynamic Safety Stock Logic Implemented
Inventory thresholds now adjust based on upcoming campaigns, regional project counts, and historical error margins.
Proactive Communication System Installed
When forecast gaps are detected, clients with standing orders are notified of lead time risks in advance.
Final Thought
Forecasting isn’t just a spreadsheet exercise—it’s a real-time decision engine. In glass distribution, accuracy is measured not by projections, but by how well you deliver when demand surges.
