The accompanying data file contains daily sales (in $) at Caf Venetian for 100 days. For cross-validation, let the training and the validation sets comprise the first 80 days and the last 20 days, respectively. pictureClick here for the Excel Data File a. Use the training set to implement the Holt exponential smoothing method with two sets of user-supplied smoothing parameters. a-0.20 and -0.10 and a 0.30 and B-0.20. Compute the resulting performance measures for the validation set. (Round final answers to 2 decimal places.) Parameters User-supplied 1 User-supplied 2 MSE MAD MAPE (%) b-1. Determine the preferred smoothing parameters for making the forecast? because of the out of 3 performance measures b-2. Reestimate the preferred model with the entire data set to forecast sales for the 101st day. (Round final answer to the nearest whole number.) Forecast sales for the 101st day 4 Cut Paste A1 Copy Format Painter Clipboard X Calibri BI fx LLE Font A A Day F G H 8 9 8 10 11 12 13 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 234567=2222222222 83 88 -234567OFFEE PREPPAN88858 A B C D 1 Day Sales 1 263 215 311 356 6 5 243 282 382 289 9 358 10 269 11 361 12 314 14 13 379 15 14 281 15 384 16 405 17 284 18 291 19 332 20 594 21 436 22 397 23 428 24 466 25 312 26 459 27 392 28 526 29 845 30 521 31 373 32 773 Cafe Sales Clipboard S Font X fx Day 00 C D E F A1 A 34 33 753 35 34 4611 36 35 759 37 36 701 38 37 692 39 38 763 40 39 649 41 40 668 42 41 571 43 42 589 44 43 717 45 44 350 46 45 938 47 46 809 48 47 756 49 48 804 50 49 809 51 50 1305 52 51 996 53 52 701 54 53 872 55 54 877 56 55 701 57 56 869 58 57 835 59 58 789 60 59 722 61 60 786 62 61 1337 63 62 1078 64 63 783 65 64 968 66 65 1290 Cafe Sales Edit A1 . X D fx. Da E F A 00 66 65 1290 67 66 1704 68 67 1150 69 68 1224 70 69 1176 71 70 977 72 71 1019 73 72 1071 74 73 1321 75 74 1192 76 75 1009 77 76 1595 78 77 945 79 78 1415 80 79 1234 81 80 1574 82 81 1406 83 82 1467 84 83 1087 85 84 1600 86 85 1588 87 86 1539 88 87 1416 89 88 1416 90 89 1645 91 90 1760 92 91 1575 93 92 1713 94 93 1764 95 94 2936 96 95 1600 97 36 1809 98 97 1781 Cafe Sales Edit 83 82 1467 84 83 1087 85 84 1600 86 85 1588 87 86 1539 88 87 1416 89 88 1416 90 89 1645 91 90 1760 92 91 1575 93 92 1713 94 93 1764 95 94 2936 96 95 1600 97 96 1809 98 97 1781 99 98 1663 100 99 2663 101 100 2020 102 103 104 105 106 107 108 109 Cafe Sales Edit Type here to search