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

Wholesale Shipments Drop in September

NMMA: Easing supply chain constraints should enable more manufacturers to build boats.

Dealers: What’s Your 2021 Retail Outlook?

The monthly Pulse Report asks marine retailers to weigh in on November market conditions.

2020 On Track for More Than 300,000 Boat Registrations

It’s the highest number since 2007, when there were almost 400,000 boats registered for the year.

A United Industry Voice Impacts Summer Sales

The comprehensive collective effort of the Get on Board campaign was a key factor in generating boatloads of new customers.

Boating Writer Scholarship Now Open

The BWI Active Interest Media Boating Journalist Scholarship is now accepting applications through January 15. College students are encouraged to apply for the $3,000 scholarship.

Quick Hits: November 24, 2020

Bluewater Yacht Sales expands; ICOMIA issues yacht coatings guide; and Elcome expands forecasting services.

Iris Innovations Launches Garmin OneHelm Compatible Camera and Alarm Management System

The UK-based company’s new products allow users to manage all onboard cameras and alarms via Garmin MFDs.