GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
576 DIRECT ACCESS ELECTRIC UTILITY
00 NOT APPLICABLE
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 13,904.28 0.00 0.00 0.00 13,904.28 0.00 42900 PROF. & CONT. SVCS 0.00 0.00 144.86 49.35 (194.21) 0.00 TOTAL FOR SERVICES-SUPPLIES 13,904.28 0.00 144.86 49.35 13,710.07 1.39 TOTAL FOR NOT APPLICABLE 13,904.28 0.00 144.86 49.35 13,710.07 1.39 13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 10.00 0.00 0.00 0.00 10.00 0.00 44101 DS INTEREST 2021 POBS 35,140.00 0.00 0.00 0.00 35,140.00 0.00 TOTAL FOR SERVICES-SUPPLIES 35,150.00 0.00 0.00 0.00 35,150.00 0.00 TOTAL FOR DEBT SERVICE 35,150.00 0.00 0.00 0.00 35,150.00 0.00 52 ELECTRIC UTILITY
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 133,689.82 5,583.06 18,163.45 0.00 115,526.37 13.58 41141 SP COMP-BILINGUAL 226.35 0.00 0.00 0.00 226.35 0.00 41200 TEMPORARY EMPLOYEES 1,168.17 0.00 0.00 0.00 1,168.17 0.00 41300 OVERTIME 1,366.00 0.00 691.74 0.00 674.26 50.63
41410 AUTO ALLOWANCE 115.20 0.00 0.00 0.00 115.20 0.00
41500 DEFERRED COMPENSATION MATCH 1,061.00 252.00 252.00 0.00 809.00 23.75 41510 PST DEFERRED COMPENSATION 8.04 0.00 0.00 0.00 8.04 0.00 41520 TIERED EMP DEF COMPENSATION 354.00 63.00 63.00 0.00 291.00 17.79 41530 TIERED RHS BENEFIT 326.00 63.00 63.00 0.00 263.00 19.32 41600 LONGEVITY 984.18 45.22 132.43 0.00 851.75 13.45
41700 ANNUAL LEAVE BUYBACK 5,377.20 0.00 0.00 0.00 5,377.20 0.00 41710 ANNUAL LEAVE OVER MAX 461.00 0.00 0.00 0.00 461.00 0.00 41910 PERS-NORMAL 16,323.58 678.21 2,204.69 0.00 14,118.89 13.50 41912 PERS-UNFUNDED 2,334.00 0.00 2,334.00 0.00 0.00 100.00 41920 MEDICARE 4,273.23 174.73 568.41 0.00 3,704.82 13.30 41929 SHORT TERM DISABILITY 427.84 27.46 79.45 0.00 348.39 18.57 41930 LONG TERM DISABILITY 909.10 45.56 131.77 0.00 777.33 14.49 41931 WORKERS COMP 2,731.86 111.67 364.60 0.00 2,367.26 13.34 41932 STATE UNEMPLOYMENT INSURANCE 129.19 5.11 17.25 0.00 111.94 13.35 41940 HEALTH INSURANCE 29,213.55 1,656.49 4,023.45 0.00 25,190.10 13.77 41945 OPT OUT HEALTH INSURANCE 672.00 0.00 0.00 0.00 672.00 0.00 41946 LIFE INSURANCE 1,109.60 55.60 160.83 0.00 948.77 14.49 41951 HEALTH ALLOWANCE CREDIT 0.00 67.18 163.15 0.00 (163.15) 0.00 41996 VACANCY FACTOR (48,910.00) 0.00 0.00 0.00 (48,910.00) 0.00 LUISN Page: 1 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:00:22
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
TOTAL FOR SALARIES-BENEFITS 154,350.91 8,828.29 29,413.22 0.00 124,937.69 19.05
SERVICES-SUPPLIES
42034 SAFETY MATERIALS/CONSTRUCTION 20.00 0.00 0.00 0.00 20.00 0.00 42055 COMPUTER EQUIPMENT & 427.86 0.00 0.00 0.00 427.86 0.00 42100 UNIFORM EXPENSE 0.00 0.00 121.97 0.00 (121.97) 0.00 42101 SAFETY SHOES - MOU ITEM 159.50 0.00 0.00 0.00 159.50 0.00 42200 ADVERTISING EXPENSE 531.00 0.00 0.00 0.00 531.00 0.00 42320 POSTAGE & SHIPPING 50.40 0.00 0.00 0.00 50.40 0.00 42340 OFFICE SUPPLIES 455.00 3.16 61.37 0.00 393.63 13.48 42350 PROGRAM EXPENDITURES 831.16 30.72 71.19 0.00 759.97 8.56 42365 RECYCLED CONTENT PRODUCTS 65.20 0.00 0.00 0.00 65.20 0.00 42410 ELECTRIC UTILITY 1,219.40 0.00 547.97 0.00 671.43 44.93 42415 WHOLESALE ENERGY 6,453,630.00 360,431.77 734,302.21 14,469.00 5,704,858.79 11.60 42500 RENTS & LEASES 23,570.00 5,892.50 5,892.50 0.00 17,677.50 25.00 42600 MOTOR POOL RENTAL - OPS & MTCE 46.00 0.00 0.00 0.00 46.00 0.00 42660 MOTOR POOL RENTAL- 120.00 0.00 0.00 0.00 120.00 0.00 42710 MILEAGE/VEHICLE EXP REIMB 10.00 0.00 0.00 0.00 10.00 0.00 42816 MOWING/LANDSCAPE CONTRACTS 140.00 0.00 0.00 0.00 140.00 0.00 42830 REBATE PROGRAMS 93,500.00 0.00 46,850.00 0.00 46,650.00 50.10 42900 PROF. & CONT. SVCS 125,848.70 9,890.40 19,784.83 109,801.74 (3,737.87) 102.97 43100 MEMBERSHIP & DUES 7,684.43 0.00 0.00 0.00 7,684.43 0.00 43200 CONFERENCE, TRAINING & TRAVEL 3,711.30 19.28 19.28 0.00 3,692.02 0.51 43400 LEGAL SERVICES-SPECIAL COUNSEL 43,932.00 2,992.97 2,992.97 0.00 40,939.03 6.81 43715 REGULATORY PERMIT & USE FEES 2,034.60 0.00 1.08 0.00 2,033.52 0.05 44610 ADMINISTRATIVE SERVICES CHARGE 161,544.00 40,386.00 40,386.00 0.00 121,158.00 25.00 44613 INTERNAL SVC CHRG-WAREHOUSE 217.00 54.25 54.25 0.00 162.75 25.00 44614 INTERNAL SVC CHRG-INFO TECH 167,646.00 41,911.50 41,911.50 0.00 125,734.50 25.00 TOTAL FOR SERVICES-SUPPLIES 7,087,393.55 461,612.55 892,997.12 124,270.74 6,070,125.69 14.35 TOTAL FOR ELECTRIC UTILITY 7,241,744.46 470,440.84 922,410.34 124,270.74 6,195,063.38 14.45 FUN 576 7,290,798.74 470,440.84 922,555.20 124,320.09 6,243,923.45 14.35 LUISN Page: 2 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:00:22
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
578 GREENFIELD ELECTRIC UTILITY FD
00 NOT APPLICABLE
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 1,884,349.56 0.00 0.00 0.00 1,884,349.56 0.00 42033 CONSTRUCTION MATERIALS 0.00 499.24 861.24 0.00 (861.24) 0.00 42900 PROF. & CONT. SVCS 195,873.60 24,155.60 24,572.52 179,267.35 (7,966.27) 104.06 43301 CAPITAL IMPROVEMENTS 0.00 0.00 0.00 520,000.00 (520,000.00) 0.00 TOTAL FOR SERVICES-SUPPLIES 2,080,223.16 24,654.84 25,433.76 699,267.35 1,355,522.05 34.83
CAPITAL OUTLAY
45100 LICENSED VEHICLES 67,827.37 0.00 1,522.50 67,827.37 (1,522.50) 102.24 45200 MACHINERY, EQUIPMENT, & FIXTUR 51,873.75 0.00 0.00 51,873.75 0.00 100.00 TOTAL FOR CAPITAL OUTLAY 119,701.12 0.00 1,522.50 119,701.12 (1,522.50) 101.27 TOTAL FOR NOT APPLICABLE 2,199,924.28 24,654.84 26,956.26 818,968.47 1,353,999.55 38.45 13 DEBT SERVICE
SERVICES-SUPPLIES
42900 PROF. & CONT. SVCS 16.00 0.00 0.00 0.00 16.00 0.00 44101 DS INTEREST 2021 POBS 48,526.00 0.00 (13,753.21) 0.00 62,279.21 (28.34) TOTAL FOR SERVICES-SUPPLIES 48,542.00 0.00 (13,753.21) 0.00 62,295.21 (28.33) TOTAL FOR DEBT SERVICE 48,542.00 0.00 (13,753.21) 0.00 62,295.21 (28.33) 21 PLANNING & DEVELOPMENT
SALARIES-BENEFITS
41912 PERS-UNFUNDED 192.00 0.00 192.00 0.00 0.00 100.00 TOTAL FOR SALARIES-BENEFITS 192.00 0.00 192.00 0.00 0.00 100.00 TOTAL FOR PLANNING & DEVELOPMENT DEPT 192.00 0.00 192.00 0.00 0.00 100.00 39 PUBLIC WORKS
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 151,473.53 2,555.15 6,191.71 0.00 145,281.82 4.08 41141 SP COMP-BILINGUAL 543.90 25.04 71.23 0.00 472.67 13.09 41200 TEMPORARY EMPLOYEES 5,406.34 249.26 1,099.61 0.00 4,306.73 20.33 41500 DEFERRED COMPENSATION MATCH 570.00 0.00 0.00 0.00 570.00 0.00 41510 PST DEFERRED COMPENSATION 70.29 3.24 14.28 0.00 56.01 20.31 41520 TIERED EMP DEF COMPENSATION 180.00 45.00 45.00 0.00 135.00 25.00 41530 TIERED RHS BENEFIT 180.00 45.00 45.00 0.00 135.00 25.00 41600 LONGEVITY 600.00 46.15 135.15 0.00 464.85 22.52
41700 ANNUAL LEAVE BUYBACK 3,140.70 0.00 0.00 0.00 3,140.70 0.00 41910 PERS-NORMAL 18,390.41 316.50 771.03 0.00 17,619.38 4.19 41912 PERS-UNFUNDED 2,743.00 0.00 2,743.00 0.00 0.00 100.00 41920 MEDICARE 4,731.39 79.87 199.92 0.00 4,531.47 4.22 LUISN Page: 3 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:00:22
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
41929 SHORT TERM DISABILITY 484.72 31.46 86.38 0.00 398.34 17.82 41930 LONG TERM DISABILITY 1,030.02 52.16 143.23 0.00 886.79 13.90 41931 WORKERS COMP 3,148.47 54.47 142.11 0.00 3,006.36 4.51 41932 STATE UNEMPLOYMENT INSURANCE 145.56 2.52 6.59 0.00 138.97 4.52 41940 HEALTH INSURANCE 22,095.86 978.82 2,385.19 0.00 19,710.67 10.79 41945 OPT OUT HEALTH INSURANCE 576.00 0.00 0.00 0.00 576.00 0.00 41946 LIFE INSURANCE 1,257.23 63.67 174.87 0.00 1,082.36 13.90 41996 VACANCY FACTOR (49,441.00) 0.00 0.00 0.00 (49,441.00) 0.00 TOTAL FOR SALARIES-BENEFITS 167,326.42 4,548.31 14,254.30 0.00 153,072.12 8.51
SERVICES-SUPPLIES
42101 SAFETY SHOES - MOU ITEM 238.75 0.00 0.00 0.00 238.75 0.00 TOTAL FOR SERVICES-SUPPLIES 238.75 0.00 0.00 0.00 238.75 0.00 TOTAL FOR PUBLIC WORKS 167,565.17 4,548.31 14,254.30 0.00 153,310.87 8.50 52 ELECTRIC UTILITY
SALARIES-BENEFITS
41100 PERMANENT EMPLOYEES 256,593.40 13,026.61 38,212.24 0.00 218,381.16 14.89 41141 SP COMP-BILINGUAL 362.85 0.00 0.00 0.00 362.85 0.00 41200 TEMPORARY EMPLOYEES 3,899.12 0.00 0.00 0.00 3,899.12 0.00 41300 OVERTIME 2,774.00 937.92 2,148.38 0.00 625.62 77.44 41400 SPECIAL DUTY PAY 2,816.00 196.48 575.41 0.00 2,240.59 20.43 41410 AUTO ALLOWANCE 115.20 0.00 0.00 0.00 115.20 0.00
41500 DEFERRED COMPENSATION MATCH 1,509.00 348.00 348.00 0.00 1,161.00 23.06 41510 PST DEFERRED COMPENSATION 24.12 0.00 0.00 0.00 24.12 0.00 41520 TIERED EMP DEF COMPENSATION 522.00 87.00 87.00 0.00 435.00 16.66 41530 TIERED RHS BENEFIT 470.00 87.00 87.00 0.00 383.00 18.51 41600 LONGEVITY 1,844.18 62.46 182.92 0.00 1,661.26 9.91 41700 ANNUAL LEAVE BUYBACK 9,347.95 0.00 0.00 0.00 9,347.95 0.00 41710 ANNUAL LEAVE OVER MAX 636.00 0.00 0.00 0.00 636.00 0.00 41910 PERS-NORMAL 31,437.64 1,577.23 4,626.60 0.00 26,811.04 14.71 41912 PERS-UNFUNDED 4,471.00 0.00 4,471.00 0.00 0.00 100.00 41920 MEDICARE 8,261.00 427.44 1,213.98 0.00 7,047.02 14.69 41929 SHORT TERM DISABILITY 821.10 54.04 156.87 0.00 664.23 19.10 41930 LONG TERM DISABILITY 1,744.84 89.62 260.22 0.00 1,484.62 14.91 41931 WORKERS COMP 5,261.85 261.73 769.58 0.00 4,492.27 14.62 41932 STATE UNEMPLOYMENT INSURANCE 250.96 12.80 37.08 0.00 213.88 14.77 41940 HEALTH INSURANCE 55,897.11 3,020.89 7,345.81 0.00 48,551.30 13.14 41941 RETIREES HEALTH INSURANCE/OPEB 60,048.00 0.00 0.00 0.00 60,048.00 0.00 41945 OPT OUT HEALTH INSURANCE 1,248.00 0.00 0.00 0.00 1,248.00 0.00 41946 LIFE INSURANCE 2,129.71 109.42 317.65 0.00 1,812.06 14.91 LUISN Page: 4 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:00:22
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
41951 HEALTH ALLOWANCE CREDIT 0.00 92.76 225.27 0.00 (225.27) 0.00 41996 VACANCY FACTOR (46,582.00) 0.00 0.00 0.00 (46,582.00) 0.00 TOTAL FOR SALARIES-BENEFITS 405,903.03 20,391.40 61,065.01 0.00 344,838.02 15.04
SERVICES-SUPPLIES
42020 MINOR EQUIPMENT & FURNITURE 0.00 539.40 850.28 0.00 (850.28) 0.00 42033 CONSTRUCTION MATERIALS 4,200.00 555.74 9,153.71 0.00 (4,953.71) 217.94 42034 SAFETY MATERIALS/CONSTRUCTION 40.00 0.00 0.00 0.00 40.00 0.00 42055 COMPUTER EQUIPMENT & 1,395.47 0.00 27.84 2.16 1,365.47 2.14 42100 UNIFORM EXPENSE 44.25 0.00 121.97 0.00 (77.72) 275.63 42101 SAFETY SHOES - MOU ITEM 371.75 0.00 0.00 0.00 371.75 0.00 42200 ADVERTISING EXPENSE 2,073.00 0.00 0.00 0.00 2,073.00 0.00 42220 PROMOTIONAL/PUBLIC OUTREACH 207.93 0.00 428.30 0.00 (220.37) 205.98 42300 WIRELESS COMMUNICATION 3,115.06 0.00 0.00 0.00 3,115.06 0.00 42310 PHONES, FAX, ISDN LINES 3,526.59 315.28 609.37 0.00 2,917.22 17.27 42320 POSTAGE & SHIPPING 9,982.54 401.91 1,331.16 0.00 8,651.38 13.33 42340 OFFICE SUPPLIES 732.19 0.00 67.88 0.00 664.31 9.27 42350 PROGRAM EXPENDITURES 1,054.35 30.72 79.95 0.00 974.40 7.58 42365 RECYCLED CONTENT PRODUCTS 89.80 0.00 0.00 0.00 89.80 0.00 42410 ELECTRIC UTILITY 14,316.00 827.64 (30,379.95) 0.00 44,695.95 (212.20) 42415 WHOLESALE ENERGY 10,801,225.00 629,774.54 1,299,211.68 19,981.00 9,482,032.32 12.21 42500 RENTS & LEASES 47,147.00 11,786.75 11,786.75 0.00 35,360.25 25.00 42600 MOTOR POOL RENTAL - OPS & MTCE 218.00 0.00 0.00 0.00 218.00 0.00 42660 MOTOR POOL RENTAL- 631.00 0.00 0.00 0.00 631.00 0.00 42710 MILEAGE/VEHICLE EXP REIMB 10.00 0.00 26.13 0.00 (16.13) 261.30 42813 MTCE & REPAIR - EQUIP & FAC 100,000.00 0.00 0.00 130,000.00 (30,000.00) 130.00 42815 SCADA MAINTENANCE 14,608.13 0.00 198.00 2,250.00 12,160.13 16.75 42816 MOWING/LANDSCAPE CONTRACTS 15,140.00 0.00 0.00 0.00 15,140.00 0.00 42830 REBATE PROGRAMS 185,000.00 0.00 92,600.00 0.00 92,400.00 50.05 42900 PROF. & CONT. SVCS 691,001.99 15,982.48 36,541.16 314,989.61 339,471.22 50.87 42902 CUST CREDIT CRD PROCESSING FEE 22,961.58 183.27 1,612.22 18,435.04 2,914.32 87.30 43000 INSURANCE & SURETY BONDS 25,901.70 0.00 18,233.14 0.00 7,668.56 70.39 43100 MEMBERSHIP & DUES 10,611.83 0.00 0.00 0.00 10,611.83 0.00 43200 CONFERENCE, TRAINING & TRAVEL 12,311.90 57.84 57.84 0.00 12,254.06 0.46 43400 LEGAL SERVICES-SPECIAL COUNSEL 60,668.00 2,329.83 2,329.83 0.00 58,338.17 3.84 43715 REGULATORY PERMIT & USE FEES 2,809.68 0.00 1.50 0.00 2,808.18 0.05 43716 JOB REQ CERTIFICATES & LICENSE 36.40 0.00 0.00 0.00 36.40 0.00 43722 PREVENTION & MAINTENANCE 173,432.00 7,781.76 7,781.76 92,218.24 73,432.00 57.65 44200 BAD DEBTS EXPENSE 17,814.30 0.00 0.00 0.00 17,814.30 0.00 44610 ADMINISTRATIVE SERVICES CHARGE 592,656.00 148,164.00 148,164.00 0.00 444,492.00 25.00 44613 INTERNAL SVC CHRG-WAREHOUSE 2,390.00 597.50 597.50 0.00 1,792.50 25.00 LUISN Page: 5 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:00:22
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
44614 INTERNAL SVC CHRG-INFO TECH 231,511.00 57,877.75 57,877.75 0.00 173,633.25 25.00 44615 INTERNAL SVC CHRG-NPDES 111,174.00 27,793.50 27,793.50 0.00 83,380.50 25.00 44630 FRANCHISE IN LIEU CHARGE 209,580.00 0.00 0.00 0.00 209,580.00 0.00 TOTAL FOR SERVICES-SUPPLIES 13,369,988.44 904,999.91 1,687,103.27 577,876.05 11,105,009.12 16.94 TOTAL FOR ELECTRIC UTILITY 13,775,891.47 925,391.31 1,748,168.28 577,876.05 11,449,847.14 16.88 FUN 578 16,192,114.92 954,594.46 1,775,817.63 1,396,844.52 13,019,452.77 19.59 LUISN Page: 6 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:00:22
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
579 ELECTRIC UTILITY GRANT/AGRMT
00 NOT APPLICABLE
SERVICES-SUPPLIES
40000 CIP & PROJECT EXPENSE 3,866.00 0.00 0.00 0.00 3,866.00 0.00 TOTAL FOR SERVICES-SUPPLIES 3,866.00 0.00 0.00 0.00 3,866.00 0.00 TOTAL FOR NOT APPLICABLE 3,866.00 0.00 0.00 0.00 3,866.00 0.00 FUN 579 3,866.00 0.00 0.00 0.00 3,866.00 0.00
LUISN Page: 7 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:00:22
User:
Report:
GL
09/30/2024
Budget
Expenditures
YTD Encumbrances
Balance
(Over)/Under
%
Used
CONSOLIDATED EXPENDITURE REPORT- BY FUND/DEPT
Fiscal Period:
Fiscal Year: 2025
OB 03
Ledger:
Level:
Month to
GRAND TOTAL 23,486,779.66 1,425,035.30 2,698,372.83 1,521,164.61 19,267,242.22 17.96 LUISN Page: 8 Current Date:
GLREREE5_Consolidated_Expenditure_Report
10/21/2024
Current Time: 09:00:22
User:
Report: