Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
07.23.12 Work Session Packet
City of Farmington Mission Statement 430 Third Street Through teamwork and cooperation, Farmington,MN 55024 the City of Farmington provides quality services that preserve our proud past and foster a promising future. AGENDA CITY COUNCIL WORKSHOP July 23, 2012 6:30 p.m. 1. CALL TO ORDER 2. APPROVE AGENDA 3. 431 THIRD STREET PROPERTY 4. PARKS AND RECREATION DEPARTMENT 2013/2014 BUDGET DISCUSSION 5. 2013/2014 ADMINISTRATION RELATED BUDGETS 6. CITY ADMINISTRATOR UPDATE 7. ADJOURN PUBLIC INFORMATION STATEMENT Council workshops are conducted as an informal work session.All discussions shall be consideredfact-finding,hypothetical and unofficial critical thinking exercises,which do not reflect an official public position. Council work session outcomes should not be construed by the attending public and/or reporting media as the articulation of a formal City policy position. Only official Council action normally taken at a regularly scheduled Council meeting should be considered as a formal expression of the City's position oii any given matter. 4iAR4fiy City of Farmington U 'z 430 Third Street P „ Farmington, Minnesota 1‘ . 651.280.6800•Fax 651.280.6899 '' PR°"' www.ciSarmington.mn.us TO: Mayor, Council Members and City Administrator FROM: Randy Distad, Parks and Recreation Director SUBJECT: 431 Third Street Property DATE: July 23, 2012 INTRODUCTION The City currently owns property at 431 Third Street. DISCUSSION Staff solicited and received a Limited Asbestos Survey Report from Davis Environmental detailing where asbestos is located in the 431 Third Street property. Staff then solicited and received proposals from two qualified asbestos abatement contractors. A proposal from EnviroBate-Metro provided a quoted cost of $63,115 to abate the asbestos. A proposal from Mayo Systems quotes two different costs: one for$42,998 to abate the asbestos if the building were being renovated and one quote if the building would be demolished. Recently the roof on the south side of the building has become an issue. The shingles on the south side of the building have started to curl from the heat. The shingles on the north side are still intact but are old. Facility maintenance staff researched the cost of new materials to replace the entire roof. The estimated cost of roofmg materials is $10,000 and this estimate does not include labor. BUDGET IMPACT The low quote to abate the asbestos material in the building is$42,998 and the materials for a new roof is $10,000 for a total cost estimated cost of$52,998,which does not include any labor costs. Currently there is no funding approved to complete this work. Funding would either have to come from the EDA Fund or from the General Fund. ACTION REQUESTED Provide direction to staff on what next steps the City Council would like to take regarding the completion of the asbestos abatement and the replacement of the roof on the 431 Third Street property. Respectfully Submitted, Randy Distad, Parks and Recreation Director 2 o``� �`��iy��► City of Farmington 40O 430 Third Street , Farmington,Minnesota GSA AMPO 0 651.280.6800•Fax 651.280.6899 48).•A PRGNo www.ci.farmington.mn.us TO: Mayor, Council Members and City Administrator FROM: Randy Distad,Parks and Recreation Director SUBJECT: Parks and Recreation Department Proposed 2013 Budget DATE: July 23,2012 INTRODUCTION: The Parks and Recreation Department division operational budgets includes: Park Maintenance, Rambling River Center, Park and Recreation Administration, Recreation Programs, Outdoor Pool and the Arena. In addition,there is one capital budget in the Department called the Park Improvement Fund budget DISCUSSION: Staff members have submitted a proposed 2013 budget. Attached is a summary of the various Parks and Recreation Department's operating budgets with an explanation of where increases or decreases are being recommended to occur by account within each of the different divisions. Staff members will be attending the July 23, 2012 City Council Work Session to discuss the recommended budget adjustments from the Adopted 2012 Budget to the Proposed 2013 Budget in the Parks and Recreation Department. ACTION REQUESTED: City Council members are being asked to review the attached report that provides explanations of the increases and decreases to the various 2013 division budgets of the Parks and Recreation Department and then come to the meeting prepared to discuss with staff members the budget adjustments that are being recommended. 3 CITY OF FARMINGTON 2013 BUDGET BREAKDOWN REVENUES SUMMARY ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED LICENSES/PERMITS 2011 12/2011 2012 6/2012 2013 2014 LIQUOR LICENSES $16,000 $24,850 155.31% $16,000 $19,925 124.53% $23,000 $23,000 BEER LICENSES $2,000 $3,075 153.75% $2,000 $1,800 90.00% $3,000 $3,000 CLUB LICENSES $900 $300 33.33% $900 $300 33.33% $300 $300 ANIMAL LICENSES $9,755 $1,178 12.08% $9,755 $7,256 74.38% $1,400 $8,000 ARCADE LICENSES $0 $690 #DIV/0! $0 $760 #DIV/0! $600 $600 MASSAGE LICENSES $1,000 $550 55.00% $1,000 $750 75.00% $750 $750 GAMBLING LICENSES/PERMITS $1,000 $300 30.00% $1,000 $300 30.00% $300 $300 OTHER LICENSES $1,500 $1,400 93.33% $1,500 $2,720 181.33% $3,000 $3,000 TOTAL LICENSES/PERMITS $32,155 $32,343 100.58% $32,155 $33,811 105.15% $32,350 $38,950 ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERMITS 2011 12/2011 2012 6/2012 2013 2014 BUILDING PERMITS $340,000 $345,880 101.73% $340,000 $142,573 41.93% $290,000 $290,000 REINSPECTION FEES $300 $465 155.00% $300 $189 63.00% $300 $300 PLUMBING/HEATING PERMITS $35,000 $44,920 128.34% $35,000 $13,327 38.08% $39,000 $39,000 SEWER PERMITS $10,000 $4,560 45.60% $10,000 $2,400 24.00% $5,000 $5,000 ELECTRIC PERMITS $0 $20,646 #DIV/0! $0 $5,151 #DIV/0! $0 $0 ISTS PERMIT $0 $700 #DIV/0! $0 $400 #DIV/0! $500 $500 COUNTY SEPTIC FEE PERMIT $0 $40 #DIV/0! $0 $0 #DIV/0! $0 $0 UTILITY PERMITS $3,000 $5,835 194.50% $3,000 $4,480 149.33% $5,000 $5,000 STREET BREAKING PERMITS $0 $210 #DIV/0! $0 $0 #DIV/0! $200 $200 SIGN PERMITS $1,000 $570 57.00% $1,000 $460 46.00% $500 $500 BURNING PERMITS $5,000 $4,330 86.60% $5,000 $2,880 57.60% $4,200 $4,200 OTHER PERMITS $5,000 $9,565 191.30% $5,000 $3,225 64.50% $7,000 $7,000 TOTAL PERMITS $399,300 $437,721 109.62% $399,300 $175,085 43.85% $351,700 $351,700 ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED FINES AND FORFEITURES 2011 12/2011 2012 6/2012 2013 2014 FINES $70,000 $78,460 112.09% $70,000 $28,893 41.28% $70,000 $70,000 CODE VIOLATIONS/FINE $0 $0 #DIV/0! $0 $825 #DIV/0! $700 $700 TOTAL FINES/FORFEITURES $70,000 $78,460 112.09% $70,000 I $29,718 42.45% $70,700 $70,700 ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED INTERGOVERNMENTAL 2011 12/2011 2012 6/2012 2013 2014 STATE AID-MAINTENANCE $163,140 $173,857 106.57% $163,140 $96,503 59.15% $163,150 $163,150 STATE AID-POLICE $154,000 $165,749 107.63% $154,000 $0 0.00% $155,000 $155,000 STATE AID-POST TRAINING $9,000 $23,493 261.03% $9,000 $1,729 19.21% $10,000 $10,000 STATE AID-FIRE $73,000 $87,709 120.15% $73,000 $0 0.00% $73,000 $73,000 4 OTHER-STATE GRANT $0 $13,350 #DIV/0! $0 $0 #DIV/0! $0 $0 OTHER-DAKOTA COUNTY $5,250 $16,038 305.49% $5,250 $7,026 133.83% $5,250 $5,250 OTHER $1,200 $2,209 184.08% $1,200 $0 0.00% $1,200 $1,200 TOTAL INTERGOVERNMENTAL $405,590 $482,405 118.94% $405,590 $105,258 25.95% $407,600 $407,600 ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED CHARGES FOR SERVICES 2011 12/2011 2012 6/2012 2013 2014 CUSTOMER SERVICE FEES $1,000 $559 55.90% $1,000 $261 26.10% $600 $600 ZONING/SUBDIVISION FEES $3,000 $3,825 127.50% $3,000 $1,200 40.00% $3,500 $3,500 PRE PLATADMIN FEES $5,000 $750 15.00% $5,000 $125 2.50% $1,000 $1,000 FIRE TOWNSHIP FEES $170,000 $187,077 110.05% $145,000 $20,809 14.35% $130,000 $130,000 ISD 192 SRO FEES $205,377 $232,269 113.09% $171,148 $56,795 33.18% $75,000 $75,000 EROSION/SEDIMENT CONTROL $12,000 $10,400 86.67% $12,000 $6,200 51.67% $10,000 $10,000 GIS FEES $2,000 $220 11.00% $2,000 $0 0.00% $200 $200 PUBLIC WORKS CHARGES $0 $3,434 #DIV/0! $0 $0 #DIV/0! $3,000 $3,000 RECREATION PROGRAM FEES $103,675 $96,036 92.63% $103,675 $68,737 66.30% $100,000 $100,000 POOL ADMISSIONS $38,000 $36,520 96.11% $39,000 $21,659 55.54% $37,000 $39,000 SWIM LESSON FEES $18,000 $16,885 93.81% $18,500 $9,719 52.54% $17,000 $18,500 POOL CONCESSIONS $11,000 $9,208 83.71% $11,000 $3,267 29.70% $9,500 $9,500 RRC PROGRAM FEES $0 $0 #DIV/0! $19,000 $5,247 27.62% $10,500 $10,500 RRC MEMBERSHIP FEES $8,500 $0 0.00% $8,500 $15,403 181.21% $13,850 $13,850 CITY NEWS ADVERTISING $0 $0 #DIV/0! $0 $400 #DIV/0! $0 $0 RECREATION ADVERTISING $2,200 $1,950 88.64% $2,200 $1,650 75.00% $1,800 $1,800 SALE OF ASSETTS $1,626 $0 0.00% $1,626 $3,260 200.49% $1,500 $1,500 FRANCHISE FEES $75,000 #VALUE! $75,000 $53,054 70.74% $75,000 $75,000 TOTAL CHARGES FOR SERVICE $656,378 $599,133 91.28% $617,649 $267,786 43.36% $489,450 $492,950 ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED MISCELLANEOUS 2011 12/2011 2012 6/2012 2013 2014 INVESTMENT INCOME $200,000 $135,600 67.80% $80,000 $33,193 41.49% $80,000 $75,000 DONATIONS $0 $5,520 #DIV/0! $26,000 $9,490 36.50% $6,000 $6,000 RENTALS $7,000 $18,225 260.36% $18,500 $13,924 75.26% $18,000 $18,000 MISCELLANEOUS $62,000 $7,058 11.38% $34,507 $4,730 13.71% $6,000 $6,000 TOTAL MISCELLANEOUS $269,000 $166,403 61.86% $159,007 $61,337 38.58% $110,000 $105,000 ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED TRANSFERS 2011 12/2011 2012 6/2012 2013 2014 LIQUOR OPERATIONS $70,007 $70,007 100.00% $70,007 $35,004 50.00% $50,000 $50,000 SEWER $70,007 $70,007 100.00% $70,007 $35,004 50.00% $70,007 $50,000 STORM WATER $70,007 $70,007 100.00% $70,007 $35,004 50.00% $70,007 $70,007 REFUSE $70,007 $70,007 100.00% $70,007 $35,004 50.00% $70,007 $70,007 WATER $70,007 $70,007 100.00% $70,007 $35,004 50.00% $70,007 $70,007 TOTAL TRANSFERS $350,035 $350,035 100.00% $350,035 $175,020 50.00% $330,028 $310,021 5 TOTAL REVENUES $2,182,458 $2,146,500 98.35% $2,033,736 $848,015 41.70% $1,791,828 $1,776,921 6 City Hall 2013 Budget Explanation 2012 2013 2014 Adopted Requested Requested Account Budget Budget Explanation Budget Explanation Replace HVAC filters more frequently due to corn dust; purchase hand and power tools for facility maintenance staff; 6220 Equipment purchase parts for HVAC equipment (Small increase for HVAC Supplies 1,700 3,500 maintenance 3,600 filters 6240 Building Increase paper products and light bulb Increase for cost of paper Supplies 2,900 3,550 costs 3,950 products, light bulbs 6242 Cleaning Decrease amount needed for cleaning Increase cost for cleaning Supplies 1,500 500 supplies 600;supplies 6250 Other Decrease amount needed for Increase cost for Supplies 1,000 500,miscellaneous supplies 600 miscellaneous supplies 6255 Landscape Increase for plant replacement, weed Decrease amount of Material 60 200lspray, mulch 150 mulch needed Increase to cover cost of staff driving City vehicle and cost of supplying fuel to the Projected increase cost to 6272 Fuel 0 2,700,backup generator currently not budgeted 2,900 purchase fuel 2012 budget items not properly budgeted for including: Coverall cleaning; cost to repair& replace electrical work; all required safety testing of fire suppression system, elevator, fire extinguishers, etc.; cost to annually maintain and service the backup generator; annual fire alarm monitoring and testing; annual exterior 1Cleaning contract expires 6401 Professional window cleaning; and servicing of HVAC in 2014 and is anticipated Se rvices 36,700 61,100 system & hot water boiler 64,150 to increase 6421 Municipal 'Anticipated slight rate Services 3,800 3,800, 3,900 increases Projected increase in consumption and Anticipated slight rate 6422 Electricity 38,000 40,000 rate increase 41,000 increases Anticipated slight rate 6424 Natural Gas 21,578 22,000 Slight increase in consumption 23,000 increases 6450 Dues and Anticipated dues increases Subscriptions 0 150 Boiler license 175 for boiler license _ Anticipated increase in 6470 Training & workshop and training Subsistence 0 500 Boiler training and one day workshop 525 registration fees Funds are spent on items such as HVAC Increase in number of 6505 Equipment system, plumbing, electrical, hot water equipment needing to be Maintenance 1,000 1,000 heater, etc. 1,4501repaired Decrease amount reflecting actual building !maintenance work being done on Increase based on 6515 Building windows, exterior of the building, repair of unexpected building Maintenance 6,000 2,500 interior walls, etc. 3,100 maintenance needed 7 CITY OF FARMINGTON 2013 BUDGET 1015 ADMINISTRATION-CITY HALL ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $12,272 $9,213 75.07% $14,238 $7,353 51.64% $16,565 $16,814 6112 SALARIES-OT $0 $15 #DIV/0! $0 $215 #DIV/0! $0 $0 6120 SALARIES-PT $0 $103 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $838 #DIV/0! $0 $0 #DIV/0! $800 $800 6135 OTHER PAY $0 $205 #DIV/01 $0 $740 #DIV/0! $600 $600 6152 FICA/MEDICARE $939 $800 85.20% $1,089 $637 58.49% $1,374 $1,393 6154 PERA $890 $752 84.49% $1,032 $602 58.33% $1,114 $1,219 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $10,476 $10,651 101.67% $10,117 $5,021 49.63% $10,068 $10,469 6159 WORKERS COMPENSATION $0 $0 #DIV/0! $0 $49 #DIV/0! $0 $0 TOTAL PERSONNEL $24,577 $22,577 91.86% $26,476 $14,617 55.21% $30,521 $31,295 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $3,500 $3,600 6220 EQUIPMENT SUPPLIES $750 $3,213 428.40% $1,700 $2,155 126.76% $3,550 $3,950 6240 BUILDING SUPPLIES $2,250 $7,483 332.58% $2,900 $2,272 78.34% $0 $0 6242 CLEANING SUPPLIES $2,500 $0 0.00% $1,500 $0 0.00% $500 $600 6250 OTHER SUPPLIES $500 $212 42.40% $1,000 $0 0.00% $500 $600 6255 LANDSCAPING SUPPLIES $60 $0 0.00% $60 $0 0.00% $200 $150 6272 FUEL $0 $2,386 #DIV/0! $0 $204 #DIV/0! $2,700 $2,900 TOTAL SUPPLIES $6,060 $13,294 219.37% $7,160 $4,631 64.68% $10,950 $11,800 OTHER SERVICES 6401 PROFESSIONAL SERVICES $61,145 $60,681 99.24% $36,700 $26,954 73.44% $61,100 $64,150 6403 LEGAL $0 $0 #DIV/0! $0 _ $0 #DIV/0! _ $0 _ $0 6404 IT SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6421 MUNICIPAL SERVICES $0 $3,570 #DIV/0! $3,800 $1,839 48.39% $3,800 $3,900 6422 ELECTRIC $28,750 $39,714 138.14% $38,000 $16,330 42.97% $40,000 $41,000 6423 NATURAL GAS $22,750 $21,323 93.73% $21,578 $8,364 38.76% $22,000 $23,000 6460 DUES/SUBSCRIPTIONS $0 $145 #DIV/0! $0 _ $50 - #DIV/0! $150 $175 6470 TRAINING/SUBSISTANCE $0 $0 #DIV/0! $0 $300 #DIV/0! $500 $525 6480 MEETING EXPENSE $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6492 ADVERTISING $0 _ $0 _ #DIV/0!_ $0 __ $0 #DIV/0!_ $0 $0 6505 EQUIPMENT REPAIR $1,860 $674 36.24% $1,000 $856 85.60% $1,000 $1,450 6515 BUILDING MAINTENANCE $0 $4,240 #DIV/0! $6,000 $488 8.13% $2,500 $3,100 TOTAL OTHER SERVICES $114,505 $130,347 113.84% $107,078 $55,181 51.53% $131,050 $137,300 7/18/2012 8 Administration-City Hall TOTAL BUDGET $145,142 $166,218 114.52% $140,714 $74,429 52.89% $172,521 1 $180,395 7/18/2012 9 Administration-City Hall Park Maintenance 2013 Budget Explanation 2012 2013 2014 Adopted Requested Requested Account Budget Budge_t Explanation Budget Explanation items purchased includes: mower supplies, 6220 Equipment tools, basketball court equipment, HVAC purchase of portable Supplies 6,000 6,000 filters for CMF 7,025 generator 6230 Vehicle increase for new truck tool box and ladder Supplies 5,000 7,000 rack 7,100 6234 Vehicle License 150 150 150 6240 Building Supplies 2,100 2,100 2,500 increase for grass seed, light bulbs for athletic increase for field paint, wood fiber safety fields, netting for softball surfacing material for playgrounds, new fields, wood fiber for banners for all light and banner poles, playgrounds, new picnic purchase new entry mats for CMF, purchase tables and downtown 6250 Other Supplies 39,200 48,200 new waste containers for parks 62,000 holiday decorations 6255 Landscape decrease spending on flowers and plants for Materials 3,000 2,500 landscaped areas 2,700 increase funding for broadleaf spray and 6260 Chemicals 5,900 6,500 fertilizer 6,700 6272 Fuel 22,000 25,000 increase in fuel price and consumption 27,000 6290 Uniforms 3,600 2,825 decrease amount spent Cintas uniforms 2,925 increase cost of prairie maintenane at Lake Julia Park prairie; unbudgeted costs to service CMF including: exterior window 6401 Professional cleaning, HVAC servicing, overhead door restroom contract ends Services 16,281 18,900 servicing, and electrical servicing 20,100 in 2014 6412 Cellular Phones 3,500 3,500 3,500 6421 Municipal Services 1,700 1,700 1,850 6422 Electric 10,750 10,750 11,100 _ reflects historical average consumption of 6423 Natural Gas 6,500 5,500 natural gas lower than budgeted amount 5,700 6460 Dues and Subscriptions 335 335 370 6470 Training and increase reflects partial funding for NRPA Subsistence 1,900 2,080 national conference 2,300 6485 Mileage Reimbursement 600 600 600 playground equipment 6505 Equipment repair and for grounds Maintenance 9,260 9,760 increase for playground equipment repair 12,100 maintenance equipment 6515 Building Maintenance 450 450 550 6535 Other Repair increase to sealcoat, crackseal, overlay and (Trail Maintenance) 15,000 30,000 replace more linear feet of trail 30,000 10 Park Maintenance 2013 Budget Explanation increase for annual mower lease cost and 6555 Equipment for mobile mini for portable warming house Rental 18,000 19,800at North Creek Park 20,400 11 CITY OF FARMINGTON 2013 BUDGET 1090 PARKS-MAINTENANCE ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $226,049 $278,334 123.13% $236,143 $133,365 56.48% $238,487 $242,803 6112 SALARIES-OT $4,482 $4,173 93.11% $4,858 $221 4.55% $5,000 $5,000 6120 SALARIES-PT $42,084 $27,756 65.95% $31,617 $9,226 29.18% $32,430 $32,916 6130 COMP TIME PAY $0 $2,222 #DIV/0! $0 $0 #DIV/0! $2,300 $2,300 6135 OTHER PAY $0 $2,708 #DIV/0! $0 $1,139 #DIV/0! $2,900 $2,944 6152 FICA/MEDICARE $24,096 $23,561 97.78% $20,855 $10,512 50.41% $21,505 $21,876 6154 PERA $21,934 $20,835 94.99% $18,853 $9,767 51.81% $19,404 $19,740 6156 HCSP $0 $517 #DIV/0! $0 $261 #DIV/0! $557 $574 6158 EMPLOYEE BENEFITS $31,139 $34,354 110.32% $43,039 $17,686 41.09% $46,900 $48,500 6159 WORKERS COM $0 $0 #DIV/0! $0 $3,837 #DIV/0! $0 $0 TOTAL PERSONNEL $349,784 $394,460 112.77% $355,365 $186,014 52.34% $369,483 $376,653 SUPPLIES _ 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $8,430 $2,594 30.77% $6,000 $1,289 21.48% $6,000 $7,025 6230 VEHICLE SUPPLIES/PARTS $2,450 $7,383 301.35% $5,000 $2,210 44.20% $7,000 $7,100 6234 VEHICLE LICENSES $150 $0 0.00% $150 $256 170.67% $150 $175 6240 BUILDING SUPPLIES $1,500 $730 48.67% $2,100 $1,678 79.90% $2,100 $2,500 6250 OTHER SUPPLIES $34,947 $41,232 117.98% $39,200 $14,908 38.03% $48,200 $62,000 6255 LANDSCAPING MATERIAL $4,625 $2,286 49.43% $3,000 $501 16.70% $2,500 $2,700 6260 CHEMICALS $2,950 $2,921 99.02% $5,900 $1,812 30.71% $6,500 $6,700 6272 FUEL $20,000 $25,079 125.40% $22,000 $7,882 35.83% $25,000 $27,000 6290 UNIFORMS $4,150 $2,216 53.40% $3,600 $1,275 35.42% $2,825 $2,925 TOTAL SUPPLIES $79,202 $84,441 106.61% $86,950 $31,811 36.59% $100,275 $118,125 OTHER SERVICES 6401 PROFESSIONAL SERVICES $14,911 $14,392 96.52% $16,281 $7,350 45.14% $18,900 $20,100 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6403 LEGAL $0 $487 #DIV/0! $0 $2,265 #DIV/0! $0 $0 6404 IT SERVICES $1,150 $1,150 100.00% $1,305 $653 50.04% $11,655 $11,655 6411 TELEPHONE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $3,555 $3,339 93.92% $3,500 $1,567 44.77% $3,500 $3,500 6421 MUNICIPAL SERVICES $1,700 $1,373 80.76% $1,700 $847 49.82% $1,700 $1,850 6422 ELECTRIC $9,600 $10,590 110.31% $10,750 $3,401 31.64% $10,750 $11,100 6423 NATURAL GAS $8,000 $4,318 53.98% $6,500 $2,180 33.54% $5,500 $5,700 6450 OUTSIDE PRINTING $0 $0 #DIV/0! $0 $0 #DIV/0! $335 $370 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 7/18/2012 1 2 Parks-Maintenance 6460 DUES/SUBSCRIPTIONS $505 $120 23.76% $335 $345 102.99% $0 $0 6470 TRAINING/SUBSISTANCE $2,760 $2,022 73.26% $1,900 $725 38.16% $2,080 $2,300 6485 MILEAGE $0 $0 #DIV/0! $600 $40 6.67% $600 $600 6505 EQUIPMENT REPAIR $8,060 $1,632 20.25% $9,260 $4,363 47.12% _ $9,760 $12,100 6510 VEHICLE MAINTANANCE $25,500 $31,799 124.70% $25,500 $10,625 41.67% $24,945 $24,945 6515 BUILDING REPAIR $450 $637 141.56% $450 $134 29.78% $450 $550 6535 OTHER REPAIR $0 $0 #DIV/0! $15,000 $0 0.00% $30,000 $30,000 6555 EQUIPMENT RENTAL $14,400 $20,168 140.06% $18,000 $12,162 67.57% $18,500 $19,100 6570 PROGRAM EXPENSES $0 $29 #DIV/0! $0 $53 #DIV/01 $0 $0 TOTAL OTHER SERVICES $90,591 $92,056 101.62% $111,081 $46,710 42.05% $138,675 $143,870 TOTAL BUDGET $519,577 $570,957 109.89% $553,396 $264,535 47.80% $608,433 $638,648 7/18/2012 13 Parks-Maintenance Rambling River Center 2013 Budget Explanation 2012 ' 2013 2014 Adopted Requested Requested Account Budget Budget Explanation Budget Explanation 6210 Office Supplies 850 850 1,000 6220 Equipment anticipated window blind replacements reduction countertop being Supplies 1,650 1,750 and replace coffee nook countertop 1,000 replaced in 2013 no funding budgeted for supplies needed 6230 Vehicle for Park and Rec bus needed in case of Supplies 0 800 bus lift and window replacement 1,000 6240 Building funding for items such as hand soap, key Supplies 600 1,100 replacement, tissue, air freshener& paint 1,350 6242 Cleaning Supplies 200 200 250 funding for framing and matting historical 6250 Other Supplies 0 500 farmington photos that can be displayed 500 6255 Landscape Materials 0 100 for mulch and plant materials 0 currently no money budgeted but fuel is 6272 Fuel 0 1,000 used in Park and Rec and DARTS buses _ 1,100 money transferred from Program Expense to reflect cost of contracted performers; increased to cover cost of sprinkler and fire alarm testing and monitoring; cover cost of HVAC servicing; cover cost of fitness room equipment; cover cost of contracted bus services; cover cost of overhead door and electrical service work; 6401 Professional decreases cost of Coverall cleaning cost Services 15,010 and DARTS bus costs 20,175 6403 Legal Fees 200 200 220 6411 Telephone 1,400 1,400 _ 1,500 6412 Cellular _ Phone 250 250 250 6421 Municipal _ Services 4,000 4,000 _ 4,100 6422 Electricity 7,300 7,300 7,400 anticipated increase in consumption and price of natural gas to heat the building 6423 Natural Gas 12,800 13,000 and water 13,200 6426 Insurance 3,020 3,020 0 Fewer members reduces the cost of 6445 Postage 900 700 mailing the bi-monthly newsletter 850 increases in purchase of subscription to 6460 Dues and newspapers and magazines; cost of staff Subscriptions 750 1,100 recertifying as a CPRP 1,095 6470 Training and Reduction in MRPA conference fees due Subsistence 1,550 1,100 to being held in the metro area 1,350 6485 Mileage Reimbursement 100 100 _ 150 6492 Advertising 1,000 1,000 1,150 6505 Equipment Maintenance 500 500 650 6515 Building Maintenance _ 1,000 1,100 increased for window repairs 1,80.0_ 6570 Programming decreased due to r nsfer of funds to the Expense 18,000 13,000 Professional ServrccAccount 13,000 CITY OF FARMINGTON 2013 BUDGET 1093 PARKS-RAMBLING RIVER CENTER ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $39,416 $39,955 101.37% $40,547 $17,934 44.23% $40,151 $41,010 6112 SALARIES-OT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6120 SALARIES-PT $21,239 $19,377 91.23% $21,451 $9,953 46.40% $20,186 $20,489 6130 COMP TIME PAY $0 $3,130 #DIV/0! $0 $0 #DIV/0! $200 $400 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $4,640 $4,288 92.41% $4,743 $1,939 40.88% $4,631 $4,735 6154 PERA $4,398 $4,528 102.96% $4,263 $2,021 47.41% $4,389 $4,488 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $12,512 $12,994 103.85% $10,761 $5,013 46.58% $11,050 $11,450 6159 WORKERS COMP $0 $0 #DIV/0! $0 $371 #DIV/0! $0 $0 TOTAL PERSONNEL $82,205 $84,272 102.51% $81,765 $37,231 45.53% $80,607 $82,572 SUPPLIES 6210 OFFICE SUPPLIES $450 $565 125.56% $850 $52 6.12% $850 $1,000 6220 EQUIPMENT SUPPLIES $500 $311 62.20% $1,650 $216 13.09% $1,750 $1,000 6230 VEHICLE SUPPLIES/PARTS $0 $0 #DIV/0! $0 $0 #DIV/0! $800 $1,000 6234 VEHICLE LICENSES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6240 BUILDING SUPPLIES $600 $3,592 598.67% $600 $357 59.50% $1,100 $1,350 6242 CLEANING SUPPLIES $200 $0 0.00% $200 $12 6.00% $200 $250 6250 OTHER SUPPLIES $50 $153 306.00% $50 $628 1256.00% $500 $500 6255 LANDSCAPING MATERIAL $0 $0 #DIV/0! $0 $0 #DIV/0! $100 $0 6260 CHEMICALS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6272 FUEL $0 $931 #DIV/0! $0 $539 #DIV/0! $1,000 $1,100 6290 UNIFORMS $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 TOTAL SUPPLIES $1,800 $5,552 308.44% $3,350 $1,804 53.85% $6,300 $6,200 OTHER SERVICES 6401 PROFESSIONAL SERVICES $17,000 $18,818 110.69% $15,010 $10,318 68.74% $18,970 $18,970 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6403 LEGAL $200 $75 37.50% $200 $150 75.00% $200 $220 6404 IT SERVICES $5,174 $5,174 100.00% $6,525 $3,263 50.01% $11,914 $11,914 6411 TELEPHONE $600 $1,337 222.83% $1,400 $409 29.21% $1,400 $1,500 6412 CELLULAR TELEPHONES $252 $0 0.00% $250 $0 0.00% $250 $250 6421 MUNICIPAL SERVICES $4,000 $2,373 59.33% $4,000 $839 20.98% $4,000 $4,100 6422 ELECTRIC $7,000 $8,133 116.19% $7,300 $3,581 49.05% $7,300 $7,400 6423 NATURAL GAS $12,800 $8,078 63.11% $12,800 $3,621 28.29% $13,000 $13,200 6426 INSURANCE $3,010 $3,010 100.00% $3,020 $1,510 50.00% $3,020 $0 7/18/2012 1 5 Parks-Rambling River Center 6445 POSTAGE $900 $0 0.00% $900 $18 2.00% $700 $850 6450 OUTSIDE PRINTING $200 $42 21.00% $0 $0 #DIV/0! $0 $0 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $92 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $700 $967 138.14% $750 $775 103.33% $1,100 $1,095 6470 TRAINING/SUBSISTANCE $1,550 $850 54.84% $1,550 $50 3.23% $1,100 $1,350 6485 MILEAGE $100 $0 0.00% $100 $0 0.00% $100 $100 6492 ADVERTISING $500 $100 20.00% $1,000 $199 19.90% $1,000 $1,150 6505 EQUIPMENT REPAIR $500 $555 111.00% $500 $35 7.00% $500 $650 6510 VEHICLE MAINTANANCE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6515 BUILDING REPAIR $1,000 $188 18.80% $1,000 $119 11.90% $1,100 $1,800 6535 OTHER REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0! $0 $31 #DIV/0! $0 $0 6570 PROGRAM EXPENSES $18,000 $8,672 48.18% $18,000 $7,115 39.53% $13,000 $13,000 TOTAL OTHER SERVICES $73,486 $58,372 79.43% $74,305 $32,125 43.23% $78,654 $77,549 TOTAL BUDGET $157,491 $148,196 94.10% $159,420 $71,160 1 44.64% I $165,561 $166,321 7/18/2012 1 6 Parks-Rambling River Center Parks and Recreation Administration 2013 Budget Explanation 2012 2013 2014 Adopted Requested Requested Account Budget Budget Explanation Budget Explanation 6210 Office Supplies 200 200 200 6230 Vehicle Supplies 50 50 _ 100 6234 Vehicle Licenses 125 125 150 6250 Other Supplies 1,000 800 _ 800 increase reflects historical fuel costs for 6272 Fuel 1,500 2,000 vehicles 2,200 price increase 6403 Legal Fees 500 500 500 6412 Cellular Phone 1,680 1,680 1,680 increased but money is transferred from rate increase&service is 6445 Postage 0 4,100 the Outside Printing Account 4,800 rebid in 2014 6450 Outside reduced but money is transferred to the printing increase &service Printing 16,542 12,500 Postage Account 15,000 is rebid in 2014 6460 Dues and Subscriptions 1,270 1,270 _ 1,400 rate increase increased for MRPA 6470 Training and increase reflects partial funding for NRPA conference being out of Subsistence 1,000 1,400 national conference 1,800 m etro area 6485 Mileage Reimbursement 600 600 600 6492 Advertising 300 300 400 17 CITY OF FARMINGTON 2013 BUDGET 1094 PARKS-ADMINISTRATION ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $154,418 $99,519 64.45% $155,708 $64,945 41.71% $158,038 $160,409 6112 SALARIES-OT $2,002 $0 0.00% $1,427 $0 0.00% $1,427 $1,427 6120 SALARIES-PT $0 $79 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $3,401 #DIV/0! $0 $0 #DIV/0! $0 $0 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $11,966 $7,745 64.73% $12,021 $4,850 40.35% $12,199 $12,380 6154 PERA $11,340 $7,465 65.83% $11,392 $4,709 41.34% $11,561 $11,733 6156 HCSP $0 $1,956 #DIV/0! $0 $956 #DIV/0! $1,808 $1,846 6158 EMPLOYEE BENEFITS $21,854 $22,316 102.11% $17,971 $8,450 47.02% $21,250 $22,050 6159 WORKERS COMP $0 $0 #DIV/0! $0 $538 #DIV/0! $0 $0 TOTAL PERSONNEL $201,580 $142,481 70.68% $198,519 $84,448 42.54% $206,283 $209,845 SUPPLIES 6210 OFFICE SUPPLIES $200 $73 36.50% $200 $0 0.00% $200 $200 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6230 VEHICLE SUPPLIES/PARTS $50 $55 110.00% $50 $0 0.00% $50 $100 6234 VEHICLE LICENSES $125 $0 0.00% $125 $64 51.20% $125 $150 6240 BUILDING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6242 CLEANING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6250 OTHER SUPPLIES $100 $40 40.00% $800 $68 8.50% $800 $800 6255 LANDSCAPING MATERIAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6260 CHEMICALS $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6272 FUEL $1,500 $1,510 100.67% $1,500 $228 15.20% $2,000 $2,200 6290 UNIFORMS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $1,975 $1,678 84.96% $2,675 $360 13.46% $3,175 $3,450 OTHER SERVICES 6401 PROFESSIONAL SERVICES $0 $100 #DIV/01 $0 $0 #DIV/0! $0 $0 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6403 LEGAL $1,000 $195 19.50% $500 $0 0.00% $500 $500 6404 IT SERVICES $22,995 $22,995 100.00% $26,100 $13,050 50.00% $10,482 $10,482 6411 TELEPHONE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $1,680 $1,234 73.45% $1,680 $682 40.60% $1,680 $1,680 6421 MUNICIPAL SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6422 ELECTRIC $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6423 NATURAL GAS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6426 INSURANCE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 7/18/2012 1 8 Parks-Administration 6445 POSTAGE $0 $0 #DIV/01 $0 $0 #DIV/0! $4,100 $4,800 6450 OUTSIDE PRINTING $17,500 $14,681 83.89% $16,542 $7,595 45.91% $12,500 $15,000 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $1,152 $438 38.02% $1,270 $848 66.77% $1,270 $1,400 6470 TRAINING/SUBSISTANCE $1,000 $912 91.20% $1,000 $0 0.00% $1,400 $1,800 6485 MILEAGE $1,200 $962 80.17% $600 $338 56.33% $600 $600 6492 ADVERTISING $300 $0 0.00% $300 $0 0.00% $300 $400 6505 EQUIPMENT REPAIR $0 $0 #DIV/OI $0 $0 #DIV/0! $0 $0 6510 VEHICLE MAINTANANCE $500 $500 100.00% $500 $208 41.60% $489 $489 6515 BUILDING REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6535 OTHER REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6570 PROGRAM EXPENSES $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $47,327 $42,017 88.78% $48,492 $22,721 46.86% $33,321 1- $37,151 T - TOTAL BUDGET $250,882 $186,176 74.21% $249,686 $107,529 43.07% $242,779 $250,446 7/18/2012 1 9 Parks-Administration Recreation Services 2013 Budget Explanation 2012 2013 2014 Adopted Requested Requested Account Budget Budget Explanation Budget Explanation 6250 Other Supplies 700 700 1,150 purchase new coolers 6290 Uniforms 400 400 500 used for contracted performers such as adult league officials, sports camp increased costs of 6401 Professional instructors, entertainment at programs and services provided for Services 35,000 35,000 events _ 36,000 programs 6412 Cellular Service 420 420 450 rate increase 6450 Outside increased costs to print Printing 500 500 600 flyers and posters 6492 Advertising 200 200 300 6505 Equipment Maintenance 100 100 100 _ funds used to cover direct expenses related to specific programs such as arts and crafts materials, sports equipment, adult league sanction fees, Dew Run 6570 Program event materials, adult league tournaments, increased cost to provide Expenses 33,200 33,200 facility rentals, etc. 34,100 events and programs 20 CITY OF FARMINGTON 2013 BUDGET 1095 PARKS-RECREATION PROGRAMS ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6112 SALARIES-OT $1,999 $0 0.00% $1,426 $0 0.00% $1,430 $1,430 6120 SALARIES-PT $36,858 $22,984 62.36% $37,749 $9,196 24.36% $37,935 $38,504 6130 COMP TIME PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6135 OTHER PAY $0 $0 #DIV/O! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $3,012 $1,748 58.03% $3,038 $703 23.14% $3,011 $3,055 6154 PERA $2,855 $0 0.00% $2,878 $0 0.00% $2,854 $2,895 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $1,230 $1,230 100.00% $1,239 $612 49.39% $2,360 $2,950 TOTAL PERSONNEL $45,954 $25,962 56.50% $46,330 $10,511 22.69% $47,590 $48,834 SUPPLIES 6210 OFFICE SUPPLIES $0 $44 #DIV/0! $0 $145 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/O! $0 $0 6230 VEHICLE SUPPLIES/PARTS $0 $0 #DIV/O! $0 $0 #DIV/0! $0 $0 6234 VEHICLE LICENSES $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6240 BUILDING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6242 CLEANING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6250 OTHER SUPPLIES $300 $85 28.33% $700 $0 0.00% $700 $1,150 6255 LANDSCAPING MATERIAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6260 CHEMICALS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6272 FUEL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6290 UNIFORMS $400 $0 0.00% $400 $135 33.75% $400 $500 TOTAL SUPPLIES $700 $129 18.43% $1,100 $280 25.45% $1,100 $1,650 OTHER SERVICES 6401 PROFESSIONAL SERVICES $35,000 $26,562 75.89% $35,000 $8,862 25.32% $35,000 $36,000 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6403 LEGAL $0 $150 #DIV/01 $0 $0 #DIV/0! $0 $0 6404 IT SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6411 TELEPHONE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6412 CELLULAR TELEPHONES $420 $348 82.86% $420 $0 0.00% $420 $450 6421 MUNICIPAL SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6422 ELECTRIC $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 - 6423 NATURAL GAS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6426 INSURANCE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6445 POSTAGE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 7/18/2012 21 Parks-Recreation 6450 OUTSIDE PRINTING $500 $0 0.00% $500 $357 71.40% $500 $600 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $0 $103 #DIV/0! $0 $0 #DIV/0! $0 $0 6470 TRAINING/SUBSISTANCE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6485 MILEAGE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6492 ADVERTISING $200 $0 0.00% $200 $0 0.00% $200 $300 6505 EQUIPMENT REPAIR $100 $0 0.00% $100 $0 0.00% $100 $100 6510 VEHICLE MAINTANANCE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6515 BUILDING REPAIR $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6535 OTHER REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6570 PROGRAM EXPENSES $33,148 $23,935 72.21% $33,200 $10,448 31.47% $33,200 $34,100 TOTAL OTHER SERVICES $69,368 $51,098 73.66% $69,420 $19,667 28.33% $69,420 $71,550 TOTAL BUDGET $116,022 $77,189 66.53% $116,850 $30,458 26.07% $118,110 $122,034 7/18/2012 2 2 Parks-Recreation Outdoor Pool 2013 Budget Explanation 2012 2013 2014 Adopted Requested Requested Account Budget- Explanation __Budget Explanation - 6220 Equipment purchase new chemical controllers and decreased by cost of Supplies _ 2,500 7,200 one new funbrella cover _ __ 3,200 chemical controllers 6240 Building reduced by cost of roofing Supplies 2,500 5,500 purchase and replace roof of bathhouse 3,000 materials 6242 Cleaning Supplies 200 200 200 increased to provide a contingency to 6250 Other Supplies 500 1,500 purchase other supplies for the pool 1,500 6255 Landscape add mulch and curbing to the landscaped Materials 0 100 areas around the pool bathhouse 100 purchase liquid chlorine, soda ash and acid to sanitize and balance water 6260 Chemicals 7,500 7,500 chemistry 8,000 anticipated price increase price increase of staff swim suits and t- price increase of staff 6290 Uniforms 1,000 1,100 shirts 1,250 swim suits and t-shirts 6401 Professional increase costs to provide swim bus anticipated increase of Services 2,500 3,750 service and cost of DJ for 4 special events 4,050 cost of services currently not budgeted so reflects what is 6411 Telephone 0 350 spent annually on this item 400 _ 6412 Cellular decrease reflects historical costs of cell Phones 625 300 phones for the pool 300 6421 Municipal Services 1,500 1,500 1,600 anticipated rate increase anticipated increase in electrical 6422 Electric 3,750 4,000 assumption 4,200 rate increase 6423 Natural Gas 9,000 9,000 _ 9,200 rate increase 6426 Insurance 3,100 3,100 3,200 rate increase printing of season passes, punch cards 6450 Outside and flyers for events and programs at the Printing 400 400 pool 450 6460 Dues and increase in Red Cross Subscriptions 1,325 1,350 1,450 dues 6470 Training and increase reflects partial funding for NRPA Subsistence 900 1,100 national conference 1,100 6485 Mileage Reimbursement 150 150 150 6492 Advertising 100 100 150 6505 Equipment increase in maintenance costs for pumps, Maintenance 2,000 3,000 filter, pool vacuum & pool heater 3,500 6515 Building used for repair of bathhouse plumbing, older building anticipated Maintenance 2,500 2,500 electrical, interior and exterior walls 3,000 additional repairs needed increase in costs of red cross learn to swim lesson materials and adds in cost of 6570 Program paying copyright fee for music played at Expense 600 1,725 pool 1,940 7510 Cost of Goods goods purchased are resold in concession Sold 7,000 7,000 stand 7,000 23 CITY OF FARMINGTON 2013 BUDGET 1097 PARKS-POOL ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 5/2012 % 2013 2014 6110 SALARIES-FT $12,200 $5,357 43.91% $10,726 $7,867 73.35% $20,134 $20,436 6112 SALARIES-OT $0 $130 #DIV/0! $0 $0 #DIV/0! $0 $0 6120 SALARIES-PT $53,067 $43,476 81.93% $53,597 $8,710 16.25% $53,875 $54,683 6130 COMP TIME PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $4,993 $3,752 75.15% $4,921 $1,263 25.67% $5,662 $5,747 6154 PERA $0 $543 #DIV/0! $778 $620 79.69% $5,366 $5,446 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $2,908 $2,907 99.97% $2,866 $1,433 50.00% $4,375 $4,375 TOTAL PERSONNEL $73,168 $56,165 76.76% $72,888 $19,893 27.29% $89,412 $90,687 SUPPLIES 5502 COST OF GOOD SOLD $7,000 $6,597 94.24% $7,000 $0 0.00% $7,000 $7,000 6210 OFFICE SUPPLIES $0 $12 #DIV/01 $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $2,500 $2,567 102.68% $2,500 $5,079 203.16% $7,200 $3,200 6230 VEHICLE SUPPLIES/PARTS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6234 VEHICLE LICENSES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6240 BUILDING SUPPLIES $2,500 $4,145 165.80% $2,500 $3,279 131.16% $5,500 $3,000 6242 CLEANING SUPPLIES $200 $3 1.50% $200 $0 0.00% $200 $200 6250 OTHER SUPPLIES $500 $1,578 315.60% $500 $199 39.80% $1,500 $1,500 6255 LANDSCAPING MATERIAL $0 $0 #DIV/0! $0 $0 #DIV/0! $100 $0 6260 CHEMICALS $6,500 $5,561 85.55% $7,500 $2,816 37.55% $7,500 $8,000 6272 FUEL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6290 UNIFORMS $1,350 $1,039 76.96% $1,000 $904 90.40% $1,100 $1,250 TOTAL SUPPLIES $20,550 $21,502 104.63% $21,200 $12,277 57.91% $30,100 $24,150 OTHER SERVICES 6401 PROFESSIONAL SERVICES $2,500 $4,145 165.80% $2,500 $1,447 57.88% $3,750 $4,050 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6403 LEGAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6404 IT SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6411 TELEPHONE $0 $579 #DIV/0! $0 $106 #DIV/01 $350 $400 6412 CELLULAR TELEPHONES $375 $620 165.33% $625 $166 26.56% $300 $300 6421 MUNICIPAL SERVICES $1,300 $1,483 114.08% $1,500 $167 11.13% $1,500 $1,600 6422 ELECTRIC $4,000 $3,807 95.18% $3,750 $565 15.07% $4,000 $4,200 6423 NATURAL GAS $9,500 $3,774 39.73% $9,000 $170 1.89% $9,000 $9,200 6426 INSURANCE $3,100 $3,100 100.00% $3,100 $1,550 50.00% $3,100 $3,200 7/18/2012 24 Parks-Pool 6445 POSTAGE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6450 OUTSIDE PRINTING $0 $352 #DIV/0! $400 $0 0.00% $400 $450 6455 LEGAL PUBLICATIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $1,500 $816 54.40% $1,325 $929 70.11% $1,350 $1,450 6465 PERMIT FEES $0 $0 #DIV/0! $0 $5 #DIV/0! $0 $0 6470 TRAINING/SUBSISTANCE $900 $651 72.33% $900 $251 27.89% $1,100 $1,100 6485 MILEAGE $150 $140 93.33% $150 $59 39.33% $150 $150 6492 ADVERTISING $100 $0 0.00% $100 $0 0.00% $100 $150 6505 EQUIPMENT REPAIR $2,000 $4,810 240.50% $2,000 $1,020 51.00% $3,000 $3,500 6510 VEHICLE MAINTANANCE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6515 BUILDING REPAIR $0 $0 #DIV/0! $2,500 $828 33.12% $2,500 $3,000 6535 OTHER REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6570 PROGRAM EXPENSES $650 $1,645 253.08% $600 $141 23.50% $1,725 $1,940 6950 MACHINERY/EQUIPMENT $0 $0 #DIV/0! $0 $5,925 #DIV/0! $0 $0 TOTAL OTHER SERVICES $26,075 $25,922 99.41% $28,450 $13,329 46.85% $32,325 $34,690 TOTAL BUDGET $119,793 $103,589 86.47% $122,538 $45,499 37.13% $151,837 $149,527 7/18/2012 25 Parks-Pool Arena 2013 Budget Explanation 2012 2013 ' 2014 Account Budget Budget Explanation Budget Explanation 5502 Cost of Goods Sold 1,400 1,400 Goods purchased are resold in pro shop 1,400 purchase two new goal nets and 6220 Equipment Supplies 1,600 3,000 increased costs for resurfacer parts 3,000 - - includes items such as: salt, entrance mat replacement, repair or replace rubber flooring tiles, paint for rink floor and walls 6240 Building Supplies 7,600 7,600 and light bulbs 7,950 Increase in paint costs 6250 Other Supplies 750 750 750 6255 Landscape purchase of mulch to replace decaying Materials 0 50 mulch in landscaped areas around arena 50 6272 Fuel 2,000 2,000 2,200 increase in price of fuel anticipated increase costs in uniform 6290 Uniforms 1,100 1,200 items such as t-shirts,jackets, etc. 1,200 for hiring electrician and plumbers to complete repair work, resurfacer blade 6401 Professional sharpening, PA announcer, spring festival anticipated increase in Services 6,000 6,000 skating judges, auditor, locksmith, etc. 6,500 costs of services 6411 Telephone 1,000 1,000 1,000 6412 Cellular Phones 500 500 500 reduction due to more efficient with water usage and increased recycling efforts at 6421 Municipal Services 7,000 5,000 the arena 5,100 anticipated rate increase reduction reflects historical average consumption of electricity is lower than 6422 Electric 45,000 42,000 budgeted amount 43,000 anticipated rate increase reduction reflects historical average consumption of natural gas is lower than 6423 Natural Gas 23,000 20,000 budgeted amount 21,000 anticipated rate increase 6426 Insurance 8,000 8,000 _ 8,100 anticipated rate increase used for professionally printing 6450 Outside Printing 500 500 promotional &advertising flyers for arena 500 6460 Dues and reduction reflects historical averages of dues and membership Subscriptions 3,020 2,000 dues and subscriptions paid 2,175 rate increases 6470 Training and Subsistence 1,500 1,500 1,600 reflects older equipment needing to be maintained more frequently such as Maintenance of mechanical and resurfacer, skate 6505 Equipment refrigeration system, resurfacer, skate sharpener machine, and Maintenance 4,750 4,750 sharpener, furnace, etc. 5,550 furnace reflects replacing more light bulbs, repair of dasher boards and more plumbing and electrical 6515 Building repair of lights, dasher boards and glass, repair work and issues Maintenance 3,300 3,300 roof, interior and exterior walls, etc. 4,150 being completed increase costs of spring increase reflects increase costs of spring skate festival competition skate festival competition and learn to and learn to skate 6570 Program Expense 4,000 4,700 skate program class materials 5,000 program class materials 26 CITY OF FARMINGTON 2013 BUDGET ICE ARENA REVENUES APPROVED THROUGH APPROVED THROUGH REQUESTED ESTIMATED 2011 12/2011 % 2012 6/2012 % 2013 2014 4512 SUMMER ACTIVITIES $500 $531 106.20% $500 $495 99.00% $500 $500 4668 CONCESSIONS $4,700 $489 10.40% $1,000 $101 10.10% $500 $500 4810 ICE RENTAL $250,000 $255,936 102.37% $255,000 $107,171 42.03% $250,000 $255,000 4815 INSTRUCTION $17,000 $15,189 89.35% $17,000 $4,662 27.42% $14,500 $14,500 4820 OPEN SKATING $5,000 $4,116 82.32% $2,500 $1,588 63.52% $3,000 $3,000 4825 ADMISSIONS $15,000 $730 4.87% $15,000 $0 0.00% $0 $0 4830 SKATE SHARPENING $4,000 $2,075 51.88% $2,500 $728 29.12% $1,500 $1,500 4835 ADVERTISING $9,000 $6,171 68.57% $9,500 $3 0.03% $6,000 $6,000 4840 SKATE SHOW $4,500 $4,158 92.40% $4,500 $3,115 69.22% $4,000 $4,000 5010 MERCHANDISE SALES $0 $840 #DIV/0! $800 $176 22.00% $800 $850 5350 MISCELLANEOUS $0 $1,431 #DIV/0! $0 $789 #DIV/0! $700 $700 5355 FYHA/DONATION $0 $0 #DIV/0! $0 $5,106 #DIV/0! $5,000 $5,000 TOTAL REVENUE $309,700 $291,666 94.18% $308,300 $123,934 40.20% $286,500 $291,550 EXPENSES 6100 PERSONAL SERVICES $175,115 $198,517 113.36% $176,800 $62,798 35.52% $156,960 $162,915 6200 SUPPLIES $17,350 $10,542 60.76% $14,450 $6,983 48.33% $16,000 $16,550 6400 OTHER SERVICES/CHARGES $112,682 $97,422 86.46% $110,506 $47,502 42.99% $109,122 $114,047 6900 CAPITAL OUTLAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL EXPENSES $305,147 $306,481 100.44% $301,756 $117,283 38.87% $282,082 $293,512 INCOME(LOSS)BEFORE $4,553 -$14,815 -325.39% $6,544 $6,651 101.64% $4,418 -$1,962 TRANSFERS 7/18/2012 27 Ice Arena Budget CITY OF FARMINGTON 2013 BUDGET ICE ARENA ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $101,441 $102,494 101.04% $94,860 $28,616 30.17% $87,295 $91,491 6112 SALARIES-OT $2,725 $963 35.34% $0 $172 #DIV/0! $0 $0 6120 SALARIES-PT $19,910 $37,340 187.54% $37,390 $14,439 38.62% $39,209 $39,798 6130 COMP TIME $0 $824 #DIV/0! $0 $0 #DIV/0! $800 $800 6135 OTHER PAY $0 $1,270 #DIV/0! $0 $273 #DIV/0! $1,300 $1,300 6152 FICA/MEDICARE $9,492 $10,174 107.18% $10,117 $3,281 32.43% $9,838 $10,204 6154 PERA $7,552 $10,837 143.50% $7,530 $2,609 34.65% $6,481 $6,785 6156 HCSP $0 $68 #DIV/0! $0 $0 #DIV/0! $436 $436 6158 EMPLOYEE BENEFITS $33,995 $34,547 101.62% $26,903 $12,628 46.94% $11,600 $12,100 6159 WORKERS COMP $0 $0 #DIV/0! $0 $780 #DIV/0! $0 $0 TOTAL PERSONNEL $175,115 $198,517 113.36% $176,800 $62,798 35.52% $156,960 $162,915 SUPPLIES 5502 COST OF GOODS SOLD $1,400 $1,164 83.14% $1,400 $1,807 129.07% $1,400 $1,400 6220 EQUIPMENT/SUPPLIES $6,800 $3,038 44.68% $1,600 $1,940 121.25% $3,000 $3,000 6240 BUILDING SUPPLIES $5,100 $2,558 50.16% $7,600 $1,908 25.11% $7,600 $7,950 6250 OTHER SUPPLIES $750 $554 73.87% $750 $27 3.60% $750 $750 6255 LANDSCAPE MATERIALS $200 $302 151.00% $0 $0 #DIV/0! $50 $50 6272 FUEL $2,000 $1,759 87.95% $2,000 $916 45.80% $2,000 $2,200 6290 UNIFORMS $1,100 $1,167 106.09% $1,100 $385 35.00% $1,200 $1,200 TOTAL SUPPLIES $17,350 $10,542 60.76% $14,450 $6,983 48.33% $16,000 $16,550 OTHER SERVICES 6401 PROFESSIONAL SERVICES $6,000 $8,249 137.48% $6,000 $3,565 59.42% $6,000 $6,500 6404 IT SERVICES $2,587 $2,587 100.00% $2,936 $1,465 49.90% $9,872 $9,872 6411 TELEPHONE $625 $831 132.96% $1,000 $303 30.30% $1,000 $1,000 6412 CELLULAR TELEPHONES $1,000 $0 0.00% $500 $0 0.00% $500 $500 6421 MUNICIPAL SERVICES $7,000 $4,453 63.61% $7,000 $2,983 42.61% $5,000 $5,100 6422 ELECTRICAL $43,000 $38,356 89.20% $45,000 $21,568 47.93% $42,000 $43,000 6423 NATURAL GAS $22,800 $15,041 65.97% $23,000 $6,870 29.87% $20,000 $21,000 6426 INSURANCE $8,000 $8,000 100.00% $8,000 $4,000 50.00% $8,000 $8,100 6445 POSTAGE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6450 OUTSIDE PRINTING $500 $115 23.00% $500 $0 0.00% $500 $500 6460 DUES/SUBSCRIPTIONS $3,095 $1,146 37.03% $3,020 $1,179 39.04% $2,000 $2,175 6470 TRAINING/SUBSTINANCE $1,450 $959 66.14% $1,500 $0 0.00% $1,500 $1,600 6485 MILEAGE $0 $234 #DIV/0! $0 $0 #DIV/0! $0 $0 6492 ADVERTISING $0 $195 #DIV/0! $0 $0 #DIV/0! $0 $0 7/18/2012 28 Ice Arena Budget 6505 EQUIPMENT MAINT. $8,750 $4,133 47.23% $4,750 $2,568 54.06% $4,750 $5,550 6510 VEHICLE REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6515 BUILDING MAINT. $4,800 $1,897 39.52% $3,300 $109 3.30% $3,300 $4,150 6545 CREDIT CARD FEES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $5,597 #DIV/0! $0 $0 #DIV/0! $0 $0 6556 BUILDING RENT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6570 PROGRAM EXPENSE $3,075 $5,611 182.47% $4,000 $2,892 72.30% $4,700 $5,000 7420 MISCELLANEOUS $0 $18 #DIV/01 $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $112,682 $97,422 86.46% $110,506 $47,502 42.99% $109,122 $114,047 r TOTAL BUDGET $305,147 $306,481 100.44% $301,756 $117,283 38.87% $282,082 ' $293,512 7/18/2012 29 Ice Arena Budget �o�EARMiy�� City of Farmington g>i z 430 Third Street poGOq, 4 Farmington, Minnesota 651.280.6800•Fax 651.280.6899 *r.A PROO\\'4 www.ci.farmington.mn.us DATE: July 23, 2012 TO: Mayor and City Council Members FROM: David J. McKnight, City Administrator SUBJECT: 2013/2014 Administration Related Budgets There should be time at your work session scheduled for Monday, July 23, 2012 to review administration related budgets. If time does not allow, we will bring these budgets back at a future work session. To help you with your review I will point out any significant changes in the proposed budgets below. Administration-Legislative Control-I included $3,000 for the potential purchase of new [pads if needed. Administration-City Administrator-The miscellaneous/reserve line item was reduced to $100,000 to help limit any potential levy increase. Administration-Elections-The budget stays consistent with the 2012 budget because we have to purchase new election equipment in 2013 for the 2014 elections. Human Resources-This budget includes the elimination of a position due to a retirement in 2013. The professional services line item is up due to costs for required drug testing we must perform. Communications-The significant change to this budget is primarily due to the adjusted method of paying for IT Services. This budget requires significant IT time with the website and other communication tools. Finance-No significant changes besides personnel costs. Risk Management-This budget was adjusted slightly for potential increases in our liability insurance costs. 30 Community Development-This budget includes the elimination of a position in 2012. We maintain costs for minor issues like chamber participation, farmers market, etc. The budgets grouped under administration do not have many significant changes but it is important that you get a chance to review them. If you have any questions please let me know. Thank you for your time on this important matter. 2 31 CITY OF FARMINGTON 2013 BUDGET ADMINISTRATION-LEGISLATIVE CONTROL ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6120 SALARIES-PT $36,120 $36,120 100.00% $36,120 $18,511 51.25% $36,120 $36,120 6152 FICA/MEDICARE $2,763 $2,763 100.00% $2,763 $1,416 51.25% $2,763 $2,763 6154 PERA $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $69 $69 100.00% $69 $35 50.72% $146 $146 TOTAL PERSONNEL $38,952 $38,952 100.00% $38,952 $19,962 51.25% $39,029 $39,029 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $42 #DIV/01 $3,000 $2,000 TOTAL OFFICE SUPPLIES $0 $0 #DIV/0! $0 $42 #DIV/0! $3,000 $2,000 OTHER SERVICES 6403 LEGAL $25,000 $15,185 60.74% $22,000 $4,400 20.00% $22,000 $22,500 6250 OTHER SUPPLIES $0 $0 #DIV/0! $0 $42 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $12,515 $14,757 117.91% $14,665 $75 0.51% $15,000 $15,000 6470 TRAINING/SUBSISTANCE $985 $1,408 142.94% $985 $319 32.39% $2,000 $2,000 6485 MILEAGE $200 $265 132.50% $200 $42 21.00% $250 $250 TOTAL OTHER SERVICES $38,700 $31,615 81.69% $37,850 $4,878 12.89% $39,250 $39,750 TOTAL BUDGET $77,652 $70,567 90.88% $76,802 $24,882 32.40% $81,279 $80,779 7/18/2012 3 2 Legislative Control CITY OF FARMINGTON 2013 BUDGET ADMINISTRATION-CITY ADMINISTRATOR ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $266,677 $298,008 111.75% $251,564 $121,197 48.18% $260,910 $260,325 6112 SALARIES-OT $1,375 $0 0.00% $0 $0 #DIV/0! $0 $0 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $0 #DIV/0! $0 $86 #DIV/0! $0 $0 6152 FICA/MEDICARE $20,506 $22,481 109.63% $19,245 $9,475 49.23% $19,960 $19,915 6154 PERA $19,434 $19,615 100.93% $18,238 $8,793 48.21% $18,916 $18,874 6156 HCSP $0 $35 #DIV/0! $0 $221 #DIV/0! $465 $465 6158 EMPLOYEE BENEFITS $95,762 $47,789 49.90% $76,326 $37,306 48.88% $66,017 $62,635 6159 WORKERS COMPENSATION $0 $0 #DIV/0! $0 $860 #DIV/0! $0 $0 TOTAL PERSONNEL . $403,754 $387,928 96.08% $365,373 $177,938 48.70% $366,268 $362,214 SUPPLIES 6210 OFFICE SUPPLIES $27,000 $15,784 58.46% $20,000 $6,762 33.81% $18,000 $18,000 6220 EQUIPMENT SUPPLIES $3,000 $0 0.00% $2,500 $0 0.00% $2,500 $2,500 TOTAL SUPPLIES $30,000 $15,784 52.61% $22,500 $6,762 30.05% $20,500 $20,500 OTHER SERVICES 6401 PROFESSIONAL SERVICES $5,700 $3,623 63.56% $5,700 $3,194 56.04% $6,700 $6,700 6403 LEGAL $11,250 $20,375 181.11% $11,000 $5,034 45.76% $11,000 $11,500 6404 IT SERVICES $7,185 $7,185 100.00% $8,156 $4,078 50.00% $12,823 $7,445 6412 CELLULAR TELEPHONES $840 $405 48.21% $540 $270 50.00% $540 $540 6455 LEGAL PUBLICATION $1,500 $498 33.20% $1,000 $44 4.40% $1,000 $1,050 6460 DUES/SUBSCRIPTIONS $2,755 $289 10.49% $1,500 $112 7.47% $2,050 $2,050 6470 TRAINING/SUBSISTANCE $3,160 $1,139 36.04% $2,000 $0 0.00% $2,100 $2,100 6480 MEETING EXPENSE $0 $35 #DIV/0! $0 $0 #DIV/0! $0 $0 6485 MILEAGE $2,500 $737 29.48% $1,600 $134 8.38% $1,500 $1,500 6492 ADVERTISING $0 $84 #DIV/0! $0 $0 #DIV/0! $0 $0 6505 EQUIPMENT REPAIR $20,920 $18,283 87.39% $18,500 $5,564 30.08% $19,070 $19,070 6555 EQUIPMENT RENTAL $32,700 $33,120 101.28% $32,700 $16,900 51.68% $32,900 $32,900 7420 MISCELLANEOUS $0 $0 #DIV/0! $141,192 $0 0.00% $100,000 $100,000 TOTAL OTHER SERVICES $88,510 $85,773 96.91% $223,888 $35,330 15.78% $189,683 $184,855 TOTAL BUDGET $522,264 $489,485 93.72% $611,761 $220,030 35.97% $576,451 $567,569 7/18/2012 33 City Administrator CITY OF FARMINGTON 2013 BUDGET ADMINISTRATION-ELECTIONS ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6112 SALARIES-OT $0 $0 #DIV/0! $950 $0 0.00% $0 $1,000 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $15,000 6152 FICA/MEDICARE $0 $0 #DIV/0! $73 $0 0.00% $0 $1,224 6154 PERA $0 $0 #DIV/0! $69 $0 0.00% $0 $73 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $0 $0 #DIV/0! $6 $3 50.00% $0 $65 TOTAL PERSONNEL $0 $0 #DIV/0! $1,098 $3 0.27% $0 $17,362 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $300 $34 11.33% $0 $300 6220 EQUIPMENT SUPPLIES $1,925 $1,925 100.00% $1,925 $1,995 103.64% $21,050 $2,100 6250 OTHER SUPPLIES $0 $0 #DIV/01 $2,000 $0 0.00% $1,000 $2,000 TOTAL SUPPLIES $1,925 $1,925 100.00% $4,225 $2,029 48.02% $22,050 $4,400 OTHER SERVICES 6401 PROFESSIONAL SERVICES $0 $0 #DIV/O! $14,500 $1,111 7.66% $0 $0 6403 LEGAL $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6404 IT SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6445 POSTAGE $0 $0 #DIV/0! $400 $0 0.00% $400 $400 6450 OUTSIDE PRINTING $0 $397 #DIV/0! $700 $0 0.00% $0 $700 6455 LEGAL PUBLICATION $0 $0 #DIV/0! $375 $0 0.00% $0 $375 6460 DUES/SUBSCRIPTIONS $0 $0 #DIV/0! $0 $0 #DIV/0I $0 $0 6470 TRAINING/SUBSISTANCE $0 $0 #DIV/O! $0 $0 #DIV/0! $0 $0 6480 MEETING EXPENSE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6485 MILEAGE $0 $0 #DIV/0! $425 $22 5.18% $0 $425 6492 ADVERTISING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6505 EQUIPMENT REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0! $400 $0 0.00% $0 $400 7420 MISCELLANEOUS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $0 $397 #DIV/0! $16,800 $1,133 6.74% $400 $2,300 TOTAL BUDGET $1,925 $2,322 120.62% $22,123 $3,165 14.31% $22,450 $24,062 7/18/2012 H4 Elections CITY OF FARMINGTON 2013 BUDGET 1011 HUMAN RESOURCES ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $155,954 $161,961 103.85% $159,159 $78,708 49.45% $108,222 $109,846 6112 SALARIES-OT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $11,930 $12,576 105.41% $12,176 $6,114 50.21% $8,279 $8,403 6154 PERA $11,307 $11,742 103.85% $11,539 $5,706 49.45% $6,895 $6,998 6156 HCSP $0 $1,231 #DIV/0! $0 $592 #DIV/0! $1,249 $1,300 6158 EMPLOYEE BENEFITS $21,851 $22,466 102.81% $17,985 $8,460 47.04% $20,385 $10,791 6159 WORKERS COMP $0 $0 #DIV/0! $0 $544 #DIV/0! $0 $0 TOTAL PERSONNEL $201,042 $209,976 104.44% $200,859 $100,124 49.85% $145,030 $137,338 SUPPLIES _ 6210 OFFICE SUPPLIES $0 $321 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $0 $321 #DIV/0! $0 $0 #DIV/0! $0 $0 OTHER SERVICES 6401 PROFESSIONAL SERVICES $3,700 $8,905 240.68% $7,200 $2,096 29.11% $14,000 $14,000 6402 DATA PROCESSING $20,000 $20,561 102.81% $27,159 $11,443 42.13% $27,840 $27,840 6403 LEGAL $2,000 $3,930 196.50% $2,000 L $765 38.25% $2,000 $2,000 6404 IT SERVICES $4,024 $4,024 100.00% $4,568 $652 14.27% $12,693 $4,169 6412 CELLULAR TELEPHONES $503 $1,126 223.86% $503 $92 18.29% $220 $220 6455 LEGAL PUBLICATION $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $950 $690 72.63% $950 $699 73.58% $855 $855 6470 TRAINING/SUBSISTANCE $1,890 $125 6.61% $1,890 $695 36.77% $1,465 $1,465 6480 MEETING EXPENSE $0 $704 #DIV/0! $0 $0 #DIV/0! $0 $0 6485 MILEAGE $1,000 $0 0.00% $700 $282 40.29% $800 $800 6494 EMPLOYMENT ADVERTISE $1,000 $1,942 194.20% $1,500 $585 39.00% $2,000 $2,000 6505 EQUIPMENT REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0! $0 $0 #DIV/0I $0 $0 7420 MISCELLANEOUS $2,050 $909 44.34% $1,000 $1,035 103.50% $3,250 $2,300 TOTAL OTHER SERVICES $37,117 $42,916 115.62% $47,470 $18,344 38.64% $65,123 $55,649 TOTAL BUDGET $238,159 $253,213 106.32% $248,329 $118,468 47.71% $210,153 $192,987 7/18/2012 35 Human Resources CITY OF FARMINGTON 2013 BUDGET 1014 ADMINISTRATION-COMMUNICATIONS ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $49,088 $49,234 100.30% $49,579 $23,812 48.03% $50,336 $51,091 6112 SALARIES-OT $0 $0 #DIV/0! $0 $214 #DIV/0! $500 $500 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $35 #DIV/0! $0 $18 #DIV/0! $0 $0 6152 FICA/MEDICARE $3,755 $3,662 97.52% $3,793 $1,868 49.25% $3,889 $3,947 6154 PERA $3,559 $3,572 100.37% $3,594 $1,743 48.50% $3,649 $3,704 6156 HCSP $0 $0 #DIV/0! $0 $154 #DIV/0I $0 $0 6158 EMPLOYEE BENEFITS $12,084 $12,927 106.98% $10,359 $5,047 48.72% $10,206 $10,609 6159 WORKERS COMPENSATION $0 $0 #DIV/0! $0 $169 #DIV/0! $0 $0 TOTAL PERSONNEL $68,486 $69,430 101.38% $67,325 $33,025 49.05% $68,580 $69,851 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 OTHER SERVICES 6401 PROFESSIONAL SERVICES $300 $0 0.00% $300 $0 0.00% $300 $300 6403 LEGAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6404 IT SERVICES $1,150 $1,150 100.00% $1,305 $2,284 175.02% $10,020 $1,191 6412 CELLULAR TELEPHONES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6445 POSTAGE $14,000 $8,322 59.44% $13,500 $6,229 46.14% $13,500 $13,500 6460 DUES/SUBSCRIPTIONS $0 $60 #DIV/0! $0 $0 #DIV/0! $0 $0 6470 TRAINING/SUBSISTANCE $300 $249 83.00% $450 $149 33.11% $450 $450 6480 MEETING EXPENSE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6485 MILEAGE $200 $173 86.50% $200 $68 34.00% $200 $200 6492 ADVERTISING $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6505 EQUIPMENT REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6555 EQUIPMENT RENTAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 7420 MISCELLANEOUS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $15,950 $9,954 62.41% $15,755 $8,730 55.41% $24,470 $15,641 TOTAL BUDGET $84,436 $79,384 94.02% $83,080 $41,755 50.26% $93,050 $85,492 7/18/2012 36 Administration-Communications CITY OF FARMINGTON 2013 BUDGET 1021 FINANCE-ACCOUNTING ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $170,015 $176,586 103.86% $161,067 $90,325 56.08% $163,488 $165,940 6112 SALARIES-OT $2,000 $180 9.00% $0 $273 #DIV/0! $1,000 $1,000 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $20 #DIV/01 $0 $17 #DIV/0! $50 $50 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $13,006 $12,673 97.44% $12,322 $6,677 54.19% $12,587 $12,775 6154 PERA $12,326 $12,817 103.98% $11,677 $5,485 46.97% $13,268 $13,466 6156 HCSP $0 $526 #DIV/0! $0 $252 #DIV/0! $539 $560 6158 EMPLOYEE BENEFITS $35,462 $35,462 100.00% $28,018 $13,463 48.05% $30,741 $31,952 6159 WORKERS COMP $0 $0 #DIV/0! $0 $550 #DIV/0! $0 $0 TOTAL PERSONNEL $232,809 $238,264 102.34% $213,084 $117,042 54.93% $221,673 $225,743 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $500 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/O! $0 $0 6240 BUILDING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6250 OTHER SUPPLIES $0 $0 #DIV/O! $0 $0 #DIV/0! $0 $0 6255 LANDSCAPING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 — 6272 FUEL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $500 $0 OTHER SERVICES 6401 PROFESSIONAL SERVICES $21,600 $14,264 66.04% $34,100 $30,312 88.89% $27,180 $27,180 6402 DATA PROCESSING $38,000 $38,353 100.93% $39,905 $20,400 51.12% $39,905 $39,905 6403 LEGAL $400 $215 53.75% $400 $495 123.75% $400 $400 — 6404 IT SERVICES $5,174 $5,174 100.00% $5,873 $2,936 49.99% $11,645 $11,645 6412 CELLULAR TELEPHONES $300 $300 100.00% $300 $125 41.67% $300 $300 6440 POSTAGE/PRINTING $750 $0 0.00% $0 $0 #DIV/0! $0 $0 6450 OUTSIDE PRINTING $350 $0 0.00% $350 $0 0.00% $350 $350 6455 LEGAL PUBLICATION $400 $262 65.50% $400 $0 0.00% $400 $400 6460 DUES/SUBSCRIPTIONS $1,170 $915 78.21% $1,195 $740 61.92% $995 $995 6470 TRAINING/SUBSISTANCE $1,100 $1,439 130.82% $1,600 $405 25.31% $1,650 $1,650 6485 MILEAGE $1,000 $959 95.90% $900 $415 46.11% $900 $900 7420 MISCELLANEOUS $240 $0 0.00% $0 $148 #DIV/0! $0 $0 TOTAL OTHER SERVICES $70,484 $61,881 87.79% $85,023 $55,976 65.84% $83,725 $83,725 7/18/2012 37 Finance TOTAL BUDGET $303,293 $300,145 98.96% $298,107 $173,018 58.04% $305,898 $309,468 7/18/2012 38 Finance CITY OF FARMINGTON 2013 BUDGET 1022 FINANCE-RISK MANAGEMENT ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6112 SALARIES-OT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6135 OTHER PAY $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6154 PERA $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL PERSONNEL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 SUPPLIES 6210 OFFICE SUPPLIES $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6240 BUILDING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6250 OTHER SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6255 LANDSCAPING SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6272 FUEL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 OTHER SERVICES 6401 PROFESSIONAL SERVICES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6402 DATA PROCESSING $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6403 LEGAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6404 IT SERVICES $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6426 INSURANCE PREMIUMS $127,115 $127,115 100.00% $127,250 $63,625 50.00% $132,250 $137,250 6440 POSTAGE/PRINTING $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 6450 OUTSIDE PRINTING $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6455 LEGAL PUBLICATION $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6470 TRAINING/SUBSISTANCE $0 $0 #DIV/01 $0 $0 #DIV/01 $0 $0 6485 MILEAGE $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 7420 MISCELLANEOUS $0 $0 #DIV/0! $0 $0 #DIV/01 $0 $0 TOTAL OTHER SERVICES $127,115 $127,115 100.00% $127,250 $63,625 50.00% $132,250 $137,250 - 7— TOTAL BUDGET $127,115 $127,115 100.00% $127,250 $63,625 50.00% $132,250 $137,250 7/18/2012 3 9 Risk Management CITY OF FARMINGTON 2013 BUDGET 1035 ADMINISTRATION-COMMUNITY DEVELOPMENT ADOPTED THROUGH APPROVED THROUGH REQUESTED ESTIMATED PERSONNEL 2011 1 12/2011 % 2012 6/2012 % 2013 2014 6110 SALARIES-FT $65,062 $67,872 104.32% $65,713 $10,669 16.24% $0 $0 6112 SALARIES-OT $0 $24 #DIV/0! $0 $0 #DIV/0! $0 $0 6120 SALARIES-PT $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6130 COMP TIME PAY $0 $162 #DIV/0! $0 $0 #DIV/0! $0 $0 6152 FICA/MEDICARE $4,977 $4,805 96.54% $5,027 $763 15.18% $0 $0 6154 PERA $4,717 $4,934 104.60% $4,764 $773 16.23% $0 $0 6156 HCSP $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6158 EMPLOYEE BENEFITS $12,193 $12,561 103.02% $10,469 $5,012 47.87% $0 $0 6159 WORKERS COMP $0 $0 #DIV/0! $0 $224 #DIV/0! $0 $0 TOTAL PERSONNEL $86,949 $90,358 103.92% $85,973 $17,441 20.29% $0 $0 SUPPLIES 6210 OFFICE SUPPLIES $0 $73 #DIV/0! $0 $0 #DIV/0! $0 $0 6220 EQUIPMENT SUPPLIES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL SUPPLIES $0 $73 #DIV/0! $0 $0 #DIV/0! $0 $0 OTHER SERVICES 6401 PROFESSIONAL SERVICES $1,700 $0 0.00% $1,000 $2,043 204.30% $1,000 $1,000 6403 LEGAL $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6404 IT SERVICES $3,499 $3,449 98.57% $3,915 $1,957 49.99% $11,121 $3,574 6412 CELLULAR TELEPHONES $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6455 LEGAL PUBLICATION $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6460 DUES/SUBSCRIPTIONS $500 $0 0.00% $1,000 $1,250 125.00% $1,000 $1,000 6470 TRAINING/SUBSISTANCE $300 $263 87.67% $500 $225 45.00% $500 $500 6480 MEETING EXPENSE $0 $0 #DIV/01 $0 $0 #DIV/0! $0 $0 6485 MILEAGE $400 $85 21.25% $200 $0 0.00% $200 $200 6492 ADVERTISING $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6505 EQUIPMENT REPAIR $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 6570 PROGRAM EXPENSE $0 $0 #DIV/0! $3,300 $1,367 41.42% $3,300 $3,300 7420 MISCELLANEOUS $0 $0 #DIV/0! $0 $0 #DIV/0! $0 $0 TOTAL OTHER SERVICES $6,399 $3,797 59.34% $9,915 $6,842 69.01% $17,121 $9,574 1 TOTAL BUDGET $93,348 $94,228 100.94% $95,888 $24,283 25.32% $17,121 $9,574 7/18/2012 40 Administration-Community Development