Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
453 2012 WATER REV REF PROJECT
00 NOT APPLICABLE
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 User: KIMS Page: 1 Current Date: 01/21/2022
Report: GREREES_Consolidated_Expenditure_Report Current Time: 12:14:33 Ledger: GL CONSOLIDATED EXPENDITURE REPORT-BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD • Encumbrances (Over)/Under Used
507 WATER CAPACITY
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 229.50 2,225.11 0.00 (2,225.11) 0.00 41910 PERS-NORMAL 0.00 26.14 253.45 0.00 (253.45) 0.00
41920 MEDICARE 0.00 7.02 67.90 0.00 (67.90) 0.00
41931 WORKERS COMP 0.00 4.59 44.50 0.00 (44.50) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.12 1.13 0.00 (1.13) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 267.37 2,592.09 0.00 (2,592.09) 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 267.37 207,513.41 611,941.06 558,512.37 59.46 50 WATER UTILITY SERVICES
SERVICES-SUPPLIES
44100 INTEREST EXPENSE 490,740.00 0.00 81,233.75 0.00 409,506.25 16.55 44610 ADMINISTRATIVE SERVICES CHARGE 8,138.00 2,034.50 4,069.00 0.00 4,069.00 50.00 TOTAL FOR SERVICES-SUPPLIES 498,878.00 2,034.50 85,302.75 0.00 413,575.25 17.09 TOTAL FOR WATER UTILITY SERVICES 498,878.00 2,034.50 85,302.75 0.00 413,575.25 17.09 FUN 507 1,876,844.84 2,301.87 292,816.16 611,941.06 972,087.62 48.20 User: KIMS Page: 2 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:14:33 Ledger: GL CONSOLIDATED EXPENDITURE REPORT-BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD : Encumbrances (Over)/Under Used
567 RECLAIMED WATER SYSTEM
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 170.44 3,931.36 0.00 (3,931.36) 0.00 41910 PERS-NORMAL 0.00 19.41 447.78 0.00 (447.78) 0.00
41920 MEDICARE 0.00 5.08 117.40 0.00 (117.40) 0.00
41931 WORKERS COMP 0.00 3.41 78.64 0.00 (78.64) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.08 1.97 0.00 (1.97) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 198.42 4,577.15 0.00 (4,577.15) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 4,350,010.84 0.00 0.00 0.00 4,350,010.84 0.00 42033 CONSTRUCTION MATERIALS 2,346.95 90,134.91 93,262.92 2,322.69 (93,238.66) 4,072.75 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,135.00 789.00 0.00 100.00 42900 PROF. & CONT. SVCS 18,844.48 0.00 1,083.15 14,230.79 3,530.54 81.26 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 60,000.00 (38,643.52) 280.94 43726 PROJECT MANAGEMENT 0.00 276.00 816.00 0.00 (816.00) 0.00 43727 INSPECTION 1,478.29 0.00 0.00 0.00 1,478.29 0.00
TOTAL FOR SERVICES-SUPPLIES 4,397,961.04 90,410.91 99,836.36 77,342.48 4,220,782.20 4.02
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 4,397,961.04 20,609.33 114,521.69 77,342.48 4,206,096.87 4.36 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 6,345.29 497.23 2,295.84 0.00 4,049.45 36.18 41500 DEFERRED COMPENSATION MATCH 114.00 0.00 0.00 0.00 114.00 0.00 41520 TIERED EMP DEF COMPENSATION 36.00 2.00 18.00 0.00 18.00 50.00 41530 TIERED RHS BENEFIT 36.00 9.00 18.00 0.00 18.00 50.00 41600 LONGEVITY 96.00 0.00 96.00 0.00 0.00 100.00
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 733.66 56.64 272.46 0.00 461.20 37.13 41912 PERS-UNFUNDED 1,915.00 0.00 495.21 0.00 1,419.79 25.85 41920 MEDICARE 217.98 14.46 85.93 0.00 132.05 39.42
41929 SHORT TERM DISABILITY 20.30 2.34 10.23 0.00 10.07 50.39 41930 LONG TERM DISABILITY 43.15 4.98 21.76 0.00 21.39 50.42 41931 WORKERS COMP 126.91 9.52 43.38 0.00 83.53 34.18
User: KIMS Page: Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:14:33 Ledger: GL CONSOLIDATED EXPENDITURE REPORT - BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
41932 STATE UNEMPLOYMENT INSURANCE 3.52 0.24 1.43 0.00 2.09 40.62 41940 HEALTH INSURANCE 1,130.55 94.07 564.38 0.00 566.17 49.92 41946 LIFE INSURANCE 52.67 6.06 26.51 0.00 26.16 50.33
41996 VACANCY FACTOR (320.00) 0.00 0.00 0.00 (320.00) 0.00 TOTAL FOR SALARIES-BENEFITS 11,158.78 703.54 4,556.89 0.00 6,601.89 40.83
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 11,180.28 703.54 4,556.89 0.00 6,623.39 40.75 53 RECLAIMED WATER
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 272,286.80 29,644.96 127,755.44 0.00 144,531.36 46.91 41102 SHIFT DIFFERENTIAL 0.00 49.69 156.45 0.00 (156.45) 0.00 41103 OUT OF CLASS PAY 0.00 30.84 30.84 0.00 (30.84) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 6.93 67.45 0.00 (67.45) 0.00 41140 FINAL LEAVE 0.00 0.00 370.17 0.00 (370.17) 0.00
41148 SP COMP-GRADE 5 CERT PAY 184.00 0.00 0.00 0.00 184.00 0.00 41300 OVERTIME 8,519.00 460.27 1,563.39 0.00 6,955.61 18.35 41400 SPECIAL DUTY PAY 2,168.00 464.88 1,770.82 0.00 397.18 81.67 41410 AUTO ALLOWANCE 912.00 66.45 291.11 0.00 620.89 31.91 41500 DEFERRED COMPENSATION MATCH 2,130.00 59.57 202.23 0.00 1,927.77 9.49 41520 TIERED EMP DEF COMPENSATION 200.00 225.00 450.00 0.00 450.00 50.00 41530 TIERED RHS BENEFIT 640.00 160.00 320.00 0.00 320.00 50.00 41600 LONGEVITY 2,370.97 73.94 2,101.55 0.00 269.42 88.63 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 0.00 0.00 1,605.00 0.00 41910 PERS-NORMAL 31,325.42 3,413.63 14,827.76 0.00 16,497.66 47.33 41912 PERS-UNFUNDED 82,756.00 0.00 21,400.89 0.00 61,355.11 25.86 41920 MEDICARE 9,249.79 947.19 4,324.19 0.00 4,925.60 46.74 41929 SHORT TERM DISABILITY 870.94 92.96 407.20 0.00 463.74 46.75 41930 LONG TERM DISABILITY 1,851.33 195.29 859.48 0.00 991.85 46.42 41931 WORKERS COMP 5,558.87 597.48 2,555.77 0.00 3,003.10 45.97 41932 STATE UNEMPLOYMENT INSURANCE 152.67 15.82 73.08 0.00 79.59 47.86 41940 HEALTH INSURANCE 30,263.25 2,419.61 14,538.25 0.00 15,725.00 48.03 41941 RETIREES HEALTH INSURANCE/OPEB 40,506.00 0.00 0.00 0.00 40,506.00 0.00 41945 OPT OUT HEALTH INSURANCE 11,250.00 949.96 5,483.10 0.00 5,766.90 48.73 41946 LIFE INSURANCE 2,260.44 238.36 1,049.02 0.00 1,211.42 46.40 41996 VACANCY FACTOR (29,716.00) 0.00 0.00 0.00 (29,716.00) 0.00 User: KIMS Page: 4 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:14:33 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
41997 BUDGETARY/PAYROLL (5,167.00) 0.00 0.00 0.00 (5,167.00) 0.00 TOTAL FOR SALARIES-BENEFITS 480,448.80 40,112.83 208,023.21 0.00 272,425.59 43.29
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 515.12 0.00 0.00 0.00 515.12 0.00 42033 CONSTRUCTION MATERIALS 137,194.26 4,719.98 22,003.08 58,843.01 56,348.17 58.92 42034 SAFETY MATERIALS/CONSTRUCTION 5.80 0.00 0.00 0.00 5.80 0.00 42055 COMPUTER EQUIPMENT & 209.00 10.86 75.11 0.00 133.89 35.93 42101 SAFETY SHOES - MOU ITEM 376.00 0.00 0.00 0.00 376.00 0.00 42200 ADVERTISING EXPENSE 15.00 0.00 48.57 0.00 (33.57) 323.80 42300 WIRELESS COMMUNICATION 770.40 50.70 311.75 0.00 458.65 40.46 42320 POSTAGE & SHIPPING 670.00 0.00 3.79 0.00 666.21 0.56 42340 OFFICE SUPPLIES 240.00 0.00 57.44 0.00 182.56 23.93 42350 PROGRAM EXPENDITURES 329.78 7.81 55.19 50.00 224.59 31.89 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 0.28 0.00 (0.28) 0.00 42410 ELECTRIC UTILITY 697,680.00 17,384.00 157,946.98 0.00 539,733.02 22.63 42442 DIESEL FUEL 5,000.00 0.00 0.00 5,000.00 0.00 100.00 42600 MOTOR POOL RENTAL 4,706.26 4,220.26 4,220.26 0.00 486.00 89.67 42605 RETAINED VEHICLE EXPENSE 698.88 698.88 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 1,041.08 1,441.34 137,361.70 66,618.96 67.56 42815 SCADA MAINTENANCE 71,815.00 6,104.00 14,546.62 58,746.00 (1,477.62) 102.05 42816 MOWING/LANDSCAPE CONTRACTS 2,962.80 246.89 1,481.34 0.00 1,481.46 49.99 42900 PROF. & CONT. SVCS 442,817.87 1,378.81 115,538.58 309,153.87 18,125.42 95.90 43000 INSURANCE & SURETY BONDS 2,451.00 5,893.92 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.00 0.00 60.00 0.00 43715 REGULATORY PERMIT & USE FEES 55.00 0.00 0.00 0.00 55.00 0.00 43722 PREVENTION & MAINTENANCE 112,133.74 0.00 36.06 68,121.92 43,975.76 60.78 43726 PROJECT MANAGEMENT 0.00 67.80 121.80 0.00 (121.80) 0.00 44100 INTEREST EXPENSE 386,063.00 0.00 84,678.25 0.00 301,384.75 21.93 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 38,795.25 77,590.50 0.00 77,590.50 50.00 44613 INTERNAL SVC CHRG-WAREHOUSE 3,162.00 790.50 1,581.00 0.00 1,581.00 50.00 44614 INTERNAL SVC CHRG-INFO TECH 46,344.00 11,586.00 23,172.00 0.00 23,172.00 50.00 TOTAL FOR SERVICES-SUPPLIES 2,292,621.91 92,996.74 517,697.74 638,036.50 1,136,887.67 50.41
CAPITAL OUTLAY
TOTAL FOR CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00
TOTAL FOR RECLAIMED WATER 2,773,070.71 133,109.57 725,720.95 638,036.50 1.409.313.26 49.17 User: KIMS Page: 5 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:14:33 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to CYTD Encumbrances (Over)/Under Used
FUN 567 7,182,212.03 224,422.44 844,799.53 715,378.98 5,622,033.52 21.72 User: KIMS Page: 6 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:14:33 Ledger: GL CONSOLIDATED EXPENDITURE REPORT-BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YID : Encumbrances (Over)/Under Used
570 WATER UTILITY
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 16,538.35 47,682.59 0.00 (47,682.59) 0.00 41141 SP COMP-BILINGUAL 0.00 86.68 189.23 0.00 (189.23) 0.00 41147 SP COMP-GRADE 4 CERT PAY 0.00 0.00 109.62 0.00 (109.62) 0.00 41300 OVERTIME 0.00 0.00 311.17 0.00 (311.17) 0.00
41910 PERS-NORMAL 0.00 1,893.56 5,465.02 0.00 (5,465.02) 0.00 41920 MEDICARE 0.00 498.45 1,445.14 0.00 (1,445.14) 0.00 41929 SHORT TERM DISABILITY 0.00 0.00 1.15 0.00 (1.15) 0.00 41931 WORKERS COMP 0.00 332.51 960.99 0.00 (960.99) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 8.45 24.52 0.00 (24.52) 0.00 41945 OPT OUT HEALTH INSURANCE 0.00 0.00 15.15 0.00 (15.15) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 19,358.00 56,204.58 0.00 (56,204.58) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 36,722,174.19 0.00 0.00 0.00 36,722,174.19 0.00 42033 CONSTRUCTION MATERIALS 64,670.86 110,005.09 500,687.71 114,305.51 (550,322.36) 950.95 42200 ADVERTISING EXPENSE 0.00 254.43 418.19 0.00 (418.19) 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 139.95 0.00 (139.95) 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 7,408.00 112,539.19 165,542.03 (107,106.78) 162.64 42830 REBATE PROGRAMS 0.00 0.00 8,882.57 0.00 (8,882.57) 0.00 42900 PROF. & CONT. SVCS 712,589.99 106,300.35 262,284.02 1,015,971.18 (565,665.21) 179.38 43300 CONSTRUCTION CONTRACTS 3,402,892.82 392,346.70 618,134.41 2,911,270.30 (126,511.89) 103.71 43301 CAPITAL IMPROVEMENTS 256,144.18 39,880.00 162,631.75 484,858.25 (391,345.82) 252.78 43724 OUTSIDE SERVICES - LABOR 12,912.00 870.00 870.00 12,912.00 (870.00) 106.73 43726 PROJECT MANAGEMENT 289,156.54 40,660.34 241,554.45 100,984.09 (53,382.00) 118.46 43727 INSPECTION 1,750.64 0.00 260.00 1,456.00 34.64 98.02 TOTAL FOR SERVICES-SUPPLIES 41,643,395.10 697,724.91 1,908,402.24 4,817,428.80 34,917,564.06 16.15
CAPITAL OUTLAY
45100 LICENSED VEHICLES 147,372.21 0.00 69,739.34 316,345.21 (238,712.34) 261.97 45200 MACHINERY, EQUIPMENT, & FIXTUR 636,981.75 116,741.19 570,213.61 66,768.14 0.00 100.00 TOTAL FOR CAPITAL OUTLAY 784,353.96 116,741.19 639,952.95 383,113.35 (238,712.34) 130.43 TOTAL FOR NOT APPLICABLE 42,427,749.06 833,824.10 2,604,559.77 5,200,542.15 34,622,647.14 18.39 18 ADMIN SERVICES-FINANCE
SALARIES-BENEFITS
41912 PERS-UNFUNDED 0.00 0.00 1,553.28 0.00 (1,553.28) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 0.00 1,553.28 0.00 (1,553.28) 0.00 User: KIMS Page: 7 Current Date: 01/21/2022
Report: GLEREES Consolidated Expenditure Report Current Time: 12:14:33 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
TOTAL FOR ADMIN SERVICES-FINANCE 0.00 0.00 1,553.28 0.00 (1,553.28) 0.00 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 486,920.94 34,171.48 149,776.31 0.00 337,144.63 30.75 41101 SPECIAL ASSIGNMENT PAY 0.00 22.33 22.33 0.00 (22.33) 0.00 41103 OUT OF CLASS PAY 0.00 0.00 50.71 0.00 (50.71) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 29.98 248.90 0.00 (248.90) 0.00 41140 FINAL LEAVE 0.00 0.00 3,229.72 0.00 (3,229.72) 0.00 41141 SP COMP-BILINGUAL 659.74 74.82 248.60 0.00 411.14 37.68 41200 TEMPORARY EMPLOYEES 29,294.41 2,248.82 10,166.02 0.00 19,128.39 34.70 41300 OVERTIME 400.00 258.99 1,195.75 0.00 (795.75) 298.93 41400 SPECIAL DUTY PAY 3,950.00 488.58 2,393.17 0.00 1,556.83 60.58 41410 AUTO ALLOWANCE 1,152.00 132.93 585.52 0.00 566.48 50.82 41500 DEFERRED COMPENSATION MATCH 3,698.00 0.00 194.25 0.00 3,503.75 5.25 41510 PST DEFERRED COMPENSATION 380.82 29.24 132.14 0.00 248.68 34.69 41520 TIERED EMP DEF COMPENSATION 1,482.00 325.50 694.06 0.00 787.94 46.83 41530 TIERED RHS BENEFIT 1,122.00 260.50 540.35 0.00 581.65 48.15 41600 LONGEVITY 3,401.12 49.11 3,013.39 0.00 387.73 88.59 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 0.00 0.00 1,514.00 0.00 41910 PERS-NORMAL 55,923.46 3,908.79 17,436.72 0.00 38,486.74 31.17 41912 PERS-UNFUNDED 147,156.00 0.00 38,054.70 0.00 109,101.30 25.86 41920 MEDICARE 16,279.23 1,076.65 5,437.38 0.00 10,841.85 33.40 41929 SHORT TERM DISABILITY 1,558.14 158.65 685.58 0.00 872.56 44.00 41930 LONG TERM DISABILITY 3,311.06 337.32 1,483.13 0.00 1,827.93 44.79 41931 WORKERS COMP 10,349.11 716.30 3,102.44 0.00 7,246.67 29.97 41932 STATE UNEMPLOYMENT INSURANCE 275.25 18.75 95.09 0.00 180.16 34.54 41940 HEALTH INSURANCE 65,293.01 4,196.15 26,906.23 0.00 38,386.78 41.20 41945 OPT OUT HEALTH INSURANCE 5,730.00 802.52 4,695.08 0.00 1,034.92 81.93 41946 LIFE INSURANCE 4,041.45 411.70 1,810.35 0.00 2,231.10 44.79 41996 VACANCY FACTOR (23,680.00) 0.00 0.00 0.00 (23,680.00) 0.00 41997 BUDGETARY/PAYROLL (601.00) 0.00 0.00 0.00 (601.00) 0.00 TOTAL FOR SALARIES-BENEFITS 838,703.56 49,719.11 291,266.79 0.00 547,436.77 34.72
SERVICES-SUPPLIES
42055 COMPUTER EQUIPMENT & 34,396.61 0.00 852.11 10,366.61 23,177.89 32.61 42101 SAFETY SHOES - MOU ITEM 1,554.06 0.00 0.00 0.00 1,554.06 0.00 42200 ADVERTISING EXPENSE 600.00 0.00 0.00 0.00 600.00 0.00 42300 WIRELESS COMMUNICATION 1,000.00 173.07 731.19 0.00 268.81 73.11 42320 POSTAGE & SHIPPING 20.00 0.00 15.71 0.00 4.29 78.55 User: KIMS Page: 8 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:14:33 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
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 7,568.00 180.00 180.00 0.00 7,388.00 2.37 TOTAL FOR SERVICES-SUPPLIES 45,538.67 353.07 1,779.01 10,366.61 33,393.05 26.67 TOTAL FOR PUBLIC WORKS 884,242.23 50,072.18 293,045.80 10,366.61 580,829.82 34.31 50 WATER UTILITY SERVICES
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 4,337,131.73 383,183.86 1,729,797.09 0.00 2,607,334.64 39.88 41101 SPECIAL ASSIGNMENT PAY 0.00 1,846.16 2,423.08 0.00 (2,423.08) 0.00 41102 SHIFT DIFFERENTIAL 50,000.00 5,037.12 26,224.68 0.00 23,775.32 52.44 41103 OUT OF CLASS PAY 0.00 308.40 308.40 0.00 (308.40) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 3,354.72 20,151.64 0.00 (20,151.64) 0.00 41140 FINAL LEAVE 0.00 6,886.95 37,737.29 0.00 (37,737.29) 0.00 41141 SP COMP-BILINGUAL 17,463.20 1,799.81 8,453.41 0.00 9,009.79 48.40 41147 SP COMP-GRADE 4 CERT PAY 70,980.00 7,151.56 34,749.34 0.00 36,230.66 48.95 41148 SP COMP-GRADE 5 CERT PAY 65,732.00 5,868.24 24,394.43 0.00 41,337.57 37.11 41200 TEMPORARY EMPLOYEES 33,023.61 0.00 4,688.08 0.00 28,335.53 14.19 41300 OVERTIME 538,978.00 62,709.52 225,290.37 0.00 313,687.63 41.79 41320 COMP TIME 0.00 2,724.80 16,201.54 0.00 (16,201.54) 0.00 41400 SPECIAL DUTY PAY 83,100.00 10,865.61 46,723.33 0.00 36,376.67 56.22 41410 AUTO ALLOWANCE 2,034.00 132.93 582.36 0.00 1,451.64 28.63 41500 DEFERRED COMPENSATION MATCH 24,682.00 1,112.02 2,998.77 0.00 21,683.23 12.14 41510 PST DEFERRED COMPENSATION 124.83 0.00 0.00 0.00 124.83 0.00 41520 TIERED EMP DEF COMPENSATION 18,600.00 4,500.40 9,150.40 0.00 9,449.60 49.19 41530 TIERED RHS BENEFIT 8,572.00 2,093.00 4,236.00 0.00 4,336.00 49.41 41600 LONGEVITY 29,915.72 147.93 26,199.33 0.00 3,716.39 87.57 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 0.00 0.00 18,528.00 0.00 41910 PERS-NORMAL 518,625.73 49,172.05 216,628.92 0.00 301,996.81 41.76 41912 PERS-UNFUNDED 1,313,157.00 0.00 339,585.12 0.00 973,571.88 25.86 41920 MEDICARE 166,043.20 14,878.90 70,588.72 0.00 95,454.48 42.51 41929 SHORT TERM DISABILITY 13,878.80 1,225.00 5,567.48 0.00 8,311.32 40.11 41930 LONG TERM DISABILITY 29,492.24 2,590.56 11,824.32 0.00 17,667.92 40.09 41931 WORKERS COMP 92,379.95 8,049.00 36,047.26 0.00 56,332.69 39.02 41932 STATE UNEMPLOYMENT INSURANCE 2,759.68 251.62 1,203.96 0.00 1,555.72 43.62 41940 HEALTH INSURANCE 742,513.54 47,198.44 291,703.79 0.00 450,809.75 39.28 41941 RETIREES HEALTH INSURANCE/OPEB 701,471.00 0.00 0.00 0.00 701,471.00 0.00 41945 OPT OUT HEALTH INSURANCE 168,360.00 14,975.02 86,129.93 0.00 82,230.07 51.15 User: KIMS Page: 9 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:14:33 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance
Budget Month to YTD Encumbrances (Over)/Under Used
41946 LIFE INSURANCE 35,998.50 3,161.96 14,432.10 0.00 21,566.40 40.09 41996 VACANCY FACTOR (498,054.00) 0.00 0.00 0.00 (498,054.00) 0.00 41997 BUDGETARY/PAYROLL (51,669.00) 0.00 0.00 0.00 (51,669.00) 0.00 TOTAL FOR SALARIES-BENEFITS 8,657,751.47 641,225.58 3,417,151.81 0.00 5,240,599.66 39.46
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 85,199.83 5,611.07 34,283.08 47,829.50 3,087.25 96.37 42033 CONSTRUCTION MATERIALS 1,060,288.38 71,159.33 425,492.97 369,443.86 265,351.55 74.97 42034 SAFETY MATERIALS/CONSTRUCTION 25,590.00 3,169.92 20,463.06 3,600.00 1,526.94 94.03 42055 COMPUTER EQUIPMENT & 29,756.01 862.58 4,801.64 1,981.01 22,973.36 22.79 42100 UNIFORM EXPENSE 23,642.66 1,855.76 8,974.73 0.00 14,667.93 37.95 42101 SAFETY SHOES - MOU ITEM 8,795.75 0.00 0.00 0.00 8,795.75 0.00 42200 ADVERTISING EXPENSE 2,767.20 0.00 909.45 0.00 1,857.75 32.86 42220 PROMOTIONAL/PUBLIC OUTREACH 38,878.75 0.00 1,526.07 2,330.55 35,022.13 9.91 42300 WIRELESS COMMUNICATION 54,392.05 3,148.21 18,375.41 0.00 36,016.64 33.78 42310 PHONES, FAX, ISDN LINES 12,103.00 965.14 5,555.72 0.00 6,547.28 45.90 42320 POSTAGE & SHIPPING 146,197.65 15,525.50 47,918.42 20,270.93 78,008.30 46.64 42340 OFFICE SUPPLIES 12,751.55 137.45 3,623.42 0.00 9,128.13 28.41 42345 FIRST AID KIT SUPPLIES 280.00 0.00 116.61 0.00 163.39 41.64 42350 PROGRAM EXPENDITURES 27,273.74 1,569.47 12,969.65 3,060.00 11,244.09 58.77 42360 CLEANING/JANITORIAL SUPPLIES 0.00 295.36 998.98 0.00 (998.98) 0.00 42410 ELECTRIC UTILITY 4,429,000.00 179,356.67 955.513.28 0.00 3,473,486.72 21.57 42420 NATURAL GAS UTILITY 1,040.40 58.34 268.77 0.00 771.63 25.83 42430 WATER UTILITY 53,060.40 5,520.92 30,254.46 0.00 22,805.94 57.01 42435 RECYCLED WATER UTILITY 13,292.64 834.32 11,638.02 0.00 1,654.62 87.55 42441 UNLEADED FUEL 6,360.00 0.00 2,596.49 0.00 3,763.51 40.82 42442 DIESEL FUEL 11,640.00 0.00 1,524.49 9,594.39 521.12 95.52 42443 OTHER FUELS 250.00 0.00 0.00 0.00 250.00 0.00
42500 RENTS & LEASES 765,715.00 189,949.57 381,415.85 0.00 384,299.15 49.81 42501 CUA LEASES 2,571,803.00 642,950.75 1,285,901.50 0.00 1,285,901.50 50.00 42600 MOTOR POOL RENTAL 230,116.35 207,559.35 207,559.35 0.00 22,557.00 90.19 42605 RETAINED VEHICLE EXPENSE 6,365.80 6,365.80 6,365.80 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 22,560.00 1,840.94 5,244.10 17,346.06 (30.16) 100.13 42700 OTHER EQUIPMENT RENTAL 50,256.62 2,027.48 11,470.01 15,427.43 23,359.18 53.52 42710 MILEAGE/VEHICLE EXP REIMB 1,515.00 0.00 416.55 0.00 1,098.45 27.49 42813 MTCE & REPAIR - EQUIP & FAC 940,460.63 (27,470.93) 77,228.86 702,100.51 161,131.26 82.86 42815 SCADA MAINTENANCE 269,887.50 40,196.48 123,777.26 192,952.36 (46,842.12) 117.35 42816 MOWING/LANDSCAPE CONTRACTS 127,705.36 6,792.36 49,373.24 7,894.01 70,438.11 44.84 42830 REBATE PROGRAMS 25,000.00 89.00 1,289.07 0.00 23,710.93 5.15 42900 PROF. & CONT. SVCS 2,553,001.50 180,178.77 816,318.64 1,345,274.71 391,408.15 84.66 42902 CUST CREDIT CRD PROCESSING FEE 230,710.60 36,966.67 97,915.73 30,386.33 102,408.54 55.61 User: KIMS Page: 10 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:14:33 Ledger: GL CONSOLIDATED EXPENDITURE REPORT - BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
43000 INSURANCE & SURETY BONDS 19,604.00 47,151.39 47,151.39 0.00 (27,547.39) 240.51 43100 MEMBERSHIP & DUES 213,845.82 5,000.00 49,184.00 0.00 164,661.82 23.00 43200 CONFERENCE, TRAINING & TRAVEL 44,380.00 1,074.98 4,242.38 0.00 40,137.62 9.55 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 30,887.75 169,112.25 (41,626.40) 126.28 43701 CHEMICALS-POLYMER 108,900.00 0.00 40,780.69 86,419.31 (18,300.00) 116.80 43702 CHEMICALS-ALUM 89,232.00 0.00 0.00 83,000.00 6,232.00 93.01 43703 CHEMICALS-AMMONIA 49,516.92 4,374.72 20,030.82 21,969.18 7,516.92 84.81 43704 CHEMICALS-ANTISCALANT 207,054.72 27,256.56 52,566.22 97,433.78 57,054.72 72.44 43705 CHEMICALS-SULFURIC ACID 171,600.00 15,443.87 68,619.38 113,559.75 (10,579.13) 106.16 43706 CHEMICALS-CAUSTIC SODA 40,700.00 0.00 4,492.10 35,507.90 700.00 98.28 43707 CHEMICALS-SODIUM 202,400.00 16,711.20 116,911.66 141,432.52 (55,944.18) 127.64 43711 CHEMICALS-MISC 79,054.56 0.00 14,328.31 65,671.69 (945.44) 101.19 43714 OUTSIDE LAB ANALYSIS 356,340.00 33,012.50 122,719.40 179,585.60 54,035.00 84.83 43715 REGULATORY PERMIT & USE FEES 142,411.00 1,605.63 12,320.00 0.00 130,091.00 8.65 43716 JOB REQ CERTIFICATES & LICENSE 2,410.00 0.00 440.00 0.00 1,970.00 18.25 43717 RAW WATER PURCHASES 14,004,702.00 1,093,317.59 7,823,930.20 0.00 6,180,771.80 55.86 43718 TREATED WATER PURCHASES 3,043,045.00 16,172.10 424,616.86 0.00 2,618,428.14 13.95 43720 LAB CHEMICALS AND SUPPLIES 44,184.00 115.66 17,106.88 45,596.70 (18,519.58) 141.91 43722 PREVENTION & MAINTENANCE 1,763,006.70 91,960.72 233,125.58 1,230,264.81 299,616.31 83.00 43723 INLAND EMPIRE BRINE LINE-SARI 1,877,058.42 126,246.62 615,069.66 0.00 1,261,988.76 32.76 43726 PROJECT MANAGEMENT 0.00 4,959.00 9,395.00 0.00 (9,395.00) 0.00 43731 CARBON DIOXIDE 29,474.53 2,397.94 10,362.52 31,637.48 (12,525.47) 142.49 44100 INTEREST EXPENSE 715,914.00 0.00 (33,713.60) 0.00 749,627.60 (4.70) 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 666,179.50 1,332,359.00 0.00 1,332,359.00 50.00 44613 INTERNAL SVC CHRG-WAREHOUSE 268,485.00 67,121.25 134,242.50 0.00 134,242.50 50.00 44614 INTERNAL SVC CHRG-INFO TECH 1,961,892.00 490,473.00 980,946.00 0.00 980,946.00 50.00 TOTAL FOR SERVICES-SUPPLIES 43,081,406.64 4,288,090.57 16,784,195.38 5,070,682.62 21,226,528.64 50.72
CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 102,271.82 0.00 21,232.61 224,226.42 (143,187.21) 240.00 TOTAL FOR CAPITAL OUTLAY 102,271.82 0.00 21,232.61 224,226.42 (143,187.21) 240.00 TOTAL FOR WATER UTILITY SERVICES 51,841,429.93 4,929,316.15 20,222,579.80 5,294,909.04 26,323,941.09 49.22 FUN 570 95,153,421.22 5,813,212.43 23,121,738.65 10,505,817.80 61,525,864.77 35.34 User: KIMS Page: 11 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:14:33 Ledger: GL CONSOLIDATED EXPENDITURE REPORT-BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YID : Encumbrances (Over)/Under Used
571 WATER UTILITY GRANT/AGREEMENT
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 474.60 3,762.08 0.00 (3,762.08) 0.00 41600 LONGEVITY 0.00 0.00 18.48 0.00 (18.48) 0.00
41910 PERS-NORMAL 0.00 54.06 430.59 0.00 (430.59) 0.00
41920 MEDICARE 0.00 14.00 112.11 0.00 (112.11) 0.00
41929 SHORT TERM DISABILITY 0.00 0.00 0.99 0.00 (0.99) 0.00 41930 LONG TERM DISABILITY 0.00 0.00 2.10 0.00 (2.10) 0.00 41931 WORKERS COMP 0.00 9.49 76.34 0.00 (76.34) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.23 1.93 0.00 (1.93) 0.00 41946 LIFE INSURANCE 0.00 0.00 2.55 0.00 (2.55) 0.00
TOTAL FOR SALARIES-BENEFITS 0.00 552.38 4,407.17 0.00 (4,407.17) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 4,414,212.13 0.00 0.00 0.00 4,414,212.13 0.00 42200 ADVERTISING EXPENSE 0.00 0.00 239.01 0.00 (239.01) 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 250.00 0.00 (250.00) 0.00 42900 PROF. & CONT. SVCS 28,938.30 46,400.00 139,207.14 28,369.24 (138,638.08) 579.08 42902 CUST CREDIT CRD PROCESSING FEE 0.00 0.00 0.00 25,000.00 (25,000.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 4,443,150.43 46,400.00 139,696.15 53,369.24 4,250,085.04 4.34 TOTAL FOR NOT APPLICABLE 4,443,150.43 46,952.38 144,103.32 53,369.24 4,245,677.87 4.44 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,443,150.43 46,952.38 144,103.32 53,369.24 4,245,677.87 4.44 User: KIMS Page: 12 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:14:33 Ledger: GL CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT Fiscal Year: 2022 Level: OB 12/31/2021 Fiscal Period: 06
Expenditures Balance %
Budget Month to YTD Encumbrances (Over)/Under Used
GRAND TOTAL 111,392,332.03 6,086,889.12 27,140,161.17 11,886,507.08 72,365,663.78 35.03 User: KIMS Page: 13 Current Date: 01/21/2022
Report: GREREES_Consolidated_Expenditure_Report Current Time: 12:14:33