GL
03/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 09
Ledger:
Level:
Month to
440 SEWER CAPACITY GEN SRVC
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 50.28 1,404.82 0.00 (1,404.82) 0.00 41141 SP COMP-BILINGUAL 0.00 1.10 33.62 0.00 (33.62) 0.00 41910 PERS-NORMAL 0.00 5.59 156.52 0.00 (156.52) 0.00
41920 MEDICARE 0.00 1.54 42.46 0.00 (42.46) 0.00
41929 SHORT TERM DISABILITY 0.00 0.00 3.76 0.00 (3.76) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 6.30 0.00 (6.30) 0.00 41931 WORKERS COMP 0.00 1.03 28.73 0.00 (28.73) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.02 0.72 0.00 (0.72) 0.00 41940 HEALTH INSURANCE 0.00 0.00 227.64 0.00 (227.64) 0.00 41946 LIFE INSURANCE 0.00 0.00 7.65 0.00 (7.65) 0.00
41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 7.16 0.00 (7.16) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 59.56 1,919.38 0.00 (1,919.38) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 3,085,180.01 0.00 0.00 0.00 3,085,180.01 0.00 42900 PROF. & CONT. SVCS 59,407.50 0.00 55,225.76 11,271.52 (7,089.78) 111.93 43300 CONSTRUCTION CONTRACTS 0.00 0.00 0.00 1,491,373.00 (1,491,373.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 3,144,587.51 0.00 55,225.76 1,502,644.52 1,586,717.23 49.54 TOTAL FOR NOT APPLICABLE 3,144,587.51 59.56 57,145.14 1,502,644.52 1,584,797.85 49.60 51 SEWER
SERVICES-SUPPLIES
44100 INTEREST EXPENSE 134,444.00 64,695.00 73,112.04 0.00 61,331.96 54.38 44610 ADMINISTRATIVE SERVICES CHARGE 7,538.00 1,884.50 5,653.50 0.00 1,884.50 75.00 TOTAL FOR SERVICES-SUPPLIES 141,982.00 66,579.50 78,765.54 0.00 63,216.46 55.47 TOTAL FOR SEWER 141,982.00 66,579.50 78,765.54 0.00 63,216.46 55.47 FUN 440 3,286,569.51 66,639.06 135,910.68 1,502,644.52 1,648,014.31 49.85 JULIEK Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:24:28
User:
Report:
GL
03/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 09
Ledger:
Level:
Month to
572 SEWER UTILITY FUND
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 6,956.95 59,336.50 0.00 (59,336.50) 0.00 41141 SP COMP-BILINGUAL 0.00 30.89 252.42 0.00 (252.42) 0.00 41200 TEMPORARY EMPLOYEES 0.00 0.00 602.49 0.00 (602.49) 0.00 41300 OVERTIME 0.00 0.00 4,316.30 0.00 (4,316.30) 0.00
41510 PST DEFERRED COMPENSATION 0.00 0.00 7.84 0.00 (7.84) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 0.00 132.67 0.00 (132.67) 0.00 41530 TIERED RHS BENEFIT 0.00 0.00 82.67 0.00 (82.67) 0.00 41600 LONGEVITY 0.00 0.00 230.45 0.00 (230.45) 0.00
41910 PERS-NORMAL 0.00 760.31 6,553.43 0.00 (6,553.43) 0.00 41920 MEDICARE 0.00 206.84 1,911.50 0.00 (1,911.50) 0.00 41929 SHORT TERM DISABILITY 0.00 0.00 75.08 0.00 (75.08) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 124.42 0.00 (124.42) 0.00 41931 WORKERS COMP 0.00 139.76 1,203.81 0.00 (1,203.81) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 3.52 32.77 0.00 (32.77) 0.00 41940 HEALTH INSURANCE 0.00 0.00 3,135.58 0.00 (3,135.58) 0.00 41946 LIFE INSURANCE 0.00 0.00 151.87 0.00 (151.87) 0.00 41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 216.18 0.00 (216.18) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 8,098.27 78,365.98 0.00 (78,365.98) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 30,077,787.07 0.00 0.00 0.00 30,077,787.07 0.00 42033 CONSTRUCTION MATERIALS 0.00 12,396.69 41,420.73 60,508.93 (101,929.66) 0.00 42200 ADVERTISING EXPENSE 0.00 0.00 1,382.66 0.00 (1,382.66) 0.00 42320 POSTAGE & SHIPPING 0.00 0.00 (732.79) 0.00 732.79 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 51.14 0.00 (51.14) 0.00 42430 WATER UTILITY 0.00 332.46 528.18 0.00 (528.18) 0.00 42700 OTHER EQUIPMENT RENTAL 0.00 0.00 5,387.84 5,000.00 (10,387.84) 0.00 42800 EQUIPMENT MAINTENANCE 1,528.00 0.00 0.00 1,528.00 0.00 100.00 42815 SCADA MAINTENANCE 37,026.84 28,931.80 131,976.24 102,868.14 (197,817.54) 634.25 42900 PROF. & CONT. SVCS 298,476.85 54,238.41 290,506.19 727,965.20 (719,994.54) 341.22 43200 CONFERENCE, TRAINING & TRAVEL 0.00 0.00 263.24 0.00 (263.24) 0.00 43300 CONSTRUCTION CONTRACTS 1,837,040.24 136,250.00 672,855.66 3,706,263.41 (2,542,078.83) 238.37 43301 CAPITAL IMPROVEMENTS 0.00 0.00 0.00 67,080.07 (67,080.07) 0.00 43400 LEGAL SERVICES-SPECIAL COUNSEL 0.00 0.00 16,387.70 0.00 (16,387.70) 0.00 43724 OUTSIDE SERVICES - LABOR 0.00 3,240.00 29,362.50 0.00 (29,362.50) 0.00 43726 PROJECT MANAGEMENT 17,028.50 46,185.25 83,409.25 11,969.25 (78,350.00) 560.11 43727 INSPECTION 0.00 2,010.00 2,010.00 154,950.00 (156,960.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 32,268,887.50 283,584.61 1,274,808.54 4,838,133.00 26,155,945.96 18.94 JULIEK Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:24:28
User:
Report:
GL
03/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 09
Ledger:
Level:
Month to
CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 817,313.46 0.00 402,253.77 1,385,043.14 (969,983.45) 218.67 45400 LAND 0.00 0.00 4,000.00 0.00 (4,000.00) 0.00
TOTAL FOR CAPITAL OUTLAY 817,313.46 0.00 406,253.77 1,385,043.14 (973,983.45) 219.16 TOTAL FOR NOT APPLICABLE 33,086,200.96 291,682.88 1,759,428.29 6,223,176.14 25,103,596.53 24.12 11 CITY MANAGER'S OFFICE
SALARIES-BENEFITS
41200 TEMPORARY EMPLOYEES 3,353.64 132.83 1,135.60 0.00 2,218.04 33.86 41510 PST DEFERRED COMPENSATION 43.60 1.73 14.76 0.00 28.84 33.85 41920 MEDICARE 49.35 1.96 16.69 0.00 32.66 33.81
41931 WORKERS COMP 67.07 2.66 22.70 0.00 44.37 33.84
41932 STATE UNEMPLOYMENT INSURANCE 1.68 0.06 0.55 0.00 1.13 32.73 TOTAL FOR SALARIES-BENEFITS 3,515.34 139.24 1,190.30 0.00 2,325.04 33.86 TOTAL FOR CITY MANAGER'S OFFICE 3,515.34 139.24 1,190.30 0.00 2,325.04 33.86 13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 0.00 0.00 150.55 0.00 (150.55) 0.00 44101 DS INTEREST 2021 POBS 218,273.55 0.00 73,256.20 0.00 145,017.35 33.56 TOTAL FOR SERVICES-SUPPLIES 218,273.55 0.00 73,406.75 0.00 144,866.80 33.63 TOTAL FOR DEBT SERVICE 218,273.55 0.00 73,406.75 0.00 144,866.80 33.63 21 COMMUNITY DEVELOPMENT
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 32,780.74 2,138.06 22,493.53 0.00 10,287.21 68.61 41103 OUT OF CLASS PAY 0.00 0.00 285.72 0.00 (285.72) 0.00 41141 SP COMP-BILINGUAL 744.74 31.04 267.80 0.00 476.94 35.95 41300 OVERTIME 0.00 0.00 59.99 0.00 (59.99) 0.00
41500 DEFERRED COMPENSATION MATCH 265.00 75.00 105.00 0.00 160.00 39.62 41520 TIERED EMP DEF COMPENSATION 150.00 22.50 82.50 0.00 67.50 55.00 41530 TIERED RHS BENEFIT 90.00 7.50 37.50 0.00 52.50 41.66 41600 LONGEVITY 145.00 5.76 100.45 0.00 44.55 69.27
41700 ANNUAL LEAVE BUYBACK 331.35 0.00 441.84 0.00 (110.49) 133.34 41910 PERS-NORMAL 3,663.35 236.62 2,483.61 0.00 1,179.74 67.79 41920 MEDICARE 1,027.63 66.82 704.46 0.00 323.17 68.55
41929 SHORT TERM DISABILITY 104.90 8.76 92.14 0.00 12.76 87.83 41930 LONG TERM DISABILITY 222.91 14.54 152.68 0.00 70.23 68.49 41931 WORKERS COMP 670.51 43.14 458.43 0.00 212.08 68.37 41932 STATE UNEMPLOYMENT INSURANCE 17.18 1.08 12.04 0.00 5.14 70.08 41940 HEALTH INSURANCE 7,090.01 484.62 4,732.36 0.00 2,357.65 66.74 JULIEK Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:24:28
User:
Report:
GL
03/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 09
Ledger:
Level:
Month to
41945 OPT OUT HEALTH INSURANCE 360.00 0.00 105.07 0.00 254.93 29.18 41946 LIFE INSURANCE 272.08 17.76 186.44 0.00 85.64 68.52 41951 HEALTH ALLOWANCE CREDIT 0.00 17.58 292.18 0.00 (292.18) 0.00 41996 VACANCY FACTOR (1,788.00) 0.00 0.00 0.00 (1,788.00) 0.00 TOTAL FOR SALARIES-BENEFITS 46,147.40 3,170.78 33,093.74 0.00 13,053.66 71.71
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 60.00 0.00 8.81 0.00 51.19 14.68 TOTAL FOR SERVICES-SUPPLIES 60.00 0.00 8.81 0.00 51.19 14.68 TOTAL FOR COMMUNITY DEVELOPMENT DEPT46,207.40 3,170.78 33,102.55 0.00 13,104.85 71.63 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 465,706.22 20,066.50 177,112.68 0.00 288,593.54 38.03 41103 OUT OF CLASS PAY 0.00 0.00 2,122.32 0.00 (2,122.32) 0.00 41141 SP COMP-BILINGUAL 3,446.70 113.74 1,146.71 0.00 2,299.99 33.26 41200 TEMPORARY EMPLOYEES 18,399.44 537.56 7,080.52 0.00 11,318.92 38.48 41300 OVERTIME 500.00 0.00 1,417.10 0.00 (917.10) 283.42 41400 SPECIAL DUTY PAY 0.00 283.12 2,793.05 0.00 (2,793.05) 0.00 41410 AUTO ALLOWANCE 576.00 44.30 420.91 0.00 155.09 73.07 41500 DEFERRED COMPENSATION MATCH 2,868.00 1,591.03 1,591.79 0.00 1,276.21 55.50 41510 PST DEFERRED COMPENSATION 239.19 6.99 92.06 0.00 147.13 38.48 41520 TIERED EMP DEF COMPENSATION 912.00 243.00 670.59 0.00 241.41 73.52 41530 TIERED RHS BENEFIT 852.00 228.00 637.22 0.00 214.78 74.79 41600 LONGEVITY 3,041.93 206.74 1,785.72 0.00 1,256.21 58.70 41700 ANNUAL LEAVE BUYBACK 28,000.81 0.00 28,448.99 0.00 (448.18) 101.60 41710 ANNUAL LEAVE OVER MAX 497.00 0.00 0.00 0.00 497.00 0.00 41910 PERS-NORMAL 51,385.05 2,219.76 19,882.49 0.00 31,502.56 38.69 41920 MEDICARE 15,241.38 668.33 6,628.30 0.00 8,613.08 43.48 41929 SHORT TERM DISABILITY 1,490.26 131.06 991.67 0.00 498.59 66.54 41930 LONG TERM DISABILITY 3,166.80 217.35 1,644.13 0.00 1,522.67 51.91 41931 WORKERS COMP 9,786.01 413.73 3,804.21 0.00 5,981.80 38.87 41932 STATE UNEMPLOYMENT INSURANCE 260.26 10.63 113.64 0.00 146.62 43.66 41940 HEALTH INSURANCE 90,610.86 5,445.07 38,818.93 0.00 51,791.93 42.84 41945 OPT OUT HEALTH INSURANCE 840.00 154.00 2,934.48 0.00 (2,094.48) 349.34 41946 LIFE INSURANCE 3,865.36 265.37 2,006.95 0.00 1,858.41 51.92 41951 HEALTH ALLOWANCE CREDIT 0.00 195.73 1,821.75 0.00 (1,821.75) 0.00 41996 VACANCY FACTOR (34,996.00) 0.00 0.00 0.00 (34,996.00) 0.00 41997 BUDGETARY/PAYROLL (184.52) 0.00 0.00 0.00 (184.52) 0.00 TOTAL FOR SALARIES-BENEFITS 666,504.75 33,042.01 303,966.21 0.00 362,538.54 45.60
SERVICES-SUPPLIES
JULIEK Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:24:28
User:
Report:
GL
03/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 09
Ledger:
Level:
Month to
42055 COMPUTER EQUIPMENT & 14,500.00 0.00 0.00 0.00 14,500.00 0.00 42101 SAFETY SHOES - MOU ITEM 1,068.00 0.00 161.00 0.00 907.00 15.07 42350 PROGRAM EXPENDITURES 0.00 0.00 100.00 0.00 (100.00) 0.00 43100 MEMBERSHIP & DUES 418.00 0.00 0.00 0.00 418.00 0.00 43200 CONFERENCE, TRAINING & TRAVEL 2,557.00 120.00 1,670.32 0.00 886.68 65.32 TOTAL FOR SERVICES-SUPPLIES 18,543.00 120.00 1,931.32 0.00 16,611.68 10.41 TOTAL FOR PUBLIC WORKS 685,047.75 33,162.01 305,897.53 0.00 379,150.22 44.65 51 SEWER
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 3,589,032.39 245,787.39 2,307,632.83 0.00 1,281,399.56 64.29 41101 SPECIAL ASSIGNMENT PAY 0.00 683.28 1,624.17 0.00 (1,624.17) 0.00 41102 SHIFT DIFFERENTIAL 0.00 2,764.96 24,232.13 0.00 (24,232.13) 0.00 41103 OUT OF CLASS PAY 0.00 0.00 157.74 0.00 (157.74) 0.00 41140 FINAL LEAVE 0.00 1,336.83 32,858.55 0.00 (32,858.55) 0.00 41141 SP COMP-BILINGUAL 20,212.54 2,116.59 19,010.56 0.00 1,201.98 94.05 41147 SP COMP-GRADE 4 CERT PAY 43,965.00 976.16 13,117.20 0.00 30,847.80 29.83 41148 SP COMP-GRADE 5 CERT PAY 82,241.61 8,184.52 72,407.37 0.00 9,834.24 88.04 41200 TEMPORARY EMPLOYEES 50,030.68 1,572.10 13,686.60 0.00 36,344.08 27.35 41300 OVERTIME 506,504.00 32,024.96 327,139.53 0.00 179,364.47 64.58 41320 COMP TIME 0.00 429.72 6,633.12 0.00 (6,633.12) 0.00 41400 SPECIAL DUTY PAY 50,233.00 3,728.28 37,736.41 0.00 12,496.59 75.12 41410 AUTO ALLOWANCE 4,482.00 199.38 1,896.33 0.00 2,585.67 42.30 41500 DEFERRED COMPENSATION MATCH 20,520.50 14,360.36 15,874.00 0.00 4,646.50 77.35 41510 PST DEFERRED COMPENSATION 153.40 20.45 163.21 0.00 (9.81) 106.39 41520 TIERED EMP DEF COMPENSATION 13,179.00 2,824.57 9,007.22 0.00 4,171.78 68.34 41530 TIERED RHS BENEFIT 6,331.00 1,388.52 4,505.86 0.00 1,825.14 71.17 41600 LONGEVITY 28,381.20 2,061.53 20,995.47 0.00 7,385.73 73.97 41660 TUITION REIMBURSEMENT 2,500.00 0.00 0.00 0.00 2,500.00 0.00 41700 ANNUAL LEAVE BUYBACK 113,890.94 0.00 107,003.48 0.00 6,887.46 93.95 41710 ANNUAL LEAVE OVER MAX 5,786.00 0.00 5,071.34 0.00 714.66 87.64 41910 PERS-NORMAL 412,527.01 28,617.35 273,058.88 0.00 139,468.13 66.19 41920 MEDICARE 133,104.18 9,466.85 91,072.34 0.00 42,031.84 68.42 41929 SHORT TERM DISABILITY 11,484.91 1,003.30 9,435.53 0.00 2,049.38 82.15 41930 LONG TERM DISABILITY 24,405.41 1,663.56 15,649.28 0.00 8,756.13 64.12 41931 WORKERS COMP 77,357.12 5,299.80 49,837.79 0.00 27,519.33 64.42 41932 STATE UNEMPLOYMENT INSURANCE 2,245.57 154.16 1,545.20 0.00 700.37 68.81 41940 HEALTH INSURANCE 932,376.60 49,194.85 422,154.93 0.00 510,221.67 45.27 41941 RETIREES HEALTH INSURANCE/OPEB 314,814.00 0.00 0.00 0.00 314,814.00 0.00 41945 OPT OUT HEALTH INSURANCE 2,160.00 3,826.62 68,041.54 0.00 (65,881.54) 3,150.07 41946 LIFE INSURANCE 29,788.96 2,030.26 19,106.34 0.00 10,682.62 64.13 JULIEK Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:24:28
User:
Report:
GL
03/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 09
Ledger:
Level:
Month to
41951 HEALTH ALLOWANCE CREDIT 0.00 1,608.81 20,341.69 0.00 (20,341.69) 0.00 41996 VACANCY FACTOR (275,934.00) 0.00 0.00 0.00 (275,934.00) 0.00 41997 BUDGETARY/PAYROLL 31,876.55 0.00 0.00 0.00 31,876.55 0.00 TOTAL FOR SALARIES-BENEFITS 6,233,649.57 423,325.16 3,990,996.64 0.00 2,242,652.93 64.02
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 26,426.00 17,704.69 82,801.42 11,607.87 (67,983.29) 357.25 42033 CONSTRUCTION MATERIALS 1,172,801.01 147,141.09 621,771.03 176,163.09 374,866.89 68.03 42034 SAFETY MATERIALS/CONSTRUCTION 22,175.00 2,428.06 13,921.82 0.00 8,253.18 62.78 42055 COMPUTER EQUIPMENT & 37,175.00 0.00 37,746.56 490.11 (1,061.67) 102.85 42100 UNIFORM EXPENSE 11,163.00 763.13 13,888.13 0.00 (2,725.13) 124.41 42101 SAFETY SHOES - MOU ITEM 9,234.00 0.00 7,502.59 0.00 1,731.41 81.24 42200 ADVERTISING EXPENSE 3,941.00 0.00 0.00 0.00 3,941.00 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 13,931.00 0.00 1,853.36 2,137.49 9,940.15 28.64 42300 WIRELESS COMMUNICATION 21,037.00 0.00 11,666.88 0.00 9,370.12 55.45 42310 PHONES, FAX, ISDN LINES 11,809.00 691.36 6,216.33 0.00 5,592.67 52.64 42320 POSTAGE & SHIPPING 118,956.00 10,135.23 74,408.24 11,760.14 32,787.62 72.43 42340 OFFICE SUPPLIES 10,607.00 1,407.01 4,990.89 0.00 5,616.11 47.05 42345 FIRST AID KIT SUPPLIES 220.00 50.89 94.32 0.00 125.68 42.87 42350 PROGRAM EXPENDITURES 16,121.00 1,023.09 15,068.29 0.00 1,052.71 93.46 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 864.05 0.00 (864.05) 0.00 42365 RECYCLED CONTENT PRODUCTS 0.00 29.79 34.68 0.00 (34.68) 0.00 42410 ELECTRIC UTILITY 1,734,412.00 98,080.93 1,086,482.95 0.00 647,929.05 62.64 42420 NATURAL GAS UTILITY 51,000.00 6,211.51 42,106.57 0.00 8,893.43 82.56 42430 WATER UTILITY 50,062.00 4,301.78 35,577.68 0.00 14,484.32 71.06 42435 RECYCLED WATER UTILITY 897,012.00 96,731.09 572,942.29 0.00 324,069.71 63.87 42441 UNLEADED FUEL 3,300.00 0.00 1,428.95 0.00 1,871.05 43.30 42442 DIESEL FUEL 25,000.00 0.00 21,095.61 2,910.65 993.74 96.02 42443 OTHER FUELS 60.00 0.00 0.00 0.00 60.00 0.00
42500 RENTS & LEASES 740,920.00 180,913.58 544,465.11 0.00 196,454.89 73.48 42501 CUA LEASES 1,637,405.00 409,351.25 1,228,053.75 0.00 409,351.25 75.00 42600 MOTOR POOL RENTAL 169,630.00 0.00 156,489.00 0.00 13,141.00 92.25 42605 RETAINED VEHICLE EXPENSE 26,191.00 0.00 13,877.00 0.00 12,314.00 52.98 42610 DIRECT VEHICLE EXPENSE 15,022.00 2,078.48 9,461.32 2,675.75 2,884.93 80.79 42630 PARTS/LABOR ON CITY VEHICLES 0.00 0.00 187.20 0.00 (187.20) 0.00 42700 OTHER EQUIPMENT RENTAL 43,567.48 5,590.08 120,651.76 78,326.59 (155,410.87) 456.71 42710 MILEAGE/VEHICLE EXP REIMB 525.00 0.00 0.00 0.00 525.00 0.00 42813 MTCE & REPAIR - EQUIP & FAC 1,154,071.57 70,164.71 544,839.79 300,299.62 308,932.16 73.23 42815 SCADA MAINTENANCE 318,112.75 35,002.25 200,346.61 139,274.94 (21,508.80) 106.76 42816 MOWING/LANDSCAPE CONTRACTS 93,491.00 4,615.96 53,818.46 16,532.92 23,139.62 75.24 42900 PROF. & CONT. SVCS 1,188,992.71 48,199.38 452,531.89 387,731.73 348,729.09 70.67 JULIEK Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:24:28
User:
Report:
GL
03/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 09
Ledger:
Level:
Month to
42902 CUST CREDIT CRD PROCESSING FEE 283,186.00 57,015.80 166,771.97 140,504.79 (24,090.76) 108.50 42910 REFUSE DISPOSAL 90,588.00 656.27 44,049.02 0.00 46,538.98 48.62 43000 INSURANCE & SURETY BONDS 48,566.00 0.00 49,346.48 0.00 (780.48) 101.60 43100 MEMBERSHIP & DUES 36,837.00 21,500.00 32,021.00 0.00 4,816.00 86.92 43200 CONFERENCE, TRAINING & TRAVEL 42,100.00 0.00 11,396.56 0.00 30,703.44 27.07 43400 LEGAL SERVICES-SPECIAL COUNSEL 5,000.00 0.00 0.00 0.00 5,000.00 0.00 43697 CHEMICALS-NITROGEN 11,836.00 0.00 578.28 0.00 11,257.72 4.88 43698 CHEMICALS-SODIUM BISOLFITE 66,300.00 0.00 37,678.93 28,621.07 0.00 100.00 43700 CHEMICALS-MINERAL OIL 20,000.00 0.00 355.59 9,644.41 10,000.00 50.00 43701 CHEMICALS-POLYMER 1,582,100.00 98,718.03 492,481.13 858,918.87 230,700.00 85.41 43702 CHEMICALS-ALUM 0.00 0.00 0.00 10,000.00 (10,000.00) 0.00 43707 CHEMICALS-SODIUM 2,226,546.00 160,201.42 919,842.81 464,954.33 841,748.86 62.19 43709 CHEMICALS-FERRIC CHLORIDE 114,000.00 9,005.14 62,695.64 49,304.36 2,000.00 98.24 43711 CHEMICALS-MISC 23,091.00 0.00 3,501.88 0.00 19,589.12 15.16 43713 BIOSOLIDS DISPOSAL/RECYCLE 1,800,000.00 158,100.28 933,973.70 68,667.79 797,358.51 55.70 43714 OUTSIDE LAB ANALYSIS 561,945.00 32,028.14 144,946.73 333,073.27 83,925.00 85.06 43715 REGULATORY PERMIT & USE FEES 214,713.00 10,948.02 207,305.91 0.00 7,407.09 96.55 43716 JOB REQ CERTIFICATES & LICENSE 1,950.00 0.00 8,341.44 0.00 (6,391.44) 427.76 43720 LAB CHEMICALS AND SUPPLIES 37,632.00 931.59 26,589.57 0.00 11,042.43 70.65 43722 PREVENTION & MAINTENANCE 1,276,679.00 70,974.09 540,897.03 524,536.49 211,245.48 83.45 43723 INLAND EMPIRE BRINE LINE-SARI 7,140.00 0.00 0.00 0.00 7,140.00 0.00 43728 WRCRWA CAP ASSET CONTRIBUTION 2,017,564.00 0.00 1,190,813.57 0.00 826,750.43 59.02 43729 WRCRWA TRTMNT/CONVEYANCE 2,605,347.00 157,483.93 1,179,337.57 0.00 1,426,009.43 45.26 44100 INTEREST EXPENSE 425,792.00 105,555.00 194,057.59 0.00 231,734.41 45.57 44200 BAD DEBTS EXPENSE 60,178.00 0.00 0.00 0.00 60,178.00 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 1,489,725.00 372,431.25 1,117,293.75 0.00 372,431.25 75.00 44613 INTERNAL SVC CHRG-WAREHOUSE 64,753.00 16,188.25 48,564.75 0.00 16,188.25 75.00 44614 INTERNAL SVC CHRG-INFO TECH 1,565,112.00 391,278.00 1,173,834.00 0.00 391,278.00 75.00 TOTAL FOR SERVICES-SUPPLIES 26,303,050.52 2,805,630.55 14,563,859.43 3,618,136.28 8,121,054.81 69.12
CAPITAL OUTLAY
45100 LICENSED VEHICLES 0.00 0.00 5,665.22 50,987.00 (56,652.22) 0.00 45200 MACHINERY, EQUIPMENT, & FIXTUR 0.00 127,910.79 127,910.79 389,611.44 (517,522.23) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 127,910.79 133,576.01 440,598.44 (574,174.45) 0.00 TOTAL FOR SEWER 32,536,700.09 3,356,866.50 18,688,432.08 4,058,734.72 9,789,533.29 69.91 FUN 572 66,575,945.09 3,685,021.41 20,861,457.50 10,281,910.86 35,432,576.73 46.77 JULIEK Page: 7 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:24:28
User:
Report:
GL
03/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 09
Ledger:
Level:
Month to
573 SEWER GRANT/AGRMT
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 0.00 396.71 0.00 (396.71) 0.00 41141 SP COMP-BILINGUAL 0.00 0.00 12.09 0.00 (12.09) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 0.00 2.79 0.00 (2.79) 0.00 41530 TIERED RHS BENEFIT 0.00 0.00 2.79 0.00 (2.79) 0.00 41600 LONGEVITY 0.00 0.00 1.46 0.00 (1.46) 0.00
41910 PERS-NORMAL 0.00 0.00 44.63 0.00 (44.63) 0.00
41920 MEDICARE 0.00 0.00 12.25 0.00 (12.25) 0.00
41929 SHORT TERM DISABILITY 0.00 0.00 1.41 0.00 (1.41) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 2.34 0.00 (2.34) 0.00 41931 WORKERS COMP 0.00 0.00 8.18 0.00 (8.18) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.00 0.22 0.00 (0.22) 0.00 41940 HEALTH INSURANCE 0.00 0.00 125.80 0.00 (125.80) 0.00 41946 LIFE INSURANCE 0.00 0.00 2.84 0.00 (2.84) 0.00
41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 5.71 0.00 (5.71) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 0.00 619.22 0.00 (619.22) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 202,606.53 0.00 0.00 0.00 202,606.53 0.00 42830 REBATE PROGRAMS 0.00 712.26 24,269.53 0.00 (24,269.53) 0.00 42900 PROF. & CONT. SVCS 0.00 530.88 12,295.56 308.10 (12,603.66) 0.00 43300 CONSTRUCTION CONTRACTS 0.00 0.00 121,420.25 120,879.75 (242,300.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 202,606.53 1,243.14 157,985.34 121,187.85 (76,566.66) 137.79 TOTAL FOR NOT APPLICABLE 202,606.53 1,243.14 158,604.56 121,187.85 (77,185.88) 138.09 51 SEWER
SALARIES-BENEFITS
TOTAL FOR SALARIES-BENEFITS 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FOR SEWER 0.00 0.00 0.00 0.00 0.00 0.00
FUN 573 202,606.53 1,243.14 158,604.56 121,187.85 (77,185.88) 138.09 JULIEK Page: 8 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:24:28
User:
Report:
GL
03/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 09
Ledger:
Level:
Month to
GRAND TOTAL 70,065,121.13 3,752,903.61 21,155,972.74 11,905,743.23 37,003,405.16 47.18 JULIEK Page: 9 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:24:28
User:
Report: