Intelligent Enterprise

Better Insight for Business Decisions

RSS
Webcasts
Whitepapers
Subscribe
Home

June 13, 2002

Gazing at the Crystal Ball

Disregarding demand forecasting technologies during tough economic times can be a costly mistake

By Ram Reddy

It's no secret that the IT sector has felt the brunt of the economic downturn. Caught up in the general disillusionment with IT has been demand forecasting (DF) technologies. Many companies blame DF technologies for supply chain problems such as excess inventory. Pinning the blame on and discontinuing DF technologies is the equivalent of throwing out the baby with the bathwater. The DF misunderstanding stems from the fact that, despite sophisticated mathematical models and underlying technologies, the output from these systems is, at best, an educated guess about the future.

A forecast from these systems is only as good as the assumptions and data used to build the forecast. Even the best forecast fails when an unexpected event — such as a recession — clobbers the underlying assumptions. However, this doesn't imply that DF technologies aren't delivering the goods. But unfortunately, many DF and supply chain technology implementations have recently fallen victim to this mindset. DF is part science and part art (or intuition) — having the potential to significantly impact a company's bottom line. In this column, you'll find an overview of how DF is supposed to work and contrast that with how most companies actually practice it. I'll conclude with suggestions on how to avoid common mistakes implementing and using this particular class of technologies.

The Need for DF Systems

DF is crucial to minimizing working capital and associated expenses and extracting maximum value from a company's capital investments in property, plant, and equipment (PPE). It takes a manufacturing company a lot of lead time to assemble and stage the raw materials and components to manufacture a given number of products per day. The manufacturing company, in turn, generates its sales forecast numbers using data from a variety of sources such as distribution channels, factory outlets, value-added resellers, historical sales data, and general macroeconomic data. Manufacturing companies can't operate without a demand forecast because they won't know the quantities of finished goods to produce. The manufacturing company wants to make sure all or much of its finished product moves off the store shelves or dealer lots as quickly as possible. Unsold products represent millions of dollars tied up in inventory.

The flip side of this equation is the millions of dollars invested in PPE to manufacture the finished products. The company and its supporting supply chain must utilize as close to 100 percent of its PPE investments. Some manufacturing plants make products in lots of 100 or 1,000. Generally, it's cost prohibitive to have production runs of one unit. So how do you extract maximum value from your investments and avoid having money tied up in unsold inventory?

DF and supply chain management (SCM) technologies try to solve this problem by generating a production plan to meet forecasted demand and extract maximum value from PPE, while reducing the amount of capital tied up in inventory. Usually, the demand forecast is pretty close to the actual outcomes, but there are times when demand forecasts don't match the outcomes. In addition to unforeseen economic events, a new product introduction may be a stellar success or an abysmal failure. In the case of a phenomenal success, the manufacturing plant may not be able to meet demand for its product.

Consider the case of the Chrysler PT Cruiser. It succeeded way beyond the demand forecast's projections. Should it have started with manufacturing capacity to fulfill the runaway demand? Absolutely not. Given the additional millions of dollars of investment in PPE necessary to add that capacity, it would've backfired if the PT Cruiser had been a flop. The value provided by DF and supporting SCM technologies in this instance was the ability to add capacity to meet the amended forecast based on actual events. Demand forecasts can and do frequently miss their targets. The point to underscore here is that the underlying DF and supporting SCM technologies are critical to a company's ability to react and respond in a coordinated manner when market conditions change.

The manufacturing company and its supply chain are able to benefit from sharing information about the changed market conditions and responding to them in a coordinated manner. Despite best practices embedded in DF and SCM technologies to support this manner of collaboration, it plays out differently in the real world.

How It Works in Real Life — Worst Practices

A company prepares its forecast by taking into account data about past sales, feedback from distribution channels, qualitative assessments from field sales managers, and macroeconomic data. DF and SCM technologies take these inputs and add existing capacities within the company and across the supply chain to generate a production plan for optimum financial performance.