Create an Excel spreadsheet that fits a time series model (with level, linear trend, and seasonal components) for purposes of forecasting daily demand at Penguin. Include calculations necessary to determine forecast margin of uncertainty. Assume that forecast errors are normally distributed.
Use your time series model to forecast future daily demand for the next three weeks (April 9-28), including a margin of uncertainty for each day’s forecast. Include a graph that shows information regarding the forecast.