Share
Explore BrainMass

3 month and 5 month Simple Moving Average Forecast

Using metrics applicable to your company, develop a 3 month and 5 month Simple Moving Average Forecast. Use at least one year's data. Explain what you are forecasting and why it is important to your company. For example, with my company, production is seasonal so I need to know how many people to schedule for each month. I could use the data from the previous year to forecast my resources for this year.

Solution Preview

Using metrics applicable to your company develop a 3 month and 5 months Simple Moving Average Forecast. Use at least one year's data. Explain what you are forecasting and why it is important to your company. For example, with my company, production is seasonal so I need to know how many people to schedule for each month. I could use the data from the previous year to forecast my resources for this year.

American Machinery Company

3 Yr Moving Average 5 Yr Moving Average
January 310 310 Actual
February 300 300 Sales Figures
March 340 340 for the
April 340 340 last ...

Solution Summary

This solution gives you a detailed discussion on 3 month and 5 month Simple Moving Average Forecast

$2.19