GL
09/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 03
Ledger:
Level:
Month to
578 ELECTRIC UTILITY FUND
00 NOT APPLICABLE
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 0.00 125.12 187.68 0.00 (187.68) 0.00 41520 TIERED EMP DEF COMPENSATION 0.00 0.94 0.94 0.00 (0.94) 0.00 41530 TIERED RHS BENEFIT 0.00 0.94 0.94 0.00 (0.94) 0.00 41600 LONGEVITY 0.00 1.92 2.88 0.00 (2.88) 0.00
41910 PERS-NORMAL 0.00 13.81 20.71 0.00 (20.71) 0.00
41920 MEDICARE 0.00 3.80 5.68 0.00 (5.68) 0.00
41929 SHORT TERM DISABILITY 0.00 0.52 0.78 0.00 (0.78) 0.00 41930 LONG TERM DISABILITY 0.00 0.85 1.27 0.00 (1.27) 0.00 41931 WORKERS COMP 0.00 2.51 3.77 0.00 (3.77) 0.00
41932 STATE UNEMPLOYMENT INSURANCE 0.00 0.07 0.11 0.00 (0.11) 0.00 41940 HEALTH INSURANCE 0.00 18.06 27.08 0.00 (27.08) 0.00 41946 LIFE INSURANCE 0.00 1.04 1.56 0.00 (1.56) 0.00
41951 HEALTH ALLOWANCE CREDIT 0.00 0.59 0.89 0.00 (0.89) 0.00 TOTAL FOR SALARIES-BENEFITS 0.00 170.17 254.29 0.00 (254.29) 0.00
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 1,448,034.54 0.00 0.00 0.00 1,448,034.54 0.00 42020 MINOR EQUIPMENT & FURNITURE 0.00 404.06 404.06 0.00 (404.06) 0.00 42033 CONSTRUCTION MATERIALS 0.00 68.62 68.62 0.00 (68.62) 0.00 42900 PROF. & CONT. SVCS 43,716.13 77.82 77.82 43,638.31 0.00 100.00 43300 CONSTRUCTION CONTRACTS 0.00 0.00 0.00 125,500.00 (125,500.00) 0.00 43301 CAPITAL IMPROVEMENTS 0.00 0.00 0.00 20,000.00 (20,000.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 1,491,750.67 550.50 550.50 189,138.31 1,302,061.86 12.71
CAPITAL OUTLAY
45200 MACHINERY, EQUIPMENT, & FIXTUR 51,873.75 0.00 0.00 51,873.75 0.00 100.00 TOTAL FOR CAPITAL OUTLAY 51,873.75 0.00 0.00 51,873.75 0.00 100.00 TOTAL FOR NOT APPLICABLE 1,543,624.42 720.67 804.79 241,012.06 1,301,807.57 15.66 13 DEBT SERVICE
SERVICES-SUPPLIES
44101 DS INTEREST 2021 POBS 87,023.39 0.00 (14,305.22) 0.00 101,328.61 (16.43) TOTAL FOR SERVICES-SUPPLIES 87,023.39 0.00 (14,305.22) 0.00 101,328.61 (16.43) TOTAL FOR DEBT SERVICE 87,023.39 0.00 (14,305.22) 0.00 101,328.61 (16.43) 21 COMMUNITY DEVELOPMENT
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 9,710.00 720.96 2,094.40 0.00 7,615.60 21.56 41141 SP COMP-BILINGUAL 227.50 17.50 52.50 0.00 175.00 23.07 41300 OVERTIME 0.00 0.00 33.01 0.00 (33.01) 0.00
JULIEK Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/18/2022
Current Time: 07:35:54
User:
Report:
GL
09/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 03
Ledger:
Level:
Month to
41910 PERS-NORMAL 1,081.20 80.34 233.58 0.00 847.62 21.60 41920 MEDICARE 293.15 21.82 64.36 0.00 228.79 21.95
41929 SHORT TERM DISABILITY 31.07 2.96 8.60 0.00 22.47 27.67 41930 LONG TERM DISABILITY 66.03 4.90 14.26 0.00 51.77 21.59 41931 WORKERS COMP 198.75 14.76 42.92 0.00 155.83 21.59 41932 STATE UNEMPLOYMENT INSURANCE 4.97 0.38 1.11 0.00 3.86 22.33 41940 HEALTH INSURANCE 930.05 72.22 216.60 0.00 713.45 23.28 41946 LIFE INSURANCE 80.59 5.98 17.38 0.00 63.21 21.56
41951 HEALTH ALLOWANCE CREDIT 0.00 4.42 13.26 0.00 (13.26) 0.00 41996 VACANCY FACTOR (471.00) 0.00 0.00 0.00 (471.00) 0.00 TOTAL FOR SALARIES-BENEFITS 12,152.31 946.24 2,791.98 0.00 9,360.33 22.97
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 30.00 0.00 0.00 0.00 30.00 0.00 42350 PROGRAM EXPENDITURES 17.00 0.00 0.00 0.00 17.00 0.00 TOTAL FOR SERVICES-SUPPLIES 47.00 0.00 0.00 0.00 47.00 0.00 TOTAL FOR COMMUNITY DEVELOPMENT DEPT12,199.31 946.24 2,791.98 0.00 9,407.33 22.88 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 150,238.43 4,055.89 12,226.01 0.00 138,012.42 8.13 41141 SP COMP-BILINGUAL 1,205.73 59.13 194.68 0.00 1,011.05 16.14 41200 TEMPORARY EMPLOYEES 2,915.34 196.83 553.25 0.00 2,362.09 18.97 41300 OVERTIME 0.00 76.62 78.74 0.00 (78.74) 0.00
41500 DEFERRED COMPENSATION MATCH 570.00 0.00 0.00 0.00 570.00 0.00 41510 PST DEFERRED COMPENSATION 37.90 2.56 7.19 0.00 30.71 18.97 41520 TIERED EMP DEF COMPENSATION 180.00 23.34 23.34 0.00 156.66 12.96 41530 TIERED RHS BENEFIT 180.00 23.34 23.34 0.00 156.66 12.96 41600 LONGEVITY 600.00 31.01 82.15 0.00 517.85 13.69
41700 ANNUAL LEAVE BUYBACK 7,858.92 0.00 5,207.04 0.00 2,651.88 66.25 41910 PERS-NORMAL 16,542.41 451.08 1,360.29 0.00 15,182.12 8.22 41920 MEDICARE 4,791.92 128.59 534.52 0.00 4,257.40 11.15 41929 SHORT TERM DISABILITY 480.76 16.63 50.10 0.00 430.66 10.42 41930 LONG TERM DISABILITY 1,021.62 27.59 83.18 0.00 938.44 8.14 41931 WORKERS COMP 3,087.18 86.23 259.45 0.00 2,827.73 8.40 41932 STATE UNEMPLOYMENT INSURANCE 81.41 2.25 9.30 0.00 72.11 11.42 41940 HEALTH INSURANCE 29,494.15 802.75 2,599.29 0.00 26,894.86 8.81 41946 LIFE INSURANCE 1,246.98 33.65 101.43 0.00 1,145.55 8.13 41951 HEALTH ALLOWANCE CREDIT 0.00 38.51 119.39 0.00 (119.39) 0.00 41996 VACANCY FACTOR (8,423.00) 0.00 0.00 0.00 (8,423.00) 0.00 41997 BUDGETARY/PAYROLL (184.52) 0.00 0.00 0.00 (184.52) 0.00 JULIEK Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/18/2022
Current Time: 07:35:54
User:
Report:
GL
09/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 03
Ledger:
Level:
Month to
TOTAL FOR SALARIES-BENEFITS 211,925.23 6,056.00 23,512.69 0.00 188,412.54 11.09
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 300.00 0.00 0.00 0.00 300.00 0.00 TOTAL FOR SERVICES-SUPPLIES 300.00 0.00 0.00 0.00 300.00 0.00 TOTAL FOR PUBLIC WORKS 212,225.23 6,056.00 23,512.69 0.00 188,712.54 11.07 52 ELECTRIC UTILITY
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 338,172.23 44,593.31 138,318.18 0.00 199,854.05 40.90 41103 OUT OF CLASS PAY 0.00 0.00 117.68 0.00 (117.68) 0.00 41140 FINAL LEAVE 0.00 0.00 195.64 0.00 (195.64) 0.00
41141 SP COMP-BILINGUAL 771.19 188.22 521.52 0.00 249.67 67.62 41147 SP COMP-GRADE 4 CERT PAY 240.00 0.00 0.00 0.00 240.00 0.00 41148 SP COMP-GRADE 5 CERT PAY 252.00 321.80 976.83 0.00 (724.83) 387.63 41200 TEMPORARY EMPLOYEES 13,111.19 620.45 1,966.70 0.00 11,144.49 15.00 41300 OVERTIME 8,379.00 767.07 1,786.23 0.00 6,592.77 21.31 41320 COMP TIME 0.00 57.39 57.39 0.00 (57.39) 0.00
41400 SPECIAL DUTY PAY 517.00 140.25 655.98 0.00 (138.98) 126.88 41410 AUTO ALLOWANCE 398.40 190.52 578.36 0.00 (179.96) 145.17 41500 DEFERRED COMPENSATION MATCH 806.00 431.36 431.36 0.00 374.64 53.51 41510 PST DEFERRED COMPENSATION 11.32 8.07 25.56 0.00 (14.24) 225.79 41520 TIERED EMP DEF COMPENSATION 372.00 506.52 506.52 0.00 (134.52) 136.16 41530 TIERED RHS BENEFIT 244.00 351.58 351.58 0.00 (107.58) 144.09 41600 LONGEVITY 928.95 541.18 1,850.82 0.00 (921.87) 199.23 41700 ANNUAL LEAVE BUYBACK 2,644.08 0.00 11,535.39 0.00 (8,891.31) 436.27 41710 ANNUAL LEAVE OVER MAX 19,334.00 0.00 0.00 0.00 19,334.00 0.00 41910 PERS-NORMAL 38,197.08 4,967.42 15,407.76 0.00 22,789.32 40.33 41920 MEDICARE 25,941.17 1,455.47 4,778.66 0.00 21,162.51 18.42 41929 SHORT TERM DISABILITY 1,082.15 182.87 567.41 0.00 514.74 52.43 41930 LONG TERM DISABILITY 5,532.49 303.09 940.37 0.00 4,592.12 16.99 41931 WORKERS COMP 7,079.54 931.05 2,890.81 0.00 4,188.73 40.83 41932 STATE UNEMPLOYMENT INSURANCE 182.80 24.27 81.25 0.00 101.55 44.44 41940 HEALTH INSURANCE 79,359.66 8,070.12 24,373.91 0.00 54,985.75 30.71 41941 RETIREES HEALTH INSURANCE/OPEB 126,012.00 0.00 0.00 0.00 126,012.00 0.00 41945 OPT OUT HEALTH INSURANCE 192.00 785.18 2,728.88 0.00 (2,536.88) 1,421.29 41946 LIFE INSURANCE 2,806.82 370.03 1,147.86 0.00 1,658.96 40.89 41951 HEALTH ALLOWANCE CREDIT 0.00 434.66 1,306.41 0.00 (1,306.41) 0.00 41996 VACANCY FACTOR (26,015.00) 0.00 0.00 0.00 (26,015.00) 0.00 41997 BUDGETARY/PAYROLL 1,721.00 0.00 0.00 0.00 1,721.00 0.00 TOTAL FOR SALARIES-BENEFITS 648,273.07 66,241.88 214,099.06 0.00 434,174.01 33.02 JULIEK Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/18/2022
Current Time: 07:35:54
User:
Report:
GL
09/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 03
Ledger:
Level:
Month to
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 2,100.00 0.00 0.00 0.00 2,100.00 0.00 42033 CONSTRUCTION MATERIALS 137,182.00 0.00 1,349.37 8,650.63 127,182.00 7.28 42034 SAFETY MATERIALS/CONSTRUCTION 60.00 0.00 0.00 0.00 60.00 0.00 42055 COMPUTER EQUIPMENT & 2,671.00 147.19 439.59 69.87 2,161.54 19.07 42100 UNIFORM EXPENSE 0.00 0.00 45.87 0.00 (45.87) 0.00 42101 SAFETY SHOES - MOU ITEM 372.00 0.00 0.00 0.00 372.00 0.00 42200 ADVERTISING EXPENSE 1,010.00 0.00 0.00 0.00 1,010.00 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 274.00 0.00 0.00 205.64 68.36 75.05 42300 WIRELESS COMMUNICATION 7,958.00 190.38 558.28 0.00 7,399.72 7.01 42310 PHONES, FAX, ISDN LINES 3,872.00 258.82 520.23 0.00 3,351.77 13.43 42320 POSTAGE & SHIPPING 8,557.00 1,288.93 1,317.74 4,535.94 2,703.32 68.40 42340 OFFICE SUPPLIES 1,077.00 28.13 104.72 0.00 972.28 9.72 42350 PROGRAM EXPENDITURES 3,158.00 62.90 377.42 0.00 2,780.58 11.95 42410 ELECTRIC UTILITY 26,888.00 1,014.61 4,308.68 0.00 22,579.32 16.02 42415 WHOLESALE ENERGY 10,445,741.00 1,417,308.51 3,087,107.10 33,280.00 7,325,353.90 29.87 42500 RENTS & LEASES 134,400.00 33,235.25 33,235.25 0.00 101,164.75 24.72 42600 MOTOR POOL RENTAL 24,806.00 0.00 0.00 0.00 24,806.00 0.00 42605 RETAINED VEHICLE EXPENSE 6,813.00 0.00 0.00 0.00 6,813.00 0.00 42700 OTHER EQUIPMENT RENTAL 24.57 0.00 0.00 24.57 0.00 100.00 42710 MILEAGE/VEHICLE EXP REIMB 20.00 0.00 0.00 0.00 20.00 0.00 42813 MTCE & REPAIR - EQUIP & FAC 108,000.00 0.00 0.00 110,000.00 (2,000.00) 101.85 42815 SCADA MAINTENANCE 13,250.00 164.00 164.00 10,586.00 2,500.00 81.13 42900 PROF. & CONT. SVCS 763,802.94 38,633.15 83,439.51 326,552.22 353,811.21 53.67 42902 CUST CREDIT CRD PROCESSING FEE 16,219.00 2,301.46 2,372.60 15,417.19 (1,570.79) 109.68 43000 INSURANCE & SURETY BONDS 18,212.00 0.00 18,504.93 0.00 (292.93) 101.60 43100 MEMBERSHIP & DUES 19,179.00 0.00 13,440.00 0.00 5,739.00 70.07 43200 CONFERENCE, TRAINING & TRAVEL 9,850.00 0.00 4.00 0.00 9,846.00 0.04 43400 LEGAL SERVICES-SPECIAL COUNSEL 109,172.00 11,204.02 11,204.02 92,377.99 5,589.99 94.87 43715 REGULATORY PERMIT & USE FEES 4,081.00 969.03 969.03 0.00 3,111.97 23.74 43722 PREVENTION & MAINTENANCE 131,308.00 0.00 0.00 101,308.42 29,999.58 77.15 44100 INTEREST EXPENSE 163,369.00 0.00 (127,945.13) 0.00 291,314.13 (78.31) 44200 BAD DEBTS EXPENSE 25,138.00 0.00 0.00 0.00 25,138.00 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 726,625.00 241,002.75 241,002.75 0.00 485,622.25 33.16 44613 INTERNAL SVC CHRG-WAREHOUSE 2,628.00 657.00 657.00 0.00 1,971.00 25.00 44614 INTERNAL SVC CHRG-INFO TECH 408,290.00 102,072.50 102,072.50 0.00 306,217.50 25.00 44630 FRANCHISE IN LIEU CHARGE 305,500.00 40,375.94 40,375.94 0.00 265,124.06 13.21 TOTAL FOR SERVICES-SUPPLIES 13,631,607.51 1,890,914.57 3,515,625.40 703,008.47 9,412,973.64 30.94 TOTAL FOR ELECTRIC UTILITY 14,279,880.58 1,957,156.45 3,729,724.46 703,008.47 9,847,147.65 31.04 FUN 578 16,134,952.93 1,964,879.36 3,742,528.70 944,020.53 11,448,403.70 29.04 JULIEK Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/18/2022
Current Time: 07:35:54
User:
Report:
GL
09/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 03
Ledger:
Level:
Month to
579 ELECTRIC UTILITY GRANT/AGRMT
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 0.00 0.00 0.00 0.00 0.00 0.00
JULIEK Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/18/2022
Current Time: 07:35:54
User:
Report:
GL
09/30/2022
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2023
OB 03
Ledger:
Level:
Month to
GRAND TOTAL 16,134,952.93 1,964,879.36 3,742,528.70 944,020.53 11,448,403.70 29.04 JULIEK Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/18/2022
Current Time: 07:35:54
User:
Report: