Annual cost of time wasted waiting for City of Ottawa recreation registration

summary.md

After scraping the 2016/2017 recreation guides for all availablesession codes, the following assumptions were made;

• sessions average 10 spaces
• 35% of all sessions are booked in the initial rush period on registration nights (4x per year)
• 3 spaces are taken for each person waiting to register
• average wait time is 35 minutes
• average hourly wage is $26.57 (based on median household income of $102,020 and 2 wage earners in the household)

Therefore we get...

• 33,205 total sessions (17,093 fall/winter & 16,112 spring/summer)
• 332,050 total spaces, 116,217.5 booked during initial rush
• 38,739 wait periods (as 3 spaces are booked for each wait period)
• 22,598 hours spent waiting (35 minutes for each of the 38,739 wait periods)
• $15.5 spent for each hour waiting (based on a $26.57 average hourly wage)

$600,373.01 potential income lost to waiting for the registration page to load and the phone to pick up

Here's some of source data for the calculation.