HomeMy WebLinkAbout6 - Preliminary 2010 Utilities Budget
CITY OF BOULDER
WATER RESOURCES ADVISORY BOARD AGENDA ITEM
MEETING DATE: May 18, 2009
AGENDA TITLE: Staff Presentation and Discussion of the Preliminary 2010 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.
i
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 2010 through 2015. Utilities staff has formulated revenue and
expenditure projections for each of the three utility funds through the year 2015. Within the
budget process Council approves and appropriates funds only for the first year, 2010.
This packet contains information concerning the Preliminary 2010 Utilities Budget and the 2010-
2015 Utilities Capital Improvement Program (CIP). The attached fund financials (Attachment
A - Water Utility, Attachment B - Wastewater Utility and Attachment C -Stormwater / Flood
Management Utility) reflect actual revenues and expenditures for 2008, 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 fiend financials later in May after the
city's budget guidelines have been distributed.
At the May 18, 2009 WRAB meeting, staff will ask WRAB for input and feedback on the
preliminary 2010 budget and 2010-2015 CIP. Staff will return to the Board on June 15th for
further discussion and to solicit a recommendation to Planning Board and City Council
concerning the proposed 2010 Utilities Division budget and 2010-2015 CIP.
AGENDA ITEM # 6 PAGE 1
Fiscal Impacts: The following percentage increases in additional revenue from the monthly
utility fees are currently being considered by staff for 2010 to fund the preliminary Utilities
budget and capital improvements program. Staff has tried to reduce the increases in Wastewater
and Stormwater/Flood to below a CPI level in order to offset a higher level of Water increase.
Water 5%
Wastewater 2%
Stormwater/ Flood Management 2%
Board Feedback: Staff is asking that WRAB review the preliminary 2010 budget and CIP and
to provide feedback to staff regarding the following:
1. Revenue Options being considered
2. Peer Review Tier 1 Items that require additional funding
3. Requests for Budget Supplementals
4. Preliminary 2010-2015 CIP
Public Feedback: Board input and a public hearing is scheduled for this meeting. A public
hearing and recommendation is scheduled for June 15, 2009. At that time, staff will request that
the WRA.B provide a final recommendation concerning the proposed 2010-2015 CIP to Planning
Board and City Council.
Staff Recommendation: No final recommendation at this time.
REVENUE HIGHLIGHTS FOR THE 2010 PRELIMINARY BUDGET:
Preliminary Revenue Increase
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.
At the April WRAB meeting, as part of the Peer Review Agenda item, it was stated that three
revenue options would be evaluated as part of the 2010 budget process. The revenue options
represent the amount of additional revenue to be generated from the monthly utility charges. The
three options presented were:
• Reduced Fiscally Constrained: 0% for all three utilities
• Fiscally Constrained: 3% for all three utilities
• Action Plan: 5% water; 6% wastewater and 3% stormwater/flood management
which are the revenue increases that were projected for 2010 as part of the 2009
budget process
AGENDA ITEM # 6 PAGE 2
After developing the draft capital improvement programs, updating revenue projections and
reviewing the financial status of each fund, these options have been revised. The revised options
that will be developed as part of the 2010 budget process are:
• Option A: 5% water; 2% wastewater and 2% stormwater/flood management
• Option B: 3% water, 2% wastewater and 2% stormwater/flood management
• Option C: 0% for all three utilities
During the 2009 budget process, the 2010 revenue increase for the wastewater utility was
projected to be 6% in order to fund a third digester at the Wastewater Treatment Facility. A
further review in 2009 shows that a third digester is not needed now and that a smaller capital
project to fund some digester mixing and headworks improvements may still be necessary. As
such, the preliminary 2010 CIP reflects the reduced costs.
The preliminary 2010 fund financials included in this packet reflect the Option A revenue
increases for 2010 (5% Water-2% Wastewater-2% Stormwater/Flood Management). In
Wastewater and Stormwater/Flood Management, this represents an inflationary increase in
revenues to cover projected personnel expenses (including insurance costs), increases to
nonpersonnel items such as chemicals, power and other purchased materials, funding for the Peer
Review Tier 1 items as well as other items that have been identified by staff. The Tier 1 Peer
Review items and staff recommended budget supplemental requests are discussed in more detail
in their respective sections of this memo and are also listed in Attachment D. In addition to
these items, the 5% increase in the Water Fund is being considered due to the revenue reduction
from the combined 3-year Plant Investment Fee phase-in period and reduced development
activity. As shown in the following Revenue Options section, a 3% revenue increase (Option B)
results in a 2010 revenue decrease of $165,000 compared to 2009, thereby creating the need to
reduce or cut projects from the 2009 level of funding.
The preliminary 2010 revenue increases (5%-2%-2%) would increase a typical residential
customer's annual utility bill by approximately $25.00, or an increase of approximately $2.12 per
month.
Revenue Options
The estimated financial impact for each of the revenue options is included in the table below.
The table shows the revenue increase and the net surplus/deficit for each option. The net
surplus/deficit is either the amount available for enhancements (such as Tier 1 items or budget
supplemental requests) or the amount to be reduced through further efficiencies and/or
reductions. This number was estimated by:
• calculating the additional revenue generated from the revenue increase
• adjusting it for the impact of the phased-in implementation of the plant investment
fees along with the impact of reduced development activity that is occurring
• reducing it by the estimated additional costs needed in 2010 for personnel costs
(salaries and benefits) and a small increase in nonpersonnel expenses.
AGENDA ITEM # 6 PAGE 3
i
Option A Option B Option C
Revenues Revenues Revenues
Water Revenue Increase 5% 3% 0%
Net Surplus/(Deficit) $235,000 ($165,000) ($770,000
Wastewater Revenue Increase 2% 2% 0%
Net S lus/(Deficit) $65,000 $65,000 $200,000)
Stormwater/ Flood Revenue Increase 2% 2% 0%
Management
Net S lus/(Deficit) $100,000 $100,000 $700
These numbers will continue to be refined based on information from the budget guidelines and
as trade-offs, reallocations and/or reductions are incorporated into the 6-year fund financial. For
each of these options, staff will prepare a proposed list of enhancements, efficiencies, trade-offs,
reductions and/or reallocations in order to operate within each financial scenario. This
information will be provided to WRAB as part of their June 15 packet. This list will likely
encompass items from the current operating budget, capital improvement program, Tier 1 peer
review items, budget supplemental requests and perhaps future revenue increases above the rate
of inflation.
PEER REVIEW ITEMS
All of the Tier 1 items have been incorporated into the preliminary 2010 budget with revenue
increases of 5%-2%-2%. As stated in the April 20, 2009 WRAB agenda item regarding the Peer
Review, of the 30 Tier 1 items, 26 may be funded within the existing 2009 budget or draft 2010
budget. These items include those that have savings (9 items) and those that are preferable to
continue and do but that do not have savings (17 items). The remaining four Tier I items in the
following table are partially funded through the existing 2009 budget or draft 2010 budget, but
require additional resources in order to evaluate and implement. These four items may result in
future savings, but the estimated amount has not been determined. All of the Tier I items are
listed in Attachment D.
AGENDA ITEM # 6 PAGE 4
Item # Water Wastewater Stormwater Total
/ Flood
Enhance Safety & Health 5 $23,500 $23,500 $3,000 $50,000
Program - hire a consultant (one-time (one-time (one-time
to perform a safety and health expense) expense) expense)
analysis for the entire
division.
Senior Management to 7 and 8 $9,400 $9,400 $1,200 $20,000
Actively Promote a Safety
Culture - in addition to
more internal staff time
focused on this area,
additional funding would be
used for training by an
outside consultant.
Regular Inspection and 10 $149,800 $149,800
Maintenance of high (includes
pressure pipeline right-of- 1 new
ways - Establish regular staff
inspection and maintenance person)
program for treated water
transmission line right-of-
ways.
Total $182,700 $32,900 $4,200 $219,800
AGENDA ITEM # 6 PAGE 5
BUDGET SUPPLEMENTAL REQUESTS
The following budget supplemental requests were submitted by staff and are being considered
and evaluated for the 2010 budget.
Stormwater
Water Wastewater ! Flood Total
Hydroelectric Equipment $10,000 $10,000
Rehabilitation - Current budget of
$50,000 for annual maintenance is
insufficient given the age of the hydro
facilities.
Household Hazardous Waste $46,766 $43,168 $89,934
Program - rising costs due to
increased citizen participation and the
possibility of the city's general fund
contribution ($17,665) being
eliminated.
Regulatory Support - Consultant $16,000 $4,000 $20,000
support for the 2010 Basic Standard
Support for Aquatic Life and nutrient
criteria and other ongoing hearing and
special water quality studies.
Replacement Program - For WQES $10,000 $45,000 $10,000 $65,000
Laboratory and Office areas including (in 2010, (in 2010, (in 2010, (in 2010,
Laboratory Equipment. Additional $8,000 $10,000 $4,000 $22,000
money in 2010 will fund the ongoing) ongoing) ongoing) ongoing)
immediate replacement of the
Spectrophotometer used for particulate
analysis.
Valve Operations Testing Program $15,000 $15,000
- Temporary staff will allow catch-up
for preventative maintenance on valves
and provide additional safety measures
havine two staff work together.
Water Monitors - When a meter is $10,000 $10,000
upgraded to Orion, leaflet will be left
to customer. City will sell monitors at
cost ($75). Pilot for five years to
evaluate interest.
Total $45,000 $107,766 $57,168 $209,934
All of these budget additions are currently incorporated into the fund financials and would be
funded as part of the preliminary revenue increases.
AGENDA ITEM # 6 PAGE 6
STAFFING LEVELS
The Utilities Division currently has 156.23 budgeted full -time equivalent (FTE) employees.
There are 75.67 that support the water utility; 58.81 in wastewater; 20.95 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. The 2010
preliminary budget includes a Tier 1 request for one additional FTE in the water fund to perform
the right-of-way maintenance for high pressure pipelines. This request will continue to be
evaluated as to whether this can be done by existing staff.
HIGHLIGHTS AND MAJOR PROPOSED CHANGES FROM THE 2010-201.5 CH'
Water Utility
1. Funding for the next phase of improvements to the Betasso Water Treatment Facility
(WTF) has been delayed until 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 waterline replacement has been reduced. A recent staff analysis indicates that
a funding level of $2,100,000 (2008 dollars) should be sufficient to maintain the current
service level, as defined by water main breaks, over the next decade. Funding has been
adjusted to reflect anticipated construction costs inflation of 3 percent each year. The
replacement program is coordinated with the Transportation Division street overlay and
reconstruction program.
3. Funds have been budgeted for inspection and possible repair and rehabilitation of the
Lakewood Pipeline. Funds would be transferred from the Lakewood Pipeline
Remediation Reserve to cover the costs.
Based on observations made during five internal inspections of Lakewood Pipeline Phase
III, immediate and/or extensive repair/remediation efforts are not necessary and
monitoring and internal inspections will occur at two-year intervals. The next internal
inspection of the pipeline is scheduled for the fall of 2009. Staff is also in the process of
developing repair, rehabilitation and replacement alternatives and formulating
recommendations concerning a long range plan. Reports on the 2009 inspection and the
alternatives analysis will likely be completed in early 2010. The budget
recommendations reflect a possible remediation project in 2012 of $1.2 million. This
anticipates that the work in 2009 (corrosion rate study, pipe inspection and review of
rehabilitation technologies) may result in a project to plan and design in 2010-2011 and
construct in 2012. The most likely pilot remediation plan would involve relining the
pipeline rather than removal and replacement.
AGENDA ITEM # 6 PAGE 7
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.
Stored water from Barker Reservoir and direct flows from Middle Boulder Creek are used
to meet approximately 35 percent of the city's annual water needs. The city has, as part of
an ongoing maintenance effort, already replaced and rehabilitated segments of the 11-
mile Barker Gravity Pipeline that showed the most degradation or highest likelihood of
failure. The city should continue its annual maintenance program, prioritizing based on
the most critical needs, and also consider providing enough cover to protect the pipeline,
and anchor the pipeline in areas prone to landslides or other damaging events. Section
replacement or lining in place are options that may each work well in different parts of
the pipeline. The city should coordinate with the USFS concerning maintenance activities
on federal land. The projected funds will allow for continued minor rehabilitation efforts
(repair of leaks, siphons, etc, as has been done over the past several years) and an
evaluation of a pilot replacement/lining project through 2014. In 2015 when additional
funds are available, the city can potentially begin a full scale replacement/lining
project.
5. The Barker Dam outlet works should be replaced within the next seven to 10 years as
recommended in the SWMP to eliminate the need to empty the reservoir for gate
inspection. A design for outlet works replacement was completed by GET, and initial bids
were received in 2002. The cost of the outlet works replacement could be substantially
reduced by eliminating one of the proposed microtunnels.
6. Funding for construction of the proposed Carter Lake Pipeline has been delayed until the
2016-2017 time period. Funding of the pipeline in the nearer term without Federal
funding 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 the drawing water directly from the Boulder Feeder
Canal and Boulder Reservoir. By delaying the schedule for pipeline construction, more
time is available to secure Federal funding assistance. A Capital Project Fund (reserve) is
reflected in the preliminary Water Fund Financial (Attachment A) at an amount of $2.5
million to help cash-fund this project.
7. Funding for the automated meter reading project is recommended for the accelerated
replacement of the meter's transponders. The original transponders are not lasting as
long as originally projected. The recommended funding is $500,000 for 5 years 2009-
2013.
Wastewater Utility
1. Funding for the 75th Street WWTP Ultraviolet (UV) Disinfection project has been
maintained at $4,400,000 in the 2010 CIP. The UV disinfection project will replace the
plant's gas chlorine and sulfur dioxide systems, representing a significant plant safety
upgrade. The UV Disinfection system design was originally a component of the
2006/2008 WWTP Liquid Stream Upgrades project. Because of funding limitations, the
AGENDA ITEM # 6 PAGE 8
city was not able to award that bid item in the construction contract. Funds have been
budgeted during the 2009-2010 time period for the design and construction phases
respectively. It is anticipated that bonds will need to be issued to fund the constriction of
this project.
2. Funding for the 75th Street WWTP Biosolids Digester project has been reduced from
$7,800,000 to $4,000,000 in the 2010 CIP. The plant's digestion process is old and is
experiencing various problems and limitations associated with the following: capacity,
poor mixing, poor operational flexibility, lack of redundancy, and aging electrical and
mechanical facilities. Carollo Engineers recently completed a comprehensive digester
evaluation which presented various digester process modifications ranging in cost
between $2,000,000 and $10,000,000. City staff is evaluating the various alternatives to
determine which improvements will best address the plant's critical needs over both the
short-term and long-term. The digester alternatives will also be evaluated relative to
other high priority WWTP needs including UV Disinfection and Headworks
improvements. Funds have been budgeted during the 2009-2010 time period for the
design and construction phases respectively.
3. Funding for the 75th Street WWTP Headworks Improvements project has been pushed
back one year from 2014/2015 to 2015/2016 because of funding limitations in the 6-year
CIP. The CIP currently has design and construction funds of $1,560,000 and $15,600,000
identified in 2015 and 2016 respectively for a new headworks facility. The headworks
facility is old, and plant staff recently experienced significant operational difficulties
when one of the key headworks processes failed during an April 2009 wet weather event.
The headworks facility is comprised of four major processes including the following:
screenings removal, grit removal, screenings and grit washing and classification, and
F VAC. Carollo Engineers is in the process of completing a comprehensive headworks
evaluation to identify various individual process upgrades as an alternative to the new
facility identified in the 2015/2016 funding. Based on the completed headworks analysis,
city staff will incorporate potential headworks improvements proj ects into the 2011 CIP.
4. Funding for the Sanitary Sewer Rehabilitation projects has been reduced to $530,000 in
the 2010 CIP. Utilities funded the sanitary sewer rehabilitation line item at $300,000,
$625,000 and $720,000 in 2006, 2007, and 2008 respectively. Utilities staff has
addressed a significant number of the sanitary sewer collection system's highest priority
problems through this effort. The 2009 sanitary sewer rehabilitation CIP funding is
$800,000. Based on a recent analysis evaluating the sewer collection system facilities
"useful life", city staff will be reducing the sanitary sewer rehabilitation line item budget
from $750,000 to $500,000 for the short-term CIP. Utilities staff has concluded that an
annual budget of $500,000 (escalated at 3% annually) will be adequate for the
rehabilitation projects.
5. Funding for the Wastewater Collection System Master Plan (WWCSMP) projects has
been identified in the Wastewater Utility Fund CIP. CIP line items 54-64 represent l 1
AGENDA ITEM # 6 PAGE 9
potential collection system projects. HDR Engineers recently completed the WWCSMP,
which identified numerous potential collection system projects based on hydraulic
deficiency. The WWCSMP identified four Tier 1 (highest priority) projects and seven
Tier 2 (second highest priority) projects for recommended collection system
improvements. The estimated cost (in 2009 dollars) for the Tier 1 and Tier 2 projects was
$5,000,000 and $23,000,000 respectively. Additionally, the Master Plan identified 10
Tier 3 (lowest priority) projects with an estimated cost of $4,000,000. The recommended
collection system projects do not represent the equivalent high priority of the WWTP
projects, therefore, the collection system projects have been moved outside of the six-year
(2010-2015) CIP.
Stormwater and Flood Management Utility
1. It is recommended that money be budgeted and allocated for flood mitigation work along
Fourmile Canyon Creek and Wonderland Creek. The flood mitigation planning process is
nearing an end and a decision regarding the flood mitigation approach for these two
streams should be made by city council in 2009. The proposed work is comprised of
multiple individual projects that allow funding to be spread out over the next 20-30 years.
The city will prioritize those projects that have the most significant benefit from either a
life safety or property damage mitigation perspective and are within the incorporated city
limits. Projects that provide multiple benefits and allow the city to leverage funding with
private developers or other agencies such as the Denver Regional Council of
Governments (DRCOG) Transportation Improvement Project (TIP) fielding will also be
prioritized. One of these projects is envisioned to be a new culvert and pedestrian
underpass at the Burlington Northern and Sante Fe Railroad and Boulder White Rocks
Ditch just upstream of Foothills Parkway on Wonderland Creek. The city applied for TIP
funding for this project and although the project did not make the first funding cut it is
still possible the city will receive matching funds. All projects will be closely coordinated
with the city's Greenways Program and Transportation Division. Land acquisition will be
required to support this project.
2. Money has been allocated for future flood mitigation design and construction for South
Boulder Creek. Funding for flood mitigation planning has already been appropriated and
the planning work will begin in 2009.
On March 25, 2009, FEMA notified the city of Boulder that it intends to officially adopt
(effective January 2010) the revised floodplain mapping that resulted from the South
Boulder Creek flood mapping study. The new floodplain mapping will be used as the
basis for the Flood Insurance Rate Map (FIRM) that establishes minimum regulatory
floodplain boundaries under the National Flood Insurance Program (NFIP) and federal
mandatory flood insurance purchase requirements. The adoption process for the study
results will coincide with the adoption of the related Digital FIRM for Boulder County.
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
AGENDA ITEM # 6 PAGE 10
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 is also pursuing Federal funding for this
project. It is recommended that money be budgeted in 2009-2011 to support this work.
3. It is recommended that money be budgeted for flood mitigation design and construction
for Gregory Canyon Creek. A recent analysis indicates that several structures could be
removed from the high hazard zone based on drainageway and culvert improvements near
Pennsylvania Ave.
BUDGET SCHEDULE
The current schedule of major budget milestones is provided below. Elements involving the
WRAB are highlighted in bold italics.
Milestone Date
Capital Projects Information Sharing Meeting April 23, 2009
Draft CIP Proposal Submitted May 8, 2009
City Council Study Session on Budget May l2, 2009
Preliminary WRAB Budget Discussion May 18, 2009
City Council Study Session on Budget June 9, 2009
Proposed Budget Submittal to City Manager June 11, 2009
Public Hearing/ WRAB Recommendation on CIPBudget June 15, 2009
Departmental Budget Review by City Manager June 12-July 10, 2009
CIP Submitted to Planning Board July 2, 2009
Planning Board CEP Hearing July 16, 2009
City Council Study Session on Budget (CIP) July 28, 2009
City Council Study Session on Budget Aug. 25, 2009
City Council Study Session on Budget (if needed) Sept. 8, 2009
City Council Consideration/Adoption of Budget Oct. 6 and 20, 2009
NEXT STEPS
Staff is seeking feedback on the revenue options, preliminary CIP and additional Peer Review
and budget supplemental items being considered. Staff will return to the June 15 meeting with
updated financial information incorporating the 2010 Budget Guidelines and input from WRAB.
The trade-offs, reductions and/or reallocations for each of the revenue options will also be
provided. At the June 15 WRAB meeting, staff will request that the WRAB provide a final
recommendation concerning the proposed 2010-2015 CIP to Planning Board and City Council.
Attachinent A: Water - Fund Financial and Capital Improvement
Attachment B: Wastewater - Fund Financial Capital Improvement Program
Attachment C: Stormwater/ Flood Management - Fund Financial and Capital Improvement
Program
Attachment D: Tier 1 Peer Review Items and Budget Supplemental Requests
Attachment E: Staffing Levels by Program
AGENDA ITEM 4 6 PAGE 1 l
Attachment A
A B C D E F G H I J K L M N O P Q
2 _CITY OF BOULDER 12-Ma -08
I 2010 FUND FINANCIAL j Draft _
3 I WATER UTILITY FUND
4 -1
5 2008 i 2009 2010 2011 2012 2013 2074 2015
6 _ ACTUAL REVISED RECOMMENDED PROJECTED ;PROJECTED PROJECTED PROJECTED! PROJECTED
7 UNAPPROPRIATED FUNO BALANCE I
BeginnincJ of Year Fund Balance $47,758,924
9 _ $47,7_17,621 =.617,4721 533,153,81 $31,711,803 S31,947,457 $32,775,717 j G S34,825,417
-
10 SOURCES OF FUNDS I 1_
i 1 O ert rating- `I T
12 Sale of Water to General Cost 518,965.952 I I_ .$18,615.656 520,171,468 $21,222.199 I $21.902379 _I 522,604.367 $23,328.860 S24,076,580
13 Projected Rate Increase _ $0 4% $1.489252 8% 51,008,573 5% $6 6,666 3% $657.071 3% $678,131 3% $699,866 3% $722,297
14 Bulkllrri ation Water Sales 5139,468 $99,950 5718.550 _$116,050 $119,050 $121,150 5124,150 1 $126,150
15 Hydroelectric Revenue _ I 51,932.085 5.1_,8_95.0001 1 S1,890,0001 $_1.785.000 $1,785,0130 51,785,000 51,785,000 $1,785,000
16 Miscellaneous Operatin Revenues 555.829 S25.000 S25,0000 - 525.000 $25.000 $25,000 i $25.000 $25.000
17 TOTAL OPERATING SOURCES OF FUNDS 521.093.334 $22,124,858 $23,213.592 $23.784,915 S24.488,501 1 $25.213,648 $25,962,876 1 $26,735,027
19 N_on-O eratin - - - -
20 Plant Investment Fees $4,193.395 1 $2.500.000 52,100,000 S2,100.000 $2,100,000 I 52.500.000 j 52,500.000 1 $2,500.000
21 Connection Charges 5144.209 $165,000 S150.ooo 1 $150.000 5150.000 $165.000 5165,000 I $165.000
22 Special Assessments $6,306 i $5,000 $5,000 $5,000 _S5.000 1 $5,000 $5,000 $5.000
24 Interest on Investments S1,923,390 $1,284,765- $1,284,765 1_ $1,160,361 51,109.913 $1,718.161 $1,747,150 $1,2t8,89U
25 Rent, assessments and other mist revenues 523.333 $104,719 S18A0o 518,500 ' 519,000 i S19,500 $20,000 $20_.500
26 Sale of Real Estate - Yards Master Ian $26,422 $250,000 I Sol 50 . $0 $0 $0 SO
27 Transfer from General Funri Fue Trainin_ Center so $130,000 I 5130,004 $130,000 $130,000 $130.000 $130,000 5130.000
28 Projected Bond Proceeds $0 I $0 i so SO $0 SO SO 50
29 TOTAL NON-OPERATING SOURCES OF FUNDS $6.317,055 54.439,484 1 $3,687,765 $3,563,861 53.513,913 $3.937.661 $3,967.150 $4.039,390
30
31 TOTAL SOURCES OF FUNDS $27,410,389 $25,564,342 $26,901,357 $27,348,776 $28,002,414 $29,151,309 529,930,026 $30,774,417
32 _ I
33 USES OF FUNDS
34 Operating Expenditures-
351 Administration S7,082,181 $878,106 5904.4491 $931,583 5959,5301 5988.3_16 51,017,966 $1,048.504_
36 Planning and Project Management 5555,660 1 $571,134 $588,268. 5605,916 5624.094 5642,816 S662.101 5661,964
'7
37 Water Resources and Hydroelectric Operatlorts 52,046,176 1 51.969,183 $2,028,256 1 _ $2,089.106 $2,151.779 32.216,333 $2.282,823 $2.351,307
38 WaierTreatment $4,122.965 $4,178,500 $4,303,855 54,432,971 $4,565,960 ( $4,701939 $4,844,027 $4,989,348
39 Water Quality & Environmental Svcs 5772,801 S802,192 . 5826,258 5851.045 5876.577 ! g902.874 $929,960 $957,859
40 Water Conservation I S371,822 W1.9231 5465.481 _S479.445 $493.623 $508.643 $_523,903 - $539.620
41 System Maintenance 1 $2,898.341 53.063.574 i $3.155,481 $3.250.146 $3,347,650 53,448,080 $3,551,522 $3,658,068
. .
42 Windy Gap Payment I $2,266,168 $2.457.567 1 $2,479,532 1 $2,500,539 $2,523,910_ S21546.836 $2.593,250_ _ $2,726.404
Proposed Tier 1 Items I 50 . _ 50 1 $182,700 1 $163_976 $1168,895 5173,962 5179,181 5184,556
44 Proposed Budget Supplementais SO So $45,000 1 $14.290 545.619. $46.987 $48,397 539,549
45 Nederland WWTP Operations $0 SO I SO ! $i 7,300 517,819 $18,354 $18,904 $19.471
- -
48 Emer eng cyReserve So 1 $360.000 1 $370,800 $381,924 5393,382 $405.183 $417,339 $429,859
49 SeckNacation Accrual _ $34.505 1 $100.000 I S103.000 I S106.090 $109.273 $112.551 1 $115,927 $119,405
50 TOTAL OPERATING USES OF FUNDS $14,150,619 j $14,832.179 ! $15,453,082 1 $15,854,337 $16,278,316 $16,713,874 $17,185,299 $17,745,514
51
52 Debt-
53 BRWTP 1996 Revenue Bond: Refundin in 2005 $845,302 S843,8101 $844,505 I$848.752 5854.690 5854.436 1 5856.594 1 $857,709
54 Refunding of the 1999 and 2000 Revenue Bonds $3,258.354 S3.257.654_ 1 $3,253,354 ! $2.507,92_1 $2.506.088 $2,511,421 - 52,523.521 S2,50.694-
55 Lakewood Pipeline 2001 Revenue Bond ! $2.178,969 52,180.202 52,174.452 52.171.1385 52.172.3.02 52,175.502 52,176,142 $2,182,416
56 Arbitrage Payment 51.678 513.352 $o $0 Sa SD so 50
61 TOTAL DEBT SERVICE I $6,284,303 56.295,018. $6,272,311 $5,528,558 55,533,080 $5,541,361 $5,556,257 $5,562,179
62
63 Transfers Out- I -
64 Cost Alloration $1,149,406 S7 133 776 ~ $1.118,145 1 1 51,229,960 $1.352,955 $1,488,251 $1,637,076 $1,800.784
65 Planning & Development Services $178.019 1 1 S183359 S188,860 $194,526 1 $200,361 5206,372 _ _$212,563_ I $218,940
66 Other Transfers 315.000 1 $115,600 $15.450 1 $15,914 516.391 $16.883' 1 $17389 S17.911
67 TOTAL TRANSFERS OUT $1,342,425 $1,332.135 1 $1,322,455 1 1 $1,440,399 $1,569.708 $1,711.506 $1.667.029 $2,037.635
68
69 Capital Imp avements ProJram- I
70 TOTAL CAPITAL USES OF FUNDS $5.708,850 1 $10,079,050 I $4.791,600 1 1 $6,454.681 1 54,888.311 I $4,874,042 $3,805.008 $7,479,504
71 1
77 ENCUMBRANCES, CARRYOVERS & MID-YR ATB's SD S8.586.11 09 $0 j so I SO $0 SO $o
78 I 1
79 TOTAL USES OF FUNDS $27A86,197 $41,124,491 $27,839,448 $29,278,169 $28,269,414 $28,840,782 $28,413,592 $32,924,832
80 1 1 I 1 I
81 Emergercy Reserve Adjustment so 1 $360.0130 1 $370.800 $381,924 $393,382 5405,183. $417,339 5429.859
82 Sick,Vacation Accrual Adjustment $34,505 $100,000 1 $103.000 $106,090 $109`273 $112,551 $115.927 I 5119,405
83
84 FUND BALANCE - END OF YEAR $47,717,621 $33,617,472 $33,153,181 $31,711,803 $31,947,457 $32,775,717 $34,825,417 $33,324,266
85
86 Designated Reserves -
87 Bond Reserves $3,068.830 $3.068.830 1 $3.068,830 I 53.068430 S3.068,830 I $3,068,830 $3,068.830 $3,068,830
88 _ Lakewood Pipeline Remediation Reserve S16,256.744 $16,646,086 $17,050.884 I 517.56.9_.502 $16,847,149 I 517.359,571 $17,7116;371 $18,306,752
89 LakewoodJUSF5 Damage Claims Reserve 5100,000 $100,000 5100,000 $160.1300 S1D0.000 $0 SD $0
90 Future Capital Pro-eects Reserve SoSo_ $2.500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000 52.500 000
91 VacationlSickl9nnusLiabilit $647,902 5667,339 1 $687,359 $707,980 $729.219 $751,096 1 $773,629 5796,838
92 Pa Period 27 - 2013 Reserve $75,708 $126,708 $177,708 $228,708 $279.708 $330.708 1 5381,708 1 5432.708
93 94 TOTAL RESERVES S20.149.184 520.608.963 $23,584.781 $24,175.020 1_S23,524,906 524,010.205 1 $24,490,538 $25.105,128 7-1
95 SURPLUS!(DEFICIT) vs, DESIGNATED RESERVE: $27,568,437 $13,008,509 $9,568,401 $7,536,782 $8,422,551 $8,765,513 $10,334,879 $8,219,138
96 OPERATING RESERVE (Goal: 25% of Operating)' $3,873,261 54,041,079 $4,193,884 _$4,323,682 $4,462,006 $4,606,3451 $4,763,082 $4,945,787
L97 CAPITAL RESERVE (Goal: $2,000,000) $2,000.000 52,000,000 $2,1100,000 $2,000,000 $2,000,000 $2,000,000 1 $2.000,000 $2,000,000
SURPLUSI(DEFICIT) vs. ALL RESERVES $21,695,176 56,967,431 53.374,516 51,213,100 $1,960,545 52,159,168 $3,571,797 S1,273,350
' 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 utility-
Attachment A
A B R
1
2
3
4
5
6
7 UNAPPROPRIATED FUND BALANCE
8 Beginninq of Year Fund Balance
9
10 SOURCES OF FUNDS _
l 1 Operating-!
Sale of Water to General Cust
13 Projected Rate Increase 3%
14 Bulk/lrrigation Water Sales
15 Hydroelectric Revenue
16 Miscellaneous Operating Revenues
17 TOTAL. OPERATING SOURCES OF FUNDS
18 - -
19 Non-Operating-
20 Plant Investment Fees
21 Connection Charges
22 Special Assessments
24 Interest on investments _
25 Rent. assessments and other misc revenues
26 Sale of Real Estate - Yards Masterplan
27 Transfer from General Fund - Fire Training Center
28 Projected Bond Proceeds
29 TOTAL NON-OPERATING SOURCES OF FUNDS
30
31 TOTAL SOURCES OF FUNDS
K-
3.3 USES OF FUNDS
34 Operating Expenditures-_
35 Administration
36, Planning and Project Management
37 Water Resources and Hydroelectric Operations
_
38 Water Treatment
39 Water Quality & Environmental Svcs
40 Water Conservation
1 System Maintenance
42 Windy Gap Payment
43 Proposed Tier 1 Items
44 Proposed Budget Supplementats
45 Nederland W WTP Operations
48 Emergency Reserve
49 Sick/Vacation Accrual
50 TOTAL OPERATING USES OF FUNDS
51
52 Debt-
53 BRWTP 1996 Revenue Bond: Refunding in 2005 I
54, Refunding of the 1999 and 2000 Revenue Bonds
55 Lakewood Pipeline 2001 Revenue Bond
56 Arbitrage Payment
61 TOTAL DEBT SERVICE
62
63 Transfers Out--
64 Cost Allocation
65 Planning & Development Services
66 Other Transfers
67, TOTAL TRANSFERS OUT
68
69 Capital Improvements Program--
70 TOTAL CAPITAL USES OF FUNDS
71
77 ENCUMBRANCES. CARRYOVERS & MID-YR ATB's
78 F-
79 TOTAL USES OF FUNDS
80
81 Emergency Reserve Adjustment
82 Sick/Vacation Accrual Adjustment
83
84 FUND BALANCE • END OF YEAR
85
86 Designated Reserves -
87 Bond Reserves
88 Lakewood Pipeline Remediation Reserve
89 Lakewood /USFS Damage Claims Reserve
90 Future Caoilal Projects Reserve
91 Vacation/Sick/Bonus Liability _
OF - Pay Period 27 - 2013 Reserve
93 TOTAL RESERVES
94
95 SURPLUS/(DEFICIT) vs. DESIGNATED RESERVE:
96 OPERATING RESERVE (Goal: 25% of Operating)
97 CAPITAL RESERVE (Goat: $2,000,000)
98 SURPLUSI(DEFICIT) vs. ALL RESERVES
99 ~
104 " Reserve levels are based on industry standards and ar
Attachment A
A C D E F G H I J K
1 CITY OF BOULDER
- I _ 12-May-09
2 2010-2015 CAPITAL IMPROVEMENTPROGRAM I
3 WATER UTILITY FUND
4
5 - - 1 l -
6 Assumed Inflation Rate I ESTIMATED 1 2008 2009 2010 2011 2012 2013 2014 2015
7 PROJECT NAME 1 2008 COST ACTUAL I REVISED ',ECOMMENDE PROJECTED! PROJECTED PROJECTED I PROJECTED PROJECTED
8
9 Treated Water Pressure Reducing and Hydroelectric Facilities
10 Maxwell Hydro/PRV Station $o 1 $0 1 $0 $0 SO SO $0 $o
11 Kohler HydrolPRV Station so $0 1 $0 SO $0 $0 $0 $0
12 Sunshine H drol-PRV Station $0 SO $0 1 SO $0 $0 $0 SO
13 Orodell H dro1PRV_Station $4,392 SO 50 $0 $0 $0 $0 $0
14 Sunshine H drolPRV Station - $0 SO I SO $0 $0 $0 $0 $0
15 Pearl Street H drolPRV Station $200,000; 50 SO I $0 SO_ $0 $0 $0 $0
16 Treated Water Pressure Reducing and Hydroelectric Facility F 500 SD $0 SO I $0 SO SO 1 $65,463
17 Subtotal - Treated Water PRV and Hydro $4.392 50 $0 $0 SO $0 $0 $65,463
18 I
19 Water Treatment Facilities
20 Betasso WTP $191,475 , 5420,892 5205.000 $100,000 $100.000 S100,000 SO 59743.580
21 Betasso WTP - Bond Proceeds $7,500,000 SO 5o $0 SO SO 50 (SO) so
22 Bond Issuance Costs $O $0 $0 50 $0 $0 SO 5o
23 Boulder Reservoir WTP S3,000,0001 $300,001 $3,890,447 $100,000 $50,000 550,000 $50.000 550,000 $0
24 Boulder Res WTP - Bond Proceeds $o $0 $0 50 $0 $0 $0 $0
25 Water Treatment Facility Rehabilitation so $0 $0 1 50 50 I $0 $0 $0
26 Subtotal -Water Treatment Facilities $491,476 54,311,339 5300,000 I $150,000 1 $150,000 I $150,000 1 $50,000 5978.580
27 - -
28 Treated Water Pump Stations
29 _Cherryvale Pump Station $500.000 $20,790 $553,610 SO SO $0 $0 SO SO
30 Boulder Reservoir Him Service Pump Station I SO $0 SO $0 $0 $0 SO SO
31 Iris Pump Station $1,000,000 $44,071 51,574,415 SO So 5o I $01 Sol SO
32 Treated Water Pump Station Rehabilitation I So $0 SO $0 I 50 SO $0 S0
33 Subtotal -Treated Water Pump Stations I $64,861 $2,128,025 SO $0 I SO SO $la $0
34 1
35 Treated Water Stove Tanks _
36 Kohler Storage Tank 5920,0001 SO $0 $0 $0 f $0 : $0 $113,148 51,131,484
37 Chautauqua Storage Tank $785,000 $287,119 $0 $85,779 $857,791 1 $0 $0 $0 50
38 Maxwell Storage Tank- 5920,000 50 $0 _$0 $0 i $0 1 $0 _ SO $0
39 Betasso Storage Tank 5250.000 SO $0 $265,225 $o $0 SO SO SO
40 Gunbarrel Storage Tank $250.000 564,156 $8,667 $0 so $0 $289,819 SO $0
41 Devil's Thumb,; orage Tank I $350.0__00 _ $42,163 $0 1 $0 $0 $0 SO 1 $0 $0
42 Boulder Reservoir Storage Tank I $0 $0 1 SO SO $0 $0 1 $0 $0
43 Booten Storage Tank SO $0 SO $o so SO SO $0
44 Treated Water Storage Tank Rehabilitation 1 $0 $0 $0 $0 $o $0 $0 S161,132
45 Subtotal - Treated Water Storage Tanks I S393,438 $8.667 $351,004 $857,791 SO 1 $289.819 5113.148 $1,292,616
461
47 Treated Water Distribution System I I
48 Zone Isolation Valves ! $2,652 $4,346 $0 $0 $0 ( $0 $0 $0
49 Cathodic Protection I $0 $200,000 $0 $0 So so $0 $0
50 Waterline Replacement $2,029,353 $3,395,867 $2,227,890 `61 52,434.476 52,507,510 $2.582,735
51 Subtotal - Treated Water Distribution S tem 1 $2,032,005 $3,600,213 $2,227,690 $2,294,727 $2,363,569 $2.434,476 $2,507,510 $2,582,735
52
53 Treated _Water Transmission System
54 W Boulder Canyon - Fourmile to Pearl $0 $0 SO $0 $0 $0 SO SO
55 Sunshine Transmission Pipe $800,000 $0 ' $200,000 So $0 $0 $927,419 $0 . $O
56 Betasso to Orodell Transmission Pipe SO SO SO : $0 $0 $0 $0 SO
57 Zone 1 Transmission Facilities $500,0001 $0 SO $0 $0 $0 $0 $0 So_
58 Zone 2 Transmission Facilities 5500,000 52,114 $0 $0 $0 $0 $0 SO $0
59 Zone 3 Transmission Facilities S500,0001 $0 $0 $0 $0 $0 $0 $597._026_ _ SO
60 Boulder Canyon - Orodell to Fourmile $500,0001 $0 _SO $0 $546,364 $0 1 $0 SO $0
61 Zone 21 Zone 3 Pressure Modifications $0 SO $0 $0 $0 $0 SO SO
62 Subtotal - Treated Water Transmission System I $2.114 $200,000 $0 S546,364 SO 1 $927,419 $597,026 50
63
64 Source Water Transmission System 65 Lakewood Pipeline- - - I $155,2.8_7 $103,559 $100,000 $0 _$1,238,060 $0 $119,405 I SO
66 Lakewood Pipeline - Non-Conformin Pipe Capital $0 50 SO $0 $0 $0 $0 1 $0
67 Lakewood Pipeline - Non-Conforming Pipe Operating $0 SO SO $0 $0 SO $0 $0
68 Lakewood Pipeline Welds $0 SDI SO 1 $0 $0 SO I $0 $0
69 Lakewood Pipeline Settlement/ Nation $0 _SO $0 $0 1 $0 $0 $0 $_0
70 Silver Lake Pipeline $~0_.I _ So $0 $0 $0 $0 $0 1 $0
71 Source Water Transmission Pi Inspections $o 1 $80,(3001 So ! $0 $80,000 $0 $0 $0
72 Subtotal - Source Water Transmission System $155,287 $183,559 $100,000 $0 1 $1,318,060 $0 $119,405 $0
73 I !
74 Barker Water System
75 Barker Gravity Pipeline Repair $20,000,0001 $687.896 $413,981 $371,315 $382,454 $393,928 $405,746 $417.918 $922,405
76 Barker-Kossler Pen_stoc_k Repair $100,0001 $0 50 $0 $0 _ $0 SO $0 $0
77 Barker Dam Outlet $0 $0 SO $0 $0 $0 S0 S804,33C}
78 Barker Dam Outlet - Bond Proceeds 57,055,000 $0 $0 $0 $0 $0 50 $0 So
79 Barker Dam_ 5350,0001 _$0 _SO_ SO _I $ 2U.000 $0 SO $0 $430,456
80 Barker Hydro System Integration ; S112,515 S740 SO $0 $0 SO $0 ^$0
81 Barker Relicensing S126,030 $1,1_45,297 SO $0_ _ $0 I SO $0_ $0
82 Barker Instream Flow Release _ $0 5152,949 SO $0 $0 $0 $o so
83 Betasso Penstock 5749,300 $2,6.82,157 SO SO $0 $0 $0 $0
84 Barker Source Water Protection $0 $0 $0 $0 $0 $0 $0 $0
85 Kossler Reservoir 1,200,000 1 $0 $0 $360,706 $939,745 $0 So SO I SO
86 Subtotal - Barker Water System $1,675,741 $4,395,124 5732,021 51.442,200 $393,928 1 $405,746 5417,918 $2,157,197
87
88 Raw Water Storage Reservoirs
89 Albion Dam ! 53,075,000 $0 I SO $0 $0 $0 SO I $0 $_92,241
90 Silver Lake Dam $0 $o $0 $10_ $0 SO 1 $0 $0
I
91 Island Lake Dam ! $105,0001 SO $108.150 $0 1 $0 I $0 50 I - SO - $0
92 Green Lake 1 Dam I I _ $0 $_0 $0 1 SO $0 . So I 5o $0
93 Green Lake 2 Dam $3,875,0001 $0 $0 $0 $o $o $86,946 $0 $0
94 Green Lake 3 Dam SO SO $0 $0 SO SO 1 $0 SO
95 Goose Lake Dam $0 $0 $0 $0 $0 $o $0 50
96 Boulder Reservoir $90,000 $0 $0 $0 1 $0 SO 5o 1 $0 SO
97 Lakewood Reservoir _ $102,500 $0 $0 $0 $0 SO SO SO SO
98 Skyscraper Dam 125.000 50 $0 SO SO I SO 1 SO 50 50
99 Wittem er Ponds 4,000,000 So $0 SO i $o $0 50 SO SO
100 Subtotal - Raw Water Storage Reservoirs f so $108,150 $0 $0 SO 586,946 SO $92,241
101
102 Other Raw Water Facilities
103 Farmers Ditch so SO $0 50 $0 $0 $0 $0
104 Anderson Ditch so SO $0 $0 ! $0 $0 $01 $0
105 ^Watershed Improvements $440,5001 $0 $0 $o $3.17,437 $0 $0 $o $92,241
106 Nederland WWTP T $300.000 SO $0 $0 $0 So SO
107 Instream Flow Structures and Ga 50 $0 So $50,000 $0 SO $01 50
108 Como Creek Diversion Structure $0 $0 So $0 $0 $o 5o I SO
109 Lakewood Diversion Structure $0 $0 $o $0 $0 50 SO SO
110 Silver Lake Diversion Structure $0 $0 so 1 $0 $0 SO $0 SD
111 NCWCD Conveyance - Boulder Feeder Canal 5283,0001 $19,432 $321,321 $300,235 $O $0 $o SO SO
112 NCWCD Conveyance - Carter Lake Pipeline $225 $1,118.525 SO SO . 50 So SO SO
Attachment A
A C D E F G H I J K
1 CITY OF BOULDER 12-May-09
2 _ 2010 - 2015 CAPITAL IMPROVEMENT PROGRAM
3 1 WATER UTILI I Y FUND 1
4
6 Assumed Inflation Rate ESTIMATED 2008 2009 1 2010 2011 2012 2013 2014 2015
7 PROJECT NAME 2008 COST ACTUAL REVISED ;ECOMMENDE PROJECTED PROJECTED PROJECTEQ PROJECTED PROJECTED
113 NCWCD Conveyance - Bond Proceeds $25,000,000 $0 $0 $0 $0 $0 $0 $0 $0
114 Subtotal -Other Raw Water Facilities $19,657 $1,739,846 $300,235 $367,437 $0 $0 1 $0 1 $92,241
115 i I I I I
116 Source Water Pressure Reducing, Pumping and Hydroelectric _
1 17 Lakewood Hydroelectric $0 $0 $0 $0 $0 $0 ;
119
$$0 $0
- -0 $0
11$ Silver Lake Hydroelectric SO $0 $0 $0 $0 $0
0
Boulder Reservoir Intake and Pumping $0 $100,000 $0 $0 SO $0 $0 $0
120 Betasso Hydro PRV Station $0 $215,826 $0 $0 $0 $0 j $0 $0
121 Barker Dam Hydro ' $3.300,0001 $0 $0 $0 $0 $0 $0 $0 $0
122 Boulder Canyon Hydro $4,300.000 _ $0 $0 $0 $0_ $0I $0 $0 $0
123 Source Water Pressure Reducing, Pumping and Hydroelectric . $0 $0 1 $0 $0 $0 $0 $0 $218,432
124 Subtotal - Source Water PRV, Pumping and Hydro j $0 $315,826 $0 $0 $0 1 SO $0 $218.432
125 -
126Water Distribution System Expansion
127 Annexation Related Water S stem Expansion I $D 5525.000 . $0 $0 $0 $0 $0 $0
'128 Subtotal - Water Distribution System Expansion I $0 $525,000 I $0 $Q 1 $0 1 $0 $01 $0
129 _
130 Water System Monitoring and Metering
1311 Automated Meter Reading $500,000 $0 $500,000 $530,450 $546,364 $562,754 $579,637 $0 $0
132 Water System Security Upgrades $164,343 $101,438 $100,000 $100,000 $100,000 $0 $0 $0
133 Distribution System Water Quality $186,130 $_192,_600 $150,000 $150,000 $0 $0 l $0 ! $0
134 Data Communications System $0 $0 $0 $0 $0 $0 $0 $0
135 Yards Master Plan Implementation $477,448 $242,387 $0 $0 $0 $0 $0 $0
136 Utility Billing Computer system Replacement $41,958 $39,550 1 $0 $0 $0 $0 $0 i $0
137 Subtotal -Water System Monitoring and Metering 98791 $1,075,975 $780,450 $796,364 f $662,754 _ $579,637 $0 I $0
138
139 TOTAL CAPITAL USES OF FUNDS $5,708,850 $18,591,724 $4,791,600 l $6,454,881 $4,888.311 $4,874,042 $3,805.008 ' $7.479.504
Attachment B
A B C D E F G H l J K L M N O P Q R
7 CITY OF BOULDER 12-May-09
2 2010 FUND FINANCIAL Draft
3
4 WASTEWATER UTILITY FUND _
1__ - -
5 2008 2009 _ 2010 2011 2012 2013 _ 2014 2015
6 ACTUAL REVISED RECOMMENDED PROJECTED PROJECTED I PROJECTED PROJECTED PROJECTED
7 UNAPPROPRIATED FUND BALANCE
8 Beginning of Year Fund Balance $22.576.055 $14.724,357 $10.589,196 $9.729.224 $8,7927801 ~-$7.371.461 $6.805,549 $6.848,866
10 SOURCES OF FUNDS I
11 d eratin --i~ _
12 Sewer Charges to General Customers $12,404,751' -!V2,709,892 $13,372,078 $13,666,798 $14,104,956 $14,557,161 T$15,169.7261 $16,112,069
13 Projected Rate increase $0 3% $635,495 5% $267,442 2% $410,004 3% $423,149 3% i $582,286 4% $910,184 6% $966,724 6%
14 Surcharge/Pretreatment Fees $131,862 $131,000 $133000 $133.000 _ $133.000 $133.000 $133.000 $133.000
- -
15 Cogeneration Revenues $39,721 1 $0 $0 $0 $0 $0 $0 $0
16 TOTAL OPERATING SOURCES OF FUNDS $12,576,334 $13.476,387 $13,772,519 1 $14,209.802 $14,661,104 $15,272,447 , $16.212,909 $17,211,793 f
17 J
18 Nan-Operating- _ I -1-
19 Plant Investment Fees $778,234 $500,000 $600 npQ SF00=nn0 $gpp pop $750,000 : I $750.000 Y75n nnn
20 Connection Charges $6.987 $11.500 $10,000 $10.000 $10.000 $10,000 i $10.000 $10,000 21 Special__- .Assessments 53,671 $5,000
$5,000 $5.000 $5,000_ $5,0001 $5,000 $5,000
23 Interest on Investments $848,546 1 $389,575 $363.209 _i $291,877 $263.784 $221.144 $204.166 $205.466
24 Rent and other miscellaneous revenue $84,343 $29,500 $29.5001 $1.5001 $1.500 $1,500 $1.500 _ $1.500
25 Sale of Real Estate Yards Master fan $0 $125,000 $0 $0 $0 $0 $0 _ $0
26 Transferfrom Other Funds $120,000 $230,000 $0 $0 $0 ii $0 $0 $0 I~
27 Projected Bonds $0 $0 1 $8.605.438 so 50 1 $D 30 $0
219 TOTAL NON-OPERATING SOURCES OF FUNDS $1.841,781 $1.290,575 1 $9.613,147 1 $908.377 $880.284 $987.644 1 $970,666 $971,966
29
30 TOTAL SOURCES OF FUNDS $14,418,115 $14,766,962 $23,385,667 $15,118,179 $15,541,388 $16,260,091 $17,183,576 $18,183,759
31
32 USES OF FUNDS
33 Operating Expenditures--
34 Administration $490.560 $490.123 $504.827 $519.971 $535.571 $551.638 j $568,187 $585.232
35 Planning and Project Management $370,887 $356.220 $366.907 $377,914 1 $389.251 $400.929 $412,957 $425.345
36 WastewaterQualitv-& Environmental Svcs SR85.992 $968 353 $997,404 $1,027,326 $1,058.145 _ $1.089.890 $1.122.587 _$1,156.264
37 S_stem Maintenance $1,642.852 $1.658,602 $1.708,360 $1,759.611 $1,812,399 $1.866.771 $1,922,774 $1.980.458
38 ~jagtonatar7raatmcnt I $5,357,251 $5,336,769 1 $5,496,872 $5,66l.778 $5,831,6_32 $6.006,581 $6,186,778 $6,372,381
39 Proposed Tter iItems - $0 - $0 - $32,900 - $9,682 $9.972 $10,272 $10,580 JU$10.897
40 Proposed Budget Su lementals $0 $0 1 $107,766_ $74449 $77,197 1 $79.513 1 $81.899 I $84,356
41 WWTP Biosolids Digester Improvements $0-I $0 1 $0 $65.000 $66.950 I $68.959 $71 ,027 $73,158
43 Emergency Reserve $0 I $265,000 1 $272,950 $281,139 $289.573 1 $298,260 $307,208 $316 424
44 SickNacation Accrual $19.916 1 $75.000 1 $77,250 $79.568 ~i S81.955 $84.413 j $86.946 $89.554
45 TOTAL OPERATING USES OF FUNDS Su8,767,458 1 $9150,067 $9,565,235 $9,856.937 1 510,152.645 $10.457,225 1 $10,770.941 $11.094.070
46
-1 -
47 Debt--
4$ WWTP Improvements 2005 Revenue Bond 1 $3,565.944 $3.557,523 1 $3,556,583 1 $3.550.367 1 1 $3.545.533jvh $3.544.883 $3.543,496 $3,519,913
49 2005 Refunding of the 1992 Marshall Landfill Bond $170.057 $170.331 1 $165.456 $165.568 5175,454 $0 $0 SO
50 Arbitrage Payment 1 ($13,070) $3,907 $0 SO ~i $0 SO.. $G ,l SQ
51 Projected Bond - WWTP UV Disinfection I $0 $0 $393,865 $393,865 5393,865 $393,865 $393,865 1 $393,865
52 Projected Bond - WWTP Biosol ids Diaester f $0 . ri $0 $356.187 $356.187 5356.187 $356.187 $356.187 $356,187
55 TnTAI OFRT SERVICE i $3,722,931 1 1 $3,731,761 $4472.091 1 $4,465.987 $4,472.039 34.294.935 $4,293,548 1 $4,269.965
56
57 Transfers Out-- - - l - - _
$787,268 $'794,683 $802,099 $882309 j X570.540 $1067594 $1,174,353 $1291.788
5$ Cost Allocation
59 Planning & Development Services $178,560 $183.9i7 $1,39.435 $195,118 - 52.00.972 $207,401 $213,211 1 Q219,607
60 TOTAL TRANSFERS OUT $965,828 $978,600 $991.534 $1,077,427 51,171,512 $1,274,59 $1.387,564 $1,511,395 j
61
62 Capital Improvements Program-- ! I
63 TOTAL CAPITAL USES OF FUNDS $2.882.277 $2.825.340 _$961.540 $1,014.957 $1,538,060 $1.181,921 $1,082,359 $2,548,585
64 i 1!
65 BOND-WWTP IMPROVEMENTS $5,951,235 $173_,_650 $0 1 $0 $o 1 $0 $0 $0
fib PROJECTED BOND-BIOSOLIDS DIGESTER $0 SO $4,000,000 $0 $0 $0 $0 $0
67 PROJECTED BOND-UV DISINFECTION $0 $0 $4,434,562 $0 $0 $0 1 $p $0
70 BOND - ISSUANCE COSTS $0 $0 $170,876 $0 $0 $0 1 $0 . I $0 1
71 CARRYOVERS. ENCUMBRANCES & MID-YR ATB $0 -j $2,382,705 SO I $D $0 SD $0 $0
72 j
73 TOTAL USES OF FUNDS $22,289,729 $19,242,123 $24,595,838 $16,415,308 $17,334,256 $17,208,676 $17,534,412 $19,424,015
74 1 1 1 _ 1
5316,424
75 Emergency Reserve Adjustment $0 $265,000 - $272.950 $281.139 $289,573 $2981.260.. _ $307,208
76 SicklVacationAccrual Adjustment - $19,96 $75,000 $77,250 79,568 $81,955 $84.413 $86.946 $89.554 1
i - -
77
78 FUND BALANCE - END OF YEAR $14,724,357 $10,589,196 $9,729,224 $8,792,801 $7,371,461 $6,805,549 $6,848,866 $6,014,589
79
80 DeGIOnated Reserves - - - I -
81 Bond Reserves $170.250 5170.250 S170,250 - 1 $170.250 1 1 $0 1 $0 $0 $0 I
82 SickNacation/Bonus Liability $661552 I $683,459 $703,962 1 $725.081 1 1 $746.834 1. $769,239 $792.316 $816.085
83 Pay Period 27 - 2013 Reserve $57.598 1 $a x:598 $129.598 $165.598 1 $201.598 $237.598 $273,598 1 $309.598
84 TOTAL RESERVES $891.400 1 TS947.307 _S1.003.810 $1,060,929 $448.432 $1.006,837 191,065.914 $1,125.683 1
85
86 SURPLUS/(DEFICIT) vs. DESIGNATED RESERVE $13,832,957 $9,641,889 $8,725,414 $7,731,872 $6,423,029 $5,798,712 $5,782,952 $4,888,905
87 OPERATING RESERVE {Goal:25% of Operating) $2,433,322 $2,532,167 $2,639,192 $2,733,591 $2,831,039 $2,932,955 $3,039,626 $3,151,366
88 CAPITAL RESERVE (Goal: $500,000) S50Q000 1 $500,000 1 $500,000 $500,000 1 $500,000 $50Q000J $500,000 $500,000 1
89 SURPLUS/(DEFICIT) vs. ALL RESERVES $10,899,636 $6,609,722 $5,586,222 $4,498,281 $3,091,990 $2,365,758 $2,243,326 $1,237,539
90
9 ' 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 utility.
Attachment B
A C D E F G H I J K
1 CITY OF BOULDER
- - 12-May-09
2 2010 - 2015 CAPITAL IMPROVEMENT PROGRAM
3 WASTEWATER UTILITY FUND
4
6 Assumed Inflation Rate ESTIMATED 2008 2009 2010 2011 2012 2013 2014 2015
7 PROJECT NAME 12008 COST ACTUAL REVISED RECOMMENDE( PROJECTED PROJECTED PROJECTED i PROJECTED PROJECTED
8
0 Wistewater Treatment
SO $0 $150,000 SO F $150.000 ~ SO $150,000
11 WWTP Permit Improvements $572,876 $345,859: $0 $0 $0 $0 ' $115,927 $0
12 WWTP Permit Improvements - Projected Bor $10,000,000 $0 $0 $0 $0 $0 $0 $0 $0
13 WWTP Laboratory $0 $0 $0 $0 $0 $0 $0 $0
14 Lower Boulder Creek Enhancement 1 $0 $0 $0 $0 -s-01 $0 $0 $0
15 WWTP Headworks $0 $300,000 $0 $0 I $0 $0~ $0 $1,560,661
16 WWTP Headworks - Projected Bond $12,320,000 $0 $0 $0 $0 $0 $0 $0 $0
17 WWTP Instrumentation/Control $0 $0 $75,000 S100000 $0 $0 $0 $0
18 WWTP Electrical $0- $0 $0 $0 $0 $100,000 1 $100000 $100000
19 WWTP Activated Sludge $0 $0 $0 $0 $0 $67.531 $0 $0
20 WWTP Primary Clarifiers $0 $0 $0 $0 $300,000 $0 $0 50
21 WWTP Secondary Clarifiers $0 $200,000 $0 $0 $0 $0 $0 $0
22 WWTP UV Disinfection $0 $443,456 $0 SO $0 $0 $0 $0
23 WWTP UV Disinfection - Projected Bond $4,180,000 $0 $0 $4,434,562 $0 $0 $0 $0 $0
24 WWTP Permit Improvements - Bond Proceeds $5,951,235 $173,650 $0 $0 $0 $0 $0 $0
25 Wastewater Treatment Rehabilitation $0 $0 SO SO $0 $0 $0 SC
26 Bond Issuance Costs $0 $0 $170,876 $0 $0 $0 $0 $0
27 Subtotal - Wastewater Treatment Plant $6,524,111 $1,462,965 $4,680,438 $250,000 $300,000 $317,531 $215,927 $1,810,661
2$ - - - -
29 Marshall Landfill
30 Marshall Landfill $0 $0 $100,000 $0 $0 $0 50 $0
31 Subtotal - Marshall Landfill $0 $0 $_100,000 1 $0 $0 $0 50 $0
32
33 Biosolids Recycling
34 Valmont Butte $282,049 _$434,940 $0 $0 $0 $0 $0 $0
35 Bjosoljds Handling & Dewatering $698,495 $106,270 $0 I $0 $0 $0 I $150,000 $0
36 WWTP Biosolids Digester $0 $983,074 $0 $0 $0 1 $0 $0 $0
37 WWTP Biosolids Digester- Bond Proceeds $7,370,000 $0 $0 $4,000,000 $0 $0 $0 $0 $0
38 WWTP Cogeneration $0 S200,000 $0 $0 $0 $168,826 $0 $0
39 WWTP Digester Complex $0 $50,000 $0 $0 $0 $0 $0 $0
40 WWTP Digester Cleaning $0 $0 S150.000 1 $0 SO ! $0 $0 $0
41 Subtotal - Biosolids Recycling $980,544 $1,774,284 $4,150.000 $0 $0 $168,826 1 $150,000 $0
42
43 Wastewater Svstem Monitoring and Metering
44 Yards Master Plan Implementation ~ $238,785 $121,215 $0 $0 $0 $0 1 $0 $0
1
45 Automated Meter Readina $0 $0 $0 $0 $0 $0 $0 $0
46 Utility Billing Computer S stem Replacement $10,920 $69.284 $0 $0 $0 $0 I SO $0
47 Subtotal - Monitoring and Metering $249,705 $190.499 $0 $0 $0 $0 SO $0
48
49 Collection and Conveyance System Rehabilitation
50 Collection §ystem Monitoring $0 1 $0 $0 S53,045 $0 $0 $0 $0
,51 Sanitary Sewer Rehabilitation 5914,904 $803,946 $530.450 $546,36,1 $562,754 $579,637 $597,026 5614,937
52 Sanitary Sewer Manhole Rehabilitation 1 $164,248 1 $100,000 1 $106,090 $109,273 $112.551 $115,927 $119,405 $122,987
,53 IBM Pump Station $500mol $0 1 $0 $0 $56_ ,275 $562,754 $0 $0 $0
54 Tier 1 Boulder Creek 2 Master Plan Project ' 5733.000
55 Tier 1 Goose Creek 1/1A Master Plan Project S1,203,0001
56 Tier 1 Goose Creek 3 Master Plan Proiect $482,000
57 Tier 1 Goose Creek 5 Master Plan Pra'ect 52,559,000
58 Tier 2 Boulder Creek 1 Master Plan Project $1,653,000
59 Tier 2 Boulder Creek 3 Master Plan Project $1.939.000
60 Tier 2 Boulder Creek 4 Master Plan Project $12,356,000
61 Tier 2 Goose Creek 4 Master Plan Project $3.928,000
62 Tier 2 Gunbarrel 1 Master Plan Project 51.116.000'11
63 Tier 2 Gunbarrel 2 Master Plan Pro ect 1 $939,0001
64 Tier 2 South Boulder Creek 1 Master Plan Pr $733,000
65 Subtotal - Sewer System Rehabilitation $1,079,152 $903,9461 $636.540 $764,957 $1,238,060 5695,5641 $716,431 $737,924
66 - - - - -
67 Wastewater System Expansion
68 Annexation Related WW System Expansion $0 $717,893 $0 $0 $0 $0 ' $0 $0
69 Subtotal - Wastewater S stem Expansion $0 $717,893 $0 $0 $0 $0 $0 $0
70 -1
71 TOTAL CAPITAL USES OF FUNDS $8.833.512 55,049,587 $9,566,978 $1,014,957 $1,538,060 $1,181,921 $1,082,359 $2,548,585
72 -
Attachment C
A B C D E F G H I J K L M N -F-0 P Q R
1 CITY OF BOULDER 12-Ma -09 1
2 2010 FUND FINANCIAL i I Z ft,
_
3 1 STORMWATERIFLOOD MANAGEMENT UTILITY FUND
4
5 2008 2009 2010 2011 2012 2013 2014 2015 _
6 ACTUAL REVISED RECOMMENDED PROJECTED I PROJECTED PROJECTED PROJECTED _ PROJECTED
7 UNAPPROPRIATED FUND BALANCE _ _
8 Beginning of Year Fund Balance $10.753,587 I $12,777,970 $5.008,892 $5,067,330 _
$4,667,373 $3,381,2031 I $3,488,584 $3,643,502.
10 SOURCES OF FUNDS
11 Operating-- - - j j I
12 Service Charge Fees $4,920,892 $4,812,655 $4,966,949 $5,076,421 $5,239,171 $5,407,138 $5,580,491 $5,759,402
13 Projected Rate Increases $0 3% $144,380 3% $99,339 2% $152,293 3% $157,175 3% $162,214 3% $167,415 3% $172,782 3%
14 TOTAL OPERATING SOURCES OF FUNDS $4,920,892 $4,957,035 I $5,066,288 $5,228,713 $5,396,346 $5,569,353 f $5,747,906_ $5.932,184 j
16 Non-Operating-- i -I I -'i - -
17 Plant Investment Fees $656,811 1 1 $500,000 $600,000. $650,000 $700,000 $900,000 $900,000 1 $900,000 1
18 Urban Drainage Distract Funds $861,776 1 $260.000 $400,000 $400,000 $400,000 $400,000 $400.000 i I $400.000
- -
19 Colorado Dept of Transportation Funds $1,265,759 1 $1,985.241 $0 _ $0 s0 $0 $0 $0
20 State & Federal Grants $24,891 $24,973 $0 _ $0 $0 ~$0 $0 $0
21 Interest on investments $439,292 $153.100 $171,805 $152,020 5140.021 $101,4361 $104,658 i $109,305
22 Intergovernmental Transfers (KICP Pro ram i $117.324 $123.600 $135,000 $145.000 $150.000 $154,500 - - -
I $159.135 i $163?09
23 Rent and other miscellaneous revenue $51,577 531.000 _ I $36:non_ 536,000 $36.000 $36,000 $36,000 $36,000
24 Miscellaneous nonrecurring revenue $104,29_0 _ $0 i $0 $0 $0_I _ $0 1 $01 _ $0
25 Sale of Real Estate - Yards Masterplan $Q $125,000 1 ! 50 $0 $0__ _$0 $0 $0
27 -Projected Bonds $Q $0 1~ $0 1 $0 $3,085.000 $0 $0 50
28 TOTAL NON-OPERATING SOURCES OF FUNDS $3,521,720 $3.192.914-1 $1,342,805 $1,383.020 $4,511,021 1 $1,591,936 $1,599,793 $1,609,214
29 1 1 - - T
30 TOTAL SOURCES OF FUNDS $8,442,612 $8,149,949 $6,409,093 $6,611,733 $9,907,367 $7,161,289 $7,347,699 $7,541,398
31 I
32 USES OF FUNDS
33 Operating Expenditures- I $401998,,415 $ $413.457
34 Administration $341,163 $384,723 $ $451 796 $455,350
35 Planning and Project Management $1,011,535 $969,620 ~i $1,059,530 $1.091,316 $1,124,055 $1,157,777
719 413.457 _
36 5tormwater Contract Management $33,333 $47,993 I $49.433 $50.916-$425 861 $438.637
$52,4431 $54,017 $55.637 $57,306
37 Stormwater Quality and Education 5815,779 $886,746 1 $913,348 $940,749 $968.971 j $998,040 $1.027.982 $1,058,821
- - - -
381 SvstemMaintenance $658,161 $7710101 $794140 $817.965 $84_2,503 $867,779 $893.8121 SP206261
39 Prn posed Tier 1 Items $0 0 : a $4,200 $1,236 $1273 $1,311 S1,351 $1.391
40 Proposed Budget Supplementals $0 $0 557,168 $52,703 $54,284 $55,913 $57,590 $59,318
41 Emergency Reserve 1 $0 $93,000 $95,790 $98.664 $101.624 $104.672 5107.812 5111.047
42 Sk6k acationAccfual ($39.193 $50,004 $51,500 $53,045 S54.636 j 556,275 $57,964 $59,703
43 TOTAL OPERATING USES OF FUNDS $2,820,778 S3,208,092 $3,365,703 1 $3.457.404 I $3,561.126 1 $3,667,960 $3,777.999 $3,891,338
44
- - - -1-
45 Debt-
46 Goose Creek/BVRC 1998 Revenue Bond $806,273 a $810,029 $1,126,036 J $493.531 j $491,872 $494,288 $490,726 1. $491,393
47 Projected Bond - South Boulder Creek $0 5o $0 $o $268,910 $268,910 $268.910 $268,911
49 TOTAL DEBT SERVICE $806,2731 1 $810.029 $1,126,036 $493.531 ]_$760.782 $763,198 $759,636 $760.303
50
51 Transfers Out--
52 Cost Allocation S189.861 $192.6741 $195,486 $215.035 $236,538 $260.192 $286.211 5314.832
53 Planning & Development Services $107,626 $110,855 $114,181 $117,606 $121,134_ _ $124,768 $128.511 _ $132,367 1
54 Other Transfers $15.000 515.000 ' 515,450 - $15.914 _$16,391 $16.883 $17.389 $17,911
55 TOTA1 TRANSFERS OUT $312,487 $318.529 $325,117 $348,554 $374,063 $401.843 $432.111 $465.110 1
56 i
57 Capital lm rovements Program- I I
58 TOTAL CAPITAL USES OF FUNDS $2,439,498 $2,350,000 $1:681490 $2,863,909 $3,568,826 $2,381,855 $2,388,810 ' $2,795,368
59 I
60 PROJECTED BOND - SOUTH BOULDER CREEK $0 $0 $0 I $0 $3,000,000 $0 $0 $0 1
61 PROJECTED BOND - BOULDER TRANSIT VILLAGE $0 $o $o i $0 $0 j $0 $0 SO 1
62 PROJECTED BOND - ISSUANCE COSTS _ $0 $0 __$0 I I $0 $85,000 $0 $0 $0 1
63 ENCUMBRANCES, CARRYOVERS & MID-YR ATBS $0 $9,375,377 SO j $0 $0 $0 $0 $0
64 1 r_1
65 TOTAL USES OF FUNDS $6,379,036 $16,062,027 $6,497,945 $7,163,398 $11,349,797 $7,214,855 $7,358,556 $7,912,119
67 Emer ency Reserve Adjustment $O 593,000 I $95,790 $98,664 $101.624 1 $104,672 $107.812 $111.047
68 SickfVacation Accrual Adjustment ($39,193) $50,000 $51,500 1 $53,045 $54,636 $56,275 $57,964 $59,703
69
70 FUND BALANCE - END OF YEAR $12,777,970 $5,008,892 $5,067,330 $4,667,373 $3,381,203 $3,488,584 $3,643,502 $3,443,531
71
72 Designated Reserves -
73 Bond Reserves $824,715_._ $824,715 , $824,715 $824,715 $824,715 $824.715 $824,715 $824,715
74 Post Flood Property Acquisition $1,050.000 $1,050.000 1 $1.050.000 I $1 050,000 51.050.000 51.050.000 $1,050.000 $_1.050.000
75 SiCkA. aaratln IRonl s Liability $k4,83- $87,378 484 99.y 402 t 94 $45 480 $98 445 $101,295 $104.130
76 Pay Period 27 Reserve- $17,453 $28,453 $39,453 $50.453 $61,453 $72,453 $8'3.453'- $94.453
77 TOTAL RESERVES S1,977,001 $1.990.546 $2,004,167 52,017,867 $2.031,648 $2.045.513 $2.059,463 1 $2.073,502
78 -
79 SURPLUSI(DEFiCIT) vs. DESIGNATED RESERVE $10,800,969 $3,018,346 $3,063,162 $2,649,506 $1,349,555 $1,443,071 $1,584,039 $1,370,029
80 OPERATING RESERVE (Goal: 25% of Operating) 1 $783,316 $11 1,655 $922,705 $951,490 $983,797 _ $_1,017,451 $1,052,528 1 $1,089,112
81 CAPITAL RESERVE (Goal: $200,000) $200,000 i $200,000 $2001000 $200,000 $200,000 j $200,000 1 $200,000 $200,000
82 SURPLUSI(DEFICIT) vs. ALL RESERVES $9,817,653 $1,936,691 $1,940,457 $1,498,017 $165,757 $225,621 $331,512 $80,917
83 I I I I I I I
91 ` Reserve levels are based on industry standards and are maintained for revenue bonds and the capital intensive nature of the utility. l
Attachment C
A C D E F G H I J K
1 CITY OF BOULDER 12-May-09
2 2010-2015 CAPITAL IMPROVEMENT PROGRAM - Daft - _
3 STORMWATER AND FLOOD MANAGEMENT UTILITY FUND
4 - - l
5
6 Assumed Inflation Rate ESTIMATED 2008 2009 2010 2011 2012 2013 2014 2015
7 PROJECT NAME 2008 COST ACTUAL REVISED RECOMMENDEC PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED
8 i J.
-
9 Major Drainageways _
10 Elmers Twomile Creek $1.711,2851 5 140,417 $0_ $0 $0 $0 I $0 $0
11 Goose Creek $0 $0 -.so $0 $0 $0 $0 $0
12 South Boulder Creek $10,252 $442,075 $0 $300.000 $1,250,000 $0 ; $0 , $0
13 South Boulder Creek - Bond Proceeds $0 $0 $0 $0 $3,000,000 $0 $0 $0
14 Bond Issuance Costs $0 $0 $0 $0 $85,000 $0 $0 $0
5 Skunk Canyon Creek $0 # $0 $0 $0 $0 $0 $0 1 $0
16 Sunshine Creek $0 $0 $0 ` $0 $0 $0 $0 J $0
17 Twomile Canyon Creek $0 ` $0 $0_ $0 $0 $0 $0 $0
18 Bluebell Canyon Creek - King's Gulch $0 SO $0 $0 $0 $0 $0 $0
19 Viele Channel SO SO $0 $0 $0 $0 $0 $0
20 Four Mile Canyon Creek $4,585,000 $51,467 $1_,335,095. $250,000 $250,000 1 $250,00_0 $250,000 $250,000 $120,096
21 Bear Canyon Creek $0 $0 $0 $0 $0 $0 $0 $0
22 Gregory Canyon Creek $0 SO ; S25.000 $2Y,)JMD $0 $0 $0 $0
23 Boulder Creek $99,999 $100,001 1,5n Cann 1 $0 $0 $0 $0 $0
24 Wonderland Creek $19,536,000 $11,108 $819,410 ! $250,000 $500,000 $500,000 $500,000 $500,000 $837,852
25 Preflood Acquisition $0 $1,499,700 $500,000 $500,000 $500,000 $500,000 j $500,000 $515,000
26 Greenwa s Program $168,980 $645,270 ; $150,000 $150,000 $150,000 $150,000 $150,000 $154,500
27 Subtotal - Major Drainageway Improvements 1 $2,053,091 $9,981,968 $1,225,000 $1,950,000 $5,735,000 $1,400,000 $1,400,000 $1,627,448
28
29 Miscellaneous _
30 Yards Master Plan Implementation 1 $238,175 $134,642 $0 $00 $D $0 f $0
31 Utility Billin Computer System Replacement j $8,400 $33,053 $0 $0 I $0 $0 $
9 0 I $0
32 Subtotal - Miscellaneous Drainage Improvements $246,575 $167,695 $0 $0 $0 $0 $0 ; $0
33
34 Stormwater Management _
35 Upper Goose Creek $10,700,0001 $0 $0 $10_0,000 $500,000 $500,000 $500,000 $500,000 $552,983
36 Stormwater Quality Improvements I $0 $50,000 $53,045 $54,636 $56.275 _$57,964 $59,703 561,494
37 Broadway Storm Sewer $0 $900,000 $0 $0 $0 $0 $0 $0
38 Storm Sewer Rehabilitation $0 $50,000 $53,045 $109,273 $112,551 $173,891 $179,108 $245,975
3 Boulder Transit Village $0 $0 $0 $0 $0 50 $0 $0
40 Boulder Transit Village - Bond Proceeds $0 $0 $0 SO $0 $0 $0 $0
41 BVRC Redevelopment $0 $0 $0 _ $0 $0 $0 $0 1 $0
42 Transportation Coordination $139,832 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $307,468
43 Subtotal - Localized Drainage Improvements $139,832 $1.250.000 $456,090 $913,909 $918,826 $981,855 $988,810 $1,167,919
44 -
45 TOTAL CAPITAL USES OF FUNDS $2,439,498 $11,399,663 $1,681,090 j $2,863,909 $6,653,826 $2,381,855 $2,388,810 I $2,795,368
46 I- 1
Ite Opportunity for Improvement Priority Business Costs Within Existing Budget Additional Resource Costs Savings Reflected in Budget
m# Level Plan Water WW Fund SW/FM Water Fund WW Fund SW/FM Water WW Fund SW/FM
Fund Fund Fund Fund Fund
16 Consider conducting an energy audit to review 1-Savings Essential $0 $38,000 SO $0 $0 SO $0 $13,000 SO
new electrical demands as well as review current w/resources Service
sources and uses of energy - Energy audit wil be within budget
completed at WWTP.
23 Operations staff appears heavy at WTP. 24/7 1-Savings Essential $2,400 $0 $0 $0 SO SO $80,000 SO SO
monitoring of distribution system by dedicated w/resources Service
operator seems excessive - An evaluation will be within budget
done. (related to #24)
24 Business case for night monitoring of distribution 1-Savings Essential $39,100 $0 SO $0 $0 $0 $80,000 $0 $0
system, and both plants from Betasso should be w/resources Service
developed - Staff will evaluate. (Related to #23) within budget
12 Digitize project records to ensure information is I-Savings Essential $13,000 $13,000 $6,500 $0 S0 $0 $20,000 $20,000 $10,000
not lost and provide methods to easily access this w/resources Service
information. - A project tracking database and within budget
procedures has been implemented.
19 Management needs to make a business case for 1-Savings Essential $0 $1,440 $0 $0 SO $0 $0 S80,01)0 $0
purchasing of environmental lab equipment and w/resources Service
continue to review analytical request to ensure within budget
only necessary and relevant work is completed -
"business case evaluation" will be done for metals
analysis work to see if in-house or outsourced.
22 Maintenance Computerized Maintenance and I-Savings Essential $17,700 SO $0 $0 $0 $0 $5,000 $0 $0
Management System (CMMS) not happening - w/resources Service
Staff started using system in Dec. 2008. within budget
26 Corrosion resistant bolts not always used on I-Savings Essential $10,600 $0 SO $0 $0 $0 $2,500 $O s0
buried applications - city's design standards need w/resources Service
to be edited so new installations have this within budget
requirement.
9 Flexibility in replacement of lines should be used 1-Savings Desirable $8,000 $8,000 $4,000 $0 SO $0 $16,000 $16,000 $8,000
to establish priorities - Implement improvements to w/resources Service
decision tool used to prioritize. within budget
11 Produce as-built drawings in a timelier manner so 1-Savings Desirable $13,000 $13,000 $6,500 $0 SO SO $20,000 $20,000 $10,000
GIS maps can be accurately updated with new w/resources Service
facilities- staff has several ideas to address issue. within budget
A decision will be made during 1st quarter of
2009.
6 Supervisors need to observe practices of 2-No Essential $8,122 $8,122 $1,037 $0 $0 SO $0 $0 $0
subordinates - consider increasing resources for additional Service
Health and Safety program. savings
13 Develop and implement procedure to ensure 2-No Essential $480 S480 $240 $0 $0 SO $0 $0 $0
management and the public information office is additional Service
informed of shut-off, sewer overflows, breaks and savings
other emergency problems.- Staff will establish
procedures and write a Utilities Division policy.
15 Provide a system to include field collected data 2-No Essential $740 $5,180 $1,480 $0 $0 $0 $0 $0 $0
into the analysis and prioritization of line additional Service
replacement or rehabilitation.- Implement savings
separate asset management system which Utilities
Maintenance staff will provide data to mak
replacement decisions.
17 Integration of work groups will provide greater 2-No Essential $0 $17,000 SO $0 $0 SO $0 SO $0
effectiveness in operating the plant - Consider additional Service
teambuilding skills and training and cross- savings
workgroup collaboration.
18 Plant management is working to establish goals 2-No Essential $0 S960 $O $0 SO $0 $0 S0 $0
and a mission statement for the plant - additional Service
goals/mission statement has been completed. savings
21 Limited communication between maintenance staff 2-No Essential $0 $0 SO $0 $0 SO $0 $0 $0
and operations management - Consider additional Service
communication training and additional resources. savings
27 Field reports not recorded in electronic 2-No Essential $2,400 $0 $0 $0 S0 $0 $0 $0 SO
records/maps - June 2008, the Utilities Program additional Service
Planner started to scan all submitted "utilityfield savings
reports. "
29 Group needs to objectively make a business case 2-No Essential $4,800 SO $0 $0 SO $0 $0 $0 $0
for new programs/projects - staff will do additional Service
cost/benefit analysis to determine if'in house or savings
out-sourced. Currently analyzing source water
nutrient. (related to #19)
4 Enact policy to adopt "near OSHA" standards - 2-No Essential $1,128 $1,128 S144 $0 $0 $0 $0 SO $0
Proposed that city adopt written policy that additional Service
utilities establish a goal of conforming to all savings
OSHA standards.
20 Reallocation of staffing must be considered in 2-No Essential $0 $15,000 $0 $0 $0 SO $0 $0 $0
order to operate the process economically and additional Service
effectively. - Staffing levels will be evaluated in savings
2009-2010 to determine optimal staffing for
Resources Recovery functions.
'Dollars in bold are considered ongoing. Red font is for savings that will reduce future budgets and no change in color is for savings that reduces the existing budget.
Ite Opportunity for Improvement Priority Business Costs Within Existing Budget Additional Resource Costs Savings Reflected in Budget
m # Level Plan Water WW Fund SW/FM Water Fund WW Fund SW/FM Water WW Fund SW/FM
Fund Fund Fund Fund Fund
14 Develop and implement procedure to ensure 2-No Essential $0 SO $0 $0 $0 $01 $0 $0 SO
management and the public information office is additional Service
informed of shut-offs, SSOs, breaks and other savings
emergencies- Staff will establish procedures for
communicating urgent/emergency issues and
write a Utilities Division policy. (related to #13)
1 Full staff meetin s are held annually with upper 2-No Desirable $192 $192 $96 $0 $O $0 $0 SO $0
9
management. It may be of value to all employees additional service
to attend full staff meetings semi-annually - Will savings
expand to semi-annual.
2 The roles and responsibilities for WRAB and 2-No Desirable $480 $480 $240 $0 $O $O $0 SO $0
utility staff need to be better defined - review city additional Service
code responsibilities as to appropriate scope and savings
balance of board activities.
25 Field's new GIS is slow, hard to read and not 2-No Desirable $960 S960 $480 $0 SO SO $0 SO $0
accurate. The older system is static and very additional Service
accurate - staff will evaluate ways to improve savings
speed and readability of system.
28 Group needs to objectively analyze existing work 2-No Desirable $7,200 $0 $0 $0 $0 $0 $0 SO $0
load as to what needs to be accomplished and what additional Service
is desirable to be done. - Through WQES, savings
program will develop work plan in 2009.
43 Some work groups consistently over-run their 2-No Desirable $360 $360 $180 $0 $(,1 Sc $0 SO $0
budgets. It is suggested these work groups be additional Service
required to stay in budgeted amounts or provide savings
written justification on why the budget must be
exceeded - Staff will develop a procedure in 2009
for reporting budget status and projected year-
end status.
3 Expand use of employee development plan within 2-No Discretion $480 $480 $240 $0 SO $0 $0 SO $0
the evaluation system. - detail development plan additional ary Service
in the employee's 2009 annual Performance savings
Evaluation.
5 Improve safety & health program within all 3-Probable Essential $2,256 $2,256 $288 $23,500 $23,500 S3,000 $0 $0 $0
divisions - City's risk manager is working with his savings, but Service
staff to schedule training opportunities for need
specific workgroups, resources
7 Senior management needs to actively promote a 3-Probable Essential $2,707 $2,707 $346 $9,400 $9,400 $1,200 $0 $0 S0
safety culture - Currently, supervisors actively savings, but Service
spend time infield and attend safety trainings need
with staff. May need consider increasing resources
resources to Health and Safety program and hold
more conferences, seminars, and workshops.
10 High pressure pipeline right-of-ways not regularly 3-Probable Essential $900 $o $0 $149,800 SO SO $195,75.0 $0 50
inspected & maintained - Maintenance of water savings, but Service
transmission pipelines should be assigned to one need
group with resources. An O&Mplan for treated resources
water transmission pipelines should be developed.
8 Trainers need to be well versed and experienced in 3-Probable Essential $0 $0 $0 $0 SO SO $0 $0 SO
their subjects. Topics should be varied to ensure savings, but Service
all aspects are covered - Need to ensure that all need
training is done in professional manner and need resources
to continue to update list of available trainers.
Regulatory Support (WQES) - Consultant.for 4-Supp Essential $0 $16,000 S4,000 $0 SO (mitigate $0
2010 Basic Standards Hearing, support Aquatic future
Life and nutrient criteria; Ongoing Hearing & budget
special water quality studies. increases)
Valve Operating Personnel - add 16-month temp 4-Supp Essental $15,000 SO so $0 $0 $0
to work w/valve operator - safety issue
Aging equipment - 5 hydros have 20+ yrs service 4-Supp Desirable $10,000 SO $0 $0 (current so $0
& others are 16yrs. Piping, valves, related hydro hydro
components starting to fail.Jeopardizes water revenue
distribution to Betasso and city system, causes projections)
shutdown of green power production, loss of
hydro
Repair/replace aging WQ lab equipment - Replace 4-Supp Desirable $101000 $0 $O $11,000 SO $0
spectrophotometer in 2010 and service contract
funding. Equipment replacement S does not exist-
Multiple lab equip needs to be replaced in I to 3
yrs.
Update/maintain 75th St. wastewater lab - 4-Supp Desirable $0 $45,000 $0 $0 $57,000 $0
paint/lighting, ceiling tiles, replace dish
wash erLspectrophotometer.Establish long-term $
for future upgrades/repairs.
Update/maintain stormwater office area - 4-Supp Desirable $0 $O $10,000, $0 $O $0
Establish fund on-going repairs/equipment
Water Monitors for all Customers - Provide water 4-Supp Discretion $10,000 $O $0 $0 SO $0
monitors for all customers ary
Houshold Hazardous Waste (HHW) Program - 4-Supp Discretion $0 $46,766 $43,168 $0 SO $0
portion paid by general fund now likely paid by ary
WW/SW HHW minimizes sw/ww impacts &
create compliance w/regs
TOTAL $137,005 S128,745[__$21,7701 $212,700 $124,666 $57,368 $430,250 $206,0001 $28,000
"Dollars in bold are considered ongoing. Red font is for savings that will reduce future budgets and no change in color is for savings that reduces the existing budget.
City of Boulder Staffing Levels by Fund and Program Attachment:
TITLE FT. _ TITLE FTE TITLE rTE
Water Fund Wastewater Fund Stormwater/ Flood Fund
is Administration 2.50 • Administration 1.35 Administration 1. is
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
i Project Admin. 0.40 I Project Admin. 0.3n Project Admin 0.3U
'r• Ratc/Data Analyst 1.00 ,
b ; Billing Services 2.85 Billing Services 1.66 Billing Services 1.24
ji 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
F' Support Services 0.76 - Support Services 0.48;
Communication Specialist 0.20 Communication Specialist 0.14 Support Services 0.53 r"
Communication Coordinator 0.14 Communication Coordinator 0.10 Communication Specialist 0.16
Administrator 0.30 Administrator 0.15 ` Communication Cnordinator 0.10
Admm Specialist Il 0.12 Admin Specialist 11 0.09 1 Administrator 0.15
Planning & Pro] Management 5.76' ' Planning & Proj Management 1.95'; Admin Specialist I 0.12
Orattsperson it 0.60 Draftsperson II 0.20
Engineering Project Manager 2.SD Engineering Project Manager 0.75
1 Admin Specialist 1 0.29 Admin Specialist I 0.16 Planning & Proj Management 4.SD'
Admin Specialist II 0.19 Admin Specialist 11 0.12 Draftsperson II 0.20 "
Admin Supervisor 0.18 Admin Supervisor 0.07 Engineering Project Manager 0.75
Senior Engineering Tech 2.00 Senior Engineering Tech 0,65 Greenways Coordinator 1.00 q;
Water Resources Operations 2,00' Adrnin Specialist I 0.21 r`
Water Resources Coordinator 1.00 Wastewater Quality Operations 4.12: Admin Specialist II 0.14 1 7:
Water Source Specialist 1.00 1 Water Quality Planner 0.10 Admin Supervisor 0.10
Watershed Operations 2.00 Laboratory Supervisor 1.00 Senior Engineering Tech 0.35
Water Source Manager 1.00 Water Quality Coordinator 0.20 Flood Management Program 0.50
Water Source Operations 1.00 Laboratory Aide 0.50 Civil Engineer 0.75
~i Hydroelectric Operations 3.00. Water Quality Analyst 0.70 Maintenance Person II 0.50
Hydro Tech. II 2.00 Lead Water Quality Analyst 0.80
Hydroelectric Manager 1.00 Admin. Specialist I 0.20 Stormwater Quality Operations 3.721
Betasso WTP Operations 13.75'. Analytical Chemist 0.50 Water Quality Planner 0.10
Industrial Mechanic 2.00 Watershed Educations Specialist 0.12 Water Quality Coordinator 0"20
f.", Treatment Plant Supervisor 1.00 { Water Quality Analyst 0.30
Plant Operator A 2.00 Industrial Pretreatment 3.66 ° Stormwater Quality Specialist 1.00 j
Industrial Mechanic 1.00 Water Quality Planner 0.10 Lead Water Quality Analyst 0,20
Admin. Specialist I 0.75 Pretreatment Inspector 1.00 Water Quality Inspector- Storage 1.00
Chief Plant Operator 5.00 1 Pretreatment Specialist 1.00 Admin. Specialist I 0.20
Process Optimization Specialist 1.00 Water Quality Coordinator 0.20 Analytical Chemist 0.30
Lead Mechanic 0.50 Admin Specialist I 0.20 Watershed Outreach Coot 0.42 i
Treatment Plant Coor. 0.50 Watershed Out Reach Coor. 0.16 !I
8idr Res WTP Operations 9.25. Field Specialist 1.00 Stormwater Permit Compliance 1.76! r
Industrial Mechanic 1.00 Collection System Maintenance 13.95 Watershed Outreach Coor. 0.26 I°
Chief Plant Operator 2.00 Maintenance Person I 3.00 Watershed Educations Specialist 1.S0
Treatment Plant Supervisor I.OD Maintenance Person II 1.00
zp Admin. Specialist I 0.25 i Maintenance Person IV 1.80
Plant Operator D 1.00 Maintenance Person III 4.00
Lead Mechanic 0.50 k Utility Maintenance Coor. 0.1S Storm Sewer Maintenance 4.75
Plant Operator A 2.00 , Program Planner 0.55 Maintenance Person I LOD
Treatment Plant Coordinator 0.50 Standby Utility 0.50 Maintenance Person II 0.40
Process Optimization Specialist 1.00 Maintenance Supervisor 0.80 Maintenance Person 111 0.30
;'System Controls 3.00 Utility Locator O.SO Maintenance Person IV 0.70
Electronics Tech 11 2.00 TV Operator 1.D0 Maintenance Supervisor 0.10
SCADA System Admin. 1.00 Material Supply Specialist 0.1D TV Operator 1,00
Water Quality Operations 6.83: Admin Specialist II 0.40 Utility Maintenance Coor. 0.15
Water Quality Planner 0.10 Program Admin MGR 0.15 Program Planner 0.15
Water Quality Project Manager 1.00 Meter Operations 0.64 Utility Locator 0.50
Water Source Operations Manager 2.0D Meter Service Tech. 0.48 Material Supply Specialist 0.10 )
17 Water Quality Coordinator 0.20 Meter Service Op Assistant 0.08 Admin. Specialist II 0.15 t1
Drinking Water Quality Lab 1.00 Shop Water Meter Service Tech 0.08 Program Admin. MGR 0115
Water Quality Inspector 1.00 Program Planner 0.15
Admin. Specialist 1 0.20 Wastewater Operations 16.OD
Laboratory Supervisor 1.00 Chief Plant Operator 5.00
Analytical Chemist 0.20 Treatment Plant Coordinator 1.00
i°- Watershed Educations Specialist 0.13 Plant Operator A 4.00 Flood Channel Maintenance 2.551
Water Conservation 1.66, Plant Operator C 1.00 Maintenance Person 11 1.05
i;
Water Quality Planner 0.10 I Plant Operator D 1.00 Maintenance Person III 0.50 • .
t Water Quality Coordinator 0.20 Admin. Specialist I 1.00 Maintenance Person IV 0.50 J
! Program Specialist 1.00 Treatment Plant Supervisor 2.00 j Maintenance Supervisor 0.50 iI)
EJ Admin. Specialist I 0.20 Process Optimization Specialist 1.00
Watershed Outreach Coor. 0.16
Distribution System Maint 14.95 WWTP Maintenance 9.00; Flood management 0.751
Maintenance Person I 1.00 f Plant maintenance Supervisor 1.00 Flood Mangmnt Program Manger 0.50
f Maintenance Person II 1,10 Industrial Mechanic 2.00 Civil Engineer II 0.25
Maintenance Person III 3.00 Maintenance Person 1 1.00
Maintenance Person IV 3.20 Maintenance Person II 2.00
E Maintenance Supervisor 1.00 Maintenance Person 1I1 2.00 Total Stormwater/flood . Utility _ 20.95
Utility Maintenance Coor 0.20 Electronics Tech. It 1.00
4 Program Planner 0.60 , Cogeneration 1.00 TITLE
u Standby Utility 0.50 1 Cogeneration Tech 1.00
{ Utility Locator 1.00 Biosolids Recycling 1.25 Transportation
Material Supply Specialist 0.80 Resource Recover Specialist 0.25 Storm Sewer Maint - Trans. OBU
4 Valve Operator 1.00 Lead Resource Recovery Operator 0.25 Total Transportation 0.80
Admin. Specialist 11 0.45 Resources Reccovery Operator 0.75
jj Program Admin. MGR 0.20
F
Meter Operations 7.36. `Biosolids Processing 3.75 TOTAL STAFF
Meter Service Tech 5.52 Resource Recovery spew sr 0,75 FOR UTILITIES 156.23
Meter Service Operations 0.92 Lead Resource Recovery OP 0.75
Shop Water Meter Service Tech 0.92 Resource Recovery operator 2.2.5
Total Water Utility 75.67 Total Wastewater Utility