Loading...
HomeMy WebLinkAbout07/17/2025 - Water Commission - SUPPLEMENTAL DOCUMENTS - Regular MeetingWater Wastewater Stormwater $5.0 $6.0 $7.0 $8.0 $9.0 $10.0 Budget Actual Operating Revenues Percent over budget: 7.4% $0.0 $2.0 $4.0 $6.0 $8.0 $10.0 Budget Actual Operating Expenses Percent under budget: 0.2% $5.0 $6.0 $7.0 $8.0 $9.0 $10.0 Budget Actual Operating Revenues Percent over budget: 3.0% $9,627,575 $9,235,779 $8.8 $9.0 $9.2 $9.4 $9.6 $9.8 $10.0 Budget Actual Operating Expenses Percent under budget: 4.1% $5.0 $6.0 $7.0 $8.0 $9.0 $10.0 Budget Actual Operating Revenues Percent over budget: 3.7% $5,383,214 $5,157,058 $0.0 $2.0 $4.0 $6.0 $8.0 $10.0 Budget Actual Operating Expenses Percent under budget: 4.2% 2 Water Fund Revenue in thousands Percent of Year 50.0% June Year to Date Actual Budget Residential Water Sales $ 1,731 *$ 38 $ 7,960 $ 8,151 $ 191 (A)$ 352 43%43% Com/Indl Water Sales 1,018 *82 3,995 4,241 246 (B)444 39%40% Excess Water Use Surcharge 23 *17 30 66 36 (C)32 7%4% District Water Sales 274 *(37)992 1,043 51 91 38%35% Other Water Sales 716 *713 367 836 468 (D)217 158%74% PILOTs 181 14 765 819 54 66 42%42% Operating Revenue 3,944 827 14,109 15,155 1,046 1,202 42%40% Interest Revenue 280 67 1,276 1,320 44 (E)180 52%49% Development Fees/PIFs/Contributions (0)(106)625 614 (11)(1,581)49%23% Financing Sources 0 0 0 0 0 (6)0% Other Misc.10 (14)145 119 (26)(F)(154)41%25% Total Lapsing Revenue**4,234 774 16,154 17,208 1,054 (359)43%39% Non-lapsing Revenue 17 24 24 TOTAL**$ 4,251 $ 17,232 $ (336) Variance Analysis: (A) (B) (C) (D) (E) (F) * ** Residential sales are 2.4% over budget and 4.5% more than YTD 2024. 3 Water Fund 2025 Department Expense In thousands `Percent of Year 50.0% June Year to Date Actual YTD Bdgt Actual $ 481 $ 89 $ 2,957 $ 2,973 $ (16)(A) Water Resources 86 19 2,033 1,976 58 (205)$ 2,147 55% Water Quality Lab 94 4 637 599 39 32 $ 701 52% Subtotal WR&T $ 661 $ 112 $ 5,628 $ 5,548 $ 80 $ (258)$ 6,656 56% Transmission & Distribution 425 (117)1,979 2,271 (292)(B) Water Meters O&M 84 5 503 468 35 (55)$ 641 60% Engineering 46 16 375 220 155 (22)$ 220 27% Subtotal WEFS 555 (96)2,856 2,959 (103)(540)$ 3,140 48% Water Conservation 79 44 679 536 142 (D)(85)$ 688 46% PILOTs 181 (14)765 819 (53)(E) Admin Services - CS&A 498 (0)2,989 2,989 (0)(354)$ 2,989 50% Other Payments & Transfers 156 0 1,081 1,115 (34)(F) Subtotal Operating Expenses $ 2,130 $ 46 $ 13,998 $ 13,966 0 $ 32 $ (1,320)$ 15,474 51% Debt Service 0 0 0 0 0 0 $ 0 Minor Capital 9 245 1,402 591 810 (342)$ 1,644 79% Total Lapsing $ 2,139 $ 290 $ 15,400 $ 14,558 $ 842 $ (1,663)$ 17,119 53% Non-lapsing Expenses 773 7,102 (5,510) TOTAL $ 2,911 $ 21,659 $ (7,173) Variance Analysis: (A) (B) (C) (D) (E) (F) completed as of May end. Water Assessment charges over ($26) but payment to Northern Water for Pleasant Valley Pipeline Ops and Maintenance Assessment aligns with FY25 total assessment budget. Solid Waste Services is over ($37) due to yearly payment to Larimer County for sludge removal. Based on historic overages in Solid Waste Services, additional budget should be incorporated in future years for sludge removal. Vehicles and Supplies cost over ($27), accounting for ~70% of total annual budget. Clothing over ($17), with yearly budget over ($4). Laboratory supplies is over ($9k), with only $2k in annual budget remaining. back to 2024 overspend expected to continue. Addition of 2025 watermain breaks and associated costs, including overtime and standby pay, was offset by underspend in Fuel by $15, Tools by $30, and Clothing by $4. on program offerings and demand. WC recently incorporated a bonus incentive to support the Xeriscape Program. While costs historically have been underspent, demand will increase through year-end providing increase in costs. 4 Wastewater Fund Revenue in thousands Percent of Year 50.0% June Year to Date Actual Budget Residential WW Sales $ 1,513 *$ 24 $ 8,936 $ 9,068 $ 132 (A)$ 536 51%53% Com/Indl WW Sales 560 *1 2,855 2,986 131 (B)204 47%48% District WW Sales 39 *2 224 235 11 12 53%52% Other WW Sales 48 *18 115 209 94 (C)26 70%49% PILOTs 127 2 720 737 17 45 50%52% Operating Revenue 2,287 47 12,850 13,235 385 824 50%52% Interest Revenue 177 54 737 792 55 117 54%50% Development Fees/PIFs/Contributions 23 (5)209 912 703 (D)462 175%105% Financing Sources 0 0 0 0 0 0 Other Misc.30 24 64 97 32 (4)83%189% Total Lapsing Revenue**2,517 121 13,860 15,036 1,176 1,398 53%53% Non-lapsing Revenue 0 0 0 TOTAL**$ 2,517 $ 15,036 $ 1,398 Variance Analysis: (A) (B) (C)Septage Treatment Charge $93. (D) (E) * ** 5 Wastewater Fund 2025 Department Expense In thousands Percent of Year 50.0% Excludes depreciation and transfers June Year to Date Actual (Over)/ YTD Bdgt Actual (Over)/ Actual + $ 653 $ (14)$ 3,778 $ 3,636 $ 142 (A)$ (518)$ 4,192 52% 105 (5)631 618 13 (90)712 54% Subtotal WR&T 758 (19)4,409 4,254 156 (608)4,904 52% 190 22 1,166 1,085 81 (188)1,091 44% 37 40 415 226 189 (B)(34)286 35% Subtotal WEFS 227 61 1,581 1,311 270 (222)1,377 41% 127 (2)720 737 (17)(C)(46)737 50% 348 (0)2,088 2,088 (0)(545)2,088 50% 115 0 829 846 (17)(D)70 880 42% Subtotal Operating Expenses $ 1,574 $ 40 $ 9,628 $ 9,236 $ 392 $ (1,351)$ 9,986 49% 0 150 150 150 0 $ 38 150 6% 60 6 742 451 291 (E)$ (331)968 75% 250 1,261 1,410 (A) (B) (C) (D) (E) orders with on-call consultants, flat by year-end (YE)), Other Professional & Tech $27 (will spend by YE), Communication Supplies $13, Testing Services $12 (awaiting invoices for required biosolids testing; will spend by YE), Natural Gas $11 (natural gas boilers have not had to run due to milder winter and spring temps), Legal Services $11, and Tools & Related Supplies $10, offset by Personnel ($52) (2 Water Treatment Facility employees' time inadvertently charged here, ~$43 correction pending, and lead operator pay increased with the One Water Operator effort; vacancies on hold), Software Maintenance & Support ($32) (prepaid software agreements for two years in ICE, will be over if not put on balance sheet), Vehicle Repair Services ($28) (Resource Recovery truck has high mileage and has had repairs, associated with the mileage, required for safety), and Electrical Parts ($12). needed and planning to spend for modeling work). 6 Stormwater Fund Revenue in thousands Percent of Year 50.0% June Year to Date Actual Budget Single Family Residential SW Services $ 788 *$ 33 $ 4,535 $ 4,711 $ 176 (A)$ 307 52%53% Non-single Family SW Services 956 *41 5,488 5,687 199 (B)317 52%53% Operating Revenue 1,744 74 10,023 10,398 375 625 52%53% Interest Revenue 252 136 692 1,172 480 (C)63 85%46% Development Fees/PIFs/Contributions 85 11 441 531 90 (D)44 60%51% Financing Sources 0 0 0 0 0 0 Other Misc.1 (1)6 8 1 (E)(41)52%10% Total Lapsing Revenue**2,081 221 11,162 12,109 947 691 54%52% Non-lapsing Revenue 0 0 0 TOTAL**$ 2,081 $ 12,109 $ 691 Variance Analysis: (A) (B) (C) (D) (E) * ** 7 Stormwater Fund 2025 Department Expense In thousands Percent of Year 50.0% Excludes depreciation and transfers June Year to Date Actual Budget Actual $ 288 $ (7)$ 1,350 $ 1,300 $ 50 (A)$ (204)$ 1,482 48% 142 11 930 853 77 (B)(63)939 49% 7 35 164 48 116 (C)152 204 39% 400 (0)2,399 2,399 (0)(559)2,399 50% 83 0 541 557 (17)(D)(15)591 34% Subtotal Operating Expenses $ 921 $ 39 $ 5,383 $ 5,157 $ 226 $ (689)$ 5,615 47% 900 0 900 900 0 185 900 30% 125 (45)1,268 488 780 (E)(214)1,195 87% 1,826 5,986 (4,293) (A) (B) (C) (D) (E) staff time development review investigations and appraisals) offset by Personnel ($45) (investigating, appears surveying time charged here and potentially incorrect labor distributions) Hazardous Material $23 (all $40 of 2025 budget for spill response inadvertently all in January, expenses vary greatly based on spills), and Other Professional & Technical $13 (Poudre Water Quality Network contract/PO is in progress). 8