Loading...
HomeMy WebLinkAbout2.c. 2007 BudgetAGENDA ITEM: 2007 Budget AGENDA SECTION: Discussion PREPARED BY: Jamie Verbrugge, City Administrator AGENDA NO. 2C ATTACHMENTS: 1. Departmental Budget Documents 2 Preliminary Budget Summary Spreadsheets and Line Item Requests APPROVED BY: RECOMMENDED ACTION: Discussion 4 ROSEMOUNT CITY COUNCIL City Council Work Session. August 9, 2006 EXECUTIVE SUMMARY ISSUE The City Council held a preliminary budget discussion at its July 12 Work Session. Direction at that meeting was to prepare budget matenais that did not increase the City's tax rate Council also requested that department heads provide an overview of then operating budget requests at the August work session. The discussion this evening is a continuation of the 2007 budget preparation process. The City Council must set a preliminary levy on Tuesday, September 5, 2006. BACKGROUND Attached for Council's review are the respective depainuental summaries accompanying their operating and capital requests for 2007 Staff made several adjustments to the budget after the July work session to create a preliminary budget that does not increase the tax rate The changes are a combination of reductions and additions The additions are primarily new initiatives that were not included in the prehminary budget spreadsheet provided to Council m July. At that time, the first draft of the spreadsheets indicated a tax rate increase which staff understood was not an acceptable position for council. The adjustments have allowed for the consideration of several new initiatives that the City Administrator has prioritized. Those changes included A reduction of $275,000 in bonded indebtedness Finance Director May discovered that recently issued debt was being booked by our financial consultant as a general levy obhgation. The debt is being financed with assessments and water core funds, rehevmg the general levy of the obhgation. A reduction of $60,000 in the operating levy for the Port Authonty. To offset the Port's levy reduction, management consultant funds have been reduced by $10,000 and management fees for environmental work related to the an cargo project have been reduced by $50,000. A reduction of $4,000 m the Parks Recreation budget for newsletter costs. This reduction is attained when combined with a proposed new uunanve (see below). An addition of $10,100 to the Police budget to cooperatively fund a recommendation from the HIPP Public Safety Support Center committee following an IT Needs Assessment to pay for software and system upgrades for police communications An addition of $8,000 to Government Buildings for lighting system upgrades. Our staff had Xcel Energy conduct an energy audit earlier this year The cost is to finance the improvements, which have a 4 6 year payback on the annual savings that will be achieved. An addition of $21,000 m the Parks Recreation budget for software to run online registration for recreation programs An addition of $13,000 m the Council budget to increase the City's newsletter from a quarterly distribution to hi-monthly The Parks Recreation brochure would also be spun off and achieves cost savings as a result An addition of $8,400 to the Administration Communications budget to provide video streaming capabilities for City Council meetings This initiative is being spearheaded by the Apple Valley, Farmington, and Rosemount Cable Commission The proposed costs is the City's monthly expense of $700. Should the commission move forward, it is being proposed that AVRFCC will pay the costs for purchasing and installing the capability. An addition of $4,200 to the Administration Communications budget to implement a bulk e -mail system An addition of $71,000 to the Administration budget to hire an Admimstranve Assistant The result of these adjustments is a net reduction of $211,300. That puts the budget in line to hold the tax tate steady. However, after the budget documents were prepared and while this memo was being formulated, staff learned from Dakota County that the calculation of Captured Tax Increment Tax Capacity has increased substantially for 2007 as a result of valuation increases from new development on the former Brockway site. The effect of the captured tax capacity is to increase our funding needs by $96,000 to maintain a level tax rate This explains the dhipanty between the previous paragraph's statement that the tax rate is level, and the fact that the attached tax rate spreadsheet shows an increase in 2007. Staff has not had an opportunity to make recommendations on budget adjustments since heanng from the County. SUMMARY Department heads will provide a bnef overview of their operating and capital requests. Following that discussion, Staff would like Council to have further discussion about an appropriate number for the preliminary levy, i e whether Council would prefer to certify a preliminary levy that is flat or to certify a levy that shows a decrease m 2007 In either case, staff will be working on recommendations to accommodate the $96,000 gap created by the County's information. Staff will also distribute an updated year -to- budget at the work session based on month end reports for July August 9 City Council Work Session Present line item detail of 2007 departmental operating and capital requests Update of year -to -date budget Continue discussion of preliminary levy certification August 23 Special City Council Work Session (tentative) Continue preliminary levy discussion, dependent on progress at the August 9 meeting 2 September 5 City Council Meeting Certify preliminary levy October 11 Council Work Session Update year -to -date and year -end fiscal forecast Update key financial strategies Review capital improvement plan October 25 Special Work Session Departmental review November 8 Special Work Session Departmental review November 15 Regular Work Session Final budget discussion December 4 Special Council Meeting Truth in taxation hearing December 5 City Council Meeting Final budget and levy adoption 3 4 ROSE_\AMIN 1 ADMINISTRATION To: Jamie Verbrugge, City Administrator From: Dawn Weitzel, Assistant City Administrator Date: June 26, 2006 Subject: Budget Narrative The Administration Department is responsible for the overall management of all departments within the City and for assuring that departmental acnvities are consistent with the goals established by the City Council Specific functions may be broken down into General Administration, Records Management, Reception, Licensing, Electrons, Human Resources Adnumstration, and Public Relations /Commumcanons /Matketmg. General Administration Staff assigned to this area provides for the management administration and coordination of activities m all City departments including. Community Development, Finance, Fire, Police, Public Works and Parks and Recreation \dmuustration provides for the preparation and overall management of the City's budgets; offers management for projects that are uruque and not assignable to other departments (i.e construction of Fire Station II, Library, remodeling of City Hall provides overall coordination of City consultants, oversees the execution of all policies as adopted by the City Council, through the Clerk's office provides administrative and clerical support to the City Administrator and City Council; and prepares, distnbutes and maintains City Council meeting documents. Records Management Records management is one of the most essential functions of this department. Administration provides for the preparation and maintenance of official records for the City including Council, Port Authority and Comnnssion mmutes In addition, department staff prepares and assures publication and posting of official notices, supplies public mformanon on ordinances, contracts and policies, and adtmmsters the collection, storage and dissemination of data. Several staff members provide notary services and the Clerk oversees any DocuWare program changes and training. Reception Rosemount's Receptionist provides the uutial contact that the public experiences when coming into City Hall or calling for information. This employee also offers ongoing administrative support to a majority of the departments (i.e. prepares invoices, data input of utility payments, orders and maintains inventory of meters, transcribes letters/memos/reports for the fire department, assists with mailings). Along with die City Clerk, the Receptionist prepares and executes all elections. Licensing The issuance and renewal of hquor and beer licenses, peddlers, solicitors and transient merchants, gambling permits, and block party street closures are all functions of the Administration Department. This effort is coordinated with other city departments to ensure that licenses are issued according to ordinance requirements Elections Administration staff manages City elections A few duties include: organizing voter registration, maintaining election egmpment, recruiting and training election judges, preparing the polling locations and performing Elecnon Day activities. Human Resources Administration The human resources division of the department provides services that will retain current employees and aid m the recruitment of new employees. Staff administers City peisonnel policies and procedures, assures compliance with union contract language, and meets the terms of state and federal labor regulations The human resources division is responsible for the planing, coordination and evaluanon of City -wide training to support employment law comphance and achievement of goals and pohcies. Staff maintams relationships with collective bargaining units Public Relations /Communications Marketing Staff within this division manages the internal and external communications (i.e. newsletters, mformauonal mailings, press releases, Internet, and mtranet) regarding the City's achievements, challenges, and goals As the pubhc relations hub, this area guides the media and public toward key messages and requested mforinanon. Staff also aids in the preparation and execution of public information in times of emergency response. In addition, the Communications Coordinator maintains and updates the City's photographic archive of events and supervises the implementation and utilization of our visual identity system to promote the City's development interests. Efficiencies and Operational Change The human resources staff of Dakota County and cities within Dakota County (HiPP) continues to meet regularly having discussion regarding more efficient and effective ways of providing benefits and services to employees Staff of Dakota County and select cities has recently submitted a Blue Cross Blue Slueld grant money apphcanon ear marked for coimnunity -wide or organizational health initiatives In addition, Dakota County is working with Deloitte to study leading health insurance practices Potential areas of study include. emerging trends m plan design including high deductible health plans, health savings accounts, and tiered networks; financial incentives to encourage healthy behavior, tools and resources for consumers to make informed decisions; and targeted care management programs In 2006 the City say dechnes m long -term disability rates, hfe insurance rates and dental rates declined due to staff's involvement in working with other municipahties to jointly purchase insurance In 2006 Rosemount's Insurance and Benefits Committee was formed to further study premium rates and dispense accurate information to co- workers New Initiatives (see following pages for details) Council Budget. Increased frequency of mailed newsletters (additional $7,000 to $15,000) Administration Budget Bulk e -mail system ($1,800 start-up, $2,340 for maintenance) Increase cablecasting of pubhc meetings ($7,600 plus additional training costs Post video of public meetings on website (Cable Commission may be providing the initial start-up cost of $11,700 /the City would need to pay a monthly cost of $700) Future Forecast With the city glowing at such a fast pace analysis needs to be conducted regarding the staff and equipment capacity each of our buildings can absorb With the creation of four new work spaces last fall, this building has met tts availability for staff capacity Two of these work stations are vacant and the third houses administration's intern. The Public Works buildings reached its equipment capacity some time ago and they continue to space issues CITY OF ROSEMOUNT REQUEST FOR REGULAR (FULL -TIME OR PART -TIME) PERSONNEL 1 Hours per Week 2 Department Cost 3. Indicate need for position(s) Allocation New Operation 40 Administration Expanded Services Finance (X Increased Work Load 4 Position Title 5 Number Required 6. Salary 7 1st year Cost Secretary or 1 $32,562 $43,869 Administrative Assistant $42,765 $55,403 8 List below the fob duties to be performed in the requested position(s) Administrative position for the City Administrator, Assistant City Administrator and Finance Director. Human Resources: Assist with the human resources function by preparing and processing routine payroll and benefit forms, preparing confidential employee personnel files, researching and responding to employee inquiries, and drafting routine correspondence as directed or required by the Assistant City Administrator. Assist in the planning and coordination of training programs. Assists with the implementation and administration of benefit programs. Assists with recruitment processes. Administration: Fill in for City Clerk when not available to attend Council meetings. Draft routine correspondence as directed by the City Administrator. Finance: 9. Specify how the above listed job duties are currently performed Planning and Personnel Secretary (less than three hours per week), Assistant City Administrator and occasionally the Receptionist (this is limited due to the location and type of material handled). 10 Explain the need for position(s) in detail Due to the demands of the Community Development Department, the Planning and Personnel Secretary spends very little time in the area of Human Resources. Four years ago the human resources division utilized 12 a week of this person's time. With an increase of time being devoted to large projects, the Assistant City Administrator needs more administrative help. Form processing and accurate filing is critical to human resources and there is much work to be done in this area on a regular basis. 11 Addition costs associated with requested position(s) Contractual Services 8 Commodities Capital Outlays Office space is available CITY OF ROSEMOUNT 2007 BUDGET PROPOSAL NEW INITIATIVE/PROGRAM REQUEST Initiative /Program Name: Post video of full public meetings on website Department Primarily Responsible: Administration Brief Narrative of Initiative /Program: (e g description ofproject, timeline, level of need) The City currently posts brief excerpts of Council meetings on its website. Outside vendors make it possible to post video of all public meetings already carried on cable access. An indexing system would permit users to jump to specific agenda items. Meetings would be streamed live so that users without Rosemount cable could watch live or on recordings. IT this issue /project is not pursued, will it affect city service levels? No reduction in current services. If yes to previous question, when and to what extent? Estimated Cost and Cost Details: Startup cost $11,700; monthly cost: $700. What are the funding options for this initiative /program? Cable Conunission is considering paying all startup costs and whether it is legal to pay half of the monthly costs out of PEG fees, thereby reducing the impact on the City budget to $350 per month. What additional costs will be obligated as a result of this initiative /program? (1 e fit is a study, what follow up costs would be anticipated? If it is a capital project, what are potential costs for operations and maintenance None. What other options exist related to this initiative /program? Continue to post selected segments of meetings occasionally to the website. CITY OF ROSEMOUNT 2007 BUDGET PROPOSAL NEW INITIATIVE/PROGRAM REQUEST Initiative/Program Name: Bulls email system Department Primarily Responsible: Administration Brief Narrative of Initiative/Program: (e g, descnptlon of project, tunehue, level of Peed) The vendor GovDelivery maintains a database of email users who have requested inclusion on various lists keyed to specific webpages on the City website. When the page is updated with new information, a notification is automatically emailed to list members. Custom messages not keyed to specific webpages can also be sent. If this issue /project is not pursued, will it affect city service levels? No reduction in current services, although there is a risk that the current distribution list for the Weekly Update may be reached and prevent adding additional addresses. If yes to previous question, when and to what extent? Estimated Cost and Cost Details: Startup cost: $1,800, monthly cost $195. What are the funding options for this initiative /program? What additional costs will be obligated as a result of this initiative /program? (z e f it rs a study, what follow up costs would be anticipated' If it rs a capital protect, what are potential costs for operanois and maintenance?) None, except for small amounts of work time to maintain links to the service on the website and to create customs messages. What other options exist related to this initiative /program? Recent addition of RS feeds to the City website will achieve some of the same goals of Notifying the public about City updates, but only for "early adopters" of the technology and without the level of customization possible with multiple mailing lists. CITY OF ROSEMOUNT 2007 BUDGET PROPOSAL NEW INITIATIVE/PROGRAM REQUEST Initiative/Program Name: Increase cablecasting of public meetings Department Primarily Responsible: Administration Brief Narrative of Initiative/Program: (e g, Jesen ofpro)ect, annelme, level (f need) 1 he City currently pays to produce only a limited number of its public meetings for showing on cable TV access. Cablecasts could be added for all advisory conunission meetings, Council work sessions, and select public meetings or open houses held in the Council chambers. If this issue /project is not pursued. will it affect city service levels? No reduction in current services If yes to previous question. when and to what extent? Estimated Cost and Cost Details: A year of additional meetings: 47,600, plus possible costs for recruitment and training of new freelance crew membeis What are the funding options for this initiative /program? What additional costs will be obligated as a result of this initiative /program? (i e fit is a stusj, i +hat follow up costs would he wittczpated If It is a capital project what w-e potential costs for cperanons and A^alrltenal]ce 2 Minor expenses for extra supplies to archive meetings, incremental increase in costs to operate video equipment. What other options exist related to this initiative /program? Audio recordings of meetings could be made and posted to the website. Additional work would be required to transfer the audio to a downloadable format. CITY OF ROSEMOUNT 2007 BUDGET PROPOSAL. NEW IN RAM REQUEST Initiative /Program Name: Increase frequency of mailed newsletters Department Primarily Responsible: Administration /Parks and Recreation Brief Narrative of Initiative/Program: (e, g description of project, 11177e1771 2, level ofaeed) The City currently publishes a quarterly newsletter. Frequency of publication could be increased to bimonthly for the general, front -of- the -book section of the current newsletter, and Parks and Recreation could be spun off to its own publication three or four times a year. If this issue /project is not pursued, will it affect city service levels? No reduction m current services. If yes to previous question, when and to what extent? Estimated Cost and Cost Details: Cost For Administration would be S13,000 more expensive than current arrangement. Cost for Parks and Recreation would be S6,000 cheaper for three -tunes yearly or $2,000 more expensive for four -times yearly. What are the funding options for this initiative /program? What additional costs will be obligated as a result of this initiative /program? (z e of it is a study, what jolloE,v up costs would be anticipated' !fit is a capital project, what ars potential costs tor operations and maintenance Greater time commitment for staff, especially communications coordinator, to create material for additional issues What other options exist related to this initiative /program? To: Rosemount City Council Jamie Verbrugge From: Kim Lindquist Date: June 16, 2006 Subject: 2007 Budget It ROSEMOUNT COMMUNITY DEVELOPMENT M E M O R A N D U M The purpose of this memo is to address several items relating to the Community Development Department and proposed budget for 2007 General Overview of Department and Services Depait vent staffing currently stands at 12 people; 6 in building division, 4 in planning /economic development, 1 code enforcement and 1 GIS technician. The secretary who assists in planning also provides support to the Human Resources function located in Administration (30 hours planning /10 hours HR per week). The workload for the position continues to increase and could certainly be a full time rather than job share position. The department is fully staffed. There is no expectation that additional personnel will be needed next year or in the short term. We have personnel available to handle the core functions of the department, planning, economic development, building, and code enforcement. Revenue Enhancements The maionty of the revenues for the depot hitent come from fees associated with building permits. To a lesser extent planning fees defray some of the depart vent costs. Code enforcement will be exploring a rental housing program which would increase revenues for that division although additional work would also be required It is not expected that the rental inspection program would cover the cost of the code enforcement specialist although would assist in defraying salary costs. Budget and Service Volatility Building and planning fees are dnven by the market and cannot be mcreased through any specific employee actions. The only option would be to increase fees. Staff has consistently evaluated the fee schedule and has made modifications to them as necessary. Additionally, building permit fees have been adjusted over time consistent with the ICBO 1997 modified fee schedule. Building permits are down from a high in 2004. In the first quarter of 2006, permits continued to be down from '04 and '05 in which 454 new residential permits were issued. By May new residential permits had increased to 2002 and 2003 levels In those two years the number of new residential starts was 330 and 440 Staff has been estimating new starts to be in the 350 range for 2006 and 2007 due to a number of factors. reduced number of ROSE MOUNT COMMUNITY DEVELOPMENT M E M O R A N D U M builders in the community; economic downturn in housing; and limited amount of land for development The last issue will be resolved when the 42/52 area is available for development The expectation is that the land ill be available for utility installation in 2007 with residential construction occurnng in 2008. This schedule is aggressive and requires that the property owners obtain planning approvals in a timely manner Although residential housing starts have decreased there has been an increase in construction valuation which has offset some of the revenue decrease Additionally, there has been more commercial, industnal, and institutional construction in the last two years than in years previous. This year the institutional values are quite high. However, this does not always translate into increased revenues as the State conducts plan reviews for all school buildings and conducts inspections for any development on the UAlore property. Efficiencies and Operational Change As previously mentioned the Department is fully staffed. At the time of wasting there will be four employees who have been in their position less than three months. We will be dedicating the remainder of 2006 and 2007 to acchinanng new employees to their required job tasks Additionally, we will look toward each staff member to bnng their own experience and professionalism to the position looking for opportunities to adapt the work program; making it more efficient and effective. Planning continues to look at the development review process to increase efficiencies while providing accurate information Staff will be looking to refine the process and provide additional information to the public, providing opportunities for input into the process earlier or providing a mechanism to obtain project information in an easier manner. Given the goals of communication, the legal requirements associated with planning application review, and the volume of paperwork churned out in the Planning Division, we look forward to having the secretary being designated as full -time to the Department rather than shared with Human Resources The volume of work has increased dramatically over the last several years and a full time compliment is needed Likewise I am aware that the "shanng arrangement" does not allow adequate time for the person to undertake all the tasks necessary in Administration. Building also continues to look at streamlining their review process. Previously checklists and a tracking system have been put into place. Inspectors continue to work closely with engineering, assisting in erosion control inspections while out on lob sites for building inspection work This has freed up time for engineenng personnel to accomplish other tasks and allowed the city to comply with new DInPCA rules. New Initiatives As the Code Enforcement Specialist becomes more proficient in his duties, we will be looking to expand his areas of responsibility The Department will be explonng a rental inspection program for all rental properties in the community. This would be undertaken ROSEMOUN 1. COMMUNITY DEVELOPMENT M E M O R A N D U M with the building inspection division In concert with Public Works we will also be investigating taking over the weed inspection program in 2007 During 2007 the planning division will spend a good portion of time on the required 2008 Comprehensive Plan update. It is intended that the Plan update will be conducted in house with the assistance of the new GIS Technician for mapping and WSB as an infrastructure and transportation resource Revenue Forecastin• Staff is expecting residential permits in 2007 to continue to be lower than the high of 2004 and slightly under what was experienced in 2003 (441 permits). There continues to be an approved inventory of lots that assures steady growth however, the lots are consolidated in a few projects where individual builders control the flow of work. The reduction in units and the return to lower valued attached housing construction versus detached, leads staff to be cautious about projecting revenues A further reduction in building permits may be experienced in 2007 if developers in the 42/52 area do not begin to plat properties While we have had discussions with a variety of developers in the area, it is unclear what the ultimate timing is Recently, one developer notified staff that they would not be pursuing purchase of the McMenomy property This is a tract that would be in a later phase of development due to utility timing, however; their decision to let the option lapse may be indicative of the lagging market. It is difficult to project revenues at this early stage of the year. Staff would like to revisit this issue later in the year when revenue numbers are clearer Commercial and mdusinal projects can soften the revenue decrease of a slowed residential market although these are often "one- time" projects that cannot be forecast at the time of budget compilation. While staff would expect that commercial and industrial growth will continue as compared to previous years, there is no way, with a high level of certainty, to accurately project future developments and associated revenues. Depaituient Goals Similar to last year, I have included the goals, or work plan, we anticipate undertaking in 2006. Plannnng Continue ordinance revisions including the modification of residential zoning districts. (Commercial and Industnal Distncts will be completed) Make Comprehensive Plan adjustments and start documenting changes to be reflected in the update scheduled for 2008. Planning files have been organized and will be ready for scanning. Buxang Continue current level of service for permit turn- around and scheduling of inspections ROSEMOUNT COMMUNITY DEVELOPMENT M E M O R A N D U M Complete compliance with ISTS ordinance requirements throughout community. Serve as coordinator for Fire Station construction Provide continued assistance to Engineering Department for NDPES and erosion control requirements. Economy Development Continue work on Downtown Redevelopment including shepherding the Core Block East project through planning review and ensure appropriate communication to residents and businesses. Begin discussions on Core Block West redevelopment. Marketing of entire community, 3 -4 major marketing pieces in 2007. Meet with businesses in community, targeting Business Park Continue to facilitate Air Cargo project. Code Enforcement Research rental housing inspection program; begin implementaton. Draft Sign ordinance update Continue sequential enforcement program and evaluate for improvements or modificanons Explore adding weed inspection responsibility. 4 ROSEMOUNT MINNESOTA M E M O R A N D U M To: Jamie Verbrugge, City Administrator From: Jeff May, Finance Director Date: June 9, 2006 Subject: Budget Summary 1) General Overview of Services Attached for your review are the Finance Department and the Insurance budget narratives These narratives do a good lob of giving a thorough overview of our department's activities 2) Revenue Enhancements The Finance Department does not currently have and revenues that are produced as a result of our work 3) Budget and Service Volatility The only factors that I can foresee that could influence our operations would be the continued increase in volume of our responsibilities and the increased reporting mandates that are handed down to us from higher levels of government. 4) Efficiencies and Operational Change In 2006 we have assumed much of the work related to the maintenance of the special assessment records This process is in flux as we train in our new part-time person and realign the duties of some of our staff We will be assuming these responsibilities that have not been taken care of by our department m the past without adding any new personnel. 5) New Initiatives We have nothing m store for 2007 in the way of new mittanves 6) Future Forecast We will be looking to add staff in the next few years but there would be nothing to be done in 2007 that would impact that preparation Actually, we may be able to delay future staffing for a short time if the County takes over the Deputy Registrar in 2009 when the new library opens. The Finance Department's goal for 2007 is to maintain the same level of service that we are providing m 2006 Quantity Unit Cost Total Cost Trade -In Net Total Cost 40 S1,750 $70,000 SO $70,000 CITY OF ROSEMOUNT JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS 1 Department Finance Dept Account No 2 Give Description and Quantity of item Requested Indicate Date Desired PC Workstation Replacements (From 2003). Request purchase 1 quarter of 2007. 3 Describe the necessity for and/or benefits or savings expected from this item. The workstations for our main operations are replaced every 4 years We replace one -half of them every two years In 2007, we will replace all of the Police Depat uuent workstations and the rest of the workstations that were purchased in 2003. 4 If the item requires an increase in personal services for the activity, state the new job title(s) contingent upon the item N/A 5. Indicate any expenses necessary to place this item in operation and whether these expenses are included in your budget request The costs for installation and setup are included m the Finance Department operating budget 6 List any item which will be replaced by this purchase. State recommendations for disposition of this item. For example, trade -in, salvage, discard, etc All old workstations will be given to the Minnesota Computers for Schools program. This program allows for the reuse of old computer equipment that is refurbished or used for parts We have worked with this program for the last few years. ESTIMATED COSTS DATE: June 14, 2006 RE: 2007 Budget Memo Parks MEMORANDUM TO: Jamie Verbrugge, City Administrator Jeff May, Finance Director FROM: Dan Schultz, Director of Parks and Recreation PARKS AND RECREATION DEPARTMENT OVERVIEW The Parks and Recreation Department works together with citizens to provide a safe, healthy and pleasant community Parks and recreation is an essential senace, one that can impact health, crime prevention, the envuonment, 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 Recreauon. This department provides a diversified range of programs for the residents of Rosemount The long range planning, development and budget preparation of parks and coordination with other service agencies are ongoing activities Adnunistrative services also provide the residents of Rosemount an opportunity to reserve facilities and register for programs Provides the Rosemount residents a vanety of recreational opportunities thiough a developing park system currently encompassing over 300 acres. Offerings include athletic facilities, trails, open space, playgrounds, picnic shelters, and other special use facilities Staff work closely with the Parks and Recreation Commission to evaluate and determine the proper level of development needed to meet the needs of Rosemount residents. Coordination with other service agencies encourages a comprehensive, quality and efficient base of parks amemttes. 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 Centel, which offers facthues for recreational programs, banquets, meetings, events, theatrical productions, seminars and exercise The Commumty 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 for the Community Centel and National Guard facilities. ICE ARENA Administration The Parks and Recreation Department is responsible for the administration of the Ice Arena. Scheduling and invoicing of ice are the main administrative duties of ice arena operations The scheduling of pnme time ice is coordinated with Independent School Distnct #196 and the Rosemount Area Hockey Association for practices, games and tournament play. The Parks and Recreation Department provides overall planning, coordination, management of personnel and admuustration 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 mamtenance of the ice arena building structure and its mechanical components. Ensures ice is maintained at optimal efficiency Revenue Enhancements N/A Budget and Services Volatility Utilities (natural gas and electricity) is always an area that causes a concern when discussing budgets Staff annually reviews a vanety of options to conserve on the use of electricity and natural gas Efficiencies and Operational Changes N/A New Initiatives The City will be organizing an adult broomball league in the spring and fall. This will result in a small revenue increase in the arena. Future Forecasts The Parks and Recreation Department will continue working to meet and surpass the goals of our City Council and needs of our residents It appears that many of our recent discussions m the area of recreation have been about recreational facahties. The current staffing levels are sufficient to meet the programming needs of our community The recreational facthty needs will have to be defined and researched to better understand the facility needs and both the operational and capital impacts to current and future budgets PARKS AND RECREATION The Parks and Recreation Department works together with citizens to provide a safe, healthy and pleasant community. Parks and recreation is an essential service, one that can impact health, crime prevention, the environment, the economy and the quality of life for Rosemount residents. ADMINISTRATION RECREATION Provides for overall planning, coordination, management of personnel and admuustration of acttvines witlun the department of Parks and Recreation This department provides a diversified range of programs for the residents of Rosemount. The long range planning, development and budget preparation of parks and coordination with other service agencies are ongoing acuvines Administrative services also provide the residents of Rosemount an opportunity to reserve facilities and register for programs. 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 oilier service agencies encourages a comprehensive, duality and efficient base of programs. COMMUNITY CENTER Provides for operation of a multi- purpose Community Center, which offers facilities for recreanonal 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 lanitonal services of the Community Center and National Guard facilities. ADMINISTRATION The Parks and Recreation Department administer the Ice Arena. Scheduling and invoicmg of ice are the main admuustranve 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 MAINTENANCE ICE ARENA Provides recreational open skating for the residents of Rosemount as well as learning to skate and figure skating programs. Provides ongoing and preventative mamtenance of the ice arena buildmg structure and its mechanical components. Ensures ice is maintained at optimal efficiency Initiative /Program Name: L C- Brief Narrative of Initiative/Program: (e g desenptxonofproject, tnneltne, level of need) ICees Estimated Cost and Cost Details: CITY OF ROSEMOUNT 2007 BUDGET PROPOSAL NEW LNITIA7IVE /PROGRAM REQUEST Department Primarily Responsible: l e t I a e C r e e k a. d rr S V- 4.6 If this issue /project is not pursued, will it affect city service levels? 6 N° If yes to previous question, when and to what extent? CoS7L5 What are the funding options for this initiative/program? Re- t/ �1 4r Z QD0 &r 4—e What additional costs will be obligated as a result of this initiative/program? (i e d it is a study, what follow up costs would be anticipated? If tt is a capital pioject, what are potential costs for operations and maintenance What other options exist related to this initiative /program? fr (PA CITY OF ROSEMOUNT 2007 BUDGET PROPOSAL NEW INITIATIVE/PROGRAM REQUEST lnitiatiive /P rogt am Name: Department Primarily Resplfnsible: iG Brief Narrative of Initiative /Program: (e g description of project, timeline, level of need) (7v1vf -J fire V °I b'Z 7172 (O a r 5trfr' r,.. for operations and maintenance 7 o G Gm k Ge .ems +-t Estimated Cost and Cost Details: Cod Z of/ If this issue /project is not pursued, will it affect city service levels? If yes to previous question, when and to what extent? Ovl %nom What are the funding options for this initiative /program? ecr et to C Cc jh'. r s What additional costs will be obligated as a result of this initiative /program? (i e if it is a study, what follow up costs would be anticipated? If it is a capital project, what are potential costs C elt t5 What other options exist related to this initiative /program? Quantity r` 5G Unit Cost Total Cost Trade -In 7O Ooo Net Total Cost Sir voc7 1 Depaihuent 2. Give Description and Quantity of Itern Requested Indicate Date Desired. /77` Sc.- Me ,ryes-La..-"Is 3 Describe the necessity for and/or benefits or savings expected from this item 4. If the item requires an mcrease m personal services for the activity, state the new job htle(s) contingent upon the item 5 Indicate any expenses necessary to place this item m operation and whether these expenses are included m your budget request 6 List any item which will be replaced by this purchase. State recommendations for disposition of this item. For example, trade -m, salvage, discard, etc CITY OF ROSEMOUNT JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS Dept Account No //mil s /re-6 e A"t—t ✓J v UJ 'a r1r t ESTIMAILD COSTS to X f S UC r,'ez .s f rrvf /n -¢-„✓l S cu r (;)C t' 1 e Cos Quantity Unit Cost Total Cost Trade -In Net,Total Cost 3. Descnbe the necessity for and/or benefits or savmgs expected from this item. //17( /J GC /o c G� 4/v7vP -1.- 4. If the item requires an increase in personal services for the activity, state the new job title(s) contingent upon the item. l/ JJ' D®✓ GZG2 -z.EG C,--Y. n; j s-de s't -=C.u ®m 0c l CITY OF ROSEMOUNT JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS 1 Department P ay kg V- Fri Dept Account No 2 Give Descnption and Quantity of Item Requested Indicate Date Desired ///J� yl �e W i'lFr� icy try j- �ov l/ 3. Descnbe the necessity for and/or benefits or savmgs expected from this item. //17( /J GC /o c G� 4/v7vP -1.- 4. If the item requires an increase in personal services for the activity, state the new job title(s) contingent upon the item. l/ JJ' D®✓ GZG2 -z.EG C,--Y. n; j s-de s't -=C.u 5 Indicate any expe nses necessary to place this item in operation and whether these expenses are Included an your budget request fie I T bbrr -Lie, v�(iH I 4e a 1Q J Y 0 O O p'� W L 7K Z 6 List any nem winch will be replaced by this purchase State recommendations for disposition of this item For example, trade -in, salvage, discard, etc ESTIIVIAI'ED COSTS Quantity C Umt Cost Total Cost Trade -In Net Total Cost r 0 CO o d 0 S 0 0, 0 8 0 1 Department /GS cL /ze JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS 2 Give Descnption and Quantity of Item Requested Indicate Date Desired 3. Describe the necessity for and/or benefits or savings expected from this item CITY OF ROSEMOUNT Dept Account No 4. If the item requires an increase m personal services for the activity, state the new job title(s) contingent upon the item Indicate any expenses necessary to place this item m operation and whether these expenses are included m your budget request %—e 1 d '1 7 /P 6 List any item which wiI1 be replaced by this purchase State recommendations for disposition of this item. For example, trade -m, salvage, discard, etc. ESTIMATED COSTS cct Quantity y/ 'J Unit Cost 5 cot) Total Cost Trade -In Net Total Cost q Doe CITY OF ROSEMOUNT JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS 1. Department 17k— Y- e C- Dept Account No 2 Give Descnption and Quantity of Item Requested Reque�stted Indicate Date Desired `t °Li 6 /po i c 01� e- r r_-a,7".j 3 Descnbe the necessity for and/or benefits 1 /d J' 7 6 2 or savings expected from this item. Pfr t/T t tt_t —e_ as- •1 of e rr_ r! 4. If the item requires an increase m personal services for the activity, state the new fob title(s) contingent upon the item n 5 Indicate any expenses necessary to place this item m operation and whether these expenses are included m your budget request 6 List any item which will be replaced by this purchase State recommendations for disposition of this item For example, trade -m, s alvage, discard, etc ESTIMATED COSTS d 7 ROSE_ MOUNT To: Jamie Verbrugge, City Administrator From: Gary Kalstabakken, Chief of Police Date: July 13, 2006 Subject: 2007 Budget Proposal Overview POLICE DEPARTMENT M E M O R A N D U M The Police Department provides general, full service law enforcement for the community. Specific functions may be broken down into Administration /Support Services, Patrol, Investigations and Emergency I\fanagement Administration/ Support Services Staff assigned to this area provides for the overall planning, coordination and management of the department. In addition, this includes the records management duties of the department Secretarial staff is responsible for transcribing and fihng the crime and administrative reports required of criminal Justice agencies Routing of criminal cases to the County Attorney's office or City Prosecutor must be completed in a timely manner Reports must also be referred to social service and other related agencies. Crane data is reported to the Minnesota Department of Pubhc Safety Animal control is also a function of Support Services Community service officers have the primary responsibility for this duty but police officers handle this task when a CSO is not on duty. The CSOs also assist with the enforcement of property maintenance code violations Patrol This is the most visible function completed by the department. Officers provide response to emergency and non emergency calls regarding criminal activity and to other calls for service. Traffic enforcement and directed patrols also require a significant amount of tune of the officers. Many of the officers assigned to patrol complete other specialized duties, for example, tactical team member, use of force and firearms training mstructor, or child passenger restraint inspection. Investigations Officers assigned to investigations conduct follow -up on criminal cases that require travel outside of Rosemount, are complex m nature or will require a significant amount of tune to complete Other cases are frequently investigated by the patrol officer originally assigned to the incident. Included in the function are the special assignments of officers to DARE and school liaison dunes. These services are provided as a joint effort with the schools located within the community with some funding received from the school district to offset the costs of these programs. The DARE officer is also responsible for the deparnnent's cnme prevention, 4 ROSEMOUN 1 POLICE DEPARTMENT M E M O R A N D U M public education and outreach actrvmes. This includes the programs of Neighborhood Watch, Nanonal Night Out, Crime Free Multi- housing and presentations to community groups. Emergency Management The preparedness of the City's Emergency Operations Plan and management of the city's response to natural, technological, man -made or any other emergency situation is a function of the police department. This effort is coordinated with all other city departments to ensure that the staff is prepared when a disaster does occur. This is an area that could benefit from the commitment of additional resources Planning, training and coordination with other public and private entities continues to increase as additional requirements and regulations are created Budget and Service Volatility The transition to the 800 MI radio system and the Dakota Communications Center will have a significant impact on the 2007 budget and a lesser impact in subsequent years. This transition will require the purchase of new radios for all public safety personnel. These costs are reflected m the Capita] Improvements Budget Along with the radio costs are additional capital costs related to the building of the radio system and the building which houses the DCC. This increase is significant and also unavoidable. There are no viable options for providing dispatch services other than the DCC Rosemount has enjoyed an excellent relationship with Eagan's dispatch center for 10+ years and have been able to purchase these services at the lowest rate of any community within Dakota County. Although the increase m costs is a direct result of the transition to the DCC, it is unlikely that Rosemount's fees would continue at the same low level even if Eagan continued the operation of their PSAP It is reasonable to assume that at some point, the elected officials of Eagan would have expected Rosemount to pay a greater share of the dispatching costs to more accurately reflect the market rate and the costs to provide service to Rosemount. In the short term, Rosemount's costs are mcreasmg quite dramatically due to costs being shared equitably across all agencies utilizing the services of the DCC. However, m the long term the DCC should result in Rosemount and all Dakota County communities having more stable costs for dispatch services while benefiting from the economies of scale derived from the combining of dispatch centers. Most other operational budget items for the police department are stable. Operational expenses are quite consistent from year -to -year. Personnel costs do mcrease when an additional officer(s) is added m response to the growth in the community and the corresponding increase m reported crimes, traffic crashes and calls- for service s ROSEMOUNT POLICE DEPARTMENT M E M O R A N D U M Efficiencies and Operational Change Operational changes have not been changed significantly in the last year Procedures are reviewed on an on -going basis and changes are made when an improved process is found or when flaws are found in the existing procedures. In addition, the retirement of Lieutenant Kuhns has resulted m promotions within the Department. While the promotions create opportunities to take advantage of the newly promoted employees' ideas and energies, there is also a learning curve for the promoted employees to learn their new positions These personnel changes along with the planning and preparation for transition to the DCC and 800 MHz radio system have been the focus for the internal operations recently and as a result there have not been significant operational changes planned or implemented. New Initiatives An additional police officer position was not sought for approval in 2007 based on the assumption that the increase m dispatch costs related to the transition to the DCC would prevent the addition of staff to the department. However, additional staffing could be utilized to address some on -going concerns that have not been able to be better addressed. Drug Enforcement The department has had a desire to increase the amount of hours devoted to drug enforcement through the Dakota County Drug Task Force. Currently, two (2) officers work on drug cases as part of their regular shift duties as time permits In addition, an officer has been assigned temporarily to the Drug Task Force on a full -tune basis during the summer months when the school resource officer filled a patrol position. Although we have been successful m working a number of drug cases with this staffing method, it is not as effective as havmg an officer assigned on a full -time basis to the Task Force. If an additional police officer position were added in 2007, the planned use for the position would be to commit approximately fifty percent of an officer's time to assignment to the Drug Task Force This would be done on a six month contnmal schedule to allow the assigned officer an opportunity to concentrate on drug investigations. The other fifty percent of time will be dedicated to traffic enforcement as described next. Traffic Enforcement This is an area that continues to be a concern expressed by many residents and motorists m our community. In the first six months of 2006, there were approxnnately 233 driving complaints received by the dispatch center. There are also several complaints of speeding, loud mufflers or music, or other reckless driving conduct received through other channels, including calls to engineering and police office staff as well as Council Members. 4 ROSEMOUN 1 POLICE DEPARTMENT M E M O R A N D U M Although traffic enforcement is a task that every patrol officer is expected to perform as part of their regular duttes, it is only one of the tasks expected to be performed and may at tunes not be possible to perform because of other calls for service demand the officers' attention. An officer assigned to specifically focus on traffic issues can be expected to be more effective m addressing traffic complaints m the community. Because traffic enforcement would be the officer's primary duty, the officer would not be assigned to other calls for service except m the case of emergencies Future Forecast The continued growth of Rosemount will result m greater police challenges to meet the service demands of the residents and businesses More development will bring additional persons, traffic, miles of streets and areas to patrol. More specific issues are discussed below. The Department, along with all other public safety agencies in Dakota County, will be transitroning to the 800 MHz radio system and the consolidated dispatch center in 2007. This will require the purchase of new handheld and mobile radios, training on the new equipment and adapting to the procedures established for the new dispatch center Because we have contracted for dispatch services for several years and because the new center's procedures will focus on delivering high quality services to both internal and external users, this transition should occur relatively smoothly. Growth m the community will not only bring new residents to the city, but will undoubtedly bring a change in the types of comes expenenced. As Rosemount becomes more connected to the urban core cities and the metropolitan area, it is expected that criminals encountered by police officers will be more transient We have already experienced this change in recent years and more frequently have had mvesugations that have lead to suspects m Minneapolis, Saint Paul and numerous suburbs. This is a contrast to less than a decade ago when most crones in Rosemount were committed by either residents of Rosemount or our neighboring communities It is important that the Department leverages technology advancements to build on existing connections with other law enforcement agencies, while also participating in investigator organizations, comprised of investigators from throughout the metropolitan area, to share case investigation information in person. Rosemount is a relatively young community, but recent development has also expanded housing options for empty nesters and seniors. As this group of aging adults increases in number and age, we can anticipate that we will see an increase m the number of vulnerable adult cases reported. This will likely include physical abuse cases and financial crimes committed by caregivers including family members. ROSEMOUN 1 POLICE DEPARTMENT M E M O R A N D U M Although Rosemount will likely have an increased, senior population, the greatest growth will undoubtedly occur in the number of young families movmg into the community The number of young children and teenagers will undoubtedly increase and will have an impact on many city services and the expectations that citizens have in the delivery of those services. An increase m the population aged 15 25 has frequently resulted in an increase in criminal activity. Development of the community's retail and business areas will lead to increased traffic and the resulting motor vehicle crashes, congestion and complaints regarding violations of traffic laws Business related crime may include credit card fraud and forgery, shoplifting, thefts from vehicles in parking lots and possibly robberies of businesses and persons. Quantity Unit Cost Total Cost Trade -In Net Total Cost 4 $23,000 $92,000 $9000 $83,000 CITY OF ROSEMOUNT JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS 1 Department Police Dept. Account No 2 Go e Description and Quantity of Item Requested Indicate Date Desired Marked Squad Cars Four (4) New squad —first quarter of 2007. Replacement squads approximately July 1, 2007 Dependent on mileage on current squads, squads are taken out of service when mileage exceeds 100, 000 and/or when city mechanics recommend based upon mechanical problems. 3 Describe the necessity for and/or benefits or savings expected from this item Based upon the operation of the squad cars, dritiing beyond 100,000 miles begins to require additional maintenance and repairs Squads are purchased with extended warranties to reduce maintenance costs up to 100, 000 miles Squads also decline in performance at approximately this mileage. 4 If the item requires an increase in personal services for the activity, state the new nob title(s) contingent upon the item N/A 5 Indicate any expenses necessary to place this item m operation and whether these expenses are included in your budget request Other expenses include the installation of the emergency equipment in the squads. This expense is included as a separate CIP item 6 List any item which will be replaced by this purchase State recommendations for disposition of tins item. For example, trade -in, salvage, discard, etc Three squad cars will be replaced by this purchase. Each squad was purchased in 2004. The vehicles will be sold at auction when the su itchover to the new squads has been completed One marked squad is being added to the fleet to accommodate the addition of two patrol officers in 2006. Squads are shared by two officers and used approximatelyl0 5 hours daily ESTIMATED COSTS Quantity Unit Cost Total Cost Trade -In Net Total Cost 45 3 Descnbethe necessity forandior benefits or savmgs expected from this item The Dakota Communications Center es scheduled to become operational on approximately September 1 2007 All the existing radios need to be replaced because of the transition to the 800 MHz system The quantity listed provides a portable radio for every police officer and twelve additional units for use by reserves and community service officers Radios are needed in this quantity to be used for special events, e g Leprechaun Days and emergency incidents, e g wind storms, haz -mat spills i hen essentially all personnel are called for duty The quantity of mobiles is a reduction from our current inventory, mobiles will only be placed in marked squads while portable units will be used in unmarked vehicles by investigators and administrative personnel 4 If the item requires an increase in personal services for the activity, state the new job title(s) contingent upon the item NONE 5 Indicate any expenses necessary to place tlus item m operation and whether these expenses are included in your budget request There will be training associated with the transition to the new radio system and radio units. This cost will be covered through the t raining tine Item budget, scheduling training during on -duty time and by shift adjustments 6 List any Item which will be replaced by this purchase State recommendations for disposition of this item For example, trade-in, salvage, discard, etc Trade -in or resale value of current radio inventory S3550 Mobiles $144,750 $4750 5140,000 $2800 Portables $12,000 Other Accessories Total CITY OF ROSEMOUNT JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS 1 Department Police Dept AccouinNo 2 Give Descnption and Quantity of Item Requested Indicate Date Desired Radio Communications Upgrades 800A(Hz Portable Radios —36 Mobile Radios 9 Purchase and delivery by approximate /vJuly 1, 2007 3 Descnbethe necessity forandior benefits or savmgs expected from this item The Dakota Communications Center es scheduled to become operational on approximately September 1 2007 All the existing radios need to be replaced because of the transition to the 800 MHz system The quantity listed provides a portable radio for every police officer and twelve additional units for use by reserves and community service officers Radios are needed in this quantity to be used for special events, e g Leprechaun Days and emergency incidents, e g wind storms, haz -mat spills i hen essentially all personnel are called for duty The quantity of mobiles is a reduction from our current inventory, mobiles will only be placed in marked squads while portable units will be used in unmarked vehicles by investigators and administrative personnel 4 If the item requires an increase in personal services for the activity, state the new job title(s) contingent upon the item NONE 5 Indicate any expenses necessary to place tlus item m operation and whether these expenses are included in your budget request There will be training associated with the transition to the new radio system and radio units. This cost will be covered through the t raining tine Item budget, scheduling training during on -duty time and by shift adjustments 6 List any Item which will be replaced by this purchase State recommendations for disposition of this item For example, trade-in, salvage, discard, etc Trade -in or resale value of current radio inventory ESTIMATED COSTS Quantity Unit Cost Total Cost Trade -In Net Total Cost 11 3 Descnbe the necessity for and/or benefits or savings expected from this item Since 2000, newly hired officers have been issued a city/department owned handgun Prior to that tune, police officers purchased their own handgun There are now more than 50% of the officers carrying city owned handguns (12 of 21). Standardization offirearms allows for One caliber of ammunition department wide Department firearms instructors and armorer familiar with every handgun carried better ability to examine for need for repair, alterations, etc Interchangeable ammunition an magazines in the field if needed during extended gun battle 4 If the item requres an increase in personal services for the activity, state the new job title(s) contingent upon the item. NONE 5 Indicate any expenses necessary to place this item in operation and whether these expenses are included m your budget request Cost includes handguns for remaining nine officers and two extra handguns for issuance when repairs needed or handgun is used in deadly force situation. Also includes holster costs 6 List any item which will be replaced by this purchase State reconunendations for disposition of this item For example, trade -m, salvage, discard, etc N/A Replacing employee owned equipment $600 $6600 $0 $6600 CITY OF ROSEMOUNT JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS 1 Department Police Dept Account No 2 Give Descnption and Quantity of ltem Requested Indicate Date Desired Department Issued Hadgun Glock 40 calibre Model 22 or 23 Eleven (11) guns Second quarter 2007 3 Descnbe the necessity for and/or benefits or savings expected from this item Since 2000, newly hired officers have been issued a city/department owned handgun Prior to that tune, police officers purchased their own handgun There are now more than 50% of the officers carrying city owned handguns (12 of 21). Standardization offirearms allows for One caliber of ammunition department wide Department firearms instructors and armorer familiar with every handgun carried better ability to examine for need for repair, alterations, etc Interchangeable ammunition an magazines in the field if needed during extended gun battle 4 If the item requres an increase in personal services for the activity, state the new job title(s) contingent upon the item. NONE 5 Indicate any expenses necessary to place this item in operation and whether these expenses are included m your budget request Cost includes handguns for remaining nine officers and two extra handguns for issuance when repairs needed or handgun is used in deadly force situation. Also includes holster costs 6 List any item which will be replaced by this purchase State reconunendations for disposition of this item For example, trade -m, salvage, discard, etc N/A Replacing employee owned equipment ESTIMATED COSTS Quantity Unit Cost Total Cost Trade -In Net Total Cost I 3 Descnbe the necessity for and/or benefits or savings expected from this item In 2006, two police officers were added Both of these officers are assigned to patrol duties and will drive a marked squad Each squad is assigned to two officers and driven one 10.5 hour shift daily An additional squad is needed for use by the officers Without the addition ofa squad, the exutnrg squads n ill he driven more and will subsequently be replaced on a quicker rotation 4 If the item requires an increase in personal services for the activity, state the new Job title(s) contingent upon the item NONE 5 Indicate any expenses necessary to place this item in operation and whether these expenses are included in your budget request N/A 6 List any item which will be replaced by this purchase State recommendations for disposition of this item For example, trade -in, sah age, discard, etc N/A $15,000 $15,000 $0 $15,000 CITY OF ROSEMOUNT JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS I Department Police Dept Account No 2 Give Description and Quantity of Item Requested indicate Date Desired Emergency equipment for new squad First Ouarter of 2007 Includes Light bar, siren, controls, long rifle and rack, security cage, shotgun and rack first aid kit, oxygen tank, fire extinguisher, laptop computer and mount 3 Descnbe the necessity for and/or benefits or savings expected from this item In 2006, two police officers were added Both of these officers are assigned to patrol duties and will drive a marked squad Each squad is assigned to two officers and driven one 10.5 hour shift daily An additional squad is needed for use by the officers Without the addition ofa squad, the exutnrg squads n ill he driven more and will subsequently be replaced on a quicker rotation 4 If the item requires an increase in personal services for the activity, state the new Job title(s) contingent upon the item NONE 5 Indicate any expenses necessary to place this item in operation and whether these expenses are included in your budget request N/A 6 List any item which will be replaced by this purchase State recommendations for disposition of this item For example, trade -in, sah age, discard, etc N/A ESTIMATED COST Quantity Unit Cost Total Cost Trade -In Net Total Cost 3 3 Describe the necessity for and /or benefits or savings expected from this item The current radar units are approximately seven (7) years old There have been advancements in the last few years that have enhanced the capabilities of radar units to hack vehicle speeds in both directions (with and against the moving squad cars) This increased capability allows for additional traffic monitoring In addition the new units are upgradeable through software downloads while the present units are not 4, If the item requires an increase in personal services for the activity, state the n ew Job title(s) contingent upon the item. NONE 5 Indicate any expenses necessary to place this item in operation and whether these expenses are included in your budget request There will be minimal training required for implementation This is not listed as a separate line item because it will be incorporated into one of the training dates that are held 3 4 times annually for all department officers 6 List any item which will be replaced by this purchase State recommendations for dispositio n of this item For example, trade -in, salvage. discard, etc These are replacement units Half the units will be replaced in 2007 and the remainder in 2008. It is anticipated that there will be a small trade -in value for the existing units. $2500 $7500 $250 ea $6750 CITY OF ROSEMOUNT JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS 1 Departtnent Police Dept Account No 2 Give Description and Quantity of Item Requested Indicate Date Desired Radar Units Three First Quarter of2007 It is proposed to take the fends for this purchase from the DWI Forfeiture Fund The DWI f ids are mandated by Minnesota state statute to be use d for DWI enforcement, education or Training Because radars are used for traffic enforcement resulting in DTI7 arrests, it is an allowable use of the Junds 3 Describe the necessity for and /or benefits or savings expected from this item The current radar units are approximately seven (7) years old There have been advancements in the last few years that have enhanced the capabilities of radar units to hack vehicle speeds in both directions (with and against the moving squad cars) This increased capability allows for additional traffic monitoring In addition the new units are upgradeable through software downloads while the present units are not 4, If the item requires an increase in personal services for the activity, state the n ew Job title(s) contingent upon the item. NONE 5 Indicate any expenses necessary to place this item in operation and whether these expenses are included in your budget request There will be minimal training required for implementation This is not listed as a separate line item because it will be incorporated into one of the training dates that are held 3 4 times annually for all department officers 6 List any item which will be replaced by this purchase State recommendations for dispositio n of this item For example, trade -in, salvage. discard, etc These are replacement units Half the units will be replaced in 2007 and the remainder in 2008. It is anticipated that there will be a small trade -in value for the existing units. ESTIMATED COSTS Quantity Unit Cost Total Cost Trade -In Net Total Cost 3 3 Describe the necessity for and/or benefits or savings expected from this item The emergency equipment includes the hght bar, siren, other emergency lights and controls for the marked squads Current equipment is over 10 years old and repairs are increasing infrequency Replacement of equipment is scheduled to be done over a three year penod as the marked squads are replaced Replacement began in 2006 4 If the item requires an increase in personal services for the activity, state the new job title(s) contingent upon the item NONE 5 Indicate any expenses necessary to place this item m operation and whether these expenses are included in your budget request The costs includes the price of installation 6 List any item which will be replaced by this purchase. State recommendations for disposition of this item. For example, tradean, salvage, discard, etc The age of the items being replaced greatly limits any salvage or trade -in value The company which installs the emergency equipment will give a credit for any items that are useful for parts or resale. This amount will vary dependent upon condition of each unit's equipment $5000 $15,000 Unknown $15,000 CITY OF ROSEMOUNT JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS 1 Department Police Dept Account No 2. Give Descnpuon and Quantity of Item Requested Indicate Date Desired Emergency Equipment for Squads— Including Installation Costs Date Second quarter of2007 3 Describe the necessity for and/or benefits or savings expected from this item The emergency equipment includes the hght bar, siren, other emergency lights and controls for the marked squads Current equipment is over 10 years old and repairs are increasing infrequency Replacement of equipment is scheduled to be done over a three year penod as the marked squads are replaced Replacement began in 2006 4 If the item requires an increase in personal services for the activity, state the new job title(s) contingent upon the item NONE 5 Indicate any expenses necessary to place this item m operation and whether these expenses are included in your budget request The costs includes the price of installation 6 List any item which will be replaced by this purchase. State recommendations for disposition of this item. For example, tradean, salvage, discard, etc The age of the items being replaced greatly limits any salvage or trade -in value The company which installs the emergency equipment will give a credit for any items that are useful for parts or resale. This amount will vary dependent upon condition of each unit's equipment ESTIMATED COSTS ROSEMOUNT M E M O R A N D U M To: Jamie Verbrugge, City Adminstrator From: Andrew J. Brotzler, P E., City Engineer Rick Cook, Operations Superintendent Date: June 14, 2006 Re: 2007 Public Works Operation Budget GENERAL OVERVIEW OF SERVICES PUBLIC WORKS DEPARTMENT The Public Works Department maintains and operates the City's streets, infrastructure, equipment and buildings. This is done through four (4) maintenance funds and three (3) enterprise funds. A summary of the Depaitnient is as follows. The Public Works Department consists of the Engineering and Public Works 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 budgets administered by the Public Works Department are as follows: Government Buildings Fleet Maintenance Street Maintenance Parks Maintenance Water Operating Sewer Operating Storm Water Operating Separate Enterpnse Fund Budgets from those included here under the advisement of the utility Commission of the City of Rosemount. The Public Works Depail,nent 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 City Engineer C \Documents and Settings \Idv \Local Settings \Temporary Internet Files \OLKBD \061406 budgetrnemo.doc 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 Fire Stations 1 and 2 It also includes three (3) park shelters, St Joe's Church, Genz -Ryan building and the Family Resource Center Maintenance and operation of the Community Center Ice Arena is not included in this budget. Significant proposed additions to this budget include anticipated price increases for gas and electric utilities and $10,000 for the installation of a new fence at the fonner St. Joe's Church. 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 (10 cars, 3 trucks, 1 ATV) Fire Department (6 pickup trucks, 6 fire trucks) Parks and Recreation (1 truck, 1 van, 1 car, 1 ice resurfacer) Administration Community Development (4 cars, 1 truck, 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, 5 mowers, 13 trucks, 2 compactors, 1 roller, 1 ATV, 4 snow blowers) 4 large trailers Budgetary increases are proposed for motor fuels and equipment parts. Street Maintenance This budget provides for the maintenance and preservation of over 120 miles of City roads, over 30 miles of sidewalks and bike trails, and 12 City parking lots. Standard maintenance includes grading, graveling, patching, seating 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 Budgetary increases are proposed for chemical products to cover the anticipated cost for utilizing a 40/60 sand and salt mixture Also included is additional funding for contract snow removal at the former Genz -Ryan facility. Parks Maintenance This budget provides for the maintenance of over 300 acres of City park areas in 23 locations, including 11 parks with athletic fields and 10 parks with shelters or C. \Documents and Settings\jdv \Local Settings \Temporary Internet Flies \OLKBD \061406 budgetmemo doc pavilions. It includes the maintenance of all park trails and 10 other municipal areas, including City Hall, the Fire Station and the Community Center. It also Includes the installation of playground equipment, landscaping projects, ice rink construction and maintenance (4 hockey nnks, 6 pleasure rinks), and other miscellaneous construction activities. In 2007, the City will be assuming maintenance responsibilthes for Innisfree Park in Evermoor. The Meadows and Brockway parks will also be on -line in 2007. Budgetary increases are proposed for fertilizer and equipment parts to maintain the current service levels with these additional facilities. Also proposed is an additional $40,000 for re- paving of the Schwarz Park parking lot. REVENUE ENHANCEMENTS The only source of revenue that may be available to offset operating costs is fees collected through the Parks and Recreation Department for athletic field rentals The total annual amount of fees collected and projected fee revenue for 2007 will need to be coordinated with Parks and Recreation and Finance. BUDGET AND SERVICE VOLATILITY The main source of volatility related to the Public Works operating budget is the continued increase in fuel pnces This unknown, combined with the potential impact of a severe winter could significantly impact the operating budget for 2006/2007. In addition to this, the City is currently utilizing the old Dakota County Shop located on Biscayne Avenue for the storage of sand /salt and two to three pieces of equipment. This also requires the City to continue to rent a front -end loader for the winter season at an approximate cost of $12,000 Should the City not be able to continue to use this facility, there will be several impacts to the Public Works operation and budget. The first impact is the displacement of two to three pieces of equipment At this time, there is no space available in the City public works garages to house these pieces of equipment. The second impact, related to the agreement with Dakota County to have access to the County's new salt shed and loader, is the County's use of 100% salt which the City would have to follow, thereby increasing the budgetary cost for salt. EFFICIENCIES AND OPERATIONAL CHANGES As highlighted in the 2005 Public Works Annual Report, there are several new technologies that the Public Works Department is employing to strive towards improved efficiencies This includes the addition of GPS units, installation of laptops in Public Works vehicles for ready access to as -built information and the implementation of CarteGraph. The department is also adding PDA's for use by field staff during routine inspections to streamline the transfer of data from field to office and the establishment of better data for future budget projections. hn addition, staff is continuously working to schedule field activities and identify when and where staff is over /under allocated. C \Documents and Settings \idv \Local Settings \Temporary Internet Fdes \OLKBD \061406 budgetmemo doc NEW INITIATIVES None. FUTURE FORECAST With the anticipated future construction of an athletic complex, there is several equipment items proposed to be added in 2008. As previously discussed, it is our understanding the construction of an athletic complex will include the construction of on -site storage facilities for this equipment At this rime, all space in the City Public Works garage area is utilized and the addition of equipment will require additional facility space or the storage of equipment outdoors Should equipment need to be stored outdoors, security is a concern and may warrant the installation of a secured yard area at Public Works. Since the addition of a maintenance worker in 2004, the City has added the following: Approximately 15 miles of streets 24 miles of sanitary sewer 19 miles of water main 27 miles of storm sewer 2 wells 1 water tower 3 lift stations Moving forward, it will be necessary to add a staff person in 2007 to maintain existing service levels. Rick and I have discussed several scenarios that we will review with you at your earliest convenience. SUMMARY We look forward to the opportunity to review the proposed 2007 Public Works operation budget with you. C \Documents and Settings \idv\ Local Setungs Temporary Internet Files \OLKBD \061406 budgetmemo doc 2007 CITY BUDGET REPORT 4ROSEN OUNT MINNESOTA August 9, 2006 FUNDING REQUIREMENTS USES (INCLUDING FIRE STATION LEVY) 2006 2007 Adopted Proposed +1 Departments Budget Budget Difference Percentage Council Budget $167,900 $297,100 $129,200 76 95% Administration Budget 515,600 584,400 68,800 1334% Elections Budget 38,90D 61,000 22,100 5681% Finance Budget 308,90D 324,000 15,100 4 89% General Government Budget 361,700 372,100 10,400 2 88% Community Development Budget 885000 930,100 44,100 498% Police Budget 2,339,700 2,650,000 310,300 1326% Fire Budget 283,400 291500 8,200 2 89% Public Works operating Budgets Government Buildings Budget 390,500 450,400 59,900 15 34% Fleet Maintenance Budget 478,000 536500 58,500 1224% Street Maintenance Budget 1,153,700 1,180,400 26,700 231% Parks Maintenance Budget 532,800 601500 68,800 12 91% Park Rec Budget- General Operating 967,70D 1,039,100 71,400 7 38% Park Rec Budget Special Programs 91,50D 102,500 11,000 12 02% Total Operating Budgets General Fund $8,516,300 $9,420,800 $904,600 10.62% Building CIP Requirements 24,000 24,000 0 0 00% Street CIP Requirements 1,105000 1,050,000 (50,000) -4 55% Equipment CIP Requirements 250,900 333,000 62,100 32 72% Insurance Budget Requirements 260,000 260,000 0 0 00% Port Authonty Operating Levy 60500 0 (65000) -100 00% Bonded Indebtedness 1,599,360 1545,364 (53,996) -3 38% Bonded Indebtedness Fire Station Levy 154,308 142,527 (11,781) -7 63% Armory Anticipatory Levy (Value 7/18/06) 248,422 269,428 21,006 8 46% "395 000 ($2,185,821,500 x 00798 Water Enterprise Fund 1,258,400 1,887,300 628,900 49 98% Sewer Enterprise Fund 1,432,000 1,453,700 21,700 1 52% Storm Water Enterprise Fund 746,000 817,700 69,700 9 32% Arena Enterprise Fund 421,200 441,800 20,600 4 89% Total Funding Requirements 516,072,890 $17,645,619 $1572,729 9.78% NOTE Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies August 9, 2006 FUNDING REQUIREMENTS SOURCES (INCLUDING FIRE STATION LEVY) 2006 2007 Adopted Proposed Types Budget Budget Difference Percentage Internal Revenue Generated Licenses and Permits 859,700 651,100 (208,600) -24 26% Intergovernmental 525,000 555,300 30,300 5 77% Charges for Services 1,160,700 911,900 (248,800) -21 44% Fines Forfeits 90000 90,000 0 0 00% Recreational Fees 236,200 228000 (8,200) -3 47% Miscellaneous Revenues 152,000 182,500 30.500 20 07% Transfers In 3,500 3,500 0 0 00% Enterprise Revenues 3,859,600 4600500 740,900 19 20% Total Internal Revenues 6,886,700 7222,800 336,100 4 88% MVHC Cuts Made Later To Include in Levy 350 330 350,330 Levy Sources Special Levies 2,002,090 1,957,319 (44,771) -2 24% General Levy 7,534430 8,815,830 1,281,400 17 01% Total Levy $9,536,520 $10,773,149 $1,236,629 12.97% Loss of MVHC from State Funding $350,330 $350,330 $0 nla Total Revenue Sources $16,072,890 $17,645,619 $1,572,729 9,78% NOTE Special Levies Include (1)Bonded Indebtedness, (2)Fire Station Lery and (3)Armory Anticipatory Levies 2006 GENERAL PROPERTY TAX LEVY PAYABLE 2007 GENERAL LEVY GENERAL FUND $7,148,830 BUILDING CIP FUND $24,000 STREET CIP FUND $1,050,000 EQUIPMENT CIP FUND $333,000 INSURANCE FUND $260,000 PORT AUTHORITY OPERATING LEVY TOTAL GENERAL LEVY $8,815,830 BONDED INDEBTEDNESS G 0 MUNICIPAL BUILDING REFUNDING BONDS 1998A (ICE ARENA) (Authorized $258,957) $258,957 G 0 IMPROVEMENT BONDS 1999B (Authorized $19 533) $19,533 G 0 IMPROVEMENT BONDS 2001A (Authorized $119.604) G 0 PUBLIC FACILITY BONDS 2001C (Port Authority) (Authorized $168,504) $168,504 G 0 COMMUNITY CENTER REFUNDING BONDS 2001E (Authonzed $94,704) $94,704 G 0 IMPROVEMENT BONDS 2002A (Authorized $10,772) $10,772 G 0 PORT AUTHORITY BONDS 2002C (Authorized $258,650) $258,650 G 0 IMPROVEMENT BONDS 2003A (Authorized $86,354) (City Assumed Special Assessments) $86,354 G 0 CAPITAL IMPROVEMENT PLAN (CIP) BONDS 2005A (Authorized $210 737) $210,737 G.O EQUIPMENT CERTIFICATES 2005B (Authorized $349,198) $349,198 G 0 EQUIPMENT CERTIFICATES 2006A (Authorized $87,955) $87,955 G 0 IMPROVEMENT BONDS 2006B (Authorized $75,081) TOTAL BONDED INDEBTEDNESS $1,545,364 MARKET VALUE BASED REFERENDUM -1995 FIRE STATION LEVY G 0 FIRE STATION REFUNDING BONDS, 2005D (Authorized $142,527) TOTAL FIRE STATION LEVY PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($95.000 ($2,185,821,500 x 00798 (As of 7/18/06) TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS GRAND TOTAL 2006 PROPERTY TAX LEVY Last Updated 812/06 $142,527 $142,527 $269,428 $269,428 $10,773,149 Total Funding Requirements Less Internal Revenues Less Market Value Based Levy Fire Station (See Below) Equals Revenues Needed Add Back in State MVHC Cuts to Reflect Actual Levy Levy Certified by City to County Auditor County Auditor Adjustments (All Subtractions). Fiscal Disparities Distributuion Levy (Metro Area) Spread Levy Used to Compute Local Tax Rate Increase from Previous Year in Spread Levy Market Value Based Referendum Levy Fire Station Last Updated 8/2106 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) 2004 2005 2006 14,088,246 14,809,814 16,072,890 6,165,131 6,258,800 6,886,700 152,193 153,426 154,308 350,330 8,121,252 (Proposed) 2007 17,645,619 (4) 7,222,800 142,527 (3) 7,770,922 8,397,588 9,031,882 10,280,292 nla 350,330 350,330 8,397,588 9,382,212 10,630,622 844,509 804,414 770,288 770,288 (2) 7,276,743 (1) 7,593,174 (1) 8,611,924 (1) 9,860,334 4.35% 13.42% 14.50% 152,193 153,426 154,308 142,527 (3) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2007 Number Provided by Dakota County as of 8/10/05 (No 2007 Number Available at This Time) (4) Market Value Based Levy for Fire Station Based on $142,527 Levy Spread to Taxable Market Value on 12/31106 Last Update from Dakota County 7118/06 Shows the Levy of $142,5271$2,185,821,500 0652 per $1,000 as our Estimate (5) In 2004 Started Including the Water, Sewer, Storm Water Arena Enterprise Funds in These Figures ag §2 i 0 0 a\ EE sE EE SEE 8228 E, Page One August 9, 2006 2007 BUDGET WORKSHEETS GENERAL FUND REVENUES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Descnption Actual Actual Actual Budget Amount Budget 101 31010 00 Current Ad Valorem Taxes 101 31040 00 Fiscal Dtspanties 101 32110 00 101 32160 00 101 32161 00 101 32210 OD 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 DO 101 33416 00 101 33416 01 101 33416 02 101 33416 00 101 33423 00 101 33425 00 101 33620 00 101 33630 00 101 33630 00 Total Taxes (Tax) Alcoholic Beverage Licenses (L) Licenses to do Business (L) Licenses to do Bus Kennels (L) Building Permit Revenue (L) Mineral Extraction Permit (L) Electrical 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 (I) MSABC Armory Payments Delinquent Ad Valorem Taxes (I) Mobile Home Taxes (I) Gravel Taxes (I) Franchise Taxes Regular Fees (1) Franchise Taxes PEG Fees (I) Forfeited Tax Sale Apportionment (1) Federal Grants 8 Aids (I) Police Training Reimbursement (I) Post Board Training Reimb State Aid (Tied to PERA) MSA for Streets Maintenance (I) Ag Preserves Credit (I) Other State Grants Aids Other County Grants Aids (1) Police Services Levy -ISD #196 (I) DARE /Liaison Funding Total Intergovernmental (I) PAGE TOTALS $3,989,670 $3,949,105 $3,872,826 $5,069,242 771,998 844,509 804414 770,288 4,761,668 4,793,614 4,677,240 5,839,530 (350,330) 5,489,200 19,160 27,637 32,583 25,000 30 000 1,400 11,130 7,360 5,000 7,000 Garbage Haulers, Ped Licenses, etc 0 0 0 0 0 752,405 1,022 025 908,188 675,000 500 000 3,445 9 155 2,695 5,000 4 000 17,004 24 149 25,628 17,000 15 000 3,369 13,316 12,616 12,000 12,000 50,252 62,981 86,502 50,000 34,000 2,450 1,690 2,214 2,500 2,000 18,847 25,583 22,699 17,000 12,000 250 120 120 200 100 46,661 76,608 91 801 50,000 34 000 345 770 1700 1,000 1,000 Alarm Permits Fireworks Permits 915,589 1,295,164 1,194,106 859,700 651,100 91,000 91,000 91,000 91,000 91,000 Included in Debt Levy Figure 91,000 64,117 10,768 14,055 107,540 9,747 2,183 0 102,805 29,445 2,538 16,353 17,328 45,767 99,711 10,792 9,594 121,479 10,570 0 0 112,834 28,300 0 16,952 13,810 46,936 79,338 8 675 29 690 131,522 12,506 0 60,000 122,641 26,715 1,197 17,668 15,000 48,512 60,000 10,000 10,000 120,000 10,000 0 0 7,000 7,000 110,000 120,000 29,000 0 13,000 15,000 50,000 60,000 10,000 15,000 125,000 12,000 0 0 127,000 26,000 0 13,000 15,000 61 300 61,300 513,846 561 978 644,485 525,000 555,300 6,190,903 6,650 756 6,515,811 6,873 900 8,004,900 $6,376,542 From County 770,288 From County 7,148,830 Total Property Tax Levy for Fund 101 (350,330) State Cuts in MVHC Permanent''» 6,798,500 Actual Property Taxes to Receive From County From County From County From Cable Company From Cable Company From County From State From State From State From State -PERA Aid Safe Sober Dakota County Recycling Funds From ISD #196 Page Two August 9, 2006 2007 BUDGET WORKSHEETS GENERAL FUND REVENUES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 34103 00 Zoning Subdivision Fees (C) 33,560 70,824 72,304 50,000 50 000 101 34104 00 Plan Checking Fees (C) 413 876 444,950 405,606 368,700 300,000 65% of Building Permit Fees" 101 34105 00 Sales of Maps Publications (C) 2,816 2,311 2,632 3,000 2,500 Maps Spec Books 101 34106 00 Deputy Registrar Fees (C) 48 438 49,392 52,406 50,000 50 000 101 34107 00 Assessment Searches (C) 20 0 0 100 0 101 34108 00 Admin Fees Other Funds (C) 199,254 337,753 341,127 125 000 101 34108 01 Applicable Funds Except Const 25,000 25,000 101 34108 02 Construction Funds 225,000 100,000 101 34109 00 Other Charges for Service (C) 8,127 9,853 11,370 5,000 5,000 101 34110 00 Service Chg on Returned Chks (C) 345 240 210 200 200 101 34112 00 Uthty Permit Application Fee (C) 450 1,525 575 1,000 500 101 34150 00 User Fees SKB 0 98,092 255,923 300,000 250,000 SKB Fees from New Cells C D 101 34151 00 User Fees!Hosl Agreements SKB 0 25,000 25,000 25 000 25 000 Landscaping Agreement (Yr 4 of 10) 101 34160 00 National Guard Maint Fees (C) 45,808 46 362 46,715 46,000 46 000 101 34160 00 Shared Space Rental Agreement 16,000 101 34160 00 Building Maintenance Contract 30 000 101 34201 00 Special Police Seances (C) 23,171 22,962 18,285 24,000 20,000 Contractual O/T for Officers 101 34202 00 Fire Services Burning Permits (C) 5,500 1,168 435 0 0 No Longer Charge for Permits 101 34203 OD Accident Reports (C) 1,019 778 266 500 500 101 34204 00 Day Care Inspection Fees (C) 490 250 658 200 200 101 34206 00 Other Police Services (C) 121 30 1,645 0 0 101 34207 00 Other Fire Protection Services (C) 10,528 13,583 11,005 12 000 101 34207 01 U of M Fire Contract 5,500 5,500 101 34207 02 Coates Fire Contract 3,500 3,500 101 34207 03 Other Billed Fire Calls 3,000 3,000 101 34301 00 Street Sidewalk Curb Repairs (C) 0 10,973 0 0 0 101 34303 00 Mow Weeds (C) 191 3,844 1,615 0 0 101 34306 00 Other Highway Street Rev (C) 37,882 74,361 27,676 20,000 20,000 Street Light Bills Developers 101 34407 00 City Share of Metro SAC Chgs (C) 5,303 7,962 8,007 5,000 5 000 Total Charges for Services (C) 836,900 1,222,213 1,283,660 1,160,700 911,900 101 35101 OD Court Fines (F) 89,752 96,902 87,888 90,000 90,000 From County Total Fines Forfeits (F) 89,752 96,902 87,886 90,000 90,000 101 34720 00 Park Reservations (R) 3,390 4,170 2,455 3,200 1,500 Loss of Church 101 34721 00 Softball Revenues (R) 55,296 59,246 62,931 57,000 60 000 101 34722 00 Volleyball Revenues (R) 1,480 1,445 1,120 1,500 1,500 101 34724 00 Tennis Revenues (R) 1,211 1,283 1,659 1,300 1,300 101 34725 00 Tiny Tot Revenues (R) 21,551 20,029 20,630 21,000 21,000 101 34726 00 Rosettes Revenues (R) 1,447 1 463 748 1,000 1 200 101 34727 00 Field Tnp Revenues (R) 2,692 8,725 10,777 3,000 4 000 101 34728 00 Broomball Revenues (R) 0 0 0 0 0 101 3472900 Skating Lesson Revenues (R) 217 244 299 300 300 101 3473D 00 Run for the Gold Revenues (R) 2,960 3,250 3,636 3,000 3,000 101 34732 00 Adult Basketball Revenues (R) 1,935 1,700 1,326 1,900 1,900 101 34733 00 Other Programs Revenues (R) 8,719 10 831 14,310 6,000 8,000 101 34735 00 Camps Revenues (R) 3,888 9 442 13,314 4,000 4 000 101 34736 00 7-Ball Lessons (R) 3,654 4 266 4,675 5 000 4,300 101 34737 OD Leprechaun Days Revenues (R) 0 4 970 0 0 0 10 34790 00 Other Recreation Revenues (R) 6,351 0 0 0 0 101 38080 00 Banquet Room Fees (R) 58,641 56,244 58,281 58,000 58 000 101 38081 00 Auditorium Fees (R) 11,563 9 085 7,308 12,000 12,000 101 38082 00 Gymnasium Fees (R) 20,321 20,890 24,363 21,000 21,000 101 38086 00 Classroom Fees (R) 30,037 21,691 9,381 28,000 16,000 Loss of EC FE 101 38096 00 Liquor Provider Fees (R) 1,050 1,170 1,050 1,500 1,500 101 38097 00 AN Rental Fees (R) 1,706 1,342 1,587 1,500 1,500 101 38154 00 Teen Night Revenues (R) 5,670 6,222 8,092 6,000 6,000 Total Recreation Fees (R) 243,777 247,706 247,942 236,200 228,000 PAGE TOTALS 1,170,430 1,566,821 1,619,489 1,486,900 1,229,900 Page Three August 9, 2006 2007 BUDGET WORKSHEETS GENERAL FUND REVENUES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 36101 00 Principal Special Assessments (M) 23 655 41,114 14,063 20,000 20,000 From County 101 Funded Projects 101 36102 00 Penalties Interest S/A (M) 82 69 101 0 0 From County 101 36210 00 Interest Earnings Investments (M) 100,891 147 009 176,951 120,000 150,000 101 36214 00 Net Change In FV- Investments (M) 6,432 (6,326) (34,218) 0 0 Annual Market Value Changes 101 35215 00 Interest Earnings (M) 1,434 1 226 722 1,500 1,000 From Checking Account 101 36220 00 Rents Royalties (M) 4,394 5,383 5,712 5,000 5,500 US West Antenna Rent 101 36230 00 Contribution'Donatlons (M) 77,884 44,633 33,765 0 0 101 36260 00 Other Revenue (M) 1,570 18,734 4,531 2,000 2 000 101 36265 00 Use of Reserve Funds (M) 0 0 0 0 0 101 38090 00 City Concessions (M) 3,506 3,662 4,574 3,500 4,000 Total Misc Revenues (M) 219,648 255,502 206,201 152,000 182 500 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) 0 0 0 0 0 Funds Returned from Project Total Transfers In (T) 3,500 3 500 3,500 3,500 3,500 PAGE TOTALS $223348 $259,002 $209,701 $155,500 $186,000 DEPARTMENT TOTALS 57,584,681 $8,476,579 $6,345,001 58,516,300 $9,420,600 INTERNAL REVENUES $2, 823, 013$3,682,965$3667761$3,027,100 $2,622,300 Grand Total Less Ad Valorem Fiscal Disparrties Page Four August 9, 2006 2007 BUDGET WORKSHEETS GENERAL FUND REVENUES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 101 34108 00 General Fund Admin Fees $25,000 $26000 $25,000 $25,000 $26000 101 34108 01 Fund 201 6,000 101 34108 02 Fund 202 2,500 101 34108 03 Fund 203 2,500 101 34108 04 Fund 206 2,500 101 34108 05 Fund 207 2,500 101 34108 06 Fund605 1,000 101 34108 07 Fund 606 1 000 101 34108 08 Fund 607 1 000 101 34108 09 Fund 650 6 000 Adman Fees Breakdown Totals $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 Comments POLICY DEVELOPMENT GENERAL OPERATIONS CITY COUNCIL The City Council is responsible for estabhshmg the mission and vision for the City of Rosemount. The Council also estabhshes community goals and supervises the activities of the City Administrator. Provides for the legislative and policy- making activities for all of mumcipal 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 pohcy making process by establishing, appointing and managing advisory comnussnons, ad hoc committees and community groups. Provides funding for general government protects and needs such as. City Newsletter Chamber of Commerce Directory Key Financial Strategies Page One August 9, 2006 Account 101 41110 103 00 101 41110 01 225 00 2007 BUDGET WORKSHEETS COUNCIL Descnphon Salaries Benefits Landscaping Materials 101 41110 01 307 00 Management Fees 101 41110 01 307 01 Newsletter 101 4111D 01 307 02 Chamber of Commerce Directory 101 41110 01 307 03 Community Survey 101 41110 01 310 00 Temporary Service Fees 101 41110 01 319 00 Other Professional Services 101 41110 01 319 01 Education Reimbursement 101 41110 01 319 02 HIPP Initiatives 101 41110 01 319 03 Community Forums 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 NDCC Dues 101 41110 01 433 04 NLC Dues 101 41110 01 433 05 Miscellaneous Dues 101 41110 01 435 DO Books Pamphlets 101 41110 01 437 00 Conferences Seminars 101 41110 01 437 01 Registration Hote! -LMC Cont 101 41110 01 437 02 Registration Hotel -NLC Con/ 101 41110 01 437 03 Miscellaneous Conferences 101 41110 01 439 00 Other Miscellaneous Charges 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget All Salary Costs Inclusive of $26,820 $25,695 $26,850 526,400 $33,900 Salary, Taxes, PERA Benefits 0 24,370 41220 25,000 25,000 SKB Landscaping Agreement 21,013 0 6,402 0 180 128 846 1,025 14,445 10,334 4,407 519 918 0 119 40 2,602 557 1,835 582 15,005 38 0 0 5,695 2,483 7,071 1,000 18,000 0 1,925 0 0 0 263,898 3,292 12,630 1,065 16,500 5,034 11,114 119,604 13,000 108,899 7,549 8,000 1,000 9,000 0 7,000 5,000 10,000 0 0 27,000 1,100 20,000 7,000 5,000 0 400 600 263 1,000 1,000 Newspaper Ads Open Houses 184 894 1,500 1,500 459 700 700 11,203 4,952 1,086 1,273 0 0 0 1,421 1,669 5,068 12,500 5 ,000 600 1,300 300 100 2,000 4,000 2,000 0 0 0 40,000 12,500 5,500 600 1,400 300 2,000 4,000 2,000 Comments 48 100 0 12,000 1 000 2,200 20 300 100 8 000 0 0 0 40,000 Yearly Contingencies 101 41110 01 510 00 Land Purchases 101 41110 01 525 00 Building Structure Purchases 101 41110 01 598 D0 Council Designated 101 41110 01 599 00 Employee Recognition Costs 101 41110 01 599 01 Employee Recognition Costs 2,500 2 500 101 41110 01 599 02 Vending Machine Costs 3,000 3,000 Offset by Revenue from Machines 101 49300 01 710 00 Transfers 0 0 0 0 100,000 Arena Operating Subsidy PAGE TOTALS $95,590 $365,634 $392,134 $167,900 $297,100 DEPARTMENT TOTALS $95,590 $365,634 $392,134 $167,900 $297,100 ADMINISTRATION DEPARTMENT The Admuustration Department is responsible for the overall management of all depa rents within the City and for assuring that depainnental activities are consistent with the goals estabhshed by the City Council. GENERAL ADMINISTRATION RECEPTION Provides overall management admuustration and coordination of activities m all City departments including Community Development, Finance, Fire, Pohce, Pubhc 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 pohcies 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 the preparation and maintenance of official records for the City including Council, Port Authority and Commission minutes. Prepares and assures pubhcation and posting of official notices Provides pubhc information on ordinances, contracts and policies. Administers the collection, storage and dissemination of data. Provides General Government /City Hall reception admuustranon. LICENSING PERSONNEL ADMINISTRATION STAFFING ADMINISTRATION DEPARTMENT- Page 2 Provides for the issuance and renewal of the following licenses: Liquor and beer Peddlers, sohcitors and transient merchants Gambling permits Kennel licenses Block party street closures Provides human resources services to improve the recruitment and retention of City employees. Administers the City's personnel policies and procedures, assures comphance with union contract language, as well as state and federal labor regulations Adimiusters employee compensation 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 pubhcauons directed to business sectors outside of the community for economic development Assists in preparing messages and collateral matenal for internal communications. For 2007, the department will consist of five positions: City Admuustrator Assistant City Administrator Commumcanons Coordinator City Clerk Recepuomst Page One August 9, 2006 Account 2007 BUDGET WORKSHEETS ADMINISTRATION Description 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget All Salary Costs Incuswe of 101 41320 101 00 Salaries 8 Benefits 5266539 $322 450 $347,771 $367,000 $450,700 Salary, Taxes PERA Benefits 101 41320 102 00 Full-Time Overtime 12 2,738 67 2,000 2,000 101 41320 01 209 00 Other Office Supplies 550 998 669 300 B00 Miscellaneous Purchases 101 41320 01 306 00 Personnel Testing 8 Recruitment 12,795 650 0 0 0 101 41320 01 319 00 Other Professional Services 3,624 16,279 4,11 0 2,000 Updating KFS Models 101 41320 01 321 00 Telephone Costs 193 1,194 1,347 800 1,000 Administration Cell Phones 101 41320 01 331 00 Travel Expense 407 1 600 101 41320 01 331 01 NLC Conference 298 669 800 B00 101 41320 01 331 02 ICMA Conference 429 0 800 B00 101 41320 01 331 03 Miscellaneous Travel 292 51 0 0 101 41320 01 353 00 Ordinance Publication 0 2,815 0 0 0 Moved to General Government 101 41320 01 394 00 P C Software Purchases 1,600 0 0 0 0 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 01433 04 IIMC Dues 101 41320 01 433 05 IPMA Dues 101 41320 01 433 06 ICMA Dues 101 41320 01 433 07 APM' Dues 101 41320 01 435 00 Books Pamphlets 101 41320 01 437 00 Conferences Seminars 2,555 101 41320 01 437 01 Registration Hotel LMC 47 101 41320 01 437 02 Registration Hotel MCMA 44 101 41320 01 437 03 Personnel Conferences 12 101 41320 01 437 04 Staff (1) Each 101 41320 01437 05 Miscellaneous Seminars 1,16 101 41320 01 437 06 Registration Hotel ICMA 1,D2 101 41320 01 437 07 Advanced Clerks School 19 101 41320 01 437 08 Registration 8 Hotel NLC 101 41320 01 437 09 Miscellaneous Meetings 0 101 41320 01 439 00 Other Miscellaneous Charges 0 5 101 41320 01 580 00 Other Equipment Purchases 0 101 41320 31 305 D0 Medical 8 Dental Fees 0 101 41320 31 315 00 Special Programs 0 101 41320 31 315 01 Employee Training 3,50 101 41320 31 315 02 HIPP Iniliatwes 101 41320 31 319 00 Other Professional Services 0 101 41320 31 319 01 Labor Consultant 101 41320 31 319 02 Labor Legal Issues 101 41320 31 319 03 CHESS Consultant 101 41320 31 319 04 COBRA Consultant 101 41320 31 319 05 FIexNEBA Administrative Fees 101 41320 31 319 06 SVJWC Co- Operative Dues 101 41320 31 331 00 Travel Expense 0 101 41320 31 341 00 Employment Advertisng 1,398 85 101 41320 31 433 00 Dues Subscriptions 0 101 41320 31433 01 PRIMA Dues 101 41320 31 433 02 IPMA Dues 101 41320 31 433 03 MPELRA Dues 101 41320 31 435 00 Books Pamphlets 0 101 41320 31 437 00 Conferences Seminars 0 101 41320 31 437 01 MPELRA State Conference 101 41320 31 437 02 Personnel Seminars 101 41320 31 437 03 Safety, Supervisor, Policy 101 41320 41 315 00 Special Programs 0 101 41320 41 319 00 Other Processional Services 0 101 41320 41 328 00 Cable Supply Costs 0 101 41320 41 329 00 Other Communication Costs 0 101 41320 41 329 01 Cable JPA Payment General City 101 41320 41 329 02 Video Streaming Council Meetings 101 41320 41 329 03 Bulk E -Mail System 101 41320 41 331 00 Travel Expenses 0 101 41320 41 433 00 Dues Subscriptions 101 41320 41 437 00 Conferences Seminars 490 2 200 9 180 200 200 5 50 100 100 3 35 150 150 10 120 150 150 39 0 0 0 74 1,420 1,500 1,500 16 0 100 100 386 1,28 915 1,000 1000 0 0 101 41320 41 580 00 Other Equipment Purchases 0 PAGE TOTALS $290 550 $358,61 DEPARTMENT TOTALS $290,550 $358,61 101 41320 41 315 00 General Marketing, Special Mailings, Changeover of City Signage 0 500 500 491 800 800 0 0 0 250 200 200 2,287 2,300 2,300 1,080 2,500 2,500 0 200 200 1635 2,000 2,500 72 0 0 20 0 100 266 900 900 0 0 300 Empbyee Drug Testing 4,498 7 000 15,000 5,000 8,200 2,000 4,302 4,500 2,000 608 900 900 5,400 5 400 5,400 0 1,000 1,000 4,172 3,000 3,300 0 500 500 520 400 400 4,852 8,000 8,000 Vacancies 39,936 40,00 14,920 5,00 5,39 90 32,49 34,00 10 11 2 60 $483,52 $483,52 310 45 160 25 300 20 233 50 300 50 255 40 315 50 20 20 40 90 $515,60 $515,60 500 400 500 34,000 8,400 4,200 9,000 13,100 Comments Moved Below to FUR Moved Below to H!R Additional Training for 2006 Wellness Health Management 1,100 450 Risk Management 250 400 500 Books Training Materials 1 400 25,000 See Below for Descnpton 5,000 Consultants Cable TV 3,000 Cable Supplies Software 46 600 200 200 MAGC 400 Technical Courses 900 5584,400 5584,400 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 STAFFING ELECTIONS Provides for the necessary supplies and minor equipment necessary to conduct the elections. CONTRACTED SERVICES Provides for the maintenance agreement for service and repair of the ballot counters. Provides for continued use of polling locations Provides for the appointment and training of election judges to work at the City's six precinct polling places Page One 2007 BUDGET WORKSHEETS ELECTIONS August 9, 2006 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 41410 01 103 00 Part-Time Salaries $0 $27,500 $0 $29,000 $15,000 Electron Judges 101 41410 01 203 00 Printed Forms Paper 0 445 0 500 300 Ballots Programming 101 41410 01 206 00 Miscellaneous Supplies 0 371 0 400 300 101 41410 01 219 00 Other Operating Supplies 0 809 0 900 400 Food for Election Judges 101 41410 01 242 00 Minor Equipment 0 2,839 105 2 900 1,500 Booths Signs 101 41410 01 319 00 Other Professional Services 0 0 0 0 0 101 41410 01 321 00 Telephone Costs 0 300 303 400 400 101 41410 01 351 00 Legal Notices Publishing 0 18 0 300 100 Election Publications 101 41410 01 409 00 Other Contracted Repair Mamt 0 1,349 0 1,500 1,500 Maintenance for Accu Vote 101 41410 01 412 00 Building Rental 0 2,800 0 3,000 1,500 Possible Rent for Locations 101 41410 01 439 00 Other Miscellaneous Charges 0 0 0 0 0 101 41410 01 580 00 Other Equipment Purchases 0 0 54,000 0 40 000 PAGE TOTALS $0 $36,430 $54,408 $36,900 $61,000 DEPARTMENT TOTALS $0 $36,430 $54,408 $36,900 $61,000 The Finance Department is responsible to work with all departments of the City, especially the Admuustration Department, to ensure that all activities of the City are conducted in a fiscally responsible manner GENERAL ADMINISTRATIVE Provides for the fiscal management, processmg 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. DATA PROCESSING TREASURY FINANCE DEPARTMENT 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 m -house consultant providing technical assistance when possible, and if not possible, coordmating the procurement of outside technical assistance when needed Fund Management Collects and deposits revenues and manages the mvestment 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 Mamtams records for property and worker's comp insurance requirements, handles all claims and prepares all documents for yearly renewals of policies. PAYROLL Receives employee time sheets, coordinates insurance, pay rates and other apphcable payroll mformanon with personnel, prepares payroll checks, prepares all Federal and State required reports, prepares all employee withheld and employer promised obligation funds for disbursement to apphcable organizanons, and prepares all reports as needed, both mternally 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 FINANCE DEPARTMENT- Page 2 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 providmg 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 /seances. Receipts monies on a daily basis and deposits those monies daily in designated banking insututions. Maintains a system that allows for the appropnate reporting of all monies collected within the accounting system. DEPUTY REGISTRAR FIXED ASSETS SPECIAL ASSESSMENTS STAFFING FINANCE DEPARTMENT- Page 3 Maintains an office that handles vehicle hcense renewals, vehicle license transfers and DNR hcensmg transactions, consistent with the requirements of the State Responsible for the maintenance of the fixed asset system. This includes all additions, deletions and changes m fixed assets for the City Also responsible for the corresponding reporting requirements that go along with the system, including year- end information, insurance renewal information and individual department information Responsible for the maintenance of the special assessments records 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 Must work with Dakota County to ensure that all assessment balances are correct In 2007, the department will consist of seven positions. Finance Director Accounting Supervisor Payroll Clerk Accounts Payable Clerk Utility Billing /Deputy Registrar Clerks (2 Full-Time and 1 Part-Time) Page One August 9, 2006 2007 BUDGET WORKSHEETS FINANCE 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41520 101 00 Salanes Benefits $193,071 $191,982 $219,263 $230,900 $246,400 Salary, Taxes, PERA Benefits 101 41520 102 00 Full -Time Overtime 2,211 2,260 1 484 3 000 3,000 101 41520 01 319 00 Other Professional Services 10,000 0 0 0 0 RA Now Done Internally 101 41520 01 331 00 Travel Expense 135 1,500 101 41520 01 331 01 Finance Director 905 997 1,000 1,200 National Conventior Misc 101 41520 01 331 02 Staff 5 16 500 300 101 41520 01 341 00 Employment Advertising 0 9B8 0 0 0 101 41520 01 391 00 P C Maintenance 46,795 51 200 101 41520 01 391 01 Civic Systems Applications Support 4,376 4,595 5,000 5,000 101 41520 01 391 02 Citnx Maintenance Renewal 0 0 0 1,200 101 41520 01 391 03 lncode Software Maintenance 5,643 5,858 6,000 6,000 101 41520 01 391 04 General Network Support 28,800 30,000 30,000 30,000 300 Hours of Support Time 101 41520 01 391 05 Motor Vehicle S!W Maint 306 0 500 500 101 41520 01 391 06 Fixed Asset Main! Contract 805 1,211 1,000 1,200 101 41520 01 391 07 Miscellaneous P C Repairs 575 1350 3,500 2,800 101 41520 01 391 08 Anti -Virus Software Renewal 426 4 205 4 000 4 500 101 41520 01 392 00 P C Accessories Supplies 1,817 1,042 3,699 3 000 3,000 City System Supplies 101 41520 01 393 00 P C Hardware Purchases 138 497 1,198 2,000 2 000 101 41520 01 394 00 P C Software Purchases 0 793 11 000 101 41520 01 394 01 Annual Microsoft Office Payment 0 11,200 10,000 Annual Payment Thru 2011 101 41520 01 394 02 Miscellaneous S!W Purchases 0 1,000 1 000 101 41520 01 409 00 Other Contracted R M 50 50 60 300 300 Cash Register Repairs/Maint 101 41520 01 433 00 Dues Subscriptions 265 700 101 41520 01 433 01 MDRA Annual Fees 0 0 100 0 101 41520 01 433 02 MnGFOA- Finance Director 40 40 50 50 101 41520 01 433 03 MnGFOA Staff 160 200 200 200 101 41520 01 433 04 GFOA Finance Director &Asst 160 295 350 350 101 41520 01 433 05 Magazine Subscriptions 0 0 100 100 101 41520 01 435 00 Books Pamphlets 0 200 101 41520 01 435 01 Accounting Related Books 0 127 100 100 101 41520 01 435 02 Finance Related Books 19 0 100 100 101 41520 01 437 00 Conferences Seminars 1,159 4,200 101 41520 01 437 01 MORA Conference (For 2) 0 0 300 0 101 41520 01 437 02 MnGFOA Annual Conf (HD Asst) 550 528 1 000 1,000 101 41520 01 437 D3 GFOA National Conf (F /D) 1,058 986 1 500 1,500 101 41520 01 437 04 Staff Development 0 0 1 000 1,000 101 41520 01 437 05 Miscellaneous Seminars 567 922 700 700 101 41520 01 439 00 Other Miscellaneous Charges 273 344 191 500 500 Contigencies 101 41520 01 570 00 Office Equipment Furnishings 0 0 0 0 0 PAGE TOTALS $255,914 $242,352 $277,222 $308,900 $324,000 DEPARTMENT TOTALS $255,914 3242352 $277,222 $308,900 $324,000 DUPLICATING COPYING Provides for maintenance agreements and expenses to operate copy machines at all City facilities. Also provides for microfilming laserfiche 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 depai itents. EQUIPMENT PARTS LEGAL FEES GENERAL GOVERNMENT 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 Annual Financial Report Also provides for other services as required of the City's financial and accounting consultants Provides for general legal and special legal services provided by the City Attorney or other law firms utilized by the City for such services. 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 rental 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, Coinrnumty Center and the Police Department Page One August 9 2006 Account Descnption 2007 BUDGET WORKSHEETS GENERAL GOVERNMENT 101 41810 01 202 00 Duplicating Copying 101 41810 01 202 01 Records Retention 101 41810 01 202 C2 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 Checks 101 41810 01 203 05 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 NP 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 State Purchasing Program 101 41810 01 242 02 Fax Machine Maint Agreement Auditing Accounting Services Audit General Consulting Fees Dakota County Assessment Fees Dak Cty Truth In Taxation Costs Pnnting of Budget Books 101 41810 01 301 05 101 41810 01 303 00 Engineering Fees 101 41810 01 304 00 Legal Fees 101 41810 01 319 DO 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 (Spnngsteds) 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 320 00 Credit Card Activity Fees 101 41810 01 321 00 Telephone Costs 101 41810 01 321 01 General Phone Costs 101 41810 01 321 02 E -Mail Server Costs 101 41810 01 321 03 Web Server Costs 101 41810 01 322 00 Postage Costs 101 41810 01 328 00 Cable Supply Costs 101 41810 01 329 00 Otner Communication 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 418 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 393 00 P C Hardware Purchases 101 41810 01 301 00 101 41810 01 301 01 101 41810 01 301 02 101 41810 01 301 03 101 41810 01 301 04 101 41810 01 433 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 101 41810 01 598 00 Emergency Operations Cost PAGE TOTALS DEPARTMENT TOTALS 2005 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $10,126 $22,000 7,766 9,624 7,000 7,000 9,419 9,487 15,000 15,000 7,480 56 9,500 4,692 5,596 2,700 3 300 690 0 1,200 1,200 1,461 0 1,500 1,500 1,356 355 3,000 3,000 0 0 0 0 0 3,458 0 500 Business Cards, etc 2,255 4,200 15,525 3 78 48,510 963 773 1,500 1,500 796 2,355 900 900 649 0 800 800 0 845 600 600 0 0 400 400 17,057 19,079 17,000 403 532 800 0 0 350 350 0 0 250 250 41,864 57,226 60,000 1,653 1,941 5 000 1,590 1,579 3 000 529 243 2 000 5,500 0 0 0 3,828 0 0 42,552 53,749 50,459 75,000 9,105 505 540 2,300 1,647 0 1,500 0 8,453 5,000 29,750 4,050 5,000 6,223 6,075 6,000 10,350 6,500 24,000 862 1,711 2,300 3,000 59,672 979 59,547 62,821 65,000 0 0 0 0 285 0 18,678 15,837 20,038 16 000 0 153 0 0 30,538 30,538 113 744 75 800 3,739 3,478 3,806 3,400 0 156 1,000 507 428 1,200 5,250 1,500 3,750 6,000 0 22,000 0 0 90 220 120 0 0 40 473 500 0 0 19,853 0 $273,123 $355,671 $333,097 $361,700 $372,100 85,000 0 0 18,000 General Office Supplies 800 City Hall Equipment Repairs 600 Yearly Fees for Program 80,000 70,000 Increased GASB Requirements 5,000 3,000 2,000 0 Moved to Administration 0 75,000 General City Legal Fees 39,600 2,300 Moved from Adminstration 1,500 Moved from Administration 5,000 Fees Paid to Spnngsted 5,000 Fees Paid to Sprngsted (Bonds) 6 000 Fees Paid to Spnngsted 20,000 Fees Paid to Spnngsted 5,000 Add'I Services at City Hall 65 000 Monthly Billings Merged with 01 in 2006 Merged with 01 in 2006 16,000 0 Moved to Administration 0 Moved to Administration 800 General Costs 5,600 3,400 All Departments 1,000 Btlfing from Dakota County 1,200 State Mandated Publications 6,000 Docuware Service Hours 0 Docuware Scanners 300 Newspapers 500 Direct Deposit Filing Fees 0 Sales Tax Audit 18,549 14,259 29 824 23,000 23,000 Copy Machine Leases All Bldgs 0 1,862 0 0 0 Mercury Spill (Fax Machine Postage Meter) $273,123 $355,871 $333,097 $361,700 $372,100 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 m a fiscally responsible manner. The Building Inspection and Planning Divisions play a key role m 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 m 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, hfe safety and environmental conditions and to assure local comphance 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 appropnate junsdicuons concerning building activities. CODE ENFORCEMENT PLANNING COMMUNITY DEVELOPMENT— Page 2 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 reviewing proposed developments for comphance with the zoning and subdivision ordinance and coordmanng 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 comphance 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, muting, 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 gradmg and building permits ECONOMIC DEVELOPMENT COMMUNITY DEVELOPMENT— Page 3 Is responsible for marketing development opportunities within the City and creating an interest m Rosemount Is responsible for creating and coordinating the establishment of tax increment districts and other economic incentives Is responsible for coordmatmg the state, county and local approval processes to insure the proponent's requests are met in a timely fashion. Is responsible for staffing the malonty of functions of the Rosemount Port Authority. Is involved with state and regional economic development organizations and functions. Page One August 9, 2006 2007 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account if Description Actual Actual Actual Budget Amount Budget Comments 101 41910 101 00 Salaries Benefits 101 41910 102 00 Full -Time Overtime 101 41910 99 103 00 Part-Time Salaries Benefits 101 41910 99 103 01 Planning Commission Members 101 41910 01 201 00 Office Accessories 101 41910 01 202 00 Duplicating Copying 101 41910 01 203 00 Printed Forms Paper 101 41910 01 205 00 Drafting Supplies 101 41910 01 208 00 Miscellaneous Supplies 101 41910 01 209 00 Other Office Supplies 101 41910 01 219 00 Other Operating Supplies 101 41910 01 241 00 Small Tools 101 41910 01 305 00 Medical Dental Fees 101 41910 01 312 00 Contract Inspection Fees 101 41910 01 319 00 Other Professional Services 101 41910 01 329 0D Other Communication Costs 101 41910 01 331 00 Travel Expense 101 41910 0 341 00 Employment Advertising 101 41910 01 391 00 P C Maintenance 101 41910 01 392 00 P C Accessories Supplies 101 41910 01 393 00 P C Hardware Purchases 101 41910 01 433 00 Dues Subscriptions 101 41910 01 433 01 APA/AICP 101 41910 01 433 02 ICC 101 41910 01 433 03 AMBO 101 41910 01 433 04 10,000 Lakes 101 41910 01 433 05 "Future Use" 101 41910 01 433 06 Trade Magazines 101 41910 01 433 07 Planners Journal 101 41910 01 433 08 Sensible Land Use Coalition 101 41910 01 433 09 AACEO!MAHCO 101 41910 01 433 10 Other Dues Subscriptions 101 41910 01 435 00 Books Pamphlets 101 41910 01 437 OD Conferences Seminars 101 41910 01 437 01 State Bldg Official School 101 41910 01 437 02 Spnng Fall Code Updates 101 41910 01 437 03 Building Inspector Training 101 41910 01 437 04 Computer Training 101 41910 01 437 05 Clerical Seminars 101 41910 01 437 06 Planning Seminars 101 41910 01 437 07 ISIS Training 101 41910 01 437 08 State Planning Conference (2) 101 41910 01 437 09 Planning Commissioner Training 101 41910 01 437 10 Gen'I Seminars 101 41910 01 437 11 Code Enforcement Training 101 41910 01 439 00 Other Miscellaneous Charges 101 41910 01 570 00 Office Equipment Furnishings PAGE TOTALS DEPARTMENT TOTALS $610,751 75 43,757 2,063 $706,897 $771,360 $850,700 1,473 0 3,000 12,585 11,620 5,000 0 36 30 400 69 472 11,489 3,000 1,308 1597 1,163 2,000 0 0 0 100 0 195 81 200 244 666 252 600 0 773 1,657 1,500 0 30 53 400 0 0 0 0 358 439 0 0 98 1,015 14 2,000 1 000 1,487 1,475 2,000 463 720 653 600 3,085 802 0 0 2,016 5 811 2,016 3,000 389 0 0 500 0 2,081 0 0 1,341 1,37 1,500 100 10 200 480 20 500 175 5 200 0 0 115 18 150 0 4 100 200 200 0 300 30 50 947 328 35 700 3,339 15 380 28 500 179 27 300 0 4 1 000 0 400 40 27 500 1,138 69 1,200 892 40 500 629 63 1,200 358 300 84 49 400 130 40 400 10 145 14 400 0 0 0 $669,971 $743,936 5807,810 $886,000 5,000 1,500 200 300 150 0 200 100 200 300 50 500 300 1,000 400 500 1200 500 1,400 300 400 400 All Salary Costs Inclusive of $894,800 Salary, Taxes, PERA Benefits 3 000 5 000 400 Calendars, Planners etc 3,000 Codification of Zoning Ordinance 3 OD0 Forms, Stickers, Tags, etc 100 Zipatone, Spray Mount 200 Calculators 600 Dictation Devices Tapes 1,500 Building Inspection Supplies 400 Inspectors' Tools 0 0 1,000 2,000 600 0 3,000 500 0 3 000 700 Manuals, References, IBC Books 6,900 400 Contingencies 0 $830 100 $669,971 $743 936 $807,810 $886,000 $930,100 Fees for Contracted/Temp Sery Planning Consultant Cellular Phone Pagers Permltworks Support PATROL CRIMINAL INVESTIGATION POLICE DEPARTMENT ADMINISTRATION AND MANAGEMENT This budget provides for the overall planning, coordination and management of personnel and admuustration 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 Provides for the protection of hfe and property and an atmosphere of community security through the deterrence of criminal activity by visible patrols; the enforcement of traffic laws and accident investigation, the apprehension of crmunal offenders, and the dehvery of other non emergency community services. Responsible for the investigation of criminal incidents through the gathering, analysis and presentation of evidence and testimony Coordinates investigations with other agencies, such as County Attorney's Office, Child Protection, victim services and other federal, state and local law enforcement agencies. CRIME PREVENTION AND COMMUNITY EDUCATION PROGRAMS The implementation of the community pohcmg philosophy has led to the pohce and community members working together to identify and solve problems. It is a philosophy that should be utihzed by all officers while completing their daily tasks. A significant effort is made by the pohce department to inform residents of crime within the community, methods that citizens can take to help prevent crimes and building relationships with community members. There are specific programs that are frequently associated with community policing and that emphasize the need for the pohce and citizens to work together to prevent criminal activity and reduce the opportunities for criminals to commit crimes. POLICE DEPARTMENT— Page 2 Drug Abuse Resistance and Education (D A R.E.) Students are taught skills to resist the temptations to use illegal drugs and alcohol A police officer instructs the seventeen -week program to all fifth grade students at Rosemount and Shannon Park Elementary Schools as well as students at St Joseph's Cathohc School D A R.E also works to build up the students' self- confidence and to develop a positive relationship between the students and police officers. School Liaison One officer serves as a haison to the Rosemount Middle and High Schools The officer spends time at each school as their needs dictate The liaison officer investigates cnimnal incidents that occur at the schools or that involve students at the schools. In addition, the haison works with the school staff to enhance the safety and secunty for both staff and students Presentations on a variety of topics are made by the liaison to classes at all grade levels Community Education In order to work together with the community, pohce must share informauon 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 taps to persons on a daily basis whom report crumnal 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 dunes during city festivals and celebrations or emergencies, such as hazardous materials spills or leaks, damage resulting from tomadoes or other severe weather and major cruninal incidents. Reserve officers patrol on some evenings and handle service calls, for example, assisting stalled motorists and animal complaints They are also unlined regularly to provide crime prevention mformauon to citizens at community events or through other programs. Chaplain Program The Pohce Chaplains are used by officers to assist m 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, mantal 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 m the crisis ANIMAL CONTROL POLICE DEPARTMENT— Page 3 The Police Department is responsible for the enforcement of ordinances related to the control and care of domestic anneals. These tasks are mainly handled by Community Service Officers Their dunes include the licensing of dogs, cats and ferrets, assisting in the handling of stray, lost or 'inured animals and other complaints of animals causing a nuisance by barking, howhng or being allowed to roam off the owner's property. CODE ENFORCEMENT The Pohce Department assists the Community Development Department's Code Enforcement Official m the 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 explained how to rectify the offense. 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 Responsible for the development of emergency plans in the event of a technical or natural disaster in the community, e g tornado, flooding or hazardous materials release This function is the local contribution to homeland security of the state and nation STAFFING POLICE DEPARTMENT— Page 4 This department is compnsed of nineteen pohce officers A records supervisor, a full-tune and a part -tune secretary and a receptionist handle support responsibilities, such as transcription, fling, recepuon and other secretanal duties Community service officers continue to fulfill a support role for many dunes, including equipment maintenance, evidence transport, office support, code enforcement and animal control dunes As the community continues to grow, additional officers and other staff will be added to the department to meet the needs and expectations of the community and work towards the City's mission of providing a safe, healthy and pleasant community m a fiscally responsible manner. The positions within the department are distributed as follows: OFFICERS SUPPORT Chief of Police Records Supervisor Lieutenant Secretary (1 F/T 1 PST) Sergeant (3) Receptionist Investigator (2) Commumty Service Officers School Liaison Officer D. A.R.E. /Crime Prevention Officer Patrol Officer (10) Page One August 9, 2006 2007 BUDGET WORKSHEETS POLICE 2003 2004 2005 Account Description Actual Actual Actual 101 42110 101 00 Salanes Benefits 101 42110 102 00 Full -Time Overime 101 42110 102 01 Regular Overtime Hours 101 42110 102 02 Contracted OIT 101 42110 103 00 Part-Time Salaries Benefits 101 42110 23 103 00 Part -Time Secretary 101 42110 99 103 00 Part CSO's 101 42110 01 202 00 Duplicating Copying 101 42110 01 203 00 Printed 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 206 00 Miscellaneous Supplies 101 42110 01 206 01 DARE Donations 101 42110 01 206 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 Accurint 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 101 42110 01 242 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 (Amended) 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 316 00 Animal Care Services 101 42110 01 316 01 Impound Care Fees 101 42110 01 316 02 Deer Inventory 101 42110 01 319 00 Other Professional Services 101 42110 01 319 01 Dispatch Services Operations 101 42110 01 319 02 Dispatch Services Startup Costs 101 42110 01 321 00 Telephone Costs 101 42110 01 321 01 Cell Phones 101 42110 01 321 02 Pagers 101 42110 01 321 03 LOGIS Communications Line 101 42110 01 323 OD Radio Units 101 42110 01 323 01 Radios 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 Conferences 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 2006 2007 Object 2007 Adopted Detail Proposed Budget Amount Budget All Salary Costs Inclusive of 1,489,144 1,635,501 1,764,519 $1,911,000 $2,070,900 Salary, Taxes, PERA Benefits 60,931 55,102 62 916 65,000 65,00D 40,000 25,000 25,505 56,200 7,031 7,469 17,900 20600 P/T Secretary 16 Hours/Wk 30,009 31,500 35500 35,600 CSO's Total 50 Hours/Wk 706 156 242 200 225 372 1,043 800 227 0 0 200 1,928 1,882 3,429 2000 285 0 400 0 64 100 6,055 6,050 0 2,091 0 0 63,395 0 941 874 564 1,000 481 0 0 100 181 0 300 2,160 3,261 0 500 1,000 0 2,434 1,500 0 26 500 1,062 955 2,006 2 000 2,500 400 100 0 0 100 300 1,000 1,500 500 3,055 1,17 2,488 2,500 1,227 1,43 523 750 750 514 500 500 569 750 750 1,249 70 849 1,500 1,500 456 500 500 54,996 54,99 54,996 56,000 1,058 44 1,255 1,500 1,500 20 368 500 500 730 2,60 700 1 500 0 0 0 13,727 11,31 9,590 14,000 14,000 0 500 0 69,588 65,80 68,124 93,000 232,400 5,55 4,422 4 000 15,000 6,483 4,88 5,132 5,000 5,000 74 134 400 0 44 481 500 500 2,861 1,94 1,103 2,000 4,000 0 1,000 500 1,184 7 40 260 500 500 1,15 0 1,400 1,400 44 711 500 500 45 450 400 400 412 400 400 249 300 300 121 200 200 200 Film and Developing 800 Evidence Logs, Animal Lic, etc 0 3,000 1,000 Video, CD's Miscellaneous 400 3,000 2,300 2,000 300 Digital Recorders 2,500 Squad Emergency Equip Repairs 2,000 Crime Scene Kit Supplies Digital Recorders 2,000 Training Supplies 56,000 Prosecution 2,000 1,500 Medical Psychological 1,200 Interpreter Services 14 000 247,400 5,500 4,500 Radio Radar Repairs Subscriber Fees 3 700 1,745,523 1,896,432 2,096,106 2,229,600 2545,100 Comments 0 Donated Forfeited Funds Radio Repeater Phone Lines Page Two August 9, 2006 2007 BUDGET WORKSHEETS POLICE 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Descnption Actual Actual Actual Budget Amount Budget Comments 101 42110 01 333 00 Freight Express Expenses 101 42110 01 341 00 Employment Advertising 101 42110 01 391 00 P C Maintenance 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 CJIIN System 101 42110 01 396 DO 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 396 06 LOGIS Security and Back Up Site 68 0 0 613 51,794 12 1,27 39,77 2,52 3,03 16,37 147 200 200 Repairs 797 500 0 0 0 10,100 County IT Needs /Enhancements 13 000 432 500 500 1,988 2,00D 2,000 8,421 10,500 10,500 64 000 42,252 41,000 29,300 CAD Included in DCC 2,351 3,000 3,000 2,464 4,000 3,000 19,652 21,000 22,800 7,875 8,000 5,900 3,593 0 0 101 42110 01 433 00 Dues Subscriptions 2,613 3,600 101 42110 01 433 01 Mutual Aid Assistance Group -MAAG 1,65 2,000 2,100 2,200 101 42110 01 433 02 IACP Chiefs 10 100 100 100 101 42110 01 433 03 MN Chiefs of Police 225 150 250 101 42110 01 433 04 Dakota Cty Chiefs of Police 5 50 50 50 101 42110 01 433 05 Wakota CAER 0 20 20 101 42110 01 433 06 Metro Emergency Managers 0 25 0 101 42110 01 433 07 MN Sex Crimes Investgators 1 18 25 25 101 42110 01 433 D8 Tn -County Investigators 6 60 60 60 101 42110 01 433 D9 MN Crime Prevention Association 36 0 25 50 101 42110 01 433 10 P 0 S T Licenses 54 460 750 700 101 42110 01 433 11 FBI Nat'l Academy Association 60 60 60 101 42110 01 433 12 Miscellaneous 55 35 85 101 42110 01 435 OD Books Pamphlets 68 9 297 300 300 Statutes, Crime Prevention 101 42110 01 436 00 Towing Charges 69 14 B8 200 200 101 42110 01 437 00 Conferences Seminars 10,208 13,000 101 42110 01 437 01 Firearms -Range Rental 40 3,896 2,000 2,000 101 42110 01 437 02 Chiefs Spring Conference 45 345 500 500 101 42110 01 437 03 Investigations 361 1 500 1,500 101 42110 01 437 04 IACP Conference 22 0 250 250 101 42110 01 437 05 Supervision 15 650 1,000 1 000 101 42110 01 437 06 Use of Force 8,36 1,625 600 600 101 42110 01 437 07 Emergency Driving 1,365 1,400 1,400 101 42110 01 437 08 First Aid 1,690 2,000 2,000 101 42110 01 437 09 Narcotic Enforcement 100 750 750 101 42110 01 437 10 Tactical 670 1,000 1,000 101 42110 01 437 11 Support Services 40 500 500 101 42110 01 437 12 Patrol 1,228 1 500 1,500 101 42110 01 439 00 Other Miscellaneous Charges 264 44 412 500 500 Snacks Beverages for Mtgs 101 42110 01 580 00 Other Equipment Purchases 5,590 1,72 3,091 2 000 0 PAGE TOTALS $71,287 $77,916 $108856 $110,100 $104,900 DEPARTMENT TOTALS $1,816,810 31,974,347 $2,204,962 32,339,700 $2,650 000 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 savmg 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 paid -on -call firefighters, which is the most fiscally sound method of delivery at this point in 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 servmg 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 FIRE DEPARTMENT Provides for the overall adni.mstration and management of the Fire Department. Included is the collection, preparation and dissemination of mformation, the preparation of operating budgets, 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 riunvnize injury, loss of life and loss of property within the City of Rosemount, both to its cinzens and visitors Provides for the controlling and extinguishing of all types of fires in order to minumze injury, loss of hfe 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 Washington County ma a mutual aid agreement by which these services can be reciprocated on an as needed basis. Provides for the investigation of fires by the local Fire Marshal Also provides for the coordination of joint mvestiganons by the local Fire Marshal and the State Fire Marshal. RESCUE SQUAD FIRE DEPARTMENT— Page 2 Provides for emergency operations pertaining to bodily injury or senous illness requiring emergency services within t City of Rosemount, both to its citizens and visitors. Provides for emergency operations pertaining to bodily injury or senous 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 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 matenal 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 m areas above those that are required, in order that fire and rescue personnel may sharpen existing skills and acquire new skills. Allows for trauung of fire fighters to prepare themselves for the acceptance of a position of leadership within the Fire Department. Provides for the training of the City Fire Marshal HEALTH TESTING STAFFING FIRE DEPARTMENT— Page 3 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. In 2006, the Fire Department consisted of 40 paid on -call firefighters serving m 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 tune's people retire prior to the full 20 years. We hope to end 2007 with a department of not less than 44 firefighters and one fire marshal Page One August 9, 2006 2003 2004 2005 Account# Description Actual Actual Actual 101 42210 101 42210 101 42210 101 42210 101 42210 101 42210 101 42210 01 202 00 101 42210 01 202 01 101 42210 01 202 02 101 42210 01 204 00 101 42210 01 204 01 101 42210 01 204 02 101 42210 01 204 03 101 42210 01 207 00 101 42210 01 208 00 101 42210 01 208 D1 101 42210 01 208 02 101 42210 01 208 03 101 42210 01 208 D4 101 42210 01 208 05 101 42210 01 211 00 101 42210 01 211 01 101 42210 01 211 02 101 42210 01 211 03 101 42210 01 211 04 101 42210 01 218 00 101 42210 C1 219 00 101 42210 01 219 01 101 42210 01 219 02 101 42210 01 219 03 101 42210 01 219 04 101 42210 01 219 05 101 42210 01 219 06 101 42210 01 229 00 101 42210 01 229 01 101 42210 01 229 02 101 42210 01 229 03 101 42210 01 229 04 101 42210 01 230 00 101 42210 01 230 01 101 42210 01 230 02 101 42210 01 230 03 101 42210 01 230 04 101 42210 01 230 05 101 42210 01 230 06 101 42210 01 241 00 101 42210 01 241 01 101 42210 01 241 02 101 42210 01 241 03 2007 BUDGET WORKSHEETS FIRE 103 00 Salaries Benefits 103 01 Salaries 103 02 Training Pay/Stipends 103 03 Call Pay /Stipends 103 04 Class Pay/Stipends 103 05 P/T Fire Marshal Duplicating Copying Copy Toner Computer Pnnters Envelopes Letterhead Envelopes Letterhead Forms Training Instructional Supplies Miscellaneous Supplies Supplies, Computer Support Film Developing Memberships Code Books Training Cleaning Supplies Soaps Chamois, Towels, etc Sponges, etc SCBA Cleaner Fire Department Clothing Other Operating Supplies Gloves Bandages Equipment Tyvek Suits Consummable Medical Oxygen Other Maintenance Supplies Aerial Pumpers Tanker Pickup Trucks Rescue Other Vehicle Modifications Equipment Repair Materials Light Bars Smoke Machines Lanterns Miscellaneous Small Tool Repairs Opticom Station Small Tools Axes, Bars Other Grass Fire 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 (4) 101 42210 01 306 02 Hepatitis Shots (4) 101 42210 01 306 03 Background Checks (4) 101 42210 01 306 04 Drug Testing (4) 101 42210 01 308 00 Instructors' Fees 101 42210 01 308 01 Fire Fighter 1 (4) 101 42210 01 308 02 Fire Fighter 1 Certificates (4) 101 42210 01 308 03 Fire Fighter Re- Certificates (6) 101 42210 01 308 04 First Responder (4) 101 42210 01 308 05 First Responder Refresher (1/2) 101 42210 01 308 06 Outside Schools ($/2) 101 42210 01 308 07 Haz -Mat Training (4) 101 42210 01 308 05 Apparatus Re- Certificates (0) PAGE TOTALS $73,285 $74,520 $82,244 $81,700 929 1,203 251 1,535 1,695 262 2,030 883 1,031 6,965 0 0 0 0 0 258 0 917 0 45 152 0 468 0 0 0 83 1,336 0 1,219 0 354 53 3,187 0 0 0 0 0 0 1,087 0 3,912 140 0 169 2,829 2,470 0 341 0 0 0 0 90 0 1,656 7,007 1,730 0 0 0 0 42 0 731 0 35 210 595 1,044 0 0 0 140 0 0 494 0 280 111 0 0 0 12 0 0 0 205 0 0 126 66 782 1,133 29 96 0 0 0 315 0 2,040 6,430 0 0 0 0 2006 2007 Object 2007 Adopted Detail Proposed Budget Amount Budget 50 50 25 25 50 0 1,500 100 300 500 1 000 100 100 25 75 300 800 100 500 100 1,800 200 800 100 100 100 100 250 250 600 300 300 150 250 300 1,000 500 100 500 1200 150 200 1,000 1,500 3,850 1,000 0 26,300 3,300 20,000 100 34,700 50 50 25 25 50 700 100 300 200 800 150 50 25 75 800 100 500 100 1,800 200 800 100 100 100 100 250 250 600 300 300 150 250 300 1,000 500 100 500 1,200 150 100 1,000 2,000 2,250 1,000 0 All Salary Costs Inclusive of $84,400 Salary, Taxes, PERA Benefits 100 100 0 2,100 Supplies for Fire Marshal 300 300 5 Uniforms $60 Each 3,500 Medical Supplies 1 100 1 800 700 2,741 3,500 3,500 Annual Medical Tests 2 100 92,696 101,204 99,900 107,500 107,700 Comments 7,700 Page Two August 9, 2006 2007 BUDGET WORKSHEETS FIRE 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 42210 01 310 00 Testing Services 1,534 3,400 101 42210 01 310 01 Aerial (Next 2009) 0 795 0 1,000 101 42210 01 310 02 Ladders (Next 2009) 0 0 0 500 101 42210 01 310 03 Pumpers (3) (Next 2008) 870 0 900 900 101 42210 01 310 04 SCBA Hydro Testing (Next 2010) 0 1,450 0 1,000 101 42210 01 313 00 Temporary Service Fees 259 3,800 101 42210 01 313 01 SCBA Contract 540 388 400 400 101 42210 01 313 02 SCBA Maintenance 0 209 200 200 101 42210 01 313 03 Copier Fax Contract 1,011 0 400 400 101 42210 01 313 04 Security Contract 278 286 500 500 101 42210 01 313 05 SOT Joint Powers 0 1,381 2,000 2,300 101 42210 01 314 00 Annual Fire Relief Contribution 135,000 135,000 139,100 143 300 147,800 Moved From Salaries Above 101 42210 01 319 00 Other Professional Services 2,713 1,800 Fire Prevention Education 101 42210 01 319 01 School Literature 0 0 350 250 101 42210 01 319 02 Door Prizes 200 0 250 150 101 42210 01 319 03 Fire Prevention Week Promos 2,001 2,887 1 300 900 101 42210 01 319 04 Food at Open House 188 0 150 150 101 42210 01 319 05 Summer Park Education 0 0 250 200 101 42210 01 319 06 National Night Out 0 0 200 150 101 42210 01 321 00 Telephone Costs 700 500 101 42210 01 321 01 Chief 557 382 300 250 101 42210 01 321 02 Assistant Chief 15 17 100 100 101 42210 01 321 03 Rescue 7 41 100 100 101 42210 01 321 04 Numeric Pagers 70 83 100 50 101 42210 01 322 00 Postage Costs 0 0 14 100 100 UPS Costs 101 42210 01 329 00 Other Communication Costs 521 3,500 101 42210 01 329 01 Base Repairs 0 0 200 200 101 42210 01 329 02 Pager Repairs 474 915 200 200 101 42210 01 329 G3 Hand Held Repairs 344 364 300 300 101 42210 01 329 04 Mobile Repairs 120 323 300 300 101 42210 01 329 05 800 MHZ User Fee 0 0 0 2,500 1 01 42210 01 331 00 Travel Expense 3,677 4 400 101 42210 01 331 01 Minnesota Chiefs Conference 1,309 2,882 1,500 1,500 101 42210 01 331 02 Fire Department Association 289 817 900 900 101 42210 01 331 03 Outside Schools 0 589 3,500 2,000 101 42210 01 433 00 Dues Subscriptions 1,214 1 400 101 42210 01 433 01 Capital City 50 0 35 50 101 42210 01 433 02 VFBA Insurance 259 30 260 350 101 42210 01 433 03 State Fire 300 300 200 250 101 42210 01 433 04 State Chiefs 165 0 250 250 101 42210 01 433 05 DCFC 0 50 40 40 101 42210 01 433 06 WAKOTA Mutual Aid 25 25 30 40 101 42210 01 433 07 Purchasing Consortium 0 35 50 50 101 42210 01 433 08 NFPA 0 0 185 185 101 42210 01 433 09 MN Ass'n Fire Marshals 0 0 150 155 Fire Marshal Dues 101 42210 01 437 00 Conferences Seminars 519 800 101 42210 01 437 01 State Fire Conference 405 0 400 450 101 42210 01 43' 02 State Chiefs Conference 0 450 300 350 101 42210 01 439 00 Other Miscellaneous Charges 1,293 1,600 101 42210 01 439 01 Food Coffee 266 328 190 250 101 42210 01 439 02 Extinguisher 0 0 400 400 101 42210 01 439 03 Plaques 48 65 20 40 101 42210 01 439 04 Paint 0 0 50 70 101 42210 01 439 D5 Station Needs 807 664 540 840 101 42210 01 58D 00 Other Equipment Purchases 15,708 15,000 101 42210 01 580 01 Bunker Gear (9) 1,285 2,803 9,000 9,000 101 42210 01 580 02 Pagers (6) 7,472 0 3000 3,000 101 42210 01 580 03 Hose Replacement 1,036 0 2,000 2,000 101 42210 01 580 04 Replace Damaged Items 2,291 1,238 1 000 1,000 101 42210 01 581 00 Other Equipment Purchases 0 0 0 0 0 PAGE TOTALS $163,138 $157,681 6158,920 $175 900 $183,900 DEPARTMENT TOTALS $255,835 $258,885 $258,821 $283 400 $291,600 Separate Enterprise Fund Budgets from those included here under the advisement of the Utility Commission of the City of Rosemount. The Pubhc Works Depaiu lent 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 City Engineer PUBLIC WORKS In pursuit of providing a safe, healthy and pleasant community, the Public Works DepaiLuient maintains and builds the City's infrastructure. This is done through four (4) maintenance funds and three (3) enterprise funds A summary of the Department is as follows: The Pubhc Works Department consists of the Engineering and Pubhc Works Divisions. The maintenance personnel maintain the streets, storm drainage, sanitary sewer and potable water systems, along with all government buildings, parks and all Ciry grounds. The budgets administered by the Public Works Department are as follows: Government Buildings Fleet Maintenance Street Maintenance Parks Maintenance Water Operating Sewer Operating Storm Water Operating 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 Pubhc Works building and garage, and two Fire Halls (the second one to open in 2006) It also includes three (3) park shelters, St. Joe's Church, 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, ores, shop supphes, and contracted vehicle maintenance The City -owned vehicles include. Pohce Department (10 cars, 3 trucks, 1 ATV) Fire Department (6 pickup trucks, 6 fire trucks) Parks and Recreation (1 truck, 1 van, 1 car, 1 ice resurfacer) Administration Community Development (4 cars, 1 truck, 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, 5 mowers, 13 trucks, 2 compactors, 1 roller, 1 ATV, 4 snow blowers) 4 large trailers STREET MAINTENANCE This budget provides for the maintenance and preservation of over 120 miles of City roads, over 30 miles of sidewalks and bike trails, and 12 City parking lots. Standard maintenance includes grading, graveling, patching, sealing and overlays This budget also provides for pavement markings, street signs, street hghtmg, signal light maintenance and power, snow and ice control, and street sweeping PARKS MAINTENANCE This budget provides for the mamtenance of over 300 acres of City park areas in 23 locations, including 11 parks with athletic fields and 10 parks with shelters or pavilions It includes the maintenance of all park trails and 10 other municipal areas, including City Hall, the Fire Station and the Community Center. It also includes the installation of playground equipment, landscaping projects, ice rink construction and maintenance (4 hockey rinks, 6 pleasure rinks), and other miscellaneous construction activities. Page One August 9, 2006 2007 BUDGET WORKSHEETS GOVERNMENT BUILDINGS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget PAGE TOTALS $315,449 $322,574 $361,796 $390,500 $450,400 DEPARTMENT TOTALS $315,449 $322,574 $361,796 $390 500 $450,400 Comments At Salary Costs Inclusive of 101 41940 101 00 Salaries Benefits $46,600 $58,300 Salary, Taxes, PERA Benefits 101 41940 79 101 01 Maintenance -P W Sup #2 0 0 8,500 8,800 101 41940 79 101 02 Maintenance Staff 49,257 46,046 47,500 49,500 101 41940 10200 Full -Time Overtime 2,214 4,180 2,869 4 000 4,000 101 41940 01 208 00 Miscellaneous Supplies 9,604 13,317 15,483 17 000 17,000 Cleaning Supplies, Towels, etc 101 41940 01 223 00 Building Repair Supplies 4899 5,186 6,499 5,000 5,000 101 41940 01 225 00 Landscaping Materials 652 469 1,316 500 500 Trees &Shrubs 101 41940 01 241 00 Small Tools 366 46 115 200 200 Hand Tools, Bits Blades, etc 101 41940 01 242 00 Minor Equipment 1,060 1,025 2,038 2,000 2,000 Equipment Replacement 101 41940 01 302 00 Archdects' Fees 0 0 0 1,000 0 Estimates 101 41940 01 318 00 Contract Engineer 1 500 750 1,500 3,000 3,000 Contracted Engineer for City (5 1001 41940 01 319 00 Other Professional Services 31 467 30,000 101 41940 01 319 01 Elevator Maintenance 1,153 1,206 1000 1,000 101 41940 01 319 02 Heating /Cooling Maint Contract 2,116 1,553 5,000 5,000 101 41940 01 319 03 Annual Boiler Inspections 110 1,015 1,500 1,500 101 41940 01 319 04 Pest Control 1,502 1,570 1,500 1,500 101 41940 01 319 05 Fire Extinguishers 706 1,750 1,000 1,0000 101 41940 01 319 06 Fire Suppression System Check 844 2,350 1,000 2,500 101 41940 01 319 07 Janitorial Service -Fire Stations 3,515 3 515 5,300 7,000 Fire Stations #2 101 41940 01 319 08 Janitorial Service -P W Building 10,288 10 288 10,500 10 500 101 41940 01 381 00 Electric Utilities 44,107 45,362 76 312 50,000 80,000 Price Increases 101 41940 01 383 00 Gas Utilities 44,612 45,617 54,161 67,500 75 000 Fire Station #2 101 41940 01 384 00 Refuse Disposal 24,025 944 35 000 101 41940 01 384 01 General Buildings Parks 10,430 11,502 20,000 20,000 Added Parks 101 41940 01 384 02 Recycling /Cleanup 13,725 14,893 15,000 15,000 2 Cleanup Days per Year 101 41940 01 389 00 Other Utility Services 3,800 3,800 3,790 3,800 3,800 Floor Mats Monthly Charges 101 41940 01 401 00 Contracted Building Repairs 11,685 25,000 101 41940 01 401 01 Electrical Repairs 1,665 456 2,000 2,000 101 41940 01 401 02 Siren Replacement Program 10,000 8,979 10,000 10,000 101 41940 01 401 03 Miscellaneous Repairs 15,855 12,871 13,000 13,000 101 41940 01 409 00 Other Contracted Repair Maint 0 0 0 0 8,000 Lighting System Upgrades 101 41940 01 415 00 Other Equipment Rental 1,234 142 397 1,000 1 000 Scaffolding, Cleaners 101 41940 01 439 00 Other Miscellaneous Charges 0 0 0 1,000 1,000 Contingencies 101 41940 01 530 00 Improvements Other Than Buildings 0 0 0 0 10,000 Fence at St Joseph's 101 41940 01 601 00 Bond Principal 33,895 36,316 38,737 41,200 43,600 MSABC Payment (2/1) 101 41940 01 611 00 Bond Interest 53,142 43,190 39,811 49,900 47,400 MSABC Payments (2/1 8/1) 101 41940 01 621 00 Bond Paying Agent Fees 585 1,063 775 600 600 Page One August 9, 2006 2007 BUDGET WORKSHEETS FLEET MAINTENANCE 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Budget Amount Budget Comments 101 43100 101 00 Salaries Benefits 101 43100 77 101 00 Administrative 101 43100 79 101 00 Maintenance 101 43100 102 OD Full -Time Overime All Salary Costs Inclusive of $132,369 $152,500 Salary, Taxes, PERA 8 Benefits 9,396 10,976 10,200 10,600 122,763 123,318 136 100 141,900 5,799 1,226 1,601 7 500 7 50 101 43100 01 211 00 Cleaning Supplies 548 709 735 1,000 1,00 101 43100 01 212 00 Motor Fuels 65,730 75,983 115,276 137 500 167,50 101 43100 01 213 00 Lubricants Additives 2,566 5,093 3,636 5 500 5,50 101 43100 01 215 00 Shop Materials 15,714 12,106 11,937 20 500 17 00 101 43100 01 221 00 Equrpment Parts 86,235 87,101 92,730 89 000 95,00 10`43100 01 222 00 Tires 12,474 10,213 11,258 16,000 16,0 101 43100 01 241 00 Small Tools 4,262 2,662 3 633 4,000 4,00 101 43100 01 242 00 Minor Equipment 6,163 6,935 4,528 6,000 6,00 101 43100 01 318 00 Contract Engineer 3000 1 500 3,000 4,500 4,50 101 43100 01 321 00 Telephone Costs 0 0 0 0 101 43100 01 323 00 Radio Units 1999 1 058 473 2,000 2,00 101 43100 01 331 00 Travel Expense 0 0 0 0 101 43100 01 341 00 Employment Advertising 0 38 0 0 101 43100 01 384 00 Refuse Disposal 190 557 151 500 50 101 43100 01 394 00 P S Software Purchases 0 354 0 500 50 101 43100 01 404 00 Contracted Mach Equip Repairs 32,136 31,179 27,680 35,000 35,00 101 43100 01 416 00 Machinery Rental 252 0 0 1,000 1,00 101 43100 01 417 00 Uniforms Rental 118 59 83 0 101 43100 01 433 D0 Dues Subscnpttons 0 95 0 0 101 43100 01 435 00 Books Pamphlets 0 0 190 200 101 43100 01 437 00 Conferences Seminars 75 220 75 1,000 1,00 PAGE TOTALS $369,629 $369,245 $411,281 $478,000 $536,500 DEPARTMENT TOTALS $369,629 $369,245 $411,281 $478,000 $536,500 Shop Vehicles Price Increases Contracted Engineer for City(10 Repair /Replace Umts Shop Hazardous Waste General Software Support Page One August 9, 2006 2007 BUDGET WORKSHEETS STREET MAINTENANCE 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43121 101 00 Salaries Benefits $392,557 $469 900 Salary, Taxes, PERA Benefits 101 43121 77 101 00 Administrative 101 43121 78 101 00 Technical /Clerical 101 43121 79 101 00 Maintenance 101 43121 102 00 Full -Time Overtime 101 43121 99 103 00 Part-Time Salaries Benefits 101 43121 01 201 00 Office Accessories 101 43121 01 203 00 Printed Forms Paper 101 43121 01 203 01 RAN Permit Inspection Forms 101 43121 01 203 02 Work Orders 101 43121 01 203 03 City Specification Books 101 43121 01 205 00 Drafting Supplies 101 43121 01 205 01 Paper for Plan Reproductions 101 43121 01 205 02 Off-Site Reproductions 101 43121 01 205 03 Film Developing 101 43121 01 205 04 Miscellaneous Tools 101 43121 01 209 00 Other Office Supplies 101 43121 01 216 D0 Chemical Chemical Products 101 43121 01 224 00 Street Maintenance Materials 101 43121 01 224 01 Paint 101 43121 01 224 D2 Mail Boxes 101 43121 01 224 03 Light Bulbs /Lenses 101 43121 01 225 00 Landscaping Materials 101 43121 01 225 01 Sod 101 43121 01 225 02 Seed 101 43121 01 225 03 Black Dirt 101 43121 01 225 04 Trees 101 43121 01 226 00 Sign Repair Materials 101 43121 01 231 00 Bituminous Patching Materials 101 43121 01 232 00 Crushed Rock 101 43121 01 233 00 Dust Control Materials 101 43121 01 234 00 De -Icing Sand 101 43121 01 235 00 Shouldering Gravel 101 43121 01 241 00 Small Tools 101 43121 01 242 0D Minor Equipment 101 43121 01 303 00 Engineering Fees 101 43121 01 304 00 Legal Fees 101 43121 01 305 00 Medical Dental Fees 101 43121 01 310 00 Testing Services 101 43121 01 313 01 Temporary Service Fees 101 43121 01 318 00 Contract Engineer 101 43121 01 319 00 Other Professional Services 101 43121 01 321 00 Telephone Costs 101 43121 01 324 00 Messenger Services 10" 43121 01 331 00 Travel Expense 101 43121 01 341 D0 Employment Advertising 101 43121 01 381 DO Electric Utilities 101 43121 01 38' 01 Street Lights 101 43 01 381 D2 Signal Lights Sirens 101 43121 01 384 00 Refuse Disposal 101 43 01 384 01 Hazardous Waste Disposal 101 43121 01 384 02 Roadside Garbage 101 43121 01 384 03 Tree Disposal 101 43121 01 391 00 P C Maintenance 101 43121 01 391 01 Gopher State One -Call 101 43121 01 391 02 State Aid 101 43121 01 391 03 Pavement Management Syst Supp 101 43121 01 392 00 P C Accessories Supplies 101 43121 01 394 OD P S Software Purchases PAGE TOTALS 28,188 32,930 30,600 52,017 44 643 71 400 296,469 326 704 355 700 12,298 8 392 7,396 16 000 12 469 12,078 16 833 15 000 0 1,658 28 0 500 145 51 200 378 2,953 3,500 1,014 80 306 1,412 900 0 450 0 200 13 50 550 82 0 279 500 32,183 27,017 59,193 37,000 674 1,147 8,350 25,684 24,761 24,686 10,136 2,488 1,342 2,823 25 9 2,500 4,05 0 0 72 79 700 473 475 500 93 261 500 163 85 500 94 35 3,000 474 0 300 243 72 2,000 498 0 1,000 8,846 7,941 10,000 23,845 26,433 27,000 25,950 33,061 30,000 22,660 18 460 30 000 5301 3 742 12 000 3,53 2 543 3 000 2,02 1 125 1 500 9,86 3 063 3 000 0 1,000 542 1,000 0 600 31,800 74,100 364,000 500 200 0 900 450 200 550 Inspection Equipment 500 60,000 De -Icing Chemicals (Added Miles) 1 500 500 500 500 3,000 300 2,000 1,000 20,537 38,39 62,545 8,500 8,500 General Non Project Related 2,528 6,72 12,183 2,000 2,000 Appeals of Closed Projects 207 0 600 600 Employment Physicals 0 95 537 1,200 1,200 0 53 14,043 0 0 6,000 3,00 6,000 9,000 9,000 Contracted Engineer for City(20 568 1,46 5,887 1,500 1,500 Random Drug Testing 2,266 2,17 1,842 3,000 3,000 Cellular Phones Pagers 0' 80 100 100 5 110 1,000 1,000 APWA Miscellaneous 501 1,949 0 0 105,575 2 8 145,000 113,18 124,546 135,000 135,000 Added Lights Price Increases 3,63 3,740 10,000 10,000 201 2,600 1,000 1 000 600 695,241 705,361 623,217 845,500 871,200 16,00D Maintenance 15 DOD 700 700 2 100 6,300 10 000 27 000 30 000 Add County Road 38 30 000 Add County Road 38 6 000 3 000 1,500 Shovels, Brooms, etc 3,000 Safety Equipment 8,500 0 0 0 0 1,000 1,000 194 7 500 7,500 0 0 0 298 5 000 5,000 General Software Support Page Two 2007 BUDGET WORKSHEETS STREET MAINTENANCE August 9, 2006 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account ft Descnption Actual Actual Actual Budget Amount Budget Comments 101 43121 01 402 00 Street Seal Coating 136,226 137,841 0 0 0 Moved to Street CIP Part of 101 43121 01 402 00 General Seal Coating 0 Pavement Management Program 101 43121 01 403 00 Contracted Repau Maintenance 5,472 29,500 101 43121 01 403 01 Street Lights 10,439 20 611 26 50 28,500 Repair 9 Street Lights (Annually) 101 43121 01 403 02 Signal Lights 494 29 50 500 101 43121 01 403 03 Light Replacements 1,675 115 50 500 101 43121 01 405 00 Street Striping 14,064 14,324 15 652 30,00 25,000 101 43121 01 406 00 Street Sweeping 5,491 6,468 3,160 5 00 5,000 101 43121 01 407 00 Bituminous Overlays 0 0 0 0 101 43121 01 408 00 Street Crack Sealing 33,332 30,165 19,891 35 00 35,000 101 43121 01 409 00 Tree Trimming 4,703 3,179 4 979 5 00 5 000 101 43121 01 410 00 Concrete Sidewalk/Curb Repairs 133,374 14,202 133,000 101 43121 01 410 01 General Repairs 0 424 8,00 8,000 101 43121 01 410 02 Pedestrian Improvements 11 124,615 125,00 125,000 101 43121 01 411 00 Contracted Snow Removal 7,215 4,192 15,686 24000 101 43121 01 411 01 Community Center 12,00 12,000 101 43121 01 411 02 St Joseph's 6,00 6,000 101 43121 01 411 02 Genz -Ryan 6,000 101 43121 01 415 00 Equipment Rental 0 16,983 4,452 45,00 45,000 Paver Rental 101 43121 01 416 00 Snow Plow Loader Rental 9,260 0 7,19 0 101 43121 01 418 00 Snow Plow Rental 0 0 0 0 101 43121 01 420 00 Truck Rentals /Sidewalk Blower 1,820 2,130 0 0 101 43121 01 433 00 Dues Subscriptions 961 900 101 43121 01 433 01 American Public Works Assn 340 429 22 225 (APWA) 101 43121 01 433 02 Request for Mutual Aid Assn 500 0 1 10 (RMAA) 101 43121 01 433 03 City Engineers' Association 0 0 15 150 101 43121 01 433 04 Professional Secretaries 80 100 9 90 101 43121 01 433 05 MN Society for Professional Engineers 375 375 30 300 (MSPE) 101 43121 01 433 06 American Society of Civil Engineers 0 0 12 125 (ASCE) 101 43121 01 435 00 Books Pamphlets 131 800 101 43121 01 435 01 MUTCD 39 0 20 200 101 43121 01 435 02 MN Dot Updates 15 121 60 600 101 43121 01 437 DO Conferences Seminars 1,303 4 000 101 43121 01 437 01 APWA 225 989 1,05 1,050 101 43121 01 437 02 Computer Training 0 251 50 500 101 43121 01 43 03 Clerical 90 10 15 150 101 43121 01 437 04 Gravel Road Maintenance 112 15 150 101 43121 01 437 05 City Management Training 0 50 500 101 43121 01 437 06 CEAM 0 50 500 101 43121 01 437 07 MN Pavement Management 12 40 400 101 43121 01 437 08 MN Dot 0 3D 300 101 43121 01 437 09 Miscellaneous Training 360 55 45 450 Safety Training 101 43121 01 439 00 Other Miscellaneous Charges 5 469 2,091 2,00 2,000 101 43121 01 570 00 Office Equipment 8 Furnishings 0 0 0 0 PAGE TOTALS $353,377 $362,457 $222,024 $308,200 $309 200 DEPARTMENT TOTALS 51,048,618 $1067,818 $1,045,241 $1,153700 51,180400 Page One August 9, 2006 2007 BUDGET WORKSHEETS PARKS GROUNDS MAINTENANCE Account Description Actual Actual Actual Budget Amount Budget 101 45202 101 00 Salaries Benefits 101 45202 77 101 00 Aaministrative 101 45202 79 101 00 Maintenance 101 45202 102 00 Full -Time Overtime 101 45202 99 103 00 Part-Time Salaries Benefits 101 45202 01 205 00 Drafting Supplies 0 0 0 100 100 101 45202 01 216 00 Chemical Chemical Products 13,141 34,000 101 45202 01 216 01 Herbicides(General Park Use) 4,727 8,027 12,000 12,000 101 45202 01 216 02 Fertilizer 10,833 16,780 17,000 22,000 Add Meadows,Innisfree &Harmony 101 45202 01 219 00 Other Operating Supplies 9,105 52,000 101 45202 01 219 al Seed, Sod, etc 878 2,561 3,000 3,000 101 45202 01 219 02 Red Rock, Sand, Gravel, etc 1,227 2,222 6,000 6,000 101 45202 01 219 03 Repair Supplies 2,129 0 3,000 3,000 Bloomfield Birch Parks Online 101 45202 01 219 04 Bituminous 0 0 0 40,000 Repave Schwarz Parking Lot 101 45202 01 221 00 Equipment Parts 10,528 15,000 Add Meadows Innisfree 101 45202 01 221 01 Playground Equipment Repair 3,151 4,464 2,500 7,500 Woodchips 101 45202 01 221 02 Irrigation Repair(Non- Contract) 3,184 2,707 3,000 5,000 101 45202 01 221 03 Miscellaneous(Player Benches) 4,843 843 2,500 2,500 101 45202 01 221 04 Park Sign Replacements 0 4,290 5,500 0 101 45202 01 223 00 Building Repair Supplies 5,245 10 000 101 45202 01 223 01 Paint, Stain etc 1,548 1,270 1,500 1,500 101 45202 01 223 02 Shingles, Boards, etc 599 1,998 2,000 2,000 101 45202 01 223 03 Miscellaneous 1,639 784 1,500 1,500 Caulk Hardware, etc 101 45202 01 223 04 Shelter/Shed Repairs 0 7,238 5,000 5,000 101 45202 01 225 00 Landscaping Materials 1,370 7 000 101 45202 01 225 01 Trees, Shrubs, Sod, etc 3,181 2,301 3,500 3,500 Landscaping Around Park Signs 101 45202 01 225 02 Timbers, Fence etc 307 2,302 3,500 3,500 101 45202 01 226 00 Sign Repair Materials 14 264 500 500 101 45202 01 229 00 Other Maintenance Supplies 1,54 1,907 3,962 4,000 4,000 Paint, Chalk Bases Field Dry, etc 101 45202 01 241 00 Small Tools 2,78 2,430 1960 2 500 2,500 Hand Tools, Blades Bits, etc 101 45202 01 242 00 Minor Equipment 2,58 450 1,326 2 500 2,500 Safety Equipment 101 45202 01 303 00 Engineering Fees 0 0 0 0 101 45202 01 305 00 Medical and Dental Fees 20 0 0 0 0 101 45202 01 318 00 Contract Engineer 1,37 750 1,500 3,000 3,000 Contracted Engineer for City (5 101 45202 01 321 00 Telephone Costs 193 2,017 1,773 500 500 Cellular Phone Bills 101 45202 01 323 00 Radio Units 0 0 500 500 WaIMe- Talkies 101 45202 01 331 00 Travel Expense 0 0 100 100 Seminars Workshops 101 45202 01 341 00 Employment Advertising 0 0 0 0 101 45202 01 381 00 Electric Utilities 12,81 15,500 101 45202 01 381 01 Skating Rinks 4,088 4,031 6,000 6,000 101 45202 01 381 02 Softball Fields 6,163 6,506 6 500 6,500 101 45202 01 381 03 Irrigation 1965 2,138 3 000 3,000 101 45202 01 363 00 Gas Utilities 2,200 2,210 2,487 3,300 3,300 101 45202 01 403 00 Contracted Repair Maintenance 2,570 8,000 101 45202 01 403 01 Irrigation Repairs 364 0 1,500 1,500 101 45202 01 403 02 Electrical Repairs 801 1,860 1,500 1,500 101 45202 01 403 03 Miscellaneous Repairs 2,601 160 5,000 5,000 Roof Jaycee Park Shelter 101 45202 01 409 00 Other Contracted Repair Maint 0 2,335 3,913 8,000 8,000 Chemical Lawn Services 101 45202 01 416 00 Machinery Rental 11,878 18,000 101 45202 01 416 01 Mower Leases 12,235 14,100 17,000 17,000 Price Increases 101 45202 01 416 02 Mrscet :aneous Rentals 4,663 973 1,000 1,000 101 45202 01 433 00 Dues Subscriptions 45 200 101 45202 01 433 01 Memberships MRPA 0 35 100 100 101 45202 01 433 02 Miscellaneous Dues 0 0 100 100 101 45202 01 435 00 Books Pamphlets 0 -0 152 100 100 101 45202 01 437 00 Conferences Semmars 662 2,500 101 45202 01 437 01 Seminars Workshops 363 1,085 300 0 101 45202 01 437 02 School Tuition 270 891 200 0 101 45202 01 439 00 Other Miscellaneous Charges 0 0 348 200 200 Contingencies PAGE TOTALS $354,072 $409,966 $467,286 $532,800 $601,600 DEPARTMENT TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed All Salary Costs Inclusive of $259,401 $385,100 Salary, Taxes, PERA Benefits 9,396 10,977 10,200 10,600 291,950 310,226 354,600 374,500 2,655 5,174 5,578 14,000 14,000 12 434 19,574 31,516 15,000 15 000 $354,072 $409,966 $467,286 $532,800 3601,600 Comments The Parks and Recreation Department works together with citizens to provide a safe, healthy and pleasant community. Parks and recreation is an essential service, one that can impact health, crime prevention, the environment, the economy and the quality of life for Rosemount residents. ADMINISTRATION RECREATION PARKS AND RECREATION Provides for overall planning, coordination, management of personnel and admiustranon of activities within the department of Parks and Recreation. This department provides a diversified range of programs for the residents of Rosemount. The long range planning, development and budget preparation of parks and coordination with other service agencies are ongoing activities. Admiustrative senates also provide the residents of Rosemount an opportunity to reserve facihues and register for programs. 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, quahty and efficient base of programs COMMUNITY CENTER Provides for operation of a mule- purpose Community Center, which offers facilities for recreational programs, banquets, meetings, events, theatrical productions, seminars and exercise. The Community Center provides senates 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 National Guard facilities. Page One August 9, 2006 Account# 2007 BUDGET WORKSHEETS PARKS RECREATION Descnption 101 45100 101 00 Salaries Benefits 101 45100 102 00 Full -Time Overtime 101 45100 103 00 Part -Time Salaries Benefits 101 45100 xx 103 00 PIT Secretary 101 45100 10 103 00 PIT Receptionist 101 45100 12 103 00 Building Attendants 101 45100 83 103 00 Playground Recreation Leaders 101 45100 94 103 00 Warming House Attendants 101 45100 99 103 00 Park &Rec Committee 101 45100 71 103 00 KT Horticulturist 101 45100 01 203 00 Printed Forms Paper 101 45100 01 205 00 Drafting Supplies 101 45100 01 207 00 Training Instructional Supplies 101 45100 01 206 00 Miscellaneous Supplies 101 45100 01 209 00 Other Office Supplies 101 45100 01 211 00 Cleaning Supplies 101 45100 01 216 00 Chemicals Chemical Products 101 45100 01 219 00 Other Operating Supplies 101 45100 01 221 00 Equipment Parts 101 45100 01 223 00 Building Repair Supplies 101 45100 01 229 00 Other Maintenance Supplies 101 45100 01 303 00 Engineering Fees 101 45100 01 305 00 Medical Dental Fees 101 45100 01 312 00 Custodial Services 101 45100 01 315 00 Special Programs 101 45100 01 315 01 Sunday Night Specials 101 45100 01 315 02 Leprechaun Days 101 45100 01 315 03 Halloween 101 45100 01 315 04 Ground Pounders(Running) 101 45100 01 315 05 Nature Programs(Arbor Day, etc 101 45100 01 315 06 Puppet Programs 101 45100 01 315 07 Special Events 101 45100 01 315 08 Adopt -A -Park Program 101 45100 01 315 09 Miscellaneous Programs 101 45100 01 315 10 ADA Programs 101 45100 01 319 00 Other Professional Services 101 45100 01 321 00 Telephone Costs 101 45100 01 331 00 Travel Expense 101 45100 01 341 00 Employment Advertising 101 45100 01 349 00 Other Advertising 101 45100 01 349 01 Brochures 101 45100 01 349 02 Yellow Pages 101 45100 01 349 03 Special Marketing 101 45100 01 381 00 Electric Utilities 101 45100 01 383 00 Gas Utilities 101 45100 01 364 00 Refuse Disposal 101 45100 01 391 00 P C Maintenance 101 45100 01 391 C1 Annual Online Fee 101 45100 01 391 02 Annual Online Maintenance 101 45100 01 394 00 P C Software Purchases 101 45100 01 401 00 Contracted Building Repairs 101 45100 01 404 00 Contracted Mach Equip Repairs 101 45100 01 409 00 Other Contracted Repair Maint 101 45100 01 412 00 Building Rental 101 45100 01 415 00 Other Equipment Rental 101 45100 01 433 00 Dues Subscriptions 101 45100 01 433 01 MRPA Dues 101 45100 01 433 02 Miscellaneous 101 45100 01 435 00 Books Pamphlets 101 45100 01 437 00 Conferences Seminars 101 45100 01 437 01 MRPA State Conference 101 45100 01 437 02 MIAMA State Conference 101 45100 01 437 03 Workshops, Schoo Tuition 101 45100 01 439 0D Other Miscellaneous Charges PAGE TOTALS General Operating DEPARTMENT TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget All Salary Costs Inclusive of $392,557 $475,475 $576 211 $628,800 $654,000 Salary, Taxes, PERA Benefits 11,770 11,218 9 458 4,700 10 500 122,200 31 908 35,634 0 0 0 Moved Above to Full -Time 22 625 26,707 23,770 30,200 31,200 81 185 71,617 50,603 33,000 49,000 19 070 20,923 16,262 20,000 20,000 8,272 9,852 9442 13,000 13,000 1,912 1,912 2,396 2,500 2,500 0 0 14 5,000 6,500 268 0 285 0 215 983 408 1,000 0 0 0 200 576 438 0 500 1,622 1,161 437 1,600 5,846 4,845 4,254 5,500 924 941 1,181 1,500 5,208 5,224 4,903 7,000 5,560 10,115 9,424 9,500 4,624 5,284 4,194 5 500 53 0 0 0 0 Comments 0 1,000 Film Developing Laminating 200 Books, Tapes etc 500 Meeting Supplies 1,600 Envelopes, Forms, Rulers, etc 5 500 1,500 7,000 Rec Programs, 1st Aid Sup, etc 9,500 5,500 153 0 0 0 0 374 481 0 B00 600 Employment Physicals 5,969 5,983 4,899 6,500 6,500 Custodial Services- Banquet Rm 6,935 12,700 2,500 2,295 3,000 3,000 Performances 84 600 600 600 Trophies Awards 459 204 500 500 Supplies 0 46 400 400 Ribbons Mailings 1,655 2,157 2000 2,500 Trees 60 291 500 500 Tapes, Fuses Puppets, etc 339 601 1 000 1,000 Publicity Supplies 374 172 1 400 1 400 Flyers, Trees, Signs 848 827 2,000 2 000 Start Up Costs 0 0 800 800 ADA Program Supplies 347 478 1,804 2,500 2,500 ADA Services/Eng LA Sery Test 1,736 2,751 2,425 3,100 3,100 Pagers Cellular Phones 16 46 149 500 500 2,092 2,310 1,602 2 800 2,600 General Employment Ads 20,473 192 25,800 17,734 24,600 21 500 20,000 City Newsletter 3,408 3,692 3 400 3,400 Rec Ads 473 1,753 2,400 2,400 New Program Flyers 19,948 18,726 23,240 26,000 26,000 23,465 26,623 34,957 33 600 33 600 3,763 3,180 3,106 4,000 4 000 0 7,500 0 0 0 6,000 0 0 0 1,500 0 0 0 0 15,000 Purchase Online Registration Prg 13,655 8,702 18,948 16,800 14,135 2,684 1,321 1,259 1,100 978 767 400 50 19 0 100 497 5,908 7,862 10,000 5,616 4,810 8,000 19,908 19,389 20,000 17 071 16,800 16,800 12 984 14,060 18,000 1,230 1,721 2,000 0 0 300 805 463 2,200 59,667 35 281 25,004 0 $814,625 $872 360 $914,988 $967,700 $1,039,100 $814,625 $672 360 5914,988 $967,700 $1 039 100 10,000 8 000 20,000 Air Handler Maintenance Contract 16 600 Monthly Rent Payments to Guard 18,000 Portable Toilets Other Rentals 1,900 1,500 Minn Recreation Parks Assn 400 Paper, Magazines JC Dues, etc 100 4,500 2,000 300 2,200 0 Donation Account Page Two August 9, 2006 2007 BUDGET WORKSHEETS PARKS RECREATION 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments $102,500 101 45100 71 Horticulturist $2,584 $0 $0 $0 $0 101 45100 51 Softball 44,322 46,211 47,639 40,000 51,000 101 45100 82 Volleyball 575 335 40 900 900 101 45100 84 Tennis 956 803 1,042 800 800 101 45100 85 Tiny Tots 16 419 16,406 18,739 19,000 19 000 101 45100 86 Rosettes 988 1230 784 2,000 2,000 101 45100 87 Trips 2,878 9,055 10,737 3,000 3,000 101 4510C 88 Broomball 0 0 0 0 0 101 45100 89 Outdoor Skating Lessons 0 73 135 400 400 101 45100 90 Run for the Gold 2,902 3,203 2,655 3,000 3,000 101 45100 91 Camps 3,884 8,292 13,634 4,000 4,000 101 45100 92 Adult Basketball 74 0 176 1,900 1,900 101 45100 93 Other Programs 6,487 8,553 11,331 6 500 6,500 101 45100 95 T Ball 5,546 4,171 4,354 5 000 5,000 101 45100 96 Teen Night 4,861 5,540 7,575 5,000 5,000 101 45100 98 Soccer Lessons 0 4,608 385 0 0 101 45100 71 103 00 Part -Ttme Salaries 2,58 0 0 0 0 See Above 101 45100 81 103 00 Part Time Salaries 24,27 22,634 25,910 24,300 7,000 101 45100 81 219 00 Operating Supplies 8,09 11,912 9,176 11,000 11 000 101 45100 81 311 00 Officiating Fees 8,57 6,273 8,784 0 28,000 101 45100 81 319 00 Otner Professional Services 3,37 5,393 3,767 4,700 5,000 101 45100 82 103 DO Part-Time Salaries 0 0 0 0 101 45100 82 219 00 Operating Supplies 57 335 40 900 900 101 45100 82 311 00 Officiating Fees 0 0 0 0 101 45100 82 319 00 Other Processional Services 0 0 0 0 101 45100 84 103 00 Pail-Time Salaries 90 803 998 650 650 101 45100 84 219 00 Operating Supplies 5 0 45 150 150 101 45100 85 103 00 Part-Time Salaries 15 13 14,170 16,289 18,000 18,000 101 45100 85 219 00 Operating Supplies 1,28 2,236 2,451 1,000 1 000 101 45100 86 103 00 Part-Time Salaries 62 566 247 1,200 1,200 101 45100 86 219 00 Operating Supplies 36 664 537 800 800 101 45100 87 103 00 Part-Time Salaries 1,151 769 0 0 101 45100 57 219 00 Operating Supplies 2,87 7,905 9,969 3,000 3 000 101 45100 88 219 00 Operating Supplies 0 0 0 0 101 45100 88 311 00 Officiating Fees 0 0 0 0 101 45100 89 103 00 Part-Time Salaries 73 135 400 400 101 45100 89 219 00 Operating Supplies 0 0 0 0 101 45100 90 219 00 Operating Supplies 2,90 3,203 2,655 3,000 3,000 101 45100 91 103 00 Part-Time Salaries 1,96 5,877 6,772 2,000 2 000 101 45100 91 219 00 Operating Supplies 1 91 2,415 6,662 2000 2,000 101 45100 92 219 00 Operating Supplies 7 0 176 1, 1,900 101 45100 93 103 00 Part-Time Salaries 2,10 3,019 2,750 2,000 2,000 101 45100 93 219 DO Operating Supplies 4,37 5,534 8,581 4,500 4 500 101 45100 95 103 00 Part-Time Salanes 4,34 3,106 3,103 4,000 4,000 101 45100 95 219 OC Operating Supplies 1,20 1 065 1,251 1,000 1,000 101 45100 96 103 00 Part-Time Salaries 453 1,220 0 0 101 45100 96 219 00 Operating Supplies 4,861 5,087 6,355 5,000 5,000 101 45100 98 103 00 Part -Time Salaries 0 0 0 0 0 101 45100 98 229 00 Operating Supplies 0 4,608 365 0 0 SPECIAL PROGRAM TOTALS GRAND TOTAL PARK REC 92,47 108,481 119 205 91,500 102,500 92 475 108,481 119,205 91,500 102,500 $907,100 $980,841 $1,034,194 $1,059,200 $1,141,600 See Above GENERAL ADMINISTRATIVE CAPITAL IMPROVEMENT PLAN (CIP) Provides for specific funding of items, the nature of which are not considered "current" in their use or hfe expectancy These items are generally of a higher estimated cost than $5,000 and will have a life expectancy of 3 years or greater The source of funding for these expenditures is typically the general tax levy In some instances, other funding is utilized. For example, beginning in 1996, revenues received from user fees have been designated m the CIP funds for capital equipment purchases or for street projects such as gravel road resurfacing If these revenues are relined, the egmpment or project will be completed and if the revenue is not reahzed the equipment or project will not be completed Individual departments are designated for each item proposed for purchase in this plan. Included are three separate funds to isolate and better track the types of capital improvements being planned for The following briefly describes each of the three. Building CIP Fund This fund is used to account for the on -going capital improvements and possible additions to government buildings Street CIP Fund This fund is used to account for the on -going street construction and reconstruction projects within the City and all other major maintenance items related to both paved and unpaved streets including, but not limited to, street hghts, signal hghts, sidewalks and gravel road resurfacing. Equipment CIP Fund This fund is used to account for the on -going replacement of and additions to City equipment The CIP budgets included with this document are for the year 2006 only. As part of a long -range planning process, a 10 -year CIP working plan has been adopted for the years 2006 through 2015. This is a working plan only, with the current year (2006 in this case) being approved as part of the formal budget process. n 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 1 2007! 2007 2007 2007 2007 2007 2007 2007 2007 1 20071 2 007 7, 1 vvv NN rT -z Totals Shannon Porid Outlet (Storrs CIP 5) Well #15 Construction Well *1h I and Acguisltinn Paint Connemara Toner Structural Repave Crane Box fur Utility Vehicle #342) Sweeper (Replare #442) Pickup (Replace 4345 1 -Ton Pickup (Replace #144) Inspection Vehicle (Replace #308) Inspection Vehicle (Replace #500) PW Building Addition LeasefPuigbase (Year 9 of 20) County Road 42 US Highway 52 (Design (-osts) Department Issued Handguns Emer eno E ui •ment for S• uads Installation Brockway Park Built Purchase Land for Athletic Complex Parks Master Plan Update Construction of Parking Lot for Disc Colt Course Radio Replacements (Replace Obsolete) City -Wide Software PC Primer Replacements PC Workstation Upgrades (Proin 2003) Paint Ceilm9 "Welcome to Rosemount" Signs Item Desenption Puh Works Pub Works Pub Works Pub Works 'Pub Works Pub Works Pub Works Pub Work Pub Works Pub Works Pub Works Pub Workb Pub Works 1 Pub Works Polire Polre Police Polire Police Police Park Rec Park Rec Park Rec. Park Reo Park Rec Park Rec Fire Gen'I Govt Comm Dee Council Council Arena Department I 24.000 24,000 r d m E. 7 ITN 0 m 1,050,000 I 300,000 50 000 700,000 Street CIP Levy 333,000 000 09 000'01 7 000 15,000 50 000 10,000 70,11(10 20,000 a —.0 1,000,000 I 1,000,000 a I 468,000 400,000 15,000 30,000 8 000 15,000 c a 3 L600,000 I 600,000 y m 3 Fe> 1 500 000 1 1,250 000 250,000 o c 3 gr 0 nm o 1,050,000 850,000 200,000 C y 'm 3 641 000 I 500,000 1 59,000- 15 000 100,000 10,000 i l I 141,000 16 000 15 000 1 00,000 10,000 Ci v£ 2A 131,000 I 15,000 I 15,000 100,000 6 437,153 349 198 87,955 0 0 2 11,910,500 I 160 000 I 45,000 22,000 22,000 000 on' t. 000'ooz I 140,000 9,000 1 5,000,000 7.500 I 4,500,000 47 000 other I (7) (3) (2) 1,250,000 19 305,6531 48 000 160 000 250,000 45,000 45 000 22,000 22.000 1,200,000 3,770,000 44,000 50 000 000 Z6 o00'0b5 18,0001 50.0001 15,000 I 5,000,000 7 500 400,000 4.500.000 ria 30,000 a,a6o 15,000 000 08 000 0 k 3 87,955 47 000 I 20 000 Total Cost n GENERAL ADMINISTRATIVE INSURANCE 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 Clues 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 m the past But, this allows us to build a special fund for msurance purposes that will allow the City to move towards self insurance, and ulnmately, lower rates. We do not anticipate ever being totally self insured, but by raismg our deductibles we approach that point and allow ourselves to save substannally on our annual insurance premiums. Doing so will allow the City to operate more efficiently and save the taxpayers money without taking undue nsks Page One August 9, 2006 Account 206 31010 00 206 33100 00 206 36210 00 206 36214 00 206 36215 00 206 36260 00 Account Description Current Ad Valorem Taxes Federal Grants Aids Interest Earnings- Investments Net Change in FV- Investments Interest Earnings Other Revenue FUND TOTALS 206 49006 01 221 00 Equipment Parts 2007 BUDGET WORKSHEETS INSURANCE REVENUES INSURANCE EXPENDITURES Description 206 49006 01 304 00 Legal Fees 206 49006 01 305 00 Medical Dental Fees 206 49006 01 317 00 General Fund Administrative Fees 206 49006 01 319 00 Other Professional Services 206 49006 01 365 00 Worker's Compensation Insurance 206 49006 01 369 00 Other Insurance 206 49006 01 409 00 Other Contracted Repair Maint 206 49006 01 439 00 Other Miscellaneous Charges FUND TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $210,000 $225,000 $255 000 $260,000 0 0 0 0 8,735 4,044 12,452 5,000 0 0 0 0 240 397 401 500 30,749 34,443 40,083 26,000 249,724 263,884 307,936 291 500 2003 Actual $1,096 $77 $232 $2,000 287 500 2006 2007 Object 2007 2004 2005 Adopted Detail Proposed Actual Actual Budget Amount Budget 261 114 242,189 229,691 291,500 NOTE Levy of $260000 covers costs for consultant fees and all insurance premiums All other expenditures covered through interest earnings and insurance refunds /dividends 287 500 Comments $260,000 0 5 000 0 Annual Market Value Changes 500 22,000 Insurance Refunds/Dividends Comments $2,000 Liability Auto Deductible Pymts 0 3,981 0 3,000 3,000 Unreimbursable Legal Fees 3,489 3,916 3,517 15,000 10,000 Work Comp Deductible Pymts 2,500 2,500 2 500 2,500 2,500 Yearly Fee Per Policy F -3 23,010 16,560 16,970 25,000 20,000 Risk Management Consultant 77,867 76,884 61,646 80,000 75,000 Annual Premium 141,668 131,841 133,147 155,000 165,000 Annual Premium General Liability 11,445 6,431 11,677 9,000 10,000 Liability Auto Deductible Pymts 0 0 0 0 0 GENERAL /ADMINISTRATIVE PORT AUTHORITY 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 Authonty will continue to work on other development and redevelopment projects related to commercial and industrial development. Page One August 9, 2006 2003 2004 Account Description Actual Actual 201 31010 00 201 31050 00 201 3313D DD 201 3342500 201 3410900 201 3610500 201 36210 00 201 36211 00 201 3621200 201 36215 D0 201 36230 00 201 36260 00 201 36265 00 201 39101 00 Account 2007 BUDGET WORKSHEETS PORT AUTHORITY REVENUES Current Ad Valorem Taxes Tax Increments Federal Grants -CDBG Other State Grants Aids Other Charges for Services Principal on Notes Interest Earnings Investments Interest Earnings Loch Interest Earnings Blake Interest Earnings C o ntnb utions /Donatons Other Revenue Use of Reserve Funds Sales of General Fixed Assets FUND TOTALS Description EXPENDITURES 201 46300 99 103 00 Part-Time Salaries Benefits 201 46300 01 303 00 Engineering Fees 201 46300 01 304 00 Legal Fees 201 46300 01 307 00 Managment Fees Air Cargo 201 46300 01 313 00 Temporary Service Fees 201 46300 01 315 00 Special Programs Downtown 201 46300 01 315 01 Downtown Planning Consultant 201 46300 01 315 02 Downtown Communications Plan 201 46300 01 315 03 Downtown Ombudsman 201 46300 01 315 04 Downtown Design Standards 201 46300 01 315 05 Downtown Market Study Update 201 46300 01 317 00 General Fund Administrative Fees 201 46300 01 319 00 Other Professional Services 201 46300 01 319 01 Project Management Consultant 201 46300 01 319 02 Marketing 201 46300 01 319 03 County TIP Charges 201 46300 01 319 04 P/A Property Tax Payments 201 46300 01 322 DO Postage Costs 201 46300 01 349 00 Other Advertising 201 46300 01 351 OD Legal Notices Publishing 201 46300 01 359 00 Other Printing Binding Costs 201 46300 01 365 00 Workers Comp Insurance 201 46300 01 369 00 Other Insurance 201 46300 01 381 00 Electric Utilities 201 46300 01 389 00 Other Utility Services 201 46300 01 433 00 Dues Subscriptions 201 46300 01 433 01 Professional Organizations /Journals 201 46300 01 433 02 Foreign Trade Zone Commission 201 46300 01 437 OD Conferences Seminars 201 46300 01 439 00 Other Miscellaneous Charges 201 46300 01 521 00 Building Structure Purchases 201 46300 01 525 00 Building Structure Purchases 201 46300 01 530 00 Improvements Other Than Bldgs 201 46300 01 710 00 Transfers FUND TOTALS $0 0 13,403 0 50,00 0 433,041 39,83 5 002 4,2 1 966 8,066 7,50 286 30 0 16,000 0 0 $60,00 $60,00 41,51 42,30 2,81 2,00 6,99 6,30 27 40 15,00 18,90 $477,764 $101 910 $126,599 $129,900 2003 2004 Actual Actual $3,18 $3,71 3,47 6,58 3,38 36 28,45 1,19 30,92 7,17 5,04 9,5 2006 2007 Object 2007 2005 Adopted Detail Proposed Actual Budget Amount Budget 2005 Actual $3,1 4,74 52 6,00 6,00 6,00 69,36 33 301 8,53 96 9,90 11,46 41 93 3,24 94 86 19 51 48 36 2,13 2,72 2,22 11 14 17 28 50 66 49 15,4 448 15,000 528 3,043 4,403 1,229 0 457 0 425,532 0 0 0 67,000 9,950 4,398 0 2006 Adopted Budget $5,00 5,00 25,00 6,00 25,00 10 00 4,00 3,00 11,00 20 10,00 5 0 4 0 20 1,00 1,500 15,000 3,000 500 0 0 0 0 0 0 0 0 15,000 10,000 4,000 0 1,500 15,000 36,40 2,00 6,00 40 125 10 $169 900 2007 Object 2007 Detail Proposed Amount Budget 3 000 11,000 200 10,000 500 4,000 200 1,000 $114,911 $561048 $121,943 6129,900 $169,900 Comments Operating Levy Admin Fees Portion Only LCDA Downtown Grant Blake LT Lease Interest Earned on CD's Paid Off in 2003 Blake L/T Lease Interest Checking Interest Misc 5 000 25,000 50,000 (EIS) or (AUAR) 0 0 Comments All Salary Costs Inclusive of $5,000 Salary, Taxes, PERA Benefits Port Authority Members 6,000 Yearly Fee Per Policy F -3 29,000 Additional Marketing Commissioners Property Insurance Business Park Sign Stormwater Fees 16,500 Prof Organizations /Journals 3,000 Development/TIF /Miscellaneous 500 Contingencies 0 0 0 Special Downtown Projects 0 0 0 0 0 Page One 2007 BUDGET WORKSHEETS ENDRES PROCESSING DISTRICT(0069) REVENUES August 9, 2006 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Descnption Actual Actual Actual Budget Amount Budget 244 31050 00 Tax Increments $31,039 $27,193 $24,780 $27,000 $25,000 Endres Processing Disinct Only 244 36215 00 Interest Earnings 0 0 0 244 36260 00 Other Revenue 0 0 0 FUND TOTALS EXPENDITURES $31 039 $27,193 $24,780 $27,000 $25,000 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments Comments 244 49044 01 530 00 Improvements Other Than Bldgs $31,039 $27,193 $24,780 $27,000 $25,000 244 49044 01 530 00 Endres Processing -Pay as You Go 27,000 FUND TOTALS 531,039 $27,193 $24,780 $27,000 $25,000 Page One August 9, 2006 Account 2007 BUDGET WORKSHEETS DOWNTOWN/BROCKWAY DISTRICT(010B) REVENUES Descnption FUND TOTALS EXPENDITURES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $0 $227 $1,374 $0 $50,000 242 31050 00 Tax Increments SO $0 $0 $0 $50,000 242 36210 00 Interest Earnings Investments 0 152 1,217 0 0 242 36215 00 Interest Earnings 0 75 157 0 0 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments Comments 242 49042 01 319 00 Other Professional Services $0 $15,659 $56,880 $0 $0 242 49042 01 522 00 Building Structure Purchases 0 181491 194,590 0 0 242 49042 01 530 00 Improvements Other Than Buildings 0 0 0 0 50,000 Pay -As -You Go to CPDC 242 49042 01 611 00 Interest on Internal Loan 0 0 17,785 0 0 FUND TOTALS $0 $197,151 $269,255 $0 $50,000 GENERAL ADMINISTRATIVE DEBT SERVICE FUNDS Debt Service Funds are Governmental Funds set up to provide for the repayment of debt of the City. This debt is normally accomphshed through the issuance of bonds secured by the full faith and credit of the City. Repayment of the debt is usually accomphshed through the collection of special assessments, general levies of the City collected through property taxes, tax increment funds, core funds, transfers from Enterprise Funds (Revenue Debt Issues) and transfers from other areas. Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 614 G 0 STORM WATER REVENUE BONDS, 1996B REVENUES September 5, 2006 Account Description 614 31010 00 614 36101 00 614 36102 00 614 36210 00 614 36215 00 614 36265 00 614 37145 00 614 37160 00 614 39202 00 614 39203 00 614 39204 00 614 39205 00 614 39206 00 614 39207 00 614 39310 00 FUND TOTALS 614 47000 01 710 00 Transfers Current Ad Valorem Taxes Principal Special Assessments Penalties Interest S/A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Water Revenues Penalties Surcharge Revenues ContnbWon From Enterpnses Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Port Authority Bond Proceeds FUND TOTALS EXPENDITURES 614 47000 01 317 00 General Fund Admin Fees 614 47000 01 319 00 Other Professional Services 614 47000 01 601 00 Bond Pnncipal 614 47000 01 611 00 Bond Interest 614 47000 01 614 00 Amortization of Bond Discount 614 47000 01 621 00 Bond Payrng Agent Fees 2003 Actual 2,07 6 50,00 128,39 50,00 $230,55 2004 Actual 2005 Actual 2,56 5,46 3 4 51,00 50,00 51,00 50,00 2006 2007 Adopted Proposed Budget Budget Comments 50,50 52,00 50,500 5200 0 0 $104,606 $105,514 $101,000 $104,000 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments $0 $0 $0 $0 $0 0 0 0 0 0 60,000 65,000 65,000 70,000 75,000 38,498 35,273 31,964 29,900 26,100 817 817 817 900 900 193 193 193 200 200 0 0 0 0 0 $99,509 $101,284 $97,974 $101,000 $102,200 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 384 G 0 PORT AUTHORITY MUNICIPAL BUILDING REFUNDING BONDS, 1998A REVENUES September 5, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget 384 31010 00 384 36101 00 384 36102 00 384 36210 00 384 36215 00 384 36265 00 384 37145 00 384 39101 00 384 39202 00 384 39203 00 384 39204 00 384 39205 00 384 39206 00 384 39207 00 384 39310 00 Account Current Ad Valorem Taxes Principal Special Assessments Penalties Interest S/A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Water Revenues Sale of General Fixed Assets Contribution From Enterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Port Authority Bond Proceeds FUND TOTALS EXPENDITURES 384 47000 01 317 00 General Fund Admin Fees 384 47000 01 319 00 Other Professional Services 384 47000 01 710 00 Transfers FUND TOTALS $348,50 58,47 3 156,65 $368 1 4,34 $383,516 $255,38 $258,95 0 0 8,026 3 $563,663 $372 563 $391,576 $255,3B4 9250,957 Comments 2006 2007 2003 2004 2005 Adopted Proposed Description Actual Actual Actual Budget Budget Comments $0 so 50 $0 $0 0 0 0 0 0 384 47000 01 601 00 Bond Principal 1,620 000 125,000 135 000 135,000 145,000 Refunding for 1992E Paid 2/1/03 384 47000 01 611 00 Bond Interest 115,663 112,925 107,268 101,300 95,000 384 47000 01 621 00 Bond Paying Agent Fees 705 0 0 0 0 0 0 0 0 0 $1,736,368 $237,925 $242 268 $236,300 $240,000 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 332 G 0 IMPROVEMENT BONDS, 1998A REVENUES September 5, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget 332 31010 00 Current Ad Valorem Taxes 332 36101 00 Principal Special Assessments 103,34 116,06 64,89 332 36102 00 Penalties Interest S/A 25 6,89 1,94 332 36210 00 Interest Earnings Investments 12,05 17,09 12,38 332 36215 00 Interest Earnings 16 4 2 332 36265 00 Use of Reserve Funds 332 37145 00 Surcharge on Water Revenues 332 37160 00 Penalties Surcharge Revenues 332 39202 00 Contribution From Enterprises 332 39203 00 Transfer From 94,10 332 39204 00 Transfer From Water Core 332 39205 00 Transfer From Sewer Core 332 39206 00 Transfer From Storm Core 332 39207 D0 Transfer From Port Authority 332 39310 00 Bond Proceeds FUND TOTALS $209,91 EXPENDITURES 226,00 212 00 $140,103 $79,250 $226,000 $212,000 2006 2007 2003 2003 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget 332 47000 01 317 00 General Fund Admin Fees 332 47000 01 319 00 Other Professional Services Comments Comments $D $0 $0 $0 50 0 0 0 0 0 332 47000 01 601 00 Bond Principal 205,000 200,000 195,000 195,000 190 000 332 47000 01 611 00 Bond Interest 55 820 47,215 38,674 30,100 21 500 332 47000 01 621 00 Bond Paying Agent Fees 771 1,046 526 900 500 332 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $261,591 $248,261 $234,200 $226,000 $212,000 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 335 G 0. IMPROVEMENT BONDS, 1999A REVENUES September 5, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget 335 31010 00 Current Ad Valorem Taxes 335 36101 00 Pnncipal Special Assessments 696,96 33,91 32,36 335 36102 00 Penalties 8 Interest S/A 36 335 36210 00 Interest Earnings Investments 30,95 24,564 30,99 335 36215 00 Interest Earnings 57 4 4 335 36260 00 Other Revenue 38 335 36265 00 Use of Reserve Funds 335 37145 00 Surcharge on Water Revenues 335 37160 DO Penalties Surcharge Revenues 335 39202 DO Contribution From Enterpnses 335 39203 00 Transfer From 335 39204 00 Transfer From Water Core 335 39205 00 Transfer From Sewer Core 335 39206 00 Transfer From Storm Core 335 39207 00 Transfer From Port Authority 335 39310 00 Bond Proceeds FUND TOTALS 335 47000 01 710 DO Transfers FUND TOTALS EXPENDITURES 335 47000 01 317 00 General Fund Admin Fees 335 47000 01 319 00 Other Professional Services 328,60 312,20 $728,860 $58,907 $63,411 $326 60 $312,200 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments Comments $o $0 $0 $0 $0 0 0 0 0 0 335 47000 01 601 00 Bond Principal 495,000 485,000 475,000 265,000 260,000 335 47000 01 611 00 Bond Interest 120,766 99,698 79,058 63,200 51,800 335 47000 01 621 00 Bond Paying Agent Fees 403 403 403 400 400 0 0 0 0 0 $616,170 $585,100 $554 $328,600 $312,200 Page One September 5, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget 336 31010 00 336 36101 00 336 36102 00 336 36210 00 336 36215 00 336 36265 00 336 37145 0D 336 37160 00 336 39202 00 336 39203 DO 336 39204 00 336 39205 DO 336 39206 D0 336 39205 00 336 39310 DO 2007 BUDGET WORKSHEETS DEBT SERV FUND 336 G 0 IMPROVEMENT BONDS, 1999B REVENUES Current Ad Valorem Taxes $16,434 $19,05 Principal Special Assessments 21,29 69,94 Penalties 8 Interest S. /A 17 1 Interest Ea-nings Investments 72,48 67,89 Interest Earnings 25 8 Use of Reserve Funds Surcharge on Water Revenues Penalties Surcharge Revenues Contribution From Enterprises Transfer From 192,63 Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Street CIP Bond Proceeds FUND TOTALS $110,640 $349,631 $167,155 5762,600 $281,50 EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 336 47000 01 317 00 General Fund Admin Fees 336 47000 01 319 00 Other Professional Services $19,61 99,25 3,8 44,4 5 514,86 747,71 $19,53 261 96 Comments $0 0 $0 $0 $0 0 0 0 0 0 336 47000 01 601 00 Bond Principal 600,000 625,000 655,000 685,000 225 000 336 47000 01 611 00 Bond Interest 162,868 136,218 107,730 77,300 56 200 336 47000 01 621 00 Bond Paying Agent Fees 306 316 316 300 300 336 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $763,173 $761,534 $763,046 5762,600 $281 500 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 616 G 0 STORM WATER REVENUE BONDS, 1999C REVENUES September 5, 2006 2008 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 616 31010 00 Current Ad Valorem Taxes 616 36101 00 Principal Special Assessments 616 36102 00 Penalties Interest S/A 616 36210 00 Interest Earnings Investments 616 36215 00 Interest Earnings 616 36260 00 Other Revenue 616 36265 00 Use of Reserve Funds 616 37145 00 Surcharge on Water Revenues 616 37160 00 Penalties Surcharge Revenues 616 39202 00 Contributor From Enterprises 616 39203 00 Transfer From 616 39204 00 Transfer From Water Core 616 39205 00 Transfer From Sewer Core 616 39206 00 Transfer From Storm Core 616 39207 00 Transfer From Port Authonty 616 39310 00 Bond Proceeds FUND TOTALS EXPENDITURES $o 0 0 6,165 4,94 61 3 0 7 42,000 41,00 42,00 41,00 10,31 4 $90 226 $87,06 $94,35 42,00 41,50 4300 42,00 41,50 43,00 $83,000 $86,000 2006 2007 2003 2004 2005 Adopted Proposed Account# Descnpbon Actual Actual Actual Budget Budget Comments 616 47000 01 317 00 General Fund Admin Fees 616 47000 01 319 00 Other Professional Services $0 $0 $0 $0 $0 0 0 0 0 0 616 47000 01 601 00 Bond Pnncipal 45,000 45,000 50,000 50,000 55,000 616 47000 01 611 00 Bond Interest 36,944 34,829 32 498 31,200 28 700 616 47000 01 614 00 Amortization of Bond Discount 1,103 1,103 1,103 1,100 1,100 616 47000 01 621 00 Bond Paying Agent Fees 403 403 403 700 400 616 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $83,450 581,334 $84,004 583 000 $85,200 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 617 G 0 WATER REVENUE BONDS, 2000A REVENUES September 5, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 617 31010 DO Current Ad Valorem Taxes 617 36101 00 Principal Special Assessments 617 36102 DO Penalties Interest S/A 617 36210 DO Interest Earnings Investments 617 36215 DO Interest Earnings 617 36265 DO Use of Reserve Funds 617 37145 00 Surcharge on Water Revenues 617 37160 00 Penalties Surcharge Revenues 617 39202 DO ContnbWOn From Enterprises 617 39203 DO Transfer From 617 39204 0O Transfer From Water Core 617 39205 00 Transfer From Sewer Core 617 39206 00 Transfer From Storm Core 617 39207 00 Transfer From Port Authority 617 39310 00 Bond Proceeds EXPENDITURES 617 47000 01 317 00 General Fund Admin Fees 617 47000 01 319 00 Other Professional Services 22 3 98,41 111,00 80 2 112,00 2,65 42 115,00 113,0 115 00 FUND TOTALS $209,671 $112,825 $118,092 $113,000 $115,000 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments $o $0 $0 10 $0 0 0 0 0 0 617 47000 01 601 00 Bond Principal 55,000 60,000 65,000 65,000 70 000 617 47000 01 611 00 Bond Interest 53,465 50,785 47,619 46,100 43,000 617 47000 01 614 00 Amortization of Bond Discount 1,351 1,351 1,351 1,400 1,400 617 47000 01 621 00 Bond Paying Agent Fees 316 316 316 500 600 617 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $110,132 $112,452 5114,487 $113,0 0 $115700D Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 337 G 0 IMPROVEMENT BONDS, 2001A REVENUES September 5, 2006 Account Descnption Actual Actual Actual Budget Budget Comments 337 31010 00 Current Ad Valorem Taxes SO $116,066 337 36101 00 Principal Special Assessments 72,248 14,161 13,53 337 36102 00 Penalties Interest S/A 141 1 337 36210 00 Interest Earnings Investments 2,361 4,58 12,45 337 36215 00 Interest Earnings 5 2 3 337 36265 00 Use of Reserve Funds 337 37145 00 Surcharge on Water Revenues 337 37160 00 Penalties Surcharge Revenues 337 39202 00 Contribution From Enterprises 337 39203 00 Transfer From 141,66 337 39204 00 Transfer From Water Core 154 00 170,00 166,00 337 39205 00 Transfer From Sewer Core 337 39206 00 Transfer From Storm Core 337 39208 00 Transfer From Street CIP 337 39310 00 Bond Proceeds 337 47000 01 710 00 Transfers FUND TOTALS $370,49 2006 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget Comments 337 47000 01 317 00 General Fund Admin Fees 337 47000 01 319 00 Other Professional Services 337 47000 01 601 00 Bond Principal 105,000 125,000 125,000 130,000 130,000 337 47000 01 511 00 Bond Interest 48,880 45,274 41,118 36,700 31,900 337 47000 01 621 00 Bond Paying Agent Fees 374 403 403 1,300 400 FUND TOTALS EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed 166,0 163,00 $304,85 $192,016 $168,000 $163,000 $o $0 50 $0 50 0 0 0 0 0 0 0 0 0 0 $154 254 $170,676 $166 520 $168,000 $162,300 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 612 G 0 STORM WATER REVENUE BONDS, 20018 REVENUES September 5, 2006 Account Descnption 612 31010 00 612 36101 00 612 36102 00 612 36210 00 612 36215 00 612 36265 00 612 37145 00 612 37160 00 612 39202 00 612 39203 00 612 39204 00 612 39205 00 612 39206 00 612 39207 00 612 39310 00 Current Ad Valorem Taxes Pnncipal Special Assessments Penalties Interest S/A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Water Revenues Penalties Surcharge Revenues Contribution From Enterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Pon Authority Bond Proceeds FUND TOTALS EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget 612 47000 01 317 00 General Fund Admin Fees 612 47000 01 319 00 Other Professional Services 612 47000 01 601 00 Bond Principal 612 47000 01 611 00 Bond Interest 612 47000 01 614 00 Amortization of Bond Discount 612 47000 01 621 00 Bond Paying Agent Fees 612 47000 01 710 00 Transfers FUND TOTALS 2006 2007 2003 2004 2005 Adopted Proposed Actual Actual Actual Budget Budget Comments 12 11 2,80 4 3 1 45,00 54,00 53,00 153,76 45 00 54,00 53,00 $90,16 $261,912 5108,817 $110,000 $106,000 0 0 $o 0 55,0 55,0 53,00 53,00 Comments $0 so $0 0 0 0 40,000 60,000 60,000 65,000 65,000 48,185 45,851 43,451 42,000 39 400 1,303 1,303 1,303 1,300 1,300 374 605 403 1,700 300 0 0 0 0 0 $89,862 $107,959 $105,156 $110000 $106,000 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 382 G 0 PORT AUTHORITY PUBLIC FACILITY BONDS, 2001C REVENUES September 5, 2006 Account 382 31010 00 382 36101 00 382 36102 00 382 36210 00 382 36215 00 382 36265 00 382 37145 00 382 39101 00 382 39202 00 382 39203 00 382 39204 00 382 39205 00 382 39206 OD 382 39207 00 382 39310 OD Account 382 47000 01 317 00 382 47000 01 319 00 382 47000 01 601 00 382 47000 01 611 00 382 47000 01 621 00 382 47000 01 710 00 Descnptmn Current Ad Valorem Taxes Principal Special Assessments Penalties Interest S/A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Water Revenues Sale of General Fixed Assets Contribution From Enterpnses Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Port Authority Bond Proceeds FUND TOTALS Description General Fund Admin Fees Other Professional Services Bond Pnncipal Bond Interest Bond Paying Agent Fees Transfers FUND TOTALS EXPENDITURES 2003 2004 Actual Actual $170,604 $172,91 1,84 2 2,16 2 2006 2003 2004 2005 Adopted Actual Actual Actual Budget 2006 2007 2005 Adopted Proposed Actual Budget Budget Comments $169,764 $171,864 $168,50 3,07 3 $172,473 $175,119 $172865 $171,864 $168,504 2007 Proposed Budget Comments 50 $0 $0 $0 $0 0 0 0 0 0 25,000 70,000 75,000 75,000 80 000 92,980 91,080 86,180 85,200 82,100 374 403 403 400 400 0 0 0 0 0 $118,354 $161,483 $163,583 $160,600 $162,500 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 618 G 0 STORM WATER REVENUE REFUNDING BONDS, 2D01D REVENUES September 5, 2006 Account Description 618 31010 00 618 36101 00 618 36102 00 618 36210 00 615 36215 00 618 36265 00 618 37145 00 618 39101 00 618 39202 00 616 39203 00 618 39204 00 618 39205 00 618 39206 00 618 39207 00 618 39310 00 Account 616 47000 01 317 00 618 47000 01 319 00 618 47000 01 601 00 618 47000 01 611 00 618 47000 01 621 00 618 47000 01 710 00 Current Ad Valorem Taxes Principal Soecal Assessments Penalties 6 Interest S;A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Water Revenues Sale of General Fixed Assets Contribution From Enterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Port Authority Bond Proceeds FUND TOTALS Transfers FUND TOTALS EXPENDITURES Descnption General Fund Admin Fees Other Professional Services Bond Principal Bond Interest Bond Paying Agent Fees 2006 2007 2003 2004 2005 Adopted Proposed Actual Actual Actual Budget Budget 5 74,00 3 4 77,00 75,0 4 5 77,50 75,00 74,00 77,000 75,00 77,50 75,00 0 0 $148,082 $154,079 $150,098 $155,000 $150,000 2006 2007 2003 2004 2005 Adopted Proposed Actual Actual Actual Budget Budget Comments Comments so $0 $0 $0 $0 0 0 0 0 0 120,000 130,000 130,000 140,000 140 000 24,870 21,045 16,668 13,800 8,600 374 374 374 1,200 400 0 0 0 0 0 $145,244 $151,419 $147,042 $155,000 $149,000 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 394 G 0 COMMUNITY CENTER REFUNDING BONDS, 2001E REVENUES September 5, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget 304 31010 00 Current Ad Valorem Taxes 304 36101 00 Principal Special Assessments 304 36102 00 Penalties Interest S/A 304 36210 00 Interest Earnings Investments 304 36215 00 Interest Earnmgs 304 36265 00 Use of Reserve Funds 304 37145 00 Surcharge on Water Revenues 304 391 C1 00 Sale of General Fixed Assets 304 39202 00 Contribution From Enterprises 304 39203 00 Transfer From 304 39204 00 Transfer From Water Core 304 39205 00 Transfer From Sewer Core 304 39206 00 Transfer From Storm Core 304 39207 00 Transfer From Pori Authority 304 39310 00 Bond Proceeds FUND TOTALS EXPENDITURES 304 47000 01 317 00 General Fund Admin Fees 304 47000 01 319 00 Other Professional Services 304 47000 01 710 00 Transfers FUND TOTALS $93,44 8,49 1 59,67 $96,74 1,24 3 $99,878 $91,94 0 0 1,464 4 2,35 394 70 $161,835 $98,022 $101 389 $94,30 $94,704 Comments 2006 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget Comments $0 $o so $o so 9 0 0 0 0 304 47000 01 601 00 Bond Principal 0 60,000 65,000 70,000 65,000 304 47000 01 611 00 Bond Interest 28,998 28,066 26,130 23,900 21,400 304 47000 01 621 00 Bond Paying Agent Fees 374 374 374 400 400 0 0 0 0 0 $29,371 $88,441 $91 504 $94,300 $86,800 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 338 G 0 IMPROVEMENT BONDS, 2002A REVENUES September 5, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account# Description Actual Actual Actual Budget Budget 338 31010 00 Current Ad Valorem Taxes 338 36101 00 Principal Special Assessments 623,68 681,79 672,93 338 35102 00 Penalties Interest S/A 1 58 2,38 338 36210 00 Interest Earnings Investments 1 99 3,74 6,75 338 36215 00 Interest Earnings 4 2 5 338 36265 00 Use of Reserve Funds 338 37145 00 Surcharge on Water Revenues 338 37160 00 Penalties Surcharge Revenues 338 39202 00 Contribution From Enterprises 338 39203 00 Transfer From 15428 338 39204 00 Transfer From Water Core 338 39205 00 Transfer From Sewer Core 338 39206 00 Transfer From Storm Core 338 39208 00 Transfer From Street CIP 338 39310 00 Bond Proceeds FUND TOTALS EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed Account Descnpbon Actual Actual Actual Budget Budget 338 47000 01 317 00 General Fund Admin Fees 338 47000 01 319 00 Other Professional Services $6,91 688,98 $10,77 650 52 $780,012 $686,157 $682,115 $695 900 $661,300 Comments Comments $0 $0 $0 $0 $0 0 0 0 0 0 338 47000 01 601 00 Bond Pnncipal 0 630,000 655,000 635,000 620,000 338 47000 01 611 00 Bond Interest 110,649 95,050 78,956 60,500 40 900 338 47000 01 621 00 Bond Paying Agent Fees 374 374 374 400 400 338 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $111,023 $725,424 $734,330 $595,900 5661,300 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 619 G.0 WATER STORM WATER REVENUE BONDS, 2002B REVENUES September 5, 2005 Account Description Actual Actual Actual Budget Budget Comments 619 31010 00 Current Ad Valorem Taxes 619 36101 00 Principal Special Assessments 26,26 (12,19) 7,85 619 36102 00 Penalties Interest S/A 4 1 619 36210 00 Interest Earnings Investments 18 22 72 619 36215 00 Interest Earnings 4 2 5 619 36265 00 Use of Reserve Funds 619 37145 00 Surcharge on Water Revenues 619 37160 00 Penalties Surcharge Revenues 619 39202 00 Contribution From Enterpnses 1600 17,00 19,00 619 39203 00 Transfer From 619 39204 00 Transfer From Water Core 26,00 64,00 58,00 619 39205 00 Transfer From Sewer Core 619 39206 00 Transfer From Storm Core 1600 17,00 19,00 619 39207 00 Transfer From Port Authority 619 39310 00 Bond Proceeds FUND TOTALS EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed 29,00 57,00 29,00 29,00 56 00 29,00 $84,490 586,098 $104,651 $115,000 $114,000 2006 2007 2003 2004 2005 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 619 47000 01 317 00 General Fund Admin Fees 619 47000 01 319 00 Other Professional Services $0 $0 $0 $0 $0 0 0 0 0 0 619 47000 01 601 00 Bond Principal 0 40,000 50,000 70,000 70,000 619 47000 01 611 00 Bond Interest 46,809 45,708 44,233 43,100 41 000 619 47000 01 614 00 Amortization of Bond Discount 1,441 1,441 1,441 1,500 1 500 619 47000 01 621 00 Bond Paying Agent Fees 374 374 374 400 500 619 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $48,623 987,522 $96,047 $115,000 $113,000 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 385 G 0 PORT AUTHORITY BONDS (HIGHWAY 3), 2002C REVENUES September 5, 2006 Account 2006 2007 2003 2004 2005 Adopted Proposed Description Actual Actual Actual Budget Budget Comments 385 31010 00 Current Ad Valorem Taxes $263,154 $272 94 385 36101 00 Principal Special Assessments 31,971 30,16 385 36102 00 Penalties Interest S/A 12 385 36210 00 Interest Earnings Investments 1,28 4,15 385 36215 00 Interest Earnings 2 4 385 36265 00 Use of Reserve Funds 385 37145 00 Surcharge on Water Revenues 385 39101 00 Sale of General Fixed Assets 385 39202 00 Contribution From Enterprises 26,00 26,00 385 39203 00 Transfer From 252,20 385 39204 00 Transfer From Water Core 385 39205 00 Transfer From Sewer Core 365 39206 00 Transfer From Storm Core 26,00 26,00 385 39207 00 Transfer From Port Authority 385 39310 00 Bond Proceeds Account FUND TOTALS 385 47000 01 317 00 General Fund Admin Fees 365 47000 01 319 00 Other Professional Services 385 47000 01 710 00 Transfers FUND TOTALS EXPENDITURES $267,02 36,42 6 11,30 2 $265,81 $258,65 26,00 25,00 2500 26,00 25,D0 25,00 $368,441 $611,653 $366,863 $315,616 5308650 2006 2007 2003 2004 2005 Adopted Proposed Descnpaon Actual Actual Actual Budget Budget Comments 50 $0 $o $o $0 0 0 0 0 0 385 47000 01 601 00 Bond Pnncipal 0 210,000 205,000 205,000 210,000 385 47000 01 611 00 Bond Interest 64,643 57,308 52,126 46,300 39,600 355 47000 01 621 00 Bond Paying Agent Fees 374 374 374 400 400 0 0 0 0 0 $65,016 $267,681 5257,500 $251,700 $250,200 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 339 G 0 IMPROVEMENT BONDS, 2003A REVENUES September 5, 2006 Account# Descnption Actual Actual Actual Budget Budget Comments 339 31010 00 Current Ad Valorem Taxes $86,35 $86,35 Levy for St Joe's Assumed SJA 339 36101 00 Pnncipal Special Assessments 154,94 234,86 339 36102 00 Penalties Interest S/A 1,45 51 339 36210 00 Interest Earnings Investments 82 2,68 339 36215 00 Interest Earnings 2 1 5 339 36265 00 Use of Reserve Funds 155,00 63,84 339 37145 00 Surcharge on Water Revenues 339 37160 00 Penalties Surcharge Revenues 339 39202 00 Contnbution From Enterprises 43,00 44,00 44,00 44 00 339 39203 00 Transfer From 339 39204 00 Transfer From Water Core 339 39205 00 Transfer From Sewer Core 339 39206 00 Transfer From Storm Core 43,00 44,00 44,00 44,00 339 39208 00 Transfer From Street CIP 339 39310 00 Bond Proceeds 57,58 FUND TOTALS $57,611 $243,235 $326,131 $329,354 $238,20 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 339 47000 01 317 00 General Fund Admin Fees 339 47000 01 319 00 Other Professional Services 339 47000 01 601 00 Bond Pnnclpal 0 0 210,000 195,000 195,000 339 47000 01 611 00 Bond Interest 0 57 663 51,128 47,100 42,700 339 47000 01 621 00 Bond Paying Agent Fees 0 403 403 900 500 339 47000 01 710 00 Transfers FUND TOTALS EXPENDITURES- 2006 2007 2003 2004 2005 Adopted Proposed $o $o $o $o $0 0 0 0 0 0 0 0 0 0 0 $0 $58,066 $261,530 $243,000 $238,200 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 613 G 0 WATER REVENUE BONDS, 2003B REVENUES September 5, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget Comments 613 31010 00 Current Ad Valorem Taxes 613 36101 00 Pnncipal Special Assessments 613 35102 00 Penalties Interest SIA 613 35210 00 Interest Earnings Investments 613 35215 00 Interest Earnings 613 36265 00 Use of Reserve Funds 613 37145 00 Surcharge on Water Revenues 613 37160 00 Penalties Surcharge Revenues 613 39202 00 Contribution From Enterprises 613 39203 00 Transfer From 613 39204 00 Transfer From Water Core 613 39205 00 Transfer From Sewer Core 613 39206 00 Transfer From Storm Core 613 39207 00 Transfer From Port Authority 613 39310 00 Bond Proceeds FUND TOTALS EXPENDITURES 613 47000 01 317 00 General Fund Admin Fees 613 47000 01 319 00 Other Professional Services $0 0 3 11 4 32,00 14 3 134,00 134,00 138,00 2,971 32,982 $32,078 $134,176 3134,000 $138,000 2006 2007 2003 2004 2005 Adopted Proposed Account Descnpton Actual Actual Actual Budget Budget Comments 50 $0 $0 $0 $0 0 0 0 0 0 613 47000 01 601 00 Bond Pnnapal 0 0 0 105,000 110,000 613 47000 01 611 00 Bond interest 14,336 28,675 27,566 26,700 25,000 613 47000 01 614 00 Amortization of Bond Discount 926 1,652 1,852 1,900 1,900 613 47000 01 621 00 Bond Paying Agent Fees 0 0 403 400 400 613 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $15,263 530,527 $29,822 $134, 000 $137300 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 301 G.0 CAPITAL IMPROVEMENT PLAN (CIP) BONDS, 2005A REVENUES September 5, 2006 Account Description Actual Actual Actual Budget Budget 301 31010 00 Current Ad Valorem Taxes $208,97 $210 73 301 36101 00 Pnncipal Special Assessments 301 36102 00 Penaties Interest S!A 301 36210 00 Interest Earnings Investments 12 301 36215 00 Interest Earnings 2 301 36265 00 Use of Reserve Funds 301 37145 00 Surcharge on Water Revenues 301 37160 00 Penalties Surcharge Revenues 301 39202 00 Contribution From Enterprises 301 39203 00 Transfer From 301 39204 00 Transfer From Water Core 301 39205 00 Transfer From Sewer Core 301 39206 00 Transfer From Storm Core 301 39207 00 Transfer From Pon Authority 301 39310 00 Bond Proceeds 65,30 FUND TOTALS $0 $0 $65,457 $206,978 $210,737 EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed Account St Description Actual Actual Actual Budget Budget 301 47000 01 317 00 General Fund Admm Fees 301 47000 01 319 00 Other Professional Services 2006 2007 2003 2004 2005 Adopted Proposed Comments Comments $0 $0 $0 $0 $0 0 0 0 0 0 301 47000 01 601 00 Bond Principal 0 0 0 0 95,000 301 47000 01 611 00 Bond Interest 0 0 0 117,400 102,400 301 47000 01 621 00 Bond Paying Agent Fees 0 0 0 600 600 301 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $0 $0 $0 $118,000 $196,000 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 302 G 0 EQUIPMENT CERTIFICATES, 2005B REVENUES September 5, 2006 Account Descnption 302 31010 00 302 36101 00 302 36102 00 302 36210 00 302 36215 00 302 36265 00 302 37145 00 302 37160 00 302 39202 00 302 39203 00 302 39204 00 302 39205 00 302 39206 00 302 39207 00 302 39310 00 Account 302 47000 01 601 00 302 47000 01 611 00 302 47000 01 621 00 302 47000 01 710 00 Transfers Current Ad Valorem Taxes Principal Special Assessments Penalties 6 Interest S!A Interest Earnings Investments Interest Earmngs Use of Reserve Funds Surcharge on Water Revenues Penalties Surcharge Revenues Contribution From Enterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Port Authonty Bond Proceeds FUND TOTALS EXPENDITURES Description 302 47000 01 317 00 General Fund Admin Fees 302 47000 01 319 00 Other Professional Services Bond Pnncipal Bond Interest Bond Paying Agent Fees FUND TOTALS 2006 2007 2003 2004 2005 Adopted Proposed Actual Actual Actual Budget Budget 2003 2004 2005 Actual Actual Actual $347,21 1,75 $0 $1 764 $347,21 3349,198 2006 Adopted Budget $349,19 Comments 2007 Proposed Budget Comments $0 $0 $0 $0 $0 0 0 0 0 0 0 0 0 290,000 300,000 0 0 20,566 40,700 32,600 0 0 0 300 400 0 0 0 0 0 $0 $0 $20,566 $331,000 $333,000 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 610 G.O WATER REVENUE BONDS, 2005C REVENUES September 5, 2006 Account# Descnpbon Actual Actual Actual Budget Budget 610 31010 00 Current Ad Valorem Taxes 610 361M 00 Principal Special Assessments 610 36102 OD Penalties Interest S,A 610 36210 00 Interest Earnings Investments 610 36215 00 Interest Earnings 610 36265 00 Use of Reserve Funds 610 37145 00 Surcharge on Water Revenues 610 37160 00 Penalties Surcharge Revenues 610 39202 00 Contribution From Entepnses 610 39203 00 Transfer From 610 39204 D0 Transfer From Water Core 610 39205 00 Transfer From Sewer Core 610 39206 00 Transfer From Storm Core 610 39207 00 Transfer From For Authority 610 39310 00 Bond Proceeds FUND TOTALS FUND TOTALS EXPENDITURES 610 47000 01 317 00 General Fund Admin Fees 610 47000 01 319 00 Other Professional Services 2006 2007 2003 2004 2005 Adopted Proposed 10,05 60 5,70 8 233,66 1,81 22,11 240,00 338,00 $0 $0 $274,066 5240,000 $338,000 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget $0 $0 $159,381 $80 000 $338,000 Comments For 1/1/07 Used for WTP Comments $0 $0 SO $0 $0 0 0 0 0 0 610 47000 01 601 00 Bond Principal 0 0 140,000 0 235,000 (2005) Final Pymt on 1993C Issue 610 47000 01 611 00 Bond Interest 0 0 14,810 79,800 102,300 610 47000 01 614 00 Amortrzatien of Bond Discount 0 0 658 D 0 610 47000 01 621 00 Bond Paying Agent Fees 0 0 3,913 200 700 610 47000 01 710 00 Transfers 0 0 0 0 0 Page One 303 31010 00 303 36101 00 303 36102 00 303 36210 00 303 36215 00 303 36265 00 303 37145 00 303 37160 00 303 39202 00 303 39203 00 303 39204 00 303 39205 00 303 39206 00 303 39207 00 303 39310 00 2007 BUDGET WORKSHEETS DEBT SERV FUND 303 G 0 FIRE STATION REFUNDING BONDS, 2005D (Old 1996A) REVENUES September 5, 2006 Account Descnption Actual Actual Actual Budget Budget 303 47000 01 710 00 Transfers Current Ad Valorem Taxes Principal Special Assessments Penalties 8 Interest S/A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Water Revenues Penalties Surcharge Revenues Contribution From Enterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Port Authonty Bond Proceeds $156,130 0 0 731 51 FUND TOTALS $156,91 FUND TOTALS EXPENDITURES 303 47000 01 317 00 General Fund Admin Fees 303 47000 01 319 00 Other Professional Services 2006 2007 2003 2004 2005 Adopted Proposed $152,19 1,52 $153,42 1,83 3 $154,30 1,150,00 $142,52 1,109,24 $153,733 $1264,542 $1,304,308 $142,52 Comments 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments $0 $0 $0 $0 $0 0 0 4,999 0 0 303 47000 01 601 00 Bond Principal 70,000 75,000 75,000 1,165,000 85,000 303 47000 01 611 00 Bond Interest 75,410 71,820 68,033 62,000 37,100 303 47000 01 621 00 Bond Paying Agent Fees 193 193 13,553 200 400 0 0 0 0 0 $145,603 $147,013 $161,584 $1,227,200 $122,500 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 321 G 0 EQUIPMENT CERTIFICATES, 200&A REVENUES September 5, 2006 Account 321 31010 00 321 36101 00 321 36102 00 321 36210 00 321 36215 00 321 36265 00 321 37145 00 321 37160 00 321 39202 00 321 39203 00 321 39204 00 321 39205 00 321 39206 00 321 39207 00 321 39310 00 2006 2007 2003 2004 2005 Adopted Proposed Descnption Actual Actual Actual Budget Budget Comments Current Ad Valorem Taxes Pnnapal Special Assessments Penalties Interest S/A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcnarge on Water Revenues Penalties Surcharge Revenues Contribution From Enterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Pori Authonty Bond Proceeds FUND TOTALS 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 321 47000 01 317 00 General Fund Admm Fees SO $0 $0 $0 $0 321 47000 01 319 00 Other Professional Services 0 0 0 0 0 321 47000 01 601 00 Bond Pnnapal 0 0 0 0 0 321 47000 01 611 00 Bond Interest 0 0 0 0 16,100 321 47000 01 621 00 Bond Paying Agent Fees 0 0 0 0 400 321 47000 01 710 00 Transfers FUND TOTALS EXPENDITURES $0 $0 $0 $0 $94,155 0 0 0 0 0 $0 $0 $0 $0 $16,500 $67,95 6 20 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 326 G 0 IMPROVEMENT BONDS, 2006B REVENUES September 5, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Descnpbon Actual Actual Actual Budget Budget Comments 326 31010 0D Current Ad Valorem Taxes 326 36101 OD Principal Special Assessments 326 36102 OD Penalties Interest S,'A 326 36210 00 Interest Earnings Investments 326 36215 OD Interest Earnings 326 36265 0D Use of Reserve Funds 326 37145 OD Surcharge on Water Revenues 326 37160 OD Penalties Surcharge Revenues 326 39202 OD Contribution From Enterprises 326 39203 OD Transfer From 326 39204 00 Transfer From Water Gore 326 39205 00 Transfer From Sewer Core 326 39206 00 Transfer From Storm Core 326 39208 00 Transfer From Street CIP 326 39310 00 Bond Proceeds EXPENDITURES FUND TOTALS 10,00 196,00 $0 $0 $0 $206,000 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 326 47000 01 317 00 General Fund Admin Fees $0 $0 $0 $0 $0 326 47000 01 319 00 Other Professional Services 0 0 0 0 0 326 47000 01 601 00 Bond Principal 0 0 0 0 0 326 47000 01 611 00 Bond Interest 0 0 0 0 205,600 326 47000 01 621 00 Bond Paying Agent Fees 0 0 0 0 400 326 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $0 $0 $0 $0 $206,000 WATER OPERATING FUND This is an Enterprise Fund consisting of revenues from water sales that provides for the operation and maintenance of the City's wells, towers and distribution system. The City currently has three water towers (with one more under construction) and six wells (with two more under construcuon). This fund covers the operation of over 870 fire hydrants, 460 gate valves and 97 miles of watermain Page One August7, 2006 2007 BUDGET WORKSHEETS WATER UTILITY REVENUES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Descnphon Actual Actual Actual Budget Amount Budget 601 33425 00 Other State Grants Aids $1,570 $0 $0 601 34108 00 Administrative Fees -Other Funds 87,127 18,103 18,595 17,00 601 34109 00 Other Gen9 Govt Chgs for Services 0 2,336 0 601 36101 00 Principal Special Assessments 42,083 31,576 29,049 30,00 601 36102 00 Penalties Interest SA 4,780 (1,202) 1,330 601 36210 00 Interest Earnings Investments 45,288 55,429 86,611 60,00 601 36214 00 Net Change in FV- Investments (2,148) 1,128 (5 141) 601 36215 00 Interest Earnings 394 329 291 40 601 36220 00 Rents Royalties 58 266 59,983 50,641 60,00 601 36260 00 Other Revenues 0 0 100 601 36265 00 Use of Reserve Funds 0 0 0 170,00 601 37110 00 Residential Water Revenues 697,730 692,800 722,666 620,00 601 37120 00 Apartment Water Revenues 36,815 44,666 58,756 45,00 601 37125 00 Institutional Water Revenues 31,120 98,302 33635 30,00 601 37130 00 Commercial Water Revenues 50,542 49,647 50,509 50,00 601 37140 D0 Industrial Water Revenues 41,836 31 946 41,678 40,00 601 37160 DO Penalties Water Revenues 6,826 8,273 7,652 6,00 601 37165 00 Meter Maint Water Revenues 0 0 0 601 37170 00 Other Water Revenues 0 0 0 601 37180 00 Water Meter Sales Revenue 136,115 185,083 121 369 130 00 601 39103 0D Gain or Loss from HA Disposal 3 160 0 (6 898) 601 39203 00 Transfer From 0 0 109 536 5,00 30 00 80 00 40 60,00 725 90 700 00 60 00 30,00 50 00 40 00 6 00 100,00 FUND TOTALS 1,241,505 1,276,402 1,320,579 1,258,400 1,887 300 5% of 5% Fees -Const Projects Annual Market Value Changes Antenna Leases Comments Page One August 7, 2006 Account 2007 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES Description 601 49400 101 00 Salaries Benefits 601 49400 77 101 00 Administrative 601 49400 78 101 00 Technical/Clerical 601 49400 79 101 00 Maintenance 601 49400 102 00 Full -Time Overtime 601 49400 103 00 Part-Time Salaries Benefits 601 49400 99 103 01 Utility Commission Wages (50 601 49400 99 103 02 Maintenance Labor 601 49400 01 203 00 Printed Forms Paper 601 49400 01 209 00 Other Office Supplies 601 49400 01 216 00 Chemicals Chemical Products 601 49400 01 219 00 Other Operating Supplies 601 49400 01 220 00 Water Meter Purchases 601 49400 01 220 01 For Replacements 601 49400 01 220 02 For New Homes 601 49400 01 224 00 Street Maintenance Matenals 601 49400 01 225 00 Landscaping Materials 601 49400 01 227 00 Utility System Maintenance Supplies 601 49400 01 228 00 Meter Repair Materials 601 49400 01 229 00 Other Maintenance Supplies 601 49400 01 229 01 Supplies for Hydrants 601 49400 01 229 02 Valve Curb Boxes 601 49400 01 229 03 Valve Replacements (2) 601 49400 01 229 04 Miscellaneous Supplies 601 49400 01 241 00 Small Tools 601 49400 01 242 00 Minor Equipment 601 49400 01 242 01 Miscellaneous Purchases 601 49400 01 242 02 601 49400 01 303 00 Engineering Fees 601 49400 01 303 01 601 49400 01 303 02 GIS Update of Asbuitts 601 49400 01 303 03 601 49400 01 303 04 Miscellaneous Fees 601 49400 01 304 00 Legal Fees 601 49400 01 310 00 Testing Services 601 49400 01 310 01 Bacteria Water Quality 601 49400 01 310 02 V 0 C Pesticides, etc 601 49400 01 310 03 CU -PB Testing ('07 Price Increase) 501 49400 01 312 00 Gopher State One -Call 601 49400 01 313 00 Temporary Service Fees 601 49400 01 313 01 Temp Service Fees 601 49400 01 315 00 Special Programs 601 49400 01 315 01 Public Information 601 49400 01 315 02 Plan Amendments 601 49400 01 315 03 Seminars 601 49400 01 315 04 Vulnerability Assessment Imp 601 49400 01 318 00 Contract Engineer 601 49400 01 319 0D Other Professional Services 601 49400 01 319 01 Thaw Pipes, Check Leaks, etc 601 49400 01 319 02 Supervisory Controls 601 49400 01 319 03 Hazardous Chemical Permits 601 49400 01 319 04 Annual Drinking Water Report 501 49400 01 319 05 Hazardous Chemical Inventory 601 49400 01 321 00 Telephone Costs 601 49400 01 322 00 Postage Costs 601 49400 01 323 00 Radio Units 601 49400 01 331 00 Travel Expense 601 49400 01 333 00 Freight Express Expenses 601 49400 01 341 00 Employment Advertising 601 49400 01 349 00 Other Advertising PAGE TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $222,229 61,216 89,591 98,000 113,592 108,346 164,900 118 556 122,362 151,500 10,444 7 178 12,674 10,000 14,228 13,126 10,253 16,000 2,076 25 42,372 0 171,902 2,954 2,750 2,500 314 146 200 44,068 37,013 45,000 657 0 200 102,000 171,900 157,400 1,000 15 000 10,000 16,000 86,685 29,325 0 0 125,743 79,457 130,000 130,000 133 0 141 2,000 2,000 Patching for Breaks 0 0 0 500 500 Topsoil Seed Sod 6,437 5,458 5,130 0 0 0 0 17 300 300 Miscellaneous Meter Parts 4,671 12,500 1,358 1,330 4,000 4,000 0 85 1,300 1,300 O 2,229 2,200 2,200 O 0 5,000 5,000 1,879 1,154 1,381 1,000 2,000 Wrenches, Shovels, etc 4,750 953 3,000 2,133 2,478 1,500 3,000 174 1,479 1,500 0 36,003 19,000 13,116 93,86 25,000 0 0 7,000 7,000 3,505 0 0 0 6 000 12,000 0 2,830 5,01 1 000 1,000 25,336 38,000 1,654 1,30 2,000 2,000 Radon, Tn -Chi 13,348 28,16 1,000 1,000 12,722 22,000 35,000 $6 36 /Connection Annual Fee (M) 4,349 4,438 4,77 5,000 7,000 Gopher State One Call (M) 0 15,500 20,03 0 803 21,06 0 0 0 61,500 Wellhead Protection Plan 891 2,35 5 500 5,500 0 5,000 5,000 0 1,000 1,000 0 50,000 50,000 6,000 3,000 6,00 9,000 9,000 Contracted Engineer for C1ty(20 11,692 13 100 6,196 2,08 1,500 1,500 2,439 3,50 3,000 3,000 525 500 500 MN Department of Public Safety 2,436 61 0 7,500 0 52 600 600 438 432 97 0 0 3,415 3,989 4,08 4,000 6,000 Billings with Inserts 645 544 56 2,000 2,000 Replace /Repair Radios Phones 0 0 1,000 1,000 AWWA National Seminar O 18 100 100 Mail Repairs O 0 700 700 PiT'ers Personnel Changes O 0 500 500 569,022 693,703 701,119 791,000 824 400 All Salary Costs Inclusive of $431,300 Salary, Taxes, PERA Benefits 50% -601, 50% -602 100% 601 2,500 Inserts Water Bill Statements 200 Disks, Ribbons, etc 55,000 Chlorine, Flouride, Polyphos 200 Maintenance Supplies 130,000 Meters, MIU's CU Horns Page Two August 2006 Account Description 2007 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES 601 49400 01 352 00 General Notices Public Info 601 49400 01 365 00 Workers Comp Insurance 601 49400 01 369 00 Other Insurance 601 49400 01 391 00 P C Maintenance 601 49400 01 392 OD P C Accessories Supplies 601 49400 01 393 00 P C Hardware Purchases 601 49400 01 394 00 P C Software Purchases 601 49400 01 395 00 P C Repairs 601 49400 01 403 00 Contracted R M Other Impr 601 49400 01 416 00 Machinery Rental 601 49400 01 433 OC Dues Subscriptions 601 49400 01 435 OC Books Pamphlets 601 49400 01 437 0C Conferences Seminars 601 49400 01 437 01 MN Health Department School 601 49400 01 437 02 AW WA Conference 601 49400 01 439 00 Other Miscellaneous Charges 601 49400 01 521 00 Building Structure Purchases 801 49400 01 530 00 Improvements Other Than Bldgs 801 49400 01 530 01 Annual Inspection of Wells 601 49400 01 530 C2 Miscellaneous Improvements 601 49400 01 530 03 CRP of Watermain 601 49400 01 530 04 Replace Pickup #344 601 49400 01 530 05 Survey Grade GPS 601 49400 01 530 06 Crane Box for Pickup #342 601 49400 01 56D 00 Furniture 8 Fixture Purchases 601 49400 01 57D 00 Office Equipment Purchases 601 49400 01 586 00 Computer Equipment Purchases 601 49400 01 611 00 Interest on Lease Payments 601 49400 01 710 00 Transfers 601- 49400 -01 TOTALS 601 49403 01 221 00 Equipment Parts 601 49403 01 223 00 Building Repair Supplies 601 49403 01 319 00 Other Professional Services 601 49403 01 32' 00 Telephone Costs 601 49403 01 381 DO Electric Utilities 601 49403 01 383 D0 Gas Utilities 601 49403 01 409 00 Other Contracted Repairs MainI 601 49403 01 439 00 Other Miscellaneous Charges TOTAL WELL #3 601 49406 01 221 00 Equipment Parts 601 49406 01 223 00 Building Repair Supplies 601 49406 01 319 00 Other Professional Services 601 49406 01 321 00 Telephone Costs 601 49406 01 381 D0 Electric Utilities 601 49406 01 383 DO Gas Utilities TOTAL EAST SIDE W/M VAULT 601 49407 01 221 00 Equipment Parts 601 49407 01 223 00 Building Repair Supplies 601 4940 01 319 00 Other Professional Services 601 49407 01 321 00 Telephone Costs 601 49407 01 381 00 Electric Utilities 601 49407 01 383 00 Gas Utilities 601 49407 01 409 DO Other Contracted Repairs Maint 601 49407 01 439 00 Other Miscellaneous Charges 601 49407 01 530 00 Improvements Other Than Bldgs TOTAL WELL #7 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget 410 4,107 13,306 507 0 0 2,130 0 0 0 686 0 1,320 6,330 16,806 5,419 602 1,724 0 211 9,983 696 0 0 13,21 0 0 0 0 5,42 15,75 33 39 63 2 5,64 1,94 19,02 42 1,188 0 0 211 10,271 656 0 0 0 0 0 0 1,867 0 4,63 16,75 29 5 3 30 4 2 69 40 9,96 9,87 16546 62 25 58 18 5,19 4,94 5,19 21 7,13 91 2,05 12,326 15,50 31 1,80 500 4,500 14,000 500 200 4,000 2,500 500 1,000 500 6,000 0 1,867 2,112 3,300 1,000 500 500 4,500 14,000 500 200 4,000 2,500 500 16,439 14,308 21,610 20,300 20,300 Laptops (M) Comments Newsletters Water's Share of Premiums Waters Share of Premiums Auto Read Software Support 3 000 3,000 4 000 4,000 800 800 AWWA for 2 Members 300 300 Reference Materials 1,500 6,000 DNR Annual Water Use (M) 10,000 10,000 Pymt on P W Building (8 of 20) 203,500 30,000 30,000 Each Well Done Every 7 Years 30,000 30,000 100 000 100 000 Annual Pavement Management 22 500 15,000 1/3 of Total Estimated Cost 25,000 12,500 50% of Total Estimated Cost 0 16,000 1/3 of Total Estimated Cost 1,000 1 000 1,000 1,000 Chair, Table 0 0 0 0 110,52 91,84 0 0 Transfers for Other Improvements 620,042 859,029 1,070 29 1,052,800 1,082,200 1,000 1,000 500 500 1,000 1,000 Independent Inspections 300 300 7,500 7,500 Pumping Lighting 2,000 2,000 Heat Engine Backup 25,000 0 100 100 Contingencies 37,400 12,400 0 P W Building Expansion(See 521) 1,000 1,000 0 0 1,000 1 000 300 300 1,000 1,000 Pumping 8, Lighting 0 0 Heat Only 3,300 1,996 652 1,092 500 500 1,724 0 0 300 300 0 0 0 500 500 Independent Inspections 211 211 211 300 300 11,755 13,325 20,307 18,000 18,000 Pumping 8, Lighting 0 0 0 0 0 753 120 0 600 600 RTU's, Pump Motor, etc 0 0 0 100 100 Contingencies 0 0 0 0 0 Page Three August 7, 2006 2007 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES Account Description Actual Actual Actual Budget Amount Budget 601 49408 01 221 00 Equipment Parts 932 220 6,959 1,000 1,000 601 49408 01 223 00 Building Repair Supplies 0 0 0 100 100 601 49408 01 319 00 Other Processional Services 0 0 0 0 0 601 49408 01 321 00 Telephone Costs 211 211 211 300 300 601 49408 01 381 00 Electric Utilities 17,375 15,816 16,387 18,000 18,000 Pumping Lighting 601 49408 01 383 00 Gas Utilities 447 496 450 600 600 Heat Only TOTAL WELL #8 18,964 16,74 601 49409 01 221 00 Equipment Parts 1,411 601 49409 01 223 00 Building Repair Supplies 0 601 49409 01 319 00 Other Professional Services 0 601 49409 01 321 00 Telephone Costs 211 21 601 49409 01 381 00 Electric Utilities 24,048 24,04 601 49409 01 383 00 Gas Utilities 849 84 601 49409 01 439 00 Other Miscellaneous Charges 0 TOTAL WELL #9 26,519 25,09 601 49410 01 219 D0 Other Operating Supplies 0 601 49410 01 221 00 Equipment Parts 4,424 601 49410 01 223 00 Building Repair Supplies 164 601 49410 01 321 00 Telephone Costs 936 92 601 49410 01 381 00 Electric Utilities 8 716 8,49 601 49410 01 409 00 Other Contracted Repairs Maint 0 1,80 TOTAL WELL #10 601 49411 01 221 00 Equipment Parts 601 49411 01 381 00 Electric Utilities TOTAL WELL #11 601 49412 01 221 00 Equipment Parts 601 49412 01 223 00 Building Repair Supplies 601 49412 01 319 00 Other Professional Services 601 49412 01 321 00 Telephone Costs 601 49412 01 381 DO Electric Uti 601 49412 01 383 DO Gas Utilities 601 49412 01 439 00 Other Miscellaneous Charges l TOTAL WELL #12 601 49414 01 221 00 Equipment Parts 601 49414 01 223 OD Building Repair Supplies 601 49414 01 319 00 Other Professional Services 601 49414 01 321 00 Telephone Costs 601 49414 01 381 00 Electric Utilities 601 49414 01 383 00 Gas Utilities 601 49414 01 439 00 Other Miscellaneous Charges TOTAL WELL #14 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed 23,987 2,929 500 500 0 100 100 0 0 0 211 300 300 28,475 30,000 30,000 Pumping Lighting 1 042 1,500 1,500 Heat Only 0 100 100 Contingencies 32,656 1,245 D 0 0 0 D 0 0 1,24 0 39 1,01 1,41 20,000 20,000 32,500 32,500 0 1,000 1,000 156 0 0 0 100 100 935 1,000 1 000 7,961 9,000 9,000 Pumping Lighting 1,189 2900 2,900 14,240 11,220 10,241 14,000 14,000 0 0 Pumping Lighting 0 5 500 100 100 1,000 1 300 300 ,000 30,000 30,000 Pumping Lighting 1 500 1,500 Heat Only 100 100 Contingencies 33,500 33,500 500 500 100 100 1,000 1,000 300 300 30,000 30,000 Pumping Lighting 1,000 1,000 Heat Only 100 100 Contingencies 0 33,000 33,000 Comments Page Four August 7, 2006 2007 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES Account Description Actual Actual Actual Budget Amount Budget 801 49415 01 221 00 Equipment Parts 0 0 0 500 500 Touch -up Paint 601 49415 01 319 00 Other Professional Services 0 0 0 500 500 Tower Inspection 601 49415 01 381 00 Electric Utilities 0 0 0 0 0 601 49415 01 409 00 Other Contracted Repairs Maint 0 0 0 500 500 601 49415 01 439 00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies TOTAL WATER TOWER #1 0 0 1,700 1,700 601 49416 01 221 00 Equipment Parts 0 1,790 601 49416 01 319 00 Other Professional Services 0 0 601 49416 01 321 00 Telephone Costs 211 211 21 601 49416 01 381 00 Electric Utilities 612 765 1,25 601 49416 01 409 00 Other Contracted Repairs Maint 0 0 601 49416 01 439 00 Other Miscellaneous Charges 0 0 601 49416 01 530 00 Improvements Other Than Bldgs 0 0 TOTAL WATER TOWER #2 601 49417 01 221 00 Equipment Parts 0 0 0 0 0 601 49417 01 321 00 Telephone Costs 0 0 0 0 0 601 49417 01 361 00 Electric Utilities 0 0 0 0 0 601 49417 01 439 00 Other Miscellaneous Charges 0 0 0 0 0 Contingencies TOTAL WATER TOWER #4 0 0 0 0 0 (Bacardi Water Tower) 601 49418 01 221 00 Equipment Parts 0 601 49418 01 319 00 Other Professional Services 0 601 49418 01 321 00 Telephone Costs 1,873 601 49418 01 381 00 Electric Utilities 1,757 601 49418 01 409 00 Other Contracted Repairs Maint 0 601 49418 01 439 00 Other Miscellaneous Charges 0 601 49418 01 530 00 Improvements Other Than Bldgs 0 TOTAL WATER TOWER #3 (East Side Water Tower) GRAND TOTAL ALL DEPTS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed 823 2,766 1,470 3,900 628400 1 87 1,85 0 500 500 0 500 500 Tower Inspection 1,874 2,000 2,000 1,647 2,000 2,000 3,200 500 500 75 200 200 Contingencies 0 300 300 3,629 3,729 6,798 6,000 8,000 715,115 947,079 1,186,089 1,258,400 1,887,300 Comments 500 500 Touch -up Paint 500 500 Tower Inspection 300 300 1,400 1 400 500 500 200 200 Contingencies 500 625,000 Paint Tower Structural Repairs SEWER OPERATING FUND This is an Enterprise Fund consisting of revenues from sewer charges which provides for the operation and maintenance of 8 hft stations, over 70 miles of sanitary sewer lines and over 5,555 service connections for the collection and treatment of sewage. $673,000 covers one line item of the Sewer Fund budget for the charges paid to the Metropohtan Council for the City's share of the operations and debt for wastewater treatment plants within the metropolitan area These charges, which make up approxunately 50% of the Sewer Fund budget, are based on sewage flows into the Metropohtan Council's Rosemount and Empire treatment plants. Page One August 7, 2006 2007 BUDGET WORKSHEETS SEWER UTILITY REVENUES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account d Description Actual Actual Actual Budget Amount Budget 602 33425 00 Other State Grants Aids 930 0 0 0 0 602 34108 00 Admintstradve Fees -Other Funds 87,127 18,103 18,595 17,000 5 000 5% of 5% Fees -Const Projects 602 36101 00 Principal Special Assessments 64 803 48 669 44,888 40,000 40,000 602 36102 00 Penalties Interest SIA 7,029 (1,496) 2,077 0 0 602 36210 00 Interest Earnings Investments 69,345 73,386 98 577 60,000 90 000 602 36214 00 Net Change in FV- Investments (18,017) (1,438) (18,632) 0 0 Annual Market Value Changes 602 36215 00 Interest Earnings 490 476 273 600 600 602 36260 00 Other Revenues 0 0 0 0 0 602 36265 00 Use of Reserve Funds 0 0 0 235,400 163,100 602 37210 00 Residential Sewer Revenues 972,190 970,562 1,011,697 900,000 1,000,000 602 37220 00 Apartment Sewer Revenues 45,720 49,364 53,042 55,000 55,000 602 37225 00 Institutional Sewer Revenues 31,058 30,548 27,870 35,000 30 000 602 37230 00 Commercial Sewer Revenues 48,689 50,547 52,136 55,000 55 000 602 37240 00 Industrial Sewer Revenues 4,960 5274 4,966 6,000 6 000 602 37260 00 Penalties Sewer Revenues 9,345 11286 9,829 8,000 9 000 602 39103 00 Gain or Loss from F/A Disposal 352 0 (32 940) 0 0 602 39203 00 Transfer From 0 0 17,355 0 0 FUND TOTALS 1,324,041 1,255,782 1,289,532 1,432,000 1,453,700 Comments Page One August 7, 2006 Account 2007 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES D 602 49450 101 00 Salanes Benefits 602 49450 77 101 00 Administrative 602 49450 78 101 00 Technical/Clerical 602 49450 79 101 00 Maintenance 602 49450 102 00 Full -Time Overtime 602 49450 103 00 Part-Time Salaries Benefits 602 49450 99 103 01 Utility Commission Wages (50 602 49450 99 103 02 Maintenance Labor 602 49450 01 203 00 Printed Forms Paper 602 49450 01 209 00 Other Office Supplies 602 49450 01 216 00 Chemicals Chemical Products 602 49450 01 219 00 Other Operating Supplies 602 49450 01 224 00 Street Maintenance Materials 602 49450 01 225 00 Landscaping Materials 602 49450 01 227 00 Utility System Maintenance Supplies 602 49450 01 241 00 Small Tools 602 49450 01 242 00 Minor Equipment 602 49450 01 303 00 Engineering Fees 602 49450 01 303 01 GIS Update of Asbullts 602 49450 01 303 02 Rate Study 602 49450 01 303 03 42/52 Sewer Study 602 49450 01 304 00 Legal Fees 602 49450 01 312 00 Gopher State One -Call 602 49450 01 313 00 Temporary Service Fees 602 49450 01 313 01 Temp Service Fees 602 49450 01 318 00 Contract Engineer 602 49450 01 319 00 Other Professional Services 602 49450 01 319 01 Televising 602 49450 01 319 02 Root Control 602 49450 01 319 03 Supervisory Controls(Maint Cont) 602 49450 01 319 04 602 49450 01 321 00 602 49450 01 322 00 602 49450 01 323 00 602 49450 01 331 00 602 49450 01 333 00 602 49450 01 341 00 602 49450 01 349 00 602 49450 01 365 00 602 49450 01 369 00 602 49450 01 391 00 602 49450 01 392 00 602 49450 01 393 00 602 49450 01 394 00 602 49450 01 395 00 Telephone Costs Postage Costs Radio Units Travel Expense Freight Express Expenses Employment Advertising Other Advertising Workers Comp Insurance Other Insurance P C Maintenance P C Accessories Supplies P C Hardware Purchases P C Software Purchases P C Repairs 602 49450 01 403 00 Contracted R M Other Impr 602 49450 01 415 OD Other Equipment Rental 602 49450 01 416 00 Machinery Rental 802 49450 01 433 00 Dues Subscriptions 602 49450 01 435 00 Books Pamphlets 602 49450 01 437 00 Conferences Seminars 602 49450 01 439 00 Other Miscellaneous Charges 602 49450 01 521 00 Building Structure Purchases 602 49450 01 530 00 Improvements Other Than Bldgs 602 49450 01 530 01 Miscellaneous Improvements 602 49450 01 530 02 Misc Improvements /Repays 602 49450 01 530 03 CRP of Sewermain 602 49450 01 530 04 Replace Pickup #344 602 49450 01 530 05 Survey Grade GPS 602 49450 01 530 06 Crash Attenuator 602 49450 01 530 07 Crane 8 Box for Pickup #342 602 49450 01 540 00 Heavy Machinery Purchases 602 49450 01 560 00 Furniture Fixture Purchases 602 49450 01 570 00 Office Equipment Purchases 602 49450 01 602 00 Sewer Service Charges 602 49450 01 611 00 Interest on Lease Payments 602 49450 01 710 00 Transfers 602 TOTALS 2D03 Actual $222,228 2004 2005 Actual Actual 81,215 89,591 98,000 113,591 108,348 164,900 118 556 122,362 151,500 10,444 7 178 12 674 10,000 14,496 19,545 9 289 15,000 1,385 1,50 2,10 1,500 0 200 0 500 0 200 331 2,500 1,356 11 400 1,828 2,66 31 1,500 547 33 15 500 4,187 1,51 64 3,000 8,907 25 0 0 7,000 0 10,064 0 0 0 15,000 167 2,24 156 500 4,349 4 43 4 769 5,000 15,50 20,033 0 80 21,065 0 5,000 3,00 6,000 9,000 10,775 0 3,000 3,506 2,000 1,404 3,000 2,43 61 0 43 43 49 600 2,81 3,04 3,23 3,000 64 54 55 1,000 1,000 1 100 300 500 4,08 5,40 4,61 4 500 9,17 9 26 9,34 12,000 50 33 500 200 4,000 2,13 29 2,500 500 1,31 13 15,66 0 D 0 1,94 1426 510 640 546,45 5,419 5,19 17 2,000 200 2,000 6 500 300 1 08 1,30 2,000 12 12 100 1D8,59 62,25 40,1 28 597,24 4,94 0 18,35 185,98 839,964 981,437 1,432,73 2006 Adopted Budget 20 000 20 000 100,000 22,500 25,000 6,500 0 0 500 500 1,409,800 2007 Object 2007 Detail Proposed Amount Budget 102,000 171,900 157,400 1,000 14,000 7,000 0 15,000 0 3,000 2,000 3,000 20,000 20,000 100,000 15,000 12,500 6,500 16 000 0 All Salary Costs Inclusive of $431,300 Salary, Taxes, PERA Benefits 1 0 000 15,000 1,500 200 500 200 2 500 400 1,500 500 6,000 22 000 0 500 500 1,427,100 SCADA System Comments 50% 602, 50% -601 100% 602 Inserts Water Bill Statements Disks, Ribbons, etc Root Killer, Degreaser Patching Topsoil, Seed Sod Manhole Castings Wrenches, Shovels etc Jetter Attachment 500 7,000 Gopher State One -Call (M) 0 9 000 Contracted Engineer tor City(20 8 000 0 3 000 Billings with Inserts 1,000 ReplacefRepar Radios Phones 1,000 National Conference 100 Mall -in Repairs 300 P/T'ers Personnel Changes 500 4 500 Sewers Share of Premiums 12,000 Sewers Share of Premiums 300 Auto Read Software Support 200 4,000 Laptops 2 500 500 2 000 200 2 000 500 300 Reference Materials 2,000 MPCA School Miscellaneous 100 Contingencies 10,000 10,000 Pymt on P W Building (8 of 20) 190 000 Annual Pavement Management 1/3 of Total Estimatea Cost 50% of Total Estimated Cost 50% of Total Estimated Cost 1/3 of Total Estimated Cost 673,000 673,000 MWCC Charges 0 0 P W Building Expansion(See 521) 0 0 Transfers for Other Improvements Page Two August 7, 2006 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 2007 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES 602 49451 01 219 00 Other Operating Supplies 602 49451 01 221 00 Equipment Parts 602 49451 01 229 00 Other Maintenance Supplies 602 49451 01 321 00 Telephone Costs 602 49451 01 381 00 Electric Utilities 602 49451 01 403 00 Contracted R M Other Impr 602 49451 01 439 00 Other Miscellaneous Charges (City Hall) TOTAL LIFT STATION #1 602 49452 01 219 00 Other Operating Supplies 602 49452 01 221 00 Equipment Parts 602 49452 01 229 00 Other Maintenance Supplies 602 49452 01 321 00 Telephone Costs 602 49452 01 381 00 Electric Utilities 602 49452 01 403 00 Contracted R M Other Impr 602 49452 01 439 00 Other Miscellaneous Charges (Bloomfield 5th) TOTAL LIFT STATION #7 602 49453 01 219 00 Other Operating Supplies 602 49453 01 221 00 Equipment Parts 602 49453 01 229 00 Other Maintenance Supplies 602 49453 01 321 00 Telephone Costs 602 49453 01 381 00 Electric Utilities 602 49453 01 403 00 Contracted R M Other Impr 602 49453 01 439 00 Other Miscellaneous Charges (Shannon Pond) TOTAL LIFT STATION #3 (Country Hills) TOTAL LIFT STATION #4 (LeForet Add'n) TOTAL LIFT STATION #5 602 49456 01 219 00 Other Operating Supplies 602 49455 01 221 00 Equipment Parts 602 49456 01 229 00 Other Maintenance Supplies 602 49456 01 321 00 Telephone Costs 602 49456 01 361 00 Electric Utilities 602 49456 01 403 00 Contracted R M Other Impr 602 49456 01 439 00 Other Miscellaneous Charges 21 53 749 2,090 3540 2,200 2,200 21 23 21 1,80 2,014 3,174 3,34 9 0 0 100 100 1,302 2,764 500 500 0 0 200 200 211 211 300 300 577 565 800 800 0 0 200 200 0 0 100 100 Contingencies 0 0 100 100 5,344 0 500 500 0 0 200 200 211 211 300 300 289 377 1 000 1 000 0 0 200 200 0 0 100 100 Contingencies 5,844 588 2,400 2,400 602 49455 01 219 00 Other Operating Supplies 0 0 0 100 602 49455 01 221 00 Equipment Parts 0 8,014 230 500 602 49455 01 229 00 Other Maintenance Supplies 0 0 0 200 602 49455 01 321 00 Telephone Costs 211 211 211 300 602 49455 01 381 00 Electric Utilities 3,134 3,467 3,785 3,500 602 49455 01 403 00 Contracted R M Other Impr 0 0 0 200 602 49455 01 439 00 Other Miscellaneous Charges 0 0 0 100 0 0 100 100 506 3,979 500 500 0 0 200 200 211 211 300 300 2,457 2,904 2,000 2000 0 0 200 200 0 0 100 100 Contingencies 602 49454 01 219 00 Other Operating Supplies 0 0 0 100 100 602 49454 01 221 00 Equipment Parts 1,950 7,162 7,925 500 500 602 49454 01 229 00 Other Maintenance Supplies 0 0 0 500 500 602 49454 0" 321 00 Telephone Costs 211 211 211 300 300 602 49454 01 381 00 Electric Utilities 2,635 2,822 3,612 3,200 3,200 Hawkins Pond 602 49454 01 403 00 Contracted R M Other Impr 0 0 0 200 200 602 49454 01 439 00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 4,996 10,195 11,748 4,900 11,692 4,226 7,095 3,400 4,900 (Drumcliffe) TOTAL LIFT STATION #6 95 1,097 1,578 2,200 3,400 4,900 100 500 200 300 3,500 Country Hills 200 100 Contingencies 4,900 Comments O 0 100 100 134 700 500 500 O 0 200 200 169 169 300 300 794 709 800 500 0 0 200 200 O 0 100 100 Contingencies 2,200 Page Three August 7, 2006 2007 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES- 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 49457 01 219 00 Other Operating Supplies 602 49457 D1 221 00 Equipment Parts 602 49457 01 229 00 Other Maintenance Supplies 602 49457 01 321 00 Telephone Costs 602 49457 01 381 00 Electric UttlRies 602 49457 01 403 00 Contracted R M Other Impr 602 49457 01 439 00 Other Miscellaneous Charges (Glendalough Mh) TOTAL LIFT STATION #9 602 49458 01 219 00 Other Operating Supplies 602 49458 01 221 00 Equipment Parts 602 49458 01 229 00 Other Maintenance Supplies 602 49458 01 321 00 Telephone Costs 602 49458 01 381 00 Electric Utilities 602 49458 01 403 DO Contracted R M Other Impr 602 49458 01 439 00 Other Miscellaneous Charges (Meadows of (Bloomfield) TOTAL LIFT STATION #8 602 49460 01 219 00 Other Operating Supplies 602 49460 01 221 00 Equipment Parts 602 49460 01 229 00 Other Maintenance Supplies 602 49460 01 321 00 Telephone Costs 602 49460 01 381 00 Electric Utilities 602 49460 01 403 00 Contracted R M Other Impr 602 49460 01 439 00 Other Miscellaneous Charges (Glen Rose) TOTAL LIFT STATION #10 0 0 0 10 50 20 30 80 20 10 0 0 0 GRAND TOTAL ALL DEPTS 851,400 1,015,529 1,461,504 1,432,00 2,20 2,200 100 500 200 300 800 200 100 Contingencies 100 500 200 300 800 200 100 Contingencies 2,200 2,200 1,453,700 100 500 200 300 800 200 100 Contingencies STORM WATER OPERATING FUND This is an Enterprise Fund consisting of revenues from storm water utility- charges that provides for the operation and maintenance of the City's storm water facilities, which includes: 5 hft stations more than 1,900 catch basins more than 50 miles of storm sewer more than 65 storm water treatment ponds This fund pays for cleaning storm dram sumps in manholes and catch basins and for ditching m rural areas. It funds wetland investigations and the assurulauon of a wetland inventory for the City. Most of the remaining operating budget is used to pay for large projects in which debt is issued. Repayment of this debt is accomplished through fund transfers to the appropriate debt service funds. Page One August7, 2006 Account 2007 BUDGET WORKSHEETS STORM WATER UTILITY REVENUES Descnption 603 34108 00 Administrative Fees -Other Funds $87,127 $16,103 $18,595 $17,000 $5,000 5% of 5% Fees- Const Projects 603 36101 00 Pnncipal Special Assessments 48,032 22,644 8,111 30,000 30 000 603 36102 00 Penalties Interest S/A 1,997 1,933 (115) 0 0 603 36210 00 Interest Earnings Investments 47 475 47,56D 57 468 60,000 60 000 603 36214 00 Net Change in FV- Investments (8,187) 1,140 (6 472) 0 0 Annual Market Value Changes 603 36215 00 Interest Earnings 514 382 183 500 500 603 36260 00 Other Revenues 0 0 0 0 0 603 36265 00 Use of Reserve Funds 0 0 0 0 58 200 603 37300 00 Storm Water Utility Revenues 522,250 583,636 624,529 636 500 660 000 603 37360 00 Penalties Storm Water Utility 2,183 4,432 2,959 4,000 4 000 603 39203 00 Transfer From 0 0 47,845 0 0 FUND TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget 701,391 680,031 753 103 748,000 817,700 Comments Page One August 7, 2006 Account 2007 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES Descnption 603 49500 101 D0 Salanes 8 Benefits 603 49500 77101 00 Administrative 603 49500 78 101 00 TechnlcaVCIericai 603 49500 79 101 00 Maintenance 603 49500 102 00 Full -Time Overtime 603 49500 01 203 00 Printed Forms Paper 603 49500 01 204 D0 Envelopes Letterhead 603 49500 01 205 00 Drafting Supplies 603 49500 01 208 00 Miscellaneous Supplies 603 49500 01 215 DO Shop Materials 603 49500 01 219 00 Other Operating Supplies 603 49500 01221 00 Equipment Parts 603 49500 01 224 00 Street Maintenance Materials 603 49500 0' 225 D0 Landscaping Materials 603 49500 01 225 01 Rip -Rap, Matting, Rock, etc 603 49500 01 225 02 Black Dirt Seel, Sod, etc 603 49500 01 225 03 603 49500 01226 603 49500 01230 603 49500 01 241 603 49500 01 242 00 Sign Repair Materials 00 Equipment Repair Material 00 Small Tools 00 Minor Equipment 603 49500 01 303 D0 Engineering Fees 603 49500 01 303 01 Problem Area Investigatons 603 49500 01 303 02 NPDES Phase II 603 49500 01 303 03 CSMP Update 603 49500 01 304 00 Legal Fees 603 49500 01 310 00 Testing Services 603 49500 01 312 D0 Contract Inspection Fees 603 49500 01 313 DO Temporary Service Fees 603 49500 01 313 01 Temporary Service Fees 603 49500 01 315 DO Special Programs (County Program) 603 49500 01318 00 Contract Engineer 603 49500 01 319 00 Other Professional Services 603 49500 01 322 00 Postage Costs 603 49500 01 323 D0 Radio Units 603 49500 01 331 00 Travel Expense 603 49500 01 352 00 General Notices Public Info 603 49500 01 365 00 Workers Comp Insurance 603 49500 01 369 00 Other Insurance 603 49500 01 384 00 Refuse Disposal 603 49500 01 389 00 Other Utility Services 603 49500 01 391 DO P C Maintenance 603 49500 01 393 00 P C Hardware Purchases 603 49500 01 394 00 P C Software Purchases 603 49500 01 403 00 Contracted R M Other Impr 603 49500 01 403 01 Ditching 603 49500 01 403 02 Miscellaneous Repairs 603 49500 01 404 00 Contracted Mach Equip Repars 603 49500 01 416 CO Machinery Rental 603 49500 01 433 00 Dues Subscriptions 603 49500 01 435 00 Books Pamphlets 603 49500 01 437 00 Conferences Seminars 603 49500 01 437 01 Stone Water Management 603 49500 01 437 02 Hydrocad Training 603 49500 01 437 03 Wetlands Training 603 49500 01 439 00 Other Miscellaneous Charges 603 49500 01 530 00 Improvements Other Than Bldgs 603 49500 01 530 01 CRP of Storm Sewer 603 49500 01 530 02 Crash Attenuator 603 49500 01 530 03 Replace Pickup #344 603 49500 01 530 04 Crane Box for Pickup «342 603 49500 01 540 00 Heavy Machinery Purchases 603 49500 01 560 00 Furniture Fixture Purchases 603 49500 01 580 00 Other Equipment Purchases 603 49500 01 586 00 Computer Equipment Purchases 603 49500 01 71D 00 Transfers 603 49500 01 710 01 1/2 of 2007 P I Payments(1996B) 603 49500 01 710 02 1/2 of 2007 P I Payments(1999C) 603 49500 01 710 03 112 of 2007 P I c ayments(20015) 603 49500 01 710 D4 1/2 of 2007 P I Payments(2001D) 603 49500 01 710 05 1/2 or 2007 P I Payments(20029) 603 49500 01 71 0 06 112 of 2007 F I Payments(2002C) 603 49500 01 710 07 1/2 of 2007 P I Payments(2003A) 603 49500 01 710 10 Projects 603 49500 -01 TOTALS 2003 2004 2005 Actual Actual Actual $161,193 64,15 59,27 9,821 4,38 1,385 1,50 0 0 0 0 184 0 0 22 2,200 6 00 2,81 23 29 2,88 5 43 2,13 0 0 101 0 6,160 0 0 0 0 0 0 0 541 31 131 270,000 33 72,807 1,39 151,9 51,000 41,000 54,000 77,000 17,000 26,000 43,000 05,670 60,65 70,57 6 83 10 10 17 33 24 12 12 40,19 74 19 191 332 0 0 666 156 0 60,944 3,26 25,98 42,41 45 2,62 54 17 27 53 14,04 3,85 3,85 3,00 60D 5,63 3,04 3,23 61 40 14 2,08 1,81 6,03 5,07 29 50,000 42 000 53 000 75,000 19,000 26,000 44,000 80,797 2006 Adopted Budget 0 97,600 80,000 10,000 1,500 0 200 200 200 500 500 2,000 3,000 1,000 0 500 1,000 1,000 0 10.000 10,000 0 2,000 1900 500 0 5,000 9,000 0 3,000 1,200 200 1,000 3,500 6,000 600 500 300 4,000 2,500 1,000 500 500 0 100,000 6,500 0 0 0 500 2,000 500 50,000 41,000 54,000 77,000 29,000 25,000 44 000 0 2007 Object 2007 Detail Proposed Amount Budget 0 101,800 63,200 3,000 1,000 0 10,000 30,000 30,000 1,000 500 500 100,000 6,500 15,000 16,000 52 000 43 000 53,000 75,000 29,000 25,000 44 000 0 0 5,000 5,000 10,000 10,000 1 000 5,000 20,000 1,000 All Salary Costs Inclusive of $185,000 Salary, Taxes, PERA Benefits 10 000 70 000 2 000 1,000 Water OuatityTests (M) 500 3rd Part Inspection Program (M) 0 5,000 9,000 0 3,000 1,200 200 1,000 3,500 6,000 600 500 300 4,000 2 500 15 000 1 000 5,000 0 1,000 2 000 137 500 0 500 2 000 500 321 000 605,802 592968 802,749 734,000 602,400 Comments 1 500 0 200 Paper, Pens Reproduction 200 Stakes, Ribbons, Level etc 200 500 500 Fillers, Hoses, Lights etc 2,000 Blacktop Gravel Washouts 4 000 500 Advance Warning Sign Rental 1,000 Due to Breakdowns 1,000 Shovels Rakes Picks, etc 0 Wetland Health Evaluation Proj Contracted Engineer for City(20 B�Ilings Info Mailings Replacements Repars Public Info Brochure Storm Water's Share of Premiums Storm Water's Share of Premiums Roadside Debns Hazardous Materials Disposal Auto Read Software Support Laptops Repairs Sent Out Backhoe, Lowboy, Pumps, etc Utility Information 0 Annual Pavement Management 50% of Total Estimated Cost 1/3 of Total Estimated Cost 1/3 of Total Estimated Cost Stone Snare of Water /Storm Issue Storm Share of Hwy 3 Project Storm Share of Connemara Proj Page Two August 7, 2006 Account 603 49511 01 221 00 603 49511 01 321 00 603 49511 01 381 00 (Copper Pond) 603 49512 01 221 00 603 49512 01 321 00 603 49512 01 381 00 (Schwarz Pond) 603 49513 01 221 00 603 49513 01 321 00 603 49513 01 381 00 (Barger Pond) 603 49514 01 221 00 603 49514 01 321 00 603 49514 01 381 00 (Marcotte Pond) 603 49515 01 221 00 603 49515 01 321 00 603 49515 01 381 00 (Hawkins Pond) 603 49516 01 221 603 49516 01 321 603 49516 01 361 (Glendalough 7th) 2007 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES- Description Equipment Parts Telephone Costs Electric utilities TOTAL LIFT STATION #1 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #2 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #3 Equipment Parts Telephone Costs Electric Mites TOTAL LIFT STATION #4 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #5 00 Equipment Parts 00 Telephone Costs 00 Electric Utilities TOTAL LIFT STATION #8 GRAND TOTAL -ALL DEPTS 2003 2004 Actual Actual 0 211 183 394 0 211 0 211 581 422 2,634 0 211 167 378 0 211 0 211 216 422 3,374 3,836 4,011 2006 2007 Object 2007 2005 Adopted Detail Proposed Actual Budget Amount Budget 0 211 210 421 1,300 0 211 0 500 300 500 500 300 500 211 1,300 350 422 5 151 500 300 5,000 5,922 5,800 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 613,552 596908 809523 748,000 500 300 500 1,300 500 300 500 1,300 500 300 5 000 5,800 0 0 0 500 500 211 42 42 300 300 3,098 198 177 3,500 3 500 3,309 241 220 4,300 4,300 0 0 0 500 500 0 0 0 300 300 0 0 0 500 500 0 0 0 1,300 1,300 500 300 500 1,300 817,700 Comments ADMINISTRATION COMMUNITY USE MAINTENANCE ICE ARENA The Parks and Recreation Department administer the Ice Arena. Scheduhng and Invoicing of ice are the main admuustranve dunes of ice arena operations The scheduling of pnme 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. Provides recreanonal open skating for the residents of Rosemount as well as learning to skate and figure skating programs Provides ongoing and preventative maintenance of the ice arena building structure and its mechanical components. Ensures ice is maintained at optimal efficiency. Page One 2007 BUDGET WORKSHEETS ARENA REVENUES August 9, 2006 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 650 31010 00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 650 36210 00 Interest Earnings Investments 365 103 243 200 0 650 36215 00 Interest Earnings 120 109 76 200 200 650 36260 00 Other Revenue Learn to Skate 21,410 28,448 33,440 27 000 32,000 Learn to Skate Program (LTS) 650 36265 00 Use of Reserve Funds 0 0 0 101,700 0 650 38060 00 Pnme Time Ice Fees 250,143 286 383 211 297 25Q000 212,000 650 38061 00 Non -Prime Time Ice Fees 0 0 45,571 0 50 000 650 38063 00 Open Skating Ice Fees 7,998 8,244 8,973 7,000 9 000 650 38064 00 Broomball Revenues 0 0 0 0 6 000 65D 38065 00 Other Events Arena 0 0 0 500 0 Dry Floor Events 65D 3806600 Advertising Revenue Arena 6,970 16,200 11,650 14,000 14 000 650 38067 00 Skate Sharpening Revenue Arena 4,362 5,244 4,817 4,000 5 000 650 38090 00 Concessions 3 300 3,224 3,900 3,500 3 900 650 38091 00 Vending Machine Revenues 12639 1Q761 10,425 12,000 12 000 650 38095 00 Pro Shop Revenues 1,440 1,409 1,133 1,100 1,100 Tape, Laces, Mouthguards, etc 650 39103 00 Gain or Loss from F/A Disposal 0 0 0 0 0 650 39201 00 Transfer From General Fund 0 0 0 0 100 000 Subsidy for Operations FUND TOTALS 308 947 338 124 331,524 421,200 445,200 Page One August 9, 2006 2007 BUDGET WORKSHEETS ARENA EXPENDITURES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 650 45130 101 00 Salaries Benefits 650 45130 77 101 D0 Administrative 650 45130 78 101 00 Technical /Clerical 650 45130 79 101 OD Maintenance 650 45130 79 102 00 Full -Time Overtime 650 45130 103 00 Part-Time Salaries Benefits 650 45130 89 103 00 Learn -To -Skate Program 650 45130 99 103 00 Building Skate Guard Attendants 650 45130 01 207 00 Training Instructional Supplies 650 45130 01 206 00 Miscellaneous Supplies 650 45130 01 208 DI Skate Magnets 650 45130 01 208 02 Other Supplies 650 45130 01 209 00 Other Office Supplies 650 45130 01 211 00 Cleaning Supplies 650 45130 01 212 00 Motor Fuels 650 45130 01 216 00 Chemicals Chemical Products 650 45130 01 219 00 Other Operating Supplies 650 45130 01 221 00 Equipment Parts 650 45130 01 223 00 Building Repair Supplies 650 45130 01 241 00 Small Tools 650 45130 01 242 DO Minor Equipment 650 45130 01 265 00 Other Items for Resale 650 45130 01 305 00 Medical Dental Fees 650 45130 01 311 00 Officiating Fees 650 45130 01 317 00 General Fund Admin Fees 650 45130 01 321 00 Telephone Costs 650 45130 01 331 00 Travel Expense 650 45130 01 341 00 Employment Advertising 650 45130 01 349 D0 Other Advertising 650 45130 01 365 00 Workers Comp Insurance 650 45130 01 369 00 Other Insurance 650 45130 01 381 00 Electric Utilities 650 45130 01 383 00 Gas Utilities 650 45130 01 384 DO Refuse Disposal 650 45130 01 401 DO Contracted Building Repairs 650 45130 01 404 00 Contracted Mach Equip Repairs 650 45130 01 415 00 Other Equipment Rental 650 45130 01 433 DC Dues Subscriptions 650 45130 0 437 00 Conferences Seminars 650 45130 01 439 00 Other Miscellaneous Charges 650 45130 01 521 00 Budding Structure Purchases 650 45130 01 580 00 Other Equipment Purchases 650 45130 01 710 00 Transfers 650 45130 01 71D 01 Yearly Maintenance 650 45130 01 710 02 650 45130 01 710 03 FUND TOTALS Comments All Salary Costs Inclusive of $106,672 $159,800 Salary, Taxes, PERA Benefits 10,66 12281 32,500 34,100 4231 44,193 26 300 27,300 69,35 8 94,800 98,400 3,865 4,48 4,642 4,000 4 000 36,120 40 000 24,48 25,290 24,000 25,000 7 79 15 245 15,000 15,000 0 0 200 200 0 15 1,000 234 200 200 0 800 800 25 31 110 500 500 Learn to Skate Program Supplies 3,83 3,05 3,139 3,500 3 500 1,03 2,323 2,400 2,400 Battery for Maintenance 3,58 2,39 2,483 3,200 3,200 Assorted Products 30 18 29 1 000 1 000 Events Supplies 2 08 1,55 1,600 4,000 4 000 1,77 1,47 535 4,000 4 000 0 0 0 0 0 0 81 78 662 800 800 Pro Shop Supplies O 500 500 0 0 2,400 Broomball Leagues Referees 6,00 6,00 6 000 6 000 6,000 Yearly Fee Per Adrn r Fee Policy 1,00 1,00 1,000 1,000 1 000 0 100 100 O 500 500 93 800 800 2,30 2,55 2 091 2,000 2 000 6 32 6,43 6,552 13,000 13 000 84,16 87,05 101,374 85,000 87,000 23,46 26,82 34,957 33,000 33 000 2,94 2,94 2,881 3,500 3 500 5,70 3,97 6,212 5,000 5 000 6,95 4,18 26,933 10,000 10 000 0 300 300 45 50 592 900 900 24 0 400 400 O 500 500 MIAMA Dues MIAMA Seminars Contingencies 7,20 25,491 0 32,000 47,000 Paint Ceding and Duct Work 0 0 6,000 0 14,45 3 500 3,500 3,500 3,500 3,500 7,400 7,800 0 0 3,600 3200 0 0 320,292 351,735 403,301 421200 441,800