Question & Answer: A manager has been using a certain technique to forecast the demand for gallons…..

1) A manager has been using a certain technique to forecast the demand for gallons of ice cream for the past six periods. Demand and forecast amounts are shown below-in the table below. The manager is now contemplating the use of the Naive method of forecasting. Would the Naïve method forecast produce better results? For full credit show all steps and calculations. (5 points) Period Demand Forecast 87 2 4 6 90 85 91 92 95 87 89 90 92

A manager has been using a certain technique to forecast the demand for gallons of ice cream for the past six periods. Demand and forecast amounts are shown below the table below. The manager is now contemplating the use of the Naive method of forecasting. Would the Naive method forecast produce better results? For full credit show all steps and calculations.

Expert Answer

Answer

For comparing the accuracy level of the forecasting method, apply Mean Absolute deviation measure. MAD is given as average of all the absolute deviation of the forecasted periods.

Period Demand (A) Actual Forecast (F) Absolute deviation

AD = |A – F|

1 90 87 3
2 85 88 3
3 91 87 4
4 92 89 3
5 95 90 5
6 88 92 4
Total Absolute deviation 22
Average Absolute Deviation 3.66667

According to the Naïve forecasting method, the forecast value of current period is equal to the actual demand of previous period.

Period Demand (A) Naïve Forecast (F) Absolute deviation

AD = |A – F|

1 90
2 85 90 5
3 91 85 6
4 92 91 1
5 95 92 3
6 88 95 7
Total Absolute deviation 22
Average Absolute Deviation 4.4

MAD of Actual Forecasting method = 3.67

MAD of Naïve Forecasting method = 4.4

According to MAD criteria, lower the MAD, accurate is forecasting value.

As the MAD of actual method is less than Naïve method, manager should continue with the actual forecasting method.

Still stressed from student homework?
Get quality assistance from academic writers!