Question: I am not sure where I have gone wrong with my MFE. All the forecasts are correct. Develop an exponential smoothing forecast (a=0.5) for February

I am not sure where I have gone wrong with myI am not sure where I have gone wrong with my

I am not sure where I have gone wrong with my MFE. All the forecasts are correct.

Develop an exponential smoothing forecast (a=0.5) for February 2019 through January 2020. Assume that your forecast for January 2019 was 90. Calculate the MFE, MAD, and MAPE values for February through December 2019. Click the icon to view the time series data. Find an exponential smoothing forecast for each period and fill-in the table below (enter your responses rounded to one decimal place). Demand 125 Month January 2019 February March Forecast 90 107.5 66 97 86.8 April 80 91.9 110 86 137 98 110 117.5 May June July August September October 117 113.7 100 115.4 103 107.7 November 93 105.3 December 94 99.2 The forecast for January 2020 is 96.6. (Enter your response rounded to one decimal place.) The MFE is 1.1. (Enter your response rounded to one decimal place and include a minus sign if necessary.) a 0.5 Month Jan-19 February March April May June July August September October November December exponential smoothing forecast (0.5) for February 2019 through January 2020 Demand Forecast Forecast error Absolute Deviation Absolute percentage error 125 90 35 35 0.28 66 107.5 -41.5 41.5 0.628787879 97 86.75 10.25 10.25 0.105670103 80 91.875 -11.875 11.875 0.1484375 110 85.9375 24.0625 24.0625 0.21875 137 97.96875 39.03125 39.03125 0.284899635 110 117.484375 -7.484375 7.484375 0.068039773 117 113. 7421875 3.2578125 3.2578125 0.027844551 100 115.3710938 -15.37109375 15.37109375 0.153710938 103 107.6855469 -4.685546875 4.685546875 0.045490746 93 105.3427734 -12.34277344 12.34277344 0.132717994 94 99.17138672 -5.171386719 5.171386719 0.055014752 96.58569336 MFE MAD MAPE 17.50264486 1.09761556 0.179113656

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 General Management Questions!