Following are the data on demand for white bread loves to be 10 214 212 229 237 24 259 11 12 207 201 270 270 200 31 Develop a lineartrend equation for the above data on demand for wnite bread loves at a bakery use of Excel's Trendline, with display Equation on chart option is recommended and use it to forecast demand on day 16. Cound the final answers to 2 decimal places Y- Forecast demand on day 16 b. The variations around the heat trend line seem to have above and below.the-line runs. Therefore, use trend adjusted exponential smoothing with a 0.3 and 3.0.2 to model the bread demand. Use the first four days to estimate the smoothed initial trend that you use for periods 4 and 5 use the increase from day to day 4 divided by 3) Also, use Ad to estimate So Start forecasting day 5. What is the forecast for day 16? (Wound the final answers to 2 decimal places) Period TANE 10 15 480 313 a. Develop a linear trend equation for the above data on demand for white bread loaves at a bakery use of Excel's Trendine, with display Equation on chart option is recommended), and use it to forecast demand on day 16. (Round the final answers to 2 decimal places.) Y = Forecast demand on day 16 b. The variations around the linear trendline seem to have above- and below.the-line runs. Therefore, use trend-adjusted exponentin smoothing with a 0.3 and -0.2 to model the bread demand. Use the first four days to estimate the smoothed initial trend that you use for periods 4 and 5 (use the increase from day 1 to day 4 divided by 3). Also, use Ag to estimate Sa Start forecasting day 5 What is the forecast for day 16? (Round the final answers to 2 decimal places.) Period TAFE 5 6 7 9 10 11 12 13 15 16 Forecast for day 16 I Following are the data on demand for white bread loves at a bakery Loves 194 314 212 228 237 240 249 ous. 259 12 11 12 13 14 15 258 267 281 278 279 288 313 a. Develop a linear trend equation for the above data on demand for white bread loaves at a bakery (use of Excel's Trendline, with display Equation on chart option, is recommended), and use it to forecast demand on day 16. (Round the final answers to 2 decimal places.) Y- Forecast demand on day 16 b. The variations around the linear trend line seem to have above- and below.the-line runs. Therefore, use trend-adjusted exponential smoothing with a = 0.3 and B = 0.2 to model the bread demand. Use the first four days to estimate the smoothed initial trend that you use for periods 4 and 5 (use the increase from day 1 to day 4 divided by 3). Also, use Ad to estimate Sa Start forecasting day 5. What is the forecast for day 167 (Round the final answers to 2 decimal places.) Period TAFE 5 E 7 14 15 288 313 a. Develop a linear trend equation for the above data on demand for white bread loaves at a bakery (use of Excel's Trendline, with display Equation on chart option is recommended), and use it to forecast demand on day 16. (Round the final answers to 2 decimat places) Ye Forecast demand on day 16 b. The variations around the linear trend line seem to have above and below-the-line runs. Therefore, use trend-adjusted exponential smoothing with a = 0.3 and = 0.2 to model the bread demand. Use the first four days to estimate the smoothed initial trend that you use for periods 4 and 5 (use the increase from day 1 to day 4 divided by 3). Also use Ad to estimate S4. Start forecasting day 5. What is the forecast for day 16? (Round the final answers to 2 decimal places.) Period TAFE S 6 7 8 9 10 11 12 13 14 15 16 Forecast for day 16