a. Calculate a seasonal factor for each day of the week. Round to 2 decimal points.
b. The owner estimates that there will be 440 total guests in week 5. Forecast the number of customers for each day of week 6 using the Multiplicative Seasonal Forecast Model. Round to 1 decimal place.
c. Suppose the regression forecast for daily demand fit to the data for the 25 days shown has a slope of 0.7 and an intercept of 71.9. Forecast the customers for each day of week 6 using the Seasonally Adjusted Trend Projection Model. Round to 1 decimal place.
Day | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | a. SI | b. Forecast | c. Forecast |
Mon | 55 | 54 | 60 | 62 | 62 | |||
Tue | 68 | 67 | 76 | 75 | 74 | |||
Wed | 85 | 95 | 90 | 95 | 93 | |||
Thu | 81 | 82 | 79 | 80 | 96 | |||
Fri | 96 | 105 | 99 | 97 | 102 |