Question: Please explain and type. It is hard to understand handwriting at times. 1. While the MAD can be used to determine which forecasting method is

Please explain and type. It is hard to understand handwriting at times.

1. While the MAD can be used to determine which forecasting method is the most accurate, normally, the MAPE is a better measure. So, compare the MAPE of the three methods and determine which is the best model (e.g. the most accurate).

2. Base on the chosen model, what should you recommend to your boss as the forecasted demand for January?

3. Produce a line chart that shows all three of the forecast and the actual demand.

4. Review the chart and the data. Do you think that the forecasts have given you an accurate result? Do you notice any trends in the data that could affect the January forecast? If so, what would you recommend to your boss?

  • Simple Moving Average (on a 4-month moving average)
  • Weighted Moving Average (4 month moving average with weights = 0.4, 0.3, 0.2. 0.1)
  • Exponential Smoothing (? = 0.3) (assume forecast for January is the same as the actual demand)
Please explain and type. It is hard to understand handwriting at times.1.While the MAD can be used to determine which forecasting method isthe most accurate, normally, the MAPE is a better measure. So, compare

Provided Data for Forecasting Modules Demand January 1750 February 1700 March 1650 April 1600 May 1625 June 1650 July 1650 August 1750 September 1750 October 1600 November 1550 December 15001750 1533 15m 1!\" 1150 Demand Data Chart of the Last Two Years i; Demand Data [Ian 2 years) aw 1* J 1" Wxxf 4* 4* i\" \"fix? Questions to be addressed 1. While the MAD can be used to determine which forecasting method is the most accurate. normally, the MAPE is a better measure. So. compare the MAPE of the three methods and determine which is the best model leg. the most accurate}. 2. Base on the chosen model, what should you recommend to your boss as the forecasted demand forJanuary? 3. Produce a line chart that shows all three of the forecast and the actual demand. 4. Review the chart and the data. Do you think that the forecasts have given you an accurate result? Do you notice any trends in the data that could affect the January forecast? If so, what would you recommend to your boss? Forecasting Models - Simple Moving Average [on a 4 month moving average]I - Weighted Moving Average [4 month moving average with weights = 0.4, (13, 12. 0.1} - Exponential Smoothing {o = {13} {assume forecast forJanuary is the same as the actual demand}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!