Loading...
Finance - Quarterly Reports - FY 23/24 3rd Quarter - 06/30/2024w a ENDING CASH CHANGE IN BEGINNING CASH W 0 Z BALANCE SHEET EXPENDITURES REVENUES W 0 Z J FUND NUMBER AND TITLE V O O co O O O O O O N 0 co V Lo 0 co N C O O r (17O O O O O O r O co o D N N co co L7, CO 01 CO LO N M N CO co co O N V O N V 4 N- N V M I_ 4- co co M co co 2,454,762.55) Ti O) P. co 0 M N- M (O R Op .-. N 0 r M 0 LO O W N,— co N O. N. V co co V N N (O O (r) O) O. co V U) N U) N 0 r O O N CO N O (O O M N N N (O co 4-opN co co N V O LO CO (O ,— I: O) op V N O CO M M N O) N V .— (O V (O co. 4-- co co co co N O) co O) N N co co N V c0 O) (O 0 c0 M V M O) (O c0 c0 0 V O) U) 0 O N CO N V O) M (O O) O) M O O (O CO O) O N M co N O W cc;N co N N N M (O O O N (O co co co (O (O LO (O N LO r co co 3,947,831.01 M co O. LO op O) co. N co N r co a) co O O co co O V V V O) (O V o0 O cc; co O O N MO) C') — O co N N co N O) N- C) u) u) N 0 (O CO N N. M M CO O) O O) N- M V V N N- M ,— V N O) V co N- co N M M V CO N N.— I� V LO V V N I. (O M O M N N N N (O LO N CO N- N (O N r O) O) N- r CO CO N N (O V V (O 0 M V M O) N V V N CO N O r M M N W O) — O N- N N LO O N- LO N- O) LO (`') LO O) cc;U) . LO LO N CO N- LO (O (O LO (O LO LO LO N (O 3,360,631.81 O (O N V (NI M N O) V (O O) M N- O O) O) 0 N co N M V LO CO O CO (O N (O M O V O O) 00 O) N- N cc) C') 00 (O O) V O (O N O (O co O V co O) V c0 0 N- O) O) co (O N N M (O N co co O) co V N V V c0 CO V c0 V V N- I': M �_ M N N N- N r co M M M N M N- M 00 N M V N V V N N.-(O N (O co V N N N N V LO O) O) O O co V O O O O O O N O O co O V co E a) O O N O O O O O O co O O co (O O O op o N (O O N- (O (O O) O) O) LO (O LO N- (O N N M (O M (O O) LO M O) CO (O N M M N- O) O) (O Oj o) con c ,— co00 GENERAL FUND LIBRARY FUND MUSEUM FUND PARK IMPACT FEE FUND r CO O 0 0 0 09 RECREATION - SPECIAL EVENTS EXECUTIVE DEPARTMENT co - 7,382,680.23 CD 03 Q U a) CO3 ?� C V) C r= > U a) s a) U 03 _c (h = C 00 O(9 a) a) a4-' a) co N 5 a) V1 cc O O N U N O. 0O — N 0 aa a) C O > V a.) U N a 0_a5 a) N .. U) > W N t U U) O O C (6 a C -) N a) 0 'O CC 0 (1) a) m a) 'T F 03 O a) W W Q N 0_w O O Q (�6 a) ce VN C C O a5 w • _ W O 3 o T oE W Wp F w _U U >O0' ~ ULc) To_ N O ao o rs o= }F Jp allo QUW wp aaQ >mp QUW QHQ wQ J}F wQ m WO R. YmWz O O -= O .a3 a) 0U0 0)0 wEt a O ca(0 C (0N _C - O O a) H oa)QF >._ > in Cr) m w W U w W w J U li U I—' (6 05 05 oO .- N +• o N M c CO O) M V LO c o o)U u U Y U o N N N N co co (O O) UILI &Z I IECE E DE :APE UBL IECE ATF AW :ITY ✓ATE IBEI OM 8,598,976.34 07/11/2024 06:37PM 75 % OF THE FISCAL YEAR HAS ELAPSED COMBINED CASH ACCOUNTS 99-0103-00-00 CASH IN CHECKING 99-0108-00-00 CASH CLEARING -ACCOUNTS REC TOTAL COMBINED CASH 99-0101-00-00 CASH ALLOCATED TO OTHER FUNDS CITY OF EAGLE COMBINED CASH INVESTMENT JUNE 30, 2024 1,992,716.64 462,045.91 2,454,762.55 ( 2,454,762.55) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 8 ALLOCATION TO PARK IMPACT FEE FUND 9 ALLOCATION TO RECREATION - SPECIAL EVENTS 19 ALLOCATION TO CAPITAL PROJECTS FUND 24 ALLOCATION TO RECREATION - EAGLE FUN DAYS 25 ALLOCATION TO PATHWAY IMPACT FEE FUND 27 ALLOCATION TO LAW ENF DEV IMPACT FEES 60 ALLOCATION TO WATER FUND 61 ALLOCATION TO FIBER FUND TOTAL ALLOCATIONS TO OTHER FUNDS ALLOCATION FROM COMBINED CASH FUND - 99-0101-00-00 1,311,269.34 330,336.73 15,514.91 174,762.72 1,651.16 44,383.84 7,098.05 535,286.28 34,459.52 2,454,762.55 ( 2,454,762.55) ZERO PROOF IF ALLOCATIONS BALANCE .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:23PM PAGE: 1 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 GENERAL FUND ASSETS 01-0101-00-00 CASH 1,311,269.34 01-0103-00-00 PETTY CASH 150.00 01-0107-00-00 TAXES RECEIVABLE DELINQUENT 22,574.55 01-0115-00-00 ACCOUNTS RECEIVABLE 59,891.29 01-0132-00-00 DUE FROM OTHER GOVERNMNTL UNTS 922,768.40 01-0151-25-00 INVESTMENTS 8,004,205.23 01-0151-28-00 ICCU CD 53,729.80 01-0151-30-00 ITD, AVIMOR, FEE INVESTMENTS 75,292.77 01-0170-00-00 HRA 10 % DEPOSIT 5,785.92 TOTAL ASSETS 10,455,667.30 LIABILITIES AND EQUITY LIABILITIES 01-0202-00-00 VOUCHERS PAYABLE ( 1,896.70) 01-0203-00-00 ACCTS PAYABLE-ACHD IMPACT FEES 233,027.00 01-0203-01-01 BONDS/SURETIES/DEPOSITS PYBLE 1,558,532.15 01-0203-01-03 VENDORS BOND DEPOSITS PAYABLE 3,000.00 01-0203-01-05 P&Z DEPOSITS PAYABLE 511,082.14 01-0203-01-06 LAND USE DEPOSITS PAYABLE 53,729.80 01-0217-07-00 INSURANCE ( 12,104.06) 01-0217-07-01 COBRA INSURANCE ( 2,641.56) 01-0217-09-00 WORKERS' COMPENSATION 5.52 01-0220-02-00 ITD, AVIMOR, DEPOSITS 75,292.77 01-0226-00-00 DEFERRED REVENUE 20,335.95 TOTAL LIABILITIES 2,438,363.01 FUND EQUITY 01-0271-00-00 FUND BALANCE 8,175,506.02 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 158,201.73) ( 158,201.73) 8,017,304.29 10,455,667.30 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:23PM PAGE: 2 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 01-0311-00-00 PROPERTY TAX 146,359.29 3,213,328.98 4,762,920.00 1,549,591.02 67.5 01-0311-01-00 PENALTY/INTEREST ON TAXES 1,402.49 3,532.12 4,500.00 967.88 78.5 01-0312-00-00 PERSONAL PROPERTY TAX REIMBURS .00 5,151.05 8,463.00 3,311.95 60.9 01-0316-10-02 FRANCHISE FEE, VEOLIA 4,642.86 25,791.83 30,000.00 4,208.17 86.0 01-0316-11-00 FRANCHISE FEE, INTERMTN GAS 152,656.64 286,209.36 350,000.00 63,790.64 81.8 01-0316-12-00 FRANCHISE FEE, CABLE TV 22,363.67 67,142.31 115,000.00 47,857.69 58.4 01-0316-13-00 FRANCHISE FEE, SOLID WASTE 98,342.37 282,653.36 350,000.00 67,346.64 80.8 01-0316-14-00 FRANCHISE FEE, IDAHO POWER 64,782.98 215,647.36 250,000.00 34,352.64 86.3 01-0321-10-00 BUSINESS, ALCOHOL, MISC-LCNSES 51,890.86 61,920.59 56,500.00 ( 5,420.59) 109.6 01-0321-10-01 BACKGROUND CHECKS 2,385.25 2,814.25 1,500.00 ( 1,314.25) 187.6 01-0322-10-00 BUILDING & INSPECTION PERMITS 687,336.95 1,351,519.65 1,025,000.00 ( 326,519.65) 131.9 01-0322-12-00 BUILDING, PLAN REVIEW FEES 254,463.45 514,234.15 478,750.00 ( 35,484.15) 107.4 01-0322-13-00 ENERGY STANDARDS (IRES) 10,050.00 19,500.00 12,500.00 ( 7,000.00) 156.0 01-0322-14-00 ELECTRICAL PERMIT FEES 69,804.57 194,614.85 200,000.00 5,385.15 97.3 01-0322-15-00 PLUMBING PERMIT FEES 51,762.92 146,110.45 184,000.00 37,889.55 79.4 01-0322-16-00 MECHANICAL PERMIT FEES 56,571.36 191,749.42 184,000.00 ( 7,749.42) 104.2 01-0322-20-00 ADMIN FEES, FIRE & ITD AVIMOR 3,340.00 6,920.00 5,000.00 ( 1,920.00) 138.4 01-0323-01-00 PZANNEX/ZONING PERMIT FEES 35,503.53 149,916.07 85,000.00 ( 64,916.07) 176.4 01-0323-02-00 PLANNING INSPECTION FEES 5,650.00 13,750.00 5,000.00 ( 8,750.00) 275.0 01-0323-03-00 PLANNING, PLAN REVIEW FEES 16,141.74 32,391.74 20,000.00 ( 12,391.74) 162.0 01-0323-04-00 STREET LIGHT INSPECTION FEES 540.00 1,630.00 800.00 ( 830.00) 203.8 01-0323-05-00 SURETY/LETTER OF CREDIT FEES 1,250.00 4,700.00 4,000.00 ( 700.00) 117.5 01-0323-06-00 GRADING -DRAINAGE PERMIT FEES 2,250.00 4,931.25 6,000.00 1,068.75 82.2 01-0323-10-00 SPRING VALLEY STAFF TIME REIMB 1,774.32 4,735.32 10,000.00 5,264.68 47.4 01-0323-11-00 AVIMOR STAFF TIME REIMBURSE 2,759.40 4,334.40 10,000.00 5,665.60 43.3 01-0335-10-00 STATE, LIQUOR DISTRIBUTION 136,484.00 272,968.00 665,000.00 392,032.00 41.1 01-0335-50-00 STATE, AG EQUIPMENT REPL TAX 4.75 14.25 19.00 4.75 75.0 01-0335-60-00 STATE, SALES TAX REV SHARING 822,325.79 2,582,133.82 3,914,826.00 1,332,692.18 66.0 01-0338-40-00 COURT FEES 33,303.59 77,834.72 55,000.00 ( 22,834.72) 141.5 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 910.00 7,510.50 12,000.00 4,489.50 62.6 01-0341-13-00 ENGINEERING FEES - DEVELOPERS 26,835.12 146,783.80 175,000.00 28,216.20 83.9 01-0341-14-00 ATTORNEY FEES - DEVELOPERS 70.00 11,007.50 30,000.00 18,992.50 36.7 01-0341-17-00 CID STAFF & MISC REIMBURSEMENT 545.90 2,594.81 .00 ( 2,594.81) .0 01-0341-20-00 REIMBURSE FROM WATER DEPT .00 9,027.00 13,410.00 4,383.00 67.3 01-0341-20-01 REIMBURSE FROM FIBER DEPT .00 3,609.00 5,000.00 1,391.00 72.2 01-0341-27-00 URA CITY STAFF REIMBURSEMENT 2,341.04 2,341.04 3,000.00 658.96 78.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 1,000.00 1,000.00 .00 100.0 01-0350-02-00 IDAHO OPIOID SETTLEMENT 5,040.86 15,110.90 15,000.00 ( 110.90) 100.7 01-0350-05-00 FIELD OF HONOR 26,691.03 27,221.03 25,000.00 ( 2,221.03) 108.9 01-0350-07-00 MAYORS 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 102,461.17 293,075.50 25,000.00 ( 268,075.50) 1172.3 01-0379-00-00 MISCELLANEOUS REVENUE 9,649.00 17,575.06 1,000.00 ( 16,575.06) 1757.5 01-0379-01-00 DUPLICATION/PUBLISHING/PRINTNG 108.00 108.00 500.00 392.00 21.6 01-0383-05-00 MISCELLANEOUS-REIMBURSEABLES 3,618.64 8,996.67 1,500.00 ( 7,496.67) 599.8 01-0383-09-00 ROOM RESERVATIONS 2,852.16 6,372.02 4,000.00 ( 2,372.02) 159.3 01-0383-16-00 INSURANCE REIMBURSEABLES 1,411.60 3,169.78 .00 ( 3,169.78) .0 01-0385-00-00 FIRE DEPT IMPACT FEES 441,954.51 723,736.10 224,250.00 ( 499,486.10) 322.7 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:23PM PAGE: 3 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 GENERAL FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT 01-0399-00-00 CARRY OVER .00 .00 8,103,480.00 8,103,480.00 .0 TOTAL FUND REVENUE 3,360,631.81 11,017,418.01 21,443,538.00 10,426,119.99 51.4 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:23PM PAGE: 4 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT 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 1,250.00 3,130.00 4,300.00 1,170.00 72.8 01-0413-02-00 DESIGN REVIEW BRD COMPENSATION 1,500.00 2,800.00 5,000.00 2,200.00 56.0 01-0413-05-00 OFFICE SUPPLIES 5,201.59 12,813.51 25,000.00 12,186.49 51.3 01-0413-06-00 PRINTING & DISTRIBUTION 78.00 78.00 500.00 422.00 15.6 01-0413-07-00 POSTAGE 1,796.96 5,381.70 12,500.00 7,118.30 43.1 01-0413-08-00 LEGAL ADVERTISING/PUBLICATION 365.84 2,254.89 5,000.00 2,745.11 45.1 01-0413-10-00 INSURANCE - PROPERTY .00 72,658.00 82,000.00 9,342.00 88.6 01-0413-12-00 PERSONNEL TRAINING 650.00 650.00 3,000.00 2,350.00 21.7 01-0413-13-00 TRAVEL & PER DIEM .00 .00 2,000.00 2,000.00 .0 01-0413-14-00 PROFESSIONAL DUES AND SERVICES 6,757.50 46,748.10 153,000.00 106,251.90 30.6 01-0413-25-00 MISCELLANEOUS 15.64 481.69 20,000.00 19,518.31 2.4 01-0413-28-00 RESOURCE MATERIALS 119.85 438.78 6,500.00 6,061.22 6.8 01-0413-29-00 REAL PROPERTY TAXES - CITY .00 339.50 400.00 60.50 84.9 01-0413-31-00 ENGINEERING FEES - DEVELOPERS 50,355.61 182,768.99 175,000.00 ( 7,768.99) 104.4 01-0413-33-00 ATTORNEY FEES - DEVELOPERS 1,251.25 6,588.75 30,000.00 23,411.25 22.0 01-0413-37-00 BACKGROUND CHECK-PERMITS/LIC 1,097.25 1,662.50 2,500.00 837.50 66.5 01-0413-44-00 PHOTOS - MAYOR/CITY COUNCIL 169.39 361.65 900.00 538.35 40.2 01-0413-50-00 RECRUITING 1,806.21 2,105.21 2,500.00 394.79 84.2 01-0413-51-00 BACKGROUND CHK, PRE -EMPLOYMENT 588.75 1,181.00 1,000.00 ( 181.00) 118.1 01-0413-52-00 DRUG TESTING, PRE -EMPLOYMENT 105.00 560.00 1,000.00 440.00 56.0 TOTAL ADMINISTRATION PERSONNEL 73,108.84 343,002.27 532,100.00 189,097.73 64.5 01-0415-11-00 SALARIES - COUNCIL 16,224.96 45,169.92 65,000.00 19,830.08 69.5 01-0415-21-00 FICA 1,241.28 3,455.64 5,000.00 1,544.36 69.1 01-0415-22-00 PERSI 1,813.92 5,049.96 7,775.00 2,725.04 65.0 01-0415-23-01 HRA/COBRAADMIN FEES 384.75 1,009.40 1,800.00 790.60 56.1 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 19,664.91 121,665.15 153,275.00 31,609.85 79.4 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:23PM PAGE: 5 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT CONTRACTS & AGREEMENTS 01-0416-02-00 CITY ATTORNEY 36,388.75 139,165.46 250,000.00 110,834.54 55.7 01-0416-05-00 PROSECUTOR -ADA, BOISE, GEM 44,239.59 108,785.41 129,000.00 20,214.59 84.3 01-0416-06-00 IDAHO HUMANE SOCIETY 42,927.51 128,782.43 171,800.00 43,017.57 75.0 01-0416-07-00 CITY ENGINEERING 3,417.25 3,514.75 20,000.00 16,485.25 17.6 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 3,400,657.47 4,232,000.00 831,342.53 80.4 01-0416-34-00 BUDGET RESERVES, FY 1STQTR .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 13,311.75 17,800.00 4,488.25 74.8 01-0416-49-00 DRUGFREE IDAHO 588.25 1,555.84 2,000.00 444.16 77.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 CODE ENFORCEMENT 1,265,551.09 3,826,123.11 6,458,420.00 2,632,296.89 59.2 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 196.51 484.51 25,000.00 24,515.49 1.9 01-0422-15-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 TOTAL RESTRICTED 196.51 484.51 44,000.00 43,515.49 1.1 PUBLIC AFFAIRS/COMM RELATIONS 01-0462-01-00 PUBLIC RELATIONS 890.79 3,006.68 6,000.00 2,993.32 50.1 01-0462-02-00 AWARDS & RECOGNITIONS .00 89.90 1,500.00 1,410.10 6.0 TOTAL PUBLIC AFFAIRS/COMM RELATIONS 890.79 3,096.58 7,500.00 4,403.42 41.3 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:23PM PAGE: 6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT GENERAL FUND TRANSFERS 01-0463-01-00 MUSEUM DEPT TRANSFER 22,643.86 43,390.84 180,610.00 137,219.16 24.0 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 116,612.01 364,026.51 807,120.00 443,093.49 45.1 01-0463-07-00 CAPITAL PROJECTS TRANSFER 128,737.67 258,034.39 2,998,200.00 2,740,165.61 8.6 01-0463-08-00 RECREATION, EAGLE FUN DAYS TRN 1,000.00 6,010.00 126,400.00 120,390.00 4.8 01-0463-11-00 PUBLIC WORKS TRANSFER 560,350.91 1,626,958.18 2,884,511.00 1,257,552.82 56.4 01-0463-11-01 EXECUTIVE DEPT TRANSFER 112,997.11 334,345.04 662,430.00 328,084.96 50.5 01-0463-12-00 CITY HALL BOND FUND TRANSFER 450.00 6,959.41 104,750.00 97,790.59 6.6 01-0463-12-01 CLERK/TREAS DEPT TRANSFER 172,345.42 498,520.70 810,700.00 312,179.30 61.5 01-0463-13-01 BUILDING DEPT TRANSFER 247,413.53 655,115.15 1,068,860.00 413,744.85 61.3 01-0463-14-01 PLANNING AND ZONING DEPT TRANS 252,283.85 736,353.46 1,288,000.00 551,646.54 57.2 01-0463-15-00 LIBRARY TRANSFER 381,965.49 930,418.18 1,672,392.00 741,973.82 55.6 01-0463-18-01 IT DEPT TRANSFER 248,476.84 693,611.45 1,204,530.00 510,918.55 57.6 TOTAL GENERAL FUND TRANSFERS COMMUNITY PROJECTS -CAP OUTLAY 2,245,276.69 6,183,208.35 13,846,578.00 7,663,369.65 44.7 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 343,142.18 568,877.77 224,250.00 ( 344,627.77) 253.7 TOTAL FIRE DEPARTMENT IMPACT FEES 343,142.18 568,877.77 224,250.00 ( 344,627.77) 253.7 TOTAL FUND EXPENDITURES 3,947,831.01 11,175,619.74 21,443,538.00 10,267,918.26 52.1 NET REVENUE OVER EXPENDITURES ( 587,199.20) ( 158,201.73) .00 158,201.73 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:24PM PAGE: 7 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 LIBRARY FUND 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 06-0216-00-00 LIBRARY/ACCRUED PAYROLL 06-0217-03-00 FICA 06-0217-04-00 PERSI RETIREMENT 06-0217-07-00 INSURANCE 06-0217-09-00 WORKERS' COMPENSATION 06-0217-10-00 HSA CONTRIBUTION 06-0226-00-00 DEFERRED REVENUE 46.07 19,220.15 3,039.93 3,284.67 18,555.81 17,055.43 2,454.00 1,048.03 TOTAL LIABILITIES 64,704.09 FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 61,756.09) 61, 756.09) 61, 756.09) 2,948.00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:24PM PAGE: 8 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 LIBRARY FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 06-0301-00-00 FUNDING FROM GENERAL FUND 381,965.49 930,418.18 1,672,392.00 741,973.82 55.6 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,217.02 2,865.21 1,000.00 ( 1,865.21) 286.5 06-0361-20-01 LOST ITEMS 2,191.55 6,098.99 2,500.00 ( 3,598.99) 244.0 06-0361-21-00 LIBRARY COPY MACHINE 873.88 2,175.74 1,200.00 ( 975.74) 181.3 06-0361-21-01 3 D PRINTING 4.80 6.31 .00 ( 6.31) .0 06-0379-00-00 MISCELLANEOUS REVENUE 173.14 961.82 750.00 ( 211.82) 128.2 06-0379-01-00 MISCELLANEOUS REV NON TAXABLE 1,213.32 1,500.94 .00 ( 1,500.94) .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 EXPENDITURES CONTRACTS/AGREEMENTS 06-0416-01-00 LEGAL - CITY ATTORNEY 06-0416-02-00 PHOTOCOPIERS TOTAL CONTRACTS/AGREEMENTS OPERATIONS & MAINTENANCE 387,639.20 967,174.61 1,682,842.00 715,667.39 57.5 .00 560.00 .00 ( 560.00) .0 1,657.22 5,863.58 13,000.00 7,136.42 45.1 1,657.22 6,423.58 13,000.00 6,576.42 49.4 06-0420-01-00 ADMINISTRATION 6,216.89 13,523.73 15,000.00 1,476.27 90.2 06-0420-04-00 MARKETING 14,227.65 14,967.16 19,000.00 4,032.84 78.8 06-0420-04-01 OUTREACH 726.45 5,632.39 5,000.00 ( 632.39) 112.7 06-0420-05-00 OFFICE SUPPLIES 1,501.13 4,107.31 9,100.00 4,992.69 45.1 06-0420-05-01 MATERIAL PROCESSING SUPPLIES 2,555.74 7,338.61 5,000.00 ( 2,338.61) 146.8 06-0420-06-00 UNIFORMS 3,768.16 4,305.32 4,650.00 344.68 92.6 06-0420-07-00 SMALL FURNITURE REPLACEMENT 4,254.86 5,453.11 2,000.00 ( 3,453.11) 272.7 06-0420-10-00 POSTAGE 1,035.00 1,831.06 2,500.00 668.94 73.2 06-0420-11-00 SUBSCRIPTIONS & MEMBERSHIPS .00 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 LYNX1 CONSORTIUM 34,285.88 57,415.50 68,550.00 11,134.50 83.8 06-0430-00-00 LYNX! SYSTEM 11,464.92 06-0430-02-00 LYNX! COURIER 6,847.00 17,197.38 26,750.00 10,483.59 16,900.00 9,552.62 64.3 6,416.41 62.0 TOTAL LYNX1 CONSORTIUM 18,311.92 27,680.97 43,650.00 15,969.03 63.4 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:24PM PAGE: 9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT COST RECOVERY OR PASS THRU 06-0435-00-00 CREDIT CARD PROCESSING FEE 953.24 2,843.89 3,200.00 356.11 88.9 06-0435-02-00 LOST ITEMS REFUNDS .00 .00 300.00 300.00 .0 06-0435-03-00 OPEN ACCESS 589.19 1,325.87 2,200.00 874.13 60.3 TOTAL COST RECOVERY OR PASS THRU 1,542.43 4,169.76 5,700.00 1,530.24 73.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 30,284.17 88,691.42 158,500.00 69,808.58 56.0 06-0450-01-00 PRINT VENDOR PROCESSING 1,854.40 5,891.80 9,000.00 3,108.20 65.5 06-0450-02-00 BOOKS -DIGITAL 23,122.00 36,503.66 85,000.00 48,496.34 43.0 06-0450-03-00 MAGAZINES & NEWSPAPERS .00 .00 3,750.00 3,750.00 .0 06-0450-03-01 MAGAZINES - DIGITAL 5,711.00 12,011.00 16,750.00 4,739.00 71.7 06-0450-04-00 MEDIA 19,480.85 50,989.39 81,000.00 30,010.61 63.0 06-0450-05-00 MEDIA -DIGITAL 6,275.00 27,569.25 67,000.00 39,430.75 41.2 06-0450-06-00 DATABASES 900.00 5,647.00 16,800.00 11,153.00 33.6 06-0450-07-00 HOTSPOT 519.40 1,466.74 3,200.00 1,733.26 45.8 06-0450-08-00 FAMILY PLACE SPACE .00 3,607.09 10,000.00 6,392.91 36.1 TOTAL GUEST RESOURCES GUEST CLASSES & EVENTS 06-0455-00-00 CLASSES & EVENTS TOTAL GUEST CLASSES & EVENTS PERSONNEL 88,146.82 232,377.35 451,000.00 218,622.65 51.5 6,344.58 16,230.70 25,000.00 8,769.30 64.9 6,344.58 16,230.70 25,000.00 8,769.30 64.9 06-0461-10-00 SALARIES - FULL TIME 147,306.70 399,467.41 539,500.00 06-0461-10-01 SALARIES - PERSONNEL SERVICES 8,969.10 28,378.19 .00 06-0461-11-00 OVERTIME 253.64 929.94 5,000.00 06-0461-15-00 SALARIES - PART TIME 15,414.54 52,854.06 216,500.00 06-0461-15-01 SALARIES - PERSONNEL SERVICES 8,464.80 15,144.94 .00 06-0461-21-00 FICA 12,056.80 33,743.52 58,500.00 06-0461-22-00 PERSI 16,090.98 43,950.94 64,700.00 06-0461-23-00 HRA BUY -DOWN .00 4,612.67 5,500.00 06-0461-23-01 HRA/COBRA ADMIN FEES 291.60 778.40 900.00 06-0461-24-00 WORKERS' COMPENSATION .00 705.58 1,792.00 06-0461-25-00 INSURANCE 20,927.50 54,648.32 103,500.00 06-0461-26-00 HSACONTRIBUTION 300.00 900.00 1,200.00 06-0461-27-00 PTO CASH OUT .00 .00 5,000.00 140,032.59 74.0 28,378.19) .0 4,070.06 18.6 163,645.94 24.4 15,144.94) .0 24,756.48 57.7 20,749.06 67.9 887.33 83.9 121.60 86.5 1,086.42 39.4 48,851.68 52.8 300.00 75.0 5,000.00 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:24PM PAGE: 10 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT 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 230,075.66 636,113.97 1,013,092.00 376,978.03 62.8 RESTRICTED FUNDS 06-0462-01-00 GRANTS TOTAL RESTRICTED FUNDS STAFF DEVELOPMENT .00 15,099.38 .00 ( 15,099.38) .0 .00 15,099.38 .00 ( 15,099.38) .0 06-0463-00-00 TRAVEL & PER DIEM .00 392.96 1,000.00 607.04 39.3 06-0463-01-00 MILEAGE REIMBURSEMENT 61.16 134.63 1,100.00 965.37 12.2 06-0463-02-00 TRAINING 900.00 900.00 2,100.00 1,200.00 42.9 06-0463-03-00 CONTINUING EDUCATION .00 9,149.00 12,500.00 3,351.00 73.2 06-0463-08-00 VIRTUAL TRAINING .00 239.00 1,500.00 1,261.00 15.9 TOTAL STAFF DEVELOPMENT 961.16 10,815.59 18,200.00 7,384.41 59.4 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 5,546.54 18,573.37 28,300.00 9,726.63 65.6 06-0464-03-00 TELEPHONE 248.32 413.90 1,000.00 586.10 41.4 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 1,502.72 1,850.00 347.28 81.2 TOTAL FACILITY (BLDGS & GROUNDS) 6,368.72 21,290.58 38,150.00 16,859.42 55.8 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 387,694.39 1,028,930.70 1,682,842.00 653,911.30 61.1 NET REVENUE OVER EXPENDITURES ( 55.19) ( 61,756.09) .00 61,756.09 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:24PM PAGE: 11 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 MUSEUM FUND LIABILITIES AND EQUITY LIABILITIES 07-0217-03-00 FICA 07-0217-04-00 PERSI RETIREMENT 07-0217-07-00 INSURANCE 07-0217-09-00 WORKERS' COMPENSATION 246.54 240.94 678.11 1,603.16 TOTAL LIABILITIES 2,768.75 FUND EQUITY 07-0271-00-00 MUSEUM FUND BALANCE 18,460.31 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 21,229.06) 21,229.06) 2,768.75) .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:24PM PAGE: 12 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 MUSEUM FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 07-0316-12-00 FUNDING FROM GENERAL FUND 22,643.86 43,390.84 180,610.00 137,219.16 24.0 07-0333-01-00 GRANTS, STATE .00 .00 16,000.00 16,000.00 .0 07-0376-00-00 CONTRIBUTIONS AND DONATIONS 545.00 545.00 500.00 ( 45.00) 109.0 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 20.00 35.99 .00 ( 35.99) .0 TOTAL FUND REVENUE EXPENDITURES PERSONNEL 23,208.86 44,051.76 197,365.00 153,313.24 22.3 07-0420-10-00 SALARIES - FULL TIME 18,413.10 48,724.80 103,500.00 54,775.20 47.1 07-0420-15-00 SALARIES - PART TIME .00 .00 20,000.00 20,000.00 .0 07-0420-21-00 FICA 1,408.58 3,727.42 9,600.00 5,872.58 38.8 07-0420-22-00 PERSI 1,875.34 5,264.19 12,450.00 7,185.81 42.3 07-0420-24-00 WORKERS' COMPENSATION .00 3.44 .00 ( 3.44) .0 07-0420-25-00 INSURANCE 932.42 4,681.22 6,500.00 1,818.78 72.0 07-0420-27-00 HRA BUY DOWN .00 .00 1,540.00 1,540.00 .0 TOTAL PERSONNEL EDUCATION 22,629.44 62,401.07 153,590.00 91,188.93 40.6 07-0461-02-00 ASSOCIATION MEMBERSHIP 50.00 333.00 325.00 ( 8.00) 102.5 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 50.00 333.00 1,575.00 1,242.00 21.1 ADMINISTRATION 07-0462-30-00 CONSERVATION AND PRESERVATION .00 .00 200.00 200.00 .0 07-0462-31-00 OFFICE SUPPLIES 46.26 324.98 750.00 425.02 43.3 07-0462-32-00 ARCHIVAL SUPPLIES 62.31 196.62 1,000.00 803.38 19.7 07-0462-33-00 PUBLICITY -PRINTING 24.99 24.99 350.00 325.01 7.1 07-0462-34-00 RESEARCH MATERIAL 30.00 269.00 500.00 231.00 53.8 07-0462-35-00 UNIFORMS 150.40 150.40 300.00 149.60 50.1 07-0462-68-00 MUSEUM AND EDUCATION PROGRAMS .00 361.20 1,500.00 1,138.80 24.1 07-0462-69-00 MISCELLANEOUS .00 162.31 3,000.00 2,837.69 5.4 07-0462-73-00 EAGLE BOOK-ARCADIA PUBLISHING .00 .00 300.00 300.00 .0 TOTAL ADMINISTRATION 313.96 1,489.50 7,900.00 6,410.50 18.9 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:25PM PAGE: 13 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 MUSEUM FUND YTD ACTUAL BUDGET UNEXPENDED PCNT EXHIBITS 07-0463-01-00 DISPLAY SUPPLIES .00 140.00 300.00 160.00 46.7 07-0463-02-00 EXHIBIT ITEMS 160.83 160.83 100.00 ( 60.83) 160.8 07-0463-03-00 EXHIBIT CONSTRUCTION 680.50 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 HISTORIC PRESERVATION COMM 841.33 1,057.25 11,400.00 10,342.75 9.3 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 23,834.73 65,280.82 197,365.00 132,084.18 33.1 NET REVENUE OVER EXPENDITURES ( 625.87) ( 21,229.06) .00 21,229.06 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:25PM PAGE: 14 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 PARK IMPACT FEE FUND ASSETS 08-0101-00-00 CASH 330,336.73 08-0151-25-00 INVESTMENTS 761, 564.39 TOTAL ASSETS 1,091,901.12 LIABILITIES AND EQUITY FUND EQUITY 08-0271-00-00 PARK FUND/FUND BALANCE 404,624.82 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 687,276.30 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 687,276.30 1,091,901.12 1,091,901.12 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:25PM PAGE: 15 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 PARK IMPACT FEE FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 08-0322-19-00 PARKS DEVELOPMENT IMPACT FEES 407,680.00 751,788.64 416,000.00 ( 335,788.64) 180.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 4,161.55 9,841.13 2,000.00 ( 7,841.13) 492.1 08-0399-00-00 CARRY OVER .00 .00 343,900.00 343,900.00 .0 TOTAL FUND REVENUE 411,841.55 761,629.77 865,900.00 104,270.23 88.0 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 411,841.55 687,276.30 .00 ( 687,276.30) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:25PM PAGE: 16 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 RECREATION - SPECIAL EVENTS ASSETS 09-0101-00-00 CASH 15,514.91 TOTAL ASSETS 15,514.91 LIABILITIES AND EQUITY LIABILITIES 09-0217-03-00 FICA 09-0217-04-00 PERSI RETIREMENT 09-0217-07-00 INSURANCE 09-0217-09-00 WORKERS' COMPENSATION 09-0217-10-00 HSA CONTRIBUTION 243.03 337.51 16,939.25 16,623.60 3,319.35 TOTAL LIABILITIES 37,462.74 FUND EQUITY 09-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 12,223.55 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 34,171.38) 12,223.55 21,947.83) 15,514.91 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:25PM PAGE: 17 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT 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 20,537.80 20,998.33 22,500.00 1,501.67 93.3 09-0347-10-00 GAZEBO CONCERT SERIES 47.95 95.90 825.00 729.10 11.6 09-0347-11-00 HARVEST FEST MARKET .00 159.31 2,750.00 2,590.69 5.8 09-0376-12-00 MISCELLANEOUS REVENUE 333.59 4,504.38 3,000.00 ( 1,504.38) 150.2 09-0376-13-00 SPONSORSHIPS 11,750.00 16,110.00 25,000.00 8,890.00 64.4 09-0376-15-00 EVENT APPLICATION FEES 700.00 2,100.00 2,500.00 400.00 84.0 09-0376-17-00 SECURITY DEPOSIT .00 .00 1,200.00 1,200.00 .0 TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION 33,369.34 74,200.88 98,600.00 24,399.12 75.3 09-0463-11-00 OFFICE SUPPLIES .00 .00 800.00 800.00 .0 09-0463-12-00 PROMOTIONS 3,215.00 10,003.64 14,000.00 3,996.36 71.5 09-0463-19-00 TRAINING AND EDUCATION 375.00 375.00 1,200.00 825.00 31.3 09-0463-20-00 TRAVEL & PER DIEM 1,003.04 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 .00 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 149.98 274.93 700.00 425.07 39.3 TOTAL ADMINISTRATION 4,743.02 14,468.56 26,600.00 12,131.44 54.4 ACTIVITIES 09-0467-02-00 EAGLE SATURDAY MARKET 3,001.43 5,681.85 15,000.00 9,318.15 37.9 09-0467-03-00 COUNTRY CHRISTMAS 1,718.00 17,016.56 18,000.00 983.44 94.5 09-0467-04-00 GAZEBO CONCERT SERIES 4,950.00 4,950.00 10,000.00 5,050.00 49.5 09-0467-05-00 GENERAL EVENTS 6,690.14 7,701.84 10,000.00 2,298.16 77.0 09-0467-06-00 EAGLE HARVEST FEST .00 3,473.96 6,000.00 2,526.04 57.9 09-0467-07-00 HALLOWEEN .00 8,238.77 10,000.00 1,761.23 82.4 09-0467-19-00 EVENT EQUIPMENT PURCHASES 111.98 445.79 3,000.00 2,554.21 14.9 TOTAL ACTIVITIES 16,471.55 47,508.77 72,000.00 24,491.23 66.0 TOTAL FUND EXPENDITURES 21,214.57 61,977.33 98,600.00 36,622.67 62.9 NET REVENUE OVER EXPENDITURES 12,154.77 12,223.55 .00 ( 12,223.55) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:25PM PAGE: 18 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 EXECUTIVE DEPARTMENT 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 ( 2,390.19) 11-0217-09-00 WORKERS' COMPENSATION 11,801.13 11-0217-10-00 HSACONTRIBUTION ( 224.00) TOTAL LIABILITIES 12,065.50 FUND EQUITY 11-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,781.62 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 13,847.12) 1,781.62 ( 12,065.50) .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:25PM PAGE: 19 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 REVENUE 11-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION EXECUTIVE DEPARTMENT PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT 112,997.11 334,345.04 662,430.00 328,084.96 50.5 112,997.11 334,345.04 662,430.00 328,084.96 50.5 11-0413-04-00 UNIFORMS 566.05 744.80 500.00 ( 244.80) 149.0 11-0413-05-00 OFFICE SUPPLIES 232.95 232.95 750.00 517.05 31.1 11-0413-06-00 DUPLICATION/PUBLISHING/PRINT .00 182.65 .00 ( 182.65) .0 11-0413-12-00 PERSONNEL TRAINING 375.00 1,169.00 5,000.00 3,831.00 23.4 11-0413-13-00 TRAVEL & PER DIEM .00 68.90 5,000.00 4,931.10 1.4 11-0413-14-00 PROFESSIONAL DUES .00 1,259.00 3,500.00 2,241.00 36.0 11-0413-20-00 MARKETING .00 464.56 20,000.00 19,535.44 2.3 TOTAL ADMINISTRATION PERSONNEL 1,174.00 4,121.86 34,750.00 30,628.14 11.9 11-0415-10-00 SALARIES - FULL TIME 82,536.96 245,165.49 345,800.00 100,634.51 70.9 11-0415-11-00 OVERTIME .00 138.65 1,000.00 861.35 13.9 11-0415-21-00 FICA 6,493.91 18,492.65 26,500.00 8,007.35 69.8 11-0415-22-00 PERSI 9,472.44 27,669.73 41,400.00 13,730.27 66.8 11-0415-24-00 WORKERS' COMPENSATION .00 190.61 .00 ( 190.61) .0 11-0415-25-00 INSURANCE 8,334.16 28,386.85 44,500.00 16,113.15 63.8 11-0415-26-00 HSA CONTRIBUTION .00 .00 1,200.00 1,200.00 .0 11-0415-27-00 PTO CASH OUT 4,562.72 4,562.72 5,000.00 437.28 91.3 11-0415-28-00 HRABUY-DOWN 1,327.81 1,327.81 3,080.00 1,752.19 43.1 TOTAL PERSONNEL STATE OF THE CITY 112,728.00 325,934.51 468,480.00 142,545.49 69.6 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 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:26PM PAGE: 20 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 EXECUTIVE DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT COMMUNITY & STAFF RELATIONS 11-0422-01-00 COMMUNITY/STAFF RELATIONS 822.84 2,507.05 5,000.00 2,492.95 50.1 11-0422-02-00 STAFF RELATIONS ( 15.00) .00 .00 .00 .0 TOTAL COMMUNITY & STAFF RELATIONS 807.84 2,507.05 5,000.00 2,492.95 50.1 TOTAL FUND EXPENDITURES 114,709.84 332,563.42 662,430.00 329,866.58 50.2 NET REVENUE OVER EXPENDITURES ( 1,712.73) 1,781.62 .00 ( 1,781.62) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:26PM PAGE: 21 LIABILITIES AND EQUITY LIABILITIES 12-0216-00-00 ACCRUED PAYROLL 12-0217-03-00 FICA 12-0217-04-00 PERSI RETIREMENT 12-0217-07-00 INSURANCE 12-0217-09-00 WORKERS' COMPENSATION CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 CITY CLERK/TREAS DEPARTMENT 7,001.54 1,420.86 2,212.17 696.57 8,143.91 TOTAL LIABILITIES 19,475.05 FUND EQUITY 12-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 105.71 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 19,580.76) 105.71 19,475.05) .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:26PM PAGE: 22 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 REVENUE 12-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION CITY CLERK/TREAS DEPARTMENT PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT 172,345.42 498,520.70 810,700.00 312,179.30 61.5 172,345.42 498,520.70 810,700.00 312,179.30 61.5 12-0413-05-00 OFFICE SUPPLIES .00 190.00 7,500.00 7,310.00 2.5 12-0413-06-00 DUPLICATION/PUBLISHING/PRINT .00 .00 100.00 100.00 .0 12-0413-12-00 PERSONNEL TRAINING & RESOURCES 1,443.11 1,571.11 12,500.00 10,928.89 12.6 12-0413-13-00 TRAVEL & PER DIEM 726.69 2,184.82 7,500.00 5,315.18 29.1 12-0413-14-00 PROFESSIONAL DUES 489.00 1,379.00 5,500.00 4,121.00 25.1 12-0413-30-00 MISCELLANEOUS 93.60 173.06 700.00 526.94 24.7 TOTAL ADMINISTRATION 2,752.40 5,497.99 33,800.00 28,302.01 16.3 PERSONNEL 12-0415-10-00 SALARIES - FULL TIME 127,216.82 367,576.81 557,800.00 190,223.19 65.9 12-0415-11-00 OVERTIME 45.75 208.42 4,000.00 3,791.58 5.2 12-0415-21-00 FICA 9,531.88 27,467.10 42,700.00 15,232.90 64.3 12-0415-22-00 PERSI 14,349.84 41,423.03 66,800.00 25,376.97 62.0 12-0415-23-00 HRA BUY- DOWN 114.06 2,151.95 7,700.00 5,548.05 28.0 12-0415-23-02 HSA CONTRIBUTION 300.00 900.00 2,400.00 1,500.00 37.5 12-0415-24-00 WORKERS' COMPENSATION .00 25.09 .00 ( 25.09) .0 12-0415-25-00 INSURANCE 16,936.20 50,439.60 85,500.00 35,060.40 59.0 12-0415-26-00 PTO CASH OUT 1,090.00 2,725.00 10,000.00 7,275.00 27.3 TOTAL PERSONNEL 169,584.55 492,917.00 776,900.00 283,983.00 63.5 TOTAL FUND EXPENDITURES 172,336.95 498,414.99 810,700.00 312,285.01 61.5 NET REVENUE OVER EXPENDITURES 8.47 105.71 .00 ( 105.71) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:26PM PAGE: 23 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 BUILDING DEPARTMENT 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 8,723.14 13-0217-09-00 WORKERS' COMPENSATION 59,433.90 13-0217-10-00 HSA CONTRIBUTION ( 1,900.00) TOTAL LIABILITIES 74,742.97 FUND EQUITY 13-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 30,342.06) ( ( 44,300.91) 30,342.06) ( 74,642.97) 100.00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:26PM PAGE: 24 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 REVENUE 13-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION 13-0413-05-00 OFFICE SUPPLIES 13-0413-08-00 LEGAL ADS & PUBLICATIONS 13-0413-12-00 TRAINING & CERTIFICATION RENEW 13-0413-13-00 TRAVEL & PER DIEM 13-0413-14-00 PROFESSIONAL DUES 13-0413-25-00 MISCELLANEOUS 13-0413-28-00 RESOURCE MATERIALS 13-0413-29-03 MECHANICAL FEE REFUND 13-0413-29-04 PLUMBING PERMIT REFUND 13-0413-29-05 ELECTRICAL PERMIT REFUND 13-0413-30-00 UNIFORMS TOTAL ADMINISTRATION PERSONNEL BUILDING DEPARTMENT PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT 247,413.53 655,115.15 1,068,860.00 413,744.85 61.3 247,413.53 655,115.15 1,068,860.00 413,744.85 61.3 ( 5,335.62 5,773.75 6,500.00 726.25 88.8 .00 .00 400.00 400.00 .0 350.00 2,245.00 4,500.00 2,255.00 49.9 21.00 61.00 2,000.00 1,939.00 3.1 455.00 455.00 700.00 245.00 65.0 790.00) ( 790.00) 400.00 1,190.00 (197.5) .00 .00 2,000.00 2,000.00 .0 65.00 .00 .00 .00 .0 .00 66.50 .00 ( 66.50) .0 725.00 .00 .00 .00 .0 424.00 1,640.25 2,000.00 359.75 82.0 6,585.62 9,451.50 18,500.00 9,048.50 51.1 13-0415-10-00 SALARIES - FULL TIME 88,431.20 261,519.21 448,100.00 186,580.79 58.4 13-0415-10-01 SALARIES - PERSONNEL SERVICES 8,119.35 8,119.35 .00 ( 8,119.35) .0 13-0415-11-00 OVERTIME 2,990.19 3,138.63 4,000.00 861.37 78.5 13-0415-21-00 FICA 6,720.54 19,540.38 34,500.00 14,959.62 56.6 13-0415-22-00 PERSI 10,220.95 29,500.87 53,600.00 24,099.13 55.0 13-0415-23-00 HRA BUY -DOWN .00 .00 6,160.00 6,160.00 .0 13-0415-24-00 WORKERS' COMPENSATION .00 449.47 .00 ( 449.47) .0 13-0415-25-00 INSURANCE 15,962.30 47,370.57 92,300.00 44,929.43 51.3 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 CONTRACTS & AGREEMENTS 132,444.53 370,038.48 644,860.00 274,821.52 57.4 13-0416-09-00 PLUMBING INSPECTOR 30,333.99 78,111.14 110,000.00 31,888.86 71.0 13-0416-10-00 ELECTRICAL INSPECTION .00 66.50 .00 ( 66.50) .0 13-0416-11-00 MECHANICAL INSPECTOR 36,741.22 106,252.48 110,000.00 3,747.52 96.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 2,100.00 3,500.00 6,000.00 2,500.00 58.3 13-0416-25-00 ELECTRICAL INSPECTOR 40,802.38 101,822.07 120,000.00 18,177.93 84.9 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:26PM PAGE: 25 TOTAL CONTRACTS & AGREEMENTS VEHICLE OPERATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 BUILDING DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT 109,977.59 305,299.44 405,000.00 99,700.56 75.4 13-0417-02-00 GAS AND OIL 343.62 667.79 500.00 ( 167.79) 133.6 TOTAL VEHICLE OPERATIONS 343.62 667.79 500.00 ( 167.79) 133.6 TOTAL FUND EXPENDITURES 249,351.36 685,457.21 1,068,860.00 383,402.79 64.1 NET REVENUE OVER EXPENDITURES ( 1,937.83) ( 30,342.06) .00 30,342.06 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:26PM PAGE: 26 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 P&Z DEPARTMENT 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,625.74) 14-0217-08-00 GARNISHMENTS 203.34 14-0217-09-00 WORKERS' COMPENSATION 83,714.36 TOTAL LIABILITIES 59,707.31 FUND EQUITY 14-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 2,940.74 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 62,648.05) 2,940.74 ( 59, 707.31) .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:26PM PAGE: 27 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 REVENUE 14-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION P&Z DEPARTMENT PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT 252,283.85 736,353.46 1,288,000.00 551,646.54 57.2 252,283.85 736,353.46 1,288,000.00 551,646.54 57.2 14-0413-05-00 OFFICE SUPPLIES 64.87 327.23 1,300.00 972.77 25.2 14-0413-06-00 DUPLICATION/PUBLISHING/PRNTG .00 .00 1,000.00 1,000.00 .0 14-0413-08-00 LEGAL ADS & PUBLICATIONS 1,138.20 2,056.74 6,000.00 3,943.26 34.3 14-0413-12-00 PERSONNEL TRAINING 1,100.00 1,225.00 2,000.00 775.00 61.3 14-0413-13-00 TRAVEL & PER DIEM 1,341.85 1,713.94 500.00 ( 1,213.94) 342.8 14-0413-14-00 PROFESSIONAL DUES 360.00 520.00 3,300.00 2,780.00 15.8 14-0413-25-00 MISCELLANEOUS .00 359.80 500.00 140.20 72.0 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 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 PERSONNEL 4,004.92 6,208.69 22, 600.00 16,391.31 27.5 14-0415-10-00 SALARIES - FULL TIME 184,774.67 523,271.03 890,500.00 14-0415-10-01 SALARIES - PERSONNEL SERVICES .00 22,126.40 .00 14-0415-11-00 OVERTIME 2,014.61 2,846.41 13,000.00 14-0415-21-00 FICA 13,706.76 38,724.32 69,800.00 14-0415-22-00 PERSI 20,883.00 58,632.15 108,900.00 14-0415-24-00 WORKERS' COMPENSATION .00 377.53 .00 14-0415-25-00 INSURANCE 28,740.25 80,084.46 143,500.00 14-0415-26-00 HSA CONTRIBUTION .00 .00 1,200.00 14-0415-29-00 PTO CASH OUT .00 .00 10,000.00 14-0415-30-00 HRA BUY- DOWN .00 953.64 7,700.00 TOTAL PERSONNEL CONTRACTS & AGREEMENTS 367,228.97 58.8 22,126.40) .0 10,153.59 21.9 31,075.68 55.5 50,267.85 53.8 377.53) .0 63,415.54 55.8 1,200.00 .0 10,000.00 .0 6,746.36 12.4 250,119.29 727,015.94 1,244,600.00 517,584.06 58.4 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 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:26PM PAGE: 28 14-0422-01-00 PUBLIC RELATIONS TOTAL PUBLIC RELATIONS CAPITAL OUTLAY 14-0465-03-00 OFFICE EQUIPMENT TOTAL CAPITAL OUTLAY COMMUNITY PLANNING PROJECTS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 P&Z DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT .00 .00 200.00 200.00 .0 .00 .00 200.00 200.00 .0 .00 188.09 600.00 411.91 31.4 .00 188.09 600.00 411.91 31.4 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 254,124.21 733,412.72 1,288,000.00 554,587.28 56.9 NET REVENUE OVER EXPENDITURES ( 1,840.36) 2,940.74 .00 ( 2,940.74) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:26PM PAGE: 29 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 RECREATION - PARKS AND REC 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 ( 19,675.72) 17-0217-09-00 WORKERS' COMPENSATION 52,333.44 17-0217-10-00 HSA CONTRIBUTION ( 4,225.93) TOTAL LIABILITIES 31,148.90 FUND EQUITY 17-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 5,111.91 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 36,110.81) 5,111.91 ( 30,998.90) 150.00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:27PM PAGE: 30 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 RECREATION - PARKS AND REC PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 17-0301-00-00 FUNDING FROM GENERAL FUND 116,612.01 364,026.51 807,120.00 443,093.49 45.1 17-0302-00-00 REGIST-SPORTS, CAMPS, CLASSES 101,539.27 212,432.19 112,000.00 ( 100,432.19) 189.7 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 27,437.31 39,233.45 20,000.00 ( 19,233.45) 196.2 17-0302-04-00 SENIOR CENTER FEES 1,712.50 5,140.00 .00 ( 5,140.00) .0 17-0304-00-00 MISC SALES, EAGLE ARTS 107.00 117.34 .00 ( 117.34) .0 17-0399-00-00 CARRYOVER .00 .00 1,000.00 1,000.00 .0 TOTAL FUND REVENUE EXPENDITURES CONTRACTS 17-0416-00-00 CONTRACT-PERMITS,CAMPS/CLASSES 17-0416-01-00 CONTRACT -PERMITS, TEAM SPORTS 247,408.09 625,827.86 950,120.00 324,292.14 65.9 2,667.00 5,844.25 23,706.68 42,361.78 20,000.00 10,000.00 14,155.75 29.2 32,361.78) 423.6 TOTAL CONTRACTS 26,373.68 PERSONNEL 48,206.03 30,000.00 18,206.03) 160.7 17-0420-10-00 SALARIES - FULL TIME 119,313.30 338,325.54 495,000.00 156,674.46 68.4 17-0420-10-01 SALARIES - PERSONNEL SERVICES 14,424.23 26,577.77 20,000.00 ( 6,577.77) 132.9 17-0420-11-00 SALARIES - SEASONAL .00 931.35 .00 ( 931.35) .0 17-0420-18-00 OVERTIME 509.07 509.07 4,000.00 3,490.93 12.7 17-0420-21-00 FICA 8,976.27 25,746.29 38,300.00 12,553.71 67.2 17-0420-22-00 PERSI 13,396.09 38,381.45 59,700.00 21,318.55 64.3 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 17,051.24 49,215.33 86,000.00 36,784.67 57.2 17-0420-26-00 HSACONTRIBUTION 900.00 2,400.00 2,400.00 .00 100.0 17-0420-27-00 PTO CASH OUT .00 3,540.00 5,000.00 1,460.00 70.8 TOTAL PERSONNEL RESTRICTED 174,570.20 486,383.10 715,020.00 228,636.90 68.0 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 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:27PM PAGE: 31 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT 17-0422-01-00 OFFICE SUPPLIES ( 5.40) 102.27 2,000.00 1,897.73 5.1 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, REIMBURSEMENT 208.32 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 337.99 487.99 2,000.00 1,512.01 24.4 17-0422-08-00 TRAINING AND EDUCATION 1,385.77 1,578.77 3,000.00 1,421.23 52.6 17-0422-09-00 TRAVEL & PER DIEM 1,777.54 1,970.54 5,000.00 3,029.46 39.4 17-0422-10-00 BACKGROUND CHECKS 2,778.35 5,726.85 8,000.00 2,273.15 71.6 17-0422-11-00 REFUNDS -PARK REC PROGRAMS 4,305.20 4,710.20 4,000.00 ( 710.20) 117.8 TOTAL ADMINISTRATION 10,787.77 14,784.94 31,800.00 17,015.06 46.5 RECREATION 17-0423-00-00 REC SUPPLIES -CAMPS & CLASSES 2,506.17 3,047.81 10,000.00 6,952.19 30.5 17-0423-00-01 REC SUPPLIES -TEAM SPORTS 8,173.67 9,681.13 20,000.00 10,318.87 48.4 17-0423-01-00 UNIFORMS, TEAM SPORTS .00 6,584.11 15,000.00 8,415.89 43.9 17-0423-02-00 FIELD TRIPS 3,711.58 3,909.58 20,000.00 16,090.42 19.6 17-0423-04-00 TRANSPORTATION SERVICES 4,513.75 4,513.75 15,000.00 10,486.25 30.1 17-0423-05-00 DADDY DAUGHTER DANCE .00 1,324.37 2,000.00 675.63 66.2 17-0423-07-00 GLOW IN THE PARK 5.40 .00 .00 .00 .0 17-0423-08-00 HALLOWEEN TRICK -OR -TREAT .00 .00 800.00 800.00 .0 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 2,798.87 7,184.23 10,000.00 2,815.77 71.8 17-0423-11-01 SENIOR CENTER GRANT 8,453.13 11,270.28 .00 ( 11,270.28) .0 17-0423-12-00 EAGLE ARTS ADVISORY COMMITTEE 89.70 14,044.72 50,000.00 35,955.28 28.1 17-0423-20-00 NEW PROGRAMS .00 .00 5,000.00 5,000.00 .0 TOTAL RECREATION 30,252.27 64,343.77 151,300.00 86,956.23 42.5 VEHICLES 17-0424-03-00 GAS AND OIL TOTAL VEHICLES CAPITAL EQUIPMENT .00 93.47 1,000.00 906.53 9.4 .00 93.47 1,000.00 906.53 9.4 17-0425-00-00 REC EQUIPMENT -TEAM SPORTS 6,735.98 17-0425-01-00 REC EQUIPMENT-CAMPS/CLASSES 101.81 6,735.98 15,000.00 101.81 3,000.00 8,264.02 44.9 2,898.19 3.4 TOTAL CAPITAL EQUIPMENT 6,837.79 CAPITAL OUTLAY 17-0460-02-00 FURNITURE 6,837.79 18,000.00 11,162.21 38.0 66.85 66.85 2,000.00 1,933.15 3.3 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:27PM PAGE: 32 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT TOTAL CAPITAL OUTLAY 66.85 66.85 2,000.00 1,933.15 3.3 TOTAL FUND EXPENDITURES 248,888.56 620,715.95 950,120.00 329,404.05 65.3 NET REVENUE OVER EXPENDITURES ( 1,480.47) 5,111.91 .00 ( 5,111.91) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:27PM PAGE: 33 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 IT DEPARTMENT LIABILITIES AND EQUITY LIABILITIES 18-0217-03-00 FICA 555.58 18-0217-04-00 PERSI RETIREMENT 936.81 18-0217-07-00 INSURANCE ( 32,143.55) 18-0217-09-00 WORKERS' COMPENSATION 2,324.64 18-0217-10-00 HSA CONTRIBUTION 820.00 TOTAL LIABILITIES FUND EQUITY 18-0271-00-00 FUND BALANCE 39,816.94 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 12,310.42) ( 12,310.42) 27,506.52) 27,506.52 .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:27PM PAGE: 34 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 REVENUE 18-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION IT DEPARTMENT PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT 248,476.84 693,611.45 1,204,530.00 510,918.55 57.6 248,476.84 693,611.45 1,204,530.00 510,918.55 57.6 18-0413-01-00 OFFICE SUPPLIES .00 .00 1,000.00 1,000.00 .0 18-0413-02-00 SUPPLIES 274.75 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 611.40 611.40 7,000.00 6,388.60 8.7 18-0413-05-00 PROFESSIONAL DUES .00 .00 750.00 750.00 .0 TOTAL ADMINISTRATION 886.15 1,338.15 20,750.00 19,411.85 6.5 PERSONNEL 18-0415-10-00 SALARIES - FULL TIME 98,932.74 251,313.97 329,500.00 78,186.03 76.3 18-0415-11-00 IT DEPT/OVERTIME 1,651.50 2,520.56 5,000.00 2,479.44 50.4 18-0415-21-00 FICA 7,538.01 18,933.13 25,800.00 6,866.87 73.4 18-0415-22-00 PERSI 11,245.29 28,155.87 40,200.00 12,044.13 70.0 18-0415-23-00 HRA BUY- DOWN .00 .00 3,080.00 3,080.00 .0 18-0415-24-00 WORKERS' COMPENSATION .00 18.82 .00 ( 18.82) .0 18-0415-25-00 INSURANCE 12,151.49 27,893.76 58,500.00 30,606.24 47.7 18-0415-26-00 HSA CONTRIBUTION 225.00 700.00 1,200.00 500.00 58.3 18-0415-27-00 PTO CASH OUT .00 .00 2,500.00 2,500.00 .0 TOTAL PERSONNEL CONTRACT & AGREEMENTS 131,744.03 329,536.11 465,780.00 136,243.89 70.8 18-0416-01-00 CONTRACTAND AGREEMENTS 67,189.31 251,102.34 453,000.00 201,897.66 55.4 TOTAL CONTRACT & AGREEMENTS 67,189.31 INTERNET/PHONE SERVICES 251,102.34 453,000.00 201,897.66 55.4 18-0417-01-00 INTERNET & PHONE SERVICES 39,765.25 86,481.36 89,000.00 2,518.64 97.2 TOTAL INTERNET/PHONE SERVICES 39,765.25 OPERATIONAL RESERVES 86,481.36 89,000.00 2,518.64 97.2 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:27PM PAGE: 35 18-0418-01-00 IT EQUIPMENT/SOFTWARE TOTAL OPERATIONAL RESERVES CAPITAL OUTLAY CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 IT DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT 6,720.03 6,720.03 55,000.00 48,279.97 12.2 6,720.03 6,720.03 55,000.00 48,279.97 12.2 18-0419-01-00 FURNITURE .00 .00 1,000.00 1,000.00 .0 18-0419-02-00 EQUIPMENT 1,646.49 22,831.84 65,000.00 42,168.16 35.1 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 1,646.49 30,743.88 121,000.00 90,256.12 25.4 TOTAL FUND EXPENDITURES 247,951.26 705,921.87 1,204,530.00 498,608.13 58.6 NET REVENUE OVER EXPENDITURES 525.58 ( 12,310.42) .00 12,310.42 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:27PM PAGE: 36 ASSETS 19-0101-00-00 CASH 19-0151-25-00 INVESTMENTS CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 CAPITAL PROJECTS FUND 174, 762.72 5,446,225.61 TOTAL ASSETS 5,620,988.33 LIABILITIES AND EQUITY LIABILITIES 19-0225-00-00 UNEARNED GRANT REVENUE, ARPA TOTAL LIABILITIES FUND EQUITY 941,148.64 19-0271-00-00 FUND BALANCE 5,131,153.38 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 451,313.69) 451,313.69) 941,148.64 4,679,839.69 5,620,988.33 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:27PM PAGE: 37 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 CAPITAL PROJECTS FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 19-0301-00-00 FUNDING FROM GENERAL FUND 128,737.67 258,034.39 2,998,200.00 2,740,165.61 8.6 19-0301-05-00 EAGLE RD PED/BIKE BRIDGE 260,498.50 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 63,963.49 198,423.26 15,000.00 ( 183,423.26) 1322.8 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 EXPENDITURES RESERVES 453,199.66 1,019,958.21 11,326,220.00 10,306,261.79 9.0 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 TOTAL CAPITAL MAINTENANCE CITY CAPITAL PROJECTS 215,038.26 590,669.28 2,146,700.00 1,556,030.72 27.5 215,038.26 590,669.28 2,146,700.00 1,556,030.72 27.5 19-0465-05-00 GENERAL CITY PROJECTS .00 .00 100,000.00 100,000.00 .0 19-0465-08-00 CURRENT FISCAL YEAR PROJECTS 176,144.12 237,507.62 2,545,000.00 2,307,492.38 9.3 TOTAL CITY CAPITAL PROJECTS 176,144.12 237,507.62 2,645,000.00 2,407,492.38 9.0 PZ CAPITAL PROJECTS 19-0466-03-00 AIKENS EXTENSION 15,287.72 15,287.72 680,000.00 664,712.28 2.3 19-0466-05-00 EAGLE RD PED/BIKE BRIDGE 142,729.67 174,397.34 30,000.00 ( 144,397.34) 581.3 19-0466-09-00 EAGLE -STATE ST INTERSECTION .00 14,837.75 1,010,309.00 995,471.25 1.5 19-0466-10-00 P&Z CAPITAL PROJECTS .00 12,925.00 400,000.00 387,075.00 3.2 TOTAL PZ CAPITAL PROJECTS PARK CAPITAL PROJECTS 19-0467-02-00 PARK CAPITAL PROJECTS 158,017.39 217,447.81 2,120,309.00 1,902,861.19 10.3 .00 161,809.97 537,000.00 375,190.03 30.1 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:27PM PAGE: 38 TOTAL PARK CAPITAL PROJECTS LIBRARY CAPITAL PROJECTS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 CAPITAL PROJECTS FUND YTD ACTUAL BUDGET UNEXPENDED PCNT .00 161,809.97 537,000.00 375,190.03 30.1 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 75,891.00 235,455.45 140,000.00 ( 95,455.45) 168.2 19-0486-01-01 ARPA, SOFTWARE PURCHASES 3,000.00 28,381.77 .00 ( 28,381.77) .0 TOTAL FEDERAL FUNDS PROJECTS 78,891.00 263,837.22 140,000.00 ( 123,837.22) 188.5 TOTAL FUND EXPENDITURES 628,090.77 1,471,271.90 11,326,220.00 9,854,948.10 13.0 NET REVENUE OVER EXPENDITURES ( 174,891.11) ( 451,313.69) .00 451,313.69 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:27PM PAGE: 39 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 PUBLIC WORKS 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 ( 13,053.11) 23-0217-08-00 GARNISHMENTS ( 1,577.86) 23-0217-09-00 WORKERS' COMPENSATION 147,462.41 23-0217-10-00 HSA CONTRIBUTION ( 1,160.00) TOTAL LIABILITIES 134,296.90 FUND EQUITY 23-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 83,817.66 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 218,114.56) 83,817.66 ( 134,296.90) .00 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:28PM PAGE: 40 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 PUBLIC WORKS PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 23-0302-00-00 FUNDING FROM GENERAL FUND 560,350.91 1,626,958.18 2,884,511.00 1,257,552.82 56.4 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 5,250.00 22,291.00 17,041.00 23.6 23-0315-09-00 WYCLIFF PUMP STATION 13,463.38 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 .00 ( 997.98) 6,000.00 6,997.98 ( 16.6) TOTAL FUND REVENUE EXPENDITURES PERSONNEL 573,814.29 1,658,676.94 2,973,602.00 1,314,925.06 55.8 23-0433-10-00 SALARIES -FULL TIME 257,199.11 792,786.34 1,110,000.00 23-0433-10-01 SALARIES - PERSONNEL SERVICES .00 .00 125,000.00 23-0433-11-00 OVERTIME 5,293.74 9,948.47 20,000.00 23-0433-16-00 SALARIES -SEASONAL .00 509.31 .00 23-0433-21-00 FICA 19,705.74 60,171.79 87,500.00 23-0433-22-00 PERSI 29,834.28 90,702.68 135,500.00 23-0433-23-00 HRA BUY -DOWN .00 .00 7,700.00 23-0433-24-00 WORKERS' COMPENSATION .00 1,588.64 .00 23-0433-25-00 INSURANCE 49,778.14 149,133.25 227,500.00 23-0433-26-00 HSA CONTRIBUTION 1,500.00 4,500.00 4,800.00 23-0433-29-00 PTO CASH OUT 4,360.00 9,180.00 15,000.00 TOTAL PERSONNEL ADMINISTRATION 317,213.66 71.4 125,000.00 .0 10,051.53 49.7 509.31) .0 27,328.21 68.8 44,797.32 66.9 7,700.00 .0 1,588.64) .0 78,366.75 65.6 300.00 93.8 5,820.00 61.2 367, 671.01 1,118,520.48 1,733,000.00 614,479.52 64.5 23-0435-01-00 OFFICE SUPPLIES 225.95 428.71 1,000.00 571.29 42.9 23-0435-02-00 PRINT, PUBLISH, LEGAL, ADV .00 21.76 5,000.00 4,978.24 .4 23-0435-03-00 TRAINING, EDUCATION, TRVL, ETC 1,206.36 2,391.31 20,000.00 17,608.69 12.0 23-0435-04-00 DUES, CERTIFICATIONS, LICENSES 250.00 576.35 1,000.00 423.65 57.6 23-0435-09-00 STAFF AND PUBLIC RELATIONS 1,880.82 2,881.86 2,500.00 ( 381.86) 115.3 23-0435-10-00 SAFETY CLOTHING AND GEAR 645.40 4,017.79 6,500.00 2,482.21 61.8 TOTAL ADMINISTRATION IRRIGATION CONTRACTS/AGRMNTS 4,208.53 10,317.78 36,000.00 25,682.22 28.7 23-0437-01-00 WYCLIFFE PUMP STATION 5,112.79 6,087.78 6,690.00 602.22 91.0 23-0437-02-00 IRRIGATION SHARES AND DUES 847.50 19,733.10 20,000.00 266.90 98.7 23-0437-03-00 BASELINE MANAGER AGREEMENT 3,942.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 9,902.29 29,763.88 31,191.00 1,427.12 95.4 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:28PM PAGE: 41 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT GENERAL MTNC & REPAIR 23-0439-02-00 MISC MTNC & REPAIR GROUNDS 1,946.24 4,618.38 45,000.00 40,381.62 10.3 23-0439-02-01 MISC MTNC & REPAIR EQUIPMENT 3,300.97 6,898.72 20,000.00 13,101.28 34.5 23-0439-02-02 MISC MTNC & REPAIR BUILDINGS 2,506.08 11,264.74 10,000.00 ( 1,264.74) 112.7 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 4,639.25 19,622.25 50,000.00 30,377.75 39.2 23-0439-04-00 HOLIDAY LIGHTING .00 6,903.90 50,000.00 43,096.10 13.8 23-0439-05-00 CLEANING AND PAPER SUPPLIES 8,073.68 16,259.59 50,000.00 33,740.41 32.5 23-0439-06-00 SIGNS & SIGN REPLACEMENT 229.66 3,262.37 5,000.00 1,737.63 65.3 TOTAL GENERAL MTNC & REPAIR VEHICLES 20,695.88 76,099.95 305,000.00 228,900.05 25.0 23-0441-01-00 VEHICLE MTNC & REPAIR 9,009.67 27,550.94 35,000.00 7,449.06 78.7 23-0441-02-00 FUEL 11,475.89 22,955.40 45,000.00 22,044.60 51.0 TOTAL VEHICLES 20,485.56 50,506.34 80,000.00 29,493.66 63.1 FACILITIES 23-0443-01-00 CITY HALL 9,141.31 37,958.44 57,200.00 19,241.56 66.4 23-0443-02-00 LIBRARY 2,658.14 3,761.09 16,000.00 12,238.91 23.5 23-0443-03-00 MUSEUM .00 299.00 2,500.00 2,201.00 12.0 23-0443-04-00 CITY SHOP 1,964.22 5,126.60 10,000.00 4,873.40 51.3 23-0443-04-01 CITY SHOP UPGRADES, SV 57.76 603.61 10,000.00 9,396.39 6.0 23-0443-05-00 SENIOR CENTER 3,944.92 18,828.85 10,000.00 ( 8,828.85) 188.3 23-0443-06-00 JACKSON HOUSE 1,656.56 6,027.96 10,000.00 3,972.04 60.3 23-0443-07-00 LINDER ROAD RESTROOM 902.80 3,147.54 6,000.00 2,852.46 52.5 23-0443-15-00 STREET LIGHTS 10,019.53 24,655.74 43,000.00 18,344.26 57.3 TOTAL FACILITIES PARKS, MONUMENTS & GROUNDS 30,345.24 100,408.83 164,700.00 64,291.17 61.0 23-0445-01-00 ADA-EAGLE SPORTS PARK 8,210.25 21,183.78 36,400.00 15,216.22 58.2 23-0445-02-00 ARBORETUM PARK .00 .00 2,000.00 2,000.00 .0 23-0445-03-00 SV REGIONAL SPORTS COMPLEX .00 78.00 10,000.00 9,922.00 .8 23-0445-04-00 FLAG PLAZA 47.88 101.39 1,000.00 898.61 10.1 23-0445-05-00 FRIENDSHIP PARK 798.04 3,773.10 6,000.00 2,226.90 62.9 23-0445-06-00 GUERBER PARK 4,723.83 13,628.64 30,000.00 16,371.36 45.4 23-0445-07-00 HERITAGE PARK 548.71 1,617.83 7,500.00 5,882.17 21.6 23-0445-08-00 MACE PARKING AREA .00 .00 5,000.00 5,000.00 .0 23-0445-09-00 MCDONALD'S PATHWAY 45.35 201.27 2,000.00 1,798.73 10.1 23-0445-10-00 MERRILL PARK 5,805.92 8,516.70 29,000.00 20,483.30 29.4 23-0445-11-00 ORVAL KRASEN PARK 640.06 1,773.08 4,500.00 2,726.92 39.4 23-0445-12-00 PAMELA BAKER PARK 1,840.19 2,954.48 11,000.00 8,045.52 26.9 23-0445-13-00 PLAZA DRIVE .00 .00 4,000.00 4,000.00 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:28PM PAGE: 42 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 23-0445-14-00 TRAILS 23-0445-20-00 CITY ENTRANCE SIGNS 23-0445-30-00 LANDSCAPING, EQUIPMENT RENTAL 23-0445-30-01 LANDSCAPING, SPRAY/FERTILIZE 23-0445-30-03 LANDSCAPING, DUMPING/DISPOSAL TOTAL PARKS, MONUMENTS & GROUNDS MEMORIALS AND PROGRAMS PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT 1,568.22 2,136.10 59.26 10,709.49 266.17 2,434.67 5,107.24 1,257.38 15,163.42 1,289.64 11,500.00 9,065.33 21.2 15,000.00 9,892.76 34.1 15,000.00 13,742.62 8.4 35,000.00 19,836.58 43.3 5,000.00 3,710.36 25.8 37,399.47 79,080.62 229,900.00 150,819.38 34.4 23-0447-01-00 MEMORIALS, MTNC/REPAIR .00 1,635.00 6,000.00 4,365.00 27.3 23-0447-02-00 MATERIALS & SUPPLIES .00 243.05 1,000.00 756.95 24.3 23-0447-03-00 FLOWERS 10,652.62 10,767.97 20,000.00 9,232.03 53.8 23-0447-04-00 SANITATION AND RECYCLING 1,989.60 6,702.90 54,000.00 47,297.10 12.4 23-0447-05-00 TREES, PUBLIC DEVELOPMENT 6,206.31 20,233.66 29,511.00 9,277.34 68.6 23-0447-05-01 TREE VOUCHER PROGRAM 14,821.88 14,821.88 15,000.00 178.12 98.8 23-0447-05-02 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 TOTAL MEMORIALS AND PROGRAMS 33,670.41 54,404.46 125,811.00 71,406.54 43.2 FISCAL YEAR PROJECTS 23-0483-15-00 LANDSCAPE UPGRADES - PARKS 9,978.14 15,092.90 25,000.00 9,907.10 60.4 23-0483-20-01 TOOLS 231.11 2,273.04 5,000.00 2,726.96 45.5 23-0483-20-02 EQUIPMENT 38,391.00 38,391.00 85,000.00 46,609.00 45.2 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 48,600.25 55,756.94 268,000.00 212,243.06 20.8 TOTAL FUND EXPENDITURES 572,978.64 1,574,859.28 2,973,602.00 1,398,742.72 53.0 NET REVENUE OVER EXPENDITURES 835.65 83,817.66 .00 ( 83,817.66) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:28PM PAGE: 43 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 RECREATION - EAGLE FUN DAYS ASSETS 24-0101-00-00 CASH 1,651.16 TOTAL ASSETS 1,651.16 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES -YTD 1,651.16 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 1,651.16 1,651.16 1,651.16 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:28PM PAGE: 44 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 24-0301-00-00 FUNDING FROM GENERAL FUND 1,000.00 6,010.00 126,400.00 120,390.00 4.8 24-0303-00-00 SPONSORSHIPS 8,000.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 4,101.21 4,101.21 7,000.00 2,898.79 58.6 24-0303-05-00 ROCKY MOUNTAIN OYSTER FEED .00 .00 15,000.00 15,000.00 .0 24-0303-07-00 MISCELLANEOUS REVENUE 288.90 3,288.90 .00 ( 3,288.90) .0 TOTAL FUND REVENUE EXPENDITURES ADMIN EXPENDITURES 13,390.11 23,400.11 175, 700.00 152,299.89 13.3 24-0401-01-00 FUN DAYS CONTRACTS 9,878.95 19,878.95 60,000.00 40,121.05 33.1 24-0401-04-00 ADVERTISEMENT 1,100.00 1,100.00 10,000.00 8,900.00 11.0 24-0401-05-00 MUSIC & ENTERTAINMENT 700.00 700.00 .00 ( 700.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 LOGISTICS 11,678.95 21,678.95 86,800.00 65,121.05 25.0 24-0410-00-00 PORTA POTTIES .00 .00 5,000.00 5,000.00 .0 24-0410-02-00 TRAFFIC BARRIERS & CONTROL 60.00 60.00 22,000.00 21,940.00 .3 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 60.00 60.00 49,500.00 49,440.00 .1 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 .00 .00 10,000.00 10,000.00 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:28PM PAGE: 45 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 RECREATION - EAGLE FUN DAYS YTD ACTUAL BUDGET UNEXPENDED PCNT TOTAL ROCKY MOUNTAIN OYSTER FEED .00 .00 30,000.00 30,000.00 .0 TOTAL FUND EXPENDITURES 11,738.95 21,748.95 175,700.00 153,951.05 12.4 NET REVENUE OVER EXPENDITURES 1,651.16 1,651.16 .00 ( 1,651.16) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:28PM PAGE: 46 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 PATHWAY IMPACT FEE FUND ASSETS 25-0101-00-00 CASH 44,383.84 25-0151-25-00 INVESTMENTS 58,273.34 TOTAL ASSETS 102,657.18 LIABILITIES AND EQUITY FUND EQUITY 25-0271-00-00 FUND BALANCE 142,294.84 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 39,637.66) 39,637.66) 102,657.18 102,657.18 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:28PM PAGE: 47 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 PATHWAY IMPACT FEE FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 25-0322-19-00 PATHWAY DEVELOPMENT IMPACT FEE 64,778.00 121,293.50 82,625.00 ( 38,668.50) 146.8 25-0371-25-00 BANK INTEREST 678.63 2,419.38 1,000.00 ( 1,419.38) 241.9 25-0399-00-00 CARRY OVER .00 .00 139,900.00 139,900.00 .0 TOTAL FUND REVENUE EXPENDITURES CAPITAL IMPROVEMENTS 65,456.63 123,712.88 223,525.00 99,812.12 55.4 25-0438-00-00 CAPITAL IMPROVEMENTS 163,350.54 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 163,350.54 163,350.54 223,525.00 60,174.46 73.1 TOTAL FUND EXPENDITURES 163,350.54 163,350.54 223,525.00 60,174.46 73.1 NET REVENUE OVER EXPENDITURES ( 97,893.91) ( 39,637.66) .00 39,637.66 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:28PM PAGE: 48 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 LAW ENF DEV IMPACT FEES ASSETS 27-0101-00-00 CASH 7,098.05 27-0151-25-00 INVESTMENTS 155, 784.74 TOTAL ASSETS 162,882.79 LIABILITIES AND EQUITY FUND EQUITY 27-0271-00-00 POLICE IMPACT FEE/FUND BALANCE 116,197.61 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 46,685.18 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 46,685.18 162,882.79 162,882.79 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:29PM PAGE: 49 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 LAW ENF DEV IMPACT FEES PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 27-0322-19-00 RESIDENTIAL IMPACT FEES 22,521.44 42,907.41 27,750.00 ( 15,157.41) 154.6 27-0322-20-00 COMMERCIAL - IMPACT FEES .00 .00 30,000.00 30,000.00 .0 27-0371-25-00 BANK INTEREST 1,340.93 3,777.77 200.00 ( 3,577.77) 1888.9 27-0399-00-00 CARRY OVER .00 .00 100,000.00 100,000.00 .0 TOTAL FUND REVENUE EXPENDITURES CAPITAL IMPROVEMENTS 23,862.37 46,685.18 157,950.00 111,264.82 29.6 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 23,862.37 46,685.18 .00 ( 46,685.18) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:29PM PAGE: 50 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 REVENUE 54-0399-01-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES BOND PAYMENTS CITY HALL BOND FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT 450.00 6,959.41 104,750.00 97,790.59 6.6 450.00 6,959.41 104,750.00 97,790.59 6.6 54-0480-81-00 PRINCIPAL BOND PAYMENT .00 .00 90,000.00 90,000.00 .0 54-0480-82-00 INTEREST BOND PAYMENT .00 6,509.41 14,250.00 7,740.59 45.7 54-0480-84-00 PAYING AGENT FEE 450.00 450.00 500.00 50.00 90.0 TOTAL BOND PAYMENTS 450.00 6,959.41 104,750.00 97,790.59 6.6 TOTAL FUND EXPENDITURES 450.00 6,959.41 104,750.00 97,790.59 6.6 NET REVENUE OVER EXPENDITURES .00 .00 .00 .00 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:29PM PAGE: 51 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 WATER FUND ASSETS 60-0101-00-00 CASH 535,286.28 60-0115-00-00 ACCOUNTS RECEIVABLE 137,538.48 60-0151-25-00 INVESTMENTS, WATER SYSTEM 7,932,385.38 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 21,999,096.22 LIABILITIES AND EQUITY LIABILITIES 60-0202-00-00 WATER/VOUCHERS PAYABLE 60-0204-00-00 WATER/LEXINGTON-TVV 60-0215-00-00 INTEREST PAYABLE 60-0216-00-00 ACCRUED PAYROLL 60-0217-00-00 COMPENSATED ABSENCE PAYABLE 60-0217-03-00 FICA 60-0217-04-00 PERSI RETIREMENT 60-0217-07-00 INSURANCE 60-0217-08-00 GARNISHMENTS 60-0217-09-00 WORKERS' COMPENSATION 60-0217-10-00 HSA CONTRIBUTION 60-0217-11-00 NET PENSION LIABILITY 60-0220-00-00 SERVICE DEPOSITS, WATER 60-0220-01-00 SERVICE DEPOSITS, HYDRANT MTR 60-0231-00-00 DEQ LOAN ( ( 227.00) 1,787.89 1,933.00 6,081.88 12,420.00 1,542.82 2,618.32 9,052.23 1,162.50 71,563.06 100.00) 325,075.00 86,875.00 600.00 118,942.00 TOTAL LIABILITIES 639,326.70 FUND EQUITY 60-0271-00-00 WATER/FUND BALANCE 19,623,429.73 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,736,339.79 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 1,736,339.79 21,359,769.52 21,999,096.22 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:29PM PAGE: 52 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 WATER FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 60-0346-59-00 STL-STORAGE & TRUNK LINE FEE 1,296,633.27 1,508,027.19 105,000.00 ( 1,403,027.19) 1436.2 60-0346-60-00 HOOK UP FEES CITY 113,730.00 255,335.00 172,050.00 ( 83,285.00) 148.4 60-0346-62-00 PROFESSIONAL SERV - DEVELOPERS 10,211.05 20,190.69 50,000.00 29,809.31 40.4 60-0346-63-00 STAFF TIME REIMB - DEVELOPERS .00 552.00 5,000.00 4,448.00 11.0 60-0347-01-00 BILLING REVENUE 420,548.00 1,162,988.30 1,322,000.00 159,011.70 88.0 60-0347-02-00 OTHER REVENUE 2,925.13 5,924.36 4,120.00 ( 1,804.36) 143.8 60-0347-03-00 RECONNECT FEES 75.00 175.00 300.00 125.00 58.3 60-0347-04-00 DELINQUENT FEES 3,225.00 8,904.00 12,000.00 3,096.00 74.2 60-0347-05-00 MISCELLANEOUS REVENUE 2,078.60 4,196.58 12,000.00 7,803.42 35.0 60-0347-06-00 SYSTEM ENHANCEMENT FEE 2.93 209.09 100,000.00 99,790.91 .2 60-0355-01-00 WCE-WATER CONST EQUIV FEE 33,200.00 69,600.00 20,000.00 ( 49,600.00) 348.0 60-0371-25-00 BANK INTEREST 84,822.21 230,607.00 10,000.00 ( 220,607.00) 2306.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 EXPENDITURES VEHICLE OPERATIONS - LEASES 1,967,451.19 3,266,709.21 4,954,400.00 1,687,690.79 65.9 60-0420-01-00 GAS AND OIL 2,388.61 60-0420-03-00 VEHICLE MTNC & REPAIR 146.86 5,018.57 15,000.00 4,122.65 10, 000.00 9,981.43 33.5 5,877.35 41.2 TOTAL VEHICLE OPERATIONS - LEASES 2,535.47 PERSONNEL 9,141.22 25,000.00 15,858.78 36.6 60-0433-10-00 SALARIES - FULL TIME 85,654.83 266,460.33 426,500.00 160,039.67 62.5 60-0433-10-02 ON -CALL TIME 940.93 2,431.04 7,500.00 5,068.96 32.4 60-0433-11-00 OVERTIME 1,267.22 2,373.15 4,500.00 2,126.85 52.7 60-0433-21-00 FICA 6,561.10 20,371.00 33,500.00 13,129.00 60.8 60-0433-22-00 PERSI 9,660.27 30,398.90 52,500.00 22,101.10 57.9 60-0433-23-00 HRA BUY -DOWN .00 342.32 3,080.00 2,737.68 11.1 60-0433-23-01 HRA/COBRAADMIN 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 9,438.56 33,431.51 59,310.00 25,878.49 56.4 60-0433-26-00 HSA CONTRIBUTION 400.00 1,600.00 2,400.00 800.00 66.7 60-0433-29-00 PTO CASH OUT .00 2,300.00 10,000.00 7,700.00 23.0 TOTAL PERSONNEL 113,922.91 370,047.45 617,190.00 247,142.55 60.0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:29PM PAGE: 53 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT OPERATIONS & MAINTENANCE 60-0434-15-00 OFFICE SUPPLIES 55.40 639.16 2,000.00 1,360.84 32.0 60-0434-19-00 TELECOMMUNICATIONS/SCADA 2,468.17 8,163.49 17,000.00 8,836.51 48.0 60-0434-20-00 ADVERTISING - PUBLICATIONS .00 294.66 1,500.00 1,205.34 19.6 60-0434-22-00 TRAVEL-MTNGS-EDUCATION 11.66 4,090.66 8,000.00 3,909.34 51.1 60-0434-23-00 DUES & SUBSCRIPTIONS 665.00 871.00 3,000.00 2,129.00 29.0 60-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE .00 6,442.71 8,000.00 1,557.29 80.5 60-0434-26-00 TOOLS, EQUIPMENT AND SUPPLIES 1,111.19 1,761.75 20,000.00 18,238.25 8.8 60-0434-26-01 EQUIPMENT RENTAL .00 .00 10,000.00 10,000.00 .0 60-0434-27-00 POSTAGE 14.50 14.50 1,300.00 1,285.50 1.1 60-0434-41-00 LIABILITY INSURANCE .00 4,000.00 5,900.00 1,900.00 67.8 60-0434-42-00 ENGINEERING SERVICES 5,336.32 19,200.04 35,000.00 15,799.96 54.9 60-0434-42-01 LEGAL SERVICES 472.50 1,277.50 25,000.00 23,722.50 5.1 60-0434-42-02 MISC LEGAL AND ENG SERVICES 1,209.85 5,570.85 100,000.00 94,429.15 5.6 60-0434-42-03 PROFESSIONAL SERV - DEVELOPERS 20,080.80 30,058.87 50,000.00 19,941.13 60.1 60-0434-43-01 CONTRACT SERVICES (REPAIR) .00 .00 35,000.00 35,000.00 .0 60-0434-44-00 DIG LINE 1,209.00 2,688.61 4,500.00 1,811.39 59.8 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 7,196.33 19,069.79 31,500.00 12,430.21 60.5 60-0434-50-01 SHOP UTILITIES 791.32 2,127.17 5,100.00 2,972.83 41.7 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 1,923.87 3,565.68 40,000.00 36,434.32 8.9 60-0434-58-01 RPR/MTNC PUMPS -WELLS -CHEMICAL 4,367.76 11,495.72 40,000.00 28,504.28 28.7 60-0434-59-00 CHEMICALS 5,170.14 7,212.53 13,500.00 6,287.47 53.4 60-0434-60-00 UTILITIES 15,089.56 36,483.07 110,000.00 73,516.93 33.2 60-0434-68-00 UNIFORMS AND SAFETY CLOTHING 657.85 1,176.03 2,300.00 1,123.97 51.1 60-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 .00 25,000.00 25,000.00 .0 TOTAL OPERATIONS & MAINTENANCE TE STI NG-W K-MO-QTR-ANNUAL 67,831.22 183,035.79 617,600.00 434,564.21 29.6 60-0435-56-00 TESTING-WK-MO-QTR-ANNUAL 590.00 2,175.00 40,000.00 37,825.00 5.4 TOTAL TESTING-WK-MO-QTR-ANNUAL 590.00 2,175.00 40,000.00 37,825.00 5.4 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 975.55 20,001.74 400,000.00 379,998.26 5.0 60-0437-99-01 RESERVES, STL FEES .00 .00 1,255,000.00 1,255,000.00 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:29PM PAGE: 54 TOTAL STL FEES, RESTRICTED CAPITAL EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT 975.55 774,634.54 1,905,000.00 1,130,365.46 40.7 60-0438-01-00 EQUIPMENT 5,300.12 5,300.12 85,500.00 80,199.88 6.2 60-0438-08-00 METER SETS, NEW CUSTOMERS 42,272.33 55,799.65 99,200.00 43,400.35 56.3 60-0438-11-00 CAPITAL CONSTRUCTION PROJECTS .00 .00 157,500.00 157,500.00 .0 60-0438-82-00 CITY HALL ADMIN OVERHEAD .00 9,027.00 13,410.00 4,383.00 67.3 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 47,572.45 70,126.77 1,649,610.00 1,579,483.23 4.3 TOTAL FUND EXPENDITURES 233,427.60 1,530,369.42 4,954,400.00 3,424,030.58 30.9 NET REVENUE OVER EXPENDITURES 1,734,023.59 1,736,339.79 .00 ( 1,736,339.79) .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:29PM PAGE: 55 CITY OF EAGLE BALANCE SHEET JUNE 30, 2024 FIBER FUND ASSETS 61-0101-00-00 CASH 61-0151-25-00 INVESTMENTS, FIBER SYSTEM 61-0166-00-00 MACHINERY AND EQUIPMENT 61-0171-00-00 DEFERRED OUTFLOWS -PENSION 34,459.52 854,276.81 3,063,174.00 28,742.00 TOTAL ASSETS 3,980,652.33 LIABILITIES AND EQUITY LIABILITIES 61-0217-07-00 INSURANCE 61-0217-08-00 GARNISHMENTS 61-0217-09-00 WORKERS' COMPENSATION 61-0217-11-00 NET PENSION LIABILITY 3,134.51 519.20 3,048.37 72,649.00 TOTAL LIABILITIES 79,351.08 FUND EQUITY 61-0271-00-00 FUND BALANCE 4,444,473.58 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 543,172.33) 543,172.33) 3,901,301.25 3,980,652.33 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:29PM PAGE: 56 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 FIBER FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT 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 3,736.49 21,171.15 10,000.00 ( 11,171.15) 211.7 61-0398-00-00 ARPACARRYOVER .00 .00 1,593,580.00 1,593,580.00 .0 TOTAL FUND REVENUE EXPENDITURES PERSONNEL 3,736.49 21,171.15 1,823,550.00 1,802,378.85 1.2 61-0433-10-00 SALARIES - FULL TIME 29,438.00 104,010.76 351,900.00 247,889.24 29.6 61-0433-10-02 ON -CALL TIME .00 .00 7,500.00 7,500.00 .0 61-0433-11-00 OVERTIME 764.08 6,734.14 7,500.00 765.86 89.8 61-0433-21-00 FICA 2,288.87 8,551.39 27,500.00 18,948.61 31.1 61-0433-22-00 PERSI 3,365.42 12,593.62 42,100.00 29,506.38 29.9 61-0433-23-00 HRABUY-DOWN .00 .00 1,540.00 1,540.00 .0 61-0433-23-01 HRA/COBRAADMIN 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,966.00 13,686.64 53,500.00 39,813.36 25.6 61-0433-26-00 HSA CONTRIBUTION 75.00 200.00 2,400.00 2,200.00 8.3 61-0433-29-00 PTO CASH OUT .00 2,000.00 1,000.00 ( 1,000.00) 200.0 TOTAL PERSONNEL OPERATIONS & MAINTENANCE 39,897.37 149,121.81 503,240.00 354,118.19 29.6 61-0434-15-00 OFFICE SUPPLIES .00 .00 500.00 500.00 .0 61-0434-19-00 TELECOMMUNICATIONS 409.75 902.32 2,500.00 1,597.68 36.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 145.85 2,500.00 2,354.15 5.8 61-0434-26-00 TOOLS, EQUIPMENT AND SUPPLIES 2,107.10 6,930.66 12,500.00 5,569.34 55.5 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 27,171.24 100,571.24 150,000.00 49,428.76 67.1 61-0434-42-01 LEGAL SERVICES 1,400.00 3,330.00 10,000.00 6,670.00 33.3 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 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:29PM PAGE: 57 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2024 FIBER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT 61-0434-50-01 SHOP UTILITIES 190.74 366.82 7,500.00 61-0434-53-03 PERMITS AND FEES .00 .00 2,500.00 61-0434-55-00 CASELLE SUPPORT .00 .00 1,500.00 61-0434-56-00 GAS AND OIL 1,917.99 3,027.75 10,000.00 61-0434-57-00 REPAIR AND MAINT, VEHICLE 1,321.06 2,788.36 25,000.00 61-0434-58-00 REPAIR AND MAINT, GROUND WORK .00 .00 50,000.00 61-0434-58-01 REPAIR AND MAINT, EQUIPMENT 3,917.99 11,966.42 50,000.00 61-0434-58-02 REPAIR AND MAINT, BUILDINGS .00 222.11 .00 61-0434-59-00 REPAIR AND MAINT, EMERGENCIES .00 .00 75,000.00 61-0434-59-01 MATERIALS 26,373.61 273,991.75 425,000.00 61-0434-60-00 UTILITIES .00 1,174.06 .00 61-0434-68-00 UNIFORMS AND SAFETY CLOTHING .00 140.33 2,000.00 61-0434-69-00 CITY HALL ADMIN OVERHEAD .00 3,609.00 4,810.00 61-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 .00 20,000.00 TOTAL OPERATIONS & MAINTENANCE CAPITAL EXPENDITURES 7,133.18 4.9 2,500.00 .0 1,500.00 .0 6,972.25 30.3 22,211.64 11.2 50,000.00 .0 38,033.58 23.9 222.11) .0 75,000.00 .0 151,008.25 64.5 1,174.06) .0 1,859.67 7.0 1,201.00 75.0 20,000.00 .0 64,809.48 415,221.67 1,105,310.00 690,088.33 37.6 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 104,706.85 564,343.48 1,823,550.00 1,259,206.52 31.0 NET REVENUE OVER EXPENDITURES ( 100,970.36) ( 543,172.33) .00 543,172.33 .0 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/11/2024 06:30PM PAGE: 58