Problems Regarding Demand Management and Forecasting
Not what you're looking for?
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.