Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Finance - Quarterly Reports - FY 22/23 2nd Quarter - 03/31/2023
BEGINNING CASH ANNUAL %ANNUAL %CHANGE IN ENDING CASH FUND NUMBER AND TITLE BALANCE REVENUES REALIZED EXPENDITURES EXPENDED BALANCE SHEET BALANCE 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:18PM PAGE: 1 01 GENERAL FUND 1,702,903.54 4,865,879.96 36.91 3,039,539.32 31.57 2,442,188.33 1,087,055.85 06 LIBRARY FUND 5,148.62 5,368.82 .52 341,899.87 29.38 ( 347,848.24)16,465.81 07 MUSEUM FUND .00 29,273.71 34.94 28,960.94 33.89 312.77 .00 08 PARK IMPACT FEE FUND 44,178.44 36,143.95 1.87 1,677,712.15 40.71 ( 1,619,559.09)22,169.33 09 RECREATION - SPECIAL EVENTS 25,925.58 16,124.76 8.92 43,264.85 36.50 ( 1,214.51).00 10 EAGLE HISTORICAL COMMISSION 20,610.34 .00 .00 .00 3.04 .00 20,610.34 11 EXECUTIVE DEPARTMENT .00 95,202.81 30.35 91,493.35 29.87 3,709.46 .00 12 CITY CLERK/TREAS DEPARTMENT .00 157,333.97 38.79 150,961.89 37.75 6,372.08 .00 13 BUILDING DEPARTMENT .00 200,375.65 40.97 197,302.59 37.85 3,073.06 .00 14 P&Z DEPARTMENT .00 246,944.97 39.00 241,010.56 38.60 5,934.41 .00 17 RECREATION - PARKS AND REC .00 113,798.82 31.06 114,430.77 30.51 ( 631.95).00 18 IT DEPARTMENT .00 221,046.02 40.29 214,858.28 37.90 6,187.74 .00 19 CAPITAL PROJECTS FUND 126,904.97 925,301.33 12.74 ( 1,332,914.51)13.99 1,401,767.38 983,353.43 21 ARTS COMMISSION 625.00 2.50 .04 .00 ( .77).00 627.50 23 PUBLIC WORKS .00 459,799.76 28.88 452,231.68 27.57 7,568.08 .00 24 RECREATION - EAGLE FUN DAYS 4,709.47 1,600.00 1.10 6,250.00 4.36 .00 59.47 25 PATHWAY IMPACT FEE FUND 5,702.00 10,886.98 2.51 748,230.50 79.61 ( 749,689.02)18,047.50 26 ECONOMIC DEVELOPMENT .00 .00 .00 .00 .00 .00 .00 27 LAW ENF DEV IMPACT FEES 25,207.92 4,696.81 10.60 .00 .00 64.97 29,839.76 54 CITY HALL BOND FUND .00 9,173.20 8.82 9,173.20 8.82 .00 .00 60 WATER FUND 610,947.35 494,820.96 21.60 557,575.97 24.12 6,938.56 541,253.78 61 FIBER FUND 19,517.02 855.34 .13 184,209.76 8.56 ( 198,356.21)34,518.81 99 COMBINED CASH FUND ( 2,592,380.25).00 .00 .00 .00 161,621.33 ( 2,754,001.58) TOTAL .00 7,894,630.32 6,766,191.17 1,128,439.15 .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, April 18, 2023 CITY OF EAGLE COMBINED CASH INVESTMENT FOR THE QUARTER ENDING MARCH 31, 2023 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:24PM PAGE: 1 COMBINED CASH ACCOUNTS 99-0103-00-00 CASH IN CHECKING 2,400,077.99 99-0108-00-00 CASH CLEARING-ACCOUNTS REC 353,923.59 TOTAL COMBINED CASH 2,754,001.58 99-0101-00-00 CASH ALLOCATED TO OTHER FUNDS ( 2,754,001.58) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 1,087,055.85 6 ALLOCATION TO LIBRARY FUND 16,465.81 8 ALLOCATION TO PARK IMPACT FEE FUND 22,169.33 10 ALLOCATION TO EAGLE HISTORICAL COMMISSION 20,610.34 19 ALLOCATION TO CAPITAL PROJECTS FUND 983,353.43 21 ALLOCATION TO ARTS COMMISSION 627.50 24 ALLOCATION TO RECREATION - EAGLE FUN DAYS 59.47 25 ALLOCATION TO PATHWAY IMPACT FEE FUND 18,047.50 27 ALLOCATION TO LAW ENF DEV IMPACT FEES 29,839.76 60 ALLOCATION TO WATER FUND 541,253.78 61 ALLOCATION TO FIBER FUND 34,518.81 TOTAL ALLOCATIONS TO OTHER FUNDS 2,754,001.58 ALLOCATION FROM COMBINED CASH FUND - 99-0101-00-00 ( 2,754,001.58) ZERO PROOF IF ALLOCATIONS BALANCE .00 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 GENERAL FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:24PM PAGE: 2 ASSETS 01-0101-00-00 CASH 1,087,055.85 01-0103-00-00 PETTY CASH 100.00 01-0107-00-00 TAXES RECEIVABLE DELINQUENT 12,084.19 01-0115-00-00 ACCOUNTS RECEIVABLE 63,907.26 01-0132-00-00 DUE FROM OTHER GOVERNMNTL UNTS 1,056,424.05 01-0151-25-00 INVESTMENTS 8,470,309.09 01-0151-28-00 ICCU CD 51,108.94 01-0170-00-00 HRA 10 % DEPOSIT 5,785.92 TOTAL ASSETS 10,746,775.30 LIABILITIES AND EQUITY LIABILITIES 01-0202-00-00 VOUCHERS PAYABLE ( 3,542.16) 01-0203-00-00 ACCTS PAYABLE-ACHD IMPACT FEES 56,032.00 01-0203-01-01 BONDS DEPOSITS PAYABLE 1,898,313.92 01-0203-01-02 FIREWORKS BOND DEPOSIT PAYABLE ( 2,000.00) 01-0203-01-03 VENDORS BOND DEPOSITS PAYABLE 3,413.00 01-0203-01-05 P&Z DEPOSITS PAYABLE 405,932.57 01-0203-01-06 LAND USE DEPOSITS PAYABLE 51,108.94 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,570.01 01-0226-00-00 DEFERRED REVENUE 11,060.32 TOTAL LIABILITIES 2,411,023.49 FUND EQUITY 01-0271-00-00 FUND BALANCE 7,303,482.60 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,032,269.21 BALANCE - CURRENT DATE 1,032,269.21 TOTAL FUND EQUITY 8,335,751.81 TOTAL LIABILITIES AND EQUITY 10,746,775.30 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:24PM PAGE: 3 REVENUE 01-0311-00-00 PROPERTY TAX 2,875,312.79 2,879,960.77 4,490,018.00 1,610,057.23 64.1 01-0311-01-00 PENALTY/INTEREST ON TAXES 1,212.90 1,655.02 4,000.00 2,344.98 41.4 01-0312-00-00 PERSONAL PROPERTY TAX REIMBURS 5,151.05 5,151.05 8,463.00 3,311.95 60.9 01-0316-10-02 FRANCHISE FEE/VEOLIA 9,354.64 18,493.97 20,000.00 1,506.03 92.5 01-0316-11-00 FRANCHISE FEE/INTERMTN GAS 112,014.85 141,748.95 275,000.00 133,251.05 51.6 01-0316-12-00 FRANCHISE FEE/CABLE TV 28,155.98 56,107.56 115,000.00 58,892.44 48.8 01-0316-13-00 FRANCHISE FEE/TRASH 102,549.81 201,968.14 300,000.00 98,031.86 67.3 01-0316-14-00 FRANCHISE FEE/IDAHO POWER 56,639.37 151,164.86 235,000.00 83,835.14 64.3 01-0321-10-00 BUSINESS, ALCOHOL, MISC-LCNSES 2,833.36 4,488.33 56,500.00 52,011.67 7.9 01-0321-30-00 BUSINESS LICENSE FEE 950.00 2,175.00 .00 ( 2,175.00).0 01-0322-10-00 BUILDING & INSPECTION PERMITS 198,368.74 528,661.04 1,135,000.00 606,338.96 46.6 01-0322-12-00 BUILDING, PLAN REVIEW FEES 93,068.17 258,428.47 475,250.00 216,821.53 54.4 01-0322-13-00 ENERGY STANDARDS (IRES)2,400.00 4,750.00 17,500.00 12,750.00 27.1 01-0322-14-00 ELECTRICAL PERMIT FEES 71,957.09 128,431.44 200,000.00 71,568.56 64.2 01-0322-15-00 PLUMBING PERMIT FEES 30,148.55 61,890.27 200,000.00 138,109.73 31.0 01-0322-16-00 MECHANICAL PERMIT FEES 33,632.93 71,324.52 200,000.00 128,675.48 35.7 01-0322-20-00 FIRE IMPACT ADMIN FEES 620.00 1,760.00 7,000.00 5,240.00 25.1 01-0323-01-00 PZ ANNEX/ZONING PERMIT FEES 62,366.08 120,199.93 170,000.00 49,800.07 70.7 01-0323-02-00 PLANNING INSPECTION FEES 3,260.00 7,310.00 5,000.00 ( 2,310.00)146.2 01-0323-03-00 PLANNING, PLAN REVIEW FEES 5,600.00 11,450.00 25,000.00 13,550.00 45.8 01-0323-04-00 STREET LIGHT INSPECTION FEES 260.00 370.00 800.00 430.00 46.3 01-0323-05-00 SURETY/LETTER OF CREDIT FEES 1,350.00 2,850.00 4,000.00 1,150.00 71.3 01-0323-06-00 GRADING-DRAINAGE PERMIT FEES 750.00 3,000.00 12,000.00 9,000.00 25.0 01-0323-10-00 SPRING VALLEY STAFF TIME REIMB 2,425.50 7,957.50 10,000.00 2,042.50 79.6 01-0323-11-00 AVIMOR STAFF TIME REIMBURSE 18,953.25 35,717.25 20,000.00 ( 15,717.25)178.6 01-0323-12-00 PZ STAFF TIME REIMBURSE .00 862.50 .00 ( 862.50).0 01-0335-10-00 STATE LIQUOR 129,255.00 258,510.00 662,590.00 404,080.00 39.0 01-0335-50-00 STATE SALES TAX, AG REPL 4.75 9.50 19.00 9.50 50.0 01-0335-60-00 STATE REVENUE SHARING 846,927.72 1,768,886.56 3,743,404.00 1,974,517.44 47.3 01-0338-40-00 COURT FEES 14,738.53 33,661.15 35,000.00 1,338.85 96.2 01-0338-41-00 CITATION FEES/CODE ENFORCEMENT .00 .00 500.00 500.00 .0 01-0338-42-00 WEED ABATEMENT .00 .00 1,000.00 1,000.00 .0 01-0341-11-00 MISCELLANEOUS PERMITS/LICENSES 20.00 1,197.00 .00 ( 1,197.00).0 01-0341-12-00 ANIMAL CONTROL FEES 3,402.50 7,402.00 10,000.00 2,598.00 74.0 01-0341-13-00 ENGINEERING FEES - DEVELOPERS 54,471.38 111,001.13 175,000.00 63,998.87 63.4 01-0341-14-00 ATTORNEY FEES - DEVELOPERS 27,094.00 35,611.50 20,000.00 ( 15,611.50)178.1 01-0341-16-00 CONSULTANT FEES - DEVELOPERS .00 4,485.00 .00 ( 4,485.00).0 01-0341-17-00 CID STAFF & MISC REIMBURSEMENT 551.41 922.59 1,200.00 277.41 76.9 01-0341-20-00 REIMBURSE FROM WATER DEPT .00 3,352.50 13,410.00 10,057.50 25.0 01-0341-20-01 REIMBURSE FROM FIBER DEPT .00 .00 14,000.00 14,000.00 .0 01-0341-26-00 BACKGROUND CHECKS 266.00 558.25 1,500.00 941.75 37.2 01-0341-27-00 URA CITY STAFF REIMBURSEMENT 2,288.47 2,487.30 2,000.00 ( 487.30)124.4 01-0341-28-00 ID POWER SUBSTATION WATER USE .00 .00 120.00 120.00 .0 01-0341-29-00 REVEL EAGLE-EASEMENT-MERRILL P 1,000.00 1,000.00 1,000.00 .00 100.0 01-0350-02-00 IDAHO OPIOID SETTLEMENT 515.36 10,875.66 15,000.00 4,124.34 72.5 01-0350-05-00 FIELD OF HONOR 4,390.00 7,060.00 20,000.00 12,940.00 35.3 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 INVESTMENT INTEREST 6,104.09 8,045.47 8,500.00 454.53 94.7 01-0379-00-00 MISCELLANEOUS .00 .00 1,000.00 1,000.00 .0 01-0379-01-00 DUPLICATION/PUBLISHING/PRINTNG 345.00 345.00 500.00 155.00 69.0 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:24PM PAGE: 4 01-0382-02-00 PROMOTIONAL SALES 5.00 200.00 .00 ( 200.00).0 01-0383-05-00 MISCELLANEOUS-REIMBURSEABLES 486.57 755.30 1,500.00 744.70 50.4 01-0383-09-00 ROOM RESERVATIONS 2,126.00 3,697.44 2,000.00 ( 1,697.44)184.9 01-0383-15-00 MISCELLANEOUS REVENUE 14,714.12 26,511.37 .00 ( 26,511.37).0 01-0383-16-00 INSURANCE REIMBURSEABLES 2,242.44 3,571.75 .00 ( 3,571.75).0 01-0385-00-00 FIRE DEPT IMPACT FEES 35,596.56 130,131.48 313,950.00 183,818.52 41.5 01-0399-00-00 CARRY OVER .00 .00 6,309,626.00 6,309,626.00 .0 TOTAL FUND REVENUE 4,865,879.96 7,139,554.52 19,342,350.00 12,202,795.48 36.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:24PM 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,590.00 2,370.00 4,200.00 1,830.00 56.4 01-0413-02-00 DESIGN REVIEW BRD COMPENSATION 1,450.00 2,200.00 5,000.00 2,800.00 44.0 01-0413-05-00 OFFICE SUPPLIES 5,734.99 9,622.63 25,000.00 15,377.37 38.5 01-0413-06-00 PRINTING & DISTRIBUTION .00 .00 500.00 500.00 .0 01-0413-07-00 POSTAGE 3,318.39 5,030.86 12,500.00 7,469.14 40.3 01-0413-08-00 LEGAL ADVERTISING/PUBLICATION 785.54 1,708.78 5,000.00 3,291.22 34.2 01-0413-10-00 INSURANCE - PROPERTY 29,080.00 56,540.00 65,000.00 8,460.00 87.0 01-0413-12-00 PERSONNEL TRAINING 150.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 21,261.75 54,859.90 168,350.00 113,490.10 32.6 01-0413-25-00 MISCELLANEOUS .91 2.89 20,000.00 19,997.11 .0 01-0413-28-00 RESOURCE MATERIALS 72.08 1,650.19 6,500.00 4,849.81 25.4 01-0413-29-00 REAL PROPERTY TAXES - CITY .00 238.50 250.00 11.50 95.4 01-0413-31-00 ENGINEERING FEES - DEVELOPERS 28,108.70 56,451.83 175,000.00 118,548.17 32.3 01-0413-33-00 ATTORNEY FEES - DEVELOPERS 21,811.50 29,637.00 20,000.00 ( 9,637.00)148.2 01-0413-37-00 BACKGROUND CHECK-PERMITS/LIC 838.81 1,158.06 2,000.00 841.94 57.9 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 131.00 419.00 1,000.00 581.00 41.9 TOTAL ADMINISTRATION 114,333.67 224,436.08 519,700.00 295,263.92 43.2 PERSONNEL 01-0415-11-00 SALARIES - COUNCIL 12,720.00 25,440.00 50,880.00 25,440.00 50.0 01-0415-21-00 FICA 973.08 1,946.16 4,000.00 2,053.84 48.7 01-0415-22-00 PERSI 1,518.72 3,037.44 6,200.00 3,162.56 49.0 01-0415-23-01 HRA/COBRA ADMIN FEES 299.10 497.45 1,800.00 1,302.55 27.6 01-0415-24-00 WORKERS' COMPENSATION 10,907.16 54,657.28 44,000.00 ( 10,657.28)124.2 01-0415-24-01 WORK COMP/BOARDS-COMMISSIONS 19.11 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 26,437.17 85,674.19 112,580.00 26,905.81 76.1 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:24PM PAGE: 6 CONTRACTS & AGREEMENTS 01-0416-02-00 CITY ATTORNEY 38,018.57 56,472.57 250,000.00 193,527.43 22.6 01-0416-05-00 PROSECUTOR 21,332.00 37,335.00 64,000.00 26,665.00 58.3 01-0416-06-00 IDAHO HUMANE SOCIETY 40,120.02 92,287.96 160,480.00 68,192.04 57.5 01-0416-07-00 CITY ENGINEERING 338.75 338.75 20,000.00 19,661.25 1.7 01-0416-08-00 CITY AUDITOR SERVICES 12,375.00 12,375.00 21,000.00 8,625.00 58.9 01-0416-09-00 LAW ENFORCEMENT DEPARTMENT 1,241,835.56 1,862,753.39 3,725,510.00 1,862,756.61 50.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 4,349.10 4,947.10 200,000.00 195,052.90 2.5 01-0416-46-00 ALLUMBAUGH HOUSE 4,437.25 8,874.50 24,020.00 15,145.50 37.0 01-0416-49-00 DRUGFREE IDAHO 443.25 874.68 1,500.00 625.32 58.3 01-0416-54-00 IDAHO SUICIDE PREVENTION .00 .00 10,000.00 10,000.00 .0 01-0416-56-00 CRIME STOPPERS .00 3,520.00 3,736.00 216.00 94.2 TOTAL CONTRACTS & AGREEMENTS 1,363,249.50 2,079,778.95 4,577,893.00 2,498,114.05 45.4 CODE ENFORCEMENT 01-0417-00-00 WEED 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 5,212.43 5,212.43 20,000.00 14,787.57 26.1 01-0422-15-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 TOTAL RESTRICTED 5,212.43 5,212.43 39,000.00 33,787.57 13.4 PUBLIC AFFAIRS/COMM RELATIONS 01-0462-01-00 PUBLIC RELATIONS 1,251.78 2,383.55 6,000.00 3,616.45 39.7 01-0462-02-00 AWARDS & RECOGNITIONS .00 .00 1,500.00 1,500.00 .0 TOTAL PUBLIC AFFAIRS/COMM RELATIONS 1,251.78 2,383.55 7,500.00 5,116.45 31.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:25PM PAGE: 7 GENERAL FUND TRANSFERS 01-0463-01-00 MUSEUM DEPT TRANSFER 29,096.42 61,422.85 176,950.00 115,527.15 34.7 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 1,017.43 1,017.43 192,365.00 191,347.57 .5 01-0463-06-00 RECREATION PARKS-REC TRANSFER 69,450.52 163,929.52 639,420.00 475,490.48 25.6 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 ( 127,003.43)100.00 90,550.00 90,450.00 .1 01-0463-11-00 PUBLIC WORKS TRANSFER 579,222.09 905,684.36 3,037,006.00 2,131,321.64 29.8 01-0463-11-01 EXECUTIVE DEPT TRANSFER 95,202.81 196,442.92 647,311.00 450,868.08 30.4 01-0463-12-00 CITY HALL BOND FUND TRANSFER 9,173.20 9,173.20 104,000.00 94,826.80 8.8 01-0463-12-01 CLERK/TREAS DEPT TRANSFER 157,333.97 319,341.46 823,180.00 503,838.54 38.8 01-0463-13-01 BUILDING DEPT TRANSFER 200,375.65 418,610.29 1,021,640.00 603,029.71 41.0 01-0463-14-01 PLANNING AND ZONING DEPT TRANS 246,944.97 519,458.25 1,332,040.00 812,581.75 39.0 01-0463-15-00 LIBRARY TRANSFER .00 .00 1,402,353.00 1,402,353.00 .0 01-0463-18-01 IT DEPT TRANSFER 221,046.02 407,192.24 1,010,650.00 603,457.76 40.3 01-0463-26-01 ECONOMIC DEV DEPT TRANSFER .00 757.06 .00 ( 757.06).0 TOTAL GENERAL FUND TRANSFERS 1,481,859.65 3,584,582.55 13,187,038.00 9,602,455.45 27.2 COMMUNITY PROJECTS-CAP OUTLAY 01-0468-10-00 VRT HWY 44 EXPRESS SRV ENHANC .00 .00 93,316.00 93,316.00 .0 01-0468-10-01 VRT EAGLE SENIOR CITIZENS 9,700.00 9,700.00 9,700.00 .00 100.0 TOTAL COMMUNITY PROJECTS-CAP OUTLA 9,700.00 9,700.00 103,016.00 93,316.00 9.4 FIRE DEPARTMENT IMPACT FEES 01-0469-00-00 FIRE DEPT IMPACT FEES 37,495.12 115,517.56 313,950.00 198,432.44 36.8 TOTAL FIRE DEPARTMENT IMPACT FEES 37,495.12 115,517.56 313,950.00 198,432.44 36.8 TOTAL FUND EXPENDITURES 3,039,539.32 6,107,285.31 19,342,350.00 13,235,064.69 31.6 NET REVENUE OVER EXPENDITURES 1,826,340.64 1,032,269.21 .00 ( 1,032,269.21).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 LIBRARY FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:26PM PAGE: 8 ASSETS 06-0101-00-00 CASH 16,465.81 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-0151-25-00 INVESTMENTS 350,938.74 06-0170-00-00 HRA 10% DEPOSIT 1,872.00 TOTAL ASSETS 376,663.99 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 11,692.85 06-0217-09-00 WORKERS' COMPENSATION 15,892.78 06-0217-10-00 HSA CONTRIBUTION 2,454.00 06-0226-00-00 DEFERRED REVENUE 6,220.06 TOTAL LIABILITIES 61,850.51 FUND EQUITY 06-0271-00-00 LIBRARY/FUND BALANCE 962,049.97 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 647,236.49) BALANCE - CURRENT DATE ( 647,236.49) TOTAL FUND EQUITY 314,813.48 TOTAL LIABILITIES AND EQUITY 376,663.99 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:26PM PAGE: 9 REVENUE 06-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 1,402,353.00 1,402,353.00 .0 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,006.31 2,221.28 1,000.00 ( 1,221.28)222.1 06-0361-20-01 LOST ITEMS 2,035.38 3,598.31 2,500.00 ( 1,098.31)143.9 06-0361-21-00 LIBRARY/COPY MACHINE REVENUE 492.66 995.42 1,200.00 204.58 83.0 06-0361-21-01 3 D PRINTING ( 3.12)49.08 400.00 350.92 12.3 06-0371-25-00 BANK INTEREST 294.44 823.57 1,200.00 376.43 68.6 06-0379-00-00 MISCELLANEOUS 1,243.15 3,764.48 750.00 ( 3,014.48)501.9 06-0380-02-00 GRANTS-GIFTS-MEMORIALS 300.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 5,368.82 11,752.14 2,242,903.00 2,231,150.86 .5 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 350.00 612.50 10,000.00 9,387.50 6.1 06-0416-02-00 PHOTOCOPIERS 3,922.48 6,050.35 11,500.00 5,449.65 52.6 TOTAL CONTRACTS/AGREEMENTS 4,272.48 6,662.85 21,500.00 14,837.15 31.0 OPERATIONS & MAINTENANCE 06-0420-01-00 ADMINISTRATION 8,485.67 11,285.06 15,000.00 3,714.94 75.2 06-0420-03-00 OPERATIONS SUBSCRIPTIONS 2,397.60 2,499.30 43,924.00 41,424.70 5.7 06-0420-04-00 MARKETING 143.94 5,004.93 15,000.00 9,995.07 33.4 06-0420-04-01 OUTREACH .00 .00 2,000.00 2,000.00 .0 06-0420-05-00 OFFICE SUPPLIES 1,298.28 3,517.81 8,500.00 4,982.19 41.4 06-0420-05-01 MATERIAL PROCESSING SUPPLIES 598.95 1,510.43 5,000.00 3,489.57 30.2 06-0420-06-00 UNIFORMS .00 433.54 4,180.00 3,746.46 10.4 06-0420-07-00 SMALL FURNITURE REPLACEMENT 2,602.22 4,293.42 1,500.00 ( 2,793.42)286.2 06-0420-09-00 MAINTENANCE AGREEMENTS 12,820.00 12,820.00 27,910.00 15,090.00 45.9 06-0420-10-00 POSTAGE 187.33 187.33 2,500.00 2,312.67 7.5 06-0420-11-00 SUBSCRIPTIONS & MEMBERSHIPS 567.00 2,370.35 9,030.00 6,659.65 26.3 06-0420-12-00 DEBT COLLECTION 152.15 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 6 MONTHS ENDING MARCH 31, 2023 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:26PM PAGE: 10 TOTAL OPERATIONS & MAINTENANCE 29,253.14 44,074.32 135,744.00 91,669.68 32.5 LYNX1 CONSORTIUM 06-0430-00-00 LYNX! SYSTEM 6,054.53 6,054.53 25,000.00 18,945.47 24.2 06-0430-02-00 LYNX! COURIER .00 3,693.40 14,124.00 10,430.60 26.2 TOTAL LYNX1 CONSORTIUM 6,054.53 9,747.93 39,124.00 29,376.07 24.9 COST RECOVERY OR PASS THRU 06-0435-00-00 CREDIT CARD PROCESSING FEE 1,054.17 1,593.02 3,000.00 1,406.98 53.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 752.09 1,040.89 1,200.00 159.11 86.7 TOTAL COST RECOVERY OR PASS THRU 1,806.26 2,638.91 4,900.00 2,261.09 53.9 TECHNOLOGY 06-0440-00-00 COMPUTER SOFTWARE .00 .00 10,650.00 10,650.00 .0 06-0440-01-00 COMPUTER MAINTENANCE & REPAIR .00 .00 1,250.00 1,250.00 .0 06-0440-02-00 COMPUTER EQUIPMENT (SMALL)39.99 39.99 3,100.00 3,060.01 1.3 TOTAL TECHNOLOGY 39.99 39.99 15,000.00 14,960.01 .3 GUEST RESOURCES 06-0450-00-00 BOOKS 39,480.90 71,686.01 143,116.00 71,429.99 50.1 06-0450-01-00 PRINT VENDOR PROCESSING 1,716.56 2,769.14 7,376.00 4,606.86 37.5 06-0450-02-00 BOOKS -DIGITAL 10,901.40 14,460.03 63,682.00 49,221.97 22.7 06-0450-03-00 MAGAZINES & NEWSPAPERS .00 3,248.51 4,308.00 1,059.49 75.4 06-0450-03-01 MAGAZINES - DIGITAL 7,375.00 7,375.00 10,647.00 3,272.00 69.3 06-0450-04-00 MEDIA 15,040.49 21,582.06 79,073.00 57,490.94 27.3 06-0450-05-00 MEDIA - DIGITAL 3,287.00 4,465.99 61,434.00 56,968.01 7.3 06-0450-06-00 DATABASES 5,395.00 9,286.00 11,845.00 2,559.00 78.4 06-0450-07-00 HOTSPOT 242.20 1,261.37 2,800.00 1,538.63 45.1 TOTAL GUEST RESOURCES 83,438.55 136,134.11 384,281.00 248,146.89 35.4 GUEST CLASSES & EVENTS 06-0455-00-00 CLASSES & EVENTS 5,419.08 9,434.82 20,000.00 10,565.18 47.2 TOTAL GUEST CLASSES & EVENTS 5,419.08 9,434.82 20,000.00 10,565.18 47.2 PERSONNEL 06-0461-10-00 SALARIES - FULL TIME 120,772.05 257,812.21 526,900.00 269,087.79 48.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:26PM PAGE: 11 06-0461-10-01 SALARIES - PERSONNEL SERVICES 236.48 236.48 .00 ( 236.48).0 06-0461-11-00 OVERTIME 589.49 2,566.85 5,000.00 2,433.15 51.3 06-0461-15-00 SALARIES - PART TIME 32,812.09 75,346.97 276,000.00 200,653.03 27.3 06-0461-15-01 SALARIES - PERSONNEL SERVICES 2,990.10 4,146.20 .00 ( 4,146.20).0 06-0461-21-00 FICA 11,530.96 25,254.08 55,183.00 29,928.92 45.8 06-0461-22-00 PERSI 14,239.58 30,841.15 56,648.00 25,806.85 54.4 06-0461-23-00 HRA BUY-DOWN .00 .00 5,500.00 5,500.00 .0 06-0461-23-01 HRA/COBRA ADMIN FEES 292.80 465.95 900.00 434.05 51.8 06-0461-24-00 WORKERS' COMPENSATION 812.30 2,476.25 2,918.00 441.75 84.9 06-0461-25-00 INSURANCE 20,484.80 33,718.30 78,405.00 44,686.70 43.0 06-0461-26-00 HSA CONTRIBUTION 510.00 1,140.00 8,160.00 7,020.00 14.0 06-0461-27-00 PTO CASH OUT .00 .00 10,000.00 10,000.00 .0 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 205,270.65 434,004.44 1,045,154.00 611,149.56 41.5 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 .00 .00 500.00 500.00 .0 06-0463-02-00 TRAINING .00 .00 1,000.00 1,000.00 .0 06-0463-03-00 CONTINUING EDUCATION 331.99 3,181.99 6,300.00 3,118.01 50.5 06-0463-08-00 VIRTUAL TRAINING .00 .00 1,500.00 1,500.00 .0 TOTAL STAFF DEVELOPMENT 331.99 3,598.65 20,700.00 17,101.35 17.4 FACILITY (BLDGS & GROUNDS) 06-0464-00-00 BUILDING .00 .00 1,500.00 1,500.00 .0 06-0464-01-00 BUILDING SUPPLIES .00 .00 1,500.00 1,500.00 .0 06-0464-02-00 UTILITIES 5,629.50 12,023.95 27,000.00 14,976.05 44.5 06-0464-03-00 TELEPHONE .00 .00 1,000.00 1,000.00 .0 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 383.70 628.66 1,500.00 871.34 41.9 TOTAL FACILITY (BLDGS & GROUNDS)6,013.20 12,652.61 36,500.00 23,847.39 34.7 TOTAL FUND EXPENDITURES 341,899.87 658,988.63 2,242,903.00 1,583,914.37 29.4 NET REVENUE OVER EXPENDITURES ( 336,531.05)( 647,236.49).00 647,236.49 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 MUSEUM FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:26PM PAGE: 12 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 514.82 07-0217-09-00 WORKERS' COMPENSATION 1,554.19 TOTAL LIABILITIES 2,556.49 FUND EQUITY 07-0271-00-00 MUSEUM FUND BALANCE ( 4,421.71) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,865.22 BALANCE - CURRENT DATE 1,865.22 TOTAL FUND EQUITY ( 2,556.49) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:26PM PAGE: 13 REVENUE 07-0316-12-00 FUNDING FROM GENERAL FUND 29,096.42 61,422.85 176,950.00 115,527.15 34.7 07-0376-00-00 MUSEUM CONTRIBUTIONS/DONATIONS .00 202.00 500.00 298.00 40.4 07-0379-00-00 MUSEUM MISC REVENUE .00 300.00 25.00 ( 275.00)1200.0 07-0379-02-00 ARCADIA BOOKS SALES/ROYALTIES 117.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 60.29 60.29 25.00 ( 35.29)241.2 TOTAL FUND REVENUE 29,273.71 62,102.14 177,755.00 115,652.86 34.9 EXPENDITURES PERSONNEL 07-0420-10-00 SALARIES - FULL TIME 22,572.66 46,979.10 102,900.00 55,920.90 45.7 07-0420-15-00 SALARIES - PART TIME .00 .00 20,000.00 20,000.00 .0 07-0420-21-00 FICA 1,726.80 3,593.87 9,500.00 5,906.13 37.8 07-0420-22-00 PERSI 2,695.20 5,609.35 12,350.00 6,740.65 45.4 07-0420-24-00 WORKERS' COMPENSATION 40.62 84.90 .00 ( 84.90).0 07-0420-25-00 INSURANCE 1,425.54 2,800.74 6,100.00 3,299.26 45.9 07-0420-27-00 HRA BUY DOWN .00 .00 3,080.00 3,080.00 .0 TOTAL PERSONNEL 28,460.82 59,067.96 153,930.00 94,862.04 38.4 EDUCATION 07-0461-02-00 ASSOCIATION MEMBERSHIP 51.50 169.50 325.00 155.50 52.2 07-0461-03-00 CONFERENCES & SEMINARS 5.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 56.50 224.50 1,575.00 1,350.50 14.3 ADMINISTRATION 07-0462-30-00 CONSERVATION/PRESERVATION .00 .00 250.00 250.00 .0 07-0462-31-00 OFFICE SUPPLIES .00 69.99 1,000.00 930.01 7.0 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 264.90 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 178.72 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 443.62 944.46 10,850.00 9,905.54 8.7 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 MUSEUM FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:26PM PAGE: 14 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 .00 .00 10,000.00 10,000.00 .0 TOTAL EXHIBITS .00 .00 11,400.00 11,400.00 .0 TOTAL FUND EXPENDITURES 28,960.94 60,236.92 177,755.00 117,518.08 33.9 NET REVENUE OVER EXPENDITURES 312.77 1,865.22 .00 ( 1,865.22).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 PARK IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:26PM PAGE: 15 ASSETS 08-0101-00-00 CASH 22,169.33 08-0151-25-00 INVESTMENTS 249,433.67 TOTAL ASSETS 271,603.00 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,681,142.69) BALANCE - CURRENT DATE ( 1,681,142.69) TOTAL FUND EQUITY 271,603.00 TOTAL LIABILITIES AND EQUITY 271,603.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 PARK IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:27PM PAGE: 16 REVENUE 08-0322-19-00 PARKS DEVELOPMENT IMPACT FEES 35,703.04 79,216.12 390,502.00 311,285.88 20.3 08-0371-25-00 BANK INTEREST 440.91 1,605.34 4,500.00 2,894.66 35.7 08-0399-00-00 CARRY OVER .00 .00 3,933,000.00 3,933,000.00 .0 TOTAL FUND REVENUE 36,143.95 80,821.46 4,328,002.00 4,247,180.54 1.9 EXPENDITURES CAPITAL IMPROVEMENTS 08-0438-37-00 CAPITAL IMPROVEMENTS 1,677,712.15 1,761,964.15 4,328,002.00 2,566,037.85 40.7 TOTAL CAPITAL IMPROVEMENTS 1,677,712.15 1,761,964.15 4,328,002.00 2,566,037.85 40.7 TOTAL FUND EXPENDITURES 1,677,712.15 1,761,964.15 4,328,002.00 2,566,037.85 40.7 NET REVENUE OVER EXPENDITURES ( 1,641,568.20)( 1,681,142.69).00 1,681,142.69 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 RECREATION - SPECIAL EVENTS FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:27PM PAGE: 17 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 15,209.37 09-0217-09-00 WORKERS' COMPENSATION 15,591.28 09-0217-10-00 HSA CONTRIBUTION 3,319.35 TOTAL LIABILITIES 34,700.54 FUND EQUITY 09-0271-00-00 FUND BALANCE 31,185.68 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 65,886.22) BALANCE - CURRENT DATE ( 65,886.22) TOTAL FUND EQUITY ( 34,700.54) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:27PM PAGE: 18 REVENUE 09-0301-00-00 FUNDING FROM GENERAL FUND 1,017.43 1,017.43 192,365.00 191,347.57 .5 09-0347-06-00 COUNTRY CHRISTMAS .00 2,410.12 2,750.00 339.88 87.6 09-0347-08-00 SATURDAY MARKET .00 .00 22,500.00 22,500.00 .0 09-0347-10-00 GAZEBO CONCERT SERIES .00 .00 825.00 825.00 .0 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 3,057.33 3,067.33 .00 ( 3,067.33).0 09-0376-13-00 SPONSORSHIPS 10,750.00 11,750.00 15,000.00 3,250.00 78.3 09-0376-15-00 EVENT APPLICATION FEES 1,300.00 1,600.00 1,500.00 ( 100.00)106.7 09-0376-17-00 SECURITY DEPOSIT .00 .00 1,200.00 1,200.00 .0 TOTAL FUND REVENUE 16,124.76 21,319.32 238,890.00 217,570.68 8.9 EXPENDITURES PERSONNEL 09-0420-10-00 SALARIES - FULL TIME 18,244.97 39,530.77 115,800.00 76,269.23 34.1 09-0420-11-00 OVERTIME .00 43.01 2,000.00 1,956.99 2.2 09-0420-21-00 FICA 1,384.26 3,002.52 8,900.00 5,897.48 33.7 09-0420-22-00 PERSI 2,178.48 4,725.17 13,900.00 9,174.83 34.0 09-0420-24-00 WORKERS' COMPENSATION 546.17 1,186.88 .00 ( 1,186.88).0 09-0420-25-00 INSURANCE 2,508.33 4,958.67 13,900.00 8,941.33 35.7 09-0420-26-00 HSA CONTRIBUTION 150.00 300.00 1,200.00 900.00 25.0 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 25,012.21 53,747.02 159,740.00 105,992.98 33.7 ADMINISTRATION 09-0463-11-00 OFFICE SUPPLIES .00 .00 800.00 800.00 .0 09-0463-12-00 PROMOTIONS .00 1,030.28 14,000.00 12,969.72 7.4 09-0463-19-00 TRAINING AND EDUCATION 726.25 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 2,739.00 2,739.00 2,150.00 ( 589.00)127.4 09-0463-22-00 UNIFORMS .00 .00 1,000.00 1,000.00 .0 09-0463-23-00 GAS AND OIL 66.75 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 .00 .00 700.00 700.00 .0 TOTAL ADMINISTRATION 3,532.00 4,642.26 25,150.00 20,507.74 18.5 ACTIVITIES 09-0467-02-00 EAGLE SATURDAY MARKET 5,502.96 5,752.96 11,000.00 5,247.04 52.3 09-0467-03-00 COUNTRY CHRISTMAS 686.74 7,754.10 8,000.00 245.90 96.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 RECREATION - SPECIAL EVENTS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:27PM PAGE: 19 09-0467-04-00 GAZEBO CONCERT SERIES .00 .00 10,000.00 10,000.00 .0 09-0467-05-00 GENERAL EVENTS 551.39 2,456.87 10,000.00 7,543.13 24.6 09-0467-06-00 EAGLE HARVEST FEST .00 4,048.86 4,000.00 ( 48.86)101.2 09-0467-07-00 EVENT EQUIPMENT PURCHASES 716.28 1,540.20 3,000.00 1,459.80 51.3 09-0467-08-00 EVENT EQUIPMENT RENTAL 7,263.27 7,263.27 8,000.00 736.73 90.8 TOTAL ACTIVITIES 14,720.64 28,816.26 54,000.00 25,183.74 53.4 TOTAL FUND EXPENDITURES 43,264.85 87,205.54 238,890.00 151,684.46 36.5 NET REVENUE OVER EXPENDITURES ( 27,140.09)( 65,886.22).00 65,886.22 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 EAGLE HISTORICAL COMMISSION FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:27PM PAGE: 20 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 6 MONTHS ENDING MARCH 31, 2023 EAGLE HISTORICAL COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:28PM PAGE: 21 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 MARCH 31, 2023 EXECUTIVE DEPARTMENT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:28PM PAGE: 22 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 ( 2,333.67) 11-0217-09-00 WORKERS' COMPENSATION 9,158.21 11-0217-10-00 HSA CONTRIBUTION ( 224.00) TOTAL LIABILITIES 9,479.10 FUND EQUITY 11-0271-00-00 FUND BALANCE ( 12,592.83) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 3,113.73 BALANCE - CURRENT DATE 3,113.73 TOTAL FUND EQUITY ( 9,479.10) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:28PM PAGE: 23 REVENUE 11-0301-00-00 FUNDING FROM GENERAL FUND 95,202.81 196,442.92 647,311.00 450,868.08 30.4 TOTAL FUND REVENUE 95,202.81 196,442.92 647,311.00 450,868.08 30.4 EXPENDITURES ADMINISTRATION 11-0413-04-00 UNIFORMS .00 .00 600.00 600.00 .0 11-0413-05-00 OFFICE SUPPLIES 229.58 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 409.00 584.00 5,000.00 4,416.00 11.7 11-0413-13-00 TRAVEL & PER DIEM 38.25 53.25 6,000.00 5,946.75 .9 11-0413-14-00 PROFESSIONAL DUES 325.00 953.97 4,453.00 3,499.03 21.4 11-0413-20-00 MARKETING 159.70 159.70 15,028.00 14,868.30 1.1 TOTAL ADMINISTRATION 1,161.53 2,180.24 32,581.00 30,400.76 6.7 PERSONNEL 11-0415-10-00 SALARIES - FULL TIME 66,266.16 143,485.59 336,000.00 192,514.41 42.7 11-0415-11-00 OVERTIME .00 368.90 500.00 131.10 73.8 11-0415-21-00 FICA 4,818.96 10,590.40 25,800.00 15,209.60 41.1 11-0415-22-00 PERSI 7,912.20 17,176.26 40,200.00 23,023.74 42.7 11-0415-24-00 WORKERS' COMPENSATION 1,131.66 2,627.40 .00 ( 2,627.40).0 11-0415-25-00 INSURANCE 9,015.38 15,286.76 38,700.00 23,413.24 39.5 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 89,144.36 189,715.31 455,480.00 265,764.69 41.7 STATE OF THE CITY 11-0417-01-00 STATE OF THE CITY 686.09 686.09 4,250.00 3,563.91 16.1 TOTAL STATE OF THE CITY 686.09 686.09 4,250.00 3,563.91 16.1 COMPREHENSIVE PLAN REWRITE 11-0418-00-00 COMP PLAN REWRITE .00 .00 150,000.00 150,000.00 .0 TOTAL COMPREHENSIVE PLAN REWRITE .00 .00 150,000.00 150,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 EXECUTIVE DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:28PM PAGE: 24 COMMUNITY & STAFF RELATIONS 11-0422-01-00 COMMUNITY/STAFF RELATIONS 109.48 355.66 5,000.00 4,644.34 7.1 11-0422-02-00 STAFF RELATIONS 391.89 391.89 .00 ( 391.89).0 TOTAL COMMUNITY & STAFF RELATIONS 501.37 747.55 5,000.00 4,252.45 15.0 TOTAL FUND EXPENDITURES 91,493.35 193,329.19 647,311.00 453,981.81 29.9 NET REVENUE OVER EXPENDITURES 3,709.46 3,113.73 .00 ( 3,113.73).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 CITY CLERK/TREAS DEPARTMENT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:28PM PAGE: 25 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 257.59 12-0217-09-00 WORKERS' COMPENSATION 7,714.65 TOTAL LIABILITIES 18,606.83 FUND EQUITY 12-0271-00-00 FUND BALANCE ( 27,232.73) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 8,625.90 BALANCE - CURRENT DATE 8,625.90 TOTAL FUND EQUITY ( 18,606.83) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 CITY CLERK/TREAS DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:28PM PAGE: 26 REVENUE 12-0301-00-00 FUNDING FROM GENERAL FUND 157,333.97 319,341.46 823,180.00 503,838.54 38.8 TOTAL FUND REVENUE 157,333.97 319,341.46 823,180.00 503,838.54 38.8 EXPENDITURES ADMINISTRATION 12-0413-05-00 OFFICE SUPPLIES 120.94 290.95 5,000.00 4,709.05 5.8 12-0413-06-00 DUPLICATION/PUBLISHING/PRINT .00 .00 150.00 150.00 .0 12-0413-12-00 PERSONNEL TRAINING & RESOURCES 1,327.34 1,327.34 12,500.00 11,172.66 10.6 12-0413-13-00 TRAVEL & PER DIEM 660.75 1,816.34 10,000.00 8,183.66 18.2 12-0413-14-00 PROFESSIONAL DUES 2,869.00 3,499.00 5,500.00 2,001.00 63.6 12-0413-29-00 UNIFORMS .00 .00 800.00 800.00 .0 12-0413-30-00 MISCELLANEOUS 132.44 132.44 500.00 367.56 26.5 TOTAL ADMINISTRATION 5,110.47 7,066.07 34,450.00 27,383.93 20.5 PERSONNEL 12-0415-10-00 SALARIES - FULL TIME 102,628.68 221,305.99 570,500.00 349,194.01 38.8 12-0415-11-00 OVERTIME .00 .00 4,000.00 4,000.00 .0 12-0415-21-00 FICA 7,896.38 16,701.81 43,800.00 27,098.19 38.1 12-0415-22-00 PERSI 12,834.27 27,004.33 64,750.00 37,745.67 41.7 12-0415-23-00 HRA BUY- DOWN 132.96 261.27 10,780.00 10,518.73 2.4 12-0415-23-02 HSA CONTRIBUTION 300.00 600.00 1,200.00 600.00 50.0 12-0415-24-00 WORKERS' COMPENSATION 193.52 408.85 .00 ( 408.85).0 12-0415-25-00 INSURANCE 17,004.61 32,506.24 83,700.00 51,193.76 38.8 12-0415-26-00 PTO CASH OUT 4,861.00 4,861.00 10,000.00 5,139.00 48.6 TOTAL PERSONNEL 145,851.42 303,649.49 788,730.00 485,080.51 38.5 TOTAL FUND EXPENDITURES 150,961.89 310,715.56 823,180.00 512,464.44 37.8 NET REVENUE OVER EXPENDITURES 6,372.08 8,625.90 .00 ( 8,625.90).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 BUILDING DEPARTMENT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:29PM PAGE: 27 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,471.14 13-0217-09-00 WORKERS' COMPENSATION 53,352.46 13-0217-10-00 HSA CONTRIBUTION ( 1,900.00) TOTAL LIABILITIES 64,409.53 FUND EQUITY 13-0271-00-00 FUND BALANCE ( 96,243.86) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 31,934.33 BALANCE - CURRENT DATE 31,934.33 TOTAL FUND EQUITY ( 64,309.53) TOTAL LIABILITIES AND EQUITY 100.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:29PM PAGE: 28 REVENUE 13-0301-00-00 FUNDING FROM GENERAL FUND 200,375.65 418,610.29 1,021,640.00 603,029.71 41.0 TOTAL FUND REVENUE 200,375.65 418,610.29 1,021,640.00 603,029.71 41.0 EXPENDITURES ADMINISTRATION 13-0413-05-00 OFFICE SUPPLIES 19.24 50.71 6,500.00 6,449.29 .8 13-0413-08-00 LEGAL ADS & PUBLICATIONS .00 .00 400.00 400.00 .0 13-0413-09-00 COMMERCIAL PLAN REVIEW 170.00 3,555.00 5,000.00 1,445.00 71.1 13-0413-12-00 TRAINING & CERTIFICATION RENEW 2,490.00 2,961.00 4,500.00 1,539.00 65.8 13-0413-13-00 TRAVEL & PER DIEM .00 .00 2,000.00 2,000.00 .0 13-0413-14-00 PROFESSIONAL DUES 440.00 440.00 700.00 260.00 62.9 13-0413-25-00 MISCELLANEOUS .00 .00 400.00 400.00 .0 13-0413-28-00 RESOURCE MATERIALS .00 .00 1,500.00 1,500.00 .0 13-0413-30-00 UNIFORMS 1,705.70 1,705.70 2,000.00 294.30 85.3 TOTAL ADMINISTRATION 4,824.94 8,712.41 23,000.00 14,287.59 37.9 PERSONNEL 13-0415-10-00 SALARIES - FULL TIME 77,199.41 166,985.47 394,800.00 227,814.53 42.3 13-0415-11-00 OVERTIME 97.06 151.65 4,000.00 3,848.35 3.8 13-0415-21-00 FICA 5,667.29 12,313.59 30,200.00 17,886.41 40.8 13-0415-22-00 PERSI 9,229.24 19,956.26 47,500.00 27,543.74 42.0 13-0415-23-00 HRA BUY-DOWN .00 .00 9,240.00 9,240.00 .0 13-0415-24-00 WORKERS' COMPENSATION 2,571.65 5,567.35 .00 ( 5,567.35).0 13-0415-25-00 INSURANCE 15,909.66 30,729.15 78,500.00 47,770.85 39.2 13-0415-26-00 HSA CONTRIBUTION 300.00 900.00 2,400.00 1,500.00 37.5 13-0415-28-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 TOTAL PERSONNEL 110,974.31 236,603.47 571,640.00 335,036.53 41.4 CONTRACTS & AGREEMENTS 13-0416-09-00 PLUMBING INSPECTOR 16,697.97 30,884.58 120,000.00 89,115.42 25.7 13-0416-11-00 MECHANICAL INSPECTOR 20,936.82 35,197.33 120,000.00 84,802.67 29.3 13-0416-13-00 BLDG INSPECTOR 6,488.00 13,068.00 61,500.00 48,432.00 21.3 13-0416-14-00 PLAN REVIEW - CONTRACT .00 .00 5,000.00 5,000.00 .0 13-0416-25-00 ELECTRICAL INSPECTOR 37,380.55 62,168.22 120,000.00 57,831.78 51.8 TOTAL CONTRACTS & AGREEMENTS 81,503.34 141,318.13 426,500.00 285,181.87 33.1 VEHICLE OPERATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 BUILDING DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:29PM PAGE: 29 13-0417-02-00 GAS AND OIL .00 41.95 500.00 458.05 8.4 TOTAL VEHICLE OPERATIONS .00 41.95 500.00 458.05 8.4 TOTAL FUND EXPENDITURES 197,302.59 386,675.96 1,021,640.00 634,964.04 37.9 NET REVENUE OVER EXPENDITURES 3,073.06 31,934.33 .00 ( 31,934.33).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 P&Z DEPARTMENT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:29PM PAGE: 30 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 ( 38,975.35) 14-0217-08-00 P&Z DEPT/GARNISHMENTS 203.34 14-0217-09-00 WORKERS' COMPENSATION 78,802.97 TOTAL LIABILITIES 58,446.31 FUND EQUITY 14-0271-00-00 FUND BALANCE ( 63,698.43) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 5,252.12 BALANCE - CURRENT DATE 5,252.12 TOTAL FUND EQUITY ( 58,446.31) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:29PM PAGE: 31 REVENUE 14-0301-00-00 FUNDING FROM GENERAL FUND 246,944.97 519,458.25 1,332,040.00 812,581.75 39.0 TOTAL FUND REVENUE 246,944.97 519,458.25 1,332,040.00 812,581.75 39.0 EXPENDITURES ADMINISTRATION 14-0413-05-00 OFFICE SUPPLIES 321.61 439.63 1,800.00 1,360.37 24.4 14-0413-06-00 DUPLICATION/PUBLISHING/PRNTG .00 .00 1,000.00 1,000.00 .0 14-0413-08-00 LEGAL ADS & PUBLICATIONS 1,568.53 2,115.61 8,000.00 5,884.39 26.5 14-0413-12-00 PERSONNEL TRAINING 696.00 696.00 5,100.00 4,404.00 13.7 14-0413-13-00 TRAVEL & PER DIEM 474.08 474.08 15,000.00 14,525.92 3.2 14-0413-14-00 PROFESSIONAL DUES 160.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 8.53 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 3,228.75 5,039.85 43,700.00 38,660.15 11.5 PERSONNEL 14-0415-10-00 SALARIES - FULL TIME 172,581.44 374,250.03 898,000.00 523,749.97 41.7 14-0415-10-01 SALARIES - PERSONNEL SERVICES 514.32 514.32 .00 ( 514.32).0 14-0415-11-00 OVERTIME 3,147.28 5,147.63 13,000.00 7,852.37 39.6 14-0415-21-00 FICA 13,140.73 28,498.16 69,800.00 41,301.84 40.8 14-0415-22-00 PERSI 20,893.76 45,211.85 108,900.00 63,688.15 41.5 14-0415-24-00 WORKERS' COMPENSATION 2,047.54 4,486.69 .00 ( 4,486.69).0 14-0415-25-00 INSURANCE 24,016.74 46,542.60 124,700.00 78,157.40 37.3 14-0415-26-00 HSA CONTRIBUTION 300.00 600.00 1,200.00 600.00 50.0 14-0415-29-00 PTO CASH OUT .00 .00 15,000.00 15,000.00 .0 14-0415-30-00 HRA BUY- DOWN .00 1,540.00 16,940.00 15,400.00 9.1 TOTAL PERSONNEL 236,641.81 506,791.28 1,247,540.00 740,748.72 40.6 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,140.00 2,375.00 10,000.00 7,625.00 23.8 TOTAL CONTRACTS & AGREEMENTS 1,140.00 2,375.00 30,000.00 27,625.00 7.9 PUBLIC RELATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 P&Z DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:29PM PAGE: 32 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 241,010.56 514,206.13 1,332,040.00 817,833.87 38.6 NET REVENUE OVER EXPENDITURES 5,934.41 5,252.12 .00 ( 5,252.12).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 RECREATION - PARKS AND REC FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:29PM PAGE: 33 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 ( 13,927.00) 17-0217-09-00 WORKERS' COMPENSATION 45,999.80 17-0217-10-00 HSA CONTRIBUTION ( 4,225.93) TOTAL LIABILITIES 30,593.46 FUND EQUITY 17-0271-00-00 FUND BALANCE ( 34,960.88) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 4,367.42 BALANCE - CURRENT DATE 4,367.42 TOTAL FUND EQUITY ( 30,593.46) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 RECREATION - PARKS AND REC PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:30PM PAGE: 34 REVENUE 17-0301-00-00 FUNDING FROM GENERAL FUND 69,450.52 163,929.52 639,420.00 475,490.48 25.6 17-0302-00-00 REGISTRATION, CAMPS & CLASSES 41,238.80 73,396.35 112,000.00 38,603.65 65.5 17-0302-01-00 SPONSORSHIPS .00 .00 10,000.00 10,000.00 .0 17-0302-03-00 PARK RESERVATION FEES 3,109.50 5,729.62 20,000.00 14,270.38 28.7 17-0399-00-00 CARRY OVER .00 .00 1,000.00 1,000.00 .0 TOTAL FUND REVENUE 113,798.82 243,055.49 782,420.00 539,364.51 31.1 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 1,149.00 5,793.00 14,000.00 8,207.00 41.4 TOTAL CONTRACTS 1,149.00 5,793.00 34,000.00 28,207.00 17.0 PERSONNEL 17-0420-10-00 SALARIES - FULL TIME 69,137.09 142,231.58 351,200.00 208,968.42 40.5 17-0420-10-01 SALARIES - PERSONNEL SERVICES 3,566.46 8,274.45 .00 ( 8,274.45).0 17-0420-11-00 SALARIES - SEASONAL .00 216.19 .00 ( 216.19).0 17-0420-15-00 SALARIES - PART TIME .00 .00 115,200.00 115,200.00 .0 17-0420-18-00 OVERTIME .00 99.26 4,000.00 3,900.74 2.5 17-0420-21-00 FICA 5,277.30 10,832.38 35,800.00 24,967.62 30.3 17-0420-22-00 PERSI 8,254.96 16,999.94 42,100.00 25,100.06 40.4 17-0420-23-00 HRA BUY-DOWN .00 .00 4,620.00 4,620.00 .0 17-0420-24-00 WORKERS' COMPENSATION 2,536.02 5,217.01 .00 ( 5,217.01).0 17-0420-25-00 INSURANCE 8,547.62 16,261.05 51,800.00 35,538.95 31.4 17-0420-26-00 HSA CONTRIBUTION 450.00 900.00 1,200.00 300.00 75.0 17-0420-27-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 TOTAL PERSONNEL 97,769.45 201,031.86 610,920.00 409,888.14 32.9 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 32.83 467.83 2,000.00 1,532.17 23.4 17-0422-01-00 OFFICE SUPPLIES 121.46 202.66 1,000.00 797.34 20.3 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 6 MONTHS ENDING MARCH 31, 2023 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:30PM PAGE: 35 17-0422-02-01 ADVERTISING/MKTNG TEAM SPORTS .00 .00 2,000.00 2,000.00 .0 17-0422-04-00 GAS AND OIL 222.32 222.32 100.00 ( 122.32)222.3 17-0422-05-00 COMMUNICATION 148.00 222.00 .00 ( 222.00).0 17-0422-06-00 PRINTING AND PUBLISHING 30.00 410.53 500.00 89.47 82.1 17-0422-07-00 PROFESSIONAL DUES 848.90 1,048.90 1,000.00 ( 48.90)104.9 17-0422-08-00 TRAINING AND EDUCATION 1,665.00 1,665.00 3,000.00 1,335.00 55.5 17-0422-09-00 TRAVEL & PER DIEM .00 .00 5,000.00 5,000.00 .0 17-0422-10-00 BACKGROUND CHECKS 2,670.51 3,341.30 3,000.00 ( 341.30)111.4 17-0422-11-00 REFUNDS-PARK REC PROGRAMS 255.00 255.00 7,600.00 7,345.00 3.4 TOTAL ADMINISTRATION 5,994.02 8,035.54 26,700.00 18,664.46 30.1 RECREATION 17-0423-00-00 REC SUPPLIES-CAMPS & CLASSES 78.49 138.19 10,000.00 9,861.81 1.4 17-0423-00-01 REC SUPPLIES-TEAM SPORTS 1,204.21 9,181.42 20,000.00 10,818.58 45.9 17-0423-01-00 UNIFORMS, TEAM SPORTS 6,182.90 11,681.82 15,000.00 3,318.18 77.9 17-0423-02-00 FIELD TRIPS .00 21.00 20,000.00 19,979.00 .1 17-0423-04-00 TRANSPORTATION SERVICES .00 .00 15,000.00 15,000.00 .0 17-0423-05-00 DADDY DAUGHTER DANCE 1,848.06 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 149.99 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-10-00 NEW PROGRAMS .00 .00 2,000.00 2,000.00 .0 TOTAL RECREATION 9,463.65 23,773.02 91,300.00 67,526.98 26.0 VEHICLES 17-0424-03-00 GAS AND OIL 54.65 54.65 1,000.00 945.35 5.5 TOTAL VEHICLES 54.65 54.65 1,000.00 945.35 5.5 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 .00 .00 1,500.00 1,500.00 .0 TOTAL CAPITAL OUTLAY .00 .00 1,500.00 1,500.00 .0 TOTAL FUND EXPENDITURES 114,430.77 238,688.07 782,420.00 543,731.93 30.5 NET REVENUE OVER EXPENDITURES ( 631.95)4,367.42 .00 ( 4,367.42).0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:30PM PAGE: 36 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 IT DEPARTMENT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:30PM PAGE: 37 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 ( 32,616.94) 18-0217-09-00 WORKERS' COMPENSATION 2,103.46 18-0217-10-00 HSA CONTRIBUTION 820.00 TOTAL LIABILITIES ( 28,201.09) FUND EQUITY 18-0271-00-00 FUND BALANCE 4,077.44 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 24,123.65 BALANCE - CURRENT DATE 24,123.65 TOTAL FUND EQUITY 28,201.09 TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:30PM PAGE: 38 REVENUE 18-0301-00-00 FUNDING FROM GENERAL FUND 221,046.02 407,192.24 1,010,650.00 603,457.76 40.3 TOTAL FUND REVENUE 221,046.02 407,192.24 1,010,650.00 603,457.76 40.3 EXPENDITURES ADMINISTRATION 18-0413-01-00 OFFICE SUPPLIES .00 51.78 1,000.00 948.22 5.2 18-0413-02-00 SUPPLIES .00 55.00 4,000.00 3,945.00 1.4 18-0413-03-00 TRAINING AND EDUCATION .00 .00 7,000.00 7,000.00 .0 18-0413-04-00 TRAVEL & PER DIEM 1,175.50 4,112.12 7,000.00 2,887.88 58.7 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,175.50 4,218.90 20,550.00 16,331.10 20.5 PERSONNEL 18-0415-10-00 SALARIES - FULL TIME 57,486.33 124,612.83 292,800.00 168,187.17 42.6 18-0415-11-00 IT DEPT/OVERTIME 369.31 637.76 5,000.00 4,362.24 12.8 18-0415-21-00 FICA 4,152.75 9,050.99 22,500.00 13,449.01 40.2 18-0415-22-00 PERSI 6,907.92 14,954.83 35,200.00 20,245.17 42.5 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 103.95 226.06 .00 ( 226.06).0 18-0415-25-00 INSURANCE 10,386.99 20,032.68 55,500.00 35,467.32 36.1 18-0415-26-00 HSA 180.00 360.00 2,400.00 2,040.00 15.0 18-0415-27-00 PTO CASH OUT .00 .00 2,500.00 2,500.00 .0 TOTAL PERSONNEL 79,587.25 171,415.15 422,100.00 250,684.85 40.6 CONTRACT & AGREEMENTS 18-0416-01-00 CONTRACT AND AGREEMENTS 99,253.26 146,942.20 350,000.00 203,057.80 42.0 TOTAL CONTRACT & AGREEMENTS 99,253.26 146,942.20 350,000.00 203,057.80 42.0 INTERNET/PHONE SERVICES 18-0417-01-00 INTERNET & PHONE SERVICES 14,281.20 23,982.56 78,000.00 54,017.44 30.8 18-0417-02-00 REPAIRS & SERVICES 37.99 37.99 .00 ( 37.99).0 TOTAL INTERNET/PHONE SERVICES 14,319.19 24,020.55 78,000.00 53,979.45 30.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 IT DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:30PM PAGE: 39 OPERATIONAL RESERVES 18-0418-01-00 IT EQUIPMENT/SOFTWARE .00 11,818.94 35,000.00 23,181.06 33.8 TOTAL OPERATIONAL RESERVES .00 11,818.94 35,000.00 23,181.06 33.8 CAPITAL OUTLAY 18-0419-01-00 FURNITURE .00 .00 1,000.00 1,000.00 .0 18-0419-02-00 EQUIPMENT 20,523.08 24,652.85 65,000.00 40,347.15 37.9 18-0419-03-00 SOFTWARE PURCHASES .00 .00 25,000.00 25,000.00 .0 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 20,523.08 24,652.85 105,000.00 80,347.15 23.5 TOTAL FUND EXPENDITURES 214,858.28 383,068.59 1,010,650.00 627,581.41 37.9 NET REVENUE OVER EXPENDITURES 6,187.74 24,123.65 .00 ( 24,123.65).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 CAPITAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:30PM PAGE: 40 ASSETS 19-0101-00-00 CASH 983,353.43 19-0115-00-00 ACCOUNTS RECEIVABLE 158,448.60 19-0151-25-00 INVESTMENTS 5,424,015.93 TOTAL ASSETS 6,565,817.96 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 ( 212,879.12) BALANCE - CURRENT DATE ( 212,879.12) TOTAL FUND EQUITY 4,589,228.98 TOTAL LIABILITIES AND EQUITY 6,565,817.96 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:30PM PAGE: 41 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-01-00 BANK INTEREST 1,767.38 7,012.47 4,100.00 ( 2,912.47)171.0 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 698,032.41 1,330,533.96 3,180,852.00 1,850,318.04 41.8 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 225,501.54 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-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 925,301.33 2,168,582.74 17,025,411.00 14,856,828.26 12.7 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 16,769.03 33,858.97 3,026,380.00 2,992,521.03 1.1 19-0462-03-00 FEMA TRAIL REPLACEMENT .00 .00 676,491.00 676,491.00 .0 TOTAL CAPITAL MAINTENANCE 16,769.03 33,858.97 3,702,871.00 3,669,012.03 .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 ( 1,554,046.23)960,181.67 .00 ( 960,181.67).0 19-0465-08-00 CURRENT FISCAL YEAR PROJECTS 18,023.75 28,565.00 1,513,000.00 1,484,435.00 1.9 TOTAL CITY CAPITAL PROJECTS ( 1,536,022.48)988,746.67 1,613,000.00 624,253.33 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 .00 488,595.73 3,300,000.00 2,811,404.27 14.8 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 FY22 .00 .00 40,000.00 40,000.00 .0 TOTAL PZ CAPITAL PROJECTS .00 488,595.73 4,868,309.00 4,379,713.27 10.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 CAPITAL PROJECTS FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:30PM PAGE: 42 PARK CAPITAL PROJECTS 19-0467-02-00 PARK CAPITAL PROJECTS FY22 3,595.00 3,595.00 200,000.00 196,405.00 1.8 TOTAL PARK CAPITAL PROJECTS 3,595.00 3,595.00 200,000.00 196,405.00 1.8 PW CAPITAL PROJECTS 19-0469-09-00 PW CAPITAL PROJECTS FY22 .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 ( 12,954.06)123,796.07 1,159,000.00 1,035,203.93 10.7 19-0486-01-01 ARPA, SOFTWARE PURCHASES 32,000.00 32,000.00 .00 ( 32,000.00).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 ( 2,398.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 166,096.00 166,096.00 929,020.00 762,924.00 17.9 TOTAL FEDERAL FUNDS PROJECTS 182,743.94 866,665.49 2,088,020.00 1,221,354.51 41.5 TOTAL FUND EXPENDITURES ( 1,332,914.51)2,381,461.86 17,025,411.00 14,643,949.14 14.0 NET REVENUE OVER EXPENDITURES 2,258,215.84 ( 212,879.12).00 212,879.12 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 ARTS COMMISSION FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:31PM PAGE: 43 ASSETS 21-0101-00-00 CASH 627.50 TOTAL ASSETS 627.50 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 627.50 BALANCE - CURRENT DATE 627.50 TOTAL FUND EQUITY 627.50 TOTAL LIABILITIES AND EQUITY 627.50 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 ARTS COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:31PM PAGE: 44 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 .00 .00 500.00 500.00 .0 21-0376-12-00 POSTCARD REVENUE 2.50 27.50 380.00 352.50 7.2 TOTAL FUND REVENUE 2.50 27.50 77,500.00 77,472.50 .0 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 6 MONTHS ENDING MARCH 31, 2023 ARTS COMMISSION YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:31PM PAGE: 45 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 2.50 627.50 .00 ( 627.50).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 PUBLIC WORKS FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:31PM PAGE: 46 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 ( 261.13) 23-0217-08-00 GARNISHMENT ( 1,162.50) 23-0217-09-00 WORKERS' COMPENSATION 127,866.20 23-0217-10-00 HSA CONTRIBUTION ( 1,160.00) TOTAL LIABILITIES 127,933.60 FUND EQUITY 23-0271-00-00 FUND BALANCE ( 169,515.86) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 41,582.26 BALANCE - CURRENT DATE 41,582.26 TOTAL FUND EQUITY ( 127,933.60) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:32PM PAGE: 47 REVENUE 23-0302-00-00 FUNDING FROM GENERAL FUND 452,118.66 905,684.36 3,037,006.00 2,131,321.64 29.8 23-0315-02-00 SIDEWALKS, LTS, TREES, STR-REP 600.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,671.10 5,671.10 6,690.00 1,018.90 84.8 23-0316-00-00 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 23-0316-01-00 MEMORIAL DONATIONS 1,410.00 4,719.65 6,000.00 1,280.35 78.7 TOTAL FUND REVENUE 459,799.76 918,175.11 3,179,507.00 2,261,331.89 28.9 EXPENDITURES PERSONNEL 23-0433-10-00 SALARIES-FULL TIME 172,097.56 362,128.05 1,127,000.00 764,871.95 32.1 23-0433-10-01 SALARIES - PERSONNEL SERVICES 49,497.16 53,303.26 50,000.00 ( 3,303.26)106.6 23-0433-11-00 OVERTIME 1,203.85 4,172.80 18,600.00 14,427.20 22.4 23-0433-15-00 SALARIES - PART TIME .00 64.79 .00 ( 64.79).0 23-0433-16-00 SALARIES -SEASONAL .00 .00 145,000.00 145,000.00 .0 23-0433-21-00 FICA 12,920.57 27,822.18 97,500.00 69,677.82 28.5 23-0433-22-00 PERSI 20,692.21 44,452.55 135,000.00 90,547.45 32.9 23-0433-24-00 WORKERS' COMPENSATION 6,784.23 14,552.19 .00 ( 14,552.19).0 23-0433-25-00 INSURANCE 31,547.33 58,447.74 230,500.00 172,052.26 25.4 23-0433-26-00 HSA CONTRIBUTION 1,110.00 2,220.00 4,800.00 2,580.00 46.3 23-0433-27-00 HRA BUY-DOWN .00 .00 10,780.00 10,780.00 .0 23-0433-29-00 PTO CASH OUT .00 5,933.55 10,000.00 4,066.45 59.3 TOTAL PERSONNEL 295,852.91 573,097.11 1,829,180.00 1,256,082.89 31.3 ADMINISTRATION 23-0435-01-00 OFFICE SUPPLIES .00 .00 1,000.00 1,000.00 .0 23-0435-02-00 PRINT, PUBLISH, LEGAL, ADV .00 .00 8,500.00 8,500.00 .0 23-0435-03-00 TRAINING, EDUCATION, TRVL, ETC 6,850.11 8,750.69 22,225.00 13,474.31 39.4 23-0435-04-00 DUES, CERTIFICATIONS, LICENSES 128.75 128.75 1,000.00 871.25 12.9 23-0435-09-00 STAFF AND PUBLIC RELATIONS .00 .00 1,000.00 1,000.00 .0 23-0435-10-00 SAFETY CLOTHING AND GEAR 870.53 1,533.04 6,500.00 4,966.96 23.6 TOTAL ADMINISTRATION 7,849.39 10,412.48 40,225.00 29,812.52 25.9 IRRIGATION CONTRACTS/AGRMNTS 23-0437-01-00 WYCLIFFE PUMP STATION 140.19 1,094.88 6,690.00 5,595.12 16.4 23-0437-02-00 IRRIGATION SHARES AND DUES 14,326.20 14,326.20 5,350.00 ( 8,976.20)267.8 23-0437-03-00 BASELINE MANAGER AGREEMENT .00 .00 3,750.00 3,750.00 .0 23-0437-04-00 CHAUMONT LEASE AGREEMENT 1.00 1.00 1.00 .00 100.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:32PM PAGE: 48 TOTAL IRRIGATION CONTRACTS/AGRMNTS 14,467.39 15,422.08 15,791.00 368.92 97.7 GENERAL MTNC & REPAIR 23-0439-02-00 MISC MTNC & REPAIR GROUNDS 567.18 720.56 50,000.00 49,279.44 1.4 23-0439-02-01 MISC MTNC & REPAIR EQUIPMENT 6,427.79 6,484.47 30,000.00 23,515.53 21.6 23-0439-02-02 MISC MTNC & REPAIR BUILDINGS .00 455.28 4,000.00 3,544.72 11.4 23-0439-02-03 EMERGENCY REPAIRS .00 .00 25,000.00 25,000.00 .0 23-0439-02-04 REPAIRS-STRTS,SDWLKS,TREES,LTS .00 .00 150,000.00 150,000.00 .0 23-0439-03-00 MATERIALS AND SUPPLIES 14,960.21 27,179.69 57,000.00 29,820.31 47.7 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 8,156.33 18,005.58 60,000.00 41,994.42 30.0 23-0439-06-00 SIGNS & SIGN REPLACEMENT 159.85 2,480.18 5,000.00 2,519.82 49.6 TOTAL GENERAL MTNC & REPAIR 30,271.36 57,727.51 388,000.00 330,272.49 14.9 VEHICLES 23-0441-01-00 VEHICLE MTNC & REPAIR 11,191.77 16,681.59 20,000.00 3,318.41 83.4 23-0441-02-00 FUEL 9,624.73 17,695.08 35,000.00 17,304.92 50.6 TOTAL VEHICLES 20,816.50 34,376.67 55,000.00 20,623.33 62.5 FACILITIES 23-0443-01-00 CITY HALL 15,319.51 27,965.26 44,000.00 16,034.74 63.6 23-0443-02-00 LIBRARY 4,451.27 5,921.49 12,000.00 6,078.51 49.4 23-0443-03-00 MUSEUM .00 .00 2,500.00 2,500.00 .0 23-0443-04-00 CITY SHOP 2,692.28 4,830.73 4,500.00 ( 330.73)107.4 23-0443-04-01 CITY SHOP UPGRADES, SV 3,029.94 7,543.69 10,000.00 2,456.31 75.4 23-0443-05-00 SENIOR CENTER 2,386.72 2,386.72 4,000.00 1,613.28 59.7 23-0443-06-00 JACKSON HOUSE .00 .00 5,000.00 5,000.00 .0 23-0443-07-00 LINDER ROAD RESTROOM 1,296.65 2,239.90 7,500.00 5,260.10 29.9 23-0443-15-00 STREET LIGHTS 5,092.33 11,953.67 43,000.00 31,046.33 27.8 23-0443-99-01 SHOP LEASE .00 6,941.64 30,000.00 23,058.36 23.1 TOTAL FACILITIES 34,268.70 69,783.10 162,500.00 92,716.90 42.9 PARKS, MONUMENTS & GROUNDS 23-0445-01-00 ADA-EAGLE SPORTS PARK 9,794.76 21,343.24 28,000.00 6,656.76 76.2 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 .00 47.66 2,000.00 1,952.34 2.4 23-0445-05-00 FRIENDSHIP PARK 55.14 1,967.01 4,500.00 2,532.99 43.7 23-0445-06-00 GUERBER PARK 4,512.92 8,091.65 30,000.00 21,908.35 27.0 23-0445-07-00 HERITAGE PARK 739.81 1,539.01 7,500.00 5,960.99 20.5 23-0445-08-00 MACE PARKING AREA .00 .00 5,000.00 5,000.00 .0 23-0445-09-00 MCDONALD'S PATHWAY 205.59 357.92 2,000.00 1,642.08 17.9 23-0445-10-00 MERRILL PARK 793.98 2,912.22 21,500.00 18,587.78 13.6 23-0445-11-00 ORVAL KRASEN PARK 28.10 632.67 4,500.00 3,867.33 14.1 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:32PM PAGE: 49 23-0445-12-00 PAMELA BAKER PARK 6,028.79 6,556.18 11,000.00 4,443.82 59.6 23-0445-13-00 PLAZA DRIVE .00 .00 4,000.00 4,000.00 .0 23-0445-14-00 TRAILS 1,489.44 1,489.44 11,500.00 10,010.56 13.0 23-0445-20-00 CITY ENTRANCE SIGNS .00 2,772.15 11,500.00 8,727.85 24.1 23-0445-30-00 LANDSCAPING, EQUIPMENT RENTAL 2,922.75 2,922.75 15,000.00 12,077.25 19.5 23-0445-30-01 LANDSCAPING, SPRAY/FERTILIZE .00 .00 48,000.00 48,000.00 .0 23-0445-30-03 LANDSCAPING, DUMPING/DISPOSAL 458.73 477.00 2,500.00 2,023.00 19.1 TOTAL PARKS, MONUMENTS & GROUNDS 27,030.01 51,722.55 220,500.00 168,777.45 23.5 MEMORIALS AND PROGRAMS 23-0447-01-00 MEMORIALS, MTNC/REPAIR 5,190.03 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 .00 .00 17,000.00 17,000.00 .0 23-0447-04-00 SANITATION AND RECYCLING 3,087.22 7,292.81 54,000.00 46,707.19 13.5 23-0447-05-00 TREES, PUBLIC DEVELOPMENT .00 8,800.00 29,511.00 20,711.00 29.8 23-0447-05-01 TREE VOUCHER PROGRAM .00 .00 15,000.00 15,000.00 .0 23-0447-05-02 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 TOTAL MEMORIALS AND PROGRAMS 8,277.25 21,282.84 123,811.00 102,528.16 17.2 FISCAL YEAR PROJECTS 23-0483-15-00 LANDSCAPE UPGRADES - PARKS 8,144.36 14,954.36 25,000.00 10,045.64 59.8 23-0483-20-01 TOOLS 478.97 722.85 7,500.00 6,777.15 9.6 23-0483-20-02 EQUIPMENT 4,774.84 5,954.30 85,000.00 79,045.70 7.0 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 .00 21,137.00 109,000.00 87,863.00 19.4 TOTAL FISCAL YEAR PROJECTS 13,398.17 42,768.51 344,500.00 301,731.49 12.4 TOTAL FUND EXPENDITURES 452,231.68 876,592.85 3,179,507.00 2,302,914.15 27.6 NET REVENUE OVER EXPENDITURES 7,568.08 41,582.26 .00 ( 41,582.26).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 RECREATION - EAGLE FUN DAYS FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:32PM PAGE: 50 ASSETS 24-0101-00-00 CASH 59.47 TOTAL ASSETS 59.47 LIABILITIES AND EQUITY FUND EQUITY 24-0271-00-00 FUND BALANCE 4,769.47 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 4,710.00) BALANCE - CURRENT DATE ( 4,710.00) TOTAL FUND EQUITY 59.47 TOTAL LIABILITIES AND EQUITY 59.47 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:32PM PAGE: 51 REVENUE 24-0301-00-00 FUNDING FROM GENERAL FUND 100.00 100.00 90,550.00 90,450.00 .1 24-0303-00-00 SPONSORSHIPS 1,500.00 1,500.00 21,000.00 19,500.00 7.1 24-0303-01-00 CAR SHOW .00 .00 3,300.00 3,300.00 .0 24-0303-03-00 FUN RUN .00 .00 3,000.00 3,000.00 .0 24-0303-04-00 VENDORS .00 .00 7,000.00 7,000.00 .0 24-0303-05-00 ROCKY MOUNTAIN OYSTER FEED .00 .00 20,000.00 20,000.00 .0 TOTAL FUND REVENUE 1,600.00 1,600.00 144,850.00 143,250.00 1.1 EXPENDITURES ADMIN EXPENDITURES 24-0401-01-00 FUN DAYS CONTRACTS 6,250.00 6,250.00 42,000.00 35,750.00 14.9 24-0401-04-00 ADVERTISEMENT .00 .00 16,800.00 16,800.00 .0 24-0401-06-00 SUPPLIES .00 .00 9,300.00 9,300.00 .0 24-0401-07-00 EQUIPMENT .00 .00 7,500.00 7,500.00 .0 TOTAL ADMIN EXPENDITURES 6,250.00 6,250.00 75,600.00 69,350.00 8.3 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 10,000.00 10,000.00 .0 24-0410-03-00 GOLF CART RENTALS .00 .00 500.00 500.00 .0 24-0410-04-00 POLICE OVERTIME .00 .00 7,000.00 7,000.00 .0 24-0410-05-00 STREET CLOSURES .00 .00 4,500.00 4,500.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 FUN RUN 24-0420-01-00 PROMOTIONS .00 .00 4,000.00 4,000.00 .0 24-0420-02-00 BIBS .00 .00 300.00 300.00 .0 24-0420-03-00 BREAKFAST .00 .00 500.00 500.00 .0 24-0420-04-00 ADVERTISING .00 .00 200.00 200.00 .0 24-0420-05-00 MISCELLANEOUS .00 .00 400.00 400.00 .0 TOTAL FUN RUN .00 .00 5,400.00 5,400.00 .0 CAR SHOW 24-0430-00-00 MARKETING/ADVERTISING .00 60.00 100.00 40.00 60.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 RECREATION - EAGLE FUN DAYS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:32PM PAGE: 52 24-0430-01-00 DASH PLAQUES .00 .00 300.00 300.00 .0 24-0430-02-00 TROPHIES .00 .00 1,500.00 1,500.00 .0 24-0430-03-00 SUPPLIES .00 .00 300.00 300.00 .0 24-0430-04-00 PARKING .00 .00 500.00 500.00 .0 24-0430-05-00 MISCELLANEOUS .00 .00 150.00 150.00 .0 24-0430-06-00 RAFFLE .00 .00 500.00 500.00 .0 24-0430-08-00 COMMUNITY GROUP .00 .00 500.00 500.00 .0 TOTAL CAR SHOW .00 60.00 3,850.00 3,790.00 1.6 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 TOTAL FUND EXPENDITURES 6,250.00 6,310.00 144,850.00 138,540.00 4.4 NET REVENUE OVER EXPENDITURES ( 4,650.00)( 4,710.00).00 4,710.00 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 PATHWAY IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:32PM PAGE: 53 ASSETS 25-0101-00-00 CASH 18,047.50 25-0151-25-00 INVESTMENTS 90,034.98 TOTAL ASSETS 108,082.48 LIABILITIES AND EQUITY FUND EQUITY 25-0271-00-00 FUND BALANCE 855,025.89 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 746,943.41) BALANCE - CURRENT DATE ( 746,943.41) TOTAL FUND EQUITY 108,082.48 TOTAL LIABILITIES AND EQUITY 108,082.48 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 PATHWAY IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:33PM PAGE: 54 REVENUE 25-0322-19-00 DEVELOPMENT IMPACT FEE 10,576.00 23,465.50 115,675.00 92,209.50 20.3 25-0371-25-00 BANK INTEREST 310.98 830.59 1,100.00 269.41 75.5 25-0399-00-00 CARRY OVER .00 .00 852,000.00 852,000.00 .0 TOTAL FUND REVENUE 10,886.98 24,296.09 968,775.00 944,478.91 2.5 EXPENDITURES CAPITAL IMPROVEMENTS 25-0438-00-00 CAPITAL IMPROVEMENTS 748,230.50 771,239.50 968,775.00 197,535.50 79.6 TOTAL CAPITAL IMPROVEMENTS 748,230.50 771,239.50 968,775.00 197,535.50 79.6 TOTAL FUND EXPENDITURES 748,230.50 771,239.50 968,775.00 197,535.50 79.6 NET REVENUE OVER EXPENDITURES ( 737,343.52)( 746,943.41).00 746,943.41 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:33PM PAGE: 55 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 6 MONTHS ENDING MARCH 31, 2023 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:33PM PAGE: 56 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 MARCH 31, 2023 LAW ENF DEV IMPACT FEES FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:33PM PAGE: 57 ASSETS 27-0101-00-00 CASH 29,839.76 27-0151-25-00 INVESTMENTS 65,199.69 TOTAL ASSETS 95,039.45 LIABILITIES AND EQUITY FUND EQUITY 27-0271-00-00 POLICE IMPACT FEE/FUND BALANCE 79,160.32 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 15,879.13 BALANCE - CURRENT DATE 15,879.13 TOTAL FUND EQUITY 95,039.45 TOTAL LIABILITIES AND EQUITY 95,039.45 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 LAW ENF DEV IMPACT FEES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:33PM PAGE: 58 REVENUE 27-0322-19-00 RESIDENTIAL IMPACT FEES 4,631.84 15,749.24 38,850.00 23,100.76 40.5 27-0322-20-00 COMMERCIAL - IMPACT FEES .00 .00 30,000.00 30,000.00 .0 27-0371-25-00 BANK INTEREST 64.97 129.89 20.00 ( 109.89)649.5 27-0399-00-00 CARRY OVER .00 .00 81,000.00 81,000.00 .0 TOTAL FUND REVENUE 4,696.81 15,879.13 149,870.00 133,990.87 10.6 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 4,696.81 15,879.13 .00 ( 15,879.13).0 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 CITY HALL BOND FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:34PM PAGE: 59 REVENUE 54-0399-01-00 FUNDING FROM GENERAL FUND 9,173.20 9,173.20 104,000.00 94,826.80 8.8 TOTAL FUND REVENUE 9,173.20 9,173.20 104,000.00 94,826.80 8.8 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 9,173.20 9,173.20 18,500.00 9,326.80 49.6 54-0480-84-00 PAYING AGENT FEE .00 .00 500.00 500.00 .0 TOTAL BOND PAYMENTS 9,173.20 9,173.20 104,000.00 94,826.80 8.8 TOTAL FUND EXPENDITURES 9,173.20 9,173.20 104,000.00 94,826.80 8.8 NET REVENUE OVER EXPENDITURES .00 .00 .00 .00 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 WATER FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:34PM PAGE: 60 ASSETS 60-0101-00-00 CASH 541,253.78 60-0115-00-00 ACCOUNTS RECEIVABLE 135,132.01 60-0151-01-00 INVESTMENTS, DEQ LOAN PMTS 656,591.01 60-0151-02-00 INVESTMENTS, DEQ LOAN RESERVE 182,000.00 60-0151-25-00 INVESTMENTS, WATER SYSTEM 4,468,638.40 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 18,693,942.28 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,369.12 60-0217-08-00 GARNISHMENTS 1,162.50 60-0217-09-00 WORKERS' COMPENSATION 66,636.64 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 99,450.00 60-0231-00-00 DEQ LOAN 749,059.00 TOTAL LIABILITIES 1,252,371.17 FUND EQUITY 60-0271-00-00 WATER/FUND BALANCE 17,552,945.37 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 111,374.26) BALANCE - CURRENT DATE ( 111,374.26) TOTAL FUND EQUITY 17,441,571.11 TOTAL LIABILITIES AND EQUITY 18,693,942.28 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:34PM PAGE: 61 REVENUE 60-0346-59-00 STL-STORAGE & TRUNK LINE FEE 2,100.00 2,100.00 105,000.00 102,900.00 2.0 60-0346-60-00 HOOK UP FEES CITY 17,450.00 27,950.00 167,250.00 139,300.00 16.7 60-0346-62-00 PROFESSIONAL SERV - DEVELOPERS 20,856.76 27,270.51 .00 ( 27,270.51).0 60-0346-63-00 STAFF TIME REIMB - DEVELOPERS 690.00 690.00 .00 ( 690.00).0 60-0347-01-00 BILLING REVENUE 324,628.32 638,143.28 1,227,000.00 588,856.72 52.0 60-0347-02-00 OTHER REVENUE 1,010.00 2,060.00 8,400.00 6,340.00 24.5 60-0347-03-00 RECONNECT FEES 41.22 66.22 600.00 533.78 11.0 60-0347-04-00 DELINQUENT FEES 2,776.25 5,989.25 10,500.00 4,510.75 57.0 60-0347-05-00 MISCELLANEOUS REVENUE 2,020.28 3,352.51 10,000.00 6,647.49 33.5 60-0347-06-00 SYSTEM ENHANCEMENT FEE 116,752.28 233,611.86 450,000.00 216,388.14 51.9 60-0355-01-00 WCE-WATER CONST EQUIV FEE 3,600.00 5,200.00 40,000.00 34,800.00 13.0 60-0371-10-00 INVESTMENTS, DEQ, TRANSFERS .00 .00 350,000.00 350,000.00 .0 60-0371-25-00 BANK INTEREST 2,895.85 6,125.28 7,500.00 1,374.72 81.7 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 494,820.96 952,558.91 4,410,108.00 3,457,549.09 21.6 EXPENDITURES VEHICLE OPERATIONS - LEASES 60-0420-01-00 GAS AND OIL 3,990.38 5,807.85 15,000.00 9,192.15 38.7 60-0420-03-00 VEHICLE MTNC & REPAIR 69.74 144.74 10,000.00 9,855.26 1.5 TOTAL VEHICLE OPERATIONS - LEASES 4,060.12 5,952.59 25,000.00 19,047.41 23.8 PERSONNEL 60-0433-10-00 SALARIES - FULL TIME 77,927.80 169,031.14 352,800.00 183,768.86 47.9 60-0433-10-02 ON-CALL TIME 319.68 1,132.84 7,500.00 6,367.16 15.1 60-0433-11-00 OVERTIME 168.42 485.58 4,500.00 4,014.42 10.8 60-0433-21-00 FICA 5,855.17 12,932.08 27,200.00 14,267.92 47.5 60-0433-22-00 PERSI 9,362.93 20,636.71 42,300.00 21,663.29 48.8 60-0433-23-00 HRA BUY-DOWN 778.67 1,097.16 7,700.00 6,602.84 14.3 60-0433-23-01 HRA/COBRA ADMIN FEES .00 .00 800.00 800.00 .0 60-0433-24-00 WORKERS' COMPENSATION 3,707.79 12,811.84 16,000.00 3,188.16 80.1 60-0433-25-00 INSURANCE 11,642.03 22,764.83 51,100.00 28,335.17 44.6 60-0433-26-00 HSA CONTRIBUTIONS 600.00 1,200.00 2,400.00 1,200.00 50.0 60-0433-29-00 PTO CASH OUT .00 2,185.93 10,000.00 7,814.07 21.9 TOTAL PERSONNEL 110,362.49 244,278.11 522,300.00 278,021.89 46.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:34PM PAGE: 62 OPERATIONS & MAINTENANCE 60-0434-15-00 OFFICE SUPPLIES 450.50 513.98 2,000.00 1,486.02 25.7 60-0434-19-00 TELECOMMUNICATIONS/SCADA 3,071.47 8,007.57 17,000.00 8,992.43 47.1 60-0434-20-00 ADVERTISING - PUBLICATIONS .00 .00 1,500.00 1,500.00 .0 60-0434-22-00 TRAVEL-MTNGS-EDUCATION 789.59 1,196.93 8,000.00 6,803.07 15.0 60-0434-23-00 DUES & SUBSCRIPTIONS 120.00 294.00 3,000.00 2,706.00 9.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 1,408.36 1,869.99 20,000.00 18,130.01 9.4 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 13,659.79 19,008.54 35,000.00 15,991.46 54.3 60-0434-42-01 LEGAL SERVICES .00 .00 25,000.00 25,000.00 .0 60-0434-42-02 MISC LEGAL AND ENG SERVICES 7,199.19 7,199.19 100,000.00 92,800.81 7.2 60-0434-42-03 PROFESSIONAL SERV - DEVELOPERS 19,564.13 24,797.26 .00 ( 24,797.26).0 60-0434-43-01 CONTRACT SERVICES (REPAIR).00 .00 35,000.00 35,000.00 .0 60-0434-44-00 DIG LINE 480.59 759.22 4,500.00 3,740.78 16.9 60-0434-45-00 CITY AUDITOR SERVICES 3,500.00 3,500.00 2,500.00 ( 1,000.00)140.0 60-0434-47-00 MAIL SERVICE-CUSTOMER BILLING 6,768.70 11,220.59 31,500.00 20,279.41 35.6 60-0434-50-00 SHOP LEASE .00 2,974.98 15,500.00 12,525.02 19.2 60-0434-50-01 SHOP UTILITIES 894.30 1,201.54 5,100.00 3,898.46 23.6 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 .00 .00 5,000.00 5,000.00 .0 60-0434-58-00 RPR/MTNC-LINES-METERS-ETC 1,506.94 1,932.53 40,000.00 38,067.47 4.8 60-0434-58-01 RPR/MTNC PUMPS-WELLS-CHEMICAL 5,956.19 6,978.39 50,000.00 43,021.61 14.0 60-0434-59-00 CHEMICALS 319.23 1,318.15 9,000.00 7,681.85 14.7 60-0434-60-00 UTILITIES 12,882.50 27,961.88 55,000.00 27,038.12 50.8 60-0434-68-00 UNIFORMS AND SAFETY CLOTHING .00 734.90 2,300.00 1,565.10 32.0 60-0434-83-00 MAPPING PROFESSIONAL SERVICES 832.50 832.50 25,000.00 24,167.50 3.3 TOTAL OPERATIONS & MAINTENANCE 79,403.98 145,581.84 521,320.00 375,738.16 27.9 TESTING-WK-MO-QTR-ANNUAL 60-0435-56-00 TESTING-WK-MO-QTR-ANNUAL 920.00 1,300.00 19,000.00 17,700.00 6.8 TOTAL TESTING-WK-MO-QTR-ANNUAL 920.00 1,300.00 19,000.00 17,700.00 6.8 DEQ REVOLVING LOAN PAYMENT 60-0436-01-00 DEQ/STATE REVOLVING LOAN PMT 350,000.00 650,000.00 800,000.00 150,000.00 81.3 TOTAL DEQ REVOLVING LOAN PAYMENT 350,000.00 650,000.00 800,000.00 150,000.00 81.3 RESTRICTED 60-0437-01-00 STL FEES, WATER SYS EXPANSION 2,291.25 3,930.00 100,000.00 96,070.00 3.9 60-0437-03-00 STL FEES, REFUNDS .00 .00 50,000.00 50,000.00 .0 60-0437-99-01 RESERVES, STL FEES .00 .00 409,378.00 409,378.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:35PM PAGE: 63 TOTAL RESTRICTED 2,291.25 3,930.00 559,378.00 555,448.00 .7 CAPITAL EXPENDITURES 60-0438-01-00 EQUIPMENT 7,660.00 7,660.00 75,500.00 67,840.00 10.2 60-0438-05-01 CURRENT STL PROJECTS .00 ( 1,000.00)430,000.00 431,000.00 ( .2) 60-0438-08-00 METER SETS, NEW CUSTOMERS .00 .00 99,200.00 99,200.00 .0 60-0438-10-00 WATER MASTER PLAN-UPDATE .00 .00 18,000.00 18,000.00 .0 60-0438-11-00 CAPITAL CONSTRUCTION PROJECTS 2,878.13 2,878.13 145,000.00 142,121.87 2.0 60-0438-82-00 CITY HALL ADMIN OVERHEAD .00 3,352.50 13,410.00 10,057.50 25.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 10,538.13 12,890.63 1,963,110.00 1,950,219.37 .7 TOTAL FUND EXPENDITURES 557,575.97 1,063,933.17 4,410,108.00 3,346,174.83 24.1 NET REVENUE OVER EXPENDITURES ( 62,755.01)( 111,374.26).00 111,374.26 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2023 FIBER FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:35PM PAGE: 64 ASSETS 61-0101-00-00 CASH 34,518.81 61-0151-25-00 INVESTMENTS, FIBER SYSTEM 2,153,802.92 61-0166-00-00 MACHINERY AND EQUIPMENT 1,693,285.00 TOTAL ASSETS 3,881,606.73 LIABILITIES AND EQUITY LIABILITIES 61-0217-07-00 INSURANCE ( 1,384.60) 61-0217-09-00 WORKERS' COMPENSATION 596.15 TOTAL LIABILITIES ( 788.45) FUND EQUITY 61-0271-00-00 FUND BALANCE 4,083,934.30 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 201,539.12) BALANCE - CURRENT DATE ( 201,539.12) TOTAL FUND EQUITY 3,882,395.18 TOTAL LIABILITIES AND EQUITY 3,881,606.73 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2023 FIBER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:35PM PAGE: 65 REVENUE 61-0347-90-00 BANK INTEREST 855.34 3,133.62 .00 ( 3,133.62).0 61-0398-00-00 ARPA CARRY OVER .00 .00 2,389,980.00 2,389,980.00 .0 TOTAL FUND REVENUE 855.34 3,133.62 2,389,980.00 2,386,846.38 .1 EXPENDITURES PERSONNEL 61-0433-10-00 SALARIES - FULL TIME 15,846.00 15,846.00 183,400.00 167,554.00 8.6 61-0433-10-02 ON-CALL TIME .00 .00 2,500.00 2,500.00 .0 61-0433-11-00 OVERTIME 662.63 662.63 2,500.00 1,837.37 26.5 61-0433-21-00 FICA 1,262.90 1,262.90 14,500.00 13,237.10 8.7 61-0433-22-00 PERSI 1,971.13 1,971.13 25,500.00 23,528.87 7.7 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 596.15 596.15 8,000.00 7,403.85 7.5 61-0433-25-00 INSURANCE 514.20 514.20 26,000.00 25,485.80 2.0 61-0433-26-00 HSA CONTRIBUTIONS .00 .00 1,200.00 1,200.00 .0 TOTAL PERSONNEL 20,853.01 20,853.01 266,980.00 246,126.99 7.8 OPERATIONS & MAINTENANCE 61-0434-15-00 OFFICE SUPPLIES .00 .00 500.00 500.00 .0 61-0434-19-00 TELECOMMUNICATIONS .00 .00 8,000.00 8,000.00 .0 61-0434-20-00 ADVERTISING - PUBLICATIONS .00 .00 20,000.00 20,000.00 .0 61-0434-22-00 TRAVEL-MTNGS-EDUCATION .00 .00 15,000.00 15,000.00 .0 61-0434-23-00 DUES & SUBSCRIPTIONS .00 .00 500.00 500.00 .0 61-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE 108.44 108.44 5,000.00 4,891.56 2.2 61-0434-26-00 TOOLS, EQUIPMENT AND SUPPLIES 4,215.68 8,995.68 5,000.00 ( 3,995.68)179.9 61-0434-26-01 EQUIPMENT RENTAL .00 .00 25,000.00 25,000.00 .0 61-0434-27-00 POSTAGE .00 .00 1,000.00 1,000.00 .0 61-0434-41-00 LIABILITY INSURANCE 3,000.00 3,000.00 7,500.00 4,500.00 40.0 61-0434-42-00 ENGINEERING SERVICES .00 .00 290,000.00 290,000.00 .0 61-0434-42-01 LEGAL SERVICES 280.00 280.00 15,000.00 14,720.00 1.9 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 500.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 SHOP LEASE .00 .00 15,000.00 15,000.00 .0 61-0434-50-01 SHOP UTILITIES 150.94 150.94 5,000.00 4,849.06 3.0 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 575.15 575.15 7,500.00 6,924.85 7.7 61-0434-57-00 REPAIR AND MAINT, VEHICLE 10,549.98 10,582.95 1,000.00 ( 9,582.95)1058.3 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 6 MONTHS ENDING MARCH 31, 2023 FIBER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/11/2023 03:35PM PAGE: 66 61-0434-58-01 REPAIR AND MAINT, EQUIPMENT 15,557.81 28,462.52 50,000.00 21,537.48 56.9 61-0434-59-00 REPAIR AND MAINT, EMERGENCIES .00 .00 100,000.00 100,000.00 .0 61-0434-59-01 MATERIALS 53,994.39 53,994.39 250,000.00 196,005.61 21.6 61-0434-60-00 UTILITIES 233.93 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 89,166.32 107,016.00 1,028,000.00 920,984.00 10.4 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 17,056.43 17,056.43 570,000.00 552,943.57 3.0 61-0438-10-00 MASTER PLAN DEVELOPMENT .00 .00 10,000.00 10,000.00 .0 61-0438-11-00 CAPITAL CONSTRUCTION PROJECTS 57,134.00 57,134.00 500,000.00 442,866.00 11.4 TOTAL CAPITAL EXPENDITURES 74,190.43 76,803.73 1,095,000.00 1,018,196.27 7.0 TOTAL FUND EXPENDITURES 184,209.76 204,672.74 2,389,980.00 2,185,307.26 8.6 NET REVENUE OVER EXPENDITURES ( 183,354.42)( 201,539.12).00 201,539.12 .0