Page of 2 Actual Sales 2-Month Moving Absolute Value Мonth Average Forecast - Sales (# of Product X) of Errors (# of Product X) Jan/19 Feb/19 Mar/19 1,860 2,033 3,556 4,211 6,250 7,990 Apr/19 May/19...


I need help solving A B and C.


Page<br>of 2<br>Actual Sales<br>2-Month Moving<br>Absolute Value<br>Мonth<br>Average Forecast - Sales<br>(# of Product X)<br>of Errors<br>(# of Product X)<br>Jan/19<br>Feb/19<br>Mar/19<br>1,860<br>2,033<br>3,556<br>4,211<br>6,250<br>7,990<br>Apr/19<br>May/19<br>Jun/19<br>Jul/19<br>Aug/19<br>Sep/19<br>Oct/19<br>Nov/19<br>10,250<br>9,850<br>9,980<br>9,990<br>7,895<br>5,353<br>Dec/19<br>Jan/20<br>- Calculate the 2-month Moving Average Forecast for sales from March/2019 to<br>/2019 and enter them in the table above.<br>-Calculate the Absolute Value of Error for every forecasted month, from March/2019 to<br>a)<br>b)<br>bnsber/2020. Enter those values on the table above.<br>- Calculate the Mean Absolute Deviation (MAD), the Mean Squared Error (MSE) and the<br>weanosolute Percent Error (MAPE) for the 2-month Moving Average Forecast you created for<br>Product X from March/2019 to December/2020.<br>d)<br>- Create a table that shows the MAD, MSE and MAPE values you obtained for the Naive<br>Forecast and for the 2-month Moving Average Forecast. Which method would you recommend<br>and why?<br>MacBook Air<br>

Extracted text: Page of 2 Actual Sales 2-Month Moving Absolute Value Мonth Average Forecast - Sales (# of Product X) of Errors (# of Product X) Jan/19 Feb/19 Mar/19 1,860 2,033 3,556 4,211 6,250 7,990 Apr/19 May/19 Jun/19 Jul/19 Aug/19 Sep/19 Oct/19 Nov/19 10,250 9,850 9,980 9,990 7,895 5,353 Dec/19 Jan/20 - Calculate the 2-month Moving Average Forecast for sales from March/2019 to /2019 and enter them in the table above. -Calculate the Absolute Value of Error for every forecasted month, from March/2019 to a) b) bnsber/2020. Enter those values on the table above. - Calculate the Mean Absolute Deviation (MAD), the Mean Squared Error (MSE) and the weanosolute Percent Error (MAPE) for the 2-month Moving Average Forecast you created for Product X from March/2019 to December/2020. d) - Create a table that shows the MAD, MSE and MAPE values you obtained for the Naive Forecast and for the 2-month Moving Average Forecast. Which method would you recommend and why? MacBook Air

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here