Question: 4 5 points Weighted Moving Average Forecast Compute the sales forecast for the month of January 2022 using the Weighted Moving Average forecasting technique and

4 5 points Weighted Moving Average Forecast4 5 points Weighted Moving Average Forecast

4 5 points Weighted Moving Average Forecast Compute the sales forecast for the month of January 2022 using the Weighted Moving Average forecasting technique and the last 3 months of 2021 data with the following monthly weights: (Refer to Slide 32 in Chapter 02 -or- Pages 49 and 50 in the textbook) Weights: 0.60 for the previous month, 0.30 for 2 months prior, 0.10 for 3 months prior Monthly sales for the RUOK Company for the last 12 months are as follows: MONTH January 2021 February 2021 March 2021 April 2021 May 2021 June 2021 July 2021 August 2021 September 2021 October 2021 November 2021 December 2021 ACTUAL SALES 93,490 77,700 52,150 42,030 11,640 81,600 11,320 27,900 38,180 49,210 22,520 53,2201 FORECAST MONTH January 2022 ??,??? Type your answer... 5 5 points Mean Absolute Deviation (MAD) Calculate the Mean Absolute Deviation (MAD) using the following data. Round to the nearest whole number (Refer to Slides 52, 53, and 54 in Chapter 02 -or- Pages 54 and 55 in the textbook) Month Actual Sales Forecast JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC 1,345 1,445 1,470 1,390 1,340 1,345 1,300 1,375 2,152 2.314 2,352 2,224 1,275 1,330 1,550 1,420 1,250 1,340 1,405 1,355 2,100 2,135 2,424 2,272 Type your

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!