Purchase Solution

Problems Regarding Demand Management and Forecasting

Not what you're looking for?

Ask Custom Question

Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period.
Month Actual

January 110
February 130
March 150
April 170
May 160
June 180
July 140
August 130
September 140

a) Forecast April through September using a three-month moving average
b) Use simple exponential smoothing with an alpha of .3 to estimate April through September
c) Use MAD to decide which method produced the better forecast over the six-month period.

Purchase this Solution

Solution Summary

This solution helps with problems regarding demand management and forecasting. It forecasts a three-month moving average, uses simple exponential smoothing, and uses MAD to decide which method produced best forecast. The solution is provided in an Excel file.

Solution Preview

Year Consumption Three-Year Moving Total Three-Year Moving Average Error Exponnetial ...

Purchase this Solution


Free BrainMass Quizzes
Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.