GL
12/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 06
Ledger:
Level:
Month to
440 SEWER CAPACITY GEN SRVC
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 1,769.97 3,050.53 0.00 (3,050.53) 0.00 41141 SP COMP-BILINGUAL 0.00 21.86 40.99 0.00 (40.99) 0.00 41910 PERS-NORMAL 0.00 215.55 371.95 0.00 (371.95) 0.00 41920 MEDICARE 0.00 53.09 91.43 0.00 (91.43) 0.00
41931 WORKERS COMP 0.00 35.85 61.85 0.00 (61.85) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 1.63 2.82 0.00 (2.82) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 2,097.95 3,619.57 0.00 (3,619.57) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 5,573,616.92 0.00 0.00 0.00 5,573,616.92 0.00 42900 PROF. & CONT. SVCS 10,471.52 0.00 1,213.26 9,258.26 0.00 100.00 43300 CONSTRUCTION CONTRACTS 1,317,475.96 242,597.29 934,973.15 382,502.81 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 6,901,564.40 242,597.29 936,186.41 391,761.07 5,573,616.92 19.24 TOTAL FOR NOT APPLICABLE 6,901,564.40 244,695.24 939,805.98 391,761.07 5,569,997.35 19.29 51 SEWER
SERVICES-SUPPLIES
44100 INTEREST EXPENSE 122,835.00 0.00 21,801.33 0.00 101,033.67 17.74 44610 ADMINISTRATIVE SERVICES CHARGE 13,666.00 3,416.50 6,833.00 0.00 6,833.00 50.00 TOTAL FOR SERVICES-SUPPLIES 136,501.00 3,416.50 28,634.33 0.00 107,866.67 20.97 TOTAL FOR SEWER 136,501.00 3,416.50 28,634.33 0.00 107,866.67 20.97 FUN 440 7,038,065.40 248,111.74 968,440.31 391,761.07 5,677,864.02 19.32 LUISN Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2024
Current Time: 15:42:17
User:
Report:
GL
12/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 06
Ledger:
Level:
Month to
572 SEWER UTILITY FUND
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 12,174.70 37,273.98 0.00 (37,273.98) 0.00 41141 SP COMP-BILINGUAL 0.00 18.60 39.94 0.00 (39.94) 0.00 41300 OVERTIME 0.00 1,086.56 1,319.39 0.00 (1,319.39) 0.00 41910 PERS-NORMAL 0.00 1,466.85 4,488.84 0.00 (4,488.84) 0.00 41920 MEDICARE 0.00 392.48 1,145.13 0.00 (1,145.13) 0.00 41931 WORKERS COMP 0.00 243.85 746.28 0.00 (746.28) 0.00 41932 STATE UNEMPLOYMENT INSURANCE 0.00 12.09 35.24 0.00 (35.24) 0.00 41951 HEALTH ALLOWANCE CREDIT 0.00 2.36 2.36 0.00 (2.36) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 15,397.49 45,051.16 0.00 (45,051.16) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 44,673,568.40 0.00 0.00 0.00 44,673,568.40 0.00 42033 CONSTRUCTION MATERIALS 0.00 10,077.96 32,086.29 123,000.00 (155,086.29) 0.00 42055 COMPUTER EQUIPMENT & 0.00 0.00 (232.43) 0.00 232.43 0.00 42430 WATER UTILITY 0.00 0.00 149.26 0.00 (149.26) 0.00 42700 OTHER EQUIPMENT RENTAL 3,060.48 484.88 2,424.40 6,636.08 (6,000.00) 296.04 42800 EQUIPMENT MAINTENANCE 1,528.00 0.00 0.00 1,528.00 0.00 100.00 42815 SCADA MAINTENANCE 101,822.10 36,426.44 110,276.97 136,163.37 (144,618.24) 242.03 42900 PROF. & CONT. SVCS 1,491,791.55 230,647.14 517,363.69 3,259,698.54 (2,285,270.68) 253.18 43300 CONSTRUCTION CONTRACTS 1,978,586.84 236,961.30 1,093,049.66 9,475,292.60 (8,589,755.42) 534.13 43301 CAPITAL IMPROVEMENTS 32,080.07 0.00 26,630.00 32,080.07 (26,630.00) 183.01 43400 LEGAL SERVICES-SPECIAL COUNSEL 0.00 121,867.94 145,887.70 0.00 (145,887.70) 0.00 43724 OUTSIDE SERVICES - LABOR 0.00 0.00 10,057.50 0.00 (10,057.50) 0.00 43726 PROJECT MANAGEMENT 11,969.25 8,025.00 56,160.00 11,969.25 (56,160.00) 569.20 43727 INSPECTION 131,852.00 32,343.60 45,343.60 72,988.40 13,520.00 89.74 TOTAL FOR SERVICES-SUPPLIES 48,426,258.69 676,834.26 2,039,196.64 13,119,356.31 33,267,705.74 31.30
CAPITAL OUTLAY
45100 LICENSED VEHICLES 257,357.00 0.00 0.00 231,743.52 25,613.48 90.04 45200 MACHINERY, EQUIPMENT, & FIXTUR 1,226,184.90 0.00 293,927.70 1,226,184.90 (293,927.70) 123.97 TOTAL FOR CAPITAL OUTLAY 1,483,541.90 0.00 293,927.70 1,457,928.42 (268,314.22) 118.08 TOTAL FOR NOT APPLICABLE 49,909,800.59 692,231.75 2,378,175.50 14,577,284.73 32,954,340.36 33.97 11 CITY MANAGER'S OFFICE
SALARIES-BENEFITS
41200 TEMPORARY EMPLOYEES 3,407.00 352.10 1,326.33 0.00 2,080.67 38.92 41510 PST DEFERRED COMPENSATION 45.00 4.57 17.24 0.00 27.76 38.31 41920 MEDICARE 49.00 5.16 19.48 0.00 29.52 39.75
41931 WORKERS COMP 68.00 7.04 26.56 0.00 41.44 39.05
41932 STATE UNEMPLOYMENT INSURANCE 3.00 0.32 1.18 0.00 1.82 39.33 LUISN Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2024
Current Time: 15:42:17
User:
Report:
GL
12/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 06
Ledger:
Level:
Month to
TOTAL FOR SALARIES-BENEFITS 3,572.00 369.19 1,390.79 0.00 2,181.21 38.93 TOTAL FOR CITY MANAGER'S OFFICE 3,572.00 369.19 1,390.79 0.00 2,181.21 38.93 13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 0.00 0.00 138.46 0.00 (138.46) 0.00 44101 DS INTEREST 2021 POBS 215,364.00 0.00 107,681.80 0.00 107,682.20 50.00 TOTAL FOR SERVICES-SUPPLIES 215,364.00 0.00 107,820.26 0.00 107,543.74 50.06 TOTAL FOR DEBT SERVICE 215,364.00 0.00 107,820.26 0.00 107,543.74 50.06 21 PLANNING & DEVELOPMENT
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 35,076.00 2,650.06 11,854.91 0.00 23,221.09 33.79 41141 SP COMP-BILINGUAL 403.00 40.62 179.98 0.00 223.02 44.66 41400 SPECIAL DUTY PAY 0.00 0.00 20.00 0.00 (20.00) 0.00 41500 DEFERRED COMPENSATION MATCH 75.00 0.00 0.00 0.00 75.00 0.00 41520 TIERED EMP DEF COMPENSATION 90.00 22.50 45.00 0.00 45.00 50.00 41530 TIERED RHS BENEFIT 30.00 7.50 15.00 0.00 15.00 50.00 41600 LONGEVITY 175.00 12.12 52.52 0.00 122.48 30.01
41910 PERS-NORMAL 3,524.00 325.13 1,454.07 0.00 2,069.93 41.26 41920 MEDICARE 1,060.00 80.28 357.31 0.00 702.69 33.70
41929 SHORT TERM DISABILITY 111.00 10.86 48.58 0.00 62.42 43.76 41930 LONG TERM DISABILITY 239.00 18.03 80.65 0.00 158.35 33.74 41931 WORKERS COMP 710.00 53.59 239.37 0.00 470.63 33.71 41932 STATE UNEMPLOYMENT INSURANCE 33.00 2.44 10.92 0.00 22.08 33.09 41940 HEALTH INSURANCE 8,020.00 446.72 2,718.22 0.00 5,301.78 33.89 41946 LIFE INSURANCE 290.00 22.02 98.50 0.00 191.50 33.96 41951 HEALTH ALLOWANCE CREDIT 0.00 16.64 100.78 0.00 (100.78) 0.00 41996 VACANCY FACTOR (14,452.00) 0.00 0.00 0.00 (14,452.00) 0.00 TOTAL FOR SALARIES-BENEFITS 35,384.00 3,708.51 17,275.81 0.00 18,108.19 48.82
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 60.00 0.00 12.19 0.00 47.81 20.31 TOTAL FOR SERVICES-SUPPLIES 60.00 0.00 12.19 0.00 47.81 20.31 TOTAL FOR PLANNING & DEVELOPMENT DEPT35,444.00 3,708.51 17,288.00 0.00 18,156.00 48.77 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 508,257.00 31,975.36 145,627.28 0.00 362,629.72 28.65 41140 FINAL LEAVE 0.00 5,199.65 27,251.11 0.00 (27,251.11) 0.00 41141 SP COMP-BILINGUAL 3,218.00 178.77 655.04 0.00 2,562.96 20.35 41200 TEMPORARY EMPLOYEES 17,394.00 818.26 3,667.17 0.00 13,726.83 21.08 LUISN Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2024
Current Time: 15:42:17
User:
Report:
GL
12/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 06
Ledger:
Level:
Month to
41300 OVERTIME 0.00 32.20 857.70 0.00 (857.70) 0.00
41400 SPECIAL DUTY PAY 0.00 460.56 1,995.76 0.00 (1,995.76) 0.00 41410 AUTO ALLOWANCE 576.00 66.45 287.95 0.00 288.05 49.99 41500 DEFERRED COMPENSATION MATCH 3,058.00 0.00 68.80 0.00 2,989.20 2.24 41510 PST DEFERRED COMPENSATION 225.00 10.65 47.72 0.00 177.28 21.20 41520 TIERED EMP DEF COMPENSATION 972.00 192.00 442.50 0.00 529.50 45.52 41530 TIERED RHS BENEFIT 912.00 172.00 402.50 0.00 509.50 44.13 41600 LONGEVITY 3,199.00 278.74 1,405.04 0.00 1,793.96 43.92 41700 ANNUAL LEAVE BUYBACK 16,740.00 7,935.09 7,935.09 0.00 8,804.91 47.40 41910 PERS-NORMAL 61,926.00 3,908.46 17,873.57 0.00 44,052.43 28.86 41920 MEDICARE 16,187.00 1,399.72 5,576.14 0.00 10,610.86 34.44 41929 SHORT TERM DISABILITY 1,627.00 184.59 872.99 0.00 754.01 53.65 41930 LONG TERM DISABILITY 3,456.00 306.74 1,448.39 0.00 2,007.61 41.90 41931 WORKERS COMP 10,613.00 666.74 3,006.03 0.00 7,606.97 28.32 41932 STATE UNEMPLOYMENT INSURANCE 496.00 42.82 172.15 0.00 323.85 34.70 41940 HEALTH INSURANCE 89,656.00 4,278.06 29,677.19 0.00 59,978.81 33.10 41945 OPT OUT HEALTH INSURANCE 1,848.00 214.00 1,254.00 0.00 594.00 67.85 41946 LIFE INSURANCE 4,216.00 374.45 1,768.16 0.00 2,447.84 41.93 41951 HEALTH ALLOWANCE CREDIT 0.00 158.32 1,074.30 0.00 (1,074.30) 0.00 41996 VACANCY FACTOR (151,573.00) 0.00 0.00 0.00 (151,573.00) 0.00 TOTAL FOR SALARIES-BENEFITS 593,003.00 58,853.63 253,366.58 0.00 339,636.42 42.72
SERVICES-SUPPLIES
42055 COMPUTER EQUIPMENT & 3,000.00 0.00 0.00 0.00 3,000.00 0.00 42101 SAFETY SHOES - MOU ITEM 1,233.00 294.62 858.68 0.00 374.32 69.64 42340 OFFICE SUPPLIES 0.00 0.00 24.47 0.00 (24.47) 0.00 42350 PROGRAM EXPENDITURES 0.00 108.75 108.75 0.00 (108.75) 0.00 43200 CONFERENCE, TRAINING & TRAVEL 0.00 0.00 660.27 0.00 (660.27) 0.00 TOTAL FOR SERVICES-SUPPLIES 4,233.00 403.37 1,652.17 0.00 2,580.83 39.03 TOTAL FOR PUBLIC WORKS 597,236.00 59,257.00 255,018.75 0.00 342,217.25 42.69 51 SEWER
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 3,857,865.11 375,505.10 1,641,043.97 0.00 2,216,821.14 42.53 41101 SPECIAL ASSIGNMENT PAY 0.00 0.00 863.61 0.00 (863.61) 0.00 41102 SHIFT DIFFERENTIAL 0.00 3,687.00 18,412.67 0.00 (18,412.67) 0.00 41140 FINAL LEAVE 0.00 0.00 23,605.33 0.00 (23,605.33) 0.00 41141 SP COMP-BILINGUAL 27,400.00 3,171.01 13,849.57 0.00 13,550.43 50.54 41147 SP COMP-GRADE 4 CERT PAY 11,280.00 1,301.52 5,639.94 0.00 5,640.06 49.99 41148 SP COMP-GRADE 5 CERT PAY 91,208.00 11,191.04 48,466.67 0.00 42,741.33 53.13 41200 TEMPORARY EMPLOYEES 56,561.00 3,650.56 16,849.47 0.00 39,711.53 29.78 LUISN Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2024
Current Time: 15:42:17
User:
Report:
GL
12/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 06
Ledger:
Level:
Month to
41300 OVERTIME 583,872.00 46,137.24 278,690.21 0.00 305,181.79 47.73 41320 COMP TIME 0.00 1,617.68 8,018.16 0.00 (8,018.16) 0.00 41400 SPECIAL DUTY PAY 28,377.00 7,290.27 29,603.63 0.00 (1,226.63) 104.32 41410 AUTO ALLOWANCE 2,592.00 299.07 1,295.97 0.00 1,296.03 49.99 41500 DEFERRED COMPENSATION MATCH 19,518.00 324.01 972.03 0.00 18,545.97 4.98 41510 PST DEFERRED COMPENSATION 272.31 47.46 218.26 0.00 54.05 80.15 41520 TIERED EMP DEF COMPENSATION 11,850.00 2,689.17 5,443.17 0.00 6,406.83 45.93 41530 TIERED RHS BENEFIT 5,918.00 1,343.39 2,708.39 0.00 3,209.61 45.76 41600 LONGEVITY 27,829.00 3,694.57 14,326.10 0.00 13,502.90 51.47 41700 ANNUAL LEAVE BUYBACK 83,946.00 78,571.41 78,571.41 0.00 5,374.59 93.59 41710 ANNUAL LEAVE OVER MAX 4,762.00 0.00 0.00 0.00 4,762.00 0.00 41910 PERS-NORMAL 488,060.79 49,394.00 213,307.88 0.00 274,752.91 43.70 41920 MEDICARE 142,389.78 16,046.51 65,230.41 0.00 77,159.37 45.81 41929 SHORT TERM DISABILITY 12,340.44 1,527.40 6,727.81 0.00 5,612.63 54.51 41930 LONG TERM DISABILITY 26,224.68 2,532.86 11,158.72 0.00 15,065.96 42.55 41931 WORKERS COMP 82,760.96 8,065.81 35,340.54 0.00 47,420.42 42.70 41932 STATE UNEMPLOYMENT INSURANCE 4,341.98 489.70 2,006.88 0.00 2,335.10 46.22 41940 HEALTH INSURANCE 818,768.00 50,718.68 307,518.54 0.00 511,249.46 37.55 41941 RETIREES HEALTH INSURANCE/OPEB 390,986.00 100,261.23 198,005.18 0.00 192,980.82 50.64 41945 OPT OUT HEALTH INSURANCE 41,160.00 4,366.48 26,227.34 0.00 14,932.66 63.72 41946 LIFE INSURANCE 32,021.69 3,091.50 13,619.25 0.00 18,402.44 42.53 41951 HEALTH ALLOWANCE CREDIT 0.00 1,648.57 9,948.31 0.00 (9,948.31) 0.00 41996 VACANCY FACTOR (127,055.00) 0.00 0.00 0.00 (127,055.00) 0.00 41997 BUDGETARY/PAYROLL 72,937.26 0.00 0.00 0.00 72,937.26 0.00 TOTAL FOR SALARIES-BENEFITS 6,798,187.00 778,663.24 3,077,669.42 0.00 3,720,517.58 45.27
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 63,550.00 10,493.83 95,182.86 3,800.00 (35,432.86) 155.75 42033 CONSTRUCTION MATERIALS 966,630.04 85,243.53 665,914.71 310,514.37 (9,799.04) 101.01 42034 SAFETY MATERIALS/CONSTRUCTION 22,475.00 2,064.57 14,216.64 0.00 8,258.36 63.25 42055 COMPUTER EQUIPMENT & 35,690.00 15,916.00 34,372.77 0.00 1,317.23 96.30 42100 UNIFORM EXPENSE 14,414.00 652.15 4,880.62 0.00 9,533.38 33.86 42101 SAFETY SHOES - MOU ITEM 9,744.00 124.20 7,201.70 0.00 2,542.30 73.90 42200 ADVERTISING EXPENSE 5,183.00 0.00 637.00 0.00 4,546.00 12.29 42220 PROMOTIONAL/PUBLIC OUTREACH 14,752.00 0.00 597.17 0.00 14,154.83 4.04 42300 WIRELESS COMMUNICATION 22,799.00 1,025.04 9,262.47 0.00 13,536.53 40.62 42310 PHONES, FAX, ISDN LINES 11,929.00 2,026.09 13,334.86 0.00 (1,405.86) 111.78 42320 POSTAGE & SHIPPING 120,737.00 3,782.48 48,634.48 0.00 72,102.52 40.28 42340 OFFICE SUPPLIES 11,312.00 968.99 3,428.11 0.00 7,883.89 30.30 42345 FIRST AID KIT SUPPLIES 340.00 132.77 197.33 0.00 142.67 58.03 42350 PROGRAM EXPENDITURES 19,382.00 870.53 19,855.82 166.96 (640.78) 103.30 LUISN Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2024
Current Time: 15:42:17
User:
Report:
GL
12/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 06
Ledger:
Level:
Month to
42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 774.53 0.00 (774.53) 0.00 42365 RECYCLED CONTENT PRODUCTS 999.00 0.00 515.31 0.00 483.69 51.58 42410 ELECTRIC UTILITY 1,734,412.00 98,773.69 742,352.97 0.00 992,059.03 42.80 42420 NATURAL GAS UTILITY 57,600.00 2,869.32 17,285.46 0.00 40,314.54 30.00 42430 WATER UTILITY 64,575.00 6,032.03 58,018.38 0.00 6,556.62 89.84 42435 RECYCLED WATER UTILITY 646,591.00 53,401.95 475,278.34 0.00 171,312.66 73.50 42441 UNLEADED FUEL 600.00 0.00 87.46 0.00 512.54 14.57 42442 DIESEL FUEL 15,000.00 0.00 22,741.38 0.00 (7,741.38) 151.60 42443 OTHER FUELS 60.00 0.00 0.00 0.00 60.00 0.00
42500 RENTS & LEASES 817,427.00 198,890.75 399,445.43 0.00 417,981.57 48.86 42501 CUA LEASES 1,548,785.00 387,196.25 774,392.50 0.00 774,392.50 50.00 42600 MOTOR POOL RENTAL - OPS & MTCE 186,182.00 84,192.75 84,192.75 0.00 101,989.25 45.22 42605 RETAINED VEHICLE EXPENSE 2,431.00 1,215.50 1,215.50 0.00 1,215.50 50.00 42610 DIRECT VEHICLE EXPENSE 9,522.00 103.70 2,013.57 12,470.31 (4,961.88) 152.10 42700 OTHER EQUIPMENT RENTAL 70,513.67 269.40 22,396.20 39,209.99 8,907.48 87.36 42710 MILEAGE/VEHICLE EXP REIMB 570.00 0.00 0.00 0.00 570.00 0.00 42813 MTCE & REPAIR - EQUIP & FAC 627,148.99 46,152.08 407,683.89 357,388.26 (137,923.16) 121.99 42815 SCADA MAINTENANCE 310,026.00 21,357.27 146,269.62 186,897.59 (23,141.21) 107.46 42816 MOWING/LANDSCAPE CONTRACTS 111,991.00 7,200.00 (13,875.00) 57,800.00 68,066.00 39.22 42900 PROF. & CONT. SVCS 1,121,379.94 118,096.48 351,772.42 576,241.13 193,366.39 82.75 42902 CUST CREDIT CRD PROCESSING FEE 352,078.00 525.70 111,473.54 236,051.28 4,553.18 98.70 42910 REFUSE DISPOSAL 90,588.00 1,574.05 30,514.78 0.00 60,073.22 33.68 43000 INSURANCE & SURETY BONDS 54,282.00 0.00 55,256.60 0.00 (974.60) 101.79 43100 MEMBERSHIP & DUES 36,652.00 0.00 9,021.00 0.00 27,631.00 24.61 43200 CONFERENCE, TRAINING & TRAVEL 46,831.00 489.50 29,243.09 0.00 17,587.91 62.44 43400 LEGAL SERVICES-SPECIAL COUNSEL 22,500.00 0.00 0.00 0.00 22,500.00 0.00 43500 BOOKS 0.00 0.00 545.34 0.00 (545.34) 0.00
43698 CHEMICALS-SODIUM BISOLFITE 120,560.00 0.00 18,868.17 101,581.83 110.00 99.90 43701 CHEMICALS-POLYMER 1,643,968.00 10,605.30 139,752.02 1,211,247.98 292,968.00 82.17 43707 CHEMICALS-SODIUM 2,238,500.00 150,543.92 687,050.78 1,551,449.22 0.00 100.00 43709 CHEMICALS-FERRIC CHLORIDE 135,520.00 12,056.07 58,517.47 53,482.53 23,520.00 82.64 43711 CHEMICALS-MISC 25,000.00 0.00 0.00 0.00 25,000.00 0.00 43713 BIOSOLIDS DISPOSAL/RECYCLE 1,800,000.00 170,076.28 593,573.92 1,464,110.73 (257,684.65) 114.31 43714 OUTSIDE LAB ANALYSIS 562,200.00 35,410.25 124,800.50 306,914.50 130,485.00 76.79 43715 REGULATORY PERMIT & USE FEES 225,736.00 181,471.61 212,032.77 0.00 13,703.23 93.92 43716 JOB REQ CERTIFICATES & LICENSE 1,950.00 110.00 1,460.16 0.00 489.84 74.88 43720 LAB CHEMICALS AND SUPPLIES 37,632.00 185.92 15,072.09 0.00 22,559.91 40.05 43722 PREVENTION & MAINTENANCE 1,173,347.38 62,901.47 493,283.46 720,295.76 (40,231.84) 103.42 43723 INLAND EMPIRE BRINE LINE-SARI 7,755.00 0.00 0.00 0.00 7,755.00 0.00 43725 FINES AND PENALTIES 0.00 0.00 177,000.00 0.00 (177,000.00) 0.00 LUISN Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2024
Current Time: 15:42:17
User:
Report:
GL
12/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 06
Ledger:
Level:
Month to
43728 WRCRWA CAP ASSET CONTRIBUTION 1,092,443.00 374,280.00 717,014.37 0.00 375,428.63 65.63 43729 WRCRWA TRTMNT/CONVEYANCE 1,839,905.00 322,619.75 894,258.14 0.00 945,646.86 48.60 44100 INTEREST EXPENSE 400,488.00 0.00 69,555.52 0.00 330,932.48 17.36 44200 BAD DEBTS EXPENSE 60,462.00 0.00 0.00 0.00 60,462.00 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 1,661,969.00 376,471.75 830,984.50 0.00 830,984.50 50.00 44613 INTERNAL SVC CHRG-WAREHOUSE 56,936.00 14,234.00 28,468.00 0.00 28,468.00 50.00 44614 INTERNAL SVC CHRG-INFO TECH 1,507,110.00 379,047.83 749,014.33 0.00 758,095.67 49.69 44615 INTERNAL SVC CHRG-NPDES 156,082.00 78,041.00 78,041.00 0.00 78,041.00 50.00 TOTAL FOR SERVICES-SUPPLIES 23,995,245.02 3,319,695.75 10,535,078.80 7,189,622.44 6,270,543.78 73.86
CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 664,818.00 0.00 0.00 657,263.25 7,554.75 98.86 TOTAL FOR CAPITAL OUTLAY 664,818.00 0.00 0.00 657,263.25 7,554.75 98.86 TOTAL FOR SEWER 31,458,250.02 4,098,358.99 13,612,748.22 7,846,885.69 9,998,616.11 68.21 FUN 572 82,219,666.61 4,853,925.44 16,372,441.52 22,424,170.42 43,423,054.67 47.18 LUISN Page: 7 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2024
Current Time: 15:42:17
User:
Report:
GL
12/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 06
Ledger:
Level:
Month to
573 SEWER GRANT/AGRMT
00 NOT APPLICABLE
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 64,511.11 0.00 0.00 0.00 64,511.11 0.00 42830 REBATE PROGRAMS 0.00 8,351.57 26,563.51 0.00 (26,563.51) 0.00 42900 PROF. & CONT. SVCS 308.10 0.00 0.00 308.10 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 64,819.21 8,351.57 26,563.51 308.10 37,947.60 41.45 TOTAL FOR NOT APPLICABLE 64,819.21 8,351.57 26,563.51 308.10 37,947.60 41.45 FUN 573 64,819.21 8,351.57 26,563.51 308.10 37,947.60 41.45 LUISN Page: 8 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2024
Current Time: 15:42:17
User:
Report:
GL
12/31/2023
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2024
OB 06
Ledger:
Level:
Month to
GRAND TOTAL 89,322,551.22 5,110,388.75 17,367,445.34 22,816,239.59 49,138,866.29 44.98 LUISN Page: 9 Current Date:
GLREREE5_Consolidated_Expenditure_Report
01/16/2024
Current Time: 15:42:17
User:
Report: