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
453 2012 WATER REV REF PROJECT
00 NOT APPLICABLE
SERVICES-SUPPLIES
TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FOR NOT APPLICABLE 0.00 0.00 0.00 0.00 0.00 0.00
FUN 453 0.00 0.00 0.00 0.00 0.00 0.00
JULIEK Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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
507 WATER CAPACITY
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 747.63 1,037.52 0.00 (1,037.52) 0.00 41600 LONGEVITY 0.00 0.00 0.81 0.00 (0.81) 0.00
41910 PERS-NORMAL 0.00 81.34 112.97 0.00 (112.97) 0.00
41920 MEDICARE 0.00 22.32 30.98 0.00 (30.98) 0.00
41929 SHORT TERM DISABILITY 0.00 0.00 0.45 0.00 (0.45) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 0.75 0.00 (0.75) 0.00 41931 WORKERS COMP 0.00 14.96 20.76 0.00 (20.76) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.38 0.53 0.00 (0.53) 0.00 41940 HEALTH INSURANCE 0.00 0.00 12.49 0.00 (12.49) 0.00 41946 LIFE INSURANCE 0.00 0.00 0.92 0.00 (0.92) 0.00
41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 1.17 0.00 (1.17) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 866.63 1,219.35 0.00 (1,219.35) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 1,990,255.93 0.00 0.00 0.00 1,990,255.93 0.00 43300 CONSTRUCTION CONTRACTS 143,740.46 0.00 0.00 0.00 143,740.46 0.00 TOTAL FOR SERVICES-SUPPLIES 2,133,996.39 0.00 0.00 0.00 2,133,996.39 0.00 TOTAL FOR NOT APPLICABLE 2,133,996.39 866.63 1,219.35 0.00 2,132,777.04 0.05 50 WATER UTILITY SERVICES
SERVICES-SUPPLIES
44100 INTEREST EXPENSE 509,691.00 211,016.75 230,508.95 0.00 279,182.05 45.22 44610 ADMINISTRATIVE SERVICES CHARGE 9,541.00 2,385.25 7,155.75 0.00 2,385.25 75.00 TOTAL FOR SERVICES-SUPPLIES 519,232.00 213,402.00 237,664.70 0.00 281,567.30 45.77 TOTAL FOR WATER UTILITY SERVICES 519,232.00 213,402.00 237,664.70 0.00 281,567.30 45.77 FUN 507 2,653,228.39 214,268.63 238,884.05 0.00 2,414,344.34 9.00 JULIEK Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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
567 RECLAIMED WATER SYSTEM
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 2,312.58 18,975.79 0.00 (18,975.79) 0.00 41141 SP COMP-BILINGUAL 0.00 36.09 337.94 0.00 (337.94) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 0.00 4.12 0.00 (4.12) 0.00 41530 TIERED RHS BENEFIT 0.00 0.00 4.12 0.00 (4.12) 0.00 41600 LONGEVITY 0.00 0.00 13.18 0.00 (13.18) 0.00
41910 PERS-NORMAL 0.00 255.53 2,102.74 0.00 (2,102.74) 0.00 41920 MEDICARE 0.00 69.56 572.03 0.00 (572.03) 0.00
41929 SHORT TERM DISABILITY 0.00 0.00 9.92 0.00 (9.92) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 16.45 0.00 (16.45) 0.00 41931 WORKERS COMP 0.00 46.96 386.26 0.00 (386.26) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 1.20 9.85 0.00 (9.85) 0.00 41940 HEALTH INSURANCE 0.00 0.00 578.89 0.00 (578.89) 0.00 41946 LIFE INSURANCE 0.00 0.00 20.09 0.00 (20.09) 0.00
41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 28.89 0.00 (28.89) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 2,721.92 23,060.27 0.00 (23,060.27) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 2,458,468.18 0.00 0.00 0.00 2,458,468.18 0.00 42020 MINOR EQUIPMENT & FURNITURE 0.00 0.00 99.14 0.00 (99.14) 0.00 42033 CONSTRUCTION MATERIALS 0.00 0.00 31,183.19 0.00 (31,183.19) 0.00 42900 PROF. & CONT. SVCS 17,744.85 6,080.73 27,572.04 57,102.39 (66,929.58) 477.17 43300 CONSTRUCTION CONTRACTS 0.00 0.00 124,790.14 0.00 (124,790.14) 0.00 43724 OUTSIDE SERVICES - LABOR 0.00 6,547.50 7,357.50 0.00 (7,357.50) 0.00 TOTAL FOR SERVICES-SUPPLIES 2,476,213.03 12,628.23 191,002.01 57,102.39 2,228,108.63 10.01
CAPITAL OUTLAY
45900 INFRASTRUCTURE 0.00 0.00 435,000.00 0.00 (435,000.00) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 0.00 435,000.00 0.00 (435,000.00) 0.00 TOTAL FOR NOT APPLICABLE 2,476,213.03 15,350.15 649,062.28 57,102.39 1,770,048.36 28.51 13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 0.00 0.00 14.65 0.00 (14.65) 0.00 44101 DS INTEREST 2021 POBS 21,225.91 0.00 7,123.77 0.00 14,102.14 33.56 TOTAL FOR SERVICES-SUPPLIES 21,225.91 0.00 7,138.42 0.00 14,087.49 33.63 TOTAL FOR DEBT SERVICE 21,225.91 0.00 7,138.42 0.00 14,087.49 33.63 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 12,508.03 695.50 6,773.57 0.00 5,734.46 54.15 JULIEK Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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
41103 OUT OF CLASS PAY 0.00 0.00 326.29 0.00 (326.29) 0.00 41141 SP COMP-BILINGUAL 159.25 20.84 197.98 0.00 (38.73) 124.32 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 22.92 0.00 13.08 63.66 41530 TIERED RHS BENEFIT 36.00 9.00 22.92 0.00 13.08 63.66 41600 LONGEVITY 96.00 7.38 54.62 0.00 41.38 56.89
41700 ANNUAL LEAVE BUYBACK 795.24 0.00 795.31 0.00 (0.07) 100.00 41910 PERS-NORMAL 1,388.65 78.74 799.87 0.00 588.78 57.60 41920 MEDICARE 406.94 21.40 240.95 0.00 165.99 59.21
41929 SHORT TERM DISABILITY 40.03 4.02 33.92 0.00 6.11 84.73 41930 LONG TERM DISABILITY 85.05 6.66 56.16 0.00 28.89 66.03 41931 WORKERS COMP 253.34 14.12 145.29 0.00 108.05 57.34 41932 STATE UNEMPLOYMENT INSURANCE 6.78 0.37 4.17 0.00 2.61 61.50 41940 HEALTH INSURANCE 3,203.18 255.93 2,084.04 0.00 1,119.14 65.06 41946 LIFE INSURANCE 103.82 8.14 68.47 0.00 35.35 65.95 41951 HEALTH ALLOWANCE CREDIT 0.00 11.22 158.67 0.00 (158.67) 0.00 41996 VACANCY FACTOR (730.00) 0.00 0.00 0.00 (730.00) 0.00 41997 BUDGETARY/PAYROLL (184.52) 0.00 0.00 0.00 (184.52) 0.00 TOTAL FOR SALARIES-BENEFITS 18,317.79 1,142.32 11,785.15 0.00 6,532.64 64.33
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 39.00 0.00 0.00 0.00 39.00 0.00 TOTAL FOR SERVICES-SUPPLIES 39.00 0.00 0.00 0.00 39.00 0.00 TOTAL FOR PUBLIC WORKS 18,356.79 1,142.32 11,785.15 0.00 6,571.64 64.20 53 RECLAIMED WATER
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 69,674.98 0.00 4,309.07 0.00 65,365.91 6.18 41102 SHIFT DIFFERENTIAL 0.00 0.00 14.98 0.00 (14.98) 0.00 41140 FINAL LEAVE 0.00 0.00 391.28 0.00 (391.28) 0.00
41141 SP COMP-BILINGUAL 1,456.48 0.00 50.84 0.00 1,405.64 3.49 41147 SP COMP-GRADE 4 CERT PAY 1,340.00 0.00 51.94 0.00 1,288.06 3.87 41148 SP COMP-GRADE 5 CERT PAY 987.70 0.00 0.00 0.00 987.70 0.00 41200 TEMPORARY EMPLOYEES 1,111.80 0.00 0.00 0.00 1,111.80 0.00 41300 OVERTIME 8,254.00 0.00 48.93 0.00 8,205.07 0.59
41400 SPECIAL DUTY PAY 936.00 0.00 87.65 0.00 848.35 9.36 41410 AUTO ALLOWANCE 99.60 0.00 1.58 0.00 98.02 1.58
41500 DEFERRED COMPENSATION MATCH 368.50 0.00 0.00 0.00 368.50 0.00 41510 PST DEFERRED COMPENSATION 3.40 0.00 0.00 0.00 3.40 0.00 41520 TIERED EMP DEF COMPENSATION 243.00 0.00 11.25 0.00 231.75 4.62 41530 TIERED RHS BENEFIT 123.00 0.00 8.75 0.00 114.25 7.11 JULIEK Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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
41600 LONGEVITY 452.24 0.00 92.86 0.00 359.38 20.53
41700 ANNUAL LEAVE BUYBACK 1,487.47 0.00 4,406.28 0.00 (2,918.81) 296.22 41710 ANNUAL LEAVE OVER MAX 4,075.00 0.00 0.00 0.00 4,075.00 0.00 41910 PERS-NORMAL 8,084.29 0.00 490.58 0.00 7,593.71 6.06 41920 MEDICARE 2,554.20 0.00 282.67 0.00 2,271.53 11.06 41929 SHORT TERM DISABILITY 222.96 0.00 16.78 0.00 206.18 7.52 41930 LONG TERM DISABILITY 473.79 0.00 27.81 0.00 445.98 5.86 41931 WORKERS COMP 1,520.48 0.00 89.75 0.00 1,430.73 5.90 41932 STATE UNEMPLOYMENT INSURANCE 42.98 0.00 4.94 0.00 38.04 11.49 41940 HEALTH INSURANCE 20,337.43 0.00 1,309.37 0.00 19,028.06 6.43 41941 RETIREES HEALTH INSURANCE/OPEB 30,238.00 0.00 0.00 0.00 30,238.00 0.00 41945 OPT OUT HEALTH INSURANCE 168.00 0.00 78.76 0.00 89.24 46.88 41946 LIFE INSURANCE 578.28 0.00 33.94 0.00 544.34 5.86 41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 54.38 0.00 (54.38) 0.00 41996 VACANCY FACTOR (8,470.00) 0.00 0.00 0.00 (8,470.00) 0.00 41997 BUDGETARY/PAYROLL 2,898.29 0.00 0.00 0.00 2,898.29 0.00 TOTAL FOR SALARIES-BENEFITS 149,261.87 0.00 11,864.39 0.00 137,397.48 7.94
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 3,015.00 0.00 0.00 0.00 3,015.00 0.00 42033 CONSTRUCTION MATERIALS 124,387.88 0.00 11,710.08 21,000.00 91,677.80 26.29 42034 SAFETY MATERIALS/CONSTRUCTION 15.00 0.00 0.00 0.00 15.00 0.00 42055 COMPUTER EQUIPMENT & 217.00 0.00 2,193.25 0.32 (1,976.57) 1,010.86 42100 UNIFORM EXPENSE 0.00 2.08 813.18 0.00 (813.18) 0.00 42101 SAFETY SHOES - MOU ITEM 186.00 0.00 0.00 0.00 186.00 0.00 42200 ADVERTISING EXPENSE 15.00 0.00 0.00 0.00 15.00 0.00 42300 WIRELESS COMMUNICATION 770.00 0.00 354.65 0.00 415.35 46.05 42320 POSTAGE & SHIPPING 745.00 0.46 0.46 0.00 744.54 0.06 42340 OFFICE SUPPLIES 240.00 30.00 92.62 0.00 147.38 38.59 42350 PROGRAM EXPENDITURES 315.00 8.74 153.04 0.00 161.96 48.58 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 0.94 0.00 (0.94) 0.00 42365 RECYCLED CONTENT PRODUCTS 0.00 0.66 0.76 0.00 (0.76) 0.00 42410 ELECTRIC UTILITY 697,680.00 13,773.00 437,060.66 0.00 260,619.34 62.64 42442 DIESEL FUEL 5,000.00 0.00 0.00 0.00 5,000.00 0.00 42500 RENTS & LEASES 486.00 0.00 0.00 0.00 486.00 0.00
42600 MOTOR POOL RENTAL 8,731.00 0.00 8,028.00 0.00 703.00 91.94 42605 RETAINED VEHICLE EXPENSE 2,270.00 0.00 1,487.00 0.00 783.00 65.50 42700 OTHER EQUIPMENT RENTAL 1,000.00 0.00 0.00 750.00 250.00 75.00 42710 MILEAGE/VEHICLE EXP REIMB 50.00 0.00 0.00 0.00 50.00 0.00 42813 MTCE & REPAIR - EQUIP & FAC 181,338.00 7,286.98 11,225.95 83,694.89 86,417.16 52.34 42815 SCADA MAINTENANCE 104,527.00 2,781.54 17,957.99 67,416.51 19,152.50 81.67 JULIEK Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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
42816 MOWING/LANDSCAPE CONTRACTS 3,052.00 246.89 1,665.20 3,581.69 (2,194.89) 171.91 42900 PROF. & CONT. SVCS 494,226.00 30,059.46 278,297.22 118,435.89 97,492.89 80.27 43000 INSURANCE & SURETY BONDS 6,071.00 0.00 6,168.31 0.00 (97.31) 101.60 43100 MEMBERSHIP & DUES 6,443.00 0.00 7,192.50 0.00 (749.50) 111.63 43200 CONFERENCE, TRAINING & TRAVEL 60.00 0.00 225.74 0.00 (165.74) 376.23 43715 REGULATORY PERMIT & USE FEES 55.00 0.00 0.00 0.00 55.00 0.00 43722 PREVENTION & MAINTENANCE 131,941.00 450.00 4,872.12 53,359.33 73,709.55 44.13 44100 INTEREST EXPENSE 360,662.00 72,054.50 124,817.63 0.00 235,844.37 34.60 44200 BAD DEBTS EXPENSE 903.00 0.00 0.00 0.00 903.00 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 128,351.00 32,087.75 96,263.25 0.00 32,087.75 75.00 44613 INTERNAL SVC CHRG-WAREHOUSE 4,301.00 1,075.25 3,225.75 0.00 1,075.25 75.00 44614 INTERNAL SVC CHRG-INFO TECH 46,834.00 11,708.50 35,125.50 0.00 11,708.50 75.00 TOTAL FOR SERVICES-SUPPLIES 2,313,886.88 171,565.81 1,048,931.80 348,238.63 916,716.45 60.38 TOTAL FOR RECLAIMED WATER 2,463,148.75 171,565.81 1,060,796.19 348,238.63 1,054,113.93 57.20 FUN 567 4,978,944.48 188,058.28 1,728,782.04 405,341.02 2,844,821.42 42.86 JULIEK Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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
570 WATER UTILITY
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 5,093.13 46,081.16 0.00 (46,081.16) 0.00 41141 SP COMP-BILINGUAL 0.00 64.81 657.64 0.00 (657.64) 0.00 41300 OVERTIME 0.00 1,262.26 2,947.57 0.00 (2,947.57) 0.00 41500 DEFERRED COMPENSATION MATCH 0.00 0.00 7.49 0.00 (7.49) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 0.00 34.17 0.00 (34.17) 0.00 41530 TIERED RHS BENEFIT 0.00 0.00 19.17 0.00 (19.17) 0.00 41600 LONGEVITY 0.00 0.00 86.32 0.00 (86.32) 0.00
41910 PERS-NORMAL 0.00 561.18 5,094.58 0.00 (5,094.58) 0.00 41920 MEDICARE 0.00 190.08 1,475.66 0.00 (1,475.66) 0.00 41929 SHORT TERM DISABILITY 0.00 0.00 67.19 0.00 (67.19) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 111.42 0.00 (111.42) 0.00 41931 WORKERS COMP 0.00 103.15 935.01 0.00 (935.01) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 3.26 25.33 0.00 (25.33) 0.00 41940 HEALTH INSURANCE 0.00 0.00 3,350.26 0.00 (3,350.26) 0.00 41945 OPT OUT HEALTH INSURANCE 0.00 0.00 56.25 0.00 (56.25) 0.00 41946 LIFE INSURANCE 0.00 0.00 136.07 0.00 (136.07) 0.00 41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 161.25 0.00 (161.25) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 7,277.87 61,246.54 0.00 (61,246.54) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 34,982,384.51 0.00 0.00 0.00 34,982,384.51 0.00 42033 CONSTRUCTION MATERIALS 0.00 25,291.11 531,989.75 24,991.28 (556,981.03) 0.00 42320 POSTAGE & SHIPPING 0.00 0.00 12.68 0.00 (12.68) 0.00 42430 WATER UTILITY 0.00 595.05 16,733.74 0.00 (16,733.74) 0.00 42800 EQUIPMENT MAINTENANCE 2,440.80 0.00 0.00 2,440.80 0.00 100.00 42815 SCADA MAINTENANCE 108,757.09 20,065.61 75,793.14 79,995.42 (47,031.47) 143.24 42900 PROF. & CONT. SVCS 869,762.20 143,295.74 629,339.92 821,811.79 (581,389.51) 166.84 43300 CONSTRUCTION CONTRACTS 1,969,852.70 77,968.96 3,452,093.05 989,711.39 (2,471,951.74) 225.48 43301 CAPITAL IMPROVEMENTS 0.00 32,836.00 162,562.14 0.00 (162,562.14) 0.00 43724 OUTSIDE SERVICES - LABOR 12,912.00 0.00 24,564.00 0.00 (11,652.00) 190.24 43726 PROJECT MANAGEMENT 62,026.77 7,800.00 184,825.42 51.35 (122,850.00) 298.05 43727 INSPECTION 0.00 29,688.00 83,020.00 54,900.00 (137,920.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 38,008,136.07 337,540.47 5,160,933.84 1,973,902.03 30,873,300.20 18.77
CAPITAL OUTLAY
45100 LICENSED VEHICLES 168,973.00 0.00 0.00 0.00 168,973.00 0.00 45200 MACHINERY, EQUIPMENT, & FIXTUR 60,156.08 27,098.77 97,025.65 219,036.84 (255,906.41) 525.40 TOTAL FOR CAPITAL OUTLAY 229,129.08 27,098.77 97,025.65 219,036.84 (86,933.41) 137.94 JULIEK Page: 7 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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
TOTAL FOR NOT APPLICABLE 38,237,265.15 371,917.11 5,319,206.03 2,192,938.87 30,725,120.25 19.64 13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 0.00 0.00 253.55 0.00 (253.55) 0.00 44101 DS INTEREST 2021 POBS 367,584.53 0.00 123,367.37 0.00 244,217.16 33.56 TOTAL FOR SERVICES-SUPPLIES 367,584.53 0.00 123,620.92 0.00 243,963.61 33.63 TOTAL FOR DEBT SERVICE 367,584.53 0.00 123,620.92 0.00 243,963.61 33.63 21 COMMUNITY DEVELOPMENT
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 54,288.89 3,216.09 34,280.09 0.00 20,008.80 63.14 41103 OUT OF CLASS PAY 0.00 0.00 571.44 0.00 (571.44) 0.00 41141 SP COMP-BILINGUAL 806.99 62.08 535.60 0.00 271.39 66.37 41200 TEMPORARY EMPLOYEES 6,414.79 110.75 1,349.40 0.00 5,065.39 21.03 41300 OVERTIME 0.00 0.00 81.06 0.00 (81.06) 0.00
41500 DEFERRED COMPENSATION MATCH 455.00 0.00 60.00 0.00 395.00 13.18 41510 PST DEFERRED COMPENSATION 83.39 1.44 17.55 0.00 65.84 21.04 41520 TIERED EMP DEF COMPENSATION 120.00 0.00 30.00 0.00 90.00 25.00 41530 TIERED RHS BENEFIT 120.00 0.00 30.00 0.00 90.00 25.00 41600 LONGEVITY 564.46 0.00 155.70 0.00 408.76 27.58
41700 ANNUAL LEAVE BUYBACK 662.70 0.00 883.68 0.00 (220.98) 133.34 41910 PERS-NORMAL 6,055.84 356.69 3,797.77 0.00 2,258.07 62.71 41920 MEDICARE 1,788.03 98.28 1,099.53 0.00 688.50 61.49 41929 SHORT TERM DISABILITY 173.72 13.18 140.26 0.00 33.46 80.73 41930 LONG TERM DISABILITY 369.16 21.85 232.51 0.00 136.65 62.98 41931 WORKERS COMP 1,235.70 67.60 731.20 0.00 504.50 59.17 41932 STATE UNEMPLOYMENT INSURANCE 31.55 1.74 19.11 0.00 12.44 60.57 41940 HEALTH INSURANCE 8,183.14 454.30 4,810.62 0.00 3,372.52 58.78 41945 OPT OUT HEALTH INSURANCE 360.00 0.00 105.07 0.00 254.93 29.18 41946 LIFE INSURANCE 450.60 26.69 284.00 0.00 166.60 63.02 41951 HEALTH ALLOWANCE CREDIT 0.00 11.08 194.72 0.00 (194.72) 0.00 41996 VACANCY FACTOR (2,814.00) 0.00 0.00 0.00 (2,814.00) 0.00 TOTAL FOR SALARIES-BENEFITS 79,349.96 4,441.77 49,409.31 0.00 29,940.65 62.26
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 120.00 0.00 17.62 0.00 102.38 14.68 TOTAL FOR SERVICES-SUPPLIES 120.00 0.00 17.62 0.00 102.38 14.68 TOTAL FOR COMMUNITY DEVELOPMENT DEPT79,469.96 4,441.77 49,426.93 0.00 30,043.03 62.19 39 PUBLIC WORKS
SALARIES-BENEFITS
JULIEK Page: 8 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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
41100 PERMANENT EMPLOYEES 663,334.23 27,755.80 249,861.26 0.00 413,472.97 37.66 41103 OUT OF CLASS PAY 0.00 0.00 2,750.38 0.00 (2,750.38) 0.00 41141 SP COMP-BILINGUAL 3,207.20 214.41 2,084.84 0.00 1,122.36 65.00 41200 TEMPORARY EMPLOYEES 28,737.04 807.23 10,550.31 0.00 18,186.73 36.71 41300 OVERTIME 1,000.00 48.32 1,130.83 0.00 (130.83) 113.08 41400 SPECIAL DUTY PAY 0.00 342.52 3,323.98 0.00 (3,323.98) 0.00 41410 AUTO ALLOWANCE 1,152.00 88.62 841.96 0.00 310.04 73.08 41500 DEFERRED COMPENSATION MATCH 3,878.00 2,309.01 2,309.76 0.00 1,568.24 59.56 41510 PST DEFERRED COMPENSATION 373.58 10.49 137.11 0.00 236.47 36.70 41520 TIERED EMP DEF COMPENSATION 1,452.00 393.00 1,049.22 0.00 402.78 72.26 41530 TIERED RHS BENEFIT 1,192.00 328.00 904.59 0.00 287.41 75.88 41600 LONGEVITY 3,965.93 277.86 2,348.90 0.00 1,617.03 59.22 41700 ANNUAL LEAVE BUYBACK 28,208.23 0.00 27,828.76 0.00 379.47 98.65 41710 ANNUAL LEAVE OVER MAX 497.00 0.00 0.00 0.00 497.00 0.00 41910 PERS-NORMAL 72,961.68 3,075.13 28,034.24 0.00 44,927.44 38.42 41920 MEDICARE 21,363.17 938.88 9,047.34 0.00 12,315.83 42.35 41929 SHORT TERM DISABILITY 2,122.67 170.82 1,318.01 0.00 804.66 62.09 41930 LONG TERM DISABILITY 4,510.67 283.32 2,186.08 0.00 2,324.59 48.46 41931 WORKERS COMP 13,941.16 574.93 5,370.56 0.00 8,570.60 38.52 41932 STATE UNEMPLOYMENT INSURANCE 365.58 14.92 154.96 0.00 210.62 42.38 41940 HEALTH INSURANCE 114,868.06 6,109.09 45,049.24 0.00 69,818.82 39.21 41945 OPT OUT HEALTH INSURANCE 1,560.00 334.00 5,989.23 0.00 (4,429.23) 383.92 41946 LIFE INSURANCE 5,505.67 345.82 2,668.13 0.00 2,837.54 48.46 41951 HEALTH ALLOWANCE CREDIT 0.00 242.42 2,571.08 0.00 (2,571.08) 0.00 41996 VACANCY FACTOR (50,894.00) 0.00 0.00 0.00 (50,894.00) 0.00 41997 BUDGETARY/PAYROLL (1,291.66) 0.00 0.00 0.00 (1,291.66) 0.00 TOTAL FOR SALARIES-BENEFITS 922,010.21 44,664.59 407,510.77 0.00 514,499.44 44.19
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 3,000.00 464.10 464.10 0.00 2,535.90 15.47 42055 COMPUTER EQUIPMENT & 25,150.00 0.00 0.00 0.00 25,150.00 0.00 42101 SAFETY SHOES - MOU ITEM 1,494.00 0.00 161.00 0.00 1,333.00 10.77 42300 WIRELESS COMMUNICATION 1,000.00 0.00 1,117.86 0.00 (117.86) 111.78 42320 POSTAGE & SHIPPING 20.00 0.00 0.00 0.00 20.00 0.00 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 43100 MEMBERSHIP & DUES 13,736.00 0.00 0.00 0.00 13,736.00 0.00 43200 CONFERENCE, TRAINING & TRAVEL 7,207.00 120.00 2,846.35 0.00 4,360.65 39.49 TOTAL FOR SERVICES-SUPPLIES 52,007.00 584.10 4,589.31 0.00 47,417.69 8.82 TOTAL FOR PUBLIC WORKS 974,017.21 45,248.69 412,100.08 0.00 561,917.13 42.30 JULIEK Page: 9 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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
50 WATER UTILITY SERVICES
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 4,611,105.53 299,002.34 2,750,440.12 0.00 1,860,665.41 59.64 41101 SPECIAL ASSIGNMENT PAY 0.00 1,001.29 2,062.30 0.00 (2,062.30) 0.00 41102 SHIFT DIFFERENTIAL 0.00 2,704.89 23,856.42 0.00 (23,856.42) 0.00 41103 OUT OF CLASS PAY 0.00 0.00 1,181.73 0.00 (1,181.73) 0.00 41140 FINAL LEAVE 0.00 1,507.49 94,292.84 0.00 (94,292.84) 0.00 41141 SP COMP-BILINGUAL 21,854.37 1,701.33 14,158.45 0.00 7,695.92 64.78 41147 SP COMP-GRADE 4 CERT PAY 101,953.00 3,177.70 35,506.84 0.00 66,446.16 34.82 41148 SP COMP-GRADE 5 CERT PAY 96,170.01 7,037.00 61,995.12 0.00 34,174.89 64.46 41200 TEMPORARY EMPLOYEES 55,589.65 1,921.41 16,701.16 0.00 38,888.49 30.04 41300 OVERTIME 436,727.00 35,494.53 344,565.72 0.00 92,161.28 78.89 41320 COMP TIME 0.00 1,210.01 10,219.83 0.00 (10,219.83) 0.00 41400 SPECIAL DUTY PAY 60,669.00 4,903.19 47,720.14 0.00 12,948.86 78.65 41410 AUTO ALLOWANCE 4,880.40 243.70 2,318.32 0.00 2,562.08 47.50 41500 DEFERRED COMPENSATION MATCH 23,741.00 16,448.65 18,341.23 0.00 5,399.77 77.25 41510 PST DEFERRED COMPENSATION 170.45 24.98 201.90 0.00 (31.45) 118.45 41520 TIERED EMP DEF COMPENSATION 15,276.00 3,124.43 10,112.87 0.00 5,163.13 66.20 41530 TIERED RHS BENEFIT 7,972.00 1,760.48 5,715.24 0.00 2,256.76 71.69 41600 LONGEVITY 28,259.69 2,040.37 20,983.64 0.00 7,276.05 74.25 41700 ANNUAL LEAVE BUYBACK 92,779.34 0.00 98,864.48 0.00 (6,085.14) 106.55 41710 ANNUAL LEAVE OVER MAX 11,080.00 0.00 5,929.81 0.00 5,150.19 53.51 41910 PERS-NORMAL 531,142.26 34,510.54 322,107.35 0.00 209,034.91 60.64 41920 MEDICARE 163,820.36 11,400.71 108,121.14 0.00 55,699.22 66.00 41929 SHORT TERM DISABILITY 14,755.54 1,230.73 11,318.77 0.00 3,436.77 76.70 41930 LONG TERM DISABILITY 31,355.53 2,041.69 18,773.24 0.00 12,582.29 59.87 41931 WORKERS COMP 99,742.58 6,403.49 59,018.67 0.00 40,723.91 59.17 41932 STATE UNEMPLOYMENT INSURANCE 2,762.18 185.91 1,833.28 0.00 928.90 66.37 41940 HEALTH INSURANCE 1,321,816.81 54,853.92 501,504.54 0.00 820,312.27 37.94 41941 RETIREES HEALTH INSURANCE/OPEB 526,398.00 0.00 0.00 0.00 526,398.00 0.00 41945 OPT OUT HEALTH INSURANCE 14,280.00 7,973.38 116,313.32 0.00 (102,033.32) 814.51 41946 LIFE INSURANCE 38,272.17 2,491.96 22,907.67 0.00 15,364.50 59.85 41951 HEALTH ALLOWANCE CREDIT 0.00 1,750.43 19,720.35 0.00 (19,720.35) 0.00 41996 VACANCY FACTOR (350,623.00) 0.00 0.00 0.00 (350,623.00) 0.00 41997 BUDGETARY/PAYROLL 39,850.97 0.00 0.00 0.00 39,850.97 0.00 TOTAL FOR SALARIES-BENEFITS 8,001,800.84 506,146.55 4,746,786.49 0.00 3,255,014.35 59.32
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 121,901.94 8,791.41 103,630.26 40,101.85 (21,830.17) 117.90 42033 CONSTRUCTION MATERIALS 1,205,280.96 147,324.34 947,819.04 269,390.37 (11,928.45) 100.98 42034 SAFETY MATERIALS/CONSTRUCTION 42,550.00 6,172.32 35,757.87 3,600.00 3,192.13 92.49 JULIEK Page: 10 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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 & 37,924.00 0.00 24,842.33 30.00 13,051.67 65.58 42100 UNIFORM EXPENSE 22,979.00 1,373.50 22,113.85 0.00 865.15 96.23 42101 SAFETY SHOES - MOU ITEM 13,596.00 0.00 10,824.47 0.00 2,771.53 79.61 42200 ADVERTISING EXPENSE 4,717.00 0.00 4,831.60 0.00 (114.60) 102.42 42220 PROMOTIONAL/PUBLIC OUTREACH 25,153.00 27,949.74 33,914.37 15,927.07 (24,688.44) 198.15 42300 WIRELESS COMMUNICATION 54,542.00 0.00 22,162.95 0.00 32,379.05 40.63 42310 PHONES, FAX, ISDN LINES 12,168.00 272.94 6,860.02 0.00 5,307.98 56.37 42320 POSTAGE & SHIPPING 142,052.00 11,268.61 85,187.80 15,541.51 41,322.69 70.91 42340 OFFICE SUPPLIES 13,086.00 1,613.33 5,654.28 0.00 7,431.72 43.20 42345 FIRST AID KIT SUPPLIES 280.00 165.43 198.16 0.00 81.84 70.77 42350 PROGRAM EXPENDITURES 30,905.00 1,831.19 32,575.36 0.00 (1,670.36) 105.40 42360 CLEANING/JANITORIAL SUPPLIES 0.00 9.66 1,798.73 0.00 (1,798.73) 0.00 42365 RECYCLED CONTENT PRODUCTS 0.00 33.10 38.54 0.00 (38.54) 0.00 42410 ELECTRIC UTILITY 5,613,462.00 207,761.27 3,829,005.14 0.00 1,784,456.86 68.21 42420 NATURAL GAS UTILITY 1,040.00 126.52 606.43 0.00 433.57 58.31 42430 WATER UTILITY 53,060.00 4,787.51 43,060.90 0.00 9,999.10 81.15 42435 RECYCLED WATER UTILITY 13,293.00 616.00 5,336.94 0.00 7,956.06 40.14 42441 UNLEADED FUEL 2,880.00 0.00 1,221.63 0.00 1,658.37 42.41 42442 DIESEL FUEL 11,140.00 0.00 1,145.45 1,597.90 8,396.65 24.62 42443 OTHER FUELS 250.00 0.00 0.00 0.00 250.00 0.00
42500 RENTS & LEASES 736,851.00 182,628.58 552,606.71 0.00 184,244.29 74.99 42501 CUA LEASES 2,430,513.00 607,628.25 1,822,884.75 0.00 607,628.25 75.00 42600 MOTOR POOL RENTAL 451,148.27 0.00 438,710.00 0.00 12,438.27 97.24 42605 RETAINED VEHICLE EXPENSE 23,206.00 0.00 16,419.00 0.00 6,787.00 70.75 42610 DIRECT VEHICLE EXPENSE 17,850.00 389.67 3,935.99 4,610.33 9,303.68 47.87 42630 PARTS/LABOR ON CITY VEHICLES 0.00 0.00 1.75 0.00 (1.75) 0.00 42700 OTHER EQUIPMENT RENTAL 54,434.66 3,097.48 10,990.73 17,481.44 25,962.49 52.30 42710 MILEAGE/VEHICLE EXP REIMB 1,515.00 23.94 398.00 0.00 1,117.00 26.27 42813 MTCE & REPAIR - EQUIP & FAC 560,292.77 50,748.51 354,347.11 267,306.13 (61,360.47) 110.95 42815 SCADA MAINTENANCE 425,567.75 35,003.66 167,254.61 221,706.55 36,606.59 91.39 42816 MOWING/LANDSCAPE CONTRACTS 150,008.00 7,767.36 62,379.86 11,637.50 75,990.64 49.34 42821 TREE MAINTENANCE 0.00 4,623.00 4,623.00 0.00 (4,623.00) 0.00 42830 REBATE PROGRAMS 25,000.00 6,094.00 7,565.81 0.00 17,434.19 30.26 42900 PROF. & CONT. SVCS 3,107,680.63 139,352.03 1,308,102.83 815,860.25 983,717.55 68.34 42902 CUST CREDIT CRD PROCESSING FEE 313,967.00 63,213.16 184,899.33 155,191.64 (26,123.97) 108.32 43000 INSURANCE & SURETY BONDS 48,566.00 0.00 49,346.48 0.00 (780.48) 101.60 43100 MEMBERSHIP & DUES 76,291.00 1,805.65 55,858.65 0.00 20,432.35 73.21 43200 CONFERENCE, TRAINING & TRAVEL 49,380.00 0.00 8,689.15 0.00 40,690.85 17.59 43400 LEGAL SERVICES-SPECIAL COUNSEL 42,500.00 2,936.60 3,416.30 0.00 39,083.70 8.03 43502 SCHOOL PROGRAMS 29,480.00 0.00 0.00 10,000.00 19,480.00 33.92 JULIEK Page: 11 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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
43699 CHEMICALS-CORRSN & SCALE INHIB 163,125.00 0.00 49,496.25 100,503.75 13,125.00 91.95 43701 CHEMICALS-POLYMER 193,016.00 10,346.69 116,543.03 72,656.97 3,816.00 98.02 43702 CHEMICALS-ALUM 89,232.00 0.00 52,640.55 36,591.45 0.00 100.00 43703 CHEMICALS-AMMONIA 83,802.00 8,646.51 55,638.25 23,361.75 4,802.00 94.26 43704 CHEMICALS-ANTISCALANT 225,266.00 19,364.30 118,952.13 43,047.87 63,266.00 71.91 43705 CHEMICALS-SULFURIC ACID 263,248.00 28,457.65 198,826.95 69,173.05 (4,752.00) 101.80 43706 CHEMICALS-CAUSTIC SODA 41,200.00 0.00 15,914.26 25,285.74 0.00 100.00 43707 CHEMICALS-SODIUM 541,088.00 26,593.96 289,152.80 413,240.80 (161,305.60) 129.81 43711 CHEMICALS-MISC 82,400.00 0.00 0.00 36,910.00 45,490.00 44.79 43714 OUTSIDE LAB ANALYSIS 366,715.00 45,604.87 87,048.57 261,671.43 17,995.00 95.09 43715 REGULATORY PERMIT & USE FEES 152,678.00 1,861.83 147,641.36 0.00 5,036.64 96.70 43716 JOB REQ CERTIFICATES & LICENSE 2,410.00 297.00 5,046.71 0.00 (2,636.71) 209.40 43717 RAW WATER PURCHASES 15,620,549.00 24,932.24 8,926,123.82 0.00 6,694,425.18 57.14 43718 TREATED WATER PURCHASES 1,876,352.00 2,561.67 601,363.17 0.00 1,274,988.83 32.04 43720 LAB CHEMICALS AND SUPPLIES 70,558.80 7,567.42 44,107.30 27,095.80 (644.30) 100.91 43722 PREVENTION & MAINTENANCE 1,828,515.00 40,927.15 411,381.22 701,364.74 715,769.04 60.85 43723 INLAND EMPIRE BRINE LINE-SARI 1,608,975.00 113,964.35 906,718.22 0.00 702,256.78 56.35 43724 OUTSIDE SERVICES - LABOR 0.00 0.00 6,075.00 0.00 (6,075.00) 0.00 43725 FINES AND PENALTIES 0.00 0.00 1,600.00 0.00 (1,600.00) 0.00 43731 CARBON DIOXIDE 41,200.00 0.00 17,323.61 20,595.60 3,280.79 92.03 44100 INTEREST EXPENSE 670,974.00 231,603.75 466,423.15 0.00 204,550.85 69.51 44200 BAD DEBTS EXPENSE 147,432.00 0.00 0.00 0.00 147,432.00 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 2,723,169.00 680,792.25 2,042,376.75 0.00 680,792.25 75.00 44613 INTERNAL SVC CHRG-WAREHOUSE 290,551.00 72,637.75 217,913.25 0.00 72,637.75 75.00 44614 INTERNAL SVC CHRG-INFO TECH 1,982,607.00 495,651.75 1,486,955.25 0.00 495,651.75 75.00 TOTAL FOR SERVICES-SUPPLIES 45,031,573.78 3,337,219.90 26,536,277.78 3,681,481.49 14,813,814.51 67.10
CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 45,850.00 31,969.22 77,819.22 0.00 (31,969.22) 169.72 TOTAL FOR CAPITAL OUTLAY 45,850.00 31,969.22 77,819.22 0.00 (31,969.22) 169.72 TOTAL FOR WATER UTILITY SERVICES 53,079,224.62 3,875,335.67 31,360,883.49 3,681,481.49 18,036,859.64 66.01 FUN 570 92,737,561.47 4,296,943.24 37,265,237.45 5,874,420.36 49,597,903.66 46.51 JULIEK Page: 12 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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
571 WATER UTILITY GRANT/AGREEMENT
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 611.37 6,147.67 0.00 (6,147.67) 0.00 41141 SP COMP-BILINGUAL 0.00 12.02 115.95 0.00 (115.95) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 0.00 1.14 0.00 (1.14) 0.00 41530 TIERED RHS BENEFIT 0.00 0.00 1.14 0.00 (1.14) 0.00 41600 LONGEVITY 0.00 0.00 6.57 0.00 (6.57) 0.00
41910 PERS-NORMAL 0.00 67.84 682.23 0.00 (682.23) 0.00
41920 MEDICARE 0.00 18.45 185.93 0.00 (185.93) 0.00
41929 SHORT TERM DISABILITY 0.00 0.00 4.17 0.00 (4.17) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 6.94 0.00 (6.94) 0.00 41931 WORKERS COMP 0.00 12.47 125.30 0.00 (125.30) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.31 3.22 0.00 (3.22) 0.00 41940 HEALTH INSURANCE 0.00 0.00 219.71 0.00 (219.71) 0.00 41945 OPT OUT HEALTH INSURANCE 0.00 0.00 15.00 0.00 (15.00) 0.00 41946 LIFE INSURANCE 0.00 0.00 8.49 0.00 (8.49) 0.00
41951 HEALTH ALLOWANCE CREDIT 0.00 0.00 11.00 0.00 (11.00) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 722.46 7,534.46 0.00 (7,534.46) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 8,331,057.82 0.00 0.00 0.00 8,331,057.82 0.00 42830 REBATE PROGRAMS 0.00 1,742.16 46,217.86 0.00 (46,217.86) 0.00 42900 PROF. & CONT. SVCS 24,194.91 643.62 8,606.40 375,645.81 (360,057.30) 1,588.15 43300 CONSTRUCTION CONTRACTS 0.00 0.00 41,596.71 4,595,370.00 (4,636,966.71) 0.00 TOTAL FOR SERVICES-SUPPLIES 8,355,252.73 2,385.78 96,420.97 4,971,015.81 3,287,815.95 60.64
CAPITAL OUTLAY
45900 INFRASTRUCTURE 0.00 0.00 145,000.00 0.00 (145,000.00) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 0.00 145,000.00 0.00 (145,000.00) 0.00 TOTAL FOR NOT APPLICABLE 8,355,252.73 3,108.24 248,955.43 4,971,015.81 3,135,281.49 62.47 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 8,355,252.73 3,108.24 248,955.43 4,971,015.81 3,135,281.49 62.47 JULIEK Page: 13 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
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 108,724,987.07 4,702,378.39 39,481,858.97 11,250,777.19 57,992,350.91 46.66 JULIEK Page: 14 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/11/2023
Current Time: 07:23:46
User:
Report: