Loading...
HomeMy WebLinkAbout4. 2011/2012 Public Works Budgets CITY OF SHAKOPEE Memorandum TO: Gregg Voxland, Finance Director FROM: Bruce Loney, Public Works Director SUBJECT: 2011 Public Works Budget DATE: July 21, 2010 The following is a memo in regard to the changes in the Public Works Budget which includes four divisions being Engineering, Street Maintenance, Fleet Maintenance and Park Maintenance. The major items and explanation of these items are as follows: ENGINEERING The Engineering budget is essentially the same for 2011 as it was in 2010 with the same level of staffing and an increase in the Logis /software object due to the IT rental charge being implemented this year. STREET MAINTENANCE In the personnel section for Street Maintenance, it is being proposed to fill the existing vacant position that has recently been vacated in June, 2010 so that the street, sanitary sewer and storm drainage maintenance will have ten (10) maintenance operators to maintain the systems in the City of Shakopee. In addition, it is proposed to make the Public Works Technician a permanent position, as the 2 -year trial period has shown that this position has sufficient work to be in the Public Works Street Maintenance Division. Also, staff would be proposing for a permanent lead in the Street Maintenance area for 2011. Major items of change in the Street Maintenance include higher pavement preservation costs and higher street light power donation with Shakopee Public Utilities. Both of these costs are offset by revenues received from State Aid and from Shakopee Public Utilities. There has been some increases in material costs, especially with salt and bituminous. Staff has also reduced its fuel usage cost based on information and projection in the fuel industry. One other item to note is that the utility bills have been reduced significantly due to tighter budgeting and better records of actual cost. FLEET MAINTENANCE The major change in Fleet Maintenance is a $35,000 estimated purchase for a gasboy fuel system upgrade which is necessary to work with Windows 7. Staff has notified the other public users of 4 -1 a cost for their share of the upgrade of the gasboy system. Scott County, SPUC and the School District have been notified and are agreeable to that concept. Also, staff would be proposing for a permanent lead in the Fleet Maintenance area and also to review the mechanic apprentice position and work duties and consider a promotion to a mechanic position in 2011. PARK MAINTENANCE In the Park Maintenance area, the major items would be a reduction in pavement preservation with the usage of park asset funds on trail overlays or reconstruction for 2011. Other changes include a recommendation for a permanent lead for the entire year. This concludes my memo on changes and explanations for the Public Works Division budgets which Engineering, Street Maintenance, Fleet Maintenance and Park Maintenance. If you have any questions in regard to this memo, please feel free to contact me in my office. Bruce Loney, P . Public Works Director BL/PmP ENGR/2010- PROJECTS /2010- CORRESPONDENCE/BUDGET -2011 4 -2 CITY OF SHAKOPEE 2011- 2012 GENERAL FUND BUDGET DIVISION: ENGINEERING MISSION STATEMENT: Provide prompt, efficient, and accurate information and engineering services to citizens, elected and appointed officials, developers, contractors, agencies, and other staff members. ACTIVITY: Conduct field investigations, collect engineering data and specify the criteria for the investigations; furnish designs, drawings, specifications and criteria for such designs; secure bids, assist in the award of contracts, oversee and inspect construction to assure compliance with the drawings and specifications; testing and approving all sanitary sewer, storm sewer and roadway construction projects; prepare all reports and studies required to preserve Municipal State Aid Funding received by the City; review all public facilities proposed in the City, Wetland Conservation Act administration, review of building permits, Right of Way Management & Permitting, provide engineering assistance to other Departments, review technical engineering material and provide for City Council, City staff, City Commissions and Committees. Goals: 1. Efficiently, but accurately, provide the services necessary to insure public improvements are designed and installed per City standards. 2. Keep public improvement project costs to within 20% of the cost estimated in the feasibility report. Measurement of Goals: Compare revenues created in Engineering Division: Actual Budgeted Requested Requested 2009 2010 2011 2012 Expenditures $551,152 $663,030 $661,630 $679,630 Population 34,691 34,000 35,100 35,300 Expenditure /Capita $15.89 $19.50 $18.85 $19.25 Revenue* $ $370,500 $322,500 $322,500 Number of projects 3 5 4 3 Value of projects $1,668,916 $3,605,000 $5,440,000 $2,050,000 Average project cost /feasibility est. $556,305 $721,000 $1,360,000 $683,333 * Includes Engineering Fees Private Developments, Grading Permits, Public Improvements, and Right -of -way Permits Staff 2009 2010 2011 2012 Public Works Director 1 1 1 1 Assistant City Engineer 1 1 1 1 4 -3 Project Engineer 1 1 1 1 Graduate Engineer 1 1 Technician IV 1 1 1 1 Technician III 1 1 1 1 GIS Technician 1 1 1 1 Secretary .9 .9 .9 .9 OBJECT DESCRIPTION: Description of lines items: Operating Supplies: General operating supplies and small tools /equipment $5,000. Office supplies for drawings, ink pens for plotter and various engineering office supplies $7,000. Equipment Maintenance: Plotter repair and survey instruments maintenance, vehicle maintenance $8,500. Motor Fuels & Lubricants: $7,000 ($6,000 in 2012) Professional Services: Attorney $5,000, transportation studies $9,000, GIS and pavement management software support and training $1,000, miscellaneous services $4,000. Communications: Telephone, cellular phones and office phones for Engineering staff $5,500. Rentals: Software Computer software upgrades and licenses for AutoCad $3,000, GIS software $3,000, IT charges $15,760 ($16,970 in 2012). Building rent $8,160 ($8,290 in 2012) Equipment rental of vehicles $5,500 ($3,580 in 2012). Dues/Training/Travel: Conferences /School /Training: Inspection certification and AutoCad /computer training and supervisor training $7,000, Dues $1,000, mileage reimbursement $3,750. Expenses Charged Back: $6,310 ($6,130 in 2012). 4 -4 R5509BUD SH005PV CITY OF SHAKOPEE 8/11/2010 14:04:55 By Co, Div (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 1 Fiscal Period: 7 / 10 Level Of Rollup 6 2008 2009 7131/2010 2010 2011 2012 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget 01000 GENERAL FUND 41 ENGINEERING 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4200 LICENSES AND PERMITS 4250 PERMITS 39,478- 85,898- 47,382- 40,000- 70,000- 70,000- 4200 LICENSES AND PERMITS 39,478- 85,898- 47,382- 40,000- 70,000- 70,000- 4500 CHARGES FOR SERVICE 4510 ADMINISTRATIVE CHARGES 3,327- 3,308- 3,422- 2,500- 2,500- 2,500- 4600 ENGINEERING 335,348- 325,682- 190,075- 330,000- 250,000- 250,000- 4500 CHARGES FOR SERVICE 338,675- 328,990- 193,497- 332,500- 252,500- 252,500- 4830 MISCELLANEOUS 4001 REVENUES 378,153- 414,888- 240,879- 372,500- 322,500- 322,500- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 430,083 369,003 201,205 403,510 381,940 388,920 6100 BENEFITS 131,336 123,771 62,548 150,300 156,960 174,480 6001 WAGES & BENEFITS 561,420 492,774 263,753 553,810 538,900 563,400 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 15,814 4,963 1,705 20,500 21,500 20,000 6300 PROFESSIONAL SERVICES 25,244 14,248 3,087 30,000 30,000 28,000 6330 COMMUNICATIONS 5,758 5,750 2,982 10,150 10,150 10,150 6350 INSURANCE 8,070 6,320 5,986 6,630 7,200 7,200 6400 RENTALS 18,601 19,093 12,609 19,790 35,420 34,850 6470 DUES/TRAINING/TRAVEL 6,399 1,763 1,491 12,150 12,150 9,900 6498 EXPENSE CHARGED BACK 4,478 6,242 10,000 6,310 6,130 6200 SUPPLIES AND SERVICES 84,365 58,379 27,860 109,220 122,730 116,230 6500 DEPRECIATION 6600 MISCELLANEOUS 6700 CAPITAL OUTLAY 6800 DEBT SERVICE 6000 EXPENDITURES 645,785 551,153 291,613 663,030 661,630 679,630 8050 TOTAL TRANSFERS OUT 4000 REVENUES AND EXPENDITURES 267,632 136,266 50,734 290,530 339,130 357,130 41 ENGINEERING 267,632 136,266 50,734 290,530 339,130 357,130 4 -5 Engineering 2011 -12 Budget 2011 2012 2011 2012 2011 2012 0411 411 412 412 413 413 Transportatio Transportatio Object # Description Management Management County Proj County Proj n n 6002 Wages FT - Reg. 188,320 195,640 32,350 32,350 35,590 35,590 6005 Wages OT - Reg. 6015 Wages PT - Temp 3,200 3,030 6122 PERA 13,650 14,180 2,350 2,350 2,810 2,800 6124 FICA 14,420 14,980 2,470 2,470 2,970 2,950 6135 Health 82,330 98,790 6139 PEHP 2,100 2,100 6140 Life 1,850 1,850 6145 Dental 3,360 3,360 6170 Workers Comp 1,590 1,620 140 140 160 160 6180 Compensated Absences 8,000 8,000 6185 OPEB Total Personnel 315,620 340,520 37,310 37,310 44,730 44,530 6202 Operating Supplies 5,000 5,000 6210 Office Supplies 7,000 6,500 6222 Motor Fuels & Lubricants 7,000 6,000 6240 Equipment Maintenance 2,500 2,500 6310 Attorney 5,000 5,000 6312 Engineering Consultants 5,000 3,000 10,000 10,000 6316 Equipment Maintenance 6,000 6,000 6327 Other Prof Services 4,000 4,000 6332 Postage 1,650 1,650 6334 Telephone 1,000 1,000 6336 Printing /Publishing 1,000 1,000 6352 Liability Insurance 5,900 5,900 6356 Auto Insurance 1,300 1,300 6410 Software 21,760 22,970 6425 Equipment Rent (IS FUND) 5,500 3,580 6430 Building Rent (IS FUND) 8,160 8,300 6435 Other Rent 6472 Conf / School / Training 7,000 6,000 6475 Travel /Subsistence 3,750 2,500 6480 Dues 1,000 1,000 6490 Subscriptions /Publications 400 400 6498 Expenses Charged Back 6,310 6,130 Total Supplies & Services 106,230 99,730 - - 10,000 10,000 6740 Capital Expenditures Total $ 421,850 $ 440,250 $ 37,310 $ 37,310 $ 54,730 $ 54,530 4 -6 Engineering 2011 -12 Budget 2011 2012 2011 2012 2011 0419 419 5000 5000 5500 Eng Object # Description ROW MGT ROW MGT Eng Projects Eng Projects DevProjects 6002 Wages FT - Reg. 45,290 45,290 58,990 58,990 - 6005 Wages OT - Reg. 12,000 12,000 3,000 6015 Wages PT - Temp 3,200 3,030 6122 PERA 3,280 3,280 5,380 5,370 220 6124 FICA 3,460 3,460 5,680 5,660 230 6135 Health 6139 PEHP 6140 Life 6145 Dental 6170 Workers Comp 190 190 310 310 10 6180 Compensated Absences 6185 OPEB Total Personnel 52,220 52,220 85,560 85,360 3,460 6202 Operating Supplies 6210 Office Supplies 6222 Motor Fuels & Lubricants 6240 Equipment Maintenance 6310 Attorney 6312 Engineering Consultants 6316 Equipment Maintenance 6327 Other Prof Services 6332 Postage 6334 Telephone 1,000 1,000 2,500 2,500 1,000 6336 Printing /Publishing 2,000 2,000 6352 Liability Insurance 6356 Auto Insurance 6410 Software 6425 Equipment Rent (IS FUND) 6430 Building Rent (IS FUND) 6435 Other Rent 6472 Conf / School / Training 6475 Travel /Subsistence 6480 Dues 6490 Subscriptions /Publications 6498 Expenses Charged Back Total Supplies & Services 1,000 1,000 4,500 4,500 1,000 6740 Capital Expenditures Total $ 53,220 $ 53,220 $ 90,060 $ 89,860 $ 4,460 4 -7 Engineering 2011 -12 Budget 2012 2011 2012 5500 Eng Object # Description DevProjects Total Total 6002 Wages FT - Reg. 360,540 367,860 6005 Wages OT - Reg. 3,000 15,000 15,000 6015 Wages PT - Temp 6,400 6,060 6122 PERA 220 27,690 28,200 6124 FICA 230 29,230 29,750 6135 Health 82,330 98,790 6139 PEHP 2,100 2,100 6140 Life 1,850 1,850 6145 Dental 3,360 3,360 6170 Workers Comp 10 2,400 2,430 6180 Compensated Absences 8,000 8,000 6185 OPEB - - Total Personnel 3,460 536,900 563,400 6202 Operating Supplies 5,000 5,000 6210 Office Supplies 7,000 6,500 6222 Motor Fuels & Lubricants 7,000 6,000 6240 Equipment Maintenance 2,500 2,500 6310 Attorney 5,000 5,000 6312 Engineering Consultants 15,000 13,000 6316 Equipment Maintenance 6,000 6,000 6327 Other Prof Services 4,000 4,000 6332 Postage 1,650 1,650 6334 Telephone 1,000 5,500 5,500 6336 Printing /Publishing 3,000 3,000 6352 Liability Insurance 5,900 5,900 6356 Auto Insurance 1,300 1,300 6410 Software 21,760 22,970 6425 Equipment Rent (IS FUND) 5,500 3,580 6430 Building Rent (IS FUND) 8,160 8,300 6435 Other Rent - - 6472 Conf / School / Training 7,000 6,000 6475 Travel /Subsistence 3,750 2,500 6480 Dues 1,000 1,000 6490 Subscriptions /Publications 400 400 6498 Expenses Charged Back 6,310 6,130 Total Supplies & Services 1,000 122,730 116,230 6740 Capital Expenditures - - Total $ 4,460 $ 661,630 $ 679,630 4-8 CITY OF SHAKOPEE 2011- 2012 GENERAL FUND BUDGET DIVISION: STREET MISSION STATEMENT: To provide public services in a professional, cost - effective manner in order to maintain the public investment of infrastructure in streets, alleys and public parking lots. ACTIVITY: Maintain bituminous and gravel roadways /alleys, traffic signs /striping, snowplowing /ice control, street sign fabrication /installation, boulevard tree trimming /removal, and disease tree prevention. GOALS: 1. Provide snowplowing and ice control in a timely and cost effective manner. 2. Provide street /alley maintenance in a cost - effective manner. MEASUREMENT OF GOALS: (* Does not include equipment rental rate.) Actual Budgeted Requested Requested 2009 2010 2011 2012 Expenditures $1,842,126 $1,947,510 $2,059,700 $2,071,630 Population 34,691 34,000 35,100 35,300 Expenditure /Capita $53.10 $57.28 $58.68 $58.69 Snowplowing /ice control $226,348 $188,050 $200,160 $205,160 Cost per capita $6.72 $5.53 $5.70 $5.81 Street and alley maintenance $518,619 $628,720 $772,810 $762,110 Cost per capita $15.41 $18.49 $22.02 $21.59 Lane miles of street /alley 467 467 467 467 Snow plow /salting events 29 30 30 30 Tons of salt applied 1,743 1,400 1,800 1,800 Tons of patching material 131 150 240 240 Sq Yards seal coat 1 279,000 289,000 1 305,000 315,000 4 -9 Staff 2009 2010 2011 2012 Public Works Superintendent 1 1 1 1 Street /Util. Supervisor 1 1 1 1 Engineering Tech IV 0 1 1 1 Maintenance Operator 6 6 4 4 OBJECT DESCRIPTION: Description of lines items: Salaries: Director (20 %), Public Works Supervisor (40 %), 1 Engineering Tech IV, 1 Street Supervisor, 10 Maintenance Operators (6 Utilities), Secretary (30 %). (including 1 Lead) Salaries - Temp: Temporary seasonal employees - (3- summer with one seasonal employee funded by sanitary/storm enterprise funds, 4- winter). Operating Supplies (6202): Striping $2,500; signs $17,500; floor mats $1,000; safety equipment $1,500; street light pole paint $1,000; various supplies $5,500. Office Supplies (6210): General office supplies $1,000. Uniforms /Clothing (6212): $5,400. Materials (6215): Ice control materials $95,000 ($100,000 in 2012); gravel $6,000; bituminous mix $15,000; trees $1,000; concrete $3,000. Motor Fuel and Lubricants (6222): $50,000 ($55,000 in 2012) Building Maintenance (6230): Miscellaneous maintenance $8,500 Equipment Maintenance (6240): Vehicle maintenance; truck washes /car washes $32,000 Professional Services Building Maintenance (6315): Miscellaneous $7,500 Equipment Maintenance (6316): Vehicle /equipment repairs $115,000; SPUC street light & signal repairs and street light pole replacement $20,000 Pavement Preservation (6322): Crack sealing $30,000; seal coating $391,700 ($385,000 in 2012). 4 -10 Other Professional Services (6327): Includes paint striping of streets $30,000 ($30,000 in 2012); paint striping of crosswalks on county roads $5,000; drug testing $2,000; traffic signal maintenance $3,000; tree trimming /removal /disposal /stump grinding $5,000; support for sign /pavement programs $3,000; Clean -up Day $30,000; miscellaneous services $10,500. Communications (6334): Telephone: Office phones and cellular phones for Public Works Supervisor, Street Supervisor and Maintenance Operators $3,500. Printing /Publishing (6336) Printing /publishing $1,000. Utility Service: Utilities include Electric, Water, Gas, Sewer, Storm Utilities for public works buildings $98,000 ($92,500 in 2012). Street lights and signals $220,000 (SPUC electric donation $200,000) Software (6410): $20,500 ($21,500 in 2012) Includes IT Rental $14,480 ($15,270 in 2012) and Cartegraph Support $6,000 Equipment Rent - IS Fund $105,420 ($95,750 in 2012) Building rent for new and old buildings 22% $44,900 ($45,610 in 2012) Other Rent (6435) None Conference /Training (6472): $2,000 ($6,000 in 2012) Subscriptions /Publications (6490): $150 Expense Charged Back (6498): Facilities charge back for PW buildings to Engineering, Fleet, Park, Sewer and Storm funds - $123,070 (- $119,490 in 2012). Special Assessments (6620): Gorman Street $12,970 ($9,110 in 2012) Capital Equipment (6740): None 4 -11 R5509BUD SH005PV CITY OF SHAKOPEE 8/11/2010 14:04:55 By Co, Div (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 2 Fiscal Period: 7 / 10 Level Of Rollup 6 2008 2009 7/31/2010 2010 2011 2012 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget 42 STREET MAINTENANCE 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4100 SPECIAL ASSESSMENT 4110 SPECIAL ASSESSMENT PRINCIPAL 8,000- 8,000- 4111 SPEC ASSESSMENT INTEREST 2,500- 2,500- 4120 SA PREPAY 2,500- 2,500- 4100 SPECIAL ASSESSMENT 13,000- 13,000- 4200 LICENSES AND PERMITS 4400 INTERGOVERNMENTAL 4450 STATE GRANTS & AIDS 8,990- 255,927- 348,763- 273,330- 386,130- 386,130- 4400 INTERGOVERNMENTAL 8,990- 255,927- 348,763- 273,330- 386,130- 386,130- 4500 CHARGES FOR SERVICE 4670 PUBLIC WORKS 22,141- 2,498- 1,260- 21,500- 5,000- 10,400- 4750 REFUSE 7,509- 10,817- 9,639- 9,000- 9,000- 9,500- 4760 RECREATION FEES 12,376- 1,362- 1,824- 15,000- 15,000- 4500 CHARGES FOR SERVICE 42,025- 14,677- 12,723- 45,500- 29,000- 19,900- 4001 REVENUES 51,016- 270,604- 361,486- 318,830- 428,130- 419,030- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 435,584 435,456 227,677 474,560 481,680 485,920 6100 BENEFITS 180,141 183,862 87,418 216,980 222,050 242,790 6001 WAGES & BENEFITS 615,725 619,318 315,094 691,540 703,730 728,710 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 247,287 214,894 138,661 236,900 254,900 265,050 6300 PROFESSIONAL SERVICES 455,114 555,286 137,932 561,500 648,200 642,250 6330 COMMUNICATIONS 4,191 4,357 3,157 4,500 4,500 4,500 6350 INSURANCE 58,424 50,939 50,436 57,800 59,100 59,600 6360 UTILITY SERVICE 198,666 301,028 59,671 335,000 326,000 312,500 6400 RENTALS 271,667 186,802 105,451 175,730 170,820 162,850 6470 DUES/TRAINING/TRAVEL 3,927 3,644 4,504 2,550 2,550 6,550 6498 EXPENSE CHARGED BACK 79,488- 110,788- 128,200- 123,070- 119,490- 6200 SUPPLIES AND SERVICES 1,159,788 1,206,162 499,811 1,245,780 1,343,000 1,333,810 6500 DEPRECIATION 6600 MISCELLANEOUS 6620 PROPERTY TAX/SPECIAL ASSESS 10,752 10,210 9,644 10,190 12,970 9,110 6600 MISCELLANEOUS 10,752 10,210 9,644 10,190 12,970 9,110 6700 CAPITAL OUTLAY 6740 EQUIPMENT 7,681 6700 CAPITAL OUTLAY 7,681 6800 DEBT SERVICE 6000 EXPENDITURES 1,793,946 1,835,690 824,550 1,947,510 2,059,700 2,071,630 8050 TOTAL TRANSFERS OUT 4 -12 R5509BUD SH005PV CITY OF SHAKOPEE 8/11/2010 14:04:55 By Co, Div (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 3 Fiscal Period: 7 / 10 Level Of Rollup 6 2008 2009 7/31/2010 2010 2011 2012 Actual Actual YTD Final Proposed Proposed Object Code ! Description Amount Amount Actual Budget Budget Budget 4000 REVENUES AND EXPENDITURES 1,742,930 1,565,087 463,064 1,628,680 1,631,570 1,652,600 42 STREET MAINTENANCE 1,742,930 1,565,087 463,064 1,628,680 1,631,570 1,652,600 4 -13 Street 2011 -12 Budget 2011 2012 2011 2012 2011 2012 0421 0421 0422 0422 0423 0423 Object Description Manage. Manage. TreeNVeed Tree/Weed Signs Signs 6002 Wages FT- Reg. $ 204,490 $ 208,730 $ 16,070 $ 16,070 $ 25,080 $ 25,080 6005 Wages OT - Reg. 6010 Premium Pay 4,700 4,700 6015 Wages PT - Temp 500 500 3,500 3,500 2,500 2,500 6122 PERA 15,190 15,510 1,420 1,420 2,000 2,000 6124 FICA 16,040 16,360 1,500 1,500 2,110 2,110 6135 Health 91,470 109,760 6139 PEHP 2,100 2,100 6140 Life 2,100 2,100 6145 Dental 3,360 3,360 6170 Workers Comp 9,930 10,260 1,490 1,490 2,100 2,100 6180 Compensated Absences 14,000 14,000 6185 OPEB Total Personnel 363,880 387,380 23,980 23,980 33,790 33,790 6202 Operating Supplies 3,000 3,000 1,000 1,000 17,500 17,500 6210 Office Supplies 1,000 1,000 6212 Uniforms 5,400 5,400 6215 Materials 1,000 1,000 6222 Motor Fuels & Lubricants 50,000 55,000 6230 Building Maintenance 6240 Equipment Maintenance 6310 Attorney 500 500 6315 Building Maintenance 6316 Equipment Maintenance 6322 Pavement Preservation 6327 Other Prof Services 2,000 2,000 5,000 5,000 6,000 6,000 6334 Telephone 3,500 3,500 6336 Printing /Publishing 1,000 1,000 6352 Liability Insurance 19,100 19,600 6354 Property Insurance 6,000 6,000 6356 Auto Insurance 18,000 18,000 6362 Electric Service 6364 Water 6365 Gas 6367 Refuse 6366 Sewer 6368 Storm 6410 Software 20,500 21,500 6425 Equipment Rent (IS FUND) 105,420 95,740 6430 Building Rent (IS FUND) 44,900 45,610 6435 Other Rent 6472 Conf / School / Training 2,000 6,000 6475 Travel /Subsistence 6480 Dues 400 400 6490 Subscriptions /Publications 150 150 6498 Expenses Charged Back 6620 Special Assessments 12,970 9,110 Total Supplies & Services 295,840 293,510 7,000 7,000 23,500 23,500 6740 Capital Expenditures Total $ 659,720 $ 680,890 $ 30,980 $ 30,980 $ 57,290 $ 57,290 4 -14 Street 2011 -12 Budget 2011 2012 2011 2012 2011 2012 0424 0424 0425 0425 0426 0426 Object Description Snow /Sand Snow /Sand PW Bldg/Yard PW Bldg/Yard Eq. Maint Eq. Maint 6002 Wages FT - Reg. $ 61,940 $ 61,940 $ 31,280 $ 31,280 $ 10,980 $ 10,980 6005 Wages OT - Reg. 19,000 19,000 6010 Premium Pay 6015 Wages PT - Temp 4,500 4,500 2,000 2,000 6122 PERA 6,190 6,190 2,410 2,410 800 800 6124 FICA 6,540 6,540 2,550 2,550 840 840 6135 Health 6139 PEHP 6140 Life 6145 Dental 6170 Workers Comp 6,490 6,490 2,530 2,530 830 830 6180 Compensated Absences 6185 OPEB Total Personnel 104,660 104,660 40,770 40,770 13,450 13,450 6202 Operating Supplies 500 500 500 500 10,000 10,000 6210 Office Supplies 6212 Uniforms 6215 Materials 95,000 100,000 6222 Motor Fuels & Lubricants 6230 Building Maintenance 3,500 3,500 6240 Equipment Maintenance 32,000 32,000 6310 Attorney 6315 Building Maintenance 6316 Equipment Maintenance 115,000 115,000 6322 Pavement Preservation 6327 Other Prof Services 6334 Telephone 6336 Printing /Publishing 6352 Liability Insurance 6354 Property Insurance 6356 Auto Insurance 6362 Electric Service 6364 Water 6365 Gas 6367 Refuse 6366 Sewer 6368 Storm 6410 Software 6425 Equipment Rent (IS FUND) 6430 Building Rent (IS FUND) 6435 Other Rent 6472 Conf / School / Training 6475 Travel /Subsistence 6480 Dues 6490 Subscriptions /Publications 6498 Expenses Charged Back 6620 Special Assessments Total Supplies & Services 95,500 100,500 4,000 4,000 157,000 157,000 6740 Capital Expenditures Total $ 200,160 $ 205,160 $ 44,770 $ 44,770 $ 170,450 $ 170,450 4 -15 Street 2011 -12 Budget 2011 2012 2011 2012 2011 2012 0427 0427 0428 0428 0429 0429 Object Description St. Maint St. Maint Seal Coat Seal Coat Facilities Facilities 6002 Wages FT - Reg. $ 24,340 $ 24,340 $ 13,670 $ 13,670 $ 24,920 $ 24,920 6005 Wages OT - Reg. 5,000 5,000 6010 Premium Pay 6015 Wages PT -Temp 8,500 8,500 500 500 6122 PERA 2,740 2,740 1,030 1,030 1,810 1,810 6124 FICA 2,890 2,890 1,080 1,080 1,910 1,910 6135 Health 7,390 8,870 6139 PEHP 6140 Life 6145 Dental 6170 Workers Comp 2,880 2,880 1,080 1,080 1,150 1,150 6180 Compensated Absences 6185 OPEB Total Personnel 46,350 46,350 17,360 17,360 37,180 38,660 6202 Operating Supplies 1,000 1,000 9,500 1,500 6210 Office Supplies 6212 Uniforms 6215 Materials 19,000 19,000 6222 Motor Fuels & Lubricants 6230 Building Maintenance 5,000 5,000 6240 Equipment Maintenance 150 6310 Attorney 6315 Building Maintenance 7,500 8,250 6316 Equipment Maintenance 20,000 20,000 6322 Pavement Preservation 30,000 30,000 391,700 385,000 6327 Other Prof Services 10,500 10,500 6334 Telephone 6336 Printing /Publishing 6352 Liability Insurance 6354 Property Insurance 16,000 16,000 6356 Auto Insurance 6362 Electric Service 220,000 220,000 40,000 40,000 6364 Water 8,000 6,500 6365 Gas 35,000 35,000 6367 Refuse 8,000 6366 Sewer 8,000 4,000 6368 Storm 7,000 7,000 6410 Software 6425 Equipment Rent (IS FUND) 6430 Building Rent (IS FUND) 6435 Other Rent 6472 Conf / School / Training 6475 Travel /Subsistence 6480 Dues 6490 Subscriptions /Publications 6498 Expenses Charged Back (123,070) (119,490) 6620 Special Assessments Total Supplies & Services 308,500 300,500 391,700 385,000 4,930 3,910 6740 Capital Expenditures Total $ 354,850 $ 346,850 $ 409,060 $ 402,360 $ 42,110 $ 42,570 4 -16 Street 2011 -12 Budget 2011 2012 2011 2012 2011 2012 0430 0430 0432 0432 0433 0433 Object Description Alley Maint Alley Maint Sidewalk Maint Sidewalk Maint Striping Striping 6002 Wages FT - Reg. $ 5,130 $ 5,130 $ 2,490 $ 2,490 $ 4,500 $ 4,500 6005 Wages OT - Reg. 6010 Premium Pay 6015 Wages PT - Temp 500 500 2,500 2,500 6122 PERA 410 410 180 180 510 510 6124 FICA 430 430 190 190 540 540 6135 Health 6139 PEHP 6140 Life 6145 Dental 6170 Workers Comp 430 430 190 190 530 530 6180 Compensated Absences 6185 OPEB Total Personnel 6,900 6,900 3,050 3,050 8,580 8,580 6202 Operating Supplies 500 500 2,500 2,500 6210 Office Supplies 6212 Uniforms 6215 Materials 2,000 2,000 3,000 3,000 6222 Motor Fuels & Lubricants 6230 Building Maintenance 6240 Equipment Maintenance 6310 Attorney 6315 Building Maintenance 6316 Equipment Maintenance 6322 Pavement Preservation 6327 Other Prof Services 30,000 30,000 6334 Telephone 6336 Printing /Publishing 6352 Liability Insurance 6354 Property Insurance 6356 Auto Insurance 6362 Electric Service 6364 Water 6365 Gas 6367 Refuse 6366 Sewer 6368 Storm 6410 Software 6425 Equipment Rent (IS FUND) 6430 Building Rent (IS FUND) 6435 Other Rent 6472 Conf / School / Training 6475 Travel /Subsistence 6480 Dues 6490 Subscriptions /Publications 6498 Expenses Charged Back 6620 Special Assessments Total Supplies & Services 2,000 2,000 3,500 3,500 32,500 32,500 6740 Capital Expenditures Total $ 8,900 $ 8,900 $ 6,550 $ 6,550 $ 41,080 $ 41,080 4-17 Street 2011 -12 Budget 2011 2012 2011 2012 0434 0434 Object Description Clean Up Day Clean Up Day Total Total 6002 Wages FT - Reg. $ 3,090 $ 3,090 $ 427,980 $ 432,220 6005 Wages OT - Reg. 24,000 24,000 6010 Premium Pay 4,700 4,700 6015 Wages PT - Temp 25,000 25,000 6122 PERA 220 220 34,910 35,230 6124 FICA 240 240 36,860 37,180 6135 Health 98,860 118,630 6139 PEHP 2,100 2,100 6140 Life 2,100 2,100 6145 Dental 3,360 3,360 6170 Workers Comp 230 230 29,860 30,190 6180 Compensated Absences 14,000 14,000 6185 OPEB - - Total Personnel 3,780 3,780 703,730 728,710 6202 Operating Supplies 38,000 38,000 6210 Office Supplies 1,000 1,000 6212 Uniforms 5,400 5,400 6215 Materials 120,000 125,000 6222 Motor Fuels & Lubricants 50,000 55,000 6230 Building Maintenance 8,500 8,500 6240 Equipment Maintenance 32,000 32,150 6310 Attorney 500 500 6315 Building Maintenance 7,500 8,250 6316 Equipment Maintenance 135,000 135,000 6322 Pavement Preservation 421,700 415,000 6327 Other Prof Services 30,000 30,000 83,500 83,500 6334 Telephone 3,500 3,500 6336 Printing /Publishing 1,000 1,000 6352 Liability Insurance 19,100 19,600 6354 Property Insurance 22,000 22,000 6356 Auto Insurance 18,000 18,000 6362 Electric Service 260,000 260,000 6364 Water 8,000 6,500 6365 Gas 35,000 35,000 6367 Refuse 8,000 - 6366 Sewer 8,000 4,000 6368 Storm 7,000 7,000 6410 Software 20,500 21,500 6425 Equipment Rent (IS FUND) 105,420 95,740 6430 Building Rent (IS FUND) 44,900 45,610 6435 Other Rent - - 6472 Conf / School / Training 2,000 6,000 6475 Travel /Subsistence - - 6480 Dues 400 400 6490 Subscriptions /Publications 150 150 6498 Expenses Charged Back (123,070) (119,490) 6620 Special Assessments 12,970 9,110 Total Supplies & Services 30,000 30,000 1,355,970 1,342,920 6740 Capital Expenditures - - Total $ 33,780 $ 33,780 $ 2,059,700 $ 2,071,630 4 -18 CITY OF SHAKOPEE 2011/2012 GENERAL FUND BUDGET DIVISION: FLEET MISSION STATEMENT: To provide fleet maintenance services in a professional, cost - effective manner in order to maintain the public investment of vehicles and equipment for all city departments. ACTIVITY: Maintain vehicles /equipment in streets, park, administration, police, fire, S.P.U.C., fabrication of new and existing equipment, prepare vehicle evaluation reports for all departments. Repairs for vehicles and equipment are billed to the respective departments. Operate car and truck wash for government vehicles and operate fueling stations for city, county, school district and SPUC vehicles. GOAL: To provide quality maintenance to all departments in a cost - effective manner. MEASUREMENT OF GOALS: Average cost per vehicle /equipment maintained Actual Budgeted Requested Requested 2009 2010 2011 2012 Net Expenditures $90,751 $103,640 $122,330 $99,830 Population 34,691 34,000 35,100 35,300 Expenditure /Capita $2.62 $3.05 $3.49 $2.83 Number of vehicles /equipment 313 313 314 314 Staff 2009 2010 2011 2012 Mechanic 2 2 2 2 Mechanic Apprentice 1 1 1 1 Secretary 1 1 1 1 OBJECT DESCRIPTION: Description of lines items: Wages & Benefits: Salaries: Public Works Director (5 %), Public Works Supervisor (20 %), 2 Mechanics- including 1 Lead, 1 Mechanic's Apprentice, and 1 temporary employee from School Employment Program $7,500, Secretary (40 %). Operating Supplies (6202): Various shop supplies $8,300, truck wash supplies $3,000, car wash supplies $2,000, scanner up- date $1,200. 4 -19 Equipment maintenance (6240) Miscellaneous equipment maintenance $1,500. Merchandise (6250) Shop parts $2,000. Professional Equipment Maintenance (6316): Crane /hoist inspections $1,200, Gas Boy fuel system repairs and miscellaneous $1,500, truck wash maintenance $2,000, car wash maintenance $1,800, fuel system maintenance $3,000. Other Professional Services (6327): Miscellaneous $1,000. Telephone (6334) Shop telephone $1,500. Utility (electric) service -truck wash (6362): $4,000 Utility (water) service -truck wash (6364): $400 Software (6410): IT Fund $7,880, ($8,480 in 2012), Fleet computer services $700 Building Rental (6430): Building rental 22% $44,900 ($45,610 in2012). Conferences /Schooling /Training (6472): Various training including schooling for the apprentice $1,000. Expense Charge Back (6498): $34,710 ($33,700 in 2012) Capital Expenditure (6700): Gasboy Fuel System Upgrade $35,000. 4 -20 R55o9BUD SH005PV CITY OF SHAKOPEE 8/11/2010 14:04:55 By Co, Div (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 4 Fiscal Period: 7 / 10 Level Of Rollup 6 2008 2009 7/31/2010 2010 2011 2012 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget 44 FLEET 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4200 LICENSES AND PERMITS 4500 CHARGES FOR SERVICE 4670 PUBLIC WORKS 87,396- 9,913- 18,452- 18,300- 8,300- 8,300- 4760 RECREATION FEES 520 5,032- 368- 4500 CHARGES FOR SERVICE 86,876- 14,945- 18,820- 18,300- 8,300- 8,300- 4001 REVENUES 86,876- 14,945- 18,820- 18,300- 8,300- 8,300- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 192,042 202,513 109,752 191,370 196,890 200,700 6100 BENEFITS 71,683 79,893 37,857 92,860 90,780 99,320 6001 WAGES & BENEFITS 263,724 282,407 147,608 284,230 287,670 300,020 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 24,680 15,166 6,625 21,300 21,300 21,300 6300 PROFESSIONAL SERVICES 13,280 15,292 9,439 11,200 11,200 10,500 6330 COMMUNICATIONS 3,281 2,625 1,300 2,250 2,250 2,250 6350 INSURANCE 852 759 825 900 900 1,400 6360 UTILITY SERVICE 3,710 4,013 1,992 4,100 4,400 4,400 6400 RENTALS 37,972 42,440 30,443 52,890 53,900 55,260 6470 DUES/TRAINING/TRAVEL 575 975 25 1,000 1,000 1,000 6497 FLEET CHARGE BACK 233,310- 310,372- 185,836- 330,000- 330,000- 330,000- 6498 EXPENSE CHARGED BACK 26,869 37,449 55,680 34,710 33,700 6200 SUPPLIES AND SERVICES 122,091- 191,653- 135,188- 180,680- 200,340- 200,190- 6500 DEPRECIATION 6600 MISCELLANEOUS 6700 CAPITAL OUTLAY 6740 EQUIPMENT 6,438 35,000 6700 CAPITAL OUTLAY 6,438 35,000 6800 DEBT SERVICE 6000 EXPENDITURES 141,633 97,192 12,420 103,550 122,330 99,830 8050 TOTAL TRANSFERS OUT 4000 REVENUES AND EXPENDITURES 54,758 82,246 6,399- 85,250 114,030 91,530 44 FLEET 54,758 82,246 6,399- 85,250 114,030 91,530 4 -21 Fleet 2011 -12 Budget 2011 2012 2011 2012 0441 0441 0450 0450 Object # Description Manage. Manage. Car Wash Car Wash 6002 Wages FT - Reg. $ 180,690 $ 184,000 $ 500 $ 500 6005 Wages OT - Reg. 2,000 2,000 6010 Premium Pay 3,200 3,200 6015 Wages PT - Temp 7,000 7,500 6122 PERA 13,980 14,260 40 40 6124 FICA 14,760 15,050 40 40 6135 Health 38,730 46,470 6139 PEHP 1,200 1,200 6140 Life 980 980 6145 Dental 1,920 1,920 6170 Workers Comp 11,370 11,600 30 30 6180 Compensated Absences 7,000 7,000 6185 OPEB Total Personnel 282,830 295,180 610 610 6202 Operating Supplies 9,000 9,000 2,000 2,000 6203 Tools 1,000 1,000 6210 Office Supplies 500 500 6212 Uniforms 1,800 1,800 6240 Equipment Maintenance 1,500 1,500 6250 Merchandise 2,000 2,000 6316 Equipment Maintenance 2,700 2,700 1,800 1,800 6327 Other Prof Services 1,700 1,000 6334 Telephone 1,500 1,500 6336 Printing /Publishing 750 750 6352 Liability Insurance 900 1,400 6362 Elec Service -Truck Wash 6364 Water Service -Truck Wash 6410 Software 9,000 9,650 6430 Building Rent (IS FUND) 44,900 45,610 6472 Conf / School / Training 1,000 1,000 6497 Fleet Charged Back (330,000) (330,000) 6498 Expenses Charged Back 34,710 33,700 Total Supplies & Services (217,040) (216,890) 3,800 3,800 6740 Capital Expenditures 35,000 Total $ 100,790 $ 78,290 $ 4,410 $ 4,410 4 -22 2011 2012 2011 2012 2011 2012 0451 0451 0456 0456 Truck Wash Truck Wash Fuel Sys. Fuel Sys. Total Total $ 2,000 $ 2,000 $ 1,500 $ 1,500 $ 184,690 $ 188,000 2,000 2,000 3,200 3,200 7,000 7,500 150 150 110 110 14,280 14,560 150 150 110 110 15,060 16,350 38,730 46,470 1,200 1,200 980 980 1,920 1,920 120 120 90 90 11,610 11,840 7,000 7,000 2,420 2,420 1,810 1,810 287,670 300,020 3,000 3,000 500 500 14,500 14,500 1,000 1,000 500 500 1,800 1,800 1,500 1,500 2,000 2,000 2,000 2,000 3,000 3,000 9,500 9,500 1,700 1,000 1,500 1,500 750 750 900 1,400 4,000 4,000 4,000 4,000 400 400 400 400 9,000 9,650 44,900 45,610 1,000 1,000 (330,000) (330,000) 34,710 33,700 9,400 9,400 3,500 3,500 (200,340) (200,190) 35,000 - $ 11,820 $ 11,820 $ 5,310 $ 5,310 $ 122,330 $ 99,830 4 -23 CITY OF SHAKOPEE 2011- 2012 GENERAL FUND BUDGET DIVISION: PARK MAINTENANCE MISSION STATEMENT: To provide public services in a professional, cost - effective manner in order to maintain the public investment of infrastructure in parks and public grounds. ACTIVITY: Maintain athletic fields, rinks, trails, sidewalks, parking lots, playgrounds, park buildings; restrooms /shelters, public grounds, downtown streetscape, trees trimming /planting. GOALS: 1. Provide quality in maintaining athletic fields in a cost- effective manner. 2. Mow and trim parks and public grounds cost effectively. PERFORMANCE MEASUREMENT: (* Does not include equipment rental rate.) Actual Budgeted Requested Requested 2009 2010 2011 2012 Expenditures $1,414,352 $1,602,640 $1,576,910 $1,650,810 Population 34,691 34,000 35,100 35,300 Expenditure /Capita $407 $47.14 $44.92 $46.77 Cost to maintain athletic fields $177,224 $193,550 $194,460 $194,960 Expenditure /Capita $5.11 $5.69 $5.54 $5.53 Cost to Mow /trim Parks $37,377 $51,430 $51,750 $51,750 Acres of land mowed 404 412 412 412 Cost of mowing per acre (labor) $92.52 $124.83 $125.36 $125.36 Number of playgrounds 24 24 25 26 Number of athletic fields 81 81 82 83 Miles of Trails 39 39 39 40 Staff 2009 2010 2011 2012 Park Supervisor 1 1 1 1 Maintenance Operator 7 7 7 7 OBJECT DESCRIPTION: Description of lines items: Salaries: Public Works Director (10%), Public Works Supervisor (25%), 1 Park Supervisor, 7 Maintenance Operators - including 1 Lead, Secretary (30 %). Temporary employees - (8 summer) $52,000 4 -25 Operating Supplies (6202): Flower planting $6,000, Hockey rink repairs $500, Irrigation system $7,500, Athletic Field Supplies $10,000, Floor mats $500, Playground equipment $2,000, Picnic tables $750, Fence supplies $1,000, Safety Supplies $500, Stadium Seats $2,500, Garbage Cans $1,000, Small Hand Tools $1,000, Vandalism $1,500, Light bulbs /Ballasts /Parking Lot Lights $5,000, Restroom Supplies $1,500, Miscellaneous $3,000. Office Supplies: (6210) $500 Uniforms (6212): safety shirts, boots, uniforms $4,900. Materials (6215): Trees /shrubs $1,500, Sod /seed $4,000, Ball field aggregate $5,000, Fertilizer $9,500, Weed killer $8,500, Concrete /pavers $5,000, Concrete /paver sealer $2,000, Landscape mulch $S00, Safety Mulch for playgrounds $8,000, Miscellaneous $2,500. Motors Fuels & Lubricants: (6222) $33,000 2011($36,000 in 2012) Building Maintenance (6230): Window /door replacement $1,000, Youth building $1,000, Miscellaneous $2,500 Paint /Supplies $1,500. Equipment Maintenance (6240): Vehicle maintenance $8,000, Car /Truck Washes $2,000 Professional Services Building Maintenance (6315): Youth building $4;000, RPZ Testing $3,000. Professional Equipment Maintenance (6316): Vehicle maintenance $85,000, Equipment maintenance $15,000, Athletic Field Light /Scoreboard Repairs $6,000, Well Repairs $500. Pavement Preservation (6322): Parking lot seal coat $50,000; Tennis court maintenance $10,000 Other Professional Services (6327): Contract cleaning of park buildings $14,000, Irrigation system maintenance $1,000, miscellaneous $2,500. Utility Service (6360): Gas, electric, telephone for park buildings, rinks, athletic fields and youth building $105,000 Software (6410): $16,850 ($17,850 in 2012) 4 -26 Equipment Rent— IS Fund (6425): Equipment rent $56,000, ($47,700 in 2012) Building Rent— IS Fund (6430): Public Works buildings 22% $44,900 ($45,610 in 2012) Other Rent (6435) Park Assets Rent $171,680 ($221,680 in 2012); Satellites for ball - fields $12,000. Expense Charge Back (6498): $34,710 ($33,700 in 2012) Special Assessments (6620): $31,450 ($30,720 in 2012) 4 -27 R5509BUD SH005PV CITY OF SHAKOPEE 8111/2010 14:04:55 By Co, Div (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 5 Fiscal Period: 7 / 10 Level Of Rollup 6 2008 2009 7/31/2010 2010 2011 2012 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget 46 PARK MAINTENANCE 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4200 LICENSES AND PERMITS 4500 CHARGES FOR SERVICE 4670 PUBLIC WORKS 1,100- 4500 CHARGES FOR SERVICE 1,100- 4001 REVENUES 1,100- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 460,401 497,676 260,135 471,860 498,200 506,870 6100 BENEFITS 145,776 177,767 81,329 171,340 185,620 202,180 6001 WAGES & BENEFITS 606,177 675,443 341,463 643,220 683,820 709,050 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 134,273 108,212 46,972 154,400 142,400 148,800 6300 PROFESSIONAL SERVICES 176,363 155,776 71,072 213,000 189,000 188,000 6330 COMMUNICATIONS 2,059 1,954 1,282 2,000 2,000 2,000 6350 INSURANCE 80,315 77,861 80,968 82,900 83,400 85,000 6360 UTILITY SERVICE 100,372 97,504 41,153 105,000 105,000 105,000 6400 RENTALS 262,866 209,472 175,589 308,340 301,430 344,840 6470 DUES/TRAINING/TRAVEL 3,169 2,794 3,489 3,700 3,700 3,700 6498 EXPENSE CHARGED BACK 32,467 45,251 62,520 34,710 33,700 6200 SUPPLIES AND SERVICES 791,883 698,823 420,525 931,860 861,640 911,040 6500 DEPRECIATION 6600 MISCELLANEOUS 6620 PROPERTY TAX/SPECIALASSESS 29,634 33,964 31,452 27,560 31,450 30,720 6600 MISCELLANEOUS 29,634 33,964 31,452 27,560 31,450 30,720 6700 CAPITAL OUTLAY 6740 EQUIPMENT 29,771 6,124 6760 IMPROVEMENTS 21,850 6700 CAPITAL OUTLAY 51,621 6,124 6800 DEBT SERVICE 6000 EXPENDITURES 1,479,315 1,414,353 793,440 1,602,640 1,576,910 1,650,810 8050 TOTAL TRANSFERS OUT 4000 REVENUES AND EXPENDITURES 1,479,315 1,413,253 793,440 1,602,640 1,576,910 1,650,810 46 PARK MAINTENANCE 1,479,315 1,413,253 793,440 1,602,640 1,576,910 1,650,810 01000 GENERAL FUND 3,544,634 3,196,852 1,300,839 3,607,100 3,661,640 3,752,070 4 -28 Park 2011 -12 Budget 2011 2012 2011 2012 2011 2012 2011 2012 2011 0621 0621 0622 0622 0623 0623 0624 0624 0626 Manage- Manage- Athletic Athletic Park Eq Object Description ment ment Park Maint Park Maint Mow I Trim Mow I Trim Fields Fields Maint 6002 Wages FT - Reg. $ 170,530 $ 177,700 $ 19,990 $ 19,990 $ 16,730 $ 16,730 $ 57,130 $ 57,130 $ 10,200 6010 Premium Pay 6005 Wages - OT - Reg 1,250 1,250 750 750 750 750 6010 Premium Pay 3,200 4,700 6015 Wages PT - Temp 2,500 2,500 3,000 3,000 22,000 22,000 6,000 6,000 1,000 6122 PERA 12,870 13,500 1,720 1,720 2,810 2,810 4,630 4,630 810 6124 FICA 13,580 14,240 1,820 1,820 2,960 2,960 4,890 4,890 860 6135 Health 72,420 86,910 6139 PEHP 2,400 2,400 6140 Life 2,190 2,190 6145 Dental 3,840 3,840 6170 Workers Comp 6,720 7,000 760 760 1,250 1,250 2,060 2,060 360 6180 Compensated Absences 11,000 11,000 6185 OPEB Total Personnel 302,500 327,230 28,040 28,040 45,750 45,750 75,460 75,460 13,230 6202 Operating Supplies 1,000 5,750 500 500 22,500 22,500 6210 Office Supplies 500 500 6212 Uniforms 3,900 4,900 6215 Materials 3,500 3,500 5,500 5,500 17,000 17,000 6222 Motor Fuels & Lubricants 33,000 36,000 6230 Building Maintenance 6240 Equipment Maintenance 10,000 6315 Building Maintenance 6316 Equipment Maintenance 21,000 21,500 87,500 6322 Pavement Preservation 50,000 50,000 6327 Other Prof Services 5,500 5,500 6334 Telephone 2,000 2,000 6352 Liability Insurance 13,000 13,500 6354 Property Insurance 66,000 67,000 6356 Auto Insurance 4,400 4,500 6362 Electric Service 14,000 14,000 39,000 39,000 6364 Water 7,300 7,300 2,000 2,000 6365 Gas 6366 Sewer 290 290 6368 Storm 410 410 6410 Software 16,850 17,850 6425 Equipment Rent (IS FUND) 56,000 47,700 6430 Building Rent (IS FUND) 44,900 45,610 6435 Other Rent 12,000 12,000 6472 Conf / School / Training 3,500 3,500 6480 Dues 100 100 6490 Subscriptions /Publications 100 100 6498 Expenses Charged Back 34,710 33,700 6620 Special Assessments 31,450 30,720 Total Supplies & Services 310,410 307,680 76,500 81,250 6,000 6,000 119,000 119,500 97,500 6740 Capital Expenditures - Total $ 612,910 $ 634,910 $ 104,540 $ 109,290 $ 51,750 $ 51,750 $ 194,460 $ 194,960 $ 110,730 4 -29 Park 2011 -12 Budget 2012 2011 2012 2011 2012 2011 2012 2011 2012 2011 0625 0626 0626 0627 0627 0628 0628 0629 0629 0630 Park Eq Park Park Youth Object Description Maint Rinks Rinks Snow Snow Buildings Buildings Tree Tree Building 6002 Wages FT - Reg. $ 10,200 $ 13,870 $ 13,870 $ 12,650 $ 12,650 $ 35,910 $ 35,910 $ 14,280 $ 14,280 $ 11,030 6010 Premium Pay 6005 Wages - OT - Reg 750 750 5,500 5,500 500 6010 Premium Pay 6015 Wages PT - Temp 1,000 2,000 2,000 500 500 4,000 4,000 500 6122 PERA 810 1,060 1,060 1,460 1,460 2,640 2,640 1,330 1,330 870 6124 FICA 860 1,120 1,120 1,540 1,540 2,790 2,790 1,400 1,400 920 6135 Health 2,460 6139 PEHP 6140 Life 6145 Dental 6170 Workers Comp 360 470 470 650 650 1,170 1,170 590 590 390 6180 Compensated Absences 6185 OPEB Total Personnel 13,230 17,270 17,270 23,800 23,800 43,010 43,010 21,600 21,600 16,670 6202 Operating Supplies 500 500 3,500 3,500 6210 Office Supplies 6212 Uniforms 6215 Materials 1,500 1,500 6222 Motor Fuels & Lubricants 6230 Building Maintenance 9,000 5,000 1,000 6240 Equipment Maintenance 10,000 6315 Building Maintenance 4,000 6316 Equipment Maintenance 85,000 6322 Pavement Preservation 6327 Other Prof Services 10,500 11,500 6334 Telephone 6352 Liability Insurance 6354 Property Insurance 6356 Auto Insurance 6362 Electric Service 3,590 3,590 2,500 6364 Water 2,000 2,000 200 6365 Gas 7,430 7,430 1,000 6366 Sewer 470 470 300 6368 Storm 24,510 24,510 6410 Software 6425 Equipment Rent (IS FUND) 6430 Building Rent (IS FUND) 6435 Other Rent 171,680 221,680 6472 Conf / School / Training 6480 Dues 6490 Subscriptions /Publications 6498 Expenses Charged Back 6620 Special Assessments Total Supplies & Services 95,000 500 500 - - 232,680 279,680 1,500 1,500 9,000 6740 Capital Expenditures Total $ 108,230 $ 17,770 $ 17,770 $ 23,800 $ 23,800 $ 275,690 $ 322,690 $ 23,100 $ 23,100 $ 25,670 4 -30 Park 2011 -12 Budget 2012 2011 2012 2011 2012 2011 2012 2011 2012 0630 0632 0632 0633 0633 0635 0635 0636 0636 Youth Trail School School Bldg & Bldg & Playgr. Playgr. Object Description Building Trail Maint Maint Fields Fields Grounds Grounds _ Maint Maint 6002 Wages FT - Reg. $ 11,030 $ 6,530 $ 6,530 $ 12,240 $ 12,240 $ 14,690 $ 14,690 $ 29,380 $ 29,380 5010 Premium Pay 6005 Wages - OT - Reg 500 500 500 6010 Premium Pay 6015 Wages PT -Temp 500 6,000 6,000 500 500 6122 PERA 870 470 470 920 920 1,500 1,500 2,170 2,170 6124 FICA 920 500 500 970 970 1,580 1,580 2,290 2,290 6135 Health 2,960 6139 PEHP 6140 Life 6145 Dental 6170 Workers Comp 390 210 210 410 410 670 670 960 960 6180 Compensated Absences 6185 OPEB Total Personnel 17,170 7,710 7,710 15,040 15,040 24,440 24,440 35,300 35,300 6202 Operating Supplies 500 2,000 2,000 8,000 2,000 6210 Office Supplies 6212 Uniforms 6215 Materials 5,500 4,500 8,000 6222 Motor Fuels & Lubricants 6230 Building Maintenance 1,000 6240 Equipment Maintenance 150 6315 Building Maintenance 4,000 6316 Equipment Maintenance 6322 Pavement Preservation 10,000 10,000 6327 Other Prof Services 500 500 6334 Telephone 6352 Liability Insurance 6354 Property Insurance 6356 Auto Insurance 6362 Electric Service 2,500 6364 Water 200 6365 Gas 1,000 6366 Sewer 300 6368 Storm 6410 Software 6425 Equipment Rent (IS FUND) 6430 Building Rent (IS FUND) 6435 Other Rent 6472 Conf / School / Training 6480 Dues 6490 Subscriptions /Publications 6498 Expenses Charged Back 6620 Special Assessments Total Supplies & Services 9,650 - - - - 8,000 7,000 18,000 20,000 6740 Capital Expenditures Total $ 26,820 $ 7,710 $ 7,710 $ 15,040 $ 15,040 $ 32,440 $ 31,440 $ 53,300 $ 55,300 4 -31 Park 2011 -12 Budget 2011 2012 2011 2012 2011 2012 0637 0637 0640 0640 Vandalis Vandalis Down- Down - Object Description m m town town Total Total 6002 Wages FT - Reg. $ 2,040 $ 2,040 $ 5,300 $ 5,300 $ 432,500 $ 439,670 6010 Premium Pay - - 6005 Wages - OT - Reg 500 500 10,500 10,500 6010 Premium Pay 3,200 4,700 6015 Wages PT - Temp 4,000 4,000 52,000 52,000 6122 PERA 150 150 710 710 36,120 36,750 6124 FICA 160 160 750 750 38,130 38,790 6135 Health 74,880 89,870 6139 PEHP 2,400 2,400 6140 Life 2,190 2,190 6145 Dental 3,840 3,840 6170 Workers Comp 70 70 320 320 17,060 17,340 6180 Compensated Absences 11,000 11,000 6185 OPEB - - Total Personnel 2,420 2,420 11,580 11,580 683,820 709,050 6202 Operating Supplies 1,500 1,500 6,000 6,000 45,500 44,750 6210 Office Supplies 500 500 6212 Uniforms 3,900 4,900 6215 Materials 6,500 6,500 39,500 46,500 6222 Motor Fuels & Lubricants 33,000 36,000 6230 Building Maintenance 10,000 6,000 6240 Equipment Maintenance 10,000 10,150 6315 Building Maintenance 4,000 4,000 6316 Equipment Maintenance 108,500 106,500 6322 Pavement Preservation 60,000 60,000 6327 Other Prof Services 16,500 17,500 6334 Telephone 2,000 2,000 6352 Liability Insurance 13,000 13,500 6354 Property Insurance 66,000 67,000 6356 Auto Insurance 4,400 4,500 6362 Electric Service 59,090 59,090 6364 Water 11,500 11,500 6365 Gas 8,430 8,430 6366 Sewer 1,060 1,060 6368 Storm 24,920 24,920 6410 Software 16,850 17,850 6425 Equipment Rent (IS FUND) 56,000 47,700 6430 Building Rent (IS FUND) 44,900 45,610 6435 Other Rent 183,680 233,680 6472 Conf / School / Training 3,500 3,500 6480 Dues 100 100 6490 Subscriptions /Publications 100 100 6498 Expenses Charged Back 34,710 33,700 6620 Special Assessments 31,450 30,720 Total Supplies & Services 1,500 1,500 12,500 12,500 893,090 941,760 6740 Capital Expenditures - - Total $ 3,920 $ 3,920 $ 24,080 $ 24,080 $1,576,910 $ 1,650,810 4 -32