Question 2: Demand Forecasting I [25] a. Develop a linear trend equation for the following data on demand for white bread loaves at a bakery and use it to forecast demand on day 16. Use Excel's Trendline with display equation on chart option. Day Day 1 2 3 4 5 Loaves 200 214 211 228 235 6 7 8 9 10 Loaves 232 248 250 253 267 Day 11 12 13 14 15 Loaves 281 275 280 288 310 1 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. c. Use the first four days to estimate the initial smoothed series (use the average of the first four days) and smoothed trend (use the increase from day 1 to day 4 divided by 3). Start forecasting day 5. What is the forecast for day 167 d. Include Excel file and all relevant parameters