The URL can be used to link to this page

Home My WebLink About3.D. Park Asset Internal Service Fund 3. I). CITY OF SHAKOPEE Memorandum TO: Mayor & City Council Mark McNeill, City Administrator FROM: Bruce Loney, Public Works Director SUBJECT: Park Asset Internal Service Fund DATE: April 27, 2010 INTRODUCTION: Public Works staff has been working with the Finance Director to better identify and define how the Park Asset Fund that was set up in 2008 can be utilized for the replacement of park assets. Staff would like to discuss the progress of our meetings with the Council on how the Park Asset Fund can be utilized. BACKGROUND: As mentioned previously, the Park Asset Fund has been set up in 2008 and the amount of revenue from the 2010 Park Maintenance Division budget of the Public Works Department is $171,680. The current balance, as of January 1, 2010, is $195,900 and is projected to be $367,580.00 by the end ofthis year. Staff has met with Gregg V oxland to better identify how the Park Asset Fund can be utilized. From our discussions, it was concluded that major repairs of buildings and overlays of trails can be included as expenditure in the Park Asset Fund as well as total replacement of park assets. Within the park system there are assets such as buildings, shelters, pavement/concrete for trails, parking lots, sidewalks, park roads, playground equipment sets, fencing, lighting systems, tennis courts, hockey rinks and irrigation systems. If Council wants to include major repairs versus just replacement, major repairs needs to be defined. Examples could be more than a dollar amount, more than half the value, more than half of the physical item or a combination of those criteria. Also, if a vendor does the work, the whole cost is paid by the Park Asset Fund. If staff provides the labor, does the Park Asset Fund pay for just the materials or labor also. On the one hand, this pulls more money out of the fund and it is just cycling dollars around between the Park Asset Fund and the General Fund since the General Fund provides all the funding for the Park Asset Fund. On the other hand, excluding labor wouldn't show the true cost of the project. Attached to this memo is a list of all park assets that are included in the Park Asset Internal Service Fund. Staff has taken this information and including overlaying trails and major repairs of buildings to see what items would be done in the next five years. Staffhas come up with a list of projects that could be done in the next five years and with funds coming out of the Park Asset Fund. The major projects that would be included in the next five years would be a Lions Park tennis court and Schleper Field lights. From the attached projected fund level and continuing the park asset funding in park maintenance at $171,680 per year, the balance in five years would be a positive $515,880. Staff believes that the Park Asset Fund should be included in the Capital Improvement Plan and a list of projects should be reviewed at that time and included in the overall budget. For 2011, $60,000 would be utilized to overlay trails, replace a fence and repair Lions Park Shelter No.2. In the past these items would be included in the General Fund Park Maintenance budget. This would be a reduction of the Park Maintenance budget of $60,000.00, as these projects would come out of the Park Asset Fund versus having to be budgeted in the Park Maintenance budget. Another item staff had considered to assist in the Park Asset Fund is to have any under-spend in the Park Maintenance budget for the year be placed in the Park Asset Fund, if the General Fund balance objectives have been met. These funds for 2009 would be about $80,000.00 which would help build the fund balance. The Finance Director does not support such a specific approach to under-spent but instead supports that Council should decide what to do with the total General Fund under-spend through the budget process. ALTERNATIVES: 1. Discuss the proposed use of the Park Asset Fund, with the definitions as presented, and provide staff direction on the use of the Park Asset Fund. 2. Provide direction to staff on any under-spend funds that could be directed into the Park Asset Fund. 3. Table for additional information. RECOMMENDATION: Staff would recommend discussion on the use of the Park Asset Fund, with its definitions, and provide staff direction on this process and also any future under-spend that can be directed into the Park Asset Fund. ~ne~ Public Works Director ENGR/2010-PROlECTS/2010-COUNCILIPARK-ASSET-FUND Park Asset Fund Projected Fund Levels 2011-2015 Capital Improvement Program City of Shakopee, Minnesota REVENUES: 2010 2011 2012 2013 2014 2015 Park Asset charges $ 171,680 $ 171,680 $ 171,680 $ 171,680 $ 171,680 $ 171,680 Interest Total Revenue 171,680 171,680 171,680 171,680 171,680 171,680 EXPENDITURES: Expenditures per List-PARKS 60,000 55,000 85,000 385,000 125,000 Total Expenditures - 60,000 55,000 85,000 385,000 125,000 Excess (Deficiency) 171,680 111,680 116,680 86,680 (213,320) 46,680 Fund Balance January 1* 195,800 367,480 479,160 595,840 682,520 469,200 Balance 12/31* $ 367,480 $ 479,160 $ 595,840 $ 682,520 $ 469,200 $ 515,880 ~ 2011 - 2015 Park Asset Proposed Project List 2011 2012 Lions shelter #2 $15,000 Tahpah shelter $20,000 Trail overlays $30,000 Trail overlays $20,000 Fence replacement $15,000 Fence replacement $15,000 $60,000 $55,000 2013 2014 Log Cabin $50,000 Lions Tennis court $350,00 Trail Overlays $20,000 Trail overlays $20,000 Fence replacement $15,000 Fence replacement $15,000 $85,000 $385,000 2015 Lights Schleper field $90,000 Trail overlays $20,000 Fence replacement $15,000 $125,000 R55120001 CITY OF SHAKOPEE 4/21/2010 Fixed Asset Master List Sort by Asset Number with Grand Total Page - 12/31/2009 Asset Date Depr Accumulated Net Book YTD Depr !i!!!!!!w: Location ~ Description Acc Cis Acauired Life Mos Meth Oriainal Cost Depreciation ~ Expense Full Depr 1364 Hiawatha B Ball court BASKETBALL COURT - HIAWATHA 60 9/11/2006 240 SL 10,250.00 (512.15) 9,737.65 512.15 5/29/2028 1365 Holmes B Ball court BASKETBALLCOURT-HOLMES 60 9/11/2006 240 SL 11,600.00 (579.60) 11,020.40 579.60 5/29/2028 1421 Tahpah Bleachers BLEACHER SEATING - TP 30 12/31/2006 360 SL 44,500.00 (1,482.39) 43,017.61 1,482.39 7/27/2038 86 lions Building RESTROOM FACILITIES - LIONS 20 1/1/1975 360 SL 15,000.00 (15,000.00) - 7/27/2004 145 Memorial Building COMFORT STATION - MEM PRK 20 1/1/1975 360 SL 41,472.00 (41,472.00) 7/27/2004 152 Tahpah Building GRANDSTAND-TAHPAH 20 1/1/1966 360 SL 50,000.00 (38,333.25) 11,666.75 1,665.37 7/26/2015 301 Scenic Building SHEL TERlWARMING HOUSE-SH 20 12/31/1991 360 SL 42,004.67 (25,203.31) 16,601.56 1,399.17 7/26/2021 672 Tahpah Building JOE SCHLEPER STADIUM 99 20 12/15/1999 360 SL 176,147.10 (58,717.07) 117,430.03 5,867.46 7/10/2029 651 Tahpah Building JOE SCHLEPER STADIUM 00/01 20 12/31/2001 360 SL 289,663.02 (77,247.01) 212,416.01 9,649.27 7/27/2031 1072 Soccer Building SOCCER COMPLEX - BUILDINGS 04 20 12/31/2004 360 SL 14,644.46 (2,440.53) 12,203.93 487.84 7/27/2034 1146 Soccer Building SOCCER COMPLEX - BUILDINGS 05 20 12/31/2005 360 SL 3,411.60 (454.91) 2,956.69 113.65 7/27/2035 1223 Huber Building PAVILION BLDG - HUBER 20 12/31/2006 360 SL 311,433.00 (31,148.98) 260,284.02 10,373.52 7/26/2036 1210 Soccer Building SOCCER COMPLEX - BLDGS - 06 20 12/31/2006 360 SL 161,678.40 (16,190.80) 145,667.60 5,392.01 7/26/2036 1302 Huber Building PAVILION BLDG - 07 20 12/31/2007 360 SL 299,767.96 (19,997.30) 279,770.66 9,964.97 7/26/2037 1310 Soccer Building SOCCER COMPLEX BLDGS - 07 20 12/31/2007 360 SL 523,688.17 (34,934.85) 488,753.32 17,443.53 7/26/2037 267 Youth Building YOUTH BUILDING 20 711/1989 600 SL 120,000.00 (48,000.67) 71,999.33 2,396.44 10/12/2038 268 Youth Building YOUTH BLDG - REMODEL 20 10/10/2001 600 SL 72,511.88 (11,602.20) 60,909.68 1,449.26 1/21/2051 87 Tahpah Fence FENCE & BACKSTOPS - TP 30 1/1/1975 300 SL 5,000.00 (5,000.00) - 8/23/1999 274 Riverview Fence FENCE - OUTFIELD 6 FT CHAIN-RV 30 1/1/1990 240 SL 10,670.00 (10,194.05) 675.95 675.94 9/18/2009 1256 Country SW Fence ORNAMENTAL FENCE - 264 LF 30 12/31/2006 300 SL 19,460.00 (2,335.60) 17,124.20 777.69 6/22/2031 1216 Tahpah Fence FENCING/BACKSTOPS(1-4) - 06 30 12/31/2006 300 SL 47,211.00 (5,666.77) 41,544.23 1,667.20 8/22/2031 1314 Tahpah Fence FENCING - TP 07 30 12/31/2007 300 SL 6,656.00 (706.91) 6,147.09 353.97 8/21/2032 1319 Tahpah Fence FENCING - PLAYGROUND TP 30 12/31/2007 300 SL 21,060.00 (1,687.41) 19,392.59 842.55 8/21/2032 1391 Tahpah Fence BACKSTOP & FENCING - TP 30 12/12/2008 300 SL 15,530.00 (620.79) 14,909.21 620.79 8/3/2033 1412 Westminster Fence FENCING W/2 BACKSTOPS 30 12/31/2008 300 SL 72,126.00 (2,883.14) 69,242.86 2,883.14 8/22/2033 1464 Soccer Fence FENCING - SOCCER COMPLEX 30 9/9/2009 300 SL 20,743.59 (260.45) 20,483.14 829.74 5/1/2034 1009 Soccer Irrigation SOCCER COMPLEX -IRRIGATION SY 30 12/31/2003 160 SL 103,912.00 (41,573.20) 62,338.60 6,922.32 10/13/2018 1071 Soccer Irrigation SOCCER COMPLEX -IRRIGATION 04 30 12/31/2004 160 SL 1,560.04 (520.02) 1,040.02 103.94 10/14/2019 794 Muenchow Irrigation SPRINKLER SYS - MUENCHOW FLD 30 12/31/2001 240 SL 16,208.00 (6,483.20) 9,724.80 809.85 9/17/2021 1214 Tahpah Irrigation IRRIGATION - TP -06 30 12/31/2006 160 SL 83,485.00 (16,700.04) 66,784.96 5,561.60 10/13/2021 1311 Soccer Irrigation SOCCER COMPLEX -IRRIGATION 30 12/31/2007 180 SL 9,645.00 (1,286.82) 8,358.18 642.53 10/13/2022 1317 Tahpah Irrigation IRRIGATION - TP 07 30 12/31/2007 180 SL 16,131.91 (2,152.30) 13,979.61 1,074.68 10/13/2022 1403 Riverview Irrigation IRRIGATION SYSTEM W/BLDG 30 12/31/2008 180 SL 28,414.94 (1,693.29) 26,521.65 1,893.29 10/14/2023 1411 Westminster Irrigation IRRIGATION - WESTMINSTER 30 12/31/2008 180 SL 21,670.00 (1,443.88) 20,226.12 1,443.88 10/14/2023 13 Tahpah Lighting TOWER RINK LIGHTS 30 1/1/1975 300 Sl 6,000.00 (6,000.00) - 8/23/1999 151 Tahpah Lighting LIGHTS - BASEBALL FLD - TP 30 1/1/1986 360 Sl 27,000.00 (20,699.96) 6,300.04 899.30 7/28/2015 1247 Country NW Lighting LIGHT FIXTURES/POLES 30 12/31/2006 360 Sl 19,857.00 (1,986.07) 17,870.93 661.42 7/26/2036 1251 Country NE Lighting LIGHT FIXTURES/POLES 30 12/31/2006 360 SL 19,857.00 (1,986.07) 17,870.93 661.42 7/26/2036 1255 Country SW Lighting LIGHT FIXTURESIPOLES 30 12/31/2006 360 SL 6,619.00 (662.02) 5,956.98 220.47 7/26/2036 1248 Country NW Mise WATER FOUNTAIN 30 12/31/2006 240 SL 7,060.00 (1,059.24) 6,000.76 352.76 9/17/2026 1252 Country NE Mise WATER FOUNTAIN 30 12/31/2006 240 SL 7,060.00 (1,059.24) 6,000.76 352.76 9/17/2026 1309 Huber Misc VINE TRELLIS - HUBER 60 12/31/2007 240 SL 15,000.00 (1,501.03) 13,498.97 749.49 9/17/2027 1249 Country NW Mise ARBOR W STONE PLANTERS 20 12/31/2006 360 SL 73,700.00 (7,371.34) 66,328.66 2,454.87 7/26/2036 1221 Huber Mise ENTRY PYLONS/COLONADES -HUBER 60 12/31/2006 360 SL 62,567.00 (6,257.83) 56,309.17 2,084.04 7/26/2036 1303 Huber Mise ENTRY PYLONS/COLONADES - 07 60 12/31/2007 360 SL 60,068.18 (4,007.10) 56,061.08 2,000.81 7/26/2037 842 lions Parking lot PARKING LOT - LIONS PARK 60 12/31/2002 360 SL 311,270.65 (72,635.18) 238,635.47 10,368.05 7/26/2032 876 Soccer Parking lot SOCCER COMPLEX - PRKG LOT 60 12/31/2002 360 SL 10,776.49 (2,514.70) 8,261.79 358.95 7/26/2032 880 Tahpah Parking lot PARKING LOT - TAHPAH 60 12/31/2002 360 SL 373,665.98 (87,195.16) 286,470.82 12,446.36 7/26/2032 1008 Soccer Parking lot SOCCER COMPLEX - PRKG LOT 60 12/31/2003 360 SL 133,009.00 (26,606.98) 106,402.02 4,430.38 7/26/2033 R55120001 CITY OF SHAKOPEE 4/21/2010 Fixed Asset Master List Sort by Asset Number with Grand Total Page - 12/31/2009 Asset ~ Depr Accumulated Net Book YTD Depr Number Location ~ Description Ace Cis Acauired Life Mos Mn!! Oriainal Cost Depreciation Value Expense Full Depr 965 Tahpah Parking lot PARKING LOT - TAHPAH 03 60 12/31/2003 360 SL 15,923.78 (3,185.37) 12,738.41 530.40 7/26/2033 1076 Tahpah Parking lot PARKING LOT - TAHPAH - 04 60 12/31/2004 360 SL 15,893.57 (2,648.70) 13,244.87 529.45 7/27/2034 1219 Huber Parking lot PARKING LOTS -HUBER PARK 60 12/31/2006 360 SL 144,946.00 (14,497.25) 130,448.75 4,828.01 7/26/2036 1217 Tahpah Parking lot PARKING LOT - TAHPAH - 06 60 12/31/2006 360 SL 634,979.00 (63,509.48) 571,469.52 21,150.51 7/26/2036 1304 Huber Parking lot PARKING LOTS -HUBER PARK 60 12/31/2007 360 SL 77,191.57 (5,149.39) 72,042.18 2,571.17 7/26/2037 1316 Tahpah Parking lot PARKING LOT - TP 07 60 12/31/2007 360 SL 158,424.47 (10,568.38) 147,856.09 5,276.96 7/26/2037 1407 Westminster Parking lot PARKING LOT - WESTMINSTER 60 12/31/2008 360 SL 83,799.00 (2,791.52) 81,007.48 2,791.52 7/27/2038 227 Stans Play equip ALUMACOREPLAYSTR-STANS 30 11/16/1987 240 SL 8,000.00 (8,000.00) 8/3/2007 254 Hiawatha Play equip PLAYGROUND APPARATUS - HIA 30 5/16/1989 240 SL 9,993.00 (9,993.00) 499.31 1/31/2009 253 Holmes Play equip PLAYGROUND APPARATUS - HOLMES 30 5/16/1989 240 SL 9,930.00 (9,930.00) - 496.16 1/31/2009 273 Emerald Play equip PLA YGRND EQ - EMERALD LANE 30 9/30/1990 240 SL 8,500.00 (8,075.26) 424.74 424.74 6/17/2010 290 Emerald Play equip PLAYSYS - LOKVILLElBENCH - HAU 30 7/1/1991 240 SL 10,540.00 (9,486.57) 1,053.43 526.71 3/18/2011 374 Memorial Play equip PLAYGROUND EQUIPMENT - MEM 30 12/15/1993 240 SL 36,547.74 (29,238.20) 7,309.54 1,826.14 9/1/2013 382 Lions Play equip GOLF POLE HOLE ASSEM- LIONS 30 2/14/1994 240 SL 5,485.82 (4,114.49) 1,371.33 274.12 11/1/2013 387 Scenic Play equip PLAYGROUND EQUIPMENT - SH 30 8/10/1994 240 SL 13,000.00 (9,750.28) 3,249.72 649.59 4/27/2014 1115 Skate Play equip SKATEPARK EQUIPMENT 30 4/12/2005 120 SL 27,115.17 (10,847.55) 16,267.62 2,710.03 2/19/2015 1147 Riverview Play equip SCOREBOARD - RIVERVIEW PARK 30 12/31/2005 120 SL 11,000.00 (4,400.61) 6,599.39 1,099.40 11/9/2015 456 Lions Play equip PLAYGROUND EQUIPMENT - LIONS 30 9/30/1996 240 SL 60,000.00 (38,998.90) 21,001.10 2,997.81 6/1712016 458 Timber Play equip PLAYGROUND EQ - TIMBER TRAILS 30 10/19/1996 240 SL 17,768.00 (11,548.86) 6,219.14 887.75 7/6/2016 492 Meadows Play equip PLAYGROUND EQ - MEADOWS PRK 30 2/26/1997 240 SL 17,584.95 (10,550.98) 7,033.97 878.65 11/13/2016 503 Prairie Play equip PLAYGROUND EQ - PRAIRIE BEND 30 12/9/1997 240 SL 27,667.12 (16,600.29) 11,066.83 1,382.41 8/26/2017 1300 Huber Play equip SOUND SYSTEM - HUBER 30 12/1/2007 120 SL 30,909.85 (6,185.36) 24,724.49 3,088.45 10/9/2017 504 Prairie Play equip PLAYGROUND EQ - PRAIRIE BEND 30 5/27/1998 240 SL 4,693.92 (2,581.73) 2,112.19 234.54 2/11/2018 673 Stans Play equip STANS PARK PLAY EQUIP 30 12/15/1999 240 SL 26,971.53 (13,486.60) 13,484.93 1,347.76 9/1/2019 793 Holmes Play equip PLAYGROUND EQUIP - HOLMES 30 12/31/2001 240 SL 28,297.75 (11,319.10) 16,978.65 1,413.92 9/17/2021 875 Hamlet Play equip PLAYGROUNDEQ-HAMLET 30 12/31/2002 240 SL 36,954.94 { 12,935.48} 24,019.46 1,846.48 9/17/2022 881 Hiawatha Play equip PLAYGROUND EQ - HIAWATHA 30 12/31/2002 240 SL 26,744.87 (9,361.63) 17,383.24 1,336.33 9/17/2022 882 Holmes Play equip PLAYGROUND EQ - HOLMES - 2002 30 12/31/2002 240 SL 8,565.20 (2,998.13) 5,567.07 427.97 9/1712022 962 Hiawatha Play equip PLAYGROUND EQ - HIAWATHA 03 30 12/31/2003 240 SL 10,896.13 (3,269.58) 7,626.55 544.43 9117/2023 961 Pheasant Play equip PLAYGROUND EQ - PHEASANT RUN 30 12/31/2003 240 SL 51,544.97 (15,467.01) 36,077.96 2,575.48 9/17/2023 1145 Greenfield W Play equip PLAYGROUND EQ - GREENFIELD W 30 12/31/2005 240 SL 269,218.45 (53,843.69) 215,374.76 13,451.71 9/1712025 1164 Huber Play equip COMMUNITY PLAYGROUND - HUBER 30 12/31/2005 240 SL 400,000.00 (80,000.00) 320,000.00 19,986.31 9/17/2025 1165 Whispering Play equip PLAYGROUND EQ - WHISPERING OAK 30 12/31/2005 240 SL 44,152.79 (8,830.56) 35,322.23 2,206.13 9/17/2025 1250 Country NW Play equip PLAYGROUND EQUIP 30 12/31/2006 240 SL 47,112.00 (7,068.42) 40,043.58 2,353.99 9/17/2026 1254 Country NE Play equip PLAYGROUND EQUIP 30 12/31/2006 240 SL 53,460.00 (8,020.83) 45,439.17 2,671.17 9/17/2026 1257 Country SW Play equip PLAYGROUND EQUIP 30 12/31/2006 240 SL 38,515.00 (5,778.56) 32,736.44 1,924.43 9/1712026 1212 Savanna Play equip PLAYGROUND EQ - SAVANNAH OAKS 30 12/31/2006 240 SL 39,999.99 (6,O01.37) 33,998.62 1,998.63 9/17/2026 1215 Tahpah Play equip PLAYGROUND EQ - TAHPAH - 06 30 12/31/2006 240 SL 67,351.00 (10,104.96) 57,246.04 3,365.25 9/1712026 1425 Autumn Play equip PLAYGROUND EQUIP - AUTUMN HIL 30 12/31/2008 240 SL 52,502.00 (2,623.30) 49,878.70 2,623.30 9/17/2028 1423 Church Play equip PLAYGROUND EQUIP - CHURCH ADD 30 12/31/2008 240 SL 71,868.00 (3,590.94) 68,277.06 3,590.94 9/17/2028 1424 Glacier Play equip PLAYGROUND EQUIP - GLACIER 30 12/31/2008 240 SL 44,831.00 (2,240.02) 42,590.98 2,240.02 9/17/2028 1406 Westminster Play equip PLAYGROUND EQUIP - WESTMINSTER 30 12/31/2008 240 SL 75,153.00 (3,755.08) 71,397.92 3,755.08 9/17/2028 1465 Westminster Play equip PLAYGROUND INSTALL - WESTMINIS 30 11/1/2009 240 SL 2,651.94 (22.10) 2,629.84 132.60 7/19/2029 1409 Westminster Rink HOCKEY RINK - WESTMINSTER 30 12/31/2008 240 SL 101,665.00 (5,079.77) 96,585.23 5,079.77 9/17/2028 85 Lions Sheller PAVILLlON - LIONS 20 1/1/1975 360 SL 9,950.00 (9,950.00) - 7/27/2004 144 Memorial Shelter PICNIC SHELTER - MEM PRK 20 1/1/1975 360 SL 7,544.00 (7,544.00) - 7/27/2004 146 Memorial Shelter PICNIC SHELTER - MEM PRK 20 111/1975 360 SL 7,544.00 (7,544.00) - 7/27/2004 89 Tahpah Shelter PARKSHELTER-TAHPAH 20 1/1/1975 360 SL 27,289.00 (27,289.00) - 7/27/2004 505 Lions Shelter PAVILLlON (2ND) LIONS PARK 20 1/1/1986 360 SL 18,000.00 (13,799.97) 4,200.03 599.53 7/28/2015 R55120001 CITY OF SHAKOPEE 4/21/2010 Fixed Asset Master List Sort by Asset Number with Grand Total Page - 12/31/2009 i' Asset .Qm. DeDr Accumulated Net Book YTD DeDr Number . Location IxI!! DescriDtion Acc Cis Acauired Life Mos ~ Oriainal Cost DeDreciation ~ EXDense Full DeDr 258 Huber Shelter HUBER PARK OVER-LOOK 20 12/30/1988 360 SL 104,758.05 (73,331.78) 31,426.27 3,489.68 7/26/2018 90 Tahpah Shelter ADDIIRENOV TO SHELTER - TP 20 10/12/1993 360 SL 93,887.60 (50,074.98) 43,812.62 3,127.64 5/8/2023 1167 Whispering Shelter GAZEBO - WHISPERING OAKS 20 12/31/2005 240 SL 31,861.47 (6,372.29) 25,489.18 1,591.98 9/17/2025 787 Hiawatha Shelter HIAWATHA SHELTER 20 12/31/2001 360 SL 88,557.86 (23,616.50) 64,941.36 2,950.04 7/27/2031 1169 Holmes Shelter HOLMES PARK SHELTER 20 12/31/2001 360 SL 44,852.00 (11,961.69) 32,890.31 1,494.08 7/27/2031 963 Hamlet Shelter SHELTER/HEXAGON - SBRDG HAMLET 20 12/31/2003 360 SL 18,039.25 (3,608.56) 14,430.69 600.87 7/26/2033 1253 Country NE Shelter STEEL SHELTER 20 12/31/2006 360 SL 27,150.00 (2,715.50) 24,434.50 904.34 7/26/2036 1222 Huber Shelter PERFORMANCE SHELTER - HUBER 20 12/31/2006 360 SL 240,607.00 (24,065.10) 216,541.90 8,014.38 7/26/2036 1301 Huber Shelter PERFORMANCE SHELTER - 07 20 12/31/2007 360 SL 165,229.05 (11,022.30) 154,206.75 5,503.61 7/26/2037 1422 Church Shelter SHELTER - CHURCH ADD 20 12/31/2008 360 SL 61,221.00 (2,039.40) 59,181.60 2,039.40 7/27/2038 1220 Huber Sidewalk TERRACE SEATING - HUBER 60 12/31/2006 360 SL 185,961.00 (18,599.49) 167,361.51 6,194.17 7/26/2036 1306 Huber Sidewalk TERRACE SEATING - 07 60 12/31/2007 360 SL 69,597.50 (4,642.79) 64,954.71 2,318.22 7/26/2037 1307 Huber Sidewalk CONCRETE SIDEWALK - HUBER 60 12/31/2007 360 SL 58,497.00 (3,902.29) 54,594.71 1,948.48 7/26/2037 1413 Westminster Sidewalk CONCRETE WORK - WESTMINSTER 60 12/31/2008 360 SL 54,853.00 (1,827.27) 53,025.73 1,827.27 7/27/2038 81 Lions T Court TENNIS COURT - LIONS 30 1/1/1975 300 SL 26,210.00 (26,210.00) - 8/23/1999 792 Stans T Court TENNIS COURT - STANS 30 12/31/2001 300 SL 197,146.90 (63,088.72) 134,058.18 7,880.69 8/22/2026 Lions Trail Trail- 4414 feet 60 1/1/1975 240 SL 55,175.00 (97,958.61) (42,783.61) 2,758.75 9/18/1994 Memorial Trail Trail - 6491 feet 60 1/1/1975 240 SL 81,137.50 81,137.50 4,056.88 9/18/1994 Upper Valley Trail Trail- 19356 feet 60 10/12/1993 240 SL 241,950.00 (199,071.08) 42,878.92 12,097.50 6/29/2013 Scenic Trail Trail- 1337 feet 60 8/10/1994 240 SL 16,712.50 (13,049.68) 3,662.82 835.63 4/27/2014 Timber Trail Trail - 61 feet 60 10/19/1996 240 SL 762.50 (510.56) 251.94 38.13 7/6/2016 Meadows Trail Trail- 802 feet 60 2/26/1997 240 SL 10,025.00 (6,531.57) 3,493.43 501.25 11/13/2016 Prairie Trail Trail- 2310 feet 60 5/27/1998 240 SL 28,875.00 (16,988.13) 11,886.88 1,443.75 2/11/2018 Muenchow Trail Trail- 1921 feet 60 12/31/2001 240 SL 24,012.50 (9,745.07) 14,267.43 1,200.63 9/17/2021 Odowd Trail Trail- 3760 feet 60 12/31/2001 240 SL 47,000.00 (19,074.17) 27,925.83 2,350.00 9/17/2021 Stans Trail Trail- 735 feet 60 12/31/2001 240 SL 9,187.50 (3,728.59) 5,458.91 459.38 9/17/2021 Holmes Trail Trail - 1242 feet 60 12/31/2002 240 SL 15,525.00 (5,513.53) 10,011.47 776.25 9/17/2022 Hiawatha Trail Trail - 568 feet 60 12/31/2003 240 SL 7,100.00 (2,161.56) 4,938,44 355.00 9/17/2023 Whispering Trail Trail-1115 feet 60 12/31/2005 240 SL 13,937.50 (2,828.15) 11,109.35 696.88 9/17/2025 Country NE Trail Trail- 2266 feet 60 12/31/2006 240 SL 28,325.00 (4,311.69) 24,013.31 1,416.25 9/17/2026 Country NW Trail Trail- 2128 feet 60 12/31/2006 240 SL 26,600.00 (4,049.11) 22,550.89 1,330.00 9/1712026 Country SW Trail Trail- 841 feet 60 12/31/2006 240 SL 10,512.50 (1,600.24) 8,912.26 525.63 9/17/2026 Greenfield W Trail Trail- 635 feet 60 12/31/2006 240 SL 7,937.50 (1,208.26) 6,729.24 396.88 9/17/2026 1308 Huber Trail Trail - 2089 feet 60 12/31/2007 240 SL 51,617.00 (5,165.23) 46,451.77 2,579.08 9/17/2027 1313 Southbridge Trail S BRDGIDEAN LK TR W/BRDG 4796 feet 60 12/31/2007 240 SL 253,161.11 (25,333,44) 227,827.67 12,649.39 9/17/2027 1318 Tahpah Trail Trail- 4666 feet 60 12/31/2007 240 SL 13,525.97 (1,353.53) 12,172.44 675.84 9/17/2027 Glacier Trail Trail- 449 feet 60 12/31/2008 240 SL 5,612.50 (284.52) 5,327.98 28Q.63 9/1712028 Glacier - RSB Trail Trail- 4919 feet Glacier - Riverside BI 60 12/31/2008 240 SL 61,487.50 (3,117.07) 58,370.43 3,074.38 9/17/2028 Greenfield E Trail Trail-1263 feet 60 12/31/2008 240 SL 15,787.50 (800.34) 14,987.16 789.38 9/1712028 1408 Westminster Trail Trail-1594 feet 60 12/31/2008 240 SL 12,587.00 (628.92) 11,958.08 628.92 9/17/2028 1213 Tahpah Utilities ELECTRICAL - TAHPAH - 06 30 12/31/2006 360 SL 246,906.00 (24,695.10) 222,210.90 8,224.19 7/26/2036 1315 Tahpah Utilities ELECTRICAL - TP 07 30 12/31/2007 360 SL 62,497.31 (4,169.15) 58,328.16 2,081.72 7/26/2037 1404 Huber Utilities ELECTRICAL SERVICE - HUBER 30 11/21/2008 360 SL 415,045.00 (13,825.99) 401,219.01 13,825.99 6/17/2038 1405 Huber Utilities SITE UTILITIES - HUBER 60 12/31/2008 360 SL 39,319.00 ( 1,309.80) 38,009.20 1,309.80 7/27/2038 1410 Westminster Utilities ELECTRICAL SERV - WESTMINSTER 30 12/31/2008 360 SL 36,422.00 (1,213.29) 35,208.71 1,213.29 7/27/2038 1414 Westminster Utilities SITE UTILITIES - WESTMINSTER 60 12/31/2008 360 SL 65,442.00 (2,180.01) 63,261.99 2,180.01 7/27/2038 795 Skate SKATE PARK 30 12/31/2001 120 SL 118,622.06 (94,910.64) 23,711.42 11,855.71 11/9/2011 878 Skate SKATE PARK - 2002 30 12/31/2002 120 SL 2,702.88 (1,892.01) 810.87 270.05 11/8/2012 1415 Westminster METALWRKlPOSTS ETC - WESTMNSTR 30 12/31/2008 240 SL 25,789.00 (1,288.57) 24,500.43 1,288.57 9/17/2028 R55120001 CITY OF SHAKOPEE 4/21/2010 Fixed Asset Master List Sort by Asset Number with Grand Total Page - 12/31/2009 A!!!!. ~ Depr Accumulated Net Book YTD Depr Number Location ~ Description Ace Cis Acquired .bi!!..!'l1!2! ~ Oriainal Cost Depreciation Value Expense Full DeDr Grand Total(s) RE 10,341,789.27 (2,288,421.55) 8,053,367.72 409,338.66 PARK ASSET INTERNAL FUND - ----------------------- Park Asset Internal Fund o Park Asset Established in 2008 • Replacement of Park Assets Minimize Spikes in Budgeting Current Balance is $195,900.00 Annual amount in budget is $171,680.00 Park Asset Internal Fund o Criteria of Replacement • Replacement of assets in Park System Staff Proposes to Add Trail Overlays Major Repairs of Shelters Question is the Definition of a Major Repair (Dollar Value or Half the Asset Value) Park Asset Internal Fund o Another question is when Maintenance Staff does work? Should Park Asset Fund Pay for Labor and Materials or Materials Only? True cost of project includes labor Funds from Park asset fund to general fund may result in budget surplus 2011- 2015 Park Asset Proposed Project List 2011 2012 Lions shelter #2 $15,000 Tahpah shelter $20,000 Trail overlays $30,000 Trail overlays $20,000 Fence replacement $15,000 Fence replacement $15,000 $60,000 $55,000 2013 2014 Log Cabin $50,000 Lions Tennis court $350,00 Trail Overlays $20,000 Trail overlays $20,000 Fence replacement $15,000 Fence replacement $15,000 $85,000 $385,000 2015 m Lights Schleperfield $90,000 Trail overlays $20,000 Fence replacement $15,000 $125,000 i AIL Park Asset Fund Projected Fund Levels 2011 -2015 Capital Improvement Program City of Shakopee, Minnesota REVENUES: 2010 2011 2012 2013 2014 2015 Park Asset charges $ 171,680 $ 171,680 $ 171,680 $ 171,680 $ 171,680 $ 171,680 Interest Total Revenue 171,680 171,680 171,680 171,680 171,680 171,680 EXPENDITURES: Expenditures per List -PARKS 60,000 55,000 85,000 385,000 125,000 Total Expenditures - 60,000 55,000 85,000 385,000 125,000 Excess (Deficiency) 171,680 111,680 116,680 86,680 (213,320) 46,680 Fund Balance January 1* 195,800 367,480 479,160 595,840 682,520 469,200 Balance 12/31* $ 367,480 $ 479,160 $ 595,840 $ 682,520 $ 469,200 $ 515,880 Accumulated Depreciation $ 2,268,600 $ 2,641,590 $ 3,041,590 $ 3,441,590 $ 3,841,590 $ 4,241,590 * Balance equals cash balance per cash flow projection with project carry forward. Interest is calculated @ 3.0% on the prior years ending fund balance Park Asset Fund o Current Funding Level is $171,680 Per Year 0 2011 Proposal is to Use $60,000 For Overlays, Fence Replacement and Shelter Repair Major projects next five years include 2014 — Lion's Park Tennis courts • 2015 —Joe Schelper field lights Park Asset Fund o Consideration of Park Maintenance Underspend to Park Asset Fund Assist in building up Fund For 2009, Park Maintenance Underspend is approximately $80,000 or 2% of Budget Finance Director is not in favor of specific approach to under -spent funds Questions /Comments ---------- ---------------- ------------------ -------------------- ---- ---------- --------------- --------------------------- --- -- --------------------------- - - - --------------------------------------------------------------------- -- -- -- -- ----------------- ----------------------------------------- - - - - - - - - - - - - - - - - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -------------------------------------------------- ------------------------------ -- -- -- -- -- -- -- -- -- -- ----------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------- --------- --------------- ------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------