GL
03/31/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 09
Ledger:
Level:
Month to
440 WATER RECN CAPACITY GEN SRVC
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 508.46 5,332.24 0.00 (5,332.24) 0.00 41141 SP COMP-BILINGUAL 0.00 13.93 147.38 0.00 (147.38) 0.00 41910 PERS-NORMAL 0.00 59.49 607.49 0.00 (607.49) 0.00
41920 MEDICARE 0.00 15.40 157.80 0.00 (157.80) 0.00
41931 WORKERS COMP 0.00 10.46 106.59 0.00 (106.59) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.28 2.72 0.00 (2.72) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 608.02 6,354.22 0.00 (6,354.22) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 1,144,390.66 0.00 0.00 0.00 1,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 3,760.00 3,760.00 2,800.00 (5,760.00) 820.00 TOTAL FOR SERVICES-SUPPLIES 1,145,190.66 3,760.00 3,810.00 2,800.00 1,138,580.66 0.57 TOTAL FOR NOT APPLICABLE 1,145,190.66 4,368.02 10,164.22 2,800.00 1,132,226.44 1.13 51 WATER RECLAMATIONS
SERVICES-SUPPLIES
44100 INTEREST EXPENSE 144,362.00 69,749.00 94,892.56 0.00 49,469.44 65.73 44610 ADMINISTRATIVE SERVICES CHARGE 6,520.00 1,630.00 4,890.00 0.00 1,630.00 75.00 TOTAL FOR SERVICES-SUPPLIES 150,882.00 71,379.00 99,782.56 0.00 51,099.44 66.13 TOTAL FOR WATER RECLAMATIONS 150,882.00 71,379.00 99,782.56 0.00 51,099.44 66.13 FUN 440 1,296,072.66 75,747.02 109,946.78 2,800.00 1,183,325.88 8.69 KIMS Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/23/2022
Current Time: 14:05:36
User:
Report:
GL
03/31/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 09
Ledger:
Level:
Month to
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
KIMS Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/23/2022
Current Time: 14:05:36
User:
Report:
GL
03/31/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 09
Ledger:
Level:
Month to
572 WATER RECLAMATION UTILITY FUND
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 4,878.06 61,238.63 0.00 (61,238.63) 0.00 41141 SP COMP-BILINGUAL 0.00 5.48 49.49 0.00 (49.49) 0.00 41910 PERS-NORMAL 0.00 556.24 6,980.71 0.00 (6,980.71) 0.00 41920 MEDICARE 0.00 152.04 1,821.07 0.00 (1,821.07) 0.00 41929 SHORT TERM DISABILITY 0.00 0.95 12.78 0.00 (12.78) 0.00 41931 WORKERS COMP 0.00 102.90 1,225.56 0.00 (1,225.56) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 2.58 31.08 0.00 (31.08) 0.00 41940 HEALTH INSURANCE 0.00 220.40 220.40 0.00 (220.40) 0.00 41951 HEALTH ALLOWANCE CREDIT 0.00 61.84 61.84 0.00 (61.84) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 5,980.49 71,641.56 0.00 (71,641.56) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 24,933,872.53 0.00 0.00 0.00 24,933,872.53 0.00 42033 CONSTRUCTION MATERIALS 13,500.00 0.00 61,113.77 29,216.64 (76,830.41) 669.11 42200 ADVERTISING EXPENSE 0.00 0.00 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 4,974.67 4,974.67 24,782.53 0.00 100.00 42815 SCADA MAINTENANCE 43,956.00 2,733.30 66,083.26 73,213.54 (95,340.80) 316.90 42900 PROF. & CONT. SVCS 419,501.34 33,717.02 370,597.69 556,663.59 (507,759.94) 221.03 43300 CONSTRUCTION CONTRACTS 5,583,805.62 74,800.00 2,539,791.20 3,577,128.97 (533,114.55) 109.54 43301 CAPITAL IMPROVEMENTS 79,600.00 6,843.30 151,210.24 134,942.76 (206,553.00) 359.48 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 26,197.50 264,183.00 173,057.25 (66,902.00) 118.06 43727 INSPECTION 34.64 0.00 0.00 0.00 34.64 0.00
TOTAL FOR SERVICES-SUPPLIES 31,474,365.58 149,265.79 3,462,316.42 4,569,005.28 23,443,043.88 25.51
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 33,620.43 535,420.03 1,311,844.33 (1,176,647.00) 275.45 TOTAL FOR CAPITAL OUTLAY 696,624.21 33,620.43 604,492.55 1,337,851.18 (1,245,719.52) 278.82 TOTAL FOR NOT APPLICABLE 32,170,989.79 188,866.71 4,138,450.53 5,906,856.46 22,125,682.80 31.22 11 CITY MANAGER'S OFFICE
SALARIES-BENEFITS
41200 TEMPORARY EMPLOYEES 2,849.60 145.90 1,394.78 0.00 1,454.82 48.94 41510 PST DEFERRED COMPENSATION 37.04 1.89 18.14 0.00 18.90 48.97 41920 MEDICARE 41.32 2.15 20.49 0.00 20.83 49.58
41931 WORKERS COMP 56.99 2.92 27.91 0.00 29.08 48.97
41932 STATE UNEMPLOYMENT INSURANCE 1.42 0.07 0.70 0.00 0.72 49.29 41996 VACANCY FACTOR (60.00) 0.00 0.00 0.00 (60.00) 0.00 KIMS Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/23/2022
Current Time: 14:05:36
User:
Report:
GL
03/31/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 09
Ledger:
Level:
Month to
TOTAL FOR SALARIES-BENEFITS 2,926.37 152.93 1,462.02 0.00 1,464.35 49.96 TOTAL FOR CITY MANAGER'S OFFICE 2,926.37 152.93 1,462.02 0.00 1,464.35 49.96 13 DEBT SERVICE
SALARIES-BENEFITS
41912 PERS-UNFUNDED 0.00 0.00 12,208,004.00 0.00 (12,208,004.00) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 0.00 12,208,004.00 0.00 (12,208,004.00) 0.00
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 0.00 0.00 48,010.74 0.00 (48,010.74) 0.00 TOTAL FOR SERVICES-SUPPLIES 0.00 0.00 48,010.74 0.00 (48,010.74) 0.00 TOTAL FOR DEBT SERVICE 0.00 0.00 12,256,014.74 0.00 (12,256,014.74) 0.00 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,795.50 14,607.99 136,745.05 0.00 207,050.45 39.77 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 22.33 0.00 (22.33) 0.00 41103 OUT OF CLASS PAY 0.00 31.60 127.73 0.00 (127.73) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 0.00 177.34 0.00 (177.34) 0.00 41140 FINAL LEAVE 0.00 10,184.88 13,058.54 0.00 (13,058.54) 0.00 41141 SP COMP-BILINGUAL 2,603.95 98.65 641.56 0.00 1,962.39 24.63 41200 TEMPORARY EMPLOYEES 15,043.58 902.35 9,448.56 0.00 5,595.02 62.80 41300 OVERTIME 500.00 14.65 844.77 0.00 (344.77) 168.95 41400 SPECIAL DUTY PAY 2,670.00 152.47 2,319.03 0.00 350.97 86.85 41410 AUTO ALLOWANCE 576.00 44.30 425.69 0.00 150.31 73.90 41500 DEFERRED COMPENSATION MATCH 2,435.00 927.55 1,041.55 0.00 1,393.45 42.77 41510 PST DEFERRED COMPENSATION 195.71 11.73 122.83 0.00 72.88 62.76 41520 TIERED EMP DEF COMPENSATION 930.00 202.50 637.02 0.00 292.98 68.49 41530 TIERED RHS BENEFIT 730.00 172.50 527.34 0.00 202.66 72.23 41600 LONGEVITY 2,300.26 278.80 2,332.19 0.00 (31.93) 101.38 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 451.73 0.00 863.27 34.35 41910 PERS-NORMAL 39,716.78 1,706.85 15,921.64 0.00 23,795.14 40.08 41912 PERS-UNFUNDED 100,638.00 0.00 26,025.15 0.00 74,612.85 25.86 41920 MEDICARE 11,512.82 828.38 5,262.52 0.00 6,250.30 45.71 KIMS Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/23/2022
Current Time: 14:05:36
User:
Report:
GL
03/31/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 09
Ledger:
Level:
Month to
41929 SHORT TERM DISABILITY 1,099.70 65.19 665.72 0.00 433.98 60.53 41930 LONG TERM DISABILITY 2,337.74 138.70 1,417.15 0.00 920.59 60.62 41931 WORKERS COMP 7,236.00 328.96 2,851.83 0.00 4,384.17 39.41 41932 STATE UNEMPLOYMENT INSURANCE 193.18 13.87 91.40 0.00 101.78 47.31 41940 HEALTH INSURANCE 58,505.94 5,274.50 37,243.33 0.00 21,262.61 63.65 41945 OPT OUT HEALTH INSURANCE 2,730.00 339.51 3,328.22 0.00 (598.22) 121.91 41946 LIFE INSURANCE 2,853.75 169.28 1,729.47 0.00 1,124.28 60.60 41951 HEALTH ALLOWANCE CREDIT 0.00 348.77 348.77 0.00 (348.77) 0.00 41996 VACANCY FACTOR (16,893.00) 0.00 0.00 0.00 (16,893.00) 0.00 41997 BUDGETARY/PAYROLL (142.00) 0.00 0.00 0.00 (142.00) 0.00 TOTAL FOR SALARIES-BENEFITS 599,537.94 36,843.98 281,031.27 0.00 318,506.67 46.87
SERVICES-SUPPLIES
42055 COMPUTER EQUIPMENT & 18,383.39 4,251.00 4,251.00 432.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 1,152.50 0.00 (1,152.50) 0.00 TOTAL FOR SERVICES-SUPPLIES 22,915.01 4,251.00 6,969.03 432.39 15,513.59 32.29 TOTAL FOR PUBLIC WORKS 622,452.95 41,094.98 288,000.30 432.39 334,020.26 46.33 51 WATER RECLAMATIONS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 2,559,892.64 180,374.17 1,688,995.56 0.00 870,897.08 65.97 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 1,523.08 0.00 (1,523.08) 0.00 41102 SHIFT DIFFERENTIAL 40,000.00 3,342.17 32,577.48 0.00 7,422.52 81.44 41103 OUT OF CLASS PAY 0.00 423.33 1,656.81 0.00 (1,656.81) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 498.95 15,211.64 0.00 (15,211.64) 0.00 41140 FINAL LEAVE 0.00 0.00 11,643.61 0.00 (11,643.61) 0.00 41141 SP COMP-BILINGUAL 7,358.93 238.15 4,098.39 0.00 3,260.54 55.69 41147 SP COMP-GRADE 4 CERT PAY 40,980.00 3,076.17 34,506.79 0.00 6,473.21 84.20 41148 SP COMP-GRADE 5 CERT PAY 65,364.00 4,906.09 39,295.44 0.00 26,068.56 60.11 41200 TEMPORARY EMPLOYEES 26,112.23 0.00 2,734.83 0.00 23,377.40 10.47 41300 OVERTIME 385,626.00 26,557.55 262,306.09 0.00 123,319.91 68.02 41320 COMP TIME 0.00 0.00 460.94 0.00 (460.94) 0.00
41400 SPECIAL DUTY PAY 44,772.00 2,532.05 32,541.63 0.00 12,230.37 72.68 41410 AUTO ALLOWANCE 1,772.40 62.04 593.81 0.00 1,178.59 33.50 41500 DEFERRED COMPENSATION MATCH 18,140.00 11,113.76 12,288.72 0.00 5,851.28 67.74 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,676.13 8,234.78 0.00 3,189.22 72.08 41530 TIERED RHS BENEFIT 5,652.00 1,353.04 4,125.29 0.00 1,526.71 72.98 41600 LONGEVITY 18,931.43 6,649.09 27,074.23 0.00 (8,142.80) 143.01 KIMS Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/23/2022
Current Time: 14:05:36
User:
Report:
GL
03/31/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 09
Ledger:
Level:
Month to
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 5,260.12 0.00 (2,355.12) 181.07 41910 PERS-NORMAL 309,142.22 22,753.99 213,502.69 0.00 95,639.53 69.06 41912 PERS-UNFUNDED 758,057.00 0.00 196,035.12 0.00 562,021.88 25.86 41920 MEDICARE 100,835.06 7,697.34 67,392.06 0.00 33,443.00 66.83 41929 SHORT TERM DISABILITY 8,190.97 578.49 5,397.18 0.00 2,793.79 65.89 41930 LONG TERM DISABILITY 17,407.07 1,229.12 11,477.68 0.00 5,929.39 65.93 41931 WORKERS COMP 55,159.91 4,144.77 35,800.19 0.00 19,359.72 64.90 41932 STATE UNEMPLOYMENT INSURANCE 1,677.17 125.11 1,145.06 0.00 532.11 68.27 41940 HEALTH INSURANCE 366,638.20 43,474.97 273,426.81 0.00 93,211.39 74.57 41941 RETIREES HEALTH INSURANCE/OPEB 416,537.00 0.00 245,879.83 0.00 170,657.17 59.02 41945 OPT OUT HEALTH INSURANCE 82,818.00 5,677.80 55,144.31 0.00 27,673.69 66.58 41946 LIFE INSURANCE 21,247.54 1,500.30 14,009.68 0.00 7,237.86 65.93 41951 HEALTH ALLOWANCE CREDIT 0.00 4,909.07 4,909.07 0.00 (4,909.07) 0.00 41996 VACANCY FACTOR (287,732.00) 0.00 0.00 0.00 (287,732.00) 0.00 41997 BUDGETARY/PAYROLL (58,172.00) 0.00 0.00 0.00 (58,172.00) 0.00 TOTAL FOR SALARIES-BENEFITS 5,105,028.16 335,893.65 3,393,728.54 0.00 1,711,299.62 66.47
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 25,126.00 3,611.38 42,523.42 0.00 (17,397.42) 169.24 42033 CONSTRUCTION MATERIALS 1,278,099.68 76,579.19 697,690.71 323,927.67 256,481.30 79.93 42034 SAFETY MATERIALS/CONSTRUCTION 12,661.00 1,369.68 11,987.97 0.00 673.03 94.68 42055 COMPUTER EQUIPMENT & 31,737.47 488.86 19,798.40 2,873.69 9,065.38 71.43 42100 UNIFORM EXPENSE 11,826.28 742.05 5,748.84 0.00 6,077.44 48.61 42101 SAFETY SHOES - MOU ITEM 4,087.00 146.81 321.81 0.00 3,765.19 7.87 42200 ADVERTISING EXPENSE 2,541.00 0.00 1,704.04 0.00 836.96 67.06 42220 PROMOTIONAL/PUBLIC OUTREACH 17,671.13 0.00 516.57 10,919.59 6,234.97 64.71 42300 WIRELESS COMMUNICATION 20,691.44 1,653.06 13,630.27 0.00 7,061.17 65.87 42310 PHONES, FAX, ISDN LINES 12,059.00 876.94 8,084.36 0.00 3,974.64 67.04 42320 POSTAGE & SHIPPING 122,606.91 12,088.77 67,968.98 26,232.69 28,405.24 76.83 42340 OFFICE SUPPLIES 10,305.30 308.45 4,473.50 0.00 5,831.80 43.40 42345 FIRST AID KIT SUPPLIES 220.00 0.00 173.90 0.00 46.10 79.04 42350 PROGRAM EXPENDITURES 15,713.37 363.47 10,122.94 2,390.00 3,200.43 79.63 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 711.51 0.00 (711.51) 0.00 42410 ELECTRIC UTILITY 1,734,412.16 133,225.14 1,120,876.84 0.00 613,535.32 64.62 42420 NATURAL GAS UTILITY 195,840.00 6,769.29 47,790.76 0.00 148,049.24 24.40 42430 WATER UTILITY 38,400.00 4,780.40 34,908.48 0.00 3,491.52 90.90 42435 RECYCLED WATER UTILITY 897,009.71 39,328.94 438,690.57 0.00 458,319.14 48.90 42441 UNLEADED FUEL 3,300.16 516.05 3,713.67 0.00 (413.51) 112.52 KIMS Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/23/2022
Current Time: 14:05:36
User:
Report:
GL
03/31/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 09
Ledger:
Level:
Month to
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 187,490.14 565,725.91 0.00 281,457.81 66.77 42501 CUA LEASES 1,730,689.00 432,672.25 1,298,016.75 0.00 432,672.25 75.00 42600 MOTOR POOL RENTAL 112,504.61 0.00 85,391.61 0.00 27,113.00 75.90 42605 RETAINED VEHICLE EXPENSE 4,775.68 0.00 4,775.68 0.00 0.00 100.00 42610 DIRECT VEHICLE EXPENSE 15,522.00 0.00 3,882.79 6,864.93 4,774.28 69.24 42700 OTHER EQUIPMENT RENTAL 46,839.16 4,107.67 17,594.93 15,813.87 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 40,208.61 321,457.37 485,847.92 (104,813.73) 114.92 42815 SCADA MAINTENANCE 254,087.50 31,765.67 125,471.69 173,027.68 (44,411.87) 117.47 42816 MOWING/LANDSCAPE CONTRACTS 74,628.94 4,893.48 58,575.36 135.00 15,918.58 78.66 42900 PROF. & CONT. SVCS 1,043,924.20 71,013.40 774,141.03 411,229.61 (141,446.44) 113.54 42902 CUST CREDIT CRD PROCESSING FEE 208,091.91 17,008.99 105,065.03 25,542.66 77,484.22 62.76 42910 REFUSE DISPOSAL 72,000.00 6,809.08 51,414.88 0.00 20,585.12 71.40 43000 INSURANCE & SURETY BONDS 19,604.00 0.00 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 795.50 9,341.13 0.00 24,998.87 27.20 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 1,399.46 6,461.05 1,938.95 3,436.08 70.96 43698 CHEMICALS-SODIUM BISOLFITE 44,843.28 8,764.74 50,778.59 0.00 (5,935.31) 113.23 43700 CHEMICALS-MINERAL OIL 28,049.73 0.00 0.00 0.00 28,049.73 0.00 43701 CHEMICALS-POLYMER 664,874.27 60,516.33 445,514.94 392,485.06 (173,125.73) 126.03 43707 CHEMICALS-SODIUM 1,047,240.00 39,451.24 678,719.59 864,136.72 (495,616.31) 147.32 43709 CHEMICALS-FERRIC CHLORIDE 85,807.50 6,203.07 24,914.96 75,085.04 (14,192.50) 116.53 43711 CHEMICALS-MISC 23,090.76 0.00 2,929.45 20,000.00 161.31 99.30 43713 BIOSOLIDS DISPOSAL/RECYCLE 1,589,346.00 236,994.69 844,954.86 1,234,299.06 (489,907.92) 130.82 43714 OUTSIDE LAB ANALYSIS 548,677.00 32,750.15 283,040.65 183,664.35 81,972.00 85.06 43715 REGULATORY PERMIT & USE FEES 206,406.00 7,244.60 196,984.90 0.00 9,421.10 95.43 43716 JOB REQ CERTIFICATES & LICENSE 1,735.00 0.00 410.88 0.00 1,324.12 23.68 43720 LAB CHEMICALS AND SUPPLIES 33,600.00 233.19 14,822.93 13,118.19 5,658.88 83.15 43722 PREVENTION & MAINTENANCE 1,174,095.32 43,486.08 569,234.20 535,581.25 69,279.87 94.09 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 0.00 6,508.80 0.00 (6,508.80) 0.00 43728 WRCRWA CAP ASSET CONTRIBUTION 994,916.00 205,199.62 216,582.17 0.00 778,333.83 21.76 43729 WRCRWA TRTMNT/CONVEYANCE 2,242,644.00 84,219.90 902,427.14 0.00 1,340,216.86 40.23 44100 INTEREST EXPENSE 448,206.00 113,801.00 190,949.11 0.00 257,256.89 42.60 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 1,132,119.75 0.00 377,373.25 75.00 KIMS Page: 7 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/23/2022
Current Time: 14:05:36
User:
Report:
GL
03/31/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 09
Ledger:
Level:
Month to
44613 INTERNAL SVC CHRG-WAREHOUSE 57,150.00 14,287.50 42,862.50 0.00 14,287.50 75.00 44614 INTERNAL SVC CHRG-INFO TECH 1,548,758.00 387,189.50 1,161,568.50 0.00 387,189.50 75.00 TOTAL FOR SERVICES-SUPPLIES 22,386,003.83 2,698,727.59 12,760,071.63 4,820,406.23 4,805,525.97 78.53
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,930,321.99 3,034,621.24 16,153,800.17 4,820,406.23 6,956,115.59 75.09 FUN 572 60,738,704.10 3,264,735.86 32,840,834.29 10,727,695.08 17,170,174.73 71.73 KIMS Page: 8 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/23/2022
Current Time: 14:05:36
User:
Report:
GL
03/31/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 09
Ledger:
Level:
Month to
573 WATER RECLAMATION GRANT/AGRMT
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 76.10 1,126.69 0.00 (1,126.69) 0.00 41600 LONGEVITY 0.00 12.99 12.99 0.00 (12.99) 0.00
41910 PERS-NORMAL 0.00 10.17 129.82 0.00 (129.82) 0.00
41920 MEDICARE 0.00 2.64 33.92 0.00 (33.92) 0.00
41931 WORKERS COMP 0.00 1.52 22.54 0.00 (22.54) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.04 0.60 0.00 (0.60) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 103.46 1,326.56 0.00 (1,326.56) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 189,020.98 0.00 0.00 0.00 189,020.98 0.00 42830 REBATE PROGRAMS 0.00 754,599.32 754,599.32 0.00 (754,599.32) 0.00 43300 CONSTRUCTION CONTRACTS 0.00 0.00 0.00 139,878.90 (139,878.90) 0.00 TOTAL FOR SERVICES-SUPPLIES 189,020.98 754,599.32 754,599.32 139,878.90 (705,457.24) 473.21 TOTAL FOR NOT APPLICABLE 189,020.98 754,702.78 755,925.88 139,878.90 (706,783.80) 473.91 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 754,702.78 755,925.88 139,878.90 (706,783.80) 473.91 KIMS Page: 9 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/23/2022
Current Time: 14:05:36
User:
Report:
GL
03/31/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 09
Ledger:
Level:
Month to
GRAND TOTAL 62,223,797.74 4,095,185.66 33,706,706.95 10,870,373.98 17,646,716.81 71.63 KIMS Page: 10 Current Date:
GLREREE5_Consolidated_Expenditure_Report
04/23/2022
Current Time: 14:05:36
User:
Report: