GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
453 2012 WATER REV REF PROJECT
00 NOT APPLICABLE
SERVICES-SUPPLIES
TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FOR NOT APPLICABLE 0.00 0.00 0.00 0.00 0.00 0.00
FUN 453 0.00 0.00 0.00 0.00 0.00 0.00
LUISN Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
507 WATER CAPACITY
00 NOT APPLICABLE
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 2,332,003.45 0.00 0.00 0.00 2,332,003.45 0.00 TOTAL FOR SERVICES-SUPPLIES 2,332,003.45 0.00 0.00 0.00 2,332,003.45 0.00 TOTAL FOR NOT APPLICABLE 2,332,003.45 0.00 0.00 0.00 2,332,003.45 0.00 13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 574.00 0.00 612.95 0.00 (38.95) 106.78 TOTAL FOR SERVICES-SUPPLIES 574.00 0.00 612.95 0.00 (38.95) 106.78 TOTAL FOR DEBT SERVICE 574.00 0.00 612.95 0.00 (38.95) 106.78 50 WATER UTILITY SERVICES
SERVICES-SUPPLIES
44100 INTEREST EXPENSE 696,737.74 187,216.25 61,057.34 0.00 635,680.40 8.76 44610 ADMINISTRATIVE SERVICES CHARGE 27,156.00 6,789.00 6,789.00 0.00 20,367.00 25.00 TOTAL FOR SERVICES-SUPPLIES 723,893.74 194,005.25 67,846.34 0.00 656,047.40 9.37 TOTAL FOR WATER UTILITY SERVICES 723,893.74 194,005.25 67,846.34 0.00 656,047.40 9.37 FUN 507 3,056,471.19 194,005.25 68,459.29 0.00 2,988,011.90 2.23 LUISN Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
567 RECLAIMED WATER SYSTEM
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 143.68 839.37 0.00 (839.37) 0.00 41910 PERS-NORMAL 0.00 17.32 101.15 0.00 (101.15) 0.00
41920 MEDICARE 0.00 4.28 24.86 0.00 (24.86) 0.00
41931 WORKERS COMP 0.00 2.88 16.79 0.00 (16.79) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.14 0.78 0.00 (0.78) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 168.30 982.95 0.00 (982.95) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 7,659,178.17 0.00 0.00 0.00 7,659,178.17 0.00 42033 CONSTRUCTION MATERIALS 0.00 14.50 967.33 194,838.56 (195,805.89) 0.00 42900 PROF. & CONT. SVCS 397,464.35 52,864.02 63,622.99 390,208.09 (56,366.73) 114.18 TOTAL FOR SERVICES-SUPPLIES 8,056,642.52 52,878.52 64,590.32 585,046.65 7,407,005.55 8.06
SERVICES-SUPPLIES
TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00
CAPITAL OUTLAY
45100 LICENSED VEHICLES 33,914.59 0.00 217.50 33,914.59 (217.50) 100.64 TOTAL FOR CAPITAL OUTLAY 33,914.59 0.00 217.50 33,914.59 (217.50) 100.64 TOTAL FOR NOT APPLICABLE 8,090,557.11 53,046.82 65,790.77 618,961.24 7,405,805.10 8.46 13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 203.00 0.00 209.30 0.00 (6.30) 103.10 44101 DS INTEREST 2021 POBS 20,407.00 0.00 (3,354.55) 0.00 23,761.55 (16.43) TOTAL FOR SERVICES-SUPPLIES 20,610.00 0.00 (3,145.25) 0.00 23,755.25 (15.26) TOTAL FOR DEBT SERVICE 20,610.00 0.00 (3,145.25) 0.00 23,755.25 (15.26) 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 32,726.13 3,647.76 4,810.12 0.00 27,916.01 14.69 41140 FINAL LEAVE 0.00 531.67 531.67 0.00 (531.67) 0.00 41141 SP COMP-BILINGUAL 270.90 20.84 61.03 0.00 209.87 22.52 41910 PERS-NORMAL 1,594.94 442.08 587.01 0.00 1,007.93 36.80 41912 PERS-UNFUNDED 569.00 0.00 569.00 0.00 0.00 100.00 41920 MEDICARE 972.15 123.55 159.04 0.00 813.11 16.35
41929 SHORT TERM DISABILITY 104.73 25.25 32.69 0.00 72.04 31.21 41930 LONG TERM DISABILITY 222.53 41.90 54.28 0.00 168.25 24.39 41931 WORKERS COMP 659.94 72.69 95.98 0.00 563.96 14.54 41932 STATE UNEMPLOYMENT INSURANCE 29.71 3.83 4.93 0.00 24.78 16.59 LUISN Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
41940 HEALTH INSURANCE 8,148.89 669.59 1,168.29 0.00 6,980.60 14.33 41945 OPT OUT HEALTH INSURANCE 0.00 12.00 46.29 0.00 (46.29) 0.00 41946 LIFE INSURANCE 271.63 51.16 66.28 0.00 205.35 24.40 41951 HEALTH ALLOWANCE CREDIT 0.00 8.26 8.26 0.00 (8.26) 0.00 41996 VACANCY FACTOR (3,038.00) 0.00 0.00 0.00 (3,038.00) 0.00 TOTAL FOR SALARIES-BENEFITS 42,532.55 5,650.58 8,194.87 0.00 34,337.68 19.26
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 82.75 0.00 0.00 0.00 82.75 0.00 TOTAL FOR SERVICES-SUPPLIES 82.75 0.00 0.00 0.00 82.75 0.00 TOTAL FOR PUBLIC WORKS 42,615.30 5,650.58 8,194.87 0.00 34,420.43 19.22 53 RECLAIMED WATER
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 77,990.38 0.00 0.00 0.00 77,990.38 0.00 41141 SP COMP-BILINGUAL 450.35 0.00 0.00 0.00 450.35 0.00 41147 SP COMP-GRADE 4 CERT PAY 420.00 0.00 0.00 0.00 420.00 0.00 41148 SP COMP-GRADE 5 CERT PAY 1,266.15 0.00 0.00 0.00 1,266.15 0.00 41200 TEMPORARY EMPLOYEES 1,266.81 0.00 0.00 0.00 1,266.81 0.00 41300 OVERTIME 8,892.00 0.00 0.00 0.00 8,892.00 0.00
41400 SPECIAL DUTY PAY 958.00 0.00 0.00 0.00 958.00 0.00 41410 AUTO ALLOWANCE 57.60 0.00 0.00 0.00 57.60 0.00
41500 DEFERRED COMPENSATION MATCH 309.00 0.00 0.00 0.00 309.00 0.00 41510 PST DEFERRED COMPENSATION 8.04 0.00 0.00 0.00 8.04 0.00 41520 TIERED EMP DEF COMPENSATION 180.00 0.00 0.00 0.00 180.00 0.00 41530 TIERED RHS BENEFIT 100.00 0.00 0.00 0.00 100.00 0.00 41600 LONGEVITY 451.59 0.00 0.00 0.00 451.59 0.00
41700 ANNUAL LEAVE BUYBACK 1,025.22 0.00 0.00 0.00 1,025.22 0.00 41910 PERS-NORMAL 9,751.77 0.00 0.00 0.00 9,751.77 0.00 41912 PERS-UNFUNDED 1,365.00 0.00 1,365.00 0.00 0.00 100.00 41920 MEDICARE 2,781.63 0.00 0.00 0.00 2,781.63 0.00
41929 SHORT TERM DISABILITY 249.59 0.00 0.00 0.00 249.59 0.00 41930 LONG TERM DISABILITY 530.27 0.00 0.00 0.00 530.27 0.00 41931 WORKERS COMP 1,659.95 0.00 0.00 0.00 1,659.95 0.00 41932 STATE UNEMPLOYMENT INSURANCE 84.84 0.00 0.00 0.00 84.84 0.00 41940 HEALTH INSURANCE 16,322.10 14.51 43.54 0.00 16,278.56 0.26 41941 RETIREES HEALTH INSURANCE/OPEB 14,017.00 0.00 0.00 0.00 14,017.00 0.00 41945 OPT OUT HEALTH INSURANCE 1,320.00 0.00 0.00 0.00 1,320.00 0.00 41946 LIFE INSURANCE 647.26 0.00 0.00 0.00 647.26 0.00
41996 VACANCY FACTOR (19,281.00) 0.00 0.00 0.00 (19,281.00) 0.00 TOTAL FOR SALARIES-BENEFITS 122,823.55 14.51 1,408.54 0.00 121,415.01 1.14 LUISN Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 3,630.00 0.00 3.63 1,500.00 2,126.37 41.42 42033 CONSTRUCTION MATERIALS 108,447.40 16,733.47 29,813.92 0.00 78,633.48 27.49 42034 SAFETY MATERIALS/CONSTRUCTION 15.00 0.00 0.00 0.00 15.00 0.00 42055 COMPUTER EQUIPMENT & 2,546.32 0.00 2,488.54 0.00 57.78 97.73 42100 UNIFORM EXPENSE 6.32 0.00 60.99 0.00 (54.67) 965.03 42101 SAFETY SHOES - MOU ITEM 358.50 0.00 0.00 0.00 358.50 0.00 42200 ADVERTISING EXPENSE 486.00 0.00 0.00 0.00 486.00 0.00 42300 WIRELESS COMMUNICATION 770.40 0.00 0.00 0.00 770.40 0.00 42320 POSTAGE & SHIPPING 670.00 0.00 0.00 0.00 670.00 0.00 42340 OFFICE SUPPLIES 256.20 0.00 26.90 0.00 229.30 10.49 42350 PROGRAM EXPENDITURES 446.38 44.79 66.62 0.00 379.76 14.92 42365 RECYCLED CONTENT PRODUCTS 26.00 0.00 0.00 0.00 26.00 0.00 42410 ELECTRIC UTILITY 748,178.25 39,546.85 223,468.87 0.00 524,709.38 29.86 42500 RENTS & LEASES 17,679.00 4,419.75 4,419.75 0.00 13,259.25 25.00 42600 MOTOR POOL RENTAL - OPS & MTCE 4,594.00 0.00 0.00 0.00 4,594.00 0.00 42605 RETAINED VEHICLE EXPENSE 110.00 0.00 0.00 0.00 110.00 0.00 42660 MOTOR POOL RENTAL- 4,245.08 0.00 0.00 0.00 4,245.08 0.00 42710 MILEAGE/VEHICLE EXP REIMB 50.00 0.00 0.00 0.00 50.00 0.00 42813 MTCE & REPAIR - EQUIP & FAC 102,000.00 1,692.28 1,692.28 17,307.72 83,000.00 18.62 42815 SCADA MAINTENANCE 105,002.00 594.00 10,339.55 25,250.00 69,412.45 33.89 42816 MOWING/LANDSCAPE CONTRACTS 10,094.00 0.00 0.00 3,000.00 7,094.00 29.72 42900 PROF. & CONT. SVCS 475,983.40 36,838.83 66,080.55 357,505.02 52,397.83 88.99 43000 INSURANCE & SURETY BONDS 8,633.90 0.00 6,077.71 0.00 2,556.19 70.39 43100 MEMBERSHIP & DUES 8,687.70 0.00 0.00 0.00 8,687.70 0.00 43200 CONFERENCE, TRAINING & TRAVEL 316.30 19.27 19.27 0.00 297.03 6.09 43715 REGULATORY PERMIT & USE FEES 100.00 0.00 0.00 0.00 100.00 0.00 43716 JOB REQ CERTIFICATES & LICENSE 5.20 0.00 0.00 0.00 5.20 0.00 43722 PREVENTION & MAINTENANCE 155,696.69 2,270.38 9,051.69 25,750.00 120,895.00 22.35 44100 INTEREST EXPENSE 288,059.53 157,648.27 44,214.85 0.00 243,844.68 15.34 44200 BAD DEBTS EXPENSE 908.00 0.00 0.00 0.00 908.00 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 129,651.00 32,412.75 32,412.75 0.00 97,238.25 25.00 44613 INTERNAL SVC CHRG-WAREHOUSE 3,911.00 977.75 977.75 0.00 2,933.25 25.00 44614 INTERNAL SVC CHRG-INFO TECH 45,785.00 11,446.25 11,446.25 0.00 34,338.75 25.00 TOTAL FOR SERVICES-SUPPLIES 2,227,348.57 304,644.64 442,661.87 430,312.74 1,354,373.96 39.19
CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 100,000.00 0.00 0.00 0.00 100,000.00 0.00 TOTAL FOR CAPITAL OUTLAY 100,000.00 0.00 0.00 0.00 100,000.00 0.00 TOTAL FOR RECLAIMED WATER 2,450,172.12 304,659.15 444,070.41 430,312.74 1,575,788.97 35.68 LUISN Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
FUN 567 10,603,954.53 363,356.55 514,910.80 1,049,273.98 9,039,769.75 14.75 LUISN Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
570 WATER UTILITY
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 4,203.65 10,476.66 0.00 (10,476.66) 0.00 41141 SP COMP-BILINGUAL 0.00 35.01 107.20 0.00 (107.20) 0.00 41300 OVERTIME 0.00 133.60 133.60 0.00 (133.60) 0.00
41910 PERS-NORMAL 0.00 510.74 1,275.35 0.00 (1,275.35) 0.00 41920 MEDICARE 0.00 129.24 316.52 0.00 (316.52) 0.00
41931 WORKERS COMP 0.00 84.78 211.67 0.00 (211.67) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 3.99 9.77 0.00 (9.77) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 5,101.01 12,530.77 0.00 (12,530.77) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 37,264,626.62 0.00 0.00 0.00 37,264,626.62 0.00 40003 CIP-MATERIALS & SUPPLIES 14,373,040.00 0.00 0.00 0.00 14,373,040.00 0.00 42020 MINOR EQUIPMENT & FURNITURE 0.00 1,357.60 1,208.96 0.00 (1,208.96) 0.00 42033 CONSTRUCTION MATERIALS 39,771.62 68,052.46 61,941.98 14,217,973.06 (14,240,143.42) 35,904.78 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 43.72 43.72 0.00 (43.72) 0.00 42320 POSTAGE & SHIPPING 0.00 0.00 21.45 0.00 (21.45) 0.00 42700 OTHER EQUIPMENT RENTAL 0.00 153.60 153.60 0.00 (153.60) 0.00 42813 MTCE & REPAIR - EQUIP & FAC 0.00 36,896.98 0.00 0.00 0.00 0.00 42815 SCADA MAINTENANCE 6,683.00 0.00 0.00 19,678.57 (12,995.57) 294.45 42900 PROF. & CONT. SVCS 1,605,691.99 138,345.24 121,526.80 2,308,413.54 (824,248.35) 151.33 43300 CONSTRUCTION CONTRACTS 2,145,071.68 1,500,701.20 1,541,901.20 3,474,864.05 (2,871,693.57) 233.87 43301 CAPITAL IMPROVEMENTS 20,000.00 0.00 5,154.80 0.00 14,845.20 25.77 43727 INSPECTION 29,816.86 0.00 0.00 29,816.86 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 55,484,701.77 1,745,550.80 1,731,952.51 20,050,746.08 33,702,003.18 39.25
SERVICES-SUPPLIES
40002 CIP-CONTRACTUAL 429,265.50 0.00 0.00 0.00 429,265.50 0.00 TOTAL FOR SERVICES-SUPPLIES 429,265.50 0.00 0.00 0.00 429,265.50 0.00
CAPITAL OUTLAY
45100 LICENSED VEHICLES 231,743.52 361,465.35 381,475.35 231,743.52 (381,475.35) 264.61 TOTAL FOR CAPITAL OUTLAY 231,743.52 361,465.35 381,475.35 231,743.52 (381,475.35) 264.61 TOTAL FOR NOT APPLICABLE 56,145,710.79 2,112,117.16 2,125,958.63 20,282,489.60 33,737,262.56 39.91 13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 735.00 0.00 672.75 0.00 62.25 91.53 44101 DS INTEREST 2021 POBS 353,401.00 0.00 (58,093.21) 0.00 411,494.21 (16.43) TOTAL FOR SERVICES-SUPPLIES 354,136.00 0.00 (57,420.46) 0.00 411,556.46 (16.21) LUISN Page: 7 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
TOTAL FOR DEBT SERVICE 354,136.00 0.00 (57,420.46) 0.00 411,556.46 (16.21) 21 PLANNING & DEVELOPMENT
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 35,262.67 2,604.16 7,494.20 0.00 27,768.47 21.25 41141 SP COMP-BILINGUAL 704.00 54.16 158.61 0.00 545.39 22.52 41200 TEMPORARY EMPLOYEES 8,355.59 0.00 0.00 0.00 8,355.59 0.00 41510 PST DEFERRED COMPENSATION 108.62 0.00 0.00 0.00 108.62 0.00 41600 LONGEVITY 140.00 10.76 10.76 0.00 129.24 7.68
41910 PERS-NORMAL 4,350.85 321.62 923.42 0.00 3,427.43 21.22 41912 PERS-UNFUNDED 1,024.00 0.00 1,024.00 0.00 0.00 100.00 41920 MEDICARE 1,188.14 77.22 222.33 0.00 965.81 18.71
41929 SHORT TERM DISABILITY 112.84 10.67 30.71 0.00 82.13 27.21 41930 LONG TERM DISABILITY 239.78 17.73 51.01 0.00 188.77 21.27 41931 WORKERS COMP 886.44 51.93 150.05 0.00 736.39 16.92 41932 STATE UNEMPLOYMENT INSURANCE 40.02 2.38 6.85 0.00 33.17 17.11 41940 HEALTH INSURANCE 4,660.45 387.61 941.49 0.00 3,718.96 20.20 41946 LIFE INSURANCE 292.67 21.60 62.17 0.00 230.50 21.24 41996 VACANCY FACTOR (2,548.00) 0.00 0.00 0.00 (2,548.00) 0.00 TOTAL FOR SALARIES-BENEFITS 54,818.07 3,559.84 11,075.60 0.00 43,742.47 20.20
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 35.00 0.00 0.00 0.00 35.00 0.00 TOTAL FOR SERVICES-SUPPLIES 35.00 0.00 0.00 0.00 35.00 0.00 TOTAL FOR PLANNING & DEVELOPMENT DEPT54,853.07 3,559.84 11,075.60 0.00 43,777.47 20.19 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 713,508.90 28,939.00 86,451.50 0.00 627,057.40 12.11 41140 FINAL LEAVE 0.00 17,139.00 17,139.00 0.00 (17,139.00) 0.00 41141 SP COMP-BILINGUAL 4,898.75 263.69 754.71 0.00 4,144.04 15.40 41200 TEMPORARY EMPLOYEES 26,416.15 956.27 3,223.75 0.00 23,192.40 12.20 41300 OVERTIME 0.00 280.02 444.02 0.00 (444.02) 0.00
41400 SPECIAL DUTY PAY 0.00 388.04 1,125.89 0.00 (1,125.89) 0.00 41410 AUTO ALLOWANCE 1,152.00 88.62 259.53 0.00 892.47 22.52 41500 DEFERRED COMPENSATION MATCH 3,143.00 7.61 7.61 0.00 3,135.39 0.24 41510 PST DEFERRED COMPENSATION 343.41 12.41 41.88 0.00 301.53 12.19 41520 TIERED EMP DEF COMPENSATION 1,302.00 325.50 325.50 0.00 976.50 25.00 41530 TIERED RHS BENEFIT 1,022.00 255.50 255.50 0.00 766.50 25.00 41600 LONGEVITY 2,942.00 226.30 660.43 0.00 2,281.57 22.44 41700 ANNUAL LEAVE BUYBACK 11,631.33 0.00 0.00 0.00 11,631.33 0.00 41710 ANNUAL LEAVE OVER MAX 44.00 0.00 0.00 0.00 44.00 0.00 LUISN Page: 8 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
41910 PERS-NORMAL 86,947.56 3,574.47 10,635.03 0.00 76,312.53 12.23 41912 PERS-UNFUNDED 12,311.00 0.00 12,311.00 0.00 0.00 100.00 41920 MEDICARE 22,496.33 1,411.26 3,191.89 0.00 19,304.44 14.18 41929 SHORT TERM DISABILITY 2,283.24 183.91 569.11 0.00 1,714.13 24.92 41930 LONG TERM DISABILITY 4,851.88 305.00 943.86 0.00 3,908.02 19.45 41931 WORKERS COMP 14,925.92 594.45 1,788.81 0.00 13,137.11 11.98 41932 STATE UNEMPLOYMENT INSURANCE 691.56 43.65 99.41 0.00 592.15 14.37 41940 HEALTH INSURANCE 87,815.15 5,812.27 14,147.08 0.00 73,668.07 16.11 41945 OPT OUT HEALTH INSURANCE 7,872.00 494.00 1,329.71 0.00 6,542.29 16.89 41946 LIFE INSURANCE 5,922.10 372.29 1,152.04 0.00 4,770.06 19.45 41951 HEALTH ALLOWANCE CREDIT 0.00 15.70 38.13 0.00 (38.13) 0.00 41996 VACANCY FACTOR (155,179.00) 0.00 0.00 0.00 (155,179.00) 0.00 TOTAL FOR SALARIES-BENEFITS 857,341.28 61,688.96 156,895.39 0.00 700,445.89 18.30
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 90.00 0.00 0.00 0.00 90.00 0.00 42033 CONSTRUCTION MATERIALS 200.00 0.00 0.00 0.00 200.00 0.00 42034 SAFETY MATERIALS/CONSTRUCTION 365.00 0.00 0.00 0.00 365.00 0.00 42055 COMPUTER EQUIPMENT & 1,392.00 605.00 605.00 0.00 787.00 43.46 42101 SAFETY SHOES - MOU ITEM 1,236.50 0.00 0.00 0.00 1,236.50 0.00 42320 POSTAGE & SHIPPING 100.00 0.00 0.00 0.00 100.00 0.00 42340 OFFICE SUPPLIES 200.00 0.00 0.00 0.00 200.00 0.00 42600 MOTOR POOL RENTAL - OPS & MTCE 209.00 0.00 0.00 0.00 209.00 0.00 42660 MOTOR POOL RENTAL- 1,039.00 0.00 0.00 0.00 1,039.00 0.00 43200 CONFERENCE, TRAINING & TRAVEL 9,805.00 0.00 419.90 0.00 9,385.10 4.28 TOTAL FOR SERVICES-SUPPLIES 14,636.50 605.00 1,024.90 0.00 13,611.60 7.00 TOTAL FOR PUBLIC WORKS 871,977.78 62,293.96 157,920.29 0.00 714,057.49 18.11 50 WATER UTILITY SERVICES
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 5,178,717.33 362,870.83 1,027,546.81 0.00 4,151,170.52 19.84 41102 SHIFT DIFFERENTIAL 0.00 2,891.20 7,874.61 0.00 (7,874.61) 0.00 41103 OUT OF CLASS PAY 0.00 593.18 593.18 0.00 (593.18) 0.00 41140 FINAL LEAVE 0.00 3,776.28 28,707.41 0.00 (28,707.41) 0.00 41141 SP COMP-BILINGUAL 26,766.59 2,348.93 7,213.73 0.00 19,552.86 26.95 41147 SP COMP-GRADE 4 CERT PAY 33,120.00 2,580.02 7,555.77 0.00 25,564.23 22.81 41148 SP COMP-GRADE 5 CERT PAY 99,993.36 7,516.13 22,725.64 0.00 77,267.72 22.72 41200 TEMPORARY EMPLOYEES 63,341.36 4,241.74 10,481.16 0.00 52,860.20 16.54 41300 OVERTIME 623,687.00 41,775.33 149,398.40 0.00 474,288.60 23.95 41320 COMP TIME 0.00 2,960.77 8,468.75 0.00 (8,468.75) 0.00 41400 SPECIAL DUTY PAY 61,506.00 5,669.76 16,825.81 0.00 44,680.19 27.35 LUISN Page: 9 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
41410 AUTO ALLOWANCE 2,822.40 243.70 713.69 0.00 2,108.71 25.28 41500 DEFERRED COMPENSATION MATCH 19,941.00 659.72 659.72 0.00 19,281.28 3.30 41510 PST DEFERRED COMPENSATION 402.09 55.14 136.24 0.00 265.85 33.88 41520 TIERED EMP DEF COMPENSATION 11,388.00 2,887.91 2,887.91 0.00 8,500.09 25.35 41530 TIERED RHS BENEFIT 6,516.00 1,628.62 1,628.62 0.00 4,887.38 24.99 41600 LONGEVITY 27,359.92 2,079.86 5,985.80 0.00 21,374.12 21.87 41700 ANNUAL LEAVE BUYBACK 66,456.79 0.00 0.00 0.00 66,456.79 0.00 41710 ANNUAL LEAVE OVER MAX 13,462.00 0.00 0.00 0.00 13,462.00 0.00 41910 PERS-NORMAL 649,202.80 46,908.14 132,028.35 0.00 517,174.45 20.33 41912 PERS-UNFUNDED 89,642.00 0.00 89,642.00 0.00 0.00 100.00 41920 MEDICARE 185,402.70 12,986.84 37,949.58 0.00 147,453.12 20.46 41929 SHORT TERM DISABILITY 16,571.76 1,488.97 4,183.53 0.00 12,388.23 25.24 41930 LONG TERM DISABILITY 35,215.26 2,469.78 6,934.62 0.00 28,280.64 19.69 41931 WORKERS COMP 110,286.48 7,648.87 21,675.83 0.00 88,610.65 19.65 41932 STATE UNEMPLOYMENT INSURANCE 5,634.47 398.73 1,171.13 0.00 4,463.34 20.78 41940 HEALTH INSURANCE 1,097,251.27 70,169.09 173,751.22 0.00 923,500.05 15.83 41941 RETIREES HEALTH INSURANCE/OPEB 646,272.00 0.00 0.00 0.00 646,272.00 0.00 41945 OPT OUT HEALTH INSURANCE 76,704.00 8,080.10 18,185.60 0.00 58,518.40 23.70 41946 LIFE INSURANCE 42,983.44 3,014.65 8,464.30 0.00 34,519.14 19.69 41951 HEALTH ALLOWANCE CREDIT 0.00 744.80 1,765.84 0.00 (1,765.84) 0.00 41996 VACANCY FACTOR (657,410.00) 0.00 0.00 0.00 (657,410.00) 0.00 TOTAL FOR SALARIES-BENEFITS 8,533,236.02 598,689.09 1,795,155.25 0.00 6,738,080.77 21.03
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 133,982.00 10,924.62 29,317.26 69,000.00 35,664.74 73.38 42033 CONSTRUCTION MATERIALS 1,582,024.27 143,669.10 476,605.27 148,861.80 956,557.20 39.53 42034 SAFETY MATERIALS/CONSTRUCTION 77,920.00 3,289.83 9,714.42 0.00 68,205.58 12.46 42055 COMPUTER EQUIPMENT & 49,665.50 0.00 13,527.97 43,036.72 (6,899.19) 113.89 42100 UNIFORM EXPENSE 24,932.53 2,077.78 10,295.01 0.00 14,637.52 41.29 42101 SAFETY SHOES - MOU ITEM 25,871.25 2,639.23 4,916.52 0.00 20,954.73 19.00 42200 ADVERTISING EXPENSE 8,460.00 0.00 0.00 0.00 8,460.00 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 21,371.81 1,960.00 1,960.00 0.00 19,411.81 9.17 42300 WIRELESS COMMUNICATION 71,277.29 0.00 1,323.00 0.00 69,954.29 1.85 42310 PHONES, FAX, ISDN LINES 12,923.92 1,151.97 2,292.96 0.00 10,630.96 17.74 42320 POSTAGE & SHIPPING 172,252.98 7,235.32 23,643.60 0.00 148,609.38 13.72 42340 OFFICE SUPPLIES 13,964.13 229.90 1,669.58 0.00 12,294.55 11.95 42345 FIRST AID KIT SUPPLIES 214.20 0.00 81.79 0.00 132.41 38.18 42350 PROGRAM EXPENDITURES 60,261.90 10,234.54 14,268.97 0.00 45,992.93 23.67 42360 CLEANING/JANITORIAL SUPPLIES 0.00 123.90 497.86 0.00 (497.86) 0.00 42365 RECYCLED CONTENT PRODUCTS 1,226.55 0.00 0.00 0.00 1,226.55 0.00 42370 OTHER CONTRACTED SERVICES 0.00 96.46 96.46 0.00 (96.46) 0.00 LUISN Page: 10 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
42410 ELECTRIC UTILITY 6,210,453.00 320,588.72 1,370,977.72 0.00 4,839,475.28 22.07 42420 NATURAL GAS UTILITY 1,976.00 42.09 130.66 0.00 1,845.34 6.61 42430 WATER UTILITY 61,576.66 28,976.38 40,281.23 0.00 21,295.43 65.41 42435 RECYCLED WATER UTILITY 7,639.22 838.68 1,732.80 0.00 5,906.42 22.68 42441 UNLEADED FUEL 2,286.00 120.46 290.40 0.00 1,995.60 12.70 42442 DIESEL FUEL 5,048.00 197.53 716.33 0.00 4,331.67 14.19 42500 RENTS & LEASES 873,427.00 218,356.75 218,356.75 0.00 655,070.25 25.00 42501 CUA LEASES 2,168,773.60 542,193.25 542,193.25 0.00 1,626,580.35 25.00 42600 MOTOR POOL RENTAL - OPS & MTCE 282,143.00 0.00 0.00 0.00 282,143.00 0.00 42605 RETAINED VEHICLE EXPENSE 5,732.00 0.00 0.00 0.00 5,732.00 0.00 42610 DIRECT VEHICLE EXPENSE 8,750.00 0.00 1,207.41 0.00 7,542.59 13.79 42660 MOTOR POOL RENTAL- 264,752.16 0.00 0.00 0.00 264,752.16 0.00 42700 OTHER EQUIPMENT RENTAL 64,322.74 0.00 0.00 0.00 64,322.74 0.00 42710 MILEAGE/VEHICLE EXP REIMB 2,760.00 0.00 123.17 0.00 2,636.83 4.46 42813 MTCE & REPAIR - EQUIP & FAC 607,163.03 38,017.61 48,734.07 170,762.61 387,666.35 36.15 42815 SCADA MAINTENANCE 371,027.00 11,910.15 67,570.25 79,143.67 224,313.08 39.54 42816 MOWING/LANDSCAPE CONTRACTS 138,739.81 (1,495.00) 3,100.00 185,410.00 (49,770.19) 135.87 42830 REBATE PROGRAMS 35,000.00 229.99 7,335.23 0.00 27,664.77 20.95 42900 PROF. & CONT. SVCS 2,814,015.85 101,443.46 283,383.85 602,217.14 1,928,414.86 31.47 42902 CUST CREDIT CRD PROCESSING FEE 390,346.86 3,115.48 27,407.66 313,395.78 49,543.42 87.30 42910 REFUSE DISPOSAL 1,575.00 0.00 0.00 0.00 1,575.00 0.00 43000 INSURANCE & SURETY BONDS 69,071.20 0.00 48,621.72 0.00 20,449.48 70.39 43100 MEMBERSHIP & DUES 203,080.25 0.00 122,750.00 0.00 80,330.25 60.44 43200 CONFERENCE, TRAINING & TRAVEL 77,095.00 963.99 4,166.35 0.00 72,928.65 5.40 43400 LEGAL SERVICES-SPECIAL COUNSEL 22,500.00 0.00 0.00 0.00 22,500.00 0.00 43502 SCHOOL PROGRAMS 29,480.00 0.00 0.00 0.00 29,480.00 0.00 43699 CHEMICALS-CORRSN & SCALE INHIB 171,281.05 0.00 0.00 150,000.00 21,281.05 87.57 43701 CHEMICALS-POLYMER 196,350.09 36,764.08 59,185.81 136,814.19 350.09 99.82 43702 CHEMICALS-ALUM 115,433.31 21,202.57 63,266.53 115,423.61 (63,256.83) 154.79 43703 CHEMICALS-AMMONIA 76,446.91 5,472.45 15,197.02 63,802.98 (2,553.09) 103.33 43704 CHEMICALS-ANTISCALANT 223,929.68 16,597.97 49,793.91 112,206.09 61,929.68 72.34 43705 CHEMICALS-SULFURIC ACID 281,400.34 18,926.47 56,441.65 211,558.35 13,400.34 95.23 43706 CHEMICALS-CAUSTIC SODA 60,000.00 13,438.08 18,334.08 25,665.92 16,000.00 73.33 43707 CHEMICALS-SODIUM 467,250.12 55,201.39 178,199.47 538,691.01 (249,640.36) 153.42 43711 CHEMICALS-MISC 110,000.00 0.00 0.00 60,000.00 50,000.00 54.54 43714 OUTSIDE LAB ANALYSIS 556,346.45 30,926.00 61,343.00 55,469.98 439,533.47 20.99 43715 REGULATORY PERMIT & USE FEES 197,434.21 0.00 3,037.12 0.00 194,397.09 1.53 43716 JOB REQ CERTIFICATES & LICENSE 4,248.90 251.00 6,174.51 0.00 (1,925.61) 145.32 43717 RAW WATER PURCHASES 17,218,307.49 2,075,819.86 4,572,693.66 0.00 12,645,613.83 26.55 43718 TREATED WATER PURCHASES 3,747,572.49 780.03 786,397.67 0.00 2,961,174.82 20.98 LUISN Page: 11 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
43720 LAB CHEMICALS AND SUPPLIES 56,410.20 2,752.65 8,704.08 25,376.55 22,329.57 60.41 43722 PREVENTION & MAINTENANCE 1,625,774.91 46,017.33 47,276.80 322,353.64 1,256,144.47 22.73 43723 INLAND EMPIRE BRINE LINE-SARI 1,669,176.79 89,544.02 154,164.32 0.00 1,515,012.47 9.23 43731 CARBON DIOXIDE 60,000.00 2,105.98 6,317.94 0.00 53,682.06 10.52 44100 INTEREST EXPENSE 556,414.35 205,481.25 (33,710.28) 0.00 590,124.63 (6.05) 44200 BAD DEBTS EXPENSE 147,537.84 0.00 0.00 0.00 147,537.84 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 3,176,790.00 794,197.50 794,197.50 0.00 2,382,592.50 25.00 44613 INTERNAL SVC CHRG-WAREHOUSE 278,799.00 69,699.75 69,699.75 0.00 209,099.25 25.00 44614 INTERNAL SVC CHRG-INFO TECH 1,938,262.00 484,565.50 484,565.50 0.00 1,453,696.50 25.00 TOTAL FOR SERVICES-SUPPLIES 49,910,247.84 5,418,876.07 10,780,569.56 3,429,190.04 35,700,488.24 28.47
CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 50,000.00 0.00 0.00 0.00 50,000.00 0.00 TOTAL FOR CAPITAL OUTLAY 50,000.00 0.00 0.00 0.00 50,000.00 0.00 TOTAL FOR WATER UTILITY SERVICES 58,493,483.86 6,017,565.16 12,575,724.81 3,429,190.04 42,488,569.01 27.36 FUN 570 115,920,161.50 8,195,536.12 14,813,258.87 23,711,679.64 77,395,222.99 33.23 LUISN Page: 12 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
571 WATER UTILITY GRANT/AGREEMENT
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 86.97 318.87 0.00 (318.87) 0.00 41141 SP COMP-BILINGUAL 0.00 1.87 1.87 0.00 (1.87) 0.00 41910 PERS-NORMAL 0.00 10.71 38.65 0.00 (38.65) 0.00
41920 MEDICARE 0.00 2.61 9.45 0.00 (9.45) 0.00
41931 WORKERS COMP 0.00 1.78 6.41 0.00 (6.41) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.09 0.29 0.00 (0.29) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 104.03 375.54 0.00 (375.54) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 7,230,300.85 0.00 0.00 0.00 7,230,300.85 0.00 42900 PROF. & CONT. SVCS 199,434.79 6,241.64 5,251.64 187,985.77 6,197.38 96.89 43300 CONSTRUCTION CONTRACTS 345,199.11 0.00 0.00 345,199.11 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 7,774,934.75 6,241.64 5,251.64 533,184.88 7,236,498.23 6.92 TOTAL FOR NOT APPLICABLE 7,774,934.75 6,345.67 5,627.18 533,184.88 7,236,122.69 6.93 FUN 571 7,774,934.75 6,345.67 5,627.18 533,184.88 7,236,122.69 6.93 LUISN Page: 13 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
GRAND TOTAL 137,355,521.97 8,759,243.59 15,402,256.14 25,294,138.50 96,659,127.33 29.62 LUISN Page: 14 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:32:41
User:
Report: