Loading...
Finance - Quarterly Reports - FY 23/24 1st Quarter - 12/31/2023CITY OF EAGLE TREASURER'S REPORT FOR THE QUARTER ENDING DECEMBER 31, 2023 BEGINNING CASH ANNUAL %ANNUAL %CHANGE IN ENDING CASH FUND NUMBER AND TITLE BALANCE REVENUES REALIZED EXPENDITURES EXPENDED BALANCE SHEET BALANCE 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:26PM PAGE: 1 01 GENERAL FUND 1,060,562.22 2,342,490.02 10.92 3,303,242.55 15.40 ( 665,330.44)765,140.13 06 LIBRARY FUND 69,023.40 252,877.69 15.03 315,210.97 18.73 6,690.12 .00 07 MUSEUM FUND 21,245.60 10,515.64 5.33 17,691.48 8.96 642.41 13,427.35 08 PARK IMPACT FEE FUND 153,181.56 192,248.86 22.20 .00 .00 202,643.10 142,787.32 09 RECREATION - SPECIAL EVENTS 3,541.36 30,643.98 31.08 33,935.34 34.42 250.00 .00 11 EXECUTIVE DEPARTMENT .00 116,231.82 17.55 112,737.41 17.02 3,494.41 .00 12 CITY CLERK/TREAS DEPARTMENT 5,852.94 173,009.92 21.34 172,998.59 21.34 5,864.27 .00 13 BUILDING DEPARTMENT 61,292.32 188,395.16 17.63 214,940.05 20.11 34,747.43 .00 14 P&Z DEPARTMENT 9,142.05 252,531.38 19.61 249,539.95 19.37 12,133.48 .00 17 RECREATION - PARKS AND REC 4,447.68 215,823.56 22.72 208,605.25 21.96 11,665.99 .00 18 IT DEPARTMENT 27,533.29 195,617.07 16.24 210,230.38 17.45 12,919.98 .00 19 CAPITAL PROJECTS FUND 195,145.19 361,980.02 3.20 490,082.74 4.33 ( 11,206.86)78,249.33 23 PUBLIC WORKS .00 594,643.06 20.00 514,215.27 17.29 80,427.79 .00 24 RECREATION - EAGLE FUN DAYS .00 3,000.00 1.71 10.00 .01 .00 2,990.00 25 PATHWAY IMPACT FEE FUND 51,440.88 32,165.06 14.39 .00 .00 50,767.56 32,838.38 27 LAW ENF DEV IMPACT FEES 14,190.64 13,013.09 8.24 .00 .00 16,186.61 11,017.12 60 WATER FUND 629,128.84 744,318.10 15.02 429,215.00 8.66 403,495.26 540,736.68 61 FIBER FUND 208,836.52 9,443.57 .52 208,057.00 11.41 ( 78,536.74)88,759.83 99 COMBINED CASH FUND ( 2,514,564.49).00 .00 .00 .00 ( 838,618.35) ( 1,675,946.14) TOTAL .00 5,728,948.00 6,480,711.98 ( 751,763.98).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, January 16, 2024 CITY OF EAGLE COMBINED CASH INVESTMENT DECEMBER 31, 2023 FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 1 COMBINED CASH ACCOUNTS 99-0103-00-00 CASH IN CHECKING 1,224,800.36 99-0108-00-00 CASH CLEARING-ACCOUNTS REC 451,145.78 TOTAL COMBINED CASH 1,675,946.14 99-0101-00-00 CASH ALLOCATED TO OTHER FUNDS ( 1,675,946.14) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 765,140.13 7 ALLOCATION TO MUSEUM FUND 13,427.35 8 ALLOCATION TO PARK IMPACT FEE FUND 142,787.32 19 ALLOCATION TO CAPITAL PROJECTS FUND 78,249.33 24 ALLOCATION TO RECREATION - EAGLE FUN DAYS 2,990.00 25 ALLOCATION TO PATHWAY IMPACT FEE FUND 32,838.38 27 ALLOCATION TO LAW ENF DEV IMPACT FEES 11,017.12 60 ALLOCATION TO WATER FUND 540,736.68 61 ALLOCATION TO FIBER FUND 88,759.83 TOTAL ALLOCATIONS TO OTHER FUNDS 1,675,946.14 ALLOCATION FROM COMBINED CASH FUND - 99-0101-00-00 ( 1,675,946.14) ZERO PROOF IF ALLOCATIONS BALANCE .00 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 GENERAL FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 2 ASSETS 01-0101-00-00 CASH 765,140.13 01-0103-00-00 PETTY CASH 200.00 01-0107-00-00 TAXES RECEIVABLE DELINQUENT 22,574.55 01-0115-00-00 ACCOUNTS RECEIVABLE 51,936.65 01-0132-00-00 DUE FROM OTHER GOVERNMNTL UNTS 922,768.40 01-0151-25-00 INVESTMENTS 7,006,425.63 01-0151-28-00 ICCU CD 53,096.47 01-0151-30-00 ITD, AVIMOR, FEE INVESTMENTS 29,950.64 01-0170-00-00 HRA 10 % DEPOSIT 5,785.92 TOTAL ASSETS 8,857,878.39 LIABILITIES AND EQUITY LIABILITIES 01-0202-00-00 VOUCHERS PAYABLE ( 1,796.70) 01-0203-00-00 ACCTS PAYABLE-ACHD IMPACT FEES 73,353.00 01-0203-01-01 BONDS/SURETIES/DEPOSITS PYBLE 977,735.30 01-0203-01-02 FIREWORKS BOND DEPOSIT PAYABLE ( 2,000.00) 01-0203-01-03 VENDORS BOND DEPOSITS PAYABLE 5,562.25 01-0203-01-05 P&Z DEPOSITS PAYABLE 500,182.01 01-0203-01-06 LAND USE DEPOSITS PAYABLE 53,096.47 01-0217-07-00 INSURANCE ( 10,779.13) 01-0217-07-01 COBRA INSURANCE ( 2,520.41) 01-0217-09-00 WORKERS' COMPENSATION 5.52 01-0220-02-00 ITD, AVIMOR, DEPOSITS 29,950.64 01-0226-00-00 DEFERRED REVENUE 20,335.95 TOTAL LIABILITIES 1,643,124.90 FUND EQUITY 01-0271-00-00 FUND BALANCE 8,175,506.02 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 960,752.53) BALANCE - CURRENT DATE ( 960,752.53) TOTAL FUND EQUITY 7,214,753.49 TOTAL LIABILITIES AND EQUITY 8,857,878.39 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 3 REVENUE 01-0311-00-00 PROPERTY TAX 3,524.64 3,524.64 4,762,920.00 4,759,395.36 .1 01-0311-01-00 PENALTY/INTEREST ON TAXES 336.13 336.13 4,500.00 4,163.87 7.5 01-0312-00-00 PERSONAL PROPERTY TAX REIMBURS .00 .00 8,463.00 8,463.00 .0 01-0316-10-02 FRANCHISE FEE, VEOLIA 11,219.89 11,219.89 30,000.00 18,780.11 37.4 01-0316-11-00 FRANCHISE FEE, INTERMTN GAS 42,316.43 42,316.43 350,000.00 307,683.57 12.1 01-0316-12-00 FRANCHISE FEE, CABLE TV 22,959.84 22,959.84 115,000.00 92,040.16 20.0 01-0316-13-00 FRANCHISE FEE, SOLID WASTE 90,510.07 90,510.07 350,000.00 259,489.93 25.9 01-0316-14-00 FRANCHISE FEE, IDAHO POWER 92,615.77 92,615.77 250,000.00 157,384.23 37.1 01-0321-10-00 BUSINESS, ALCOHOL, MISC-LCNSES 3,931.68 3,931.68 56,500.00 52,568.32 7.0 01-0322-10-00 BUILDING & INSPECTION PERMITS 377,537.87 377,537.87 1,025,000.00 647,462.13 36.8 01-0322-12-00 BUILDING, PLAN REVIEW FEES 143,093.61 143,093.61 478,750.00 335,656.39 29.9 01-0322-13-00 ENERGY STANDARDS (IRES)5,450.00 5,450.00 12,500.00 7,050.00 43.6 01-0322-14-00 ELECTRICAL PERMIT FEES 65,456.92 65,456.92 200,000.00 134,543.08 32.7 01-0322-15-00 PLUMBING PERMIT FEES 56,060.36 56,060.36 184,000.00 127,939.64 30.5 01-0322-16-00 MECHANICAL PERMIT FEES 58,851.15 58,851.15 184,000.00 125,148.85 32.0 01-0322-20-00 ADMIN FEES, FIRE & ITD AVIMOR 2,100.00 2,100.00 5,000.00 2,900.00 42.0 01-0323-01-00 PZ ANNEX/ZONING PERMIT FEES 81,092.93 81,092.93 85,000.00 3,907.07 95.4 01-0323-02-00 PLANNING INSPECTION FEES 5,450.00 5,450.00 5,000.00 ( 450.00)109.0 01-0323-03-00 PLANNING, PLAN REVIEW FEES 7,250.00 7,250.00 20,000.00 12,750.00 36.3 01-0323-04-00 STREET LIGHT INSPECTION FEES 730.00 730.00 800.00 70.00 91.3 01-0323-05-00 SURETY/LETTER OF CREDIT FEES 2,250.00 2,250.00 4,000.00 1,750.00 56.3 01-0323-06-00 GRADING-DRAINAGE PERMIT FEES 1,181.25 1,181.25 6,000.00 4,818.75 19.7 01-0323-10-00 SPRING VALLEY STAFF TIME REIMB 1,732.50 1,732.50 10,000.00 8,267.50 17.3 01-0323-11-00 AVIMOR STAFF TIME REIMBURSE 819.00 819.00 10,000.00 9,181.00 8.2 01-0335-10-00 STATE, LIQUOR .00 .00 665,000.00 665,000.00 .0 01-0335-50-00 STATE, SALES TAX - AG REPL 4.75 4.75 19.00 14.25 25.0 01-0335-60-00 STATE, REVENUE SHARING 915,147.42 915,147.42 3,914,826.00 2,999,678.58 23.4 01-0338-40-00 COURT FEES 19,931.11 19,931.11 55,000.00 35,068.89 36.2 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 4,445.50 4,445.50 12,000.00 7,554.50 37.1 01-0341-13-00 ENGINEERING FEES - DEVELOPERS 83,781.80 83,781.80 175,000.00 91,218.20 47.9 01-0341-14-00 ATTORNEY FEES - DEVELOPERS 7,945.00 7,945.00 30,000.00 22,055.00 26.5 01-0341-17-00 CID STAFF & MISC REIMBURSEMENT 1,383.28 1,383.28 .00 ( 1,383.28).0 01-0341-20-00 REIMBURSE FROM WATER DEPT 3,009.00 3,009.00 13,410.00 10,401.00 22.4 01-0341-20-01 REIMBURSE FROM FIBER DEPT 1,203.00 1,203.00 5,000.00 3,797.00 24.1 01-0341-26-00 BACKGROUND CHECKS 99.75 99.75 1,500.00 1,400.25 6.7 01-0341-27-00 URA CITY STAFF REIMBURSEMENT .00 .00 3,000.00 3,000.00 .0 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 .00 1,000.00 1,000.00 .0 01-0350-02-00 IDAHO OPIOID SETTLEMENT 606.30 606.30 15,000.00 14,393.70 4.0 01-0350-05-00 FIELD OF HONOR .00 .00 25,000.00 25,000.00 .0 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 93,428.72 93,428.72 25,000.00 ( 68,428.72)373.7 01-0379-00-00 MISCELLANEOUS REVENUE 5,762.36 5,762.36 1,000.00 ( 4,762.36)576.2 01-0379-01-00 DUPLICATION/PUBLISHING/PRINTNG .00 .00 500.00 500.00 .0 01-0383-05-00 MISCELLANEOUS-REIMBURSEABLES 1,629.81 1,629.81 1,500.00 ( 129.81)108.7 01-0383-09-00 ROOM RESERVATIONS 2,305.86 2,305.86 4,000.00 1,694.14 57.7 01-0383-16-00 INSURANCE REIMBURSEABLES 398.00 398.00 .00 ( 398.00).0 01-0385-00-00 FIRE DEPT IMPACT FEES 124,938.32 124,938.32 224,250.00 99,311.68 55.7 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 4 01-0399-00-00 CARRY OVER .00 .00 8,103,480.00 8,103,480.00 .0 TOTAL FUND REVENUE 2,342,490.02 2,342,490.02 21,443,538.00 19,101,047.98 10.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM 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 650.00 4,300.00 3,650.00 15.1 01-0413-02-00 DESIGN REVIEW BRD COMPENSATION 400.00 400.00 5,000.00 4,600.00 8.0 01-0413-05-00 OFFICE SUPPLIES 3,733.58 3,733.58 25,000.00 21,266.42 14.9 01-0413-06-00 PRINTING & DISTRIBUTION .00 .00 500.00 500.00 .0 01-0413-07-00 POSTAGE 1,159.94 1,159.94 12,500.00 11,340.06 9.3 01-0413-08-00 LEGAL ADVERTISING/PUBLICATION 918.37 918.37 5,000.00 4,081.63 18.4 01-0413-10-00 INSURANCE - PROPERTY 72,658.00 72,658.00 82,000.00 9,342.00 88.6 01-0413-12-00 PERSONNEL TRAINING .00 .00 3,000.00 3,000.00 .0 01-0413-13-00 TRAVEL & PER DIEM .00 .00 2,000.00 2,000.00 .0 01-0413-14-00 PROFESSIONAL DUES AND SERVICES 35,693.10 35,693.10 153,000.00 117,306.90 23.3 01-0413-25-00 MISCELLANEOUS ( 10.31)( 10.31)20,000.00 20,010.31 ( .1) 01-0413-28-00 RESOURCE MATERIALS .00 .00 6,500.00 6,500.00 .0 01-0413-29-00 REAL PROPERTY TAXES - CITY 339.50 339.50 400.00 60.50 84.9 01-0413-31-00 ENGINEERING FEES - DEVELOPERS 51,855.35 51,855.35 175,000.00 123,144.65 29.6 01-0413-33-00 ATTORNEY FEES - DEVELOPERS 2,065.00 2,065.00 30,000.00 27,935.00 6.9 01-0413-37-00 BACKGROUND CHECK-PERMITS/LIC 199.50 199.50 2,500.00 2,300.50 8.0 01-0413-44-00 PHOTOS - MAYOR/CITY COUNCIL .00 .00 900.00 900.00 .0 01-0413-50-00 JOB POSTINGS .00 .00 2,500.00 2,500.00 .0 01-0413-51-00 BACKGROUND CHK, PRE-EMPLOYMENT 53.25 53.25 1,000.00 946.75 5.3 01-0413-52-00 DRUG TESTING, PRE-EMPLOYMENT 210.00 210.00 1,000.00 790.00 21.0 TOTAL ADMINISTRATION 169,925.28 169,925.28 532,100.00 362,174.72 31.9 PERSONNEL 01-0415-11-00 SALARIES - COUNCIL 12,720.00 12,720.00 65,000.00 52,280.00 19.6 01-0415-21-00 FICA 973.08 973.08 5,000.00 4,026.92 19.5 01-0415-22-00 PERSI 1,422.12 1,422.12 7,775.00 6,352.88 18.3 01-0415-23-01 HRA/COBRA ADMIN FEES 245.60 245.60 1,800.00 1,554.40 13.6 01-0415-24-00 WORKERS' COMPENSATION 66,871.91 66,871.91 68,000.00 1,128.09 98.3 01-0415-24-01 WORK COMP/BOARDS-COMMISSIONS 108.32 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 82,341.03 82,341.03 153,275.00 70,933.97 53.7 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 6 CONTRACTS & AGREEMENTS 01-0416-02-00 CITY ATTORNEY 32,592.50 32,592.50 250,000.00 217,407.50 13.0 01-0416-05-00 PROSECUTOR - ADA, BOISE, GEM 32,239.59 32,239.59 129,000.00 96,760.41 25.0 01-0416-06-00 IDAHO HUMANE SOCIETY 42,927.51 42,927.51 171,800.00 128,872.49 25.0 01-0416-07-00 CITY ENGINEERING .00 .00 20,000.00 20,000.00 .0 01-0416-08-00 CITY AUDITOR SERVICES .00 .00 22,300.00 22,300.00 .0 01-0416-09-00 LAW ENFORCEMENT DEPARTMENT 755,701.66 755,701.66 4,232,000.00 3,476,298.34 17.9 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 4,437.25 17,800.00 13,362.75 24.9 01-0416-49-00 DRUGFREE IDAHO 451.13 451.13 2,000.00 1,548.87 22.6 01-0416-54-00 IDAHO SUICIDE PREVENTION .00 .00 10,000.00 10,000.00 .0 01-0416-56-00 CRIME STOPPERS .00 .00 3,520.00 3,520.00 .0 TOTAL CONTRACTS & AGREEMENTS 868,349.64 868,349.64 6,458,420.00 5,590,070.36 13.5 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 .00 .00 25,000.00 25,000.00 .0 01-0422-15-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 TOTAL RESTRICTED .00 .00 44,000.00 44,000.00 .0 PUBLIC AFFAIRS/COMM RELATIONS 01-0462-01-00 PUBLIC RELATIONS 639.58 639.58 6,000.00 5,360.42 10.7 01-0462-02-00 AWARDS & RECOGNITIONS 89.90 89.90 1,500.00 1,410.10 6.0 TOTAL PUBLIC AFFAIRS/COMM RELATIONS 729.48 729.48 7,500.00 6,770.52 9.7 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 7 GENERAL FUND TRANSFERS 01-0463-01-00 MUSEUM DEPT TRANSFER 10,515.64 10,515.64 180,610.00 170,094.36 5.8 01-0463-05-00 SPECIAL EVENTS TRANSFER 26,751.22 26,751.22 38,075.00 11,323.78 70.3 01-0463-06-00 RECREATION PARKS-REC TRANSFER 164,192.55 164,192.55 807,120.00 642,927.45 20.3 01-0463-07-00 CAPITAL PROJECTS TRANSFER .00 .00 2,998,200.00 2,998,200.00 .0 01-0463-08-00 EAGLE FUN DAYS TRANSFER .00 .00 126,400.00 126,400.00 .0 01-0463-11-00 PUBLIC WORKS TRANSFER 594,643.06 594,643.06 2,884,511.00 2,289,867.94 20.6 01-0463-11-01 EXECUTIVE DEPT TRANSFER 116,231.82 116,231.82 662,430.00 546,198.18 17.6 01-0463-12-00 CITY HALL BOND FUND TRANSFER .00 .00 104,750.00 104,750.00 .0 01-0463-12-01 CLERK/TREAS DEPT TRANSFER 173,009.92 173,009.92 810,700.00 637,690.08 21.3 01-0463-13-01 BUILDING DEPT TRANSFER 188,395.16 188,395.16 1,068,860.00 880,464.84 17.6 01-0463-14-01 PLANNING AND ZONING DEPT TRANS 252,531.38 252,531.38 1,288,000.00 1,035,468.62 19.6 01-0463-15-00 LIBRARY TRANSFER 244,169.98 244,169.98 1,672,392.00 1,428,222.02 14.6 01-0463-18-01 IT DEPT TRANSFER 195,617.07 195,617.07 1,204,530.00 1,008,912.93 16.2 TOTAL GENERAL FUND TRANSFERS 1,966,057.80 1,966,057.80 13,846,578.00 11,880,520.20 14.2 COMMUNITY PROJECTS-CAP OUTLAY 01-0468-10-00 VALLEY REGIONAL TRANSIT SERV 129,162.00 129,162.00 129,200.00 38.00 100.0 TOTAL COMMUNITY PROJECTS-CAP OUTLA 129,162.00 129,162.00 129,200.00 38.00 100.0 FIRE DEPARTMENT IMPACT FEES 01-0469-00-00 FIRE DEPT IMPACT FEES 86,677.32 86,677.32 224,250.00 137,572.68 38.7 TOTAL FIRE DEPARTMENT IMPACT FEES 86,677.32 86,677.32 224,250.00 137,572.68 38.7 TOTAL FUND EXPENDITURES 3,303,242.55 3,303,242.55 21,443,538.00 18,140,295.45 15.4 NET REVENUE OVER EXPENDITURES ( 960,752.53)( 960,752.53).00 960,752.53 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 LIBRARY FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM 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 46.07 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 19,133.00 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 65,281.28 FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 62,333.28) BALANCE - CURRENT DATE ( 62,333.28) TOTAL FUND EQUITY ( 62,333.28) TOTAL LIABILITIES AND EQUITY 2,948.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 9 REVENUE 06-0301-00-00 FUNDING FROM GENERAL FUND 244,169.98 244,169.98 1,672,392.00 1,428,222.02 14.6 06-0361-20-00 LIBRARY, FINES, FEES 707.04 707.04 1,000.00 292.96 70.7 06-0361-20-01 LOST ITEMS 1,889.98 1,889.98 2,500.00 610.02 75.6 06-0361-21-00 LIBRARY COPY MACHINE 616.36 616.36 1,200.00 583.64 51.4 06-0361-21-01 3 D PRINTING 1.61 1.61 .00 ( 1.61).0 06-0379-00-00 MISCELLANEOUS REVENUE 456.00 456.00 750.00 294.00 60.8 06-0379-01-00 MISCELLANEOUS REV NON TAXABLE 36.72 36.72 .00 ( 36.72).0 06-0380-03-00 SPONSORSHIPS 5,000.00 5,000.00 5,000.00 .00 100.0 TOTAL FUND REVENUE 252,877.69 252,877.69 1,682,842.00 1,429,964.31 15.0 EXPENDITURES CONTRACTS/AGREEMENTS 06-0416-01-00 LEGAL - CITY ATTORNEY 560.00 560.00 .00 ( 560.00).0 06-0416-02-00 PHOTOCOPIERS 2,090.43 2,090.43 13,000.00 10,909.57 16.1 TOTAL CONTRACTS/AGREEMENTS 2,650.43 2,650.43 13,000.00 10,349.57 20.4 OPERATIONS & MAINTENANCE 06-0420-01-00 ADMINISTRATION 2,280.91 2,280.91 15,000.00 12,719.09 15.2 06-0420-04-00 MARKETING 739.51 739.51 19,000.00 18,260.49 3.9 06-0420-04-01 OUTREACH 4,905.94 4,905.94 5,000.00 94.06 98.1 06-0420-05-00 OFFICE SUPPLIES 1,467.53 1,467.53 9,100.00 7,632.47 16.1 06-0420-05-01 MATERIAL PROCESSING SUPPLIES 678.47 678.47 5,000.00 4,321.53 13.6 06-0420-06-00 UNIFORMS 537.16 537.16 4,650.00 4,112.84 11.6 06-0420-07-00 SMALL FURNITURE REPLACEMENT .00 .00 2,000.00 2,000.00 .0 06-0420-10-00 POSTAGE 796.06 796.06 2,500.00 1,703.94 31.8 06-0420-11-00 SUBSCRIPTIONS & MEMBERSHIPS 256.81 256.81 5,100.00 4,843.19 5.0 06-0420-13-00 PRINTING AND PUBLISHING .00 .00 1,200.00 1,200.00 .0 TOTAL OPERATIONS & MAINTENANCE 11,662.39 11,662.39 68,550.00 56,887.61 17.0 LYNX1 CONSORTIUM 06-0430-00-00 LYNX! SYSTEM .00 .00 26,750.00 26,750.00 .0 06-0430-02-00 LYNX! COURIER 3,636.59 3,636.59 16,900.00 13,263.41 21.5 TOTAL LYNX1 CONSORTIUM 3,636.59 3,636.59 43,650.00 40,013.41 8.3 COST RECOVERY OR PASS THRU 06-0435-00-00 CREDIT CARD PROCESSING FEE 613.29 613.29 3,200.00 2,586.71 19.2 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 10 06-0435-02-00 LOST ITEMS REFUNDS .00 .00 300.00 300.00 .0 06-0435-03-00 OPEN ACCESS 184.21 184.21 2,200.00 2,015.79 8.4 TOTAL COST RECOVERY OR PASS THRU 797.50 797.50 5,700.00 4,902.50 14.0 TECHNOLOGY 06-0440-01-00 COMPUTER MAINTENANCE & REPAIR .00 .00 3,000.00 3,000.00 .0 06-0440-02-00 COMPUTER EQUIPMENT (SMALL)38.10 38.10 3,500.00 3,461.90 1.1 TOTAL TECHNOLOGY 38.10 38.10 6,500.00 6,461.90 .6 GUEST RESOURCES 06-0450-00-00 BOOKS 32,492.66 32,492.66 158,500.00 126,007.34 20.5 06-0450-01-00 PRINT VENDOR PROCESSING 1,690.51 1,690.51 9,000.00 7,309.49 18.8 06-0450-02-00 BOOKS -DIGITAL 6,317.65 6,317.65 85,000.00 78,682.35 7.4 06-0450-03-00 MAGAZINES & NEWSPAPERS .00 .00 3,750.00 3,750.00 .0 06-0450-03-01 MAGAZINES - DIGITAL 6,300.00 6,300.00 16,750.00 10,450.00 37.6 06-0450-04-00 MEDIA 6,647.22 6,647.22 81,000.00 74,352.78 8.2 06-0450-05-00 MEDIA - DIGITAL 19,886.91 19,886.91 67,000.00 47,113.09 29.7 06-0450-06-00 DATABASES 4,547.00 4,547.00 16,800.00 12,253.00 27.1 06-0450-07-00 HOTSPOT 418.14 418.14 3,200.00 2,781.86 13.1 06-0450-08-00 FAMILY PLACE SPACE .00 .00 10,000.00 10,000.00 .0 TOTAL GUEST RESOURCES 78,300.09 78,300.09 451,000.00 372,699.91 17.4 GUEST CLASSES & EVENTS 06-0455-00-00 CLASSES & EVENTS 2,564.39 2,564.39 25,000.00 22,435.61 10.3 TOTAL GUEST CLASSES & EVENTS 2,564.39 2,564.39 25,000.00 22,435.61 10.3 PERSONNEL 06-0461-10-00 SALARIES - FULL TIME 124,021.38 124,021.38 539,500.00 415,478.62 23.0 06-0461-10-01 SALARIES - PERSONNEL SERVICES 13,834.93 13,834.93 .00 ( 13,834.93).0 06-0461-11-00 OVERTIME 413.86 413.86 5,000.00 4,586.14 8.3 06-0461-15-00 SALARIES - PART TIME 20,884.32 20,884.32 216,500.00 195,615.68 9.7 06-0461-15-01 SALARIES - PERSONNEL SERVICES 2,697.04 2,697.04 .00 ( 2,697.04).0 06-0461-21-00 FICA 11,000.30 11,000.30 58,500.00 47,499.70 18.8 06-0461-22-00 PERSI 13,911.86 13,911.86 64,700.00 50,788.14 21.5 06-0461-23-00 HRA BUY-DOWN 1,481.35 1,481.35 5,500.00 4,018.65 26.9 06-0461-23-01 HRA/COBRA ADMIN FEES 195.20 195.20 900.00 704.80 21.7 06-0461-24-00 WORKERS' COMPENSATION 705.58 705.58 1,792.00 1,086.42 39.4 06-0461-25-00 INSURANCE 14,213.73 14,213.73 103,500.00 89,286.27 13.7 06-0461-26-00 HSA CONTRIBUTION 300.00 300.00 1,200.00 900.00 25.0 06-0461-27-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 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 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 11 TOTAL PERSONNEL 203,659.55 203,659.55 1,013,092.00 809,432.45 20.1 STAFF DEVELOPMENT 06-0463-00-00 TRAVEL & PER DIEM 392.96 392.96 1,000.00 607.04 39.3 06-0463-01-00 MILEAGE REIMBURSEMENT 73.47 73.47 1,100.00 1,026.53 6.7 06-0463-02-00 TRAINING .00 .00 2,100.00 2,100.00 .0 06-0463-03-00 CONTINUING EDUCATION 4,757.00 4,757.00 12,500.00 7,743.00 38.1 06-0463-08-00 VIRTUAL TRAINING .00 .00 1,500.00 1,500.00 .0 TOTAL STAFF DEVELOPMENT 5,223.43 5,223.43 18,200.00 12,976.57 28.7 FACILITY (BLDGS & GROUNDS) 06-0464-00-00 BUILDING .00 .00 1,500.00 1,500.00 .0 06-0464-01-00 BUILDING SUPPLIES 800.59 800.59 1,500.00 699.41 53.4 06-0464-02-00 UTILITIES 5,339.85 5,339.85 28,300.00 22,960.15 18.9 06-0464-03-00 TELEPHONE 82.78 82.78 1,000.00 917.22 8.3 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 455.28 455.28 1,850.00 1,394.72 24.6 TOTAL FACILITY (BLDGS & GROUNDS)6,678.50 6,678.50 38,150.00 31,471.50 17.5 TOTAL FUND EXPENDITURES 315,210.97 315,210.97 1,682,842.00 1,367,631.03 18.7 NET REVENUE OVER EXPENDITURES ( 62,333.28)( 62,333.28).00 62,333.28 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 MUSEUM FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 12 ASSETS 07-0101-00-00 CASH 13,427.35 TOTAL ASSETS 13,427.35 LIABILITIES AND EQUITY LIABILITIES 07-0217-03-00 FICA 246.54 07-0217-04-00 PERSI RETIREMENT 240.94 07-0217-07-00 INSURANCE 52.24 07-0217-09-00 WORKERS' COMPENSATION 1,603.16 TOTAL LIABILITIES 2,142.88 FUND EQUITY 07-0271-00-00 MUSEUM FUND BALANCE 18,460.31 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 7,175.84) BALANCE - CURRENT DATE ( 7,175.84) TOTAL FUND EQUITY 11,284.47 TOTAL LIABILITIES AND EQUITY 13,427.35 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 13 REVENUE 07-0316-12-00 FUNDING FROM GENERAL FUND 10,515.64 10,515.64 180,610.00 170,094.36 5.8 07-0333-01-00 GRANTS, STATE .00 .00 16,000.00 16,000.00 .0 07-0376-00-00 CONTRIBUTIONS AND DONATIONS .00 .00 500.00 500.00 .0 07-0379-00-00 MISCELLANEOUS REVENUE .00 .00 50.00 50.00 .0 07-0379-02-00 ARCADIA BOOKS SALES/ROYALTIES .00 .00 200.00 200.00 .0 07-0379-03-00 SALES TAX REVENUE .00 .00 5.00 5.00 .0 TOTAL FUND REVENUE 10,515.64 10,515.64 197,365.00 186,849.36 5.3 EXPENDITURES PERSONNEL 07-0420-10-00 SALARIES - FULL TIME 13,304.98 13,304.98 103,500.00 90,195.02 12.9 07-0420-15-00 SALARIES - PART TIME .00 .00 20,000.00 20,000.00 .0 07-0420-21-00 FICA 1,017.84 1,017.84 9,600.00 8,582.16 10.6 07-0420-22-00 PERSI 1,487.49 1,487.49 12,450.00 10,962.51 12.0 07-0420-24-00 WORKERS' COMPENSATION 3.44 3.44 .00 ( 3.44).0 07-0420-25-00 INSURANCE 1,425.54 1,425.54 6,500.00 5,074.46 21.9 07-0420-27-00 HRA BUY DOWN .00 .00 1,540.00 1,540.00 .0 TOTAL PERSONNEL 17,239.29 17,239.29 153,590.00 136,350.71 11.2 EDUCATION 07-0461-02-00 ASSOCIATION MEMBERSHIP .00 .00 325.00 325.00 .0 07-0461-03-00 CONFERENCES & SEMINARS .00 .00 500.00 500.00 .0 07-0461-04-00 TRAVEL & PER DIEM .00 .00 750.00 750.00 .0 TOTAL EDUCATION .00 .00 1,575.00 1,575.00 .0 ADMINISTRATION 07-0462-30-00 CONSERVATION AND PRESERVATION .00 .00 200.00 200.00 .0 07-0462-31-00 OFFICE SUPPLIES 136.26 136.26 750.00 613.74 18.2 07-0462-32-00 ARCHIVAL SUPPLIES .00 .00 1,000.00 1,000.00 .0 07-0462-33-00 PUBLICITY-PRINTING .00 .00 350.00 350.00 .0 07-0462-34-00 RESEARCH MATERIAL .00 .00 500.00 500.00 .0 07-0462-35-00 UNIFORMS .00 .00 300.00 300.00 .0 07-0462-68-00 MUSEUM PROGRAMS 95.64 95.64 1,500.00 1,404.36 6.4 07-0462-69-00 MISCELLANEOUS 4.37 4.37 3,000.00 2,995.63 .2 07-0462-73-00 EAGLE BOOK-ARCADIA PUBLISHING .00 .00 300.00 300.00 .0 TOTAL ADMINISTRATION 236.27 236.27 7,900.00 7,663.73 3.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 MUSEUM FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 14 EXHIBITS 07-0463-01-00 DISPLAY SUPPLIES 140.00 140.00 300.00 160.00 46.7 07-0463-02-00 EXHIBIT ITEMS .00 .00 100.00 100.00 .0 07-0463-03-00 EXHIBIT CONSTRUCTION .00 .00 1,000.00 1,000.00 .0 07-0463-04-00 ANNUAL EXHIBIT 75.92 75.92 10,000.00 9,924.08 .8 TOTAL EXHIBITS 215.92 215.92 11,400.00 11,184.08 1.9 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 HISTORIC PRESERVATION 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 17,691.48 17,691.48 197,365.00 179,673.52 9.0 NET REVENUE OVER EXPENDITURES ( 7,175.84)( 7,175.84).00 7,175.84 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 PARK IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 15 ASSETS 08-0101-00-00 CASH 142,787.32 08-0151-25-00 INVESTMENTS 454,086.36 TOTAL ASSETS 596,873.68 LIABILITIES AND EQUITY FUND EQUITY 08-0271-00-00 PARK FUND/FUND BALANCE 404,624.82 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 192,248.86 BALANCE - CURRENT DATE 192,248.86 TOTAL FUND EQUITY 596,873.68 TOTAL LIABILITIES AND EQUITY 596,873.68 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 PARK IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 16 REVENUE 08-0322-19-00 PARKS DEVELOPMENT IMPACT FEES 189,885.76 189,885.76 416,000.00 226,114.24 45.7 08-0322-20-00 PARKS DEV IMPACT FEES-VALNOVA .00 .00 104,000.00 104,000.00 .0 08-0371-25-00 BANK INTEREST 2,363.10 2,363.10 2,000.00 ( 363.10)118.2 08-0399-00-00 CARRY OVER .00 .00 343,900.00 343,900.00 .0 TOTAL FUND REVENUE 192,248.86 192,248.86 865,900.00 673,651.14 22.2 EXPENDITURES CAPITAL IMPROVEMENTS 08-0438-37-00 CAPITAL IMPROVEMENTS .00 .00 761,900.00 761,900.00 .0 08-0438-99-00 VALNOVA IMPACT FEE PAYMENTS .00 .00 104,000.00 104,000.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 .00 865,900.00 865,900.00 .0 TOTAL FUND EXPENDITURES .00 .00 865,900.00 865,900.00 .0 NET REVENUE OVER EXPENDITURES 192,248.86 192,248.86 .00 ( 192,248.86).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 RECREATION - SPECIAL EVENTS FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 17 LIABILITIES AND EQUITY LIABILITIES 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 37,462.74 FUND EQUITY 09-0271-00-00 FUND BALANCE ( 34,171.38) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 3,291.36) BALANCE - CURRENT DATE ( 3,291.36) TOTAL FUND EQUITY ( 37,462.74) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 18 REVENUE 09-0301-00-00 FUNDING FROM GENERAL FUND 26,751.22 26,751.22 38,075.00 11,323.78 70.3 09-0347-06-00 COUNTRY CHRISTMAS 767.92 767.92 2,750.00 1,982.08 27.9 09-0347-08-00 SATURDAY MARKET 405.53 405.53 22,500.00 22,094.47 1.8 09-0347-10-00 GAZEBO CONCERT SERIES .00 .00 825.00 825.00 .0 09-0347-11-00 HARVEST FEST MARKET 159.31 159.31 2,750.00 2,590.69 5.8 09-0376-12-00 MISCELLANEOUS REVENUE .00 .00 3,000.00 3,000.00 .0 09-0376-13-00 SPONSORSHIPS 2,360.00 2,360.00 25,000.00 22,640.00 9.4 09-0376-15-00 EVENT APPLICATION FEES 200.00 200.00 2,500.00 2,300.00 8.0 09-0376-17-00 SECURITY DEPOSIT .00 .00 1,200.00 1,200.00 .0 TOTAL FUND REVENUE 30,643.98 30,643.98 98,600.00 67,956.02 31.1 EXPENDITURES ADMINISTRATION 09-0463-11-00 OFFICE SUPPLIES .00 .00 800.00 800.00 .0 09-0463-12-00 PROMOTIONS 5,852.64 5,852.64 14,000.00 8,147.36 41.8 09-0463-19-00 TRAINING AND EDUCATION .00 .00 1,200.00 1,200.00 .0 09-0463-20-00 TRAVEL & PER DIEM .00 .00 4,000.00 4,000.00 .0 09-0463-21-00 PROFESSIONAL DUES .00 .00 3,000.00 3,000.00 .0 09-0463-22-00 UNIFORMS 614.95 614.95 1,500.00 885.05 41.0 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 29.98 29.98 700.00 670.02 4.3 TOTAL ADMINISTRATION 6,497.57 6,497.57 26,600.00 20,102.43 24.4 ACTIVITIES 09-0467-02-00 EAGLE SATURDAY MARKET 445.00 445.00 15,000.00 14,555.00 3.0 09-0467-03-00 COUNTRY CHRISTMAS 14,786.23 14,786.23 18,000.00 3,213.77 82.2 09-0467-04-00 GAZEBO CONCERT SERIES .00 .00 10,000.00 10,000.00 .0 09-0467-05-00 GENERAL EVENTS 160.00 160.00 10,000.00 9,840.00 1.6 09-0467-06-00 EAGLE HARVEST FEST 3,473.96 3,473.96 6,000.00 2,526.04 57.9 09-0467-07-00 HALLOWEEN 8,238.77 8,238.77 10,000.00 1,761.23 82.4 09-0467-19-00 EVENT EQUIPMENT PURCHASES 333.81 333.81 3,000.00 2,666.19 11.1 TOTAL ACTIVITIES 27,437.77 27,437.77 72,000.00 44,562.23 38.1 TOTAL FUND EXPENDITURES 33,935.34 33,935.34 98,600.00 64,664.66 34.4 NET REVENUE OVER EXPENDITURES ( 3,291.36)( 3,291.36).00 3,291.36 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 EXECUTIVE DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 19 LIABILITIES AND EQUITY LIABILITIES 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 ( 4,102.98) 11-0217-09-00 WORKERS' COMPENSATION 11,801.13 11-0217-10-00 HSA CONTRIBUTION ( 224.00) TOTAL LIABILITIES 10,352.71 FUND EQUITY 11-0271-00-00 FUND BALANCE ( 13,847.12) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 3,494.41 BALANCE - CURRENT DATE 3,494.41 TOTAL FUND EQUITY ( 10,352.71) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 20 REVENUE 11-0301-00-00 FUNDING FROM GENERAL FUND 116,231.82 116,231.82 662,430.00 546,198.18 17.6 TOTAL FUND REVENUE 116,231.82 116,231.82 662,430.00 546,198.18 17.6 EXPENDITURES ADMINISTRATION 11-0413-04-00 UNIFORMS 93.75 93.75 500.00 406.25 18.8 11-0413-05-00 OFFICE SUPPLIES .00 .00 750.00 750.00 .0 11-0413-12-00 PERSONNEL TRAINING .00 .00 5,000.00 5,000.00 .0 11-0413-13-00 TRAVEL & PER DIEM 68.90 68.90 5,000.00 4,931.10 1.4 11-0413-14-00 PROFESSIONAL DUES 767.00 767.00 3,500.00 2,733.00 21.9 11-0413-20-00 MARKETING .00 .00 20,000.00 20,000.00 .0 TOTAL ADMINISTRATION 929.65 929.65 34,750.00 33,820.35 2.7 PERSONNEL 11-0415-10-00 SALARIES - FULL TIME 85,376.89 85,376.89 345,800.00 260,423.11 24.7 11-0415-11-00 OVERTIME 138.65 138.65 1,000.00 861.35 13.9 11-0415-21-00 FICA 6,290.55 6,290.55 26,500.00 20,209.45 23.7 11-0415-22-00 PERSI 9,560.61 9,560.61 41,400.00 31,839.39 23.1 11-0415-24-00 WORKERS' COMPENSATION 190.61 190.61 .00 ( 190.61).0 11-0415-25-00 INSURANCE 9,994.83 9,994.83 44,500.00 34,505.17 22.5 11-0415-26-00 HSA CONTRIBUTION .00 .00 1,200.00 1,200.00 .0 11-0415-27-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 11-0415-28-00 HRA BUY-DOWN .00 .00 3,080.00 3,080.00 .0 TOTAL PERSONNEL 111,552.14 111,552.14 468,480.00 356,927.86 23.8 STATE OF THE CITY 11-0417-01-00 STATE OF THE CITY .00 .00 4,200.00 4,200.00 .0 TOTAL STATE OF THE CITY .00 .00 4,200.00 4,200.00 .0 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 COMMUNITY & STAFF RELATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 EXECUTIVE DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 21 11-0422-01-00 COMMUNITY/STAFF RELATIONS 255.62 255.62 5,000.00 4,744.38 5.1 TOTAL COMMUNITY & STAFF RELATIONS 255.62 255.62 5,000.00 4,744.38 5.1 TOTAL FUND EXPENDITURES 112,737.41 112,737.41 662,430.00 549,692.59 17.0 NET REVENUE OVER EXPENDITURES 3,494.41 3,494.41 .00 ( 3,494.41).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 CITY CLERK/TREAS DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 22 LIABILITIES AND EQUITY LIABILITIES 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 790.95 12-0217-09-00 WORKERS' COMPENSATION 8,143.91 TOTAL LIABILITIES 19,569.43 FUND EQUITY 12-0271-00-00 FUND BALANCE ( 19,580.76) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 11.33 BALANCE - CURRENT DATE 11.33 TOTAL FUND EQUITY ( 19,569.43) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 CITY CLERK/TREAS DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 23 REVENUE 12-0301-00-00 FUNDING FROM GENERAL FUND 173,009.92 173,009.92 810,700.00 637,690.08 21.3 TOTAL FUND REVENUE 173,009.92 173,009.92 810,700.00 637,690.08 21.3 EXPENDITURES ADMINISTRATION 12-0413-05-00 OFFICE SUPPLIES 57.44 57.44 7,500.00 7,442.56 .8 12-0413-06-00 DUPLICATION/PUBLISHING/PRINT .00 .00 100.00 100.00 .0 12-0413-12-00 PERSONNEL TRAINING & RESOURCES 122.00 122.00 12,500.00 12,378.00 1.0 12-0413-13-00 TRAVEL & PER DIEM 683.67 683.67 7,500.00 6,816.33 9.1 12-0413-14-00 PROFESSIONAL DUES 350.00 350.00 5,500.00 5,150.00 6.4 12-0413-30-00 MISCELLANEOUS .00 .00 700.00 700.00 .0 TOTAL ADMINISTRATION 1,213.11 1,213.11 33,800.00 32,586.89 3.6 PERSONNEL 12-0415-10-00 SALARIES - FULL TIME 128,553.54 128,553.54 557,800.00 429,246.46 23.1 12-0415-11-00 OVERTIME 57.19 57.19 4,000.00 3,942.81 1.4 12-0415-21-00 FICA 9,659.12 9,659.12 42,700.00 33,040.88 22.6 12-0415-22-00 PERSI 14,561.44 14,561.44 66,800.00 52,238.56 21.8 12-0415-23-00 HRA BUY- DOWN 497.89 497.89 7,700.00 7,202.11 6.5 12-0415-23-02 HSA CONTRIBUTION 300.00 300.00 2,400.00 2,100.00 12.5 12-0415-24-00 WORKERS' COMPENSATION 25.09 25.09 .00 ( 25.09).0 12-0415-25-00 INSURANCE 16,496.21 16,496.21 85,500.00 69,003.79 19.3 12-0415-26-00 PTO CASH OUT 1,635.00 1,635.00 10,000.00 8,365.00 16.4 TOTAL PERSONNEL 171,785.48 171,785.48 776,900.00 605,114.52 22.1 TOTAL FUND EXPENDITURES 172,998.59 172,998.59 810,700.00 637,701.41 21.3 NET REVENUE OVER EXPENDITURES 11.33 11.33 .00 ( 11.33).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 BUILDING DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 24 ASSETS 13-0103-00-00 PETTY CASH 100.00 TOTAL ASSETS 100.00 LIABILITIES AND EQUITY LIABILITIES 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 4,925.97 13-0217-09-00 WORKERS' COMPENSATION 59,433.90 13-0217-10-00 HSA CONTRIBUTION ( 1,900.00) TOTAL LIABILITIES 70,945.80 FUND EQUITY 13-0271-00-00 FUND BALANCE ( 44,300.91) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 26,544.89) BALANCE - CURRENT DATE ( 26,544.89) TOTAL FUND EQUITY ( 70,845.80) TOTAL LIABILITIES AND EQUITY 100.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 25 REVENUE 13-0301-00-00 FUNDING FROM GENERAL FUND 188,395.16 188,395.16 1,068,860.00 880,464.84 17.6 TOTAL FUND REVENUE 188,395.16 188,395.16 1,068,860.00 880,464.84 17.6 EXPENDITURES ADMINISTRATION 13-0413-05-00 OFFICE SUPPLIES 253.18 253.18 6,500.00 6,246.82 3.9 13-0413-08-00 LEGAL ADS & PUBLICATIONS .00 .00 400.00 400.00 .0 13-0413-09-00 COMMERCIAL PLAN REVIEW 1,400.00 1,400.00 6,000.00 4,600.00 23.3 13-0413-12-00 TRAINING & CERTIFICATION RENEW .00 .00 4,500.00 4,500.00 .0 13-0413-13-00 TRAVEL & PER DIEM .00 .00 2,000.00 2,000.00 .0 13-0413-14-00 PROFESSIONAL DUES .00 .00 700.00 700.00 .0 13-0413-25-00 MISCELLANEOUS .00 .00 400.00 400.00 .0 13-0413-28-00 RESOURCE MATERIALS .00 .00 2,000.00 2,000.00 .0 13-0413-29-03 MECHANICAL FEE REFUND ( 65.00)( 65.00).00 65.00 .0 13-0413-29-05 ELECTRICAL PERMIT REFUND ( 65.00)( 65.00).00 65.00 .0 13-0413-30-00 UNIFORMS .00 .00 2,000.00 2,000.00 .0 TOTAL ADMINISTRATION 1,523.18 1,523.18 24,500.00 22,976.82 6.2 PERSONNEL 13-0415-10-00 SALARIES - FULL TIME 95,771.20 95,771.20 448,100.00 352,328.80 21.4 13-0415-11-00 OVERTIME .00 .00 4,000.00 4,000.00 .0 13-0415-21-00 FICA 7,107.04 7,107.04 34,500.00 27,392.96 20.6 13-0415-22-00 PERSI 10,707.27 10,707.27 53,600.00 42,892.73 20.0 13-0415-23-00 HRA BUY-DOWN .00 .00 6,160.00 6,160.00 .0 13-0415-24-00 WORKERS' COMPENSATION 449.47 449.47 .00 ( 449.47).0 13-0415-25-00 INSURANCE 15,811.06 15,811.06 92,300.00 76,488.94 17.1 13-0415-26-00 HSA CONTRIBUTION 300.00 300.00 1,200.00 900.00 25.0 13-0415-28-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 TOTAL PERSONNEL 130,146.04 130,146.04 644,860.00 514,713.96 20.2 CONTRACTS & AGREEMENTS 13-0416-09-00 PLUMBING INSPECTOR 24,864.94 24,864.94 110,000.00 85,135.06 22.6 13-0416-11-00 MECHANICAL INSPECTOR 22,509.95 22,509.95 110,000.00 87,490.05 20.5 13-0416-13-00 BLDG INSPECTOR 7,316.00 7,316.00 55,000.00 47,684.00 13.3 13-0416-14-00 PLAN REVIEW - CONTRACT .00 .00 4,000.00 4,000.00 .0 13-0416-25-00 ELECTRICAL INSPECTOR 28,413.41 28,413.41 120,000.00 91,586.59 23.7 TOTAL CONTRACTS & AGREEMENTS 83,104.30 83,104.30 399,000.00 315,895.70 20.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 BUILDING DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 26 VEHICLE OPERATIONS 13-0417-02-00 GAS AND OIL 166.53 166.53 500.00 333.47 33.3 TOTAL VEHICLE OPERATIONS 166.53 166.53 500.00 333.47 33.3 TOTAL FUND EXPENDITURES 214,940.05 214,940.05 1,068,860.00 853,919.95 20.1 NET REVENUE OVER EXPENDITURES ( 26,544.89)( 26,544.89).00 26,544.89 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 P&Z DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 27 LIABILITIES AND EQUITY LIABILITIES 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 ( 42,676.43) 14-0217-08-00 GARNISHMENTS 203.34 14-0217-09-00 WORKERS' COMPENSATION 83,714.36 TOTAL LIABILITIES 59,656.62 FUND EQUITY 14-0271-00-00 FUND BALANCE ( 62,648.05) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 2,991.43 BALANCE - CURRENT DATE 2,991.43 TOTAL FUND EQUITY ( 59,656.62) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:06PM PAGE: 28 REVENUE 14-0301-00-00 FUNDING FROM GENERAL FUND 252,531.38 252,531.38 1,288,000.00 1,035,468.62 19.6 TOTAL FUND REVENUE 252,531.38 252,531.38 1,288,000.00 1,035,468.62 19.6 EXPENDITURES ADMINISTRATION 14-0413-05-00 OFFICE SUPPLIES 250.06 250.06 1,300.00 1,049.94 19.2 14-0413-06-00 DUPLICATION/PUBLISHING/PRNTG .00 .00 1,000.00 1,000.00 .0 14-0413-08-00 LEGAL ADS & PUBLICATIONS 160.40 160.40 6,000.00 5,839.60 2.7 14-0413-12-00 PERSONNEL TRAINING 125.00 125.00 2,000.00 1,875.00 6.3 14-0413-13-00 TRAVEL & PER DIEM 294.98 294.98 500.00 205.02 59.0 14-0413-14-00 PROFESSIONAL DUES .00 .00 3,300.00 3,300.00 .0 14-0413-25-00 MISCELLANEOUS 334.30 334.30 500.00 165.70 66.9 14-0413-26-00 REIMBURSE-ANNEX/ZONING/DR FEES .00 .00 2,000.00 2,000.00 .0 14-0413-28-00 RESOURCE MATERIALS .00 .00 500.00 500.00 .0 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 1,164.74 1,164.74 22,600.00 21,435.26 5.2 PERSONNEL 14-0415-10-00 SALARIES - FULL TIME 173,906.48 173,906.48 890,500.00 716,593.52 19.5 14-0415-10-01 SALARIES - PERSONNEL SERVICES 18,944.64 18,944.64 .00 ( 18,944.64).0 14-0415-11-00 OVERTIME 363.59 363.59 13,000.00 12,636.41 2.8 14-0415-21-00 FICA 12,949.39 12,949.39 69,800.00 56,850.61 18.6 14-0415-22-00 PERSI 19,295.70 19,295.70 108,900.00 89,604.30 17.7 14-0415-24-00 WORKERS' COMPENSATION 377.53 377.53 .00 ( 377.53).0 14-0415-25-00 INSURANCE 22,349.79 22,349.79 143,500.00 121,150.21 15.6 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 .00 7,700.00 7,700.00 .0 TOTAL PERSONNEL 248,187.12 248,187.12 1,244,600.00 996,412.88 19.9 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 3 MONTHS ENDING DECEMBER 31, 2023 P&Z DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM 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 188.09 188.09 600.00 411.91 31.4 TOTAL CAPITAL OUTLAY 188.09 188.09 600.00 411.91 31.4 COMMUNITY PLANNING PROJECTS 14-0468-11-00 OTHER .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 249,539.95 249,539.95 1,288,000.00 1,038,460.05 19.4 NET REVENUE OVER EXPENDITURES 2,991.43 2,991.43 .00 ( 2,991.43).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 RECREATION - PARKS AND REC FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 30 ASSETS 17-0103-00-00 PETTY CASH 150.00 TOTAL ASSETS 150.00 LIABILITIES AND EQUITY LIABILITIES 17-0217-03-00 FICA 1,637.19 17-0217-04-00 PERSI RETIREMENT 1,079.92 17-0217-07-00 INSURANCE ( 21,782.12) 17-0217-09-00 WORKERS' COMPENSATION 52,333.44 17-0217-10-00 HSA CONTRIBUTION ( 4,225.93) TOTAL LIABILITIES 29,042.50 FUND EQUITY 17-0271-00-00 FUND BALANCE ( 36,110.81) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 7,218.31 BALANCE - CURRENT DATE 7,218.31 TOTAL FUND EQUITY ( 28,892.50) TOTAL LIABILITIES AND EQUITY 150.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 RECREATION - PARKS AND REC PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 31 REVENUE 17-0301-00-00 FUNDING FROM GENERAL FUND 164,192.55 164,192.55 807,120.00 642,927.45 20.3 17-0302-00-00 REGIST- SPORTS, CAMPS, CLASSES 49,679.46 49,679.46 112,000.00 62,320.54 44.4 17-0302-01-00 SPONSORSHIPS .00 .00 10,000.00 10,000.00 .0 17-0302-03-00 PARK RESERVATION FEES 1,265.55 1,265.55 20,000.00 18,734.45 6.3 17-0302-04-00 SENIOR CENTER FEES 675.00 675.00 .00 ( 675.00).0 17-0304-00-00 MISC SALES, EAGLE ARTS 11.00 11.00 .00 ( 11.00).0 17-0399-00-00 CARRY OVER .00 .00 1,000.00 1,000.00 .0 TOTAL FUND REVENUE 215,823.56 215,823.56 950,120.00 734,296.44 22.7 EXPENDITURES CONTRACTS 17-0416-00-00 CONTRACT-PERMITS,CAMPS/CLASSES 2,092.75 2,092.75 20,000.00 17,907.25 10.5 17-0416-01-00 CONTRACT-PERMITS, TEAM SPORTS 15,252.60 15,252.60 10,000.00 ( 5,252.60)152.5 TOTAL CONTRACTS 17,345.35 17,345.35 30,000.00 12,654.65 57.8 PERSONNEL 17-0420-10-00 SALARIES - FULL TIME 114,888.25 114,888.25 495,000.00 380,111.75 23.2 17-0420-10-01 SALARIES - PERSONNEL SERVICES 7,250.47 7,250.47 20,000.00 12,749.53 36.3 17-0420-11-00 SALARIES - SEASONAL 922.89 922.89 .00 ( 922.89).0 17-0420-18-00 OVERTIME .00 .00 4,000.00 4,000.00 .0 17-0420-21-00 FICA 8,963.69 8,963.69 38,300.00 29,336.31 23.4 17-0420-22-00 PERSI 13,343.41 13,343.41 59,700.00 46,356.59 22.4 17-0420-23-00 HRA BUY-DOWN .00 .00 4,620.00 4,620.00 .0 17-0420-24-00 WORKERS' COMPENSATION 756.30 756.30 .00 ( 756.30).0 17-0420-25-00 INSURANCE 14,798.62 14,798.62 86,000.00 71,201.38 17.2 17-0420-26-00 HSA CONTRIBUTION 600.00 600.00 2,400.00 1,800.00 25.0 17-0420-27-00 PTO CASH OUT 3,540.00 3,540.00 5,000.00 1,460.00 70.8 TOTAL PERSONNEL 165,063.63 165,063.63 715,020.00 549,956.37 23.1 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 17-0422-01-00 OFFICE SUPPLIES 34.61 34.61 2,000.00 1,965.39 1.7 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 32 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 .00 .00 1,000.00 1,000.00 .0 17-0422-04-00 GAS AND OIL .00 .00 1,000.00 1,000.00 .0 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 .00 .00 2,000.00 2,000.00 .0 17-0422-08-00 TRAINING AND EDUCATION .00 .00 3,000.00 3,000.00 .0 17-0422-09-00 TRAVEL & PER DIEM .00 .00 5,000.00 5,000.00 .0 17-0422-10-00 BACKGROUND CHECKS 888.80 888.80 8,000.00 7,111.20 11.1 17-0422-11-00 REFUNDS-PARK REC PROGRAMS .00 .00 4,000.00 4,000.00 .0 TOTAL ADMINISTRATION 923.41 923.41 31,800.00 30,876.59 2.9 RECREATION 17-0423-00-00 REC SUPPLIES-CAMPS & CLASSES 382.79 382.79 10,000.00 9,617.21 3.8 17-0423-00-01 REC SUPPLIES-TEAM SPORTS 1,448.21 1,448.21 20,000.00 18,551.79 7.2 17-0423-01-00 UNIFORMS, TEAM SPORTS 4,096.93 4,096.93 15,000.00 10,903.07 27.3 17-0423-02-00 FIELD TRIPS .00 .00 20,000.00 20,000.00 .0 17-0423-04-00 TRANSPORTATION SERVICES .00 .00 15,000.00 15,000.00 .0 17-0423-05-00 DADDY DAUGHTER DANCE .00 .00 2,000.00 2,000.00 .0 17-0423-07-00 GLOW IN THE PARK ( 5.40)( 5.40).00 5.40 .0 17-0423-08-00 HALLOWEEN TRICK-OR-TREAT .00 .00 800.00 800.00 .0 17-0423-09-00 VETERAN'S BREAKFAST 665.72 665.72 1,500.00 834.28 44.4 17-0423-10-00 MOTHER-SON MONSTER MASH 2,118.07 2,118.07 2,000.00 ( 118.07)105.9 17-0423-11-00 SENIOR CENTER 2,658.04 2,658.04 10,000.00 7,341.96 26.6 17-0423-12-00 EAGLE ARTS ADVISORY COMMITTEE 13,815.03 13,815.03 50,000.00 36,184.97 27.6 17-0423-20-00 NEW PROGRAMS .00 .00 5,000.00 5,000.00 .0 TOTAL RECREATION 25,179.39 25,179.39 151,300.00 126,120.61 16.6 VEHICLES 17-0424-03-00 GAS AND OIL 93.47 93.47 1,000.00 906.53 9.4 TOTAL VEHICLES 93.47 93.47 1,000.00 906.53 9.4 CAPITAL EQUIPMENT 17-0425-00-00 REC EQUIPMENT-TEAM SPORTS .00 .00 15,000.00 15,000.00 .0 17-0425-01-00 REC EQUIPMENT-CAMPS/CLASSES .00 .00 3,000.00 3,000.00 .0 TOTAL CAPITAL EQUIPMENT .00 .00 18,000.00 18,000.00 .0 CAPITAL OUTLAY 17-0460-02-00 FURNITURE .00 .00 2,000.00 2,000.00 .0 TOTAL CAPITAL OUTLAY .00 .00 2,000.00 2,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 33 TOTAL FUND EXPENDITURES 208,605.25 208,605.25 950,120.00 741,514.75 22.0 NET REVENUE OVER EXPENDITURES 7,218.31 7,218.31 .00 ( 7,218.31).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 IT DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 34 LIABILITIES AND EQUITY LIABILITIES 18-0217-03-00 FICA 555.58 18-0217-04-00 PERSI RETIREMENT 936.81 18-0217-07-00 INSURANCE ( 29,840.66) 18-0217-09-00 WORKERS' COMPENSATION 2,324.64 18-0217-10-00 HSA CONTRIBUTION 820.00 TOTAL LIABILITIES ( 25,203.63) FUND EQUITY 18-0271-00-00 FUND BALANCE 39,816.94 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 14,613.31) BALANCE - CURRENT DATE ( 14,613.31) TOTAL FUND EQUITY 25,203.63 TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 35 REVENUE 18-0301-00-00 FUNDING FROM GENERAL FUND 195,617.07 195,617.07 1,204,530.00 1,008,912.93 16.2 TOTAL FUND REVENUE 195,617.07 195,617.07 1,204,530.00 1,008,912.93 16.2 EXPENDITURES ADMINISTRATION 18-0413-01-00 OFFICE SUPPLIES .00 .00 1,000.00 1,000.00 .0 18-0413-02-00 SUPPLIES .00 .00 4,000.00 4,000.00 .0 18-0413-03-00 TRAINING AND EDUCATION .00 .00 8,000.00 8,000.00 .0 18-0413-04-00 TRAVEL & PER DIEM .00 .00 7,000.00 7,000.00 .0 18-0413-05-00 PROFESSIONAL DUES .00 .00 750.00 750.00 .0 TOTAL ADMINISTRATION .00 .00 20,750.00 20,750.00 .0 PERSONNEL 18-0415-10-00 SALARIES - FULL TIME 70,083.49 70,083.49 329,500.00 259,416.51 21.3 18-0415-11-00 IT DEPT/OVERTIME 531.56 531.56 5,000.00 4,468.44 10.6 18-0415-21-00 FICA 5,227.35 5,227.35 25,800.00 20,572.65 20.3 18-0415-22-00 PERSI 7,671.98 7,671.98 40,200.00 32,528.02 19.1 18-0415-23-00 HRA BUY- DOWN .00 .00 3,080.00 3,080.00 .0 18-0415-24-00 WORKERS' COMPENSATION 18.82 18.82 .00 ( 18.82).0 18-0415-25-00 INSURANCE 4,990.25 4,990.25 58,500.00 53,509.75 8.5 18-0415-26-00 HSA CONTRIBUTION 250.00 250.00 1,200.00 950.00 20.8 18-0415-27-00 PTO CASH OUT .00 .00 2,500.00 2,500.00 .0 TOTAL PERSONNEL 88,773.45 88,773.45 465,780.00 377,006.55 19.1 CONTRACT & AGREEMENTS 18-0416-01-00 CONTRACT AND AGREEMENTS 77,119.69 77,119.69 453,000.00 375,880.31 17.0 TOTAL CONTRACT & AGREEMENTS 77,119.69 77,119.69 453,000.00 375,880.31 17.0 INTERNET/PHONE SERVICES 18-0417-01-00 INTERNET & PHONE SERVICES 21,379.46 21,379.46 89,000.00 67,620.54 24.0 TOTAL INTERNET/PHONE SERVICES 21,379.46 21,379.46 89,000.00 67,620.54 24.0 OPERATIONAL RESERVES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 IT DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 36 18-0418-01-00 IT EQUIPMENT/SOFTWARE .00 .00 55,000.00 55,000.00 .0 TOTAL OPERATIONAL RESERVES .00 .00 55,000.00 55,000.00 .0 CAPITAL OUTLAY 18-0419-01-00 FURNITURE .00 .00 1,000.00 1,000.00 .0 18-0419-02-00 EQUIPMENT 15,301.78 15,301.78 65,000.00 49,698.22 23.5 18-0419-03-00 SOFTWARE PURCHASES 7,656.00 7,656.00 40,000.00 32,344.00 19.1 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 22,957.78 22,957.78 121,000.00 98,042.22 19.0 TOTAL FUND EXPENDITURES 210,230.38 210,230.38 1,204,530.00 994,299.62 17.5 NET REVENUE OVER EXPENDITURES ( 14,613.31)( 14,613.31).00 14,613.31 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 CAPITAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 37 ASSETS 19-0101-00-00 CASH 78,249.33 19-0151-25-00 INVESTMENTS 5,865,949.97 TOTAL ASSETS 5,944,199.30 LIABILITIES AND EQUITY LIABILITIES 19-0225-00-00 UNEARNED GRANT REVENUE, ARPA 941,148.64 TOTAL LIABILITIES 941,148.64 FUND EQUITY 19-0271-00-00 FUND BALANCE 5,131,153.38 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 128,102.72) BALANCE - CURRENT DATE ( 128,102.72) TOTAL FUND EQUITY 5,003,050.66 TOTAL LIABILITIES AND EQUITY 5,944,199.30 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 38 REVENUE 19-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 2,998,200.00 2,998,200.00 .0 19-0301-05-00 EAGLE RD PED/BIKE BRIDGE 293,832.40 293,832.40 28,000.00 ( 265,832.40)1049.4 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 68,147.62 68,147.62 15,000.00 ( 53,147.62)454.3 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 361,980.02 361,980.02 11,326,220.00 10,964,239.98 3.2 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 201,295.90 201,295.90 2,146,700.00 1,945,404.10 9.4 TOTAL CAPITAL MAINTENANCE 201,295.90 201,295.90 2,146,700.00 1,945,404.10 9.4 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 43,005.23 43,005.23 2,545,000.00 2,501,994.77 1.7 TOTAL CITY CAPITAL PROJECTS 43,005.23 43,005.23 2,645,000.00 2,601,994.77 1.6 PZ CAPITAL PROJECTS 19-0466-03-00 AIKENS EXTENSION .00 .00 680,000.00 680,000.00 .0 19-0466-05-00 EAGLE RD PED/BIKE BRIDGE 6,611.28 6,611.28 30,000.00 23,388.72 22.0 19-0466-09-00 EAGLE-STATE ST INTERSECTION 12,842.75 12,842.75 1,010,309.00 997,466.25 1.3 19-0466-10-00 P&Z CAPITAL PROJECTS 12,925.00 12,925.00 400,000.00 387,075.00 3.2 TOTAL PZ CAPITAL PROJECTS 32,379.03 32,379.03 2,120,309.00 2,087,929.97 1.5 PARK CAPITAL PROJECTS 19-0467-02-00 PARK CAPITAL PROJECTS 167,161.97 167,161.97 537,000.00 369,838.03 31.1 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 CAPITAL PROJECTS FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 39 TOTAL PARK CAPITAL PROJECTS 167,161.97 167,161.97 537,000.00 369,838.03 31.1 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 31,310.20 31,310.20 140,000.00 108,689.80 22.4 19-0486-01-01 ARPA, SOFTWARE PURCHASES 14,930.41 14,930.41 .00 ( 14,930.41).0 TOTAL FEDERAL FUNDS PROJECTS 46,240.61 46,240.61 140,000.00 93,759.39 33.0 TOTAL FUND EXPENDITURES 490,082.74 490,082.74 11,326,220.00 10,836,137.26 4.3 NET REVENUE OVER EXPENDITURES ( 128,102.72)( 128,102.72).00 128,102.72 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 PUBLIC WORKS FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 40 LIABILITIES AND EQUITY LIABILITIES 23-0202-00-00 VOUCHERS PAYABLE ( 156.08) 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 ( 10,000.72) 23-0217-08-00 GARNISHMENTS ( 1,240.38) 23-0217-09-00 WORKERS' COMPENSATION 147,462.41 23-0217-10-00 HSA CONTRIBUTION ( 1,160.00) TOTAL LIABILITIES 137,686.77 FUND EQUITY 23-0271-00-00 FUND BALANCE ( 218,114.56) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 80,427.79 BALANCE - CURRENT DATE 80,427.79 TOTAL FUND EQUITY ( 137,686.77) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 41 REVENUE 23-0302-00-00 FUNDING FROM GENERAL FUND 594,643.06 594,643.06 2,884,511.00 2,289,867.94 20.6 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 .00 .00 22,291.00 22,291.00 .0 23-0315-09-00 WYCLIFF PUMP STATION .00 .00 10,500.00 10,500.00 .0 23-0316-00-00 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 23-0316-01-00 MEMORIAL DONATIONS .00 .00 6,000.00 6,000.00 .0 TOTAL FUND REVENUE 594,643.06 594,643.06 2,973,602.00 2,378,958.94 20.0 EXPENDITURES PERSONNEL 23-0433-10-00 SALARIES-FULL TIME 293,776.46 293,776.46 1,110,000.00 816,223.54 26.5 23-0433-10-01 SALARIES - PERSONNEL SERVICES .00 .00 125,000.00 125,000.00 .0 23-0433-11-00 OVERTIME 3,691.76 3,691.76 20,000.00 16,308.24 18.5 23-0433-16-00 SALARIES -SEASONAL 208.26 208.26 .00 ( 208.26).0 23-0433-21-00 FICA 22,418.02 22,418.02 87,500.00 65,081.98 25.6 23-0433-22-00 PERSI 33,452.79 33,452.79 135,500.00 102,047.21 24.7 23-0433-23-00 HRA BUY-DOWN .00 .00 7,700.00 7,700.00 .0 23-0433-24-00 WORKERS' COMPENSATION 1,588.64 1,588.64 .00 ( 1,588.64).0 23-0433-25-00 INSURANCE 45,302.85 45,302.85 227,500.00 182,197.15 19.9 23-0433-26-00 HSA CONTRIBUTION 1,500.00 1,500.00 4,800.00 3,300.00 31.3 23-0433-29-00 PTO CASH OUT 2,020.00 2,020.00 15,000.00 12,980.00 13.5 TOTAL PERSONNEL 403,958.78 403,958.78 1,733,000.00 1,329,041.22 23.3 ADMINISTRATION 23-0435-01-00 OFFICE SUPPLIES 78.34 78.34 1,000.00 921.66 7.8 23-0435-02-00 PRINT, PUBLISH, LEGAL, ADV .00 .00 5,000.00 5,000.00 .0 23-0435-03-00 TRAINING, EDUCATION, TRVL, ETC 621.95 621.95 20,000.00 19,378.05 3.1 23-0435-04-00 DUES, CERTIFICATIONS, LICENSES 95.00 95.00 1,000.00 905.00 9.5 23-0435-09-00 STAFF AND PUBLIC RELATIONS 298.40 298.40 2,500.00 2,201.60 11.9 23-0435-10-00 SAFETY CLOTHING AND GEAR 1,895.95 1,895.95 6,500.00 4,604.05 29.2 TOTAL ADMINISTRATION 2,989.64 2,989.64 36,000.00 33,010.36 8.3 IRRIGATION CONTRACTS/AGRMNTS 23-0437-01-00 WYCLIFFE PUMP STATION 784.33 784.33 6,690.00 5,905.67 11.7 23-0437-02-00 IRRIGATION SHARES AND DUES 1,065.35 1,065.35 20,000.00 18,934.65 5.3 23-0437-03-00 BASELINE MANAGER AGREEMENT .00 .00 4,500.00 4,500.00 .0 23-0437-04-00 CHAUMONT LEASE AGREEMENT .00 .00 1.00 1.00 .0 TOTAL IRRIGATION CONTRACTS/AGRMNTS 1,849.68 1,849.68 31,191.00 29,341.32 5.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 42 GENERAL MTNC & REPAIR 23-0439-02-00 MISC MTNC & REPAIR GROUNDS 2,258.70 2,258.70 45,000.00 42,741.30 5.0 23-0439-02-01 MISC MTNC & REPAIR EQUIPMENT 1,429.95 1,429.95 20,000.00 18,570.05 7.2 23-0439-02-02 MISC MTNC & REPAIR BUILDINGS 4,075.67 4,075.67 10,000.00 5,924.33 40.8 23-0439-02-03 EMERGENCY REPAIRS .00 .00 25,000.00 25,000.00 .0 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 1,587.76 1,587.76 50,000.00 48,412.24 3.2 23-0439-04-00 HOLIDAY LIGHTING 6,876.91 6,876.91 50,000.00 43,123.09 13.8 23-0439-05-00 CLEANING AND PAPER SUPPLIES 4,601.74 4,601.74 50,000.00 45,398.26 9.2 23-0439-06-00 SIGNS & SIGN REPLACEMENT .00 .00 5,000.00 5,000.00 .0 TOTAL GENERAL MTNC & REPAIR 20,830.73 20,830.73 305,000.00 284,169.27 6.8 VEHICLES 23-0441-01-00 VEHICLE MTNC & REPAIR 9,765.03 9,765.03 35,000.00 25,234.97 27.9 23-0441-02-00 FUEL 5,454.12 5,454.12 45,000.00 39,545.88 12.1 TOTAL VEHICLES 15,219.15 15,219.15 80,000.00 64,780.85 19.0 FACILITIES 23-0443-01-00 CITY HALL 17,227.48 17,227.48 57,200.00 39,972.52 30.1 23-0443-02-00 LIBRARY 926.00 926.00 16,000.00 15,074.00 5.8 23-0443-03-00 MUSEUM 299.00 299.00 2,500.00 2,201.00 12.0 23-0443-04-00 CITY SHOP 762.72 762.72 10,000.00 9,237.28 7.6 23-0443-04-01 CITY SHOP UPGRADES, SV 545.85 545.85 10,000.00 9,454.15 5.5 23-0443-05-00 SENIOR CENTER 10,284.44 10,284.44 10,000.00 ( 284.44)102.8 23-0443-06-00 JACKSON HOUSE 2,402.87 2,402.87 10,000.00 7,597.13 24.0 23-0443-07-00 LINDER ROAD RESTROOM 921.31 921.31 6,000.00 5,078.69 15.4 23-0443-15-00 STREET LIGHTS 6,594.58 6,594.58 43,000.00 36,405.42 15.3 TOTAL FACILITIES 39,964.25 39,964.25 164,700.00 124,735.75 24.3 PARKS, MONUMENTS & GROUNDS 23-0445-01-00 ADA-EAGLE SPORTS PARK 5,828.11 5,828.11 36,400.00 30,571.89 16.0 23-0445-02-00 ARBORETUM PARK .00 .00 2,000.00 2,000.00 .0 23-0445-03-00 SV REGIONAL SPORTS COMPLEX 78.00 78.00 10,000.00 9,922.00 .8 23-0445-04-00 FLAG PLAZA 29.57 29.57 1,000.00 970.43 3.0 23-0445-05-00 FRIENDSHIP PARK 1,059.94 1,059.94 6,000.00 4,940.06 17.7 23-0445-06-00 GUERBER PARK 716.56 716.56 30,000.00 29,283.44 2.4 23-0445-07-00 HERITAGE PARK 583.97 583.97 7,500.00 6,916.03 7.8 23-0445-08-00 MACE PARKING AREA .00 .00 5,000.00 5,000.00 .0 23-0445-09-00 MCDONALD'S PATHWAY 263.74 263.74 2,000.00 1,736.26 13.2 23-0445-10-00 MERRILL PARK 996.66 996.66 29,000.00 28,003.34 3.4 23-0445-11-00 ORVAL KRASEN PARK 1,528.13 1,528.13 4,500.00 2,971.87 34.0 23-0445-12-00 PAMELA BAKER PARK 260.51 260.51 11,000.00 10,739.49 2.4 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 3 MONTHS ENDING DECEMBER 31, 2023 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 43 23-0445-14-00 TRAILS 102.95 102.95 11,500.00 11,397.05 .9 23-0445-20-00 CITY ENTRANCE SIGNS 2,971.14 2,971.14 15,000.00 12,028.86 19.8 23-0445-30-00 LANDSCAPING, EQUIPMENT RENTAL 152.32 152.32 15,000.00 14,847.68 1.0 23-0445-30-01 LANDSCAPING, SPRAY/FERTILIZE 132.03 132.03 35,000.00 34,867.97 .4 23-0445-30-03 LANDSCAPING, DUMPING/DISPOSAL 446.08 446.08 5,000.00 4,553.92 8.9 TOTAL PARKS, MONUMENTS & GROUNDS 15,149.71 15,149.71 229,900.00 214,750.29 6.6 MEMORIALS AND PROGRAMS 23-0447-01-00 MEMORIALS, MTNC/REPAIR .00 .00 6,000.00 6,000.00 .0 23-0447-02-00 MATERIALS & SUPPLIES 243.05 243.05 1,000.00 756.95 24.3 23-0447-03-00 FLOWERS .00 .00 20,000.00 20,000.00 .0 23-0447-04-00 SANITATION AND RECYCLING 2,486.50 2,486.50 54,000.00 51,513.50 4.6 23-0447-05-00 TREES, PUBLIC DEVELOPMENT 11,387.35 11,387.35 29,511.00 18,123.65 38.6 23-0447-05-01 TREE VOUCHER PROGRAM .00 .00 15,000.00 15,000.00 .0 23-0447-05-02 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 TOTAL MEMORIALS AND PROGRAMS 14,116.90 14,116.90 125,811.00 111,694.10 11.2 FISCAL YEAR PROJECTS 23-0483-15-00 LANDSCAPE UPGRADES - PARKS .00 .00 25,000.00 25,000.00 .0 23-0483-20-01 TOOLS 136.43 136.43 5,000.00 4,863.57 2.7 23-0483-20-02 EQUIPMENT .00 .00 85,000.00 85,000.00 .0 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 136.43 136.43 268,000.00 267,863.57 .1 TOTAL FUND EXPENDITURES 514,215.27 514,215.27 2,973,602.00 2,459,386.73 17.3 NET REVENUE OVER EXPENDITURES 80,427.79 80,427.79 .00 ( 80,427.79).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 RECREATION - EAGLE FUN DAYS FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 44 ASSETS 24-0101-00-00 CASH 2,990.00 TOTAL ASSETS 2,990.00 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 2,990.00 BALANCE - CURRENT DATE 2,990.00 TOTAL FUND EQUITY 2,990.00 TOTAL LIABILITIES AND EQUITY 2,990.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 45 REVENUE 24-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 126,400.00 126,400.00 .0 24-0303-00-00 SPONSORSHIPS .00 .00 21,000.00 21,000.00 .0 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 .00 .00 7,000.00 7,000.00 .0 24-0303-05-00 ROCKY MOUNTAIN OYSTER FEED .00 .00 15,000.00 15,000.00 .0 24-0303-07-00 MISCELLANEOUS REVENUE 3,000.00 3,000.00 .00 ( 3,000.00).0 TOTAL FUND REVENUE 3,000.00 3,000.00 175,700.00 172,700.00 1.7 EXPENDITURES ADMIN EXPENDITURES 24-0401-01-00 FUN DAYS CONTRACTS .00 .00 60,000.00 60,000.00 .0 24-0401-04-00 ADVERTISEMENT .00 .00 10,000.00 10,000.00 .0 24-0401-06-00 SUPPLIES .00 .00 9,300.00 9,300.00 .0 24-0401-07-00 EQUIPMENT .00 .00 7,500.00 7,500.00 .0 TOTAL ADMIN EXPENDITURES .00 .00 86,800.00 86,800.00 .0 LOGISTICS 24-0410-00-00 PORTA POTTIES .00 .00 5,000.00 5,000.00 .0 24-0410-02-00 TRAFFIC BARRIERS & CONTROL .00 .00 22,000.00 22,000.00 .0 24-0410-03-00 GOLF CART RENTALS .00 .00 500.00 500.00 .0 24-0410-04-00 POLICE OVERTIME .00 .00 7,000.00 7,000.00 .0 24-0410-06-00 SIGNAGE .00 .00 5,000.00 5,000.00 .0 24-0410-07-00 SECURITY .00 .00 10,000.00 10,000.00 .0 TOTAL LOGISTICS .00 .00 49,500.00 49,500.00 .0 COMMUNITY EVENTS 24-0420-01-00 FUN RUN .00 .00 5,400.00 5,400.00 .0 24-0420-10-00 CAR SHOW 10.00 10.00 4,000.00 3,990.00 .3 TOTAL COMMUNITY EVENTS 10.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 .00 .00 10,000.00 10,000.00 .0 TOTAL ROCKY MOUNTAIN OYSTER FEED .00 .00 30,000.00 30,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 RECREATION - EAGLE FUN DAYS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 46 TOTAL FUND EXPENDITURES 10.00 10.00 175,700.00 175,690.00 .0 NET REVENUE OVER EXPENDITURES 2,990.00 2,990.00 .00 ( 2,990.00).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 PATHWAY IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 47 ASSETS 25-0101-00-00 CASH 32,838.38 25-0151-25-00 INVESTMENTS 141,621.52 TOTAL ASSETS 174,459.90 LIABILITIES AND EQUITY FUND EQUITY 25-0271-00-00 FUND BALANCE 142,294.84 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 32,165.06 BALANCE - CURRENT DATE 32,165.06 TOTAL FUND EQUITY 174,459.90 TOTAL LIABILITIES AND EQUITY 174,459.90 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 PATHWAY IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 48 REVENUE 25-0322-19-00 PATHWAY DEVELOPMENT IMPACT FEE 31,397.50 31,397.50 82,625.00 51,227.50 38.0 25-0371-25-00 BANK INTEREST 767.56 767.56 1,000.00 232.44 76.8 25-0399-00-00 CARRY OVER .00 .00 139,900.00 139,900.00 .0 TOTAL FUND REVENUE 32,165.06 32,165.06 223,525.00 191,359.94 14.4 EXPENDITURES CAPITAL IMPROVEMENTS 25-0438-00-00 CAPITAL IMPROVEMENTS .00 .00 213,525.00 213,525.00 .0 25-0438-34-00 IMPACT FEE UPDATE .00 .00 10,000.00 10,000.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 .00 223,525.00 223,525.00 .0 TOTAL FUND EXPENDITURES .00 .00 223,525.00 223,525.00 .0 NET REVENUE OVER EXPENDITURES 32,165.06 32,165.06 .00 ( 32,165.06).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 LAW ENF DEV IMPACT FEES FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 49 ASSETS 27-0101-00-00 CASH 11,017.12 27-0151-25-00 INVESTMENTS 118,193.58 TOTAL ASSETS 129,210.70 LIABILITIES AND EQUITY FUND EQUITY 27-0271-00-00 POLICE IMPACT FEE/FUND BALANCE 116,197.61 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 13,013.09 BALANCE - CURRENT DATE 13,013.09 TOTAL FUND EQUITY 129,210.70 TOTAL LIABILITIES AND EQUITY 129,210.70 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 LAW ENF DEV IMPACT FEES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 50 REVENUE 27-0322-19-00 RESIDENTIAL IMPACT FEES 11,826.48 11,826.48 27,750.00 15,923.52 42.6 27-0322-20-00 COMMERCIAL - IMPACT FEES .00 .00 30,000.00 30,000.00 .0 27-0371-25-00 BANK INTEREST 1,186.61 1,186.61 200.00 ( 986.61)593.3 27-0399-00-00 CARRY OVER .00 .00 100,000.00 100,000.00 .0 TOTAL FUND REVENUE 13,013.09 13,013.09 157,950.00 144,936.91 8.2 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 13,013.09 13,013.09 .00 ( 13,013.09).0 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 CITY HALL BOND FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 51 REVENUE 54-0399-01-00 FUNDING FROM GENERAL FUND .00 .00 104,750.00 104,750.00 .0 TOTAL FUND REVENUE .00 .00 104,750.00 104,750.00 .0 EXPENDITURES BOND PAYMENTS 54-0480-81-00 PRINCIPAL BOND PAYMENT .00 .00 90,000.00 90,000.00 .0 54-0480-82-00 INTEREST BOND PAYMENT .00 .00 14,250.00 14,250.00 .0 54-0480-84-00 PAYING AGENT FEE .00 .00 500.00 500.00 .0 TOTAL BOND PAYMENTS .00 .00 104,750.00 104,750.00 .0 TOTAL FUND EXPENDITURES .00 .00 104,750.00 104,750.00 .0 NET REVENUE OVER EXPENDITURES .00 .00 .00 .00 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 WATER FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 52 ASSETS 60-0101-00-00 CASH 540,736.68 60-0115-00-00 ACCOUNTS RECEIVABLE 118,096.40 60-0151-25-00 INVESTMENTS, WATER SYSTEM 6,523,031.07 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 20,575,750.23 LIABILITIES AND EQUITY LIABILITIES 60-0202-00-00 WATER/VOUCHERS PAYABLE ( 227.00) 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 6,817.93 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 87,600.00 60-0231-00-00 DEQ LOAN 118,942.00 TOTAL LIABILITIES 637,217.40 FUND EQUITY 60-0271-00-00 WATER/FUND BALANCE 19,623,429.73 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 315,103.10 BALANCE - CURRENT DATE 315,103.10 TOTAL FUND EQUITY 19,938,532.83 TOTAL LIABILITIES AND EQUITY 20,575,750.23 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 53 REVENUE 60-0346-59-00 STL-STORAGE & TRUNK LINE FEE 209,293.92 209,293.92 105,000.00 ( 104,293.92)199.3 60-0346-60-00 HOOK UP FEES CITY 73,590.00 73,590.00 172,050.00 98,460.00 42.8 60-0346-62-00 PROFESSIONAL SERV - DEVELOPERS 7,186.89 7,186.89 50,000.00 42,813.11 14.4 60-0346-63-00 STAFF TIME REIMB - DEVELOPERS 506.00 506.00 5,000.00 4,494.00 10.1 60-0347-01-00 BILLING REVENUE 357,120.55 357,120.55 1,322,000.00 964,879.45 27.0 60-0347-02-00 OTHER REVENUE 1,074.23 1,074.23 4,120.00 3,045.77 26.1 60-0347-03-00 RECONNECT FEES .00 .00 300.00 300.00 .0 60-0347-04-00 DELINQUENT FEES 2,556.00 2,556.00 12,000.00 9,444.00 21.3 60-0347-05-00 MISCELLANEOUS REVENUE 1,910.86 1,910.86 12,000.00 10,089.14 15.9 60-0347-06-00 SYSTEM ENHANCEMENT FEE 226.96 226.96 100,000.00 99,773.04 .2 60-0355-01-00 WCE-WATER CONST EQUIV FEE 19,600.00 19,600.00 20,000.00 400.00 98.0 60-0371-25-00 BANK INTEREST 71,252.69 71,252.69 10,000.00 ( 61,252.69)712.5 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 744,318.10 744,318.10 4,954,400.00 4,210,081.90 15.0 EXPENDITURES VEHICLE OPERATIONS - LEASES 60-0420-01-00 GAS AND OIL 1,362.49 1,362.49 15,000.00 13,637.51 9.1 60-0420-03-00 VEHICLE MTNC & REPAIR 985.30 985.30 10,000.00 9,014.70 9.9 TOTAL VEHICLE OPERATIONS - LEASES 2,347.79 2,347.79 25,000.00 22,652.21 9.4 PERSONNEL 60-0433-10-00 SALARIES - FULL TIME 100,406.48 100,406.48 426,500.00 326,093.52 23.5 60-0433-10-02 ON-CALL TIME 874.86 874.86 7,500.00 6,625.14 11.7 60-0433-11-00 OVERTIME 587.52 587.52 4,500.00 3,912.48 13.1 60-0433-21-00 FICA 7,618.32 7,618.32 33,500.00 25,881.68 22.7 60-0433-22-00 PERSI 11,388.85 11,388.85 52,500.00 41,111.15 21.7 60-0433-23-00 HRA BUY-DOWN .00 .00 3,080.00 3,080.00 .0 60-0433-23-01 HRA/COBRA ADMIN FEES .00 .00 400.00 400.00 .0 60-0433-24-00 WORKERS' COMPENSATION 10,339.20 10,339.20 17,500.00 7,160.80 59.1 60-0433-25-00 INSURANCE 11,888.14 11,888.14 59,310.00 47,421.86 20.0 60-0433-26-00 HSA CONTRIBUTION 600.00 600.00 2,400.00 1,800.00 25.0 60-0433-29-00 PTO CASH OUT .00 .00 10,000.00 10,000.00 .0 TOTAL PERSONNEL 143,703.37 143,703.37 617,190.00 473,486.63 23.3 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 54 OPERATIONS & MAINTENANCE 60-0434-15-00 OFFICE SUPPLIES 416.03 416.03 2,000.00 1,583.97 20.8 60-0434-19-00 TELECOMMUNICATIONS/SCADA 3,437.71 3,437.71 17,000.00 13,562.29 20.2 60-0434-20-00 ADVERTISING - PUBLICATIONS 294.66 294.66 1,500.00 1,205.34 19.6 60-0434-22-00 TRAVEL-MTNGS-EDUCATION 104.00 104.00 8,000.00 7,896.00 1.3 60-0434-23-00 DUES & SUBSCRIPTIONS 86.00 86.00 3,000.00 2,914.00 2.9 60-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE 6,442.71 6,442.71 8,000.00 1,557.29 80.5 60-0434-26-00 TOOLS, EQUIPMENT AND SUPPLIES ( 611.33)( 611.33)20,000.00 20,611.33 ( 3.1) 60-0434-26-01 EQUIPMENT RENTAL .00 .00 10,000.00 10,000.00 .0 60-0434-27-00 POSTAGE .00 .00 1,300.00 1,300.00 .0 60-0434-41-00 LIABILITY INSURANCE 4,000.00 4,000.00 5,900.00 1,900.00 67.8 60-0434-42-00 ENGINEERING SERVICES 4,651.75 4,651.75 35,000.00 30,348.25 13.3 60-0434-42-01 LEGAL SERVICES 507.50 507.50 25,000.00 24,492.50 2.0 60-0434-42-02 MISC LEGAL AND ENG SERVICES 2,009.50 2,009.50 100,000.00 97,990.50 2.0 60-0434-42-03 PROFESSIONAL SERV - DEVELOPERS 4,108.57 4,108.57 50,000.00 45,891.43 8.2 60-0434-43-01 CONTRACT SERVICES (REPAIR).00 .00 35,000.00 35,000.00 .0 60-0434-44-00 DIG LINE 859.51 859.51 4,500.00 3,640.49 19.1 60-0434-45-00 CITY AUDITOR SERVICES .00 .00 3,500.00 3,500.00 .0 60-0434-47-00 MAIL SERVICE-CUSTOMER BILLING 4,735.85 4,735.85 31,500.00 26,764.15 15.0 60-0434-50-01 SHOP UTILITIES 326.88 326.88 5,100.00 4,773.12 6.4 60-0434-53-01 PUBLIC WATER DRINKING FEES 13,332.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 493.61 493.61 40,000.00 39,506.39 1.2 60-0434-58-01 RPR/MTNC PUMPS-WELLS-CHEMICAL 232.90 232.90 40,000.00 39,767.10 .6 60-0434-59-00 CHEMICALS 442.55 442.55 13,500.00 13,057.45 3.3 60-0434-60-00 UTILITIES 7,059.65 7,059.65 110,000.00 102,940.35 6.4 60-0434-68-00 UNIFORMS AND SAFETY CLOTHING 341.98 341.98 2,300.00 1,958.02 14.9 60-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 .00 25,000.00 25,000.00 .0 TOTAL OPERATIONS & MAINTENANCE 53,272.03 53,272.03 617,600.00 564,327.97 8.6 TESTING-WK-MO-QTR-ANNUAL 60-0435-56-00 TESTING-WK-MO-QTR-ANNUAL 570.00 570.00 40,000.00 39,430.00 1.4 TOTAL TESTING-WK-MO-QTR-ANNUAL 570.00 570.00 40,000.00 39,430.00 1.4 DEQ REVOLVING LOAN PAYMENT 60-0436-01-00 DEQ/STATE REVOLVING LOAN PMT 121,208.65 121,208.65 100,000.00 ( 21,208.65)121.2 TOTAL DEQ REVOLVING LOAN PAYMENT 121,208.65 121,208.65 100,000.00 ( 21,208.65)121.2 STL FEES, RESTRICTED 60-0437-01-00 STL FEES, REIMB SYS EXPANSION 100,390.00 100,390.00 200,000.00 99,610.00 50.2 60-0437-03-00 STL FEES, REFUNDS .00 .00 50,000.00 50,000.00 .0 60-0437-05-01 CURRENT STL PROJECTS 4,714.16 4,714.16 400,000.00 395,285.84 1.2 60-0437-99-01 RESERVES, STL FEES .00 .00 1,255,000.00 1,255,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 55 TOTAL STL FEES, RESTRICTED 105,104.16 105,104.16 1,905,000.00 1,799,895.84 5.5 CAPITAL EXPENDITURES 60-0438-01-00 EQUIPMENT .00 .00 85,500.00 85,500.00 .0 60-0438-08-00 METER SETS, NEW CUSTOMERS .00 .00 99,200.00 99,200.00 .0 60-0438-11-00 CAPITAL CONSTRUCTION PROJECTS .00 .00 157,500.00 157,500.00 .0 60-0438-82-00 CITY HALL ADMIN OVERHEAD 3,009.00 3,009.00 13,410.00 10,401.00 22.4 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 3,009.00 3,009.00 1,649,610.00 1,646,601.00 .2 TOTAL FUND EXPENDITURES 429,215.00 429,215.00 4,954,400.00 4,525,185.00 8.7 NET REVENUE OVER EXPENDITURES 315,103.10 315,103.10 .00 ( 315,103.10).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2023 FIBER FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 56 ASSETS 61-0101-00-00 CASH 88,759.83 61-0151-25-00 INVESTMENTS, FIBER SYSTEM 1,140,682.05 61-0166-00-00 MACHINERY AND EQUIPMENT 3,063,174.00 61-0171-00-00 DEFERRED OUTFLOWS-PENSION 28,742.00 TOTAL ASSETS 4,321,357.88 LIABILITIES AND EQUITY LIABILITIES 61-0217-07-00 INSURANCE ( 381.36) 61-0217-08-00 GARNISHMENTS 181.72 61-0217-09-00 WORKERS' COMPENSATION 3,048.37 61-0217-11-00 NET PENSION LIABILITY 72,649.00 TOTAL LIABILITIES 75,497.73 FUND EQUITY 61-0271-00-00 FUND BALANCE 4,444,473.58 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 198,613.43) BALANCE - CURRENT DATE ( 198,613.43) TOTAL FUND EQUITY 4,245,860.15 TOTAL LIABILITIES AND EQUITY 4,321,357.88 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2023 FIBER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 57 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 9,443.57 9,443.57 10,000.00 556.43 94.4 61-0398-00-00 ARPA CARRY OVER .00 .00 1,593,580.00 1,593,580.00 .0 TOTAL FUND REVENUE 9,443.57 9,443.57 1,823,550.00 1,814,106.43 .5 EXPENDITURES PERSONNEL 61-0433-10-00 SALARIES - FULL TIME 39,970.00 39,970.00 351,900.00 311,930.00 11.4 61-0433-10-02 ON-CALL TIME .00 .00 7,500.00 7,500.00 .0 61-0433-11-00 OVERTIME 3,331.91 3,331.91 7,500.00 4,168.09 44.4 61-0433-21-00 FICA 3,282.57 3,282.57 27,500.00 24,217.43 11.9 61-0433-22-00 PERSI 4,841.09 4,841.09 42,100.00 37,258.91 11.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 1,345.26 1,345.26 8,000.00 6,654.74 16.8 61-0433-25-00 INSURANCE 4,222.96 4,222.96 53,500.00 49,277.04 7.9 61-0433-26-00 HSA CONTRIBUTION 50.00 50.00 2,400.00 2,350.00 2.1 61-0433-29-00 PTO CASH OUT .00 .00 1,000.00 1,000.00 .0 TOTAL PERSONNEL 57,043.79 57,043.79 503,240.00 446,196.21 11.3 OPERATIONS & MAINTENANCE 61-0434-15-00 OFFICE SUPPLIES .00 .00 500.00 500.00 .0 61-0434-19-00 TELECOMMUNICATIONS 328.36 328.36 2,500.00 2,171.64 13.1 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 .00 2,500.00 2,500.00 .0 61-0434-26-00 TOOLS, EQUIPMENT AND SUPPLIES 3,074.23 3,074.23 12,500.00 9,425.77 24.6 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 5,000.00 5,000.00 7,500.00 2,500.00 66.7 61-0434-42-00 ENGINEERING SERVICES 27,050.00 27,050.00 150,000.00 122,950.00 18.0 61-0434-42-01 LEGAL SERVICES 437.50 437.50 10,000.00 9,562.50 4.4 61-0434-43-00 TRAFFIC CONTROL .00 .00 200,000.00 200,000.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 .00 3,000.00 3,000.00 .0 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 3 MONTHS ENDING DECEMBER 31, 2023 FIBER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/16/2024 12:18PM PAGE: 58 61-0434-50-01 SHOP UTILITIES .00 .00 7,500.00 7,500.00 .0 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 462.45 462.45 10,000.00 9,537.55 4.6 61-0434-57-00 REPAIR AND MAINT, VEHICLE 1,430.85 1,430.85 25,000.00 23,569.15 5.7 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 6,563.15 6,563.15 50,000.00 43,436.85 13.1 61-0434-58-02 REPAIR AND MAINT, BUILDINGS 63.82 63.82 .00 ( 63.82).0 61-0434-59-00 REPAIR AND MAINT, EMERGENCIES .00 .00 75,000.00 75,000.00 .0 61-0434-59-01 MATERIALS 104,622.20 104,622.20 425,000.00 320,377.80 24.6 61-0434-60-00 UTILITIES 777.65 777.65 .00 ( 777.65).0 61-0434-68-00 UNIFORMS AND SAFETY CLOTHING .00 .00 2,000.00 2,000.00 .0 61-0434-69-00 CITY HALL ADMIN OVERHEAD 1,203.00 1,203.00 4,810.00 3,607.00 25.0 61-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 .00 20,000.00 20,000.00 .0 TOTAL OPERATIONS & MAINTENANCE 151,013.21 151,013.21 1,105,310.00 954,296.79 13.7 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 208,057.00 208,057.00 1,823,550.00 1,615,493.00 11.4 NET REVENUE OVER EXPENDITURES ( 198,613.43)( 198,613.43).00 198,613.43 .0