From Chapter 8 (Data Analytics book Camm et al.) solve case problem 1 Forecasting food and beverage sales. Please complete the following: a) Develop a time series plot and comment on the underlying pattern of the data. What type of model seems most appropriate to develop a forecast for this data? b) Develop a forecasting model for the data. If more than one model option is available, provide a summary of your analysis of each option including (R-square, F-test, residual plots, and significance of coefficients) to justify your choice of model. c) Forecast sales from January through December of the fourth year. d) Assume that January sales for the fourth year turn out to be $295,000. What was your forecast error? If the error is large, Karen may be puzzled about the difference between your forecast and the actual sales value. What can you do to resolve her uncertainty about the forecasting procedure? Month Sales 1 242 2 235 3 232 4 178 5 184 6 140 7 145 8 152 9 110 10 130 11 152 12 206 13 263 14 238 15 247 16 193 17 193 18 149 19 157 20 161 21 122 22 130 23 167 24 230 25 282 26 255 27 265 28 205 29 210 30 160 31 166 32 174 33 126 34 148 35 173 36 235 Please show the excel answers and a vivid explanation