HomeMy WebLinkAbout5 - Preliminary 2011 Utilities Budget
CITY OF BOULDER
WATER RESOURCES ADVISORY BOARD
AGENDA ITEM
MEETING DATE: May 17, 2010
AGENDA TITLE: Staff Presentation and Discussion of the Preliminary 2011 Utilities Budget
(Water, Wastewater and Stormwater/ Flood Management) including the 6-year Capital
Improvement Program (CIP), Monthly Utility Rates and the six-year Utility Fund Financials.
PRESENTERS:
Ned Williams, Director of Public Works for Utilities
Bob Harberg, Utilities Planning & Project Management Coordinator
Carol Linn, Utilities Financial Manager
EXECUTIVE SUMMARY:
As part of the city's annual budget process, Utilities develops a six-year planning budget, this
year for the time period of 2011 through 2016. Utilities staff has formulated initial revenue and
expenditure projections for each of the three utility funds through the year 2016. Within the
budget process Council approves and appropriates funds only for the first year, 2011.
This packet contains information concerning the Preliminary 2011 Utilities Budget and the draft
2011-2016 Utilities Capital Improvement Program (CIP). The attached fund financials
(Attachment B - Water Utility, Attachment C - Wastewater Utility and Attachment D -
Stormwater / Flood Management Utility) reflect actual revenues and expenditures for 2009,
updated revenue projections/rate increases for the planning period (this includes the phased-in
implementation of the adopted Plant Investment Fees), updated CIP and any proposed budget
supplementals (additions to the current budget). The operating budget (i.e. personnel costs,
chemicals, energy, etc.) and transfers will be updated and incorporated into the fund financials
later in May after the city's budget guidelines have been distributed.
At the May 17, 2010 WRAB meeting, staff will ask WRAB for input and feedback on the 2011-
2016 CIP and preliminary revenue increases for 2011. Staff will return to the Board on June
21st for further discussion and to solicit a recommendation to Planning Board and City Council
concerning the proposed 2011 Utilities Division budget and 2011-2016 CIP.
Fiscal Impacts: The following percentage increases in additional revenue from the monthly
utility fees are currently being considered by staff for 2011 to fund the preliminary Utilities
budget and capital improvements program.
Water 4%
Wastewater 3%
Stormwater/ Flood Management 3%
Page 1
Board Feedback: Staff is asking that WRAB review the 2011-2016 CIP and preliminary 2011
budget and CIP and provide feedback to staff.
Public Feedback: Board input and a public hearing is scheduled for this meeting. A public
hearing and recommendation is also scheduled for June 21, 2010. At that time, staff will request
that the WRAB provide a final recommendation concerning the proposed 2011-2016 CIP to
Planning Board and City Council.
BACKGROUND:
The Utilities Division's mission is to provide quality water services, as desired by the
community, in a manner which emphasizes efficient management of fiscal and natural resources,
and protects human and environmental health. Each of the city's three utilities (water,
wastewater and stormwater/flood management) is a separate enterprise fund established to
finance and account for the acquisition, operation and maintenance of each utility's facilities and
services while maintaining designated reserves and meeting debt service requirements. The
utility funds receive the majority of their revenues from the monthly utility charges
Revenues generated from the monthly utility bill are the largest source/revenue for each utility.
Other significant sources of funds include development fees (plant investment fees),
hydroelectric revenues, funding from the Urban Drainage and Flood Control District (UDFCD)
and interest earnings.
The majority of the utilities expenditures are for rehabilitating and improving our capital
infrastructure either through the capital improvements program (cash financed) or through
annual debt payments for revenue bonds that have been issued to fund capital improvements.
The infrastructure is core in carrying out the utilities' mission of delivering safe and reliable
water to our customers and ensuring that water is available for fire protection. Other significant
uses of funds include water treatment operations, wastewater treatment operations, system
maintenance and water quality operations.
For 2010, uses of funds exceed sources in all utilities. This is largely attributed to the 2010
capital improvement program and the difference is paid for from each utility's available fund
balance. The fund balance is the amount available after funding all appropriated expenditures
and reserve targets.
Attachment A provides graphs that summarize the 2010 adopted budget for sources and uses of
funds for each utility. These charts do not reflect the bond proceeds or debt service associated
with the bond for wastewater treatment plant improvements (ultra-violet disinfection, digester
and headworks improvements) that is anticipated to be issued later this year. Those dollars will
be appropriated at the time of the bond issuance.
REVENUES:
The preliminary 2011 budget reflects the following revenue increases: 4% Water, 3%
Wastewater, and 3% Stormwater/Flood Management. These are the same increases that were
projected for 2011 during the 2010 budget process. The following table summarizes the 2010
Page 2
adopted increase and preliminary projections for 2011-2013. The preliminary 2011 increases are
in bold.
2010 2011 2012 2013
Water 0% 4% 4% 3%
Wastewater 0% 3% 4% 4%
Stormwater/Flood Management 0% 3% 3% 3%
The revenue increase represents the amount of additional revenue to be generated from the
monthly utility charges. The actual rate increase (e.g. $ per 1,000 gallons) may or may not be
equal to the revenue increase depending on whether any changes in consumption or use are
factored in when calculating the actual rates. For example when there is an established or
projected decrease in consumption, in order to generate 3% more revenue from last year's
budget, monthly rates may need to increase greater than 3% to generate the needed revenue
requirements.
The preliminary 2011 revenue increases represents an inflationary increase to cover projected
personnel expenses, increases to nonpersonnel items such as chemicals, power and other
purchased materials.
Staff is planning to check in with Council at the May 25t1i budget study session to see whether
Council is supportive of considering the preliminary utility revenue increases for 2011. Given
the current economic environment Council may want staff to also evaluate 0% revenue increases
for 2011 or something less than 4%-3%-3%.
In addition, revenue projections for Plant Investment Fees have been revised downward in all
three utilities to reflect decreased development activity. These revisions are reflected in the fund
financials.
CUSTOMER BILL IMPACT:
The proposed 2011 revenue increases (4%-3%-3%) would increase a typical residential
customer's annual utility bill by approximately $25.00, or an increase of approximately $2.10
per month. The following table provides a breakdown of the proposed increases by utility.
Annual Bill Annual Bill Annual
2010 Rates 2011 Rates Difference
Water $363.85 $378.88 $15.03
Wastewater $239.52 $246.48 $6.96
Stormwater/ Flood Mgmt $85.20 $87.72 $2.52
Total $688.57 $713.08 $24.51
BUDGET SUPPLEMENTAL REQUESTS AND ANTICPATED BONDS:
The 2011 preliminary budget includes one operating budget supplemental in the water utility. It
Page 3
provides for $17,300 to pay a portion of the Nederland Wastewater Treatment Facility Operating
costs, given that certain treatment levels are maintained as outlined in the Intergovernmental
Agreement with Nederland. This is an ongoing budget supplemental request and would be
funded as part of the preliminary revenue increases.
The 2011-2016 utility fund financials also reflect several bond issuances (and associated debt
payments) to fund the following capital projects:
Water:
1. Betasso Water Treatment Plant Improvements ($8.2 million in 2016) to fund
improvements to the Betasso WTP to assure compliance with federal Safe Drinking
Water Act regulations.
Wastewater:
1. No bonds are anticipated in the 2011-2016 planning period. However, a bond will be
issued in 2010 ($9.4 million) to fund improvements to the WWTP including ultraviolet
disinfection, biosolids digesters and headworks facilities.
Storm-,eater and Flood Management:
1. South Boulder Creek Improvements ($3.0 million in 2012) to fund improvements
designed to mitigate flood hazards in the South Boulder Creek West Valley area.
The following table summarizes the debt obligations of the utilities, the year the debt is retired
and the average annual debt payment. Items shown in italics are projects that are anticipated to
be funded b issuing bonds.
Year Debt Approximate Annual
utility Projects is Retired Debt Payment
Water Boulder Reservoir WTP Imp 2016 $855,000
Multiple Projects including Silver 2019 $2,500,000
Lake Pipeline, Barker Purchase
Lakewood Pipeline 2021 $2,180,000
Betasso WTP Imp. (2016) 2036 $790,000
Wastewater Marshall Landfill 2012 $170,000
WWTP Improvements 2025 $3,500,000
UV Disin ection (2010) 2030 $395,000
Biosolids Digester (2010) 2030 $356,000
Headworks Imp. (2010) 2030 $94,000
Storm/Flood Multiple projects including Goose 2018 $490,000
Creek Improvements
South Boulder Creek Imp. (2012) 2032 $294, 000
* The existing bond in the stormwater/flood management fund is in the process of being
refinanced. This will result in annual savings of approximately $105,000 in debt payments. The
water utility also pays a portion of the Northern Colorado Water Conservancy District's debt
related to the Windy Gap project. This debt will be retired in 2017 and Boulder's annual debt
Page 4
payment is approximately $1,650,000.
STAFFING LEVELS:
The Utilities Division currently has 155.90 budgeted full -time equivalent (FTE) employees.
There are 75.13 that support the water utility; 58.91 in wastewater; 21.06 in stormwater/flood
management and .80 in transportation (transportation contributes to storm sewer maintenance).
A listing of FTEs and positions by workgroup is included in Attachment E. There are no
additional FTEs being requested for 2011.
As vacancies occur there is an ongoing effort to analyze and evaluate staffing level efficiencies
by the city-wide staffing committee review. As analyses are completed and information about
the positions are reviewed, decisions will be made about the need to fill vacant positions (in
2010 or 2011) or whether to eliminate positions.
HIGHLIGHTS AND MAJOR PROPOSED CHANGES FROM THE 2010-2015 CIP:
Because of decreases in construction costs during 2009 and 2010, cost estimated pegged to 2008
dollars are not escalated through the 2008-2013 time period. It is assumed that beginning in
2013, construction costs will escalate at 3 percent per year.
Water:
1. Funding for the next phase of improvements to the Betasso Water Treatment Facility
(WTF) has been scheduled for the 2015-2016 time period. Water demands have not
increased significantly and the existing treatment processes should be adequate to meet
water demands in compliance with federal Safe Drinking Water Act regulations until that
time.
2. Funding for annual waterline replacement continues at a rate of $2,100,000 in 2008
dollars. This should be sufficient to maintain the current service level, as defined by
water main breaks, over the next decade. The replacement program is coordinated with
the Transportation Division street overlay and reconstruction program.
3. Funds have been budgeted in 2014 for inspection of the Lakewood Pipeline. Based on
observations made during the 2009 inspection it is recommended that the frequency of
inspections be reduced to one every five years. No funds have been budgeted for pipeline
repair costs. Funds would be transferred from the Lakewood Pipeline Remediation
Reserve to cover the costs.
4. Barker Gravity Pipeline is a critical component of the city's source water system because
it conveys the city's Barker Reservoir/Middle Boulder Creek water to Betasso WTF.
Funds have been budgeted for annual, on-going repair and rehabilitation work on the
pipeline and a report on the overall condition along with future repair recommendations
will be available in late 2010.
5. Funding for construction of the proposed Carter Lake Pipeline has been schedule for the
2016-2017 time period. Funding of the pipeline in the near term without federal funding
Page 5
assistance would have a significant impact on water rates. Staff continues to recommend
the pipeline as the best long-term solution to water quality, operational and security
vulnerability issues related to drawing water directly from the Boulder Feeder Canal and
Boulder Reservoir.
Wastewater;
1. Funding for the annual Sanitary Sewer Rehabilitation projects has been reduced to a rate
of $450,000 in 2008 dollars. This should be sufficient to maintain the current service
level, over the next decade.
2. Although Colorado Department of Public Health and Environment (CDPHE) may
include additional regulatory limits for nitrate and Total Inorganic Nitrogen (TIN) in the
impending 2010 permit renewal, staff is not recommending budgeting money for
treatment improvements at this time. If the city receives nitrate and TIN limits in the
2010 permit, city staff would attempt to negotiate a compliance schedule with CDPHE
that considers the city's current budget limitations. At this time it is not clear what
additional facilities would be required as a result of the 2010 permit requirements.
Although funding for future discharge permit-driven projects at the WWTP are not
included in this preliminary CIP, funds for evaluation and planning associated with the
permit are included in 2015.
Stormwater and Flood Management:
1. City Council selected a flood mitigation plan for Wonderland and Fourmile Canyon
Creek in late 2010. High priority projects are defined for areas along Wonderland Creek
between Foothills Parkway and 28th St. (including underpasses at the Burlington
Northern & Santa Fe Railway, Boulder White Rocks Ditch and 28th St.) and along
Fourmile Canyon Creek in the area of Crestview Elementary school (including
underpasses at Upland and 19th Streets.) Funding is recommended in 2011-2016 for these
projects and will be coordinated under the city's Greenways Program.
2. Funding is recommended for improvements designed to mitigate South Boulder Creek
flood hazards. It is anticipated that the focus of the mitigation work will be to mitigate the
impacts of flooding in the West Valley, where flood impacts were previously not
identified and substantial urban development has since occurred. It is also important that
flood mitigation planning be coordinated with the U.S. 36 Corridor Improvements-
Environmental Impact Statement. The city has initiated a flood mitigation alternatives
analysis and initial results should be available later this year.
BUDGET SCHEDULE:
The current schedule of major budget milestones is provided below. Elements involving the
WRAB are highlighted in bold italics.
Page 6
Milestone Date
Capital Projects Information Sharing Meeting April 15, 2010
Draft CIP Proposal Submitted May 7, 2010
Preliminary WRAB Budget Discussion May 17, 2010
City Council Study Session on Budget May 25, 2010
Proposed Budget Submittal to City Manager June 18, 2010
WRAB Recommendation on CIP/Budget June 21, 2010
Departmental Budget Review by City Manager June 18-July 16, 2010
CIP Submitted to Planning Board June 22, 2010
Planning Board CIP Hearing July 15, 2010
City Council Study Session on Budget (CIP) July 27, 2010
City Council Study Session on Budget Aug. 24, 2010
City Council Study Session on Budget (if needed) Sept. 14, 2010
City Council Consideration/Adoption of Budget Oct. 5 and 19, 2010
NEXT STEPS:
Staff is seeking feedback on the preliminary CIP and revenue increases being considered. Staff
will return to the WRAB's June 21 meeting with updated financial information that incorporates
the city's 2011 Budget Guidelines and input from WRAB. At the June 21 WRAB meeting, staff
will request that the WRAB provide a final recommendation concerning the proposed 2011-2016
CIP to Planning Board and City Council.
Attachments:
A: 2010 Sources and Uses of Funds Graphs
B: Water - Fund Financial and Capital Improvement Program
C: Wastewater - Fund Financial and Capital Improvement Program
D: Stormwater/ Flood Management - Fund Financial and Capital Improvement Program
E: Staffing Levels by Program
Page 7
Attachment A
Water Utility:
2010 Sources of Funds
$25,225,618
Utility Service
Charges
$20,290,018
81%
Hydroelectric
Revenues
$1,890,000
Interest/Other Development 7%
$795,600 Fees
3% $2,250,000
9%
2010 Uses of Funds
$26,727,340
Water Debt & Windy Gap
Quality& Maintenance Payment
Conservation $3,181,785 $8,751,843
$1,261,073 12% 33%
5%
Water
Treatment
$4,267,303
16%
Transfers
Water $1,322,005
Resources Capital 5%
$1,978,143 Engineering improvements
$563,365 Administration
7% $960,458 $4,441,365
2% 3% 17%
Attachment A
Wastewater Utility:
2010 Sources of Funds
$14,356,067
Uti I ity Se rvi ce
Charges
$13,505,078
94%
Development
Fees
Interest $610,000
Other $206,489
Revenues 2% 4%
$34,500
0%
2010 Uses of Funds
$14,711,806
Capital
Improvements Administration Engineering
Transfers $911,540 $600,043 $341,929
0
$991,534 6/° 4%
70%
Wastewater
Treatment
$5,385,984
37%
Debt
$3,722,038
25%
Maintenance
$1,682,120 Wastewater
12% Quality
$1,076,618
7%
Attachment A
Stormwater/Flood Management Fund:
2010 Souces of Funds
$6,235,622
Utility Service
Charges
S4,966,949
80%
Other Keep It Clean Development
$36,000 Interest
Program $97,673 Fees
1 % $135,000 2% UDFCD Reimb $600,000
1% $400,000 10%
6%
2010 Uses of Funds
$6,318,255
Capital Administration
Improvements $454,335
$1,681,090 7%
27%
Transfers Engineering
$324,667 $996,697
5% 16%
Stormwater
Contract
Debt Management
$1,126,036 Maintenance Stormwater $48,473
18% $724,403 Quality 1%
11% $962,554
15%
I
Attachment B-1
A B C D E F G H I J K L M N O P Q R
CITY OF BOULDER 10-May-10
2011 FUND FINANCIAL - Draft -
WATER UTILITY FUND
2009 2010 2011 2012 2013 2014 2015 2016
ACTUAL REVISED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED
UNAPPROPRIATED FUND BALANCE
Beginning of Year Fund Balance $47,717,619 $42,701,853 $28,553,747 $26,679,916 $27,956,236 $29,025,989 $31,400,099 $33,233,180
-IT SOURCES OF FUNDS
Operating--
21 Sale of Water to General Cust $17,757,975 $20,171,468 $20,211,608 $21,061,909 $21,947,992 $22,651,441 $23,377,443 $24,126,721
Projected Rate Increase $0 8% $0 0% $808,464 4% $842,476 4% $658,440 3% $679,543 3% $701,323 3% $723,802 3%
Bulk/Irrigation Water Sales $127,566 $123,600 $120,700 $123,700 $120,800 $123,800 $125,800 $125,800
Hydroelectric Revenue $2,230,379 $1,890,000 $2,151,000 $2,151,000 $2,304,000 $2,304,000 $2,304,000 $2,304,000
Miscellaneous Operating Revenues $55,065 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
TOTAL OPERATING SOURCES OF FUNDS $20,170,985 $22,210,068 $23,316,772 $24,204,086 $25,056,231 $25,783,784 $26,533,567 $27,305,323
fg-
Non-Operating--
Plant Investment Fees $2,954,080 $2,100,000 $2,100,000 $2,100,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000
21 Connection Charges $135,122 $150,000 $150,000 $150,000 $165,000 $165,000 $165,000 $165,000
Special Assessments $2,474 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
State & Federal Grants $0 $1,180,000 $0 $0 $0 $0 $0 $0
Interest on Investments $1,369,016 $654,815 $556,798 $666,998 $838.687 $870,780 $942,003 $996,995
Rent. assessments and other misc revenues $231,568 $18,000 $18,500 $19,000 $19,500 $20,000 $20,500 $20,500
Sale of Real Estate - Yards Masterplan $0 $250,000 $0 $0 $0 $0 $0 $0
Transfer from General Fund - Fire Training Centel $92,785 $92,785 $92,785 $92,785 $92,785 $92,785 $92,785 $92,785
Projected Bond Proceeds $0 $0 $0 $0 $0 $0 $0 $9,065,000
TOTAL NON-OPERATING SOURCES OF FUNDS $4,785,045 $4,450,600 $2,923,083 $3,033,783 $3,620,972 $3,653,565 $3,725,288 $12,845,280
TOTAL SOURCES OF FUNDS $24,956,030 $26,660,668 $26,239,855 $27,237,869 $28,677,203 $29,437,349 $30,258,855 $40,150,603
USES OF FUNDS
Operating Expenditures--
Administration $821,332 $860,458 $886,272 $912.860 $940,246 $968,453 $997,507 $1,027,432
Planning and Project Management $439,506 $563,365 $580,266 $597,674 $615,604 $634,072 $653,094 $672,687
Water Resources and Hydroelectric Operations $2,044,449 $1,978,143 $2,037,487 $2,098,612 $2,161,570 $2,226,417 $2,293,210 $2,362,006
Water Treatment $4,003,864 $4,267,303 $4,395,322 $4,527,182 $4,662,997 $4,802,887 $4,946,974 $5,095,383
Water Quality & Environmental Svcs $797,293 $869,198 $895,274 $922,132 $949,796 $978,290 $1,007,639 $1,037,868
Water Conservation $251,389 $391,875 $403,631 $415,740 $428,212 $441,059 $454,291 $467,919
41 System Maintenance $2,678,353 $3,181,785 $3,277,239 $3,375,556 $3,476,822 $3,581,127 $3,688,561 $3,799,218
Windy Gap Payment $2,322,398 $2,479,532 $2,580,539 $2,523,910 $2,546,836 $2,593,250 $2,716,004 $2,795,959
Nederland WWTP Operations $0 $0 $17,300 $17,819 $18,354 $18,904 $19,471 $20,055
SickNacation Accrual ($3,905) $100,000 $103,000 $106,090 $109,273 $112,551 $115,927 $119,405
45- TOTAL OPERATING USES OF FUNDS $13,354,679 $14,691,659 $15,176,330 $15,497,575 $15,909,710 $16,357,011 $16,892,678 $17,397,933
2rr Debt--
BRWTP 1996 Revenue Bond; Refunding in 2005 $843,810 $844,505 $848,752 $854,690 $854,438 $856,594 $857,709 $858,531
48
49- Refunding of the 1999 and 2000 Revenue Bonds $3,257,654 $3,253,354 $2,507,921 $2,506,088 $2,511,421 $2,523,521 $2,522,054 $2,517.388
Lakewood Pipeline 2001 Revenue Bond $2,180,202 $2,174,452 $2,171,885 $2.172,302 $2,175,502 $2,176,142 $2,182,416 $2,183.781
Arbitrage Payment ($2,408) $0 $0 $0 $0 $0 $0 $0
Projected Bond-Betasso WTP Improvements $0 $0 $0 $0 $0 $0 $0 $790.480
TOTAL DEBT SERVICE $6,279,258 $6,272,311 $5,528,558 $5,533,080 $5,541,361 $5,556.257 $5,562,179 $6,350,180
Transfers Out-
_W Cost $1,133.776 $1,118,145 $1,229,960 $1,352,955 $1,488,251 $1,637,076 $1,800,784 $1,980,862
57 Planning & Development Services $183,359 $188,860 $194,526 $200,361 $206,372 $212,563 $218,940 $225,508
Other Transfers $15,000 $15,000 $15,450 $15,914 $16,391 $16,883 $17,389 $17,911
TOTAL TRANSFERS OUT $1,332,135 $1,322,005 $1,439,935 $1,569,230 $1,711,014 $1,866,522 $2,037,113 $2,224,281
Capital Improvements Program--
62 CAPITAL USES OF FUNDS $9,001,819 $4,441,365 $6,071,864 $3,467,754 $4,554,637 $3,396,000 $4,049,731 $7,699,526
PROJECTED BOND - BETASSO WTP IMP $0 $0 $0 $0 $0 $0 $0 $8,195,453
PROJECTED BONDS - ISSUANCE COSTS $0 $0 $0 $0 $0 $0 $0 $100,000
ENCUMBRANCES, CARRYOVERS & MID-YR ATB's $0 $14,181,434 $0 $0 $0 $0 $0 $0
TOTAL USES OF FUNDS $29,967,891 $40,908,774 $28,216,686 $26,067,639 $27,716,723 $27,175,790 $28,541,701 $41,967,373
Sick/Vacation Accrual Adjustment ($3,905) $100,000 $103,000 $106,090 $109,273 $112,551 $115,927 $119,405
-TT
FUND BALANCE - END OF YEAR $42,701,853 $28,553,747 $26,679,916 $27,956,236 $29,025,989 $31,400,099 $33,233,180 $31,535,816
Designated Reserves -
Bond Reserves $3,068,830 $3,068,830 $3,068,830 $3,068,830 $3,068,830 $3,068,830 $3,068,830 $3,859,310
Lakewood Pipeline Remediation Reserve $16,593,356 $12,737,271 $13,124,687 $13.989,878 $14,881,385 $15,538,621 $16,477,235 $17,444,397
Lakewood/USFS Damage Claims Reserve $100,000 $100,000 $100,000 $100,000 $0 $0 $0 $0
Vacation/Sick/Bonus Liability $643,997 $663.317 $683,216 $703,713 $724,824 $746,569 $768,966 $792,035
Pay Period 27 - 2013 Reserve $130,443 $181.443 $232,443 $283,443 $334,443 $385,443 $436,443 $487,443
TOTAL RESERVES 520,536,626 $16,750.861 $17,209,177 $18.145.864 $19,009,483 $19,739,463 $20.751,474 $22,583,185
SURPLUS!(DEFICIT) vs. DESIGNATED RESERVE $22,165,227 $11,802,886 $9,470,740 $9,810,371 $10,016,507 $11,660,636 $12,481,707 $8,952,631
OPERATING RESERVE (Goal: 25% of Operating) $3,671,704 $4,003,416 $4,154,066 $4,266,701 $4,405,181 $4,555,883 $4,732,448 $4,905,554
CAPITAL RESERVE (Goal: $2,000,000) $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000
SURPLUS!(DEFICIT) vs. ALL RESERVES $16,493,524 $5,799,470 $3,316,673 $3,543,670 $3,611,325 $5,104,753 $5,749,259 $2,047,078
Reserve levels are based on industry standards and are maintained for revenue bonds, revenue fluctuations (weather and water usage impacts) and the capital intensive nature of
the utilit,.
Attachment B-2
A B C D E F G H I J K
CITY OF BOULDER 10-May-10
2011-2016 CAPITAL IMPROVEMENT PROGRAM
WATER UTILITY FUND
Assumed Inflation Rate 3.00% ESTIMATED 2009 2010 2011 2012 2013 2014 2015 2016
PROJECT NAME 2008 COST ACTUAL REVISED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED
Treated Water Pressure Reducing and Hydroelectric Facilities
Maxwell Hydro/PRV Station 411342 $0 $0 $0 $0 $0 $0 $0 $D
Kohler Hydro/PRV Station 411376 $0 $0 $0 $0 $0 $0 $0 $0
Sunshine Hydro/PRV Station 411328 $0 $0 $0 $0 $0 $0 $0 $0
Orodell Hydro/PRV Station 411331 $0 $0 $0 $0 $0 $0 $0 $0
Sunshine Hydro/PRV Station 411347 $0 $0 $0 $0 $0 $0 $0 $0
Pearl Street Hydro/PRV Station $200,000 $0 $0 $0 $0 $0 $0 $0 $0
Treated Water Pressure Reducing and Hydroelectric Facility Rehabilita- $0 $0 $0 $0 $0 $0 $0 so
Subtotal - Treated Water PRV and Hydro $0 $0 $0 $0 $0 $0 $0 $0
18
Water Treatment Facilities
Betasso WTP 411947 $71,697 $200,000 $200,000 $100,000 $100,000 $100,000 $819,545 $0
Betasso WTP - Bond Proceeds $7,500,000 $0 $0 $0 $0 $0 $0 $0 $8,195,453
Bond Issuance Costs $0 $0 $0 $0 $0 $0 $0 $100,000
Boulder Reservoir WTP 411652 $3,000,000 $1,163,461 $2,226,985 $0 $0 $0 $0 $0 $0
Boulder Res WTP - Bond Proceeds $0 $0 $0 $0 $0 $0 $0 $0
Subtotal - Water Treatment Facilities $1,235,158 $2,426,985 $200,000 $100,000 $100,000 $100,000 $819,545 $8,295,453
27 Treated Water Pump Stations
Cherryvale Pump Station 411010 $500,000 $185,382 $318,228 $0 $0 $0 $0 $0 $0
Boulder Reservoir High Service Pump Station 411011 $0 $0 $0 $0 $0 $0 $0 $O
Iris Pump Station 411012 $1,000,000 $869,101 $85,710 $0 $0 $0 $0 $0 $0
Treated Water Pump Station Rehabilitation $0 $0 $0 $0 $0 $0 $0 $0
32 Subtotal - Treated Water Pump Stations $1,054,483 $403,938 $0 $0 $0 $0 $0 $0
Treated Water Storage Tanks
Kohler Storage Tank 411671 $920,000 $0 $0 $0 $0 $0 $0 $100,531 $1,005,309
Chautauqua Storage Tank 411672 $785,000 $2,400 $85,779 $785,000 $0 $0 $0 $0 SO
Maxwell Storage Tank 411673 $920,000 $0 $0 $0 $0 $0 $0 $0 $0
Betasso Storage Tank $250,000 $0 $265,225 $0 $0 $0 $0 $0 $0
39 Gunbarrel Storage Tank 411670 $250,000 $1,759 $32,136 $0 $0 $250,000 $0 $0 $0
Devil's Thumb Storage Tank 411674 $350,000 $8,871 $0 $0 $0 $0 $0 $0 $0
Boulder Reservoir Storage Tank $0 $0 $0 $0 $0 $0 $0 SO
42 Booten Storage Tank $0 $0 $0 $0 $0 $0 $0 SO
Treated Water Storage Tank Rehabilitation $0 $0 $0 $0 $0 $0 $0 s0
44 Subtotal - Treated Water Storage Tanks $13,030 $383,140 $785,000 $0 $250,000 $0 $100,531 $1,005,309
45
Treated Water Distribution System
Zone Isolation Valves 411390 $0 $1,460 $0 $0 $0 $0 $0 SO
48 Cathodic Protection 411387 $67,930 $132,070 $0 $0 $0 $0 $0 $0
Waterline Replacement 411389 $2,156,236 $3,476,821 52,100,000 $27100,000 $2,100.000 $2,163,000 $2.227,890 $2,294727
Subtotal -Treated Water Distribution System $2,224,166 $3,610,351 $2,100,000 $2,100,000 $2,100,000 $2,163,000 $2,227,890 $2,294,727
51
Treated Water Transmission System
Boulder Canyon - Fourmile to Pearl 411666 $0 $0 $0 $0 $0 $0 $0 $0
54 Sunshine Transmission Pipe 411006 $800,000 $12,385 $267,615 $0 $0 $800,000 $0 $0 $0
Betasso to Orodell Transmission Pipe $0 $0 $0 $0 $0 $0 $0 $0
Zone 1 Transmission Facilities 411002 $500,000 $0 $0 $0 $0 $0 $0 $0 $546,364
57 Zone 2 Transmission Facilities 411004 $500,000 $0 $0 $0 $0 $0 $0 $0 $0
Zone 3 Transmission Facilities 411005 $500,000 $0 $0 $0 $0 $0 $515,000 $0 $0
Boulder Canyon - Orodell to Fourmile $500,000 $0 $0 $500,000 $0 $0 $0 $0 SO
60 Zone 2 /Zone 3 Pressure Modifications 411003 $0 $0 $0 $0 $0 $0 SO
61 Subtotal - Treated Water Transmission System $12,385 $267,615 $500,000 $0 $800,000 $515,000 $0 $546,364
62
63 Source Water Transmission System
_BT Lakewood Pipeline 411780 $142,552 $311,007 $0 $0 $0 $257,500 $0 $0
65 Lakewood Pipeline - Non-Conforming Pipe Cap 411788 $0 $0 $0 $0 $0 $0 $0 $0
66 Lakewood Pipeline - Non-Conforming Pipe Ope 411790 $0 $0 $0 $0 $0 $0 $0 $0
_BT Lakewood Pipeline Welds 411792 $0 $0 $0 $0 $0 $0 $0 $0
68 Lakewood Pipeline Settlement/ Litigation 411795 $0 $0 $0 $0 $0 $0 $0 $0
69 Silver Lake Pipeline 411640 $0 $0 $0 $0 $0 $0 $0 $0
Source Water Transmission Pipe Inspections 411775 $0 $0 $0 $80,000 $0 $0 $0 $0
71 Subtotal - Source Water Transmission System $142,552 $311,007 $0 $80,000 $0 $257,500 $0 $0
72
Barker Water System
74 Barker Gravity Pipeline Repair 411106 $20,000,000 $294,003 $491,293 $350,000 $350,000 $350,000 $360,500 $371,315 $382,454
75 Barker-Kossler Penstock Repair 411107 $100,000 $0 $0 $0 $175,000 $0 $0 $0 SO
Barker Dam Outlet 411109 $0 $0 $0 $0 $0 $0 $0 SO
77 Barker Dam Outlet - Bond Proceeds $7,055,000 $0 $0 $0 $0 $0 $0 $0 SO
78 Barker Dam and Reservoir 411110 $350,000 $0 $0 $120,000 $0 $0 $0 $371,315 SO
Barker Hydro System Integration 411111 $647 $0 $0 $0 $0 $0 $0 $0
80 Barker Relicensing 411112 $65,162 $969,028 $0 $0 $0 $0 $0 $253,354
81 Barker Instream Flow Release 411114 $4,944 $148,005 $0 $0 $0 $0 $0 $0
_BT Betasso Penstock 411940 $2,916,746 $74,150 $0 $0 $0 $0 $0 SD
83 Barker Source Water Protection $0 $0 $0 $0 $0 $0 $0 SD
84 Kossler Reservoir 411119 1,200,000 $0 $360,706 $860,000 $0 5300,000 $0 $0 SO
85 Subtotal - Barker Water System $3,281,502 $2,043,182 $1,330,000 $525,000 $650,000 $360,500 $742,630 $635,808
86
87 Raw Water Storage Reservoirs
88 Albion Dam $3,075,000 $0 $0 $0 $0 $0 $0 $79,568 $0
89 Silver Lake Dam $0 $0 $0 $0 $0 $0 $0 $0
90 Island Lake Dam 411626 $105,000 $3,199 $104,951 $0 $0 $0 $0 $0 $0
91 Green Lake 1 Dam $0 $0 $0 $0 $0 $0 $0 $0
92 Green Lake 2 Dam 411627 $3,875,000 $0 $0 $0 $0 $75,000 $0 $0 $384,924
93 Green Lake 3 Dam $0 $0 $0 $0 $0 $0 $0 $0
94 Goose Lake Dam 411612 $0 $0 $0 $0 $0 $0 $0 $0
95 Boulder Reservoir $90,000 $0 $0 $0 $0 $0 $0 $0 $0
96 Lakewood Reservoir 411981 $102,500 $0 $0 $0 $0 $0 $0 $0 So
97 Skyscraper Dam 125,000 $0 $0 $0 $0 $0 $0 $0 SO
98 Wittemyer Ponds 4,000,000 $0 $0 $0 $0 $0 $0 $0 SO
99 Subtotal - Raw Water Storage Reservoirs $3,199 $104,951 $0 $0 $75,000 $0 $79,568 $384,924
100
101 Other Raw Water Facilities
102 Farmer's Ditch 411550 $0 $0 $0 $0 $0 $0 $0 $D
103 Anderson Ditch 411883 $0 $0 $0 $0 $0 $0 $0 $0
104 Watershed Improvements $440,500 $0 $0 $290,500 $0 $0 $0 $79,568 $0
105 Nederland WWTP 411565 $0 $300,000 $70,000 $0 $0 $0 $0 $0
106 Instream Flow Structures and Gaging 411549 $0 $0 $50,000 $0 $0 $0 $0 $0
107 Como Creek Diversion Structure 411548 $0 $0 $0 $0 $0 $0 $0 $0
108 Lakewood Diversion Structure $0 $0 $0 $0 $0 $0 $0 $0
109 Silver Lake Diversion Structure $0 $0 $0 $0 $0 $0 $0 $0
110 NCWCD Conveyance - Boulder Feeder Canal 411546 $283,000 $34,166 $287,155 $0 $0 $0 $0 $0 $0
142' NCWCD Conveyance - Carter Lake Pipeline 411547 $125,539 $992,986 $0 $0 SO $0 $0 $2,532,395
1 NCWCD Conveyance - Bond Proceeds $25,000,000 $0 $0 $0 $0 $0 $0 $0 $0
113 Subtotal - Other Raw Water Facilities $159,705 $1,580,141 $410,500 $0 $0 $0 $79,568 $2,532,395
114
115 Source Water Pressure Reducing, Pumping and Hydroelectric
116 Lakewood Hydroelectric/PRV 411801 $0 $0 $0 $0 $0 $0 $0 5300,000
117 Silver Lake Hydroelectric/PRV 411970 $0 $0 $0 $0 $0 $0 $0 $0
118 Boulder Reservoir Intake and Pumping 411655 $0 $200,000 $0 $0 $0 $0 $0 SO
119 Betasso Hydro PRV Station 411974 $2,417 $215,286 $0 $0 $0 $0 $0 SO
Attachment B-2
A B C D E F G H I J K
CITY OF BOULDER 10-May-10
2011-2016 CAPITAL IMPROVEMENT PROGRAM
WATER UTILITY FUND
Assumed Inflation Rate 3.00% ESTIMATED 2009 2010 2011 2012 2013 2014 2015 2016
PROJECT NAME 2008 COST ACTUAL REVISED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED
Barker Dam Hydro $0 $0 $0 $0 $0 $0 $0 $0
Barker Dam Hydro - Bond Proceeds $3,300,000 $0 $0 $0 $0 $0 $0 $0 $0
Boulder Canyon Hydro 411975 $4,300,000 $56,713 $3,975,000 $0 $0 $0 $0 $0 $0
Boulder Canyon Hydro - Grant 411976 $0 $1,180.000 $0 $0 $0 $0 $0 $0
Source Water Pressure Reducing, Pumping and Hydroelectric Facility F $0 $0 $0 $0 $0 $0 $0 so
Subtotal - Source Water PRV, Pumping and Hydro $59,130 $5,570,286 $0 $0 $0 $0 $0 $300,000
127 Water Distribution System Expansion
Annexation Related Water System Expansion 411433 $371 $524,628 $0 $0 $0 $0 $0 SO
Subtotal - Water Distribution System Expansion $371 $524,628 $0 $0 $0 $0 $0 $0
131 Water System Monitoring and Metering
32 Automated Meter Reading 411454 $500,000 $500,000 $530,450 $546,364 $562,754 $579,637 $0 $0 $0
Water System Security Upgrades 411440 $271,103 $100,000 $100,000 $100,000 $0 $0 $0 $0
Distribution System Water Quality 411425 $34,077 $249,857 $100,000 $0 $0 $0 $0 $0
Data Communications System 411435 $0 $0 $0 $0 $0 $0 $0 $0
Yards Master Plan Implementation 411039 $512 $241,875 $0 $0 $0 $0 $0 SO
TJ7 Utility Billing Computer System Replacement 411453 $10,446 $29,104 $0 $0 $0 $0 $0 $0
4 138 Subtotal -Water System Monitoring and Metering $816,138 $1,151,286 $746,364 $662,754 $579,637 $0 $0 $0
TOTAL CAPITAL USES OF FUNDS $9,001,819 $18,377,510 $6,071,864 $3,467,754 $4,554,637 $3,396,000 $4,049,731 $15,994,979
Attachment C-1
A B C D E F G H I J K L M N O P Q R
CITY OF BOULDER 17-May-10
2011 FUND FINANCIAL -Draff-
WASTEWATER UTILITY FUND
2009 2010 2011 2012 2013 2014 2015 2016
ACTUAL REVISED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED
UNAPPROPRIATED FUND BALANCE
Beginning of Year Fund Balance $14,724,357 $15,082,764 $11,154,156 $9,599,837 $7,670,432 $6,040,896 $5,543,636 $5,444,293
SOURCES OF FUNDS
Operating--
Sewer Charges to General Customers $12,601,245 $12,872,078 $12,897,822 $13,311,326 $13,871,467 $14,455,178 $15,3537134 $16,306,871
31 Projected Rate Increase $0 5% $0 0% $386,935 3% $532,453 4% $554,859 4% $867,311 6% $921,188 6% $978,412 6%
Surcharge/ Pretreatment Fees $114,589 $133,000 $118,000 $118,000 $118,000 $118,000 $118,000 $118,000
Cogeneration Revenues ($5,282) $0 $0 $0 $0 $0 $0 $0
_TT TOTAL OPERATING SOURCES OF FUNDS $12,710,552 $13,005,078 $13,402,757 $13,961,779 $14,544,326 $15,440,489 $16,392,322 $17,403,283
fg- NNon-Operating--
_TT Investment Fees $517,576 $600,000 $550,000 $600,000 $600,000 $600,000 $600,000 $600,000
Connection Charges $13,335 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
21 Special Assessments $0 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Interest on Investments $465,777 $206,489 $217,506 $239,996 $230,113 $181,227 $166,309 $163,329
Rent and other miscellaneous revenue $31,074 $29,500 $29,500 $1,500 $1,500 $1,500 $1,500 $1,500
Sale of Real Estate - Yards Masterplan $0 $125,000 $0 $0 $0 $0 $0 $0
Transfer from Other Funds $230,000 $0 $0 $0 $0 $0 $0 $0
Projected Bonds $0 $10,515,000 $0 $0 $0 $0 $0 $0
TOTAL NON-OPERATING SOURCES OF FUNDS $1,257,762 $11,490,989 $812,006 $856,496 $846,613 $797,727 $782,809 $779,829
TOTAL SOURCES OF FUNDS $13,968,314 $24,496,067 $14,214,763 $14,818,275 $15,390,939 $16,238,216 $17,175,131 $18,183,112
USES OF FUNDS
Operating Expenditures--
33 Administration $462,023 $525,043 $540,794 $557,018 $573,729 $590,941 $608,669 $626,929
Planning and Project Management $358,418 $341,929 $352,187 $362,752 $373,635 $384,844 $396,389 $408,281
Wastewater Quality & Environmental Svcs $920,893 $1,076,618 $1,108,917 $1,142,184 $1,176,450 $1,211,743 $1,248,095 $1,285,538
76- System Maintenance $1,253,192 $1,682,120 $1,732,584 $17784,561 $17838,098 $1,893,241 $1,950,038 $2,008,539
Wastewater Treatment $4,806,172 $5,385,984 $5,5477564 $5,713,990 $5,885,410 $6,061,972 $6,2437832 $6,431,147
Sick/Vacation Accrual ($51,293) $75,000 $77,250 $79,568 $81,955 $84,413 $86,946 $89,554
39 TOTAL OPERATING USES OF FUNDS $7,749,405 $9,086,694 $9,359,295 $9,640,074 $9,929,276 $10,227,154 $10,533,969 $10,849,988
Debt--
WWTP Improvements 2005 Revenue Bond $3,557,523 $3,556,583 $3,550,367 $3,546,533 $3,544,883 $3,543,496 $3,519,913 $3,502,288
4T
2005 Refunding of the 1992 Marshall Landfill Boric $170,331 $165,456 $165,568 $175,454 $0 $0 $0 $0
Arbitrage Payment ($22,858) $0 $0 $0 $0 $0 $0 $0
Projected Bond - WWTP UV Disinfection $0 $196,838 $3937675 $393,675 $393,675 $393,675 $3937675 $393,675
Projected Bond - WWTP Biosolids Digester $0 $177,888 $355,775 $355,775 $355,775 $355,775 $355,775 $355,775
Projected Bond - Headwork Improvements $0 $47,113 $94,225 $94,225 $94,225 $94,225 $94,225 $94,225
TOTAL DEBT SERVICE $3,704,996 $4,143,877 $4,559,610 $4,565,662 $4,388,558 $4,387,171 $4,363,588 $4,345,963
Transfers Out--
CostAllocation $794,683 $802,099 $882,309 $970,540 $1,067,594 $1,174,353 $1,291,788 $1,420,967
Planning & Development Services $183,917 $189,435 $195,118 $200,972 $207,001 $213,211 $219,607 $226,195
53 TOTAL TRANSFERS OUT $978,600 $991,534 $1,077,427 $1,171,512 $1,274,595 $1,387,564 $1,5117395 $1,647,162
Capital Improvements Program--
-57 CAPITAL USES OF FUNDS $951,963 $911,540 $850,000 $1,450,000 $1,510,000 $818,000 $952,467 $705,636
2005 BOND-WWTP IMPROVEMENTS $173,650 $0 $0 $0 $0 $0 $0 $0
PROJECTED BOND-BIOSOLIDS DIGESTER $0 $4,000,000 $0 $0 $0 $0 $0 $0
PROJECTED BOND-UV DISINFECTION $0 $4,434,562 $0 $0 $0 L $0 $0 $0
PROJECTED BOND-WWTP HEADWORKS $0 $1,000,000 $0 $0 $0 $0 $0 $0
BOND - ISSUANCE COSTS $0 $225,000 $0 $0 $0 $0 $0 $0
CARRYOVERS, ENCUMBRANCES & MID-YR ATBs $0 $3,706,469 $0 $0 $0 $0 $0 $0
TOTAL USES OF FUNDS $13,558,614 $28,499,676 $15,846,332 $16,827,248 $17,102,429 $16,819,889 $17,361,419 $17,548,749
66
_BT Sick/Vacation Accrual Adjustment ($51,293) $75,000 $77,250 $79,568 $81,955 $84,413 $86,946 $89,554
FUND BALANCE - END OF YEAR $15,082,764 $11,154,156 $9,599,837 $7,670,432 $6,040,896 $5,543,636 $5,444,293 $6,168,210
ri- Designated Reserves -
Bond Reserves $170,250 $1,013,925 $1,013,925 $1,013,925 $843,675 $843,675 $843,675 $843,675
Sick/Vacation/Bonus Liability $612,259 $630,627 $649,546 $669,032 $689,103 $709,776 $731,069 $753,001
Pay Period 27 - 2013 Reserve $96,357 $132,357 $168,357 $204,357 $240,357 $276,357 $312,357 $348,357
TOTAL RESERVES $878,866 $1,776,909 $1,8317828 $1,887,314 $1,773,135 $1,829,808 $1,8877101 $1,945,033
76
77 SURPLUS/(DEFICIT) vs. DESIGNATED RESERVE $14,203,898 $9,377,247 $7,768,009 $5,783,118 $4,267,761 $3,713,828 $3,557,192 $4,223,176
G RESERVE (Goal:25% of Operating)' $2,182,001 $2,519,557 $2,609,180 $2,702,896 $2,800,968 $2,903,680 $3,011,341 $3,124,287
CAPITAL RESERVE (Goal: $500,000) $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000
E82 OPERATIN
SURPLUS/(DEFICIT) vs. ALL RESERVES $11,521,897 $6,357,690 $4,658,829 $2,580,221 $966,793 $310,148 $45,851 $598,889
' Reserve levels are based on industry standards and are maintained for revenue bonds, revenue fluctuations weather and water usage impacts) and the capital intensive nature of the
utilit,
Attachment C-2
A B C D E F G H I J K
1 CITY OF BOULDER 17-May-10
2 2011 - 2016 CAPITAL IMPROVEMENT PROGRAM
3 WASTEWATER UTILITY FUND
Assumed Inflation Rate 3.00% ESTIMATED 2009 2010 2011 2012 2013 2014 2015 2016
PROJECT NAME 2008 COST ACTUAL REVISED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED
Wastewater Treatment
WWTP Pumps 421339 $0 $0 $0 $150,000 $0 $150,000 $0
-TT WWTP Permit Improvements 421617 $83,714 $83,714 $116,564 $0 $0 $0 $0
WWTP Permit Improvements- Proj. Bond 425xxx $10,000,000 $0 $10,000,000 $0 $0 $0 $0 $0 $0
-TT WWTP Laboratory $0 $0 $0 $0 $50,000 $0 $0
Lower Boulder Creek Enhancement 421661 $0 $0 $0 $0 $0 $0 $0
-TF WWTP Headworks 421003 $50,620 $50,620 $249,380 $0 $0 $0 $0
WWTP Headworks - Proj. Bond $0 $0 $0 $0 $1,000,000 $0 $0 $0 $0
WWTP Instrumentation/Control 421437 $0 $0 $75,000 $100,000 $0 $0 $0
WWTP Electrical 421439 $0 $0 $0 $0 $0 $100,000 $100,000
WWTP Activated Sludge $0 $0 $0 $0 $0 $60,000 $0
20 WWTP Primary Clarifiers 421005 = $0 $0 $0 $0 $300,000 $0 $0
WWTP Secondary Clarifiers 421006 $0 $0 $0 $0 $0 $0 $0
WWTP UV Disinfection 421110 $0 $0 $443,456 $0 $0 $0 $0
WWTP UV Disinfection - Proj. Bond $4,180,000 $0 $4,180,000 $0 $4,434,562 $0 $0 $0 SO
WWTP Permit Improvements - Proj. Bond 423900 $173,650 $173,650 $0 $0 $0 $0 $0
Wastewater Treatment Rehabilitation $0 $0 $0 $0 $0 $500,000 $0
26 Valmont Butte 421675 $135,992 $135,992 $298,948 $0 $0 $0 $0
Biosolids Handling & Dewatering 421670 $156,868 $156,868 $0 $0 $0 $0 $150,000
WWTP Biosolids Digester 421671 $181,481 $181,481 $801,593 $0 $0 $0 $0
WWTP Biosolids Digester - Proj. Bond 424xxx $0 $0 $4,000,000 $0 $0 $0 $0
WWTP Cogeneration 421329 $110,377 $110,377 $0 $0 $0 $150,000 $0
WWTP Digester Complex 421007 $0 $0 $50,000 $0 $0 $0 $0
32 WWTP Digester Cleaning 421360 $0 $0 $150,000 $0 $0 $0 $0
-ST Bond Issuance Costs 423998 $0 $0 $225,000 $0 $0 $0 $0
Subtotal - Wastewater Treatment Plant $892,702 $892,702 $11,844,503 $250,000 $350,000 $960,000 $250,000
Marshall Landfill
Marshall Landfill $0 $0 $100,000 $0 $0 $0 $0
38 Subtotal - Marshall Landfill $0 $0 $100,000 $0 $0 $0 $0
-ST
2rT Wastewater System Monitoring and Metering
Yards Master Plan Implementation 421039 $256 $256 $120,959 $0 $0 $0 $0
Automated Meter Reading 421548 $0 $0 $0 $0 $0 $0 SO
Utility Billing Computer System Replacement 421453 $9,051 $9,051 $60,232 $0 $0 $0 $0
44 Subtotal - Monitoring and Metering $9,307 $9,307 $181,191 $0 $0 $0 $0
Collection and Conveyance System Rehabilitation
Collection System Monitoring 421450 $0 $0 $0 $0 $50,000 $0 $0
Sanitary Sewer Rehabilitation 421002 $222,187 $222,187 $1,015,972 $450,000 $450,000 $450,000 $465,000
Sanitary Sewer Manhole Rehabilitation 421454 $836 $836 $205.090 $100.000 $100.000 $100,000 $103,000
IBM Pump Station 421521 $500,000 $0 $500,000 $0 $0 $50,000 $500,000 $0 $0
Tier 1 Boulder Creek 2 Master Plan Project $733,000 $0 $733,000 $0 $0 $0 $0 $0 $0
Tier 1 Goose Creek VIA Master Plan Project $1,203,000 $0 $1,203,000 $0 $0 $0 $0 $0 $0
Tier 1 Goose Creek 3 Master Plan Project $482,000 $0 $482,000 _ $0 $0 $0 $0 $0 $0
Tier 1 Goose Creek 5 Master Plan Project $2,559,000 $0 $2,559,000 $0 $0 $0 $0 $0 $0
Tier 2 Boulder Creek 1 Master Plan Project $1,653,000 $0 $1,653,000 $0 $0 $0 $0 $0 $0
Tier 2 Boulder Creek 3 Master Plan Project $1,939,000 $0 $1,939,000 $0 $0 $0 $0 $0 $0
Tier 2 Boulder Creek 4 Master Plan Project $12,356,000 $0 $12,356,000 $0 $0 $0 $0 $0 $0
Tier 2 Goose Creek 4 Master Plan Project $3,928,000 $0 $3,928,000 $0 $0 $0 $0 $0 $0
Tier 2 Gunbarrel 1 Master Plan Project $1,116,000 $0 $1,116,000 $0 $0 $0 $0 $0 $0
Tier 2 Gunbarrel 2 Master Plan Project $939,000 $0 $939,000 $0 $0 $0 $0 $0 $0
Tier 2 South Boulder Creek 1 Master Plan Project $733,000 $0 $733,000 $0 $0 $0 $0 $0 $0
62 Subtotal - Sewer System Rehabilitation $223,023 $223,023 $1,221,062 $600,000 $1,100,000 $550,000 $568,000
-GT
Wastewater System Expansion
Annexation Related WW System Expansion 421436 $581 $581 $717,312 $0 $0 $0 $0
Subtotal - Wastewater System Expansion $581 $581 $717,312 $0 $0 $0 $0
-GT
TOTAL CAPITAL USES OF FUNDS $1,125,613 $1,125,613 $14,064,068 $850,000 $1,450,000 $1,510,000 $818.000
Attachment D-1
A B C D E F G H I J K L M N O P Q R
CITY OF BOULDER 10-May-10
2011 FUND FINANCIAL -Draff-
STORMWATERlFLOOD MANAGEMENT UTILITY FUND
2009 2010 2011 2012 2013 2014 2015 2016
ACTUAL REVISED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED
UNAPPROPRIATED FUND BALANCE
Beginning of Year Fund Balance $12,777,970 $12,073,196 $6,106,059 $5,816,319 $5,232,516 $5,479,582 $5,667,932 $5,741,026
SOURCES OF FUNDS
Operating--
Service Charge Fees $5,0417779 $4,966,949 $4,976,883 $5,136,442 $5,301,116 $5,471,070 $5,646,472 $5,827,498
Projected Rate Increases $0 3% $0 0% $149,306 3% $154,093 3% $1597033 3% $164,132 3% $169,394 3% $1747825 3%
TOTAL OPERATING SOURCES OF FUNDS $5,041,779 $4,966,949 $5,126,189 $5,290,535 $5,460,150 55,635,202 $5,815,867 $6,002,323
Nan-Operating--
Plant Investment Fees $852,072 $600,000 $600,000 $600,000 $6507000 $650,000 $700,000 $700,000
fg- Urban Drainage District Funds $258,648 $500,000 $300,000 $275,000 $200,000 $250,000 $250,000 $250,000
_TT Colorado Dept of Transportation Funds $1,895,739 $89,502 $0 $0 $0 $0 $0 $0
State & Federal Grants $21,444 $0 $0 $0 SO $0 $0 $0
Interest on Investments $389,770 $97,673 $119,068 $145,408 $1567975 $164,387 $170,038 $172,231
Intergovernmental Transfers (KICP Program) $114,974 $135,000 $145,000 $150,000 $154,500 $159,135 $163,909 $168,826
23 Rent and other miscellaneous revenue $54,170 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000
Miscellaneous nonrecurring revenue $0 $0 $0 $0 $0 $0 $0 $0
Sale of Real Estate - Yards Masterplan $0 $125,000 $0 $0 s0 $0 $0 $0
Projected Bonds $0 $0 $0 $3,375,000 $0 $0 $0 $0
TOTAL NON-OPERATING SOURCES OF FUNDS $3,586,817 $1,583,175 $1,200,068 $4,581,408 $1,197,475 $1,259,522 $1,319,947 $1,327,057
29 TOTAL SOURCES OF FUNDS $8,628,596 $6,550,124 $6,326,258 $9,871,943 $6,657,625 $6,894,724 $7,135,814 $7,329,380
USES OF FUNDS
Operating Expenditures--
Administration $360,683 $404,335 $416,465 $428,959 $441,828 $455,083 $468,735 $482,797
Planning and Project Management $863,107 $996,697 $1,026,598 $1,057,396 $1,089,118 $1,121,791 $1,155,445 $1,190,108
Stormwater Contract Management $33,333 $48,473 $49,927 $51,425 $52,968 $54,557 $56,193 $57,879
36 Stormwater Quality and Education $817,520 $962,554 $985,251 $1,014,808 $1,045,252 $1,076,610 $1,108,908 $1,142,176
System Maintenance $6097805 $724,403 $746,135 $768,519 $7917575 $815,322 $839,782 $864,975
Sick/Vacation Accrual ($12,323) $50,000 $51,500 $53,045 $54,636 $56,275 $57,964 $59,703
TOTAL OPERATING USES OF FUNDS $2,672,125 $3,186,462 $3,275,876 $3,374,152 $3,4757377 $3,579,638 $3,687,027 $3,797,638
Debt--
Goose Creek/BVRC 1998 Revenue Bond $810,029 $1,126,036 $493,531 $491,872 $4947288 $490,726 $491,393 $486,045
Projected Bond - South Boulder Creek $0 $0 $0 $294,180 $2947180 $294,180 $294,180 $294,180
TOTAL DEBT SERVICE $810,029 $1,1267036 $493,531 $786,052 $788,468 $784,906 $785,573 $780,225
Transfers Out--
Cost Allocation $192,674 $195,486 $215,035 $236,538 $260,192 $286,211 $314,832 $346,315
Planning & Development Services $110,855 $114,181 $117,606 $121,135 $124,769 $128,512 $132,367 $136,338
49 Other Transfers $15,000 $15,000 $15,450 $15,914 $16,391 $16,883 $17,389 $17,911
TOTAL TRANSFERS OUT $318,529 $324,667 $348,091 $373,586 $401,351 $431,605 $464,588 $500,564
-57
Capital Improvements Program--
TOTAL CAPITAL USES OF FUNDS $5,520,364 $1,681,090 $2,550,000 $2,900,000 $1,800,000 $1,966,500 $2,183,495 $4,001,000
PROJECTED BOND - SOUTH BOULDER CREEK $0 $0 $0 $3,000,000 $0 $0 $0 $0
-57 PROJECTED BOND - ISSUANCE COSTS $0 $0 $0 $75,000 $0 $0 $0 $0
ENCUMBRANCES, CARRYOVERS & MID-YR ATBS $0 $6,249,006 $0 $0 $0 $0 $0 $0
TOTAL USES OF FUNDS $9,321,047 $12,567,261 $6,667,498 $10,508,790 $6,465,196 $6,762,649 $7,120,683 $9,079,427
Sick/Vacation Accrual Adjustment ($12,323) $50,000 $51,500 $53,045 $54,636 $56,275 $57,964 $59,703
FUND BALANCE - END OF YEAR $12,073,196 $6,106,059 $5,816,319 $5,232,516 $5,479,582 $5,667,932 $5,741,026 $4,050,682
Designated Reserves -
Bond Reserves $824,715 $824,715 $824,715 $1,118,895 $1,118,895 $1,118,895 $1,118,895 $1,118,895
Post Flood Property Acquisition $1,050,000 $1,050,000 $1,050,000 $1,050,000 $1,050,000 $1,050,000 $1,050,000 $1,050,000
68 Sick/Vacation/Bonus Liability $72,510 $74,685 $76,926 $79,234 $81,611 $84,059 $86,581 $89,178
Pay Period 27 Reserve $29,292 $40,292 $51,292 $62,292 $73,292 $84,292 $95,292 $1067292
TOTAL RESERVES $1,976,517 $1,989,692 $2,002,933 $2,310,421 $2,323,798 $2,337,246 $2,350,768 $2,364,365
SURPLUS/(DEFICIT) vs. DESIGNATED RESERVE: $10,096,679 $4,116,367 $3,813,386 $2,922,096 $3,155,784 $3,330,686 $3,390,258 $1,686,317
OPERATING RESERVE (Goal: 25% of Operating)' $747,664 $877,782 $905,992 $936,935 $969,182 $1,002,811 $1,037,904 $1,074,551
CAPITAL RESERVE (Goal: $200,000) $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000
SURPLUS/(DEFICIT) vs. ALL RESERVES $9,149,016 $3,038,584 $2,707,394 $1,785,161 $1,986,602 $2,127,875 $2,152,354 $411,766
76
77 ' Reserve levels are based on industry standards and are maintained for revenue bonds and the capital intensive nature of the utility
Attachment D-2
A B C D E F G H I J K
1 CITY OF BOULDER 10-May-10
2 2011-2016 CAPITAL IMPROVEMENT PROGRAM - Draft-
3 STORMWATER AND FLOOD MANAGEMENT UTILITY FUND
Assumed Inflation Rate 3.00% ESTIMATED 2009 2010 2011 2012 2013 2014 2015 2016
PROJECT NAME 2008 COST ACTUAL REVISED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED
Major Drainageways
-IT Elmer's Twomile Creek 431332 $4,098,432 $1,373,377 $0 $0 $0 $0 $0 $0
Goose Creek 431710 $0 $0 $0 $0 $0 $0 $0 $0
South Boulder Creek 431202 $12,900 $429,175 $300,000 $1,000,000 $0 $0 $0 $0
South Boulder Creek - Bond Proceeds $0 $0 $0 $3,000,000 $0 $0 $0 $0
Bond Issuance Costs $0 $0 $0 $75,000 $0 $0 $0 $0
-f 7 Skunk Canyon Creek $0 $0 $0 $0 $0 $0 $0 $0
TG- Sunshine Creek $0 $0 $0 $0 $0 $0 $0 $0
Twomile Canyon Creek $0 $0 $0 $0 $0 $0 $0 $0
18 Bluebell Canyon Creek - King's Gulch $0 $0 $0 $0 $0 $0 $0 $0
-IT Viele Channel $0 $0 $0 $0 $0 $0 $0 $0
Four Mile Canyon Creek 431729 S3,500,000 $9,237 $1,575,859 $0 SO $750,000 $750,000 $0 $0
Bear Canyon Creek 431010 $0 $0 $0 $0 $0 $0 $0 $0
Gregory Canyon Creek 431702 $0 $25,000 $250,000 $0 $0 $0 $0 $0
Boulder Creek 431015 $75,751 $74,250 $0 $100,000 $0 $0 $0 $0
24 Wonderland Creek 431003 S7,500,000 $73,614 $995,795 $750,000 $750,000 $0 $0 $750,000 $750,000
Preflood Acquisition 431622 $0 $1,668,307 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000
Greenways Program 431630 $365,552 $429,718 $150,000 $150,000 $150,000 $150,000 5150,000 $150,000
Subtotal - Major Drainageway Improvements $4,635,486 $6,571,481 $1,950,000 $5,575,000 $1,400,000 $1,400,000 $1,400,000 $1,400,000
79- -
Miscellaneous
30 Yards Master Plan Implementation 431039 $256 $134,386 $0 $0 $0 $0 $0 $0
CU Bike/Ped Bridge Replacement 431039 $0 SO $200,000 $0 $0 $0 SO $0
Utility Billing Computer System Replacement 431453 $10,446 $22,607 $0 $0 $0 $0 $0 $0
Subtotal - Miscellaneous Drainage Improvements $10,702 $156,993 $200,000 $0 $0 $0 $0 $0
Stormwater Management
36 Upper Goose Creek 431459 $10,700,000 $0 $100,000 $0 $0 $0 $0 $200,000 $2,000,000
Stormwater Quality Improvements 431775 $0 $53,045 $50,000 $50,000 $50,000 $51,500 $53,045 $54,636
Broadway Storm Sewer 431013 $874,176 $138,089 $0 $0 $0 $0 $0 $0
Storm Sewer Rehabilitation $0 $53,045 $100,000 5100.000 $100,000 $257,500 5265.225 $273,182
Transportation Coordination 431780 $0 $487,735 $250,000 $250,000 $250,000 $257.500 $265,225 $273,182
41 Subtotal - Localized Drainage Improvements $874,176 $831,914 $400,000 $400,000 $400,000 $566,500 $783,495 $2,601,000
42
TOTAL CAPITAL USES OF FUNDS $5,520,364 $7,560,388 $2,550,000 $5,975,000 $1,800,000 $1,966,500 $2,183,495 $4,001,000
44
Attachment E
Utilities 2010 Staffing Levels by Fund and Program
TITLE FTE TITLE FTE TITLE FTE
Water Fund (510) Wastewater Fund (520) Stormwater Fund (530)
Admin - Water 2.13 Admin -Wastewater 1.57 Admin - Flood Control 1.30
Director of Public Works 0.40 Director 0.35 Director 0.25
Financial Manager 0.35 Financial Manager 0.35 Financial Manager 0.30
Admin Specialist II 0.35 Admin Specialist II 0.35 Admin Specialist II 0.30
Project Admin. 0.40 Project Admin. 0.30 Project Admin. 0.30
Rate/Data Analyst 0.63 Rate/Data Analyst 0.22 Rabe/Data Analyst 0.15
Billing Services - Water 2.85 Billing Services - Wastewater 1.66 Billing Services - Flood 1.24
Supervisor 0.54 Supervisor 0.27 Supervisor 0.19
Representative 2.00 Representative 1.17 Representative 0.83
CIS Support 0.31 CIS Support 0.22 CIS Support 0.22
Support Services - 510 0.64 Support Services - 520 0.39 Support Services - 530 0.41
Communication Specialist 0.20 Communication Specialist 0.14 Communication Specialist 0.16
Communication Coordinator 0.14 Communication Coordinator 0.10 Communication Coordinator 0.10
Administrator 0.30 Administrator 0.15 Administrator 0.15
Engineering Ops - Water 5.76 Engineering Ops - Wastewater 1.95 Engineering Ops -Flood Control 4.50
Draftsperson II 0.60 Draftsperson II 0.20 Draftsperson II 0.20
Engineering Project Manager 2.50 Engineering Project Manager 0.75 Engineering Project Manager 1.50
Admin Specialist I 0.08 Admin Specialist I 0.08 Greenways Coordinator 1.00
Admin Specialist II 0.40 Admin Specialist II 0.20 Admin Specialist 1 0.08
Admin Supervisor 0.18 Admin Supervisor 0.07 Admin Specialist II 0.27
Senior Engineering Tech 2.00 Senior Engineering Tech 0.65 Admin Supervisor 0.10
Water Resources Operations 2.00 Senior Engineering Tech 0.35
Water Resources Coordinator 1.00 Wastewater Quality Operations 4.09 Flood Management Program 0.50
Water Source Specialist 1.00 Water Quality Planner 0.10 Maintenance Person III 0.50
Watershed Operations 2.00 Laboratory Supervisor 1.00
Water Source Manager 1.00 Water Quality Coordinator 0.20
Water Source Operations 1.00 Laboratory Aide 0.50
Hydroelectric Operations 3.00 Water Quality Analyst 0.70
Hydro Tech. II 2.00 Lead Water Quality Analyst 0.80
Hydroelectric Manager 1.00 Admin. Specialist I 0.20 Stormwater Quality Operations 3.55
Betasso WTP Operations 13.75 Analytical Chemist 0.50 Water Quality Planner 0.10
Industrial Mechanic 2.00 Watershed Educations Specialist 0.09 Water Quality Coordinator 0.20
Treatment Plant Supervisor 1.00 Water Quality Analyst 0.30
Plant Operator A 2.00 Industrial Pretreatment 3.66 Stormwater Quality Specialist 1.00
Plant Operator B 1.oo Water Quality Planner 0.10 Lead Water Quality Analyst 0.20
Admin. Specialist II 0.75 Pretreatment Inspector 1.00 Water Quality Inspector- Storage 1.00
Chief Plant Operator 5.00 Pretreatment Specialist 1.00 Admin. Specialist II 0.20
Lead Mechanic 0.50 Water Quality Coordinator 0.20 Analytical Chemist 0.30
Treatment Plant Coor. 0.50 Admin Specialist II 0.20 Watershed Outreach Coor. 0.25
Process Optimization Specialist 1.00 Watershed Out Reach Coor. 0.16
Bldr Res WTP Operations 9.25 Field Specialist 1.00 Stormwater Permit Compliance 2.01
Industrial Mechanic 1.00 Collection System Maintenance 13.95 Watershed Outreach Coor. 0.26
Chief Plant Operator 2.00 Maintenance Person I 2.00 Watershed Educations Specialist 1.50
Treatment Plant Supervisor 1.00 Maintenance Person II 2.00 Field Specialist (Drinking Water) 0.25
Admin. Specialist II 0.25 Maintenance Person IV 1.80
Mi Plant Operator D 1.00 Maintenance Person III 4.00
Lead Mechanic 0.50 Utility Maintenance Coor. 0.15 Storm Sewer Maintenance 4.75
Plant Operator A 2.00 Program Planner 0.55 Maintenance Person I 1.00
Treatment Plant Coordinator 0.50 Standby Utility 0.50 Maintenance Person II 0.25
Process Optimization Specialist 1.00 Maintenance Supervisor 0.80 Maintenance Person III 0.30
System Controls 3.00 Utility Locator 0.50 Maintenance Person IV 0.70
Electronics Tech II 2.00 TV Operator 1.00 Maintenance Supervisor 0.10
SCADA System Admin. 1.00 Material Supply Specialist 0.10 TV Operator 1.00
Water Quality Operations 6.78 Admin Specialist II 0.40 Utility Maintenance Coor. 0.15
Water Quality Planner 0.10 Program Admin MGR 0.15 Program Planner 0.20
Water Quality Project Manager 1.00 Meter Operations-Wastewater 0.64 Utility Locator 0.50
Water Source Operations Manager 2.00 Meter Service Tech. 0.48 Material Supply Specialist 0.10
Water Quality Coordinator 0.20 Meter Service Operations Assistant. 0.08 Admin. Specialist II 0.15
Drinking Water Quality Lab 1.00 Shop Water Meter Service Tech 0.08 Program Admin. MGR 0.15
Water Quality Inspector 1.00 Program Planner 0.15
Admin. Specialist II 0.20 Wastewater Operations 16.00
Laboratory Supervisor 1.00 Chief Plant Operator 5.00
Analytical Chemist 0.20 Treatment Plant Coordinator 1.00
Watershed Educations Specialist 0.08 Plant Operator A 3.00 Flood Channel Maintenance 2.55
Water Conservation 1.66 Plant Operator C 2.00 Maintenance Person II 0.55
Water Quality Planner 0.10 Plant Operator D 1.00 Maintenance Person III 1.00
Water Quality Coordinator 0.20 Admin. Specialist II 1.00 Maintenance Person IV 0.50
Program Specialist 1.00 Treatment Plant Supervisor 2.00 Maintenance Supervisor 0.50
Admin. Specialist I 0.20 Process Optimization Specialist 1.00
Watershed Outreach Coor. 0.16 WWTP Maintenance 9.00
Distribution System Maint 14.95 Plant Maintenance Supervisor 1.00 Flood Management 0.75
Maintenance Person I 1.00 Industrial Mechanic 2.00 Flood Management Program Manger 0.50
Maintenance Person II 2.00 Maintenance Person I 1.00 Civil Engineer II 0.25
Maintenance Person III 3.00 Maintenance Person II 1.00
Maintenance Person IV 3.20 Maintenance Person III 2.00
Maintenance Supervisor 1.00 Electronics Tech. II 1.00 21.06
Utility Maintenance Coor 0.20 Lead Instrumentation/Control I 1.00
Program Planner 0.60 Cogeneration 1.00 TITLE FTE
Standby Utility 0.50 Cogeneration Tech 1.00
Utility Locator 1.00 Biosolids Recycling 1.25 Transportation (180)
Material Supply Specialist 0.80 Resource Recover Specialist 0.25 Storm Sewer Maint - Transpo 0.80
Valve Operator 1.00 Lead Resource Recovery Operator 0.25 0.80
Admin. Specialist II 0.45 Resources Reccovery Operator 0.75 Sub Total Stormwater & Transportation 21.86
Program Admin. MGR 0.20
Meter Operations-Water 7.36 (Biosolids Processing 3.75 Total FTE count
Meter Service Tech 5.52 Resource Recovery Specilist 0.75 COB Public Works Utilities 155.90
Meter Service Operations 0.92 Lead Resource Recovery Op 0.75
Shop Water Meter Service Tech 0.92 Resource Recovery Operator 2.25
75.13 58.91