1. Use Moving Average Method (use data of the last three weeks) (1 point)

2. Use Weighted Moving Average (use data of the last three weeks and use 0.6, 0.3, and 0.1 weighting factors for weeks from most recent to oldest) (1 point)

3. Use exponential smoothing factor and use smoothing constant (?) as 0.1 (Take the forecast for the first week as 2500) (1 point)

4. Calculate and compare the Mean Absolute Deviations (MAD). Which method will possibly work best in 2023? Why? (1 point)

5. Draw a graph to compare actual and forecast data for all techniques. (1 point)

6. Calculate MAD for smoothing constants (?) from 0.1-0.9 with 0.1 increments. Find the lowest MAD. (1 point)

7. Draw the smoothing factor vs MAD chart. Which smoothing factor works better? Explain your reasoning. (1 point)

Please make your calculations in MS Excel but your submission as PDF file in proper professional look.

A B Number of Week 1 visitors 2 1 2576 3 2 2657 4 3 2876 5 4 3003 6 5 7 2976 2345 8 9 10 =222222222228858838858885493 494 48 773888888 11 12 13 14 15 16 17 18 19 20 21 26 27 30 31 36 37 221667~~~~~222288523338583++9399+%2858 2886 3224 2903 10 3100 11 3523 2576 2657 14 2876 3003 2976 2345 2888 3224 20 2903 3100 3523 2576 24 2657 2876 3003 2976 2345 2886 30 3224 2903 3100 3523 34 2576 2657 2876 3003 2976 40 2345 41 40 2888 41 42 3224 2903 44 43 3100 45 44 3523 46 45 47 46 48 47 3224 2903 3100 49 48 3523 50 49 3224 51 50 2903 52 53 3100 3523 54 55 56 57 58 59 60 61 62 D E Sheet2