Purchase Solution

Five-period and Ten-period Moving Average Forecasts

Not what you're looking for?

Ask Custom Question

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.