Forecasting Exercise 5_Solution.xlsx - Seasonality Exercise Create a seat occupancy forecast by 15-minute time interval for the River Restaurant for

Forecasting Exercise 5_Solution.xlsx - Seasonality Exercise...

This preview shows page 1 - 2 out of 2 pages.

Seasonality Exercise
Time Period Date 6:45-7:00 7:00-7:15 7:15-7:30 7:30-7:45 7:45-8:00 8:00-8:15 8:15-8:30 8:30-8:45 8:45-9:00 Total 10/24/2016 29 40 33 24 24 25 27 15 10 227 10/31/2016 29 45 33 28 24 25 27 15 15 241 11/7/2016 30 48 34 22 24 26 27 16 16 243 11/14/2016 33 52 33 26 24 25 26 15 18 252 11/21/2016 35 55 32 30 23 24 26 15 12 252 11/28/2016 37 56 31 28 22 23 25 14 14 250 12/5/2016 38 59 30 31 22 23 24 14 11 252 Average 33.00 50.71 32.29 27.00 23.29 24.43 26.00 14.86 13.71 245.29 % of arrivals 13.45% 20.68% 13.16% 11.01% 9.49% 9.96% 10.60% 6.06% 5.59% 12/12/2016 6:45-7:00 7:00-7:15 7:15-7:30 7:30-7:45 7:45-8:00 8:00-8:15 8:15-8:30 8:30-8:45 8:45-9:00 33.90332 52.102504 33.169482 27.73908 23.923122 25.097263 26.711706 15.263832 14.089691

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture