The URL can be used to link to this page

Finance - Quarterly Reports - FY 22/23 3rd Quarter - 06/30/2023CITY OF EAGLE TREASURER'S REPORT FOR THE QUARTER ENDING JUNE 30, 2023 BEGINNING CASH ANNUAL %ANNUAL %CHANGE IN ENDING CASH FUND NUMBER AND TITLE BALANCE REVENUES REALIZED EXPENDITURES EXPENDED BALANCE SHEET BALANCE 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 08:59AM PAGE: 1 01 GENERAL FUND 1,087,062.66 2,562,598.79 50.16 3,056,763.64 47.38 ( 67,558.56)660,456.37 06 LIBRARY FUND 16,465.81 30,444.40 1.88 403,086.79 47.35 ( 356,176.58).00 07 MUSEUM FUND .00 27,524.64 50.42 27,476.88 49.35 47.76 .00 08 PARK IMPACT FEE FUND 22,169.33 70,887.58 3.51 66,924.90 42.26 597.22 25,534.79 09 RECREATION - SPECIAL EVENTS .00 41,246.70 26.19 42,968.07 54.49 ( 1,721.37).00 10 EAGLE HISTORICAL COMMISSION 20,610.34 .00 .00 .00 3.04 .00 20,610.34 11 EXECUTIVE DEPARTMENT .00 108,758.41 47.15 109,086.23 46.72 ( 327.82).00 12 CITY CLERK/TREAS DEPARTMENT .00 169,472.47 59.38 169,989.78 58.40 ( 517.31).00 13 BUILDING DEPARTMENT .00 241,200.38 64.58 244,180.11 61.75 ( 2,979.73).00 14 P&Z DEPARTMENT .00 279,750.34 60.00 280,228.84 59.64 ( 478.50).00 17 RECREATION - PARKS AND REC .00 141,790.81 49.19 145,890.06 49.15 ( 4,099.25).00 18 IT DEPARTMENT .00 242,590.06 64.29 239,979.09 61.65 2,610.97 .00 19 CAPITAL PROJECTS FUND 983,353.43 1,307,469.14 20.42 1,576,191.95 23.25 306,773.87 407,856.75 21 ARTS COMMISSION 627.50 262.00 .37 .00 ( .77).00 889.50 23 PUBLIC WORKS .00 639,991.15 49.01 646,541.22 47.90 ( 6,550.07).00 24 RECREATION - EAGLE FUN DAYS 59.47 16,997.08 12.84 16,018.90 15.42 .00 1,037.65 25 PATHWAY IMPACT FEE FUND 18,047.50 21,029.66 4.68 .00 79.61 208.16 38,869.00 26 ECONOMIC DEVELOPMENT .00 .00 .00 .00 .00 .00 .00 27 LAW ENF DEV IMPACT FEES 29,839.76 7,813.89 15.81 .00 .00 25,555.17 12,098.48 54 CITY HALL BOND FUND .00 450.00 9.25 450.00 9.25 .00 .00 60 WATER FUND 541,253.78 561,179.41 34.32 208,244.45 28.85 224,530.80 669,657.94 61 FIBER FUND 34,518.81 1,104.87 .18 174,349.55 15.86 ( 139,888.37)1,162.50 99 COMBINED CASH FUND ( 2,754,008.39).00 .00 .00 .00 ( 915,835.07) ( 1,838,173.32) TOTAL .00 6,472,561.78 7,408,370.46 ( 935,808.68).00 Citizens are invited to inspect the detailed supporting records of the attached financial statements. Idaho Code 50-1011 Making the Quarterly Treasurer’s Report available for public review on the City’s website shall satisfy publication requirements. Idaho Code 50-2080 For additional information, please contact Eagle City Hall, 208-939-6813. City of Eagle Kellie Rekow, CMC City Treasurer Posted to the City of Eagle website, July 14, 2023 CITY OF EAGLE COMBINED CASH INVESTMENT JUNE 30, 2023 FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:01AM PAGE: 1 COMBINED CASH ACCOUNTS 99-0103-00-00 CASH IN CHECKING 1,464,002.48 99-0108-00-00 CASH CLEARING-ACCOUNTS REC 374,170.84 TOTAL COMBINED CASH 1,838,173.32 99-0101-00-00 CASH ALLOCATED TO OTHER FUNDS ( 1,838,173.32) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 660,456.37 8 ALLOCATION TO PARK IMPACT FEE FUND 25,534.79 10 ALLOCATION TO EAGLE HISTORICAL COMMISSION 20,610.34 19 ALLOCATION TO CAPITAL PROJECTS FUND 407,856.75 21 ALLOCATION TO ARTS COMMISSION 889.50 24 ALLOCATION TO RECREATION - EAGLE FUN DAYS 1,037.65 25 ALLOCATION TO PATHWAY IMPACT FEE FUND 38,869.00 27 ALLOCATION TO LAW ENF DEV IMPACT FEES 12,098.48 60 ALLOCATION TO WATER FUND 669,657.94 61 ALLOCATION TO FIBER FUND 1,162.50 TOTAL ALLOCATIONS TO OTHER FUNDS 1,838,173.32 ALLOCATION FROM COMBINED CASH FUND - 99-0101-00-00 ( 1,838,173.32) ZERO PROOF IF ALLOCATIONS BALANCE .00 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 GENERAL FUND FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:01AM PAGE: 2 ASSETS 01-0101-00-00 CASH 660,456.37 01-0103-00-00 PETTY CASH 100.00 01-0107-00-00 TAXES RECEIVABLE DELINQUENT 12,084.19 01-0115-00-00 ACCOUNTS RECEIVABLE 64,082.51 01-0132-00-00 DUE FROM OTHER GOVERNMNTL UNTS 1,056,424.05 01-0151-25-00 INVESTMENTS 8,156,915.72 01-0151-28-00 ICCU CD 51,605.64 01-0170-00-00 HRA 10 % DEPOSIT 5,785.92 TOTAL ASSETS 10,007,454.40 LIABILITIES AND EQUITY LIABILITIES 01-0202-00-00 VOUCHERS PAYABLE ( 3,542.16) 01-0203-00-00 ACCTS PAYABLE-ACHD IMPACT FEES 45,409.00 01-0203-01-01 BONDS DEPOSITS PAYABLE 1,641,008.11 01-0203-01-02 FIREWORKS BOND DEPOSIT PAYABLE ( 2,000.00) 01-0203-01-03 VENDORS BOND DEPOSITS PAYABLE 5,425.25 01-0203-01-05 P&Z DEPOSITS PAYABLE 426,179.82 01-0203-01-06 LAND USE DEPOSITS PAYABLE 51,605.64 01-0217-04-00 PUBLIC RETIREMENT ( .02) 01-0217-07-00 GEN ADMIN HEALTH INSURANCE ( 10,779.13) 01-0217-07-01 COBRA- HEALTH INSURANCE ( 85.96) 01-0217-09-00 WORKERS' COMPENSATION 1,586.57 01-0226-00-00 DEFERRED REVENUE 11,060.32 TOTAL LIABILITIES 2,165,867.44 FUND EQUITY 01-0271-00-00 FUND BALANCE 7,303,482.60 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 538,104.36 BALANCE - CURRENT DATE 538,104.36 TOTAL FUND EQUITY 7,841,586.96 TOTAL LIABILITIES AND EQUITY 10,007,454.40 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:01AM PAGE: 3 REVENUE 01-0311-00-00 PROPERTY TAX 159,678.25 3,039,639.02 4,490,018.00 1,450,378.98 67.7 01-0311-01-00 PENALTY/INTEREST ON TAXES 1,046.05 2,701.07 4,000.00 1,298.93 67.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 3,771.33 22,265.30 20,000.00 ( 2,265.30)111.3 01-0316-11-00 FRANCHISE FEE/INTERMTN GAS 200,549.25 342,298.20 275,000.00 ( 67,298.20)124.5 01-0316-12-00 FRANCHISE FEE/CABLE TV 26,360.16 82,467.72 115,000.00 32,532.28 71.7 01-0316-13-00 FRANCHISE FEE/TRASH 71,190.78 273,158.92 300,000.00 26,841.08 91.1 01-0316-14-00 FRANCHISE FEE/IDAHO POWER 61,369.34 212,534.20 235,000.00 22,465.80 90.4 01-0321-10-00 BUSINESS, ALCOHOL, MISC-LCNSES 62,004.00 66,492.33 56,500.00 ( 9,992.33)117.7 01-0321-30-00 BUSINESS LICENSE FEE ( 2,200.00)( 25.00).00 25.00 .0 01-0322-10-00 BUILDING & INSPECTION PERMITS 282,431.07 811,092.11 1,135,000.00 323,907.89 71.5 01-0322-12-00 BUILDING, PLAN REVIEW FEES 112,656.83 371,085.30 475,250.00 104,164.70 78.1 01-0322-13-00 ENERGY STANDARDS (IRES)3,600.00 8,350.00 17,500.00 9,150.00 47.7 01-0322-14-00 ELECTRICAL PERMIT FEES 45,721.06 174,152.50 200,000.00 25,847.50 87.1 01-0322-15-00 PLUMBING PERMIT FEES 71,088.93 132,979.20 200,000.00 67,020.80 66.5 01-0322-16-00 MECHANICAL PERMIT FEES 51,274.84 122,599.36 200,000.00 77,400.64 61.3 01-0322-20-00 FIRE IMPACT ADMIN FEES 1,360.00 3,120.00 7,000.00 3,880.00 44.6 01-0323-01-00 PZ ANNEX/ZONING PERMIT FEES 44,485.50 164,685.43 170,000.00 5,314.57 96.9 01-0323-02-00 PLANNING INSPECTION FEES 2,260.00 9,570.00 5,000.00 ( 4,570.00)191.4 01-0323-03-00 PLANNING, PLAN REVIEW FEES 7,725.00 19,175.00 25,000.00 5,825.00 76.7 01-0323-04-00 STREET LIGHT INSPECTION FEES 280.00 650.00 800.00 150.00 81.3 01-0323-05-00 SURETY/LETTER OF CREDIT FEES 1,100.00 3,950.00 4,000.00 50.00 98.8 01-0323-06-00 GRADING-DRAINAGE PERMIT FEES 4,900.00 7,900.00 12,000.00 4,100.00 65.8 01-0323-10-00 SPRING VALLEY STAFF TIME REIMB 1,118.25 9,075.75 10,000.00 924.25 90.8 01-0323-11-00 AVIMOR STAFF TIME REIMBURSE 8,268.00 43,985.25 20,000.00 ( 23,985.25)219.9 01-0323-12-00 PZ STAFF TIME REIMBURSE .00 862.50 .00 ( 862.50).0 01-0324-01-00 TREE FUND 3,000.00 3,000.00 .00 ( 3,000.00).0 01-0335-10-00 STATE, LIQUOR 258,510.00 517,020.00 662,590.00 145,570.00 78.0 01-0335-50-00 STATE, SALES TAX - AG REPL 4.75 14.25 19.00 4.75 75.0 01-0335-60-00 STATE, REVENUE SHARING 814,183.95 2,583,070.51 3,743,404.00 1,160,333.49 69.0 01-0338-40-00 COURT FEES 20,630.17 54,291.32 35,000.00 ( 19,291.32)155.1 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-11-00 MISCELLANEOUS PERMITS/LICENSES ( 1,197.00).00 .00 .00 .0 01-0341-12-00 ANIMAL CONTROL FEES 1,405.00 8,807.00 10,000.00 1,193.00 88.1 01-0341-13-00 ENGINEERING FEES - DEVELOPERS 42,232.50 153,233.63 175,000.00 21,766.37 87.6 01-0341-14-00 ATTORNEY FEES - DEVELOPERS 14,299.22 49,910.72 20,000.00 ( 29,910.72)249.6 01-0341-16-00 CONSULTANT FEES - DEVELOPERS .00 4,485.00 .00 ( 4,485.00).0 01-0341-17-00 CID STAFF & MISC REIMBURSEMENT 698.74 1,621.33 1,200.00 ( 421.33)135.1 01-0341-20-00 REIMBURSE FROM WATER DEPT 6,705.00 10,057.50 13,410.00 3,352.50 75.0 01-0341-20-01 REIMBURSE FROM FIBER DEPT .00 .00 14,000.00 14,000.00 .0 01-0341-26-00 BACKGROUND CHECKS 293.72 851.97 1,500.00 648.03 56.8 01-0341-27-00 URA CITY STAFF REIMBURSEMENT 2,987.60 5,474.90 2,000.00 ( 3,474.90)273.8 01-0341-28-00 ID POWER SUBSTATION WATER USE 120.00 120.00 120.00 .00 100.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 .00 10,875.66 15,000.00 4,124.34 72.5 01-0350-05-00 FIELD OF HONOR 25,713.00 32,773.00 20,000.00 ( 12,773.00)163.9 01-0350-07-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 01-0365-01-00 PARKING IN LIEU OF PAYMENTS .00 11,400.00 .00 ( 11,400.00).0 01-0371-25-00 BANK INTEREST 71,606.63 79,652.10 8,500.00 ( 71,152.10)937.1 01-0379-00-00 MISCELLANEOUS REVENUE 11,942.32 38,453.69 1,000.00 ( 37,453.69)3845.4 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:01AM PAGE: 4 01-0379-01-00 DUPLICATION/PUBLISHING/PRINTNG ( 220.04)124.96 500.00 375.04 25.0 01-0382-02-00 PROMOTIONAL SALES .00 200.00 .00 ( 200.00).0 01-0383-05-00 MISCELLANEOUS-REIMBURSEABLES 7,573.09 8,328.39 1,500.00 ( 6,828.39)555.2 01-0383-09-00 ROOM RESERVATIONS 1,766.50 5,463.94 2,000.00 ( 3,463.94)273.2 01-0383-16-00 INSURANCE REIMBURSEABLES .00 3,571.75 .00 ( 3,571.75).0 01-0385-00-00 FIRE DEPT IMPACT FEES 58,305.00 188,436.48 313,950.00 125,513.52 60.0 01-0399-00-00 CARRY OVER .00 .00 6,309,626.00 6,309,626.00 .0 TOTAL FUND REVENUE 2,562,598.79 9,702,153.31 19,342,350.00 9,640,196.69 50.2 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:01AM PAGE: 5 RESERVES 01-0410-19-00 RESERVES, EMERGENCIES .00 .00 480,673.00 480,673.00 .0 TOTAL RESERVES .00 .00 480,673.00 480,673.00 .0 ADMINISTRATION 01-0413-01-00 P&Z COMMISSIONERS COMPENSATION 1,650.00 4,020.00 4,200.00 180.00 95.7 01-0413-02-00 DESIGN REVIEW BRD COMPENSATION 1,100.00 3,300.00 5,000.00 1,700.00 66.0 01-0413-05-00 OFFICE SUPPLIES 4,377.74 14,000.37 25,000.00 10,999.63 56.0 01-0413-06-00 PRINTING & DISTRIBUTION 223.20 223.20 500.00 276.80 44.6 01-0413-07-00 POSTAGE 3,087.93 8,118.79 12,500.00 4,381.21 65.0 01-0413-08-00 LEGAL ADVERTISING/PUBLICATION 507.08 2,215.86 5,000.00 2,784.14 44.3 01-0413-10-00 INSURANCE - PROPERTY .00 56,540.00 65,000.00 8,460.00 87.0 01-0413-12-00 PERSONNEL TRAINING .00 150.00 3,000.00 2,850.00 5.0 01-0413-13-00 TRAVEL & PER DIEM .00 154.00 2,000.00 1,846.00 7.7 01-0413-14-00 PROFESSIONAL DUES AND SERVICES 2,801.75 57,661.65 168,350.00 110,688.35 34.3 01-0413-25-00 MISCELLANEOUS .00 2.89 20,000.00 19,997.11 .0 01-0413-28-00 RESOURCE MATERIALS 236.31 1,886.50 6,500.00 4,613.50 29.0 01-0413-29-00 REAL PROPERTY TAXES - CITY 53.26 291.76 250.00 ( 41.76)116.7 01-0413-31-00 ENGINEERING FEES - DEVELOPERS 96,512.41 152,964.24 175,000.00 22,035.76 87.4 01-0413-33-00 ATTORNEY FEES - DEVELOPERS 19,001.72 48,638.72 20,000.00 ( 28,638.72)243.2 01-0413-37-00 BACKGROUND CHECK-PERMITS/LIC 2,136.47 3,294.53 2,000.00 ( 1,294.53)164.7 01-0413-40-00 INSURANCE REIMBURSEABLES .00 2,242.44 .00 ( 2,242.44).0 01-0413-44-00 PHOTOS - MAYOR/CITY COUNCIL .00 .00 900.00 900.00 .0 01-0413-50-00 JOB POSTINGS .00 .00 2,500.00 2,500.00 .0 01-0413-51-00 BACKGROUND CHK, PRE-EMPLOYMENT .00 .00 1,000.00 1,000.00 .0 01-0413-52-00 DRUG TESTING, PRE-EMPLOYMENT 295.00 714.00 1,000.00 286.00 71.4 TOTAL ADMINISTRATION 131,982.87 356,418.95 519,700.00 163,281.05 68.6 PERSONNEL 01-0415-11-00 SALARIES - COUNCIL 12,720.00 38,160.00 50,880.00 12,720.00 75.0 01-0415-21-00 FICA 973.08 2,919.24 4,000.00 1,080.76 73.0 01-0415-22-00 PERSI 1,518.72 4,556.16 6,200.00 1,643.84 73.5 01-0415-23-01 HRA/COBRA ADMIN FEES 453.90 951.35 1,800.00 848.65 52.9 01-0415-24-00 WORKERS' COMPENSATION 16.56 54,673.84 44,000.00 ( 10,673.84)124.3 01-0415-24-01 WORK COMP/BOARDS-COMMISSIONS .00 95.86 200.00 104.14 47.9 01-0415-28-00 UNEMPLOYMENT BENEFITS .00 .00 5,500.00 5,500.00 .0 TOTAL PERSONNEL 15,682.26 101,356.45 112,580.00 11,223.55 90.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:01AM PAGE: 6 CONTRACTS & AGREEMENTS 01-0416-02-00 CITY ATTORNEY 40,431.50 96,904.07 250,000.00 153,095.93 38.8 01-0416-05-00 PROSECUTOR 10,666.00 48,001.00 64,000.00 15,999.00 75.0 01-0416-06-00 IDAHO HUMANE SOCIETY 40,120.02 132,407.98 160,480.00 28,072.02 82.5 01-0416-07-00 CITY ENGINEERING 532.50 871.25 20,000.00 19,128.75 4.4 01-0416-08-00 CITY AUDITOR SERVICES .00 12,375.00 21,000.00 8,625.00 58.9 01-0416-09-00 LAW ENFORCEMENT DEPARTMENT 931,376.67 2,794,130.06 3,725,510.00 931,379.94 75.0 01-0416-34-00 BUDGET RESERVES, FY 1ST QTR .00 .00 97,647.00 97,647.00 .0 01-0416-35-00 ADMINISTRATION RESERVES .00 4,947.10 200,000.00 195,052.90 2.5 01-0416-46-00 ALLUMBAUGH HOUSE 4,437.25 13,311.75 24,020.00 10,708.25 55.4 01-0416-49-00 DRUGFREE IDAHO 495.22 1,369.90 1,500.00 130.10 91.3 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 .00 3,520.00 3,736.00 216.00 94.2 TOTAL CONTRACTS & AGREEMENTS 1,038,059.16 3,117,838.11 4,577,893.00 1,460,054.89 68.1 CODE ENFORCEMENT 01-0417-00-00 NUISANCE ABATEMENT .00 .00 1,000.00 1,000.00 .0 TOTAL CODE ENFORCEMENT .00 .00 1,000.00 1,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 2,154.62 7,367.05 20,000.00 12,632.95 36.8 01-0422-15-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 TOTAL RESTRICTED 2,154.62 7,367.05 39,000.00 31,632.95 18.9 PUBLIC AFFAIRS/COMM RELATIONS 01-0462-01-00 PUBLIC RELATIONS 1,829.67 4,213.22 6,000.00 1,786.78 70.2 01-0462-02-00 AWARDS & RECOGNITIONS .00 .00 1,500.00 1,500.00 .0 TOTAL PUBLIC AFFAIRS/COMM RELATIONS 1,829.67 4,213.22 7,500.00 3,286.78 56.2 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:01AM PAGE: 7 GENERAL FUND TRANSFERS 01-0463-01-00 MUSEUM DEPT TRANSFER 27,524.64 88,947.49 176,950.00 88,002.51 50.3 01-0463-02-00 ARTS COMMISSION TRANSFER .00 .00 75,120.00 75,120.00 .0 01-0463-04-00 HISTORICAL COMMISSION TRANSFER .00 .00 6,900.00 6,900.00 .0 01-0463-05-00 SPECIAL EVENTS TRANSFER 17,081.86 18,099.29 192,365.00 174,265.71 9.4 01-0463-06-00 RECREATION PARKS-REC TRANSFER 53,620.31 217,549.83 639,420.00 421,870.17 34.0 01-0463-07-00 CAPITAL PROJECTS TRANSFER .00 581,452.97 2,627,553.00 2,046,100.03 22.1 01-0463-08-00 EAGLE FUN DAYS TRANSFER 11,491.17 11,591.17 90,550.00 78,958.83 12.8 01-0463-11-00 PUBLIC WORKS TRANSFER 629,530.72 1,535,215.08 3,037,006.00 1,501,790.92 50.6 01-0463-11-01 EXECUTIVE DEPT TRANSFER 108,758.41 305,201.33 647,311.00 342,109.67 47.2 01-0463-12-00 CITY HALL BOND FUND TRANSFER 450.00 9,623.20 104,000.00 94,376.80 9.3 01-0463-12-01 CLERK/TREAS DEPT TRANSFER 169,472.47 488,813.93 823,180.00 334,366.07 59.4 01-0463-13-01 BUILDING DEPT TRANSFER 241,200.38 659,810.67 1,021,640.00 361,829.33 64.6 01-0463-14-01 PLANNING AND ZONING DEPT TRANS 279,750.34 799,208.59 1,332,040.00 532,831.41 60.0 01-0463-15-00 LIBRARY TRANSFER 26,120.78 26,120.78 1,402,353.00 1,376,232.22 1.9 01-0463-18-01 IT DEPT TRANSFER 242,590.06 649,782.30 1,010,650.00 360,867.70 64.3 01-0463-26-01 ECONOMIC DEV DEPT TRANSFER .00 757.06 .00 ( 757.06).0 TOTAL GENERAL FUND TRANSFERS 1,807,591.14 5,392,173.69 13,187,038.00 7,794,864.31 40.9 COMMUNITY PROJECTS-CAP OUTLAY 01-0468-10-00 VALLEY REGIONAL TRANSIT SERV .00 9,700.00 103,016.00 93,316.00 9.4 TOTAL COMMUNITY PROJECTS-CAP OUTLA .00 9,700.00 103,016.00 93,316.00 9.4 FIRE DEPARTMENT IMPACT FEES 01-0469-00-00 FIRE DEPT IMPACT FEES 59,463.92 174,981.48 313,950.00 138,968.52 55.7 TOTAL FIRE DEPARTMENT IMPACT FEES 59,463.92 174,981.48 313,950.00 138,968.52 55.7 TOTAL FUND EXPENDITURES 3,056,763.64 9,164,048.95 19,342,350.00 10,178,301.05 47.4 NET REVENUE OVER EXPENDITURES ( 494,164.85)538,104.36 .00 ( 538,104.36).0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 LIBRARY FUND FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:02AM PAGE: 8 ASSETS 06-0103-00-00 LIBRARY/PETTY CASH 300.00 06-0104-00-00 PETTY CASH-CHILDRENS PROGRAMS 300.00 06-0107-00-00 LIBRARY/TAXES RECEIVABLE 6,787.44 06-0170-00-00 HRA 10% DEPOSIT 1,872.00 TOTAL ASSETS 9,259.44 LIABILITIES AND EQUITY LIABILITIES 06-0202-00-00 LIBRARY/VOUCHERS PAYABLE 46.07 06-0216-00-00 LIBRARY/ACCRUED PAYROLL 19,220.15 06-0217-03-00 LIBRARY/FICA 3,039.93 06-0217-04-00 LIBRARY/PUBLIC RETIREMENT 3,284.67 06-0217-07-00 LIBRARY HEALTH INSURANCE 16,266.25 06-0217-09-00 WORKERS' COMPENSATION 16,557.22 06-0217-10-00 HSA CONTRIBUTION 2,454.00 06-0226-00-00 DEFERRED REVENUE 6,220.06 TOTAL LIABILITIES 67,088.35 FUND EQUITY 06-0271-00-00 LIBRARY/FUND BALANCE 962,049.97 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 1,019,878.88) BALANCE - CURRENT DATE ( 1,019,878.88) TOTAL FUND EQUITY ( 57,828.91) TOTAL LIABILITIES AND EQUITY 9,259.44 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:02AM PAGE: 9 REVENUE 06-0301-00-00 FUNDING FROM GENERAL FUND 26,120.78 26,120.78 1,402,353.00 1,376,232.22 1.9 06-0356-01-00 LIBRARY/PENALTY & INT PROP TXS .00 .00 1,500.00 1,500.00 .0 06-0361-20-00 LIBRARY, FINES, FEES 1,316.33 3,537.61 1,000.00 ( 2,537.61)353.8 06-0361-20-01 LOST ITEMS 1,721.14 5,319.45 2,500.00 ( 2,819.45)212.8 06-0361-21-00 LIBRARY COPY MACHINE 638.51 1,633.93 1,200.00 ( 433.93)136.2 06-0361-21-01 3 D PRINTING .00 49.08 400.00 350.92 12.3 06-0371-25-00 BANK INTEREST 22.18 845.75 1,200.00 354.25 70.5 06-0379-00-00 MISCELLANEOUS REVENUE .00 3,764.48 750.00 ( 3,014.48)501.9 06-0379-01-00 MISCELLANEOUS REV NON TAXABLE 625.46 625.46 .00 ( 625.46).0 06-0380-02-00 GRANTS-GIFTS-MEMORIALS .00 300.00 .00 ( 300.00).0 06-0399-00-00 CARRY OVER .00 .00 372,000.00 372,000.00 .0 06-0399-01-00 BUDGET RESERVE, FY 1ST QTR .00 .00 460,000.00 460,000.00 .0 TOTAL FUND REVENUE 30,444.40 42,196.54 2,242,903.00 2,200,706.46 1.9 EXPENDITURES RESERVES 06-0410-01-00 RESERVES .00 .00 470,000.00 470,000.00 .0 06-0410-01-01 RESERVES, LIBRARY MASTER PLAN .00 .00 50,000.00 50,000.00 .0 TOTAL RESERVES .00 .00 520,000.00 520,000.00 .0 CONTRACTS/AGREEMENTS 06-0416-01-00 LEGAL - CITY ATTORNEY 490.00 1,102.50 10,000.00 8,897.50 11.0 06-0416-02-00 PHOTOCOPIERS 1,796.94 7,847.29 11,500.00 3,652.71 68.2 TOTAL CONTRACTS/AGREEMENTS 2,286.94 8,949.79 21,500.00 12,550.21 41.6 OPERATIONS & MAINTENANCE 06-0420-01-00 ADMINISTRATION 2,352.52 13,637.58 15,000.00 1,362.42 90.9 06-0420-03-00 OPERATIONS SUBSCRIPTIONS 16,457.19 18,956.49 43,924.00 24,967.51 43.2 06-0420-04-00 MARKETING 1,490.47 6,495.40 15,000.00 8,504.60 43.3 06-0420-04-01 OUTREACH .00 .00 2,000.00 2,000.00 .0 06-0420-05-00 OFFICE SUPPLIES 1,580.59 5,098.40 8,500.00 3,401.60 60.0 06-0420-05-01 MATERIAL PROCESSING SUPPLIES 2,294.59 3,805.02 5,000.00 1,194.98 76.1 06-0420-06-00 UNIFORMS 545.35 978.89 4,180.00 3,201.11 23.4 06-0420-07-00 SMALL FURNITURE REPLACEMENT 6,996.42 11,289.84 1,500.00 ( 9,789.84)752.7 06-0420-09-00 MAINTENANCE AGREEMENTS 725.00 13,545.00 27,910.00 14,365.00 48.5 06-0420-10-00 POSTAGE 2,070.00 2,257.33 2,500.00 242.67 90.3 06-0420-11-00 SUBSCRIPTIONS & MEMBERSHIPS 180.50 2,550.85 9,030.00 6,479.15 28.3 06-0420-12-00 DEBT COLLECTION .00 152.15 .00 ( 152.15).0 06-0420-13-00 PRINTING AND PUBLISHING .00 .00 1,200.00 1,200.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:02AM PAGE: 10 TOTAL OPERATIONS & MAINTENANCE 34,692.63 78,766.95 135,744.00 56,977.05 58.0 LYNX1 CONSORTIUM 06-0430-00-00 LYNX! SYSTEM 12,109.06 18,163.59 25,000.00 6,836.41 72.7 06-0430-02-00 LYNX! COURIER 7,906.15 11,599.55 14,124.00 2,524.45 82.1 TOTAL LYNX1 CONSORTIUM 20,015.21 29,763.14 39,124.00 9,360.86 76.1 COST RECOVERY OR PASS THRU 06-0435-00-00 CREDIT CARD PROCESSING FEE 928.48 2,521.50 3,000.00 478.50 84.1 06-0435-01-00 3D PRINTING .00 .00 400.00 400.00 .0 06-0435-02-00 LOST ITEMS REFUNDS .00 5.00 300.00 295.00 1.7 06-0435-03-00 OPEN ACCESS 522.80 1,563.69 1,200.00 ( 363.69)130.3 TOTAL COST RECOVERY OR PASS THRU 1,451.28 4,090.19 4,900.00 809.81 83.5 TECHNOLOGY 06-0440-00-00 COMPUTER SOFTWARE 378.60 378.60 10,650.00 10,271.40 3.6 06-0440-01-00 COMPUTER MAINTENANCE & REPAIR .00 .00 1,250.00 1,250.00 .0 06-0440-02-00 COMPUTER EQUIPMENT (SMALL)9,209.15 9,249.14 3,100.00 ( 6,149.14)298.4 TOTAL TECHNOLOGY 9,587.75 9,627.74 15,000.00 5,372.26 64.2 GUEST RESOURCES 06-0450-00-00 BOOKS 34,623.17 106,309.18 143,116.00 36,806.82 74.3 06-0450-01-00 PRINT VENDOR PROCESSING 1,655.78 4,424.92 7,376.00 2,951.08 60.0 06-0450-02-00 BOOKS -DIGITAL 11,263.12 25,723.15 63,682.00 37,958.85 40.4 06-0450-03-00 MAGAZINES & NEWSPAPERS .00 3,248.51 4,308.00 1,059.49 75.4 06-0450-03-01 MAGAZINES - DIGITAL 980.00 8,355.00 10,647.00 2,292.00 78.5 06-0450-04-00 MEDIA 20,243.77 41,825.83 79,073.00 37,247.17 52.9 06-0450-05-00 MEDIA - DIGITAL 4,541.00 9,006.99 61,434.00 52,427.01 14.7 06-0450-06-00 DATABASES .00 9,286.00 11,845.00 2,559.00 78.4 06-0450-07-00 HOTSPOT 707.23 1,968.60 2,800.00 831.40 70.3 TOTAL GUEST RESOURCES 74,014.07 210,148.18 384,281.00 174,132.82 54.7 GUEST CLASSES & EVENTS 06-0455-00-00 CLASSES & EVENTS 9,797.76 19,232.58 20,000.00 767.42 96.2 TOTAL GUEST CLASSES & EVENTS 9,797.76 19,232.58 20,000.00 767.42 96.2 PERSONNEL CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:02AM PAGE: 11 06-0461-10-00 SALARIES - FULL TIME 139,028.04 396,840.25 526,900.00 130,059.75 75.3 06-0461-10-01 SALARIES - PERSONNEL SERVICES 715.50 951.98 .00 ( 951.98).0 06-0461-11-00 OVERTIME 1,003.42 3,570.27 5,000.00 1,429.73 71.4 06-0461-15-00 SALARIES - PART TIME 30,069.62 105,416.59 276,000.00 170,583.41 38.2 06-0461-15-01 SALARIES - PERSONNEL SERVICES 7,579.53 11,725.73 .00 ( 11,725.73).0 06-0461-21-00 FICA 12,889.73 38,143.81 55,183.00 17,039.19 69.1 06-0461-22-00 PERSI 17,189.95 48,031.10 56,648.00 8,616.90 84.8 06-0461-23-00 HRA BUY-DOWN 1,540.00 1,540.00 5,500.00 3,960.00 28.0 06-0461-23-01 HRA/COBRA ADMIN FEES 292.80 758.75 900.00 141.25 84.3 06-0461-24-00 WORKERS' COMPENSATION 664.44 3,140.69 2,918.00 ( 222.69)107.6 06-0461-25-00 INSURANCE 20,429.47 54,147.77 78,405.00 24,257.23 69.1 06-0461-26-00 HSA CONTRIBUTION 509.99 1,649.99 8,160.00 6,510.01 20.2 06-0461-27-00 PTO CASH OUT 3,938.02 3,938.02 10,000.00 6,061.98 39.4 06-0461-28-00 UNEMPLOYMENT BENEFITS .00 .00 18,540.00 18,540.00 .0 06-0461-29-00 EMPLOYMENT TESTING .00 .00 1,000.00 1,000.00 .0 TOTAL PERSONNEL 235,850.51 669,854.95 1,045,154.00 375,299.05 64.1 STAFF DEVELOPMENT 06-0463-00-00 TRAVEL & PER DIEM .00 416.66 11,400.00 10,983.34 3.7 06-0463-01-00 MILEAGE REIMBURSEMENT 16.57 16.57 500.00 483.43 3.3 06-0463-02-00 TRAINING .00 .00 1,000.00 1,000.00 .0 06-0463-03-00 CONTINUING EDUCATION 2,148.00 5,329.99 6,300.00 970.01 84.6 06-0463-08-00 VIRTUAL TRAINING 253.94 253.94 1,500.00 1,246.06 16.9 TOTAL STAFF DEVELOPMENT 2,418.51 6,017.16 20,700.00 14,682.84 29.1 FACILITY (BLDGS & GROUNDS) 06-0464-00-00 BUILDING .00 .00 1,500.00 1,500.00 .0 06-0464-01-00 BUILDING SUPPLIES .00 .00 1,500.00 1,500.00 .0 06-0464-02-00 UTILITIES 4,643.72 16,667.67 27,000.00 10,332.33 61.7 06-0464-03-00 TELEPHONE 660.68 660.68 1,000.00 339.32 66.1 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 521.22 1,149.88 1,500.00 350.12 76.7 TOTAL FACILITY (BLDGS & GROUNDS)5,825.62 18,478.23 36,500.00 18,021.77 50.6 CAPITAL IMPROVEMENT 06-0466-01-00 CAPITAL FURNISHING 7,146.51 7,146.51 .00 ( 7,146.51).0 TOTAL CAPITAL IMPROVEMENT 7,146.51 7,146.51 .00 ( 7,146.51).0 TOTAL FUND EXPENDITURES 403,086.79 1,062,075.42 2,242,903.00 1,180,827.58 47.4 NET REVENUE OVER EXPENDITURES ( 372,642.39)( 1,019,878.88).00 1,019,878.88 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:02AM PAGE: 12 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 MUSEUM FUND FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:03AM PAGE: 13 LIABILITIES AND EQUITY LIABILITIES 07-0217-03-00 FICA 246.54 07-0217-04-00 MUSEUM/PERSI RETIREMENT 240.94 07-0217-07-00 MUSEUM HEALTH INSURANCE 435.43 07-0217-09-00 WORKERS' COMPENSATION 1,585.82 TOTAL LIABILITIES 2,508.73 FUND EQUITY 07-0271-00-00 MUSEUM FUND BALANCE ( 4,421.71) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,912.98 BALANCE - CURRENT DATE 1,912.98 TOTAL FUND EQUITY ( 2,508.73) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:03AM PAGE: 14 REVENUE 07-0316-12-00 FUNDING FROM GENERAL FUND 27,524.64 88,947.49 176,950.00 88,002.51 50.3 07-0376-00-00 CONTRIBUTIONS AND DONATIONS .00 202.00 500.00 298.00 40.4 07-0379-00-00 MISCELLANEOUS REVENUE .00 300.00 25.00 ( 275.00)1200.0 07-0379-02-00 ARCADIA BOOKS SALES/ROYALTIES .00 117.00 250.00 133.00 46.8 07-0379-03-00 SALES TAX REVENUE .00 .00 5.00 5.00 .0 07-0380-00-00 GIFT SHOP REVENUE .00 60.29 25.00 ( 35.29)241.2 TOTAL FUND REVENUE 27,524.64 89,626.78 177,755.00 88,128.22 50.4 EXPENDITURES PERSONNEL 07-0420-10-00 SALARIES - FULL TIME 17,570.15 64,549.25 102,900.00 38,350.75 62.7 07-0420-15-00 SALARIES - PART TIME .00 .00 20,000.00 20,000.00 .0 07-0420-21-00 FICA 1,344.11 4,937.98 9,500.00 4,562.02 52.0 07-0420-22-00 PERSI 2,097.89 7,707.24 12,350.00 4,642.76 62.4 07-0420-24-00 WORKERS' COMPENSATION 31.63 116.53 .00 ( 116.53).0 07-0420-25-00 INSURANCE 1,357.49 4,158.23 6,100.00 1,941.77 68.2 07-0420-27-00 HRA BUY DOWN .00 .00 3,080.00 3,080.00 .0 TOTAL PERSONNEL 22,401.27 81,469.23 153,930.00 72,460.77 52.9 EDUCATION 07-0461-02-00 ASSOCIATION MEMBERSHIP .00 169.50 325.00 155.50 52.2 07-0461-03-00 CONFERENCES & SEMINARS .00 55.00 500.00 445.00 11.0 07-0461-04-00 TRAVEL & PER DIEM .00 .00 750.00 750.00 .0 TOTAL EDUCATION .00 224.50 1,575.00 1,350.50 14.3 ADMINISTRATION 07-0462-30-00 CONSERVATION AND PRESERVATION .00 .00 250.00 250.00 .0 07-0462-31-00 OFFICE SUPPLIES 26.98 96.97 1,000.00 903.03 9.7 07-0462-32-00 ARCHIVAL SUPPLIES .00 .00 1,000.00 1,000.00 .0 07-0462-33-00 PUBLICITY-PRINTING .00 .00 500.00 500.00 .0 07-0462-34-00 RESEARCH MATERIAL .00 340.30 200.00 ( 140.30)170.2 07-0462-35-00 UNIFORMS .00 280.50 400.00 119.50 70.1 07-0462-68-00 MUSEUM PROGRAMS .00 253.67 1,500.00 1,246.33 16.9 07-0462-69-00 MISCELLANEOUS .00 .00 5,700.00 5,700.00 .0 07-0462-73-00 EAGLE BOOK-ARCADIA PUBLISHING .00 .00 300.00 300.00 .0 TOTAL ADMINISTRATION 26.98 971.44 10,850.00 9,878.56 9.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 MUSEUM FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:03AM PAGE: 15 EXHIBITS 07-0463-01-00 DISPLAY SUPPLIES .00 .00 300.00 300.00 .0 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 5,048.63 5,048.63 10,000.00 4,951.37 50.5 TOTAL EXHIBITS 5,048.63 5,048.63 11,400.00 6,351.37 44.3 TOTAL FUND EXPENDITURES 27,476.88 87,713.80 177,755.00 90,041.20 49.4 NET REVENUE OVER EXPENDITURES 47.76 1,912.98 .00 ( 1,912.98).0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 PARK IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:03AM PAGE: 16 ASSETS 08-0101-00-00 CASH 25,534.79 08-0151-25-00 INVESTMENTS 250,030.89 TOTAL ASSETS 275,565.68 LIABILITIES AND EQUITY FUND EQUITY 08-0271-00-00 PARK FUND/FUND BALANCE 1,952,745.69 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 1,677,180.01) BALANCE - CURRENT DATE ( 1,677,180.01) TOTAL FUND EQUITY 275,565.68 TOTAL LIABILITIES AND EQUITY 275,565.68 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 PARK IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:03AM PAGE: 17 REVENUE 08-0322-19-00 PARKS DEVELOPMENT IMPACT FEES 70,290.36 149,506.48 390,502.00 240,995.52 38.3 08-0371-25-00 BANK INTEREST 597.22 2,202.56 4,500.00 2,297.44 49.0 08-0399-00-00 CARRY OVER .00 .00 3,933,000.00 3,933,000.00 .0 TOTAL FUND REVENUE 70,887.58 151,709.04 4,328,002.00 4,176,292.96 3.5 EXPENDITURES CAPITAL IMPROVEMENTS 08-0438-37-00 CAPITAL IMPROVEMENTS 66,924.90 1,828,889.05 4,328,002.00 2,499,112.95 42.3 TOTAL CAPITAL IMPROVEMENTS 66,924.90 1,828,889.05 4,328,002.00 2,499,112.95 42.3 TOTAL FUND EXPENDITURES 66,924.90 1,828,889.05 4,328,002.00 2,499,112.95 42.3 NET REVENUE OVER EXPENDITURES 3,962.68 ( 1,677,180.01).00 1,677,180.01 .0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 RECREATION - SPECIAL EVENTS FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:03AM PAGE: 18 LIABILITIES AND EQUITY LIABILITIES 09-0217-03-00 FICA 243.03 09-0217-04-00 PUBLIC RETIREMENT 337.51 09-0217-07-00 HEALTH INSURANCE 16,287.48 09-0217-09-00 WORKERS' COMPENSATION 16,234.54 09-0217-10-00 HSA CONTRIBUTION 3,319.35 TOTAL LIABILITIES 36,421.91 FUND EQUITY 09-0271-00-00 FUND BALANCE 31,185.68 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 67,607.59) BALANCE - CURRENT DATE ( 67,607.59) TOTAL FUND EQUITY ( 36,421.91) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:03AM PAGE: 19 REVENUE 09-0301-00-00 FUNDING FROM GENERAL FUND 17,081.86 18,099.29 192,365.00 174,265.71 9.4 09-0347-06-00 COUNTRY CHRISTMAS .00 2,410.12 2,750.00 339.88 87.6 09-0347-08-00 SATURDAY MARKET 19,050.57 19,050.57 22,500.00 3,449.43 84.7 09-0347-10-00 GAZEBO CONCERT SERIES 14.27 14.27 825.00 810.73 1.7 09-0347-11-00 HARVEST FEST MARKET .00 1,474.44 2,750.00 1,275.56 53.6 09-0376-12-00 MISCELLANEOUS REVENUE 750.00 3,817.33 .00 ( 3,817.33).0 09-0376-13-00 SPONSORSHIPS 3,250.00 15,000.00 15,000.00 .00 100.0 09-0376-15-00 EVENT APPLICATION FEES 1,100.00 2,700.00 1,500.00 ( 1,200.00)180.0 09-0376-17-00 SECURITY DEPOSIT .00 .00 1,200.00 1,200.00 .0 TOTAL FUND REVENUE 41,246.70 62,566.02 238,890.00 176,323.98 26.2 EXPENDITURES PERSONNEL 09-0420-10-00 SALARIES - FULL TIME 21,285.80 60,816.57 115,800.00 54,983.43 52.5 09-0420-11-00 OVERTIME 232.23 275.24 2,000.00 1,724.76 13.8 09-0420-21-00 FICA 1,632.75 4,635.27 8,900.00 4,264.73 52.1 09-0420-22-00 PERSI 2,569.27 7,294.44 13,900.00 6,605.56 52.5 09-0420-24-00 WORKERS' COMPENSATION 643.26 1,830.14 .00 ( 1,830.14).0 09-0420-25-00 INSURANCE 2,508.33 7,467.00 13,900.00 6,433.00 53.7 09-0420-26-00 HSA CONTRIBUTION 150.00 450.00 1,200.00 750.00 37.5 09-0420-27-00 HRA BUY-DOWN .00 .00 1,540.00 1,540.00 .0 09-0420-29-00 PTO CASH OUT .00 .00 2,500.00 2,500.00 .0 TOTAL PERSONNEL 29,021.64 82,768.66 159,740.00 76,971.34 51.8 ADMINISTRATION 09-0463-11-00 OFFICE SUPPLIES .00 .00 800.00 800.00 .0 09-0463-12-00 PROMOTIONS 6,973.00 8,003.28 14,000.00 5,996.72 57.2 09-0463-19-00 TRAINING AND EDUCATION .00 726.25 1,200.00 473.75 60.5 09-0463-20-00 TRAVEL & PER DIEM .00 .00 4,000.00 4,000.00 .0 09-0463-21-00 PROFESSIONAL DUES .00 2,739.00 2,150.00 ( 589.00)127.4 09-0463-22-00 UNIFORMS 665.50 665.50 1,000.00 334.50 66.6 09-0463-23-00 GAS AND OIL .00 146.73 100.00 ( 46.73)146.7 09-0463-25-00 SECURITY DEPOSIT REFUND .00 .00 1,200.00 1,200.00 .0 09-0463-26-00 MEMBERSHIPS 12.99 12.99 700.00 687.01 1.9 TOTAL ADMINISTRATION 7,651.49 12,293.75 25,150.00 12,856.25 48.9 ACTIVITIES 09-0467-02-00 EAGLE SATURDAY MARKET 2,690.00 8,442.96 11,000.00 2,557.04 76.8 09-0467-03-00 COUNTRY CHRISTMAS .00 7,754.10 8,000.00 245.90 96.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 RECREATION - SPECIAL EVENTS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:03AM PAGE: 20 09-0467-04-00 GAZEBO CONCERT SERIES 2,000.00 2,000.00 10,000.00 8,000.00 20.0 09-0467-05-00 GENERAL EVENTS 1,309.94 3,766.81 10,000.00 6,233.19 37.7 09-0467-06-00 EAGLE HARVEST FEST .00 4,048.86 4,000.00 ( 48.86)101.2 09-0467-19-00 EVENT EQUIPMENT PURCHASES .00 1,540.20 3,000.00 1,459.80 51.3 09-0467-20-00 EVENT EQUIPMENT RENTAL 295.00 7,558.27 8,000.00 441.73 94.5 TOTAL ACTIVITIES 6,294.94 35,111.20 54,000.00 18,888.80 65.0 TOTAL FUND EXPENDITURES 42,968.07 130,173.61 238,890.00 108,716.39 54.5 NET REVENUE OVER EXPENDITURES ( 1,721.37)( 67,607.59).00 67,607.59 .0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 EAGLE HISTORICAL COMMISSION FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:03AM PAGE: 21 ASSETS 10-0101-00-00 CASH 20,610.34 TOTAL ASSETS 20,610.34 LIABILITIES AND EQUITY FUND EQUITY 10-0271-00-00 FUND BALANCE 21,002.34 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 392.00) BALANCE - CURRENT DATE ( 392.00) TOTAL FUND EQUITY 20,610.34 TOTAL LIABILITIES AND EQUITY 20,610.34 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 EAGLE HISTORICAL COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:04AM PAGE: 22 REVENUE 10-0316-12-00 FUNDING FROM GENERAL FUND .00 .00 6,900.00 6,900.00 .0 10-0333-01-00 GRANTS, STATE .00 .00 6,000.00 6,000.00 .0 TOTAL FUND REVENUE .00 .00 12,900.00 12,900.00 .0 EXPENDITURES ADMINISTRATION 10-0462-02-00 PUBLICITY - PRINTING .00 392.00 500.00 108.00 78.4 10-0462-05-00 TRAINING AND EDUCATION .00 .00 200.00 200.00 .0 TOTAL ADMINISTRATION .00 392.00 700.00 308.00 56.0 PROGRAMS 10-0464-08-00 COMM ENGAGEMENT/SPECIAL EVENTS .00 .00 200.00 200.00 .0 TOTAL PROGRAMS .00 .00 200.00 200.00 .0 GRANTS 10-0465-04-00 SHPO GRANT PROJECTS .00 .00 12,000.00 12,000.00 .0 TOTAL GRANTS .00 .00 12,000.00 12,000.00 .0 TOTAL FUND EXPENDITURES .00 392.00 12,900.00 12,508.00 3.0 NET REVENUE OVER EXPENDITURES .00 ( 392.00).00 392.00 .0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 EXECUTIVE DEPARTMENT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:04AM PAGE: 23 LIABILITIES AND EQUITY LIABILITIES 11-0216-00-00 ACCRUED PAYROLL 1,750.00 11-0217-03-00 FICA 452.83 11-0217-04-00 EXEC DEPT/PUBLIC RETIREMENT 675.73 11-0217-07-00 EXEC DEPT HEALTH INSURANCE ( 3,326.10) 11-0217-09-00 WORKERS' COMPENSATION 10,478.46 11-0217-10-00 HSA CONTRIBUTION ( 224.00) TOTAL LIABILITIES 9,806.92 FUND EQUITY 11-0271-00-00 FUND BALANCE ( 12,592.83) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 2,785.91 BALANCE - CURRENT DATE 2,785.91 TOTAL FUND EQUITY ( 9,806.92) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:04AM PAGE: 24 REVENUE 11-0301-00-00 FUNDING FROM GENERAL FUND 108,758.41 305,201.33 647,311.00 342,109.67 47.2 TOTAL FUND REVENUE 108,758.41 305,201.33 647,311.00 342,109.67 47.2 EXPENDITURES ADMINISTRATION 11-0413-04-00 UNIFORMS 743.00 743.00 600.00 ( 143.00)123.8 11-0413-05-00 OFFICE SUPPLIES .00 429.32 750.00 320.68 57.2 11-0413-06-00 DUPLICATION/PUBLISHING/PRINT .00 .00 750.00 750.00 .0 11-0413-12-00 PERSONNEL TRAINING 1,034.00 1,618.00 5,000.00 3,382.00 32.4 11-0413-13-00 TRAVEL & PER DIEM 10.00 63.25 6,000.00 5,936.75 1.1 11-0413-14-00 PROFESSIONAL DUES 668.00 1,621.97 4,453.00 2,831.03 36.4 11-0413-20-00 MARKETING 1,081.74 1,241.44 15,028.00 13,786.56 8.3 TOTAL ADMINISTRATION 3,536.74 5,716.98 32,581.00 26,864.02 17.6 PERSONNEL 11-0415-10-00 SALARIES - FULL TIME 77,310.54 220,796.13 336,000.00 115,203.87 65.7 11-0415-11-00 OVERTIME .00 368.90 500.00 131.10 73.8 11-0415-21-00 FICA 5,662.95 16,253.35 25,800.00 9,546.65 63.0 11-0415-22-00 PERSI 9,230.90 26,407.16 40,200.00 13,792.84 65.7 11-0415-24-00 WORKERS' COMPENSATION 1,320.25 3,947.65 .00 ( 3,947.65).0 11-0415-25-00 INSURANCE 9,003.24 24,290.00 38,700.00 14,410.00 62.8 11-0415-26-00 HSA CONTRIBUTION .00 180.00 1,200.00 1,020.00 15.0 11-0415-27-00 PTO CASH OUT .00 .00 10,000.00 10,000.00 .0 11-0415-28-00 HRA BUY-DOWN .00 .00 3,080.00 3,080.00 .0 TOTAL PERSONNEL 102,527.88 292,243.19 455,480.00 163,236.81 64.2 STATE OF THE CITY 11-0417-01-00 STATE OF THE CITY 1,707.87 2,393.96 4,250.00 1,856.04 56.3 TOTAL STATE OF THE CITY 1,707.87 2,393.96 4,250.00 1,856.04 56.3 COMPREHENSIVE PLAN REWRITE 11-0418-00-00 COMP PLAN REWRITE .00 .00 150,000.00 150,000.00 .0 TOTAL COMPREHENSIVE PLAN REWRITE .00 .00 150,000.00 150,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 EXECUTIVE DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:04AM PAGE: 25 COMMUNITY & STAFF RELATIONS 11-0422-01-00 COMMUNITY/STAFF RELATIONS 1,705.63 2,061.29 5,000.00 2,938.71 41.2 11-0422-02-00 STAFF RELATIONS ( 391.89).00 .00 .00 .0 TOTAL COMMUNITY & STAFF RELATIONS 1,313.74 2,061.29 5,000.00 2,938.71 41.2 TOTAL FUND EXPENDITURES 109,086.23 302,415.42 647,311.00 344,895.58 46.7 NET REVENUE OVER EXPENDITURES ( 327.82)2,785.91 .00 ( 2,785.91).0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 CITY CLERK/TREAS DEPARTMENT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:04AM PAGE: 26 LIABILITIES AND EQUITY LIABILITIES 12-0216-00-00 ACCRUED PAYROLL 7,001.54 12-0217-02-00 FEDERAL WITHHOLDING TAX .02 12-0217-03-00 FICA 1,420.86 12-0217-04-00 CLERKS DEPT/PUBLIC RETIREMENT 2,212.17 12-0217-07-00 CLERK DEPT HEALTH INSURANCE 552.10 12-0217-09-00 WORKERS' COMPENSATION 7,937.45 TOTAL LIABILITIES 19,124.14 FUND EQUITY 12-0271-00-00 FUND BALANCE ( 27,232.73) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 8,108.59 BALANCE - CURRENT DATE 8,108.59 TOTAL FUND EQUITY ( 19,124.14) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 CITY CLERK/TREAS DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:04AM PAGE: 27 REVENUE 12-0301-00-00 FUNDING FROM GENERAL FUND 169,472.47 488,813.93 823,180.00 334,366.07 59.4 TOTAL FUND REVENUE 169,472.47 488,813.93 823,180.00 334,366.07 59.4 EXPENDITURES ADMINISTRATION 12-0413-05-00 OFFICE SUPPLIES 68.42 359.37 5,000.00 4,640.63 7.2 12-0413-06-00 DUPLICATION/PUBLISHING/PRINT .00 .00 150.00 150.00 .0 12-0413-12-00 PERSONNEL TRAINING & RESOURCES 1,579.00 2,906.34 12,500.00 9,593.66 23.3 12-0413-13-00 TRAVEL & PER DIEM 1,153.59 2,969.93 10,000.00 7,030.07 29.7 12-0413-14-00 PROFESSIONAL DUES 125.00 3,624.00 5,500.00 1,876.00 65.9 12-0413-29-00 UNIFORMS 634.90 634.90 800.00 165.10 79.4 12-0413-30-00 MISCELLANEOUS 32.54 164.98 500.00 335.02 33.0 TOTAL ADMINISTRATION 3,593.45 10,659.52 34,450.00 23,790.48 30.9 PERSONNEL 12-0415-10-00 SALARIES - FULL TIME 119,944.68 341,250.67 570,500.00 229,249.33 59.8 12-0415-11-00 OVERTIME .00 .00 4,000.00 4,000.00 .0 12-0415-21-00 FICA 9,138.23 25,840.04 43,800.00 17,959.96 59.0 12-0415-22-00 PERSI 14,775.84 41,780.17 64,750.00 22,969.83 64.5 12-0415-23-00 HRA BUY- DOWN 1,042.11 1,303.38 10,780.00 9,476.62 12.1 12-0415-23-02 HSA CONTRIBUTION 300.00 900.00 1,200.00 300.00 75.0 12-0415-24-00 WORKERS' COMPENSATION 222.80 631.65 .00 ( 631.65).0 12-0415-25-00 INSURANCE 17,166.49 49,672.73 83,700.00 34,027.27 59.4 12-0415-26-00 PTO CASH OUT 3,806.18 8,667.18 10,000.00 1,332.82 86.7 TOTAL PERSONNEL 166,396.33 470,045.82 788,730.00 318,684.18 59.6 TOTAL FUND EXPENDITURES 169,989.78 480,705.34 823,180.00 342,474.66 58.4 NET REVENUE OVER EXPENDITURES ( 517.31)8,108.59 .00 ( 8,108.59).0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 BUILDING DEPARTMENT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:05AM PAGE: 28 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 BLDG DEPT/PUBLIC RETIREMENT 2,022.42 13-0217-07-00 BLDG DEPT HEALTH INSURANCE 4,438.95 13-0217-09-00 WORKERS' COMPENSATION 56,364.38 13-0217-10-00 HSA CONTRIBUTION ( 1,900.00) TOTAL LIABILITIES 67,389.26 FUND EQUITY 13-0271-00-00 FUND BALANCE ( 96,243.86) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 28,954.60 BALANCE - CURRENT DATE 28,954.60 TOTAL FUND EQUITY ( 67,289.26) TOTAL LIABILITIES AND EQUITY 100.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:05AM PAGE: 29 REVENUE 13-0301-00-00 FUNDING FROM GENERAL FUND 241,200.38 659,810.67 1,021,640.00 361,829.33 64.6 TOTAL FUND REVENUE 241,200.38 659,810.67 1,021,640.00 361,829.33 64.6 EXPENDITURES ADMINISTRATION 13-0413-05-00 OFFICE SUPPLIES 3,790.09 3,840.80 6,500.00 2,659.20 59.1 13-0413-08-00 LEGAL ADS & PUBLICATIONS .00 .00 400.00 400.00 .0 13-0413-09-00 COMMERCIAL PLAN REVIEW 2,880.00 6,435.00 5,000.00 ( 1,435.00)128.7 13-0413-12-00 TRAINING & CERTIFICATION RENEW 175.00 3,136.00 4,500.00 1,364.00 69.7 13-0413-13-00 TRAVEL & PER DIEM .00 .00 2,000.00 2,000.00 .0 13-0413-14-00 PROFESSIONAL DUES 145.00 585.00 700.00 115.00 83.6 13-0413-25-00 MISCELLANEOUS .00 .00 400.00 400.00 .0 13-0413-28-00 RESOURCE MATERIALS 1,403.00 1,403.00 1,500.00 97.00 93.5 13-0413-30-00 UNIFORMS .00 1,705.70 2,000.00 294.30 85.3 TOTAL ADMINISTRATION 8,393.09 17,105.50 23,000.00 5,894.50 74.4 PERSONNEL 13-0415-10-00 SALARIES - FULL TIME 90,345.90 257,331.37 394,800.00 137,468.63 65.2 13-0415-11-00 OVERTIME 28.36 180.01 4,000.00 3,819.99 4.5 13-0415-21-00 FICA 6,667.74 18,981.33 30,200.00 11,218.67 62.9 13-0415-22-00 PERSI 10,790.74 30,747.00 47,500.00 16,753.00 64.7 13-0415-23-00 HRA BUY-DOWN .00 .00 9,240.00 9,240.00 .0 13-0415-24-00 WORKERS' COMPENSATION 3,011.92 8,579.27 .00 ( 8,579.27).0 13-0415-25-00 INSURANCE 15,909.66 46,638.81 78,500.00 31,861.19 59.4 13-0415-26-00 HSA CONTRIBUTION 300.00 1,200.00 2,400.00 1,200.00 50.0 13-0415-28-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 TOTAL PERSONNEL 127,054.32 363,657.79 571,640.00 207,982.21 63.6 CONTRACTS & AGREEMENTS 13-0416-09-00 PLUMBING INSPECTOR 38,412.11 69,296.69 120,000.00 50,703.31 57.8 13-0416-11-00 MECHANICAL INSPECTOR 29,104.25 64,301.58 120,000.00 55,698.42 53.6 13-0416-13-00 BLDG INSPECTOR 7,940.00 21,008.00 61,500.00 40,492.00 34.2 13-0416-14-00 PLAN REVIEW - CONTRACT .00 .00 5,000.00 5,000.00 .0 13-0416-25-00 ELECTRICAL INSPECTOR 33,235.68 95,403.90 120,000.00 24,596.10 79.5 TOTAL CONTRACTS & AGREEMENTS 108,692.04 250,010.17 426,500.00 176,489.83 58.6 VEHICLE OPERATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 BUILDING DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:05AM PAGE: 30 13-0417-02-00 GAS AND OIL 40.66 82.61 500.00 417.39 16.5 TOTAL VEHICLE OPERATIONS 40.66 82.61 500.00 417.39 16.5 TOTAL FUND EXPENDITURES 244,180.11 630,856.07 1,021,640.00 390,783.93 61.8 NET REVENUE OVER EXPENDITURES ( 2,979.73)28,954.60 .00 ( 28,954.60).0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 P&Z DEPARTMENT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:05AM PAGE: 31 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 P&Z DEPT/PUBLIC RETIREMENT 5,215.16 14-0217-07-00 P&Z DEPT HEALTH INSURANCE ( 40,923.01) 14-0217-08-00 P&Z DEPT/GARNISHMENTS 203.34 14-0217-09-00 WORKERS' COMPENSATION 81,229.13 TOTAL LIABILITIES 58,924.81 FUND EQUITY 14-0271-00-00 FUND BALANCE ( 63,698.43) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 4,773.62 BALANCE - CURRENT DATE 4,773.62 TOTAL FUND EQUITY ( 58,924.81) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:05AM PAGE: 32 REVENUE 14-0301-00-00 FUNDING FROM GENERAL FUND 279,750.34 799,208.59 1,332,040.00 532,831.41 60.0 TOTAL FUND REVENUE 279,750.34 799,208.59 1,332,040.00 532,831.41 60.0 EXPENDITURES ADMINISTRATION 14-0413-05-00 OFFICE SUPPLIES 290.50 730.13 1,800.00 1,069.87 40.6 14-0413-06-00 DUPLICATION/PUBLISHING/PRNTG .00 .00 1,000.00 1,000.00 .0 14-0413-08-00 LEGAL ADS & PUBLICATIONS 1,049.82 3,165.43 8,000.00 4,834.57 39.6 14-0413-12-00 PERSONNEL TRAINING 718.00 1,414.00 5,100.00 3,686.00 27.7 14-0413-13-00 TRAVEL & PER DIEM 640.98 1,115.06 15,000.00 13,884.94 7.4 14-0413-14-00 PROFESSIONAL DUES .00 1,306.00 2,500.00 1,194.00 52.2 14-0413-25-00 MISCELLANEOUS .00 .00 1,000.00 1,000.00 .0 14-0413-26-00 REIMBURSE-ANNEX/ZONING/DR FEES .00 .00 3,000.00 3,000.00 .0 14-0413-28-00 RESOURCE MATERIALS .00 8.53 800.00 791.47 1.1 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 2,699.30 7,739.15 43,700.00 35,960.85 17.7 PERSONNEL 14-0415-10-00 SALARIES - FULL TIME 195,185.20 569,435.23 898,000.00 328,564.77 63.4 14-0415-10-01 SALARIES - PERSONNEL SERVICES 7,588.92 8,103.24 .00 ( 8,103.24).0 14-0415-11-00 OVERTIME 2,105.72 7,253.35 13,000.00 5,746.65 55.8 14-0415-21-00 FICA 15,055.58 43,553.74 69,800.00 26,246.26 62.4 14-0415-22-00 PERSI 23,815.89 69,027.74 108,900.00 39,872.26 63.4 14-0415-24-00 WORKERS' COMPENSATION 2,426.16 6,912.85 .00 ( 6,912.85).0 14-0415-25-00 INSURANCE 24,490.40 71,033.00 124,700.00 53,667.00 57.0 14-0415-26-00 HSA CONTRIBUTION 300.00 900.00 1,200.00 300.00 75.0 14-0415-29-00 PTO CASH OUT 3,324.62 3,324.62 15,000.00 11,675.38 22.2 14-0415-30-00 HRA BUY- DOWN 1,479.55 3,019.55 16,940.00 13,920.45 17.8 TOTAL PERSONNEL 275,772.04 782,563.32 1,247,540.00 464,976.68 62.7 CONTRACTS & AGREEMENTS 14-0416-02-00 TRAILS CONSULTANTS-STUDIES .00 .00 20,000.00 20,000.00 .0 14-0416-03-00 PROFESSIONAL SERVICE CONTRACTS 1,757.50 4,132.50 10,000.00 5,867.50 41.3 TOTAL CONTRACTS & AGREEMENTS 1,757.50 4,132.50 30,000.00 25,867.50 13.8 PUBLIC RELATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 P&Z DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:05AM PAGE: 33 14-0422-01-00 PUBLIC RELATIONS .00 .00 200.00 200.00 .0 TOTAL PUBLIC RELATIONS .00 .00 200.00 200.00 .0 CAPITAL OUTLAY 14-0465-03-00 OFFICE EQUIPMENT .00 .00 600.00 600.00 .0 TOTAL CAPITAL OUTLAY .00 .00 600.00 600.00 .0 COMMUNITY PLANNING PROJECTS 14-0468-11-00 OTHER .00 .00 10,000.00 10,000.00 .0 TOTAL COMMUNITY PLANNING PROJECTS .00 .00 10,000.00 10,000.00 .0 TOTAL FUND EXPENDITURES 280,228.84 794,434.97 1,332,040.00 537,605.03 59.6 NET REVENUE OVER EXPENDITURES ( 478.50)4,773.62 .00 ( 4,773.62).0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 RECREATION - PARKS AND REC FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:05AM PAGE: 34 LIABILITIES AND EQUITY LIABILITIES 17-0217-02-00 FEDERAL WITHOLDING TAX 29.48 17-0217-03-00 FICA 1,637.19 17-0217-04-00 PUBLIC RETIREMENT 1,079.92 17-0217-07-00 HEALTH INSURANCE ( 12,764.80) 17-0217-09-00 WORKERS' COMPENSATION 48,936.85 17-0217-10-00 HSA CONTRIBUTION ( 4,225.93) TOTAL LIABILITIES 34,692.71 FUND EQUITY 17-0271-00-00 FUND BALANCE ( 34,960.88) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 268.17 BALANCE - CURRENT DATE 268.17 TOTAL FUND EQUITY ( 34,692.71) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 RECREATION - PARKS AND REC PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:05AM PAGE: 35 REVENUE 17-0301-00-00 FUNDING FROM GENERAL FUND 53,620.31 217,549.83 639,420.00 421,870.17 34.0 17-0302-00-00 REGISTRATION, CAMPS & CLASSES 65,274.49 138,670.84 112,000.00 ( 26,670.84)123.8 17-0302-01-00 SPONSORSHIPS .00 .00 10,000.00 10,000.00 .0 17-0302-03-00 PARK RESERVATION FEES 22,896.01 28,625.63 20,000.00 ( 8,625.63)143.1 17-0399-00-00 CARRY OVER .00 .00 1,000.00 1,000.00 .0 TOTAL FUND REVENUE 141,790.81 384,846.30 782,420.00 397,573.70 49.2 EXPENDITURES CONTRACTS 17-0416-00-00 CONTRACT-PERMITS-CAMPS/CLASSES .00 .00 20,000.00 20,000.00 .0 17-0416-01-00 CONTRACT-PERMITS TEAM SPORTS .00 5,793.00 14,000.00 8,207.00 41.4 TOTAL CONTRACTS .00 5,793.00 34,000.00 28,207.00 17.0 PERSONNEL 17-0420-10-00 SALARIES - FULL TIME 77,652.75 219,884.33 351,200.00 131,315.67 62.6 17-0420-10-01 SALARIES - PERSONNEL SERVICES 10,416.36 18,690.81 .00 ( 18,690.81).0 17-0420-11-00 SALARIES - SEASONAL 1,183.36 1,399.55 .00 ( 1,399.55).0 17-0420-15-00 SALARIES - PART TIME .00 .00 115,200.00 115,200.00 .0 17-0420-18-00 OVERTIME 51.56 150.82 4,000.00 3,849.18 3.8 17-0420-21-00 FICA 6,146.06 16,978.44 35,800.00 18,821.56 47.4 17-0420-22-00 PERSI 9,478.56 26,478.50 42,100.00 15,621.50 62.9 17-0420-23-00 HRA BUY-DOWN .00 .00 4,620.00 4,620.00 .0 17-0420-24-00 WORKERS' COMPENSATION 2,937.05 8,154.06 .00 ( 8,154.06).0 17-0420-25-00 INSURANCE 8,664.22 24,925.27 51,800.00 26,874.73 48.1 17-0420-26-00 HSA CONTRIBUTION 450.00 1,350.00 1,200.00 ( 150.00)112.5 17-0420-27-00 PTO CASH OUT 1,630.77 1,630.77 5,000.00 3,369.23 32.6 TOTAL PERSONNEL 118,610.69 319,642.55 610,920.00 291,277.45 52.3 RESTRICTED 17-0421-00-00 SCHOLARSHIP FUNDS .00 .00 1,000.00 1,000.00 .0 TOTAL RESTRICTED .00 .00 1,000.00 1,000.00 .0 ADMINISTRATION 17-0422-00-00 TRAINING-PROFESSIONAL DEV 67.76 535.59 2,000.00 1,464.41 26.8 17-0422-01-00 OFFICE SUPPLIES 176.98 379.64 1,000.00 620.36 38.0 17-0422-02-00 ADVERTISING/MKTNG CAMP/CLASS .00 200.00 1,500.00 1,300.00 13.3 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:06AM PAGE: 36 17-0422-02-01 ADVERTISING/MKTNG TEAM SPORTS .00 .00 2,000.00 2,000.00 .0 17-0422-04-00 GAS AND OIL 43.37 265.69 100.00 ( 165.69)265.7 17-0422-05-00 COMMUNICATION 74.00 296.00 .00 ( 296.00).0 17-0422-06-00 PRINTING AND PUBLISHING 60.00 470.53 500.00 29.47 94.1 17-0422-07-00 PROFESSIONAL DUES 99.00 1,147.90 1,000.00 ( 147.90)114.8 17-0422-08-00 TRAINING AND EDUCATION ( 134.03)1,530.97 3,000.00 1,469.03 51.0 17-0422-09-00 TRAVEL & PER DIEM 2,588.09 2,588.09 5,000.00 2,411.91 51.8 17-0422-10-00 BACKGROUND CHECKS 3,844.09 7,185.39 3,000.00 ( 4,185.39)239.5 17-0422-11-00 REFUNDS-PARK REC PROGRAMS 485.00 740.00 7,600.00 6,860.00 9.7 TOTAL ADMINISTRATION 7,304.26 15,339.80 26,700.00 11,360.20 57.5 RECREATION 17-0423-00-00 REC SUPPLIES-CAMPS & CLASSES 1,767.60 1,905.79 10,000.00 8,094.21 19.1 17-0423-00-01 REC SUPPLIES-TEAM SPORTS 4,839.01 14,020.43 20,000.00 5,979.57 70.1 17-0423-01-00 UNIFORMS, TEAM SPORTS 7,202.82 18,884.64 15,000.00 ( 3,884.64)125.9 17-0423-02-00 FIELD TRIPS 3,882.29 3,903.29 20,000.00 16,096.71 19.5 17-0423-04-00 TRANSPORTATION SERVICES 2,018.75 2,018.75 15,000.00 12,981.25 13.5 17-0423-05-00 DADDY DAUGHTER DANCE .00 1,848.06 1,500.00 ( 348.06)123.2 17-0423-07-00 GLOW IN THE PARK .00 .00 6,000.00 6,000.00 .0 17-0423-08-00 HALLOWEEN TRICK-OR-TREAT .00 149.99 800.00 650.01 18.8 17-0423-09-00 VETERAN'S BREAKFAST .00 752.54 1,000.00 247.46 75.3 17-0423-20-00 NEW PROGRAMS 100.00 100.00 2,000.00 1,900.00 5.0 TOTAL RECREATION 19,810.47 43,583.49 91,300.00 47,716.51 47.7 VEHICLES 17-0424-03-00 GAS AND OIL 121.65 176.30 1,000.00 823.70 17.6 TOTAL VEHICLES 121.65 176.30 1,000.00 823.70 17.6 CAPITAL EQUIPMENT 17-0425-00-00 REC EQUIPMENT-TEAM SPORTS .00 .00 15,000.00 15,000.00 .0 17-0425-01-00 REC EQUIPMENT-CAMPS/CLASSES .00 .00 1,000.00 1,000.00 .0 TOTAL CAPITAL EQUIPMENT .00 .00 16,000.00 16,000.00 .0 CAPITAL OUTLAY 17-0460-02-00 FURNITURE 42.99 42.99 1,500.00 1,457.01 2.9 TOTAL CAPITAL OUTLAY 42.99 42.99 1,500.00 1,457.01 2.9 TOTAL FUND EXPENDITURES 145,890.06 384,578.13 782,420.00 397,841.87 49.2 NET REVENUE OVER EXPENDITURES ( 4,099.25)268.17 .00 ( 268.17).0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:06AM PAGE: 37 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 IT DEPARTMENT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:06AM PAGE: 38 LIABILITIES AND EQUITY LIABILITIES 18-0217-03-00 FICA 555.58 18-0217-04-00 PUBLIC RETIRMENT 936.81 18-0217-07-00 HEALTH INSURANCE ( 35,347.49) 18-0217-09-00 WORKERS' COMPENSATION 2,223.04 18-0217-10-00 HSA CONTRIBUTION 820.00 TOTAL LIABILITIES ( 30,812.06) FUND EQUITY 18-0271-00-00 FUND BALANCE 4,077.44 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 26,734.62 BALANCE - CURRENT DATE 26,734.62 TOTAL FUND EQUITY 30,812.06 TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:06AM PAGE: 39 REVENUE 18-0301-00-00 FUNDING FROM GENERAL FUND 242,590.06 649,782.30 1,010,650.00 360,867.70 64.3 TOTAL FUND REVENUE 242,590.06 649,782.30 1,010,650.00 360,867.70 64.3 EXPENDITURES ADMINISTRATION 18-0413-01-00 OFFICE SUPPLIES .00 51.78 1,000.00 948.22 5.2 18-0413-02-00 SUPPLIES 35.00 90.00 4,000.00 3,910.00 2.3 18-0413-03-00 TRAINING AND EDUCATION .00 .00 7,000.00 7,000.00 .0 18-0413-04-00 TRAVEL & PER DIEM 1,172.98 5,285.10 7,000.00 1,714.90 75.5 18-0413-05-00 PROFESSIONAL DUES .00 .00 750.00 750.00 .0 18-0413-06-00 UNIFORMS .00 .00 800.00 800.00 .0 TOTAL ADMINISTRATION 1,207.98 5,426.88 20,550.00 15,123.12 26.4 PERSONNEL 18-0415-10-00 SALARIES - FULL TIME 66,180.63 190,793.46 292,800.00 102,006.54 65.2 18-0415-11-00 IT DEPT/OVERTIME 358.72 996.48 5,000.00 4,003.52 19.9 18-0415-21-00 FICA 4,814.76 13,865.75 22,500.00 8,634.25 61.6 18-0415-22-00 PERSI 7,890.82 22,845.65 35,200.00 12,354.35 64.9 18-0415-23-00 HRA BUY- DOWN .00 1,540.00 6,200.00 4,660.00 24.8 18-0415-24-00 WORKERS' COMPENSATION 119.58 345.64 .00 ( 345.64).0 18-0415-25-00 INSURANCE 10,386.99 30,419.67 55,500.00 25,080.33 54.8 18-0415-26-00 HSA 180.01 540.01 2,400.00 1,859.99 22.5 18-0415-27-00 PTO CASH OUT .00 .00 2,500.00 2,500.00 .0 TOTAL PERSONNEL 89,931.51 261,346.66 422,100.00 160,753.34 61.9 CONTRACT & AGREEMENTS 18-0416-01-00 CONTRACT AND AGREEMENTS 105,371.32 252,313.52 350,000.00 97,686.48 72.1 18-0416-02-00 REPAIR & SERVICES 251.84 251.84 .00 ( 251.84).0 TOTAL CONTRACT & AGREEMENTS 105,623.16 252,565.36 350,000.00 97,434.64 72.2 INTERNET/PHONE SERVICES 18-0417-01-00 INTERNET & PHONE SERVICES 19,790.80 43,773.36 78,000.00 34,226.64 56.1 18-0417-02-00 REPAIRS & SERVICES .00 37.99 .00 ( 37.99).0 TOTAL INTERNET/PHONE SERVICES 19,790.80 43,811.35 78,000.00 34,188.65 56.2 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 IT DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:06AM PAGE: 40 OPERATIONAL RESERVES 18-0418-01-00 IT EQUIPMENT/SOFTWARE 5,717.33 17,536.27 35,000.00 17,463.73 50.1 TOTAL OPERATIONAL RESERVES 5,717.33 17,536.27 35,000.00 17,463.73 50.1 CAPITAL OUTLAY 18-0419-01-00 FURNITURE .00 .00 1,000.00 1,000.00 .0 18-0419-02-00 EQUIPMENT 12,668.31 37,321.16 65,000.00 27,678.84 57.4 18-0419-03-00 SOFTWARE PURCHASES 5,040.00 5,040.00 25,000.00 19,960.00 20.2 18-0419-04-00 WEBSITE DEVELOPMENT .00 .00 12,000.00 12,000.00 .0 18-0419-05-00 TOOLS .00 .00 2,000.00 2,000.00 .0 TOTAL CAPITAL OUTLAY 17,708.31 42,361.16 105,000.00 62,638.84 40.3 TOTAL FUND EXPENDITURES 239,979.09 623,047.68 1,010,650.00 387,602.32 61.7 NET REVENUE OVER EXPENDITURES 2,610.97 26,734.62 .00 ( 26,734.62).0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 CAPITAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:06AM PAGE: 41 ASSETS 19-0101-00-00 CASH 407,856.75 19-0115-00-00 ACCOUNTS RECEIVABLE 158,448.60 19-0151-25-00 INVESTMENTS 5,730,789.80 TOTAL ASSETS 6,297,095.15 LIABILITIES AND EQUITY LIABILITIES 19-0225-00-00 UNEARNED GRANT REVENUE, ARPA 1,976,588.98 TOTAL LIABILITIES 1,976,588.98 FUND EQUITY 19-0271-00-00 FUND BALANCE 4,802,108.10 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 481,601.93) BALANCE - CURRENT DATE ( 481,601.93) TOTAL FUND EQUITY 4,320,506.17 TOTAL LIABILITIES AND EQUITY 6,297,095.15 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:06AM PAGE: 42 REVENUE 19-0301-00-00 FUNDING FROM GENERAL FUND .00 581,452.97 2,627,553.00 2,046,100.03 22.1 19-0301-03-00 FOOTHILLS REIMB AGREEMENT .00 .00 100,000.00 100,000.00 .0 19-0301-05-00 EAGLE RD PED/BIKE BRIDGE 1,300,695.27 2,631,229.23 3,180,852.00 549,622.77 82.7 19-0301-06-00 STATE HWY 44 PED CROSSING .00 5,631.61 .00 ( 5,631.61).0 19-0301-12-00 FEMA GENERAL REVENUE .00 243,951.73 1,511,385.00 1,267,433.27 16.1 19-0331-01-00 ARPA, AMERICAN RESCUE PLAN ACT .00 .00 9,003.00 9,003.00 .0 19-0371-25-00 BANK INTEREST 6,773.87 13,786.34 4,100.00 ( 9,686.34)336.3 19-0399-00-00 CARRY OVER .00 .00 7,504,498.00 7,504,498.00 .0 19-0399-01-00 CARRY OVER, ARPA FUNDS .00 .00 2,088,020.00 2,088,020.00 .0 TOTAL FUND REVENUE 1,307,469.14 3,476,051.88 17,025,411.00 13,549,359.12 20.4 EXPENDITURES RESERVES 19-0410-01-00 RESERVES, FUTURE PROJECTS .00 .00 3,833,211.00 3,833,211.00 .0 TOTAL RESERVES .00 .00 3,833,211.00 3,833,211.00 .0 CAPITAL MAINTENANCE 19-0462-01-00 CAPITAL MAINTENANCE SET ASIDE 36,617.45 70,476.42 3,026,380.00 2,955,903.58 2.3 19-0462-03-00 FEMA TRAIL REPLACEMENT .00 .00 676,491.00 676,491.00 .0 TOTAL CAPITAL MAINTENANCE 36,617.45 70,476.42 3,702,871.00 3,632,394.58 1.9 CITY CAPITAL PROJECTS 19-0465-05-00 GENERAL CITY PROJECTS .00 .00 100,000.00 100,000.00 .0 19-0465-07-00 LAND PURCHASES .00 960,181.67 .00 ( 960,181.67).0 19-0465-08-00 CURRENT FISCAL YEAR PROJECTS 332.50 28,897.50 1,513,000.00 1,484,102.50 1.9 TOTAL CITY CAPITAL PROJECTS 332.50 989,079.17 1,613,000.00 623,920.83 61.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 1,438,061.23 1,926,656.96 3,300,000.00 1,373,343.04 58.4 19-0466-09-00 EAGLE-STATE ST INTERSECTION .00 .00 848,309.00 848,309.00 .0 19-0466-10-00 P&Z CAPITAL PROJECTS .00 .00 40,000.00 40,000.00 .0 TOTAL PZ CAPITAL PROJECTS 1,438,061.23 1,926,656.96 4,868,309.00 2,941,652.04 39.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 CAPITAL PROJECTS FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:06AM PAGE: 43 PARK CAPITAL PROJECTS 19-0467-02-00 PARK CAPITAL PROJECTS .00 3,595.00 200,000.00 196,405.00 1.8 TOTAL PARK CAPITAL PROJECTS .00 3,595.00 200,000.00 196,405.00 1.8 PW CAPITAL PROJECTS 19-0469-09-00 PW CAPITAL PROJECTS .00 .00 350,000.00 350,000.00 .0 TOTAL PW CAPITAL PROJECTS .00 .00 350,000.00 350,000.00 .0 TRAILS & PATHWAYS 19-0473-03-00 GREENBELT MAINTENANCE .00 .00 370,000.00 370,000.00 .0 TOTAL TRAILS & PATHWAYS .00 .00 370,000.00 370,000.00 .0 FEDERAL FUNDS PROJECTS 19-0486-01-00 ARPA, CAPITAL PROJECTS, TBD 73,790.17 197,586.24 1,159,000.00 961,413.76 17.1 19-0486-01-01 ARPA, SOFTWARE PURCHASES 27,390.60 59,390.60 .00 ( 59,390.60).0 19-0486-01-02 ARPA, MISC LEGAL .00 157.50 .00 ( 157.50).0 19-0486-01-03 ARPA, FIBER EQUIPMENT .00 333,958.99 .00 ( 333,958.99).0 19-0486-01-04 ARPA, FACILITIES .00 ( 4,295.42).00 4,295.42 .0 19-0486-01-05 ARPA, FIBER MATERIALS .00 214,952.35 .00 ( 214,952.35).0 19-0486-02-00 ARPA, FIBER NETWORK CONNECT .00 166,096.00 929,020.00 762,924.00 17.9 TOTAL FEDERAL FUNDS PROJECTS 101,180.77 967,846.26 2,088,020.00 1,120,173.74 46.4 TOTAL FUND EXPENDITURES 1,576,191.95 3,957,653.81 17,025,411.00 13,067,757.19 23.3 NET REVENUE OVER EXPENDITURES ( 268,722.81)( 481,601.93).00 481,601.93 .0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 ARTS COMMISSION FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:07AM PAGE: 44 ASSETS 21-0101-00-00 CASH 889.50 TOTAL ASSETS 889.50 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 889.50 BALANCE - CURRENT DATE 889.50 TOTAL FUND EQUITY 889.50 TOTAL LIABILITIES AND EQUITY 889.50 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 ARTS COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:07AM PAGE: 45 REVENUE 21-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 75,120.00 75,120.00 .0 21-0376-07-00 DONATIONS .00 .00 1,000.00 1,000.00 .0 21-0376-09-00 SCHOLARSHIPS .00 .00 500.00 500.00 .0 21-0376-11-00 GALLERY MAINTENANCE 260.00 260.00 500.00 240.00 52.0 21-0376-12-00 POSTCARD REVENUE 2.00 29.50 380.00 350.50 7.8 TOTAL FUND REVENUE 262.00 289.50 77,500.00 77,210.50 .4 EXPENDITURES ADMINISTRATION 21-0420-00-00 ADMINISTRATION .00 .00 1,500.00 1,500.00 .0 21-0420-01-00 POSTCARD EXPENDITURES .00 .00 300.00 300.00 .0 TOTAL ADMINISTRATION .00 .00 1,800.00 1,800.00 .0 ART EDUCATION 21-0421-00-00 ART EDUCATION & ADVOCACY .00 ( 600.00)24,000.00 24,600.00 ( 2.5) TOTAL ART EDUCATION .00 ( 600.00)24,000.00 24,600.00 ( 2.5) ART INSTALLATION 21-0422-00-00 ARTS IN PUBLIC SPACES/BEAUTIFY .00 .00 33,000.00 33,000.00 .0 TOTAL ART INSTALLATION .00 .00 33,000.00 33,000.00 .0 ACQUISITION OF ART 21-0423-00-00 ACQUISITION OF ART .00 .00 1,500.00 1,500.00 .0 TOTAL ACQUISITION OF ART .00 .00 1,500.00 1,500.00 .0 COMMUNITY EVENTS 21-0425-00-00 COMMUNITY EVENTS .00 .00 17,100.00 17,100.00 .0 TOTAL COMMUNITY EVENTS .00 .00 17,100.00 17,100.00 .0 GALLERY MTNC/SUPPLIES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 ARTS COMMISSION YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:07AM PAGE: 46 21-0427-00-00 GALLERY MTNC/SLUPPLIES .00 .00 100.00 100.00 .0 TOTAL GALLERY MTNC/SUPPLIES .00 .00 100.00 100.00 .0 TOTAL FUND EXPENDITURES .00 ( 600.00)77,500.00 78,100.00 ( .8) NET REVENUE OVER EXPENDITURES 262.00 889.50 .00 ( 889.50).0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 PUBLIC WORKS FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:07AM PAGE: 47 LIABILITIES AND EQUITY LIABILITIES 23-0202-00-00 VOUCHERS PAYABLE ( 156.08) 23-0216-00-00 ACCRUED PAYROLL 10,783.10 23-0217-02-00 FEDERAL WITHHOLDING 25.57 23-0217-03-00 FICA 3,569.98 23-0217-04-00 PUBLIC RETIREMENT 2,814.49 23-0217-05-00 PW DEPT MISC DEDUCTIONS ( 14,386.03) 23-0217-07-00 HEALTH INSURANCE ( 2,945.72) 23-0217-08-00 GARNISHMENT ( 920.20) 23-0217-09-00 WORKERS' COMPENSATION 136,858.56 23-0217-10-00 HSA CONTRIBUTION ( 1,160.00) TOTAL LIABILITIES 134,483.67 FUND EQUITY 23-0271-00-00 FUND BALANCE ( 169,515.86) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 35,032.19 BALANCE - CURRENT DATE 35,032.19 TOTAL FUND EQUITY ( 134,483.67) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:07AM PAGE: 48 REVENUE 23-0302-00-00 FUNDING FROM GENERAL FUND 629,530.72 1,535,215.08 3,037,006.00 1,501,790.92 50.6 23-0315-02-00 SIDEWALKS, LTS, TREES, STR-REP .00 600.00 100,000.00 99,400.00 .6 23-0315-06-00 TREE FUNDS, CARRYOVER .00 1,500.00 29,511.00 28,011.00 5.1 23-0315-09-00 WYCLIFF PUMP STATION 5,452.43 11,123.53 6,690.00 ( 4,433.53)166.3 23-0316-00-00 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 23-0316-01-00 MEMORIAL DONATIONS 2,508.00 7,227.65 6,000.00 ( 1,227.65)120.5 23-0316-13-00 SPONSORSHIPS 2,500.00 2,500.00 .00 ( 2,500.00).0 TOTAL FUND REVENUE 639,991.15 1,558,166.26 3,179,507.00 1,621,340.74 49.0 EXPENDITURES PERSONNEL 23-0433-10-00 SALARIES-FULL TIME 226,813.83 588,941.88 1,127,000.00 538,058.12 52.3 23-0433-10-01 SALARIES - PERSONNEL SERVICES 70,425.34 123,728.60 50,000.00 ( 73,728.60)247.5 23-0433-11-00 OVERTIME 3,220.62 7,393.42 18,600.00 11,206.58 39.8 23-0433-15-00 SALARIES - PART TIME .00 64.79 .00 ( 64.79).0 23-0433-16-00 SALARIES -SEASONAL 215.50 215.50 145,000.00 144,784.50 .2 23-0433-21-00 FICA 17,435.42 45,257.60 97,500.00 52,242.40 46.4 23-0433-22-00 PERSI 27,788.01 72,240.56 135,000.00 62,759.44 53.5 23-0433-23-00 HRA BUY-DOWN 1,539.99 1,539.99 10,780.00 9,240.01 14.3 23-0433-24-00 WORKERS' COMPENSATION 8,992.36 23,544.55 .00 ( 23,544.55).0 23-0433-25-00 INSURANCE 35,040.13 93,487.87 230,500.00 137,012.13 40.6 23-0433-26-00 HSA CONTRIBUTION 1,210.00 3,430.00 4,800.00 1,370.00 71.5 23-0433-29-00 PTO CASH OUT 2,479.92 8,413.47 10,000.00 1,586.53 84.1 TOTAL PERSONNEL 395,161.12 968,258.23 1,829,180.00 860,921.77 52.9 ADMINISTRATION 23-0435-01-00 OFFICE SUPPLIES 560.80 560.80 1,000.00 439.20 56.1 23-0435-02-00 PRINT, PUBLISH, LEGAL, ADV 122.50 122.50 8,500.00 8,377.50 1.4 23-0435-03-00 TRAINING, EDUCATION, TRVL, ETC 5,195.51 13,946.20 22,225.00 8,278.80 62.8 23-0435-04-00 DUES, CERTIFICATIONS, LICENSES 225.00 353.75 1,000.00 646.25 35.4 23-0435-09-00 STAFF AND PUBLIC RELATIONS 762.05 762.05 1,000.00 237.95 76.2 23-0435-10-00 SAFETY CLOTHING AND GEAR 1,765.52 3,298.56 6,500.00 3,201.44 50.8 TOTAL ADMINISTRATION 8,631.38 19,043.86 40,225.00 21,181.14 47.3 IRRIGATION CONTRACTS/AGRMNTS 23-0437-01-00 WYCLIFFE PUMP STATION 1,122.76 2,217.64 6,690.00 4,472.36 33.2 23-0437-02-00 IRRIGATION SHARES AND DUES .00 14,326.20 5,350.00 ( 8,976.20)267.8 23-0437-03-00 BASELINE MANAGER AGREEMENT 3,582.00 3,582.00 3,750.00 168.00 95.5 23-0437-04-00 CHAUMONT LEASE AGREEMENT .00 1.00 1.00 .00 100.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:07AM PAGE: 49 TOTAL IRRIGATION CONTRACTS/AGRMNTS 4,704.76 20,126.84 15,791.00 ( 4,335.84)127.5 GENERAL MTNC & REPAIR 23-0439-02-00 MISC MTNC & REPAIR GROUNDS 19,499.71 20,220.27 50,000.00 29,779.73 40.4 23-0439-02-01 MISC MTNC & REPAIR EQUIPMENT 1,378.80 7,863.27 30,000.00 22,136.73 26.2 23-0439-02-02 MISC MTNC & REPAIR BUILDINGS 5,271.44 5,726.72 4,000.00 ( 1,726.72)143.2 23-0439-02-03 EMERGENCY REPAIRS 79.06 79.06 25,000.00 24,920.94 .3 23-0439-02-04 REPAIRS-STRTS,SDWLKS,TREES,LTS .00 .00 150,000.00 150,000.00 .0 23-0439-03-00 MATERIALS AND SUPPLIES 4,064.77 31,244.46 57,000.00 25,755.54 54.8 23-0439-04-00 HOLIDAY LIGHTING .00 2,401.75 7,000.00 4,598.25 34.3 23-0439-05-00 CLEANING AND PAPER SUPPLIES 11,170.80 29,176.38 60,000.00 30,823.62 48.6 23-0439-06-00 SIGNS & SIGN REPLACEMENT 156.50 2,636.68 5,000.00 2,363.32 52.7 TOTAL GENERAL MTNC & REPAIR 41,621.08 99,348.59 388,000.00 288,651.41 25.6 VEHICLES 23-0441-01-00 VEHICLE MTNC & REPAIR 9,677.27 26,358.86 20,000.00 ( 6,358.86)131.8 23-0441-02-00 FUEL 10,848.08 28,543.16 35,000.00 6,456.84 81.6 TOTAL VEHICLES 20,525.35 54,902.02 55,000.00 97.98 99.8 FACILITIES 23-0443-01-00 CITY HALL 9,338.56 37,303.82 44,000.00 6,696.18 84.8 23-0443-02-00 LIBRARY 2,059.32 7,980.81 12,000.00 4,019.19 66.5 23-0443-03-00 MUSEUM .00 .00 2,500.00 2,500.00 .0 23-0443-04-00 CITY SHOP 556.11 5,386.84 4,500.00 ( 886.84)119.7 23-0443-04-01 CITY SHOP UPGRADES, SV 308.78 7,852.47 10,000.00 2,147.53 78.5 23-0443-05-00 SENIOR CENTER 314.60 2,701.32 4,000.00 1,298.68 67.5 23-0443-06-00 JACKSON HOUSE 1,736.28 1,736.28 5,000.00 3,263.72 34.7 23-0443-07-00 LINDER ROAD RESTROOM 518.72 2,758.62 7,500.00 4,741.38 36.8 23-0443-15-00 STREET LIGHTS 9,887.94 21,841.61 43,000.00 21,158.39 50.8 23-0443-99-01 SHOP LEASE .00 6,941.64 30,000.00 23,058.36 23.1 TOTAL FACILITIES 24,720.31 94,503.41 162,500.00 67,996.59 58.2 PARKS, MONUMENTS & GROUNDS 23-0445-01-00 ADA-EAGLE SPORTS PARK 11,927.95 33,271.19 28,000.00 ( 5,271.19)118.8 23-0445-02-00 ARBORETUM PARK .00 613.65 2,000.00 1,386.35 30.7 23-0445-03-00 SV REGIONAL SPORTS COMPLEX .00 .00 10,000.00 10,000.00 .0 23-0445-04-00 FLAG PLAZA 16.08 63.74 2,000.00 1,936.26 3.2 23-0445-05-00 FRIENDSHIP PARK 523.22 2,490.23 4,500.00 2,009.77 55.3 23-0445-06-00 GUERBER PARK 1,728.96 9,820.61 30,000.00 20,179.39 32.7 23-0445-07-00 HERITAGE PARK 346.42 1,885.43 7,500.00 5,614.57 25.1 23-0445-08-00 MACE PARKING AREA .00 .00 5,000.00 5,000.00 .0 23-0445-09-00 MCDONALD'S PATHWAY 241.32 599.24 2,000.00 1,400.76 30.0 23-0445-10-00 MERRILL PARK 2,795.50 5,707.72 21,500.00 15,792.28 26.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:08AM PAGE: 50 23-0445-11-00 ORVAL KRASEN PARK 386.70 1,019.37 4,500.00 3,480.63 22.7 23-0445-12-00 PAMELA BAKER PARK 673.85 7,230.03 11,000.00 3,769.97 65.7 23-0445-13-00 PLAZA DRIVE .00 .00 4,000.00 4,000.00 .0 23-0445-14-00 TRAILS .00 1,489.44 11,500.00 10,010.56 13.0 23-0445-20-00 CITY ENTRANCE SIGNS 1,464.64 4,236.79 11,500.00 7,263.21 36.8 23-0445-30-00 LANDSCAPING, EQUIPMENT RENTAL 5,043.72 7,966.47 15,000.00 7,033.53 53.1 23-0445-30-01 LANDSCAPING, SPRAY/FERTILIZE 16,329.89 16,329.89 48,000.00 31,670.11 34.0 23-0445-30-03 LANDSCAPING, DUMPING/DISPOSAL 316.39 793.39 2,500.00 1,706.61 31.7 TOTAL PARKS, MONUMENTS & GROUNDS 41,794.64 93,517.19 220,500.00 126,982.81 42.4 MEMORIALS AND PROGRAMS 23-0447-01-00 MEMORIALS, MTNC/REPAIR .00 5,190.03 6,000.00 809.97 86.5 23-0447-02-00 MATERIALS & SUPPLIES .00 .00 2,000.00 2,000.00 .0 23-0447-03-00 FLOWERS 18,858.65 18,858.65 17,000.00 ( 1,858.65)110.9 23-0447-04-00 SANITATION AND RECYCLING 3,510.22 10,803.03 54,000.00 43,196.97 20.0 23-0447-05-00 TREES, PUBLIC DEVELOPMENT 4,941.00 13,741.00 29,511.00 15,770.00 46.6 23-0447-05-01 TREE VOUCHER PROGRAM 12,348.81 12,348.81 15,000.00 2,651.19 82.3 23-0447-05-02 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 TOTAL MEMORIALS AND PROGRAMS 39,658.68 60,941.52 123,811.00 62,869.48 49.2 FISCAL YEAR PROJECTS 23-0483-15-00 LANDSCAPE UPGRADES - PARKS 12,062.89 27,017.25 25,000.00 ( 2,017.25)108.1 23-0483-20-01 TOOLS 1,484.65 2,207.50 7,500.00 5,292.50 29.4 23-0483-20-02 EQUIPMENT 48,836.14 54,790.44 85,000.00 30,209.56 64.5 23-0483-20-03 VEHICLE REPLACEMENT .00 .00 53,000.00 53,000.00 .0 23-0483-50-22 CAPITAL PROJECTS FY22 .00 .00 65,000.00 65,000.00 .0 23-0483-50-23 CAPITAL PROJECTS FY23 7,340.22 28,477.22 109,000.00 80,522.78 26.1 TOTAL FISCAL YEAR PROJECTS 69,723.90 112,492.41 344,500.00 232,007.59 32.7 TOTAL FUND EXPENDITURES 646,541.22 1,523,134.07 3,179,507.00 1,656,372.93 47.9 NET REVENUE OVER EXPENDITURES ( 6,550.07)35,032.19 .00 ( 35,032.19).0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 RECREATION - EAGLE FUN DAYS FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:08AM PAGE: 51 ASSETS 24-0101-00-00 CASH 1,037.65 TOTAL ASSETS 1,037.65 LIABILITIES AND EQUITY FUND EQUITY 24-0271-00-00 FUND BALANCE 4,769.47 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 3,731.82) BALANCE - CURRENT DATE ( 3,731.82) TOTAL FUND EQUITY 1,037.65 TOTAL LIABILITIES AND EQUITY 1,037.65 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:08AM PAGE: 52 REVENUE 24-0301-00-00 FUNDING FROM GENERAL FUND 11,491.17 11,591.17 90,550.00 78,958.83 12.8 24-0303-00-00 SPONSORSHIPS 2,500.00 4,000.00 21,000.00 17,000.00 19.1 24-0303-01-00 CAR SHOW 1,705.00 1,705.00 3,300.00 1,595.00 51.7 24-0303-03-00 FUN RUN .00 .00 3,000.00 3,000.00 .0 24-0303-04-00 VENDORS 540.00 540.00 7,000.00 6,460.00 7.7 24-0303-05-00 ROCKY MOUNTAIN OYSTER FEED 690.00 690.00 20,000.00 19,310.00 3.5 24-0303-07-00 MISCELLANEOUS REVENUE 70.91 70.91 .00 ( 70.91).0 TOTAL FUND REVENUE 16,997.08 18,597.08 144,850.00 126,252.92 12.8 EXPENDITURES ADMIN EXPENDITURES 24-0401-01-00 FUN DAYS CONTRACTS 10,000.00 16,250.00 42,000.00 25,750.00 38.7 24-0401-04-00 ADVERTISEMENT 1,262.50 1,262.50 16,800.00 15,537.50 7.5 24-0401-06-00 SUPPLIES 3,468.11 3,468.11 9,300.00 5,831.89 37.3 24-0401-07-00 EQUIPMENT 892.00 892.00 7,500.00 6,608.00 11.9 TOTAL ADMIN EXPENDITURES 15,622.61 21,872.61 75,600.00 53,727.39 28.9 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 14,500.00 14,500.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 7,000.00 7,000.00 .0 TOTAL LOGISTICS .00 .00 39,000.00 39,000.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 396.29 456.29 3,850.00 3,393.71 11.9 TOTAL COMMUNITY EVENTS 396.29 456.29 9,250.00 8,793.71 4.9 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 1,000.00 1,000.00 .0 TOTAL ROCKY MOUNTAIN OYSTER FEED .00 .00 21,000.00 21,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 RECREATION - EAGLE FUN DAYS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:08AM PAGE: 53 TOTAL FUND EXPENDITURES 16,018.90 22,328.90 144,850.00 122,521.10 15.4 NET REVENUE OVER EXPENDITURES 978.18 ( 3,731.82).00 3,731.82 .0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 PATHWAY IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:08AM PAGE: 54 ASSETS 25-0101-00-00 CASH 38,869.00 25-0151-25-00 INVESTMENTS 90,243.14 TOTAL ASSETS 129,112.14 LIABILITIES AND EQUITY FUND EQUITY 25-0271-00-00 FUND BALANCE 855,025.89 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 725,913.75) BALANCE - CURRENT DATE ( 725,913.75) TOTAL FUND EQUITY 129,112.14 TOTAL LIABILITIES AND EQUITY 129,112.14 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 PATHWAY IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:08AM PAGE: 55 REVENUE 25-0322-19-00 DEVELOPMENT IMPACT FEE 20,821.50 44,287.00 115,675.00 71,388.00 38.3 25-0371-25-00 BANK INTEREST 208.16 1,038.75 1,100.00 61.25 94.4 25-0399-00-00 CARRY OVER .00 .00 852,000.00 852,000.00 .0 TOTAL FUND REVENUE 21,029.66 45,325.75 968,775.00 923,449.25 4.7 EXPENDITURES CAPITAL IMPROVEMENTS 25-0438-00-00 CAPITAL IMPROVEMENTS .00 771,239.50 968,775.00 197,535.50 79.6 TOTAL CAPITAL IMPROVEMENTS .00 771,239.50 968,775.00 197,535.50 79.6 TOTAL FUND EXPENDITURES .00 771,239.50 968,775.00 197,535.50 79.6 NET REVENUE OVER EXPENDITURES 21,029.66 ( 725,913.75).00 725,913.75 .0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:08AM PAGE: 56 LIABILITIES AND EQUITY LIABILITIES 26-0217-03-00 FICA 371.85 26-0217-04-00 PUBLIC RETIREMENT 583.73 26-0217-07-00 HEALTH INSURANCE 254.61 26-0217-09-00 WORKERS' COMPENSATION 830.15 TOTAL LIABILITIES 2,040.34 FUND EQUITY 26-0271-00-00 FUND BALANCE ( 2,797.40) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 757.06 BALANCE - CURRENT DATE 757.06 TOTAL FUND EQUITY ( 2,040.34) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:08AM PAGE: 57 REVENUE 26-0301-00-00 FUNDING FROM GENERAL FUND .00 757.06 .00 ( 757.06).0 TOTAL FUND REVENUE .00 757.06 .00 ( 757.06).0 NET REVENUE OVER EXPENDITURES .00 757.06 .00 ( 757.06).0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 LAW ENF DEV IMPACT FEES FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:08AM PAGE: 58 ASSETS 27-0101-00-00 CASH 12,098.48 27-0151-25-00 INVESTMENTS 90,754.86 TOTAL ASSETS 102,853.34 LIABILITIES AND EQUITY FUND EQUITY 27-0271-00-00 POLICE IMPACT FEE/FUND BALANCE 79,160.32 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 23,693.02 BALANCE - CURRENT DATE 23,693.02 TOTAL FUND EQUITY 102,853.34 TOTAL LIABILITIES AND EQUITY 102,853.34 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 LAW ENF DEV IMPACT FEES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:08AM PAGE: 59 REVENUE 27-0322-19-00 RESIDENTIAL IMPACT FEES 7,258.72 23,007.96 38,850.00 15,842.04 59.2 27-0322-20-00 COMMERCIAL - IMPACT FEES .00 .00 30,000.00 30,000.00 .0 27-0371-25-00 BANK INTEREST 555.17 685.06 20.00 ( 665.06)3425.3 27-0399-00-00 CARRY OVER .00 .00 81,000.00 81,000.00 .0 TOTAL FUND REVENUE 7,813.89 23,693.02 149,870.00 126,176.98 15.8 EXPENDITURES CAPITAL IMPROVEMENTS 27-0438-00-00 EQUIPMENT .00 .00 74,935.00 74,935.00 .0 27-0438-01-00 CITY FACILITY .00 .00 74,935.00 74,935.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 .00 149,870.00 149,870.00 .0 TOTAL FUND EXPENDITURES .00 .00 149,870.00 149,870.00 .0 NET REVENUE OVER EXPENDITURES 7,813.89 23,693.02 .00 ( 23,693.02).0 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 CITY HALL BOND FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:09AM PAGE: 60 REVENUE 54-0399-01-00 FUNDING FROM GENERAL FUND 450.00 9,623.20 104,000.00 94,376.80 9.3 TOTAL FUND REVENUE 450.00 9,623.20 104,000.00 94,376.80 9.3 EXPENDITURES BOND PAYMENTS 54-0480-81-00 PRINCIPAL BOND PAYMENT .00 .00 85,000.00 85,000.00 .0 54-0480-82-00 INTEREST BOND PAYMENT .00 9,173.20 18,500.00 9,326.80 49.6 54-0480-84-00 PAYING AGENT FEE 450.00 450.00 500.00 50.00 90.0 TOTAL BOND PAYMENTS 450.00 9,623.20 104,000.00 94,376.80 9.3 TOTAL FUND EXPENDITURES 450.00 9,623.20 104,000.00 94,376.80 9.3 NET REVENUE OVER EXPENDITURES .00 .00 .00 .00 .0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 WATER FUND FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:09AM PAGE: 61 ASSETS 60-0101-00-00 CASH 669,657.94 60-0115-00-00 ACCOUNTS RECEIVABLE 151,391.73 60-0151-01-00 INVESTMENTS, DEQ LOAN PMTS 423,929.68 60-0151-02-00 INVESTMENTS, DEQ LOAN RESERVE 182,000.00 60-0151-25-00 INVESTMENTS, WATER SYSTEM 4,915,880.97 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.&( 183,637.00) 60-0164-00-00 WATER/IMPROVEMENTS-OTHER THAN 15,633,373.00 60-0165-00-00 WATER/ACCUM. DEP.-IMPROVEMENTS ( 4,033,182.00) 60-0166-00-00 WATER/MACHINERY & EQUIPMENT 1,501,217.00 60-0167-00-00 WATER/ACCUMULATED DEPREC-EQUIP ( 1,018,840.00) 60-0170-00-00 HRA 10% DEPOSIT 550.08 60-0171-00-00 DEFERRED OUTFLOWS-PENSION 158,311.00 TOTAL ASSETS 19,053,187.40 LIABILITIES AND EQUITY LIABILITIES 60-0202-00-00 WATER/VOUCHERS PAYABLE ( 227.00) 60-0204-00-00 WATER/LEXINGTON - TVV 1,787.89 60-0215-00-00 INTEREST PAYABLE 11,158.00 60-0216-00-00 ACCRUED PAYROLL 6,081.88 60-0217-00-00 COMPENSATED ABSENCE PAYABLE 8,229.00 60-0217-03-00 FICA 1,542.82 60-0217-04-00 PUBLIC RETIREMENT 2,618.32 60-0217-07-00 WATER DEPT HEALTH INSURANCE 7,615.35 60-0217-08-00 GARNISHMENTS 1,162.50 60-0217-09-00 WORKERS' COMPENSATION 69,075.57 60-0217-10-00 HSA CONTRIBUTION ( 100.00) 60-0217-11-00 NET PENSION LIABILITY 296,214.00 60-0217-12-00 DEFERRED INFLOWS-PENSION 1,389.00 60-0220-00-00 SERVICE DEPOSITS, WATER 103,075.00 60-0231-00-00 DEQ LOAN 749,059.00 TOTAL LIABILITIES 1,258,681.33 FUND EQUITY 60-0271-00-00 WATER/FUND BALANCE 17,552,945.37 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 241,560.70 BALANCE - CURRENT DATE 241,560.70 TOTAL FUND EQUITY 17,794,506.07 TOTAL LIABILITIES AND EQUITY 19,053,187.40 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:09AM PAGE: 62 REVENUE 60-0346-59-00 STL-STORAGE & TRUNK LINE FEE 2,100.00 4,200.00 105,000.00 100,800.00 4.0 60-0346-60-00 HOOK UP FEES CITY 30,105.00 58,055.00 167,250.00 109,195.00 34.7 60-0346-62-00 PROFESSIONAL SERV - DEVELOPERS 3,571.25 30,841.76 .00 ( 30,841.76).0 60-0346-63-00 STAFF TIME REIMB - DEVELOPERS 897.00 1,587.00 .00 ( 1,587.00).0 60-0347-01-00 BILLING REVENUE 353,410.56 991,553.84 1,227,000.00 235,446.16 80.8 60-0347-02-00 OTHER REVENUE 1,410.02 3,470.02 8,400.00 4,929.98 41.3 60-0347-03-00 RECONNECT FEES 200.00 266.22 600.00 333.78 44.4 60-0347-04-00 DELINQUENT FEES 2,956.50 8,945.75 10,500.00 1,554.25 85.2 60-0347-05-00 MISCELLANEOUS REVENUE 2,143.22 5,495.73 10,000.00 4,504.27 55.0 60-0347-06-00 SYSTEM ENHANCEMENT FEE 118,004.62 351,616.48 450,000.00 98,383.52 78.1 60-0355-01-00 WCE-WATER CONST EQUIV FEE 6,800.00 12,000.00 40,000.00 28,000.00 30.0 60-0371-10-00 INVESTMENTS, DEQ, TRANSFERS .00 .00 350,000.00 350,000.00 .0 60-0371-25-00 BANK INTEREST 39,581.24 45,706.52 7,500.00 ( 38,206.52)609.4 60-0399-00-00 CARRY OVER .00 .00 152,480.00 152,480.00 .0 60-0399-01-00 RESERVES, FOR BUDGET .00 .00 325,000.00 325,000.00 .0 60-0399-02-00 RESERVES, EMERGENCY REPL ITEMS .00 .00 175,000.00 175,000.00 .0 60-0399-03-00 RESERVES, EQUIP/BLDG REPLCMNT .00 .00 250,000.00 250,000.00 .0 60-0399-04-00 RESERVES, REPAIR/ MAINTENANCE .00 .00 175,000.00 175,000.00 .0 60-0399-05-00 RESERVES, VEHICLE REPLACEMENT .00 .00 72,000.00 72,000.00 .0 60-0399-06-00 RESERVES, STL FEES .00 .00 884,378.00 884,378.00 .0 TOTAL FUND REVENUE 561,179.41 1,513,738.32 4,410,108.00 2,896,369.68 34.3 EXPENDITURES VEHICLE OPERATIONS - LEASES 60-0420-01-00 GAS AND OIL 2,125.03 7,932.88 15,000.00 7,067.12 52.9 60-0420-03-00 VEHICLE MTNC & REPAIR 163.09 307.83 10,000.00 9,692.17 3.1 TOTAL VEHICLE OPERATIONS - LEASES 2,288.12 8,240.71 25,000.00 16,759.29 33.0 PERSONNEL 60-0433-10-00 SALARIES - FULL TIME 90,473.74 259,504.88 352,800.00 93,295.12 73.6 60-0433-10-02 ON-CALL TIME 822.45 1,955.29 7,500.00 5,544.71 26.1 60-0433-11-00 OVERTIME 993.82 1,479.40 4,500.00 3,020.60 32.9 60-0433-21-00 FICA 6,912.71 19,844.79 27,200.00 7,355.21 73.0 60-0433-22-00 PERSI 11,019.51 31,656.22 42,300.00 10,643.78 74.8 60-0433-23-00 HRA BUY-DOWN 268.59 1,365.75 7,700.00 6,334.25 17.7 60-0433-23-01 HRA/COBRA ADMIN FEES .00 .00 800.00 800.00 .0 60-0433-24-00 WORKERS' COMPENSATION 2,438.93 15,250.77 16,000.00 749.23 95.3 60-0433-25-00 INSURANCE 11,475.02 34,239.85 51,100.00 16,860.15 67.0 60-0433-26-00 HSA CONTRIBUTIONS 600.00 1,800.00 2,400.00 600.00 75.0 60-0433-29-00 PTO CASH OUT .00 2,185.93 10,000.00 7,814.07 21.9 TOTAL PERSONNEL 125,004.77 369,282.88 522,300.00 153,017.12 70.7 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:09AM PAGE: 63 OPERATIONS & MAINTENANCE 60-0434-15-00 OFFICE SUPPLIES 30.00 543.98 2,000.00 1,456.02 27.2 60-0434-19-00 TELECOMMUNICATIONS/SCADA 2,284.93 10,292.50 17,000.00 6,707.50 60.5 60-0434-20-00 ADVERTISING - PUBLICATIONS .00 .00 1,500.00 1,500.00 .0 60-0434-22-00 TRAVEL-MTNGS-EDUCATION 1,732.59 2,929.52 8,000.00 5,070.48 36.6 60-0434-23-00 DUES & SUBSCRIPTIONS 118.49 412.49 3,000.00 2,587.51 13.8 60-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE .00 5,275.20 8,000.00 2,724.80 65.9 60-0434-26-00 TOOLS, EQUIPMENT AND SUPPLIES 10,264.97 12,134.96 20,000.00 7,865.04 60.7 60-0434-27-00 POSTAGE .00 .00 1,300.00 1,300.00 .0 60-0434-41-00 LIABILITY INSURANCE .00 4,620.00 4,620.00 .00 100.0 60-0434-42-00 ENGINEERING SERVICES 5,617.50 24,626.04 35,000.00 10,373.96 70.4 60-0434-42-01 LEGAL SERVICES .00 .00 25,000.00 25,000.00 .0 60-0434-42-02 MISC LEGAL AND ENG SERVICES 1,577.00 8,776.19 100,000.00 91,223.81 8.8 60-0434-42-03 PROFESSIONAL SERV - DEVELOPERS 4,265.50 29,062.76 .00 ( 29,062.76).0 60-0434-43-01 CONTRACT SERVICES (REPAIR)3,000.00 3,000.00 35,000.00 32,000.00 8.6 60-0434-44-00 DIG LINE 770.44 1,529.66 4,500.00 2,970.34 34.0 60-0434-45-00 CITY AUDITOR SERVICES .00 3,500.00 2,500.00 ( 1,000.00)140.0 60-0434-47-00 MAIL SERVICE-CUSTOMER BILLING 6,826.29 18,046.88 31,500.00 13,453.12 57.3 60-0434-50-00 SHOP LEASE .00 2,974.98 15,500.00 12,525.02 19.2 60-0434-50-01 SHOP UTILITIES 212.91 1,414.45 5,100.00 3,685.55 27.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 52.50 1,500.00 1,447.50 3.5 60-0434-55-00 CASELLE SUPPORT 272.00 272.00 5,000.00 4,728.00 5.4 60-0434-58-00 RPR/MTNC-LINES-METERS-ETC 497.34 2,429.87 40,000.00 37,570.13 6.1 60-0434-58-01 RPR/MTNC PUMPS-WELLS-CHEMICAL 40.67 7,019.06 50,000.00 42,980.94 14.0 60-0434-59-00 CHEMICALS 357.49 1,675.64 9,000.00 7,324.36 18.6 60-0434-60-00 UTILITIES 10,961.89 38,923.77 55,000.00 16,076.23 70.8 60-0434-68-00 UNIFORMS AND SAFETY CLOTHING 720.59 1,455.49 2,300.00 844.51 63.3 60-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 832.50 25,000.00 24,167.50 3.3 TOTAL OPERATIONS & MAINTENANCE 49,550.60 195,132.44 521,320.00 326,187.56 37.4 TESTING-WK-MO-QTR-ANNUAL 60-0435-56-00 TESTING-WK-MO-QTR-ANNUAL 870.00 2,170.00 19,000.00 16,830.00 11.4 TOTAL TESTING-WK-MO-QTR-ANNUAL 870.00 2,170.00 19,000.00 16,830.00 11.4 DEQ REVOLVING LOAN PAYMENT 60-0436-01-00 DEQ/STATE REVOLVING LOAN PMT .00 650,000.00 800,000.00 150,000.00 81.3 TOTAL DEQ REVOLVING LOAN PAYMENT .00 650,000.00 800,000.00 150,000.00 81.3 STL FEES, RESTRICTED 60-0437-01-00 STL FEES, REIMB SYS EXPANSION ( 3,930.00).00 100,000.00 100,000.00 .0 60-0437-03-00 STL FEES, REFUNDS .00 .00 50,000.00 50,000.00 .0 60-0437-05-01 CURRENT STL PROJECTS 11,156.21 10,156.21 430,000.00 419,843.79 2.4 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:09AM PAGE: 64 60-0437-99-01 RESERVES, STL FEES .00 .00 409,378.00 409,378.00 .0 TOTAL STL FEES, RESTRICTED 7,226.21 10,156.21 989,378.00 979,221.79 1.0 CAPITAL EXPENDITURES 60-0438-01-00 EQUIPMENT .00 7,660.00 75,500.00 67,840.00 10.2 60-0438-08-00 METER SETS, NEW CUSTOMERS 11,132.25 11,132.25 99,200.00 88,067.75 11.2 60-0438-10-00 WATER MASTER PLAN-UPDATE 5,467.50 5,467.50 18,000.00 12,532.50 30.4 60-0438-11-00 CAPITAL CONSTRUCTION PROJECTS .00 2,878.13 145,000.00 142,121.87 2.0 60-0438-82-00 CITY HALL ADMIN OVERHEAD 6,705.00 10,057.50 13,410.00 3,352.50 75.0 60-0438-99-01 RESERVES, FOR BUDGET .00 .00 375,000.00 375,000.00 .0 60-0438-99-02 RESERVES, EMERGENCY REPL ITEMS .00 .00 200,000.00 200,000.00 .0 60-0438-99-03 RESERVES, EQUIP, BLDG REPLCMNT .00 .00 275,000.00 275,000.00 .0 60-0438-99-04 RESERVES, WATER SYSTEM R&M .00 .00 200,000.00 200,000.00 .0 60-0438-99-05 RESERVES, VEHICLE REPLACEMENT .00 .00 12,000.00 12,000.00 .0 60-0438-99-06 RESERVES, IDENTIFIED PROJECTS .00 .00 120,000.00 120,000.00 .0 TOTAL CAPITAL EXPENDITURES 23,304.75 37,195.38 1,533,110.00 1,495,914.62 2.4 TOTAL FUND EXPENDITURES 208,244.45 1,272,177.62 4,410,108.00 3,137,930.38 28.9 NET REVENUE OVER EXPENDITURES 352,934.96 241,560.70 .00 ( 241,560.70).0 CITY OF EAGLE BALANCE SHEET JUNE 30, 2023 FIBER FUND FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:09AM PAGE: 65 ASSETS 61-0101-00-00 CASH 1,162.50 61-0151-25-00 INVESTMENTS, FIBER SYSTEM 2,014,907.79 61-0166-00-00 MACHINERY AND EQUIPMENT 1,693,285.00 TOTAL ASSETS 3,709,355.29 LIABILITIES AND EQUITY LIABILITIES 61-0217-07-00 INSURANCE ( 1,384.60) 61-0217-09-00 WORKERS' COMPENSATION 1,589.39 TOTAL LIABILITIES 204.79 FUND EQUITY 61-0271-00-00 FUND BALANCE 4,083,934.30 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 374,783.80) BALANCE - CURRENT DATE ( 374,783.80) TOTAL FUND EQUITY 3,709,150.50 TOTAL LIABILITIES AND EQUITY 3,709,355.29 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 FIBER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:09AM PAGE: 66 REVENUE 61-0347-90-00 BANK INTEREST 1,104.87 4,238.49 .00 ( 4,238.49).0 61-0398-00-00 ARPA CARRY OVER .00 .00 2,389,980.00 2,389,980.00 .0 TOTAL FUND REVENUE 1,104.87 4,238.49 2,389,980.00 2,385,741.51 .2 EXPENDITURES PERSONNEL 61-0433-10-00 SALARIES - FULL TIME 26,460.00 42,306.00 183,400.00 141,094.00 23.1 61-0433-10-02 ON-CALL TIME .00 .00 2,500.00 2,500.00 .0 61-0433-11-00 OVERTIME 1,016.44 1,679.07 2,500.00 820.93 67.2 61-0433-21-00 FICA 2,101.94 3,364.84 14,500.00 11,135.16 23.2 61-0433-22-00 PERSI 3,280.70 5,251.83 25,500.00 20,248.17 20.6 61-0433-23-00 HRA BUY-DOWN .00 .00 3,080.00 3,080.00 .0 61-0433-23-01 HRA/COBRA ADMIN FEES .00 .00 300.00 300.00 .0 61-0433-24-00 WORKERS' COMPENSATION 993.24 1,589.39 8,000.00 6,410.61 19.9 61-0433-25-00 INSURANCE 3,232.56 3,746.76 26,000.00 22,253.24 14.4 61-0433-26-00 HSA CONTRIBUTIONS .00 .00 1,200.00 1,200.00 .0 TOTAL PERSONNEL 37,084.88 57,937.89 266,980.00 209,042.11 21.7 OPERATIONS & MAINTENANCE 61-0434-15-00 OFFICE SUPPLIES .00 .00 500.00 500.00 .0 61-0434-19-00 TELECOMMUNICATIONS 163.82 163.82 8,000.00 7,836.18 2.1 61-0434-20-00 ADVERTISING - PUBLICATIONS .00 .00 20,000.00 20,000.00 .0 61-0434-22-00 TRAVEL-MTNGS-EDUCATION 240.00 240.00 15,000.00 14,760.00 1.6 61-0434-23-00 DUES & SUBSCRIPTIONS .00 .00 500.00 500.00 .0 61-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE .00 108.44 5,000.00 4,891.56 2.2 61-0434-26-00 TOOLS, EQUIPMENT AND SUPPLIES 7,924.51 16,920.19 5,000.00 ( 11,920.19)338.4 61-0434-26-01 EQUIPMENT RENTAL 22.99 22.99 25,000.00 24,977.01 .1 61-0434-27-00 POSTAGE .00 .00 1,000.00 1,000.00 .0 61-0434-41-00 LIABILITY INSURANCE .00 3,000.00 7,500.00 4,500.00 40.0 61-0434-42-00 ENGINEERING SERVICES 33,725.50 33,725.50 290,000.00 256,274.50 11.6 61-0434-42-01 LEGAL SERVICES 402.50 682.50 15,000.00 14,317.50 4.6 61-0434-43-00 TRAFFIC CONTROL .00 .00 100,000.00 100,000.00 .0 61-0434-44-00 DIG LINE .00 .00 2,500.00 2,500.00 .0 61-0434-45-00 CITY AUDITOR SERVICES .00 500.00 3,000.00 2,500.00 16.7 61-0434-47-00 MAIL SERVICE-CUSTOMER BILLING .00 .00 10,000.00 10,000.00 .0 61-0434-50-00 CITY SHOP UPGRADES, SV .00 .00 15,000.00 15,000.00 .0 61-0434-50-01 SHOP UTILITIES 44.58 195.52 5,000.00 4,804.48 3.9 61-0434-53-03 PERMITS AND FEES .00 .00 5,000.00 5,000.00 .0 61-0434-55-00 CASELLE SUPPORT .00 .00 1,500.00 1,500.00 .0 61-0434-56-00 GAS AND OIL 3,481.89 4,057.04 7,500.00 3,442.96 54.1 61-0434-57-00 REPAIR AND MAINT, VEHICLE 7,516.38 18,099.33 1,000.00 ( 17,099.33)1809.9 61-0434-58-00 REPAIR AND MAINT, GROUND WORK .00 .00 50,000.00 50,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 9 MONTHS ENDING JUNE 30, 2023 FIBER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 75 % OF THE FISCAL YEAR HAS ELAPSED 07/13/2023 09:09AM PAGE: 67 61-0434-58-01 REPAIR AND MAINT, EQUIPMENT 17,018.95 45,481.47 50,000.00 4,518.53 91.0 61-0434-58-02 REPAIR AND MAINT, BUILDINGS 7,500.00 7,500.00 .00 ( 7,500.00).0 61-0434-59-00 REPAIR AND MAINT, EMERGENCIES 98.64 98.64 100,000.00 99,901.36 .1 61-0434-59-01 MATERIALS 37,319.80 91,314.19 250,000.00 158,685.81 36.5 61-0434-60-00 UTILITIES .00 365.93 .00 ( 365.93).0 61-0434-68-00 UNIFORMS AND SAFETY CLOTHING .00 .00 1,000.00 1,000.00 .0 61-0434-69-00 CITY HALL ADMIN OVERHEAD .00 .00 14,000.00 14,000.00 .0 61-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 .00 20,000.00 20,000.00 .0 TOTAL OPERATIONS & MAINTENANCE 115,459.56 222,475.56 1,028,000.00 805,524.44 21.6 CAPITAL EXPENDITURES 61-0438-01-00 EQUIPMENT .00 2,613.30 15,000.00 12,386.70 17.4 61-0438-09-00 TOOLS AND EQUIPMENT, FY22 ARPA 3,367.11 20,423.54 570,000.00 549,576.46 3.6 61-0438-10-00 MASTER PLAN DEVELOPMENT .00 .00 10,000.00 10,000.00 .0 61-0438-11-00 CAPITAL CONSTRUCTION PROJECTS 18,438.00 75,572.00 500,000.00 424,428.00 15.1 TOTAL CAPITAL EXPENDITURES 21,805.11 98,608.84 1,095,000.00 996,391.16 9.0 TOTAL FUND EXPENDITURES 174,349.55 379,022.29 2,389,980.00 2,010,957.71 15.9 NET REVENUE OVER EXPENDITURES ( 173,244.68)( 374,783.80).00 374,783.80 .0