Loading...
HomeMy WebLinkAboutRESOLUTION 03-1800RESOLUTION#03-18REAPPROPRIATIONOF2017ENCUMBEREDFUNDSANDPROJECT“ROLLOVERS”TOTHE2018BUDGETWHEREAS,theBoardofTrusteesoftheTownofEstesParkhasadoptedthe2018annualbudgetinaccordancewiththeLocalGovernmentBudgetLawonNovember281h2017;andWHEREAS,theTownofEstesPark’saccountingsystemincorporatesapurchaseordersystemthatencumbersthebudgetappropriationwhencommitmentsforthepurchaseofgoodsorservicesaremade;andWHEREAS,encumbrancesthatwerenotliquidatedinthefiscalyearendedDecember31,2017aretobere-appropriatedinthenextfiscalyear;andWHEREAS,appropriationsforcertainprojectsunderwaythathavenotbeenencumberedwithapurchaseorderaretoberolledovertofacilitatecompletionoftheseprojects;andWHEREAS,itisnotonlyrequiredbylaw,butalsonecessarytoappropriatetherevenuesprovidedinthebudgettoandforthepurposesdescribedbelow,soasnottoimpairtheoperationsoftheTownofEstesPark.NOW,THEREFORE,BEITRESOLVEDBYTHEBOARDOFTRUSTEESOFTHETOWNOFESTESPARK,COLORADO:Thattheappropriationsbeincreasedby$3,353,107forfundsspeOifiedbelowandtheseamountsareherebyappropriatedfromadditionalrevenueoravailablefundbalanceofeachfund.FundFundNameExistingAmendmentAmended#AppropriationsAppropriations101GeneralFund17,790,615754,82618,545,441204CommunityReinvestmentFund937,5101,789,2352,726,745211ConservationTrustFund32,541032,541220LarimerCountyOpenSpaceFund267,300245,045512,345236EmergencyResponseSystemFund45,685045,685238CommunityCenterFund696,7000696,700244TrailsFund400,0000400,000260StreetFund1,679,63117,7441,697,375502Light&PowerFund18,419,162234,43218,653,594503WaterFund7,561,080264,3617,825,441606MedicalInsuranceFund2,002,90902,002,909612FleetMaintenanceFund426,5710426,571625InformationTechnologyFund715,7710715,771635VehicleReplacementFund208,00147,464255,465TotalAllFunds51,183,4763,353,10754,536,583 CADOPTEDthis27thdayofFebruary,2018ATTEST:TOWNOFESTESPARK0TjnClerkI-Mayor Revenuen,As Amended Expenses.As Amended Net Estimated Beginning Fund Balance,1/1/is Estimated Endi,Fund Balance,12/31/is Budget Reserves Community Drive /US 36 Intersection FLAP reserve Nonspendable Prepaid Fund Balance &Restricted Donations Total Restricted Fund Balance 211 220 CONSERVATION LARIMER COUNTY TRUST OPEN SPACE $32,550 $608,155 32,541 512,345 9 95,810 35,213 9,042 35,222 104,852S 236 238 EMERGENCY RESPONSE COMMUNITYCENTER $69,800 $696,700 45,685 696,700 24,115 0 39,433 0 63.548 $ 244 TRAILS 352,100 400,000 (47,900) 146,704 93,804 TOWN OF ESTES PARK RECAP OF PROPOSED BUDGET ADJUSTMENTS FOR YEAR ENDED 12-31-2018 RESOLUTION 03-18 AS OF FEBRUARY 27,2018 101 GENERAL FUNO $17,354,656 $ 18,545,441 (i.150 JELl 5,264,987 4,074,202 204 COMMUNITY REINVESTMENT 3,010,230 2,726,745 283,485 235,377 518,862 260 STREET $$ 400,000 S $$$$ 60,000 60,000 400,000 1685,900 1,697,375 (ii475) 3,462,126 3,450,651 21.6% 3444,381 3,444,381 502 503 606 612 625 635 INFORMATION VEHICLE LIGHT &POWER WATER MEDICALINSURANCE FLEET TECHNOLOGY REPLACEMENT TOTAL Revenues,AsAmended $16,279,710 $5,596,748 $2,590,625 $428,825 $726,276 $892,419 $50,324,694 Expenses,AsAmended 18,653,594 7,825,441 2,002,909 426,571 715,771 255,465 54,536,583 Net 2373,884!17,218,693)587,716 2,254 10,505 636,954 (4,211,889) Estimated Beginning Fund Balance,1/1/18 6,382,229 5,366,782 381,312 306,098 213,232 1,415,795 23,258,330 Essimated Ending Fund Balance,11/31/iS 4,002,345 $3,138,089 $969,028 308,352 223,737 2,052,749 19,046,441S$$$$ 0 ATTACHMENT B C0TOWNOFESTESPARKSUMMARYOFANTICIPATEDREVENUEADJUSTMENTSFORYEARENDED12-31-2018RESOLUTION03-18ASOFFEBRUARY27,2018ResolutionBudgetFund/DeptCurrentBudget#03-18AsAmended101GENERALFUND16845319509,33717,354,656204COMMUNITYREINVESTMENT1368,3221,641,9083,010,230211CONSERVATIONTRUST32,550-32,550220LARIMERCOUNTYOPENSPACE368,250239,905608,155236EMERGENCYRESPONSE69,800-69,800236COMMUNITYCENTER696,700-596,700244TRAILS352,100-352,100260STREET1,685,900-1,685,900502LIGHT&POWER16,279,710-16,279,710503WATER5,596,748-5,596,748606MEDICALINSURANCE2,590,625-2,590,625612FLEET428,825-428,825625INFORMATIONTECHNOLOGY726,276-726,276635VEHICLEREPLACEMENT892,419-892,419TOTAL47,933,5442,391,15050,324,694ATTACHMENTB 00TOWNOFESTESPARKSUMMARYOFSUPPLEMENTALAPPROPRIATIONSFORYEARENDED12-31-2018RESOLUTION03-18ASOFFEBRUARY27,2018ResolutionBudgetAsFund/DeptCurrentBudget*103-18Amended101GENERALFUND101-1100Legislative208,3644,998213,362101-1200Judicial80,131-80,131101-1300Executive3551105,776360,886101-1400AdminSvcs6098034,382614,185101-1500Finance548652800549,452101-1600CornDev(Planning)805,068-805,068101-1700Facilities1,031,11022,1541,053,264101-1800EmployeeBenefits150,7518,900159,651101-1900CommunityServiceGrants1,059,065-1,059,065101-2100Police-Patrol3,353,9635,6743,359,637101-2155Police-Communications1,003,181-1,003,181101-2175Police-CommSvcs348,097-348,097101-2300BuildingSafetyDivison559,092-559,092101-2400Engineering378,796133,616512,412101-2600VisitorCenter461,529-461,529101-3100Streets1,144,162547,9121,692,074101-5200Parks1,164,20018,4041,182,604101-5304SeniorCenter21,250-21,250101-5500SpecialEvents2,333,439-2,333,439101-5600Transit466,678-466,678101-5700Museum357,8522,210360,062101-9000Transfers1,350,3221,350,322101GENERALFUND17,790.615754,82618,545,441204COMMUNITYREINVESTMENT937,5101,789,2352,726,745211CONSERVATIONTRUST32,541-32,541220LARIMERCOUNTYOPENSPACE267,300245,045512,345236EMERGENCYRESPONSE45,68S-45,685238COMMUNITYCENTER696,700-696,700244TRAILS400,000-400,000260STREET1,679,63117,7441,697,375502LIGHT&POWER18.419,162234,43218,653,594S03WATER7,561,080264,3617,825,441606MEDICALINSURANCE2,002,909-2,002,909612FLEET426,571-426,571625INFORMATIONTECHNOLOGY715,771-715,771635VEHICLEREPLACEMENT208,00147,464255,465TOTALALLFUNDS51,183,4763,353,10754,536,583ATTACHMENTB TOWN OF ESTES PARK P0 &SELECT PROJECT ROLLOVERS RESOLUTION 03-18 AS OF FEBRUARY 27,2018 STRUCTURES INC COMMUNITY DRIVE ENGINEERING PROJECT KIMLEY HORN &ASSOCIATES INC WALKER PARKING CONSULTANTS DYNAMIC MESSAGE SYSTEM MORBRG COMM DR CVBPRK DYNMSG Vendor U’Vendor Name Additional 2017 Project Appropriation from Budget Project P0 Balance Rollovers Fund Balance AmendmentFundAccountNumber 101 101-1100-411.26-46 101 101-1300-413.29-33 101 101-1400-414.22-98 101 101-1SOO-415.26-23 101 101-1700-417.25-02 101 1Ol-1700-417.2S-02 101 101-1700-417.33-32 101 101-1800-418.22-90 101 101-2100-421.26-11 101 101-2100-421.26-11 101 101-2400324.22-02 101 101-2400424.22-02 101 101-2400-424.22-02 101 101-3100431.22-02 101 101-3100-431.22-02 101 101-3100431.22-02 101 101-3100-431.22-02 101 101-3100431.25-04 101 101-3100431.26-46 101 101-3100431.34-98 101 101-3100-431.34-98 101 101-5200452,26-46 101 101-5200-452.34-98 101 101-5200452.34.98 101 101-5700-457.25-02 TOTAL GENERAL FUND 204 204-5400-544.35-51 204 204-5400-544.35-51 204 204-S400-S44.3S-S2 204 204-5400-544.35-52 204 204-5400-544.36-52 P04 036191 036190 03SS96 036200 036081 036112 036195 036109 036043 036157 035375 035391 035398 035634 035634 035635 035635 036173 036168 036147 036148 036168 036150 036159 036165 036117 NA 035921 035938 NA CENTWN MORBRG STORM STM FEE SCATC FHWAFC SCATC FR WA FC VIDEOLINK INC PINNACLE SCOPES INC ESM CONSULTING SERVICES INC PRODUCTIVE OFFICE &SCHOOL COLORADO DOORWAYS,INC. COLORADO DOORWAYS,INC. INTECONNECT INC MILLIMAN INC PCS MOBILE SAFARILAND TRAINING GROUP CORNERSTONE ENGINEERING AND ANDERSON CONSULTING ENGINEERS INC ANDERSON CONSULTING ENGINEERS INC LARIMER COUNTY ENGINEERING LARIMER COUNTY ENGINEERING LARIMER COUNTY ENGINEERING IARIMER COUNTY ENGINEERING MACDONALD EQUIPMENT COMPANY MOTOROLA SOLUTIONS,INC. WATSON (0.1.)COMPANY,INC. WATSON (0.J.)COMPANY,INC. MOTOROLA SOLUTIONS,INC. WATSON (0.i.)COMPANY,INC. MILE HIGH GOLF CARS SMITH SIGN STUDIO Date 12/29/2017 12/28/2017 1/11/2017 12/29/20 17 10/24/20 17 11/6/20 17 12/31/2017 11/1/20 17 9/27/20 17 12/4/20 17 1/1/20 17 1/1/20 17 12 /3 1/2017 1/1/2017 1/1/2017 1/1/2017 1/1/20 17 12/15/20 17 12/14/20 17 11/30/20 17 11/30/20 17 12/14/2017 11/30/20 17 12/6/2017 12/12/20 17 11/10/20 17 NA 7/13/2017 7/24/2017 NA 0004946 0005965 0004811 0003195 000 195 5 0001955 0005769 0003108 0003650 0005825 0002522 0005366 0005366 0003423 0003423 0003423 0003423 0001039 0000544 0000957 0000957 0000544 0000957 0005958 0004507 0005928 NA 0005896 0004866 NA 4,998.00 5,776.00 4,382.50 800.00 3,049.96 3,071.00 16,033.29 8,900.00 3,674.00 2,000.00 86,283.00 37,038.38 10,294.32 40,323.24 334,611.43 7,395.00 127,007.00 14,575.00 8,000.00 10,391.00 5,609.00 7,402.67 10,000.00 1,001.25 2,210.00 754,826.04 4,998.00 5,776.00 4,382.50 800 .00 3,049.96 3,071.00 16,033.29 8,900.00 3,674.00 2,000.00 86,283.00 37,038.38 10,294.32 40,323.24 334,611.43 7,395.00 127,007.00 14,575.00 8,000.00 10,391.00 5,609.00 7,402.67 10,000.00 1,001.25 2,210.00 754,826.04 TOTAL COMMUNITY REINVESTMENT FUND 1,589,711.46 1,589,711,46 50,000.00 50,000.00 S,169.O0 5,169.00 6,000.00 6,000.00 128,354.00 10,000.00 138,354.00 1,600,880.46 178,354.00 10,000.00 1,789,234.46 ATTACHMENT B Fund Account Number 220 220-4600362.22-02 035391 220 2203600-46222-02 035634 220 220-4600462.22-02 035635 TOTAL LARIMER COUNTY OPEN SPACE FUND 260 260-2000-420.25-20 035198 TOTAL STREET IMPROVEMENT FUND 503 503-6300-540.22-02 503 503-7000-580.33-36 503 503-7000-580.33-36 503 503-7000-580.33-36 503 503-7000-580.33-36 503 503-7000-580.33-36 503 503-7000-580.35-54 503 503-7000-580.35-54 503 503-7000-580.35-62 TOTAL WATER FUND BB0001 TR AN S F EQUIP AP2016 MO RAVE MORB17 AP2016 PEMPWC MORB17 5140.04 239,905.10 P0 if Date Vendor N’Vendor Name Project P0 Balance Rollovers Fund Balance Amendment 1/1/2017 0005718 DEEREANDAULTCONSULTANTS INC CDBGCH 5,14004 4/17/2017 0003423 LARIMER COUNTY ENGINEERING 11CATG 23g,gos.lo 4/17/2017 0003423 LARIMER COUNTY ENGINEERING 11CATG Additional 2017 Project Appropriation from 4/26/2017 0000144 MOUNTAIN CONSTRUCTORS INC. Budget 1750 P 502 502-6301-540.25-31 502 502-6301-540.25-33 502 502-6401-550.26-23 502 502-6501-560.22-98 502 502-6501-560.27-04 502 502-7001-580.33-35 502 502-7001-580.33-41 502 502-7001-580.35-57 502 502-7001-580.35-58 502 502-7001-580.35-58 502 502-7001-580.35-66 502 502-7001-580.35-66 TOTAL LIGHT &POWER FUND 036130 035590 036200 035914 036035 035920 036086 036009 036068 036082 035702 036178 035382 036180 036181 036182 036183 036186 035742 036083 035382 035917 036147 036150 036159 036168 11/22/2017 1/11/2017 12/29/2017 7/11/20 17 9/26/20 17 7/13/2017 10/26/2017 9/5/20 17 10/13/2017 10/24/2017 3/2/2017 12/20/20 17 1/1/2017 12/20/20 17 12/18/2017 12/20/2017 12/20/2017 12/26/2017 3/23/20 17 10/24/2017 1/1/2017 7/12/2017 11/30/20 17 11/30/20 17 12/6/2017 12/14/2017 0001955 0000461 0003195 0005897 0005328 0002879 0000143 0000828 0004269 0005928 0005814 0001671 0003601 0001750 0001750 0001750 0001750 0001750 0005600 0005928 0003601 0005899 0000957 0000957 000S9SB 0000544 COLORADO DOORWAYS,INC. 4 RIVERS EQUIPMENT LLC PRODUCTIVE OFFICE &SCHOOL UPTOWN SERVICES LLC TANTALUS SYSTEMS CORP STUART C IRBY CO HOTLINE ELECTRICAL SALES WESTERN UNITED ELECTRIC SUPPLY BADGER DRILLING &BLASTING CORP STRUCTURES INC BACKBONE FIBER SYSTEMS LLC SHERMAN &REILLY INC. HOR ENGINEERING SERVICES,INC. INTEGRATED TELECOMMUNICATION INTEGRATED TELECOMMUNICATION INTEGRATED TELECOMMUNICATION INTEGRATED TELECOMMUNICATION INTEGRATED TELECOMMUNICATION JVA INCORPORATED STRUCTURES INC HDR ENGINEERING SERVICES,INC. KUSTOM FABRICATED SOLUTIONS LLC WATSON (0.1.)COMPANY,INC. WATSON (0.1.)COMPANY,INC. MILE HIGH GOLF CARS MOTOROLA SOLUTIONS,INC. 245,045.14 --245,045.14 17,743.55 17,743.55 17,743.55 --17,743.55 3,049.96 3,049.96 7,500.00 7,500.00 2,7S0.OO 2,750.00 10,000.00 10,000.00 3,000.00 3,000.00 7,823.80 7,823.80 20,638.00 20,638.00 64,412.82 64,412.82 50,000.00 50,000.00 15,191.00 15,191.00 21,244.10 21,244.10 28,822.40 28,822.40 234,432.08 --234,432.08 352.64 352.64 19,360,40 19,360.40 14,000.00 14,000.00 11,732,50 11,732,50 5,300.00 5,300.00 19,814,50 19,814.50 72,000.00 72,000,00 91,445.00 91,445.00 30,356.31 3D,3S6,31 264,361.35 --264,361.35 11,892,50 11,892.50 12,852.00 12,852.00 14,597.00 14,597.00 7,997,50 7,997,50 125.09 125.09 47,464,09 --47,464,09 3,164,752,71 178,354,00 10,000.00 3,353,106.71 635 635-7000-435,34-42 635 635-7000-435.34-42 635 635-7000435,34-42 63S 635-7000-435.34-42 635 635-7000-435.34-42 TOTAL VEHICLE REPLACEMENT FUND Grand Total ATTACHMENT B