K
KOA
Financial Hub
RS
Back to Data Analytics
Scheduling Assistant
Occupancy-driven staffing & pay model.
KOA Grand Canyon3 of 6
Occupancy adjustment
100%
Applies to all 14 days
Total sites at property: 180
Avg party: 2.1 adults / 1.3 kids per site
live
Editing occupancy % or any per-day Occupied Sites cell recalculates below.
Workload Summary
| Date | Staff Group | Occupied | Guests | Adults | Kids | Checkins | Checkouts | Turnovers | Base Hrs | Turn Hrs | Total Hrs |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Mon 07/06 | Light | 381 | 235 | 146 | 22 | 19 | 19 | 100.8 | 14.3 | 115.1 | |
| Tue 07/07 | Light | 367 | 227 | 140 | 18 | 20 | 20 | 97.2 | 15.0 | 112.2 | |
| Wed 07/08 | Standard | 405 | 250 | 155 | 26 | 17 | 17 | 107.1 | 12.8 | 119.9 | |
| Thu 07/09 | Standard | 435 | 269 | 166 | 30 | 24 | 24 | 115.2 | 18.0 | 133.2 | |
| Fri 07/10 | Peak | 507 | 313 | 194 | 44 | 28 | 28 | 134.1 | 21.0 | 155.1 | |
| Sat 07/11 | Peak | 557 | 344 | 213 | 52 | 38 | 38 | 147.6 | 28.5 | 176.1 | |
| Sun 07/12 | Peak | 537 | 332 | 205 | 20 | 49 | 49 | 142.2 | 36.8 | 179.0 | |
| Mon 07/13 | Light | 392 | 242 | 150 | 24 | 21 | 21 | 103.5 | 15.8 | 119.3 | |
| Tue 07/14 | Light | 374 | 231 | 143 | 19 | 22 | 22 | 99.0 | 16.5 | 115.5 | |
| Wed 07/15 | Standard | 415 | 256 | 159 | 27 | 18 | 18 | 109.8 | 13.5 | 123.3 | |
| Thu 07/16 | Standard | 452 | 279 | 173 | 31 | 25 | 25 | 119.7 | 18.8 | 138.5 | |
| Fri 07/17 | Peak | 520 | 321 | 199 | 45 | 29 | 29 | 137.7 | 21.8 | 159.5 | |
| Sat 07/18 | Peak | 568 | 351 | 217 | 50 | 40 | 40 | 150.3 | 30.0 | 180.3 | |
| Sun 07/19 | Peak | 551 | 340 | 211 | 18 | 47 | 47 | 145.8 | 35.3 | 181.1 | |
| TOTAL | 14 days | 1,900 | 6,461 | 3,990 | 2,471 | 426 | 397 | 397 | 1710.0 | 298.1 | 2008.1 |
Recommended Schedule by Department
Derived from workload above. Dept total includes fixed shift minimums.
| Department | 07/06 | 07/07 | 07/08 | 07/09 | 07/10 | 07/11 | 07/12 | 07/13 | 07/14 | 07/15 | 07/16 | 07/17 | 07/18 | 07/19 | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Housekeeping | 27.3 | 27.2 | 27.2 | 32.4 | 37.8 | 45.5 | 50.7 | 28.8 | 28.6 | 28.2 | 33.7 | 38.9 | 47.1 | 50.2 | 503.6 |
| Facilities & Grounds | 14.7 | 14.5 | 15.1 | 15.7 | 16.9 | 17.8 | 17.5 | 14.9 | 14.6 | 15.3 | 16.0 | 17.2 | 18.0 | 17.7 | 225.9 |
| Go Karts | 9.8 | 9.7 | 10.1 | 10.4 | 11.1 | 11.6 | 11.4 | 9.9 | 9.7 | 10.2 | 10.5 | 11.2 | 11.7 | 11.5 | 148.8 |
| Guest Services | 16.2 | 15.6 | 16.6 | 18.8 | 22.4 | 26.0 | 21.8 | 17.0 | 16.2 | 17.0 | 19.2 | 22.8 | 26.0 | 21.0 | 276.6 |
| F&B | 13.6 | 13.3 | 14.1 | 14.7 | 16.1 | 17.1 | 16.7 | 13.8 | 13.5 | 14.3 | 15.0 | 16.4 | 17.4 | 17.0 | 213.0 |
| Activities | 8.6 | 8.4 | 8.9 | 9.2 | 10.1 | 10.7 | 10.4 | 8.7 | 8.5 | 9.0 | 9.4 | 10.2 | 10.8 | 10.6 | 133.5 |
| TOTAL HOURS | 90.2 | 88.7 | 92.0 | 101.2 | 114.4 | 128.7 | 128.5 | 93.1 | 91.1 | 94.0 | 103.8 | 116.7 | 131.0 | 128.0 | 1501.4 |
| Total Estimated Pay | $1,644 | $1,615 | $1,677 | $1,844 | $2,086 | $2,345 | $2,325 | $1,696 | $1,658 | $1,713 | $1,890 | $2,127 | $2,385 | $2,315 | $27,321 |
| Average Hourly Wage | $18.22 | $18.21 | $18.23 | $18.22 | $18.23 | $18.22 | $18.10 | $18.22 | $18.20 | $18.23 | $18.21 | $18.23 | $18.21 | $18.09 | $18.20 |