Parent Budget % %
INVESTMENT EARNINGS 3,274 5,000 5,000 0.00 0 0.00
3,274 5,000 5,000 0.00 0 0.00
CONTRIBUTIONS -42 0 0 0.00 0 0.00
-42 0 0 0.00 0 0.00
WTR-USAGE 959,779 1,287,000 1,087,000 -15.54 -122,000 -9.48WTR-BASE 960,009 860,000 860,000 0.00 0 0.00WTR-REV. OTHR 10,742 0 7,000 0.00 0 0.00WTR-REV. OTHR-TURN ON FEE 12,849 11,000 8,500 -22.73 -3,000 -27.27WTR-REV. OTHR-LATE FEE 26,844 25,000 35,000 40.00 -3,700 -14.80WTR-REV. OTHR-BACKFLOW 17,787 10,000 3,500 -65.00 0 0.00WTR-REIMB 3,141 0 0 0.00 0 0.00WTR-REIMB-BCKFLW SPCL ASSMNT 587 0 0 0.00 0 0.00WTR-REIMB-RTRN CHCK FEE 70 0 0 0.00 0 0.00CNSRVTN-GRANTS 0 0 0 0.00 0 0.00 1,991,807 2,193,000 2,001,000 -0.09 -128,700 -0.061,995,039 2,198,000 2,006,000 0.00 -128,700 0.00 SALARIES AND BENEFITS 813,559 670,260 658,530 0.00 420 5.86 PAYOUTS 32,353 28,110 33,575 0.00 -1,120 0.00MATERIALS & SUPPLIES 17,422 22,000 18,500 -15.91 0 0.00ALLOCATED-MATERIALS & SUPPLIES 612 216 216 0.00 408 188.89 18,035 22,216 18,716 0.00 408 188.89
CNTRCT SVCS-PROFESSIONAL SVCS 27,448 7,000 7,000 0.00 -2,000 -28.57ALLOCATED-PROFESSIONAL SVCS 6,829 16,066 11,886 -26.02 2,175 13.54CNTRCT SVCS-TECH & DATA MGMT 50,819 48,940 63,940 30.65 -3,300 -6.74ALLOCATED-TECH & DATA MGMT 31,924 28,330 32,650 15.25 7,952 28.07CNTRCT SVCS-SPECIAL PROJECT 0 69,650 110,000 57.93 30,350 43.58CNTRCT SVCS-GENERAL 17,084 28,684 79,824 178.29 3,092 10.78WATER RATE STUDY 663 0 0 0.00 15,000 1.00ALLOCATED-GENERAL 11,610 17,936 17,936 0.00 -1,069 -5.96 146,378 216,606 323,236 0.00 67,200 -5.96
Increase /
(Decrease)
2023-2024
Proposed
Increase /
(Decrease)
Account Number
2019-2020
Total Activity
2020-2021
Total Activity
2021-2022
Total Activity
2022-2023
Adopted
2022-2023
EST Actuals
Budget Comparison Report
Enterprise (Water and Wastewater) Funds Account Summary Comparison 1
Budget
Comparison 1
to Parent
Budget
Comparison 2
Budget
Comparison 2
to Parent
Budget
Fund: 401 - WATER OPERATING
Revenue
Category: 650 - INVESTMENT EARNINGS
401-00-65010-000000 16,628 8,982 0
Category: 700 - SALARIES AND BENEFITS
COMBINED 506,527 737,228 0 699,090
COMBINED
Total Category: 660 - CONTRIBUTIONS: 0 0 0 0
Category: 680 - SPECIAL REVENUESCategory: 660 - CONTRIBUTIONS 401-00-66010-000000 00 0 0
5,000
Total Category: 650 - INVESTMENT EARNINGS: 16,628 8,982 0 5,000 401-00-68100-000000 279 35,257 7,000 0
401-00-68102-000000 9,825 7,270 -2,500 8,000
401-00-68010-000000 1,056,377 1,181,243 -200,000 1,165,000 401-00-68020-000000 809,815 865,724 0 860,000
401-00-68150-000000 00 0 0
401-00-68152-000000 2,481 202 0 0
401-00-68104-000000 20,343 25,380 10,000 21,300
401-00-68106-000000 13,359 12,766 -6,500 10,000
Total Category: 680 - BILLING: 1,912,779 2,128,145 -192,000 2,064,300 401-00-69100-000000 0 194 0 0401-00-68154-000000 300 110 0 0 Total Revenue: 1,929,407 2,137,127 -42,000 2,069,300
Expense
Category: 707 - PAYOUTS
25,265 0 5,000
401-00-80000-1ALLOC 0 0 0 624
Total Category: 800 - MATERIAL & SUPPLY: 48,297 13,875 -3,500 22,624 Category: 800 - MATERIAL & SUPPLY
401-00-80000-000000 48,297 13,875 -3,500 22,000
6,167 38,330 5,465 26,990
401-00-80186-1ALLOC 24,670 33,932 4,320 36,282
401-00-80187-000000 0 0 40,350 100,000401-00-80185-1ALLOC 13,009 13,221 -4,180 18,241401-00-80186-000000 34,878 43,699 15,000 45,640 Category: 801 - CONTRACT SERVICES
401-00-80185-000000 9,024
401-00-80188-1ALLOC 8,325 10,152 0 16,867
Total Category: 801 - CONTRACT SERVICES: 114,529 147,713 106,630 283,806 401-00-80188-000000 24,624 21,444 51,140 31,776
401-00-80188-17RATE 0 0 0 15,000
Parent Budget % %
Increase /
(Decrease)
2023-2024
Proposed
Increase /
(Decrease)
Account Number
2019-2020
Total Activity
2020-2021
Total Activity
2021-2022
Total Activity
2022-2023
Adopted
2022-2023
EST Actuals
Comparison 1
Budget
Comparison 1
to Parent
Budget
Comparison 2
Budget
Comparison 2
to Parent
Budget
SVCS-LEGAL 4,810 0 3,800 0.00 0 0.00ALLOCATED-LEGAL RETAINER 8,633 9,509 9,509 0.00 371 3.90ALLOCATED-LEGAL NON-RETAINER 1,077 5,400 1,080 -80.00 -4,360 -80.74SVCS-LEGAL-SPCL-ALLOCATED 1,321 2,700 2,700 0.00 576 21.33 15,839 17,609 17,089 0.00 -3,413 21.33
UTILITIES - COMCAST 382 450 450 0.00 1,443 320.67UTILITIES - PG&E 60,365 61,300 81,300 32.63 32,540 0.53UTILITIES - SONOMA EVERGREEN 6,335 7,100 7,100 0.00 1,100 0.15UTILITIES-PHONE 7,718 7,650 7,650 0.00 0 0.00 74,801 76,500 96,500 0.00 35,083 0.46
R&M-GENERAL 36,643 25,350 35,000 38.07 650 2.56R&M-VEHICLE 6,463 57,750 57,750 0.00 -5,250 -9.09 43,106 83,100 92,750 0.00 -4,600 -9.09
OTHER EXPENSES 0 0 0 0.00 0 0.00ADS.& PUBS 953 300 1,600 433.33 0 0.00BAD DEBT WRITE OFF -68,343 0 0 0.00 0 0.00BANK & MERCHANT FEES 0 16,590 37,800 127.85 28,410 1.71ALLOCATED-BANK & MERCHANT FEES 17,868 1,193 1,193 0.00 575 48.20DUES & SUBSCRIPTIONS 14,365 23,370 23,370 0.00 -1,110 -4.75ALLOCATED-DUES & SUBSCRIPTIONS 0 1,470 1,470 0.00 -56 -3.81EQUIPMENT RENTAL 1,818 2,540 2,540 0.00 920 36.22ALLOCATED-EQUIPMENT RENTAL 0 1,609 1,609 0.00 -787 -48.91INSURANCE-OTHER 0 0 0 0.00 21,640 0.00ALLOCATED-OTHER INSURANCE 56,468 69,169 69,169 0.00 4,863 7.03LICENSING-SOFTWARE 0 0 0 0.00 5,000 0.00MEETING & TRAINING 352 500 650 30.00 0 0.00RECRUITING 323 400 400 0.00 0 0.00POSTAGE 1,462 550 850 54.55 950 1.73PRNTG-PSTG-UTILITY BILLING 9,586 6,600 3,600 -45.45 2,400 0.36PRINTING/COPIES 645 500 500 0.00 0 0.00ALLOCATED-PRINTING/COPIES 193 1,620 2,270 40.12 -60 -3.70REGULATORY FEES 16,468 18,000 19,000 5.56 -4,500 -25.00SMALL TOOLS & EQUIP. 2,261 9,000 49,000 444.44 0 0.00TRAVEL, MEALS, LODGING 412 500 500 0.00 0 0.00VEHICLE FUEL EXPENSE 6,898 5,000 8,320 66.40 0 0.00 61,731 158,911 223,841 66.40 58,245 0.37
ADMIN FEE-BACKFLOW 42 30 30 0.00 0 0.00
42 30 30 0.00 0 0.00
INVESTMENT EXPENSE - FMV 14,430 0 0 0.00 0 0.00INT. EXP-INTRFND LN 9,147 9,503 9,503 0.00 0 0.00PRINCIPAL-INTRFND LN 0 676,966 676,966 0.00 -582,000 -85.97PRINCIPAL-LEASE 0 0 0 0.00 0 0.00 23,577 686,469 686,469 0.00 -582,000 0.00
Category: 802 - LEGAL
401-00-80285-000000 11,967 7,207 3,800 0
Category: 803 - UTILITIES
401-00-80302-000000 318 335 0 1,893
401-00-80286-1ALLOC 379 527 0 3,276
Total Category: 802 - LEGAL: 26,061 16,821 -520 14,196
401-00-80285-1ALLOC 9,439 7,432 0 9,880
401-00-80285-2ALLOC 4,277 1,655 -4,320 1,040401-00-80306-000000 6,031 7,593 0 7,650 Total Category: 803 - UTILITIES: 91,127 97,990 20,000 111,583 401-00-80303-000000 77,645 83,279 20,000 93,840
401-00-80305-000000 7,132 6,783 0 8,200
Category: 806 - OTHER EXPENSES
401-00-80600-000000 315 0 0 0
401-00-80572-000000 25,298 61,040 0 52,500
Total Category: 805 - REPAIR & MAINTENANCE: 41,018 77,023 9,650 78,500 Category: 805 - REPAIR & MAINTENANCE
401-00-80570-000000 15,720 15,983 9,650 26,000401-00-80609-000000 0 18 21,210 45,000401-00-80609-1ALLOC 12,595 17,495 0 1,768401-00-80605-000000 562 0 1,300 300 401-00-80607-000000 -41 96,262 0 0
401-00-80616-000000 4,099 530 0 3,460
401-00-80616-1ALLOC 236 26 0 822
401-00-80611-000000 25,648 21,356 0 22,260
401-00-80611-1ALLOC 0 0 0 1,414401-00-80626-000000 3,594 0 0 5,000 401-00-80628-000000 0 294 150 500
401-00-80620-000000 6,438 0 0 21,640
401-00-80620-1ALLOC 39,202 52,623 0 74,032
401-00-80631-000000 6,867 8,870 -3,000 9,000
401-00-80632-000000 3,810 22 0 500401-00-80629-000000 199 345 0 400 401-00-80630-000000 16 530 300 1,500
401-00-80645-000000 6,125 4,143 40,000 9,000
401-00-80652-000000 553 0 0 500
401-00-80632-1ALLOC 248 197 650 1,560401-00-80640-000000 12,945 13,003 1,000 13,500 Total Category: 807 - FISCAL FEES: 21 -4,357 0 30
Category: 808 - DEBT SERVICECategory: 807 - FISCAL FEES 401-00-80740-000000 21 -4,357 0 30
401-00-80654-000000 4,956 5,274 3,320 5,000
Total Category: 806 - OTHER EXPENSES: 128,365 220,986 64,930 217,156 Total Category: 808 - DEBT SERVICE: 13,434 11,309 0 104,469 401-00-80827-000000 0 0 0 94,966
401-00-80836-000000 00 0 0401-00-80822-999999 00 0 0401-00-80826-000000 13,434 11,309 0 9,503 Parent Budget % %
Increase /
(Decrease)
2023-2024
Proposed
Increase /
(Decrease)
Account Number
2019-2020
Total Activity
2020-2021
Total Activity
2021-2022
Total Activity
2022-2023
Adopted
2022-2023
EST Actuals
Comparison 1
Budget
Comparison 1
to Parent
Budget
Comparison 2
Budget
Comparison 2
to Parent
Budget
ALLOCATED-FIXED ASSET-VEHICLE 0 53,575 53,575 0.00 -35,375 -66.03 0 53,575 53,575 0.00 -35,375 -66.03
OPER TRANS OUT-WTR 0 0 0 0.00 0 0.00
0 0 0 0.00 0 0.00
AQUEDUCT WATER USAGE 453,872 600,000 580,000 -3.33 35,250 0.06BACKFLOW 16,580 17,000 3,605 -78.79 -12,000 -0.71GSA - PUMP WELL USE FEE 5,252 0 12,700 0.00 15,000 1.00CNSRVTN-EDUCATION PRGRM 30,488 26,000 10,000 -61.54 -21,000 -80.77CNSRVTN-CSH 4 GRASS 5,768 4,000 4,000 0.00 0 0.00CNSRVTN-TOILET RPLCMNT 100 0 0 0.00 0 0.00CNSRVTN-WASHER 75 250 250 0.00 0 0.00CNSRVTN-WATER AUDITS 4,674 4,000 4,000 0.00 0 0.00CNSRVTN-WATER SMART 15,539 8,000 15,540 94.25 8,000 100.00 532,348 659,250 630,095 94.25 -13,000 100.00
1,761,769 2,672,636 2,834,406 0.06 -565,968 -0.21
233,270 -474,636 -828,406 94.25 437,268 100.00
1,675,307 696,440 846,901 1.00 151,961 1.00
521,458 595,850 644,381 0.08 -45,464 1.00
Reserves in Excess: 809,746 843,473 101,930 298,015 1,153,849 100,590 202,520 1.01 197,425 1.00 Category: 809 - CAPITAL OUTLAY
Total Category: 810 - TRANS OUT & OTHER USES: 0 0 0 0
Category: 820 - ENTERPRISECategory: 810 - TRANS OUT & OTHER USES 401-00-81000-000000 00 0 0
401-00-80905-1ALLOC 0 0 0 18,200
Total Category: 809 - CAPITAL OUTLAY: 0 0 0 18,200
401-00-82030-000000 0 0 12,700 15,000
401-00-82050-000000 25,181 25,209 -16,000 5,000401-00-82010-000000 475,192 602,082 -20,000 635,250 401-00-82020-000000 11,418 12,406 -13,395 5,000
401-00-82054-000000 150 75 0 250
401-00-82055-000000 549 1,059 0 4,000401-00-82051-000000 460 1,000 0 4,000401-00-82053-000000 00 0 0 Total Fund: 401 - WATER OPERATING: 243,697 130,608 -203,770 130,212 Total Expense: 1,685,710 2,006,520 161,770 1,939,088
401-00-82058-03PWGL 23,684 7,770 7,540 16,000
Total Category: 820 - ENTERPRISE: 536,633 649,600 -29,155 646,250 Ending Fund Balance/Deficit: 1,311,429 1,442,037 150,461 848,401 Required Reserve: 501,683 598,563 48,531 550,386
Parent Budget % %
Increase /
(Decrease)
2023-2024
Proposed
Increase /
(Decrease)
Account Number
2019-2020
Total Activity
2020-2021
Total Activity
2021-2022
Total Activity
2022-2023
Adopted
2022-2023
EST Actuals
Comparison 1
Budget
Comparison 1
to Parent
Budget
Comparison 2
Budget
Comparison 2
to Parent
Budget
INVESTMENT EARNINGS 2,440 5,000 5,000 0.00 0 0.00
2,440 5,000 5,000 0.00 0 0.00
OPER TRANS IN-WTR CAP 0 0 0 0.00 0 0.00
0 0 0 0.00 0 0.00
WTR-COLL. SYSTM CHRGS 0 0 0 0.00 0 0.00WTR-CONNECTION FEES 327,427 0 0 0.00 0 0.00WTR CPTL-REV.OTHR-METER 5,164 1,700 0 -100.00 0 0.00WTR CPTL-REV.OTHR 378 0 0 0.00 0 0.00 332,969 1,700 0 0.00 0 0.00335,409 6,700 5,000 0.00 0 0.00 INVESTMENT EXPENSE - FMV 12,183 0 0 0.00 0 0.00
12,183 0 0 0.00 0 0.00
FIXED ASSETS-IMPRVMNTS 0 0 0 0.00 0 0.00
0 0 0 0.00 0 0.00
WTR- Well 4 (W. Cotati/116) 0 50,000 50,000 0.00 -50,000 -100.00CIP-SCADA SYSTEM 0 150,000 80,000 -0.47 -50,000 -33.33WTR-CIP-WELL 1A IMPRVMNTS 0 0 0 0.00 42,500 0.00WTR - WATER ATM 0 0 0 0.00 75,000 0.00Portal, Mercantile & Aaron Main Replacement 0 608,900 131,105 0.00 -608,900 -100.00 0 808,900 261,105 0.00 -591,400 -100.00
12,183 808,900 261,105 0.00 -593,900 -100.00
323,225 -802,200 -256,105 0.00 593,900 -100.00
1,139,059 134,484 882,954 1.00 537,670 1.00
402-00-92200-63PWGL 0 0 0 75,000
Fund: 402 - WATER CAPITAL
Revenue
Category: 650 - INVESTMENT EARNINGS
Total Category: 680 - SPECIAL REVENUES: 224,790 86,647 -1,700 1,700 402-00-68120-000000 12,645 15,588 -1,700
Total Category: 670 - TRANSFR IN & OTHR SOURCES: 0 0 0 0 Category: 680 - SPECIAL REVENUESCategory: 670 - TRANSFR IN & OTHR SOURCES 402-00-67000-000000 00 0 0402-00-65010-000000 9,765 6,085 0 5,000 Total Category: 650 - INVESTMENT EARNINGS: 9,765 6,085 0 5,000 1,700
402-00-68126-000000 00 0 0
402-00-68030-000000 1,750 0 0 0
402-00-68040-000000 210,395 71,059 0 0
0 Total Category: 808 - DEBT SERVICE: 0 0 0 0
Category: 808 - DEBT SERVICE
402-00-80822-999999 00 0
Total Revenue: 234,555 92,732 -1,700 6,700
Expense
Total Category: 809 - CAPITAL OUTLAY: 0 13,439 0 0
Category: 911 - CAPITAL PROJECTCategory: 809 - CAPITAL OUTLAY 402-00-80910-000000 0 13,439 0 0
Total Category: 911 - CAPITAL PROJECT: 12,150 0 -547,795 217,500 402-00-92200-63PWGL 0 0 0 42,500
402-00-92200-PORTAL 0 0 -477,795 0402-00-92200-22PWGL 00 0 0402-00-92200-53PWGL 12,150 0 -70,000 100,000 Total Expense: 12,150 13,439 0 217,500
Total Fund: 402 - WATER CAPITAL: 222,405 79,293 -1,700 -210,800 Ending Fund Balance/Deficit: 736,541 815,834 748,470 672,154 Parent Budget % %
Increase /
(Decrease)
2023-2024
Proposed
Increase /
(Decrease)
Account Number
2019-2020
Total Activity
2020-2021
Total Activity
2021-2022
Total Activity
2022-2023
Adopted
2022-2023
EST Actuals
Comparison 1
Budget
Comparison 1
to Parent
Budget
Comparison 2
Budget
Comparison 2
to Parent
Budget
CONSERVATION FEE 17,750 0 0 0.00 0 0.00
17,750 0 0 0.00 0 0.00
INVESTMENT EARNINGS 6,736 5,000 5,000 0.00 0 0.00OTHER INTEREST 7,247 0 0 0.00 0 0.00 404-00-65000-000000 INTERFUND DEBT 0 0 0 0.00 0 0.00
13,983 5,000 5,000 0.00 0 0.00
SWR-USAGE 1,376,311 1,514,000 1,346,000 -0.11 -152,150 -10.05SWR-BASE 1,402,468 1,548,000 1,539,000 -0.01 82,000 0.05SWR-REIMB 20,013 0 0 0.00 0 0.00SWR-REIMB SWR SPCL ASSMNT 565 0 300 0.00 0 0.00 2,799,357 3,062,000 2,885,300 0.00 -340,150 0.002,831,090 3,067,000 2,890,300 0.00 -340,150 0.00 SALARIES AND BENEFITS 793,654 667,690 656,585 -0.02 28,680 0.04PAYOUTS 31,781.11 27,180.00 33,575.00 0.00 -1,030 0.00MATERIALS & SUPPLIES 6,914 7,000 7,000 0.00 0 0.00ALLOCATED-MATERIALS & SUPPLIES 582 212 212 0.00 400 188.68 7,496 7,212 7,212 0.00 400 188.68
CNTRCT SVCS-PROFESSIONAL SVCS 25,320 7,500 7,500 0.00 -5,500 -73.33ALLOCATED-PROFESSIONAL SVCS 6,528 15,768 11,666 -26.01 2,122 13.46CNTRCT SVCS-TECH & DATA MGMT 11,735 13,100 28,100 114.50 -600 -4.58ALLOCATED-TECH & DATA MGMT 30,210 27,806 32,046 15.25 7,779 27.98CNTRCT SVCS-SPECIAL PROJECT 0 4,000 4,000 0.00 3,500 87.50CNTRCT SVCS-GENERAL 1,467 10,650 10,650 0.00 -650 -6.10SEWER 2017 RATE STUDY 663 0 0 0.00 1 0.00ALLOCATED-GENERAL 11,014 17,606 17,606 0.00 -1,057 -6.00 86,937 96,430 111,568 0.00 5,595 -6.00
SVCS-LEGAL 319 0 400 0.00 0 0.00ALLOCATED-LEGAL RETAINER 8,228 9,333 9,333 0.00 357 3.83ALLOCATED-LEGAL NON-RETAINER 1,023 5,300 1,060 -80.00 -4,280 -80.75SVCS-LEGAL-SPCL-ALLOCATED 1,257 2,650 2,650 0.00 563 21.25 10,828 17,283 13,443 0.00 -3,360 21.25
UTILITIES - COMCAST 382 450 450 0.00 1,406 312.44UTILITIES - PG&E 8,800 8,500 12,850 51.18 12,920 152.00UTILITIES - SONOMA EVERGREEN 564 600 600 0.00 1,440 240.00UTILITIES-PHONE 5,524 5,300 5,300 0.00 310 5.85 15,271 14,850 19,200 0.00 16,076 5.85
Category: 700 - SALARIES AND BENEFITS
COMBINED 628,053 714,520 -11,105 696,370
00 0 0
404-00-62040-000000 19,250 73,500 0 0
Total Category: 620 - CHARGES FOR SVS: 19,250 73,500 0 0 Fund: 404 - SEWER OPERATING
Revenue
Category: 620 - CHARGES FOR SVSCategory: 680 - SPECIAL REVENUES 404-00-68010-000000 1,188,382 1,284,295 -168,000 1,361,850 404-00-65100-000000 48,772 0 0 0
Total Category: 650 - INVESTMENT EARNINGS: 100,703 25,059 0 5,000 Category: 650 - INVESTMENT EARNINGS
404-00-65010-000000 51,931 25,059 0 5,000
404-00-68160-000000 714 0 300 0
Total Category: 680 - SPECIAL REVENUES: 2,482,811 2,569,085 -158,700 2,991,850 404-00-68020-000000 1,204,829 1,284,789 -9,000 1,630,000 404-00-68158-000000 88,886 0 0 0
Expense
Total Revenue: 2,602,763 2,667,644 -158,700 2,996,850
Category: 707 - PAYOUTS
6,089 11,700 0 7,612
Category: 801 - CONTRACT SERVICES
404-00-80000-1ALLOC 0 0 0 612
404-00-80000-000000 6,089 11,700 0 7,000
Category: 800 - MATERIAL & SUPPLY
COMBINED 6,166.73 37,853.43 6,395.00 26,150
Total Category: 800 - MATERIAL & SUPPLY:
404-00-80186-000000 12,149 15,522 15,000 12,500
404-00-80186-1ALLOC 23,644 32,233 4,240 35,585404-00-80185-000000 12,460 781 0 2,000404-00-80185-1ALLOC 12,603 12,578 -4,102 17,890 Total Category: 801 - CONTRACT SERVICES: 81,421 72,563 15,138 102,025 Category: 802 - LEGAL
404-00-80188-17RATE 00 0 1404-00-80188-1ALLOC 7,991 9,630 0 16,549 404-00-80187-000000 0 0 0 7,500
404-00-80188-000000 12,575 1,819 0 10,000
Total Category: 802 - LEGAL: 14,935 9,134 -3,840 13,923 Category: 803 - UTILITIES
404-00-80285-2ALLOC 4,097 1,570 -4,240 1,020
404-00-80286-1ALLOC 363 501 0 3,213
404-00-80285-000000 1,819 0 400 0
404-00-80285-1ALLOC 8,656 7,064 0 9,690
Total Category: 803 - UTILITIES: 13,207 15,407 4,350 30,926 Category: 805 - REPAIR & MAINTENANCE
404-00-80305-000000 529 596 0 2,040
404-00-80306-000000 4,254 5,487 0 5,610
404-00-80302-000000 318 335 0 1,856
404-00-80303-000000 8,105 8,989 4,350 21,420
Parent Budget % %
Increase /
(Decrease)
2023-2024
Proposed
Increase /
(Decrease)
Account Number
2019-2020
Total Activity
2020-2021
Total Activity
2021-2022
Total Activity
2022-2023
Adopted
2022-2023
EST Actuals
Comparison 1
Budget
Comparison 1
to Parent
Budget
Comparison 2
Budget
Comparison 2
to Parent
Budget
R&M-GENERAL 24,271 10,000 15,000 50.00 0 0.00R&M-VEHICLE 6,463 35,000 35,000 0.00 300 0.86 30,733 45,000 50,000 0.00 300 0.86
ADS.& PUBS 143 400 200 -50.00 0 0.00BAD DEBT WRITE OFF -41,630 0 0 0.00 0 0.00BANK & MERCHANT FEES 0 30,810 37,800 22.69 -12,310 -39.95ALLOCATED-BANK & MERCHANT FEES 33,009 1,171 1,171 0.00 563 48.08DUES & SUBSCRIPTIONS 13,998 10,000 10,750 7.50 2,913 29.13ALLOCATED-DUES & SUBSCRIPTIONS 0 1,442 1,442 0.00 -55 -3.81EQUIPMENT RENTAL 10,597 10,000 10,000 0.00 600 6.00ALLOCATED-EQUIPMENT RENTAL 0 1,579 1,579 0.00 -773 -48.96INSURANCE-OTHER 0 0 0 0.00 20,710 0.00ALLOCATED-OTHER INSURANCE 52,454 67,889 67,889 0.00 4,720 6.95LICENSING-SOFTWARE 0 0 0 0.00 5,600 0.00MEETING & TRAINING 327 2,000 395 -80.25 0 0.00RECRUITING 323 200 200 0.00 0 0.00POSTAGE 505 100 450 350.00 512 512.00PRNTG-PSTG-UTILITY BILLING 9,586 8,400 3,400 -59.52 0 0.00PRINTING/COPIES 645 50 250 400.00 0 0.00ALLOCATED-PRINTING/COPIES 183 1,590 2,225 39.94 -60 -3.77REGULATORY FEES 0 3,000 3,000 0.00 0 0.00SMALL TOOLS & EQUIP. 261 3,500 3,500 0.00 0 0.00TRAVEL, MEALS, LODGING 412 500 500 0.00 0 0.00VEHICLE FUEL EXPENSE 6,898 4,400 8,320 89.09 0 0.00 87,711 147,031 153,071 89.09 22,420 0.00
ADMIN FEE-DELINQUENT SEWER 607 0 0 0.00 0 0.00
607 0 0 0.00 0 0.00
INVESTMENT EXPENSE - FMV 26,536 0 0 0.00 0 0.00INTEREST - INTERFUND LOAN 25,517 49,786 49,786 0.00 -22,717 -45.63PRINCIPAL - INTERFUND LOAN 0 93,908 93,908 0.00 -53,479 -56.95 52,053 143,694 143,694 0.00 -76,196 -0.53
ALLOCATED-FIXED ASSET-VEHICLE 0 87,575 0 -1.00 -69,725 -79.62 0 87,575 0 -1.00 -69,725 -79.62
OPER TRANS OUT-SWR 0 0 0 0.00 0 0.00
0 0 0 0.00 0 0.00
PRINCIPAL - DEBT SERVICE 894,936 888,408 888,408 0.00 -71,099 -0.08WASTEWATER TREATMENT 1,250,570 1,420,000 1,483,920 4.50 111,644 0.08 2,145,506 2,308,408 2,372,328 0.03 40,545 0.02
404-00-80605-000000 308 699 -200 400
404-00-80607-000000 0 31,466 0 0
Total Category: 805 - REPAIR & MAINTENANCE: 45,784 48,152 5,000 45,300 Category: 806 - OTHER EXPENSES
404-00-80570-000000 18,457 18,817 5,000 10,000404-00-80572-000000 27,328 29,335 0 35,300404-00-80611-000000 17,989 13,893 750 12,913404-00-80611-1ALLOC 0 0 0 1,387404-00-80609-000000 0 0 6,990 18,500404-00-80609-1ALLOC 23,899 32,951 0 1,734404-00-80620-1ALLOC 37,470 49,776 0 72,609404-00-80620-000000 50 0 0 20,710 404-00-80616-000000 3,442 0 0 10,600
404-00-80616-1ALLOC 227 25 0 806
404-00-80629-000000 199 279 0 200404-00-80630-000000 0 0 350 612 404-00-80626-000000 3,594 0 0 5,600
404-00-80628-000000 358 284 -1,605 2,000
404-00-80632-1ALLOC 238 187 635 1,530404-00-80640-000000 2,625 2,848 0 3,000 404-00-80631-000000 6,867 8,870 -5,000 8,400404-00-80632-000000 63 16 200 50 Category: 807 - FISCAL FEES
404-00-80754-000000 6 146 0 0
404-00-80654-000000 4,956 5,274 3,920 4,400
Total Category: 806 - OTHER EXPENSES: 107,516 148,778 6,040 169,451 404-00-80645-000000 4,681 2,209 0 3,500404-00-80652-000000 553 0 0 500 404-00-80822-999999 00 0 0
404-00-80825-000000 33,677 26,160 0 27,069
Total Category: 810 - TRANS OUT & OTHER USES: 0 0 0 0
Category: 820 - ENTERPRISE
Total Category: 807 - FISCAL FEES: 6 146 0 0
Category: 808 - DEBT SERVICE
0 404-00-80905-1ALLOC 0 0 -87,575 17,850
Total Category: 809 - CAPITAL OUTLAY: 0 0 -87,575
Total Category: 808 - DEBT SERVICE: 33,677 26,160 0 67,498 Category: 809 - CAPITAL OUTLAY
404-00-80834-SUBREG 857,099 863,922 0 817,309
404-00-80835-000000 0 0 0 40,429
404-00-82040-000000 885,435 1,142,028 63,920 1,531,644
Category: 810 - TRANS OUT & OTHER USES
404-00-81000-000000 00 0
17,850
Total Category: 820 - ENTERPRISE: 1,742,534 2,005,950 63,920 2,348,953 Parent Budget % %
Increase /
(Decrease)
2023-2024
Proposed
Increase /
(Decrease)
Account Number
2019-2020
Total Activity
2020-2021
Total Activity
2021-2022
Total Activity
2022-2023
Adopted
2022-2023
EST Actuals
Comparison 1
Budget
Comparison 1
to Parent
Budget
Comparison 2
Budget
Comparison 2
to Parent
Budget
SWR-SCADA SYTM UPG 0 0 0 0.00 0 0.00
0 0 0 0.00 0 0.00
3,262,577 3,562,353 3,560,676 0.00 -347,273 -0.10
-431,486 -495,353 -670,376 0.00 7,123 -0.01
2,280,306 1,734,000 1,609,931 1.00 -612,299 1.00
963,157 1,025,598 1,025,095 0.00 -81,323 -0.08
1,317,149 708,402 584,836 -0.17 -530,976 -0.75
INVESTMENT EARNINGS 1,318 0 2,000 0.00 0 0.00INT. REV-INTRFND LOAN 9,147 552,220 552,220 0.00 -447,751 -81.08 10,464 552,220 554,220 0.00 -447,751 -81.08
OPER TRANS IN-SWR CAP 0 0 0 0.00 0 0.00
0 0 0 0.00 0 0.00
SWR-COLL. SYSTM CHRGS 36,567 36,567 36,567 0.00 -21,467 -58.71SWR-CONNECTION FEES 252,455 50,000 0 -100.00 -50,000 -100.00SWR CPTL-REIMB 0 3,000 3,000 0.00 0 0.00 289,022 89,567 39,567 0.00 -71,467 0.00299,486 641,787 593,787 0.00 -519,218 0.00 INVESTMENT EXPENSE - FMV 6,589 0 0 0.00 0 0.00
6,589 0 0 0.00 0 0.00
FIXED ASSET-EQUIP. 0 0 0 0.00 0 0.00
0 0 0 0.00 0 0.00
P-1 PIPELINE 0 0 0 0.00 0 0.00SWR-CIP-ST. JOSEPH 0 0 0 0.00 0 0.00SWR-SCADA PHASE 2 0 150,000 150,000 0.00 -50,000 -33.33WILLIAM/OLOF SEWER REPLACEMENT 0 0 0 0.00 0 0.00MANHOLE LATERAL REPAIR 109,597 0 70,000 1.00 96,000 0.00CYPRESS AVE. SEWER 0 0 0 1.00 640,000 1.00SWR-W. Sierra Ave Sewer Replacement 0 1,100,000 1,100,000 0.00 -1,100,000 -100.00 109,597 1,250,000 1,320,000 0.06 -414,000 -0.33116,185 1,250,000 1,320,000 0.06 -510,000 -0.41183,301 -608,213 -726,213 0.08 534,782 -0.88 Ending Fund Balance (Deficit): 1,203,140 693,470 72,738 77,127 876,771 77,820 150,558 0.93 -693 -0.01 00 Required Reserve: 793,714 925,386 -503 944,275
Reserves in Excess: 2,361,213 1,786,407 -123,566
404-00-92300-53PWGL 0 20,415 0 0
-124,069 1,121,701
177,426
Category: 911 - CAPITAL PROJECT
405-00-65010-000000 5,290 1,431 2,000 0
405-00-65100-000000 13,434 11,309 0 104,469
Fund: 405 - SEWER CAPITAL
Revenue
Category: 650 - INVESTMENT EARNINGS
Total Expense: 2,679,390 3,110,778 -1,677 3,215,080
Total Fund: 404 - SEWER OPERATING: -76,626 -443,134 -175,023 -488,230 Total Category: 911 - CAPITAL PROJECT: 0 20,415
Category: 680 - SPECIAL REVENUES
405-00-68030-000000 36,567 36,567 0 15,100
405-00-67000-000000 00 0 0
Total Category: 670 - TRANSFR IN & OTHR SOURCES: 0 0 0 0 Total Category: 650 - INVESTMENT EARNINGS: 18,723 12,740 2,000 104,469 Category: 670 - TRANSFR IN & OTHR SOURCESCategory: 808 - DEBT SERVICE 405-00-80822-999999 00 0
Total Revenue: 721,808 192,562 -48,000 122,569
Expense
Total Category: 680 - SPECIAL REVENUES: 703,084 179,823 -50,000 18,100 405-00-68040-000000 666,517 143,256 -50,000 0
405-00-68162-000000 0 0 0 3,000
Category: 809 - CAPITAL OUTLAY
405-00-80900-000000 0 8,915 0 0
405-00-92300-53PWGL 0 0 0 100,000
0 Total Category: 808 - DEBT SERVICE: 0 0 0 0
0 Total Category: 911 - CAPITAL PROJECT: 70,981 693,317 70,000 740,000 405-00-92300-WSIERA 00 0 0
405-00-92300-MNHOLE 0 83,615 70,000 0
Total Category: 809 - CAPITAL OUTLAY: 0 8,915 0 0
Category: 911 - CAPITAL PROJECT
405-00-92300-CYPRES 0 0 0 640,000
Total Expense: 70,981 702,232 70,000 740,000
Total Fund: 405 - SEWER CAPITAL: 650,826 -509,670 -48,000 -73,431 Ending Fund Balance: 3,154,927 2,711,793
405-00-92300-68PWGL 68,267 609,702 0 0405-00-92200-62PWGL 2,709 0 0 0 405-00-92300-38PWGL 50 0