Operations Management homework help

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 uncertaintyAssume 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.
The assessment of your work will include the accuracy as well as the clarity of the spreadsheet and graph (e.g., clear labels, good alignment, easy to understand, etc.).
  • attachment

    metad680_PS1Data.xlsx
  • attachment

    metad680_PS1Forecasting.pdf
  • attachment

    Example_COMPLETEDEXCEL.xlsx
Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!
%d bloggers like this: