Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2019-2023 Capital Improvement Plan
Capital Investment Program – 2019 2023 InvestinginCommunity Safe~ Friendly~ Vibrant~ Stable December 2018 2019 – 2023Capital InvestmentProgram Table of Contents Fund Summaries Summary of Expenditures by Program Category & Method of Financing............. 1 Cable Television Fund.......................................................................................... 2 Building Capital Improvements............................................................................. 3 Streets Improvement Fund................................................................................... 4 ParksCapital Improvements................................................................................. 5 Information Technology Fund............................................................................... 6 Capital EquipmentFund....................................................................................... 7 Water Utility Fund................................................................................................. 8 Sewer Utility Fund................................................................................................ 9 Storm Water Utility Fund....................................................................................10 Liquor Fund........................................................................................................11 D etail Project Pages Governmental and Special Revenue Funds Cable TV ...........................................................................................................12 Buildings ......................................................................................................13–15 Streets ......................................................................................................... 16–28 Parks ...........................................................................................................29–37 Information Technology ............................................................................... 38–46 Capital Equipment........................................................................................47–87 Enterprise Funds Water Utility Fund.........................................................................................88–98 Sewer Utility Fund......................................................................................99–103 Storm Water Utility Fund..........................................................................104–117 Municipal LiquorFund......................................................................................118 Table I Capital Investment Program 2019-2023 EXPENDITURES BY PROGRAM CATEGORY & METHOD OF FINANCING 20172018201820192020202120222023 ActualBudgetRevisedBudgetProjectionProjectionProjectionProjectionTOTALPercent Expenditures Program Category Major Equipment$ 713,442$534,600$531,000$759,700$ 1,224,000$ 414,000$414,000$607,000$5,197,7425.3% Technology Improvements169,690317,000317,000310,000184,000154,000154,000404,0002,009,6902.0% Municipal Buildings19,417,00722,000,00031,060,000250,00072,727,00774.1% - - - - Parks Improvements528,012634,00010,000876,000412,000197,000197,000410,0003,264,0123.3% Street Improvements3,341,8101,862,800524,4002,398,2002,008,4002,125,4002,125,400505,40014,891,81015.2% Total Expenditures By Program$ 24,169,961$25,348,401$32,442,402$ 4,593,902$3,828,403$2,890,404$2,890,405$1,926,405$ 98,090,283100.0% Method of Financing Property Taxes$ 50,000$ 100,000$ 50,000$55,913$57,310$58,743$58,743$61,717$ 542,4260.7% Local Government Aid605,145568,300568,300577,400577,400577,400577,400577,4005,728,7387.3% Municipal State Aid645,477500,000100,000426,0001,000,000700,000700,000400,0005,512,3237.0% Federal Highway Aid1,128,015459,000420,000360,000360,0002,804,9633.6% - - - S.P.R.I.N.G. Foundation476,027300,0006,00050,000-832,0271.1% - - - Other Grants & Reimb (4,825)825,20025,200775,200775,20010,0002,405,9753.1% - - User Fees (External & Internal)6,5012,4002,508,2003.2% - - - - - - Park Dedication Fees-5,00060,0005,0005,0005,0005,0005,00096,4220.1% Special Assessments431,178230,000230,000110,000680,000300,000300,000360,0003,241,4014.1% Interest on Investments301,828154,000154,00069,00049,00024,00024,00024,000857,9721.1% Auction Proceeds91,81930,00030,00030,00030,00030,00030,00030,000345,5090.4% Capital Improvement Plan Bonds50,714,89850,714,89864.6% - - - - - - - Transfers In (Liquor Proceeds)250,000250,000250,000250,000250,000250,000250,000250,0002,250,0002.9% Transfers In (Other Funds)-250,00031,00031,00031,00031,00031,000612,1000.8% - Total Method of Financing$ 54,696,063$ 2,596,300$1,700,700$2,849,513$2,704,910$3,111,343$3,111,343$1,749,117$ 78,452,954100.0% Net30,526,102(22,752,101)(30,741,702)(1,744,390)(1,123,493)220,939220,938(177,288) Expenditures - Enterprise Program Category Storm Drainage Improvements$ 1,110,437$1,345,000$ 947,000$ 1,603,000$ 495,000$315,000$315,000$320,000$6,450,43730.8% Water System Improvements1,359,7861,105,000865,0004,790,0001,105,000550,000550,000630,00010,954,78652.3% Sewer System Imp66,919265,000265,000810,00050,000665,000665,000695,0003,481,91916.6% Municipal Liquor Stores-56,00018,00074,0000.4% - - - - - Total Expenditures By Program$ 2,537,142$2,771,000$2,077,000$7,221,000$1,650,000$1,530,000$1,530,000$1,645,000$ 20,961,142100.0% Method of Financing - Enterprise Grants$ 775,131$217,000$290,000$ 17,000$17,000$17,000$17,000$17,000$ 1,367,1316.5% User Fees (External & Internal)1,762,0112,554,0001,787,0007,204,0001,633,0001,513,0001,513,0001,628,00019,594,01193.5% Total Method of Financing$ 2,537,142$2,771,000$2,077,000$7,221,000$1,650,000$1,530,000$1,530,000$1,645,000$ 20,961,142100.0% Page 1 Table II CIP 2019-2023 CABLE TV FUND Funding Sources and Expenditure Projections 20172018201820192020202120222023 225ActualBudgetRevisedBudgetProjectionProjectionProjectionProjection Funding Sources Licenses & permits$297,233$290,000$290,000$293,300$300,633$308,148$315,852$323,748 Charges for Services1,115--700---- Interest on Investments11,97210,00010,00014,70014,70014,70014,70014,700 Reimbursement26,142------- Total Funding Sources$336,462$300,000$300,000$308,700$315,333$322,848$330,552$338,448 Non-Capital Expenditures Operations$285,486$555,300$600,200$322,600$329,052$335,633$335,633$342,346 Subtotal Non-capital Expenditures$285,486$555,300$600,200$322,600$329,052$335,633$335,633$342,346 Capital Expenditures Video editing system---12,000---- Total Expenditures$285,486$555,300$600,200$334,600$329,052$335,633$335,633$342,346 Surplus (deficiency) of funding sources over (under) expenditures$50,976$(255,300)$(300,200)$(25,900)$(13,720)$(12,785)$(5,081)$(3,897) Estimated Beginning Fund Balance1,527,9631,578,9391,578,9391,028,7391,002,839989,120976,335971,254 Transfer out for Council Chamber AV System-(250,000)(250,000)----- Estimated Ending Fund Balance$1,578,939$1,073,639$1,028,739$1,002,839$989,120$976,335$971,254$967,356 Page 2 Table III CIP 2019-2023 BUILDING CAPITAL IMPROVEMENTS Funding Sources and Expenditure Projections 20172018201820192020202120222023 405ActualBudgetRevisedBudgetProjectionProjectionProjectionProjection Funding Sources Interest on Investments$ 274,929$ 120,000$ 120,000$ 40,000$ -$ -$ -$ - Capital Improvement Plan Bonds*50,714,898------- Other2,500------- Transfer In (HRA & Cable TV Fund)--250,00031,00031,00031,00031,00031,000 Total Funding Sources$ 50,992,327$ 120,000$ 370,000$ 71,000$ 31,000$ 31,000$ 31,000$ 31,000 Expenditures Civic Campus Civic Campus, Floor Sweeper$ -$ -$ 60,000$ -$ -$ -$ -$ - Police and Public Works Storage Facility-250,000-250,000---- Civic Campus Architectural Design, Construction*18,693,12321,750,00031,000,000---- - Civic Campus, Bond Issuance Costs711,761------- Public Works Public Works Building Upgrades, Crane------150,000- Fire Stations Fire Station 2 & 3 Building Repairs12,123-----40,000- Total Expenditures$ 19,417,007$ 22,000,000$ 31,060,000$ 250,000$ -$ -$ 190,000$ - Surplus (deficiency) of funding sources over (under) expenditures$ 31,575,320$ (21,880,000)$ (30,690,000)$ (179,000)$ 31,000$ 31,000$ (159,000)$ 31,000 Estimated Beginning Fund Balance672,83532,248,15532,248,1551,558,1551,379,1551,410,1551,410,1551,251,155 Estimated Ending Fund Balance$ 32,248,155$ 10,368,155$ 1,558,155$ 1,379,155$ 1,410,155$ 1,441,155$ 1,251,155$ 1,282,155 Page 3 Table IV CIP 2019-2023 STREET IMPROVEMENT FUND Funding Sources and Expenditure Projections 20172018201820192020202120222023 406ActualBudgetRevisedBudgetProjectionProjectionProjectionProjection Funding Sources Municipal State Aid - State Aid Routes$568,546$400,000$50,000$180,000$170,000$300,000$-$- Municipal State Aid - Local Routes76,931100,00050,000246,000830,000400,000400,000400,000 Federal Highway Funds1,128,015459,000-420,000-360,000-- Other State Grants and Aids---50,000---- Misc.(4,825)-800,000-750,000-. Special Assessments431,178230,000230,000110,000680,000300,000360,000360,000 Interest on Investments12,18210,00010,0005,00025,000--- Total Funding Sources$2,212,027$1,199,000$340,000$1,811,000$1,705,000$2,110,000$760,000$760,000 Expenditures $10,000$910,000$750,000$930,000$580,000$- Street Rehabilitation Program$511,133$480,000 Street Sealing Program (Chip Sealing)248,248250,000250,000250,000250,000250,000250,000250,000 Street Sealing Program (Crack Sealing)-20,00020,00020,00023,00025,00025,00030,000 Trail/Walk Upgrades-200,000-300,000100,000100,000100,000100,000 West Moore Lake Ped & Bike Improvements-600,000120,000600,000---- 7th Street Ped & Bike Improvements-----700,000-- Traffic Signal Maintenance/Retrofit191,225180,000-75,00020,00020,00025,00025,000 Capital Signage Replacements-15,000-15,00015,000-15,000- Traffic Safety Improvement Projects9,32830,00030,00030,00030,00030,00060,00030,000 Main Street Pedestrian Bridge Project2,279,433----- Development/Connections----750,000-- Community Corridor Study---100,000---- Transfer to the General Fund (Staff Allocation)102,44387,80094,40098,20070,40070,40070,40070,400 Total Expenditures$3,341,810$1,862,800$524,400$2,398,200$2,008,400$2,125,400$1,125,400$505,400 Surplus (deficiency) of funding sources over (under) expenditures$(1,129,783)$(663,800)$(184,400)$(587,200)$(303,400)$(15,400)$(365,400)$254,600 Estimated Beginning Fund Balance2,796,8011,667,0181,667,0181,482,618895,418592,018576,618211,218 Estimated Ending Fund Balance$1,667,018$1,003,218$1,482,618$895,418$592,018$576,618$211,218$465,818 Page 4 Table V CIP 2019-2023 PARKS CAPITAL IMPROVEMENT Funding Sources and Expenditure Projections 20172018201820192020202120222023 407ActualBudgetRevisedBudgetProjectionProjectionProjectionProjection Funding Sources Local Government Aid$20,000$125,000$125,000$125,000$125,000$125,000$125,000$125,000 Park Dedication Fees-5,00060,0005,0005,0005,0005,0005,000 Liquor Store Proceeds (Transfer)75,00075,00075,00075,00075,00075,00075,00075,000 Interest on Investments8,60715,00015,00015,00015,00015,00015,00015,000 State Grant Funds---150,000---- S.P.R.I.N.G. Foundation Donations/Grant476,027300,0006,00050,000---- Total Funding Sources$579,634$520,000$281,000$420,000$220,000$220,000$220,000$220,000 Expenditures $35,000 Court Surfacing/Overlays$28,575$32,000$-$64,000$35,000$35,000$35,000 Park Furnishings3,88412,0005,00012,00012,00012,00012,00015,000 Civic Campus Park Improvements---200,00050,000--- Parking Lot Replacement15,016130,000--90,000--200,000 SNC Boardwalk Replacement-5,000-5,000---10,000 Playground Equipment Replacement17,535150,000-120,000150,000150,000150,000150,000 Moore Lake Park Master Plan, Picnic Shelter 14,8975,000--75,000--- SPRING Proj/Ph 1/SNC52,227------- SPRING Proj Ph 2/SNC395,878300,0005,000300,000---- Locke Park Pointe Playground---175,000---- Total Expenditures$528,012$634,000$10,000$876,000$412,000$197,000$197,000$410,000 Surplus (deficiency) of funding sources over (under) expenditures$51,622$(114,000)$271,000$(456,000)$(192,000)$23,000$23,000$(190,000) Estimated Beginning Fund Balance1,470,3001,521,9221,521,9221,792,9221,336,9221,144,9221,167,9221,190,922 Estimated Ending Fund Balance$1,521,922$1,407,922$1,792,922$1,336,922$1,144,922$1,167,922$1,190,922$1,000,922 Page 5 Table VI CIP 2019-2023 INFORMATION TECHNOLOGY PROJECTS FUND Funding Sources and Expenditure Projections 20172018201820192020202120222023 409ActualBudgetRevisedBudgetProjectionProjectionProjectionProjection Funding Sources Property Taxes$50,000$100,000$50,000$55,913$57,310$58,743$60,212$61,717 Local Government Aid86,000150,000150,00072,40072,40072,40072,40072,400 Charges for Services6,501-2,400----- Interest on Investments3,0031,5001,5001,5001,5001,5001,5001,500 Miscellaneous4,090-130,000----- Total Funding Sources$149,594$251,500$333,900$129,813$131,210$132,643$134,112$135,617 Expenditures Technology Purchases and Upgrades$4,686$64,000$64,000$32,000$37,800$37,800$37,800$37,800 Computer and Printer Replacement106,703133,000133,00090,000106,200106,200106,200106,200 Microsoft SA Licenses (server CALs)-40,00040,000----- Network Switch Replacement------250,000 2-Factor Authentication2,420------- Accelerated Laserfiche Implementation16,667------- Laserfiche Expansion-20,00020,00020,00010,00010,00010,00010,000 Police VPN6,042------- Energov (Code Enforcement Software)33,172------- Paperless Accounts Payable Pilot---25,000---- Mobile Device Management System-4,0004,000----- L3 Server Upgrade-36,00036,000----- Security Audit-8,0008,00010,000---- Applicant Tracking System-12,00012,000----- Agenda Management---9,000---- Mobile Assessing Technology---2,000---- VSAN Replacement---110,000---- Firewall Replacement----30,000--- Total Expenditures$169,690$317,000$317,000$298,000$184,000$154,000$154,000$404,000 Surplus (deficiency) of funding sources over (under) expenditures$(20,096)$(65,500)$16,900$(168,188)$(52,790)$(21,357)$(19,888)$(268,383) Estimated Beginning Fund Balance459,969439,873439,873456,773288,585235,795214,438194,550 Estimated Ending Fund Balance$439,873$374,373$456,773$288,585$235,795$214,438$194,550$(73,833) Page 6 Table VII CIP 2019-2023 CAPITAL EQUIPMENT FUND Funding Sources and Expenditure Projections 20172018201820192020202120222023 410ActualBudgetRevisedBudgetProjectionProjectionProjectionProjection Funding Sources Local Government Aid$ 499,145$ 293,300$ 293,300$ 380,000$ 380,000$ 380,000$ 380,000$ 380,000 Liquor Store Proceeds (Transfer)175,000175,000175,000175,000175,000175,000175,000175,000 Interest on Investments3,1077,5007,5007,5007,5007,5007,5007,500 Federal Grants---25,20025,20025,20010,00010,000 Auction Proceeds91,81930,00030,00030,00030,00030,00030,00030,000 Total Funding Sources$ 769,071$ 505,800$ 505,800$ 617,700$ 617,700$ 617,700$ 602,500$ 602,500 Expenditures Police Police Squad/SUV/Pickup$ 206,143$ 181,600$ 184,000$ 127,000$ 127,000$ 127,000$ 127,000$ 127,000 Non-Lethal Force Equipment38,153------- MILO - Interactive Simulator---30,000---- Squad/Body Camera Upgrade42,000--67,700---- 800 MHz Radio Replacement59,482------- Fire High Pressure Firefighting Vehicle---77,000---- Rescue Truck(s)92,17235,00035,000----- Personal Protective Equipment----30,00030,00030,000- 800 MHz Radio Replacement65,68120,00020,000----- SCBA Replacement---135,000135,000--- Digital fire attack simulator29,828------- Thermal Imagers-----12,000-- Gear Extractor------10,000- Apparatus Vent Fab-------200,000 Community Services/Employee Relations Mobile Event Van---70,000---- Passenger Van-----40,000-- Community Development Building Inspection Vehicle-30,00024,00030,000---- Code Enforcement Vehicle----25,00025,000-- Rental Inspection Vehicle----25,00025,000-- Public Works - Parks Division Highway Mower Replacement-9,0009,000115,000---- Zero Turn Mower Replacement---10,000---- Pickup Truck27,91553,00053,000--40,00050,00030,000 Dump Trucks with Plows-39,00039,000----- Tanker Truck----150,000--- Skid Steer---35,000---- Utility Vehicle for Plowing116,000------- Utility Vehicile with Groomer---38,000---- Utility Vehicle----40,000--- Zero Turn Mower Replacement----10,00010,000-- Front Mount Tractor/Mower Replacemen----18,000--10,000 Aeration Tool Attachment Replacement------7,000- Public Works - Streets Division Pickup Trucks36,068----95,00045,000- Dump Trucks with Plows-132,000132,000-200,000-230,000240,000 Skid Loader---25,000---- Paving Equipment-----10,000-- Dump Truck w/Hot Mix Box Replacement----200,000--- Asphalt Roller Replacement----34,000--- Wheeled Loader with Plow Attachment----230,000--- Total Expenditures$ 713,442$ 534,600$ 531,000$ 759,700$ 1,224,000$ 414,000$ 499,000$ 607,000 Surplus (deficiency) of funding sources over (under) expenditures$ 55,629$ (28,800)$ (25,200)$ (142,000)$ (606,300)$ 203,700$ 103,500$ (4,500) Estimated Beginning Fund Balance768,150823,779823,779798,579656,57950,279253,979357,479 Projects Carried Forward from Prior Years----- Estimated Ending Fund Balance$ 823,779$ 794,979$ 798,579$ 656,579$ 50,279$ 253,979$ 357,479$ 352,979 Page 7 Table VIII CIP 2019-2023 WATER UTILITY FUND Funding Sources and Expenditure Projections 20172018201820192020202120222023 601ActualBudgetRevisedBudgetProjectionProjectionProjectionProjection Funding Sources Water Sales$3,495,836$3,937,800$3,862,000$3,983,500$4,550,709$4,766,998$4,994,081$4,994,081 Interest on Investments38,9615,2005,20030,00030,00030,00030,00030,000 Total Funding Sources$3,534,797$3,943,000$3,867,200$4,013,500$4,580,709$4,796,998$5,024,081$5,024,081 Expenditures Non-Capital Expenditures Operating Expenses $3,425,536$3,002,900$2,917,400$2,874,100$2,931,582$2,990,214$3,050,018$3,111,018 Debt Service88,123163,7001,018,7001,025,600789,900794,975794,650793,794 Subtotal Non-capital Expenditures$3,513,659$3,166,600$3,936,100$3,899,700$3,721,482$3,785,189$3,844,668$3,904,812 Capital Expenditures Fleet Vehicles$32,230$-$-$-$-$-$-$80,000 Trailer Vac Excavator-60,00060,000----- Distribution System Reconstruction*-300,00060,000540,000300,000500,000500,000500,000 Hydrant Repairs-20,00020,00020,00020,00020,00020,00020,000 Well Updates*29,150190,000190,000400,000200,000-210,000- Water Meter Replacement - AMR System*30,000110,000110,00010,00010,00010,00030,00010,000 Well House Building Repairs-40,00040,00020,00040,00020,00040,00020,000 Distribution System Interconnection*---500,000---- Locke Park Treatment Plant Rehabilitation---3,300,000500,000--- Variable Frequency Drives-35,00035,000-35,000-40,000- Treatment Plant Retrofits*153,836-----100,000- Transmission System Reconstruction*1,114,570350,000350,000----- Subtotal Capital Expenditures$1,359,786$1,105,000$865,000$4,790,000$1,105,000$550,000$940,000$630,000 Total Expenditures$4,873,445$4,271,600$4,801,100$8,689,700$4,826,482$4,335,189$4,784,668$4,534,812 Estimated Beginning Cash Reserve7,340,4044,213,0914,213,0913,331,5912,500,4913,359,7184,371,5275,550,940 Estimated Ending Cash Reserve$4,213,091$2,125,283$3,331,591$2,500,491$3,359,718$4,371,527$5,550,940$6,670,209 Cash Balance Floor (6 months Operating/DS/Capital)2,770,1503,342,4007,252,6503,360,6912,840,0823,259,6592,979,303 One year operating, debt & capital5,434,1335,963,63310,114,5006,550,0496,437,0237,276,1177,026,261 Page 8 Table VIIII CIP 2019-2023 SEWER UTILITY FUND Funding Sources and Expenditure Projections 20172018201820192020202120222023 602ActualBudgetRevisedBudgetProjectionProjectionProjectionProjection Funding Sources Sewer Services$5,656,419$5,822,800$6,043,530$6,167,375$6,352,396$6,542,968$6,739,257$6,941,435 Interest on Investments11,46418,80018,80014,00014,00014,00014,00014,000 Total Funding Sources$5,667,883$5,841,600$6,062,330$6,181,375$6,366,396$6,556,968$6,753,257$6,955,435 Expenditures Non-Capital Expenditures Operating Expenses$1,175,591$1,317,716$1,172,510$1,192,600$1,216,452$1,240,781$1,240,781$1,265,597 Sewer Service Charge4,135,3014,284,0004,234,3044,625,4154,764,1774,907,1035,054,3165,205,945 Debt Service11,22510,60010,6009,60043,52542,47546,35045,100 Subtotal Non-capital Expenditures$5,322,117$5,612,316$5,417,414$5,827,615$6,024,154$6,190,359$6,341,447$6,516,642 Capital Expenditures Fleet Vehicles$66,919$220,000$220,000$-$-$-$-$- Sanitary Sewer Collection System Recon-45,00045,000105,00050,00050,00050,00050,000 Sanitary Sewer Collection System Lining---270,000-520,000-550,000 Sanitary Sewer Force Main Recon---90,000-95,000-95,000 Generator---35,000---- Lift Station Rehabilitation---310,000--40,000- Subtotal Capital Expenditures$66,919$265,000$265,000$810,000$50,000$665,000$90,000$695,000 Total Expenditures$5,389,036$5,877,316$5,682,414$6,637,615$6,074,154$6,855,359$6,431,447$7,211,642 Estimated Beginning Cash Reserve1,677,0862,286,9442,286,9442,941,8603,828,4204,170,6624,537,2714,949,081 Estimated Ending Cash Reserve$2,286,944$1,983,576$2,941,860$3,828,420$4,170,662$4,537,271$4,949,081$5,387,874 Cash Balance Floor (6 months Operating/DS/Capital)3,076,4582,979,0073,728,6083,083,8403,781,4173,283,8983,975,871 One year operating, debt & capital6,312,1166,117,2147,131,9156,656,3647,540,5867,217,1917,997,386 Page 9 Table X CIP 2019-2023 STORM WATER FUND Funding Sources and Expenditure Projections 20172018201820192020202120222023 603ActualBudgetRevisedBudgetProjectionProjectionProjectionProjection Funding Sources Storm Water Utility Fees$ 1,382,590$ 1,379,000$ 1,379,000$ 1,444,100$ 1,472,982$ 1,502,442$ 1,532,490$ 1,563,140 Grants and Other Revenue775,131217,000290,00017,00017,00017,00017,00017,000 Interest on Investments18,61212,00012,00015,00015,00015,00015,00015,000 Total Funding Sources$ 2,176,333$ 1,608,000$ 1,681,000$ 1,476,100$ 1,504,982$ 1,534,442$ 1,564,490$ 1,595,140 Expenditures Operating Expenses$ 1,077,431$ 1,243,100$ 1,124,800$ 1,143,600$ 1,166,472$ 1,189,801$ 1,189,801$ 1,213,597 Debt Service8,3507,9007,9007,20031,41335,58829,76333,900 Subtotal Operating Expenditures$ 1,085,781$ 1,251,000$ 1,132,700$ 1,150,800$ 1,197,885$ 1,225,389$ 1,219,564$ 1,247,497 Capital Expenditures Pond Maintenance$ -$ 25,000$ 2,000$ 48,000$ 30,000$ 30,000$ 30,000$ 30,000 Mississippi Underpass Rehab .---100,000---- Storm Sewer Replacement/Reconstr/Lining-60,000-120,00065,00065,00065,00065,000 Storm Sewer System Upgrades217,080160,000-220,000100,000100,000100,000100,000 Oak Glen Creek Erosion Control831,774--200,000---- Watershed BMP Implementation-20,00020,00020,00020,00020,00025,00025,000 Street Sweeper--230,000---- Watershed District Water Quality Projects-70,000-130,00080,000100,00060,000100,000 Sediment Removal Projects----100,000--- TMDL Water Quality Projects-50,000-200,000100,000-300,000- Stonybrook Flood Control Project61,583900,000900,000200,000---- Locke Lake Dam Upgrades-35,000-35,000---- Norton Creek---100,000--900,000- Vehicles-25,00025,000----- Subtotal Capital Expenditures$ 1,110,437$ 1,345,000$ 947,000$ 1,603,000$ 495,000$ 315,000$ 1,480,000$ 320,000 Total Expenditures$ 2,196,218$ 2,596,000$ 2,079,700$ 2,753,800$ 1,692,885$ 1,540,389$ 2,699,564$ 1,567,497 Estimated Beginning Cash Reserve2,024,4752,256,1372,256,1372,187,4371,248,6371,555,7341,864,7862,209,712 Estimated Ending Cash Reserve$ 2,256,137$ 1,308,875$ 2,187,437$ 1,248,637$ 1,555,734$ 1,864,786$ 2,209,712$ 2,557,355 Cash Balance Floor (6 months Operating/DS/Capital)1,974,4501,517,3002,182,0001,109,649945,4892,104,664960,699 One year operating, debt & capital3,113,9002,597,6003,433,5002,558,4852,616,6394,001,7642,869,697 Page 10 Table XI CIP 2019-2023 LIQUOR FUND Funding Sources and Expenditure Projections 20172018201820192020202120222023 609ActualBudgetRevisedBudgetProjectionProjectionProjectionProjection Funding Sources Liquor Sales (3% Growth)$5,519,933$5,853,000$5,852,900$6,220,010$6,531,000$6,531,000$6,857,600$6,857,600 Miscellaneous Income2,529------- Total Funding Sources$5,522,462$5,853,000$5,852,900$6,220,010$6,531,000$6,531,000$6,857,600$6,857,600 Expenditures Non-Capital Expenditures Cost of Sales (24% Gross Profit Target)$4,046,643$4,333,100$4,333,100$4,609,168$4,963,600$4,963,600$5,211,800$5,211,800 Operating Expenses 1,043,9741,201,2101,188,3001,212,0981,236,3001,236,3001,261,0001,261,000 Transfers338,500338,500338,500338,500338,500338,500338,500338,500 Capital Outlay-Other Subtotal Non-capital Expenditures$5,429,117$5,872,810$5,859,900$6,159,766$6,538,400$6,538,400$6,811,300$6,811,300 Capital Expenditures Fridley Market - Condensor & Compressor$-$18,000$-$18,000$-$-$-$- Moore Lake - HVAC-38,000------ Subtotal Capital Expenditures$-$56,000$-$18,000$-$-$-$- Total Expenditures$5,429,117$5,928,810$5,859,900$6,177,766$6,538,400$6,538,400$6,811,300$6,811,300 Surplus (deficiency) of funding sources over (under) expenditures$93,345$(19,810)$(7,000)$60,244$(7,400)$(7,400)$46,300$46,300 Estimated Beginning Cash Reserve169,069365,673365,673358,673418,917411,517404,117450,417 Estimated Ending Cash Reserve$365,673$313,159$358,673$418,917$411,517$404,117$450,417$496,717 Page 11 thru 12,00012,000 12,00012,000 12,00012,000 12,00012,000 Page 12 thru 250,000250,000 250,000250,000 250,000250,000 250,000250,000 Page 13 thru 40,00040,000 40,00040,000 40,00040,000 40,00040,000 Page 14 thru 150,000150,000 150,000150,000 150,000150,000 150,000150,000 Page 15 thru 600,000600,000 600,000600,000 420,000420,000 110,000110,000 70,00070,000 600,000600,000 Page 16 thru 910,000910,000 910,000910,000 910,000910,000 910,000910,000 Page 17 thru 75,00020,00020,00025,00025,000165,000 75,00020,00020,00025,00025,000165,000 75,00020,00020,00025,00025,000165,000 75,00020,00020,00025,00025,000165,000 Page 18 thru 30,00030,000 30,00030,00030,00030,00030,000150,000 30,00030,00030,00060,00030,000180,000 30,00030,00030,00060,00030,000180,000 30,00030,00030,00060,00030,000180,000 Page 19 thru 100,000100,000 100,000100,000 50,00050,000 50,00050,000 100,000100,000 Page 20 thru 270,000273,000275,000275,000280,0001,373,000 270,000273,000275,000275,000280,0001,373,000 270,000273,000275,000275,000280,0001,373,000 270,000273,000275,000275,000280,0001,373,000 Page 21 thru 300,000100,000100,000100,000100,000700,000 300,000100,000100,000100,000100,000700,000 300,000100,000100,000100,000100,000700,000 300,000100,000100,000100,000100,000700,000 Page 22 thru 15,00015,00015,00045,000 15,00015,00015,00045,000 15,00015,00015,00045,000 15,00015,00015,00045,000 Page 23 thru 750,000750,000 750,000750,000 170,000170,000 580,000580,000 750,000750,000 580,000580,000 580,000580,000 Page 24 thru 750,000750,000 750,000750,000 750,000750,000 750,000750,000 Page 25 thru 930,000930,000 930,000930,000 300,000300,000 630,000630,000 930,000930,000 Page 26 thru 700,000700,000 700,000700,000 515,000515,000 130,000130,000 55,00055,000 700,000700,000 Page 27 thru 580,000580,000 580,000580,000 580,000580,000 580,000580,000 Page 28 thru 300,000300,000 300,000300,000 50,00050,000 150,000150,000 100,000100,000 300,000300,000 Page 29 thru 5,00010,00015,000 5,00010,00015,000 5,00010,00015,000 5,00010,00015,000 Page 30 thru 120,000150,000150,000150,000150,000720,000 120,000150,000150,000150,000150,000720,000 120,000150,000150,000150,000150,000720,000 120,000150,000150,000150,000150,000720,000 Page 31 thru 200,00050,000250,000 200,00050,000250,000 200,00050,000250,000 200,00050,000250,000 Page 32 thru 175,000175,000 175,000175,000 175,000175,000 175,000175,000 Page 33 thru 75,00075,000 75,00075,000 75,00075,000 75,00075,000 Page 34 thru 64,00035,00035,00035,00035,000204,000 64,00035,00035,00035,00035,000204,000 64,00035,00035,00035,00035,000204,000 64,00035,00035,00035,00035,000204,000 Page 35 thru 12,00012,00012,00012,00015,00063,000 12,00012,00012,00012,00015,00063,000 12,00012,00012,00012,00015,00063,000 12,00012,00012,00012,00015,00063,000 Page 36 thru 90,000200,000290,000 90,000200,000290,000 90,000200,000290,000 90,000200,000290,000 Page 37 thru 122,000144,000144,000144,000144,000698,000 122,000144,000144,000144,000144,000698,000 122,000144,000144,000144,000144,000698,000 122,000144,000144,000144,000144,000698,000 Page 38 thru 20,00010,00010,00010,00010,00060,000 20,00010,00010,00010,00010,00060,000 20,00010,00010,00010,00010,00060,000 20,00010,00010,00010,00010,00060,000 Page 39 thru 110,000110,000 110,000110,000 110,000110,000 110,000110,000 Page 40 thru 9,0009,000 9,0009,000 9,0009,000 9,0009,000 Page 41 thru 10,00010,000 10,00010,000 10,00010,000 10,00010,000 Page 42 thru 2,0002,000 2,0002,000 2,0002,000 2,0002,000 Page 43 thru 25,00025,000 25,00025,000 25,00025,000 25,00025,000 Page 44 thru 30,00030,000 30,00030,000 30,00030,000 30,00030,000 Page 45 thru 250,000250,000 250,000250,000 250,000250,000 250,000250,000 Page 46 thru 77,00077,000 77,00077,000 77,00077,000 77,00077,000 Page 47 thru 30,00030,000 30,00030,000 30,00030,000 30,00030,000 Page 48 thru 127,000127,000127,000127,000127,000635,000 127,000127,000127,000127,000127,000635,000 127,000127,000127,000127,000127,000635,000 127,000127,000127,000127,000127,000635,000 Page 49 thru 30,00030,000 30,00030,000 30,00030,000 30,00030,000 Page 50 thru 67,70067,700 67,70067,700 42,50042,500 25,20025,200 67,70067,700 31,00031,00031,00031,000124,000 31,00031,00031,00031,000124,000 Page 51 thru 25,00025,000 25,00025,000 25,00025,000 25,00025,000 Page 52 thru 30,00030,00030,00090,000 30,00030,00030,00090,000 30,00030,00030,00090,000 30,00030,00030,00090,000 Page 53 thru 135,000135,000270,000 135,000135,000270,000 135,000135,000270,000 135,000135,000270,000 Page 54 thru 40,00040,000 40,00040,000 40,00040,000 40,00040,000 Page 55 thru 70,00070,000 70,00070,000 70,00070,000 70,00070,000 Page 56 thru 10,00010,000 10,00010,000 10,00010,000 10,00010,000 Page 57 thru 38,00038,000 38,00038,000 38,00038,000 38,00038,000 Page 58 thru 40,00040,000 40,00040,000 40,00040,000 40,00040,000 Page 59 thru 35,00035,000 35,00035,000 35,00035,000 35,00035,000 Page 60 thru 115,000115,000 115,000115,000 115,000115,000 115,000115,000 Page 61 thru 200,000200,000 200,000200,000 200,000200,000 200,000200,000 Page 62 thru 25,00025,000 25,00025,000 25,00025,000 25,00025,000 Page 63 thru 25,00025,000 25,00025,000 25,00025,000 25,00025,000 Page 64 thru 150,000150,000 150,000150,000 150,000150,000 150,000150,000 Page 65 thru 10,00010,000 10,00010,000 10,00010,000 10,00010,000 Page 66 thru 18,00018,000 18,00018,000 18,00018,000 18,00018,000 Page 67 thru 34,00034,000 34,00034,000 34,00034,000 34,00034,000 Page 68 thru 230,000230,000 230,000230,000 230,000230,000 230,000230,000 Page 69 thru 200,000200,000 200,000200,000 200,000200,000 200,000200,000 Page 70 thru 25,00025,000 25,00025,000 25,00025,000 25,00025,000 Page 71 thru 25,00025,000 25,00025,000 25,00025,000 25,00025,000 Page 72 thru 12,00012,000 12,00012,000 1,0001,000 11,00011,000 12,00012,000 Page 73 thru 10,00010,000 10,00010,000 10,00010,000 10,00010,000 Page 74 thru 40,00040,000 40,00040,000 40,00040,000 40,00040,000 Page 75 thru 45,00045,000 45,00045,000 45,00045,000 45,00045,000 Page 76 thru 10,00010,000 10,00010,000 10,00010,000 10,00010,000 Page 77 thru 50,00050,000 50,00050,000 50,00050,000 50,00050,000 Page 78 thru 45,00045,000 45,00045,000 45,00045,000 45,00045,000 Page 79 thru 10,00010,000 10,00010,000 1,0001,000 9,0009,000 10,00010,000 Page 80 thru 50,00050,000 50,00050,000 50,00050,000 50,00050,000 Page 81 thru 7,0007,000 7,0007,000 7,0007,000 7,0007,000 Page 82 thru 230,000230,000 230,000230,000 230,000230,000 230,000230,000 Page 83 thru 200,000200,000 200,000200,000 200,000200,000 200,000200,000 Page 84 thru 10,00010,000 10,00010,000 10,00010,000 10,00010,000 Page 85 thru 30,00030,000 30,00030,000 30,00030,000 30,00030,000 Page 86 thru 240,000240,000 240,000240,000 240,000240,000 240,000240,000 Page 87 thru 3,300,000500,0003,800,000 3,300,000500,0003,800,000 3,300,000500,0003,800,000 3,300,000500,0003,800,000 Page 88 thru 540,000300,000500,000500,000500,0002,340,000 540,000300,000500,000500,000500,0002,340,000 540,000300,000500,000500,000500,0002,340,000 540,000300,000500,000500,000500,0002,340,000 Page 89 thru 10,00010,00010,00030,00010,00070,000 10,00010,00010,00030,00010,00070,000 10,00010,00010,00030,00010,00070,000 10,00010,00010,00030,00010,00070,000 Page 90 thru 20,00020,00020,00020,00020,000100,000 20,00020,00020,00020,00020,000100,000 20,00020,00020,00020,00020,000100,000 20,00020,00020,00020,00020,000100,000 Page 91 thru 20,00040,00020,00040,00020,000140,000 20,00040,00020,00040,00020,000140,000 20,00040,00020,00040,00020,000140,000 20,00040,00020,00040,00020,000140,000 Page 92 thru 500,000500,0001,000,000 500,000500,0001,000,000 500,000500,0001,000,000 500,000500,0001,000,000 Page 93 thru 400,000200,000210,000810,000 400,000200,000210,000810,000 400,000200,000210,000810,000 400,000200,000210,000810,000 Page 94 thru 35,00040,00075,000 35,00040,00075,000 35,00040,00075,000 35,00040,00075,000 Page 95 thru 40,00040,000 40,00040,000 40,00040,000 40,00040,000 Page 96 thru 100,000100,000 100,000100,000 100,000100,000 100,000100,000 Page 97 thru 40,00040,000 40,00040,000 40,00040,000 40,00040,000 Page 98 thru 105,00050,00050,00050,00050,000305,000 105,00050,00050,00050,00050,000305,000 105,00050,00050,00050,00050,000305,000 105,00050,00050,00050,00050,000305,000 Page 99 thru 270,000520,000550,0001,340,000 270,000520,000550,0001,340,000 270,000520,000550,0001,340,000 270,000520,000550,0001,340,000 Page 100 thru 90,00095,00095,000280,000 90,00095,00095,000280,000 95,00095,000 90,00095,000185,000 90,00095,00095,000280,000 Page 101 thru 310,00040,000350,000 310,00040,000350,000 310,00040,000350,000 310,00040,000350,000 Page 102 thru 35,00035,000 35,00035,000 35,00035,000 35,00035,000 Page 103 thru 200,000100,000300,000600,000 200,000100,000300,000600,000 200,000100,000300,000600,000 200,000100,000300,000600,000 Page 104 thru 100,000100,000 100,000100,000 100,000100,000 100,000100,000 Page 105 thru 230,000230,000 230,000230,000 230,000230,000 230,000230,000 Page 106 thru 120,00065,00065,00065,00065,000380,000 120,00065,00065,00065,00065,000380,000 120,00065,00065,00065,00065,000380,000 120,00065,00065,00065,00065,000380,000 Page 107 thru 220,000100,000100,000100,000100,000620,000 220,000100,000100,000100,000100,000620,000 220,000100,000100,000100,000100,000620,000 220,000100,000100,000100,000100,000620,000 Page 108 thru 20,00020,00020,00025,00025,000110,000 20,00020,00020,00025,00025,000110,000 20,00020,00020,00025,00025,000110,000 20,00020,00020,00025,00025,000110,000 Page 109 thru 130,00080,000100,00060,000100,000470,000 130,00080,000100,00060,000100,000470,000 130,00080,000100,00060,000100,000470,000 130,00080,000100,00060,000100,000470,000 Page 110 thru 35,00035,000 35,00035,000 35,00035,000 35,00035,000 Page 111 thru 48,00030,00030,00030,00030,000168,000 48,00030,00030,00030,00030,000168,000 48,00030,00030,00030,00030,000168,000 48,00030,00030,00030,00030,000168,000 Page 112 thru 200,000200,000 200,000200,000 200,000200,000 200,000200,000 Page 113 thru 200,000200,000 200,000200,000 200,000200,000 200,000200,000 Page 114 thru 100,000100,000 100,000100,000 100,000100,000 100,000100,000 Page 115 thru 100,000100,000 100,000100,000 100,000100,000 100,000100,000 Page 116 thru 900,000900,000 900,000900,000 900,000900,000 900,000900,000 Page 117 thru 18,00018,000 18,00018,000 18,00018,000 18,00018,000 Page 118