GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
578 ELECTRIC UTILITY FUND
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 62.56 250.24 0.00 (250.24) 0.00 41600 LONGEVITY 0.00 0.96 3.86 0.00 (3.86) 0.00
41910 PERS-NORMAL 0.00 7.24 28.95 0.00 (28.95) 0.00
41920 MEDICARE 0.00 1.88 7.53 0.00 (7.53) 0.00
41931 WORKERS COMP 0.00 1.25 5.01 0.00 (5.01) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.03 0.13 0.00 (0.13) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 73.92 295.72 0.00 (295.72) 0.00
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,392.52 0.00 (1,392.52) 0.00 42200 ADVERTISING EXPENSE 0.00 0.00 650.41 0.00 (650.41) 0.00 42900 PROF. & CONT. SVCS 173,881.95 17,342.40 148,629.15 58,716.13 (33,463.33) 119.24 43300 CONSTRUCTION CONTRACTS 0.00 0.00 83,869.64 0.00 (83,869.64) 0.00 43301 CAPITAL IMPROVEMENTS 0.00 0.00 0.00 48,436.50 (48,436.50) 0.00 43727 INSPECTION 0.00 760.00 760.00 0.00 (760.00) 0.00
TOTAL FOR SERVICES-SUPPLIES 1,546,472.90 18,102.40 235,301.72 107,152.63 1,204,018.55 22.14
CAPITAL OUTLAY
45100 LICENSED VEHICLES 0.00 0.00 30,324.52 0.00 (30,324.52) 0.00 45200 MACHINERY, EQUIPMENT, & FIXTUR 0.00 0.00 129,684.38 51,873.75 (181,558.13) 0.00 TOTAL FOR CAPITAL OUTLAY 0.00 0.00 160,008.90 51,873.75 (211,882.65) 0.00 TOTAL FOR NOT APPLICABLE 1,546,472.90 18,176.32 395,606.34 159,026.38 991,840.18 35.86 13 DEBT SERVICE
SALARIES-BENEFITS
41912 PERS-UNFUNDED 4,886,249.18 0.00 4,867,078.62 0.00 19,170.56 99.60 TOTAL FOR SALARIES-BENEFITS 4,886,249.18 0.00 4,867,078.62 0.00 19,170.56 99.60
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 0.00 0.00 19,170.56 0.00 (19,170.56) 0.00 44001 DS PRINCIPAL 2021 POBS 298,716.00 0.00 298,716.00 0.00 0.00 100.00 44101 DS INTEREST 2021 POBS 48,028.15 0.00 48,028.15 0.00 0.00 100.00 TOTAL FOR SERVICES-SUPPLIES 346,744.15 0.00 365,914.71 0.00 (19,170.56) 105.52 TOTAL FOR DEBT SERVICE 5,232,993.33 0.00 5,232,993.33 0.00 0.00 100.00 18 ADMIN SERVICES-FINANCE
SALARIES-BENEFITS
41912 PERS-UNFUNDED 517.74 0.00 517.74 0.00 0.00 100.00 TOTAL FOR SALARIES-BENEFITS 517.74 0.00 517.74 0.00 0.00 100.00 JULIEK Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:49:03
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
TOTAL FOR ADMIN SERVICES-FINANCE 517.74 0.00 517.74 0.00 0.00 100.00 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 114,220.23 2,805.66 50,748.95 0.00 63,471.28 44.43 41110 CONTRACTUAL OBLIGATION 0.00 0.00 14.63 0.00 (14.63) 0.00 41140 FINAL LEAVE 0.00 1,409.15 14,611.77 0.00 (14,611.77) 0.00 41141 SP COMP-BILINGUAL 509.00 56.30 269.39 0.00 239.61 52.92 41200 TEMPORARY EMPLOYEES 2,249.28 289.80 2,241.69 0.00 7.59 99.66 41300 OVERTIME 101.00 33.01 642.69 0.00 (541.69) 636.32 41400 SPECIAL DUTY PAY 2,390.00 0.00 1,665.51 0.00 724.49 69.68 41500 DEFERRED COMPENSATION MATCH 665.00 0.00 665.00 0.00 0.00 100.00 41510 PST DEFERRED COMPENSATION 29.21 3.77 29.13 0.00 0.08 99.72 41520 TIERED EMP DEF COMPENSATION 210.00 0.00 157.50 0.00 52.50 75.00 41530 TIERED RHS BENEFIT 210.00 0.00 157.50 0.00 52.50 75.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 13,131.45 326.00 5,874.79 0.00 7,256.66 44.73 41912 PERS-UNFUNDED 8,466.15 0.00 8,466.15 0.00 0.00 100.00 41920 MEDICARE 3,844.38 131.28 2,226.13 0.00 1,618.25 57.90 41929 SHORT TERM DISABILITY 365.53 19.82 288.74 0.00 76.79 78.99 41930 LONG TERM DISABILITY 776.76 36.98 615.01 0.00 161.75 79.17 41931 WORKERS COMP 2,340.01 63.03 1,040.18 0.00 1,299.83 44.45 41932 STATE UNEMPLOYMENT INSURANCE 62.66 2.33 38.00 0.00 24.66 60.64 41940 HEALTH INSURANCE 18,781.79 1,096.15 18,824.94 0.00 (43.15) 100.22 41946 LIFE INSURANCE 947.87 45.08 750.58 0.00 197.29 79.18 41951 HEALTH ALLOWANCE CREDIT 0.00 45.50 255.70 0.00 (255.70) 0.00 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 172,144.93 6,363.86 117,256.18 0.00 54,888.75 68.11
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 368.25 0.00 0.00 0.00 368.25 0.00 TOTAL FOR SERVICES-SUPPLIES 368.25 0.00 0.00 0.00 368.25 0.00 TOTAL FOR PUBLIC WORKS 172,513.18 6,363.86 117,256.18 0.00 55,257.00 67.96 52 ELECTRIC UTILITY
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 1,051,076.03 49,559.72 772,791.97 0.00 278,284.06 73.52 41103 OUT OF CLASS PAY 0.00 299.72 616.44 0.00 (616.44) 0.00 JULIEK Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:49:03
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
41110 CONTRACTUAL OBLIGATION 0.00 0.00 185.64 0.00 (185.64) 0.00 41140 FINAL LEAVE 0.00 0.00 62,304.72 0.00 (62,304.72) 0.00 41141 SP COMP-BILINGUAL 1,541.23 163.72 1,105.54 0.00 435.69 71.73 41147 SP COMP-GRADE 4 CERT PAY 2,040.00 0.00 1,423.36 0.00 616.64 69.77 41148 SP COMP-GRADE 5 CERT PAY 1,701.00 321.80 2,620.01 0.00 (919.01) 154.02 41200 TEMPORARY EMPLOYEES 2,182.47 58.34 494.55 0.00 1,687.92 22.66 41300 OVERTIME 18,256.00 899.13 6,141.59 0.00 12,114.41 33.64 41320 COMP TIME 0.00 137.73 504.21 0.00 (504.21) 0.00
41400 SPECIAL DUTY PAY 5,437.00 185.58 2,864.52 0.00 2,572.48 52.68 41410 AUTO ALLOWANCE 4,030.80 190.52 2,395.11 0.00 1,635.69 59.42 41500 DEFERRED COMPENSATION MATCH 7,854.00 951.38 6,517.52 0.00 1,336.48 82.98 41510 PST DEFERRED COMPENSATION 12.48 0.76 1.36 0.00 11.12 10.89 41520 TIERED EMP DEF COMPENSATION 2,478.00 547.49 2,341.37 0.00 136.63 94.48 41530 TIERED RHS BENEFIT 1,758.00 392.50 1,688.23 0.00 69.77 96.03 41600 LONGEVITY 13,759.10 580.27 18,309.63 0.00 (4,550.53) 133.07 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 17,575.70 0.00 (10,792.70) 259.11 41910 PERS-NORMAL 122,116.53 5,816.69 90,931.72 0.00 31,184.81 74.46 41912 PERS-UNFUNDED 80,787.30 0.00 80,787.30 0.00 0.00 100.00 41920 MEDICARE 35,431.64 1,610.88 27,890.44 0.00 7,541.20 78.71 41929 SHORT TERM DISABILITY 3,362.63 184.34 2,518.58 0.00 844.05 74.89 41930 LONG TERM DISABILITY 7,147.09 343.53 5,312.07 0.00 1,835.02 74.32 41931 WORKERS COMP 21,681.02 1,026.93 15,727.73 0.00 5,953.29 72.54 41932 STATE UNEMPLOYMENT INSURANCE 581.89 26.80 468.29 0.00 113.60 80.47 41940 HEALTH INSURANCE 160,502.80 9,228.82 117,914.92 0.00 42,587.88 73.46 41941 RETIREES HEALTH INSURANCE/OPEB 166,068.00 98,042.75 196,085.83 0.00 (30,017.83) 118.07 41945 OPT OUT HEALTH INSURANCE 25,292.00 718.00 23,330.72 0.00 1,961.28 92.24 41946 LIFE INSURANCE 8,722.45 419.34 6,484.04 0.00 2,238.41 74.33 41951 HEALTH ALLOWANCE CREDIT 0.00 468.94 2,839.92 0.00 (2,839.92) 0.00 41996 VACANCY FACTOR (116,695.00) 0.00 0.00 0.00 (116,695.00) 0.00 41997 BUDGETARY/PAYROLL 96,014.00 0.00 0.00 0.00 96,014.00 0.00 TOTAL FOR SALARIES-BENEFITS 1,772,574.41 172,175.68 1,512,278.40 0.00 260,296.01 85.31
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 51,509.89 113,100.00 15,390.11 91.44 42034 SAFETY MATERIALS/CONSTRUCTION 23.20 0.00 176.05 0.00 (152.85) 758.83 42055 COMPUTER EQUIPMENT & 846.53 43.46 544.19 26.76 275.58 67.44 42101 SAFETY SHOES - MOU ITEM 1,147.50 0.00 0.00 0.00 1,147.50 0.00 42200 ADVERTISING EXPENSE 510.00 0.00 549.52 0.00 (39.52) 107.74 JULIEK Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:49:03
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
42220 PROMOTIONAL/PUBLIC OUTREACH 274.18 0.00 80.24 56.85 137.09 50.00 42300 WIRELESS COMMUNICATION 5,333.96 380.76 4,580.45 0.00 753.51 85.87 42310 PHONES, FAX, ISDN LINES 3,743.00 309.40 3,034.54 0.00 708.46 81.07 42320 POSTAGE & SHIPPING 8,270.73 1,046.10 6,080.13 710.64 1,479.96 82.10 42340 OFFICE SUPPLIES 957.15 53.67 549.00 0.00 408.15 57.35 42350 PROGRAM EXPENDITURES 1,220.11 141.08 1,464.23 200.00 (444.12) 136.39 42360 CLEANING/JANITORIAL SUPPLIES 0.00 0.00 28.66 0.00 (28.66) 0.00 42410 ELECTRIC UTILITY 25,274.00 2,470.35 22,982.99 0.00 2,291.01 90.93 42415 WHOLESALE ENERGY 9,562,581.00 824,987.68 8,746,273.10 9,030.00 807,277.90 91.55 42500 RENTS & LEASES 148,367.00 0.00 111,275.25 0.00 37,091.75 75.00 42600 MOTOR POOL RENTAL 13,520.78 0.00 12,061.78 0.00 1,459.00 89.20 42605 RETAINED VEHICLE EXPENSE 2,096.64 0.00 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 8,409.30 90,993.29 11,997.40 36,377.35 73.89 42815 SCADA MAINTENANCE 16,360.00 0.00 5,942.29 12,417.71 (2,000.00) 112.22 42900 PROF. & CONT. SVCS 855,381.47 74,611.67 353,057.89 285,412.44 216,911.14 74.64 42902 CUST CREDIT CRD PROCESSING FEE 13,571.21 2,722.69 12,972.39 13,768.25 (13,169.43) 197.03 43000 INSURANCE & SURETY BONDS 7,352.00 0.00 17,681.77 0.00 (10,329.77) 240.50 43100 MEMBERSHIP & DUES 19,732.00 0.00 16,904.00 0.00 2,828.00 85.66 43200 CONFERENCE, TRAINING & TRAVEL 6,790.00 0.00 2,857.60 0.00 3,932.40 42.08 43400 LEGAL SERVICES-SPECIAL COUNSEL 109,172.00 3,486.18 18,037.84 81,962.16 9,172.00 91.59 43715 REGULATORY PERMIT & USE FEES 4,026.00 870.06 3,614.82 0.00 411.18 89.78 43722 PREVENTION & MAINTENANCE 189,365.84 0.00 9,600.00 99,508.42 80,257.42 57.61 43726 PROJECT MANAGEMENT 0.00 1,615.00 1,660.60 0.00 (1,660.60) 0.00 44100 INTEREST EXPENSE 194,589.00 0.00 39,212.59 0.00 155,376.41 20.15 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 0.00 666,098.25 0.00 222,032.75 75.00 44613 INTERNAL SVC CHRG-WAREHOUSE 5,837.00 0.00 4,377.75 0.00 1,459.25 75.00 44614 INTERNAL SVC CHRG-INFO TECH 404,024.00 0.00 303,018.00 0.00 101,006.00 75.00 44630 FRANCHISE IN LIEU CHARGE 300,940.00 0.00 204,314.65 0.00 96,625.35 67.89 TOTAL FOR SERVICES-SUPPLIES 13,335,144.34 921,147.40 10,714,000.71 628,440.63 1,992,703.00 85.05 TOTAL FOR ELECTRIC UTILITY 15,107,718.75 1,093,323.08 12,226,279.11 628,440.63 2,252,999.01 85.08 FUN 578 22,060,215.90 1,117,863.26 17,972,652.70 787,467.01 3,300,096.19 85.04 JULIEK Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:49:03
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
579 ELECTRIC UTILITY GRANT/AGRMT
00 NOT APPLICABLE
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 236,743.00 0.00 0.00 0.00 236,743.00 0.00 42830 REBATE PROGRAMS 0.00 0.00 236,743.00 0.00 (236,743.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 236,743.00 0.00 236,743.00 0.00 0.00 100.00 TOTAL FOR NOT APPLICABLE 236,743.00 0.00 236,743.00 0.00 0.00 100.00 52 ELECTRIC UTILITY
SALARIES-BENEFITS
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 236,743.00 0.00 236,743.00 0.00 0.00 100.00
JULIEK Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:49:03
User:
Report:
GL
06/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2022
OB 12
Ledger:
Level:
Month to
GRAND TOTAL 22,296,958.90 1,117,863.26 18,209,395.70 787,467.01 3,300,096.19 85.19 JULIEK Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
07/14/2022
Current Time: 13:49:03
User:
Report: