Five-period and Ten-period Moving Average Forecasts
Not what you're looking for?
See the attached file.
Can anyone solve the problem below, and plz see the attached xls:
Forecasting for 5 Thermostat Demands
(a) Develop a five-period moving average forecast to predict sales for periods 6 through
66 and calculate the MAD.
(b) Develop a ten-period moving average forecast to predict sales for periods 11 through
66 and calculate the MAD. Which forecast is more accurate for period 66? Are the forecasting methods used appropriate for the data? Why or why not? Which forecast is smoother? When a trend or pattern is emerging, would you use a small or large n? Why?
Purchase this Solution
Solution Summary
The solution computes for a five-period and ten-year moving average and a ten-year forecasts. The mean absolute deviation was computed to identify the best forecasting method. The detailed computation was done in the attached spreadsheet file.
Solution Preview
For the 5-period and 10-period moving average forecasts, please see the attached spreadsheet file.
Which forecast is more accurate for period 66?
Having smallest computed mean absolute deviation (MAD) of 44, the 10-point ...
Purchase this Solution
Free BrainMass Quizzes
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
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.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.