Loading...
HomeMy WebLinkAbout4. Public Works Budget Discussion IILj CITY OF SHAKO PEE 2008 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: Budgeted 2006 2007 2008 Engineering & Grade Fees $1,093,710 $ 326,000 $ 200,000 Public Projects Staff Time $ 196,164 $ 83,017 $ 160,000 (6/30/07) OBJECT DESCRIPTION: Description of lines items: Wages & Benefits: Salaries: 1 Ci ty Engineer (65%) , 1 Assistant City engineer, 1 Project Engineer, 4 Engineering Technicians, 1 GIS Specialist, 1 Graduate Engineer, 1 Secretary (90%) , 2 Engineering Interns. Operating Supplies: Includes computer software upgrades and licenses for Autocad $3,000, general operating supplies and small tools/equipment $6,500. Office supplies for drawings, ink pens for plotter and various engineering office supplies $8,000, GIS software $5,000. Equipment Maintenance: Plotter repair, & survey instruments maintenance, vehicle maintenance $14,000. I Professional Services: Attorney $5,000, transportation studies $7,000, GIS and pavement management software support and training $9,000, miscellaneous services $4,000. Communications: Telephone: Cellular phones and office phones for Engineering staff $5,000. Rentals: Equipment rental of vehicles $12,380, GPS survey equipment rental $1,500. Dues/Training/Travel: Conferences/School/Training: Inspection certification and Auto Cadd/computer training and supervisor training $11,000. Building Rental: $6,300 :2 R5509BUD LOGIS005 CITY OF SHAKOPEE 7/27/2007 9:18:56 Fiscal Period: 6 / 7 Budget Report Page - 1 Level Of Rollup 7 2004 2005 2006 6/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 01000 GENERAL FUND 41 ENGINEERING 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 480,092 501,200 548,427 254,238 612,150 586,470 586,470 586,470 6005 OVERTIME-FT 22,665 22,408 19,819 3,029 21,000 20,000 20,000 20,000 6015 WAGES - PART TIME/TEMP 1,743 4,465 7,671 12,000 12,000 12,000 12,000 6017 OVERTIME-PART TIMErrEMP 241 6002 WAGES 504,500 528,314 575,916 257,267 645,150 618,470 618,470 618,470 6100 BENEFITS 6122 PERA 27,789 29,606 32,734 15,806 40,320 40,220 40,220 40,220 6124 FICA 37,715 39,955 41,462 18,748 49,350 47,330 47,330 47,330 6135 HEALTH 52,244 60,382 63,799 28,927 64,450 59,210 59,210 59,210 6139 POST EMPLOYMENT HEALTH PLAN 2,782 2,733 2,735 1,241 3,000 2,700 2,700 2,700 6140 L1FE/LTD 2,275 2,374 2,406 1,122 2,630 2,770 2,770 2,770 6145 DENTAL 3,036 3,097 3,293 1,566 3,840 3,460 3,460 3,460 ~ 6170 WORKERS COMPENSATION 2,786 4,036 5,092 889 5,500 5,670 5,670 5,670 6180 COMPENSATED ABSENCES 8,308 20,628 12,117- 11,000 11,440 11 ,440 11 ,440 6100 BENEFITS 136,935 162,811 139,405 68,300 180,090 172,800 172,800 172,800 6001 WAGES & BENEFITS 641,435 691,125 715,321 325,567 825,240 791,270 791,270 791,270 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 3,451 12,414 3,043 4,910 6,500 5,000 5,000 5,000 6210 OFFICE SUPPLIES 2,300 3,455 3,480 690 16,000 17,500 17,500 17,500 6222 MOTOR FUELS & LUBRICANTS 3,745 5,698 5,035 2,052 5,500 5,500 5,500 5,500 6230 BUILDING MAINT SUPPLIES 8,911 1,000 1,000 1,000 1,000 6240 EQUIPMENT MAINTENANCE 1,157 1,916 1,007- 1,454 3,500 3,500 3,500 3,500 6250 MERCHANDISE 527 6201 SUPPLIES & SERVICES 10,652 24,010 19,461 9,106 32,500 32,500 32,500 32,500 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 342 5,291 1 ,487 2,914 5,000 5,000 5,000 5,000 6312 ENGINEERING CONSUL TNTS 1,940 26,566 23,057 8,895 26,000 21,000 21,000 21,000 6315 BUILDING MAl NT. 18,637 8,000 2,000 2,000 2,000 6316 EQUIPMENT MAINTENANCE 561 959 353 10,500 10,500 10,500 10,500 6327 OTHER PROF SERVICES 6,255 2,948 1,407 1,919- 4,000 4,000 4,000 4,000 6300 PROFESSIONAL SERVICES 9,098 35,764 44,942 9,890 53,500 42,500 42,500 42,500 R5509BUD LOGIS005 CITY OF SHAKOPEE 7/27/2007 9:18:56 Fiscal Period: 6 / 7 Budget Report Page - 2 Level Of Rollup 7 2004 2005 2006 6/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6330 COMMUNICATIONS 6332 POSTAGE 800 800 800 6334 TELEPHONE 3,750 4,475 4,918 2,466 5,000 5,500 5,500 5,500 6336 PRINTING/PUBLISHING 1,061 840 2,914 1,162 3,000 3,000 3,000 3,000 6330 COMMUNICATIONS 4,811 5,315 7,832 3,627 8,000 9,300 9,300 9,300 6350 INSURANCE 6352 LIABILITY 4,578 4,356 5,119 5,540 5,600 5,770 5,770 5,770 6354 PROPERTY 200 856 6356 AUTO 1,452 1,265 1,819 1,885 2,000 2,060 2,060 2,060 6350 INSURANCE 6,230 5,621 6,938 8,281 7,600 7,830 7,830 7,830 6360 UTILITY SERVICE 7,200 6362 ELECTRIC 544 6364 WATER 48 6365 GAS 1,168 ~ 6366 SEWER 45 6368 STORM 119 6360 UTILITY SERVICE 1,924 7,200 6400 RENTALS 6425 EQUIPMENT RENT (IS FUND) 14,256 13,236 14,472 7,314 14,700 12,380 12,380 12,380 6430 BUILDING RENT (IS FUND) 5,520 2,850 5,700 6,300 6,300 6,300 6435 OTHER RENT 1,500 1,500 1,500 1,500 6400 RENTALS 14,256 13,236 19,992 10,164 21,900 20,180 20,180 20,180 6470 DUES/TRAINING/TRAVEL 6472 CONFERENCE/SCHOOL/TRAINING 6,119 5,317 6,815 3,156 10,000 10,000 10,000 10,000 6475 TRAVEL/SUBSISTENCE 375 522 106 1,000 1,000 1,000 1,000 6480 DUES 266 373 1,205 268 1,000 1,000 1,000 1,000 6490 SUBSCRIPTIONS/PUBLICATIONS 418 291 131 114 400 400 400 400 6470 DUES/TRAINING/TRAVEL 7,177 6,503 8,257 3,538 12,400 12,400 12,400 12,400 6498 EXPENSE CHARGED BACK 8,000- 8,000- 6,674 8,000 8,000 8,000 6200 SUPPLIES AND SERVICES 44,225 82,449 116,020 44,606 143,100 132,710 132,710 132,710 6500 DEPRECIATION 6600 MISCELLANEOUS R5509BUD LOGIS005 CITY OF SHAKOPEE 7/27/2007 9:18:56 Fiscal Period: 6 / 7 Budget Report Page - 3 Level Of Rollup 7 2004 2005 2006 6/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6700 CAPITAL OUTLAY 6740 EQUIPMENT 36,075 6700 CAPITAL OUTLAY 36,075 6800 DEBT SERVICE 6840 DEBT SERVICE INTEREST 6000 EXPENDITURES 685,660 773,574 867,415 370,173 968,340 923,980 923,980 923,980 41 ENGINEERING 685,660 773,574 867.415 370,173 968,340 923,980 923,980 923,980 01000 GENERAL FUND 685,660 773,574 867.415 370,173 968,340 923,980 923,980 923,980 ~ Engineering 2008 Budget 0411 413 0419 5000 5500 Object # Description Management Transportation ROW MGT Eng Projects Eng DevProjects Total 6002 Wages FT - Reg. 196,590 2,810 76,240 310,830 586,470 6005 Wages OT - Reg. 18,000 2,000 20,000 6015 Wages PT - Temp 1,000 1,000 9,000 1,000 12,000 6122 PERA 12,790 250 5,020 1,760 20,400 40,220 6124 FICA 15,050 290 5,910 2,070 24,010 47,330 6126 ICMA - 6135 Health 59,210 59,210 6139 PEHP 2,700 2,700 6140 Life 2,770 2,770 6145 Dental 3,460 3,460 6170 Workers Comp 5,670 5,670 6180 Compensated Absences 11 ,440 11 ,440 6190 Retirement Benefit Total Personnel 309,680 4,350 88,170 30,830 358,240 791,270 6202 Operating Supplies 1,000 500 1000 1500 1,000 5,000 6210 Office Supplies 5,000 1,000 2,000 5,000 4,500 17,500 6222 Motor Fuels & Lubricants 500 500 1,500 1,500 1,500 5,500 6230 Building Maintenance 1,000 1,000 6240 Equipment Maintenance 3,500 3,500 6310 Attorney 2,000 500 2,000 500 5,000 6312 Engineering Consultants 3,000 10,000 2,000 4,000 2,000 21,000 6314 Computer Services 6315 Building Maintenance 2,000 2,000 6316 Equipment Maintenance 10,500 10,500 6327 Other Prof Services 4,000 4,000 6332 Postage 800 800 6334 Telephone 1,000 1,000 2,500 1,000 5,500 6336 Printing/Publishing 1,000 2,000 3,000 6352 Liability Insurance 5,770 5,770 6354 Property Insurance - 6356 Auto Insurance 2,060 2,060 6360 Utility Service 6365 Gas - 6367 Refuse - 6410 LOG IS - 6420 Equipment Rent - 6425 Equipment Rent (IS FUND) 1,530 500 3,000 5,000 2,350 12,380 6430 Building Rent (IS FUND) 1,500 800 1,000 2,000 1,000 6,300 6435 Other Rent 1,500 1,500 6472 Conf / School/ Training 3,500 3,500 3,000 10,000 6475 Travel/Subsistence 1,000 1,000 6480 Dues 1,000 1,000 6490 Subscriptions/Publ ications 400 400 6498 Expenses Charged Back 8,000 8,000 Total Supplies & Services 61,560 13,300 12,000 29,000 16,850 132,710 6740 Capital Expenditures Total $ 371,240 $ 17,650 $ 100,170 $ 59,830 $ 375,090 $ 923,980 C; CITY OF SHAKO PEE 2008 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.) 1. Average cost of snowplowing/ice control operations per capita. Actual Budgeted Requested 2006 2007 2008 Wages and materials $109,089 $158,350 $204,390 Population 31,800 32,300 32,800 Cost per capita $3.43 $4.90 $6.23 2. Average cost of street and alley maintenance per capita. Actual Budgeted Requested 2006 2007 2008 Wages and materials $189,139 $291,430 $232,950 population 31,800 32,300 32,800 Cost per capita $5.95 $9.02 $7.10 OBJECT DESCRIPTION: Description of lines items: Wages & Benefits: Salaries: Director (20%), Public Works Supervisor (40%), 1 Street Supervisor, 10 Maintenance Operators, Secretary (30%). Salaries - Temp: Temporary seasonal employees (4-summer with one seasonal employee funded by sanitary/storm enterprise funds, 4-winter). I Operating Supplies (6202) : Striping ($2,500)i Signs ($17,500) i Uniforms, boots and floor mats ($10,580) i Safety equipment ($1,500) i Portable Welder ($2500) i Sidewalk Grinding Machine ($2,OOO)iVarious supplies ($11,000) . Office Supplies (6210) : Computer hardware and software ($8,000) i General office supplies ($1,000) . Materials (6215) : Ice control materials ($72,500) i Gravel ($9,000) i Bituminous mix ($6,OOO)i Trees ($3,000) i Concrete ($7,000) . Motor Fuel and Lubricants (6222) : ($52,000) Building Maintenance (6230) : Miscellaneous maintenance ($10,000). Equipment Maintenance (6240) : Vehicle maintenance ($110,800) i Truck Washes ($8,OOO)i Car Washes ($1,200) . Professional Services Building Maintenance (6315) : Miscellaneous ($5,OOO)i Automatic Door Opener-front entry ($5,000) Pavement Preservation (6322) : Crack Sealing ($20,000) i Seal Coating ($160,000) i Large street repair ($10,000) . Other Professional Services (6327) : Includes paint striping of streets ($10,000) i paint striping of crosswalks on County Roads ($5,OOO)i OSHA safety consultant services ($3,500) i Drug testing ($2,000) i Traffic signal maintenance ($3,000) i Tree trimming/removal/disposal/stump grinding ($15,OOO)i Support for sign/pavement programs ($3,000) i Clean-up Day ($20,000) i Miscellaneous services ($3,000) . Communications (6334) : Telephone: Office phones and cellular phones for Public Works Supervisor, Street Supervisor and Maintenance Operators ($4,500) . Printing/Publishing (6336) Printing/publishing ($1,000) . Utility Service (6360) : Utilities - includes street lights and traffic control Signals $95,000 (Includes SPUC cost of $70,000), Replacement of street lights in Downtown area $5,000. Utilities for public works buildings ($58,000) . Equipment Rent - IS Fund (6425) : Equipment Rental ($226,820) . Building Rent - IS Fund (6430) : Building rent for new and old buildings 29% ($45,036) . Other Rent (6435) Other rent ($4000) . ~ Dues/Training/Travel (6470) : Conference/Training ($6,000) i Travel/subsistence ($500) i Dues ($1,000) i Subscriptions/Publications ($300) . Special Assessments (6620) : Gorman Street ($11,250) Capital Equipment (6740) : Small Trailer ($6,500) i Dump Box for Hook Truck ($15,000) i 2 Dumpsters & Tire Cage ($10,000) . :] R5509BUD LOGIS005 CITY OF SHAKOPEE 7/27/2007 9:44:14 Fiscal Period: 6 1 7 Budget Report Page - 1 Level Of Rollup 7 2004 2005 2006 6/30/2007 2007 2008 2008 2008 Actual Actual Actual YTO Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 01000 GENERAL FUND 42 STREET MAINTENANCE 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 283,809 320,292 334,483 189,052 410,150 445,620 445,620 445,620 6005 OVERTIME-FT 4,227 17,730 8,153 17,020 28,500 32,500 32,500 32,500 6010 PREMIUM PAY 692 1,180 745 4,600 4,600 4,600 4,600 6015 WAGES - PART TIMEITEMP 15,161 14,024 16,500 11,350 32,000 32,000 32,000 32,000 6017 OVERTIME-PART TIMEITEMP 2,469 6002 WAGES 303,197 352,737 360,316 220,636 475,250 514,720 514,720 514,720 6100 BENEFITS 6122 PERA 15,916 19,344 20,569 12,891 29,970 33,430 33,430 33,430 6124 FICA 21,296 26,001 25,577 15,512 36,670 39,370 39,370 39,370 6135 HEALTH 51,136 65,059 57,403 34,373 62,780 83,840 83,840 83,840 6139 POST EMPLOYMENT HEALTH PLAN 1,987 2,325 2,153 1,235 2,700 2,700 2,700 2,700 6140 L1FEIL TO 1,422 1,725 1,610 936 2,090 2,250 2,250 2,250 6145 DENTAL 2,292 2,661 2,614 1,545 3,500 3,530 3,530 3,530 ~ 6170 WORKERS COMPENSATION 10,486 14,496 16,179 10,468 17,000 17,510 17,510 17,510 6180 COMPENSATED ABSENCES 7,398 26,031 6,162 15,000 15,600 15,600 15,600 6190 RETIREMENT BENEFIT 1,109 497 17,549- 6100 BENEFITS 113,042 158,138 114,719 76,960 169,710 198,230 198,230 198,230 6001 WAGES & BENEFITS 416,239 510,875 475,035 297,596 644,960 712,950 712,950 712,950 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 45,378 41,487 98,579 44,130 39,640 46,580 46,580 46,580 6203 TOOLS 524 6210 OFFICE SUPPLIES 617 585 7,291 1,189 5,500 9,000 9,000 9,000 6215 MATERIALS 47,593 86,319 55,253 53,627 92,500 97,500 97,500 97,500 6222 MOTOR FUELS & LUBRICANTS 20,968 36,806 24,395 21,833 33,000 52,000 52,000 52,000 6230 BUILDING MAl NT SUPPLIES 1,512 9,222 12,000 10,000 10,000 10,000 6240 EQUIPMENT MAINTENANCE 49,340 38,921 26,518 28,042 179,200 120,000 120,000 120,000 6250 MERCHANDISE 18 6201 SUPPLIES & SERVICES 163,896 204,117 214,091 158,043 361,840 335,080 335,080 335,080 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 909 1,193 6312 ENGINEERING CONSUL TNTS 458 1,152 R5509BUD LOGIS005 CITY OF SHAKOPEE 7/27/2007 9:44:14 Fiscal Period: 6 / 7 Budget Report Page - 2 Level Of Rollup 7 2004 2005 2006 6/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6315 BUILDING MAINT. 4,651 2,382 5,917 3,535 5,000 10,000 10,000 10,000 6316 EQUIPMENT MAINTENANCE 6,532 4,163 3,606 10,521 3,000 6322 PAVEMENT PRESERVATION 77,940 81,993 84,525 130,374 130,000 190,000 190,000 190,000 6327 OTHER PROF SERVICES 47,065 41,469 69,997 50,019 71,500 64,500 64,500 64,500 6300 PROFESSIONAL SERVICES 136,645 130,917 165,238 195,601 209,500 264,500 264,500 264,500 6330 COMMUNICATIONS 6332 POSTAGE 151 6334 TELEPHONE 3,976 3,076 2,933 904 4,500 4,500 4,500 4,500 6336 PRINTING/PUBLISHING 1,356 3,403 2,517 1,000 1,000 1,000 1,000 6330 COMMUNICATIONS 3,976 4,432 6,487 3,421 5,500 5,500 5,500 5,500 6350 INSURANCE 6352 L1ABI L1TY 10,731 10,367 9,411 11,617 11,000 11,330 11,330 11,330 6354 PROPERTY 9,550 9,651 21,222 27,521 9,950 22,970 22,970 22,970 6356 AUTO 11,464 13,576 14,085 16,854 17,000 17,510 17,510 17,510 6350 INSURANCE 31,745 33,594 44,718 55,992 37,950 51,810 51,810 51,810 ~ 6360 UTILITY SERVICE 2,638 46,096 3,497 4,555 158,000 100,000 100,000 100,000 6362 ELECTRIC 70,409 15,710 89,363 21,608 6364 WATER 2,467 15,866 6365 GAS 23,871 31,952 6366 SEWER 27,573 12,360 6367 REFUSE 1,495 408 2,676 6368 STORM 3,877 2,573 6360 UTILITY SERVICE 74,542 62,214 153,325 88,913 158,000 100,000 100,000 100,000 6400 RENTALS 6420 EQUIPMENT RENT 1,128 1,000 2,390 3,190 6425 EQUIPMENT RENT (IS FUND) 187,512 185,400 195,768 100,902 201,800 226,820 226,820 226,820 6430 BUILDING RENT (IS FUND) 40,020 20,652 45,040 45,040 45,040 6435 OTHER RENT 4,000 4,000 4,000 4,000 6400 RENTALS 188,640 186,400 238,178 124,744 205,800 275,860 275,860 275,860 6470 DUES/TRAININGITRAVEL 6472 CONFERENCE/SCHOOL/TRAINING 910 4,395 4,846 2,018 6,000 6,000 6,000 6475 TRAVEL/SUBSISTENCE 49 262 290 303 500 500 500 6480 DUES 794 773 295 733 1,000 1,000 1,000 6490 SUBSCRIPTIONS/PUBLICATIONS 49 254 90 70 300 300 300 6470 DUESITRAININGITRAVEL 1,802 5,683 5,521 3,124 7,800 7,800 7,800 R5509BUD LOGIS005 CITY OF SHAKOPEE 7/27/2007 9:44:14 Fiscal Period: 6 / 7 Budget Report Page - 3 Level Of Rollup 7 2004 2005 2006 6/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6498 EXPENSE CHARGED BACK 22,000- 124,260- 58,000 58,000 58,000 6200 SUPPLIES AND SERVICES 579,246 627,356 703,299 629,838 978,590 1,098,550 1,098,550 1,098,550 6500 DEPRECIATION 6600 MISCELLANEOUS 6620 PROPERTY TAX/SPECIAL ASSESS 531 756 12,442 12,153 11,250 11,250 11,250 6600 MISCELLANEOUS 531 756 12,442 12,153 11,250 11,250 11,250 6700 CAPITAL OUTLAY 6740 EQUIPMENT 13,937 9,694 31,500 31,500 31,500 6760 IMPROVEMENTS 3,273- 6700 CAPITAL OUTLAY 3,273- 13,937 9,694 31,500 31,500 31,500 6800 DEBT SERVICE 6000 EXPENDITURES 992,743 1,152,924 1,190,775 949,281 1,623,550 1,854,250 1,854,250 1,854,250 <S'\ 42 STREET MAINTENANCE 992,743 1,152,924 1,190,775 949,281 1,623,550 1,854,250 1,854,250 1,854,250 01000 GENERAL FUND 992,743 1,152,924 1,190,775 949,281 1,623,550 1,854,250 1,854,250 1,854,250 Street 2008 Budget Object Street 0421 0422 0423 0424 0425 0426 # Description Management Tree/Weed Signs Snow/Sand PW BldglYard Equip Maint 6002 Wages FT - Reg. 181,910 18,890 30,490 75,140 54,960 9,020 6005 Wages OT - Reg. 1,500 1,000 1,500 21,500 - 500 6010 Premium Pay 4,600 6015 Wages PT - Temp 600 4,000 2,000 5,640 500 - 6122 PERA 12,240 1,550 2,210 6,650 3,600 620 6124 FICA 14,430 1,830 2,600 7,820 4,240 730 6126 ICMA 6135 Health 83,840 6139 PEHP 2,700 6140 Life 2,250 6145 Dental 3,530 6170 Workers Comp 17,510 6180 Compensated Absences 15,600 6190 Retirement Benefit Total Personnel 340,710 27,270 38,800 116,750 63,300 10,870 6202 Operating Supplies 16,580 2,000 20,000 1,000 500 621 0 Office Supplies 1,000 8,000 6215 Materials 3,000 72,500 6222 Motor Fuels & Lubricants 52,000 6230 Building Maintenance 6240 Equipment Maintenance 120,000 6310 Attorney 6312 Engineering Consultants 6314 Computer Services 6315 Building Maintenance 6316 Equipment Maintenance 6322 Pavement Preservation 6327 Other Prof Services 8,500 15,000 3,000 6332 Postage 6334 Telephone 4,500 6336 Printing/Publishing 1,000 6352 Liability Insurance 11,330 6354 Property Insurance 22,970 6356 Auto Insurance 17,510 6360 Utility Service 6365 Gas 6367 Refuse 6400 Rentals 6410 LOGIS 6420 Equipment Rent 6425 Equipment Rent (IS FUND) 226,820 6430 Building Rent (IS FUND) 45,040 6435 Other Rent 6472 Conf / School/ Training 6,000 6475 Travel/Subsistence 500 6480 Dues 1,000 6490 Subscriptions/Publications 300 6498 Expenses Charged Back 6620 Special Assessments 11 ,250 Total Supplies & Services 426,300 20,000 31,000 73,500 120,500 6740 Capital Expenditures 6,500 15,000 10,000 Total $ 773,510 $ 62,270 $ 69,800 $ 190,250 $ 73,300 $ 131,370 7 0427 0428 0429 0430 0432 0433 0434 2008 Street Maint Seal Coating Custodian Alley Maint Sidewalk Maint Striping Clean Up Day Total 41,650 11 ,590 11,240 5,150 4,720 860 445,620 3,500 - 1,000 - - - 2,000 32,500 4,600 12,360 3,090 2,190 500 - 1,000 120 32,000 3,740 950 940 370 - 370 190 33,430 4,400 1,120 1,100 430 - 440 230 39,370 83,840 2,700 2,250 3,530 1 0 15,600 - 65,650 16,750 16,470 6,450 - 6,530 3,400 712,950 - 500 1,500 2,000 2,500 46,580 9,000 12,000 3,000 7,000 97,500 52,000 10,000 10,000 120,000 - - - 10,000 10,000 - 30,000 160,000 190,000 3,000 15,000 20,000 64,500 - 4,500 1,000 11 ,330 22,970 17,510 100,000 100,000 - - - - 226,820 45,040 4,000 4,000 6,000 500 1,000 300 58,000 11 ,250 149,500 160,000 79,500 3,000 9,000 17,500 20,000 1,109,800 31,500 $ 215,150 $ 176,750 $ 95,970 $ 9,450 $ 9,000 $24,030 $ 23,400 $ 1,854,250 <3 CITY OF SHAKO PEE 2008 GENERAL FUND BUDGET DIVISION: SHOP MISSION STATEMENT: To provide services in a professional, cost-effective manner in order to maintain the public investment of infrastructure and equipment in streets, parks and public grounds. 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. Mechanic repairs for equipment is billed to the respective departments. Operating car and truck wash for government vehicles. GOAL: To provide quality maintenance to all departments in a cost-effective manner. MEASUREMENT OF GOALS: 1. Average cost per vehicle/equipment maintained Actual Budgeted Requested 2006 2007 2008 Overall shop budget $364,506 $383,860 $409,450 Number of vehicles/equipment 237 241 317 Avg cost per vehicles/equipment $1,538 $1,593 $1,292 OBJECT DESCRIPTION: Description of lines items: Wages & Benefits: Salaries: Public Works Director (5%) , Public Works Supervisor (20%) , 2 Mechanics, 1 Mechanic's Apprentice, and 1 temporary employee from School Employment Program, Secretary (40%). Operating Supplies (6202) : Various shop supplies ($9,000) i Uniforms ($4,000) i Truck wash supplies ($7,000) i Car wash supplies ($4,500)i Upgrade of scanner ($1,500) . Tools (6203) : Small tools ($2,000). Office Supplies (6210) : Miscellaneous office supplies ($1,000) . Equipment maintenance (6240) Miscellaneous equip. maintenance ($1500) . Merchandise (6250) Shop merchandise ($2,000) Professional Equipment Maintenance (6316) : Crane/Hoist inspections ($5,000) i Gas Boy fuel system repairs and miscellaneous ($1,500) i Truck wash maintenance agreement ($2,500) i Car wash maintenance agreement ($1,500) . I Other Professional Services (6327) : Fleet computer services ($700); Miscellaneous ($1,000) . Telephone (6334) Shop telephone ($1,250); Printing/Publishing ($1,000) . Utility Service (6360) : Utilities - includes electric, water, sanitary sewer, storm drainage, and Gas for new building ($48,000) . Building Rental (6430) : Building rental for new building 24% ($37,270) . Conferences/Schooling/Training (6472) : Various training including schooling for the apprentice ($3,000) . Subscriptions/Publications (6490) Shop subscriptions/publications ($200) :2 R5509BUD LOGIS005 CITY OF SHAKOPEE 7/27/2007 10:39:04 Fiscal Period: 6 / 7 Budget Report Page - 1 Level Of Rollup 7 2004 2005 2006 6/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 01000 GENERAL FUND 44 SHOP 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 106,319 158,469 170,130 106,619 158,610 178,770 178,770 178,770 6005 OVERTIME-FT 966 3,527 1,692 512 2,500 2,500 2,500 2,500 6010 PREMIUM PAY 3,000 3,200 3,200 3,200 6015 WAGES - PART TIME/TEMP 25,620 11,309 12,612 5,343 9,400 9,400 9,400 9,400 6002 WAGES 132,905 173,305 184,433 112,475 173,510 193,870 193,870 193,870 6100 BENEFITS 6122 PERA 6,998 9,128 9,576 6,678 10,770 12,600 12,600 12,600 6124 FICA 9,761 12,924 13,655 8,097 13,190 14,830 14,830 14,830 6135 HEALTH 17,019 28,473 27,440 15,810 31,240 35,190 35,190 35,190 6139 POST EMPLOYMENT HEALTH PLAN 718 1,115 1 ,400 665 1,200 1,200 1,200 1,200 6140 L1FElLTD 493 794 1,032 510 690 840 840 840 6145 DENTAL 732 1,251 1,725 848 1,540 1,540 1,540 1,540 W 6170 WORKERS COMPENSATION 3,437 4,821 5,341 4,237 5,800 5,970 5,970 5,970 6180 COMPENSATED ABSENCES 3,054 5,260 8,665 5,400 5,620 5,620 5,620 6190 RETIREMENT BENEFIT 8,088 8,088- 6100 BENEFITS 50,301 55,677 68,833 36,844 69,830 77,790 77,790 77,790 6001 WAGES & BENEFITS 183,206 228,982 253,267 149,319 243,340 271,660 271,660 271,660 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 9,479 17,950 14,177 8,550 25,540 26,000 26,000 26,000 6203 TOOLS 1,237 2,180 2,379 402 2,000 2,000 2,000 2,000 6210 OFFICE SUPPLIES 1,711 402 191 258 1,000 1,000 1,000 1,000 6222 MOTOR FUELS & LUBRICANTS 79 6230 BUILDING MAl NT SUPPLIES 1,462 4,627 162 50 6240 EQUIPMENT MAINTENANCE 688 203 224 414 1,500 1,500 1,500 1,500 6250 MERCHANDISE 5,818 6,261 3,038 1,526 2,000 2,000 2,000 2,000 6201 SUPPLIES & SERVICES 20,395 31,624 20,250 11,200 32,040 32,500 32,500 32,500 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 75 6315 BUILDING MAINT, 2,509 12,544 2,365 6316 EQUIPMENT MAINTENANCE 2,921 1,565 1,155 710 10,500 10,500 10,500 10,500 6327 OTHER PROF SERVICES 1,584 5,856 6,240 83 1,700 1,700 1,700 1,700 R5509BUD LOGIS005 CITY OF SHAKOPEE 7/27/2007 10:39:04 Fiscal Period: 6 / 7 Budget Report Page - 2 Level Of Rollup 7 2004 2005 2006 6/30/2007 2007 2008 2008 2008 Actual Actual Actual YTO Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6300 PROFESSIONAL SERVICES 7,015 19,966 9,835 794 12,200 12,200 12,200 12,200 6330 COMMUNICATIONS 6334 TELEPHONE 507 591 857 413 1,250 1,250 1,250 1,250 6336 PRINTING/PUBLISHING 672 1,000 1,000 1,000 6330 COMMUNICATIONS 507 591 857 1,085 1,250 2,250 2,250 2,250 6350 INSURANCE 6352 LIABILITY 2,159 2,041 1,946 429 2,300 2,370 2,370 2,370 6354 PROPERTY 2,637 2,464 6350 INSURANCE 4,796 4,505 1,946 429 2,300 2,370 2,370 2,370 6360 UTILITY SERVICE 11,973 48,000 6362 ELECTRIC 6,720 14,441 3,996 1,429 6364 WATER 508 2,398 286 6365 GAS 15,430 26,420 7,007 1,407 6366 SEWER 498 2,297 268 -t:= 6368 STORM 2,901 5,905 714 6360 UTILITY SERVICE 38,031 51,461 12,271 2,836 48,000 6400 RENTALS 6420 EQUIPMENT RENT 1,000 6430 BUILDING RENT (IS FUND) 30,384 31,104 33,120 17,094 34,180 37,270 37,270 37,270 6400 RENTALS 30,384 32,104 33,120 17,094 34,180 37,270 37,270 37,270 6470 DUES/TRAININGITRAVEL 6472 CONFERENCE/SCHOOUTRAINING 75 617 841 571 3,000 3,000 3,000 3,000 6475 TRAVEL/SUBSISTENCE 24 6480 DUES 350 6490 SUBSCRIPTIONS/PUBLICATIONS 140 10 76 200 200 200 200 6470 DUES/TRAININGITRAVEL 215 627 917 595 3,550 3,200 3,200 3,200 6497 FLEET CHARGE BACK 313,200- 313,200- 313,200- 6498 EXPENSE CHARGED BACK 32,043 64,444- 318,610- 48,000 48,000 48,000 6200 SUPPLIES AND SERVICES 101,342 140,878 111,240 30,411- 185,090- 175,410- 175,410- 175,410- 6500 DEPRECIATION 6600 MISCELLANEOUS 6620 PROPERTY TAX/SPECIAL ASSESS 7,279 12,321 R5509BUD LOGIS005 CITY OF SHAKOPEE 7/27/2007 10:39:04 Fiscal Period: 6 / 7 Budget Report Page - 3 Level Of Rollup 7 2004 2005 2006 6/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6600 MISCELLANEOUS 7,279 12,321 6700 CAPITAL OUTLAY 6740 EQUIPMENT 20,183 7,340 8,000 6700 CAPITAL OUTLAY 20,183 7,340 8,000 6800 DEBT SERVICE 6000 EXPENDITURES 291,826 402,364 364,506 126,248 66,250 96,250 96,250 96,250 44 SHOP 291,826 402,364 364,506 126,248 66,250 96,250 96,250 96,250 01000 GENERAL FUND 291,826 402,364 364,506 126,248 66,250 96,250 96,250 96,250 0\ Shop 2008 Budget 0441 0443 0444 0445 0446 0448 0449 0450 0451 2008 Object # Description Management Maint Street Maint Park Maint Police Maint Others Maint Fire Custodian Car Wash Truck Wash Total 6002 Wages FT - Reg. 83,780 47,730 13,150 21,760 510 4,720 4,320 600 2,200 178,770 6005 Wages OT - Reg. 1,250 1,250 2,500 6010 Premium Pay 3,200 3,200 6015 Wages PT - Temp 700 2,600 2,600 1,750 1,750 9,400 6122 PERA 5,700 3,270 1,110 1,610 30 420 280 40 140 12,600 6124 FICA 6,710 3,850 1,300 1,890 40 490 330 50 170 14,830 6126 ICMA - 6135 Health 35,190 35,190 6139 PEHP 1,200 1,200 6140 Life 840 840 6145 Dental 1,540 1,540 6170 Workers Camp 5,970 5,970 6180 Compensated Absences 5,620 5,620 6190 Retirement Benefit - Total Personnel 150,450 57,450 19,410 28,260 580 7,380 4,930 690 2,510 271,660 6202 Operating Supplies 26,000 26,000 6203 Tools 2,000 2,000 6210 Office Supplies 1,000 1,000 6215 Materials - 6222 Motor Fuels & Lubricants 6230 Building Maintenance - 6240 Equipment Maintenance 1,500 1,500 6250 Merchandise 2,000 2,000 6310 Attorney - 6312 Engineering Consultants - 6314 Computer Services - 6315 Building Maintenance - 6316 Equipment Maintenance 6,500 1500 2500 10,500 6322 Pavement Preservation - 6327 Other Prof Services 1,700 1,700 6332 Postage - 6334 Telephone 1,250 1,250 6336 Printing/Publishing 1,000 1,000 6352 Liability Insurance 2,370 2,370 6354 Property Insurance - 6360 Utility Service - 6365 Gas 6367 Refuse - 6400 Rentals - 6410 LOGIS - 6420 Equipment Rent - 6425 Equipment Rent <IS FUND) 6430 Building Rent (IS FUND) 37,270 37,270 6435 Other Rent - 6472 Conf / School/Training 3,000 3,000 6475 Travel/Subsistence 6480 Dues - - 6490 Subscriptions/Publications 200 200 6498 Expenses Charged Back 48,000 48,000 6620 Special Assessments. Total Supplies & Services 48,520 - - 85,270 1,500 2,500 137,790 6740 Capital Expenditures - 6497 Fleet Charged Back (120,000) (52,800) (86,400) (33,000) (21,000) (313,200) Total $ 198,970 $ (62,550) $ (33,390) $ (58,140) $ (32,420) $(13,620) $90,200 $ 2,190 $ 5,010 $ 96,250 r; CITY OF SHAKO PEE 2008 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 building/restrooms/shelters, public grounds, downtown streetscape, trees trimming/planting. GOALS: l. 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.) l. Cost to maintain athletic fields per capita. Actual Budgeted Requested 2006 2007 2008 Wages and materials $150,057 $144,830 $235,240 population 31,800 32,300 32,800 Cost per capita $4.72 $4.48 $7.17 2. Mowing and trimming per acre. Actual Budgeted Requested 2006 2007 2008 Wages and supplies $52,203 $33,460 $35,970 Acres of land mowed and trimmed 392.20 404.20 404.20 Cost of mowing and trimming per acre $133.10 $82.78 $89.00 OBJECT DESCRIPTION: Description of lines items: Wages & Benefits: Salaries: Public Works Director (10%) , Public Works Supervisor (40%) 1 Park Supervisor, 7 Maintenance Operators, Secretary (30%) . Salaries - Temp: Temporary employees - (10 summer, 1 winter) . Operating Supplies (6202) : Downtown Garbage Receptacles ($3,000); Additional heads for infield watering ($4,500) ; Flower planting ($6,000) ; Hockey rink repairs ($500) ; Irrigation system ($7,500) ; Athletic Field Supplies ($10,000); Garbage cans ($1,000) ; Uniforms, boots, and floor mats ($7,240) ; Playground equipment/wood chips ($8,000) ; Picnic tables ($2,000) ; Fence supplies ($2,000); Youth Building ($3,500); Safety equipment ($1,500) ; Computer I software and hardware ($3,500) ; Stadium Seats ($2,500) ; Tool box/tools ($1,000); Vandalism ($2,500); Miscellaneous ($5,000) . Materials (6215) : Trees ($3,000) ; Sod/seed ($2,000); Ballfield aggregate ($5,OOO); Fertilizer ($8,500) , Weed killer ($7,500) ; Concrete/pavers ($8,000); Concrete/paver sealer ($2,000); Landscape mulch ($2,000); Miscellaneous ($3,000) . Motor Fuels & Lubricants (6222) : Management (0621) ($28,000). Building Maintenance (6230) : Paint (Schleper Stadium) ($2,500); Window/door replacement ($1,500); Youth building ($2,650); RPZ Testing ($4,000); Miscellaneous ($5,000). Equipment Maintenance (6240) : Bobcat Upgrade ($2000);Vehicle maintenance ($52,800) ; Washes ($4,000) . Professional Services Building Maintenance (6315) : Youth building ($4,000) . Professional Equipment Maintenance (6316) : Replace irrigation wiring at Tahpah Park ($5,000); Equipment maintenance ($2,OOO) Pavement Preservation (6322) : Trail maintenance/overlay ($30,000). Other Professional Services (6327) : Includes satellites for ball fields ($12,000); Athletic Field Light/Scoreboard Repairs ($3,000) ; Contract cleaning of Community Youth Building and park buildings ($18,000) ; OSHA Safety Consultant Services ($3,000); Irrigation system maintenance ($2,500) ; Tennis Court repairs ($30,000); Vandalism ($2,500); Ballfield lighting ($3,000); Miscellaneous ($2,500). Telephone (6334) Telephone ($2,000); Additional line for stadium ($1,500). Utility Service (6360): Gas, electric, telephone for park buildings, rinks, athletic fields and youth building ($52,000); utilities for public works buildings ($58,000). Equipment Rent - IS Fund (6425) : Equipment rent ($102,903) Building Rent - IS Fund (6430) : Youth Building ($12,370); Public Works buildings 29% ($45,036) . Other Rent (6435) Other rent ($2,000) . Special Assessments (6620) : Assessments ($20,650) . Capital Expenditures: Air Compressor ($15,000) ; 2 Backstops (Tahpah Park #2 & #3) ($15,000);Chipper Box & Flat Bed for Hook Truck ($12,500). ~ R5509BUD LOGIS005 CITY OF SHAKOPEE 7/27/200711:17:47 Fiscal Period: 6 / 7 Budget Report Page - 1 Level Of Rollup 7 2004 2005 2006 6/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 01000 GENERAL FUND 46 PARK MAINTENANCE 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 303,774 319,878 343,091 156,733 414,670 440,230 440,230 440,230 6005 OVERTIME-FT 3,682 6,452 4,533 8,281 6,000 16,000 16,000 16,000 6010 PREMIUM PAY 77 278 88 5,000 3,200 3,200 3,200 6015 WAGES - PART TIMEITEMP 29,640 44,018 52,208 20,704 53,000 65,000 65,000 65,000 6017 OVERTIME-PART TIMEITEMP 187 6002 WAGES 337,097 370,425 400,110 185,993 478,670 524,430 524,430 524,430 6100 BENEFITS 6122 PERA 16,999 18,392 21,373 10,302 30,170 34,070 34,070 34,070 6124 FICA 24,001 26,602 28,093 13,219 36,910 40,140 40,140 40,140 6135 HEALTH 44,714 52,839 49,247 18,197 55,270 58,230 58,230 58,230 6139 POST EMPLOYMENT HEALTH PLAN 2,213 2,210 1,970 832 2,400 2,400 2,400 2,400 6140 L1FEIL TD 1,473 1,630 1 ,496 643 1,810 2,110 2,110 2,110 W 6145 DENTAL 2,352 2,504 2,410 1,032 3,080 3,070 3,070 3,070 6170 WORKERS COMPENSATION 5,275 7,515 8,336 4,544 9,000 9,270 9,270 9,270 6180 COMPENSATED ABSENCES 7,104 9,110 10,674 9,500 9,880 9,880 9,880 6190 RETIREMENT BENEFIT 7,540 7,540- 6100 BENEFITS 111,670 113,263 123,599 48,769 148,140 159,170 159,170 159,170 6001 WAGES & BENEFITS 448,767 483,688 523,709 234,762 626,810 683,600 683,600 683,600 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 31,824 38,406 64,968 27,904 56,740 71,240 71,240 71,240 6203 TOOLS 1,247 1,175 6210 OFFICE SUPPLIES 104 295 59 214 6215 MATERIALS 10,367 28,518 13,195 6,148 39,000 41,000 41,000 41,000 6222 MOTOR FUELS & LUBRICANTS 12,367 18,827 22,107 11,347 20,900 28,000 28,000 28,000 6230 BUILDING MAINT SUPPLIES 2,417 1,688 3,515 2,295 50,650 15,650 15,650 15,650 6240 EQUIPMENT MAINTENANCE 14,846 20,247 18,958 20,487 79,200 58,800 58,800 58,800 6201 SUPPLIES & SERVICES 71,926 109,228 123,976 68,395 246,490 214,690 214,690 214,690 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 268 124 6315 BUILDING MAINT. 9,505 8,855 11,833 2,315 4,000 4,250 4,250 4,250 6316 EQUIPMENT MAINTENANCE 2,916 1,042 1,173 2,190 2,000 7,000 7,000 7,000 R5509BUD LOGIS005 CITY OF SHAKOPEE 7/27/200711:17:47 Fiscal Period: 6 / 7 Budget Report Page - 2 Level Of Rol/up 7 2004 2005 2006 6/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code 1 Description Amount Amount Amount Actual Budget Budget Budget Budget 6322 PAVEMENT PRESERVATION 19,185 21,585 20,000 30,000 30,000 30,000 6327 OTHER PROF SERVICES 8,451 24,142 33,561 4,836 52,000 76,500 76,500 76,500 6300 PROFESSIONAL SERVICES 20,872 53,492 68,276 9,341 78,000 117,750 117,750 117,750 6330 COMMUNICATIONS 6334 TELEPHONE 651 1,659 1,276 558 2,000 3,500 3,500 3,500 6336 PRINTING/PUBLlSHING 101 62 841 751 200 6330 COMMUNICATIONS 752 1,721 2,117 1,310 2,200 3,500 3,500 3,500 6350 INSURANCE 6352 LIABILITY 4,693 5,276 6,346 7,469 6,800 7,000 7,000 7,000 6354 PROPERTY 26,423 25,399 30,144 43,800 31,500 32,450 32,450 32,450 6356 AUTO 3,815 3,389 3,809 3,515 4,200 4,330 4,330 4,330 6350 INSURANCE 34,931 34,064 40,299 54,784 42,500 43,780 43,780 43,780 6360 UTILITY SERVICE 15,226 110,000 52,000 52,000 52,000 6362 ELECTRIC 6,691 10,914 15,215 4,077 -t:: 6364 WATER 6,031 4,904 5,080 238 6365 GAS 4,809 5,555 13,107 7,346 6366 SEWER 371 718 1,000 267 6367 REFUSE 25 408 975 714 6368 STORM 10,791 21,968 23,147 9,572 6360 UTILITY SERVICE 43,944 44,466 58,524 22,214 110,000 52,000 52,000 52,000 6400 RENTALS 6420 EQUIPMENT RENT 2,092 1,494 527 6425 EQUIPMENT RENT (IS FUND) 83,388 85,152 86,664 46,896 93,800 105,700 105,700 105,700 6430 BUILDING RENT (IS FUND) 10,812 11,292 52,152 26,838 53,670 57,770 57,770 57,770 6435 OTHER RENT 3,809 3,431 2,919 4,000 2,000 2,000 2,000 6400 RENTALS 100,102 101,368 139,343 76,653 151,470 165,470 165,470 165,470 6470 DUESITRAINING/TRAVEL 6472 CONFERENCE/SCHOOUTRAINING 1,205 3,039 1,335 2,004 4,500 4,500 4,500 4,500 6475 TRAVEUSUBSISTENCE 9 10 24 6480 DUES 70 30 88 250 6490 SUBSCRIPTIONS/PUBLICATIONS 70 250 6470 DUESITRAININGITRAVEL 1,275 3,048 1,375 2,187 5,000 4,500 4,500 4,500 6498 EXPENSE CHARGED BACK 48,385 58,000 58,000 58,000 6200 SUPPLIES AND SERVICES 273,801 347,388 482,296 234,884 635,660 659,690 659,690 659,690 R5509BUD LOGIS005 CITY OF SHAKOPEE 7/27/200711:17:47 Fiscal Period: 6 / 7 Budget Report Page - 3 Level Of Rollup 7 2004 2005 2006 6/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6500 DEPRECIATION 6600 MISCELLANEOUS 6620 PROPERTY TAX/SPECIAL ASSESS 70,514 81,878 70,923 41,754 37,470 20,650 20,650 20,650 6600 MISCELLANEOUS 70,514 81,878 70,923 41,754 37,470 20,650 20,650 20,650 6700 CAPITAL OUTLAY 6740 EQUIPMENT 10,000 42,500 42,500 42,500 6700 CAPITAL OUTLAY 10,000 42,500 42,500 42,500 6800 DEBT SERVICE 6000 EXPENDITURES 793,082 912,955 1,076,928 511,400 1,309,940 1,406,440 1,406,440 1,406,440 46 PARK MAINTENANCE 793,082 912,955 1,076,928 511,400 1,309,940 1,406,440 1,406,440 1,406,440 01000 GENERAL FUND 793,082 912,955 1,076,928 511,400 1,309,940 1,406,440 1,406,440 1,406,440 ~ Park 2008 Budget Object 0621 0622 0623 0624 0625 0626 0627 0628 Manage- Athletic Park Eq # Description ment Park Maint Mow / Trim Fields Maint Rinks Snow Building 6002 Wages FT - Reg. 177,930 20,730 3,250 76,820 4,880 12,600 24,390 30,480 6005 Wages OT - Reg. 1.500 1,000 1.000 2,500 - 1,000 5,500 500 6010 Premium Pay 3,200 6015 Wages PT - Temp 2,500 6,000 22,000 7,180 1,500 - 2,700 620 6122 PERA 12,010 1,800 1,710 5,620 410 880 2,120 2,050 6124 FICA 14,160 2,120 2,010 6,620 490 1,040 2,490 2,420 6126 ICMA 6135 Health 58,230 6139 PEHP 2,400 6140 Life 2,110 6145 Dental 3,070 6170 Workers Comp 9,270 6180 Compensated Absences 9,880 6190 Retirement Benefit Total Personnel 296,260 31.650 29.970 98,740 7,280 15,520 37,200 36,070 6202 Operating Supplies 18,240 1,000 24,000 500 6215 Materials 3,000 6,000 18,000 2,000 6222 Motor Fuels & Lubricants 28,000 6230 Building Maintenance 4,000 9,000 6240 Equipment Maintenance 56,800 2,000 6310 Attorney 6312 Engineering Consultants 6314 Computer Services 6315 Building Maintenance 6316 Equipment Maintenance 5,000 2,000 6322 Pavement Preservation 6327 Other Prof Services 3,000 2,500 47,000 18,000 6332 Postage 6334 Telephone 2,000 1,500 6336 Printing/Publishing 6352 Liability Insurance 7,000 6354 Property Insurance 32,450 6356 Auto Insurance 4,330 6360 Utility Service 5,000 2,000 41,000 6365 Gas 6367 Refuse 6400 Rentals 6410 LOGIS 6420 Equipment Rent 6425 Equipment Rent (IS FUND) 105,700 6430 Building Rent (IS FUND) 6435 Other Rent 2,000 6472 Conf / School/ Training 4,500 6475 Travel/Subsistence 6480 Dues 6490 Subscriptions/Publications 6498 Expenses Charged Back 6620 Special Assessments 20,650 Total Supplies & Services 225.870 6,500 6.000 106,500 58,800 2,500 2,000 70,000 6740 Capital Expenditures 12,500 30.000 6498 Expenses Charged Back Total $ 534,630 $ 38,150 $ 35.970 $ 235,240 $ 66,080 $ 18,020 $ 39,200 $ 106,070 ~ 0629 0630 0631 0632 0633 0635 0636 0637 0640 2008 Youth School Bldg& Playground Vanda- Tree Building Custodian Trail Maint Fields Grounds Maint lism Down-town Total 11,790 11 ,480 11,240 3,000 10,970 19,100 10,570 3,000 8,000 440,230 - - - 500 - 2,500 16,000 3,200 6,000 500 - - 7,000 1,000 8,000 65,000 1,160 780 730 200 750 1,700 750 200 1,200 34,070 1,360 920 860 230 880 2,000 890 230 1,420 40,140 - 58,230 2,400 2,110 3,070 9,270 9,880 - 20,310 13,680 12,830 3,430 13,100 29,800 13,210 3,430 21,120 683,600 3,500 2,500 10,000 2,500 9,000 71,240 4,000 2,500 5,500 41,000 28,000 2,650 15,650 58,800 - - - 4,250 4,250 7,000 30,000 30,000 500 3,000 2,500 76,500 - 3,500 - 7,000 32,450 4,330 4,000 52,000 - - - - 105,700 12,730 45,040 57,770 2,000 4,500 - - 58,000 20,650 4,000 27,130 103,040 30,000 5,500 13,000 5,000 14,500 680,340 - 42,500 - $ 24,310 $ 40,810 $ 115,870 $ 33,430 $ 13,100 $ 35,300 $ 26,210 $ 8,430 $ 35,620 1,406,440 "7 Edina SI. cioud - crystiii 12 I Little Canada 20 ........ ....--.. .. .20 .. .^' ....... 15 12 15 Oakdaie 14 'r 10 -"ilIst was 35 i l years old i , r!,placed il! 1!~ I 12to15 coniracted 10 1 5" I depends on service buy back plan Cat buy back condition plan I 10"-" . I.....based more mw~'___ T....-............. .1 . ... ..on .usa9.e .' . 10io12 10 io 15- .." -. .... 12'1015 10 to 12 trade every 5 i 5 I I I combo VlI.t~ jet l .piYrn~~th I ... .'1.~..t" 14. ._s^t~.9 _ ""'1'0 y~,~,~~ ...2.0_ .... .. 1.5..!~ 18 .. ..... I j Eden Prairie I 14 i 10 81010 8 8to 10 10 to 12 I...... 15t020 25 to 35 10 io 12 all equipment is i evaluated annually ! i I for cost of l i operation & J co.~.dit!C?!1~~ 20 years or 80,000 miles 20 1 I 12 to 15 20 .. ........ dispose of fn'2 buy back plan yrs. use < 30 i h':!,.a!'nually 12 8 I 11 "~~,~" j ...1......... ..... T ..... r 5 '7 I I ... buybll~. Il!"n.... I i West Saint Paul 15 i 12 20 ..,,--- 25 i Jla9~!1.0!'. 11fl020 or I "'10 or ' '^~~,._- l 100,000 miles 100,000 miles i l , 1 unit is '10 10 1 unit is 1 on leaseclprogram .. BrooklynC:El~ter i" 11 11 '11 8 . Huber Park Seasonal Maintenance (Hours) . \ q Turf 11/ B/dg Maint 330 11/ Irrigation 24% 11/ Band Shelter IlII Parking Lot 11/ Playground 11/ Landscapes III Turf 11/ Minor Flooding 11/ Trails II Park Amenities I'l Prairie Grass Burning Playground ~ " J38 10% Full Time: 527 Part Time: 860 Total Hours: 1387 I I ~ Countryside NE Seasonal Maintenance (Hours) I ! ! I Park Amenities 6 3% \ I I . Bldg Maint I 11/ Irrigation 11/ Playground .. Landscapes 11/ Turf 11/ Trails I I III Park Amenities I I I \ Total Hours: 235 -----------. --------- . I Countryside NW Seasonal Maintenance (Hours) Park Amenities 6 2% 11/ Bldg Maint 11/ Irrigation 11/ Playground III Landscapes 11/ Turf 11/ Trails .. Park Amenities Total Hours: 253 ,.----- ------- ---- ----------.. ---------_._---..~_._- ------- - I . I Countryside SW Seasonal Maintenance (Hours) Park Amenities 2 2% 11/ Playground .. Landscapes .Turf II Trails .. Park Amenities I I Total Hours: 115 -- ---- ---~ ___ ______ ______...__...________._____.._m_ ________ ___.. _ Church Addition Seasonal Maintenance (Hours) Park Amenities 2 1% Parking Lot 2 1% 11/ Bldg Maint 11/ Irrigation I .. Parking Lot Iilll Playground I 11/ Landscapes 11/ Turf . Trails . Park Amenities ~ Total Hours: 182 I i ----- - ~ --- .--- - I Savanna Oaks Seasonal Maintenance (Hours) I, I I I, I I, Park Amenities I 2 ] 2% I I 1 I I 1 I i I I I I . Bldg Maint I 11/ Playground I I 11/ Landscapes I II Tu rf 1 I 11/ Trails I 11/ Park Amenities 1 I 1 I I I I I 1 I Total Hours: 131 I I I \ I ! \ \ I ! I \ i I \ I I \ I Transit Site Seasonal Maintenance (Hours) Park Amenities 18 2% I I I I I ~ I I . Shelter I 11/ Irrigation I II Parking Lot I .. Landscapes I 11/ Turf I 1;1' 11/ Trails I If) III Park Amenities I !II! 'I!I lli ''if! I i\il I ~ 'I! ~ \ ~ ~{,_!ta \ ;ll! Parl<,ih~Lot III 170 I 22% I I I Total Hours: 790 I I I I I I I I I I