3 Directions: 4. 1. Complete the folowing four problems, save your work, then submit your saved spreadsheet to Canvas by the due date and time given by Canvas 52. Do not change the name of this file when you save your work. The file should be called "Graded Homework 1 xls 63. Express all real numbers in this spreadsheet in FOUR (4) decimal places 74 To facilitate grading, please do not delete or insert ROWS 8 Use simple exponential smoothing to and 10 to prepare forecast for period 25 | Problema 47 Alpha Actu Demand be Period 1 100 36 Bag? 11 14 1 19 99 56 115 127 115 304 111 24 26 80 BBBB5 36 | 4 | 44 - 39 4 44 45 118 9 47 99 MAD 4 11 TO 110 110 TE | 129 118 13 TH 15 17 20 30 115 127 115 104 111 20 90 102 100 129 111 20 79 123 30 31 11 100 25 110 109 120 120 | BB 112 122 | 40 91 42 4 44 116 45 46 119 47 121 48 49 124 50 110 100 61 101 MAD 112 103 m Use Solver to find the exponential smoothing constant that is MAD (Do not found the optimal pha) 104 Using the optimal value of a found in (a) and sample exponential smoothing, find the forecast for persod 51 97 14 | | 48 Alpha= Actual Demand At Exponentially- Smoothed Forecast Ft 100 Absolute Deviation 102 49 50 51 52 53 54 55 56 57 58 59 60 61 62 83 Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 90 119 82 124 92 91 96 124 110 93 96 129 118 103 106 99 86 115 127 115 TO 71 12 104 74 76 111 126 98 102 109 129 111 125 103 TB 79 BO 33 34 116 100 36 30 120 90 100 1 12 43 110 110 123 00 3 Directions: 4. 1. Complete the folowing four problems, save your work, then submit your saved spreadsheet to Canvas by the due date and time given by Canvas 52. Do not change the name of this file when you save your work. The file should be called "Graded Homework 1 xls 63. Express all real numbers in this spreadsheet in FOUR (4) decimal places 74 To facilitate grading, please do not delete or insert ROWS 8 Use simple exponential smoothing to and 10 to prepare forecast for period 25 | Problema 47 Alpha Actu Demand be Period 1 100 36 Bag? 11 14 1 19 99 56 115 127 115 304 111 24 26 80 BBBB5 36 | 4 | 44 - 39 4 44 45 118 9 47 99 MAD 4 11 TO 110 110 TE | 129 118 13 TH 15 17 20 30 115 127 115 104 111 20 90 102 100 129 111 20 79 123 30 31 11 100 25 110 109 120 120 | BB 112 122 | 40 91 42 4 44 116 45 46 119 47 121 48 49 124 50 110 100 61 101 MAD 112 103 m Use Solver to find the exponential smoothing constant that is MAD (Do not found the optimal pha) 104 Using the optimal value of a found in (a) and sample exponential smoothing, find the forecast for persod 51 97 14 | | 48 Alpha= Actual Demand At Exponentially- Smoothed Forecast Ft 100 Absolute Deviation 102 49 50 51 52 53 54 55 56 57 58 59 60 61 62 83 Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 90 119 82 124 92 91 96 124 110 93 96 129 118 103 106 99 86 115 127 115 TO 71 12 104 74 76 111 126 98 102 109 129 111 125 103 TB 79 BO 33 34 116 100 36 30 120 90 100 1 12 43 110 110 123 00