Loading...
HomeMy WebLinkAbout5 - Draft 2003 Utilities Budget CITY OF BOULDER WATER RESOURCE ADVISORY BOARD AGENDA ITEM MEETING DATE: April 15, 2002 SUBJECT: Staff Presentation and Discussion of the 2003 Utilities (Water, Wastewater and Flood Control) Budget including the 5-year Capital Improvement Program and the Monthly Utility Rates. REQUESTING DEPARTMENT: Ned Williams, Director of Public Works for Utilities Bob Harberg, Utilities Project Coordinator Carol Linn, Utilities Analyst BOARD ACTION REQUESTED: None - Discussion Only FISCAL IMPACT: See attached Attached is information concerning the 2002 Utilities Division budget and the 2002-2007 Utilities Capital Improvement Program (CIP) for background in preparation for 2003 budget discussions. Staff will return to the Board in May and June for further discussions and to solicit a recommendation to Planning Board and City Council concerning the proposed 2003 Utilities Division budget and 2003-2008 CIP. Attachment A: 2002 Fund Financial Spreadsheet Information (Water, Wastewater and Flood Control). Attachment B: 2002-2007 Capital Improvement Program (Water, Wastewater, Flood Control and Tributary Greenways). j CITY OF BOULDER 2002-03 FUND FINANCIAL WATER UTILITY FUND 2000 2001 2002 2003 2004 2005 2006 2007 ACTUAL REVISED APPROVED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED UNAPPROPRIATED FUND BALANCE Beginning of Year $17,406,910 $37,264,669 $17,182,048 $16,367,564 $12,810,984 $14,749,348 $16,248,158 $12,568,709 SOURCES OF FUNDS Operating-- Sale of Water to General Cust $16,232,083 $14,673,989 $16,173,586 $17,664,383 $18,230,619 $18,815,008 $19,418,133 $20,040,594 Projected Rate Increase $0 3% $1,467,399 10% $1,455,623 9% $529,931 3% $546,919 3% $564,450 3% $582,544 3% $601,218 3% Bulo nigation Water Sales $74,296 $95,000 $47,000 $47,000 $47,000 $47,000 $47,000 $47,000 Hydroelectnc Revenue $779,844 $986,000 $1,235,000 $1,145,000 $1,325,000 $1,585,000 $1,585,000 $1,585,000 Public Fire Protection $10,648 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 Miscellaneous Operating Revenues $30,864 $32,500 $32,500 $32,500 $32,500 $32,500 $32,500 $32,500 TOTAL OPERATING SOURCES OF FUNDS $17,127,735 $17,264,888 $18,953,709 $19,428,815 $20,192,037 $21,053,958 $21,675,177 $22,316,312 Non-Operating- Plant Investment Fees $1,824,523 $1,500,000 $2,100,000 $2,100,000 $2,100,000 $2,100,000 $2,100,000 $2,100,000 Connection Charges $182,234 $130,000 $115,000 $115,000 $115,000 $115,000 $115,000 $115,000 Special Assessments $52,931 $42,000 $47,500 $47,500 $47,500 $47,500 $47,500 $47,500 Interest $1,746,980 $1,363,500 $761,339 $818,378 $640,549 $737,467 $812,408 $628,435 Miscellaneous Non-Operating $116,514 $181,400 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 Transfer from Windy Gap - Barker Projects $925,000 $13,175,000 $3,075,000 $2,250,000 $2,000,000 $1,900,000 $3,200,000 $0 Payment from County- Caribou Acquisition $0 $817,820 $817,820 $817,820 $817,820 $817,820 $0 $0 Net Impact from AMR $0 $100,000 $250,000 $0 $0 $0 $0 $0 Silver Lake Bond Proceeds $0 $0 $0 $0 $0 $0 $0 $0 Barker/ AMR/ Cold Springs/Canbou Bond Proceeds $25,369,655 $0 $0 $0 $0 $0 $0 $0 Projected Bond Proceeds $0 $28,830,000 $0 $0 $0 $0 $0 $0 TOTAL NON-OPERATING SOURCES OF FUNDS $30,217,837 $46,139,720 $7,173,659 $6,155,698 $5,727,869 $5,724,787 $6,281,908 $2,897,935 TOTAL SOURCES OF FUNDS $47,345,572 $63,404,608 $26,127,368 $25,584,513 $25,919,907 $26,778,746 $27,957,085 $25,214,247 USES OF FUNDS Operating- Operating Expenditures $8,612,418 $8,396,198 $8,785,391 $9,066,146 $9,260,880 $9,538,707 $9,824,868 $10,119,614 Budget Adjustment l $0 $0 $0 $42,226 $86,563 $133,092 $181,896 $233,060 Budget Adjustment 2 $0 $0 $0 $0 $0 $0 $0 $0 Changes in Service $0 $0 $0 $0 $0 $0 $0 $0 Windy Gap Payment $1,658,948 $1,688,302 $1,698,623 $1,698,733 $1,698,441 $1,696,657 $1,697,375 $1,699,314 Emergency Reserve $0 $262,000 $296,000 $306,360 $317,083 $328,180 $339,667 $351,555 Sick/Vacation Accrual $70,971 $80,000 $100,000 $103,500 $107,123 $110,872 $114,752 $118,769 TOTAL OPERATING USES OF FUNDS $10,342,337 $10,426,500 $10,880,014 $11,236,965 $11,470,089 $11,807,508 $12,158,558 $12,522,312 Debt- Betasso Hydroelectric GO Bond $353,453 $365,699 $362,147 $353,088 $367,403 $365,653 $0 $0 Water Refunding Revenue Bond $0 $0 $0 $0 $0 $0 $0 $0 BRWTP 1996 Revenue Bond $901,814 $908,210 $908,376 $912,522 $910,477 $912,794 $908,440 $912,766 Silver Lake 1999 Revenue Bond $1,224,130 $1,228,419 $1,231,677 $1,233,903 $1,240,082 $1,239,974 $1,238,110 $1,240,095 Barker/AMR/ Cold Springs/ Caribou Revenue Bond $2,219,168 $2,207,540 $2,231,249 $2,246,258 $2,255,586 $2,271,458 $2,273,436 $2,272,002 Projected Bond -Lakewood Pipeline $0 $55,634 $2,157,607 $2,195,681 $2,181,152 $2,179,419 $2,181,069 $2,180,919 TOTAL DEBT SERVICE $4,698,565 $4,765,502 $6,891,056 $6,941,452 $6,954,700 $6,969,298 $6,601,055 $6,605,782 CITY OF BOULDER 2002-03 FUND FINANCIAL _ WATER UTILITY FUND 2000 2001 2002 2003 2004 2005 2006 2007 ACTUAL REVISED APPROVED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED Transfers Out- Employee Insurance Benefit $0 $0 $44,322 $45,873 $47,479 $49,141 $50,861 $52,641 Cost Allocation $714,628 $812,601 $989,232 $1,038,694 $1,090,628 $1,145,160 $1,202,418 $1,262,539 Caribou Ranch repayment to Windy Gap $175,200 $175,200 $175,200 $175,200 $175,200 $175,200 $175,200 $175,200 Planning 8 Development Services $0 $96,306 $158,028 $162,769 $167,652 $172,681 $177,862 $183,198 TOTAL TRANSFERS OUT $889,828 $1,084,107 $1,366,782 $1,422,536 $1,480,959 $1,542,182 $1,606,340 $1,673,577 Capital Improvements Program- TOTAL CAPITAL USES OF FUNDS $5,299,607 $16,450,000 $8,200,000 $9,950,000 $4,500,000 $5,400,000 $11,725,000 $7,800,000 BOULDER RESERVOIR WTP BOND $19,053 $0 $0 $0 $0 $0 $0 $0 SILVER LAKE BOND FUND $290,049 $0 $0 $0 $0 $0 $0 $0 BETASSO RESIDUALS - BOND $2,749,629 $1,033,432 $0 $0 $0 $0 $0 $0 BOULDER CANYON TRANSMISSION LINE- BOND $915,481 $89,076 $0 $0 $0 $0 $0 $0 PROJECTED BOND- LAKEWOOD PIPELINE $0 $26,614,537 $0 $0 $0 $0 $0 $0 BARKER/AMR/ COLD SPRINGS/CARIBOU BOND $2,354,135 $21,042,256 $0 $0 $0 $0 $0 $0 ENCUMBRANCES, CARRYOVERS & MID-YR ATB's $0 $2,323,819 $0 $0 $0 $0 $0 $0 TOTAL USES OF FUNDS $27,558,684 $83,829,229 $27,337,852 $29.550,953 $24,405,748 $25,718,988 $32,090,953 $28,601,671 Emergency Reserve Adjustment $0 $262,000 $296,000 $306,360 $317,083 $328,180 $339,667 $351,555 SickfVacation Accrual Adjustment $70,971 $80,000 $100,000 $103,500 $107,123 $110,872 $114,752 $118,769 FUND BALANCE -END OF YEAR $37,264,669 $17,182,048 $16,367,564 $12,810,984 $14,749,348 $16,248,158 $12,568,709 $9,651,609 Designated Reserves - Barker Reserves $895,979 $895,979 $895,979 $895,979 $895,979 $895,979 $895,979 $895,979 Bond Reserves $4,107,478 $6,322,941 $6,322,941 $6,322,941 $6,322,941 $6,322,941 $6,322,941 $6,322,941 Vacation/Sick/Banus Liability $606,474 $571,584 $588,732 $606,394 $624,585 $643,323 $662,623 $682,501 TOTAL RESERVES $5,609,931 $7,790,504 $7,807,652 $7,825,314 $7,843,505 $7,862,243 $7,881,543 $7,901,421 SURPLUS/(DEFICIT) vs. RESERVE GOAL $31,654,738 $9,391,544 $8,559,912 $4,985,671 $6,905,842 $8,385,915 $4,687,166 $1,750,188 OPERATING RESERVE (GOAL -20%) 339.39% 100.93% 86.18% 48.26% 65.11% 76.31% 41.16% 14.83% CITY OF BOULDER 10-Apr-02 2002 - 2007 CAPITAL IMPROVEMENT PROGRAM WATER UTILITY FUND 2002 2003 2004 2005 2006 2007 PROJECT NAME ADOPTED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED Treated Water Pressure Reducing and Hydroelectric Facilities Pearl Street Hydro/PRV Station Improvements $0 $0 $0 $0 $0 $200,000 Subtotal - Treated Water PRV and Hydro $0 $0 $0 $0 $0 $200,000 Water Treatment Facilities Betasso WTP Rehabilitation $0 $0 $0 $500,000 $5,000,000 $0 Boulder Reservoir WTP Improvements $300,000 $3,500,000 $0 $0 $0 $0 Boulder Reservoir WTP Expansion $0 $0 $0 $0 $500,000 $5,000,000 Subtotal - Water Treatment Facilities $300,000 $3,500,000 $0 $500,000 $5,500,000 $5,000,000 Pump Stations Cherryvale Pump Station $75,000 $150,000 $0 $0 $0 $0 Boulder Reservoir High Service Pump Station $100,000 $0 $0 $0 $0 $0 Iris Pump Station $75,000 $250,000 $0 $0 $0 $0 Subtotal - Pump Stations $250,000 $400,000 $0 $0 $0 $0 Storage Tanks Kohler Storage Tank Lining Rehabilitation $500,000 $0 $0 $0 $0 $0 Maxwell Storage Tank Lining Rehabilitation $600,000 $0 $0 $0 $0 $0 Subtotal - Storage Tanks $1,100,000 $0 $0 $0 $0 $0 Distribution System Rehabilitation Whittier Area Distribution System Rehabilitation $0 $500,000 $0 $0 $0 $0 Goss Grove Distribution System Rehabilitation $1,000,000 $0 $0 $0 $0 $0 South Boulder Water System Rehabilitation $0 $0 $0 $500,000 $0 $0 East Boulder Water System Rehabilitation $0 $0 $500,000 $0 $0 $0 North Boulder Water System Rehabilitation $0 $0 $0 $0 $500,000 $0 West Boulder Water System Rehabilitation $0 $0 $0 $0 $0 $500,000 Corroded Waterline Rehabilitation $1,750,000 $1,750,000 $1,750,000 $2,000,000 $2,000,000 $2,000,000 Subtotal - Distribution System Rehabilitation $2,750,000 $2,250,000 $2,250,000 $2,500,000 $2,500,000 $2,500,000 Treated Water Transmisstion System Rehabilitation Zone 1 Transmission Facilities $50,000 $500,000 $0 $0 $500,000 $0 Zone 2 Transmission Facilities $50,000 $500,000 $0 $0 $0 $0 Zone 3 Transmission Facilities $0 $0 $0 $500,000 $0 $0 Subtotal - Treated Water Transmission System Rehab $100,000 $1,000,000 $0 $500,000 $500,000 $0 CITY OF BOULDER 10-Apr-02 2002 - 2007 CAPITAL IMPROVEMENT PROGRAM WATER UTILITY FUND 2002 2003 2004 2005 2006 2007 1PROJECT NAME ADOPTED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED barker Water System Barker Gravity Pipeline Repair $0 $1,000,000 $1,000,000 $700,000 $1,200,000 $0 Barker-Kossler Penstock Repair $0 $0 $200,000 $800,000 $0 $0 Barker Dam Outlet Improvements $2,000,000 $0 $0 $0 $0 $0 Barker Dam Resurfacing $0 $0 $0 $100,000 $1,000,000 $0 Barker Hydro System Integration $0 $750,000 $550,000 $0 $0 $0 Barker Reliscensing $575,000 $500,000 $250,000 $0 $0 $0 Barker Instream Flow Release $500,000 $0 $0 $0 $0 $0 Barker Water System Source Protection $0 $0 $0 $300,000 $1,000,000 $0 Subtotal - Barker Water System $3,075,000 $2,250,000 $2,000,000 $1,900,000 $3,200,000 $0 Raw Water Storage Reservoirs Albion Dam Rehabilitation $0 $0 $0 $0 $25,000 $100,000 Green Lake 2 Reconstruction $25,000 $500,000 $0 $0 $0 $0 Subtotal - Raw Water Storage Reservoirs $25,000 $500,000 $0 $0 $25,000 $100,000 Other Raw Water Facilities Upgrades Como Creek Diversion Structure $350,000 $0 $0 $0 $0 $0 Boulder Feeder Canal $50,000 $50,000 $0 $0 $0 $0 Subtotal - Other Raw Water Facilities Upgrades $400,000 $50,000 $0 $0 $0 $0 Raw Water Pressure Reducing and Hydroelectric Facilities Boulder Reservoir Intake and Pumping $200,000 $0 $0 $0 $0 $0 Subtotal - Raw Water PRV and Hydro $200,000 $0 $0 $0 $0 $0 Water System Monitoring and Metering Data Communications System Upgrades $0 $0 $250,000 $0 $0 $0 Subtotal - Water System Monitoring and Metering $0 $0 $250,000 $0 $0 $0 TOTAL CAPITAL USES OF FUNDS $8,200,000 $9,950,000 $4,500,000 $5,400,000 $11,725,000 $7,800,000 CITY OF BOULDER 2002.03 FUND FINANCIAL WASTEWATER FUND 2000 2001 2002 2003 2004 2005 2006 2007 ACTUAL REVISED APPROVED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED UNAPPROPRIATED FUND BALANCE Beginning of Year $6,618,023 $6,566,280 $7,206,119 $4,417,403 $6,865,443 $6,342,287 $5,890,242 $5,471,949 SOURCES OF FUNDS Operating- Sewer Charges to General Customers $6,995,052 $6,689,853 $7,105,426 $7,973,994 $8,948,735 $9,504,630 $9,904,585 $10,222,126 Projected Rate Increase $0 3% $401,391 6% $852,651 12% $956,879 12% $536,924 6% $380,185 4% $297,138 3% $306,664 3% Surcharge/ Pretreatment Fees $127,371 $119,500 $142,500 $142,500 $142,500 $142,500 $142,500 $142,500 Cogeneration Revenues $78,915 $70,000 $90,000 $70,000 $70,000 $70,000 $70,000 $70,000 TOTAL OPERATING SOURCES OF FUNDS $7,201,338 $7,280,744 $8,190,578 $9,143,373 $9,698,159 $10,097,315 $10,414,223 $10,741,290 Non-Operating-- PlantInvestment Fees $355,265 $260,000 $420,000 $420,000 $420,000 $420,000 $420,000 5420,000 Connection Charges $56.008 $10,000 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 Special Assessments $18,310 $31,500 $37,000 $42,500 $44,000 $44,000 $44,000 $44,000 Federal & Slate Grants $0 $0 $0 $0 $0 $0 $0 $0 Interest on Investments $394,459 $361,000 $360,431 $220,870 $343,272 $317,114 $294,512 $273,597 Miscellaneous Non-Operating $39,408 $30,130 $21,130 $21,130 $21,130 $21,130 $21,130 $21,130 Sale of Capital Assets $0 $800,000 $400,000 $752,894 $0 $0 $0 $0 Projected Bond Proceeds $0 $0 $0 $29,463,700 $0 $0 $0 $0 TOTAL NON-OPERATING SOURCES OF FUNDS $863,450 $1,492,630 $1,248,061 $30,930,594 $837,902 $811,744 $789,142 $768,227 TOTAL SOURCES OF FUNDS $8,064,788 $8,773,374 $9,438,639 $40,073,967 $10,536,061 $10,909,060 $11,203,365 $11,509,517 USES OF FUNDS Operating- Operating Expenditures $5,640,443 $5,900,357 $6,176,359 $6,379,347 $6,539,827 $6,736,022 $6,938,103 $7,146,246 Budget Adjustment l $0 $0 $0 $31,251 $64,065 $98,501 $134,620 $172,486 Budget Adjustment 2 $0 $0 $0 $0 $0 $0 $0 $0 Changes in Service $0 $0 $0 $0 $0 $0 $0 $0 Emergency Reserve $0 $185,000 $205.000 $212,175 $219,601 $227,287 $235,242 $243,476 SickNacalion Accrual $69,565 $50,000 $75,000 $77,625 $80,342 $83,154 $86,064 $89,076 TOTAL OPERATING USES OF FUNDS $5,710,008 $6,135,357 $6,456,359 $6,700,398 $6,903,835 $7,144,964 $7,394,029 $7,651,284 Debt-- ProjectedBond - WWTP Improvements $0 $0 $0 $1,194,850 $1,194,850 $1,194,850 $1,194,850 $1,194,850 Projected Bond- Biosolids Composting Facility $0 $0 $0 $896,125 $896,125 $896,125 $896,125 $896,125 Projected Bond - Biosolids Handling & Dewatering $0 $0 $0 $597,500 $597,500 $597,500 $597,500 $597,500 Marshall Landfill Revenue Bond $185,457 $185,278 $185,043 $184,662 $183,908 $187,746 $185,932 $188,683 W WTP Capital Energy Lease $7,918 $7,918 $7,918 $0 $0 $0 $0 $0 TOTAL DEBT SERVICE $193,375 $193,196 $192,961 $2,873,137 $2,872,383 $2,876,221 $2,874,407 $2,877,158 Transfers Out.. Employee Insurance Benefit $0 $0 $38,936 $40,299 $41,709 $43,169 $44,680 $46,244 Cost Allocation $445,110 $530,721 $561,071 $589,125 $618,581 $649,510 $681,985 $716,085 Planning & Development Services $0 $96,691 $158,028 $162,769 $167,652 $172,682 $177,862 $183,198 TOTAL TRANSFERS OUT $445,110 $627,412 $758,035 $792,192 $827,942 $865,361 $904,527 $945,526 CITY OF BOULDER 2002-03 FUND FINANCIAL WASTEWATER FUND 2000 2001 2002 2003 2004 2005 2006 2007 ACTUAL REVISED APPROVED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED Capital Improvements Program- TOTAL CAPITAL USES OF FUNDS $1,837,603 $500,000 $5,100,000 $550,000 $755,000 $785,000 $770,000 $800,000 PROJECTED BOND-WWTP IMPROVEMENTS $0 $0 $0 $12,000,000 $0 $0 $0 $0 PROJECTED BOND-BIOSOLIDS COMPOSTING $0 $0 $0 $9,000,000 $0 $0 $0 $0 PROJECTED BOND-SIOSOLIDS HANDLING $0 $0 $0 $6,000,000 $0 $0 $0 $0 CARRYOVERS, ENCUMBRANCES 8 MID-YR ATBS $0 $912,570 $0 $0 $0 $0 $0 $0 TOTAL USES OF FUNDS $8,186,096 $8,368,535 $12,507,355 $37,915,727 $11,359,160 $11,671,546 $11,942,963 $12,273,968 Emergency Reserve Adjustment $0 $185,000 $205,000 $212,175 $219,601 $227,287 $235,242 $243,476 Sick/Vacation Accrual Adjustment $69,565 $50,000 $75.000 $77,625 $80,342 $83,154 $86,064 $89,076 FUND BALANCE -END OF YEAR $6,566,280 $7,206,119 $4,417,403 $6,81 $6,342,287 $5,890,242 $5,471,949 $5,040,051 Designated Reserves - Bond Reserves $187,586 $187,586 $187,586 $2,876,061 $2,876,061 $2,876,061 $2,876,061 $2,876,061 SickNaoation/Bonus Liability 5456,063 $459,323 $473,103 $487,296 $501,915 $516,972 $532,482 $548,456 TOTAL RESERVES $643,649 $646,909 $660,689 $3,363,357 $3,377,976 $3,393,033 $3,408,543 $3,424,517 SURPLUSI(DEFICIT) vs. RESERVE $5,922,631 $6,559,210 $3,756,714 $3,502,086 $2,964,311 $2,497,208 $2,063,407 $1,615,534 OPERATING RESERVE (GOAL -20%) 97.32% 100.48% 54.18% 48.62% 39.89% 32.43% 25.87% 19.55% CITY OF BOULDER 10-Apr-02 2002 - 2007 CAPITAL IMPROVEMENT PROGRAM WASTEWATER UTILITY FUND 2002 2003 2004 2005 2006 2007 1PROJECT NAME ADOPTED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED Wastewater Treatment WW--P Pump Rehabilitation $0 $0 $55,000 $55,000 $0 $0 WWTP/CPDES Improvements $2,000,000 $0 $0 $0 $0 $0 WWTP/CPDES Improvements - Projected Bond $0 $12,000,000 $0 $0 $0 $0 WWTP Headworks Improvements $0 $0 $0 $0 $0 $100,000 WWTP Instrumentation/Control Improvements $0 $0 $0 $0 $100,000 $0 WWTP Trickling Filter Rehabilitation $200,000 $0 $0 $0 $0 $0 WWTP Solids Contact Improvements $0 $0 $0 $0 $0 $150,000 WWTP Secondary Clarifier Rehabilitation $0 $150,000 $0 $0 $0 $0 WWTP Primary Clarifier Rehabilitation $0 $0 $200,000 $0 $0 $0 WWTP Digester Cleaning $0 $0 $0 $0 $120,000 $0 WWTP Cogeneration $0 $0 $0 $180,000 $0 $0 WWTP Effluent Outfall Relocation $1,000,000 $0 $0 $0 $0 $0 Subtotal - Wastewater Treatment Plan $3,200,000 $12,150,000 $255,000 $235,000 $220,000 $250,000 Biosolids Recycling Biosolids Composting $1,000,000 $0 $0 $0 $0 $0 Biosolids Composting - Projected Bond $0 $9,000,000 $0 $0 $0 $0 Biosolids Handling & Dewatering $500,000 $0 $0 $0 $0 $0 Biosolids Handling & Dewatering - Projected Bond $0 $6,000,000 $0 $0 $0 $0 Subtotal - Biosolids Recycling $1,500,000 $15,000,000 $0 $0 $0 $0 Sewer System Rehabilitation Interceptor Sewer Rehabilitation $150,000 $150,000 $150,000 $300,000 $300,000 $300,000 Collector Sewer Rehabilitation $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 Manhole Rehabilitation $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 Subtotal - Sewer System Rehabilitation $400,000 $400,000 $400,000 $550,000 $550,000 $550,000 Wastewater System Expansion North Boulder Wastewater System Expansion $0 $0 $100,000 $0 $0 $0 Gunbarrel Wastewater System Expansion $0 $0 $0 $0 $0 $0 East Boulder Wastewater System Expansion $0 $0 $0 $0 $0 $0 Subtotal- Wastewater System Expansion $0 $0 $100,000 $0 $0 $0 TOTAL CAPITAL USES OF FUNDS $5,100,000 $27,550,000 $755,000 $785,000 $770,000 $800,000 CITY OF BOULDER 2002-03 FUND FINANCIAL FLOOD CONTROL UTILITY FUND 2000 2001 2002 2003 2004 2005 2006 2007 ACTUAL REVISED APPROVED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED UNAPPROPRIATED FUND BALANCE Beginning of Year $11,391,006 $10,332.768 $4,391,181 $4,660,596 $4,303,561 $4,836,207 $4,932,176 $5,142,101 SOURCES OF FUNDS Operating- Service Charge Fees $3,479,207 $3,431,578 $3,575,979 $3,869,781 $4,187,722 $4,363,942 $4,547,576 $4,738,938 Projected Rate Increases $0 0% $137,263 4% $286,078 8% $309,582 8% $167,509 4% $174,558 4% $181,903 4% $189,558 4% TOTAL OPERATING SOURCES OF FUNDS $3,479,207 $3,568,841 $3,862,057 $4,179,364 $4,355,231 $4,538,499 $4,729,479 $4,928,496 Non-Operating- PlantInvestment Fees $1,075,486 $750,000 $700,000 $700,000 $700,000 $700,000 $700,DD0 $700,000 Urban Drainage District Funds $1,422,796 $750,000 $400,000 $382,000 $266,700 $400,000 $400,000 $400,000 State & Federal Grants $266,561 $0 $0 $0 $0 $0 $0 $0 Interest on Investments $662,581 $475,000 $206,492 $233,030 $215,178 $241,810 $246,609 $257,105 Mapleton Mobile Home Park Revenues $362,654 $250,000 $300,000 $300,000 $320,000 $320,000 $320,000 $320,000 Miscellaneous Non-Operating $338,840 $32,000 $3,000 $2,000 $1,000 $1,000 $1,000 $1,000 Transfers From Other Funds $201,838 $201,838 $0 $0 $0 $0 $0 $0 Projected Bond Proceeds $0 $0 $6,547,500 $3,274,000 $0 $0 $0 $0 TOTAL NON-OPERATING SOURCES OF FUNDS $4,330,756 $2,458,838 $8,156,992 $4,891,030 $1,502,878 $1,662,810 $1,667,609 $1,678,105 TOTAL SOURCES OF FUNDS $7,809,963 $6,027,679 $12,019,049 $9,070,393 $5,858,109 $6,201,310 $6,397,088 $6,606,601 USES OF FUNDS Operating- Operating Expenditures $1,929,932 $1,637,678 $1,672,835 $1,724,704 $1,745,545 $1,797,912 $1,851,849 $1,907,405 Budget Adjusment l $0 $0 $0 $10,306 $21,127 $32,482 $44,393 $56,880 Budget Adjustment 2 $0 $0 $0 $0 $0 $0 $0 $0 Changes in Service $0 $0 $0 $0 $0 $0 $0 $0 Emergency Reserve $0 $56,000 $62,000 $64,170 $66,416 $68,741 $71,146 $73,637 SickNacation Accrual $2,456 $20,000 $25,000 $25,875 $26,781 $27,718 $28,688 $29,692 TOTAL OPERATING USES OF FUNDS $1,932,388 $1,713,678 $1,759,835 $1,825,055 $1,859,869 $1,926,852 $1,996,077 $2,067,613 Debt- Mapleton Mobile Home Park payments $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $1,495,515 Goose Creek/BVRCl 90 Refunding Bond $818,856 $815,272 $810,975 $810,946 $809,967 $808,038 $805,158 $806,309 Projected Bond - Four Mile Creek $0 $0 $597,500 $597,500 $597,500 $597,500 $597,500 $597,500 Projected Bond - South Boulder Creek $0 $0 $0 $299,000 $299,000 $299,000 $299,000 $299,000 TOTAL DE13T SERVICE $1,068,856 $1,065,272 $1,658,475 $1,957,446 $1,956,467 $1,954,538 $1,951,658 $3,198,324 Transfers Out- Employee Insurance Benefit $0 $0 $14,200 $14,697 $15,211 $15,744 $16,295 $16,865 Cost Allocation $146,728 $186,527 $201,367 $211,435 $222,007 $233,107 $244,763 $257,001 Planning & Development Services $0 $133,249 $202,757 $208,840 $215,105 $221,558 $228,205 $235,051 - TOTAL TRANSFERS OUT $146,728 $319,776 $418,324 $434,972 $452,323 $470,409 $489,262 $508,917 CITY OF BOULDER 2002-03 FUND FINANCIAL FLOOD CONTROL UTILITY FUND 2000 2001 2002 2003 2004 2005 2006 2007 ACTUAL REVISED APPROVED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED Capital Improvements Program- TOTAL CAPITAL USES OF FUNDS $4,816,597 $1,650,000 $2,000,000 $2,300,000 $1,150,000 $1,850,000 $1,850,000 $2,850,000 GOOSE CREEK/BVRC BOND $906,088 $2,663,246 $0 $0 $0 $0 $0 $0 PROJECTED BOND - FOUR MILE CREEK $0 $0 $6,000,000 $0 $0 $0 $0 $0 PROJECTED BOND- SOUTH BOULDER CREEK $0 $0 $0 $3,000,000 $0 $0 $0 $0 ENCUMBRANCES, CARRYOVERS 8 MID-YR ATBS $0 $4,633,294 $0 $0 $0 $0 $0 $0 TOTAL USES OF FUNDS $8,870,657 $12,045,266 $11,836,634 $9,517,473 $5,418,659 $6,201,800 $6,286,997 $8,624,854 Emergency Reserve Adjustment $0 $56,000 $62,000 $64,170 $66,416 $68,741 $71,146 $73,637 Sick/Vacation Accrual Adjustment $2,456 $20,000 $25,000 $25,875 $26,781 $27,718 $28,688 $29,692 FUND BALANCE -END OF YEAR $10,332,768 $4,391,181 $4,660,596 54,303,561 $4,836,207 $4,932,176 $5,142,101 $3,227,177 Designated Reserves - Bond Reserves $824,715 $824,715 $1,422,215 $1,721,215 $1,721,215 $1,721,215 $1,721,215 $1,721,215 Post Flood Property Acquisition $750,000 $900,000 $1,050,000 $1,050,000 $1,050,000 $1,050,000 $1,050,000 $1,050,000 MMHP Reserve $180,000 $360,000 $540,000 $720,000 $900,000 $1,080,000 $1,260,000 $0 Sick/Vacation/Bonus Liability $108,165 $53,190 $54,786 $56,430 $58,122 $59,866 $61,662 $63,512 TOTAL RESERVES $1,862,880 $2,137,905 $3,067,001 $3,547,645 $3,729,337 $3,911,081 $4,092,877 $2,834,727 SURPLUSI(DEFICIT) vs. RESERVES $8,469,888 $2,253,276 $1,593,595 $755,916 $1,106,870 $1,021,095 $1,049,224 $392,450 OPERATING RESERVE (GOAL -20%) 407.86% 115.11% 76.21% 34.84% 49.88% 44.38% 43.98% 15.87% CITY OF BOULDER 10-Apr-02 2002-2007 CAPITAL IMPROVEMENT PROGRAM FLOOD CONTROL UTILITY FUND 2002 2003 2004 2005 2006 2007 1PROJECT NAME ADOPTED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED Major Drainageway Improvements Elmer's Two-mile Creek $0 $1,300,000 $0 $0 $0 $0 Goose Creek $1,500,000 $0 $0 $0 $0 $0 South Boulder Creek Improvements $100,000 $0 $0 $0 $0 $0 South Boulder Creek Improvements - Projected Bond $0 $3,000,000 $0 $0 $0 $0 Four Mile Creek Improvements $0 $0 $0 $0 $1,000,000 $1,000,000 Four Mile Creek Improvements - Projected Bond $6,000,000 $0 $0 $0 $0 $0 Bear Creek - Arapahoe to Foothills $100,000 $0 $0 $0 $0 $0 Wonderland Creek - Diagonal Highway Underpass $0 $750,000 $0 $0 $0 $0 Subtotal - Major Drainageway improvements $7,700,000 $5,050,000 $0 $0 $1,000,000 $1,000,000 Miscellaneous Drainage Improvements Preflood Acquisition $0 $0 $500,000 $500,000 $500,000 $500,000 Tributrary Greenways Program $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 Subtotal - Miscellaneous Drainage Improvements $150,000 $150,000 $650,000 $650,000 $650,000 $650,000 Localized Drainage Improvements and Storm Sewers Mapleton Hill Drainage Improvements $0 $0 $0 $0 $200,000 $1,200,000 Upper Goose Creek Drainage Improvements $0 $100,000 $500,000 $1,200,000 $0 $0 Crossroads Redevelopment $150,000 $0 $0 $0 $0 $0 Subtotal - Localized Drainage Improvements $150,000 $100,000 $500,000 $1,200,000 $200,000 $1,200,000 TOTAL CAPITAL USES OF FUNDS $8,000,000 $5,300,000 $1,150,000 $1,850,000 $1,850,000 $2,850,000 CITY OF BOULDER 10-Apr-02 2002 - 2007 CAPITAL IMPROVEMENT PROGRAM TRIBUTARY GREENWAYS 2002 2003 2004 2005 2006 2007 1PROJECT NAME ADOPTED PROPOSED PROJECTED PROJECTED PROJECTED PROJECTED Continuation Projects Greenways Maintenance $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 Wonderland Creek - Foothills to Diagonal $0 $0 $55,000 $100,000 $190,000 $150,000 Habitat Surveys, Corridor Assessments, Misc Trail $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 Subtotal Continuation Projects $200,000 $200,000 $255,000 $300,000 $390,000 $350,000 New Projects Fourmile Improvements - 26th to 28th Streets $50,000 $0 $0 $0 $0 $0 Iris Avenue Underpass $125,000 $125,000 $0 $0 $0 $0 Bear Creek Reach 1 $75,000 $0 $0 $0 $0 $0 Fourmile Improvements - Pleasantview to 28th $0 $125,000 $195,000 $0 $0 $0 Fourmile Improvements - Sumac to 19th $0 $0 $0 $150,000 $60,000 $100,000 Subtotal New Projects $250,000 $250,000 $195,000 $150,000 $60,000 $100,000 TOTAL CAPITAL USES OF FUNDS $450,000 $450,000 $450,000 $450,000 $450,000 $450,000