The URL can be used to link to this page

Home My WebLink About08/20/1998 TENTATIVE AGENDA CITY OF SHAKOPEE ADJ. REGULAR SESSION SHAKOPEE, MINNESOTA AUGUST 20, 1998 LOCATION: 129 Holmes Street South Mayor Jon Brekke presiding 1] Roll Call at 4:00 p.m. 2] Approval of Agenda 3] 1999 Budget discussion-bring budget materials from the August 13, 1998, agenda packet 4] Other Business 5] Adjourn to Thursday,August 27, 1998 at 4:00 p.m. # 3 SPECIAL REVENUE FUNDS Special Revenue Funds are used to account for the proceeds of specific revenue sources designated to finance particular activities as required by law or administrative regulation. Established in 1984, the Transit Fund accounts for the van pools and Bial- a-ride services provided by the City after opting out of the Metropolitan Transit Commission's service. Economic Development Authority Fund accounts for the activities of that body. 1 CITY OF SHAKOPEE 1999 BUDGET SPECIAL REVENUE FUNDS BUDGET SUMMARY Transit EDA Total Revenue Taxes $ 340,630 $108,700 $ 449,330 Intergovernmental 90,000 $ 5,400 95,400 Charges for Service 70,000 70,000 Miscellaneous - Interest 22,000 22,000 Total Revenue 500,630 136,100 636,730 Expenditures and Transfers Genral Government 145,970 145,970 Public Works 500,630 500,630 Total Expenditures 500,630 145,970 646,600 Excess (Deficiency) Of Revenues over Expenditures &Transfers $ - $ (9,870) (9,870) Fund Balance $ 156,204 $397,222 553,426 2 TRANSIT FUND 1999 BUDGET ACTIVITY: The transit system began operation in September of 1984. Subsidy is provided under contract with RTB. Service is comprised of van pools for trips outside of Shakopee and a dial-a-ride service for internal trips. Express route bus service to Eden Prairie Center and Downtown Minneapolis is also provided twice daily during peak A.M. and P.M. travel times. Private carriers provide the service and are under contract with the City. City Staff monitors the contract. OBJECT DESCRIPTION: Description of lines items: Salaries: Share of City Staff. Utilities: Contracts with transit providers. 3 CITY OF SHAKOPEE, MINNESOTA 1999 BUDGET TRANSIT FUND BUDGET SUMMARY 1996 1997 1998 1999 Actual Actual Proposed Proposed Revenue Property Taxes $285,833 $ 340,630 State Aid 393,734 83,263 440,380 90,000 State Grants 179,596 - Fares 66,999 63,501 71,150 70,000 Interest 3,610 - Total Revenue 460,733 615,803 511,530 500,630 Expenditures Personal Services 1,712 1,458 5,505 13,250 Supplies & Services 459,021 460,794 506,025 487,380 Capital - - - Total Expenditures 460,733 462,252 511,530 500,630 Excess (Deficiency) Of Revenues over Expenditures &Transfers $ - $ 153,551 $ - $ - Fund Balance $ 2,653 $ 156,204 $ 156,204 $ 156,204 Note: The $257,000 in 1997 revenues as State Aid is a 1 time carryover of funds from Met Council for$205,000 and Private Vehicle Capital payments from the RTB for$52,000. 4 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 1,527 1,302 5,010 1,832 11,740 11,740 4121 PERA 68 58 270 95 610 610 4122 FICA 116 98 390 131 900 900 PERSONNEL SERVICES 1,712 1,458 5,670 2,058 13,250 13,250 4210 OPERATING SUPPLIES 0 337 1,500 300 1,500 1,500 4222 MOTOR FUELS & LUBRICANTS 16,146 16,921 20,000 0 0 0 4310 PROFESSIONAL SERVICES 33,275 37,765 25,000 15,518 27,500 27,500 4330 TRAVEL/SUBSISTENCE 97 0 100 0 100 100 4340 ADVERTISING 3,031 1,493 3,090 469 3,090 3,090 4350 PRINTING/PUBLISHING 358 179 1,800 43 1,000 1,000 4360 INSURANCE 300 680 0 0 0 0 4380 UTILITY SERVICE 404,314 401,919 426,730 164,571 453,680 453,680 4410 RENTALS 1,500 1,500 1,500 0 0 0 4433 DUES 0 0 180 2,858 510 510 SUPPLIES & SERVICES 459,021 460,794 479,900 183,759 487,380 487,380 TOTAL COMMUNITY DEVELOPMENT DIVISION 460,733 462,252 485,570 185,817 500,630 500,630 5 EDA FUND 1999 BUDGET ACTIVITY: Activity includes the operation of the Shakopee Economic Development Authority. The EDA's mission is to enhance the quality of life in Shakopee by expanding and strengthening the local economy; broadening the city's job base and increasing its revenue base through facilitating the preservation, expansion, creation and attraction of quality businesses and related jobs. Implement strategies and administer various programs (grants, loans, etc. ) to accomplish above activities. Staff must maintain EDA records and prepare materials for policy decisions by Commissioners. The Commission is comprised of the Mayor and City Council. Section 469.107 of the Minnesota Statutes states that the governing body may, at the request of the authority, levy a tax in any year for the benefit of the authority. The tax must be not more than 0.01813 percent of taxable market value. OBJECT DESCRIPTION: Description of lines items: Salaries: EDA Director, share of City Staff including Planning Director. Professional Services: Legal and other consulting costs. Dues: Membership dues for professional economic.. development associations such as the American Economic Development Council, Economic Development Association of Minnesota, Mid-America Economic Development Association, and Council for Urban Economic Development. Conference/School/Training: Various conferences and training courses sponsored by professional economic development associations as outlined above. Miscellaneous: $45,000 (former Rehab Grant Program) . . . use to establish Economic Development Revolving Loan Fund? Contingency: $25,000 (not designated) . . . use to establish Economic Development Revolving Loan Fund? 6 CITY OF SHAKOPEE, MINNESOTA 1999 BUDGET EDA FUND BUDGET SUMMARY 1996 1997 1998 1999 Actual Actual Proposed Proposed Revenue Taxes $ 110,565 $ 103,552 $ 101,701 $ 108,700 Intergovernmental 4,711 5,400 5,379 5,400 Charges for Service 5,200 Miscellaneous Interest 19,302 22,893 18,000 22,000 Miscellaneous 7,475 Sale of Property Total Revenue 134,578 144,520 125,080 136,100 Transfer in Total Revenue and Transfers 134,578 144,520 125,080 136,100 Expenditures Personal Services 35,976 54,377 67,650 59,120 Supplies & Services 28,992 51,311 88,950 86,850 Capital - - - Total Expenditures 64,968 105,688 156,600 145,970 Excess (Deficiency) Of Revenues over Expenditures&Transfers $ 69,610 $ 38,832 $ (31,520) $ (9,870) Fund Balance December 31 399,780 438,612 407,092 397,222 7 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 19 - EDA 4101 WAGES FT REG 31,903 45,399 54,760 20,673 46,800 46,800 4110 WAGES - TEMP 40 769 1,000 24 1,000 1,000 4121 PERA 1,364 1,850 2,890 1,007 2,430 2,430 4122 FICA 2,434 3,501 4,270 1,563 3,670 3,670 4131 HEALTH & LIFE 0 285 4,630 129 4,820 4,820 4151 WORKERS COMPENSATION 236 402 100 0 400 400 4170 COMPENSATED ABSENCES 0 2,171 0 0 0 0 PERSONNEL SERVICES 35,977 54,377 67,650 23,396 59,120 59,120 4210 OPERATING SUPPLIES 418 2,050 2,500 123 2,500 2,500 4240 EQUIPMENT MAINTENANCE 0 0 100 0 0 0 4310 PROFESSIONAL SERVICES 5,897 7,652 8,000 3,206 7,000 7,000 4320 POSTAGE 0 21 200 0 100 100 4321 TELEPHONE 24 277 600 123 300 300 4330 TRAVEL/SUBSISTENCE 67 301 800 0 500 500 4340 ADVERTISING 200 0 200 0 200 200 4350 PRINTING/PUBLISHING 118 642 500 18 500 500 4360 INSURANCE 996 1,314 1,500 0 1,500 1,500 4390 CONFERENCE/SCHOOL/TRAINING 70 895 1,700 0 1,500 1,500 4410 RENTALS 1,500 1,500 1,500 0 1,500 1,500 4430 DESIGNATED MISCELLANEOUS 19,588 35,986 45,000 0 45,000 45,000 4433 DUES 107 465 1,000 465 1,000 1,000 4435 SUBSCRIPTIONS/PUBLICATIONS 0 208 350 0 250 250 4490 CONTINGENCY 0 0 25,000 0 25,000 25,000 SUPPLIES & SERVICES 28,984 51,311 88,950 3,935 86,850 86,850 TOTAL EDA DIVISION 64,960 105,688 156,600 27,331 145,970 145,970 8 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM 191 191 MANAGEMENT BENEFITS TOTAL EDA 4101 WAGES FT REG 39,300 7,500 46,800 4110 WAGES - TEMP 1,000 0 1,000 4121 PERA 2,040 390 2,430 4122 FICA 3,090 580 3,670 4131 HEALTH & LIFE 0 4,820 4,820 4151 WORKERS COMPENSATION 0 400 400 Total PERSONNEL SERVICES $45,430 $13,690 $59,120 4210 OPERATING SUPPLIES 2,500 0 2,500 4310 PROFESSIONAL SERVICES 7,000 0 7,000 4320 POSTAGE 100 0 100 4321 TELEPHONE 300 0 300 4330 TRAVEL/SUBSISTENCE 500 0 500 4340 ADVERTISING 200 0 200 4350 PRINTING/PUBLISHING 500 0 500 4360 INSURANCE 1,500 0 1,500 4390 CONFERENCE/SCHOOL/TRAINING 1,500 0 1,500 4410 RENTALS 1,500 0 1,500 4430 DESIGNATED MISCELLANEOUS 45,000 0 45,000 4433 DUES 1,000 0 1,000 4435 SUBSCRIPTIONS/PUBLICATIONS 250 0 250 4490 CONTINGENCY 25,000 0 25,000 Total SUPPLIES & SERVICES $86,850 $0 $86,850 TOTAL EDA $132,280 $13,690 $145,970 9 • 1,f 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 r 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 1 Excess (deficiency) Revenues 1 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 December31 $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. 9 1998 1999 2000 2001 2002 2003 Estimate Estimate Estimate Estimate Estimate Estimate $2,962,087 $3,601,361 $3,811,442 $4,033,680 $4,268,863 $4,517,613 0 0 0 0 0 0 $638,300 $689,900 $720,900 $751,900 $782,900 $813,900 $863,517 $1,153,890 $824,990 $824,990 $824,990 $824,990 $910,520 $1,025,780 $1,040,900 $1,056,260 $1,071,870 $1,087,750 $85,000 $90,000 $92,000 $94,000 $96,000 $98,000 $190,000 $270,000 $270,000 $270,000 $270,000 $270,000 5,649,424 6,830,931 6,760,232 7,030,830 7,314,623 7,612,253 1,680,940 1,997,160 2,077,046 2,160,128 2,246,533 2,336,395 2,530,880 2,699,660 2,807,646 2,919,952 3,036,750 3,158,220 1,396,480 1,473,630 1,532,575 1,593,878 1,657,633 1,723,939 373,940 517,460 538,158 559,685 582,072 605,355 302,790 646,980 672,859 699,774 727,765 756,875 6,285,030 7,334,890 7,628,286 7,933,417 8,250,754 8,580,784 (635,606) (503,959) (868,054) (902,587) (936,131) (968,531) 848,720 825,000 849,750 875,243 901,500 928,545 (332,690) (324,750) (337,740) (351,250) (365,300) (379,912) ($119,576) ($3,709) ($356,044) ($378,594) ($399,930) ($419,898) $3,708,925 $3,705,216 $3,349,172 $2,970,578 $2,570,648 $2,150,750 3 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 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 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 4 • 1999 GENERAL FUND BUDGET- REVENUES r , 1998 1999 2000 2001 2002 2003 EST. EST. EST. EST. EST. EST. Taxes Current Ad Valorem $ 2,515,557 $ 3,156,266 $ 3,345,642 $ 3,546,380 $ 3,759,163 $ 3,984,713 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,601,361 3,811,442 4,033,680 4,268,863 4,517,613 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 430,000 460,000 490,000 520,000 550,000 Plumbing Permits 50,000 60,000 60,000 60,000 60,000 60,000 Mechanical Permits 40,000 41,000 42,000 43,000 44,000 45,000 Electric Permits 40,000 45,000 45,000 45,000 45,000 45,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 689,900 720,900 751,900 782,900 813,900 Intergovernmental Grants 50,000 328,900 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 - - - - - 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 16,520 16,520 16,520 16,520 16,520 Aggregate Tax 15,000 18,000 18,000 18,000 18,000 18,000 Total Intergovernmental 863,517 1,153,890 824,990 824,990 824,990 824,990 Charges for Service Administrative Fee 45,000 45,000 45,000 45,000 45,000 45,000 Plan Check 250,000 255,000 260,000 265,000 270,000 275,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 Fire Calls &Contracts 35,000 35,000 35,000 35,000 35,000 35,000 5 1999 GENERAL FUND BUDGET- REVENUES , 1993 1994 1995 1996 1997 1998 ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL YTD (6-30-98) 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 I 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 370,553 Capital Equipment 290,318 747,302 - SPUC Contribution 279,481 286,197 759,489 789,232 620,993 377,760 Total Other Sources 572,905 1,035,558 759,831 791,694 1,066,546 377,760 Grand Total $8,637,825 $9,064,934 $9,215,156 $6,741,856 $7,429,790 $4,597,951 6 1999 GENERAL FUND BUDGET- REVENUES 1998 1999 2000 2001 2002 2003 EST. EST. EST. EST. EST. EST. 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 500,000 505,000 510,000 515,000 520,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,025,780 1,040,900 1,056,260 1,071,870 1,087,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 200,000 200,000 200,000 200,000 200,000 Rent 10,000 10,000 10,000 10,000 10,000 10,000 Contributions - - - - - Total Miscellaneous 190,000 270,000 270,000 270,000 270,000 270,000 Total Revenues 5,649,424 6,830,931 6,760,232 7,030,830 7,314,623 7,612,253 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,655,931 $7,609,982 $7,906,073 $8,216,123 $8,540,798 , 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 60,500 60,500 TOTAL MAYOR & COUNCIL DIVISION 69,978 51,987 65,330 19,009 94,380 94,380 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 5,000 5,000 TOTAL CITY ADMINISTRATOR DIVISION 237,402 176,700 225,000 68,307 223,590 223,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 39,050 39,050 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 180,840 180,840 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 424,170 424,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 726,120 726,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 130,290 130,290 450 CAPITAL EXPENDITURES 0 0 12,000 0 0 0 TOTAL GENERAL GOVERNMENT BUILDINGS DIVISION 132,065 149,733 153,890 34,377 158,230 158,230 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 287,650 287,650 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 40,000 40,000 TOTAL POLICE DIVISION 1,584,199 1,710,879 1,814,370 681,735 1,850,340 1,850,340 DIVISION 32 - FIRE 410 PERSONNEL SERVICES 140,576 137,094 162,420 29,884 152,580 152,580 420 SUPPLIES & SERVICES 247,810 293,249 320,140 113,464 386,740 386,740 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 567,320 567,320 DIVISION 33 - INSPECTION-BLDG-PLMBG-HTG 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 26,800 26,800 450 CAPITAL EXPENDITURES 5,427 0 4,500 0 3,500 3,500 TOTAL SHOP DIVISION 106,776 124,242 125,890 40,294 136,070 136,070 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 271,750 271,750 450 CAPITAL EXPENDITURES 0 0 0 0 39,500 39,500 TOTAL PARK MAINTENANCE DIVISION 282,599 315,551 377,940 133,217 517,460 517,460 DIVISION 91 - UNALLOCATED 410 PERSONNEL SERVICES 0 0 0 54,107 0 0 420 SUPPLIES & SERVICES 20,209 90,722 194,140 308,566 646,980 646,980 470 TRANSFERS OUT 663,596 2,321,602 332,690 0 324,750 324,750 TOTAL UNALLOCATED DIVISION 683,805 2,412,324 526,830 362,673 971,730 971,730 TOTAL GENERAL FUND 5,774,097 7,847,174 6,962,820 2,361,621 7,659,640 7,659,640 9 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: Southwest Coalition $2,000 and $6,000 undesignated projects. Provides for production of 4500 issues of the City Newsletter. (Additional $3,300 to deliver with Shakopee Valley News. ) Postage: Delivery of City Newsletter in mint advertiser $8,400. Printing/Publishing: Printing ordinances for code books $3,500. Conference/School/Training: LMC conference, one national conference for Mayor. Dues: AMM dues $3,826, League dues $6,800, SRA $1,300, Utility Coalition $2,700, misc. $560. Miscellaneous: Volunteer/employee appreciation picnic and retirement/appreciation plaques. 10 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 27,200 27,200 4320 POSTAGE 905 0 1,000 0 9,400 9,400 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 60,500 60,500 TOTAL MAYOR & COUNCIL DIVISION 69,978 51,987 65,330 23,621 94,380 94,380 11 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 27,200 27,200 4320 POSTAGE 9,400 9,400 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 $60,500 $60,500 TOTAL MAYOR & COUNCIL $94,380 $94,380 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 13 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. Capital Equipment: Purchase of a paperless electronic imaging records system $40,000. 14 r , 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 5,000 5,000 CAPITAL EXPENDITURES 12,615 0 2,500 0 5,000 5,000 TOTAL CITY ADMINISTRATOR DIVISION 237,402 176,700 225,000 80,391 223,590 223,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 4550 EQUIPMENT 0 5,000 0 0 5,000 Total CAPITAL EXPENDITURES $0 $5,000 $0 $0 $5,000 TOTAL CITY ADMINISTRATOR $36,730 $150,320 $35,070 $1,470 $223,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 s 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 2,850 2,850 4240 EQUIPMENT MAINTENANCE 0 0 250 0 250 250 4310 PROFESSIONAL SERVICES 250 674 1,000 0 800 800 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 19,050 19,050 4360 INSURANCE 1,305 1,759 1,700 363 1,810 1,810 4390 CONFERENCE/SCHOOL/TRAINING 51 416 320 80 500 500 4410 RENTALS 566 567 500 136 600 600 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 39,050 39,050 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 180,840 180,840 19 r 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 350 2,850 4240 EQUIPMENT MAINTENANCE 0 250 0 250 4310 PROFESSIONAL SERVICES 0 250 550 800 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 18,500 550 19,050 4360 INSURANCE 0 1,810 0 1,810 4390 CONFERENCE/SCHOOL/TRAINING 0 500 0 500 4410 RENTALS 0 550 50 600 4433 DUES 0 140 0 140 Total SUPPLIES & SERVICES SO $37,550 $1,500 $39,050 4800 EXPENSE CHARGED BACK 0 -3,000 0 -3,000 Total EXPENSE CHARGED TO OTHER ACT SO $-3,000 SO 5-3,000 TOTAL CITY CLERK $36,600 $139,430 $4,810 $180,840 20 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 SO $0 $0 SO S-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 28 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 ($35,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. 29 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 221,660 221,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 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 216,400 75,713 424,170 424,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 474,700 200,855 726,120 726,120 30 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 $0 $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 35,000 43,480 10,000 123,500 221,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 $193,010 $43,480 $10,000 $123,500 $424,170 4800 EXPENSE CHARGED BACK 0 -6,000 0 0 0 0 -6,000 Total EXPENSE CHARGED TO OTHER ACT $0 $-6,000 $0 $0 $0 $0 $-6,000 TOTAL COMMUNITY DEVELOPMENT $67,750 $96,180 $195,270 $190,460 $52,960 $123,500 $726,120 31 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 32 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. 33 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 11,490 11,490 SUPPLIES & SERVICES 95,382 126,038 114,400 34,166 130,290 130,290 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 158,230 158,230 34 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 800 18,390 4102 OVERTIME-FT 0 200 0 0 200 4121 PERA 180 600 130 50 960 4122 FICA 270 890 190 60 1,410 4131 HEALTH & LIFE 4,630 0 0 0 4,630 4151 WORKERS COMPENSATION 1,850 0 0 0 1,850 4170 COMPENSATED ABSENCES 500 0 0 0 500 Total PERSONNEL SERVICES $10,930 $13,280 $2,820 $910 $27,940 4210 OPERATING SUPPLIES 0 3,000 0 0 3,000 4230 BUILDING MAINT 0 44,500 18,000 3,200 65,700 4240 EQUIPMENT MAINTENANCE 0 2,500 0 0 2,500 4310 PROFESSIONAL SERVICES 0 1,000 0 2,500 3,500 4321 TELEPHONE 0 1,600 1,400 0 3,000 4330 TRAVEL/SUBSISTENCE 0 100 0 0 100 4360 INSURANCE 0 4,000 0 0 4,000 4380 UTILITY SERVICE 0 29,000 7,000 1,000 37,000 4410 RENTALS 0 0 0 11,490 11,490 Total SUPPLIES & SERVICES $0 $85,700 $26,400 $18,190 $130,290 TOTAL GENERAL GOVERNMENT BUILDINGS $10,930 $98,980 $29,220 $19,100 $158,230 35 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 36 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 and two Community Service Officers which will be paid for in part by a Federal Grant. 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. 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. 37 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 34,500 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 131,030 56,394 122,070 122,070 4122 FICA 16,497 18,945 19,840 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,526,730 714,177 1,522,690 1,522,690 4210 OPERATING SUPPLIES 31,729 39,030 34,290 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,200 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,220 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 2,500 668 2,750 2,750 4360 INSURANCE 22,559 25,424 26,000 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,000 3,134 15,000 15,000 4410 RENTALS 41,784 55,410 57,530 29,185 63,350 63,350 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 242,190 106,652 287,650 287,650 4550 EQUIPMENT 13,723 1,728 18,000 1,623 40,000 40,000 CAPITAL EXPENDITURES 13,723 1,728 18,000 1,623 40,000 40,000 TOTAL POLICE DIVISION 1,584,199 1,710,879 1,786,920 822,452 1,850,340 1,850,340 38 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 $0 $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 21600 39050 0 0 0 0 0 0 2,700 0 63,350 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 $201250 $58650 $1400 $0 $0 $8,550 $0 $4,500 $13,300 $0 $287,650 4550 EQUIPMENT 0 0 0 0 0 0 0 0 40,000 0 0 40,000 Total CAPITAL EXPENDITURES $0 $0 $0 $0 $0 $0 $0 $0 $40,000 $0 $0 $40,000 TOTAL POLICE $449810 $490860 $669060 $120080 $7330 $6770 $9,130 $15,800 $44,500 $22,330 $14,670 $1,850,340 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 40 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 47 Fire Fighters, an increase from 44 in 1998. 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 #2 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. 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. 41 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 141,820 141,820 4121 PERA 106 135 190 56 190 190 4122 FICA 1,467 1,496 2,340 509 2,370 2,370 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 152,580 152,580 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 197,940 197,940 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 386,740 386,740 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 567,320 567,320 47' CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM 321 324 MGT FIRE STATION NO. 2 TOTAL FIRE 4102 OVERTIME-FT 2,200 0 2,200 4110 WAGES - TEMP 127,820 14,000 141,820 4121 PERA 130 0 130 4122 FICA 2,080 210 2,290 4151 WORKERS COMPENSATION 5,000 0 5,000 Total PERSONNEL SERVICES $137,230 $14,210 $151,440 4210 OPERATING SUPPLIES 37,950 9,000 46,950 4222 MOTOR FUELS & LUBRICANTS 5,000 0 5,000 4230 BUILDING MAINT 21,000 7,000 28,000 4240 EQUIPMENT MAINTENANCE 25,000 0 25,000 4310 PROFESSIONAL SERVICES 6,200 0 6,200 4320 POSTAGE 120 0 120 4321 TELEPHONE 1,770 1,500 3,270 4330 TRAVEL/SUBSISTENCE 10,000 0 10,000 4350 PRINTING/PUBLISHING 1,000 0 1,000 4360 INSURANCE 16,300 5,700 22,000 4380 UTILITY SERVICE 12,000 20,000 32,000 4390 CONFERENCE/SCHOOL/TRAINING 7,700 0 7,700 4410 RENTALS 197,940 0 197,940 4433 DUES 1,040 0 1,040 4435 SUBSCRIPTIONS/PUBLICATIONS 520 0 520 Total SUPPLIES & SERVICES $343,540 $43,200 $386,740 4550 EQUIPMENT 28,000 0 28,000 Total CAPITAL EXPENDITURES $28,000 $0 $28,000 TOTAL FIRE $508,770 $57,410 $566,180 43 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: ICBG $750 (250 each) 44 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 .l 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 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 47 • 4' 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. 48 ,1 . 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 49 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 $0 $-8,000 $0 $0 $-8,000 TOTAL ENGINEERING $103,910 $155,130 $89,480 $144,590 $493,110 50 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 51 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. 52 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 53 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 EOP 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 $45,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 54 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 55 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 SPUC 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: 1 Mechanic, 1 Assistant Mechanic, 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 56 , 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 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 0 0 4433 DUES 0 0 200 0 100 100 SUPPLIES & SERVICES 21,442 35,324 23,350 4,381 26,800 26,800 4550 EQUIPMENT 5,427 0 4,500 0 3,5003,500 CAPITAL EXPENDITURES 5,427 0 4,500 0 3,500 3,500 TOTAL SHOP DIVISION 106,776 124,242 125,890 44,722 136,070 136,070 57 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 4433 DUES 0 100 0 0 0 0 0 100 Total SUPPLIES & SERVICES $0 $26,800 $0 $0 $0 $0 SO $26,800 4550 EQUIPMENT 0 3,500 0 0 0 0 0 3,500 Total CAPITAL EXPENDITURES $0 $3,500 $0 $0 $0 $0 $0 $3,500 TOTAL SHOP $23,800 $41,960 $40,510 $16,880 $8,970 $2,820 $1,130 $136,070 58 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 • 59 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, 1/2 year for additional maintenance worker for 1999. 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 $50,000, Sod $500, ballfield aggregate $3,000, fertilizer $1,000, weed killer $1,000, wood chips (Memorial Park) $3,000 and miscellaneous $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, resurfacing of tennis courts in Stans Park $35,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 Capital Expenditures: Athletic Field Groomer $3,500, Top Dresser (Turf Management) $6,000, and playground equipment $30,000. 60 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 59,500 59,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 51,000 51,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 39,500 39,500 4433 DUES 0 10 100 131 150 150 SUPPLIES & SERVICES 121,941 128,555 172,420 59,545 271,750 271,750 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 517,460 517,460 61 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRM PROGRAM PROGRAM PROGRM PROGRM PROGRM PROGRM PRGRM PROGRM PROGRM PRGRM PROGRAM 620 621 622 623 624 625 626 627 628 629 630 631 BENFTS MGT MAINT MW/TRM ATH FL EQP/VH RINKS SNOW BLD/PP TR/SCP CSTDN MRPHY'S TOTAL PARK MAINTENANCE 4101 WAGES FT REG 26000 22000 25000 7500 16000 800 9000 3200 17210 4000 1200 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 $1350 $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 1500 0 3000 0 500 0 0 54000 0 500 59,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 2000 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 35000 0 6000 0 0 0 0 1000 3000 2,000 51,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 0 0 0 0 39,500 4433 DUES 0 150 0 0 0 0 0 0 0 0 0 0 150 Total SUPPLIES & SERVICES $0 $81450 $44500 $0 $19000 $14000 $1300 $0 $43000 $55000 $5000 $8,500 $271,750 4550 EQUIPMENT 0 0 36000 - 0 3500 0 0 0 0 0 0 0 39,500 Total CAPITAL EXPENDITURES $0 $0 $36000 $0 $3500 $0 $0 $0 $0 $0 $0 $0 $39,500 TOTAL PARK MAINTENANCE $54520 $106810 $113070 $-16050 $47090 $15440 $12590 $6910 $63490 $60590 $6350 $14,550 $517,460 62 S I 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 63 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. $103,190 Contingency: Contingency appropriation for the General Fund. Additional wage increases 1% $34,000, reclassifications and new positions $174,990, and a police technology grant $224,800. Designated Miscellaneous: ADC tax payment - Local Effort "TIF" $95,000 Interfund Operating Transfers: Operating Transfers Recreation Fund $324,750. 64 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 95,000 95,000 4431 CASH SHORT/OVER 0 1 0 0 0 0 4437 PROPERTY TAX/SPECIAL ASSESS 14,117 65,943 97,790 52,031 103,190 103,190 4438 SALES TAX 277 0 0 0 0 0 4490 CONTINGENCY 829 24,093 190,000 9,187 433,790 433,790 SUPPLIES & SERVICES 20,209 90,722 302,790 312,210 646,980 646,980 4720 INTERFUND OPERATING TRANSFERS 251,340 301,140 332,690 0 324,750 324,750 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 324,750 324,750 TOTAL UNALLOCATED DIVISION 683,805 2,412,324 635,480 366,317 971,730 971,730 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 95,000 95,000 4437 PROPERTY TAX/SPECIAL ASSESS 103,190 103,190 4490 CONTINGENCY 433,790 433,790 Total SUPPLIES & SERVICES $646,980 $646,980 4720 INTERFUND OPERATING TRANSFERS 324,750 324,750 Total TRANSFERS OUT $324,750 $324,750 TOTAL UNALLOCATED $971,730 $971,730 66 SPECIAL REVENUE FUNDS Special Revenue Funds are used to account for the proceeds of specific revenue sources designated to finance particular activities as required by law or administrative regulation. Established in 1984, the Transit Fund accounts for the van pools and Bial- a-ride services provided by the City after opting out of the Metropolitan Transit Commission's service. Economic Development Authority Fund accounts for the activities of that body. i CITY OF SHAKOPEE 1999 BUDGET SPECIAL REVENUE FUNDS BUDGET SUMMARY Transit EDA Total Revenue Taxes $ 340,630 $108,700 $ 449,330 Intergovernmental 90,000 $195,400 285,400 Charges for Service 70,000 70,000 Interest 22,000 22,000 Total Revenue 500,630 326,100 826,730 Transfer In 95,000 95,000 Total Revenue and Transfers 500,630 421,100 921,730 Expenditures and Transfers Genral Government 430,970 430,970 Public Works 500,630 500,630 Total Expenditures 500,630 430,970 931,600 Excess(Deficiency) Of Revenues over Expenditures&Transfers $ - $ (9,870) (9,870) Fund Balance $ 156,204 $397,222 553,426 2 TRANSIT FUND 1999 BUDGET ACTIVITY: The transit system began operation in September of 1984. Subsidy is provided under contract with RTB. Service is comprised of van pools for trips outside of Shakopee and a dial-a-ride service for internal trips. Express route bus service to Eden Prairie Center and Downtown Minneapolis is also provided twice daily during peak A.M. and P.M. travel times. Private carriers provide the service and are under contract with the City. City Staff monitors the contract. OBJECT DESCRIPTION: Description of lines items: Salaries: Share of City Staff. Utilities: Contracts with transit providers. 3 CITY OF SHAKOPEE, MINNESOTA 1999 BUDGET TRANSIT FUND BUDGET SUMMARY 1996 1997 1998 1999 Actual Actual Proposed Proposed Revenue Property Taxes $ 285,833 $ 340,630 State Aid 393,734 83,263 440,380 90,000 State Grants 179,596 - Fares 66,999 63,501 71,150 70,000 Interest 3,610 - Total Revenue 460,733 615,803 511,530 500,630 Expenditures Personal Services 1,712 1,458 5,505 13,250 Supplies & Services 459,021 460,794 506,025 487,380 Capital - - - Total Expenditures 460,733 462,252 511,530 500,630 Excess (Deficiency) Of Revenues over Expenditures &Transfers $ - $ 153,551 $ - $ - Fund Balance $ 2,653 $ 156,204 $ 156,204 $ 156,204 Note: The $257,000 in 1997 revenues as State Aid is a 1 time carryover of funds from Met Council for$205,000 and Private Vehicle Capital payments from the RTB for$52,000. 4 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 1,527 1,302 5,010 1,832 11,740 11,740 4121 PERA 68 58 270 95 610 610 4122 FICA 116 98 390 131 900 900 PERSONNEL SERVICES 1,712 1,458 5,670 2,058 13,250 13,250 4210 OPERATING SUPPLIES 0 337 1,500 300 1,500 1,500 4222 MOTOR FUELS & LUBRICANTS 16,146 16,921 20,000 0 0 0 4310 PROFESSIONAL SERVICES 33,275 37,765 25,000 15,518 27,500 27,500 4330 TRAVEL/SUBSISTENCE 97 0 100 0 100 100 4340 ADVERTISING 3,031 1,493 3,090 469 3,090 3,090 4350 PRINTING/PUBLISHING 358 179 1,800 43 1,000 1,000 4360 INSURANCE 300 680 0 0 0 0 4380 UTILITY SERVICE 404,314 401,919 426,730 164,571 453,680 453,680 4410 RENTALS 1,500 1,500 1,500 0 0 0 4433 DUES 0 0 180 2,858 510 510 SUPPLIES & SERVICES 459,021 460,794 479,900 183,759 487,380 487,380 TOTAL COMMUNITY DEVELOPMENT DIVISION 460,733 462,252 485,570 185,817 500,630 500,630 5 1999 CITY OF SHAKOPEE 14 TRANSIT FUND Program Program Program 142 143 144 Object# Description DIAL-A-RIDE VAN POOL CIRCULATOR Total 4101 Wages FT- Reg. $ 4,870 $ 4,870 $ 2,000 $ 11,740 4110 Wages-Temporary - 4121 PERA 250 250 110 610 4122 FICA 370 370 160 900 4131 Health &Life - 4151 Workers Comp - Total Personnel 5,490 5,490 2,270 13,250 4210 Operating Supplies 500 500 500 1,500 4222 Motor Fuels/Lube - - - - 4240 Equipment Maintenance - - - - 4310 Professional Services 25,500 1,000 1,000 27,500 4320 Postage - - - - 4321 Telephone - - - - 4330 Travel/Subsistence 100 - - 100 4340 Advertising 1,030 1,030 1,030 3,090 4350 Printing/Publishing 600 200 200 1,000 4360 Insurance - 4380 Services 340,760 75,550 37,370 453,680 4390 Conference/School/Training - 4410 Rentals - - - - 4430 Miscellaneous - 4433 Dues 390 60 60 510 4437 Property Tax/Special Assess - Total Supplies&Services 368,880 78,340 40,160 487,380 4550 Capital Expenditures Total $ 374,370 $ 83,830 $ 42,430 $500,630 6 EDA FUND 1999 BUDGET ACTIVITY: Activity includes the operation of the Shakopee Economic Development Authority. The EDA's mission is to enhance the quality of life in Shakopee by expanding and strengthening the local economy; broadening the city's job base and increasing its revenue base through facilitating the preservation, expansion, creation and attraction of quality businesses and related jobs. Implement strategies and administer various programs (grants, loans, etc. ) to accomplish above activities. Staff must maintain EDA records and prepare materials for policy decisions by Commissioners. The Commission is comprised of the Mayor and City Council. Section 469.107 of the Minnesota Statutes states that the governing body may, at the request of the authority, levy a tax in any year for the benefit of the authority. The tax must be not more than 0.01813 percent of taxable market value. OBJECT DESCRIPTION: Description of lines items: Salaries: EDA Director, share of City Staff including Planning Director. Professional Services: Legal and other consulting costs. Dues: Membership dues for professional economic development associations such as the American Economic Development Council, Economic Development Association of Minnesota, Mid-America Economic Development Association, and Council for Urban Economic Development. Conference/School/Training: Various conferences and training courses sponsored by professional economic development associations as outlined above. Miscellaneous: $45,000 (former Rehab Grant Program) . . . use to establish Economic Development Revolving Loan Fund. $285,000 for ADC, local (TIF) effort. Contingency: $25,000 (not designated) . . . use to establish Economic Development Revolving Loan Fund. CITY OF SHAKOPEE, MINNESOTA 1999 BUDGET EDA FUND BUDGET SUMMARY 1996 1997 1998 1999 Actual Actual Proposed Proposed Revenue Taxes $ 110,565 $ 103,552 $ 101,701 $ 108,700 Intergovernmental 4,711 5,400 5,379 195,400 Charges for Service 5,200 Miscellaneous Interest 19,302 22,893 18,000 22,000 Miscellaneous 7,475 Total Revenue 134,578 144,520 125,080 326,100 Transfer in 95,000 Total Revenue and Transfers 134,578 144,520 125,080 421,100 Expenditures Personal Services 35,976 54,377 67,650 59,120 Supplies&Services 28,992 51,311 88,950 41,850 Miscellaneous - - 330,000 Total Expenditures 64,968 105,688 156,600 430,970 Excess (Deficiency) Of Revenues over Expenditures&Transfers $ 69,610 $ 38,832 $ (31,520) $ (9,870) Fund Balance December 31 399,780 438,612 407,092 397,222 8 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 19 - EDA 4101 WAGES FT REG 31,903 45,399 54,760 20,673 46,800 46,800 4110 WAGES - TEMP 40 769 1,000 24 1,000 1,000 4121 PERA 1,364 1,850 2,890 1,007 2,430 2,430 4122 FICA 2,434 3,501 4,270 1,563 3,670 3,670 4131 HEALTH & LIFE 0 285 4,630 129 4,820 4,820 4151 WORKERS COMPENSATION 236 402 100 0 400 400 4170 COMPENSATED ABSENCES 0 2,171 0 0 0 0 PERSONNEL SERVICES 35,977 54,377 67,650 23,396 59,120 59,120 4210 OPERATING SUPPLIES 418 2,050 2,500 123 2,500 2,500 4240 EQUIPMENT MAINTENANCE 0 0 100 0 0 0 4310 PROFESSIONAL SERVICES 5,897 7,652 8,000 3,206 7,000 7,000 4320 POSTAGE 0 21 200 0 100 100 4321 TELEPHONE 24 277 600 123 300 300 4330 TRAVEL/SUBSISTENCE 67 301 800 0 500 500 4340 ADVERTISING 200 0 200 0 200 200 4350 PRINTING/PUBLISHING 118 642 500 18 500 500 4360 INSURANCE 996 1,314 1,500 0 1,500 1,500 4390 CONFERENCE/SCHOOL/TRAINING 70 895 1,700 0 1,500 1,500 4410 RENTALS 1,500 1,500 1,500 0 1,500 1,500 4430 DESIGNATED MISCELLANEOUS 19,588 35,986 45,000 0 330,000 330,000 4433 DUES 107 465 1,000 465 1,000 1,000 4435 SUBSCRIPTIONS/PUBLICATIONS 0 208 350 0 250 250 4490 CONTINGENCY 0 0 25,000 0 25,000 25,000 SUPPLIES & SERVICES 28,984 51,311 88,950 3,935 371,850 371,850 TOTAL EDA DIVISION 64,960 105,688 156,600 27,331 430,970 430,970 9 CITY OF SHAKOPEE PROGRAM BUDGET WORKSHEET FOR THE YEAR ENDING 12/31/99 PROGRAM PROGRAM 190 191 BENEFITS MANAGEMENT TOTAL EDA 4101 WAGES FT REG 7,500 39,300 46,800 4110 WAGES - TEMP 0 1,000 1,000 4121 PERA 390 2,040 2,430 4122 FICA 580 3,090 3,670 4131 HEALTH & LIFE 4,820 0 4,820 4151 WORKERS COMPENSATION 400 0 400 Total PERSONNEL SERVICES $13,690 $45,430 $59,120 4210 OPERATING SUPPLIES 0 2,500 2,500 4310 PROFESSIONAL SERVICES 0 7,000 7,000 4320 POSTAGE 0 100 100 4321 TELEPHONE 0 300 300 4330 TRAVEL/SUBSISTENCE 0 500 500 4340 ADVERTISING 0 200 200 4350 PRINTING/PUBLISHING 0 500 500 4360 INSURANCE 0 1,500 1,500 4390 CONFERENCE/SCHOOL/TRAINING 0 1,500 1,500 4410 RENTALS 0 1,500 1,500 4430 DESIGNATED MISCELLANEOUS 0 330,000 330,000 4433 DUES 0 1,000 1,000 4435 SUBSCRIPTIONS/PUBLICATIONS 0 250 250 4490 CONTINGENCY 0 25,000 25,000 Total SUPPLIES & SERVICES $0 $371,850 $371,850 TOTAL EDA $13,690 $417,280 5430,970 10 Shakopee Fire Department 1999 personnel requests Salaries - Temp 47 firefighters. This represents an increase of 3 firefighters over 1998. This requires an increase of approximately $8,000 for the salaries of temporary employees. This increase is intended to help staff our 2 station operation and to meet ISO standards for staffing and apparatus manning. These positions should have a start date of January 1, 1999. Supplies and training associated with new firefighters Firefighting gear$1,000 per person and $400 for initial training per person. Salaries-Full time Fire Marshal A full time fire marshal is required to adequately perform and manage fire inspections, annual fire suppression system flow tests, building pre-plans, building plan reviews and meetings, fire incident reports, to assist in fire investigations and deliver and manage fire education programs. Years ago this could be managed on a volunteer part-time basis however with Shakopee's current size and expansion we cannot provide the level of service in this area which is required. Salary for this position would be equivalent to a starting building inspector position. The start date for this position should be in April of 1999. /f.b -, S- Duties for part time Fire Marshal 1. Manage and perform fire inspections 2. Annual fire suppression system flow tests 3. Perform building pre-plans and manage documentation and access 4. Perform building plan reviews and attend meetings 5. Fill out and manage fire incident reports 6. Assist in fire investigations 7. Manage and deliver fire prevention education programs 8. Manage SARA title two reports from the State of MN 9. Provide local fire code information and answer code questions w. N , W CO L— 0 40-0711170- 00015."U L L V L Ldi. CO CO t L CO L L CO L�L L CO CO L N C ` ` 10 y`. Lp o ` ` N N N lc N N N N co N N O1 l0 l0 Oi O1 N N A 10 lL 10 R{ to R1 l0 co 10 10 CO W 10 f0 CO 10 CO 22222 2E 22'. 2"2222 222222222M `1 N d 00000 y W N y 0 0 W W W W W W 000 W 000 W Q wwil.LLILQIZiZ U.LLOQLLOLLLLLLIkm L LL.LLLLLLLLLLLLiLLLLL E E C a oOLL . OOOOO OO 000() E c�O 00 UEEEEE EE EEEqq-� E EEQ rno �� az ( - ornN rnn foon ro 7 oonbrn DOg0�Of fVmm� ac-CO ,3 InCnc w2 23233 2: gmawaa 4, 11 O O E Eca N Ei0 EE 11 C °dV W iRi _g6 4,4,444 WaugCloW — c z 13 v SIE v c-0 iz v ��CC L O I(3 to V (gpp� �N .0 l>.E Q j fc4 m 0 ` U� 1,c In YUCO�� C U o O— (7) -6- 111 lU l0 h o �l , 040, .a `- E m s `� > W pp: p�p:!m cmi �pp o Ep�pa� `c4 OD fo U In n n In f7 n = G Old �0 O)N o n ao r..ultOO)fof(o 44 4444 4444{44, 44 44 4444444444444444 I graR 1.< LL Q I w yy 0) 10 yy yy O O O O d O y YI W O 0 d y y W 0 (0 . . . 0 . 0 . . . . I E W ZZZZ} Z} }}Z}}}}}Z} }Z}Z}Z}}}} • W E N r 00000 W m 0000000000 o 0 d CI) 0 0 0 0 0 0 >-ZZZZ >->- ZZZ>-ZZ)-Z)-Z Z}}>-ZZZZZZ I • O a E o ririCiriri LL riririLririaaaa cl.u.waaaaaaa • Li. I • P x S _ . cy r c c. c L N 111 • Iv „Ism 3'iI �m La c(921 qEg N o c N c c°oiU� c > m 5 �c—m omri o lS m o .0$ €� m o LLWe �� 4: al w <OC XX2ZQo> 0 ou' ww—et2Zin� 411 131 Stanton Group Unallocated 1998 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 95,000 95,000 4433 Dues - 4435 Subscriptions/Publications - 4437 Property Tax/Special Assess 103,190 103,190 4490 Contingency 433,790 433,790 Total Supplies &Services $ 646,980 $ 646,980 4720 Interfund Operating Transfer $ 324,750 324,750 Total Unallocated $ 971,730 $ 971,730 Transfers: Rec. Fund 324,750 Contingency: Wage adjustments 1% 34,000 Police Technology Grant 224,800 Reclassifications 5,000 New position- Fire Inspect 19,060 New position - Police CSO 28,290 New position - Police CSO 28,290 New position - Clerk Typist 30,660 New position - Police sw 43,320 New position - Park Maint 20,370 433,790