Forecasting Monthly Sales on a Month by Month Basis

Solution Preview

Dear Student:

Please open the attached Excel file and continue to read the following additional remarks.

There are several forecasting methods. It depends on the situation, which would be the best method to use, as each case is different, and often doing forecasts using several methods would be advisable. The best forecasting method could be verified using MAD (mean absolute deviation), but to calculate this we would need the forecasted sales from years 1 to 6, which are not given in the assignment, as in this case the data given in the assignment includes only actual monthly sales numbers. To increase the accuracy of our forecast, we would want to use a more ...