2021 Sales Elite Electric Units Sold Jan 250 Feb 270 Mar 210 Apr 314 May 346...

Transcribed Image Text:

2021 Sales Elite Electric Units Sold Jan 250 Feb 270 Mar 210 Apr 314 May 346 Jun 297 Jul 165 Aug 361 Sep 310 Oct 347 Nov 290 Dec 311 Submit ONE EXCEL Document containing: Your name, section, and student number. 1. 2. Table One (20%): A) Calculate a 3-month Simple moving average, for Apr-Dec to show what your forecasts would have been for 2021. Calculate the Mean Absolute Deviation, the mean squared error and the mean absolute percent error for this set of data. B) Calculate a 2-month Simple moving average for March-Dec of 2021. Calculate the Mean Absolute Deviation, mean squared error and mean absolute percent error. C) Create a text box beside the table with a sentence indicating which of the two forecasts might be more accurate and why. Table Two (20%): A) Calculate a 3-month weighted moving average with weighting of .5, .3,2, for Apr- Dec of 2021. Calculate the Mean Absolute Deviation, the mean squared error and the mean absolute percent error. B) Calculate a second 3-month Weighted moving average using weights of .8, .15,.05 for Apr-Dec of 2021. Calculate the Mean Absolute Deviation, mean squared error and mean absolute percent error for this method. C) Create a text box beside the table indicating which of the two forecasts might be more accurate and why. 2021 Sales Elite Electric Units Sold Jan 250 Feb 270 Mar 210 Apr 314 May 346 Jun 297 Jul 165 Aug 361 Sep 310 Oct 347 Nov 290 Dec 311 Submit ONE EXCEL Document containing: Your name, section, and student number. 1. 2. Table One (20%): A) Calculate a 3-month Simple moving average, for Apr-Dec to show what your forecasts would have been for 2021. Calculate the Mean Absolute Deviation, the mean squared error and the mean absolute percent error for this set of data. B) Calculate a 2-month Simple moving average for March-Dec of 2021. Calculate the Mean Absolute Deviation, mean squared error and mean absolute percent error. C) Create a text box beside the table with a sentence indicating which of the two forecasts might be more accurate and why. Table Two (20%): A) Calculate a 3-month weighted moving average with weighting of .5, .3,2, for Apr- Dec of 2021. Calculate the Mean Absolute Deviation, the mean squared error and the mean absolute percent error. B) Calculate a second 3-month Weighted moving average using weights of .8, .15,.05 for Apr-Dec of 2021. Calculate the Mean Absolute Deviation, mean squared error and mean absolute percent error for this method. C) Create a text box beside the table indicating which of the two forecasts might be more accurate and why.