please use excel and show formulas

Question 2) Quarterly demand values for flowers at a wholesaler are as shown below. Forecast quarterly demand for year 5 using simple exponential smoothing with a=0.1 as well as Holt's model with a=0.1 and B=0.1. Which of the two methods do you prefer? Why? (Hint: You need to use accuracy measures). Table 1 - Quarterly Demand (in Thousand dollars) Year 1 Quarter 1 11 Demand ($000) 98 106 109 =- 133 N 1 11 111 130 116 133 116 138 130 147 141 144 142 165 173 Monthly demand at A&D Electronics for flat screen TVs are as follows: Month Demand (units) 1 1,000 2 1,113 3 1,271 4 1,445 5 1,558 6 1,648 7 1,724 8 1,850 9 1,864 10 2,076 11 2,167 12 2,191 Estimate demand for the next two months using simple exponential smoothing with a=0.3 and Holt's model with a=0.05 and B=0.1. For the simple exponential smoothing model, use the level at Period 0 to be LO = 1,659 (the average demand over the 12 months). For Holt's model, use level at Period 0 to be LO = 948 and the trend in Period 0 to be TO = 109. Evaluate the MAD, MAPE, MSE, bias, and TS in each case. Which of the two methods do you prefer? Why