The URL can be used to link to this page

Home My WebLink About040708 City Council Work Session CITY OF PRIOR LAKE NEIGHBORHOOD PARK & NATRUAL SPACE EQUIPMENT REPLACEMENT MATRIX (46 PARKS) 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 TOTAL EXPENDITURE TOTALS $80,000 mo:ooo $120,000 $140,000 $160,000 $180,000 $2U;,000 $230,000 $245,000 $365,000 $255,000 $260,000 $485,000 '1'$395,000 $410,000 $410,000 $385,000 $530,000 $490,000 $450,000 $445,000 $500,000 $475,000 $500,000 $495,000 $530,000 $410,000 $245,000 $9,495,000 Operating Budget Fund $80,000 $100,000 $120,000 $140,000 $160,000 $180,000 $205,000 $230,000 $255,000 $155,000 $165,000 $175,000 $185,000 $195,000 $205,000 $215,000 $225,000 $235,000 $245,000 $255,000 $265,000 $275,000 $285,000 $295,000 $305,000 $315,000 $325,000 $335,000 Park Equipment Fund $210,000 $90,000 $85,000 $300,000 $200,000 $205,000 $195,000 $160,000 $295,000 $245,000 $195,000 $180,000 $225,000 $190,000 $205,000 $190,000 $215,000 $325,000 $90,000 =:QUIPMENT FUND EXPENDITURES $0 $0 $0 $0 $0 $0 $0 $0 $210,000 $90,000 $85,000 $300,000 $200,000 $205,000 $195,000 $160,000 $295,000 $245,000 $195,000 $180,000 $225,000 $190,000 $205,000 $190,000 $215,000 $325,000 $90,000 REVENUE STREAM: Equipment Fund Balance (1/1/09) $100,000 $104,000 $208,160 $316,486 $429,146 $546,312 $668,164 $794,891 $926,686 $853,754 $902,904 $964,020 $817,581 $770,284 $721,096 $664,939 $687,337 $559,830 $482,224 $456,513 $449,773 $402,764 $393,875 $374,630 $374,615 $354,599 $228,783 Fund Balance Conbibution $0 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 Interest Earnings (4%) $4,000 $4,160 $8,326 $12,659 $17,166 $21,852 $26,727 $31,796 $37,067 $34,150 $36,116 $38,561 $32,703 $30,811 $28,844 $27,398 $27,493 $22,393 $19,289 $18,261 $17,991 $16,111 $15,755 $14,985 $14,985 $14,184 $9,151 Annual Equipment Levy $0 $0 $0 $0 $0 $0 $0 $0 $100,000 $105,000 $110,000 $115,000 $120,000 $125,000 $130,000 $135,000 $140,000 $145,000 $150,000 $155,000 $160,000 $165,000 $170,000 $175,000 $180,000 $185,000 $190,000 REVENUE TOTALS... $104,000 $208,160 $316,486 $429,146 $546,312 $668,164 $794,891 $926,686 $1,063,754 $992,904 $1,049,020 $1,117,581 $970,284 $926,096 $879,939 $847,337 $854,830 $727,224 $651,513 $629,773 $627,764 $583,875 $579,630 $564,615 $569,599 $553,783 $427,935 CUMULATIVE FUND BALANCE... $104,000 $208,160 $316,486 $429,146 $546,312 $668,164 $794,891 $926,686 $853,754 $902,904 $964,020 $817,581 1$770,284 $721,096 $684,939 $687,337 $559,830 $482,224 $456,513 $449,773 $402,764 $393,875 $374,630 $374,615 $354,599 $228,783 $337,935 NET LEVY INCREASE $20,000 $20,000 $20,000 $20,000 $20,000 $25,000 ~~;,UOO $25,000 $0 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 ,FUND BALANCE CONTRIBUTION $0 $100,000 $100.000 $100.000 $100,000 $100,000 $100.000 $100.000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 FIGURE 1 PARK EQUIPMENT MATRIX Years Athletic Field Equip BldgfFaclllty Improvements Courts ~nclosuresfKiosk Park Amenities Park Signage Parking Lots PiersfBoardwalkfSllpsfRinks Play Structures Rinks SheltersfBuildingsfTowers TrailsfSldewalks Totals 2008 $9.064 $58.020 $0 $0 $11.486 $0 $0 $0 $0 $0 $0 $0 2009 $37.556 $55.962 $0 $4.084 $12.695 $0 $0 $0 $0 $0 $0 $0 2010 $27.602 $15,271 $0 $5.409 $27,716 $0 $0 $0 $0 $0 $0 $44.659 2011 $0 $55.330 $0 $14.238 $13.468 $0 $0 $0 $0 $0 $28.138 $25.685 2012 $126.175 $10,897 $0 $0 $2,319 $0 $0 $0 $0 $0 $0 $25.039 2013 $63.046 $27,195 $5.078 $8.537 $34.319 $0 $0 $0 $0 $0 $0 $48.230 2014 I 2015 I 2016 $38.495 $43.324 $6.002 $68.602 I $8,2861 $24,204 $0 I $9.549 I $52.411 $676 I $0 I $0 $13.8191 $130.7671 $82.963 $01 $01 $0 $39.9431 $0 I $0 $0 I $22.802 I $0 $01 $01 $0 $01 $01 $0 $30.7471 $1.330 I $913 $3.8591 $13.1821 $78.446 2017 $7,045 $34.303 $18.488 $18,082 $0 $0 $0 $0 $0 $0 $288.497 PARK REPLACEMENT MATRIX ANNUAL BREAKDOWN 2018 $0 $52,878 $24.259 $12.687 $0 $28.734 $0 $0 $0 $0 $0 $0 $138,934 2019 $31.189 $12.083 $133,772 $6.131 $13.040 $0 $0 $0 $64.159 $0 $0 $0 2020 $140.480 $26.912 $4.990 $17,329 $118.819 $0 $0 $0 $132.168 $0 $0 $46,337 2021 $44.803 $132.669 $11.875 $27.680 $24.516 $0 $0 $0 $136.133 $0 $0 $18.620 2022 $28.140 $21.773 $8.408 $6.699 $9.260 $0 $0 $9.192 $140.217 $0 $0 $189,898 2023 $105.590 $17.090 $20.481 $10.350 $11.140 $0 $0 $0 $144.424 $0 $2.407 $98.864 2024 $28.793 $15.537 $16.509 $6.363 $33.678 $0 $22,214 $17,851 $74.378 $0 $165.285 $5.527 2025 $58.768 $41.250 I $5,201 I $21,025 I $27.297 I $0 I $0 I $40.858 I $306.438 I $0 I $11.917 $19,741 2026 $28.530 $95,610 $8,512 $53,219 $56.523 $0 $39.308 $0 $157.816 $0 $52,605 $0 2027 $137.196 $47.275 $5.518 $0 $3.829 $0 $0 $108.367 $0 $0 $45.153 $104.845 2028 $16.371 $18.789 $10.040 $13.301 $47,352 $0 $63,788 $0 $0 $0 $52.274 $223.790 2029 $22.035 $48,909 $6.894 $4.120 $3.744 $0 $0 $0 $344.899 $0 $60.357 $9.466 2030 $193.333 $44.455 $3,550 $5,329 $102.173 $7.434 $0 $47,366 $0 $0 $0 $73.404 2031 $12.400 $165.642 $3,657 $4.371 $72.258 $0 $0 $0 $91.476 $0 $101,640 $46,390 2032 $93,575 $39.049 $10.163 $0 $28.172 $80.000 $8.905 $0 $188,440 $0 $0 $48.615 2033 $0 $0 $3.880 $0 $0 $0 $0 $0 $291.140 $0 $236.794 $0 2034 2035 $139.719 $0 $0 $0 $0 $0 $0 $15,993 $199,916 $0 $55.532 $0 $Q. $Q. $Q. $Q. $Q. $Q. $Q. $Q. $102.957_ $Q. $114.396_ $29, 12~ $78,569 I $110,298 I $120,657 I $136,858 I $164,430 I $186,406 I $196,142 I $229,220 I $244,939 I $366,416 I $257,491 I $260,374 I $487,034 I $396,297 I $413,587 I $410,365 I $386,135 I $532,496 I $492,121 I $452,182 I $445,704 I $500,423 I $477,043 I $497,833 I $496,919 I $531,813 I $411,161 I $246,478 FIGURE 2 MATRIX ANNUAL BREAKDOWN LAKEFRONT - PLAY STRUCTURE - HOCKEY RINKS _ PARKINGfROADWAY II:lgMoRW. .. - PARKING - PLAY STRUCTURE THE PONDS - PLAY STRUCTURE - PARKINGfROADWAY SAND Pi. BEACH -CONCESSION _ PARKINGfROADWAY THOMAS RYAIIl MEMORIAL - BALLFIELD RENOVATION - PLAY STRUCTURE - PARKING WAjii..'$'B~CH - CONCESSION IOTAL ANNUAL COSTS 2019 Referendum 2029 Referendum 2008 2009 $0 2010 $0 LakefrontfWatzlslSandPt $3.1 Million MemorialfPondslRyan $2.3 Million $0 2011 $0 2012 $0 CITY OF PRIOR LAKE COMMUNITY PARK REPLACEMENT COSTS (7 PARKS) 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 TOTAL $0 $0 $215,000 $375,000 $875,000 $85,000 $255,000 $240,000 $720,000 $585,000 $145,000 $465,000 $230,000 $540,000 $700,000 $0 $0 $0 $0 $215,000 $1.070.000 $0 $700,000 $240,000 $950.000 $630,000 $0 $0 $230,000 $0 $1.415,000 $0 $0 $0 $215,000 $375,000 $875,000 $85,000 $255,000 $240,000 $720,000 $585,000 $145,000 $485,000 $230,000 $540,000 ~ $0 $0 $5,450.00~ FIGURE 3 COMMUNITY PARK REPLACEMENT COSTS CITY MAINTAINED OR MANAGED PARK/NATURAL SPACE ACRES 0.050 - 0.045 0.040 - 0.035 - .. c ~ 0.030- III ~ 0.025- - III ~ 0.020 (,,) <( 0.015 0.010 0.005 0.000 Savage Apple Valley Eagan Lakeville Burnsville Shakopee Prior Lake EXPENDITURE TOTALS $245,000 $365,000 Operating Budget Fund $255,000 $155,000 Park Equipment Fund $210,000 EQUIPMENT FUND EXPENDITURES $0 $210,000 REVENUE STREAM: Equipment Fund Balance (1/1/09) $794,891 $926,686 Fund Balance Contribution $100,000 Interest Earnings (4%) $31,796 $37,067 $34,150 Annual Equipment Levy $0 $100,000 $105,000 REVENUE TOTALS... $926,686 $1,063,754 $992,904 CUMULATIVE FUND BALANCE... $926,686 $853,754 $902,904 NET LEVY INCREASE