GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
453 2012 WATER REV REF PROJECT
00 NOT APPLICABLE
SALARIES-BENEFITS
TOTAL FOR SALARIES-BENEFITS 0.00 0.00 0.00 0.00 0.00 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 8,250.00 0.00 0.00 0.00 8,250.00 0.00 43300 CONSTRUCTION CONTRACTS 2,728,453.51 0.00 2,736,703.51 0.00 (8,250.00) 100.30 TOTAL FOR SERVICES-SUPPLIES 2,736,703.51 0.00 2,736,703.51 0.00 0.00 100.00 TOTAL FOR NOT APPLICABLE 2,736,703.51 0.00 2,736,703.51 0.00 0.00 100.00 FUN 453 2,736,703.51 0.00 2,736,703.51 0.00 0.00 100.00 JULIEK Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
507 WATER CAPACITY
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 0.00 2,335.57 0.00 (2,335.57) 0.00 41600 LONGEVITY 0.00 0.00 1.54 0.00 (1.54) 0.00
41910 PERS-NORMAL 0.00 0.00 266.21 0.00 (266.21) 0.00
41920 MEDICARE 0.00 0.00 71.24 0.00 (71.24) 0.00
41931 WORKERS COMP 0.00 0.00 46.71 0.00 (46.71) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.00 1.19 0.00 (1.19) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 0.00 2,722.46 0.00 (2,722.46) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 568,710.46 0.00 0.00 0.00 568,710.46 0.00 42815 SCADA MAINTENANCE 9,052.00 0.00 4,304.00 0.00 4,748.00 47.54 42900 PROF. & CONT. SVCS 480,709.60 0.00 17,063.00 468,200.60 (4,554.00) 100.94 43300 CONSTRUCTION CONTRACTS 319,494.78 0.00 175,754.32 143,740.46 0.00 100.00 43726 PROJECT MANAGEMENT 0.00 0.00 7,800.00 0.00 (7,800.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 1,377,966.84 0.00 204,921.32 611,941.06 561,104.46 59.28 TOTAL FOR NOT APPLICABLE 1,377,966.84 0.00 207,643.78 611,941.06 558,382.00 59.47 50 WATER UTILITY SERVICES
SERVICES-SUPPLIES
44100 INTEREST EXPENSE 490,740.00 0.00 309,214.25 0.00 181,525.75 63.00 44610 ADMINISTRATIVE SERVICES CHARGE 8,138.00 0.00 6,103.50 0.00 2,034.50 75.00 TOTAL FOR SERVICES-SUPPLIES 498,878.00 0.00 315,317.75 0.00 183,560.25 63.20 TOTAL FOR WATER UTILITY SERVICES 498,878.00 0.00 315,317.75 0.00 183,560.25 63.20 FUN 507 1,876,844.84 0.00 522,961.53 611,941.06 741,942.25 60.46 JULIEK Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
567 RECLAIMED WATER SYSTEM
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 0.00 5,711.67 0.00 (5,711.67) 0.00 41600 LONGEVITY 0.00 0.00 87.59 0.00 (87.59) 0.00
41910 PERS-NORMAL 0.00 0.00 660.51 0.00 (660.51) 0.00
41920 MEDICARE 0.00 0.00 173.02 0.00 (173.02) 0.00
41931 WORKERS COMP 0.00 0.00 114.26 0.00 (114.26) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.00 2.92 0.00 (2.92) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 0.00 6,749.97 0.00 (6,749.97) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 1,872,592.53 0.00 0.00 0.00 1,872,592.53 0.00 42033 CONSTRUCTION MATERIALS 2,346.95 0.00 99,631.46 820.52 (98,105.03) 4,280.10 42200 ADVERTISING EXPENSE 0.00 0.00 18.20 0.00 (18.20) 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 750.00 0.00 (750.00) 0.00 42815 SCADA MAINTENANCE 3,924.00 0.00 3,907.40 16.60 0.00 100.00 42900 PROF. & CONT. SVCS 18,844.48 237.50 1,320.65 18,898.80 (1,374.97) 107.29 43300 CONSTRUCTION CONTRACTS 0.00 0.00 771.09 0.00 (771.09) 0.00 43301 CAPITAL IMPROVEMENTS 21,356.48 0.00 0.00 40,000.00 (18,643.52) 187.29 43726 PROJECT MANAGEMENT 0.00 0.00 872.00 0.00 (872.00) 0.00 43727 INSPECTION 1,478.29 88.00 88.00 0.00 1,390.29 5.95 TOTAL FOR SERVICES-SUPPLIES 1,920,542.73 325.50 107,358.80 59,735.92 1,753,448.01 8.70
CAPITAL OUTLAY
45100 LICENSED VEHICLES 0.00 0.00 10,108.18 0.00 (10,108.18) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 0.00 10,108.18 0.00 (10,108.18) 0.00 TOTAL FOR NOT APPLICABLE 1,920,542.73 325.50 124,216.95 59,735.92 1,736,589.86 9.57 13 DEBT SERVICE
SALARIES-BENEFITS
41912 PERS-UNFUNDED 1,191,829.36 0.00 1,187,160.34 0.00 4,669.02 99.60 TOTAL FOR SALARIES-BENEFITS 1,191,829.36 0.00 1,187,160.34 0.00 4,669.02 99.60
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 0.00 0.00 4,669.02 0.00 (4,669.02) 0.00 44001 DS PRINCIPAL 2021 POBS 72,859.92 0.00 72,859.92 0.00 0.00 100.00 44101 DS INTEREST 2021 POBS 11,714.56 0.00 11,714.56 0.00 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 84,574.48 0.00 89,243.50 0.00 (4,669.02) 105.52 TOTAL FOR DEBT SERVICE 1,276,403.84 0.00 1,276,403.84 0.00 0.00 100.00 39 PUBLIC WORKS
SALARIES-BENEFITS
JULIEK Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41100 PERMANENT EMPLOYEES 6,505.29 928.67 5,360.12 0.00 1,145.17 82.39 41500 DEFERRED COMPENSATION MATCH 114.00 0.00 0.00 0.00 114.00 0.00 41520 TIERED EMP DEF COMPENSATION 36.00 9.00 36.00 0.00 0.00 100.00 41530 TIERED RHS BENEFIT 36.00 9.00 36.00 0.00 0.00 100.00 41600 LONGEVITY 96.00 7.38 143.03 0.00 (47.03) 148.98
41630 ONE TIME MOU PAYMENTS 126.91 0.00 126.91 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 480.84 0.00 480.85 0.00 (0.01) 100.00 41910 PERS-NORMAL 751.66 106.62 626.83 0.00 124.83 83.39 41912 PERS-UNFUNDED 495.21 0.00 495.21 0.00 0.00 100.00 41920 MEDICARE 222.98 28.06 179.13 0.00 43.85 80.33
41929 SHORT TERM DISABILITY 21.30 3.40 22.35 0.00 (1.05) 104.92 41930 LONG TERM DISABILITY 44.15 6.32 46.60 0.00 (2.45) 105.54 41931 WORKERS COMP 129.91 18.58 104.68 0.00 25.23 80.57 41932 STATE UNEMPLOYMENT INSURANCE 3.52 0.48 3.01 0.00 0.51 85.51 41940 HEALTH INSURANCE 1,304.55 110.40 1,226.82 0.00 77.73 94.04 41946 LIFE INSURANCE 53.67 7.70 56.78 0.00 (3.11) 105.79 41951 HEALTH ALLOWANCE CREDIT 0.00 10.62 63.71 0.00 (63.71) 0.00 41996 VACANCY FACTOR (320.00) 0.00 0.00 0.00 (320.00) 0.00 TOTAL FOR SALARIES-BENEFITS 10,101.99 1,246.23 9,008.03 0.00 1,093.96 89.17
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 21.50 0.00 0.00 0.00 21.50 0.00 TOTAL FOR SERVICES-SUPPLIES 21.50 0.00 0.00 0.00 21.50 0.00 TOTAL FOR PUBLIC WORKS 10,123.49 1,246.23 9,008.03 0.00 1,115.46 88.98 53 RECLAIMED WATER
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 275,458.80 19,209.09 241,172.78 0.00 34,286.02 87.55 41102 SHIFT DIFFERENTIAL 0.00 0.00 224.66 0.00 (224.66) 0.00 41103 OUT OF CLASS PAY 0.00 53.52 370.24 0.00 (370.24) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 69.10 0.00 (69.10) 0.00 41140 FINAL LEAVE 0.00 0.00 4,277.72 0.00 (4,277.72) 0.00 41141 SP COMP-BILINGUAL 0.00 87.96 87.96 0.00 (87.96) 0.00 41147 SP COMP-GRADE 4 CERT PAY 0.00 0.00 32.37 0.00 (32.37) 0.00 41148 SP COMP-GRADE 5 CERT PAY 184.00 0.00 0.00 0.00 184.00 0.00 41300 OVERTIME 8,564.00 290.10 3,757.66 0.00 4,806.34 43.87 41400 SPECIAL DUTY PAY 2,168.00 371.27 3,629.42 0.00 (1,461.42) 167.40 41410 AUTO ALLOWANCE 912.00 44.30 556.91 0.00 355.09 61.06 41500 DEFERRED COMPENSATION MATCH 2,130.00 506.32 1,641.91 0.00 488.09 77.08 41520 TIERED EMP DEF COMPENSATION 900.00 187.50 821.25 0.00 78.75 91.25 41530 TIERED RHS BENEFIT 640.00 147.50 611.25 0.00 28.75 95.50 JULIEK Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41600 LONGEVITY 2,375.97 178.14 3,726.32 0.00 (1,350.35) 156.83 41630 ONE TIME MOU PAYMENTS 4,697.82 0.00 4,697.82 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 2,873.50 0.00 2,727.20 0.00 146.30 94.90 41710 ANNUAL LEAVE OVER MAX 1,605.00 0.00 3,703.82 0.00 (2,098.82) 230.76 41910 PERS-NORMAL 31,687.42 2,232.19 28,010.94 0.00 3,676.48 88.39 41912 PERS-UNFUNDED 21,400.89 0.00 21,400.89 0.00 0.00 100.00 41920 MEDICARE 9,305.79 633.08 8,151.88 0.00 1,153.91 87.60 41929 SHORT TERM DISABILITY 880.94 71.17 779.35 0.00 101.59 88.46 41930 LONG TERM DISABILITY 1,873.33 132.65 1,631.92 0.00 241.41 87.11 41931 WORKERS COMP 5,622.87 395.22 4,878.58 0.00 744.29 86.76 41932 STATE UNEMPLOYMENT INSURANCE 152.67 10.53 138.05 0.00 14.62 90.42 41940 HEALTH INSURANCE 33,450.25 2,651.06 30,935.55 0.00 2,514.70 92.48 41941 RETIREES HEALTH INSURANCE/OPEB 40,506.00 23,915.92 47,831.80 0.00 (7,325.80) 118.08 41945 OPT OUT HEALTH INSURANCE 9,964.00 540.00 9,763.01 0.00 200.99 97.98 41946 LIFE INSURANCE 2,284.44 161.91 1,991.79 0.00 292.65 87.18 41951 HEALTH ALLOWANCE CREDIT 0.00 136.49 870.48 0.00 (870.48) 0.00 41996 VACANCY FACTOR (29,716.00) 0.00 0.00 0.00 (29,716.00) 0.00 41997 BUDGETARY/PAYROLL (6,535.00) 0.00 0.00 0.00 (6,535.00) 0.00 TOTAL FOR SALARIES-BENEFITS 423,386.69 51,955.92 428,492.63 0.00 (5,105.94) 101.20
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 515.12 0.00 2.97 0.00 512.15 0.57 42033 CONSTRUCTION MATERIALS 137,194.26 337.13 43,499.95 39,703.32 53,990.99 60.64 42034 SAFETY MATERIALS/CONSTRUCTION 5.80 0.00 0.00 0.00 5.80 0.00 42055 COMPUTER EQUIPMENT & 209.00 10.86 140.27 0.03 68.70 67.12 42101 SAFETY SHOES - MOU ITEM 444.00 0.00 0.00 0.00 444.00 0.00 42200 ADVERTISING EXPENSE 15.00 0.00 48.57 0.00 (33.57) 323.80 42300 WIRELESS COMMUNICATION 770.40 0.00 565.08 0.00 205.32 73.34 42320 POSTAGE & SHIPPING 670.00 0.00 3.79 0.00 666.21 0.56 42340 OFFICE SUPPLIES 240.00 13.42 129.08 0.00 110.92 53.78 42350 PROGRAM EXPENDITURES 329.78 0.32 99.55 50.00 180.23 45.34 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 0.84 0.00 (0.84) 0.00 42410 ELECTRIC UTILITY 697,680.00 57,474.48 590,264.14 0.00 107,415.86 84.60 42442 DIESEL FUEL 5,000.00 0.00 0.00 5,000.00 0.00 100.00 42600 MOTOR POOL RENTAL 4,706.26 0.00 4,220.26 0.00 486.00 89.67 42605 RETAINED VEHICLE EXPENSE 698.88 0.00 698.88 0.00 0.00 100.00 42700 OTHER EQUIPMENT RENTAL 1,020.00 0.00 0.00 760.00 260.00 74.50 42710 MILEAGE/VEHICLE EXP REIMB 50.00 0.00 0.00 0.00 50.00 0.00 42813 MTCE & REPAIR - EQUIP & FAC 205,422.00 24,068.46 41,352.57 72,813.51 91,255.92 55.57 42815 SCADA MAINTENANCE 71,815.00 7,380.33 26,111.40 38,695.08 7,008.52 90.24 42816 MOWING/LANDSCAPE CONTRACTS 2,962.80 0.00 2,468.90 0.00 493.90 83.32 JULIEK Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
42900 PROF. & CONT. SVCS 442,817.87 61,092.86 384,427.25 41,280.91 17,109.71 96.13 43000 INSURANCE & SURETY BONDS 2,451.00 0.00 5,893.92 0.00 (3,442.92) 240.47 43100 MEMBERSHIP & DUES 6,120.00 0.00 6,195.00 0.00 (75.00) 101.22 43200 CONFERENCE, TRAINING & TRAVEL 60.00 0.00 0.20 0.00 59.80 0.33 43715 REGULATORY PERMIT & USE FEES 55.00 0.00 0.00 0.00 55.00 0.00 43722 PREVENTION & MAINTENANCE 112,133.74 10,098.20 33,054.25 43,077.35 36,002.14 67.89 43726 PROJECT MANAGEMENT 0.00 72.00 193.80 0.00 (193.80) 0.00 44100 INTEREST EXPENSE 386,063.00 0.00 162,525.25 0.00 223,537.75 42.09 44200 BAD DEBTS EXPENSE 8,554.00 0.00 0.00 0.00 8,554.00 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 155,181.00 0.00 116,385.75 0.00 38,795.25 75.00 44613 INTERNAL SVC CHRG-WAREHOUSE 3,162.00 0.00 2,371.50 0.00 790.50 75.00 44614 INTERNAL SVC CHRG-INFO TECH 46,344.00 0.00 34,758.00 0.00 11,586.00 75.00 TOTAL FOR SERVICES-SUPPLIES 2,292,689.91 160,548.06 1,455,411.17 241,380.20 595,898.54 74.00
CAPITAL OUTLAY
TOTAL FOR CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00
TOTAL FOR RECLAIMED WATER 2,716,076.60 212,503.98 1,883,903.80 241,380.20 590,792.60 78.24 FUN 567 5,923,146.66 214,075.71 3,293,532.62 301,116.12 2,328,497.92 60.68 JULIEK Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
570 WATER UTILITY
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 4,352.73 83,483.68 0.00 (83,483.68) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 206.42 0.00 (206.42) 0.00 41141 SP COMP-BILINGUAL 0.00 75.89 463.83 0.00 (463.83) 0.00 41147 SP COMP-GRADE 4 CERT PAY 0.00 0.00 115.39 0.00 (115.39) 0.00 41300 OVERTIME 0.00 580.97 2,502.55 0.00 (2,502.55) 0.00 41600 LONGEVITY 0.00 5.72 304.05 0.00 (304.05) 0.00
41910 PERS-NORMAL 0.00 505.06 9,609.24 0.00 (9,609.24) 0.00 41920 MEDICARE 0.00 148.15 2,596.45 0.00 (2,596.45) 0.00 41929 SHORT TERM DISABILITY 0.00 0.00 1.15 0.00 (1.15) 0.00 41931 WORKERS COMP 0.00 88.56 1,682.70 0.00 (1,682.70) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 2.58 44.27 0.00 (44.27) 0.00 41945 OPT OUT HEALTH INSURANCE 0.00 0.00 53.61 0.00 (53.61) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 5,759.66 101,063.34 0.00 (101,063.34) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 24,290,164.77 0.00 0.00 0.00 24,290,164.77 0.00 42020 MINOR EQUIPMENT & FURNITURE 0.00 0.00 62.42 0.00 (62.42) 0.00 42033 CONSTRUCTION MATERIALS 64,670.86 192,438.56 1,174,894.85 175,631.54 (1,285,855.53) 2,088.30 42200 ADVERTISING EXPENSE 0.00 0.00 2,769.74 0.00 (2,769.74) 0.00 42320 POSTAGE & SHIPPING 0.00 0.08 7.41 0.00 (7.41) 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 151.79 0.00 (151.79) 0.00 42800 EQUIPMENT MAINTENANCE 10,129.44 0.00 0.00 10,129.44 0.00 100.00 42815 SCADA MAINTENANCE 170,974.44 38,033.20 266,157.83 117,241.79 (212,425.18) 224.24 42830 REBATE PROGRAMS 0.00 0.00 11,995.00 0.00 (11,995.00) 0.00 42900 PROF. & CONT. SVCS 712,589.99 275,503.88 919,951.12 912,096.52 (1,119,457.65) 257.09 43300 CONSTRUCTION CONTRACTS 3,402,892.82 401,208.00 2,436,602.41 1,653,844.19 (687,553.78) 120.20 43301 CAPITAL IMPROVEMENTS 256,144.18 73,694.38 458,612.42 221,095.61 (423,563.85) 265.36 43724 OUTSIDE SERVICES - LABOR 12,912.00 783.00 2,697.00 12,912.00 (2,697.00) 120.88 43726 PROJECT MANAGEMENT 289,156.54 28,130.00 468,227.95 74,372.59 (253,444.00) 187.64 43727 INSPECTION 1,750.64 116.00 376.00 1,456.00 (81.36) 104.64 TOTAL FOR SERVICES-SUPPLIES 29,211,385.68 1,009,907.10 5,742,505.94 3,178,779.68 20,290,100.06 30.54
CAPITAL OUTLAY
45100 LICENSED VEHICLES 147,372.21 0.00 218,479.18 168,973.00 (240,079.97) 262.90 45200 MACHINERY, EQUIPMENT, & FIXTUR 636,981.75 0.00 633,529.74 59,927.76 (56,475.75) 108.86 TOTAL FOR CAPITAL OUTLAY 784,353.96 0.00 852,008.92 228,900.76 (296,555.72) 137.80 TOTAL FOR NOT APPLICABLE 29,995,739.64 1,015,666.76 6,695,578.20 3,407,680.44 19,892,481.00 33.68 13 DEBT SERVICE
SALARIES-BENEFITS
JULIEK Page: 7 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41912 PERS-UNFUNDED 20,639,823.53 0.00 20,558,979.43 0.00 80,844.10 99.60 TOTAL FOR SALARIES-BENEFITS 20,639,823.53 0.00 20,558,979.43 0.00 80,844.10 99.60
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 0.00 0.00 80,844.10 0.00 (80,844.10) 0.00 44001 DS PRINCIPAL 2021 POBS 1,261,768.53 0.00 1,261,768.53 0.00 0.00 100.00 44101 DS INTEREST 2021 POBS 202,869.65 0.00 202,869.65 0.00 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 1,464,638.18 0.00 1,545,482.28 0.00 (80,844.10) 105.51 TOTAL FOR DEBT SERVICE 22,104,461.71 0.00 22,104,461.71 0.00 0.00 100.00 18 ADMIN SERVICES-FINANCE
SALARIES-BENEFITS
41912 PERS-UNFUNDED 1,553.28 0.00 1,553.28 0.00 0.00 100.00 TOTAL FOR SALARIES-BENEFITS 1,553.28 0.00 1,553.28 0.00 0.00 100.00 TOTAL FOR ADMIN SERVICES-FINANCE 1,553.28 0.00 1,553.28 0.00 0.00 100.00 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 500,105.94 25,320.66 284,647.04 0.00 215,458.90 56.91 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 22.33 0.00 (22.33) 0.00 41103 OUT OF CLASS PAY 0.00 93.88 458.71 0.00 (458.71) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 286.20 0.00 (286.20) 0.00 41140 FINAL LEAVE 0.00 8,572.34 26,136.33 0.00 (26,136.33) 0.00 41141 SP COMP-BILINGUAL 691.74 114.22 611.19 0.00 80.55 88.35 41200 TEMPORARY EMPLOYEES 29,432.97 2,721.72 20,057.09 0.00 9,375.88 68.14 41300 OVERTIME 402.00 206.41 2,130.86 0.00 (1,728.86) 530.06 41400 SPECIAL DUTY PAY 3,950.00 135.96 3,678.55 0.00 271.45 93.12 41410 AUTO ALLOWANCE 1,152.00 88.62 1,117.24 0.00 34.76 96.98 41500 DEFERRED COMPENSATION MATCH 3,694.00 665.00 2,380.82 0.00 1,313.18 64.45 41510 PST DEFERRED COMPENSATION 381.82 35.39 260.74 0.00 121.08 68.28 41520 TIERED EMP DEF COMPENSATION 1,448.00 298.50 1,318.06 0.00 129.94 91.02 41530 TIERED RHS BENEFIT 1,117.00 233.50 1,034.35 0.00 82.65 92.60 41600 LONGEVITY 3,413.12 192.12 4,707.40 0.00 (1,294.28) 137.92 41630 ONE TIME MOU PAYMENTS 7,779.24 0.00 7,779.24 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 11,313.58 0.00 11,289.63 0.00 23.95 99.78 41710 ANNUAL LEAVE OVER MAX 1,514.00 0.00 451.73 0.00 1,062.27 29.83 41910 PERS-NORMAL 57,430.46 2,922.12 33,039.08 0.00 24,391.38 57.52 41912 PERS-UNFUNDED 38,054.70 0.00 38,054.70 0.00 0.00 100.00 41920 MEDICARE 16,653.23 1,108.93 10,590.43 0.00 6,062.80 63.59 41929 SHORT TERM DISABILITY 1,601.14 132.84 1,342.37 0.00 258.77 83.83 41930 LONG TERM DISABILITY 3,402.06 247.36 2,872.70 0.00 529.36 84.44 41931 WORKERS COMP 10,618.11 567.08 6,019.16 0.00 4,598.95 56.68 JULIEK Page: 8 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41932 STATE UNEMPLOYMENT INSURANCE 280.25 19.25 184.39 0.00 95.86 65.79 41940 HEALTH INSURANCE 71,973.01 4,343.17 55,606.84 0.00 16,366.17 77.26 41945 OPT OUT HEALTH INSURANCE 4,970.00 544.00 8,897.88 0.00 (3,927.88) 179.03 41946 LIFE INSURANCE 4,151.45 302.00 3,506.70 0.00 644.75 84.46 41951 HEALTH ALLOWANCE CREDIT 0.00 257.33 1,415.00 0.00 (1,415.00) 0.00 41996 VACANCY FACTOR (23,680.00) 0.00 0.00 0.00 (23,680.00) 0.00 41997 BUDGETARY/PAYROLL (3,715.00) 0.00 0.00 0.00 (3,715.00) 0.00 TOTAL FOR SALARIES-BENEFITS 748,134.82 49,122.40 529,896.76 0.00 218,238.06 70.82
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 0.00 0.00 164.38 0.00 (164.38) 0.00 42055 COMPUTER EQUIPMENT & 34,396.61 0.00 6,352.69 6,115.61 21,928.31 36.24 42101 SAFETY SHOES - MOU ITEM 1,631.06 0.00 0.00 0.00 1,631.06 0.00 42200 ADVERTISING EXPENSE 600.00 406.06 406.06 0.00 193.94 67.67 42300 WIRELESS COMMUNICATION 1,000.00 0.00 1,630.45 0.00 (630.45) 163.04 42320 POSTAGE & SHIPPING 20.00 0.00 15.71 0.00 4.29 78.55 42340 OFFICE SUPPLIES 200.00 0.00 0.00 0.00 200.00 0.00 42350 PROGRAM EXPENDITURES 200.00 0.00 0.00 0.00 200.00 0.00 42900 PROF. & CONT. SVCS 0.00 33.00 33.00 0.00 (33.00) 0.00 43100 MEMBERSHIP & DUES 7,568.00 0.00 266.00 0.00 7,302.00 3.51 43200 CONFERENCE, TRAINING & TRAVEL 0.00 0.00 865.03 0.00 (865.03) 0.00 TOTAL FOR SERVICES-SUPPLIES 45,615.67 439.06 9,733.32 6,115.61 29,766.74 34.74 TOTAL FOR PUBLIC WORKS 793,750.49 49,561.46 539,630.08 6,115.61 248,004.80 68.75 50 WATER UTILITY SERVICES
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 4,434,450.73 274,937.93 3,318,001.53 0.00 1,116,449.20 74.82 41101 SPECIAL ASSIGNMENT PAY 0.00 1,892.32 5,007.71 0.00 (5,007.71) 0.00 41102 SHIFT DIFFERENTIAL 50,000.00 2,446.17 43,991.63 0.00 6,008.37 87.98 41103 OUT OF CLASS PAY 0.00 663.14 7,334.04 0.00 (7,334.04) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 23,712.99 0.00 (23,712.99) 0.00 41140 FINAL LEAVE 0.00 1,738.67 64,948.02 0.00 (64,948.02) 0.00 41141 SP COMP-BILINGUAL 18,127.20 1,355.57 15,290.00 0.00 2,837.20 84.34 41147 SP COMP-GRADE 4 CERT PAY 79,963.00 3,923.10 60,710.33 0.00 19,252.67 75.92 41148 SP COMP-GRADE 5 CERT PAY 65,581.00 6,876.58 56,729.81 0.00 8,851.19 86.50 41200 TEMPORARY EMPLOYEES 33,475.61 700.05 9,904.74 0.00 23,570.87 29.58 41300 OVERTIME 541,872.00 46,775.07 483,352.25 0.00 58,519.75 89.20 41320 COMP TIME 0.00 1,023.00 22,506.94 0.00 (22,506.94) 0.00 41400 SPECIAL DUTY PAY 83,100.00 6,528.50 82,140.21 0.00 959.79 98.84 41410 AUTO ALLOWANCE 2,034.00 88.62 1,114.08 0.00 919.92 54.77 41500 DEFERRED COMPENSATION MATCH 24,536.00 4,463.67 24,502.73 0.00 33.27 99.86 JULIEK Page: 9 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41510 PST DEFERRED COMPENSATION 124.83 9.09 16.20 0.00 108.63 12.97 41520 TIERED EMP DEF COMPENSATION 18,600.00 3,811.51 16,985.60 0.00 1,614.40 91.32 41530 TIERED RHS BENEFIT 8,572.00 1,979.50 8,246.23 0.00 325.77 96.19 41600 LONGEVITY 28,852.72 2,013.60 47,473.65 0.00 (18,620.93) 164.53 41630 ONE TIME MOU PAYMENTS 67,269.31 0.00 67,269.31 0.00 0.00 100.00 41660 TUITION REIMBURSEMENT 0.00 0.00 250.00 0.00 (250.00) 0.00 41700 ANNUAL LEAVE BUYBACK 56,660.43 0.00 55,611.36 0.00 1,049.07 98.14 41710 ANNUAL LEAVE OVER MAX 18,528.00 0.00 10,072.43 0.00 8,455.57 54.36 41910 PERS-NORMAL 530,688.73 34,157.13 412,589.20 0.00 118,099.53 77.74 41912 PERS-UNFUNDED 339,585.12 0.00 339,585.12 0.00 0.00 100.00 41920 MEDICARE 168,635.20 10,787.44 133,326.29 0.00 35,308.91 79.06 41929 SHORT TERM DISABILITY 14,190.80 1,000.63 10,790.50 0.00 3,400.30 76.03 41930 LONG TERM DISABILITY 30,155.24 1,863.37 22,659.37 0.00 7,495.87 75.14 41931 WORKERS COMP 94,546.95 5,954.86 70,168.84 0.00 24,378.11 74.21 41932 STATE UNEMPLOYMENT INSURANCE 2,802.68 179.91 2,263.39 0.00 539.29 80.75 41940 HEALTH INSURANCE 819,052.54 55,797.90 623,112.49 0.00 195,940.05 76.07 41941 RETIREES HEALTH INSURANCE/OPEB 701,471.00 414,099.50 828,196.49 0.00 (126,725.49) 118.06 41945 OPT OUT HEALTH INSURANCE 150,986.00 7,504.00 149,697.38 0.00 1,288.62 99.14 41946 LIFE INSURANCE 36,807.50 2,274.36 27,657.00 0.00 9,150.50 75.13 41951 HEALTH ALLOWANCE CREDIT 0.00 2,224.81 12,844.61 0.00 (12,844.61) 0.00 41996 VACANCY FACTOR (498,054.00) 0.00 0.00 0.00 (498,054.00) 0.00 41997 BUDGETARY/PAYROLL (82,733.00) 0.00 0.00 0.00 (82,733.00) 0.00 TOTAL FOR SALARIES-BENEFITS 7,839,881.59 897,070.00 7,058,062.47 0.00 781,819.12 90.02
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 85,199.83 6,751.25 105,960.61 27,451.53 (48,212.31) 156.58 42033 CONSTRUCTION MATERIALS 1,060,288.38 37,843.84 1,015,208.38 187,159.65 (142,079.65) 113.40 42034 SAFETY MATERIALS/CONSTRUCTION 25,590.00 2,755.94 40,205.90 3,600.00 (18,215.90) 171.18 42055 COMPUTER EQUIPMENT & 29,756.01 543.18 37,289.94 485.26 (8,019.19) 126.94 42100 UNIFORM EXPENSE 23,642.66 1,531.06 17,150.93 0.00 6,491.73 72.54 42101 SAFETY SHOES - MOU ITEM 10,350.75 0.00 0.00 0.00 10,350.75 0.00 42200 ADVERTISING EXPENSE 2,767.20 0.00 2,181.60 0.00 585.60 78.83 42220 PROMOTIONAL/PUBLIC OUTREACH 38,878.75 1,858.89 7,631.07 2,330.55 28,917.13 25.62 42300 WIRELESS COMMUNICATION 54,392.05 708.34 36,297.10 0.00 18,094.95 66.73 42310 PHONES, FAX, ISDN LINES 12,103.00 1,236.38 11,195.07 0.00 907.93 92.49 42320 POSTAGE & SHIPPING 146,197.65 17,988.18 103,690.17 3,851.28 38,656.20 73.55 42340 OFFICE SUPPLIES 12,751.55 786.09 8,164.84 0.00 4,586.71 64.03 42345 FIRST AID KIT SUPPLIES 280.00 0.00 208.55 0.00 71.45 74.48 42350 PROGRAM EXPENDITURES 27,273.74 1,839.37 23,614.63 3,060.00 599.11 97.80 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 1,195.53 0.00 (1,195.53) 0.00 42410 ELECTRIC UTILITY 4,429,000.00 451,048.86 4,994,638.97 0.00 (565,638.97) 112.77 JULIEK Page: 10 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
42420 NATURAL GAS UTILITY 1,040.40 43.53 1,371.55 0.00 (331.15) 131.82 42430 WATER UTILITY 53,060.40 2,775.91 53,745.63 0.00 (685.23) 101.29 42435 RECYCLED WATER UTILITY 13,292.64 337.07 14,353.90 0.00 (1,061.26) 107.98 42441 UNLEADED FUEL 6,360.00 1,033.48 7,097.21 0.00 (737.21) 111.59 42442 DIESEL FUEL 11,640.00 473.07 3,591.27 9,594.39 (1,545.66) 113.27 42443 OTHER FUELS 250.00 0.00 0.00 0.00 250.00 0.00
42500 RENTS & LEASES 765,715.00 0.00 575,916.74 0.00 189,798.26 75.21 42501 CUA LEASES 2,571,803.00 0.00 1,928,852.25 0.00 642,950.75 75.00 42600 MOTOR POOL RENTAL 230,116.35 0.00 207,559.35 0.00 22,557.00 90.19 42605 RETAINED VEHICLE EXPENSE 6,365.80 0.00 6,365.80 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 22,560.00 699.45 8,716.49 16,159.78 (2,316.27) 110.26 42700 OTHER EQUIPMENT RENTAL 50,256.62 2,310.43 20,950.71 7,222.33 22,083.58 56.05 42710 MILEAGE/VEHICLE EXP REIMB 1,515.00 0.00 451.65 0.00 1,063.35 29.81 42813 MTCE & REPAIR - EQUIP & FAC 940,460.63 58,283.21 354,493.69 268,432.14 317,534.80 66.23 42815 SCADA MAINTENANCE 269,887.50 50,503.80 276,533.55 70,478.07 (77,124.12) 128.57 42816 MOWING/LANDSCAPE CONTRACTS 127,705.36 1,250.00 92,024.19 24,030.00 11,651.17 90.87 42821 TREE MAINTENANCE 0.00 0.00 890.40 0.00 (890.40) 0.00 42830 REBATE PROGRAMS 25,000.00 390.00 7,126.58 0.00 17,873.42 28.50 42900 PROF. & CONT. SVCS 2,553,001.50 398,290.72 1,977,593.20 492,694.66 82,713.64 96.76 42902 CUST CREDIT CRD PROCESSING FEE 230,710.60 46,285.81 220,194.10 210,007.34 (199,490.84) 186.46 43000 INSURANCE & SURETY BONDS 19,604.00 0.00 47,151.39 0.00 (27,547.39) 240.51 43100 MEMBERSHIP & DUES 213,845.82 15,000.00 153,079.23 15,000.00 45,766.59 78.59 43200 CONFERENCE, TRAINING & TRAVEL 44,380.00 0.00 8,538.71 0.00 35,841.29 19.23 43300 CONSTRUCTION CONTRACTS 0.00 0.00 10,193.33 0.00 (10,193.33) 0.00 43400 LEGAL SERVICES-SPECIAL COUNSEL 42,500.00 0.00 0.00 0.00 42,500.00 0.00 43502 SCHOOL PROGRAMS 29,480.00 0.00 0.00 0.00 29,480.00 0.00 43699 CHEMICALS-CORRSN & SCALE INHIB 158,373.60 0.00 60,268.75 120,619.00 (22,514.15) 114.21 43701 CHEMICALS-POLYMER 108,900.00 24,798.92 88,436.70 38,763.30 (18,300.00) 116.80 43702 CHEMICALS-ALUM 89,232.00 15,650.28 65,889.73 17,110.27 6,232.00 93.01 43703 CHEMICALS-AMMONIA 49,516.92 0.00 40,883.24 1,116.76 7,516.92 84.81 43704 CHEMICALS-ANTISCALANT 207,054.72 31,353.71 122,857.87 27,142.13 57,054.72 72.44 43705 CHEMICALS-SULFURIC ACID 171,600.00 32,701.72 188,078.85 10,600.28 (27,079.13) 115.78 43706 CHEMICALS-CAUSTIC SODA 40,700.00 6,674.47 15,769.33 24,230.67 700.00 98.28 43707 CHEMICALS-SODIUM 202,400.00 39,521.62 237,468.77 65,190.99 (100,259.76) 149.53 43711 CHEMICALS-MISC 79,054.56 45,455.05 74,757.80 5,242.20 (945.44) 101.19 43714 OUTSIDE LAB ANALYSIS 356,340.00 34,707.40 237,541.03 64,763.97 54,035.00 84.83 43715 REGULATORY PERMIT & USE FEES 142,411.00 3,172.05 140,244.70 0.00 2,166.30 98.47 43716 JOB REQ CERTIFICATES & LICENSE 2,410.00 175.00 2,191.70 0.00 218.30 90.94 43717 RAW WATER PURCHASES 14,004,702.00 1,877,019.95 14,257,792.76 0.00 (253,090.76) 101.80 43718 TREATED WATER PURCHASES 3,043,045.00 39,779.50 542,485.13 0.00 2,500,559.87 17.82 JULIEK Page: 11 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
43720 LAB CHEMICALS AND SUPPLIES 44,184.00 4,742.89 45,498.88 23,533.19 (24,848.07) 156.23 43722 PREVENTION & MAINTENANCE 1,763,006.70 161,097.54 1,111,676.14 336,189.97 315,140.59 82.12 43723 INLAND EMPIRE BRINE LINE-SARI 1,877,058.42 171,929.55 1,364,497.55 0.00 512,560.87 72.69 43726 PROJECT MANAGEMENT 0.00 15,409.00 24,804.00 0.00 (24,804.00) 0.00 43727 INSPECTION 0.00 1,960.00 1,960.00 0.00 (1,960.00) 0.00 43731 CARBON DIOXIDE 29,474.53 3,397.50 25,454.11 16,545.89 (12,525.47) 142.49 44100 INTEREST EXPENSE 715,914.00 0.00 417,623.23 0.00 298,290.77 58.33 44200 BAD DEBTS EXPENSE 913,467.00 0.00 0.00 0.00 913,467.00 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 2,664,718.00 0.00 1,998,538.50 0.00 666,179.50 75.00 44613 INTERNAL SVC CHRG-WAREHOUSE 268,485.00 0.00 201,363.75 0.00 67,121.25 75.00 44614 INTERNAL SVC CHRG-INFO TECH 1,961,892.00 0.00 1,471,419.00 0.00 490,473.00 75.00 TOTAL FOR SERVICES-SUPPLIES 43,082,961.64 3,612,114.01 35,118,925.73 2,092,605.60 5,871,430.31 86.37
CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 102,271.82 0.00 113,578.59 58,524.25 (69,831.02) 168.27 TOTAL FOR CAPITAL OUTLAY 102,271.82 0.00 113,578.59 58,524.25 (69,831.02) 168.27 TOTAL FOR WATER UTILITY SERVICES 51,025,115.05 4,509,184.01 42,290,566.79 2,151,129.85 6,583,418.41 87.09 FUN 570 103,920,620.17 5,574,412.23 71,631,790.06 5,564,925.90 26,723,904.21 74.28 JULIEK Page: 12 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
571 WATER UTILITY GRANT/AGREEMENT
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 88.04 7,579.68 0.00 (7,579.68) 0.00 41141 SP COMP-BILINGUAL 0.00 0.46 0.46 0.00 (0.46) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 0.00 15.00 0.00 (15.00) 0.00 41530 TIERED RHS BENEFIT 0.00 0.00 15.00 0.00 (15.00) 0.00 41600 LONGEVITY 0.00 0.00 116.87 0.00 (116.87) 0.00
41910 PERS-NORMAL 0.00 10.07 876.67 0.00 (876.67) 0.00
41920 MEDICARE 0.00 2.64 228.21 0.00 (228.21) 0.00
41929 SHORT TERM DISABILITY 0.00 0.00 2.12 0.00 (2.12) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 4.51 0.00 (4.51) 0.00 41931 WORKERS COMP 0.00 1.77 153.25 0.00 (153.25) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.04 3.92 0.00 (3.92) 0.00 41940 HEALTH INSURANCE 0.00 0.00 30.15 0.00 (30.15) 0.00 41946 LIFE INSURANCE 0.00 0.00 5.50 0.00 (5.50) 0.00
TOTAL FOR SALARIES-BENEFITS 0.00 103.02 9,031.34 0.00 (9,031.34) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 4,885,808.43 0.00 0.00 0.00 4,885,808.43 0.00 42033 CONSTRUCTION MATERIALS 0.00 4,891.25 4,891.25 0.00 (4,891.25) 0.00 42200 ADVERTISING EXPENSE 0.00 0.00 344.38 0.00 (344.38) 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 0.00 1,364.11 1,364.11 0.00 (1,364.11) 0.00 42320 POSTAGE & SHIPPING 0.00 186.55 1,177.51 0.00 (1,177.51) 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 250.00 0.00 (250.00) 0.00 42830 REBATE PROGRAMS 0.00 0.00 1,653,542.40 0.00 (1,653,542.40) 0.00 42900 PROF. & CONT. SVCS 28,938.30 44,980.00 234,308.39 27,656.74 (233,026.83) 905.25 42902 CUST CREDIT CRD PROCESSING FEE 0.00 0.00 25,000.00 0.00 (25,000.00) 0.00 43300 CONSTRUCTION CONTRACTS 0.00 36,726.89 36,726.89 0.00 (36,726.89) 0.00 TOTAL FOR SERVICES-SUPPLIES 4,914,746.73 88,148.80 1,957,604.93 27,656.74 2,929,485.06 40.39 TOTAL FOR NOT APPLICABLE 4,914,746.73 88,251.82 1,966,636.27 27,656.74 2,920,453.72 40.57 50 WATER UTILITY SERVICES
SALARIES-BENEFITS
TOTAL FOR SALARIES-BENEFITS 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FOR WATER UTILITY SERVICES 0.00 0.00 0.00 0.00 0.00 0.00 FUN 571 4,914,746.73 88,251.82 1,966,636.27 27,656.74 2,920,453.72 40.57 JULIEK Page: 13 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
GRAND TOTAL 119,372,061.91 5,876,739.76 80,151,623.99 6,505,639.82 32,714,798.10 72.59 JULIEK Page: 14 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:47:34
User:
Report: