The URL can be used to link to this page

Home My WebLink About09/08/1998 TENTATIVE AGENDA CITY OF SHAKOPEE ADJOURNED REGULAR SHAKOPEE,MINNESOTA SEPTEMBER 8, 1998 LOCATION: 129 Holmes Street South Mayor Jon Brekke presiding 1] Roll Call at 4:00 P.M. 2] Approval of Agenda 3] New Business A] Amendment to Tobacco Ordinance No. 527 B] 4] Old Business A] EDA Levy Impact B] FY 99 Issues C] Use of Fund Balance 4 D] Tax Levy and Impact 5] Adjourn to Monday, September 14, 1998, at 7:00 p.m. CITY OF SHAKOPEE ORDINANCE NO. 5�FOURTH SERIES AN ORDINANCE RELATING TTO OBACCO RODUCTSSSI�ONn AND USE OF TOBACCO. TOBACCO RELATED DEVICES. BY AMENDING SUBD. i SECTION 6.23.SUBD. 3,PARAGRAPHS AND The City Council of the City of Shakopee.Minnesota ordains: Section 1 - Section 6.23, Subd. 3, Paragraphs J and L of the City Code of Shakopee arc amended to read as follows: J. Instructional Progann. No person shall be issued a license or renewal license to sell tobacco, tobacco products or tobacco-related devices unless an applicant plicanteor license holder has an approved program for instructing all employeesregarding ts pertaining to the sale of tobacco,tobacco products or tobacco-related devices at the business premises for which the license was issued. The instructional pmogram shall and dem not limited to, reviewing the law on the sale of tobacco-relatedserpent � the Equi ech . : . . : • ' e. No license. e lawretardin shall be issued unless the applicant or of arch ens to ablish of license holder sips a form attesting that each employee of the applicant or license holder has received training and instruction on the sale of tobacco.tt r►gashco products all include infozTnatin tobacco- related devices and the date such training occurred.explanation of what proof of age is legally that p a sale andof that products r sal to minors can subject the applicant or license holder and their acceptable, employees to criminal and civil liability. products or tobacco related devices shall L. Proof of Age. Any sale of tobacco, tobaccoch �� ab ars t be unde the ale not take place unless the licensee requires them purchaser by one of the Qf 27 to sl}e�t� ish proof of age ' establi bed by state law for the purchase of alcoholic beverages. Section 2 - Section 6.23, Subd. 15 of the City Code of Shakopee is amended to read as follows: Subd. 15. Amendment. The city clerk shall make reasonabledefforts to d titof he Scottp u� Community Health Services and all tobacco retailers thirty days si fie t amendments to this Section. Section 3 - Effective Date. This ordinance shall take effect after its adoption and publication in the city's official newspaper. Adopted in adjourned regular session of the City Council of the City of Shakopee, 13T.149631 5H155•23 880-i EO/ZO"d 656-1 O166REZl9 N3APID ! A03NN3N-woJi wdEp:ZO 86-80-d9S Minnesota,held the 8th day of September, 1998. Mayor of the City of Shakopee ATTEST: City Clerk 33T-149631 511155-23 880—d £0/£0'd £56-1 Ol£6!££Zl9 N3AVdn V AO3NN3N—woad wd£q:ZO 86-80—des SHAKOPEE EDA Memorandum TO: EDA Chairman and Commissioners Mark McNeill, EDA Director FROM: Gregg Voxland, Finance Director RE: 1999 Tax Levy And Budget Adoption Resolution DATE: September 3, 1998 Introduction and Background There are two statutes under which a tax for the purposes of the EDA may be levied. The major differences as far as the levy is concerned are: HRA EDA 469.033 469.107 Levied by EDA City City consent yes yes Under City levy limit no yes 1999 EDA levy limit $119,000 $158,000 MSA 469.107 has broader purposes allowed than 469.003 but the distinction is not clearly defined. Basically, the HRA levy is for redevelopment and the EDA levy is for redevelopment and new development. The proposed budget is attached with appropriations in the amount of $420,970. The EDA needs to adopt a proposed maximum levy and budget amount by September 15 for certification to the County Auditor. That levy will be used for the tax notice mailed to property owners. Alternatives 1. Adopt resolution under MSA 469.033. 2. Adopt resolution under MSA 469.107. Recommendation Discuss and give staff direction as to which statute will be used for the levy. Unallocated 1999 Budget Page 1 Program 911 Object# Description Management Total 4210 Operating Supplies - 4222 Motor Fuels& Lubricants - 4240 Equipment Maintenance - 4310 Professional Services - 4320 Postage - 4321 Telephone - 4330 Travel/Subsistence - 4340 Advertising - 4350 Printing/Publishing - 4360 Insurance 15,000 15,000 4380 Utility Service - 4390 Conference/School/Training - 4410 Rentals - 4430 Miscellaneous 75,000 75,000 4433 Dues - 4435 Subscriptions/Publications - 4437 Property Tax/Special Assess 105,580 105,580 4490 Contingency 50,000 50,000 4491 Contingency- Designated 180,080 180,080 Total Supplies&Services $ 425,660 $ 425,660 *4'4720 Interfund Operating Transfer $ 333,050 333,050 Total Unallocated $ 758,710 $ 758,710 Transfers: ** Rec. Fund 333,050 Contingency-Designated: Wage adjustments 1% 34,000 Police Technology Grant 12,000 Reclassifications 22,000 New position - Fire Inspect 38,120 New Position - Police SW 43,300 New position-Clerk Typist 30,660 180,080 N • • ° d I--5-Ca RECREATION FUND e J ) S 1999 BUDGET ACTIVITY: Activity includes the administration of a year round comprehensive recreation, parks and leisure services program. The operations include the management of youth and adult activities, special events, public relations, volunteers, parks, trails and special facilities such as the outdoor pool, community center, community youth building and athletic complexes. OBJECT DESCRIPTION: Description of lines items: Salaries: Director, Facility Manager/Asst. Director, 2 Recreation Supervisors, 1 Customer Service Rep. , 1 Clerk Typist I, and a Assistant Facilities Manager. Salaries - PT Temp: Pool (35) , Instructors (10) , Activity Leaders (15) , Building Coordinators (13) , Rink Attendants (12) . Supplies: Recreation supplies, office supplies, cleaning supplies, flowers, blades and propane for ice resurfacer, & miscellaneous equipment. Professional Services: Professional Services (LOGIS $1,000) , transportation for trips and tours, entertainers for playground events ($500) , band concerts ($3,500) , and park financial/analyst for bond referendum ($5,000) and Huber Park Master Plan revision ($2,000) and design specs for boat landing. Building Maintenance: Cleaning contracts ($18,000) , maintenance contracts for heating and cooling equipment ($3,000) . Utilities: Ice arena, Civic Center and Pool. Printing/Publishing: Publication of three brochures with Community Education and newspaper advertising ($6,500) . Capital Equipment: Computer hardware for recreation supervisor ($2,500) . Conferences/School/Training: Facility Manager attending regional training in Michigan ($600) , Park and Recreation Director attending NRPA National Conference ($1000) . Rentals: LOGIS computer service ($9,500) , Postage meter rental ($400) Ice Resurfacer ($6,500) . T CITY OF SHAKOPEE, MINNESOTA PROFORMA OPERATING STATEMENT-RECREATION FUND For the Year Ending December 31, 1999 1996 1997 1998 1999 Actual Actual Est. Est. Operating Revenue Memberships&Admissions $ 93,131 $ 114,743 $ 108,000 $ 140,000 Activities 111,584 121,886 136,000 155,560 Concessions 23,050 27,503 32,040 35,040 Rentals 185,100 159,895 239,700 239,700 Fees 14,167 21,277 20,000 18,500 Miscellaneous 1,504 500 3,000 Contributions 1,544 2,276 3.000 10.000 Total Operating Revenue 430,080 448,080 541,740 598,800 Operating Expense 4101 FT Salaries 182,421 187,089 233,070 261,250 4102 Wages-Overtime 2,194 376 1,000 1,000 4110 PT Salaries 126,225 137,423 156,760 167,000 4121 PERA 8,621 9,057 12,070 13,590 4122 FICA 21,094 21,844 29,900 32,840 4131 Health& Life 15,662 17,184 28,130 33,740 4142 Unemployment 40 - 2,000 500 4151 Workcomp 8,747 9,867 10,200 7,500 4170 Compensated Absences 4,399 4,823 8,000 5,000 4210 Supplies 31,941 34,597 36,500 40,500 4230 Bldg. Maint. 3,523 30,970 30,750 30,000 4240 Equip. Maint. 2,559 13,675 4,500 4,500 4250 Merchandise 4,866 3,374 6,000 5,000 4310 Professional Serv. 23,899 10,295 3,500 17,000 4320 Postage 1,920 1,713 3,100 2,500 4321 Telephone 9,595 9,631 4,100 7,100 4330 Travel/Subsistence 855 1,271 2,150 1,550 4340 Advertising 1,306 875 1,300 1,300 4350 Printing & Repro 4,318 3,427 6,000 6,500 4360 Insurance 25,660 22,242 22,150 23,500 4380 Utilities 115,589 121,790 109,000 122,000 4390 Conference/School/Train 877 989 1,900 2,100 4410 Rents 6,894 6,552 7,200 120,730 4420 Depreciation 117,441 134,286 133,000 24,000 4433 Dues 746 759 750 750 4435 Subscriptions/Publication 268 321 400 400 4438 Sales Tax 10,441 3,000 - Total Expense 732,101 784,430 856,430 931,850 Operating Income (302,021) (336,350) (314,690) (333,050) Interest Income 11,398 11,159 Transfer In General Fund 251,340 301,140 332,690 333,050 Net Income $ (39,283) $ (24,051) $ 18,000 $ - 2 _ ' Recreation Fund-Cash For the Year Ending December 31, 1999 1996 1997 1998 1999 Actual Actual Est. Est. Operating Receipts Service Charges $ 430,080 $ 448,080 $ 541,740 $ 598,800 Transfers In 301,140 332,690 333,050 430,080 749,220 874,430 931,850 Operating Expense 4100 FT Salaries 182,421 187,089 233,070 261,250 4102 FT Overtime 2,194 376 1,000 1,000 4110 PT Salaries 126,225 137,423 156,760 167,000 4140 PERA 8,621 9,057 12,070 13,590 4141 FICA 21,094 21,844 29,900 32,840 4131 Health & Life 15,662 17,184 28,130 33,740 4142 Unemployment 40 2,000 500 4151 Workcomp 8,747 9,867 10,200 7,500 4170 Compensated Absences 4,399 4,823 8,000 5,000 4210 Supplies 31,941 34,597 36,500 40,500 4230 Bldg. Maint. 3,523 30,970 30,750 30,000 4232 Equip. Maint. 2,559 13,675 4,500 4,500 4250 Merchandise 4,866 3,374 6,000 5,000 4310 Professional Serv. 23,899 10,295 3,500 17,000 4320 Postage 1,920 1,713 3,100 2,500 4321 Telephone 9,595 9,631 4,100 7,100 4330 Travel/Subsistence 855 1,271 2,150 1,550 4340 Advertising 1,306 875 1,300 1,300 4350 Printing & Repro 4,318 3,427 6,000 6,500 4360 Insurance 25,660 22,242 22,150 23,500 4380 Utilities 115,589 121,790 109,000 122,000 4390 Conference/School/Train 877 989 1,900 2,100 4410 Rents 6,894 6,552 7,200 120,730 4433 Dues 746 759 750 750 4435 Subscriptions/Publication 268 321 400 400 4438 Sales Tax 3,000 4550 Capital Equipment 10,441 2,661 22,000 2,500 Total Disbursements 614,660 652,805 745,430 910,350 Net Cash Flow ($184,580) $96,415 $129,000 $21,500 Cash Balance 74,358 196,299 325,299 346,799 Accumulated Depreciation (282,486) (416,772) (549,772) (573,772) Operating Cash $ (208,128) $ (220,473) $(224,473) $(226,973) 3 - CASH BASIS Program Program Program Program Program Program 750 751 752 753 754 755 Object Description Benefits Gen. Rec. Pool Ice Arena Civ Cntr Pk Admin. Total Operating Revenue 3470 Memberships $ 35,000 $ 30,000 $ 65,000 3471 Daily Admissions 40,000 35,000 75,000 3472 Lessons 15,000 1,000 16,000 3474 Ice Rental-Prime 225,000 225,000 3481 Non-resident Fee 3,000 3,000 3477 Youth Activities 71,560 22,000 93,560 3478 Aerobics 11,000 11,000 3478 Adult Activities 32,000 3,000 35,000 3479 Concession Stand 12,000 9,000 21,000 3480 Vending Contract 2,770 2,770 5,540 3480 Vending Machines 2,500 3,000 3,000 8,500 3489 Township Contributions 7,000 7,000 3490 Other Rec. Fees 4,000 4,000 3491 Arena Advertising 9,000 9,000 3620 Skate Sharpening 2,000 2,000 3620 Pay Phones 500 500 3622 Cable Access Rental 7,200 7,200 3622 Rentals 4,000 2,000 6,000 3622 Meeting Room Rental 1,500 1,500 3623 Contributions 3,000 3,000 Total Operating Revenue - 124,560 107,270 249,500 117,470 - 598,800 Operating Expenses 4101 Wages FT-Reg. 29,000 85,070 8,500 42,000 65,680 31,000 261,250 4102 Wages FT-OT 1,000 1,000 4110 Wages-Temporary - 27,000 50,000 23,000 67,000 167,000 4121 PERA 1,500 4,460 440 2,180 3,400 1,610 13,590 4122 FICA 2,220 8,650 4,480 4,970 10,150 2,370 32,840 4131 Health&Life 33,740 33,740 4142 Unemployment 500 500 4151 Workers Comp 7,500 7,500 4170 Compensated Absences 5,000 5,000 Total Personnel 79,460 126,180 63,420 72,150 146,230 34,980 522,420 4210 Operating Supplies 22,000 6,500 6,000 6,000 40,500 4230 Building Maintenance 5,000 5,000 20,000 30,000 4240 Equipment Maintenance 3,000 1,500 4,500 4250 Merchandise 5,000 5,000 4310 Professional Services 4,500 2,000 1,500 1,500 4,000 13,500 4320 Postage 2,500 2,500 4321 Telephone 500 700 2,000 3,500 400 7,100 4330 Travel/Subsistence 400 150 200 200 600 1,550 4340 Advertising 500 800 1,300 4350 Printing/Publishing 5,000 1,500 6,500 4360 Insurance 2,500 4,000 1,500 15,500 23,500 4380 Utilities 14,000 70,000 38,000 122,000 4390 Conference/School/Training 400 300 400 200 800 2,100 4410 Rentals 10,000 48,220 62,510 120,730 4433 Dues 150 100 200 300 750 4310 Music in the Parks 3,500 3,500 4435 Subscriptions/Publications 200 200 400 4438 Sales Tax - Total Supplies&Services - 51,650 38,150 138,120 151,410 6,100 385,430 4550 Capital Expenditures - 2,500 2,500 Total Park& Rec. $ 79,460 $ 180,330 $ 101,570 $ 210,270 $ 297,640 $ 41,080 $ 910,350 4 1 1999 BUDGET 1999 1999 Pay With Title/Description Step 2%COL Inc FICA PERA Park& Rec Director 5 $ 50,250 $ 3,844 $ 2,603 Facility Manager 7 46,818 3,582 2,425 Rec Supervisor I 7 36,794 2,815 1,906 Rec Supervisor I 2 31,008 2,372 1,606 Clerk Typist I 8 29,128 2,228 1,509 Clerk Typist I 8 28,572 2,186 1,480 Assit Facilities Manager 1 26,677 2,041 1,382 Charge in Park Maint N/A 8,000 612 414 Charge in Govt Buildings N/A 4,000 306 207 Total Rec Fund (General) $ 261,247 $ 19,986 $ 13,532 • 5 Projected population 1999 16,000 1999 1999 Net Percentage Subsidy Budgeted Budgeted Revenues/ of Expenses per Program Expenses Revenues Expenses Earned capita Benefits 79,460 (79,460) 4.97 Gen. Rec. 180,330 124,560 (55,770) 69.1% 3.49 Pool 101,570 107,270 5,700 105.6% (0.36) Ice Arena 210,270 249,500 39,230 118.7% (2.45) Civ Cntr 297,640 117,470 (180,170) 39.5% 11.26 Pk Admin. 41,080 (41,080) 2.57 Net Subsidy 19.47 300, .;..... z 250,000 ;.... 200,000 $ ®Expenses �.. • Hues ■Rev 150,000 M' �r od \L °i.A100,000 GG£� ''...'''',•••• •••:•..-,:•,.-. ‘...s.:::',. 1.--„:. —.. • : ::-.::::''.50,000 �,,z 0 ; '`\Chi• ::� • `� Benefits Gen. Rec. Pool Ice Arena Civ Cntr Pk Admin. 4 Tax Rate Impact - Pay 1999 27, 700 Item Amount 3s of tax inc. Fire Inspector 38,120 1.38% contingency Fire fees (20,000) -0.72% in revenue Police Officer 43,300 1.56% contingency SWMTF Reimb (49,500) -1.79% in revenue Bldg/Clerk clerk 30,660 1.11% contingency Rec Maint. Position 26,700 0.96% Rec Transfer Park Maint. Position 17,800 out Stans tennis courts 35,000 out Tree replace-reduced to $20,000 30,000 out CSO 28,290 out CSO 28,290 out CSO Revenue (13,000) out police technology 12,000 0.43% contingency Depreciation- bldgs 146,840 5.30% in Depr-use of fund balance (146,840) -5.30% in Underspend-3% 225,000 8.12% out Informational ADC pmt 75,000 2.71% 1997 underspend 100,000 3.61% LEVY98B.XLS TAXBILL pay 99 2:00 PM 9/8/98 ..2 City of Shakopee 9/8/98 Pay 1998 Pay 1999 Change Net levy spread 2,573, 873 3, 142, 791 22 .1% Total City Taxable Tax Capacity 12, 016,642 13,210, 079 9 City Tax Rate 0.21127 0.23791 12 .6% Assessor's Estimated Market Value $75, 000 $81,000 8.0% Tax Capacity First $75, 000 at 1% 750 750 Balance at 1.85% 102 750 852 13 .6% City Tax Rate 21.127% 23.791% $ 44.25 City Tax $158.45 $202.70 27.9% Assessor's Estimated Market Value $101,600 $109,300 7.6% Tax Capacity First $75, 000 at 1% 750 750 Balance at 1.85% 492 583 1,242 1,333 7.3% City Tax Rate 21.127% 23.791% $ 54 .74 City Tax $262 .42 $317.16 20.9% Assessor's Estimated Market Value $107, 800 $117, 100 8.6% Tax Capacity First $75, 000 at 1% 750 750 Balance at 1.85% 607 716 1,357 1,466 8.0% City Tax Rate 21.127% 23.791% $ 62 .05 City Tax $286.65 $348.70 21.6% Assessor's Estimated Market Value $177,800 $187, 700 5.6% Tax Capacity First $75,000 at 1% 750 750 Balance at 1.85% 1, 902 1, 916 2,652 2,666 0.5% City Tax Rate 21.127% 23.791% $ 73 .99 City Tax $560.25 $634.24 13 .2% Assessor's Estimated Market Value $177, 800 $187,700 5.6% Tax Capacity Commercial First $150, 000 at 2.7% 4,050 3,675 Balance at 4.0% 1,112 1,320 5, 162 4, 995 -3 .2% City Tax Rate 21.127% 23.791% $ 97.66 City Tax $1,090.58 $1, 188.23 9.0% LEVY98B.XLS TAXBILL pay 99 2:17 PM 9/8/98 7. A8 I C D I E IFI G I H I11 J I K 1 ity of Shakopee 9/8/98 2 Pay 99 tax levy 3 4 97/98 98/99 Change 5 General Fund Tax Levy 2,714,371 3,544,267 6 Transit levy 293309 7 Est.Value growth 139570 8 Total General Fund 2,714,371 3,544,267 829,896 30.6% 9 Debt Service 10 1990A Imp CNX 134940 135,209 11 1991A Imp 41,615 41,937 12 1992A Imp CNX 22825 cnx24088 13 1993B Imp CNX 22998 0 14 1995A Imp 61,816 cnx60624 15 1995B Storm Revenue CNX 157217 cnx152586 16 1996A Imp 59,511 64,861 17 1997B Imp 40,000 16,612 18 1998A Imp 0 19 1998B Imp 20 Fire Referendum 250569 261235 21 Total Debt Service 202,942 258,619 55,677 22 Changes 23 Levy cut (345,000) 24 Levy cut (To keep average house at no change without referendum) 25 26 Total Levy 2,917,313 3,457,886 540,573 18.5% 27 28 Fiscal Disp Dist (292,680) (315,095) (22,415) 29 Net Levy to spread 2,624,633 3,142,791 518,158 19.7% 30 31 Allowance for 32 Budget Amount Unroll 2,575,756877) ,575,756 3,073,633 9,158) 497,877) 19.3% 33 34 General Fund 2,372,814 2,815,014 442,200 18.6% 35 Debt Service Replacement 202,942 258,619 55,677 27% 36 37 —SEI SUMMARY GENERAL FUND 39 1998 1999 40 GF Total Revenue per print+tax changes 6,527,813 7,537,708 41 Revenue changes 0 0 42 Total Revenue&Transfers 6,527,813 7,537,708 43 44 GF Expend+tran.per print 6,598,730 7,525,570 45 46 47 48 49 50 51 52 53 Total Expenditures and Transfers 6,598,730 7,525,570 54 55 Net surplus (deficit) (70,917) 12,138 56 57 DS Levy to replace transfer (202,942) (258,689) 58 Net surplus(deficit) (273,859) 59 60 Use of Fund Balance 61 Equip Fund Designated Fund Balance draw down 162,500 done 62 One time MIS Y2K 100,000 63 1st year building depreciation 146,840 64 Contingency '50000 65 Net surplus(deficit) (111,359) 359 66 67 Underspend/overbudget factor 100,000 (1-� 68 Net surplus(deficit) (11,359) 359 69 71 Tax rate change 12.6° 72 Subsidy for Recreation Fund 332,690 339,170 73 Under spent factor has been about 9%for 1996 and 7%for 1997. 74 Underspend factor for 1999 shown at$225,000 is 3%. LEVY98B.XLS LEVY98-99 2:17 PM 9/8/98 0 1 City of Shakopee 9/8/98 Pay 1998 Pay 1999 Change Net levy spread 2, 573, 873 2, 913, 791 13 .2% Total City Taxable Tax Capacity 12, 016,642 13,210, 079 9.9% City Tax Rate 0.21127 0.22057 ( .4j Assessor' s Estimated Market Value $75,000 $81, 000 8.0% Tax Capacity First $75, 000 at 1% 750 750 Balance at 1.85% 102 750 852 13 .6% City Tax Rate 21.127% 22.057% $ 29.48 City Tax $158.45 $187.93 18.6% Assessor's Estimated Market Value $101,600 $109,300 7.6% Tax Capacity First $75, 000 at 1% 750 750 Balance at 1.85% 492 583 1,242 1,333 7.3% City Tax Rate 21.127% 22.057% $ 31.63 City Tax $262 .42 $294.05 12 .1% Assessor's Estimated Market Value $107, 800 $117, 100 8.6% Tax Capacity First $75, 000 at 1% 750 750 Balance at 1.85% 607 716 1,357 1,466 8 .0% City Tax Rate 21.127% 22 .057% $ 36.64 City Tax $286.65 $323 .29 12 .8% Assessor's Estimated Market Value $177, 800 $187, 700 5.6% Tax Capacity First $75, 000 at 1% 750 750 Balance at 1.85% 1,902 __ 1,916 2,652 2,666 0.5% City Tax Rate 21.127% 22.057% $ 27.78 City Tax $560.25 $588.03 5.0% Assessor's Estimated Market Value $177,800 $187,700 5.6% Tax Capacity Commercial First $150,000 at 2.7% 4,050 3,675 Balance at 4.0% 1,112 1,320 5,162 4, 995 -3 .2% City Tax Rate 21.127% 22 .057% $ 11.08 City Tax $1, 090.58 $1, 101.65 1.0% LEVY98B.XLS TAXBILL pay 99 2:09 PM 9/8/98 I AlB of Shakopee' c9/8/981 D ' E IFI G I H III J I K 2 Pay 99 tax levy 3 4 97/98 98/99 Change 5 General Fund Tax Levy 2,714,371 3,544,267 6 Transit levy 293309 7 Est.Value growth 139570 8 Total General Fund 2,714,371 3,544,267 829,896 30.6% 9 Debt Service 10 1990A Imp CNX 134940 135,209 11 1991A Imp 41,615 41,937 12 1992A Imp CNX 22825 cnx24088 13 1993B Imp CNX 22998 0 -fir1995A Imp 61,816 cnx60624 15 1995B Storm Revenue CNX 157217 cnx152586 16 1996A Imp 59,511 64,861 17 1997B Imp 40,000 16,612 18 1998A Imp 0 19 1998B Imp 20 Fire Referendum 250569 261235 21 Total Debt Service 202,942 258,619 55,677 22 Changes 23 Levy cut (574,000) 24 Levy cut (To keep average house at no change without referendum) 25 26 Total Levy 2,917,313 3,228,886 311,573 10.7% 27 28 Fiscal Disp Dist292,680) (315,095) (22,415) 29 Net Levy to spread 224,633 2,913,791 289,15811.0% 30 31 Allowance for Uncoil. 48,877) (64,578) (15,701) 32 Budget Amount 2,575,756 2, 49, 213 273,457 10.6% 33 34 General Fund 2,372,814 2,590,594 217,780 9.2% 35 Debt Service Replacement 202,942 258,619 55,677 27% 36 37 38 SUMMARY GENERAL FUND 39 1998 1999 40 GF Total Revenue per print+tax changes 6,527,813 7,313,288 41 Revenue changes 0 0 42 Total Revenue&Transfers 6,527,813 7,313,288 43 44 GF Expend+tran.per print 6,598,730 7,525,570 45 46 47 48 49 50 51 52 53 Total Expenditures and Transfers 6,598,730 7,525,570 54 55 Net surplus (deficit) (70,917) (212,282) 56 22)) 57 DS Levy to replace transfer (202,942) (258,619) 58 Net surplus(deficit) 59 60 Use of Fund Balance 61 Equip Fund Designated Fund Balance draw down 162,500 done 62 One time MIS Y2K 100,000 63 1st year building depreciation 146,840 64 Contingency '50000 65 Net surplus(deficit) (111,359) (224,061) 66 67 Underspend/overbudget factor 100,000 225,000 68 Net surplus(deficit) (11,359) 939 69 70 Tax rate change 4.4% 71 72 Subsidy for Recreation Fund 332,690 339,170 73 Under spent factor has been about 9%for 1996 and 7%for 1997. 74 Underspend factor for 1999 shown at$225,000 is 3%. LEVY98B.XLS LEVY98-99 2:16 PM 9/8/98 _r B I C I D I E I F G I H 76 City of Shakopee 77 General Fund Fund Balance 25% Min 35% max 78 12/31/97 Fund Balance unreserved undesignated $ 3,101,701 $ 3,101,701 79 Cash Flow Target @ 25%of Expenditures(1998) 1,654,430 2,316,202 so Net available 1,447,271 785,499 81 Options for use of fund balance 82 Specific use of fund balance (246,840) (246,840) 83 Further buy down of tax levy 84 Transfer to Building Fund (1,200,000) (538,000) 85 Transfer to new project in lieu of tax levy for debt. 86 431 659 87 88 Designations 89 Designated for 1991 A Imp for 1999 (430,000) 90 Designated for 1990 A Imp for 1999 (134,340) 91 92 LEVY98B.XLS LEVY98-99 2:25 PM 9/8/98 6- General Fund Expenditures 1997/1998 1998/1999 Wage& Benefits 3,760,840 3,850,480 Supplies& Service 2,483,690 3,236,040 Capital 40,500 140,000 Transfers 332,690 333,050 3,500.000 s x A-..0t - , . : % ,3,000,000 t ,« f sK w ri d ' ` bM . e�...�c , k $ Ta" ' 13.41 2,000,000 �0�0 ",, -----,--'1.-4, ■1997/1998 o E T a 1 1,a 8e�` n. .um d x , ■1998/1999 1.500.000 4 i4�t Fr , x� ' 50V.0000a. iiitthli0 , :, Wage&Benefits Supplies&Services Capital Transfers General Fund Expenditures 1997/1998 capitapansfers 1% Supplies&Services 38% Wage&Benefits 56% LEVY98B.XLS TAXBILL pay 99 1:58 PM 9/8/98 eeeeeeeee eee - eee e e ee e . c!, C)C O N O — , e- N , r , C O 0^ N O i9 N/7 t(J �- f7 C O G :-.: , , , cm !O C NC) c mU' O e '_7 - N th!7 69 CV f9) c C N N ^ C) C7 C) 0 N ... 69 1A 1A 69 69. . ... f9 4 1R M d) ?W m a e:C)e e e e a e e at e at e e e e e e e e e O c'O O o m C O C i0 r, — ... ,, ,,,,, N O O N n �? c V cam).- .-.- O N C O C O C) N C M m U e y V Oco N .- U)C N K) ,-.40. ,-. . CO- N 6.- C) OO 06969O W HC) 69`-.1161 °969`44 C. 0e e et V eee e ° ° ° °e e e e e e e e e , c ..0,,,, , --,.. ,..... , c. 0. — m , c O me p co) U e d 7 n4•O n O O Q C) C.C.': C CC 5'A O 0 n 69«c O A0 4440696969 69660.90 -69v0 >,C) M e O 0,92 . -E-t -t � •e -a -e -e -e .t e e ee e M .0 oCC) VCC ) o oono cc: o C) o no 0 00 XO Am L RU m ee o �0, O C)O c 010meeeeee ee eeeeeee ee e ee e C O �m n p O C: O m 0 n.- D C C, 0 v U 0 <e Q w= e e 0 . 00v00000 o0c000wo on = - oC^, c o) c N.= n = m o O i- O S.:'c5 O < Q O 0 ee°° eeee eeee e ee e e ee e I. 5�N C)oc.- c�nu) ^ once acoc mc no 0 U <N-', n M: m 1 Om 2 <o' • 3• ;o co' OOCOO C)CCag C) = moo e\r) o o� o (.S XU r > C C ©U O . m <e neeeeeeee eeat e at e •ee e > g c n r C ) O N c o C) 10 C) C cV C 0 0 O 0 O o MIt _ e- 0 00000000 000CC00 O 000 .m. -- 00 O O O 2_ 0000000o C)C0.- N Q O)0 C) C) O 10 c n C) C Cl) CG ICO CC') C9 A,N c' N V O- CO O'O) m.O C) O t0 0 A 0 n 0 - ._ 'N- ' < 690696969696969 49696969696969 0 0 00 0 0 00000000 0 O o CQ 0 0 0 0 0 0 0 0 = 0 - 0. 5 , o o 0 0 00 O t 2_ 00000000 n N O O C')c n N .- O CC C U) O) ICO On 0 0 o 0- 00-0 ,.- 00 e-_ _ :. m0 -6 = ,0eO ^ N Oc) N G 6969616969696969 69696969.96969 69 69 MW 69 7 CP)n O O = 00 Cn o O O 00 0 O) NO OOC' Cnn' c Q nNcn 'O ' N N NO ON- OOCNC' n O9N) C7 O CO O;C ^ONCmVn ) e O V OC) N©„ N-nOC 'VO 'VCn O F- .- NJC) C 696969696969690 69696969 69 69 09 69 69 069 69 y l-V 20 C C) G Y __') _C V V C 0) d 0 m ', a- C Y Y N Y 2 0 y v c R y 0. u P n _ m 0 -J 0,- O C o c o -- _ 3 = 3 3 0 o 0 0^ Z Q-ov aOJn0000o :J. ZZZw C) CO U N h T CO 1 1 .0. u v N M N N N U 5 0 0 0 0 > %SZ'L %Ot'6 %OS' peersawoH-uoN %9Z.I. %017'I• %08'1. BOZ£ < %08.0 %06'0 %00': eOZE > )l;6I-S < %9£'0 %0t.'0 %S17"0 > pea;sewoH 8pi8 'S puei leJnllno!J6y %0Z'Z %OS'Z %0S'Z ISL$ < %SZ'l %017'l %OS'Z )19LS -NNZL$ %SZ'L %017-1- %09.1. )1ZL$ > su!geo %09'£ %00.17 %09'r '4nn %08'1 %01.'Z %0£'Z (oti) sjose leuosees °io00'l %00'1 %00'l (01.) s;iose pea;sawoH lepJawwoO •oad •uoseaS %OS'£ %00'17 %O9' )1091-$ < %St7'Z %OL'Z %09'4P )1 091,S -)1001$ %8t7'Z %OL'Z %0O'£ )1001$ > le J snpul/le!oJewwoo %00.1- %O6'l %007 VHd %00'1 %00"Z %08'Z II OR!! s}uawuedy ewooui-moi %91'Z %0£'Z %0£-Z '!J IIewS %09'Z %06'Z %O177'£ Jeln6aj 0!un avow Jo j) sluewledy %OL'l %01..Z %0£'Z 6u!pl!nq £ - Z %OE l %01.:Z %0£'Z )ISL$ < %9Z.I. %06'1. %0£'Z )19L$ > 6u!pl nq Al!wel-eI6u!S :pealsewoH-uoN le!4uep!se %OL'I• %98'1. %00'Z )1 SL$ < %W.I. %O0'1 %00-Z )ISL$ ->1ZL$ %00'1, %00'l %00-1. ZL$ > :pealsewoH le!luep!se II!8 xel mei lua.uno L6 ed 6661 Aed 86 Aed II!9 Xel 8661 pue mel TuaJJn3 se6ueyo ssei9 ;o uos!Jedwo3 aeaA lsel?i gego.d II!M}nq `page ui IUs si %OZ eq •j 39 %Z171. Jo aseeioui leioedS • 171-' °/,, Q) - %8'g Jo aseaJoui sen a %9.6 Jo aseaJou! po!JTs1a 100g35 •a �o X (t,1 ( S"t %V}o aseaJou! Anal ATunoa 71,8 %0 6 }o aseeJoui uoiTenIen t/ :suogdwnsse 6u!MolloJ aye L-11!^^ 00'01.$ Aq uMop o6 pinoys sexel scAlunoa Boos 'E b b� ' 0 •00'OZE-.0'SZZ$ wo.4 paseejoui say panwnwixeW •Z .6661.-2661. WWI '099-3C 77,eq a�eJ pan pealsewoH uogeonp3 •6 • Io I io is I 'e 'e •o io o I io co CD IN- itf) ISI O N' [0 0' O v CJ !!'s. ICb I col k- iini! '...co N. Ivto O 1cn i co IIil � • ill II I II I ! IIj1 • • I ! ili ' I 10 .v ;0. LO! I'V 0") a v ISI co a Ico to !- iQ co in i0! .- 7; 10 ICA l IN m 0 v N- 1(C) I L^i'i IN 0i N- M Z x 0) ON 1 CD .O I CO O lf) I N LC) V' s- co I •-1 N- 0) CO 1•- H O N <: co-; c'i m O I co- ol I co co PC') co 1` 1C in Iin C IN O O IN' v IO 'co 0) (C) co O O I cn. co I I In N 0 CO Ta 0 a- N 1 Cf) I C)-: N I I sr u) CO CO 0 V O L'7: Ccnin- (2? a. ') In CD c 'to. CD' I f) c'N- O CO ii. N v v CD 1 C .L)1 Io v < p ivl ivj vI co ) v 1 10 U) U) u) I co v co' I O: •a)I1 N r� o I ,v N J 00)) Ih' •'I Op CCD IC)) r LL I C; 10 Id el 0 0) r) C~) I- .- co I c i N' ! N- 0) 0 to c'') O 0 - - 0.1 O N v to IQ 1�I IN I co Ir' I"' co- Ico I0) ' CN ') CO i .0): N I O c0 N 0)A N-0 v 0 CI O V.1 iC�, N I C7 O O) 0 003 B. CO RO) IN 1 0 `DI IN Ia) COO I C7) :0) N-1 I Co CD co_ U C) 0) I i0 'Lr1 I� N aN CL) �I c`) Zvi !v cI 1tn CnI Cn co —I V i cc LI I O. I I i Cl)I mI m mI .CD! Im COp CO CO C Ci_ t4 sr N 00) I CO CSO)I I CD to to Cr) �I> O). O I Ic+')' LC)i I0) N CO I0 •--I N N I N N 1 N C'1 c') 1.1: VI I I � I 1 I 1 I w • , o IiI• U . ' �� Cl) I^ O) 2 '0) 0 l to Io Ico v v 67; rn o I c) i u) C a am N O) I iL; V. 10 CD v CD CO N. I' I co- :C)) 0 0 O I'-; N N N N 69 69 1 69 I69 I 69 EA 69 69 69 _ CO N v ICr))' 0 I Tr- co co O W 0 C O 01 coomACL) N N 0 0 e- U) N: co- I NI CO N- 0) 0 w CO 0) N 100) :N-' O 00) 0 O ) LLQ N N N I N N co- N Cr; N 69 69 69 I69 :69 I 69 69 co* 69 a) N- ICD: COI CO h v CD I,- C') 0 Cr)i -M' in O M N Q 0) 0) N 10: .CDI N N O M U u) ion 0) co- •- CO- o o = 0) vt c)0 I N i i C'), N v CO CO c) C') co- iv --I ('V C v- ,CA 69 69 i y3 •69 I 169 69 69 49!Iv 'O' Ir- CD v II o 8) I0. CDI i8 Q 25 �_ > � v N '0 �i I S CO- 8 O I v N CD 'i-: I Ch O 0 0) U '- N IN SNI IN N co- co- ,-- I69 I69 69I i69; •691 i69 fA co* 69 I I 1 N f7 iv.: L7 I CD c0 0) } CO 0) Cr) '0): C)I Cr) 0) 0) 0) O 0) Q) I O. -0): 0) Q) 0) 0) I�: I I� . � K i 44 (A e°' 1)e GENERAL FUND The General Fund is used to account for revenues and expenditures necessary to carry out the basic functions of city government. These basic functions include police and fire protection, planning, administration, etc. Appropriations are made from this fund annually. Revenues are recorded by source, i.e. taxes, intergovernmental, charges for services, etc. Expenditures are recorded by object and are primarily for day-to-day operating expenses and equipment. Capital expenditures for large scale public improvements are accounted for within the Capital Projects Funds. 1 I CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET SUMMARY 1993 1994 1995 1996 1997 Actual Actual Actual Actual Actual Revenue Taxes $2,690,777 $2,951,832 $2,950,583 $2,873,265 $3,093,665 Special Assessments 0 0 0 0 0 Licenses and Permits 481,992 410,992 589,104 $711,190 $746,705 Intergovernmental 781,224 831,072 779,276 $876,219 $955,070 Charges for Service 1,277,803 781,002 935,196 $1,075,570 $1,045,053 Fines and Forfeits 63,773 64,914 80,083 $95,865 $84,708 Miscellaneous 238,984 199,290 323,187 $318,053 $438,044 Total Revenue 5,534,553 5,239,102 5,657,429 5,950,162 6,363,245 Expenditures General Government 1,199,244 1,291,772 1,451,119 1,451,119 1,502,375 Public Safety 1,599,182 2,389,753 2,050,871 2,050,871 2,394,648 Public Works 1,694,055 1,017,678 1,123,556 1,123,556 1,222,062 Recreation 635,077 641,707 610,584 610,584 315,551 Miscellaneous 40,040 29,150 33,780 33,780 90,936 Total Expenditures 5,167,598 5,370,060 5,269,910 5,269,910 5,525,572 Excess (deficiency) Revenues over Expenditures 366,955 (130,958) 387,519 680,252 837,673 Other Sources 572,905 1,035,558 759,832 759,832 1,066,545 Other Uses (1,102,265) (242,654) (96,971) (96,971) (2,321,602) Excess (deficiency) Revenues &Other Sources Over Expenditures &Other Uses ($162,405) $661,946 $1,050,380 $1,343,113 ($417,384) Residual Equity Transfer Fund Balance December 31 $1,565,800 $2,227,746 $3,278,126 $4,245,885 $3,828,501 Expenditure projections for 2000 through 2003 assumes a 4%increase each year. Revenues and Expenditures for the Pool and Park&Rec.divisions are budgeted in the Recreation(Enterprise)Fund starting in 1996. 2 1998 1999 2000 2001 2002 2003 Estimate Estimate Estimate Estimate Estimate Estimate $2,962,087 $3,856,828 $4,082,237 $4,320,723 $4,573,129 $4,840,134 0 0 0 0 0 0 $638,300 $738,900 $767,900 $796,900 $825,900 $854,900 $863,517 $959,300 $858,900 $820,400 $820,400 $820,400 $910,520 $1,085,780 $1,100,900 $1,116,260 $1,131,870 $1,147,750 $85,000 $90,000 $92,000 $94,000 $96,000 $98,000 $190,000 $320,000 $320,000 $320,000 $320,000 $320,000 5,649,424 7,050,808 7,221,937 7,468,283 7,767,299 8,081,184 1,680,940 2,049,940 2,131,938 2,217,215 2,305,904 2,398,140 2,530,880 2,784,060 2,895,422 3,011,239 3,131,689 3,256,956 1,396,480 1,482,090 1,541,374 1,603,029 1,667,150 1,733,836 373,940 450,770 468,801 487,553 507,055 527,337 302,790 425,660 442,686 460,394 478,810 497,962 6,285,030 7,192,520 7,480,221 7,779,430 8,090,607 8,414,231 (635,606) (141,712) (258,284) (311,146) (323,308) (333,047) 848,720 825,000 849,750 875,243 901,500 928,545 (332,690) (333,050) (346,372) (360,227) (374,636) (389,621) ($119,576) $350,238 $245,094 $203,869 $203,556 $205,877 $3,708,925 $4,059,163 $4,304,257 $4,508,126 $4,711,682 $4,917,559 1999 GENERAL FUND BUDGET-REVENUES 1993 1994 1995 1996 1997 1998 ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL YTD (6-30-98) Taxes Current Ad Valorem $ 2,298,852 $ 2,532,961 $ 2,559,150 $ 2,480,420 $ 2,620,138 $ 2,793,620 Tax Increment $ 2,298,852 $ 2,532,961 $ 2,559,150 $ 31,605 Fiscal Disparities 301,900 319,487 276,001 272,708 317,008 Lodging Tax 90,025 99,384 115,432 120,137 124,553 38,591 Total Taxes 4,989,629 5,484,793 5,509,733 2,873,265 3,093,304 2,832,211 Special Assessment Licenses& Permits Cable Franchise 48,789 40,680 51,568 42,852 - Track Franchise - 13,888 10,663 8,503 Liquor Licenses 57,574 60,545 66,847 80,094 81,603 80,847 Beer Licenses 4,697 9,077 3,806 644 1,803 1,743 Cigarette licenses 535 645 2,590 3,342 2,300 900 Misc. Business Permits 2,455 5,108 3,326 5,443 3,690 482 Building Permits 256,132 201,983 323,876 428,871 431,498 313,266 Plumbing Permits 41,536 31,123 41,789 50,097 71,590 42,285 Mechanical Permits 23,975 26,372 36,159 28,839 70,337 21,026 Electric Permits 31,722 24,374 33,510 43,354 58,261 27,449 Fire Permit Rev Septic Permits 1,200 1,500 1,802 1,550 1,450 750 Sewer Permits 6,134 5,253 5,981 8,232 9,067 9,738 Street Opening Permits 6,900 3,725 3,500 6,650 5,880 2,520 Dog Licenses 258 286 458 559 724 446 Misc. Non-Bus. Lic. 85 321 4 - - 40 Total Lic. & Permits 481,992 410,992 589,104 711,190 746,706 501,492 Intergovernmental Grants 13,306 23,332 47,016 8,618 State Grants &Aids 147,216 158,842 150,866 263,740 Local Government Aid 147,216 158,842 150,866 177,612 194,793 HACA 417,747 450,363 456,586 433,665 443,694 Mobile Home 634 593 1,070 928 361 Local Performance Aid 15,506 PERA Aid 9,085 Police Training 6,379 5,911 6,168 6,449 5,406 State Hwy Maint Aid 103,164 101,085 33,303 101,795 119,473 Police State Aid 89,686 98,471 96,680 111,412 103,185 County Grants/Aid 89,686 98,471 96,680 - - Aggregate Tax 11,010 15,807 12,497 21,026 16,912 Total Intergovernmental 1,012,738 1,088,385 1,018,022 876,219 955,431 272,358 Charges for Service Administrative Fee 63,846 29,582 61,048 41,863 51,005 16,694 Plan Check 134,895 108,917 177,691 252,211 241,577 180,352 Sale of Documents 7,256 9,354 10,601 9,511 9,750 5,710 Assessment Search 5,850 4,010 4,453 4,431 4,834 4,005 Release of Dev. Agreem 470 490 583 411 420 358 Comprehensive Plan Fee 100 2,470 194 87 175 Land Division Administrat 22,378 18,754 5,877 11,960 13,627 11,165 Land Use Administration 7,036 26,963 27,539 49,523 9,242 Radon Kit Sales 1,000 4 1 1999 GENERAL FUND BUDGET- REVENUES , 1998 1999 2000 2001 2002 2003 EST. EST. EST. EST. EST. EST. Taxes Current Ad Valorem $ 2,515,557 $ 3,411,733 $ 3,616,437 $ 3,833,423 $ 4,063,429 $ 4,307,234 Tax Increment $ - $ - $ - $ - $ Fiscal Disparities 337,530 315,095 330,800 347,300 364,700 382,900 Lodging Tax 109,000 130,000 135,000 140,000 145,000 150,000 Total Taxes 2,962,087 3,856,828 4,082,237 4,320,723 4,573,129 4,840,134 Special Assessment Licenses&Permits Cable Franchise - - - - Track Franchise 10,000 10,000 10,000 10,000 10,000 10,000 Liquor Licenses 78,000 80,000 80,000 80,000 80,000 80,000 Beer Licenses 3,000 2,000 2,000 2,000 2,000 2,000 Cigarette licenses 3,300 3,300 3,300 3,300 3,300 3,300 Misc. Business Permits 2,500 4,000 4,000 4,000 4,000 4,000 Building Permits 400,000 450,000 470,000 490,000 510,000 530,000 Plumbing Permits 50,000 70,000 75,000 80,000 85,000 90,000 Mechanical Permits 40,000 40,000 42,000 44,000 46,000 48,000 Electric Permits 40,000 45,000 45,000 45,000 45,000 45,000 Fire Permit Rev 20,000 22,000 24,000 26,000 28,000 Septic Permits 1,000 1,000 1,000 1,000 1,000 1,000 Sewer Permits 5,000 7,000 7,000 7,000 7,000 7,000 Street Opening Permits 5,000 6,000 6,000 6,000 6,000 6,000 Dog Licenses 500 600 600 600 600 600 Misc. Non-Bus. Lic. - - - - - Total Lic. & Permits 638,300 738,900 767,900 796,900 825,900 854,900 Intergovernmental Grants 50,000 100,400 State Grants &Aids 5,600 5,600 5,600 5,600 5,600 Local Government Aid 203,590 213,625 213,625 213,625 213,625 213,625 HACA 443,170 442,945 442,945 442,945 442,945 442,945 Mobile Home 800 700 700 700 700 700 Local Performance Aid 17,437 16,600 16,600 16,600 16,600 16,600 PERA Aid 11,930 11,930 11,930 11,930 11,930 Police Training 7,000 6,000 6,000 6,000 6,000 6,000 State Hwy Maint Aid - Police State Aid 110,000 105,000 105,000 105,000 105,000 105,000 County Grants/Aid 16,520 38,500 38,500 - - - Aggregate Tax 15,000 18,000 18,000 18,000 18,000 18,000 Total Intergovernmental 863,517 959,300 858,900 820,400 820,400 820,400 Charges for Service Administrative Fee 45,000 45,000 45,000 45,000 45,000 45,000 Plan Check 250,000 290,000 295,000 300,000 305,000 310,000 Sale of Documents 10,000 10,000 10,000 10,000 10,000 10,000 Assessment Search 4,000 5,000 5,000 5,000 5,000 5,000 Release of Dev. Agreem 400 400 400 400 400 400 Comprehensive Plan Fee 250 100 100 100 100 100 Land Division Administrat 14,000 14,420 14,850 15,300 15,760 16,230 Land Use Administration 40,000 41,000 41,500 42,000 42,500 43,000 Radon Kit Sales Misc. Police Services 10,000 12,000 14,000 16,000 18,000 5 1999 GENERAL FUND BUDGET-REVENUES 1993 1994 1995 1996 1997 1998 ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL YTD (6-30-98) Misc. Police Services 14,256 4,734 11,241 18,488 27,818 2,262 Fire Calls&Contracts 27,115 29,748 32,973 27,172 39,881 18,014 Pound Fines& Fees 1,417 2,998 2,190 3,260 3,100 1,510 Valleyfair 12,336 13,570 14,927 16,420 18,062 19,868 Snow Removal 5,878 6,228 3,943 5,712 8,737 Street Repair 875 - - - Public Works Rentals 751 803 - - Misc. Public Works 7,538 8,194 10,401 30,618 19,455 10,714 Engineering Services 308,966 375,527 394,976 546,920 502,118 221,154 Engineering Grade Fee 3,399 2,850 2,401 78,967 53,970 29,421 Weed Removal 570 - - Refuse Disposal 497,963 - - - Refuse Coupons 13,298 - - - - Memberships 16,207 21,260 23,069 - - - General Admissions 22,027 24,902 33,533 - - - Lessons 7,649 9,349 9,204 - - - Water Slide 9,227 - - - - - Youth Activities 41,167 42,718 43,565 - - - Adult Activities 35,127 34,988 38,255 - - - Concessions 10,796 11,268 7,759 - - - Concessions Commission 1,897 - - - Non Resident Fee 70 2,365 2,609 - - - Township Contributions 4,179 4,179 8,279 - - - Other Recreation Fees 3,642 4,636 5,191 - - - Total Charges for Svs. 1,277,803 781,002 935,196 1,075,570 1,045,052 530,469 Fines and Forfeits Court Fines 63,773 64,914 80,083 95,865 84,708 47,202 Miscellaneous Miscellaneous 50,177 52,267 70,906 57,559 115,161 28,609 Interest 168,411 129,718 219,412 235,918 296,330 Rent 13,629 15,670 29,673 24,576 21,202 7,850 Contributions 6,768 1,635 3,196 - 5,350 - Total Miscellaneous 238,985 199,290 323,187 318,053 438,043 36,459 Total Revenues 8,064,920 8,029,376 8,455,325 5,950,162 6,363,244 4,220,191 Other Sources Sale Of Assets 3,106 2,059 342 2,462 75,000 Operating Transfers 218,885 Capital Equipment 290,318 747,302 - SPUC Contribution 279,481 286,197 759,489 789,232 772,660 377,760 Total Other Sources 572,905 1,035,558 759,831 791,694 1,066,545 377,760 Grand Total $8,637,825 $9,064,934 $9,215,156 $6,741,856 $7,429,789 $4,597,951 6 1999 GENERAL FUND BUDGET-REVENUES , t 1998 1999 2000 2001 2002 2003 EST. EST. EST. EST. EST. EST. Fire Calls&Contracts 35,000 35,000 35,000 35,000 35,000 35,000 Pound Fines&Fees 2,000 3,000 3,000 3,000 3,000 3,000 Valleyfair 19,870 21,860 24,050 26,460 29,110 32,020 Snow Removal - - - - - Street Repair - Public Works Rentals - - - - - - Misc. Public Works 15,000 20,000 20,000 20,000 20,000 20,000 Engineering Services 410,000 525,000 530,000 535,000 540,000 545,000 Engineering Grade Fee 65,000 65,000 65,000 65,000 65,000 65,000 Weed Removal Refuse Disposal Refuse Coupons Memberships - - - General Admissions Lessons - - - - Water Slide Youth Activities - - - - Adult Activities - - - - Concessions - Concessions Commission Non Resident Fee - - - Township Contributions Other Recreation Fees - - - - Total Charges for Svs. 910,520 1,085,780 1,100,900 1,116,260 1,131,870 1,147,750 Fines and Forfeits Court Fines 85,000 90,000 92,000 94,000 96,000 98,000 Miscellaneous Miscellaneous 40,000 60,000 60,000 60,000 60,000 60,000 Interest 140,000 245,000 245,000 245,000 245,000 245,000 Rent 10,000 15,000 15,000 15,000 15,000 15,000 Contributions - - - Total Miscellaneous 190,000 320,000 320,000 320,000 320,000 320,000 Total Revenues 5,649,424 7,050,808 7,221,937 7,468,283 7,767,299 8,081,184 Other Sources Sale Of Assets Operating Transfers Capital Equipment SPUC Contribution 848,720 825,000 849,750 875,243 901,500 928,545 Total Other Sources 848,720 825,000 849,750 875,243 901,500 928,545 Grand Total $6,498,144 $7,875,808 $8,071,687 $8,343,526 $8,668,798 $9,009,729 7 General Fund Budget Summary by Division 1996 1997 1998 Y-T-D DEPARTMENT PROPOSED Division ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET 001 -GENERAL FUND DIVISION 00 - N/A 420 SUPPLIES & SERVICES 0 0 0 250 0 0 TOTAL N/A DIVISION 0 0 0 250 0 0 DIVISION 11 - MAYOR & COUNCIL 410 PERSONNEL SERVICES 31,247 31,486 32,740 13,061 33,880 33,880 420 SUPPLIES & SERVICES 38,730 20,501 32,590 5,948 40,200 40,200 TOTAL MAYOR & COUNCIL DIVISION 69,978 51,987 65,330 19,009 74,080 74,080 DIVISION 12 - CITY ADMINISTRATOR 410 PERSONNEL SERVICES 121,598 142,480 182,700 57,816 183,080 183,080 420 SUPPLIES & SERVICES 103,189 34,219 39,800 10,491 35,510 35,510 450 CAPITAL EXPENDITURES 12,615 0 2,500 0 0 0 TOTAL CITY ADMINISTRATOR DIVISION 237,402 176,700 225,000 68,307 218,590 218,590 DIVISION 13 - CITY CLERK 410 PERSONNEL SERVICES 95,303 128,656 143,820 51,359 144,790 144,790 420 SUPPLIES & SERVICES 30,105 34,546 38,110 9,659 40,550 40,550 450 CAPITAL EXPENDITURES 0 0 3,500 0 0 0 480 EXPENSE CHARGED TO OTHER ACT -3,000 -3,000 -3,000 0 -3,000 -3,000 TOTAL CITY CLERK DIVISION 122,408 160,202 182,430 61,018 182,340 182,340 DIVISION 15 - FINANCE 410 PERSONNEL SERVICES 204,303 202,930 208,130 72,804 213,040 213,040 420 SUPPLIES & SERVICES 100,013 106,821 125,960 32,132 139,960 139,960 480 EXPENSE CHARGED TO OTHER ACT -8,000 -8,000 -8,000 0 -8,000 -8,000 TOTAL FINANCE DIVISION 296,316 301,751 326,090 104,936 345,000 345,000 DIVISION 16 - LEGAL COUNSEL 410 PERSONNEL SERVICES 87,152 0 0 0 0 0 420 SUPPLIES & SERVICES 127,027 246,612 253,500 101,437 269,000 269,000 480 EXPENSE CHARGED TO OTHER ACT -3,000 0 0 0 0 0 TOTAL LEGAL COUNSEL DIVISION 211,180 246,612 253,500 101,437 269,000 269,000 DIVISION 17 - COMMUNITY DEVELOPMENT 410 PERSONNEL SERVICES 168,907 235,594 264,300 100,561 307,950 307,950 420 SUPPLIES & SERVICES 167,081 178,168 234,400 62,316 430,170 430,170 450 CAPITAL EXPENDITURES 2,297 6,844 0 0 0 0 480 EXPENSE CHARGED TO OTHER ACT -6,000 -5,000 -6,000 0 -6,000 -6,000 TOTAL COMMUNITY DEVELOPMENT DIVISION 332,285 415,605 492,700 162,877 732,120 732,120 DIVISION 18 - GENERAL GOVERNMENT BUILDINGS 410 PERSONNEL SERVICES 36,682 23,695 27,490 7,667 27,940 27,940 420 SUPPLIES & SERVICES 95,382 126,038 114,400 26,710 200,870 200,870 450 CAPITAL EXPENDITURES 0 0 12,000 0 0 0 TOTAL GENERAL GOVERNMENT BUILDINGS DIVISION 132,065 149,733 153,890 34,377 228,810 228,810 DIVISION 31 - POLICE 410 PERSONNEL SERVICES 1,358,844 1,469,212 1,540,790 591,393 1,522,690 1,522,690 420 SUPPLIES & SERVICES 211,632 239,939 253,930 88,719 291,950 291,950 8 , General Fund Budget Summary by Division 1996 1997 1998 Y-T-D DEPARTMENT PROPOSED Division ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET 450 CAPITAL EXPENDITURES 13,723 1,728 19,650 1,623 69,000 69,000 TOTAL POLICE DIVISION 1,584,199 1,710,879 1,814,370 681,735 1,883,640 1,883,640 DIVISION 32 - FIRE 410 PERSONNEL SERVICES 140,576 137,094 162,420 29,884 142,430 142,430 420 SUPPLIES & SERVICES 247,810 293,249 320,140 113,464 447,990 447,990 450 CAPITAL EXPENDITURES 2,765 3,608 4,300 1,585 28,000 28,000 TOTAL FIRE DIVISION 391,152 433,951 486,860 144,933 618,420 618,420 DIVISION 33 - INSPECTION-BLDG-PLMBG-NTG 410 PERSONNEL SERVICES 173,517 191,718 204,380 65,376 202,640 202,640 420 SUPPLIES & SERVICES 55,789 58,101 57,020 16,838 79,360 79,360 450 CAPITAL EXPENDITURES 2,689 0 0 0 0 0 TOTAL INSPECTION-BLDG-PLMBG-HTG DIVISION 231,995 249,818 261,400 82,214 282,000 282,000 DIVISION 41 - ENGINEERING 410 PERSONNEL SERVICES 322,477 344,484 380,710 135,129 432,560 432,560 420 SUPPLIES & SERVICES 52,930 43,123 69,300 9,010 68,550 68,550 450 CAPITAL EXPENDITURES 3,529 3,104 0 0 0 0 480 EXPENSE CHARGED TO OTHER ACT -8,000 -8,000 -8,000 0 -8,000 -8,000 TOTAL ENGINEERING DIVISION 370,937 382,711 442,010 144,139 493,110 493,110 DIVISION 42 - STREET MAINTENANCE 410 PERSONNEL SERVICES 280,607 285,406 391,960 107,654 327,500 327,500 420 SUPPLIES & SERVICES 440,395 427,394 836,620 112,550 516,950 516,950 450 CAPITAL EXPENDITURES 0 2,309 0 0 0 0 TOTAL STREET MAINTENANCE DIVISION 721,002 715,109 1,228,580 220,204 844,450 844,450 DIVISION 44 - SHOP 410 PERSONNEL SERVICES 79,907 88,918 98,040 36,221 105,770 105,770 420 SUPPLIES & SERVICES 21,442 35,324 23,350 4,073 35,260 35,260 450 CAPITAL EXPENDITURES 5,427 0 4,500 0 3,500 3,500 TOTAL SHOP DIVISION 106,776 124,242 125,890 40,294 144,530 144,530 DIVISION 46 - PARK MAINTENANCE 410 PERSONNEL SERVICES 160,658 186,995 205,520 82,458 206,210 206,210 420 SUPPLIES & SERVICES 121,941 128,555 172,420 50,759 205,060 205,060 450 CAPITAL EXPENDITURES 0 0 0 0 39,500 39,500 TOTAL PARK MAINTENANCE DIVISION 282,599 315,551 377,940 133,217 450,770 450,770 DIVISION 91 - UNALLOCATED 410 PERSONNEL SERVICES 0 0 0 54,107 0 0 420 SUPPLIES & SERVICES 20,209 90,722 194,140 308,566 425,660 425,660 470 TRANSFERS OUT 663,596 2,321,602 332,690 0 333,050 333,050 TOTAL UNALLOCATED DIVISION 683,805 2,412,324 526,830 362,673 758,710 758,710 TOTAL GENERAL FUND 5,774,097 7,847,174 6,962,820 2,361,621 7,525,570 7,525,570 9 1 Y CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: MAYOR & COUNCIL ACTIVITY: Includes ceremonial functions performed by the Mayor, who is elected as Mayor and who is the Chief Executive Officer of the City. The Mayor serves as Chairman of the Council and is a voting member of the Council. The Mayor has no power of veto. Council activity includes legislative and policy making functions as well as liaison membership on numerous boards and commissions. The Mayor and four Council Members are elected at-large. OBJECT DESCRIPTION: Description of lines items: Salaries: Mayor's salary @ $6,120 and Council @ $5,100 per year, and the Recording Secretary @ $3,500. PERA: PERA for Mayor and all Council Members @ 5.18%. FICA: FICA for all members @ 7.65%. Professional Service: Provides for production of 4500 issues of the City Newsletter on a quarterly basis $6,500 and $6,000 in undesignated projects. Postage: Delivery of City Newsletter in mint advertiser on a quarterly basis $2,800. Printing/Publishing: Printing ordinances for code books $3,500. Conference/School/Training: LMC conference, one national conference for Mayor. Dues: AMM dues $3,900, League dues $6,800, SRA $1,300, Utility Coalition $2,700, misc. $600. Miscellaneous: Volunteer/employee appreciation picnic and retirement/appreciation plaques. CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 11 - MAYOR & COUNCIL 4110 WAGES - TEMP 27,795 28,017 29,020 14,096 30,020 30,020 4121 PERA 1,326 1,326 1,500 663 1,560 1,560 4122 FICA 2,126 2,143 2,220 1,078 2,300 2,300 PERSONNEL SERVICES 31,247 31,486 32,740 15,837 33,880 33,880 4210 OPERATING SUPPLIES 642 766 700 327 800 800 4310 PROFESSIONAL SERVICES 18,562 3,574 8,000 1,680 12,500 12,500 4320 POSTAGE 905 0 1,000 0 3,800 3,800 4321 TELEPHONE 240 280 300 117 300 300 4330 TRAVEL/SUBSISTENCE 689 530 1,000 153 400 400 4350 PRINTING/PUBLISHING 3,000 0 4,000 0 3,500 3,500 4360 INSURANCE 695 836 800 0 800 800 4390 CONFERENCE/SCHOOL/TRAINING 770 180 1,500 403 1,500 1,500 4430 DESIGNATED MISCELLANEOUS 740 1,107 1,000 58 800 800 4433 DUES 12,488 13,228 14,290 5,046 15,800 15,800 SUPPLIES & SERVICES 38,730 20,501 32,590 7,784 40,200 40,200 TOTAL MAYOR & COUNCIL DIVISION 69,978 51,987 65,330 23,621 74,080 74,080 1 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM 111 MGT TOTAL MAYOR & COUNCIL 4110 WAGES - TEMP 30,020 30,020 4121 PERA 1,560 1,560 4122 FICA 2,300 2,300 Total PERSONNEL SERVICES $33,880 $33,880 4210 OPERATING SUPPLIES 800 800 4310 PROFESSIONAL SERVICES 12,500 12,500 4320 POSTAGE 3,800 3,800 4321 TELEPHONE 300 300 4330 TRAVEL/SUBSISTENCE 400 400 4350 PRINTING/PUBLISHING 3,500 3,500 4360 INSURANCE 800 800 4390 CONFERENCE/SCHOOL/TRAINING 1,500 1,500 4430 DESIGNATED MISCELLANEOUS 800 800 4433 DUES 15,800 15,800 Total SUPPLIES & SERVICES $40,200 $40,200 TOTAL MAYOR & COUNCIL $74,080 $74,080 12 1999 BUDGET 1999 Title/Description Step 1999 Pay FICA PERA Mayor N/A $ 6,120 $ 468 $ 317 Council Member N/A 5,100 390 264 Council Member N/A 5,100 390 264 Council Member N/A 5,100 390 264 Council Member N/A 5,100 390 264 Recording Secretary N/A 3,500 268 181 Total Mayor& Council $ 30,020 $ 2,296 $ 1,554 1q CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: ADMINISTRATION ACTIVITY: The City Administrator's activities include direction and coordination of all city departments in carrying out the policies established by City Council, preparation of the annual budget, making recommendations to City Council concerning existing and new programs for the city, and advising City Council on personnel matters. The City administrator is appointed by City Council. OBJECT DESCRIPTION: Description of lines items: Salaries: City Administrator, Administrative Aide 6 months, Secretary, and Payroll/Benefits Coordinator (40%) . Professional Service: LMC Labor Relations $3,500, Negotiations $7,000, miscellaneous personnel studies $5,000. Conference/School/Training: State Managers Conference $500, National ICMA $1,500, other training $300. General department training $2,000. Rentals: 1988 Pontiac Grand Am $1,350 Dues: ICMA $600, MN Managers Association $75, Chamber of Commerce $80, miscellaneous $400. Subscriptions/Publication Miscellaneous $300, Personnel software $300. Performance Measures: 1995 1996 1997 Department Expenditures $203,179 $237,402 $176,700 City Households 4,877 5,307 5,755 Cost Per Household $41.66 $44.73 $30.70 1 4 i CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 12 - CITY ADMINISTRATOR 4101 WAGES FT REG 129,040 118,722 149,350 59,007 149,170 149,170 4102 OVERTIME-FT 12 0 200 0 0 0 4110 WAGES - TEMP 164 465 0 166 650 650 4121 PERA 2,880 2,004 7,750 1,166 3,770 3,770 4122 FICA 9,910 8,605 11,440 4,556 11,410 11,410 4123 ICMA 1,337 3,204 0 1,868 4,020 4,020 4131 HEALTH & LIFE 5,451 4,458 9,600 2,262 9,600 9,600 4151 WORKERS COMPENSATION 355 466 360 0 460 460 4170 COMPENSATED ABSENCES -27,551 4,556 4,000 0 4,000 4,000 PERSONNEL SERVICES 121,598 142,480 182,700 69,026 183,080 183,080 4210 OPERATING SUPPLIES 2,576 1,836 2,600 264 2,000 2,000 4222 MOTOR FUELS & LUBRICANTS 0 68 500 27 200 200 4240 EQUIPMENT MAINTENANCE 182 322 1,000 143 600 600 4310 PROFESSIONAL SERVICES 84,049 15,918 21,500 6,381 15,500 15,500 4321 TELEPHONE 1,364 1,107 1,400 427 1,400 1,400 4330 TRAVEL/SUBSISTENCE 1,992 2,081 2,000 716 1,500 1,500 4350 PRINTING/PUBLISHING 2,595 3,846 3,000 2,472 4,200 4,200 4360 INSURANCE 1,803 2,337 2,500 0 2,500 2,500 4390 CONFERENCE/SCHOOL/TRAINING 1,094 1,059 2,300 240 4,300 4,300 4410 RENTALS 0 1,356 540 270 1,350 1,350 4430 DESIGNATED MISCELLANEOUS 5,121 0 0 0 0 0 4433 DUES 2,292 3,949 1,360 321 1,360 1,360 4435 SUBSCRIPTIONS/PUBLICATIONS 120 340 1,100 104 600 600 SUPPLIES & SERVICES 103,189 34,219 39,800 11,365 35,510 35,510 4550 EQUIPMENT 12,615 0 2,500 0 0 0 CAPITAL EXPENDITURES 12,615 0 2,500 0 0 0 TOTAL CITY ADMINISTRATOR DIVISION 237,402 176,700 225,000 80,391 218,590 218,590 15 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM PROGRAM PROGRAM 120 121 123 125 BENEFITS MGT PERSONNEL CABLE TOTAL CITY ADMINISTRATOR 4101 WAGES FT REG 17,000 113,830 17,340 1,000 149,170 4110 WAGES - TEMP 0 350 0 300 650 4121 PERA 350 2,450 900 70 3,770 4122 FICA 1,300 8,680 1,330 100 11,410 4123 ICMA 4,020 0 0 0 4,020 4131 HEALTH & LIFE 9,600 0 0 0 9,600 4151 WORKERS COMPENSATION 460 0 0 0 460 4170 COMPENSATED ABSENCES 4,000 0 0 0 4,000 Total PERSONNEL SERVICES $36,730 $125,310 $19,570 $1,470 $183,080 4210 OPERATING SUPPLIES 0 2,000 0 0 2,000 4222 MOTOR FUELS & LUBRICANTS 0 200 0 0 200 4240 EQUIPMENT MAINTENANCE 0 600 0 0 600 4310 PROFESSIONAL SERVICES 0 0 15,500 0 15,500 4321 TELEPHONE 0 1,400 0 0 1,400 4330 TRAVEL/SUBSISTENCE 0 1,500 0 0 1,500 4350 PRINTING/PUBLISHING 0 4,200 0 0 4,200 4360 INSURANCE 0 2,500 0 0 2,500 4390 CONFERENCE/SCHOOL/TRAINING 0 4,300 0 0 4,300 4410 RENTALS 0 1,350 0 0 1,350 4433 DUES 0 1,360 0 0 1,360 4435 SUBSCRIPTIONS/PUBLICATIONS 0 600 0 0 600 Total SUPPLIES & SERVICES $0 $20,010 $15,500 $0 $35,510 TOTAL CITY ADMINISTRATOR $36,730 $145,320 $35,070 $1,470 $218,590 16 1999 BUDGET 1999 1999 Pay With Title/Description Step 2%COL Inc FICA PERA City Administrator N/A $ 76,500 $ 5,852 $ - Administrative Intern 1 17,350 1,327 899 Executive Secretary 8 37,968 2,905 1,967 Charge in Personnel N/A 17,344 1,327 898 Total Administration $ 149,162 $ 11,411 $ 3,764 17 CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: CITY CLERK ACTIVITY: The City Clerk's activities involve statutory clerk's responsibilities (except financial responsibilities) including record keeping, publications, elections, licenses, developer's agreements; also, assist City Administrator in agenda preparation and follow-up, research and preparation of memos recommending changes to City Code, city policies and responding to citizen problems/concerns. OBJECT DESCRIPTION: Description of lines items: Salaries: City Clerk, Secretary, and Customer Service Representative. Salaries - Temp: Election Judges Postage: City Hall mailing machine Printing and Publication: Legal printing, copies Performance Measures: 1995 1996 1997 Department Expenditures $123,541 $237,402 $160,202 City Households 4,877 5,307 5,755 Cost Per Household $25.33 $23.07 $27.84 18 CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 13 - CITY CLERK 4101 WAGES FT REG 73,629 105,426 106,820 50,850 111,950 111,950 4102 OVERTIME-FT 24 0 0 0 0 0 4110 WAGES - TEMP 5,208 1,437 6,000 0 1,500 1,500 4121 PERA 3,183 4,527 5,540 2,505 5,810 5,810 4122 FICA 5,617 7,999 8,630 3,735 8,680 8,680 4131 HEALTH & LIFE 5,743 8,555 14,230 4,450 14,250 14,250 4151 WORKERS COMPENSATION 414 419 600 0 600 600 4170 COMPENSATED ABSENCES 1,484 292 2,000 0 2,000 2,000 PERSONNEL SERVICES 95,303 128,656 143,820 61,541 144,790 144,790 4210 OPERATING SUPPLIES 1,004 1,262 3,500 176 3,200 3,200 4240 EQUIPMENT MAINTENANCE 0 0 250 0 250 250 4310 PROFESSIONAL SERVICES 250 674 1,000 0 1,350 1,350 4316 FILING FEES 249 1,106 1,000 268 1,000 1,000 4320 POSTAGE 9,603 9,140 10,700 5,552 11,000 11,000 4321 TELEPHONE 510 850 850 353 900 900 4330 TRAVEL/SUBSISTENCE 0 58 150 0 150 150 4350 PRINTING/PUBLISHING 16,448 18,455 18,000 5,665 18,600 18,600 4360 INSURANCE 1,305 1,759 1,700 363 1,810 1,810 4390 CONFERENCE/SCHOOL/TRAINING 51 416 320 80 1,500 1,500 4410 RENTALS 566 567 500 136 650 650 4433 DUES 120 40 140 120 140 140 4435 SUBSCRIPTIONS/PUBLICATIONS 0 220 0 0 0 0 SUPPLIES & SERVICES 30,105 34,546 38,110 12,711 40,550 40,550 4550 EQUIPMENT 0 0 3,500 0 0 0 CAPITAL EXPENDITURES 0 0 3,500 0 0 0 4800 EXPENSE CHARGED BACK -3,000 -3,000 -3,000 0 -3,000 -3,000 EXPENSE CHARGED TO OTHER ACT -3,000 -3,000 -3,000 0 -3,000 -3,000 TOTAL CITY CLERK DIVISION 122,408 160,202 182,430 74,252 182,340 182,340 I CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM PROGRAM 130 131 132 BENEFITS MGT ELECTIONS TOTAL CITY CLERK 4101 WAGES FT REG 17,500 92,950 1,500 111,950 4110 WAGES - TEMP 0 0 1,500 1,500 4121 PERA 910 4,820 80 5,810 4122 FICA 1,340 7,110 230 8,680 4131 HEALTH & LIFE 14,250 0 0 14,250 4151 WORKERS COMPENSATION 600 0 0 600 4170 COMPENSATED ABSENCES 2,000 0 0 2,000 Total PERSONNEL SERVICES $36,600 $104,880 $3,310 $144,790 4210 OPERATING SUPPLIES 0 2,500 700 3,200 4240 EQUIPMENT MAINTENANCE 0 250 0 250 4310 PROFESSIONAL SERVICES 0 250 1,100 1,350 4316 FILING FEES 0 1,000 0 1,000 4320 POSTAGE 0 11,000 0 11,000 4321 TELEPHONE 0 900 0 900 4330 TRAVEL/SUBSISTENCE 0 150 0 150 4350 PRINTING/PUBLISHING 0 17,500 1,100 18,600 4360 INSURANCE 0 1,810 0 1,810 4390 CONFERENCE/SCHOOL/TRAINING 0 1,500 0 1,500 4410 RENTALS 0 550 100 650 4433 DUES 0 140 0 140 Total SUPPLIES & SERVICES SO $37,550 $3,000 $40,550 4800 EXPENSE CHARGED BACK 0 -3,000 0 -3,000 Total EXPENSE CHARGED TO OTHER ACT SO $-3,000 SO S-3,000 TOTAL CITY CLERK $36,600 $139,430 $6,310 $182,340 20 1r? 1999 BUDGET 1999 1999 Pay With Title/Description Step 2% COL Inc FICA PERA City Clerk 8 $ 49,406 $ 3,780 $ 2,559 Secretary 8 33,346 2,551 1,727 Customer Service 8 29,198 2,234 1,512 Total City Clerk $ 111,950 $ 8,565 $ 5,798 21 CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: FINANCE ACTIVITY: The major activities of the Finance Department encompass payroll, accounts payable, cash management, accounts receivable, financial reports, assessments, annual financial report, budget, insurance and many other of lessor importance. OBJECT DESCRIPTION: Description of lines items: Salaries: Finance Director, Accountant, Payroll/Benefits Coordinator (60%) , Acc't. Clerk Professional Services: Auditing services (total = $25,000) , County TNT notices $500, Investment safe keeping fees - offset by revenue $4,500, misc. services as needed ($1,000)and assessing contract with the county ($51,400) , county special assessment fees $3,000. Rentals: LOGIS Performance Measure - Assessing 1996 1997 1998 1999 Cost $38,170 $40,700 $44,100 $51,400 # Parcels 5,082 5,685 6,305 6,856 Cost per parcel 7.511 7.159 6.994 7.44 Sales Ratio Period 10/94-9/95 10/95-9/96 10/96-9/97 Residential 86.8 87.4 95.5 Commercial 105.3 90.3 100.3 22 CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 15 - FINANCE 4101 WAGES FT REG 168,303 169,797 162,400 73,973 160,990 160,990 4102 OVERTIME-FT 0 0 0 671 1,000 1,000 4110 WAGES - TEMP 0 0 0 0 5,000 5,000 4121 PERA 7,224 7,313 8,400 3,622 8,390 8,390 4122 FICA 12,726 12,879 12,700 5,506 12,780 12,780 4131 HEALTH & LIFE 9,642 10,886 19,030 6,256 19,280 19,280 4151 WORKERS COMPENSATION 1,428 585 600 0 600 600 4170 COMPENSATED ABSENCES 4,980 1,471 5,000 0 5,000 5,000 PERSONNEL SERVICES 204,303 202,930 208,130 90,027 213,040 213,040 4210 OPERATING SUPPLIES 3,511 6,307 6,450 274 5,050 5,050 4222 MOTOR FUELS & LUBRICANTS 50 50 50 0 50 50 4240 EQUIPMENT MAINTENANCE 508 940 1,300 23 1,300 1,300 4310 PROFESSIONAL SERVICES 56,671 59,533 73,670 57,129 85,400 85,400 4321 TELEPHONE 2,284 2,430 2,800 1,118 2,800 2,800 4330 TRAVEL/SUBSISTENCE 515 521 850 9 1,000 1,000 4350 PRINTING/PUBLISHING 938 781 1,370 938 1,500 1,500 4360 INSURANCE 2,772 3,807 3,200 363 4,000 4,000 4390 CONFERENCE/SCHOOL/TRAINING 265 745 1,000 139 1,000 1,000 4410 RENTALS 32,150 31,589 34,900 19,769 37,460 37,460 4431 CASH SHORT/OVER 14 -7 0 97 0 0 4433 DUES 310 125 370 215 400 400 4435 SUBSCRIPTIONS/PUBLICATIONS 23 0 0 0 0 0 SUPPLIES & SERVICES 100,013 106,821 125,960 80,074 139,960 139,960 4800 EXPENSE CHARGED BACK -8,000 -8,000 -8,000 0 -8,000 -8,000 EXPENSE CHARGED TO OTHER ACT -8,000 -8,000 -8,000 0 -8,000 -8,000 TOTAL FINANCE DIVISION 296,316 301,751 326,090 170,102 345,000 345,000 23 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM 150 151 152 153 155 156 BENEFITS MGT ACCOUNTING PAYROLL BUDGET ASSESSMNT TOTAL FINANCE 4101 WAGES FT REG 30,500 29,500 72,990 15,500 11,500 1,000 160,990 4102 OVERTIME-FT 0 0 1,000 0 0 0 1,000 4110 WAGES - TEMP 0 0 5,000 0 0 0 5,000 4121 PERA 1,580 1,530 3,830 800 600 50 8,390 4122 FICA 2,330 2,260 6,040 1,190 880 80 12,780 4131 HEALTH & LIFE 19,280 0 0 0 0 0 19,280 4151 WORKERS COMPENSATION 600 0 0 0 0 0 600 4170 COMPENSATED ABSENCES 5,000 0 0 0 0 0 5,000 Total PERSONNEL SERVICES $59,290 $33,290 $88,860 $17,490 $12,980 $1,130 $213,040 4210 OPERATING SUPPLIES 0 4,000 350 300 100 300 5,050 4222 MOTOR FUELS & LUBRICANTS 0 50 0 0 0 0 50 4240 EQUIPMENT MAINTENANCE 0 1,300 0 0 0 0 1,300 4310 PROFESSIONAL SERVICES 0 57,400 25,000 0 0 3,000 85,400 4321 TELEPHONE 0 2,800 0 0 0 0 2,800 4330 TRAVEL/SUBSISTENCE 0 1,000 0 0 0 0 1,000 4350 PRINTING/PUBLISHING 0 1,000 0 100 400 0 1,500 4360 INSURANCE 0 4,000 0 0 0 0 4,000 4390 CONFERENCE/SCHOOL/TRAINING 0 1,000 0 0 0 0 1,000 4410 RENTALS 0 9,320 14,310 10,150 0 3,680 37,460 4433 DUES 0 400 0 0 0 0 400 Total SUPPLIES & SERVICES $0 $82,270 $39,660 $10,550 $500 $6,980 $139,960 4800 EXPENSE CHARGED BACK 0 -8,000 0 0 0 0 -8,000 Total EXPENSE CHARGED TO OTHER ACT $0 $-8,000 $0 $0 $0 $0 $-8,000 TOTAL FINANCE $59,290 $107,560 $128,520 $28,040 $13,480 $8,110 $345,000 24 1999 BUDGET 1999 1999 Pay With Title/Description Step 2%COL Inc FICA PERA Finance Director 8 $ 64,043 $ 4,899 $ 3,317 Accountant III 2 40,584 3,105 2,102 Payroll/Benefits Coord. 8 43,361 3,317 2,246 Accounting Clerk 8 33,346 2,551 1,727 Charge out Personnel N/A (17,344) (1,327) (898) Charge out Storm N/A (1,000) (77) (52) Charge out Sewer N/A (2,000) (153) (104) Total Finance $ 160,990 $ 12,315 $ 8,338 25 • CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: LEGAL ACTIVITY: The City currently contracts for civil legal services. Scott Joint Prosecution, a joint powers entity, provides prosecution of all non-felony criminal matters occurring in Shakopee. Civil legal services include: contracts, ordinance preparation, and review of departmental actions and policies. OBJECT DESCRIPTION: Description of lines items: Professional Services: This includes $140,000 for Scott Joint Prosecution, $75,000 for general civil work, and $50,000 for special outside consulting legal counsel. This provides the same amount this year to cover expected costs of litigation against the United States and Bureau of Indian Affairs. 26 CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 16 - LEGAL COUNSEL 4101 WAGES FT REG 77,580 0 0 0 0 0 4121 PERA 3,179 0 0 0 0 0 4122 FICA 5,908 0 0 0 0 0 4131 HEALTH & LIFE 3,232 0 0 0 0 0 4151 WORKERS COMPENSATION 493 0 0 0 0 0 4170 COMPENSATED ABSENCES -3,241 0 0 0 0 0 PERSONNEL SERVICES 87,152 0 0 0 0 0 4210 OPERATING SUPPLIES 679 922 0 0 0 0 4240 EQUIPMENT MAINTENANCE 264 0 0 0 0 0 4310 PROFESSIONAL SERVICES 118,893 238,988 250,000 113,462 265,000 265,000 4316 FILING FEES 374 0 0 0 0 0 4321 TELEPHONE 836 0 0 11 0 0 4330 TRAVEL/SUBSISTENCE 11 0 0 9 0 0 4350 PRINTING/PUBLISHING 95 1,028 0 236 500 500 4360 INSURANCE 3,426 4,532 2,500 0 2,500 2,500 4390 CONFERENCE/SCHOOL/TRAINING 381 0 0 0 0 0 4433 DUES 650 0 0 0 0 0 4435 SUBSCRIPTIONS/PUBLICATIONS 1,419 1,143 1,000 387 1,000 1,000 SUPPLIES & SERVICES 127,027 246,612 253,500 114,105 269,000 269,000 4800 EXPENSE CHARGED BACK -3,000 0 0 0 0 0 EXPENSE CHARGED TO OTHER ACT -3,000 0 0 0 0 0 TOTAL LEGAL COUNSEL DIVISION 211,180 246,612 253,500 114,105 269,000 269,000 27 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM 161 163 CIVIL PROSECUTIONS TOTAL LEGAL COUNSEL 4310 PROFESSIONAL SERVICES 125,000 140,000 265,000 4350 PRINTING/PUBLISHING 500 0 500 4360 INSURANCE 2,500 0 2,500 4435 SUBSCRIPTIONS/PUBLICATIONS 1,000 0 1,000 Total SUPPLIES & SERVICES $129,000 $140,000 $269,000 TOTAL LEGAL COUNSEL $129,000 $140,000 $269,000 0 CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: COMMUNITY DEVELOPMENT ACTIVITY: The Community Development Department is responsible for the physical development of the City. The department conducts both current and long- range planning functions, Management Information Services, and transit services. Management Information Services funds all of the operations/maintenance/replacement of the City's computer systems in City Hall, Police, Public Works and Fire (Recreation Dept. computers are now funded in the Recreation budget. ) Individual dept. budgets fund new equipment/significant upgrades/specialized applications. MIS funds system resources (including printers) , operating systems, equipment replacement, word processing, spreadsheet, database, presentation graphics and other "general use" applications. The MIS budgets also includes $100,000 to address "Year 2000" computer problems, as well as funding for the MIS Coordinator shared by the cities of Shakopee, Savage, and Prior Lake. The department coordinates the City's dial-a-ride, express bus and vanpool services. OBJECT DESCRIPTION: Description of lines items: Salaries: Community Development Director, Planner II, 2 Planner I's, Planning Technician, and Secretary. Salaries - Temp: Up to $1,200/year for seven commission members, totaling $8,400. Planning Intern and Planning Commission Recording Secretary, totaling $10,000. Total temporary salaries of $18,400 Supplies: MIS hardware and software ($46,980) Professional Services: GIS ($25,200) , new technology outreach (e.g. Internet, Web sites, etc. ) projects per City Council direction, and special area studies ($18,280) , totaling $43,480. MIS services ($41,000) . Proceeds from the lodging tax are used to support the Convention and Visitor's Bureau ($123,500) . Use of the funds are not under the control of the Community Development Department. Printing/Publishing: Comprehensive Plan publication, brochures, Zoning Ordinances, zoning maps, etc. Conference/School/Training: On-going professional training, GIS, MIS and new staff. Designated Miscellaneous: Year 2000 computer problems $100,000. Dues: Southwest Coalition $2,200, Minnesota APA $300. n Community Development Performance Measures: 1996 1997 1998 (Thru 8-5-98) Conditional Use Permits 23 35 25 Variances 5 8 3 Preliminary Plats 8 11 6 Final Plats 17 10 14 Preliminary/Final Plat 2 2 3 RLS 0 0 1 PUD's 6 4 4 Rezoning 3 11 3 Text Ammendments 10 21 7 Vacations 5 9 8 Comprhensive Plan Ammendments 1 2 0 EAW's 0 3 3 TOTAL LAND USE APPLICATIONS 80 116 77 Cost Ratio Program 174 : Number of Applications $1,540:1 $1,039:1 $1,127:1 n CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 17 - COMMUNITY DEVELOPMENT 4101 WAGES FT REG 139,398 174,924 193,180 95,225 224,080 224,080 4102 OVERTIME-FT 221 704 2,500 629 1,250 1,250 4110 WAGES - TEMP 4,198 17,312 13,180 7,262 18,400 18,400 4111 OVERTIME-TEMP 0 0 0 62 0 0 4121 PERA 5,608 7,669 10,810 4,896 11,670 11,670 4122 FICA 10,954 14,609 15,970 7,604 18,650 18,650 4131 HEALTH & LIFE 8,217 11,446 23,660 7,018 28,900 28,900 4142 UNEMPLOYMENT 0 1,658 0 0 0 0 4151 WORKERS COMPENSATION 1,368 1,873 2,000 0 2,000 2,000 4170 COMPENSATED ABSENCES -1,057 5,399 3,000 0 3,000 3,000 PERSONNEL SERVICES 168,907 235,594 264,300 122,696 307,950 307,950 4210 OPERATING SUPPLIES 11,076 16,968 24,000 12,553 70,010 70,010 4222 MOTOR FUELS & LUBRICANTS 67 0 100 0 0 0 4240 EQUIPMENT MAINTENANCE 5,301 8,520 6,600 703 6,600 6,600 4310 PROFESSIONAL SERVICES 138,114 142,602 164,500 55,847 227,660 227,660 4320 POSTAGE 0 0 0 0 1,400 1,400 4321 TELEPHONE 1,254 1,407 1,500 2,726 4,000 4,000 4330 TRAVEL/SUBSISTENCE 155 208 1,400 493 2,000 2,000 4350 PRINTING/PUBLISHING 3,677 1,737 1,000 1,617 2,000 2,000 4360 INSURANCE 4,047 4,489 4,200 0 4,200 4,200 4380 UTILITY SERVICE 0 0 18,000 0 0 0 4390 CONFERENCE/SCHOOL/TRAINING 1,079 1,715 6,000 1,380 5,500 5,500 4410 RENTALS 1,356 0 3,500 0 3,000 3,000 4430 DESIGNATED MISCELLANEOUS 0 0 0 0 100,000 100,000 4433 DUES 697 340 3,000 142 3,000 3,000 4435 SUBSCRIPTIONS/PUBLICATIONS 181 181 600 253 800 800 4438 SALES TAX 75 0 0 0 0 0 SUPPLIES & SERVICES 167,081 178,168 234,400 75,713 430,170 430,170 4550 EQUIPMENT 2,297 6,844 0 2,446 0 0 CAPITAL EXPENDITURES 2,297 6,844 0 2,446 0 0 4800 EXPENSE CHARGED BACK -6,000 -5,000 -6,000 0 -6,000 -6,000 EXPENSE CHARGED TO OTHER ACT -6,000 -5,000 -6,000 0 -6,000 -6,000 TOTAL COMMUNITY DEVELOPMENT DIVISION 332,285 415,605 492,700 200,855 732,120 732,120 3 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM 170 171 172 174 175 176 BENEFITS MGT MIS CURRENT LONG/RANGE CDC TOTAL COMMUNITY DEVELOPMENT 4101 WAGES FT REG 30,000 33,000 2,000 121,000 38,080 0 224,080 4102 OVERTIME-FT 0 0 0 1,250 0 0 1,250 4110 WAGES - TEMP 0 10,000 0 8,400 0 0 18,400 4121 PERA 1,550 1,710 110 6,330 1,970 0 11,670 4122 FICA 2,300 3,290 150 10,000 2,910 0 18,650 4131 HEALTH & LIFE 28,900 0 0 0 0 0 28,900 4151 WORKERS COMPENSATION 2,000 0 0 0 0 0 2,000 4170 COMPENSATED ABSENCES 3,000 0 0 0 0 0 3,000 Total PERSONNEL SERVICES $67,750 $48,000 $2,260 $146,980 $42,960 SO $307,950 4210 OPERATING SUPPLIES 0 23,030 46,980 0 0 0 70,010 4240 EQUIPMENT MAINTENANCE 0 2,570 4,030 0 0 0 6,600 4310 PROFESSIONAL SERVICES 0 9,680 41,000 43,480 10,000 123,500 227,660 4320 POSTAGE 0 1,400 0 0 0 0 1,400 4321 TELEPHONE 0 1,000 3,000 0 0 0 4,000 4330 TRAVEL/SUBSISTENCE 0 2,000 0 0 0 0 2,000 4350 PRINTING/PUBLISHING 0 2,000 0 0 0 0 2,000 4360 INSURANCE 0 4,200 0 0 0 0 4,200 4390 CONFERENCE/SCHOOL/TRAINING 0 2,500 3,000 0 0 0 5,500 4410 RENTALS 0 2,000 1,000 0 0 0 3,000 4430 DESIGNATED MISCELLANEOUS 0 0 100,000 0 0 0 100,000 4433 DUES 0 3,000 0 0 0 0 3,000 4435 SUBSCRIPTIONS/PUBLICATIONS 0 800 0 0 0 0 800 Total SUPPLIES & SERVICES $0 $54,180 $199,010 543,480 $10,000 $123,500 5430,170 4800 EXPENSE CHARGED BACK 0 -6,000 0 0 0 0 -6,000 Total EXPENSE CHARGED TO OTHER ACT SO $-6,000 SO $0 SO $0 $-6,000 TOTAL COMMUNITY DEVELOPMENT $67,750 $96,180 $201,270 $190,460 $52,960 $123,500 $732,120 32 \ , 1999 BUDGET 1999 1999 Pay With Title/Description Step 2% COL Inc FICA PERA CD Director 7 $ 60,840 $ 4,654 $ 3,152 Planner II 3 42,113 3,222 2,181 Planner I 4 37,477 2,867 1,941 Planner I 4 37,683 2,883 1,952 Planning Technician 2 27,392 2,095 1,419 Secretary 8 33,346 2,551 1,727 Charge out Transit N/A (11,736) (898) (608) Charge out EDA N/A (3,042) (233) (158) Total Comm Devlp $ 224,073 $ 17,141 $ 11,606 33 CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: GOVERNMENT BUILDING ACTIVITY: Activity includes the operation and maintenance of City Hall, Library, Eagle Creek Hall and Senior Citizen Center. OBJECT DESCRIPTION: Description of lines items: Salaries: 1 Custodian (20% charged to Recreation) . Building Maintenance: Contracted cleaning of Sr. Hi-Rise $3,200, City Mechanical Systems Contract $2,800 (all but City Hall and Civic Center) , Elevator Maintenance Contract $1,500, Contracted cleaning at City Hall and Library $15,000, Mechanical Systems Contract - City Hall only $10,800. City Hall roof repair $12,000; undesignated miscellaneous mechanical $10,000; Library trash receptacle enclosure $3,000. Professional Services: Pest Control $1,000 Rentals: Sr. Hi-Rise Congregated Dining Rental $11,490 and Building Rental Charges $70,580. 34 CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 18 - GENERAL GOVERNMENT BUILDINGS 4101 WAGES FT REG 28,465 15,615 18,160 6,603 18,390 18,390 4102 OVERTIME-FT 93 47 0 96 200 200 4121 PERA 1,068 702 940 346 960 960 4122 FICA 2,168 1,169 1,380 495 1,410 1,410 4131 HEALTH & LIFE 5,873 4,234 4,630 2,246 4,630 4,630 4151 WORKERS COMPENSATION 1,836 986 1,880 0 1,850 1,850 4170 COMPENSATED ABSENCES -2,820 943 500 0 500 500 PERSONNEL SERVICES 36,682 23,695 27,490 9,786 27,940 27,940 4210 OPERATING SUPPLIES 2,587 1,697 3,000 1,042 3,000 3,000 4230 BUILDING MAINT 16,556 62,387 40,300 11,145 65,700 65,700 4240 EQUIPMENT MAINTENANCE 2,507 1,371 2,500 227 2,500 2,500 4310 PROFESSIONAL SERVICES 10,950 6,821 2,500 1,527 3,500 3,500 4321 TELEPHONE 2,860 3,068 3,000 1,311 3,000 3,000 4330 TRAVEL/SUBSISTENCE 0 0 100 0 100 100 4360 INSURANCE 7,082 5,154 8,000 0 4,000 4,000 4380 UTILITY SERVICE 41,360 34,061 42,000 12,217 37,000 37,000 4410 RENTALS 11,481 11,481 13,000 6,697 82,070 82,070 SUPPLIES & SERVICES 95,382 126,038 114,400 34,166 200,870 200,870 4550 EQUIPMENT 0 0 12,000 0 0 0 CAPITAL EXPENDITURES 0 0 12,000 0 0 0 TOTAL GENERAL GOVERNMENT BUILDINGS DIVISION 132,065 149,733 153,890 43,952 228,810 228,810 35 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM 180 181 182 183 184 BENEFITS CITY HALL LIBRARY EC HALL SR CENTER TOTAL GENERAL GOVERNMENT BUILDINGS 4101 WAGES FT REG 3,500 11,590 2,500 0 800 18,390 4102 OVERTIME-FT 0 200 0 0 0 200 4121 PERA 180 600 130 0 50 960 4122 FICA 270 890 190 0 60 1,410 4131 HEALTH & LIFE 4,630 0 0 0 0 4,630 4151 WORKERS COMPENSATION 1,850 0 0 0 0 1,850 4170 COMPENSATED ABSENCES 500 0 0 0 0 500 Total PERSONNEL SERVICES $10,930 $13,280 $2,820 SO $910 $27,940 4210 OPERATING SUPPLIES 0 3,000 0 0 0 3,000 4230 BUILDING MAINT 0 44,500 18,000 0 3,200 65,700 4240 EQUIPMENT MAINTENANCE 0 2,500 0 0 0 2,500 4310 PROFESSIONAL SERVICES 0 1,000 0 0 2,500 3,500 4321 TELEPHONE 0 1,600 1,400 0 0 3,000 4330 TRAVEL/SUBSISTENCE 0 100 0 0 0 100 4360 INSURANCE 0 4,000 0 0 0 4,000 4380 UTILITY SERVICE 0 29,000 7,000 0 1,000 37,000 4410 RENTALS 0 65,660 4,180 740 11,490 82,070 Total SUPPLIES & SERVICES SO $151,360 $30,580 $740 $18,190 $200,870 TOTAL GENERAL GOVERNMENT BUILDINGS $10,930 $164,640 $33,400 $740 $19,100 $228,810 3 6 1999 BUDGET 1999 1999 Pay With Title/Description Step 2% COL Inc FICA PERA Custodian 8 $ 22,383 $ 1,712 $ 1,159 Charge out Park Rec N/A (4,000) (306) (207) Total Gen Govt Build $ 18,383 $ 1,406 $ 952 37 CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: POLICE ACTIVITY: The Shakopee Police Department is dedicated to protecting, serving and working with the public to promote and maintain a safe, peaceful community. Activity includes 24 hour a day, seven days per week of service to the community in rendering assistance, the protection of life and property, the preservation of public and order, the prevention and detection of crime, the apprehension of offenders, the regulation and control of traffic and the enforcement of the laws of the State of Minnesota and the City of Shakopee. OBJECT DESCRIPTION: Description of lines items: Salaries: Police Chief, Deputy Chief, Three Sergeants, Two Investigators, fifteen Officers, Three FTE Clerical, One 3/4 time Clerical. We are also requesting from Council an additional officer to serve on the Southwest Metro Drug Task Force. Supplies: Two radar sets @ $2,000 each, Security Holsters $2,500, Body Armor for the SIRT team $9,000, Rifles $3,600, Emergency First Aid equipment $2,000, sandbags $2,500, and two portable radio's $3,000. Building Maintenance: Cleaning contract $8,550, normal repairs $3,000, Preventive Maintenance $1,500. Rentals: Access fees to state and Federal computers $1,560, Equipment Rental $48,660, Mobile Display Terminals $7,780, Copy machine lease $2,400, and $4,300 in Building Rent. Professional Services: PEI and psychological exams $11,000, Animal Control $8,600, and the City portion of computer programmer analyst cooperative agreement $7,500. Capital Equipment: Two Civil Defense sirens $40,000 and updated computer equipment $29,000. Performance Measures 1996 1997 1998 Cost - Code Enforcement $ 5,966 $ 3,813 $10,890 Code Enforcement cases 128 157 Cost for Task Force $ 8,400 $ 8,400 $ 8,400 Drug Task Force Cases 21 n n CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 31 - POLICE 4101 WAGES FT REG 1,052,857 1,155,269 1,158,480 577,811 1,135,160 1,135,160 4102 OVERTIME-FT 51,828 57,245 46,910 27,018 60,000 60,000 4103 PREMIUM PAY 0 0 4,500 0 0 0 4110 WAGES - TEMP 5,362 3,447 9,650 1,694 10,000 10,000 4111 OVERTIME-TEMP 0 13 0 75 0 0 4121 PERA 114,801 123,686 132,470 56,394 122,070 122,070 4122 FICA 16,497 18,945 20,050 9,271 26,350 26,350 4131 HEALTH & LIFE 68,998 83,992 120,430 41,469 124,110 124,110 4151 WORKERS COMPENSATION 29,238 31,277 33,300 446 30,000 30,000 4170 COMPENSATED ABSENCES 19,264 -12,341 15,000 0 15,000 15,000 4171 RETIREMENT BENEFIT 0 7,679 0 0 0 0 PERSONNEL SERVICES 1,358,844 1,469,212 1,540,790 714,177 1,522,690 1,522,690 4210 OPERATING SUPPLIES 31,729 39,030 35,790 17,592 59,700 59,700 4222 MOTOR FUELS & LUBRICANTS 12,838 17,257 14,500 6,011 14,800 14,800 4230 BUILDING MAINT 16,932 12,012 19,050 5,098 13,050 13,050 4240 EQUIPMENT MAINTENANCE 19,633 23,776 20,500 9,670 20,900 20,900 4310 PROFESSIONAL SERVICES 19,689 14,762 19,730 15,721 27,100 27,100 4320 POSTAGE 1,253 1,242 1,450 800 1,500 1,500 4321 TELEPHONE 11,394 11,566 14,290 5,271 16,000 16,000 4330 TRAVEL/SUBSISTENCE 1,103 1,645 2,000 765 4,000 4,000 4350 PRINTING/PUBLISHING 1,783 4,682 3,500 668 2,750 2,750 4360 INSURANCE 22,559 25,424 26,500 292 26,250 26,250 4380 UTILITY SERVICE 14,206 13,507 12,000 5,399 13,300 13,300 4390 CONFERENCE/SCHOOL/TRAINING 7,290 10,314 9,040 3,134 15,000 15,000 4410 RENTALS 41,784 55,410 65,630 29,185 67,650 67,650 4430 DESIGNATED MISCELLANEOUS 8,400 8,400 8,400 6,300 8,400 8,400 4433 DUES 830 321 1,000 528 1,000 1,000 4435 SUBSCRIPTIONS/PUBLICATIONS 210 590 550 217 550 550 SUPPLIES & SERVICES 211,632 239,939 253,930 106,652 291,950 291,950 4550 EQUIPMENT 13,723 1,728 19,650 1,623 69,000 69,000 CAPITAL EXPENDITURES 13,723 1,728 19,650 1,623 69,000 69,000 TOTAL POLICE DIVISION 1,584,199 1,710,879 1,814,370 822,452 1,883,640 1,883,640 00 ..-'. ..1 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM PROGRAM PROGRAM PRGRM PRGRM PROGRM PROGRAM PROGRAM PROGRAM PROGRAM 310 311 312 313 314 315 318 319 351 361,317 316 BENEFTS MGT PATROL INVSTGT DARE COURT CUSTDN CD ENFR CVL DFN 357 0TH SCHOOL TOTAL = ____ POLICE 4101 WAGES FT REG 255000 252500 504660 102500 5000 1000 500 4,000 0 0 10,000 1,135,160 4102 OVERTIME-FT 0 5500 34000 3000 1500 5000 0 0 0 8,000 3,000 60,000 4110 WAGES - TEMP 0 0 0 0 0 0 0 10,000 0 0 0 10,000 4121 PERA 21500 20430 63940 11650 730 680 30 720 0 910 1,480 122,070 4122 FICA 4200 11180 7810 1530 100 90 50 1,080 0 120 190 26,350 4131 HEALTH & LIFE 124110 0 0 0 0 0 0 0 0 0 0 124,110 4151 WORKERS COMPENSATION 30000 0 0 0 0 0 0 0 0 0 0 30,000 4170 COMPENSATED ABSENCES 15000 0 0 0 0 0 0 0 0 0 0 15,000 Total PERSONNEL SERVICES $449810 $289610 $610410 $118680 $7330 $6770 $580 $15,800 SO $9,030 $14,670 $1,522,690 4210 OPERATING SUPPLIES 0 55700 0 0 0 0 0 0 2,500 1,500 0 59,700 4222 MOTOR FUELS & LUBRICANTS 0 800 12600 1400 0 0 0 0 0 0 0 14,800 4230 BUILDING MAINT 0 4500 0 0 0 0 8,550 0 0 0 0 13,050 4240 EQUIPMENT MAINTENANCE 0 12500 7000 0 0 0 0 0 1,400 0 0 20,900 4310 PROFESSIONAL SERVICES 0 18500 0 0 0 0 0 0 0 8,600 0 27,100 4320 POSTAGE 0 1500 0 0 0 0 0 0 0 0 0 1,500 4321 TELEPHONE 0 16000 0 0 0 0 0 0 0 0 0 16,000 4330 TRAVEL/SUBSISTENCE 0 4000 0 0 0 0 0 0 0 0 0 4,000 4350 PRINTING/PUBLISHING 0 2500 0 0 0 0 0 0 0 250 0 2,750 4360 INSURANCE 0 26000 0 0 0 0 0 0 0 250 0 26,250 4380 UTILITY SERVICE 0 12700 0 0 0 0 0 0 600 0 0 13,300 4390 CONFERENCE/SCHOOL/TRAINING 0 15000 0 0 0 0 0 0 0 0 0 15,000 4410 RENTALS 0 25900 39050 0 0 0 0 0 0 2,700 0 67,650 4430 DESIGNATED MISCELLANEOUS 0 8400 0 0 0 0 0 0 0 0 0 8,400 4433 DUES 0 1000 0 0 0 0 0 0 0 0 0 1,000 4435 SUBSCRIPTIONS/PUBLICATIONS 0 550 0 0 0 0 0 0 0 0 0 550 Total SUPPLIES & SERVICES $0 $205550 $58650 $1400 $0 $0 $8,550 SO $4,500 $13,300 $0 $291,950 4550 EQUIPMENT 0 29000 0 0 0 0 0 0 40,000 0 0 69,000 Total CAPITAL EXPENDITURES SO $29000 $0 SO $0 $0 $0 SO $40,000 SO $0 569,000 TOTAL POLICE $449810 $524160 $669060 $120080 $7330 $6770 $9,130 $15,800 $44,500 $22,330 $14,670 $1,883,640 4 0 1999 BUDGET 1999 1999 Pay With Title/Description Step 2% COL Inc FICA PERA Clerk Typist 13/4 Time 4 $ 18,927 $ 1,448 $ 980 Clerk Typist II 8 32,473 2,484 1,682 Clerk Typist II 8 33,266 2,545 1,723 Secretary 8 33,346 2,551 1,727 Police Chief 73,245 1,062 8,350 Deputy Chief 62,925 912 7,173 Police Investigator 49,497 718 5,643 Police Investigator 49,176 713 5,606 Police Sergeant 56,976 826 6,495 Police Sergeant 50,293 729 5,733 Police Sergeant 50,293 729 5,733 Police Officer 47,645 691 5,432 Police Officer 47,645 691 5,432 Police Officer 46,973 681 5,355 Police Officer 47,946 695 5,466 Police Officer 46,658 677 5,319 Police Officer 45,306 657 5,165 Police Officer 41,201 597 4,697 Police Officer 41,201 597 4,697 Police Officer 41,801 606 4,765 Police Officer 41,201 597 4,697 Police Officer 35,417 514 4,038 Police Officer 35,417 514 4,038 Police Officer 34,111 495 3,889 Police Officer 34,111 495 3,889 Police Officer 34,111 495 3,889 Premium Pay 4,000 58 456 Total Police $ 1,135,162 $ 23,777 $ 122,069 41 CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: FIRE ACTIVITY: Activity includes fire prevention, inspection, training, fire fighting hazardous material response and water and high level rescue. Maintenance of station and equipment on a 24-hour basis in order to insure the safety and protection of the City of Shakopee and Jackson and Louisville Townships. OBJECT DESCRIPTION: Description of lines items: Salaries - Temp 44 Fire Fighters. Supplies: Minor increase over 1998 for basic supplies. Increase includes Fire Fighting foam $2,000, upgrading radios $4,000, hose $5,000, high angle rescue equipment $1,500 and fire fighter protective clothing $10,000, SCBA bottle replacement (expiration) $10,000, and a Computer $2,200. Building Maintenance: Increased maintenance for station 12 from $4,000 to $7,000 to better reflect actual costs. Additional $18,000 to replace stucco on exterior of station #1. Equip. Maintenance: Increased by $5,000 to provide maintenance on aging SCBA (air Packs) , Tires $3,000. Telephone: Increased by $1,000 for lines and service for station #2 and the addition of a celluar phone. Insurance: Increased by $500. Utilities: Increased by $5,000 for station #2, to better reflect actual costs. Rentals: Equipment Rental increased by $51,541 with the addition of the two fire trucks and building rental of $61,250. Equipment: Purchase Carin's Iris for firefighters to see through smoke in a burning building to find victims, fire hotspots, escape routes, or other dangers to firefighters $28,000. 42 CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 32 - FIRE 4101 WAGES FT REG 197 870 2,210 359 1,000 1,000 4102 OVERTIME-FT 2,160 2,149 2,080 726 2,200 2,200 4110 WAGES - TEMP 88,989 87,864 136,720 29,646 131,820 131,820 4121 PERA 106 135 190 56 190 190 4122 FICA 1,467 1,496 2,340 509 2,220 2,220 4124 FIRE PENSION 42,385 39,854 12,120 0 0 0 4151 WORKERS COMPENSATION 5,273 4,725 6,760 0 5,000 5,000 PERSONNEL SERVICES 140,576 137,094 162,420 31,296 142,430 142,430 4210 OPERATING SUPPLIES 28,553 36,733 46,500 37,946 46,950 46,950 4222 MOTOR FUELS & LUBRICANTS 3,984 4,201 4,560 1,953 5,000 5,000 4230 BUILDING MAINT 3,598 16,053 10,000 1,181 28,000 28,000 4240 EQUIPMENT MAINTENANCE 24,012 30,852 24,000 5,189 25,000 25,000 4310 PROFESSIONAL SERVICES 4,772 10,010 5,120 1,134 6,200 6,200 4320 POSTAGE 0 64 110 29 120 120 4321 TELEPHONE 1,632 1,749 5,270 937 3,270 3,270 4330 TRAVEL/SUBSISTENCE 6,526 6,510 11,160 6,368 10,000 10,000 4350 PRINTING/PUBLISHING 0 1,127 980 495 1,000 1,000 4360 INSURANCE 15,320 20,336 31,080 2,602 22,000 22,000 4380 UTILITY SERVICE 12,121 10,907 28,000 4,810 32,000 32,000 4390 CONFERENCE/SCHOOL/TRAINING 5,608 8,097 5,400 7,034 7,700 7,700 4410 RENTALS 141,000 146,100 146,400 73,200 259,190 259,190 4433 DUES 645 485 1,040 350 1,040 1,040 4435 SUBSCRIPTIONS/PUBLICATIONS 40 25 520 85 520 520 SUPPLIES & SERVICES 247,810 293,249 320,140 143,313 447,990 447,990 4550 EQUIPMENT 2,765 3,608 4,300 1,585 28,000 28,000 CAPITAL EXPENDITURES 2,765 3,608 4,300 1,585 28,000 28,000 TOTAL FIRE DIVISION 391,152 433,951 486,860 176,194 618,420 618,420 43 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM PROGRAM 321 323 324 MGT FIRE CUSTODIAN FIRE STATION NO. 2 TOTAL FIRE 4101 WAGES FT REG 0 1,000 0 1,000 4102 OVERTIME-FT 2,200 0 0 2,200 4110 WAGES - TEMP 117,820 0 14,000 131,820 4121 PERA 130 60 0 190 4122 FICA 1,930 80 210 2,220 4151 WORKERS COMPENSATION 5,000 0 0 5,000 Total PERSONNEL SERVICES $127,080 $1,140 $14,210 $142,430 4210 OPERATING SUPPLIES 37,950 0 9,000 46,950 4222 MOTOR FUELS & LUBRICANTS 5,000 0 0 5,000 4230 BUILDING MAINT 21,000 0 7,000 28,000 4240 EQUIPMENT MAINTENANCE 25,000 0 0 25,000 4310 PROFESSIONAL SERVICES 6,200 0 0 6,200 4320 POSTAGE 120 0 0 120 4321 TELEPHONE 1,770 0 1,500 3,270 4330 TRAVEL/SUBSISTENCE 10,000 0 0 10,000 4350 PRINTING/PUBLISHING 1,000 0 0 1,000 4360 INSURANCE 16,300 0 5,700 22,000 4380 UTILITY SERVICE 12,000 0 20,000 32,000 4390 CONFERENCE/SCHOOL/TRAINING 7,700 0 0 7,700 4410 RENTALS 201,420 0 57,770 259,190 4433 DUES 1,040 0 0 1,040 4435 SUBSCRIPTIONS/PUBLICATIONS 520 0 0 520 Total SUPPLIES & SERVICES $347,020 SO $100,970 $447,990 4550 EQUIPMENT 28,000 0 0 28,000 Total CAPITAL EXPENDITURES $28,000 SO SO $28,000 TOTAL FIRE $502,100 $1,140 $115,180 $618,420 44 CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: INSPECTION BUILDING-PLUMBING-HEATING ACTIVITY: Enforcing all building codes and rules for both State and City for safety and code compliance of uniform building codes. OBJECT DESCRIPTION: Description of lines items: Salaries: Building Official, 2 Building Inspectors, and Secretary. Supplies: Permit software ($15,000) Equipment Maintenance: Three vehicles. Professional Services: Electrical Inspector $42,000, Consultant $2,000 Rentals: Equipment Rentals $3,710. Dues: ICBO $750 (250 each) 45 CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 33 - INSPECTION-BLDG-PLMBG-HTG 4101 WAGES FT REG 146,906 160,122 159,170 67,703 158,500 158,500 4102 OVERTIME-FT 139 32 0 115 0 0 4121 PERA 6,216 6,755 8,240 3,269 8,210 8,210 4122 FICA 11,222 12,225 12,170 5,143 12,130 12,130 4131 HEALTH & LIFE 6,235 8,173 19,200 3,652 19,300 19,300 4151 WORKERS COMPENSATION 1,094 1,298 2,000 0 1,500 1,500 4170 COMPENSATED ABSENCES 1,704 3,112 3,600 0 3,000 3,000 PERSONNEL SERVICES 173,517 191,718 204,380 79,881 202,640 202,640 4210 OPERATING SUPPLIES 4,501 2,472 10,470 1,508 18,000 18,000 4222 MOTOR FUELS & LUBRICANTS 1,176 1,582 1,750 485 1,500 1,500 4240 EQUIPMENT MAINTENANCE 871 1,046 2,000 304 2,000 2,000 4310 PROFESSIONAL SERVICES 40,710 42,369 32,000 16,381 44,000 44,000 4321 TELEPHONE 953 1,279 1,090 537 1,200 1,200 4330 TRAVEL/SUBSISTENCE 94 674 700 163 1,500 1,500 4350 PRINTING/PUBLISHING 1,788 1,283 1,600 434 1,500 1,500 4360 INSURANCE 2,324 3,075 3,200 -98 3,200 3,200 4390 CONFERENCE/SCHOOL/TRAINING 1,212 1,597 1,500 689 2,000 2,000 4410 RENTALS 1,860 2,508 1,960 1,260 3,710 3,710 4433 DUES 300 215 750 60 750 750 4435 SUBSCRIPTIONS/PUBLICATIONS 0 0 0 100 0 0 SUPPLIES & SERVICES 55,789 58,101 57,020 21,822 79,360 79,360 4550 EQUIPMENT 2,689 0 0 0 0 0 CAPITAL EXPENDITURES 2,689 0 0 0 0 0 TOTAL INSPECTION-BLDG-PLMBG-HTG DIVISION 231,995 249,818 261,400 101,703 282,000 282,000 4 .) N CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM 330 331 332 333 334 BENEFITS MGT PLAN REV BLDG INSP PLUB/HTG TOTAL INSPECTION-BLDG-PLMBG-HTG 4101 WAGES FT REG 25,000 50,370 34,550 27,460 21,120 158,500 4121 PERA 1,300 2,610 1,790 1,420 1,090 8,210 4122 FICA 1,910 3,860 2,640 2,100 1,620 12,130 4131 HEALTH & LIFE 19,300 0 0 0 0 19,300 4151 WORKERS COMPENSATION 1,500 0 0 0 0 1,500 4170 COMPENSATED ABSENCES 3,000 0 0 0 0 3,000 Total PERSONNEL SERVICES $52,010 $56,840 $38,980 $30,980 $23,830 $202,640 4210 OPERATING SUPPLIES 0 18,000 0 0 0 18,000 4222 MOTOR FUELS & LUBRICANTS 0 1,500 0 0 0 1,500 4240 EQUIPMENT MAINTENANCE 0 2,000 0 0 0 2,000 4310 PROFESSIONAL SERVICES 0 44,000 0 0 0 44,000 4321 TELEPHONE 0 1,200 0 0 0 1,200 4330 TRAVEL/SUBSISTENCE 0 1,500 0 0 0 1,500 4350 PRINTING/PUBLISHING 0 1,500 0 0 0 1,500 4360 INSURANCE 0 3,200 0 0 0 3,200 4390 CONFERENCE/SCHOOL/TRAINING 0 2,000 0 0 0 2,000 4410 RENTALS 0 3,710 0 0 0 3,710 4433 DUES 0 750 0 0 0 750 Total SUPPLIES & SERVICES $0 $79,360 $0 $0 $0 $79,360 TOTAL INSPECTION-BLDG-PLMBG-HTG $52,010 $136,200 $38,980 $30,980 $23,830 $282,000 47 1999 BUDGET 1999 1999 Pay With Title/Description Step 2%COL Inc FICA PERA Building Official 8 $ 46,383 $ 3,548 $ 2,403 Inspector 8 43,361 3,317 2,246 Inspector 2 35,412 2,709 1,834 Secretary 8 33,346 2,551 1,727 Total Inspections $ 158,502 $ 12,125 $ 8,210 • 48 CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: ENGINEERING 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, provide engineering assistance to Public Works Department, review technical engineering material and provide for City Council, City staff, City Commissions and Committees. OBJECT DESCRIPTION: Description of lines items: Salaries: 1 City Engineer (70%) , 1 Assistant City Engineer, 1 Project Coordinator, 4 Engineering Technicians, 1 Secretary, 2 Engineering Interns. • No additional full time employees are proposed in 1999 as the City Council authorized an addional Engineering Technician in 1998 with a budget amendment. • Overtime budget was increased in anticipation of future growth and with an additional Engineering Technician. Supplies: Includes computer software upgrades and licenses $5,000„ general office supplies $8,000, small tools $500, and computer hardware upgrades $2,500. Equipment Maintenance: Plotter & digitizer repair Professional Services: Transportation assistance $3,500, pavement management software support and training $3,000, Consultant inspectors and plan review as necessary $7,500, miscellaneous services $6,000. Telephone: Cellular phones for Inspectors. Conferences/School/Training: Inspection certification and Auto Cadd/computer training. Rentals: Equipment Rental of Vehicles. 49 CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 41 - ENGINEERING 4101 WAGES FT REG 250,558 270,166 276,720 131,218 318,380 318,380 4102 OVERTIME-FT 6,517 4,320 10,000 2,550 12,500 12,500 4110 WAGES - TEMP 9,645 7,573 15,600 291 13,000 13,000 4111 OVERTIME-TEMP 259 79 0 0 0 0 4121 PERA 10,944 11,795 15,540 6,616 17,010 17,010 4122 FICA 19,942 21,295 23,130 10,024 26,310 26,310 4131 HEALTH & LIFE 22,207 21,972 32,920 11,275 38,560 38,560 4151 WORKERS COMPENSATION 1,730 2,704 2,800 0 2,800 2,800 4170 COMPENSATED ABSENCES 676 4,580 4,000 0 4,000 4,000 PERSONNEL SERVICES 322,477 344,484 380,710 161,975 432,560 432,560 4210 OPERATING SUPPLIES 7,722 5,784 13,500 1,041 16,000 16,000 4222 MOTOR FUELS & LUBRICANTS 1,212 1,396 1,550 440 1,850 1,850 4240 EQUIPMENT MAINTENANCE 1,831 1,750 2,000 1,131 4,500 4,500 4310 PROFESSIONAL SERVICES 26,157 17,282 30,000 2,839 20,000 20,000 4321 TELEPHONE 2,867 3,931 5,000 1,912 6,000 6,000 4330 TRAVEL/SUBSISTENCE 236 19 750 27 1,000 1,000 4350 PRINTING/PUBLISHING 1,099 296 1,400 437 1,000 1,000 4360 INSURANCE 4,387 5,528 5,600 -78 5,700 5,700 4390 CONFERENCE/SCHOOL/TRAINING 44 912 2,500 309 3,500 3,500 4410 RENTALS 6,396 5,760 6,000 2,976 8,000 8,000 4433 DUES 530 305 750 480 750 750 4435 SUBSCRIPTIONS/PUBLICATIONS 229 160 250 82 250 250 4438 SALES TAX 221 0 0 0 0 0 SUPPLIES & SERVICES 52,930 43,123 69,300 11,595 68,550 68,550 4550 EQUIPMENT 3,529 3,104 0 0 0 0 CAPITAL EXPENDITURES 3,529 3,104 0 0 0 0 4800 EXPENSE CHARGED BACK -8,000 -8,000 -8,000 0 -8,000 -8,000 EXPENSE CHARGED TO OTHER ACT -8,000 -8,000 -8,000 0 -8,000 -8,000 TOTAL ENGINEERING DIVISION 370,937 382,711 442,010 173,570 493,110 493,110 50 , CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM PROGRAM PROGRAM 410 411 5500 5000 BENEFITS MGT PRIVATE DEVELPR PUBLIC PROJECTS TOTAL ENGINEERING 4101 WAGES FT REG 52,000 90,000 60,000 116,380 318,380 4102 OVERTIME-FT 0 0 6,250 6,250 12,500 4110 WAGES - TEMP 0 7,000 3,000 3,000 13,000 4121 PERA 2,570 4,660 3,430 6,350 17,010 4122 FICA 3,980 7,420 5,300 9,610 26,310 4131 HEALTH & LIFE 38,560 0 0 0 38,560 4151 WORKERS COMPENSATION 2,800 0 0 0 2,800 4170 COMPENSATED ABSENCES 4,000 0 0 0 4,000 Total PERSONNEL SERVICES $103,910 $109,080 $77,980 $141,590 $432,560 4210 OPERATING SUPPLIES 0 13,000 1,500 1,500 16,000 4222 MOTOR FUELS & LUBRICANTS 0 1,850 0 0 1,850 4240 EQUIPMENT MAINTENANCE 0 4,500 0 0 4,500 4310 PROFESSIONAL SERVICES 0 11,000 7,500 1,500 20,000 4321 TELEPHONE 0 3,500 2,500 0 6,000 4330 TRAVEL/SUBSISTENCE 0 1,000 0 0 1,000 4350 PRINTING/PUBLISHING 0 1,000 0 0 1,000 4360 INSURANCE 0 5,700 0 0 5,700 4390 CONFERENCE/SCHOOL/TRAINING 0 3,500 0 0 3,500 4410 RENTALS 0 8,000 0 0 8,000 4433 DUES 0 750 0 0 750 4435 SUBSCRIPTIONS/PUBLICATIONS 0 250 0 0 250 Total SUPPLIES & SERVICES $0 $54,050 $11,500 $3,000 $68,550 4800 EXPENSE CHARGED BACK 0 -8,000 0 0 -8,000 Total EXPENSE CHARGED TO OTHER ACT SO $-8,000 $0 SO S-8,000 TOTAL ENGINEERING $103,910 $155,130 $89,480 $144,590 5493,110 51 1999 BUDGET 1999 1999 Pay With Title/Description Step 2%COL Inc FICA PERA PW Director 6 $ 68,591 $ 5,247 $ 3,553 Assisst City Eng 8 49,406 3,780 2,559 Project Coordinator 8 46,383 3,548 2,403 Eng Tech IV 8 43,361 3,317 2,246 Eng Tech II 8 37,968 2,905 1,967 Eng Tech II 4 32,635 2,497 1,690 Eng Tech II 3 32,035 2,451 1,659 Secretary 8 33,346 2,551 1,727 Car Allowance N/A 2,400 184 124 Charge out Storm N/A (4,500) (344) (233) Charge out Sewer N/A (4,000) (306) (207) Charge out Street N/A (12,750) (975) (660) Charge out Park Maint N/A (6,500) (497) (337) Total Engineering $ 318,375 $ 24,358 $ 16,491 52 ' e r CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: STREET ACTIVITY: Street Department activities include street and alley maintenance and repair, street cleaning, snow removal, storm sewer and sanitary sewer maintenance, sign maintenance and parking lot maintenance (8 lots) . OBJECT DESCRIPTION: Description of lines items: Salaries: Director (20%) , Public Works Supervisor, 1 Lead Person, 6 Maintenance Workers. Salaries - Temp: Temporary seasonal employees - (2-summer, 1-winter) . Supplies: Striping $3,500, Signs $4,000, Computer $2,000, software for street, shop and parks operations $1,000, and various supplies. Materials: Includes $3,000 for dust coating, $9,000 for salt, $15,000 for sand and gravel, and $6,000 for bituminous mix. Building Maintenance: Replacement of one side door $1,500, miscellaneous $1,000. Equipment Maintenance Vehicle maintenance, replacement of tires on grader & loaders $6,000. Pavement Preservation: Crack Sealing $10,000, Seal Coating $45,000, Overlays & Patching $40,000, Sidewalk replacement $5,000. Telephone: Network connection phone line to City Hall computer and cellular phone for Public Works Supervisor. Professional Services: Includes Paint Striping $8,000, Gopher State One Call $1,500, Building Expansion Analysis Study $3,000, Drug Testing $1,500, Street sweeping recycling $3,000, cleaning services $2,000, stump grinding $1,500, and $5,000 miscellaneous services. Utility Service: Utilities - includes street lights $113,000 ($49,000 SPUC) . Operating costs on Traffic control signal systems on County and State Highways (Vierling Drive & Marschall Road - new signal) . Replacement of street lights in Downtown area (SPUC) $5,000. Rentals: Equipment Rental $129,870, rental of mill attachement $1,230. 53 r Street Performance Measures: 1996 1997 Road miles 89.9 94.7 Lane miles plowed Cost 122,062 99,460 Cost per lane mile 54 CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 42 - STREET MAINTENANCE 4101 WAGES FT REG 194,294 211,492 213,660 109,837 206,790 206,790 4102 OVERTIME-FT 14,481 9,822 18,000 18,167 22,000 22,000 4110 WAGES - TEMP 4,029 6,730 5,500 147 10,500 10,500 4111 OVERTIME-TEMP 0 71 0 634 0 0 4121 PERA 9,319 9,086 11,840 6,206 11,850 11,850 4122 FICA 15,706 16,551 18,150 9,211 18,300 18,300 4131 HEALTH & LIFE 28,462 27,384 37,210 12,578 38,560 38,560 4142 UNEMPLOYMENT 0 122 0 209 0 0 4151 WORKERS COMPENSATION 10,171 8,894 9,500 500 9,500 9,500 4170 COMPENSATED ABSENCES 4,146 -4,747 4,000 0 4,000 4,000 4171 RETIREMENT BENEFIT 0 0 6,000 0 6,000 6,000 PERSONNEL SERVICES 280,607 285,406 323,860 157,489 327,500 327,500 4210 OPERATING SUPPLIES 19,384 21,129 24,800 12,630 26,300 26,300 4215 MATERIALS 18,169 29,558 32,000 9,232 33,000 33,000 4222 MOTOR FUELS & LUBRICANTS 17,850 16,437 20,000 9,083 20,000 20,000 4230 BUILDING MAINT 1,367 4,436 2,500 2,099 3,000 3,000 4240 EQUIPMENT MAINTENANCE 21,697 22,600 24,000 12,596 31,000 31,000 4242 PAVEMENT PRESERVATION 70,718 67,632 100,000 1,650 100,000 100,000 4310 PROFESSIONAL SERVICES 48,891 28,017 28,000 3,532 23,500 23,500 4320 POSTAGE 0 0 100 963 500 500 4321 TELEPHONE 2,588 2,816 3,000 1,190 4,250 4,250 4330 TRAVEL/SUBSISTENCE 15 0 500 7 250 250 4350 PRINTING/PUBLISHING 289 0 300 0 300 300 4360 INSURANCE 17,694 21,054 19,000 0 21,700 21,700 4380 UTILITY SERVICE 110,551 104,413 116,500 22,982 118,000 118,000 4390 CONFERENCE/SCHOOL/TRAINING 220 467 3,500 469 3,000 3,000 4410 RENTALS 110,304 108,007 129,770 70,115 131,100 131,100 4433 DUES 560 585 750 468 750 750 4435 SUBSCRIPTIONS/PUBLICATIONS 96 246 0 258 300 300 SUPPLIES & SERVICES 440,395 427,394 504,720 147,272 516,950 516,950 4550 EQUIPMENT 0 2,309 0 0 0 0 CAPITAL EXPENDITURES 0 2,309 0 0 0 0 TOTAL STREET MAINTENANCE DIVISION 721,002 715,109 828,580 304,761 844,450 844,450 55 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRM 420 421 422 423 424 426 427 428 429 BENEFITS MGT TR/WD P STRPNG SNW & S EQP MNT STRT MNT SEAL CT CUSTDN TOTAL STREET MAINTENANCE 4101 WAGES FT REG 54,000 40,290 22,000 10,000 45,000 2,500 30,000 1,000 2,000 206,790 4102 OVERTIME-FT 0 2,000 0 0 13,000 0 7,000 0 0 22,000 4110 WAGES - TEMP 0 4,000 1,000 1,000 2,000 0 2,500 0 0 10,500 4121 PERA 2,800 2,190 1,140 520 3,000 130 1,920 50 100 11,850 4122 FICA 4,130 3,540 1,760 840 4,590 190 3,020 80 150 18,300 4131 HEALTH & LIFE 38,560 0 0 0 0 0 0 0 0 38,560 4151 WORKERS COMPENSATION 9,500 0 0 0 0 0 0 0 0 9,500 4170 COMPENSATED ABSENCES 4,000 0 0 0 0 0 0 0 0 4,000 4171 RETIREMENT BENEFIT 6,000 0 0 0 0 0 0 0 0 6,000 Total PERSONNEL SERVICES $118,990 $52,020 $25,900 $12,360 $67,590 $2,820 $44,440 $1,130 $2,250 $327,500 4210 OPERATING SUPPLIES 0 8,800 2,500 7,500 1,500 500 5,000 0 500 26,300 4215 MATERIALS 0 0 0 0 15,000 0 18,000 0 0 33,000 4222 MOTOR FUELS & LUBRICANTS 0 20,000 0 0 0 0 0 0 0 20,000 4230 BUILDING MAINT 0 3,000 0 0 0 0 0 0 0 3,000 4240 EQUIPMENT MAINTENANCE 0 0 0 0 0 31,000 0 0 0 31,000 4242 PAVEMENT PRESERVATION 0 5,000 0 0 0 0 50,000 45,000 0 100,000 4310 PROFESSIONAL SERVICES 0 7,500 3,000 8,000 0 0 3,000 0 2,000 23,500 4320 POSTAGE 0 500 0 0 0 0 0 0 0 500 4321 TELEPHONE 0 4,250 0 0 0 0 0 0 0 4,250 4330 TRAVEL/SUBSISTENCE 0 250 0 0 0 0 0 0 0 250 4350 PRINTING/PUBLISHING 0 300 0 0 0 0 0 0 0 300 4360 INSURANCE 0 21,700 0 0 0 0 0 0 0 21,700 4380 UTILITY SERVICE 0 32,000 0 0 0 0 86,000 0 0 118,000 4390 CONFERENCE/SCHOOL/TRAINING 0 3,000 0 0 0 0 0 0 0 3,000 4410 RENTALS 0 131,100 0 0 0 0 0 0 0 131,100 4433 DUES 0 750 0 0 0 0 0 0 0 750 4435 SUBSCRIPTIONS/PUBLICATIONS 0 300 0 0 0 0 0 0 0 300 Total SUPPLIES & SERVICES $0 $238,450 $5,500 $15,500 $16,500 $31,500 $162,000 545,000 $2,500 $516,950 TOTAL STREET MAINTENANCE $118,990 $290,470 $31,400 $27,860 $84,090 $34,320 $206,440 $46,130 $4,750 $844,450 58 1999 BUDGET 1999 1999 Pay With Title/Description Step 2%COL Inc FICA PERA PW Supervisor 3 $ 39,647 $ 3,033 $ 2,054 Street Leadperson 8 37,968 2,905 1,967 Maintenance Worker 8 33,346 2,551 1,727 Maintenance Worker 8 33,346 2,551 1,727 Maintenance Worker 6 30,567 2,338 1,583 Maintenance Worker 4 28,821 2,205 1,493 Maintenance Worker 2 27,233 2,083 1,411 Maintenance Worker 3 28,106 2,150 1,456 Charge out Storm N/A (40,000) (3,060) (2,072) Charge out Sewer N/A (25,000) (1,913) (1,295) Charge out Park Maint N/A (10,500) (803) (544) Charge in Park Maint N/A 10,500 803 544 Charge in Engineering N/A 12,750 975 660 Total Street $ 206,784 $ 15,818 $ 10,711 57 CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: SHOP ACTIVITY: The City Mechanic does the technical repair of all City equipment including staff cars, street and park vehicles and equipment, squad cars and SPDC vehicles and equipment. The mechanic repairs the equipment and bills the parts and labor to the respective departments. OBJECT DESCRIPTION: Description of lines items: Salaries: 2 Mechanics and 1 temporary employee from School Employment Program. Supplies: Computer software $1,000 for equipment maintenance and parts inventory, tools, various shop supplies, and upgrades for computerized equipment. Capital Expenditures: Bearing Press $3,500 Professional Services: Misc. as needed Rentals: Building Rental $8,460. Performance Measures: 1996 1997 Number of vehicles maintained 46 47 Cost of Shop Division 103,776 121,242 Average cost per vehicle 2,256 2,580 58 CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 44 - SHOP 4101 WAGES FT REG 60,221 65,233 69,120 29,020 72,500 72,500 4102 OVERTIME-FT 915 481 2,000 872 2,000 2,000 4110 WAGES - TEMP 246 3,159 3,750 2,017 7,500 7,500 4111 OVERTIME-TEMP 10 10 0 0 0 0 4121 PERA 2,728 2,944 3,870 1,545 3,860 3,860 4122 FICA 4,603 5,050 5,740 2,344 6,270 6,270 4131 HEALTH & LIFE 8,096 8,592 9,260 4,543 9,640 9,640 4151 WORKERS COMPENSATION 2,299 2,443 2,500 0 2,500 2,500 4170 COMPENSATED ABSENCES 790 1,006 1,800 0 1,500 1,500 PERSONNEL SERVICES 79,907 88,918 98,040 40,341 105,770 105,770 4210 OPERATING SUPPLIES 10,867 10,193 10,500 5,254 12,000 12,000 4230 BUILDING MAINT 2,214 16,105 3,500 1,253 3,000 3,000 4240 EQUIPMENT MAINTENANCE 3,714 7,186 6,000 586 8,000 8,000 4250 MERCHANDISE 0 0 0 -2,821 0 0 4310 PROFESSIONAL SERVICES 3,444 143 1,000 58 1,500 1,500 4360 INSURANCE 1,096 1,283 1,400 0 1,350 1,350 4380 UTILITY SERVICE 0 100 0 50 100 100 4390 CONFERENCE/SCHOOL/TRAINING 0 315 750 0 750 750 4410 RENTALS 107 0 0 0 8,460 8,460 4433 DUES 0 0 200 0 100 100 SUPPLIES & SERVICES 21,442 35,324 23,350 4,381 35,260 35,260 4550 EQUIPMENT 5,427 0 4,500 0 3,500 3,500 CAPITAL EXPENDITURES 5,427 0 4,500 0 3,500 3,500 TOTAL SHOP DIVISION 106,776 124,242 125,890 44,722 144,530 144,530 59 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM PROGRAM 440 441 443 444 445 446 447 BENEFITS MGT STREET PARK POLICE ADMIN SPUC TOTAL SHOP 4101 WAGES FT REG 9,000 7,000 33,000 13,000 7,000 2,500 1,000 72,500 4102 OVERTIME-FT 0 0 1,000 1,000 0 0 0 2,000 4110 WAGES - TEMP 0 3,500 2,000 1,000 1,000 0 0 7,500 4121 PERA 470 360 1,760 730 360 130 50 3,860 4122 FICA 690 800 2,750 1,150 610 190 80 6,270 4131 HEALTH & LIFE 9,640 0 0 0 0 0 0 9,640 4151 WORKERS COMPENSATION 2,500 0 0 0 0 0 0 2,500 4170 COMPENSATED ABSENCES 1,500 0 0 0 0 0 0 1,500 Total PERSONNEL SERVICES $23,800 $11,660 $40,510 $16,880 $8,970 $2,820 $1,130 $105,770 4210 OPERATING SUPPLIES 0 12,000 0 0 0 0 0 12,000 4230 BUILDING MAINT 0 3,000 0 0 0 0 0 3,000 4240 EQUIPMENT MAINTENANCE 0 8,000 0 0 0 0 0 8,000 4310 PROFESSIONAL SERVICES 0 1,500 0 0 0 0 0 1,500 4360 INSURANCE 0 1,350 0 0 0 0 0 1,350 4380 UTILITY SERVICE 0 100 0 0 0 0 0 100 4390 CONFERENCE/SCHOOL/TRAINING 0 750 0 0 0 0 0 750 4410 RENTALS 0 8,460 0 0 0 0 0 8,460 4433 DUES 0 100 0 0 0 0 0 100 Total SUPPLIES & SERVICES $0 535,260 $0 SO $0 $0 $0 $35,260 4550 EQUIPMENT 0 3,500 0 0 0 0 0 3,500 Total CAPITAL EXPENDITURES $0 $3,500 SO SO SO SO $0 $3,500 TOTAL SHOP $23,800 $50,420 540,510 $16,880 $8,970 $2,820 $1,130 $144,530 6 ) 1 , 1999 BUDGET 1999 1999 Pay With Title/Description Step 2%COL Inc FICA PERA Mechanic 8 $ 37,065 $ 2,835 $ 1,920 Mechanic 6 35,438 2,711 1,836 Total Shop $ 72,503 $ 5,546 $ 3,756 61 CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: PARK MAINTENANCE ACTIVITY: The care and maintenance of 12 developed parks (154 acres) and shelter buildings. The Park department also maintains the ice and hockey rinks during the winter. Murphy's Landing City maintenance is under the Parks Division. The total acreage of the park system for maintenance is 407 acres. OBJECT DESCRIPTION: Description of lines items: Salaries: Director (10%) , 1 Lead Person, 3 Maintenance Workers. Salaries - Temp: Temporary employees - (5 summer, 1 winter) . Supplies: Flower planting $3,000, Murphy's Landing $1,000, hockey rink replacement $800, miscellaneous $7,000. Materials: Trees $20,000,. Sod $500, ballfield aggregate $3,000, fertilizer $1,000, and weed killer $1,000. Building Maintenance: Painting of buildings $1,000, Insulation of Old Bubble building $2,000, Holmes Park building rest room repairs $3,500, miscellaneous $3,500. Equipment Maintenance: Vehicle maintenance. Pavement Preservation: Trail Maintenance $5,000, Parking Lot $5,000. Professional Services: Includes satellites for ball fields $3,000, ball field fence replacement $6,000, service work for Murphy's Landing $2,000, tree trimming and disposal $1,000, contract cleaning of Community Youth Building $3,000, rekeying locks $1,000, Sentence to Service $2,000, and miscellaneous $4,000. Utility Service: Gas, electric, telephone for park buildings. Also Murphy's Landing utility service per agreement. Rentals: Equipment Rental $39,500 and buildin rental $2,310. Capital Expenditures: Athletic Field Groomer $3,500, Top Dresser (Turf Management) $6,000, and playground equipment $30,000. 62 _ 1_ 4 Performance Measures: 1996 1997 Number of rinks 9 9 Cost of rinks Average cost per rink Number of athletic fields 22 22 Cost of field maintenance Average cost per field 61 CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 46 - PARK MAINTENANCE 4101 WAGES FT REG 122,743 128,556 132,600 68,631 133,410 133,410 4102 OVERTIME-FT 3,267 3,090 7,000 2,086 7,000 7,000 4110 WAGES - TEMP 9,215 17,114 20,700 6,222 21,000 21,000 4111 OVERTIME-TEMP 0 61 0 665 0 0 4121 PERA 5,511 5,661 8,300 3,530 7,280 7,280 4122 FICA 9,587 10,234 12,260 5,168 12,340 12,340 4131 HEALTH & LIFE 11,416 12,043 18,860 8,867 19,280 19,280 4151 WORKERS COMPENSATION 2,698 3,159 3,300 46 3,400 3,400 4170 COMPENSATED ABSENCES -3,778 1,351 2,500 0 2,500 2,500 4171 RETIREMENT BENEFIT 0 5,726 0 0 0 0 PERSONNEL SERVICES 160,658 186,995 205,520 95,214 206,210 206,210 4210 OPERATING SUPPLIES 8,509 14,223 14,000 7,608 11,800 11,800 4215 MATERIALS 496 2,271 5,500 1,038 25,500 25,500 4222 MOTOR FUELS & LUBRICANTS 3,328 4,192 5,000 1,655 5,000 5,000 4230 BUILDING MAINT 4,279 6,141 8,000 7,015 10,000 10,000 4240 EQUIPMENT MAINTENANCE 24,783 17,774 23,000 7,105 22,000 22,000 4242 PAVEMENT PRESERVATION 7,370 0 10,000 0 10,000 10,000 4310 PROFESSIONAL SERVICES 5,614 2,732 15,700 1,517 16,000 16,000 4321 TELEPHONE 332 521 400 158 600 600 4350 PRINTING/PUBLISHING 0 0 0 170 0 0 4360 INSURANCE 5,832 7,763 7,100 0 15,500 15,500 4380 UTILITY SERVICE 41,413 43,403 46,500 13,101 45,000 45,000 4390 CONFERENCE/SCHOOL/TRAINING 60 0 1,500 784 1,700 1,700 4410 RENTALS 19,925 29,527 35,620 19,264 41,810 41,810 4433 DUES 0 10 100 131 150 150 SUPPLIES & SERVICES 121,941 128,555 172,420 59,545 205,060 205,060 4550 EQUIPMENT 0 0 0 0 39,500 39,500 CAPITAL EXPENDITURES 0 0 0 0 39,500 39,500 TOTAL PARK MAINTENANCE DIVISION 282,599 315,551 377,940 154,759 450,770 450,770 6 4 • CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRM PROGRAM PROGRM PROGRM PROGRM PROGRM PROGRM PRGRM PROGRM PROGRM PROGRM PROGRAM 620 621 622 623 624 625 626 627 628 629 630 631 BENFTS MGT MAINT MW/TRM ATH FL ECP/VH RINKS SNOW BLD/PP TR/SCP CUSTDN MRPHY'S TOTAL PARK MAINTENANCE 4101 WAGES FT REG 26000 22000 25000 7500 16000 800 9000 3200 17210 4000 1,200 1,500 133,410 4102 OVERTIME-FT 0 0 1000 1000 1500 0 1000 1500 0 0 0 1,000 7,000 4110 WAGES - TEMP 0 500 3000 6000 4500 500 0 1500 1000 1000 0 3,000 21,000 4121 PERA 1350 1140 1350 440 910 40 520 240 890 210 60 130 7,280 4122 FICA 1990 1720 2220 1110 1680 100 770 470 1390 380 90 420 12,340 4131 HEALTH & LIFE 19280 0 0 0 0 0 0 0 0 0 0 0 19,280 4151 WORKERS COMPENSATION 3400 0 0 0 0 0 0 0 0 0 0 0 3,400 4170 COMPENSATED ABSENCES 2500 0 0 0 0 0 0 0 0 0 0 0 2,500 Total PERSONNEL SERVICES $54520 $25360 $32570 $16050 $24590 $1440 $11290 $6910 $20490 $5590 $1,350 $6,050 $206,210 4210 OPERATING SUPPLIES 0 4500 2500 0 3000 0 800 0 0 0 0 1,000 11,800 4215 MATERIALS 0 0 2500 0 3000 0 0 0 0 20000 0 0 25,500 4222 MOTOR FUELS & LUBRICANTS 0 5000 0 0 0 0 0 0 0 0 0 0 5,000 4230 BUILDING MAINT 0 500 1000 0 0 0 0 0 6500 0 2,000 0 10,000 4240 EQUIPMENT MAINTENANCE 0 0 500 0 4000 14000 0 0 3500 0 0 0 22,000 4242 PAVEMENT PRESERVATION 0 10000 0 0 0 0 0 0 0 0 0 0 10,000 4310 PROFESSIONAL SERVICES 0 4000 0 0 6000 0 0 0 0 1000 3,000 2,000 16,000 4321 TELEPHONE 0 600 0 0 0 0 0 0 0 0 0 0 600 4360 INSURANCE 0 15500 0 0 0 0 0 0 0 0 0 0 15,500 4380 UTILITY SERVICE 0 0 4000 0 3000 0 0 0 33000 0 0 5,000 45,000 4390 CONFERENCE/SCHOOL/TRAINING 0 1700 0 0 0 0 0 0 0 0 0 0 1,700 4410 RENTALS 0 39500 0 0 0 0 0 0 2310 0 0 0 41,810 4433 DUES 0 150 0 0 0 0 0 0 0 0 0 0 150 Total SUPPLIES & SERVICES $0 $81450 $10500 $0 $19000 $14000 $800 SO $45310 $21000 $5,000 $8,000 $205,060 4550 EQUIPMENT 0 0 36000 0 3500 0 0 0 0 0 0 0 39,500 Total CAPITAL EXPENDITURES $0 SO $36000 $0 $3500 $0 SO SO $0 $0 SO $0 $39,500 TOTAL PARK MAINTENANCE $54520 $106810 $79070 $16050 $47090 $15440 $12090 $6910 $65800 $26590 $6,350 $14,050 $450,770 13.a 4 . p 1999 BUDGET 1999 1999 Pay With Title/Description Step 2%COL Inc FICA PERA Park Leadperson 8 $ 37,968 $ 2,905 $ 1,967 Maintenance Worker 8 33,346 2,551 1,727 Maintenance Worker 8 33,346 2,551 1,727 Maintenance Worker 5 30,250 , 2,314 1,567 Charge out Pool N/A (8,000) (612) (414) Charge out Street N/A (10,500) (803) (544) Charge in Street N/A 10,500 803 544 Charge in Engineering N/A 6,500 497 337 Total Park Maintenance $ 133,410 $ 10,206 $ 6,911 131.3 4 ., w CITY OF SHAKOPEE 1999 GENERAL FUND BUDGET DIVISION: UNALLOCATED ACTIVITY: This division accounts for the ambulance service contribution, general liability insurance not charged to other departments/funds and other costs not readily chargeable to other departments. OBJECT DESCRIPTION: Description of lines items: Insurance: General Insurance $15,000 Property Tax/Special Assessments: Taxes and Special Assessments on City property. Council has elected to pay off special assessments against city property over ten years out of the General Fund. $105,580 Contingency: Contingency appropriation for the General Fund $50,000. Additional wage increases 1% $34,000, reclassifications and new positions $134,080, and a police technology grant $12,000. Designated Miscellaneous: ADC tax payment - Local Effort "TIF" $75,000 Interfund Operating Transfers: Operating Transfers Recreation Fund $333,050. 67 • CITY OF SHAKOPEE 1999 BUDGET Division Budget Object 12/31/96 12/31/97 12/31/98 Y-T-D DEPARTMENT PROPOSED Code Description ACTUAL ACTUAL BUDGET 06/30/98 REQUEST BUDGET DIVISION 91 - UNALLOCATED 4151 WORKERS COMPENSATION 0 0 0 54,107 0 0 PERSONNEL SERVICES 0 0 0 54,107 0 0 4210 OPERATING SUPPLIES 0 -107 0 2,260 0 0 4350 PRINTING/PUBLISHING 0 -107 0 -1,269 0 0 4360 INSURANCE 4,985 900 15,000 0 15,000 15,000 4430 DESIGNATED MISCELLANEOUS 0 0 0 250,000 75,000 75,000 4431 CASH SHORT/OVER 0 1 0 0 0 0 4437 PROPERTY TAX/SPECIAL ASSESS 14,117 65,943 97,790 52,031 105,580 105,580 4438 SALES TAX 277 0 0 0 0 0 4490 CONTINGENCY 829 24,093 81,350 9,187 50,000 50,000 4491 CONTINGENCY - DESIGNATED 0 0 0 0 180,080 180,080 SUPPLIES & SERVICES 20,209 90,722 194,140 312,210 425,660 425,660 4720 INTERFUND OPERATING TRANSFERS 251,340 301,140 332,690 0 333,050 333,050 4721 OPERATING TRANSFER/DEBT SERV 193,371 300,989 0 0 0 0 4722 OPERATING TRANSFER/CAPITAL FD 218,885 1,719,473 0 0 0 0 TRANSFERS OUT 663,596 2,321,602 332,690 0 333,050 333,050 TOTAL UNALLOCATED DIVISION 683,805 2,412,324 526,830 366,317 758,710 758,710 6 9 A • CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM 911 MGT TOTAL UNALLOCATED 4360 INSURANCE 15,000 15,000 4430 DESIGNATED MISCELLANEOUS 75,000 75,000 4437 PROPERTY TAX/SPECIAL ASSESS 105,580 105,580 4490 CONTINGENCY 50,000 50,000 4491 CONTINGENCY - DESIGNATED 180,080 180,080 Total SUPPLIES & SERVICES $425,660 $425,660 4720 INTERFUND OPERATING TRANSFERS 333,050 333,050 Total TRANSFERS OUT $333,050 $333,050 TOTAL UNALLOCATED $758,710 $758,710 69