3/8/2022 2022-23 WATER DEPARTMENT CIP WORKSHEET - LOCAL WASTEWATER CAPITAL FUND 1626 1 . Carryover 2021-22 2021-22 IFAS REQUEST
Line IFAS Funding From Budget Mid-Year ITD Y.T.D. Y.T.D. Projected YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 5 YEAR No. PID Key Project Title Type 2020-21 Request Revisions Expenditures Expenditures Encumbered Available 2022-23 2023-24 2024-25 2025-26 2026-27 TOTAL 1 Public Assistance (PA) Projects
2 2208 70797 Misc Sewer Lift Station Work - Cat F CO $320,305 $0 $0 $354,298 $21,604 $39,340 $259,362 $0 $0 $0 $0 $0 $0 3 2208 70798 Lift Station1 Stagecoach Rehabilitation - Cat F CO $343,561 $0 $0 $866,804 $107,365 $116,732 $119,463 $0 $0 $0 $0 $0 $0 4 N/A 70813 Glass Fire Emergency Response - Sewer CO $7,211 $0 $0 $22,789 $0 $0 $7,211 $0 $0 $0 $0 $0 $0 5 2201 70799 Lift Station 2 Skyfarm A Rehabilitation - Ca t F CO $1,960,065 $0 $0 $3,014,242 $1, 374,307 $276,694 $309,063 $0 $0 $0 $0 $0 $0 6 2201 70800 Lift Station 20 Hansford Ct. Rehab ilitation - Cat F CO $364, 238 $0 $0 $2,025,542 $185,978 $264,748 ($86,488) $0 $0 $0 $0 $0 $0 7 PA Project Totals $2,995,380 $0 $0 $6,283,676 $1,689,254 $697,515 $608,611 $0 $0 $0 $0 $0 $0 8 9
10 Hazard Mitigation Program (HM GP) Projects
11 2256 70795 Wastewater Facility Generato r Replacements - HMG CO $2,375,499 $0 $0 $517,893 $108,369 $699,153 $1,567,978 $0 $0 $0 $0 $0 $0 12 HMGP Project Totals $2,375,499 $0 $0 $517,893 $108,369 $699,153 $1,567,978 $0 $0 $0 $0 $0 $0 13 14
15 Master Planning/Studies/Miscellaneous
16 509 70590 Local Wastewater Project Contingency CONT $5, 624,829 $0 $3,995,679 $0 $0 $0 $7,611,578 $250,000 $1,000,000 $1,000,000 $1,000,000 $20 0,000 $3,450,000 17 2402 70551 Local Repairs - On Call Contracts CONT $604, 138 $0 $0 $1,195,849 $18,987 $198,539 $386, 612 $100,000 $291,000 $291,000 $291,000 $0 $9 73,000 18 1641 70556 Pre-Design, Planning, Budget, GIS Support - Sewer CONT $417,992 $0 $0 $2,085,395 $110,257 $0 $307,735 $100,000 $100,000 $100,000 $ 100,000 $0 $400,000 19 242 70669 Wastewater Plannin g CONT $160,651 $0 $0 $453,525 $39,176 $0 $121,475 $50,000 $50,000 $50,000 $50,000 $53,929 $253,929 20 292 70553 Warranty Punch List - Sewer CONT $35,708 $25, 000 $0 $439,107 $30,366 $0 $30,342 $26, 900 $25,000 $25,000 $16,727 $0 $93,627 21 244 70670 Water Conservation Indoor Water Use Efficiency - WW CONT $437,164 $0 $0 $437,531 $24,696 $25,746 $386,722 $0 $0 $0 $50,000 $0 $50,000 22 64 70516 Sewer Master Plan CONT $55,154 $0 $0 $1, 035,934 $7,240 $41,585 $6,328 $0 $0 $0 $0 $1,800,000 $1,800,000 23 2302 70805 2020 Sewer Master Plan Update CO $682,547 $0 $0 $2,128,275 $122,822 $535,133 $24,592 $0 $0 $0 $0 $0 $0 24 2314 70809 Strategic Asset Management Plan - Sewer CO $1,655 $0 $0 $5,345 $0 $0 $1,655 $0 $0 $0 $0 $0 $0 25 1660 70621 W College Pond 2 Closur e Constr CO $10,531 $0 $0 $411,166 $26,697 $0 ($16,166) $0 $0 $0 $0 $0 $0 26 2291 70803 Sewer On-Call Engineering Services CO $87,272 $0 $4,000 $60,334 $11,606 $74,109 $5,557 $0 $0 $0 $0 $0 $0 27 2057 55740 Computer Maintenance Management System Re placemen CO $338,273 $0 $0 $1,793,090 $115,816 $62,088 $160,370 $0 $0 $0 $0 $0 $0 28 2315 70810 Catastrophic Reserve Study - Sewer CO $208 $0 $0 $6,792 $0 $2 $206 $0 $0 $0 $0 $0 $0 29 1448 70745 Oakmont Treatment Plant Closure Investig ation CO $32,645 $0 $0 $89,670 $2,315 $15,440 $14,890 $0 $0 $0 $0 $0 $0 30 2304 70804 Downtown Station ASP Update - Sewer CO $73,567 $0 $0 $30,433 $0 $72,670 $897 $0 $0 $0 $0 $0 $0 31 2358 70814 Design-Build Sewer CO $36,606 $0 $60,000 $52,866 $29,472 $38,623 $28,511 $0 $0 $0 $0 $0 $0 32 1765 70728 AMI/AMR Meter Installation CO $22,695 $0 $0 $5,159,982 $1,101 $22,695 ($1,101) $0 $0 $0 $0 $0 $0 33 Master Planning/Studies/Miscellaneous Totals $8,621,635 $25,000 $4,059,679 $15,385,296 $540, 551 $1,086,630 $9,070,203 $526,900 $1,466,000 $1,466,000 $1,507,727 $2,053,929 $7,020,556 34 35
36 Sewer Mains and Services
37 203 70600 SMR Albany/Clement/Malano CONT $707,355 $375,000 $0 $70,992 $68,347 $92,268 $921,740 $845,000 $0 $0 $0 $0 $845,000 38 2154 70785 SMR Alderbrook and Denton CONT $583,980 $0 $0 $170,460 $84,440 $157,795 $976,746 $800, 000 $1,380,327 $0 $0 $0 $2,180,327 39 2323 70811 SMR Terra Linda and Buena Vista NEW $0 $0 $0 $0 $0 $0 $0 $250,000 $1,400,000 $0 $0 $0 $1,650,000 40 2154 70524 SMR Sherwood Forest Neighborhood, Phase I CON T $0 $640,000 $0 $6,496 $1,967 $0 $3,033 $0 $0 $1,600,000 $1,600,000 $0 $3,200,000 41 166 70707 SMR Meyers Dr - Steele Ln to Administration NEW $0 $0 $0 $0 $0 $0 $0 $140,000 $950,000 $0 $0 $0 $1,090,000 42 477 70711 SMR Raegan Way, Bay St, California Ave NEW $0 $0 $0 $0 $0 $0 $0 $0 $600,000 $1,100,000 $0 $0 $1,700,000 43 592 70608 SMR Carrington, S Davis, Theresa, Oliv e NEW $0 $0 $0 $0 $0 $0 $0 $0 $600,000 $350,000 $1,450,000 $0 $2,400,000 44 204 70641 SMR Salem Ave and Clement Ave NEW $0 $0 $0 $0 $0 $0 $0 $0 $309,000 $680,000 $0 $0 $989,000 45 472 70602 SMR Corby Ave - Barham to Baker NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,400,000 $0 $0 $1,400,000 46 240 70718 SMR Wright St - Silva to Poppy NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $600,000 $1,800,000 $0 $2,400,000 47 2153 70784 SMR Corby Ave - Inglewood to Earle NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $339,415 $770,000 $0 $1,109,415 48 2040 70763 SMR Palomino Dr and Sunny Manor Wa y NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $250,000 $1,200,000 $0 $1,450,000 49 234 70721 SMR College Ave - E to 4th NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $450,000 $1,300,000 $1,750,000 50 2152 70788 SMR Corby Ave. Colgan to Barham NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $400,000 $1,600,000 $2,000,000 51 612 70610 SMR Apple Valley Ln NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $150,000 $700,000 $850,000 52 184 70653 SMR Grace Neighborhood, Phase 4 N EW $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,700,000 $1,700,000 53 308 70719 SMR East Haven / La Paloma / Rogers- Ph ase 3 CO $178,791 $0 $0 $1,587,277 $1, 068 $40,009 $137,713 $0 $0 $0 $0 $0 $0 54 727 70729 SMR Stony Point Rd CO $39,422 $0 $0 $930,578 $0 $88 $39,334 $0 $0 $0 $0 $0 $0 55 2290 70808 SMR Rock Creek and Matanzas CO $254,385 $680,000 $0 $115,206 $49,591 $41,445 $843,349 $0 $0 $0 $0 $0 $0 56 2117 70778 SR Creek at Fulton Lining Repair CO $936,229 $1,200,000 $0 $513,009 $34,238 $92, 736 $2,009,255 $0 $0 $0 $0 $0 $0 57 1915 70744 Danbeck / Denton / Yerba Buena Lateral Wye Replaceme n CO $2,312 $0 $15,000 $118,132 $0 $0 $17,312 $0 $0 $0 $0 $0 $0 58 1945 70733 SM Abandon: Foley CO $9,803 $0 $0 $20,197 $0 $0 $9,803 $0 $0 $0 $0 $0 $0 59 189 70654 SMR Slater - Dexter to Lewis CO $2,047,284 $0 ($450,285) $1,241,974 $999,259 $466,363 $131,378 $0 $0 $0 $0 $0 $0 - P R O J E C T E D -
3/8/2022 2022-23 WATER DEPARTMENT CIP WORKSHEET - LOCAL WASTEWATER CAPITAL FUND 1626 2 . Carryover 2021-22 2021-22 IFAS REQUEST
Line IFAS Funding From Budget Mid-Year ITD Y.T.D. Y.T.D. Projected YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 5 YEAR No. PID Key Project Title Type 2020-21 Request Revisions Expenditures Expenditures Encumbered Available 2022-23 2023-24 2024-25 2025-26 2026-27 TOTAL - P R O J E C T E D -
60 1521 70549 SMR Mendocino Ave Easement CO $567,128 $750,000 $0 $721,763 $58,891 $25,109 $1,233,128 $0 $0 $0 $0 $0 $0 61 2263 70816 Calistoga Rd. Sewer Main and Service Replacement CO $0 $0 $0 $0 $0 $0 $15,000 $0 $0 $0 $0 $0 $0 62 2041 70767 SM Abandonment: Cleveland Ave CO $877, 850 $650,000 $0 $441,400 $69,249 $5,650 $2,102,951 $0 $0 $0 $0 $0 $0 63 327 70758 SMR Terra Linda Way and Buena Vista Dr CO $1,804,491 $0 ($1,418,043) $172,225 $26,716 $20,431 $1,666,302 $0 $0 $0 $0 $0 $0 64 1805 70714 SM Relocation: Oakmont Treatment Plant C O $1,545,186 $200,000 $0 $391,254 $16,439 $122,679 $1,606,068 $0 $0 $0 $0 $0 $0 65 1684 70709 SMR East Haven and Foothill Dr- Phase 6 CO $376,067 $1,300,000 $380,000 $86,400 $60,467 $37,977 $1,957,623 $0 $0 $0 $0 $0 $0 66 661 70752 SMR Pacific Ave West of North St CO $108,561 $0 $75,000 $284,580 $98,142 $11,868 $73,552 $0 $0 $0 $0 $0 $0 67 Sewer Main and Service Totals $10,038,845 $5,795,000 ($1,398,328) $6,871,942 $1,568,814 $1,114,418 $13, 744,286 $2,035,000 $5,239,327 $6,319, 415 $7,820,000 $5,300,000 $26,713,742 68 69
70 Sewer Trunks
71 2403 70677 Sewer Trunk Lining using Design-Build CO NT $0 $0 $60,000 $10,016 $10,016 $0 $49, 984 $9,950,000 $0 $0 $0 $0 $9,950,000 72 1904 70738 Los Alamos Trunk Replacement: Elaine Dr to Melita Road a CONT $8,343 $400,000 $0 $29,434 $20,755 $0 $387, 588 $400,000 $600,000 $5,400,000 $0 $0 $6,400,000 73 2017 70757 Cross Town Trunk Replacement Phase 1 NEW $0 $0 $0 $0 $0 $0 $0 $200,000 $200,000 $200,000 $4,500,000 $0 $5,100,000 74 2115 70790 Robles Trunk Lining Phase II CONT $0 $600,000 $0 $0 $0 $0 $600,000 $0 $6,000,000 $0 $0 $0 $6,000,000 75 2156 70786 Llano Trunk Sewer Lining near Concord Av e CONT $49,034 $400,000 $0 $966 $0 $0 $449,034 $0 $0 $0 $0 $6,000,000 $6,000,000 76 2311 70807 Sonoma Ave Trunk Repair CO $1,363,430 $0 $0 $220,444 $72,366 $44,579 $1,246,485 $0 $0 $0 $0 $0 $0 77 158 70640 North Trunk Sewer Replacement - West of Chan ate CO $6,992,413 $0 $0 $10,021,180 $3,633, 517 $2,613,809 $745,086 $0 $0 $0 $0 $0 $0 78 2042 70773 North and Llano Trunk Linin g CANC $158,804 $0 $0 $3,556,017 $5,673 $142,218 $10,913 $0 $0 $0 $0 $0 $0 79 2114 70775 Robles Trunk Lining Phase 1 CO $2,814, 587 $2,510,000 $0 $326,489 $141,076 $58,638 $5,124,873 $0 $0 $0 $0 $0 $0 80 1903 70737 Los Alamos Trunk Replacement: Streamside to El aine Dr CO $4,604,392 $3,000,000 $0 $1, 816,798 $182,634 $6,235 $7,415,523 $0 $0 $0 $ 0$ 0 $ 0 81 Sewer Trunk Totals $15,991,003 $6,910,000 $60,000 $15,981, 345 $4,066,038 $2,865,479 $16,029,486 $10,550,000 $6,800,000 $5,600,000 $4,500,000 $6,000,000 $33,450,000 82 83
84 Lift Stations and Facilities
85 2407 70550 Fulton Road Lift Station CONT $1,840,059 $0 $0 $1,832,055 $2,783 $0 $1,837,276 $0 $0 $525,000 $500,000 $7,200,000 $8,225,000 86 2349 70812 Purchase of Piezzi Lift Station Parcel CO $112,669 $0 $0 $23,665 $16,334 $0 $96,335 $0 $0 $0 $0 $0 $0 87 2387 70815 Country Manor LS Rehab or Replacement CO $350,000 $0 $0 $1,264 $1,264 $0 $348,736 $0 $0 $0 $0 $0 $0 88 Lift Station and Facility Totals $2,302,728 $0 $0 $1,856,984 $20,381 $0 $2,282, 347 $0 $0 $525,000 $500,000 $7,200,000 $8,225,000 89 Grand Totals $42,325,090 $12,730,000 $46,897,136 $7,993,407 $6,463,195 $43,302,910 $13,111,900 $13,505,327 $13,910,415 $14,327,727 $20,553,929 $75,409, 298 Funding Type:
CANC = Project is expected to be completed by end of current fiscal year CO = Carryover project with no additional funding
CONT = Continue project with additional funding
NEW = New project with initial funding within five year plan Assumptions:
3% construction cost inflation per year