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
440 WATER RECN CAPACITY GEN SRVC
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 955.80 3,161.46 0.00 (3,161.46) 0.00 41141 SP COMP-BILINGUAL 0.00 22.69 86.67 0.00 (86.67) 0.00 41910 PERS-NORMAL 0.00 111.46 353.32 0.00 (353.32) 0.00 41920 MEDICARE 0.00 29.14 91.85 0.00 (91.85) 0.00
41931 WORKERS COMP 0.00 19.56 61.94 0.00 (61.94) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.50 1.57 0.00 (1.57) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 1,139.15 3,756.81 0.00 (3,756.81) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 144,390.66 0.00 0.00 0.00 144,390.66 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 50.00 0.00 (50.00) 0.00 42900 PROF. & CONT. SVCS 800.00 0.00 0.00 2,800.00 (2,000.00) 350.00 TOTAL FOR SERVICES-SUPPLIES 145,190.66 0.00 50.00 2,800.00 142,340.66 1.96 TOTAL FOR NOT APPLICABLE 145,190.66 1,139.15 3,806.81 2,800.00 138,583.85 4.55 51 WATER RECLAMATIONS
SERVICES-SUPPLIES
44100 INTEREST EXPENSE 144,362.00 0.00 25,143.56 0.00 119,218.44 17.41 44610 ADMINISTRATIVE SERVICES CHARGE 6,520.00 1,630.00 3,260.00 0.00 3,260.00 50.00 TOTAL FOR SERVICES-SUPPLIES 150,882.00 1,630.00 28,403.56 0.00 122,478.44 18.82 TOTAL FOR WATER RECLAMATIONS 150,882.00 1,630.00 28,403.56 0.00 122,478.44 18.82 FUN 440 296,072.66 2,769.15 32,210.37 2,800.00 261,062.29 11.82 User: KIMS Page: 1 Current Date: 01/21/2022
Report: GREREES_Consolidated_Expenditure_Report Current Time: 12:16:12 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
454 2013 Wastewater Revenue Bonds
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 454 0.00 0.00 0.00 0.00 0.00 0.00
User: KIMS Page: 2 Current Date: 01/21/2022
Report: GREREES_Consolidated_Expenditure_Report Current Time: 12:16:12 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
572 WATER RECLAMATION UTILITY FUND
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 8,640.40 43,851.91 0.00 (43,851.91) 0.00 41141 SP COMP-BILINGUAL 0.00 8.22 32.82 0.00 (32.82) 0.00 41910 PERS-NORMAL 0.00 985.06 4,998.47 0.00 (4,998.47) 0.00 41920 MEDICARE 0.00 257.37 1,299.28 0.00 (1,299.28) 0.00 41929 SHORT TERM DISABILITY 0.00 0.00 10.88 0.00 (10.88) 0.00 41931 WORKERS COMP 0.00 172.98 874.29 0.00 (874.29) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 4.39 22.18 0.00 (22.18) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 10,068.42 51,089.83 0.00 (51,089.83) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 21,156,876.89 0.00 0.00 0.00 21,156,876.89 0.00 42033 CONSTRUCTION MATERIALS 13,500.00 9,068.32 60,514.61 29,815.80 (76,830.41) 669.11 42200 ADVERTISING EXPENSE 0.00 1,069.12 1,232.88 0.00 (1,232.88) 0.00 42350 PROGRAM EXPENDITURES 0.00 0.00 50.00 0.00 (50.00) 0.00 42800 EQUIPMENT MAINTENANCE 29,757.20 0.00 0.00 29,757.20 0.00 100.00 42815 SCADA MAINTENANCE 43,956.00 12,008.00 26,115.50 110,015.30 (92,174.80) 309.69 42900 PROF. & CONT. SVCS 419,501.34 6,650.13 143,160.26 774,920.11 (498,579.03) 218.85 43300 CONSTRUCTION CONTRACTS 5,583,805.62 393,883.07 1,935,812.21 4,137,157.96 (489,164.55) 108.76 43301 CAPITAL IMPROVEMENTS 79,600.00 0.00 6,250.00 258,350.00 (185,000.00) 332.41 43715 REGULATORY PERMIT & USE FEES 0.00 0.00 3,079.71 0.00 (3,079.71) 0.00 43726 PROJECT MANAGEMENT 370,338.25 37,217.00 191,524.25 198,616.00 (19,802.00) 105.34 43727 INSPECTION 34.64 0.00 0.00 0.00 34.64 0.00
TOTAL FOR SERVICES-SUPPLIES 27,697,369.94 459,895.64 2,367,739.42 5,538,632.37 19,790,998.15 28.54
CAPITAL OUTLAY
45100 LICENSED VEHICLES 26,006.85 0.00 69,072.52 26,006.85 (69,072.52) 365.59 45200 MACHINERY, EQUIPMENT, & FIXTUR 670,617.36 501,799.60 501,799.60 930,464.76 (761,647.00) 213.57 TOTAL FOR CAPITAL OUTLAY 696,624.21 501,799.60 570,872.12 956,471.61 (830,719.52) 219.24 TOTAL FOR NOT APPLICABLE 28,393,994.15 971,763.66 2,989,701.37 6,495,103.98 18,909,188.80 33.40 11 CITY MANAGER'S OFFICE
SALARIES-BENEFITS
41200 TEMPORARY EMPLOYEES 2,849.60 150.94 984.59 0.00 1,865.01 34.55 41510 PST DEFERRED COMPENSATION 37.04 1.97 12.82 0.00 24.22 34.61 41920 MEDICARE 41.32 2.22 14.46 0.00 26.86 34.99
41931 WORKERS COMP 56.99 3.02 19.70 0.00 37.29 34.56
41932 STATE UNEMPLOYMENT INSURANCE 1.42 0.08 0.50 0.00 0.92 35.21 41996 VACANCY FACTOR (60.00) 0.00 0.00 0.00 (60.00) 0.00 TOTAL FOR SALARIES-BENEFITS 2,926.37 158.23 1,032.07 0.00 1,894.30 35.26 User: KIMS Page: 3 Current Date: 01/21/2022
Report: GREREES Consolidated Expenditure Report Current Time: 12:16:12 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 CITY MANAGER'S OFFICE 2,926.37 158.23 1,032.07 0.00 1,894.30 35.26 18 ADMIN SERVICES-FINANCE
SALARIES-BENEFITS
41912 PERS-UNFUNDED 12,013.00 0.00 3,106.53 0.00 8,906.47 25.85 TOTAL FOR SALARIES-BENEFITS 12,013.00 0.00 3,106.53 0.00 8,906.47 25.85 TOTAL FOR ADMIN SERVICES-FINANCE 12,013.00 0.00 3,106.53 0.00 8,906.47 25.85 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 343,344.50 20,872.68 95,289.77 0.00 248,054.73 27.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 17.48 156.20 0.00 (156.20) 0.00 41140 FINAL LEAVE 0.00 0.00 2,760.94 0.00 (2,760.94) 0.00 41141 SP COMP-BILINGUAL 2,603.95 121.62 415.87 0.00 2,188.08 15.97 41200 TEMPORARY EMPLOYEES 15,131.58 1,417.06 6,457.42 0.00 8,674.16 42.67 41300 OVERTIME 500.00 147.48 635.81 0.00 (135.81) 127.16 41400 SPECIAL DUTY PAY 2,670.00 334.92 1,720.00 0.00 950.00 64.41 41410 AUTO ALLOWANCE 576.00 66.46 292.77 0.00 283.23 50.82 41500 DEFERRED COMPENSATION MATCH 2,435.00 0.00 114.00 0.00 2,321.00 4.68 41510 PST DEFERRED COMPENSATION 196.71 18.42 83.95 0.00 112.76 42.67 41520 TIERED EMP DEF COMPENSATION 930.00 202.50 434.52 0.00 495.48 46.72 41530 TIERED RHS BENEFIT 730.00 172.50 354.84 0.00 375.16 48.60 41600 LONGEVITY 2,300.26 19.84 2,038.12 0.00 262.14 88.60 41630 ONE TIME MOU PAYMENTS 5,463.26 0.00 5,463.26 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 11,190.77 0.00 11,759.55 0.00 (568.78) 105.08 41710 ANNUAL LEAVE OVER MAX 1,315.00 0.00 0.00 0.00 1,315.00 0.00 41910 PERS-NORMAL 39,665.78 2,398.06 11,140.61 0.00 28,525.17 28.08 41912 PERS-UNFUNDED 100,638.00 0.00 26,025.15 0.00 74,612.85 25.86 41920 MEDICARE 11,500.82 654.89 3,608.13 0.00 7,892.69 31.37 41929 SHORT TERM DISABILITY 1,098.70 103.47 462.90 0.00 635.80 42.13 41930 LONG TERM DISABILITY 2,334.74 219.55 985.52 0.00 1,349.22 42.21 41931 WORKERS COMP 7,229.00 439.04 1,971.00 0.00 5,258.00 27.26 41932 STATE UNEMPLOYMENT INSURANCE 193.18 11.40 62.96 0.00 130.22 32.59 41940 HEALTH INSURANCE 58,505.94 3,825.25 24,087.90 0.00 34,418.04 41.17 41945 OPT OUT HEALTH INSURANCE 2,730.00 346.25 2,208.71 0.00 521.29 80.90 41946 LIFE INSURANCE 2,849.75 267.95 1,202.72 0.00 1,647.03 42.20 41996 VACANCY FACTOR (16,893.00) 0.00 0.00 0.00 (16,893.00) 0.00 41997 BUDGETARY/PAYROLL 300.00 0.00 0.00 0.00 300.00 0.00 TOTAL FOR SALARIES-BENEFITS 599,539.94 31,679.15 199,805.66 0.00 399,734.28 33.32 User: KIMS 4 Current Date: 01/21/2022
Report: OUREREES. Consolidated Expenditure Report: Current Time: 12:16:12 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
SERVICES-SUPPLIES
42055 COMPUTER EQUIPMENT & 18,383.39 0.00 0.00 4,683.39 13,700.00 25.47 42101 SAFETY SHOES - MOU ITEM 1,063.62 0.00 0.00 0.00 1,063.62 0.00 43100 MEMBERSHIP & DUES 3,468.00 0.00 1,565.53 0.00 1,902.47 45.14 43200 CONFERENCE, TRAINING & TRAVEL 0.00 0.00 455.00 0.00 (455.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 22,915.01 0.00 2,020.53 4,683.39 16,211.09 29.25 TOTAL FOR PUBLIC WORKS 622,454.95 31,679.15 201,826.19 4,683.39 415,945.37 33.17 51 WATER RECLAMATIONS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,548,805.64 264,491.87 1,158,123.60 0.00 1,390,682.04 45.43 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 1,523.08 0.00 (1,523.08) 0.00 41102 SHIFT DIFFERENTIAL 40,000.00 4,821.90 22,051.64 0.00 17,948.36 55.12 41103 OUT OF CLASS PAY 0.00 246.72 246.72 0.00 (246.72) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 5,705.57 12,502.01 0.00 (12,502.01) 0.00 41140 FINAL LEAVE 0.00 0.00 1,408.85 0.00 (1,408.85) 0.00 41141 SP COMP-BILINGUAL 6,894.93 703.71 3,242.22 0.00 3,652.71 47.02 41147 SP COMP-GRADE 4 CERT PAY 40,980.00 5,766.96 23,744.22 0.00 17,235.78 57.94 41148 SP COMP-GRADE 5 CERT PAY 65,364.00 6,206.52 26,113.95 0.00 39,250.05 39.95 41200 TEMPORARY EMPLOYEES 26,112.23 0.00 2,734.83 0.00 23,377.40 10.47 41300 OVERTIME 385,626.00 46,487.18 177,802.14 0.00 207,823.86 46.10 41320 COMP TIME 0.00 0.00 59.11 0.00 (59.11) 0.00
41400 SPECIAL DUTY PAY 44,772.00 4,962.02 24,337.03 0.00 20,434.97 54.35 41410 AUTO ALLOWANCE 1,772.40 93.06 407.69 0.00 1,364.71 23.00 41500 DEFERRED COMPENSATION MATCH 18,140.00 304.71 1,174.96 0.00 16,965.04 6.47 41510 PST DEFERRED COMPENSATION 112.35 0.00 0.00 0.00 112.35 0.00 41520 TIERED EMP DEF COMPENSATION 11,424.00 2,706.40 5,562.40 0.00 5,861.60 48.69 41530 TIERED RHS BENEFIT 5,652.00 1,363.00 2,776.00 0.00 2,876.00 49.11 41600 LONGEVITY 18,931.43 516.97 19,717.36 0.00 (785.93) 104.15 41630 ONE TIME MOU PAYMENTS 40,770.84 0.00 40,770.84 0.00 0.00 100.00 41660 TUITION REIMBURSEMENT 2,500.00 0.00 1,645.00 0.00 855.00 65.80 41700 ANNUAL LEAVE BUYBACK 40,908.20 0.00 42,063.78 0.00 (1,155.58) 102.82 41710 ANNUAL LEAVE OVER MAX 2,905.00 0.00 0.00 0.00 2,905.00 0.00 41910 PERS-NORMAL 307,826.22 34,159.89 146,440.58 0.00 161,385.64 47.57 41912 PERS-UNFUNDED 758,057.00 0.00 196,035.12 0.00 562,021.88 25.86 41920 MEDICARE 100,493.06 10,184.07 46,420.23 0.00 54,072.83 46.19 41929 SHORT TERM DISABILITY 8,155.97 846.60 3,697.51 0.00 4,458.46 45.33 41930 LONG TERM DISABILITY 17,332.07 1,812.88 7,866.59 0.00 9,465.48 45.38 41931 WORKERS COMP 54,928.91 5,604.62 24,394.86 0.00 30,534.05 44.41 41932 STATE UNEMPLOYMENT INSURANCE 1,671.17 172.72 792.31 0.00 878.86 47.41 41940 HEALTH INSURANCE 363,463.20 28,647.54 169,389.29 0.00 194,073.91 46.60 User: KIMS Page: 5 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:16:12 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
41941 RETIREES HEALTH INSURANCE/OPEB 416,537.00 0.00 0.00 0.00 416,537.00 0.00 41945 OPT OUT HEALTH INSURANCE 82,818.00 6,018.99 36,950.69 0.00 45,867.31 44.61 41946 LIFE INSURANCE 21,155.54 2,212.73 9,601.88 0.00 11,553.66 45.38 41996 VACANCY FACTOR (287,732.00) 0.00 0.00 0.00 (287,732.00) 0.00 41997 BUDGETARY/PAYROLL (41,335.00) 0.00 0.00 0.00 (41,335.00) 0.00 TOTAL FOR SALARIES-BENEFITS 5,105,042.16 434,036.63 2,209,596.49 0.00 2,895,445.67 43.28
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 25,126.00 2,213.58 25,172.46 0.00 (46.46) 100.18 42033 CONSTRUCTION MATERIALS 1,278,099.68 67,788.85 444,439.27 422,794.58 410,865.83 67.85 42034 SAFETY MATERIALS/CONSTRUCTION 12,661.00 1,049.70 7,238.92 0.00 5,422.08 57.17 42055 COMPUTER EQUIPMENT & 31,737.47 488.86 17,914.02 1,406.80 12,416.65 60.87 42100 UNIFORM EXPENSE 11,826.28 848.69 3,665.33 0.00 8,160.95 30.99 42101 SAFETY SHOES - MOU ITEM 4,087.00 175.00 175.00 0.00 3,912.00 4.28 42200 ADVERTISING EXPENSE 2,541.00 228.73 1,704.04 0.00 836.96 67.06 42220 PROMOTIONAL/PUBLIC OUTREACH 17,671.13 0.00 516.57 2,660.57 14,493.99 17.97 42300 WIRELESS COMMUNICATION 20,691.44 1,533.72 8,521.35 0.00 12,170.09 41.18 42310 PHONES, FAX, ISDN LINES 12,059.00 881.00 5,385.16 0.00 6,673.84 44.65 42320 POSTAGE & SHIPPING 122,606.91 13,548.81 41,443.28 17,218.16 63,945.47 47.84 42340 OFFICE SUPPLIES 10,305.30 36.89 2,995.35 0.00 7,309.95 29.06 42345 FIRST AID KIT SUPPLIES 220.00 0.00 123.03 0.00 96.97 55.92 42350 PROGRAM EXPENDITURES 15,713.37 372.24 3,745.26 2,390.00 9,578.11 39.04 42360 CLEANING/JANITORIAL SUPPLIES 0.00 168.32 517.78 0.00 (517.78) 0.00 42410 ELECTRIC UTILITY 1,734,412.16 109,004.24 765,336.93 0.00 969,075.23 44.12 42420 NATURAL GAS UTILITY 195,840.00 6,240.91 28,113.10 0.00 167,726.90 14.35 42430 WATER UTILITY 38,400.00 3,672.08 22,024.08 0.00 16,375.92 57.35 42435 RECYCLED WATER UTILITY 897,009.71 41,877.49 302,343.50 0.00 594,666.21 33.70 42441 UNLEADED FUEL 3,300.16 0.00 2,095.36 0.00 1,204.80 63.49 42442 DIESEL FUEL 19,000.00 0.00 4,707.70 15,292.30 (1,000.00) 105.26 42443 OTHER FUELS 60.00 0.00 0.00 0.00 60.00 0.00
42500 RENTS & LEASES 847,183.72 188,064.93 376,704.25 0.00 470,479.47 44.46 42501 CUA LEASES 1,730,689.00 432,672.25 865,344.50 0.00 865,344.50 50.00 42600 MOTOR POOL RENTAL 112,504.61 85,391.61 85,391.61 0.00 27,113.00 75.90 42605 RETAINED VEHICLE EXPENSE 4,775.68 4,775.68 4,775.68 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 15,522.00 0.00 3,316.80 7,430.92 4,774.28 69.24 42700 OTHER EQUIPMENT RENTAL 46,839.16 0.00 6,517.22 26,891.58 13,430.36 71.32 42710 MILEAGE/VEHICLE EXP REIMB 525.00 0.00 0.00 0.00 525.00 0.00 42800 EQUIPMENT MAINTENANCE 0.00 0.00 83.09 0.00 (83.09) 0.00 42813 MTCE & REPAIR - EQUIP & FAC 702,491.56 48,597.05 139,005.00 448,139.13 115,347.43 83.58 42815 SCADA MAINTENANCE 254,087.50 29,290.19 92,817.27 176,125.91 (14,855.68) 105.84 42816 MOWING/LANDSCAPE CONTRACTS 74,628.94 4,615.96 43,990.37 135.00 30,503.57 59.12 User: KIMS Page: 6 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:16:12 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
42900 PROF. & CONT. SVCS 1,043,924.20 191,338.99 470,581.45 568,526.12 4,816.63 99.53 42902 CUST CREDIT CRD PROCESSING FEE 208,091.91 33,342.49 70,572.56 27,407.27 110,112.08 47.08 42910 REFUSE DISPOSAL 72,000.00 1,442.48 25,681.95 0.00 46,318.05 35.66 43000 INSURANCE & SURETY BONDS 19,604.00 47,151.38 47,151.38 0.00 (27,547.38) 240.51 43100 MEMBERSHIP & DUES 36,837.00 0.00 9,021.00 0.00 27,816.00 24.48 43200 CONFERENCE, TRAINING & TRAVEL 34,340.00 30.00 8,355.33 0.00 25,984.67 24.33 43400 LEGAL SERVICES-SPECIAL COUNSEL 5,000.00 0.00 0.00 0.00 5,000.00 0.00 43697 CHEMICALS-NITROGEN 11,836.08 699.73 4,361.86 4,038.14 3,436.08 70.96 43698 CHEMICALS-SODIUM BISOLFITE 44,843.28 14,536.11 23,638.72 21,361.28 (156.72) 100.34 43700 CHEMICALS-MINERAL OIL 28,049.73 0.00 0.00 0.00 28,049.73 0.00 43701 CHEMICALS-POLYMER 414,874.27 0.00 282,691.17 305,308.83 (173,125.73) 141.72 43707 CHEMICALS-SODIUM 1,047,240.00 103,888.26 477,903.37 1,064,952.94 (495,616.31) 147.32 43709 CHEMICALS-FERRIC CHLORIDE 85,807.50 6,062.22 12,664.34 87,335.66 (14,192.50) 116.53 43711 CHEMICALS-MISC 23,090.76 2,929.45 2,929.45 20,000.00 161.31 99.30 43713 BIOSOLIDS DISPOSAL/RECYCLE 1,589,346.00 68,378.98 426,928.51 1,473,823.49 (311,406.00) 119.59 43714 OUTSIDE LAB ANALYSIS 548,677.00 33,411.50 178,713.75 287,991.25 81,972.00 85.06 43715 REGULATORY PERMIT & USE FEES 206,406.00 476.59 21,789.15 0.00 184,616.85 10.55 43716 JOB REQ CERTIFICATES & LICENSE 1,735.00 0.00 127.88 0.00 1,607.12 7.37 43720 LAB CHEMICALS AND SUPPLIES 33,600.00 1,200.72 11,278.37 3,185.58 19,136.05 43.04 43722 PREVENTION & MAINTENANCE 1,174,095.32 61,278.31 349,134.54 717,243.76 107,717.02 90.82 43723 INLAND EMPIRE BRINE LINE-SARI 7,140.00 0.00 (24,968.21) 0.00 32,108.21 (349.69) 43726 PROJECT MANAGEMENT 0.00 2,762.80 6,508.80 0.00 (6,508.80) 0.00 43728 WRCRWA CAP ASSET CONTRIBUTION 994,916.00 11,382.55 11,382.55 0.00 983,533.45 1.14 43729 WRCRWA TRTMNT/CONVEYANCE 2,242,644.00 (2,226.19) 632,928.11 0.00 1,609,715.89 28.22 44100 INTEREST EXPENSE 448,206.00 0.00 77,148.11 0.00 371,057.89 17.21 44200 BAD DEBTS EXPENSE 455,684.00 0.00 0.00 0.00 455,684.00 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 1,509,493.00 377,373.25 754,746.50 0.00 754,746.50 50.00 44613 INTERNAL SVC CHRG-WAREHOUSE 57,150.00 14,287.50 28,575.00 0.00 28,575.00 50.00 44614 INTERNAL SVC CHRG-INFO TECH 1,548,758.00 387,189.50 774,379.00 0.00 774,379.00 50.00 TOTAL FOR SERVICES-SUPPLIES 22,136,003.83 2,400,473.40 7,990,347.92 5,701,659.27 8,443,996.64 61.85
CAPITAL OUTLAY
45100 LICENSED VEHICLES 439,290.00 0.00 0.00 0.00 439,290.00 0.00 TOTAL FOR CAPITAL OUTLAY 439,290.00 0.00 0.00 0.00 439,290.00 0.00 TOTAL FOR WATER RECLAMATIONS 27,680,335.99 2,834,510.03 10,199,944.41 5,701,659.27 11,778,732.31 57.44 FUN 572 56,711,724.46 3,838,111.07 13,395,610.57 12,201,446.64 31,114,667.25 45.13 User: KIMS 7 Current Date: 01/21/2022
Current Time: 12:16:12
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
573 WATER RECLAMATION GRANT/AGRMT
NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 254.91 254.91 0.00 (254.91) 0.00 41910 PERS-NORMAL 0.00 29.04 29.04 0.00 (29.04) 0.00
41920 MEDICARE 0.00 7.53 7.53 0.00 (7.53) 0.00
41931 WORKERS COMP 0.00 5.10 5.10 0.00 (5.10) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.14 0.14 0.00 (0.14) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 296.72 296.72 0.00 (296.72) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 189,020.98 0.00 0.00 0.00 189,020.98 0.00 TOTAL FOR SERVICES-SUPPLIES 189,020.98 0.00 0.00 0.00 189,020.98 0.00 TOTAL FOR NOT APPLICABLE 189,020.98 296.72 296.72 0.00 188,724.26 0.15 51 WATER RECLAMATIONS
SALARIES-BENEFITS
TOTAL FOR SALARIES-BENEFITS 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FOR WATER RECLAMATIONS 0.00 0.00 0.00 0.00 0.00 0.00 FUN 573 189,020.98 296.72 296.72 0.00 188,724.26 0.15
User: KIMS Page: 8 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:16:12 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
GRAND TOTAL 57,196,818.10 3,841,176.94_13,428,117.66 _12,204,246.64 31,564,453.80 44.81 User: KIMS Page: 9 Current Date: 01/21/2022
Report: GREREES_Consolidated_Expenditure_Report Current Time: 12:16:12