jasper pool study 061014
DESCRIPTION
Aquatics needs study for Jasper, Indiana 2014.TRANSCRIPT
Presented By:
Counsilman ▪ Hunsaker
June 10th, 2014
AgendaAgenda� Process Review� What We Heard� Options for Consideration� Demographic Overview� Operational Pro-forma� Summary
Feasibility Study ProcessFeasibility Study Process� Needs Assessment� Community Outreach � Common Vocabulary, Vision
� Public Meeting� Stakeholder Meetings
� Evaluate Existing Area Providers� Research Area Demographics� Identify Potential User Groups
� Program Requirements� Develop Options for Programming� Develop Project Cost Estimates� Conceptual Plan
� Operations Plan� Opinion Of Revenue � Opinion Of Operating Expenses� Determine Cashflow
Types of Aquatic ProgrammingTypes of Aquatic Programming
Aquatic ComponentsüCompetitiveüRecreationü Instructionü Fitness & Therapy
What We Heard
� Need new pool to enhance “quality of life” within Jasper� Definition of Success� Financial – Reduce “loss” per visitor� Improve quality of life in community – attract
visitors/new residents� Maximize number of users – increase visits� Provide amenities that are viable option to the Holiday
World “event”
Options for Consideration
� Option 1 – Multi-purpose leisure pool with zero depth entry, play feature, 6-25 yard lap lanes, diving board, separate tot pool, crossing activity, separate waterslide catch pool, shade structures and required support spaces
� Option 2 – Multi-purpose leisure pool with zero depth entry, play feature, 6-25 yard lap lanes, diving board, crossing activity, current channel
� Option 3 – 50 meter lap pool, diving board, drop slide, waterslide with run-out, leisure pool with ramp entry, water slide, spray features
Option 1� Option 1 – Multi-purpose leisure pool with zero depth entry,
play feature, 6-25 yard lap lanes, diving board, separate tot pool, crossing activity, separate waterslide catch pool, shade structures and required support spaces
Option 1 Description Unit Amount Opinion of Cost
Demolition Not Included
Bathhouse 4,020 $762,000Entrance/Recep Office Sq. Ft. 150 First Aid /Guard Room Sq. Ft. 200 Manager Office Sq. Ft. 150 Mechanical/Storage Sq. Ft. 1,050 Locker Rooms Sq. Ft. 1,200 Family Changing Room Sq. Ft. 150 Snack Bar/Concessions Sq. Ft. 450 Efficiency Sq. Ft. 670
Outdoor Leisure Pool 8,706 $1,765,100Multi-Purpose Pool Sq. Ft. 7,225 Diving Boards Add. Cost 1 Participatory Play Feature Allowance 1 Crossing Activity Add. Cost 1Slide Catch Pool Sq. Ft. 785 Waterslide 1st flume Quantity 1 Waterslide 2nd flume Quantity 1Tot Area Sq. Ft. 690 Features Allowance 1
Support 26,118 $383,238Pool Deck Sq. Ft. 17,412Fence Linear Ft. 1,000Overhead Lighting Sq. Ft. 26,118Funbrellas Quantity 3Equipment Allowance 1
Total Building Construction Costs 2,910,338
Site Construction Costs (parking lot, landscaping, utilities, walks) $602,760
Subtotal $3,513,098
Contingency 5% $175,655
Indirect Costs 10% $368,875
Total Estimated Project Costs: $4,057,628Say $4,100,000
OPINION OF PROJECT COST: Concept I
Option 2� Option 2 – Multi-purpose leisure pool with zero depth entry, play
feature, 6-25 yard lap lanes, diving board, crossing activity, current channel
Option 2 Description Unit Amount Opinion of Cost
Demolition Not Included
Bathhouse 4,020 $762,000Entrance/Recep Office Sq. Ft. 150 First Aid /Guard Room Sq. Ft. 200 Manager Office Sq. Ft. 150 Mechanical/Storage Sq. Ft. 1,050 Locker Rooms Sq. Ft. 1,200 Family Changing Room Sq. Ft. 150 Snack Bar/Concessions Sq. Ft. 450 Efficiency Sq. Ft. 670
Outdoor Leisure Pool 10,780 $2,046,500Multi-Purpose Pool Sq. Ft. 10,775 River / Vortex Equipment Add. Cost 1 Participatory Play Feature Allowance 1 Waterslide 1st flume Quantity 1 Diving Board Quantity 1 Crossing Activity Quantity 1
Support 32,340 $480,440Pool Deck Sq. Ft. 21,560Fence Linear Ft. 1,100Overhead Lighting Sq. Ft. 32,340Funbrellas Quantity 6Equipment Allowance 1
Total Building Construction Costs 3,288,940
Site Construction Costs (parking lot, landscaping, utilities, walks) $654,480
Subtotal $3,943,420
Indirect Costs 10% $394,342
Contingency 5% $216,888
Total Estimated Project Costs: $4,554,650Say $4,600,000
OPINION OF PROJECT COST: Concept II
Option 3� Option 3 – 50 meter lap pool, diving board, drop slide, waterslide
with run-out, leisure pool with ramp entry, water slide, spray features
Option 3 Description Unit Amount Opinion of Cost
Demolition Not Included
Bathhouse 6,240 $1,147,750Entrance/Recep Office Sq. Ft. 200 First Aid /Guard Room Sq. Ft. 200 Manager Office Sq. Ft. 150 Mechanical/Storage Sq. Ft. 2,150 Locker Rooms Sq. Ft. 1,500 Family Changing Room Sq. Ft. 250 Snack Bar/Concessions Sq. Ft. 750 Efficiency Sq. Ft. 1,040
Outdoor Leisure Pool 14,655 $2,695,00050 Meter Pool Sq. Ft. 11,500 Waterslide 1st flume Quantity 1 Waterslide 2nd flume Quantity 1 Diving Board Quantity 1Tot Area Sq. Ft. 3,150 Features Allowance 1 Waterslide 1st flume Add. Cost 1
Support 43,965 $593,565Pool Deck Sq. Ft. 29,310Fence Linear Ft. 1,100Overhead Lighting Sq. Ft. 43,965Funbrellas Quantity 10Equipment Allowance 1
Total Building Construction Costs 4,436,315
Site Construction Costs (parking lot, landscaping, utilities, walks) $903,690
Subtotal $5,340,005
Indirect Costs 10% $534,001
Contingency 5% $293,700
Total Estimated Project Costs: $6,167,706Say $6,200,000
OPINION OF PROJECT COST: Concept III
CapacityOption 1 Option 2 Option 3
WET-SIDE CAPACITYTraining (Available 25-Yard Lanes)Multi-purpose pool 6 6 11Tot Pool 0 0 0Slide Catch Pool 0 0 0Total 6 6 11
Estimated Training Holding Capacity 30 30 55Daily Training Capacity 90 90 165
Recreation (Surface Area Sq. Ft.)Multi-purpose pool 7,225 10,775 11,500Tot Pool 690 0 3,150Slide Catch Pool 785 0 0Total 8,700 10,775 14,650
Shallow Water 6,525 8,081 10,255Deep Water 2,175 2,694 4,395
Estimated Recreation Holding Capacity 283 350 454Daily Recreation Holding Capacity 707 875 1,135
Total Holding Capacity 313 380 509 Total Daily Facility Capacity 797 965 1,300
Parking / Site Size
Option 1 Option 2 Option 3Parking 125 152 204 Parking Sq. Ft. 41,000 50,000 67,000 Impervious Structure 30,138 36,360 50,205 Total Program Sq. Ft. 71,138 86,360 117,205 Total Sq. Ft. with Efficiency 142,276 172,720 234,410 Preferred Site Size Requirements (acres) 3.27 3.97 5.38 Recommended Site Size (acres) 4.90 5.95 8.07
Population
Radius Number Percent Number Percent Number Percent Number Percent Number Percent(000's) of Total (000's) of Total (000's) of Total (000's) Percent (000's) Percent
0 to 3 Miles 16.9 7.2% 17.0 7.2% 17.7 7.3% 0.0 0.3% 0.1 0.7%
3 to 5 Miles 19.3 8.2% 19.4 8.2% 20.1 8.3% 0.0 0.2% 0.1 0.8%
5 to 10 Miles 34.6 14.7% 34.7 14.7% 35.8 14.8% 0.1 0.2% 0.2 0.6%
Subtotal 70.7 30.0% 71.2 30.1% 73.7 30.4% 0.2 0.2% 0.5 0.7%
10 to 15 Miles 47.9 20.3% 48.1 20.3% 49.5 20.4% 0.1 0.1% 0.3 0.6%
15 to 25 Miles 117.2 49.7% 117.2 49.5% 119.1 49.2% 0.0 0.0% 0.4 0.3%
Subtotal 165.1 70.0% 165.3 69.9% 168.7 69.6% 0.1 0.0% 0.7 0.4%
Total (0-25 Miles) 235.8 100.0% 236.4 100.0% 242.3 100.0% 0.2 0.1% 1.2 0.5%
Jasper, IN 15.0 15.2 15.6 0.0 0.3% 0.1 0.6%
MARKET AREA POPULATION BY DISTANCEPopulation Average Annual Change
2010 2013 2018 2010-2013 2014-2019
Source: Experian
Age
Age Groups U.S. Age# % # % # % # % # % # % Population
Age 0-4 1,166 6.8% 1,285 6.6% 2,285 6.6% 3,066 6.4% 7,582 6.5% 1,061 7.0% 6.5%Age 5-9 1,143 6.7% 1,316 6.8% 2,384 6.9% 3,243 6.7% 8,088 6.9% 1,006 6.6% 6.5%Age 10-14 1,249 7.3% 1,435 7.4% 2,555 7.4% 3,519 7.3% 8,346 7.1% 1,089 7.2% 6.6%Age 15-19 1,092 6.4% 1,278 6.6% 2,374 6.8% 3,276 6.8% 7,907 6.7% 939 6.2% 6.9%
Subtotal 4,650 27.3% 5,314 27.4% 9,598 27.6% 13,104 27.2% 31,923 27.2% 4,095 27.0% 26.5%Age 20-24 814 4.8% 914 4.7% 1,658 4.8% 2,280 4.7% 6,192 5.3% 737 4.9% 7.1%Age 25-29 1,092 6.4% 1,195 6.2% 2,054 5.9% 2,740 5.7% 6,598 5.6% 999 6.6% 6.8%Age 30-34 1,065 6.2% 1,178 6.1% 2,134 6.1% 2,873 6.0% 6,814 5.8% 970 6.4% 6.6%Age 35-39 941 5.5% 1,082 5.6% 2,009 5.8% 2,782 5.8% 6,816 5.8% 833 5.5% 6.3%Age 40-44 1,073 6.3% 1,241 6.4% 2,277 6.6% 3,212 6.7% 7,470 6.4% 939 6.2% 6.8%Age 45-49 1,257 7.4% 1,461 7.5% 2,639 7.6% 3,736 7.8% 8,685 7.4% 1,093 7.2% 7.1%Age 50-54 1,324 7.8% 1,551 8.0% 2,781 8.0% 3,903 8.1% 9,216 7.9% 1,147 7.6% 7.3%Age 55-59 1,180 6.9% 1,374 7.1% 2,460 7.1% 3,489 7.3% 8,340 7.1% 1,031 6.8% 6.5%Age 60-64 975 5.7% 1,127 5.8% 2,030 5.8% 2,838 5.9% 7,347 6.3% 862 5.7% 5.7%Age 65-69 706 4.1% 800 4.1% 1,423 4.1% 2,003 4.2% 5,322 4.5% 634 4.2% 4.2%Age 70-74 603 3.5% 685 3.5% 1,228 3.5% 1,742 3.6% 4,331 3.7% 543 3.6% 3.1%Age 75-79 491 2.9% 544 2.8% 953 2.7% 1,345 2.8% 3,245 2.8% 447 3.0% 2.4%Age 80-84 417 2.4% 451 2.3% 746 2.1% 1,053 2.2% 2,510 2.1% 384 2.5% 1.9%Age 85+ 463 2.7% 486 2.5% 741 2.1% 1,009 2.1% 2,347 2.0% 437 2.9% 1.9%
TOTAL: 17,051 100.0% 19,403 100.0% 34,731 100.0% 48,109 100.0% 117,156 100.0% 15,151 100.0% 100%Median Age 37.0
MARKET AREAAGE DISTRIBUTION
0 to 3 Miles 3 to 5 Miles 5 to 10 Miles 10 to 15 Miles 15 to 25 Miles
Source: Experian
Jasper, IN
39.8 40.1 39.8 40.5 40.2 39.7
Income
Radius Dollars Index Dollars Index0 to 3 Miles $30,293 1.14 $57,432 1.09
3 to 5 Miles $30,506 1.15 $59,036 1.12
5 to 10 Miles $27,487 1.04 $55,518 1.06
10 to 15 Miles $26,221 0.99 $54,124 1.03
15 to 25 Miles $23,781 0.90 $49,867 0.95
Jasper, IN $30,090 1.14 $56,122 1.07
Total U.S. $26,464 1.00 $52,599 1.00Source: Experian
MARKET AREA INCOMEPer Capita Incomes Median Household Incomes
Group ProgrammingVisits per Program Day Option 1 Option 2 Option 3Swim Meet Rental 1 1 1 USA / City Swim Team 20 20 50 Masters Swim Team 30 30 30 Summer Swim Lessons 30 30 30 Lifeguard Training 10 10 10 Wellness Programming 10 10 10 Birthday Party 2 2 2 Private Rental 1 1 1
Programming Days Option 1 Option 2 Option 3Swim Meet Rental 2 2 6 USA / City Swim Team 60 60 60 Masters Swim Team 50 50 50 Summer Swim Lessons 32 32 32 Lifeguard Training 10 10 10 Wellness Programming 30 30 30 Birthday Party 60 60 60 Private Rental 50 50 50
Per Capita Spending (Net) Option 1 Option 2 Option 3Swim Meet Rental $500.00 $500.00 $1,000.00USA / City Swim Team $1.00 $1.00 $2.00Masters Swim Team $1.50 $1.50 $1.50Summer Swim Lessons $2.50 $2.50 $2.50Lifeguard Training $3.50 $3.50 $3.50Wellness Programming $1.50 $1.50 $1.50Birthday Party $50.00 $50.00 $50.00Private Rental $75.00 $75.00 $75.00
Opinion of Revenue (Net) Option 1 Option 2 Option 3Swim Meet Rental $1,000 $1,000 $6,000USA / City Swim Team $1,200 $1,200 $6,000Masters Swim Team $2,250 $2,250 $2,250Summer Swim Lessons $2,400 $2,400 $2,400Lifeguard Training $350 $350 $350Wellness Programming $450 $450 $450Birthday Party $6,000 $6,000 $6,000Private Rental $3,750 $3,750 $3,750
User-Group Revenue $17,400 $17,400 $27,200
Per Cap SpendingCategory Rate
Percent of Visits
Per Visit Unit
Residents Adult (18 & Older) 6.00 17% 1.02
Children (3-17) 4.00 20% 0.80 Free 0 2% -
Non-ResidentAdult 7.00 14% 0.98 Child 5.00 11% 0.55
Season PassResident
Individual 90.00 12% 0.27 Family 200.00 10% 0.17
Non-ResidentIndividual 110.00 8% 0.25 Family 275.00 6% 0.15
Subtotal / Average 100% 4.19
Food / Merchandise 0.05$ Total $4.24
Revenue
Option 1 Option 2 Option 3Attendance
2014 30,664 35,039 33,084 2015 30,876 35,280 33,310 2016 31,013 35,431 33,461 2017 31,225 35,672 33,687 2018 31,437 35,913 33,913
Per Capita Spending (3% Annual Increase) $4.24 $4.24 $4.24Special User Group Spending $17,400 $17,400 $27,200
2014 $147,358 $165,898 $167,4122015 $152,182 $171,404 $172,6052016 $156,724 $176,570 $177,5202017 $161,647 $182,187 $182,8182018 $166,623 $187,866 $188,174
ExpensesOption 1 Option 2 Option 3
Facility StaffFull Time Employment Not Included Not Included Not IncludedSummer Employment $76,901 $93,461 $143,141Winter Employment $2,760 $2,760 $4,140Training $1,000 $1,000 $2,000Total Labor $80,661 $97,221 $149,281
Contractual ServicesInsurance $23,129 $26,175 $35,860Repair and Maintenance $10,300 $11,500 $15,500Total Contractual Services $33,429 $37,675 $51,360
CommoditiesOperating Supplies $6,180 $6,900 $9,300Chemicals $11,824 $16,001 $22,832Advertising $10,000 $11,667 $11,000Total Commodities $28,004 $34,568 $43,132
UtilitiesHVAC $6,271 $6,271 $9,734Electricity $25,072 $30,332 $31,470Pool Heating $0 $0 $0Telephone $336 $336 $336Trash Service $2,700 $2,700 $2,700Water & Sewer $8,463 $10,455 $11,929Total Utilities $42,842 $50,094 $56,169
Total Operating Expenses $184,935 $219,557 $299,942
Capital Replacement Fund $20,500 $23,000 $31,000
Total Expense $205,435 $242,557 $330,942
Labor
Job Description Opt
ion
1
Opt
ion
2
Opt
ion
3
Hou
rly R
ate
Rat
e w
ith o
verh
ead
Indo
or
Out
door
Spra
ygro
und
Opt
ion
1
Opt
ion
2
Opt
ion
3
SummerCashier 9 9 9 7.00 $8.05 90 90 100 6,521 6,521 6,521Pool Manager 10 10 10 9.00 $10.35 90 90 100 9,315 9,315 9,315Lifeguard 70 90 150 8.00 $9.20 90 90 100 57,960 74,520 124,200Maintenance 2 2 2 15.00 $17.25 90 90 100 3,105 3,105 3,105Summer Total 91 111 171 $76,901 $93,461 $143,141
WinterCashier 0 0 0 7.00 $8.05 265 20 50 0 0 0Pool Manager 0 0 0 9.00 $10.35 265 20 50 0 0 0Lifeguard 0 0 0 8.00 $9.20 265 20 50 0 0 0Maintenance 8 8 12 15.00 $17.25 265 20 50 2,760 2,760 4,140Winter Total 8 8 12 $2,760 $2,760 $4,140
Annual Labor Expense $79,661 $96,221 $147,281
Total Employer ExpenseDays per SeasonCost Per HourHours Per Day
Summary2014 2015 2016 2017 2018
Option 1 Project Cost $4,100,000 Attendance 30,664
Revenue $147,358 $152,182 $156,724 $161,647 $166,623Expense $184,935 $189,559 $194,298 $199,155 $204,134Operating Cashflow ($37,578) ($37,377) ($37,573) ($37,508) ($37,511)Recapture Rate 80% 80% 81% 81% 82%Capital Replacement Fund $20,500 $20,500 $20,500 $20,500 $20,500Debt Service ($328,995) ($328,995) ($328,995) ($328,995) ($328,995)Cash Flow ($387,072) ($386,872) ($387,068) ($387,003) ($387,006)
Option 2 Project Cost $4,600,000 Attendance 35,039
Revenue $165,898 $171,404 $176,570 $182,187 $187,866Expense $219,557 $225,046 $230,672 $236,439 $242,350Operating Cashflow ($53,660) ($53,642) ($54,103) ($54,252) ($54,484)Recapture Rate 76% 76% 77% 77% 78%Capital Replacement Fund $23,000 $23,000 $23,000 $23,000 $23,000Debt Service ($369,116) ($369,116) ($369,116) ($369,116) ($369,116)Cash Flow ($445,776) ($445,758) ($446,219) ($446,368) ($446,600)
Option 3 Project Cost $6,200,000 Attendance 33,084
Revenue $167,412 $172,605 $177,520 $182,818 $188,174Expense $299,942 $307,440 $315,126 $323,005 $331,080Operating Cashflow ($132,530) ($134,836) ($137,607) ($140,186) ($142,906)Recapture Rate 56% 56% 56% 57% 57%Capital Replacement Fund $31,000 $31,000 $31,000 $31,000 $31,000Debt Service ($497,504) ($497,504) ($497,504) ($497,504) ($497,504)Cash Flow ($661,034) ($663,340) ($666,111) ($668,691) ($671,410)
Presented By:
Counsilman ▪ Hunsaker
June 10th, 2014