GL
06/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 12
Ledger:
Level:
Month to
440 SEWER CAPACITY GEN SRVC
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 0.00 8,119.73 0.00 (8,119.73) 0.00 41141 SP COMP-BILINGUAL 0.00 0.00 79.22 0.00 (79.22) 0.00 41910 PERS-NORMAL 0.00 0.00 986.39 0.00 (986.39) 0.00
41920 MEDICARE 0.00 0.00 242.31 0.00 (242.31) 0.00
41931 WORKERS COMP 0.00 0.00 164.04 0.00 (164.04) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.00 7.52 0.00 (7.52) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 0.00 9,599.21 0.00 (9,599.21) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 5,573,616.92 0.00 0.00 0.00 5,573,616.92 0.00 42900 PROF. & CONT. SVCS 10,471.52 0.00 9,543.26 9,258.26 (8,330.00) 179.54 43300 CONSTRUCTION CONTRACTS 1,317,475.96 0.00 1,362,485.05 52,548.82 (97,557.91) 107.40 43727 INSPECTION 0.00 0.00 12,600.00 23,880.00 (36,480.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 6,901,564.40 0.00 1,384,628.31 85,687.08 5,431,249.01 21.30 TOTAL FOR NOT APPLICABLE 6,901,564.40 0.00 1,394,227.52 85,687.08 5,421,649.80 21.44 51 SEWER
SERVICES-SUPPLIES
44100 INTEREST EXPENSE 122,835.00 0.00 79,941.33 0.00 42,893.67 65.08 44610 ADMINISTRATIVE SERVICES CHARGE 13,666.00 0.00 10,249.50 0.00 3,416.50 75.00 TOTAL FOR SERVICES-SUPPLIES 136,501.00 0.00 90,190.83 0.00 46,310.17 66.07 TOTAL FOR SEWER 136,501.00 0.00 90,190.83 0.00 46,310.17 66.07 FUN 440 7,038,065.40 0.00 1,484,418.35 85,687.08 5,467,959.97 22.30 JULIEK Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/22/2024
Current Time: 14:15:51
User:
Report:
GL
06/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 12
Ledger:
Level:
Month to
572 SEWER UTILITY FUND
00 NOT APPLICABLE
SERVICES-SUPPLIES
23502 COMP TIME PAYABLES 0.00 528.65 (1,062.35) 0.00 1,062.35 0.00 TOTAL FOR SERVICES-SUPPLIES 0.00 528.65 (1,062.35) 0.00 1,062.35 0.00
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 7,746.13 79,609.21 0.00 (79,609.21) 0.00 41141 SP COMP-BILINGUAL 0.00 29.53 213.81 0.00 (213.81) 0.00 41300 OVERTIME 0.00 79.56 1,653.19 0.00 (1,653.19) 0.00 41910 PERS-NORMAL 0.00 935.40 9,602.70 0.00 (9,602.70) 0.00 41920 MEDICARE 0.00 231.50 2,409.47 0.00 (2,409.47) 0.00 41929 SHORT TERM DISABILITY 0.00 3.78 13.06 0.00 (13.06) 0.00 41931 WORKERS COMP 0.00 155.09 1,595.17 0.00 (1,595.17) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 7.18 74.36 0.00 (74.36) 0.00 41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 2.36 0.00 (2.36) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 9,188.17 95,173.33 0.00 (95,173.33) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 46,795,866.66 0.00 0.00 0.00 46,795,866.66 0.00 40003 CIP-MATERIALS & SUPPLIES 0.00 0.00 39,820.82 0.00 (39,820.82) 0.00 42033 CONSTRUCTION MATERIALS 0.00 0.00 218,782.79 55,754.33 (274,537.12) 0.00 42055 COMPUTER EQUIPMENT & 0.00 0.00 4,676.56 3,431.57 (8,108.13) 0.00 42300 WIRELESS COMMUNICATION 0.00 117.60 705.60 0.00 (705.60) 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 4,424.57 0.00 (4,424.57) 0.00 42430 WATER UTILITY 0.00 0.00 149.26 0.00 (149.26) 0.00 42700 OTHER EQUIPMENT RENTAL 3,060.48 489.38 6,321.44 2,739.04 (6,000.00) 296.04 42800 EQUIPMENT MAINTENANCE 1,528.00 0.00 0.00 1,528.00 0.00 100.00 42815 SCADA MAINTENANCE 101,822.10 107,319.78 384,772.71 141,224.04 (424,174.65) 516.58 42900 PROF. & CONT. SVCS 1,491,791.55 397,655.47 1,852,854.12 3,699,248.70 (4,060,311.27) 372.17 43300 CONSTRUCTION CONTRACTS 1,978,586.84 591,374.27 4,918,262.50 9,715,881.16 (12,655,556.82) 739.62 43301 CAPITAL IMPROVEMENTS 32,080.07 0.00 26,630.00 32,080.07 (26,630.00) 183.01 43400 LEGAL SERVICES-SPECIAL COUNSEL 0.00 17,923.64 241,165.06 34,431.96 (275,597.02) 0.00 43715 REGULATORY PERMIT & USE FEES 0.00 0.00 1,331.98 0.00 (1,331.98) 0.00 43724 OUTSIDE SERVICES - LABOR 0.00 0.00 10,057.50 0.00 (10,057.50) 0.00 43726 PROJECT MANAGEMENT 11,969.25 25,852.50 114,900.00 11,669.25 (114,600.00) 1,057.45 43727 INSPECTION 131,852.00 0.00 45,733.60 72,598.40 13,520.00 89.74 TOTAL FOR SERVICES-SUPPLIES 50,548,556.95 1,140,732.64 7,870,588.51 13,770,586.52 28,907,381.92 42.81
SERVICES-SUPPLIES
40002 CIP-CONTRACTUAL 0.00 0.00 7,827.36 0.00 (7,827.36) 0.00 TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 7,827.36 0.00 (7,827.36) 0.00 JULIEK Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/22/2024
Current Time: 14:15:51
User:
Report:
GL
06/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 12
Ledger:
Level:
Month to
CAPITAL OUTLAY
45100 LICENSED VEHICLES 257,357.00 0.00 0.00 231,743.52 25,613.48 90.04 45200 MACHINERY, EQUIPMENT, & FIXTUR 1,226,184.90 7,068.75 1,027,657.42 200,414.30 (1,886.82) 100.15 45300 COMPUTER SOFTWARE 0.00 0.00 8,265.00 0.00 (8,265.00) 0.00 TOTAL FOR CAPITAL OUTLAY 1,483,541.90 7,068.75 1,035,922.42 432,157.82 15,461.66 98.95 TOTAL FOR NOT APPLICABLE 52,032,098.85 1,157,518.21 9,008,449.27 14,202,744.34 28,820,905.24 44.60 11 CITY MANAGER'S OFFICE
SALARIES-BENEFITS
41200 TEMPORARY EMPLOYEES 3,446.82 286.15 2,924.36 0.00 522.46 84.84 41510 PST DEFERRED COMPENSATION 45.51 3.35 37.67 0.00 7.84 82.77 41910 PERS-NORMAL 0.00 3.38 3.38 0.00 (3.38) 0.00
41920 MEDICARE 49.58 4.20 42.94 0.00 6.64 86.60
41931 WORKERS COMP 68.79 5.72 58.53 0.00 10.26 85.08
41932 STATE UNEMPLOYMENT INSURANCE 3.03 0.26 2.63 0.00 0.40 86.79 41997 BUDGETARY/PAYROLL (41.73) 0.00 0.00 0.00 (41.73) 0.00 TOTAL FOR SALARIES-BENEFITS 3,572.00 303.06 3,069.51 0.00 502.49 85.93 TOTAL FOR CITY MANAGER'S OFFICE 3,572.00 303.06 3,069.51 0.00 502.49 85.93 13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 0.00 0.00 138.46 0.00 (138.46) 0.00 44001 DS PRINCIPAL 2021 POBS 0.00 0.00 776,434.86 0.00 (776,434.86) 0.00 44101 DS INTEREST 2021 POBS 215,364.00 0.00 215,363.60 0.00 0.40 100.00 TOTAL FOR SERVICES-SUPPLIES 215,364.00 0.00 991,936.92 0.00 (776,572.92) 460.58 TOTAL FOR DEBT SERVICE 215,364.00 0.00 991,936.92 0.00 (776,572.92) 460.58 21 PLANNING & DEVELOPMENT
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 35,076.00 1,819.04 23,656.26 0.00 11,419.74 67.44 41141 SP COMP-BILINGUAL 403.00 27.08 356.00 0.00 47.00 88.33 41400 SPECIAL DUTY PAY 0.00 0.00 20.00 0.00 (20.00) 0.00 41500 DEFERRED COMPENSATION MATCH 75.00 0.00 75.01 0.00 (0.01) 100.01 41520 TIERED EMP DEF COMPENSATION 90.00 22.50 90.00 0.00 0.00 100.00 41530 TIERED RHS BENEFIT 30.00 7.50 30.00 0.00 0.00 100.00 41600 LONGEVITY 175.00 8.08 105.04 0.00 69.96 60.02
41910 PERS-NORMAL 3,524.00 223.04 2,901.14 0.00 622.86 82.32 41920 MEDICARE 1,060.00 53.20 701.55 0.00 358.45 66.18
41929 SHORT TERM DISABILITY 111.00 7.48 97.10 0.00 13.90 87.47 41930 LONG TERM DISABILITY 239.00 12.36 160.85 0.00 78.15 67.30 41931 WORKERS COMP 710.00 35.32 468.50 0.00 241.50 65.98 JULIEK Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/22/2024
Current Time: 14:15:51
User:
Report:
GL
06/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 12
Ledger:
Level:
Month to
41932 STATE UNEMPLOYMENT INSURANCE 33.00 1.62 21.43 0.00 11.57 64.93 41940 HEALTH INSURANCE 8,020.00 463.53 5,731.14 0.00 2,288.86 71.46 41946 LIFE INSURANCE 290.00 15.12 196.59 0.00 93.41 67.78 41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 100.78 0.00 (100.78) 0.00 41996 VACANCY FACTOR (14,452.00) 0.00 0.00 0.00 (14,452.00) 0.00 TOTAL FOR SALARIES-BENEFITS 35,384.00 2,695.87 34,711.39 0.00 672.61 98.09
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 60.00 0.00 12.19 0.00 47.81 20.31 TOTAL FOR SERVICES-SUPPLIES 60.00 0.00 12.19 0.00 47.81 20.31 TOTAL FOR PLANNING & DEVELOPMENT DEPT35,444.00 2,695.87 34,723.58 0.00 720.42 97.96 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 508,521.04 18,624.10 281,702.02 0.00 226,819.02 55.39 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 17.91 0.00 (17.91) 0.00 41140 FINAL LEAVE 0.00 0.00 28,919.94 0.00 (28,919.94) 0.00 41141 SP COMP-BILINGUAL 3,218.00 72.01 1,515.35 0.00 1,702.65 47.08 41200 TEMPORARY EMPLOYEES 17,594.46 697.54 8,380.32 0.00 9,214.14 47.63 41300 OVERTIME 0.00 215.48 1,682.95 0.00 (1,682.95) 0.00 41400 SPECIAL DUTY PAY 0.00 302.62 4,038.15 0.00 (4,038.15) 0.00 41410 AUTO ALLOWANCE 576.00 44.30 575.90 0.00 0.10 99.98 41500 DEFERRED COMPENSATION MATCH 3,058.00 252.50 1,851.05 0.00 1,206.95 60.53 41510 PST DEFERRED COMPENSATION 227.59 9.07 109.00 0.00 118.59 47.89 41520 TIERED EMP DEF COMPENSATION 972.00 192.00 826.50 0.00 145.50 85.03 41530 TIERED RHS BENEFIT 912.00 172.00 746.50 0.00 165.50 81.85 41600 LONGEVITY 3,199.00 157.45 2,455.13 0.00 743.87 76.74 41700 ANNUAL LEAVE BUYBACK 16,740.00 0.00 7,935.09 0.00 8,804.91 47.40 41710 ANNUAL LEAVE OVER MAX 0.00 0.00 42.43 0.00 (42.43) 0.00 41910 PERS-NORMAL 61,957.76 2,290.64 34,574.70 0.00 27,383.06 55.80 41920 MEDICARE 16,197.68 595.28 9,950.13 0.00 6,247.55 61.42 41929 SHORT TERM DISABILITY 1,627.84 106.81 1,656.43 0.00 (28.59) 101.75 41930 LONG TERM DISABILITY 3,457.80 182.30 2,768.15 0.00 689.65 80.05 41931 WORKERS COMP 10,622.31 385.82 5,819.75 0.00 4,802.56 54.78 41932 STATE UNEMPLOYMENT INSURANCE 496.40 18.20 306.62 0.00 189.78 61.76 41940 HEALTH INSURANCE 89,656.00 3,326.13 59,256.30 0.00 30,399.70 66.09 41945 OPT OUT HEALTH INSURANCE 1,848.00 340.00 4,865.60 0.00 (3,017.60) 263.29 41946 LIFE INSURANCE 4,218.19 222.52 3,379.08 0.00 839.11 80.10 41951 HEALTH ALLOWANCE CREDIT 0.00 13.05 1,318.34 0.00 (1,318.34) 0.00 41996 VACANCY FACTOR (151,573.00) 0.00 0.00 0.00 (151,573.00) 0.00 41997 BUDGETARY/PAYROLL (524.07) 0.00 0.00 0.00 (524.07) 0.00 JULIEK Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/22/2024
Current Time: 14:15:51
User:
Report:
GL
06/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 12
Ledger:
Level:
Month to
TOTAL FOR SALARIES-BENEFITS 593,003.00 28,219.82 464,693.34 0.00 128,309.66 78.36
SERVICES-SUPPLIES
42055 COMPUTER EQUIPMENT & 3,000.00 0.00 0.00 0.00 3,000.00 0.00 42101 SAFETY SHOES - MOU ITEM 1,233.00 0.00 959.77 0.00 273.23 77.84 42340 OFFICE SUPPLIES 0.00 0.00 24.47 0.00 (24.47) 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 108.75 0.00 (108.75) 0.00 43200 CONFERENCE, TRAINING & TRAVEL 0.00 0.00 745.68 0.00 (745.68) 0.00 TOTAL FOR SERVICES-SUPPLIES 4,233.00 0.00 1,838.67 0.00 2,394.33 43.43 TOTAL FOR PUBLIC WORKS 597,236.00 28,219.82 466,532.01 0.00 130,703.99 78.11 51 SEWER
SERVICES-SUPPLIES
TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 3,857,865.11 262,819.58 3,328,738.02 0.00 529,127.09 86.28 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 977.49 0.00 (977.49) 0.00 41102 SHIFT DIFFERENTIAL 0.00 2,788.41 35,447.16 0.00 (35,447.16) 0.00 41103 OUT OF CLASS PAY 0.00 0.00 123.48 0.00 (123.48) 0.00 41140 FINAL LEAVE 0.00 0.00 64,577.86 0.00 (64,577.86) 0.00 41141 SP COMP-BILINGUAL 27,400.00 2,819.82 29,877.77 0.00 (2,477.77) 109.04 41147 SP COMP-GRADE 4 CERT PAY 11,280.00 650.76 10,846.00 0.00 434.00 96.15 41148 SP COMP-GRADE 5 CERT PAY 91,208.00 6,514.53 90,173.67 0.00 1,034.33 98.86 41200 TEMPORARY EMPLOYEES 57,211.87 2,762.83 32,707.88 0.00 24,503.99 57.16 41300 OVERTIME 583,872.00 36,524.08 565,452.87 0.00 18,419.13 96.84 41320 COMP TIME 0.00 528.65 12,359.78 0.00 (12,359.78) 0.00 41400 SPECIAL DUTY PAY 28,377.00 4,438.11 57,454.07 0.00 (29,077.07) 202.46 41410 AUTO ALLOWANCE 2,592.00 199.38 2,591.94 0.00 0.06 99.99 41500 DEFERRED COMPENSATION MATCH 19,518.00 2,751.58 16,208.59 0.00 3,309.41 83.04 41510 PST DEFERRED COMPENSATION 275.02 36.44 407.53 0.00 (132.51) 148.18 41520 TIERED EMP DEF COMPENSATION 11,850.00 2,602.14 10,733.06 0.00 1,116.94 90.57 41530 TIERED RHS BENEFIT 5,918.00 1,414.38 5,465.68 0.00 452.32 92.35 41600 LONGEVITY 27,829.00 1,704.21 25,789.05 0.00 2,039.95 92.66 41660 TUITION REIMBURSEMENT 0.00 0.00 1,004.85 0.00 (1,004.85) 0.00 41700 ANNUAL LEAVE BUYBACK 83,946.00 0.00 78,571.41 0.00 5,374.59 93.59 41710 ANNUAL LEAVE OVER MAX 4,762.00 0.00 9,877.60 0.00 (5,115.60) 207.42 41910 PERS-NORMAL 488,114.05 34,054.57 431,160.14 0.00 56,953.91 88.33 41920 MEDICARE 142,399.22 9,553.58 130,208.04 0.00 12,191.18 91.43 41929 SHORT TERM DISABILITY 12,340.44 1,067.21 13,626.43 0.00 (1,285.99) 110.42 41930 LONG TERM DISABILITY 26,224.68 1,769.64 22,602.73 0.00 3,621.95 86.18 41931 WORKERS COMP 82,773.97 5,485.98 70,545.15 0.00 12,228.82 85.22 JULIEK Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/22/2024
Current Time: 14:15:51
User:
Report:
GL
06/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 12
Ledger:
Level:
Month to
41932 STATE UNEMPLOYMENT INSURANCE 4,342.59 290.98 3,991.11 0.00 351.48 91.90 41940 HEALTH INSURANCE 818,768.00 49,713.86 627,149.83 0.00 191,618.17 76.59 41941 RETIREES HEALTH INSURANCE/OPEB 390,986.00 81,595.04 390,975.63 0.00 10.37 99.99 41945 OPT OUT HEALTH INSURANCE 41,160.00 6,115.00 99,853.70 0.00 (58,693.70) 242.59 41946 LIFE INSURANCE 32,021.69 2,160.06 27,587.73 0.00 4,433.96 86.15 41951 HEALTH ALLOWANCE CREDIT 0.00 336.86 11,809.86 0.00 (11,809.86) 0.00 41996 VACANCY FACTOR (127,055.00) 0.00 0.00 0.00 (127,055.00) 0.00 41997 BUDGETARY/PAYROLL 72,207.36 0.00 0.00 0.00 72,207.36 0.00 TOTAL FOR SALARIES-BENEFITS 6,798,187.00 520,697.68 6,208,896.11 0.00 589,290.89 91.33
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 63,550.00 15,634.66 188,605.72 4,449.23 (129,504.95) 303.78 42033 CONSTRUCTION MATERIALS 966,630.04 150,470.02 1,313,277.95 222,268.59 (568,916.50) 158.85 42034 SAFETY MATERIALS/CONSTRUCTION 22,475.00 1,767.34 26,680.71 0.00 (4,205.71) 118.71 42055 COMPUTER EQUIPMENT & 35,690.00 300.03 47,749.64 0.00 (12,059.64) 133.78 42100 UNIFORM EXPENSE 14,414.00 607.06 12,029.49 0.00 2,384.51 83.45 42101 SAFETY SHOES - MOU ITEM 9,744.00 830.47 14,608.30 0.00 (4,864.30) 149.92 42200 ADVERTISING EXPENSE 5,183.00 0.00 3,283.99 0.00 1,899.01 63.36 42220 PROMOTIONAL/PUBLIC OUTREACH 14,752.00 0.00 1,124.65 0.00 13,627.35 7.62 42300 WIRELESS COMMUNICATION 22,799.00 1,638.95 19,148.82 0.00 3,650.18 83.98 42310 PHONES, FAX, ISDN LINES 11,929.00 7,689.91 39,567.80 0.00 (27,638.80) 331.69 42320 POSTAGE & SHIPPING 120,737.00 14,546.28 118,915.78 0.00 1,821.22 98.49 42340 OFFICE SUPPLIES 11,312.00 1,979.26 8,984.45 0.00 2,327.55 79.42 42345 FIRST AID KIT SUPPLIES 340.00 0.00 243.91 0.00 96.09 71.73 42350 PROGRAM EXPENDITURES 19,382.00 4,028.09 61,506.88 166.96 (42,291.84) 318.20 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 2,263.27 0.00 (2,263.27) 0.00 42365 RECYCLED CONTENT PRODUCTS 999.00 0.00 515.31 0.00 483.69 51.58 42410 ELECTRIC UTILITY 1,734,412.00 9,007.69 1,280,808.29 0.00 453,603.71 73.84 42420 NATURAL GAS UTILITY 57,600.00 3,640.12 37,259.95 0.00 20,340.05 64.68 42430 WATER UTILITY 64,575.00 0.00 84,478.08 0.00 (19,903.08) 130.82 42435 RECYCLED WATER UTILITY 646,591.00 0.00 825,965.88 0.00 (179,374.88) 127.74 42441 UNLEADED FUEL 600.00 16.11 158.55 0.00 441.45 26.42 42442 DIESEL FUEL 15,000.00 22.45 37,237.88 0.00 (22,237.88) 248.25 42443 OTHER FUELS 60.00 0.00 0.00 0.00 60.00 0.00
42500 RENTS & LEASES 817,427.00 0.00 596,672.25 0.00 220,754.75 72.99 42501 CUA LEASES 1,548,785.00 0.00 1,161,588.75 0.00 387,196.25 75.00 42600 MOTOR POOL RENTAL - OPS & MTCE 184,092.00 0.00 83,147.75 0.00 100,944.25 45.16 42605 RETAINED VEHICLE EXPENSE 2,431.00 0.00 1,215.50 0.00 1,215.50 50.00 42610 DIRECT VEHICLE EXPENSE 9,522.00 1,892.40 5,138.85 9,792.60 (5,409.45) 156.81 42700 OTHER EQUIPMENT RENTAL 70,513.67 6,868.05 76,374.11 28,476.61 (34,337.05) 148.69 42710 MILEAGE/VEHICLE EXP REIMB 570.00 0.00 15.06 0.00 554.94 2.64 JULIEK Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/22/2024
Current Time: 14:15:51
User:
Report:
GL
06/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 12
Ledger:
Level:
Month to
42813 MTCE & REPAIR - EQUIP & FAC 627,148.99 84,988.33 763,567.34 353,086.29 (489,504.64) 178.05 42815 SCADA MAINTENANCE 310,026.00 48,167.18 353,083.67 36,281.76 (79,339.43) 125.59 42816 MOWING/LANDSCAPE CONTRACTS 111,991.00 14,500.00 11,422.19 99,900.00 668.81 99.40 42900 PROF. & CONT. SVCS 1,121,379.94 263,791.54 985,755.05 339,153.46 (203,528.57) 118.14 42902 CUST CREDIT CRD PROCESSING FEE 352,078.00 5,809.02 227,232.41 118,222.41 6,623.18 98.11 42910 REFUSE DISPOSAL 90,588.00 0.00 52,139.25 0.00 38,448.75 57.55 43000 INSURANCE & SURETY BONDS 54,282.00 0.00 55,256.60 0.00 (974.60) 101.79 43100 MEMBERSHIP & DUES 36,652.00 0.00 31,527.00 0.00 5,125.00 86.01 43200 CONFERENCE, TRAINING & TRAVEL 46,831.00 1,299.56 38,599.40 0.00 8,231.60 82.42 43400 LEGAL SERVICES-SPECIAL COUNSEL 22,500.00 0.00 0.00 0.00 22,500.00 0.00 43500 BOOKS 0.00 0.00 537.76 0.00 (537.76) 0.00
43698 CHEMICALS-SODIUM BISOLFITE 120,560.00 0.00 48,877.86 71,572.14 110.00 99.90 43700 CHEMICALS-MINERAL OIL 0.00 0.00 4,289.59 0.00 (4,289.59) 0.00 43701 CHEMICALS-POLYMER 1,643,968.00 135,646.05 557,354.21 793,645.79 292,968.00 82.17 43707 CHEMICALS-SODIUM 2,238,500.00 141,408.64 1,502,078.22 736,421.78 0.00 100.00 43709 CHEMICALS-FERRIC CHLORIDE 135,520.00 11,847.10 106,227.33 5,772.67 23,520.00 82.64 43711 CHEMICALS-MISC 25,000.00 0.00 0.00 0.00 25,000.00 0.00 43713 BIOSOLIDS DISPOSAL/RECYCLE 1,800,000.00 118,411.14 1,274,193.08 1,039,846.26 (514,039.34) 128.55 43714 OUTSIDE LAB ANALYSIS 562,200.00 53,446.25 405,493.20 26,221.80 130,485.00 76.79 43715 REGULATORY PERMIT & USE FEES 225,736.00 2,644.84 225,258.59 0.00 477.41 99.78 43716 JOB REQ CERTIFICATES & LICENSE 1,950.00 400.00 3,189.66 0.00 (1,239.66) 163.57 43720 LAB CHEMICALS AND SUPPLIES 37,632.00 4,032.60 92,980.68 0.00 (55,348.68) 247.07 43722 PREVENTION & MAINTENANCE 1,173,347.38 55,682.23 1,195,227.01 82,437.99 (104,317.62) 108.89 43723 INLAND EMPIRE BRINE LINE-SARI 7,755.00 0.00 0.00 0.00 7,755.00 0.00 43725 FINES AND PENALTIES 0.00 0.00 177,000.00 0.00 (177,000.00) 0.00 43726 PROJECT MANAGEMENT 0.00 810.00 810.00 0.00 (810.00) 0.00 43728 WRCRWA CAP ASSET CONTRIBUTION 1,092,443.00 0.00 874,857.40 0.00 217,585.60 80.08 43729 WRCRWA TRTMNT/CONVEYANCE 1,839,905.00 167,479.27 1,533,101.60 0.00 306,803.40 83.32 44100 INTEREST EXPENSE 400,488.00 0.00 164,415.52 0.00 236,072.48 41.05 44200 BAD DEBTS EXPENSE 60,462.00 0.00 0.00 0.00 60,462.00 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 1,661,969.00 0.00 1,246,476.75 0.00 415,492.25 75.00 44613 INTERNAL SVC CHRG-WAREHOUSE 56,936.00 14,234.00 56,936.00 0.00 0.00 100.00 44614 INTERNAL SVC CHRG-INFO TECH 1,590,944.00 0.00 1,169,979.16 0.00 420,964.84 73.53 44615 INTERNAL SVC CHRG-NPDES 156,082.00 0.00 117,061.50 0.00 39,020.50 75.00 44700 LOSS ON FIXED ASSET DISPOSAL 0.00 0.00 22,390.87 0.00 (22,390.87) 0.00 TOTAL FOR SERVICES-SUPPLIES 24,076,989.02 1,345,536.64 19,345,886.47 3,967,716.34 763,386.21 96.82
CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 664,818.00 (192,346.13) 81,913.88 509,361.56 73,542.56 88.93 TOTAL FOR CAPITAL OUTLAY 664,818.00 (192,346.13) 81,913.88 509,361.56 73,542.56 88.93 JULIEK Page: 7 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/22/2024
Current Time: 14:15:51
User:
Report:
GL
06/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 12
Ledger:
Level:
Month to
TOTAL FOR SEWER 31,539,994.02 1,673,888.19 25,636,696.46 4,477,077.90 1,426,219.66 95.47 FUN 572 84,423,708.87 2,862,625.15 36,141,407.75 18,679,822.24 29,602,478.88 64.93 JULIEK Page: 8 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/22/2024
Current Time: 14:15:51
User:
Report:
GL
06/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 12
Ledger:
Level:
Month to
573 SEWER GRANT/AGRMT
00 NOT APPLICABLE
CAPITAL OUTLAY
23502 COMP TIME PAYABLES 0.00 0.00 258.98 0.00 (258.98) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 0.00 258.98 0.00 (258.98) 0.00
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 100.39 2,333.45 0.00 (2,333.45) 0.00 41141 SP COMP-BILINGUAL 0.00 0.00 5.59 0.00 (5.59) 0.00 41200 TEMPORARY EMPLOYEES 0.00 0.00 428.28 0.00 (428.28) 0.00 41300 OVERTIME 0.00 15.45 1,865.32 0.00 (1,865.32) 0.00 41320 COMP TIME 0.00 0.00 258.98 0.00 (258.98) 0.00
41910 PERS-NORMAL 0.00 12.07 281.40 0.00 (281.40) 0.00
41920 MEDICARE 0.00 3.42 130.16 0.00 (130.16) 0.00
41931 WORKERS COMP 0.00 2.00 55.36 0.00 (55.36) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.10 4.19 0.00 (4.19) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 133.43 5,362.73 0.00 (5,362.73) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 64,511.11 0.00 0.00 0.00 64,511.11 0.00 42830 REBATE PROGRAMS 0.00 912.49 36,926.74 0.00 (36,926.74) 0.00 42900 PROF. & CONT. SVCS 308.10 0.00 0.00 308.10 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 64,819.21 912.49 36,926.74 308.10 27,584.37 57.44 TOTAL FOR NOT APPLICABLE 64,819.21 1,045.92 42,548.45 308.10 21,962.66 66.11 FUN 573 64,819.21 1,045.92 42,548.45 308.10 21,962.66 66.11 JULIEK Page: 9 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/22/2024
Current Time: 14:15:51
User:
Report:
GL
06/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 12
Ledger:
Level:
Month to
GRAND TOTAL 91,526,593.48 2,863,671.07 37,668,374.55 18,765,817.42 35,092,401.51 61.65 JULIEK Page: 10 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/22/2024
Current Time: 14:15:51
User:
Report: