Loading...
Finance - Quarterly Reports - FY 23/24 4th Quarter - 09/30/2024CITY OF EAGLE TREASURER'S REPORT FOR THE QUARTER ENDING SEPTEMBER 30, 2024 BEGINNING CASH ANNUAL %ANNUAL %CHANGE IN ENDING CASH FUND NUMBER AND TITLE BALANCE REVENUES REALIZED EXPENDITURES EXPENDED BALANCE SHEET BALANCE 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:20PM PAGE: 1 01 GENERAL FUND 1,311,269.34 4,605,570.85 72.86 5,081,333.49 75.81 ( 28,073.31)863,580.01 06 LIBRARY FUND .00 509,094.05 87.72 520,084.25 92.05 ( 10,990.20).00 07 MUSEUM FUND .00 40,889.33 43.04 41,687.92 54.20 ( 798.59).00 08 PARK IMPACT FEE FUND 330,336.73 270,448.74 119.19 .00 8.59 206,288.74 394,496.73 09 RECREATION - SPECIAL EVENTS 15,514.91 23,466.38 99.05 22,141.96 85.31 ( 4,482.39)21,321.72 11 EXECUTIVE DEPARTMENT .00 84,649.69 63.25 87,320.64 63.39 ( 2,670.95).00 12 CITY CLERK/TREAS DEPARTMENT .00 155,483.99 80.67 164,389.74 81.76 ( 8,905.75).00 13 BUILDING DEPARTMENT .00 231,568.58 82.96 280,808.95 90.40 ( 49,240.37).00 14 P&Z DEPARTMENT .00 223,320.45 74.51 237,999.42 75.42 ( 14,678.97).00 17 RECREATION - ADM & ACTIVITIES .00 282,828.63 95.64 295,997.13 96.48 ( 13,168.50).00 18 IT DEPARTMENT .00 290,125.03 81.67 294,355.68 83.04 ( 4,230.65).00 19 CAPITAL PROJECTS FUND 174,762.72 759,111.56 15.71 1,404,973.73 25.39 ( 471,099.45).00 23 PUBLIC WORKS .00 571,410.53 75.00 606,552.58 73.36 ( 35,142.05).00 24 RECREATION - EAGLE FUN DAYS 1,651.16 62,147.07 48.69 63,798.23 48.69 .00 .00 25 PATHWAY IMPACT FEE FUND 44,383.84 42,383.97 74.31 .00 73.08 410.47 86,357.34 27 LAW ENF DEV IMPACT FEES 7,098.05 16,037.17 39.71 .00 .00 1,483.97 21,651.25 54 CITY HALL BOND FUND .00 97,085.39 99.33 97,085.39 99.33 .00 .00 60 WATER FUND 535,286.28 829,481.37 82.68 525,289.48 41.49 258,188.95 581,289.22 61 FIBER FUND 34,459.52 .00 1.16 148,875.69 39.11 ( 376,376.55)261,960.38 99 COMBINED CASH FUND ( 2,454,762.55).00 .00 .00 .00 ( 224,105.90) ( 2,230,656.65) TOTAL .00 9,095,102.78 9,872,694.28 ( 777,591.50).00 Citizens are invited to inspect the detailed supporting records of the attached financial statements. Idaho Code 50-1011 Making the Quarterly Treasurer’s Report available for public review on the City’s website shall satisfy publication requirements. Idaho Code 50-2080 For additional information, please contact Eagle City Hall, 208-939-6813. City of Eagle Kellie Rekow, CMC City Treasurer Posted to the City of Eagle website, October 28, 2024 CITY OF EAGLE COMBINED CASH INVESTMENT SEPTEMBER 30, 2024 FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:12PM PAGE: 1 COMBINED CASH ACCOUNTS 99-0103-00-00 CASH IN CHECKING 2,200,156.65 99-0108-00-00 CASH CLEARING-ACCOUNTS REC 30,500.00 TOTAL COMBINED CASH 2,230,656.65 99-0101-00-00 CASH ALLOCATED TO OTHER FUNDS ( 2,230,656.65) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 863,580.01 8 ALLOCATION TO PARK IMPACT FEE FUND 394,496.73 9 ALLOCATION TO RECREATION - SPECIAL EVENTS 21,321.72 25 ALLOCATION TO PATHWAY IMPACT FEE FUND 86,357.34 27 ALLOCATION TO LAW ENF DEV IMPACT FEES 21,651.25 60 ALLOCATION TO WATER FUND 581,289.22 61 ALLOCATION TO FIBER FUND 261,960.38 TOTAL ALLOCATIONS TO OTHER FUNDS 2,230,656.65 ALLOCATION FROM COMBINED CASH FUND - 99-0101-00-00 ( 2,230,656.65) ZERO PROOF IF ALLOCATIONS BALANCE .00 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 GENERAL FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:12PM PAGE: 2 ASSETS 01-0101-00-00 CASH 863,580.01 01-0103-00-00 PETTY CASH 150.00 01-0107-00-00 TAXES RECEIVABLE DELINQUENT 22,574.55 01-0115-00-00 ACCOUNTS RECEIVABLE ( 18,341.37) 01-0132-00-00 DUE FROM OTHER GOVERNMNTL UNTS 922,768.40 01-0151-25-00 INVESTMENTS 10,384,790.44 01-0151-28-00 ICCU CD 54,366.25 01-0151-30-00 INVESTMENTS - AVIMOR ITD FEE 150,579.24 01-0170-00-00 HRA 10 % DEPOSIT 5,785.92 TOTAL ASSETS 12,386,253.44 LIABILITIES AND EQUITY LIABILITIES 01-0202-00-00 VOUCHERS PAYABLE 581,148.63 01-0203-01-01 BONDS/SURETIES/DEPOSITS PYBLE 4,035,724.24 01-0203-01-03 VENDORS BOND DEPOSITS PAYABLE 3,000.00 01-0203-01-05 P&Z DEPOSITS PAYABLE ( 25,546.28) 01-0203-01-06 LAND USE DEPOSITS PYBLE, ICCU 54,366.25 01-0217-07-00 INSURANCE ( 12,148.40) 01-0217-07-01 COBRA INSURANCE ( 3,253.36) 01-0217-09-00 WORKERS' COMPENSATION 5.52 01-0220-00-00 ACCOUNTS RECEIVABLE, DEPOSITS 40,500.00 01-0220-02-00 ITD, AVIMOR, DEPOSITS 150,579.24 01-0226-00-00 DEFERRED REVENUE 20,335.95 TOTAL LIABILITIES 4,844,711.79 FUND EQUITY 01-0271-00-00 FUND BALANCE 8,175,506.02 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 633,964.37) BALANCE - CURRENT DATE ( 633,964.37) TOTAL FUND EQUITY 7,541,541.65 TOTAL LIABILITIES AND EQUITY 12,386,253.44 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:13PM PAGE: 3 REVENUE 01-0311-00-00 PROPERTY TAX 1,571,213.54 4,784,542.52 4,762,920.00 ( 21,622.52)100.5 01-0311-01-00 PENALTY/INTEREST ON TAXES 1,757.80 5,289.92 4,500.00 ( 789.92)117.6 01-0312-00-00 PERSONAL PROPERTY TAX REIMBURS 5,151.05 10,302.10 8,463.00 ( 1,839.10)121.7 01-0316-10-02 FRANCHISE FEE, VEOLIA 9,942.29 35,734.12 30,000.00 ( 5,734.12)119.1 01-0316-11-00 FRANCHISE FEE, INTERMTN GAS 68,044.67 354,254.03 350,000.00 ( 4,254.03)101.2 01-0316-12-00 FRANCHISE FEE, CABLE TV 21,272.83 88,415.14 115,000.00 26,584.86 76.9 01-0316-13-00 FRANCHISE FEE, SOLID WASTE 96,087.08 378,740.44 350,000.00 ( 28,740.44)108.2 01-0316-14-00 FRANCHISE FEE, IDAHO POWER 59,851.46 275,498.82 250,000.00 ( 25,498.82)110.2 01-0321-10-00 BUSINESS, ALCOHOL, MISC-LCNSES 10,443.94 72,364.53 56,500.00 ( 15,864.53)128.1 01-0321-10-01 BACKGROUND CHECKS 284.75 3,099.00 1,500.00 ( 1,599.00)206.6 01-0322-10-00 BUILDING & INSPECTION PERMITS 505,406.92 1,856,926.57 1,025,000.00 ( 831,926.57)181.2 01-0322-12-00 BUILDING, PLAN REVIEW FEES 186,566.43 700,800.58 478,750.00 ( 222,050.58)146.4 01-0322-13-00 ENERGY STANDARDS (IRES)6,950.00 26,450.00 12,500.00 ( 13,950.00)211.6 01-0322-14-00 ELECTRICAL PERMIT FEES 73,255.94 267,870.79 200,000.00 ( 67,870.79)133.9 01-0322-15-00 PLUMBING PERMIT FEES 63,570.62 209,681.07 184,000.00 ( 25,681.07)114.0 01-0322-16-00 MECHANICAL PERMIT FEES 77,747.11 269,496.53 184,000.00 ( 85,496.53)146.5 01-0322-20-00 ADMIN FEES, FIRE & ITD AVIMOR 3,420.00 10,340.00 5,000.00 ( 5,340.00)206.8 01-0323-01-00 PZ ANNEX/ZONING PERMIT FEES 55,535.37 205,451.44 85,000.00 ( 120,451.44)241.7 01-0323-02-00 PLANNING INSPECTION FEES 4,800.00 18,550.00 5,000.00 ( 13,550.00)371.0 01-0323-03-00 PLANNING, PLAN REVIEW FEES 10,900.00 43,291.74 20,000.00 ( 23,291.74)216.5 01-0323-04-00 STREET LIGHT INSPECTION FEES 1,370.00 3,000.00 800.00 ( 2,200.00)375.0 01-0323-05-00 SURETY/LETTER OF CREDIT FEES 2,150.00 6,850.00 4,000.00 ( 2,850.00)171.3 01-0323-06-00 GRADING-DRAINAGE PERMIT FEES 4,827.50 9,758.75 6,000.00 ( 3,758.75)162.7 01-0323-10-00 SPRING VALLEY STAFF TIME REIMB 7,474.68 12,210.00 10,000.00 ( 2,210.00)122.1 01-0323-11-00 AVIMOR STAFF TIME REIMBURSE 2,213.25 6,547.65 10,000.00 3,452.35 65.5 01-0335-10-00 STATE, LIQUOR DISTRIBUTION 233,215.00 506,183.00 665,000.00 158,817.00 76.1 01-0335-50-00 STATE, AG EQUIPMENT REPL TAX 4.75 19.00 19.00 .00 100.0 01-0335-60-00 STATE, SALES TAX REV SHARING 1,000,333.32 3,582,467.14 3,914,826.00 332,358.86 91.5 01-0338-40-00 COURT FEES 20,558.66 98,393.38 55,000.00 ( 43,393.38)178.9 01-0338-41-00 CITATION FEES/CODE ENFORCEMENT .00 .00 500.00 500.00 .0 01-0338-42-00 NUISANCE ABATEMENT .00 .00 1,000.00 1,000.00 .0 01-0341-12-00 ANIMAL CONTROL FEES 2,310.00 9,820.50 12,000.00 2,179.50 81.8 01-0341-13-00 ENGINEERING FEES - DEVELOPERS 83,762.42 230,546.22 175,000.00 ( 55,546.22)131.7 01-0341-14-00 ATTORNEY FEES - DEVELOPERS 3,233.25 14,240.75 30,000.00 15,759.25 47.5 01-0341-17-00 CID STAFF & MISC REIMBURSEMENT 595.24 3,190.05 .00 ( 3,190.05).0 01-0341-20-00 REIMBURSE FROM WATER DEPT 3,009.00 12,036.00 13,410.00 1,374.00 89.8 01-0341-20-01 REIMBURSE FROM FIBER DEPT 1,203.00 4,812.00 5,000.00 188.00 96.2 01-0341-27-00 URA CITY STAFF REIMBURSEMENT 461.54 2,802.58 3,000.00 197.42 93.4 01-0341-28-00 ID POWER SUBSTATION WATER USE .00 .00 120.00 120.00 .0 01-0341-29-00 REVEL EAGLE-EASEMENT-MERRILL P .00 1,000.00 1,000.00 .00 100.0 01-0350-02-00 IDAHO OPIOID SETTLEMENT 7,085.20 22,196.10 15,000.00 ( 7,196.10)148.0 01-0350-05-00 FIELD OF HONOR 165.00 27,386.03 25,000.00 ( 2,386.03)109.5 01-0350-07-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 01-0350-50-00 DONATIONS - MISCELLANEOUS .00 .00 5,000.00 5,000.00 .0 01-0371-25-00 BANK INTEREST 130,585.21 423,660.71 25,000.00 ( 398,660.71)1694.6 01-0379-00-00 MISCELLANEOUS REVENUE 2,799.26 20,374.32 1,000.00 ( 19,374.32)2037.4 01-0379-01-00 DUPLICATION/PUBLISHING/PRINTNG ( 6.48)101.52 500.00 398.48 20.3 01-0383-05-00 MISCELLANEOUS-REIMBURSEABLES 3,623.76 12,620.43 1,500.00 ( 11,120.43)841.4 01-0383-09-00 ROOM RESERVATIONS 1,278.87 7,650.89 4,000.00 ( 3,650.89)191.3 01-0383-16-00 INSURANCE REIMBURSEABLES 1,952.96 5,122.74 .00 ( 5,122.74).0 01-0385-00-00 FIRE DEPT IMPACT FEES 259,163.66 982,899.76 224,250.00 ( 758,649.76)438.3 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:13PM PAGE: 4 01-0399-00-00 CARRY OVER .00 .00 8,103,480.00 8,103,480.00 .0 TOTAL FUND REVENUE 4,605,570.85 15,622,988.86 21,443,538.00 5,820,549.14 72.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:13PM PAGE: 5 RESERVES 01-0410-19-00 RESERVES, EMERGENCIES .00 .00 43,215.00 43,215.00 .0 TOTAL RESERVES .00 .00 43,215.00 43,215.00 .0 ADMINISTRATION 01-0413-01-00 P&Z COMMISSIONERS COMPENSATION 650.00 3,780.00 4,300.00 520.00 87.9 01-0413-02-00 DESIGN REVIEW BRD COMPENSATION 1,950.00 4,750.00 5,000.00 250.00 95.0 01-0413-05-00 OFFICE SUPPLIES 5,071.85 17,885.36 25,000.00 7,114.64 71.5 01-0413-06-00 PRINTING & DISTRIBUTION 70.00 148.00 500.00 352.00 29.6 01-0413-07-00 POSTAGE 1,814.25 7,195.95 12,500.00 5,304.05 57.6 01-0413-08-00 LEGAL ADVERTISING/PUBLICATION 3,944.79 6,199.68 5,000.00 ( 1,199.68)124.0 01-0413-10-00 INSURANCE - PROPERTY 157.50 72,815.50 82,000.00 9,184.50 88.8 01-0413-12-00 PERSONNEL TRAINING .00 650.00 3,000.00 2,350.00 21.7 01-0413-13-00 TRAVEL & PER DIEM 110.80 110.80 2,000.00 1,889.20 5.5 01-0413-14-00 PROFESSIONAL DUES AND SERVICES 3,572.50 50,320.60 153,000.00 102,679.40 32.9 01-0413-25-00 MISCELLANEOUS 35.00 516.69 20,000.00 19,483.31 2.6 01-0413-28-00 RESOURCE MATERIALS 841.28 1,280.06 6,500.00 5,219.94 19.7 01-0413-29-00 REAL PROPERTY TAXES - CITY .00 339.50 400.00 60.50 84.9 01-0413-31-00 ENGINEERING FEES - DEVELOPERS 105,300.62 288,069.61 175,000.00 ( 113,069.61)164.6 01-0413-33-00 ATTORNEY FEES - DEVELOPERS 4,086.25 10,675.00 30,000.00 19,325.00 35.6 01-0413-37-00 BACKGROUND CHECK-PERMITS/LIC 1,097.25 2,759.75 2,500.00 ( 259.75)110.4 01-0413-44-00 PHOTOS - MAYOR/CITY COUNCIL .00 361.65 900.00 538.35 40.2 01-0413-50-00 RECRUITING .00 2,105.21 2,500.00 394.79 84.2 01-0413-51-00 BACKGROUND CHK, PRE-EMPLOYMENT 688.50 1,869.50 1,000.00 ( 869.50)187.0 01-0413-52-00 DRUG TESTING, PRE-EMPLOYMENT 455.00 1,015.00 1,000.00 ( 15.00)101.5 TOTAL ADMINISTRATION 129,845.59 472,847.86 532,100.00 59,252.14 88.9 PERSONNEL 01-0415-11-00 SALARIES - COUNCIL 16,224.96 61,394.88 65,000.00 3,605.12 94.5 01-0415-21-00 FICA 1,241.28 4,696.92 5,000.00 303.08 93.9 01-0415-22-00 PERSI 1,940.52 6,990.48 7,775.00 784.52 89.9 01-0415-23-01 HRA/COBRA ADMIN FEES 678.08 1,687.48 1,800.00 112.52 93.8 01-0415-24-00 WORKERS' COMPENSATION .00 66,871.91 68,000.00 1,128.09 98.3 01-0415-24-01 WORK COMP/BOARDS-COMMISSIONS .00 108.32 200.00 91.68 54.2 01-0415-28-00 UNEMPLOYMENT BENEFITS .00 .00 5,500.00 5,500.00 .0 TOTAL PERSONNEL 20,084.84 141,749.99 153,275.00 11,525.01 92.5 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:13PM PAGE: 6 CONTRACTS & AGREEMENTS 01-0416-02-00 CITY ATTORNEY 80,349.69 219,515.15 250,000.00 30,484.85 87.8 01-0416-02-03 SETTLEMENTS 61,500.00 61,500.00 .00 ( 61,500.00).0 01-0416-05-00 PROSECUTOR - ADA, BOISE, GEM 32,239.59 141,025.00 129,000.00 ( 12,025.00)109.3 01-0416-06-00 IDAHO HUMANE SOCIETY 42,927.34 171,709.77 171,800.00 90.23 100.0 01-0416-07-00 CITY ENGINEERING 1,174.00 4,688.75 20,000.00 15,311.25 23.4 01-0416-08-00 CITY AUDITOR SERVICES .00 16,850.00 22,300.00 5,450.00 75.6 01-0416-09-00 LAW ENFORCEMENT DEPARTMENT 1,133,552.49 4,534,209.96 4,232,000.00 ( 302,209.96)107.1 01-0416-34-00 BUDGET RESERVES, FY 1ST QTR .00 .00 1,500,000.00 1,500,000.00 .0 01-0416-35-00 ADMINISTRATION RESERVES .00 .00 100,000.00 100,000.00 .0 01-0416-46-00 ALLUMBAUGH HOUSE 4,437.25 17,749.00 17,800.00 51.00 99.7 01-0416-49-00 DRUGFREE IDAHO 460.04 2,015.88 2,000.00 ( 15.88)100.8 01-0416-54-00 IDAHO CRISIS & SUICIDE HOTLINE .00 10,000.00 10,000.00 .00 100.0 01-0416-56-00 CRIME STOPPERS .00 3,500.00 3,520.00 20.00 99.4 TOTAL CONTRACTS & AGREEMENTS 1,356,640.40 5,182,763.51 6,458,420.00 1,275,656.49 80.3 CODE ENFORCEMENT 01-0417-00-00 NUISANCE ABATEMENT .00 .00 5,000.00 5,000.00 .0 TOTAL CODE ENFORCEMENT .00 .00 5,000.00 5,000.00 .0 RESTRICTED 01-0422-02-00 IDAHO OPIOID SUPPORT .00 .00 15,000.00 15,000.00 .0 01-0422-06-00 FIELD OF HONOR 19,776.52 20,261.03 25,000.00 4,738.97 81.0 01-0422-15-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 TOTAL RESTRICTED 19,776.52 20,261.03 44,000.00 23,738.97 46.1 PUBLIC AFFAIRS/COMM RELATIONS 01-0462-01-00 PUBLIC RELATIONS 3,007.63 6,014.31 6,000.00 ( 14.31)100.2 01-0462-02-00 AWARDS & RECOGNITIONS 35.53 125.43 1,500.00 1,374.57 8.4 TOTAL PUBLIC AFFAIRS/COMM RELATIONS 3,043.16 6,139.74 7,500.00 1,360.26 81.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:13PM PAGE: 7 GENERAL FUND TRANSFERS 01-0463-01-00 MUSEUM DEPT TRANSFER 40,767.33 84,158.17 180,610.00 96,451.83 46.6 01-0463-05-00 RECREATION, SPECIAL EVNTS TRNS .00 29,465.04 38,075.00 8,609.96 77.4 01-0463-06-00 RECREATION, REC TRANSFER 206,010.30 570,036.81 807,120.00 237,083.19 70.6 01-0463-07-00 CAPITAL PROJECTS TRANSFER 697,153.26 955,187.65 2,998,200.00 2,043,012.35 31.9 01-0463-08-00 RECREATION, EAGLE FUN DAYS TRN 58,875.96 64,885.96 126,400.00 61,514.04 51.3 01-0463-11-00 PUBLIC WORKS TRANSFER 542,245.05 2,169,203.23 2,884,511.00 715,307.77 75.2 01-0463-11-01 EXECUTIVE DEPT TRANSFER 84,649.69 418,994.73 662,430.00 243,435.27 63.3 01-0463-12-00 CITY HALL BOND FUND TRANSFER 97,085.39 104,044.80 104,750.00 705.20 99.3 01-0463-12-01 CLERK/TREAS DEPT TRANSFER 155,483.99 654,004.69 810,700.00 156,695.31 80.7 01-0463-13-01 BUILDING DEPT TRANSFER 231,568.58 886,683.73 1,068,860.00 182,176.27 83.0 01-0463-14-01 PLANNING AND ZONING DEPT TRANS 223,320.45 959,673.91 1,288,000.00 328,326.09 74.5 01-0463-15-00 LIBRARY TRANSFER 504,302.96 1,434,721.14 1,672,392.00 237,670.86 85.8 01-0463-18-01 IT DEPT TRANSFER 290,125.03 983,736.48 1,204,530.00 220,793.52 81.7 TOTAL GENERAL FUND TRANSFERS 3,131,587.99 9,314,796.34 13,846,578.00 4,531,781.66 67.3 COMMUNITY PROJECTS-CAP OUTLAY 01-0468-10-00 VALLEY REGIONAL TRANSIT SERV .00 129,162.00 129,200.00 38.00 100.0 TOTAL COMMUNITY PROJECTS-CAP OUTLA .00 129,162.00 129,200.00 38.00 100.0 FIRE DEPARTMENT IMPACT FEES 01-0469-00-00 FIRE DEPT IMPACT FEES 420,354.99 989,232.76 224,250.00 ( 764,982.76)441.1 TOTAL FIRE DEPARTMENT IMPACT FEES 420,354.99 989,232.76 224,250.00 ( 764,982.76)441.1 TOTAL FUND EXPENDITURES 5,081,333.49 16,256,953.23 21,443,538.00 5,186,584.77 75.8 NET REVENUE OVER EXPENDITURES ( 475,762.64)( 633,964.37).00 633,964.37 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 LIBRARY FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:13PM PAGE: 8 ASSETS 06-0107-00-00 TAXES RECEIVABLE 1,076.00 06-0170-00-00 HRA 10% DEPOSIT 1,872.00 TOTAL ASSETS 2,948.00 LIABILITIES AND EQUITY LIABILITIES 06-0202-00-00 VOUCHERS PAYABLE 3,905.88 06-0216-00-00 LIBRARY/ACCRUED PAYROLL 19,220.15 06-0217-03-00 FICA 3,039.93 06-0217-04-00 PERSI RETIREMENT 3,284.67 06-0217-07-00 INSURANCE 25,686.20 06-0217-09-00 WORKERS' COMPENSATION 17,055.43 06-0217-10-00 HSA CONTRIBUTION 2,454.00 06-0226-00-00 DEFERRED REVENUE 1,048.03 TOTAL LIABILITIES 75,694.29 FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 72,746.29) BALANCE - CURRENT DATE ( 72,746.29) TOTAL FUND EQUITY ( 72,746.29) TOTAL LIABILITIES AND EQUITY 2,948.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:14PM PAGE: 9 REVENUE 06-0301-00-00 FUNDING FROM GENERAL FUND 504,302.96 1,434,721.14 1,672,392.00 237,670.86 85.8 06-0356-00-00 LIBRARY/PROPERTY TAX REVENUE .00 2,789.52 .00 ( 2,789.52).0 06-0356-01-00 LIBRARY/PENALTY & INT PROP TXS .00 357.90 .00 ( 357.90).0 06-0361-20-00 LIBRARY, FINES, FEES 1,172.22 4,037.43 1,000.00 ( 3,037.43)403.7 06-0361-20-01 LOST ITEMS 2,472.58 8,571.57 2,500.00 ( 6,071.57)342.9 06-0361-21-00 LIBRARY COPY MACHINE 800.53 2,976.27 1,200.00 ( 1,776.27)248.0 06-0361-21-01 3 D PRINTING .00 6.31 .00 ( 6.31).0 06-0379-00-00 MISCELLANEOUS REVENUE 407.13 1,368.95 750.00 ( 618.95)182.5 06-0379-01-00 MISCELLANEOUS REV NON TAXABLE ( 61.37)1,439.57 .00 ( 1,439.57).0 06-0380-01-00 GRANTS .00 15,000.00 .00 ( 15,000.00).0 06-0380-03-00 SPONSORSHIPS .00 5,000.00 5,000.00 .00 100.0 TOTAL FUND REVENUE 509,094.05 1,476,268.66 1,682,842.00 206,573.34 87.7 EXPENDITURES CONTRACTS/AGREEMENTS 06-0416-01-00 LEGAL - CITY ATTORNEY .00 560.00 .00 ( 560.00).0 06-0416-02-00 PHOTOCOPIERS 2,487.22 8,350.80 13,000.00 4,649.20 64.2 TOTAL CONTRACTS/AGREEMENTS 2,487.22 8,910.80 13,000.00 4,089.20 68.5 OPERATIONS & MAINTENANCE 06-0420-01-00 ADMINISTRATION 5,957.19 19,480.92 15,000.00 ( 4,480.92)129.9 06-0420-04-00 MARKETING 20,110.19 35,077.35 19,000.00 ( 16,077.35)184.6 06-0420-04-01 OUTREACH .00 5,632.39 5,000.00 ( 632.39)112.7 06-0420-05-00 OFFICE SUPPLIES 1,257.37 5,364.68 9,100.00 3,735.32 59.0 06-0420-05-01 MATERIAL PROCESSING SUPPLIES 3,064.57 10,403.18 5,000.00 ( 5,403.18)208.1 06-0420-06-00 UNIFORMS .00 4,305.32 4,650.00 344.68 92.6 06-0420-07-00 SMALL FURNITURE REPLACEMENT .00 5,453.11 2,000.00 ( 3,453.11)272.7 06-0420-10-00 POSTAGE 3,037.99 4,869.05 2,500.00 ( 2,369.05)194.8 06-0420-11-00 SUBSCRIPTIONS & MEMBERSHIPS 1,798.20 2,055.01 5,100.00 3,044.99 40.3 06-0420-13-00 PRINTING AND PUBLISHING .00 .00 1,200.00 1,200.00 .0 TOTAL OPERATIONS & MAINTENANCE 35,225.51 92,641.01 68,550.00 ( 24,091.01)135.1 LYNX1 CONSORTIUM 06-0430-00-00 LYNX! SYSTEM 5,732.46 22,929.84 26,750.00 3,820.16 85.7 06-0430-02-00 LYNX! COURIER 3,453.00 13,936.59 16,900.00 2,963.41 82.5 TOTAL LYNX1 CONSORTIUM 9,185.46 36,866.43 43,650.00 6,783.57 84.5 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:14PM PAGE: 10 COST RECOVERY OR PASS THRU 06-0435-00-00 CREDIT CARD PROCESSING FEE 1,275.94 4,119.83 3,200.00 ( 919.83)128.7 06-0435-02-00 LOST ITEMS REFUNDS .00 .00 300.00 300.00 .0 06-0435-03-00 OPEN ACCESS 776.97 2,102.84 2,200.00 97.16 95.6 TOTAL COST RECOVERY OR PASS THRU 2,052.91 6,222.67 5,700.00 ( 522.67)109.2 TECHNOLOGY 06-0440-01-00 COMPUTER MAINTENANCE & REPAIR .00 .00 3,000.00 3,000.00 .0 06-0440-02-00 COMPUTER EQUIPMENT (SMALL).00 115.07 3,500.00 3,384.93 3.3 TOTAL TECHNOLOGY .00 115.07 6,500.00 6,384.93 1.8 GUEST RESOURCES 06-0450-00-00 BOOKS 105,554.97 194,246.39 158,500.00 ( 35,746.39)122.6 06-0450-01-00 PRINT VENDOR PROCESSING 4,039.45 9,931.25 9,000.00 ( 931.25)110.4 06-0450-02-00 BOOKS -DIGITAL 38,749.82 75,253.48 85,000.00 9,746.52 88.5 06-0450-03-00 MAGAZINES & NEWSPAPERS .00 .00 3,750.00 3,750.00 .0 06-0450-03-01 MAGAZINES - DIGITAL 2,100.00 14,111.00 16,750.00 2,639.00 84.2 06-0450-04-00 MEDIA 55,375.13 106,364.52 81,000.00 ( 25,364.52)131.3 06-0450-05-00 MEDIA - DIGITAL 10,234.58 37,803.83 67,000.00 29,196.17 56.4 06-0450-06-00 DATABASES .00 5,647.00 16,800.00 11,153.00 33.6 06-0450-07-00 HOTSPOT 699.29 2,166.03 3,200.00 1,033.97 67.7 06-0450-08-00 FAMILY PLACE SPACE 2,588.17 6,195.26 10,000.00 3,804.74 62.0 TOTAL GUEST RESOURCES 219,341.41 451,718.76 451,000.00 ( 718.76)100.2 GUEST CLASSES & EVENTS 06-0455-00-00 CLASSES & EVENTS 11,991.84 28,222.54 25,000.00 ( 3,222.54)112.9 TOTAL GUEST CLASSES & EVENTS 11,991.84 28,222.54 25,000.00 ( 3,222.54)112.9 PERSONNEL 06-0461-10-00 SALARIES - FULL TIME 129,873.76 529,341.17 539,500.00 10,158.83 98.1 06-0461-10-01 SALARIES - PERSONNEL SERVICES 14,552.35 42,930.54 .00 ( 42,930.54).0 06-0461-11-00 OVERTIME 1,017.11 1,947.05 5,000.00 3,052.95 38.9 06-0461-15-00 SALARIES - PART TIME 19,506.32 72,360.38 216,500.00 144,139.62 33.4 06-0461-15-01 SALARIES - PERSONNEL SERVICES 10,352.60 25,497.54 .00 ( 25,497.54).0 06-0461-21-00 FICA 11,381.27 45,124.79 58,500.00 13,375.21 77.1 06-0461-22-00 PERSI 15,508.02 59,458.96 64,700.00 5,241.04 91.9 06-0461-23-00 HRA BUY-DOWN .00 4,612.67 5,500.00 887.33 83.9 06-0461-23-01 HRA/COBRA ADMIN FEES 388.80 1,167.20 900.00 ( 267.20)129.7 06-0461-24-00 WORKERS' COMPENSATION .00 705.58 1,792.00 1,086.42 39.4 06-0461-25-00 INSURANCE 23,095.04 77,743.36 103,500.00 25,756.64 75.1 06-0461-26-00 HSA CONTRIBUTION 300.00 1,200.00 1,200.00 .00 100.0 06-0461-27-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:14PM PAGE: 11 06-0461-28-00 UNEMPLOYMENT BENEFITS .00 .00 10,000.00 10,000.00 .0 06-0461-29-00 EMPLOYMENT TESTING .00 .00 1,000.00 1,000.00 .0 TOTAL PERSONNEL 225,975.27 862,089.24 1,013,092.00 151,002.76 85.1 RESTRICTED FUNDS 06-0462-01-00 GRANTS .00 15,099.38 .00 ( 15,099.38).0 TOTAL RESTRICTED FUNDS .00 15,099.38 .00 ( 15,099.38).0 STAFF DEVELOPMENT 06-0463-00-00 TRAVEL & PER DIEM 4,000.00 4,392.96 1,000.00 ( 3,392.96)439.3 06-0463-01-00 MILEAGE REIMBURSEMENT 79.16 213.79 1,100.00 886.21 19.4 06-0463-02-00 TRAINING .00 900.00 2,100.00 1,200.00 42.9 06-0463-03-00 CONTINUING EDUCATION 365.00 9,514.00 12,500.00 2,986.00 76.1 06-0463-08-00 VIRTUAL TRAINING .00 239.00 1,500.00 1,261.00 15.9 TOTAL STAFF DEVELOPMENT 4,444.16 15,259.75 18,200.00 2,940.25 83.8 FACILITY (BLDGS & GROUNDS) 06-0464-00-00 BUILDING .00 .00 1,500.00 1,500.00 .0 06-0464-01-00 BUILDING SUPPLIES .00 800.59 1,500.00 699.41 53.4 06-0464-02-00 UTILITIES 8,475.09 27,048.46 28,300.00 1,251.54 95.6 06-0464-03-00 TELEPHONE 331.52 745.42 1,000.00 254.58 74.5 06-0464-04-00 SECURITY SYSTEM .00 .00 3,000.00 3,000.00 .0 06-0464-06-00 GROUNDS .00 .00 1,000.00 1,000.00 .0 06-0464-07-00 FLOOR MATS 573.86 2,076.58 1,850.00 ( 226.58)112.3 TOTAL FACILITY (BLDGS & GROUNDS)9,380.47 30,671.05 38,150.00 7,478.95 80.4 CAPITAL IMPROVEMENT 06-0466-01-00 CAPITAL FURNISHING .00 1,198.25 .00 ( 1,198.25).0 TOTAL CAPITAL IMPROVEMENT .00 1,198.25 .00 ( 1,198.25).0 TOTAL FUND EXPENDITURES 520,084.25 1,549,014.95 1,682,842.00 133,827.05 92.1 NET REVENUE OVER EXPENDITURES ( 10,990.20)( 72,746.29).00 72,746.29 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 MUSEUM FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:14PM PAGE: 12 LIABILITIES AND EQUITY LIABILITIES 07-0202-00-00 VOUCHERS PAYABLE 798.59 07-0217-03-00 FICA 246.54 07-0217-04-00 PERSI RETIREMENT 240.94 07-0217-07-00 INSURANCE 678.11 07-0217-09-00 WORKERS' COMPENSATION 1,603.16 TOTAL LIABILITIES 3,567.34 FUND EQUITY 07-0271-00-00 MUSEUM FUND BALANCE 18,460.31 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 22,027.65) BALANCE - CURRENT DATE ( 22,027.65) TOTAL FUND EQUITY ( 3,567.34) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:14PM PAGE: 13 REVENUE 07-0316-12-00 FUNDING FROM GENERAL FUND 40,767.33 84,158.17 180,610.00 96,451.83 46.6 07-0333-01-00 GRANTS, STATE .00 .00 16,000.00 16,000.00 .0 07-0376-00-00 CONTRIBUTIONS AND DONATIONS 122.00 667.00 500.00 ( 167.00)133.4 07-0379-00-00 MISCELLANEOUS REVENUE .00 .00 50.00 50.00 .0 07-0379-02-00 ARCADIA BOOKS SALES/ROYALTIES .00 79.93 200.00 120.07 40.0 07-0379-03-00 SALES TAX REVENUE .00 .00 5.00 5.00 .0 07-0380-00-00 GIFT SHOP REVENUE .00 35.99 .00 ( 35.99).0 TOTAL FUND REVENUE 40,889.33 84,941.09 197,365.00 112,423.91 43.0 EXPENDITURES PERSONNEL 07-0420-10-00 SALARIES - FULL TIME 18,247.86 66,972.66 103,500.00 36,527.34 64.7 07-0420-15-00 SALARIES - PART TIME 2,740.31 2,740.31 20,000.00 17,259.69 13.7 07-0420-15-01 SALARIES - PERSONNEL SERVICES 10,065.68 10,065.68 .00 ( 10,065.68).0 07-0420-21-00 FICA 1,605.59 5,333.01 9,600.00 4,266.99 55.6 07-0420-22-00 PERSI 1,974.73 7,238.92 12,450.00 5,211.08 58.1 07-0420-24-00 WORKERS' COMPENSATION .00 3.44 .00 ( 3.44).0 07-0420-25-00 INSURANCE 237.00 4,918.22 6,500.00 1,581.78 75.7 07-0420-27-00 HRA BUY DOWN .00 .00 1,540.00 1,540.00 .0 TOTAL PERSONNEL 34,871.17 97,272.24 153,590.00 56,317.76 63.3 EDUCATION 07-0461-02-00 ASSOCIATION MEMBERSHIP 100.00 433.00 325.00 ( 108.00)133.2 07-0461-03-00 CONFERENCES & SEMINARS 442.00 442.00 500.00 58.00 88.4 07-0461-04-00 TRAVEL & PER DIEM 1,619.19 1,619.19 750.00 ( 869.19)215.9 TOTAL EDUCATION 2,161.19 2,494.19 1,575.00 ( 919.19)158.4 ADMINISTRATION 07-0462-30-00 CONSERVATION AND PRESERVATION .00 .00 200.00 200.00 .0 07-0462-31-00 OFFICE SUPPLIES 293.29 618.27 750.00 131.73 82.4 07-0462-32-00 ARCHIVAL SUPPLIES 1,280.44 1,477.06 1,000.00 ( 477.06)147.7 07-0462-33-00 PUBLICITY-PRINTING 89.83 114.82 350.00 235.18 32.8 07-0462-34-00 RESEARCH MATERIAL 347.00 616.00 500.00 ( 116.00)123.2 07-0462-35-00 UNIFORMS .00 150.40 300.00 149.60 50.1 07-0462-68-00 MUSEUM AND EDUCATION PROGRAMS 200.03 561.23 1,500.00 938.77 37.4 07-0462-69-00 MISCELLANEOUS 2,444.97 2,607.28 3,000.00 392.72 86.9 07-0462-73-00 EAGLE BOOK-ARCADIA PUBLISHING .00 .00 300.00 300.00 .0 TOTAL ADMINISTRATION 4,655.56 6,145.06 7,900.00 1,754.94 77.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 MUSEUM FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:14PM PAGE: 14 EXHIBITS 07-0463-01-00 DISPLAY SUPPLIES .00 140.00 300.00 160.00 46.7 07-0463-02-00 EXHIBIT ITEMS .00 160.83 100.00 ( 60.83)160.8 07-0463-03-00 EXHIBIT CONSTRUCTION .00 680.50 1,000.00 319.50 68.1 07-0463-04-00 ANNUAL EXHIBIT .00 75.92 10,000.00 9,924.08 .8 TOTAL EXHIBITS .00 1,057.25 11,400.00 10,342.75 9.3 HISTORIC PRESERVATION COMM 07-0464-30-00 HISTORIC PRESERVATION ADMIN .00 .00 700.00 700.00 .0 07-0464-31-00 HISTORIC PRESERVATION PROGRAMS .00 .00 200.00 200.00 .0 07-0464-40-00 HPC STATE GRANTS .00 .00 22,000.00 22,000.00 .0 TOTAL HISTORIC PRESERVATION COMM .00 .00 22,900.00 22,900.00 .0 TOTAL FUND EXPENDITURES 41,687.92 106,968.74 197,365.00 90,396.26 54.2 NET REVENUE OVER EXPENDITURES ( 798.59)( 22,027.65).00 22,027.65 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 PARK IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:14PM PAGE: 15 ASSETS 08-0101-00-00 CASH 394,496.73 08-0151-25-00 INVESTMENTS 967,853.13 TOTAL ASSETS 1,362,349.86 LIABILITIES AND EQUITY FUND EQUITY 08-0271-00-00 PARK FUND/FUND BALANCE 404,624.82 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 957,725.04 BALANCE - CURRENT DATE 957,725.04 TOTAL FUND EQUITY 1,362,349.86 TOTAL LIABILITIES AND EQUITY 1,362,349.86 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 PARK IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:14PM PAGE: 16 REVENUE 08-0322-19-00 PARKS DEVELOPMENT IMPACT FEES 264,160.00 1,015,948.64 416,000.00 ( 599,948.64)244.2 08-0322-20-00 PARKS DEV IMPACT FEES-VALNOVA .00 .00 104,000.00 104,000.00 .0 08-0371-25-00 BANK INTEREST 6,288.74 16,129.87 2,000.00 ( 14,129.87)806.5 08-0399-00-00 CARRY OVER .00 .00 343,900.00 343,900.00 .0 TOTAL FUND REVENUE 270,448.74 1,032,078.51 865,900.00 ( 166,178.51)119.2 EXPENDITURES CAPITAL IMPROVEMENTS 08-0438-37-00 CAPITAL IMPROVEMENTS .00 74,353.47 761,900.00 687,546.53 9.8 08-0438-99-00 VALNOVA IMPACT FEE PAYMENTS .00 .00 104,000.00 104,000.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 74,353.47 865,900.00 791,546.53 8.6 TOTAL FUND EXPENDITURES .00 74,353.47 865,900.00 791,546.53 8.6 NET REVENUE OVER EXPENDITURES 270,448.74 957,725.04 .00 ( 957,725.04).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 RECREATION - SPECIAL EVENTS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:14PM PAGE: 17 ASSETS 09-0101-00-00 CASH 21,321.72 TOTAL ASSETS 21,321.72 LIABILITIES AND EQUITY LIABILITIES 09-0202-00-00 VOUCHERS PAYABLE 4,482.39 09-0217-03-00 FICA 243.03 09-0217-04-00 PERSI RETIREMENT 337.51 09-0217-07-00 INSURANCE 16,939.25 09-0217-09-00 WORKERS' COMPENSATION 16,623.60 09-0217-10-00 HSA CONTRIBUTION 3,319.35 TOTAL LIABILITIES 41,945.13 FUND EQUITY 09-0271-00-00 FUND BALANCE ( 34,171.38) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 13,547.97 BALANCE - CURRENT DATE 13,547.97 TOTAL FUND EQUITY ( 20,623.41) TOTAL LIABILITIES AND EQUITY 21,321.72 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:14PM PAGE: 18 REVENUE 09-0301-00-00 FUNDING FROM GENERAL FUND .00 29,465.04 38,075.00 8,609.96 77.4 09-0347-06-00 COUNTRY CHRISTMAS .00 767.92 2,750.00 1,982.08 27.9 09-0347-08-00 SATURDAY MARKET 13,924.30 34,922.63 22,500.00 ( 12,422.63)155.2 09-0347-10-00 GAZEBO CONCERT SERIES 287.75 383.65 825.00 441.35 46.5 09-0347-11-00 HARVEST FEST MARKET 3,654.33 3,813.64 2,750.00 ( 1,063.64)138.7 09-0376-12-00 MISCELLANEOUS REVENUE .00 4,504.38 3,000.00 ( 1,504.38)150.2 09-0376-13-00 SPONSORSHIPS 5,500.00 21,610.00 25,000.00 3,390.00 86.4 09-0376-15-00 EVENT APPLICATION FEES 100.00 2,200.00 2,500.00 300.00 88.0 09-0376-17-00 SECURITY DEPOSIT .00 .00 1,200.00 1,200.00 .0 TOTAL FUND REVENUE 23,466.38 97,667.26 98,600.00 932.74 99.1 EXPENDITURES ADMINISTRATION 09-0463-11-00 OFFICE SUPPLIES .00 .00 800.00 800.00 .0 09-0463-12-00 PROMOTIONS 3,179.00 13,182.64 14,000.00 817.36 94.2 09-0463-19-00 TRAINING AND EDUCATION .00 375.00 1,200.00 825.00 31.3 09-0463-20-00 TRAVEL & PER DIEM .00 1,099.54 4,000.00 2,900.46 27.5 09-0463-21-00 PROFESSIONAL DUES .00 2,100.50 3,000.00 899.50 70.0 09-0463-22-00 UNIFORMS 305.80 920.75 1,500.00 579.25 61.4 09-0463-23-00 GAS AND OIL .00 .00 200.00 200.00 .0 09-0463-25-00 SECURITY DEPOSIT REFUND .00 .00 1,200.00 1,200.00 .0 09-0463-26-00 MEMBERSHIPS 65.96 340.89 700.00 359.11 48.7 TOTAL ADMINISTRATION 3,550.76 18,019.32 26,600.00 8,580.68 67.7 ACTIVITIES 09-0467-02-00 EAGLE SATURDAY MARKET 4,159.90 9,841.75 15,000.00 5,158.25 65.6 09-0467-03-00 COUNTRY CHRISTMAS .00 17,016.56 18,000.00 983.44 94.5 09-0467-04-00 GAZEBO CONCERT SERIES 4,500.00 9,450.00 10,000.00 550.00 94.5 09-0467-05-00 GENERAL EVENTS 4,338.17 12,040.01 10,000.00 ( 2,040.01)120.4 09-0467-06-00 EAGLE HARVEST FEST .00 3,473.96 6,000.00 2,526.04 57.9 09-0467-07-00 HALLOWEEN 3,049.99 11,288.76 10,000.00 ( 1,288.76)112.9 09-0467-19-00 EVENT EQUIPMENT PURCHASES 2,543.14 2,988.93 3,000.00 11.07 99.6 TOTAL ACTIVITIES 18,591.20 66,099.97 72,000.00 5,900.03 91.8 TOTAL FUND EXPENDITURES 22,141.96 84,119.29 98,600.00 14,480.71 85.3 NET REVENUE OVER EXPENDITURES 1,324.42 13,547.97 .00 ( 13,547.97).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 EXECUTIVE DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:15PM PAGE: 19 LIABILITIES AND EQUITY LIABILITIES 11-0202-00-00 VOUCHERS PAYABLE 230.00 11-0216-00-00 ACCRUED PAYROLL 1,750.00 11-0217-03-00 FICA 452.83 11-0217-04-00 PERSI RETIREMENT 675.73 11-0217-07-00 INSURANCE 50.76 11-0217-09-00 WORKERS' COMPENSATION 11,801.13 11-0217-10-00 HSA CONTRIBUTION ( 224.00) TOTAL LIABILITIES 14,736.45 FUND EQUITY 11-0271-00-00 FUND BALANCE ( 13,847.12) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 889.33) BALANCE - CURRENT DATE ( 889.33) TOTAL FUND EQUITY ( 14,736.45) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:15PM PAGE: 20 REVENUE 11-0301-00-00 FUNDING FROM GENERAL FUND 84,649.69 418,994.73 662,430.00 243,435.27 63.3 TOTAL FUND REVENUE 84,649.69 418,994.73 662,430.00 243,435.27 63.3 EXPENDITURES ADMINISTRATION 11-0413-04-00 UNIFORMS .00 744.80 500.00 ( 244.80)149.0 11-0413-05-00 OFFICE SUPPLIES 43.65 276.60 750.00 473.40 36.9 11-0413-06-00 DUPLICATION/PUBLISHING/PRINT .00 182.65 .00 ( 182.65).0 11-0413-12-00 PERSONNEL TRAINING 60.00 1,229.00 5,000.00 3,771.00 24.6 11-0413-13-00 TRAVEL & PER DIEM 2,248.99 2,317.89 5,000.00 2,682.11 46.4 11-0413-14-00 PROFESSIONAL DUES 688.00 1,947.00 3,500.00 1,553.00 55.6 11-0413-20-00 MARKETING .00 464.56 20,000.00 19,535.44 2.3 TOTAL ADMINISTRATION 3,040.64 7,162.50 34,750.00 27,587.50 20.6 PERSONNEL 11-0415-10-00 SALARIES - FULL TIME 64,079.37 309,244.86 345,800.00 36,555.14 89.4 11-0415-11-00 OVERTIME .00 138.65 1,000.00 861.35 13.9 11-0415-21-00 FICA 4,765.17 23,257.82 26,500.00 3,242.18 87.8 11-0415-22-00 PERSI 7,581.24 35,250.97 41,400.00 6,149.03 85.2 11-0415-24-00 WORKERS' COMPENSATION .00 190.61 .00 ( 190.61).0 11-0415-25-00 INSURANCE 6,898.26 35,285.11 44,500.00 9,214.89 79.3 11-0415-26-00 HSA CONTRIBUTION .00 .00 1,200.00 1,200.00 .0 11-0415-27-00 PTO CASH OUT .00 4,562.72 5,000.00 437.28 91.3 11-0415-28-00 HRA BUY-DOWN 247.19 1,575.00 3,080.00 1,505.00 51.1 TOTAL PERSONNEL 83,571.23 409,505.74 468,480.00 58,974.26 87.4 STATE OF THE CITY 11-0417-01-00 STATE OF THE CITY 88.43 88.43 4,200.00 4,111.57 2.1 TOTAL STATE OF THE CITY 88.43 88.43 4,200.00 4,111.57 2.1 COMPREHENSIVE PLAN REWRITE 11-0418-00-00 COMP PLAN REWRITE .00 .00 150,000.00 150,000.00 .0 TOTAL COMPREHENSIVE PLAN REWRITE .00 .00 150,000.00 150,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 EXECUTIVE DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:15PM PAGE: 21 COMMUNITY & STAFF RELATIONS 11-0422-01-00 COMMUNITY/STAFF RELATIONS 381.68 2,888.73 5,000.00 2,111.27 57.8 11-0422-02-00 STAFF RELATIONS 238.66 238.66 .00 ( 238.66).0 TOTAL COMMUNITY & STAFF RELATIONS 620.34 3,127.39 5,000.00 1,872.61 62.6 TOTAL FUND EXPENDITURES 87,320.64 419,884.06 662,430.00 242,545.94 63.4 NET REVENUE OVER EXPENDITURES ( 2,670.95)( 889.33).00 889.33 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 CITY CLERK/TREAS DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:15PM PAGE: 22 LIABILITIES AND EQUITY LIABILITIES 12-0202-00-00 VOUCHERS PAYABLE 2,850.50 12-0216-00-00 ACCRUED PAYROLL 7,001.54 12-0217-03-00 FICA 1,420.86 12-0217-04-00 PERSI RETIREMENT 2,212.17 12-0217-07-00 INSURANCE 6,751.82 12-0217-09-00 WORKERS' COMPENSATION 8,143.91 TOTAL LIABILITIES 28,380.80 FUND EQUITY 12-0271-00-00 FUND BALANCE ( 19,580.76) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 8,800.04) BALANCE - CURRENT DATE ( 8,800.04) TOTAL FUND EQUITY ( 28,380.80) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 CITY CLERK/TREAS DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:15PM PAGE: 23 REVENUE 12-0301-00-00 FUNDING FROM GENERAL FUND 155,483.99 654,004.69 810,700.00 156,695.31 80.7 TOTAL FUND REVENUE 155,483.99 654,004.69 810,700.00 156,695.31 80.7 EXPENDITURES ADMINISTRATION 12-0413-05-00 OFFICE SUPPLIES 916.49 1,106.49 7,500.00 6,393.51 14.8 12-0413-06-00 DUPLICATION/PUBLISHING/PRINT .00 .00 100.00 100.00 .0 12-0413-12-00 PERSONNEL TRAINING & RESOURCES 1,745.00 3,316.11 12,500.00 9,183.89 26.5 12-0413-13-00 TRAVEL & PER DIEM 565.90 2,750.72 7,500.00 4,749.28 36.7 12-0413-14-00 PROFESSIONAL DUES 445.00 1,824.00 5,500.00 3,676.00 33.2 12-0413-30-00 MISCELLANEOUS .00 173.06 700.00 526.94 24.7 TOTAL ADMINISTRATION 3,672.39 9,170.38 33,800.00 24,629.62 27.1 PERSONNEL 12-0415-10-00 SALARIES - FULL TIME 109,114.44 476,691.25 557,800.00 81,108.75 85.5 12-0415-10-01 SALARIES - PERSONNEL SERVICES 4,438.59 4,438.59 .00 ( 4,438.59).0 12-0415-11-00 OVERTIME 114.38 322.80 4,000.00 3,677.20 8.1 12-0415-21-00 FICA 8,507.90 35,975.00 42,700.00 6,725.00 84.3 12-0415-22-00 PERSI 13,444.09 54,867.12 66,800.00 11,932.88 82.1 12-0415-23-00 HRA BUY- DOWN 1,425.94 3,577.89 7,700.00 4,122.11 46.5 12-0415-23-02 HSA CONTRIBUTION 300.00 1,200.00 2,400.00 1,200.00 50.0 12-0415-24-00 WORKERS' COMPENSATION .00 25.09 .00 ( 25.09).0 12-0415-25-00 INSURANCE 17,377.01 67,816.61 85,500.00 17,683.39 79.3 12-0415-26-00 PTO CASH OUT 5,995.00 8,720.00 10,000.00 1,280.00 87.2 TOTAL PERSONNEL 160,717.35 653,634.35 776,900.00 123,265.65 84.1 TOTAL FUND EXPENDITURES 164,389.74 662,804.73 810,700.00 147,895.27 81.8 NET REVENUE OVER EXPENDITURES ( 8,905.75)( 8,800.04).00 8,800.04 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 BUILDING DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:15PM PAGE: 24 ASSETS 13-0103-00-00 PETTY CASH 100.00 TOTAL ASSETS 100.00 LIABILITIES AND EQUITY LIABILITIES 13-0202-00-00 VOUCHERS PAYABLE 43,481.46 13-0216-00-00 ACCRUED PAYROLL 5,067.00 13-0217-03-00 FICA 1,396.51 13-0217-04-00 PERSI RETIREMENT 2,022.42 13-0217-07-00 INSURANCE 14,482.05 13-0217-09-00 WORKERS' COMPENSATION 59,433.90 13-0217-10-00 HSA CONTRIBUTION ( 1,900.00) TOTAL LIABILITIES 123,983.34 FUND EQUITY 13-0271-00-00 FUND BALANCE ( 44,300.91) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 79,582.43) BALANCE - CURRENT DATE ( 79,582.43) TOTAL FUND EQUITY ( 123,883.34) TOTAL LIABILITIES AND EQUITY 100.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:15PM PAGE: 25 REVENUE 13-0301-00-00 FUNDING FROM GENERAL FUND 231,568.58 886,683.73 1,068,860.00 182,176.27 83.0 TOTAL FUND REVENUE 231,568.58 886,683.73 1,068,860.00 182,176.27 83.0 EXPENDITURES ADMINISTRATION 13-0413-05-00 OFFICE SUPPLIES 16.24 5,789.99 6,500.00 710.01 89.1 13-0413-08-00 LEGAL ADS & PUBLICATIONS .00 .00 400.00 400.00 .0 13-0413-12-00 TRAINING & CERTIFICATION RENEW 409.00 2,654.00 4,500.00 1,846.00 59.0 13-0413-13-00 TRAVEL & PER DIEM .00 61.00 2,000.00 1,939.00 3.1 13-0413-14-00 PROFESSIONAL DUES 170.00 625.00 700.00 75.00 89.3 13-0413-25-00 MISCELLANEOUS .00 ( 790.00)400.00 1,190.00 (197.5) 13-0413-28-00 RESOURCE MATERIALS 64.95 64.95 2,000.00 1,935.05 3.3 13-0413-29-04 PLUMBING PERMIT REFUND ( 66.50).00 .00 .00 .0 13-0413-30-00 UNIFORMS .00 1,640.25 2,000.00 359.75 82.0 TOTAL ADMINISTRATION 593.69 10,045.19 18,500.00 8,454.81 54.3 PERSONNEL 13-0415-10-00 SALARIES - FULL TIME 79,978.23 341,497.44 448,100.00 106,602.56 76.2 13-0415-10-01 SALARIES - PERSONNEL SERVICES 5,932.96 14,052.31 .00 ( 14,052.31).0 13-0415-11-00 OVERTIME 601.89 3,740.52 4,000.00 259.48 93.5 13-0415-21-00 FICA 5,891.17 25,431.55 34,500.00 9,068.45 73.7 13-0415-22-00 PERSI 9,534.36 39,035.23 53,600.00 14,564.77 72.8 13-0415-23-00 HRA BUY-DOWN 71.61 71.61 6,160.00 6,088.39 1.2 13-0415-24-00 WORKERS' COMPENSATION .00 449.47 .00 ( 449.47).0 13-0415-25-00 INSURANCE 16,326.52 63,697.09 92,300.00 28,602.91 69.0 13-0415-26-00 HSA CONTRIBUTION .00 400.00 1,200.00 800.00 33.3 13-0415-28-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 TOTAL PERSONNEL 118,336.74 488,375.22 644,860.00 156,484.78 75.7 CONTRACTS & AGREEMENTS 13-0416-09-00 PLUMBING INSPECTOR 46,520.83 124,631.97 110,000.00 ( 14,631.97)113.3 13-0416-10-00 ELECTRICAL INSPECTION ( 66.50).00 .00 .00 .0 13-0416-11-00 MECHANICAL INSPECTOR 56,081.09 162,333.57 110,000.00 ( 52,333.57)147.6 13-0416-13-00 BLDG INSPECTOR .00 15,547.25 55,000.00 39,452.75 28.3 13-0416-14-00 PLAN REVIEW - CONTRACT .00 .00 4,000.00 4,000.00 .0 13-0416-16-00 STRUCTURAL PLAN REVIEW .00 3,500.00 6,000.00 2,500.00 58.3 13-0416-25-00 ELECTRICAL INSPECTOR 58,866.56 160,688.63 120,000.00 ( 40,688.63)133.9 TOTAL CONTRACTS & AGREEMENTS 161,401.98 466,701.42 405,000.00 ( 61,701.42)115.2 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 BUILDING DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:15PM PAGE: 26 VEHICLE OPERATIONS 13-0417-02-00 GAS AND OIL 476.54 1,144.33 500.00 ( 644.33)228.9 TOTAL VEHICLE OPERATIONS 476.54 1,144.33 500.00 ( 644.33)228.9 TOTAL FUND EXPENDITURES 280,808.95 966,266.16 1,068,860.00 102,593.84 90.4 NET REVENUE OVER EXPENDITURES ( 49,240.37)( 79,582.43).00 79,582.43 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 P&Z DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 27 LIABILITIES AND EQUITY LIABILITIES 14-0202-00-00 VOUCHERS PAYABLE 4,952.68 14-0216-00-00 ACCRUED PAYROLL 9,808.33 14-0217-03-00 FICA 3,391.86 14-0217-04-00 PERSI RETIREMENT 5,215.16 14-0217-07-00 INSURANCE ( 32,899.45) 14-0217-08-00 GARNISHMENTS 203.34 14-0217-09-00 WORKERS' COMPENSATION 83,714.36 TOTAL LIABILITIES 74,386.28 FUND EQUITY 14-0271-00-00 FUND BALANCE ( 62,648.05) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 11,738.23) BALANCE - CURRENT DATE ( 11,738.23) TOTAL FUND EQUITY ( 74,386.28) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 28 REVENUE 14-0301-00-00 FUNDING FROM GENERAL FUND 223,320.45 959,673.91 1,288,000.00 328,326.09 74.5 TOTAL FUND REVENUE 223,320.45 959,673.91 1,288,000.00 328,326.09 74.5 EXPENDITURES ADMINISTRATION 14-0413-05-00 OFFICE SUPPLIES 92.50 419.73 1,300.00 880.27 32.3 14-0413-06-00 DUPLICATION/PUBLISHING/PRNTG .00 .00 1,000.00 1,000.00 .0 14-0413-08-00 LEGAL ADS & PUBLICATIONS 1,089.20 3,145.94 6,000.00 2,854.06 52.4 14-0413-12-00 PERSONNEL TRAINING ( 220.00)1,005.00 2,000.00 995.00 50.3 14-0413-13-00 TRAVEL & PER DIEM 429.09 2,143.03 500.00 ( 1,643.03)428.6 14-0413-14-00 PROFESSIONAL DUES 1,339.00 1,859.00 3,300.00 1,441.00 56.3 14-0413-25-00 MISCELLANEOUS .00 359.80 500.00 140.20 72.0 14-0413-26-00 REIMBURSE-ANNEX/ZONING/DR FEES 282.50 282.50 2,000.00 1,717.50 14.1 14-0413-28-00 RESOURCE MATERIALS .00 5.98 500.00 494.02 1.2 14-0413-30-01 ENVIRONMENTAL REVIEW SERVICES .00 .00 5,000.00 5,000.00 .0 14-0413-37-00 ARBORICULTURE .00 .00 500.00 500.00 .0 TOTAL ADMINISTRATION 3,012.29 9,220.98 22,600.00 13,379.02 40.8 PERSONNEL 14-0415-10-00 SALARIES - FULL TIME 149,533.98 672,805.01 890,500.00 217,694.99 75.6 14-0415-10-01 SALARIES - PERSONNEL SERVICES 30,651.91 52,778.31 .00 ( 52,778.31).0 14-0415-11-00 OVERTIME 666.08 3,512.49 13,000.00 9,487.51 27.0 14-0415-21-00 FICA 10,950.93 49,675.25 69,800.00 20,124.75 71.2 14-0415-22-00 PERSI 17,774.35 76,406.50 108,900.00 32,493.50 70.2 14-0415-24-00 WORKERS' COMPENSATION .00 377.53 .00 ( 377.53).0 14-0415-25-00 INSURANCE 25,409.88 105,494.34 143,500.00 38,005.66 73.5 14-0415-26-00 HSA CONTRIBUTION .00 .00 1,200.00 1,200.00 .0 14-0415-29-00 PTO CASH OUT .00 .00 10,000.00 10,000.00 .0 14-0415-30-00 HRA BUY- DOWN .00 953.64 7,700.00 6,746.36 12.4 TOTAL PERSONNEL 234,987.13 962,003.07 1,244,600.00 282,596.93 77.3 CONTRACTS & AGREEMENTS 14-0416-03-00 PROFESSIONAL SERVICE CONTRACTS .00 .00 10,000.00 10,000.00 .0 TOTAL CONTRACTS & AGREEMENTS .00 .00 10,000.00 10,000.00 .0 PUBLIC RELATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 P&Z DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 29 14-0422-01-00 PUBLIC RELATIONS .00 .00 200.00 200.00 .0 TOTAL PUBLIC RELATIONS .00 .00 200.00 200.00 .0 CAPITAL OUTLAY 14-0465-03-00 OFFICE EQUIPMENT .00 188.09 600.00 411.91 31.4 TOTAL CAPITAL OUTLAY .00 188.09 600.00 411.91 31.4 COMMUNITY PLANNING PROJECTS 14-0468-11-00 PROJECTS .00 .00 10,000.00 10,000.00 .0 TOTAL COMMUNITY PLANNING PROJECTS .00 .00 10,000.00 10,000.00 .0 TOTAL FUND EXPENDITURES 237,999.42 971,412.14 1,288,000.00 316,587.86 75.4 NET REVENUE OVER EXPENDITURES ( 14,678.97)( 11,738.23).00 11,738.23 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 RECREATION - ADM & ACTIVITIES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 30 ASSETS 17-0103-00-00 PETTY CASH 100.00 TOTAL ASSETS 100.00 LIABILITIES AND EQUITY LIABILITIES 17-0202-00-00 VOUCHERS PAYABLE 8,886.49 17-0217-03-00 FICA 1,637.19 17-0217-04-00 PERSI RETIREMENT 1,079.92 17-0217-07-00 INSURANCE ( 15,443.71) 17-0217-09-00 WORKERS' COMPENSATION 52,333.44 17-0217-10-00 HSA CONTRIBUTION ( 4,225.93) TOTAL LIABILITIES 44,267.40 FUND EQUITY 17-0271-00-00 FUND BALANCE ( 36,110.81) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 8,056.59) BALANCE - CURRENT DATE ( 8,056.59) TOTAL FUND EQUITY ( 44,167.40) TOTAL LIABILITIES AND EQUITY 100.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 RECREATION - ADM & ACTIVITIES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 31 REVENUE 17-0301-00-00 FUNDING FROM GENERAL FUND 206,010.30 570,036.81 807,120.00 237,083.19 70.6 17-0302-00-00 REGIST- SPORTS, CAMPS, CLASSES 60,914.24 273,346.43 112,000.00 ( 161,346.43)244.1 17-0302-01-00 SPONSORSHIPS .00 6,750.00 10,000.00 3,250.00 67.5 17-0302-02-00 DONATIONS .00 ( 1,871.63).00 1,871.63 .0 17-0302-03-00 PARK RESERVATION FEES 14,975.59 54,209.04 20,000.00 ( 34,209.04)271.1 17-0302-04-00 SENIOR CENTER FEES 487.50 5,627.50 .00 ( 5,627.50).0 17-0304-00-00 MISC SALES, EAGLE ARTS 441.00 558.34 .00 ( 558.34).0 17-0399-00-00 CARRY OVER .00 .00 1,000.00 1,000.00 .0 TOTAL FUND REVENUE 282,828.63 908,656.49 950,120.00 41,463.51 95.6 EXPENDITURES CONTRACTS 17-0416-00-00 CONTRACT-PERMITS,CAMPS/CLASSES 147.00 5,991.25 20,000.00 14,008.75 30.0 17-0416-01-00 CONTRACT-PERMITS, TEAM SPORTS 32,265.02 74,626.80 10,000.00 ( 64,626.80)746.3 TOTAL CONTRACTS 32,412.02 80,618.05 30,000.00 ( 50,618.05)268.7 PERSONNEL 17-0420-10-00 SALARIES - FULL TIME 116,250.34 454,575.88 495,000.00 40,424.12 91.8 17-0420-10-01 SALARIES - PERSONNEL SERVICES 40,865.64 67,443.41 20,000.00 ( 47,443.41)337.2 17-0420-11-00 SALARIES - SEASONAL .00 931.35 .00 ( 931.35).0 17-0420-18-00 OVERTIME 1,391.21 1,900.28 4,000.00 2,099.72 47.5 17-0420-21-00 FICA 8,191.07 33,937.36 38,300.00 4,362.64 88.6 17-0420-22-00 PERSI 12,829.78 51,211.23 59,700.00 8,488.77 85.8 17-0420-23-00 HRA BUY-DOWN .00 .00 4,620.00 4,620.00 .0 17-0420-24-00 WORKERS' COMPENSATION .00 756.30 .00 ( 756.30).0 17-0420-25-00 INSURANCE 14,880.55 64,095.88 86,000.00 21,904.12 74.5 17-0420-26-00 HSA CONTRIBUTION 900.00 3,300.00 2,400.00 ( 900.00)137.5 17-0420-27-00 PTO CASH OUT .00 3,540.00 5,000.00 1,460.00 70.8 TOTAL PERSONNEL 195,308.59 681,691.69 715,020.00 33,328.31 95.3 RESTRICTED 17-0421-00-00 SCHOLARSHIP FUNDS .00 .00 1,000.00 1,000.00 .0 TOTAL RESTRICTED .00 .00 1,000.00 1,000.00 .0 ADMINISTRATION 17-0422-00-00 TRAINING-PROFESSIONAL DEV .00 .00 2,000.00 2,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 RECREATION - ADM & ACTIVITIES YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 32 17-0422-01-00 OFFICE SUPPLIES 30.25 132.52 2,000.00 1,867.48 6.6 17-0422-02-00 ADVERTISING/MKTNG CAMP/CLASS .00 .00 1,500.00 1,500.00 .0 17-0422-02-01 ADVERTISING/MKTNG TEAM SPORTS .00 .00 1,500.00 1,500.00 .0 17-0422-03-00 PRINTING AND PUBLISHING 100.92 100.92 1,000.00 899.08 10.1 17-0422-04-00 GAS AND OIL, REIMBURSEMENT .00 208.32 1,000.00 791.68 20.8 17-0422-05-00 COMMUNICATION .00 .00 300.00 300.00 .0 17-0422-06-00 PRINTING AND PUBLISHING .00 .00 500.00 500.00 .0 17-0422-07-00 PROFESSIONAL DUES 1,261.00 1,748.99 2,000.00 251.01 87.5 17-0422-08-00 TRAINING AND EDUCATION .00 1,578.77 3,000.00 1,421.23 52.6 17-0422-09-00 TRAVEL & PER DIEM .00 1,970.54 5,000.00 3,029.46 39.4 17-0422-10-00 BACKGROUND CHECKS 1,612.41 7,339.26 8,000.00 660.74 91.7 17-0422-11-00 REFUNDS-PARK REC PROGRAMS 957.20 5,667.40 4,000.00 ( 1,667.40)141.7 TOTAL ADMINISTRATION 3,961.78 18,746.72 31,800.00 13,053.28 59.0 RECREATION 17-0423-00-00 REC SUPPLIES-CAMPS & CLASSES 1,867.14 4,914.95 10,000.00 5,085.05 49.2 17-0423-00-01 REC SUPPLIES-TEAM SPORTS 5,370.69 15,051.82 20,000.00 4,948.18 75.3 17-0423-01-00 UNIFORMS, TEAM SPORTS 8,905.40 15,489.51 15,000.00 ( 489.51)103.3 17-0423-02-00 FIELD TRIPS 9,637.82 13,547.40 20,000.00 6,452.60 67.7 17-0423-04-00 TRANSPORTATION SERVICES 9,343.75 13,857.50 15,000.00 1,142.50 92.4 17-0423-05-00 DADDY DAUGHTER DANCE ( 175.00)1,149.37 2,000.00 850.63 57.5 17-0423-08-00 HALLOWEEN TRICK-OR-TREAT 787.23 787.23 800.00 12.77 98.4 17-0423-09-00 VETERAN'S BREAKFAST .00 665.72 1,500.00 834.28 44.4 17-0423-10-00 MOTHER-SON MONSTER MASH .00 2,118.07 2,000.00 ( 118.07)105.9 17-0423-11-00 SENIOR CENTER 5,617.81 12,802.04 10,000.00 ( 2,802.04)128.0 17-0423-11-01 SENIOR CENTER GRANT .00 11,270.28 .00 ( 11,270.28).0 17-0423-12-00 EAGLE ARTS ADVISORY COMMITTEE 13,543.82 27,588.54 50,000.00 22,411.46 55.2 17-0423-20-00 NEW PROGRAMS 3,856.45 3,856.45 5,000.00 1,143.55 77.1 TOTAL RECREATION 58,755.11 123,098.88 151,300.00 28,201.12 81.4 VEHICLES 17-0424-03-00 GAS AND OIL 234.41 327.88 1,000.00 672.12 32.8 TOTAL VEHICLES 234.41 327.88 1,000.00 672.12 32.8 CAPITAL EQUIPMENT 17-0425-00-00 REC EQUIPMENT-TEAM SPORTS 3,185.47 9,921.45 15,000.00 5,078.55 66.1 17-0425-01-00 REC EQUIPMENT-CAMPS/CLASSES 1,187.22 1,289.03 3,000.00 1,710.97 43.0 TOTAL CAPITAL EQUIPMENT 4,372.69 11,210.48 18,000.00 6,789.52 62.3 CAPITAL OUTLAY 17-0460-02-00 FURNITURE 952.53 1,019.38 2,000.00 980.62 51.0 TOTAL CAPITAL OUTLAY 952.53 1,019.38 2,000.00 980.62 51.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 RECREATION - ADM & ACTIVITIES YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 33 TOTAL FUND EXPENDITURES 295,997.13 916,713.08 950,120.00 33,406.92 96.5 NET REVENUE OVER EXPENDITURES ( 13,168.50)( 8,056.59).00 8,056.59 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 IT DEPARTMENT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 34 LIABILITIES AND EQUITY LIABILITIES 18-0202-00-00 VOUCHERS PAYABLE 472.86 18-0217-03-00 FICA 555.58 18-0217-04-00 PERSI RETIREMENT 936.81 18-0217-07-00 INSURANCE ( 28,385.76) 18-0217-09-00 WORKERS' COMPENSATION 2,324.64 18-0217-10-00 HSA CONTRIBUTION 820.00 TOTAL LIABILITIES ( 23,275.87) FUND EQUITY 18-0271-00-00 FUND BALANCE 39,816.94 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 16,541.07) BALANCE - CURRENT DATE ( 16,541.07) TOTAL FUND EQUITY 23,275.87 TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 35 REVENUE 18-0301-00-00 FUNDING FROM GENERAL FUND 290,125.03 983,736.48 1,204,530.00 220,793.52 81.7 TOTAL FUND REVENUE 290,125.03 983,736.48 1,204,530.00 220,793.52 81.7 EXPENDITURES ADMINISTRATION 18-0413-01-00 OFFICE SUPPLIES .00 .00 1,000.00 1,000.00 .0 18-0413-02-00 SUPPLIES .00 726.75 4,000.00 3,273.25 18.2 18-0413-03-00 TRAINING AND EDUCATION .00 .00 8,000.00 8,000.00 .0 18-0413-04-00 TRAVEL & PER DIEM 3,084.82 3,696.22 7,000.00 3,303.78 52.8 18-0413-05-00 PROFESSIONAL DUES .00 .00 750.00 750.00 .0 TOTAL ADMINISTRATION 3,084.82 4,422.97 20,750.00 16,327.03 21.3 PERSONNEL 18-0415-10-00 SALARIES - FULL TIME 85,305.11 336,619.08 329,500.00 ( 7,119.08)102.2 18-0415-11-00 OVERTIME 487.03 3,007.59 5,000.00 1,992.41 60.2 18-0415-21-00 FICA 6,409.27 25,342.40 25,800.00 457.60 98.2 18-0415-22-00 PERSI 10,154.05 38,309.92 40,200.00 1,890.08 95.3 18-0415-23-00 HRA BUY- DOWN 1,145.94 1,145.94 3,080.00 1,934.06 37.2 18-0415-24-00 WORKERS' COMPENSATION .00 18.82 .00 ( 18.82).0 18-0415-25-00 INSURANCE 12,151.49 40,045.25 58,500.00 18,454.75 68.5 18-0415-26-00 HSA CONTRIBUTION 225.00 925.00 1,200.00 275.00 77.1 18-0415-27-00 PTO CASH OUT .00 .00 2,500.00 2,500.00 .0 TOTAL PERSONNEL 115,877.89 445,414.00 465,780.00 20,366.00 95.6 CONTRACT & AGREEMENTS 18-0416-01-00 CONTRACT AND AGREEMENTS 132,206.72 383,309.06 453,000.00 69,690.94 84.6 TOTAL CONTRACT & AGREEMENTS 132,206.72 383,309.06 453,000.00 69,690.94 84.6 INTERNET/PHONE SERVICES 18-0417-01-00 INTERNET & PHONE SERVICES 36,899.38 123,380.74 89,000.00 ( 34,380.74)138.6 TOTAL INTERNET/PHONE SERVICES 36,899.38 123,380.74 89,000.00 ( 34,380.74)138.6 OPERATIONAL RESERVES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 IT DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 36 18-0418-01-00 IT EQUIPMENT/SOFTWARE .00 6,720.03 55,000.00 48,279.97 12.2 TOTAL OPERATIONAL RESERVES .00 6,720.03 55,000.00 48,279.97 12.2 CAPITAL OUTLAY 18-0419-01-00 FURNITURE .00 .00 1,000.00 1,000.00 .0 18-0419-02-00 EQUIPMENT 6,286.87 29,118.71 65,000.00 35,881.29 44.8 18-0419-03-00 SOFTWARE PURCHASES .00 7,912.04 40,000.00 32,087.96 19.8 18-0419-04-00 WEBSITE DEVELOPMENT .00 .00 12,000.00 12,000.00 .0 18-0419-05-00 TOOLS .00 .00 3,000.00 3,000.00 .0 TOTAL CAPITAL OUTLAY 6,286.87 37,030.75 121,000.00 83,969.25 30.6 TOTAL FUND EXPENDITURES 294,355.68 1,000,277.55 1,204,530.00 204,252.45 83.0 NET REVENUE OVER EXPENDITURES ( 4,230.65)( 16,541.07).00 16,541.07 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 CAPITAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 37 ASSETS 19-0151-25-00 INVESTMENTS 5,008,183.91 TOTAL ASSETS 5,008,183.91 LIABILITIES AND EQUITY LIABILITIES 19-0202-00-00 VOUCHERS PAYABLE 33,057.75 19-0225-00-00 UNEARNED GRANT REVENUE, ARPA 941,148.64 TOTAL LIABILITIES 974,206.39 FUND EQUITY 19-0271-00-00 FUND BALANCE 5,131,153.38 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 1,097,175.86) BALANCE - CURRENT DATE ( 1,097,175.86) TOTAL FUND EQUITY 4,033,977.52 TOTAL LIABILITIES AND EQUITY 5,008,183.91 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 38 REVENUE 19-0301-00-00 FUNDING FROM GENERAL FUND 697,153.26 955,187.65 2,998,200.00 2,043,012.35 31.9 19-0301-05-00 EAGLE RD PED/BIKE BRIDGE .00 563,500.56 28,000.00 ( 535,500.56)2012.5 19-0301-19-00 DEVELOPER PARTICIPATION .00 .00 100,000.00 100,000.00 .0 19-0333-01-00 STATE GRANTS .00 .00 10,000.00 10,000.00 .0 19-0371-25-00 BANK INTEREST 61,958.30 260,381.56 15,000.00 ( 245,381.56)1735.9 19-0399-00-00 CARRY OVER .00 .00 8,035,020.00 8,035,020.00 .0 19-0399-01-00 CARRY OVER, ARPA FUNDS .00 .00 140,000.00 140,000.00 .0 TOTAL FUND REVENUE 759,111.56 1,779,069.77 11,326,220.00 9,547,150.23 15.7 EXPENDITURES RESERVES 19-0410-01-00 RESERVES, FUTURE PROJECTS .00 .00 3,187,211.00 3,187,211.00 .0 TOTAL RESERVES .00 .00 3,187,211.00 3,187,211.00 .0 CAPITAL MAINTENANCE 19-0462-01-00 CAPITAL MAINTENANCE SET ASIDE 50,715.30 641,384.58 2,146,700.00 1,505,315.42 29.9 TOTAL CAPITAL MAINTENANCE 50,715.30 641,384.58 2,146,700.00 1,505,315.42 29.9 CITY CAPITAL PROJECTS 19-0465-05-00 GENERAL CITY PROJECTS .00 .00 100,000.00 100,000.00 .0 19-0465-08-00 CURRENT FISCAL YEAR PROJECTS 646,750.92 884,258.54 2,545,000.00 1,660,741.46 34.7 TOTAL CITY CAPITAL PROJECTS 646,750.92 884,258.54 2,645,000.00 1,760,741.46 33.4 PZ CAPITAL PROJECTS 19-0466-03-00 AIKENS EXTENSION 38,281.51 53,569.23 680,000.00 626,430.77 7.9 19-0466-05-00 EAGLE RD PED/BIKE BRIDGE 23,982.85 198,380.19 30,000.00 ( 168,380.19)661.3 19-0466-09-00 EAGLE-STATE ST INTERSECTION 54,730.77 69,568.52 1,010,309.00 940,740.48 6.9 19-0466-10-00 P&Z CAPITAL PROJECTS 122.50 13,047.50 400,000.00 386,952.50 3.3 TOTAL PZ CAPITAL PROJECTS 117,117.63 334,565.44 2,120,309.00 1,785,743.56 15.8 PARK CAPITAL PROJECTS 19-0467-02-00 PARK CAPITAL PROJECTS 587,561.79 749,371.76 537,000.00 ( 212,371.76)139.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 CAPITAL PROJECTS FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:16PM PAGE: 39 TOTAL PARK CAPITAL PROJECTS 587,561.79 749,371.76 537,000.00 ( 212,371.76)139.6 LIBRARY CAPITAL PROJECTS 19-0468-01-00 LIBRARY CAPITAL PROJECTS .00 .00 50,000.00 50,000.00 .0 TOTAL LIBRARY CAPITAL PROJECTS .00 .00 50,000.00 50,000.00 .0 PW CAPITAL PROJECTS 19-0469-09-00 PW CAPITAL PROJECTS .00 .00 450,000.00 450,000.00 .0 TOTAL PW CAPITAL PROJECTS .00 .00 450,000.00 450,000.00 .0 FLEET CAPITAL PROJECTS 19-0470-01-00 FLEET EXPANSION .00 .00 50,000.00 50,000.00 .0 TOTAL FLEET CAPITAL PROJECTS .00 .00 50,000.00 50,000.00 .0 FEDERAL FUNDS PROJECTS 19-0486-01-00 ARPA, CAPITAL PROJECTS, TBD 62.96 235,518.41 140,000.00 ( 95,518.41)168.2 19-0486-01-01 ARPA, SOFTWARE PURCHASES 2,765.13 31,146.90 .00 ( 31,146.90).0 TOTAL FEDERAL FUNDS PROJECTS 2,828.09 266,665.31 140,000.00 ( 126,665.31)190.5 TOTAL FUND EXPENDITURES 1,404,973.73 2,876,245.63 11,326,220.00 8,449,974.37 25.4 NET REVENUE OVER EXPENDITURES ( 645,862.17)( 1,097,175.86).00 1,097,175.86 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 PUBLIC WORKS FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:17PM PAGE: 40 LIABILITIES AND EQUITY LIABILITIES 23-0202-00-00 VOUCHERS PAYABLE 20,524.94 23-0216-00-00 ACCRUED PAYROLL 10,783.10 23-0217-03-00 FICA 3,569.98 23-0217-04-00 PERSI RETIREMENT 2,814.49 23-0217-05-00 PW DEPT MISC DEDUCTIONS ( 14,386.03) 23-0217-07-00 INSURANCE 1,667.52 23-0217-08-00 GARNISHMENTS ( 1,837.46) 23-0217-09-00 WORKERS' COMPENSATION 147,462.41 23-0217-10-00 HSA CONTRIBUTION ( 1,160.00) TOTAL LIABILITIES 169,438.95 FUND EQUITY 23-0271-00-00 FUND BALANCE ( 218,114.56) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 48,675.61 BALANCE - CURRENT DATE 48,675.61 TOTAL FUND EQUITY ( 169,438.95) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:17PM PAGE: 41 REVENUE 23-0302-00-00 FUNDING FROM GENERAL FUND 542,245.05 2,169,203.23 2,884,511.00 715,307.77 75.2 23-0315-02-00 SIDEWALKS, LTS, TREES, STR-REP .00 .00 50,000.00 50,000.00 .0 23-0315-06-00 TREE FUNDS, CARRYOVER 26,607.50 31,857.50 22,291.00 ( 9,566.50)142.9 23-0315-09-00 WYCLIFF PUMP STATION .00 27,466.74 10,500.00 ( 16,966.74)261.6 23-0316-00-00 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 23-0316-01-00 MEMORIAL DONATIONS 2,557.98 1,560.00 6,000.00 4,440.00 26.0 TOTAL FUND REVENUE 571,410.53 2,230,087.47 2,973,602.00 743,514.53 75.0 EXPENDITURES PERSONNEL 23-0433-10-00 SALARIES-FULL TIME 207,126.13 999,912.47 1,110,000.00 110,087.53 90.1 23-0433-10-01 SALARIES - PERSONNEL SERVICES 34,839.19 34,839.19 125,000.00 90,160.81 27.9 23-0433-11-00 OVERTIME 3,649.72 13,598.19 20,000.00 6,401.81 68.0 23-0433-16-00 SALARIES -SEASONAL .00 509.31 .00 ( 509.31).0 23-0433-21-00 FICA 15,572.02 75,743.81 87,500.00 11,756.19 86.6 23-0433-22-00 PERSI 24,780.33 115,483.01 135,500.00 20,016.99 85.2 23-0433-23-00 HRA BUY-DOWN .00 .00 7,700.00 7,700.00 .0 23-0433-24-00 WORKERS' COMPENSATION .00 1,588.64 .00 ( 1,588.64).0 23-0433-25-00 INSURANCE 44,857.06 193,990.31 227,500.00 33,509.69 85.3 23-0433-26-00 HSA CONTRIBUTION 1,500.00 6,000.00 4,800.00 ( 1,200.00)125.0 23-0433-29-00 PTO CASH OUT 1,010.00 10,190.00 15,000.00 4,810.00 67.9 TOTAL PERSONNEL 333,334.45 1,451,854.93 1,733,000.00 281,145.07 83.8 ADMINISTRATION 23-0435-01-00 OFFICE SUPPLIES 21.91 450.62 1,000.00 549.38 45.1 23-0435-02-00 PRINT, PUBLISH, LEGAL, ADV 399.50 421.26 5,000.00 4,578.74 8.4 23-0435-03-00 TRAINING, EDUCATION, TRVL, ETC 3,642.21 6,033.52 20,000.00 13,966.48 30.2 23-0435-04-00 DUES, CERTIFICATIONS, LICENSES .00 576.35 1,000.00 423.65 57.6 23-0435-09-00 STAFF AND PUBLIC RELATIONS 221.71 3,103.57 2,500.00 ( 603.57)124.1 23-0435-10-00 SAFETY CLOTHING AND GEAR 2,731.92 6,749.71 6,500.00 ( 249.71)103.8 TOTAL ADMINISTRATION 7,017.25 17,335.03 36,000.00 18,664.97 48.2 IRRIGATION CONTRACTS/AGRMNTS 23-0437-01-00 WYCLIFFE PUMP STATION 4,004.28 10,092.06 6,690.00 ( 3,402.06)150.9 23-0437-02-00 IRRIGATION SHARES AND DUES .00 19,733.10 20,000.00 266.90 98.7 23-0437-03-00 BASELINE MANAGER AGREEMENT .00 3,942.00 4,500.00 558.00 87.6 23-0437-04-00 CHAUMONT LEASE AGREEMENT .00 1.00 1.00 .00 100.0 TOTAL IRRIGATION CONTRACTS/AGRMNTS 4,004.28 33,768.16 31,191.00 ( 2,577.16)108.3 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:17PM PAGE: 42 GENERAL MTNC & REPAIR 23-0439-02-00 MISC MTNC & REPAIR GROUNDS 6,129.36 10,747.74 45,000.00 34,252.26 23.9 23-0439-02-01 MISC MTNC & REPAIR EQUIPMENT 13,974.56 20,873.28 20,000.00 ( 873.28)104.4 23-0439-02-02 MISC MTNC & REPAIR BUILDINGS 1,833.46 13,098.20 10,000.00 ( 3,098.20)131.0 23-0439-02-03 EMERGENCY REPAIRS .00 7,270.00 25,000.00 17,730.00 29.1 23-0439-02-04 REPAIRS-STRTS,SDWLKS,TREES,LTS .00 .00 50,000.00 50,000.00 .0 23-0439-03-00 MATERIALS AND SUPPLIES 9,427.74 29,049.99 50,000.00 20,950.01 58.1 23-0439-04-00 HOLIDAY LIGHTING 14,056.44 20,960.34 50,000.00 29,039.66 41.9 23-0439-05-00 CLEANING AND PAPER SUPPLIES 19,477.35 35,736.94 50,000.00 14,263.06 71.5 23-0439-06-00 SIGNS & SIGN REPLACEMENT 2,328.65 5,591.02 5,000.00 ( 591.02)111.8 TOTAL GENERAL MTNC & REPAIR 67,227.56 143,327.51 305,000.00 161,672.49 47.0 VEHICLES 23-0441-01-00 VEHICLE MTNC & REPAIR 21,049.07 48,600.01 35,000.00 ( 13,600.01)138.9 23-0441-02-00 FUEL 8,131.20 31,086.60 45,000.00 13,913.40 69.1 TOTAL VEHICLES 29,180.27 79,686.61 80,000.00 313.39 99.6 FACILITIES 23-0443-01-00 CITY HALL 13,288.56 51,247.00 57,200.00 5,953.00 89.6 23-0443-02-00 LIBRARY 550.00 4,311.09 16,000.00 11,688.91 26.9 23-0443-03-00 MUSEUM .00 299.00 2,500.00 2,201.00 12.0 23-0443-04-00 CITY SHOP 1,334.83 6,461.43 10,000.00 3,538.57 64.6 23-0443-04-01 CITY SHOP UPGRADES, SV 8,071.53 8,675.14 10,000.00 1,324.86 86.8 23-0443-05-00 SENIOR CENTER 6,830.39 25,659.24 10,000.00 ( 15,659.24)256.6 23-0443-06-00 JACKSON HOUSE 1,831.97 7,859.93 10,000.00 2,140.07 78.6 23-0443-07-00 LINDER ROAD RESTROOM 1,188.74 4,336.28 6,000.00 1,663.72 72.3 23-0443-15-00 STREET LIGHTS 7,756.26 32,412.00 43,000.00 10,588.00 75.4 TOTAL FACILITIES 40,852.28 141,261.11 164,700.00 23,438.89 85.8 PARKS, MONUMENTS & GROUNDS 23-0445-01-00 ADA-EAGLE SPORTS PARK 22,259.12 43,442.90 36,400.00 ( 7,042.90)119.4 23-0445-02-00 ARBORETUM PARK .00 .00 2,000.00 2,000.00 .0 23-0445-03-00 SV REGIONAL SPORTS COMPLEX 5,151.47 5,229.47 10,000.00 4,770.53 52.3 23-0445-04-00 FLAG PLAZA 141.06 242.45 1,000.00 757.55 24.3 23-0445-05-00 FRIENDSHIP PARK 6,930.50 10,703.60 6,000.00 ( 4,703.60)178.4 23-0445-06-00 GUERBER PARK 17,677.42 31,306.06 30,000.00 ( 1,306.06)104.4 23-0445-07-00 HERITAGE PARK 1,314.03 2,931.86 7,500.00 4,568.14 39.1 23-0445-08-00 MACE PARKING AREA .00 .00 5,000.00 5,000.00 .0 23-0445-09-00 MCDONALD'S PATHWAY 469.06 670.33 2,000.00 1,329.67 33.5 23-0445-10-00 MERRILL PARK 9,365.62 17,882.32 29,000.00 11,117.68 61.7 23-0445-11-00 ORVAL KRASEN PARK 2,267.20 4,040.28 4,500.00 459.72 89.8 23-0445-12-00 PAMELA BAKER PARK 6,642.92 9,597.40 11,000.00 1,402.60 87.3 23-0445-13-00 PLAZA DRIVE .00 .00 4,000.00 4,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:17PM PAGE: 43 23-0445-14-00 TRAILS 32.85 2,467.52 11,500.00 9,032.48 21.5 23-0445-20-00 CITY ENTRANCE SIGNS 5,981.19 11,088.43 15,000.00 3,911.57 73.9 23-0445-30-00 LANDSCAPING, EQUIPMENT RENTAL 435.68 1,693.06 15,000.00 13,306.94 11.3 23-0445-30-01 LANDSCAPING, SPRAY/FERTILIZE 3,725.00 18,888.42 35,000.00 16,111.58 54.0 23-0445-30-03 LANDSCAPING, DUMPING/DISPOSAL 367.42 1,657.06 5,000.00 3,342.94 33.1 TOTAL PARKS, MONUMENTS & GROUNDS 82,760.54 161,841.16 229,900.00 68,058.84 70.4 MEMORIALS AND PROGRAMS 23-0447-01-00 MEMORIALS, MTNC/REPAIR 2,557.98 4,192.98 6,000.00 1,807.02 69.9 23-0447-02-00 MATERIALS & SUPPLIES .00 243.05 1,000.00 756.95 24.3 23-0447-03-00 FLOWERS 2,585.40 13,353.37 20,000.00 6,646.63 66.8 23-0447-04-00 SANITATION AND RECYCLING 2,812.42 9,515.32 54,000.00 44,484.68 17.6 23-0447-05-00 TREES, PUBLIC DEVELOPMENT 2,158.70 22,392.36 29,511.00 7,118.64 75.9 23-0447-05-01 TREE VOUCHER PROGRAM ( 100.00)14,721.88 15,000.00 278.12 98.2 23-0447-05-02 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 TOTAL MEMORIALS AND PROGRAMS 10,014.50 64,418.96 125,811.00 61,392.04 51.2 FISCAL YEAR PROJECTS 23-0483-15-00 LANDSCAPE UPGRADES - PARKS 8,999.15 24,092.05 25,000.00 907.95 96.4 23-0483-20-01 TOOLS 4,009.34 6,282.38 5,000.00 ( 1,282.38)125.7 23-0483-20-02 EQUIPMENT 19,152.96 57,543.96 85,000.00 27,456.04 67.7 23-0483-20-03 VEHICLE REPLACEMENT .00 .00 53,000.00 53,000.00 .0 23-0483-50-24 CAPITAL PROJECTS, CURRENT FY .00 .00 100,000.00 100,000.00 .0 TOTAL FISCAL YEAR PROJECTS 32,161.45 87,918.39 268,000.00 180,081.61 32.8 TOTAL FUND EXPENDITURES 606,552.58 2,181,411.86 2,973,602.00 792,190.14 73.4 NET REVENUE OVER EXPENDITURES ( 35,142.05)48,675.61 .00 ( 48,675.61).0 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:18PM PAGE: 44 REVENUE 24-0301-00-00 FUNDING FROM GENERAL FUND 58,875.96 64,885.96 126,400.00 61,514.04 51.3 24-0303-00-00 SPONSORSHIPS .00 10,000.00 21,000.00 11,000.00 47.6 24-0303-01-00 CAR SHOW .00 .00 3,300.00 3,300.00 .0 24-0303-03-00 FUN RUN .00 .00 3,000.00 3,000.00 .0 24-0303-04-00 VENDORS 3,213.75 7,314.96 7,000.00 ( 314.96)104.5 24-0303-05-00 ROCKY MOUNTAIN OYSTER FEED .00 .00 15,000.00 15,000.00 .0 24-0303-07-00 MISCELLANEOUS REVENUE 57.36 3,346.26 .00 ( 3,346.26).0 TOTAL FUND REVENUE 62,147.07 85,547.18 175,700.00 90,152.82 48.7 EXPENDITURES ADMIN EXPENDITURES 24-0401-01-00 FUN DAYS CONTRACTS 22,647.02 42,525.97 60,000.00 17,474.03 70.9 24-0401-04-00 ADVERTISEMENT 12,866.96 13,966.96 10,000.00 ( 3,966.96)139.7 24-0401-05-00 MUSIC & ENTERTAINMENT .00 700.00 .00 ( 700.00).0 24-0401-06-00 SUPPLIES 760.12 760.12 9,300.00 8,539.88 8.2 24-0401-07-00 EQUIPMENT 2,000.00 2,000.00 7,500.00 5,500.00 26.7 TOTAL ADMIN EXPENDITURES 38,274.10 59,953.05 86,800.00 26,846.95 69.1 LOGISTICS 24-0410-00-00 PORTA POTTIES 4,090.00 4,090.00 5,000.00 910.00 81.8 24-0410-02-00 TRAFFIC BARRIERS & CONTROL 9,696.83 9,756.83 22,000.00 12,243.17 44.4 24-0410-03-00 GOLF CART RENTALS .00 .00 500.00 500.00 .0 24-0410-04-00 POLICE OVERTIME 498.00 498.00 7,000.00 6,502.00 7.1 24-0410-06-00 SIGNAGE 694.65 694.65 5,000.00 4,305.35 13.9 24-0410-07-00 SECURITY 10,100.00 10,100.00 10,000.00 ( 100.00)101.0 TOTAL LOGISTICS 25,079.48 25,139.48 49,500.00 24,360.52 50.8 COMMUNITY EVENTS 24-0420-01-00 FUN RUN .00 .00 5,400.00 5,400.00 .0 24-0420-10-00 CAR SHOW .00 10.00 4,000.00 3,990.00 .3 TOTAL COMMUNITY EVENTS .00 10.00 9,400.00 9,390.00 .1 ROCKY MOUNTAIN OYSTER FEED 24-0445-01-00 COMMUNITY BENEFICIARY .00 .00 20,000.00 20,000.00 .0 24-0445-03-00 FOOD AND BEVERAGE 444.65 444.65 10,000.00 9,555.35 4.5 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 RECREATION - EAGLE FUN DAYS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:18PM PAGE: 45 TOTAL ROCKY MOUNTAIN OYSTER FEED 444.65 444.65 30,000.00 29,555.35 1.5 TOTAL FUND EXPENDITURES 63,798.23 85,547.18 175,700.00 90,152.82 48.7 NET REVENUE OVER EXPENDITURES ( 1,651.16).00 .00 .00 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 PATHWAY IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:18PM PAGE: 46 ASSETS 25-0101-00-00 CASH 86,357.34 25-0151-25-00 INVESTMENTS 58,683.81 TOTAL ASSETS 145,041.15 LIABILITIES AND EQUITY FUND EQUITY 25-0271-00-00 FUND BALANCE 142,294.84 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 2,746.31 BALANCE - CURRENT DATE 2,746.31 TOTAL FUND EQUITY 145,041.15 TOTAL LIABILITIES AND EQUITY 145,041.15 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 PATHWAY IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:18PM PAGE: 47 REVENUE 25-0322-19-00 PATHWAY DEVELOPMENT IMPACT FEE 41,973.50 163,267.00 82,625.00 ( 80,642.00)197.6 25-0371-25-00 BANK INTEREST 410.47 2,829.85 1,000.00 ( 1,829.85)283.0 25-0399-00-00 CARRY OVER .00 .00 139,900.00 139,900.00 .0 TOTAL FUND REVENUE 42,383.97 166,096.85 223,525.00 57,428.15 74.3 EXPENDITURES CAPITAL IMPROVEMENTS 25-0438-00-00 CAPITAL IMPROVEMENTS .00 163,350.54 213,525.00 50,174.46 76.5 25-0438-34-00 IMPACT FEE UPDATE .00 .00 10,000.00 10,000.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 163,350.54 223,525.00 60,174.46 73.1 TOTAL FUND EXPENDITURES .00 163,350.54 223,525.00 60,174.46 73.1 NET REVENUE OVER EXPENDITURES 42,383.97 2,746.31 .00 ( 2,746.31).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 LAW ENF DEV IMPACT FEES FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:18PM PAGE: 48 ASSETS 27-0101-00-00 CASH 21,651.25 27-0151-25-00 INVESTMENTS 157,268.71 TOTAL ASSETS 178,919.96 LIABILITIES AND EQUITY FUND EQUITY 27-0271-00-00 POLICE IMPACT FEE/FUND BALANCE 116,197.61 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 62,722.35 BALANCE - CURRENT DATE 62,722.35 TOTAL FUND EQUITY 178,919.96 TOTAL LIABILITIES AND EQUITY 178,919.96 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 LAW ENF DEV IMPACT FEES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:18PM PAGE: 49 REVENUE 27-0322-19-00 RESIDENTIAL IMPACT FEES 14,553.20 57,460.61 27,750.00 ( 29,710.61)207.1 27-0322-20-00 COMMERCIAL - IMPACT FEES .00 .00 30,000.00 30,000.00 .0 27-0371-25-00 BANK INTEREST 1,483.97 5,261.74 200.00 ( 5,061.74)2630.9 27-0399-00-00 CARRY OVER .00 .00 100,000.00 100,000.00 .0 TOTAL FUND REVENUE 16,037.17 62,722.35 157,950.00 95,227.65 39.7 EXPENDITURES CAPITAL IMPROVEMENTS 27-0438-00-00 EQUIPMENT .00 .00 78,975.00 78,975.00 .0 27-0438-01-00 CITY FACILITY .00 .00 78,975.00 78,975.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 .00 157,950.00 157,950.00 .0 TOTAL FUND EXPENDITURES .00 .00 157,950.00 157,950.00 .0 NET REVENUE OVER EXPENDITURES 16,037.17 62,722.35 .00 ( 62,722.35).0 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 CITY HALL BOND FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:18PM PAGE: 50 REVENUE 54-0399-01-00 FUNDING FROM GENERAL FUND 97,085.39 104,044.80 104,750.00 705.20 99.3 TOTAL FUND REVENUE 97,085.39 104,044.80 104,750.00 705.20 99.3 EXPENDITURES BOND PAYMENTS 54-0480-81-00 PRINCIPAL BOND PAYMENT 90,000.00 90,000.00 90,000.00 .00 100.0 54-0480-82-00 INTEREST BOND PAYMENT 7,085.39 13,594.80 14,250.00 655.20 95.4 54-0480-84-00 PAYING AGENT FEE .00 450.00 500.00 50.00 90.0 TOTAL BOND PAYMENTS 97,085.39 104,044.80 104,750.00 705.20 99.3 TOTAL FUND EXPENDITURES 97,085.39 104,044.80 104,750.00 705.20 99.3 NET REVENUE OVER EXPENDITURES .00 .00 .00 .00 .0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 WATER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:19PM PAGE: 51 ASSETS 60-0101-00-00 CASH 581,289.22 60-0115-00-00 ACCOUNTS RECEIVABLE 135,017.70 60-0151-25-00 INVESTMENTS, WATER SYSTEM 8,326,588.24 60-0161-00-00 WATER/LAND 93,250.00 60-0162-00-00 WATER/BUILDINGS & STRUCTURES 559,285.00 60-0163-00-00 WATER/ACCUMULATED DEP.-BLDGS.&( 194,823.00) 60-0164-00-00 WATER/IMPROVEMENTS-OTHER THAN 16,960,303.00 60-0165-00-00 WATER/ACCUM. DEP.-IMPROVEMENTS ( 4,591,075.00) 60-0166-00-00 WATER/MACHINERY & EQUIPMENT 1,555,752.00 60-0167-00-00 WATER/ACCUMULATED DEPREC-EQUIP ( 1,117,966.00) 60-0170-00-00 HRA 10% DEPOSIT 550.08 60-0171-00-00 DEFERRED OUTFLOWS-PENSION 128,610.00 TOTAL ASSETS 22,436,781.24 LIABILITIES AND EQUITY LIABILITIES 60-0202-00-00 WATER/VOUCHERS PAYABLE 125,455.07 60-0204-00-00 WATER/LEXINGTON - TVV 1,787.89 60-0215-00-00 INTEREST PAYABLE 1,933.00 60-0216-00-00 ACCRUED PAYROLL 6,081.88 60-0217-00-00 COMPENSATED ABSENCE PAYABLE 12,420.00 60-0217-03-00 FICA 1,542.82 60-0217-04-00 PERSI RETIREMENT 2,618.32 60-0217-07-00 INSURANCE 11,488.29 60-0217-08-00 GARNISHMENTS 1,162.50 60-0217-09-00 WORKERS' COMPENSATION 71,563.06 60-0217-10-00 HSA CONTRIBUTION ( 100.00) 60-0217-11-00 NET PENSION LIABILITY 325,075.00 60-0220-00-00 SERVICE DEPOSITS, WATER 92,450.00 60-0220-01-00 SERVICE DEPOSITS, HYDRANT MTR 400.00 60-0231-00-00 DEQ LOAN 118,942.00 TOTAL LIABILITIES 772,819.83 FUND EQUITY 60-0271-00-00 WATER/FUND BALANCE 19,623,429.73 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 2,040,531.68 BALANCE - CURRENT DATE 2,040,531.68 TOTAL FUND EQUITY 21,663,961.41 TOTAL LIABILITIES AND EQUITY 22,436,781.24 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:19PM PAGE: 52 REVENUE 60-0346-59-00 STL-STORAGE & TRUNK LINE FEE 145,234.04 1,653,261.23 105,000.00 ( 1,548,261.23)1574.5 60-0346-60-00 HOOK UP FEES CITY 79,165.00 334,500.00 172,050.00 ( 162,450.00)194.4 60-0346-61-00 METER FEE 11,248.00 11,248.00 .00 ( 11,248.00).0 60-0346-62-00 PROFESSIONAL SERV - DEVELOPERS 13,475.50 33,666.19 50,000.00 16,333.81 67.3 60-0346-63-00 STAFF TIME REIMB - DEVELOPERS 3,326.85 3,878.85 5,000.00 1,121.15 77.6 60-0347-01-00 BILLING REVENUE 441,901.07 1,604,889.37 1,322,000.00 ( 282,889.37)121.4 60-0347-02-00 OTHER REVENUE 3,360.00 9,284.36 4,120.00 ( 5,164.36)225.4 60-0347-03-00 RECONNECT FEES 100.00 275.00 300.00 25.00 91.7 60-0347-04-00 DELINQUENT FEES 2,325.00 11,229.00 12,000.00 771.00 93.6 60-0347-05-00 MISCELLANEOUS REVENUE 10,345.56 14,542.14 12,000.00 ( 2,542.14)121.2 60-0347-06-00 SYSTEM ENHANCEMENT FEE ( 2.51)206.58 100,000.00 99,793.42 .2 60-0355-01-00 WCE-WATER CONST EQUIV FEE 24,800.00 94,400.00 20,000.00 ( 74,400.00)472.0 60-0371-25-00 BANK INTEREST 94,202.86 324,809.86 10,000.00 ( 314,809.86)3248.1 60-0399-00-00 CARRY OVER .00 .00 279,930.00 279,930.00 .0 60-0399-01-00 RESERVES, FOR BUDGET .00 .00 375,000.00 375,000.00 .0 60-0399-02-00 RESERVES, EMERGENCY REPL ITEMS .00 .00 200,000.00 200,000.00 .0 60-0399-03-00 RESERVES, EQUIP/BLDG REPLCMNT .00 .00 275,000.00 275,000.00 .0 60-0399-04-00 RESERVES, REPAIR/ MAINTENANCE .00 .00 200,000.00 200,000.00 .0 60-0399-05-00 RESERVES, VEHICLE REPLACEMENT .00 .00 12,000.00 12,000.00 .0 60-0399-06-00 RESERVES, STL FEES .00 .00 1,800,000.00 1,800,000.00 .0 TOTAL FUND REVENUE 829,481.37 4,096,190.58 4,954,400.00 858,209.42 82.7 EXPENDITURES VEHICLE OPERATIONS - LEASES 60-0420-01-00 GAS AND OIL 1,418.47 6,437.04 15,000.00 8,562.96 42.9 60-0420-03-00 VEHICLE MTNC & REPAIR 1,282.21 5,404.86 10,000.00 4,595.14 54.1 TOTAL VEHICLE OPERATIONS - LEASES 2,700.68 11,841.90 25,000.00 13,158.10 47.4 PERSONNEL 60-0433-10-00 SALARIES - FULL TIME 68,776.11 335,236.44 426,500.00 91,263.56 78.6 60-0433-10-02 ON-CALL TIME 844.58 3,275.62 7,500.00 4,224.38 43.7 60-0433-11-00 OVERTIME 3,213.57 5,586.72 4,500.00 ( 1,086.72)124.2 60-0433-21-00 FICA 5,665.36 26,036.36 33,500.00 7,463.64 77.7 60-0433-22-00 PERSI 8,907.80 39,306.70 52,500.00 13,193.30 74.9 60-0433-23-00 HRA BUY-DOWN .00 342.32 3,080.00 2,737.68 11.1 60-0433-23-01 HRA/COBRA ADMIN FEES .00 .00 400.00 400.00 .0 60-0433-24-00 WORKERS' COMPENSATION .00 10,339.20 17,500.00 7,160.80 59.1 60-0433-25-00 INSURANCE 7,982.81 41,414.32 59,310.00 17,895.68 69.8 60-0433-26-00 HSA CONTRIBUTION 300.00 1,900.00 2,400.00 500.00 79.2 60-0433-29-00 PTO CASH OUT 2,420.00 4,720.00 10,000.00 5,280.00 47.2 TOTAL PERSONNEL 98,110.23 468,157.68 617,190.00 149,032.32 75.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:19PM PAGE: 53 OPERATIONS & MAINTENANCE 60-0434-15-00 OFFICE SUPPLIES 6.92 646.08 2,000.00 1,353.92 32.3 60-0434-19-00 TELECOMMUNICATIONS/SCADA 2,407.28 10,570.77 17,000.00 6,429.23 62.2 60-0434-20-00 ADVERTISING - PUBLICATIONS 428.97 723.63 1,500.00 776.37 48.2 60-0434-22-00 TRAVEL-MTNGS-EDUCATION 254.48 4,345.14 8,000.00 3,654.86 54.3 60-0434-23-00 DUES & SUBSCRIPTIONS 146.00 1,017.00 3,000.00 1,983.00 33.9 60-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE 5,506.00 11,948.71 8,000.00 ( 3,948.71)149.4 60-0434-26-00 TOOLS, EQUIPMENT AND SUPPLIES 3,843.49 5,605.24 20,000.00 14,394.76 28.0 60-0434-26-01 EQUIPMENT RENTAL .00 .00 10,000.00 10,000.00 .0 60-0434-27-00 POSTAGE 500.00 514.50 1,300.00 785.50 39.6 60-0434-41-00 LIABILITY INSURANCE .00 4,000.00 5,900.00 1,900.00 67.8 60-0434-42-00 ENGINEERING SERVICES 3,161.09 22,361.13 35,000.00 12,638.87 63.9 60-0434-42-01 LEGAL SERVICES 2,292.50 3,570.00 25,000.00 21,430.00 14.3 60-0434-42-02 MISC LEGAL AND ENG SERVICES 7,916.21 13,487.06 100,000.00 86,512.94 13.5 60-0434-42-03 PROFESSIONAL SERV - DEVELOPERS 22,672.98 52,731.85 50,000.00 ( 2,731.85)105.5 60-0434-43-01 CONTRACT SERVICES (REPAIR).00 .00 35,000.00 35,000.00 .0 60-0434-44-00 DIG LINE 1,911.00 4,599.61 4,500.00 ( 99.61)102.2 60-0434-45-00 CITY AUDITOR SERVICES .00 3,500.00 3,500.00 .00 100.0 60-0434-47-00 MAIL SERVICE-CUSTOMER BILLING 10,144.26 29,214.05 31,500.00 2,285.95 92.7 60-0434-50-01 SHOP UTILITIES 530.01 2,657.18 5,100.00 2,442.82 52.1 60-0434-53-01 PUBLIC WATER DRINKING FEES .00 13,332.00 14,000.00 668.00 95.2 60-0434-53-03 PERMITS AND FEES .00 .00 1,500.00 1,500.00 .0 60-0434-55-00 CASELLE SUPPORT .00 .00 5,000.00 5,000.00 .0 60-0434-58-00 RPR/MTNC-LINES-METERS-ETC 2,249.76 5,815.44 40,000.00 34,184.56 14.5 60-0434-58-01 RPR/MTNC PUMPS-WELLS-CHEMICAL 1,656.91 13,152.63 40,000.00 26,847.37 32.9 60-0434-59-00 CHEMICALS 3,454.77 10,667.30 13,500.00 2,832.70 79.0 60-0434-60-00 UTILITIES 27,989.73 64,472.80 110,000.00 45,527.20 58.6 60-0434-68-00 UNIFORMS AND SAFETY CLOTHING 527.78 1,703.81 2,300.00 596.19 74.1 60-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 .00 25,000.00 25,000.00 .0 TOTAL OPERATIONS & MAINTENANCE 97,600.14 280,635.93 617,600.00 336,964.07 45.4 TESTING-WK-MO-QTR-ANNUAL 60-0435-56-00 TESTING-WK-MO-QTR-ANNUAL 3,840.00 6,015.00 40,000.00 33,985.00 15.0 TOTAL TESTING-WK-MO-QTR-ANNUAL 3,840.00 6,015.00 40,000.00 33,985.00 15.0 DEQ REVOLVING LOAN PAYMENT 60-0436-01-00 DEQ/STATE REVOLVING LOAN PMT .00 121,208.65 100,000.00 ( 21,208.65)121.2 TOTAL DEQ REVOLVING LOAN PAYMENT .00 121,208.65 100,000.00 ( 21,208.65)121.2 STL FEES, RESTRICTED 60-0437-01-00 STL FEES, REIMB SYS EXPANSION .00 754,632.80 200,000.00 ( 554,632.80)377.3 60-0437-03-00 STL FEES, REFUNDS .00 .00 50,000.00 50,000.00 .0 60-0437-05-01 CURRENT STL PROJECTS 125,513.58 145,515.32 400,000.00 254,484.68 36.4 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:19PM PAGE: 54 60-0437-99-01 RESERVES, STL FEES .00 .00 1,255,000.00 1,255,000.00 .0 TOTAL STL FEES, RESTRICTED 125,513.58 900,148.12 1,905,000.00 1,004,851.88 47.3 CAPITAL EXPENDITURES 60-0438-01-00 EQUIPMENT 90,276.49 95,576.61 85,500.00 ( 10,076.61)111.8 60-0438-08-00 METER SETS, NEW CUSTOMERS 68,968.42 124,768.07 99,200.00 ( 25,568.07)125.8 60-0438-11-00 CAPITAL CONSTRUCTION PROJECTS 35,270.94 35,270.94 157,500.00 122,229.06 22.4 60-0438-82-00 CITY HALL ADMIN OVERHEAD 3,009.00 12,036.00 13,410.00 1,374.00 89.8 60-0438-99-01 RESERVES, FOR BUDGET .00 .00 400,000.00 400,000.00 .0 60-0438-99-02 RESERVES, EMERGENCY REPL ITEMS .00 .00 225,000.00 225,000.00 .0 60-0438-99-03 RESERVES, EQUIP, BLDG REPLCMNT .00 .00 300,000.00 300,000.00 .0 60-0438-99-04 RESERVES, WATER SYSTEM R&M .00 .00 225,000.00 225,000.00 .0 60-0438-99-05 RESERVES, VEHICLE REPLACEMENT .00 .00 24,000.00 24,000.00 .0 60-0438-99-06 RESERVES, IDENTIFIED PROJECTS .00 .00 120,000.00 120,000.00 .0 TOTAL CAPITAL EXPENDITURES 197,524.85 267,651.62 1,649,610.00 1,381,958.38 16.2 TOTAL FUND EXPENDITURES 525,289.48 2,055,658.90 4,954,400.00 2,898,741.10 41.5 NET REVENUE OVER EXPENDITURES 304,191.89 2,040,531.68 .00 ( 2,040,531.68).0 CITY OF EAGLE BALANCE SHEET SEPTEMBER 30, 2024 FIBER FUND FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:19PM PAGE: 55 ASSETS 61-0101-00-00 CASH 261,960.38 61-0151-25-00 INVESTMENTS, FIBER SYSTEM 504,276.81 61-0166-00-00 MACHINERY AND EQUIPMENT 3,063,174.00 61-0171-00-00 DEFERRED OUTFLOWS-PENSION 28,742.00 TOTAL ASSETS 3,858,153.19 LIABILITIES AND EQUITY LIABILITIES 61-0202-00-00 VOUCHERS PAYABLE 24,083.81 61-0217-07-00 INSURANCE 5,271.49 61-0217-08-00 GARNISHMENTS 674.96 61-0217-09-00 WORKERS' COMPENSATION 3,048.37 61-0217-11-00 NET PENSION LIABILITY 72,649.00 TOTAL LIABILITIES 105,727.63 FUND EQUITY 61-0271-00-00 FUND BALANCE 4,444,473.58 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 692,048.02) BALANCE - CURRENT DATE ( 692,048.02) TOTAL FUND EQUITY 3,752,425.56 TOTAL LIABILITIES AND EQUITY 3,858,153.19 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 FIBER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:19PM PAGE: 56 REVENUE 61-0347-01-00 BILLING REVENUE .00 .00 204,000.00 204,000.00 .0 61-0347-02-00 OTHER REVENUE .00 .00 4,250.00 4,250.00 .0 61-0347-04-00 DELINQUENT FEES .00 .00 1,620.00 1,620.00 .0 61-0347-05-00 MISCELLANEOUS REVENUE .00 .00 100.00 100.00 .0 61-0347-06-00 EQUIPMENT RENTAL, INTERFUND .00 .00 10,000.00 10,000.00 .0 61-0347-90-00 BANK INTEREST .00 21,171.15 10,000.00 ( 11,171.15)211.7 61-0398-00-00 CARRY OVER, ARPA FUNDS .00 .00 1,593,580.00 1,593,580.00 .0 TOTAL FUND REVENUE .00 21,171.15 1,823,550.00 1,802,378.85 1.2 EXPENDITURES PERSONNEL 61-0433-10-00 SALARIES - FULL TIME 22,260.00 126,270.76 351,900.00 225,629.24 35.9 61-0433-10-02 ON-CALL TIME .00 .00 7,500.00 7,500.00 .0 61-0433-11-00 OVERTIME 1,146.49 7,880.63 7,500.00 ( 380.63)105.1 61-0433-21-00 FICA 1,768.61 10,320.00 27,500.00 17,180.00 37.5 61-0433-22-00 PERSI 2,767.30 15,360.92 42,100.00 26,739.08 36.5 61-0433-23-00 HRA BUY-DOWN .00 .00 1,540.00 1,540.00 .0 61-0433-23-01 HRA/COBRA ADMIN FEES .00 .00 300.00 300.00 .0 61-0433-24-00 WORKERS' COMPENSATION .00 1,345.26 8,000.00 6,654.74 16.8 61-0433-25-00 INSURANCE 3,398.47 17,085.11 53,500.00 36,414.89 31.9 61-0433-26-00 HSA CONTRIBUTION 75.00 275.00 2,400.00 2,125.00 11.5 61-0433-29-00 PTO CASH OUT .00 2,000.00 1,000.00 ( 1,000.00)200.0 TOTAL PERSONNEL 31,415.87 180,537.68 503,240.00 322,702.32 35.9 OPERATIONS & MAINTENANCE 61-0434-15-00 OFFICE SUPPLIES .00 .00 500.00 500.00 .0 61-0434-19-00 TELECOMMUNICATIONS 491.66 1,393.98 2,500.00 1,106.02 55.8 61-0434-20-00 ADVERTISING - PUBLICATIONS .00 .00 5,000.00 5,000.00 .0 61-0434-22-00 TRAVEL-MTNGS-EDUCATION .00 .00 15,000.00 15,000.00 .0 61-0434-23-00 DUES & SUBSCRIPTIONS .00 .00 500.00 500.00 .0 61-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE .00 145.85 2,500.00 2,354.15 5.8 61-0434-26-00 TOOLS, EQUIPMENT AND SUPPLIES 50.39 6,981.05 12,500.00 5,518.95 55.9 61-0434-26-01 EQUIPMENT RENTAL .00 .00 5,000.00 5,000.00 .0 61-0434-27-00 POSTAGE .00 .00 500.00 500.00 .0 61-0434-41-00 LIABILITY INSURANCE .00 5,000.00 7,500.00 2,500.00 66.7 61-0434-42-00 ENGINEERING SERVICES 70,072.06 170,643.30 150,000.00 ( 20,643.30)113.8 61-0434-42-01 LEGAL SERVICES 1,330.00 4,660.00 10,000.00 5,340.00 46.6 61-0434-43-00 TRAFFIC CONTROL .00 55.00 200,000.00 199,945.00 .0 61-0434-44-00 DIG LINE .00 .00 2,500.00 2,500.00 .0 61-0434-45-00 CITY AUDITOR SERVICES .00 1,000.00 3,000.00 2,000.00 33.3 61-0434-47-00 MAIL SERVICE-CUSTOMER BILLING .00 .00 5,000.00 5,000.00 .0 61-0434-50-00 CITY SHOP UPGRADES, SV .00 .00 10,000.00 10,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING SEPTEMBER 30, 2024 FIBER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 100 % OF THE FISCAL YEAR HAS ELAPSED 10/28/2024 01:19PM PAGE: 57 61-0434-50-01 SHOP UTILITIES 738.64 1,105.46 7,500.00 6,394.54 14.7 61-0434-53-03 PERMITS AND FEES .00 .00 2,500.00 2,500.00 .0 61-0434-55-00 CASELLE SUPPORT .00 .00 1,500.00 1,500.00 .0 61-0434-56-00 GAS AND OIL 1,409.93 4,437.68 10,000.00 5,562.32 44.4 61-0434-57-00 REPAIR AND MAINT, VEHICLE 467.42 3,255.78 25,000.00 21,744.22 13.0 61-0434-58-00 REPAIR AND MAINT, GROUND WORK .00 .00 50,000.00 50,000.00 .0 61-0434-58-01 REPAIR AND MAINT, EQUIPMENT 366.52 12,332.94 50,000.00 37,667.06 24.7 61-0434-58-02 REPAIR AND MAINT, BUILDINGS .00 222.11 .00 ( 222.11).0 61-0434-59-00 REPAIR AND MAINT, EMERGENCIES .00 .00 75,000.00 75,000.00 .0 61-0434-59-01 MATERIALS 41,330.20 315,321.95 425,000.00 109,678.05 74.2 61-0434-60-00 UTILITIES .00 1,174.06 .00 ( 1,174.06).0 61-0434-68-00 UNIFORMS AND SAFETY CLOTHING .00 140.33 2,000.00 1,859.67 7.0 61-0434-69-00 CITY HALL ADMIN OVERHEAD 1,203.00 4,812.00 4,810.00 ( 2.00)100.0 61-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 .00 20,000.00 20,000.00 .0 TOTAL OPERATIONS & MAINTENANCE 117,459.82 532,681.49 1,105,310.00 572,628.51 48.2 CAPITAL EXPENDITURES 61-0438-01-00 EQUIPMENT .00 .00 15,000.00 15,000.00 .0 61-0438-11-00 CAPITAL CONSTRUCTION PROJECTS .00 .00 200,000.00 200,000.00 .0 TOTAL CAPITAL EXPENDITURES .00 .00 215,000.00 215,000.00 .0 TOTAL FUND EXPENDITURES 148,875.69 713,219.17 1,823,550.00 1,110,330.83 39.1 NET REVENUE OVER EXPENDITURES ( 148,875.69)( 692,048.02).00 692,048.02 .0