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
440 SEWER CAPACITY GEN SRVC
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 1,646.07 1,906.71 0.00 (1,906.71) 0.00 41141 SP COMP-BILINGUAL 0.00 10.45 16.99 0.00 (16.99) 0.00 41910 PERS-NORMAL 0.00 199.64 231.82 0.00 (231.82) 0.00 41920 MEDICARE 0.00 48.96 56.86 0.00 (56.86) 0.00
41931 WORKERS COMP 0.00 33.12 38.46 0.00 (38.46) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 1.50 1.74 0.00 (1.74) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 1,939.74 2,252.58 0.00 (2,252.58) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 5,430,908.06 0.00 0.00 0.00 5,430,908.06 0.00 43300 CONSTRUCTION CONTRACTS 52,548.82 0.00 0.00 52,548.82 0.00 100.00 43727 INSPECTION 23,880.00 1,800.00 1,800.00 22,080.00 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 5,507,336.88 1,800.00 1,800.00 74,628.82 5,430,908.06 1.38 TOTAL FOR NOT APPLICABLE 5,507,336.88 3,739.74 4,052.58 74,628.82 5,428,655.48 1.42 51 SEWER
SERVICES-SUPPLIES
44100 INTEREST EXPENSE 109,393.00 58,140.00 19,592.38 0.00 89,800.62 17.91 44610 ADMINISTRATIVE SERVICES CHARGE 121,344.00 30,336.00 30,336.00 0.00 91,008.00 25.00 TOTAL FOR SERVICES-SUPPLIES 230,737.00 88,476.00 49,928.38 0.00 180,808.62 21.63 TOTAL FOR SEWER 230,737.00 88,476.00 49,928.38 0.00 180,808.62 21.63 FUN 440 5,738,073.88 92,215.74 53,980.96 74,628.82 5,609,464.10 2.24 LUISN Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:31:13
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
572 SEWER UTILITY FUND
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 8,546.80 28,910.93 0.00 (28,910.93) 0.00 41141 SP COMP-BILINGUAL 0.00 25.13 86.40 0.00 (86.40) 0.00 41300 OVERTIME 0.00 0.00 318.24 0.00 (318.24) 0.00
41910 PERS-NORMAL 0.00 1,032.92 3,494.17 0.00 (3,494.17) 0.00 41920 MEDICARE 0.00 253.27 866.36 0.00 (866.36) 0.00
41931 WORKERS COMP 0.00 171.44 579.95 0.00 (579.95) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 7.84 26.81 0.00 (26.81) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 10,037.40 34,282.86 0.00 (34,282.86) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 40,034,532.57 0.00 0.00 0.00 40,034,532.57 0.00 42033 CONSTRUCTION MATERIALS 52,070.41 0.00 0.00 52,070.41 0.00 100.00 42300 WIRELESS COMMUNICATION 0.00 0.00 117.60 0.00 (117.60) 0.00 42320 POSTAGE & SHIPPING 0.00 9.92 9.92 0.00 (9.92) 0.00 42700 OTHER EQUIPMENT RENTAL 2,587.84 1,468.14 1,468.14 1,119.70 0.00 100.00 42813 MTCE & REPAIR - EQUIP & FAC 0.00 6,892.60 6,892.60 0.00 (6,892.60) 0.00 42815 SCADA MAINTENANCE 141,224.04 7,623.00 7,623.00 133,601.04 0.00 100.00 42900 PROF. & CONT. SVCS 2,910,775.59 216,895.53 308,296.76 2,474,880.07 127,598.76 95.61 43300 CONSTRUCTION CONTRACTS 8,541,496.96 507,110.50 904,193.87 5,629,690.09 2,007,613.00 76.49 43301 CAPITAL IMPROVEMENTS 0.00 0.00 0.00 2,089,000.00 (2,089,000.00) 0.00 43400 LEGAL SERVICES-SPECIAL COUNSEL 34,431.96 12,644.23 12,644.23 21,787.73 0.00 100.00 43726 PROJECT MANAGEMENT 11,669.25 0.00 0.00 11,669.25 0.00 100.00 43727 INSPECTION 72,598.40 0.00 0.00 72,598.40 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 51,801,387.02 752,643.92 1,241,246.12 10,486,416.69 40,073,724.21 22.63
CAPITAL OUTLAY
45100 LICENSED VEHICLES 231,743.52 361,465.35 361,465.35 231,743.52 (361,465.35) 255.97 45200 MACHINERY, EQUIPMENT, & FIXTUR 159,934.10 76,006.83 89,739.33 83,927.58 (13,732.81) 108.58 TOTAL FOR CAPITAL OUTLAY 391,677.62 437,472.18 451,204.68 315,671.10 (375,198.16) 195.79 TOTAL FOR NOT APPLICABLE 52,193,064.64 1,200,153.50 1,726,733.66 10,802,087.79 39,664,243.19 24.00 11 CITY MANAGER'S OFFICE
SALARIES-BENEFITS
41200 TEMPORARY EMPLOYEES 3,638.35 314.90 885.49 0.00 2,752.86 24.33 41510 PST DEFERRED COMPENSATION 24.23 2.32 6.52 0.00 17.71 26.90 41910 PERS-NORMAL 213.85 16.46 46.31 0.00 167.54 21.65
41920 MEDICARE 52.75 4.60 12.95 0.00 39.80 24.54
41931 WORKERS COMP 72.76 6.30 17.72 0.00 55.04 24.35
41932 STATE UNEMPLOYMENT INSURANCE 3.28 0.29 0.80 0.00 2.48 24.39 41997 BUDGETARY/PAYROLL (190.78) 0.00 0.00 0.00 (190.78) 0.00 LUISN Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:31:13
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 SALARIES-BENEFITS 3,814.44 344.87 969.79 0.00 2,844.65 25.42 TOTAL FOR CITY MANAGER'S OFFICE 3,814.44 344.87 969.79 0.00 2,844.65 25.42 13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 63.00 0.00 0.00 0.00 63.00 0.00 44101 DS INTEREST 2021 POBS 209,851.00 0.00 (34,496.04) 0.00 244,347.04 (16.43) TOTAL FOR SERVICES-SUPPLIES 209,914.00 0.00 (34,496.04) 0.00 244,410.04 (16.43) TOTAL FOR DEBT SERVICE 209,914.00 0.00 (34,496.04) 0.00 244,410.04 (16.43) 21 PLANNING & DEVELOPMENT
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 24,212.07 1,866.06 5,445.29 0.00 18,766.78 22.48 41141 SP COMP-BILINGUAL 352.00 27.08 79.31 0.00 272.69 22.53 41500 DEFERRED COMPENSATION MATCH 75.00 0.00 0.00 0.00 75.00 0.00 41520 TIERED EMP DEF COMPENSATION 90.00 22.50 22.50 0.00 67.50 25.00 41530 TIERED RHS BENEFIT 30.00 7.50 7.50 0.00 22.50 25.00 41600 LONGEVITY 175.00 13.46 29.04 0.00 145.96 16.59
41910 PERS-NORMAL 2,981.06 229.77 669.32 0.00 2,311.74 22.45 41912 PERS-UNFUNDED 624.00 0.00 624.00 0.00 0.00 100.00 41920 MEDICARE 736.40 54.76 159.35 0.00 577.05 21.63
41929 SHORT TERM DISABILITY 77.48 7.66 22.36 0.00 55.12 28.85 41930 LONG TERM DISABILITY 164.65 12.68 37.00 0.00 127.65 22.47 41931 WORKERS COMP 491.28 36.26 106.60 0.00 384.68 21.69 41932 STATE UNEMPLOYMENT INSURANCE 22.28 1.66 4.89 0.00 17.39 21.94 41940 HEALTH INSURANCE 5,568.18 463.14 1,124.94 0.00 4,443.24 20.20 41946 LIFE INSURANCE 200.96 15.50 45.23 0.00 155.73 22.50 41996 VACANCY FACTOR (902.00) 0.00 0.00 0.00 (902.00) 0.00 TOTAL FOR SALARIES-BENEFITS 34,898.36 2,758.03 8,377.33 0.00 26,521.03 24.00
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 17.50 0.00 0.00 0.00 17.50 0.00 TOTAL FOR SERVICES-SUPPLIES 17.50 0.00 0.00 0.00 17.50 0.00 TOTAL FOR PLANNING & DEVELOPMENT DEPT34,915.86 2,758.03 8,377.33 0.00 26,538.53 23.99 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 504,462.48 22,063.66 57,818.30 0.00 446,644.18 11.46 41140 FINAL LEAVE 0.00 15,317.03 15,317.03 0.00 (15,317.03) 0.00 41141 SP COMP-BILINGUAL 919.39 71.24 208.61 0.00 710.78 22.69 41200 TEMPORARY EMPLOYEES 17,581.46 623.72 2,040.98 0.00 15,540.48 11.60 41300 OVERTIME 0.00 213.72 213.72 0.00 (213.72) 0.00
LUISN Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:31:13
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
41400 SPECIAL DUTY PAY 0.00 327.14 947.54 0.00 (947.54) 0.00 41410 AUTO ALLOWANCE 576.00 44.30 129.74 0.00 446.26 22.52 41500 DEFERRED COMPENSATION MATCH 2,152.00 7.61 7.61 0.00 2,144.39 0.35 41510 PST DEFERRED COMPENSATION 228.56 8.12 26.54 0.00 202.02 11.61 41520 TIERED EMP DEF COMPENSATION 768.00 192.00 192.00 0.00 576.00 25.00 41530 TIERED RHS BENEFIT 688.00 172.00 172.00 0.00 516.00 25.00 41600 LONGEVITY 2,117.00 162.83 474.55 0.00 1,642.45 22.41 41700 ANNUAL LEAVE BUYBACK 8,748.89 0.00 0.00 0.00 8,748.89 0.00 41710 ANNUAL LEAVE OVER MAX 44.00 0.00 0.00 0.00 44.00 0.00 41910 PERS-NORMAL 58,796.80 2,714.47 7,080.65 0.00 51,716.15 12.04 41912 PERS-UNFUNDED 9,046.00 0.00 9,046.00 0.00 0.00 100.00 41920 MEDICARE 15,725.47 1,139.20 2,248.00 0.00 13,477.47 14.29 41929 SHORT TERM DISABILITY 1,614.27 136.77 352.88 0.00 1,261.39 21.86 41930 LONG TERM DISABILITY 3,430.37 226.83 585.24 0.00 2,845.13 17.06 41931 WORKERS COMP 10,488.06 453.86 1,200.07 0.00 9,287.99 11.44 41932 STATE UNEMPLOYMENT INSURANCE 482.97 35.26 69.96 0.00 413.01 14.48 41940 HEALTH INSURANCE 81,400.58 3,695.01 8,539.33 0.00 72,861.25 10.49 41945 OPT OUT HEALTH INSURANCE 2,208.00 292.00 807.71 0.00 1,400.29 36.58 41946 LIFE INSURANCE 4,187.01 276.84 714.29 0.00 3,472.72 17.05 41951 HEALTH ALLOWANCE CREDIT 0.00 21.30 39.93 0.00 (39.93) 0.00 41996 VACANCY FACTOR (137,663.00) 0.00 0.00 0.00 (137,663.00) 0.00 TOTAL FOR SALARIES-BENEFITS 588,002.31 48,194.91 108,232.68 0.00 479,769.63 18.40
SERVICES-SUPPLIES
42055 COMPUTER EQUIPMENT & 1,392.00 0.00 0.00 0.00 1,392.00 0.00 42101 SAFETY SHOES - MOU ITEM 897.00 0.00 0.00 0.00 897.00 0.00 42105 PROTECTIVE CLOTHING 65.00 0.00 0.00 0.00 65.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,055.00 0.00 0.00 0.00 9,055.00 0.00 TOTAL FOR SERVICES-SUPPLIES 12,657.00 0.00 0.00 0.00 12,657.00 0.00 TOTAL FOR PUBLIC WORKS 600,659.31 48,194.91 108,232.68 0.00 492,426.63 18.01 51 SEWER
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 3,897,702.53 250,882.76 739,332.48 0.00 3,158,370.05 18.96 41102 SHIFT DIFFERENTIAL 0.00 2,762.08 7,682.90 0.00 (7,682.90) 0.00 41103 OUT OF CLASS PAY 0.00 526.02 526.02 0.00 (526.02) 0.00 41140 FINAL LEAVE 0.00 605.21 29,640.43 0.00 (29,640.43) 0.00 41141 SP COMP-BILINGUAL 26,376.24 2,456.56 7,608.26 0.00 18,767.98 28.84 41147 SP COMP-GRADE 4 CERT PAY 8,460.00 650.76 1,905.80 0.00 6,554.20 22.52 LUISN Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:31:13
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
41148 SP COMP-GRADE 5 CERT PAY 85,165.29 5,878.09 17,757.76 0.00 67,407.53 20.85 41200 TEMPORARY EMPLOYEES 57,007.18 3,470.47 8,575.21 0.00 48,431.97 15.04 41300 OVERTIME 685,847.00 45,199.87 136,650.10 0.00 549,196.90 19.92 41320 COMP TIME 0.00 422.38 3,227.22 0.00 (3,227.22) 0.00 41400 SPECIAL DUTY PAY 50,742.00 4,104.66 12,505.86 0.00 38,236.14 24.64 41410 AUTO ALLOWANCE 2,592.00 199.38 583.90 0.00 2,008.10 22.52 41500 DEFERRED COMPENSATION MATCH 15,558.00 640.28 640.28 0.00 14,917.72 4.11 41510 PST DEFERRED COMPENSATION 361.86 45.10 111.48 0.00 250.38 30.80 41520 TIERED EMP DEF COMPENSATION 10,134.00 2,461.09 2,461.09 0.00 7,672.91 24.28 41530 TIERED RHS BENEFIT 5,166.00 1,320.38 1,320.38 0.00 3,845.62 25.55 41600 LONGEVITY 26,032.55 1,613.37 4,838.27 0.00 21,194.28 18.58 41700 ANNUAL LEAVE BUYBACK 79,635.78 0.00 0.00 0.00 79,635.78 0.00 41710 ANNUAL LEAVE OVER MAX 10,174.00 0.00 0.00 0.00 10,174.00 0.00 41910 PERS-NORMAL 489,215.58 32,392.48 95,071.36 0.00 394,144.22 19.43 41912 PERS-UNFUNDED 68,449.00 0.00 68,449.00 0.00 0.00 100.00 41920 MEDICARE 147,607.59 9,378.26 28,417.79 0.00 119,189.80 19.25 41929 SHORT TERM DISABILITY 12,472.67 1,024.93 3,029.47 0.00 9,443.20 24.28 41930 LONG TERM DISABILITY 26,504.35 1,699.29 5,027.83 0.00 21,476.52 18.96 41931 WORKERS COMP 83,187.05 5,269.34 15,561.71 0.00 67,625.34 18.70 41932 STATE UNEMPLOYMENT INSURANCE 4,493.94 288.04 877.51 0.00 3,616.43 19.52 41940 HEALTH INSURANCE 729,924.75 47,054.69 118,070.87 0.00 611,853.88 16.17 41941 RETIREES HEALTH INSURANCE/OPEB 491,572.00 0.00 0.00 0.00 491,572.00 0.00 41945 OPT OUT HEALTH INSURANCE 73,656.00 4,519.90 12,085.80 0.00 61,570.20 16.40 41946 LIFE INSURANCE 32,350.88 2,074.09 6,136.86 0.00 26,214.02 18.96 41951 HEALTH ALLOWANCE CREDIT 0.00 336.86 818.07 0.00 (818.07) 0.00 41996 VACANCY FACTOR (245,194.00) 0.00 0.00 0.00 (245,194.00) 0.00 TOTAL FOR SALARIES-BENEFITS 6,875,194.24 427,276.34 1,328,913.71 0.00 5,546,280.53 19.32
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 130,550.00 14,734.38 28,274.26 4,500.00 97,775.74 25.10 42033 CONSTRUCTION MATERIALS 1,217,490.00 96,829.97 252,467.59 76,234.53 888,787.88 26.99 42034 SAFETY MATERIALS/CONSTRUCTION 31,475.00 6,460.76 8,142.83 0.00 23,332.17 25.87 42055 COMPUTER EQUIPMENT & 48,337.11 0.00 34,387.07 33.12 13,916.92 71.20 42100 UNIFORM EXPENSE 14,485.65 1,266.10 7,937.04 0.00 6,548.61 54.79 42101 SAFETY SHOES - MOU ITEM 17,114.00 1,538.96 2,997.90 0.00 14,116.10 17.51 42200 ADVERTISING EXPENSE 5,182.50 0.00 0.00 0.00 5,182.50 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 14,752.26 0.00 0.00 0.00 14,752.26 0.00 42300 WIRELESS COMMUNICATION 23,578.97 0.00 0.00 0.00 23,578.97 0.00 42310 PHONES, FAX, ISDN LINES 35,389.50 3,539.01 7,262.32 0.00 28,127.18 20.52 42320 POSTAGE & SHIPPING 149,344.08 6,771.23 23,238.82 0.00 126,105.26 15.56 42340 OFFICE SUPPLIES 11,435.98 126.79 1,421.18 0.00 10,014.80 12.42 LUISN Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:31:13
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
42345 FIRST AID KIT SUPPLIES 340.00 0.00 4.01 0.00 335.99 1.17 42350 PROGRAM EXPENDITURES 33,370.01 3,540.18 8,299.58 0.00 25,070.43 24.87 42360 CLEANING/JANITORIAL SUPPLIES 0.00 69.70 537.15 0.00 (537.15) 0.00 42365 RECYCLED CONTENT PRODUCTS 999.40 0.00 0.00 0.00 999.40 0.00 42410 ELECTRIC UTILITY 1,734,412.16 124,353.72 388,444.52 0.00 1,345,967.64 22.39 42420 NATURAL GAS UTILITY 57,600.00 3,601.25 10,844.97 0.00 46,755.03 18.82 42430 WATER UTILITY 147,000.00 4,550.21 11,181.67 0.00 135,818.33 7.60 42435 RECYCLED WATER UTILITY 788,341.00 96,427.64 225,057.37 0.00 563,283.63 28.54 42441 UNLEADED FUEL 900.00 21.26 51.25 0.00 848.75 5.69 42442 DIESEL FUEL 30,600.00 27.20 118.75 0.00 30,481.25 0.38 42443 OTHER FUELS 60.00 0.00 0.00 0.00 60.00 0.00
42500 RENTS & LEASES 795,563.00 198,890.75 198,890.75 0.00 596,672.25 25.00 42501 CUA LEASES 1,464,595.40 366,148.75 366,148.75 0.00 1,098,446.65 25.00 42600 MOTOR POOL RENTAL - OPS & MTCE 186,814.00 0.00 0.00 0.00 186,814.00 0.00 42605 RETAINED VEHICLE EXPENSE 5,181.00 0.00 0.00 0.00 5,181.00 0.00 42610 DIRECT VEHICLE EXPENSE 13,350.00 738.85 3,692.12 6,307.88 3,350.00 74.90 42660 MOTOR POOL RENTAL- 209,678.76 0.00 0.00 0.00 209,678.76 0.00 42700 OTHER EQUIPMENT RENTAL 125,086.16 0.00 3,067.02 1,648.00 120,371.14 3.76 42710 MILEAGE/VEHICLE EXP REIMB 1,025.00 0.00 52.00 0.00 973.00 5.07 42813 MTCE & REPAIR - EQUIP & FAC 749,380.77 20,732.82 33,764.14 348,984.62 366,632.01 51.07 42815 SCADA MAINTENANCE 326,539.60 10,699.96 64,227.17 87,242.04 175,070.39 46.38 42816 MOWING/LANDSCAPE CONTRACTS 155,940.94 11,750.00 (2,250.00) 21,750.00 136,440.94 12.50 42900 PROF. & CONT. SVCS 1,175,255.95 51,806.30 92,355.07 503,149.21 579,751.67 50.67 42902 CUST CREDIT CRD PROCESSING FEE 352,077.56 2,810.04 24,720.65 282,670.69 44,686.22 87.30 42910 REFUSE DISPOSAL 90,588.24 0.00 0.00 0.00 90,588.24 0.00 43000 INSURANCE & SURETY BONDS 69,071.20 0.00 48,621.72 0.00 20,449.48 70.39 43100 MEMBERSHIP & DUES 39,249.30 0.00 0.00 0.00 39,249.30 0.00 43200 CONFERENCE, TRAINING & TRAVEL 58,733.50 1,235.17 8,867.40 0.00 49,866.10 15.09 43400 LEGAL SERVICES-SPECIAL COUNSEL 22,500.00 0.00 0.00 0.00 22,500.00 0.00 43698 CHEMICALS-SODIUM BISOLFITE 120,560.00 0.00 9,464.25 110,985.75 110.00 99.90 43700 CHEMICALS-MINERAL OIL 10,000.00 0.00 0.00 0.00 10,000.00 0.00 43701 CHEMICALS-POLYMER 1,643,967.60 196,660.46 212,043.15 1,129,956.85 301,967.60 81.63 43707 CHEMICALS-SODIUM 2,238,500.00 118,268.30 452,229.59 1,786,270.41 0.00 100.00 43709 CHEMICALS-FERRIC CHLORIDE 135,520.00 0.00 12,429.70 99,570.30 23,520.00 82.64 43713 BIOSOLIDS DISPOSAL/RECYCLE 1,600,000.00 19,642.35 146,860.06 1,724,720.54 (271,580.60) 116.97 43714 OUTSIDE LAB ANALYSIS 563,513.25 40,190.00 84,700.50 62,322.80 416,489.95 26.09 43715 REGULATORY PERMIT & USE FEES 234,371.00 1,470.00 21,939.56 0.00 212,431.44 9.36 43716 JOB REQ CERTIFICATES & LICENSE 3,450.00 0.00 0.00 0.00 3,450.00 0.00 43720 LAB CHEMICALS AND SUPPLIES 37,632.00 1,506.64 6,783.86 7,526.00 23,322.14 38.02 43722 PREVENTION & MAINTENANCE 1,177,731.73 77,244.88 148,555.63 348,554.44 680,621.66 42.20 LUISN Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:31:13
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
43728 WRCRWA CAP ASSET CONTRIBUTION 1,327,729.00 0.00 0.00 0.00 1,327,729.00 0.00 43729 WRCRWA TRTMNT/CONVEYANCE 445,912.00 0.00 268,726.07 0.00 177,185.93 60.26 43732 WRCRWA FIXED/ADMIN 1,844,323.00 0.00 0.00 0.00 1,844,323.00 0.00 44100 INTEREST EXPENSE 372,058.31 94,860.00 64,317.54 0.00 307,740.77 17.28 44200 BAD DEBTS EXPENSE 60,526.40 0.00 0.00 0.00 60,526.40 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 2,176,320.00 544,080.00 544,080.00 0.00 1,632,240.00 25.00 44613 INTERNAL SVC CHRG-WAREHOUSE 54,326.00 13,581.50 13,581.50 0.00 40,744.50 25.00 44614 INTERNAL SVC CHRG-INFO TECH 1,530,103.00 382,525.75 382,525.75 0.00 1,147,577.25 25.00 44615 INTERNAL SVC CHRG-NPDES 163,826.00 40,956.50 40,956.50 0.00 122,869.50 25.00 TOTAL FOR SERVICES-SUPPLIES 26,073,757.29 2,559,657.38 4,262,018.73 6,602,427.18 15,209,311.38 41.66
CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 514,917.12 0.00 0.00 464,917.12 50,000.00 90.28 TOTAL FOR CAPITAL OUTLAY 514,917.12 0.00 0.00 464,917.12 50,000.00 90.28 TOTAL FOR SEWER 33,463,868.65 2,986,933.72 5,590,932.44 7,067,344.30 20,805,591.91 37.82 FUN 572 86,506,236.90 4,238,385.03 7,400,749.86 17,869,432.09 61,236,054.95 29.21 LUISN Page: 7 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:31:13
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
573 SEWER GRANT/AGRMT
00 NOT APPLICABLE
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 521,627.59 0.00 0.00 0.00 521,627.59 0.00 TOTAL FOR SERVICES-SUPPLIES 521,627.59 0.00 0.00 0.00 521,627.59 0.00 TOTAL FOR NOT APPLICABLE 521,627.59 0.00 0.00 0.00 521,627.59 0.00 FUN 573 521,627.59 0.00 0.00 0.00 521,627.59 0.00
LUISN Page: 8 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:31:13
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 92,765,938.37 4,330,600.77 7,454,730.82 17,944,060.91 67,367,146.64 27.37 LUISN Page: 9 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:31:13
User:
Report: