Loading...
HomeMy WebLinkAbout9.a. 2010 Preliminary Budget and LevyAGENDA ITEM: 2010 Preliminary Budget and Levy AGgNDA SECTION: u) 0N4 PREPARED BY: Dwight Johnson, City Administrator AGENDA NO. ci ATTACHMENTS: Resolution, Preliminary Budget APPROVED BY: F RECOMMENDED ACTION: Motion to approve the attached resolution adopting the preliminary budgets and tax levies for 2010 and setting the public hearing date for December 1, 2009 at 7:30 p.m. 4 ROSEMOUNT CITY COUNCIL City Council Meeting September 1, 2009 EXECUTIVE SUMMARY EXECUTIVE SUMMARY Despite a reduced tax base, the loss of state aid, and the reduction of local revenues such as building permits, the City's proposed budget will reduce taxes on the average home by $77 while service levels will generally be maintained. A large reduction in city debt is the main reason why this is possible. Principal reasons for this tax reduction: 1. Surplus funds from 2008, which came from conservative budgeting and at a time before the recession deepened, will be used to pay off debt and save the City $527,000 in debt levies for 2010. 2. The City planned for the reduction and elimination of state aids beginning in 2008 and did not wait for the full crisis to hit in 2009 and 2010. 3. Appropriate reorganization and consolidation of staff positions occurred in the spring of 2008, early in the recession. 4. Many cost saving measures have been implemented relating to office equipment, fuel purchases, conserving water usage, implementing high- deductible health insurance, and cross- training employees. 5. Residential assessed values dropped about 9 more than the overall Citywide tax base reduction of 4.48 Business properties did not drop as much, and some continued growth also mitigated the citywide reduction. The recommended budget for 2010 proposes the lowest overall spending since at least 2005. The 2010 budget proposes no change in the number of full-time staff and no new vehicles other than police cars. The most notable areas for new spending are to begin maintaining the new soccer fields at DCTC coming on line this Fall and funds to open the former St. Joseph's Church to the public for events. BUDGET PROCESS The annual budget process really begins with the adoption of goals and work plans by the City Council early in the year. All participating staff members keep these goals and plans in mind as the budget is developed. At the April 15th work session, staff reviewed several budget scenarios with the Council. In May, all department directors received budget forms from the Finance Department and developed a first draft of the 2010 budget. At the same time, staff developed performance measurements for key city services to be included in the budget process for the first time. In late May, the Finance Director aggregated all of the draft budget requests and also estimated City revenues. The initial budgets developed by staff were very realistic and showed a reduction in the required tax levy. The Finance Director and I then met with each department director and reviewed overall operations as well as every line item in their budgets. We found a number of line items that could be reduced and some that needed to be increased, but the net savings was about $100,000. Next, we looked at long range needs for capital improvements and equipment to arrive at appropriate levies for our three capital funds. Finally, we looked at the overall budget strategically one more time for its overall balance, consistency, impact on taxpayers, and long term impacts on finances for 2011 and beyond. Our hope was to develop the most conservative budget possible that: (1) is consistent with council goals (2) maintains important services, (3) does not weaken the City's long range financial outlook. (4) is balanced not only between revenues and expenditures, but also is well balanced internally between personnel, equipment, technology, operating needs and capital expenditures. According to state law, the preliminary budget and levy must be adopted by September 15` and the final budget must be adopted in December after a public hearing OUTSIDE FACTORS AFFECTING THE BUDGET Loss of Market Value Homestead Credit On June 16, 2009, Governor Pawlenty announced his plan to unallot significant amounts of certain state aids to cities including Local Governrnent Aid (LGA) and Market Value Homestead Credit (MVHC). Rosemount has not received any LGA in recent years, but did receive some MVHC payments as recently as October, 2008. The amount of MVHC estimated for Rosemount is $362,471 in 2009 and $412,575 in 2010. The Governor's announcement indicates that Rosemount will receive no MVHC payments in either 2009 or 2010. However, because of the way MVHC is calculated, and because it was estimated to increase in 2010 if there were no unallotment, the City actually loses an additional $71,527 in revenue for 2010, even though we never planned to receive these funds. Levy Limits Levy limits were re- imposed by the Legislature for 2009 and will continue to be in effect for 2010. For 2009, the City was allowed an inflation factor of 3.9% plus half the percentage of household growth and half the percentage for new commercial /industrial growth. In 2010, the inflation factor is currently estimated at only 0.83% (less than 1 and our growth factor is estimated to be 0.9009% for household growth and 0.1353% for commercial /industrial growth. Although our overall levy is reduced from the 2009 amount, most of the reduction is in the tax levies for debt service which are outside of the levy limit calculation. The City Council previously designated about two- thirds of its operating surplus from 2008 for debt reduction. Therefore, staff has had to carefully review whether our proposed levy is within the new levy limit. Although staff estimates that we are within the levy limit, we will not have a final levy limit number until September. Permit Revenues The economy is continuing to slow the growth of the City. The current 2009 budget was based upon an estimate of 135 new homes. For 2010, after a survey of active builders, we have determined that we should reduce our permit related revenues by an additional $165,000 from the 2009 permit revenues. The 2010 budget is based upon an estimate that 100 new homes will be built (60 multifamily and 40 single family homes). As in the past, no permits for new commercial or industrial projects are assumed. Tax Base For the first time in recent history, the overall tax base in the community has declined. The overall tax 2 capacity value within the City is estimated to be 4.48% lower in 2010 that it was in 2009. The decline in market value of the median home in Rosemount is even more dramatic, with an average decrease in market value of 9.02 The overall tax base did not decline by that much because commercial and industrial property had more moderate declines and new growth in the community offset some of the decline in existing property values. SKB Revenues The City approved a new agreement with SKB, inc. last year that will gradually increase our percentage of revenues from SKB's operations in Rosemount over the next several years. However, current revenue collections have been hindered by the slow economy as well the discovery of an overpayment to the City in early 2009 based upon somewhat incorrect estimates of previous volumes by SKB. Nevertheless, overall SKB revenues are expected to increase over time, and the allocation of these funds is an important strategic decision. REVENUES Property taxes fund 83.1% of the General Fund budget and 65.4% of the overall City Budget. As noted above, our tax base is decreased by 4.48% for 2010. However, there are several other categories of General Fund revenues that are also important to the City. The chart below compares budgeted revenue for 2009 with estimated revenue in 2010 for several key categories of revenues. Licenses Permits Intergovernmental Charges for Services (no SKB) Fines Forfeits Recreational Revenues Miscellaneous Revenues SKB revenue (General Fund) As can be seen, there are projected decreases in most of the major revenue categories. Without the proposal to increase the amount of SKB funding in the General Fund, the decrease in non -tax General Fund revenues would have been $317,500. The SKB funds are normally a part of the Charges for Services line, but are shown separately here to show their impact. The license permit revenues were detailed in a previous paragraph. The intergovernmental revenues have an $80,000 decrease in the budgeting of delinquent taxes (reduced to zero to offset anticipated collections in the current tax collections) that is offset by small increases in other areas to make the total reduction $49,500. The charges for services have two large decreases for plan check fees ($60,000 part of the permit process) and administrative fees for construction projects ($50,000 development related fees that are not anticipated for 2010). The miscellaneous revenues show a decrease mainly because of an anticipated decrease in investment interest earnings of $10,000 and a decrease of $46,300 in rental revenues because of the loss of St. Joseph's rental of the old school and church as they will have moved into their new facilities in 2009. EXPENDITURES 2009 Budget $486,600 $616,000 $379,100 $110,000 $253,800 $254,500 $300,000 2010 Estimated Change $382,600 ($104,000) $566,500 ($49,500) $255,900 ($123,200) $125,000 $15,000 $253,800 0 $198,200 ($56,300) $400,000 $100,000 Salaries and Benefits Rosemount employs 80 full time employees. No new full time employees are proposed in this budget. A contingency for potential increases in salaries and /or health cares costs has been included in the proposed General Fund budget in the amount of $152,400. There is some uncertainty about both salaries and 3 benefits at this writing since we have four labor contracts expiring at the end of 2009 and negotiations have not yet begun. Very few other cities have settled new contracts for 2010 either, adding to market uncertainty With four bargaining units, the City can unilaterally determine 2010 salaries for only certain supervisory and managerial employees. All other salaries and benefits must be bargained. For certain "essential" employees such as police, the State can impose a wage settlement through a state arbitrator, as happened recently in Apple Valley. In addition, we will not receive new health insurance premium figures until at least September 1S` St, Joe's Church The proposed budget includes operating funds to open the former St. Joe's church and adjacent "gathering space" to the public for events in 2010. The revenues and expenditures for the church property were detailed in a report to the Council in May, 2009. Sufficient capital dollars have already been accumulated in 2008 and 2009 to do minimal code and other improvements to open the building for public use. The net impact on the General Fund is $74,000. However, about $54,000 of this amount would be needed for utilities and routine maintenance even if we were to choose not to open the building next year. This item is included in the 2010 budget because it will make productive use of a significant asset and was also included in the Council's adopted goals and work plan for this year. DCTC soccer fields New soccer fields on DCTC property have been seeded and will be ready for play during 2010. The City must provide for the maintenance of these fields to make use of its investment next year. Additional part time staff is included in the budget for this purpose, but no new equipment is needed at this time. Capital Budgets The City currently has three capital improvement program (CIP) funds: Equipment, Streets, and Buildings. In the Equipment CIP, no new vehicles are proposed except for replacement of police cars. However, staff studies show that long range, the City needs a levy of approximately $400,000 for vehicle replacement, even if we extend the "normal" life of some vehicles by 20 to 50 While our overall Equipment CIP levy is $439,000, only $201,000 is available for current or future vehicles. In 2010 the Equipment CIP will have a surplus, but it faces a significant long range deficit unless the levy is increased in future years. Staff believes that if the levy for expiring Equipment Certificate debt is transferred to the Equipment CIP fund in 2013 and 2014 the long term deficit can be accommodated. The Street CIP is proposed to have a levy of $700,000 for 2010. Public Works Director /City Engineer Andy Brotzler has updated the rating of our streets and indicates that this levy is sufficient in the short run but in the longer term will lead to an overall average pavement rating of 62.5 which is somewhat below the Council's adopted standard (75 rating for collector streets and 60 for residential streets). Our current pavement ratings average 77.5, which is above the council adopted standard. Further analysis of our future street paving needs is in progress and will be available when we discuss the Capital Improvements Program in detail. Our streets have a net asset value of $31,092,317 according to our current CAFR report and represent one of our biggest assets. The Building CIP has a levy of $24,000 for 2010 for the repayment of an internal loan for the current Public Works facility. This fund is not accumulating any funds for replacement or future additions to City buildings such as City Hall or Public Works facilities. Nor are any funds being accumulated for other opportunities or issues that may arise, such as matching grants or dealing with the Emerald Ash Borer threat. Accordingly, it is recommended that $100,000 of the overall SKB funding of $525,000 be allocated to the CIP for these purposes. Items NOT included in 2010 Budget Proposal Earlier this year, a letter was received from the Rosemount Area Seniors Club requesting funding for a part -time senior coordinator. This item is not included in this budget proposal. While staff believes there 4 is merit in this proposal and that this is the next best step to improve senior services in the community, it is difficult for us to recommend funding for a new staff position when no other new staff positions are being added and we have a declining tax base and other declining City revenues. Enterprise Fund Budgets. The Water utility has an anticipated increase of $129,000 from 2009 to 2010. Most of this increase is for improvements to the system including air conditioner temperature and humidity controls for the wells that currently do not have them, humidifiers for the well houses that do not have them, mixers for the water towers, and interior painting of the East Side Water Tower ($150,000). The Sewer utility has an anticipated increase of $144,900 from 2009 to 2010. Most of this increase is for an anticipated increase in the Metropolitan Waste Control Commission (MWCC) charges that the City pays on an annual basis. The Storm Water utility basically maintains a budget that is constant from 2009 to 2010. The Arena fund has an anticipated increase of $43,600 from 2009 to 2010. This increase can be attributed to the replacement of compressors in the arena. Debt Service Funds. The City ended 2008 with a General Fund surplus. The Council approved a strategy that committed about two- thirds of the surplus to paying off existing debt. Enough funds were available to completely pay off three debt issues, saving not only $526,930 in tax levies for 2010, but also several years of lesser debt payments beyond 2010. Implementation of this strategy is the major reason why we have been able to propose an overall reduced tax levy for 2010 while still maintaining important services. CONCLUSION While it is always a challenge to draft a budget in a time of declining revenues, staff is pleased that a budget could be developed for 2010 that both reduces the tax burden by about $77 for the average resident while not resorting to temporary one -time fixes that could cause tax increases in the future. We believe that the proposed budget is appropriately conservative for the current economic situation, but also keeps us as ready as possible to accommodate economic recovery when it occurs and allows us to continue to address the Council's goals. 5 CITY OF ROSEMOUNT DAKOTA COUNTY, MINNESOTA RESOLUTION 2009 A RESOLUTION SETTING THE PRELIMINARY 2010 GENERAL FUND OPERATING BUDGET, THE PRELIMINARY 2010 C.I.P. BUDGETS, THE PRELIMINARY 2010 INSURANCE BUDGET, THE PRELIMINARY 2010 PORT AUTHORITY OPERATING LEVY AND THE PRELIMINARY 2009 LEVY AND BUDGET HEARING DATE REQUIRED BY THE CITY OF ROSEMOUNT WHEREAS, the City Council of the City of Rosemount has determined that budgets and special needs for the year 2010 will be in the amount of $16,114,000 for the General Operating Fund, the three CIP Funds, the Insurance Fund, the Port Authority Fund and the Enterprise Funds; and WHEREAS, the City Council has determined that special levies for Bonded Indebtedness (including $142,273 for the market value based referendum levy for the fire station) and the Armory Project total $951,744; and WHEREAS, the City Council has determined that actual incomes, fund transfers and anticipated aids will total $5,902,425. NOW, THEREFORE BE IT RESOLVED, that the total certified to the or shall $11 0211,046 for the levy and $142,273 Dakota County Audit for the Dakota market value based referendum levy; and BE IT FURTHER RESOLVED, that the City Council of the City of Rosemount will conduct a Public Hearing for the purpose of presenting the proposed budget and levy to the general public and to comply with Truth in Taxation laws as set by the Minnesota State Legislature, and that the hearing shall take place on December 1, 2009, at 7:30 P.M., in the Council Chambers at the City Hall. ADOPTED this 1 day of September, 2009. ATTEST: Amy Domeier, City Clerk (SEAL) CERTIFICATION William H. Droste, Mayor RESOLUTION 2009 I hereby certify that the foregoing is a true and correct copy of a resolution presented to and adopted by the City Council of Rosemount at a duly authorized meeting thereof, held on the 1 day of September, 2009, as disclosed by the records of said City in my possession. Amy Domeier, Rosemount City Clerk Motion by: Seconded by: Voted in Favor: Voted Against: Members Absent: DAKOTA COUNTY PROPERTY TAXATION RECORDS PAYABLE 2010 PROPOSED LEVY CERTIFICATION FORM TAX CAPACITY BASED LEVY General Revenue Debt General Obligation* Debt Other* Road and Bridge Other (identify) Total Tcap Based Levy Debt General Obligation* Debt Other* Other Total Mkt Referendum Levy 16,114,000 809,471 16,923,471 142,273 142,273 -0- -0- 5,902,425 5,902,425 MARKET REFERENDUM BASED LEVY 10,211,575 809,471 11,021,046 142,273 142,273 17,065,744 -0- 5,902,425 11,163,319 Total of all Levies Provide a breakdown of the certified levy by individual bond on the reverse side or attach an additional sheet. ($ee Attached) Amount needed to fund services. These aids are certified to the taxing district by the Department of Revenue. This can be used to reduce any budget item levy requirement, combination of items or be deducted proportionally from all levies. All other resources that will be used to finance your taxing districts budget. Including but not limited to other aids, interest income, prior year reserves, grants, etc. Levy certified to the County Treasurer Auditor. ROUND TO THE NEAREST WHOLE DOLLAR. DO NOT CERTIFY PENNIES. The Treasurer Auditor's office will deduct Fiscal Disparities from all certified levies. A- Budget Requirement B -LGA (Local Government Aid) C -Other Resources D- Certified Levy Before signing, please verify the following: -MAKE SURE THAT ALL LINES ADD ACROSS AND ALL COLUMNS ADD UP TO THE TOTAL LINE BREAKDOWN OF DEBT SERVICE LEVY BY INDIVIDUAL BOND HAS BEEN PROVIDED AMOUNTS REPORTED MATCH ANY OTHER SUPPORTING DOCUMENTATION INCLUDED e., Celie ev this form matches amount on your taxing district's resolution, etc.) 651- 322 -2031 Signatur of on completing al Fin ce Director Title FORM B Date City of Rosemount Phone number (including area -code) 9 -11 -09 TAXING DISTRICT NAME LEVY CERTIFICATION Debt Service Schedule PLEASE NOTE: All debt must be accounted for in your resolution whether it is a part of your levy or not. If the amount levied is less than the required amount from the payment schedule for the bond, you must pass a resolution stating that you have sufficient funds for that bond. This can be included in the same resolution with your levy. Dakota County will be verifying the levy requirements based on the payment schedule in our Bond Register (see attached, if applicable). You must submit your resolution with this certification form. iir:ces (See Attached) Debt Service Total This must match the totals for Debt Service reported on the front. 2009 GENERAL PROPERTY TAX LEVY PAYABLE 2010 GENERAL LEVY $8,723,575 GENERAL FUND $24,000 BUILDING CIP FUND $$24,000 STREET CIP FUND $700,000 EQUIPMENT CIP FUND $439,000 INSURANCE FUND $50,000 PORT AUTHORITY OPERATING LEVY $10,211,575 TOTAL GENERAL LEVY BONDED INDEBTEDNESS G.O. PUBLIC FACILITY BONDS 2001C (Port Authority) (Authorized $173,402) $173,402 G.O. COMMUNITY CENTER REFUNDING BONDS 2001E (Authorized $95,537) G.O. IMPROVEMENT BONDS 2003A (Authorized $86,354) (City Assumed Special Assessments) $209,846 G.O. CAPITAL IMPROVEMENT PLAN (CIP) BONDS 2005A (Authorized $209,846) $6 G.O. EQUIPMENT CERTIFICATES 2005B (Authorized $346,540) $0 G.O. EQUIPMENT CERTIFICATES 2006A (Authorized $84,854) G.O. IMPROVEMENT BONDS 2006B (Authorized $268,551) $0 $105,0 G.O. EQUIPMENT CERTIFICATES 2007B (Authorized $105,079) PUBLIC SAFETY REVENUE BONDS 2007 (Dakota Communications Center) (Authorized $62,633) $62,633 G.O. EQUIPMENT CERTIFICATES 2008A (Authorized $92,157) $729,471 TOTAL BONDED INDEBTEDNESS MARKET VALUE BASED REFERENDUMS G.O. FIRE STATION REFUNDING BONDS, 2005D (Authorized $142273) TOTAL FIRE STATION LEVY PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($2,183,008,500 x .00798% $174,204) (As of 7/5/09) $80,000 (Authorized $174,204 Only Levy Amount Due MSABC) $80,000 TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS GRAND TOTAL 2009 PROPERTY TAX LEVY $11,163,319 Last Updated 8/17/09 $142,273 $142,273 0) m V 11 IV 11 N n 0) II OD r H J 1 A 2P0PPPPPPPPPPP0P0000000 0bbbbbbbb9b9bp9P9PP9PPP 0 tg, gv vvE mm?1 m0 C) N N m 0) 0) ED o L a v v v 0- m c c 0 c 1 3 W 3 O 3 0 0 0 'O "o 'O' w V m 3 o D D -Ti 0<<<< 3 3 3 m c o c. 3° (D F. F. 01 O O O O N N N v z (0 Th m m m o 0 m 3: 3 CO CD n n n 7 m n 0 N C m m m g CC (1 m. .0" a 0 W W W 0) ao j o (3 (3 7 Q 01 0) C W G< 0) 71 x F a J 7 7 7 g n n n 7 n 0) g O W o 0 o d. 0 W 0) j 0L 0. 0t 0. 0 m N N d 0 N m W 0 0 7 7 D C 0 7 V Q N N N N N S a- 0 A 0 O. O. O. 01 O. 01 N N N N O N 01 c. N 00 0 A o O N TO O 0 W N 0 0 O 00 0 o f ONO. i Z a. m 000. 0 °m .›),»o m 03 2 p D C) 0W m D0D O W >0>- W010 i 3 0) 03 0 O 0 0 O N O f7 N N 0 N o N II O 1)0 u H 0) 0 0 I 0 11 c o 11 co O it O) O) 11 O 1 II CO II 0 II co II 0 09) O O 1 11 N) N W II -J 1) 0)) 0 N 0 O N O o O N D f m W C) 0) Et y 0 m N W N+ W N N O) CO V 0) N J 0) N (0 N A CO W N CO W W W N N s 0) V 0) 01 .P 0) O 03 CO V W N N CO N 0)0)00)0)00)0)0)0) 000 01000)0100 000000000 0000 0 00 0 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ca (.4 01 O 7 o No= 4 O C 7 .a O 0 O 3 m m 5 0 N 0c 0 O C a 7 0) O 5 W 0 Q 0 W 01 N C 0) V (O CO N co 1 Z 01 A (T W O W 0) N 1 CO CO (0 CO 0 V (ON CO 0)NN V CO 0) 0)IV (0 0) N-I00 V N O C 0 A )(0)»-00)O 0 00)N O0011N (400)0)) w m 0 O V V W (0 01 V O O N 0) V 0) A O CO W O E CO 00010) 01 N N N 0 00 V N V OA ON V 00D C'! 0 0 0 0- 0 0 0 0 0 0 0 0 0 0 0) 0 0 0 0 0 N a c 0100 N D 00 V 0D 0) N (0 (1 A O) 0D V N 0 V 0 0) 0101 0N0 0 0) 00 N 0) 010100 p 1010A 000.0 0 p 0 0 0 O 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 A V+ W W CO W pp V CO N N CO ONA V CO 0NN 10 W 0) 01"4 4 ^4 V 01 N Inaba A 0) ON_O ODOD 0 1N (4C N O V V CO (0 01 V W O N 0) V 0 O W (0 0 0010) CA in N N N NI 00 V N V ON O OD CD 0 0 0 N 0— 0 0 0 0 0 0 0 0 0 0 01 N O 0 0 0 0) W 01 N N 0 m v ,pp 0 C D V (ON CO 03 O Q)N N p, 0 O V W 0 V CO 0) O O N 0) v C a 0) w O O 0) N N 0) N N 0 0 0 V N^ I 0 0 0 0 0 0 0 0 O O 0 01 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O) 7 7 7 7 7 7 7 7 :1 7 0D 7 7 2 (0 0 CO A A O CO N 01 O1 0 0 0) O) 0) 0) W if 51 m m 0 N 01 A N 0) 01 CO 0 N A J m A W 0 W CO 5 r o N c) N i mono= 7 7 7 7"4 0 0 CO 7 7 7 CO O A a m N 0 1 0) 0) 0 0) 0 0) 0) W 0 0 01 m m m N N N (O W N A V 0) O W 0 0 0 O. �G 3 000)0001d33 0)0)(00) 7 7 P:Im 1u.Z1 0) 0 0 0 0 0 0 T T 0) is O N W 0 m 0) N o b 0) N a a 3 la N C) 0 0) O 71 11 -11 C C -11 O N co N O O C o n o G 0 a s 0 0 0 (0 N w 0 O 01 CO 0 0 0 0 E 0 0 0 0 0 a 00 0 0 0 N N N N 3 3 3 3 m 0 m 0) 7 7 7 7 www 0 0 O 0 '1) T C C 7 7 0. 0 0. O N Taxing District Name: Name or Title: Website or E -mail Address: No personal (home) e-mail addresses please. Signature of person completing this form: Title: Phone number: Date: DAKOTA COUNTY OFFICE OF PROPERTY TAXATION RECORDS Public Hearing Date: Tuesday, December 1, 2009 Time of meeting: 7:30 P.M. Place of meeting: Rosemount City Hall (including address) 2875 145th Street West Rosemount, MN 55068 PLEASE PROVIDE CONTACT INFORMATION, ADDRESS AND PHONE NUMBER AS YOU WOULD LIKE IT TO APPEAR ON THE TNT NOTICES. (Five lines only 36 characters per line including spaces.) Address: PAYABLE 2010 TRUTH IN TAXATION HEARING DATE CERTIFICATION FORM A City of Rosemount Finance Director City of Rosemount 2875 145th Street West Rosemount, MN 55068 Phone number: (651) 423 4411 www.ci.rosemount.mn.us If you would like an e-mail contact or your website listed on the notice, please complete. Note: you are not required to provide this information. Finance Director (651) 322 -2031 September 11, 2009 *Please include area code when identifying phone numbers September 1, 2009 Departments FUNDING REQUIREMENTS USES (INCLUDING FIRE STATION LEVY) 2009 2010 Adopted Proposed Budget Budget Difference Percentage Council Budget $330,100 $391,800 $61,700 18.69% Administration Budget 553,500 508,800 (44,700) 8.08% Elections Budget 40,000 40,000 0 0.00% Finance Budget 417,900 417,700 (200) -0.05% General Govemment Budget 403,300 387,700 (15,600) -3.87% Community Development Budget 930,000 933,800 3,800 0.41% Police Budget 2,974,200 2,993,900 19,700 0.66% Fire Budget 289,000 301,800 12,800 4.43% Public Works Operating Budgets: Govemment Buildings Budget 502,000 490,200 (11,800) -2.35% Fleet Maintenance Budget 576,800 606,600 29,800 5.17% Street Maintenance Budget 1,297,000 1,324,700 27,700 2.14% Parks Maintenance Budget 683,900 718,500 34,600 5.06% Park Rec Budget General Operating 1,148,400 1,142,300 (6,100) -0.53% Park Rec Budget Special Programs 123,700 123,700 0 0.00% Transfers Arena Assistance _115,000 Y 115,000 0 0.00% Total Operating Budgets General Fund $10,384,800 $10,496,500 $111,700 1.08% Building CIP Requirements 84,000 24,000 (60,000) 71.43% Street CIP Requirements 765,000 700,000 (65,000) 8.50% Equipment CIP Requirements 445,000 439,000 (6,000) -1.35% Insurance Budget Requirements 275,000 275,000 0 0.00% Port Authority Operating Levy 50,000 50,000 0 0.00% Bonded Indebtedness 1,250,750 729,471 (521,279) 41.68% Bonded Indebtedness Fire Station Levy 146,084 142,273 (3,811) -2.61% Armory Anticipatory Levy (Value 7/5/09) 80,000 80,000 0 0.00% *12,183,008,500 x .00798% $174,204** Water Enterprise Fund 1,224,900 1,353,900 129,000 10.53% Sewer Enterprise Fund 1,502,400 1,647,300 144,900 9.64% Storm Water Enterprise Fund 665,700 670,300 4,600 0.69% Arena Enterprise Fund 414,400 458,000 43,600 10.52% Total Funding Requirements $17,288,034 $17,065,744 ($222,290) -1.29% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. September 1, 2009 FUNDING REQUIREMENTS SOURCES (INCLUDING FIRE STATION LEVY) 2009 2010 Adopted Proposed Types Budget Budget Difference Percentage Internal Revenue Generated: Licenses and Permits 486,600 382,600 (104,000) 21.37% Intergovernmental 616,000 566,500 (49,500) -8.04% Charges for Services 679,100 655,900 (23,200) -3.42% Fines Forfeits 110,000 125,000 15,000 13.64% Recreational Fees 253,800 253,800 0 0.00% Miscellaneous Revenues 254,500 198,200 (56,300) 22.12% Transfers In 3,500 3,500 0 0.00% Enterprise Revenues 3,807,400 4,129,500 322,100 8.46% Total Internal Revenues 6,210,900 6,315,000 104,100 1.68% MVHC Cuts Made Later To Include in Levy 350,330 412,575 Levy Sources: Special Levies 1,476,834 951,744 (525,090) 35.56% General Levy 9,950,630 10,211,575 260,945 2.62% Total Levy $11,427,464 $11,163,319 ($264,145) -2.31% Loss of MVHC from State Funding $350,330 $412,575 $62,245 17.77% Total Revenue Sources $17,288,034 $17,065,744 ($222,290) -1.29% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. 2009 GENERAL PROPERTY TAX LEVY PAYABLE 2010 GENERAL LEVY GENERAL FUND $8,723,575 BUILDING CIP FUND $24,000 STREET CIP FUND $700,000 EQUIPMENT CIP FUND $439,000 INSURANCE FUND $275,000 PORT AUTHORITY OPERATING LEVY $50,000 TOTAL GENERAL LEVY $10,211,575 BONDED INDEBTEDNESS G.O. PUBLIC FACILITY BONDS 2001C (Port Authority) (Authorized $173,402) $173,402 G.O. COMMUNITY CENTER REFUNDING BONDS 2001E (Authorized $95,537) G.O. IMPROVEMENT BONDS 2003A (Authorized $86,354) (City Assumed Special Assessments) $206,8 4 G.O. CAPITAL IMPROVEMENT PLAN (CIP) BONDS 2005A (Authorized $209,846) $6 G.O. EQUIPMENT CERTIFICATES 2005B (Authorized $346,540) $0 G.O. EQUIPMENT CERTIFICATES 2006A (Authorized $84,854) G.O. IMPROVEMENT BONDS 2006B (Authorized $268,551) $0 $105,0 G.O. EQUIPMENT CERTIFICATES 2007B (Authorized $105,079) PUBLIC SAFETY REVENUE BONDS 2007 (Dakota Communications Center) (Authorized $62,633) $62,633 G.O. EQUIPMENT CERTIFICATES 2008A (Authorized $92,157) 7 $729,471 TOTAL BONDED INDEBTEDNESS MARKET VALUE BASED REFERENDUMS G.O. FIRE STATION REFUNDING BONDS, 2005D (Authorized $142,273) $142,273 TOTAL FIRE STATION LEVY $142,273 PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($2,183,008,500 x .00798% $174,204) (As of 7/5/09) $80,000 (Authorized $174,204 Only Levy Amount Due MSABC) $80,000 TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS GRAND TOTAL 2009 PROPERTY TAX LEVY $11,163,319 Last Updated 8117109 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 Distribution 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/17109 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) Total Funding Requirements Less: Internal Revenues Less: Market Value Based Levy Fire Station (See Below) 2007 2008 2009 17,341,719 7,189,300 142,527 10,009,892 350,330 10,360,222 154,308 17,855,312 6,526,300 144,417 11,184,595 11,184,595 870,514 968,892 9,489,708 (1) 10,215,703 (1) 7.65% 142,527 17,288,034 6,210,900 146,084 10,931,050 0 350,330 11,281,380 (Proposed) 2010 17,065,744 6,315,000 142,273 (3) 10,608,471 412,575 11,021,046 1,141,159 1,195,913 (2) 10,140,221 (1) 9,825,133 -0.74% 3.11% 144,417 142,273 (3) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2010 Number Provided by Dakota County as of 815/09 (3) Market Value Based Levy for Fire Station Based on $142,273 Levy Spread to Taxable Market Value on 2119109 Last Update from Dakota County 8/9109 Shows the Levy of $142,273 1 $2,183,471,800 $.0650 per $1,000 as our Estimate 11 T as N 2 H 8sm R8 9 o owm p a o ma a nn a 3 m m -LN Gyp (J� m N A pAp W f J N 8 m O J 8w8. 0 ppDp W .a1° W W O W J A 0 o W J PPP J W PPP 58 1 PPP g N A W PPP XQ5 8 J O PPP O 2 PPP IR Ng ee 0 1 W kg hP qw it8 11 t I .8 II 81 I O I S O 2 ID m m y s p.z a o p B- p g zga a 8 =;a o8m y m A NO m m g "s. 3 131,3s mpg a« 3 .900 2 Ign 0099 2,"rt 0000 N A 20:1 8 0000 Q +NN Bit 0099 B� W s J W p O O O O NNA !O 0099 �NN& 0000 m I V N A Nw 01 W J S A W N 9000 0 N W A J p O O O O 8g&t 0 A p SOD W 88 O 0 N 8 cre 0 8 N 8 v 0 0 if 1181 It IN VW N 1 1-8 I m N m 11 j I f f II> IIN W 0p1 NWW N O W �j p N A W W N 0 3 1 1 14 N A W t II 1 i I W W N IiY 4888 0{p W A J 8 -N$ 0 p W O m A O N J W W 8 0 J P W W N N J.-40W N O N A N A W 0 W N 000 I8 000 AtJ 000 ,r 0 00 8 I O O O 222( PPP 8 N A W 0 N W 000 O 9999 ip +W r W A 999 1 S O 0 0 0 0 N A N W 8 N po aW m (pJ 018 J�A 1 1 1 11 i1 O II� li 6 1: 000 1p 0000 m OtN9 A 1Dm 8 0 2 i gn 8 0000 R N N N N 0000 S r N N N k1 0009 ViTt P,NN PPP gg io 0000 5 5����555 t I it 2v j 1,0 w 0099 o w N w A W:l 1 p 0029 L _I N01 N t° OD WS W N I 0000 w .-g" Q 8 v 8 O 0 8 Page One September 1, 2009 Account 101 31010.00 101 31040.00 101 32110.00 101 32160.00 101 32162.00 101 32210.00 101 32212.00 101 32220.00 101 32221.00 101 32230.00 101 32240.00 101 32250.00 101 32255.00 101 32260.00 101 32290.00 101 31010.00 101 31010.01 101 31020.00 101 31030.00 101 31710.00 101 31810.00 101 31811.00 101 31920.00 101 33100.00 101 33416.00 101 33416.01 101 33416.02 101 33418.00 101 33423.00 101 33425.00 101 33620.00 101 33630.00 101 33630.00 2010 BUDGET WORKSHEETS GENERAL FUND REVENUES Description Current Ad Valorem Taxes Fiscal Disparities Total Taxes (Tax) Alcoholic Beverage Licenses (L) Licenses to do Business (L) Lic to do Business Rental Housing (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 (I) Franchise Taxes PEG Fees (1) Forfeited Tax Sale Apportionment (I) Federal Grants Aids (I) Police Training Reimbursement (1) Post Board Training Reimb State Aid (Tied to PERA) MSA for Streets Maintenance (I) Ag Preserves Credit (I) Other State Grants Aids (I) Other County Grants Aids (I) Police Services Levy -ISD #196 (I) D.A.R.E. /Liaison Funding 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $4,630,971 $5,920,729 $6,732,360 $7,190,471 770,288 870,514 968,892 1,141,159 5,401,259 6,791,243 7,701,252 8,331,630 (350,330) 7,981,300 $7,582,416 1,141,159 From County From County 8,723,575 Total Property Tax Levy for Fund 101 (412,575) State Cuts in MVHC 8,311,000 Actual Property Taxes to Receive 33,040 34,525 32,657 32,000 34,000 5,710 6,390 7,730 6,500 7,500 Garbage Haulers, Ped Licenses, etc. 0 0 13,191 0 0 575,778 435,956 489,002 300,000 200,000 4,330 740 2,180 4,000 2,000 21,059 15,626 15,795 15,000 15,000 10,250 9,040 7,990 9,000 8,000 50,589 57,039 53,994 45,000 45,000 2,759 2,829 2,442 2,000 2,000 18,862 13,773 7,252 12,000 8,000 190 80 30 100 100 75,329 73,866 66,133 60,000 60,000 1,755 770 360 1,000 1,000 Alarm Permits Fireworks Permits 799,651 650,635 698,755 486,600 91,000 91,000 91,000 80,000 80,000 Included in Debt Levy Figure 80,000 80,280 110,316 139,641 70,000 0 From County 8,342 10,635 8,834 9,000 9,000 From County 13,670 18,811 15,348 15,000 15,000 From County 148,080 158,698 169,415 150,000 160,000 From Cable Company 23,118 23,936 23,905 20,000 22,000 From Cable Company 0 0 0 0 0 From County 0 0 0 0 0 133,872 147,061 147,847 145,000 From State 26,910 29,115 29,115 26,000 29,000 From State 1,135 1,163 628 0 500 From State 19,465 35,475 21,882 24,000 21,000 From State -PERA Aid Safe Sober 18,500 15,400 82,803 16,000 19,000 Dakota County Recycling Funds 59,548 68,727 63,620 64,000 66,000 66,000 From ISD #196 Total Intergovernmental (I) 623,920 710,336 794,038 616,000 PAGE TOTALS 6,824,831 8,152,214 9,194,045 9,083,900 7,000 7,000 135,000 138,000 382,600 566,500 9,260,100 Page Two September 1, 2009 Account Description 2010 BUDGET WORKSHEETS GENERAL FUND REVENUES 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Comments Actual Actual Actual Budget Amount Budget 39,000 50,000 40,000 39, 101 34103.00 Zoning &Subdivision Fees (C) 47,917 76,425 70,000 101 34104.00 Plan Checking Fees (C) 259,610 185,934 174,452 130,000 Spec 0 Maps S Books s 101 34105.00 Sales of Maps Publications (C) 1,123 1,859 1,102 1,000 1,000 Ma Sp County Taking Over in 2009 101 34106.00 Deputy Registrar Fees (C) 58,563 56,373 58,703 5,000 0 101 34107.00 Assessment Searches (C) 160 0 0 0 34,770 47,750 25,000 101 34108.00 Admin Fees Other Funds (C) 101 34108.01 Applicable Funds Except Const. 25,000 25,000 25,000 25,000 25,000 101 34108.02 Construction Funds 187,875 96,785 91,434 50,000 0 7,000 101 34109.00 Other Charges for Service (C) 8,423 7,749 8,309 6,000 200 101 34110.00 Service Chg on Retumed Chks (C) 240 270 180 200 1,000 101 34112.00 Utility Permit Application Fee (C) 550 1,550 2,129 500 15,000 0 5,000 0 0 101 34113.00 Application Fees (C) 400,000 SKB Fees 101 34150.00 User Fees SKB (C) 257,556 315,490 339,518 300,000 25,000 Landscaping Agreement (Yr 7 of 10) 101 34151.00 User Fees /Host Agreements SKB(C) 25,000 25,000 25,000 25,000 46,000 101 34160.00 National Guard Maint Fees (C) 43,469 47,488 51,445 46,000 16,000 101 34160.00 Shared Space Rental Agreement 36,000 101 34160.00 Building Maintenance Contract 21,000 Contractual 0/T for 1 Officers 101 34201.00 Special Police Services (C) 16,117 23,145 52,675 21,000 2, 0 Co Longer Charge for Permits 101 34202.00 Fire Services Buming Permits (C) 450 300 800 0 101 34203.00 Accident Reports (C) 114 5 19 100 200 101 34204.00 Day Care Inspection Fees (C) 450 250 100 300 0 101 34206.00 Other Police Services (C) 136 176 713 0 15,000 101 34207.00 Other Fire Protection Services (C) 11,780 15,655 21,510 6,000 6,000 101 34207.01 U of M Fire Contract 4,000 6,000 101 34207.02 Coates Fire Contract 4,000 4,000 101 34207.03 Other Billed Fire Calls 0 0 0 101 34301.00 Street, Sidewalk Curb Repairs (C) 1,349 2, 0 0 2,448 2,55 0 1,500 101 34303.00 Mow Weeds (C) 0 Street Light Bills Developers 101 34306.00 Other Highway Street Rev (C) 18,990 2,852 20,551 2,000 0 101 34310.00 Right -of -Way Permlts (C) 0 0 17,990 0 3,000 101 34407.00 City Share of Metro SAC Chgs (C) 4,821 3,594 6,742 3,000 Total Charges for Services (C) 1,019,461 888,346 992,674 679,100 655,900 101 35101.00 Court Fines (F) 87,971 120,093 127,239 110,000 125,000 From County Total Fines Forfeits (F) 87,971 120,093 127,239 110,000 125,000 101 34720.00 Park Reservations (R) 879 2,417 4,881 2,500 2,500 Loss of Church 101 34721.00 Softball Revenues (R) 55,128 61,401 64,980 60,000 60,000 0 0 0 101 34722.00 Volleyball Revenues (R) 1,200 2,300 101 34724.00 Tennis Revenues (R) 1,990 2,354 2,522 2,300 22,000 101 34725.00 Tiny Tot Revenues (R) 21,928 21,932 18,334 22,000 000 7,300 101 34726.00 Rosettes Revenues (R) 949 510 1,110 1,200 1 1,200 101 34727.00 Field Trip Revenues (R) 988 4,658 5,000 1,284 1,735 2,300 4 989 1 101 34727.01 Youth/Teen Trips 1 g 794 4,, 101 34727.02 AdulUSenior Trips 0 No League in 2010 101 34728.00 Soccer League Revenues (R) 0 13,741 10,391 0 4,000 101 34730.00 Run for the Gold Revenues (R) 4,273 3,971 4,397 4,000 2 000 101 34731.00 Soccer Lessons (R) 2,006 1,980 3,335 2,000 2 000 101 34732.00 Adult Basketball Revenues (R) 1,052 2,108 1,406 2,000 14,000 101 34733.00 Other Programs Revenues (R) 14,072 16,227 13,468 14,000 12,000 101 34735.00 Camps Revenues (R) 12,743 13,028 13,095 12,000 5,000 101 34736.00 T -Ball Lessons (R) 5,150 5,176 5,287 5,000 0 101 34790.00 Other Recreation Revenues (R) 0 0 0 0 62,000 65,000 62 852 75,555 101 38080.00 Banquet Room Fees (R) 56,790 64, 7,000 101 38081.00 Auditorium Fees (R) 10,045 6,219 6,059 8,000 30,000 101 38082.00 Gymnasium Fees (R) 25,007 32,290 28,864 30,000 10,000 101 38086.00 Classroom Fees (R) 16,307 12,725 9,386 12,000 1,300 101 38096.00 Liquor Provider Fees (R) 1,170 1,320 1,230 1,300 1,000 101 38097.00 AN Rental Fees (R) 1,795 688 1,221 1,000 5,200 101 38154.00 Teen Night Revenues (R) 5,297 5,064 6,660 5,200 Total Recreation Fees (R) 248,857 274,740 278,574 253,800 253,800 PAGE TOTALS 1,356,289 1,283,179 1,398,487 1,042,900 1,034,700 Page Three September 1, 2009 Account Description 2010 BUDGET WORKSHEETS GENERAL FUND REVENUES 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget 101 36101.00 Principal Special Assessments (M) 14,878 12,119 15,680 10,000 10,000 From County 101 Funded Projects 93 15 31 0 0 From County 101 36102.00 Penalties Interest SIA (M) 101 36210.00 Interest Eamings Investments (M) 215,024 277,199 223,236 180,000 170,000 Annual Market Value C 101 36214.00 Net Change in FV- Investments (M) (3,216) 90,546 3,624 0 500 rom l Market Value Changes h Account 101 36215.00 Interest Earnings (M) 690 428 1,128 500 10,700 101 36220.00 Rents Royalties (M) 5,712 5,236 45,281 57,000 6,000 101 36220.01 Verizon Antenna Rent 3 000 101 36220.02 Athletic Complex Land Rental 1 700 Partial Year Rent New Lot Opening 101 36220.03 MVTA -RCC Parking Lot Rental 25,608 25,823 22,580 0 0 101 36230.00 Contribution /Donations (M) 101 36260.00 Other Revenue (M) 1,636 17,154 5,582 2,000 2,000 50,010 31,200 0 0 0 101 36262.00 Special Settlements (M) 5,000 101 38090.00 City Concessions (M) 5,171 5,108 4,986 5,000 Total Misc Revenues (M) 315,606 464,828 322,127 254,500 198,200 3,500 3,500 3,500 3,500 3,500 Arena Building Grounds Maint. 101 39202.00 Contribution from Enterprises (T) 0 85,469 7,133 0 0 Funds Retumed from Project 101 39203.00 Transfer From (T) Total Transfers In (T) 3,500 88,969 10,633 3,500 3,500 PAGE TOTALS $319,106 $553,797 $332,760 $258,000 $201,700 FUND TOTALS $8,500,226 $9,989,191 $10,925,291 $10,384,800 $10,496,500 INTERNAL REVENUES $3,098,967 $3,197,947 $3,224,040 $2,403,500 $2,185,500 Grand Coal Less: Ad Valorem Comments Page Four 2010 BUDGET WORKSHEETS GENERAL FUND REVENUES September 1, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Comments Account Description Actual Actual Actual Budget Amount Budget 101 34108.00 General Fund Admin Fees $25,000 $25,000 $25,000 $25,000 6,000 $25,000 101 34108.01 Fund 201 2,500 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 Fund 605 1,000 101 34108.07 Fund 606 ,000 101 34108.08 Fund 607 1 1,000 101 34108.09 Fund 650 Admin Fees Breakdown Totals $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 CITY COUNCIL The City Council is responsible for establishing the mission and vision for the City of Rosemount. The Council also establishes community goals and supervises the activities of the City Administrator. POLICY DEVELOPMENT Provides for the legislative and policy- making activities for all of municipal government Provides for the planning and control of all City expenditures through the adoption of the City's annual budget. Provides for the definition of the City's tax structure through the levying of taxes and approval of user fees and rate structures. Provides for citizen input to policy- making process by establishing, appointing and managing advisory commissions, ad hoc committees and community groups. GENERAL OPERATIONS Provides funding for general government projects and needs such as: City Newsletter Chamber of Commerce Directory Page One 2010 BUDGET WORKSHEETS COUNCIL September 1, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41110 103.00 Salaries Benefits $26,001 $34,338 $31,253 $35,500 $36,400 Salary, Taxes, PERA Benefits 101 41110 01 225.00 Landscaping Materials 25,021 25,005 25,154 25,000 25,000 SKB Landscaping Agreement 101 41110 01 307.00 City Promotional Fees 26,100 101 41110 01 307.01 Newsletter 13,756 22,263 27,718 29,000 25,000 101 41110 01 307.02 Chamber of Commerce Directory 1,065 1,065 2,130 1,100 1,100 101 41110 01 307.03 Community Survey 0 18,500 0 20,000 0 101 41110 01 319.00 Other Professional Services 548 10,000 101 41110 01 319.01 Education Reimbursement 11,897 10,909 5,834 8,000 8,000 101 41110 01 319.02 HIPP Initiatives 48 0 0 5,000 2,000 101 41110 01 319.04 Technology Study 0 24,500 1,000 0 0 101 41110 01 321.00 Telephone Costs 79 600 101 41110 01 321.01 Mayor's Pager 0 27 0 0 0 101 41110 01 321.02 Mayor's Cell Phone 0 0 63 600 600 101 41110 01 329.00 Other Communication Costs 70 0 0 1,000 500 Newspaper Ads Open Houses 101 41110 01 331.00 Travel Expense 3,500 101 41110 01 331.01 NLC Conference 1,450 3,418 1,627 2,000 2,000 101 41110 01 331.02 Miscellaneous Travel 229 1,448 1,185 1,000 1,500 101 41110 01 433.00 Dues Subscriptions 24,600 101 41110 01 433.01 LMC Dues 12,523 13,397 14,368 14,500 15,000 101 41110 01 433.02 AMM Dues 5,357 5,734 6,423 6,200 7,000 101 41110 01 433.03 Dak Cty Regional Chamber 579 0 579 600 800 101 41110 01 433.04 NLC Dues 1,324 1,377 1,432 1,400 1,600 101 41110 01 433.05 Miscellaneous Dues 120 120 120 300 200 101 41110 01 435.00 Books Pamphlets 0 44 46 100 100 101 41110 01 437.00 Conferences Seminars 6,000 101 41110 01 437.01 Registration Hotel -LMC Conf 1,243 677 515 2,000 1,000 101 41110 01 437.02 Registration Hotel -NLC Conf 3,697 4,379 4,363 4,000 4,000 101 41110 01 437.03 Miscellaneous Conferences 961 628 540 2,000 1,000 101 41110 01 439.00 Other Miscellaneous Charges 169 107 16 0 100 101 41110 01 598.00 Council Designated 59,330 15,330 36,815 165,300 100,000 252,400 Yearly Contingencies 101 41110 01 598.01 Library Site Expenditures 21,372 56,005 8,838 0 0 101 41110 01 598.02 Future Capital Expenditures 0 0 254,648 0 0 101 41110 01 598.03 Salary Benefit Contingency 0 0 0 0 152,400 Contingency for Negotiations 101 41110 01 599.00 Employee Recognition Costs 6,500 101 41110 01 599.01 Employee Recognition Costs 2,201 2,273 3,108 2,500 3,000 101 41110 01 599.02 Vending Machine Costs 3,513 3,914 3,607 3,000 3,500 Offset by Revenue from Machines 101 41110 01 599.03 Commemorations 0 0 0 0 0 PAGE TOTALS $192,553 $245,458 $431,383 $330,100 $391,800 DEPARTMENT TOTALS $192,553 $245,458 $431,383 $330,100 $391,800 GENERAL ADMINISTRATION RECORDS MANAGEMENT RECEPTION ADMINISTRATION DEPARTMENT The Administration Department is responsible for the overall management of all departments within the City and for assuring that departmental activities are consistent with the goals established by the City Council. Provides overall management administration and coordination of activities in all City departments including: Community Development, Finance, Fire, Police, Public Works and Parks Recreation. Provides for preparation and overall management of the City's budgets. Provides project management for projects that are unique and therefore not assignable to any other department. Provides overall coordination of City consultants. Provides for the execution of all policies as adopted by the City Council. Provides administrative and clerical support to the City Council including the preparation, distribution and maintenance of City Council meeting documents. Provides for the preparation and maintenance of official records for the City including Council, Port Authority and Commission minutes. Prepares and assures publication and posting of official notices. Provides public information on ordinances, contracts and policies. Administers the collection, storage and dissemination of data. Provides for the maintenance, training and supervision of the digital document management system. Provides General Government /City Hall reception administration. ADMINISTRATION DEPARTMENT Page 2 LICENSING Provides for the issuance and renewal of the following licenses: Liquor Peddlers, solicitors and transient merchants Lawful purpose gambling premise permits Block party street closures Massage therapy Arcade parlor, billiard hall and dance club PERSONNEL ADMINISTRATION Administers overall human resources programs and services. Provides services to improve employee recruitment, retention, safety, training, orientation and relations. Administers the City's personnel policies and procedures, assures compliance with union contract language, as well as state and federal labor regulations. Administers employee compensation, insurance, and benefit plans, assuring compliance with state and federal regulations. PUBLIC INFORMATION AND MARKETING Prepares communications to residents about City government activities. Creates and coordinates marketing publications directed to business sectors outside of the community for economic development. Assists in preparing messages and collateral material for internal communications. STAFFING For 2010, the department will consist of five positions: PERFORMANCE MEASURES Worker's Compensation Modification Factor 2004 2005 2006 2007 2008 2009 n/a n/a .78 .83 .82 n/a Turnover Rate of City Personnel 2004 2005 2006 2007 2008 2009 n/a n/a 9.0% 2.5% 2.5% n/a Average Monthly Unique Views on City Website 2004 2005 2006 2007 2008 2009 n/a n/a 4,830 6,683 8,444 6,580 (6 Months) n/a Information Not Available ADMINISTRATION DEPARTMENT Page 3 City Administrator Assistant City Administrator Communications Coordinator City Clerk Receptionist Page One September 1, 2009 2010 BUDGET WORKSHEETS ADMINISTRATION 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget All Salary Costs Inclusive of 101 41320 101.00 Salaries Benefits $381,348 $353,911 $369,001 $405,700 $407,800 Salary, Taxes, PERA Benefits 101 41320 102.00 Full -Time Overtime 1,159 20 1,712 2,000 2,000 101 41320 103.00 Part-Time Salaries Benefits 8,863 6,224 6,549 7,000 7,000 Temp Receptionist Coverage 101 41320 01 209.00 Other Office Supplies 455 165 129 500 500 Miscellaneous Purchases 101 41320 01 306.00 Personnel Testing Recruitment 0 0 0 0 0 101 41320 01 313.00 Temporary Service Fees 1,370 0 28,774 0 0 101 41320 01 319.00 Other Professional Services 1,706 180 0 1,500 0 101 41320 01 321.00 Telephone Costs 1,976 2,027 1,094 1,600 1,500 Administration CeII Phones 101 41320 01 331.00 Travel Expense 1,700 101 41320 01 331.01 NLC Conference 967 642 0 800 500 101 41320 01 331.02 ICMA Conference 382 395 873 800 800 101 41320 01 331.03 Miscellaneous Travel 362 396 40 400 400 101 41320 01 433.00 Dues Subscriptions 2,100 101 41320 01 433.01 MCMA Dues 187 194 191 200 250 101 41320 01 433.02 MAMA Dues 40 40 80 100 100 101 41320 01 433.03 MCFOA Dues 35 35 0 50 50 101 41320 01 433.04 Munici -Pals 165 25 25 150 100 101 41320 01 433.06 ICMA Dues 2,111 909 2,213 1,500 1,500 101 41320 01 433.07 APMP Dues 20 0 63 100 100 101 41320 01 435.00 Books Pamphlets 606 322 92 1,000 200 101 41320 01 437.00 Conferences Seminars 8,000 101 41320 01 437.01 Registration Hotel LMC 394 340 0 500 500 101 41320 01 437.02 Registration Hotel MCMA 498 1,132 1,033 1,200 1,300 101 41320 01 437.04 Staff (1) Each 0 70 75 200 200 101 41320 01 437.05 Miscellaneous Seminars 577 1,893 2,579 4,000 1,000 ULI Greening Initiatives 101 41320 01 437.06 Registration Hotel ICMA 1,422 3,389 2,415 2,500 2,500 101 41320 01 437.07 City Clerk Training 450 410 1,020 800 800 All MCFOA Events 101 41320 01 437.08 Registration Hotel NLC 1,890 1,257 0 2,500 1,200 101 41320 01 437.09 Miscellaneous Meetings 18 490 95 0 500 101 41320 01 439.00 Other Miscellaneous Charges 125 92 26 100 100 101 41320 01 580.00 Other Equipment Purchases 1,265 0 895 900 900 PAGE TOTALS 408,392 374,558 418,975 436,100 431,800 Comments Page Two 2010 BUDGET WORKSHEETS ADMINISTRATION September 1, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Comments Account Description Actual Actual Actual Budget Amount Budget 101- 41320 -01 -31 -xxx is for Human Resources 115 2,000 Employee Drug Testing 101 41320 31 305.00 Medical Dental Fees 0 0 846 500 500 101 41320 31 305.01 Pre- Employment Physicals 0 0 84 1,500 1,500 101 41320 31 305.02 Employee Drug Testing 2,000 101 41320 31 315.00 Special Programs 858 219 1 629 5,000 2,000 101 41320 31 315.01 Employee Training 0 Wellness &Health M 101 41320 31 315.02 HIPP Initiatives 2,419 663 1,427 2,000 0 Now Covered H lth Management anagem 101 41320 31 315.03 EAP 0 717 699 1,000 5,400 Insurance (5 101 41320 31 319.00 Other Professional Services (567) 0 600 1,000 1,000 101 41320 31 319.01 Labor Consultant 5 67 249 0 900 900 101 41320 31 319.02 Labor Legal Issues 0 0 0 1,000 1,000 101 41320 31 319.04 COBRA Consultant 101 41320 31 319.05 FIexNEBA Administrative Fees 2,855 2,279 2,325 3 500 2 50 101 41320 31 319.06 SW 0 WC Co- Operative Dues 298 5 517 400 400 101 41320 31 331.00 Travel Expense 3,000 Vacancies 101 41320 31 341.00 Employment Advertising 11,672 975 2,504 6,000 101 41320-01 -41 -xxx is for Communications 600 310 0 101 41320 31 433.00 Dues Subscriptions 350 0 0 4 101 41320 31 433.01 "Future Use" 310 145 3 50 300 200 101 41320 31 433.02 IPMA Dues 1 0 400 400 400 101 41320 31 433.03 MPELRA Dues 300 Books &Training Materials 101 41320 31 435.00 Books Pamphlets 402 84 315 300 600 0 0 101 41320 31 437.00 Conferences Seminars 370 300 300 13 249 3 101 41320 31 437.01 MPELRA State Conference 105 300 300 101 41320 31 437.02 Personnel Seminars 0 0 0 4 00 0 101 41320 31 437.03 Safety, Supervisor, Policy 39,439 24,489 4,243 25,000 7,300 9, 101 41320 41 315.00 Special Programs 30 0 0 0 5,000 Special Mailings 101 41320 41 315.01 General Marketing 101 41320 41 315.02 Historical Monuments 0 0 0 0 5,000 2,500 Consultants &Cable TV 160 1,354 1,020 5,000 500 Con Supplies, Software 101 41320 41 319.00 C able Supply Cos Services 382 178 198 3,000 101 41320 41 328.00 Cable Supply Costs 36,285 0 0 50,600 101 41320 41 329.00 Other Communication Costs 0 37,929 41,462 43,000 43,000 101 41320 41 329.01 Cable JPA Payment General City 5 4,739 8,400 5,000 0 2,726 101 41320 41 329.02 Video Streaming Council Meeting: 0 7,95 4,739 4,200 2,600 101 41320 41 329.03 Bulk E -Mail System 185 304 174 200 300 101 41320 41 331.00 Travel Expenses 60 60 60 200 200 MAGC 101 41320 41 433.00 Dues Subscriptions 0 0 55 400 300 Technical Courses 101 41320 41 437.00 Conferences Seminars 5,616 988 2,900 1,000 101 41320 41 580.00 Other Equipment Purchases 3,350 PAGE TOTALS $98,541 $83,454 $68,550 $117,400 $77,000 DEPARTMENT TOTALS $506,933 $458,013 $487,524 $553,500 $508,800 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 VOTER REGISTRATION SUPPLIES EQUIPMENT CONTRACTED SERVICES Provides for the maintenance agreements for service and repair of the voter assist terminals and the ballot counters. STAFFING ELECTIONS Provides for conducting all local, state and federal elections. Provides for the maintenance and execution of procedures for voter registration. Provides for the necessary supplies and minor equipment necessary to conduct the elections. Provides for continued use of polling locations. Provides for the recruitment, appointment, training and supervision of election judges to carry out Election Day activities at the City's seven precinct polling locations. Provides for training of absentee ballot board. PERFORMANCE MEASURES Average Number of Registered Voters per Precinct 2004 2005 2006 2007 2008 2009 n/a n/a 1,619 1,578 1,671 1,836 n/a Information Not Available Page One 2010 BUDGET WORKSHEETS ELECTIONS September 1, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 41410 01 103.00 Part-Time Salaries $19,339 $0 $30,001 $0 $24,000 Election Judges 101 41410 01 203.00 Printed Forms Paper 306 0 3,311 0 4,200 Ballots Programming 101 41410 01 208.00 Miscellaneous Supplies 489 (18) 617 0 700 101 41410 01 219.00 Other Operating Supplies 428 (25) 777 0 800 Food for Election Judges 101 41410 01 242.00 Minor Equipment 2,397 0 1,218 0 1,500 Booths Signs 101 41410 01 319.00 Other Professional Services 0 0 0 0 0 101 41410 01 321.00 Telephone Costs 352 57 86 100 0 101 41410 01 351.00 Legal Notices Publishing 0 0 0 0 0 Election Publications 101 41410 01 409.00 Other Contracted Repair Maint 0 0 2,300 101 41410 01 409.01 Maintenance for AutoMarks 1,225 1,300 1,300 Voting Machines 101 41410 01 409.02 Maintenance for Accuvotes 1,000 1,000 1,000 Voting Machines 101 41410 01 412.00 Building Rental 0 400 0 0 0 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 15,000 60,000 1,234 37,600 6,500 PAGE TOTALS $38,311 $60,415 $39,468 $40,000 $40,000 DEPARTMENT TOTALS $38,311 $60,415 $39,468 $40,000 $40,000 The Finance Department is responsible to work with all departments of the City, especially the Administration Department, to ensure that all activities of the City are conducted in a fiscally responsible manner GENERAL ADMINISTRATIVE Provides for the fiscal management, processing and maintenance of all accounting transactions for all funds of the City, including budgetary controls, preparation of interim accounting reports and the Comprehensive Annual Financial Report (CAFR). Also responsible for all other reporting requirements of the Federal, State, County and other government agencies in regards to budgets, taxes, financial statements, TIF Districts and other items. DATA PROCESSING 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 in -house consultant providing technical assistance when possible, and if not possible, coordinating the procurement of outside technical assistance when needed. Fund Management Collects and deposits revenues and manages the investment of idle funds. Budgetary Compiles historical and current expenditure and revenue data to facilitate budget preparation. Bonding Assists in the issuance, sale and record maintenance of indebtedness. Insurance Maintains records for property and workers comp insurance requirements, handles all claims and prepares all documents for yearly renewals of policies. PAYROLL FINANCE DEPARTMENT Page 2 Receives employee time sheets, coordinates insurance, pay rates and other applicable payroll information with personnel, prepares payroll checks, prepares all Federal and State required reports, prepares all employee withheld and employer promised obligation funds for disbursement to applicable organizations, and prepares all reports as needed, both internally and externally. UTILITY BILLING Coordinates the automated reading of all City water meters and the mailing and collection of all utility bills. Handles on the computer system, the preparation of final bills and the setup of new accounts. Fields and responds to utility billing questions and complaints. Compiles operating statistical information which is available to other departments as needed. ACCOUNTS PAYABLE Processes purchase orders prepared by all departments, checking for accuracy and matching with invoices and all other supporting documentation so payments can be made in a timely manner. Also, prepares all checks and supporting reports that accompany each check run. Coordinates the review of bills by Council by providing applicable reports and supporting documentation. ACCOUNTS RECEIVABLE CASH RECEIPTS Prepares invoices for all departments for items /services that must be billed to outside sources. Maintains records that allow for the timely collection of invoiced items /services. Receipts monies on a daily basis and deposits those monies daily in designated banking institutions. Maintains a system that allows for the appropriate reporting of all monies collected within the accounting system FINANCE DEPARTMENT Page 3 FIXED ASSETS Responsible for the maintenance of the fixed asset system. This includes all additions, deletions and changes in fixed assets for the City. It also includes the periodic physical reinventory of all current fixed assets. Also responsible for the corresponding reporting requirements that go along with the system, including year -end information, insurance renewal information and individual department information. SPECIAL ASSESSMENTS Responsible for the maintenance of the special assessments records including the implementation of our own records system that will be used to ensure that Dakota County's assessment balances are correct and in agreement with ours. Works with the Engineering Department for additions to the special assessment collections p Responsible edal for coordinating all deletions and changes to the system as well as assessment payments. STAFFING In 2010, the department will consist of eight positions: Finance Director Accounting Supervisor IT Coordinator Payroll Clerk Accounts Payable Clerk Utility Billing /Special Assessment Clerks (2 Full-Time 1 Part -Time) PERFORMANCE MEASURES City Bond Rating 2004 2005 2006 2007 2008 2009 Al Al Al Aa3 Aa3 Aa3 (10/1/07) FINANCE DEPARTMENT Page 4 GFOA Certificate of Achievement Award Received 2004 2005 2(_)9_6_ 2007 2008 2009 Yes Yes Yes Yes (Applied) n/a Of Accounts Payable Checks Processed 2004 2005 2006 2007 2008 2009 n/a n/a n/a 3,098 3,081 n/a Of Utility Bills Processed 20Q4 2005 2006 2007 2008 2009 n/a 27,654 28,767 29,000 (est.) 29,902 n/a n/a Information Not Available Page One September 1, 2009 Account 2010 BUDGET WORKSHEETS FINANCE Description 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget PAGE TOTALS $293,820 $330,105 $391,299 $417,900 $417,700 DEPARTMENT TOTALS $293,820 $330,105 $391,299 $417,900 $417,700 Comments All Salary Costs Inclusive of 101 41520 101.00 Salaries Benefits $194,877 $206,431 $248,981 $290,500 $292,100 Salary, Taxes, PERA Benefits 101 41520 102.00 Full -Time Overtime 1,957 1,557 2,257 3,000 3,000 101 41520 103.00 Part-Time Salaries Benefits 20,023 31,448 35,363 42,600 44,900 101 41520 01 321.00 Telephone Costs 0 0 137 600 1,000 Cell Phone Allowances (2) 101 41520 01 331.00 Travel Expense 1,400 101 41520 01 331.01 Finance Director 472 894 1,015 1,200 1,200 National Convention Misc 101 41520 01 331.02 Staff 10 80 6 300 200 101 41520 01 391.00 P.C. Maintenance 48,100 101 41520 01 391.01 Civic Systems Applications Support 4,810 5,035 5,187 5,500 5,500 101 41520 01 391.02 Citrix Maintenance Renewal 0 1,240 959 1,400 1,400 101 41520 01 391.03 Incode Software Maintenance 6,082 6,329 6,642 7,000 7,000 101 41520 01 391.04 General Network Support 40,000 50,000 49,657 25,000 20,000 200 Hours of Support Time 101 41520 01 391.05 "Future Use" 0 0 0 0 0 101 41520 01 391.06 Fixed Asset Maint Contract 1,211 1,211 1,211 1,300 1,400 Price Increase 101 41520 01 391.07 Miscellaneous P.C. Repairs 1,290 2,133 1,957 2,800 2,800 101 41520 01 391.08 Anti -Virus Software Renewal 2,260 4,163 7,493 8,000 8,000 101 41520 01 391.09 File Server Software Maintenance 0 1,204 795 1,500 2,000 101 41520 01 392.00 P.C. Accessories Supplies 2,929 2,788 3,059 4,000 4,000 City System Supplies 101 41520 01 393.00 P.C. Hardware Purchases 1,218 1,447 13,679 2,500 2,500 101 41520 01 394.00 P.C. Software Purchases 15,000 101 41520 01 394.01 Annual Microsoft Office Payment 9,811 9,811 9,811 10,000 10,000 Annual Payment Thru 2011 101 41520 01 394.02 Miscellaneous S/W Purchases 0 0 160 5,000 5,000 Potential True -Up Costs 101 41520 01 409.00 Other Contracted R M 105 105 105 200 200 Non Computer Equipment 101 41520 01 433.00 Dues Subscriptions 900 101 41520 01 433.02 MnGFOA Finance Director 40 40 60 50 100 101 41520 01 433.03 MnGFOA Staff 200 200 360 250 450 101 41520 01 433.04 GFOA Finance Director Asst. 305 315 325 350 350 101 41520 01 433.05 Magazine Subscriptions 0 0 0 50 0 101 41520 01 435.00 Books Pamphlets 100 101 41520 01 435.01 Accounting Related Books 0 0 37 50 50 101 41520 01 435.02 Finance Related Books 0 0 0 50 50 101 41520 01 437.00 Conferences Seminars 3,300 101 41520 01 437.02 MnGFOA Annual Conf (F /D Ass't) 526 551 551 1,000 1,000 101 41520 01 437.03 GFOA National Conf (F /D) 0 1,270 1,111 1,500 1,300 101 41520 01 437.04 Staff Development 644 930 0 1,000 500 101 41520 01 437.05 Miscellaneous Seminars 791 370 230 1,000 500 101 41520 01 439.00 Other Miscellaneous Charges 134 553 155 200 200 Contingencies 101 41520 01 570.00 Office Equipment Furnishings 4,127 0 0 0 1,000 Office Chairs GENERAL GOVERNMENT DUPLICATING COPYING Provides for maintenance agreements and expenses to operate copy machines at all City facilities. Also provides for digital document management costs. PRINTED FORMS PAPER Provides for copy paper utilized by all departments and provides for forms utilized by the Finance Department. ENVELOPES LETTERHEADS Provides for letterhead utilized by all departments and for various types and sizes of envelopes. OTHER OFFICE SUPPLIES Provides for general office supplies utilized by all City departments. EQUIPMENT PARTS Provides for the maintenance and repair of general office equipment. AUDITING ACCOUNTING SERVICES LEGAL FEES Provides for the annual audit of the City's accounting transactions for all funds of the City and for the preparation of the Comprehensive Annual Financial Report. Also provides for other services as required of the City's financial and accounting consultants. 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 costs of the City's telephone system, monthly service fees, long distance calls and miscellaneous installation costs. Also, provides for fees associated with the City's e-mail and web services. POSTAGE COSTS Provides for postage costs for all departments and maintenance agreements for the postage machine and postage allocator. OTHER TRANSPORTATION EXPENSES Provides for two -year renewals of City vehicle license plates, emission fees and duplicate plates, titles or tags, if needed. LEGAL GENERAL NOTICES PUBLISHING Provides for the publication of legal documents from all departments except when publication costs are charged to specific projects. LEASE AGREEMENTS Provides for leasing of copy machines at City Hall, Community Center and the Police Department. Page One September 1, 2009 Account 2010 BUDGET WORKSHEETS GENERAL GOVERNMENT Description 2006 2007 Actual Actual 2009 2010 Object 2010 2008 Adopted Detail Proposed Actual Budget Amount Budget 101 41810 01 202.00 Duplicating Copying 9,000 101 41810 01 202.01 Records Retention 8,200 7,998 7,535 14,282 7,53 5 19,000 101 41810 01 202.02 Copying Costs 101 41810 01 203.00 Printed Forms Paper 7,321 5,000 8,000 513 4,911 101 41810 01 203.01 Copy Paper 4,513 9 743 800 800 101 41810 01 203.02 General Receipt Books 1,528 0 1,602 1,500 1,700 280 284 2, 101 41810 01 203.03 Purchase Orders 1 02 1,500 1,500 101 41810 01 203.04 Payroll A/P Checks 564 1,991 1 00 1,200 1,000 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 "Future Use" 101 41810 01 242.02 Credit Card Equipment 101 41810 01 301.00 Auditing Accounting Services 101 41810 01 301.01 Audit General Consulting Fees 101 41810 01 301.02 Dakota County Assessment Fees 101 41810 01 301.03 Dak Cty Truth In Taxation Costs 101 41810 01 301.04 Printing of Budget Books 101 41810 01 303.00 Engineering Fees 101 41810 01 304.00 Legal Fees 101 41810 01 319.00 Other Professional Services 101 41810 01 319.01 City Code Update 101 41810 01 319.02 City Code Web Fees 101 41810 01 319.03 State Building Report (Springsteds) 101 41810 01 319.04 Continuing Disclosure Fees 101 41810 01 319.05 Annual User Fee Study Update 101 41810 01 319.06 Arbitrage /Rebate Calculations 101 41810 01 319.10 UMore Professional Services 101 41810 01 320.00 Credit Card Activity Fees 101 41810 01 320.01 Utilities' Fees 101 41810 01 320.02 Parks Recreation Fees 101 41810 01 320.03 Building Fees 101 41810 01 320.04 General Fees 101 41810 01 321.00 Telephone Costs 101 41810 01 321.01 General Phone Costs 101 41810 01 321.02 Domain Housing 101 41810 01 322.00 Postage Costs 101 41810 01 339.00 Other Transportation Expenses 101 41810 01 351.00 Legal Notices Publishing 101 41810 01 351.01 Costs for Public Notices 101 41810 01 351.02 Truth in Taxation Notices 101 41810 01 351.03 Budget Audit Publications 101 41810 01 391.00 P.C. Maintenance 101 41810 01 392.00 P.C. Software Purchases 101 41810 01 393.00 P.C. Hardware Purchases 101 41810 01 433.00 Dues Subscriptions 101 41810 01 439.00 Other Miscellaneous Charges 101 41810 01 450.00 Sales Tax on Purchases 26,212 24,974 101 41810 01 580.00 Other Equipment Purchases 22,097 M PAGE TOTALS $326,722 $360,463 $348,898 DEPARTMENT TOTALS $326,722 $360,463 $348,898 $403,300 $387,700 0 0 0 350 0 467 0 0 250 300 $12,000 0 12,000 3,824 2,850 2,643 4,000 3,000 340 268 586 500 600 362 459 689 500 800 1,500 0 0 5,000 O 0 0 0 O 0 0 0 140 721 841 500 10,195 260 260 500 O 0 0 29,000 29,000 $403,300 $387, Comments Moved to "391.00" Below 13,000 Business Cards, etc. 5,500 695 1,542 2,054 1,600 2,000 1,310 2,464 1,327 1,600 1,600 O 0 0 500 700 1,095 0 1,155 600 1,200 O 0 0 200 0 19,000 General Office Supplies 18,859 16,068 17,228 18 500 0 City Hall Equipment Repairs O 0 0 300 82,000 Increased GASB Requirements 61,167 64,204 72,635 75,000 75,000 2,922 3,449 3,373 4,000 4,500 1,741 1,840 1,832 2,500 2,000 393 (205) 0 500 500 7,631 12,767 2,978 0 0 75,000 General City Legal Fees 62,728 63,537 63,370 75,000 34,300 567 540 1,853 2,300 1,500 O 250 250 1,500 300 8,390 8,760 3,870 11,000 9,500 2,000 2,000 2,000 4,000 4,000 O 14,225 4,675 11,000 8,000 9,450 11,900 3,750 15,000 10,000 O 0 3,005 1,000 1,000 2,711 141 980 1,127 1,000 1,400 510 4,158 4,236 6,000 6,000 187 1,080 3,347 4,000 12,000 228 245 593 1,000 600 62,916 70,048 73,941 70,000 40,000 0 0 60 100 100 17,783 19,569 20,029 20,000 24,000 801 33 813 800 800 Vehicle Licensing 4,400 All Departments Billing from Dakota County State Mandated Publications Laserfishe Maintenance Laserfishe Software (Phase 3) Scanner Purchase Fees Paid to Springsted Fees Paid to Springsted (Bonds) Fees Paid to Springsted Fees Paid to Springsted 20,000 Add'I Services at City Hall 40,100 10,000 14,600 2,200 Includes Internet Costs 1,000 Newspapers 500 Direct Deposit Filing Fees/Flex 0 Sales Tax Audit Office Machine Leases -All Bldgs. COMMUNITY DEVELOPMENT OVERVIEW: MISSION, VISION AND GOALS The Community Development Department playsc u a ole as the e City ible manned its mission of providing a safe, healthy and pleasant ty The Building Inspection and Planning Divisions play a ke role in th making ty Co cu $oafs in and pleasant community. These divisions are also involved reaching affordable housing and property maintenance. by fostering The Economic Development Division addr dtvis on helps City's City rs is hometown character opportunities to live, work and shop. The p and pride, for example, through downtown redevelopment. The division, along with the Rosemount Port Authority, plays a vital role in meeting goals of the City Council such as commercial enhancement and business growth. BUILDING INSPECTIONS Is responsible for providing the services of building permit review, building inspection, code administration, consultation and review on new and existing buildings and structures within the City. Is responsible for the maintenance and enforcement of city ordinances and codes relating to building, health, life safety, fire and environmental conditions and to assure local compliance with county, state and federal regulations relating to the same activities. Is responsible for the successful implementation of all emounral development and assuring regulated and controlled standards Is responsible for monitoring and permitting all individual sewage treatment systems within the City. Is responsible for reports submitted to all appropriate jurisdictions concerning building activities. COMMUNITY DEVELOPMENT Page 2 CODE ENFORCEMENT Is responsible for enforcement of city ordinances and codes relating to health, life safety, environmental, and nuisance conditions and assure local compliance with county, state and federal regulations relating to the same activities. Is responsible for sign ordinance implementation and permitting. Is responsible for drafting of code text amendments to carry out Council goals and City initiatives. Is responsible for rental housing inspection and permitting. Is responsible for sequential code enforcement program, which is a city initiated program for resident education and neighborhood code compliance. PLANNING Is responsible for reviewing proposed developments for compliance with the zoning and subdivision ordinance and c industrial pa rt op ntsaff review of all residential, commercial, institutional Is responsible for providing recommendations to Planning Commission and City Council on all deliberations concerning land use, zoning, variances, site plan reviews, platting and special permits (interim use permits, mining permits, etc.). Is responsible for maintaining zoning and subdivision ordinances and the City's Comprehensive plan in compliance with county, state and federal requirements (statutes and rules). Is responsible for long -range planning and special studies that guide the physical development of the community. Is involved with state and regional activities affecting the City, including, but not limited to, land use, transportation, mining, housing and environmental services. Includes active participation by departmental staff in various committees and organizations. Is involved with issuance of development related permits such as grading and building permits. COMMUNITY DEVELOPMENT Page 3 ECONOMIC DEVELOPMENT Is responsible for marketing development opportunities within the City and creating an interest in Rosemount. Is responsible for creating and coordinating the establishment of tax increment districts and other economic incentives. Is responsible for creation and expansion of a local Business Retention program. Is responsible for coordinating the state, county and local approval processes to insure the proponent's requests are met in a timely fashion. Is responsible for staffing the majority of functions of the Rosemount Port Authority. Is involved with state and regional economic development organizations and functions. PERFORMANCE MEASURES COMMUNITY DEVELOPMENT Page 4 Planning Application Processed Within 60 Days 2004 2005 2006 2007 2008 2009 n/a n/a 79% 86% 87% 94% Requested Inspections Completed Within One Day 2004 2005 2006 2007 2008 2009 n/a n/a n a n a n a 100% Residential Plan Reviews Fully Completed Within 10 Working Days 2004 2005 2006 2007 2008 2009 n/a n a n a n a n/a 96.6% Code Complaints Resolved 2004 2005 2006 2007 2008 2009 n/a n a n /a 98% 95% 81% Existing Businesses Visited 2004 2005 2006 2007 2008 2009 n/a n a n a n a n/a n/a Information Not Available All 2009 figures are estimates for the first 6 months of the year. Page One September 1, 2009 2010 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41910 101.00 Salaries Benefits $763,813 $797,187 $832,464 $888,700 $898,800 Salary, Taxes, PERA Benefits 101 41910 102.00 Full -Time Overtime 1,758 435 0 2,000 1,000 101 41910 99 103.00 Part -Time Salaries Benefits 6,118 2,587 3,367 5,000 4,500 Planning Commission Members 101 41910 01 201.00 Office Accessories 9 0 0 400 0 Calendars, Planners, etc. 101 41910 01 202.00 Duplicating Copying 3,267 1,344 7,557 8,000 3,000 101 41910 01 203.00 Printed Forms Paper 1,111 3,712 4,100 4,000 4,000 Forms, Stickers, Tags, etc. 101 41910 01 205.00 Drafting Supplies 0 0 0 100 0 101 41910 01 208.00 Miscellaneous Supplies 15 21 53 200 0 101 41910 01 209.00 Other Office Supplies 331 295 77 600 600 Dictation Devices Tapes 101 41910 01 219.00 Other Operating Supplies 944 1,302 638 1,500 2,000 Chairs 101 41910 01 241.00 Small Tools 106 160 0 400 200 Inspectors' Tools 101 41910 01 302.00 Architects' Fees 0 275 0 0 0 101 41910 01 319.00 Other Professional Services 911 250 0 1,000 1,000 Consultant 101 41910 01 329.00 Other Communication Costs 1,710 3,128 2,443 2,800 3,600 Cell Phones Pagers (Add F/M) 101 41910 01 331.00 Travel Expense 1,279 540 472 700 600 101 41910 01 391.00 P.C. Maintenance 2,566 2,184 2,318 3,000 2,700 Permitworks Support 101 41910 01 392.00 P.C. Accessories Supplies 0 0 0 500 300 101 41910 01 393.00 P.C. Hardware Purchases 0 0 0 0 0 101 41910 01 433.00 Dues Subscriptions 3,100 101 41910 01 433.01 APA/AICP 1,187 1,006 1,131 1,500 1,300 101 41910 01 433.02 ICC 100 100 0 200 200 101 41910 01 433.03 AMBO 480 200 260 300 300 101 41910 01 433.04 10,000 Lakes 50 75 115 150 150 101 41910 01 433.05 "Future Use" 0 0 0 0 0 101 41910 01 433.06 Trade Magazines 50 42 0 200 200 101 41910 01 433.07 Planner's Journal 0 0 0 100 0 101 41910 01 433.08 Sensible Land Use Coalition 448 201 150 400 300 101 41910 01 433.09 AACEO/MAHCO 0 0 0 300 100 101 41910 01 433.10 Other Dues Subscriptions 33 533 562 50 550 101 41910 01 435.00 Books Pamphlets 134 910 557 700 700 Manuals, References, IBC Books 101 41910 01 437.00 Conferences Seminars 7,300 101 41910 01 437.01 State Bldg Official School 525 70 495 550 550 101 41910 01 437.02 Spring Fall Code Updates 295 60 370 300 400 101 41910 01 437.03 Building Inspector Training 255 184 952 1,000 1,000 101 41910 01 437.04 Computer Training 537 0 32 400 300 101 41910 01 437.05 Clerical Seminars 70 0 743 500 400 101 41910 01 437.06 Planning Seminars 1,521 1,783 5,094 1,500 1,800 101 41910 01 437.07 ISTS Training 830 429 0 500 500 101 41910 01 437.08 State Planning Conference (2) 245 0 104 1,000 1,000 101 41910 01 437.09 Planning Commissioner Training 25 0 305 250 250 101 41910 01 437.10 Gen'I Seminars 1,218 955 0 400 400 101 41910 01 437.11 Code Enforcement Training 293 0 239 400 700 101 41910 01 439.00 Other Miscellaneous Charges 0 0 90 400 400 Contingencies PAGE TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed $792,234 $819,969 $864,689 $930,000 $933,800 DEPARTMENT TOTALS $792,234 $819,969 $864,689 $930,000 $933,800 POLICE DEPARTMENT The Department provides police services through its staff on a 24/7/365 basis. Staffing levels have grown along with the community and services have been enhanced and expanded as the additional staffing has been added. Specific functions completed within the Department include: ADMINISTRATION AND MANAGEMENT This budget provides for the overall planning, coordination and management of personnel and administration of activities within the Police Department. This includes the collection, preparation and filing of crime data and miscellaneous reports with the State of Minnesota; preparation and oversight of the operating and capital improvements budgets; and strategic planning for the future needs of the Department and the community. PATROL This is the most visible function of the Department. Patrol officers are recognized in the community because of their uniforms and marked police squads. They also are the first responders to calls for service regardless of whether it is a medical response, motor vehicle crash or a criminal act. The overall goal of the patrol officers is the protection of life and property and the creation of a sense of security in the community. This is accomplished through visible patrolling, the enforcement of traffic laws, the arresting of criminal offenders and the delivery of other non emergency services. CRIMINAL INVESTIGATION Patrol officers and detectives are responsible for the investigation of criminal incidents through the gathering, analysis and presentation of evidence and testimony. Investigations that are more complex or cross municipal boundaries are coordinated by the detectives. This is accomplished by working cooperatively with other police agencies, the County Attorney's Office, Child Protection, victim services and other federal and state law enforcement agencies. CRIME PREVENTION AND COMMUNITY EDUCATION PROGRAMS A significant effort is made by the police department to inform residents of crime within the community, methods that citizens can take to help prevent crimes and building relationships with community members. While these objectives are part of each officers' daily responsibilities, there are specific programs that are frequently associated with community policing and that emphasize the need for the police and citizens to work together to prevent criminal activity and reduce the opportunities for criminals to commit crimes. POLICE DEPARTMENT Page 2 Drug Abuse Resistance and Education (D.A.R.E.) Students are taught skills to resist and alcohol. A police officer instructs the the temptations to use illegal drugs at Rosemount and Shannon Pa k Elementary ten-week program to all fifth grade students Schools as well as students at St. Joseph's Catholic 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 Officers serves as a liaison to the Rosemount Middle and High Schools. One officer is assigned full-time to the High School and a second officer spends one quarter time at the Middle school. The liaison officers investigate criminal incidents that occur at the schools or that involve students at the schools. In addition, the liaisons work with the school staff to enhance the safety and security for both staff and students. Presentations on a variety of topics are made by the liaison to classes at all grade levels. Community Education In order to work together with the community, police must share information concerning criminal activity and crime prevention with and community. Officers are available to make presentations to community groups organizations on a variety of topics. In addition, officers provide prevention tips to persons on a daily basis whom report criminal activity. Several events are also held throughout the year in an effort to build relationships with the residents and business persons. These include National Night Out block parties and gatherings, Neighborhood Watch meetings and Public Safety in the Park events. Reserve Officer Program Reserve officers are volunteers whom supplement the staff of sworn officers of the Department. The reserve officers are utilized to handle traffic and crowd control duties during city festivals and celebrations or emergencies, such as hazardous materials spills or leaks, damage resulting from tornadoes or other severe weather and major criminal inciden s stalled motoristsandnanimal complaints. T handle service calls, for example, assisting are also utilized regularly to provide crime prevention information to citizens at community events or through other programs. Chaplain Program The Police Chaplains are used by officers to assist in a variety of situations in which individuals or families are having difficulties. Chaplains are able to provide support to persons that are experiencing stress as a result of the death of a loved one, marital or family problems, financial struggles or any other event. By utilizing the chaplains to console and counsel persons in crisis, police officers are able to get back to other duties, while the chaplains are able to remain with the persons involved in the crisis. ANIMAL CONTROL The Police Department is responsible for the enforcement of ordinances related to the control and care of domestic animals. These tasks are mainly handled by Community Service Officers. Their duties include the licensing of dogs, cats and ferrets, assisting in the handling of stray, lost or injured animals and other complaints of animals causing a nuisance by barking, howling or being allowed to roam off the owner's property. CODE ENFORCEMENT The Police Department assists the Community Development Department with code enforcement of city ordinances related to property maintenance and outside storage. The Department's Community Service Officers primarily handle this effort. Property owners that are observed to be in violation of an ordinance are notified of the violation and given an explanation of how to remedy the violation. The enforcement of city ordinances is important to maintain community standards, which help the City attain its mission of providing a safe, healthy and pleasant community. EMERGENCY MANAGEMENT POLICE DEPARTMENT Page 3 The City has an all hazards emergency plan and the Chief of Police serves as the City's emergency manager. The emergency manager is responsible for the development of emergency plans in the event of a chemical, technical or natural disaster in the community, e.g. tornado, flooding or hazardous materials release. PERFORMANCE MEASURES Number of Licensed Officers per 1000 Residents 2004 2005 2006 2007 2008 2009 n/a .94 .95 .97 .98 .97 Number of Non licensed Employees per 1000 Residents 2004 2005 2006 2007 2008 2009 n/a .22 .22 .21 .20 .20 Number of Car Crashes with Personal Injury Resulting 2004 2005 2006 2007 2008 2009 41 23 38 33 30 23 2003 2004 2005 2006 2007 2008 Total 467 519 488 467 428 398 Reported Rate per 3130 3129 2851 2578 2196 1860 1000 n/a Information Not Available POLICE DEPARTMENT Page 4 Part I Crimes Per 1000 Part II Crimes 2003 2004 2005 2006 2007 2008 Total 1036 717 879 858 1020 952 Reported Rate per 6945 4380 5136 4737 5246 4450 1000 Case Clearance Rate of Reported Crimes (Percent Solved) 2003 2004 2005 2006 2007 2008 55% 55% 59% 57% 61% 62% DWI Arrests 2003 2004 2005 2006 2007 2008 Number 76 75 128 170 251 236 of Arrests Rate per 500 458 747 938 1291 1291 1000 Night to Unite (National Night Out) Neighborhood Parties 2004 2005 2006 2007 2008 2009 Number n/a 26 34 25 31 36 of Events Response Time to Priority 1 Calls for Service 2004 2005 2006 20 7 2008 2009 5.62 5.50 6.00 5.97 6.38 n/a Page One September 1, 2009 2010 BUDGET WORKSHEETS POLICE 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 42110 101.00 Salaries Benefits $1,894,055 $1,995,799 $2,144,449 $2,334,500 $2,307,100 Salary, Taxes, PERA Benefits 101 42110 102.00 Full -Time Overtime 76,321 72,650 112,323 65,000 65,000 101 42110 102.01 Regular Overtime Hours 44,000 101 42110 102.02 Contracted O/T 21,000 101 42110 103.00 Part-Time Salaries Benefts 105,800 101 42110 22 103.00 Part -Time Receptionist (2) 0 0 0 0 49,800 2 P/T Receptionists 44 Hrs/Wk 101 42110 23 103.00 Part-Time Secretary 8,434 10,006 9,618 22,200 20,000 P/T Secretary 14 Hours/Wk 101 42110 99 103.00 Part -Time CSO's 32,242 28,501 27,204 38,700 36,000 CSO's Up To 50 Hours/Wk 101 42110 01 202.00 Duplicating Copying 0 0 25 0 0 101 42110 01 203.00 Printed Forms Paper 718 1,630 747 800 800 Evidence Logs, Animal Lic, etc. 101 42110 01 204.00 Envelopes Letterheads 93 159 0 200 200 Business Cards 101 42110 01 207.00 Training Instructional Supplies 10,100 101 42110 01 207.01 Practice Ammunition 2,098 3,656 5,345 3,000 5,000 101 42110 01 207.02 Service Ammunition 0 515 79 400 0 101 42110 01 207.03 Other Supplies 64 0 229 100 100 101 42110 01 207.04 M.A.A.G. Ammunition 0 0 0 0 5,000 101 42110 01 208.00 Miscellaneous Supplies 0 Donated Forfeited Funds 101 42110 01 208.01 DARE Donations 2,406 2,659 2,657 0 0 101 42110 01 208.02 Equipment Donations/Forfeitures 8,313 7,781 7,842 0 0 101 42110 01 209.00 Other Office Supplies 850 1,035 591 1,000 1,000 Video, CD's Miscellaneous 101 42110 01 211.00 Cleaning Supplies 500 101 42110 01 211.01 Blanket Cleaning 0 0 0 0 0 101 42110 01 211.02 Squad Interior Cleaning 608 509 0 500 500 101 42110 01 217.00 Clothing Allowance 4,000 101 42110 01 217.01 CSO's 1,291 331 967 1,000 1,000 101 42110 01 217.02 Reserves 1,612 1,127 1,965 2,000 2,000 101 42110 01 217.03 Other Supplies 923 1,590 0 1,000 1,000 101 42110 01 219.00 Other Operating Supplies 1,905 30 13 2,800 101 42110 01 219.01 Evidence Bags, Drug Kits, Misc. 1,999 843 2,000 2,000 101 42110 01 219.02 Accurint Database Services 405 380 400 800 101 42110 01 221.00 Equipment Parts 2,786 3,919 1,775 2,500 2,500 Squad Emergency Equip Repairs 101 42110 01 241.00 Small Tools 2,000 Crime Scene Kit Supplies 101 42110 01 241.01 Evidence Processing Equipment 515 145 800 750 750 101 42110 01 241.02 Camera and Video Supplies 1,017 758 206 500 500 101 42110 01 241.03 Other Supplies 574 417 970 750 750 Digital Recorders 101 42110 01 242.00 Minor Equipment 861 2,000 101 42110 01 242.01 Less Lethal Tactical Equipment 538 760 943 1,500 1,500 Training Supplies, Taser Batteries 101 42110 01 242.02 MAAG Equipment 849 383 499 500 500 101 42110 01 304.00 Legal Fees 54,996 55,010 54,996 56,000 56,700 Prosecution 101 42110 01 305.00 Medical Dental Fees 6,000 101 42110 01 305.01 Employee Drug Testing 736 1,074 809 1,500 1,000 101 42110 01 305.02 Seized Narcotic Testing 224 340 663 500 5,000 Sup. Ct. Decision Blood Draws 101 42110 01 306.00 Personnel Testing Recruitment 4,254 825 875 1,000 1,000 Medical Psychological 101 42110 01 313.00 Temporary Service Fees 0 715 464 1,200 1,200 Interpreter Services 101 42110 01 315.00 Special Programs 0 11,994 0 0 0 101 42110 01 316.00 Animal Care Services 12,000 101 42110 01 316.01 Impound Care Fees 10,224 9,918 10,943 12,000 12,000 101 42110 01 316.02 "Future Use" 0 0 0 0 0 101 42110 01 319.00 Other Professional Services 297,000 101 42110 01 319.01 Dispatch Services Operations 90,240 232,230 232,800 304,200 297,000 101 42110 01 319.02 "Future Use" 4,611 19,608 24,586 0 0 101 42110 01 321.00 Telephone Costs 4,800 101 42110 01 321.01 Cell Phones 4,724 4,826 4,371 4,800 4,800 101 42110 01 321.02 Pagers 0 0 0 0 0 101 42110 01 321.03 LOGIS Communications Line 444 444 74 500 0 Not Applicable Fiber Now Used 101 42110 01 323.00 Radio Units 12,000 101 42110 01 323.01 Radios ($380 per Unit) 911 221 6,944 13,500 11,500 800 MHz Subscriber Fees 101 42110 01 323.02 Radars 61 220 430 500 500 Radar LIDAR Repairs 101 42110 01 331.00 Travel Expense 3,700 101 42110 01 331.01 MN Chiefs Spring Conference 116 302 0 500 500 101 42110 01 331.02 IACP Conference 0 1,639 1,865 1,500 1,500 101 42110 01 331.03 Outstate Investigations Conf. 315 120 693 500 500 101 42110 01 331.04 MAAG Conference 436 441 624 400 400 101 42110 01 331.05 CAN -AM Narcotic Conference 430 258 0 400 400 101 42110 01 331.06 Juvenile Officers Conference 243 610 325 300 300 101 42110 01 331.07 Meeting Reimbursements 74 160 190 100 100 PAGE TOTALS 2,212,108 2,477,720 2,662,125 2,878,700 2,898,200 Page Two 2010 BUDGET WORKSHEETS POLICE September 1, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 200 Repairs 12500 101 42110 01 333.00 Freight Express Expenses 202 138 141 200 101 42110 01 394.00 P.C. Software Purchases 101 42110 01 394.01 Automated Pawn System 432 432 240 500 500 101 42110 01 394.02 Pictometry 0 1,504 1588 2,000 1,500 101 42110 01 394.03 CJIIN System 10,474 10,474 10,474 10,500 10,500 101 42110 01 396.00 Computer Maintenance 101 42110 01 396.01 Records Management 41,623 31,069 34,377 32,500 32,500 101 42110 01 396.02 CJDN Connection Charges 3,443 2,520 2,981 2,800 2,800 101 42110 01 396.03 MCD Connection Charges 1,573 1,384 1,845 2,000 2,000 101 42110 01 396.04 MCD Maintenance Cellular 22,391 17,753 15,115 20,500 20,500 101 42110 01 396.05 LOGIS Annual Fees 7,844 6,942 7,275 7,800 7,800 101 42110 01 433.00 Dues Subscriptions 4,700 101 42110 01 433.01 Mutual Aid Assistance Group -MAAG 2,100 2,100 3,000 3,000 3,200 101 42110 01 433.02 IACP Chiefs 100 100 120 100 100 101 42110 01 433.03 MN Chiefs of Police 245 165 165 250 175 101 42110 01 433.04 Dakota Cty Chiefs of Police 50 35 35 50 50 101 42110 01 433.05 Wakota CAER 0 20 0 20 20 101 42110 01 433.06 Metro Emergency Managers 0 0 0 0 60 101 42110 01 433.07 MN Sex Crimes Investigators 18 18 0 20 20 101 42110 01 433.08 Tri- County Investigators 60 60 0 60 60 101 42110 01 433.09 MN Crime Prevention Association 40 55 90 55 55 101 42110 01 433.10 P.O.S.T. Licenses 1,080 810 360 800 800 101 42110 01 433.11 FBI Nat'l Academy Association 0 0 0 60 0 101 42110 01 433.12 Miscellaneous 40 55 165 85 160 101 42110 01 435.00 Books Pamphlets 998 1,118 943 500 1,000 Crime Prevention Materials 101 42110 01 436.00 Towing Charges 184 0 0 200 200 Disabled Squads 101 42110 01 437.00 Conferences Seminars 11,000 101 42110 01 437.01 Firearms Training 1,757 2,071 5,931 2,000 2,000 Range Rental 101 42110 01 437.02 Chiefs Spring Conference 575 425 0 500 500 101 42110 01 437.03 Investigations 1,183 2,020 1,920 1,500 1,500 101 42110 01 437.04 IACP Conference 0 275 275 250 250 101 42110 01 437.05 Supervision 407 665 755 750 750 101 42110 01 437.06 Use of Force 21 0 100 600 600 101 42110 01 437.07 Emergency Driving 1,365 2,100 1,120 1,400 1,400 101 42110 01 437.08 First Aid 0 700 0 1,250 1,250 101 42110 01 437.09 Narcotic Enforcement 200 307 0 500 500 101 42110 01 437.10 Tactical 480 690 0 750 750 101 42110 01 437.11 Support Services 65 40 245 250 250 101 42110 01 437.12 Patrol 1,820 1,050 618 1,250 1,250 101 42110 01 439.00 Other Miscellaneous Charges 643 510 282 500 500 Refreshments for Meetings Compliance Checks 101 42110 01 580.00 Other Equipment Purchases 1,181 0 0 0 0 PAGE TOTALS $102,594 $87,605 $89,961 $95,500 $95,700 DEPARTMENT TOTALS $2,314,702 $2,565,325 $2,752,086 $2,974,200 $2,993,900 65,600 CAD Included in DCC in 2007 FIRE DEPARTMENT MISSION VISION GOALS The Rosemount Fire Department's mission is an intricate component of the overall mission of the City of Rosemount in that the Fire Department is dedicated to the saving of life and property. This component which the Fire Department provides compliments and provides a necessary service so that the City may reach its broader mission of providing a safe, healthy and pleasant community in which to live and work. This service is provided by a paid -on -call department, which is the most fiscally sound method of delivery at this point in the City of Rosemount's development. The Rosemount Fire Department enhances the overall vision that is set for the City of Rosemount in that it provides the opportunity for individuals to demonstrate their pride in the community by serving on a "volunteer" fire department and assisting their neighbors. The "volunteer" Fire Department has historically been associated with the kind of small town character that Rosemount is striving to maintain. ADMINISTRATIVE MANAGEMENT Provides for the overall administration and management of the Fire Department. Included is the collection, preparation and dissemination of information; the preparation of operating budgets, Capital Improvement Projects (CIP) budgets and state reports; and planning for the long and short term needs with respect to training, fire protection, emergency medical response, facilities, staffing and the acquisition and maintenance of equipment, along with the coordination of efforts between other emergency response agencies and those of the City of Rosemount. FIRE SUPPRESSION INVESTIGATION Provides for the controlling and extinguishing of all types of fires in order to minimize injury, loss of life and loss of property within the City of Rosemount, both to its citizens and visitors. Provides for the controlling and extinguishing of all types of fires in order to minimize injury, loss of life and loss of property within the contracted areas of Coates and the University of Minnesota, along with the railroad right -of -ways. Provides for the provision of all of these fire services to all the cities of Dakota County and many of the cities of Washington County via a mutual aid agreement by which these services can be reciprocated on an as needed basis. FIRE DEPARTMENT Page 2 Provides for the investigation of fires by the local Fire Marshal. Also provides for the coordination of joint investigations by the local Fire Marshal and the State Fire Marshal. RESCUE SQUAD Provides for emergency operations pertaining to bodily injury or serious illness requiring emergency services within the City of Rosemount, both to its citizens and visitors. Provides for emergency operations pertaining to bodily injury or serious illness requiring emergency services within the contracted areas of Coates and the University of Minnesota. Provides for the provision of all of these emergency operations to all the cities of Dakota County and many of the cities of Washington County via a mutual aid agreement by which these services can be reciprocated on an as needed basis. HAZARDOUS MATERIAL RESPONSE CONFINED SPACE RESPONSE Provides a team of Operations Level, Technician Level and Specialists, trained to respond to hazardous material ac d to contain, mitigate andclean up the spill. fforts coordinate the of outside agencies that are tr� Trains all firefighters to respond to confined space incidents, evaluate the situation and mitigate or coordinate the rescue effort. TRAINING EDUCATION Provides for the necessary monthly and annual training requirements. Allows for training in areas above those that are required, in order that fire and rescue personnel may sharpen existing skills and acquire new skills. Allows for training of fire fighters to prepare themselves for the acceptance of a position of leadership within the Fire Department. FIRE DEPARTMENT Page 3 HEALTH TESTING Provides for the screening and medical certification of potential new fire fighters. Allows for the continuous health monitoring of existing personnel. Provides for the protection of personnel from blood -borne pathogens and communicable disease. EQUIPMENT MAINTENANCE Allows for the replacement or addition of equipment necessary for fire and medical response, including both consumable and nonconsumable items. Provides for the emergency contracting with outside providers for repairs of fire vehicles and specialized equipment. STAFFING In 2009, the Fire Department consisted of 40 paid on -call firefighters serving in various capacities within the department. This number is constantly changing due to retirements and new additions. We have 5 people who have reached or exceeded full retirement requirements, but often people retire prior to the full 20 years. We hope to end 2010 with a department of not less than 45 firefighters. PERFORMANCE MEASURES Total Number of Paged Calls 2004 2005 2006 2007 2008 Fire n/a n/a n/a n/a 229 Medical n/a n/a n/a n/a 540 Average Response Time: High Priority Calls 2004 2005 2006 2007 2008 n/a n/a n/a n/a n/a Total Number of Fire Fighters 2004 2005 2006 2007 22 Total 37 41 41 39 43 Added n/a n/a n a n/a 4 Net Change n/a n/a n/a n/ 2 n/a Information Not Available FIRE DEPARTMENT Page 4 Number of Attendances at Outside Training 2004 2005 2006 2007 2008 n/a n/a n n 10 Number of Customer Complaints 2004 2005 2006 2007 2008 n/a n/a n n 0 Page One September 1, 2009 Account 2010 BUDGET WORKSHEETS FIRE Description 101 42210 103.00 Salaries Benefits 101 42210 103.01 Salaries 101 42210 103.02 Training Pay /Stipends 101 42210 103.03 Call Pay /Stipends 101 42210 103.04 Class Pay /Stipends 101 42210 103.05 PIT Fire Marshal 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $100,280 $96,884 $75,329 $55,000 $55,000 Salary, Taxes, PERA Benefits 30,000 4,000 20,900 100 0 Position Eliminated in 2008 101 42210 01 202.00 Duplicating Copying 100 101 42210 01 202.01 Copy Toner 355 107 0 50 50 101 42210 01 202.02 Computer Printers 0 0 0 50 50 101 42210 01 204.00 Envelopes Letterhead 100 101 42210 01 204.01 Envelopes 0 0 0 25 25 101 42210 01 204.02 Letterhead 0 0 0 25 25 101 42210 01 204.03 Forms 134 0 0 50 50 101 42210 01 208.00 Miscellaneous Supplies 0 Supplies for Fire Marshal 101 42210 01 208.01 Supplies, Computer Support 699 851 1,040 0 0 101 42210 01 208.02 Film Developing 183 217 101 0 0 101 42210 01 208.03 Memberships 35 35 0 0 0 101 42210 01 208.04 Code Books 0 82 140 0 0 101 42210 01 208.05 Training 1,171 905 700 0 0 101 42210 01 211.00 Cleaning Supplies 800 101 42210 01 211.01 Soaps 53 1,217 140 550 550 101 42210 01 211.02 Chamois, Towels, etc. 33 116 0 50 50 101 42210 01 211.03 Sponges, etc. 0 39 0 50 50 101 42210 01 211.04 SCBA Cleaner 0 75 0 150 150 101 42210 01 218.00 Fire Department Clothing 67 45 0 400 400 5 Uniforms c $80 Each 101 42210 01 219.00 Other Operating Supplies 4,800 Medical Supplies 101 42210 01 219.01 Gloves 424 659 314 1,000 1,000 101 42210 01 219.02 Bandages 505 0 0 100 100 101 42210 01 219.03 Equipment 744 751 937 500 1,000 101 42210 01 219.04 Tyvek Suits 0 0 0 100 100 101 42210 01 219.05 Consummable Medical 1,826 2,105 891 2,200 2,200 101 42210 01 219.06 Oxygen 122 137 146 400 400 101 42210 01 229.00 Other Maintenance Supplies 700 101 42210 01 229.01 Aerial- Pumpers- Tanker 123 0 45 800 200 101 42210 01 229.02 Pickup Trucks 0 13 0 100 100 101 42210 01 229.03 Rescue Other 300 0 650 100 300 101 42210 01 229.04 Vehicle Modifications 3,148 0 72 100 100 101 42210 01 230.00 Equipment Repair Materials 2,100 101 42210 01 230.01 Light Bars 0 0 0 100 100 101 42210 01 230.02 Smoke Machines 0 0 0 250 250 101 42210 01 230.03 Lanterns Miscellaneous 0 478 61 250 250 101 42210 01 230.04 Small Tool Repairs 285 700 543 600 600 101 42210 01 230.05 Opticom 0 0 0 300 300 101 42210 01 230.06 Station 504 307 1,624 300 600 101 42210 01 241.00 Small Tools 700 101 42210 01 241.01 Axes, Bars Other 253 245 110 150 150 101 42210 01 241.02 Grass Fire 0 195 0 250 250 101 42210 01 241.03 Hand Tools 1,803 998 378 300 300 101 42210 01 305.00 Medical Dental Fees 2,734 2,805 2,850 3,500 3,500 Annual Medical Tests 101 42210 01 306.00 Personnel Testing Recruitment 2,300 101 42210 01 306.01 New Physicals (5) 1,540 1,955 2,925 1,325 1,325 101 42210 01 306.02 Hepatitis Shots (5) 293 651 151 625 625 101 42210 01 306.03 Background Checks (5) 261 29 121 125 125 101 42210 01 306.04 Drug Testing (5) 0 0 0 625 225 101 42210 01 308.00 Instructors' Fees 9,700 101 42210 01 308.01 Fire Fighter 1 (5) 0 974 1,198 1,500 1,500 101 42210 01 308.02 Fire Fighter 1 Certificates (5 5) 0 645 120 600 600 101 42210 01 308.03 Fire Fighter Re- Certificates (6) 90 0 195 90 200 101 42210 01 308.04 First Responder (5) 0 2,210 0 1,200 1,200 101 42210 01 308.05 First Responder Refresher (1/2) 1,820 715 1,200 1,400 1,400 101 42210 01 308.06 Outside Schools ($/2) 4,806 6,647 5,651 2,560 3,550 101 42210 01 308.07 Haz-Mat Training (5) 0 0 0 1,250 1,250 101 42210 01 308.08 Apparatus Re- Certificates 0 0 45 0 0 PAGE TOTALS 124,591 123,792 97,679 79,100 80,200 Page Two September 1, 2009 Account 2010 BUDGET WORKSHEETS FIRE 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Comments Actual Actual Actual Budget Amount Budget Description 3,700 101 42210 01 310.00 Testing Services 0 1,000 1,000 101 42210 01 310.01 Aerial 0 0 821 1 0 500 500 101 42210 01 310.02 Ladders 750 0 855 0 900 101 42210 01 310.03 Pumpers (3) (Next 2012) 0 0 0 0 1,300 101 42210 01 310.04 SCBA Hydro Testing (Next 2013) 7,800 777 101 42210 01 313.00 Temporary Service Fees 592 557 2,300 2,300 101 42210 01 313.01 SCBA Contract Repairs 1,270 7 2 5 92 269 600 2,000 101 42210 01 313.02 SCBA Flow Test 101 42210 01 313.05 Security Co 380 617 600 800 603 2 700 2,700 owet 1,598 2,301 2,724 161,200 101 42210 01 313.05 SOT Joint Powers 143,300 147,600 152,000 156,500 1,300 Fire Prevention Education 101 42210 01 314.00 Other Fire Relief Services 101 42210 01 319.0 Other Professional Services 0 0 0 200 200 101 42210 01 319.01 School Literature 38 0 212 200 200 101 42210 01 319.02 Door Prizes 1 764 525 538 500 500 101 42210 01 319.03 Fire Prevention Week Promos 247 511 402 200 200 101 42210 01 319.04 Food at Open House 248 44 66 100 100 101 42210 01 319.05 Summer Park Education 78 0 0 100 100 101 42210 01 319.06 National Night Out 1,400 101 42210 01 321.00 Telephone Costs 396 599 1,103 1,300 1,300 101 42210 01 321.01 Fire Dept. Cell Phones 250 0 0 101 42210 01 321.02 Fire Marshal Cell Phone 56 124 167 140 334 0 0 101 42210 01 321.03 "Future Use" 74 78 92 100 100 101 42210 01 321.04 Numeric Pagers 0 p 100 100 UPS Costs 101 42210 01 322.00 Postage Costs 10 16,800 50 101 42210 01 329.00 Other Communication Costs 0 0 1 pp 100 101 42210 01 329.01 Base Repairs 3 808 937 900 1,500 101 42210 01 329.02 Pager Repairs 1 79 330 0 100 100 101 42210 01 329.03 Hand Held Repairs 211 125 0 100 100 101 42210 01 329.04 Mobile Repairs 0 0 7 604 18,000 15,000 3,900 2,202 1,632 101 42210 01 329.05 800 MHZ User Fee 101 42210 01 331.00 Travel Expense 1,484 2,000 2,000 101 42210 01 331.01 Minnesota Chiefs Conference 979 1,736 2484 1,600 2 ,000 101 42210 01 331.02 Fire Department Association 893 489 0 1,300 300 101 42210 01 331.03 Outside Schools 0 10 0 0 101 42210 01 333.00 Freight &Express Expense 22 1,300 101 42210 01 433.00 Dues Subscriptions 50 50 50 50 50 101 42210 01 433.01 Capital City 544 324 354 550 550 300 101 42210 01 433.02 VFBA Insurance 12 360 300 300 Chiefs 42210 01 433.03 State Fire 200 165 290 250 250 101 42210 01 433.04 State Chiefs 0 100 75 60 60 101 42210 01 433.05 DCFC 50 0 55 50 50 101 42210 01 433.06 WAKOTA Mutual Aid 35 35 50 50 50 101 42210 01 433.07 Purchasing Consortium 0 0 150 0 0 101 42210 01 433.08 NFPA 0 p p 0 0 101 42210 01 433.09 "Future Use" 900 510 0 0 101 42210 01 437.00 Conferences Seminars 400 400 101 42210 01 437.01 State Fire Conference 840 450 0 500 4 00 101 42210 01 437.02 State Chief's Conference 1,600 101 42210 01 439.00 Other Miscellaneous Charges 376 50 59 150 150 101 42210 01 439.01 Food Coffee 73 860 0 300 300 101 42210 01 439.02 Extinguisher 0 0 60 40 40 101 42210 01 439.03 Plaques 0 0 0 70 70 101 42210 01 439.04 Paint 2,496 1,010 1,070 1,070 2 670 2 101 42210 01 439.05 Station Needs 21, 600 101 42210 01 580.00 Other Equipment Purchases 4,409 11,627 16,282 9,000 15,000 Re lacements 101 42210 01 580.01 Bunker Gear (7) 1,541 3,204 0 3,000 3,600 p 101 42210 01 580.02 2 Pagers rs (6) 4,694 0 1,000 1,000 1 24 4, 101 42210 01 580.03 Hose Replacement 1 1 91 2,336 2,000 2,000 0 101 42210 01 580.04 Replace Damaged Items 1 2 4 6 0 0 0 101 42210 01 581.00 Other Equipment Purchases 7,356 0 7,069 0 0 0 101 42210 01 586.00 Computer Equipment Purchase 0 $221,600 PAGE TOTALS $186,473 $193,116 $200,398 $209,900 DEPARTMENT TOTALS $311,063 $316,909 $298,077 $289,000 $301,800 Separate Enterprise Fund Budgets from those included here under the advisement of the Utility Commission of the City of Rosemount. The Public Works Department currently has a combined permanent work force of 26 positions for the areas of engineering, buildings, fleet maintenance, streets, parks and the enterprise- funded utilities. Also, the City employs up to 14 seasonal part -time people to help during periods that require higher levels of maintenance. The Public Works budget also incorporates the contract for consulting services currently held to fill the position of the Director of Public Works City Engineer. The Public Works Department consists of the Engineering and Operations Divisions. The maintenance personnel maintain the streets, storm drainage, sanitary sewer and potable water systems, along with all government buildings, parks and all City grounds. The Department manages its expenditures and revenues through the following four (4) maintenance funds and three (3) enterprise funds: PUBLIC WORKS The Public Works Department has a mission to enhance the quality of life through responsive, efficient, and cost effective delivery of services consistent with community values. With sound management, fiscal responsibility and professional care, the Department will preserve and protect the infrastructure resources of the City, creating a safe, clean and enjoyable environment for residents and businesses. 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 Public Works building and garage, and two Fire Stations. It also includes three (3) park shelters, the old St. Joseph's Church, the Dakota County Library (plowing only), and the Family Resource Center. Maintenance and operation of the Community Center Ice Arena is not included in this budget. FLEET MAINTENANCE This budget provides for the maintenance of all City -owned vehicles and over 250 pieces of large and small equipment. It provides funding for all fuels, oils, parts, tires, shop supplies, and contracted vehicle maintenance. The City -owned vehicles include: Police Department (11 cars, 3 trucks) Fire Department (6 pickup trucks, 7 fire /rescue trucks) Parks and Recreation (2 trucks, 1 van, 1 car, 1 ice resurfacer) Administration Community Development (2 cars, 2 trucks, 1 van) Utility Department (1 Jetter, 1 Vactor, 2 trucks) Streets and Parks Maintenance (2 sweepers, 3 tractors, 2 loaders, 2 skidsters, 7 dump trucks, 6 mowers, 13 trucks, 2 compactors, 1 roller, 1 ATV, 4 snow blowers) 5 large trailers STREET MAINTENANCE This budget provides for the maintenance and preservation of over 102 miles of City roads, 92 miles of sidewalks and bike trails, and 18 City parking lots. Standard maintenance includes grading, graveling, patching, sealing and overlays. This budget also provides for pavement markings, street signs, street lighting, signal light maintenance and power, snow and ice control, and street sweeping. PARKS MAINTENANCE This budget provides for the maintenance of over 360 acres of City park areas in 24 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, two Fire Stations and the Community Center. It also includes the installation and maintenance of playground equipment, landscaping projects, ice rink construction and maintenance (4 hockey rinks, 6 pleasure rinks), and other miscellaneous construction activities. PUBLIC WORKS Page 3 PERFORMANCE MEASURES Value of Projects Ordered (Contract Amount) 2004 2005 2006 2007 2008 2009 (Est.) n/a n/a $8,422,192 $3,160,046 $4,057,030 $1,870,660 Change from Prior Year (Above) 2004 2005 2006 2007 2008 2Q02 n/a n/a n/a -62.5% 28.4% -53.9% Average Number of Hours for Full Snow Clearing Event 2004 2005 2006 2007 2008 2009 n/a n/a n/a n a n a n/a of Mechanics' Time Spent on Repair Maintenance 2004 2005 20 6 2007 2008 2009 n a n a 81% 93% 93% 93% Park Acres Maintained 2004 2005 2006 2007 2008 2009 n/a n/a 130 135 127 133 n/a Information Not Available 2006 tracking was done on paper, less accurate than CarteGraph tracking (started in 2007). Page One September 1, 2009 Account 101 41940 01 302.00 101 41940 01 318.00 101 41940 01 319.00 101 41940 01 319.01 101 41940 01 319.02 101 41940 01 319.03 101 41940 01 319.04 101 41940 01 319.05 101 41940 01 319.06 101 41940 01 319.07 101 41940 01 319.08 101 41940 01 319.09 101 41940 01 319.10 101 41940 01 319.11 101 41940 01 381.00 101 41940 01 382.00 101 41940 01 383.00 101 41940 01 384.00 101 41940 01 384.01 101 41940 01 384.02 101 41940 01 389.00 2010 BUDGET WORKSHEETS GOVERNMENT BUILDINGS 101 41940 101.00 Salaries Benefits 101 41940 79 101.01 Maintenance Staff 101 41940 102.00 Full -Time Overtime 101 41940 01 208.00 Miscellaneous Supplies 101 41940 01 223.00 Building Repair Supplies 101 41940 01 225.00 Landscaping Materials 101 41940 01 241.00 Small Tools 101 41940 01 242.00 Minor Equipment 101 41940 01 601.00 Bond Principal 101 41940 01 611.00 Bond Interest 101 41940 01 621.00 Bond Paying Agent Fees 2006 2007 2008 Description Actual Actual Actual Architects' Fees Contract Engineer Other Professional Services Elevator Maintenance Heating /Cooling Maint Contract Annual Boiler Inspections Maint. Pest Control Fire Extinguishers Fire Suppression System Check Janitorial Service-Fire Stations Janitorial Service-P.W. Building Janitorial Service -City Hall Floor Mats Monthly Charges Other Janitorial Services Electric Utilities Water Utilities Gas Utilities Refuse Disposal General Buildings Parks Recycling /Cleanup Other Utility Services 101 41940 01 401.00 Contracted Building Repairs 101 41940 01 401.01 Electrical Repairs 101 41940 01 401.02 Siren Replacement Program 101 41940 01 401.03 Miscellaneous Repairs 101 41940 01 401.04 Roof Inspection 101 41940 01 415.00 Other Equipment Rental 101 41940 01 439.00 Other Miscellaneous Charges 101 41940 01 530.00 Improvements Other Than Buildings PAGE TOTALS DEPARTMENT TOTALS 48,114 49,402 10,521 0 3,137 2,689 0 0 13,558 20,513 16,717 20,000 7,053 5,924 9,231 9,000 81 169 466 500 0 355 9 200 719 2,804 2,066 2,000 O 3,000 0 0 2,250 750 1,500 3,000 1,277 2,702 1,498 1,500 2,469 1,107 7,048 8,000 30 659 476 1,500 1,598 2,036 2,146 2,000 1,209 1,805 2,308 2,000 2,613 2,825 3,044 4,000 3,515 10,633 10,452 10,500 10,288 13,266 10,555 11,500 O 0 25,826 25,000 O 0 0 3,800 O 0 0 0 72,810 62,795 64,821 75,000 O 40 0 0 51,360 63,317 80,087 80,000 11,505 13,399 14,169 20,000 16,000 11,157 12,381 12,858 15,000 14,000. 3,694 3,810 3,528 0 800 167 3,339 4,070 6,112 5,000 673 10,018 10,000 10,000 53,025 40,332 22,493 25,000 O 0 0 500 O 307 0 1,000 O 0 0 1,000 O 10,000 142,196 85,000 41,158 43,579 46,000 48,500 41,043 37,205 33,186 30,000 775 0 0 1,500 $389,249 $422,060 $539,315 $502,000 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget 0 1,500 7,000 1,500 2,500 3,000 3,500 10,500 11,500 25,000 3,800 7,000 5,000 10,000 25,000 0 $490,200 $389,249 $422,060 $539,315 $502,000 $490,200 Comments All Salary Costs Inclusive of $0 Salary, Taxes, PERA Benefits Increase to "319.09" Below 0 17,000 Cleaning Supplies, Towels, etc. 9,200 2,500 Trees Shrubs 200 Hand Tools, Bits, Blades, etc. 2,000 Equipment Replacement O Estimates 1,500 Contracted Engineer for City (5 76,800 Includes all City Facilities Waxing Floors, Carpet Cleaning 75,000 0 80,000 30,000 2 Cleanup Days per Year O Moved to "319.10" Above 40,000 1,000 Scaffolding, Cleaners 5,000 Energy Efficiency Improvements 70,000 50,900 MSABC Payment (2/1) 29,100 MSABC Payments (2/1 8/1) 0 Page One September 1, 2009 Account 101 43100 101.00 101 43100 77 101.00 101 43100 79 101.00 101 43100 102.00 101 43100 01 211.00 101 43100 01 212.00 101 43100 01 213.00 101 43100 01 215.00 101 43100 01 221.00 101 43100 01 222.00 101 43100 01 241.00 101 43100 01 242.00 101 43100 01 318.00 101 43100 01 321.00 101 43100 01 323.00 101 43100 01 384.00 101 43100 01 394.00 101 43100 01 404.00 101 43100 01 416.00 101 43100 01 417.00 101 43100 01 433.00 101 43100 01 435.00 101 43100 01 437.00 2010 BUDGET WORKSHEETS FLEET MAINTENANCE Description Salaries Benefits Administrative Maintenance Full -Time Overtime Cleaning Supplies Motor Fuels Lubricants Additives Shop Materials Equipment Parts Tires Small Tools Minor Equipment Contract Engineer Telephone Costs Radio Units Refuse Disposal P.C. Software Purchases Contracted Mach Equip Repairs Machinery Rental Uniforms Rental Dues Subscriptions Books Pamphlets Conferences Seminars PAGE TOTALS DEPARTMENT TOTALS Estimated Fuel Cost for 2010 Unleaded $2.80 /gallon x 40,000 gallons $112,000 Diesel $3.00 /gallon x 27,000 gallons 81,000 unleaded tax 10,000 diesel tax 2,300 Total for motor fuels $205,300 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget All Salary Costs Inclusive of $152,900 Salary, Taxes, PERA Benefits 10,123 10,506 10,954 11,300 11,500 128,087 131,936 138,537 143,400 141,400 424 1,185 1,786 7,500 5,000 1,377 1,082 1,022 1,000 1,000 Shop Vehicles 135,325 167,365 173,858 230,000 210,000 Price Estimate (See Below) 5,035 9,188 8,712 5,500 10,000 Price Increase, Fleet Expansion 17,092 14,649 18,535 17,000 17,000 78,242 90,275 115,712 95,000 120,000 Fleet Expansion 6,841 9,976 15,718 12,000 40,000 Large Equipment Replacements 5,102 3,898 4,444 4,000 4,000 1,973 2,633 6,246 6,000 4,000 4,500 1,500 3,000 4,500 3,000 Contracted Engineer for City(10 0 0 0 0 0 2,257 850 284 2,000 2,000 Repair /Replace Units 30 154 158 500 300 Shop Hazardous Waste 32 0 0 500 500 General Software Support 43,038 20,524 25,340 35,000 35,000 0 0 0 1,000 1,000 145 139 226 0 0 0 0 75 100 100 DOT Certification 376 51 51 0 0 999 364 0 500 800 $600- CarteGraph; $200 -Misc. $440,997 $466,276 $524,657 $576,800 $606,600 $440,997 $466,276 $524,657 $576,800 $606,600 Comments Page One September 1, 2009 Account 2010 BUDGET WORKSHEETS STREET MAINTENANCE 2006 Description Actual 101 43121 101.00 Salaries 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 R/W 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.00 Chemical Chemical Products 101 43121 01 224.00 Street Maintenance Materials 101 43121 01 224.01 Paint 101 43121 01 224.02 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 225.05 Hanging Baskets 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 Rock 101 43121 01 235.00 Shouldering Gravel 101 43121 01 241.00 Small Tools 101 43121 01 242.00 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 323.00 Radio Units 101 43121 01 324.00 Messenger Services 101 43121 01 331.00 Travel Expense 101 43121 01 341.00 Employment Advertising 101 43121 01 381.00 Electric Utilities 101 43121 01 381.01 Street Lights 101 43121 01 381.02 Signal Lights Sirens 101 43121 01 384.00 Refuse Disposal 101 43121 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 Sup 101 43121 01 391.04 R-O -W Permit On -Line Service 101 43121 01 392.00 P.C. Accessories Supplies 101 43121 01 394.00 P.C. Software Purchases PAGE TOTALS 30,368 53,684 342,342 5,164 15,146 0 0 27 0 312 134 468 19 577 312 73 0 13,133 29,963 23,805 27,600 2,649 0 1,499 3,223 76,428 493 242 0 2,723 9,000 658 3,501 0 0 399 0 0 917 0 0 0 0 0 0 314 2009 2007 2008 Adopted Actual Actual Budget 31,519 57,671 360,684 10,601 19,167 151 0 0 0 534 547 856 900 2,000 367 95 88 450 450 0 0 0 200 0 0 0 0 550 550 Inspection Equipment 205 144 492 500 500 Road Salt, Price Increase -See P.2 37,122 65,339 79,449 80,000 2,500 543 662 684 37 0 195 0 0 9,146 36,565 30,077 29,368 2,476 2,465 1,603 2,835 37,886 1,063 0 0 681 3,000 1,727 2,442 0 0 512 0 138,852 142,407 149,837 150,000 165,000 4,203 5,613 4,940 10,000 6,000 0 894 173 0 0 1,729 0 0 1,843 32,861 60,134 376,362 11,817 25,630 0 0 0 0 105 465 613 1,917 298 820 490 0 14,507 28,566 23,550 21,101 0 1,107 1,248 902 22,578 440 0 0 0 6,000 0 2,484 0 29 35 0 121 326 0 0 0 21,888 4,360 0 901 33,900 62,900 388,100 16,000 25,000 100 200 100 0 500 500 1,500 1,500 200 1,000 500 7,000 15,000 40,000 30,000 35,000 1,200 3,000 2,000 4,000 8,500 2,000 600 1,200 0 9,000 500 3,000 0 100 500 0 2010 Object 2010 Detail Proposed Comments Amount Budget All Salary Costs Inclusive of $487,900 Salary, Taxes, PERA Benefits 1,000 1,200 600 0 1,000 10,000 4,800 0 5,000 34,300 63,800 389,800 200 100 0 500 500 1500 1,500 200 1,000 500 5,000 500 900 600 0 0 10,000 4,800 14,000 Maintenance 25,000 826,457 862,542 897,318 960,800 978,000 100 300 3,000 8,200 8,500 1,000 600 1,200 0 6,000 500 3,000 1,300 100 500 0 171,000 2,000 14,800 Work Orders Through CarteGraph Plotter (Ink and Paper) Replace with LED Bulbs 15,000 40,000 30,000 35,000 2,000 Gravel Road Ice Control-See P.2 3,000 2,000 Shovels, Brooms, etc. 4,000 Safety Equipment Power Tools General Non Project Related Appeals of Closed Projects Employment Physicals Contracted Engineer for City(20 Random Drug Testing to Admin Includes Wireless Technology 800 MHZ Monthly Charges Price Increases, More Lights 0 5,000 CarteGraph Maintenance Page Two 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget ,500 0 16,871 10,000 11 101 43121 01 402.00 Parking Lot Seal Coating 0 11,500 101 43121 01 403.00 Contracted Repair Maintenance Repair 9 Street Lights (Annually) 101 43121 01 403.01 Street Lights 25,946 26,390 31,440 28,500 28,500 1,891 0 792 500 500 101 43121 01 403.02 Signal Lights 1,80 0 0 5,000 0 101 43121 01 403.03 Light Replacements 0 0 0 0 15,000 Quiet Zones Railroad Maint Costs 101 43121 01 404.00 Contracted Mach Equip Repairs 30,000 P Increase, Added Bonaire 4,557 2,175 0 101 43121 01 405.00 Street Striping 17,958 20,808 25,523 25,000 0 101 43121 01 408 Street Sweeping 31,434 33,091 42,960 45,000 45,000 101 43121 01 408.00 Street Crack Sealing 10,000 101 43121 01 409.00 Tree Trimming 3,633 4,649 8,362 10,000 133,000 101 43121 01 410.00 Concrete Sidewalk/Curb Repairs 101 43121 01 410.01 General Repairs 3,706 7,843 9,436 8,000 8,000 101 43121 01 410.02 Pedestrian Improvements 126,465 125,268 123,457 125,000 125,000 31,500 101 43121 01 411.00 Contracted Snow Removal 101 43121 01 411.01 Community Center 4,008 13,060 9,512 15,000 12,000 101 43121 01 411.02 St. Joseph's 4,820 9,241 8,814 8,000 9,500 101 43121 01 411.03 Genz -Ryan 0 2,888 5,778 4,000 0 101 43121 01 411.04 Dakota County Library 0 0 0 8,000 10,000 35,000 Bucket Truck OSHA 101 43121 01 415.00 Equipment Rental 15,364 23,863 13,251 35,000 0 0 0 0 101 43121 01 416.00 Snow Plow Loader Rental 0 700 101 43121 01 433.00 Dues Subscriptions 101 43121 01 433.01 American Public Works Ass'n 750 484 633 500 600 101 43121 01433.02 "Future Use" 0 28 0 0 0 101 43121 01 433.03 City Engineers' Association 0 0 0 0 0 101 43121 01 433.04 Professional Secretaries 0 0 0 0 0 101 43121 01 433.05 MN Society for Professional Eng. 0 0 0 0 0 101 43121 01 433.06 American Society of Civil Eng. 0 0 70 100 100 101 43121 01433.07 MN Street Superintendent Assn 0 0 0 500 0 101 43121 01433.08 "Future Use" 0 101 43121 01 435.00 Books Pamphlets 0 0 0 200 0 101 43121 01435.01 "Future Use" 0 0 0 600 0 101 43121 01 435.02 "Future Use" 5,000 101 43121 01437.00 Conferences Seminars 101 43121 01 437.01 APWA 233 549 215 1,200 500 101 43121 01 437.02 Computer Training 384 0 99 500 500 49 0 0 200 200 101 43121 01 437.03 Clerical 2 2 49 0 0 150 200 101 43121 01 437.04 Gravel Road Maintenance 0 0 20 300 350 101 43121 01 437.05 Maintenance Expo 0 0 0 300 350 101 43121 01 437.06 CarteGraph User Conference 0 0 90 650 600 101 43121 01 437.07 Snow Conference 440 0 0 0 3,648 4 640 1,4 101 43121 01 437.08 MN Dot 50 2,000 2,000 101 43121 01 437.09 Miscellaneous Training 590 0 0 3,5 2,000 1,000 Host CONDAC $500 101 43121 01 439.00 Other Miscellaneous Charges 101 43121 01 570:00 Office Equipment Furnishings 1,362 0 0 0 0 PAGE TOTALS $247,148 $272,528 $301,095 $336,200 $346,700 DEPARTMENT TOTALS $1,073,605 $1,135,070 $1,198,413 $1,297,000 $1,324,700 Estimated Road Salt Cost for 2010 Salt $58.75/ton x 500 tons $29,375 Treated Salt $74.00/ton x 750 tons 55,500 $84,875 September 1, 2009 2010 BUDGET WORKSHEETS STREET MAINTENANCE Total for Road Salt Estimated De -Icing Gravel Cost for 3 15.50fton x 70 tons Gravel Treated Gravel $28.50/ton x 20 tons Total for Road Salt $1,085 570 $1,655 Comments Page One September 1, 2009 Account Description 101 45202 101.00 101 45202 77 101.00 101 45202 79 101.00 101 45202 102.00 101 45202 99 103.00 101 45202 01 205.00 101 45202 01 216.00 101 45202 01 216.01 101 45202 01 216.02 101 45202 01 219.00 101 45202 01 219.01 101 45202 01 219.02 101 45202 01 219.03 101 45202 01 219.04 101 45202 01 219.05 101 45202 01 221.00 101 45202 01 221.01 101 45202 01 221.02 101 45202 01 221.03 101 45202 01 221.04 101 45202 01 223.00 101 45202 01 223.01 101 45202 01 223.02 101 45202 01 223.03 101 45202 01 223.04 101 45202 01 225.00 101 45202 01 225.01 101 45202 01 225.02 101 45202 01 226.00 101 45202 01 229.00 101 45202 01 241.00 101 45202 01 242.00 101 45202 01 303.00 101 45202 01 305.00 101 45202 01 318.00 101 45202 01 321.00 101 45202 01 323.00 101 45202 01 341.00 101 45202 01 381.00 101 45202 01 381.01 101 45202 01 381.02 101 45202 01 381.03 101 45202 01 383.00 101 45202 01 394.00 101 45202 01 403.00 101 45202 01 403.01 101 45202 01 403.02 101 45202 01 403.03 101 45202 01 409.00 101 45202 01 409.01 101 45202 01 409.02 101 45202 01 416.00 101 45202 01 416.01 101 45202 01 416.02 101 45202 01 433.00 101 45202 01 433.01 101 45202 01 433.02 101 45202 01 435.00 101 45202 01 437.00 101 45202 01 437.01 101 45202 01 437.02 101 45202 01 439.00 2010 BUDGET WORKSHEETS PARKS GROUNDS MAINTENANCE Salaries Benefits Administrative Maintenance Full-Time Overtime Part-Time Salaries Benefits Drafting Supplies Chemical Chemical Products Herbicides(General Park Use) Fertilizer Other Operating Supplies Seed, Sod, etc. Red Rock, Sand, Gravel, etc. Repair Supplies Bituminous Wood Chips Equipment Parts Playground Equipment Repair Irrigation Repair(Non- Contract) Miscellaneous Park Sign Replacements Building Repair Supplies Paint, Stain, etc. Shingles, Boards, etc. Miscellaneous Shelter /Shed Repairs Landscaping Materials Trees, Shrubs, Sod, etc. Timbers, Fence, etc. Sign Repair Materials Other Maintenance Supplies Small Tools Minor Equipment Engineering Fees Medical and Dental Fees Contract Engineer Telephone Costs Radio Units Employment Advertising Electric Utilities Skating Rinks Softball Fields Irrigation Gas Utilities P.C. Software Purchases Contracted Repair Maintenance Irrigation Repairs Electrical Repairs Miscellaneous Repairs Other Contracted Repair Maint Chemlawn Services Library St. Joe's RCC Machinery Rental Mower Leases Miscellaneous Rentals Dues Subscriptions MN Park Supervisors Ass'n Miscellaneous Dues Books Pamphlets Conferences Seminars Seminars Workshops School Tuition Other Miscellaneous Charges 101 45202 01 530.00 Improvements Other Than Bldgs PAGE TOTALS DEPARTMENT TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $521,414 $535,318 $721,147 $683,900 $718,500 $521,414 $535,318 $721,147 $683,900 $718,500 Comments All Salary Costs Inclusive of $412,600 Salary, Taxes, PERA Benefits 10,123 10,506 10,954 11,300 11,500 346,649 366,723 381,555 393,600 401,100 7,018 11,384 14,556 14,000 14,000 19,544 15,478 35,190 35,000 49,500 Additional New 6 -Month Position O 0 0 100 100 34,000 Includes all City Facilities 9,230 6,081 8,651 12,000 12,000 16,426 18,304 21,579 22,000 22,000 16,500 2,492 3,426 2,952 3,000 3,000 5,964 3,472 1,085 7,000 3,500 16 334 512 3,000 1,000 O 0 0 0 0 O 0 6,760 6,000 9,000 Special Wood Chips Playgrounds 14,500 2,855 7,791 4,509 4,500 4,500 3,357 5,735 7,450 7,500 7,500 883 3,289 108 2,500 2,500 5,473 0 648 2,500 0 10,000 2,152 981 1,696 1,500 1,500 1,705 1,012 1,915 2,000 2,000 1,502 1,503 1,706 1,500 1,500 4,809 5,219 29,580 5,000 5,000 7,000 6,082 4,536 2,218 3,500 3,500 456 629 684 3,500 3,500 O 492 0 500 500 6,196 3,731 5,288 6,000 7,000 Paint, Chalk, Field Dry DCTC) 2,584 2,377 1,539 2,500 2,500 Hand Tools, Blades, Bits, etc. 2,089 1,053 2,627 2,500 2,500 Weed Whips, Chain Saws Powered O 0 0 0 0 O 0 0 600 600 Employment Physicals 2,250 750 1,500 3,000 1,500 Contracted Engineer for City (5 2,928 2,988 2,905 3,100 3,100 Includes Wireless Technology O 0 0 500 1,300 800 MHZ Monthly Charges O 0 11 0 0 20,000 5,104 5,831 6,697 6,000 6,000 8,740 5,937 7,030 10,000 9,000 2,929 3,190 3,402 5,000 5,000 2,292 2,574 2,509 3,300 2,800 O 0 0 5,000 6,000 CarteGraph Maintenance 14,000 O 913 2,985 5,000 5,000 System Blow -Out 4,308 7,362 3,951 6,000 6,000 2,080 6,013 36 3,000 3,000 16,459 4,222 3,806 8,000 10,000 0 0 0 0 4,000 O 0 0 0 6,000 20,500 14,100 18,395 14,584 19,000 19,000 Exmark, 2 John Deere 1,758 1,851 1,425 1,500 1,500 200 O 0 0 50 50 70 35 70 150 150 O 0 0 100 100 2,500 346 726 616 1,500 1,500 Green Expo, MPSA, Playgrounds 445 475 1,285 400 1,000 Turf School, Power Limited Tech. O 0 0 200 200 Contingencies 124,572 50,000 65,000 Annual Total Expenditures PARKS AND RECREATION The Parks and Recreation Department works together with citizens to provide a safe, healthy and pleasant community. Parks and recreation are essential services that can impact health, crime prevention, the environment, the economy and the quality of life for Rosemount residents. ADMINISTRATION Provides for overall planning, coordination, management of personnel and administration of activities within the department of Parks and Recreation. This department provides a diversified range of activities and facilities for the residents of Rosemount. The long range planning, budget preparation and development of parks and coordination with other service agencies are ongoing activities. Administrative services also provide the residents of Rosemount an opportunity to reserve facilities and register for programs. RECREATION Provides the Rosemount resident a variety of recreational activities serving all ages. Program offerings are based on the needs of residents as determined and evaluated by the Parks and Recreation Commission and staff. Coordination with other service agencies encourages a comprehensive, quality and efficient base of programs. COMMUNITY CENTER Provides for operation of a multi- purpose Community Center, which offers facilities for recreational programs, banquets, meetings, events, theatrical productions, seminars and exercise. The Community Center provides services in the form of meeting space, gym space for community groups and sponsorship of community events. The Parks and Recreation Department provides ongoing, preventive maintenance and janitorial services of the Community Center and portions of the National Guard facilities. PARKS RECREATION DEPARTMENT Page 2 PERFORMANCE MEASURES Hours of Use at Community Center 2004 205 2006 2007 2008 n/a n/a 20,060 19,149 22,761 Total Community Center Rental Income and Change from Prior Fiscal Year 2004 2005 2006 2007 2008 n/a n/a $109,944 $118,094 $122,315 n/a n/a n/a +7% +3.5% Income Change Number of Acres in the Park System and Change from Prior Fiscal Year 2004 2005 2006 2007 2008 n/a n/a 430.84 430.84 430.52 n/a n/a +15.35% 0% -0.07% 57.62 acres added (FHR for future athletic complex) 0.33 acres lost at Schwarz Pond Park 0.01 acres added at Erickson Park 0.02 acres added at Carroll's Woods Income Change 2006 Park System Acres: 2008 Park System Acres: 2009 Park System Acres: Total Number of Recreation Program Participants 2004 2005 n/a n/a n/a Information Not Available 2006 2007 14,000 14,000 Percentage of Costs Received for All Recreation Programs 2004 Revenues n/a Expenses n/a Net n/a Change n/a 2005 n/a n/a n/a n/a 2008 14,000 2006 2007 2008 $136,866 $154,229 $151,378 $122,826 $133,556 $128,292 $14,040 $20,673 $23,086 +10.26% +13.40% +15.25% Page One September 1, 2009 Account 2010 BUDGET WORKSHEETS PARKS RECREATION Description 101 45100 101.00 Salaries Benefits $608,445 10,899 64 2 8 $66g 811 $655,000 101 45100 102.00 Full -Time Overtime 101 45100 103.00 Part-Time Salaries Benefits 28 168 20,723 30,760 44,800 101 45100 10 103.00 PIT Receptionists 101 45100 12 103.00 Building Attendants 52,065 47,070 56,912 49,000 101 45100 83 103.00 Playground Recreation Leaders 19,160 22,902 24,155 23,000 101 45100 94 103.00 Warming House Attendants 10,811 10,511 16,453 15,000 101 45100 99 103.00 Park &Rec Committee 1,877 1,595 1,560 2,500 101 45100 71 103.00 P/T Horticulturist 2,976 4,985 3,449 6,500 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 208.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 Utilkies 101 45100 01 383.00 Gas Utilities 101 45100 01 384.00 Refuse Disposal 101 45100 01 392.00 P.C. Accessories Supplies 101 45100 01 393.00 P.C. Hardware Purchases 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 433.03 On -Line Registrat'n Subscription 101 45100 01 435.00 Books Pamphlets 101 45100 01 437.00 Conferences Seminars 101 45100 01437.01 MRPA State Conference 101 45100 01 437.02 MIAMA State Conference 101 45100 01 437.03 Workshops, Schools, Tuition 101 45100 01439.00 Other Miscellaneous Charges 101 45100 01 530.00 Improvements Other Than Bldgs PAGE TOTALS 2006 2007 2008 Actual Actual Actual O 46 43 0 0 782 706 237 1,000 800 Film, Developing Laminating O 0 0 200 100 Books, Tapes, etc. 74 100 69 500 200 Meeting Supplies 1,102 282 70 1,600 1,200 Envelopes, Forms, Rulers, etc. 5,669 5,171 4,406 6,000 6,000 2,009 1,408 789 2,000 1,500 6,779 5,709 5,604 7,000 6,000 Rec Programs, 1st Aid Sup, etc. 9,483 8,932 7,854 9,500 8,500 4,213 3,555 3,654 5,500 4,5000 148 0 44 0 O 0 0 0 0 230 50 0 800 0 Employment Physicals 5,700 9,074 8,307 9,000 9,000 Custodial Services Banquet Rm 15,300 2,150 3,139 3,002 6,000 6,000 Performances (Add Movies) 800 200 212 600 400 Trophies Awards 130 16 129 0 0 270 53 54 400 300 Ribbons Mailings 2,057 2,619 3,257 3,900 3,900 Trees 299 0 230 500 300 Tapes, Fuses, Puppets, etc. 971 197 1,751 1,000 1,000 Publicity Supplies 345 1,357 932 1,000 1,000 Flyers, Signs 756 2,009 557 2,000 2,000 Start Up Costs O 0 0 800 400 2,437 393 2,723 2,500 2 500 ADA Servic s/Eng.LLA Sery Test 2,234 2,351 2,973 3,100 3,100 6 O 675 696 2,800 100 Pagers Cellular Phones 147 196 380 500 700 General Employment Ads 43,300 26,047 36,019 36,688 35,000 36,000 City Newsletter (4 Per Year) 4,363 5,080 4,893 3,400 3,400 Rec Ads 2,284 2,250 4,799 3,900 3,900 Garage Sale Ad 25,383 27,291 27,864 27,000 30,000 31,488 34,232 37,862 50,000 42,000 3,190 3,720 4,363 4,000 4,000 3,431 0 0 0 0 1,409 0 1,764 0 2,000 O 0 13,000 13,000 5,000 On-Line Registration S/VV Support 9,049 12,066 6,408 11,000 10,000 6,799 8,793 1,571 8,000 8,000 19,268 22,736 19,594 30,000 23,000 Air Handler Maintenance Contract 16,800 16,800 16,800 16,800 16,800 Monthly Rent Payments to Guard 13,213 12,367 13,054 18,000 1 00 Portable Toilets Other Rentals 1,259 1,259 1,259 2,100 941 867 583 400 O 0 1,332 1,200 O 0 0 100 1,260 1,677 2,494 2,000 O 0 190 300 997 469 972 2,200 7,595 19,991 7,586 0 0 0 0 45,000 $957,960 $1,019,058 $1,058,589 $1,148,400 General Operating DEPARTMENT TOTALS $957,960 $1,019,058 $1,058,589 $1,148,400 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget 34,000 50,000 23,000 15,000 2,500 6,500 2,100 400 1,200 2,000 300 2,200 Comments All Salary Costs Inclusive of $657,000 Salary, Taxes, PERA Benefits 11,000 131,000 Minn Recreation Parks Ass'n Paper, Magazines, JC Dues, etc. 100 4,500 74,000 Net Effect for St. Joe's Operations $1,142,300 $1,142,300 0 Donation Account Page Two September 1, 2009 2010 BUDGET WORKSHEETS PARKS RECREATION 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 101 45100 81 Softball $44,625 $43,973 $49,985 $45,000 $45,000 101 45100 82 Volleyball 335 85 0 0 0 101 45100 84 Tennis 1,137 1,727 1,893 2,000 2,000 101 45100 85 Tiny Tots 21,285 22,769 18,543 21,500 21,500 101 45100 86 Rosettes 817 1,281 1,111 1,200 1,200 101 45100 87 Trips 10,667 7,327 7,013 8,300 8,300 101 45100 88 Broomball 0 0 0 0 0 101 45100 90 Run for the Gold 3,405 3,966 3,027 4,000 4,000 101 45100 91 Camps 14,918 11,917 10,846 12,000 12,000 101 45100 92 Adult Basketball 0 501 859 600 600 101 45100 93 Other Programs 13,017 14,348 11,218 14,500 14,500 101 45100 95 T -Ball 5,320 6,587 5,286 7,000 7,000 101 45100 96 Teen Night 5,245 5,322 5,478 5,000 5,000 101 45100 97 Soccer League 844 11,071 9,627 0 0 101 45100 98 Soccer Lessons 1,211 2,682 3,406 2,600 2,600 GRAND TOTAL PARK REC 122,826 133,556 128,294 123,700 123,700 AAAA Detail for Above AAA $123,700 Comments No League in 2010 101 45100 81 103.00 Part-Time Salaries 7,746 6,568 7,332 7,000 7,000 101 45100 81 219.00 Operating Supplies 5,609 7,521 10,037 8,000 8,000 101 45100 81 311.00 Officiating Fees 28,000 26,266 27,470 27,000 27,000 101 45100 81 319.00 Other Professional Services 3,270 3,617 5,146 3,000 3,000 101 45100 82 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 82 219.00 Operating Supplies 335 85 0 0 0 101 45100 82 311.00 Officiating Fees 0 0 0 0 0 101 45100 82 319.00 Other Professional Services 0 0 0 0 0 101 45100 84 103.00 Part-Time Salaries 1,061 1,223 1,604 1,500 1,500 101 45100 84 219.00 Operating Supplies 76 504 290 500 500 101 45100 85 103.00 Part-Time Salaries 18,829 21,617 17,685 20,000 20,000 101 45100 85 219.00 Operating Supplies 2,455 1,152 857 1,500 1,500 101 45100 86 103.00 Part-Time Salaries 356 346 490 400 400 101 45100 86 219.00 Operating Supplies 460 935 621 800 800 101 45100 87 103.00 Part-Time Salaries 859 799 638 1,000 1,000 101 45100 87 219.00 Operating Supplies 9,807 7,300 101 45100 87 219.01 Youth/Teen Trips Supplies 0 4,369 4,561 4,300 4,300 101 45100 87 219.02 Adult/Senior Trips Supplies 0 2,159 1,815 3,000 3,000 101 45100 88 219.00 Operating Supplies 0 0 0 0 0 101 45100 88 311.00 Officiating Fees 0 0 0 0 0 101 45100 90 219.00 Operating Supplies 3,405 3,966 3,027 4,000 4,000 101 45100 91 103.00 Part-Time Salaries 6,773 4,319 3,297 5,000 5,000 101 45100 91 219.00 Operating Supplies 8,145 7,598 7,549 7,000 7,000 101 45100 92 219.00 Operating Supplies 0 501 859 600 600 101 45100 93 103.00 Part-Time Salaries 3,013 3,093 3,069 3,000 3,000 101 45100 93 219.00 Operating Supplies 10,004 10,265 7,859 11,500 11,500 101 45100 93 319.00 Other Professional Services 0 990 290 0 0 101 45100 95 103.00 Part-Time Salaries 3,641 4,585 3,435 5,500 5,500 101 45100 95 219.00 Operating Supplies 1,679 2,002 1,850 1,500 1,500 101 45100 96 103.00 Part-Time Salaries 1,273 1,684 1,262 0 0 101 45100 96 219.00 Operating Supplies 3,971 3,638 4,216 5,000 5,000 101 45100 97 103.00 Part-Time Salaries 806 0 0 0 0 101 45100 97 219.00 Operating Supplies 38 821 717 0 0 101 45100 97 311.00 Officiating Fees 0 10,250 8,910 0 0 101 45100 98 103.00 Part -Time Salaries 273 1,571 1,989 1,000 1,000 101 45100 98 219.00 Operating Supplies 938 1,112 1,418 1,600 1,600 SPECIAL PROGRAM TOTALS 122,826 133,556 128,294 123,700 123,700 $1,080,786 $1,152,615 $1,186,883 $1,272,100 $1,266,000 OTHER FINANCING USES TRANSFERS This is a transfer set up beginning in 2007 for the assistance from the General Fund to the Arena Fund for the operations of the arena. Page One 2010 BUDGET WORKSHEETS OTHER FINANCING USES September 1, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 101 49300- 01710.00 Transfers FUND TOTALS $0 $100,000 $165,000 $115,000 $115,000 Arena Operations Assistance $0 $100,000 $165,000 $115,000 $115,000 Comments CAPITAL IMPROVEMENT PLAN (CIP) GENERAL ADMINISTRATIVE Provides for specific funding of items, the nature of which are not considered "current" in their use or life 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 in the CIP funds for capital equipment purchases or for street projects such as gravel road resurfacing. If these revenues are realized, the equipment or project will be completed and if the revenue is not realized 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 lights, signal lights, 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 2010 only. As part of a long -range planning process, a 10 -year CIP working plan has been adopted for the years 2010 through 2019. This is a working plan only, with the current year (2010 in this case) being approved as part of the formal budget process. 0 -4 0 0 CO co 0 CO 0 0 0 0 0 0 CO CO g co 0 0 0 k 1 k 0 0 0 g. IJ 0 k f 0 0 0 co 0 0 8 8 0 e 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 CO 0 g a k k 0 g 8 0 j 8 0 0 8 CO 0 0 3 k 0 k R. k j 0 0 0 0 0 0 CO 0 g i cn 0 2 Cll 8 CO 0 k CO 01 3 0 CO i CO CO i Q7 i 0 CO 0 au WM 51 co oo 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 Cities Insurance Trust. This agency allows the City to have thorough, yet affordable insurance. In 1995, we set up a separate Internal Service Fund for insurance purposes. The amount levied was, and will be, the same as it would have been if the Insurance budget had been in the General Fund, as it has been in the past. But, this allows us to build a special fund for insurance purposes that will allow the City to move towards self insurance, and ultimately, lower rates. We do not anticipate ever being totally self insured, but by raising our deductibles we approach that point and allow ourselves to save substantially on our annual insurance premiums. Doing so will allow the City to operate more efficiently and save the taxpayers money without taking undue risks. Page One September 1, 2009 Account Description 206 31010.00 206 33100.00 206 36210.00 206 36214.00 206 36215.00 206 36260.00 Current Ad Valorem Taxes Federal Grants Aids Interest Eamings- Investments Net Change in FV- Investments Interest Eamings Other Revenue FUND TOTALS Account Description 2010 BUDGET WORKSHEETS INSURANCE REVENUES INSURANCE EXPENDITURES 206 49006 01 221.00 Equipment Parts 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 319.01 Risk Management Consultant 206 49006 01 319.02 CHESS Consultant 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 2008 Actual Actual Actual $260,000 $260,000 $275,000 $275,000 0 0 23,660 29,968 24,345 28,000 0 562 (375) 292 161 409 500 14,775 26,743 19,713 21,000 298,727 317,433 319,091 324,500 2006 2007 2008 Actual Actual Actual $1,163 $2,653 0 6,543 2,500 17,495 0 7,260 2,500 18,240 0 5,051 2,500 10,100 8,200 70,877 76,437 88,429 180,146 178,524 165,746 11,136 17,747 10,120 15,000 0 97 0 289,860 303,458 290,145 324,500 9,500 10,500 10,500 13,500 85,000 190,000 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget $0 $3,000 1,000 8,000 2,500 NOTE: Levy of $275,000 covers costs for all insurance premiums. All other expenditures covered through interest eamings and insurance refunds /dividends. $275,000 0 26,000 0 Annual Market Value Changes 500 20,000 Insurance Refunds/Dividends 321,500 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget $2,500 Liability Auto Deductible Pymts 500 7,000 2,500 24,000 92,000 Annual Premium 183,000 Annual Premium General Liability 10,000 Liability Auto Deductible Pymts 0 321,500 Comments Comments Unreimbursable Legal Fees Work Comp Deductible Pymts Yearly Fee Per Policy F -3 Risk Management Consultant 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 Authority will continue to work on other development and redevelopment projects related to commercial and industrial development. Page One June 16, 2009 Account 201 31010.00 201 31050.00 201 33130.00 201 33425.00 201 34109.00 201 36105.00 201 36210.00 201 36212.00 201 36215.00 201 36230.00 201 36260.00 201 36265.00 201 39101.00 Account Description Description 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 TIF Charges 201 46300 01 319.04 P/A Property Tax Payments 201 46300 01 319.07 Central Park Survey Work 201 46300 01 322.00 Postage Costs 201 46300 01 349.00 Other Advertising. 201 46300 01 351.00 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 383.00 Gas Utilities 201 46300 01 389.00 Other Utility Services 201 46300 01 403.00 201 46300 01 433.00 201 46300 01 433.01 201 46300 01 433.02 201 46300 01 437.00 201 46300 01 439.00 201 46300 01 521.00 201 46300 01 525.00 201 46300 01 530.00 201 46300 01 710.00 Transfers 2010 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 Blake Interest Eamings Contributions /Donations Other Revenue Use of Reserve Funds Sales of General Fixed Assets EXPENDITURES Contracted Repairs Maintenance Dues Subscriptions Professional Organizations /Jourm Foreign Trade Zone Commission Conferences Seminars Other Miscellaneous Charges Building Structure Purchases Building Structure Purchases Improvements Other Than Bldgs FUND TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $60,000 0 0 0 0 38,064 5,552 6,484 355 0 0 0 0 $0 0 0 0 11,256 499,021 5,254 3,072 418 0 0 0 0 $50,000 0 0 0 13,319 0 632 0 204 0 421 0 0 $50,000 0 0 0 0 0 2,000 0 200 0 0 22,500 0 FUND TOTALS $110,454 $519,021 $64,576 $74,700 $53,200 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $4,233 $5,393 $3,870 $5,000 1,421 3,834 0 0 0 0 0 0 0 6,000 919 14,599 3,152 834 0 0 73 0 0 399 1,454 3,207 846 1,258 0 1,365 15,000 4,844 788 0 0 6,254 0 0 0 0 0 0 0 6,400 3,750 70 7,066 2,170 0 85 163 0 0 429 4,323 7,229 8,314 1,789 964 1,360 15,000 7,106 139 O 0 O 558,910 0 0 0 0 1,596 0 0 0 0 0 0 0 6,000 3,150 0 7,996 10,546 7,307 117 2,050 0 491 456 4,385 4,420 9,814 1,871 0 1,195 0 4,697 89 0 0 0 0 4,000 5,000 0 0 0 0 0 0 0 6,000 2,000 0 4,000 1,000 1,000 3,000 20,000 200 10,000 500 2,500 1,000 0 1,000 0 2,000 1,700 0 0 6,000 500 0 0 0 0 0 0 0 0 0 2,000 0 0 1,000 0 $64,224 $636,913 $70,049 $74,700 $53,200 Comments $50,000 Operating Levy O Admin Fees Portion Only 0 O LCDA Downtown Grant 1,000 Genz -Ryan Tenant Utility Pymts O Blake UT Lease Sold in 2007 2,000 Interest Eamed on CD's 0 Blake UT Lease Sold in 2007 200 Checking Interest Misc 0 0 0 0 $5,000 Comments 6,000 Yearly Fee Per Policy F -3 3,000 All Salary Costs Inclusive of Salary, Taxes, PERA Benefits Port Authority Members 4,000 4,000 0 (EIS) or (AUAR) 0 0 0 Moved to "349.00" Below 1,000 14,000 Additional Marketing 0 3,000 500 Commissioners 2,800 Property Insurance 1,000 Business Park Other Properties 700 Other Properties 1,000 Utility Fees 1,700 Prof Organizations/Journals 5,000 Development/TIF/Miscellaneous 500 Contingencies 0 0 0 Special Downtown Projects Page One June 16, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 242 31050.00 Tax Increments $14,675 $134,224 $296,735 $300,000 242 33400.00 State Grants Aids 0 0 422,179 0 242 33620.00 Other County Grants Aids 0 0 100,000 0 242 36210.00 Interest Eamings Investments 0 803 427 0 242 36215.00 Interest Eamings 70 258 99 0 242 36220.00 Rents Royalties 9,679 65,041 30,252 0 242 36260.00 Other Revenue 0 10,000 9,500 0 242 39310.00 Bond Proceeds 0 0 6,040,000 0 FUND TOTALS $24,425 $210,326 $6,899,192 $300,000 Account 242 49042 01 303.00 242 49042 01 304.00 242 49042 01 319.00 242 49042 01 522.00 242 49042 01 530.00 242 49042 01 611.00 242 49042 01 710.00 2010 BUDGET WORKSHEETS DOWNTOWN /BROCKWAY DISTRICT(0108) REVENUES D EXPENDITURES Engineering Fees Legal Fees Other Professional Services Building Structure Purchases Improvements Other Than Buildings Interest on Internal Loan Transfers FUND TOTALS 2006 2007 2008 Actual Actual Actual $0 $0 $201,758 $0 O 0 434 0 6,188 89,898 177,259 0 2,460,390 356,987 900,945 0 O 35,139 1,944,456 0 64,376 127,656 34,825 0 O 0 86,000 300,000 $2,530,954 $609,681 $3,345,677 $300,000 $300,000 $300,000 0 0 0 0 0 0 0 $300,000 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget Comments $0 0 0 0 0 0 300,000 P I for 2008A 2008B Issues DEBT SERVICE FUNDS GENERAL ADMINISTRATIVE Debt Service Funds are Governmental Funds set up to provide for the repayment of debt of the City. This debt is normally accomplished through the issuance of bonds secured by the full faith and credit of the City. Repayment of the debt is usually accomplished 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 2010 BUDGET WORKSHEETS DEBT SERV FUND 335 G.O. IMPROVEMENT BONDS, 1999A REVENUES September 1, 2009 2009 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget 335 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 335 36101.00 Principal Special Assessments 30,821 29,275 27,729 0 0 335 36102.00 Penalties Interest S/A 0 0 0 0 0 335 36210.00 Interest Earnings Investments 40,278 50,968 19,387 0 0 335 36215.00 Interest Eamings 60 33 134 0 0 335 36260.00 Other Revenue 0 0 0 0 0 335 36265.00 Use of Reserve Funds 0 0 0 279,200 262,800 335 37145.00 Surcharge on Water Revenues 0 0 0 0 0 335 37160.00 Penalties Surcharge Revenues 0 0 0 335 39202.00 Contribution From Enterprises 0 0 0 0 0 335 39203.00 Transfer From 0 0 0 0 0 335 39204.00 Transfer From Water Core 0 0 0 0 0 335 39205.00 Transfer From Sewer Core 0 0 0 0 0 335 39206.00 Transfer From Storm Core 0 0 0 0 0 335 39207.00 Transfer From Port Authority 0 0 0 0 0 335 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $71,159 $80,277 $47,250 $279,200 $262,800 EXPENDITURES 2009 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget 335 47000 01 317.00 General Fund Admin Fees 335 47000 01 319.00 Other Professional Services Comments Comments $0 $0 $0 $0 $0 0 0 0 0 0 335 47000 01 601.00 Bond Principal 265,000 260,000 255,000 250,000 245,000 335 47000 01 611.00 Bond Interest 63,148 51,730 40,273 28,800 17,300 335 47000 01 621.00 Bond Paying Agent Fees 403 403 403 400 500 335 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $328,550 $312,133 $295,675 $279,200 $262,800 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 617 G.O. WATER REVENUE BONDS, 2000A REVENUES September 1, 2009 Account Description EXPENDITURES 617 47000 01 317.00 General Fund Admin Fees 617 47000 01 319.00 Other Professional Services 2009 2010 2006 2007 2008 Adopted Proposed Actual Actual Actual Budget Budget Comments 617 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 617 36101.00 Principal Special Assessments 0 0 0 0 617 36102.00 Penalties Interest S/A 0 0 0 0 0 617 36210.00 Interest Earnings Investments 5,038 6,673 5,279 0 0 617 36215.00 Interest Earnings 25 15 21 0 617 36265.00 Use of Reserve Funds 0 0 0 0 0 617 37145.00 Surcharge on Water Revenues 0 0 0 0 0 617 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 617 39202.00 Contribution From Enterprises 0 0 0 0 0 617 39203.00 Transfer From 0 0 0 0 0 617 39204.00 Transfer From Water Core 112,000 115,000 115,000 113,000 115,000 617 39205.00 Transfer From Sewer Core 0 0 0 0 617 39206.00 Transfer From Storm Core 0 0 0 0 0 617 39207.00 Transfer From Port Authority 0 0 0 0 0 617 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $117,063 $121,688 $120,300 $113,000 $115,000 2009 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments $0 $0 $0 $0 $0 0 0 0 0 0 617 47000 01 601.00 Bond Principal 65,000 70,000 75,000 75,000 80,000 617 47000 01 611.00 Bond Interest 44,799 41,532 37,992 35,900 32,200 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 374 374 374 700 700 617 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $111,524 $113,257 $114,717 $113,000 $114,300 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 612 G.O. STORM WATER REVENUE BONDS, 2001B REVENUES September 1, 2009 Account 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 Account 612 47000 01 317.00 612 47000 01 319.00 612 47000 01 601.00 612 47000 01 611.00 612 47000 01 614.00 612 47000 01 621.00 612 47000 01 710.00 2006 Description Actual Current Ad Valorem Taxes $0 $0 $0 $0 $0 Principal Special Assessments 0 0 0 0 0 Penalties Interest S/A 0 0 0 0 0 Interest Earnings Investments 7,195 9,316 7,011 0 0 Interest Earnings 28 25 150 0 0 Use of Reserve Funds 0 0 0 0 0 Surcharge on Water Revenues 0 0 0 0 0 Penalties Surcharge Revenues 0 0 0 0 0 Contribution From Enterprises 54,000 53,000 54,000 53,000 54,000 Transfer From 0 0 17,724 0 0 Transfer From Water Core 0 0 0 0 0 Transfer From Sewer Core 0 0 0 0 0 Transfer From Storm Core 54,000 53,000 54,000 53,000 54,000 Transfer From Port Authority 0 0 0 0 0 Bond Proceeds 0 0 0 0 0 FUND TOTALS EXPENDITURES Description General Fund Admin Fees Other Professional Services Bond Principal Bond Interest Amortization of Bond Discount Bond Paying Agent Fees Transfers FUND TOTALS 2007 2008 Actual Actual 2009 Adopted Budget $115,222 $115,341 $132,885 $106,000 $108,000 2009 2006 2007 2008 Adopted Actual Actual Actual Budget 2010 Proposed Budget Comments $107,573 $104,973 $107,190 $105,600 $107,600 2010 Proposed Budget Comments $0 $0 $0 $0 $0 0 0 0 0 0 65,000 65,000 70,000 70,000 75,000 40,868 38,268 35,485 33,900 30,900 1,303 1,303 1,303 1,300 1,300 403 403 403 400 400 0 0 0 0 0 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 382 G.O. PORT REA AUTHORITY PUBLIC FACILITY BONDS, 2001C September 1, 2009 2009 2010 2006 2007 2008 Adopted Proposed Comments Account Description Actual Actual Actual Budget Budget 382 31010.00 Current Ad Valorem Taxes $171,864 $168,504 $170,394 $172,074 $173,4030 0 0 Principal Special Assessments 0 0 0 382 36101.00 P P 0 0 1'958 0 382 36102.00 Penalties Interest SIA 8 030 10,168 8,899 0 382 36210.00 Interest Earnings Investments 17 11 0 0 382 36265.00 Use of Reserve Funds Interest Earnings 22 0 0 382 36215.00 0 0 0 0 0 0 0 382 37145.00 Surcharge on Water Revenues 0 0 0 0 0 0 382 39101.00 Sale of General Fixed Assets 0 0 0 0 Contribution From Enterprises 0 0 0 382 39202.00 0 0 0 382 39203.00 Transfer From 382 39204.00 Transfer From Water Core 0 0 0 0 0 0 0 0 0 0 382 39205.00 Transfer From Sewer Core 0 0 0 0 382 39206.00 Transfer From Storm Core 0 0 0 0 0 0 382 39207.00 Transfer From Port Authority 0 0 0 0 382 39310.00 Bond Proceeds 0 FUND TOTALS $180,920 $178,689 $181,261 $172,074 $173,403 EXPENDITURES 2009 2010 2006 2007 2008 Adopted Proposed Account# Description Actual Actual Actual Budget_ Budget $0 $0 $0 $0 382 47000 01 317.00 General Fund Admin Fees $0 0 0 0 0 382 47000 01 319.00 Other Professional Services 0 382 47000 01 601.00 Bond Principal 75,000 80,000 80,000 85,000 90,000 382 47000 01 611.00 Bond Interest 85,180 82,080 431 431 500 500 78,880 75,600 72,100 382 47000 01 621.00 Bond Paying Agent Fees 0 382 47000 01 710.00 Transfers 0 0 0 0 FUND TOTALS $160,611 $162,511 $159,311 $161,100 $162,600 Comments Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 304 G.O. COMMUNITY CENTER REFUNDING BONDS, 2001E REVENUES- September 1, 2009 2009 2010 2006 2007 2008 Adopted Proposed Comments Account Description Actual Actual Actual Budget Budget 304 31010.00 Current Ad Valorem Taxes $91,945 $94,704 $96,941 $93,713 0 304 36101.00 Principal Special Assessments 0 0 0 0 0 304 36102.00 Penalties Interest S/A 30 5,310 4,802 0 0 304 36210.00 Interest Earnings Investments 3,835 32 31 0 0 304 36215.00 Interest Earnings 0 0 1 0 88,200 304 36265.00 Use of Reserve Funds 0 0 0 0 0 304 37145.00 Surcharge on Water Revenues 0 0 0 0 0 304 39101.00 Sale of General Fixed Assets 0 0 0 0 0 304 39202.00 Contribution From Enterprises 0 0 157,650 0 0 304 39201.00 Transfer From General Fund 0 0 0 0 0 304 39204.00 Transfer From Water Core 0 0 0 0 0 304 39205.00 Transfer From Sewer Core 0 0 0 0 0 304 39206.00 Transfer From Storm Core 0 0 0 0 0 304 39207.00 Transfer From Port Authority 0 0 0 0 0 304 39310.00 Bond Proceeds TN FUND TOTALS $95,808 $100,046 $259,424 $93,713 $88,200 Account EXPENDITURES 2009 2010 2006 2007 2008 Adopted Proposed Comments Description Actual Actual Actual Budget Budget 304 47000 01 317.00 General Fund Admin Fees $0 $0 $0 0 304 47000 01 319.00 Other Professional Services 0 0 0 0 304 47000 01 601.00 Bond Principal 70,000 65,000 70,000 75,000 75,000 304 47000 01 611.00 Bond Interest 23,845 21,381 18,760 15,800 12,700 304 47000 01 621.00 Bond Paying Agent Fees 403 603 403 400 500 0 0 0 0 0 304 47000 01 710.00 Transfers FUND TOTALS $94,248 $86,984 $89,163 $91,200 $88,200 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 338 G.O. IMPROVEMENT BONDS, 2002A REVENUES September 1, 2009 2009 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget 338 31010.00 Current Ad Valorem Taxes $6,913 $10,772 $0 338 36101.00 Principal Special Assessments 620,059 531,748 89,370 0 338 36102.00 Penalties Interest SIA 2,802 299 1,634 0 0 338 36210.00 Interest Earnings Investments 11,644 29,467 15,266 0 0 3 38 36215.00 Interest Eamings 42 35 65 338 36265.00 Use of Reserve Funds 0 0 0 59,100 57,400 338 37145.00 Surcharge on Water Revenues 0 0 0 0 0 338 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 338 39202.00 Contribution From Enterprises 0 0 0 0 0 338 39203.00 Transfer From 0 0 0 0 0 338 39204.00 Transfer From Water Core 0 0 0 0 0 338 39205.00 Transfer From Sewer Core 0 0 0 0 0 338 39206.00 Transfer From Storm Core 0 0 0 0 0 338 39208.00 Transfer From Street CIP 0 0 0 0 0 338 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $641,460 $572,321 $106,336 $59,100 $57,400 EXPENDITURES Comments 2009 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 338 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 338 47000 01 319.00 Other Professional Services 0 0 0 338 47000 01 601.00 Bond Principal 635,000 620,000 605,000 50,000 50,000 338 47000 01 611.00 Bond Interest 60,425 40,825 20,163 8,700 6,900 338 47000 01 621.00 Bond Paying Agent Fees 403 403 403 400 500 338 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $695,828 $661,228 $625,565 $59,100 $57,400 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 619 G.O. WATER STORM WATER REVENUE BONDS, 2002B REVENUES September 1, 2009 2009 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 619 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 619 36101.00 Principal Special Assessments 608 1,294 141 0 0 0 0 619 36102.00 Penalties Interest S/A 619 36210.00 Interest Earnings Investments 1,523 2,511 2,451 0 0 619 36215.00 Interest Earnings 31 26 30 0 0 619 36265.00 Use of Reserve Funds 0 0 0 0 0 619 37145.00 Surcharge on Water Revenues 0 0 0 0 0 619 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 619 39202.00 Contribution From Enterprises 29,000 29,000 28,000 28,000 28,00 30,000 619 39203.00 Transfer From 619 39204.00 Transfer From Water Core 57,000 60,000 55,000 54,000 56,000 619 39205.00 Transfer From Sewer Core 0 0 0 0 0 619 39206.00 Transfer From Storm Core 29,000 29,000 28,000 28,000 30,000 619 39207.00 Transfer From Port Authority 0 0 0 0 0 619 39310.00 Bond Proceeds 0 0 0 0 0 Account 619 47000 01 317.00 619 47000 01 319.00 619 47000 01 601.00 619 47000 01 611.00 619 47000 01 614.00 619 47000 01 621.00 619 47000 01 710.00 FUND TOTALS EXPENDITURES- Description $117,163 $121,842 $113,629 $110,000 $116,000 2009 2010 2006 2007 2008 Adopted Proposed Actual Actual Actual Budget Budget Comments General Fund Admin Fees $0 $0 $0 Other Professional Services 0 0 0 0 0 Bond Principal 70,000 70,000 70,000 70,000 80,000 Bond Interest 42,183 40,018 37,672 36,300 33,500 Amortization of Bond Discount 1,441 1,441 1,441 1,500 1,500 Bond Paying Agent Fees 403 403 403 500 500 Transfers 0 0 0 0 0 FUND TOTALS $114,026 $111,862 $109,515 $108,300 $115,500 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 339 G.O. IMPROVEMENT BONDS, 2003A REVENUES September 1, 2009 Account Description 339 31010.00 Current Ad Valorem Taxes $86,354 $86,354 $86,354 $86,354 $86,354 L for St. Joe's Assumed S/A 339 36101.00 Principal Special Assessments 153,630 88,374 61 259 0 0 339 36102.00 Penalties Interest S/A 54 18,148 17,343 0 0 339 36210.00 Interest Earnings Investments 8,354 16 30 0 0 339 36215.00 Interest Eamings 0 0 0 52,646 47,046 339 36265.00 Use of Reserve Funds 0 0 0 0 0 339 37145.00 Surcharge on Water Revenues 0 0 0 0 0 339 37160.00 Penalties Surcharge Revenues 339 39202.00 Contribution From Enterprises 44,000 44,000 42,000 81,165 0 0 42,000 42,00 339 39203.00 Transfer From 0 0 0 0 0 339 39204.00 Transfer From Water Core 0 0 0 0 0 339 39205.00 Transfer From Sewer Core 339 39206.00 Transfer From Storm Core 44,000 44,000 42,000 0 0 0 42,000 42,000 339 39208.00 Transfer From Street CIP 0 339 39310.00 Bond Proceeds 0 0 0 0 0 $417,594 $281,049 $249,970 $223,000 $217,400 FUND TOTALS 2009 2010 2006 2007 2008 Adopted Proposed Comments Account Description Actual Actual Actual Budget Budget 0 0 0 0 0 195,000 195,000 195,000 190,000 190,000 47,078 42,690 37,815 32,600 26,900 403 403 403 400 0 0 0 0 0 $242,480 $238,093 $233,218 $223,000 $217,400 339 47000 01 317.00 General Fund Admin Fees 339 47000 01 319.00 Other Professional Services 339 47000 01 601.00 Bond Principal 339 47000 01 611.00 Bond Interest 339 47000 01 621.00 Bond Paying Agent Fees 339 47000 01 710.00 Transfers EXPENDITURES FUND TOTALS 2009 2006 2007 2008 Adopted Actual Actual Actual Budget 2010 Proposed Budget Comments Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 613 G.O. WATER REVENUE BONDS, 2003B REVENUES- September 1, 2009 2009 2010 2006 2007 2008 Adopted Proposed Actual Actual Actual Budget Budget Comments Account Description 613 31010.00 Current Ad Valorem Taxes $0 $0 0 0 0 $00 $0 0 613 36101.00 Principal Special Assessments 0 0 0 0 613 36102.00 Penalties Interest SIA 23 517 482 0 0 613 36210.00 Interest Earnings Investments 26 4 42 0 0 613 36215.00 Interest Eamings 0 0 0 0 0 613 36265.00 Use of Reserve Funds 0 0 0 0 0 613 37145.00 Surcharge on Water Revenues 0 0 0 0 0 613 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 613 39202.00 Contribution From Enterprises 0 0 0 0 0 613 39203.00 Transfer From 613 39204.00 Transfer From Water Core 132,000 140,000 140,000 138,000 0 0 0 0 135,0000 613 39205.00 Transfer From Sewer Core 0 0 0 0 0 613 39206.00 Transfer From Storm Core 0 0 0 0 0 613 39207.00 Transfer From Port Authority 0 0 0 0 0 613 39310.00 Bond Proceeds FUND TOTALS $132,257 $140,521 $140,524 $138,000 $135,000 EXPENDITURES 2009 2010 2006 2007 2008 Adopted Proposed Comments Account Description Actual Actual Actual Budget Budget 613 47000 01 317.00 General Fund Admin Fees $0 $0 $0 0 613 47000 01 319.00 Other Professional Services 0 0 0 0 613 47000 01 601.00 Bond Principal 105,000 110,000 110,000 115,000 115,000 613 47000 01 611.00 Bond Interest 26,024 24,078 21,795 20,300 17,400 613 47000 01 614.00 Amortization of Bond Discount 1,852 403 1 403 1,852 403 1 400 1 900 613 47000 01 621.00 Bond Paying Agent Fees 613 47000 01 710.00 Transfers FUND TOTALS $133,278 $136,332 $134,049 $137,600 $134,700 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 301 G.O. CAPITAL IMPROVEMENT PLAN (CIP) BONDS, 2005A REVENUES September 1, 2009 Account Account 301 47000 01 317.00 301 47000 01 319.00 301 47000 01 601.00 301 47000 01 611.00 301 47000 01 621.00 301 47000 01 710.00 Description 301 31010.00 Current Ad Valorem Taxes $208,978 $210,737 $212,313 $208,454 $209,846 301 36101.00 Principal Special Assessments 0 0 0 0 0 301 36102.00 Penalties Interest S/A 0 301 36210.00 Interest Earnings Investments 1,139 2,016 2,366 0 0 0 3 01 36215.00 Interest Earnings 0 21 0 0 0 301 36265.00 Use of Reserve Funds 0 0 0 0 0 301 37145.00 Surcharge on Water Revenues 0 0 0 0 301 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 301 39202.00 Contribution From Enterprises 0 0 0 0 0 301 39203.00 Transfer From 0 0 0 0 0 301 39204.00 Transfer From Water Core 0 0 0 0 0 301 39205.00 Transfer From Sewer Core 0 0 0 0 0 301 39206.00 Transfer From Storm Core 0 0 0 0 0 301 39207.00 Transfer From Port Authority 0 0 0 0 0 301 39310.00 Bond Proceeds FUND TOTALS $210,128 $212,774 $214,687 $208,454 $209,846 EXPENDITURES Description General Fund Admin Fees Other Professional Services Bond Principal Bond Interest Bond Paying Agent Fees Transfers FUND TOTALS 2006 2007 Actual Actual 2009 2010 2008 Adopted Proposed Actual Budget Budget 2009 2010 2006 2007 2008 Adopted Proposed Comments Actual Actual Actual Budget Budget $0 $0 $0 $0 SO 1,300 0 0 0 0 95,000 100,000 105,000 105,000 117,320 102,365 98,953 95,400 91,700 403 403 403 400 500 0 0 0 0 0 $119,022 $197,768 $199,355 $200,800 $197,200 Comments Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 302 G.O. EQUIPMENT CERTIFICATES, 2005B REVENUES 2009 2010 2006 2007 2008 Adopted Proposed Comments Account Description Actual Actual Actual Budget Budget 302 31010.00 Current Ad Valorem Taxes $347,219 $349,198 $345,395 $346,290 302 36101.00 Principal Special Assessments 0 0 0 0 0 302 36102.00 Penalties Interest SIA 0 0 210 0 0 302 36210.00 Interest Earnings Investments 0 2 6 0 0 302 36215.00 Interest Earnings 0 0 0 0 330,500 302 36265.00 Use of Reserve Funds 0 0 0 0 0 302 37145.00 Surcharge on Water Revenues 0 0 0 0 0 302 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 302 39202.00 Contribution From Enterprises 0 0 283,700 0 0 302 39201.00 Transfer From_General Fund 0 0 0 0 0 302 39204.00 Transfer From Water Core 0 0 0 0 0 302 39205.00 Transfer From Sewer Core 0 0 0 0 0 302 39206.00 Transfer From Storm Core 0 0 0 0 0 302 39207.00 Transfer From Port Authority 0 0 0 0 0 302 39310.00 Bond Proceeds FUND TOTALS $347,219 $349,200 $629,311 $346,290 $330,500 September 1, 2009 Account EXPENDITURES 2009 2010 2006 2007 2008 Adopted Proposed Description Actual Actual Actual Budget Budget 302 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 302 47000 01 319.00 Other Professional Services 0 0 0 0 302 47000 01 601.00 Bond Principal 290,000 300,000 305,000 315,000 325,000 302 47000 01 611.00 Bond Interest 40,685 32,570 23,948 14,800 5,100 302 47000 01 621.00 Bond Paying Agent Fees 403 403 403 400 400 302 47000 01 710.00 Transfers FUND TOTALS $331,088 $332,973 $329,350 $330,200 $330,500 Comments Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 610 G.O. WATER REVENUE BONDS, 2005C REVENUES- September 1, 2009 2009 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 610 31010.00 Current Ad Valorem Taxes $0 $0 $0 610 36101.00 Principal Special Assessments 4,148 552 589 0 0 610 36102.00 Penalties Interest S/A 0 0 610 36210.00 Interest Earnings Investments 21,194 36,267 32,410 0 0 0 610 36215.00 Interest Earnings 103 32 27 610 36265.00 Use of Reserve Funds 0 0 0 0 0 0 0 For 1/1/07 Used for WTP 610 37145.00 Surcharge on Water Revenues 202,870 0 0 0 610 37160.00 Penalties Surcharge Revenues 1,998 0 0 0 0 0 610 39202.00 Contribution From Enterprises 0 0 610 39203.00 Transfer From 0 0 413,904 0 610 39204.00 Transfer From Water Core 0 340,000 364,000 364,000 364,000 0 0 0 0 0 610 39205.00 Transfer From Sewer Core 0 0 0 610 39206.00 Transfer From Storm Core 0 0 610 39207.00 Transfer From Port Authority 0 0 0 0 0 0 0 610 39310.00 Bond Proceeds 0 0 FUND TOTALS $230,313 $376,851 $810,931 $364,000 $364,000 EXPENDITURES 2009 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 610 47000 01 317.00 General Fund Admin Fees $0 0 0 6 47000 01 319.00 Other Professional Services 0 0 610 47000 01 601.00 Bond Principal 0 235,000 270,000 275,000 285,000 610 47000 01 611.00 Bond Interest 106,363 98,823 89,475 83,900 74,100 610 47000 01 614.00 Amortization of Bond Discount 3,949 3,949 3,949 4,000 4,000 610 47000 01 621.00 Bond Paying Agent Fees 403 403 403 500 500 610 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $110,714 $338,174 $363,826 $363,400 $363,600 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 303 G.O. FIRE STATION REFUNDING BONDS, 2005D (Old 1996A) REVENUES September 1, 2009 2009 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 303 31010.00 Current Ad Valorem Taxes $154,308 $142,527 $144,417 $146,084 $142,273 303 36101.00 Principal Special Assessments 0 0 0 0 0 303 36102.00 Penalties Interest S/A 303 36210.00 Interest Eamings Investments 12,939 7,809 7,686 0 0 303 36215.00 Interest Eamings 35 20 20 0 0 303 36265.00 Use of Reserve Funds 0 0 0 0 0 303 37145.00 Surcharge on Water Revenues 0 0 0 0 0 303 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 303 39202.00 Contribution From Enterprises 0 0 0 0 0 303 39203.00 Transfer From 0 0 0 0 0 303 39204.00 Transfer From Water Core 0 0 0 0 0 303 39205.00 Transfer From Sewer Core 0 0 0 0 0 303 39206.00 Transfer From Storm Core 0 0 0 0 0 303 39207.00 Transfer From Port Authority 0 0 0 0 0 303 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $167,282 $150,356 $152,122 $146,084 $142,273 EXPENDITURES 2009 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 303 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 303 47000 01 319.00 Other Professional Services 303 47000 01 601.00 Bond Principal 1,165,000 85,000 100,000 105,000 110,000 1996A Called 2/1/06 303 47000 01 611.00 Bond Interest 61,873 37,079 34,140 30,900 27,400 303 47000 01 621.00 Bond Paying Agent Fees 861 403 403 400 500 303 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $1,227,734 $122,481 $134,543 $136,300 $137,900 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 321 G.O. EQUIPMENT CERTIFICATES, 2006A REVENUES- September 1, 2009 2006 Account Description Actual 321 31010.00 Current Ad Valorem Taxes $0 $87,955 $85,237 $87,767 321 36101.00 Principal Special Assessments 0 0 0 0 0 321 36102.00 Penalties Interest S/A 0 995 0 0 321 36210.00 Interest Eamings Investments 0 0 0 321 36215.00 Interest Earnings 25 13 12 0 0 0 82,700 321 36265.00 Use of Reserve Funds 0 0 0 0 0 321 37145.00 Surcharge on Water Revenues 0 0 0 0 321 37160.00 Penalties Surcharge Revenues 0 0 321 39202.00 Contribution From Enterprises 0 0 0 0 0 0 150,650 0 0 321 39201.00 Transfer From General Fund 0 0 0 0 0 321 39204.00 Transfer From Water Core 0 0 0 0 0 321 39205.00 Transfer From Sewer Core 0 0 0 321 39206.00 Transfer From Storm Core 0 0 321 39207.00 Transfer From Port Authority 0 0 0 0 0 g 178 0 0 0 0 321 39310.00 Bond Proceeds FUND TOTALS $9,204 $87,968 $236,894 $87,767 $82,700 Account 321 47000 01 317.00 321 47000 01 319.00 321 47000 01 601.00 321 47000 01 611.00 321 47000 01 621.00 321 47000 01 710.00 EXPENDITURES Description General Fund Admin Fees Other Professional Services Bond Principal Bond Interest Bond Paying Agent Fees Transfers FUND TOTALS 2009 2007 2008 Adopted Actual Actual Budget 2010 Proposed Budget Comments 2009 2010 2006 2007 2008 Adopted Proposed Comments Actual Actual Actual Budget Budget $0 so $0 $0 0 0 0 0 0 0 70,000 70,000 75,000 O 16,062 12,473 9,900 7,200 O 431 431 500 500 O 0 0 0 0 $0 $16,493 $82,904 $80,400 $82,700 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 326 G.O. IMPROVEMENT BONDS, 2006B REVENUES September 1, 2009 Account Description 326 31010.00 Current Ad Valorem Taxes $0 $0 $0 326 36101.00 Principal Special Assessments 4,000 584,237 323,038 0 0 326 36102.00 Penalties Interest S/A 0 0 853 0 326 36210.00 Interest Earnings Investments 0 8,497 15,672 0 0 326 36215.00 Interest Eamings 63 84 354 0 0 326 36265.00 Use of Reserve Funds 0 0 0 375,600 358,600 0 0 0 0 326 37145.00 Surcharge on Water Revenues 0 0 0 0 0 326 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 326 39202.00 Contribution From Enterprises 0 0 0 0 0 326 39203.00 Transfer From 326 39204.00 Transfer From Water Core 0 200,000 200,000 200,000 200,000 326 39205.00 Transfer From Sewer Core 0 0 0 0 0 326 39206.00 Transfer From Storm Core 0 0 0 0 0 326 39208.00 Transfer From Street CIP 0 0 0 0 0 326 39310.00 Bond Proceeds 117,467 0 0 0 0 Account 326 47000 01 317.00 326 47000 01 319.00 326 47000 01 601.00 326 47000 01 611.00 326 47000 01 621.00 326 47000 01 710.00 FUND TOTALS EXPENDITURES Description General Fund Admin Fees Other Professional Services Bond Principal Bond Interest Bond Paying Agent Fees Transfers FUND TOTALS 2009 2010 2006 2007 2008 Adopted Proposed Actual Actual Actual Budget Budget $121,530 $792,817 $539,917 $575,600 $558,600 2006 2007 Actual Actual 2009 2010 2008 Adopted Proposed Actual Budget Budget Comments Comments $0 $0 $0 $0 $0 O 0 0 0 0 O 0 440,000 425,000 425,000 O 205,567 167,400 150,100 133,100 O 431 431 500 500 O 0 0 0 $0 $205,998 $607,831 $575,600 $558,600 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 611 G.O. WATER REVENUE BONDS, 2007A REVENUES September 1, 2009 2009 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget 611 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 611 36101.00 Principal Special Assessments 0 0 0 0 0 611 36102.00 Penalties Interest S/A 0 0 1,360 0 0 611 36210.00 Interest Earnings Investments 0 2,033 50 0 0 611 36215.00 Interest Earnings 0 0 0 0 0 611 36265.00 Use of Reserve Funds 0 0 0 0 0 611 37145.00 Surcharge on Water Revenues 0 0 0 0 0 611 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 611 39202.00 Contribution From Enterprises 0 0 0 0 0 611 39203.00 Transfer From 0 0 40,000 133,000 150,000 611 39204.00 Transfer From Water Core 0 0 0 0 0 611 39205.00 Transfer From Sewer Core 0 0 0 0 0 611 39206.00 Transfer From Storm Core 0 0 0 0 0 611 39207.00 Transfer From Port Authority 0 0 0 0 0 611 39310.00 Bond Proceeds FUND TOTALS $0 $2,033 $41,409 $133,000 $150,000 EXPENDITURES Comments 2009 2010 2006 2007 2008 Adopted Proposed Comments Account Description Actual Actual Actual Budget Budget 611 47000 01 317.00 General Fund Admin Fees $0 0 0 611 47000 01 319.00 Other Professional Services 0 0 611 47000 01 601.00 Bond Principal 0 0 0 85,000 105,000 611 47000 01 611.00 Bond Interest 0 11,535 47,082 46,700 42,900 611 47000 01 614.00 Amortization of Bond Discount 0 2,5 7 4 500 500 611 47000 01 621.00 Bond Paying Agent Fees 611 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $0 $11,786 $48,718 $133,000 $149,200 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 322 G.O. EQUIPMENT CERTIFICATES, 2007B REVENUES September 1, 2009 2009 2006 2007 2008 Adopted Account Description Actual Actual Actual Budget 322 31010.00 Current Ad Valorem Taxes 322 36101.00 Principal Special Assessments 322 36102.00 Penalties Interest S/A 322 36210.00 Interest Eamings Investments 322 36215.00 Interest Earnings 322 36265.00 Use of Reserve Funds 322 37145.00 Surcharge on Water Revenues 322 37160.00 Penalties Surcharge Revenues 322 39202.00 Contribution From Enterprises 322 39203.00 Transfer From 322 39204.00 Transfer From Water Core 322 39205.00 Transfer From Sewer Core 322 39206.00 Transfer From Storm Core 322 39207.00 Transfer From Port Authority 322 39310.00 Bond Proceeds Account 322 47000 01 317.00 322 47000 01 319.00 322 47000 01 601.00 322 47000 01 611.00 322 47000 01 621.00 322 47000 01 710.00 FUND TOTALS Description Bond Principal Bond Interest Bond Paying Agent Fees EXPENDITURES General Fund Admin Fees Other Professional Services Transfers FUND TOTALS 2010 Proposed Budget Comments $0 $0 $105,431 $102,908 $105,079 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 663 2 0 0 O 0 0 0 0 0 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 6,300 0 0 0 $0 $6,963 $105,451 $102,908 $105,079 2009 2010 2006 2007 2008 Adopted Proposed Actual Actual Actual Budget Budget Comments $0 $0 $0 $0 $0 O 0 0 0 0 O 0 0 80,000 85,000 O 0 12,526 14,400 11,600 0 1,800 431 500 500 O 0 0 0 0 $0 $1,800 $12,958 $94,900 $97,100 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 323 G.O. EQUIPMENT CERTIFICATES, 2008A REVENUES September 1, 2009 2009 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget 323 31010.00 Current Ad Valorem Taxes 323 36101.00 Principal Special Assessments 323 36102.00 Penalties Interest S/A 323 36210.00 Interest Earnings Investments 323 36215.00 Interest Earnings 323 36265.00 Use of Reserve Funds 323 37145.00 Surcharge on Water Revenues 323 37160.00 Penalties Surcharge Revenues 323 39202.00 Contribution From Enterprises 323 39203.00 Transfer From 323 39204.00 Transfer From Water Core 323 39205.00 Transfer From Sewer Core 323 39206.00 Transfer From Storm Core 323 39207.00 Transfer From Port Authority 323 39310.00 Bond Proceeds Account 323 47000 01 317.00 323 47000 01 319.00 323 47000 01 601.00 323 47000 01 611.00 323 47000 01 621.00 323 47000 01 710.00 FUND TOTALS EXPENDITURES 2009 2010 2006 2007 2008 Adopted Proposed Comments Description Actual Actual Actual Budget Budget General Fund Admin Fees Other Professional Services Bond Principal Bond Interest Bond Paying Agent Fees Transfers FUND TOTALS Comments $0 $0 $0 $88,457 $92,157 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 $0 $0 $0 $88,457 $92,157 $0 $0 $0 $0 $0 0 0 0 0 0 0 0 0 0 $0 O 0 0 65,000 O 0 11,600 14,100 0 0 900 900 $0 $0 $12,500 $80,000 Page One 2010 BUDGET WORKSHEETS DEBT SERV FUND 381 G.O. TAXABLE TIF 2008A G.O. TIF 20088 REVENUES- September 1, 2009 2008 2010 2006 2007 2008 Adopted Proposed Account Description Actual Actual Actual Budget Budget 381 31010.00 Current Ad Valorem Taxes $0 $0 0 277,700 0 $0 $0 $0 381 31050.00 Tax Increments 0 0 0 0 0 0 381 36101.00 Principal Special Assessments 0 0 0 0 0 381 36102.00 Penalties Interest S/A 0 0 0 0 0 381 36210.00 Interest Earnings Investments 0 0 0 0 0 381 36215.00 Interest Eamings 0 0 1 0 0 381 36265.00 Use of Reserve Funds 0 0 0 0 0 381 37145.00 Surcharge on Water Revenues 0 0 0 0 0 381 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 381 39202.00 Contribution From Enterprises 0 0 86,000 0 0 381 39203.00 Transfer From 0 0 0 0 0 381 39204.00 Transfer From Water Core 0 0 0 0 0 381 39205.00 Transfer From Sewer Core 0 0 0 0 0 381 39206.00 Transfer From Storm Core 0 0 0 0 277,700 381 39207.00 Transfer From Port Authority 0 0 0 0 0 381 39310.00 Bond Proceeds $0 $0 $86,001 $277,700 $277,700 FUND TOTALS EXPENDITURES 2009 2010 2006 2007 2008 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 381 47000 01 317.00 General Fund Admin Fees $0 $0 $0 0 3 81 47000 01 319.00 Other Professional Services 381 47000 01 601.00 Bond Principal 0 0 0 0 0 381 47000 01 611.00 Bond Interest 0 0 85,296 276,700 276,700 381 47000 01 621.00 Bond Paying Agent Fees 0 0 0 1,000 1,000 381 47000 01 710.00 Transfers 0 0 0 0 0 $0 $0 $85,296 $277,700 $277,700 FUND TOTALS Comments 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 four water towers and eight wells. The newest well (Well #15) went online in the spring of 2009. This fund covers the operation of over 1,200 fire hydrants, 1,400 gate valves and 119 miles of watermain. Page One 2010 BUDGET WORKSHEET WATER UTILITY REVENUES- July 13, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 601 33425.00 Other State Grants Aids $0 $0 $0 $0 0 5% of 5% Fees -Const Projects 601 34108.00 Administrative Fees -Other Funds 11,051 5,693 5,378 3,000 0 601 34109.00 Other Gen'I Govt Chgs for Services 0 0 2,500 0 601 36101.00 Principal Special Assessments 96,261 32,075 45,448 30,000 0 30,000 0 601 36102.00 Penalties Interest SIA 1,966 2,409 (28) 80,000 601 36210.00 Interest Eamings Investments 101,383 129,301 88,409 100,000 0 Annual Market Value Changes 601 36214.00 Net Change in FV- Investments (2,305) 15,790 7,341 0 601 36215.00 Rents 386 216 554 200 200 Eamings 50,000 Antenna Leases 601 36220.00 Rents Royalties 81,473 47,705 49,709 50,000 0 601 36260.00 Other Revenues 0 0 0 0 0 0 0 0 0 601 36265.00 Use of Reserve Funds 50,000 601 37110.00 Residential Water Revenues 857,057 902,174 907,400 825,000 1 0 55 000 601 37120.00 Apartment Water Revenues 92,229 68,187 68,576 65,000 30,000 601 37125.00 Institutional Water Revenues 29,207 33,006 45,900 30,000 60,000 601 37130.00 Commercial Water Revenues 58,007 63,450 55,094 60,000 37,000 601 37140.00 Industrial Water Revenues 31,011 30,214 54,720 30,000 7,000 601 37160.00 Penalties Water Revenues 10,971 9,080 9,652 7,000 0 6 37165.00 Meter Maint Water Revenues 0 0 0 0 0 601 37170.00 Other Water Revenues 40,000 601 37180.00 Water Meter Sales Revenue 85,230 65,604 56,669 50,000 0 6 39103.00 Gain or Loss from F/A Disposal 0 0 0 0 0 601 39203.00 Transfer From FUND TOTALS $1,453,927 $1,404,903 $1,397,321 $1,250,200 $1,449,200 Page One July 13, 2009 Account 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 xx 101.00 Salary Benefrt Contingency 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 303.00 601 49400 01 303.01 601 49400 01 303.02 601 49400 01 303.03 601 49400 01 303.04 601 49400 01 304.00 601 49400 01 310.00 601 49400 01 310.01 601 49400 01 310.02 601 49400 01 310.03 601 49400 01 312.00 601 49400 01 313.00 601 49400 01 315.00 601 49400 01 315.01 601 49400 01 315.02 601 49400 01 315.03 601 49400 01 315.04 601 49400 01 318.00 601 49400 01 319.00 601 49400 01 319.01 601 49400 01 319.02 601 49400 01 319.03 601 49400 01 319.04 601 49400 01 319.05 601 49400 06 319.06 601 49400 01 321.00 601 49400 01 322.00 601 49400 01 323.00 601 49400 01 331.00 601 49400 01 333.00 601 49400 01 341.00 601 49400 01 349.00 2010 BUDGET WORKSHEET WATER UTILITY EXPENDITURES Engineering Fees Water Conserv'n Emergency GIS Update of Asbuiks Rate Study Miscellaneous Fees Legal Fees Testing Services Bacteria Water Quality V.O.C., Pesticides, etc. CU -PB Testing Gopher State One -Call Temporary Service Fees Special Programs Public Information Plan Amendments Seminars Vulnerability Assessment Imp. Contract Engineer Other Professional Services Thaw Pipes, Check Leaks, etc. Supervisory Controls Hazardous Chemical Permits Annual Drinking Water Report Hazardous Chemical Inventory Contracted Hydrant Painting Telephone Costs Postage Costs Radio Units Travel Expense Freight Express Expenses Employment Advertising Other Advertising PAGE TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $410,200 Salary, Taxes, PERA Benefits 103,612 108,458 100,662 109,500 108,300 132,293 143,055 150,848 164,400 164,700 126,546 125,239 127,752 140,700 137,200 O 0 0 0 10,700 4,701 10,405 6,825 10,000 7,500 20,251 28,523 6,758 9,000 8,000 1,000 50% 601; 50% 602 7,000 100% 601 1,903 1,988 1,742 2,500 2,000 Inserts Water Bill Statements 328 142 280 200 200 Disks, Ribbons, etc. 36,349 43,422 64,796 55,000 90,000 Chorine, Flouride, Polyphos O 0 231 200 200 Maintenance Supplies 40,000 Meters, MIU's CU Homs 7,960 7,693 19,081 0 0 77,055 80,268 61,712 130,000 40,000 1,905 2,811 2,534 2,000 2,500 Patching for Breaks 491 0 0 500 500 Topsoil, Seed Sod 895 1,916 130 0 0 196 0 0 300 300 Miscellaneous Meter Parts 14,000 10,710 1,355 4,422 4,000 5,500 2,091 138 510 1,300 1,300 1,078 0 0 2,200 2,200 2,983 1,941 3,225 5,000 5,000 1,686 963 1,263 2,000 2,000 Wrenches, Shovels, etc. 3,000 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 Materials 601 49400 01 225.00 Landscaping Materials 601 49400 01 227.00 Utility System Maintenance Suppliie: 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 920 487 2,811 3,000 3,000 601 49400 01 242.02 402 0 0 0 0 19,000 1,346 23,523 2,132 0 0 O 0 10,257 7,000 7,000 O 3,348 162 0 0 1,177 13,553 12,317 12,000 12,000 O 63 769 1,000 1,000 43,000 1,560 1,873 1,960 2,000 2,000 Radon, Tri-ChL O 0 0 1,000 1,000 32,976 37,284 37,831 40,000 40,000 $6.36 /Connection Annual Fee (M) 3,985 3,269 3,500 7,000 3,500 Gopher State One -Call (M) 4,085 1,021 0 0 0 11,500 O 0 0 5,500 5,500 Wellhead Protection Plan O 0 0 5,000 5,000 Wellhead Protection Plan O 0 0 1,000 1,000 Wellhead Protection Plan O 3,656 0 0 0 13,413 3,000 6,000 9,000 6,000 Contracted Engineer for City(20%) 21,100 12,549 6,022 3,557 1,500 1,500 343 0 11,522 3,000 5,000 O 0 1,000 500 1,000 MN Department of Public Safety O 0 2,271 2,500 2,500 O 0 1,100 600 1,100 O 0 6,936 7,000 10,000 175 Hydrants per Year 1,181 1,529 3,013 2,000 2,200 Cell Phones, Modesm, GPS 4,918 5,428 3,975 6,000 6,000 Billings with Inserts 873 1,422 150 1,000 1,300 800 MHZ Monthly Charges 10 0 0 1,000 0 AWWA National Seminar O 38 0 100 100 Mail-in Repairs O 0 0 700 0 Pliers Personnel Changes O 0 0 500 500 612,768 663,831 664,034 758,700 706,300 Page Two July 13, 2009 Account 601 49400 01 403.00 601 49400 01 416.00 601 49400 01 433.00 601 49400 01 435.00 601 49400 01 437.00 601 49400 01 437.01 601 49400 01 437.02 601 49400 01 439.00 601 49400 01 521.00 601 49400 01 530.00 601 49400 01 530.01 601 49400 01 530.02 601 49400 01 530.03 601 49400 01 530.04 601 49400 01 530.05 601 49400 01 530.06 601 49400 01 530.07 601 49400 01 560.00 601 49400 01 570.00 601 49400 01 586.00 601 49403 01 221.00 601 49403 01 223.00 601 49403 01 319.00 601 49403 01 321.00 601 49403 01 381.00 601 49403 01 383.00 601 49403 01 409.00 601 49403 01 439.00 2010 BUDGET WORKSHEET WATER UTILITY EXPENDITURES- Description 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.00 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 Contracted R M Other Impr Machinery Rental Dues Subscriptions Books Pamphlets Conferences Seminars MN Health Department School AWWA Conference Other Miscellaneous Charges Building Structure Purchases Improvements Other Than Bidgs Well Inspections Recondition Miscellaneous Improvements CRP of Watermain Water Tower Inspection Furniture Fixture Purchases Office Equipment Purchases Computer Equipment Purchases 601 49400 01 611.00 Interest on Lease Payments 601 49400 01 710.00 Transfers 601- 49400-01 TOTALS Equipment Parts Building Repair Supplies Other Professional Services Telephone Costs Electric Utilities Gas Utilities Other Contracted Repairs Maint 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 801 49406 01 381.00 Electric Utilities 601 49406 01 383.00 Gas Utilities TOTAL EAST SIDE W/M VAULT 601 49407 01 221.00 Equipment Parts 601 49407 01 223.00 Building Repair Supplies 601 49407 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.00 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 2008 Actual Actual Actual 0 5,153 20,813 338 248 3,423 2,663 0 2,200 0 363 0 106 573 13,024 O 0 0 10,000 10,000 Pymt on P.W. Building (12 of 20) 160,000 13,932 23,939 18,422 25,000 0 None Scheduled in 2010 28 10,118 0 10,000 10,000 3,036 0 0 150,000 150,000 Annual Pavement Management O 14,435 0 3,000 0 None Scheduled in 2010 18,149 0 0 0 0 O 16,851 0 0 0 O 21,928 0 0 0 1,362 0 0 0 0 1,181 233 0 1,000 1,000 O 0 0 0 0 4,696 4,432 4,153 704,057 1,138,853 734,442 1,018,500 1,549 1,659 0 18 2,562 839 0 0 3,608 0 0 211 18,100 0 0 0 0 0 5,514 21,446 2,178 0 101 1,215 0 7,427 0 1,205 0 944 0 13,023 O 330,035 666 0 0 18 328 939 0 0 0 5,612 19,794 2,431 171 985 2,500 0 0 0 1,712 61 957 0 13,609 0 500 4,500 20,000 1,000 200 4,000 5,000 500 3,000 4,000 1,300 300 0 0 43,862 0 O 0 O 0 O 0 387 0 626 2,000 O 0 O 100 6,627 1,950 44,874 2,100 185 0 0 500 O 0 0 500 O 0 0 1,000 O 0 0 0 1,246 1,164 1,245 1,000 O 0 0 0 1,431 1,164 1,245 3,000 1,515 7,550 0 211 18,242 0 0 0 0 7,782 0 0 211 21,819 0 0 0 0 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget 900 1,000 600 1,200 15,000 1,200 300 500 0 18,000 0 600 100 0 21,918 27,518 29,812 20,700 Comments 500 Newsletters 6,000 Water's Share of Premiums 20,000 Water's Share of Premiums 3,000 Auto Read Software Support 200 13,000 Laptops (Split) 2 New Readers 6,000 Cartegraph ESRI Maintenance 500 6,000 Watermain Breaks 2,000 300 Suburban Utility Supt. Assn. 300 Reference Materials 2,200 Water School, 50% Split w/ 602 (M) (Part Moved from 433.00) 15,000 DNR Annual Water Use (M) 952,300 O P.W. Building Expansion(See 521) O Transfers for Other Improvements 0 500 500 1,000 0 1,000 Pumping Lighting 0 Heat Only 3,000 1,200 300 500 Independent Inspections 0 22,000 Pumping Lighting 0 600 RTU's, Pump Motor, etc. 100 Contingencies 10,000 A/C Temp Humidity Controls 34,700 O Cap Well O Cap Well O Cap Well O Cap Well O Cap Well 0 0 0 Page Three July 13, 2009 Account Description Actual Actual Actual Budget Amount Budget 601 49411 01 221.00 Equipment Parts 601 49411 01 381.00 Electric Utilities 2010 BUDGET WORKSHEET WATER UTILITY EXPENDITURES 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed TOTAL WELL #10 15,868 44,656 16,103 13,000 13,000 TOTAL WELL #11 TOTAL WELL #15 6,045 46,727 590 0 0 0 0 14,114 32,200 34,000 Comments 601 49408 01 221.00 Equipment Parts 6,817 1,883 3,513 1,500 1,500 601 49408 01 223.00 Building Repair Supplies 550 0 0 500 500 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 601 49408 01 321.00 Telephone Costs 18 0 0 0 0 601 49408 01 381.00 Electric Utilities 16,230 10,066 11,269 18,000 18,000 Pumping Lighting 601 49408 01 383.00 Gas Utilities 620 703 741 600 600 Heat Only 601 49408 01 530.00 Improvements Other Than Bldgs 0 0 0 0 10,000 A/C Temp Humidity Controls TOTAL WELL #8 24,235 12,652 15,523 20,600 30,600 601 49409 01 221.00 Equipment Parts 4,296 1,765 2,021 1,500 1,500 601 49409 01 223.00 Building Repair Supplies 0 0 0 100 100 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 601 49409 01 321.00 Telephone Costs 18 0 0 0 0 601 49409 01 381.00 Electric Utilities 33,779 30,690 23,975 35,000 35,000 Pumping Lighting 601 49409 01 383.00 Gas Utilities 647 1,007 971 1,500 1,500 Heat Only 601 49409 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49409 01 530.00 Improvements Other Than Bldgs 0 0 0 0 10,000 A/C Temp Humility Controls TOTAL WELL #9 38,739 33,462 26,967 38,200 48,200 601 49410 01 219.00 Other Operating Supplies 0 0 0 500 500 601 49410 01 221.00 Equipment Parts 6,768 34,078 990 500 500 601 49410 01 223.00 Building Repair Supplies 0 0 0 100 100 601 49410 01 321.00 Telephone Costs 742 723 722 0 0 601 49410 01 381.00 Electric Utilities 8,358 9,855 14,391 9,000 9,000 Pumping Lighting 601 49410 01 409.00 Other Contracted Repairs Maint 0 0 0 2,900 2,900 6,045 46,727 590 0 0 0 0 0 0 0 Pumping Lighting 601 49412 01 221.00 Equipment Parts 2,023 4,810 1,186 1,000 1,000 601 49412 01 223.00 Building Repair Supplies 41 0 0 500 500 601 49412 01 319.00 Other Professional Services 0 250 7,989 0 0 601 49412 01 321.00 Telephone Costs 0 0 0 0 0 601 49412 01 381.00 Electric Utilities 28,254 28,012 24,122 30,000 30,000 Pumping Lighting 601 49412 01 383.00 Gas Utilities 0 0 0 1,500 1,500 Heat Only 601 49412 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL WELL #12 30,318 33,072 33,297 33,100 33,100 601 49414 01 221.00 Equipment Parts 0 285 599 500 500 601 49414 01 223.00 Building Repair Supplies 0 0 0 100 100 601 49414 01 319.00 Other Professional Services 0 495 908 1,000 1,000 601 49414 01 321.00 Telephone Costs 0 0 0 0 0 601 49414 01 381.00 Electric Utilities 1,415 26,704 32,645 30,000 30,000 Pumping Lighting 601 49414 01 383.00 Gas Utilities 0 0 0 1,000 1,000 Heat Only 601 49414 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49414 01 530.00 Improvements Other Than Bldgs 0 0 0 0 1,800 Humidifier TOTAL WELL #14 1,415 27,484 34,151 32,700 34,500 601 49425 01 221.00 Equipment Parts 0 0 0 500 500 601 49425 01 223.00 Building Repair Supplies 0 0 0 100 100 601 49425 01 319.00 Other Professional Services 0 0 11,960 500 500 601 49425 01 321.00 Telephone Costs 0 0 2,154 0 0 601 49425 01 381.00 Electric Utilities 0 0 0 30,000 30,000 Pumping Lighting 601 49425 01 383.00 Gas Utilities 0 0 0 1,000 1,000 Heat Only 601 49425 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49425 01 530.00 Improvements Other Than Bldgs 0 0 0 0 1,800 Humidifier Page Four July 13, 2009 Account Description 2010 BUDGET WORKSHEET WATER UTILITY EXPENDITURES 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 676 211 500 500 Touch -up Paint 601 49415 01 221.00 Equipment Parts 769 0 0 Tower Inspection 601 49415 01 319.00 Other Professional Services 5,500 0 0 0 0 601 49415 01 381.00 Electric Utilities 0 500 500 601 49415 01 409.00 Other Contracted Repairs Maint 957 0 200 200 Contingencies 601 49415 01 439.00 Other Miscellaneous Charges 120 0 0 5,200 Mixer 601 49415 01 530.00 Improvements Other Than Bldgs 0 0 0 0 TOTAL -WATER TOWER #1 7,346 676 211 1,200 6,200 (Chippendale Water Tower) 785 0 394 500 500 Touch -up Paint 601 49416 01 3 .00 Other Professional ss o 0 730 0 0 0 Tower Inspection s 601 49416 01 319.00 Other Professional Services 0 0 0 0 601 49416 01 321.00 Telephone Costs 18 1,400 601 49416 01 381.00 Electric Utilities 1,395 1,604 933 1,400 500 601 49418 01 409.00 Other Contracted Repairs Maint 0 2,542 0 500 200 Contingencies 601 49416 01 439.00 Other Miscellaneous Charges 0 56 0 200 5,000 Mixer 601 49416 01 530.00 Improvements Other Than Bldgs 0 552,579 0 0 TOTAL WATER TOWER #2 2,198 557,511 1,327 2,600 7,600 (Connemara Water Tower) 0 8,970 536 500 500 601 49417 01 31 21.00 9.00 Other Professional Parts essional 0 1,044 0 0 Tower Inspection 601 49417 01 31 Other Pfvices 0 0 2,984 0 0 601 49417 01 321.00 Telephone Costs 2,000 601 49417 01 381.00 Electric Utilities 331 2,019 0 2,000 500 601 49417 01 409.00 Other Contracted Repairs Maint 0 0 0 500 601 49417 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 0 0 0 300 300 Contingencies 601 49417 01 530.00 Improvements Other Than Bldgs TOTAL WATER TOWER #4 331 10,989 4,564 3,500 3,500 (Bacardi Water Tower) 9 0 3,548 500 500 601 49418 01 221.00 Equipment Parts 979 0 0 0 0 Tower Inspection 601 49418 01 319.00 Other Professional Services 132 0 0 0 0 601 49418 01 321.00 Telephone Costs 2,000 000 601 49418 01 381.00 Electric Utilities 1,953 1,750 1,756 2,000 500 601 49418 01 409.00 Other Contracted Repairs Maint 0 0 1,922 500 0 0 0 200 200 Contingencies 601 49418 01 439.00 Other Miscellaneous Charges 0 0 0 300 150,000 Interior Painting 601 49418 01 530.00 Improvements Other Than Bldgs TOTAL WATER TOWER #3 3,064 1,750 7,226 3,500 153,200 (East Side Water Tower) GRAND TOTAL ALL DEPTS. $863,591 $1,938,465 $964,445 $1,224,900 $1,353,900 SEWER OPERATING FUND This is an Enterprise Fund consisting of revenues from sewer charges which provides for the operation and maintenance of 9 lift stations, 90 miles of sanitary sewer lines and over 6,000 service connections for the collection and treatment of sewage. $850,000 covers one line item of the Sewer Fund budget for the charges paid to the Metropolitan Council for the City's share of the operations and debt for wastewater treatment plants within the metropolitan area. These charges, which make up approximately 54% of the Sewer Fund budget, are based on sewage flows into the Metropolitan Council's Rosemount and Empire treatment plants. PERFORMANCE MEASURES of Sanitary Sewer System Cleaned 2004 2�5_ 2006 2007 2008 2009 n/a n/a 26.4% 22.0% 31.2% 33.0% n/a Information Not Available Page One July 13, 2009 Account Description 2010 BUDGET WORKSHEETS SEWER UTILITY REVENUES 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 5 00 602 33425.00 Other State Grants Aids $0 $0 $0 $0 0 5% of 5% Fees -Const Projects 602 34108.00 Administrative Fees -Other Funds 11,051 5,693 5,378 3,000 602 36101.00 Principal Special Assessments 54,093 57,251 65,559 50,000 50,000 602 36102.00 Penalties Interest S/A 3,021 2,318 771 0 90,000 602 36210.00 Interest Eamings Investments 106,066 102,710 94,216 90,000 0 Annual Market Value Changes 602 36214.00 Net Change in FV- Investments (5,812) 35,821 5,640 0 400 602 38215.00 Interest Eamings 297 288 840 400 0 602 36260.00 Other Revenues 0 0 0 0 0 0 0 95,000 26,900 602 36265.00 Use of Reserve Funds 1,226,900 602 37210.00 Residential Sewer Revenues 1,134,471 1,169,455 1,122,524 1,100,000 90,000 602 37220.00 Apartment Sewer Revenues 63,806 81,053 87,525 70,000 25,000 602 37225.00 Institutional Sewer Revenues 22,879 22,291 22,669 25,000 55,000 602 37230.00 Commercial Sewer Revenues 54,448 55,087 53,466 55,000 5,000 602 37240.00 Industrial Sewer Revenues 5,434 4,143 29,574 4,000 5 30,000 602 37260.00 Penalties Sewer Revenues 14,941 11,288 12 10,000 0 602 39103.00 Gain or Loss from F/A Disposal 0 0 0 0 0 0 39203.00 Transfer From FUND TOTALS $1,464,696 $1,549,898 $1,500,905 $1,502,400 $1,647,300 Page One July 13, 2009 A 602 49450 101.00 602 49450 77 101.00 602 49450 78 101.00 602 49450 79 101.00 602 49450 xx 101.00 602 49450 102.00 602 49450 103.00 602 49450 99 103.01 602 49450 99 103.02 602 49450 01 203.00 602 49450 01 209.00 602 49450 01 216.00 602 49450 01 219.00 602 49450 01 224.00 602 49450 01 225.00 602 49450 01 227.00 602 49450 01 241.00 602 49450 01 242.00 602 49450 01 303.00 602 49450 01 303.01 602 49450 01 303.02 602 49450 01 303.03 602 49450 01 303.04 602 49450 01 304.00 602 49450 01 312.00 602 49450 01 313.00 602 49450 01 318.00 602 49450 01 319.00 602 49450 01 319.01 602 49450 01 319.0 602 49450 01 319.0 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 602 49450 01 403.00 602 49450 01 415.00 602 49450 01 416.00 602 49450 01 433.00 602 49450 01 435.00 602 49450 01 437.00 602 49450 01 439.00 602 49450 01 521.00 602 49450 01 530.00 602 49450 01 530.01 602 49450 01 530.02 602 49450 01 530.03 602 49450 01 530.04 602 49450 01 530.05 602 49450 01 530.06 602 49450 01 530.07 602 49450 01 530.08 602 49450 01 540.00 602 49450 01 560.00 602 49450 01 570.00 602 49450 01 602.00 602 48450 01 611.00 602 49450 01 710.00 2010 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES Description Salaries Benefits Administrative Technical/Clerical Maintenance Salary Benefit Contingency Full-Time Overtime Part-Time Salaries Benefits Utility Commission Wages (50 Maintenance Labor Printed Forms Paper Other Office Supplies Chemicals Chemical Products Other Operating Supplies Street Maintenance Materials Landscaping Materials Utility System Maintenance Supplies Small Tools Minor Equipment Engineering Fees GIS Update of Asbuifts Rate Study 42/52 Sewer Study Miscellaneous Legal Fees Gopher State One -Call Temporary Service Fees Contract Engineer Other Professional Services Televising 2 Root Control 3 Supervisory Controls(Maint Cont) 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. Repass Contracted R M Other Impr Other Equipment Rental Machinery Rental Dues Subscriptions Books Pamphlets Conferences Seminars Other Miscellaneous Charges Building Structure Purchases Improvements Other Than Bldgs Miscellaneous Improvements Misc. Improvements /Repairs CRP of Sewermain Heavy Machinery Purchases Furniture Fixture Purchases Office Equipment Purchases Sewer Service Charges Interest on Lease Payments Transfers 602 49450 -01 TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Comments Actual Actual Actual Budget Amount Budget 103,611 108,457 100,622 109,500 108,300 132,293 143,055 150,848 164,400 164,700 126,545 125,239 127,753 140,700 137,200 10 700 0 0 0 4,701 10,405 6,825 10,000 7,500 24,842 20,410 9,758 9,000 1,000 50% 602; 50% 601 8,000 100% 602 1,500 Inserts Water Bill Statements 779 1,729 1,742 1,500 200 Disks, Ribbons, etc. 0 0 0 200 0 0 0 500 500 Root Killer, Degreaser 112 0 0 200 200 685 1 85 19 0 400 116 2,160 500 Patching 9 630 2,500 2, 400 Topsoil, Seed Sod 6 3,000 Manhole Castings 1,541 560 1,852 3,000 500 Wrenches, Shovels, etc. 179 843 452 500 3,000 2,428 6,697 2,935 3,000 22,000 0 17,983 0 0 85 3,985 4,085 9,000 0 0 196 0 1,181 3,684 846 0 0 0 0 5,138 11,899 337 0 3,423 2,663 0 2,200 0 0 23 0 23 115 0 0 4,538 2,277 0 4,851 0 0 0 (2,869) 0 500 672,585 4,697 162,061 1,674 15,158 10,319 0 0 3,269 1,021 3,000 0 0 532 0 1,530 3,673 1,422 0 0 0 0 5,499 11,319 2,026 0 0 1,215 0 3,713 0 0 96 0 833 145 0 5,059 0 0 14,435 0 7,273 16,851 21,928 0 0 0 721,350 4,432 252,815 7,245 0 9,974 1,786 0 3,500 0 6,000 1,890 73 7,436 0 3,013 3,975 150 0 0 0 0 5,612 10,595 2,340 171 985 2,500 0 0 0 0 100 0 962 145 434 0 0 0 0 0 0 0 0 0 0 785,283 4,153 0 7,000 0 0 5,000 500 7,000 0 9,000 3,000 2,000 3,000 0 1,500 3,500 500 200 100 300 500 5,000 15,000 1,000 200 4,000 5,000 500 2,000 200 2,000 100 300 1,000 100 p 10,000 10,000 0 150,000 0 0 0 0 0 0 500 500 775,000 0 0 7,000 0 0 15,000 3,000 2,000 5,000 0 10,000 0 150,000 0 0 0 0 0 500 4,000 Gopher State One -Call (M) 0 6,000 Contracted Engineer for Cfty(20 10,000 1,313,336 1,530,162 1,261,745 1,470,900 1,610,200 All Salary Costs Inclusive of $410,200 Salary, Taxes, PERA Benefits 2,000 200 2,000 100 300 1,000 100 Sewer Repairs SCADA System 2,200 CeN Phones, Modems, GPS 3,500 Billings with Inserts 1,300 800 MHZ Monthly Charges 200 Use 437.00 100 Mail -in Repairs 300 P/Ters Personnel Changes 500 6,000 Sewer's Share of Premiums 15,000 Sewer's Share of Premiums 3,000 Auto Read Software Support 200 3,000 Laptops (Split) 6,000 CarteGraph ESRI Maintenance 500 Suburban Util. Supt. Ass'n(50 Reference Materials Sewer School, 50% Split with 601 Contingencies 10,000 Pymt on P.W. Building (12 of 20) 160,000 Annual Pavement Management 0 500 500 900,000 MWCC Charges 0 P.W. Building Expanslon(See 521) 0 Transfers for Other Improvements Page Two July 13, 2009 Account 2010 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES Description 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 602 49451 01 219.00 Other Operating 0 0 100 100 Supplies 726 0 7,286 800 800 602 49451 01 221.00 Equipment Parts 0 0 0 200 200 602 49451 01 229.00 Other Maintenance Supplies 18 0 0 0 0 602 49451 01 321.00 Telephone Costs 1,500 602 49451 01 381.00 Electric Utilities 786 1,038 1,445 800 200 0 0 0 200 602 49451 01 403.00 Contracted R M Other Impr 0 0 0 100 100 Contingencies 602 49451 01 439.00 Other Miscellaneous Charges (City Hall) TOTAL LIFT STATION #1 1,888 1,038 8,731 2,200 2,900 0 0 0 100 100 602 49452 01 219.00 Other Operating Supplies 1,100 1,732 0 800 800 0 2 0 200 200 602 49452 01 221.00 Equipment Parts 602 49452 01 229.00 Other Maintenance Supplies 21 21 211 0 0 602 49452 01 321.00 Telephone Costs 500 602 49452 01 381.00 Electric Utilities 438 456 485 800 200 602 49452 01 403.00 Contracted R M Other Impr 0 0 0 200 0 0 0 100 100 Contingencies 602 49452 01 439.00 Other Miscellaneous Charges (Bloomfield 5th) TOTAL LIFT STATION #7 1,753 2,399 696 2,200 1,900 0 0 0 100 100 602 49453 01 219.00 Other Operating Supplies S,g40 240 8,330 800 800 602 49453 01 221.00 Equipment Parts 0 0 0 200 200 602 49453 01 229.00 Other Maintenance Supplies 10 0 0 0 0 602 49453 01 321.00 Telephone Costs 3,500 602 49453 01 381.00 Electric Utilities 3,495 2,804 3,052 5,000 200 0 0 0 200 602 49453 01 403.00 Contracted R M Other Impr 0 0 0 100 100 Contingencies 602 49453 01 439.00 Other Miscellaneous Charges (Shannon Pond) TOTAL LIFT STATION #3 9,453 3,044 11,382 6,400 4,900 0 0 0 100 100 602 49454 01 219.00 Other Operating Supplies 290 0 2,548 800 800 602 49454 01 221.00 Equipment Parts 0 0 0 200 200 602 49454 01 229.00 Other Maintenance Supplies 18 0 0 0 0 602 49454 01 321.00 Telephone Costs 4,000 602 49454 01 381.00 Electric Utilities 2,542 3,403 3,877 5,000 200 602 49454 01403.00 Contracted R M Other Impr 0 0 0 200 0 0 0 100 100 Contingencies 602 49454 01 439.00 Other Miscellaneous Charges (Hawkins) TOTAL LIFT STATION #4 2,852 3,403 6,425 6,400 5,400 0 0 0 100 100 602 49455 01 219.00 Other Operating Supplies 2,053 15,746 962 800 100 602 49455 01 221.00 Equipment Parts 0 0 0 200 200 602 49455 01 229.00 Other Maintenance Supplies 18 0 0 0 0 602 49455 01 321.00 Telephone Costs 6,000 602 49455 01 381.00 Electric Utilities 4,024 4,593 5,702 5,000 200 0 0 0 200 602 49455 01 403.00 Contracted R M Other Impr 0 0 0 100 100 Contingencies 602 49455 01 439.00 Other Miscellaneous Charges (LeForet Add'n) TOTAL -LIFT STATION #5 6,095 20,338 6,664 6,400 7,400 0 0 0 100 100 602 49456 01 219.00 Other Operating Supplies g 370 0 229 800 800 602 49456 01 221.00 Equipment Parts 200 602 49456 01 229.00 Other Maintenance Supplies 14 0 0 0 200 0 0 0 0 602 49456 01 321.00 Telephone Costs 7,500 602 49456 01 381.00 Electric Utilities 540 1,487 7,364 800 200 602 49456 01 403.00 Contracted R M Other Impr 0 0 0 200 0 0 0 100 100 Contingencies 602 49456 01 439.00 Other Miscellaneous Charges (Drumcl'rffe) TOTAL LIFT STATION #6 6,934 1,487 7,593 2,200 8,900 Page Three July 13, 2009 Account Description 2010 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Comments Actual Actual Actual Budget Amount Budget 0 0 0 100 100 602 49457 01 219.00 Other Operating Supplies 175 922 546 100 100 602 49457 01 221.00 Equipment Parts 0 0 0 200 200 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 0 0 602 49457 01 321.00 Telephone Costs 272 354 469 800 800 602 49457 01 381.00 Electric Utilities 0 0 0 200 800 602 49457 01 403.00 Contracted R M Other Impr 0 0 0 100 2 00 Contingencies 602 49457 01 439.00 Other Miscellaneous Charges (Glendabugh 5th) TOTAL LIFT STATION #9 447 1,276 1,015 1,900 1,900 0 0 p 100 100 939 356 211 602 49458 01 219.00 Other Operating Supplies `0 602 49458 01 221.00 Equipment Parts 0 0 1 500 500 200 200 602 49458 01 229.00 Other Maintenance Supplies 602 49458 01 321.00 Telephone Costs 800 602 49458 01 381.00 Electric Utilities 285 362 388 800 200 602 49458 01 403.00 Contracted R M Other Impr 0 0 0 200 0 0 0 100 100 Contingencies 602 49458 01 439.00 Other Miscellaneous Charges (Meadows of) TOTAL LIFT STATION #8 1,224 718 599 1,900 1,900 (Bloomfield) 0 0 0 100 100 0 1,062 211 602 49460 01 219.00 Other Operating Supplies 500 500 602 49460 01 221.00 Equipment Parts 0 0 1 P00 200 602 49460 01 229.00 Other Maintenance Supplies 0 602 49460 01 321.00 Telephone Costs 0 160 145 800 800 602 49460 01 381.00 Electric Utilities 00 602 49460 01 403.00 Contracted R M Other Impr 0 0 0 0 0 0 8 200 00 8 2 00 Contingencies 602 49460 01 439.00 Other Miscellaneous Charges (Glen Rose) TOTAL LIFT STATION #10 0 1,222 356 1,900 1,900 GRAND TOTAL ALL DEPTS. $1,343,983 $1,565,087 $1,305,205 $1,502,400 $1,647,300 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: 7 lift stations More than 3,000 catch basins 81 miles of storm sewer More than 65 storm water treatment ponds This fund pays for cleaning storm drain sumps in manholes and catch basins and for ditching in rural areas. It funds wetland investigations and the assimilation 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. PERFORMANCE MEASURES Number of Sumps Cleaned 20 4 2005 2006 2007 2008 2009 (Est.) n/a n/a 340 188 149 65 n/a Information Not Available Has been decreasing since 2006 due to new procedure of inspecting all and cleaning only if greater than 50% full. Page One 2010 BUDGET WORKSHEETS STORM WATER UTILITY REVENUES- July 13, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments $0 603 33425.00 Other State Grants Aids $0 $2,500 $0 $0 0 5% of 5% Fees Const Projects 603 34108.00 Administrative Fees -Other Funds 11,051 5,693 5,378 3,000 603 36101.00 Principal Special Assessments 15,777 12,617 17,405 10,000 10,000 0 0 722 386 278 80,000 Net Change 603 36102.00 Penalties Interest 0 Annual Market Value Changes 603 36210.00 Interest na ings st Investments 58,397 62,368 008 39,863 491 60,000 0 603 36214.00 Net C in FV- Investments 1 44 303 283 300 300 603 36215.00 Interest Eamings 344 0 2 000 0 0 603 36260.00 Other Revenues 0 0 0 0 603 36265.00 Use of Reserve Funds 0 775,000 603 37300.00 Storm Water Utility Revenues 665,905 731,323 745,805 700,000 4,000 7 4,027 4,159 4, O 0 603 37360.00 Penalties Storm Water Utility 6,157 0 0 603 39203.00 Transfer From FUND TOTALS $758,101 $828,226 $815,663 $777,300 $829,300 Page One July 13, 2009 Account 603 49500 01 226.00 603 49500 01 230.00 603 49500 01 241.00 603 49500 01 242.00 603 49500 01 403.00 603 49500 01 403.01 603 49500 01 403.02 603 49500 01 404.00 603 49500 01 416.00 603 49500 01 433.00 603 49500 01 435.00 603 49500 01 437.00 603 49500 01 437.01 603 49500 01 437.02 603 49500 01 437.03 603 49500 01 439.00 2010 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES Description 603 49500 101.00 Salaries Benefits 603 49500 77 101.00 Administrative 603 49500 78 101.00 Technical/Clerical 603 49500 79 101.00 Maintenance 603 49500 xx 101.00 Salary Benefit Contingency 603 49500 102.00 Full -Time Overtime 603 49500 99 103.00 Part-Time Salaries Benefits 603 49500 01 203.00 Printed Forms Paper 603 49500 01 204.00 Envelopes Letterhead 603 49500 01 205.00 Drafting Supplies 603 49500 01 208.00 Miscellaneous Supplies 603 49500 01 215.00 Shop Materials 603 49500 01 219.00 Other Operating Supplies 603 49500 01 221.00 Equipment Parts 603 49500 01 224.00 Street Maintenance Materials 603 49500 01 225.00 Landscaping Materials 603 49500 01 225.01 Rip -Rap, Matting, Rock, etc. 603 49500 01 225.02 Black Dirt, Seet, Sod, etc. 603 49500 01 225.03 Sign Repair Materials Equipment Repair Material Small Tools Minor Equipment 603 49500 01 303.00 Engineering Fees 603 49500 01 303.01 Problem Area Investigations 603 49500 01 303.02 NPDES Phase II 603 49500 01 303.03 CSMP Update 603 49500 01 303.04 Miscellaneous 603 49500 01 304.00 Legal Fees 603 49500 01 310.00 Testing Services 603 49500 01 312.00 Contract Inspection Fees 603 49500 01 313.00 Temporary Service Fees 603 49500 01 315.00 Special Programs (County Program) 603 49500 01 318.00 Contract Engineer 603 49500 01 319.00 Other Professional Services 603 49500 01 321.00 Telephone Costs 603 49500 01 322.00 Postage Costs 603 49500 01 323.00 Radlo 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.00 P.C. Maintenance 603 49500 01 393.00 P.C. Hardware Purchases 603 49500 01 394.00 P.C. Software Purchases Contracted R M Other Impr Ditching Miscellaneous Repairs Contracted Mach Equip Repairs Machinery Rental Dues Subscriptions Books Pamphlets Conferences Seminars Storm Water Management Hydrocad Training Wetlands Training 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 603 49500 01 530.03 603 49500 01 530.04 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 PAGE TOTALS 2006 2007 2008 Actual Actual Actual 0 77,793 63,273 0 2,526 0 779 0 0 0 0 0 0 536 0 0 0 0 134 581 0 31,486 27,441 0 0 0 0 0 2,723 3,850 9,000 844 0 3,684 503 0 0 2,019 6,349 0 0 337 3,423 2,663 0 36,496 0 0 976 13 25 0 0 115 2,277 0 0 0 0 21,438 0 0 0 0 85,070 62,620 0 5,372 0 1,729 0 0 0 0 0 0 2,292 2,174 11 0 0 236 152 0 96,644 55,281 63,466 459 6,094 0 0 681 3,850 3,000 0 0 3,673 339 0 0 2,162 6,029 0 0 2,026 0 1,215 0 151,306 0 401 976 0 42 0 0 145 0 7,273 14,435 16,851 0 0 0 0 0 87,908 63,876 0 3,602 0 1,742 0 0 0 0 0 0 3,798 4,940 5 0 223 959 920 255 69,780 22,097 2,318 26,464 0 0 0 0 3,850 6,000 0 0 3,975 150 0 0 2,232 5,660 0 0 2,340 1,145 0 0 26,217 0 0 140 0 875 0 0 145 2,603 0 0 0 0 0 0 0 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget 0 97,300 70,400 0 10,000 8,000 1,500 0 0 1,600 0 0 0 2,000 3,000 1,000 0 500 1,000 1,000 0 10,000 30,000 0 30,000 2,000 1,000 500 0 5,000 9,000 3,000 0 3,000 600 200 1,000 3,500 6,000 600 500 1,000 4,000 5,000 5,000 5,000 50,000 50,000 1,000 5,000 0 500 1,000 0 500 0 150,000 0 0 0 0 500 2,000 500 3,000 1,000 0 10,000 30,000 0 30,000 1,000 0 500 150,000 0 0 0 301,283 596,004 344,221 529,200 534,800 Comments All Salary Costs Inclusive of $166,000 Salary, Taxes, PERA Benefits 0 97,400 68,600 4,400 6,000 8,000 1,500 0 0 1,600 Stakes, Ribbons, Level, etc. 0 0 0 2,000 Blacktop Gravel Washouts 4,000 500 1,000 1,000 2,000 Misc. Nozzles for Vac Truck 70,000 2,000 1,000 500 0 5,000 6,000 5,000 2,200 5,000 1,300 200 1,000 3,500 6,000 600 500 3,000 3,000 6,000 Water Quality Tests (M) 3rd Part Inspection Program (M) Wetland Health Evaluation Proj Contracted Engineer for City(20 SCADA Cell Phones, Modems, GPS Billings Info Mailings 800 MHZ Monthly Charges Public Info Brochure Storm Waters Share of Premiums Storm Water's Share of Premiums Roadside Debris Hazardous Materials Disposal Auto Read Software Support Laptops (Split) CarteGraph ESRI Maintenance 55,000 Storm Maintenance Work 0 5,000 Pumps 0 500 Utility Information 1,500 0 150,000 MN Cities Stormwater Collaboration Annual Pavement Management 0 500 2,000 500 Page Two 2010 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES July 13, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 125,000 603 49500 01 710.00 Transfers Bonds Called 2/1/08 603 49500 01 710.01 1/2 of 2008 P I Payments(1996B) 50,000 52,000 83,000 0 0 603 49500 01 710.02 1/2 of 2008 P I Payments(1999C) 41,000 43,000 16,500 0 0 Bonds Called 2/1/08 603 49500 01 710.03 1/2 of 2008 P I Payments(2001B) 54,000 53,000 54,000 53,000 54,000 goods Palo off 2/1/08 603 49500 01 710.04 1/2 of 2008 P I Payments(2001D) 77,000 75,000 70,000 0 0 603 49500 01 710.05 1/2 of 2008 P I Payments(2002B) 29,000 29,000 28,000 28,000 29,000 Storm Share of Water /Storm Issue 603 49500 01 710.06 1/2 of 2008 P I Payments(2002C) 26,000 25,000 0 0 0 Bonds Defeased 3/1/07 603 49500 01 710.07 1/2 of 2008 P I Payments(2003A) 44,000 44,000 42,000 42,000 42,000 Storm Share of Connemara Proj. 603 49500 01 710.10 Projects 200,811 186,144 0 0 0 603 49500 -01 TOTALS 823,094 1,103,148 637,721 652,200 659,800 603 49511 01 221.00 Equipment Parts 185 0 211 500 500 603 49511 01 321.00 Telephone Costs 18 0 0 0 0 603 49511 01 381.00 Electric Utilities 193 224 206 500 500 (Copper Pond) TOTAL LIFT STATION #1 395 224 416 1,000 1,000 603 49512 01 221.00 Equipment Parts 360 0 211 500 500 603 49512 01 321.00 Telephone Costs 18 0 0 0 0 603 49512 01 381.00 Electric Utilities 0 0 0 500 500 (Schwarz Pond) TOTAL LIFT STATION #2 378 0 211 1,000 1,000 603 49513 01 221.00 Equipment Parts 418 1,362 211 500 500 603 49513 01 321.00 Telephone Costs 35 0 0 0 0 603 49513 01 381.00 Electric Utilities 2,211 2,968 3,352 5,000 3,500 (Birger Pond) TOTAL LIFT STATION #3 2,664 4,329 3,563 5,500 4,000 603 49514 01 221.00 Equipment Parts 185 0 1,651 500 500 603 49514 01 321.00 Telephone Costs 4 0 0 0 0 603 49514 01 381.00 Electric Utilities 135 372 1,964 3,500 2.000 (Marcotte Pond) TOTAL LIFT STATION #4 324 372 3,615 4,000 2,500 603 49515 01 221.00 Equipment Parts 98 0 211 500 500 603 49515 01 321.00 Telephone Costs 0 0 0 0 0 603 49515 01 381.00 Electric Utilities 0 0 0 500 500 (Hawkins Pond) TOTAL LIFT STATION #5 98 0 211 1,000 1,000 603 49516 01 221.00 Equipment Parts 22 0 211 500 500 603 49516 01 321.00 Telephone Costs 0 0 0 0 0 603 49516 01 381.00 Electric Utilities 0 245 219 500 500 (Glendalough 7th) TOTAL LIFT STATION #6 22 245 430 1,000 1,000 GRAND TOTAL ALL DEPTS. $826,974 $1,108,318 $646,166 $665,700 $670,300 ADMINISTRATION MAINTENANCE The Parks and Recreation Department administer the Ice Arena. Scheduling and invoicing of ice are the main administrative duties of ice arena operations. The scheduling of prime time ice is coordinated with Independent School District #196 and Rosemount Area Hockey Association for practices, games and tournament play. The Parks and Recreation Department provides overall planning, coordination, management of personnel and administration of ice arena activities. COMMUNITY USE Provides recreational open skating for the residents of Rosemount as well as learning to skate and figure skating programs. Provides ongoing and preventative maintenance of the ice arena building structure and its mechanical components Ensures ice is maintained at optimal efficiency. PERFORMANCE MEASURES 2004 2005 2006 2007 2008 n/a n/a 2,353 2,456 2,544 n/a Information Not Available ICE ARENA Number of Ice Arena Hours Utilized Page One 2010 BUDGET WORKSHEETS ARENA REVENUES September 1, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 650 36210.00 Interest Earnings Investments $0 $0 $0 $0 650 36215.00 Interest Eamings 3 0 47 100 100 650 36260.00 Other Revenue Learn to Skate 38,823 32,075 44,774 35,000 35,000 Learn to Skate Program (LTS) 650 36265.00 Use of Reserve Funds 0 0 0 0 0 650 38060.00 Prime Time Ice Fees 207,851 216,710 221,861 220,000 220,000 650 38061.00 Non -Prime Time Ice Fees 69,733 76,677 81,056 75,000 75,000 650 38063.00 Open Skating Ice Fees 9,599 9,864 8,917 9,000 9,000 650 38064.00 Broomball Revenues 0 5,761 8,220 0 0 Moved to Prime/Non -Prime Times 650 38065.00 Other Events Arena 0 0 0 0 0 Dry Floor Events 650 38066.00 Advertising Revenue Arena 4,820 13,500 7,700 10,000 10,000 650 38067.00 Skate Sharpening Revenue Arena 5,196 5,472 4,672 5,500 5,500 650 38090.00 Concessions 3,900 3,900 3,900 3,900 3,900 650 38091.00 Vending Machine Revenues 10,702 8,367 8,472 10,000 10,000 650 38095.00 Pro Shop Revenues 1,184 1,178 1,058 1,200 1,200 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 100,000 165,000 115,000 115,000 Subsidy for Operations FUND TOTALS 351,811 473,504 555,678 484,700 484,700 Page One September 1, 2009 2010 BUDGET WORKSHEETS ARENA EXPENDITURES All Salary Costs Inclusive of 650 45130 101.00 Salaries Benefits $132,300 Salary, Taxes, PERA Benefits 650 45130 77 101.00 Administrative 36,329 34,081 29,814 36,500 36,800 650 45130 78 101.00 Technical /Clerical 26,193 26,936 28,383 33,800 34,100 650 45130 79 101.00 Maintenance 91,489 96,916 89,495 60,600 61,400 650 45130 xx 101.00 Salary Benefit Contingency 0 0 0 0 3,700 650 45130 79 102.00 Full -Time Overtime 5,393 5,180 3,826 4,700 4,700 650 45130 103.00 Part-Time Salaries Benefits 47,000 650 45130 89 103.00 Leam -To -Skate Program 27,785 27,100 24,985 27,000 27,000 650 45130 99 103.00 Building Attendants 18,386 15,392 33,493 15,000 20,000 And Other PIT Positions 650 45130 01 207.00 Training Instructional Supplies 0 0 0 200 100 650 45130 01 208.00 Miscellaneous Supplies 700 650 45130 01 208.01 Skate Magnets 0 0 0 200 100 650 45130 01 208.02 Other Supplies 51 0 418 800 600 650 45130 01 209.00 Other Office Supplies 407 575 687 500 500 Learn to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 3,605 3,302 3,811 4,000 4,000 650 45130 01 212.00 Motor Fuels 2,400 0 0 2,400 0 Zamboni Maint. (Every 3rd Year) 650 45130 01 216.00 Chemicals Chemical Products 3,200 2,814 2,528 3,200 3,000 Assorted Products 650 45130 01 219.00 Other Operating Supplies 269 434 16 1,000 500 Events Supplies 650 45130 01 221.00 Equipment Parts 2,983 2,605 4,302 4,000 4,000 650 45130 01 223.00 Building Repair Supplies 2,544 1,444 1,952 4,000 3,000 650 45130 01 265.00 Other Items for Resale 544 515 600 600 600 Pro Shop Supplies 650 45130 01 305.00 Medical Dental Fees 0 0 0 500 0 650 45130 01 311.00 Officiating Fees 0 2,075 1,080 2,400 0 650 45130 01 317.00 General Fund Admin Fees 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Admin Fee Policy 650 45130 01 321.00 Telephone Costs 1,000 1,000 1,000 1,000 1,000 650 45130 01 331.00 Travel Expense 0 0 0 100 100 650 45130 01 341.00 Employment Advertising 0 0 0 500 0 650 45130 01 349.00 Other Advertising 98 210 284 800 400 650 45130 01 365.00 Workers Comp Insurance 2,488 2,691 2,994 2,500 3,200 650 45130 01 369.00 Other Insurance 7,789 7,746 7,772 8,000 8,000 650 45130 01 381.00 Electric Utilities 109,878 114,332 110,858 115,000 120,000 650 45130 01 383.00 Gas Utilities 31,488 34,232 37,862 50,000 45,000 650 45130 01 384.00 Refuse Disposal 2,962 3,455 3,613 3,500 3,500 650 45130 01 401.00 Contracted Building Repairs 4,359 13,014 3,096 5,000 5,000 650 45130 01 404.00 Contracted Mach Equip Repairs 15,482 11,028 16,101 15,000 15,000 650 45130 01 415.00 Other Equipment Rental 0 0 0 300 300 650 45130 01 433.00 Dues Subscriptions 450 475 350 900 500 MIAMA MRPA Dues 650 45130 01 437.00 Conferences Seminars 0 0 0 400 400 MIAMA Seminars 650 45130 01 439.00 Other Miscellaneous Charges 0 0 0 500 0 Contingencies 650 45130 01 521.00 Building Structure Purchases 0 0 64,921 0 0 650 45130 01 580.00 Other Equipment Purchases 0 0 2,822 0 42,000 New Compressors 650 45130 01 710.00 Transfers 3,500 650 45130 01 710.01 Yearly Maintenance 3,500 3,500 3,500 3,500 3,500 650 45130 01 710.02 0 0 0 0 0 650 45130 01 710.03 0 0 0 0 0 Account Description Actual Actual Actual Budget Amount Budget Comments FUND TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed 407,071 417,050 486,563 414,400 458,000