Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2.A. 2014 Budget Discussion
%D EXECUTIVE SUMMARY CITY COUNCIL City Council Work Session Meeting June 25, 2013 AGENDA ITEM: 2014 Budget Discussion SECTION: SNDA PREPARED BY: Dwight Johnson, City Administrator AGENDA NO. 3.A-, Jeff May, Finance Director ATTACHMENTS: Budget worksheets APPROVED BY: RECOMMENDED ACTION: Discussion Item EXECUTIVE SUMMARY The recommended budget for 2014 proposes an increase in the City's property tax levy of 1.41 %. This would result in an estimated annual increase of $12 in the City taxes assessed to a median value home. The estimated City tax on a median family home valued at $203,500 would be $872. A 3.76% increase in residential property values combined with the increased levy amount is responsible for the projected increase in 2014. Even with this increase, the City has reduced taxes on the median home by $186 since 2008. The proposed increase in levy is approximately equal to the growth of the City without any inflation included. The budget shows some increased costs for new facilities and athletic fields coming on line; increased costs to replace existing equipment, playgrounds, and parking lots; reduced costs for debt service; one new full-time employee in Police (mid -year 2014); and our best estimate of the costs of future employee wages and benefits for 2014 (including mandated insurance coverage for two additional employees). One notable change in expenditures is that the Legislature has approved a law to eliminate most sales tax payments to the State for goods. We are currently evaluating the amount of savings based on 2012 sales tax payments. A preliminary number of $140,000 in savings is being used for this draft budget. Looking at non -tax revenues, interest on investments is reduced due to current market conditions. Building permits for 2014 are estimated based on the average of the past three years. SKB host agreement funds designated for the General Fund are proposed to increase from $400,000 to $500,000, leaving an estimated $700,000 for planned capital building projects or trails. These items are discussed in more detail below. A summary of key characteristics of the proposed 2014 budget are shown in the following table: Budget Facts at a Glance Increase of property tax base from 2013 Average increase in residential values General fund spending change: Total funding change — all tax impacted funds Change in overall tax levy from 2009 City share of tax impact on median value home Percentage tax change on median value home Change in estimated tax rate (City share only) BUDGET PROCESS +4.12% +3.76% +3.00% +$273,828 - 864,842 +$12 +1.40% -3.02% (from .48862 to .47385) The annual budget process begins with the adoption of goals and work plans by the City Council early in the year. The City Council officially adopted goals for 2013 -2014 on February 19, 2013. This draft budget was initially developed by the Department Directors. We met with each Department Director and reviewed details of their budget with them. In addition, as a part of the budget review, we have looked again at 10 year needs projections for street improvements, equipment replacement, buildings and the Ice Arena. We have also reviewed our long term needs for major maintenance needs for parking lots, playgrounds, etc. 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 2012 and beyond. Our hope was to develop the most conservative budget possible that: (1) is consistent with council goals (2) is consistent with previous council direction on levels of service, (3) does not weaken the City's long range financial outlook. (4) is balanced not only between revenues and expenditures, but also is well balanced internally between personnel, equipment, technology, operating needs and capital expenditures. According to state law, the preliminary budget and levy must be adopted by September 15th and the final budget must be adopted by December 20th after a public hearing. GENERAL FACTORS AFFECTING THE BUDGET Tax Base For the first year since 2009, the overall tax base in the community has increased. The overall tax capacity value within the City is estimated to be 4.12% higher in 2014 than it was in 2013. The increase in market value of the median home in Rosemount is 3.76 %. State Budget and Legislative Impacts A significant legislative impact for local governments is the repeal of the general state sales tax for most local government expenditures. Although it will take many weeks of work to calculate in detail what we will save from this initiative, the draft budget assumes a savings of $140,000 in the General Fund. This means that the City's property tax levy would be 2.75% higher rather than the proposed 1.41% increase. 2 REVENUES Property taxes fund 79% of the General Fund budget. However, there are several other categories of General Fund revenues that are also important to the City. The chart below compares budgeted revenue for 2013 with estimated revenue in 2014 for several key categories of revenues. Licenses & Permits Intergovernmental Charges for Services (no SKB) Fines & Forfeits Recreational Revenues Miscellaneous Revenues SKB revenue (General Fund portion) 2013 Budget 2014 Estimated Change 382,300 438,300 +56,000 643,100 580,800 - 62,300 238,000 323,300 +85,300 125,000 125,000 -0- 263,200 253,600 -9,600 169,200 125,700 - 43,500 425,000 525,000 +100,000 Two of the most important non -tax revenues are building permit revenues and SKB fees. Building Permit Revenues Building permit revenues have varied from about $250,000 to $300,000 annually over the past three years. For 2014, we are estimating an amount equal to the average of the past three years, or $275,000. SKB Revenues The City approved a new agreement with SKB, inc. in 2008 that has increased our revenues from SKB's operations in Rosemount. The draft budget for 2014 designates $500,000 of SKB funds to support the operating budgets. This is an increase of $100,000 over the amount of the past several years. We estimate that seven hundred thousand dollars will be available for planned capital projects in 2014 to help fund council goals relating to a senior activity center and a possible partnership with DCTC and the Y for new indoor recreation facilities. The capital improvement budgets will be presented for review later this year. EXPENDITURES Salaries Rosemount currently has 75 authorized full time employees. This compares with 81 full time employees at the beginning of 2008. The draft budget would increase the number of full time employees on July 1, 2014 by adding a new Sergeant position in the Police Department. This position would help improve the management of our investigations unit, provide daytime supervision of patrol that is currently lacking, assist with stronger efforts in such areas as emergency planning for both the City and its neighborhoods and enhance our ability to use data for timely identification of crime and accident trends. The budget also shows a part -time staff member being added to the Parks and Recreation budget in mid - 2014 on the assumption that a new senior center may be nearing completion at that time. This position has been budgeted for several years, but has not been filled due to developer - related delays in building the senior center in conjunction with a major new senior housing project. Staff is still open to the possibility of contracting for the operation of some or all of the operation of the senior center. Finally, the budget shows some additional hours for a part -time employee in Finance to help address a disproportionate work load for the Accounting Supervisor, especially in the first half of the year. 3 All four bargaining unit contracts expire at the end of 2013 and there have been no negotiations for new contracts as of this date. A salary increase similar to amounts negotiated for 2013 has been assumed in the draft budget. Health Insurance While our Health Insurance Reserve funds will buffer us from any unpredictable spikes in premiums when our renewal rates are received in late August, we will need to accommodate new federal rules requiring that we offer insurance to all employees who average more than 30 hours per week. Currently, only full time employees receive City health insurance. Maintenance A significant factor in developing the 2014 budget is increased maintenance and repair of existing as well as new facilities. In various places throughout the budget, there are increases for future playground replacements, parking lot maintenance, additional maintenance for new athletic fields, operating costs for the new senior center and other maintenance increases. Together, these items total an increase of $167,000 in 2014, which is more than overall proposed levy increase. Capital Budgets The City currently has three capital improvement program (CIP) funds: Equipment, Streets, and Buildings. Staff has not yet done a detailed review of the CIP and plans to bring a proposed 10 year CIP to the Council later this year. A general review of the trends for the purpose of setting CIP levies for 2012 has been done. The levy for the Equipment CIP is proposed to be $490,000, an increase of $30,000 due to future forecasted needs. The Street CIP is proposed to have a levy of $740,000 for 2014, an increase of $10,000 to reflect the modest growth rate of the City and the current good ratings of the street system. The Building CIP has an ongoing levy of $24,000 for 2014 which is for the repayment of an internal loan for the current Public Works facility. The Building CIP fund is intended to fund the City's share of a planned senior housing /senior center redevelopment project north of the Steeple Center and also may provide some funds for a possible partnership on an indoor recreational facility on DCTC property. It will also fund some improvements and updates planned for the Community Center as well as certain park projects such as the splash pad. No tax levy above the current $24,000 is proposed. Future SKB funds along with proceeds from past General Fund surpluses will provide the funds for these projects. Enterprise Fund Budgets The City's Enterprise Funds include the Water Fund, Sewer Fund and Stormwater Fund. At this time, no significant work has been done on these budgets and they will be presented later this year since they do not affect the City's levy which must be determined by September 15`" Debt Service Funds The City ended 2012 with a General Fund surplus. The Council approved a strategy that committed some of the surplus to eliminating the need for a levy for the City's share of the National Guard's debt for the Armory. A debt levy of $86,000 has therefore been eliminated and this obligation is now permanently ended. CONCLUSION The City has reduced the tax burden on the median value home each of the last five years and proposes a modest increase of 1.40% this year due to additional maintenance and operating costs for new facilities 4 coming on line as well as general growth plus inflation. The State's elimination of sales tax for most City expenditures and the continued reductions in debt service levies help mitigate the property tax increase. We are pleased that we can present a reasonably modest budget and tax levy that keeps the City moving ahead on the building, operating and maintaining of many new facilities including a Senior Center, a splash pad, new ball fields at UMore Park, new athletic fields on the Flint Hills property, a new underpass under Highway 3, improvements to Erickson Park, a splash pad, senior exercise equipment, new tennis courts, new trail projects, improvements to both the Steeple Center and the Community Center, and various neighborhood amenities. 5 2014 CITY BUDGET REPORT !$ROSEMOUNT MINNESOTA June 25, 2013 Departments FUNDING REQUIREMENTS -USES (INCLUDING FIRE STATION LEVY) Council Budget Sales Tax Exemption Savings Administration Budget Elections Budget Finance Budget General Government Budget Community Development Budget Police Budget Fire Budget Public Works Operating Budgets: Government Buildings Budget Fleet Maintenance Budget Street Maintenance Budget Parks Maintenance Budget Park & Rec Budget - General Operating Park & Rec Budget - Steeple Ctr. Operations Park & Rec Budget - Senior / Activity Center Park & Rec Budget - Special Programs Transfers - Arena Assistance Total Operating Budgets - General Fund Building CIP Requirements Street CIP Requirements Equipment CIP Requirements Insurance Budget Requirements Port Authority Operating Levy Bonded Indebtedness Bonded Indebtedness - Fire Station Levy Armory Anticipatory Levy (Value 3/9/12) "$1,931,934,605 x .00798% _ $154,168" Water Enterprise Fund Sewer Enterprise Fund Storm Water Enterprise Fund Arena Enterprise Fund Total Funding Requirements 2013 2014 Adopted Proposed +!- Budget --- -- ------ ------- Budget -- --- ------- - -- - -- Difference -- --- ---- ----- - - -- Percentage --------------- -- $247,700 $252,600 $4,900 1.98% $0 ($140,000) ($140,000) n/a 484,400 500,000 15,600 3.22% 22,000 40,000 18,000 81.82% 435,300 463,400 28,100 6.46% 383,200 374,200 (9,000) -2.35% 896,800 928,600 31,800 3.55% 3,187,800 3,379,800 192,000 6.02% 437,000 437,300 300 0.07% 540,500 504,100 (36,400) -6.73% 645,200 676,200 31,000 4.80% 1,272,200 1,333,400 61,200 4.81% 739,100 831,600 92,500 12.52% 1,130,000 1,166,300 36,300 3.21% 64,500 61,200 (3,300) -5.12% 14,000 15,000 1,000 7.14% 113,900 111,500 (2,400) -2.11% 115,000 115,000 0 0.00% $10,728,600 $11,050,200 ------------------ $321,600 -------- - - - --- 3.00% 24,000 24,000 0 0.00% 730,000 740,000 10,000 1.37% 460,000 490,000 30,000 6.52% 245,000 245,000 0 0.00% 58,000 58,000 0 0.00% 377,394 375,622 (1,772) - 0.47% 0 0 0 0.00% 86,000 0 (86,000) - 100.00% 1, 330, 300 1,501,900 171,600 12.90% 1,782,200 1,811,300 29,100 1.63% 647,600 662,700 15,100 2.33% 485,800 ---- -------- - - -- -- 505,300 - ----- ------ - - - - -- 19,500 ----- ------- ------ 4.01% --------------- $16,954,894 $17,464,022 $509,128 - 3.00% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. FUNDING REQUIREMENTS -SOURCES (INCLUDING FIRE STATION LEVY) June 25, 2013 Levy Sources: Special Levies General Levy Total Levy Loss of MVHC from State Funding Total Revenue Sources 463,394 2013 2014 - 18.94% 9,996,300 10,232,000 Adopted Proposed --------- ---- - - - - -- $10,459,694 +1. Types ---------------------------------------- ----- -- ------ Budget - - - - -- ------------- -- ---- Budget --- -- -------- - - - - -- Difference -------- ----- - - -- -- Percentage --------------- Internal Revenue Generated: ------ ------------ $16,954,894 - --- - - - - -- ---------- --- -------- -- - - -- -- ------------- $17,464,022 ---- - - - - -- ---- ---- - - - - -- ---- - - - - -- --------------- $509,128 - - - - -- -- - - - - -- -- 3.00% - - - - -- - - - - -- Licenses and Permits 382,300 438,300 56,000 14.65% Intergovernmental 643,100 580,800 (62,300) -9.69% Charges for Services 663,000 848,300 185,300 27.95% Fines & Forfeits 125,000 125,000 0 0.00% Recreational Fees 263,200 253,600 (9,600) -3.65% Miscellaneous Revenues 169,200 125,700 (43,500) - 25.71% Transfers In 3,500 3,500 0 0.00% Enterprise Revenues 4,245,900 4,481,200 235,300 5.54% Total Internal Revenues ------ ------------ 6,495,200 ------------- - - - - -- 6,856,400 ------- ------ - - - - -- 361,200 --------------- 5.56% Levy Sources: Special Levies General Levy Total Levy Loss of MVHC from State Funding Total Revenue Sources 463,394 375,622 (87,772) - 18.94% 9,996,300 10,232,000 235,700 2.36% --------- ---- - - - - -- $10,459,694 ------------- - - - - -- ---- $10,607,622 ------ -- -- -- - -- --------------- $147,928 1.41% $0 $0 $0 0.00% ------ ------------ $16,954,894 - --- - - - - -- ---------- --- -------- -- - - -- -- ------------- $17,464,022 ---- - - - - -- ---- ---- - - - - -- ---- - - - - -- --------------- $509,128 - - - - -- -- - - - - -- -- 3.00% - - - - -- - - - - -- NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. 2 2013 GENERAL PROPERTY TAX LEVY PAYABLE 2014 GENERALLEVY GENERAL FUND $8,675,000 BUILDING CIP FUND $24,000 STREET CIP FUND $740,000 EQUIPMENT CIP FUND $490,000 INSURANCE FUND $245,000 PORT AUTHORITY OPERATING LEVY $58,000 TOTAL GENERAL LEVY $10,232,000 BONDEDINDEBTEDNESS G.Q. CAPITAL IMPROVEMENT PLAN (CIP) BONDS 2005A (Authorized - $212,011) $212,011 G.O. IMPROVEMENT BONDS 2006B (Authorized - $265,893) $0 G.O. PUBLIC FACILITY REFUNDING BONDS 2010B (Old 2001 C) (Port Authority) (Authorized - $163,611) $163,611 G.O. IMPROVEMENT BONDS 2011A (Authorized - $3,420) $0 TOTAL BONDED INDEBTEDNESS $375,622 MARKET VALUE BASED REFERENDUMS G.O. FIRE STATION REFUNDING BONDS, 2005D (Authorized - $141,225) $0 TOTAL FIRE STATION LEVY $0 PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($1,952,221,344 x.00798% = $155,787) (As of 2/27/13) $0 (Authorized - $155,787 - Only Levy Amount Due MSABC) ------------------------- TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS $0 GRAND TOTAL 2011 PROPERTY TAX LEVY $10,607,622 -------- - - - - -- -------------- Last Updated 6/16/13 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) (Proposed) 2011 2012 2013 2014 Total Funding Requirements 16,625,444 16,689,426 16,954,894 17,464,022 Less: Internal Revenues 6,092,800 6,357,600 6,495,200 6,856,400 Less: Market Value Based Levy - Fire Station (See Below) 143,654 0 0 0 (3) Equals: Revenues Needed 10,388,990 ----------------- 10,331,826 ---- ------- ---- -- 10,459,694 --------------- -- 10,607,622 Add Back in State MVHC Cuts to Reflect Actual Levy 429,507 0 0 0 (4) Levy Certified by City to County Auditor - -- --- -- --- - - ---- 10,818,497 --- ----- --- - - ---- 10,331,826 -- -- ------- -- - - -- 10,459,694 --------------- -- 10,607,622 County Auditor Adjustments (All Subtractions): Fiscal Disparities Distribution Levy (Metro Area) 1,299,717 1,252,954 1,235,453 1,235,453 (2) Spread Levy Used to Compute Local Tax Rate - ---- ------ ------ ----- ------ --- - -- 9,518,780 (1) 9,078,872 (1) - --------- -- - - --- 9,224,241 (1) --------------- -- 9,372,169 Increasel(Decrease) from Previous Year in Spread Levy -4.62% 1.60% 1.60% Market Value Based Referendum Levy - Fire Station 143,654 0 0 0 (3) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2014 Number Provided by Dakota County as of 81xx/13 (3) For 2012 Through 2014 No Levy Needed so No Impact on the Taxpayers (4) The MVHC Program was Eliminated for 2012 and Replaced with a Market Value Exclusion Program Last Updated - 6/16/13 L� CITY OF ROSEMOUNT WORKSHEET FOR ESTIMATING RESIDENTIAL PROPERTY TAXES (ISD #196 FIGURES) (Rates Based on Proposed Final Levy Numbers) (MN Exclusion is Only Applicable to 2012 and Beyond) 181,632 (Value After MN Exclusion) 176,073 (Value After MfV Exclusion) 184,085 (Value After M/V Exclusion) 235,260 (Value After M/V Exclusion) Market Value 200,800 (Payable 2012 Median) 195,700 (Payable 2013 Median) 203,050 (Est. Payable 2014 Median) 250,000 Year 2012 2013 2014 Est. 2012 2013 2014 Est. 2012 2013 2014 Est. 2012 2013 2014 Est. Tax Capacity ----'- ____-- 2,008 ----------- 1,816 ---------•------ 1,816 ------------------ 1,957 - --- ----'---- 1,761 -------------- 1,761 ------------------ •-----------'_' 2,031 1,841 - •- ----- --- -- 1,841 ----- - - ----- 2,500 •-- -- ------ -- 2,353 ---------- ------- 2,353 Tax Capacity Rates: City 0.46994 0.48862 0.47385 0.46994 0.48862 0.47385 0.46994 0.48862 0.47385 0.46994 0.48862 0.47385 County 0.31426 0.33421 033421 0.31426 0.33421 0.33421 0.31426 0.33421 0.33421 0.31426 0.33421 0.33421 School District 0.28440 0.27956 0.27956 0.28440 0.27956 0.27956 0.28440 0.27956 0.27956 0.28440 0.27956 0.27956 Miscellaneous 0.05562 0.05884 0.05884 0.05562 0.05884 0.05884 0.05562 0.05884 0.05884 0.05562 0.05884 0.05884 Totals ------"-----__ 1.12422 _---- ------- 1.16123 - -'--------- 1.14646 -------------- 1.12422 --- ------ - "'-- 1.16123 ----------------- 1.14646 -------- ------- - --- 1.12422 116123 ------- - --- ____ 1.14646 --- ------------- 1.12422 --- -------------- 1.16123 ------ ----'-- 1.14646 City Market Referendum 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 ISO #196 Market Ref 0.0022131 0.0022131 0.0023542 0.0022131 0.0022131 0.0023542 0.0022131 0.0022131 0.0023542 0.0022131 0.0022131 0.0023542 Dakota County Ref 0.0000551 0.0000000 0.0000000 0.0000551 0.0000000 0.0000009 0.0000551 0.0000000 0.0000000 0.0000551 0.0000000 0.0000000 2013 2014 Property Taxes: City 864 887 861 838 860 834 875 899 872 1,113 1,150 1,115 City Taxes $860 $872 County 577 607 607 560 588 588 585 615 615 744 786 786 City Market Ref. $0 $0 School District 523 508 508 507 492 492 529 515 515 674 658 658 Miscellaneous 102 107 107 99 104 104 104 108 108 132 138 138 Total Taxes - Median $860 $872 Total Property Taxes _.- -------- __- 2,066 ------- __------- 2,109 ----- ------------ 2,082 ---- _ ----- __---- 2,004 - __ ----- _------- 2,045 ------ _--------- 2,019 -------- _ --- ___ --------------- __ 2,093 2,138 __ ----- .---- ___ 2,110 ---------- _----- 2,663 ------- _ ---- _--- 2,732 ------- _ ----- ___ 2,697 Increase / (Decrease) $12 City Market Referendum 0 0 0 0 0 0 0 0 0 0 0 0 ISO #196 Market Ref 444 444 473 433 433 461 449 449 478 553 553 589 Dakota County Ref 11 0 0 11 0 0 11 0 0 14 0 0 Grand Total All Taxes ---•--------- - $2,521 ---------------- $2,554 -----"'--•--- $2,555 ---••-------•---' $2,448 ----------- ------ $2,478 --------------• $2,479 ------ ----------- ------- ---- -- $2,554 $2,587 ------- -----'-' $2,588 ---_______-____ $3,230 _- ------- ---- $3,285 --------------- -- $3,286 269,760 (Value After M/V Exclusion) 414,000 (Value After M/V Exclusion) Market Value 300,000 414,000 History of Actual Tax Capacity Rates (Using ISO #196 Rates) Year 2012 2013 2014 Est. 2012 2013 2014 Est, ___ ------ - ------ _ ---- _ -------- _ 2009 2010 __ ------- _.____ 2011 ____-------- ----- 2012 .--------- _------ 2013 ------ _ ---- ____ 2014 Est. Tax Capacity 3,000 - - 2,898 -------------- __ 2,898 __________•____ 4,140 --- ____--------- 4,140 _ ------- .------ _ 4,140 ------ __------- -------------- ___ -------- __ ---- __ ---- _---- ----- ____------- ____________ (3.02% Decrease) Tax Capacity Rates: City 0.46994 0.48862 0.47385 0.46994 0.48862 0.47385 0.42323 0.43358 0.44661 0.46994 0.48862 0.47385 (1),(2) County 031426 0.33421 0.33421 0.31426 0.33421 0.33421 0.25821 0.27269 0.29149 0.31426 0.33421 0.33421 (2) School District 0.28440 0.27956 0.27956 0.28440 0.27956 0.27956 0.21109 0.25391 0.26959 0.28440 0.27956 0.27956 (2) Miscellaneous 0.05562 0.05884 0.05884 0.05562 0.05884 0.05884 0.04916 0.04987 0.05199 0.05562 0.05884 0.05884 (2) Totals -------------- 1.12422 --------- ------- 1.16123 -'------------ 1.14646 -------------- 1.12422 -------- --'------ 1.16123 "- - ---- ------- 1.14646 ------""-----• -------- °--_- 0.94169 1.01005 -'-_"--- -- 1.05968 --------------• 1.12422 -'--------__-._- 1.16123 ------------ 1.14646 City Market Referendum 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000631 0.0000652 0.0000697 0.0000000 0.0000000 0.0000000 (2) ISO #196 Market Ref 0.0022131 0.0022131 0.0023542 0.0022131 0.0022131 0.0023542 0.0021032 0.0022268 0.0022601 0.0022131 0.0022131 0.0023542 (2) Dakota County Ref 0.0000551 0.0000000 0.0000000 0.0000551 0.0000000 0.0000000 0.0000471 0.0000501 0.0000537 0.0000551 0.0000000 0.0000000 (2) Property Taxes: City 1,367 1,416 1,373 1,946 2,023 1,962 Net Tax Capacity Percentages County 914 968 968 1,301 1,384 1,384 For Residential Homesteads: School District 827 810 810 1,177 1,157 1,157 Miscellaneous 162 170 170 230 244 244 Equal to or Less Than $500,000 1.00% 1.00% 1.00% _-___.__-__-_ _----__-__--• ....... ----------- _____ -__-__-_-__ ._-________--' Over $500,000 1.25% 1.25% 1.25% Total Property Taxes 3,270 3,365 3,322 4,654 4,807 4,746 City Market Referendum 0 0 0 0 0 0 ISO #196 Market Ref 664 664 706 916 916 975 Tax Credit for Homestead Properties: (For 2002 Through 2011 Credit Applied to All Organizations Proportionately) Dakota County Ref 17 0 0 23 ----- ----- 0 --- -===== 0 ======---- (Based on % of Tax Capacity) (For 2012 and On Credit Eliminated - Replaced with Market Value Adjustment) Grand Total All Taxes $3,951 $4,029 $4,028 $5,593 $5,724 $5,721 Less Than Initial Value of Tax Capacity n/a n/a n/a (2) Over Initial Value (Maximum Allowed) $304 n/a n/a (2) Initial Value Used to Calculate Credit $76,000 nla Ma (2) (1) This Figure Derived Using Figures Provided by Dakota County: (a) 2013 Projected Levy Less Fiscal Disparities as of 5/6113 9,372,169 / 19,778,838 = 0.47385 (b) Net Tax Capacity Figure as of 2/27113 (With M/V Exclusion) 22,702,682 (4.12% Increase from Final Pay 2013) (c) Captured Tax Increment Tax Capacity as of 10)23)12 (565,673) ((4.11 % -Last Year) Decrease from Final Pay 2013) (d) Contribution to Fiscal Disparities as of 812/12 (2,358,171) ((0.78 % -Last Year) Decrease from Final Pay 2013) Last Updated - 6116/13 (2) These Figures Provided by Dakota County 19,778,838 (For 2012 and on the City of Rosemount does not have a Referendum Levy) Page One 2014 BUDGET WORKSHEETS GENERAL FUND REVENUES June 25, 2013 Account # Description 101 31010.00 Current Ad Valorem Taxes 101 31040.00 Fiscal Disparities Total Taxes (Tax) 101 32110.00 101 32160.00 101 32162.00 101 32210.00 101 32212.00 101 32220.00 101 32221.00 101 32230.00 101 32240.00 101 32250.00 101 32255.00 101 32260.00 101 32290.00 101 31010.00 101 31010.01 101 31020.00 101 31030.00 101 31710.00 101 31810.00 101 31811.00 101 31920.00 101 33100.00 101 33416.00 101 33416.01 101 33416.02 101 33418.00 101 33423.00 101 33425.00 101 33620.00 101 33630.00 101 33630.00 Alcoholic Beverage Licenses (L) Licenses to do Business (L) Lic to do Business - Rental Housing (L) Building Permit Revenue (L) Mineral Extraction Permit (L) 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 (1) MSABC Armory Payments Delinquent Ad Valorem Taxes (I) Mobile Home Taxes (1) Gravel Taxes (1) Franchise Taxes - Regular Fees (I) Franchise Taxes - PEG Fees (1) Forfeited Tax Sale Apportionment (1) Federal Grants & Aids (1) Police Training Reimbursement (I) Post Board Training Reimb State Aid (Tied to PERA) MSA for Streets - Maintenance (1) Ag Preserves Credit (1) Other State Grants & Aids (1) Other County Grants & Aids (1) Police Services Levy -ISD #196 (1) Liaison Funding Total Intergovernmental (1) PAGE TOTALS 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $7,013,792 $7,239,992 $6,972,330 $7,243,847 1,195,913 1,299,717 1,252, 954 1,235,453 8,209,705 8,539,709 8,225,284 8,479,300 51,533 38,825 38,607 40,000 10,455 5,880 6,960 7,000 15,337 4,010 15,750 4,000 272,975 249,558 304,223 230,000 1,110 1,070 1,850 1,200 13,555 16,467 14,085 13,000 7,270 8,274 6,678 7,000 26,250 29,795 30,355 30,000 2,397 2,491 2,440 2,500 12,891 5,325 13,894 7,000 70 60 100 100 39,117 26,270 49,402 40,000 940 590 300 500 453,900 388,616 484,644 382,300 80,000 86,000 86,000 86,000 169,891 131,114 106,838 0 13,026 12,746 12,401 12,000 46,073 39,679 16,817 20,000 193,997 199,067 202,501 200,000 24,739 24,037 23,173 25,000 0 0 0 0 0 0 26,044 0 147,975 152,637 144,515 7,000 143,000 30,165 30,165 32,625 32,600 1,484 1,007 1,275 1,000 31,087 38,277 51,794 30,000 19,500 22,400 21,100 22,500 67,284 62,242 62,864 64,000 825,221 799,371 787,949 643,100 9,488,825 9,727,696 9,497,877 _ 9,504,700 �0 $7,439,547 From County 1,235,453 From County 8,675,000 Total Property Tax Levy for Fund 101 38,000 7,000 Garbage Haulers, Ped Licenses, etc. 12,000 280,000 1,200 13,000 7,000 30,000 2,500 7,000 100 40,000 500 Alarm Permits & Fireworks Permits 438,300 0 Included in Debt Levy Figure 0 " Will Use Reserves Thru Final Pymt 0 From County 12,000 From County 43,000 From County 202,000 From Cable Company 23,000 From Cable Company 0 From County 0 150,000 From State 7,000 143,000 32,600 From State 1,000 From State 30,000 From State -PERA Aid & Safe & Sober 22,500 Dakota County Recycling Funds 64,700 64,700 From ISD #196 580,800 9,694,100 �0 Page Two 2014 BUDGET WORKSHEETS GENERAL FUND REVENUES June 25, 2013 Account # Description 2010 2011 2012 Actual Actual Actual 2013 2014 Object 2014 Adopted Detail Proposed Budget Amount Budget Comments 101 34103.00 Zoning & Subdivision Fees (C) 33,310 31,865 29,854 32,000 101 34104.00 Plan Checking Fees (C) 89,313 71,774 105,669 75,000 101 34105.00 Sales of Maps & Publications (C) 364 377 215 500 101 34106.00 Deputy Registrar Fees (C) 0 0 0 0 101 34108.00 Admin Fees - Other Funds (C) 0 101 34108.01 Applicable Funds Except Const. 25,000 25,000 25,000 25,000 101 34108.02 Construction Funds 10,027 36,093 97,462 0 101 34109.00 Other Charges for Service (C) 6,286 3,981 4,939 4,000 101 34110.00 Service Chg on Returned Chks (C) 148 60 210 100 101 34112.00 Utility Permit Application Fee (C) 1,120 0 0 0 101 34113.00 Application Fees (C) 0 0 2,500 0 101 34150.00 User Fees - SKB (C) 112,314 74,655 124,362 120,000 101 34151.00 User Fees /Host Agreements - SKB(C) 162,306 180,672 140,248 165,000 101 34151.00 Landscaping Agreement 10,700 101 34151.00 Trust Fund - City Portion 1,500 101 34152.00 User Fees - SKB (C) 16,885 10,850 15,879 20,000 101 34153.00 User Fees - SKB (C) 135,229 167,857 145,029 120,000 101 34160.00 National Guard Maint Fees (C) 48,456 45,084 49,854 46,000 101 34160.00 Shared Space Maint. Agreement 9,000 New Fee for 2012 101 34160.00 Building Maintenance Contract New Fee for 2011 4,000 101 34201.00 Special Police Services (C) 15,160 25,322 12,570 19,000 101 34202.00 Fire Services - Burning Permits (C) 850 750 750 200 101 34203.00 Accident Reports (C) 25 43 2 0 101 34204.00 Day Care Inspection Fees (C) 500 150 150 200 101 34206.00 Other Police Services (C) 550 0 50 0 101 34207.00 Other Fire Protection Services (C) 21,043 20,209 41,146 101 34207.01 U of M Fire Contract 4,500 8,000 101 34207.02 Coates Fire Contract 6,000 10,000 101 34207.03 Other Billed Fire Calls 8,500 1,000 101 34303.00 Mow Weeds (C) 1,331 1,580 1,696 1,500 101 34304.00 Sweep /Plow Streets (C) 730 733 1,149 300 101 34306.00 Other Highway & Street Rev (C) 11,982 61,031 28,954 10,000 101 34310.00 Right -of -Way Permits (C) 4,715 3,146 10,905 3,400 101 34407.00 City Share of Metro SAC Chgs (C) 2,154 1,677 2,860 1,800 Total Charges for Services (C) - 699,796 762,906 - 841,451 - 663,000 101 35101.00 Court Fines (F) 113,675 123,245 129,343 125,000 Total Fines & Forfeits (F) 113,675 123,245 129,343 125,000 101 34718.00 Tournament Fees (R) 0 0 11,685 7,000 101 34719.00 Player Maintenance Fees (R) 0 1,894 0 0 101 34720.00 Park Reservations (R) 3,984 3,605 3,526 4,000 101 34721.00 Softball Revenues (R) 66,288 59,135 50,946 58,000 101 34724.00 Tennis Revenues (R) 2,490 1,710 2,460 2,100 101 34725.00 Tiny Tot Revenues (R) 5,934 0 0 0 101 34726.00 Rosettes Revenues (R) 1,974 2,150 1,987 2,100 101 34727.00 Field Trip Revenues (R) 101 34727.01 Youth/Teen Trips 0 450 300 200 10134727.02 AdultiSenior Trips 1,384 791 5,077 1,000 101 34728.00 Adult Soccer League Revenues (R) 14,866 13,319 12,527 13,000 101 34730.00 Run for the Gold Revenues (R) 4,527 4,956 4,410 4,600 101 34731.00 Youth Soccer Lessons (R) 4,011 3,782 2,814 3,700 101 34732.00 Adult Basketball Revenues (R) 2,147 1,400 1,774 1,400 101 34733.00 Other Programs Revenues (R) 20,298 21,064 20,032 20,000 101 34735.00 Camps Revenues (R) 19,571 20,000 21,256 19,000 101 34736.00 T -Ball Lessons (R) 5,887 4,330 5,250 4,500 101 38080.00 Banquet Room Fees (R) 55,435 60,124 46,427 60,000 101 38081.00 Auditorium Fees (R) 8,535 7,981 5,480 8,000 101 38082.00 Gymnasium Fees (R) 25,062 23,098 26,943 24,000 101 38086.00 Classroom Fees (R) 7,548 7,476 8,497 8,000 101 38096.00 Liquor Provider Fees (R) 540 630 795 800 101 38097.00 A/V Rental Fees (R) 255 520 1,100 500 101 38154.00 Teen Night Revenues (R) 100 0 750 0 101 38201.00 Rental Revenues 6,575 19,750 17,830 18,000 101 38203.00 Rental Revenue- Churches 0 500 0 0 101 38205.00 A/V Rental Revenues 0 428 25 500 101 38209.00 Miscellaneous Revenues 0 280 93 0 101 38211.00 Security Services 700 2,050 1,050 2,000 101 38301.00 Rental Revenues 0 0 0 750 101 38305.00 A/V Rental Revenues 0 0 0 50 - Total Recreation Fees (R) -- -- -- -- - -- 258,110 ----- -- - - -- ----- 261,422 --- -- ---- -- --- 253,033 - - -- -- 263,200 PAGE TOTALS - - - -- 1,071,581 - --- -- -- - --- 1,147,572 -- - - - -- -- -- 1,223,827 ----- - --- -- 1,051,200 32,000 90,000 300 Maps & Spec Books 0 Dakota County Took Over Feb. 2009 95,000 25,000 70,000 85% of 5% Fee for Const. Projects 4,500 100 0 0 155,000 SKB Fees - C & D Cell Fees 180,000 25,000 Landscaping Agreement 155,000 20,000 SKB Fees - MSW Ash Charges 170,000 SKB Fees - Base Service Charges 46,000 16,000 Snow Removal / Mowing 30,000 19,000 Contractual Orf for Officers 200 No Longer Charge for Permits 0 200 0 18,000 5,200 10,700 2,100 1,500 500 10,000 Street Light Bills - Developers 4,000 2,000 848,300 125,000 From County 125,000 9,000 New Fee for 2012 0 New Fee for 2011 4,000 52,000 2,400 0 Eliminated Program in 2010 2,100 5,000 400 4,600 13,000 4,600 3,000 1,400 20,000 19,000 4,500 60,000 6,000 27,000 8,500 800 1,000 0 Eliminated Program in 2010 8,000 Steeple Center Operations 0 Steeple Center Operations 500 Steeple Center Operations 0 Steeple Center Operations 1,000 Steeple Center Operations 750 Senior / Activity Center Operations 50 Senior / Activity Center Operations 253,600 1,226,900 Page Three 2014 BUDGET WORKSHEETS GENERAL FUND REVENUES June 25, 2013 Account # Description 101 36101.00 101 36102.00 101 36210.00 101 36214.00 101 36215.00 101 36220.00 101 36220.01 101 36220.02 101 36220.03 101 36230.00 101 36260.00 101 36262.00 101 36265.00 101 38090.00 101 39202.00 101 39203.00 Principal - Special Assessments (M) Penalties & Interest - S/A (M) Interest Earnings - Investments (M) Net Change in FV- Investments (M) interest Earnings (M) Rents & Royalties (M) Verizon Antenna Rent Athletic Complex Land Rental MVTA -RCC Parking Lot Rental Contribution /Donations (M) Other Revenue (M) Special Settlements (M) Use of Reserve Funds (M) City Concessions (M) Total Misc Revenues (M) Contribution from Enterprises (T) Transfer From (T) Total Transfers In (T) PAGE TOTALS FUND TOTALS INTERNAL REVENUES 2010 Actual 2011 Actual 2012 Actual 2013 Adopted Budget 2014 Object Detail Amount 2014 Proposed Budget Comments 9,450 9,244 8,369 1,000 1,000 From County - 101 Funded Projects 113 0 2 0 0 From County 165,773 189,675 94,204 145,000 85,000 (43,787) 5,947 2,588 0 0 Annual Market Value Changes 1,349 610 743 500 500 From Checking Account 19,325 18,329 19,237 15,700 12,700 12,700 0 New Fields Constructed in 2013 0 Move to New Lot 18,639 25,622 42,638 0 0 98,882 2,785 6,369 2,000 2,000 0 0 0 0 0 0 0 0 0 20,000 Elections Balancing 4,903 5,295 4,538 5,000 4,500 274,645 257,507 178,689 169,200 -� - - - 125,700 3,500 3,500 3,500 3,500 3,500 Arena - Building & Grounds Maint. 0 61,422 0 0 0 Funds Returned from Projects 3,500 64,922 3,500 3,500 - - - 3,500 $278,145 - - --- $322,429 ----- - - - - -- $182,189 - - - - - - -- $172,700 ---- - - - - -- - - - - - -- $129,200 $10,838,551 $11,197,697 $10,903,894 $10,728,600 $11,050,200 $2,628,847 $2,657,988 $2,678,610 $2,249,300 $2,375,200 Grand Total Less: Ad Valorem & Fiscal Disparities Page Four 2014 BUDGET WORKSHEETS GENERAL FUND REVENUES June 25, 2013 Account # Description 101 34108.00 General Fund Admin Fees 101 34108.01 Fund 201 101 34108.02 Fund 202 101 34108.03 Fund 203 101 34108.04 Fund 206 101 34108.05 Fund 207 101 34108.06 Fund 605 101 34108.07 Fund 606 101 34108.08 Fund 607 101 34108.09 Fund 650 Admin Fees Breakdown Totals Comments 4 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $25,000 $25,000 $25,000 $25,000 $25,000 6,000 2,500 2,500 2,500 2,500 1,000 1,000 1,000 6,000 - $25,000 --- --- -- ---- $25,000 - -- --- $25,000 -- -- ------ $25,000 -- -- ---- $25,000 - - - - -- $25,000 Comments 4 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 10 Page One 2014 BUDGET WORKSHEETS COUNCIL June 25, 2013 Account # Description 101 41110 103.00 Salaries & Benefits 101 41110 01 225.00 Landscaping Materials 101 41110 01 307.00 City Promotional Fees 101 4111001 307.01 Newsletter 101 41110 01 307.02 Chamber of Commerce Directory 101 41110 01 307.03 Community Survey 101 41110 01 315.00 Special Programs 101 4111001 319.00 Other Professional Services 101 4111001 319.01 Education Reimbursement 101 41110 01 319.02 Intergovernmental Initiatives 101 41110 01 321.00 Telephone Costs 101 4111001 321.01 Mayor's Pager 101 41110 01 321.02 Mayor's Cell Phone 101 41110 01 329.00 Other Communication Costs 101 41110 01 331.00 Travel Expense 101 4111001 331.01 NLC Conference 101 41110 01 331.02 Miscellaneous Travel 101 4111001 433.00 Dues & Subscriptions 101 41110 01 433.01 LMC Dues 101 41110 01 433.02 AMM Dues 101 41110 01 433.03 Dak Cty Regional Chamber 101 41110 01 433.04 NLC Dues 101 41110 01 433.05 Miscellaneous Dues 101 41110 01 435.00 Books & Pamphlets 101 41110 01 437.00 Conferences & Seminars 101 4111001 437.01 Registration & Hotel -LMC Conf 101 41110 01 437.02 Registration & Hotel -NLC Conf 101 41110 01 437.03 Miscellaneous Conferences 101 4111001 439.00 Other Miscellaneous Charges 101 41110 01 598.00 Council Designated 101 4111001 598.01 Library Site Expenditures 101 41110 01 598.02 Sales Tax Exemption Savings 101 4111001 598.03 Salary & Benefit Contingency 101 41110 01 599.00 Employee Recognition Costs 101 41110 01 599.01 Employee Recognition Costs 101 41110 01 599.02 Vending Machine Costs 101 41110 01 599.03 Commemorations 101 41110 01 599.04 CommissionlVolunteer Recognition PAGE TOTALS DEPARTMENT TOTALS 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual ------ --- - - - - -- Actual ----- ---- - - - - -- Actual --------- - - - - -- Budget -------- Amount Budget Comments - - - - - -- ----- ---- - - - - -- ------- -- -- - -- ----------------------------------------------- All Salary Costs Inclusive of $35,761 $36,148 $36,785 $36,800 $36,800 Salary, Taxes, PERA & Benefits 25,026 25,000 24,799 25,000 25,000 SKB Agreement, Arbor Day, etc. 16,100 20,237 18,300 14,475 18,300 15,000 Reduce From 5 to 3 Newsletters 2,138 1,069 1,069 1,100 1,100 0 0 0 0 0 0 3,058 1,501 5,000 2,500 Promotions, Marketing, etc. 17,000 6,067 15,243 4,196 12,000 12,000 903 0 769 5,000 5,000 400 0 0 0 0 0 378 375 389 400 400 252 0 0 500 500 Newspaper Ads/ Open Houses 6,800 0 740 5,250 1,200 5,200 1,009 1,453 1,564 1,500 1,600 25,900 14,806 14,957 15,562 15,300 16,000 6,912 6,951 7,263 7,500 7,800 (651) 30 0 800 100 1,489 1,549 1,861 1,600 2,000 140 0 0 0 0 0 0 0 100 100 11,300 590 1,619 0 1,700 1,700 0 3,249 2,245 4,000 8,600 150 964 540 1,000 1,000 231 98 21 300 300 18,935 271,718 49,119 100,000 100,000 2011- Assignment for Health Ins. 0 0 0 0 0 0 0 0 0 0 (140,000) 0 0 0 0 0 Contingency for Negotiations 9,900 3,487 2,462 3,980 2,700 3,500 3,406 4,358 3,907 3,500 4,000 Offset by Revenue from Machines 1,044 1,118 775 1,200 1,200 0 --------- -- -- -- 0 -------- - ----- 0 1,200 1,200 $142,309 - $410,458 ---- ---- - - - - -- $176,072 -- --- ---- - - - --- $247,700 --- ----- - - -- -- ------ -- - - - - -- $112,600 $142,309 $410,458 $176,072 $247,700 $112,600 ADMINISTRATION DEPARTMENT The Administration Department is responsible for the overall management of all departments within the City and for assuring that departmental activities are consistent with the goals established by the City Council. GENERAL ADMINISTRATION • Provides overall management, administration and coordination of activities in all City departments including: Community Development, Finance, Fire, Police, Public Works and Parks & Recreation. • Provides for preparation and overall management of the City's budgets. • Provides project management for projects that are unique and therefore not assignable to any other department. • Provides overall coordination of City consultants. • Provides for the execution of all policies as adopted by the City Council. • Provides administrative and clerical support to the City Council including the preparation, distribution and maintenance of City Council meeting documents. RECORDS MANAGEMENT • Provides for the preparation and maintenance of official records for the City including Council, Port Authority and Commission minutes. • Prepares and assures publication and posting of official notices. • Provides public information on ordinances, contracts and policies. • Administers the collection, storage and dissemination of data. • Provides for the maintenance, training and supervision of the digital document management system. (ti 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. �j ADMINISTRATION DEPARTMENT - Page 3 STAFFING • For 2014, the department will consist of four positions: • City Administrator • Assistant City Administrator • Communications Coordinator • City Clerk PERFORMANCE MEASURES n/a — Information Not Available 2013 n/a 2013 2.6% (4 Months) 2013 6,893 (4 Months) 14 Worker's Compensation Modification Factor 2008 2009 2010 2011 2012 .82 .86 .85 .90 .88 Turnover Rate of City Personnel 2008 2009 2010 2011 2012 2.5% 0.0% 2.5% 5.2% 2.6% Average Monthly Unique Views on City Website 2008 2009 2010 2011 2012 8,444 6,368 7,005 6,555 7,423 n/a — Information Not Available 2013 n/a 2013 2.6% (4 Months) 2013 6,893 (4 Months) 14 Page One 2014 BUDGET WORKSHEETS ADMINISTRATION June 25, 2013 Account # Description 101 41320 101.00 Salaries & Benefits 101 41320 102.00 Full -Time Overtime 101 41320 103.00 Part-Time Salaries & Benefits 101 41320 01 209.00 Other Office Supplies 101 41320 01 313.00 Temporary Service Fees 101 4132001 319.00 Other Professional Services 101 41320 01 321.00 Telephone Costs 101 41320 01 331.00 Travel Expense 101 4132001 331.01 NLC Conference 101 41320 01 331.02 ICMA Conference 101 4132001 331.03 Miscellaneous Travel 101 41320 01 433.00 Dues & Subscriptions 101 41320 01 433.01 MCMA Dues 101 41320 01 433.02 MAMA Dues 101 41320 0143103 MCFOA Dues 101 41320 01 433.04 Munici -Pals 101 41320 01 433.05 IIMC Dues 101 41320 01 433.06 ICMA Dues 101 41320 01 433.07 APMP Dues 101 41320 01 435.00 Books & Pamphlets 101 41320 01 437.00 Conferences & Seminars 101 41320 01 437.01 Registration & Hotel - LMC 101 41320 01 437.02 Registration & Hotel - MCMA 101 41320 01 437.04 Staff (1) Each 101 41320 01 437.05 Miscellaneous Seminars 101 41320 01 437.06 Registration & Hotel - ICMA 101 41320 01 437.07 City Clerk Training 101 41320 01 437.08 Registration & Hotel - NLC 101 41320 01 437.09 Miscellaneous Meetings 101 41320 01 439.00 Other Miscellaneous Charges 101 41320 01 580.00 Other Equipment Purchases PAGE TOTALS 16 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual ------- -- - - -- Actual ------ ---- - - - -- Actual --------- - - ---- Budget -- Amount Budget Comments ---- ----- - --- ------ --- - - - - -- --- --- --- - - - - -- ----------------------------------------------- All Salary Costs Inclusive of $408,204 $426,536 $415,333 $410,600 $422,600 Salary, Taxes, PERA & Benefits 0 0 0 300 0 2,056 0 8,599 700 0 Temp Receptionist Coverage 94 0 0 300 300 Miscellaneous Purchases 0 0 0 0 0 0 0 0 0 0 1,083 1,363 1,324 1,500 1,500 Administration Cell Phones 1,200 0 0 0 0 0 422 274 288 600 700 325 448 289 500 500 2,500 215 261 264 300 270 45 0 0 50 0 35 35 0 50 50 85 25 85 100 90 0 0 0 0 200 City Clerk Association 1,716 1,742 1,759 1,800 1,800 90 30 55 100 90 0 61 0 100 100 7,300 500 709 295 800 500 1,633 1,318 724 1,500 1,500 0 0 0 0 0 240 (193) 0 300 300 ULI / Greening Initiatives 2,306 2,059 2,998 2,500 3,000 680 594 679 1,200 1,800 All MCFOA Events AMC 0 0 0 0 0 6 209 187 200 200 0 0 200 100 200 841 214 73 500 200 ------- - - ---- 420,574 -------- - - -- -- 435,687 --------- - - - - -- 433,150 ------ --- - - - - -- 424,100 -------- - ----- --------------- 435,900 16 Page Two 2014 BUDGET WORKSHEETS ADMINISTRATION June 25, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description - ---- ----- -- -- - --- ---- - - -- -- -------------- -------------------------------- Actual - -------- - --- -- Actual ------- - - - - - -- Actual ------- ---- - - -- Budget ----- ---- - - - - -- Amount --------- -- - - -- Budget ------ --- - - - - -- Comments ----------------------------------------------- 101 41320 31 305.00 Medical & Dental Fees 1,800 Employee Drug Testing 101 4132031 305.01 Pre - Employment Physicals 597 1,704 525 600 600 101 4132031 305.02 Employee Drug Testing 658 658 1,020 1,200 1,200 101 4132031 306.00 Personnel Testing & Recruitment 0 0 8,850 0 2,000 101 41320 31 315.00 Special Programs 1,500 101 41320 31 315.01 Employee Training 212 1,066 638 1,000 1,000 101 4132031 315.02 Health & Wellness 51 38 50 500 500 Wellness & Health Management 101 4132031 319.00 Other Professional Services 4,000 101 4132031 319.01 Labor Consultant 694 0 1,318 300 500 101 4132031 319.02 Labor Legal Issues 0 0 502 700 700 101 41320 31 319.04 COBRA Consultant 624 692 764 800 800 101 4132031 319.05 Flex/VEBAAdministrative Fees 1,751 1,777 1,771 2,000 2,000 101 41320 31 319.06 SWWC Co- Operative Dues 0 0 0 0 0 101 41320 31 331.00 Travel Expense 313 343 336 400 400 101 4132031 341.00 Employment Advertising 1,727 972 1,100 1,000 1,000 Vacancies 101 41320 31 433.00 Dues & Subscriptions 600 101 4132031 433.01 "Future Use" 0 0 0 0 0 101 41320 31 433.02 IPMA Dues 145 149 149 200 200 101 41320 31 433.03 MPELRA Dues 290 150 329 300 400 101 41320 31 435.00 Books & Pamphlets 0 0 40 100 100 Books & Training Materials 101 41320 31 437.00 Conferences & Seminars 700 101 41320 31 437.01 MPELRA State Conference 0 300 365 300 500 101 41320 31 437.02 Personnel Seminars 300 74 209 200 200 101 4132031 437.03 Safety, Supervisor, Policy 0 0 0 0 0 101 41320 41 315.00 Special Programs 0 0 500 101 4132041 315.01 General Marketing 0 0 200 1,000 500 101 4132041 315.02 Historical Monuments 0 0 0 0 0 101 41320 41 319.00 Other Professional Services 1,043 3,600 101 4132041 319.01 Website 0 1,100 275 3,600 3,600 101 4132041 319.02 Website Improvements 0 10,000 0 0 0 101 4132041 328.00 Cable Supply Costs 2 60 759 500 1,000 Cable Supplies, Software 101 4132041 329.00 Other Communication Costs 0 0 0 46,100 101 4132041 329.01 Cable JPA Payment - General City 41,998 42,902 54,717 44,300 46,000 101 4132041 329.02 Video Streaming Council Mtgs 4,799 0 60 0 100 101 4132041 329.03 Bulk E -Mail System 2,508 2,508 209 0 0 101 4132041 331.00 Travel Expenses 40 25 47 100 100 101 41320 41 433.00 Dues & Subscriptions 200 60 0 100 100 MAGC 101 41320 41 437.00 Conferences & Seminars 0 0 0 100 100 Technical Courses 101 41320 41 580.00 Other Equipment Purchases 827 196 40 1,000 500 PAGE TOTALS -- ------- - - ---- $58,779 ----- -- ----- - -- $64,774 -------- - - - - - -- $74,272 ---- -- --- - - -- -- $60,300 --- ------ - - ---- --------------- $64,100 DEPARTMENT TOTALS $479,353 -- - - - - -- -------- $500,460 -- - - - - -- -- - - - - -- $507,422 -- - - - - -- -- - - - - -- $484,400 -- - - - - -- -- - - - - -- -- - - - - -- -- - - - - -- $500,000 -- - - - - -- -- - - - - -- 1(0 ELECTIONS The responsible execution of elections is a crucial function of local government. Federal, state and local elections assure the popular representation of citizens and that the community's mission, vision and goals are consistent with the wishes of the electorate. GENERAL / ADMINISTRATIVE • Provides for conducting all local, state and federal elections. VOTER REGISTRATION • Provides for the maintenance and execution of procedures for voter registration. SUPPLIES & EQUIPMENT • Provides for the necessary supplies and minor equipment necessary to conduct the elections. CONTRACTED SERVICES • Provides for the maintenance agreements for service and repair of the voter assist terminals and the ballot counters. • Provides for continued use of polling locations. STAFFING • Provides for the recruitment, appointment, training and supervision of election judges to carry out Election Day activities at the City's seven precinct polling locations. • Provides for training of absentee ballot board. PERFORMANCE MEASURES Average Number of Registered Voters per Precinct 2008 2009 2010 2011 2012 2013 1,671 1,836 1,807 1,871 2,186 1,949 n/a — Information Not Available Page One 2014 BUDGET WORKSHEETS ELECTIONS June 25, 2013 Account # Description 101 41410 01 103.00 Part -Time Salaries 101 41410 01 203.00 Printed Forms & Paper 101 41410 01 208.00 Miscellaneous Supplies 101 41410 01 219.00 Other Operating Supplies 101 41410 01 242.00 Minor Equipment 101 41410 01 304.00 Legal Fees 101 4141001 319.00 Other Professional Services 101 41410 01 321.00 Telephone Costs 101 41410 01 351.00 Legal Notices Publishing 101 41410 01 391.00 P.C. Maintenance 101 41410 01 409.00 Other Contracted Repair & Maint 101 41410 01 409.01 Maintenance for AutoMarks 101 4141001 409.02 Maintenance for Accuvotes 101 41410 01 412.00 Building Rental 101 41410 01 439.00 Other Miscellaneous Charges 101 41410 01 580.00 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual ----- --- - - ---- Actual --- --- --- --- - -- Actual --- ------ -- - - -- Budget - ------- - - - - -- Amount ----- -- - - -- -- Budget ----- ---- - - - --- Comments ---------------------------------------------- $20,755 $0 $29,523 $0 $30,000 Election Judges 0 688 117 0 200 Ballots & Programming 656 0 475 0 500 236 0 216 0 300 Food for Election Judges 192 0 77 0 200 Signs & Miscellaneous 2,017 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Election Publications 0 0 0 0 6,200 Elections S/W Maintenance Costs 2,600 1,225 1,225 1,225 1,400 1,400 Voting Machines 1,000 1,000 1,000 1,200 1,200 Voting Machines 0 0 0 0 0 Possible Rent for Locations 0 0 0 0 0 638 0 0 19,400 0 - ----- --- - - ---- $26,719 ------ --- - - - - -- $2,913 - -------- - - -- -- $32,634 ------ --- - - - - -- $22,000 ------ --- - -- --- --------------- $40,000 $26,719 -- - - - - -- -------- $2,913 -- - - - - -- -- - - - - -- $32,634 -- - - - - -- -- - - - - -- $22,000 -- - - - - -- -- - - - - -- -- - - - - -- -- - - - - -- $40,000 -- - - - - -- -- - - - - -- FINANCE DEPARTMENT The Finance Department is responsible to work with all departments of the City, especially the Administration Department, to ensure that all activities of the City are conducted in a fiscally responsible manner. GENERAL / 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. Beginning in 2012 also responsible for main line phone administration. DATA PROCESSING Provides for evaluation of appropriate computer hardware and software on a continuing basis. • Coordinates efforts between departments to assure an integrated information system. • Acts as an in -house consultant providing technical assistance when possible, and if not possible, coordinating the procurement of outside technical assistance when needed. TREASURY • Fund Management - Collects and deposits revenues and manages the investment of idle funds. • Budgetary - Compiles historical and current expenditure and revenue data to facilitate budget preparation. • Bonding - Assists in the issuance, sale and record maintenance of indebtedness. • Insurance - Maintains records for property and worker's comp insurance requirements, handles all property & liability claims and prepares documents for all yearly renewals of policies. If 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 processing, mailing, uploading 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. 10 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 special assessments records to confirm that Dakota County's assessment balances are correct and in agreement with ours. Works with the Engineering Department for additions to the special assessment system. Responsible for coordinating all deletions and changes to the system as well as all collections of special assessment payments not collected through property taxes. STAFFING • In 2014, the department will consist of eight positions: • Finance Director • Accounting Supervisor • IT Coordinator • Payroll Clerk • Accounts Payable Clerk • Utility Billing Clerks (2) • Accounting Clerk (Part -Time) 21 FINANCE DEPARTMENT - Page 4 PERFORMANCE MEASURES City Bond Rating 2008 2009 2010 2011 2012 2013 Aa3 Aa3 Aa2 Aa2 Aa2 Aa2 (4/16/10) GFOA Certificate of Achievement Award Received 2008 2009 2010 2011 2012 2013 Yes Yes Yes Yes (Applied) n/a # Of Accounts Payable Checks Processed 2008 2009 2010 2011 2012 2013 3,081 3,326 3,179 3,263 3,138 n/a # Of Utility Bills Processed 2008 2009 2010 2011 2012 2013 29,092 29,160 29,362 29,563 30,019 n/a n/a — Information Not Available Page One 2- �i 2014 BUDGET WORKSHEETS FINANCE June 25, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # - ----------- - - - - -- ---- ------ Description --------------------------------------- ---------- Actual ------- -- - -- - -- Actual --- -- ---- - - - - -- Actual -------- - - - - -- Budget -- Amount Budget Comments --------- - - -- --------- - - - --- --------- - -- - -- -------------------------------------------- All Salary Costs Inclusive of 101 41520 101.00 Salaries & Benefits $294,584 $303,823 $310,869 $318,800 $394,000 Salary, Taxes, PERA & Benefits 101 41520 102.00 Full -Time Overtime 2,327 2,302 570 2,300 1,500 101 41520 103.00 Part-Time Salaries & Benefits 41,202 43,796 46,816 47,800 0 Propose Making P/T Position F/T 101 4152001 321.00 Telephone Costs 1,245 1,293 1,324 1,400 1,400 Cell Phone Allowances (2) 101 4152001 331.00 Travel Expense 1,300 101 41520 01 331.01 Finance Director 457 358 372 1,200 1,200 Miscellaneous (National Added) 101 41520 01 331.02 Staff 0 0 99 100 100 101 41520 01 391.00 P.C. Maintenance 48,600 101 4152001 391.01 Civic Systems Applications Support 5,428 5,482 0 0 0 Moved to Utilities 101 4152001 391.02 Citrix Maintenance Renewal 962 1,656 962 1,000 1,000 101 41520 01 391.03 Incode Software Maintenance 7,939 7,967 8,334 8,700 8,700 101 41520 01 391.04 General Network Support 20,000 20,000 20,000 20,000 20,000 190 Hours of Support Time 101 41520 01 391.06 Fixed Asset Maint Contract 1,384 1,384 1,384 1,400 1,400 101 4152001 391.07 Miscellaneous Repairs & Maint. 902 1,793 2,335 2,500 2,500 101 4152001 391.08 Anti -Virus Software Renewal 4,866 3,023 3,063 5,000 3,000 101 4152001 391.09 File Server Software Maintenance 7,160 7,801 8,049 8,000 12,000 101 4152001 392.00 P.C. Accessories & Supplies 3,383 3,565 3,174 4,000 4,000 City System Supplies 101 41520 01 393.00 P.C. Hardware Purchases 2,351 1,892 2,412 2,500 2,500 101 41520 01 394.00 P.C. Software Purchases 5,000 101 41520 01 394.01 Annual Microsoft Office Payment 9,846 0 0 0 0 2015 End of Life for Office 2010 101 4152001 394.02 Miscellaneous S/W Purchases 3,008 5,286 3,605 5,000 5,000 101 41520 01 409.00 Other Contracted R & M 165 180 180 200 200 Non- Computer Equipment 101 41520 01 433.00 Dues & Subscriptions 800 101 41520 01 433.02 MnGFOA - Finance Director 60 60 60 70 70 101 41520 01 433.03 MnGFOA - Staff 360 360 360 380 380 101 41520 01 433.04 GFOA - Finance Director & Asst. 340 340 340 350 350 101 4152001 433.05 Magazine Subscriptions 0 0 0 0 0 101 41520 01 435.00 Books & Pamphlets 100 101 41520 01 435.01 Accounting Related Books 0 0 27 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) 565 571 571 1,000 1,000 101 41520 01 437.03 GFOA National Conf (F /D) 0 0 0 1,500 1,500 Cut for 2011 & 2012 101 41520 01 437.04 Staff Development 218 0 135 400 400 101 41520 01 437.05 Miscellaneous Seminars 652 292 314 400 400 Misc. Meetings, Lunches, etc. 101 41520 01 439.00 Other Miscellaneous Charges 151 114 34 200 200 Contingencies 101 41520 01 570.00 Office Equipment & Furnishings 910 969 495 1,000 500 PAGE TOTALS ----- ---- - - - --- $410,465 --------- - - - - -- $414,308 ---- ----- - - -- -- $415,886 ------ --- - - - - -- $435,300 -- ------- -- -- -- --------------- $463,400 DEPARTMENT TOTALS $410,465 -- - - - - -- -------- $414,308 -- - - - - -- -- - - - - -- $415,886 -- - -- - -- -- - - - - -- $435,300 -- -- - - -- -- - - - - -- -- - - - - -- -- - - - - -- $463,400 -- - - - - -- -- - - - - -- 2- �i GENERAL GOVERNMENT DUPLICATING & COPYING • Provides for maintenance agreements and expenses to operate copy machines at all City facilities. Also provides for digital document management costs. PRINTED FORMS & PAPER • Provides for copy paper utilized by all departments and provides for forms utilized by the Finance Department. ENVELOPES & LETTERHEADS • Provides for letterhead utilized by all departments and for various types and sizes of envelopes. OTHER OFFICE SUPPLIES • Provides for general office supplies utilized by all City departments. EQUIPMENT PARTS • Provides for the maintenance and repair of general office equipment. AUDITING & ACCOUNTING SERVICES • Provides for the annual audit of the City's accounting transactions for all funds of the City and for the preparation of the Comprehensive Annual Financial Report. Also provides for other services as required of the City's financial and accounting consultants. LEGAL FEES • Provides for general legal and special legal services provided by the City Attorney or other law firms utilized by the City for such services. 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 and other office machines at City Hall, Community Center and the Police Department. �fo Page One 2014 BUDGET WORKSHEETS GENERAL GOVERNMENT June 25, 2013 Account # Description 101 41810 01 202.00 Duplicating & Copying 101 4181001 202.01 Records Retention 101 41810 01 202.02 Copying Costs 101 41810 01 203.00 Printed Forms & Paper 101 41810 01 203.01 Copy Paper 101 41810 01 203.02 General Receipt Books 101 4181001 203.03 Purchase Orders 101 41810 01 203.04 Payroll & A/P Checks 101 41810 01 203.06 Miscellaneous Forms 101 4181001 204.00 Envelopes & Letterheads 101 4181001 204.01 Letterhead 101 41810 01 204.02 Plain Envelopes 101 41810 01 204.03 A/P & Payroll Envelopes 101 41810 01 204.04 10 x 13 Envelopes 101 41810 01 204.05 10 x 15 Envelopes 101 41810 01 209.00 Other Office Supplies 101 41810 01 221.00 Equipment Parts 101 41810 01 242.00 Minor Equipment 101 4181001 242.01 "Future Use" 101 4181001 242.02 Credit Card Equipment 101 4181001 301.00 Auditing & Accounting Services 101 41810 01 301.01 Audit & General Consulting Fees 101 4181001 301.02 Dakota County Assessment Fees 101 4181001 301.03 Dak Cty Truth In Taxation Costs 101 41810 01 303.00 Engineering Fees 101 41810 01 304.00 Legal Fees 101 4181001 319.00 Other Professional Services 101 41810 01 319.01 City Code Update 101 41810 01 319.02 City Code Web Fees 101 4181001 319.03 State Building Report (Springsteds) 101 4181001 319.04 Continuing Disclosure Fees 101 4181001 319.05 Annual User Fee Study Update 101 4181001 319.06 Arbitrage /Rebate Calculations 101 4181001 319.10 Wore Professional Services 101 4181001 320.00 Credit Card Activity Fees 101 4181001 320.01 Utilities' Fees 101 4181001 320.02 Parks & Recreation Fees 101 4181001 320.03 Building Fees 101 4181001 320.04 General Fees 101 4181001 321.00 Telephone Costs 101 4181001 321.01 General Phone Costs (& Internet) 101 4181001 321.02 Domain Housing 101 41810 01 321.03 Software Maintenance Costs 101 41810 01 321.04 Phone System Hardware 101 4181001 322.00 Postage Costs 101 4181001 339.00 Other Transportation Expenses 101 4181001 351.00 Legal Notices Publishing 101 4181001 351.01 Costs for Public Notices 101 4181001 351.02 Truth in Taxation Notices 101 4181001 351.03 Budget & Audit Publications 101 4181001 391.00 P.C. Maintenance 101 4181001 392.00 P.C. Software Purchases 101 4181001 393.00 P.C. Hardware Purchases 101 4181001 433.00 Dues & Subscriptions 101 41810 01 439.00 Other Miscellaneous Charges 101 4181001 450.00 Sales Tax on Purchases 101 41810 01 580.00 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 0 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual ------ --- - - -- -- Actual --------- - - - - -- Actual -------- --- - - -- Budget ---- ----- - - - - -- Amount ----- --- --- - - -- Budget -- ------- - - ---- Comments -------------------------------------------- $14,000 40 0 0 0 0 Moved to "391.00" Below 13,747 12,453 12,911 14,000 14,000 9,000 4,328 6,811 3,743 7,000 5,000 0 800 573 800 800 0 1,707 0 1,700 1,700 394 326 1,578 500 500 180 735 277 1,000 1,000 Business Cards, etc. 4,700 784 1,223 967 1,200 1,200 1,587 0 557 1,800 1,800 454 766 523 500 500 0 1,202 0 1,200 1,200 0 0 0 0 0 14,605 14,288 14,318 16,000 15,000 General Office Supplies 0 0 0 0 0 City Hall Equipment Repairs 300 0 0 0 0 0 0 0 1,106 300 300 $500 -$700 for One Terminal 70,000 56,045 59,383 56,932 64,000 62,000 4,389 5,456 5,614 6,000 6,000 1,913 1,860 1,554 2,000 2,000 8,163 5,402 11,738 0 0 55,007 60,931 51,637 80,000 60,000 General City Legal Fees 38,000 1,495 2,568 4,024 2,500 2,700 0 0 250 300 300 4,995 4,703 4,470 6,000 5,000 Fees Paid to Springsted 3,621 4,321 2,000 4,500 4,000 Fees Paid to Springsted (Bonds) 5,370 5,710 4,780 7,000 6,000 Fees Paid to Springsted 10,855 15,750 18,750 7,000 10,000 Fees Paid to Springsted (Bonds) 30,816 12,868 64,050 5,000 10,000 22,300 1,474 1,675 2,127 1,700 0 O/L Added - Moved to Utilities 5,437 5,692 5,012 6,000 6,000 12,095 16,319 12,824 15,000 15,000 814 1,258 1,093 1,300 1,300 44,100 42,188 43,928 41,133 39,000 34,000 Aded Fiber to Buildings in 2013 60 60 60 100 100 0 0 6,101 7,000 8,000 Added Additional Licenses 0 0 0 0 2,000 Phone Upgrades, Headsets, etc. 16,705 16,344 16,142 17,000 17,000 802 221 954 800 800 Vehicle Licensing 3,800 2,475 2,564 3,467 3,000 3,000 All Departments 0 0 0 300 300 Newspaper Notice Publication 123 457 648 500 500 State Mandated Publications 9,476 9,745 9,962 15,500 16,800 Laserfishe Maintenance 11,414 0 0 4,900 15,300 Laserfishe Software 2,200 0 2,707 4,300 6,600 Scanner Purchase 867 956 943 1,000 1,000 Newspapers 250 270 510 500 500 Direct Deposit Filing Fees /Flex 9,829 0 0 0 0 Sales Tax Audit 33,414 33,304 36,663 35,000 35,000 Office Machine Leases -All Bldgs. - -------- - - - - -- $368,411 --------- ---- -- $352,051 -------- -- - - - -- $402,695 ------ -- - - - - - -- $383,200 ------- -- - - - - -- --------------- $374,200 $368,411 $352,051 $402,695 $383,200 $374,200 0 COMMUNITY DEVELOPMENT OVERVIEW: MISSION, VISION AND GOALS The Community Development Department plays an important role as the City moves toward its mission of providing a safe, healthy and pleasant community in a fiscally responsible manner. The Building Inspection and Planning Divisions play a key role in making Rosemount a safe and pleasant community. These divisions are also involved in reaching the City Council's goals in affordable housing and property maintenance. The Economic Development Division addresses the City's vision statement by fostering opportunities to live, work and shop. The division helps the City enhance its hometown character and pride, for example, through downtown redevelopment. The division, along with the Rosemount Port Authority, plays a vital role in meeting goals of the City Council such as commercial enhancement and business growth. BUILDING INSPECTIONS • Is responsible for providing the services of building permit review, building inspection, code administration, consultation and review on new and existing buildings and structures within the City. • Is responsible for the maintenance and enforcement of city ordinances and codes relating to building, health, life safety, fire and environmental conditions and to assure local compliance with county, state and federal regulations relating to the same activities. • Is responsible for the successful implementation of all structural development and assuring regulated and controlled standards within Rosemount. • Is responsible for monitoring and permitting all individual sewage treatment systems within the City. • Is responsible for reports submitted to all appropriate jurisdictions concerning building activities. COMMUNITY DEVELOPMENT — Page 2 CODE ENFORCEMENT • Is responsible for enforcement of city ordinances and codes relating to health, life safety, environmental, and nuisance conditions and assure local compliance with county, state and federal regulations relating to the same activities. • Is responsible for sign ordinance implementation and permitting. • Is responsible for drafting of code text amendments to carry out Council goals and City initiatives. • Is responsible for rental housing inspection and permitting. • Is responsible for sequential code enforcement program, which is a city initiated program for resident education and neighborhood code compliance. PLANNING • Is responsible for reviewing proposed developments for compliance with the zoning and subdivision ordinance and coordinating interdepartmental staff review of all residential, commercial, institutional and industrial developments. • Is responsible for providing recommendations to Planning Commission and City Council on all deliberations concerning land use, zoning, variances, site plan reviews, platting and special permits (interim use permits, mining permits, etc.). • Is responsible for maintaining zoning and subdivision ordinances and the City's Comprehensive plan in compliance with county, state and federal requirements (statutes and rules). • Is responsible for long -range planning and special studies that guide the physical development of the community. • Is involved with state and regional activities affecting the City, including, but not limited to, land use, transportation, 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. 0 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. COMMUNITY DEVELOPMENT -- Page 4 PERFORMANCE MEASURES Planning Application Processed Within 60 Days 2008 2009 2010 2011 2012 2013 87% 86% 92% 83% 65% 18% Requested Inspections Completed Within One Day 2008 2009 2010 2011 2012 2013 n/a 100% 100% 100% 100% 100% Residential Plan Reviews Fully Completed Within 10 Working Days 2008 2009 2010 2011 2012 2013 n/a 90% 90% 86% 78% 76% Code Complaints Resolved 2008 2009 2010 2011 2012 2013 95% 99% 99% 99% 100% 72% Existing Businesses Visited 2008 2009 2010 2011 2012 2013 n/a 31 31 24 16 2 n/a — Information Not Available All 2013 figures are estimates for the first 4 months of the year. Page One 2014 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT June 25, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description - --- -------- - - -- -- --- -- - - --- ------------------ ----- ----- ----- ------- - - - - -- Actual ----- ---- - - - - -- Actual ---- ----- - -- - -- Actual ---- ----- - ---- Budget ---- Amount Budget Comments - ----- - - - --- - --- ----- - - - - -- -- -- --- ---- -- - --- --------------------------------------------- All Salary Costs Inclusive of 101 41910 101.00 Salaries & Benefits $870,501 $827,265 $840,012 $864,700 $895,200 Salary, Taxes, PERA & Benefits 101 41910 101.00 Economic Development Coor. 0 0 0 0 0 Proposed New Position 101 41910 102.00 Full -Time Overtime 1,695 1,020 407 1,000 1,000 101 41910 99 10100 Part-Time Salaries & Benefits 1,485 2,932 2,957 4,500 4,500 Planning Commission Members 101 4191001 201.00 Office Accessories 0 0 0 0 0 Calendars, Planners, etc. 101 41910 01 202.00 Duplicating & Copying 1,990 2,234 1,788 2,500 2,500 101 4191001 203.00 Printed Forms & Paper 2,640 765 0 1,500 1,000 Forms, Stickers, Tags, etc. 101 41910 01 205.00 Drafting Supplies 0 0 0 0 0 101 41910 01 208.00 Miscellaneous Supplies 89 106 19 0 0 101 41910 01 209.00 Other Office Supplies 438 232 71 600 600 Dictation Devices & Tapes 101 41910 01 219.00 Other Operating Supplies 1,397 1,110 242 1,500 1,500 101 41910 01 241.00 Small Tools 191 30 230 200 200 Inspectors' Tools 101 41910 01 302.00 Architects' Fees 0 0 0 0 0 101 4191001 319.00 Other Professional Services 5 0 0 1,000 1,000 Consultant 101 41910 01 329.00 Other Communication Costs 2,078 1,871 2,036 2,500 2,500 Cell Phones & Pagers 101 41910 01 331.00 Travel Expense 273 350 290 600 600 101 4191001 391.00 P.C. Maintenance 2,124 2,190 3,031 4,200 4,200 Permitworks Support 101 41910 01 392.00 P.C. Accessories & Supplies 0 0 223 300 300 101 41910 01 393.00 P.C. Hardware Purchases 0 0 0 0 0 101 41910 01 409.00 Other Contracted Repair & Maint. 0 0 0 0 1,500 Mow Weeds -From Street Maint. 101 41910 01 433.00 Dues & Subscriptions 3,300 101 41910 01 433.01 APA/AICP 1,360 1,390 1,425 1,500 1,500 101 41910 01 433.02 [CC 200 100 225 200 200 101 41910 01 433.03 AMBO 50 300 200 300 300 101 41910 01 433.04 10,000 Lakes 0 150 115 150 150 101 41910 01 433.05 "Future Use" 0 0 0 0 0 101 41910 01 433.06 Trade Magazines 85 85 0 200 200 101 41910 01 433.07 Planner's Journal 0 0 0 0 0 101 41910 01 433.08 Sensible Land Use Coalition 0 0 0 300 300 101 41910 01 433.09 AACEO /MAHCO 35 0 90 100 100 101 41910 01 433.10 Other Dues & Subscriptions 588 269 307 550 550 101 41910 01 435.00 Books & Pamphlets 452 549 467 700 700 Manuals, References, IBC Books 101 41910 01 437.00 Conferences & Seminars 7,600 101 41910 01 437.01 State Bldg Official School 421 365 400 550 550 101 41910 01 437.02 Spring & Fail Code Updates 255 400 400 400 400 101 41910 01 437.03 Building Inspector Training 1,040 669 756 1,000 1,000 101 41910 01 437.04 Computer Training 0 0 0 200 200 101 41910 01 437.05 Clerical Seminars 0 0 60 300 300 101 41910 01 437.06 Planning Seminars 268 328 320 2,000 2,000 101 41910 01 437.07 ISTS Training 426 150 500 500 500 101 41910 01 437.08 State Planning Conference (2) 0 1,258 589 1,400 1,400 101 41910 01 437.09 Planning Commissioner Training 48 82 435 200 500 101 41910 0143710 Gen'I Seminars 40 150 354 300 300 101 41910 01 437.11 Code Enforcement Training 146 44 0 450 450 101 41910 01 439.00 Other Miscellaneous Charges 100 0 0 400 400 Contingencies PAGE TOTALS ---- ----- --- --- $890,419 -- ---- --- - -- - -- $846,393 --------- --- - -- $857,950 -- ---- --- - --- -- $896,800 --- ----- - - --- -- --------------- -- $928,600 DEPARTMENT TOTALS $890,419 $846,393 $857,950 $896,800 $928,600 �1 POLICE DEPARTMENT The Police Department is responsible for policing services to the community to ensure safety and response to services calls. A Community Oriented Policing philosophy is core to all services through partnerships and relationships with citizens, businesses and community organizations. Staffing levels are continually evaluated to meet the needs of a growing community. The specific service functions within the Police Department are described below. POLICE ADMINISTRATION This budget provides for the overall leadership, 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. Police Department leadership is also involved in many consolidated services governance boards that contribute to policing services for the city. The Dakota Communications Center (DCC), Criminal Justice Integrated Information Network (CJIIN) Dakota County Drug Task Forces and Dakota County Multi- Agency Assistance Group (MAAG) are consolidated services organizations that contribute to Rosemount's policing services. RECORDS UNIT The Police Department's Records Unit is responsible for the processing of over 2,200 case reports each year. Reports require transcription and compilation for transmittal to the city or county prosecutor's office or any other agency (e.g., social services, county crises, corrections) requiring information for service to the community. Records staff ensure the Police Department is compliant with all Minnesota Bureau of Criminal Apprehension data management laws, regulations and reporting requirements. Administrative support is provided to the entire Police Department for gun permit applications, criminal background checks, and city licensing requirements. PATROL OPERATIONS Uniformed patrol is the core function of the Police Department and the most visible in the community. Through 24 hour daily patrols in marked police vehicles, patrol officers respond to calls for service, investigate traffic accidents, conduct preliminary criminal investigations, enforce traffic laws and enforce criminal laws. Patrol Officers respond to medical calls as trained first responders. Through patrol operations the Police Department meets its goal of the protection of life and property and creating a sense of safety and security in the community. Patrol Officers spend a significant amount of time developing relationships within the community and contacting members of community organizations. Patrol Officers perform additional specialty assignments as Crime Scene Technicians, Use -of -Force Instructors, Multi- Agency Assistance Group (MAAG) Tactical Officers, Drug Recognition Expert, and Field Training Officer. MIWIII 1 .40, POLICE DEPARTMENT — Page 2 CRIMINAL INVESTIGATION Patrol officers and investigators are responsible for the investigation of criminal incidents through evidence gathering and analysis, witness and suspect interviews, and court preparation and testimony. Complex investigations or those requiring a multi-jurisdictional or agency involvement are coordinated by the investigator. This is accomplished by working cooperatively with other police agencies, the County Attorney's Office, Child Protection, victim services and other local, state and federal law enforcement agencies. One investigator is assigned to the Dakota County Drug Task Force, a multi - jurisdictional joint powers entity, whose mission is to investigate drug crimes in the City of Rosemount and throughout Dakota County. 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 officer's 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. School Liaison - Officers serve as a liaison to the Rosemount Middle and High Schools. One officer is assigned full-time to the High School and a second officer spends one - quarter time at the Middle School. The liaison officers investigate criminal incidents that occur at the schools or that involve students at the schools. In addition, the liaisons work with the school staff to enhance the safety and security for both staff and students. Presentations on a variety of topics are made by the liaison to classes at all grade levels. The Middle School officer also spends time at each of the elementary schools, working with staff on any issues and making presentations in classes. Community Education - In order to work together with the community, police must share information concerning criminal activity and crime prevention with the community. Officers are available to make presentations to community groups and organizations on a variety of topics. In addition, officers provide prevention tips to persons on a daily basis who 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 Night -to -Unite block parties and gatherings, Neighborhood Watch meetings and Public Safety in the Park events. 3� POLICE DEPARTMENT — Page 3 Reserve Officer Program — Reserve officers are volunteers who supplement the staff of sworn officers of the Department. The reserve officers are utilized to handle traffic and crowd control duties during city festivals and celebrations or emergencies, such as hazardous materials spills or leaks, damage resulting from tornadoes or other severe weather and major criminal incidents. Reserve officers patrol on some evenings and handle service calls; for example, assisting stalled motorists and animal complaints. They are also utilized regularly to provide crime prevention information to citizens at community events or through other programs. Chaplain Program — The Police Chaplains 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 focus on their primary 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 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 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, school shooting, or hazardous materials release). The Chief of Police represents the City of Rosemount on the Dakota County Domestic Preparedness Committee ( DCDPC). The DCDPC is comprised of police, fire, dispatch, EMS, public health, and medical facility representatives to aid all Dakota County cities and Dakota County with all- hazards emergency planning and leadership. 91 L 2012 .99 2012 .20 2012 46 2012 270 1180 2012 659 2881 2012 57% 2012 119 520 r9i POLICE DEPARTMENT — Page 4 PERFORMANCE MEASURES Number of Licensed Officers per 1,000 Residents 2007 2008 2009 2010 2011 .97 .98 .97 .99 .99 Number of Non - licensed Employees per 1,000 Residents 2007 2008 2009 2010 2011 .21 .20 .20 .20 .20 Number of Car Crashes with Personal Injury Resulting 2007 2008 2009 2010 2011 33 30 45 30 23 Part I Crimes 2007 2008 2009 2010 2011 Total # 428 398 411 334 336 Reported Rate per 2196 1860 1872 1513 1469 100,000 Part 11 Crimes 2007 2008 2009 2010 2011 Total # 1020 952 809 686 719 Reported Rate per 5248 4450 3686 3109 3143 100,000 Case Clearance Rate of Reported Crimes (Percent Solved) 2007 2008 2009 2010 2011 61% 62% 53% 52% 54% DWI Arrests 2007 2008 2009 2010 2011 Number 251 236 141 101 106 of Arrests Rate per 1291 1291 642 457 463 100,000 2012 .99 2012 .20 2012 46 2012 270 1180 2012 659 2881 2012 57% 2012 119 520 r9i POLICE DEPARTMENT — Page 5 Night to Unite (National Night Out) Neighborhood Parties 2007 2008 2009 2010 2011 2012 Number 25 31 36 25 33 34 of Events Response Time to Priority 1 Calls for Service ( * *) 2007 2008 2009 2010 2011 2012 5.97 6.38 6.22 6.24 6.75 6.24 n/a — Information Not Available 3(p Page One 2014 BUDGET WORKSHEETS POLICE June 25, 2013 Account # Description 101 42110 101.00 Salaries & Benefits 101 42110 102.00 Full -Time Overtime 101 42110 102.01 Regular Overtime Hours 101 42110 102.02 Contracted O(f 101 42110 103.00 Part-Time Salaries & Benefits 101 42110 22 103.00 Part-Time Receptionist (2) 101 42110 22 103.00 Part-Time Secretary 101 42110 99 103.00 Part-Time CSO's 101 42110 01 202.00 Duplicating & Copying 101 42110 01 203.00 Printed Forms & Paper 101 42110 01 204.00 Envelopes & Letterheads 101 42110 01 207.00 Training & Instructional Supplies 101 42110 01 207.01 Practice Ammunition 101 42110 01 207.02 Service Ammunition 101 42110 01 207.03 Other Supplies 101 42110 01 207.04 M.A.A.G. Ammunition 101 42110 01 208.00 Miscellaneous Supplies 101 42110 01 208.01 DARE Donations 101 42110 01 208.02 Equipment Donations /Forfeitures 101 42110 01 209.00 Other Office Supplies 101 42110 01 211.00 Cleaning Supplies 101 42110 01 211.01 Blanket Cleaning 101 42110 01 211.02 Squad Interior Cleaning 101 42110 01 217.00 Clothing Allowance 101 42110 01 217.01 CSO's 101 42110 01 217.02 Reserves 101 42110 01 217.03 Other Supplies 101 42110 01 219.00 Other Operating Supplies 101 42110 01 219.01 Evidence Bags, Drug Kits, Misc. 101 42110 01 219.02 Accurint Database Services 101 42110 01 221.00 Equipment Parts 101 42110 01 241.00 Small Tools 101 42110 01 241.01 Evidence Processing Equipment 101 42110 01 241.02 Camera and Video Supplies 101 42110 01 241.03 Other Supplies 101 42110 01 242.00 Minor Equipment 101 42110 01 242.01 Less Lethal Tactical Equipment 101 42110 01 242.02 MAAG Equipment 101 42110 01 304.00 Legal Fees 101 42110 01 305.00 Medical & Dental Fees 101 42110 01 305.01 Physicals 101 42110 01 305.02 Seized Narcotic Testing 101 42110 01 306.00 Personnel Testing & Recruitment 101 42110 01 313.00 Temporary Service Fees 101 42110 01 315.00 Special Programs 101 42110 01 316.00 Animal Care Services 101 42110 01 316.01 Impound & Care Fees 101 42110 01 316.02 "Future Use" 101 42110 01 319.00 Other Professional Services 101 42110 01 319.01 Dispatch Services - Operations 101 42110 01 319.02 Policy Development & Training 101 42110 01 319.03 Mediation Services 101 42110 01 321.00 Telephone Costs 101 42110 01 321.01 Cell Phones 101 42110 01 321.03 "Future Use" 101 42110 01 323.00 Radio Units 101 42110 01 323.01 Radios 101 42110 01 323.02 Radars 101 42110 01 323.03 Radio Warranty 101 42110 01 331.00 Travel Expense 101 42110 01 331.01 MN Chiefs Spring Conference 101 42110 01 331.02 IACP or FBINAA Conference 101 42110 01 331.03 Outstate Investigations & Conf. 101 42110 01 331.04 MAAG Conference 101 42110 01 331.05 CAN -AM Narcotic Conference 101 42110 01 331.06 Juvenile Officers Conference 101 42110 01 331.07 Meeting Reimbursements PAGE TOTALS 2010 Actual 2011 Actual 2012 Actual 2013 Adopted Budget 2014 Object Detail Amount 2014 Proposed Budget Comments All Salary Costs Inclusive of $2,342,838 $2,356,994 $2,416,057 $2,450,900 $2,666,800 Salary, Taxes, PERA & Benefits 66,069 75,223 67,587 70,000 72,500 Propose New Sergeant 7/1114 53,500 COLA & Explorer Post Time 19,000 63,400 37,691 50,322 56,194 53,000 0 Made 1 F/T Position for 2014 16,025 14,530 12,194 19,000 21,500 PIT Secretary - 14 Hours/Wk 35,777 33,759 28,286 39,000 41,900 CSO's - Up To 50 Hours/Wk 0 0 0 0 0 846 975 1,442 1,200 1,200 Evid. Logs, Animal Lic, E- Tickets 0 388 0 200 200 Business Cards 11,600 4,739 4,963 4,898 5,000 5,250 Ammo Cost Increase 0 546 1,042 1,000 1,000 0 27 233 100 100 4,322 4,920 4,999 5,000 5,250 Ammo Cost Increase 0 Donated & Forfeited Funds 2,409 156 226 0 0 7,279 6,875 6,489 0 0 1,019 245 456 1,000 1,000 Videos & CD's 500 0 0 0 0 0 621 321 107 500 500 2,500 269 1,661 900 750 750 1,299 550 998 1,000 1,000 289 1,860 1,335 750 750 3,000 2,190 983 1,319 2,000 2,000 859 871 740 1,000 1,000 2,457 3,199 2,965 3,000 3,000 Squad Emergency Equip Repairs 3,900 Crime Scene Kit Supplies 682 1,084 725 750 800 430 1,140 1,229 2,000 2,000 Squad Camera Maintenance 395 407 433 750 1,100 Digital Recorders Warranty 1,500 1,177 937 0 1,000 1,000 Training Supplies, Taser Batteries 667 688 0 500 500 56,652 57,780 59,802 61,200 62,500 Prosecution - 2% Increase 2,000 380 380 623 1,000 1,000 761 427 85 1,000 1,000 Blood Draws 0 1,329 425 1,000 1,000 Medical & Psychological 764 14 458 800 800 Interpreter Services 0 0 0 0 0 3,100 12,226 7,632 3,078 3,000 3,100 Estimated Costs / History 0 0 0 0 0 356,500 297,671 307,043 290,111 338,400 354,700 0 6,850 2,650 3,700 800 IACP Net Replaces Lexipol 0 0 0 1,000 1,000 5,400 5,953 5,137 5,150 5,400 5,400 0 0 0 0 0 14,000 9,648 10,674 10,239 11,500 11,500 800 MHz Subscriber Fees 831 0 0 500 500 Radar & LIDAR Repairs 0 0 0 1,700 2,000 Warranty Radio Increase 4,500 297 271 384 500 500 0 0 0 2,000 2,000 Chief Will Not Attend in 2013 117 352 520 500 500 201 380 0 600 600 285 318 237 300 300 210 440 661 500 500 130 139 99 100 100 2,916,475 2,962,788 2,985,375 3,094,100 'J 3,280,900 3� Page Two 2014 BUDGET WORKSHEETS POLICE June 25, 2013 Account # Description 101 42110 01 333.00 Freight & Express Expenses 101 42110 01 394.00 P.C. Software Purchases 101 42110 01 394.01 Automated Pawn System 101 42110 01 394.02 Pictometry 101 42110 01 394.03 CJIIN System 101 42110 01 396.00 Computer Maintenance 101 42110 01396 .O 1 Records Management 101 42110 01 396.02 CJDN Connection Charges 101 42110 01 396.03 MCD Connection Charges 101 42110 01 396.04 MCD Maintenance & Cellular 101 42110 01 396.05 LOGIS Annual Fees 101 42110 01 433.00 Dues & Subscriptions 101 42110 01433.01 Multi- Agency Assistance Group -MAAG 101 42110 01 433.02 IACP Chiefs 101 42110 01 433.03 MN Chiefs of Police 101 42110 0143104 Dakota Cty Chiefs of Police 101 42110 01 433.05 Wakota CAER 101 42110 01 433.06 Metro Emergency Managers 101 42110 01 433.07 MN Sex Crimes Investigators 101 42110 01 433.08 Tri- County Investigators 101 42110 01 433.09 MN Crime Prevention Association 101 42110 01 433.10 P.O.S.T. Licenses 101 42110 01 433.11 FBI Nat'l Academy Association 101 42110 01 433.12 Miscellaneous 101 42110 01 435.00 Books & Pamphlets 101 42110 01 436.00 Towing Charges 101 42110 01437.00 Conferences & Seminars 101 42110 01437.01 Firearms - Range 101 42110 01437.02 Chiefs Spring Conference 101 42110 01 437.03 Investigations 101 42110 01 437.04 IACP Conference 101 42110 01437.05 Supervision 101 42110 01 437.06 Use of Force 101 42110 01 437.07 Emergency Driving 101 42110 01437.08 First Aid 101 42110 01 437.09 Narcotic Enforcement 101 42110 01 437.10 Tactical 101 42110 01 437.11 Support Services 101 42110 01 437.12 Patrol Ops, 101 42110 01437.13 Emergency Management 101 42110 01 439.00 Other Miscellaneous Charges 101 42110 01 580.00 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 110 13 19 200 200 Repairs 37,300 240 204 204 300 300 1,193 1,538 0 0 0 In Public Works Budget 10,474 11,610 7,314 6,000 37,000 CJIIN /ProPhoenix RMS 33,500 32,172 33,120 33,852 34,700 3,000 LOGIS APS Support 3,904 2,520 4,509 2,800 2,800 State of MN CJDN Connection 1,744 1,845 0 2,000 2,100 LOGIS MDC Connection Chgs. 17,316 18,432 17,557 19,000 21,000 7,763 7,890 8,188 8,500 4,600 Development Fund 10,200 3,200 3,200 5,000 5,000 8,300 MAAG Equipment CIP Increase 120 170 120 175 175 265 265 0 265 265 35 0 50 50 330 Chief and Lieutenant 0 0 0 0 0 0 0 0 0 0 0 0 0 20 20 50 50 50 50 50 60 0 60 65 65 720 360 1,080 700 700 0 0 0 0 75 Chiefs Membership 155 35 225 175 220 281 0 0 1,000 1,000 Crime Prevention Materials 0 168 103 200 200 Disabled Squads 13,500 988 2,113 4,790 4,000 4,000 Range Rental 325 420 375 500 500 731 921 1,032 1,200 1,200 0 0 0 300 300 675 25 8,875 500 2,000 Personnel Development 750 2,380 0 1,000 1,000 420 1,730 675 1,000 1,000 0 400 250 400 400 100 100 100 200 200 280 1,450 1,750 1,000 1,000 1,017 123 555 200 200 3,325 820 660 1,500 1,500 0 0 755 200 200 1,188 187 808 500 500 Refreshments for Meetings & Compliance Checks 0 0 0 0 2,500 3 Chairs & Desk $89,600 $92,090 `^ $98,957 $93,700 r $98,900 $3,006,075 --- - - - - -- --------- $3,054,877 --- - - - - -- --- - - - --- $3,084,331 --- -- - - -- - -- - - - - -- $3,187,800 --- -- - - -- --- --- -- - - -- --- - - - - -- -- - - -- $3,379,800 --- - - - - -- --- - - - - -- 4�y 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. �n FIRE DEPARTMENT — Page 2 Provides for the investigation of fires by the local Fire Marshal. Also provides for the coordination of joint investigations by the local Fire Marshal and the State Fire Marshal. RESCUE SQUAD • Provides for emergency operations pertaining to bodily injury or serious illness requiring emergency services within the City of Rosemount, both to its citizens and visitors. • Provides for emergency operations pertaining to bodily injury or serious illness requiring emergency services within the contracted areas of Coates and the University of Minnesota. Provides for the provision of all of these emergency operations to all the cities of Dakota County and many of the cities of Washington County via a mutual aid agreement by which these services can be reciprocated on an as needed basis. HAZARDOUS MATERIAL RESPONSE / CONFINED SPACE RESPONSE • Provides a team of Operations Level, Technician Level and Specialists, trained to respond to hazardous material accidents, identify, secure and coordinate the efforts of outside agencies that are trained to contain, mitigate and clean up the spill. • Trains all firefighters to respond to confined space incidents, evaluate the situation and mitigate or coordinate the rescue effort. WATER/ICE RESCUE Provide technical water rescue during emergency situations to include the use of inflatable boats, throwing devices, water rescue suits and row boats.. 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. 40 FIRE DEPARTMENT — Page 3 • Allows for training of fire fighters to prepare themselves for the acceptance of a position of leadership within the Fire Department. 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 2012, the Fire Department consisted of 44 paid on -call firefighters serving in various capacities within the department. The number is constantly changing due to retirements and new additions. We have seven people who have reached or exceeded full retirement requirements, but often people retire prior to the full 20 years. We hope to end 2013 with a department of not less than 45 firefighters. 1I+ n/a — Information Not Available 41 FIRE DEPARTMENT — Page 4 PERFORMANCE MEASURES Total Number of Paged Calls 2008 2009 2010 2011 2012 Fire 229 303 298 288 351 Medical 540 329 332 402 373 Average Response Time: High Priority Calls 2008 2009 2010 2011 2012 n/a n/a 7:41 7:24 6:52 Number of Attendances at Outside Training 2008 2009 2010 2011 2012 10 36 20 28 46 Total Number of Fire Fighters 2008 2009 2010 2011 2012 Total 43 42 43 44 44 Added 4 5 1 5 3 Net Change 2 -1 1 1 0 Number of Customer Complaints 2008 2009 2010 2011 2012 0 1 0 1 0 Insurance Industry Rating of Fire Services (ISO Rating) 2008 2009 2010 2011 2012 City 5 5 5 4/5 4/5 Rural 9 9 9 10 10 n/a — Information Not Available 41 Page One 2014 BUDGET WORKSHEETS FIRE June 25, 2013 Account # Description 101 42210 103.00 Salaries & Benefits 10142210 103.01 Salaries 101 42210 103.02 Training Pay /Stipends 101 42210 103.03 Call Pay /Stipends 101 42210 103.04 Class Pay /Stipends 101 42210 01 202.00 Duplicating & Copying 101 42210 01 202.01 Copy Toner 101 4221001 202.02 Computer Printers 101 4221001 204.00 Envelopes & Letterhead 101 42210 01 204.01 Envelopes 101 4221001 204.02 Letterhead 101 42210 01 204.03 Forms 101 42210 01 211.00 Cleaning Supplies 101 42210 01 211.01 Soaps 101 42210 01 211.02 Chamois, Towels, etc. 101 42210 01 211.03 Sponges, etc. 101 42210 01 211.04 SCBA Cleaner 101 42210 01 218.00 Fire Department Clothing 101 42210 01 218.01 Uniforms 101 42210 01 218.02 Station Wear (2015) 101 4221001 219.00 Other Operating Supplies 101 4221001 219.01 Gloves 101 42210 01 219.02 Bandages 101 42210 01 219.03 Equipment 101 42210 01 219.04 Tyvek Suits 101 42210 01 219.05 Consummable Medical 101 42210 01 219.06 Oxygen 101 42210 01 229,00 Other Maintenance Supplies 101 42210 01 229,01 Vehicle Repairs 101 42210 01 229,02 Pickup Trucks 101 42210 01 229.03 Rescue & Other 101 42210 01 229.04 Vehicle Modifications 101 42210 01 230.00 Equipment Repair Materials 101 42210 01 230.01 Light Bars 101 42210 01 230.02 Smoke Machines 101 42210 01 230.03 Lanterns & Miscellaneous 101 42210 01 230.04 Small Tool Repairs 101 42210 01 230.05 Opticom 101 4221001 230.06 Station 101 42210 01 241.00 Small Tools 101 42210 01 241.01 Axes, Bars & Other 101 42210 01 241.02 Grass Fire 101 42210 01 241.03 Hand Tools 101 42210 01 305.00 Medical & Dental Fees 101 4221001 306.00 Personnel Testing & Recruitment 101 42210 01 306.01 New Physicals (4) 101 4221001 306.02 Hepatitis Shots (4) 101 42210 01 306.03 Background Checks (4) 101 4221001 306.04 Drug Testing (4) 101 4221001 308.00 Instructors' Fees 101 4221001 308.01 Fire Fighter 1 (4) 101 4221001 308.02 Fire Fighter 1 Certificates (4) 101 4221001 308.03 Fire Fighter Re- Certificates (14) 101 4221001 308.04 First Responder (4) 101 42210 01 308.05 First Responder Refresher (1/2) 101 42210 01 308.06 Outside Schools 101 42210 01 308.07 Haz -Mat Training (4) 101 42210 01 308.08 Other Re- Certificates (2) PAGE TOTALS 43 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual -- --- -- - --- --------- Actual - - - - -- Actual -- ---- --- -- - --- Budget ---------- -- Amount - Budget Comments - ------ -- - - - -- ------- - - - - - -- -------------------------------------------- All Salary Costs Inclusive of $54,192 $56,593 $110,441 $172,000 $172,000 Salary, Taxes, PERA & Benefits 32,000 0 140,000 0 100 414 0 0 50 50 0 97 77 50 50 100 0 0 0 25 25 0 0 0 25 25 0 293 106 50 50 800 293 835 358 550 550 0 0 0 50 50 18 0 0 50 50 118 0 0 150 150 453 1,013 1,152 1,400 0 0 0 400 1,000 5 Uniforms @ $200 Each 0 0 0 1,000 400 Next - 2015 4,800 Medical Supplies 500 535 1,105 1,000 1,000 0 0 0 100 100 0 2,076 365 1,000 1,000 0 0 0 100 100 2,953 3,531 1,301 2,200 2,200 160 175 198 400 400 700 0 0 419 400 400 70 0 0 0 0 11 0 0 0 0 2,223 0 1,576 300 300 1,500 0 0 0 100 100 0 0 0 300 300 274 908 566 300 300 712 734 1,258 600 600 0 0 D 100 100 628 339 910 100 100 700 675 354 0 150 150 29 166 0 250 250 971 673 101 300 300 3,604 3,339 3,377 3,800 3,800 Annual Medical Tests 2,400 408 2,237 1,004 1,600 1,600 106 0 131 500 500 121 122 146 100 100 0 0 0 200 200 9,000 2,500 449 468 1,600 1,600 590 225 375 280 280 200 360 140 280 280 1,455 1,200 777 1,000 1,000 1,200 0 1,200 1,200 1,400 5,547 3,065 6,452 3,300 3,300 1,000 0 0 1,000 1,000 0 60 0 40 140 ---- -- ---- -- 81,429 - ----- --- - - -- -- 79,378 ---- --- -- - --- 134,002 ------ --- - - - --- 197,000 - --- ---- - - - - --- --------------- 197,300 43 Page Two 2014 BUDGET WORKSHEETS FIRE June 25, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # -- ----- ----- - - - - -- ---- ---- -- Description -------------------- -- ---- ------- --- ----- - - - - -- Actual -- -- ---- -- - - -- Actual ----- --- - - - - -- --- Actual ----- - -- - -- Budget - ------ -- - - - --- Amount -- ------- - - - - -- Budget Comments ---- ----- - - -- -- --------------------------------------------- 101 42210 01 310.00 Testing Services 2,700 101 42210 01 310.01 Aerial 1,336 1,188 1,172 1,000 1,000 101 42210 01 310.02 Ladders 0 0 0 500 500 101 42210 01 310.03 Pumpers (3) (Next 2014) 0 0 675 1,200 1,200 101 4221001 310.04 SCBA Hydro Testing (Next 2016) 0 0 0 0 0 101 42210 01 313.00 Temporary Service Fees 12,600 101 42210 01 313.01 SCBA Maintenance 1,112 4,771 8,182 4,000 4,000 101 42210 01 313.02 SCBA Flow Test 1,551 0 247 2,000 2,000 101 4221001 313.04 Security Contract 559 641 587 800 800 101 4221001 313.05 SOT Joint Powers 2,605 2,605 3,496 5,800 5,800 101 4221001 314.00 Annual Fire Relief Contribution 161,200 166,000 171,000 171,000 171,000 101 4221001 319.00 Other Professional Services 2,200 Fire Prevention Education 101 4221001 319.01 School Literature 59 461 0 400 400 101 42210 01 319.02 Door Prizes 0 150 10 200 200 101 4221001 319.03 Fire Prevention Week Promos 833 703 1,182 700 700 101 42210 01 319.04 Food at Open House 353 350 277 300 300 101 4221001 319.05 Summer Park Education 313 0 309 0 0 101 4221001 319.06 National Night Out 95 621 98 600 600 101 42210 01 321.00 Telephone Costs 2,100 101 42210 01 321.01 Cell Phones 542 802 2,050 300 300 101 42210 01 321.02 Computer Cards 318 44 0 1,800 1,800 101 4221001 321.03 "Future Use" 0 88 0 0 0 101 42210 01 321.04 Numeric Pagers 0 0 0 0 0 101 42210 01 322.00 Postage Costs 0 0 258 100 100 UPS Costs 101 42210 01 329.00 Other Communication Costs 17,000 101 4221001 329.01 Base Repairs 0 0 159 300 300 101 42210 01 329.02 Pager Repairs 546 282 608 1,000 1,000 101 42210 01 329.03 Hand Held Repairs 0 252 605 300 300 101 4221001 329.04 Mobile Repairs 0 0 0 200 200 101 4221001 329.05 800 MHZ User Fee 10,356 10,604 9,769 14,000 14,000 101 4221001 329.06 Mobile Computers 0 0 371 1,200 1,200 Monthly Air Time Fees 101 4221001 331.00 Travel Expense 3,900 101 4221001 331.01 Minnesota Chiefs Conference 1,621 854 2,500 2,000 2,000 101 4221001 331.02 Fire Department Association 1,852 1,572 1,647 1,600 1,600 101 42210 01 331.03 Outside Schools 710 168 0 300 300 101 4221001 333.00 Freight & Express Expense 0 0 0 0 0 101 42210 01 433.00 Dues & Subscriptions 1,500 101 42210 01 433.01 Capital City 50 50 50 50 50 101 42210 0143102 VFBA Insurance 328 305 361 350 350 101 4221001 433.03 State Fire 360 710 720 725 725 101 42210 01 433.04 State Chiefs 530 0 291 250 250 101 42210 01 433.05 DCFC 75 75 75 75 75 101 42210 01 433.06 WAKOTA Mutual Aid 50 50 50 50 50 101 4221001 433.07 Purchasing Consortium 0 0 0 0 0 101 42210 01 433.08 NFPA 0 0 0 0 0 101 42210 01 433.09 "Future Use" 0 0 0 0 0 101 42210 01 437.00 Conferences & Seminars 900 101 4221001 437.01 State Fire Conference 0 0 0 400 400 101 4221001 437.02 State Chiefs Conference 565 487 630 500 500 101 42210 01 439.00 Other Miscellaneous Charges 2,400 101 42210 01 439.01 Food & Coffee 81 664 480 700 700 101 4221001 439.02 Extinguisher 0 559 692 550 550 101 4221001 439.03 Plaques 13 221 51 50 50 101 42210 01 439.04 Paint 0 360 0 100 100 101 4221001 439.05 Station Needs 1,346 5,419 880 1,000 1,000 101 4221001 580.00 Other Equipment Purchases 23,600 101 4221001 580.01 Bunker Gear (8) 20,614 17,423 19,067 18,600 18,600 101 42210 01 580.02 Pagers 7,015 0 0 2,000 2,000 Replacements 101 4221001 580.03 Hose & Fittings 0 1,719 2,901 1,000 1,000 101 4221001 580.04 Replace Damaged Items 1,960 4,760 380 2,000 2,000 101 42210 01 581.00 Other Equipment Purchases 0 0 0 0 0 101 4221001 586.00 Other Equipment Purchase 0 7,196 19,900 0 0 Donation Items PAGE TOTALS - -------- - - - - -- $218,950 - -- ----- - --- - -- $232,151 - -------- -- - --- $251,729 --- ------ - - - - -- $240,000 -------- - - - - -- --------------- $240,000 DEPARTMENT TOTALS $300,379 -- - - - - -- -------- $311,529 -- - - - - -- -- - - - - -- $385,731 -- - - - - -- -- - - - - -- $437,000 -- - - - - -- -- - - - - -- - - - - - - -- -- - - - - -- $437,300 -- - - - - -- -- - - - - -- 44 PUBLIC WORKS The Public Works Department has a mission to enhance the quality of life through responsive, efficient, and cost - effective delivery of services consistent with community values. With sound management, fiscal responsibility and professional care, the Department will preserve and protect the infrastructure resources of the City, creating a safe, clean and enjoyable environment for residents and businesses. The Public Works Department consists of the Engineering and Operations Divisions. The maintenance personnel maintain the streets, storm drainage, sanitary sewer and potable water systems, along with all government buildings, parks and all City grounds. The Department manages its expenditures and revenues through the following four (4) maintenance funds and three (3) enterprise funds: Government Buildings Fleet Maintenance Street Maintenance Parks Maintenance ( *) Water Operating ( *) Sewer Operating ( *) Storm Water Operating ( *) Separate Enterprise Fund Budgets from those included here under the advisement of the Utility Commission of the City of Rosemount. The Public Works Department currently has a combined permanent work force of 24 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. �F5 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 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 units of large and small equipment. It provides funding for all fuels, oils, parts, tires, shop supplies, and contracted vehicle maintenance. The City -owned vehicles include: • Police Department (11 cars, 3 trucks) • Fire Department (6 pickup trucks, 7 fire /rescue trucks) • Parks and Recreation (1 truck, 2 vans, 1 car, 1 ice resurfacer) • Administration / Community Development (2 cars, 2 trucks, 1 van) • Utility Department (1 fetter, 1 Vactor, 2 trucks) • Streets and Parks Maintenance (2 sweepers, 3 tractors, 2 loaders, 2 skidsters, 6 dump trucks, 1 water truck, 6 mowers, 13 trucks, 1 roller, 1 ATV, 4 snow blowers) • 5 large trailers STREET MAINTENANCE This budget provides for the maintenance and preservation of 105 miles of City roads, 92 miles of sidewalks and bike trails, and 20 parking lots. Standard maintenance includes grading, graveling, patching, sealing and overlays. This budget also provides for pavement markings, street signs, street lighting, signal light maintenance and power, snow and ice control, and street sweeping. PARKS MAINTENANCE This budget provides for the maintenance of over 360 acres of park area in 25 locations, including 13 parks with athletic fields, 12 parks with shelters or pavilions, and athletic fields at DCTC. 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, 3 pleasure rinks), and other miscellaneous construction activities. z PUBLIC WORKS — Page 3 PERFORMANCE MEASURES Average Overall (Network) City Street Pavement Condition Rating 2008 2009 2010 2011 2012 2013 n/a n/a 73.83 73.69 n/a n/a Value of Projects Ordered (Contract Amount) 2008 2009 2010 2011 2012 2013 est $4,057,030 $1,414,284 $5,400,000 $5,462,900 $4,193,954 $4,300,000 % Change from Prior Year (Above) 2008 2009 2010 2011 2012 2013 est 28.45% -65.1% 282% 0.1% -23.2% 2.5% Average Number of Hours for Full Snow Clearing Event 2008 -09 2009 -10 2010 -11 2011 -12 2012 -13 2013- 14(est n/a 7.125 6.80 6.92 7.70 7.0 % of Mechanics' Time Spent on Repair / Maintenance 2008 2009 2010 2011 2012 2013 (es!) 93% 96% 93% 97% 92% 95% Park Acres Maintained 2008 2009 2010 2011 2012 2013 127 133 133 134 134 134 n/a — Information Not Available 4-1 Page One 2014 BUDGET WORKSHEETS GOVERNMENT BUILDINGS June 25, 2013 Account # Description 101 41940 101.00 Salaries & Benefits 101 4194079 101.01 Facility Specialist 101 41940 102.00 Full -Time Overtime 101 41940 01 208.00 Miscellaneous Supplies 101 41940 01 219.00 Other Operating Supplies 101 41940 01 223.00 Building Repair Supplies 101 4194001 225.00 Landscaping Materials 101 41940 01 241.00 Small Tools 101 41940 01 242.00 Minor Equipment 101 4194001 302.00 Architects' Fees 101 4194001 318.00 Contract Engineer 101 41940 01 319.00 Other Professional Services 101 41940 01 319.01 Elevator Maintenance 101 4194001 319.02 Heating /Cooling Maint Contract 101 41940 01 319.03 Annual Boiler Inspections / Maint. 101 41940 01 319.04 Pest Control 101 4194001 319.05 Fire Extinguishers 101 4194001 319.06 Fire Suppression System Check 101 4194001 319.07 Janitorial Service -Fire Stations 101 4194001 319.08 Janitorial Service -P.W. Building 101 4194001 319.09 Janitorial Service -City Hall 101 4194001 319.10 Floor Mats - Monthly Charges 101 4194001 319.11 Other Janitorial Services 101 4194001 319.12 Annual Monument Maintenance 101 4194001 321.00 Telephone Costs 101 41940 01 381.00 Electric Utilities 101 4194001 383.00 Gas Utilities 101 41940 01 384.00 Refuse Disposal 101 41940 01 384.01 General Buildings & Parks 101 41940 01 384.02 Recycling /Cleanup 101 41940 01 39100 P.C. Hardware Purchases 101 41940 01 401.00 Contracted Building Repairs 101 4194001 401.01 Electrical Repairs 101 41940 01 401.02 Siren Replacement Program 101 41940 01 401.03 Miscellaneous Repairs 101 4194001 401.04 Roof Inspections 101 4194001 439.00 Other Miscellaneous Charges 101 41940 01 530.00 Improvements Other Than Buildings 101 41940 01 601.00 Bond Principal 101 41940 01 611.00 Bond Interest 101 41940 01 621.00 Bond Paying Agent Fees PAGE TOTALS DEPARTMENT TOTALS 4x 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual - ---- ---- - - - --- Actual - -- -- --- --- - - -- Actual -- - -- -- Budget Amount Budget Comments ----- -- - --------- - - -- -- ------ --- - -- - -- ----- ---- -- - - -- ----------------------------------------------- All Salary Costs Inclusive of $73,400 Salary, Taxes, PERA & Benefits 0 0 26,690 71,200 73,400 80% of F/T Person 0 0 513 0 0 15,626 16,542 16,726 17,000 17,000 Cleaning Supplies, Towels 0 0 1,754 2,000 2,000 Flags 9,030 13,423 14,961 9,200 13.000 947 941 1,122 1,500 1,500 Trees & Shrubs (CH in 2014) 246 228 262 200 200 Hand Tools, Bits, Blades, etc. 811 1,996 1,341 2,000 2,000 Equipment Replacement 0 0 0 0 0 Estimates 1,500 1,750 2,000 1,800 1,800 Contracted Engineer for City (5 %) 81,500 2,051 1,832 1,853 1,500 2,000 7,646 6,167 8,637 8,000 9,000 Includes all City Facilities 120 647 50 800 800 2,210 2,505 3,051 2,500 3,000 1,769 1,135 1,397 1,800 1,800 3,131 3,033 3,375 3,500 3,500 10,016 10,016 9,896 10,100 10,100 10,529 10,529 10,529 10,600 10,600 24,534 24,534 26,446 24,600 26,500 Additional Day in PD 3,257 3,578 3,474 4,000 4,000 4,701 6,946 8,211 9,200 9,200 Wax Flrs, Carpet Cing, Windows 0 800 1,025 1,000 1,000 $900 - $1200 (Hot Wax) 0 0 0 0 700 Air Card for iPad- Monthly Chgs 63,008 66,212 68,950 70,000 77,000 Anticipated Rate Increase 46,942 51,688 44,796 62,000 55,000 37,000 15,713 18,377 18,480 19,000 20,000 Add UMore in 2014 11,090 13,535 15,597 14,000 17,000 Increased Recycling Costs 0 0 0 0 0 iPad for Maintenance Worker 52,000 1,839 3,027 5,740 4,000 4,000 8,157 311 9,949 10,000 10,000 24,462 27,419 35,544 28,000 38,000 Garage Doors, HVAC, etc. 0 0 210 0 0 0 0 7,154 5,000 5,000 Energy Efficiency Improvements 69,836 69,944 76,000 60,000 85,000 Next 5 -year Average Expenditure 41,886 60,526 490,526 65,400 0 Will Be Paid from Assigned Funds 33,717 24,973 22,416 20,600 0 Will Be Paid from Assigned Funds 1,549 0 775 0 0 - ----- --- - -- --- $416,324 - ---- ---- --- - -- $442,613 ------- - - - --- $939,448 --- -- ---- - - - - -- $540,500 -- ---- --- --- --- --------------- $504,100 $416,324 $442,613 $939,448 $540,500 $504,100 4x Page One 2014 BUDGET WORKSHEETS FLEET MAINTENANCE June 25, 2013 Account # Description 101 43100 101.00 Salaries & Benefits 101 43100 77 101.00 Administrative 101 43100 78 101.00 Technical /Clerical 101 43100 79 101.00 Maintenance 101 43100 102.00 Full -Time Overtime 101 43100 01 211.00 Cleaning Supplies 101 4310001 212.00 Motor Fuels 101 4310001 213.00 Lubricants & Additives 101 4310001 215.00 Shop Materials 101 43100 01 221.00 Equipment Parts 101 43100 01 222.00 Tires 101 43100 01 241.00 Small Tools 101 43100 01 242.00 Minor Equipment 101 4310001 318.00 Contract Engineer 101 4310001 321.00 Telephone Costs 101 43100 01 323.00 Radio Units - Warranty 101 43100 01 384.00 Refuse Disposal 101 4310001 394.00 P.C. Software Purchases 101 43100 01 394.01 Licensing & Maintenance 101 4310001 394.02 Online Subscriptions 101 43100 01 394.03 New Software Purchases 101 43100 01 404.00 Contracted Mach & Equip Repairs 101 4310001 404.01 Contracted Repairs 101 4310001 404.02 Contracted Preventative Maint. 101 43100 01 416.00 Machinery Rental 101 43100 01 417.00 Uniforms Rental 101 43100 01 433.00 Dues & Subscriptions 101 43100 01 435.00 Books & Pamphlets 101 43100 01 437.00 Conferences & Seminars PAGE TOTALS DEPARTMENT TOTALS LM 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual ---- ----- -- - --- Actual -------- - - - --- Actual - ---- ---- -- - - -- Budget -- - - Amount Budget Comments ------- - - -- -- --- --- - - - --- ----- --- - --- -- ------------------------------------------- All Salary Costs Inclusive of $184,900 Salary, Taxes, PERA & Benefits 11,555 11,876 14,275 10,700 11,000 0 0 3,456 9,600 10,100 147,683 152,060 154,723 158,800 163,800 2,561 619 0 3,000 3,000 1,111 1,577 2,470 1,000 2,000 Shop & Vehicles 187,081 174,864 194,475 210,000 215,000 Price Estimate 10,699 10,546 15,772 12,000 15,000 Price Increase 16,433 19,779 15,412 17,000 17,000 153,416 147,760 140,223 140,000 14 5, 000 35,695 22,830 27,752 22,500 25,000 Tires on 8413 & 8436 2,396 2,195 2,387 4,000 3,000 3,198 4,703 3,714 4,000 4,000 3,000 3,500 4,000 3,500 3,500 Contracted Engineer for City(10 %) 0 0 0 0 0 150 4,645 605 1,300 1,000 Warranty (All for Lieutenant) 25 25 0 300 300 Shop Hazardous Waste 529 1,892 6,000 1,670 1,800 1,800 CarteGraph 1,500 2,700 2,700 All Fleet Software Updates 0 1,500 1,500 Detroit Diesel Software 39,152 37,962 51,265 40,000 50,000 0 0 0 0 40,000 0 0 0 0 10,000 Power Wash and Paint 0 0 0 1,000 1,000 263 181 0 0 0 90 1,500 0 100 100 DOT Certification 56 273 87 100 100 DOT Decals and Inspection Pads 0 247 113 300 300 $150- CarteGraph; $150 -Misc. -- ----- -- - -- - -- $615,092 --- -- -- -- - --- -- $599,035 ----- ---- - - - - -- $633,899 --- ---- -- - -- - -- $645,200 --- ---- -- - --- -- --- ---- -- - - - -- $676,200 $615,092 $599,035 $633,899 $645,200 $676,200 LM Page One 2014 BUDGET WORKSHEETS STREET MAINTENANCE June 25, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of - 101 43121 101.00 Salaries & Benefits $493,000 Salary, Taxes, PERA & Benefits 101 43121 77 101.00 Administrative 34,665 35,630 38,790 21,300 21,900 101 4312178 101.00 Technical/Clerical 63,978 47,215 49,966 52,400 53,600 101 43121 7G101.00 Maintenance 372,144 426,887 436,567 413,500 417,500 101 43121 102.00 Full -Time Overtime 13,457 10,055 4,112 14,000 14,000 Maintenance 101 43121 9S103.00 Part-Time Salaries & Benefits 28,696 16,553 17,652 20,000 20,000 Includes Funds for Horticulturist 101 43121 01 201.00 Office Accessories 0 0 171 100 100 101 43121 01203.00 Printed Forms & Paper 200 101 43121 01 203.01 R/W Permit & Inspection Forms 0 0 0 200 200 101 43121 01 203.03 City Specification Books 0 0 0 0 0 101 43121 01 205.00 Drafting Supplies 900 101 43121 01 205.01 Plotter Ink and Paper 136 752 114 500 500 Split with 101 - 45202 -01- 205.00 101 43121 01 205.02 Off -Site Reproductions 53 0 147 400 400 101 43121 01 209.00 Other Office Supplies 1,231 0 70 500 500 101 43121 01 216.00 Chemical & Chemical Products 72,845 77,386 102,846 75,000 100,000 101 43121 01 224.00 Street Maintenance Materials 7,800 101 43121 01 224.01 Paint 481 738 343 500 500 101 43121 01 224.02 Mail Boxes 493 2,955 1,133 1,500 1,500 101 43121 01 224.03 Light Bulbs /Lenses 304 20 647 1,500 800 Replace with LED Bulbs 101 43121 01 224.04 Holiday Decorations 0 0 0 5,000 5,000 Begin Replacement Program 101 43121 01225.00 Landscaping Materials 16,900 101 43121 01 225.01 Turf Restoration Material 0 235 622 1,500 3,500 101 43121 01 225.02 Seed 0 1,572 844 200 0 101 43121 01 225.03 Black Dirt 51 923 1,315 1,000 0 101 43121 01 225.04 Trees 0 2,990 975 500 500 101 43121 01 225.05 Hanging Baskets 4,379 3,638 4,087 5,000 5,000 101 43121 01 225.06 Entrance Monuments 0 656 4,508 2,000 2,000 101 43121 01 225.07 Downtown Planters 0 1,575 1,658 1,600 1,600 101 43121 01225.08 Park Signs & RCC 0 1,112 1,905 2,000 2,000 101 43121 01 225.09 Library/Steeple Center 0 0 0 1,500 1,500 101 43121 01 225.10 Banners /Flag Components 0 0 492 0 800 101 43121 01 226.00 Sign Repair Materials 9,950 13,682 4,475 15,000 6,000 101 43121 01231.00 Bituminous Patching Materials 25,664 39,430 44,731 32,500 37,500 101 43121 01 232.00 Crushed Rock 25,155 30,236 32,737 32,500 32,500 101 43121 01 233.00 Dust Control Materials 30,154 24,848 25,000 30,000 30,000 None East of Akron, Price Increase 101 43121 01 234.00 De -Icing Sand / Rock 1,955 2,853 486 3,000 3,000 Gravel Road Ice Control(Estimate) 101 43121 01235.00 Shouldering Gravel 0 0 257 0 0 101 43121 01 241.00 Small Tools 863 658 1,350 2,000 1,000 Shovels, Brooms, etc. 101 43121 01242.00 Minor Equipment 4,184 2,095 1,723 4,000 3,000 Safety Equipment / Power Tools 101 43121 01 303.00 Engineering Fees 13,237 40,096 11,602 10,000 10,000 General Non - Project Related 101 43121 01 304.00 Legal Fees 877 0 1,196 0 0 101 43121 01 305.00 Medical & Dental Fees 0 0 0 0 0 101 43121 01 310.00 Testing Services 0 56 0 0 0 101 43121 01 313.00 Temporary Service Fees 1,275 9,706 0 0 0 101 43121 01 318.00 Contract Engineer 6,000 7,000 8,000 7,000 7,000 Contracted Engineer for Cdy(20 %) 101 43121 01 319.00 Other Professional Services 32 114 0 5,000 101 43121 01 319.01 Random Drug Testing 0 0 (64) 0 0 101 43121 01 319.02 GIS Consulting Services 0 0 1,672 10,000 5,000 101 43121 01 321.00 Telephone Costs 2,609 2,812 2,814 3,000 3,000 Includes Wireless Technology 101 43121 01 323.00 Radio Units 1,083 1,211 1,116 1,500 1,500 24 Units @ $300 (Split 5 Ways) 101 43121 01324.00 Messenger Services 0 0 0 100 0 101 43121 01 331.00 Travel Expense 417 0 38 500 500 101 43121 01 381.00 Electric Utilities 173,500 101 43121 01 381.01 Street Lights 158,067 170,065 166,887 170,000 170,000 101 43121 01 381.02 Signal Lights & Sirens 2,989 3,003 2,648 5,000 3,500 101 43121 01 384.00 Refuse Disposal 1,400 101 43121 01 384.01 Hazardous Waste Disposal 609 463 457 500 500 101 43121 01 384.02 Roadside Garbage 697 231 517 900 900 101 43121 01 384.03 Tree Disposal 53 0 0 600 0 101 43121 01 391.00 P.C. Maintenance 10,800 101 43121 01 391.03 Pavement Management Syst Sup 5,450 10,254 3,713 10,000 10,000 101 43121 01 391.04 R -O -W Permit On -Line Service 4,800 4,800 5,296 800 800 New County Online Permiting 101 43121 01 392.00 P.C. Accessories & Supplies 0 320 0 0 0 101 43121 01 393.00 P.C. Hardware Purchases 0 0 1,800 4,000 3,000 AV Enhancements at PW 101 43121 01 394.00 P.C. Software Purchases 3,240 4,574 7,800 101 43121 01 394.01 Licensing & Maintenance 4,779 4,800 6,500 CarteGraph, GIS 101 43121 01 394.02 Online Subscriptions 308 30D 800 Pictometry 101 43121 01 394.03 New Software Purchases 2,031 0 500 AV Enhancements at PW PAGE TOTALS -- - -- - 892,272 -- -- - ---- 999,396 ----- -- -- - --- --- 994,531 - - - - -- 969,700 --- --- - -- --- - --- -- 989,900 Page Two 2014 BUDGET WORKSHEETS STREET MAINTENANCE June 25, 2013 Account # Description 101 43121 01402.00 Parking Lot Maintenance 101 43121 01 403.00 Contracted Repair & Maintenance 101 43121 01 403.01 Street Lights 101 43121 01 403.02 Signal Lights 101 43121 01 403.03 Light Replacements 101 43121 01 404.00 Contracted Mach & Equip Repairs 101 43121 01 405.00 Street Striping 101 43121 01 408.00 Street Crack Sealing 101 43121 01 409.00 Tree Trimming 101 43121 01410.00 Concrete Sidewalk/Curb Repairs 101 43121 01 410.01 General Repairs 101 43121 01 410.02 Pedestrian Improvements 101 43121 01 411.00 Contracted Snow Removal 101 43121 01 411.01 Community Center 101 43121 01 411.02 Steeple Center 101 43121 01 411.04 Dakota County Library 101 43121 01 415.00 Equipment Rental 101 43121 01 433.00 Dues & Subscriptions 101 43121 01 433.01 American Public Works Assn 101 43121 01433.03 City Engineers' Association 101 43121 01 433.07 MN Street Superintendent Ass'n 101 43121 01 435.00 Books & Pamphlets 101 43121 01 435.02 "Future Use" 101 43121 01 437.00 Conferences & Seminars 101 43121 01 437.01 APWA 101 43121 01 437.03 Clerical 101 43121 01 437.05 Maintenance Expo 101 43121 01 437.06 Cartegraph, ESRI, GIS 101 43121 01437.07 Snow Conference 101 43121 01 437.08 MN Dot 101 43121 01 437.09 Miscellaneous Training 101 43121 01 439.00 Other Miscellaneous Charges 101 43121 01 570.00 Office Equipment & Furnishings PAGE TOTALS DEPARTMENT TOTALS 51 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 13,577 0 25,000 25,000 65,000 Next 5 -year Average Expenditure 30,000 1,421 27,543 27,506 28,500 10,000 Street Light/Pole Repair /Replace 0 763 2,315 1,500 1,500 0 0 0 0 18,500 Conversion to LED 0 0 0 15,000 15,000 Quiet Zones - Railroad Maint Costs 40,811 46,887 36,303 60,000 60,000 44,913 59,267 50,577 60,000 60,000 Increased Street Overlays 19,959 4,309 8,966 10,000 8,500 $1500 Moved to C/D for Mowing 20,000 16,839 26,252 14,641 20,000 20,000 125,000 130,604 4,447 0 0 Moved $125,000 to Street CIP 45,000 21,970 30,268 13,518 20,000 20,000 8,329 9,993 7,055 10,000 10,000 16,310 12,219 8,980 15,000 15,000 27,917 35,508 31,455 30,000 32,500 1,000 671 695 796 700 800 Annual Membership 33 0 35 0 0 120 70 100 200 200 0 0 0 0 0 0 6,000 0 0 1,080 1,000 1,000 Spring I Fall Conferences 97 0 60 150 0 0 0 37 300 300 0 231 105 1,500 1,500 User Group, Conference, Training 165 0 0 300 300 0 0 200 300 300 Simulator 785 1,332 2,007 2,550 2,600 DCTC Defensive Driving Training 496 105 280 500 500 Host CONDAC, RL & CD Notary 0 0 0 0 0 $339,412 $386,045 $235,463 $302,500 $343,500 $1,231,684 --- - - - - -- $1,385,442 --- - - - - -- $1,229,994 --- - - - - -- $1,272,200 --- - - - - -- -- - - - --- $1,333,400 --- - --- -- 51 Page One 2014 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE June 25, 2013 Account # Description 101 45202 101.00 Salaries & Benefits 101 45202 77 101,00 Administrative 101 45202 78 101.00 Technical /Clerical 101 45202 79 101.00 Maintenance 101 45202 102.00 Full -Time Overtime 101 45202 99 103.00 Part-Time Salaries & Benefits 101 4520201 205.00 Plotter Ink and Paper 101 45202 01 216.00 Chemical & Chemical Products 101 4520201 216.01 Herbicides(General Park Use) 101 4520201 216.02 Fertilizer 101 45202 01 219.00 Other Operating Supplies 101 45202 01 219.01 Seed, Sod, etc. 101 45202 01 219.02 Red Rock, Sand, Gravel, etc. 101 45202 01 219.03 Repair Supplies 101 45202 01 219.04 Bituminous 101 45202 01 219.05 Wood Chips 101 4520201 221.00 Equipment Parts 101 45202 01 221.01 Playground Equipment Repair 101 4520201 221.02 Irrigation Repair(Non- Contract) 101 45202 01 221.03 Miscellaneous 101 45202 01 221.04 Park Sign Replacements 101 45202 01 223.00 Building Repair Supplies 101 4520201 223.01 Paint, Stain, etc. 101 45202 01 223.02 Shingles, Boards, etc. 101 45202 01 223.03 Miscellaneous 101 45202 01 223.04 Shelter /Shed Repairs 101 45202 01 225.00 Landscaping Materials 101 4520201 225.01 Trees, Shrubs, Sod, etc. 101 45202 01 225.02 Timbers, Fence, etc. 101 45202 01 226.00 Sign Repair Materials 101 4520201 229.00 Other Maintenance Supplies 101 4520201 241.00 Small Tools 101 4520201 242.00 Minor Equipment 101 45202 01 303.00 Engineering Fees 101 45202 01 305.00 Medical and Dental Fees 101 4520201 318.00 Contract Engineer 101 4520201 319.00 Other Professional Services 101 45202 01 319.01 Maintenance of Open Spaces 101 4520201 319.02 Central / Erickson Prairie 101 4520201 321.00 Telephone Costs 101 45202 01 323.00 Radio Units 101 4520201 341.00 Employment Advertising 101 4520201 381.00 Electric Utilities 101 4520201 381.01 Skating Rinks 101 45202 01 381.02 Softball Fields 101 4520201 381.03 Irrigation 101 45202 01 383.00 Gas Utilities 101 45202 01 393.00 P.C. Hardware Purchases 101 4520201 394.00 P.C. Software Purchases 101 45202 01 394.01 Licensing & Maintenance 101 4520201 394.02 Online Subscriptions 101 4520201 394.03 New Software Purchases PAGE TOTALS �Z 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual ------ --- - -- Actual -- ---- --- - - - - -- Actual --- ----- - - -- - -- Budget - ---- -- - -- Amount - Budget Comments ---- - -- ---- --- - - - -- ------ --- - --- -- ------------------------------------------------ All Salary Costs Inclusive of $387,300 Salary, Taxes, PERA & Benefits 11,555 11,877 18,311 21,300 21,900 0 0 6,912 19,100 20,100 401,187 411,767 362,547 335,400 345,300 15,185 9,366 7,095 14,000 14,000 49,894 68,823 50,805 63,000 63,000 0 0 114 500 500 Split with 101 - 43121 -01- 205.01 25,000 31,000 FHR Fields Online in 2014 8,520 6,165 5,960 0 0 21,330 8,295 10,754 0 0 21,000 3,440 2,139 3,676 3,000 4,000 FHR Fields Online in 2014 7,079 5,299 5,147 2,500 5,000 0 0 115 0 0 0 0 0 0 0 8,972 7,214 9,000 12,000 12,000 Special Chips, Jaycee Playground 15,500 4,387 4,643 4,935 6,000 6,000 Repairs on Aging Equipment 4,341 5,046 6,663 6,000 7,000 864 1,599 2,142 1,500 2,500 127 0 46 0 0 7,000 315 2,749 758 2,500 2,500 592 1,268 861 1,500 1,500 1,570 1,647 206 1,500 1,500 2,301 3,018 1,106 3,500 1,500 5,000 1,891 1,648 2,248 2,500 2,500 1,772 1,241 159 1,000 2,500 Field Fence Maintenance 202 0 0 500 500 13,981 12,276 13,368 15,000 16,000 Paint, Chalk, Field Dry (& DCTC) 3,181 2,456 2,355 2,500 2,500 Hand Tools, Blades, Bits, etc. 1,589 3,264 2,180 2,500 2,509 Weed Whips, Chain Saws- Powered 0 0 0 0 0 0 0 0 0 0 1,500 1,750 2,000 1,800 1,800 Contracted Engineer for City (5 %) 3,141 3,000 0 3,120 0 3,000 3,000 0 0 0 2,500 0 Controlled Burn at Erickson in '13 3,284 3,806 4,111 3,100 5,000 All Wireless, Including iPad 1,083 1,211 1,116 1,500 1,500 24 Units @ $300 (Split 5 Ways) 0 0 0 0 0 22,500 Anticipated Rate Increase 6,738 7,108 6,628 8,000 8,500 Service Connect / Disconnect 6,560 7,026 6,536 8,000 8,500 3,637 3,461 4,668 5,000 5,500 1,844 2,124 1,572 2,000 2,000 0 320 1,800 4,000 3,000 AV Enhancements at PW 5,378 4,574 7,800 4,779 4,800 6,500 Cartegraph, GIS 308 300 800 Pictometry 2,031 0 500 AV Enhancements at PW ------ - -- --- 594,300 -- ------ - - - ---- 606,299 -- --- ---- - - - --- 556,152 -- ------- - - - - -- 586,300 - -------- -- - - -- --------------- 612,400 �Z Page Two 2014 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE June 25, 2013 Account # Description 101 45202 01 403.00 Contracted Repair & Maintenance 101 4520201 403.01 Irrigation Repairs 101 45202 01 403.02 Electrical Repairs 101 45202 01 403.03 Miscellaneous Repairs 101 4520201 409.00 Other Contracted Repair & Maint 101 45202 01 409.01 Chemlawn Services 101 45202 01 409.02 Library / St. Joe's / RCC 101 4520201 409.03 Fire Station #1 101 45202 01 409.04 Fire Station #2 101 45202 01 409.05 City Hall / Central Park 101 45202 01 409.06 UMore Baseball Fields 101 45202 01 409.07 FHR Soccer Fields 101 45202 01 416.00 Machinery Rental 101 45202 01 416.01 Mower Leases 101 45202 01 416.02 Miscellaneous Rentals 101 4520201 43100 Dues & Subscriptions 101 45202 01 433.01 MN Park Supervisors Ass'n 101 45202 01 433.02 Miscellaneous Dues 101 45202 01 435.00 Books & Pamphlets 101 45202 01 437.00 Conferences & Seminars 101 45202 01 437.01 Seminars & Workshops 101 45202 01 437.02 School & Tuition 101 45202 01 437.03 CarteGraph, ESRI, GIS 101 45202 01 439.00 Other Miscellaneous Charges 101 45202 01 530.00 Improvements Other Than Bldgs PAGE TOTALS DEPARTMENT TOTALS 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual -------- - - - - -- Actual ---- ---- - - - - -- Actual --- ----- - - - - --- Budget -- -- ----- - -- - -- Amount --------- - - - --- Budget --------- - - - - -- Comments ---------------------------------------------- 12,000 3,847 6,186 6,362 8,000 8,000 RPZ- Inspect & Replace(& Blowout) 2,475 3,484 1,662 3,000 3,000 1,330 3,529 4,449 1,000 1,000 47,500 2,133 1,947 1,947 2,000 0 7,531 8,108 8,104 10,000 9,000 Mowing / Chemicals - VonBank 0 3,500 3,529 5,000 4,000 Mowing / Chemicals - VonBank 0 2,450 2,471 4,000 3,000 Mowing / Chemicals - VonBank 0 6,000 6,043 8,000 6,500 Mowing / Chemicals - VonBank 0 0 15,000 15,000 15,000 UMore Baseball Field Maintenance 0 0 0 0 10,000 FHR Soccer Fields Maintenance 19,000 3,727 27,855 15,562 16,000 17,500 3 John Deere's 3,580 1,301 1,598 1,500 1,500 200 0 0 0 50 50 45 0 25 150 150 0 0 0 0 0 5,300 726 659 514 1,100 2,500 Green Expo, MPSA, Playgrounds 156 1,771 1,126 1,300 1,300 Turf School, Power Limited Tech. 0 157 105 1,500 1,500 User Group, Conference, Training 0 250 0 200 200 Contingencies 64,892 ----- ---- -- - - -- 64,988 -- --- --- - - - - -- 64,185 ---- ----- -- - - -- 75,000 ---- --- - - - - - -- -------- - - -- 135,000 --------------- Next 5 -Year Average Expenditures $90,442 $132,187 $132,682 $152,800 - - $219,200 $684,742 -------- $738,485 -- - - - - -- $688,834 -- - - - - -- $739,100 -- - - - - -- -- - - - - -- $831,600 -- - - - - -- 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. STEEPLE CENTER Provides the operations of the Steeple Center which opened in 2010 in the former St. Joseph's church building at the north end of Downtown Rosemount. The Center is available for weddings, banquets, meetings, parties, performances and special events. Staff coordinates the rentals, maintenance and capital improvement projects of the facility. The Rosemount Area Arts Council also provides a program called the "Front Porch" which is a quasi - visitor center during the day on Tuesdays through Fridays. 11 PARKS & RECREATION DEPARTMENT — Page 2 PERFORMANCE MEASURES Hours of Use at Community Center 2008 2009 2010 2011 2012 22,761 18,151 18,296 19,390 20,472 Total Community Center Rental Income and % Change from Prior Fiscal Year 2008 2009 2010 2011 2012 Income $122,315 $111,186 $97,375 $99,829 $89,242 % Change +3.5% -9.0% -12.5% +2.5% -10.6% Number of Acres in the Park Systi 2008 2009 Income 430.52 440.24 % Change -0.07% +2.4% 2009 — Added DCTC Soccer Fields 2011 — Added UMore Ball Fields °m and % Change from Prior Fiscal Year 2010 2011 2012 440.24 467.24 467.24 +0.0% +6.8% +0.0% Percentage of Costs Received for All Recreation Programs 2008 2009 2010 2011 2012 Revenues $151,378 $124,554 $149,377 $134,981 $128,233 Expenses $128,292 $107,625 $128,707 $113,336 $107,994 Net $23,086 $16,929 $20,670 $21,645 $20,239 n/a — Information Not Available Is Page One 2014 BUDGET WORKSHEETS PARKS & RECREATION June 25, 2013 Account # Description 2010 Actual 2011 Actual 2012 Actual 2013 Adopted Budget 2014 Object Detail Amount 2014 Proposed Budget Comments All Salary Costs Inclusive of _ 101 45100 101.00 Salaries & Benefits $677,923 $703,800 $725,023 $746,300 $754,600 Salary, Taxes, PERA & Benefits 101 45100 102.00 Full -Time Overtime 4,396 4,864 4,025 5,000 5,000 101 45100 103.00 Part-Time Salaries & Benefits 167,200 101 45100 10 103.00 P/T Receptionist 35,011 35,361 36,400 36,300 37,200 101 45100 12 103.00 Building Attendants 53,294 54,009 59,873 54,000 54,000 101 45100 15 103.00 PIT Recreation Coordinator 0 0 0 11,000 35,000 112 Time 711114 101 4510083 103.00 Playground Recreation Leaders 24,955 18,501 25,631 20,000 24,000 101 45100 94 103.00 Warming House Attendants 15,190 14,523 12,839 17,000 15,000 101 45100 99 103.00 Park & Rec Committee 1,754 1,814 1,705 2,000 2,000 101 45100 71 103.00 P(T Horticulturist 9,738 0 0 0 0 Moved to Public Works Budget 101 45100 01 203.00 Printed Forms & Paper 0 0 0 0 0 101 45100 01 205.00 Drafting Supplies 1,039 117 0 500 500 Laminating 101 45100 01 207.00 Training & Instructional Supplies 0 0 0 0 0 101 4510001 208.00 Miscellaneous Supplies 94 60 43 0 0 101 45100 01 209.00 Other Office Supplies 1,062 119 378 500 500 Envelopes, Forms, Rulers, etc. 101 45100 01 211.00 Cleaning Supplies 3,757 4,326 4,254 4,000 4,500 101 4510001 216.00 Chemicals & Chemical Products 35 109 124 500 0 Moved to "211.00" 101 45100 01 219.00 Other Operating Supplies 6,690 6,655 8,853 7,000 8,000 Rec Programs, 1st Aid Sup, etc. 101 4510001 221.00 Equipment Parts 10,556 6,050 8,688 8,000 8,000 101 45100 01 223.00 Building Repair Supplies 1,908 1,169 1,296 3,500 1,500 101 45100 01 229.00 Other Maintenance Supplies 0 0 0 5,000 5,000 Tournament Supplies 101 45100 01 312.00 Custodial Services 4,232 5,258 5,515 6,000 6,000 Custodial Services- Banquet Rm 101 45100 01 315.00 Special Programs 14,500 101 45100 01 315.01 Sunday Night Specials 6,007 5,329 5,633 5,500 5,500 Performances (Add Movies) 101 4510001 315.02 Leprechaun Days 283 613 352 250 250 101 45100 01 315.03 Umore Maint. Agreement 0 0 0 500 2,000 2014 - Full Year 101 45100 01 315.04 Ground Pounders(Running) 0 297 140 200 200 Ribbons & Mailings 101 45100 01 315.05 Nature Programs (Arbor Day) 3,018 4,291 4,402 4,700 0 Move to 101 - 41110 -01- 225.00 101 45100 01 315.06 Puppet Programs 294 54 0 150 150 Tapes, Fuses, Puppets, etc. 101 45100 01 315.07 Special Events 441 124 322 1,000 1,000 Publicity & Supplies 101 45100 01 315.08 Adopt -A -Park Program 453 389 75 500 500 Flyers, Signs 101 45100 01 315.09 Miscellaneous Programs 1,787 2,552 6,859 3,000 4,500 Community Gardens 101 4510001 315.10 ADA Programs 0 0 0 400 400 ADA Program Supplies 101 45100 01 319.00 Other Professional Services 1,466 5,393 4,950 6,000 6,000 ADA Services /Eng.LA Sery Test 101 4510001 321.00 Telephone Costs 3,620 3,898 4,181 3,900 4,000 Pagers & Cellular Phones 101 45100 01 331.00 Travel Expense 160 181 668 500 500 101 4510001 341.00 Employment Advertising 333 100 0 0 0 101 4510001 349.00 Other Advertising 33,400 101 45100 01 349.01 Brochures 35,140 28,889 30,611 28,000 28,000 City Newsletter (3 Per Year) 1014510001 349.02 Yellow Pages 1,607 1,430 1,352 1,500 1,500 Rec Ads 101 4510001 349.03 Special Marketing 3,835 3,835 3,528 3,900 3,900 Garage Sale Ad 101 4510001 381.00 Electric Utilities 27,331 30,295 30,969 29,000 30,000 1014510001 383.00 Gas Utilities 23,885 26,328 22,141 28,000 25,000 101 4510001 384.00 Refuse Disposal 3,737 3,699 3,517 4,000 4,000 101 4510001 392.00 P.C. Accessories & Supplies 0 0 0 0 0 101 45100 01 393.00 P.C. Hardware Purchases 1,550 0 0 0 0 101 45100 01 394.00 P.C. Software Purchases 2,167 2,066 0 0 0 See "433.03" Below 101 4510001 401.00 Contracted Building Repairs 7,162 11,486 6,602 8,000 8,000 101 45100 01 404.00 Contracted Mach & Equip Repairs 5,195 4,170 5,722 6,000 6,000 101 4510001 409.00 Other Contracted Repair & Maint 23,624 24,745 24,187 24,000 24,000 Air Handler Maintenance Contract 101 45100 01 412.00 Building Rental 16,800 16,800 16,800 16,800 16,800 Monthly Rent Payments to Guard 101 4510001 415.00 Other Equipment Rental 17,757 16,827 23,704 19,000 24,000 Portable Toilets & Other(New Pks) 101 45100 01 433.00 Dues & Subscriptions 4,800 101 45100 01 433.01 MRPA Dues 1,437 1,576 1,391 1,700 1,700 Minn Recreation & Parks Ass'n 101 4510001 433.02 Miscellaneous 1,761 1,927 2,008 400 400 Paper, Magazines, etc. 101 4510001 433.03 On -Line Registrat'n Subscription 0 0 2,028 2,700 2,700 101 45100 01 435.00 Books & Pamphlets 0 0 5 100 100 101 45100 01 437.00 Conferences & Seminars 4,400 101 4510001 437.01 MRPA State Conference 1,055 1,520 2,207 1,300 2,000 101 45100 01 437.03 Workshops, Schools, & Tuition 2,432 2,112 658 2,400 2,400 101 4510001 439.00 Other Miscellaneous Charges 9,857 19,590 8,856 0 0 Donation Account 101 45100 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 PAGE TOTALS $1,055,824 $1,077,250 $1,108,514 $1,130,000 $1,166,300 General Operating DEPARTMENT TOTALS $1,055,824 $1,077,250 $1,108,514 $1,130,000 $1,166,300 Is Page Two 2014 BUDGET WORKSHEETS PARKS & RECREATION " STEEPLE CENTER *` June 25, 2013 Account # Description 101 38201.00 Rental Revenues 101 38203.00 Rental Revenue - Churches 101 38205.00 A/V Rental Revenues 101 38209.00 Miscellaneous Revenues 101 38211.00 Security Services 428 25 TOTAL REVENUES 101 4510030 103.00 Salaries & Benefits 101 4510030 103.00 Building Attendants 101 45100 30 211.00 Cleaning Supplies 101 45100 30 219.00 Other Operating Supplies 101 4510030 221.00 Equipment Parts 101 45100 30 223.00 Building Repair Supplies 101 4510030 241.00 Small Tools 101 4510030 242.00 Minor Equipment 101 4510030 312.00 Custodial Services 101 45100 30 321.00 Telephone Costs 1014510030 349.00 Other Advertising 101 45100 30 365.00 Workers' Comp Insurance 101 45100 30 369.00 Other Insurance 101 45100 30 381.00 Electric Utilities 101 4510030 383.00 Gas Utilities 101 45100 30 384.00 Refuse Disposal 101 4510030 401.00 Contracted Building Repairs 101 4510030 404.00 Contracted Mach & Equip Repairs 101 4510030 409.00 Other Contracted Repairs & Main 101 45100 30 415.00 Other Equipment Rental 101 4510030 439.00 Other Miscellaneous Charges 101 45100 30 521.00 Building & Structure Purchases PAGE /EXPENDITURE TOTALS SENIOR CENTER •' Account # Description 2013 2014 Objecl 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $6,575 $19,750 $17,830 $18,000 Rental Revenues $8,000 $0 0 500 0 0 0 A/V Rental Revenues 0 428 25 500 101 500 0 280 93 0 0 0 700 2,050 1,050 2,000 - -$0 _ 1,000 ~ $0 -- - $800 $7,275 $23,008 $18,998 $20,500 Salaries & Benefits $9,500 101 4510031 103.00 $15,000 Salary, Taxes, PERA & Benefits 2,324 15,425 14,435 15,000 15,000 45100 31 Event Staff 1,654 4,207 2,247 3,000 0 3,000 101 4,539 1,538 1,205 1,500 0 1,500 Events Supplies 2,089 990 145 1,500 1,000 0 3,998 4,251 3,233 5,000 4510031 4,500 74 0 0 500 500 500 45100 31 1,304 1,273 1,339 1,000 0 1,000 300 101 0 0 1,480 0 0 800 0 276 1,751 2,069 1,800 2,000 0 1,220 325 0 1,500 4510031 500 0 0 0 500 200 500 4510031 0 0 0 2,000 0 0 Pay from Insurance Fund 5,590 5,669 4,863 5,500 Electric Utilities 4,500 0 10,632 9,905 7,023 9,000 383.00 7,000 Gas Utilities 323 1,142 1,149 1,000 101 1,200 384.00 13,855 11,523 8,493 11,000 300 11,000 45100 31 6,423 3,553 6,793 4,200 0 4,200 500 0 0 0 0 Contracted Mach & Equip Repairs 2,500 Holiday Lights 910 789 718 500 415.00 500 Other Equipment Rental 0 0 0 0 101 0 439.00 1,604 0 0 0 0 0 $56,815 $62,340 - $55,193 $64,500 --- - -- --- $0 $61,200 - - - - - -- - $0 ------ --- - -- $14,000 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 101 38301.00 Rental Revenues $0 $0 $0 $750 101 38305.00 A/V Rental Revenues 0 0 0 50 101 38309.00 Miscellaneous Revenues 0 0 0 0 TOTAL REVENUES - - -$0 _ - $0 - - ~ $0 -- - $800 101 4510031 103.00 Salaries & Benefits 101 4510031 103.00 Building Attendants 0 0 0 7,800 101 45100 31 211.00 Cleaning Supplies 0 0 0 300 101 45100 31 219.00 Other Operating Supplies 0 0 0 400 101 4510031 221.00 Equipment Parts 0 0 0 400 101 4510031 223.00 Building Repair Supplies 0 0 0 500 101 45100 31 242.00 Minor Equipment 0 0 0 300 101 45100 31 321.00 Telephone Costs 0 0 0 300 101 4510031 349.00 Other Advertising 0 0 0 100 101 4510031 365.00 Workers' Comp Insurance 0 0 0 200 101 4510031 369.00 Other Insurance 0 0 0 500 101 4510031 381.00 Electric Utilities 0 0 0 1,500 101 4510031 383.00 Gas Utilities 0 0 0 500 101 4510031 384.00 Refuse Disposal 0 0 0 300 101 45100 31 401.00 Contracted Building Repairs 0 0 0 500 101 45100 31 404.00 Contracted Mach & Equip Repairs 0 0 0 300 101 4510031 415.00 Other Equipment Rental 0 0 0 100 101 4510031 439.00 Other Miscellaneous Charges 0 0 0 0 ---- PAGE /EXPENDITURE TOTALS --- - -- --- $0 --- ---- -- -- --- $0 - - - - - -- - $0 ------ --- - -- $14,000 $750 50 0 $800 $8,800 Salary, Taxes, PERA & Benefits 8,800 Event Staff 300 400 Events Supplies 400 500 300 300 100 200 500 1,500 500 300 500 300 100 0 $15,000 61 Page Three 1i 2014 BUDGET WORKSHEETS PARKS & RECREATION June 25, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments $111,500 1014510080 Art Classes $0 $0 $0 $1,000 $1,000 101 4510081 Softball 51,127 44,877 44,160 45,000 45,000 101 4510082 Volleyball 0 0 0 0 0 101 45100 84 Tennis 1,215 1,065 1,767 1,600 1,600 101 45100 85 Tiny Tots 9,184 377 0 0 0 Eliminated Program in 2010 101 45100 86 Rosettes 1,595 1,747 1,646 1,700 1,700 101 4510087 Trips 1,700 916 4,677 1,000 4,600 101 4510088 Broomball 0 0 0 0 0 101 4510090 Run for the Gold 4,358 4,693 4,615 4,500 4,500 101 4510091 Camps 19,254 21,289 14,583 21,000 15,000 101 4510092 Adult Basketball 0 0 0 600 600 101 45100 93 Other Programs 17,843 17,658 17,055 17,000 17,000 101 4510095 T -Ball 5,410 4,960 4,894 5,000 5,000 101 4510096 Teen Night 480 0 786 0 0 Eliminated Program in 2010 101 4510097 Adult Soccer League 13,702 12,137 11,205 12,000 12,000 No League in 2009 101 4510098 Youth Soccer Lessons 2,839 3,617 2,605 3,500 3,500 128,707 113,336 107,994 113,900 111,500 101 45100 80 219.00 Operating Supplies 0 0 0 1,000 1,000 101 45100 81 103.00 Part-Time Salaries 7,197 6,149 7,380 6,000 6,000 101 4510081 219.00 Operating Supplies 12,208 9,041 10,318 9,000 9,000 101 4510081 311.00 Officiating Fees 26,509 24,574 23,853 25,000 25,000 101 4510081 319.00 Other Professional Services 5,213 5,113 2,609 5,000 5,000 101 4510082 103.00 Part -Time Salaries 0 0 0 0 0 101 4510082 219.00 Operating Supplies 0 0 0 0 0 101 4510082 311.00 Officiating Fees 0 0 0 0 0 101 4510082 319.00 Other Professional Services 0 0 0 0 0 1014510084 103.00 Part-Time Salaries 1,175 1,065 1,767 1,100 1,100 101 4510084 219.00 Operating Supplies 41 0 0 500 500 101 45100 85 103.00 Part-Time Salaries 8,799 377 0 0 0 101 4510085 219.00 Operating Supplies 385 0 0 0 0 101 4510086 103.00 Part-Time Salaries 711 691 678 700 700 101 45100 86 219.00 Operating Supplies 885 1,056 968 1,000 1,000 101 4510087 103.00 Part-Time Salaries 0 0 0 0 0 101 4510087 219.00 Operating Supplies 4,600 101 45100 87 219.01 Youthrreen Trips Supplies 0 407 274 500 500 101 4510087 219.02 Adult/SeniorTrips Supplies 1,700 509 4,403 500 4,100 101 4510088 219.00 Operating Supplies 0 0 0 0 0 101 4510088 311.00 Officiating Fees 0 0 0 0 0 101 4510090 219.00 Operating Supplies 4,358 4,693 4,615 4,500 4,500 101 45100 91 103.00 Part -Time Salaries 10,236 11,623 3,434 11,000 4,000 101 45100 91 219.00 Operating Supplies 9,018 9,666 11,149 10,000 11,000 101 4510092 219.00 Operating Supplies 0 0 0 600 600 101 4510093 103.00 Part-Time Salaries 4,467 2,825 2,159 3,000 3,000 101 45100 93 219.00 Operating Supplies 13,376 14,833 14,476 14,000 14,000 101 45100 93 319.00 Other Professional Services 0 0 420 0 0 101 4510095 103.00 Part-Time Salaries 3,885 3,514 3,289 3,500 3,500 101 4510095 219.00 Operating Supplies 1,525 1,445 1,605 1,500 1,500 101 4510096 103.00 Part-Time Salaries 0 0 0 0 0 101 4510096 219.00 Operating Supplies 480 0 786 0 0 101 4510097 103.00 Part-Time Salaries 0 0 0 0 0 101 4510097 219,00 Operating Supplies 1,702 1,637 1,545 1,500 1,500 101 4510097 311.00 Officiating Fees 12,000 10,500 9,660 10,500 10,500 101 4510098 103.00 Part-Time Salaries 1,699 2,377 1,695 2,300 2,300 101 4510098 219.00 Operating Supplies 1,140 1,240 910 1,200 1,200 SPECIAL PROGRAM TOTALS -- - - -- - - -- 128,707 --- -- -- - -- 113,336 - ----------- - 107,994 -- - - - -- -- 113,900 ------ - - -- --- - - -- --- 111,500 GRAND TOTAL - PARK & REC $1,241,347 --- - - - - -- --------- $1,252,926 --- - - - - -- -- - - - - - -- $1,271,700 -- - - - - - -- --- - - - --- $1,322,400 --- - - - --- --- - - - - -- - - - - - - -- - - - - - - -- $1,354,000 -- - - - - --- --- - - - --- 1i 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. glfi� Page One 2014 BUDGET WORKSHEETS OTHER FINANCING USES June 25, 2013 Comments Excess FIB Transfers ;I 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description ---- -------- - - - - -- -- -- -- - - -- ----------------------------- ------------------ Actual ------ -- - - - - -- Actual ---- ----- - - -- -- Actual --- ----- - - -- -- Budget ---- ---- - - - - --- Amount ---- --- -- -- - - -- Budget ---- - -- - -- 101- 49300 -01 710.00 Transfers $115,000 $477,376 $115,000 $115,000 $115,000 101- 49300 -01 710.01 Arena Operations Assistance 0 0 0 0 115,000 101 - 49300 -01 710.02 Debt Service Levies 0 0 0 0 0 101 - 49300 -01 720.00 Transfers 0 323,138 25,000 0 0 FUND TOTALS - --- -- -- -- ---- $115,000 --- ----- - -- - -- $800,514 ---- --- -- - - -- -- $140,000 - --- ----- --- - -- $115,000 ---- --- -- - -- - -- -- -- ---- - - - - -- $115,000 Comments Excess FIB Transfers ;I INSURANCE GENERAL / ADMINISTRATIVE Provides for the funding of the City's Worker's Compensation Insurance and General Liability Insurance. Currently, both insurances are provided through the League of Minnesota Cities Insurance Trust. This agency allows the City to have thorough, yet affordable insurance. In 1995, we set up a separate Internal Service Fund for insurance purposes. The amount levied was, and will be, the same as it would have been if the Insurance budget had been in the General Fund, as it has been in the past. But, this allows us to build a special fund for insurance purposes that will allow the City to move towards self - insurance, and ultimately, lower rates. We do not anticipate ever being totally self - insured, but by raising our deductibles we approach that point and allow ourselves to save substantially on our annual insurance premiums. Doing so will allow the City to operate more efficiently and save the taxpayers money without taking undue risks. W Page One 2014 BUDGET WORKSHEETS INSURANCE - REVENUES June 25, 2013 Account # Description 206 31010.00 Current Ad Valorem Taxes 206 33100.00 Federal Grants & Aids 206 36210.00 Interest Earnings- Investments 206 36214.00 Net Change in FV- Investments 206 36215.00 Interest Earnings 206 36260.00 Other Revenue 206 36265.00 Use of Reserve Funds Budget Comments -- --- - -- - -- ----------------------------------------- FUND TOTALS INSURANCE - EXPENDITURES Account # Description 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 403.00 Contracted R & M -Other Impr. 206 49006 01 409.00 Other Contracted Repair & Maint 206 49006 01 439.00 Other Miscellaneous Charges FUND TOTALS 2010 2011 2012 Actual Actual Actual --- -- - -- - -- ----- --- - -- -- -- - --- ---- - -- - -- $2,621 $10,834 $1,955 500 500 4,230 11,850 9,742 3,597 2,500 2,500 2,500 10,500 6,000 6,000 12,300 12,300 12,300 105,374 106,210 103,113 163,362 80,309 89,713 33,016 0 0 8,651 57,602 49,577 1,000 0 0 --- --- - - -- -- -- ------ - - - -- -- ----- --- -- - - -- 351,675 285,997 272,986 2013 2014 Object 2014 Adopted Detail Proposed Budget Amount Budget ---- --- -- - - -- - ----- - -- - -- ---- ---- - - - - -- $8,000 $5,000 500 500 12,000 6,000 2,500 2,500 18,300 6,000 6,000 12,300 12,300 110,000 110,000 85,000 95,000 0 0 55,000 55,000 0 0 - ----- -- - - --- ----- ---- - - - - -- -- --- -- - - - - --- 291,300 292,300 Comments -------------------------------------------- Liability & Auto Deductible Pymts Unreimbursable Legal Fees Work Comp Deductible Pymts Yearly Fee Per Policy F -3 Risk Management Consultant Annual Premium Annual Premium - General Liability (Changed to High Deductible) Liability & Auto Deductible Pymts Liability & Auto Deductible Pymts (Changed to High Deductible) NOTE: Levy of $245,000 covers costs for all insurance premiums and general liability payments (changed to high deductible plan for 2011). All other expenditures covered through a combination of tax levies, interest earnings and insurance refunds /dividends. &2- 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual --------- -- - - -- Actual ---- -- --- --- - -- Actual --- ----- - -- --- Budget Amount --- ---- -- - -- - -- -- ---- --- --- - -- Budget Comments -- --- - -- - -- ----------------------------------------- $275,000 $245,000 $245,000 $245,000 $245,000 0 0 0 0 0 11,778 8,360 6,408 8,000 7,000 (172) 0 0 0 0 Annual Market Value Changes 308 201 135 300 300 41,905 71,767 77,449 38,000 40,000 Insurance Refunds /Dividends 0 0 0 0 0 - --- -- -- - - ----- 328,818 -- - - - - -- -------- ---- ----- - - - - -- 325,328 -- - - - - -- -- - - - - -- -- ---- -- - -- - --- 328,992 -- - - - - -- -- - - - - -- -- ------- - --- -- -- ------- - -- - -- 291,300 -- - - - - -- -- - - - - -- - - - - - - -- -- - - - - -- --------------- 292,300 -- - - - - -- -- - - -- -- 2010 2011 2012 Actual Actual Actual --- -- - -- - -- ----- --- - -- -- -- - --- ---- - -- - -- $2,621 $10,834 $1,955 500 500 4,230 11,850 9,742 3,597 2,500 2,500 2,500 10,500 6,000 6,000 12,300 12,300 12,300 105,374 106,210 103,113 163,362 80,309 89,713 33,016 0 0 8,651 57,602 49,577 1,000 0 0 --- --- - - -- -- -- ------ - - - -- -- ----- --- -- - - -- 351,675 285,997 272,986 2013 2014 Object 2014 Adopted Detail Proposed Budget Amount Budget ---- --- -- - - -- - ----- - -- - -- ---- ---- - - - - -- $8,000 $5,000 500 500 12,000 6,000 2,500 2,500 18,300 6,000 6,000 12,300 12,300 110,000 110,000 85,000 95,000 0 0 55,000 55,000 0 0 - ----- -- - - --- ----- ---- - - - - -- -- --- -- - - - - --- 291,300 292,300 Comments -------------------------------------------- Liability & Auto Deductible Pymts Unreimbursable Legal Fees Work Comp Deductible Pymts Yearly Fee Per Policy F -3 Risk Management Consultant Annual Premium Annual Premium - General Liability (Changed to High Deductible) Liability & Auto Deductible Pymts Liability & Auto Deductible Pymts (Changed to High Deductible) NOTE: Levy of $245,000 covers costs for all insurance premiums and general liability payments (changed to high deductible plan for 2011). All other expenditures covered through a combination of tax levies, interest earnings and insurance refunds /dividends. &2- 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 2014 only. As part of a long -range planning process, a 10 -year CIP working plan has been adopted for the years 2014 through 2023. This is a working plan only, with the current year (2014 in this case) being approved as part of the formal budget process. �'2 ., ... .. ,. .. . .., 7t �z,Yeark : -. .. ,rrG ,., , A ,.. „ s... ,a... o s�+ ,., '007N%09' �- .�:,�n „rn .. .vat , ... .a: . _ a. .., ,ifs: v,A ai ,. ,,.r ..,.r ^, .,. .. r ,., M .. .. ,.. .. .. e .... ✓ »dk ,.. � "K � �: ,, t.. x.$1:: ,.�Y e ., .. .... R 3 9' .. .. , _ ,a ., x4� .. . u., ,.... c .4... ,.. r1. .. ,... . N..V,.. a 51 i d a lw. ., , ,..: s. . :.. Y m Via. -k2 ... ,:. i,.: n , r. t � 7r r t .... k. J,z &.. , aD ... �. .. .. h....,: ,�. v� 41u t` c t r s, s ..... A. t< h.. f. {�, .0 .. .?4. �: ... , , . ,,... a. t ' f ..t h k �. ?w3 d t x � a ... , i ., _, ,r. k.. ,. �,A•i n �...L. A . ,., , .. _. ..,. 4,t _. , ., 1., 5": � «- =��4,�:,Item.,.Descnt,on,,:.A ,,.. J. _.�,ra.�1,t�•.De J .,, .�1..., .... t nn. in.... *� .. ,.,� d, .A...2k ,.. arbrlen0. IX �F a . 4 .h :;,� f,. , ,Clpv:��... muw.. l.. +7.. n .. " ,. a,CIP,,, ..,„„ ..'E ::./r d, Y "' .. „S CIRi)?„',..�Assesasr i ,. r. .. ,.. >.. «v. , .,.... ... , 4 i1 ,.. i.. , C. .=I� ..- .,F.und.,. t kA, � J. z.... ) .4, , .. l... o S e.,.. ,. vt. tat .. ,, , ,.,4..1 ,:. . ,., r , ) ,.. $ore..��'.a r5f. ... !,1`yS+n. t, ] ^; ., .,e: ...,rte k ..s .. _ �Y � Care,•,.,, ...,.. a,, iY. j a „ $ a. q *.,,= ,. , ,:, �. .. ,.:. ,�. Yt .Core,a.,r.. .. , . �... ,.. ... :. A rc,,. ,,.,rUh6 :-..:, n , i •:k:. ?'t t� :.,.. +M .. ,... >•„ !";3,. x1fU�dd +.5, .. k•.6 i' ;.:, r, n . •in D� „..Utlll �,.;,, .- c q " : „ .N.. ,.. � ,,, r'., . , r��e xw... l rkY. ,f fSV.C' � ,^:.',7� 7. .. . 1g - ,,...., s .. , .. „ „.:,,Ot�ierzt h u . , . 1 i."Y.J s,(,,,: ,ixd . 'R' -., - .. .. ,.,.. I 5. ,�COSt..,... „ 2014 1 Replace Skate Sher ener Arena 15,000 1 15,000 2014 2 Replace Cooling Tower Arena 60,000 1 60,000 2014 3 Upgrades - Council Chambers, Conference Room & Control Room Council 325,000 L21 325,000 2014 4 Replace 4 P.W, Laptops Finance 6,000 6,000 2014 5 PC Printer Replacements Finance 10,000 10,000 2014 6 Re lace rosemountSAN, Phone Server & Watch guard Finance 45,000 45,000 2014 7 PC Workstation Upgrades From 2009 Finance 60,000 60,000 2014 8 Hose Testers Fire 12,000 12,000 2014 9 4x4 Brush Truck Re lacement 1991 Vehicle)( Truck, Pump & Tank Fire 75,000 75,000 2014 10 City-Wide Software Gen'I. Govt. 25,000 25,000 2014 11 YMCA/DCTC Facilit Year 1 of 5 Gen'I. Govt. 500,000 _L3)_ 500,000 2014 12 Repair Roof Drainage Issues at Community Center Rec 20,000 20,000 2014 13 Mechanical Window Shades at Steeple Center Rec 35,000 35,000 2014 14 Patio Improvements at Community Center Rec 40,000 40,000 2014 15 Landscape Improvements at Steeple Center Rec 60,000 60,000 2014 16 Im rove Ja cee Park Battin Ca a R&Rec Rec 22,000 4 22,000 2014 17 Shade Cano ies for Du outs at Ja cee Park and Umore Park Rec 30,000 4 30,000 2014 18 New Nei hborhood Park Built N -1 Prestwick Place Rec 200,000 200,000 2014 19 Briefiin Room Technolo 4,000 4,000 2014 20 Re lace 2 Lasers 5,000 5,000 2014 21 Re lace S uad La to s 4 / Printers / Net Motion c 21,000 21,000 20141 22 1 Squad Set Up and Equipment Installation Police 22,500 22,500 2014 23 Re lace Video Equipment in Squads 8 Police 40,000 40,000 2014 24 4 Squads Sell Back 3 - #3550, 3580 & 35110 Police 78,000 9,000 5 87,000 2014 25 PW Building Addition Lease /Purchase Year 16 of 20 Pub Works 24,000 10,000 10 000 44,000 2014 26 Molz Utility Evaluation Pub Works 5,000 5,000 5,000 15,000 2014 27 Railroad Crossing Improvements Pub Works 385,580 365,580 2014 28 Pedestrian Improvements Program Pub Works 125,000 125,000 2014 29 Pavement Mana ement Program Pub Works 589,040 80,260 669,300 2014 30 RTV Kubota (Replace #8401 Purchased 2004 Pub Works 15,000 2,000 6 17,000 2014 31 1 -Ton Pickup w /Dum (Replace #6344 2000 Vehicle Pub Works 45,000 5,000 6 50,000 2014 32 ITractor • John Deere (Replace #8408 Purchased 2002 Pub Works 95,000 5,000 6 100 000 2014 33 Loader, Win & Plow (Replace 8421, 0195 & 0212 1995 Vehicle Pub Works 245,000 45,000 6 290,000 2014 34 Vac Truck Re lace #8446 1995 Vehicle Pub Works 137,500 137,500 50,000 6 325,000 2014 35 Well #16 Construction Pub Works 1,250,000 7 1,250,000 Totals 179,000 714,040 803,500 80,260 200,000 385,580 1,250,000 0 0 15,000 152,500 142,500 0 1,068,000 4,990,380 Total CIP Funding Requirements - Year 2014 $1,696,540 ( #) These items will be funded with the issuance of Equipment Certificates. $0 (1) Replace Skate Sharpener and Replace Cooling Tower funding comes from Arena Fund operations/reserves. (2) Other funding for Council Chambers, Conference Room will come from 2012 Assigned Funds ($100,000) and future assignments for 2013. (3) Other funding for YMCA/DCTC facility will come from SKB reserves. (4) Other funding for Parks projects comes from Building CIP /SKB reserves. (5) Other funding for Squad Cars comes from auction sales of old vehicles. (6) Other funding for Public Works equipment comes from trade -in value of old vehicles. (7) Funding for Well #16 will come from a Water Revenue bond issue. Total Building CIP levy for 2014 is $24,000. If there is a difference, the difference between this number and the number from above is a result of a 10 -year funding program and other funding alternatives (such as potential SKB revenues). Total Street CIP levy for 2014 is $740,000. If there is a difference, the difference between this number and the number from above is a result of a 10 -year funding program and other funding alternatives (such as potential SKB revenues). Total Equipment CIP levy for 2014 is $490,000, If there is a difference, the difference between this number and the number from above is a result of a 10 -year funding program and other funding alternatives (such as potential SKB revenues). loft V+ PORT AUTHORITY GENERAL / ADMINISTRATIVE The Rosemount Port Authority is the successor to the Rosemount Housing and Redevelopment Authority (HRA) and the Rosemount Economic Development Authority (EDA). As such, the Port Authority is responsible for both redevelopment and economic development activities in the City. The Port Authority concentrates much of its activity on the development of the Rosemount Business Park and on the redevelopment of downtown Rosemount. • The Port Authority will continue to work on other development and redevelopment projects related to commercial and industrial development. Me Page One 2014 BUDGET WORKSHEETS PORT AUTHORITY - REVENUES June 25, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description - ------ -- --- - - - --- --- - - - - - -- --------------- ----- ----- ------ ------ -- - - - - -- -- Actual --- -- -- - -- - -- ----- Actual ---- - --- -- - Actual ----- --- - -- --- Budget - --- -- --- -- - - -- Amount - -- ----- -- - - - -- Budget --- -- ---- -- -- -- Comments ---------------------------------------------- 201 31010.00 Current Ad Valorem Taxes $50,000 $58,600 $58,600 $58,000 $58,000 Operating Levy 201 31050.00 Tax Increments 0 0 0 0 0 Admin Fees Portion Only 201 33130.00 Federal Grants -CDBG 0 0 0 0 0 201 33425.00 Other State Grants & Aids 0 0 0 0 0 LCDA Downtown Grant 201 34109.00 Other Charges for Services 0 0 0 0 0 Genz -Ryan Tenant Utility Pymts 201 36210.00 Interest Earnings - Investments 10 81 50 100 100 Interest Earned on CD's 201 36215.00 Interest Earnings 320 39 86 100 100 Checking Interest & Misc 20136230.00 Contributions /Donations 0 0 0 0 0 201 36260.00 Other Revenue 0 575 0 0 0 201 36265.00 Use of Reserve Funds 0 0 0 0 0 201 39101.00 Sales of General Fixed Assets 0 0 0 0 0 -- FUND TOTALS --- --------- --- -- -- - - - - -- -- $50,330 - - - - -- ------- - - - - -- ---- $59,295 --- - - - - -- --- - - - - -- --- -- -- - - -- $58,735 --- - - - - -- --- - - - --- ---- ----- --- - -- $58,200 --- - - - - -- --- - - - - -- ----- --- - - - - - -- --- - - - - -- --- - - - - -- --------------- $58,200 --- - - - - -- --- - - - - -- EXPENDITURES 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description -- - - ---- -- - -- --------------- Actual Actual Actual Budget Amount Budget Comments ------ ---- -- - -- ------- ---- ------- ------- - - - - -- ---- ----- - - -- -- --- ------ --- - -- ------- -- - - - --- ------- -- - -- - -- -- ------ - - - - - -- --------- --- - -- ---------------------------------------------- AII Salary Costs Inclusive of 201 46300 99 103.00 Part-Time Salaries & Benefits $3,433 $3,868 $3,302 $5,000 $5,000 Salary, Taxes, PERA & Benefits Port Authority Members 201 46300 01 303.00 Engineering Fees 0 4,400 0 2,000 2,000 201 46300 01 304.00 legal Fees 714 900 1,209 3,000 3,000 201 46300 01 317.00 General Fund Administrative Fees 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Policy F -3 201 46300 01 319.00 Other Professional Services 17,400 201 46300 01 319.01 Project Management Consultant 0 0 0 2,000 2,000 201 46300 01 319.02 Marketing - REDE - City Share 7,741 10,853 10,231 10,000 10,000 Twin Cities Marketing Initiative 201 46300 01 319.03 County TIF Charges 10,564 0 0 0 0 201 46300 01 319.04 P/A Property Tax Payments 0 0 0 0 0 201 46300 01 319.05 Other Consultants 0 0 0 5,400 5,400 201 46300 01 319.07 Central Park Survey Work 0 0 0 0 0 201 46300 01 322.00 Postage Costs 132 87 0 800 800 201 46300 01 331.00 Travel Expense 291 0 0 0 0 201 46300 01 349.00 Other Advertising 401 3,972 2,939 11,800 10,000 Additional Marketing 201 46300 01 359.00 Other Printing & Binding Costs 855 321 0 2,000 2,000 201 46300 01 365.00 Workers Comp Insurance 538 521 540 500 500 Commissioners 201 46300 01 369.00 Other Insurance 5,079 2,282 1,532 2,000 2,000 Property Insurance 201 46300 01 381.00 Electric Utilities 193 223 287 500 500 Business Park & Other Properties 201 46300 01 383.00 Gas Utilities 0 0 0 0 0 Other Properties 201 46300 01 389.00 Other Utility Services 0 0 0 0 0 Utility Fees 201 46300 01 403.00 Contracted Repairs & Maintenance 0 0 0 0 0 201 46300 01 433.00 Dues & Subscriptions 1,700 Prof Organizations /Journals 201 46300 01 433.01 Professional Organizations /Jourm 1,483 2,380 1,790 1,700 1,700 201 46300 01 433.02 Foreign Trade Zone Commission 0 0 0 0 0 201 46300 01 437.00 Conferences & Seminars 3,034 4,125 2,419 5,000 5,000 Development/TIF /Miscellaneous 201 46300 01 439.00 Other Miscellaneous Charges 86 48 110 500 500 Contingencies 201 46300 01 521.00 Building & Structure Purchases 0 0 0 0 0 201 46300 01 525.00 Building & Structure Purchases 0 0 0 0 0 201 46300 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 201 46300 01 710.00 Transfers 0 0 0 0 0 --------- FUND TOTALS --- --------- - - - --- $40,543 - - - - -- - ------ -- - - - --- $39,979 --- - - - - -- --- - - - - -- - --- ---- - - - - - -- $30,360 --- - - - - -- --- - - - - -- ----- ---- - --- -- $58,200 --- - - - - -- --- - - - - -- --------- - --- -- --- - -- - -- --- - - - - -- ----- -- - - - --- $56,400 --- - - - - -- --- - - - - -- 9 Page One 2014 BUDGET WORKSHEETS DOWNTOWNIBROCKWAY DISTRICT(0108) - REVENUES June 25, 2013 Account # Description 242 31010.00 Current Ad Valorem Taxes 242 31050.00 Tax Increments 242 33400.00 State Grants & Aids 242 33425.00 Other State Grants & Aids 242 33620.00 Other County Grants & Aids 242 36210.00 Interest Earnings - Investments 242 36215.00 Interest Earnings 242 36220.00 Rents & Royalties 242 36230.00 Other Revenue 242 36260.00 Contribution /Donation- Private 242 39310.00 Bond Proceeds 0 FUND TOTALS EXPENDITURES Account # Description 242 49042 01 303.00 Engineering Fees 242 49042 01 304.00 Legal Fees 242 49042 01 319.00 Other Professional Services 242 49042 01 522.00 Building & Structure Purchases 242 49042 01 530.00 Improvements Other Than Buildings 242 49042 01 533.00 Waterford Grant Reimbursement 242 49042 01 601.00 Principal on Waterford PAYG 242 49042 01 611.00 Interest on Waterford PAYG 242 49042 01 710.00 Transfers FUND TOTALS 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $37,968 $46,811 $0 $0 $0 MVHC Payments 410,286 576,675 660,056 554,000 670,000 1,876 0 0 0 0 139,965 0 0 0 0 0 0 0 0 0 73 724 879 0 0 244 130 75 0 0 2,425 0 0 0 0 0 0 0 0 0 125 0 0 0 0 0 0 0 0 0 $592,961 $624,339 $661,010 $554,000 $670,000 2010 2011 Actual Actual $3,690 $0 0 0 4,730 16,053 0 103 0 0 139,965 0 0 19,108 0 63,880 280,000 350,000 $428,385 $449,144 - - - - - -- --- - -- - -- 2012 Actual $0 0 10,699 0 0 0 44,979 83,340 350,000 $489,018 2013 2014 Object 2014 Adopted Detail Proposed Budget Amount Budget Comments $0 $0 0 0 20,000 20,000 County TIF Charges (in 2011) 0 0 0 0 0 0 44,000 63,000 Waterford Pay -As- You -Go 90,000 80,000 Waterford Pay -As- You -Go 400,000 400,000 P & I for 2008A & 2008B Issues $554,000 M $563,000 VT 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. This fund covers the operation of 1,300 fire hydrants, 1,600 gate valves and 127 miles of water main. PERFORMANCE MEASURES Operating Cost Per 1,000,000 Gallons of Water Pumped /Produced 2008 2009 2010 2011 2012 2013 est n/a n/a $1,132 $1,392 $1,193 $1,350 n/a — Information Not Available 1, Page One 2014 BUDGET WORKSHEETS WATER UTILITY - REVENUES- June 10, 2013 Account # Description 601 33425.00 Other State Grants & Aids 601 34108.00 Administrative Fees -Other Funds 601 34109.00 Other Gen'] Govt Chgs for Services 601 36101.00 Principal - Special Assessments 601 36102.00 Penalties & Interest - SIA 601 36210.00 Interest Earnings - Investments 601 36214.00 Net Change in FV- Investments 601 36215.00 Interest Earnings 601 36220.00 Rents & Royalties 601 36260.00 Other Revenues 601 36265.00 Use of Reserve Funds 601 37110.00 Residential Water Revenues 601 37120.00 Apartment Water Revenues 601 37125.00 Institutional Water Revenues 601 37130.00 Commercial Water Revenues 601 37140.00 Industrial Water Revenues 601 37160.00 Penalties - Water Revenues 601 37165.00 Meter Maint Water Revenues 601 37170.00 Other Water Revenues 601 37180.00 Water Meter Sales Revenue 601 39103.00 Gain or Loss from F/A Disposal 601 39203.00 Transfer From 70,470 87,847 FUND TOTALS 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $1,208 $0 $19,960 $0 $0 590 2,123 5,733 0 0 5% of 5% Fees -Const Projects 10,380 0 14,000 0 0 48,772 54,354 59,342 50,000 50,000 10,808 (5,989) (3,093) 0 0 72,361 60,496 60,556 60,000 60,000 (6,319) 3,794 5,131 0 0 Annual Market Value Changes 736 1,280 427 1,000 500 70,594 80,745 84,223 80,000 90,000 Antenna Leases 0 750 0 0 0 0 0 0 0 0 999,856 1,079,507 1,258,104 1,050,000 1,200,000 71,064 75,444 79,934 73,000 75,000 72,159 70,470 87,847 70,000 75,000 71,616 71,131 84,393 65,000 70,000 64,269 73,851 70,693 70,000 70,000 8,861 9,378 10,470 8,000 8,000 0 0 0 0 0 0 0 0 0 0 32,138 27,498 42,497 30,000 35,000 0 (1,532) (739) 0 0 0 0 0 0 0 $1,529,091 $1,603,302 $1,879,477 $1,557,000 _ �^ $1,733,500 Page One 2014 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - June 10, 2013 Account # Description 2010 Actual 2011 Actual 2012 Actual 2013 Adopted Budget 2014 Object Detail Amount 2014 Proposed Budget Comments All Salary Costs Inclusive of 601 49400 101.00 Salaries & Benefits $421,600 Salary, Taxes, PERA & Benefits 601 4940077 101.00 Administrative 117,561 110,344 120,763 107,300 110,400 6014940078 101.00 Technical /Clerical 158,239 136,304 144,153 144,200 148,400 6014940079 101.00 Maintenance 137,759 138,854 146,589 159,300 162,800 601 49400 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 601 49400 102.00 Full -Time Overtime 8,493 9,378 7,794 8,000 8,000 601 49400 103.00 Part-Time Salaries & Benefits 8,521 6,289 6,112 8,000 8,000 601 4940099 103.01 Utility Commission Wages (50 %) 1,000 50 %- 601; 50 %- 602 6014940099 103.02 Maintenance Labor 7,000 100 % -601 601 4940001 203.00 Printed Forms & Paper 1,832 1,196 2,260 2,000 2,000 Inserts & Water Bill Statements 601 49400 01 209.00 Other Office Supplies 97 238 749 200 200 601 49400 01 216.00 Chemicals & Chemical Products 62,382 59,746 66,610 65,000 70,000 Chlorine, Flouride, Polyphos 601 4940001 219.00 Other Operating Supplies 0 465 97 200 200 Maintenance Supplies 601 4940001 220.00 Water Meter Purchases 80,000 Meters, MIU's & CU Horns 601 49400 01 220.01 For Replacements 6,275 0 0 10,000 40,000 New Meter Standards 601 49400 01 220.02 For New Homes 53,511 23,283 46,600 30,000 40,000 Water Rate Model (3% Growth) 601 4940001 224.00 Street Maintenance Materials 1,468 3,720 637 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 0 279 208 500 500 Topsoil, Seed & Sod 601 4940001 228.00 Meter Repair Materials 0 0 0 300 0 601 49400 01 229.00 Other Maintenance Supplies 14,200 601 4940001 229.01 Supplies for Hydrants 5,398 5,849 4,599 6,000 6,000 601 4940001 229.02 Curb Shutoffs 1,355 554 1,097 1,000 1,000 601 49400 01 229.03 GV Repair /Replacement 0 0 2,574 2,200 2,200 601 49400 01 229.04 Miscellaneous Supplies 2,035 4,626 4,438 5,000 5,000 601 4940001 241.00 Small Tools 1,607 1,513 1,792 2,000 2,000 Wrenches, Shovels, etc. 601 49400 01 242.00 Minor Equipment 2,897 2,095 609 3,000 3,000 601 49400 01 303.00 Engineering Fees 37,500 601 49400 01 303.01 WHPP 0 0 474 0 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 0 0 2,539 10,000 5,000 601 49400 01 303.03 Rate Study 159 0 0 0 7,500 601 4940001 303.04 Miscellaneous Fees 30,959 40,828 28,450 20,000 20,000 6014940001 304.00 Legal Fees 0 94 1,269 1,000 1,000 601 49400 01 310.00 Testing Services 44,000 601 4940001 310.01 Bacteria & Water Quality 1,616 1,734 1,560 2,000 2,000 Radon, Tri-Chl, 601 49400 01 310.02 V.O.C., Pesticides, etc. 0 1 0 1,000 1,000 601 49400 01 310.03 CU -PB Testing 40,487 40,901 41,623 41,000 41,000 $6.36 /Connection - Annual Fee (M) 601 49400 01 312.00 Gopher State One -Call 2,315 2,098 2,559 3,500 3,500 Gopher State One -Call (M) 601 49400 01 31100 Temporary Service Fees 1,913 23,401 6,190 0 0 601 49400 01 315.00 Special Programs 0 601 4940001 315.01 Public Information 0 0 0 0 0 601 49400 01 315.02 Plan Amendments 0 0 0 0 0 601 4940001 315.03 Seminars 0 0 0 0 0 601 4940001 318.00 Contract Engineer 6,000 7,000 8,000 7,000 7,000 Contracted Engineer for City(20 %) 601 4940001 319,00 Other Professional Services 17,500 601 49400 01 319.01 Thaw Pipes, Check Leaks, etc. 870 200 311 1,500 1,500 601 49400 01 319.02 Supervisory Controls 7,329 3,015 910 5,000 5,000 SCADA 601 4940001 319.03 Hazardous Chemical Permits 0 0 725 1,000 1,000 MN Department of Public Safety 601 4940001 319.05 Hazardous Chemical Inventory 0 0 0 1,100 0 601 4940006 319.06 Contracted Hydrant Painting 9,996 9,800 9,922 10,000 10,000 120 Hydrants / Yr ($82 each) 601 4940001 320.00 Credit Card Activity Fees 0 0 0 0 5,000 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 2,284 2,354 2,646 2,500 2,500 Cell Phones, Modesm, GPS 601 4940001 322.00 Postage Costs 4,299 4,504 4,678 5,000 5,000 Billings with Inserts 601 4940001 323.00 Radio Units 1,083 1,211 1,116 1,500 1,500 24 Units' $300 (Split 5 Ways) 601 49400 01 333.00 Freight & Express Expenses 0 0 0 100 0 Mail -in Repairs 601 4940001 349.00 Other Advertising 0 0 0 500 0 601 49400 01 352.00 General Notices & Public Info 0 0 78 500 0 Newsletters 601 49400 01 365.00 Workers Comp Insurance 6,641 7,089 6,807 6,000 7,000 Water's Share of Premiums 601 4940001 369.00 Other Insurance 19,414 10,487 10,746 20,000 12,000 Water's Share of Premiums 601 4940001 391.00 P.C. Maintenance 467 491 2,700 601 4940001 391.01 U/B Software Maintenance 0 0 1,827 2,000 2,000 Added to Utility Budgets in 2012 601 4940001 391.02 Auto Read Software Support 0 0 585 700 700 Added to Utility Budgets in 2012 601 4940001 392.00 P.C. Accessories & Supplies 359 128 0 200 200 601 49400 01 393.00 P.C. Hardware Purchases 11,488 320 1,637 4,000 3,000 AV Enhancements at PW 601 4940001 394.00 P.C. Software Purchases 5,378 4,574 7,800 601 49400 01 394.01 Licensing & Maintenance 0 0 4,843 4,600 6,500 Cartegraph, GIS 601 4940001 394.02 Online Subscriptions 0 0 308 300 800 Pictometry 601 4940001 394.03 New Software Purchases 0 0 7,868 4,400 500 AV Enhancements at PW 601 4940001 395.00 P.C. Repairs 0 0 0 500 500 PAGE TOTALS - - -- 722,489 ° - - 664,963 - - -- - -- --- 705,356 - ---- -- - - 713,800 - - ---- - -- ---- --------------- 769,900 Page Two 2014 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - June 10, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 601 49400 01 403.00 Contracted R & M - Other Impr 970 10,544 22,113 6,000 6,000 Watermain Breaks 601 49400 01 416.00 Machinery Rental 0 0 0 1,000 0 601 49400 01 433.00 Dues & Subscriptions 1,794 45 73 1,800 400 Suburban Utility Supt Assn 601 49400 01 435.00 Books & Pamphlets 0 0 23 300 300 Reference Materials 601 49400 01 437.00 Conferences & Seminars 4,500 601 49400 01 437.01 MDH Training (Water School) 778 588 755 1,000 2,000 Operator Licensure (M) 601 49400 01 437.02 AWWA Conference 0 0 0 500 0 601 49400 01 437.03 CarteGraph, ESRI, GIS 0 157 270 1,500 1,500 User Group, Conference, Training 601 49400 01 437.04 Miscellaneous Training 0 0 0 0 1,000 601 49400 01 439.00 Other Miscellaneous Charges 12,741 15,235 16,646 15,000 45,000 DNR Annual Water Use (M) 601 49400 01 521.00 Building & Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W. Building (16 of 20) 601 49400 01 530.00 Improvements Other Than Bldgs 400,600 601 4940001 530.01 Well Inspections 560 560 560 600 600 601 49400 01 530.02 Miscellaneous Improvements 5,237 0 1,050 5,000 5,000 601 49400 01 530.03 CRP of Watermain 0 0 0 150,000 150,000 Annual Pavement Management 601 49400 01 530.04 Inspection & Maintenance 0 0 20,000 150,000 245,000 Next 5 -Year Average Expenditure 601 49400 01 570.00 Office Equipment Purchases 42 0 58 1,000 1,000 601 49400 01 611.00 Interest on Lease Payments 3,554 3,232 2,893 0 0 P.W. Building Expension(See 521) 601 4940001 710.00 Transfers 0 298,666 200,000 0 0 Transfers for Other Improvements 601 - 49400 -01 TOTALS - 748,165 993,990 969,797 1,057,500 �Y ^1,237,700 601 49406 01 221.00 Equipment Parts 77 512 0 500 500 601 49406 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49406 01 319.00 Other Professional Services 0 0 0 1,000 1,000 601 49406 01 381.00 Electric Utilities 1,003 1,304 995 1,300 1,300 Pumping & Lighting TOTAL-PRV 1,080 1,816 995 3,000 3,000 601 49407 01 221.00 Equipment Parts 720 779 5,968 2,000 500 601 49407 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49407 01 319.00 Other Professional Services 0 0 0 0 0 601 49407 01 321.00 Telephone Costs 211 211 211 300 300 601 4940701 381.00 Electric Utilities 19,548 18,322 21,934 22,000 30,000 Pumping & Lighting 601 49407 01 409.00 Other Contracted Repairs & Maint 0 3,741 0 4,500 1,000 601 49407 01 439.00 Other Miscellaneous Charges 0 100 0 100 100 Contingencies 601 49407 01 530.00 Improvements Other Than Bldgs 0 3,219 101 0 0 TOTAL - WELL #7 20,479 26,370 28,213 29,100 32,100 601 49408 01 221.00 Equipment Parts 491 2,390 2,024 2,000 500 601 49408 01 223.00 Building Repair Supplies 0 0 15 200 200 601 4940801 319.00 Other Professional Services 0 0 0 0 0 601 49408 01 381.00 Electric Utilities 3,060 14,969 21,917 15,000 25,000 Pumping & Lighting 601 4940801 383.00 Gas Utilities 497 468 428 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs & Maint 0 0 0 7,000 20,000 Driveway, Sidewalk, Curb & Gutter 601 49408 01 439.00 Other Miscellaneous Charges 0 100 0 100 100 Contingencies 601 4940801 530.00 Improvements Other Than Bldgs 11,700 1,809 0 1,000 0 TOTAL - WELL #8 - - ------ 15,748 - -- -- - - - -- ----- 19,736 - - ---- 24,385 - - - - - - -- 25,900 ----- -- - - -- -- - -- ---- - - - --- 46,400 601 49409 01 221.00 Equipment Parts 10,602 1,009 3,955 3,000 1,000 601 49409 01 223.00 Building Repair Supplies 34 0 0 200 200 601 4940901 319,00 Other Professional Services 0 0 0 0 0 601 49409 01 381.00 Electric Utilities 20,988 27,268 25,692 28,000 35,000 Pumping & Lighting 601 49409 01 383.00 Gas Utilities 609 547 627 1,500 1,500 Heat Only 601 4940901 409.00 Other Contracted Repairs & Maint 0 0 0 2,000 1,000 601 49409 01 439.00 Other Miscellaneous Charges 0 100 259 100 100 Contingencies 601 49409 01 530.00 Improvements Other Than Bldgs 13,000 1,809 101 22,500 1,000 TOTAL - WELL #9 - - ---- 45,234 - -- - -- - - -- 30,732 - - - - -- 30,633 ------ - ------ 57,300 - -- ---- ---- -- -- --- --- - - -- -- 39,800 -T1 Page Three 2014 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - June 10, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 601 49410 01 219.00 Other Operating Supplies 0 0 1 500 500 601 49410 01 221.00 Equipment Parts 4,150 1,469 1,062 3,500 1,000 601 49410 01 223.00 Building Repair Supplies 0 9 0 200 200 601 49410 01 321.00 Telephone Costs 765 765 765 800 0 Removing Phone Line in 2013 601 49410 01 381.00 Electric Utilities 12,182 12,489 13,189 14,000 15,000 Pumping & Lighting 601 4941001 409.00 Other Contracted Repairs & Maint 0 0 1,703 1,500 500 601 49410 01 439.00 Other Miscellaneous Charges 0 50 0 100 100 Contingencies 601 4941001 530.00 Improvements Other Than Bldgs 0 0 0 1,000 0 TOTAL - WELL #10 - 17,097 _ 14,782 -- 16,720 21,600 - -^ - 17,300 Rural Water System 601 49411 01 221.00 Equipment Parts 1,426 1,565 0 0 0 601 49411 01 439.00 Other Miscellaneous Charges 0 50 0 0 0 TOTAL- WELL #11 1,426 1,615 0 0 0 Rural Water System ( #2) 6014941201 221.00 Equipment Parts 550 1,134 1,847 1,000 1,000 601 49412 01 223.00 Building Repair Supplies 0 0 10 200 200 601 4941201 319.00 Other Professional Services 0 0 0 0 0 601 49412 01 381.00 Electric Utilities 15,214 19,190 22,444 25,000 30,000 Pumping & Lighting 601 4941201 409.00 Other Contracted Repairs & Maint 0 6,101 278 5,000 1,000 601 49412 01 439.00 Other Miscellaneous Charges 0 100 0 100 100 Contingencies TOTAL - WELL #12 15,764 26,525 24,578 31,300 - - 32,300 601 4941401 221.00 Equipment Parts 1,545 1,104 1,063 500 500 601 49414 01 223.00 Building Repair Supplies 0 0 0 200 200 601 4941401 319.00 Other Professional Services 0 0 1,097 1,000 1,000 601 49414 01 381.00 Electric Utilities 27,328 29,008 24,193 30,000 30,000 Pumping & Lighting 601 4941401 409.00 Other Contracted Repairs & Maint 0 2,138 0 3,000 7,000 SCADA Reconfiguration, PLC 601 4941401 439.00 Other Miscellaneous Charges 0 100 0 100 100 Contingencies 601 4941401 530.00 Improvements Other Than Bldgs 0 0 0 22,500 1,000 TOTAL - WELL #14 28,872 32,349 26,353 57,300 39,800 601 4942501 221.00 Equipment Parts 1,962 1,096 3,629 500 500 601 49425 01 223.00 Building Repair Supplies 0 0 0 200 200 601 4942501 319.00 Other Professional Services 0 353 0 500 500 601 49425 01 381.00 Electric Utilities 27,050 25,190 23,461 30,000 30,000 Pumping & Lighting 601 49425 01 383.00 Gas Utilities 0 0 0 0 0 Electricity Only 601 4942501 409.00 Other Contracted Repairs & Maint 0 0 0 2,500 500 601 4942501 439.00 Other Miscellaneous Charges 0 48 185 100 100 Contingencies 601 49425 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 - TOTAL - WELL #15 -- - - - - -- -- 29,012 --- - - - -- -- 26,687 27,276 - - -- ----- - --- - 33,800 -- --- -- - ----- 31,800 Page Four 2014 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - June 10, 2013 Account # Description 601 49415 01 221.00 Equipment Parts 601 4941501 319.00 Other Professional Services 601 4941501 409.00 Other Contracted Repairs & Maint 601 49415 01 439.00 Other Miscellaneous Charges 601 49415 01 530.00 Improvements Other Than Bldgs TOTAL - WATER TOWER #1 (Chippendale Water Tower) 601 4941601 221.00 Equipment Parts 601 4941601 319.00 Other Professional Services 601 4941601 381.00 Electric Utilities 601 4941601 409.00 Other Contracted Repairs & Maint 601 49416 01 439.00 Other Miscellaneous Charges 601 49416 01 530.00 Improvements Other Than Bldgs TOTAL - WATER TOWER #2 (Connemara Water Tower) 601 49417 D1 221.00 Equipment Parts 601 4941701 319.00 Other Professional Services 601 4941701 381.00 Electric Utilities 601 49417 01 409.00 Other Contracted Repairs & Maint 601 49417 01 439.00 Other Miscellaneous Charges 601 4941701 530.00 Improvements Other Than Bldgs TOTAL - WATER TOWER #4 (Bacardi Water Tower) 601 4941801 221.00 Equipment Parts 601 4941801 319.00 Other Professional Services 601 4941801 381.00 Electric Utilities 601 4941801 409.00 Other Contracted Repairs & Maint 601 4941801 439.00 Other Miscellaneous Charges 601 4941801 530.00 Improvements Other Than Bldgs TOTAL - WATER TOWER #3 (East Side Water Tower) GRAND TOTAL - ALL DEPTS 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 600 122 0 500 500 Touch -up Paint 0 0 0 0 0 0 0 0 500 500 0 100 0 200 200 Contingencies 0 0 0 0 0 600 222 0 1,200 --- - - -` -- - - - -- -1,200 383 2,500 0 500 500 Touch -up Paint 0 0 0 0 0 Tower Inspection 1,325 712 429 1,400 1,400 0 2,945 0 500 500 0 0 0 200 200 Contingencies 0 0 0 0 0 1,708 6,156 - -- -- 429 2,600 � - - - - -- 2,600 28 28 4,261 0 500 500 0 0 0 0 0 4,539 4,267 5,345 2,000 6,000 0 122 0 500 7,000 SCADA Reconfiguration, PLC 0 0 0 200 200 Contingencies 0 0 0 300 0 4,567 8,651 5,345 3,500 13,700 0 0 0 500 500 0 0 3,800 0 0 1,885 1,648 1,885 5,000 3,000 3,000 0 792 500 500 0 0 28 200 200 Contingencies 0 0 0 0 0 4,885 1,648 6,505 6,200 -�- _ 4,200 $934,635 --- - - - - -- --------- $1,191,281 --- - - -- -- --- - - -- -- $1,161,229 --- - - - - -- --- - - -- -- $1,330,300 --- - -- - -- ---- - - --- - - - - -- ---- - - $1,501,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, 95 miles of sanitary sewer lines and 7,400 service connections for the collection and treatment of sewage. $1,030,000 covers one line item of the 2014 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 57% 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 2008 2009 2010 2011 2012 2013 est 31.2% 25.6% 31.7% 31.3% 26.7% 33% Number of Sewer Blockages on City System Per 100 Connections 2008 2009 2010 2011 2012 2013 n/a n/a 0.08 0.0 0.1 n/a n/a — Information Not Available Page One 0 2014 BUDGET WORKSHEETS SEWER UTILITY -REVENUES - June 10, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account 4 Description Actual Actual Actual Budget Amount Budget Comments 602 33425.00 Other State Grants & Aids $1,208 $0 $0 $0 $0 602 34108.00 Administrative Fees -Other Funds 590 2,123 5,733 0 0 5% of 5% Fees -Const Projects 602 36101.00 Principal - Special Assessments 69,472 77,214 192,425 75,000 80,000 602 36102.00 Penalties & Interest - S/A 0 2,775 1,783 0 0 602 36210.00 Interest Earnings - Investments 58,124 40,077 24,678 50,000 25,000 602 36214.00 Net Change in FV- Investments (2,364) 3,447 725 0 0 Annual Market Value Changes 602 36215.00 Interest Earnings 754 282 240 500 500 602 36260.00 Other Revenues 0 2,212 0 0 0 602 36265.00 Use of Reserve Funds 0 0 0 267,700 260,800 602 37210.00 Residential Sewer Revenues 1,080,354 1,135,626 1,274,698 1,150,000 1,200,000 602 37220.00 Apartment Sewer Revenues 95,269 101,697 106,160 100,000 100,000 602 37225.00 Institutional Sewer Revenues 21,443 22,231 23,868 21,000 23,000 602 37230.00 Commercial Sewer Revenues 61,252 63,367 65,411 61,000 65,000 602 37240.00 Industrial Sewer Revenues 47,286 47,106 47,136 47,000 47,000 602 37260.00 Penalties - Sewer Revenues 11,308 11,327 12,809 10,000 10,000 602 39103.00 Gain or Loss from F/A Disposal 0 (3,421) 0 0 0 602 39203.00 Transfer From 0 0 238,964 0 0 FUND TOTALS $1,444,695 --------- $1,506,064 --- - - - - -- $1,994,630 --- - - - --- $1,782,200 --- - - - - -- $1,811,300 -- - - - - -- --- - -- - -- 0 Page One 2014 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - June 10, 2013 2013 2014 Objed 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 602 49450 101.00 Salaries & Benefits $421,600 Salary, Taxes, PERA & Benefits 6024945077 101.00 Administrative 117,536 110,563 120,762 107,300 110,400 6024945078 101.00 Technical /Clerical 158,239 136,305 144,154 144,200 148,400 6024945079 101.00 Maintenance 137,759 138,718 146,589 159,300 162,800 602 49450 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 602 49450 102.00 Full -Time Overtime 8,493 9,029 7,794 7,500 7,500 602 49450 103.00 Part-Time Salaries & Benefits 8,291 8,880 8,025 9,000 9,000 602 49450 99 103.01 Utility Commission Wages (50 %) 1,000 50% - 602; 50% - 601 602 49450 99 103.02 Maintenance Labor 8,000 100%-602 602 49450 01 203.00 Printed Forms & Paper 1,258 1,195 1,499 1,500 1,500 Inserts & Water Bill Statements 602 49450 01 209.00 Other Office Supplies 0 0 227 200 200 602 49450 01 216.00 Chemicals & Chemical Products 0 0 0 500 500 Root Killer, Degreaser 602 49450 01 219.00 Other Operating Supplies 0 0 0 200 200 602 49450 01 224.00 Street Maintenance Materials 1,550 1,425 0 2,500 2,500 Patching 602 49450 01 225.00 Landscaping Materials 0 0 0 400 400 Topsoil, Seed & Sod 602 49450 01 227.00 Utility System Maintenance Supplies 667 18 3,292 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 241.00 Small Tools 185 417 802 500 500 Wrenches, Shovels, etc. 602 49450 01 242.00 Minor Equipment 2,897 1,285 414 3,000 3,000 602 49450 01 303.00 Engineering Fees 27,500 602 49450 01 303.01 GIS 121 129 2,539 5,000 5,000 602 49450 01 303.02 Rate Study 0 0 0 0 7,500 602 49450 01 303.04 Miscellaneous 4,721 4,148 2,395 15,000 15,000 Sewer System O &M Review 602 49450 01 304.00 Legal Fees 0 0 286 500 500 602 49450 01 312.00 Gopher State One -Call 2,315 2,092 2,559 3,500 3,500 Gopher State One -Call (M) 602 49450 01 313.00 Temporary Service Fees 1,913 14,559 0 0 0 602 49450 01 318.00 Contract Engineer 6,000 7,000 8,000 7,000 7,000 Contracted Engineer for City(20 %) 602 49450 01 319.00 Other Professional Services 10,000 6024945001 319.01 Televising 1,550 1,720 531 3,000 3,000 602 49450 01 319.02 Root Control 2,307 0 0 2,000 2,000 602 49450 01 319.03 Supervisory Controls(Maint Cont) 0 3,356 0 5,000 5,000 SCADA System 602 49450 01 320.00 Credit Card Activity Fees 0 0 0 0 5,000 113 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 2,284 2,312 2,646 2,500 2,500 Cell Phones, Modems, GPS 602 49450 01 322.00 Postage Costs 4,299 4,504 4,678 5,000 5,000 Billings with Inserts 602 49450 01 323.00 Radio Units 1,083 1,211 1,116 1,500 1,500 24 Units " $300 (Split 5 Ways) 602 49450 01 333.00 Freight & Express Expenses 0 0 0 100 0 602 49450 01 341.00 Employment Advertising 0 0 0 300 0 602 49450 01 349.00 Other Advertising 0 0 0 500 0 602 49450 01 365.00 Workers Comp Insurance 6,643 7,109 6,828 7,000 7,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 10,766 5,307 6,443 15,000 12,000 Sewer's Share of Premiums 602 49450 01 391.00 P.C. Maintenance 467 491 0 2,700 602 49450 01 391.01 U/B Software Maintenance 0 0 1,827 2,000 2,000 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 0 0 585 700 700 Added to Utility Budgets in 2012 602 49450 01 392.00 P.C. Accessories & Supplies 138 0 0 200 200 602 49450 01 393.00 P.C. Hardware Purchases 1,370 320 1,362 4,000 3,000 AV Enhancements at PW 602 49450 01 394.00 P.C. Software Purchases 5,378 4,574 7,800 602 49450 01 394.01 Licensing & Maintenance 0 0 4,779 4,800 6,500 Cartegraph, GIS 602 49450 01 394.02 Online Subscriptions 0 0 308 300 800 Pictometry 602 49450 01 394.03 New Software Purchases 0 0 7,772 4,400 500 AV Enhancements at PW 602 49450 01 395.00 P.C. Repairs 0 0 0 500 500 602 49450 01 403.00 Contracted R & M - Other Impr 18,926 0 3,533 5,000 5,000 MH Castings Replacement Frog. 602 49450 01 415.00 Other Equipment Rental 0 0 0 200 200 602 49450 01 416.00 Machinery Rental 0 0 0 2,000 2,000 602 49450 01 433.00 Dues & Subscriptions 50 23 50 100 200 SUSA (AJ, Dick) 50% Split w /Storm 602 49450 01 435.00 Books & Pamphlets 0 0 0 300 300 Reference Materials 602 49450 01 437.00 Conferences & Seminars 1,001 4,000 602 49450 01 437.01 MPCA Training (Sewer School) 0 23 90 800 1,500 Operator Licensure $300 each (M) 602 49450 01 437.02 Collection System Conference 0 950 1,310 1,000 0 Duplicate of Sewer School 437.01 602 49450 01 437.03 CarteGraph, ESRI, GIS 0 158 270 1,500 1,500 User Group, Conference, Training 602 49450 01 437.04 Miscellaneous Training 0 0 0 0 1,000 602 49450 01 439.00 Other Miscellaneous Charges 145 144 153 100 100 Contingencies 602 49450 01 521.00 Building & Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W. Building (16 of 20) 602 49450 01 530.00 Improvements Other Than Bldgs 160,000 602 49450 01 530.01 Miscellaneous Improvements 0 0 0 10,000 10,000 SCADA Reconfiguration, PCL's 602 49450 01 530.02 Misc. Improvements /Repairs 0 0 0 0 0 602 49450 01 530.03 CRP of Sewermain 0 0 0 150,000 150,000 Annual Pavement Management 602 49450 01 530.04 0 0 0 0 0 602 49450 01 540.00 Heavy Machinery Purchases 0 0 0 0 0 602 49450 01 560.00 Furniture & Fixture Purchases 0 0 0 500 500 602 49450 01 570.00 Office Equipment Purchases 0 0 0 500 500 -- PAGE TOTALS - - - --- --- 508,353 ---- - - ---- ------ 467,964 --- - -- - -- 493,620 ----- - - - - -- 712,900 ---- --------- ------ --- - -- 730,400 Page Two 2014 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - June 10, 2013 Account # Description 602 49450 01 602.00 Sewer Service Charges 602 49450 01 611.00 Interest on Lease Payments 602 49450 01 710.00 Transfers 602- 49450 -01 TOTALS 602 49451 01 219.00 Other Operating Supplies 602 49451 01 221.00 Equipment Parts 602 49451 01 229.00 Other Maintenance Supplies 602 49451 01 303.00 Engineering Fees 602 49451 01 381.00 Electric Utilities 602 49451 01 403.00 Contracted R & M - Other Impr 602 49451 01 439.00 Other Miscellaneous Charges (City Hall) TOTAL - LIFT STATION #1 602 49452 01 219.00 Other Operating Supplies 602 49452 01 221.00 Equipment Parts 602 49452 01 229.00 Other Maintenance Supplies 602 49452 01 321.00 Telephone Costs 602 49452 01 381.00 Electric Utilities 602 49452 01 403.00 Contracted R & M - Other Impr 602 49452 01 439.00 Other Miscellaneous Charges (Bloomfield 5th) TOTAL - LIFT STATION #7 602 49453 01 219.00 Other Operating Supplies 602 49453 01 221.00 Equipment Parts 602 49455 01 229.00 Other Maintenance Supplies 602 49453 01 381.00 Electric Utilities 602 49453 01 403.00 Contracted R & M - Other Impr 602 49453 01 439.00 Other Miscellaneous Charges (Shannon Pond) TOTAL - LIFT STATION #3 602 49454 01 219.00 Other Operating Supplies 602 49454 01 221.00 Equipment Parts 602 49454 01 229.00 Other Maintenance Supplies 602 49454 01 381.00 Electric Utilities 602 49454 01 403.00 Contracted R & M - Other Impr 602 49454 01 439.00 Other Miscellaneous Charges (Hawkins) TOTAL - LIFT STATION #4 602 49455 01 219.00 Other Operating Supplies 602 49455 01 221.00 Equipment Parts 602 49455 01 229.00 Other Maintenance Supplies 602 49455 01 303.00 Engineering Fees 602 49455 01 310.00 Testing Services 602 49455 01 381.00 Electric Utilities 602 49455 01 403.00 Contracted R & M - Other Impr 602 49455 01 439.00 Other Miscellaneous Charges (LeForet Add'n) TOTAL - LIFT STATION #5 602 49456 01 219.00 Other Operating Supplies 602 49456 01 221.00 Equipment Parts 602 49456 01 229.00 Other Maintenance Supplies 602 49456 01 381.00 Electric Utilities 602 49456 01 403.00 Contracted R & M - Other Impr 602 49456 01 439.00 Other Miscellaneous Charges (Drumcliffe) TOTAL - LIFT STATION #6 2013 2014 Objecl 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 923,221 981,478 940,900 1,030,000 1,030,000 MWCC Charges 3,554 3,232 2,893 0 0 P.W. Building Expansion(See 521) 0 172,451 10,493 0 _ 0 Transfers for Other Improvements 1,435,129 1,625,124 1,447,906 1,742,900 1,760,400 0 0 0 100 100 182 4,215 21 800 800 0 0 0 200 200 0 5,499 0 0 0 948 1,058 925 1,500 1,500 0 0 0 200 200 0 0 0 100 100 Contingencies 1,129 10,772 947 2,900 2,900 0 0 0 100 100 0 2,697 59 800 800 0 0 0 200 200 211 211 105 0 0 558 620 554 700 700 0 0 0 200 200 0 0 0 100 100 Contingencies 769 23,528 719 _ 2,100 -- -2,100 0 0 0 100 100 9,421 338 0 800 800 0 0 0 200 200 3,546 3,154 3,578 3,500 4,000 0 0 230 200 200 0 0 0 100 100 Contingencies 12,967 3,492 3,808 4,900 5,400 0 0 0 100 100 3,387 478 2,001 800 800 0 0 0 200 200 5,560 4,898 5,377 6,000 6,000 0 3,195 0 200 10,000 Alarm Upgrades, SCADA, PLC 0 0 0 100 100 Contingencies 8,947 8,571 7,377 7,400 17,200 0 0 0 100 100 724 31,500 0 800 800 0 0 0 200 200 0 0 0 0 0 0 0 0 0 0 5,125 5,609 5,879 6,000 7,000 0 0 0 200 200 0 0 0 100 100 Contingencies 5,849 - -- -- - - ---- 37,108 - --- - --- -- 5,879 ---- ---- -- ---- - 7,400 - - - - -- - - - - --- 8,400 0 0 0 100 100 203 118 4,247 800 800 0 0 0 200 200 5,060 6,614 3,788 7,500 5,000 0 0 0 200 3,000 Alarm Upgrades 0 0 0 100 100 Contingencies 5,263 - 6,732 - -- - - -- 8,035 ----- -- - - ---- ----- 8,900 - - -- -- - -- - - ---- 9,200 Page Three 2014 BUDGET WORKSHEETS SEWER UTILITY • EXPENDITURES - June 10, 2013 Account # Description 602 49457 01 219.00 Other Operating Supplies 602 49457 01 221.00 Equipment Parts 602 49457 01 229.00 Other Maintenance Supplies 602 49457 01 321.00 Telephone Costs 602 49457 01 381.00 Electric Utilities 602 49457 01 403.00 Contracted R & M - Other Impr 602 49457 01 439.00 Other Miscellaneous Charges (Glendalough 5th) TOTAL - LIFT STATION #9 602 49458 01 219.00 Other Operating Supplies 602 49458 01 221.00 Equipment Parts 602 49458 01 229.00 Other Maintenance Supplies 602 49458 01 321.00 Telephone Costs 602 49458 01 381.00 Electric Utilities 602 49458 01 403.00 Contracted R & M - Other Impr 602 49458 01 439.00 Other Miscellaneous Charges (Meadows of) TOTAL - LIFT STATION #8 (Bloomfield) 602 49460 01 219.00 Other Operating Supplies 602 49460 01 221.00 Equipment Parts 602 49460 01 229.00 Other Maintenance Supplies 602 49460 01 321.00 Telephone Costs 602 49460 01 381.00 Electric Utilities 602 49460 01 403.00 Contracted R & M - Other Impr 602 49460 01 439.00 Other Miscellaneous Charges (Glen Rose) TOTAL - LIFT STATION #10 GRAND TOTAL - ALL DEPTS 2010 Actual 2011 Actual 2012 Actual 2013 2014 Object Adopted Detail Budget Amount 2014 Proposed Budget Comments 0 0 0 100 100 1,659 0 0 500 500 0 0 0 200 200 0 0 0 0 0 982 1,103 1,176 1,200 1,200 0 0 0 200 200 0 0 0 100 100 Contingencies 2,641 _ 1,103 1,176 2,300 2,300 0 0 0 100 100 237 6,612 353 500 500 0 0 0 200 200 0 0 0 0 0 473 552 522 800 800 0 0 0 200 200 0 0 0 100 100 Contingencies 710 7,164 875 1,900 1,900 0 0 0 100 100 0 497 294 500 500 0 0 0 200 200 0 0 0 0 0 183 295 251 400 400 0 0 0 200 200 0 0 0 100 100 Contingencies 183 793 545 1,500 1,500 $1,473,586 --- - - - - -- --------- $1,704,387 --- - - - - -- - -- - -- - -- $1,477,266 --- - - - - -- --- - - - --- $1,782,200 --- - -- - -- -- - - - - -- --- - -- - -- -- -- - - -- $1,811,300 --- - -- - -- --- - - - - -- it 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 • 3,200 catch basins • 84 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 2008 2009 2010 2011 2012 2013 (est 149 59 62 411* 167 100 * All sumps are inspected and rated on the following scale: 1: 0 -25% full 2: 25 -50% full 3: 50 -75% full 4: 75 -100% full Only sumps with ratings of 3 or 4 are cleaned each year. Many sumps that had been rated 2 for several years (just below the threshold for cleaning) received a rating of 3 or 4 in 2011. 5M Page One June 10, 2013 Account # 2014 BUDGET WORKSHEETS STORM WATER UTILITY -REVENUES - Description 2010 Actual 2011 Actual 2012 Actual 2013 2014 Object Adopted Detail Budget Amount 2014 Proposed Budget Comments 603 33400.00 State Grants & Aids $3,816 $0 $0 $0 $0 603 33425.00 Other State Grants & Aids 1,208 0 0 0 0 603 34108.00 Administrative Fees -Other Funds 590 2,123 5,733 0 0 5% of 5% Fees -Const Projects 603 36101.00 Principal - Special Assessments 17,868 22,204 22,418 20,000 20,000 603 36102.00 Penalties & Interest - S/A 0 732 514 0 0 603 36210.00 Interest Earnings - Investments 28,485 45,136 24,205 30,000 20,000 603 36214.00 Net Change in FV- Investments (11,555) 2,198 479 0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 617 245 262 400 300 603 36260.00 Other Revenues 0 0 0 0 0 603 36265.00 Use of Reserve Funds 0 0 0 0 0 603 37300.00 Storm Water Utility Revenues 835,434 879,551 908,679 860,000 900,000 603 37360.00 Penalties - Storm Water Utility 3,901 3,690 5,416 3,600 4,700 603 39203.00 Transfer From 0 0 0 0 0 FUND TOTALS $880,364 $955,878 $967,705 $914,000 _ ^ $945,000 Page One 2014 BUDGET WORKSHEETS STORM WATER UTILITY -EXPENDITURES - June 10, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 603 49500 101.00 Salaries & Benefits $176,800 Salary, Taxes, PERA & Benefits 6034950077 101.00 Administrative 0 0 4,036 10,700 11,000 603 49500 78 101.00 Technical /Clerical 95,473 76,109 88,359 79,600 81,600 603 49500 79 101.00 Maintenance 68,879 69,358 73,294 81,400 84,200 603 49500 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 603 49500 102.00 Full -Time Overtime 4,296 4,568 3,958 6,000 6,000 603 49500 99 103.00 Part-Time Salaries & Benefits 7,954 9,334 6,824 8,000 8,000 603 49500 01 203.00 Printed Forms & Paper 1,258 1,195 1,726 1,500 1,500 603 49500 01 204.00 Envelopes & Letterhead 0 0 0 0 0 603 49500 01 208.00 Miscellaneous Supplies 0 0 352 1,600 500 Stakes, Ribbons, Level, etc. 603 49500 01 215.00 Shop Materials 0 0 0 0 0 603 49500 01 219.00 Other Operating Supplies 0 0 0 0 0 603 49500 01 221.00 Equipment Parts 0 0 0 0 0 603 49500 01 224.00 Street Maintenance Materials 1,578 406 1,199 2,000 2,000 Blacktop & Gravel Washouts 603 49500 01 225.00 Landscaping Materials 4,000 603 49500 01 225.01 Rip -Rap, Matting, Rock, etc. 408 1,751 1,386 2,000 2,000 603 49500 01 225.02 Black Dirt, Seed, Sod, etc. 299 1,962 1,370 2,000 2,000 603 49500 01 226.00 Sign Repair Materials 287 926 0 500 500 603 49500 01 230.00 Equipment Repair Material 204 534 881 1,000 1,000 603 49500 01 241.00 Small Tools 0 0 87 1,000 1,000 603 49500 01 242.00 Minor Equipment 2,747 332 221 2,000 2,000 Misc. Nozzles for Vac Truck 603 49500 01 303.00 Engineering Fees 75,000 603 49500 01 303.01 Problem Area Investigations 31,441 10,003 3,501 10,000 10,000 603 49500 01 303.02 NPDES Phase II 28,763 0 29,749 30,000 30,000 603 49500 01 303.03 CSMP Update 15,076 22,880 36 0 0 603 49500 01 303.04 Miscellaneous 8,525 29,866 4,186 30,000 30,000 603 49500 01 303.05 GIS 0 0 1,672 5,000 5,000 603 49500 01 304.00 Legal Fees 0 234 0 2,000 2,000 603 49500 01 310.00 Testing Services 0 0 0 1,000 1,000 Water Quality Tests (M) 603 49500 01 312.00 Contract Inspection Fees 0 0 0 500 500 3rd Part Inspection Program (M) 603 49500 01 313.00 Temporary Service Fees 1,275 9,706 0 0 0 603 49500 01 315.00 Special Programs (County Program) 4,500 4,500 3,850 5,000 5,000 Wetland Health & Evaluation Proj 603 49500 01 318.00 Contract Engineer 6,000 7,000 8,000 7,000 7,000 Contracted Engineer for City(20 %) 603 49500 01 319.00 Other Professional Services 0 3,356 0 5,000 5,000 SCADA 603 49500 01 320.00 Credit Card Activity Fees 0 0 0 0 5,000 113 Cost of C/C Pymt Processing 603 49500 01 321.00 Telephone Costs 2,284 2,312 2,647 2,500 2,500 Cell Phones, Modems, GPS 603 49500 01 322.00 Postage Costs 4,299 4,504 4,678 5,000 5,000 Billings & Info Mailings 603 49500 01 323.00 Radio Units 1,083 1,210 1,116 1,500 1,500 24 Units' $300 (Split 5 Ways) 603 49500 01 352.00 General Notices & Public Info 58 0 0 1,000 1,000 Public Info Brochure 603 49500 01 365.00 Workers Comp Insurance 2,640 2,875 2,654 3,500 3,500 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 4,927 2,393 2,362 6,000 4,000 Storm Water's Share of Premiums 603 49500 01 384.00 Refuse Disposal 0 0 0 600 0 603 49500 01 389.00 Other Utility Services 0 0 0 500 0 603 49500 01 391.00 P.C. Maintenance 467 491 2,700 603 49500 01 391.01 U/B Software Maintenance 0 0 1,827 2,000 2,000 Added to Utility Budgets in 2012 603 49500 01 391.02 Auto Read Software Support 0 0 585 700 700 Added to Utility Budgets in 2012 603 49500 01 393.00 P.C. Hardware Purchases 0 320 1,362 4,000 3,000 AV Enhancements at PW 603 49500 01 394.00 P.C. Software Purchases 5,378 4,574 7,800 603 49500 01 394.01 Licensing & Maintenance 0 0 4,779 4,800 6,500 Cartegraph, GIS 603 49500 01 394.02 Online Subscriptions 0 0 308 300 800 Pictometry 603 49500 01 394.03 New Software Purchases 0 0 7,772 4,400 500 AV Enhancements at PW 603 49500 01 403.00 Contracted R & M - Other Impr 55,000 603 49500 01 403.01 Ditching 0 0 0 5,000 5,000 603 49500 01 403.02 Miscellaneous Repairs 46,150 22,899 17,830 50,000 50,000 Storm System Maint., Catch Basins 603 49500 01 416.00 Machinery Rental 939 43 0 4,000 4,000 Pumps • 603 49500 01 433.00 Dues & Subscriptions 140 140 140 0 200 SUSA(AJ, Dick) 50% Split w /Storm 603 49500 01 435.00 Books & Pamphlets 0 0 0 500 500 Utility Information 603 49500 01 437.00 Conferences & Seminars 3,700 603 49500 01 437.01 Storm Water Management 875 875 965 1,000 1,200 Stormwater Collab, Flygt Training 603 49500 01 437.03 Wetlands Training 0 0 0 500 0 603 49500 01 437.04 Cartegraph, ESRI, GIS 0 157 270 1,500 1,500 User Group, Conference, Training 603 49500 01 437.05 Miscellaneous Training 0 0 0 0 1,000 603 49500 01 439.00 Other Miscellaneous Charges 145 144 153 0 0 603 49500 01 530.00 Improvements Other Than Bldgs 150,000 603 49500 01 530.01 CRP of Storm Sewer 11,997 2,669 597 150,000 150,000 Annual Pavement Management 603 49500 01 560.00 Furniture & Fixture Purchases 0 0 0 500 500 603 49500 01 580.00 Other Equipment Purchases 0 0 0 2,000 2,000 603 49500 01 586.00 Computer Equipment Purchases 0 0 0 500 500 PAGE TOTALS -- -- 360,346 -- -- - -- - -- ----- 299,624 -- -- -- 284,731 - - - - - -- 547,100 - -- -- --- - -- - -- ---- --- - -- 551,200 Page Two 2014 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - June 10, 2013 Account # Description 2010 Actual 2011 Actual 2012 Actual 2013 Adopted Budget 2014 Object Detail Amount 2014 Proposed Budget Comments 603 49500 01 710.00 Transfers 87,000 603 49500 01 710.01 1/2 of 2011 P & I Payments(1996B) 0 0 0 0 0 Bonds Called 2/1/08 603 49500 01 710.02 1/2 of 2011 P & I Payments(1999C) 0 0 0 0 0 Bonds Called 2/1108 603 49500 01 710.03 1/2 of 2011 P & I Payments(2001B) 54,000 0 0 0 0 Bonds Called 2/1111 603 49500 01 710.04 1/2 of 2011 P & I Payments(2001D) 0 0 0 0 0 Bonds Paid off 2/1/08 603 49500 01 710.05 1/2 of 2011 P & 1 Payments(2002B) 33,000 8,000 0 0 0 Bonds Called 2/1/11 603 49500 01 710.06 1/2 of 2011 P & I Payments(2010A) 0 60,000 84,000 89,000 87,000 New Refunding Issue 12/10 603 49500 01 710.07 1/2 of 2011 P & I Payments(2003A) 42,000 90,000 0 0 0 Bonds Called 12/1/11 603 49500 01 710.10 Projects 9,542 233,607 68,296 0 0 603 - 49500 -01 TOTALS - 498,888 691,232 - 437,027 636,100 -- -- 638,200 603 49511 01 221.00 Equipment Parts 1,771 0 0 500 500 603 49511 01 381.00 Electric Utilities 269 264 258 500 500 603 49511 01 403.00 Contracted Repair & Maintenance 0 0 0 0 0 (Copper Pond) TOTAL- LIFT STATION #1 2,040 264 258 - 1,000 _ 1,000 603 49512 01 221.00 Equipment Parts 237 880 390 500 500 603 49512 01 381.00 Electric Utilities 0 0 0 500 500 603 49512 01 403.00 Contracted Repair & Maintenance 0 0 0 0 0 (Schwarz Pond) TOTAL - LIFT STATION #2 - -- 237 --- - 880 - - - -- - - - -- 390 - ----- 1,000 - - - -- -- 1,000 603 49513 01 221.00 Equipment Parts 0 375 0 500 500 603 49513 01 381.00 Electric Utilities 7,844 4,401 2,698 4,500 4,500 603 49513 01 403.00 Contracted Repair & Maintenance 0 0 0 0 0 (Birger Pond) TOTAL - LIFT STATION #3 - 7,844 4,776 2,698 5,000 - _ - 5,000 603 49514 01 221.00 Equipment Parts 0 931 0 500 500 603 49514 01 381.00 Electric Utilities 1,265 1,653 947 2,000 2,000 603 49514 01 403.00 Contracted Repair & Maintenance 0 0 0 0 3,000 Alarm Upgrades (Marcotte Pond) TOTAL - LIFT STATION #4 - -1,265 - 2,585 -947 - 2,500 - - - 5,500 603 49515 01 221.00 Equipment Parts 0 0 0 500 500 603 49515 01 381.00 Electric Utilities 0 0 0 500 500 603 49515 01 403.00 Contracted Repair & Maintenance 0 0 -- 0 0 10,000 Alarm Upgrades, SCADA, PLC (Hawkins Pond) TOTAL - LIFT STATION #5 - - 0 - 0 - - -- 0 - - --- 1,000 - - -- - - - - -- 11,000 603 49516 01 221.00 Equipment Parts 0 0 0 500 500 603 49516 01 381.00 Electric Utilities 463 415 460 500 500 603 49516 01 403.00 Contracted Repair & Maintenance 0 0 0 0 0 (Glendalough 7th) TOTAL - LIFT STATION #6 463 415 460 1,000 1,000 GRAND TOTAL - ALL DEPTS. $510,737 --- - - - - -- --------- $700,152 --- - - - - -- --- - - - - -- $441,779 --- - - - - -- --- - -- - -- $647,600 - -- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- $662,700 --- - - - - -- -- - - - - - -- sm ICE ARENA ADMINISTRATION The Parks and Recreation Department administer the Ice Arena. Scheduling and invoicing of ice are the main administrative duties of ice arena operations. The scheduling of prime time ice is coordinated with Independent School District #196 and Rosemount Area Hockey Association for practices, games and tournament play. The Parks and Recreation Department provides overall planning, coordination, management of personnel and administration of ice arena activities. COMMUNITY USE • Provides recreational open skating for the residents of Rosemount as well as learning to skate and figure skating programs. MAINTENANCE • Provides ongoing and preventative maintenance of the ice arena building structure and its mechanical components. Ensures ice is maintained at optimal efficiency. PERFORMANCE MEASURES Number of Ice Arena Hours Utilized 2008 2009 2010 2011 2012 2,544 2,466 2,577 2,514 2,332 n/a — Information Not Available 0 Page One 2014 BUDGET WORKSHEETS ARENA - REVENUES June 25, 2013 Account # Description 650 36210.00 Interest Earnings - Investments 650 36215.00 Interest Earnings 650 36230.00 Adopted Detail Contributions /Donations 650 36260.00 Actual ---- ----- - - - --- - Other Revenue - Learn to Skate 650 36265.00 Comments ------------- ------------- -- --- ------- --- - -- Use of Reserve Funds 650 38060.00 $0 Prime Time Ice Fees 650 38061.00 137 Non -Prime Time Ice Fees 650 38063.00 Open Skating Ice Fees 650 38064.00 0 Broomball Revenues 650 38065.00 30,122 Other Events - Arena 650 38066.00 Learn to Skate Program (LTS) Advertising Revenue - Arena 650 38067.00 0 Skate Sharpening Revenue - Arena 650 38090.00 251,519 Concessions 650 38091.00 Vending Machine Revenues 650 38095.00 74,000 Pro Shop Revenues 650 39103.00 5,259 Gain or Loss from F/A Disposal 650 39201.00 Transfer From General Fund FUND TOTALS r6A 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual ---- --- --- - -- -- Actual ---- ----- - - - --- - Actual ---- --- - - - -- -- Budget Amount ----- --- - --- - -- ------ -- - - -- Budget ---- ---- -- - - --- Comments ------------- ------------- -- --- ------- --- - -- $274 $486 $897 $0 $0 274 137 142 100 100 0 0 0 0 0 39,709 30,122 33,551 31,000 31,000 Learn to Skate Program (LTS) 0 0 0 0 21,300 247,457 251,519 238,721 251,000 245,000 87,068 73,792 55,772 74,000 65,000 5,216 5,259 4,587 6,000 5,000 0 0 0 0 0 Moved to Prime /Non -Prime Times 0 0 0 0 0 Dry Floor Events 13,000 3,500 8,375 10,000 10,000 3,636 3,322 2,628 3,500 3,000 3,900 3,900 3,900 3,900 3,900 5,974 5,771 4,737 6,000 5,000 837 863 658 1,000 1,000 Tape, Laces, Mouthguards, etc. 0 0 0 0 0 115,000 --------- - - --- 115,000 --- - - 115,000 115,000 115,000 Subsidy for Operations - 522,345 -- - - - - -- -------- --- --- - - -- -- 493,669 -- - - - - -- -- - - - - -- ----- -- - - -- -- 468,968 -- - - - - -- -- - - - - -- - --- -- -- - - --- -- ----- ---- - - - --- 501,500 -- - - - - -- -- - - - - -- -- - - - - -- -- - - - - -- --------------- 505,300 -- - - - - -- -- - - - - -- r6A Page One 2014 BUDGET WORKSHEETS ARENA - EXPENDITURES June 25, 2013 Account # Description 650 45130 101.00 Salaries & Benefits 650 45130 77 101.00 Administrative 650 45130 78 101.00 Technical /Clerical 650 45130 79 101.00 Maintenance 650 45130 xx 101.00 Salary & Benefit Contingency 650 45130 79 102.00 Full -Time Overtime 650 45130 103.00 Part-Time Salaries & Benefits 650 45130 89 10100 Learn -To -Skate Program 650 45130 99 103.00 Building Attendants 650 45130 01 207.00 Training & Instructional Supplies 650 45130 01 208.00 Miscellaneous Supplies 650 45130 01 208.01 Skate Magnets 650 45130 01 208.02 Other Supplies 650 45130 01 209.00 Other Office Supplies 650 45130 01 211.00 Cleaning Supplies 650 45130 01 212.00 Motor Fuels 650 45130 01 216.00 Chemicals & Chemical Products 650 45130 01 219.00 Other Operating Supplies 650 45130 01 221.00 Equipment Parts 650 45130 01 223.00 Building Repair Supplies 650 45130 01 265.00 Other Items for Resale 650 45130 01 305.00 Medical & Dental Fees 650 45130 01 311.00 Officiating Fees 650 45130 01 317.00 General Fund Admin Fees 650 45130 01 321.00 Telephone Costs 650 45130 01 331.00 Travel Expense 650 45130 01 341.00 Employment Advertising 650 45130 01 349.00 Other Advertising 650 45130 01 365.00 Workers Comp Insurance 650 45130 01 369.00 Other Insurance 650 45130 01 381.00 Electric Utilities 650 45130 01 383.00 Gas Utilities 650 45130 01 384.00 Refuse Disposal 650 45130 01 401.00 Contracted Building Repairs 650 45130 01 404.00 Contracted Mach & Equip Repairs 650 45130 01 415.00 Other Equipment Rental 650 45130 01 433.00 Dues & Subscriptions 650 45130 01 437.00 Conferences & Seminars 650 45130 01 439.00 Other Miscellaneous Charges 650 45130 01 521.00 Building & Structure Purchases 650 45130 01 580.00 Other Equipment Purchases 650 45130 01 710.00 Transfers 650 45130 01 710.01 Yearly Maintenance 650 45130 01 710.02 650 45130 01 710.03 FUND TOTALS VON 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual -------- - - - - -- -- Actual ----- -- - - -- -- ----- Actual ---- -- - - -- Budget --- Amount Budget Comments ----- - - -- - -- --------- - -- - -- --------- - - - - -- --------------------------------------------- All Salary Costs Inclusive of $159,400 Salary, Taxes, PERA & Benefits 43,775 42,725 40,250 40,500 40,500 34,427 35,363 36,545 37,600 37,600 67,022 73,447 76,702 81,300 81,300 0 0 0 0 0 2,456 1,494 490 2,000 2,000 40,000 20,097 16,286 16,975 17,000 17,000 24,507 22,000 26,885 23,000 23,000 And Other PIT Positions 0 0 0 100 100 700 0 100 0 100 100 0 484 0 600 600 185 0 47 500 500 Learn to Skate Program Supplies 3,409 4,198 4,079 4,000 4,000 0 0 0 0 0 Zamboni Maintenance 4,835 4,249 5,535 5,000 5,000 Cooling Tower 38 156 209 500 500 Events Supplies 3,034 7,425 4,836 6,000 6,000 826 2,590 1,335 3,000 3,000 333 269 484 600 600 Pro Shop Supplies 0 0 0 0 0 0 0 0 0 0 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Admin Fee Policy 1,174 1,340 1,413 1,300 1,300 0 0 0 100 100 0 0 0 0 0 110 115 115 400 400 3,567 3,254 3,402 3,500 3,500 7,671 3,679 4,637 8,000 8,000 115,700 125,740 130,420 120,000 125,000 23,885 26,328 22,141 27,000 24,000 3,178 2,817 2,833 3,500 3,000 1,928 10,189 5,580 7,000 7,000 19,230 22,730 35,889 22,000 25,000 0 0 0 300 300 868 720 745 1,000 1,000 MIAMA & MRPA Dues 0 0 0 400 400 MIAMA & MRPA Seminars 0 0 0 0 0 Contingencies 0 0 0 0 0 42,000 12,000 15,541 60,000 75,000 Cooling Tower, Skate Sharpener 3,500 3,500 3,500 3,500 3,500 3,500 0 0 0 0 0 0 0 0 0 0 ------ - ----- 433,757 -- - -- - -- -------- ------ --- - - ---- 429,196 -- - - - - -- -- - - - - -- ----- -- -- - --- -- 446,587 -- - - - - -- -- - - - - -- ------ --- - --- -- 485,800 -- - - - - -- -- - - - - -- ----- ---- - - - - -- -- - - - - -- -- - - - - -- - ---- --- - - --- -- 505,300 -- - - - - -- -- - - - - -- VON