Loading...
Attachment 2 Reserve FundsCity of Otsego, Minnesota Capital Inirrovement Plan 2013 thril 2017 SOURCES AND USES OT' FUNDS S0111-ce 2013 2014 2015 2016 2017 201 Pavement Mawagement Fund Begimihig -flatice 595,000 277,000 200,000 119;000 183)000 Reveimes mid Mimi- Fmid Som-ces Revemte General Property Taxes 300,000 320,000 330o000 340,000 350,000 Total 300,000 320,000 330,000 340,000 350,000 Total Revemies mid Othei- 1+ mid Som-ces 300,000 320,000 330,000 340,000 350,000 Total Funds Available 89 F00 59700 530,000 459,000 533,000 Expemlitin-es -md Uses Capital Projects & Eqtfipmeifl Public Works Annual Street Seal Coating PW-ST1 2-059 (500,000) (260,000) (265,000) (135,000) (350,000) Annual Street Crack Filling PW -ST 12-060 (50,000) (70,000) (76,000) (70,000) (76,000) Annual Street Striping PW-ST1 2-061 (30,000) (28,000) (29,000) (29,000) (30o000) Annual Street Preventative Mainteriarice PVV-ST12-062 (P80000) (39,000) (41,000) (42,000) (44,000) Total (618,000) (397,0,00) (411,000) (276,000) (500,000) TotnI Expendittjj`es aitd Uses (618,000) (397,000) (41-1,000) (276,000) (500,000) Chmige hi Fmid Balance (318,000) (77,000) (81,000) 64,000 (150,000) Ei iidhig Balaitce 277,000 200,000 119,000 1833000 33,000 Page I Monday, July 01, 2013 S0111 - e 2013 2014 2015 2016 2017 ,202 Trail Management Fujii Beginning Bahmice 101000 0 1,500 3,500 6,500 Reveimes mid Othei- Fmid Som-ces Revem(e General Property Taxes 25,000 26,500 27,000 28,000 29,000 7161al 25,000 26,500 27,000 28,000 29"000 Total lvemics awl Othei- Rind OIII-Ccs 25,000 2+-),500 27,000 28,000 29,000 Total Fmids Available 35,000 26,500 28$500 31,500 35,500 Expewlittives apd Uses Capital Projects &, Equipmeid PublIc Works Annual Trail Management PW- T12-058 (35,000) (25,000) (25,000) (25,000) (25,000) Total (35,000) (25,000) (25,000) (25,000) (25,000) 'I'otal Expetiditm-es mid Uses p5,0000 (25,000) (25,000) (25,000) (25,000) Chmige hi Fimid Bahmice (10,000) 1,500 2,000 3,000 4,000 E m1hig Balance 0 1,500 3,500 6,500 10)500 Page 2 Monday, July 01, 2013 Som-ce 2013 2014 2015 2016 2017 205 Park Capital Eqpt -Fund Beginning Bahmee 93jO00 118,000 156F000 211,000 267,500 Reventies awl Offiev Mimi Som-ces Revellife General Propeq Taxes 25,000 53,000 55J 000 56,500 58,000 Total Revemies aml OtIm- Ftm(l Sources Total Fmids Available F":Xpen(litul-es am] Uses Capital NojeOs & Equipmew Parks & Recreallon Norin Landing Park Project Prairie Park Playground Equipment School Knoll Park Playground Equipment School Knoll Park Pro -1 Play Structure Total Expejidiftires awl Uses Clinjige iii Ftin(I Bal-ance E ifflhig Bah-mee 'rotal 25,000 53,000 55,000 66.5 00 58,000 25,000 5V0O 55,000 56,500 58,000 118POOO 171M0 211j000 267o500 325,510 P&R-NI-12-032 0 0 0 0 (83,517) PR -PP 12-002 0 0 0 0 (80,000) P&R-SK1 2-003 0 0 0 0 (55,733) P&R-SK1 2-045 0 (15,000) 0 0 0 Total 0 (15,000) 0 0 (219,250) 0 (15,000) 0 0 (219,250) 25,000 38,000 55,000 56,500 �I 61,250) 118J000 156,000 211JO00 267)500 1061250 Page 4 Ifonday, Aly 01, 2013 Total Total Revenues awl 0(lice Fuii(] Soui-ces 2013 2014 2015 201 6- 2017 Capital Nojects & Eq0pnieW 206 Capital Eqpt Revolving Fund Adniln[st aflon 175,000 Phone System Upgrade ADM -12-002 234,670 Beginning Balance 480,000 4 4N 69,670 (129)830) (234,830) Reveiiues awl Offier Fqp(l Sotirces Information TechngL.oU 0 Finance System So%vare Upgrade IT -12-001 (20,000) Rove' nte Pubis Works 0 Sign Truck PW -12-0005 Upgfadle sboy System Building Safety Revenues 0 25,000 0 0 0 General Property Taxes 175,000 160,000 165,000 170,000 175,000 Total Total Revenues awl 0(lice Fuii(] Soui-ces 185,000 ToNI Minds Available 170,000 E ell (I i t LI ves a 11 (1 Cases 175,000 Capital Nojects & Eq0pnieW 165,000 Adniln[st aflon 175,000 Phone System Upgrade ADM -12-002 234,670 Total Bui,ld[rig Safety 0 Building Inspection Vehicle (113D.19) BLD -12-001 0 Total Information TechngL.oU 0 Finance System So%vare Upgrade IT -12-001 (20,000) Votal Pubis Works 0 Sign Truck PW -12-0005 Upgfadle sboy System PVV-1 2-021 Light Duty Trucks) ehicles Under 15,000 GVW PW -12-100 Asphalt Maintenance Equipment PW -12-101 Heavy Duty TrucksNehicles PVV-12-102 Heavy Equipment PVV-12-103 Mowing Equipment PW -I2-1 CD4 Light EquipnienWisc PW -12-195 (25,000) 7,01al Total Expeii(Illittit-esawl Uses Cliange hi hin(I 13.alaiice Ending Balance 175,000 185,000 1 65,0 00 170,000 175,000 175,000 185,000 165,000 170,000 175,000 655,000 649,670 234,670 40,170 (59,830) 0 0 0 0 (20,000) 0 0 0 0 (20,000) 0 (25,000) 0 0 0 0 (25,000) 0 0 0 (16,200) 0 0 0 0 (16,200) 0 0 0 0 0 (60,000) 0 0 0 (I2' 13 0) 0 0 0 0 (62,000) (125,000) (35,000) (70,000) 0 (35,000) 0 (9,500) 0 0 0 (180,000) (200,000) 0 0 0 (190,000) (20,000) (150,000) (180,000) (65,000) 0 (42,000) 0 (11,000) 0 0 (58,000) (55,000) (25,000) (174,130) (555,000) (364,500) (275,000) (216,000) (190,330) (580,000) (364,500) (275,000) (236,000) (15,330) (395,000) (199,500) (105,000) (61,000) 464,670 69,670 (129,830) (2342830) (2952830) P"Ige 5 Afonday, JuI)A 01, 2013 Source 2013 2014 2015 2016 2017 '220 Stornmater - Out of District Beghming B-ahrince 0 0 12,235 114,470 10,705 Revemies ayd OtIm- Fimd Som-ces Reveime General Property Taxes 57,765 25,000 25,000 25,000 25,000 Total Total Reveimes mid Othet- Fmid Som-ces Total Funds Available Expeildifill-es 'III(] Uses Capital Pi-ojects & E'clitipment Public Utilities Stormwater CM Sys (GuIverls - Out of 01strict) UTIL-12-067 Ston mater Col I Sys (Kad [e r Cu [vert/C SA H 39 UTIL-12-068 Ditch) Needham Avenue Drainage UTIL-13-002 Annual Stormwate r Mal ntena nCe noUt of District" UTIL-13-003 Total Total Expenditm-esand Uses Cliar ge iii Fimd Balance Ending Balance 57,765 25,000 25,000 25,000 25,000 57,765 25,000 25,000 25,000 25,000 57,765 25000 37,235 39,470 41,705 0 0 (10,000) (10,000) (10,000) (40,000) 0 0 0 0 (5,000) 0 0 0 0 (12,765) (12,765) (12,765) (12,765) (12,765) (57,765) (12,765) (22,765) (22,765) (22,765) (57,765) (12,765) (22,765) (22,765) (22,765) 0 12,235 2,235 2,235 2,235 0 12,235 14,470 162705 18,040 Page 9 Afonday, July 01, 2013