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
578 ELECTRIC UTILITY FUND
00 NOT APPLICABLE
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 1,372,590.95 0.00 0.00 0.00 1,372,590.95 0.00 42033 CONSTRUCTION MATERIALS 0.00 0.00 1,323.90 0.00 (1,323.90) 0.00 42200 ADVERTISING EXPENSE 0.00 0.00 650.41 0.00 (650.41) 0.00 42900 PROF. & CONT. SVCS 173,881.95 50,656.60 99,188.55 94,693.40 (20,000.00) 111.50 43301 CAPITAL IMPROVEMENTS 0.00 0.00 0.00 50,000.00 (50,000.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 1,546,472.90 50,656.60 101,162.86 144,693.40 1,300,616.64 15.89
CAPITAL OUTLAY
45100 LICENSED VEHICLES 0.00 0.00 30,324.52 0.00 (30,324.52) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 0.00 30,324.52 0.00 (30,324.52) 0.00 TOTAL FOR NOT APPLICABLE 1,546,472.90 50,656.60 131,487.38 144,693.40 1,270,292.12 17.85 18 ADMIN SERVICES-FINANCE
SALARIES-BENEFITS
41912 PERS-UNFUNDED 2,002.00 0.00 517.74 0.00 1,484.26 25.86 TOTAL FOR SALARIES-BENEFITS 2,002.00 0.00 517.74 0.00 1,484.26 25.86 TOTAL FOR ADMIN SERVICES-FINANCE 2,002.00 0.00 517.74 0.00 1,484.26 25.86 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 106,730.23 6,623.53 30,090.88 0.00 76,639.35 28.19 41110 CONTRACTUAL OBLIGATION 0.00 0.00 10.97 0.00 (10.97) 0.00 41141 SP COMP-BILINGUAL 443.00 38.26 83.66 0.00 359.34 18.88 41200 TEMPORARY EMPLOYEES 2,247.28 253.80 1,106.23 0.00 1,141.05 49.22 41300 OVERTIME 100.00 126.28 362.27 0.00 (262.27) 362.27 41400 SPECIAL DUTY PAY 2,390.00 275.40 1,206.51 0.00 1,183.49 50.48 41500 DEFERRED COMPENSATION MATCH 665.00 0.00 0.00 0.00 665.00 0.00 41510 PST DEFERRED COMPENSATION 29.21 3.29 14.37 0.00 14.84 49.19 41520 TIERED EMP DEF COMPENSATION 210.00 52.50 105.00 0.00 105.00 50.00 41530 TIERED RHS BENEFIT 210.00 52.50 105.00 0.00 105.00 50.00 41600 LONGEVITY 560.00 0.00 560.00 0.00 0.00 100.00
41630 ONE TIME MOU PAYMENTS 1,740.40 0.00 1,740.40 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 5,274.21 0.00 5,371.80 0.00 (97.59) 101.85 41710 ANNUAL LEAVE OVER MAX 634.00 0.00 0.00 0.00 634.00 0.00 41910 PERS-NORMAL 12,271.45 758.77 3,500.63 0.00 8,770.82 28.52 41912 PERS-UNFUNDED 32,738.00 0.00 8,466.15 0.00 24,271.85 25.86 41920 MEDICARE 3,621.38 204.87 1,129.39 0.00 2,491.99 31.18 41929 SHORT TERM DISABILITY 341.53 39.00 168.12 0.00 173.41 49.22 41930 LONG TERM DISABILITY 725.76 82.83 360.65 0.00 365.11 49.69 User: KIMS Page: 1 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:17:14 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
41931 WORKERS COMP 2,189.01 135.81 602.34 0.00 1,586.67 27.51 41932 STATE UNEMPLOYMENT INSURANCE 59.66 3.51 19.35 0.00 40.31 32.43 41940 HEALTH INSURANCE 16,856.79 1,475.46 9,327.17 0.00 7,529.62 55.33 41946 LIFE INSURANCE 885.87 101.12 440.25 0.00 445.62 49.69 41996 VACANCY FACTOR (5,165.00) 0.00 0.00 0.00 (5,165.00) 0.00 41997 BUDGETARY/PAYROLL (199.00) 0.00 0.00 0.00 (199.00) 0.00 TOTAL FOR SALARIES-BENEFITS 185,558.78 10,226.93 64,771.14 0.00 120,787.64 34.90
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 343.25 0.00 0.00 0.00 343.25 0.00 TOTAL FOR SERVICES-SUPPLIES 343.25 0.00 0.00 0.00 343.25 0.00 TOTAL FOR PUBLIC WORKS 185,902.03 10,226.93 64,771.14 0.00 121,130.89 34.84 52 ELECTRIC UTILITY
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,043,133.03 96,472.29 432,388.65 0.00 610,744.38 41.45 41103 OUT OF CLASS PAY 0.00 30.84 30.84 0.00 (30.84) 0.00 41110 CONTRACTUAL OBLIGATION 0.00 1.82 155.40 0.00 (155.40) 0.00 41140 FINAL LEAVE 0.00 0.00 1,504.86 0.00 (1,504.86) 0.00 41141 SP COMP-BILINGUAL 1,342.23 115.50 556.85 0.00 785.38 41.48 41147 SP COMP-GRADE 4 CERT PAY 2,040.00 235.37 1,031.11 0.00 1,008.89 50.54 41148 SP COMP-GRADE 5 CERT PAY 2,326.00 246.99 1,082.08 0.00 1,243.92 46.52 41200 TEMPORARY EMPLOYEES 2,150.47 0.00 390.55 0.00 1,759.92 18.16 41300 OVERTIME 18,158.00 1,413.27 3,397.48 0.00 14,760.52 18.71 41320 COMP TIME 0.00 0.00 60.90 0.00 (60.90) 0.00
41400 SPECIAL DUTY PAY 5,437.00 450.70 1,659.38 0.00 3,777.62 30.52 41410 AUTO ALLOWANCE 4,030.80 285.78 1,251.99 0.00 2,778.81 31.06 41500 DEFERRED COMPENSATION MATCH 7,854.00 195.71 526.98 0.00 7,327.02 6.70 41510 PST DEFERRED COMPENSATION 12.48 0.00 0.00 0.00 12.48 0.00 41520 TIERED EMP DEF COMPENSATION 2,478.00 618.70 1,238.20 0.00 1,239.80 49.96 41530 TIERED RHS BENEFIT 1,758.00 439.50 879.00 0.00 879.00 50.00 41600 LONGEVITY 13,704.10 821.43 10,724.07 0.00 2,980.03 78.25 41630 ONE TIME MOU PAYMENTS 18,905.15 0.00 18,905.15 0.00 0.00 100.00 41700 ANNUAL LEAVE BUYBACK 23,747.80 0.00 23,200.22 0.00 547.58 97.69 41710 ANNUAL LEAVE OVER MAX 6,783.00 0.00 0.00 0.00 6,783.00 0.00 41910 PERS-NORMAL 121,244.53 11,249.40 50,883.08 0.00 70,361.45 41.96 41912 PERS-UNFUNDED 312,400.00 0.00 80,787.30 0.00 231,612.70 25.86 41920 MEDICARE 35,308.64 3,087.15 15,088.03 0.00 20,220.61 42.73 41929 SHORT TERM DISABILITY 3,337.63 306.71 1,389.70 0.00 1,947.93 41.63 41930 LONG TERM DISABILITY 7,093.09 656.90 2,961.31 0.00 4,131.78 41.74 41931 WORKERS COMP 21,529.02 1,959.46 8,714.29 0.00 12,814.73 40.47 User: KIMS Page: 2 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:17:14 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 581.89 51.07 253.13 0.00 328.76 43.50 41940 HEALTH INSURANCE 147,115.80 8,868.86 58,161.32 0.00 88,954.48 39.53 41941 RETIREES HEALTH INSURANCE/OPEB 166,068.00 0.00 0.00 0.00 166,068.00 0.00 41945 OPT OUT HEALTH INSURANCE 28,740.00 2,550.03 14,535.17 0.00 14,204.83 50.57 41946 LIFE INSURANCE 8,658.45 801.74 3,614.60 0.00 5,043.85 41.74 41996 VACANCY FACTOR (116,695.00) 0.00 0.00 0.00 (116,695.00) 0.00 41997 BUDGETARY/PAYROLL 90,811.00 0.00 0.00 0.00 20,811.00 0.00 TOTAL FOR SALARIES-BENEFITS 1,980,053.11 130,859.22 735,371.64 0.00 1,244,681.47 37.13
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 500.00 0.00 370.32 0.00 129.68 74.06 42033 CONSTRUCTION MATERIALS 180,000.00 0.00 68.62 173,100.00 6,831.38 96.20 42034 SAFETY MATERIALS/CONSTRUCTION 23.20 0.00 172.39 0.00 (149.19) 743.06 42055 COMPUTER EQUIPMENT & 846.53 43.46 283.43 26.53 536.57 36.61 42101 SAFETY SHOES - MOU ITEM 967.50 0.00 0.00 0.00 967.50 0.00 42200 ADVERTISING EXPENSE 510.00 0.00 549.52 0.00 (39.52) 107.74 42220 PROMOTIONAL/PUBLIC OUTREACH 274.18 0.00 0.00 137.09 137.09 50.00 42300 WIRELESS COMMUNICATION 5,333.96 418.50 2,107.70 0.00 3,226.26 39.51 42310 PHONES, FAX, ISDN LINES 3,743.00 231.98 1,504.20 0.00 2,238.80 40.18 42320 POSTAGE & SHIPPING 8,270.73 881.60 2,886.58 983.37 4,400.78 46.79 42340 OFFICE SUPPLIES 957.15 1.46 254.48 0.00 702.67 26.58 42350 PROGRAM EXPENDITURES 1,220.11 581.25 780.64 200.00 239.47 80.37 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 26.40 0.00 (26.40) 0.00 42410 ELECTRIC UTILITY 25,274.00 1,761.81 7,501.06 0.00 17,772.94 29.67 42415 WHOLESALE ENERGY 9,562,581.00 737,320.40 4,462,125.45 23,280.00 5,077,175.55 46.90 42500 RENTS & LEASES 148,367.00 37,091.75 74,183.50 0.00 74,183.50 50.00 42600 MOTOR POOL RENTAL 13,520.78 12,061.78 12,061.78 0.00 1,459.00 89.20 42605 RETAINED VEHICLE EXPENSE 2,096.64 2,096.64 2,096.64 0.00 0.00 100.00 42700 OTHER EQUIPMENT RENTAL 500.00 0.00 0.00 250.00 250.00 50.00 42710 MILEAGE/VEHICLE EXP REIMB 20.00 0.00 0.00 0.00 20.00 0.00 42813 MTCE & REPAIR - EQUIP & FAC 139,368.04 0.00 38,316.49 63,849.20 37,202.35 73.30 42815 SCADA MAINTENANCE 16,360.00 0.00 656.00 15,704.00 0.00 100.00 42900 PROF. & CONT. SVCS 855,381.47 29,455.23 130,119.70 444,040.87 281,220.90 67.12 42902 CUST CREDIT CRD PROCESSING FEE 13,571.21 2,174.51 5,759.75 1,787.44 6,024.02 55.61 43000 INSURANCE & SURETY BONDS 7,352.00 17,681.77 17,681.77 0.00 (10,329.77) 240.50 43100 MEMBERSHIP & DUES 19,732.00 0.00 12,099.00 0.00 7,633.00 61.31 43200 CONFERENCE, TRAINING & TRAVEL 6,790.00 30.00 103.00 0.00 6,687.00 1.51 43400 LEGAL SERVICES-SPECIAL COUNSEL 109,172.00 2,512.51 6,874.11 93,125.89 9,172.00 91.59 43715 REGULATORY PERMIT & USE FEES 4,026.00 4.40 1,003.59 0.00 3,022.41 24.92 43722 PREVENTION & MAINTENANCE 189,365.84 0.00 0.00 109,108.42 80,257.42 57.61 43726 PROJECT MANAGEMENT 0.00 45.60 45.60 0.00 (45.60) 0.00 User: KIMS Page: 3 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:17:14 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
44100 INTEREST EXPENSE 194,589.00 0.00 20,236.79 0.00 174,352.21 10.39 44200 BAD DEBTS EXPENSE 225,319.00 0.00 0.00 0.00 225,319.00 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 888,131.00 222,032.75 444,065.50 0.00 444,065.50 50.00 44613 INTERNAL SVC CHRG-WAREHOUSE 5,837.00 1,459.25 2,918.50 0.00 2,918.50 50.00 44614 INTERNAL SVC CHRG-INFO TECH 404,024.00 101,006.00 202,012.00 0.00 202,012.00 50.00 44630 FRANCHISE IN LIEU CHARGE 300,940.00 95,494.80 141,671.86 0.00 159,268.14 47.07 TOTAL FOR SERVICES-SUPPLIES 13,334,964.34 1,264,387.45 5,590,536.37 925,592.81 6,818,835.16 48.86 TOTAL FOR ELECTRIC UTILITY 15,315,017.45 1,395,246.67 6,325,908.01 925,592.81 8,063,516.63 47.34 FUN 578 17,049,394.38 1,456,130.20 6,522,684.27 1,070,286.21 9,456,423.90 44.53 User: KIMS Page: 4 Current Date: 01/21/2022
Report: GLREREES_Consolidated_Expenditure_Report Current Time: 12:17:14 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
579 ELECTRIC UTILITY GRANT/AGRMT
SALARIES NEIT ELECTRIC UTILITY
TOTAL FOR SALARIES-BENEFITS 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FOR ELECTRIC UTILITY 0.00 0.00 0.00 0.00 0.00 0.00 FUN 579 0.00 0.00 0.00 0.00 0.00 0.00
User: KIMS Page: 5 Current Date: 01/21/2022
Report: GREREES_Consolidated_Expenditure_Report Current Time: 12:17:14 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
GRAND TOTAL 17,049,394.38 1,456,130.20 6,522,684.27 1,070,286.21 9,456,423.90 44.53 User: KIMS Page: 6 Current Date: 01/21/2022
Report: GREREES_Consolidated_Expenditure_Report Current Time: 12:17:14