GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
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
JULIEK Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
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 0.00 61,057.34 0.00 635,680.40 8.76 44610 ADMINISTRATIVE SERVICES CHARGE 27,156.00 6,789.00 13,578.00 0.00 13,578.00 50.00 TOTAL FOR SERVICES-SUPPLIES 723,893.74 6,789.00 74,635.34 0.00 649,258.40 10.31 TOTAL FOR WATER UTILITY SERVICES 723,893.74 6,789.00 74,635.34 0.00 649,258.40 10.31 FUN 507 3,056,471.19 6,789.00 75,248.29 0.00 2,981,222.90 2.46 JULIEK Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
Ledger:
Level:
Month to
567 RECLAIMED WATER SYSTEM
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 1,221.22 4,179.76 0.00 (4,179.76) 0.00 41910 PERS-NORMAL 0.00 147.16 503.67 0.00 (503.67) 0.00 41920 MEDICARE 0.00 36.14 123.70 0.00 (123.70) 0.00
41931 WORKERS COMP 0.00 24.42 83.60 0.00 (83.60) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 1.12 3.84 0.00 (3.84) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 1,430.06 4,894.57 0.00 (4,894.57) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 7,676,496.17 0.00 0.00 0.00 7,676,496.17 0.00 42033 CONSTRUCTION MATERIALS 0.00 6,067.44 11,766.97 32,062.98 (43,829.95) 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 0.00 7.66 7.66 0.00 (7.66) 0.00 42900 PROF. & CONT. SVCS 397,464.35 300,039.72 386,846.85 323,424.70 (312,807.20) 178.70 43300 CONSTRUCTION CONTRACTS 0.00 0.00 48,200.00 0.00 (48,200.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 8,073,960.52 306,114.82 446,821.48 355,487.68 7,271,651.36 9.93
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,107,875.11 307,544.88 451,933.55 389,402.27 7,266,539.29 10.37 13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 203.00 0.00 222.78 0.00 (19.78) 109.74 44101 DS INTEREST 2021 POBS 20,407.00 0.00 6,848.88 0.00 13,558.12 33.56 TOTAL FOR SERVICES-SUPPLIES 20,610.00 0.00 7,071.66 0.00 13,538.34 34.31 TOTAL FOR DEBT SERVICE 20,610.00 0.00 7,071.66 0.00 13,538.34 34.31 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 32,726.13 3,079.87 14,018.00 0.00 18,708.13 42.83 41140 FINAL LEAVE 0.00 0.00 1,729.54 0.00 (1,729.54) 0.00 41141 SP COMP-BILINGUAL 270.90 4.36 91.61 0.00 179.29 33.81 41910 PERS-NORMAL 1,594.94 371.65 1,700.26 0.00 (105.32) 106.60 41912 PERS-UNFUNDED 569.00 0.00 569.00 0.00 0.00 100.00 41920 MEDICARE 972.15 90.39 462.00 0.00 510.15 47.52
41929 SHORT TERM DISABILITY 104.73 25.36 117.91 0.00 (13.18) 112.58 41930 LONG TERM DISABILITY 222.53 42.07 195.63 0.00 26.90 87.91 JULIEK Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
Ledger:
Level:
Month to
41931 WORKERS COMP 659.94 61.11 276.99 0.00 382.95 41.97 41932 STATE UNEMPLOYMENT INSURANCE 29.71 2.79 14.28 0.00 15.43 48.06 41940 HEALTH INSURANCE 8,148.89 895.50 7,066.44 0.00 1,082.45 86.71 41945 OPT OUT HEALTH INSURANCE 0.00 0.00 46.29 0.00 (46.29) 0.00 41946 LIFE INSURANCE 271.63 51.35 238.79 0.00 32.84 87.91 41951 HEALTH ALLOWANCE CREDIT 0.00 27.45 172.96 0.00 (172.96) 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 4,651.90 26,699.70 0.00 15,832.85 62.77
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 4,651.90 26,699.70 0.00 15,915.60 62.65 53 RECLAIMED WATER
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 77,990.38 60,905.67 61,987.57 0.00 16,002.81 79.48 41102 SHIFT DIFFERENTIAL 0.00 351.82 351.82 0.00 (351.82) 0.00 41103 OUT OF CLASS PAY 0.00 67.16 67.16 0.00 (67.16) 0.00 41140 FINAL LEAVE 0.00 1,028.57 1,028.57 0.00 (1,028.57) 0.00 41141 SP COMP-BILINGUAL 450.35 448.54 470.42 0.00 (20.07) 104.45 41147 SP COMP-GRADE 4 CERT PAY 420.00 343.92 343.92 0.00 76.08 81.88 41148 SP COMP-GRADE 5 CERT PAY 1,266.15 1,231.46 1,231.46 0.00 34.69 97.26 41200 TEMPORARY EMPLOYEES 1,266.81 435.63 435.63 0.00 831.18 34.38 41300 OVERTIME 8,892.00 7,802.47 7,802.47 0.00 1,089.53 87.74 41320 COMP TIME 0.00 368.86 368.86 0.00 (368.86) 0.00
41400 SPECIAL DUTY PAY 958.00 1,135.45 1,135.45 0.00 (177.45) 118.52 41410 AUTO ALLOWANCE 57.60 57.60 57.60 0.00 0.00 100.00 41500 DEFERRED COMPENSATION MATCH 309.00 26.46 26.46 0.00 282.54 8.56 41510 PST DEFERRED COMPENSATION 8.04 5.67 5.67 0.00 2.37 70.52 41520 TIERED EMP DEF COMPENSATION 180.00 154.21 154.21 0.00 25.79 85.67 41530 TIERED RHS BENEFIT 100.00 87.42 87.42 0.00 12.58 87.42 41600 LONGEVITY 451.59 407.61 407.61 0.00 43.98 90.26
41660 TUITION REIMBURSEMENT 0.00 91.26 91.26 0.00 (91.26) 0.00 41700 ANNUAL LEAVE BUYBACK 1,025.22 2,046.27 2,046.27 0.00 (1,021.05) 199.59 41910 PERS-NORMAL 9,751.77 7,508.38 7,641.40 0.00 2,110.37 78.35 41912 PERS-UNFUNDED 1,365.00 0.00 1,365.00 0.00 0.00 100.00 41920 MEDICARE 2,781.63 2,208.48 2,241.01 0.00 540.62 80.56 41929 SHORT TERM DISABILITY 249.59 240.73 240.73 0.00 8.86 96.45 41930 LONG TERM DISABILITY 530.27 397.60 397.60 0.00 132.67 74.98 41931 WORKERS COMP 1,659.95 1,227.40 1,250.03 0.00 409.92 75.30 JULIEK Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
Ledger:
Level:
Month to
41932 STATE UNEMPLOYMENT INSURANCE 84.84 67.76 68.77 0.00 16.07 81.05 41940 HEALTH INSURANCE 16,322.10 9,401.69 9,474.25 0.00 6,847.85 58.04 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 1,161.73 1,161.73 0.00 158.27 88.00 41946 LIFE INSURANCE 647.26 485.23 485.23 0.00 162.03 74.96 41951 HEALTH ALLOWANCE CREDIT 0.00 77.17 77.17 0.00 (77.17) 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 99,772.22 102,502.75 0.00 20,320.80 83.45
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 0.00 56,181.87 0.00 52,265.53 51.80 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,490.80 0.00 55.52 97.81 42100 UNIFORM EXPENSE 6.32 10.15 87.71 0.00 (81.39) 1,387.81 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 42220 PROMOTIONAL/PUBLIC OUTREACH 0.00 0.00 529.60 0.00 (529.60) 0.00 42300 WIRELESS COMMUNICATION 770.40 46.57 139.70 0.00 630.70 18.13 42320 POSTAGE & SHIPPING 670.00 0.41 234.19 0.00 435.81 34.95 42340 OFFICE SUPPLIES 256.20 0.00 46.01 0.00 210.19 17.95 42350 PROGRAM EXPENDITURES 446.38 36.35 258.95 0.00 187.43 58.01 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 0.56 0.00 (0.56) 0.00 42365 RECYCLED CONTENT PRODUCTS 26.00 0.00 1.10 0.00 24.90 4.23 42410 ELECTRIC UTILITY 748,178.25 21,862.58 440,052.49 0.00 308,125.76 58.81 42500 RENTS & LEASES 17,679.00 4,419.75 8,839.50 0.00 8,839.50 50.00 42600 MOTOR POOL RENTAL - OPS & MTCE 4,594.00 2,297.00 2,297.00 0.00 2,297.00 50.00 42605 RETAINED VEHICLE EXPENSE 110.00 55.00 55.00 0.00 55.00 50.00 42660 MOTOR POOL RENTAL- 4,245.08 1,849.00 1,849.00 0.00 2,396.08 43.55 42710 MILEAGE/VEHICLE EXP REIMB 50.00 0.00 0.48 0.00 49.52 0.96 42813 MTCE & REPAIR - EQUIP & FAC 102,000.00 0.00 9,292.28 17,307.72 75,400.00 26.07 42815 SCADA MAINTENANCE 105,002.00 786.00 30,796.04 15,299.72 58,906.24 43.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 42,457.56 190,415.54 302,962.34 (17,394.48) 103.65 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 1.20 119.59 0.00 196.71 37.80 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 0.00 23,600.34 32,255.99 99,840.36 35.87 44100 INTEREST EXPENSE 288,059.53 0.00 44,214.85 0.00 243,844.68 15.34 JULIEK Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
Ledger:
Level:
Month to
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 64,825.50 0.00 64,825.50 50.00 44613 INTERNAL SVC CHRG-WAREHOUSE 3,911.00 977.75 1,955.50 0.00 1,955.50 50.00 44614 INTERNAL SVC CHRG-INFO TECH 45,785.00 11,446.25 22,892.50 0.00 22,892.50 50.00 TOTAL FOR SERVICES-SUPPLIES 2,227,348.57 118,658.32 907,257.44 372,325.77 947,765.36 57.44
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 218,430.54 1,009,760.19 372,325.77 1,068,086.16 56.40 FUN 567 10,621,272.53 530,627.32 1,495,465.10 761,728.04 8,364,079.39 21.25 JULIEK Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
Ledger:
Level:
Month to
570 WATER UTILITY
00 NOT APPLICABLE
SALARIES-BENEFITS
40001 CIP - PAYROLL EXPENSES 0.00 0.00 1,896.00 0.00 (1,896.00) 0.00 41100 PERMANENT EMPLOYEES 0.00 7,454.70 32,056.18 0.00 (32,056.18) 0.00 41141 SP COMP-BILINGUAL 0.00 35.53 229.29 0.00 (229.29) 0.00 41300 OVERTIME 0.00 0.00 133.60 0.00 (133.60) 0.00
41910 PERS-NORMAL 0.00 902.60 3,890.45 0.00 (3,890.45) 0.00 41920 MEDICARE 0.00 221.33 957.76 0.00 (957.76) 0.00
41931 WORKERS COMP 0.00 149.81 645.72 0.00 (645.72) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 6.83 29.59 0.00 (29.59) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 8,770.80 39,838.59 0.00 (39,838.59) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 39,160,059.76 0.00 0.00 0.00 39,160,059.76 0.00 40003 CIP-MATERIALS & SUPPLIES 14,373,040.00 0.00 1,964.31 0.00 14,371,075.69 0.01 42020 MINOR EQUIPMENT & FURNITURE 0.00 0.00 1,901.92 0.00 (1,901.92) 0.00 42033 CONSTRUCTION MATERIALS 39,771.62 1,281,231.42 1,576,110.70 44,789.84 (1,581,128.92) 4,075.52 42034 SAFETY MATERIALS/CONSTRUCTION 0.00 0.00 43.72 0.00 (43.72) 0.00 42055 COMPUTER EQUIPMENT & 0.00 0.00 5,547.08 0.00 (5,547.08) 0.00 42200 ADVERTISING EXPENSE 0.00 758.20 758.20 0.00 (758.20) 0.00 42300 WIRELESS COMMUNICATION 0.00 20.02 60.06 0.00 (60.06) 0.00 42320 POSTAGE & SHIPPING 0.00 0.00 21.45 0.00 (21.45) 0.00 42700 OTHER EQUIPMENT RENTAL 0.00 0.00 874.07 0.00 (874.07) 0.00 42813 MTCE & REPAIR - EQUIP & FAC 0.00 29,081.00 29,081.00 0.00 (29,081.00) 0.00 42815 SCADA MAINTENANCE 6,683.00 2,245.00 6,683.00 15,240.57 (15,240.57) 328.04 42900 PROF. & CONT. SVCS 1,605,691.99 80,951.20 520,547.76 1,740,791.55 (655,647.32) 140.83 43300 CONSTRUCTION CONTRACTS 2,145,071.68 297,822.62 2,559,433.52 2,557,932.58 (2,972,294.42) 238.56 43301 CAPITAL IMPROVEMENTS 20,000.00 0.00 5,154.80 0.00 14,845.20 25.77 43722 PREVENTION & MAINTENANCE 0.00 43,398.00 99,531.95 0.00 (99,531.95) 0.00 43727 INSPECTION 29,816.86 0.00 0.00 29,816.86 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 57,380,134.91 1,735,507.46 4,807,713.54 4,388,571.40 48,183,849.97 16.02
SERVICES-SUPPLIES
40002 CIP-CONTRACTUAL 429,265.50 0.00 731,961.63 0.00 (302,696.13) 170.51 TOTAL FOR SERVICES-SUPPLIES 429,265.50 0.00 731,961.63 0.00 (302,696.13) 170.51
CAPITAL OUTLAY
45100 LICENSED VEHICLES 231,743.52 0.00 20,010.00 231,743.52 (20,010.00) 108.63 45200 MACHINERY, EQUIPMENT, & FIXTUR 0.00 0.00 3,000.00 0.00 (3,000.00) 0.00 TOTAL FOR CAPITAL OUTLAY 231,743.52 0.00 23,010.00 231,743.52 (23,010.00) 109.92 TOTAL FOR NOT APPLICABLE 58,041,143.93 1,744,278.26 5,602,523.76 4,620,314.92 47,818,305.25 17.61 JULIEK Page: 7 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
Ledger:
Level:
Month to
13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 735.00 0.00 905.95 0.00 (170.95) 123.25 44101 DS INTEREST 2021 POBS 353,401.00 0.00 118,606.96 0.00 234,794.04 33.56 TOTAL FOR SERVICES-SUPPLIES 354,136.00 0.00 119,512.91 0.00 234,623.09 33.74 TOTAL FOR DEBT SERVICE 354,136.00 0.00 119,512.91 0.00 234,623.09 33.74 21 PLANNING & DEVELOPMENT
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 35,262.67 2,670.56 16,764.71 0.00 18,497.96 47.54 41141 SP COMP-BILINGUAL 704.00 54.16 348.17 0.00 355.83 49.45 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 48.42 0.00 91.58 34.58
41910 PERS-NORMAL 4,350.85 329.62 2,067.89 0.00 2,282.96 47.52 41912 PERS-UNFUNDED 1,024.00 0.00 1,024.00 0.00 0.00 100.00 41920 MEDICARE 1,188.14 80.07 498.11 0.00 690.03 41.92
41929 SHORT TERM DISABILITY 112.84 10.94 68.69 0.00 44.15 60.87 41930 LONG TERM DISABILITY 239.78 18.18 114.13 0.00 125.65 47.59 41931 WORKERS COMP 886.44 53.87 335.55 0.00 550.89 37.85 41932 STATE UNEMPLOYMENT INSURANCE 40.02 2.47 15.37 0.00 24.65 38.40 41940 HEALTH INSURANCE 4,660.45 193.80 2,104.33 0.00 2,556.12 45.15 41946 LIFE INSURANCE 292.67 22.14 139.05 0.00 153.62 47.51 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,446.57 23,528.42 0.00 31,289.65 42.92
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,446.57 23,528.42 0.00 31,324.65 42.89 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 616,556.15 17,485.83 131,991.81 0.00 484,564.34 21.40 41103 OUT OF CLASS PAY 0.00 832.32 3,329.28 0.00 (3,329.28) 0.00 41140 FINAL LEAVE 0.00 0.00 25,524.07 0.00 (25,524.07) 0.00 41141 SP COMP-BILINGUAL 4,898.75 160.82 1,376.45 0.00 3,522.30 28.09 41200 TEMPORARY EMPLOYEES 26,416.15 1,566.96 7,458.59 0.00 18,957.56 28.23 41300 OVERTIME 0.00 0.00 541.25 0.00 (541.25) 0.00
41400 SPECIAL DUTY PAY 0.00 161.70 1,012.82 0.00 (1,012.82) 0.00 41410 AUTO ALLOWANCE 1,152.00 88.62 569.70 0.00 582.30 49.45 41500 DEFERRED COMPENSATION MATCH 1,756.00 48.00 55.61 0.00 1,700.39 3.16 JULIEK Page: 8 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
Ledger:
Level:
Month to
41510 PST DEFERRED COMPENSATION 343.41 20.36 96.89 0.00 246.52 28.21 41520 TIERED EMP DEF COMPENSATION 864.00 216.00 432.00 0.00 432.00 50.00 41530 TIERED RHS BENEFIT 584.00 146.00 292.00 0.00 292.00 50.00 41600 LONGEVITY 1,482.00 114.00 722.53 0.00 759.47 48.75 41700 ANNUAL LEAVE BUYBACK 4,739.11 4,508.63 4,508.63 0.00 230.48 95.13 41710 ANNUAL LEAVE OVER MAX 44.00 0.00 0.00 0.00 44.00 0.00 41910 PERS-NORMAL 75,063.87 2,140.18 16,185.83 0.00 58,878.04 21.56 41912 PERS-UNFUNDED 12,311.00 0.00 12,311.00 0.00 0.00 100.00 41920 MEDICARE 19,305.21 733.69 5,146.84 0.00 14,158.37 26.66 41929 SHORT TERM DISABILITY 1,972.99 118.25 912.14 0.00 1,060.85 46.23 41930 LONG TERM DISABILITY 4,192.61 196.14 1,512.78 0.00 2,679.83 36.08 41931 WORKERS COMP 12,957.44 396.61 2,826.53 0.00 10,130.91 21.81 41932 STATE UNEMPLOYMENT INSURANCE 596.79 22.61 160.37 0.00 436.42 26.87 41940 HEALTH INSURANCE 71,483.81 1,495.29 22,439.76 0.00 49,044.05 31.39 41945 OPT OUT HEALTH INSURANCE 7,872.00 197.00 2,511.71 0.00 5,360.29 31.90 41946 LIFE INSURANCE 5,117.39 239.42 1,846.46 0.00 3,270.93 36.08 41951 HEALTH ALLOWANCE CREDIT 0.00 7.86 85.25 0.00 (85.25) 0.00 41996 VACANCY FACTOR (155,179.00) 0.00 0.00 0.00 (155,179.00) 0.00 TOTAL FOR SALARIES-BENEFITS 714,529.68 30,896.29 243,850.30 0.00 470,679.38 34.12
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 0.00 1,643.33 0.00 (251.33) 118.05 42101 SAFETY SHOES - MOU ITEM 1,108.75 0.00 0.00 0.00 1,108.75 0.00 42300 WIRELESS COMMUNICATION 0.00 211.80 564.32 0.00 (564.32) 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 104.50 104.50 0.00 104.50 50.00 42660 MOTOR POOL RENTAL- 1,039.00 519.50 519.50 0.00 519.50 50.00 43200 CONFERENCE, TRAINING & TRAVEL 9,805.00 0.00 1,614.90 0.00 8,190.10 16.47 TOTAL FOR SERVICES-SUPPLIES 14,508.75 835.80 4,446.55 0.00 10,062.20 30.64 TOTAL FOR PUBLIC WORKS 729,038.43 31,732.09 248,296.85 0.00 480,741.58 34.05 50 WATER UTILITY SERVICES
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 5,298,941.33 258,017.55 2,193,882.64 0.00 3,105,058.69 41.40 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 1,386.23 0.00 (1,386.23) 0.00 41102 SHIFT DIFFERENTIAL 0.00 2,262.06 17,230.30 0.00 (17,230.30) 0.00 41103 OUT OF CLASS PAY 0.00 (33.58) 1,745.96 0.00 (1,745.96) 0.00 JULIEK Page: 9 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
Ledger:
Level:
Month to
41140 FINAL LEAVE 0.00 (648.98) 29,118.90 0.00 (29,118.90) 0.00 41141 SP COMP-BILINGUAL 26,766.59 1,628.18 14,813.46 0.00 11,953.13 55.34 41147 SP COMP-GRADE 4 CERT PAY 33,120.00 1,655.80 14,074.41 0.00 19,045.59 42.49 41148 SP COMP-GRADE 5 CERT PAY 99,993.36 4,698.04 46,806.39 0.00 53,186.97 46.80 41200 TEMPORARY EMPLOYEES 63,341.36 643.14 21,549.67 0.00 41,791.69 34.02 41300 OVERTIME 623,687.00 38,355.64 306,938.54 0.00 316,748.46 49.21 41320 COMP TIME 0.00 313.87 13,878.32 0.00 (13,878.32) 0.00 41400 SPECIAL DUTY PAY 61,506.00 4,952.58 36,225.06 0.00 25,280.94 58.89 41410 AUTO ALLOWANCE 2,822.40 70.93 1,393.87 0.00 1,428.53 49.38 41500 DEFERRED COMPENSATION MATCH 19,941.00 309.32 969.04 0.00 18,971.96 4.85 41510 PST DEFERRED COMPENSATION 402.09 8.33 280.08 0.00 122.01 69.65 41520 TIERED EMP DEF COMPENSATION 11,388.00 2,522.06 5,409.97 0.00 5,978.03 47.50 41530 TIERED RHS BENEFIT 6,516.00 1,428.64 3,057.26 0.00 3,458.74 46.91 41600 LONGEVITY 27,359.92 1,487.35 12,804.33 0.00 14,555.59 46.79 41660 TUITION REIMBURSEMENT 0.00 (456.30) 1,521.00 0.00 (1,521.00) 0.00 41700 ANNUAL LEAVE BUYBACK 66,456.79 61,703.91 66,722.55 0.00 (265.76) 100.39 41710 ANNUAL LEAVE OVER MAX 13,462.00 0.00 0.00 0.00 13,462.00 0.00 41910 PERS-NORMAL 663,752.45 33,435.52 282,455.49 0.00 381,296.96 42.55 41912 PERS-UNFUNDED 89,642.00 0.00 89,642.00 0.00 0.00 100.00 41920 MEDICARE 188,963.29 11,269.02 82,443.27 0.00 106,520.02 43.62 41929 SHORT TERM DISABILITY 16,956.48 1,048.33 8,930.88 0.00 8,025.60 52.66 41930 LONG TERM DISABILITY 36,032.78 1,746.54 14,814.03 0.00 21,218.75 41.11 41931 WORKERS COMP 112,751.07 5,450.99 46,250.57 0.00 66,500.50 41.02 41932 STATE UNEMPLOYMENT INSURANCE 5,742.67 341.61 2,534.95 0.00 3,207.72 44.14 41940 HEALTH INSURANCE 1,130,176.07 13,499.37 358,592.53 0.00 771,583.54 31.72 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 2,256.12 41,059.42 0.00 35,644.58 53.52 41946 LIFE INSURANCE 43,981.30 2,132.23 18,082.25 0.00 25,899.05 41.11 41951 HEALTH ALLOWANCE CREDIT 0.00 176.43 3,787.87 0.00 (3,787.87) 0.00 41996 VACANCY FACTOR (657,410.00) 0.00 0.00 0.00 (657,410.00) 0.00 TOTAL FOR SALARIES-BENEFITS 8,709,267.95 450,274.70 3,738,401.24 0.00 4,970,866.71 42.92
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 133,982.00 4,040.59 54,292.80 69,000.00 10,689.20 92.02 42033 CONSTRUCTION MATERIALS 1,582,024.27 122,977.50 838,509.40 82,263.08 661,251.79 58.20 42034 SAFETY MATERIALS/CONSTRUCTION 77,920.00 6,844.73 25,423.73 11,132.43 41,363.84 46.91 42055 COMPUTER EQUIPMENT & 49,665.50 0.00 59,714.60 36.72 (10,085.82) 120.30 42100 UNIFORM EXPENSE 24,932.53 (1,785.70) 13,402.97 0.00 11,529.56 53.75 42101 SAFETY SHOES - MOU ITEM 26,671.25 1,430.76 9,784.95 0.00 16,886.30 36.68 42200 ADVERTISING EXPENSE 8,460.00 0.00 874.00 0.00 7,586.00 10.33 42220 PROMOTIONAL/PUBLIC OUTREACH 21,371.81 6,792.02 36,126.71 0.00 (14,754.90) 169.03 JULIEK Page: 10 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
Ledger:
Level:
Month to
42300 WIRELESS COMMUNICATION 71,277.29 4,523.35 13,138.54 0.00 58,138.75 18.43 42310 PHONES, FAX, ISDN LINES 12,923.92 4,017.23 11,318.74 0.00 1,605.18 87.57 42320 POSTAGE & SHIPPING 172,252.98 17,479.20 75,567.87 0.00 96,685.11 43.87 42340 OFFICE SUPPLIES 13,964.13 222.98 3,421.72 0.00 10,542.41 24.50 42345 FIRST AID KIT SUPPLIES 214.20 0.00 98.78 0.00 115.42 46.11 42350 PROGRAM EXPENDITURES 60,261.90 7,844.96 28,175.60 0.00 32,086.30 46.75 42360 CLEANING/JANITORIAL SUPPLIES 0.00 532.60 2,018.65 0.00 (2,018.65) 0.00 42365 RECYCLED CONTENT PRODUCTS 1,226.55 0.00 55.94 0.00 1,170.61 4.56 42370 OTHER CONTRACTED SERVICES 0.00 0.00 96.46 0.00 (96.46) 0.00 42410 ELECTRIC UTILITY 6,210,453.00 266,191.54 2,962,616.03 0.00 3,247,836.97 47.70 42420 NATURAL GAS UTILITY 1,976.00 0.00 130.66 0.00 1,845.34 6.61 42430 WATER UTILITY 61,576.66 7,460.11 61,287.49 0.00 289.17 99.53 42435 RECYCLED WATER UTILITY 7,639.22 1,004.14 4,107.18 0.00 3,532.04 53.76 42441 UNLEADED FUEL 2,286.00 0.00 533.33 0.00 1,752.67 23.33 42442 DIESEL FUEL 5,048.00 0.00 4,022.79 0.00 1,025.21 79.69 42500 RENTS & LEASES 873,427.00 218,356.75 436,713.50 0.00 436,713.50 50.00 42501 CUA LEASES 2,168,773.60 542,193.25 1,084,386.50 0.00 1,084,387.10 50.00 42600 MOTOR POOL RENTAL - OPS & MTCE 282,143.00 141,071.50 141,071.50 0.00 141,071.50 50.00 42605 RETAINED VEHICLE EXPENSE 5,732.00 2,866.00 2,866.00 0.00 2,866.00 50.00 42610 DIRECT VEHICLE EXPENSE 8,750.00 1,200.00 3,261.39 0.00 5,488.61 37.27 42660 MOTOR POOL RENTAL- 264,752.16 113,823.50 113,823.50 0.00 150,928.66 42.99 42700 OTHER EQUIPMENT RENTAL 64,322.74 3,228.07 3,905.67 5,000.00 55,417.07 13.84 42710 MILEAGE/VEHICLE EXP REIMB 2,760.00 0.00 232.15 0.00 2,527.85 8.41 42813 MTCE & REPAIR - EQUIP & FAC 607,163.03 43,488.50 194,487.59 306,948.62 105,726.82 82.58 42815 SCADA MAINTENANCE 371,027.00 8,087.00 124,847.49 96,867.24 149,312.27 59.75 42816 MOWING/LANDSCAPE CONTRACTS 138,739.81 2,460.00 2,460.00 97,010.00 39,269.81 71.69 42830 REBATE PROGRAMS 35,000.00 651.97 8,541.01 0.00 26,458.99 24.40 42900 PROF. & CONT. SVCS 2,814,015.85 242,338.34 910,143.00 448,527.72 1,455,345.13 48.28 42902 CUST CREDIT CRD PROCESSING FEE 390,346.86 18,419.35 100,273.87 240,529.57 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 167,998.00 0.00 35,082.25 82.72 43200 CONFERENCE, TRAINING & TRAVEL 77,095.00 7,882.52 25,955.64 0.00 51,139.36 33.66 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 10,000.00 19,480.00 33.92 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 18,073.14 108,266.29 87,733.71 350.09 99.82 43702 CHEMICALS-ALUM 115,433.31 0.00 75,113.59 103,576.55 (63,256.83) 154.79 43703 CHEMICALS-AMMONIA 76,446.91 5,472.44 35,510.49 43,489.51 (2,553.09) 103.33 43704 CHEMICALS-ANTISCALANT 223,929.68 16,597.97 82,989.85 79,010.15 61,929.68 72.34 JULIEK Page: 11 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
Ledger:
Level:
Month to
43705 CHEMICALS-SULFURIC ACID 281,400.34 28,240.24 122,647.42 145,352.58 13,400.34 95.23 43706 CHEMICALS-CAUSTIC SODA 60,000.00 13,623.69 45,159.74 54,840.26 (40,000.00) 166.66 43707 CHEMICALS-SODIUM 467,250.12 40,868.07 297,609.34 420,007.05 (250,366.27) 153.58 43711 CHEMICALS-MISC 110,000.00 0.00 15,352.00 44,648.00 50,000.00 54.54 43714 OUTSIDE LAB ANALYSIS 556,346.45 20,056.00 170,265.00 73,589.98 312,491.47 43.83 43715 REGULATORY PERMIT & USE FEES 197,434.21 1,283.00 18,142.16 0.00 179,292.05 9.18 43716 JOB REQ CERTIFICATES & LICENSE 4,248.90 425.00 8,389.49 0.00 (4,140.59) 197.45 43717 RAW WATER PURCHASES 17,218,307.49 592,580.09 8,825,866.65 0.00 8,392,440.84 51.25 43718 TREATED WATER PURCHASES 3,747,572.49 2,080.09 898,885.03 0.00 2,848,687.46 23.98 43720 LAB CHEMICALS AND SUPPLIES 56,410.20 2,811.79 18,250.48 24,839.37 13,320.35 76.38 43722 PREVENTION & MAINTENANCE 1,625,774.91 26,680.31 293,733.85 269,948.62 1,062,092.44 34.67 43723 INLAND EMPIRE BRINE LINE-SARI 1,669,176.79 72,259.82 490,633.04 0.00 1,178,543.75 29.39 43731 CARBON DIOXIDE 60,000.00 0.00 12,635.88 0.00 47,364.12 21.05 44100 INTEREST EXPENSE 556,414.35 176,822.18 143,111.90 0.00 413,302.45 25.72 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 1,588,395.00 0.00 1,588,395.00 50.00 44613 INTERNAL SVC CHRG-WAREHOUSE 278,799.00 69,699.75 139,399.50 0.00 139,399.50 50.00 44614 INTERNAL SVC CHRG-INFO TECH 1,938,262.00 484,565.50 969,131.00 0.00 969,131.00 50.00 TOTAL FOR SERVICES-SUPPLIES 49,911,047.84 4,161,979.34 21,933,795.17 2,864,351.16 25,112,901.51 49.68
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,670,315.79 4,612,254.04 25,672,196.41 2,864,351.16 30,133,768.22 48.63 FUN 570 117,849,487.22 6,391,710.96 31,666,058.35 7,484,666.08 78,698,762.79 33.22 JULIEK Page: 12 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
Ledger:
Level:
Month to
571 WATER UTILITY GRANT/AGREEMENT
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 407.09 1,432.38 0.00 (1,432.38) 0.00 41141 SP COMP-BILINGUAL 0.00 0.00 1.87 0.00 (1.87) 0.00 41910 PERS-NORMAL 0.00 49.04 172.79 0.00 (172.79) 0.00
41920 MEDICARE 0.00 12.01 42.40 0.00 (42.40) 0.00
41931 WORKERS COMP 0.00 8.14 28.68 0.00 (28.68) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.35 1.28 0.00 (1.28) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 476.63 1,679.40 0.00 (1,679.40) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 7,230,300.85 0.00 0.00 0.00 7,230,300.85 0.00 42830 REBATE PROGRAMS 0.00 0.00 (121,339.15) 0.00 121,339.15 0.00 42900 PROF. & CONT. SVCS 199,434.79 9,096.86 47,371.77 168,178.68 (16,115.66) 108.08 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 9,096.86 (73,967.38) 513,377.79 7,335,524.34 5.65 TOTAL FOR NOT APPLICABLE 7,774,934.75 9,573.49 (72,287.98) 513,377.79 7,333,844.94 5.67 FUN 571 7,774,934.75 9,573.49 (72,287.98) 513,377.79 7,333,844.94 5.67 JULIEK Page: 13 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report:
GL
12/31/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 06
Ledger:
Level:
Month to
GRAND TOTAL 139,302,165.69 6,938,700.77 33,164,483.76 8,759,771.91 97,377,910.02 30.09 JULIEK Page: 14 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2025
Current Time: 08:51:20
User:
Report: