Loading...
HomeMy WebLinkAbout2.e. 2011 Budget Discussion4ROSEMOUNTEXECUTIVE SUMMARY CITY COUNCIL City Council Workshop Meeting June 9, 2010 AGENDA ITEM: 2011 Budget Discussion AGENDA SECTION: PREPARED BY: Dwight Johnson, City Administrator AGENDA NO., ATTACHMENTS: Budget worksheets, level of service options APPROVED BY: DAJ RECOMMENDED ACTION: Discussion Item EXECUTIVE SUMMARY The recommended budget for 2011 proposes a reduction of $42 in the City taxes assessed to a median value home. The City tax levy would decline by 1.54% and the overall reduction in City funding needs would be 2.17 %. With the reduction of $77 in taxes for the median home in 2010, the two year property tax decline for the median home will be $119 or 13.1 %. The median family home paid $1,025 in City taxes in 2009 and would pay $906 in 2011 with this proposed budget. The principal reasons for this decline are declining home values, significant reductions in City debt for the second straight year, a City wide review and prioritization of our levels of service and ongoing improvements in efficiency. Key characteristics of the proposed 2010 budget are shown in the following table: Bu et Facts at a Glance Loss of property tax base from 2010 Average reduction in residential values General fund spending change: Total funding change — all funds Total funding change — all tax impacted funds Change in overall tax levy from 2010 City share of tax impact on median value home Percentage tax reduction on median value home Change in estimated tax rate (City share only) -5.33% -8.12% -0.02% - $369,800 (- 2.17 0/,) - $164,600 (- 1.27 0/.) - $171,768 (- 1.54 %) -$42 -4.43% +5.41% (from .43358 to .45702) BUDGET PROCESS The annual budget process really begins with the adoption of goals and work plans by the City Council early in the year. All participating staff members keep these goals and plans in mind as the budget is developed. One of the goals was to begin the budget process a month early, and a budget calendar was developed to accommodate this new schedule. At the March 16th workshop meeting, staff provided background materials for the 2011 budget including tax base information, a list of grants, and information comparing Rosemount to a number of other similar metro cities. Another directive from the goal setting sessions early in the year was to review our level of services. At the workshop meeting on April 14th, staff presented a list of 30 possible service reductions that were generated from the various City Departments. The list was divided into an A group, a B group and a C group. After discussion, the Council reached consensus that all of the items on the A list should be included for further consideration as well as two items on the B list. More information was requested on several other items. These ten reduction items have been included in the draft budget presented and saved an estimated $91,150. Also, performance measurements for each department, which were initiated last year, have been updated. This draft budget was initially developed by the Department Directors and the Finance Director. I met with each Department Director and reviewed every line item with them. After discussion and a review of historical trends, about 55 individual line items were adjusted. While a few line items were increased, the net effect of the review was an additional net reduction of an estimated $85,360. Revenues were generally estimated by the Finance Director with input from the Departments. In addition, as a part of the budget review, we have looked again at our long range needs for street improvements, equipment replacement, and also reviewed a 10 year projection for the Ice Arena. Finally, we looked at the overall budget strategically one more time for its overall balance, consistency, impact on taxpayers, and long term impacts on finances for 2011 and beyond. Our hope was to develop the most conservative budget possible that: (1) is consistent with council goals (2) is consistent with council direction on levels of service, (3) does not weaken the City's long range financial outlook. (4) is balanced not only between revenues and expenditures, but also is well balanced internally between personnel, equipment, technology, operating needs and capital expenditures. The City continues to look for new savings and efficiencies. We were recently awarded a grant for new, more efficient boilers for the Steeple Center. We have also begun a major review of our City insurance policies to see if we can benefit from higher deductibles since we currently have a large balance in the Insurance Fund. According to state law, the preliminary budget and levy must be adopted by September 15'' and the final budget must be adopted by December 20th after a public hearing. OUTSIDE FACTORS AFFECTING THE BUDGET Tax Base For the second consecutive year, the overall tax base in the community has declined. The overall tax capacity value within the City is estimated to be 5.33% lower in 2011 that it was in 2010. This is on top of a 4.35% decline from 2009 to 2010. The decline in market value of the median home in Rosemount is even more dramatic, with an average decrease in market value of 8.12 %. The overall tax base did not decline by that much because new growth in the community offset some of the decline in existing property values. State Budget and Legislative Impacts Rosemount has not received any Market Value Homestead Credit (MVHC) Funds from the State of Minnesota since October, 2008. We have not budgeted assuming that we would receive any MVHC since 2007. The 2011 budget has been prepared assuming no MVHC funds will be received and the recent adoption of the budget by the State Legislature confirmed this assumption. The MVHC amount for 2010 would have been $429,507 had the Legislature approved it. 2 Levy limits continue for 2011 under current law but would expire after 2011 if no new legislation is approved next year. The draft budget is currently estimated to be $517,084 below the levy limit. Levy limits are calculated based upon an index known as the implicit price deflator as well as a formula for local household and commercial growth. These numbers will not be final until about September 1 st. Although the current levy limit laws do not require us to "use it or lose it," there is a risk that any legislation to extend or introduce new levy limit laws next year may use our current levy as the new base for calculations and give us no credit for reducing levies the last two years. There have been only a few years in the last several decades where some type of levy limit was not in place. Staff is working with our financial advisors to determine if we can substitute "regular" levy dollars for debt levy dollars in our property tax levy, and thus levy close to our levy limit but still reduce overall taxes as proposed in the draft budget. Early indications are that this may be possible. Building Permit Revenues The economy is continuing to slow the growth of the City. The current 2010 budget was based upon an estimate of 100 new homes (60 multifamily and 40 single family homes). For 2011, we are following the revenue trends to date. Most of permit categories should be about the same as we budgeted in 2010, except that HVAC and plumbing permits are trending somewhat lower than our current budget assumed.. SKB Revenues The City approved a new agreement with SKB, inc. in 2008 that will gradually increase our percentage of revenues from SKB's operations in Rosemount over the next several years. However, current revenue collections continue to be hindered by the slow economy. The draft budget continues to designate $400,000 of SKB funds to the operating budgets and $100,000 to the capital budgets which is the same split that the Council approved for the 2010 budget. Emerald Ash Borer threat Recently, the Emerald Ash Borer was discovered in the St. Paul area which poses a major threat to Ash trees throughout Minnesota. Rosemount has a number of parks, right -of -ways, and public spaces with Ash trees that may be threatened. While no emerald ash borer insects have been verified in the immediate Rosemount area, it is important to consider the long range threat in looking at future City finances. The City receives $25,000 annually from SKB specifically designated for landscaping. It is staff's intention to designated these funds principally to prepare for the Emerald Ash Borer threat during the three remaining years we are scheduled to receive these funds (2011- 2013). REVENUES Property taxes fund 83.1% of the General Fund budget and 66.5% of the overall City Budget. As noted above, our tax base is decreased by 5.33% for 2011. However, there are several other categories of General Fund revenues that are also important to the City. The chart below compares budgeted revenue for 2010 with estimated revenue in 2011 for several key categories of revenues. As can be seen, non -tax revenues have stabilized at their relatively low 2010 levels. Licenses and permits continue to decline mainly due to expected reductions in plumbing and HVAC permits. 3 2010 Budget 2011 Estimated Change Licenses & Permits $382,600 $360,100 ($22,500) Intergovernmental $566,500 $622,500 $56,000 Charges for Services (no SKB) $255,900 $258,400 $2,500 Fines & Forfeits $125,000 $125,000 $ 0 Recreational Revenues $267,300 $252,300 ($15,000) Miscellaneous Revenues $178,200 $181,300 $3,100 SKB revenue (General Fund) $400,000 $400,000 $ 0 As can be seen, non -tax revenues have stabilized at their relatively low 2010 levels. Licenses and permits continue to decline mainly due to expected reductions in plumbing and HVAC permits. 3 Intergovernmental revenues are up mainly because of increased gravel tax revenue from Dakota County and increased cable TV franchise taxes. Recreational revenues are down due to the elimination of the Tiny Tot program for which there is a corresponding decrease in expenditures also. EXPENDITURES Salaries and Benefits Rosemount employs 80 full time employees. No new full time or part -time employees are proposed in this budget. Contract settlements were reached with all four City bargaining units earlier this year for both 2010 and 2011. With contracts in hand, the City will not need a salary contingency as a part of the 2011 budget. The budget includes a 1.5% salary increase as required by the contracts for 2011. Health insurance contract renewal will not occur until later this summer. A 10% increase in health insurance premiums has been assumed in this first budget draft. State mandated increases in PERA employer contributions are also included in the budget. Utility and fuel cost assumptions. Electric and natural gas bills for 2011 have been estimated based on recent consumption trends with a 5% increase added based upon pending rate adjustment requests. Fuel costs for 2011 will not be very predictable until December when we will sign a new fuel consortium agreement with the State. In this draft budget, we are lowering the expected price of fuel from $2.80 per gallon to $2.65 based on current market conditions. It should be noted that the price the City gets is not directly comparable to what consumers pay because we can buy in bulk, make purchases through a consortium, and do not pay the same taxes consumers do. Steeple Center (former St. Joe's Church) The proposed budget continues to include operating funds for the Rosemount Steeple Center (former St. Joe's church). The center is expected to open in July, 2010. Since a full year of expenditures and revenues were included in the 2010 budget, there is no significant new impact on the 2011 budget. The budget shows $87,500 in expenditures and $13,500 in revenues (see page 55). Over half of the expenditures ($46,000) are for gas and electric utility bills. Capital Budgets The City currently has three capital improvement program (CIP) funds: Equipment, Streets, and Buildings. In the Equipment CIP, a long range study of vehicle needs was accomplished as a part of the 2010 budget. That study was reviewed and updated for the 2011 budget. The 2010 study showed that a $25,000 increase in the Equipment CIP levy was indicated for 2011 because of long range weakness in the fund, even after extending the projected life -cycle of a number of vehicles. However, further review this year indicates that the levy can remain the same for the Equipment CIP due to payment of outdoor warning sirens and police records management system software from 2009 surplus funds. The actual analysis of whether any vehicles will be recommended for replacement in 2011 has not yet taken place and will be presented at a future meeting. The CIP budgets will be presented in more detail at a future meeting. The Street CIP is proposed to have a levy of $710,000 for 2010. The long range plan developed in August 2010 showed that the levy should increase 6% annually to meet future needs. The six percent was based upon a combination of inflation and the construction of new streets that will begin to need maintenance. However, since inflation has been very low and the construction of new streets has also been minimal due to low growth, this levy is proposed to increase by only 1.4 %. The Building CIP has a levy of $44,000 for 2011 which includes repayment of an internal loan for the current Public Works facility and $20,000 for general repairs and upgrades to the Community Center 4 building. Wager damage to the building near the south door has been evaluated recently and will probably need repairs. Other building equipment such as the windows, restrooms, light controls and HVAC equipment also need repairs or improvements. The SKB funds currently designated for Capital Improvements ($100,000) are being allocated to the Building CIP fund.. Enterprise Fund Budgets The water, sewer, and storm sewer budgets do not show any major new projects or initiatives. As usual, funds are budgeted in each account for any utility work that must be done in relation to our our annual street improvement project. Water and sewer rates were changed last winter to comply with DNR requirements for tiered water rates and also to boost revenues by 4 -5 %. No changes in rates are proposed for 2011. The Ice Arena budget also was also reviewed using a 10 year forecast for needed improvements and currently appears to be stable with the current amount of support from the General Fund ($115,000). Debt Service Funds The City ended 2009 with a General Fund surplus. The Council approved a strategy that committed about two- thirds of the surplus to paying off existing debt, similar to what was approved a year ago with the 2008 surplus. Enough funds were available from the 2009 surplus to make all of the remaining debt service payments on two debt issues, saving $190,000 in tax levies for 2011. Implementation of this strategy is once again a major reason why we have been able to propose an overall reduced tax levy for 2011. CONCLUSION While it is always a challenge to draft a budget in a time of declining revenues, staff is pleased to present a draft budget for 2011 that will reduces the City tax burden by an additional $42 for the resident in a median value home while still maintaining our most important services. This tax reduction is in addition to the $80 decrease adopted for 2010. We believe that the proposed budget is appropriately conservative for the current economic situation, but also keeps us as ready as possible to accommodate economic recovery when it occurs and allows us to continue to address the Council's goals. We look forward to discussing it with you. I List of Possible Service Reductions Grouped in Order (not in any order within the groups) A List: not necessarily recommended, but should be considered. 1. Begin charging athletic teams a maintenance fee. $25,000. A number of other cities are now doing this. 2. Cut herbicide and fertilizer applications at athletic fields in half. $17,000. This will detract from the overall appearance of the fields, but may have some environmental benefit. 3. Reduce City newsletter frequency from five to three. $10,000. Other cities are doing this. This may go against the Council goals and priorities relating to Communication, but increasing use of electronic communication can help fill the gap. 4. Reduce temporary salary budget for coverage of front reception desk. $7,000. When the City was busier, it was more of a problem for other departments to fill in, but this is not a major concern now. 5. Eliminate web streaming of council meetings. $5,000 - $10,000. This also may go against our adopted goals for Communication. However, from a business viewpoint, it costs about $15 for every user of this benefit and is not cost effective. Since this service is part of our Joint Powers Agreement with Apple Valley and Farmington, it is not clear if we can unilaterally change this. 6. Park Brochures. Reduce from four per year to three. $15,000. Other cities are also doing this. This makes marketing our recreation programs more difficult, but the impact may not be material. 7. Reduce travel /conference budgets. $25,000? While we think it would be counterproductive to eliminate all travel and conferences, since some are necessary for continuing education or certificate requirements, there may be room to reduce the amount without causing significant problems. 8. Reduce overtime. $5000- 10,000? A few projects or activities would take longer, but careful management could reduce the negative effects. This item needs to be reviewed in context of other items selected, since some could actually increase overtime costs. Subtotal: $109,000 to $119,000 B List: Items that are not necessarily recommended, but can be considered. Generally more direct impact on the public or staff than the A list. 1. Reduce janitorial service at Fire Station 1 from twice a week to once per week (same as Station 2). $3,500. While this would have no direct impact on the public, it may require some degree of extra cleaning work from firefighters (who get $2 /call). Station 1 is also a remote office for Health East ambulance crews. 2. Fleet maintenance: cut outside contract budget in half $12,500. This will result in some delays in certain kinds of repairs, especially for large items such as snowplows and fire trucks. 3. Reduce dust control on gravel roads. $17,500. (1/2 of current funding). Calcium chloride is applied to all gravel roads once per year. This proposal would apply it only to the more densely populated rural areas west of Akron Avenue. May raise some questions about equality of service between east and west sections of the City. This will produce some complaints. 4. New sidewalk /trail budget. Cut funding for new sidewalks and trails in half. $57,500. This would reduce our ability to match grants for trails or take advantage of lower costs of installation with nearby road reconstruction projects. However, it is doubtful that very many cities are proceeding with new trail and sidewalk construction in this economy. 5. Planters and horticulture. Eliminate planters, brackets and all planting around park signs and gardens. $11,500. This would be a step back in our "marketing" of our downtown and park areas, but a number of cities are doing this. 6. Street equipment rental. $20,000. Eliminate the rental of a lift for downtown decorations, flowers, and Christmas lights. This would eliminate the installation of these items, since using a loader vehicle for installation is not approved by OSHA. Also eliminated: the rental of a water truck for maintenance of gravel roads. 7. Finance - reduce internal support for items such as insurance claims and fixed asset tracking. $16,800. May result in lesser ability to meet all recommendations of our auditors and /or burden other staff beyond 50 hours /week. 8. Cat licensing. Remove cat licensing requirements from City Code. $8,000. Most other cities do not license cats. We pay impound fees for stray cats picked up and not claimed. May result in about 50 unanswered cat complaints per year. 9. Two officer police squad. $3,500. If officers double up on one shift, one squad could be parked saving fuel. Mileage savings may result in one less car traded in every five years. There would be less officer visibility and slightly higher average response times. However, situations normally requiring a backup car could be handled by one two- officer squad. 10. Reduce reception support staff by 8 hours per week. $10,450. Requires other staff to fill in. In the current situation, it would not be a great hardship for other staff to fill in. This may not be readily sustainable if growth picks UP. 11. Park and Recreation program reductions. $28,000. This would require reduced recreation staffing and would likely impact special projects such as work with Eagle Scouts, clean up days, art in the park, and support for Leprechaun Days and Haunted Trail. Other possibilities are fewer portable toilets in the parks, reduced cleaning schedules in the community center or eliminating the Arbor Day tree giveaway. 12. Reduce GIS support. $29,100 (1/2 position). This would reduce our ability to create our own maps and graphics for City documents such as the Comprehensive Plan, planning reports, etc. Our ongoing effort to get recent mapping documents in electronic form would also come to a halt. 13. Eliminate credit card payments for City services. $20,000. Credit card companies charge fees which are non- recoverable under our contract with them. A significant convenience for both residents and builders would be lost, and the City may have a higher incidence of collection problems as a result. Future on -line opportunities would also be curtailed. 14. Stretch replacement time for park facilities such as playgrounds and ice rink boards. $32,500 (1/2 of current funding). We would have to be careful not to allow any material safety problems to develop. Subtotal: $270,850 C List: Not recommended. Fairly substantial impacts on the public or staff with an increased risk of unintended consequences. 1. Eliminate janitorial service for both fire stations and public works. Reduce janitorial service for City Hall in half. $34,000. Would require substantial effort from a number of staff causing a misallocation of resources (e.g. $35 /hr employees doing $15 /hr work). More extensive version of B -1 above. 2. Fleet maintenance. Eliminate all outside contracting. $25,000. Major delays in repairing /maintaining some items of equipment. Full version of item B -2. 3. Reduce parks /public works maintenance. $87,500 to $187,500. This would entail a reduction in force of both full time and seasonal employees. Impacts would be seen with increased snowplowing time, no flowers, no special projects, longer response time for patching and sweeping streets, reduced field maintenance (striping, dragging), less frequent mowing and trimming. 4. End Police Drug Task Force participation. $90,000. Impact would be to lose 50 investigations per year leading to 20 persons charged per year. 5. Reduce police patrol. $90,000 - $180,000. May result in higher response times, less officer initiated activity, and more overtime. Some of these impacts could be partially mitigated if we eliminate DARE, Citizen Police Academy, and Night to Unite activities. 6. No new firefighters hired. $6,700. Goal to reach 50 not reached to fully staff two stations. Current level of 42 firefighters may be hard to maintain due to retirements. 7. Fire training /education activities eliminated. $4,900. This would eliminate all new training and education activities in the schools, etc. Only training needed to retain certifications would continue. 8. Completely eliminate one reception support staff. $52,700. Full version of item B -10. This would entail either a major impact on other departments to cover the front desk, or implementation of a phone tree /buzzer system to let staff know when a resident needs assistance. Staff has not yet worked out a reasonable scenario for how this would work. Subtotal: $390,800- $580,800 Total: $744,200- $943,900 after duplication of B1, B2 and B10 removed co FUNDING REQUIREMENTS - USES (INCLUDING FIRE STATION LEVY) May 28, 2010 "$2,060,560,350 x.00798% _ $164,433— Water Enterprise Fund 2010 2011 (181,100) - 13.38% Sewer Enterprise Fund Adopted Proposed 6,600 +/- Departments Budget Budget Difference Percentage Council Budget $256,500 $237,100 ($19,400) -7.56% Administration Budget 520,300 514,200 (6,100) -1.17% Elections Budget 40,000 22,000 (18,000) - 45.00% Finance Budget 422,300 420,800 (1,500) -0.36% General Government Budget 387,700 385,100 (2,600) -0.67% Community Development Budget 945,700 969,200 23,500 2.48% Police Budget 3,030,300 3,106,200 75,900 2.50% Fire Budget 301,800 301,600 (200) -0.07% Public Works Operating Budgets: Government Buildings Budget 490,200 491,900 1,700 0.35% Fleet Maintenance Budget 612,300 568,600 (43,700) -7.14% Street Maintenance Budget 1,331,300 1,342,400 11,100 0.83% Parks Maintenance Budget 723,900 730,100 6,200 0.86% Park & Rec Budget - General Operating 1,077,500 1,069,500 (8,000) -0.74% Park & Rec Budget - Steeple Ctr. Operations 87,500 87,500 0 n/a Park & Rec Budget - Special Programs 123,700 102,400 (21,300) - 17.22% Transfers - Arena Assistance 115,000 115,000 0 0.00% Total Operating Budgets - General Fund $10,466,000 $10,463,600 ($2,400) -0.02% Building CIP Requirements 24,000 44,000 20,000 83.33% Street CIP Requirements 700,000 710,000 10,000 1.43% Equipment CIP Requirements 439,000 439,000 0 0.00% Insurance Budget Requirements 275,000 275,000 0 0.00% Port Authority Operating Levy 50,000 48,600 (1,400) -2.80% Bonded Indebtedness 729,471 531,290 (198,181) - 27.17% Bonded Indebtedness - Fire Station Levy 142,273 143,654 1,381 0.97% Armory Anticipatory Levy (Value 2/18/10) 80,000 86,000 6,000 7.50% "$2,060,560,350 x.00798% _ $164,433— Water Enterprise Fund 1,353,900 1,172,800 (181,100) - 13.38% Sewer Enterprise Fund 1,671,300 1,677,900 6,600 0.39% Storm Water Enterprise Fund 670,300 672,200 1,900 0.28% Arena Enterprise Fund 458,000 425,400 (32,600) -7.12% Total Funding Requirements $17,059,244 se =ammxxas $16,689,444 ($369,800) ���- -xaem: =aaaez��x - -2.17% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. oa May 28, 2010 Types FUNDING REQUIREMENTS -SOURCES (INCLUDING FIRE STATION LEVY) Internal Revenue Generated: Licenses and Permits Intergovernmental Charges for Services Fines & Forfeits Recreational Fees Miscellaneous Revenues Transfers In Enterprise Revenues Total Internal Revenues MVHC Cuts Made Later To Include in Levy Levy Sources: Special Levies General Levy Total Levy Loss of MVHC from State Funding Total Revenue Sources 2010 2011 Adopted Proposed +l- Budget Budget Difference Percentage 382,600 360,100 (22,500) -5.88% 566,500 622,500 56,000 9.89% 655,900 658,400 2,500 0.38% 125,000 125,000 0 0.00% 267,300 252,300 (15,000) -5.61% 178,200 181,300 3,100 1.74% 3,500 3,500 0 0.00°x6 4,153,500 3,948,300 (205,200) -4.94% 6,332,500 6,151,400 (181,100) -2.86% 412,575 429,507 951,744 760,944 (190,800) - 20.05% 10,187,575 10,206,607 19,032 0.19% $11,139,319 $10,967,551 ($171,768) -1.54% $412,575 $429,507 $16,932 4.10% $17,059,244 $16,689,444 ($369,800) -2.17% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. C -D 3 2010 GENERAL PROPERTY TAX LEVY PAYABLE 2011 GENERAL FUND $8,690,007 BUILDING CIP FUND $44,000 STREET CIP FUND $710,000 EQUIPMENT CIP FUND $439,000 INSURANCE FUND $275,000 PORT AUTHORITY OPERATING LEVY $48,600 TOTAL GENERAL LEVY $10,206,607 BONDEDINDEBTEDNESS G.O. PUBLIC FACILITY BONDS 2001 C (Port Authority) (Authorized - $168,914) $168,914 G.O. COMMUNITY CENTER REFUNDING BONDS 2001E (Authorized - $91,883) $0 G.O. IMPROVEMENT BONDS 2003A (Authorized - $86,354) (City Assumed Special Assessments) $86,354 G.O. CAPITAL IMPROVEMENT PLAN (CIP) BONDS 2005A (Authorized - $210,764) $210,764 G.O. EQUIPMENT CERTIFICATES 2006A (Authorized - $87,150) $0 G.O. IMPROVEMENT BONDS 2006B (Authorized - $268,201) *"*"" Evaluate after 1st half taxes'""""' $0 G.O. EQUIPMENT CERTIFICATES 2007B (Authorized - $107,022) $0 PUBLIC SAFETY REVENUE BONDS 2007 (Dakota Communications Center) (Authorized - $65,258) $65,258 G.O. EQUIPMENT CERTIFICATES 2008A (Authorized - $94,265) $0 TOTAL BONDED INDEBTEDNESS $531,290 MARKET VALUE BASED REFERENDUMS G.O. FIRE STATION REFUNDING BONDS, 2005D (Authorized - $143,654) TOTAL FIRE STATION LEVY PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($2,060,560,350 x.00798% = $164,433) (As of 2/18/10) (Authorized - $164,433 - Only Levy Amount Due MSABC) TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS GRAND TOTAL 2010 PROPERTY TAX LEVY Last Updated 5127110 $143,654 $143,654 $86,000 $86,000 $10,967,551 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) (Proposed) 2008 2009 2010 2011 Total Funding Requirements 17,855,312 17,288,034 17,059,244 16,689,444 Less: Internal Revenues 6,526,300 6,210,900 6,332,500 6,151,400 Less: Market Value Based Levy - Fire Station (See Below) 144,417 146,084 142,273 143,654 (3) Equals: Revenues Needed 11,184,595 10,931,050 10,584,471 10,394,390 Add Back in State MVHC Cuts to Reflect Actual Levy 0 350,330 412,575 429,507 Levy Certified by City to County Auditor 11,184,595 11,281,380 10,997,046 10,823,897 County Auditor Adjustments (Ali Subtractions): Fiscal Disparities Distribution Levy (Metro Area) 968,892 1,141,159 1,195,913 1,195,913 (2) Spread Levy Used to Compute Local Tax Rate 10,215,703 (1) 10,140,221 (1) 9,801,133 (1) 9,627,984 Ihcrease /(Decrease) from Previous Year in Spread Levy -0.74% - 3.340/9 -1.77% Market Value Based Referendum Levy - Fire Station 144,417 146,084 142,273 143,654 (3) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2011 Number Provided by Dakota County as of x1x110 (3) Market Value Based Levy for Fire Station - Based on $143,654 Levy Spread to Taxable Market Value on 2118110 Last Update from Dakota County 2/18110 Shows the Levy of $143,6541 $2,060,560,350 = $.0697 per $1,000 as our Estimate Last Updated - 5127/10 a a mO�= o PyC) o xm o m 'n mNno � m m v Dr O Q m w x m m o �i D?a PTO nm mm 3� c nn m m a m am (] yo nm m q,� 3ulo Amg m m s o m m o 7 n m m m c m c 3 m �O `Z ,2 o D �mp� �O� o J°'A �4 d3 0 $s. g�. Amm z m m w� -mom w= x �A�m = _pa a ° it it t U� O8 O O it �Op O O O O N I 98 O O „ p 11 � W ++ 88Qp8 II .p SNaN A � I II N + S88OQQy ^I tl + S+(pN�pN N II O +�NN +�N OOD V W w II pD +m A � • V +N+ II W m +NN S ( II +N m �A J +N+ 0 pl tl +NN 11 it it 1 II II II it y� pQO 8O 8O �� fps �� O 8O O8 �I + it II �p ?p1 N A ++ a+^+Q II 8� �pSpp tNUJ W d' O ppO 11 �!pJ yp + �p �p m ^+p 11 8+ SN V(W� it II (h O +OI m �O W J1DN$ 11 N J +m m s O II N ON W( Om W N $N ml ��mUC O O it 11 I O p O O II l O II O Op O It O I N O I I p� O N N° I 11 N 1 �p +o +p+1ppN II �.W�fD �S{pp N V tT oa T 11 N " A m1N II W Sp tUJ ml m 11 O�D O +mN I (m 41J W O� N 11 A I m two to O S I .^w' II S A +V 8 W Nm oN II m V +bN + m N 11 tl V+ tl N 11 W O m W m N v + II 11 N u 11 11 p 999 I" 11 O O O p I C tOp 0000 8N Ij II v p 1D y pNp + +Np M p S per_ N N (OU1 tD 11 !V !J N 11 S S o +mN1N N dj ° C II A Y 011N��ODr 01 V tl) P pN�1 Wv N m I QI IpN W O 11 N +pAG++ I ONN � w lo 11 mltlN(NJ A T T OI$ II +NNmI O + +A 3 p a 11 V +JtU ml W NN W � dS' x II Y It I II II q 11 OOO It i Q1p' ii It u o00o N II „ mp �i <p 888 p II Y �Op 01010 N m; Ay U II N N y1 m I�y�J1 x 8 O 2 w it O 4 3 r 'I ii ii ii N i II II Fan n n m �S II II o0o It o it o00 0+ a+ m yet it &m�; IINi _ pQg$° IIO O9oP + IIp� pqq II. 4000 + 3 $ m n g Y, y 11:q II W yW EAU N V m �+1Ny II WW Spw N V "s a II V 1 N tpN�p `+� W �`p NIV�� N wm 2 O a 9 g Il N 11 O W t90 N V S Nml N II A N-w O 11 N I +N OAm1 m1�N Y S 0Ym01 �p1 + - O I ~'9 ...SSSS OYim II fp V +tON 11 Im Nmm V J V mm o m II f0 V+fON A D� I tl < p Z a m 0 0 0 I+ 0 0 0 O $•� m S m ,'Ox NO II N OIV IJA W II N + N tl GIV IJA N V Oml oo q yQpp ,� �i Jmw it y 4 +4 pA A+ N °O ��� 6S w'O ��ppW+ I; IlNm�1{mm�1WN Ilm A+N MOb+ KKMM J C s J Q 0 N V m 11 W m A m W 11 N O V W+ m m tl m low o p m 1p + W m m Sim bib a_ m_ xo 0080 11 t °p p 11 OpO SOQ� Y� p O m M pAp I[N�J x 11 8�Ap tNT 1V� W N +p N m > X ft N ONN 1 II 0 +V +m °� A ow" 11 Q G1m01 W 0 O n m A OO1I n ¢¢ 3 d v v r w �N Il tl Avv+ II +w A J +tl� 25 m m ? .. it ff t J m T !D 3 coo 11 N II 80 SO0 N O pV 3v pH N x 11 IV 8N �O Op IJ IJA N + v If A sV 11 (J� spy (gym ♦p m 11 ° ° tAp W (UN `�' 11 mmlmV�pV N w O +A W II 8 W m A O I g 11 A + m V th NQ O N II p V +tON 01 0 v N Qm;I Ny A+ Nm 11 m m A SI J p O g O it 11��D (((mmmpppI Np mm (.pN�m na +p+ Q�8Q8QQjN8Q8Q4 It 6 m I v W N OI O A OnS N N O V W w II I 8�(N�N Y W N ,lQSI.N m mp aQ r, 11 N h D m_f+pp� W 8W O DD 11 C it N $ OO QQQQ 11 II go o 1pt >> II W m a + o II + °Q N O ONIV A + & it m 0 H po g OONIN II 8+ jdd�511 11 8r �mSp ml lmV��Wp !81 O 8 Om OS o0 3e •�. O0N II tU I �� N f Ixl O NODo n Nml OJ +�N II m V lm+Y 1000 O O o _$ 33_, o0o II N x o00 11 ^a 4.2 � T p v� (p(pJJ pm `JQg8�' 11mJ� II �(.jCyD I IV IJ A x O N qSQ l^8�l? pp °Q8 II (lOy1 �Sp N V (AJI T SIP , N O A m O O e� m 11 1 p i D O w I O lat N v b `b' ^mm' WW I I AW V m Nm o V 8W OD N II O N O N N p Q vvv vv N+ OON V�. o O 3 b l � ell Page One 2011 BUDGET WORKSHEETS GENERAL FUND REVENUES May 28, 2010 Account # Description 101 31010.00 Current Ad Valorem Taxes 101 31040.00 Fiscal Disparities Total Taxes (Tax) 101 32110.00 101 32160.00 101 32162.00 101 32210.00 101 32212.00 101 32220.00 101 32221.00 101 32230.00 101 32240.00 101 32250.00 101 32255.00 101 32260.00 101 32290.00 101 31010.00 101 31010.01 101 31020.00 101 31030.00 101 31710.00 101 31810.00 101 31811.00 101 31920.00 101 33100.00 101 33416.00 101 33416.01 101 33416.02 101 33418.00 101 33423.00 101 33425.00 101 33620.00 101 33630.00 101 33630.00 Alcoholic Beverage Licenses (L) Licenses to do Business (L) Lic to do Business - Rental Housing (L) Building Permit Revenue (L) Mineral Extraction Permit (L) Elwrical Permit Revenue (L) Admin Fee - Electrical Permits (L) Plumbing Permit Revenue (L) Animal Licenses (L) Sewer Permit Revenue (L) County Recording Fee -City's (L) HVAC Permit Revenue (L) Other Non -Bus Lic & Permits (L) Total Licenses & Permits (L) Current Ad Valorem Taxes (1) MSABC Armory Payments Delinquent Ad Valorem Taxes (1) Mobile Home Taxes (1) Gravel Taxes (1) Franchise Taxes - Regular Fees (1) Franchise Taxes - PEG Fees (1) Forfeited Tax Sale Apportionment (1) Federal Grants & Aids (1) Police Training Reimbursement (1) Post Board Training Reimb State Aid (Tied to PERA) MSA for Streets - Maintenance (1) Ag Preserves Credit (1) Other State Grants & Aids (1) Other County Grants & Aids (1) Police Services Levy -ISD #196 (1) Liaison Funding Total Intergovernmental (1) PAGE TOTALS 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $5,920,729 $6,732,360 $6,697,852 $7,503,662 870,514 968,892 1,141,159 1,195,913 6,791,243 7,701,252 7,839,011 8,699,575 (412,575) 8,287,000 34,525 32,657 36,035 34,000 6,390 7,730 8,430 7,500 0 13,191 1,345 0 435,956 489,002 281,984 200,000 740 2,180 1,480 2,000 15,626 15,795 13,238 15,000 9,040 7,990 7,040 8,000 57,039 53,994 30,058 45,000 2,829 2,442 2,663 2,000 13,773 7,252 6,585 8,000 80 30 100 100 73,866 66,133 41,073 60,000 770 360 520 1,000 650,635 698,755 430,551 382,600 91,000 91,000 80,000 80,000 110,316 139,641 150,317 0 10,635 8,834 15,330 9,000 18,811 15,348 13,390 15,000 158,698 169,415 185,886 160,000 23,936 23,905 25,001 22,000 0 0 0 0 0 0 0 0 147,061 147,847 145,036 7,000 138,000 29,115 29,115 30,165 29,000 1,163 628 659 500 35,475 21,882 44,537 21,000 15,400 82,803 60,100 19,000 68,727 63,620 64,603 66,000 710,336 794,038 8,152,214 9,194,045 815,023 566,500 9,084,585 9,236,100 86,000 7,500 139,500 60,000 i $7,494,094 From County 1,195,913 From County 8,690,007 Total Property Tax Levy for Fund 101 (429,507) State Cuts in MVHC 8,260,500 Actual Property Taxes to Receive 40,000 7,500 Garbage Haulers, Pod Licenses, etc. 1,000 200,000 1,500 13,000 7,000 35,000 2,500 7,000 100 45,000 500 Alarm Permits & Fireworks Permits 360,100 86,000 Included in Debt Levy Figure 0 From County 9,000 From County 45,000 From County 180,000 From Cable Company 25,000 From Cable Company 0 From County 0 147,000 From State 30,000 From State 500 From State 21,000 From State -PERA Aid & Safe & Sober 19,000 Dakota County Recycling Funds 60,000 From ISD #196 622,500 9,243,100 Page Two May 28, 2010 Account # 101 34103.00 101 34104.00 101 34105.00 101 34106.00 101 34107.00 101 34108.00 101 34108.01 10134108.02 101 34109.00 101 34110.00 101 34112.00 101 34113.00 101 34150.00 101 34151.00 101 34151.00 101 34151.00 101 34152.00 101 34153.00 101 34160.00 101 34160.00 101 34160.00 101 34201.00 101 34202.00 101 34203.00 101 34204.00 101 34206.00 101 34207.00 101 34207.01 101 34207.02 101 34207.03 101 34303.00 101 34306.00 101 34310.00 101 34407.00 101 35101.00 101 34719.00 101 34720.00 101 34721.00 101 34722.00 101 34724.00 101 34725.00 101 34726.00 101 34727.00 10134727.01 101 34727.02 101 34728.00 101 34730.00 101 34731.00 101 34732.00 101 34733.00 101 34735.00 101 34736.00 101 38080.00 101 38081.00 101 38082.00 101 38086.00 101 38096.00 101 38097.00 101 38154.00 101 38201.00 101 38203.00 101 38205.00 101 38207.00 101 38209.00 101 38211.00 101 38215.00 D-? 2011 BUDGET WORKSHEETS GENERAL FUND REVENUES 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Description Actual Actual Actual Budget Amount Budget Comments Zoning & Subdivision Fees (C) 76,425 39,000 28,215 40,000 35,000 Plan Checking Fees (C) 185,934 174,452 89,352 70,000 80,000 Sales of Maps & Publications (C) 1,859 1,102 517 1,000 1,000 Maps & Spec Books Deputy Registrar Fees (C) 56,373 58,703 8,731 0 0 Dakota County Took Over Feb. 2009 Assessment Searches (C) 0 0 0 0 0 Admin Fees - Other Funds (C) 47,750 25,000 Applicable Funds Except Const. 25,000 25,000 25,000 25,000 25,000 Construction Funds 96,785 91,434 79,141 0 0 Other Charges for Service (C) 7,749 8,309 7,074 7,000 7,000 Service Chg on Returned Chks (C) 270 180 90 200 200 Utility Permit Application Fee (C) 1,550 2,129 0 1,000 1,000 Application Fees (C) 0 5,000 0 0 0 User Fees - SKB (C) 315,490 339,518 128,745 200,000 200,000 SKB Fees - C & D Cell Fees User Fees/Host Agreements - SKB(C) 25,000 25,000 102,955 105,000 105,000 Landscaping Agreement 25,000 Landscaping Agreement (Yr 8 of 10) Trust Fund - City Portion 80,000 User Fees - SKB (C) 0 0 8,782 20,000 20,000 SKB Fees - MSW Ash Charges User Fees - SKB (C) 0 0 100,491 100,000 100,000 SKB Fees - Base Service Charges National Guard Maint Fees (C) 47,488 51,445 47,488 46,000 46,000 Shared Space Rental Agreement 16,000 Building Maintenance Contract 30,000 Special Police Services (C) 23,145 52,675 18,199 21,000 19,000 Contractual Orr for Officers Fire Services - Burning Permits (C) 300 800 300 0 0 No Longer Charge for Permits Accident Reports (C) 5 19 0 0 0 Day Care Inspection Fees (C) 250 100 350 200 200 Other Police Services (C) 176 713 12,944 0 0 Other Fire Protection Services (C) 15,655 21,510 15,700 15,000 U of M Fire Contract 6,000 6,000 Coates Fire Contract 4,000 4,000 Other Billed Fire Calls 5,000 5,000 Mow Weeds (C) 2,448 2,551 1,662 1,500 1,500 Other Highway & Street Rev (C) 2,852 20,551 6,245 0 0 Street Light Bills - Developers Right- cf-Way Permits (C) 0 17,990 4,934 0 0 City Share of Metro SAC Chgs (C) 3,594 6,742 2,209 3,000 2,500 Total Charges for Services (C) 888,346 992,674 689,124 655,900 658,400 Court Fines (F) 120,093 127,239 121,618 125,000 125,000 From County Total Fines & Forfeits (F) 120,093 127,239 121,618 125,000 125,000 Player Maintenance Fees (R) 0 0 0 0 9,000 New Fee for 2011 Park Reservations (R) 2,417 4,881 3,789 2,500 3,500 Softball Revenues (R) 61,401 64,980 54,636 60,000 54,000 Volleyball Revenues (R) 0 0 0 0 0 Tennis Revenues (R) 2,354 2,522 2,016 2,300 2,000 Tiny Tot Revenues (R) 21,932 18,334 13,674 22,000 0 Eliminated Program Rosettes Revenues (R) 510 1,110 1,625 1,200 1,600 Field Trip Revenues (R) 7,300 4,500 Youth/Teen Trips 4,988 4,658 799 0 Adult/SeniorTrips 1,749 1,735 3,897 4,500 Adult Soccer League Revenues (R) 13,741 10,391 0 0 10,000 No League in 2009 Run for the Gold Revenues (R) 3,971 4,397 4,659 4,000 4,600 Youth Soccer Lessons (R) 1,980 3,335 3,648 2,000 3,500 Adult Basketball! Revenues (R) 2,108 1,406 1,870 2,000 2,000 Other Programs Revenues (R) 16,227 13,468 13,981 14,000 14,000 Camps Revenues (R) 13,028 13,095 15,960 12,000 14,000 T -Ball Lessons (R) 5,176 5,287 5,092 5,000 5,000 Banquet Room Fees (R) 64,852 75,555 60,413 65,000 62,000 Auditorium Fees (R) 6,219 6,059 7,331 7,000 7,000 Gymnasium Fees (R) 32,290 28,864 32,174 30,000 30,000 Classroom Fees (R) 12,725 9,386 9,838 10,000 10,000 Liquor Provider Fees (R) 1,320 1,230 900 1,300 1,300 A/V Rental Fees (R) 688 1,221 530 1,000 800 Teen Night Revenues (R) 5,064 6,660 2,697 5,200 0 Eliminated Program Other Revenue - Miscellaneous Events 0 0 0 2,000 2,000 Steeple Center Operations Church Rentals 0 0 0 7,500 7,500 Steeple Center Operations Miscellaneous Rentals 0 0 0 2,000 2,000 Steeple Center Operations Other Rentals/Events 0 0 0 0 0 Steeple Center Operations Advertising Revenue 0 0 0 1,000 1,000 Steeple Center Operations Concessions 0 0 0 1,000 1,000 Steeple Center Operations Vending Machine Revenues 0 0 0 0 0 Steeple Center Operations Total Recreation Fees (R) 274,740 278,574 239,528 267,300 252,300 PAGE TOTALS 1,283,179 1,398,487 1,050,271 1,048,200 1,035,700 Page Three 2011 BUDGET WORKSHEETS GENERAL FUND REVENUES May 28, 2010 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 101 36101.00 Principal - Special Assessments (M) 12,119 15,680 10,803 10,000 5,000 From County - 101 Funded Projects 101 36102.00 Penalties & Interest - S/A (M) 15 31 17 0 0 From County 101 36210.00 Interest Earnings - Investments (M) 277,199 223,236 180,401 150,000 150,000 101 36214.00 Net Change in FV- Investments (M) 90,546 3,624 (8,113) 0 0 Annual Market Value Changes 101 36215.00 Interest Earnings (M) 428 1,128 3,063 500 2,000 From Checking Account 101 36220.00 Rents & Royalties (M) 5,236 45,281 59,948 10,700 17,300 101 36220.01 Verizon Antenna Rent 12,500 101 36220.02 Athletic Complex Land Rental 3,000 Leasing Less Land Leasing Less Land 101 36220.03 MVTA -RCC Parking Lot Rental 1,800 101 36230.00 Contribution/Donations (M) 25,823 22,580 37,764 0 0 101 36260.00 Other Revenue (M) 17,154 5,582 40,497 2,000 2,000 101 36262.00 Special Settlements (M) 31,200 0 0 0 0 101 38090.00 City Concessions (M) 5,108 4,986 4,846 5,000 5,000 Total Misc Revenues (M) 464,828 322,127 329,229 178,200 181,300 101 39202.00 Contribution from Enterprises (T) 3,500 3,500 3,500 3,500 3,500 Arena - Building & Grounds Maint. 101 39203.00 Transfer From (T) 85,469 7,133 19,964 0 0 Funds Returned from Project Total Transfers In (T) 88,969 10,633 23,464 3,500 3,500 PAGE TOTALS $553,797 $332,760 $352,693 $181,700 $184,800 FUND TOTALS $9,989,191 $10,925,291 $10,487,548 $10,466,000 $10,463,600 INTERNAL REVENUES $3,197,947 $3,224,040 $2,648,537 $2,179,000 $2,203,100 Grand Total Less: Ad Valorem _________ ========= _____ -___ _____== == _________ __________ &Fiscal Disparities Page Four 2011 BUDGET WORKSHEETS GENERAL FUND REVENUES May 28, 2010 Account # Description 101 34108.00 101 34108.01 101 34108.02 101 34108.03 101 34108.04 101 34108.05 101 34108.06 101 34108.07 101 34108.08 101 34108.09 General Fund Admin Fees Fund 201 Fund 202 Fund 203 Fund 206 Fund 207 Fund 605 Fund 606 Fund 607 Fund 650 Admin Fees Breakdown Totals 50 Comments 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $25,000 $25,000 $25,000 $25,000 $25,000 6,000 2,500 2,500 2,500 2,500 1,000 1,000 1,000 6,000 $25,000 -- -- ---- ---- -------- ---- $25,000 -- - - -- -- - - - - -- --- $25,000 -- - -- - -- -- - -- -- $25,000 ---- -----= --- ======= $25,000 --- -- -- -- ----- ---- $25,000 -- - - - ---- ---- - -- - -- 50 Comments 0Q) - 0 4 The City Council is responsible for establishing the mission and vision for the City of Rosemount. The Council also establishes community goals and supervises the activities of the City Administrator. POLICY DEVELOPMENT • Provides for the legislative and policy- making activities for all of municipal government. • Provides for the planning and control of all City expenditures through the adoption of the City's annual budget. • Provides for the definition of the City's tax structure through the levying of taxes and approval of user fees and rate structures. • Provides for citizen input to policy- making process by establishing, appointing and managing advisory commissions, ad hoc committees and community groups. GENERAL OPERATIONS • Provides funding for general government projects and needs such as: City Newsletter Chamber of Commerce Directory Page One 2011 BUDGET WORKSHEETS COUNCIL May 28, 2010 Account # Description 101 41110 103.00 Salaries & Benefits 101 41110 01 225.00 Landscaping Materials 101 41110 01 307.00 City Promotional Fees 101 41110 01 307.01 Newsletter 101 41110 01 307.02 Chamber of Commerce Directory 101 41110 01 307.03 Community Survey 101 41110 01 319.00 Other Professional Services 101 41110 01 319.01 Education Reimbursement 101 41110 01 319.02 Intergovernmental Initiatives 101 41110 01 319.04 Technology Study 101 41110 01 321.00 Telephone Costs 101 41110 01 321.01 Mayor's Pager 101 41110 01 321.02 Mayor's Cell Phone 101 41110 01 329.00 Other Communication Costs 101 41110 01 331.00 Travel Expense 101 41110 01 331.01 NLC Conference 101 41110 01 331.02 Miscellaneous Travel 101 41110 01 433.00 Dues & Subscriptions 101 41110 01 433.01 LMC Dues 101 41110 01 433.02 AMM Dues 101 41110 01 433.03 Dak Cty Regional Chamber 101 41110 01 433.04 NLC Dues 101 41110 01 433.05 Miscellaneous Dues 101 41110 01 435.00 Books & Pamphlets 101 41110 01 437.00 Conferences & Seminars 101 41110 01 437.01 Registration & Hotel -LMC Conf 101 41110 01 437.02 Registration & Hotel -NLC Conf 101 41110 01 437.03 Miscellaneous Conferences 101 41110 01 439.00 Other Miscellaneous Charges 101 41110 01 598.00 Council Designated 101 41110 01 598.01 Library Site Expenditures 101 41110 01 598.02 Future Capital Expenditures 101 41110 01 598.03 Salary & Benefit Contingency 101 41110 01 599.00 Employee Recognition Costs 101 41110 01 599.01 Employee Recognition Costs 101 41110 01 599.02 Vending Machine Costs 101 41110 01 599.03 Commemorations 107 PAGE TOTALS 145 DEPARTMENT TOTALS Off 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $34,338 $31,253 $36,017 $36,400 $36,800 25,005 25,154 77,500 25,000 6,782 22,263 27,718 25,005 25,000 18,000 1,065 2,130 0 1,100 1,100 18,500 0 20,000 0 0 10,909 5,834 11,473 8,000 12,000 0 0 0 2,000 3,000 24,500 1,000 0 0 0 27 0 0 0 0 0 63 378 600 400 0 0 2,760 500 3,418 1,627 964 2,000 1,200 1,448 1,185 1,133 1,500 1,500 13,397 14,368 14,191 All Salary Costs Inclusive of $36,800 Salary, Taxes, PERA & Benefits 25,000 SKB Landscaping Agreement 19,100 6,782 7,000 Reduce From 5 to 3 Newsletters 15,000 0 Staff Reimbursements 400 800 500 Newspaper Ads / Open Houses 2,700 1,377 24,400 2,978 13,397 14,368 14,191 15,000 15,000 5,734 6,423 6,782 7,000 7,000 0 579 1,302 800 800 1,377 1,432 2,978 1,600 1,600 120 120 0 200 0 44 46 0 100 100 6,000 677 515 350 1,000 1,000 4,379 4,363 2,768 4,000 4,000 628 540 1,185 1,000 1,000 107 16 145 100 100 15,330 36,815 3,257 100,000 100,000 Yearly Contingencies 56,005 8,838 1,788 0 0 0 254,648 0 0 0 0 0 0 17,100 0 Contingency for Negotiations 7,000 2,273 3,108 2,498 3,000 2,700 3,914 3,607 4,063 3,500 3,500 Offset by Revenue from Machines 0 0 723 0 800 $245,458 $431,383 $217,261 $256,500 $237,100 $245,458 -- - - - - -- -------- $431,383 -- - - - - -- - -- -- - -- $217,261 -- - - -- -- -- - - - - -- $256,500 -- - - ---- -- - -- - - - -- - - - - - -- - - -- - -- $237,100 -- ---- -- -- --- - -- ra ADMINISTRATION DEPARTMENT The Administration Department is responsible for the overall management of all departments within the City and for assuring that departmental activities are consistent with the goals established by the City Council. GENERAL ADMINISTRATION • Provides overall management administration and coordination of activities in all City departments including: Community Development, Finance, Fire, Police, Public Works and Parks & Recreation. • Provides for preparation and overall management of the City's budgets. • Provides project management for projects that are unique and therefore not assignable to any other department. • Provides overall coordination of City consultants. • Provides for the execution of all policies as adopted by the City Council. • Provides administrative and clerical support to the City Council including the preparation, distribution and maintenance of City Council meeting documents. RECORDS MANAGEMENT • Provides for the preparation and maintenance of official records for the City including Council, Port Authority and Commission minutes. • Prepares and assures publication and posting of official notices. • Provides public information on ordinances, contracts and policies. • Administers the collection, storage and dissemination of data. • Provides for the maintenance, training and supervision of the digital document management system. RECEPTION • Provides General Government /City Hall reception administration. D3 ADMINISTRATION DEPARTMENT - Page 2 LICENSING • Provides for the issuance and renewal of the following licenses: • Liquor • Peddlers, solicitors and transient merchants • Lawful purpose gambling premise permits • Block party street closures • Massage therapy • Arcade parlor, billiard hall and dance club PERSONNEL ADMINISTRATION • Administers overall human resources programs and services. Provides services to improve employee recruitment, retention, safety, training, orientation and relations. • Administers the City's personnel policies and procedures, assures compliance with union contract language, as well as state and federal labor regulations. • Administers employee compensation, insurance, and benefit plans, assuring compliance with state and federal regulations. PUBLIC INFORMATION AND MARKETING • Prepares communications to residents about City government activities. • Creates and coordinates marketing publications directed to business sectors outside of the community for economic development. • Assists in preparing messages and collateral material for internal communications. ADMINISTRATION DEPARTMENT - Page 3 STAFFING • For 2011, the department will consist of five positions: • City Administrator • Assistant City Administrator • Communications Coordinator • City Clerk • Receptionist PERFORMANCE MEASURES n/a — Information Not Available 2010 n/a 2010 0.0% (3 Months) 2009 6,168 (3 Months) Worker's Compensation Modification Factor 2005 2006 2007 2008 2009 n/a .78 .83 .82 .86 Turnover Rate of City Personnel 2005 2006 2007 2008 2009 n/a 9.0% 2.5% 2.5% 0.0% Average Monthly Unique Views on City Website 2005 2006 2007 2008 2009 n/a 4,830 6,683 8,444 6,368 n/a — Information Not Available 2010 n/a 2010 0.0% (3 Months) 2009 6,168 (3 Months) Cheryle Coughlin, City of Rosemount Receptionist responsibilities. May, 2010 f' ` "�� ADMINISTRATION DEPARTMENT P:u �tment Answer telephones, provide information requested, forward calls to appropriate person o Greet and assist visitors. Assist City Clerk with miscellaneous typing, filing and other clerical assignments as needed. Maintain electronic document retention for the department and central files. Maintain paper document retention for department and central files. Assist City Clerk with the preparation of council packets when needed. Secure building at close of business day. Assist City Administrator and Assistant City Administrator with projects when needed. Maintain MSDS files for City Hall and Public Works. Assist with the initial application process for solicitation and massage therapy licenses. Update and maintain safety deposit list. Provide miscellaneous notary services. Prepare purchase orders for the department. Maintain City information rack in lobby. Accept /distribute UPS, Fed Ex, USPS and other courier deliveries. Accept and clock in bids for City projects. Prepare invoices to vendors for services provided by the department. Maintain calendars for public meeting rooms. Order office supplies for the department when requested to do so. Assist City Clerk with the preparation and execution of elections every 2 years. A member of the City Safety Committee. FINANCE DEPARTMENT Write -up and input daily cash receipts when requested to do so. Maintain cash drawer. Data input of utility payments — during quarterly billing cycle — when requested to do so. Prepare invoices to vendors for services provided by the department. Follow payment histories of delinquent vendors - prepare delinquency notification letters. Balance the Express checking account monthly. PUBLIC WORKS /ENGINEERING DEPARTMENT Prepare water meter tickets based on data generated from Permit Works. Issue those assigned meters to plumbers and tickets to the utility billing clerks. Order and maintain inventory of meters. Cover Cindy's phone when she is out of office; generate work orders on CarteGraph as needed. Prepare invoices to vendors for services provided by the department. Assist department with large mailings POLICE DEPARTMENT Prepare invoices to vendors for services provided by the department. FIRE DEPARTMENT Typing of executive summaries, letters, memos and other miscellaneous jobs. Prepare invoices to vendors for services provided by the department. Order office supplies for the department when requested to do so. Prepare purchase orders for department as needed. COMMUNITY DEVELOPMENT Prepare invoices to vendors for services provided by the department. Assist department with large mailings. Coughlin, Cheryle From: Coughlin, Cheryle Sent: Tuesday, June 01, 2010 3:44 PM To: Johnson, Dwight Subject: RE: Duties Hi Dwight, First I must mention there are never 2 days the same at this desk. This explains why I have always enjoyed my job so much. I have never been bored or lacking for something to do. The variables that affect my work flow can be as simple as the end versus the first of the month, an absent employee or an unexpected project. At this time, I would estimate that 40% is phone calls and walk -in business. Approximately 40% clerical and /or Laserfiche duties. The last 20% may consist of issuing a water meter, processing a utility payment or offering notary services. Hope this is sufficient for your needs. Cheryl& From: Johnson, Dwight Sent: Tuesday, June 01, 2010 2:22 PM To: Coughlin, Cheryle Subject: Duties Cheryle, I re -read your list of administrative tasks for various departments today. I have a follow -up question: about what percent of your time would you say is devoted to all of those administrative tasks vs. answering phones and assisting walk -in customer? A good guess would be fine with me -no need for any detailed analysis. Thanks. Dwight Johnson City Administrator City of Rosemount 651- 322 -2006 dwieht.iohnson @ci.rosemount.mn.us Page One 2011 BUDGET WORKSHEETS ADMINISTRATION May 28, 2010 Account # Description 101 41320 101.00 Salaries & Benefits 101 41320 102.00 Full -Time Overtime 101 41320 103.00 Part-Time Salaries & Benefits 101 41320 01 209.00 Other Office Supplies 101 41320 01 306.00 Personnel Testing & Recruitment 101 41320 01 313.00 Temporary Service Fees 101 41320 01 319.00 Other Professional Services 101 41320 01 321.00 Telephone Costs 101 41320 01 331.00 Travel Expense 101 41320 01 331.01 NLC Conference 101 41320 01 331.02 ICMA Conference 101 41320 01 331.03 Miscellaneous Travel 101 41320 01 433.00 Dues & Subscriptions 101 41320 01 433.01 MCMA Dues 101 41320 01 433.02 MAMA Dues 101 41320 01 433.03 MCFOA Dues 101 41320 01 433.04 Munici -Pals 101 41320 01 433.06 ICMA Dues 101 41320 01 433.07 APMP Dues 101 41320 01 435.00 Books & Pamphlets 101 41320 01 437.00 Conferences & Seminars 101 41320 01 437.01 Registration & Hotel - LMC 101 41320 01 437.02 Registration & Hotel - MCMA 101 41320 01 437.04 Staff (1) Each 101 41320 01 437.05 Miscellaneous Seminars 101 41320 01 437.06 Registration & Hotel - ICMA 101 41320 01 437.07 City Clerk Training 101 41320 01 437.08 Registration & Hotel - NLC 101 41320 01 437.09 Miscellaneous Meetings 101 41320 01 439.00 Other Miscellaneous Charges 101 41320 01 580.00 Other Equipment Purchases PAGE TOTALS l 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $353,911 $369,001 $393,980 $419,300 $431,600 Salary, Taxes, PERA & Benefits 20 1,712 0 2,000 300 6,224 6,549 4,232 7,000 700 Temp Receptionist Coverage 165 129 0 500 300 Miscellaneous Purchases 0 0 0 0 0 0 28,774 0 0 0 180 0 0 0 0 2,027 1,094 1,311 1,500 1,500 Administration Cell Phones 900 642 0 317 500 0 395 873 0 800 500 396 40 348 400 400 1,900 194 191 199 250 200 40 80 45 100 50 35 0 35 50 50 25 25 25 100 50 909 2,213 741 1,500 1,500 0 63 45 100 50 322 92 0 200 200 6,200 340 0 200 500 500 1,132 1,033 1,287 1,300 1,300 70 75 0 200 200 1,893 2,579 955 1,000 500 ULI / Greening Initiatives 3,389 2,415 0 2,500 2,500 410 1,020 689 800 800 All MCFOA Events 1,257 0 1,219 1,200 0 490 95 309 500 400 92 26 295 100 100 0 895 536 900 900 374,558 418,975 406,766 443,300 444,600 �i Page Two 2011 BUDGET WORKSHEETS ADMINISTRATION May 28, 2010 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 101 - 41320 -0131 -xxx is for Human Resources _ 101 41320 31 305.00 Medical & Dental Fees 115 1,500 Employee Drug Testing 101 41320 31 305.01 Pre- Employment Physicals 0 846 558 500 500 101 41320 31 305.02 Employee Drug Testing 0 871 164 1,500 1,000 101 41320 31 315.00 Special Programs 2,000 101 41320 31 315.01 Employee Training 219 1,629 1,178 2,000 1,000 101 41320 31 315.02 Health & Wellness 663 1,427 1,842 0 1,000 Wellness & Heath Management 101 41320 31 315.03 EAP 717 699 0 0 0 Now Covered with Insurance 101 41320 31 319.00 Other Professional Services 4,200 101 41320 31 319.01 Labor Consultant 0 600 0 1,000 300 101 41320 31 319.02 Labor Legal Issues 249 0 2,835 900 900 101 41320 31 319.04 COBRA Consultant 0 0 692 1,000 800 101 41320 31 319.05 FlexIVEBA Administrative Fees 2,279 2,325 1,746 2,500 2,200 101 41320 31 319.06 SWWC Co- Operative Dues 0 0 0 0 0 101 41320 31 331.00 Travel Expense 51 517 188 400 400 101 41320 31 341.00 Employment Advertising 975 2,504 709 3,000 700 Vacancies 101 - 41320 -01- 41 -xxx is for Communications 101 41320 31 433.00 Dues & Subscriptions 500 101 41320 31 433.01 "Future Use" 0 350 0 0 0 101 41320 31 433.02 IPMA Dues 145 145 145 200 200 101 41320 31 433.03 MPELRA Dues 0 400 345 400 300 101 41320 31 435.00 Books & Pamphlets 84 315 233 300 200 Books & Training Materials 101 41320 31 437.00 Conferences & Seminars 500 101 41320 31 437.01 MPELRA State Conference 0 370 315 300 300 101 41320 31 437.02 Personnel Seminars 249 105 107 300 200 101 41320 31 437.03 Safety, Supervisor, Policy 0 0 0 0 0 101 41320 41 315.00 Special Programs 24,489 4,243 0 1,000 101 41320 41 315.01 General Marketing 0 0 0 5,000 1,000 Special Mailings 101 41320 41 315.02 Historical Monuments 0 0 0 2,300 0 101 41320 41 319.00 Other Professional Services 1,354 1,020 2,356 2,500 11,100 101 41320 41 319.01 Website 0 0 0 1,100 101 41320 41 319.02 Website Improvements 0 0 0 10,000 101 41320 41 328.00 Cable Supply Costs 178 198 340 500 500 Cable Supplies, Software 101 41320 41 329.00 Other Communication Costs 0 0 0 45,600 101 41320 41 329.01 Cable JPA Payment- General City 37,929 41,462 42,823 43,000 43,000 101 41320 41 329.02 Video Streaming Council Mtgs 2,765 4,739 4,760 5,000 0 101 41320 41 329.03 Bulk E -Mail System 5,014 2,508 2,508 2,600 2,600 101 41320 41 331.00 Travel Expenses 304 174 60 300 200 101 41320 41 433.00 Dues & Subscriptions 60 60 120 200 100 MAGC 101 41320 41 437.00 Conferences & Seminars 0 55 75 300 100 Technical Courses 101 41320 41 580.00 Other Equipment Purchases 5,616 988 2,242 1,000 1,000 PAGE TOTALS $83,454 $68,550 $66,341 $77,000 $69,600 DEPARTMENT TOTALS $458,013 $487,524 $473,107 $520,300 $514,200 ELECTIONS The responsible execution of elections is a crucial function of local government. Federal, state and local elections assure the popular representation of citizens and that the community's mission, vision and goals are consistent with the wishes of the electorate. GENERAL / ADMINISTRATIVE • Provides for conducting all local, state and federal elections. VOTER REGISTRATION • Provides for the maintenance and execution of procedures for voter registration. SUPPLIES & EQUIPMENT • Provides for the necessary supplies and minor equipment necessary to conduct the elections. CONTRACTED SERVICES • Provides for the maintenance agreements for service and repair of the voter assist terminals and the ballot counters. • Provides for continued use of polling locations. STAFFING • Provides for the recruitment, appointment, training and supervision of election judges to carry out Election Day activities at the City's seven precinct polling locations. • Provides for training of absentee ballot board. PERFORMANCE MEASURES Average Number of Registered Voters per Precinct 2005. 2006 2007 2008 2009 2010 n/a 1,619 1,578 1,671 1,836 1,807 (4 Months) n/a — Information Not Available Page One 2011 BUDGET WORKSHEETS ELECTIONS May 28, 2010 Account # Description 101 41410 01 103.00 Part-Time Salaries 101 41410 01 203.00 Printed Forms & Paper 101 41410 01 208.00 Miscellaneous Supplies 101 41410 01 219.00 Other Operating Supplies 101 41410 01 242.00 Minor Equipment 101 41410 01 319.00 Other Professional Services 101 41410 01 321.00 Telephone Costs 101 41410 01 351.00 Legal Notices Publishing 101 41410 01 409.00 Other Contracted Repair & Maint 101 41410 01 409.01 Maintenance for AutoMarks 101 41410 01 409.02 Maintenance for Accuvotes 101 41410 01 412.00 Building Rental 101 41410 01 439.00 Other Miscellaneous Charges 101 41410 01 580.00 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS I� 2007 Actual 2008 Actual 2009 Actual 2010 Adopted Budget 2011 Object Detail Amount 2011 Proposed Budget Comments $0 $30,001 $133 $24,000 $10,000 Election Judges 0 3,311 0 4,200 2,200 Ballots & Programming (18) 617 0 700 400 (25) 777 0 800 300 Food for Election Judges 0 1,218 0 1,500 500 Booths & Signs 0 0 0 0 0 57 86 0 0 0 0 0 0 0 0 Election Publications 0 2,300 1,225 1,225 1,300 1,300 Voting Machines 1,000 1,000 1,000 1,000 Voting Machines 400 0 0 0 0 Possible Rent for Locations 0 0 0 0 0 60,000 1,234 600 6,500 6,300 $60,415 $39,468 $2,958 $40,000 $22,000 $60,415 $39,468 $2,958 $40,000 ------ $22,000 -- - - - - -- l� FINANCE DEPARTMENT The Finance Department is responsible to work with all departments of the City, especially the Administration Department, to ensure that all activities of the City are conducted in a fiscally responsible manner. GENERAL 1 ADMINISTRATIVE • Provides for the fiscal management, processing and maintenance of all accounting transactions for all funds of the City, including budgetary controls, preparation of interim accounting reports and the Comprehensive Annual Financial Report (CAFR). Also responsible for all other reporting requirements of the Federal, State, County and other government agencies in regards to budgets, taxes, financial statements, TIF Districts and other items. DATA PROCESSING • Provides for evaluation of appropriate computer hardware and software on a continuing basis. • Coordinates efforts between departments to assure an integrated information system. • Acts as an in -house consultant providing technical assistance when possible, and if not possible, coordinating the procurement of outside technical assistance when needed. TREASURY • Fund Management - Collects and deposits revenues and manages the investment of idle funds. • Budgetary - Compiles historical and current expenditure and revenue data to facilitate budget preparation. • Bonding - Assists in the issuance, sale and record maintenance of indebtedness. • Insurance - Maintains records for property and worker's comp insurance requirements, handles all property & liability claims and prepares documents for all yearly renewals of policies. FINANCE DEPARTMENT - Page Z PAYROLL a • Receives employee time sheets, coordinates insurance, pay rates and other applicable payroll information with personnel, prepares payroll checks, prepares all Federal and State required reports, prepares all employee withheld and employer promised obligation funds for disbursement to applicable organizations, and prepares all reports as needed, both internally and externally. UTILITY BILLING • Coordinates the automated reading of all City water meters and the mailing and collection of all utility bills. Handles on the computer system, the preparation of final bills and the setup of new accounts. Fields and responds to utility billing questions and complaints. Compiles operating statistical information which is available to other departments as needed. ACCOUNTS PAYABLE • Processes purchase orders prepared by all departments, checking for accuracy and matching with invoices and all other supporting documentation so payments can be made in a timely manner. Also, prepares all checks and supporting reports that accompany each check run. Coordinates the review of bills by Council by providing applicable reports and supporting documentation. ACCOUNTS RECEIVABLE / CASH RECEIPTS • Prepares invoices for all departments for items /services that must be billed to outside sources. Maintains records that allow for the timely collection of invoiced items /services. Receipts monies on a daily basis and deposits those monies daily in designated banking institutions. Maintains a system that allows for the appropriate reporting of all monies collected within the accounting system. FINANCE DEPARTMENT - Page 3 FIXED ASSETS a • Responsible for the maintenance of the fined asset system. This includes all additions, deletions and changes in fixed assets for the City. It also includes the periodic physical reinventory of all current fixed assets. Also responsible for the corresponding reporting requirements that go along with the system, including year -end information, insurance renewal information and individual department information. SPECIAL ASSESSMENTS • Responsible for the maintenance of the special assessments records including the implementation of our own records system that will be used to ensure that Dakota County's assessment balances are correct and in agreement with ours. Works with the Engineering Department for additions to the special assessment system. Responsible for coordinating all deletions and changes to the system as well as all collections of special assessment payments not collected through property taxes. STAFFING • In 2011, the department will consist of eight positions: • Finance Director • Accounting Supervisor • IT Coordinator • Payroll Clerk • Accounts Payable Clerk • Utility Billing Clerks (2) • Accounting Clerk (Part -Time) FINANCE DEPARTMENT - Page 4 PERFORMANCE MEASURES City Bond Rating 2005 2006 2007 2008 2009 2010 Al Al Aa3 Aa3 Aa3 Aa2 (10/1/07) (4/16/10) GFOA Certificate of Achievement Award Received 2005 2006 2007 2008 2009 2010 Yes Yes Yes Yes (Applied) n/a # Of Accounts Payable Checks Processed 2005 2006 2007 2008 2009 2010 n/a n/a 3,098 3,081 3,326 n/a # Of Utility Bills Processed 2005 2006 2007 2008 2009 2010 27,654 28,767 29,000 (est.) 29,092 29,160 n/a n/a — Information Not Available Page One �_3 2011 BUDGET WORKSHEETS FINANCE May 28, 2010 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41520 101.00 Salaries & Benefits $206,431 $248,981 $284,536 $296,000 $303,500 Salary, Taxes, PERA & Benefits 101 41520 102.00 Full -Time Overtime 1,557 2,257 2,689 3,000 1,500 101 41520 103.00 Part-Time Salaries & Benefits 31,448 35,363 37,214 45,600 45,900 101 41520 01 321.00 Telephone Costs 0 137 659 1,000 1,400 Cell Phone Allowances (2) 101 41520 01 331.00 Travel Expense 700 101 41520 01 331.01 Finance Director 894 1,015 678 1,200 500 Miscellaneous (National Cut) 101 41520 01 331.02 Staff 80 6 18 200 200 101 41520 01 391.00 P.C. Maintenance 51,900 101 41520 01 391.01 Civic Systems Applications Support 5,035 5,187 5,316 5,500 5,700 101 41520 01 391.02 Citrix Maintenance Renewal 1,240 959 959 1,400 1,000 101 41520 01 391.03 Incode Software Maintenance 6,329 6,642 7,593 7,000 8,000 101 41520 01 391.04 General Network Support 50,000 49,657 25,000 20,000 20,000 200 Hours of Support Time 101 41520 01 391.06 Fixed Asset Maint Contract 1,211 1,211 1,383 1,400 1,400 101 41520 01 391.07 Miscellaneous P.C. Repairs 2,133 1,957 2,697 2,800 2,800 101 41520 01 391.08 Anti -Virus Software Renewal 4,163 7,493 5,951 8,000 4,000 101 41520 01 391.09 File Server Software Maintenance 1,204 795 1,475 2,000 9,000 101 41520 01 392.00 P.C. Accessories & Supplies 2,788 3,059 3,478 4,000 4,000 City System Supplies 101 41520 01 393.00 P.C. Hardware Purchases 1,447 13,679 1,967 2,500 2,500 101 41520 01 394.00 P.C. Software Purchases 5,000 101 41520 01 394.01 Annual Microsoft Office Payment 9,811 9,811 9,811 10,000 0 Final Pymt 2010 Thru 2011 101 41520 01 394.02 Miscellaneous S/W Purchases 0 160 2,779 5,000 5,000 101 41520 01 409.00 Other Contracted R & M 105 105 165 200 200 Non - Computer Equipment 101 41520 01 433.00 Dues & Subscriptions 900 101 41520 01 433.02 MnGFOA - Finance Director 40 60 60 100 100 101 41520 01 433.03 MnGFOA - Staff 200 360 360 450 450 101 41520 01 433.04 GFOA - Finance Director & Asst. 315 325 335 350 350 101 41520 01 433.05 Magazine Subscriptions 0 0 0 0 0 101 41520 01 435.00 Books & Pamphlets 100 101 41520 01 435.01 Accounting Related Books 0 37 0 50 50 101 41520 01 435.02 Finance Related Books 0 0 0 50 50 101 41520 01 437.00 Conferences & Seminars 2,000 101 41520 01 437.02 MnGFOA Annual Conf (F /D & Ass't) 551 551 558 1,000 1,000 101 41520 01 437.03 GFOA National Conf (F /D) 1,270 1,111 1,437 1,300 0 Cut for 2011 101 41520 01 437.04 Staff Development 930 0 125 500 500 101 41520 01 437.05 Miscellaneous Seminars 370 230 245 500 500 101 41520 01 439.00 Other Miscellaneous Charges 553 155 220 200 200 Contingencies 101 41520 01 570.00 Office Equipment & Furnishings 0 0 889 1,000 1,000 Office Chairs PAGE TOTALS $330,105 $391,299 $398,596 $422,300 $420,800 DEPARTMENT TOTALS $330,105 $391,299 $398,596 $422,300 $420,800 04 , GENERAL GOVERNMENT DUPLICATING & COPYING • Provides for maintenance agreements and expenses to operate copy machines at all City facilities. Also provides for digital document management costs. PRINTED FORMS & PAPER • Provides for copy paper utilized by all departments and provides for forms utilized by the Finance Department. ENVELOPES & LETTERHEADS • Provides for letterhead utilized by all departments and for various types and sizes of envelopes. OTHER OFFICE SUPPLIES • Provides for general office supplies utilized by all City departments. EQUIPMENT PARTS • Provides for the maintenance and repair of general office equipment. AUDITING & ACCOUNTING SERVICES • Provides for the annual audit of the City's accounting transactions for all funds of the City and for the preparation of the Comprehensive Annual Financial Report. Also provides for other services as required of the City's financial and accounting consultants. LEGAL FEES • Provides for general legal and special legal services provided by the City Attorney or other law firms utilized by the City for such services. as GENERAL GOVERNMENT - Page 2 OTHER PROFESSIONAL SERVICES • Provides for the administration costs of the City's code updates, code web fees, annual updates to the user fee study, preparation of the State building report and continuing disclosure fees. TELEPHONE COSTS • Provides for the costs of the City's telephone system, monthly service fees, long distance calls and miscellaneous installation costs. Also, provides for fees associated with the City's e-mail and web services. POSTAGE COSTS • Provides for postage costs for all departments and maintenance agreements for the postage machine and postage allocator. OTHER TRANSPORTATION EXPENSES • Provides for two -year renewals of City vehicle license plates, emission fees and duplicate plates, titles or tags, if needed. LEGAL & GENERAL NOTICES PUBLISHING • Provides for the publication of legal documents from all departments except when publication costs are charged to specific projects. LEASE AGREEMENTS • Provides for leasing of copy machines at City Hall, Community Center and the Police Department. Page One 2011 BUDGET WORKSHEETS GENERAL GOVERNMENT May 28, 2010 Account # Description 101 41810 01 202.00 Duplicating & Copying 101 41810 01 202.01 Records Retention 101 41810 01 202.02 Copying Costs 101 41810 01 203.00 Printed Forms & Paper 101 41810 01 203.01 Copy Paper 101 41810 01 203.02 General Receipt Books 101 41810 01 203.03 Purchase Orders 101 41810 01 203.04 Payroll & A/P Checks 101 41810 01 203.06 Miscellaneous Forms 101 41810 01 204.00 Envelopes & Letterheads 101 41810 01 204.01 Letterhead 101 41810 01 204.02 Plain Envelopes 101 41810 01 204.03 A/P & Payroll Envelopes 101 41810 01 204.04 10 x 13 Envelopes 101 41810 01 204.05 10 x 15 Envelopes 101 41810 01 209.00 Other Office Supplies 101 41810 01 221.00 Equipment Parts 101 41810 01 242.00 Minor Equipment 101 41810 01 242.01 "Future Use' 101 41810 01 242.02 Credit Card Equipment 101 41810 01 301.00 Auditing & Accounting Services 101 41810 01 301.01 Audit & General Consulting Fees 101 41810 01 301.02 Dakota County Assessment Fees 101 4181001 301.03 Dak Cty Truth In Taxation Costs 101 4181001 301.04 Printing of Budget Books 101 41810 01 303.00 Engineering Fees 101 41810 01 304.00 Legal Fees 101 41810 01 319.00 Other Professional Services 101 41810 01 319.01 City Code Update 101 41810 01 319.02 City Code Web Fees 101 41810 01 319.03 State Building Report (Springsteds) 101 41810 01 319.04 Continuing Disclosure Fees 101 41810 01 319.05 Annual User Fee Study Update 101 41810 01 319.06 Arbitrage/Rebate Calculations 101 41810 01 319.10 UMore Professional Services 101 41810 01 320.00 Credit Card Activity Fees 101 41810 01 320.01 Utilities' Fees 101 41810 01 320.02 Parks & Recreation Fees 101 41810 01 320.03 Building Fees 101 41810 01 320.04 General Fees 101 41810 01 321.00 Telephone Costs 101 41810 01 321.01 General Phone Costs (& Internet) 101 41810 01 321.02 Domain Housing 101 41810 01 322.00 Postage Costs 101 41810 01 339.00 Other Transportation Expenses 101 41810 01 351.00 Legal Notices Publishing 101 41810 01 351.01 Costs for Public Notices 101 41810 01 351.02 Truth in Taxation Notices 101 41810 01 351.03 Budget & Audit Publications 101 41810 01 391.00 P.C. Maintenance 101 41810 01 392.00 P.C. Software Purchases 101 41810 01 393.00 P.C. Hardware Purchases 101 41810 01433.00 Dues & Subscriptions 101 41810 01 439.00 Other Miscellaneous Charges 101 41810 01 450.00 Sales Tax on Purchases 101 41810 01 580.00 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $12,000 7,998 7,535 8,973 0 0 Moved to "391.00" Below 14,282 9,741 10,632 12,000 12,000 13,000 4,911 7,321 5,678 8,000 8,000 774 743 0 800 800 0 1,602 0 1,700 1,700 284 2,100 339 1,500 1,500 1,991 362 986 1,000 1,000 Business Cards, etc. 5,500 1,542 2,054 528 2,000 2,000 2,464 1,327 1,850 1,600 1,800 0 0 0 700 500 0 1,155 0 1,200 1,200 0 0 0 0 0 16,068 17,228 18,015 19,000 19,000 General Office Supplies 0 0 55 0 0 City Hall Equipment Repairs 300 0 0 0 0 0 0 0 0 300 300 74,500 64,204 72,635 62,929 75,000 68,000 Increased GASB Requirements 3,449 3,373 4,085 4,500 4,500 1,840 1,832 1,841 2,000 2,000 (205) 0 0 500 0 12,767 2,978 1,251 0 0 63,537 63,370 78,235 75,000 80,000 General City Legal Fees 34,800 540 1,853 2,375 1,500 2,500 250 250 0 300 300 8,760 3,870 6,120 9,500 7,000 Fees Paid to Springsted 2,000 2,000 3,607 4,000 4,000 Fees Paid to Springsted (Bonds) 14,225 4,675 14,128 8,000 9,000 Fees Paid to Springsted 11,900 3,750 1,305 10,000 7,000 Fees Paid to Springsted 0 3,005 11,465 1,000 5,000 22,000 Add'I Services at City Hall 980 1,127 1,299 1,400 1,500 4,158 4,236 4,760 6,000 4,800 1,080 3,347 14,212 12,000 15,000 245 593 693 600 700 45,100 70,048 73,941 63,179 40,000 45,000 Includes SJW Maintenance Costs 0 60 0 100 100 19,569 20,029 17,756 24,000 22,000 33 813 74 800 800 Vehicle Licensing 4,400 2,850 2,643 2,202 3,000 3,000 All Departments 268 586 0 600 600 Billing from Dakota County 459 689 549 800 800 State Mandated Publications 0 0 0 10,000 12,000 Laserfishe Maintenance 0 0 0 14,600 6,000 Laserfishe Software (Phase 4) 0 0 0 2,200 3,200 Scanner Purchase 721 841 773 1,000 1,000 Newspapers 260 260 269 500 500 Direct Deposit Filing Fees/Flex 0 0 0 0 0 Sales Tax Audit 26,212 24,974 31,889 29,000 29,000 Office Machine Leases-All Bldgs. $360,463 $348,898 $372,052 $387,700 $385,100 $360,463 -- -- -- -- -------- $348,898 -- - - - --- -- - - - - -- $372,052 -- - - - - -- -- - - - - -- $387,700 -- - - -- -- -- -- - - - - -- -- - - - - -- - - ---- $385,100 -- - - - - -- -- - - - - -- C)--V) COMMUNITY DEVELOPMENT OVERVIEW: MISSION, VISION AND GOALS The Community Development Department plays an important role as the City moves toward its mission of providing a safe, healthy and pleasant community in a fiscally responsible manner. The Building Inspection and Planning Divisions play a key role in making Rosemount a safe and pleasant community. These divisions are also involved in reaching the City Council's goals in affordable housing and property maintenance. The Economic Development Division addresses the City's vision statement by fostering opportunities to live, work and shop. The division helps the City enhance its hometown character and pride, for example, through downtown redevelopment. The division, along with the Rosemount Port Authority, plays a vital role in meeting goals of the City Council such as commercial enhancement and business growth. BUILDING INSPECTIONS • Is responsible for providing the services of building permit review, building inspection, code administration, consultation and review on new and existing buildings and structures within the City. • Is responsible for the maintenance and enforcement of city ordinances and codes relating to building, health, life safety, fire and environmental conditions and to assure local compliance with county, state and federal regulations relating to the same activities. • Is responsible for the successful implementation of all structural development and assuring regulated and controlled standards within Rosemount. • Is responsible for monitoring and permitting all individual sewage treatment systems within the City. • Is responsible for reports submitted to all appropriate jurisdictions concerning building activities. COMMUNITY DEVELOPMENT — Page 2 CODE ENFORCEMENT • Is responsible for enforcement of city ordinances and codes relating to health, life safety, environmental, and nuisance conditions and assure local compliance with county, state and federal regulations relating to the same activities. • Is responsible for sign ordinance implementation and permitting. • Is responsible for drafting of code text amendments to carry out Council goals and City initiatives. • Is responsible for rental housing inspection and permitting. • Is responsible for sequential code enforcement program, which is a city initiated program for resident education and neighborhood code compliance. PLANNING • Is responsible for reviewing proposed developments for compliance with the zoning and subdivision ordinance and coordinating interdepartmental staff review of all residential, commercial, institutional and industrial developments. • Is responsible for providing recommendations to Planning Commission and City Council on all deliberations concerning land use, zoning, variances, site plan reviews, platting and special permits (interim use permits, mining permits, etc.). • Is responsible for maintaining zoning and subdivision ordinances and the City's Comprehensive plan in compliance with county, state and federal requirements (statutes and rules). • Is responsible for long -range planning and special studies that guide the physical development of the community. • Is involved with state and regional activities affecting the City, including, but not limited to, land use, transportation, training, housing and environmental services. Includes active participation by departmental staff in various committees and organizations. • Is involved with issuance of development related permits such as grading and building permits. (21)-, COMMUNITY DEVELOPMENT — Page 3 ECONOMIC DEVELOPMENT • Is responsible for marketing development opportunities within the City and creating an interest in Rosemount. • Is responsible for creating and coordinating the establishment of tax increment districts and other economic incentives. • Is responsible for creation and expansion of a local Business Retention program. • Is responsible for coordinating the state, county and local approval processes to insure the proponent's requests are met in a timely fashion. • Is responsible for staffing the majority of functions of the Rosemount Port Authority. • Is involved with state and regional economic development organizations and functions. 03�3 COMMUNITY DEVELOPMENT — Page 4 PERFORMANCE MEASURES Planning Application Processed Within 60 Days 2005 2006 2007 2008 2009 2010 n/a 79% 86% 87% 94% n/a Requested Inspections Completed Within One Day 2005 2006 2007 2008 2009 2010 n/a n/a n/a n/a 100% n/a Residential Plan Reviews Fully Completed Within 10 Working Days 2005 2006 2007 2008 2009 2010 n/a n/a n/a n/a 96% n/a Code Complaints Resolved 2005 2006 2007 2008 2009 2010 n/a n/a 98% 95% 100% n/a Existing Businesses Visited 2005 2006 2007 2008 2009 2010 n/a n/a n/a n/a 31 n/a n/a — Information Not Available All 2010 figures are estimates for the first 6 months of the year. Page One 2011 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT May 28, 2010 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments y All Salary Costs Inclusive of 101 41910 101.00 Salaries & Benefits $797,187 $832,464 $878,708 $910,700 $936,300 Salary, Taxes, PERA & Benefits 101 41910 102.00 Full -Time Overtime 435 0 0 1,000 1,000 101 41910 99 103.00 Part-Time Salaries & Benefits 2,587 3,367 2,024 4,500 3,500 Planning Commission Members 101 41910 01 201.00 Office Accessories 0 0 521 0 0 Calendars, Planners, etc. 101 41910 01 202.00 Duplicating & Copying 1,344 7,557 7,306 3,000 3,000 101 41910 01 203.00 Printed Forms & Paper 3,712 4,100 529 4,000 4,000 Forms, Stickers, Tags, etc. 101 41910 01 205.00 Drafting Supplies 0 0 0 0 0 101 41910 01 208.00 Miscellaneous Supplies 21 53 998 0 0 101 41910 01 209.00 Other Office Supplies 295 77 180 600 600 Dictation Devices & Tapes 101 41910 01 219.00 Other Operating Supplies 1,302 638 2,176 2,000 2,000 Chairs 101 41910 01 241.00 Small Tools 160 0 344 200 200 Inspectors' Tools 101 41910 01 302.00 Architects' Fees 275 0 0 0 0 101 4191001 319.00 Other Professional Services 250 0 299 1,000 1,000 Consultant 101 41910 01 329.00 Other Communication Costs 3,128 2,443 2,327 3,600 2,500 Cell Phones & Pagers 101 41910 01 331.00 Travel Expense 540 472 6 600 600 101 41910 01 391.00 P.C. Maintenance 2,184 2,318 2,016 2,700 2,700 Perrnitworks Support 101 41910 01 392.00 P.C. Accessories & Supplies 0 0 0 300 300 101 41910 01 393.00 P.C. Hardware Purchases 0 0 0 0 0 101 41910 01 433.00 Dues & Subscriptions 3,100 101 41910 01 433.01 APA/AICP 1,006 1,131 1,209 1,300 1,300 101 41910 01 433.02 ICC 100 0 260 200 200 101 41910 01 433.03 AMBO 200 260 275 300 300 101 41910 01 433.04 10,000 Lakes 75 115 325 150 150 101 41910 01 433.05 "Future Use" 0 0 0 0 0 101 41910 01 433.06 Trade Magazines 42 0 0 200 200 101 41910 01 433.07 Planner's Journal 0 0 0 0 0 101 41910 01 433.08 Sensible Land Use Coalition 201 150 0 300 300 101 41910 01 433.09 AACEO/MAHCO 0 0 25 100 100 101 41910 01 433.10 Other Dues & Subscriptions 533 562 3,398 550 550 101 41910 01 435.00 Books & Pamphlets 910 557 631 700 700 Manuals, References, IBC Books 101 41910 01 437.00 Conferences & Seminars 7,300 101 41910 01 437.01 State Bldg Official School 70 495 550 550 550 101 41910 01 437.02 Spring & Fall Code Updates 60 370 150 400 400 101 41910 01 437.03 Building Inspector Training 184 952 619 1,000 1,000 101 41910 01 437.04 Computer Training 0 32 0 300 300 101 41910 01 437.05 Clerical Seminars 0 743 0 400 400 101 41910 01 437.06 Planning Seminars 1,783 5,094 110 1,800 1,800 101 41910 01 437.07 ISTS Training 429 0 500 500 500 101 41910 01 437.08 State Planning Conference (2) 0 104 1,665 1,000 1,000 101 41910 01 437.09 Planning Commissioner Training 0 305 32 250 250 101 41910 01 437.10 Gen'I Seminars 955 0 1,667 400 400 101 41910 01 437.11 Code Enforcement Training 0 239 290 700 700 101 41910 01 439.00 Other Miscellaneous Charges 0 90 120 400 400 Contingencies PAGE TOTALS $819,969 $864,689 $909,262 $945,700 $969,200 DEPARTMENT TOTALS $819,969 $864,689 $909,262 $945,700 $969,200 POLICE DEPARTMENT The Department provides police services through its staff on a 24/7/365 basis. Staffing levels have grown along with the community and services have been enhanced and expanded as the additional staffing has been added. Specific functions completed within the Department include: ADMINISTRATION AND MANAGEMENT This budget provides for the overall planning, coordination and management of personnel and administration of activities within the Police Department. This includes the collection, preparation and filing of crime data and miscellaneous reports with the State of Minnesota; preparation and oversight of the operating and capital improvements budgets; and strategic planning for the future needs of the Department and the community. PATROL This is the most visible function of the Department. Patrol officers are recognized in the community because of their uniforms and marked police squads. They also are the first responders to calls for service — regardless of whether it is a medical response, motor vehicle crash or a criminal act. The overall goal of the patrol officers is the protection of life and property and the creation of a sense of security in the community. This is accomplished through visible patrolling, the enforcement of traffic laws, the arresting of criminal offenders and the delivery of other non - emergency services. CRIMINAL INVESTIGATION Patrol officers and detectives are responsible for the investigation of criminal incidents through the gathering, analysis and presentation of evidence and testimony. Investigations that are more complex or cross municipal boundaries are coordinated by the detectives. This is accomplished by working cooperatively with other police agencies, the County Attorney's Office, Child Protection, victim services and other federal and state law enforcement agencies. CRIME PREVENTION AND COMMUNITY EDUCATION PROGRAMS A significant effort is made by the police department to inform residents of crime within the community, methods that citizens can take to help prevent crimes and building relationships with community members. While these objectives are part of each officers' daily responsibilities, there are specific programs that are frequently associated with community policing and that emphasize the need for the police and citizens to work together to prevent criminal activity and reduce the opportunities for criminals to commit crimes. POLICE DEPARTMENT — Page 2 • School Liaison - Officers serve as a liaison to the Rosemount Middle and High Schools. One officer is assigned full-time to the High School and a second officer spends one- quarter time at the Middle School. The liaison officers investigate criminal incidents that occur at the schools or that involve students at the schools. In addition, the liaisons work with the school staff to enhance the safety and security for both staff and students. Presentations on a variety of topics are made by the liaison to classes at all grade levels. The Middle School officer also spends time at each of the elementary schools, working with staff on any issues and making presentations in classes. Community Education - In order to work together with the community, police must share information concerning criminal activity and crime prevention with the community. Officers are available to make presentations to community groups and organizations on a variety of topics. In addition, officers provide prevention tips to persons on a daily basis whom report criminal activity. Several events are also held throughout the year in an effort to build relationships with the residents and business persons. These include National Night Out block parties and gatherings, Neighborhood Watch meetings and Public Safety in the Park events. • Reserve Officer Program — Reserve officers are volunteers whom supplement the staff of sworn officers of the Department. The reserve officers are utilized to handle traffic and crowd control duties during city festivals and celebrations or emergencies, such as hazardous materials spills or leaks, damage resulting from tornadoes or other severe weather and major criminal incidents. Reserve officers patrol on some evenings and handle service calls, for example, assisting stalled motorists and animal complaints. They are also utilized regularly to provide crime prevention information to citizens at community events or through other programs. • Chaplain Program — The Police Chaplains are used by officers to assist in a variety of situations in which individuals or families are having difficulties. Chaplains are able to provide support to persons that are experiencing stress as a result of the death of a loved one, marital or family problems, financial struggles or any other event. By utilizing the chaplains to console and counsel persons in crisis, police officers are able to get back to other duties, while the chaplains are able to remain with the persons involved in the crisis. ANIMAL CONTROL The Police Department is responsible for the enforcement of ordinances related to the control and care of domestic animals. These tasks are mainly handled by Community Service Officers. Their duties include the licensing of dogs, cats and ferrets, assisting in the handling of stray, lost or injured animals and other complaints of animals causing a nuisance by barking, howling or being allowed to roam off the owner's property. Q, POLICE DEPARTMENT — Page 3 CODE ENFORCEMENT The Police Department assists the Community Development Department with code enforcement of city ordinances related to property maintenance and outside storage. The Department's Community Service Officers primarily handle this effort. Property owners that are observed to be in violation of an ordinance are notified of the violation and given an explanation of how to remedy the violation. The enforcement of city ordinances is important to maintain community standards, which help the City attain its mission of providing a safe, healthy and pleasant community. EMERGENCY MANAGEMENT The City has an all- hazards emergency plan and the Chief of Police serves as the City's emergency manager. The emergency manager is responsible for the development of emergency plans in the event of a chemical, technical or natural disaster in the community, e.g. tornado, flooding or hazardous materials release. PERFORMANCE MEASURES Number of Licensed Officers per 1,000 Residents 2005 2006 2007 2008 2009 2010 .94 .95 .97 .98 .97 n/a Number of Non - licensed Employees per 1,000 Residents 2005 2006 2007 2008 2009 2010 .22 .22 .21 .20 .20 n/a Number of Car Crashes with Personal Injury Resulting 2005 2006 2007 2008 2009 2010 23 38 33 30 23 n/a 2004 Total # 519 Reported Rate per 3129 100,000 POLICE DEPARTMENT — Page 4 Part I Crimes Per 100,000 2005 2006 2007 2008 2009 488 467 428 398 411 2851 2578 2196 1860 1872 n/a — Information Not Available 2009 809 3686 2009 53% 2009 141 642 2010 n/a 2009 6.22 0��- Part II Crimes 2004 2005 2006 2007 2008 Total # 717 879 858 1020 952 Reported Rate per 4380 5136 4737 5248 4450 100,000 Case Clearance Rate of Reported Crimes (Percent Solved) 2004 2005 2006 2007 2008 55% 59% 57% 61% 62% DWI Arrests 2004 2005 2006 2007 2008 Number 75 128 170 251 236 of Arrests Rate per 458 747 938 1291 1291 100,000 Night to Unite (National Night Out) Neighborhood Parties 2005 2006 2007 2008 2009 Number 26 34 25 31 36 of Events Response Time to Priority 1 Calls for Service 2004 2005 2006 2007 2008 5.62 5.50 6.00 5.97 6.38 n/a — Information Not Available 2009 809 3686 2009 53% 2009 141 642 2010 n/a 2009 6.22 0��- Page One 2011 BUDGET WORKSHEETS POLICE May 28, 2010 Account # Description 101 42110 101.00 Salaries & Benefits 101 42110 102.00 Full -Time Overtime 101 42110 102.01 Regular Overtime Hours 101 42110 102.02 Contracted OR 101 42110 103.00 Part-Time Salaries & Benefits 101 42110 22 103.00 Part-Time Receptionist (2) 101 42110 23 103.00 Part-Time Secretary 101 42110 95 103.00 Part-Time CSO's 101 42110 01 202.00 Duplicating & Copying 101 42110 01 203.00 Primed Forms & Paper 101 42110 01 204.00 Envelopes & Letterheads 101 42110 01 207.00 Training & Instructional Supplies 101 42110 01 207.01 Practice Ammunition 101 42110 01 207.02 Service Ammunition 101 42110 01 207.03 Other Supplies 101 42110 01 207.04 M.AA.G. Ammunition 101 42110 01 208.00 Miscellaneous Supplies 101 42110 01 208.01 DARE Donations 101 42110 01 208.02 Equipment Donations/Forfeitures 101 42110 01 209.00 Other Office Supplies 101 42110 01 211.00 Cleaning Supplies 101 42110 01 211.01 Blanket Cleaning 101 42110 01 211.02 Squad Interior Cleaning 101 42110 01 217.00 Clothing Allowance 101 42110 01 217.01 CSO's 101 42110 01 217.02 Reserves 101 42110 01 217.03 Other Supplies 101 42110 01 219.00 Other Operating Supplies 101 42110 01 219.01 Evidence Bags, Drug Kits, Misc. 101 42110 01 219.02 Accurim Database Services 101 42110 01 221.00 Equipment Parts 101 42110 01 241.00 Small Tools 101 42110 01 241.01 Evidence Processing Equipment 101 42110 01 241.02 Camera and Video Supplies 101 42110 01 241.03 Other Supplies 1014211 Q 01242.00 Minor Equipment 101 42110 01 242.01 Less Lethal Tactical Equipment 101 42110 01 242.02 MAAG Equipment 101 42110 01 304.00 Legal Fees 101 42110 01 305.00 Medical & Dental Fees 101 42110 01 305.01 Employee Drug Testing 101 42110 01 305.02 Seized Narcotic Testing 101 42110 01 306.00 Personnel Testing & Recruitment 101 42110 01 313.00 Temporary Service Fees 101 42110 01 315.00 Special Programs 101421 '10 01 316.00 Animal Care Services 101 42110 01 316.01 Impound & Care Fees 101 42110 01 316.02 "Future Use" 101 42110 01 319.00 Other Professional Services 101 42110 01 319.01 Dispatch Services - Operations 101 42110 01 319.02 Policy Development & Training 101 42110 01 321.00 Telephone Costs 101 42110 01 321.01 Cell Phones 101 42110 01 321.03 LOGIS Communications Line 101 42110 01 323.00 Radio Units 101 42110 01 323.01 Radios ($380 per Unit) 101 42110 01 323.02 Radars 101 42110 01 331.00 Travel Expense 101 42110 01 331.01 MN Chiefs Spring Conference 101 42110 01 331.02 IACP Conference 101 42110 01 331.03 Outstate Investigations & Cont. 101 42110 01 331.04 MAAG Conference 101 42110 01 331.05 CAN -AM Narcotic Conference 101 42110 01 331.06 Juvenile Officers Conference 101 42110 01 331.07 Meeting Reimbursements PAGE TOTALS 3 i� , 2007 Actual 2008 Actual 2009 Actual 2010 Adopted Budget 2011 Object Detail Amount 2011 Proposed Budget Comments All Salary Costs Inclusive of $1,995,799 $2,144,449 $2,263,404 $2,338,400 $2,400,100 Salary, Taxes, PERA & Benefits 72,650 112,323 79,326 65,000 70,000 51,000 19,000 112,200 0 0 41,681 50,600 51,400 2 P/T Receptionists - 44 Hrs/Wk 10,006 9,618 11,989 20,000 20,400 P/T Secretary - 16 Hour&Wk 28,501 27,204 28,447 40,300 40,400 CSO's - Up To 50 Hours/Wk 0 25 0 0 0 1,630 747 762 800 800 Evidence Logs, Animal Lic, etc. 159 0 103 200 200 Business Cards 11,100 3,656 5,345 4,654 5,000 5,000 515 79 7,046 0 1,000 0 229 0 100 100 0 0 0 5,000 5,000 0 Donated & Forfeited Funds 2,659 2,657 2,078 0 0 7,781 7,842 10,224 0 0 1,035 591 826 1,000 1,000 Video, CD's & Miscelaneous 500 0 0 0 0 0 509 0 124 500 500 3,000 331 967 790 1,000 1,000 1,127 1,965 0 2,000 1,000 1,590 0 1,304 1,000 1,000 30 13 2,800 1,999 843 1,361 2,000 2,000 405 380 626 800 800 3,919 1,775 2,048 2,500 2,500 Squad Emergency Equip Repairs 2,000 Crime Scene Kit Supplies 145 800 558 750 750 758 206 1,163 500 500 417 970 1,000 750 750 Digital Recorders 1,500 760 943 658 1,500 1,000 Training Supplies, Taser Batteries 383 499 500 500 500 55,010 54,996 56,499 56,700 57,900 Prosecution 2,000 1,074 809 478 1,000 1,000 340 663 1,429 5,000 1,000 Sup. Ct. Decision - Blood Draws 825 875 868 1,000 1,000 Medical & Psychological 715 464 106 1,200 1,200 Interpreter Services 11,994 0 0 0 0 6,000 Eliminate Cat Licensing 9,918 10,943 11,240 12,000 6,000 0 0 0 0 0 317,100 232,230 232,800 338,412 297,000 307,100 19,608 24,586 0 0 10,000 4,800 4,826 4,371 5,225 4,800 4,800 444 74 0 0 0 Not Applicable - Fiber Now Used 12,000 221 6,944 9,213 11,500 11,500 800 MHz Subscriber Fees 220 430 520 500 500 Radar & LIDAR Repairs 2,500 302 0 387 500 500 1,639 1,865 0 1,500 0 120 693 430 500 500 441 624 733 400 600 258 0 245 400 300 610 325 785 300 500 160 190 48 100 100 2,477,720 2,662,125 2,887,289 2,934,600 3,012,200 Page Two 2011 BUDGET WORKSHEETS POLICE May 28, 2010 Account # Description 101 42110 01 333.00 Freight & Express Expenses 101 42110 01 394.00 P.C. Software Purchases 101 42110 01 394.01 Automated Pawn System 101 42110 01 394.02 Pictometry 101 42110 01 394.03 CAIN System 101 42110 01 396.00 Computer Maintenance 101 42110 01 396.01 Records Management 101 42110 01 396.02 CJDN Connection Charges 101 42110 01 396.03 MCD Connection Charges 101 42110 01 396.04 MCD Maintenance & Cellular 101 42110 01 396.05 LOGIS Annual Fees 101 42110 01 433.00 Dues & Subscriptions 101 42110 01 433.01 Mutual Aid Assistance Group -MAAG 101 42110 01 433.02 IACP Chiefs 101 42110 01 433.03 MN Chiefs of Police 101 42110 01 433.04 Dakota Cty Chiefs of Police 101 42110 01 433.05 Wakote CAER 101 42110 01 433.06 Metro Emergency Managers 101 42110 01 433.07 MN Sex Crimes Investigators 101 42110 01 433.08 Tri-County Investigators 101 42110 01433.09 MN Crime Prevention Association 101 42110 01 433.10 P.O.S.T. Licenses 101 42110 01 433.11 FBI Natl Academy Association 101 42110 01433.12 Miscellaneous 101 42110 01 435.00 Books & Pamphlets 101 42110 01 436.00 Towing Charges 101 42110 01 437.00 Conferences & Seminars 101 42110 01 437.01 Firearms - Range 101 42110 01 437.02 Chiefs Spring Conference 101 42110 01 437.03 Investigations 101 42110 01 437.04 IACP Conference 101 42110 01437.05 Supervision 101 42110 01 437.06 Use of Force 101 42110 01 437.07 Emergency Driving 101 42110 01 437.08 First Aid 101 42110 01 437.09 Narcotic Enforcement 101 42110 01 437.10 Tactical 101 42110 01 437.11 Support Services 101 42110 01437.12 Patrol Ops. 101 42110 01437.13 Emergency Management 101 42110 01 439.00 Other Miscellaneous Charges 101 42110 01 580.00 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 37 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 138 141 38 200 200 Repairs 12,200 432 240 240 500 300 1,504 1,388 1,388 1,500 1,400 10,474 10,474 10,474 10,500 10,500 65,600 31,069 34,377 35,188 32,500 33,000 CAD Included in DCC in 2007 2,520 2,981 3,443 2,800 2,800 1,384 1,845 1,620 2,000 2,000 17,753 15,115 18,647 20,500 20,000 6,942 7,275 2,779 7,800 7,800 4,300 2,100 3,000 3,200 3,200 3,200 100 120 120 100 125 165 165 215 175 225 35 35 0 50 50 20 0 0 20 20 0 0 0 60 0 18 0 0 20 20 60 0 50 60 60 55 90 0 55 65 810 360 1,080 800 400 0 0 0 0 0 55 165 75 160 135 1,118 943 238 1,000 1,000 Crime Prevention Materials 0 0 0 200 200 Disabled Squads 10,000 2,071 5,931 2,085 2,000 2,000 Range Rental 425 0 420 500 500 2,020 1,920 1,710 1,500 1,700 275 275 0 250 0 665 755 480 750 500 0 100 1,750 600 900 2,100 1,120 2,740 1,400 1,000 700 0 950 1,250 1,000 307 0 100 500 200 690 0 1,320 750 1,000 40 245 15 250 200 1,050 618 105 1,250 800 0 0 0 0 200 510 282 476 500 500 Refreshments for Meetings & Compliance Checks 0 0 0 0 0 $87,605 $89,961 $90,947 $95,700 $94,000 $2,565,325 $2,752,086 $2,978,235 $3,030,300 $3,106,200 3 FIRE DEPARTMENT MISSION / VISION / GOALS The Rosemount Fire Department's mission is an intricate component of the overall mission of the City of Rosemount in that the Fire Department is dedicated to the saving of life and property. This component which the Fire Department provides compliments and provides a necessary service so that the City may reach its broader mission of providing a safe, healthy and pleasant community in which to live and work. This service is provided by a paid -on -call department, which is the most fiscally sound method of delivery at this point in the City of Rosemount's development. The Rosemount Fire Department enhances the overall vision that is set for the City of Rosemount in that it provides the opportunity for individuals to demonstrate their pride in the community by serving on a "volunteer" fire department and assisting their neighbors. The "volunteer" Fire Department has historically been associated with the kind of small town character that Rosemount is striving to maintain. ADMINISTRATIVE / MANAGEMENT Provides for the overall administration and management of the Fire Department. Included is the collection, preparation and dissemination of information; the preparation of operating budgets, Capital Improvement Projects (CIP) budgets and state reports; and planning for the long and short term needs with respect to training, fire protection, emergency medical response, facilities, staffing and the acquisition and maintenance of equipment, along with the coordination of efforts between other emergency response agencies and those of the City of Rosemount. FIRE SUPPRESSION / INVESTIGATION • Provides for the controlling and extinguishing of all types of fires in order to minimize injury, loss of life and loss of property within the City of Rosemount, both to its citizens and visitors. • Provides for the controlling and extinguishing of all types of fires in order to minimize injury, loss of life and loss of property within the contracted areas of Coates and the University of Minnesota, along with the railroad right -of -ways. • Provides for the provision of all of these fire services to all the cities of Dakota County and many of the cities of Washington County via a mutual aid agreement by which these services can be reciprocated on an as needed basis. 03� " FIRE DEPARTMENT — Page 2 • Provides for the investigation of fires by the local Fire Marshal. Also provides for the coordination of joint investigations by the local Fire Marshal and the State Fire Marshal. RESCUE SQUAD • Provides for emergency operations pertaining to bodily injury or serious illness requiring emergency services within the City of Rosemount, both to its citizens and visitors. • Provides for emergency operations pertaining to bodily injury or serious illness requiring emergency services within the contracted areas of Coates and the University of Minnesota. • Provides for the provision of all of these emergency operations to all the cities of Dakota County and many of the cities of Washington County via a mutual aid agreement by which these services can be reciprocated on an as needed basis. HAZARDOUS MATERIAL RESPONSE / CONFINED SPACE RESPONSE • Provides a team of Operations Level, Technician Level and Specialists, trained to respond to hazardous material accidents, identify, secure and coordinate the efforts of outside agencies that are trained to contain, mitigate and clean up the spill. • Trains all firefighters to respond to confined space incidents, evaluate the situation and mitigate or coordinate the rescue effort. TRAINING / EDUCATION • Provides for the necessary monthly and annual training requirements. • Allows for training in areas above those that are required, in order that fire and rescue personnel may sharpen existing skills and acquire new skills. • Allows for training of fire fighters to prepare themselves for the acceptance of a position of leadership within the Fire Department. oq,) FIRE DEPARTMENT - Page 3 HEALTH TESTING • Provides for the screening and medical certification of potential new fire fighters. • Allows for the continuous health monitoring of existing personnel. • Provides for the protection of personnel from blood -borne pathogens and communicable disease. EQUIPMENT / MAINTENANCE • Allows for the replacement or addition of equipment necessary for fire and medical response, including both consumable and nonconsumable items. • Provides for the emergency contracting with outside providers for repairs of fire vehicles and specialized equipment. STAFFING • In 2010, the Fire Department consisted of 42 paid on -call firefighters serving in various capacities within the department. This number is constantly changing due to retirements and new additions. We have 5 people who have reached or exceeded full retirement requirements, but often people retire prior to the full 20 years. We hope to end 2011 with a department of not less than 46 firefighters. PERFORMANCE MEASURES Total Number of Paged Calls 2005 2006 2007 2008 2009 Fire n/a n/a n/a 229 303 Medical n/a n/a n/a 540 329 Average Response Time: High Priority Calls 2005 2006 2007 2008 2009 n/a n/a n/a n/a n/a FIRE DEPARTMENT — Page 4 Number of Attendances at Outside Training 2005 2006 2007 2008 2009 n/a n/a n/a 10 36 Total Number of Fire Fighters 2005 2006 Total 41 41 Added n/a n/a Net Change n/a n/a Number of 2005 2006 n/a n/a n/a — Information Not Available 2007 2008 2009 41 43 42 n/a 4 5 n/a 2 -1 - ustomer Complaints 2007 2008 2009 n/a 0 1 0q, Page One 2011 BUDGET WORKSHEETS FIRE May 28, 2010 Account # Description 101 42210 103.00 Salaries & Benefits 10142210 103.01 Salaries 101 42210 103.02 Training Pay /Stipends 101 42210 103.03 Call Pay /Stipends 101 42210 103.04 Class Pay /Stipends 101 42210 103.05 PIT Fire Marshal 101 42210 01 202.00 Duplicating & Copying 101 42210 01 202.01 Copy Toner 101 42210 01 202.02 Computer Printers 101 42210 01 204.00 Envelopes & Letterhead 101 42210 01 204.01 Envelopes 101 42210 01 204.02 Letterhead 101 42210 01 204.03 Forms 101 42210 01 208.00 Miscellaneous Supplies 101 42210 01 208.01 Supplies, Computer Support 101 42210 0120&02 Film Developing 101 42210 01 208.03 Memberships 101 42210 01 208.04 Code Books 101 42210 01 208.05 Training 101 42210 01 211.00 Cleaning Supplies 101 42210 01 211.01 Soaps 101 42210 01 211.02 Chamois, Towels, etc. 101 42210 01 211.03 Sponges, etc. 101 42210 01 211.04 SCBA Cleaner 101 42210 01 218.00 Fire Department Clothing 101 42210 01 219.00 Other Operating Supplies 101 42210 01 219.01 Gloves 101 42210 01 219.02 Bandages 101 42210 01 219.03 Equipment 101 42210 01 219.04 Tyvek Suits 101 42210 01 219.05 Consummable Medical 101 42210 01 219.06 Oxygen 101 42210 01 229.00 Other Maintenance Supplies 101 42210 01 229.01 Aerial- Pumpers - Tanker 101 42210 01 229.02 Pickup Trucks 101 42210 01 229.03 Rescue & Other 101 42210 01 229.04 Vehicle Modifications 101 42210 01 230.00 Equipment Repair Materials 101 42210 01 230.01 Light Bars 101 42210 01 230.02 Smoke Machines 101 42210 01 230.03 Lanterns & Miscellaneous 101 42210 01 230.04 Small Tool Repairs 101 42210 01 230.05 Opticom 101 42210 01 230.06 Station 101 42210 01 241.00 Small Tools 101 42210 01 241.01 Axes, Bars & Other 101 42210 01 241.02 Grass Fire 101 42210 01 241.03 Hand Tools 101 42210 01 305.00 Medical & Dental Fees 101 42210 01 306.00 Personnel Testing & Recruitment 101 42210 01 306.01 New Physicals (5) 101 42210 01 306.02 Hepatitis Shots (5) 101 42210 01 306.03 Background Checks (5) 101 42210 01 306.04 Drug Testing (5) 101 42210 01 308.00 Instructors' Fees 101 42210 01 308.01 Fire Fighter 1 (5) 101 42210 01 308.02 Fire Fighter 1 Certificates (5) 101 4221001 308.03 Fire Fighter Re- Certificates (17) 101 4221001 308.04 First Responder (5) 101 42210 01 308.05 First Responder Refresher (1/2) 101 42210 01 308.06 Outside Schools ($12) 101 42210 01 308.07 Haz -Mat Training (5) 101 42210 01 308.08 Apparatus Re- Certificates PAGE TOTALS y 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments ^^ ^^ All Salary Costs Inclusive of $96,884 $75,329 $54,810 $55,000 $55,000 Salary, Taxes, PERA & Benefits 30,000 4,000 20,900 100 0 Position Eliminated in 2008 100 107 0 43 50 50 0 0 69 50 50 100 0 0 0 25 25 0 0 0 25 25 0 0 422 50 50 0 Supplies for Fire Marshal 851 1,040 0 0 0 217 101 0 0 0 35 0 0 0 0 82 140 0 0 0 905 700 0 0 0 800 1,217 140 937 550 550 116 0 0 50 50 39 0 18 50 50 75 0 59 150 150 45 0 3,495 400 400 5 Uniforms $80 Each 4,800 Medical Supplies 659 314 633 1,000 1,000 0 0 0 100 100 751 937 637 1,000 1,000 0 0 0 100 100 2,105 891 437 2,200 2,200 137 146 74 400 400 700 0 45 0 200 200 13 0 45 100 100 0 650 67 300 300 0 72 380 100 100 2,100 0 0 0 100 100 0 0 0 250 250 478 61 356 250 250 700 543 3,658 600 600 0 0 0 300 300 307 1,624 477 600 600 700 245 110 162 150 150 195 0 85 250 250 998 378 430 300 300 2,805 2,850 611 3,500 3,500 Annual Medical Tests 2,300 1,955 2,925 2,181 1,325 1,325 651 151 102 625 625 29 121 146 125 125 0 0 0 225 225 10,000 974 1,198 480 1,500 2,000 645 120 241 600 200 0 195 100 200 340 2,210 0 762 1,200 1,200 715 1,200 1,200 1,400 1,400 6,647 5,651 3,558 3,550 3,550 0 0 0 1,250 1,250 0 45 0 0 60 123,792 97,679 76,673 80,200 80,500 Page Two 2011 BUDGET WORKSHEETS FIRE May 28, 2010 Account # Description 101 42210 01 310.00 Testing Services 101 42210 01 310.01 Aerial 101 42210 01 310.02 Ladders 101 42210 01 310.03 Pumpers (3) (Next 2012) 101 42210 01 310.04 SCBA Hydro Testing (Next 2013) 101 42210 01 313.00 Temporary Service Fees 101 42210 01 313.01 SCBA Contract & Repairs 101 42210 01 313.02 SCBA Flow Test 101 4221001 313.04 Security Contract 101 42210 01 313.05 SOT Joint Powers 101 42210 01 314.00 Annual Fire Relief Contribution 101 42210 01 319.00 Other Professional Services 101 42210 01 319.01 School Literature 101 42210 01 319.02 Door Prizes 101 42210 01 319.03 Fire Prevention Week Promos 101 42210 01 319.04 Food at Open House 101 42210 01 319.05 Summer Park Education 101 42210 01 319.06 National Night Out 101 42210 01 321.00 Telephone Costs 101 42210 01 321.01 Fire Dept. Cell Phones 101 42210 01 321.02 Fire Marshal Cell Phone 101 42210 01 321.03 "Future Use" 101 42210 01 321.04 Numeric Pagers 101 42210 01 322.00 Postage Costs 101 42210 01 329.00 Other Communication Costs 101 42210 01 329.01 Base Repairs 101 42210 01 329.02 Pager Repairs 101 42210 01 329.03 Hand Held Repairs 101 42210 01 329.04 Mobile Repairs 101 42210 01 329.05 800 MHZ User Fee 101 42210 01 331.00 Travel Expense 101 42210 01 331.01 Minnesota Chiefs Conference 101 42210 01 331.02 Fire Department Association 101 42210 01 331.03 Outside Schools 101 42210 01 333.00 Freight & Express Expense 101 42210 01 433.00 Dues & Subscriptions 101 42210 01 433.01 Capital City 101 42210 01 433.02 VFBA Insurance 101 42210 01 433.03 State Fire 101 42210 01 433.04 State Chiefs 101 42210 01 433.05 DCFC 101 42210 01 433.06 WAKOTA Mutual Aid 101 42210 01 433.07 Purchasing Consortium 101 42210 01 433.08 NFPA 101 42210 01 433.09 "Future Use" 101 42210 01 437.00 Conferences & Seminars 101 42210 01 437.01 State Fire Conference 101 42210 01 437.02 State Chiefs Conference 101 42210 01 439.00 Other Miscellaneous Charges 101 42210 01 439.01 Food & Coffee 101 42210 01 439.02 Extinguisher 101 42210 01 439.03 Plaques 101 42210 01 439.04 Paint 101 42210 01 439.05 Station Needs 101 42210 01 580.00 Other Equipment Purchases 101 42210 01 580.01 Bunker Gear (7) 101 42210 01 580.02 Pagers (6) 101 42210 01 580.03 Hose Replacement 101 42210 01 580.04 Replace Damaged Items 101 42210 01 581.00 Other Equipment Purchases 101 42210 01 586.00 Computer Equipment Purchase PAGE TOTALS DEPARTMENT TOTALS (iD 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 1,500 821 0 750 1,000 1,000 0 0 474 500 500 0 855 0 900 0 0 0 0 1,300 0 7,800 592 557 2,315 2,300 2,300 2,922 269 2,047 2,000 2,000 380 617 631 800 800 2,301 2,724 2,637 2,700 2,700 147,600 152,000 156,500 161,200 166,000 1,300 Fire Prevention Education 0 0 0 200 200 0 212 0 200 200 525 538 1,028 500 500 511 402 300 200 200 44 66 98 100 100 0 0 0 100 100 1,300 599 1,103 822 1,300 1,300 124 250 1,024 0 0 140 334 306 0 0 78 92 93 100 0 0 0 13 100 100 UPS Costs 13,800 0 0 0 100 100 808 937 930 1,500 1,500 330 0 51 100 100 125 0 0 100 100 0 7,604 10,400 15,000 12,000 3,900 1,632 1,484 1,584 2,000 2,000 1,736 2,159 294 1,600 1,600 489 0 0 300 300 0 10 0 0 0 1,300 50 50 50 50 50 324 354 0 550 550 165 360 360 300 300 165 290 145 250 250 100 75 75 60 60 0 50 100 50 50 35 35 0 40 40 0 150 0 0 0 0 0 0 0 0 900 0 0 594 400 400 450 0 320 500 500 1,600 50 59 18 150 150 860 0 196 300 300 0 60 102 40 40 0 0 0 70 70 2,496 1,017 649 1,040 1,040 21,600 11,627 16,282 15,901 15,000 15,000 3,204 0 4,231 3,600 3,600 Replacements 4,694 0 2,099 1,000 1,000 7,141 2,336 3,542 2,000 2,000 0 0 0 0 0 0 7,069 4,228 0 0 $193,116 $200,398 $214,907 $221,600 $221,100 $316,909 $298,077 $291,580 $301,800 $301,600 -- - - - - -- -- - - ---- -- - - - - -- -- - - - --- -- -- - --- - -- - - - -- -------- - - - - - - -- -- - - - - -- -- - - -- -- - - - - - - -- -- - -- - -- PUBLIC WORKS The Public Works Department has a mission to enhance the quality of life through responsive, efficient, and cost - effective delivery of services consistent with community values. With sound management, fiscal responsibility and professional care, the Department will preserve and protect the infrastructure resources of the City, creating a safe, clean and enjoyable environment for residents and businesses. The Public Works Department consists of the Engineering and Operations Divisions. The maintenance personnel maintain the streets, storm drainage, sanitary sewer and potable water systems, along with all government buildings, parks and all City grounds. The Department manages its expenditures and revenues through the following four (4) maintenance funds and three (3) enterprise funds: Government Buildings Fleet Maintenance Street Maintenance Parks Maintenance ( *) Water Operating ( *) Sewer Operating ( *) Storm Water Operating ( *) Separate Enterprise Fund Budgets from those included here under the advisement of the Utility Commission of the City of Rosemount. The Public Works Department currently has a combined permanent work force of 26 positions for the areas of engineering, buildings, fleet maintenance, streets, parks and the enterprise - funded utilities. Also, the City employs up to 14 seasonal part-time people to help during periods that require higher levels of maintenance. The Public Works budget also incorporates the contract for consulting services currently held to fill the position of the Director of Public Works / City Engineer. PUBLIC WORKS — Page 2 - RESPECTIVE BUDGETS - GOVERNMENT BUILDINGS This budget provides for the management, operation, maintenance and repair of the City's buildings. This includes City Hall, the MN DOT garage, the Public Works building and garage, and two Fire Stations. It also includes three (3) park shelters, the old St. Joseph's Church, the Dakota County Library (plowing only), and the Family Resource Center. Maintenance and operation of the Community Center / Ice Arena is not included in this budget. FLEET MAINTENANCE This budget provides for the maintenance of all City -owned vehicles and over 250 pieces of large and small equipment. It provides funding for all fuels, oils, parts, tires, shop supplies, and contracted vehicle maintenance. The City -owned vehicles include: • Police Department (11 cars, 3 trucks) • Fire Department (6 pickup trucks, 7 fire /rescue trucks) • Parks and Recreation (1 truck, 1 van, 1 car, 1 SW, 1 ice resurfaces) • Administration / Community Development (2 cars, 2 trucks, 1 van) • Utility Department (1 Jetter, 1 Vactor, 2 trucks) • Streets and Parks Maintenance (2 sweepers, 3 tractors, 2 loaders, 2 skidsters, 7 dump trucks, 6 mowers, 13 trucks, 2 compactors, 1 roller, 1 ATV, 4 snow blowers) • 5 large trailers STREET MAINTENANCE This budget provides for the maintenance and preservation of 103 miles of City roads, 93 miles of sidewalks and bike trails, and 20 parking lots. Standard maintenance includes grading, graveling, patching, sealing and overlays. This budget also provides for pavement markings, street signs, street lighting, signal light maintenance and power, snow and ice control, and street sweeping. PARKS MAINTENANCE This budget provides for the maintenance of over 360 acres of park area in 25 locations, including 12 parks with athletic fields and 11 parks with shelters or pavilions. It includes the maintenance of all park trails and 10 other municipal areas, including City Hall, two Fire Stations and the Community Center. It also includes the installation and maintenance of playground equipment, landscaping projects, ice rink construction and maintenance (4 hockey rinks, 6 pleasure rinks), and other miscellaneous construction activities. Yoko I PUBLIC WORKS — Page 3 PERFORMANCE MEASURES Value of Projects Ordered (Contract Amount) 2005 2006 2007 2008 2009 2010 (es4 n/a $8,422,192 $3,160,046 $4,057,030 $1,414,284 $5,400,000 % Change from Prior Year (Above) 2005 2006 2007 2008 2009 2010 4est n/a n/a -62.5% 28.4% -65.1% 281.8% Average Number of Hours for Full Snow Clearing Event 2005 -06 2006 -07 2007 -08 2008 -09 2009 -10 2010 -11 (est n/a n/a n/a n/a 7.125 7.125 % of Mechanics' Time Spent on Repair / Maintenance 2004 2005 2006 2007 2008 2009 2010 est n/a n/a 81% * 93% 93% 96% 95% Park Acres Maintained 2004 2005 2006 2007 2008 2009 2010 n/a n/a 130 135 127 133 133 n/a — Information Not Available * 2006 tracking was done on paper, less accurate than CarteGraph tracking (started in 2007). Page One Cq 1 2011 BUDGET WORKSHEETS GOVERNMENT BUILDINGS May 28, 2010 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41940 101.00 Salaries & Benefits $0 Salary, Taxes, PERA & Benefits 101 41940 79 101.01 Maintenance Staff 49,402 10,521 0 0 0 Increase to "319.09" Below 101 41940 102.00 Full -Time Overtime 2,689 0 0 0 0 101 41940 01 208.00 Miscellaneous Supplies 20,513 16,717 16,399 17,000 19,000 Cleaning Supplies, Towels, Flags 101 41940 01 223.00 Building Repair Supplies 5,924 9,231 8,910 9,200 9,200 101 41940 01 225.00 Landscaping Materials 169 466 116 2,500 1,500 Trees & Shrubs (Fire Stations) 101 41940 01 241.00 Small Tools 355 9 179 200 200 Hand Tools, Bits, Blades, etc. 101 41940 01 242.00 Minor Equipment 2,804 2,066 1,468 2,000 2,000 Equipment Replacement 101 41940 01 302.00 Architects' Fees 3,000 0 0 0 0 Estimates 101 41940 01 318.00 Contract Engineer 750 1,500 1,500 1,500 1,500 Contracted Engineer for City (5 %) 101 41940 01 319.00 Other Professional Services 76,500 101 41940 01 319.01 Elevator Maintenance 2,702 1,498 1,695 1,500 1,500 101 41940 01 319.02 Heating/Cooling Maint Contract 1,107 7,048 8,310 7,000 7,000 Includes all City Facilities 101 41940 01 319.03 Annual Boiler Inspections / Maint. 659 476 1,128 1,500 1,500 101 41940 01 319.04 Pest Control 2,036 2,146 2,180 2,500 2,500 101 41940 01 319.05 Fire Extinguishers 1,805 2,308 738 3,000 2,500 101 41940 01 319.06 Fire Suppression System Check 2,825 3,044 3,484 3,500 3,500 101 41940 01 319.07 Janitorial Service-Fire Stations 10,633 10,452 10,908 10,500 10,500 $9,372 + Toiletries 101 41940 01 319.08 Janitorial Service-P.W. Building 13,266 10,555 11,104 11,500 11,500 $9,852 + Toiletries 101 41940 01 319.09 Janitorial Service -City Hall 0 25,826 26,183 25,000 25,000 $22,956 + Toiletries 101 41940 01 319.10 Floor Mats - Monthly Charges 0 0 3,817 3,800 4,000 101 41940 01 319.11 Other Janitorial Services 0 0 0 7,000 7,000 Waxing Floors, Carpet Cleaning 101 41940 01 381.00 Electric Utilities 62,795 64,821 62,637 75,000 70,000 101 41940 01 382.00 Water Utilities 40 0 0 0 0 101 41940 01 383.00 Gas Utilities 63,317 80,087 61,001 80,000 80,000 101 41940 01 384.00 Refuse Disposal 30,000 101 41940 01 384.01 General Buildings & Parks 13,399 14,169 15,175 16,000 16,000 101 41940 01 384.02 Recycling/Cleanup 12,381 12,858 12,201 14,000 14,000 2 Cleanup Days per Year 101 41940 01 389.00 Other Utility Services 3,810 3,528 0 0 0 Moved to "319.10" Above 101 41940 01 401.00 Contracted Building Repairs 167 40,000 101 41940 01 401.01 Electrical Repairs 4,070 6,112 4,202 5,000 5,000 101 41940 01 401.02 Siren Replacement Program 10,018 10,000 10,000 10,000 10,000 101 41940 01 401.03 Miscellaneous Repairs 40,332 22,493 25,353 25,000 25,000 101 41940 01 401.04 Roof Inspection 0 0 123 0 0 101 41940 01 415.00 Other Equipment Rental 307 0 103 1,000 1,000 Scaffolding, Cleaners 101 41940 01 439,00 Other Miscellaneous Charges 0 0 0 5,000 5,000 Energy Efficiency Improvements 101 41940 01 530.00 Improvements Other Than Buildings 10,000 142,196 84,606 70,000 70,000 101 41940 01 601.00 Bond Principal 43,579 46,000 48,421 50,900 60,600 MSABC Payment (2/1) 101 41940 01 611.00 Bond Interest 37,205 33,186 29,034 29,100 25,400 MSABC Payments (2/1 & 8/1) 101 41940 01 621.00 Bond Paying Agent Fees 0 0 0 0 0 PAGE TOTALS $422,060 $539,315 $450,974 $490,200 $491,900 DEPARTMENT TOTALS $422,060 -------- $539 ,315 -- - - - - -- $450,974 - - - - - - -- $490,200 -- - - - - -- -- - -- - -- $491,900 -- - -- --- Page One 2011 BUDGET WORKSHEETS FLEET MAINTENANCE May 28, 2010 Account # Description 101 43100 101.00 Salaries & Benefits 101 43100 77 101.00 Administrative 101 43100 79 101.00 Maintenance 101 43100 102.00 Full -Time Overtime 101 43100 01 211.00 Cleaning Supplies 101 43100 01 212.00 Motor Fuels 101 43100 01 213.00 Lubricants & Additives 101 43100 01 215.00 Shop Materials 101 43100 01 221.00 Equipment Parts 101 43100 01 222.00 Tires 101 43100 01 241.00 Small Tools 101 43100 01 242.00 Minor Equipment 101 43100 01 318.00 Contract Engineer 101 43100 01 321.00 Telephone Costs 101 43100 01 323.00 Radio Units 101 43100 01 384.00 Refuse Disposal 101 43100 01 394.00 P.C. Software Purchases 101 43100 01 404.00 Contracted Mach & Equip Repairs 101 43100 01 416.00 Machinery Rental 101 43100 01 417.00 Uniforms Rental 101 43100 01 433.00 Dues & Subscriptions 101 43100 0`1435.00 Books & Pamphlets 101 43100 01 437.00 Conferences & Seminars PAGE TOTALS DEPARTMENT TOTALS a Estimated Fuel Cost for 2011 Unleaded $2.65 /gallon x 40,000 gallons $106,000 Diesel $2.65 /gallon x 26,000 gallons 68,900 Total for motor fuels $174,900 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $163,700 Salary, Taxes, PERA & Benefits 10,506 10,954 11,274 11,600 11,900 131,936 138,537 143,260 147,000 151,800 1,185 1,786 1,971 5,000 3,000 1,082 1,022 987 1,000 1,000 Shop & Vehicles 167,365 173,858 126,007 210,000 175,000 Price Estimate (See Below) 9,188 8,712 7,891 10,000 10,000 Price Increase, Fleet Expansion 14,649 18,535 12,732 17,000 17,000 90,275 115,712 102,642 120,000 120,000 Fleet Expansion 9,976 15,718 11,854 40,000 20,000 Squads, Possibly 2 Dump Trucks 3,898 4,444 3,504 4,000 4,000 2,633 6,246 4,339 4,000 4,000 1,500 3,000 3,000 3,000 3,000 Contracted Engineer for City(10 %) 0 0 0 0 0 850 284 1,104 2,000 3,000 Repair /Replace Units (2 Add'I) 154 158 10 300 300 Shop Hazardous Waste 0 0 284 500 1,600 CarteGraph Maintenance 20,524 25,340 44,680 35,000 40,000 0 0 0 1,000 1,000 139 226 295 0 0 More Accurate Allocations (433.00) 0 75 1,575 100 1,600 DOT Certification, ALLDATA 51 51 129 0 100 DOT Decals and Inspection Pads 364 0 348 800 300 $100- CarteGraph; $200 -Mist. $466,276 $524,657 $477,886 $612,300 $568,600 $466,276 -- - - - - -- -------- $524,657 -- - - - - -- -- - - - --- $477,886 -- - - - - -- -- - - ---- $612,300 -- - - - - -- -- - - - - -- -- - - -- -- -- - -- - -- $568,600 - - - - - -- -- - - - - -- Estimated Fuel Cost for 2011 Unleaded $2.65 /gallon x 40,000 gallons $106,000 Diesel $2.65 /gallon x 26,000 gallons 68,900 Total for motor fuels $174,900 Page One 2011 BUDGET WORKSHEETS STREET MAINTENANCE May 28, 2010 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43121 101.00 Salaries & Benefits $509,600 Salary, Taxes, PERA & Benefits 101 4312177 101.00 Administrative 31,519 32,861 33,821 34,700 35,700 101 43121 78 101.00 Technical/Clerical 57,671 60,134 62,847 64,600 66,600 101 43121 7G101.00 Maintenance 360,684 376,362 389,176 395,200 407,300 101 43121 102.00 Full-Time Overtime 10,601 11,817 13,177 14,000 14,000 Maintenance 101 43121 9G103.00 Part-Time Salaries & Benefits 19,167 25,630 33,759 25,000 31,500 Includes ($6,500 for Horticulturist) ($6,500 Moved from P &R) 101 43121 01 201.00 Office Accessories 151 0 0 100 100 101 43121 01 203.00 Printed Forms & Paper 200 101 43121 01 203.01 R/W Permit & Inspection Forms 0 0 0 200 200 101 43121 01 203.02 Work Orders 0 0 0 100 0 Work Orders Through CarteGraph 101 43121 01203.03 City Specification Books 0 0 1,956 0 0 101 43121 01205.00 Drafting Supplies 1,400 101 43121 01 205.01 Paper for Plan Reproductions 547 856 936 2,000 1,000 Plotter (Ink and Paper) 101 43121 01 205.02 Off -Site Reproductions 95 88 246 450 400 101 43121 01 205.03 Film & Developing 0 0 0 0 0 101 43121 01 205.04 Miscellaneous Tools 0 0 0 550 0 101 43121 01 209.00 Other Office Supplies 144 492 154 500 500 101 43121 01 216.00 Chemical & Chemical Products 65,339 79,449 48,212 90,000 75,000 Road Saft - See P.2 101 43121 01 224.00 Street Maintenance Materials 2,500 101 43121 01 224.01 Paint 543 105 208 500 500 101 43121 01 224.02 Mail Boxes 662 465 611 500 500 101 43121 01 224.03 Light Bulbs/Lenses 684 613 396 1,500 1,500 Replace with LED Bulbs 101 43121 01 225.00 Landscaping Materials 17,500 101 43121 01 225.01 Sod 37 1,917 0 1,500 1,500 101 43121 01 225.02 Seed 0 298 0 200 200 101 43121 01 225.03 Black Dirt 195 820 250 1,000 1,000 101 43121 01 225.04 Trees 0 490 469 500 500 101 43121 01 225.05 Hanging Baskets 0 0 4,571 5,000 5,000 101 43121 01 225.06 Entrance Monuments 0 0 0 0 6,000 101 43121 01 225.07 Downtown Planters 0 0 0 0 1,300 101 43121 01 225.08 Park Signs & RCC 0 0 0 0 2,000 101 43121 01 226.00 Sign Repair Materials 9,146 14,507 12,483 15,000 15,000 101 43121 01 231.00 Bituminous Patching Materials 36,565 28,566 32,495 40,000 40,000 101 43121 01 232.00 Crushed Rock 30,077 23,550 29,395 30,000 30,000 101 43121 01 233.00 Dust Control Materials 29,368 21,101 35,197 35,000 25,000 Nothing East of Akron Avenue 101 43121 01 234.00 De -Icing Sand / Rock 2,476 0 3,531 2,000 5,000 Gravel Road Ice Control(Estimate) 101 43121 01 235.00 Shouldering Gravel 2,465 1,107 576 3,000 0 101 43121 01 241.00 Small Tools 1,603 1,248 1,657 2,000 2,000 Shovels, Brooms, etc. 101 43121 01 242.00 Minor Equipment 2,835 902 3,506 4,000 4,000 Safety Equipment / Power Tools 101 43121 01 303.00 Engineering Fees 37,886 22,578 45,778 8,500 8,500 General Non -Project Related 101 43121 01 304.00 Legal Fees 1,063 440 578 1,000 0 101 43121 01 305.00 Medical & Dental Fees 0 0 0 600 600 Employment Physicals 101 43121 01 310.00 Testing Services 0 0 0 1,200 0 101 43121 01 313.01 Temporary Service Fees 681 0 0 0 0 101 43121 01 318.00 Contract Engineer 3,000 6,000 6,000 6,000 6,000 Contracted Engineer for City(20 %) 101 43121 01 319.00 Other Professional Services 1,727 0 544 500 500 Random Drug Testing to Admin 101 43121 01 321.00 Telephone Costs 2,442 2,484 3,073 3,000 3,000 Includes Wireless Technology 101 43121 01 323.00 Radio Units 0 0 0 1,300 1,500 800 MHZ Monthly Charges 101 43121 01 324.00 Messenger Services 0 29 0 100 100 101 43121 01 331.00 Travel Expense 512 35 206 500 500 101 43121 01 341.00 Employment Advertising 0 0 0 0 0 101 43121 01 381.00 Electric Utilities 171,000 101 43121 01 381.01 Street Lights 142,407 149,837 159,178 165,000 165,000 Price Increases, More Lights 101 43121 01 381.02 Signal Lights & Sirens 5,613 4,940 4,272 6,000 6,000 101 43121 01 384.00 Refuse Disposal 2,000 101 43121 01 384.01 Hazardous Waste Disposal 0 121 0 500 500 101 43121 01 384.02 Roadside Garbage 894 326 392 900 900 101 43121 01 384.03 Tree Disposal 173 0 0 600 600 101 43121 01 391.00 P.C. Maintenance 14,800 101 43121 01 391.01 Gopher State One -Cell 0 0 0 0 0 101 43121 01 391.02 State Aid 0 0 0 0 0 101 43121 01 391.03 Pavement Management Syst Sup 1,729 21,888 0 10,000 10,000 101 43121 01 391.04 R -O -W Permit On -Line Service 0 4,360 4,800 4,800 4,800 101 43121 01 392.00 P.C. Accessories & Supplies 0 0 0 0 0 101 43121 01 392.00 P.C. Hardware Purchases 0 0 0 0 500 Laptop, Truck Mounts 101 43121 01 394.00 P.C. Software Purchases 1,843 901 4,574 5,000 5,500 CarteGraph / GIS Maintenance PAGE TOTALS 862,542 897,318 939,026 984,600 987,800 Page Two 2011 BUDGET WORKSHEETS STREET MAINTENANCE May 28, 2010 Account # Description 101 43121 01 402.00 Parking Lot Seal Coating 101 43121 01 403.00 Contracted Repair & Maintenance 101 43121 01 403.01 Street Lights 101 43121 01 403.02 Signal Lights 101 43121 01 403.03 Light Replacements 101 43121 01 404.00 Contracted Mach & Equip Repairs 101 43121 01 405.00 Street Striping 101 43121 01 406.00 Street Sweeping 101 43121 01 408.00 Street Crack Sealing 101 43121 01 409.00 Tree Trimming 101 43121 01 410.00 Concrete Sidewaik/Curb Repairs 101 43121 01 410.01 General Repairs 101 43121 01 410.02 Pedestrian Improvements 101 43121 01 411.00 Contracted Snow Removal 101 43121 01 411.01 Community Center 101 43121 01 411.02 St. Joseph's 101 43121 01 411.03 Genz -Ryan 101 43121 01 411.04 Dakota County Library 101 43121 01 415.00 Equipment Rental 101 43121 01 416.00 Snow Plow Loader Rental 101 43121 01 433.00 Dues & Subscriptions 101 43121 01 433.01 American Public Works Assn 101 43121 01 433.02 "Future Use" 101 43121 01433.03 City Engineers' Association 101 43121 01 433.04 Professional Secretaries 101 43121 01 433.05 MN Society for Professional Eng. 101 43121 01 433.06 American Society of Civil Eng. 101 43121 01 433.07 MN Street Superintendent Ass'n 101 43121 01 433.08 "Future Use' 101 43121 01 435.00 Books & Pamphlets 101 43121 01435.01 "Future Use" 101 43121 01 435.02 "Future Use" 101 43121 01 437.00 Conferences & Seminars 101 43121 01 437.01 APWA 101 43121 01 437.02 Computer Training 101 43121 01 437.03 Clerical 101 43121 01 437.04 Gravel Road Maintenance 101 43121 01437.05 Maintenance Expo 101 43121 01437.06 CaneGraph User Conference 101 43121 01 437.07 Snow Conference 101 43121 01 437.08 MN Dot 101 43121 01 437.09 Miscellaneous Training 101 43121 01 439.00 Other Miscellaneous Charges 101 43121 01 570.00 Office Equipment & Furnishings PAGE TOTALS DEPARTMENT TOTALS L 2010 2011Objecl 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 0 16,871 10,000 11,500 5,000 29,000 26,390 31,440 14,231 28,500 28,500 Repair 9 Street Lights (Annually) 0 792 767 500 500 0 0 1,471 0 0 0 0 0 15,000 15,000 Quiet Zones - Railroad Maint Costs 20,808 25,523 36,202 30,000 40,000 2,175 0 0 0 0 33,091 42,960 49,153 45,000 60,000 Increased Street Overlays 4,649 8,362 2,109 10,000 7,500 133,000 7,843 9,436 3,508 8,000 8,000 125,268 123,457 124,381 125,000 125,000 31,500 13,060 9,512 9,869 12,000 12,000 9,241 8,814 4,775 9,500 9,500 Full Year After 2009 2,888 5,778 0 0 0 0 0 9,340 10,000 10,000 23,863 13,251 24,531 35,000 30,000 Bucket Truck / OSHA 0 0 0 0 0 700 484 633 652 600 600 Annual Membership 0 0 0 0 0 28 0 20 0 0 0 0 80 0 0 0 0 0 0 0 0 0 0 0 0 0 70 70 100 100 0 0 0 0 0 0 0 0 0 0 0 0 0 140 0 0 2,400 549 215 59 500 1,000 Spring / Fall Conferences 0 99 0 500 0 0 0 80 200 150 MuniciPals (Twice Annually) 0 0 210 200 0 0 24 50 350 300 0 0 250 600 450 0 90 0 650 0 440 0 160 0 0 1,014 3,557 436 2,000 500 738 211 216 1,000 500 Host CONDAC $500 0 0 0 0 0 $272,528 $301,095 $292,758 $346,700 $354,600 $1,135,070 $1,198,413 $1,231,784 $1,331,300 $1,342,400 Estimated Road Salt Cost for 2011 Sak $60tton x 500 tons $30,000 Treated Sale $74.00tton x 500 tons 37,000 Total for Road SaR $67,000 Estimated De -Icing Gravel Cost for 2011 Gravel $12/ton x 150 tons $1,800 Treated Gravel $25/ton x 0 tons 0 Total for Road Safi $1,800 Page One 2011 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE May 28, 2010 Account # Description 101 45202 101.00 Salaries & Benefits 101 45202 77 101.00 Administrative 101 45202 7S 101.00 Maintenance 101 45202 102.00 Full -Time Overtime 101 45202 9S 103.00 Part-Time Salaries & Benefits 101 45202 01 205.00 Drafting Supplies 101 45202 01 216.00 Chemical & Chemical Products 101 45202 01 216.01 Herbicides(General Park Use) 101 45202 01 216.02 Fertilizer 101 45202 01 219.00 Other Operating Supplies 101 45202 01 219.01 Seed, Sod, etc. 101 45202 01 219.02 Red Rock, Sand, Gravel, etc. 101 45202 01 219.03 Repair Supplies 101 45202 01 219.04 Bituminous 101 45202 01 219.05 Wood Chips 101 45202 01 221.00 Equipment Parts 101 45202 01 221.01 Playground Equipment Repair 101 45202 01 221.02 Irrigation Repair(Non- Contract) 101 45202 01 221.03 Miscellaneous 101 45202 01 221.04 Park Sign Replacements 101 45202 01 223.00 Building Repair Supplies 101 45202 01 223.01 Paint, Stain, etc. 101 45202 01 223.02 Shingles, Boards, etc. 101 45202 01 223.03 Miscellaneous 101 45202 01 223.04 Shelter /Shed Repairs 101 45202 01 225.00 Landscaping Materials 101 45202 01 225.01 Trees, Shrubs, Sod, etc. 101 45202 01 225.02 Timbers, Fence, etc. 101 45202 01 226.00 Sign Repair Materials 101 45202 01 229.00 Other Maintenance Supplies 101 45202 01 241.00 Small Tools 101 45202 01 242.00 Minor Equipment 101 45202 01 303.00 Engineering Fees 101 45202 01 305.00 Medical and Dental Fees 101 45202 01 318.00 Contract Engineer 101 45202 01 321.00 Telephone Costs 101 45202 01 323.00 Radio Units 101 45202 01 341.00 Employment Advertising 101 45202 01 381.00 Electric Utilities 101 45202 01 381.01 Skating Rinks 101 45202 01 381.02 Softball Fields 101 45202 01 381.03 Irrigation 101 45202 01 383.00 Gas Utilities 101 45202 01 393.00 P.C. Hardware Purchases 101 45202 01 394.00 P.C. Software Purchases 101 45202 01 403.00 Contracted Repair & Maintenance 101 45202 01 403.01 Irrigation Repairs 101 45202 01 403.02 Electrical Repairs 101 45202 01403.03 Miscellaneous Repairs 101 45202 01409.00 Other Contracted Repair & Maint 101 45202 01 409.01 Chemlawn Services 101 45202 01 409.02 Library / St. Joe's / RCC 101 45202 01 409.03 Fire Station #1 101 45202 01 409.04 Fire Station #2 101 45202 01 409.05 City Hall / Central Park 101 45202 01 416.00 Machinery Rental 101 45202 01 416.01 Mower Leases 101 45202 01 416.02 Miscellaneous Rentals 101 45202 01433.00 Dues & Subscriptions 101 45202 01 433.01 MN Park Supervisors Ass'n 101 45202 01 433.02 Miscellaneous Dues 101 45202 01 435.00 Books & Pamphlets 101 45202 01 437.00 Conferences & Seminars 101 45202 01 437.01 Seminars & Workshops 101 45202 01 437.02 School & Tuition 101 45202 01 437.03 CarteGraph / ESRI 101 45202 01 439.00 Other Miscellaneous Charges 101 45202 01 530.00 Improvements Other Than Bldgs PAGE TOTALS DEPARTMENT TOTALS 01�-j 2010 2011Objecl 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $431,600 Salary, Taxes, PERA & Benefits 10,506 10,954 11,274 11,600 11,900 366,723 381,555 396,110 406,400 419,700 11,384 14,556 14,214 14,000 14,000 15,478 35,190 42,088 49,500 49,500 0 0 0 100 100 17,000 Includes all City Facilities 6,081 8,651 2,954 12,000 6,000 18,304 21,579 21,785 22,000 11,000 15,500 3,426 2,952 4,917 3,000 3,000 3,472 1,085 2,409 3,500 2,500 334 512 0 1,000 1,000 0 0 0 0 0 0 6,760 8,484 9,000 9,000 Special Wood Chips - Playgrounds 14,500 7,791 4,509 4,886 4,500 4,500 5,735 7,450 7,418 7,500 7,500 3,289 108 3,434 2,500 2,500 0 648 0 0 0 10,000 981 1,696 2,950 1,500 1,500 1,012 1,915 1,515 2,000 2,000 1,503 1,706 755 1,500 1,500 5,219 29,580 3,168 5,000 5,000 3,500 4,536 2,218 740 3,500 2,500 629 684 227 3,500 1,000 492 0 0 500 500 3,731 5,288 5,701 7,000 7,000 Paint, Chalk, Field Dry (& DCTC) 2,377 1,539 2,572 2,500 2,500 Hand Tools, Blades, Bits, etc. 1,053 2,627 2,406 2,500 2,500 Weed Whips, Chain Saws - Powered 0 0 0 0 0 0 0 0 600 600 Employment Physicals 750 1,500 1,500 1,500 1,500 Contracted Engineer for City (5 %) 2,988 2,905 3,460 3,100 3,100 Includes Wireless Technology 0 0 603 1,300 1,300 800 MHZ Monthly Charges 0 11 0 0 0 19,000 5,831 6,697 5,975 6,000 6,000 5,937 7,030 7,542 9,000 8,000 3,190 3,402 3,982 5,000 5,000 2,574 2,509 2,133 2,800 2,800 0 0 0 6,000 500 Laptop, Truck Mounts 0 0 4,609 6,000 5,500 CarteGraph / GIS Maintenance 22,000 913 2,985 3,686 5,000 13,000 RPZ- Inspect & Replace(& Blowout) 7,362 3,951 3,299 6,000 6,000 6,013 36 601 3,000 3,000 4,222 3,806 5,537 16,500 0 0 0 4,000 2,000 0 0 0 6,000 6,000 Mowing and Chemical Application 0 0 0 0 2,500 Mowing and Chemical Application 0 0 0 0 2,000 Mowing and Chemical Application 0 0 0 0 4,000 Mowing and Chemical Application 20,500 18,395 14,584 15,685 19,000 19,000 Exmark, 2 John Deere 1,851 1,425 1,689 1,500 1,500 100 0 0 0 50 50 35 70 80 150 50 0 0 0 100 0 3,300 726 616 967 1,500 1,500 Green Expo, MPSA, Playgrounds 475 1,285 1,219 1,000 1,300 Turf School, Power Limited Tech. 0 0 0 0 500 0 0 0 200 200 Contingencies 124,572 50,000 65,000 65,000 Annual Total Expenditures $535,318 $721,147 $652,572 $729,900 $730,100 $535,318 - ----- -- ------- $721,147 -- -- - - -- ---- - - -- $652,572 -- - --- -- - - -- - -- $729,900 - - - - - - -- - - - -- --- - ---- - -- ---- - --- $730,100 -- - - - - -- -- - - - - -- cl�� PARKS AND RECREATION The Parks and Recreation Department works together with citizens to provide a safe, healthy and pleasant community. Parks and recreation are essential services that can impact health, crime prevention, the environment, the economy and the quality of life for Rosemount residents. ADMINISTRATION • Provides for overall planning, coordination, management of personnel and administration of activities within the department of Parks and Recreation. This department provides a diversified range of activities and facilities for the residents of Rosemount. The long range planning, budget preparation and development of parks and coordination with other service agencies are ongoing activities. Administrative services also provide the residents of Rosemount an opportunity to reserve facilities and register for programs. RECREATION • Provides the Rosemount resident a variety of recreational activities serving all ages. Program offerings are based on the needs of residents as determined and evaluated by the Parks and Recreation Commission and staff. Coordination with other service agencies encourages a comprehensive, quality and efficient base of programs. COMMUNITY CENTER • Provides for operation of a multi- purpose Community Center, which offers facilities for recreational programs, banquets, meetings, events, theatrical productions, seminars and exercise. The Community Center provides services in the form of meeting space, gym space for community groups and sponsorship of community events. The Parks and Recreation Department provides ongoing, preventive maintenance and janitorial services of the Community Center and portions of the National Guard facilities. S PARKS & RECREATION DEPARTMENT — Page 2 PERFORMANCE MEASURES Hours of Use at Community Center 2005 2006 2007 2008 2009 n/a 20,060 191149 22,761 18,151 Total Community Center Rental Income and % Change from Prior Fiscal Year 2005 2006 2007 2008 2009 Income n/a $109,944 $118,094 $122,315 $111,186 % Change n/a n/a +7.0% +3.5% -9.0% Number of Acres in the Park System and % Change from Prior Fiscal Year 2005 2006 2007 2008 2009 Income n/a 430.84 430.84 430.52 440.24 % Change n/a +15.35% +0.0% -0.07% +2.4% 2009 — Added DCTC Soccer Fields Percentage of Costs Received for All Recreation Programs n/a — Information Not Available 2005 2006 2007 2008 2009 Revenues n/a $136,866 $154,229 $151,378 $124,554 Expenses n/a $122,826 $133,556 $128,292 $107,625 Net n/a $14,040 $20,673 $23,086 $16,929 % Change n/a +10.26% +13.40% +15.25% +13.59% n/a — Information Not Available One 2011 BUDGET WORKSHEETS PARKS & RECREATION May 28, 2010 Account # Description 2007 Actual 2008 Actual 2009 Actual 2010 Adopted Budget 2011Objecl Detail Amount 2011 Proposed Budget Comments All Salary Costs Inclusive of 101 45100 101.00 Salaries & Benefits $644,547 $664,811 $650,239 $665,700 $692,200 Salary, Taxes, PERA & Benefits 101 45100 102.00 Full -Time Overtime 12,871 9,443 6,844 11,000 5,000 101 45100 103.00 Part-Time Salaries & Benefits 125,700 101 45100 10 103.00 PIT Receptionist 20,723 30,760 33,014 34,500 35,200 101 45100 12 103.00 Building Attendants 47,070 56,912 62,401 50,000 50,000 101 45100 83 103.00 Playground Recreation Leaders 22,902 24,155 20,757 23,000 21,000 101 45100 94 103.00 Warming House Attendants 10,511 16,453 16,400 15,000 17,000 101 45100 99 103.00 Park & Rec Committee 1,595 1,560 1,559 2,500 2,500 101 45100 71 103.00 PIT Horticulturist 4,985 3,449 7,480 6,500 0 Moved to Pubic Works Budget 101 45100 01 203.00 Printed Forms & Paper 46 43 0 0 0 101 45100 01 205.00 Drafting Supplies 706 237 149 800 500 Laminating 101 45100 01 207.00 Training & Instructional Supplies 0 0 0 100 100 Books, Tapes, etc. 101 45100 01 208.00 Miscellaneous Supplies 100 69 70 200 100 Meeting Supplies 101 45100 01 209.00 Other Office Supplies 282 70 455 1,200 500 Envektpes, Forms, Rulers, etc. 101 45100 01 211.00 Cleaning Supplies 5,171 4,406 4,080 6,000 6,000 101 45100 01 216.00 Chemicals & Chemical Products 1,408 789 652 1,500 1,000 101 45100 01 219.00 Other Operating Supplies 5,709 5,604 6,816 6,000 6,000 Rec Programs, 1 st Aid Sup, etc. 101 4510001 221.00 Equipment Parts 8,932 7,854 8,586 8,500 8,500 101 45100 01 223.00 Building Repair Supplies 3,555 3,654 1,063 4,500 3,500 101 45100 01 229.00 Other Maintenance Supplies 0 44 0 0 0 101 45100 01 303.00 Engineering Fees 0 0 0 0 0 101 45100 01 305.00 Medical & Dental Fees 50 0 0 0 0 Employment Physicals 101 45100 01 312.00 Custodial Services 9,074 8,307 7,042 9,000 9,000 Custodial Services- Banquet Rm 101 45100 01 315.00 Special Programs 14,700 101 45100 01 315.01 Sunday Night Specials 3,139 3,002 5,096 6,000 5,500 Performances (Add Movies) 101 45100 01 315.02 Leprechaun Days 200 212 242 400 250 Trophies & Awards 101 45100 01 315.03 Halloween 16 129 0 0 0 101 45100 01 315.04 Ground Pounders(Running) 53 54 127 300 200 Ribbons & Mailings 101 45100 01 315.05 Nature Programs(Arbor Day, etc.) 2,619 3,257 3,622 3,900 4,700 Trees (Add 30 Trees for 2011) 101 45100 01 315.06 Puppet Programs 0 230 11 300 150 Tapes, Fuses, Puppets, etc. 101 45100 01 315.07 Special Events 197 1,751 56 1,000 1,000 Publicity & Supplies 101 45100 01 315.08 Adopt -A -Park Program 1,357 932 81 1,000 500 Flyers, Signs 101 45100 01 315.09 Miscellaneous Programs 2,009 557 0 2,000 2,000 Start Up Costs 101 45100 01 315.10 ADA Programs 0 0 20 400 400 ADA Program Supplies 101 45100 01 319.00 Other Professional Services 393 2,723 2,773 2,500 2,500 ADA Services ng.LA Sery Test 101 45100 01 321.00 Telephone Costs 2,351 2,973 3,024 3,100 3,100 Pagers & Cellular Phones 101 45100 01 331.00 Travel Expense 196 380 338 500 500 101 45100 01 341.00 Employment Advertising 675 696 0 700 700 General Employment Ads 101 45100 01 349.00 Other Advertising 33,900 101 45100 01 349.01 Brochures 36,019 36,688 36,914 36,000 28,000 City Newsletter(Cut to 3 Per Year) 101 45100 01 349.02 Yellow Pages 5,080 4,893 2,148 3,400 2,000 Rec Ads 101 45100 01 349.03 Special Marketing 2,250 4,799 3,871 3,900 3,900 Garage Sale Ad 101 45100 01 381.00 Electric Utilities 27,291 27,864 26,990 30,000 30,000 101 45100 01 383.00 Gas Utilities 34,232 37,862 31,542 42,000 35,000 101 45100 01 384.00 Refuse Disposal 3,720 4,363 3,887 4,000 4,000 101 45100 01 392.00 P.C. Accessories & Supplies 0 0 0 0 0 101 45100 01 393.00 P.C. Hardware Purchases 0 1,764 0 2,000 0 101 45100 01 394.00 P.C. Software Purchases 0 13,000 3,742 5,000 2,500 On -Line Registration S/W Support 101 45100 01 401.00 Contracted Building Repairs 12,066 6,408 7,472 10,000 10,000 101 4510001 404.00 Contracted Mach & Equip Repairs 8,793 1,571 3,840 8,000 8,000 101 45100 01 409.00 Other Contracted Repair & Maint 22,736 19,594 23,507 23,000 23,000 Air Handler Maintenance Contract 101 45100 01 412.00 Building Rental 16,800 16,800 16,800 16,800 16,800 Monthly Rent Payments to Guard 101 45100 01 415.00 Other Equipment Rental 12,367 13,054 15,327 17,000 19,000 Portable Toilets & Other(New Pks) 101 45100 01 433.00 Dues & Subscriptions 4,800 101 45100 01 433.01 MRPA Dues 1,259 1,259 1,426 2,100 1,700 Minn Recreation & Parks Ass'n 101 45100 01 433.02 Miscellaneous 867 583 1,002 400 400 Paper, Magazines, etc. 101 45100 01 433.03 On -Line Registrafn Subscription 0 1,332 181 1,200 2,700 101 45100 01 435.00 Books & Pamphlets 0 0 0 100 100 101 45100 01 437.00 Conferences & Seminars 2,800 101 45100 01 437.01 MRPA State Conference 1,677 2,494 1,260 2,000 1,300 101 45100 01 437.02 MIAMA State Conference 0 190 0 300 0 101 45100 01 437.03 Workshops, Schools, & Tuition 469 972 1,521 2,200 1,500 101 45100 01 439.00 Other Miscellaneous Charges 19,991 7,586 21,722 0 0 Donation Account 101 45100 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 PAGE TOTALS $1,019,058 $1,058,589 $1,046,152 $1,077,500 $1,069,500 General Operating DEPARTMENT TOTALS $1,019,058 $1,058,589 $1,046,152 $1,077,500 $1,069,500 Page Two 2011 BUDGET WORKSHEETS PARKS & RECREATION May 28, 2010 Account # Description 101 38201.00 Other Revenue -Misc Events 101 38203.00 Church Rentals 101 38205.00 Miscellaneous Rentels 101 38207.00 Other Rentals/Events 101 38209.00 Advertising Revenue 10138211.00 Concessions 101 38215.00 Vending Machine Revenues 1,500 Events Supplies TOTALREVENUES 101 45100 30 103.00 Salaries & Benefits 101 45100 30 103.00 Budding Attendants 101 45100 30 211.00 Cleaning Supplies 101 45100 30 219.00 Other Operating Supplies 101 45100 30 221.00 Equipment Parts 101 45100 30 223.00 Building Repair Supplies 101 45100 30 241.00 Small Tools 101 45100 30 242.00 Minor Equipment 101 45100 30 321.00 Telephone Costs 101 45100 30 349.00 Other Advertising 101 45100 30 365.00 Workers' Comp Insurance 101 45100 30 369.00 Other Insurance 101 45100 30 381.00 Electric Utilities 101 45100 30 383.00 Gas Utilities 101 45100 30 384.00 Refuse Disposal 101 45100 30 401.00 Contracted Building Repairs 101 45100 30 404.00 Contracted Mach & Equip Repairs 101 45100 30 415.00 Other Equipment Rental 101 45100 30 439.00 Other Miscellaneous Charges 101 45100 30 521.00 Building & Structure Purchases 101 45100 30 580.00 Other Equipment Purchases PAGEIEXPENDITURE TOTALS 2010 2011Objecl 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget AAAA Steeple Center Revenues AAA $0 $0 $0 $2,000 $2,000 0 0 0 7,500 7,500 0 0 0 2,000 2,000 0 0 0 0 0 0 0 0 1,000 1,000 0 0 0 1,000 1,000 0 0 0 0 0 $0 $0 $0 $13,500 $13,500 AAAA Steeple Center Expenditures AAA S� Comments $8,000 Salary, Taxes, PERA & Benefits 0 0 0 8,000 8,000 0 0 0 1,500 1,500 0 0 0 1,500 1,500 Events Supplies 0 0 0 1,500 1,500 0 0 0 5,000 5,000 0 0 0 1,000 1,000 0 0 0 1,000 1,000 0 0 0 1,200 1,200 0 0 0 1,500 1,500 0 0 0 500 500 0 0 0 2,000 2,000 0 0 0 15,200 15,200 0 0 0 31,000 31,000 0 0 0 1,900 1,900 0 0 0 10,000 10,000 0 0 0 4,200 4,200 0 0 0 500 500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $0 $0 $0 $87,500 $87,500 Page Three cl��) 2011 BUDGET WORKSHEETS PARKS & RECREATION May 28, 2010 Account # Description 2007 Actual 2008 Actual 2009 Actual 2010 Adopted Budget 2011 Objecl Detail Amount 2011 Proposed Budget Comments $102,400 101 45100 80 Art Classes $0 $0 $0 $0 $1,000 101 45100 81 Softball 43,973 49,985 44,648 45,000 45,000 101 45100 82 Volleyball 85 0 0 0 0 1014510084 Tennis 1,727 1,893 1,744 2,000 2,000 101 45100 85 Tiny Tots 22,769 18,543 10,751 21,500 0 Eliminated Program 101 45100 86 Rosettes 1,281 1,111 1,378 1,200 1,200 101 45100 87 Trips 7,327 7,013 5,642 8,300 4,500 101 45100 88 Broombali 0 0 0 0 0 101 45100 90 Run for the Gold 3,966 3,027 4,241 4,000 4,000 1014510091 Camps 11,917 10,846 16,710 12,000 12,000 101 45100 92 Adult Basketball 501 859 0 600 600 101 45100 93 Other Programs 14,348 11,218 9,987 14,500 14,500 101 45100 95 T -Ball 6,587 5,286 4,371 7,000 5,000 101 45100 96 Teen Night 5,322 5,478 5,279 5,000 0 Eliminated Program 101 45100 97 Adult Soccer League 11,071 9,627 0 0 10,000 No League in 2009 101 45100 98 Youth Soccer Lessons 2,682 3,406 2,875 2,600 2,600 133,556 128,294 107,625 123,700 102,400 AAAA Detail for Above AAA 101 45100 80 219.00 Operating Supplies 0 0 0 0 1,000 101 45100 81 103.00 Part-Time Salaries 6,568 7,332 7,797 7,000 7,000 101 45100 81 219.00 Operating Supplies 7,521 10,037 9,011 8,000 8,000 101 45100 81 311.00 Officiating Fees 26,266 27,470 11,788 27,000 27,000 101 45100 81 319.00 Other Professional Services 3,617 5,146 16,052 3,000 3,000 101 45100 82 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 82 219.00 Operating Supplies 85 0 0 0 0 101 45100 82 311.00 Officiating Fees 0 0 0 0 0 101 45100 82 319.00 Other Professional Services 0 0 0 0 0 101 45100 84 103.00 Part-Time Salaries 1,223 1,604 1,475 1,500 1,500 101 45100 84 219.00 Operating Supplies 504 290 269 500 500 101 45100 85 103.00 Part-Time Salaries 21,617 17,685 10,097 20,000 0 101 45100 85 219.00 Operating Supplies 1,152 857 654 1,500 0 101 45100 86 103.00 Part-Time Salaries 346 490 575 400 400 101 45100 86 219.00 Operating Supplies 935 621 803 800 800 101 45100 87 103.00 Part-Time Salaries 799 638 73 1,000 500 101 45100 87 219.00 Operating Supplies 4,000 101 45100 87 219.01 Youth/Teen Trips Supplies 4,369 4,561 920 4,300 0 1014510087 219.02 Adult/Senior Trips Supplies 2,159 1,815 4,649 3,000 4,000 101 45100 88 219.00 Operating Supplies 0 0 0 0 0 101 45100 88 311.00 Officiating Fees 0 0 0 0 0 101 45100 90 219.00 Operating Supplies 3,966 3,027 4,241 4,000 4,000 101 45100 91 103.00 Part-Time Salaries 4,319 3,297 7,636 5,000 5,000 101 45100 91 219.00 Operating Supplies 7,598 7,549 9,074 7,000 7,000 101 45100 92 219.00 Operating Supplies 501 859 0 600 600 101 45100 93 103.00 Part-Time Salaries 3,093 3,069 2,469 3,000 3,000 1014510093 219.00 Operating Supplies 10,265 7,859 7,318 11,500 11,500 101 45100 93 319.00 Other Professional Services 990 290 200 0 0 101 45100 95 103.00 Part-Time Salaries 4,585 3,435 2,810 5,500 3,500 1014510095 219.00 Operating Supplies 2,002 1,850 1,561 1,500 1,500 101 45100 96 103.00 Part-Time Salaries 1,684 1,262 1,011 0 0 10145100 96 219.00 Operating Supplies 3,638 4,216 4,268 5,000 0 101 45100 97 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 97 219.00 Operating Supplies 821 717 0 0 1,000 101 45100 97 311.00 Officiating Fees 10,250 8,910 0 0 9,000 1014510098 103.00 Part-Time Salaries 1,571 1,989 1,765 1,000 1,000 1014510098 219.00 Operating Supplies 1,112 1,418 1,110 1,600 1,600 SPECIAL PROGRAM TOTALS 133,556 128,294 107,625 123,700 102,400 GRAND TOTAL - PARK & REC $1,152,615 --- - - - - -- --------- $1,186,883 --- - - - - -- - -------- $1,153,777 --- - - - - -- --- - - - - -- $1,288,700 --- - - - - -- --- - - - - -- - - - - -- -- ------ $1,259,400 -- - ---- -- -- - - - ---- D-) OTHER FINANCING USES - TRANSFERS This is a transfer set up beginning in 2007 for the assistance from the General Fund to the Arena Fund for the operations of the arena. Page One 2011 BUDGET WORKSHEETS OTHER FINANCING USES May 28, 2010 Account # Description 101-49300-01710.00 Transfers FUND TOTALS ( D5-Y 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $100,000 $165,000 $115,000 $115,000 $115,000 Arena Operations Assistance $100,000 $165,000 $115,000 $115,000 $115,000 -- - - - - -- -- - - - - -- -- - - - - -- -- --- - -- -- - - - - -- -- ---- -- -------- -- - - - - -- -- - - - - -- -- - - - - -- -- - - - - -- -- - - - - -- 0(11� INSURANCE GENERAL / ADMINISTRATIVE • Provides for the funding of the City's Worker's Compensation Insurance and General Liability Insurance. Currently, both insurances are provided through the League of Minnesota Cities Insurance Trust This agency allows the City to have thorough, yet affordable insurance. • In 1995, we set up a separate Internal Service Fund for insurance purposes. The amount levied was, and will be, the same as it would have been if the Insurance budget had been in the General Fund, as it has been in the past. But, this allows us to build a special fund for insurance purposes that will allow the City to move towards self - insurance, and ultimately, lower rates. We do not anticipate ever being totally self - insured, but by raising our deductibles we approach that point and allow ourselves to save substantially on our annual insurance premiums. Doing so will allow the City to operate more efficiently and save the taxpayers money without taking undue risks. Page One 2011 BUDGET WORKSHEETS INSURANCE - REVENUES i (�3 May 28, 2010 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 206 31010.00 Current Ad Valorem Taxes $260,000 $275,000 $275,000 $275,000 $275,000 206 33100.00 Federal Grants & Aids 0 0 0 0 0 206 36210.00 Interest Earnings - Investments 29,968 24,345 14,596 26,000 15,000 206 36214.00 Net Change in FV- Investments 562 (375) 596 0 0 Annual Market Value Changes 206 36215.00 Interest Earnings 161 409 654 500 800 206 36260.00 Other Revenue 26,743 19,713 38,312 20,000 24,000 Insurance Refunds/Dividends FUND TOTALS 317,433 319,091 329,159 321,500 314,800 INSURANCE- EXPENDITURES 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 206 49006 01 221.00 Equipment Parts $2,653 $0 $5,069 $2,500 $2,500 Liability & Auto Deductible Pymts 206 49006 01 304.00 Legal Fees 0 0 500 500 500 Unreimbursable Legal Fees 206 49006 01 305.00 Medical & Dental Fees 7,260 5,051 5,071 7,000 6,000 Work Comp Deductible Pymts 206 49006 01 317.00 General Fund Administrative Fees 2,500 2,500 2,500 2,500 2,500 Yearly Fee Per Policy F -3 206 49006 01 319.00 Other Professional Services 18,240 18,300 Risk Management Consultant 206 49006 01 319.01 Risk Management Consultant 10,100 6,000 10,500 6,000 206 49006 01 319.02 CHESS Consultant 8,200 12,300 13,500 12,300 206 49006 01 365.00 Worker's Compensation Insurance 76,437 88,429 95,224 92,000 100,000 Annual Premium 206 49006 01 369.00 Other Insurance- 178,524 165,746 165,849 183,000 175,000 Annual Premium - General Liability 206 49006 01 409.00 Other Contracted Repair & Maint 17,747 10, 120 8,728 10,000 10,000 Liability & Auto Deductible Pymts 206 49006 01 439.00 Other Miscellaneous Charges 97 0 1,000 0 0 FUND TOTALS 303,458 - - -- - - -- -------- 290,145 ------------ ------------ 302,242 - - - - -- - -- - -- 321,500 -- -- - - -- -- - - -- -- -- - - - - -- -- - - - - -- 314,800 -- - - - - -- -- - - - - -- NOTE: Levy of $275,000 covers costs for all insurance premiums. All other expenditures covered through interest earnings and insurance refunds/dividends. �&D PORT AUTHORITY GENERAL / ADMINISTRATIVE The Rosemount Port Authority is the successor to the Rosemount Housing and Redevelopment Authority (HRA) and the Rosemount Economic Development Authority (EDA). As such, the Port Authority is responsible for both redevelopment and economic development activities in the City. • The Port Authority concentrates much of its activity on the development of the Rosemount Business Park and on the redevelopment of downtown Rosemount. • The Port Authority will continue to work on other development and redevelopment projects related to commercial and industrial development. Page One 2011 BUDGET WORKSHEETS PORT AUTHORITY - REVENUES May 4, 2010 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 201 31010.00 Current Ad Valorem Taxes $0 $50,000 $50,000 $50,000 $48,600 Operating Levy 201 31050.00 Tax Increments 0 0 0 0 0 Admin Fees Portion Only 201 33130.00 Federal Grants -CDBG 0 0 0 0 0 201 33425.00 Other State Grants & Aids 0 0 4,474 0 0 LCDA Downtown Grant 201 34109.00 Other Charges for Services 11,256 13,319 605 1,000 200 Genz -Ryan Tenant Utility Pymts 201 36105.00 Principal on Notes 499,021 0 0 0 0 Blake L/T Lease - Sold in 2007 201 36210.00 Interest Earnings - Investments 5,254 632 824 2,000 500 Interest Earned on CD's 201 36212.00 Interest Earnings - Blake 3,072 0 0 0 0 Blake LIT Lease - Sold in 2007 201 38215.00 Interest Earnings 418 204 265 200 200 Checking Interest & Misc 20136230.00 Contributions/Donations 0 0 0 0 0 201 36260.00 Other Revenue 0 421 0 0 0 201 36265.00 Use of Reserve Funds 0 0 0 0 0 201 39101.00 Sales of General Fixed Assets 0 0 0 0 0 FUND TOTALS $519,021 - -- - - - - -- --------- $64,576 --- - - ---- --- - - - - -- $56,168 ---- - -- -- --- - - - - -- $53,200 - -- - - - - -- - -- -- - --- - -- - -- - -- --- - - - - -- $49,500 -- - - - - - -- -- - --- --- EXPENDITURES 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 201 46300 99 103.00 Part-Time Salaries & Benefits $5,393 $3,870 $2,468 $5,000 $5,000 Salary, Taxes, PERA & Benefits Port Authority Members 201 46300 01 303.00 Engineering Fees 0 0 1,900 4,000 4,000 201 46300 01 304.00 Legal Fees 6,254 1,596 565 4,000 3,000 201 46300 01 317.00 General Fund Administrative Fees 6,400 6,000 6,000 6,000 6,000 Yearly Fee Per Policy F -3 201 46300 01 319.00 Other Professional Services 3,000 201 46300 01 319.01 Project Management Consultant 3,750 3,150 0 2,000 2,000 201 46300 01 319.02 Marketing 70 0 416 0 0 Moved to "349.00" Below 201 46300 01 319.03 County TIF Charges 7,066 7,996 10,112 0 0 201 46300 01 319.04 P/A Property Tax Payments 2,170 10,546 0 1,000 1,000 201 46300 01 319.07 Central Park Survey Work 0 7,307 1,603 0 0 201 46300 01 322.00 Postage Costs 85 117 241 1,000 800 201 46300 01 349.00 Other Advertising 163 2,050 4,644 14,000 10,000 Additional Marketing 201 46300 01 359.00 Other Printing & Binding Costs 0 491 365 3,000 3,100 201 46300 01 365.00 Workers Comp Insurance 429 456 488 500 500 Commissioners 201 46300 01 369.00 Other Insurance 4,323 4,385 5,154 2,800 5,400 Property Insurance 201 46300 01 381.00 Electric Utilities 7,229 4,420 479 1,000 500 Business Park & Other Properties 201 46300 01 383.00 Gas Utilities 8,314 9,814 1,279 700 500 Other Properties 201 46300 01 389.00 Other Utility Services 1,789 1,871 239 1,000 500 Utility Fees 201 46300 01 403.00 Contracted Repairs & Maintenance 964 0 0 0 0 201 46300 01 433.00 Dues & Subscriptions 1,700 Prof Organizations/Joumals 201 46300 01 433.01 Professional Organizations/Joum< 1,360 1,195 1,674 1,700 1,700 201 46300 01 433.02 Foreign Trade Zone Commission 15,000 0 0 0 0 201 46300 01 437.00 Conferences & Seminars 7,106 4,697 2,731 5,000 5,000 DevelopmentMF/Miscellaneous 201 46300 01 439.00 Other Miscellaneous Charges 139 89 200 500 500 Contingencies 201 46300 01 521.00 Building & Structure Purchases 0 0 0 0 0 201 48300 01 525.00 Building & Structure Purchases 558,910 0 0 0 0 201 46300 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 Special Downtown Projects 201 46300 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $636,913 --- - - - - -- --------- $70,049 --- - - - - -- -- - - -- - -- $40,559 --- - - - - -- --- - - -- -- $53,200 --- -- - - -- -- - --- - -- -- --- ---- --- - - - - -- $49,500 -- --- -- -- --- - - ---- Page One May 4, 2010 Account # 242 31010.00 242 31050.00 242 33400.00 242 33425.00 242 33620.00 242 36210.00 242 36215.00 242 36220.00 242 36260.00 242 39310.00 (b D(� - 2011 BUDGET WORKSHEETS DOWNTOWN /BROCKWAY DISTRICT(0108) - REVENUES EXPENDITURES 2010 2011 Objecl 2011 2007 2008 2009 Adopted Detail Proposed Description Actual Actual Actual Budget Amount Budget Comments Current Ad Valorem Taxes $0 $0 $21,420 $0 $0 MVHC Payments Tax Increments 134,224 296,735 357,931 300,000 350,000 State Grants & Aids 0 422,179 242,085 0 0 Other State Grants & Aids 0 0 12,551 0 0 Other County Grants & Aids 0 100,000 0 0 0 Interest Earnings - Investments 803 427 37 0 0 Interest Earnings 258 99 294 0 0 Rents & Royalties 65,041 30,252 875 0 0 Other Revenue 10,000 9,500 0 0 0 Bond Proceeds 0 6,040,000 0 0 0 FUND TOTALS $210,326 $6,899,192 $635,193 $300,000 $350,000 EXPENDITURES 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 242 49042 01 303.00 Engineering Fees $0 $201,758 $42,777 $0 $0 242 49042 01 304.00 Legal Fees 0 434 128 0 0 242 49042 01 319.00 Other Professional Services 89,898 177,259 18,129 0 15,000 County TIF Charges 242 49042 01 522.00 Building & Structure Purchases 356,987 900,945 57,700 0 0 242 49042 01 530.00 Improvements Other Than Buildings 35,139 1,944,456 160,445 0 0 242 49042 01 611.00 Interest on Internal Loan 127,656 $4,825 0 0 0 242 49042 01 710.00 Transfers 0 86,000 420,000 300,000 335,000 P & I for 2008A & 2008B Issues FUND TOTALS $609,681 $3,345,677 $699,178 $300,000 $350,000 ICE ARENA ADMINISTRATION ob�-- The Parks and Recreation Department administer the Ice Arena. Scheduling and invoicing of ice are the main administrative duties of ice arena operations. The scheduling of prime time ice is coordinated with Independent School District #196 and Rosemount Area Hockey Association for practices, games and tournament play. The Parks and Recreation Department provides overall planning, coordination, management of personnel and administration of ice arena activities. COMMUNITY USE • Provides recreational open skating for the residents of Rosemount as well as learning to skate and figure skating programs. MAINTENANCE • Provides ongoing and preventative maintenance of the ice arena building structure and its mechanical components. Ensures ice is maintained at optimal efficiency. PERFORMANCE MEASURES Number of Ice Arena Hours Utilized 2005 2006 2007 2008 2009 n/a 2,353 2,456 2,544 2,466 n/a — Information Not Available Page One May 28, 2010 Account # 650 36210.00 650 36215.00 650 36230.00 650 36260.00 650 36265.00 650 38060.00 650 38061.00 650 38063.00 650 38064.00 650 38065.00 650 38066.00 650 38067.00 650 38090.00 650 38091.00 650 38095.00 650 39103.00 650 39201.00 ow 2011 BUDGET WORKSHEETS ARENA - REVENUES 2010 2011 Object 2011 2007 2008 2009 Adopted Detail Proposed Description Actual Actual Actual Budget Amount Budget Comments Interest Earnings - Investments $0 $0 $0 $0 $0 Interest Earnings 0 47 320 100 100 Contributions/Donations 0 0 597 0 0 Other Revenue - Learn to Skate 32,075 44,774 31,648 35,000 34,000 Learn to Skate Program (LTS) Use of Reserve Funds 0 0 0 0 0 Prime Time Ice Fees 216,710 221,861 236,606 220,000 230,000 Non -Prime Time Ice Fees 76,677 81,056 74,964 75,000 75,000 Open Skating Ice Fees 9,864 8,917 6,163 9,000 6,000 Broomball Revenues 5,761 8,220 0 0 0 Moved to Prime/Non -Prime Times Other Events - Arena 0 0 0 0 0 Dry Floor Events Advertising Revenue - Arena 13,500 7,700 6,220 10,000 10,000 Skate Sharpening Revenue - Arena 5,472 4,672 3,844 5,500 4,000 Concessions 3,900 3,900 3,900 3,900 3,900 Vending Machine Revenues 8,367 8,472 6,653 10,000 8,000 Pro Shop Revenues 1,178 1,058 965 1,200 1,200 Tape, Laces, Mouthguards, etc. Gain or Loss from F/A Disposal 0 0 0 0 0 Transfer From General Fund 100,000 165,000 115,000 115,000 115,000 Subsidy for Operations FUND TOTALS -- -------- 473,504 - - - - -- 555,678 -- ---------- ------------ 486,881 - -- - -- - -- --- 484,700 -- - - - - -- -- - - - - -- -- - - - - -- -- - -- - -- 487,200 -- - - - - -- -- - - ---- � t} �2 b Page One 2011 BUDGET WORKSHEETS ARENA - EXPENDITURES May 28, 2010 Account # Description 2007 Actual 2008 Actual 2009 Actual 2010 Adopted Budget 2011 Object Detail Amount 2011 Proposed Budget Comments All Salary Costs Inclusive of 650 45130 101.00 Salaries & Benefits $144,100 Salary, Taxes, PERA & Benefits 650 45130 77 101.00 Administrative 34,081 29,814 39,280 38,500 38,600 650 45130 78 101.00 Technical /Clerical 26,936 28,383 33,224 34,100 35,500 650 45130 79 101.00 Maintenance 96,916 89,495 60,654 61,400 70,000 650 45130 xx 101.00 Salary & Benefit Contingency 0 0 0 2,000 0 650 45130 79 102.00 Full -Time Overtime 5,180 3,826 3,836 4,700 2,000 650 45130 103.00 Part -Time Salaries & Benefits 50,000 650 45130 89 103.00 Leam- To-Skate Program 27,100 24,985 23,641 27,000 25,000 650 45130 99 103.00 Building Attendants 15,392 33,493 31,815 20,000 25,000 And Other PIT Positions 650 45130 01 207.00 Training & Instructional Supplies 0 0 0 100 100 650 45130 01 208.00 Miscellaneous Supplies 700 650 45130 01 208.01 Skate Magnets 0 0 0 100 100 650 45130 01 208.02 Other Supplies 0 418 176 600 600 650 45130 01 209.00 Other Office Supplies 575 687 54 500 500 Learn to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 3,302 3,811 2,961 4,000 4,000 650 45130 01 212.00 Motor Fuels 0 0 0 0 0 Zamboni Maint. (Every 3rd Year) 650 45130 01 216.00 Chemicals & Chemical Products 2,814 2,528 4,217 3,000 3,000 Assorted Products 650 45130 01 219.00 Other Operating Supplies 434 16 2,523 500 500 Events Supplies 650 45130 01 221.00 Equipment Parts 2,605 4,302 4,374 4,000 4,000 650 45130 01 223.00 Building Repair Supplies 1,444 1,952 2,149 3,000 3,000 650 45130 01 265.00 Other Items for Resale 515 600 517 600 600 Pro Shop Supplies 650 45130 01 305.00 Medical & Dental Fees 0 0 0 0 0 650 45130 01 311.00 Officiating Fees 2,075 1,080 0 0 0 650 45130 01 317.00 General Fund Admin Fees 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Admin Fee Policy 650 45130 01 321.00 Telephone Costs 1,000 1,000 833 1,000 1,000 650 45130 01 331.00 Travel Expense 0 0 0 100 100 650 45130 01 341.00 Employment Advertising 0 0 0 0 0 650 45130 01 349.00 Other Advertising 210 284 110 400 400 650 45130 01 365.00 Workers Comp Insurance 2,691 2,994 2,730 3,200 3,200 650 45130 01 369.00 Other Insurance 7,746 7,772 7,884 8,000 8,000 650 45130 01 381.00 Electric Utilities 114,332 110,858 112,239 120,000 120,000 650 45130 01 383.00 Gas Utilities 34,232 37,862 27,568 45,000 31,000 650 45130 01 384.00 Refuse Disposal 3,455 3,613 3,237 3,500 3,500 650 45130 01 401.00 Contracted Building Repairs 13,014 3,096 6,754 5,000 7,000 650 45130 01 404.00 Contracted Mach & Equip Repairs 11,028 16,101 23,788 15,000 16,000 650 45130 01 415.00 Other Equipment Rental 0 0 300 300 300 650 45130 01 433.00 Dues & Subscriptions 475 350 1,165 500 500 MIAMA & MRPA Dues 650 45130 01 437.00 Conferences & Seminars 0 0 220 400 400 MIAMA Seminars 650 45130 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 Contingencies 650 45130 01 521.00 Building & Structure Purchases 0 64,921 0 0 0 650 45130 01 580.00 Other Equipment Purchases 0 2,822 0 42,000 12,000 New Batteries 650 45130 01 710.00 Transfers 3,500 650 45130 01 710.01 Yearly Maintenance 3,500 3,500 3,500 3,500 3,500 650 45130 01 710.02 0 0 0 0 0 650 45130 01 710.03 0 0 0 0 0 FUND TOTALS 417,050 486,563 405,748 458,000 425,400