The URL can be used to link to this page

10-11-11 CM Agenda Packet - Item 5 - proposed budget - other funds ��' M� randum � �Yl � � Finance 11 763-593-8013 I 763-593-8109 (fax) Executive Summary Golden Valley Council/Manager Meeting October 11, 2011 Agenda Item 5. 2012-2013 Proposed Budget - Other Funds Prepared By Sue Virnig, Finance Director Summary At the Council/Manager meeting, the Council will be reviewing the following funds: • Water and Sewer Utility Fund (Enterprise) • Storm Sewer Utility Fund (Enterprise) • Vehicle Maintenance Fund (Internal Service Fund) Appropriate staff will be in attendance to discuss the proposed budgets for these divisions and answer questions from the Council. Attachments 2012-2013 Water and Sewer Utility Proposed Budget (39 pages) 2012-2013 Storm Sewer Utility Fund Proposed Budget (42 pages) 2012-2013 Vehicle Maintenance Proposed Budget (15 pages) CITY OF GOLDEN VALLEY 2012-2013 OPERATING BUDGET DIVISION: Utility Malntenance(082) 2012% 2013% 2009 2010 2011 2011 2012 2012 2013 OVER 2011 OVER 2012 OBJECT DESCRIPTION ACTUAL ACTUAL ADOPTED ESTIMATED CONCEPT PROPOSED CONCEPT ADOPTED PROPOSED Personal Services 6110 Salaries-Regular Employees $537,774 $548,742 $581,160 $603,220 $581,160 $623,600 $623,600 6111 Overtime-Regular Empioyees 18,226 19,377 18,000 21,500 18,000 23,000 23,000 6130 Salaries-Temporary Employees 27,171 33,074 36,250 36,250 36,250 36,250 36,250 6150 Employee Insurance 98,831 129,924 130,500 150,810 130,500 157,940 157,940 6160 Retirement 73,283 77,452 99,305 86,450 99,305 90,450 90,450 TOTAL Personal Services 755,285 808,569 865,215 898,230 865,215 931,240 931,240 7.63% 0.00% Supplies and Services 6320 Operating Supplies 143,583 212,234 175,950 192,950 175,950 176,250 158,800 0.17% -9.90% 6324 Clathing 6,355 6,266 6,500 6,500 6,500 7,100 7,100 9.23% 0.00% 6331 EquipmentParts 3,586 3,943 15,250 16,750 14,250 16,750 14,750 9.84% -11.94% 6340 Professional Services 190,292 106,504 147,200 148,150 147,200 143,695 144,180 -2.38% 0.34% 6343 Telephone 6,467 5,845 9,680 9,680 9,680 9,750 9,750 0.72% 0.00% 6371 Electric Service-NSP 2,151 2,123 2,600 2,600 2,600 2,600 2,600 0.00% 0.00% 6411 ConferencesandSchools 13,752 7,164 13,550 13,550 13,550 15,245 13,245 12.51% -13.12% 6413 DuesandSubscriptions 1,423 1,148 1,530 1,525 1,530 1,580 1,580 3.27% 0.00% 6440 OtherContractualService 1,872,323 2,006,921 2,279,190 2,281,640 2,490,890 2,605,420 2,605,420 14.31% 0.00°/ 6840 MerchandiseforResale 2,754,535 2,130,612 2,731,000 2,890,465 2,841,000 2,764,180 2,889,190 1.21% 4.52°/ TOTAL Supplies and Services 4,994,467 4,482,760 5,382,450 5,563,810 5,703,150 5,742,570 5,846,615 6.69% 1.81% Vehicle Maintenance Charaes 7401 Maintenance Charges-Labor 47,637 40,108 40,000 40,000 41,000 41,000 41,000 2.50% 0.00% 7402 Maintenance Charges-Parts 39,535 31,270 40,000 40,000 40,000 40,000 40,000 0.00% 0.00% 7403 MotorFuels 27,143 34,346 32,000 32,000 33,000 33,000 33,000 3.13% 0.00°/ TOTAL Vehicle Maintenance Chgs 114,315 105,724 112,000 112,000 114,000 114,000 114,000 1.79% 0.00°/ Capital Outlav 6960 CapitalOutlay 1,421,549 663,704 2,242,000 2,264,320 732,000 1,391,000 1,485,000 -37.96% 6.76% TOTAL Capital Outlay 1,421,549 663,704 2,242,000 2,264,320 732,000 1,391,000 1,485,000 37.96% 6.76°/ Transfers 7110 Permanent Transfer-Reserve Fund - - - - - - - 7220 Overhead Transfer-General Fund 275,000 275,000 290,000 275,000 305,000 275,000 275,000 -5.17% 0.00% TOTALTransfers 275,000 275,000 290,000 275,000 305,000 275,000 275,000 -5.17% 0.00% TOTALS $7,560,616 $6,335,757 $8,891,665 $9,113,360 $7,719,365 $8,453,810 $8,651,855 -4.92% 2.34% CITY OF GOLDEN VALLEY 2012-2013 OPERATING BUDGET DIVISION: Utility Maintenance(082) PROGRAM: Administration(7121) 2012% 2013% 2009 2010 2011 2011 2012 2012 2013 OVER 2011 OVER 2012 OBJECT DESCRIPTION ACTUAL ACTUAL ADOPTED ESTIMATED CONCEPT PROPOSED CONCEPT ADOPTED PROPOSED Supplies and Services 6320 OperatingSupplies $21,385 $30,103 $25,700 $25,700 $25,700 $27,300 $29,300 6.23% 7.33% 6324 Clothing 6,355 6,266 6,500 6,500 6,500 7,100 7,100 9.23% 0.00% 6331 EquipmentParts 3,586 3,943 15,250 16,750 14,250 16,750 14,750 9.84% -11.94% 6340 ProfessionalServices 89,067 26,812 29,200 30,150 29,200 25,195 25,680 -13.72% 1.92% 6343 Telephone 4,637 4,280 7,680 7,680 7,680 9,250 9,250 20.44% 0.00% 6411 Conferences and Schools 13,752 7,164 13,550 13,550 13,550 15,245 13,245 12.51% -13.12% 6413 Dues and Subscriptions 1,423 1,148 1,530 1,525 1,530 1,580 1,580 3.27% 0.00% 6440 Other Contractual Services 1,222 620 1,200 1,200 1,200 6,200 6,200 416.67% 0.00% 6840 Merchandise for Resale 4,304 18,766 25,000 25,000 25,000 25,000 25,000 0.00% 0.00% TOTAL Supplies and Services 145,731 99,102 125,610 128,055 124,610 133,620 t32,105 6.38% -1.13% Vehicle Maintenance Charqes 7401 MaintenanceCharges-Labor 47,637 40,108 40,000 40,000 41,000 41,000 41,000 2.50% 0.00% 7402 Maintenance Charges-Parts 39,535 31,270 40,000 40,000 40,000 40,000 40,000 0.00% 0.00% 7403 Molor Fuels 27,143 34,346 32,000 32,000 33,000 33,000 33,000 3.13% 0.00% TOTAL Vehicle Maintenance Chgs 114,315 105,724 112,000 112,000 114,000 114,000 114,000 1.79% 0.00% Caoital Outlav 6960 CapitalOutlay 1,421,549 663,704 2,242,000 2,264,320 732,000 1,391,000 1,465,000 -37.96% 6.76% TOTALCapitalOutlay 1,421,549 663,704 2,242,000 2,264,320 732,000 1,391,000 1,485,000 -37.96% 6.76% Transfers 7220 Overfiead Transfer-GeneralFund 275,000 275,000 290,000 275,000 305,000 275,000 275,000 -5.17% 0.00% TOTAL Transfers 275,000 275,000 290,000 275,000 305,000 275,000 275,000 -5.17% 0.00% TOTALS $1,956,595 $1,143,530 $2,769,610 $2,779,375 $1,275,610 $1,913,620 $2,006,105 -30.91% 4.83% Administration- Utilities Program 7121 6320-Operating Supplies 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Concept Sho Su lies& E ui ment 1,638 6,201 3,500 3,500 3,500 3,500 4,000 Tools 2,263 2,080 1,000 1,000 1,000 1,000 2,000 Paint&Su lies 690 100 800 800 800 800 800 Safet E ui ment 3,094 1,242 2,500 1,700 2,500 2,500 3,000 Re lacement Parts 5,711 3,350 4,000 4,000 4,000 4,000 4,000 Re air Materials 4,355 4,496 4,100 4,100 4,100 4,100 4,100 Markin PainUlocate 1,770 900 1,000 1,000 Office Furniture 200 1,000 1,000 1,000 1,000 1,000 Metai Locator 1,006 2,254 1,500 1,600 1,500 1,500 1,500 Office Su lies 730 1,680 1,500 1,500 1,500 1,500 1,500 Cement Mixer 3,000 Generator 3,130 Printer 1,131 Meters for City Buildings 2009 Moved to 6340 Water Qualit Re ort 767 800 800 800 800 Re lacement of Com uters 5,000 5,000 5,000 5,000 5,000 S ecial Assessment Char es(Henn Ct 600 600 600 600 $21,385 $30,103 $25,700 $25,700 $25,700 $27,300 $29,300 Administration- Utilities Program 7121 6324-Clothing 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Concept Pro osed Conce t Uniforms for Crew 3,200 3,290 3,700 3,700 3,700 3,900 3,900 Safet Shoe Reimbursement 10 em lo ees$150/calendar ear/ erson 1,437 1,457 1,500 1,500 1,500 1,500 1,500 Safet Clothin Rain Suits,Vests, Hard Hats Rubber Glove 1,718 1,519 1,300 1,300 1,300 1,700 1,700 $6,355 $6,266 $6,500 $6,500 $6,500 $7,100 $7,100 Administration- Utilities Program 7121 6331-Equipment Parts 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Proposed Concept Hose for Sewer Jet 3,586 4,000 3,800 4,000 4,000 4,000 Nozzle for Sewer Jet 2,000 4,500 2,000 3,000 3,000 Grease Release 1,400 2,900 1,400 2,900 2,900 2 Broom Heads sidewalk machines 1,350 1,350 1,350 1,350 1,350 Misc Su lies 1,000 1,000 1,000 1,000 1,000 Manhole Blowers 2 1,000 1,000 Confined S ace Ent Tri od 3,000 3,000 Confined S ace Ent Monitors/Software 1,500 1,500 1,500 3"Trash Pum 4,500 3,200 Mixer 2,340 Generator 1,603 $3,586 $3,943 $15,250 $16,750 $14,250 $16,750 $14,750 Administration- Utilities Program 7121 6340-Professional Services 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Pro osed Concept Go her One Call 4,864 6,029 6,000 7,000 6,000 7,000 7,000 Water Qualit Re ort 800 555 800 600 700 Hi hwa Technolo ies 500 500 500 500 500 AGT International electronic o her locates 1,224 1,224 1,400 1,400 1,400 1,400 1,400 Plumbin at Cit facilities (Meter U rades Moved from 6320 7,000 7,000 7,000 7,000 7,000 Misc. Printin 620 620 620 620 620 800 Mhz. Radio Maint. 16 Radios 2,880 2,352 2,880 3,075 2,880 3,075 3,460 Tree Trust Reservoir Wall 9,109 MCES Foundation Grant Pro ram 70,990 15,658 revenue to offset ex ense Carte ra h Technical Su ort 1,549 10,000 10,000 10,000 5,000 5,000 $89,067 $26,812 $29,200 $30,150 $29,200 $25,195 $25,680 Administration- Utilities Program 7121 6343-Telephone 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Proposed Concept Cell Phone Usa e for De artment 2,762 2,505 2,800 2,800 2,800 2,800 2,800 Cell Phone Re IacemenU Parts 100 100 100 100 100 Com uter Wireless Modem 1,875 1,775 3,060 3,060 3,060 4,650 4,650 6 X$42.5/month X 12 months Net Motion for 2 La To s 2 X$200) 1,000 1,000 1,000 600 600 Two more in 2010 GPS Cell Phone $90/month X 12 months 720 720 720 1,100 1,100 $4,637 $4,280 $7,680 $7,680 $7,680 $9,250 $9,250 Administration -Utilities Program 7121 6411-Conferences&Schools 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Concept Proposed Conce t AWWA National Conference 2,000 Suburban Utilit All Utilities Staf� 90 180 200 200 200 200 200 MN De t of Health water schoo�3 da ) 1,120 1,162 1,200 1,200 1,200 1,200 1,200 Five Utilities Staff MN Pollution Control (sewer school 3 da 568 560 1,200 1,200 1,200 1,200 1,200 Six Utilities Staff MN Rural Water Association One Da &Annual Conference 1,275 1,325 1,200 1,200 1,200 1,200 1,200 MN Wastewater O erators Conference Lemke 517 140 800 800 800 800 800 MN AWWA Section Conference 1,500 1,149 1,600 1,600 1,600 1,600 1,600 Trac , Lemke) Public Works Leadershi Academ Lemke 1,300 Misc Trainin O ortunities(All Utilities Sta 5,494 4,900 4,305 4,900 4,000 4,000 Safet Trainin All Utilities Sta 1,387 1,485 1,700 1,700 1,700 1,700 1,700 Trainin Materials(All Utilities Staf� 42 500 500 500 500 500 Audio Metric Onsite Testin 162 168 250 250 250 250 250 CPR Trainin 297 Defensive Snow Plaw Trainin 400 Utilit Mana ement Institute 595 595 595 595 $13,752 $7,164 $13,550 $13,550 $13,550 $15,245 $13,245 Administration-Utilities Program 7121 6413-Dues,Subscriptions and Certifications 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Proposed Conce t MN Wastewater O erator Dues Trac , Lemke 140 200 50 55 50 50 50 AWWA Membershi Trac , Lemke 557 310 600 590 600 600 600 APWA Membershi Trac , Lemke 283 205 290 290 290 290 290 Certification Costs All Utilities Sta 20 100 100 100 100 100 SUSA Membershi Trac , Lemke 200 200 250 200 250 250 250 MN Rural Water Membershi Cit , Lemke 200 188 200 200 200 200 200 Boiler License Renewal McCall 23 45 40 90 40 90 90 $1,423 $1,148 $1,530 $1,525 $1,530 $1,580 $1,580 Administration -Utilities Program 7121 6440-Other Contractual Services 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Conce t Miscellaneous Contractual Fees 1,222 620 1,200 1,200 1,200 1,200 1,200 Clean Fill Dis osal 5,000 5,000 $1,222 $620 $1,200 $1,200 $1,200 $6,200 $6,200 Administration -Utilities Program 7121 6840-Merchandise for Resale 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Conce t Radio Read Meters and Parts 4,304 18,766 25,000 25,000 25,000 25,000 25,000 $4,304 $18,766 $25,000 $25,000 $25,000 $25,000 $25,000 Administration-Utilities Program 7121 6960 Capital Outlay 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Pro osed Conce t Utilit Buildin Re airs Air Com ressor 185CFM Unit 637 W&SS-01 15,011 Utilit Truck, Unit 669 W&SS-020 30,684 Portable Generator W&SS-041 23,409 GPS Unit 8,712 Utilities Tractor W&SS-031 Moved From 2010 108,402 San Swr&Wtr Line Re air/Reconst 987,184 275,718 1,000,000 1,000,000 400,000 400,000 1,100,000 I&I Surchar e Pro ram 216,304 185,316 200,000 200,000 200,000 200,000 200,000 Sewer Debris Collector 5,419 Door Re lacement 8,800 H dralic Breaker 5,268 Utilit Buildin Roof Re lace-Wold Priorit #1 21,068 Portable Generator SCADA Connection on All Lift Stations 26,858 Dum Truck W&SS-017 64,677 Picku Truck W&SS-019 25,970 Water Main Re lacement-Boone Ave 88,089 Sidewalk Swee er W&SS-034 10,056 Mill and Overla Outdoor Stora e Area W&SS-046 50,000 50,000 Utilit Buildin Re airs W&SS-045 Vactor Truck W&SS-033 390,000 390,000 Trailer Mounted Welder W&SS-049 20,000 7,337 H dralic Dewaterin Pum W&SS-055 20,000 30,940 Water Main Rehabilitaion-Le end Dr 540,000 470,000 -Brunswick 70,000 Structure and Pi e Ins ection Pole Camera 22,000 19,185 Trailer 12,000 12,000 Air Com ressor Mounted on Trailer 35,000 25,000 Picku Truck 35,000 45,000 Utilit Buildin Floorin U rade 50,000 50,000 Guide Rail S stem 5,166 Er onomic Work Stations 20,000 Meter Readin S stem U rade 100,000 100,000 Sidewalk Swee er W&SS-044 15,000 Picku Truck 85,000 Harold Ave Reconstruction 500,000 Sewer Televisin E ui ment 24,000 1,421,549 663,704 2,242,000 2,264,320 732,000 1,391,000 1,485,000 City of Golden Valley, Minnesota Capital Improvement Plan Data in Year 2012 and 2013 PROJECTS BY YEAR Project Name Department Project# Priority Project Cost 2012 Sanitary Sewer&Water Line RepaidRecon. Water&Sewer Systems W&SS-001 n/a 400,000 Inflowllnfiltration Study and Improvements Water&Sewer Systems W&SS-002 n/a 200,000 Utility Building Flooring UpgradelReplacement Water&Sewer Systems W&SS-032 n/a 50,000 Pickup/Utility Truck Water&Sewer Systems W&SS-035 n/a 45,000 Sidewalk Sweeper Water&Sewer Systems W&SS-044 n/a 15,000 Air Compressor Mounted on Trailer Water 8 Sewer Systems W&SS-047 n/a 25,000 Televising Equipment Water&Sewer Systems W&SS-053 nla 24,000 Trailer Water 8 Sewer Systems W&SS-054 nla 12,000 Harold and Rhode Island Reconstruction Water&Sewer Systems W&SS-057 nla 500,000 Work Stations Water&Sewer Systems W&SS-059 nla 20,000 Radio Meter Reading System Water&Sewer Systems W&SS-063 n/a 100,000 Total for 2012 1,391,000 20� Sanitary Sewer&Water Line RepairlRecon. Water&Sewer Systems W&SS-001 nla 1,100,000 Inflowllnfiltration Study and Improvements Water&Sewer Systems W&SS-002 nla 200,000 Pickup Truck Water&Sewer Systems W&SS-062 n/a 85,000 Radio Meter Reading System Water&Sewer Systems W&SS-063 n/a 100,000 Total for 2013 1,485,000 GRAND TOTAL 2,876,000 Page 1 Project# WcXLSS-OO1 Department Water&Sewer Systems � Contact Project Name Sanitary Sewer& Water Line Repair/Recon. Type Unassigned llseful Life Category Water and Sewer Priority Description !Major repairs and reconstruction on the City's sanitary sewer and water systems as needed. Repairs will be done in conjunction with the City's Pavement �, Managemen[Program(See S#1). I Justification _ __ To maintain City's water mains and sanitary sewer mains. !I Expenditures 2012 2013 2014 2015 2016 Total Construction/Maintenance 400,000 1,100,000 1,100,000 1,100,000 1,100,000 4,800,000 Total 400,000 1,100,000 1,100,000 1,100,000 1,100,000 4,800,000 Funding Sources 2012 2013 2014 2015 2016 Total Water&Sewer Utility Fund 400,000 1,100,000 1,100,000 1,100,000 1,100,000 4,800,000 TOtal 400,000 7,100,000 1,100,000 1,100,000 1,100,000 4,800,000 Project# wc�iLss-��2 I Department Water&Sewer Systems Contact Project Name Inflow/Infiltration Study and Improvements I Type Unassigned Useful Life Category Water and Sewer Priority Description ,Results of an enginnering study in 2005 and 2006 identified the sources of clear water inflow and infiltration(I&I)into the cities and the Metropolitan Council Gnvironmental Services(MCES)sanitary sewer systems.Beginning in 2006,the sources identified in the study will be addressed. � Justification Consistent with the MCES requirements that the City's I&I problems must be addressed to avoid the surcharge and pending demand charge from the MCES.In I 2013,unaddressed flows were to built into the rates from MCES but will now be used for rehabiliation of the sys[em. I Expenditures 2012 2013 2014 2015 2016 Total Infrastructure Improvements 200,000 200,000 200,000 200,000 200,000 1,000,000 Total 200,00o zoo,000 200,000 200,000 200,000 1,000,000 Funding Sources �012 2013 2014 2015 2016 Total Water&Sewer Utility Fund 200,000 200,000 200,000 200,000 200,000 1,000,000 Total 200,000 200,000 200,000 200,000 200,000 1,000,000 Page 1 Project# w&SS-�32 � Department Water&Sewer Systems Contact � rro�e�r tvame Utility Building Flooring Upgrade/Replacement I TyPe Unassigned � Usefui Life Category Water and Sewer Priority � Description I _ __ _ Utility Building tile tlooring in the main roll call room,restroom,offices,kitchen,steps and entry. _ —_� Justification Utility Building flooring withstands heavy abuse from employee tracking and has exceeded its life cycle. Expenditures 2012 2013 2014 2015 2016 Total Other 50,000 50,000 TOtal 50,000 50,000 Funding Sources 2012 2013 2014 2015 2016 Total Water&Sewer Utility Fund 50,000 50,000 Total 50,000 50,000 Project# wc�iLss-�35 Department Water&Sewer Systems Contact Project Name picku /IJtili Truck T p �' ype Unassigned Oseful Life Category Water and Sewer Priority Description �IPickup/Utility truck for the Utility Department to replace Unit#673,a 2002 Ford F-I50 pickup. J ' Justification Increased repair and maintenance on Unit#673,which will be ten years old. � Expenditures 2012 2013 2014 2015 2016 Total Other 45,000 45,000 TOtal 45,000 45,000 Funding Sources 2012 2013 2014 2015 2016 Total Water&Sewer Utility Fund 45,000 45,000 TOtal 45,000 45,000 Page 2 I Project# w�Lss-�44 ' Department Water&Sewer Systems I Contact Project Name SldeWa�k SWeeper Type Unassigned Useful Life Category Water and Sewer Priority jDescription 'Gravely sidewalk sweeper for complex snow removal and various sweeping duties. I '� Justification Ilncreased repair and maintenance expenditures on Unit 663,a 1998 Gravely sidewalk machine. 1 Expenditures 2012 2013 2014 2015 2016 Total Other 15,000 15,000 Total 15,000 75,000 Funding Sources 2012 2013 2014 2015 2016 Total Water&Sewer Utility Fund 15,000 15,000 Total 15,000 15,000 Project# We�iLSS-O47 Department Water&Sewer Systems Contact Project Name Air Compressor Mounted on Trailer Type Unassigned Useful Life Category Water and Sewer Priority IDescription IAir compressor on trailer to replace Unit 662, 1997 Ingersol Rand. __-----_ _ __.._-- —- --- --_ __I I Justification ' �Increase repair and maintenance expenditures on Unit 662,which will be 15 years old. � Expenditures 2012 2013 2014 2015 2016 Total EquipNehicles/Furnishings 25,000 25,000 Total 25,000 25,000 Funding Sources 2012 2013 2014 2015 2016 Total Water 8�Sewer Utility Fund 25,000 25,000 TOt31 25,000 25,000 Page 3 �� Project# w8iss-053 Department Water&Sewer Systems ' Contact ', Pro�ect Name Televising Equipment Type Equipment Llseful Li(e Category Water and Sewer Priority ' Description Sewer televising camera and transporter for televising sewer mainlines.Main Line Televising equipment to replace equipment purchased with truck#680.The equipment will be four years old and the computer software will be not compatible. IJustification ' !The equipment will be four years old and the computer software will be outdated.In 2016,all equipment will need to be replaced.. � ____ Expenditures 2012 2013 2014 2015 2016 Total EquipNehicles/Furnishings 24,000 50,000 74,000 Total 24,000 50,000 74,000 Funding Sources 2012 2013 2014 2015 2016 Total Water&Sewer Utility Fund 24,000 50,000 74,000 Total za,000 �o,000 7a,000 Project# w&ss-054 � Department Water&Sewer Systems Contact Project Name Trailer I Type Equipment Useful Life Category Water and Sewer Priority ! Description �, _- Trailer to haul trench box for water main breaks.This is one of two trailers. Justification �IThis would replace Unit#652 that will be 21 years old. I Expenditures 2012 2013 2014 2015 2016 Total EquipNehicles/Furnishings 12,000 12,000 Total 12,000 12,000 Funding Sources 2012 2013 2014 2015 2016 Total Water&Sewer Utility Fund 12,000 12,000 TOtal 12,000 12,000 Page 4 i Project# wBLss-�57 Department Water&Sewer Systems Contact Project Name Harold and Rhode Island Reconstruction I T ype Unassigned useru�Lire Category Unassigned Priority I Description �� IiMajor repairs and reconstruction on the City's sanitary sewer and water systems as needed.Repair will be done in conjunction with the City's Pavement 'Management Program on Harold Avenue.This project is in addition to the 2012 PMY project area. Justification To maintain City's water mains and sanitary sewer mains. Expenditures 2012 2013 2014 2015 2016 Total Infrastructure Improvements 500,000 500,000 Total 500,000 500,000 Funding Sources 2012 2013 2014 2015 2016 Total Water&Sewer Utility Fund 500,000 500,000 Total 500,000 500,000 Project# wt�ss-�59 Department Water&Sewer Systems Contact Project Name work Stations Type Unassigned IJseful Life Category Unassigned Priority � Description ____ _ -� �IErgonomically correct work stations to replace olde style desks[hat were purohased prior to computers. ' Justification Utility work station replacements due to age and ergonomics.This would include four works[ations. Expenditures 2012 2013 2014 2015 2016 Total Equip/Vehicles/Furnishings 20,000 20,000 Total 20,000 20,000 Funding Sources 2012 2013 2014 2015 2016 Total Water&Sewer Utility Fund 20,000 20,000 Total 20,000 20,000 Page 5 ', Project# w8iss-�62 Department Water&Sewer Systems Contact Project Name p�ckup Truck Type Equipment IJseful Life Category Water and Sewer Priority ', Description �Pickup Truck for the Utility Department to replace Unit#683,a 2008 F-350 4X4 with utility box,lazge crane hoist and plow.Unit#683 will be transferred to Vehicle Maintenance. � Justification _�Increased repair and maintenance expenditures on Unit#683. Expenditures 2012 2013 2014 2015 2016 Total Equip/Vehicles/Furnishings 85,000 85,000 Total 85,000 85,000 Funding Sources 2012 2013 2014 2015 2016 Total Water&Sewer Utility Fund 85,000 85,000 TOtal 85,000 85,000 Project# W&SS-O63 Department Water&Sewer Systems Contact Project Name Radio Meter Reading System TyPe Equipment Useful Life Category Water and Sewer Priority Description Fixed base radio metering reading system. � Justification Existing FCC radio frequency utilized for reading city water meters has been banned by the FCC and city is forced to comply with the rule changes. Expenditures 2012 2013 2014 2015 2016 Total EquipNehicles/Furnishings 100,000 t00,000 100,000 100,000 400,000 Total 100,000 �oo,000 �00,000 100,000 400,000 Funding Sources 2012 2013 2014 2015 2016 Total Water 8�Sewer Utility Fund 100,000 100,000 100,000 100,000 400,000 Total 100,000 100,000 100,000 100,000 400,000 Page 6 Administration- Utilities Program 7121 7220-Overhead Transfer-General Fund 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Proposed Conce t Transfer to General Fund 275,000 275,000 275,000 275,000 275,000 275,000 275,000 15,000 30,000 $275,000 $275,000 $290,000 $275,000 $305,000 $275,000 $275,000 CITY OF GOLDEN VALLEY 2012-2013 OPERATING BUDGET DIVISION: Utility Maintenance(082) PROGRAM: Sewer Maintenance(7122) 2012% 2013% 2009 2010 2011 2011 2012 2012 2013 OVER 2011 OVER 2012 OBJECT DESCRIPTION ACTUAL ACTUAL ADOPTED ESTIMATED CONCEPT PROPOSED CONCEPT ADOPTED PROPOSED Personal Services 6110 Salaries-Regular Employees $245,768 $247,181 $290,575 $301,610 $290,575 $311,800 $311,800 6111 Overtime-Regular Employees 3,452 5,083 3,000 5,500 3,000 6,000 6,000 6130 Salaries-Temporary Employees 12,403 16,509 18,125 18,125 18,125 18,125 18,125 6150 Employeelnsurance 44,742 61,915 62,250 75,405 62,250 78,970 78,970 6160 Retirement 32,969 34,674 47,950 43,225 47,950 45,225 45,225 TOTAL Personal Services 339,334 365,362 421,900 443,865 421,900 460,120 460,120 9.06% 0.00% Suoolies and Services 6320 Operating Supplies 81,125 84,158 87,250 89,250 87,250 70,950 51,500 -18.68% -27.41% 6340 Professional Services 48,538 18,552 65,000 65,000 65,000 65,000 65,000 0.00% 0.00% 6343 Telephone 1,830 1,565 2,000 2,000 2,000 500 500 -75.00% 0.00% 6371 Electric Service 2,151 2,123 2,600 2,600 2,600 2,600 2,600 0.00% 0.00% 6440 Other Conlractual Service 1,613,203 1,592,657 1,669,390 1,669,840 1,736,090 1,842,220 1,842,220 10.35% 0.00% TOTAL Supplies and Services 1,746,847 1,699,055 1,826,240 1,828,690 1,892,940 1,981,270 1,961,820 8.49% -0.98% TOTALS $2,086,181 $2,064,417 $2,248,140 $2,272,555 $2,314,840 $2,441,390 $2,421,940 8.60% -0.80% a o ch c� u� o N �"� � u�Oi n `r r°� o°o_ N O� O (O �fi h N Cp N V N M E V v3 A � m ch � � M a � N y o K � = o y O M N � O N y N � � M O�D O _ p oi o co ui � N O N V N a N M � G! M R � � N (A O � O _ Y (O � V N N G7 � � O> ONi N NC Oi O ln V O � N � N U y� d .+ m � N K _ N O M N O N O � � W � � � � � � I� V C4 (O p , m O f0 N N N �1 N � M W fA N � M Q' N y N Q.' � 2 �p co v v �n p� � a0 N f� ti7 � � ln p 0 W O (O R O N � N � N Q fA d f0 � N � 2 w OD (O V M U o � ^ � °r Z � OD (h 01 O Q p V � O ln in I� Z N Q � N W tH H 2 y � � � W W � f� _ � � rn � � ro � o � ao rn n n v o � v vi N Q W � ry 69 N A � N � 2 rn � N � N � N � O � C N L W � V � U U L � N ~ fp (p ; C N N N V C M C �,0 N N N N N 0 y y 10 I� .� N � f� � � N N ui d O y � � � y � � � a � N A y N � � � p j E j O � N E 'O � p� O O C @ G7 U d ?� N � � N � m O N � V � � V �� C E � � � - 1] U � �c a � a' � Q o ° .+ a NI M G! O � n N C � N O E V A rn °7 o � a y K 2 � o f V fy � O O O � � � N p a` w a � � � 2 o ° � o N y p � O C � � N p U a� io d' N � 2 a o ° 0 � o ,� � E u' 'n o ._ � N y W N A Q.' � R' 2 .o 0 0 � d p � O p M � N � Q d N � y � 2 W � � U O R p O 2 � ,n �n 0 Z N Q W H Z y � � � W W � (� _ N N O10 � V � � M O V N Q d N � y � 2 rn N N d � d � O � a � a w E c � W O v � c R y m � U � � d C � @ d � E N � Y N j > > O � a � m a NI a+ � N N � � A M N N C � � m U rn o y a @ � y � _ � � � d � N N O O � � N p � a m m � w � 2 � � N N N ry N C � � O U a� « A � � � 2 a � � @ � N O E aD � N y W N 10 � N � 2 � � � � d � � p p � ro N �p Q N N � N � 2 o � u°� u°� � � � o � N Q d i0 � N � 2 M ch � � � V p V N N N Q N R � N � 2 W O N - �L � � lE � N N r � o � — a � £ w d � F C O M � t0 (n SEWER MAINTENANCE Program 7122 6320-Operating Supplies 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Concept Proposed Conce t Sewer S stem Re air Parts 18,565 19,949 20,000 20,000 20,000 20,000 20,000 includin : manhole covers/castin s cement rin cement sections sealants lift station re airs ie Landsca e Materials 2,929 6,458 3,000 5,000 3,000 3,000 3,000 includin : beddin rock it run ravel black dirt/sod as halbconcrete cement Televisin Camera Parts 2,170 3,353 3,500 3,500 3,500 4,000 4,000 adlocks Grease Release 2,625 2,746 3,000 3,000 3,000 4,200 4,500 Solid Manhole Covers, I/I(15% 47,348 48,482 50,000 50,000 50,000 30,000 10,000 a rox 2900 manhole covers throu hout cit Drivewa Clean Out Covers, 50 1,341 0 1,750 1,750 1,750 1,750 2,000 New Sewer Pum s-Hw 55 lift station emer enc ) Lift Station Su lies 3,173 2,000 2,000 Jetter Hose 2,974 3,170 3,500 3,500 3,500 3,500 3,500 Sewer Flow Meter Re air Parts 2,500 2,500 2,500 2,500 2,500 $81,125 $84,158 $87,250 $89,250 $87,250 $70,950 $51,500 SEWER MAINTENANCE Program 7122 6340-Professional Services 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Pro osed Conce t Sewer Line Groutin /Sealin and Linin 35,000 35,000 35,000 32,000 32,000 Manhole Re airs/Flex Seal Chimne s 9,212 13,412 25,000 25,000 25,000 25,000 25,000 40 X$390 each Carte ra h WSB 493 970 2,000 2,000 2,000 2,000 2,000 Sewer Service Re airs 12,038 Le al Fees 2,760 3,000 3,000 3,000 1,000 1,000 To Hat 17,800 Install Transformer 6,235 Lift Station Re airs 3,991 2,000 2,000 Emer enc Service Call 179 3,000 3,000 SCADA Maintnenance $48,538 $18,552 $65,000 $65,000 $65,000 $65,000 $65,000 SEWER MAINTENANCE Program 7122 6343-Telephone 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Proposed Conce t Lift Stations Phone Line 1,830 1,565 2,000 2,000 2,000 Lift Station SCADA Cell Phones 500 500 $1,830 $1,565 $2,000 $2,000 $2,000 $500 $500 SEWER MAINTENANCE Program 7122 6371-Electric Service 2009 2010 2011 2011 2012 2072 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Concept Electricit at Pum Stations 2,151 2,123 2,600 2,600 2,600 2,600 2,600 $2,151 $2,123 $2,600 $2,600 $2,600 $2,600 $2,600 SEWER MAfNTENANCE Program 7122 6440-Other Contractual Services 2009 2010 2011 2011 2012 2012 2073 Descri tion Actual Actual Ado ted Estimate Conce t Proposed Concept MCES wastewater 1,585,847 2010 Flow Total 84,519,050 GV-801.14 or.947881% 2011 FlowTota185,293,980 1,586,844 1,650,545 1,650,545 1,716,570 1,824,000 1,824,000 GV-814.78 or.955261% Surroundin Cit Sewer char es Trans Alarm 1,424 1,248 1,600 1,600 1,700 0 0 New Ho e 3 service addresses 1,227 1,475 1,325 1,475 1,400 1,500 1,500 C stal 1 service address 180 135 220 220 220 220 220 Manhole Re airs Claim 5,879 Bank/cc Char es-I&I 2,170 2,212 2,200 2,500 2,200 2,500 2,500 Lea ue of Minnesota Cities 12,830 13,500 13,500 14,000 14,000 14,000 sewer backu covera e Life Safet S stems 185 Miscellaneous Concrete Re air 3,056 Cit of Bloomin ton Sam le Anal sis 405 Ra id Gra hics 391 Under round Piercin 382 $1,613,203 $1,592,687 $1,669,390 $1,669,840 $1,736,090 $1,842,220 $1,842,220 CITY OF GOLDEN VALLEY 2012-2073 OPERATING BUDGET DIVISION: Utility Maintenance(082) PROGRAM: Water Maintenance(7123) 2012% 2013% 2009 2010 2011 2011 2012 2012 2013 OVER 2011 OVER 2012 OBJECT DESCRIPTION ACTUAL ACTUAL ADOPTED ESTIMATED CONCEPT PROPOSED CONCEPT ADOPTED PROPOSED Personal Services 6110 Salaries-Regular Employees $292,006 $301,561 $290,585 $301,610 $290,585 $311,800 $311,800 6111 OveAime-Regular Emptoyees 14,774 14,294 15,000 16,000 15,000 17,000 17,000 6130 Salaries-Temporary Employees 14,768 16,565 18,125 18,125 18,125 18,125 18,125 6150 Employee Insurance 54,089 68,009 68,250 75,405 68,250 78,970 78,970 6160 Retirement 40,314 42,778 51,355 43,225 51,355 45,225 45,225 TOTAL Personal Services 415,951 443,207 443,315 454,365 443,315 471,120 471,120 6.27% 0.00% Suoplies and Services 6320 Operating Supplies 41,073 97,973 63,000 78,000 63,000 78,000 78,000 23.81% 0.00% 6340 Professional Services 52,687 61,140 53,000 53,000 53,000 53,500 53,500 0.94% 0.00% 6440 Olher Contractual Service 257,898 413,644 608,600 610,600 753,600 757,000 757,000 24.38% 0.00% 6840 MerchandiseforResale(Water) 2,750,231 2,111,846 2,706,000 2,865,465 2,816,000 2,739,180 2,864,190 1.23% 4.56% TOTAL Supplies and Services 3,101,889 2,684,603 3,430,600 3,607,065 3,685,600 3,627,680 3,752,690 5.74% 3.45% TOTALS $3,517,840 $3,127,810 $3,873,915 $4,061,430 $4,128,915 $4,098,800 $4,223,610 5.81% 3.05% e"1I ~ t�0 W � O O N M V � 1� M aO � N � N V � N E V N M � M p� d M a a' N O � O _ N N t0 W � O O � O � f� M o0 O m O (O � � N � N V N a N M y M � M � N (n O � � _ � "'' O � � u� � � V !� � � � � O C � O � V O N p N V 6) V N N G/ N � � � _ d O M N O ln O � � � W � � � � 1� V (O c0 O £ � O c0 N N N y N V O W N M � M M N Q.' N � N � � _ 'O O � 1n Ln u7 � 0� c0 e0 N oD � � � � O p O� O � V O N -p N V � Q N N N N d' � � _ W W c0 V (`� V � r � Z � j N M 01 O l!') Q N V � � � � O Z a N M W H Z � � � � W N Q � � _ �n �n u'� co � �p CO o0 N O p 3 � � � O N V M � � � m a N N N l6 � � � _ � � y NN � N � 1� p � O C `� tl.� � � L C �7 � � U U = r c c 3 � o G7 �VC N N C C � N y N N N O tn v7 L {O � C n � C .N � 'y L N � � ° u°, � °� Q 3 A � N � � � p j � � o O N o � E � E rn G1 � N � � ON .0 y N OV � V N � o �C � d - 1] U � 7 — � N 'p in a � d � Q 0 0 NI M V O O n NC I� 1� O E V A rn d o ia a` � � � x d o 0 N O O O O � 1� f� N a m m � � � 2 0 0 N d O O r V O C �1 � N p U a� m � y � x d � � °o °o 0 0 o E cfl co N y W N N � � � _ � N O O O O O p � � N � Q N N � y Q' 2 W Z � 3 N N Q O V '7 V Z N Q W H Z � � � � W y Q � � _ � � r r O � � n N V � � Q G1 m � � � 2 rn � � � � o �, � Q' w E c � W O v N � (6 j V C � � � y C G7 ❑ � E �n � Y N j > ] O � a � �o a � � M d N � � U O C � a0 N p U MI N � � a � E m rn � o = d N O N N O Q o0 aO N a m A � � � x y � � N N N � � V O C � aO N p U N A Q.' � d' _ G1 � � j0 N N O � �D W N N W d R Q' N � _ v �n �n `' :: � � Np aD e0 � Q N l0 � y � _ W Z � j � � Q N V (O (O Z Q W H Z � � � � W � a � � _ � � o � � � N V � � Q N N � N � _ ul O d — .` A 'C � v m � y N N � r o 0 � - o � a W m � � o M � t0 fn Water Maintenance Program 7723 6320-Operating Supplies 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Concept Water S stem Re air Parts 23,316 7,584 23,000 23,000 23,000 23,000 23,000 H drant Re air Su lies 4,267 9,819 5,000 5,000 5,000 5,000 5,000 Landsca e Materials/As halt 13,490 79,469 25,000 40,000 25,000 40,000 40,000 Water Meter/Parts and Su lies 1,101 10,000 10,000 10,000 10,000 10,000 re lacement batteries ortable interro ator-reads meters $41,073 $97,973 $63,000 $78,000 $63,000 $78,000 $78,000 Water Maintenance Program 7123 6340-Professional Services 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Concept Water Connection Fee(State of MN 45,267 45,238 46,000 46,000 46,000 46,000 46,000 Bad er Service Maintenance 989 1,057 1,000 1,200 1,000 1,200 1,200 Water Re air/Leak Detection 3,513 5,211 3,500 3,500 3,500 4,000 4,000 Utilit Permits 215 215 500 300 500 300 300 Miscellaneous Concrete 1,663 536 Misc.Traffice Control, Hi hwa Technolo ies 200 2,398 2,000 2,000 2,000 2,000 2,000 Plumbin 1,022 Bacteria Anal sis moved to 7123.6440 840 1,178 Pum Rentai Dewaterin 4,285 $52,687 $61,140 $53,000 $53,000 $53,000 $53,500 $53,500 Water Maintenance Program 7123 6440-Other Contractual Services 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Conce t Joint Water Contractual Services 252,007 410,764 605,000 605,000 750,000 750,000 750,000 re air um s electricit hone misc contractual services facilitate Cit of Minne olis Governance Task Force re air to Reservoir Contractual Re airs Misc. Concrete and Street 4,091 2,100 1,500 1,500 1,500 Bacteria Anal sis Twin Cit Water Clinic 1,800 3,600 3,600 3,600 4,000 4,000 WSB Carte ra h Mana ement 780 1,500 1,500 $257,898 $413,644 $608,600 $610,100 $753,600 $757,000 $757,000 Water Maintenance Program 7123 6840-Merchandise for Resale(Water) 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Concept Proposed Concept Water Purchases from JWC 2,750,231 2,111,846 2,706,000 2,865,465 2,816,000 2,739,180 2,864,190 Minnea olis Rates 2013-2.67 2012-2.56 2011 2.46 2010 2.37 2009 2.27 2008 2.12 2007 2.06 $2,750,231 $2,111,846 $2,706,000 $2,865,465 $2,816,000 $2,739,180 $2,864,190 CITY OF GOLDEN VALLEV,MINNESOTA WATER AND SEWER UTILITY FUND REVENUE DETAIL Actua12009 Actua12010 Adopted 2011 Estimated 2011 Concepl2012 Proposed 2012 Concept2013 Percent Percent Percent Percent Percent Percent Percent Revenue Amount of Total Amount of Total Amount of Total Amount of Total Amount of Total Amount of Total Amount of Total WaterCharges (1) $4,130,996 52.8% $3,809,608 51.1% $4,304,300 53.9% $3,932,585 50.8% $4,450,000 53.9% $4,022,955 51.8% $4,103,415 51.8% SewerCharges (2) 3,168,607 40.5% 3,149,569 42.3% 3,210,000 40.2% 3,145,620 40.6% 3,325,000 40.3% 3,236,245 41.6% 3,300,970 41.7% Meter Sales 5,336 0.1% 3,793 0.1% 5,000 0.1% 5,800 0.1% 5,000 0.1% 5,000 0.1% 5,000 0.1% MCES Grent Program 70,643 0.9% 13,286 0.2% - 110,790 1.4% - 0.0% - 0.0% - 0.0% LatePaymentPenalties 119,687 1.5% 149,544 2.0% 100,000 1.3% 123,450 1.6% 100,000 12% 120,000 1.5% 120,000 1.5% ChargesForOtherServices 74,892 1.0% 52,866 0.7% 150,000 1.9% 236,000 3.0% 150,000 1.8% 210,000 2.7% 210,000 2.7% StateWaterTestingFeePassThrough 45,234 0.6% 45,657 0.6% 43,000 0.5% 43,000 0.6% 43,000 0.5% 43,000 0.6% 43,000 0.5% Miscellaneous Revenue 49,717 0.6% 104,140 1.4% 40,000 0.5% 7,655 0.1% 40,000 0.5% 10,000 0.1% 10,000 0.1% CeAificateofCompliance 63,850 0.8% 80,325 1.1% 45,000 0.6% 70,000 0.9% 45,000 0.5% 60,000 0.8% 60,000 0.8% InterestEarnings 91,096 12% 41,210 0.6% 85,000 1.1% 65,000 0.8% 100,000 1.2% 65,000 0.8% 65,000 0.8% TOTALS 57,820,058 100.0% 57,449,998 100.0% f7,982,300 100.0% 57.739,900 100.0% 58,258,000 700.0°/a 57,772,200 700.0% 57,977.385 100.0°k Water Rates(1): 4.05/M Gallons RES up to 79,000 gallons up to 79,000 4.18/M Gallons 4.34/M Gallons 4.45/M Gallons RES 80,000 gallons and over 4.21/M Gallons 4.37/M Gallons 4.45/M Gallons IRR all consumption $6 meter+4.21/gallon $6 meter+q.37/gallon $6 meter+4.45/gallon Sewer Rates(2): 56.10 over 20,000 62.00 Winter Quarter Water Consumption: 0-5000 52.00 52.00 52.00 52.00 6000-15,000 56.10 56.10 56.10 56.10 16,000-19,000 62.00 62.00 62.00 62.00 20,000-25,000 65.00 65.00 67.40 69.00 26,000-39,000 72.00 80.00 80.00 40,000-79,000 78.00 40,000-59,000 86.00 98.00 60,000-79,000 92.00 104.00 60,000 and over 84.00 100.00 80,000-99,000 115.00 100,000 and over 127.00 26,000-99,000 68.00 100,000 and over 72.00 Commercial Sewer 325 3.37 3.47 3.57 per thousand gallons CITY OF GOLDEN VALLEY WATER AND SEWER UTILITY FUND NET ASSETS ANALYSIS Net Assets-01/01/11 $7,482,899 Estimated Revenue-2011 $7,739,900 Estimated Expenses-2011 9,113,360 Change in Net Assets Over(Under) Expenses (1,373,460) Net Assets- 12/31/11 6,109,439 Proposed Revenue-2012 7,772,200 Proposed Expenses-2012 8,453,810 Change in Net Assets Over(Under) Expenses (681,610) Net Assets- 12/31/11 $5,427,829 Concept Revenue-2013 7,917,385 Concept Expenses-2013 8,651,855 Change in Net Assets Over(Under) Expenses (734,470) Net Assets - 12/31/13 $4,693,359 Inventory and Accounts Receivable is$1,959,010. CITY OF GOLDEN VALLEY 2012-2013 OPERATING BUDGET Division: Storm Sewer Utility Maintenance(093) 2009 2010 2011 2011 2012 2012 2013 OBJECT DESCRIPTION ACTUAL ACTUAL ADOPTED ESTIMATED CONCEPT PROPOSED CONCEPT Personal Services 6110 Salaries-Regular Employees $183,157 $154,555 $180,485 $135,980 $180,485 $154,615 $154,615 6111 Overtime-Regular Employees 8,049 12,224 10,000 10,000 10,000 10,000 10,000 6130 Salaries-Temporary Employees 3,677 4,636 3,300 4,600 3,300 4,600 4,600 6150 Employee Insurance 30,721 34,839 34,850 32,460 34,850 37,230 37,230 6160 Retirement 25,075 22,371 27,995 20,615 27,995 23,690 23,690 TOTAL Personal Services 250,679 228,625 256,630 203,655 256,630 230,135 230,135 Suoplies and Services 6320 Operating Supplies 8,395 14,371 16,600 18,600 16,600 19,600 19,600 6324 Clothing 150 176 150 50 150 - - 6334 Street Maintenance Materials 7,781 8,656 9,500 9,500 9,500 9,500 9,500 6340 Professional Services 129,550 75,314 246,500 190,000 171,500 171,700 171,700 6342 Postage - - 2,250 2,250 2,250 2,250 2,250 6343 Telephone 218 209 1,100 125 1,100 - - 6344 Use of Personal Auto - 40 200 - 200 - - 6352 General Notices and Publications - - 5,500 5,500 5,500 5,500 5,500 6371 Electric Service 175 294 500 400 500 500 500 6372 Gas Service 244 146 670 400 670 500 500 6375 Waste Disposal - - 500 500 500 500 500 6382 Contractual Maintenance - 4,450 195 - 195 - - 6390 Rentals - 254 1,000 1,000 1,000 1,000 1,000 6411 Conferences and Schools 951 1,220 2,145 220 2,145 400 400 6413 Dues&Subscriptions 181 - 325 150 325 - - 6440 Other Contractual Services 112,052 103,256 109,230 109,230 113,000 140,915 140,915 TOTAL Supplies and Services 259,697 208,386 396,365 337,925 325,135 352,365 352,365 Vehicle Maintenance Charqes 7401 Maintenance Charges-Labor 6,046 9,684 13,250 13,250 13,250 13,250 13,250 7402 Maintenance Charges-Parts 6,817 9,626 8,750 9,750 8,750 8,750 8,750 7403 Motor Fuels 4,480 4,550 8,760 8,760 8,760 8,760 8,760 TOTAL Vehicle Maintenance Chgs 17,343 23,860 30,760 31,760 30,760 30,760 30,760 Caqital Outlav 6960 CapitalOutlay 675,673 818,916 1,623,500 1,521,660 2,776,000 2,376,200 1,525,000 TOTAL Capital Outlay 675,673 818,916 1,623,500 1,521,660 2,776,000 2,376,200 1,525,000 Transfers 7220 Overhead Transfer-General Fund 100,000 100,000 106,000 100,000 112,000 150,000 150,000 TOTAL Transfers 100,000 100,000 106,000 100,000 112,000 150,000 150,000 Debt Services 7310 Debt Service-Principal 270,000 280,000 295,000 295,000 305,000 305,000 320,000 7315 Debt Service-Interest 164,250 147,134 140,300 140,300 128,125 128,125 115,140 7320 Fiscal Charges 976 7,263 2,000 2,000 2,000 2,000 2,000 TOTAL Debt Services 435,226 434,397 437,300 437,300 435,125 435,125 437,140 TOTALS $1,738,618 $1,814,184 $2,850,555 $2,632,300 $3,935,650 $3,574,585 $2,725,400 CITY OF GOLDEN VALLEY 2012-2013 OPERATING BUDGET DIVISION: Storm Sewer Maintenance(093) PROGRAM: Storm Utility(7301) 2009 2010 2011 2011 2012 2012 2013 OBJECT DESCRIPTION ACTUAL ACTUAL ADOPTED ESTIMATED CONCEPT PROPOSED CONCEPT Personal Services 6110 Salaries-Regular Employees $50,684 $42,003 $52,615 $52,615 $52,615 $52,615 $52,615 6111 Overtime-Regular Employees 711 4,412 2,000 2,000 2,000 2,000 2,000 6130 Salaries-Temporary Employees 3,677 4,636 3,300 4,600 3,300 4,600 4,600 6150 Employee Insurance 10,127 12,029 12,100 12,100 12,100 12,600 12,600 6160 Retirement 6,767 6,345 7,895 7,895 7,895 8,500 8,500 TOTAL Personal Services 71,966 69,425 77,910 79,210 77,910 80,315 80,315 Suqolies and Services 6320 Operating Supplies 7,384 14,371 11,000 13,000 11,000 14,000 14,000 6340 Professional Services 7,475 14,368 88,500 86,500 13,500 13,700 13,700 6371 Electric Service 175 294 500 400 500 500 500 6372 Gas Service 244 146 670 400 670 500 500 6375 Waste Disposal - - 500 500 500 500 500 6390 Rentals - 254 1,000 1,000 1,000 1,000 1,000 6440 Other Contractual Service 112,052 103,256 109,230 109,230 113,000 140,915 140,915 TOTAL Supplies and Services 127,330 132,689 211,400 211,030 140,170 171,115 171,115 Caqital Outlav 6960 CapitalOutlay 675,673 818,916 1,623,500 1,521,660 2,776,000 2,376,200 1,525,000 TOTAL Capital Outlay 675,673 818,916 1,623,500 1,521,660 2,776,000 2,376,200 1,525,000 Transfers 7220 Overhead Tra�sfer-General Fund 100,000 100,000 106,000 100,000 112,000 150,000 150,000 TOTAL Transfers 100,000 100,000 106,000 100,000 112,000 150,000 150,000 TOTALS $974,969 $1,121,030 $2,018,810 $1,911,900 $3,106,080 $2,777,630 $1,926,430 � � � � M M V (O c0 n O C N N N p �n in E v � A rn d o � a y � _ y � � N O c0 cD N � � � a � a, ia � N � 2 u'� �n � � � � O G N N N p �n u� U � d � � � � _ d � � � m � � O £ N N N y � � W � N l0 � W U � Q 2 Z W � � � � Z � •� co co � N � � � � Q �» w � d w ;c � � � � O � � _ M M � ; O O O O N Q V � � G1 N � y � _ � � � � O � O V O O N Q � l{') EA N N Q' N d' _ N N O � C w O V c N (Q d C ' V N .� N C � N y O � A N Y � O Of > � � U O � 7 ic a O O M N � � e- V O C � V N O EA U MI Gl l0 E � �o � o � a` _ N O tD cap N Q � fA a m m � � � x 0 0 N � O O � U N C M M O � U d A � y � 2 d o 0 � m � � o £ v v N y EA W N N � y 0_' S � d °o °o (�7 M N � � � � Q N N � W U � Z = W ~ M M Z O � � � � N v � � � a w � d w ;c � � � � O � � _ � � r � o � �O_ � N V M � Q Gl N � y a' x vl O N - .` l0 - �p U N � y N d � �' � O N - O E a w aEi �6 F' o m � � co cn STORM SEWER MAINTENANCE Program 7301 6320-Operating Supplies 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Pro osed Concept Sewer S stem Re air Parts 1,436 7,307 10,000 9,000 10,000 9,000 9,000 re airs from revious PMP ro rams inciudin : catch basin castin s cement rin s i e/culverts Landsca e Materials 5,948 7,064 1,000 4,000 1,000 5,000 5,000 includin : ri ra black dirt as halUconcrete cement sod/ lantin s $7,384 $14,371 $11,000 $13,000 $11,000 $14,000 $14,000 STORM SEWER MAINTENANCE Program 7301 6340-Professional Services 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Proposed Concept Professional Services 500 500 500 500 500 Tra Beaver Contractual Re airs, Liners/Re lacement 10,140 10,500 10,500 10,500 10,500 10,500 Golden Valle Count Club Sum 4,012 Professional Services 2,140 2,000 2,000 2,000 2,000 Boone Storm Lift Electrical Re airs 1,323 500 500 500 500 500 NPDES Phase II Pond Anal sis NURP Ponds 75,000 75,000 New Shaft-Wisconsin Control Gate 2,860 Commitment and Search Packa e 748 Henne in Count Recordin Fees 269 200 200 Towin Stuck Loader 351 $7,475 $14,368 $86,500 $88,500 $13,500 $13,700 $13,700 STORM SEWER MAINTENANCE Program 7301 6371-Electric Service 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Conce t Electric Service on Pum s 175 294 500 400 500 500 500 $175 $294 $500 $400 $500 $500 $500 STORM SEWER MAINTENANCE Program 7301 6372-Gas Service 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Concept Proposed Concept Boone Avenue Lift Station 244 146 670 400 670 500 500 $244 $146 $670 $400 $670 $500 $500 STORM SEWER MAINTENANCE Program 7301 6375-Waste Disposal 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Proposed Conce t Ti in Fees 0 0 500 500 500 500 500 $0 $0 $500 $500 $500 $500 $500 STORM SEWER MAINTENANCE Program 7301 6390-Rentals 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Concept Proposed Conce t Small E ui ment for back ard work 0 254 1,000 1,000 1,000 1,000 1,000 $0 $254 $1,000 $1,000 $1,000 $1,000 $1,000 STORM SEWER MAINTENANCE Program 7301 6440-Other Contractual Services 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Concept Bassett Creek Watershed Mana ement 112,052 103,256 109,230 109,230 113,000 140,915 140,915 Commission $112,052 $103,256 $109,230 $109,230 $113,000 $140,915 $140,915 STORM SEWER MAINTENANCE Program 7301 6960 Capital Outlay 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Pro osed Conce t Pavement Mana ement Pro'ects and various other ro'ects included in CIP. 2009: Residential Storm Sewer Im PMP 639,546 Storm Water Ponds PMP 30,753 Storm Water Dred in 5,464 2010: Residential Storm Sewer Im PMP 718,914 Storm Water Ponds PMP Streambank Stabilization 57,749 Storm Water Dred in 42,253 2011: Residential Storm Sewer Im PMP 600,000 600,000 Streambank Stabilization 786,500 786,500 Storm Water Dred in wait until 2012) 105,000 Groundswee er 35,000 32,700 Tandem Axle V-Box Sander combined) 39,360 Tandem Axle V-Box Sander 23,000 0 Sin le Axle V-Box Sander 20,000 0 DeCola Ponds Storm Water Stud 54,000 54,000 Little Lea ue Fields 9,100 2012: Residential Storm Sewer Im PMP 650,000 800,000 Picku Truck 26,000 26,000 Bassett Creek Streambank Stabilization 1,650,000 730,200 Sin le Axle V-Box Sander 40,000 Sweene Lake Outlet Structure 250,000 Decola Ponds Storm Water Stud 100,000 Wirth Lake Outlet Structure 250,000 Anti Icin Production E ui ment 65,000 Hea Equi ment Mounted Winch 20,000 Fla Avenue Draina e Stud 35,000 Sum Manhole Retrofits 60,000 60,000 2013: Lakeview Park Water Qualit Im rovements 150,000 Brookview Golf Course Buffer Stud 30,000 Residential Storm Sewer Im PMP 1,100,000 10th Avenue Culvert Re airs 185,000 675,763 818,916 1,623,500 1,521,660 2,326,000 2,376,200 1,525,000 City of Golden Valley, Minnesota Capital Improvement Plan Data in Year 2012 and 2013 PROJECTS BY YEAR Project Name Department Project# Priority Project Cost 2012 Residential Storm Sewer Improvements Storm Sewers SS-01 n/a 800,000 Bassett Creek Stream Bank Stabilization Storm Sewers SS-20 n/a 730,200 Pickup Truck(Storm Water Utility) Storm Sewers SS-22 n/a 26,000 V-Box Sander(single) Storm Sewers SS-26 n/a 40,000 DeCola Ponds Storm Water Study Storm Sewers SS-28 n/a 100,000 Sweeney Lake Outlet Structure Storm Sewers SS-29 n/a 250,000 Wirth Lake Outlet Structure Storm Sewers SS-30 n/a 250,000 Winch Mounted on Heavy Equipment Storm Sewers SS-31 n/a 20,000 Anti-Icing Brine Production Room and Equipment Storm Sewers SS-32 nla 65,000 Sump Manhole Retrofits Storm Sewers SS-33 nla 60,000 Flag Avenue Drainage Study Storm Sewers SS-35 nla 35,000 Total for 2012 2,376,200 20� Residential Storm Sewer Improvements Storm Sewers SS-Ol nla 1,100,000 Lakeview Park Water Quality Improvements Storm Sewers SS-10 nla 150,000 Brookview Golf Course-Buffer Zone Study Storm Sewers SS-12 nla 30,000 10th Avenue NoRh Culvert Repairs Storm Sewers SS-24 nla 185,000 Sump Manhole Retrofits Storm Sewers SS-33 nla 60,000 Total for 2013 1,525,000 GRAND TOTAL 3,901,200 Project# SS-�1 � Department Storm Sewers � '�� Contact Project Name RCSI(1Clltla� St01'lll SCWCC Ilri]IPOVCIriCRtS Type Improvement lJseful Life Category Stortn Sewer Priority ' Description �� ___.___ _ �Construction and repair of storm sewer system in conjunction with the Pavement Management Program(see S#1).. _ _ _ I I� Justification �I IProvide an improved storm water runoff drainage system in conjunction with the Pavement Management Program to facilitate surface water runoff,minimize local � Idrainage and flooding issues and protect pavement Expenditures 2012 2013 2014 2015 2016 Total Infrastructure Improvements 800,000 1,100,000 1,100,000 1,100,000 1,100,000 5,200,000 TOt81 800,000 1,100,000 1,100,000 1,100,000 1,100,000 5,200,000 Funding Sources 2012 2013 2014 2015 2016 Total Storm Sewer Utility Fund(730 800,000 1,100,000 1,100,000 1,100,000 1,100,000 5,200,000 TOtal 800,000 1,100,000 1,100,000 1,100,000 1,100,000 5,200,000 Project# SS-IO Department Storm Sewers Contact Project Name Lakeview Park Water Quality Improvements Type Improvement Useful Life Category Stortn Sewer Priority Description ' Water quality improvements in Lakeview Park to improve water quality in Medicine Lake.The scope of this project is to be determined during preliminary project design. , � Justification ' To reduce nutrients and sediment from storm water runoff in the Lakeview Heights area that drains to Medicine Lake.This project will be consistent with the 1 Medicine Lake Total Maximin Daily l,oad(TMDL)Implementation Plan. �� Expenditures 2012 2013 2014 2015 2016 Total Infrastructure Improvements 150,000 150,000 Total 150,000 150,000 Funding Sources 2012 2013 2014 2015 2016 Total Storm Sewer Utility Fund(730 150,000 150,000 Total 750,000 150,000 I, Project# SS-iZ Department Storm Sewers Contact j Project Name Brookview Golf Course-Buffer Zone Study Type Improvement Useful Life Category Storm Sewer Priority I Description , Perform a study in 2013 to identify locations for the development of native vegetation buffer areas in Brookview Golf Course.Construction of the buffer areas in �I2014. I Justification IRemoval of nutrients and sediment from stormwater runoff entering golf course ponds and Bassett Creek. I Expenditures 2012 2013 2014 2015 2016 Total Infrastructure Improvements 30,000 250,000 280,000 Total 30,000 250,000 280,000 Funding Sources 2012 2013 2014 2015 2016 Total Storm Sewer Utility Fund(730 30,000 250,000 280,000 Total 30,000 250,000 280,000 Project# SS-2� Department Storm Sewers Contact Project Name Bassett Creek Stream Bank Stabilization T ype Improvement Useful Life Category Storm Sewer Priority Description Stabilize banks along sub reaches of E3assett Creek Main Stem.Need is based on the Bassett Creek Inventory which was completed in 2001 and is updated on an � annual basis. 2012: Main Stem(Between Duluth Street and 26th Avenue)-Subreach 2 � Justification The Bassett Creek Watershed Management Commission has additional funding for stabilization of the stream banks thorughout the watershed.Based upon the ' availability of funding the Commission has added the portion of Bassett Creek in Golden Valley between TH 169 and the north Ciry Limits just north of Westbrook ' Road.The project funding is available beginning in 2011 and 2012. Expenditures 2012 2013 2014 2015 2016 Total Infrastructure Improvements 730,200 730,200 Total 730,200 730,200 Funding Sources 2012 2013 2014 2015 2016 Total Bassett Creek Watershed Mg 580,200 580,200 Storm Sewer Utility Fund(730 150,000 150,000 Total 730,200 730,200 Project# SS-22 Department Storm Sewers Contact Project Name pickup Truck(Storm Water Utility) TyPe Equipment Useful Life Category Vehicles Priority Description One half ton pickup truck for the Storm Water Management and other environmental activi[ies to replace Unit#501 (2000 Ford F-150). J i Justification ', Ilncreased repair and maintenance expenditures on Unit#501,which will be twelve years old. I Expenditures 2012 2013 2014 2015 2016 Total EquipNehicles/Furnishings 26,000 26,000 Total 26,000 26,000 Funding Sources 2012 2013 2014 2015 2016 Total Storm Sewer Utility Fund(730 26,000 26,000 Total 26,00o zs,000 ! Project# SS-24 I� Department Storm Sewers i Contact �, ero�e�t Name lOth Avenue North Culvert Repairs � Type tmpro�ement Useful Life Category Storm Sewer Priority Description ' IRepair Culverts that convey E3assett Creek under lOth Avenue North and the Union Pacific Railroad. '� Justification � These culverts are technically classitied as a bridge by the Minnesota Department of Transportation and are inspected regularly.The last inspection identified high I level corrosion of the culverts at the base flow level.Although not a high risk for collapse,the corrosion needs to be addressed soon.These culverts are owned by the railroad. Expenditures 2012 2013 2014 2015 2016 Total Construction/Maintenance 185,000 185,000 Total 185,000 185,000 Funding Sources 2012 2013 2014 2015 2016 Total Union Pacific Railroad 185,000 185,000 Total 185,000 185,000 Project# ss-26 ', Department Stortn Sewers i Contact Project Name V-Box Sander(single) Type Equipment LJseful Life Category Storm Sewer Priority Description �I V-Box sander with hook frame for the single axle dump truck#778. � I Justification 'V-Box sanders are the most efficient and cost effective way to apply the de-icing chemicals for winter operations.V-Box sanders will reduce the impacts of de-icing ,chemicals on local lakes and streams. Expenditures 2012 2013 2014 2015 2016 Total Equip/Vehicles/Furnishings 40,000 40,000 Total a0,0o0 ao,000 Funding Sources 2012 2013 2014 2015 2016 Total Storm Sewer Utility Fund(730 40,000 40,000 Total 40,000 40,000 Project# SS-2g Department Storm Sewers Contact Project Name DeCola Ponds Storm Water Study Type Improvement Useful Life Category Storm Sewer Priority Description �Perform a Hydrologic,Hydraulic,and Flood Mitigation Study of the DeCola Ponds subwatershed,located in the north central portion of the City.This study will Idevelop the storm water runoff models for this area,including inflows from New Hope and Crystal,and will investigate storm water management strategies for the I Winnetka Ave and Medicine Lake Road intersection and residential areas around the DeCola Ponds. Additional study is needed in 2012 to further identify measures to mitigate flood damage at Decola Ponds and the Medicine Lake Road and Winnetka Avenue areas. '�, 7'his study will examine future land uses,retrofitting existing land uses,structural floodproofing and other measures to reduce and mitigate flooding impacts. ', Justification This study will give information to proceed to make appropriate improvements. Expenditures 2012 2013 2014 2015 2016 Total Planning/Design 100,000 100,000 Total 100,000 100,000 Funding Sources 2012 2013 2014 2015 2016 Total Storm Sewer Utility Fund(730 100,000 100,000 Total 100,000 100,000 Project# SS-29 Department Storm Sewers i Contact Project Name Sweeney Lake Outlet Structure � Type Improvement Useful LiPe Category Storm Sewer Priority � Description � Reconstruction of the outlet structure from Sweeney Lake to a permanent weir. � Justification ' Based upon a request by the City of Golden Valley,the Bassett Creek Watershed Management Commission has included the reconstruction of the Sweeney Lake outlet in its CIP.The current structure is hand placed concrete that is subject to modification and erosion around each end of the structure.The new structure will include engineering cut off walls to prevent flow around the ends of and under the structure,greatly reducing the threat of erosion. Expenditures 2012 2013 2014 2015 2016 Total Infrastructure Improvements 250,000 250,000 Total 250,000 250,000 Funding Sources 2012 2013 2014 2015 2016 Total Bassett Creek Watershed Mg 250,000 250,000 Total 250,000 250,000 Project# SS-3� Department Storm Sewers Contact Pro�ect Name wirth Lake Outlet Strueture Type unass�gned Llseful Life Category Unassigned Priority Description �� Reconstruction of the ouUet structure from Wirth Lake to prevent high water backtlow from Bassett Creek from entering the lake. I � Justification The Total Maximum Daily Load Study for Wirth Lake identified the backflow of flood waters from the Bassett Creek into Wirth Lake as the primary phosphorus I load to the lake,resulting in failure to achieve water quality goals.A backflow prevention device was identified as part of the study and has been included in the �Bassett Creek Water Management Commission CIP.The City of Golden Valley will be the lead agency in implementing this project. Expenditures 2012 2013 2014 2015 2016 Total Infrastructure Improvements 250,000 250,000 Total 250,000 250,000 Funding Sources 2012 2013 2014 2015 2016 Total Bassett Creek Watershed Mg 250,000 250,000 Total 250,000 250,000 II Project# SS-31 �i Department Storm Sewers Contact I P'"o�e�t Na"'e Winch Mounted on Heavy Equipment � Type un�s�gnea Useful Life Category Unassigned Priority ' Description IA winch that mounts on heary equipment for storm tree damage removal from Bassett Creek —� Justification Downed trees obstruct the flow in Bassett Creek creating flooding situations and require removal from the creek to establish flows. 1 Expenditures 2012 2013 2014 2015 2016 Total Equip/Vehicles/Furnishings 20,000 20,000 Total 20,000 20,000 Funding Sources 2012 2013 2014 2015 2016 Total Storm Sewer Utility Fund(730 20,000 20,000 Total 20,000 20,000 Project# SS-32 i Department Storm Sewers Contact Project Name Anti-Icing Brine Production Room and Equipment �I Type Unassigned Oseful Life Category Unassigned Priority Description , Construct a room at the I Oth Ave storage to house brine production equipment and storage tanks. Justification Anti-icing brine production for reducing anti-icing/de-icing chemical application on city streets to reduce the impacts of de-icing chemicals in oiu creeks,lakes and wetlands. The brine production equipment was obtained at no cost from another city.This community replaced and upgraded their equipment to increase de-icing capacity. Expenditures 2012 2013 2014 2015 2016 Total Equip/Vehicles/Furnishings 65,000 65,000 Total 65,000 65,000 Funding Sources 2012 2013 2014 2015 2016 Total Storm Sewer Utility Fund(730 65,000 65,000 Total 65,000 65,000 Project# SS-33 Department Storm Sewers Contact � Pro�e�r Na"'e Sum Manhole Retrofits � Type Improvement Useful Life Category Storm Sewer Priority Description Installation of baffles to increase the removal efficiency of existing sump manholes in the storm sewer system. Justification Manhole and catch basin baflles will improve the removal efficiencies for suspended solids and phosphorus.►nstallation priorities will be in the Sweeney Lake and jMedicine Lake sub-watersheds,where TMDL studies have been completed and approved. Expenditures 2012 2013 2014 2015 2016 Total Other 60,000 60,000 60,000 60,000 60,000 300,000 Total so,000 so,000 so,000 so,000 s0,0oo 300,000 Funding Sources 2012 2013 2014 2015 2016 Total Storm Sewer Utility Fund(730 60,000 60,000 60,000 60,000 60,000 300,000 Total so,000 so,000 so,000 so,000 s0,o0o 300,000 Project# SS-35 Department Storm Sewers Contact Pro�e��N�"'e Flag Avenue Drainage Study Type Unassigned Useful Life Category Unassigned Priority , Description IPreparation of a drainage study in the vacinity of Flag Avenue between Earl Street and Duluth Street. J ___ _ ___ _.__ �i Justification ', IThis study will address surface water runoff and ground water issues prior to the scheduled 2015 Pavement Management Program. li Expenditures 2012 2013 2014 2015 2016 Total Other 35,000 35,000 Total 35,000 35,000 Funding Sources 2012 2013 2014 2015 2016 Total Storm Sewer Utility Fund(730 35,000 35,000 Total 35,000 35,000 STORM SEWER MAINTENANCE Program 7301 7220-Overhead Transfer-General Fund 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Pro osed Conce t Transfer to General Fund 100,000 100,000 100,000 100,000 100,000 150,000 150,000 Transfers to Storm Utilit Fund 6,000 12,000 $100,000 $100,000 $106,000 $100,000 $112,000 $150,000 $150,000 CITY OF GOLDEN VALIEY 2012-2013 OPERATING BUDGET DIVISION: Storm Sewer Utility(093) PROGRAM: Street Cleaning(7302) 2009 2010 2011 2011 2012 2012 2013 OBJECT DESCRIPTION ACTUAL ACTUAL ADOPTED ESTIMATED CONCEPT PROPOSED CONCEPT Personal Services 6110 Salaries-Regular Employees $57,463 $37,203 $52,000 $52,000 $52,000 $52,000 $52,000 6111 Overtime-Regular Employees 7,338 7,812 8,000 8,000 8,000 8,000 8,000 6150 Employee Insurance 11,287 11,711 11,800 16,120 11,800 16,120 16,120 6160 Retirement 8,150 5,731 8,150 8,150 8,150 8,150 8,150 TOTAL Personal Services 84,238 62,457 79,950 84,270 79,950 84,270 84,270 Supalies and Services 6334 Street Maintenance Materials 7,781 8,656 9,500 9,500 9,500 9,500 9,500 TOTAL Supplies and Services 7,781 8,656 9,500 9,500 9,500 9,500 9,500 Vehicle Maintenance Charpes 7401 Maintenance Charges-Labor 5,488 9,222 12,500 12,500 12,500 12,500 12,500 7402 Maintenance Charges-Parts 6,631 8,893 8,000 9,000 8,000 8,000 8,000 7403 Motor Fuels 4,136 3,955 7,510 7,510 7,510 7,510 7,510 TOTAL Vehicle Maintenance Chgs 16,255 22,070 28,010 29,010 28,010 28,010 28,010 TOTALS $108,274 $93,183 $117,460 $122,780 $117,460 $121,780 $121,780 .. NI O O M M V O O � O C N N N p � u� � U � tC Cf � O N a` � N � x N O O O N � � � a � m m � � � x 0 0 N d O O � V O C N N N p u� u� U � d Y R � � � _ G7 Q O � � O O O E N N N y � tn W � N i0 � N � _ � N O O O O N � 1N IN Q � G1 N � N d' _ M M O � � � � N N � O I� I� Z N Q M (7 Z � Q W y J U � H W W y � � H = � M M � � V V O � O V 1� I� N Q � � EA d N � N Q' 2 N N O � � C w Vl � V N C � .0 C O N � C � N � � W � N � Y � 7 Q y � N � U (n O � 7 �n a STREET CLEANING Program 7302 6334-Street Maintenance Materials 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Concept Brooms for all Swee ers 7,781 8,655 9,500 9,500 9,500 9,500 9,500 $7,781 $8,655 $9,500 $9,500 $9,500 $9,500 $9,500 CITY OF GOLDEN VALLEY 2012-2073 OPERATING BUDGET DIVISION: Storm Sewer Utility(093) PROGRAM: Environmental Control(7303) 2009 2010 2011 2011 2012 2012 2013 OBJECT DESCRIPTION ACTUAL ACTUAL ADOPTED ESTIMATED CONCEPT PROPOSED CONCEPT Personal Services 6110 Salaries-Regular Employees $75,010 $75,349 $75,870 $31,365 $75,870 $50,000 $50,000 6150 Employee Insurance 9,307 11,099 10,950 4,240 10,950 8,510 8,510 6160 Retirement 10,158 10,295 11,950 4,570 11,950 7,040 7,040 TOTAL Personal Services 94,475 96,743 98,770 40,175 98,770 65,550 65,550 Supplies and Services 6320 Operating Supplies 1,011 - 5,600 5,600 5,600 5,600 5,600 6324 Clothing 150 176 150 50 150 - - 6340 Professional Services 122,075 60,946 158,000 103,500 158,000 158,000 158,000 6342 Postage - - 2,250 2,250 2,250 2,250 2,250 6343 Telephone 218 209 1,100 125 1,100 - - 6344 Use of Personal Auto - 40 200 - 200 - - 6352 General Notices 8 Public Information - - 5,500 5,500 5,500 5,500 5,500 6382 Contractual Maintenance - 4,450 195 - 195 - - 6411 Conferences and Schools 951 1,220 2,145 220 2,145 400 400 6413 Dues&Subscriptions 181 - 325 150 325 - - TOTAL Supplies and Services 124,586 67,041 175,465 117,395 175,465 171,750 171,750 Vehicle Maintenance Charqes 7401 Maintenance Charges-Labor 558 462 750 750 750 750 750 7402 Maintenance Charges-Parts 186 733 750 750 750 750 750 7403 Motor Fuels 344 595 1,250 1,250 1,250 1,250 1,250 TOTAL Vehicle Maintenance Chgs 1,088 1,790 2,750 2,750 2,750 2,750 2,750 TOTALS $220,149 $165,574 $276,985 $160,320 $276,985 $240,050 $240,050 0 0 M M d O O V M N p � � � U � m rn °/ o ie a` � y a x d o 0 N p O O � O ��[7 � N � a d A � � � x 0 0 � � � � o c ui u� N p t� 1� V � G7 N 0.' N d' _ d � � � � M M o E - - N N M M W � N � G.' N � _ v o 0 � � � � o p �ri �ri N � 1� 1� Q � d N � J � Q = � H Z � � O O � M M U Q N a '� � � z w d � m z � 0 � � > � z = w 0 0 °' 10 0 0 o � O V Ln � N Q 1� I� � N N � N � _ c 0 0 N � � - C - �1 U A y O � � O y U m tb � c � a� c �, E � o °°'' O C � — C C c0 W W ENVIRONMENTAL CONTROL Program 7303 6320-Operating Supplies 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Conce t Office Su lies 25 0 200 200 200 200 200 Presentation Su lies 100 100 100 100 100 Storm Draina e Stencilin Pro'ects 300 300 300 300 300 Buckthorn Pro ram 222 5,000 5,000 5,000 5,000 5,000 Com uter 764 $1,011 $0 $5,600 $5,600 $5,600 $5,600 $5,600 ENVIRONMENTAL CONTROL Program 7303 6324-Clothing 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Concept Safet Shoes/Safet Wear Env Coordinator 150 176 150 50 150 - - $150 $176 $150 $50 $150 $0 $0 ENVIRONMENTAL CONTROL Program 7303 6340-Professional Services 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Concept Professional Services for addressin NPDES 3,387 5,869 44,500 44,500 54,500 54,500 Phase II Water Qualit and Water Quantit Concerns. case contested in 2011 Native Buffer Zone Maintenance for Ponds 20,981 20,278 27,000 27,000 27,000 27,000 27,000 Wetland Bankin Monitorin Re ortin 5 Years 2,238 2,700 4,500 4,500 4,500 4,500 4,500 General Milis and Minna ua Naturat Area ($4,000 First ear-2007. 2,000 for each of the remainin four ears S ecial Assessment for Ponds 71,061 32,099 72,000 72,000 72,000 72,000 72,000 U date Surface Water Mana ement Plan for 23,126 Completion of Cit Com rehensive Plan Deve�o Storm Water Ordinance 1,282 10,000 10,000 $122,075 $60,946 $158,000 $103,500 $158,000 $158,000 $158,000 ENVIRONMENTAL CONTROL Program 7303 6342-Postage 2009 2010 2011 2011 2012 2072 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Conce t Water Resource Education 0 0 2,250 2,250 2,250 2,250 2,250 Fertilizer Brochure Newsletter Articles NPDES Phase II Education $0 $0 $2,250 $2,250 $2,250 $2,250 $2,250 ENVIRONMENTAL CONTROL Program 7303 6343-Telephone 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Concept Environmental Coordinator 218 209 1,100 125 1,100 - - $218 $209 $1,100 $125 $1,100 $0 $0 ENVIRONMENTAL CONTROL Program 7303 6344-Use of Personal Auto 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Pro osed Concept Milea e Reimbursement 0 40 200 0 200 - - $0 $40 $200 $0 $200 $0 $0 ENVIRONMENTAL CONTROL Program 7303 6352-General Notices and Public Information 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Concept Proposed Concept Water Resource Education: 0 0 5,500 5,500 5,500 5,500 5,500 Gradin Permit cover Fertilizer Brochure Sum Pum s Phase II $0 $0 $5,500 $5,500 $5,500 $5,500 $5,500 ENVIRONMENTAL CONTROL Program 7303 6382-Contractual Maintenance 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Pro osed Concept 800 MHz Radio Environmental Coordinator 0 195 0 195 - - K le Avenue Storm Sewer Pro'ect 4,450 $0 $4,450 $195 $0 $195 $0 $0 ENVIRONMENTAL CONTROL Program 7303 6411-Conferences and Schools 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Pro osed Conce t MPWA S rin Conference 500 500 U of M Tree Ins ector Certification 165 165 125 165 125 Mana ement Worksho s 311 200 200 Environmental Trainin 250 680 1,100 1,100 MPWA Fall Conference 225 220 220 MN Societ of Arboriculture 40 Erosion Control Trainin Ins ections De t 375 400 400 LMC Safet Trainin 15 $951 $1,220 $2,145 $220 $2,145 $400 $400 ENVIRONMENTAL CONTROL Program 7303 6413-Dues and Subscriptions 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Pro osed Concept APWA Lundstrom 141 0 145 150 145 0 0 Water Resource Periodicals Lundstrom) 50 50 Erosion Control Periodicals Lundstrom 45 45 MECA Membershi Lundstrom 35 35 International Societ of Arboculture 40 50 50 $181 $0 $325 $150 $325 $0 $0 CITY OF GOLDEN VALLEY 2012-2013 OPERATING BUDGET DIVISION: Storm Sewer Utility(093) PROGRAM: Debt Service(7304) 2009 2010 2011 2011 2012 2012 2013 OBJECT DESCRIPTION ACTUAL ACTUAL ADOPTED ESTIMATED CONCEPT PROPOSED CONCEPT Personal Services 7310 Debt Service-Principal $270,000 $280,000 $295,000 $295,000 $305,000 $305,000 $320,000 7315 Debt Service-Interest 164,250 147,134 140,300 140,300 128,125 128,125 115,140 7320 Fiscal Charges 976 7,263 2,000 2,000 2,000 2,000 2,000 TOTAL Debt Services $435,226 $434,397 $437,300 $437,300 $435,125 $435,125 $437,140 Program 7304 7310-Bond Principal Payments 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Proposed Concept 2004 C Storm Sewer Utilit Bonds 170,000 175,000 185,000 185,000 190,000 190,000 200,000 matures 02/01/2019 2006 C Storm Sewer Utilit Bonds 100,000 105,000 110,000 110,000 115,000 115,000 120,000 matures 02/01/2021 $270,000 $280,000 $295,000 $295,000 $305,000 $305,000 $320,000 Program 7304 7315-Bond Interest Payments 2009 2010 2011 2010 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Pro osed Concept 2004 C Storm Sewer Utilit Bonds 94,343 87,656 80,456 80,456 72,837 72,837 64,670 matures 02/01/2019 2006 C Storm Sewer Utilit Bonds 69,907 59,478 59,844 59,844 55,288 55,288 50,470 matures 02/01/2021 $164,250 $147,134 $140,300 $140,300 $128,125 $128,125 $115,140 Program 7304 7320-Fiscal Agency Costs 2009 2010 2011 2010 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Concept 2004 C Storm Sewer Utilit Bonds 531 845 1,000 1,000 1,000 1,000 1,000 matures 02/01/2019 2006 C Storm Sewer Utilit Bonds 445 431 1,000 1,000 1,000 1,000 1,000 matures 02/01/2021 Arbitra e Re ortin 5,987 $976 $7,263 $2,000 $2,000 $2,000 $2,000 $2,000 CITY OF GOLDEN VALLEY STORM SEWER UTILITY FUND REVENUE DETAIL Actua12009 Aetua12070 Adopted 2011 Estimated 2011 Concept2072 Proposed 2012 Concept2073 Peroent Percent Percent Percent Percenl Percent Percent Revenue Amount of Total Amount of Total Amount of Total Amount of Total Amount of Total Amount of Total Amount of Total StormSewerCharges (1) $2,265,937 93.9% $2,279,838 982% $2,212,150 74.3% $2,228,920 74.7% $2,212,150 56.0% $2,228,920 66.6% $2,228,920 982% State of Minnesota 56,081 2.3% - O.Oq Bassett Creek Watershed Commission 0 0.0% - O.OM 715,000 24.0% 715,000 24.0% 1,500,000 38.0% 1,080,200 32.3% 0.0% Other - 568 - - 185,000 4.7% 0.0% 0.0% Transfer From Conservation/ RecylingFund 7,000 0.3% - 0.0% - 0.0% 0 0.0% 0 0.0% - 0.0% - 0.0% InterestEamings 85,045 3.5% 41,575 1.Sq 50,000 1.7q 40,000 �.3% 50,000 1.3q 40,000 1.2% 40,000 1.8% TOTALS 52,414,063 100.0% 52,321,981 100.0% =2,977,150 100.0% 52,983,920 100.0% 53,947,150 100.0% 53,349,120 100.0% 52,268,920 100.0% (1)Storm SewerRates 2009 2010 2011 2012 2013 Residential Property per Quarter $22 $22 $22 $22 $22 Commercial Property per Acre per Month $110 $110 $110 $110 $110 CITY OF GOLDEN VALLEY STORM SEWER UTILITY FUND NET ASSETS ANALYSIS Net Assets @ 01/01/11 $4,217,997 Estimated Revenue-2011 $2,983,920 Estimated Expenses-2011 2,632,300 Excess of Revenue Over(Under) Expenses 351,620 Estimated Net Assets @ 12/31/11 4,569,617 Proposed Revenue-2012 3,349,120 Proposed Expenses -2012 3,574,585 Excess of Revenue Over(Under) Expenses (225,465) Projected Net Assets @ 12/31/12 $4,344,152 Concept Revenue-2013 2,268,920 Conceptd Expenses-2013 2,725,400 Excess of Revenue Over(Under) Expenses (456,480) Projected Net Assets @ 12/31/13 $3,887,672 CITY OF GOLDEN VALLEY 2072-2013 OPERATING BUDGET Division: Vehicle Maintenance(070) Program: Vehicle Maintenance(8200) 2009 2010 2011 2011 2012 2012 2013 OBJECT DESCRIPTION ACTUAL ACTUAL ADOPTED ESTIMATED CONCEPT PROPOSED CONCEPT Personal Services 6110 Salaries-Regular Employees $189,437 $172,650 $198,740 $173,810 $202,715 $186,110 $186,110 6111 Overtime-Regular Employees 1,527 3,511 3,000 3,000 3,000 3,000 3,000 6130 Salaries-Temporary Employees 7,279 2,429 5,860 16,455 5,860 5,860 5,680 6150 Employee Insurance 32,169 29,567 38,900 35,600 39,370 39,370 39,370 6160 Retirement 25,343 23,384 30,845 30,845 31,845 31,845 31,845 TOTAL Personal Services 255,755 231,541 277,345 259,710 282,790 266,185 266,005 Suqplies and Services 6320 Operating Supplies 8,106 5,148 7,700 7,700 7,700 7,700 7,700 6324 Clothing 1,935 2,284 2,650 3,200 2,650 3,200 3,200 6331 Equipment Parts (1,682) 238 5,000 4,000 5,000 4,000 4,000 6343 Telephone 320 209 400 400 400 300 300 6382 Contractual Maintenance (306) 3,728 10,700 10,275 10,700 11,300 11,350 6390 Rentals 23,213 23,300 23,200 23,300 23,200 23,300 23,300 6411 Conferences and Schools 462 283 870 620 870 870 870 6413 Dues and Subscriptions - 135 310 310 310 310 310 6414 Licenses and Taxes 123 123 240 450 240 225 225 TOTAL Supplies and Services 32,171 35,448 51,070 50,255 51,070 51,205 51,255 Caqital Outlav 6960 CapitalOutlay - - - - - 8,000 - TOTAL Capital Outlay - - - - - 8,000 - Vehicle Maintenance 7401 Maintenance Charges-Labor 1,701 2,595 2,500 2,500 2,500 2,500 2,500 7402 Maintenance Charges-Parts 1,682 1,431 2,500 2,500 2,500 2,500 2,500 7403 Motor Fuels 706 921 1,000 1,000 1,000 1,000 1,000 TOTAL Vehicle Maintenance Chgs 4,089 4,947 6,000 6,000 6,000 6,000 6,000 TOTALS 292,015 271,936 334,415 315,965 339,860 331,390 323,260 oD N O � O N � V �M O r � � pp O C � � O tD N p r � ao E V � � Of °= a�o o�o a � N N � � V 2 � N o0 N O � O N O M O r � O � O O CO N � 1� � a0 a �;, m �n � � � � � N N N (�O O 2' V _ � � N a0 � N G7 � O � f� � V O C V O a0 N N � r N f) y) d r N � � � _ N a0 � I� � O � j0 O M [O M I� I� � CO O � � f� O M N y f� O� � I� Il.l � y u� u� � � � � N N � = M � � G7 O� M M V O �fl I� N � r � � � � Q � G7 � �'1 � V V � � � N N � (O V � � 2 � � N I� O � j � O � f0 O V V O N N Q I� � � N �C7 A � � N N O � � S � � M � M O 7 O N V O V V O � � N Q f� a0 V3 GI � � � V V � � � N N y � m a' x v a� U � � � C O � L � N N � � C O � @ N — C � N E l4 0 N � w N O O C � N � � E C � y � c U N O N C C (6 N C C � 47 7 (6 d � N � C O � N N d C O V �> N 'p N > L 7 tD � d � CO a o 0 NI � U � 0�0 � NC � b9 O � V 16 � w O � a N � x N O a�0 a�O � o a �ri ui N � EA a d A � N � 2 w N y � � � V O C �C1 � N p tA U a� « R � N � x d o �n �n � m � � v o � ui o co N N W � d r � � N � N � � _ � W CO (D � a W N O p � � N y EA Q N W � � � _ m � O � � � � 7 N V N � Q d �+ l6 � h � _ � W R � n � � N N o r r N Q EA d l0 � N � S N O a o E d _ w •� a 3 A - a� m uf y y ? Z' o o � m — � � w � y �c m � o ° M � � �O (n F- Program 8201 6320-Operating Supplies 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Conce t Weldin , Grindin , Machinin 259 476 600 600 600 600 600 Medical Su lies 85 200 200 200 200 200 Tools/Parts 1,682 2,080 2,400 2,400 2,400 2,400 2,400 Sho E ui ment 2,000 4,000 2,000 4,000 4,000 Su lies 1,283 1,200 2,500 2,500 Used Filters 621 512 Plasma Machine Air D er Com uter 1,382 Carte ra h S stem 2,794 880 500 500 500 $8,106 $5,148 $7,700 $7,700 $7,700 $7,700 $7,700 Program 8201 6324-Clothing 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Pro osed Conce t 3 Mechanic Rental Uniforms 1,791 2,114 1,800 2,200 1,800 2,200 2,200 Additional Clothin Items: 200 200 200 200 200 Safet Boots 3 em lo ees X$150/em l0 144 144 450 450 450 450 450 Gloves 26 100 250 100 250 250 Weldin A arel 100 100 100 100 100 $1,935 $2,284 $2,650 $3,200 $2,650 $3,200 $3,200 Program 8201 6331-Equipment Parts 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Conce t Parts that are needed to re air 1,682 238 5,000 4,000 5,000 4,000 4,000 vehicles that are not billed directl to the vehicle. $1,682 $238 $5,000 $4,000 $5,000 $4,000 $4,000 Program 8201 6343-Telephone 2009 2010 2011 2071 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Pro osed Concept Cell Phone for Steve Loomis 320 209 400 300 400 300 300 Vehicle Maintenance Foreman $320 $209 $400 $300 $400 $300 $300 Program 8201 6382-Contractual Maintenance 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Conce t Contractual Work to Sho Area 1,266 3,146 10,000 9,000 10,000 10,000 10,000 hoist re air, cranes, etc. 800 Mhz Radio Maint. (Henn Co$175/Radio X 960 582 700 575 700 600 650 Used Oil Filters/Floor D /Tire Rec clin 700 700 700 moved from 6320 $306 $3,728 $10,700 $10,275 $10,700 $11,300 $11,350 Program 8201 6390-Rentals 2009 2010 2011 2017 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Pro osed Conce t Rental Char e for Sho Buildin 22,000 22,000 22,000 22,000 22,000 22,000 22,000 Miscellaneous E ui ment Rental 1,213 1,300 1,200 1,300 1,200 1,300 1,300 $23,213 $23,300 $23,200 $23,300 $23,200 $23,300 $23,300 Program 8201 6411-Conferences and Schools 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Pro osed Concept Su ervisor Trainin Loomis 100 91 100 100 100 100 100 Safet Trainin All Vehicles Sta 36 185 185 185 185 185 Mechanic Trainin Fadden, Goddard) 95 100 100 100 100 100 APWA National Conference MPWA S rin Conference Loomis 250 250 250 250 APWA Snow Conference Fall Maintenance Ex o 75 75 100 100 100 100 100 Audiometric Examinations 56 60 60 60 60 60 Minnesota Truckin Assoc 75 75 75 75 75 75 CPR Trainin 81 MSSA 61 $462 $283 $870 $620 $870 $870 $870 Program 8201 6413-Dues and Subscriptions 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Concept Proposed Conce t APWA Membershi Loomis) 0 135 135 135 135 135 135 Sho Manuals All Vehicles Sta 100 100 100 100 100 MSSA MN Street Su erv Assoc Loomis 75 75 75 75 75 $0 $135 $310 $310 $310 $310 $310 Program 8201 6414-Licenses and Taxes 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Adopted Estimate Conce t Proposed Concept Hazardous Waste License Henn Co 53 53 100 60 100 60 60 Hazardous Waste Tax 70 70 70 70 70 Boiler License 20 45 20 45 20 45 45 Fuel License 25 25 250 25 25 25 Fuel Tax License 25 25 25 25 25 25 25 $123 $123 $240 $450 $240 $225 $225 Program 8201 6960-Capital Outlay 2009 2010 2011 2011 2012 2012 2013 Descri tion Actual Actual Ado ted Estimate Conce t Pro osed Conce t Picku Truck - - 0 0 0 0 0 S ecialt Tor ue Wrench 8,000 $0 $0 $0 $0 $0 $8,000 $0 CITV OF GOLDEN VAILEY VEHICLE MAINTENANCE FUND REVENUE DETAIL Aetua12009 Actua12070 Adopted 2071 Estimated 2017 Concept2012 Proposed 2012 Concept2013 Percent Percent Percent Percent Percent Percent Percent Revenue Amount of Total Amount of Total Amount of Tolal Amount of Total Amount of Total Amount of Total Amount of Total Charges To Other Funds (1) 292 015 100.0% 273 783 100.0% 334 415 100.0% 31$ 5.965 100.0% 339 860 100.0% 331 390 100.0% 33$9 860 100.0% TOTALS f292.015 700.0% E273.783 100.0% E334.415 100.0% f315.965 100.0% E339.860 100.0% f331.390 700.0% 33 100.0% (1)Per hour labor rates charged to departments: 2009 2010 2011 2012 2013 $72 $76 $80 S82 $85 CITY OF GOLDEN VALLEY VEHICLE MAINTENANCE FUND NET ASSETS ANALYSIS Net Assets @ 01/01/11 $184,757 Estimated Revenue - 2011 $315,965 Estimated Expenditures - 2011 315,965 Excess of Revenue Over (Under) Expenditures 0 Estimated Net Assets @ 12/31/11 184,757 Proposed Revenue - 2012 331,390 Proposed Expenditures - 2012 331,390 Excess of Revenue Over (Under) Expenditures 0 Projected Net Assets @ 12/31/12 $184,757 Concept Revenue - 2013 339,860 Concept Expenditures - 2013 323,260 Excess of Revenue Over (Under) Expenditures 16,600 Projected Net Assets @ 12/31/13 $201,357 I nventory at 01/01/11 was at $150,348