The URL can be used to link to this page

Finance - Quarterly Reports - FY 22/23 1st Quarter - 12/31/2022CITY OF EAGLE TREASURER'S REPORT FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 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/17/2023 11:16AM PAGE: 1 01 GENERAL FUND 1,750,596.94 2,273,674.56 11.75 3,067,745.99 15.86 ( 746,378.03) 1,702,903.54 06 LIBRARY FUND 94,581.62 6,383.32 .28 317,088.76 14.14 ( 221,272.44)5,148.62 07 MUSEUM FUND .00 32,828.43 18.47 31,275.98 17.59 1,552.45 .00 08 PARK IMPACT FEE FUND 100,691.86 44,677.51 1.03 84,252.00 1.95 16,938.93 44,178.44 09 RECREATION - SPECIAL EVENTS 66,842.79 5,194.56 2.17 43,940.69 18.39 2,171.08 25,925.58 10 EAGLE HISTORICAL COMMISSION 21,002.34 .00 .00 392.00 3.04 .00 20,610.34 11 EXECUTIVE DEPARTMENT .00 101,240.11 15.64 101,835.84 15.73 ( 595.73).00 12 CITY CLERK/TREAS DEPARTMENT .00 162,007.49 19.68 159,753.67 19.41 2,253.82 .00 13 BUILDING DEPARTMENT .00 218,234.64 21.36 189,373.37 18.54 28,861.27 .00 14 P&Z DEPARTMENT .00 272,513.28 20.46 273,195.57 20.51 ( 682.29).00 17 RECREATION - PARKS AND REC .00 129,256.67 16.52 124,257.30 15.88 4,999.37 .00 18 IT DEPARTMENT .00 186,146.22 18.42 168,210.31 16.64 17,935.91 .00 19 CAPITAL PROJECTS FUND 231,020.80 1,243,281.41 7.30 3,714,376.37 21.82 ( 2,366,979.13)126,904.97 21 ARTS COMMISSION .00 25.00 .03 ( 600.00) ( .77).00 625.00 23 PUBLIC WORKS .00 458,375.35 14.42 424,361.17 13.35 34,014.18 .00 24 RECREATION - EAGLE FUN DAYS 4,769.47 .00 .00 60.00 .04 .00 4,709.47 25 PATHWAY IMPACT FEE FUND 25,821.50 13,409.11 1.38 23,009.00 2.38 10,519.61 5,702.00 26 ECONOMIC DEVELOPMENT .00 757.06 .00 .00 .00 757.06 .00 27 LAW ENF DEV IMPACT FEES 14,090.52 11,182.32 7.46 .00 .00 64.92 25,207.92 60 WATER FUND 937,125.42 457,737.95 10.38 506,357.20 11.48 277,558.82 610,947.35 61 FIBER FUND 39,980.00 2,278.28 .10 20,462.98 .86 2,278.28 19,517.02 99 COMBINED CASH FUND ( 3,286,523.26).00 .00 .00 .00 ( 694,143.01) ( 2,592,380.25) TOTAL .00 5,619,203.27 9,249,348.20 ( 3,630,144.93).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 17, 2023 CITY OF EAGLE COMBINED CASH INVESTMENT DECEMBER 31, 2022 FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:20AM PAGE: 1 COMBINED CASH ACCOUNTS 99-0103-00-00 CASH IN CHECKING 2,290,219.23 99-0108-00-00 CASH CLEARING-ACCOUNTS REC 302,161.02 TOTAL COMBINED CASH 2,592,380.25 99-0101-00-00 CASH ALLOCATED TO OTHER FUNDS ( 2,592,380.25) TOTAL UNALLOCATED CASH .00 CASH ALLOCATION RECONCILIATION 1 ALLOCATION TO GENERAL FUND 1,702,903.54 6 ALLOCATION TO LIBRARY FUND 5,148.62 8 ALLOCATION TO PARK IMPACT FEE FUND 44,178.44 9 ALLOCATION TO RECREATION - SPECIAL EVENTS 25,925.58 10 ALLOCATION TO EAGLE HISTORICAL COMMISSION 20,610.34 19 ALLOCATION TO CAPITAL PROJECTS FUND 126,904.97 21 ALLOCATION TO ARTS COMMISSION 625.00 24 ALLOCATION TO RECREATION - EAGLE FUN DAYS 4,709.47 25 ALLOCATION TO PATHWAY IMPACT FEE FUND 5,702.00 27 ALLOCATION TO LAW ENF DEV IMPACT FEES 25,207.92 60 ALLOCATION TO WATER FUND 610,947.35 61 ALLOCATION TO FIBER FUND 19,517.02 TOTAL ALLOCATIONS TO OTHER FUNDS 2,592,380.25 ALLOCATION FROM COMBINED CASH FUND - 99-0101-00-00 ( 2,592,380.25) ZERO PROOF IF ALLOCATIONS BALANCE .00 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 GENERAL FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:20AM PAGE: 2 ASSETS 01-0101-00-00 CASH 1,702,903.54 01-0103-00-00 PETTY CASH 100.00 01-0107-00-00 TAXES RECEIVABLE DELINQUENT 12,084.19 01-0115-00-00 ACCOUNTS RECEIVABLE 62,509.89 01-0132-00-00 DUE FROM OTHER GOVERNMNTL UNTS 1,056,424.05 01-0151-25-00 FIRST INTERSTATE INVESTMENT 6,164,205.00 01-0151-28-00 ICCU CD 51,042.65 01-0170-00-00 HRA 10 % DEPOSIT 5,785.92 TOTAL ASSETS 9,055,055.24 LIABILITIES AND EQUITY LIABILITIES 01-0202-00-00 VOUCHERS PAYABLE ( 3,444.16) 01-0203-00-00 ACCTS PAYABLE-ACHD IMPACT FEES 22,110.00 01-0203-01-01 BONDS DEPOSITS PAYABLE 2,116,877.92 01-0203-01-02 FIREWORKS BOND DEPOSIT PAYABLE ( 2,000.00) 01-0203-01-03 VENDORS BOND DEPOSITS PAYABLE 5,139.00 01-0203-01-05 P&Z DEPOSITS PAYABLE 354,170.00 01-0203-01-06 LAND USE DEPOSITS PAYABLE 51,042.65 01-0217-04-00 PUBLIC RETIREMENT ( .02) 01-0217-07-00 GEN ADMIN HEALTH INSURANCE ( 10,779.13) 01-0217-07-01 COBRA- HEALTH INSURANCE ( 85.96) 01-0217-09-00 WORKERS' COMPENSATION 1,553.45 01-0226-00-00 DEFERRED REVENUE 11,060.32 TOTAL LIABILITIES 2,545,644.07 FUND EQUITY 01-0271-00-00 FUND BALANCE 7,303,482.60 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 794,071.43) BALANCE - CURRENT DATE ( 794,071.43) TOTAL FUND EQUITY 6,509,411.17 TOTAL LIABILITIES AND EQUITY 9,055,055.24 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:20AM PAGE: 3 REVENUE 01-0311-00-00 PROPERTY TAX 4,647.98 4,647.98 4,490,018.00 4,485,370.02 .1 01-0311-01-00 PENALTY/INTEREST ON TAXES 442.12 442.12 4,000.00 3,557.88 11.1 01-0312-00-00 PERSONAL PROPERTY TAX REIMBURS .00 .00 8,463.00 8,463.00 .0 01-0316-10-02 FRANCHISE FEE/VEOLIA 9,139.33 9,139.33 20,000.00 10,860.67 45.7 01-0316-11-00 FRANCHISE FEE/INTERMTN GAS 29,734.10 29,734.10 275,000.00 245,265.90 10.8 01-0316-12-00 FRANCHISE FEE/CABLE TV 27,951.58 27,951.58 115,000.00 87,048.42 24.3 01-0316-13-00 FRANCHISE FEE/TRASH 99,418.33 99,418.33 300,000.00 200,581.67 33.1 01-0316-14-00 FRANCHISE FEE/IDAHO POWER 94,525.49 94,525.49 235,000.00 140,474.51 40.2 01-0321-10-00 ALCOHOLIC BEVERAGE LICENSES 1,654.97 1,654.97 56,500.00 54,845.03 2.9 01-0321-30-00 BUSINESS LICENSE FEE 1,225.00 1,225.00 .00 ( 1,225.00).0 01-0322-10-00 BUILDING & INSPECTION PERMITS 330,292.30 330,292.30 1,135,000.00 804,707.70 29.1 01-0322-12-00 BUILDING, PLAN REVIEW FEES 165,360.30 165,360.30 475,250.00 309,889.70 34.8 01-0322-13-00 ENERGY STANDARDS (IRES)2,350.00 2,350.00 17,500.00 15,150.00 13.4 01-0322-14-00 ELECTRICAL PERMIT FEES 56,474.35 56,474.35 200,000.00 143,525.65 28.2 01-0322-15-00 PLUMBING PERMIT FEES 31,741.72 31,741.72 200,000.00 168,258.28 15.9 01-0322-16-00 MECHANICAL PERMIT FEES 37,691.59 37,691.59 200,000.00 162,308.41 18.9 01-0322-20-00 FIRE IMPACT ADMIN FEES 1,140.00 1,140.00 7,000.00 5,860.00 16.3 01-0323-01-00 PZ ANNEX/ZONING PERMIT FEES 57,833.85 57,833.85 170,000.00 112,166.15 34.0 01-0323-02-00 PLANNING INSPECTION FEES 4,050.00 4,050.00 5,000.00 950.00 81.0 01-0323-03-00 PLANNING, PLAN REVIEW FEES 5,850.00 5,850.00 25,000.00 19,150.00 23.4 01-0323-04-00 STREET LIGHT INSPECTION FEES 110.00 110.00 800.00 690.00 13.8 01-0323-05-00 SURETY/LETTER OF CREDIT FEES 1,500.00 1,500.00 4,000.00 2,500.00 37.5 01-0323-06-00 GRADING-DRAINAGE PERMIT FEES 2,250.00 2,250.00 12,000.00 9,750.00 18.8 01-0323-10-00 SPRING VALLEY STAFF TIME REIMB 5,532.00 5,532.00 10,000.00 4,468.00 55.3 01-0323-11-00 AVIMOR STAFF TIME REIMBURSE 16,764.00 16,764.00 20,000.00 3,236.00 83.8 01-0323-12-00 PZ STAFF TIME REIMBURSE 862.50 862.50 .00 ( 862.50).0 01-0335-10-00 STATE LIQUOR 129,255.00 129,255.00 662,590.00 533,335.00 19.5 01-0335-50-00 STATE SALES TAX, AG REPL 4.75 4.75 19.00 14.25 25.0 01-0335-60-00 STATE REVENUE SHARING 921,958.84 921,958.84 3,743,404.00 2,821,445.16 24.6 01-0338-40-00 COURT FEES 18,922.62 18,922.62 35,000.00 16,077.38 54.1 01-0338-41-00 CITATION FEES/CODE ENFORCEMENT .00 .00 500.00 500.00 .0 01-0338-42-00 WEED ABATEMENT .00 .00 1,000.00 1,000.00 .0 01-0341-11-00 MISCELLANEOUS PERMITS/LICENSES 1,177.00 1,177.00 .00 ( 1,177.00).0 01-0341-12-00 ANIMAL CONTROL FEES 3,999.50 3,999.50 10,000.00 6,000.50 40.0 01-0341-13-00 ENGINEERING FEES - DEVELOPERS 56,529.75 56,529.75 175,000.00 118,470.25 32.3 01-0341-14-00 ATTORNEY FEES - DEVELOPERS 8,517.50 8,517.50 20,000.00 11,482.50 42.6 01-0341-16-00 CONSULTANT FEES - DEVELOPERS 4,485.00 4,485.00 .00 ( 4,485.00).0 01-0341-17-00 CID STAFF & MISC REIMBURSEMENT 371.18 371.18 1,200.00 828.82 30.9 01-0341-20-00 REIMBURSE FROM WATER DEPT 3,352.50 3,352.50 13,410.00 10,057.50 25.0 01-0341-20-01 REIMBURSE FROM FIBER DEPT .00 .00 14,000.00 14,000.00 .0 01-0341-26-00 BACKGROUND CHECKS 292.25 292.25 1,500.00 1,207.75 19.5 01-0341-27-00 URA CITY STAFF REIMBURSEMENT 198.83 198.83 2,000.00 1,801.17 9.9 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-02-00 IDAHO OPIOID SETTLEMENT 10,360.30 10,360.30 15,000.00 4,639.70 69.1 01-0350-05-00 FIELD OF HONOR 2,670.00 2,670.00 20,000.00 17,330.00 13.4 01-0350-07-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 01-0365-01-00 PARKING IN LIEU OF PAYMENTS 11,400.00 11,400.00 .00 ( 11,400.00).0 01-0371-25-00 BANK INVESTMENT INTEREST 1,941.38 1,941.38 8,500.00 6,558.62 22.8 01-0379-00-00 MISCELLANEOUS .00 .00 1,000.00 1,000.00 .0 01-0379-01-00 DUPLICATION/PUBLISHING/PRINTNG .00 .00 500.00 500.00 .0 CITY OF EAGLE REVENUES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 GENERAL FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:20AM PAGE: 4 01-0382-02-00 PROMOTIONAL SALES 195.00 195.00 .00 ( 195.00).0 01-0383-05-00 MISCELLANEOUS-REIMBURSEABLES 268.73 268.73 1,500.00 1,231.27 17.9 01-0383-09-00 ROOM RESERVATIONS 1,571.44 1,571.44 2,000.00 428.56 78.6 01-0383-15-00 MISCELLANEOUS REVENUE 11,797.25 11,797.25 .00 ( 11,797.25).0 01-0383-16-00 INSURANCE REIMBURSEABLES 1,329.31 1,329.31 .00 ( 1,329.31).0 01-0385-00-00 FIRE DEPT IMPACT FEES 94,534.92 94,534.92 313,950.00 219,415.08 30.1 01-0399-00-00 CARRY OVER .00 .00 6,309,626.00 6,309,626.00 .0 TOTAL FUND REVENUE 2,273,674.56 2,273,674.56 19,342,350.00 17,068,675.44 11.8 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:20AM PAGE: 5 RESERVES 01-0410-19-00 RESERVES, EMERGENCIES .00 .00 480,673.00 480,673.00 .0 TOTAL RESERVES .00 .00 480,673.00 480,673.00 .0 ADMINISTRATION 01-0413-01-00 P&Z COMMISSIONERS COMPENSATION 780.00 780.00 4,200.00 3,420.00 18.6 01-0413-02-00 DESIGN REVIEW BRD COMPENSATION 750.00 750.00 5,000.00 4,250.00 15.0 01-0413-05-00 OFFICE EXPENSES 3,887.64 3,887.64 25,000.00 21,112.36 15.6 01-0413-06-00 PRINTING & DISTRIBUTION .00 .00 500.00 500.00 .0 01-0413-07-00 POSTAGE 1,712.47 1,712.47 12,500.00 10,787.53 13.7 01-0413-08-00 LEGAL ADVERTISING/PUBLICATION 923.24 923.24 5,000.00 4,076.76 18.5 01-0413-10-00 INSURANCE - PROPERTY 27,460.00 27,460.00 65,000.00 37,540.00 42.3 01-0413-12-00 PERSONNEL TRAINING .00 .00 3,000.00 3,000.00 .0 01-0413-13-00 TRAVEL & PER DIEM 154.00 154.00 2,000.00 1,846.00 7.7 01-0413-14-00 PROFESSIONAL DUES AND SERVICES 33,598.15 33,598.15 168,350.00 134,751.85 20.0 01-0413-25-00 MISCELLANEOUS 1.98 1.98 20,000.00 19,998.02 .0 01-0413-28-00 RESOURCE MATERIALS 1,578.11 1,578.11 6,500.00 4,921.89 24.3 01-0413-29-00 REAL PROPERTY TAXES - CITY 238.50 238.50 250.00 11.50 95.4 01-0413-31-00 ENGINEERING FEES - DEVELOPERS 28,343.13 28,343.13 175,000.00 146,656.87 16.2 01-0413-33-00 ATTORNEY FEES - DEVELOPERS 7,825.50 7,825.50 20,000.00 12,174.50 39.1 01-0413-37-00 BACKGROUND CHECK-PERMITS/LIC 319.25 319.25 2,000.00 1,680.75 16.0 01-0413-40-00 INSURANCE REIMBURSEABLES 2,242.44 2,242.44 .00 ( 2,242.44).0 01-0413-44-00 PHOTOS - MAYOR/CITY COUNCIL .00 .00 900.00 900.00 .0 01-0413-50-00 JOB POSTINGS .00 .00 2,500.00 2,500.00 .0 01-0413-51-00 BACKGROUND CHK, PRE-EMPLOYMENT .00 .00 1,000.00 1,000.00 .0 01-0413-52-00 DRUG TESTING, PRE-EMPLOYMENT 288.00 288.00 1,000.00 712.00 28.8 TOTAL ADMINISTRATION 110,102.41 110,102.41 519,700.00 409,597.59 21.2 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,000.00 3,026.92 24.3 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 198.35 198.35 1,800.00 1,601.65 11.0 01-0415-24-00 WORKERS' COMPENSATION 43,750.12 43,750.12 44,000.00 249.88 99.4 01-0415-24-01 WORK COMP/BOARDS-COMMISSIONS 76.75 76.75 200.00 123.25 38.4 01-0415-28-00 UNEMPLOYMENT BENEFITS .00 .00 5,500.00 5,500.00 .0 TOTAL PERSONNEL 59,237.02 59,237.02 112,580.00 53,342.98 52.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:20AM PAGE: 6 CONTRACTS & AGREEMENTS 01-0416-02-00 CITY ATTORNEY 18,454.00 18,454.00 250,000.00 231,546.00 7.4 01-0416-05-00 PROSECUTOR 16,003.00 16,003.00 64,000.00 47,997.00 25.0 01-0416-06-00 IDAHO HUMANE SOCIETY 52,167.94 52,167.94 160,480.00 108,312.06 32.5 01-0416-07-00 CITY ENGINEERING .00 .00 20,000.00 20,000.00 .0 01-0416-08-00 CITY AUDITOR SERVICES .00 .00 21,000.00 21,000.00 .0 01-0416-09-00 LAW ENFORCEMENT DEPARTMENT 620,917.83 620,917.83 3,725,510.00 3,104,592.17 16.7 01-0416-34-00 BUDGET RESERVES, FY 1ST QTR .00 .00 97,647.00 97,647.00 .0 01-0416-35-00 ADMINISTRATION RESERVES 598.00 598.00 200,000.00 199,402.00 .3 01-0416-46-00 ALLUMBAUGH HOUSE 4,437.25 4,437.25 24,020.00 19,582.75 18.5 01-0416-49-00 DRUGFREE IDAHO 431.43 431.43 1,500.00 1,068.57 28.8 01-0416-54-00 IDAHO SUICIDE PREVENTION .00 .00 10,000.00 10,000.00 .0 01-0416-56-00 CRIME STOPPERS 3,520.00 3,520.00 3,736.00 216.00 94.2 TOTAL CONTRACTS & AGREEMENTS 716,529.45 716,529.45 4,577,893.00 3,861,363.55 15.7 CODE ENFORCEMENT 01-0417-00-00 WEED ABATEMENT .00 .00 1,000.00 1,000.00 .0 TOTAL CODE ENFORCEMENT .00 .00 1,000.00 1,000.00 .0 RESTRICTED 01-0422-02-00 IDAHO OPIOID SUPPORT .00 .00 15,000.00 15,000.00 .0 01-0422-06-00 FIELD OF HONOR .00 .00 20,000.00 20,000.00 .0 01-0422-15-00 MAYOR'S SCHOLARSHIP FUND .00 .00 4,000.00 4,000.00 .0 TOTAL RESTRICTED .00 .00 39,000.00 39,000.00 .0 PUBLIC AFFAIRS/COMM RELATIONS 01-0462-01-00 PUBLIC RELATIONS 1,131.77 1,131.77 6,000.00 4,868.23 18.9 01-0462-02-00 AWARDS & RECOGNITIONS .00 .00 1,500.00 1,500.00 .0 TOTAL PUBLIC AFFAIRS/COMM RELATIONS 1,131.77 1,131.77 7,500.00 6,368.23 15.1 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 GENERAL FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:21AM PAGE: 7 GENERAL FUND TRANSFERS 01-0463-01-00 MUSEUM DEPT TRANSFER 32,326.43 32,326.43 176,950.00 144,623.57 18.3 01-0463-02-00 ARTS COMMISSION TRANSFER .00 .00 75,120.00 75,120.00 .0 01-0463-04-00 HISTORICAL COMMISSION TRANSFER .00 .00 6,900.00 6,900.00 .0 01-0463-05-00 SPECIAL EVENTS TRANSFER .00 .00 192,365.00 192,365.00 .0 01-0463-06-00 RECREATION PARKS-REC TRANSFER 94,479.00 94,479.00 639,420.00 544,941.00 14.8 01-0463-07-00 CAPITAL PROJECTS TRANSFER 581,452.97 581,452.97 2,627,553.00 2,046,100.03 22.1 01-0463-08-00 EAGLE FUN DAYS TRANSFER 127,103.43 127,103.43 90,550.00 ( 36,553.43)140.4 01-0463-11-00 PUBLIC WORKS TRANSFER 326,462.27 326,462.27 3,037,006.00 2,710,543.73 10.8 01-0463-11-01 EXECUTIVE DEPT TRANSFER 101,240.11 101,240.11 647,311.00 546,070.89 15.6 01-0463-12-00 CITY HALL BOND FUND TRANSFER .00 .00 104,000.00 104,000.00 .0 01-0463-12-01 CLERK/TREAS DEPT TRANSFER 162,007.49 162,007.49 823,180.00 661,172.51 19.7 01-0463-13-01 BUILDING DEPT TRANSFER 218,234.64 218,234.64 1,021,640.00 803,405.36 21.4 01-0463-14-01 PLANNING AND ZONING DEPT TRANS 272,513.28 272,513.28 1,332,040.00 1,059,526.72 20.5 01-0463-15-00 LIBRARY TRANSFER .00 .00 1,402,353.00 1,402,353.00 .0 01-0463-18-01 IT DEPT TRANSFER 186,146.22 186,146.22 1,010,650.00 824,503.78 18.4 01-0463-26-01 ECONOMIC DEV DEPT TRANSFER 757.06 757.06 .00 ( 757.06).0 TOTAL GENERAL FUND TRANSFERS 2,102,722.90 2,102,722.90 13,187,038.00 11,084,315.10 16.0 COMMUNITY PROJECTS-CAP OUTLAY 01-0468-10-00 VRT HWY 44 EXPRESS SRV ENHANC .00 .00 93,316.00 93,316.00 .0 01-0468-10-01 VRT EAGLE SENIOR CITIZENS .00 .00 9,700.00 9,700.00 .0 TOTAL COMMUNITY PROJECTS-CAP OUTLA .00 .00 103,016.00 103,016.00 .0 FIRE DEPARTMENT IMPACT FEES 01-0469-00-00 FIRE DEPT IMPACT FEES 78,022.44 78,022.44 313,950.00 235,927.56 24.9 TOTAL FIRE DEPARTMENT IMPACT FEES 78,022.44 78,022.44 313,950.00 235,927.56 24.9 TOTAL FUND EXPENDITURES 3,067,745.99 3,067,745.99 19,342,350.00 16,274,604.01 15.9 NET REVENUE OVER EXPENDITURES ( 794,071.43)( 794,071.43).00 794,071.43 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 LIBRARY FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:21AM PAGE: 8 ASSETS 06-0101-00-00 CASH 5,148.62 06-0103-00-00 LIBRARY/PETTY CASH 300.00 06-0104-00-00 PETTY CASH-CHILDRENS PROGRAMS 300.00 06-0107-00-00 LIBRARY/TAXES RECEIVABLE 6,787.44 06-0151-25-00 FIRST INTERSTATE INVESTMENT 700,644.30 06-0170-00-00 HRA 10% DEPOSIT 1,872.00 TOTAL ASSETS 715,052.36 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 14,119.08 06-0217-09-00 WORKERS' COMPENSATION 15,323.87 06-0217-10-00 HSA CONTRIBUTION 2,454.00 06-0226-00-00 DEFERRED REVENUE 6,220.06 TOTAL LIABILITIES 63,707.83 FUND EQUITY 06-0271-00-00 LIBRARY/FUND BALANCE 962,049.97 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 310,705.44) BALANCE - CURRENT DATE ( 310,705.44) TOTAL FUND EQUITY 651,344.53 TOTAL LIABILITIES AND EQUITY 715,052.36 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 LIBRARY FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:21AM PAGE: 9 REVENUE 06-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 1,402,353.00 1,402,353.00 .0 06-0356-01-00 LIBRARY/PENALTY & INT PROP TXS .00 .00 1,500.00 1,500.00 .0 06-0361-20-00 LIBRARY/FINES/FEES 1,214.97 1,214.97 1,000.00 ( 214.97)121.5 06-0361-20-01 LOST ITEMS 1,562.93 1,562.93 2,500.00 937.07 62.5 06-0361-21-00 LIBRARY/COPY MACHINE REVENUE 502.76 502.76 1,200.00 697.24 41.9 06-0361-21-01 3 D PRINTING 52.20 52.20 400.00 347.80 13.1 06-0371-25-00 BANK INTEREST 529.13 529.13 1,200.00 670.87 44.1 06-0379-00-00 MISCELLANEOUS 2,521.33 2,521.33 750.00 ( 1,771.33)336.2 06-0399-00-00 CARRY OVER .00 .00 372,000.00 372,000.00 .0 06-0399-01-00 BUDGET RESERVE, FY 1ST QTR .00 .00 460,000.00 460,000.00 .0 TOTAL FUND REVENUE 6,383.32 6,383.32 2,242,903.00 2,236,519.68 .3 EXPENDITURES RESERVES 06-0410-01-00 RESERVES .00 .00 470,000.00 470,000.00 .0 06-0410-01-01 RESERVES, LIBRARY MASTER PLAN .00 .00 50,000.00 50,000.00 .0 TOTAL RESERVES .00 .00 520,000.00 520,000.00 .0 CONTRACTS/AGREEMENTS 06-0416-01-00 LEGAL - CITY ATTORNEY 262.50 262.50 10,000.00 9,737.50 2.6 06-0416-02-00 PHOTOCOPIERS 2,127.87 2,127.87 11,500.00 9,372.13 18.5 TOTAL CONTRACTS/AGREEMENTS 2,390.37 2,390.37 21,500.00 19,109.63 11.1 OPERATIONS & MAINTENANCE 06-0420-01-00 ADMINISTRATION 2,799.39 2,799.39 15,000.00 12,200.61 18.7 06-0420-03-00 OPERATIONS SUBSCRIPTIONS 101.70 101.70 43,924.00 43,822.30 .2 06-0420-04-00 MARKETING 4,860.99 4,860.99 15,000.00 10,139.01 32.4 06-0420-04-01 OUTREACH .00 .00 2,000.00 2,000.00 .0 06-0420-05-00 OFFICE SUPPLIES 2,219.53 2,219.53 8,500.00 6,280.47 26.1 06-0420-05-01 MATERIAL PROCESSING SUPPLIES 911.48 911.48 5,000.00 4,088.52 18.2 06-0420-06-00 UNIFORMS 433.54 433.54 4,180.00 3,746.46 10.4 06-0420-07-00 SMALL FURNITURE REPLACEMENT 1,691.20 1,691.20 1,500.00 ( 191.20)112.8 06-0420-09-00 MAINTENANCE AGREEMENTS .00 .00 27,910.00 27,910.00 .0 06-0420-10-00 POSTAGE .00 .00 2,500.00 2,500.00 .0 06-0420-11-00 SUBSCRIPTIONS & MEMBERSHIPS 1,803.35 1,803.35 9,030.00 7,226.65 20.0 06-0420-13-00 PRINTING AND PUBLISHING .00 .00 1,200.00 1,200.00 .0 TOTAL OPERATIONS & MAINTENANCE 14,821.18 14,821.18 135,744.00 120,922.82 10.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:21AM PAGE: 10 LYNX1 CONSORTIUM 06-0430-00-00 LYNX! SYSTEM .00 .00 25,000.00 25,000.00 .0 06-0430-02-00 LYNX! COURIER 3,693.40 3,693.40 14,124.00 10,430.60 26.2 TOTAL LYNX1 CONSORTIUM 3,693.40 3,693.40 39,124.00 35,430.60 9.4 COST RECOVERY OR PASS THRU 06-0435-00-00 CREDIT CARD PROCESSING FEE 538.85 538.85 3,000.00 2,461.15 18.0 06-0435-01-00 3D PRINTING .00 .00 400.00 400.00 .0 06-0435-02-00 LOST ITEMS REFUNDS 5.00 5.00 300.00 295.00 1.7 06-0435-03-00 OPEN ACCESS 288.80 288.80 1,200.00 911.20 24.1 TOTAL COST RECOVERY OR PASS THRU 832.65 832.65 4,900.00 4,067.35 17.0 TECHNOLOGY 06-0440-00-00 COMPUTER SOFTWARE .00 .00 10,650.00 10,650.00 .0 06-0440-01-00 COMPUTER MAINTENANCE & REPAIR .00 .00 1,250.00 1,250.00 .0 06-0440-02-00 COMPUTER EQUIPMENT (SMALL).00 .00 3,100.00 3,100.00 .0 TOTAL TECHNOLOGY .00 .00 15,000.00 15,000.00 .0 GUEST RESOURCES 06-0450-00-00 BOOKS 32,205.11 32,205.11 143,116.00 110,910.89 22.5 06-0450-01-00 PRINT VENDOR PROCESSING 1,052.58 1,052.58 7,376.00 6,323.42 14.3 06-0450-02-00 BOOKS -DIGITAL 3,558.63 3,558.63 63,682.00 60,123.37 5.6 06-0450-03-00 MAGAZINES & NEWSPAPERS 3,248.51 3,248.51 4,308.00 1,059.49 75.4 06-0450-03-01 MAGAZINES - DIGITAL .00 .00 10,647.00 10,647.00 .0 06-0450-04-00 MEDIA 6,541.57 6,541.57 79,073.00 72,531.43 8.3 06-0450-05-00 MEDIA - DIGITAL 1,178.99 1,178.99 61,434.00 60,255.01 1.9 06-0450-06-00 DATABASES 3,891.00 3,891.00 11,845.00 7,954.00 32.9 06-0450-07-00 HOTSPOT 1,019.17 1,019.17 2,800.00 1,780.83 36.4 TOTAL GUEST RESOURCES 52,695.56 52,695.56 384,281.00 331,585.44 13.7 GUEST CLASSES & EVENTS 06-0455-00-00 CLASSES & EVENTS 4,015.74 4,015.74 20,000.00 15,984.26 20.1 TOTAL GUEST CLASSES & EVENTS 4,015.74 4,015.74 20,000.00 15,984.26 20.1 PERSONNEL 06-0461-10-00 SALARIES - FULL TIME 137,040.16 137,040.16 526,900.00 389,859.84 26.0 06-0461-11-00 OVERTIME 1,977.36 1,977.36 5,000.00 3,022.64 39.6 06-0461-15-00 SALARIES - PART TIME 42,534.88 42,534.88 276,000.00 233,465.12 15.4 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 LIBRARY FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:22AM PAGE: 11 06-0461-15-01 SALARIES - PERSONNEL SERVICES 1,156.10 1,156.10 .00 ( 1,156.10).0 06-0461-21-00 FICA 13,723.12 13,723.12 55,183.00 41,459.88 24.9 06-0461-22-00 PERSI 16,601.57 16,601.57 56,648.00 40,046.43 29.3 06-0461-23-00 HRA BUY-DOWN .00 .00 5,500.00 5,500.00 .0 06-0461-23-01 HRA/COBRA ADMIN FEES 173.15 173.15 900.00 726.85 19.2 06-0461-24-00 WORKERS' COMPENSATION 1,663.95 1,663.95 2,918.00 1,254.05 57.0 06-0461-25-00 INSURANCE 13,233.50 13,233.50 78,405.00 65,171.50 16.9 06-0461-26-00 HSA CONTRIBUTION 630.00 630.00 8,160.00 7,530.00 7.7 06-0461-27-00 PTO CASH OUT .00 .00 10,000.00 10,000.00 .0 06-0461-28-00 UNEMPLOYMENT BENEFITS .00 .00 18,540.00 18,540.00 .0 06-0461-29-00 EMPLOYMENT TESTING .00 .00 1,000.00 1,000.00 .0 TOTAL PERSONNEL 228,733.79 228,733.79 1,045,154.00 816,420.21 21.9 STAFF DEVELOPMENT 06-0463-00-00 TRAVEL & PER DIEM 416.66 416.66 11,400.00 10,983.34 3.7 06-0463-01-00 MILEAGE REIMBURSEMENT .00 .00 500.00 500.00 .0 06-0463-02-00 TRAINING .00 .00 1,000.00 1,000.00 .0 06-0463-03-00 CONTINUING EDUCATION 2,850.00 2,850.00 6,300.00 3,450.00 45.2 06-0463-08-00 VIRTUAL TRAINING .00 .00 1,500.00 1,500.00 .0 TOTAL STAFF DEVELOPMENT 3,266.66 3,266.66 20,700.00 17,433.34 15.8 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 6,394.45 6,394.45 27,000.00 20,605.55 23.7 06-0464-03-00 TELEPHONE .00 .00 1,000.00 1,000.00 .0 06-0464-04-00 SECURITY SYSTEM .00 .00 3,000.00 3,000.00 .0 06-0464-06-00 GROUNDS .00 .00 1,000.00 1,000.00 .0 06-0464-07-00 FLOOR MATS 244.96 244.96 1,500.00 1,255.04 16.3 TOTAL FACILITY (BLDGS & GROUNDS)6,639.41 6,639.41 36,500.00 29,860.59 18.2 TOTAL FUND EXPENDITURES 317,088.76 317,088.76 2,242,903.00 1,925,814.24 14.1 NET REVENUE OVER EXPENDITURES ( 310,705.44)( 310,705.44).00 310,705.44 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 MUSEUM FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:22AM PAGE: 12 LIABILITIES AND EQUITY LIABILITIES 07-0217-03-00 FICA 246.54 07-0217-04-00 MUSEUM/PERSI RETIREMENT 240.94 07-0217-07-00 MUSEUM HEALTH INSURANCE 868.21 07-0217-09-00 WORKERS' COMPENSATION 1,513.57 TOTAL LIABILITIES 2,869.26 FUND EQUITY 07-0271-00-00 MUSEUM FUND BALANCE ( 4,421.71) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 1,552.45 BALANCE - CURRENT DATE 1,552.45 TOTAL FUND EQUITY ( 2,869.26) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 MUSEUM FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:22AM PAGE: 13 REVENUE 07-0316-12-00 FUNDING FROM GENERAL FUND 32,326.43 32,326.43 176,950.00 144,623.57 18.3 07-0376-00-00 MUSEUM CONTRIBUTIONS/DONATIONS 202.00 202.00 500.00 298.00 40.4 07-0379-00-00 MUSEUM MISC REVENUE 300.00 300.00 25.00 ( 275.00)1200.0 07-0379-02-00 ARCADIA BOOKS SALES/ROYALTIES .00 .00 250.00 250.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 25.00 25.00 .0 TOTAL FUND REVENUE 32,828.43 32,828.43 177,755.00 144,926.57 18.5 EXPENDITURES PERSONNEL 07-0420-10-00 SALARIES - FULL TIME 24,406.44 24,406.44 102,900.00 78,493.56 23.7 07-0420-15-00 SALARIES - PART TIME .00 .00 20,000.00 20,000.00 .0 07-0420-21-00 FICA 1,867.07 1,867.07 9,500.00 7,632.93 19.7 07-0420-22-00 PERSI 2,914.15 2,914.15 12,350.00 9,435.85 23.6 07-0420-24-00 WORKERS' COMPENSATION 44.28 44.28 .00 ( 44.28).0 07-0420-25-00 INSURANCE 1,375.20 1,375.20 6,100.00 4,724.80 22.5 07-0420-27-00 HRA BUY DOWN .00 .00 3,080.00 3,080.00 .0 TOTAL PERSONNEL 30,607.14 30,607.14 153,930.00 123,322.86 19.9 EDUCATION 07-0461-02-00 ASSOCIATION MEMBERSHIP 118.00 118.00 325.00 207.00 36.3 07-0461-03-00 CONFERENCES & SEMINARS 50.00 50.00 500.00 450.00 10.0 07-0461-04-00 TRAVEL & PER DIEM .00 .00 750.00 750.00 .0 TOTAL EDUCATION 168.00 168.00 1,575.00 1,407.00 10.7 ADMINISTRATION 07-0462-30-00 CONSERVATION/PRESERVATION .00 .00 250.00 250.00 .0 07-0462-31-00 OFFICE SUPPLIES 69.99 69.99 1,000.00 930.01 7.0 07-0462-32-00 ARCHIVAL SUPPLIES .00 .00 1,000.00 1,000.00 .0 07-0462-33-00 PUBLICITY-PRINTING .00 .00 500.00 500.00 .0 07-0462-34-00 RESEARCH MATERIAL 75.40 75.40 200.00 124.60 37.7 07-0462-35-00 UNIFORMS 280.50 280.50 400.00 119.50 70.1 07-0462-68-00 MUSEUM PROGRAMS 74.95 74.95 1,500.00 1,425.05 5.0 07-0462-69-00 MISCELLANEOUS .00 .00 5,700.00 5,700.00 .0 07-0462-73-00 EAGLE BOOK-ARCADIA PUBLISHING .00 .00 300.00 300.00 .0 TOTAL ADMINISTRATION 500.84 500.84 10,850.00 10,349.16 4.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 MUSEUM FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:22AM PAGE: 14 EXHIBITS 07-0463-01-00 DISPLAY SUPPLIES .00 .00 300.00 300.00 .0 07-0463-02-00 EXHIBIT ITEMS .00 .00 100.00 100.00 .0 07-0463-03-00 EXHIBIT CONSTRUCTION .00 .00 1,000.00 1,000.00 .0 07-0463-04-00 ANNUAL EXHIBIT .00 .00 10,000.00 10,000.00 .0 TOTAL EXHIBITS .00 .00 11,400.00 11,400.00 .0 TOTAL FUND EXPENDITURES 31,275.98 31,275.98 177,755.00 146,479.02 17.6 NET REVENUE OVER EXPENDITURES 1,552.45 1,552.45 .00 ( 1,552.45).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 PARK IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:22AM PAGE: 15 ASSETS 08-0101-00-00 CASH 44,178.44 08-0151-25-00 FIRST INTERSTATE INVESTMENT 1,868,992.76 TOTAL ASSETS 1,913,171.20 LIABILITIES AND EQUITY FUND EQUITY 08-0271-00-00 PARK FUND/FUND BALANCE 1,952,745.69 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 39,574.49) BALANCE - CURRENT DATE ( 39,574.49) TOTAL FUND EQUITY 1,913,171.20 TOTAL LIABILITIES AND EQUITY 1,913,171.20 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 PARK IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:22AM PAGE: 16 REVENUE 08-0322-19-00 PARKS DEVELOPMENT IMPACT FEES 43,513.08 43,513.08 390,502.00 346,988.92 11.1 08-0371-25-00 BANK INTEREST 1,164.43 1,164.43 4,500.00 3,335.57 25.9 08-0399-00-00 CARRY OVER .00 .00 3,933,000.00 3,933,000.00 .0 TOTAL FUND REVENUE 44,677.51 44,677.51 4,328,002.00 4,283,324.49 1.0 EXPENDITURES CAPITAL IMPROVEMENTS 08-0438-37-00 CAPITAL IMPROVEMENTS 84,252.00 84,252.00 4,328,002.00 4,243,750.00 2.0 TOTAL CAPITAL IMPROVEMENTS 84,252.00 84,252.00 4,328,002.00 4,243,750.00 2.0 TOTAL FUND EXPENDITURES 84,252.00 84,252.00 4,328,002.00 4,243,750.00 2.0 NET REVENUE OVER EXPENDITURES ( 39,574.49)( 39,574.49).00 39,574.49 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 RECREATION - SPECIAL EVENTS FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:22AM PAGE: 17 ASSETS 09-0101-00-00 CASH 25,925.58 TOTAL ASSETS 25,925.58 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 14,541.03 09-0217-09-00 WORKERS' COMPENSATION 15,045.11 09-0217-10-00 HSA CONTRIBUTION 3,319.35 TOTAL LIABILITIES 33,486.03 FUND EQUITY 09-0271-00-00 FUND BALANCE 31,185.68 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 38,746.13) BALANCE - CURRENT DATE ( 38,746.13) TOTAL FUND EQUITY ( 7,560.45) TOTAL LIABILITIES AND EQUITY 25,925.58 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 RECREATION - SPECIAL EVENTS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:22AM PAGE: 18 REVENUE 09-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 192,365.00 192,365.00 .0 09-0347-06-00 CHRISTMAS MARKET 2,410.12 2,410.12 2,750.00 339.88 87.6 09-0347-08-00 SATURDAY MARKET .00 .00 22,500.00 22,500.00 .0 09-0347-10-00 GAZEBO CONCERT SERIES .00 .00 825.00 825.00 .0 09-0347-11-00 HARVEST FEST MARKET 1,474.44 1,474.44 2,750.00 1,275.56 53.6 09-0376-12-00 MISCELLANEOUS REVENUE 10.00 10.00 .00 ( 10.00).0 09-0376-13-00 SPONSORSHIPS 1,000.00 1,000.00 15,000.00 14,000.00 6.7 09-0376-15-00 EVENT APPLICATION FEES 300.00 300.00 1,500.00 1,200.00 20.0 09-0376-17-00 SECURITY DEPOSIT .00 .00 1,200.00 1,200.00 .0 TOTAL FUND REVENUE 5,194.56 5,194.56 238,890.00 233,695.44 2.2 EXPENDITURES PERSONNEL 09-0420-10-00 SALARIES - FULL TIME 21,285.80 21,285.80 115,800.00 94,514.20 18.4 09-0420-11-00 OVERTIME 43.01 43.01 2,000.00 1,956.99 2.2 09-0420-21-00 FICA 1,618.26 1,618.26 8,900.00 7,281.74 18.2 09-0420-22-00 PERSI 2,546.69 2,546.69 13,900.00 11,353.31 18.3 09-0420-24-00 WORKERS' COMPENSATION 640.71 640.71 .00 ( 640.71).0 09-0420-25-00 INSURANCE 2,450.34 2,450.34 13,900.00 11,449.66 17.6 09-0420-26-00 HSA CONTRIBUTION 150.00 150.00 1,200.00 1,050.00 12.5 09-0420-27-00 HRA BUY-DOWN .00 .00 1,540.00 1,540.00 .0 09-0420-29-00 PTO CASH OUT .00 .00 2,500.00 2,500.00 .0 TOTAL PERSONNEL 28,734.81 28,734.81 159,740.00 131,005.19 18.0 ADMINISTRATION 09-0463-11-00 OFFICE SUPPLIES .00 .00 800.00 800.00 .0 09-0463-12-00 PROMOTIONS 1,030.28 1,030.28 14,000.00 12,969.72 7.4 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 1,000.00 1,000.00 .0 09-0463-23-00 GAS/MILEAGE 79.98 79.98 100.00 20.02 80.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 1,110.26 1,110.26 25,150.00 24,039.74 4.4 ACTIVITIES 09-0467-02-00 EAGLE SATURDAY MARKET 250.00 250.00 11,000.00 10,750.00 2.3 09-0467-03-00 CHRISTMAS MARKET 7,067.36 7,067.36 8,000.00 932.64 88.3 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 RECREATION - SPECIAL EVENTS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:23AM PAGE: 19 09-0467-04-00 GAZEBO CONCERT SERIES .00 .00 10,000.00 10,000.00 .0 09-0467-05-00 GENERAL EVENTS 1,905.48 1,905.48 10,000.00 8,094.52 19.1 09-0467-06-00 EAGLE HARVEST FEST 4,048.86 4,048.86 4,000.00 ( 48.86)101.2 09-0467-07-00 EVENT EQUIPMENT PURCHASES 823.92 823.92 3,000.00 2,176.08 27.5 09-0467-08-00 EVENT EQUIPMENT RENTAL .00 .00 8,000.00 8,000.00 .0 TOTAL ACTIVITIES 14,095.62 14,095.62 54,000.00 39,904.38 26.1 TOTAL FUND EXPENDITURES 43,940.69 43,940.69 238,890.00 194,949.31 18.4 NET REVENUE OVER EXPENDITURES ( 38,746.13)( 38,746.13).00 38,746.13 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 EAGLE HISTORICAL COMMISSION FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:23AM PAGE: 20 ASSETS 10-0101-00-00 CASH 20,610.34 TOTAL ASSETS 20,610.34 LIABILITIES AND EQUITY FUND EQUITY 10-0271-00-00 FUND BALANCE 21,002.34 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 392.00) BALANCE - CURRENT DATE ( 392.00) TOTAL FUND EQUITY 20,610.34 TOTAL LIABILITIES AND EQUITY 20,610.34 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 EAGLE HISTORICAL COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:23AM PAGE: 21 REVENUE 10-0316-12-00 FUNDING FROM GENERAL FUND .00 .00 6,900.00 6,900.00 .0 10-0333-01-00 GRANTS, STATE .00 .00 6,000.00 6,000.00 .0 TOTAL FUND REVENUE .00 .00 12,900.00 12,900.00 .0 EXPENDITURES ADMINISTRATION 10-0462-02-00 PUBLICITY - PRINTING 392.00 392.00 500.00 108.00 78.4 10-0462-05-00 EDUCATION/TRAINING .00 .00 200.00 200.00 .0 TOTAL ADMINISTRATION 392.00 392.00 700.00 308.00 56.0 PROGRAMS 10-0464-08-00 COMM ENGAGEMENT/SPECIAL EVENTS .00 .00 200.00 200.00 .0 TOTAL PROGRAMS .00 .00 200.00 200.00 .0 GRANTS 10-0465-04-00 SHPO GRANT PROJECTS .00 .00 12,000.00 12,000.00 .0 TOTAL GRANTS .00 .00 12,000.00 12,000.00 .0 TOTAL FUND EXPENDITURES 392.00 392.00 12,900.00 12,508.00 3.0 NET REVENUE OVER EXPENDITURES ( 392.00)( 392.00).00 392.00 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 EXECUTIVE DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:23AM 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,507.45 11-0217-09-00 WORKERS' COMPENSATION 8,026.55 11-0217-10-00 HSA CONTRIBUTION ( 224.00) TOTAL LIABILITIES 13,188.56 FUND EQUITY 11-0271-00-00 FUND BALANCE ( 12,592.83) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 595.73) BALANCE - CURRENT DATE ( 595.73) TOTAL FUND EQUITY ( 13,188.56) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 EXECUTIVE DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:23AM PAGE: 23 REVENUE 11-0301-00-00 FUNDING FROM GENERAL FUND 101,240.11 101,240.11 647,311.00 546,070.89 15.6 TOTAL FUND REVENUE 101,240.11 101,240.11 647,311.00 546,070.89 15.6 EXPENDITURES ADMINISTRATION 11-0413-04-00 UNIFORMS .00 .00 600.00 600.00 .0 11-0413-05-00 OFFICE EXPENSES 199.74 199.74 750.00 550.26 26.6 11-0413-06-00 DUPLICATION/PUBLISHING/PRINT .00 .00 750.00 750.00 .0 11-0413-12-00 PERSONNEL TRAINING 175.00 175.00 5,000.00 4,825.00 3.5 11-0413-13-00 TRAVEL & PER DIEM 15.00 15.00 6,000.00 5,985.00 .3 11-0413-14-00 PROFESSIONAL DUES 628.97 628.97 4,453.00 3,824.03 14.1 11-0413-20-00 MARKETING .00 .00 15,028.00 15,028.00 .0 TOTAL ADMINISTRATION 1,018.71 1,018.71 32,581.00 31,562.29 3.1 PERSONNEL 11-0415-10-00 SALARIES - FULL TIME 77,219.43 77,219.43 336,000.00 258,780.57 23.0 11-0415-11-00 OVERTIME 368.90 368.90 500.00 131.10 73.8 11-0415-21-00 FICA 5,771.44 5,771.44 25,800.00 20,028.56 22.4 11-0415-22-00 PERSI 9,264.06 9,264.06 40,200.00 30,935.94 23.0 11-0415-24-00 WORKERS' COMPENSATION 1,495.74 1,495.74 .00 ( 1,495.74).0 11-0415-25-00 INSURANCE 6,271.38 6,271.38 38,700.00 32,428.62 16.2 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 100,570.95 100,570.95 455,480.00 354,909.05 22.1 STATE OF THE CITY 11-0417-01-00 STATE OF THE CITY .00 .00 4,250.00 4,250.00 .0 TOTAL STATE OF THE CITY .00 .00 4,250.00 4,250.00 .0 COMPREHENSIVE PLAN REWRITE 11-0418-00-00 COMP PLAN REWRITE .00 .00 150,000.00 150,000.00 .0 TOTAL COMPREHENSIVE PLAN REWRITE .00 .00 150,000.00 150,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 EXECUTIVE DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:23AM PAGE: 24 COMMUNITY & STAFF RELATIONS 11-0422-01-00 COMMUNITY/STAFF RELATIONS 246.18 246.18 5,000.00 4,753.82 4.9 TOTAL COMMUNITY & STAFF RELATIONS 246.18 246.18 5,000.00 4,753.82 4.9 TOTAL FUND EXPENDITURES 101,835.84 101,835.84 647,311.00 545,475.16 15.7 NET REVENUE OVER EXPENDITURES ( 595.73)( 595.73).00 595.73 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 CITY CLERK/TREAS DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:23AM 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 6,823.19 12-0217-09-00 WORKERS' COMPENSATION 7,521.13 TOTAL LIABILITIES 24,978.91 FUND EQUITY 12-0271-00-00 FUND BALANCE ( 27,232.73) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 2,253.82 BALANCE - CURRENT DATE 2,253.82 TOTAL FUND EQUITY ( 24,978.91) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 CITY CLERK/TREAS DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:23AM PAGE: 26 REVENUE 12-0301-00-00 FUNDING FROM GENERAL FUND 162,007.49 162,007.49 823,180.00 661,172.51 19.7 TOTAL FUND REVENUE 162,007.49 162,007.49 823,180.00 661,172.51 19.7 EXPENDITURES ADMINISTRATION 12-0413-05-00 OFFICE EXPENSES 170.01 170.01 5,000.00 4,829.99 3.4 12-0413-06-00 DUPLICATION/PUBLISHING/PRINT .00 .00 150.00 150.00 .0 12-0413-12-00 PERSONNEL TRAINING & RESOURCES .00 .00 12,500.00 12,500.00 .0 12-0413-13-00 TRAVEL & PER DIEM 1,155.59 1,155.59 10,000.00 8,844.41 11.6 12-0413-14-00 PROFESSIONAL DUES 630.00 630.00 5,500.00 4,870.00 11.5 12-0413-29-00 UNIFORMS .00 .00 800.00 800.00 .0 12-0413-30-00 MISCELLANEOUS .00 .00 500.00 500.00 .0 TOTAL ADMINISTRATION 1,955.60 1,955.60 34,450.00 32,494.40 5.7 PERSONNEL 12-0415-10-00 SALARIES - FULL TIME 118,677.31 118,677.31 570,500.00 451,822.69 20.8 12-0415-11-00 OVERTIME .00 .00 4,000.00 4,000.00 .0 12-0415-21-00 FICA 8,805.43 8,805.43 43,800.00 34,994.57 20.1 12-0415-22-00 PERSI 14,170.06 14,170.06 64,750.00 50,579.94 21.9 12-0415-23-00 HRA BUY- DOWN 128.31 128.31 10,780.00 10,651.69 1.2 12-0415-23-02 HSA CONTRIBUTION 300.00 300.00 1,200.00 900.00 25.0 12-0415-24-00 WORKERS' COMPENSATION 215.33 215.33 .00 ( 215.33).0 12-0415-25-00 INSURANCE 15,501.63 15,501.63 83,700.00 68,198.37 18.5 12-0415-26-00 PTO CASH OUT .00 .00 10,000.00 10,000.00 .0 TOTAL PERSONNEL 157,798.07 157,798.07 788,730.00 630,931.93 20.0 TOTAL FUND EXPENDITURES 159,753.67 159,753.67 823,180.00 663,426.33 19.4 NET REVENUE OVER EXPENDITURES 2,253.82 2,253.82 .00 ( 2,253.82).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 BUILDING DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:23AM 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 10,115.85 13-0217-09-00 WORKERS' COMPENSATION 50,780.81 13-0217-10-00 HSA CONTRIBUTION ( 1,900.00) TOTAL LIABILITIES 67,482.59 FUND EQUITY 13-0271-00-00 FUND BALANCE ( 96,243.86) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 28,861.27 BALANCE - CURRENT DATE 28,861.27 TOTAL FUND EQUITY ( 67,382.59) TOTAL LIABILITIES AND EQUITY 100.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 BUILDING DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:24AM PAGE: 28 REVENUE 13-0301-00-00 FUNDING FROM GENERAL FUND 218,234.64 218,234.64 1,021,640.00 803,405.36 21.4 TOTAL FUND REVENUE 218,234.64 218,234.64 1,021,640.00 803,405.36 21.4 EXPENDITURES ADMINISTRATION 13-0413-05-00 OFFICE EXPENSES 31.47 31.47 6,500.00 6,468.53 .5 13-0413-08-00 LEGAL ADS & PUBLICATIONS .00 .00 400.00 400.00 .0 13-0413-09-00 COMMERCIAL PLAN REVIEW 3,385.00 3,385.00 5,000.00 1,615.00 67.7 13-0413-12-00 TRAINING & CERTIFICATION RENEW 471.00 471.00 4,500.00 4,029.00 10.5 13-0413-13-00 TRAVEL & PER DIEM .00 .00 2,000.00 2,000.00 .0 13-0413-14-00 PROFESSIONAL DUES .00 .00 700.00 700.00 .0 13-0413-25-00 MISCELLANEOUS .00 .00 400.00 400.00 .0 13-0413-28-00 RESOURCE MATERIALS .00 .00 1,500.00 1,500.00 .0 13-0413-30-00 UNIFORMS .00 .00 2,000.00 2,000.00 .0 TOTAL ADMINISTRATION 3,887.47 3,887.47 23,000.00 19,112.53 16.9 PERSONNEL 13-0415-10-00 SALARIES - FULL TIME 89,786.06 89,786.06 394,800.00 305,013.94 22.7 13-0415-11-00 OVERTIME 54.59 54.59 4,000.00 3,945.41 1.4 13-0415-21-00 FICA 6,646.30 6,646.30 30,200.00 23,553.70 22.0 13-0415-22-00 PERSI 10,727.02 10,727.02 47,500.00 36,772.98 22.6 13-0415-23-00 HRA BUY-DOWN .00 .00 9,240.00 9,240.00 .0 13-0415-24-00 WORKERS' COMPENSATION 2,995.70 2,995.70 .00 ( 2,995.70).0 13-0415-25-00 INSURANCE 14,819.49 14,819.49 78,500.00 63,680.51 18.9 13-0415-26-00 HSA CONTRIBUTION 600.00 600.00 2,400.00 1,800.00 25.0 13-0415-28-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 TOTAL PERSONNEL 125,629.16 125,629.16 571,640.00 446,010.84 22.0 CONTRACTS & AGREEMENTS 13-0416-09-00 PLUMBING INSPECTOR 14,186.61 14,186.61 120,000.00 105,813.39 11.8 13-0416-11-00 MECHANICAL INSPECTOR 14,260.51 14,260.51 120,000.00 105,739.49 11.9 13-0416-13-00 BLDG INSPECTOR 6,580.00 6,580.00 61,500.00 54,920.00 10.7 13-0416-14-00 PLAN REVIEW - CONTRACT .00 .00 5,000.00 5,000.00 .0 13-0416-25-00 ELECTRICAL INSPECTOR 24,787.67 24,787.67 120,000.00 95,212.33 20.7 TOTAL CONTRACTS & AGREEMENTS 59,814.79 59,814.79 426,500.00 366,685.21 14.0 VEHICLE OPERATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 BUILDING DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:24AM PAGE: 29 13-0417-02-00 GAS AND OIL 41.95 41.95 500.00 458.05 8.4 TOTAL VEHICLE OPERATIONS 41.95 41.95 500.00 458.05 8.4 TOTAL FUND EXPENDITURES 189,373.37 189,373.37 1,021,640.00 832,266.63 18.5 NET REVENUE OVER EXPENDITURES 28,861.27 28,861.27 .00 ( 28,861.27).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 P&Z DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:24AM PAGE: 30 LIABILITIES AND EQUITY LIABILITIES 14-0216-00-00 ACCRUED PAYROLL 9,808.33 14-0217-03-00 FICA 3,391.86 14-0217-04-00 P&Z DEPT/PUBLIC RETIREMENT 5,215.16 14-0217-07-00 P&Z DEPT HEALTH INSURANCE ( 30,993.40) 14-0217-08-00 P&Z DEPT/GARNISHMENTS 203.34 14-0217-09-00 WORKERS' COMPENSATION 76,755.43 TOTAL LIABILITIES 64,380.72 FUND EQUITY 14-0271-00-00 FUND BALANCE ( 63,698.43) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 682.29) BALANCE - CURRENT DATE ( 682.29) TOTAL FUND EQUITY ( 64,380.72) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 P&Z DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:24AM PAGE: 31 REVENUE 14-0301-00-00 FUNDING FROM GENERAL FUND 272,513.28 272,513.28 1,332,040.00 1,059,526.72 20.5 TOTAL FUND REVENUE 272,513.28 272,513.28 1,332,040.00 1,059,526.72 20.5 EXPENDITURES ADMINISTRATION 14-0413-05-00 OFFICE EXPENSES 118.02 118.02 1,800.00 1,681.98 6.6 14-0413-06-00 DUPLICATION/PUBLISHING/PRNTG .00 .00 1,000.00 1,000.00 .0 14-0413-08-00 LEGAL ADS & PUBLICATIONS 547.08 547.08 8,000.00 7,452.92 6.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 1,146.00 1,146.00 2,500.00 1,354.00 45.8 14-0413-25-00 MISCELLANEOUS .00 .00 1,000.00 1,000.00 .0 14-0413-26-00 REIMBURSE-ANNEX/ZONING/DR FEES .00 .00 3,000.00 3,000.00 .0 14-0413-28-00 RESOURCE MATERIALS .00 .00 800.00 800.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 1,811.10 1,811.10 43,700.00 41,888.90 4.1 PERSONNEL 14-0415-10-00 SALARIES - FULL TIME 201,668.59 201,668.59 898,000.00 696,331.41 22.5 14-0415-11-00 OVERTIME 2,000.35 2,000.35 13,000.00 10,999.65 15.4 14-0415-21-00 FICA 15,357.43 15,357.43 69,800.00 54,442.57 22.0 14-0415-22-00 PERSI 24,318.09 24,318.09 108,900.00 84,581.91 22.3 14-0415-24-00 WORKERS' COMPENSATION 2,439.15 2,439.15 .00 ( 2,439.15).0 14-0415-25-00 INSURANCE 22,525.86 22,525.86 124,700.00 102,174.14 18.1 14-0415-26-00 HSA CONTRIBUTION 300.00 300.00 1,200.00 900.00 25.0 14-0415-29-00 PTO CASH OUT .00 .00 15,000.00 15,000.00 .0 14-0415-30-00 HRA BUY- DOWN 1,540.00 1,540.00 16,940.00 15,400.00 9.1 TOTAL PERSONNEL 270,149.47 270,149.47 1,247,540.00 977,390.53 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 1,235.00 1,235.00 10,000.00 8,765.00 12.4 TOTAL CONTRACTS & AGREEMENTS 1,235.00 1,235.00 30,000.00 28,765.00 4.1 PUBLIC RELATIONS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 P&Z DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:24AM 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 273,195.57 273,195.57 1,332,040.00 1,058,844.43 20.5 NET REVENUE OVER EXPENDITURES ( 682.29)( 682.29).00 682.29 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 RECREATION - PARKS AND REC FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:24AM PAGE: 33 LIABILITIES AND EQUITY LIABILITIES 17-0217-02-00 FEDERAL WITHOLDING TAX 29.48 17-0217-03-00 FICA 1,637.19 17-0217-04-00 PUBLIC RETIREMENT 1,079.92 17-0217-07-00 HEALTH INSURANCE ( 12,022.93) 17-0217-09-00 WORKERS' COMPENSATION 43,463.78 17-0217-10-00 HSA CONTRIBUTION ( 4,225.93) TOTAL LIABILITIES 29,961.51 FUND EQUITY 17-0271-00-00 FUND BALANCE ( 34,960.88) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 4,999.37 BALANCE - CURRENT DATE 4,999.37 TOTAL FUND EQUITY ( 29,961.51) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 RECREATION - PARKS AND REC PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:24AM PAGE: 34 REVENUE 17-0301-00-00 FUNDING FROM GENERAL FUND 94,479.00 94,479.00 639,420.00 544,941.00 14.8 17-0302-00-00 REGISTRATION 32,157.55 32,157.55 112,000.00 79,842.45 28.7 17-0302-01-00 SPONSORSHIPS .00 .00 10,000.00 10,000.00 .0 17-0302-03-00 PARK RESERVATION FEES 2,620.12 2,620.12 20,000.00 17,379.88 13.1 17-0390-00-00 CARRY OVER .00 .00 1,000.00 1,000.00 .0 TOTAL FUND REVENUE 129,256.67 129,256.67 782,420.00 653,163.33 16.5 EXPENDITURES CONTRACTS 17-0416-00-00 CONTRACT-PERMITS-CAMPS/CLASSES .00 .00 20,000.00 20,000.00 .0 17-0416-01-00 CONTRACT-PERMITS TEAM SPORTS 4,644.00 4,644.00 14,000.00 9,356.00 33.2 TOTAL CONTRACTS 4,644.00 4,644.00 34,000.00 29,356.00 13.7 PERSONNEL 17-0420-10-00 SALARIES - FULL TIME 73,094.49 73,094.49 351,200.00 278,105.51 20.8 17-0420-10-01 SALARIES - PERSONNEL SERVICES 4,707.99 4,707.99 .00 ( 4,707.99).0 17-0420-11-00 SALARIES - SEASONAL 216.19 216.19 .00 ( 216.19).0 17-0420-15-00 SALARIES - PART TIME .00 .00 115,200.00 115,200.00 .0 17-0420-18-00 OVERTIME 99.26 99.26 4,000.00 3,900.74 2.5 17-0420-21-00 FICA 5,555.08 5,555.08 35,800.00 30,244.92 15.5 17-0420-22-00 PERSI 8,744.98 8,744.98 42,100.00 33,355.02 20.8 17-0420-23-00 HRA BUY-DOWN .00 .00 4,620.00 4,620.00 .0 17-0420-24-00 WORKERS' COMPENSATION 2,680.99 2,680.99 .00 ( 2,680.99).0 17-0420-25-00 INSURANCE 7,713.43 7,713.43 51,800.00 44,086.57 14.9 17-0420-26-00 HSA CONTRIBUTION 450.00 450.00 1,200.00 750.00 37.5 17-0420-27-00 PTO CASH OUT .00 .00 5,000.00 5,000.00 .0 TOTAL PERSONNEL 103,262.41 103,262.41 610,920.00 507,657.59 16.9 RESTRICTED 17-0421-00-00 SCHOLARSHIP FUNDS .00 .00 1,000.00 1,000.00 .0 TOTAL RESTRICTED .00 .00 1,000.00 1,000.00 .0 ADMINISTRATION 17-0422-00-00 TRAINING-PROFESSIONAL DEV 435.00 435.00 2,000.00 1,565.00 21.8 17-0422-01-00 OFFICE SUPPLIES 81.20 81.20 1,000.00 918.80 8.1 17-0422-02-00 ADVERTISING/MKTING CAMP/CLASS 200.00 200.00 1,500.00 1,300.00 13.3 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:24AM PAGE: 35 17-0422-02-01 ADVERTISING/MKTNG TEAM SPORTS .00 .00 2,000.00 2,000.00 .0 17-0422-04-00 GAS/MILEAGE .00 .00 100.00 100.00 .0 17-0422-05-00 COMMUNICATION 74.00 74.00 .00 ( 74.00).0 17-0422-06-00 PRINTING AND PUBLISHING 380.53 380.53 500.00 119.47 76.1 17-0422-07-00 PROFESSIONAL DUES 200.00 200.00 1,000.00 800.00 20.0 17-0422-08-00 TRAINING .00 .00 3,000.00 3,000.00 .0 17-0422-09-00 TRAVEL/PER DIEM .00 .00 5,000.00 5,000.00 .0 17-0422-10-00 BACKGROUND CHECKS 670.79 670.79 3,000.00 2,329.21 22.4 17-0422-11-00 REFUNDS-PARK REC PROGRAMS .00 .00 7,600.00 7,600.00 .0 TOTAL ADMINISTRATION 2,041.52 2,041.52 26,700.00 24,658.48 7.7 RECREATION 17-0423-00-00 REC SUPPLIES-CAMPS & CLASSES 59.70 59.70 10,000.00 9,940.30 .6 17-0423-00-01 REC SUPPLIES-TEAM SPORTS 7,977.21 7,977.21 20,000.00 12,022.79 39.9 17-0423-01-00 UNIFORMS 5,498.92 5,498.92 15,000.00 9,501.08 36.7 17-0423-02-00 FIELD TRIPS 21.00 21.00 20,000.00 19,979.00 .1 17-0423-04-00 TRANSPORTATION SERVICES .00 .00 15,000.00 15,000.00 .0 17-0423-05-00 DADDY DAUGHTER DANCE .00 .00 1,500.00 1,500.00 .0 17-0423-07-00 GLOW IN THE PARK .00 .00 6,000.00 6,000.00 .0 17-0423-08-00 HALLOWEEN TRICK-OR-TREAT .00 .00 800.00 800.00 .0 17-0423-09-00 VETERAN'S BREAKFAST 752.54 752.54 1,000.00 247.46 75.3 17-0423-10-00 NEW PROGRAMS .00 .00 2,000.00 2,000.00 .0 TOTAL RECREATION 14,309.37 14,309.37 91,300.00 76,990.63 15.7 VEHICLES 17-0424-03-00 GAS .00 .00 1,000.00 1,000.00 .0 TOTAL VEHICLES .00 .00 1,000.00 1,000.00 .0 CAPITAL EQUIPMENT 17-0425-00-00 REC EQUIPMENT-TEAM SPORTS .00 .00 15,000.00 15,000.00 .0 17-0425-01-00 REC EQUIPMENT-CAMPS/CLASSES .00 .00 1,000.00 1,000.00 .0 TOTAL CAPITAL EQUIPMENT .00 .00 16,000.00 16,000.00 .0 CAPITAL OUTLAY 17-0460-02-00 FURNITURE .00 .00 1,500.00 1,500.00 .0 TOTAL CAPITAL OUTLAY .00 .00 1,500.00 1,500.00 .0 TOTAL FUND EXPENDITURES 124,257.30 124,257.30 782,420.00 658,162.70 15.9 NET REVENUE OVER EXPENDITURES 4,999.37 4,999.37 .00 ( 4,999.37).0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 RECREATION - PARKS AND REC YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:24AM PAGE: 36 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 IT DEPARTMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:24AM PAGE: 37 LIABILITIES AND EQUITY LIABILITIES 18-0217-03-00 FICA 555.58 18-0217-04-00 PUBLIC RETIRMENT 936.81 18-0217-07-00 HEALTH INSURANCE ( 26,325.25) 18-0217-09-00 WORKERS' COMPENSATION 1,999.51 18-0217-10-00 HSA CONTRIBUTION 820.00 TOTAL LIABILITIES ( 22,013.35) FUND EQUITY 18-0271-00-00 FUND BALANCE 4,077.44 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 17,935.91 BALANCE - CURRENT DATE 17,935.91 TOTAL FUND EQUITY 22,013.35 TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 IT DEPARTMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:24AM PAGE: 38 REVENUE 18-0301-00-00 FUNDING FROM GENERAL FUND 186,146.22 186,146.22 1,010,650.00 824,503.78 18.4 TOTAL FUND REVENUE 186,146.22 186,146.22 1,010,650.00 824,503.78 18.4 EXPENDITURES ADMINISTRATION 18-0413-01-00 OFFICE SUPPLIES 51.78 51.78 1,000.00 948.22 5.2 18-0413-02-00 SUPPLIES 55.00 55.00 4,000.00 3,945.00 1.4 18-0413-03-00 TRAINING .00 .00 7,000.00 7,000.00 .0 18-0413-04-00 TRAVEL AND PER DIEM 2,936.62 2,936.62 7,000.00 4,063.38 42.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 3,043.40 3,043.40 20,550.00 17,506.60 14.8 PERSONNEL 18-0415-10-00 SALARIES - FULL TIME 67,126.50 67,126.50 292,800.00 225,673.50 22.9 18-0415-11-00 IT DEPT/OVERTIME 268.45 268.45 5,000.00 4,731.55 5.4 18-0415-21-00 FICA 4,898.24 4,898.24 22,500.00 17,601.76 21.8 18-0415-22-00 PERSI 8,046.91 8,046.91 35,200.00 27,153.09 22.9 18-0415-23-00 HRA BUY- DOWN 1,540.00 1,540.00 6,200.00 4,660.00 24.8 18-0415-24-00 WORKERS' COMPENSATION 122.11 122.11 .00 ( 122.11).0 18-0415-25-00 INSURANCE 9,645.69 9,645.69 55,500.00 45,854.31 17.4 18-0415-26-00 HSA 180.00 180.00 2,400.00 2,220.00 7.5 18-0415-27-00 PTO CASH OUT .00 .00 2,500.00 2,500.00 .0 TOTAL PERSONNEL 91,827.90 91,827.90 422,100.00 330,272.10 21.8 CONTRACT & AGREEMENTS 18-0416-01-00 CONTRACT AND AGREEMENTS 47,688.94 47,688.94 350,000.00 302,311.06 13.6 TOTAL CONTRACT & AGREEMENTS 47,688.94 47,688.94 350,000.00 302,311.06 13.6 INTERNET/PHONE SERVICES 18-0417-01-00 INTERNET & PHONE SERVICES 9,701.36 9,701.36 78,000.00 68,298.64 12.4 TOTAL INTERNET/PHONE SERVICES 9,701.36 9,701.36 78,000.00 68,298.64 12.4 OPERATIONAL RESERVES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 IT DEPARTMENT YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:24AM PAGE: 39 18-0418-01-00 IT EQUIPMENT/SOFTWARE 11,818.94 11,818.94 35,000.00 23,181.06 33.8 TOTAL OPERATIONAL RESERVES 11,818.94 11,818.94 35,000.00 23,181.06 33.8 CAPITAL OUTLAY 18-0419-01-00 FURNITURE .00 .00 1,000.00 1,000.00 .0 18-0419-02-00 EQUIPMENT 4,129.77 4,129.77 65,000.00 60,870.23 6.4 18-0419-03-00 SOFTWARE PURCHASES .00 .00 25,000.00 25,000.00 .0 18-0419-04-00 WEBSITE DEVELOPMENT .00 .00 12,000.00 12,000.00 .0 18-0419-05-00 TOOLS .00 .00 2,000.00 2,000.00 .0 TOTAL CAPITAL OUTLAY 4,129.77 4,129.77 105,000.00 100,870.23 3.9 TOTAL FUND EXPENDITURES 168,210.31 168,210.31 1,010,650.00 842,439.69 16.6 NET REVENUE OVER EXPENDITURES 17,935.91 17,935.91 .00 ( 17,935.91).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 CAPITAL PROJECTS FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:25AM PAGE: 40 ASSETS 19-0101-00-00 CASH 126,904.97 19-0115-00-00 ACCOUNTS RECEIVABLE 158,448.60 19-0151-25-00 FIRST INTERSTATE INVESTMENT 4,022,248.55 TOTAL ASSETS 4,307,602.12 LIABILITIES AND EQUITY LIABILITIES 19-0225-00-00 UNEARNED GRANT REVENUE, ARPA 1,976,588.98 TOTAL LIABILITIES 1,976,588.98 FUND EQUITY 19-0271-00-00 FUND BALANCE 4,802,108.10 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 2,471,094.96) BALANCE - CURRENT DATE ( 2,471,094.96) TOTAL FUND EQUITY 2,331,013.14 TOTAL LIABILITIES AND EQUITY 4,307,602.12 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 CAPITAL PROJECTS FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:25AM PAGE: 41 REVENUE 19-0301-00-00 FUNDING FROM GENERAL FUND 581,452.97 581,452.97 2,627,553.00 2,046,100.03 22.1 19-0301-01-00 BANK INTEREST 5,245.09 5,245.09 4,100.00 ( 1,145.09)127.9 19-0301-03-00 FOOTHILLS REIMB AGREEMENT .00 .00 100,000.00 100,000.00 .0 19-0301-05-00 EAGLE RD PED/BIKE BRIDGE 632,501.55 632,501.55 3,180,852.00 2,548,350.45 19.9 19-0301-06-00 STATE HWY 44 PED CROSSING 5,631.61 5,631.61 .00 ( 5,631.61).0 19-0301-12-00 FEMA GENERAL REVENUE 18,450.19 18,450.19 1,511,385.00 1,492,934.81 1.2 19-0331-01-00 ARPA, AMERICAN RESCUE PLAN ACT .00 .00 9,003.00 9,003.00 .0 19-0399-00-00 CARRY OVER .00 .00 7,504,498.00 7,504,498.00 .0 19-0399-01-00 CARRY OVER, ARPA FUNDS .00 .00 2,088,020.00 2,088,020.00 .0 TOTAL FUND REVENUE 1,243,281.41 1,243,281.41 17,025,411.00 15,782,129.59 7.3 EXPENDITURES RESERVES 19-0410-01-00 RESERVES, FUTURE PROJECTS .00 .00 3,833,211.00 3,833,211.00 .0 TOTAL RESERVES .00 .00 3,833,211.00 3,833,211.00 .0 CAPITAL MAINTENANCE 19-0462-01-00 CAPITAL MAINTENANCE SET ASIDE 17,089.94 17,089.94 3,026,380.00 3,009,290.06 .6 19-0462-03-00 FEMA TRAIL REPLACEMENT .00 .00 676,491.00 676,491.00 .0 TOTAL CAPITAL MAINTENANCE 17,089.94 17,089.94 3,702,871.00 3,685,781.06 .5 CITY CAPITAL PROJECTS 19-0465-05-00 GENERAL CITY PROJECTS .00 .00 100,000.00 100,000.00 .0 19-0465-07-00 LAND PURCHASES 2,514,227.90 2,514,227.90 .00 ( 2,514,227.90).0 19-0465-08-00 CURRENT FISCAL YEAR PROJECTS 10,541.25 10,541.25 1,513,000.00 1,502,458.75 .7 TOTAL CITY CAPITAL PROJECTS 2,524,769.15 2,524,769.15 1,613,000.00 ( 911,769.15)156.5 PZ CAPITAL PROJECTS 19-0466-03-00 AIKENS EXTENSION .00 .00 680,000.00 680,000.00 .0 19-0466-05-00 EAGLE RD PED/BIKE BRIDGE 488,595.73 488,595.73 3,300,000.00 2,811,404.27 14.8 19-0466-09-00 EAGLE-STATE ST INTERSECTION .00 .00 848,309.00 848,309.00 .0 19-0466-10-00 P&Z CAPITAL PROJECTS FY22 .00 .00 40,000.00 40,000.00 .0 TOTAL PZ CAPITAL PROJECTS 488,595.73 488,595.73 4,868,309.00 4,379,713.27 10.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 CAPITAL PROJECTS FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:25AM PAGE: 42 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 350,000.00 350,000.00 .0 TOTAL PW CAPITAL PROJECTS .00 .00 350,000.00 350,000.00 .0 TRAILS & PATHWAYS 19-0473-03-00 GREENBELT MAINTENANCE .00 .00 370,000.00 370,000.00 .0 TOTAL TRAILS & PATHWAYS .00 .00 370,000.00 370,000.00 .0 FEDERAL FUNDS PROJECTS 19-0486-01-00 ARPA, CAPITAL PROJECTS, TBD 136,750.13 136,750.13 1,159,000.00 1,022,249.87 11.8 19-0486-01-02 ARPA, MISC LEGAL 157.50 157.50 .00 ( 157.50).0 19-0486-01-03 ARPA, FIBER EQUIPMENT 333,958.99 333,958.99 .00 ( 333,958.99).0 19-0486-01-04 ARPA, FACILITIES ( 1,897.42)( 1,897.42).00 1,897.42 .0 19-0486-01-05 ARPA, FIBER MATERIALS 214,952.35 214,952.35 .00 ( 214,952.35).0 19-0486-02-00 ARPA, FIBER NETWORK CONNECT .00 .00 929,020.00 929,020.00 .0 TOTAL FEDERAL FUNDS PROJECTS 683,921.55 683,921.55 2,088,020.00 1,404,098.45 32.8 TOTAL FUND EXPENDITURES 3,714,376.37 3,714,376.37 17,025,411.00 13,311,034.63 21.8 NET REVENUE OVER EXPENDITURES ( 2,471,094.96)( 2,471,094.96).00 2,471,094.96 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 ARTS COMMISSION FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:25AM PAGE: 43 ASSETS 21-0101-00-00 CASH 625.00 TOTAL ASSETS 625.00 LIABILITIES AND EQUITY FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 625.00 BALANCE - CURRENT DATE 625.00 TOTAL FUND EQUITY 625.00 TOTAL LIABILITIES AND EQUITY 625.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 ARTS COMMISSION PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:25AM PAGE: 44 REVENUE 21-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 75,120.00 75,120.00 .0 21-0376-07-00 DONATIONS .00 .00 1,000.00 1,000.00 .0 21-0376-09-00 SCHOLARSHIPS .00 .00 500.00 500.00 .0 21-0376-11-00 GALLERY MAINTENANCE .00 .00 500.00 500.00 .0 21-0376-12-00 POSTCARD REVENUE 25.00 25.00 380.00 355.00 6.6 TOTAL FUND REVENUE 25.00 25.00 77,500.00 77,475.00 .0 EXPENDITURES ADMINISTRATION 21-0420-00-00 ADMINISTRATION .00 .00 1,500.00 1,500.00 .0 21-0420-01-00 POSTCARD EXPENDITURES .00 .00 300.00 300.00 .0 TOTAL ADMINISTRATION .00 .00 1,800.00 1,800.00 .0 ART EDUCATION 21-0421-00-00 ART EDUCATION & ADVOCACY ( 600.00)( 600.00)24,000.00 24,600.00 ( 2.5) TOTAL ART EDUCATION ( 600.00)( 600.00)24,000.00 24,600.00 ( 2.5) ART INSTALLATION 21-0422-00-00 ARTS IN PUBLIC SPACES/BEAUTIFY .00 .00 33,000.00 33,000.00 .0 TOTAL ART INSTALLATION .00 .00 33,000.00 33,000.00 .0 ACQUISITION OF ART 21-0423-00-00 ACQUISITION OF ART .00 .00 1,500.00 1,500.00 .0 TOTAL ACQUISITION OF ART .00 .00 1,500.00 1,500.00 .0 COMMUNITY EVENTS 21-0425-00-00 COMMUNITY EVENTS .00 .00 17,100.00 17,100.00 .0 TOTAL COMMUNITY EVENTS .00 .00 17,100.00 17,100.00 .0 GALLERY MTNC/SUPPLIES CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 ARTS COMMISSION YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:25AM PAGE: 45 21-0427-00-00 GALLERY MTNC/SLUPPLIES .00 .00 100.00 100.00 .0 TOTAL GALLERY MTNC/SUPPLIES .00 .00 100.00 100.00 .0 TOTAL FUND EXPENDITURES ( 600.00)( 600.00)77,500.00 78,100.00 ( .8) NET REVENUE OVER EXPENDITURES 625.00 625.00 .00 ( 625.00).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 PUBLIC WORKS FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 46 LIABILITIES AND EQUITY LIABILITIES 23-0202-00-00 VOUCHERS PAYABLE ( 156.08) 23-0216-00-00 ACCRUED PAYROLL 10,783.10 23-0217-02-00 FEDERAL WITHHOLDING 25.57 23-0217-03-00 FICA 3,569.98 23-0217-04-00 PUBLIC RETIREMENT 2,814.49 23-0217-05-00 PW DEPT MISC DEDUCTIONS ( 14,386.03) 23-0217-07-00 HEALTH INSURANCE 14,091.18 23-0217-08-00 GARNISHMENT ( 1,162.50) 23-0217-09-00 WORKERS' COMPENSATION 121,081.97 23-0217-10-00 HSA CONTRIBUTION ( 1,160.00) TOTAL LIABILITIES 135,501.68 FUND EQUITY 23-0271-00-00 FUND BALANCE ( 169,515.86) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 34,014.18 BALANCE - CURRENT DATE 34,014.18 TOTAL FUND EQUITY ( 135,501.68) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 PUBLIC WORKS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 47 REVENUE 23-0302-00-00 FUNDING FROM GENERAL FUND 453,565.70 453,565.70 3,037,006.00 2,583,440.30 14.9 23-0315-02-00 SIDEWALKS, LTS, TREES, STR-REP .00 .00 100,000.00 100,000.00 .0 23-0315-06-00 TREE FUNDS, CARRYOVER 1,500.00 1,500.00 29,511.00 28,011.00 5.1 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 3,309.65 3,309.65 6,000.00 2,690.35 55.2 TOTAL FUND REVENUE 458,375.35 458,375.35 3,179,507.00 2,721,131.65 14.4 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 .00 .00 7,500.00 7,500.00 .0 23-0413-04-00 TRAINING 1,900.58 1,900.58 15,500.00 13,599.42 12.3 23-0413-05-00 TRAVEL & PER DIEM .00 .00 6,725.00 6,725.00 .0 23-0413-06-00 PROFESSIONAL DUES .00 .00 1,000.00 1,000.00 .0 23-0413-09-00 UNIFORMS AND SAFETY CLOTHING 662.51 662.51 5,500.00 4,837.49 12.1 23-0413-10-00 PUBLIC RELATIONS .00 .00 1,000.00 1,000.00 .0 TOTAL ADMINISTRATION 2,563.09 2,563.09 39,225.00 36,661.91 6.5 GEN MAINTENANCE & REPAIR 23-0414-02-00 MISC MTNC & REPAIR GROUNDS 153.38 153.38 50,000.00 49,846.62 .3 23-0414-03-00 MATERIALS AND SUPPLIES 12,219.48 12,219.48 57,000.00 44,780.52 21.4 23-0414-04-00 HOLIDAY LIGHTING 2,401.75 2,401.75 7,000.00 4,598.25 34.3 23-0414-05-00 PAPER PRODUCTS 9,849.25 9,849.25 60,000.00 50,150.75 16.4 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 2,320.33 2,320.33 5,000.00 2,679.67 46.4 23-0414-10-00 ROOF MAINTENANCE .00 .00 1,500.00 1,500.00 .0 23-0414-11-00 HVAC MAINTENANCE 455.28 455.28 2,500.00 2,044.72 18.2 23-0414-12-00 EMERGENCY REPAIRS .00 .00 25,000.00 25,000.00 .0 TOTAL GEN MAINTENANCE & REPAIR 27,399.47 27,399.47 218,000.00 190,600.53 12.6 RESTRICTED 23-0415-02-00 SIDEWALKS, LTS, TREES, STR-REP .00 .00 150,000.00 150,000.00 .0 TOTAL RESTRICTED .00 .00 150,000.00 150,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 48 CONTRACTS & AGREEMENTS 23-0416-00-00 WYCLIFFE PUMP STATION 954.69 954.69 6,690.00 5,735.31 14.3 23-0416-01-00 FARMERS UNION .00 .00 1,350.00 1,350.00 .0 23-0416-02-00 EAST ENTRY SIGN .00 .00 1,000.00 1,000.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,750.00 3,750.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 954.69 954.69 15,791.00 14,836.31 6.1 VEHICLES 23-0417-01-00 VEHICLE MTNC & REPAIR 5,489.82 5,489.82 17,000.00 11,510.18 32.3 23-0417-02-00 GAS AND OIL 8,070.35 8,070.35 35,000.00 26,929.65 23.1 23-0417-05-00 VEHICLE CAR WASH .00 .00 3,000.00 3,000.00 .0 TOTAL VEHICLES 13,560.17 13,560.17 55,000.00 41,439.83 24.7 PROGRAMS 23-0418-03-00 MEMORIALS, MTNC/REPAIR .00 .00 6,000.00 6,000.00 .0 TOTAL PROGRAMS .00 .00 6,000.00 6,000.00 .0 FLOWER BASKETS 23-0419-01-00 MATERIALS & SUPPLIES .00 .00 2,000.00 2,000.00 .0 23-0419-02-00 FLOWERS .00 .00 17,000.00 17,000.00 .0 TOTAL FLOWER BASKETS .00 .00 19,000.00 19,000.00 .0 EQUIPMENT MTNC & REPAIR 23-0420-00-00 MTNC/REPAIR EQUIPMENT 56.68 56.68 20,000.00 19,943.32 .3 TOTAL EQUIPMENT MTNC & REPAIR 56.68 56.68 20,000.00 19,943.32 .3 SUSTAINABILITY-CONSERVATION 23-0421-01-00 SANITATION SERVICES 4,205.59 4,205.59 54,000.00 49,794.41 7.8 23-0421-02-00 TREE FUNDS 8,800.00 8,800.00 29,511.00 20,711.00 29.8 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 TOTAL SUSTAINABILITY-CONSERVATION 13,005.59 13,005.59 98,811.00 85,805.41 13.2 FLEET MANAGEMENT CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 49 23-0423-00-00 VEHICLE REPLACEMENT .00 .00 53,000.00 53,000.00 .0 TOTAL FLEET MANAGEMENT .00 .00 53,000.00 53,000.00 .0 PERSONNEL 23-0433-10-00 SALARIES-FULL TIME 190,030.49 190,030.49 1,127,000.00 936,969.51 16.9 23-0433-10-01 SALARIES - PERSONNEL SERVICES 3,806.10 3,806.10 50,000.00 46,193.90 7.6 23-0433-11-00 OVERTIME 2,968.95 2,968.95 18,600.00 15,631.05 16.0 23-0433-15-00 SALARIES - PART TIME 64.79 64.79 .00 ( 64.79).0 23-0433-16-00 SALARIES -SEASONAL .00 .00 145,000.00 145,000.00 .0 23-0433-21-00 FICA 14,901.61 14,901.61 97,500.00 82,598.39 15.3 23-0433-22-00 PERSI 23,760.34 23,760.34 135,000.00 111,239.66 17.6 23-0433-24-00 WORKERS' COMPENSATION 7,767.96 7,767.96 .00 ( 7,767.96).0 23-0433-25-00 INSURANCE 26,900.41 26,900.41 230,500.00 203,599.59 11.7 23-0433-26-00 HSA CONTRIBUTION 1,110.00 1,110.00 4,800.00 3,690.00 23.1 23-0433-27-00 HRA BUY-DOWN .00 .00 10,780.00 10,780.00 .0 23-0433-29-00 PTO CASH OUT 5,933.55 5,933.55 10,000.00 4,066.45 59.3 TOTAL PERSONNEL 277,244.20 277,244.20 1,829,180.00 1,551,935.80 15.2 SHOP 23-0440-00-00 SHOP LEASE 6,941.64 6,941.64 30,000.00 23,058.36 23.1 23-0440-02-00 UTILITIES 2,138.45 2,138.45 4,500.00 2,361.55 47.5 TOTAL SHOP 9,080.09 9,080.09 34,500.00 25,419.91 26.3 STREET LIGHTS 23-0441-01-00 MAINTENANCE & REPAIR .00 .00 8,000.00 8,000.00 .0 23-0441-02-00 UTILITIES 6,861.34 6,861.34 35,000.00 28,138.66 19.6 TOTAL STREET LIGHTS 6,861.34 6,861.34 43,000.00 36,138.66 16.0 CITY HALL 23-0442-01-00 BLDG MAINTENANCE & REPAIR 1,810.00 1,810.00 2,500.00 690.00 72.4 23-0442-02-00 GROUNDS MAINTENANCE & REPAIR 945.00 945.00 1,500.00 555.00 63.0 23-0442-04-00 UTILITIES 9,890.75 9,890.75 40,000.00 30,109.25 24.7 TOTAL CITY HALL 12,645.75 12,645.75 44,000.00 31,354.25 28.7 SENIOR CENTER 23-0443-01-00 BLDG MAINTENANCE & REPAIR .00 .00 2,500.00 2,500.00 .0 23-0443-02-00 GROUNDS MAINTENANCE & REPAIR .00 .00 1,500.00 1,500.00 .0 TOTAL SENIOR CENTER .00 .00 4,000.00 4,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 50 LIBRARY 23-0444-01-00 BLDG MAINTENANCE & REPAIR 1,470.22 1,470.22 10,000.00 8,529.78 14.7 23-0444-02-00 GROUNDS MAINTENANCE & REPAIR .00 .00 2,000.00 2,000.00 .0 TOTAL LIBRARY 1,470.22 1,470.22 12,000.00 10,529.78 12.3 MUSEUM 23-0445-01-00 BLDG MAINTENANCE & REPAIR .00 .00 2,500.00 2,500.00 .0 TOTAL MUSEUM .00 .00 2,500.00 2,500.00 .0 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 MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0446-04-00 UTILITIES 613.65 613.65 500.00 ( 113.65)122.7 TOTAL ARBORETUM PARK 613.65 613.65 2,000.00 1,386.35 30.7 FLAG PLAZA 23-0447-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0447-02-00 EQUIPMENT MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0447-03-00 GROUNDS MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0447-04-00 UTILITIES 47.66 47.66 500.00 452.34 9.5 TOTAL FLAG PLAZA 47.66 47.66 2,000.00 1,952.34 2.4 FRIENDSHIP PARK 23-0448-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0448-02-00 EQUIPMENT MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0448-03-00 GROUNDS MAINTENANCE & REPAIR 985.00 985.00 500.00 ( 485.00)197.0 23-0448-04-00 UTILITIES 926.87 926.87 3,000.00 2,073.13 30.9 TOTAL FRIENDSHIP PARK 1,911.87 1,911.87 4,500.00 2,588.13 42.5 GUERBER PARK 23-0449-01-00 BLDGS/STRUCTURES MTNC & REPAIR 658.44 658.44 2,500.00 1,841.56 26.3 23-0449-02-00 EQUIPMENT MAINTENANCE & REPAIR .00 .00 5,000.00 5,000.00 .0 23-0449-03-00 GROUNDS MAINTENANCE & REPAIR .00 .00 5,000.00 5,000.00 .0 23-0449-04-00 UTILITIES 2,920.29 2,920.29 17,500.00 14,579.71 16.7 TOTAL GUERBER PARK 3,578.73 3,578.73 30,000.00 26,421.27 11.9 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 51 HERITAGE PARK 23-0450-01-00 BLDG/STRUCTURES MTNC & REPAIR 72.94 72.94 1,500.00 1,427.06 4.9 23-0450-02-00 EQUIPMENT MAINTENANCE & REPAIR .00 .00 1,500.00 1,500.00 .0 23-0450-03-00 GROUNDS MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0450-04-00 UTILITIES 726.26 726.26 4,000.00 3,273.74 18.2 TOTAL HERITAGE PARK 799.20 799.20 7,500.00 6,700.80 10.7 MCDONALDS PARK/PATHWAY 23-0451-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0451-02-00 EQUIPMENT MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0451-03-00 GROUNDS MAINTENANCE & REPAIR 152.33 152.33 1,000.00 847.67 15.2 TOTAL MCDONALDS PARK/PATHWAY 152.33 152.33 2,000.00 1,847.67 7.6 MERRILL PARK 23-0452-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 2,500.00 2,500.00 .0 23-0452-02-00 EQUIPMENT MAINTENANCE & REPAIR .00 .00 1,500.00 1,500.00 .0 23-0452-03-00 GROUNDS MAINTENANCE & REPAIR .00 .00 1,500.00 1,500.00 .0 23-0452-04-00 UTILITIES 2,118.24 2,118.24 16,000.00 13,881.76 13.2 TOTAL MERRILL PARK 2,118.24 2,118.24 21,500.00 19,381.76 9.9 ORVAL KRASEN PARK 23-0453-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0453-02-00 EQUIPMENT MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0453-03-00 GROUNDS MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0453-04-00 UTILITIES 604.57 604.57 3,000.00 2,395.43 20.2 TOTAL ORVAL KRASEN PARK 604.57 604.57 4,500.00 3,895.43 13.4 SPORTS COMPLEX 23-0454-01-00 BLDGS/STRUCTURES MTNC & REPAIR 584.72 584.72 2,500.00 1,915.28 23.4 23-0454-02-00 EQUIPMENT MAINTENANCE & REPAIR .00 .00 2,500.00 2,500.00 .0 23-0454-03-00 GROUNDS MAINTENANCE & REPAIR 4,465.67 4,465.67 1,000.00 ( 3,465.67)446.6 23-0454-04-00 UTILITIES 6,498.09 6,498.09 22,000.00 15,501.91 29.5 TOTAL SPORTS COMPLEX 11,548.48 11,548.48 28,000.00 16,451.52 41.2 TOWN ENTRANCE SIGNS 23-0455-01-00 BLDGS/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0455-02-00 EQUIPMENT MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 52 23-0455-03-00 GROUNDS MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0455-04-00 UTILITIES 2,772.15 2,772.15 10,000.00 7,227.85 27.7 TOTAL TOWN ENTRANCE SIGNS 2,772.15 2,772.15 11,500.00 8,727.85 24.1 PLAZA DRIVE 23-0456-02-00 EQUIPMENT MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0456-03-00 GROUNDS MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0456-04-00 UTILITIES .00 .00 3,000.00 3,000.00 .0 TOTAL PLAZA DRIVE .00 .00 4,000.00 4,000.00 .0 PAMELA BAKER PARK 23-0459-01-00 BLDG/STRUCTURES MTNC & REPAIR .00 .00 500.00 500.00 .0 23-0459-02-00 GROUNDS MAINTENANCE & REPAIR .00 .00 1,000.00 1,000.00 .0 23-0459-03-00 EQUIPMENT MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0459-04-00 UTILITIES 527.39 527.39 9,000.00 8,472.61 5.9 TOTAL PAMELA BAKER PARK 527.39 527.39 11,000.00 10,472.61 4.8 CAPITAL EQUIPMENT 23-0460-00-00 TOOLS 243.88 243.88 7,500.00 7,256.12 3.3 23-0460-01-00 EQUIPMENT 1,179.46 1,179.46 85,000.00 83,820.54 1.4 TOTAL CAPITAL EQUIPMENT 1,423.34 1,423.34 92,500.00 91,076.66 1.5 CITY LANDSCAPE MAINTENANCE 23-0462-00-00 EQUIPMENT RENTAL .00 .00 15,000.00 15,000.00 .0 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 18.27 18.27 2,500.00 2,481.73 .7 TOTAL CITY LANDSCAPE MAINTENANCE 18.27 18.27 66,500.00 66,481.73 .0 LINDER ROAD RESTROOM 23-0463-01-00 BLDG/STRUCTURES MTNC REPAIR .00 .00 1,500.00 1,500.00 .0 23-0463-02-00 EQUIPMENT MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0463-03-00 GROUNDS MAINTENANCE & REPAIR .00 .00 500.00 500.00 .0 23-0463-04-00 UTILITIES 943.25 943.25 5,000.00 4,056.75 18.9 TOTAL LINDER ROAD RESTROOM 943.25 943.25 7,500.00 6,556.75 12.6 TRAILS CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 PUBLIC WORKS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 53 23-0464-00-00 GROUNDS MAINTENANCE & REPAIR .00 .00 7,500.00 7,500.00 .0 23-0464-01-00 EQUIPMENT RENTAL .00 .00 4,000.00 4,000.00 .0 TOTAL TRAILS .00 .00 11,500.00 11,500.00 .0 CAPITAL OUTLAY 23-0465-01-00 JACKSON HOUSE .00 .00 5,000.00 5,000.00 .0 TOTAL CAPITAL OUTLAY .00 .00 5,000.00 5,000.00 .0 DEPARTMENT 0466 23-0466-01-00 SV REGIONAL SPORTS COMPLEX .00 .00 10,000.00 10,000.00 .0 TOTAL DEPARTMENT 0466 .00 .00 10,000.00 10,000.00 .0 DEPARTMENT 0467 23-0467-01-00 SV REGIONAL SPORTS COMP, SHOP 4,513.75 4,513.75 10,000.00 5,486.25 45.1 TOTAL DEPARTMENT 0467 4,513.75 4,513.75 10,000.00 5,486.25 45.1 DEPARTMENT 0468 23-0468-01-00 MACE PARKING LOT .00 .00 5,000.00 5,000.00 .0 TOTAL DEPARTMENT 0468 .00 .00 5,000.00 5,000.00 .0 FISCAL YEAR CAPITAL PROJECTS 23-0480-15-00 LANDSCAPE UPGRADES - PARKS 6,810.00 6,810.00 25,000.00 18,190.00 27.2 TOTAL FISCAL YEAR CAPITAL PROJECTS 6,810.00 6,810.00 25,000.00 18,190.00 27.2 FY 21/22 PROJECTS 23-0483-01-00 CAPITAL PROJECTS FY22 .00 .00 65,000.00 65,000.00 .0 23-0483-02-00 CAPITAL PROJECTS FY23 21,137.00 21,137.00 109,000.00 87,863.00 19.4 TOTAL FY 21/22 PROJECTS 21,137.00 21,137.00 174,000.00 152,863.00 12.2 TOTAL FUND EXPENDITURES 424,361.17 424,361.17 3,179,507.00 2,755,145.83 13.4 NET REVENUE OVER EXPENDITURES 34,014.18 34,014.18 .00 ( 34,014.18).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 RECREATION - EAGLE FUN DAYS FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 54 ASSETS 24-0101-00-00 CASH 4,709.47 TOTAL ASSETS 4,709.47 LIABILITIES AND EQUITY LIABILITIES 24-0217-00-00 FUND BALANCE 4,769.47 TOTAL LIABILITIES 4,769.47 FUND EQUITY UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 60.00) BALANCE - CURRENT DATE ( 60.00) TOTAL FUND EQUITY ( 60.00) TOTAL LIABILITIES AND EQUITY 4,709.47 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 RECREATION - EAGLE FUN DAYS PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 55 REVENUE 24-0301-00-00 FUNDING FROM GENERAL FUND .00 .00 90,550.00 90,550.00 .0 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-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 .00 .00 144,850.00 144,850.00 .0 EXPENDITURES ADMIN EXPENDITURES 24-0401-01-00 FUN DAYS CONTRACTS .00 .00 42,000.00 42,000.00 .0 24-0401-04-00 ADVERTISEMENT .00 .00 16,800.00 16,800.00 .0 24-0401-06-00 SUPPLIES .00 .00 9,300.00 9,300.00 .0 24-0401-07-00 EQUIPMENT .00 .00 7,500.00 7,500.00 .0 TOTAL ADMIN EXPENDITURES .00 .00 75,600.00 75,600.00 .0 LOGISTICS 24-0410-00-00 PORTA POTTIES .00 .00 5,000.00 5,000.00 .0 24-0410-02-00 TRAFFIC BARRIERS & CONTROL .00 .00 10,000.00 10,000.00 .0 24-0410-03-00 GOLF CART RENTALS .00 .00 500.00 500.00 .0 24-0410-04-00 POLICE OVERTIME .00 .00 7,000.00 7,000.00 .0 24-0410-05-00 STREET CLOSURES .00 .00 4,500.00 4,500.00 .0 24-0410-06-00 SIGNAGE .00 .00 5,000.00 5,000.00 .0 24-0410-07-00 SECURITY .00 .00 7,000.00 7,000.00 .0 TOTAL LOGISTICS .00 .00 39,000.00 39,000.00 .0 FUN RUN 24-0420-01-00 PROMOTIONS .00 .00 4,000.00 4,000.00 .0 24-0420-02-00 BIBS .00 .00 300.00 300.00 .0 24-0420-03-00 BREAKFAST .00 .00 500.00 500.00 .0 24-0420-04-00 ADVERTISING .00 .00 200.00 200.00 .0 24-0420-05-00 MISCELLANEOUS .00 .00 400.00 400.00 .0 TOTAL FUN RUN .00 .00 5,400.00 5,400.00 .0 CAR SHOW 24-0430-00-00 MARKETING/ADVERTISING 60.00 60.00 100.00 40.00 60.0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 RECREATION - EAGLE FUN DAYS YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 56 24-0430-01-00 DASH PLAQUES .00 .00 300.00 300.00 .0 24-0430-02-00 TROPHIES .00 .00 1,500.00 1,500.00 .0 24-0430-03-00 SUPPLIES .00 .00 300.00 300.00 .0 24-0430-04-00 PARKING .00 .00 500.00 500.00 .0 24-0430-05-00 MISCELLANEOUS .00 .00 150.00 150.00 .0 24-0430-06-00 RAFFLE .00 .00 500.00 500.00 .0 24-0430-08-00 COMMUNITY GROUP .00 .00 500.00 500.00 .0 TOTAL CAR SHOW 60.00 60.00 3,850.00 3,790.00 1.6 ROCKY MOUNTAIN OYSTER FEED 24-0445-01-00 COMMUNITY BENEFICIARY .00 .00 20,000.00 20,000.00 .0 24-0445-03-00 FOOD AND BEVERAGE .00 .00 1,000.00 1,000.00 .0 TOTAL ROCKY MOUNTAIN OYSTER FEED .00 .00 21,000.00 21,000.00 .0 TOTAL FUND EXPENDITURES 60.00 60.00 144,850.00 144,790.00 .0 NET REVENUE OVER EXPENDITURES ( 60.00)( 60.00).00 60.00 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 PATHWAY IMPACT FEE FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 57 ASSETS 25-0101-00-00 CASH 5,702.00 25-0151-25-00 FIRST INTERSTATE INVESTMENT 839,724.00 TOTAL ASSETS 845,426.00 LIABILITIES AND EQUITY FUND EQUITY 25-0271-00-00 FUND BALANCE 855,025.89 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 9,599.89) BALANCE - CURRENT DATE ( 9,599.89) TOTAL FUND EQUITY 845,426.00 TOTAL LIABILITIES AND EQUITY 845,426.00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 PATHWAY IMPACT FEE FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:26AM PAGE: 58 REVENUE 25-0322-19-00 DEVELOPMENT IMPACT FEE 12,889.50 12,889.50 115,675.00 102,785.50 11.1 25-0371-25-00 BANK INTEREST 519.61 519.61 1,100.00 580.39 47.2 25-0399-00-00 CARRY OVER .00 .00 852,000.00 852,000.00 .0 TOTAL FUND REVENUE 13,409.11 13,409.11 968,775.00 955,365.89 1.4 EXPENDITURES CAPITAL IMPROVEMENTS 25-0438-00-00 CAPITAL IMPROVEMENTS 23,009.00 23,009.00 968,775.00 945,766.00 2.4 TOTAL CAPITAL IMPROVEMENTS 23,009.00 23,009.00 968,775.00 945,766.00 2.4 TOTAL FUND EXPENDITURES 23,009.00 23,009.00 968,775.00 945,766.00 2.4 NET REVENUE OVER EXPENDITURES ( 9,599.89)( 9,599.89).00 9,599.89 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 ECONOMIC DEVELOPMENT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:27AM PAGE: 59 LIABILITIES AND EQUITY LIABILITIES 26-0217-03-00 FICA 371.85 26-0217-04-00 PUBLIC RETIREMENT 583.73 26-0217-07-00 HEALTH INSURANCE 254.61 26-0217-09-00 WORKERS' COMPENSATION 830.15 TOTAL LIABILITIES 2,040.34 FUND EQUITY 26-0271-00-00 FUND BALANCE ( 2,797.40) UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 757.06 BALANCE - CURRENT DATE 757.06 TOTAL FUND EQUITY ( 2,040.34) TOTAL LIABILITIES AND EQUITY .00 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 ECONOMIC DEVELOPMENT PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:27AM PAGE: 60 REVENUE 26-0301-00-00 FUNDING FROM GENERAL FUND 757.06 757.06 .00 ( 757.06).0 TOTAL FUND REVENUE 757.06 757.06 .00 ( 757.06).0 NET REVENUE OVER EXPENDITURES 757.06 757.06 .00 ( 757.06).0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 LAW ENF DEV IMPACT FEES FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:27AM PAGE: 61 ASSETS 27-0101-00-00 CASH 25,207.92 27-0151-25-00 FIRST INTERSTATE INVESTMENTS 65,134.72 TOTAL ASSETS 90,342.64 LIABILITIES AND EQUITY FUND EQUITY 27-0271-00-00 POLICE IMPACT FEE/FUND BALANCE 79,160.32 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD 11,182.32 BALANCE - CURRENT DATE 11,182.32 TOTAL FUND EQUITY 90,342.64 TOTAL LIABILITIES AND EQUITY 90,342.64 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 LAW ENF DEV IMPACT FEES PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:27AM PAGE: 62 REVENUE 27-0322-19-00 RESIDENTIAL IMPACT FEES 11,117.40 11,117.40 38,850.00 27,732.60 28.6 27-0322-20-00 COMMERCIAL - IMPACT FEES .00 .00 30,000.00 30,000.00 .0 27-0371-25-00 BANK INTEREST 64.92 64.92 20.00 ( 44.92)324.6 27-0399-00-00 CARRY OVER .00 .00 81,000.00 81,000.00 .0 TOTAL FUND REVENUE 11,182.32 11,182.32 149,870.00 138,687.68 7.5 EXPENDITURES CAPITAL IMPROVEMENTS 27-0438-00-00 EQUIPMENT .00 .00 74,935.00 74,935.00 .0 27-0438-01-00 CITY FACILITY .00 .00 74,935.00 74,935.00 .0 TOTAL CAPITAL IMPROVEMENTS .00 .00 149,870.00 149,870.00 .0 TOTAL FUND EXPENDITURES .00 .00 149,870.00 149,870.00 .0 NET REVENUE OVER EXPENDITURES 11,182.32 11,182.32 .00 ( 11,182.32).0 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 CITY HALL BOND FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:27AM PAGE: 63 REVENUE 54-0399-01-00 FUNDING FROM GENERAL FUND .00 .00 104,000.00 104,000.00 .0 TOTAL FUND REVENUE .00 .00 104,000.00 104,000.00 .0 EXPENDITURES BOND PAYMENTS 54-0480-81-00 PRINCIPAL BOND PAYMENT .00 .00 85,000.00 85,000.00 .0 54-0480-82-00 INTEREST BOND PAYMENT .00 .00 18,500.00 18,500.00 .0 54-0480-84-00 PAYING AGENT FEE .00 .00 500.00 500.00 .0 TOTAL BOND PAYMENTS .00 .00 104,000.00 104,000.00 .0 TOTAL FUND EXPENDITURES .00 .00 104,000.00 104,000.00 .0 NET REVENUE OVER EXPENDITURES .00 .00 .00 .00 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 WATER FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:27AM PAGE: 64 ASSETS 60-0101-00-00 CASH 610,947.35 60-0115-00-00 ACCOUNTS RECEIVABLE 134,130.12 60-0151-01-00 INVESTMENTS, DEQ LOAN PMTS 539,093.33 60-0151-02-00 INVESTMENTS, DEQ LOAN RESERVE 182,000.00 60-0151-25-00 FIRST INTERSTATE INVESTMENT 4,583,240.23 60-0161-00-00 WATER/LAND 93,250.00 60-0162-00-00 WATER/BUILDINGS & STRUCTURES 559,285.00 60-0163-00-00 WATER/ACCUMULATED DEP.-BLDGS.&( 183,637.00) 60-0164-00-00 WATER/IMPROVEMENTS-OTHER THAN 15,633,373.00 60-0165-00-00 WATER/ACCUM. DEP.-IMPROVEMENTS ( 4,033,182.00) 60-0166-00-00 WATER/MACHINERY & EQUIPMENT 1,501,217.00 60-0167-00-00 WATER/ACCUMULATED DEPREC-EQUIP ( 1,018,840.00) 60-0170-00-00 HRA 10% DEPOSIT 550.08 60-0171-00-00 DEFERRED OUTFLOWS-PENSION 158,311.00 TOTAL ASSETS 18,759,738.11 LIABILITIES AND EQUITY LIABILITIES 60-0202-00-00 WATER/VOUCHERS PAYABLE ( 227.00) 60-0204-00-00 WATER/LEXINGTON - TVV 1,787.89 60-0215-00-00 INTEREST PAYABLE 11,158.00 60-0216-00-00 ACCRUED PAYROLL 6,081.88 60-0217-00-00 COMPENSATED ABSENCE PAYABLE 8,229.00 60-0217-03-00 FICA 1,542.82 60-0217-04-00 PUBLIC RETIREMENT 2,618.32 60-0217-07-00 WATER DEPT HEALTH INSURANCE 10,532.83 60-0217-08-00 GARNISHMENTS 1,162.50 60-0217-09-00 WORKERS' COMPENSATION 64,563.75 60-0217-10-00 HSA CONTRIBUTION ( 100.00) 60-0217-11-00 NET PENSION LIABILITY 296,214.00 60-0217-12-00 DEFERRED INFLOWS-PENSION 1,389.00 60-0220-00-00 WATER/SERVICE DEPOSITS 101,400.00 60-0231-00-00 DEQ LOAN 749,059.00 TOTAL LIABILITIES 1,255,411.99 FUND EQUITY 60-0271-00-00 WATER/FUND BALANCE 17,552,945.37 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 48,619.25) BALANCE - CURRENT DATE ( 48,619.25) TOTAL FUND EQUITY 17,504,326.12 TOTAL LIABILITIES AND EQUITY 18,759,738.11 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 WATER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:27AM PAGE: 65 REVENUE 60-0346-59-00 STL-STORAGE & TRUNK LINE FEE .00 .00 105,000.00 105,000.00 .0 60-0346-60-00 HOOK UP FEES CITY 10,500.00 10,500.00 167,250.00 156,750.00 6.3 60-0346-62-00 PROFESSIONAL SERV - DEVELOPERS 6,413.75 6,413.75 .00 ( 6,413.75).0 60-0347-01-00 BILLING REVENUE 313,514.96 313,514.96 1,227,000.00 913,485.04 25.6 60-0347-02-00 OTHER REVENUE 1,050.00 1,050.00 8,400.00 7,350.00 12.5 60-0347-03-00 RECONNECT FEES 25.00 25.00 600.00 575.00 4.2 60-0347-04-00 DELINQUENT FEES 3,213.00 3,213.00 10,500.00 7,287.00 30.6 60-0347-05-00 MISCELLANEOUS REVENUE 1,332.23 1,332.23 10,000.00 8,667.77 13.3 60-0347-06-00 SYSTEM ENHANCEMENT FEE 116,859.58 116,859.58 450,000.00 333,140.42 26.0 60-0355-01-00 WCE-WATER CONST EQUIV FEE 1,600.00 1,600.00 40,000.00 38,400.00 4.0 60-0371-10-00 INVESTMENTS, DEQ, TRANSFERS .00 .00 350,000.00 350,000.00 .0 60-0371-25-00 BANK INTEREST 3,229.43 3,229.43 7,500.00 4,270.57 43.1 60-0399-00-00 CARRY OVER .00 .00 152,480.00 152,480.00 .0 60-0399-01-00 RESERVES, FOR BUDGET .00 .00 325,000.00 325,000.00 .0 60-0399-02-00 RESERVES, EMERGENCY REPL ITEMS .00 .00 175,000.00 175,000.00 .0 60-0399-03-00 RESERVES, EQUIP/BLDG REPLCMNT .00 .00 250,000.00 250,000.00 .0 60-0399-04-00 RESERVES, REPAIR/ MAINTENANCE .00 .00 175,000.00 175,000.00 .0 60-0399-05-00 RESERVES, VEHICLE REPLACEMENT .00 .00 72,000.00 72,000.00 .0 60-0399-06-00 RESERVES, STL FEES .00 .00 884,378.00 884,378.00 .0 TOTAL FUND REVENUE 457,737.95 457,737.95 4,410,108.00 3,952,370.05 10.4 EXPENDITURES VEHICLE OPERATIONS - LEASES 60-0420-01-00 GAS AND OIL 1,817.47 1,817.47 15,000.00 13,182.53 12.1 60-0420-03-00 VEHICLE MTNC & REPAIR 75.00 75.00 10,000.00 9,925.00 .8 TOTAL VEHICLE OPERATIONS - LEASES 1,892.47 1,892.47 25,000.00 23,107.53 7.6 PERSONNEL 60-0433-10-00 SALARIES - FULL TIME 91,103.34 91,103.34 352,800.00 261,696.66 25.8 60-0433-10-02 ON-CALL TIME 813.16 813.16 7,500.00 6,686.84 10.8 60-0433-11-00 OVERTIME 317.16 317.16 4,500.00 4,182.84 7.1 60-0433-21-00 FICA 7,076.91 7,076.91 27,200.00 20,123.09 26.0 60-0433-22-00 PERSI 11,273.78 11,273.78 42,300.00 31,026.22 26.7 60-0433-23-00 HRA BUY-DOWN 318.49 318.49 7,700.00 7,381.51 4.1 60-0433-23-01 HRA/COBRA ADMIN FEES .00 .00 800.00 800.00 .0 60-0433-24-00 WORKERS' COMPENSATION 9,104.05 9,104.05 16,000.00 6,895.95 56.9 60-0433-25-00 INSURANCE 11,122.80 11,122.80 51,100.00 39,977.20 21.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 2,185.93 2,185.93 10,000.00 7,814.07 21.9 TOTAL PERSONNEL 133,915.62 133,915.62 522,300.00 388,384.38 25.6 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:28AM PAGE: 66 OPERATIONS & MAINTENANCE 60-0434-15-00 OFFICE SUPPLIES 63.48 63.48 2,000.00 1,936.52 3.2 60-0434-19-00 TELECOMMUNICATIONS/SCADA 4,936.10 4,936.10 17,000.00 12,063.90 29.0 60-0434-20-00 ADVERTISING - PUBLICATIONS .00 .00 1,500.00 1,500.00 .0 60-0434-22-00 TRAVEL-MTNGS-EDUCATION 407.34 407.34 8,000.00 7,592.66 5.1 60-0434-23-00 DUES & SUBSCRIPTIONS 174.00 174.00 3,000.00 2,826.00 5.8 60-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE 5,275.20 5,275.20 8,000.00 2,724.80 65.9 60-0434-26-00 TOOLS, EQUIPMENT AND SUPPLIES 461.63 461.63 20,000.00 19,538.37 2.3 60-0434-27-00 POSTAGE .00 .00 1,300.00 1,300.00 .0 60-0434-41-00 LIABILITY INSURANCE 4,620.00 4,620.00 4,620.00 .00 100.0 60-0434-42-00 ENGINEERING SERVICES 5,348.75 5,348.75 35,000.00 29,651.25 15.3 60-0434-42-01 LEGAL SERVICES .00 .00 25,000.00 25,000.00 .0 60-0434-42-02 MISC LEGAL AND ENG SERVICES .00 .00 100,000.00 100,000.00 .0 60-0434-42-03 PROFESSIONAL SERV - DEVELOPERS 5,233.13 5,233.13 .00 ( 5,233.13).0 60-0434-43-01 CONTRACT SERVICES (REPAIR).00 .00 35,000.00 35,000.00 .0 60-0434-44-00 DIG LINE 278.63 278.63 4,500.00 4,221.37 6.2 60-0434-45-00 CITY AUDITOR SERVICES .00 .00 2,500.00 2,500.00 .0 60-0434-47-00 MAIL SERVICE-CUSTOMER BILLING 4,451.89 4,451.89 31,500.00 27,048.11 14.1 60-0434-50-00 SHOP LEASE 2,974.98 2,974.98 15,500.00 12,525.02 19.2 60-0434-50-01 SHOP UTILITIES 307.24 307.24 5,100.00 4,792.76 6.0 60-0434-53-01 PUBLIC WATER DRINKING FEES 13,332.00 13,332.00 14,000.00 668.00 95.2 60-0434-53-03 PERMITS AND FEES 52.50 52.50 1,500.00 1,447.50 3.5 60-0434-55-00 CASELLE SUPPORT .00 .00 5,000.00 5,000.00 .0 60-0434-58-00 RPR/MTNC-LINES-METERS-ETC 425.59 425.59 40,000.00 39,574.41 1.1 60-0434-58-01 RPR/MTNC PUMPS-WELLS-CHEMICAL 1,022.20 1,022.20 50,000.00 48,977.80 2.0 60-0434-59-00 CHEMICALS 998.92 998.92 9,000.00 8,001.08 11.1 60-0434-60-00 UTILITIES 15,079.38 15,079.38 55,000.00 39,920.62 27.4 60-0434-68-00 UNIFORMS AND SAFETY CLOTHING 734.90 734.90 2,300.00 1,565.10 32.0 60-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 .00 25,000.00 25,000.00 .0 TOTAL OPERATIONS & MAINTENANCE 66,177.86 66,177.86 521,320.00 455,142.14 12.7 TESTING-WK-MO-QTR-ANNUAL 60-0435-56-00 TESTING-WK-MO-QTR-ANNUAL 380.00 380.00 19,000.00 18,620.00 2.0 TOTAL TESTING-WK-MO-QTR-ANNUAL 380.00 380.00 19,000.00 18,620.00 2.0 DEQ REVOLVING LOAN PAYMENT 60-0436-01-00 DEQ/STATE REVOLVING LOAN PMT 300,000.00 300,000.00 800,000.00 500,000.00 37.5 TOTAL DEQ REVOLVING LOAN PAYMENT 300,000.00 300,000.00 800,000.00 500,000.00 37.5 RESTRICTED 60-0437-01-00 STL FEES, WATER SYS EXPANSION 1,638.75 1,638.75 100,000.00 98,361.25 1.6 60-0437-03-00 STL FEES, REFUNDS .00 .00 50,000.00 50,000.00 .0 60-0437-99-01 RESERVES, STL FEES .00 .00 409,378.00 409,378.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 WATER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:28AM PAGE: 67 TOTAL RESTRICTED 1,638.75 1,638.75 559,378.00 557,739.25 .3 CAPITAL EXPENDITURES 60-0438-01-00 EQUIPMENT .00 .00 75,500.00 75,500.00 .0 60-0438-05-01 CURRENT STL PROJECTS ( 1,000.00)( 1,000.00)430,000.00 431,000.00 ( .2) 60-0438-08-00 METER SETS, NEW CUSTOMERS .00 .00 99,200.00 99,200.00 .0 60-0438-10-00 WATER MASTER PLAN-UPDATE .00 .00 18,000.00 18,000.00 .0 60-0438-11-00 CAPITAL CONSTRUCTION PROJECTS .00 .00 145,000.00 145,000.00 .0 60-0438-82-00 CITY HALL ADMIN OVERHEAD 3,352.50 3,352.50 13,410.00 10,057.50 25.0 60-0438-99-01 RESERVES, FOR BUDGET .00 .00 375,000.00 375,000.00 .0 60-0438-99-02 RESERVES, EMERGENCY REPL ITEMS .00 .00 200,000.00 200,000.00 .0 60-0438-99-03 RESERVES, EQUIP, BLDG REPLCMNT .00 .00 275,000.00 275,000.00 .0 60-0438-99-04 RESERVES, WATER SYSTEM R&M .00 .00 200,000.00 200,000.00 .0 60-0438-99-05 RESERVES, VEHICLE REPLACEMENT .00 .00 12,000.00 12,000.00 .0 60-0438-99-06 RESERVES, IDENTIFIED PROJECTS .00 .00 120,000.00 120,000.00 .0 TOTAL CAPITAL EXPENDITURES 2,352.50 2,352.50 1,963,110.00 1,960,757.50 .1 TOTAL FUND EXPENDITURES 506,357.20 506,357.20 4,410,108.00 3,903,750.80 11.5 NET REVENUE OVER EXPENDITURES ( 48,619.25)( 48,619.25).00 48,619.25 .0 CITY OF EAGLE BALANCE SHEET DECEMBER 31, 2022 FIBER FUND FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:28AM PAGE: 68 ASSETS 61-0101-00-00 CASH 19,517.02 61-0151-25-00 FIRST INTERSTATE INVESTMENT 2,352,947.58 61-0166-00-00 MACHINERY AND EQUIPMENT 1,693,285.00 TOTAL ASSETS 4,065,749.60 LIABILITIES AND EQUITY FUND EQUITY 61-0271-00-00 FUND BALANCE 4,083,934.30 UNAPPROPRIATED FUND BALANCE: REVENUE OVER EXPENDITURES - YTD ( 18,184.70) BALANCE - CURRENT DATE ( 18,184.70) TOTAL FUND EQUITY 4,065,749.60 TOTAL LIABILITIES AND EQUITY 4,065,749.60 CITY OF EAGLE REVENUES AND EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 FIBER FUND PERIOD ACTUAL YTD ACTUAL BUDGET UNEARNED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:28AM PAGE: 69 REVENUE 61-0347-90-00 BANK INTEREST 2,278.28 2,278.28 .00 ( 2,278.28).0 61-0398-00-00 ARPA CARRY OVER .00 .00 2,389,980.00 2,389,980.00 .0 TOTAL FUND REVENUE 2,278.28 2,278.28 2,389,980.00 2,387,701.72 .1 EXPENDITURES PERSONNEL 61-0433-10-00 SALARIES - FULL TIME .00 .00 183,400.00 183,400.00 .0 61-0433-10-02 ON-CALL TIME .00 .00 2,500.00 2,500.00 .0 61-0433-11-00 OVERTIME .00 .00 2,500.00 2,500.00 .0 61-0433-21-00 FICA .00 .00 14,500.00 14,500.00 .0 61-0433-22-00 PERSI .00 .00 25,500.00 25,500.00 .0 61-0433-23-00 HRA BUY-DOWN .00 .00 3,080.00 3,080.00 .0 61-0433-23-01 HRA/COBRA ADMIN FEES .00 .00 300.00 300.00 .0 61-0433-24-00 WORKERS' COMPENSATION .00 .00 8,000.00 8,000.00 .0 61-0433-25-00 INSURANCE .00 .00 26,000.00 26,000.00 .0 61-0433-26-00 HSA CONTRIBUTIONS .00 .00 1,200.00 1,200.00 .0 TOTAL PERSONNEL .00 .00 266,980.00 266,980.00 .0 OPERATIONS & MAINTENANCE 61-0434-15-00 OFFICE SUPPLIES .00 .00 500.00 500.00 .0 61-0434-19-00 TELECOMMUNICATIONS .00 .00 8,000.00 8,000.00 .0 61-0434-20-00 ADVERTISING - PUBLICATIONS .00 .00 20,000.00 20,000.00 .0 61-0434-22-00 TRAVEL-MTNGS-EDUCATION .00 .00 15,000.00 15,000.00 .0 61-0434-23-00 DUES & SUBSCRIPTIONS .00 .00 500.00 500.00 .0 61-0434-25-00 MTNC EQUIP-COPIERS/SOFTWARE .00 .00 5,000.00 5,000.00 .0 61-0434-26-00 TOOLS, EQUIPMENT AND SUPPLIES 4,780.00 4,780.00 5,000.00 220.00 95.6 61-0434-26-01 EQUIPMENT RENTAL .00 .00 25,000.00 25,000.00 .0 61-0434-27-00 POSTAGE .00 .00 1,000.00 1,000.00 .0 61-0434-41-00 LIABILITY INSURANCE .00 .00 7,500.00 7,500.00 .0 61-0434-42-00 ENGINEERING SERVICES .00 .00 290,000.00 290,000.00 .0 61-0434-42-01 LEGAL SERVICES .00 .00 15,000.00 15,000.00 .0 61-0434-43-00 TRAFFIC CONTROL .00 .00 100,000.00 100,000.00 .0 61-0434-44-00 DIG LINE .00 .00 2,500.00 2,500.00 .0 61-0434-45-00 CITY AUDITOR SERVICES .00 .00 3,000.00 3,000.00 .0 61-0434-47-00 MAIL SERVICE-CUSTOMER BILLING .00 .00 10,000.00 10,000.00 .0 61-0434-50-00 SHOP LEASE .00 .00 15,000.00 15,000.00 .0 61-0434-50-01 SHOP UTILITIES .00 .00 5,000.00 5,000.00 .0 61-0434-53-03 PERMITS AND FEES .00 .00 5,000.00 5,000.00 .0 61-0434-55-00 CASELLE SUPPORT .00 .00 1,500.00 1,500.00 .0 61-0434-56-00 GAS AND OIL .00 .00 7,500.00 7,500.00 .0 61-0434-57-00 REPAIR AND MAINT, VEHICLE 32.97 32.97 1,000.00 967.03 3.3 61-0434-58-00 REPAIR AND MAINT, GROUND WORK .00 .00 50,000.00 50,000.00 .0 CITY OF EAGLE EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 3 MONTHS ENDING DECEMBER 31, 2022 FIBER FUND YTD ACTUAL BUDGET UNEXPENDED PCNT FOR ADMINISTRATION USE ONLY 25 % OF THE FISCAL YEAR HAS ELAPSED 01/17/2023 11:28AM PAGE: 70 61-0434-58-01 REPAIR AND MAINT, EQUIPMENT 12,904.71 12,904.71 50,000.00 37,095.29 25.8 61-0434-59-00 REPAIR AND MAINT, EMERGENCIES .00 .00 100,000.00 100,000.00 .0 61-0434-59-01 MATERIALS .00 .00 250,000.00 250,000.00 .0 61-0434-60-00 UTILITIES 132.00 132.00 .00 ( 132.00).0 61-0434-68-00 UNIFORMS AND SAFETY CLOTHING .00 .00 1,000.00 1,000.00 .0 61-0434-69-00 CITY HALL ADMIN OVERHEAD .00 .00 14,000.00 14,000.00 .0 61-0434-83-00 MAPPING PROFESSIONAL SERVICES .00 .00 20,000.00 20,000.00 .0 TOTAL OPERATIONS & MAINTENANCE 17,849.68 17,849.68 1,028,000.00 1,010,150.32 1.7 CAPITAL EXPENDITURES 61-0438-01-00 EQUIPMENT 2,613.30 2,613.30 15,000.00 12,386.70 17.4 61-0438-09-00 TOOLS AND EQUIPMENT, FY22 ARPA .00 .00 570,000.00 570,000.00 .0 61-0438-10-00 MASTER PLAN DEVELOPMENT .00 .00 10,000.00 10,000.00 .0 61-0438-11-00 CAPITAL CONSTRUCTION PROJECTS .00 .00 500,000.00 500,000.00 .0 TOTAL CAPITAL EXPENDITURES 2,613.30 2,613.30 1,095,000.00 1,092,386.70 .2 TOTAL FUND EXPENDITURES 20,462.98 20,462.98 2,389,980.00 2,369,517.02 .9 NET REVENUE OVER EXPENDITURES ( 18,184.70)( 18,184.70).00 18,184.70 .0