Loading...
Finance - Quarterly Reports - FY 23/24 2nd Quarter - 03/31/20240 Ce 013. 2 Lu• a w" I.fiZ o a w CO UQw W I- a W L2 r O U- ENDING CASH CHANGE IN W 0 Z J BALANCE SHEET a J o Q Z z W z a < X BEGINNING CASH EXPENDITURES REVENUES W 0 Z J FUND NUMBER AND TITLE 0) 0 0 (r) V 0 0 0 0 0 0 N 0 0 co 0 V CO CS) CO Q. Q. N O O O O O O CO O O CO (O O O CO O N (O O N- 66 0) 01 01 Mco (so co (O 0�) lf) M • 01 CO CO- N M M I- 01 0) (O 0) 4-N co u) 0) M 00 0) 4-o0 cO 0 co O (p Cr- N- CO' Co- N 0 0) co 0 Co- 01 U) co. O V O O 01 M (D O) co co N 0 N 0 Ni lO 01 I. M (O N N CO criN N. co L() r M 01 0 CO LN.O Ni M CO lO CO M CO I� (O N. (0 N 0) (NI V CO CO 00 M .— . M N M 0 U) M 17- 01 N N N N 0 0 0) V 0) N O M N V 0) 0 0 0 CO 0 N- O lf) M CO N CO N O V (O O. O. N N O M cO c0 Ni O O N- 0) cO N- M U) (O (O lf) co co N V M V V M M M M N N 3,924,546.18 M (O V V N V N U) U) N N M CO N— O (O M V CO- lf) M N N I- O U) M 221,165.80 (.0M 0) N.O 0 O N M 0 co Ni co co O O O Tr op (.0O V ▪ N V 0) ▪ (O O O N N- I� N r O (O O lO I� U) 01 M I� M I� O (O I� N (O V U) CO CO lf) N N M V CO N N V (O 0 M V CO M (O 0 CO 0 (O U) N (.0 0 N- V lO V V V N lO CO 0) O V N- O V N N 0) O lf) V O O M O cO N- 0) (O lf) (O lf) (O V (O (O co co V V M V M M M M M N N 5,314,296.18 N (.0 (O (0 N— (O (O M N— V M 0) 0 0) N N 0) O ✓ Ni co u4 .— co 4- Ni Ni lO lO lO O N— N- 4-0) O O N- N: 0) N: (0 N (O CO (O N- CO 0) O 0) 0) 0) lO N M CO N— (O 0 M 0) N— N- 01 O O M 0) (O M lO M lO lO lO N- N 0 0 CO lO 0) 0) (O O N- O lO M 01 (V 01 V O r (O 0) (O V r N N— U N— O U M (O V N N O O1 M N N N N V lO M 0 M CON0 0 0 0 0 0 0 M 0 0 CO N 0 CO ((0 COM 0 N- � 0) 0 00 N W 0) (o 4- N co V 0) co co lO V V N- N 0) 00 O N. N. 0) In Ci N CO- N N .— O CO- LO- CO 4- N- co .— N CO N. GENERAL FUND LIBRARY FUND MUSEUM FUND PARK IMPACT FEE FUND CO O 0 • 0 0 09 RECREATION - SPECIAL EVENTS EXECUTIVE DEPARTMENT ✓ z W ce a w 0 a w I Ui W 0 V cd M r 7,452 ,158.99 8,247,597.44 (0 IE E IE F I I M V N- CO 0) M V lO N- V 0 0) N N N N lO CO (O 0) U C a) a) CCS To U C (B C a) 0 CCS a) O U) O U a) L 0 C O Q Q U) D a) CCS a) a) L U a) Q U) C 0 D a) .0 N CCS C a) N U Idaho Code 50-1011 c7 co an co 0 0 0 N 2 CU a) O) W U C O U a) U) a) Q C O U O ( - a O � 0 • W • O (1) L u • U Y 04/16/2024 50 % 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 MARCH 31, 2024 1,435,405.69 454,423.40 1,889,829.09 ( 1,889,829.09) 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 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 946,312.99 172,656.73 3,360.14 63,617.32 57,956.38 9,576.61 499,369.04 136,979.88 1,889,829.09 ( 1,889,829.09) ZERO PROOF IF ALLOCATIONS BALANCE .00 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:21AM PAGE: 1 CITY OF EAGLE BALANCE SHEET MARCH 31, 2024 GENERAL FUND ASSETS 01-0101-00-00 CASH 946,312.99 01-0103-00-00 PETTY CASH 150.00 01-0107-00-00 TAXES RECEIVABLE DELINQUENT 22,574.55 01-0115-00-00 ACCOUNTS RECEIVABLE 58,710.66 01-0132-00-00 DUE FROM OTHER GOVERNMNTL UNTS 922,768.40 01-0151-25-00 INVESTMENTS 8,301, 744.06 01-0151-28-00 ICCU CD 53,106.63 01-0151-30-00 ITD, AVIMOR, FEE INVESTMENTS 40,138.19 01-0170-00-00 HRA 10 % DEPOSIT 5,785.92 TOTAL ASSETS 10,351,291.40 LIABILITIES AND EQUITY LIABILITIES 01-0202-00-00 VOUCHERS PAYABLE ( 831.35) 01-0203-00-00 ACCTS PAYABLE-ACHD IMPACT FEES 92,523.00 01-0203-01-01 BONDS/SURETIES/DEPOSITS PYBLE 1,049,378.03 01-0203-01-03 VENDORS BOND DEPOSITS PAYABLE 2,000.00 01-0203-01-05 P&Z DEPOSITS PAYABLE 503,459.63 01-0203-01-06 LAND USE DEPOSITS PAYABLE 53,106.63 01-0217-07-00 INSURANCE ( 10,838.25) 01-0217-07-01 COBRA INSURANCE ( 2,489.44) 01-0217-09-00 WORKERS' COMPENSATION 5.52 01-0220-02-00 ITD, AVIMOR, DEPOSITS 40,138.19 01-0226-00-00 DEFERRED REVENUE 20,335.95 TOTAL LIABILITIES 1,746,787.91 FUND EQUITY 01-0271-00-00 FUND BALANCE 8,175,506.02 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 428,997.47 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 428,997.47 8,604,503.49 10,351,291.40 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:21AM PAGE: 2 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 GENERAL FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 01-0311-00-00 PROPERTY TAX 3,063,445.05 3,066,969.69 4,762,920.00 1,695,950.31 64.4 01-0311-01-00 PENALTY/INTEREST ON TAXES 1,793.50 2,129.63 4,500.00 2,370.37 47.3 01-0312-00-00 PERSONAL PROPERTY TAX REIMBURS 5,151.05 5,151.05 8,463.00 3,311.95 60.9 01-0316-10-02 FRANCHISE FEE, VEOLIA 9,929.08 21,148.97 30,000.00 8,851.03 70.5 01-0316-11-00 FRANCHISE FEE, INTERMTN GAS 91,236.29 133,552.72 350,000.00 216,447.28 38.2 01-0316-12-00 FRANCHISE FEE, CABLE TV 21,818.80 44,778.64 115,000.00 70,221.36 38.9 01-0316-13-00 FRANCHISE FEE, SOLID WASTE 93,800.92 184,310.99 350,000.00 165,689.01 52.7 01-0316-14-00 FRANCHISE FEE, IDAHO POWER 58,248.61 150,864.38 250,000.00 99,135.62 60.4 01-0321-10-00 BUSINESS, ALCOHOL, MISC-LCNSES 6,098.05 10,029.73 56,500.00 46,470.27 17.8 01-0322-10-00 BUILDING & INSPECTION PERMITS 286,644.83 664,182.70 1,025,000.00 360,817.30 64.8 01-0322-12-00 BUILDING, PLAN REVIEW FEES 116,677.09 259,770.70 478,750.00 218,979.30 54.3 01-0322-13-00 ENERGY STANDARDS (I RES) 4,000.00 9,450.00 12,500.00 3,050.00 75.6 01-0322-14-00 ELECTRICAL PERMIT FEES 59,353.36 124,810.28 200,000.00 75,189.72 62.4 01-0322-15-00 PLUMBING PERMIT FEES 38,287.17 94,347.53 184,000.00 89,652.47 51.3 01-0322-16-00 MECHANICAL PERMIT FEES 76,326.91 135,178.06 184,000.00 48,821.94 73.5 01-0322-20-00 ADMIN FEES, FIRE & ITD AVIMOR 1,480.00 3,580.00 5,000.00 1,420.00 71.6 01-0323-01-00 PZANNEX/ZONING PERMIT FEES 33,319.61 114,412.54 85,000.00 ( 29,412.54) 134.6 01-0323-02-00 PLANNING INSPECTION FEES 2,650.00 8,100.00 5,000.00 ( 3,100.00) 162.0 01-0323-03-00 PLANNING, PLAN REVIEW FEES 9,000.00 16,250.00 20,000.00 3,750.00 81.3 01-0323-04-00 STREET LIGHT INSPECTION FEES 360.00 1,090.00 800.00 ( 290.00) 136.3 01-0323-05-00 SURETY/LETTER OF CREDIT FEES 1,200.00 3,450.00 4,000.00 550.00 86.3 01-0323-06-00 GRADING -DRAINAGE PERMIT FEES 1,500.00 2,681.25 6,000.00 3,318.75 44.7 01-0323-10-00 SPRING VALLEY STAFF TIME REIMB 1,228.50 2,961.00 10,000.00 7,039.00 29.6 01-0323-11-00 AVIMOR STAFF TIME REIMBURSE 756.00 1,575.00 10,000.00 8,425.00 15.8 01-0335-10-00 STATE, LIQUOR DISTRIBUTION 136,484.00 136,484.00 665,000.00 528,516.00 20.5 01-0335-50-00 COUNTY, AG EQUIPMENT REPL TAX 4.75 9.50 19.00 9.50 50.0 01-0335-60-00 STATE, SALES TAX REV SHARING 844,660.61 1,759,808.03 3,914,826.00 2,155,017.97 45.0 01-0338-40-00 COURT FEES 24,600.02 44,531.13 55,000.00 10,468.87 81.0 01-0338-41-00 CITATION FEES/CODE ENFORCEMENT .00 .00 500.00 500.00 .0 01-0338-42-00 NUISANCE ABATEMENT .00 .00 1,000.00 1,000.00 .0 01-0341-12-00 ANIMAL CONTROL FEES 2,155.00 6,600.50 12,000.00 5,399.50 55.0 01-0341-13-00 ENGINEERING FEES - DEVELOPERS 36,166.88 119,948.68 175,000.00 55,051.32 68.5 01-0341-14-00 ATTORNEY FEES - DEVELOPERS 2,992.50 10,937.50 30,000.00 19,062.50 36.5 01-0341-17-00 CID STAFF & MISC REIMBURSEMENT 665.63 2,048.91 .00 ( 2,048.91) .0 01-0341-20-00 REIMBURSE FROM WATER DEPT 6,018.00 9,027.00 13,410.00 4,383.00 67.3 01-0341-20-01 REIMBURSE FROM FIBER DEPT 2,406.00 3,609.00 5,000.00 1,391.00 72.2 01-0341-26-00 BACKGROUND CHECKS 329.25 429.00 1,500.00 1,071.00 28.6 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 1,000.00 1,000.00 1,000.00 .00 100.0 01-0350-02-00 IDAHO OPIOID SETTLEMENT 9,463.74 10,070.04 15,000.00 4,929.96 67.1 01-0350-05-00 FIELD OF HONOR 530.00 530.00 25,000.00 24,470.00 2.1 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 97,185.61 190,614.33 25,000.00 ( 165,614.33) 762.5 01-0379-00-00 MISCELLANEOUS REVENUE 2,163.70 7,926.06 1,000.00 ( 6,926.06) 792.6 01-0379-01-00 DUPLICATION/PUBLISHING/PRINTNG .00 .00 500.00 500.00 .0 01-0383-05-00 MISCELLANEOUS-REIMBURSEABLES 3,748.22 5,378.03 1,500.00 ( 3,878.03) 358.5 01-0383-09-00 ROOM RESERVATIONS 1,214.00 3,519.86 4,000.00 480.14 88.0 01-0383-16-00 INSURANCE REIMBURSEABLES 1,360.18 1,758.18 .00 ( 1,758.18) .0 01-0385-00-00 FIRE DEPT IMPACT FEES 156,843.27 281,781.59 224,250.00 ( 57,531.59) 125.7 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:21AM PAGE: 3 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 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 5,314,296.18 7,656,786.20 21,443,538.00 13,786,751.80 35.7 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:21AM PAGE: 4 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 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,230.00 1,880.00 4,300.00 2,420.00 43.7 01-0413-02-00 DESIGN REVIEW BRD COMPENSATION 900.00 1,300.00 5,000.00 3,700.00 26.0 01-0413-05-00 OFFICE SUPPLIES 3,878.34 7,611.92 25,000.00 17,388.08 30.5 01-0413-06-00 PRINTING & DISTRIBUTION .00 .00 500.00 500.00 .0 01-0413-07-00 POSTAGE 2,424.80 3,584.74 12,500.00 8,915.26 28.7 01-0413-08-00 LEGAL ADVERTISING/PUBLICATION 970.68 1,889.05 5,000.00 3,110.95 37.8 01-0413-10-00 INSURANCE - PROPERTY .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 4,297.50 39,990.60 153,000.00 113,009.40 26.1 01-0413-25-00 MISCELLANEOUS 476.36 466.05 20,000.00 19,533.95 2.3 01-0413-28-00 RESOURCE MATERIALS 318.93 318.93 6,500.00 6,181.07 4.9 01-0413-29-00 REAL PROPERTY TAXES - CITY .00 339.50 400.00 60.50 84.9 01-0413-31-00 ENGINEERING FEES - DEVELOPERS 80,558.03 132,413.38 175,000.00 42,586.62 75.7 01-0413-33-00 ATTORNEY FEES - DEVELOPERS 3,272.50 5,337.50 30,000.00 24,662.50 17.8 01-0413-37-00 BACKGROUND CHECK-PERMITS/LIC 365.75 565.25 2,500.00 1,934.75 22.6 01-0413-44-00 PHOTOS - MAYOR/CITY COUNCIL 192.26 192.26 900.00 707.74 21.4 01-0413-50-00 JOB POSTINGS 299.00 299.00 2,500.00 2,201.00 12.0 01-0413-51-00 BACKGROUND CHK, PRE -EMPLOYMENT 539.00 592.25 1,000.00 407.75 59.2 01-0413-52-00 DRUG TESTING, PRE -EMPLOYMENT 245.00 455.00 1,000.00 545.00 45.5 TOTAL ADMINISTRATION PERSONNEL 99,968.15 269,893.43 532,100.00 262,206.57 50.7 01-0415-11-00 SALARIES - COUNCIL 16,224.96 28,944.96 65,000.00 36,055.04 44.5 01-0415-21-00 FICA 1,241.28 2,214.36 5,000.00 2,785.64 44.3 01-0415-22-00 PERSI 1,813.92 3,236.04 7,775.00 4,538.96 41.6 01-0415-23-01 HRA/COBRAADMIN FEES 379.05 624.65 1,800.00 1,175.35 34.7 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,659.21 102,000.24 153,275.00 51,274.76 66.6 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:21AM PAGE: 5 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT CONTRACTS & AGREEMENTS 01-0416-02-00 CITY ATTORNEY 70,184.21 102,776.71 250,000.00 147,223.29 41.1 01-0416-05-00 PROSECUTOR -ADA, BOISE, GEM 32,306.23 64,545.82 129,000.00 64,454.18 50.0 01-0416-06-00 IDAHO HUMANE SOCIETY 42,927.41 85,854.92 171,800.00 85,945.08 50.0 01-0416-07-00 CITY ENGINEERING 97.50 97.50 20,000.00 19,902.50 .5 01-0416-08-00 CITY AUDITOR SERVICES 16,850.00 16,850.00 22,300.00 5,450.00 75.6 01-0416-09-00 LAW ENFORCEMENT DEPARTMENT 1,511,403.32 2,267,104.98 4,232,000.00 1,964,895.02 53.6 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 8,874.50 17,800.00 8,925.50 49.9 01-0416-49-00 DRUGFREE IDAHO 516.46 967.59 2,000.00 1,032.41 48.4 01-0416-54-00 IDAHO SUICIDE PREVENTION 10,000.00 10,000.00 10,000.00 .00 100.0 01-0416-56-00 CRIME STOPPERS 3,500.00 3,500.00 3,520.00 20.00 99.4 TOTAL CONTRACTS & AGREEMENTS CODE ENFORCEMENT 1,692,222.38 2,560,572.02 6,458,420.00 3,897,847.98 39.7 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 288.00 288.00 25,000.00 24,712.00 1.2 01-0422-15-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 TOTAL RESTRICTED 288.00 288.00 44,000.00 43,712.00 .7 PUBLIC AFFAIRS/COMM RELATIONS 01-0462-01-00 PUBLIC RELATIONS 1,476.31 2,115.89 6,000.00 3,884.11 35.3 01-0462-02-00 AWARDS & RECOGNITIONS .00 89.90 1,500.00 1,410.10 6.0 TOTAL PUBLIC AFFAIRS/COMM RELATIONS 1,476.31 2,205.79 7,500.00 5,294.21 29.4 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:21AM PAGE: 6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT GENERAL FUND TRANSFERS 01-0463-01-00 MUSEUM DEPT TRANSFER 10,231.34 20,746.98 180,610.00 159,863.02 11.5 01-0463-05-00 SPECIAL EVENTS TRANSFER 2,713.82 29,465.04 38,075.00 8,609.96 77.4 01-0463-06-00 RECREATION PARKS-REC TRANSFER 83,221.95 247,414.50 807,120.00 559,705.50 30.7 01-0463-07-00 CAPITAL PROJECTS TRANSFER 129,296.72 129,296.72 2,998,200.00 2,868,903.28 4.3 01-0463-08-00 EAGLE FUN DAYS TRANSFER 5,010.00 5,010.00 126,400.00 121,390.00 4.0 01-0463-11-00 PUBLIC WORKS TRANSFER 471,964.21 1,066,607.27 2,884,511.00 1,817,903.73 37.0 01-0463-11-01 EXECUTIVE DEPT TRANSFER 105,116.11 221,347.93 662,430.00 441,082.07 33.4 01-0463-12-00 CITY HALL BOND FUND TRANSFER 6,509.41 6,509.41 104,750.00 98,240.59 6.2 01-0463-12-01 CLERK/TREAS DEPT TRANSFER 153,165.36 326,175.28 810,700.00 484,524.72 40.2 01-0463-13-01 BUILDING DEPT TRANSFER 219,306.46 407,701.62 1,068,860.00 661,158.38 38.1 01-0463-14-01 PLANNING AND ZONING DEPT TRANS 231,538.23 484,069.61 1,288,000.00 803,930.39 37.6 01-0463-15-00 LIBRARY TRANSFER 304,282.71 548,452.69 1,672,392.00 1,123,939.31 32.8 01-0463-18-01 IT DEPT TRANSFER 249,517.54 445,134.61 1,204,530.00 759,395.39 37.0 TOTAL GENERAL FUND TRANSFERS COMMUNITY PROJECTS -CAP OUTLAY 1,971,873.86 3,937,931.66 13,846,578.00 9,908,646.34 28.4 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 139,058.27 225,735.59 224,250.00 ( 1,485.59) 100.7 TOTAL FIRE DEPARTMENT IMPACT FEES 139,058.27 225,735.59 224,250.00 ( 1,485.59) 100.7 TOTAL FUND EXPENDITURES 3,924,546.18 7,227,788.73 21,443,538.00 14,215,749.27 33.7 NET REVENUE OVER EXPENDITURES 1,389,750.00 428,997.47 .00 ( 428,997.47) .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:22AM PAGE: 7 CITY OF EAGLE BALANCE SHEET MARCH 31, 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,500.62 17,055.43 2,454.00 1,048.03 TOTAL LIABILITIES 64,648.90 FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 61,700.90) 61, 700.90) 61, 700.90) 2,948.00 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:22AM PAGE: 8 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 REVENUE 06-0301-00-00 FUNDING FROM GENERAL FUND 06-0356-00-00 LIBRARY/PROPERTY TAX REVENUE 06-0356-01-00 LIBRARY/PENALTY & INT PROP TXS 06-0361-20-00 LIBRARY, FINES, FEES 06-0361-20-01 LOST ITEMS 06-0361-21-00 LIBRARY COPY MACHINE 06-0361-21-01 3 D PRINTING 06-0379-00-00 MISCELLANEOUS REVENUE 06-0379-01-00 MISCELLANEOUS REV NON TAXABLE 06-0380-01-00 GRANTS 06-0380-03-00 SPONSORSHIPS TOTAL FUND REVENUE EXPENDITURES CONTRACTS/AGREEMENTS 06-0416-01-00 LEGAL - CITY ATTORNEY 06-0416-02-00 PHOTOCOPIERS TOTAL CONTRACTS/AGREEMENTS OPERATIONS & MAINTENANCE LIBRARY FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT ( 304,282.71 548,452.69 1,672,392.00 1,123,939.31 32.8 2,789.52 2,789.52 .00 ( 2,789.52) .0 357.90 357.90 .00 ( 357.90) .0 941.15 1,648.19 1,000.00 ( 648.19) 164.8 2,017.46 3,907.44 2,500.00 ( 1,407.44) 156.3 685.50 1,301.86 1,200.00 ( 101.86) 108.5 .10) 1.51 .00 ( 1.51) .0 332.68 788.68 750.00 ( 38.68) 105.2 250.90 287.62 .00 ( 287.62) .0 15,000.00 15,000.00 .00 ( 15,000.00) .0 .00 5,000.00 5,000.00 .00 100.0 326,657.72 579,535.41 1,682,842.00 1,103,306.59 34.4 .00 560.00 .00 ( 560.00) .0 2,115.93 4,206.36 13,000.00 8,793.64 32.4 2,115.93 4,766.36 13,000.00 8,233.64 36.7 06-0420-01-00 ADMINISTRATION 5,025.93 7,306.84 15,000.00 7,693.16 48.7 06-0420-04-00 MARKETING .00 739.51 19,000.00 18,260.49 3.9 06-0420-04-01 OUTREACH .00 4,905.94 5,000.00 94.06 98.1 06-0420-05-00 OFFICE SUPPLIES 1,138.65 2,606.18 9,100.00 6,493.82 28.6 06-0420-05-01 MATERIAL PROCESSING SUPPLIES 4,104.40 4,782.87 5,000.00 217.13 95.7 06-0420-06-00 UNIFORMS .00 537.16 4,650.00 4,112.84 11.6 06-0420-07-00 SMALL FURNITURE REPLACEMENT 1,198.25 1,198.25 2,000.00 801.75 59.9 06-0420-10-00 POSTAGE .00 796.06 2,500.00 1,703.94 31.8 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 11,467.23 23,129.62 68,550.00 45,420.38 33.7 LYNX1 CONSORTIUM 06-0430-00-00 LYNX! SYSTEM 5,732.46 5,732.46 26,750.00 21,017.54 21.4 06-0430-02-00 LYNX! COURIER .00 3,636.59 16,900.00 13,263.41 21.5 TOTAL LYNX1 CONSORTIUM 5,732.46 9,369.05 43,650.00 34,280.95 21.5 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:22AM PAGE: 9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT COST RECOVERY OR PASS THRU 06-0435-00-00 CREDIT CARD PROCESSING FEE 1,277.36 1,890.65 3,200.00 1,309.35 59.1 06-0435-02-00 LOST ITEMS REFUNDS .00 .00 300.00 300.00 .0 06-0435-03-00 OPEN ACCESS 552.47 736.68 2,200.00 1,463.32 33.5 TOTAL COST RECOVERY OR PASS THRU 1,829.83 2,627.33 5,700.00 3,072.67 46.1 TECHNOLOGY 06-0440-01-00 COMPUTER MAINTENANCE & REPAIR .00 .00 3,000.00 3,000.00 .0 06-0440-02-00 COMPUTER EQUIPMENT (SMALL) 76.97 115.07 3,500.00 3,384.93 3.3 TOTAL TECHNOLOGY 76.97 115.07 6,500.00 6,384.93 1.8 GUEST RESOURCES 06-0450-00-00 BOOKS 25,914.59 58,407.25 158,500.00 100,092.75 36.9 06-0450-01-00 PRINT VENDOR PROCESSING 2,346.89 4,037.40 9,000.00 4,962.60 44.9 06-0450-02-00 BOOKS -DIGITAL 7,064.01 13,381.66 85,000.00 71,618.34 15.7 06-0450-03-00 MAGAZINES & NEWSPAPERS .00 .00 3,750.00 3,750.00 .0 06-0450-03-01 MAGAZINES - DIGITAL .00 6,300.00 16,750.00 10,450.00 37.6 06-0450-04-00 MEDIA 24,861.32 31,508.54 81,000.00 49,491.46 38.9 06-0450-05-00 MEDIA -DIGITAL 1,407.34 21,294.25 67,000.00 45,705.75 31.8 06-0450-06-00 DATABASES 200.00 4,747.00 16,800.00 12,053.00 28.3 06-0450-07-00 HOTSPOT 529.20 947.34 3,200.00 2,252.66 29.6 06-0450-08-00 FAMILY PLACE SPACE 3,607.09 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 65,930.44 144,230.53 451,000.00 306,769.47 32.0 7,321.73 9,886.12 25,000.00 15,113.88 39.5 7,321.73 9,886.12 25,000.00 15,113.88 39.5 06-0461-10-00 SALARIES - FULL TIME 128,139.33 252,160.71 539,500.00 06-0461-10-01 SALARIES - PERSONNEL SERVICES 5,574.16 19,409.09 .00 06-0461-11-00 OVERTIME 262.44 676.30 5,000.00 06-0461-15-00 SALARIES - PART TIME 16,555.20 37,439.52 216,500.00 06-0461-15-01 SALARIES - PERSONNEL SERVICES 3,983.10 6,680.14 .00 06-0461-21-00 FICA 10,686.42 21,686.72 58,500.00 06-0461-22-00 PERSI 13,948.10 27,859.96 64,700.00 06-0461-23-00 HRABUY-DOWN 3,131.32 4,612.67 5,500.00 06-0461-23-01 HRA/COBRA ADMIN FEES 291.60 486.80 900.00 06-0461-24-00 WORKERS' COMPENSATION .00 705.58 1,792.00 06-0461-25-00 INSURANCE 19,507.09 33,720.82 103,500.00 06-0461-26-00 HSACONTRIBUTION 300.00 600.00 1,200.00 06-0461-27-00 PTO CASH OUT .00 .00 5,000.00 287,339.29 46.7 19,409.09) .0 4,323.70 13.5 179,060.48 17.3 6,680.14) .0 36,813.28 37.1 36,840.04 43.1 887.33 83.9 413.20 54.1 1,086.42 39.4 69,779.18 32.6 600.00 50.0 5,000.00 .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:22AM PAGE: 10 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 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 202,378.76 406,038.31 1,013,092.00 607,053.69 40.1 RESTRICTED FUNDS 06-0462-01-00 GRANTS TOTAL RESTRICTED FUNDS STAFF DEVELOPMENT 15,099.38 15,099.38 .00 ( 15,099.38) .0 15,099.38 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 .00 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,392.00 9,149.00 12,500.00 3,351.00 73.2 06-0463-08-00 VIRTUAL TRAINING 239.00 239.00 1,500.00 1,261.00 15.9 TOTAL STAFF DEVELOPMENT 4,631.00 9,854.43 18,200.00 8,345.57 54.2 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 7,686.98 13,026.83 28,300.00 15,273.17 46.0 06-0464-03-00 TELEPHONE 82.80 165.58 1,000.00 834.42 16.6 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 473.58 928.86 1,850.00 921.14 50.2 TOTAL FACILITY (BLDGS & GROUNDS) 8,243.36 14,921.86 38,150.00 23,228.14 39.1 CAPITAL IMPROVEMENT 06-0466-01-00 CAPITAL FURNISHING 1,198.25 1,198.25 .00 ( 1,198.25) .0 TOTAL CAPITAL IMPROVEMENT 1,198.25 1,198.25 .00 ( 1,198.25) .0 TOTAL FUND EXPENDITURES 326,025.34 641,236.31 1,682,842.00 1,041,605.69 38.1 NET REVENUE OVER EXPENDITURES 632.38 ( 61,700.90) .00 61,700.90 .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:22AM PAGE: 11 CITY OF EAGLE BALANCE SHEET MARCH 31, 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 52.24 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 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 20,603.19) 20,603.19) 2,142.88) .00 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:22AM PAGE: 12 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 MUSEUM FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 07-0316-12-00 FUNDING FROM GENERAL FUND 10,231.34 20,746.98 180,610.00 159,863.02 11.5 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 79.93 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 15.99 15.99 .00 ( 15.99) .0 TOTAL FUND REVENUE EXPENDITURES PERSONNEL 10,327.26 20,842.90 197,365.00 176, 522.10 10.6 07-0420-10-00 SALARIES - FULL TIME 17,006.72 30,311.70 103,500.00 73,188.30 29.3 07-0420-15-00 SALARIES - PART TIME .00 .00 20,000.00 20,000.00 .0 07-0420-21-00 FICA 1,301.00 2,318.84 9,600.00 7,281.16 24.2 07-0420-22-00 PERSI 1,901.36 3,388.85 12,450.00 9,061.15 27.2 07-0420-24-00 WORKERS' COMPENSATION .00 3.44 .00 ( 3.44) .0 07-0420-25-00 INSURANCE 2,323.26 3,748.80 6,500.00 2,751.20 57.7 07-0420-27-00 HRA BUY DOWN .00 .00 1,540.00 1,540.00 .0 TOTAL PERSONNEL EDUCATION 22,532.34 39,771.63 153,590.00 113,818.37 25.9 07-0461-02-00 ASSOCIATION MEMBERSHIP 283.00 283.00 325.00 42.00 87.1 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 283.00 283.00 1,575.00 1,292.00 18.0 ADMINISTRATION 07-0462-30-00 CONSERVATION AND PRESERVATION .00 .00 200.00 200.00 .0 07-0462-31-00 OFFICE SUPPLIES 142.46 278.72 750.00 471.28 37.2 07-0462-32-00 ARCHIVAL SUPPLIES 134.31 134.31 1,000.00 865.69 13.4 07-0462-33-00 PUBLICITY -PRINTING .00 .00 350.00 350.00 .0 07-0462-34-00 RESEARCH MATERIAL 239.00 239.00 500.00 261.00 47.8 07-0462-35-00 UNIFORMS .00 .00 300.00 300.00 .0 07-0462-68-00 MUSEUM PROGRAMS 265.56 361.20 1,500.00 1,138.80 24.1 07-0462-69-00 MISCELLANEOUS 157.94 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 939.27 1,175.54 7,900.00 6,724.46 14.9 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:23AM PAGE: 13 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 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 .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 .00 75.92 10,000.00 9,924.08 .8 TOTAL EXHIBITS .00 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 23,754.61 41,446.09 197,365.00 155,918.91 21.0 NET REVENUE OVER EXPENDITURES ( 13,427.35) ( 20,603.19) .00 20,603.19 .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:23AM PAGE: 14 CITY OF EAGLE BALANCE SHEET MARCH 31, 2024 PARK IMPACT FEE FUND ASSETS 08-0101-00-00 CASH 172,656.73 08-0151-25-00 INVESTMENTS 507, 402.84 TOTAL ASSETS 680,059.57 LIABILITIES AND EQUITY FUND EQUITY 08-0271-00-00 PARK FUND/FUND BALANCE 404,624.82 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 275,434.75 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 275,434.75 680,059.57 680,059.57 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:23AM PAGE: 15 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 PARK IMPACT FEE FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 08-0322-19-00 PARKS DEVELOPMENT IMPACT FEES 154,222.88 344,108.64 416,000.00 71,891.36 82.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 3,316.48 5,679.58 2,000.00 ( 3,679.58) 284.0 08-0399-00-00 CARRY OVER .00 .00 343,900.00 343,900.00 .0 TOTAL FUND REVENUE 157,539.36 349,788.22 865,900.00 516,111.78 40.4 EXPENDITURES CAPITAL IMPROVEMENTS 08-0438-37-00 CAPITAL IMPROVEMENTS 74,353.47 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 74,353.47 74,353.47 865,900.00 791,546.53 8.6 TOTAL FUND EXPENDITURES 74,353.47 74,353.47 865,900.00 791,546.53 8.6 NET REVENUE OVER EXPENDITURES 83,185.89 275,434.75 .00 ( 275,434.75) .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:23AM PAGE: 16 CITY OF EAGLE BALANCE SHEET MARCH 31, 2024 RECREATION - SPECIAL EVENTS ASSETS 09-0101-00-00 CASH 3,360.14 TOTAL ASSETS 3,360.14 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 68.78 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 34,171.38) 68.78 34,102.60) 3,360.14 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:23AM PAGE: 17 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 09-0301-00-00 FUNDING FROM GENERAL FUND 2,713.82 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 55.00 460.53 22,500.00 22,039.47 2.1 09-0347-10-00 GAZEBO CONCERT SERIES 47.95 47.95 825.00 777.05 5.8 09-0347-11-00 HARVEST FEST MARKET .00 159.31 2,750.00 2,590.69 5.8 09-0376-12-00 MISCELLANEOUS REVENUE 4,170.79 4,170.79 3,000.00 ( 1,170.79) 139.0 09-0376-13-00 SPONSORSHIPS 2,000.00 4,360.00 25,000.00 20,640.00 17.4 09-0376-15-00 EVENT APPLICATION FEES 1,200.00 1,400.00 2,500.00 1,100.00 56.0 09-0376-17-00 SECURITY DEPOSIT .00 .00 1,200.00 1,200.00 .0 TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION 10,187.56 40,831.54 98,600.00 57,768.46 41.4 09-0463-11-00 OFFICE SUPPLIES .00 .00 800.00 800.00 .0 09-0463-12-00 PROMOTIONS 936.00 6,788.64 14,000.00 7,211.36 48.5 09-0463-19-00 TRAINING AND EDUCATION .00 .00 1,200.00 1,200.00 .0 09-0463-20-00 TRAVEL & PER DIEM 96.50 96.50 4,000.00 3,903.50 2.4 09-0463-21-00 PROFESSIONAL DUES 2,100.50 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 94.97 124.95 700.00 575.05 17.9 TOTAL ADMINISTRATION 3,227.97 9,725.54 26,600.00 16,874.46 36.6 ACTIVITIES 09-0467-02-00 EAGLE SATURDAY MARKET 2,235.42 2,680.42 15,000.00 12,319.58 17.9 09-0467-03-00 COUNTRY CHRISTMAS 512.33 15,298.56 18,000.00 2,701.44 85.0 09-0467-04-00 GAZEBO CONCERT SERIES .00 .00 10,000.00 10,000.00 .0 09-0467-05-00 GENERAL EVENTS 851.70 1,011.70 10,000.00 8,988.30 10.1 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 .00 333.81 3,000.00 2,666.19 11.1 TOTAL ACTIVITIES 3,599.45 31,037.22 72,000.00 40,962.78 43.1 TOTAL FUND EXPENDITURES 6,827.42 40,762.76 98,600.00 57,837.24 41.3 NET REVENUE OVER EXPENDITURES 3,360.14 68.78 .00 ( 68.78) .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:23AM PAGE: 18 CITY OF EAGLE BALANCE SHEET MARCH 31, 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 ( 4,102.92) 11-0217-09-00 WORKERS' COMPENSATION 11,801.13 11-0217-10-00 HSACONTRIBUTION ( 224.00) TOTAL LIABILITIES 10,352.77 FUND EQUITY 11-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 3,494.35 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 13,847.12) 3,494.35 ( 10,352.77) .00 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:24AM PAGE: 19 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 REVENUE 11-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION EXECUTIVE DEPARTMENT PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT 105,116.11 221,347.93 662,430.00 441,082.07 33.4 105,116.11 221,347.93 662,430.00 441,082.07 33.4 11-0413-04-00 UNIFORMS 85.00 178.75 500.00 321.25 35.8 11-0413-05-00 OFFICE SUPPLIES .00 .00 750.00 750.00 .0 11-0413-06-00 DUPLICATION/PUBLISHING/PRINT 182.65 182.65 .00 ( 182.65) .0 11-0413-12-00 PERSONNEL TRAINING 794.00 794.00 5,000.00 4,206.00 15.9 11-0413-13-00 TRAVEL & PER DIEM .00 68.90 5,000.00 4,931.10 1.4 11-0413-14-00 PROFESSIONAL DUES 492.00 1,259.00 3,500.00 2,241.00 36.0 11-0413-20-00 MARKETING 464.56 464.56 20,000.00 19,535.44 2.3 TOTAL ADMINISTRATION PERSONNEL 2,018.21 2,947.86 34,750.00 31,802.14 8.5 11-0415-10-00 SALARIES - FULL TIME 77,251.64 162,628.53 345,800.00 183,171.47 47.0 11-0415-11-00 OVERTIME .00 138.65 1,000.00 861.35 13.9 11-0415-21-00 FICA 5,708.19 11,998.74 26,500.00 14,501.26 45.3 11-0415-22-00 PERSI 8,636.68 18,197.29 41,400.00 23,202.71 44.0 11-0415-24-00 WORKERS' COMPENSATION .00 190.61 .00 ( 190.61) .0 11-0415-25-00 INSURANCE 10,057.86 20,052.69 44,500.00 24,447.31 45.1 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 STATE OF THE CITY 101,654.37 213,206.51 468,480.00 255,273.49 45.5 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 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:24AM PAGE: 20 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 EXECUTIVE DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT COMMUNITY & STAFF RELATIONS 11-0422-01-00 COMMUNITY/STAFF RELATIONS 1,428.59 1,684.21 5,000.00 3,315.79 33.7 11-0422-02-00 STAFF RELATIONS 15.00 15.00 .00 ( 15.00) .0 TOTAL COMMUNITY & STAFF RELATIONS 1,443.59 1,699.21 5,000.00 3,300.79 34.0 TOTAL FUND EXPENDITURES 105,116.17 217,853.58 662,430.00 444,576.42 32.9 NET REVENUE OVER EXPENDITURES ( .06) 3,494.35 .00 ( 3,494.35) .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:24AM 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 MARCH 31, 2024 CITY CLERK/TREAS DEPARTMENT 7,001.54 1,420.86 2,212.17 705.04 8,143.91 TOTAL LIABILITIES 19,483.52 FUND EQUITY 12-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 97.24 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 19,580.76) 97.24 19,483.52) .00 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:24AM PAGE: 22 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 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 153,165.36 326,175.28 810,700.00 484,524.72 40.2 153,165.36 326,175.28 810,700.00 484,524.72 40.2 12-0413-05-00 OFFICE SUPPLIES 132.56 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 6.00 128.00 12,500.00 12,372.00 1.0 12-0413-13-00 TRAVEL & PER DIEM 774.46 1,458.13 7,500.00 6,041.87 19.4 12-0413-14-00 PROFESSIONAL DUES 540.00 890.00 5,500.00 4,610.00 16.2 12-0413-30-00 MISCELLANEOUS 79.46 79.46 700.00 620.54 11.4 TOTAL ADMINISTRATION 1,532.48 2,745.59 33,800.00 31,054.41 8.1 PERSONNEL 12-0415-10-00 SALARIES - FULL TIME 111,806.45 240,359.99 557,800.00 317,440.01 43.1 12-0415-11-00 OVERTIME 105.48 162.67 4,000.00 3,837.33 4.1 12-0415-21-00 FICA 8,276.10 17,935.22 42,700.00 24,764.78 42.0 12-0415-22-00 PERSI 12,511.75 27,073.19 66,800.00 39,726.81 40.5 12-0415-23-00 HRA BUY- DOWN 1,540.00 2,037.89 7,700.00 5,662.11 26.5 12-0415-23-02 HSA CONTRIBUTION 300.00 600.00 2,400.00 1,800.00 25.0 12-0415-24-00 WORKERS' COMPENSATION .00 25.09 .00 ( 25.09) .0 12-0415-25-00 INSURANCE 17,007.19 33,503.40 85,500.00 51,996.60 39.2 12-0415-26-00 PTO CASH OUT .00 1,635.00 10,000.00 8,365.00 16.4 TOTAL PERSONNEL 151,546.97 323,332.45 776,900.00 453,567.55 41.6 TOTAL FUND EXPENDITURES 153,079.45 326,078.04 810,700.00 484,621.96 40.2 NET REVENUE OVER EXPENDITURES 85.91 97.24 .00 ( 97.24) .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:24AM PAGE: 23 CITY OF EAGLE BALANCE SHEET MARCH 31, 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 6,785.31 13-0217-09-00 WORKERS' COMPENSATION 59,433.90 13-0217-10-00 HSA CONTRIBUTION ( 1,900.00) TOTAL LIABILITIES 72,805.14 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 ( 28,404.23) ( ( 44,300.91) 28,404.23) ( 72,705.14) 100.00 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:24AM PAGE: 24 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 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-09-00 COMMERCIAL PLAN REVIEW 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 219,306.46 407,701.62 1,068,860.00 661,158.38 38.1 219,306.46 407,701.62 1,068,860.00 661,158.38 38.1 ( 184.95 438.13 6,500.00 6,061.87 6.7 .00 .00 400.00 400.00 .0 .00 1,400.00 6,000.00 4,600.00 23.3 1,895.00 1,895.00 4,500.00 2,605.00 42.1 40.00 40.00 2,000.00 1,960.00 2.0 .00 .00 700.00 700.00 .0 .00 .00 400.00 400.00 .0 .00 .00 2,000.00 2,000.00 .0 .00 ( 65.00) .00 65.00 .0 66.50 66.50 .00 ( 66.50) .0 660.00) ( 725.00) .00 725.00 .0 1,216.25 1,216.25 2,000.00 783.75 60.8 2,742.70 4,265.88 24,500.00 20,234.12 17.4 13-0415-10-00 SALARIES - FULL TIME 77,316.81 173,088.01 448,100.00 275,011.99 38.6 13-0415-11-00 OVERTIME 148.44 148.44 4,000.00 3,851.56 3.7 13-0415-21-00 FICA 5,712.80 12,819.84 34,500.00 21,680.16 37.2 13-0415-22-00 PERSI 8,572.65 19,279.92 53,600.00 34,320.08 36.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,597.21 31,408.27 92,300.00 60,891.73 34.0 13-0415-26-00 HSA CONTRIBUTION 100.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 107, 447.91 237,593.95 644,860.00 407,266.05 36.8 13-0416-09-00 PLUMBING INSPECTOR 22,912.21 47,777.15 110,000.00 62,222.85 43.4 13-0416-10-00 ELECTRICAL INSPECTION 66.50 66.50 .00 ( 66.50) .0 13-0416-11-00 MECHANICAL INSPECTOR 47,001.31 69,511.26 110,000.00 40,488.74 63.2 13-0416-13-00 BLDG INSPECTOR 8,231.25 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-25-00 ELECTRICAL INSPECTOR 32,606.28 61,019.69 120,000.00 58,980.31 50.9 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:24AM PAGE: 25 TOTAL CONTRACTS & AGREEMENTS VEHICLE OPERATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 BUILDING DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT 110,817.55 193,921.85 399,000.00 205,078.15 48.6 13-0417-02-00 GAS AND OIL 157.64 324.17 500.00 175.83 64.8 TOTAL VEHICLE OPERATIONS 157.64 324.17 500.00 175.83 64.8 TOTAL FUND EXPENDITURES 221,165.80 436,105.85 1,068,860.00 632,754.15 40.8 NET REVENUE OVER EXPENDITURES ( 1,859.34) ( 28,404.23) .00 28,404.23 .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:24AM PAGE: 26 CITY OF EAGLE BALANCE SHEET MARCH 31, 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 ( 44,466.10) 14-0217-08-00 GARNISHMENTS 203.34 14-0217-09-00 WORKERS' COMPENSATION 83,714.36 TOTAL LIABILITIES 57,866.95 FUND EQUITY 14-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 4,781.10 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 62,648.05) 4,781.10 ( 57,866.95) .00 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:24AM PAGE: 27 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 REVENUE 14-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION P&Z DEPARTMENT PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT 231,538.23 484,069.61 1,288,000.00 803,930.39 37.6 231,538.23 484,069.61 1,288,000.00 803,930.39 37.6 14-0413-05-00 OFFICE SUPPLIES 12.30 262.36 1,300.00 1,037.64 20.2 14-0413-06-00 DUPLICATION/PUBLISHING/PRNTG .00 .00 1,000.00 1,000.00 .0 14-0413-08-00 LEGAL ADS & PUBLICATIONS 758.14 918.54 6,000.00 5,081.46 15.3 14-0413-12-00 PERSONNEL TRAINING .00 125.00 2,000.00 1,875.00 6.3 14-0413-13-00 TRAVEL & PER DIEM 77.11 372.09 500.00 127.91 74.4 14-0413-14-00 PROFESSIONAL DUES 160.00 160.00 3,300.00 3,140.00 4.9 14-0413-25-00 MISCELLANEOUS 25.50 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 5.98 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 1,039.03 2,203.77 22,600.00 20,396.23 9.8 PERSONNEL 14-0415-10-00 SALARIES - FULL TIME 164,589.88 338,496.36 890,500.00 14-0415-10-01 SALARIES - PERSONNEL SERVICES 3,181.76 22,126.40 .00 14-0415-11-00 OVERTIME 468.21 831.80 13,000.00 14-0415-21-00 FICA 12,068.17 25,017.56 69,800.00 14-0415-22-00 PERSI 18,453.45 37,749.15 108,900.00 14-0415-24-00 WORKERS' COMPENSATION .00 377.53 .00 14-0415-25-00 INSURANCE 28,994.42 51,344.21 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 953.64 953.64 7,700.00 TOTAL PERSONNEL CONTRACTS & AGREEMENTS 552,003.64 38.0 22,126.40) .0 12,168.20 6.4 44,782.44 35.8 71,150.85 34.7 377.53) .0 92,155.79 35.8 1,200.00 .0 10,000.00 .0 6,746.36 12.4 228,709.53 476,896.65 1,244,600.00 767,703.35 38.3 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 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:24AM 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 6 MONTHS ENDING MARCH 31, 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 229,748.56 479,288.51 1,288,000.00 808,711.49 37.2 NET REVENUE OVER EXPENDITURES 1,789.67 4,781.10 .00 ( 4,781.10) .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:24AM PAGE: 29 CITY OF EAGLE BALANCE SHEET MARCH 31, 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 ( 21,156.19) 17-0217-09-00 WORKERS' COMPENSATION 52,333.44 17-0217-10-00 HSA CONTRIBUTION ( 4,225.93) TOTAL LIABILITIES 29,668.43 FUND EQUITY 17-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 6,592.38 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 36,110.81) 6,592.38 ( 29,518.43) 150.00 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:25AM PAGE: 30 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 RECREATION - PARKS AND REC PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 17-0301-00-00 FUNDING FROM GENERAL FUND 83,221.95 247,414.50 807,120.00 559,705.50 30.7 17-0302-00-00 REGIST-SPORTS, CAMPS, CLASSES 61,213.46 110,892.92 112,000.00 1,107.08 99.0 17-0302-01-00 SPONSORSHIPS 6,750.00 6,750.00 10,000.00 3,250.00 67.5 17-0302-02-00 DONATIONS ( 1,871.63) ( 1,871.63) .00 1,871.63 .0 17-0302-03-00 PARK RESERVATION FEES 10,530.59 11,796.14 20,000.00 8,203.86 59.0 17-0302-04-00 SENIOR CENTER FEES 2,752.50 3,427.50 .00 ( 3,427.50) .0 17-0304-00-00 MISC SALES, EAGLE ARTS ( .66) 10.34 .00 ( 10.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 162,596.21 378,419.77 950,120.00 571,700.23 39.8 1,084.50 3,177.25 3,402.50 18,655.10 20,000.00 10,000.00 16,822.75 15.9 8,655.10) 186.6 TOTAL CONTRACTS 4,487.00 PERSONNEL 21,832.35 30,000.00 8,167.65 72.8 17-0420-10-00 SALARIES - FULL TIME 104,123.99 219,012.24 495,000.00 275,987.76 44.2 17-0420-10-01 SALARIES - PERSONNEL SERVICES 4,903.07 12,153.54 20,000.00 7,846.46 60.8 17-0420-11-00 SALARIES - SEASONAL 8.46 931.35 .00 ( 931.35) .0 17-0420-18-00 OVERTIME .00 .00 4,000.00 4,000.00 .0 17-0420-21-00 FICA 7,806.33 16,770.02 38,300.00 21,529.98 43.8 17-0420-22-00 PERSI 11,641.95 24,985.36 59,700.00 34,714.64 41.9 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,365.47 32,164.09 86,000.00 53,835.91 37.4 17-0420-26-00 HSACONTRIBUTION 900.00 1,500.00 2,400.00 900.00 62.5 17-0420-27-00 PTO CASH OUT .00 3,540.00 5,000.00 1,460.00 70.8 TOTAL PERSONNEL RESTRICTED 146,749.27 311,812.90 715,020.00 403,207.10 43.6 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 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:25AM PAGE: 31 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT 17-0422-01-00 OFFICE SUPPLIES 73.06 107.67 2,000.00 1,892.33 5.4 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 150.00 150.00 2,000.00 1,850.00 7.5 17-0422-08-00 TRAINING AND EDUCATION 193.00 193.00 3,000.00 2,807.00 6.4 17-0422-09-00 TRAVEL & PER DIEM 193.00 193.00 5,000.00 4,807.00 3.9 17-0422-10-00 BACKGROUND CHECKS 2,059.70 2,948.50 8,000.00 5,051.50 36.9 17-0422-11-00 REFUNDS -PARK REC PROGRAMS 405.00 405.00 4,000.00 3,595.00 10.1 TOTAL ADMINISTRATION 3,073.76 3,997.17 31,800.00 27,802.83 12.6 RECREATION 17-0423-00-00 REC SUPPLIES -CAMPS & CLASSES 158.85 541.64 10,000.00 9,458.36 5.4 17-0423-00-01 REC SUPPLIES -TEAM SPORTS 59.25 1,507.46 20,000.00 18,492.54 7.5 17-0423-01-00 UNIFORMS, TEAM SPORTS 2,487.18 6,584.11 15,000.00 8,415.89 43.9 17-0423-02-00 FIELD TRIPS 198.00 198.00 20,000.00 19,802.00 1.0 17-0423-04-00 TRANSPORTATION SERVICES .00 .00 15,000.00 15,000.00 .0 17-0423-05-00 DADDY DAUGHTER DANCE 1,324.37 1,324.37 2,000.00 675.63 66.2 17-0423-07-00 GLOW IN THE PARK .00 ( 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 .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 1,727.32 4,385.36 10,000.00 5,614.64 43.9 17-0423-11-01 SENIOR CENTER GRANT 2,817.15 2,817.15 .00 ( 2,817.15) .0 17-0423-12-00 EAGLE ARTS ADVISORY COMMITTEE 139.99 13,955.02 50,000.00 36,044.98 27.9 17-0423-20-00 NEW PROGRAMS .00 .00 5,000.00 5,000.00 .0 TOTAL RECREATION 8,912.11 34,091.50 151,300.00 117,208.50 22.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 .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 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:25AM PAGE: 32 TOTAL CAPITAL OUTLAY TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT .00 .00 2,000.00 2,000.00 .0 163,222.14 371,827.39 950,120.00 578,292.61 39.1 ( 625.93) 6,592.38 .00 ( 6,592.38) .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:25AM PAGE: 33 CITY OF EAGLE BALANCE SHEET MARCH 31, 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 ( 31,617.97) 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,836.00) ( 12,836.00) 26,980.94) 26,980.94 .00 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:25AM PAGE: 34 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 REVENUE 18-0301-00-00 FUNDING FROM GENERAL FUND TOTAL FUND REVENUE EXPENDITURES ADMINISTRATION IT DEPARTMENT PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT 249,517.54 445,134.61 1,204,530.00 759,395.39 37.0 249,517.54 445,134.61 1,204,530.00 759,395.39 37.0 18-0413-01-00 OFFICE SUPPLIES .00 .00 1,000.00 1,000.00 .0 18-0413-02-00 SUPPLIES 452.00 452.00 4,000.00 3,548.00 11.3 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 452.00 452.00 20,750.00 20,298.00 2.2 PERSONNEL 18-0415-10-00 SALARIES - FULL TIME 82,297.74 152,381.23 329,500.00 177,118.77 46.3 18-0415-11-00 IT DEPT/OVERTIME 337.50 869.06 5,000.00 4,130.94 17.4 18-0415-21-00 FICA 6,167.77 11,395.12 25,800.00 14,404.88 44.2 18-0415-22-00 PERSI 9,238.60 16,910.58 40,200.00 23,289.42 42.1 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 10,752.02 15,742.27 58,500.00 42,757.73 26.9 18-0415-26-00 HSA CONTRIBUTION 225.00 475.00 1,200.00 725.00 39.6 18-0415-27-00 PTO CASH OUT .00 .00 2,500.00 2,500.00 .0 TOTAL PERSONNEL CONTRACT & AGREEMENTS 109, 018.63 197,792.08 465,780.00 267,987.92 42.5 18-0416-01-00 CONTRACTAND AGREEMENTS 106,793.34 183,913.03 453,000.00 269,086.97 40.6 TOTAL CONTRACT & AGREEMENTS 106,793.34 INTERNET/PHONE SERVICES 183,913.03 453,000.00 269,086.97 40.6 18-0417-01-00 INTERNET & PHONE SERVICES 25,336.65 46,716.11 89,000.00 42,283.89 52.5 TOTAL INTERNET/PHONE SERVICES 25,336.65 OPERATIONAL RESERVES 46,716.11 89,000.00 42,283.89 52.5 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:25AM PAGE: 35 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 IT DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT 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 5,883.57 21,185.35 65,000.00 43,814.65 32.6 18-0419-03-00 SOFTWARE PURCHASES 256.04 7,912.04 40,000.00 32,087.96 19.8 18-0419-04-00 WEBSITE DEVELOPMENT .00 .00 12,000.00 12,000.00 .0 18-0419-05-00 TOOLS .00 .00 3,000.00 3,000.00 .0 TOTAL CAPITAL OUTLAY 6,139.61 29,097.39 121,000.00 91,902.61 24.1 TOTAL FUND EXPENDITURES 247,740.23 457,970.61 1,204,530.00 746,559.39 38.0 NET REVENUE OVER EXPENDITURES 1,777.31 ( 12,836.00) .00 12,836.00 .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:25AM PAGE: 36 ASSETS 19-0101-00-00 CASH 19-0151-25-00 INVESTMENTS CITY OF EAGLE BALANCE SHEET MARCH 31, 2024 CAPITAL PROJECTS FUND 63,617.32 5,732,262.12 TOTAL ASSETS 5,795,879.44 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 ( 276,422.58) 276,422.58) 941,148.64 4,854,730.80 5,795,879.44 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:25AM PAGE: 37 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 CAPITAL PROJECTS FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 19-0301-00-00 FUNDING FROM GENERAL FUND 129,296.72 129,296.72 2,998,200.00 2,868,903.28 4.3 19-0301-05-00 EAGLE RD PED/BIKE BRIDGE 9,169.66 303,002.06 28,000.00 ( 275,002.06) 1082.2 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 66,312.15 134,459.77 15,000.00 ( 119,459.77) 896.4 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 204,778.53 EXPENDITURES RESERVES 566,758.55 11,326,220.00 10,759,461.45 5.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 174,335.12 375,631.02 2,146,700.00 1,771,068.98 17.5 174,335.12 375,631.02 2,146,700.00 1,771,068.98 17.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 18,358.27 61,363.50 2,545,000.00 2,483,636.50 2.4 TOTAL CITY CAPITAL PROJECTS 18,358.27 61,363.50 2,645,000.00 2,583,636.50 2.3 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 25,056.39 31,667.67 30,000.00 ( 1,667.67) 105.6 19-0466-09-00 EAGLE -STATE ST INTERSECTION 1,995.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 27,051.39 PARK CAPITAL PROJECTS 19-0467-02-00 PARK CAPITAL PROJECTS 59,430.42 2,120,309.00 2,060,878.58 2.8 ( 5,352.00) 161,809.97 537,000.00 375,190.03 30.1 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:25AM PAGE: 38 TOTAL PARK CAPITAL PROJECTS LIBRARY CAPITAL PROJECTS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 CAPITAL PROJECTS FUND YTD ACTUAL BUDGET UNEXPENDED PCNT ( 5,352.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 128,254.25 159,564.45 140,000.00 ( 19,564.45) 114.0 19-0486-01-01 ARPA, SOFTWARE PURCHASES 10,451.36 25,381.77 .00 ( 25,381.77) .0 TOTAL FEDERAL FUNDS PROJECTS 138,705.61 184,946.22 140,000.00 ( 44,946.22) 132.1 TOTAL FUND EXPENDITURES 353,098.39 843,181.13 11,326,220.00 10,483,038.87 7.4 NET REVENUE OVER EXPENDITURES ( 148,319.86) ( 276,422.58) .00 276,422.58 .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:25AM PAGE: 39 CITY OF EAGLE BALANCE SHEET MARCH 31, 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 ( 12,295.34) 23-0217-08-00 GARNISHMENTS ( 1,499.98) 23-0217-09-00 WORKERS' COMPENSATION 147,462.41 23-0217-10-00 HSA CONTRIBUTION ( 1,160.00) TOTAL LIABILITIES 135,132.55 FUND EQUITY 23-0271-00-00 FUND BALANCE UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 82,982.01 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY ( 218,114.56) 82,982.01 ( 135,132.55) .00 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:26AM PAGE: 40 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 REVENUE 23-0302-00-00 FUNDING FROM GENERAL FUND 23-0315-02-00 SIDEWALKS, LTS, TREES, STR-REP 23-0315-06-00 TREE FUNDS, CARRYOVER 23-0315-09-00 WYCLIFF PUMP STATION 23-0316-00-00 ARBOR DAY, TREE CITY USA GRANT 23-0316-01-00 MEMORIAL DONATIONS TOTAL FUND REVENUE EXPENDITURES PERSONNEL PUBLIC WORKS PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT ( 471,964.21 1,066,607.27 2,884,511.00 1,817,903.73 37.0 .00 .00 50,000.00 50,000.00 .0 5,250.00 5,250.00 22,291.00 17,041.00 23.6 14,003.36 14,003.36 10,500.00 ( 3,503.36) 133.4 .00 .00 300.00 300.00 .0 997.98) ( 997.98) 6,000.00 6,997.98 ( 16.6) 490,219.59 1,084,862.65 2,973,602.00 1,888,739.35 36.5 23-0433-10-00 SALARIES -FULL TIME 241,810.77 535,587.23 1,110,000.00 23-0433-10-01 SALARIES - PERSONNEL SERVICES .00 .00 125,000.00 23-0433-11-00 OVERTIME 962.97 4,654.73 20,000.00 23-0433-16-00 SALARIES -SEASONAL 301.05 509.31 .00 23-0433-21-00 FICA 18,048.03 40,466.05 87,500.00 23-0433-22-00 PERSI 27,415.61 60,868.40 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 54,052.26 99,355.11 227,500.00 23-0433-26-00 HSA CONTRIBUTION 1,500.00 3,000.00 4,800.00 23-0433-29-00 PTO CASH OUT 2,800.00 4,820.00 15,000.00 TOTAL PERSONNEL ADMINISTRATION 574,412.77 48.3 125,000.00 .0 15,345.27 23.3 509.31) .0 47,033.95 46.3 74,631.60 44.9 7,700.00 .0 1,588.64) .0 128,144.89 43.7 1,800.00 62.5 10,180.00 32.1 346,890.69 750,849.47 1,733,000.00 982,150.53 43.3 23-0435-01-00 OFFICE SUPPLIES 124.42 202.76 1,000.00 797.24 20.3 23-0435-02-00 PRINT, PUBLISH, LEGAL, ADV 21.76 21.76 5,000.00 4,978.24 .4 23-0435-03-00 TRAINING, EDUCATION, TRVL, ETC 563.00 1,184.95 20,000.00 18,815.05 5.9 23-0435-04-00 DUES, CERTIFICATIONS, LICENSES 231.35 326.35 1,000.00 673.65 32.6 23-0435-09-00 STAFF AND PUBLIC RELATIONS 702.64 1,001.04 2,500.00 1,498.96 40.0 23-0435-10-00 SAFETY CLOTHING AND GEAR 1,476.44 3,372.39 6,500.00 3,127.61 51.9 TOTAL ADMINISTRATION 3,119.61 6,109.25 36,000.00 29,890.75 17.0 IRRIGATION CONTRACTS/AGRMNTS 23-0437-01-00 WYCLIFFE PUMP STATION 190.66 974.99 6,690.00 5,715.01 14.6 23-0437-02-00 IRRIGATION SHARES AND DUES 17,820.25 18,885.60 20,000.00 1,114.40 94.4 23-0437-03-00 BASELINE MANAGER AGREEMENT .00 .00 4,500.00 4,500.00 .0 23-0437-04-00 CHAUMONT LEASE AGREEMENT 1.00 1.00 1.00 .00 100.0 TOTAL IRRIGATION CONTRACTS/AGRMNTS 18,011.91 19,861.59 31,191.00 11,329.41 63.7 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:26AM PAGE: 41 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT GENERAL MTNC & REPAIR 23-0439-02-00 MISC MTNC & REPAIR GROUNDS 413.44 2,672.14 45,000.00 42,327.86 5.9 23-0439-02-01 MISC MTNC & REPAIR EQUIPMENT 2,167.80 3,597.75 20,000.00 16,402.25 18.0 23-0439-02-02 MISC MTNC & REPAIR BUILDINGS 4,682.99 8,758.66 10,000.00 1,241.34 87.6 23-0439-02-03 EMERGENCY REPAIRS 7,270.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 13,395.24 14,983.00 50,000.00 35,017.00 30.0 23-0439-04-00 HOLIDAY LIGHTING 26.99 6,903.90 50,000.00 43,096.10 13.8 23-0439-05-00 CLEANING AND PAPER SUPPLIES 3,584.17 8,185.91 50,000.00 41,814.09 16.4 23-0439-06-00 SIGNS & SIGN REPLACEMENT 3,032.71 3,032.71 5,000.00 1,967.29 60.7 TOTAL GENERAL MTNC & REPAIR 34,573.34 55,404.07 305,000.00 249,595.93 18.2 VEHICLES 23-0441-01-00 VEHICLE MTNC & REPAIR 8,776.24 18,541.27 35,000.00 16,458.73 53.0 23-0441-02-00 FUEL 6,025.39 11,479.51 45,000.00 33,520.49 25.5 TOTAL VEHICLES 14,801.63 30,020.78 80,000.00 49,979.22 37.5 FACILITIES 23-0443-01-00 CITY HALL 11,589.65 28,817.13 57,200.00 28,382.87 50.4 23-0443-02-00 LIBRARY 176.95 1,102.95 16,000.00 14,897.05 6.9 23-0443-03-00 MUSEUM .00 299.00 2,500.00 2,201.00 12.0 23-0443-04-00 CITY SHOP 2,399.66 3,162.38 10,000.00 6,837.62 31.6 23-0443-04-01 CITY SHOP UPGRADES, SV .00 545.85 10,000.00 9,454.15 5.5 23-0443-05-00 SENIOR CENTER 4,599.49 14,883.93 10,000.00 ( 4,883.93) 148.8 23-0443-06-00 JACKSON HOUSE 1,968.53 4,371.40 10,000.00 5,628.60 43.7 23-0443-07-00 LINDER ROAD RESTROOM 1,323.43 2,244.74 6,000.00 3,755.26 37.4 23-0443-15-00 STREET LIGHTS 8,041.63 14,636.21 43,000.00 28,363.79 34.0 TOTAL FACILITIES PARKS, MONUMENTS & GROUNDS 23-0445-01-00 ADA-EAGLE SPORTS PARK 23-0445-02-00 ARBORETUM PARK 23-0445-03-00 SV REGIONAL SPORTS COMPLEX 23-0445-04-00 FLAG PLAZA 23-0445-05-00 FRIENDSHIP PARK 23-0445-06-00 GUERBER PARK 23-0445-07-00 HERITAGE PARK 23-0445-08-00 MACE PARKING AREA 23-0445-09-00 MCDONALD'S PATHWAY 23-0445-10-00 MERRILL PARK 23-0445-11-00 ORVAL KRASEN PARK 23-0445-12-00 PAMELA BAKER PARK 23-0445-13-00 PLAZA DRIVE 30,099.34 70,063.59 164,700.00 94,636.41 42.5 ( ( 7,145.42 12,973.53 36,400.00 23,426.47 35.6 .00 .00 2,000.00 2,000.00 .0 .00 78.00 10,000.00 9,922.00 .8 23.94 53.51 1,000.00 946.49 5.4 1,915.12 2,975.06 6,000.00 3,024.94 49.6 8,188.25 8,904.81 30,000.00 21,095.19 29.7 485.15 1,069.12 7,500.00 6,430.88 14.3 .00 .00 5,000.00 5,000.00 .0 107.82) 155.92 2,000.00 1,844.08 7.8 1,714.12 2,710.78 29,000.00 26,289.22 9.4 395.11) 1,133.02 4,500.00 3,366.98 25.2 853.78 1,114.29 11,000.00 9,885.71 10.1 .00 .00 4,000.00 4,000.00 .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:26AM PAGE: 42 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT 23-0445-14-00 TRAILS 763.50 866.45 11,500.00 10,633.55 7.5 23-0445-20-00 CITY ENTRANCE SIGNS .00 2,971.14 15,000.00 12,028.86 19.8 23-0445-30-00 LANDSCAPING, EQUIPMENT RENTAL 1,045.80 1,198.12 15,000.00 13,801.88 8.0 23-0445-30-01 LANDSCAPING, SPRAY/FERTILIZE 4,321.90 4,453.93 35,000.00 30,546.07 12.7 23-0445-30-03 LANDSCAPING, DUMPING/DISPOSAL 577.39 1,023.47 5,000.00 3,976.53 20.5 TOTAL PARKS, MONUMENTS & GROUNDS 26,531.44 41,681.15 229,900.00 188,218.85 18.1 MEMORIALS AND PROGRAMS 23-0447-01-00 MEMORIALS, MTNC/REPAIR 1,635.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 115.35 115.35 20,000.00 19,884.65 .6 23-0447-04-00 SANITATION AND RECYCLING 2,226.80 4,713.30 54,000.00 49,286.70 8.7 23-0447-05-00 TREES, PUBLIC DEVELOPMENT 2,640.00 14,027.35 29,511.00 15,483.65 47.5 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 6,617.15 20,734.05 125,811.00 105,076.95 16.5 FISCAL YEAR PROJECTS 23-0483-15-00 LANDSCAPE UPGRADES - PARKS 5,114.76 5,114.76 25,000.00 19,885.24 20.5 23-0483-20-01 TOOLS 1,905.50 2,041.93 5,000.00 2,958.07 40.8 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 7,020.26 7,156.69 268,000.00 260,843.31 2.7 TOTAL FUND EXPENDITURES 487,665.37 1,001,880.64 2,973,602.00 1,971,721.36 33.7 NET REVENUE OVER EXPENDITURES 2,554.22 82,982.01 .00 ( 82,982.01) .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:26AM PAGE: 43 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 24-0301-00-00 FUNDING FROM GENERAL FUND 5,010.00 5,010.00 126,400.00 121,390.00 4.0 24-0303-00-00 SPONSORSHIPS 2,000.00 2,000.00 21,000.00 19,000.00 9.5 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 .00 3,000.00 .00 ( 3,000.00) .0 TOTAL FUND REVENUE EXPENDITURES ADMIN EXPENDITURES 7,010.00 10,010.00 175,700.00 165,690.00 5.7 24-0401-01-00 FUN DAYS CONTRACTS 10,000.00 10,000.00 60,000.00 50,000.00 16.7 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 10,000.00 10,000.00 86,800.00 76,800.00 11.5 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 .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 TOTAL ROCKY MOUNTAIN OYSTER FEED .00 .00 30,000.00 30,000.00 .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:26AM PAGE: 44 TOTAL FUND EXPENDITURES NET REVENUE OVER EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 RECREATION - EAGLE FUN DAYS YTD ACTUAL BUDGET UNEXPENDED PCNT 10,000.00 10,010.00 175,700.00 165,690.00 5.7 2,990.00) .00 .00 .00 .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:26AM PAGE: 45 CITY OF EAGLE BALANCE SHEET MARCH 31, 2024 PATHWAY IMPACT FEE FUND ASSETS 25-0101-00-00 CASH 57,956.38 25-0151-25-00 INVESTMENTS 142, 594.71 TOTAL ASSETS 200,551.09 LIABILITIES AND EQUITY FUND EQUITY 25-0271-00-00 FUND BALANCE 142,294.84 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 58,256.25 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 58,256.25 200,551.09 200,551.09 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:26AM PAGE: 46 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 PATHWAY IMPACT FEE FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 25-0322-19-00 PATHWAY DEVELOPMENT IMPACT FEE 25,118.00 56,515.50 82,625.00 26,109.50 68.4 25-0371-25-00 BANK INTEREST 973.19 1,740.75 1,000.00 ( 740.75) 174.1 25-0399-00-00 CARRY OVER .00 .00 139,900.00 139,900.00 .0 TOTAL FUND REVENUE EXPENDITURES CAPITAL IMPROVEMENTS 26,091.19 58,256.25 223,525.00 165,268.75 26.1 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 26,091.19 58,256.25 .00 ( 58,256.25) .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:27AM PAGE: 47 CITY OF EAGLE BALANCE SHEET MARCH 31, 2024 LAW ENF DEV IMPACT FEES ASSETS 27-0101-00-00 CASH 9,576.61 27-0151-25-00 INVESTMENTS 129, 443.81 TOTAL ASSETS 139,020.42 LIABILITIES AND EQUITY FUND EQUITY 27-0271-00-00 POLICE IMPACT FEE/FUND BALANCE 116,197.61 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 22,822.81 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 22,822.81 139,020.42 139,020.42 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:27AM PAGE: 48 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 LAW ENF DEV IMPACT FEES PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT REVENUE 27-0322-19-00 RESIDENTIAL IMPACT FEES 8,559.49 20,385.97 27,750.00 7,364.03 73.5 27-0322-20-00 COMMERCIAL - IMPACT FEES .00 .00 30,000.00 30,000.00 .0 27-0371-25-00 BANK INTEREST 1,250.23 2,436.84 200.00 ( 2,236.84) 1218.4 27-0399-00-00 CARRY OVER .00 .00 100,000.00 100,000.00 .0 TOTAL FUND REVENUE EXPENDITURES CAPITAL IMPROVEMENTS 9,809.72 22,822.81 157,950.00 135,127.19 14.5 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 9,809.72 22,822.81 .00 ( 22,822.81) .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:27AM PAGE: 49 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 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 6,509.41 6,509.41 104,750.00 98,240.59 6.2 6,509.41 6,509.41 104,750.00 98,240.59 6.2 54-0480-81-00 PRINCIPAL BOND PAYMENT .00 .00 90,000.00 90,000.00 .0 54-0480-82-00 INTEREST BOND PAYMENT 6,509.41 6,509.41 14,250.00 7,740.59 45.7 54-0480-84-00 PAYING AGENT FEE .00 .00 500.00 500.00 .0 TOTAL BOND PAYMENTS 6,509.41 6,509.41 104,750.00 98,240.59 6.2 TOTAL FUND EXPENDITURES 6,509.41 6,509.41 104,750.00 98,240.59 6.2 NET REVENUE OVER EXPENDITURES .00 .00 .00 .00 .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:27AM PAGE: 50 CITY OF EAGLE BALANCE SHEET MARCH 31, 2024 WATER FUND ASSETS 60-0101-00-00 CASH 499,369.04 60-0115-00-00 ACCOUNTS RECEIVABLE 117,174.97 60-0151-25-00 INVESTMENTS, WATER SYSTEM 6,247,563.17 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,257,993.26 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-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 6,897.86 1,162.50 71,563.06 100.00) 325,075.00 82,550.00 118,942.00 TOTAL LIABILITIES 632,247.33 FUND EQUITY 60-0271-00-00 WATER/FUND BALANCE 19,623,429.73 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 2,316.20 BALANCE - CURRENT DATE TOTAL FUND EQUITY TOTAL LIABILITIES AND EQUITY 2,316.20 19,625,745.93 20,257,993.26 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:27AM PAGE: 51 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 REVENUE 60-0346-59-00 STL-STORAGE & TRUNK LINE FEE 60-0346-60-00 HOOK UP FEES CITY 60-0346-62-00 PROFESSIONAL SERV - DEVELOPERS 60-0346-63-00 STAFF TIME REIMB - DEVELOPERS 60-0347-01-00 BILLING REVENUE 60-0347-02-00 OTHER REVENUE 60-0347-03-00 RECONNECT FEES 60-0347-04-00 DELINQUENT FEES 60-0347-05-00 MISCELLANEOUS REVENUE 60-0347-06-00 SYSTEM ENHANCEMENT FEE 60-0355-01-00 WCE-WATER CONST EQUIV FEE 60-0371-25-00 BANK INTEREST 60-0399-00-00 CARRY OVER 60-0399-01-00 RESERVES, FOR BUDGET 60-0399-02-00 RESERVES, EMERGENCY REPL ITEMS 60-0399-03-00 RESERVES, EQUIP/BLDG REPLCMNT 60-0399-04-00 RESERVES, REPAIR/ MAINTENANCE 60-0399-05-00 RESERVES, VEHICLE REPLACEMENT 60-0399-06-00 RESERVES, STL FEES TOTAL FUND REVENUE EXPENDITURES VEHICLE OPERATIONS - LEASES WATER FUND PERIOD ACTUAL YTDACTUAL BUDGET UNEARNED PCNT ( 2,100.00 211,393.92 105,000.00 ( 106,393.92) 201.3 68,015.00 141,605.00 172,050.00 30,445.00 82.3 2,792.75 9,979.64 50,000.00 40,020.36 20.0 46.00 552.00 5,000.00 4,448.00 11.0 385,319.75 742,440.30 1,322,000.00 579,559.70 56.2 1,925.00 2,999.23 4,120.00 1,120.77 72.8 100.00 100.00 300.00 200.00 33.3 3,123.00 5,679.00 12,000.00 6,321.00 47.3 207.12 2,117.98 12,000.00 9,882.02 17.7 20.80) 206.16 100,000.00 99,793.84 .2 16,800.00 36,400.00 20,000.00 ( 16,400.00) 182.0 74,532.10 145,784.79 10,000.00 ( 135,784.79) 1457.9 .00 .00 279,930.00 279,930.00 .0 .00 .00 375,000.00 375,000.00 .0 .00 .00 200,000.00 200,000.00 .0 .00 .00 275,000.00 275,000.00 .0 .00 .00 200,000.00 200,000.00 .0 .00 .00 12,000.00 12,000.00 .0 .00 .00 1,800,000.00 1,800,000.00 .0 554,939.92 1,299,258.02 4,954,400.00 3,655,141.98 26.2 60-0420-01-00 GAS AND OIL 1,267.47 60-0420-03-00 VEHICLE MTNC & REPAIR 2,990.49 2,629.96 15,000.00 3,975.79 10,000.00 12,370.04 17.5 6,024.21 39.8 TOTAL VEHICLE OPERATIONS - LEASES 4,257.96 PERSONNEL 6,605.75 25,000.00 18,394.25 26.4 60-0433-10-00 SALARIES - FULL TIME 80,399.02 180,805.50 426,500.00 245,694.50 42.4 60-0433-10-02 ON -CALL TIME 615.25 1,490.11 7,500.00 6,009.89 19.9 60-0433-11-00 OVERTIME 518.41 1,105.93 4,500.00 3,394.07 24.6 60-0433-21-00 FICA 6,191.58 13,809.90 33,500.00 19,690.10 41.2 60-0433-22-00 PERSI 9,349.78 20,738.63 52,500.00 31,761.37 39.5 60-0433-23-00 HRA BUY -DOWN 342.32 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 12,104.81 23,992.95 59,310.00 35,317.05 40.5 60-0433-26-00 HSA CONTRIBUTION 600.00 1,200.00 2,400.00 1,200.00 50.0 60-0433-29-00 PTO CASH OUT 2,300.00 2,300.00 10,000.00 7,700.00 23.0 TOTAL PERSONNEL 112,421.17 256,124.54 617,190.00 361,065.46 41.5 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:27AM PAGE: 52 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT OPERATIONS & MAINTENANCE 60-0434-15-00 OFFICE SUPPLIES 167.73 583.76 2,000.00 1,416.24 29.2 60-0434-19-00 TELECOMMUNICATIONS/SCADA 2,257.61 5,695.32 17,000.00 11,304.68 33.5 60-0434-20-00 ADVERTISING - PUBLICATIONS .00 294.66 1,500.00 1,205.34 19.6 60-0434-22-00 TRAVEL-MTNGS-EDUCATION 3,975.00 4,079.00 8,000.00 3,921.00 51.0 60-0434-23-00 DUES & SUBSCRIPTIONS 120.00 206.00 3,000.00 2,794.00 6.9 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,261.89 650.56 20,000.00 19,349.44 3.3 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 .00 4,000.00 5,900.00 1,900.00 67.8 60-0434-42-00 ENGINEERING SERVICES 9,211.97 13,863.72 35,000.00 21,136.28 39.6 60-0434-42-01 LEGAL SERVICES 297.50 805.00 25,000.00 24,195.00 3.2 60-0434-42-02 MISC LEGAL AND ENG SERVICES 2,351.50 4,361.00 100,000.00 95,639.00 4.4 60-0434-42-03 PROFESSIONAL SERV - DEVELOPERS 5,869.50 9,978.07 50,000.00 40,021.93 20.0 60-0434-43-01 CONTRACT SERVICES (REPAIR) .00 .00 35,000.00 35,000.00 .0 60-0434-44-00 DIG LINE 620.10 1,479.61 4,500.00 3,020.39 32.9 60-0434-45-00 CITY AUDITOR SERVICES 3,500.00 3,500.00 3,500.00 .00 100.0 60-0434-47-00 MAIL SERVICE -CUSTOMER BILLING 7,137.61 11,873.46 31,500.00 19,626.54 37.7 60-0434-50-01 SHOP UTILITIES 1,008.97 1,335.85 5,100.00 3,764.15 26.2 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,148.20 1,641.81 40,000.00 38,358.19 4.1 60-0434-58-01 RPR/MTNC PUMPS -WELLS -CHEMICAL 6,895.06 7,127.96 40,000.00 32,872.04 17.8 60-0434-59-00 CHEMICALS 1,599.84 2,042.39 13,500.00 11,457.61 15.1 60-0434-60-00 UTILITIES 14,333.86 21,393.51 110,000.00 88,606.49 19.5 60-0434-68-00 UNIFORMS AND SAFETY CLOTHING 176.20 518.18 2,300.00 1,781.82 22.5 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 61,932.54 115,204.57 617,600.00 502,395.43 18.7 60-0435-56-00 TESTING-WK-MO-QTR-ANNUAL 1,015.00 1,585.00 40,000.00 38,415.00 4.0 TOTAL TESTING-WK-MO-QTR-ANNUAL 1,015.00 1,585.00 40,000.00 38,415.00 4.0 DEQ REVOLVING LOAN PAYMENT 60-0436-01-00 DEQ/STATE REVOLVING LOAN PMT .00 121,208.65 100,000.00 ( 21,208.65) 121.2 TOTAL DEQ REVOLVING LOAN PAYMENT .00 121,208.65 100,000.00 ( 21,208.65) 121.2 STL FEES, RESTRICTED 60-0437-01-00 STL FEES, REIMB SYS EXPANSION 654,242.80 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 14,312.03 19,026.19 400,000.00 380,973.81 4.8 60-0437-99-01 RESERVES, STL FEES .00 .00 1,255,000.00 1,255,000.00 .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:28AM PAGE: 53 TOTAL STL FEES, RESTRICTED CAPITAL EXPENDITURES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT 668,554.83 773,658.99 1,905,000.00 1,131,341.01 40.6 60-0438-01-00 EQUIPMENT .00 .00 85,500.00 85,500.00 .0 60-0438-08-00 METER SETS, NEW CUSTOMERS 13,527.32 13,527.32 99,200.00 85,672.68 13.6 60-0438-11-00 CAPITAL CONSTRUCTION PROJECTS .00 .00 157,500.00 157,500.00 .0 60-0438-82-00 CITY HALLADMIN OVERHEAD 6,018.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 19,545.32 22,554.32 1,649,610.00 1,627,055.68 1.4 TOTAL FUND EXPENDITURES 867,726.82 1,296,941.82 4,954,400.00 3,657,458.18 26.2 NET REVENUE OVER EXPENDITURES ( 312,786.90) 2,316.20 .00 ( 2,316.20) .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:28AM PAGE: 54 CITY OF EAGLE BALANCE SHEET MARCH 31, 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 136,979.88 850,540.32 3,063,174.00 28,742.00 TOTAL ASSETS 4,079,436.20 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 1,129.74 337.48 3,048.37 72,649.00 TOTAL LIABILITIES 77,164.59 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 ( 442,201.97) 442,201.97) 4,002,271.61 4,079,436.20 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:28AM PAGE: 55 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 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 7,991.09 17,434.66 10,000.00 ( 7,434.66) 174.4 61-0398-00-00 ARPACARRYOVER .00 .00 1,593,580.00 1,593,580.00 .0 TOTAL FUND REVENUE EXPENDITURES PERSONNEL 7,991.09 17,434.66 1,823,550.00 1,806,115.34 1.0 61-0433-10-00 SALARIES - FULL TIME 34,602.76 74,572.76 351,900.00 277,327.24 21.2 61-0433-10-02 ON -CALL TIME .00 .00 7,500.00 7,500.00 .0 61-0433-11-00 OVERTIME 2,638.15 5,970.06 7,500.00 1,529.94 79.6 61-0433-21-00 FICA 2,979.95 6,262.52 27,500.00 21,237.48 22.8 61-0433-22-00 PERSI 4,387.11 9,228.20 42,100.00 32,871.80 21.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 5,497.68 9,720.64 53,500.00 43,779.36 18.2 61-0433-26-00 HSA CONTRIBUTION 75.00 125.00 2,400.00 2,275.00 5.2 61-0433-29-00 PTO CASH OUT 2,000.00 2,000.00 1,000.00 ( 1,000.00) 200.0 TOTAL PERSONNEL OPERATIONS & MAINTENANCE 52,180.65 109,224.44 503,240.00 394,015.56 21.7 61-0434-15-00 OFFICE SUPPLIES .00 .00 500.00 500.00 .0 61-0434-19-00 TELECOMMUNICATIONS 164.21 492.57 2,500.00 2,007.43 19.7 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 145.85 145.85 2,500.00 2,354.15 5.8 61-0434-26-00 TOOLS, EQUIPMENT AND SUPPLIES 1,749.33 4,823.56 12,500.00 7,676.44 38.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 .00 5,000.00 7,500.00 2,500.00 66.7 61-0434-42-00 ENGINEERING SERVICES 46,350.00 73,400.00 150,000.00 76,600.00 48.9 61-0434-42-01 LEGAL SERVICES 1,492.50 1,930.00 10,000.00 8,070.00 19.3 61-0434-43-00 TRAFFIC CONTROL 55.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 1,000.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 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:28AM PAGE: 56 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2024 FIBER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT 61-0434-50-01 SHOP UTILITIES 176.08 176.08 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 647.31 1,109.76 10,000.00 61-0434-57-00 REPAIR AND MAINT, VEHICLE 36.45 1,467.30 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 1,485.28 8,048.43 50,000.00 61-0434-58-02 REPAIR AND MAINT, BUILDINGS 158.29 222.11 .00 61-0434-59-00 REPAIR AND MAINT, EMERGENCIES .00 .00 75,000.00 61-0434-59-01 MATERIALS 142,995.94 247,618.14 425,000.00 61-0434-60-00 UTILITIES 396.41 1,174.06 .00 61-0434-68-00 UNIFORMS AND SAFETY CLOTHING 140.33 140.33 2,000.00 61-0434-69-00 CITY HALL ADMIN OVERHEAD 2,406.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,323.92 2.4 2,500.00 .0 1,500.00 .0 8,890.24 11.1 23,532.70 5.9 50,000.00 .0 41,951.57 16.1 222.11) .0 75,000.00 .0 177,381.86 58.3 1,174.06) .0 1,859.67 7.0 1,201.00 75.0 20,000.00 .0 199,398.98 350,412.19 1,105,310.00 754,897.81 31.7 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 251,579.63 459,636.63 1,823,550.00 1,363,913.37 25.2 NET REVENUE OVER EXPENDITURES ( 243,588.54) ( 442,201.97) .00 442,201.97 .0 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/16/2024 10:28AM PAGE: 57