Loading...
Finance - Quarterly Reports - FY 21/22 2nd Quarter - 03/31/2022CITY OF EAGLEQUARTERLY TREASURER'S REPORT FOR THE 6 MONTHS ENDING MARCH 31, 2022 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/12/2022 03:48PM PAGE: 1 01 GENERAL FUND 640,585.60 7,855,347.62 45.33 4,488,927.23 25.91 2,557,308.35 1,449,697.64 06 LIBRARY FUND ( 43,479.61)993,844.75 47.97 560,146.03 27.04 375,575.95 14,643.16 07 MUSEUM FUND 46,900.01 14,177.28 9.04 60,644.27 38.66 433.02 .00 08 PARK IMPACT FEE FUND 212,713.17 185,158.87 3.25 52,671.72 .92 276,009.68 69,190.64 09 RECREATION - SPECIAL EVENTS 152,178.59 8,447.04 3.16 66,291.63 24.77 ( 2,601.11)96,935.11 10 EAGLE HISTORICAL COMMISSION 19,283.33 1,733.52 19.26 .00 .00 .00 21,016.85 11 EXECUTIVE DEPARTMENT .00 136,759.81 34.19 140,886.46 35.22 ( 4,126.65).00 12 CITY CLERK/TREAS DEPARTMENT .00 275,384.83 43.95 275,221.42 43.93 163.41 .00 13 BUILDING DEPARTMENT .00 506,543.84 43.80 470,415.69 40.68 36,128.15 .00 14 P&Z DEPARTMENT .00 460,101.26 37.90 456,541.00 37.60 3,560.26 .00 17 RECREATION - PARKS AND REC 168,969.85 79,220.66 11.95 195,648.74 29.52 9,166.44 43,375.33 18 IT DEPARTMENT .00 340,850.24 38.13 316,974.62 35.46 23,875.62 .00 19 CAPITAL PROJECTS FUND 3,038,014.38 90,989.13 .43 3,029,879.49 14.46 ( 656,057.21)755,181.23 21 ARTS COMMISSION 24,558.04 156.00 .20 6,863.30 8.87 .00 17,850.74 23 PUBLIC WORKS .00 2,918.10 .12 632,101.25 26.47 ( 629,183.15).00 24 RECREATION - EAGLE FUN DAYS ( 23,706.58)23,706.58 16.29 .00 .00 .00 .00 25 PATHWAY IMPACT FEE FUND 102,694.44 54,546.82 6.05 483.00 .05 131,961.26 24,797.00 26 ECONOMIC DEVELOPMENT .00 97,034.51 45.76 96,611.68 45.56 422.83 .00 27 LAW ENF DEV IMPACT FEES 8,614.24 23,490.30 16.58 .00 .00 16,116.46 15,988.08 54 CITY HALL BOND FUND 3,405.22 7,843.95 7.62 11,249.17 10.93 .00 .00 60 WATER FUND 945,182.58 1,755,711.19 49.22 850,439.85 23.84 1,283,942.59 566,511.33 99 COMBINED CASH FUND ( 5,295,913.26).00 .00 .00 .00 ( 2,220,726.15) ( 3,075,187.11) TOTAL .00 12,913,966.30 11,711,996.55 1,201,969.75 .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 13, 2022 CITY OF EAGLE COMBINED CASH INVESTMENT MARCH 31, 2022 FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 1 COMBINED CASH ACCOUNTS 99-0103-00-00 CASH IN CHECKING 2,924,513.34 99-0108-00-00 CASH CLEARING-ACCOUNTS REC 150,673.77 TOTAL COMBINED CASH 3,075,187.11 99-0101-00-00 CASH ALLOCATED TO OTHER FUNDS ( 3,075,187.11) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 1,449,697.64 6 ALLOCATION TO LIBRARY FUND 14,643.16 8 ALLOCATION TO PARK IMPACT FEE FUND 69,190.64 9 ALLOCATION TO RECREATION - SPECIAL EVENTS 96,935.11 10 ALLOCATION TO EAGLE HISTORICAL COMMISSION 21,016.85 17 ALLOCATION TO RECREATION - PARKS AND REC 43,375.33 19 ALLOCATION TO CAPITAL PROJECTS FUND 755,181.23 21 ALLOCATION TO ARTS COMMISSION 17,850.74 25 ALLOCATION TO PATHWAY IMPACT FEE FUND 24,797.00 27 ALLOCATION TO LAW ENF DEV IMPACT FEES 15,988.08 60 ALLOCATION TO WATER FUND 566,511.33 TOTAL ALLOCATIONS TO OTHER FUNDS 3,075,187.11 ALLOCATION FROM COMBINED CASH FUND - 99-0101-00-00 ( 3,075,187.11) ZERO PROOF IF ALLOCATIONS BALANCE .00 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 GENERAL FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 2 ASSETS 01-0101-00-00 CASH 1,449,697.64 01-0103-00-00 PETTY CASH 100.00 01-0107-00-00 TAXES RECEIVABLE DELINQUENT 14,402.55 01-0132-00-00 DUE FROM OTHER GOVERNMNTL UNTS 863,581.36 01-0151-25-00 FIRST INTERSTATE INVESTMENT 7,702,111.04 01-0151-28-00 ICCU CD 50,972.47 01-0170-00-00 HRA 10 % DEPOSIT 5,785.92 TOTAL ASSETS 10,086,650.98 LIABILITIES AND EQUITY LIABILITIES 01-0202-00-00 VOUCHERS PAYABLE ( 3,542.16) 01-0203-00-00 ACCTS PAYABLE-ACHD IMPACT FEES 69,066.00 01-0203-01-01 BONDS DEPOSITS PAYABLE 2,556,607.28 01-0203-01-02 FIREWORKS BOND DEPOSIT PAYABLE ( 2,000.00) 01-0203-01-03 VENDORS BOND DEPOSITS PAYABLE 6,939.00 01-0203-01-05 P&Z DEPOSITS PAYABLE 205,624.00 01-0203-01-06 LAND USE DEPOSITS PAYABLE 50,972.47 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 ( 1,415.27) 01-0217-09-00 WORKERS' COMPENSATION 1,501.37 01-0226-00-00 DEFERRED REVENUE 12,637.20 TOTAL LIABILITIES 2,885,610.74 FUND EQUITY 01-0271-00-00 FUND BALANCE 3,834,619.85 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 3,366,420.39 BALANCE - CURRENT DATE 3,366,420.39 TOTAL FUND EQUITY 7,201,040.24 TOTAL LIABILITIES AND EQUITY 10,086,650.98 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 3 REVENUE 01-0308-00-00 CARRY OVER .00 .00 5,560,218.00 5,560,218.00 .0 01-0311-00-00 PROPERTY TAX 1,746,328.51 1,746,328.51 2,708,042.00 961,713.49 64.5 01-0311-01-00 PENALTY/INTEREST ON TAXES 1,368.70 1,368.70 3,000.00 1,631.30 45.6 01-0312-00-00 PERSONAL PROPERTY TAX REIMBURS 4,231.43 4,231.43 8,463.00 4,231.57 50.0 01-0316-10-00 FRANCHISE FEE/EAGLE WATER CO.2,365.15 2,365.15 5,000.00 2,634.85 47.3 01-0316-10-02 FRANCHISE FEE/SUEZ 9,344.81 9,344.81 15,000.00 5,655.19 62.3 01-0316-11-00 FRANCHISE FEE/INTERMTN GAS 98,173.78 98,173.78 270,000.00 171,826.22 36.4 01-0316-12-00 FRANCHISE FEE/CABLE TV 56,296.45 56,296.45 112,000.00 55,703.55 50.3 01-0316-13-00 FRANCHISE FEE/TRASH 179,171.20 179,171.20 275,000.00 95,828.80 65.2 01-0316-14-00 FRANCHISE FEE/IDAHO POWER 135,273.77 135,273.77 212,000.00 76,726.23 63.8 01-0321-10-00 ALCOHOLIC BEVERAGE LICENSES 1,541.22 1,541.22 30,000.00 28,458.78 5.1 01-0321-30-00 BUSINESS LICENSE FEE 2,060.00 2,060.00 16,500.00 14,440.00 12.5 01-0322-10-00 BUILDING & INSPECTION PERMITS 682,660.92 682,660.92 1,770,000.00 1,087,339.08 38.6 01-0322-12-00 PLAN REVIEW FEES 262,766.03 262,766.03 525,000.00 262,233.97 50.1 01-0322-13-00 ENERGY STANDARDS (IRES)9,150.00 9,150.00 30,000.00 20,850.00 30.5 01-0322-14-00 ELECTRICAL INSPECT FEE 142,655.52 142,655.52 252,000.00 109,344.48 56.6 01-0322-15-00 PLUMBING INSPECTION FEES 102,849.32 102,849.32 252,000.00 149,150.68 40.8 01-0322-16-00 MECHANICAL INSPECTION FEES 154,861.60 154,861.60 252,000.00 97,138.40 61.5 01-0322-20-00 FIRE IMPACT ADMIN FEES 4,530.00 4,530.00 12,000.00 7,470.00 37.8 01-0323-01-00 PZ ANNEX/ZONING PERMIT FEES 254,562.90 254,562.90 210,000.00 ( 44,562.90)121.2 01-0323-02-00 INSPECTION FEES 665.00 665.00 8,000.00 7,335.00 8.3 01-0323-03-00 PLAN REVIEW FEES 12,100.00 12,100.00 40,000.00 27,900.00 30.3 01-0323-04-00 STREET LIGHT INSPECTION FEES 910.00 910.00 1,200.00 290.00 75.8 01-0323-05-00 SURETY/LETTER OF CREDIT FEES 3,980.00 3,980.00 4,000.00 20.00 99.5 01-0323-06-00 GRADING-DRAINAGE PERMIT FEES 4,767.50 4,767.50 16,000.00 11,232.50 29.8 01-0323-10-00 SPRING VALLEY STAFF TIME REIMB .00 .00 10,000.00 10,000.00 .0 01-0323-11-00 AVIMOR STAFF TIME REIMBURSE .00 .00 85,000.00 85,000.00 .0 01-0324-01-00 TREE FUND 5,950.00 5,950.00 .00 ( 5,950.00).0 01-0331-61-00 MATCHING GRANT .00 .00 100,000.00 100,000.00 .0 01-0331-63-00 GRANTS/MATCHING FUNDS .00 .00 50,000.00 50,000.00 .0 01-0335-10-00 STATE LIQUOR 265,036.00 265,036.00 678,514.00 413,478.00 39.1 01-0335-50-00 STATE SALES TAX, AG REPL 14.25 14.25 .00 ( 14.25).0 01-0335-60-00 STATE REVENUE SHARING 1,566,386.92 1,566,386.92 3,019,563.00 1,453,176.08 51.9 01-0338-40-00 COURT FEES 21,045.35 21,045.35 30,000.00 8,954.65 70.2 01-0338-41-00 CITATION FEES/CODE ENFORCEMENT 15.00 15.00 500.00 485.00 3.0 01-0338-42-00 WEED ABATEMENT .00 .00 2,000.00 2,000.00 .0 01-0341-11-00 MISCELLANEOUS PERMITS/LICENSES 1,555.00 1,555.00 4,000.00 2,445.00 38.9 01-0341-12-00 ANIMAL CONTROL FEES 7,552.00 7,552.00 12,000.00 4,448.00 62.9 01-0341-13-00 ENGINEERING FEES-DEVELOPERS 127,613.75 127,613.75 150,000.00 22,386.25 85.1 01-0341-14-00 ATTORNEY FEES - DEVELOPER .00 .00 15,000.00 15,000.00 .0 01-0341-17-00 CID STAFF & MISC REIMBURSEMENT 4,202.15 4,202.15 1,000.00 ( 3,202.15)420.2 01-0341-20-00 REIMBURSE WATER DEPARTMENT 9,603.00 9,603.00 12,803.00 3,200.00 75.0 01-0341-21-00 PRESSURIZED IRRIGATION REIMB 10,561.82 10,561.82 .00 ( 10,561.82).0 01-0341-26-00 BACKGROUND CHECKS 422.50 422.50 1,500.00 1,077.50 28.2 01-0341-27-00 URA CITY STAFF REIMBURSEMENT 1,993.13 1,993.13 4,800.00 2,806.87 41.5 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-05-00 FIELD OF HONOR 610.00 610.00 10,000.00 9,390.00 6.1 01-0350-07-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 01-0371-25-00 BANK INVESTMENT INTEREST 5,449.29 5,449.29 7,000.00 1,550.71 77.9 01-0379-00-00 MISCELLANEOUS 50.03 50.03 1,000.00 949.97 5.0 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 4 01-0379-01-00 DUPLICATION/PUBLISHING/PRINTNG 402.78 402.78 500.00 97.22 80.6 01-0382-02-00 PROMOTIONAL SALES 510.00 510.00 .00 ( 510.00).0 01-0383-05-00 MISCELLANEOUS-REIMBURSEABLES 4,990.12 4,990.12 1,500.00 ( 3,490.12)332.7 01-0383-09-00 ROOM RESERVATIONS 394.00 394.00 600.00 206.00 65.7 01-0383-14-00 SETTLEMENTS 1,750,000.00 1,750,000.00 .00 ( 1,750,000.00).0 01-0383-15-00 MISCELLANEOUS REVENUE 2,610.00 2,610.00 .00 ( 2,610.00).0 01-0385-00-00 FIRE DEPT IMPACT FEES 194,766.72 194,766.72 538,200.00 343,433.28 36.2 TOTAL FUND REVENUE 7,855,347.62 7,855,347.62 17,328,023.00 9,472,675.38 45.3 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 5 RESERVE 01-0410-19-00 RESERVE, EMERGENCIES .00 .00 480,673.00 480,673.00 .0 TOTAL RESERVE .00 .00 480,673.00 480,673.00 .0 ADMINISTRATION 01-0413-01-00 P&Z COMMISSIONERS COMPENSATION 1,510.00 1,510.00 4,200.00 2,690.00 36.0 01-0413-02-00 DESIGN REVIEW BRD COMPENSATION 1,910.00 1,910.00 5,000.00 3,090.00 38.2 01-0413-05-00 OFFICE EXPENSES 9,467.80 9,467.80 25,000.00 15,532.20 37.9 01-0413-06-00 PRINTING & DISTRIBUTION 19.50 19.50 2,500.00 2,480.50 .8 01-0413-07-00 POSTAGE 4,706.15 4,706.15 9,000.00 4,293.85 52.3 01-0413-08-00 LEGAL ADVERTISING/PUBLICATION 1,907.95 1,907.95 8,000.00 6,092.05 23.9 01-0413-10-00 INSURANCE - PROPERTY 51,438.00 51,438.00 57,000.00 5,562.00 90.2 01-0413-12-00 PERSONNEL TRAINING 265.00 265.00 3,000.00 2,735.00 8.8 01-0413-13-00 TRAVEL & PER DIEM .00 .00 2,000.00 2,000.00 .0 01-0413-14-00 PROFESSIONAL DUES AND SERVICES 56,965.10 56,965.10 163,827.00 106,861.90 34.8 01-0413-25-00 MISCELLANEOUS 173.78 173.78 40,000.00 39,826.22 .4 01-0413-28-00 RESOURCE MATERIALS 3,502.54 3,502.54 4,500.00 997.46 77.8 01-0413-29-00 REAL PROPERTY TAXES/CITY 231.58 231.58 225.00 ( 6.58)102.9 01-0413-31-00 ENGINEERING FEE/DEVELOPER CHGS 181,955.66 181,955.66 150,000.00 ( 31,955.66)121.3 01-0413-33-00 ATTORNEY FEE-CHARGE DEVELOPERS 15,779.50 15,779.50 15,000.00 ( 779.50)105.2 01-0413-37-00 BACKGROUND CHECK-PERMITS/LIC 1,166.88 1,166.88 1,250.00 83.12 93.4 01-0413-40-00 INSURANCE REIMBURSEABLES 397.70 397.70 .00 ( 397.70).0 01-0413-44-00 PHOTOS - MAYOR/CITY COUNCIL 172.33 172.33 900.00 727.67 19.2 01-0413-46-00 PROPERTY TAX EXP -3%.00 .00 250.00 250.00 .0 01-0413-50-00 JOB POSTINGS 2,806.50 2,806.50 6,000.00 3,193.50 46.8 01-0413-51-00 BACKGROUND CHK, PRE-EMPLOYMENT 226.49 226.49 1,500.00 1,273.51 15.1 01-0413-52-00 DRUG TESTING, PRE-EMPLOYMENT 416.00 416.00 1,500.00 1,084.00 27.7 TOTAL ADMINISTRATION 335,018.46 335,018.46 500,652.00 165,633.54 66.9 PERSONNEL 01-0415-11-00 SALARIES-COUNCIL 25,440.00 25,440.00 50,880.00 25,440.00 50.0 01-0415-21-00 FICA 1,946.16 1,946.16 4,500.00 2,553.84 43.3 01-0415-22-00 PERSI 3,037.44 3,037.44 6,200.00 3,162.56 49.0 01-0415-23-01 HRA/COBRA ADMIN FEES 365.15 365.15 1,800.00 1,434.85 20.3 01-0415-24-00 WORKERS' COMPENSATION 38,109.87 38,109.87 54,374.00 16,264.13 70.1 01-0415-24-01 WORK COMP/BOARDS-COMMISSIONS 69.76 69.76 100.00 30.24 69.8 01-0415-25-00 INSURANCE .00 .00 12,000.00 12,000.00 .0 01-0415-28-00 UNEMPLOYMENT BENEFITS 1,912.40 1,912.40 .00 ( 1,912.40).0 TOTAL PERSONNEL 70,880.78 70,880.78 129,854.00 58,973.22 54.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 6 CONTRACTS & AGREEMENTS 01-0416-02-00 CITY ATTORNEY 54,499.50 54,499.50 250,000.00 195,500.50 21.8 01-0416-02-02 LITIGATION ATTORNEYS FEES 3,647.00 3,647.00 50,000.00 46,353.00 7.3 01-0416-05-00 PROSECUTOR 32,002.00 32,002.00 65,500.00 33,498.00 48.9 01-0416-06-00 IDAHO HUMANE SOCIETY 72,287.50 72,287.50 144,575.00 72,287.50 50.0 01-0416-07-00 CITY ENGINEERING .00 .00 50,000.00 50,000.00 .0 01-0416-07-04 PARK/REC ENGINEERING FEES .00 .00 20,000.00 20,000.00 .0 01-0416-08-00 CITY AUDITOR SERVICES 17,250.00 17,250.00 21,000.00 3,750.00 82.1 01-0416-09-00 LAW ENFORCEMENT DEPARTMENT 1,786,339.12 1,786,339.12 3,572,672.00 1,786,332.88 50.0 01-0416-23-00 GRANT WRITER .00 .00 15,000.00 15,000.00 .0 01-0416-34-00 BUDGET RESERVE, FY 1ST QTR .00 .00 1,500,000.00 1,500,000.00 .0 01-0416-35-00 ADMINISTRATIVE RESERVE 12,210.50 12,210.50 200,000.00 187,789.50 6.1 01-0416-46-00 ALLUMBAUGH HOUSE 8,874.50 8,874.50 17,749.00 8,874.50 50.0 01-0416-49-00 DRUGFREE IDAHO 754.51 754.51 1,090.00 335.49 69.2 01-0416-54-00 IDAHO SUICIDE PREVENTION 10,000.00 10,000.00 10,000.00 .00 100.0 01-0416-55-00 EAGLE SENIOR CENTER 25,000.00 25,000.00 50,000.00 25,000.00 50.0 01-0416-56-00 CRIME STOPPERS 3,500.00 3,500.00 3,500.00 .00 100.0 TOTAL CONTRACTS & AGREEMENTS 2,026,364.63 2,026,364.63 5,971,086.00 3,944,721.37 33.9 CODE ENFORCEMENT 01-0417-00-00 WEED ABATEMENT .00 .00 2,000.00 2,000.00 .0 TOTAL CODE ENFORCEMENT .00 .00 2,000.00 2,000.00 .0 GRANTS 01-0421-01-00 GRANTS/MATCHING FUNDS .00 .00 100,000.00 100,000.00 .0 01-0421-03-00 MATCHING GRANT .00 .00 50,000.00 50,000.00 .0 TOTAL GRANTS .00 .00 150,000.00 150,000.00 .0 RESTRICTED FUNDS 01-0422-06-00 FIELD OF HONOR 2,065.42 2,065.42 10,000.00 7,934.58 20.7 01-0422-15-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 TOTAL RESTRICTED FUNDS 2,065.42 2,065.42 14,000.00 11,934.58 14.8 CONTINUING EDUCATION 01-0461-01-00 CONTINUING EDUCATION 2,626.00 2,626.00 3,800.00 1,174.00 69.1 TOTAL CONTINUING EDUCATION 2,626.00 2,626.00 3,800.00 1,174.00 69.1 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 7 PUBLIC AFFAIRS/COMM RELATIONS 01-0462-01-00 PUBLIC RELATIONS 2,057.32 2,057.32 6,000.00 3,942.68 34.3 01-0462-02-00 AWARDS & RECOGNITIONS 812.10 812.10 1,500.00 687.90 54.1 01-0462-03-00 CITY BRANDING/LOGO .00 .00 5,000.00 5,000.00 .0 TOTAL PUBLIC AFFAIRS/COMM RELATIONS 2,869.42 2,869.42 12,500.00 9,630.58 23.0 GENERAL FUND TRANSFERS 01-0463-01-00 MUSEUM DEPT TRANSFER 13,185.78 13,185.78 142,185.00 128,999.22 9.3 01-0463-02-00 ARTS COMMISSION TRANSFER .00 .00 44,901.00 44,901.00 .0 01-0463-04-00 HISTORICAL COMMISSION TRANSFER .00 .00 3,118.00 3,118.00 .0 01-0463-05-00 SPECIAL EVENTS TRANSFER .00 .00 221,095.00 221,095.00 .0 01-0463-06-00 RECREATION PARKS-REC TRANSFER .00 .00 443,770.00 443,770.00 .0 01-0463-07-00 CAPITAL PROJECTS TRANSFER .00 .00 1,708,900.00 1,708,900.00 .0 01-0463-08-00 EAGLE FUN DAYS TRANSFER 23,706.58 23,706.58 90,000.00 66,293.42 26.3 01-0463-11-00 PUBLIC WORKS TRANSFER .00 .00 2,167,755.00 2,167,755.00 .0 01-0463-11-01 EXECUTIVE DEPT TRANSFER 136,759.81 136,759.81 400,030.00 263,270.19 34.2 01-0463-12-00 CITY HALL BOND FUND TRANSFER 7,843.95 7,843.95 102,950.00 95,106.05 7.6 01-0463-12-01 CLERK/TREAS DEPT TRANSFER 275,384.83 275,384.83 626,550.00 351,165.17 44.0 01-0463-13-01 BUILDING DEPT TRANSFER 506,543.84 506,543.84 1,156,430.00 649,886.16 43.8 01-0463-14-01 PLANNING AND ZONING DEPT TRANS 460,101.26 460,101.26 1,214,100.00 753,998.74 37.9 01-0463-18-01 IT DEPT TRANSFER 340,850.24 340,850.24 893,820.00 552,969.76 38.1 01-0463-26-01 ECONOMIC DEV DEPT TRANSFER 97,034.51 97,034.51 212,056.00 115,021.49 45.8 TOTAL GENERAL FUND TRANSFERS 1,861,410.80 1,861,410.80 9,427,660.00 7,566,249.20 19.7 COMMUNITY PROJECTS-CAP OUTLAY 01-0468-10-00 VRT HWY 44 EXPRESS SRV ENHANC 2,644.00 2,644.00 87,898.00 85,254.00 3.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 12,344.00 12,344.00 97,598.00 85,254.00 12.7 FIRE DEPARTMENT IMPACT FEES 01-0469-00-00 FIRE DEPT IMPACT FEES 175,347.72 175,347.72 538,200.00 362,852.28 32.6 TOTAL FIRE DEPARTMENT IMPACT FEES 175,347.72 175,347.72 538,200.00 362,852.28 32.6 TOTAL FUND EXPENDITURES 4,488,927.23 4,488,927.23 17,328,023.00 12,839,095.77 25.9 NET REVENUE OVER EXPENDITURES 3,366,420.39 3,366,420.39 .00 ( 3,366,420.39).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 LIBRARY FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 8 ASSETS 06-0101-00-00 CASH 14,643.16 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 8,865.78 06-0151-25-00 FIRST INTERSTATE INVESTMENT 1,298,743.32 06-0170-00-00 HRA 10% DEPOSIT 1,872.00 TOTAL ASSETS 1,324,724.26 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 9,473.50 06-0217-09-00 WORKERS' COMPENSATION 13,453.85 06-0217-10-00 HSA CONTRIBUTION 2,454.00 06-0226-00-00 DEFERRED REVENUE 7,786.25 TOTAL LIABILITIES 58,758.42 FUND EQUITY 06-0271-00-00 LIBRARY/FUND BALANCE 832,267.12 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 433,698.72 BALANCE - CURRENT DATE 433,698.72 TOTAL FUND EQUITY 1,265,965.84 TOTAL LIABILITIES AND EQUITY 1,324,724.26 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 9 REVENUE 06-0356-00-00 LIBRARY/PROPERTY TAX REVENUE 982,779.24 982,779.24 1,492,845.00 510,065.76 65.8 06-0356-01-00 LIBRARY/PENALTY & INT PROP TXS 853.04 853.04 1,000.00 146.96 85.3 06-0361-20-00 LIBRARY/FINES/FEES 1,328.12 1,328.12 .00 ( 1,328.12).0 06-0361-20-01 LOST ITEMS 2,593.06 2,593.06 2,500.00 ( 93.06)103.7 06-0361-21-00 LIBRARY/COPY MACHINE REVENUE 710.90 710.90 3,600.00 2,889.10 19.8 06-0361-21-01 3 D PRINTING 5.24 5.24 400.00 394.76 1.3 06-0371-25-00 BANK INTEREST 827.94 827.94 700.00 ( 127.94)118.3 06-0379-00-00 MISCELLANEOUS 4,747.21 4,747.21 750.00 ( 3,997.21)633.0 06-0390-00-00 CARRY OVER .00 .00 120,040.00 120,040.00 .0 06-0390-01-00 RESERVE FUND .00 .00 450,000.00 450,000.00 .0 TOTAL FUND REVENUE 993,844.75 993,844.75 2,071,835.00 1,077,990.25 48.0 EXPENDITURES RESERVE 06-0410-01-00 RESERVE .00 .00 460,000.00 460,000.00 .0 TOTAL RESERVE .00 .00 460,000.00 460,000.00 .0 CONTRACTS/AGREEMENTS 06-0416-01-00 LEGAL - CITY ATTORNEY .00 .00 10,000.00 10,000.00 .0 06-0416-02-00 PHOTOCOPIERS 2,687.29 2,687.29 14,570.00 11,882.71 18.4 TOTAL CONTRACTS/AGREEMENTS 2,687.29 2,687.29 24,570.00 21,882.71 10.9 OPERATIONS & MAINTENANCE 06-0420-01-00 ADMINISTRATION 14,155.33 14,155.33 15,000.00 844.67 94.4 06-0420-03-00 OPERATIONS SUBSCRIPTIONS 23,062.70 23,062.70 41,310.00 18,247.30 55.8 06-0420-04-00 MARKETING 6,910.19 6,910.19 11,300.00 4,389.81 61.2 06-0420-04-01 OUTREACH 20.51 20.51 2,500.00 2,479.49 .8 06-0420-05-00 OFFICE SUPPLIES 2,496.28 2,496.28 9,373.00 6,876.72 26.6 06-0420-05-01 MATERIAL PROCESSING SUPPLIES 964.09 964.09 8,000.00 7,035.91 12.1 06-0420-06-00 UNIFORMS 1,644.64 1,644.64 3,905.00 2,260.36 42.1 06-0420-07-00 SMALL FURNITURE REPLACEMENT 1,262.91 1,262.91 1,400.00 137.09 90.2 06-0420-09-00 MAINTENANCE AGREEMENTS 335.00 335.00 31,194.00 30,859.00 1.1 06-0420-10-00 POSTAGE 45.36 45.36 2,500.00 2,454.64 1.8 06-0420-11-00 SUBSCRIPTIONS & MEMBERSHIPS 1,382.79 1,382.79 11,000.00 9,617.21 12.6 06-0420-13-00 PRINTING AND PUBLISHING .00 .00 1,500.00 1,500.00 .0 TOTAL OPERATIONS & MAINTENANCE 52,279.80 52,279.80 138,982.00 86,702.20 37.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 10 LYNX1 CONSORTIUM 06-0430-00-00 LYNK! SYSTEM 6,048.02 6,048.02 24,192.00 18,143.98 25.0 06-0430-02-00 LYNX! COURIER 4,875.54 4,875.54 11,600.00 6,724.46 42.0 TOTAL LYNX1 CONSORTIUM 10,923.56 10,923.56 35,792.00 24,868.44 30.5 COST RECOVERY OR PASS THRU 06-0435-00-00 CREDIT CARD PROCESSING FEE 1,429.90 1,429.90 2,700.00 1,270.10 53.0 06-0435-01-00 3D PRINTING .00 .00 2,600.00 2,600.00 .0 06-0435-02-00 LOST ITEMS REFUNDS 23.00 23.00 1,700.00 1,677.00 1.4 06-0435-03-00 OPEN ACCESS 569.57 569.57 1,200.00 630.43 47.5 TOTAL COST RECOVERY OR PASS THRU 2,022.47 2,022.47 8,200.00 6,177.53 24.7 TECHNOLOGY 06-0440-00-00 COMPUTER SOFTWARE .00 .00 13,650.00 13,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)749.98 749.98 3,163.00 2,413.02 23.7 TOTAL TECHNOLOGY 749.98 749.98 18,063.00 17,313.02 4.2 GUEST RESOURCES 06-0450-00-00 BOOKS 48,674.50 48,674.50 136,301.00 87,626.50 35.7 06-0450-01-00 PRINT VENDOR PROCESSING 3,860.34 3,860.34 6,000.00 2,139.66 64.3 06-0450-02-00 BOOKS -DIGITAL 6,305.77 6,305.77 61,919.00 55,613.23 10.2 06-0450-03-00 MAGAZINES & NEWSPAPERS 594.37 594.37 5,920.00 5,325.63 10.0 06-0450-03-01 MAGAZINES - DIGITAL 6,750.00 6,750.00 9,606.00 2,856.00 70.3 06-0450-04-00 MEDIA 45,605.43 45,605.43 74,057.00 28,451.57 61.6 06-0450-05-00 MEDIA - DIGITAL 4,080.99 4,080.99 61,609.00 57,528.01 6.6 06-0450-06-00 DATABASES 5,176.00 5,176.00 11,050.00 5,874.00 46.8 06-0450-07-00 HOTSPOT 1,311.88 1,311.88 5,562.00 4,250.12 23.6 TOTAL GUEST RESOURCES 122,359.28 122,359.28 372,024.00 249,664.72 32.9 GUEST CLASSES & EVENTS 06-0455-00-00 CLASSES & EVENTS 12,943.17 12,943.17 25,000.00 12,056.83 51.8 TOTAL GUEST CLASSES & EVENTS 12,943.17 12,943.17 25,000.00 12,056.83 51.8 PERSONNEL 06-0461-10-00 SALARIES - FULL TIME 172,162.04 172,162.04 453,000.00 280,837.96 38.0 06-0461-10-01 SALARIES - PERSONNEL SERVICES 13,753.62 13,753.62 .00 ( 13,753.62).0 06-0461-11-00 OVERTIME 2,451.95 2,451.95 5,000.00 2,548.05 49.0 06-0461-15-00 SALARIES - PART TIME 85,945.94 85,945.94 221,600.00 135,654.06 38.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 11 06-0461-21-00 FICA 19,597.05 19,597.05 51,990.00 32,392.95 37.7 06-0461-22-00 PERSI 20,849.10 20,849.10 54,050.00 33,200.90 38.6 06-0461-23-00 HRA BUY-DOWN .00 .00 5,500.00 5,500.00 .0 06-0461-23-01 HRA/COBRA ADMIN FEES 365.15 365.15 900.00 534.85 40.6 06-0461-24-00 WORKERS' COMPENSATION 1,939.51 1,939.51 5,476.00 3,536.49 35.4 06-0461-25-00 INSURANCE 19,203.12 19,203.12 67,788.00 48,584.88 28.3 06-0461-26-00 HSA CONTRIBUTION 1,260.00 1,260.00 5,760.00 4,500.00 21.9 06-0461-27-00 PTO CASH OUT .00 .00 20,000.00 20,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 337,527.48 337,527.48 910,604.00 573,076.52 37.1 STAFF DEVELOPMENT 06-0463-00-00 TRAVEL & PER DIEM .00 .00 17,300.00 17,300.00 .0 06-0463-01-00 MILEAGE REIMBURSEMENT .00 .00 1,000.00 1,000.00 .0 06-0463-02-00 TRAINING 190.75 190.75 2,200.00 2,009.25 8.7 06-0463-03-00 CONTINUING EDUCATION 2,021.78 2,021.78 12,500.00 10,478.22 16.2 06-0463-04-00 RECRUITMENT .00 .00 1,000.00 1,000.00 .0 06-0463-06-00 TRUSTEE-TRAVEL/MEETINGS .00 .00 5,600.00 5,600.00 .0 06-0463-08-00 VIRTUAL TRAINING 2,459.00 2,459.00 1,500.00 ( 959.00)163.9 TOTAL STAFF DEVELOPMENT 4,671.53 4,671.53 41,100.00 36,428.47 11.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 11,584.40 11,584.40 27,000.00 15,415.60 42.9 06-0464-03-00 TELEPHONE 1,299.76 1,299.76 2,000.00 700.24 65.0 06-0464-04-00 SECURITY SYSEM 534.96 534.96 3,000.00 2,465.04 17.8 06-0464-06-00 GROUNDS .00 .00 1,000.00 1,000.00 .0 06-0464-07-00 FLOOR MATS 562.35 562.35 1,500.00 937.65 37.5 TOTAL FACILITY (BLDGS & GROUNDS)13,981.47 13,981.47 37,500.00 23,518.53 37.3 TOTAL FUND EXPENDITURES 560,146.03 560,146.03 2,071,835.00 1,511,688.97 27.0 NET REVENUE OVER EXPENDITURES 433,698.72 433,698.72 .00 ( 433,698.72).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 MUSEUM FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM 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 830.40 07-0217-09-00 WORKERS' COMPENSATION 1,403.63 TOTAL LIABILITIES 2,721.51 FUND EQUITY 07-0271-00-00 MUSEUM FUND BALANCE 43,745.48 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 46,466.99) BALANCE - CURRENT DATE ( 46,466.99) TOTAL FUND EQUITY ( 2,721.51) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 13 REVENUE 07-0316-12-00 FUNDING FROM GENERAL FUND 13,185.78 13,185.78 142,185.00 128,999.22 9.3 07-0376-00-00 MUSEUM CONTRIBUTIONS/DONATIONS 748.92 748.92 150.00 ( 598.92)499.3 07-0379-00-00 MUSEUM MISC REVENUE 26.00 26.00 25.00 ( 1.00)104.0 07-0379-02-00 ARCADIA BOOKS SALES/ROYALTIES 198.28 198.28 400.00 201.72 49.6 07-0379-03-00 SALES TAX REVENUE 1.30 1.30 5.00 3.70 26.0 07-0380-00-00 GIFT SHOP REVENUE 17.00 17.00 100.00 83.00 17.0 07-0390-00-00 MUSEUM CARRY OVER .00 .00 14,000.00 14,000.00 .0 TOTAL FUND REVENUE 14,177.28 14,177.28 156,865.00 142,687.72 9.0 EXPENDITURES PERSONNEL 07-0420-10-00 SALARIES-FULL TIME 27,708.28 27,708.28 57,500.00 29,791.72 48.2 07-0420-15-00 SALARIES - PART TIME 13,379.74 13,379.74 52,500.00 39,120.26 25.5 07-0420-21-00 FICA 3,143.14 3,143.14 7,500.00 4,356.86 41.9 07-0420-22-00 PERSI 3,308.38 3,308.38 6,800.00 3,491.62 48.7 07-0420-24-00 WORKERS' COMPENSATION 78.07 78.07 .00 ( 78.07).0 07-0420-25-00 INSURANCE 1,905.72 1,905.72 7,600.00 5,694.28 25.1 07-0420-27-00 HRA BUY DOWN .00 .00 1,540.00 1,540.00 .0 TOTAL PERSONNEL 49,523.33 49,523.33 133,440.00 83,916.67 37.1 EDUCATION 07-0461-02-00 ASSOCIATION MEMBERSHIP 169.50 169.50 325.00 155.50 52.2 07-0461-03-00 CONFERENCES & SEMINARS 15.00 15.00 1,500.00 1,485.00 1.0 07-0461-04-00 TRAVEL & PER DIEM .00 .00 3,500.00 3,500.00 .0 TOTAL EDUCATION 184.50 184.50 5,325.00 5,140.50 3.5 ADMINISTRATION 07-0462-30-00 CONSERVATION/PRESERVATION .00 .00 1,000.00 1,000.00 .0 07-0462-31-00 OFFICE SUPPLIES 364.72 364.72 .00 ( 364.72).0 07-0462-32-00 ARCHIVAL SUPPLIES 678.97 678.97 1,000.00 321.03 67.9 07-0462-33-00 PUBLICITY-PRINTING 21.67 21.67 1,000.00 978.33 2.2 07-0462-34-00 RESEARCH MATERIAL 208.90 208.90 100.00 ( 108.90)208.9 07-0462-35-00 UNIFORMS .00 .00 400.00 400.00 .0 07-0462-68-00 MUSEUM PROGRAMS 884.64 884.64 2,000.00 1,115.36 44.2 07-0462-69-00 MISCELLANEOUS 150.21 150.21 200.00 49.79 75.1 07-0462-73-00 EAGLE BOOK-ARCADIA PUBLISHING .00 .00 300.00 300.00 .0 TOTAL ADMINISTRATION 2,309.11 2,309.11 6,000.00 3,690.89 38.5 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 14 EXHIBITS 07-0463-01-00 DISPLAY SUPPLIES 206.83 206.83 300.00 93.17 68.9 07-0463-02-00 EXHIBIT ITEMS .00 .00 500.00 500.00 .0 07-0463-03-00 EXHIBIT CONSTRUCTION 2,398.90 2,398.90 1,000.00 ( 1,398.90)239.9 07-0463-04-00 ANNUAL EXHIBIT 6,021.60 6,021.60 10,000.00 3,978.40 60.2 TOTAL EXHIBITS 8,627.33 8,627.33 11,800.00 3,172.67 73.1 PROGRAMS 07-0464-08-00 GIFT SHOP SUPPLIES .00 .00 300.00 300.00 .0 TOTAL PROGRAMS .00 .00 300.00 300.00 .0 TOTAL FUND EXPENDITURES 60,644.27 60,644.27 156,865.00 96,220.73 38.7 NET REVENUE OVER EXPENDITURES ( 46,466.99)( 46,466.99).00 46,466.99 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 PARK IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 15 ASSETS 08-0101-00-00 CASH 69,190.64 08-0151-25-00 FIRST INTERSTATE INVESTMENT 3,764,039.41 TOTAL ASSETS 3,833,230.05 LIABILITIES AND EQUITY FUND EQUITY 08-0271-00-00 PARK FUND/FUND BALANCE 3,700,742.90 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 132,487.15 BALANCE - CURRENT DATE 132,487.15 TOTAL FUND EQUITY 3,833,230.05 TOTAL LIABILITIES AND EQUITY 3,833,230.05 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 PARK IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 16 REVENUE 08-0322-19-00 PARKS DEVELOPMENT IMPACT FEES 181,862.36 181,862.36 669,432.00 487,569.64 27.2 08-0364-01-00 CONTRIBUTIONS AND DONATIONS .00 .00 288,286.00 288,286.00 .0 08-0371-25-00 BANK INTEREST 3,296.51 3,296.51 4,200.00 903.49 78.5 08-0390-00-00 PARK FUND / CARRY OVER .00 .00 4,732,830.00 4,732,830.00 .0 TOTAL FUND REVENUE 185,158.87 185,158.87 5,694,748.00 5,509,589.13 3.3 EXPENDITURES CAPITAL IMPROVEMENTS 08-0438-37-00 CAPITAL IMPROVEMENTS 52,671.72 52,671.72 5,694,748.00 5,642,076.28 .9 TOTAL CAPITAL IMPROVEMENTS 52,671.72 52,671.72 5,694,748.00 5,642,076.28 .9 TOTAL FUND EXPENDITURES 52,671.72 52,671.72 5,694,748.00 5,642,076.28 .9 NET REVENUE OVER EXPENDITURES 132,487.15 132,487.15 .00 ( 132,487.15).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 RECREATION - SPECIAL EVENTS FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 17 ASSETS 09-0101-00-00 CASH 96,935.11 TOTAL ASSETS 96,935.11 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 10,654.59 09-0217-09-00 WORKERS' COMPENSATION 13,345.92 09-0217-10-00 HSA CONTRIBUTION 3,319.35 TOTAL LIABILITIES 27,900.40 FUND EQUITY 09-0271-00-00 FUND BALANCE 126,879.30 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 57,844.59) BALANCE - CURRENT DATE ( 57,844.59) TOTAL FUND EQUITY 69,034.71 TOTAL LIABILITIES AND EQUITY 96,935.11 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 18 REVENUE 09-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 221,095.00 221,095.00 .0 09-0347-06-00 CHRISTMAS MARKET 3,583.44 3,583.44 2,750.00 ( 833.44)130.3 09-0347-08-00 SATURDAY MARKET 276.19 276.19 22,500.00 22,223.81 1.2 09-0347-10-00 GAZEBO CONCERT SERIES 3,000.00 3,000.00 825.00 ( 2,175.00)363.6 09-0347-11-00 HARVEST FEST MARKET 487.41 487.41 2,750.00 2,262.59 17.7 09-0376-13-00 SPONSORSHIPS .00 .00 15,000.00 15,000.00 .0 09-0376-15-00 EVENT APPLICATION FEES 1,100.00 1,100.00 1,500.00 400.00 73.3 09-0376-17-00 SECURITY DEPOSIT .00 .00 1,200.00 1,200.00 .0 TOTAL FUND REVENUE 8,447.04 8,447.04 267,620.00 259,172.96 3.2 EXPENDITURES CAPITAL EXPENDITURE 09-0419-01-00 EVENT EQUIPMENT PURCHASES .00 .00 3,000.00 3,000.00 .0 TOTAL CAPITAL EXPENDITURE .00 .00 3,000.00 3,000.00 .0 PERSONNEL 09-0420-10-00 SALARIES-FULL TIME 36,210.55 36,210.55 118,800.00 82,589.45 30.5 09-0420-11-00 OVERTIME 626.99 626.99 2,000.00 1,373.01 31.4 09-0420-15-00 SALARIES-PART TIME 834.81 834.81 26,700.00 25,865.19 3.1 09-0420-21-00 FICA 2,841.67 2,841.67 11,400.00 8,558.33 24.9 09-0420-22-00 PERSI 4,161.31 4,161.31 14,300.00 10,138.69 29.1 09-0420-24-00 WORKERS' COMPENSATION 1,153.39 1,153.39 .00 ( 1,153.39).0 09-0420-25-00 INSURANCE 2,836.07 2,836.07 15,920.00 13,083.93 17.8 09-0420-26-00 HSA CONTRIBUTION 400.00 400.00 .00 ( 400.00).0 09-0420-29-00 PTO CASH OUT .00 .00 2,500.00 2,500.00 .0 TOTAL PERSONNEL 49,064.79 49,064.79 191,620.00 142,555.21 25.6 ADMINISTRATION 09-0463-11-00 OFFICE SUPPLIES 6.29 6.29 800.00 793.71 .8 09-0463-12-00 PROMOTIONS .00 .00 14,000.00 14,000.00 .0 09-0463-19-00 TRAINING 53.55 53.55 1,200.00 1,146.45 4.5 09-0463-20-00 TRAVEL/PER DIEM 194.50 194.50 4,000.00 3,805.50 4.9 09-0463-21-00 PROFESSIONAL DUES 1,766.90 1,766.90 2,150.00 383.10 82.2 09-0463-22-00 UNIFORMS .00 .00 600.00 600.00 .0 09-0463-23-00 GAS/MILEAGE .00 .00 100.00 100.00 .0 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 2,021.24 2,021.24 24,750.00 22,728.76 8.2 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 19 ACTIVITIES 09-0467-02-00 EAGLE SATURDAY MARKET 1,485.60 1,485.60 11,000.00 9,514.40 13.5 09-0467-03-00 CHRISTMAS MARKET 9,715.02 9,715.02 6,500.00 ( 3,215.02)149.5 09-0467-04-00 GAZEBO CONCERT SERIES 350.00 350.00 8,750.00 8,400.00 4.0 09-0467-05-00 GENERAL EVENTS 750.00 750.00 10,000.00 9,250.00 7.5 09-0467-06-00 EAGLE HARVEST FEST 2,154.98 2,154.98 4,000.00 1,845.02 53.9 09-0467-08-00 EVENTS EQUIPMENT RENTAL 750.00 750.00 8,000.00 7,250.00 9.4 TOTAL ACTIVITIES 15,205.60 15,205.60 48,250.00 33,044.40 31.5 TOTAL FUND EXPENDITURES 66,291.63 66,291.63 267,620.00 201,328.37 24.8 NET REVENUE OVER EXPENDITURES ( 57,844.59)( 57,844.59).00 57,844.59 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 EAGLE HISTORICAL COMMISSION FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 20 ASSETS 10-0101-00-00 CASH 21,016.85 TOTAL ASSETS 21,016.85 LIABILITIES AND EQUITY FUND EQUITY 10-0271-00-00 FUND BALANCE 19,283.33 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,733.52 BALANCE - CURRENT DATE 1,733.52 TOTAL FUND EQUITY 21,016.85 TOTAL LIABILITIES AND EQUITY 21,016.85 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 EAGLE HISTORICAL COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 21 REVENUE 10-0316-12-00 FUNDING FROM GENERAL FUND .00 .00 3,118.00 3,118.00 .0 10-0333-01-00 GRANTS, STATE 1,733.52 1,733.52 .00 ( 1,733.52).0 10-0390-00-00 CARRY OVER .00 .00 5,882.00 5,882.00 .0 TOTAL FUND REVENUE 1,733.52 1,733.52 9,000.00 7,266.48 19.3 EXPENDITURES ADMINISTRATION 10-0462-02-00 PUBLICITY - PRINTING .00 .00 1,000.00 1,000.00 .0 10-0462-05-00 EDUCATION/TRAINING .00 .00 500.00 500.00 .0 TOTAL ADMINISTRATION .00 .00 1,500.00 1,500.00 .0 PROGRAMS 10-0464-07-00 PRESERVATION .00 .00 1,000.00 1,000.00 .0 10-0464-08-00 COMM ENGAGEMENT/SPECIAL EVENTS .00 .00 500.00 500.00 .0 TOTAL PROGRAMS .00 .00 1,500.00 1,500.00 .0 GRANTS 10-0465-02-00 MUNICIPAL GRANT FUNDS .00 .00 6,000.00 6,000.00 .0 TOTAL GRANTS .00 .00 6,000.00 6,000.00 .0 TOTAL FUND EXPENDITURES .00 .00 9,000.00 9,000.00 .0 NET REVENUE OVER EXPENDITURES 1,733.52 1,733.52 .00 ( 1,733.52).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 EXECUTIVE DEPARTMENT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM 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 3,578.63 11-0217-09-00 WORKERS' COMPENSATION 3,967.20 11-0217-10-00 HSA CONTRIBUTION ( 224.00) TOTAL LIABILITIES 10,200.39 FUND EQUITY 11-0271-00-00 FUND BALANCE ( 6,073.74) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 4,126.65) BALANCE - CURRENT DATE ( 4,126.65) TOTAL FUND EQUITY ( 10,200.39) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 23 REVENUE 11-0301-00-00 MONTHLY TRANSFER TO DEPTS 136,759.81 136,759.81 400,030.00 263,270.19 34.2 TOTAL FUND REVENUE 136,759.81 136,759.81 400,030.00 263,270.19 34.2 EXPENDITURES ADMINISTRATION 11-0413-04-00 UNIFORMS .00 .00 300.00 300.00 .0 11-0413-05-00 OFFICE EXPENSES 258.08 258.08 500.00 241.92 51.6 11-0413-12-00 PERSONNEL TRAINING .00 .00 3,500.00 3,500.00 .0 11-0413-13-00 TRAVEL & PER DIEM 142.00 142.00 6,000.00 5,858.00 2.4 11-0413-14-00 PROFESSIONAL DUES 1,476.00 1,476.00 1,900.00 424.00 77.7 TOTAL ADMINISTRATION 1,876.08 1,876.08 12,200.00 10,323.92 15.4 PERSONNEL 11-0415-10-00 SALARIES-FULL TIME 106,306.34 106,306.34 221,700.00 115,393.66 48.0 11-0415-11-00 OVERTIME 17.92 17.92 500.00 482.08 3.6 11-0415-21-00 FICA 7,870.88 7,870.88 17,100.00 9,229.12 46.0 11-0415-22-00 PERSI 12,695.02 12,695.02 26,700.00 14,004.98 47.6 11-0415-24-00 WORKERS' COMPENSATION 2,156.09 2,156.09 .00 ( 2,156.09).0 11-0415-25-00 INSURANCE 9,236.18 9,236.18 19,300.00 10,063.82 47.9 11-0415-26-00 HSA CONTRIBUTION 360.00 360.00 1,200.00 840.00 30.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 138,642.43 138,642.43 299,580.00 160,937.57 46.3 STATE OF THE CITY 11-0417-01-00 STATE OF THE CITY .00 .00 2,250.00 2,250.00 .0 TOTAL STATE OF THE CITY .00 .00 2,250.00 2,250.00 .0 DEPARTMENT 0418 11-0418-00-00 COMP PLAN REWRITE 77.40 77.40 83,000.00 82,922.60 .1 TOTAL DEPARTMENT 0418 77.40 77.40 83,000.00 82,922.60 .1 COMMUNITY & STAFF RELATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 24 11-0422-01-00 COMMUNITY/STAFF RELATIONS 290.55 290.55 3,000.00 2,709.45 9.7 TOTAL COMMUNITY & STAFF RELATIONS 290.55 290.55 3,000.00 2,709.45 9.7 TOTAL FUND EXPENDITURES 140,886.46 140,886.46 400,030.00 259,143.54 35.2 NET REVENUE OVER EXPENDITURES ( 4,126.65)( 4,126.65).00 4,126.65 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 CITY CLERK/TREAS DEPARTMENT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM 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 7,323.53 12-0217-09-00 WORKERS' COMPENSATION 6,892.06 TOTAL LIABILITIES 24,850.18 FUND EQUITY 12-0271-00-00 FUND BALANCE ( 25,013.59) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 163.41 BALANCE - CURRENT DATE 163.41 TOTAL FUND EQUITY ( 24,850.18) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 CITY CLERK/TREAS DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:03PM PAGE: 26 REVENUE 12-0301-00-00 MONTHLY TRANSFER TO DEPTS 275,384.83 275,384.83 626,550.00 351,165.17 44.0 TOTAL FUND REVENUE 275,384.83 275,384.83 626,550.00 351,165.17 44.0 EXPENDITURES ADMINISTRATION 12-0413-05-00 OFFICE EXPENSES 433.44 433.44 1,000.00 566.56 43.3 12-0413-06-00 DUPLICATION/PUBLISHING/PRINTIG 30.00 30.00 200.00 170.00 15.0 12-0413-12-00 PERSONNEL TRAINING & RESOURCES 866.18 866.18 10,000.00 9,133.82 8.7 12-0413-13-00 TRAVEL & PER DIEM 26.20 26.20 5,000.00 4,973.80 .5 12-0413-14-00 PROFESSIONAL DUES 445.00 445.00 1,400.00 955.00 31.8 12-0413-29-00 UNIFORMS .00 .00 750.00 750.00 .0 12-0413-30-00 MISCELLANEOUS 110.79 110.79 500.00 389.21 22.2 TOTAL ADMINISTRATION 1,911.61 1,911.61 18,850.00 16,938.39 10.1 PERSONNEL 12-0415-10-00 SALARIES- FULL TIME 201,425.56 201,425.56 408,000.00 206,574.44 49.4 12-0415-11-00 OVERTIME 1,926.33 1,926.33 3,000.00 1,073.67 64.2 12-0415-15-00 SALARIES-PART TIME .00 .00 16,500.00 16,500.00 .0 12-0415-21-00 FICA 14,910.01 14,910.01 32,800.00 17,889.99 45.5 12-0415-22-00 PERSI 23,260.05 23,260.05 51,200.00 27,939.95 45.4 12-0415-23-00 HRA BUY- DOWN 480.98 480.98 8,000.00 7,519.02 6.0 12-0415-23-02 HSA CONTRIBUTION .00 .00 1,200.00 1,200.00 .0 12-0415-24-00 WORKERS' COMPENSATION 385.23 385.23 .00 ( 385.23).0 12-0415-25-00 INSURANCE 30,721.65 30,721.65 82,000.00 51,278.35 37.5 12-0415-26-00 PTO CASH OUT 200.00 200.00 5,000.00 4,800.00 4.0 TOTAL PERSONNEL 273,309.81 273,309.81 607,700.00 334,390.19 45.0 TOTAL FUND EXPENDITURES 275,221.42 275,221.42 626,550.00 351,328.58 43.9 NET REVENUE OVER EXPENDITURES 163.41 163.41 .00 ( 163.41).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 BUILDING DEPARTMENT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM 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 6,679.89 13-0217-09-00 WORKERS' COMPENSATION 42,299.54 13-0217-10-00 HSA CONTRIBUTION ( 1,900.00) TOTAL LIABILITIES 55,565.36 FUND EQUITY 13-0271-00-00 FUND BALANCE ( 91,593.51) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 36,128.15 BALANCE - CURRENT DATE 36,128.15 TOTAL FUND EQUITY ( 55,465.36) TOTAL LIABILITIES AND EQUITY 100.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 28 REVENUE 13-0301-00-00 MONTHLY TRANSFER TO DEPTS 506,543.84 506,543.84 1,156,430.00 649,886.16 43.8 TOTAL FUND REVENUE 506,543.84 506,543.84 1,156,430.00 649,886.16 43.8 EXPENDITURES ADMINISTRATION 13-0413-05-00 OFFICE EXPENSES 3,318.48 3,318.48 6,500.00 3,181.52 51.1 13-0413-08-00 LEGAL ADS & PUBLICATIONS 27.00 27.00 400.00 373.00 6.8 13-0413-09-00 COMMERCIAL PLAN REVIEW .00 .00 6,000.00 6,000.00 .0 13-0413-12-00 TRAINING & CERTIFICATION RENEW 1,648.00 1,648.00 4,400.00 2,752.00 37.5 13-0413-13-00 TRAVEL & PER DIEM .00 .00 3,000.00 3,000.00 .0 13-0413-14-00 PROFESSIONAL DUES .00 .00 540.00 540.00 .0 13-0413-25-00 MISCELLANEOUS .00 .00 300.00 300.00 .0 13-0413-28-00 RESOURCE MATERIALS 1,314.40 1,314.40 1,500.00 185.60 87.6 13-0413-29-00 BUILDING PERMIT REFUNDS 250.00 250.00 .00 ( 250.00).0 13-0413-29-03 MECHANICAL FEE REFUND 4,375.00 4,375.00 500.00 ( 3,875.00)875.0 13-0413-29-04 PLUMBING PERMIT REFUND 1,480.00 1,480.00 500.00 ( 980.00)296.0 13-0413-29-05 ELECTRICAL PERMIT REFUND 1,875.20 1,875.20 500.00 ( 1,375.20)375.0 13-0413-30-00 UNIFORMS 1,501.24 1,501.24 1,750.00 248.76 85.8 TOTAL ADMINISTRATION 15,789.32 15,789.32 25,890.00 10,100.68 61.0 PERSONNEL 13-0415-10-00 SALARIES-FULL TIME 154,834.24 154,834.24 407,000.00 252,165.76 38.0 13-0415-10-01 SALARIES - PERSONNEL SERVICES 8,089.92 8,089.92 .00 ( 8,089.92).0 13-0415-11-00 OVERTIME 721.07 721.07 8,000.00 7,278.93 9.0 13-0415-21-00 FICA 11,336.85 11,336.85 31,800.00 20,463.15 35.7 13-0415-22-00 PERSI 18,573.20 18,573.20 49,700.00 31,126.80 37.4 13-0415-23-00 HRA BUY-DOWN 125.66 125.66 9,240.00 9,114.34 1.4 13-0415-24-00 WORKERS' COMPENSATION 5,268.51 5,268.51 .00 ( 5,268.51).0 13-0415-25-00 INSURANCE 31,326.12 31,326.12 87,000.00 55,673.88 36.0 13-0415-26-00 HSA CONTRIBUTION 1,200.00 1,200.00 1,200.00 .00 100.0 13-0415-28-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 TOTAL PERSONNEL 231,475.57 231,475.57 598,940.00 367,464.43 38.7 CONTRACTS & AGREEMENTS 13-0416-09-00 PLUMBING INSPECTOR 52,084.67 52,084.67 150,000.00 97,915.33 34.7 13-0416-11-00 MECHANICAL INSPECTOR 77,466.95 77,466.95 150,000.00 72,533.05 51.6 13-0416-13-00 BLDG INSPECTOR 20,964.00 20,964.00 62,000.00 41,036.00 33.8 13-0416-14-00 PLAN REVIEW - CONTRACT .00 .00 15,000.00 15,000.00 .0 13-0416-25-00 ELECTRICAL INSPECTOR 72,595.02 72,595.02 150,000.00 77,404.98 48.4 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 29 TOTAL CONTRACTS & AGREEMENTS 223,110.64 223,110.64 527,000.00 303,889.36 42.3 VEHICLE OPERATIONS 13-0417-02-00 GAS AND OIL 40.16 40.16 600.00 559.84 6.7 13-0417-03-00 VEHICLE REPLACEMENT .00 .00 4,000.00 4,000.00 .0 TOTAL VEHICLE OPERATIONS 40.16 40.16 4,600.00 4,559.84 .9 TOTAL FUND EXPENDITURES 470,415.69 470,415.69 1,156,430.00 686,014.31 40.7 NET REVENUE OVER EXPENDITURES 36,128.15 36,128.15 .00 ( 36,128.15).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 P&Z DEPARTMENT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM 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 ( 32,123.83) 14-0217-08-00 P&Z DEPT/GARNISHMENTS 203.34 14-0217-09-00 WORKERS' COMPENSATION 69,488.91 TOTAL LIABILITIES 55,983.77 FUND EQUITY 14-0271-00-00 FUND BALANCE ( 59,544.03) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 3,560.26 BALANCE - CURRENT DATE 3,560.26 TOTAL FUND EQUITY ( 55,983.77) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 31 REVENUE 14-0301-00-00 MONTHLY TRANSFER TO DEPTS 460,101.26 460,101.26 1,214,100.00 753,998.74 37.9 TOTAL FUND REVENUE 460,101.26 460,101.26 1,214,100.00 753,998.74 37.9 EXPENDITURES ADMINISTRATION 14-0413-05-00 OFFICE EXPENSES 267.81 267.81 1,800.00 1,532.19 14.9 14-0413-06-00 DUPLICATION/PUBLISHING/PRNTG .00 .00 1,000.00 1,000.00 .0 14-0413-08-00 LEGAL ADS & PUBLICATIONS 2,508.05 2,508.05 8,000.00 5,491.95 31.4 14-0413-12-00 PERSONNEL TRAINING .00 .00 5,100.00 5,100.00 .0 14-0413-13-00 TRAVEL & PER DIEM 1,087.31 1,087.31 15,000.00 13,912.69 7.3 14-0413-14-00 PROFESSIONAL DUES 1,005.00 1,005.00 2,500.00 1,495.00 40.2 14-0413-25-00 MISCELLANEOUS 768.78 768.78 1,000.00 231.22 76.9 14-0413-26-00 REIMBURSE-ANNEX/ZONING/DR FEES 1,866.54 1,866.54 3,000.00 1,133.46 62.2 14-0413-28-00 RESOURCE MATERIALS .00 .00 200.00 200.00 .0 14-0413-30-01 ENVIRONMENTAL REVIEW SERVICES .00 .00 5,000.00 5,000.00 .0 14-0413-37-00 ARBORICULTURE .00 .00 500.00 500.00 .0 TOTAL ADMINISTRATION 7,503.49 7,503.49 43,100.00 35,596.51 17.4 PERSONNEL 14-0415-10-00 SALARIES-FULL TIME 333,890.21 333,890.21 788,000.00 454,109.79 42.4 14-0415-11-00 OVERTIME 1,561.53 1,561.53 11,300.00 9,738.47 13.8 14-0415-21-00 FICA 25,070.65 25,070.65 61,500.00 36,429.35 40.8 14-0415-22-00 PERSI 40,052.82 40,052.82 95,600.00 55,547.18 41.9 14-0415-24-00 WORKERS' COMPENSATION 5,327.10 5,327.10 .00 ( 5,327.10).0 14-0415-25-00 INSURANCE 38,119.38 38,119.38 137,000.00 98,880.62 27.8 14-0415-26-00 HSA CONTRIBUTION 700.00 700.00 4,800.00 4,100.00 14.6 14-0415-29-00 PTO CASH OUT .00 .00 15,000.00 15,000.00 .0 14-0415-30-00 HRA BUY- DOWN 2,963.33 2,963.33 17,000.00 14,036.67 17.4 TOTAL PERSONNEL 447,685.02 447,685.02 1,130,200.00 682,514.98 39.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,092.50 1,092.50 10,000.00 8,907.50 10.9 TOTAL CONTRACTS & AGREEMENTS 1,092.50 1,092.50 30,000.00 28,907.50 3.6 PUBLIC RELATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM 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 259.99 259.99 600.00 340.01 43.3 TOTAL CAPITAL OUTLAY 259.99 259.99 600.00 340.01 43.3 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 456,541.00 456,541.00 1,214,100.00 757,559.00 37.6 NET REVENUE OVER EXPENDITURES 3,560.26 3,560.26 .00 ( 3,560.26).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 RECREATION - PARKS AND REC FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 33 ASSETS 17-0101-00-00 CASH 43,375.33 TOTAL ASSETS 43,375.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 ( 7,785.20) 17-0217-09-00 WORKERS' COMPENSATION 35,375.84 17-0217-10-00 HSA CONTRIBUTION ( 4,225.93) TOTAL LIABILITIES 26,111.30 FUND EQUITY 17-0271-00-00 FUND BALANCE 133,692.11 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 116,428.08) BALANCE - CURRENT DATE ( 116,428.08) TOTAL FUND EQUITY 17,264.03 TOTAL LIABILITIES AND EQUITY 43,375.33 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 RECREATION - PARKS AND REC PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 34 REVENUE 17-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 443,770.00 443,770.00 .0 17-0302-00-00 REGISTRATION 71,032.74 71,032.74 188,000.00 116,967.26 37.8 17-0302-01-00 SPONSORSHIPS .00 .00 10,000.00 10,000.00 .0 17-0302-03-00 PARK RESERVATION FEES 8,187.92 8,187.92 20,000.00 11,812.08 40.9 17-0303-00-00 SCHOLARSHIP FUNDS .00 .00 1,000.00 1,000.00 .0 TOTAL FUND REVENUE 79,220.66 79,220.66 662,770.00 583,549.34 12.0 EXPENDITURES CONTRACTS 17-0416-00-00 CONTRACT-PERMITS-CAMPS/CLASSES 525.00 525.00 35,000.00 34,475.00 1.5 17-0416-01-00 CONTRACT-PERMITS TEAM SPORTS 6,130.50 6,130.50 15,000.00 8,869.50 40.9 TOTAL CONTRACTS 6,655.50 6,655.50 50,000.00 43,344.50 13.3 PERSONNEL 17-0420-10-00 SALARIES-FULL TIME 118,176.09 118,176.09 266,500.00 148,323.91 44.3 17-0420-10-01 SALARIES-PERSONNEL SERVICES 1,649.00 1,649.00 .00 ( 1,649.00).0 17-0420-11-00 SALARIES-SEASONAL 628.60 628.60 58,500.00 57,871.40 1.1 17-0420-15-00 SALARIES-PART TIME 4,716.93 4,716.93 30,500.00 25,783.07 15.5 17-0420-18-00 OVERTIME 1,074.16 1,074.16 4,000.00 2,925.84 26.9 17-0420-21-00 FICA 9,360.18 9,360.18 27,550.00 18,189.82 34.0 17-0420-22-00 PERSI 12,462.94 12,462.94 31,800.00 19,337.06 39.2 17-0420-23-00 HRA BUY-DOWN .00 .00 4,620.00 4,620.00 .0 17-0420-24-00 WORKERS' COMPENSATION 4,633.21 4,633.21 .00 ( 4,633.21).0 17-0420-25-00 INSURANCE 10,903.52 10,903.52 27,500.00 16,596.48 39.7 17-0420-26-00 HSA CONTRIBUTION 800.00 800.00 4,800.00 4,000.00 16.7 17-0420-27-00 PTO CASH OUT .00 .00 5,400.00 5,400.00 .0 TOTAL PERSONNEL 164,404.63 164,404.63 461,170.00 296,765.37 35.7 RESTRICTED FUNDS 17-0421-00-00 SCHOLARSHIP FUNDS .00 .00 1,000.00 1,000.00 .0 TOTAL RESTRICTED FUNDS .00 .00 1,000.00 1,000.00 .0 ADMINISTRATION 17-0422-00-00 TRAINING-PROFESSIONAL DEVELOP 62.02 62.02 2,000.00 1,937.98 3.1 17-0422-01-00 OFFICE SUPPLIES 440.92 440.92 1,000.00 559.08 44.1 17-0422-02-00 ADVERTISING/MKTING CAMP/CLASS 35.00 35.00 5,500.00 5,465.00 .6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 RECREATION - PARKS AND REC PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 35 17-0422-02-01 ADVERTISING/MKTNG TEAM SPORTS 50.00 50.00 5,500.00 5,450.00 .9 17-0422-04-00 GAS/MILEAGE 38.03 38.03 100.00 61.97 38.0 17-0422-06-00 PRINTING AND PUBLISHING .00 .00 10,000.00 10,000.00 .0 17-0422-07-00 PROFESSIONAL DUES .00 .00 2,000.00 2,000.00 .0 17-0422-08-00 TRAINING .00 .00 3,000.00 3,000.00 .0 17-0422-09-00 TRAVEL/PER DIEM 194.50 194.50 8,000.00 7,805.50 2.4 17-0422-10-00 BACKGROUND CHECKS 491.50 491.50 2,000.00 1,508.50 24.6 17-0422-11-00 REFUNDS-PARK REC PROGRAMS 40.00 40.00 2,000.00 1,960.00 2.0 TOTAL ADMINISTRATION 1,351.97 1,351.97 41,100.00 39,748.03 3.3 RECREATION 17-0423-00-00 REC SUPPLIES-CAMPS & CLASSES 169.71 169.71 6,000.00 5,830.29 2.8 17-0423-00-01 REC SUPPLIES-TEAM SPORTS 3,829.31 3,829.31 15,000.00 11,170.69 25.5 17-0423-01-00 UNIFORMS 6,605.09 6,605.09 15,000.00 8,394.91 44.0 17-0423-02-00 FIELD TRIPS 865.43 865.43 15,000.00 14,134.57 5.8 17-0423-03-00 FACILITY RENTAL 8,687.50 8,687.50 10,000.00 1,312.50 86.9 17-0423-04-00 TRANSPORTATION SERVICES 1,368.93 1,368.93 10,000.00 8,631.07 13.7 17-0423-05-00 DADDY DAUGHTER DANCE 1,275.66 1,275.66 2,200.00 924.34 58.0 17-0423-07-00 GLOW IN THE PARK .00 .00 15,500.00 15,500.00 .0 17-0423-08-00 HALLOWEEN TRICK-OR-TREAT .00 .00 800.00 800.00 .0 17-0423-09-00 VETERAN'S BREAKFAST 365.69 365.69 1,000.00 634.31 36.6 17-0423-10-00 NEW PROGRAMS .00 .00 2,000.00 2,000.00 .0 TOTAL RECREATION 23,167.32 23,167.32 92,500.00 69,332.68 25.1 VEHICLES 17-0424-03-00 GAS 69.32 69.32 1,000.00 930.68 6.9 TOTAL VEHICLES 69.32 69.32 1,000.00 930.68 6.9 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 TOTAL FUND EXPENDITURES 195,648.74 195,648.74 662,770.00 467,121.26 29.5 NET REVENUE OVER EXPENDITURES ( 116,428.08)( 116,428.08).00 116,428.08 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 IT DEPARTMENT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 36 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 ( 25,432.75) 18-0217-09-00 WORKERS' COMPENSATION 1,647.10 18-0217-10-00 HSA CONTRIBUTION 820.00 TOTAL LIABILITIES ( 21,473.26) FUND EQUITY 18-0271-00-00 FUND BALANCE ( 2,402.36) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 23,875.62 BALANCE - CURRENT DATE 23,875.62 TOTAL FUND EQUITY 21,473.26 TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 37 REVENUE 18-0301-00-00 MONTHLY TRANSFER TO DEPTS 340,850.24 340,850.24 893,820.00 552,969.76 38.1 TOTAL FUND REVENUE 340,850.24 340,850.24 893,820.00 552,969.76 38.1 EXPENDITURES ADMINISTRATION 18-0413-01-00 OFFICE SUPPLIES .00 .00 1,000.00 1,000.00 .0 18-0413-02-00 SUPPLIES .00 .00 4,000.00 4,000.00 .0 18-0413-03-00 TRAINING .00 .00 6,450.00 6,450.00 .0 18-0413-04-00 TRAVEL AND PER DIEM 317.19 317.19 6,600.00 6,282.81 4.8 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 317.19 317.19 19,600.00 19,282.81 1.6 PERSONNEL 18-0415-10-00 SALARIES (FULL TIME)115,911.10 115,911.10 237,000.00 121,088.90 48.9 18-0415-11-00 IT DEPT/OVERTIME 564.94 564.94 3,000.00 2,435.06 18.8 18-0415-21-00 FICA 8,385.07 8,385.07 18,500.00 10,114.93 45.3 18-0415-22-00 PERSI 13,907.20 13,907.20 28,800.00 14,892.80 48.3 18-0415-23-00 HRA BUY- DOWN .00 .00 4,620.00 4,620.00 .0 18-0415-24-00 WORKERS' COMPENSATION 220.78 220.78 .00 ( 220.78).0 18-0415-25-00 INSURANCE 18,835.36 18,835.36 41,300.00 22,464.64 45.6 18-0415-26-00 HSA 360.00 360.00 1,200.00 840.00 30.0 18-0415-27-00 PTO CASH OUT .00 .00 2,000.00 2,000.00 .0 TOTAL PERSONNEL 158,184.45 158,184.45 336,420.00 178,235.55 47.0 CONTRACT & AGREEMENTS 18-0416-01-00 CONTRACT AND AGREEMENTS 97,931.13 97,931.13 330,000.00 232,068.87 29.7 TOTAL CONTRACT & AGREEMENTS 97,931.13 97,931.13 330,000.00 232,068.87 29.7 INTERNET/PHONE SERVICES 18-0417-01-00 INTERNET & PHONE SERVICES 28,305.50 28,305.50 74,000.00 45,694.50 38.3 TOTAL INTERNET/PHONE SERVICES 28,305.50 28,305.50 74,000.00 45,694.50 38.3 OPERATIONAL RESERVE CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 38 18-0418-01-00 OPERATIONAL RESV, EQUIP/SOFTWR 16,704.24 16,704.24 35,000.00 18,295.76 47.7 TOTAL OPERATIONAL RESERVE 16,704.24 16,704.24 35,000.00 18,295.76 47.7 CAPITAL OUTLAY 18-0419-01-00 FURNITURE .00 .00 1,300.00 1,300.00 .0 18-0419-02-00 EQUIPMENT 12,050.68 12,050.68 60,000.00 47,949.32 20.1 18-0419-03-00 SOFTWARE PURCHASES 1,450.00 1,450.00 25,000.00 23,550.00 5.8 18-0419-04-00 WEBSITE DEVELOPMENT .00 .00 12,000.00 12,000.00 .0 18-0419-05-00 TOOLS 2,031.43 2,031.43 500.00 ( 1,531.43)406.3 TOTAL CAPITAL OUTLAY 15,532.11 15,532.11 98,800.00 83,267.89 15.7 TOTAL FUND EXPENDITURES 316,974.62 316,974.62 893,820.00 576,845.38 35.5 NET REVENUE OVER EXPENDITURES 23,875.62 23,875.62 .00 ( 23,875.62).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 CAPITAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 39 ASSETS 19-0101-00-00 CASH 755,181.23 19-0151-25-00 FIRST INTERSTATE INVESTMENT 9,504,121.21 19-0151-25-01 FIRST INTERSTATE INV CITY HALL 7,776.78 TOTAL ASSETS 10,267,079.22 LIABILITIES AND EQUITY LIABILITIES 19-0225-00-00 UNEARNED GRANT REVENUE, ARPA 3,204,501.48 TOTAL LIABILITIES 3,204,501.48 FUND EQUITY 19-0271-00-00 FUND BALANCE 10,001,468.10 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 2,938,890.36) BALANCE - CURRENT DATE ( 2,938,890.36) TOTAL FUND EQUITY 7,062,577.74 TOTAL LIABILITIES AND EQUITY 10,267,079.22 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 40 REVENUE 19-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 1,708,900.00 1,708,900.00 .0 19-0301-01-00 BANK INTEREST 1,354.27 1,354.27 500.00 ( 854.27)270.9 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 56,188.93 56,188.93 .00 ( 56,188.93).0 19-0301-12-00 FEMA GENERAL REVENUE .00 .00 1,057,905.00 1,057,905.00 .0 19-0301-13-00 EURA COST SHARE 33,429.13 33,429.13 424,000.00 390,570.87 7.9 19-0301-20-00 COMPASS CIM GRANT .00 .00 25,000.00 25,000.00 .0 19-0331-01-00 ARPA, AMERICAN RESCUE PLAN ACT .00 .00 3,200,000.00 3,200,000.00 .0 19-0333-01-00 STATE BROADBAND GRANT .00 .00 250,000.00 250,000.00 .0 19-0371-25-01 BANK INTEREST, EXPANSION 16.80 16.80 .00 ( 16.80).0 19-0390-00-00 CARRY OVER .00 .00 10,982,829.00 10,982,829.00 .0 19-0390-01-00 CARRY OVER, ARPA FUNDS .00 .00 3,200,000.00 3,200,000.00 .0 TOTAL FUND REVENUE 90,989.13 90,989.13 20,949,134.00 20,858,144.87 .4 EXPENDITURES RESERVES 19-0410-01-00 RESERVES .00 .00 4,560,041.00 4,560,041.00 .0 TOTAL RESERVES .00 .00 4,560,041.00 4,560,041.00 .0 CAPITAL MAINTENANCE 19-0462-01-00 CAPITAL MAINTENANCE SET ASIDE 24,394.96 24,394.96 2,015,889.00 1,991,494.04 1.2 19-0462-03-00 FEMA TRAIL REPLACEMENT 8,528.48 8,528.48 1,596,204.00 1,587,675.52 .5 TOTAL CAPITAL MAINTENANCE 32,923.44 32,923.44 3,612,093.00 3,579,169.56 .9 CITY CAPITAL PROJECTS 19-0465-05-00 GENERAL CITY PROJECTS .00 .00 100,000.00 100,000.00 .0 19-0465-06-00 EXPANSION OF CITY HALL 1,191,911.56 1,191,911.56 2,800,000.00 1,608,088.44 42.6 19-0465-07-00 LAND PURCHASES 948,557.88 948,557.88 .00 ( 948,557.88).0 TOTAL CITY CAPITAL PROJECTS 2,140,469.44 2,140,469.44 2,900,000.00 759,530.56 73.8 PZ CAPITAL PROJECTS 19-0466-03-00 AIKENS EXTENSION .00 .00 617,000.00 617,000.00 .0 19-0466-05-00 EAGLE RD PED/BIKE BRIDGE 156,323.53 156,323.53 900,000.00 743,676.47 17.4 19-0466-06-00 HALF CFI PED/BIKE EDUCATION 3,300.00 3,300.00 .00 ( 3,300.00).0 19-0466-09-00 EAGLE-STATE ST INTERSECTION .00 .00 840,000.00 840,000.00 .0 19-0466-10-00 P&Z CAPITAL PROJECTS FY22 .00 .00 50,000.00 50,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 41 TOTAL PZ CAPITAL PROJECTS 159,623.53 159,623.53 2,407,000.00 2,247,376.47 6.6 PARK CAPITAL PROJECTS 19-0467-02-00 PARK CAPITAL PROJECTS FY22 .00 .00 200,000.00 200,000.00 .0 TOTAL PARK CAPITAL PROJECTS .00 .00 200,000.00 200,000.00 .0 PW CAPITAL PROJECTS 19-0469-09-00 PW CAPITAL PROJECTS FY22 .00 .00 250,000.00 250,000.00 .0 TOTAL PW CAPITAL PROJECTS .00 .00 250,000.00 250,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 .00 .00 3,400,000.00 3,400,000.00 .0 19-0486-01-01 ARPA, SOFTWARE PURCHASES 19,050.00 19,050.00 .00 ( 19,050.00).0 19-0486-01-02 ARPA, MISC LEGAL 1,090.75 1,090.75 .00 ( 1,090.75).0 19-0486-01-03 ARPA, FIBER EQUIPMENT 603,171.00 603,171.00 .00 ( 603,171.00).0 19-0486-02-00 ARPA, FIBER NETWORK CONNECT 73,551.33 73,551.33 3,250,000.00 3,176,448.67 2.3 TOTAL FEDERAL FUNDS PROJECTS 696,863.08 696,863.08 6,650,000.00 5,953,136.92 10.5 TOTAL FUND EXPENDITURES 3,029,879.49 3,029,879.49 20,949,134.00 17,919,254.51 14.5 NET REVENUE OVER EXPENDITURES ( 2,938,890.36)( 2,938,890.36).00 2,938,890.36 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 ARTS COMMISSION FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 42 ASSETS 21-0101-00-00 CASH 17,850.74 TOTAL ASSETS 17,850.74 LIABILITIES AND EQUITY FUND EQUITY 21-0271-00-00 FUND BALANCE 24,558.04 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 6,707.30) BALANCE - CURRENT DATE ( 6,707.30) TOTAL FUND EQUITY 17,850.74 TOTAL LIABILITIES AND EQUITY 17,850.74 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 ARTS COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 43 REVENUE 21-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 44,901.00 44,901.00 .0 21-0376-07-00 DONATIONS .00 .00 500.00 500.00 .0 21-0376-09-00 SCHOLARSHIPS .00 .00 500.00 500.00 .0 21-0376-11-00 GALLERY MAINTENANCE 150.00 150.00 500.00 350.00 30.0 21-0376-12-00 POSTCARD REVENUE 6.00 6.00 300.00 294.00 2.0 21-0390-00-00 CARRY OVER .00 .00 30,719.00 30,719.00 .0 TOTAL FUND REVENUE 156.00 156.00 77,420.00 77,264.00 .2 EXPENDITURES ADMINISTRATION 21-0420-00-00 ADMINISTRATION .00 .00 8,000.00 8,000.00 .0 21-0420-01-00 POSTCARD EXPENDITURES .00 .00 300.00 300.00 .0 TOTAL ADMINISTRATION .00 .00 8,300.00 8,300.00 .0 ART EDUCATION 21-0421-00-00 ART EDUCATION & ADVOCACY 5,672.00 5,672.00 15,000.00 9,328.00 37.8 TOTAL ART EDUCATION 5,672.00 5,672.00 15,000.00 9,328.00 37.8 ART INSTALLATION 21-0422-00-00 ARTS IN PUBLIC SPACES/BEAUTIFY 91.30 91.30 33,120.00 33,028.70 .3 TOTAL ART INSTALLATION 91.30 91.30 33,120.00 33,028.70 .3 ACQUISITION OF ART 21-0423-00-00 ACQUISITION OF ART 600.00 600.00 1,500.00 900.00 40.0 TOTAL ACQUISITION OF ART 600.00 600.00 1,500.00 900.00 40.0 COMMUNITY EVENTS 21-0425-00-00 COMMUNITY EVENTS 500.00 500.00 18,000.00 17,500.00 2.8 TOTAL COMMUNITY EVENTS 500.00 500.00 18,000.00 17,500.00 2.8 GALLERY MTNC/SUPPLIES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 ARTS COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 44 21-0427-00-00 GALLERY MTNC/SLUPPLIES .00 .00 1,500.00 1,500.00 .0 TOTAL GALLERY MTNC/SUPPLIES .00 .00 1,500.00 1,500.00 .0 TOTAL FUND EXPENDITURES 6,863.30 6,863.30 77,420.00 70,556.70 8.9 NET REVENUE OVER EXPENDITURES ( 6,707.30)( 6,707.30).00 6,707.30 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 PUBLIC WORKS FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 45 ASSETS 23-0151-00-00 INVESTMENTS 82,705.30 TOTAL ASSETS 82,705.30 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 23,174.44 23-0217-08-00 GARNISHMENT ( 1,162.50) 23-0217-09-00 WORKERS' COMPENSATION 100,658.77 23-0217-10-00 HSA CONTRIBUTION ( 1,160.00) TOTAL LIABILITIES 124,161.74 FUND EQUITY 23-0271-00-00 FUND BALANCE 587,726.71 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 629,183.15) BALANCE - CURRENT DATE ( 629,183.15) TOTAL FUND EQUITY ( 41,456.44) TOTAL LIABILITIES AND EQUITY 82,705.30 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 46 REVENUE 23-0302-00-00 FUNDING FROM GENERAL FUND .00 .00 2,167,755.00 2,167,755.00 .0 23-0303-00-00 VENDOR LEASE PAYMENTS, PARKS .00 .00 3,000.00 3,000.00 .0 23-0315-01-00 SANITATION SERVICES .00 .00 25,000.00 25,000.00 .0 23-0315-02-00 SIDEWALKS, LTS, TREES, STR-REP .00 .00 150,000.00 150,000.00 .0 23-0315-06-00 TREE FUNDS .00 .00 29,511.00 29,511.00 .0 23-0315-09-00 WYCLIFF PUMP STATION .00 .00 6,690.00 6,690.00 .0 23-0316-00-00 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 23-0316-01-00 MEMORIAL DONATIONS 2,918.10 2,918.10 6,000.00 3,081.90 48.6 TOTAL FUND REVENUE 2,918.10 2,918.10 2,388,256.00 2,385,337.90 .1 EXPENDITURES ADMINISTRATION 23-0413-01-00 OFFICE SUPPLIES .00 .00 1,000.00 1,000.00 .0 23-0413-02-00 PRINTING AND PUBLISHING .00 .00 1,000.00 1,000.00 .0 23-0413-03-00 LEGAL, ADV, PUBLICATION 1,920.36 1,920.36 7,500.00 5,579.64 25.6 23-0413-04-00 TRAINING 7,383.96 7,383.96 15,500.00 8,116.04 47.6 23-0413-05-00 TRAVEL & PER DIEM 438.22 438.22 6,725.00 6,286.78 6.5 23-0413-06-00 PROFESSIONAL DUES 30.00 30.00 2,500.00 2,470.00 1.2 23-0413-09-00 UNIFORMS 450.00 450.00 5,500.00 5,050.00 8.2 23-0413-10-00 PUBLIC RELATIONS .00 .00 1,000.00 1,000.00 .0 TOTAL ADMINISTRATION 10,222.54 10,222.54 40,725.00 30,502.46 25.1 GEN MAINTENANCE & REPAIR 23-0414-01-00 DO NOT USE 283.98 283.98 .00 ( 283.98).0 23-0414-02-00 MISC MTNC & REPAIR GROUNDS 11,120.57 11,120.57 40,000.00 28,879.43 27.8 23-0414-03-00 MATERIALS AND SUPPLIES 20,325.67 20,325.67 47,000.00 26,674.33 43.3 23-0414-04-00 HOLIDAY LIGHTING 3,800.00 3,800.00 7,000.00 3,200.00 54.3 23-0414-05-00 PAPER PRODUCTS 17,470.34 17,470.34 40,000.00 22,529.66 43.7 23-0414-06-00 BACK FLOW PARTS REPLACEMENT .00 .00 5,000.00 5,000.00 .0 23-0414-07-01 MTNC/RPR SNOW EQUIPMENT 250.00 250.00 5,000.00 4,750.00 5.0 23-0414-08-00 SIGNS & SIGN REPLACEMENT 755.00 755.00 5,000.00 4,245.00 15.1 23-0414-10-00 ROOF MAINTENANCE .00 .00 3,000.00 3,000.00 .0 23-0414-11-00 HVAC MAINTENANCE 1,184.02 1,184.02 2,500.00 1,315.98 47.4 23-0414-12-00 EMERGENCY REPAIRS 5,035.00 5,035.00 25,000.00 19,965.00 20.1 TOTAL GEN MAINTENANCE & REPAIR 60,224.58 60,224.58 179,500.00 119,275.42 33.6 PW RESTRICTED FUNDS 23-0415-02-00 SIDEWALKS, LTS, TREES, STR-REP .00 .00 150,000.00 150,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 47 TOTAL PW RESTRICTED FUNDS .00 .00 150,000.00 150,000.00 .0 CONTRACTS & AGREEMENTS 23-0416-00-00 WYCLIFFE PUMP STATION 729.62 729.62 6,690.00 5,960.38 10.9 23-0416-01-00 FARMERS UNION 1,300.74 1,300.74 1,200.00 ( 100.74)108.4 23-0416-02-00 EAST ENTRY SIGN 339.11 339.11 1,000.00 660.89 33.9 23-0416-03-00 SCENIC BYWAY .00 .00 154.00 154.00 .0 23-0416-07-00 CHAUMONT LEASE AGREEMENT 1.00 1.00 1.00 .00 100.0 23-0416-08-00 BASELINE MANAGER AGREEMENT .00 .00 3,500.00 3,500.00 .0 23-0416-09-00 NEW DRY CREEK DITCH CO 306.00 306.00 1,000.00 694.00 30.6 23-0416-10-00 BALLANTYNE/BOISE VALLEY DITCH .00 .00 2,000.00 2,000.00 .0 TOTAL CONTRACTS & AGREEMENTS 2,676.47 2,676.47 15,545.00 12,868.53 17.2 VEHICLES 23-0417-01-00 VEHICLE MTNC & REPAIR 3,442.21 3,442.21 17,000.00 13,557.79 20.3 23-0417-02-00 GAS AND OIL 9,989.61 9,989.61 25,000.00 15,010.39 40.0 23-0417-05-00 VEHICLE CAR WASH 18.00 18.00 2,200.00 2,182.00 .8 TOTAL VEHICLES 13,449.82 13,449.82 44,200.00 30,750.18 30.4 PROGRAMS 23-0418-03-00 MEMORIALS, MTNC/REPAIR 2,318.10 2,318.10 6,000.00 3,681.90 38.6 TOTAL PROGRAMS 2,318.10 2,318.10 6,000.00 3,681.90 38.6 FLOWER BASKETS 23-0419-01-00 MATERIALS & SUPPLIES .00 .00 2,000.00 2,000.00 .0 23-0419-02-00 FLOWERS .00 .00 15,000.00 15,000.00 .0 TOTAL FLOWER BASKETS .00 .00 17,000.00 17,000.00 .0 EQUIPMENT MTNC & REPAIR 23-0420-00-00 MTNC/REPAIR EQUIPMENT 7,745.08 7,745.08 10,000.00 2,254.92 77.5 TOTAL EQUIPMENT MTNC & REPAIR 7,745.08 7,745.08 10,000.00 2,254.92 77.5 SUSTAINABILITY-CONSERVATION 23-0421-01-00 SANITATION SERVICES 11,621.50 11,621.50 54,000.00 42,378.50 21.5 23-0421-02-00 TREE FUNDS .00 .00 29,511.00 29,511.00 .0 23-0421-03-00 TREE VOUCHER PROGRAM .00 .00 15,000.00 15,000.00 .0 23-0421-04-00 ARBOR DAY, TREE CITY USA GRANT .00 .00 300.00 300.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 48 TOTAL SUSTAINABILITY-CONSERVATION 11,621.50 11,621.50 98,811.00 87,189.50 11.8 FLEET MANAGEMENT 23-0423-00-00 VEHICLE REPLACEMENT .00 .00 83,700.00 83,700.00 .0 TOTAL FLEET MANAGEMENT .00 .00 83,700.00 83,700.00 .0 PERSONNEL 23-0433-10-00 SALARIES-FULL TIME 237,523.05 237,523.05 654,000.00 416,476.95 36.3 23-0433-10-01 SALARIES - PERSONNEL SERVICES 7,237.32 7,237.32 .00 ( 7,237.32).0 23-0433-11-00 OVERTIME 4,134.67 4,134.67 18,600.00 14,465.33 22.2 23-0433-15-00 SALARIES-PART TIME 659.16 659.16 .00 ( 659.16).0 23-0433-16-00 SALARIES-SEASONAL 27,695.56 27,695.56 195,400.00 167,704.44 14.2 23-0433-21-00 FICA 20,105.53 20,105.53 66,500.00 46,394.47 30.2 23-0433-22-00 PERSI 29,449.57 29,449.57 78,500.00 49,050.43 37.5 23-0433-24-00 WORKERS' COMPENSATION 10,700.26 10,700.26 .00 ( 10,700.26).0 23-0433-25-00 INSURANCE 30,402.23 30,402.23 142,500.00 112,097.77 21.3 23-0433-26-00 HSA CONTRIBUTION 1,720.00 1,720.00 15,600.00 13,880.00 11.0 23-0433-27-00 HRA BUY-DOWN .00 .00 7,700.00 7,700.00 .0 TOTAL PERSONNEL 369,627.35 369,627.35 1,178,800.00 809,172.65 31.4 SHOP 23-0440-00-00 SHOP LEASE 14,897.68 14,897.68 27,000.00 12,102.32 55.2 23-0440-02-00 UTILTIES 1,563.07 1,563.07 3,750.00 2,186.93 41.7 TOTAL SHOP 16,460.75 16,460.75 30,750.00 14,289.25 53.5 STREET LIGHTS 23-0441-01-00 MAINTENANCE & REPAIR 123.00 123.00 8,000.00 7,877.00 1.5 23-0441-02-00 UTILITIES 13,510.38 13,510.38 55,000.00 41,489.62 24.6 TOTAL STREET LIGHTS 13,633.38 13,633.38 63,000.00 49,366.62 21.6 CITY HALL 23-0442-01-00 BLDG MAINTENANCE & REPAIR 1,240.00 1,240.00 2,500.00 1,260.00 49.6 23-0442-02-00 MTNC & REPAIR GROUNDS .00 .00 1,500.00 1,500.00 .0 23-0442-04-00 UTILITIES 18,690.23 18,690.23 40,000.00 21,309.77 46.7 TOTAL CITY HALL 19,930.23 19,930.23 44,000.00 24,069.77 45.3 SENIOR CENTER 23-0443-01-00 BLDG MAINTENANCE & REPAIR 510.40 510.40 2,500.00 1,989.60 20.4 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 49 23-0443-02-00 MTNC & REPAIR GROUNDS .00 .00 1,500.00 1,500.00 .0 TOTAL SENIOR CENTER 510.40 510.40 4,000.00 3,489.60 12.8 LIBRARY 23-0444-01-00 BLDG MAINTENANCE & REPAIR 9,837.96 9,837.96 5,000.00 ( 4,837.96)196.8 23-0444-02-00 MTNC & REPAIR GROUNDS .00 .00 2,000.00 2,000.00 .0 TOTAL LIBRARY 9,837.96 9,837.96 7,000.00 ( 2,837.96)140.5 MUSEUM 23-0445-01-00 BLDG MAINTENANCE & REPAIR 4,029.18 4,029.18 2,500.00 ( 1,529.18)161.2 TOTAL MUSEUM 4,029.18 4,029.18 2,500.00 ( 1,529.18)161.2 ARBORETUM PARK 23-0446-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0446-02-00 EQUIPMENT MTNC & REPAIRS .00 .00 500.00 500.00 .0 23-0446-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0446-04-00 UTILITIES 14.62 14.62 1,000.00 985.38 1.5 TOTAL ARBORETUM PARK 14.62 14.62 2,500.00 2,485.38 .6 FLAG PLAZA 23-0447-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0447-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0447-03-00 GROUNDS - MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0447-04-00 UTILTIES 59.05 59.05 225.00 165.95 26.2 TOTAL FLAG PLAZA 59.05 59.05 1,725.00 1,665.95 3.4 FRIENDSHIP PARK 23-0448-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0448-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0448-03-00 GROUNDS MTNC & REPAIR .00 .00 2,500.00 2,500.00 .0 23-0448-04-00 UTILITIES 358.84 358.84 3,000.00 2,641.16 12.0 TOTAL FRIENDSHIP PARK 358.84 358.84 6,500.00 6,141.16 5.5 GUERBER PARK 23-0449-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 .00 6,500.00 6,500.00 .0 23-0449-02-00 EQUIPMENT MTNC & REPAIR 1,582.00 1,582.00 1,500.00 ( 82.00)105.5 23-0449-03-00 GROUNDS MTNC & REPAIR 19.98 19.98 5,000.00 4,980.02 .4 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 50 23-0449-04-00 UTILITIES 6,023.88 6,023.88 24,000.00 17,976.12 25.1 TOTAL GUERBER PARK 7,625.86 7,625.86 37,000.00 29,374.14 20.6 HERITAGE PARK 23-0450-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 2,000.00 2,000.00 .0 23-0450-02-00 EQUIPMENT MTNC & REPAIR 36.98 36.98 1,500.00 1,463.02 2.5 23-0450-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0450-04-00 UTILTIES 1,380.55 1,380.55 3,000.00 1,619.45 46.0 TOTAL HERITAGE PARK 1,417.53 1,417.53 7,000.00 5,582.47 20.3 MCDONALDS PARK/PATHWAY 23-0451-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0451-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0451-03-00 GROUNDS MTNC & REPAIR .00 .00 1,000.00 1,000.00 .0 TOTAL MCDONALDS PARK/PATHWAY .00 .00 2,000.00 2,000.00 .0 MERRILL PARK 23-0452-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 6,500.00 6,500.00 .0 23-0452-02-00 EQUIPMENT MTNC & REPAIR .00 .00 1,500.00 1,500.00 .0 23-0452-03-00 GROUNDS MTNC & REPAIR .00 .00 5,000.00 5,000.00 .0 23-0452-04-00 UTILITIES 6,352.56 6,352.56 9,500.00 3,147.44 66.9 TOTAL MERRILL PARK 6,352.56 6,352.56 22,500.00 16,147.44 28.2 ORVAL KRASEN PARK 23-0453-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0453-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0453-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0453-04-00 UTILITIES 1,141.09 1,141.09 2,000.00 858.91 57.1 TOTAL ORVAL KRASEN PARK 1,141.09 1,141.09 3,500.00 2,358.91 32.6 SPORTS COMPLEX 23-0454-01-00 BLDGS/STRUCTURES MTNC & REPAIR 1,721.67 1,721.67 2,500.00 778.33 68.9 23-0454-02-00 EQUIPMENT MTNC & REPAIR 1,669.25 1,669.25 1,000.00 ( 669.25)166.9 23-0454-03-00 GROUNDS MTNC & REPAIR .00 .00 1,000.00 1,000.00 .0 23-0454-04-00 UTILITIES 11,690.13 11,690.13 20,000.00 8,309.87 58.5 TOTAL SPORTS COMPLEX 15,081.05 15,081.05 24,500.00 9,418.95 61.6 TOWN ENTRANCE SIGNS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 51 23-0455-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0455-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0455-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0455-04-00 UTILITIES 1,518.04 1,518.04 21,000.00 19,481.96 7.2 TOTAL TOWN ENTRANCE SIGNS 1,518.04 1,518.04 22,500.00 20,981.96 6.8 PLAZA DRIVE 23-0456-02-00 EQUIPMENT MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0456-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0456-04-00 UTILITIES 870.35 870.35 1,500.00 629.65 58.0 TOTAL PLAZA DRIVE 870.35 870.35 2,500.00 1,629.65 34.8 PAMELA BAKER PARK 23-0459-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0459-02-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0459-03-00 EQUIPMENT MTNC/REPAIR .00 .00 500.00 500.00 .0 23-0459-04-00 UTILITIES 5,456.54 5,456.54 5,000.00 ( 456.54)109.1 TOTAL PAMELA BAKER PARK 5,456.54 5,456.54 6,500.00 1,043.46 84.0 CAPITAL EQUIPMENT 23-0460-00-00 TOOLS 2,165.69 2,165.69 5,000.00 2,834.31 43.3 23-0460-01-00 EQUIPMENT 18,104.02 18,104.02 85,000.00 66,895.98 21.3 TOTAL CAPITAL EQUIPMENT 20,269.71 20,269.71 90,000.00 69,730.29 22.5 CITY LANDSCAPE MAINTENANCE 23-0462-00-00 EQUIPMENT RENTAL 3,476.89 3,476.89 7,500.00 4,023.11 46.4 23-0462-01-00 SPRAYING/FERTILIZING 6,235.00 6,235.00 48,000.00 41,765.00 13.0 23-0462-02-00 SAFETY EQUIPMENT .00 .00 1,000.00 1,000.00 .0 23-0462-03-00 DUMPING-DISPOSAL 512.56 512.56 5,000.00 4,487.44 10.3 TOTAL CITY LANDSCAPE MAINTENANCE 10,224.45 10,224.45 61,500.00 51,275.55 16.6 LINDER ROAD RESTROOM 23-0463-01-00 BLDG/STRUCTURES MTNC REPAIR 737.50 737.50 1,000.00 262.50 73.8 23-0463-02-00 EQUIPMENT MTNC-REPAIR .00 .00 500.00 500.00 .0 23-0463-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0463-04-00 UTILITIES 1,548.38 1,548.38 6,000.00 4,451.62 25.8 TOTAL LINDER ROAD RESTROOM 2,285.88 2,285.88 8,000.00 5,714.12 28.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 52 TRAILS 23-0464-00-00 GROUNDS MTNC/REPAIR .00 .00 5,000.00 5,000.00 .0 23-0464-01-00 EQUIPMENT RENTAL 296.41 296.41 4,000.00 3,703.59 7.4 TOTAL TRAILS 296.41 296.41 9,000.00 8,703.59 3.3 FISCAL YEAR CAPITAL PROJECTS 23-0480-15-00 LANDSCAPE UPGRADES - PARKS 9,253.62 9,253.62 25,000.00 15,746.38 37.0 TOTAL FISCAL YEAR CAPITAL PROJECTS 9,253.62 9,253.62 25,000.00 15,746.38 37.0 FY 21/22 PROJECTS 23-0483-01-00 CAPITAL PROJECTS FY22 7,588.31 7,588.31 80,500.00 72,911.69 9.4 TOTAL FY 21/22 PROJECTS 7,588.31 7,588.31 80,500.00 72,911.69 9.4 TOTAL FUND EXPENDITURES 632,101.25 632,101.25 2,388,256.00 1,756,154.75 26.5 NET REVENUE OVER EXPENDITURES ( 629,183.15)( 629,183.15).00 629,183.15 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 RECREATION - EAGLE FUN DAYS FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 53 LIABILITIES AND EQUITY LIABILITIES 24-0217-00-00 FUND BALANCE ( 23,706.58) TOTAL LIABILITIES ( 23,706.58) FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 23,706.58 BALANCE - CURRENT DATE 23,706.58 TOTAL FUND EQUITY 23,706.58 TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 54 REVENUE 24-0301-00-00 FUNDING FROM GENERAL FUND 23,706.58 23,706.58 90,000.00 66,293.42 26.3 24-0303-00-00 SPONSORSHIPS .00 .00 21,000.00 21,000.00 .0 24-0303-01-00 CAR SHOW .00 .00 3,300.00 3,300.00 .0 24-0303-02-00 CORNHOLE .00 .00 1,250.00 1,250.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 23,706.58 23,706.58 145,550.00 121,843.42 16.3 EXPENDITURES ADMIN EXPENDITURES 24-0401-01-00 PARADE CONTRACTOR .00 .00 10,000.00 10,000.00 .0 24-0401-03-00 FIREWORKS .00 .00 20,000.00 20,000.00 .0 24-0401-04-00 ADVERTISEMENT .00 .00 12,000.00 12,000.00 .0 24-0401-05-00 MUSIC & ENTERTAINMENT .00 .00 10,000.00 10,000.00 .0 24-0401-06-00 SUPPLIES .00 .00 6,000.00 6,000.00 .0 24-0401-07-00 EQUIPMENT .00 .00 6,000.00 6,000.00 .0 TOTAL ADMIN EXPENDITURES .00 .00 64,000.00 64,000.00 .0 LOGISTICS 24-0410-00-00 PORTA POTTIES .00 .00 2,000.00 2,000.00 .0 24-0410-01-00 SUPPLIES .00 .00 2,500.00 2,500.00 .0 24-0410-02-00 TRAFFIC BARRIERS & CONTROL .00 .00 8,000.00 8,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 2,500.00 2,500.00 .0 24-0410-07-00 SECURITY .00 .00 7,000.00 7,000.00 .0 24-0410-09-00 EQUIPMENT .00 .00 1,500.00 1,500.00 .0 TOTAL LOGISTICS .00 .00 35,500.00 35,500.00 .0 FUN RUN 24-0420-01-00 PROMOTIONS .00 .00 2,000.00 2,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 3,400.00 3,400.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 55 CAR SHOW 24-0430-00-00 MARKETING/ADVERTISING .00 .00 100.00 100.00 .0 24-0430-01-00 DASH PLAQUES .00 .00 300.00 300.00 .0 24-0430-02-00 TROPHIES .00 .00 2,500.00 2,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 .00 4,850.00 4,850.00 .0 CORNHOLE 24-0440-00-00 BUILDING/PAINT SUPPLIES .00 .00 200.00 200.00 .0 24-0440-01-00 ARTIST .00 .00 300.00 300.00 .0 24-0440-02-00 BEAN BAGS .00 .00 300.00 300.00 .0 TOTAL CORNHOLE .00 .00 800.00 800.00 .0 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 17,000.00 17,000.00 .0 TOTAL ROCKY MOUNTAIN OYSTER FEED .00 .00 37,000.00 37,000.00 .0 TOTAL FUND EXPENDITURES .00 .00 145,550.00 145,550.00 .0 NET REVENUE OVER EXPENDITURES 23,706.58 23,706.58 .00 ( 23,706.58).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 PATHWAY IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 56 ASSETS 25-0101-00-00 CASH 24,797.00 25-0151-25-00 FIRST INTERSTATE INVESTMENT 793,193.91 TOTAL ASSETS 817,990.91 LIABILITIES AND EQUITY FUND EQUITY 25-0271-00-00 FUND BALANCE 763,927.09 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 54,063.82 BALANCE - CURRENT DATE 54,063.82 TOTAL FUND EQUITY 817,990.91 TOTAL LIABILITIES AND EQUITY 817,990.91 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 PATHWAY IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 57 REVENUE 25-0322-19-00 DEVELOPMENT IMPACT FEE 53,871.50 53,871.50 198,300.00 144,428.50 27.2 25-0371-25-00 BANK INTEREST 675.32 675.32 1,080.00 404.68 62.5 25-0390-00-00 CARRY OVER .00 .00 702,268.00 702,268.00 .0 TOTAL FUND REVENUE 54,546.82 54,546.82 901,648.00 847,101.18 6.1 EXPENDITURES CAPITAL IMPROVEMENTS 25-0438-00-00 CAPITAL IMPROVEMENTS 483.00 483.00 801,648.00 801,165.00 .1 25-0438-01-00 EAGLE ISLAND ST PK CONNECTION .00 .00 100,000.00 100,000.00 .0 TOTAL CAPITAL IMPROVEMENTS 483.00 483.00 901,648.00 901,165.00 .1 TOTAL FUND EXPENDITURES 483.00 483.00 901,648.00 901,165.00 .1 NET REVENUE OVER EXPENDITURES 54,063.82 54,063.82 .00 ( 54,063.82).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 58 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 ( 357.33) 26-0217-09-00 WORKERS' COMPENSATION 726.57 TOTAL LIABILITIES 1,324.82 FUND EQUITY 26-0271-00-00 FUND BALANCE ( 1,747.65) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 422.83 BALANCE - CURRENT DATE 422.83 TOTAL FUND EQUITY ( 1,324.82) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 59 REVENUE 26-0301-00-00 MONTHLY TRANSFER TO DEPTS 97,034.51 97,034.51 212,056.00 115,021.49 45.8 TOTAL FUND REVENUE 97,034.51 97,034.51 212,056.00 115,021.49 45.8 EXPENDITURES ADMINISTRATION 26-0413-05-00 OFFICE SUPPLIES 101.61 101.61 500.00 398.39 20.3 26-0413-06-00 DUPLICATION/PUBLISHING/PRINTIN 163.90 163.90 1,500.00 1,336.10 10.9 26-0413-12-00 TRAINING 500.00 500.00 6,895.00 6,395.00 7.3 26-0413-13-00 TRAVEL & PER DIEM 15.00 15.00 6,400.00 6,385.00 .2 26-0413-14-00 PROFESSIONAL DUES 475.00 475.00 4,281.00 3,806.00 11.1 26-0413-19-00 COMMUNICATIONS 8,512.76 8,512.76 12,200.00 3,687.24 69.8 26-0413-29-00 UNIFORMS .00 .00 200.00 200.00 .0 TOTAL ADMINISTRATION 9,768.27 9,768.27 31,976.00 22,207.73 30.6 PERSONNEL 26-0415-10-00 SALARIES- FULL TIME 66,666.18 66,666.18 135,500.00 68,833.82 49.2 26-0415-21-00 FICA 5,086.83 5,086.83 10,400.00 5,313.17 48.9 26-0415-22-00 PERSI 7,960.01 7,960.01 16,300.00 8,339.99 48.8 26-0415-23-00 HRA BUY-DOWN .00 .00 3,080.00 3,080.00 .0 26-0415-24-00 WORKERS' COMPENSATION 126.65 126.65 .00 ( 126.65).0 26-0415-25-00 INSURANCE 7,003.74 7,003.74 14,800.00 7,796.26 47.3 TOTAL PERSONNEL 86,843.41 86,843.41 180,080.00 93,236.59 48.2 TOTAL FUND EXPENDITURES 96,611.68 96,611.68 212,056.00 115,444.32 45.6 NET REVENUE OVER EXPENDITURES 422.83 422.83 .00 ( 422.83).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 LAW ENF DEV IMPACT FEES FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 60 ASSETS 27-0101-00-00 CASH 15,988.08 27-0151-25-00 FIRST INTERSTATE INVESTMENTS 50,031.71 TOTAL ASSETS 66,019.79 LIABILITIES AND EQUITY FUND EQUITY 27-0271-00-00 POLICE IMPACT FEE/FUND BALANCE 42,529.49 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 23,490.30 BALANCE - CURRENT DATE 23,490.30 TOTAL FUND EQUITY 66,019.79 TOTAL LIABILITIES AND EQUITY 66,019.79 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 LAW ENF DEV IMPACT FEES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 61 REVENUE 27-0322-19-00 RESIDENTIAL IMPACT FEES 23,488.08 23,488.08 66,600.00 43,111.92 35.3 27-0322-20-00 COMMERCIAL - IMPACT FEES .00 .00 30,000.00 30,000.00 .0 27-0371-25-00 BANK INTEREST 2.22 2.22 100.00 97.78 2.2 27-0390-00-00 CARRY OVER .00 .00 45,000.00 45,000.00 .0 TOTAL FUND REVENUE 23,490.30 23,490.30 141,700.00 118,209.70 16.6 EXPENDITURES CAPITAL IMPROVEMENTS 27-0438-00-00 EQUIPMENT .00 .00 70,850.00 70,850.00 .0 27-0438-01-00 CITY FACILITY .00 .00 70,850.00 70,850.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 .00 141,700.00 141,700.00 .0 TOTAL FUND EXPENDITURES .00 .00 141,700.00 141,700.00 .0 NET REVENUE OVER EXPENDITURES 23,490.30 23,490.30 .00 ( 23,490.30).0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 CITY HALL BOND FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 62 LIABILITIES AND EQUITY FUND EQUITY 54-0271-00-00 FUND BALANCE 3,405.22 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 3,405.22) BALANCE - CURRENT DATE ( 3,405.22) TOTAL FUND EQUITY .00 TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 CITY HALL BOND FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 63 REVENUE 54-0399-01-00 FUNDING FROM GENERAL FUND 7,843.95 7,843.95 102,950.00 95,106.05 7.6 TOTAL FUND REVENUE 7,843.95 7,843.95 102,950.00 95,106.05 7.6 EXPENDITURES BOND PAYMENTS 54-0480-81-00 PRINCIPAL BOND PAYMENT .00 .00 80,000.00 80,000.00 .0 54-0480-82-00 INTEREST BOND PAYMENT 11,249.17 11,249.17 22,500.00 11,250.83 50.0 54-0480-84-00 PAYING AGENT FEE .00 .00 450.00 450.00 .0 TOTAL BOND PAYMENTS 11,249.17 11,249.17 102,950.00 91,700.83 10.9 TOTAL FUND EXPENDITURES 11,249.17 11,249.17 102,950.00 91,700.83 10.9 NET REVENUE OVER EXPENDITURES ( 3,405.22)( 3,405.22).00 3,405.22 .0 CITY OF EAGLE BALANCE SHEET MARCH 31, 2022 WATER FUND FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 64 ASSETS 60-0101-00-00 CASH 566,511.33 60-0115-00-00 WATER/ACCOUNTS RECEIVABLE 130,102.70 60-0151-01-00 DEQ LOAN INV (COLL/PMTS)492,987.79 60-0151-02-00 DEQ RESERVE FUND INV 182,000.00 60-0151-25-00 FIRST INTERSTATE INVESTMENT 4,069,750.69 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.&( 172,451.00) 60-0164-00-00 WATER/IMPROVEMENTS-OTHER THAN 12,593,065.00 60-0165-00-00 WATER/ACCUM. DEP.-IMPROVEMENTS ( 3,518,225.00) 60-0166-00-00 WATER/MACHINERY & EQUIPMENT 1,394,602.00 60-0167-00-00 WATER/ACCUMULATED DEPREC-EQUIP ( 915,756.00) 60-0170-00-00 HRA 10% DEPOSIT 550.08 60-0171-00-00 DEFERRED OUTFLOWS-PENSION 82,423.00 TOTAL ASSETS 15,558,095.59 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 15,099.00 60-0216-00-00 ACCRUED PAYROLL 6,081.88 60-0217-00-00 COMPENSATED ABSENCE PAYABLE 13,084.04 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 9,353.44 60-0217-08-00 GARNISHMENTS 1,162.50 60-0217-09-00 WORKERS' COMPENSATION 57,498.58 60-0217-10-00 HSA CONTRIBUTION ( 100.00) 60-0217-11-00 NET PENSION LIABILITY ( 5,717.00) 60-0217-12-00 DEFERRED INFLOWS-PENSION 182,893.00 60-0220-00-00 WATER/SERVICE DEPOSITS 96,275.00 60-0231-00-00 DEQ LOAN 1,115,023.00 TOTAL LIABILITIES 1,496,375.47 FUND EQUITY 60-0271-00-00 WATER/FUND BALANCE 13,156,448.78 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 905,271.34 BALANCE - CURRENT DATE 905,271.34 TOTAL FUND EQUITY 14,061,720.12 TOTAL LIABILITIES AND EQUITY 15,558,095.59 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 65 REVENUE 60-0346-57-00 RESERVE, REPAIR/ MAINTENANCE .00 .00 150,000.00 150,000.00 .0 60-0346-58-00 RESERVE, EQUIP/BLDG REPLCMNT .00 .00 225,000.00 225,000.00 .0 60-0346-59-00 STL-SUPPLY TRUNK LINE FEE 799,052.31 799,052.31 105,000.00 ( 694,052.31)761.0 60-0346-59-01 STL-CARRY FORWARD, PREVIOUS FY .00 .00 629,200.00 629,200.00 .0 60-0346-60-00 HOOK UP FEES CITY 109,970.00 109,970.00 157,500.00 47,530.00 69.8 60-0346-65-00 RESERVE, EMERGENCY REPL ITEMS .00 .00 150,000.00 150,000.00 .0 60-0346-66-00 RESERVE, VEHICLE REPLACEMENT .00 .00 60,000.00 60,000.00 .0 60-0346-67-00 RESERVE, FOR BUDGET .00 .00 310,000.00 310,000.00 .0 60-0347-01-00 BILLING REVENUE 588,456.79 588,456.79 1,158,396.00 569,939.21 50.8 60-0347-02-00 OTHER REVENUE 3,680.00 3,680.00 8,400.00 4,720.00 43.8 60-0347-03-00 RECONNECT FEES 75.00 75.00 600.00 525.00 12.5 60-0347-04-00 DELINQUENT FEES 5,116.50 5,116.50 8,736.00 3,619.50 58.6 60-0347-05-00 MISCELLANEOUS REVENUE 5,915.05 5,915.05 7,500.00 1,584.95 78.9 60-0347-06-00 SYSTEM ENHANCEMENT FEE 219,883.04 219,883.04 400,000.00 180,116.96 55.0 60-0355-01-00 WCE-WATER CONST EQUIV FEE 20,000.00 20,000.00 20,000.00 .00 100.0 60-0371-25-00 BANK INTEREST 3,562.50 3,562.50 6,000.00 2,437.50 59.4 60-0390-00-00 WATER FUND CARRY OVER .00 .00 171,047.00 171,047.00 .0 TOTAL FUND REVENUE 1,755,711.19 1,755,711.19 3,567,379.00 1,811,667.81 49.2 EXPENDITURES CONTRACTS/AGREEMENT 60-0416-07-00 SHOP LEASE 1,983.32 1,983.32 .00 ( 1,983.32).0 TOTAL CONTRACTS/AGREEMENT 1,983.32 1,983.32 .00 ( 1,983.32).0 VEHICLE OPERATIONS - LEASES 60-0420-01-00 GAS AND OIL 3,810.93 3,810.93 15,000.00 11,189.07 25.4 60-0420-03-00 VEHICLE MTNC & REPAIR 2,214.11 2,214.11 9,000.00 6,785.89 24.6 TOTAL VEHICLE OPERATIONS - LEASES 6,025.04 6,025.04 24,000.00 17,974.96 25.1 PERSONNEL 60-0433-10-00 SALARIES-FULL TIME 152,391.31 152,391.31 372,000.00 219,608.69 41.0 60-0433-10-02 ON-CALL TIME 1,223.35 1,223.35 7,500.00 6,276.65 16.3 60-0433-11-00 OVERTIME 745.29 745.29 4,500.00 3,754.71 16.6 60-0433-21-00 FICA 11,532.51 11,532.51 29,400.00 17,867.49 39.2 60-0433-22-00 PERSI 18,350.67 18,350.67 45,900.00 27,549.33 40.0 60-0433-23-00 HRA BUY-DOWN .00 .00 7,700.00 7,700.00 .0 60-0433-23-01 HRA/COBRA ADMIN FEES .00 .00 800.00 800.00 .0 60-0433-24-00 WORKERS' COMPENSATION 10,197.04 10,197.04 13,500.00 3,302.96 75.5 60-0433-25-00 INSURANCE 21,304.41 21,304.41 58,500.00 37,195.59 36.4 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 66 60-0433-26-00 HSA CONTRIBUTIONS 1,200.00 1,200.00 2,400.00 1,200.00 50.0 60-0433-29-00 PTO CASH OUT .00 .00 15,000.00 15,000.00 .0 TOTAL PERSONNEL 216,944.58 216,944.58 557,200.00 340,255.42 38.9 OPERATIONS & MAINTENANCE 60-0434-15-00 OFFICE SUPPLIES 712.34 712.34 1,800.00 1,087.66 39.6 60-0434-19-00 TELECOMMUNICATIONS/SCADA ( 1,352.24)( 1,352.24)10,836.00 12,188.24 ( 12.5) 60-0434-20-00 ADVERTISING - PUBLICATIONS .00 .00 2,000.00 2,000.00 .0 60-0434-22-00 TRAVEL-MTNGS-EDUCATION 1,075.00 1,075.00 8,000.00 6,925.00 13.4 60-0434-23-00 DUES & SUBSCRIPTIONS 139.00 139.00 3,100.00 2,961.00 4.5 60-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE 4,149.28 4,149.28 7,800.00 3,650.72 53.2 60-0434-26-00 TOOLS, EQUIPMENT AND SUPPS 3,539.84 3,539.84 10,000.00 6,460.16 35.4 60-0434-27-00 POSTAGE .00 .00 1,300.00 1,300.00 .0 60-0434-41-00 LIABILITY INSURANCE 4,620.00 4,620.00 4,620.00 .00 100.0 60-0434-42-00 ENGINEERING SERVICES 4,390.08 4,390.08 35,000.00 30,609.92 12.5 60-0434-42-01 LEGAL SERVICES 1,002.50 1,002.50 25,000.00 23,997.50 4.0 60-0434-42-02 MISC LEGAL AND ENG SERVICES 3,838.25 3,838.25 145,920.00 142,081.75 2.6 60-0434-43-01 CONTRACT SERVICES (REPAIR).00 .00 35,000.00 35,000.00 .0 60-0434-44-00 DIG LINE 1,854.58 1,854.58 4,500.00 2,645.42 41.2 60-0434-45-00 CITY AUDITOR SERVICES 2,500.00 2,500.00 2,500.00 .00 100.0 60-0434-47-00 MAIL SERVICE-CUSTOMER BILLING 12,168.42 12,168.42 28,800.00 16,631.58 42.3 60-0434-50-00 SHOP LEASE 4,683.32 4,683.32 13,400.00 8,716.68 35.0 60-0434-50-01 SHOP UTILITIES 824.89 824.89 4,800.00 3,975.11 17.2 60-0434-53-01 PUBLIC WATER DRINKING FEES 12,112.00 12,112.00 12,800.00 688.00 94.6 60-0434-53-03 PERMITS AND FEES .00 .00 1,500.00 1,500.00 .0 60-0434-58-00 RPR/MTNC-LINES-METERS-ETC 1,664.99 1,664.99 40,000.00 38,335.01 4.2 60-0434-58-01 RPR/MTNC PUMPS-WELLS-CHEMICAL 4,015.92 4,015.92 50,000.00 45,984.08 8.0 60-0434-59-00 CHEMICALS 4,896.88 4,896.88 9,000.00 4,103.12 54.4 60-0434-60-00 POWER 19,447.25 19,447.25 55,000.00 35,552.75 35.4 60-0434-68-00 UNIFORMS 647.70 647.70 2,300.00 1,652.30 28.2 60-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 .00 25,000.00 25,000.00 .0 TOTAL OPERATIONS & MAINTENANCE 86,930.00 86,930.00 539,976.00 453,046.00 16.1 TESTING-WK-MO-QTR-ANNUAL 60-0435-56-00 TESTING-WK-MO-QTR-ANNUAL 9,527.00 9,527.00 12,000.00 2,473.00 79.4 TOTAL TESTING-WK-MO-QTR-ANNUAL 9,527.00 9,527.00 12,000.00 2,473.00 79.4 DEQ REVOLVING LOAN PAYMENT 60-0436-01-00 DEQ/STATE REVOLVING LOAN PMT 400,000.00 400,000.00 400,000.00 .00 100.0 TOTAL DEQ REVOLVING LOAN PAYMENT 400,000.00 400,000.00 400,000.00 .00 100.0 RESTRICTED FUNDS 60-0437-01-00 WATER SYS EXPANSION-STL FEES 34,754.00 34,754.00 100,000.00 65,246.00 34.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 6 MONTHS ENDING MARCH 31, 2022 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 50 % OF THE FISCAL YEAR HAS ELAPSED 04/12/2022 04:04PM PAGE: 67 60-0437-02-00 RESERVE STL FEES-RESV, TRNK LN .00 .00 35,000.00 35,000.00 .0 60-0437-03-00 REFUND OF STL FEES .00 .00 50,000.00 50,000.00 .0 TOTAL RESTRICTED FUNDS 34,754.00 34,754.00 185,000.00 150,246.00 18.8 CAPITAL EXPENDITURES 60-0438-01-00 EQUIPMENT 4,850.00 4,850.00 9,950.00 5,100.00 48.7 60-0438-02-00 RESERVE, WATER SYSTEM R&M .00 .00 175,000.00 175,000.00 .0 60-0438-03-00 RESERVE--EQUIP, BLDG REPLCMNT .00 .00 250,000.00 250,000.00 .0 60-0438-04-00 RESERVE FOR SPECIFIED PROJECTS .00 .00 20,000.00 20,000.00 .0 60-0438-05-01 CURRENT STL PROJECTS .00 .00 549,200.00 549,200.00 .0 60-0438-05-02 HORSESHOE BND1-GREENBROOK 5,827.36 5,827.36 .00 ( 5,827.36).0 60-0438-06-00 RESERVE FOR BUDGET .00 .00 325,000.00 325,000.00 .0 60-0438-08-00 CAPITAL METER SETS (NEW CUST)43,439.68 43,439.68 86,250.00 42,810.32 50.4 60-0438-10-00 WATER MASTER PLAN-UPDATE 12,880.00 12,880.00 40,000.00 27,120.00 32.2 60-0438-11-00 CAPITAL CONSTRUCTION PROJECTS 17,675.87 17,675.87 134,000.00 116,324.13 13.2 60-0438-18-00 RESERVE, EMERGENCY REPL ITEMS .00 .00 175,000.00 175,000.00 .0 60-0438-20-00 RESERVE, VEHICLE REPLACEMENT .00 .00 72,000.00 72,000.00 .0 60-0438-82-00 ROOM AND BOARD AT CITY HALL 9,603.00 9,603.00 12,803.00 3,200.00 75.0 TOTAL CAPITAL EXPENDITURES 94,275.91 94,275.91 1,849,203.00 1,754,927.09 5.1 TOTAL FUND EXPENDITURES 850,439.85 850,439.85 3,567,379.00 2,716,939.15 23.8 NET REVENUE OVER EXPENDITURES 905,271.34 905,271.34 .00 ( 905,271.34).0