What should i put in solver to find answer to 1d and 1e

A B D E F G H s U w X Z A4 AB AC 2 2 2 1 4 1 Method ALL QUESTIONS ARE IN RED, PROVIDE ANSWERS IN YELLOW CELLS First forecast for period t to obtain Ft, then observe demand Dt and calculate error et la) Determine forecasts for periods 2 through 12 using ES(alpha=0.22). 1b) Determine the ME, MSE, MAD, and MAPE of your forecast for periods 2 thorough & 1c) Is your forecast unbiased? Explain. ; 1d) Find the alpha that minimizes MAD using Solver and report MAD le) Find alpha that minimizes MSE using Solver and report MSE 5 ES no te the mean errare utilo Answer: abstet) Slet/d/100 et et2 11 28.84 720.3656 -19.12 2916 --60.42 25734.575 -2114 116995 221.78 40186.366 -222 6 91106 FO 241.74 58436.226 25.84 13.04 51 29.2 29.1215065 160.42 89.122222 2114 11.223100 221.78 80.064952 222.0 760431 COAT 241.74 79.519737 7 0.22 . 9 TD) DI FRI 101 ? 11 2 44 17.16 12 1 HO . 13 34 4 1.00 19.58 14 5 251 190 15 156 277 55.22 167 253 0094 12 8 304 62.26 19 9 9 G6,82 GER 19 10 0 20 11 12 O 22 221 24 consider periods 2.8 25 ME -1662220 26 MSE 33481.53 MAD 166.7278 28 MAPS 30.217154 30 11 32 2 34 35 36 37 39 40 4 43 45 42 49 49 50