The URL can be used to link to this page

Home My WebLink About8. 2011/2012 City Adminstrator Budgets 8. CITY OF SHAKOPEE 2011 -2012 GENERAL FUND BUDGET DIVISION: MAYOR & COUNCIL MISSION STATEMENT: Through its legislative authority, the mission of the Mayor and City Council is to set policy, establish service levels, and set a rate of taxation for Shakopee property owners. ACTIVITY: Includes ceremonial functions performed by the Mayor, who is elected as Mayor and serves as Chief Executive Officer of the City. The Mayor is 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 not otherwise provided for or prohibited by State and Federal governments, adopting the City's operating and capital budgets, and affirming the hiring and dismissal of City employees. The Council also provides liaison relationships on numerous boards and commissions. The Mayor and four Council Members are elected at -large for terms of two and four years, respectively. GOALS: 1. Provide for service levels commensurate with population growth; acceptable levels of taxation. 2. Implement the Goals and Strategies of the Shakopee Visioning Process to provide for current and future needs. MEASUREMENT OF GOALS: Cost to provide City services as measured on a per capita basis: Actual Budgeted Requested Requested 2009 2010 2011 2012 Total Mayor & Council Expenditures $123,440 $207,802 $198,290 $199,730 Population 34,691 34,000 35,100 35,300 Expenditure /Capita $3.56 $6.11 $5.65 $5.66 OBJECT DESCRIPTION: Description of line items: Wages & Benefits: Mayor's salary $7,860, Council $6,720, Recording Secretary $5,000; no change for 2012 Supplies: Includes items for support of council members Professional Service: Provides for $6,000 for undesignated projects, and $40,000 for attorney for civil work (formerly budgeted in the Legal Division). 8 -1 Conference /Schools /Training: LMC or other elected official conferences for Mayor or Council members $1,500 (same for 2011). Travel Subsistence: Council workshop meals, and reimbursement for mileage traveled on City business $2,500 (same for 2012). Dues: Metro Cities dues $9,240 ($9,517 in 2012), League of MN Cities dues $19,280 ($19,858 in 2012), Suburban Rate Authority $3,000 (same for 2012), miscellaneous dues $3,000 (same for 2012), SCALE group participation $5,000 (same for 2012), contribution to Transportation Alliance (SCALE) $20,000 (same for 2012); MN Mayor's Association $20 (same for 2012); and US Highway 169 Coalition $3,000 (same for 2012) Other Charges: Departmental IT $7,880 ($8,480 for 2012) Designated Miscellaneous: Volunteer /employee recognition picnic, employee appreciation lunch, and retirement plaques $1,500 ($1,500 for 2012); contribution for Derby Days $0 ($0 for 2012) 8 -2 R5509BUD SH005PV CITY OF SHAKOPEE 814/2010 8:54:13 By Co, Div (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 1 Fiscal Period: 7 / 10 Level Of Rollup 6 2008 2009 713112010 2010 2011 2012 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget 01000 GENERAL FUND 11 MAYOR & COUNCIL 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4200 LICENSES AND PERMITS 4500 CHARGES FOR SERVICE 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 37,628 36,926 21,455 39,740 39,740 39,740 6100 BENEFITS 3,394 3,337 1,741 5,150 5,150 5,150 6001 WAGES & BENEFITS 41,022 40,264 23,196 44,890 44,890 44,890 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 223 194 151 1,400 1,400 1,400 6300 PROFESSIONAL SERVICES 9,006 767 10,905 46,000 46,000 46,000 6330 COMMUNICATIONS 185 253 306 6350 INSURANCE 1,555 1,191 1,557 1,260 1,660 1,760 6400 RENTALS 17,676 20,892 15,449 26,480 32,800 33,280 6470 DUES/TRAINING/TRAVEL 49,986 54,539 36,814 79,290 70,040 70,900 6200 SUPPLIES AND SERVICES 78,631 77,836 65,182 154,430 151,900 153,340 6500 DEPRECIATION 6600 MISCELLANEOUS 6640 DESIGNATED MISCELLANEOUS 5,217 5,340 1,097 8,500 1,500 1,500 6600 MISCELLANEOUS 5,217 5,340 1,097 8,500 1,500 1,500 6800 DEBT SERVICE 6000 EXPENDITURES 124,870 123,440 89,474 207,820 198,290 199,730 8050 TOTAL TRANSFERS OUT 4000 REVENUES AND EXPENDITURES 124,870 123,440 89,474 207,820 198,290 199,730 11 MAYOR & COUNCIL 124,870 123,440 89,474 207,820 198,290 199,730 01000 GENERAL FUND 124,870 123,440 89,474 207,820 198,290 199,730 8 -3 City of Shakopee 2011 Budget Improvement Package Instructions —for any improvement that results in an increase of .$5,000 or more, the following information should be provided: Project /Improvement: Adds Shakopee as a member of the Municipal Legislative Commission. Prepared by: Mark McNeill, City Administrator Description of Improvement and Need for it: Shakopee has been invited to become a member of the Municipal Legislative Commission (MLC). This is a group composed of 14 metro -area cities (total population 765,000), which focuses on tax policy lobbying. See the attachment for a listing of the current member cities, and the 2010 MLC legislative policies. Because of Shakopee's development in recent years, the current MLC members have extended the invitation, based on a commonality of size, economic factors, tax base, and demographics with the member cities. While the City would maintain its membership in other groups such as the LMC and Metro Cities, the MLC would provide more narrowly- focused lobbying on topics of direct importance to Shakopee and its taxpayers —Local Government Aid, transportation, MVHC, job creation and retention through economic policies, fiscal disparities, and the like. Costs: The 2011 introductory dues would be one -half of the normal dues (which are based on $.20 per capita). This would mean dues of $3950 for 2011, and $7900 for 2012. The City would have a chance to evaluate membership effectiveness, and determine whether to continue each year. Funds would be charged to Mayor /Council budget 0111, and would come from general tax levy. Anticipated Revenue: None. Impact on City Service Levels by Funding the Improvement: Future financial benefits from membership, including possible funding for changes to service levels, will be in harder -to- measure legislative policy changes. 8 -4 Home Page 1 of 1 r r The Municipal Legislative Cot Mern.berCrty EderrPrairle - si � MorieyhfagaarriesBestFIacetoLrve 3026 MUNICIPAL L � TT ��'ll`j� Home EG .G.d I AT V /'� x ° Who We Are NIL , coMMA�V1 V 1 Our Cities LL I Legislative Initlailvives -14 Suburban Communities- -Over 760,000 Residents- t4LC Breakfast Meetings i -Over 500,000 Employees- MLC News ! I Legislative Delegation i The Municipal Legislative Commission provides a voice at the Capitol for - - suburban communities sharing common demographic, economic and tax calendar 1 base characteristics. Documents _ I Just released: Money Mag a zine Zine names 5 MLC Cities in their Pictures Top 25 Best Places to Live! I ContactUs Eden Prairie ( #1 Best Place to Live) Plymouth Woodbury Eagan Apple Valley I We welcome you to explore our site to learn more about the MLC and our legislative priorities. i Site last modified: 7/22/10, 4:30 PM i Site Ma 8 -5 http : / /www.mlc,mi.org /index.litinl 8/4/2010 Municipal Legislative Commission Page 1 of 1 The Municipal legislative Commission Menibej7Qty: Eden Prairie Aroney Kagazrne sBesfflace to brve, f 2020 r F I 1i Who We Are ' r The MLC was established in 1984 and now provides a voice for the more than 76 5,000 Home residents and over half a million employees who work in our 14 suburban communities. ' • � Wl,o weN The MLC Cities are: our cores Apple Valley Bloomington Legislative Indtattvives Burnsville Eagan g j 't MLCBreakrasIMeetin s Eden Prairie Edina i I MLC Nevis Inver Grove Heights Lakeville Legislatveoetegauon Maple Grove Maplewood carendar Minnetonka Plymouth s '. Documents ' Shoreview Woodbury Pictures j contactus Our communities aren't all the same —some are growing rapidly while others are fully 1 developed; some are primarily residential communities while others contain significant I - - -- commercial developments. Despite those differences, we share common demographic, economic and tax base I I characteristics. We also face similar challenges associated with development and maintenance of public infrastructure, and increasing demand from residents and businesses for effective public services. MLC Board of Directors MLC Operating Com mittee Site Ptao 8 -6 http://www.mlei 8/4/2010 Our Cities Page 1 of 1 f , ..•r.. ::.iii ,. �,�. , ::•i{il' .' The Municipal Legislative Commission b_ hfenrberCfty:£denPrairie koney. &Iagazrne s BestP2ace to Lrve Our Cities :3 The 14 Suburban Communities of MLC are an important part of Minnesota because Home they have - Who We Are • Large Populations l ; our Cities Apple Vail y • Diverse Residents f Bloomjng n Legislative Iniliativives Burnsv Ile • Increasing Population Size ' MLC BrealSasl Meetings Eden Pre i re • Economic Strength and Significance Ed l a MLC News _In ver Grove Reigl is • Over 500,000 City Employees LAev ne LegislativeDelenapp. • Valuable Commercial and Residential Developments Mapie,Grc e Calendar htaplevrobd - Ml nneto a Documents _ aiymoi tl, Find Out About Our Member Cities' Pooulation Growth Pictures shorevibv yJoodbL ry Contact Us Click on a member city to learn more about them, their elected officials and contact information. Apole Valley Bloomington Burnsville Eagan Eden Prairie Edina Inver Grove Heigh is Lakeville Maple Grove Maplewood Minnetonka Plymouth Shoreview Woodbury Site Mao 8 -7 http://www.mlemn.org/our 3/4/2010 i ( 4 MUNICIPAL i t 2010 LEGISLATIVE i Approved by the MLC Board of Directors on 01104/2010 I j i 8 -8 i I SUMMARY OF 2010 LEGISLATIVE PRIORITIES I. Promote accountability in the State & Local Fiscal Relationship A. Eliminate WHC program and convert proceeds directly to aid homeowners and to address the State deficit B. Study fiscal disparities program paid for by fiscal disparities pool C. Support sound LGA principles i II. Invest in Job Retention and Growth A. Support highway and transit investments 1 State GO. bonding investments in highway and transit projects that will help leverage job growth 2. Support public /private partnerships for interchange improvements 3. Authorize public /private partnerships for transit oriented development i. Authorize pilot project for funding Transit Improvement Areas B. Support funding to Department of Employment & Economic Development for job retention and growth C. Support Tax Increment Financing (TIF) district extensions ItII[> Provide Practical Solutions to Litigate "Great Recession Impacts to Cities A. Allow cities to do a mid -year actuarial analysis for volunteer fire relief association's unfunded liabilities D. Reprioritize real estate forfeiture statute to place higher priority on municipal recover of unpaid utility charges and building or development fees 8 -9 i 2010 LEGISLATIVE INITIATIVES The Municipal Legislative Cominission (MLC) has identified the following issue areas as priorities for the 2010 Legislative Session: I. Promote accountability in the state & local fiscal .relationship II. Invest in job retention and growth III. Provide practical solutions to mitigate "Great Recession" impacts to cities i 1. Promote Accountability in the State & Local Fiscal Relationship I A. ]Eliminate MVHC program and convert proceeds directly to aid homeowners and to address the State deficit i I Currently, the State spends almost $300 million reimbursing counties, cities and school districts for MVHC. Based on the $1.2 billion deficit being projected for FY 2010 -11, as well as the significant projected state budget deficit in FY 2012- 13, the MLC believes it would be prudent to take a serious look at whether the i State can afford the MVHC program. Savings generated from eliminating this program could be used to help offset the State budget deficit, as well as to aid homeowners directly on providing property tax relief. The property tax refund program ("circuit breaker ") could be enhanced by the savings generated fioin the MVHC program to provide relief to individuals who need it most (income tested) regardless of where they live. The MLC strongly recommends that the Legislature act this session (2010) to address the growing state deficit, as well as provide local governments with budget planning predictability. B. Study fiscal disparities program, paid for by fiscal disparities pool In 1971, the State of Minnesota instituted a program of commercial - industrial tax base sharing within the Twin Cities metropolitan area. The Twin Cities area fiscal disparities program shares 40 percent of the growth in the commercial - industrial property tax base of the seven comity metro area. Many arguments used in support of the original fiscal disparities law in the early 1970s may no longer be valid. MLC cities ask the State to reexamine this program, specifically asking the following: • How has the program affected property tax disparities across the area? • Are the contribution and distribution formulas reasonable? • Does the program help promote orderly growth and sound land use? 8 -10 a What is the effect of the program on competition for commercial- industrial development between communities? o Do contributions to the pool prevent local govermments from generating sufficient revenues from commercial- industrial development to cover the costs of providing services? o Should the pre -1971 commercial - industrial base continue to be excluded from the formula? o Could improvements be made in program administration? The MLC recommends using the fiscal disparities pool to fined the study of the program. C. Support sound principles on LGA The LGA program has undergone many changes since it was enacted in 1971. It has gone from a revenue sharing program to measuring inequities in city need and fiscal capacity. The measurements of "need" have also been revised to help reduce the - stimulative effects of the aid program. Last year, the Legislature approved the formation of an LGA Study Group. The study group is charged to determine what the goals of the LGA program are, and whether or not the program, in its current form, is meeting those goals. MLC cities do not receive LGA. However, our members believe the LGA program should adhere to the following principles: 1. Equitable — an effective LGA formula should provide similar amounts of aid to similarly situated cities (minimize mechanisms such as "grandfathers" and minimum/maximum aid amounts). 2. Neutral — the LGA program should not encourage cities to spend more than it would otherwise need to for basic services. LGA should be based on factors outside of the individual city's control. 3. Simple and Understandable — attempting to address every unique and special problem with each of the 855 cities in Minnesota causes the LGA formula to be too complex. Factors used to determine aid should have general support and understanding from cities and their citizens. 4. Ability to Provide Adequate Revenue — an effective formula should grow with general city costs, stay relatively stable, and. should be based on factors for which we have accurate information and whose values do not wildly fluctuate from year to year. 8 -11 11, Invest in Job Retention and Growth MLC cities are critical job producers for the region. In fact, our cities combined are among the biggest job producing areas in the state with over 503,000 employees (compared to Miinneapol.is /St. Paul with a combined total of 474 employees) Our Association believes that the State can play a critical role in keeping and growing jobs by making key investments, and by supporting and partnering with cities. A jobs focus will help cities promote a healthy business environment, which will keep and grow jobs here rather than having companies move to a more competitive state. A. Support. highway and transit investments The MLC strongly encourages the State to support: 1. State General Obligation bonding investments in highway and transit projects that will help leverage job growth (i.e. local bridges, local roads with regional significance, Cedar Avenue BRT, Southwest Light Rail Transit...). Note — a majority of highway projects are funded through Trunk Highway bonds as opposed to State G.O. bonds. 2. Public /private partnerships for interchange investments 3. Legislation that would authorize public /private partnerships for transit oriented development i. Implement a pilot project authorizing funding mechanisms for Transit Improvement Areas In 2008, DEED was authorized to establish Transit Improvement Areas. Transit Improvement Areas include parcels of land that are located in part within one -half mile of a transit station. This language was initiated by communities concerned about the lack of tools available to shape development around major transit stations. Although the language passed and was signed into law, there was no funding put into place to implement the new program. The MLC supports the implementation of a pilot project with the authorization of funding mechanisms, such as TIF, tax abatement, bonding and general. fund appropriations for a revolving loan or grant program. B. Support funding to DECD for job retention and growth. DEED has several funds that are used for grants and loans to retain high - quality jobs in Minnesota. The largest of these funds is the Miiulesota Investment Fund, which focuses on industrial, manufacturing and technology - related industries to improve state and local economic vitality (i.e. Medtronic in 2001, Coloplast in 2006, and most recently Innovative Surfaces in 2009). Loans are paid back 1 The Metropolitan Council, - Afetro Stats: Employment Swnmaiy, 2000 -200$ January 2009, < http:// www. metrocauncil .orghnetroarea/Employmetu t�> directly into the fund, malting it nearly self - sufficient. In FY 2009, approximately $2 million was loaned out to qualifying businesses froin the Minnesota Investment Fund. The. Legislature has appropriated $1 - $4 million into the fund since its creation, but has also out their: investment when faced with a budget crisis. The MLC requests the State to maintain its commitment to job creation and retention by investing in DEED, and not make. cuts to the Minnesota Investment Fund to balance the budget deficit. Doing so would send. a strong message to the private sector that we want to retain their businesses, and would like their future expansion to occur in Minnesota. C. Support Tax increment Financing (TIF) district extensions TIF remains one of the most viable tools available to fund community reinvestment efforts. Further restrictions of TIF would render the tool less effective and will likely curtail local efforts to support job creation. In light of the recent economic and. development downturns, cities need greater flexibility to use TIF effectively to support the economic viability of their business and residential conununities. 1. Allow terra extensions for redevelopment districts Recent credit /development market conditions have caused unprecedented delays for some TIF projects. To help offset losses to local governments, the MLC would like to see the State allow terra extensions for redevelopment districts which are taking longer to develop as a result of the current economic crisis. �JCJI. Provide Practical Solutions to Litigate "Great Reeession linpaets to Cities A. Allow cities to do a mid -year actuarial analysis for volunteer fire relief association's unfunded liabilities Under current law, if a volunteer fire relief association has an unfunded actuarial liability, the city is required to address 1 /10 of the shortfall in the following calendar year's budget. The actuarial study is required to be presented to the city council by August 1" so the council can incorporate any additional levy into the next year's budget. The valuation of assets is calculated as of December 31 of the prior year. Many cities complain that on December 31 2008, the fund was at a low point for valuation. of fund investments, and did not accurately reflect the true condition of the fund throughout the year. The MLC supports legislation that would allow for a mid -year actuarial analysis, providing a more accurate picture of the fund's true unfunded liability. 8 —� 3 i B. Reprioritize real estate forfeiture statute to place a higher priority on municipal recovery of unpaid utility charges and building or development fees Under current law, the net. proceeds from the sale or rental of forfeited land must be apportioned as follows: 40% to the county, 40% to the school district, and 20% to the city or town. Based on the county - focused priority structure, cities are at times unable to recover unpaid taxes and utilities. The MLC supports changing the forfeiture statute (M.S. 282.08) to give the proceed distribution priority to a city's unpaid charges for electricity, water and sewer, as well as building and development fees, when the forfeited property is located within a city. The League of Minnesota Cities is also supportive of this change, and our organizations will be working together to implement this statutory change. 8-14 CITY OF SHAKOPEE 2011- 2012 GENERAL FUND BUDGET DIVISION: ADMINISTRATION MISSION STATEMENT: The mission of the Administration Department is to provide for the day -to -day operation of the City government of Shakopee, in accordance with the policies and directives of the Mayor and City Council, and to support the work of the City's six other departments by providing effective and efficient administrative support services. ACTIVITY: The activities of the Administration Department include direction and coordination of all city departments in carrying out the policies established by the City Council, preparation of the annual budget, and making recommendations to the Council regarding existing and new policies and programs. The Department is also responsible for all personnel matters, including payroll and benefits; communications activities, such as the City's website and newsletter; and telecommunications functions including operation of the Public and Government Access Channels. Information technology and facilities maintenance are also part of the Administration Department but are funded through individual divisions elsewhere in this budget. Actual Budgeted Requested Requested 2009 2010 2011 2012 Expenditures $537,590 $755,210 $789,530 $826,200 Population 33,860 34,000 35,100 35,300 Expenditure /Capita $15.88 $22.21 $22.49 $23.41 Number of W -2' issued 390 390 390 Staff 2009 2010 2011 2012 City Administrator 1 1 1 1 Assistant Administrator 1 1 1 1 HR Technician 1 1 1 1 Office Service Worker .625 .6 .6 .6 Communications Coordinator .5 .5 .5 .5 Telecomm Coordinator 1 1 1 1 OBJECT DESCRIPTION: Description of lines items: Supplies & Services: Operating Supplies for Telecom $4,000, R &D Fund $17,000, Office Supplies $6,000, Attorney for HR issues $6,000, Attorney for Telecom issues $5,000. 8 -15 Other Professional Services: Sentence to Service $6,650 ($7,000 for 2012), Position Valuation & Labor Negotiations $5,000, Outsourced Benefits Administration $10,000, Misc. graphic design and photography $2,000, Government Access webstreaming service $9,400. Postage: Delivery of HomeTown Messenger four times /year $13,000, general postage and delivery costs $2,750. Printing /Publishing: HomeTown Messenger $9,800, in -house printing and copying, including Council & TAC packets $7,000, Residents Guide advertising $1,000 and public access advertising $5,500. Software: Payroll and Timesheet Software $36,000, Communications Software (e- newsletter, online surveys) $1,000. IT charges $18,910 ($20,360 in 2012). Training: ICMA National Conference ($1,600 for 2011, $0 in 2012), state managers conference (for 2) $1,200, Effective Management Group participation (for 2) $1,800, Misc. local training for Admin staff $700, General city employee training (sexual harassment prevention, customer service, HR training for supervisors, etc.) $5,000. City -wide safety training and OSHA compliance assistance $25,000, Communications Coordinator training $600, Telecommunications Coordinator training and staff and TAC member conference attendance $4,000. Travel /Subsistence: Mileage $4,400, Meal Reimbursement $500. Dues: ICMA (for 2) $1,600 (same for 2012), MN Managers Association (for 2) $200; Metro Manager Groups (for 2) $200 (same for 2012), Rotary$150 (same for 2012), Misc. $200, HR- related professional organizations (SHRM) $200; Government Communicator's Organization (MAGC) $100, state and national telecommunications groups (MACTA & NATOA) $1,250. Subscriptions /Publications: Administration and HR Publications and Books $700. 8 -16 R5509BUD SH001PV CITY OF SHAKOPEE 8/5/2010 14:18:18 By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 1 Fiscal Period: 7 / 10 Level Of Rollup 6 2008 2009 7/3112010 2010 2011 2012 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget 01000 GENERAL FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4100 SPECIAL ASSESSMENT 4110 SPECIAL ASSESSMENT PRINCIPAL 37,196- 7,857- 2,000- 4111 SPEC ASSESSMENT INTEREST 3,397- 2,837- 4120 SA PREPAY 30,643 3,080- 4100 SPECIAL ASSESSMENT 9,950- 13,774- 2,000- 4200 LICENSES AND PERMITS 4201 LICENSES 60,310- 305,000- 305,000- 305,000- 4200 LICENSES AND PERMITS 80,310- 305,000- 305,000- 305,000- 4400 INTERGOVERNMENTAL 4500 CHARGES FOR SERVICE 4510 ADMINISTRATIVE CHARGES 170- 500- 500- 500- 4500 CHARGES FOR SERVICE 170- 500- 500- 500 - 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 180- 4830 MISCELLANEOUS 180- 4001 REVENUES 9,950- 13,774- 80,660- 307,500- 305,500- 305,500- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 285,779 296,249 198,427 390,980 392,420 403,440 6100 BENEFITS 67,160 82,326 55,026 127,040 119,060 130,040 6001 WAGES & BENEFITS 352,939 378,575 253,453 518,020 511,480 533,480 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 3,250 4,300 1,956 29,000 29,650 33,650 6300 PROFESSIONAL SERVICES 26,275 23,451 9,437 47,170 47,900 49,400 6330 COMMUNICATIONS 24,835 27,313 14,945 42,400 43,710 43,900 6350 INSURANCE 4,530 3,922 5,837 5,740 6,160 6,360 6400 RENTALS 45,905 45,353 46,328 65,480 102,080 110,460 6470 DUES/TRAINING/TRAVEL 14,691 33,729 24,248 47,400 49,050 49,450 6200 SUPPLIES AND SERVICES 119,486 138,068 102,751 237,190 278,550 293,220 6500 DEPRECIATION 6600 MISCELLANEOUS 6700 CAPITAL OUTLAY 6740 EQUIPMENT 20,948 6700 CAPITAL OUTLAY 20,948 6800 DEBT SERVICE 6000 EXPENDITURES 472,426 537,590 356,204 755,210 790,030 826,700 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 4000 REVENUES AND EXPENDITURES 462,476 8 _ 913,816 275,544 447,710 484,530 521,200 R5509BUD SH001PV CITY OF SHAKOPEE 8/5/2010 14:18:18 By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 2 Fiscal Period: 7 / 10 Level Of Rollup 6 2008 2009 7/31/2010 2010 2011 2012 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget 01000 GENERAL FUND 462,476 523,816 275,544 447,710 484,530 521,200 8 -18 F Admin 2011 -12 Budget 2011 2012 2011 2012 2011 2012 0121 0121 0123 0123 0125 0125 Object # Description Admin. Admin. Human Res Human Res Commun. Commun. 6002 Wages FT - Reg. $ 192,470 $ 195,130 $ 94,250 $ 101,250 6005 Wages OT - Reg. 6015 Wages PT -Temp 30,320 31,680 6122 PERA 13,960 14,150 6,830 7,340 2,200 2,300 6124 FICA 14,730 14,930 7,210 7,750 2,320 2,420 6135 Health 46,130 55,360 6139 PEHP 1,200 1,200 6140 Life 1,700 1,700 6145 Dental 1,920 1,920 6170 Workers Comp 1,370 1,390 670 720 220 220 6180 Compensated Absences 6,000 6,000 6185 OPEB Total Personnel 279,480 291,780 108,960 117,060 35,060 36,620 6202 Operating Supplies 6210 Office Supplies 1,500 1,500 1,150 1,150 1,500 1,500 6210 Motor Fuel 500 500 6240 Equipment Maint - Supplies 6310 Attorney 1,000 6,000 6,000 6316 Equipment Maintenance 500 500 6327 Other Prof Services 6,500 7,000 15,000 15,000 2,000 2,000 6332 Postage 1,300 800 600 1,300 13,860 13,750 6334 Telephone 3,000 4,200 6336 Printing /Publishing 5,000 4,000 500 500 11,600 11,50D 6352 Liability Insurance 4,150 4,350 6356 Auto Insurance 300 300 6410 Software 4,730 5,090 41,910 42,270 2,250 2,250 6430 Building Rent (IS FUND) 20,890 20,670 6435 Otherrent 6472 Conf / School /Training 5,300 5,300 30,000 30,000 600 600 6475 Travel /Subsistence 3,500 3,500 550 600 100 6480 Dues 2,100 2,350 200 200 100 100 6490 Subscriptions /Publications 300 300 400 400 Total Supplies & Services 58,570 61,360 97,310 97,420 31,910 31,800 6740 Capital Expenditures Total $ 338,050 $ 353,140 $ 206,270 $ 214 $ 6 $ 68,420 8 -19 Admin 2011 -12 Budget 2011 2012 2011 2012 0127 0127 Object # Description Telecomm Telecomm Total Total 6002 Wages FT - Reg. $ 66,380 $ 66,380 $ 353,100 $ 362,760 6005 Wages OT - Reg. - - 6015 Wages PT -Temp 9 9,000 39,320 40,680 6122 PERA 5,470 5,470 28,460 29,260 6124 FICA 5,770 5,770 30,030 30,870 6135 Health 46,130 55,360 6139 PEHP 1,200 1,200 6140 Life 1,700 1 ,700 6145 Dental 1,920 1,920 6170 Workers Comp 360 400 2,620 2,730 6180 Compensated Absences 1,000 1,000 7,000 7,000 6185 OPEB - - Total Personnel 87,980 88,020 511,480 533,480 6202 Operating Supplies 21,000 25,000 21,000 25,000 6210 Office Supplies 2,000 2,000 6,150 6,150 6210 Motor Fuel 6240 Equipment Maint - Supplies 2,000 2,000 2,000 2,000 6310 Attorney 5,000 5,000 11,000 12,000 6316 Equipment Maintenance 3,500 3,500 4,000 4,000 6327 Other Prof Services 9,400 9,400 32,900 33,400 6332 Postage 750 750 16,510 16,600 6334 Telephone 100 100 3,100 4,300 6336 Printing /Publishing 7,000 7,000 24,100 23,000 6352 Liability Insurance 1,700 1,700 5,850 6,050 6356 Auto Insurance 10 10 310 310 6410 Software 23,950 24,680 72,840 74,290 6430 Building Rent (IS FUND) 8,350 12,400 29,240 33,070 6435 Other rent 3,100 - 3,100 6472 Conf / School / Training 4,000 4,000 39,900 39,900 6475 Travel /Subsistence 750 750 4,800 4,950 6480 Dues 1,250 1,250 3,650 3,900 6490 Subscriptions /Publications 700 700 Total Supplies & Services 90,760 102,640 278,050 292,720 6740 Capital Expenditures - - Total $ 178,740 $ 190,660 $ 789,530 $ 826,200 8 -20