Demand Forecasting Techniques: Moving Average & Exponential Smoothing

Demand Forecasting Techniques: Moving Average & Exponential Smoothing
Coming up next: Using Qualitative Data for Demand Forecasting

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
Your next lesson will play in 10 seconds
  • 0:03 What Is Demand Forecasting?
  • 2:22 Moving Average Formula
  • 3:47 Exponential Smoothing
  • 5:55 Lesson Summary
Add to Add to Add to

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Log in or Sign up


Recommended Lessons and Courses for You

Lesson Transcript
Instructor: Christian George
This lesson will discuss demand forecasting with a focus on sales of established goods and services. It will introduce the quantitative techniques of moving average and exponential smoothing to help determine sales demand.

What Is Demand Forecasting?

Picture the holiday season. Kids are ready for a visit from Santa, and parents are stressed out over shopping and finances. Businesses are finalizing their operations for the calendar year and preparing to move into whatever lies ahead.

ABC Inc. manufactures telephone wire. Their accounting and operations time periods run on a calendar year, so the end of the year allows them to wrap up operations before the holiday break and plan for the beginning of a new year. It's time for managers to prepare and submit their department's operational plans to senior management so they can create an organizational operations plan for the new year.

The sales department is stressed out of their minds. Demand for telephone wire was down in 2015, and the general economic data suggests a continuing downturn in construction projects that require telephone wire. Bob, the sales manager, knows that senior management, the board of directors, and stakeholders are hoping for an optimistic sales forecast, but he feels the ice of industry recession creeping up behind him to tackle him.

Demand forecasting is the method of projecting customer demand for a good or service. This process is a continual, where managers use historical data to calculate what they expect the sales demand for a good or service to be. Bob uses information from the company's past and adds it to economic data from the marketplace to see if sales will grow or decline. Bob uses the results of demand forecasting to set goals for the sales department, while trying to keep in line with company goals. Bob will be able to evaluate the results of the sales department next year to determine how his forecast came out.

Bob can use different techniques that are both qualitative and quantitative to determine the growth or decline of sales. Examples of qualitative techniques include:

  • Educated guesses
  • Prediction market
  • Game theory
  • Delphi technique

Examples of quantitative techniques include:

  • Extrapolation
  • Data mining
  • Causal models
  • Box-Jenkins models

These examples of demand forecasting techniques are only a short list of the possibilities available to Bob as he practices demand forecasting. This lesson will focus on two additional quantitative techniques that are simple to use and provide an objective, accurate forecast.

Moving Average Formula

A moving average is a technique that calculates the overall trend in a data set. In operations management, the data set is sales volume from historical data of the company. This technique is very useful for forecasting short-term trends. It is simply the average of a select set of time periods. It's called 'moving' because as a new demand number is calculated for an upcoming time period; the oldest number in the set falls off, keeping the time period locked. Let's look at an example of how the sales manager at ABC Inc. will forecast demand using the moving average formula.

The formula is illustrated as follows:

Moving Average = (n1 + n2 + n3 + ...) / n

Where n = the number of time periods in the data set. The sum of the first time period and all additional time periods chosen is divided by the number of time periods. Bob decides to create his demand forecast based on a 5-year moving average. This means that he will use the sales volume data from the past 5 years as the data for the calculation.

To unlock this lesson you must be a Member.
Create your account

Register to view this lesson

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use

Become a member and start learning now.
Become a Member  Back
What teachers are saying about
Try it risk-free for 30 days

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it risk-free for 30 days!
Create an account