Backup Documents 02/23/2021 Item #16C February 2021 Concurrency AnalysisMillion Gallons per Day (MGD)
WATER
REGIONAL
1a. 52.000
1b. 48.000
2a. 34.073
2b. 31.981
3a. 13.927
3b. 16.019
4a.SYSTEM AVAILABILITY BASED ON MAX. 3-DAY (Line 3a / Line 1b)29%
4b.SYSTEM AVAILABILITY BASED ON MAX. MONTH (Line 3b / Line 1b)33%
Current Available Diminishing Capacity (MADD) (Line 1b - Line 2b)
CURRENT AVAILABILITY WITHOUT FUTURE COMMITMENTS
CURRENT AVAILABLE CAPACITY (BASED ON HISTORICAL EXTREME EVENT)
Existing Permitted Plant Capacity (MADD)
Existing Operational Plant Capacity per 2020 AUIR
10-Year Maximum TDADD [1]
10-Year Maximum MADD [2]
COLLIER COUNTY WATER - SEWER DISTRICT
SYSTEM UTILIZATION AND DIMINISHING CAPACITY REPORT ("CHECKBOOK")
REGIONAL POTABLE WATER SYSTEM
DATA: Current as of February 3, 2021
Current Available Diminishing Capacity (TDADD) (Line 1b - Line 2a)
INTRODUCTION: The Checkbook uses the historical maximum 3-day average daily demand (TDADD) and monthly average daily demand (MADD)
from the last 10 years as baseline scenarios. Unbuilt future commitments are then multiplied by standard peaking factors and added to the baselines to arrive
at worst-case scenarios for future operational requirements.
1 of 8
COLLIER COUNTY WATER - SEWER DISTRICT
SYSTEM UTILIZATION AND DIMINISHING CAPACITY REPORT ("CHECKBOOK")
REGIONAL POTABLE WATER SYSTEM
DATA: Current as of February 3, 2021
Million Gallons per Day (MGD)
WATER
REGIONAL
5. 10.666
6a. 3.261
6b. 5.352
7a.SYSTEM AVAILABILITY BASED ON MAX. 3-DAY (Line 6a / Line 1b)7%
7b.SYSTEM AVAILABILITY BASED ON MAX. MONTH (Line 6b / Line 1b)11%
Million Gallons per Day (MGD)
WATER
REGIONAL
8a. 0.875
8b. 0.000
9a. 4.136
9b. 6.227
10a.SYSTEM AVAILABILITY BASED ON MAX. 3-DAY (Line 11a / Line 1b)9%
10b.SYSTEM AVAILABILITY BASED ON MAX. MONTH (Line 11b / Line 1b)13%
[1] Mar-19
[2] Mar-20
[3]
Line 2a: Mo-Yr of Max. 3-Day Since February 2011 =>
Line 2b: Mo-Yr of Max. Month Since February 2011 =>
Capacity requested by outstanding active BCC-approved PUD units, as documented in the most current GMD PUD Master List. Built-out, closed-out,
inactive, and discontinued PUD's are not included in line 5; only active PUD's are included. The outstanding PUD units are assumed to be developed
before PUD closeout. Level of service for future commitments is defined by the latest rate study.
Future Available Capacity (TDADD) (Line 6a + Line 8a + Line 8b)
Future Available Capacity (MADD) (Line 6b + Line 8a + Line 8b)
FUTURE AVAILABILITY WITH EXPANSIONS
FOOTNOTES/QUALIFIERS:
CURRENT AVAILABILITY WITH FUTURE COMMITMENTS
FUTURE AVAILABLE CAPACITY (WITH EXPANSIONS)
Expansions Within Next 12 Months (MADD)
Expansions Within Next 12-24 Months (MADD)
PROJECTED AVAILABLE CAPACITY (WITH FUTURE COMMITMENTS)
Total BCC-approved Active PUD commitments (Unbuilt per GMD PUD Master List) [3]
Projected Available Capacity (TDADD) (Line 3a - Line 5)
Projected Available Capacity (MADD) (Line 3b - Line 5)
2 of 8
NORTH SOUTH
1. 24.100 16.000
2a. 16.734 18.983
2b. 12.105 11.000
3a. 3.500 (3.500)
3b. 0.000 0.000
4a. 3.866 0.517
4b. 11.995 5.001
5a.SYSTEM AVAILABILITY BASED ON MAX. 3-DAY (Line 4a / Line 1)16% 3%
5b.SYSTEM AVAILABILITY BASED ON PERMIT (MAX. MONTH) (Line 4b / Line 1)50% 31%
CURRENT AVAILABILITY WITHOUT FUTURE COMMITMENTS
INTRODUCTION: The Checkbook uses the historical maximum 3-day average daily flow (TDADF) and monthly average daily flow (MADF) from the
last 10 years as baseline scenarios. Unbuilt future commitments are then multiplied by standard peaking factors and added to the baselines to arrive at worst-
case scenarios for future operational requirements.
CURRENT AVAILABLE CAPACITY (BASED ON HISTORICAL EXTREME EVENT)
Existing Permitted/Operational Plant Capacity per 2020 AUIR (TMADF)
10-Year Maximum TDADF [2]
10-Year Maximum MADF [3]
Current Available Diminishing Capacity (MADF) (Line 1 - Line 2b - Line 3b)
COLLIER COUNTY WATER - SEWER DISTRICT
SYSTEM UTILIZATION AND DIMINISHING CAPACITY REPORT ("CHECKBOOK")
REGIONAL WASTEWATER SYSTEM
DATA: Current as of February 3, 2021
Current Available Diminishing Capacity (TDADF) (Line 1 - Line 2a - Line 3a)
Peak Flow Diversion (TDADF) [5]
Peak Flow Diversion (MADF) [5]
Million Gallons per Day (MGD)
WASTEWATER [1]
3 of 8
COLLIER COUNTY WATER - SEWER DISTRICT
SYSTEM UTILIZATION AND DIMINISHING CAPACITY REPORT ("CHECKBOOK")
REGIONAL WASTEWATER SYSTEM
DATA: Current as of February 3, 2021
NORTH SOUTH
6. 2.822 4.143
7a. 4.120 (3.500)
7b. 0.363 0.000
8a. 0.425 (3.626)
8b. 8.810 0.858
9a.SYSTEM AVAILABILITY BASED ON MAX. 3-DAY (Line 8a / Line 1)2% -23%
9b.SYSTEM AVAILABILITY BASED ON PERMIT (MAX. MONTH) (Line 8b / Line 1)37% 5%
NORTH SOUTH
10a. 0.000 0.000
10b. 0.000 0.000
11a. 0.425 (3.626)
11b. 8.810 0.858
12a.SYSTEM AVAILABILITY BASED ON MAX. 3-DAY (Line 11a / Line 1)2%-23%
12b.SYSTEM AVAILABILITY BASED ON PERMIT (MAX. MONTH) (Line 11b / Line 1)37% 5%
PROJECTED AVAILABLE CAPACITY (WITH FUTURE COMMITMENTS)
FUTURE AVAILABILITY WITH EXPANSIONS
Peak Flow Diversion (MADF) [5]
Future Available Capacity (TDADF) (Line 8a + Line 10a + Line 10b)
Future Available Capacity (MADF) (Line 8b + Line 10a + Line10b)
CURRENT AVAILABILITY WITH FUTURE COMMITMENTS
FUTURE AVAILABLE CAPACITY (WITH EXPANSIONS)
Expansions Within Next 12 Months (MADF)
Expansions Within Next 12-24 Months (MADF)
Peak Flow Diversion (TDADF) [5]
Million Gallons per Day (MGD)
WASTEWATER [1]
WASTEWATER [1]
Million Gallons per Day (MGD)
Total BCC-approved Active PUD commitments (Unbuilt per GMD PUD Master List) [4]
Projected Available Capacity (TDADF) (Line 1 - Line 2a - Line 6 - Line 7a)
Projected Available Capacity (MADF) (Line 1 - Line 2b - Line 6 - Line 7b)
4 of 8
COLLIER COUNTY WATER - SEWER DISTRICT
SYSTEM UTILIZATION AND DIMINISHING CAPACITY REPORT ("CHECKBOOK")
REGIONAL WASTEWATER SYSTEM
DATA: Current as of February 3, 2021
[1] Wastewater North and South shown separately because of the finite capacity of the interconnect.
[2] Aug-17 Sep-20
[3] Feb-19 Sep-20
[4]
[5]
Capacity requested by outstanding active BCC-approved PUD units, as documented in the most current GMD PUD Master List. Built-out, closed-out,
inactive, and discontinued PUD's are not included in line 5; only active PUD's are included. The outstanding PUD units are assumed to be developed
before PUD closeout. Level of service for future commitments is defined by the latest rate study.
Wastewater flows can be diverted from the south service area to the NCWRF via the East and West Interconnects and associated pump station
improvements. The East Interconnect is an existing 20" force main along Santa Barbara Blvd that can divert flows from MPSs 312.00 and 313.00 to
MPS 104.00, which ultimately discharges to the NCWRF. The West Interconnect is a proposed 24" force main along Livingston Road that will divert
flows from MPSs 305.00, 309.00, and 310.00 ultimately to the NCWRF. The West Interconnect is being constructed in phases and will become
operational in FY 2022. Peak flows can be diverted to MPS 167.00 (Heritage Bay) by the 0.75 MGD OT master pump station and force mains along
Oil Well Road and Immokalee Road. MPS 167.00 will have the capability of diverting wastewater flows from the north and/or south service areas to
the future NEWRF. These interconnects provide the operational flexibility needed to manage the peak flows forecasted by the Checkbook.
FOOTNOTES/QUALIFIERS:
Line 2a: Mo-Yr of Max. 3-Day Since February 2011 =>
Line 2b: Mo-Yr of Max. Month Since February 2011 =>
5 of 8
NORTHEAST CENTRAL
1. 0.750 1.800
2a. 0.835 n/a
2b. 0.547 1.548
2c. 0.512 1.368
3a. (0.092) n/a
3b. (0.060) n/a
3c. (0.056) n/a
3d. 0.000 n/a
3e. 0.000 n/a
3f. 0.000 n/a
4a. 0.006 n/a
4b. 0.264 0.252
4c. 0.294 0.432
5a.SYSTEM AVAILABILITY BASED ON MAX. 3-DAY (Line 4a / Line 1)1%n/a
5b.SYSTEM AVAILABILITY BASED ON MAX. MONTH (Line 4b / Line 1)35% 14%
5c.SYSTEM AVAILABILITY BASED ON MAX. 3-MONTH (Line 4c / Line 1)39% 24%
Million Gallons per Day (MGD)
CURRENT AVAILABILITY WITHOUT FUTURE COMMITMENTS
Current Available Diminishing Capacity (MADF) (Line 1 - Line 2b - Line 3b - Line 3e)
Current Available Diminishing Capacity (TMADF) (Line 1 - Line 2c - Line 3c - Line 3f)
WASTEWATER
COLLIER COUNTY WATER - SEWER DISTRICT
SYSTEM UTILIZATION AND DIMINISHING CAPACITY REPORT ("CHECKBOOK")
SUB-REGIONAL WASTEWATER SYSTEMS
DATA: Current as of February 3, 2021
INTRODUCTION: The Checkbook uses the historical maximum 3-day average daily flow (TDADF), monthly average daily flow (MADF), and 3-month
average daily flow (TMADF) from the last 10 years as baseline scenarios. Unbuilt future commitments are then multiplied by standard peaking factors and
added to the baselines to arrive at worst-case scenarios for future operational requirements.
Twin Eagles Diversion (TDADF) (-0.11(Line 2a)) [4]
Twin Eagles Diversion (MADF) (-0.11(Line 2b)) [4]
Twin Eagles Diversion (TMADF) (-0.11(Line 2c)) [4]
Current Available Diminishing Capacity (TDADF) (Line 1 - Line 2a - Line 3a - Line 3d)
CURRENT AVAILABLE CAPACITY (BASED ON HISTORICAL EXTREME EVENT)
Existing Permitted/Operational Plant Capacity per 2020 AUIR (TMADF)
10-Year Maximum TDADF [1]
10-Year Maximum MADF [2]
10-Year Maximum TMADF [3]
Peak Flow Diversion (TDADF) (Line 1 - Line 2a - Line 3a) (-0.75 min., 0 max.) [6]
Peak Flow Diversion (MADF) (Line 1 - Line 2b - Line 3b) (-0.75 min., 0 max.) [6]
Peak Flow Diversion (TMADF) (Line 1 - Line 2c - Line 3c) (-0.75 min., 0 max.) [6]
6 of 8
COLLIER COUNTY WATER - SEWER DISTRICT
SYSTEM UTILIZATION AND DIMINISHING CAPACITY REPORT ("CHECKBOOK")
SUB-REGIONAL WASTEWATER SYSTEMS
DATA: Current as of February 3, 2021
NORTHEAST CENTRAL
6. 0.626 0.006
7a. (0.620) n/a
7b. (0.363) n/a
7c. (0.332) n/a
8a. 0.000 n/a
8b. 0.000 0.246
8c. 0.000 0.426
9a.SYSTEM AVAILABILITY BASED ON MAX. 3-DAY (Line 8a / Line 1)0%n/a
9b.SYSTEM AVAILABILITY BASED ON MAX. MONTH (Line 8b / Line 1)0% 14%
9c.SYSTEM AVAILABILITY BASED ON MAX. 3-MONTH (Line 8c / Line 1)0% 24%
NORTHEAST CENTRAL
10a. 0.000 0.000
10b. 0.000 0.000
11a. 0.000 n/a
11b. 0.000 0.246
11c. 0.000 0.426
12a.SYSTEM AVAILABILITY BASED ON MAX. 3-DAY (Line 11a / Line 1)0%n/a
12b.SYSTEM AVAILABILITY BASED ON MAX. MONTH (Line 11b / Line 1)0% 14%
12c.SYSTEM AVAILABILITY BASED ON MAX. 3-MONTH (Line 11c / Line 1)0% 24%
Million Gallons per Day (MGD)
Million Gallons per Day (MGD)
Expansions Within Next 12 Months (TMADF)
Expansions Within Next 12-24 Months (TMADF)
Peak Flow Diversion (TDADF) (Line 1 - Line 2a - Line 3a - Line 6) (-0.75 min., 0 max.) [6]
Peak Flow Diversion (MADF) (Line 1 - Line 2b - Line 3b - Line 6) (-0.75 min., 0 max.) [6]
Peak Flow Diversion (TMADF) (Line 1 - Line 2c - Line 3c - Line 6) (-0.75 min., 0 max.) [6]
Future Available Capacity (TDADF) (Line 8a + Line 10a + Line 10b)
Future Available Capacity (MADF) (Line 8b + Line 10a + Line10b)
Future Available Capacity (TMADF) (Line 8c + Line 10a + Line 10b)
FUTURE AVAILABILITY WITH EXPANSIONS
FUTURE AVAILABLE CAPACITY (WITH EXPANSIONS)
Projected Available Capacity (TMADF) (Line 1 - Line 2c - Line 3c - Line 6 - Line 7c)
CURRENT AVAILABILITY WITH FUTURE COMMITMENTS
WASTEWATER
PROJECTED AVAILABLE CAPACITY (WITH FUTURE COMMITMENTS)
Total BCC-Approved, Active PUD Commitments (Unbuilt per GMD PUD Master List) [5]
Projected Available Capacity (TDADF) (Line 1 - Line 2a - Line 3a - Line 6 - Line 7a)
Projected Available Capacity (MADF) (Line 1 - Line 2b - Line 3b - Line 6 - Line 7b)
WASTEWATER
7 of 8
COLLIER COUNTY WATER - SEWER DISTRICT
SYSTEM UTILIZATION AND DIMINISHING CAPACITY REPORT ("CHECKBOOK")
SUB-REGIONAL WASTEWATER SYSTEMS
DATA: Current as of February 3, 2021
[1] Sep-17 n/a
[2] Sep-17 Aug-17
[3] Oct-17 Sep-16
[4]
[5]
[6]Peak flows and effluent will be diverted to the NCWRF by the 0.75 MGD OT pump station and Oil Well Road force main; Heritage Bay master pump
station; and new and existing force mains along Oil Well Rd, Immokalee Rd, Logan Blvd, Vanderbilt Beach Rd, and Goodlette-Frank Rd.
Line 2b: Mo-Yr of Max. Month per Available Data Since February 2011 =>
Line 2c: Mo-Yr of Max. 3-Month per Available Data Since February 2011 =>
The sub-regional Northeast Utility Facilities (former OTU) previously served all customers in the Orange Tree and Orange Blossom Ranch PUDs as
well as the Twin Eagles subdivision, but flow from Twin Eagles was diverted to the NCWRF wastewater collection/transmission system in May 2019.
Since the historical max. wastewater flows occurred prior to any services being transferred, values are reduced by eleven percent (11%) based on
billing data from September 2017, the month in which the maximums occurred.
Line 2a: Mo-Yr of Max. 3-Day per Available Data Since February 2011 =>
Capacity requested by outstanding active BCC-approved PUD units, as documented in the most current GMD PUD Master List. Built-out, closed-out,
inactive, and discontinued PUD's are not included in line 5; only active PUD's are included. The outstanding PUD units are assumed to be developed
before PUD closeout. Level of service for future commitments is defined by the latest rate study.
FOOTNOTES/QUALIFIERS:
8 of 8