2 3 Directions 4 1. Complete the following four problems, save your work, then submit your saved spreadsheet to Canvas by the due date and time given by Canvas 5 2. Do not change the name of this file when you save your work. The file should be called "Graded Homework 1 xls" 62. Express all real numbers in this spreadsheet in FOUR (4) decimal places 74 To facilitate grading, please do not delete or insert ROWS 47 About Deviation Alpha Exponentially Attual Demand Smoothed Penod AL Forecast 1 TOR 100 2 90 118 50 51 124 63 54 66 56 6 7 124 10 110 126 61 129 63 14 15 103 65 16 106 66 99 TB 65 115 69 127 70 21 115 T1 104 23 73 25 58 75 26 102 VE 109 129 78 29 111 75 125 30 31 103 85 30 116 34 109 35 120 65 36 120 86 37 90 BY 38 112 BE 39 122 89 84 90 41 94 91 42 126 92 43 81 93 116 94 45 97 46 119 47 121 97 50 124 99 50 110 51 101 MAD 102 103 a Une Solver to find the exponential-smoothing constant that minimicos MAD (Do not round the optimal pha) 104 b. Using the optimal value of a found in ta) and simple exponential smoothing, find the forecast for period 51. 100 105