a. Compute a linear trend line for height car loadings (Use of Excel's Trendline is recommended. Make sure to select the display equation option) h. Use the trend equation to predict loadings for weeks 19 and 20' c. The manager intends to install new equipment when the volume reaches 700 loadings per week Assuming the current trend continues, the loading volume will reach that level in approximately what week? 9. After plotting the following demand data, a manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. Use 1 to 4 to alimate the initial smoothed series (use the average of the rst four periods) and smoothed trend (use the increase from day 1 to day 4 divided by 3). Use a = 0.5 and I! = 0.4 to develop forecasts for periods 5 through In. I Perio An Act d, t ual 13. coal shipments from a mine for the past 18 weeks are: L03 & A Tonnes Tonnes hipped Week Shipped 2 224 410 11 M6 4 240 13 455 15 466 17 476 H 6 Plot the data as time series, determine the pattern, and explain why an averaging technique would not be appropriate in this case. I). Use an appropriate technique to develop a forecast for week 19. 14. Calculate daily seasonal relatives for the number of customers served at a restaurant, given the following data. ( Hint: Use a seven- day centred moving average.) L05 Deseasonalize the data, t an appropriate model to the deseasonalized data, project it seven days ahead, and reseasonalize the projections to forecast daily demand nnyt maul