Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Finance - Quarterly Reports - FY 21/22 1st Quarter - 12/31/2021
CITY OF EAGLEQUARTERLY TREASURER'S REPORT FOR THE PERIOD ENDING DECEMBER 31, 2021 BEGINNING CASH ANNUAL %ANNUAL %CHANGE IN ENDING CASH FUND NUMBER AND TITLE BALANCE REVENUES REALIZED EXPENDITURES EXPENDED BALANCE SHEET BALANCE 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 12:00PM PAGE: 1 01 GENERAL FUND 640,585.60 3,860,254.18 22.28 2,277,190.85 13.14 ( 121,182.38) 2,344,831.31 06 LIBRARY FUND ( 43,479.61)8,679.13 .42 279,269.52 13.48 ( 304,475.22) ( 9,594.78) 07 MUSEUM FUND 46,900.01 251.92 .16 36,203.82 23.08 488.73 10,459.38 08 PARK IMPACT FEE FUND 212,713.17 88,656.54 1.56 .00 .00 244,343.55 57,026.16 09 RECREATION - SPECIAL EVENTS 152,178.59 4,547.04 1.70 39,737.03 14.85 ( 956.32)117,944.92 10 EAGLE HISTORICAL COMMISSION 19,283.33 1,733.52 19.26 .00 .00 .00 21,016.85 11 EXECUTIVE DEPARTMENT .00 66,716.38 16.68 68,487.47 17.12 ( 1,771.09).00 12 CITY CLERK/TREAS DEPARTMENT .00 147,472.39 23.54 142,316.69 22.71 5,155.70 .00 13 BUILDING DEPARTMENT .00 269,533.28 23.31 225,755.92 19.52 43,777.36 .00 14 P&Z DEPARTMENT .00 261,059.28 21.50 248,741.60 20.49 12,317.68 .00 17 RECREATION - PARKS AND REC 168,969.85 36,814.35 5.55 117,855.76 17.78 11,767.34 76,161.10 18 IT DEPARTMENT .00 175,549.83 19.64 148,285.23 16.59 27,264.60 .00 19 CAPITAL PROJECTS FUND 3,038,014.38 89,874.48 .43 1,588,338.41 7.58 13,096.11 1,526,454.34 21 ARTS COMMISSION 24,558.04 .00 .00 1,191.30 1.54 .00 23,366.74 23 PUBLIC WORKS .00 .00 .00 332,939.99 13.94 ( 332,939.99).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 26,103.71 2.90 .00 .00 121,610.65 7,187.50 26 ECONOMIC DEVELOPMENT .00 55,712.89 26.27 54,452.29 25.68 1,260.60 .00 27 LAW ENF DEV IMPACT FEES 8,614.24 13,214.08 9.33 .00 .00 16,115.24 5,713.08 54 CITY HALL BOND FUND 3,405.22 .00 .00 .00 .00 .00 3,405.22 60 WATER FUND 945,182.58 624,646.86 17.51 457,656.17 12.83 543,905.62 568,267.65 99 COMBINED CASH FUND ( 5,295,913.26).00 .00 .00 .00 ( 543,673.79) ( 4,752,239.47) TOTAL .00 5,754,526.44 6,018,422.05 ( 263,895.61).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, January 25, 2022 CITY OF EAGLE COMBINED CASH INVESTMENT DECEMBER 31, 2021 FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:50AM PAGE: 1 COMBINED CASH ACCOUNTS 99-0103-00-00 CASH IN CHECKING 4,600,684.45 99-0108-00-00 CASH CLEARING-ACCOUNTS REC 151,555.02 TOTAL COMBINED CASH 4,752,239.47 99-0101-00-00 CASH ALLOCATED TO OTHER FUNDS ( 4,752,239.47) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 2,344,831.31 6 ALLOCATION TO LIBRARY FUND ( 9,594.78) 7 ALLOCATION TO MUSEUM FUND 10,459.38 8 ALLOCATION TO PARK IMPACT FEE FUND 57,026.16 9 ALLOCATION TO RECREATION - SPECIAL EVENTS 117,944.92 10 ALLOCATION TO EAGLE HISTORICAL COMMISSION 21,016.85 17 ALLOCATION TO RECREATION - PARKS AND REC 76,161.10 19 ALLOCATION TO CAPITAL PROJECTS FUND 1,526,454.34 21 ALLOCATION TO ARTS COMMISSION 23,366.74 25 ALLOCATION TO PATHWAY IMPACT FEE FUND 7,187.50 27 ALLOCATION TO LAW ENF DEV IMPACT FEES 5,713.08 54 ALLOCATION TO CITY HALL BOND FUND 3,405.22 60 ALLOCATION TO WATER FUND 568,267.65 TOTAL ALLOCATIONS TO OTHER FUNDS 4,752,239.47 ALLOCATION FROM COMBINED CASH FUND - 99-0101-00-00 ( 4,752,239.47) ZERO PROOF IF ALLOCATIONS BALANCE .00 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 GENERAL FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:50AM PAGE: 2 ASSETS 01-0101-00-00 CASH 2,344,831.31 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 4,984,811.32 01-0151-28-00 ICCU CD 50,966.19 01-0170-00-00 HRA 10 % DEPOSIT 5,785.92 TOTAL ASSETS 8,264,478.65 LIABILITIES AND EQUITY LIABILITIES 01-0202-00-00 VOUCHERS PAYABLE ( 3,542.16) 01-0203-00-00 ACCTS PAYABLE-ACHD IMPACT FEES 73,818.00 01-0203-01-01 BONDS DEPOSITS PAYABLE 2,514,064.03 01-0203-01-02 FIREWORKS BOND DEPOSIT PAYABLE ( 2,000.00) 01-0203-01-03 VENDORS BOND DEPOSITS PAYABLE 5,939.00 01-0203-01-05 P&Z DEPOSITS PAYABLE 205,624.00 01-0203-01-06 LAND USE DEPOSITS PAYABLE 50,966.19 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,483.61 01-0226-00-00 DEFERRED REVENUE 12,637.20 TOTAL LIABILITIES 2,846,795.47 FUND EQUITY 01-0271-00-00 FUND BALANCE 3,834,619.85 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,583,063.33 BALANCE - CURRENT DATE 1,583,063.33 TOTAL FUND EQUITY 5,417,683.18 TOTAL LIABILITIES AND EQUITY 8,264,478.65 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:50AM 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 2,989.12 2,989.12 2,708,042.00 2,705,052.88 .1 01-0311-01-00 PENALTY/INTEREST ON TAXES 427.54 427.54 3,000.00 2,572.46 14.3 01-0312-00-00 PERSONAL PROPERTY TAX REIMBURS .00 .00 8,463.00 8,463.00 .0 01-0316-10-00 FRANCHISE FEE/EAGLE WATER CO.1,102.92 1,102.92 5,000.00 3,897.08 22.1 01-0316-10-02 FRANCHISE FEE/SUEZ 3,518.21 3,518.21 15,000.00 11,481.79 23.5 01-0316-11-00 FRANCHISE FEE/INTERMTN GAS 24,503.11 24,503.11 270,000.00 245,496.89 9.1 01-0316-12-00 FRANCHISE FEE/CABLE TV 28,674.51 28,674.51 112,000.00 83,325.49 25.6 01-0316-13-00 FRANCHISE FEE/TRASH 89,320.09 89,320.09 275,000.00 185,679.91 32.5 01-0316-14-00 FRANCHISE FEE/IDAHO POWER 87,355.92 87,355.92 212,000.00 124,644.08 41.2 01-0321-10-00 ALCOHOLIC BEVERAGE LICENSES 575.00 575.00 30,000.00 29,425.00 1.9 01-0321-30-00 BUSINESS LICENSE FEE 825.00 825.00 16,500.00 15,675.00 5.0 01-0322-10-00 BUILDING & INSPECTION PERMITS 346,039.32 346,039.32 1,770,000.00 1,423,960.68 19.6 01-0322-12-00 PLAN REVIEW FEES 140,256.80 140,256.80 525,000.00 384,743.20 26.7 01-0322-13-00 ENERGY STANDARDS (IRES)4,700.00 4,700.00 30,000.00 25,300.00 15.7 01-0322-14-00 ELECTRICAL INSPECT FEE 79,669.43 79,669.43 252,000.00 172,330.57 31.6 01-0322-15-00 PLUMBING INSPECTION FEES 59,550.03 59,550.03 252,000.00 192,449.97 23.6 01-0322-16-00 MECHANICAL INSPECTION FEES 91,572.59 91,572.59 252,000.00 160,427.41 36.3 01-0322-20-00 FIRE IMPACT ADMIN FEES 2,660.00 2,660.00 12,000.00 9,340.00 22.2 01-0323-01-00 PZ ANNEX/ZONING PERMIT FEES 80,512.46 80,512.46 210,000.00 129,487.54 38.3 01-0323-02-00 INSPECTION FEES 450.00 450.00 8,000.00 7,550.00 5.6 01-0323-03-00 PLAN REVIEW FEES 7,100.00 7,100.00 40,000.00 32,900.00 17.8 01-0323-04-00 STREET LIGHT INSPECTION FEES 430.00 430.00 1,200.00 770.00 35.8 01-0323-05-00 SURETY/LETTER OF CREDIT FEES 1,350.00 1,350.00 4,000.00 2,650.00 33.8 01-0323-06-00 GRADING-DRAINAGE PERMIT FEES 3,400.00 3,400.00 16,000.00 12,600.00 21.3 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-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 132,518.00 132,518.00 678,514.00 545,996.00 19.5 01-0335-50-00 STATE SALES TAX 4.75 4.75 .00 ( 4.75).0 01-0335-60-00 STATE REVENUE SHARING 727,844.62 727,844.62 3,019,563.00 2,291,718.38 24.1 01-0338-40-00 COURT FEES 9,206.94 9,206.94 30,000.00 20,793.06 30.7 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 617.00 617.00 4,000.00 3,383.00 15.4 01-0341-12-00 ANIMAL CONTROL FEES 1,851.00 1,851.00 12,000.00 10,149.00 15.4 01-0341-13-00 ENGINEERING FEES-DEVELOPERS 53,130.75 53,130.75 150,000.00 96,869.25 35.4 01-0341-14-00 ATTORNEY FEES - DEVELOPER .00 .00 15,000.00 15,000.00 .0 01-0341-17-00 CID STAFF & MISC REIMBURSEMENT 1,457.08 1,457.08 1,000.00 ( 457.08)145.7 01-0341-20-00 REIMBURSE WATER DEPARTMENT 3,201.00 3,201.00 12,803.00 9,602.00 25.0 01-0341-26-00 BACKGROUND CHECKS 111.00 111.00 1,500.00 1,389.00 7.4 01-0341-27-00 URA CITY STAFF REIMBURSEMENT 354.52 354.52 4,800.00 4,445.48 7.4 01-0341-28-00 ID POWER SUBSTATION WATER USE .00 .00 120.00 120.00 .0 01-0341-29-00 REVEL EAGLE-EASEMENT-MERRILL P .00 .00 1,000.00 1,000.00 .0 01-0350-05-00 FIELD OF HONOR .00 .00 10,000.00 10,000.00 .0 01-0350-07-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 01-0371-25-00 BANK INVESTMENT INTEREST 2,281.66 2,281.66 7,000.00 4,718.34 32.6 01-0379-00-00 MISCELLANEOUS 474.03 474.03 1,000.00 525.97 47.4 01-0379-01-00 DUPLICATION/PUBLISHING/PRINTNG 137.00 137.00 500.00 363.00 27.4 01-0382-02-00 PROMOTIONAL SALES 485.00 485.00 .00 ( 485.00).0 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:50AM PAGE: 4 01-0383-05-00 MISCELLANEOUS-REIMBURSEABLES 8,501.06 8,501.06 1,500.00 ( 7,001.06)566.7 01-0383-09-00 ROOM RESERVATIONS 100.00 100.00 600.00 500.00 16.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 20.00 20.00 .00 ( 20.00).0 01-0385-00-00 FIRE DEPT IMPACT FEES 110,961.72 110,961.72 538,200.00 427,238.28 20.6 TOTAL FUND REVENUE 3,860,254.18 3,860,254.18 17,328,023.00 13,467,768.82 22.3 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM 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,050.00 1,050.00 4,200.00 3,150.00 25.0 01-0413-02-00 DESIGN REVIEW BRD COMPENSATION 960.00 960.00 5,000.00 4,040.00 19.2 01-0413-05-00 OFFICE EXPENSES 3,062.46 3,062.46 25,000.00 21,937.54 12.3 01-0413-06-00 PRINTING & DISTRIBUTION 19.50 19.50 2,500.00 2,480.50 .8 01-0413-07-00 POSTAGE 2,751.65 2,751.65 9,000.00 6,248.35 30.6 01-0413-08-00 LEGAL ADVERTISING/PUBLICATION 898.30 898.30 8,000.00 7,101.70 11.2 01-0413-10-00 INSURANCE - PROPERTY 25,719.00 25,719.00 57,000.00 31,281.00 45.1 01-0413-12-00 PERSONNEL TRAINING 65.00 65.00 3,000.00 2,935.00 2.2 01-0413-13-00 TRAVEL & PER DIEM .00 .00 2,000.00 2,000.00 .0 01-0413-14-00 PROFESSIONAL DUES AND SERVICES 51,421.35 51,421.35 163,827.00 112,405.65 31.4 01-0413-25-00 MISCELLANEOUS 74.99 74.99 40,000.00 39,925.01 .2 01-0413-28-00 RESOURCE MATERIALS 519.77 519.77 4,500.00 3,980.23 11.6 01-0413-29-00 REAL PROPERTY TAXES/CITY 224.00 224.00 225.00 1.00 99.6 01-0413-31-00 ENGINEERING FEE/DEVELOPER CHGS 42,832.10 42,832.10 150,000.00 107,167.90 28.6 01-0413-33-00 ATTORNEY FEE-CHARGE DEVELOPERS ( 15,944.10)( 15,944.10)15,000.00 30,944.10 (106.3) 01-0413-37-00 BACKGROUND CHECK-PERMITS/LIC 519.53 519.53 1,250.00 730.47 41.6 01-0413-44-00 PHOTOS - MAYOR/CITY COUNCIL .00 .00 900.00 900.00 .0 01-0413-46-00 PROPERTY TAX EXP -3%.00 .00 250.00 250.00 .0 01-0413-50-00 JOB POSTINGS .00 .00 6,000.00 6,000.00 .0 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 224.00 224.00 1,500.00 1,276.00 14.9 TOTAL ADMINISTRATION 114,624.04 114,624.04 500,652.00 386,027.96 22.9 PERSONNEL 01-0415-11-00 SALARIES-COUNCIL 12,720.00 12,720.00 50,880.00 38,160.00 25.0 01-0415-21-00 FICA 973.08 973.08 4,500.00 3,526.92 21.6 01-0415-22-00 PERSI 1,518.72 1,518.72 6,200.00 4,681.28 24.5 01-0415-23-01 HRA/COBRA ADMIN FEES 141.64 141.64 1,800.00 1,658.36 7.9 01-0415-24-00 WORKERS' COMPENSATION 38,092.11 38,092.11 54,374.00 16,281.89 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 TOTAL PERSONNEL 53,515.31 53,515.31 129,854.00 76,338.69 41.2 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 6 CONTRACTS & AGREEMENTS 01-0416-02-00 CITY ATTORNEY 19,976.00 19,976.00 250,000.00 230,024.00 8.0 01-0416-02-02 LITIGATION ATTORNEYS FEES 2,159.50 2,159.50 50,000.00 47,840.50 4.3 01-0416-05-00 PROSECUTOR 16,003.00 16,003.00 65,500.00 49,497.00 24.4 01-0416-06-00 IDAHO HUMANE SOCIETY 36,143.74 36,143.74 144,575.00 108,431.26 25.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 4,938.00 4,938.00 21,000.00 16,062.00 23.5 01-0416-09-00 LAW ENFORCEMENT DEPARTMENT 893,173.12 893,173.12 3,572,672.00 2,679,498.88 25.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 8,445.50 8,445.50 200,000.00 191,554.50 4.2 01-0416-46-00 ALLUMBAUGH HOUSE 4,437.25 4,437.25 17,749.00 13,311.75 25.0 01-0416-49-00 DRUGFREE IDAHO 384.15 384.15 1,090.00 705.85 35.2 01-0416-54-00 IDAHO SUICIDE PREVENTION .00 .00 10,000.00 10,000.00 .0 01-0416-55-00 EAGLE SENIOR CENTER 12,500.00 12,500.00 50,000.00 37,500.00 25.0 01-0416-56-00 CRIME STOPPERS 3,500.00 3,500.00 3,500.00 .00 100.0 TOTAL CONTRACTS & AGREEMENTS 1,001,660.26 1,001,660.26 5,971,086.00 4,969,425.74 16.8 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 .00 .00 3,800.00 3,800.00 .0 TOTAL CONTINUING EDUCATION .00 .00 3,800.00 3,800.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 7 PUBLIC AFFAIRS/COMM RELATIONS 01-0462-01-00 PUBLIC RELATIONS 637.51 637.51 6,000.00 5,362.49 10.6 01-0462-02-00 AWARDS & RECOGNITIONS 769.20 769.20 1,500.00 730.80 51.3 01-0462-03-00 CITY BRANDING/LOGO .00 .00 5,000.00 5,000.00 .0 TOTAL PUBLIC AFFAIRS/COMM RELATIONS 1,406.71 1,406.71 12,500.00 11,093.29 11.3 GENERAL FUND TRANSFERS 01-0463-01-00 MUSEUM DEPT TRANSFER .00 .00 142,185.00 142,185.00 .0 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 66,716.38 66,716.38 400,030.00 333,313.62 16.7 01-0463-12-00 CITY HALL BOND FUND TRANSFER .00 .00 102,950.00 102,950.00 .0 01-0463-12-01 CLERK/TREAS DEPT TRANSFER 147,472.39 147,472.39 626,550.00 479,077.61 23.5 01-0463-13-01 BUILDING DEPT TRANSFER 269,533.28 269,533.28 1,156,430.00 886,896.72 23.3 01-0463-14-01 PLANNING AND ZONING DEPT TRANS 261,059.28 261,059.28 1,214,100.00 953,040.72 21.5 01-0463-18-01 IT DEPT TRANSFER 175,549.83 175,549.83 893,820.00 718,270.17 19.6 01-0463-26-01 ECONOMIC DEV DEPT TRANSFER 55,712.89 55,712.89 212,056.00 156,343.11 26.3 TOTAL GENERAL FUND TRANSFERS 999,750.63 999,750.63 9,427,660.00 8,427,909.37 10.6 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 91,824.48 91,824.48 538,200.00 446,375.52 17.1 TOTAL FIRE DEPARTMENT IMPACT FEES 91,824.48 91,824.48 538,200.00 446,375.52 17.1 TOTAL FUND EXPENDITURES 2,277,190.85 2,277,190.85 17,328,023.00 15,050,832.15 13.1 NET REVENUE OVER EXPENDITURES 1,583,063.33 1,583,063.33 .00 ( 1,583,063.33).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 LIBRARY FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 8 ASSETS 06-0101-00-00 LIBRARY/CASH ( 9,594.78) 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 613,241.76 06-0170-00-00 HRA 10% DEPOSIT 1,872.00 TOTAL ASSETS 614,984.76 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 4,530.62 06-0217-09-00 WORKERS' COMPENSATION 12,946.34 06-0217-10-00 HSA CONTRIBUTION 2,454.00 06-0226-00-00 DEFERRED REVENUE 7,786.25 TOTAL LIABILITIES 53,308.03 FUND EQUITY 06-0271-00-00 LIBRARY/FUND BALANCE 832,267.12 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 270,590.39) BALANCE - CURRENT DATE ( 270,590.39) TOTAL FUND EQUITY 561,676.73 TOTAL LIABILITIES AND EQUITY 614,984.76 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 9 REVENUE 06-0356-00-00 LIBRARY/PROPERTY TAX REVENUE 1,878.14 1,878.14 1,492,845.00 1,490,966.86 .1 06-0356-01-00 LIBRARY/PENALTY & INT PROP TXS 279.90 279.90 1,000.00 720.10 28.0 06-0361-20-00 LIBRARY/FINES/FEES 679.81 679.81 .00 ( 679.81).0 06-0361-20-01 LOST ITEMS 1,272.34 1,272.34 2,500.00 1,227.66 50.9 06-0361-21-00 LIBRARY/COPY MACHINE REVENUE 251.64 251.64 3,600.00 3,348.36 7.0 06-0361-21-01 3 D PRINTING .00 .00 400.00 400.00 .0 06-0371-25-00 BANK INTEREST 326.38 326.38 700.00 373.62 46.6 06-0379-00-00 MISCELLANEOUS 3,990.92 3,990.92 750.00 ( 3,240.92)532.1 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 8,679.13 8,679.13 2,071,835.00 2,063,155.87 .4 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 1,609.41 1,609.41 14,570.00 12,960.59 11.1 TOTAL CONTRACTS/AGREEMENTS 1,609.41 1,609.41 24,570.00 22,960.59 6.6 OPERATIONS & MAINTENANCE 06-0420-01-00 ADMINISTRATION 1,198.09 1,198.09 15,000.00 13,801.91 8.0 06-0420-03-00 OPERATIONS SUBSCRIPTIONS 9,243.80 9,243.80 41,310.00 32,066.20 22.4 06-0420-04-00 MARKETING 5,685.59 5,685.59 11,300.00 5,614.41 50.3 06-0420-04-01 OUTREACH 20.51 20.51 2,500.00 2,479.49 .8 06-0420-05-00 OFFICE SUPPLIES 1,688.74 1,688.74 9,373.00 7,684.26 18.0 06-0420-05-01 MATERIAL PROCESSING SUPPLIES 193.36 193.36 8,000.00 7,806.64 2.4 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 .00 .00 2,500.00 2,500.00 .0 06-0420-11-00 SUBSCRIPTIONS & MEMBERSHIPS 257.79 257.79 11,000.00 10,742.21 2.3 06-0420-13-00 PRINTING AND PUBLISHING .00 .00 1,500.00 1,500.00 .0 TOTAL OPERATIONS & MAINTENANCE 21,530.43 21,530.43 138,982.00 117,451.57 15.5 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 10 LYNX1 CONSORTIUM 06-0430-00-00 LYNK! SYSTEM .00 .00 24,192.00 24,192.00 .0 06-0430-02-00 LYNX! COURIER 2,592.30 2,592.30 11,600.00 9,007.70 22.4 TOTAL LYNX1 CONSORTIUM 2,592.30 2,592.30 35,792.00 33,199.70 7.2 COST RECOVERY OR PASS THRU 06-0435-00-00 CREDIT CARD PROCESSING FEE 892.66 892.66 2,700.00 1,807.34 33.1 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 265.64 265.64 1,200.00 934.36 22.1 TOTAL COST RECOVERY OR PASS THRU 1,181.30 1,181.30 8,200.00 7,018.70 14.4 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 19,030.81 19,030.81 136,301.00 117,270.19 14.0 06-0450-01-00 PRINT VENDOR PROCESSING 1,613.69 1,613.69 6,000.00 4,386.31 26.9 06-0450-02-00 BOOKS -DIGITAL 2,110.50 2,110.50 61,919.00 59,808.50 3.4 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 19,486.82 19,486.82 74,057.00 54,570.18 26.3 06-0450-05-00 MEDIA - DIGITAL 573.00 573.00 61,609.00 61,036.00 .9 06-0450-06-00 DATABASES 5,176.00 5,176.00 11,050.00 5,874.00 46.8 06-0450-07-00 HOTSPOT 539.79 539.79 5,562.00 5,022.21 9.7 TOTAL GUEST RESOURCES 55,874.98 55,874.98 372,024.00 316,149.02 15.0 GUEST CLASSES & EVENTS 06-0455-00-00 CLASSES & EVENTS 2,597.32 2,597.32 25,000.00 22,402.68 10.4 TOTAL GUEST CLASSES & EVENTS 2,597.32 2,597.32 25,000.00 22,402.68 10.4 PERSONNEL 06-0461-10-00 SALARIES - FULL TIME 93,558.05 93,558.05 453,000.00 359,441.95 20.7 06-0461-10-01 SALARIES - PERSONNEL SERVICES 4,983.92 4,983.92 .00 ( 4,983.92).0 06-0461-11-00 OVERTIME 1,406.32 1,406.32 5,000.00 3,593.68 28.1 06-0461-15-00 SALARIES - PART TIME 48,087.49 48,087.49 221,600.00 173,512.51 21.7 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 11 06-0461-21-00 FICA 10,763.74 10,763.74 51,990.00 41,226.26 20.7 06-0461-22-00 PERSI 11,338.84 11,338.84 54,050.00 42,711.16 21.0 06-0461-23-00 HRA BUY-DOWN .00 .00 5,500.00 5,500.00 .0 06-0461-23-01 HRA/COBRA ADMIN FEES 141.66 141.66 900.00 758.34 15.7 06-0461-24-00 WORKERS' COMPENSATION 1,432.00 1,432.00 5,476.00 4,044.00 26.2 06-0461-25-00 INSURANCE 9,222.99 9,222.99 67,788.00 58,565.01 13.6 06-0461-26-00 HSA CONTRIBUTION 630.00 630.00 5,760.00 5,130.00 10.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 181,565.01 181,565.01 910,604.00 729,038.99 19.9 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 5,552.21 5,552.21 27,000.00 21,447.79 20.6 06-0464-03-00 TELEPHONE 557.04 557.04 2,000.00 1,442.96 27.9 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 253.05 253.05 1,500.00 1,246.95 16.9 TOTAL FACILITY (BLDGS & GROUNDS)6,897.26 6,897.26 37,500.00 30,602.74 18.4 TOTAL FUND EXPENDITURES 279,269.52 279,269.52 2,071,835.00 1,792,565.48 13.5 NET REVENUE OVER EXPENDITURES ( 270,590.39)( 270,590.39).00 270,590.39 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 MUSEUM FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 12 ASSETS 07-0101-00-00 MUSEUM/CASH 10,459.38 07-0103-00-00 MUSEUM/PETTY CASH 75.00 TOTAL ASSETS 10,534.38 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 883.50 07-0217-09-00 WORKERS' COMPENSATION 1,369.82 TOTAL LIABILITIES 2,740.80 FUND EQUITY 07-0271-00-00 MUSEUM FUND BALANCE 43,745.48 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 35,951.90) BALANCE - CURRENT DATE ( 35,951.90) TOTAL FUND EQUITY 7,793.58 TOTAL LIABILITIES AND EQUITY 10,534.38 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 13 REVENUE 07-0316-12-00 FUNDING FROM GENERAL FUND .00 .00 142,185.00 142,185.00 .0 07-0376-00-00 MUSEUM CONTRIBUTIONS/DONATIONS 176.92 176.92 150.00 ( 26.92)118.0 07-0379-00-00 MUSEUM MISC REVENUE 75.00 75.00 25.00 ( 50.00)300.0 07-0379-02-00 ARCADIA BOOKS SALES/ROYALTIES .00 .00 400.00 400.00 .0 07-0379-03-00 SALES TAX REVENUE .00 .00 5.00 5.00 .0 07-0380-00-00 GIFT SHOP REVENUE .00 .00 100.00 100.00 .0 07-0390-00-00 MUSEUM CARRY OVER .00 .00 14,000.00 14,000.00 .0 TOTAL FUND REVENUE 251.92 251.92 156,865.00 156,613.08 .2 EXPENDITURES PERSONNEL 07-0420-10-00 SALARIES-FULL TIME 14,863.12 14,863.12 57,500.00 42,636.88 25.9 07-0420-15-00 SALARIES - PART TIME 8,436.63 8,436.63 52,500.00 44,063.37 16.1 07-0420-21-00 FICA 1,782.37 1,782.37 7,500.00 5,717.63 23.8 07-0420-22-00 PERSI 1,774.66 1,774.66 6,800.00 5,025.34 26.1 07-0420-24-00 WORKERS' COMPENSATION 44.26 44.26 .00 ( 44.26).0 07-0420-25-00 INSURANCE 1,701.57 1,701.57 7,600.00 5,898.43 22.4 07-0420-27-00 HRA BUY DOWN .00 .00 1,540.00 1,540.00 .0 TOTAL PERSONNEL 28,602.61 28,602.61 133,440.00 104,837.39 21.4 EDUCATION 07-0461-02-00 ASSOCIATION MEMBERSHIP .00 .00 325.00 325.00 .0 07-0461-03-00 CONFERENCES & SEMINARS .00 .00 1,500.00 1,500.00 .0 07-0461-04-00 TRAVEL & PER DIEM .00 .00 3,500.00 3,500.00 .0 TOTAL EDUCATION .00 .00 5,325.00 5,325.00 .0 ADMINISTRATION 07-0462-30-00 CONSERVATION/PRESERVATION .00 .00 1,000.00 1,000.00 .0 07-0462-31-00 OFFICE SUPPLIES 176.72 176.72 .00 ( 176.72).0 07-0462-32-00 ARCHIVAL SUPPLIES .00 .00 1,000.00 1,000.00 .0 07-0462-33-00 PUBLICITY-PRINTING .00 .00 1,000.00 1,000.00 .0 07-0462-34-00 RESEARCH MATERIAL .00 .00 100.00 100.00 .0 07-0462-35-00 UNIFORMS .00 .00 400.00 400.00 .0 07-0462-68-00 MUSEUM PROGRAMS 879.34 879.34 2,000.00 1,120.66 44.0 07-0462-69-00 MISCELLANEOUS 25.00 25.00 200.00 175.00 12.5 07-0462-73-00 EAGLE BOOK-ARCADIA PUBLISHING .00 .00 300.00 300.00 .0 TOTAL ADMINISTRATION 1,081.06 1,081.06 6,000.00 4,918.94 18.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 14 EXHIBITS 07-0463-01-00 DISPLAY SUPPLIES 74.65 74.65 300.00 225.35 24.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 4,046.60 4,046.60 10,000.00 5,953.40 40.5 TOTAL EXHIBITS 6,520.15 6,520.15 11,800.00 5,279.85 55.3 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 36,203.82 36,203.82 156,865.00 120,661.18 23.1 NET REVENUE OVER EXPENDITURES ( 35,951.90)( 35,951.90).00 35,951.90 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 PARK IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 15 ASSETS 08-0101-00-00 PARK IMPACT FEE FUND 57,026.16 08-0151-25-00 FIRST INTERSTATE INVESTMENT 3,732,373.28 TOTAL ASSETS 3,789,399.44 LIABILITIES AND EQUITY FUND EQUITY 08-0271-00-00 PARK FUND/FUND BALANCE 3,700,742.90 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 88,656.54 BALANCE - CURRENT DATE 88,656.54 TOTAL FUND EQUITY 3,789,399.44 TOTAL LIABILITIES AND EQUITY 3,789,399.44 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 PARK IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 16 REVENUE 08-0322-19-00 PARKS DEVELOPMENT IMPACT FEES 87,026.16 87,026.16 669,432.00 582,405.84 13.0 08-0364-01-00 CONTRIBUTIONS AND DONATIONS .00 .00 288,286.00 288,286.00 .0 08-0371-25-00 BANK INTEREST 1,630.38 1,630.38 4,200.00 2,569.62 38.8 08-0390-00-00 PARK FUND / CARRY OVER .00 .00 4,732,830.00 4,732,830.00 .0 TOTAL FUND REVENUE 88,656.54 88,656.54 5,694,748.00 5,606,091.46 1.6 EXPENDITURES CAPITAL IMPROVEMENTS 08-0438-37-00 CAPITAL IMPROVEMENTS .00 .00 5,694,748.00 5,694,748.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 .00 5,694,748.00 5,694,748.00 .0 TOTAL FUND EXPENDITURES .00 .00 5,694,748.00 5,694,748.00 .0 NET REVENUE OVER EXPENDITURES 88,656.54 88,656.54 .00 ( 88,656.54).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 RECREATION - SPECIAL EVENTS FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 17 ASSETS 09-0101-00-00 CASH 117,944.92 TOTAL ASSETS 117,944.92 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 9,483.92 09-0217-09-00 WORKERS' COMPENSATION 12,871.80 09-0217-10-00 HSA CONTRIBUTION 3,319.35 TOTAL LIABILITIES 26,255.61 FUND EQUITY 09-0271-00-00 FUND BALANCE 126,879.30 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 35,189.99) BALANCE - CURRENT DATE ( 35,189.99) TOTAL FUND EQUITY 91,689.31 TOTAL LIABILITIES AND EQUITY 117,944.92 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM 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 .00 .00 825.00 825.00 .0 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 200.00 200.00 1,500.00 1,300.00 13.3 09-0376-17-00 SECURITY DEPOSIT .00 .00 1,200.00 1,200.00 .0 TOTAL FUND REVENUE 4,547.04 4,547.04 267,620.00 263,072.96 1.7 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 20,511.57 20,511.57 118,800.00 98,288.43 17.3 09-0420-11-00 OVERTIME 411.94 411.94 2,000.00 1,588.06 20.6 09-0420-15-00 SALARIES-PART TIME 824.13 824.13 26,700.00 25,875.87 3.1 09-0420-21-00 FICA 1,640.65 1,640.65 11,400.00 9,759.35 14.4 09-0420-22-00 PERSI 2,261.16 2,261.16 14,300.00 12,038.84 15.8 09-0420-24-00 WORKERS' COMPENSATION 679.27 679.27 .00 ( 679.27).0 09-0420-25-00 INSURANCE 1,197.27 1,197.27 15,920.00 14,722.73 7.5 09-0420-26-00 HSA CONTRIBUTION 150.00 150.00 .00 ( 150.00).0 09-0420-29-00 PTO CASH OUT .00 .00 2,500.00 2,500.00 .0 TOTAL PERSONNEL 27,675.99 27,675.99 191,620.00 163,944.01 14.4 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 .00 .00 1,200.00 1,200.00 .0 09-0463-20-00 TRAVEL/PER DIEM .00 .00 4,000.00 4,000.00 .0 09-0463-21-00 PROFESSIONAL DUES .00 .00 2,150.00 2,150.00 .0 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 6.29 6.29 24,750.00 24,743.71 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 19 ACTIVITIES 09-0467-02-00 EAGLE SATURDAY MARKET 810.60 810.60 11,000.00 10,189.40 7.4 09-0467-03-00 CHRISTMAS MARKET 7,239.17 7,239.17 6,500.00 ( 739.17)111.4 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 12,054.75 12,054.75 48,250.00 36,195.25 25.0 TOTAL FUND EXPENDITURES 39,737.03 39,737.03 267,620.00 227,882.97 14.9 NET REVENUE OVER EXPENDITURES ( 35,189.99)( 35,189.99).00 35,189.99 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 EAGLE HISTORICAL COMMISSION FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM 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 3 MONTHS ENDING DECEMBER 31, 2021 EAGLE HISTORICAL COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM 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 DECEMBER 31, 2021 EXECUTIVE DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 22 LIABILITIES AND EQUITY LIABILITIES 11-0216-00-00 ACCRUED PAYROLL 1,750.00 11-0217-03-00 FICA 452.83 11-0217-04-00 EXEC DEPT/PUBLIC RETIREMENT 675.73 11-0217-07-00 EXEC DEPT HEALTH INSURANCE 2,302.02 11-0217-09-00 WORKERS' COMPENSATION 2,888.25 11-0217-10-00 HSA CONTRIBUTION ( 224.00) TOTAL LIABILITIES 7,844.83 FUND EQUITY 11-0271-00-00 FUND BALANCE ( 6,073.74) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 1,771.09) BALANCE - CURRENT DATE ( 1,771.09) TOTAL FUND EQUITY ( 7,844.83) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 23 REVENUE 11-0301-00-00 MONTHLY TRANSFER TO DEPTS 66,716.38 66,716.38 400,030.00 333,313.62 16.7 TOTAL FUND REVENUE 66,716.38 66,716.38 400,030.00 333,313.62 16.7 EXPENDITURES ADMINISTRATION 11-0413-04-00 UNIFORMS .00 .00 300.00 300.00 .0 11-0413-05-00 OFFICE EXPENSES 248.99 248.99 500.00 251.01 49.8 11-0413-12-00 PERSONNEL TRAINING .00 .00 3,500.00 3,500.00 .0 11-0413-13-00 TRAVEL & PER DIEM .00 .00 6,000.00 6,000.00 .0 11-0413-14-00 PROFESSIONAL DUES .00 .00 1,900.00 1,900.00 .0 TOTAL ADMINISTRATION 248.99 248.99 12,200.00 11,951.01 2.0 PERSONNEL 11-0415-10-00 SALARIES-FULL TIME 52,286.00 52,286.00 221,700.00 169,414.00 23.6 11-0415-11-00 OVERTIME 17.92 17.92 500.00 482.08 3.6 11-0415-21-00 FICA 3,875.91 3,875.91 17,100.00 13,224.09 22.7 11-0415-22-00 PERSI 6,245.04 6,245.04 26,700.00 20,454.96 23.4 11-0415-24-00 WORKERS' COMPENSATION 1,077.14 1,077.14 .00 ( 1,077.14).0 11-0415-25-00 INSURANCE 4,382.72 4,382.72 19,300.00 14,917.28 22.7 11-0415-26-00 HSA CONTRIBUTION 180.00 180.00 1,200.00 1,020.00 15.0 11-0415-27-00 PTO CASH OUT .00 .00 10,000.00 10,000.00 .0 11-0415-28-00 HRA BUY-DOWN .00 .00 3,080.00 3,080.00 .0 TOTAL PERSONNEL 68,064.73 68,064.73 299,580.00 231,515.27 22.7 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 .00 .00 83,000.00 83,000.00 .0 TOTAL DEPARTMENT 0418 .00 .00 83,000.00 83,000.00 .0 COMMUNITY & STAFF RELATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 24 11-0422-01-00 COMMUNITY/STAFF RELATIONS 173.75 173.75 3,000.00 2,826.25 5.8 TOTAL COMMUNITY & STAFF RELATIONS 173.75 173.75 3,000.00 2,826.25 5.8 TOTAL FUND EXPENDITURES 68,487.47 68,487.47 400,030.00 331,542.53 17.1 NET REVENUE OVER EXPENDITURES ( 1,771.09)( 1,771.09).00 1,771.09 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 CITY CLERK/TREAS DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM 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 2,515.94 12-0217-09-00 WORKERS' COMPENSATION 6,707.36 TOTAL LIABILITIES 19,857.89 FUND EQUITY 12-0271-00-00 FUND BALANCE ( 25,013.59) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 5,155.70 BALANCE - CURRENT DATE 5,155.70 TOTAL FUND EQUITY ( 19,857.89) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 CITY CLERK/TREAS DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 26 REVENUE 12-0301-00-00 MONTHLY TRANSFER TO DEPTS 147,472.39 147,472.39 626,550.00 479,077.61 23.5 TOTAL FUND REVENUE 147,472.39 147,472.39 626,550.00 479,077.61 23.5 EXPENDITURES ADMINISTRATION 12-0413-05-00 OFFICE EXPENSES 90.42 90.42 1,000.00 909.58 9.0 12-0413-06-00 DUPLICATION/PUBLISHING/PRINTIG .00 .00 200.00 200.00 .0 12-0413-12-00 PERSONNEL TRAINING & RESOURCES 70.00 70.00 10,000.00 9,930.00 .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 330.00 330.00 1,400.00 1,070.00 23.6 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 627.41 627.41 18,850.00 18,222.59 3.3 PERSONNEL 12-0415-10-00 SALARIES- FULL TIME 105,161.97 105,161.97 408,000.00 302,838.03 25.8 12-0415-11-00 OVERTIME 527.23 527.23 3,000.00 2,472.77 17.6 12-0415-15-00 SALARIES-PART TIME .00 .00 16,500.00 16,500.00 .0 12-0415-21-00 FICA 7,695.89 7,695.89 32,800.00 25,104.11 23.5 12-0415-22-00 PERSI 12,357.91 12,357.91 51,200.00 38,842.09 24.1 12-0415-23-00 HRA BUY- DOWN .00 .00 8,000.00 8,000.00 .0 12-0415-23-02 HSA CONTRIBUTION .00 .00 1,200.00 1,200.00 .0 12-0415-24-00 WORKERS' COMPENSATION 200.53 200.53 .00 ( 200.53).0 12-0415-25-00 INSURANCE 15,545.75 15,545.75 82,000.00 66,454.25 19.0 12-0415-26-00 PTO CASH OUT 200.00 200.00 5,000.00 4,800.00 4.0 TOTAL PERSONNEL 141,689.28 141,689.28 607,700.00 466,010.72 23.3 TOTAL FUND EXPENDITURES 142,316.69 142,316.69 626,550.00 484,233.31 22.7 NET REVENUE OVER EXPENDITURES 5,155.70 5,155.70 .00 ( 5,155.70).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 BUILDING DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM 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 1,484.92 13-0217-09-00 WORKERS' COMPENSATION 39,845.30 13-0217-10-00 HSA CONTRIBUTION ( 1,900.00) TOTAL LIABILITIES 47,916.15 FUND EQUITY 13-0271-00-00 FUND BALANCE ( 91,593.51) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 43,777.36 BALANCE - CURRENT DATE 43,777.36 TOTAL FUND EQUITY ( 47,816.15) TOTAL LIABILITIES AND EQUITY 100.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 28 REVENUE 13-0301-00-00 MONTHLY TRANSFER TO DEPTS 269,533.28 269,533.28 1,156,430.00 886,896.72 23.3 TOTAL FUND REVENUE 269,533.28 269,533.28 1,156,430.00 886,896.72 23.3 EXPENDITURES ADMINISTRATION 13-0413-05-00 OFFICE EXPENSES 1,617.64 1,617.64 6,500.00 4,882.36 24.9 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 414.00 414.00 4,400.00 3,986.00 9.4 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 702.15 702.15 1,500.00 797.85 46.8 13-0413-29-00 BUILDING PERMIT REFUNDS 250.00 250.00 .00 ( 250.00).0 13-0413-29-03 MECHANICAL FEE REFUND 2,510.00 2,510.00 500.00 ( 2,010.00)502.0 13-0413-29-04 PLUMBING PERMIT REFUND 905.00 905.00 500.00 ( 405.00)181.0 13-0413-29-05 ELECTRICAL PERMIT REFUND 970.00 970.00 500.00 ( 470.00)194.0 13-0413-30-00 UNIFORMS .00 .00 1,750.00 1,750.00 .0 TOTAL ADMINISTRATION 7,395.79 7,395.79 25,890.00 18,494.21 28.6 PERSONNEL 13-0415-10-00 SALARIES-FULL TIME 82,798.12 82,798.12 407,000.00 324,201.88 20.3 13-0415-11-00 OVERTIME 463.61 463.61 8,000.00 7,536.39 5.8 13-0415-21-00 FICA 6,076.43 6,076.43 31,800.00 25,723.57 19.1 13-0415-22-00 PERSI 9,941.40 9,941.40 49,700.00 39,758.60 20.0 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 2,814.27 2,814.27 .00 ( 2,814.27).0 13-0415-25-00 INSURANCE 14,883.24 14,883.24 87,000.00 72,116.76 17.1 13-0415-26-00 HSA CONTRIBUTION 600.00 600.00 1,200.00 600.00 50.0 13-0415-28-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 TOTAL PERSONNEL 117,702.73 117,702.73 598,940.00 481,237.27 19.7 CONTRACTS & AGREEMENTS 13-0416-09-00 PLUMBING INSPECTOR 25,050.81 25,050.81 150,000.00 124,949.19 16.7 13-0416-11-00 MECHANICAL INSPECTOR 32,447.50 32,447.50 150,000.00 117,552.50 21.6 13-0416-13-00 BLDG INSPECTOR 8,332.00 8,332.00 62,000.00 53,668.00 13.4 13-0416-14-00 PLAN REVIEW - CONTRACT .00 .00 15,000.00 15,000.00 .0 13-0416-25-00 ELECTRICAL INSPECTOR 34,827.09 34,827.09 150,000.00 115,172.91 23.2 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 29 TOTAL CONTRACTS & AGREEMENTS 100,657.40 100,657.40 527,000.00 426,342.60 19.1 VEHICLE OPERATIONS 13-0417-02-00 GAS AND OIL .00 .00 600.00 600.00 .0 13-0417-03-00 VEHICLE REPLACEMENT .00 .00 4,000.00 4,000.00 .0 TOTAL VEHICLE OPERATIONS .00 .00 4,600.00 4,600.00 .0 TOTAL FUND EXPENDITURES 225,755.92 225,755.92 1,156,430.00 930,674.08 19.5 NET REVENUE OVER EXPENDITURES 43,777.36 43,777.36 .00 ( 43,777.36).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 P&Z DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 30 ASSETS 14-0103-00-00 PETTY CASH 50.00 TOTAL ASSETS 50.00 LIABILITIES AND EQUITY LIABILITIES 14-0216-00-00 ACCRUED PAYROLL 9,808.33 14-0217-03-00 FICA 3,391.86 14-0217-04-00 P&Z DEPT/PUBLIC RETIREMENT 5,215.16 14-0217-07-00 P&Z DEPT HEALTH INSURANCE ( 38,551.00) 14-0217-08-00 P&Z DEPT/GARNISHMENTS 203.34 14-0217-09-00 WORKERS' COMPENSATION 67,208.66 TOTAL LIABILITIES 47,276.35 FUND EQUITY 14-0271-00-00 FUND BALANCE ( 59,544.03) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 12,317.68 BALANCE - CURRENT DATE 12,317.68 TOTAL FUND EQUITY ( 47,226.35) TOTAL LIABILITIES AND EQUITY 50.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 31 REVENUE 14-0301-00-00 MONTHLY TRANSFER TO DEPTS 261,059.28 261,059.28 1,214,100.00 953,040.72 21.5 TOTAL FUND REVENUE 261,059.28 261,059.28 1,214,100.00 953,040.72 21.5 EXPENDITURES ADMINISTRATION 14-0413-05-00 OFFICE EXPENSES 157.85 157.85 1,800.00 1,642.15 8.8 14-0413-06-00 DUPLICATION/PUBLISHING/PRNTG .00 .00 1,000.00 1,000.00 .0 14-0413-08-00 LEGAL ADS & PUBLICATIONS 862.29 862.29 8,000.00 7,137.71 10.8 14-0413-12-00 PERSONNEL TRAINING .00 .00 5,100.00 5,100.00 .0 14-0413-13-00 TRAVEL & PER DIEM .00 .00 15,000.00 15,000.00 .0 14-0413-14-00 PROFESSIONAL DUES 684.00 684.00 2,500.00 1,816.00 27.4 14-0413-25-00 MISCELLANEOUS .00 .00 1,000.00 1,000.00 .0 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 3,570.68 3,570.68 43,100.00 39,529.32 8.3 PERSONNEL 14-0415-10-00 SALARIES-FULL TIME 186,532.03 186,532.03 788,000.00 601,467.97 23.7 14-0415-11-00 OVERTIME 496.36 496.36 11,300.00 10,803.64 4.4 14-0415-21-00 FICA 13,939.50 13,939.50 61,500.00 47,560.50 22.7 14-0415-22-00 PERSI 22,331.13 22,331.13 95,600.00 73,268.87 23.4 14-0415-24-00 WORKERS' COMPENSATION 3,046.85 3,046.85 .00 ( 3,046.85).0 14-0415-25-00 INSURANCE 17,950.05 17,950.05 137,000.00 119,049.95 13.1 14-0415-26-00 HSA CONTRIBUTION 400.00 400.00 4,800.00 4,400.00 8.3 14-0415-29-00 PTO CASH OUT .00 .00 15,000.00 15,000.00 .0 14-0415-30-00 HRA BUY- DOWN .00 .00 17,000.00 17,000.00 .0 TOTAL PERSONNEL 244,695.92 244,695.92 1,130,200.00 885,504.08 21.7 CONTRACTS & AGREEMENTS 14-0416-02-00 TRAILS CONSULTANTS-STUDIES .00 .00 20,000.00 20,000.00 .0 14-0416-03-00 PROFESSIONAL SERVICE CONTRACTS 475.00 475.00 10,000.00 9,525.00 4.8 TOTAL CONTRACTS & AGREEMENTS 475.00 475.00 30,000.00 29,525.00 1.6 PUBLIC RELATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 32 14-0422-01-00 PUBLIC RELATIONS .00 .00 200.00 200.00 .0 TOTAL PUBLIC RELATIONS .00 .00 200.00 200.00 .0 CAPITAL OUTLAY 14-0465-03-00 OFFICE EQUIPMENT .00 .00 600.00 600.00 .0 TOTAL CAPITAL OUTLAY .00 .00 600.00 600.00 .0 COMMUNITY PLANNING PROJECTS 14-0468-11-00 OTHER .00 .00 10,000.00 10,000.00 .0 TOTAL COMMUNITY PLANNING PROJECTS .00 .00 10,000.00 10,000.00 .0 TOTAL FUND EXPENDITURES 248,741.60 248,741.60 1,214,100.00 965,358.40 20.5 NET REVENUE OVER EXPENDITURES 12,317.68 12,317.68 .00 ( 12,317.68).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 RECREATION - PARKS AND REC FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 33 ASSETS 17-0101-00-00 CASH 76,161.10 TOTAL ASSETS 76,161.10 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 ( 8,790.87) 17-0217-09-00 WORKERS' COMPENSATION 33,780.61 17-0217-10-00 HSA CONTRIBUTION ( 4,225.93) TOTAL LIABILITIES 23,510.40 FUND EQUITY 17-0271-00-00 FUND BALANCE 133,692.11 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 81,041.41) BALANCE - CURRENT DATE ( 81,041.41) TOTAL FUND EQUITY 52,650.70 TOTAL LIABILITIES AND EQUITY 76,161.10 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 RECREATION - PARKS AND REC PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM 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 32,706.85 32,706.85 188,000.00 155,293.15 17.4 17-0302-01-00 SPONSORSHIPS .00 .00 10,000.00 10,000.00 .0 17-0302-03-00 PARK RESERVATION FEES 4,107.50 4,107.50 20,000.00 15,892.50 20.5 17-0303-00-00 SCHOLARSHIP FUNDS .00 .00 1,000.00 1,000.00 .0 TOTAL FUND REVENUE 36,814.35 36,814.35 662,770.00 625,955.65 5.6 EXPENDITURES CONTRACTS 17-0416-00-00 CONTRACT-PERMITS-CAMPS/CLASSES 399.00 399.00 35,000.00 34,601.00 1.1 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,529.50 6,529.50 50,000.00 43,470.50 13.1 PERSONNEL 17-0420-10-00 SALARIES-FULL TIME 76,657.94 76,657.94 266,500.00 189,842.06 28.8 17-0420-11-00 SALARIES-SEASONAL 618.68 618.68 58,500.00 57,881.32 1.1 17-0420-15-00 SALARIES-PART TIME 2,603.13 2,603.13 30,500.00 27,896.87 8.5 17-0420-18-00 OVERTIME 816.63 816.63 4,000.00 3,183.37 20.4 17-0420-21-00 FICA 6,019.29 6,019.29 27,550.00 21,530.71 21.9 17-0420-22-00 PERSI 7,473.73 7,473.73 31,800.00 24,326.27 23.5 17-0420-23-00 HRA BUY-DOWN .00 .00 4,620.00 4,620.00 .0 17-0420-24-00 WORKERS' COMPENSATION 3,037.98 3,037.98 .00 ( 3,037.98).0 17-0420-25-00 INSURANCE 7,237.57 7,237.57 27,500.00 20,262.43 26.3 17-0420-26-00 HSA CONTRIBUTION 650.00 650.00 4,800.00 4,150.00 13.5 17-0420-27-00 PTO CASH OUT .00 .00 5,400.00 5,400.00 .0 TOTAL PERSONNEL 105,114.95 105,114.95 461,170.00 356,055.05 22.8 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 .00 .00 2,000.00 2,000.00 .0 17-0422-01-00 OFFICE SUPPLIES 129.10 129.10 1,000.00 870.90 12.9 17-0422-02-00 ADVERTISING/MKTING CAMP/CLASS .00 .00 5,500.00 5,500.00 .0 17-0422-02-01 ADVERTISING/MKTNG TEAM SPORTS .00 .00 5,500.00 5,500.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 RECREATION - PARKS AND REC PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 35 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 .00 .00 8,000.00 8,000.00 .0 17-0422-10-00 BACKGROUND CHECKS 78.50 78.50 2,000.00 1,921.50 3.9 17-0422-11-00 REFUNDS-PARK REC PROGRAMS .00 .00 2,000.00 2,000.00 .0 TOTAL ADMINISTRATION 245.63 245.63 41,100.00 40,854.37 .6 RECREATION 17-0423-00-00 REC SUPPLIES-CAMPS & CLASSES 115.50 115.50 6,000.00 5,884.50 1.9 17-0423-00-01 REC SUPPLIES-TEAM SPORTS 553.74 553.74 15,000.00 14,446.26 3.7 17-0423-01-00 UNIFORMS .00 .00 15,000.00 15,000.00 .0 17-0423-02-00 FIELD TRIPS ( 37.50)( 37.50)15,000.00 15,037.50 ( .3) 17-0423-03-00 FACILITY RENTAL 4,337.50 4,337.50 10,000.00 5,662.50 43.4 17-0423-04-00 TRANSPORTATION SERVICES 561.43 561.43 10,000.00 9,438.57 5.6 17-0423-05-00 DADDY DAUGHTER DANCE .00 .00 2,200.00 2,200.00 .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 5,896.36 5,896.36 92,500.00 86,603.64 6.4 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 117,855.76 117,855.76 662,770.00 544,914.24 17.8 NET REVENUE OVER EXPENDITURES ( 81,041.41)( 81,041.41).00 81,041.41 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 IT DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM 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 ( 28,718.98) 18-0217-09-00 WORKERS' COMPENSATION 1,544.35 18-0217-10-00 HSA CONTRIBUTION 820.00 TOTAL LIABILITIES ( 24,862.24) FUND EQUITY 18-0271-00-00 FUND BALANCE ( 2,402.36) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 27,264.60 BALANCE - CURRENT DATE 27,264.60 TOTAL FUND EQUITY 24,862.24 TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 37 REVENUE 18-0301-00-00 MONTHLY TRANSFER TO DEPTS 175,549.83 175,549.83 893,820.00 718,270.17 19.6 TOTAL FUND REVENUE 175,549.83 175,549.83 893,820.00 718,270.17 19.6 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 .00 .00 6,600.00 6,600.00 .0 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 .00 .00 19,600.00 19,600.00 .0 PERSONNEL 18-0415-10-00 SALARIES (FULL TIME)61,829.04 61,829.04 237,000.00 175,170.96 26.1 18-0415-11-00 IT DEPT/OVERTIME 506.91 506.91 3,000.00 2,493.09 16.9 18-0415-21-00 FICA 4,498.49 4,498.49 18,500.00 14,001.51 24.3 18-0415-22-00 PERSI 7,442.89 7,442.89 28,800.00 21,357.11 25.8 18-0415-23-00 HRA BUY- DOWN .00 .00 4,620.00 4,620.00 .0 18-0415-24-00 WORKERS' COMPENSATION 118.03 118.03 .00 ( 118.03).0 18-0415-25-00 INSURANCE 9,189.67 9,189.67 41,300.00 32,110.33 22.3 18-0415-26-00 HSA 180.00 180.00 1,200.00 1,020.00 15.0 18-0415-27-00 PTO CASH OUT .00 .00 2,000.00 2,000.00 .0 TOTAL PERSONNEL 83,765.03 83,765.03 336,420.00 252,654.97 24.9 CONTRACT & AGREEMENTS 18-0416-01-00 CONTRACT AND AGREEMENTS 30,326.54 30,326.54 330,000.00 299,673.46 9.2 TOTAL CONTRACT & AGREEMENTS 30,326.54 30,326.54 330,000.00 299,673.46 9.2 INTERNET/PHONE SERVICES 18-0417-01-00 INTERNET & PHONE SERVICES 10,799.08 10,799.08 74,000.00 63,200.92 14.6 TOTAL INTERNET/PHONE SERVICES 10,799.08 10,799.08 74,000.00 63,200.92 14.6 OPERATIONAL RESERVE CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 38 18-0418-01-00 OPERATIONAL RESV, EQUIP/SOFTWR 15,140.28 15,140.28 35,000.00 19,859.72 43.3 TOTAL OPERATIONAL RESERVE 15,140.28 15,140.28 35,000.00 19,859.72 43.3 CAPITAL OUTLAY 18-0419-01-00 FURNITURE .00 .00 1,300.00 1,300.00 .0 18-0419-02-00 EQUIPMENT 8,254.30 8,254.30 60,000.00 51,745.70 13.8 18-0419-03-00 SOFTWARE PURCHASES .00 .00 25,000.00 25,000.00 .0 18-0419-04-00 WEBSITE DEVELOPMENT .00 .00 12,000.00 12,000.00 .0 18-0419-05-00 TOOLS .00 .00 500.00 500.00 .0 TOTAL CAPITAL OUTLAY 8,254.30 8,254.30 98,800.00 90,545.70 8.4 TOTAL FUND EXPENDITURES 148,285.23 148,285.23 893,820.00 745,534.77 16.6 NET REVENUE OVER EXPENDITURES 27,264.60 27,264.60 .00 ( 27,264.60).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 CAPITAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 39 ASSETS 19-0101-00-00 CASH 1,526,454.34 19-0151-25-00 FIRST INTERSTATE INVESTMENT 9,845,882.81 19-0151-25-01 FIRST INTERSTATE INV CITY HALL 335,168.50 TOTAL ASSETS 11,707,505.65 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 ( 1,498,463.93) BALANCE - CURRENT DATE ( 1,498,463.93) TOTAL FUND EQUITY 8,503,004.17 TOTAL LIABILITIES AND EQUITY 11,707,505.65 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM 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 241.45 241.45 500.00 258.55 48.3 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 14.97 14.97 .00 ( 14.97).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 89,874.48 89,874.48 20,949,134.00 20,859,259.52 .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 .00 .00 2,015,889.00 2,015,889.00 .0 19-0462-03-00 FEMA TRAIL REPLACEMENT .00 .00 1,596,204.00 1,596,204.00 .0 TOTAL CAPITAL MAINTENANCE .00 .00 3,612,093.00 3,612,093.00 .0 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 493,978.80 493,978.80 2,800,000.00 2,306,021.20 17.6 19-0465-07-00 LAND PURCHASES 948,557.88 948,557.88 .00 ( 948,557.88).0 TOTAL CITY CAPITAL PROJECTS 1,442,536.68 1,442,536.68 2,900,000.00 1,457,463.32 49.7 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 116,982.65 116,982.65 900,000.00 783,017.35 13.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 3 MONTHS ENDING DECEMBER 31, 2021 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 41 TOTAL PZ CAPITAL PROJECTS 116,982.65 116,982.65 2,407,000.00 2,290,017.35 4.9 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-PATHWAY - FLOODING 19-0471-00-00 FEMA PA GRANT - FLOODING 1,980.00 1,980.00 .00 ( 1,980.00).0 TOTAL TRAILS-PATHWAY - FLOODING 1,980.00 1,980.00 .00 ( 1,980.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 9,350.00 9,350.00 .00 ( 9,350.00).0 19-0486-02-00 ARPA, FIBER NETWORK CONNECT 17,489.08 17,489.08 3,250,000.00 3,232,510.92 .5 TOTAL FEDERAL FUNDS PROJECTS 26,839.08 26,839.08 6,650,000.00 6,623,160.92 .4 TOTAL FUND EXPENDITURES 1,588,338.41 1,588,338.41 20,949,134.00 19,360,795.59 7.6 NET REVENUE OVER EXPENDITURES ( 1,498,463.93)( 1,498,463.93).00 1,498,463.93 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 ARTS COMMISSION FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM PAGE: 42 ASSETS 21-0101-00-00 CASH 23,366.74 TOTAL ASSETS 23,366.74 LIABILITIES AND EQUITY FUND EQUITY 21-0271-00-00 FUND BALANCE 24,558.04 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 1,191.30) BALANCE - CURRENT DATE ( 1,191.30) TOTAL FUND EQUITY 23,366.74 TOTAL LIABILITIES AND EQUITY 23,366.74 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 ARTS COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM 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 .00 .00 500.00 500.00 .0 21-0376-12-00 POSTCARD REVENUE .00 .00 300.00 300.00 .0 21-0390-00-00 CARRY OVER .00 .00 30,719.00 30,719.00 .0 TOTAL FUND REVENUE .00 .00 77,420.00 77,420.00 .0 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 .00 .00 15,000.00 15,000.00 .0 TOTAL ART EDUCATION .00 .00 15,000.00 15,000.00 .0 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 3 MONTHS ENDING DECEMBER 31, 2021 ARTS COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:51AM 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 1,191.30 1,191.30 77,420.00 76,228.70 1.5 NET REVENUE OVER EXPENDITURES ( 1,191.30)( 1,191.30).00 1,191.30 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 PUBLIC WORKS FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 45 ASSETS 23-0151-00-00 INVESTMENTS 371,837.39 TOTAL ASSETS 371,837.39 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 20,863.81 23-0217-08-00 GARNISHMENT ( 1,162.50) 23-0217-09-00 WORKERS' COMPENSATION 95,858.33 23-0217-10-00 HSA CONTRIBUTION ( 1,160.00) TOTAL LIABILITIES 117,050.67 FUND EQUITY 23-0271-00-00 FUND BALANCE 587,726.71 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 332,939.99) BALANCE - CURRENT DATE ( 332,939.99) TOTAL FUND EQUITY 254,786.72 TOTAL LIABILITIES AND EQUITY 371,837.39 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM 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 .00 .00 6,000.00 6,000.00 .0 TOTAL FUND REVENUE .00 .00 2,388,256.00 2,388,256.00 .0 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 3,762.50 3,762.50 7,500.00 3,737.50 50.2 23-0413-04-00 TRAINING 4,505.03 4,505.03 15,500.00 10,994.97 29.1 23-0413-05-00 TRAVEL & PER DIEM 243.72 243.72 6,725.00 6,481.28 3.6 23-0413-06-00 PROFESSIONAL DUES .00 .00 2,500.00 2,500.00 .0 23-0413-09-00 UNIFORMS 250.00 250.00 5,500.00 5,250.00 4.6 23-0413-10-00 PUBLIC RELATIONS .00 .00 1,000.00 1,000.00 .0 TOTAL ADMINISTRATION 8,761.25 8,761.25 40,725.00 31,963.75 21.5 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 10,161.52 10,161.52 40,000.00 29,838.48 25.4 23-0414-03-00 MATERIALS AND SUPPLIES 10,209.97 10,209.97 47,000.00 36,790.03 21.7 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 7,485.81 7,485.81 40,000.00 32,514.19 18.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 .00 .00 5,000.00 5,000.00 .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 2.63 2.63 2,500.00 2,497.37 .1 23-0414-12-00 EMERGENCY REPAIRS .00 .00 25,000.00 25,000.00 .0 TOTAL GEN MAINTENANCE & REPAIR 32,698.91 32,698.91 179,500.00 146,801.09 18.2 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 3 MONTHS ENDING DECEMBER 31, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 47 TOTAL PW RESTRICTED FUNDS .00 .00 150,000.00 150,000.00 .0 CONTRACTS & AGREEMENTS 23-0416-00-00 WYCLIFFE PUMP STATION 587.28 587.28 6,690.00 6,102.72 8.8 23-0416-01-00 FARMERS UNION .00 .00 1,200.00 1,200.00 .0 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 .00 .00 1.00 1.00 .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 .00 .00 1,000.00 1,000.00 .0 23-0416-10-00 BALLANTYNE/BOISE VALLEY DITCH .00 .00 2,000.00 2,000.00 .0 TOTAL CONTRACTS & AGREEMENTS 926.39 926.39 15,545.00 14,618.61 6.0 VEHICLES 23-0417-01-00 VEHICLE MTNC & REPAIR 1,135.17 1,135.17 17,000.00 15,864.83 6.7 23-0417-02-00 GAS AND OIL 3,993.52 3,993.52 25,000.00 21,006.48 16.0 23-0417-05-00 VEHICLE CAR WASH 18.00 18.00 2,200.00 2,182.00 .8 TOTAL VEHICLES 5,146.69 5,146.69 44,200.00 39,053.31 11.6 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,093.60 7,093.60 10,000.00 2,906.40 70.9 TOTAL EQUIPMENT MTNC & REPAIR 7,093.60 7,093.60 10,000.00 2,906.40 70.9 SUSTAINABILITY-CONSERVATION 23-0421-01-00 SANITATION SERVICES 5,880.57 5,880.57 54,000.00 48,119.43 10.9 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 3 MONTHS ENDING DECEMBER 31, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 48 TOTAL SUSTAINABILITY-CONSERVATION 5,880.57 5,880.57 98,811.00 92,930.43 6.0 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 125,198.44 125,198.44 654,000.00 528,801.56 19.1 23-0433-11-00 OVERTIME 2,754.14 2,754.14 18,600.00 15,845.86 14.8 23-0433-15-00 SALARIES-PART TIME 350.14 350.14 .00 ( 350.14).0 23-0433-16-00 SALARIES-SEASONAL 21,433.61 21,433.61 195,400.00 173,966.39 11.0 23-0433-21-00 FICA 11,119.37 11,119.37 66,500.00 55,380.63 16.7 23-0433-22-00 PERSI 15,088.59 15,088.59 78,500.00 63,411.41 19.2 23-0433-24-00 WORKERS' COMPENSATION 5,899.82 5,899.82 .00 ( 5,899.82).0 23-0433-25-00 INSURANCE 13,852.36 13,852.36 142,500.00 128,647.64 9.7 23-0433-26-00 HSA CONTRIBUTION 810.00 810.00 15,600.00 14,790.00 5.2 23-0433-27-00 HRA BUY-DOWN .00 .00 7,700.00 7,700.00 .0 TOTAL PERSONNEL 196,506.47 196,506.47 1,178,800.00 982,293.53 16.7 SHOP 23-0440-00-00 SHOP LEASE 5,920.62 5,920.62 27,000.00 21,079.38 21.9 23-0440-02-00 UTILTIES 584.41 584.41 3,750.00 3,165.59 15.6 TOTAL SHOP 6,505.03 6,505.03 30,750.00 24,244.97 21.2 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 4,364.89 4,364.89 55,000.00 50,635.11 7.9 TOTAL STREET LIGHTS 4,487.89 4,487.89 63,000.00 58,512.11 7.1 CITY HALL 23-0442-01-00 BLDG MAINTENANCE & REPAIR 250.00 250.00 2,500.00 2,250.00 10.0 23-0442-02-00 MTNC & REPAIR GROUNDS .00 .00 1,500.00 1,500.00 .0 23-0442-04-00 UTILITIES 8,636.39 8,636.39 40,000.00 31,363.61 21.6 TOTAL CITY HALL 8,886.39 8,886.39 44,000.00 35,113.61 20.2 SENIOR CENTER 23-0443-01-00 BLDG MAINTENANCE & REPAIR 385.40 385.40 2,500.00 2,114.60 15.4 23-0443-02-00 MTNC & REPAIR GROUNDS .00 .00 1,500.00 1,500.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 49 TOTAL SENIOR CENTER 385.40 385.40 4,000.00 3,614.60 9.6 LIBRARY 23-0444-01-00 BLDG MAINTENANCE & REPAIR 7,244.40 7,244.40 5,000.00 ( 2,244.40)144.9 23-0444-02-00 MTNC & REPAIR GROUNDS .00 .00 2,000.00 2,000.00 .0 TOTAL LIBRARY 7,244.40 7,244.40 7,000.00 ( 244.40)103.5 MUSEUM 23-0445-01-00 BLDG MAINTENANCE & REPAIR 3,437.18 3,437.18 2,500.00 ( 937.18)137.5 TOTAL MUSEUM 3,437.18 3,437.18 2,500.00 ( 937.18)137.5 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 .00 .00 1,000.00 1,000.00 .0 TOTAL ARBORETUM PARK .00 .00 2,500.00 2,500.00 .0 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 34.39 34.39 225.00 190.61 15.3 TOTAL FLAG PLAZA 34.39 34.39 1,725.00 1,690.61 2.0 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 271.19 271.19 3,000.00 2,728.81 9.0 TOTAL FRIENDSHIP PARK 271.19 271.19 6,500.00 6,228.81 4.2 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 .00 .00 1,500.00 1,500.00 .0 23-0449-03-00 GROUNDS MTNC & REPAIR 19.98 19.98 5,000.00 4,980.02 .4 23-0449-04-00 UTILITIES 3,042.17 3,042.17 24,000.00 20,957.83 12.7 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 50 TOTAL GUERBER PARK 3,062.15 3,062.15 37,000.00 33,937.85 8.3 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 .00 .00 1,500.00 1,500.00 .0 23-0450-03-00 GROUNDS MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0450-04-00 UTILTIES 666.66 666.66 3,000.00 2,333.34 22.2 TOTAL HERITAGE PARK 666.66 666.66 7,000.00 6,333.34 9.5 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 4,871.81 4,871.81 9,500.00 4,628.19 51.3 TOTAL MERRILL PARK 4,871.81 4,871.81 22,500.00 17,628.19 21.7 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 752.06 752.06 2,000.00 1,247.94 37.6 TOTAL ORVAL KRASEN PARK 752.06 752.06 3,500.00 2,747.94 21.5 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 .00 .00 1,000.00 1,000.00 .0 23-0454-03-00 GROUNDS MTNC & REPAIR .00 .00 1,000.00 1,000.00 .0 23-0454-04-00 UTILITIES 6,825.05 6,825.05 20,000.00 13,174.95 34.1 TOTAL SPORTS COMPLEX 8,546.72 8,546.72 24,500.00 15,953.28 34.9 TOWN ENTRANCE SIGNS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM 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,366.10 1,366.10 21,000.00 19,633.90 6.5 TOTAL TOWN ENTRANCE SIGNS 1,366.10 1,366.10 22,500.00 21,133.90 6.1 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 850.26 850.26 1,500.00 649.74 56.7 TOTAL PLAZA DRIVE 850.26 850.26 2,500.00 1,649.74 34.0 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 186.65 186.65 5,000.00 4,813.35 3.7 TOTAL PAMELA BAKER PARK 186.65 186.65 6,500.00 6,313.35 2.9 CAPITAL EQUIPMENT 23-0460-00-00 TOOLS 700.36 700.36 5,000.00 4,299.64 14.0 23-0460-01-00 EQUIPMENT 17,558.42 17,558.42 85,000.00 67,441.58 20.7 TOTAL CAPITAL EQUIPMENT 18,258.78 18,258.78 90,000.00 71,741.22 20.3 CITY LANDSCAPE MAINTENANCE 23-0462-00-00 EQUIPMENT RENTAL 2,577.12 2,577.12 7,500.00 4,922.88 34.4 23-0462-01-00 SPRAYING/FERTILIZING .00 .00 48,000.00 48,000.00 .0 23-0462-02-00 SAFETY EQUIPMENT .00 .00 1,000.00 1,000.00 .0 23-0462-03-00 DUMPING-DISPOSAL 188.26 188.26 5,000.00 4,811.74 3.8 TOTAL CITY LANDSCAPE MAINTENANCE 2,765.38 2,765.38 61,500.00 58,734.62 4.5 LINDER ROAD RESTROOM 23-0463-01-00 BLDG/STRUCTURES MTNC REPAIR .00 .00 1,000.00 1,000.00 .0 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 499.17 499.17 6,000.00 5,500.83 8.3 TOTAL LINDER ROAD RESTROOM 499.17 499.17 8,000.00 7,500.83 6.2 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM 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 142.00 142.00 4,000.00 3,858.00 3.6 TOTAL TRAILS 142.00 142.00 9,000.00 8,858.00 1.6 FISCAL YEAR CAPITAL PROJECTS 23-0480-15-00 LANDSCAPE UPGRADES - PARKS 388.40 388.40 25,000.00 24,611.60 1.6 TOTAL FISCAL YEAR CAPITAL PROJECTS 388.40 388.40 25,000.00 24,611.60 1.6 FY 21/22 PROJECTS 23-0483-01-00 CAPITAL PROJECTS FY22 .00 .00 80,500.00 80,500.00 .0 TOTAL FY 21/22 PROJECTS .00 .00 80,500.00 80,500.00 .0 TOTAL FUND EXPENDITURES 332,939.99 332,939.99 2,388,256.00 2,055,316.01 13.9 NET REVENUE OVER EXPENDITURES ( 332,939.99)( 332,939.99).00 332,939.99 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 RECREATION - EAGLE FUN DAYS FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM 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 3 MONTHS ENDING DECEMBER 31, 2021 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM 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 3 MONTHS ENDING DECEMBER 31, 2021 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM 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 DECEMBER 31, 2021 PATHWAY IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 56 ASSETS 25-0101-00-00 CASH 7,187.50 25-0151-25-00 FIRST INTERSTATE INVESTMENT 782,843.30 TOTAL ASSETS 790,030.80 LIABILITIES AND EQUITY FUND EQUITY 25-0271-00-00 FUND BALANCE 763,927.09 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 26,103.71 BALANCE - CURRENT DATE 26,103.71 TOTAL FUND EQUITY 790,030.80 TOTAL LIABILITIES AND EQUITY 790,030.80 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 PATHWAY IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 57 REVENUE 25-0322-19-00 DEVELOPMENT IMPACT FEE 25,779.00 25,779.00 198,300.00 172,521.00 13.0 25-0371-25-00 BANK INTEREST 324.71 324.71 1,080.00 755.29 30.1 25-0390-00-00 CARRY OVER .00 .00 702,268.00 702,268.00 .0 TOTAL FUND REVENUE 26,103.71 26,103.71 901,648.00 875,544.29 2.9 EXPENDITURES CAPITAL IMPROVEMENTS 25-0438-00-00 CAPITAL IMPROVEMENTS .00 .00 801,648.00 801,648.00 .0 25-0438-01-00 EAGLE ISLAND ST PK CONNECTION .00 .00 100,000.00 100,000.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 .00 901,648.00 901,648.00 .0 TOTAL FUND EXPENDITURES .00 .00 901,648.00 901,648.00 .0 NET REVENUE OVER EXPENDITURES 26,103.71 26,103.71 .00 ( 26,103.71).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM 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 ( 1,136.42) 26-0217-09-00 WORKERS' COMPENSATION 667.89 TOTAL LIABILITIES 487.05 FUND EQUITY 26-0271-00-00 FUND BALANCE ( 1,747.65) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,260.60 BALANCE - CURRENT DATE 1,260.60 TOTAL FUND EQUITY ( 487.05) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 59 REVENUE 26-0301-00-00 MONTHLY TRANSFER TO DEPTS 55,712.89 55,712.89 212,056.00 156,343.11 26.3 TOTAL FUND REVENUE 55,712.89 55,712.89 212,056.00 156,343.11 26.3 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 .00 .00 1,500.00 1,500.00 .0 26-0413-12-00 TRAINING .00 .00 6,895.00 6,895.00 .0 26-0413-13-00 TRAVEL & PER DIEM .00 .00 6,400.00 6,400.00 .0 26-0413-14-00 PROFESSIONAL DUES .00 .00 4,281.00 4,281.00 .0 26-0413-19-00 COMMUNICATIONS 8,162.76 8,162.76 12,200.00 4,037.24 66.9 26-0413-29-00 UNIFORMS .00 .00 200.00 200.00 .0 TOTAL ADMINISTRATION 8,264.37 8,264.37 31,976.00 23,711.63 25.9 PERSONNEL 26-0415-10-00 SALARIES- FULL TIME 35,777.52 35,777.52 135,500.00 99,722.48 26.4 26-0415-21-00 FICA 2,724.03 2,724.03 10,400.00 7,675.97 26.2 26-0415-22-00 PERSI 4,271.87 4,271.87 16,300.00 12,028.13 26.2 26-0415-23-00 HRA BUY-DOWN .00 .00 3,080.00 3,080.00 .0 26-0415-24-00 WORKERS' COMPENSATION 67.97 67.97 .00 ( 67.97).0 26-0415-25-00 INSURANCE 3,346.53 3,346.53 14,800.00 11,453.47 22.6 TOTAL PERSONNEL 46,187.92 46,187.92 180,080.00 133,892.08 25.7 TOTAL FUND EXPENDITURES 54,452.29 54,452.29 212,056.00 157,603.71 25.7 NET REVENUE OVER EXPENDITURES 1,260.60 1,260.60 .00 ( 1,260.60).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 LAW ENF DEV IMPACT FEES FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 60 ASSETS 27-0101-00-00 CASH 5,713.08 27-0151-25-00 FIRST INTERSTATE INVESTMENTS 50,030.49 TOTAL ASSETS 55,743.57 LIABILITIES AND EQUITY FUND EQUITY 27-0271-00-00 POLICE IMPACT FEE/FUND BALANCE 42,529.49 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 13,214.08 BALANCE - CURRENT DATE 13,214.08 TOTAL FUND EQUITY 55,743.57 TOTAL LIABILITIES AND EQUITY 55,743.57 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 LAW ENF DEV IMPACT FEES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 61 REVENUE 27-0322-19-00 RESIDENTIAL IMPACT FEES 13,213.08 13,213.08 66,600.00 53,386.92 19.8 27-0322-20-00 COMMERCIAL - IMPACT FEES .00 .00 30,000.00 30,000.00 .0 27-0371-25-00 BANK INTEREST 1.00 1.00 100.00 99.00 1.0 27-0390-00-00 CARRY OVER .00 .00 45,000.00 45,000.00 .0 TOTAL FUND REVENUE 13,214.08 13,214.08 141,700.00 128,485.92 9.3 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 13,214.08 13,214.08 .00 ( 13,214.08).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 CITY HALL BOND FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 62 ASSETS 54-0101-00-00 CASH 3,405.22 TOTAL ASSETS 3,405.22 LIABILITIES AND EQUITY FUND EQUITY 54-0271-00-00 FUND BALANCE 3,405.22 TOTAL FUND EQUITY 3,405.22 TOTAL LIABILITIES AND EQUITY 3,405.22 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 CITY HALL BOND FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 63 REVENUE 54-0399-01-00 FUNDING FROM GENERAL FUND .00 .00 102,950.00 102,950.00 .0 TOTAL FUND REVENUE .00 .00 102,950.00 102,950.00 .0 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 .00 .00 22,500.00 22,500.00 .0 54-0480-84-00 PAYING AGENT FEE .00 .00 450.00 450.00 .0 TOTAL BOND PAYMENTS .00 .00 102,950.00 102,950.00 .0 TOTAL FUND EXPENDITURES .00 .00 102,950.00 102,950.00 .0 NET REVENUE OVER EXPENDITURES .00 .00 .00 .00 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2021 WATER FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 64 ASSETS 60-0101-00-00 CASH 568,267.65 60-0115-00-00 WATER/ACCOUNTS RECEIVABLE 132,681.07 60-0151-01-00 DEQ LOAN INV (COLL/PMTS)581,889.89 60-0151-02-00 DEQ RESERVE FUND INV 182,000.00 60-0151-25-00 FIRST INTERSTATE INVESTMENT 3,228,912.20 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 14,810,493.89 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 5,038.85 60-0217-08-00 GARNISHMENTS 1,162.50 60-0217-09-00 WORKERS' COMPENSATION 55,592.12 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 93,175.00 60-0231-00-00 DEQ LOAN 1,115,023.00 TOTAL LIABILITIES 1,487,054.42 FUND EQUITY 60-0271-00-00 WATER/FUND BALANCE 13,156,448.78 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 166,990.69 BALANCE - CURRENT DATE 166,990.69 TOTAL FUND EQUITY 13,323,439.47 TOTAL LIABILITIES AND EQUITY 14,810,493.89 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM 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 157,500.00 157,500.00 105,000.00 ( 52,500.00)150.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 48,060.00 48,060.00 157,500.00 109,440.00 30.5 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 293,829.17 293,829.17 1,158,396.00 864,566.83 25.4 60-0347-02-00 OTHER REVENUE 1,700.00 1,700.00 8,400.00 6,700.00 20.2 60-0347-03-00 RECONNECT FEES .00 .00 600.00 600.00 .0 60-0347-04-00 DELINQUENT FEES 2,578.50 2,578.50 8,736.00 6,157.50 29.5 60-0347-05-00 MISCELLANEOUS REVENUE 3,939.85 3,939.85 7,500.00 3,560.15 52.5 60-0347-06-00 SYSTEM ENHANCEMENT FEE 109,013.23 109,013.23 400,000.00 290,986.77 27.3 60-0355-01-00 WCE-WATER CONST EQUIV FEE 6,400.00 6,400.00 20,000.00 13,600.00 32.0 60-0371-25-00 BANK INTEREST 1,626.11 1,626.11 6,000.00 4,373.89 27.1 60-0390-00-00 WATER FUND CARRY OVER .00 .00 171,047.00 171,047.00 .0 TOTAL FUND REVENUE 624,646.86 624,646.86 3,567,379.00 2,942,732.14 17.5 EXPENDITURES VEHICLE OPERATIONS - LEASES 60-0420-01-00 GAS AND OIL 1,438.82 1,438.82 15,000.00 13,561.18 9.6 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 3,652.93 3,652.93 24,000.00 20,347.07 15.2 PERSONNEL 60-0433-10-00 SALARIES-FULL TIME 89,813.42 89,813.42 372,000.00 282,186.58 24.1 60-0433-10-02 ON-CALL TIME 780.80 780.80 7,500.00 6,719.20 10.4 60-0433-11-00 OVERTIME 199.64 199.64 4,500.00 4,300.36 4.4 60-0433-21-00 FICA 6,813.25 6,813.25 29,400.00 22,586.75 23.2 60-0433-22-00 PERSI 10,760.89 10,760.89 45,900.00 35,139.11 23.4 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 8,290.58 8,290.58 13,500.00 5,209.42 61.4 60-0433-25-00 INSURANCE 11,588.91 11,588.91 58,500.00 46,911.09 19.8 60-0433-26-00 HSA CONTRIBUTIONS 600.00 600.00 2,400.00 1,800.00 25.0 60-0433-29-00 PTO CASH OUT .00 .00 15,000.00 15,000.00 .0 TOTAL PERSONNEL 128,847.49 128,847.49 557,200.00 428,352.51 23.1 OPERATIONS & MAINTENANCE CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 66 60-0434-15-00 OFFICE SUPPLIES 78.98 78.98 1,800.00 1,721.02 4.4 60-0434-19-00 TELECOMMUNICATIONS/SCADA ( 3,545.25)( 3,545.25)10,836.00 14,381.25 ( 32.7) 60-0434-20-00 ADVERTISING - PUBLICATIONS .00 .00 2,000.00 2,000.00 .0 60-0434-22-00 TRAVEL-MTNGS-EDUCATION 100.00 100.00 8,000.00 7,900.00 1.3 60-0434-23-00 DUES & SUBSCRIPTIONS .00 .00 3,100.00 3,100.00 .0 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 809.41 809.41 10,000.00 9,190.59 8.1 60-0434-27-00 POSTAGE .00 .00 1,300.00 1,300.00 .0 60-0434-41-00 LIABILITY INSURANCE 2,310.00 2,310.00 4,620.00 2,310.00 50.0 60-0434-42-00 ENGINEERING SERVICES 1,745.01 1,745.01 35,000.00 33,254.99 5.0 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 90.00 90.00 145,920.00 145,830.00 .1 60-0434-43-01 CONTRACT SERVICES (REPAIR).00 .00 35,000.00 35,000.00 .0 60-0434-44-00 DIG LINE 606.06 606.06 4,500.00 3,893.94 13.5 60-0434-45-00 CITY AUDITOR SERVICES .00 .00 2,500.00 2,500.00 .0 60-0434-47-00 MAIL SERVICE-CUSTOMER BILLING 6,004.58 6,004.58 28,800.00 22,795.42 20.9 60-0434-50-00 SHOP LEASE 2,700.00 2,700.00 13,400.00 10,700.00 20.2 60-0434-50-01 SHOP UTILITIES 241.12 241.12 4,800.00 4,558.88 5.0 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 .00 .00 40,000.00 40,000.00 .0 60-0434-58-01 RPR/MTNC PUMPS-WELLS-CHEMICAL 1,717.86 1,717.86 50,000.00 48,282.14 3.4 60-0434-59-00 CHEMICALS 596.89 596.89 9,000.00 8,403.11 6.6 60-0434-60-00 POWER 9,163.60 9,163.60 55,000.00 45,836.40 16.7 60-0434-68-00 UNIFORMS .00 .00 2,300.00 2,300.00 .0 60-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 .00 25,000.00 25,000.00 .0 TOTAL OPERATIONS & MAINTENANCE 39,882.04 39,882.04 539,976.00 500,093.96 7.4 TESTING-WK-MO-QTR-ANNUAL 60-0435-56-00 TESTING-WK-MO-QTR-ANNUAL 5,683.00 5,683.00 12,000.00 6,317.00 47.4 TOTAL TESTING-WK-MO-QTR-ANNUAL 5,683.00 5,683.00 12,000.00 6,317.00 47.4 DEQ REVOLVING LOAN PAYMENT 60-0436-01-00 DEQ/STATE REVOLVING LOAN PMT 200,000.00 200,000.00 400,000.00 200,000.00 50.0 TOTAL DEQ REVOLVING LOAN PAYMENT 200,000.00 200,000.00 400,000.00 200,000.00 50.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 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 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2021 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/24/2022 11:52AM PAGE: 67 60-0438-01-00 EQUIPMENT .00 .00 9,950.00 9,950.00 .0 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 2,240.00 2,240.00 549,200.00 546,960.00 .4 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)21,719.84 21,719.84 86,250.00 64,530.16 25.2 60-0438-10-00 WATER MASTER PLAN-UPDATE .00 .00 40,000.00 40,000.00 .0 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 3,201.00 3,201.00 12,803.00 9,602.00 25.0 TOTAL CAPITAL EXPENDITURES 44,836.71 44,836.71 1,849,203.00 1,804,366.29 2.4 TOTAL FUND EXPENDITURES 457,656.17 457,656.17 3,567,379.00 3,109,722.83 12.8 NET REVENUE OVER EXPENDITURES 166,990.69 166,990.69 .00 ( 166,990.69).0