Problem #2- Y from January to December of 2019, as presented in Problem #1. -The table below shows the same actual sales of a Product X sold by Company Month Actual Sales 2-Month Moving Absolute Value...


I just need the first 3 please (:


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

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

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here