How Accurate are Your Demand Forecasts?

Author:
Updated:
Original:

You forecast future demand of products and services. Your business model is based on these forecasts. But have you ever stopped to determine the accuracy of your demand forecasts? In a recent study we conducted for the National Association of Wholesale Distributors we found that the average forecast error (i.e., the difference between the forecast and actual sales or usage) was more than 300%! In order to make the most of your people, machinery, inventory and other resources, calculate your forecast error for every stocked product by using the equation:

[Absolute Value of (Forecast – Sales or Usage)] ÷ the Lower of Sales or Usage

For example if there is a forecast of 100 pieces and corresponding actual sales equal 50 pieces the resulting forecast error is 100% [Absolute Value of 100 - 50) ÷ 50]. 

Acceptable forecast errors will vary from company to company and even from product to product. But you should always be concerned with forecast errors that exceed 100%. Pay particular attention to the forecast error for products that are sold or used on a regular basis. If the forecast error is too high, you are forced to overstock in order to maintain your desired level of product availability.

Jon Schreibfeder
Effective Inventory Management, Inc.

Related

Webasto Produces 8,000th Marine Roof

The German company designs and builds a number of glass roof solutions for boats.

A Strong Q2 for Johnson Outdoors

With jumps in nearly all its business segments, the recreation manufacturer saw net sales increase by 26 percent.

Thrust Issues

Is it time for the industry to standardize trolling motor ratings?

Viking Holds Vaccination Event

The New Jersey-based builder is working with local healthcare providers to offer Covid-19 shots to employees and their families.

Bellingham to Supply Dock for Superyacht Marina

Bellingham Marine will design and install a floating concrete dock system at Hurricane Hole Superyacht Marina in the Bahamas.

Off the Charts

Even as builders faced order backlogs and product shortages, registrations continued to soar in March.

Maverick Boat Group Expands

The Florida-based builder plans to increase production capacity by 30 percent and add 150 new jobs.