The URL can be used to link to this page

Home My WebLink About9.d. 2014 Budget DiscussionROSEMOUNTEXECUTIVE SUMMARY CITY COUNCIL City Council Work Regular Meeting September 3, 2013 AGENDA ITEM: 2014 Budget Discussion AGENDA SECTION: New Business PREPARED BY: Dwight Johnson, City Administrator AGENDA NO. Jeff May, Finance Director ATTACHMENTS: Resolution, 2014 Preliminary Budget APPROVED BY: RECOMMENDED ACTION: Adopt a Resolution Setting the Preliminary 2014 General Fund Operating Budget, the Preliminary 2014 C.I.P. Budgets, the Preliminary 2014 Insurance Budget, the Preliminary 2014 Port Authority Operating Levy and the Preliminary 2013 Levy and Budget Hearing Date Required by the City of Rosemount EXECUTIVE SUMMARY The recommended budget for 2014 proposes an increase in the City's property tax levy of 1.55 %. This would result in an estimated annual increase of $18 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 $878. 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 $180 since 2008. The proposed increase in levy is less than the rate of inflation for the past year. 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. 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 have evaluated the amount of savings based on 2012 sales tax payments. A preliminary number of $90,000 in General Fund 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 is 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.13% +$287,628 - 806,042 +$18 +2.10% -2.34% (from .48862 to .47719) 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. Staff spent several weeks calculating in detail what we paid in 2012 and used this amount to estimate the savings in 2014. The draft budget assumes a savings of $90,000 in the General Fund. 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) 2413 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 $280,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 fiill 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. 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. K Health Insurance Our preliminary increase in health insurance premium for 2014 is 11.7 %. However, a special reserve fund established two years ago will help buffer the increase and therefore require only 7.65% increase in the 2014 budget. Additional quotes are being sought to reduce the increase. 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. 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, the water and sewer budgets have been reviewed and approved by the Utilities Commission for 2014. The proposed water rate increase is 5% in order to continue building up funds for a potential water treatment plant later this decade. The proposed sewer rate increase is 2 %. 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.55% this year. One of the main reasons for an increase is to provide additional maintenance and operating costs for both new and existing facilities. The overall increase is still less than the current rate of 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 4 UMore Park, new athletic fields on the Flint Hills property, a new underpass under Highway 3, improvements to Erickson Park, senior exercise equipment, new tennis courts, new trail projects, improvements to both the Steeple Center and the Community Center, and various neighborhood amenities. 5 CITY OF ROSEMOUNT DAKOTA COUNTY, MINNESOTA RESOLUTION 2013 - A RESOLUTION SETTING THE PRELIMINARY 2014 GENERAL FUND OPERATING BUDGET, THE PRELIMINARY 2014 C.I.P. BUDGETS, THE PRELIMINARY 2014 INSURANCE BUDGET, THE PRELIMINARY 2014 PORT AUTHORITY OPERATING LEVY AND THE PRELIMINARY 2013 LEVY AND BUDGET HEARING DATE REQUIRED BY THE CITY OF ROSEMOUNT WHEREAS, the City Council of the City of Rosemount has determined that budgets and special needs for the year 2014 will be in the amount of $17,095,800 for the General Operating Fund, the three CIP Funds, the Insurance Fund, the Port Authority Fund and the Enterprise Funds; and WHEREAS, the City Council has determined that special levies for Bonded Indebtedness and the Armory Project total $375,622; and WHEREAS, the City Council has determined that actual incomes, fund transfers and anticipated aids will total $6,850,000. NOW, THEREFORE BE IT RESOLVED, that the total Preliminary Levy certified to the Dakota County Auditor shall be $10,621,422; and BE IT FURTHER RESOLVED, that the City Council of the City of Rosemount will conduct a Public Hearing for the purpose of presenting the proposed budget and levy to the general public and to comply with Truth in Taxation laws as set by the Minnesota State Legislature, and that the hearing shall take place on Tuesday, December 3, 2013, at 7:30 P.M., in the Council Chambers at the City Hall. ADOPTED this 3rd day of September, 2013. William H. Droste, Mayor ATTEST: Amy Domeier, City Clerk 2014 CITY BUDGET REPORT !$ROSEMOUNT MINNESOTA RESOLUTION 2013 - CERTIFICATION I hereby certify that the foregoing is a true and correct copy of a resolution presented to and adopted by the City Council of Rosemount at a duly authorized meeting thereof, held on the 3rd day of September, 2013, as disclosed by the records of said City in my possession. (SEAL) Amy Domeier, Rosemount City Clerk z DAKOTA COUNTY City of Rosemount PROPERTY TAXATION & RECORDS -- - T-AXING DISTRICT NAME PAYABLE 2014 PROPOSED LEVY CERTIFICATION FORM FORM B �t�x .......drtiir�s =':s ....C.:. .I.?a.. ..t....? ." ..�.." ...:....'!" .�.'.r.': ...............:...:...': . ...: :..:...:...::..: : :.......:.......:.......:.....: e. ...n.-.......................................:.....:.,...:.....:.......:.. .�....... .vF.., .m�....c...aA..i........... ..............................- .=:............:.........:." . .......'q:" .."i...i.E .,l. t .,:. . a9":.m.:.....:.t:. CAS€....:.... .........................e... . :st.a..Q.t . h Uer�r....e...� .................................... ...............:......,:....:,...:.... � :.:. .e .. r. ti.f .. l. e d.,.. R:. X1:.l�C.............:. :. :.: CRT_. Tom. -' � CAP�►(�t� � AS;ED l.�Y � ; � . _ _� General Revenue $ 17,095,800 $ -0- $ 6,850,000 $ 10,245,800 Debt - General Obligation* 375,622 -0- -0- 375,622 Debt - Other* Road and Bridge Other (identify) TotalTcap Based Levy $ 17,471,422 $ -0- $ 6,850,000 is 10,621,422 MARKETREFEREND�UMBASEDLEKVYs n'°5rt' ''F "" W', Debt - General Obligation* Debt - Other* Other Total Mkt Referendum Levy $ $ $ $ * Provide a breakdown of the certified levy by individual bond on the reverse side or attach an additional sheet. A- Budget Requirement.................... .................................... ...................... Amount needed to fund services. ( See Attached) B -LGA (Local Government Aid) ................................. ............................... These aids are certified to the taxing district by the Department of Revenue. This can be used to reduce any budget item levy requirement, combination of items or be deducted proportionally from all levies. C -Other Resources ................................................... ............................... All other resources that will be used to finance your taxing districts budget. Including but not limited to other aids, interest income, prior year reserves, grants, etc. D- Certified Levy ................... ............................... ....... ............................... Le vy certified ifed to the Coun ty Treasurer - Auditor. ROUND TO THE NEAREST WHOLE DOLLAR. DO NOT CERTIFY PENNIES. The Treasurer - Auditor's office will deduct Fiscal Disparities from all certified levies. Before signing, please verify the following: -MAKE SURE THAT ALL LINES ADD ACROSS AND ALL COLUMNS ADD UP TO THE TOTAL LINE - BREAKDOWN OF DEBT SERVICE LEVY BY INDIVIDUAL BOND HAS BEEN PROVIDED - AMOUNTS REPO TED MATCH ANY OTHER SUPPORTING DOCUMENTATION INCLUDED Cd vy his form matches amount on your taxing district's resolution, etc.) (651) 322 -2031 Signat e o e on completing form Phone number (including area -code) Finance Director 9 -6 -13 Date 2013 GENERAL PROPERTY TAX LEVY PAYABLE 2014 GENERALLEVY GENERAL FUND $8,688,800 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,245,800 BONDEDINDEBTEDNESS G.O. 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,621,422 -------- - - - - -- -------------- Last Updated 8/21/13 &bbbbb0000boo 6 o d d v m g�:E °vOT - -c m a v ?]c� m� o m�� m DDDO 0 ov'cow m 'Z CL A m m s 5 m 3 0� d tu O W N O O O 0 0 a c N N ' . 3 =� ;u on mw t v c O m m c 1 Dpi O O O Z c N A W T = p X 7 7 7 -> n (D 0 c= 7 0 OW IT 0 cL N N 7 CL d .tan ((4 m a O N N "a N 0 j mtp NN�'N TOO�NO i! 0 O O .: N N C O O V m 0 00 0 WDDaoco �aDDA°DO, DNON f11 to N y 0 w 0 o c No 05 3 a 0 D W D a a to o D N N O O a) I I � I I N V W O II O I I N V O II O 11 O II r W 11 W W II W II O 11 O I I N 0 W OD W II0o Gf II CO, II I I N 11 -_ V II W 11 N I I N 11 II W O) II II O ii w V i N 11 W I I N IM O 7 CL d m W N ( W t0 -4 j N W OD -4 tD W W i W d A V W V N V 00 V 00 y 0) OI N N PPP_ O N 0 0 0 0 0 0 0 0 0 0 0 0 W 0 0 0 0 0 0 0 0 0 0 0 0 j V 0 W r j A I N O 4 C* p C 7 N P N O N 1 .a W 0 0 00000 0000000 i A �'p OOOOO 0000000 O , 01 •D 0 0 0 0 0 0 0 0 0 0 0 0 0 O w NAA V N0NM W -� A N 0 O W W f o V O 0 0 0 0 0 4 V W 0 V V AO t00) A N N Vt O N A N N O V O N O N 7 M 0000 V 00000 V OO (D O O o 0 0 0 0 0 0 0 N O O ` Q e► N = CD NNA A W AT W 000 O W W N V 0 0 to N W M s V W O O t0 V V A O O W I A W N N O t n A N N P.-4 O (n 0.0 7 0 0 0 o V to N O (o O V 0 0 O 00000 00000 (o00 S A a e W � (o t0 j N 70000 W V W 0 O j V V A o 0 W 1 O p N N O. N. 5:).-4 O o . I c C w 0 0 0 0 0 0 0 0 N 06 I W Q !iN 7 7 01 7 7 7 W j 3 J r d d d W m 01 Ol W tr N N. < 0 OD A N O O O w 0 con a 0 7 7 7 W 7 7 7 N N N d U1 ➢1 01 d O �< 0 0 0 0 0 a 0 0 0 0 Dj T -nv 0-8 N 0 O In o N N N (7 (� O O O N tD ID C c c O O N N g z z N a a O. .� 0 0 0 0 0 N 0 rn 5.5 !D N N to N333 N 0 N 7 � 7 5 5 N Q. 0 0 m T 7 Ol 0 �4' C a S m 0 0 c A N m K v m 0 av 0 5 DAKOTA COUNTY OFFICE OF PROPERTY TAXATION & RECORDS PAYABLE 2014 TRUTH IN TAXATION PUBLIC BUDGET MEETING DATE CERTIFICATION FORM A Taxing District Name: City of Rosemount Public Meeting Date: Tuesday, December 3, 2013 Time of meeting: 7:30 P.M. Place of meeting: Rosemount City Hall (including address) 2875 145th Street West Rosemount, MN 55068 PLEASE PROVIDE CONTACT INFORMATION, ADDRESS AND PHONE NUMBER AS YOU WOULD LIKE IT TO APPEAR ON THE TNT NOTICES. (Please limit to five lines only.) Name and/or Title: Finance Director Address: City of Rosemount 2875 145th Street West Rosemount, MN 55068 Phone number: ( 651) 322 -2031 Website or E -mail Address: www.ci.rosemount.mn.us No personal (home) e-mail If you would like an e-mail contact or your website listed on the notice, addresses please. please complete. No e: y are n t re uired to provide this information. Signature of person completing this form: Title: i n n e Director Phone number: (651) 322 -2031 Date: September 6, 2013 * ** *Please include area code when identifying phone numbers * * ** DAKOTA COUNTY PROPERTY TAXATION & RECORDS Dakota County Administration Center 1590 Highway 55 Hastings MN 55033 651.438.4576 Fax 651.438.4399 www.dakotacounty.us Certification of 2012 Sales and Use Tax For Property Tax Saving Report Name of Jurisdiction City of Rosemount Estimate of 2012 Sales and Use Tax Q61ij" - Aut46rizkdMignature Finance Director Title Jeffrey A. May (651) 322 -2031 Contact Person and Phone Number $126,104 Return no later than September 16, 2013 to: Dakota County Property Taxation & Records Attn: Taxation 1590 Highway 55 Hastings, MN 55033 O:\TaxationMuth in Taxation\2014 \Certification of Sales Tax.doc 9 -6 -13 Date FUNDING REQUIREMENTS - USES (INCLUDING FIRE STATION LEVY) September 3, 2013 NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. 2013 2014 Adopted Proposed +►. Departments Budget Budget Difference Percentage Council Budget $247,700 $252,600 $4,900 1.98% Sales Tax Exemption Savings $0 ($90,000) ($90,000) n/a Administration Budget 484,400 500,000 15,600 3.22% Elections Budget 22,000 40,000 18,000 81.82% Finance Budget 435,300 463,400 28,100 6.46% General Government Budget 383,200 374,200 (9,000) -2.35% Community Development Budget 896,800 926,100 29,300 3.27% Police Budget 3,187,800 3,346,100 158,300 4.97% Fire Budget 437,000 437,300 300 0.07% Public Works Operating Budgets: Government Buildings Budget 540,500 504,100 (36,400) -6.73% Fleet Maintenance Budget 645,200 676,200 31,000 4.80% Street Maintenance Budget 1,272,200 1,333,400 61,200 4.81% Parks Maintenance Budget 739,100 831,600 92,500 12.52% Park &Rec Budget- General Operating 1,130,000 1,166,300 36,300 3.21% Park & Rec Budget - Steeple Ctr. Operations 64,500 61,200 (3,300) -5.12% Park & Rec Budget - Senior/ Activity Center 14,000 15,000 1,000 7.14% Park & Rec Budget - Special Programs 113,900 111,500 (2,400) -2.11% Transfers - Arena Assistance 115,000 115,000 0 0.00% Total Operating Budgets - General Fund $10,728,600 - - --- --- $11,064,000 ------ - ---- - ---- $335,400 -- ------ - --- -- 3.13% Building CIP Requirements 24,000 24,000 0 0.00% Street CIP Requirements 730,000 740,000 10,000 1.37% Equipment CIP Requirements 460,000 490,000 30,000 6.52% Insurance Budget Requirements 245,000 245,000 0 0.00% Port Authority Operating Levy 58,000 58,000 0 0.00% Bonded Indebtedness 377,394 375,622 (1,772) -0.47% Bonded Indebtedness - Fire Station Levy 0 0 0 0.00% Armory Anticipatory Levy (Value 3/9/12) 86,000 0 (86,000) - 100.00% *'$1,931,934,605 x .00798% _ $154,168" Water Enterprise Fund 1,330,300 1,500,900 170,600 12.82% Sewer Enterprise Fund 1,782,200 1,810,300 28,100 1.58% Storm Water Enterprise Fund 647,600 659,700 12,100 1.87% Arena Enterprise Fund 485,800 - ----- -- -- -- - - - -- 503,900 --- ----- ----- -- - -- 18,100 ---- 3.73% Total Funding Requirements $16,954,894 $17,471,422 -- ---- -- -- -- -- $516,528 --------------- -- 3.05% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. FUNDING REQUIREMENTS -SOURCES (INCLUDING FIRE STATION LEVY) September 3, 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,245,800 Adopted Proposed -------- ----- - - - - -- $10,459,694 +/- Types Budget Budget Difference Percentage Internal Revenue Generated: $16,954,894 ---- - - - - -- ---------- $17,471,422 ---- - - - - -- ---- ---- - - - - -- ---- $516,528 - - - - -- -- - - - - -- -- 3.05% - - - - -- - - - - -- 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,474,800 228,900 5.39% Total Internal Revenues 6,495,200 6,850,000 354,800 5.46% 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,245,800 249,500 2.50% -------- ----- - - - - -- $10,459,694 --- ----- --- ---- - -- ------------ $10,621,422 - - - - -- -- $161,728 -- --- - -- -- -- 1.55% $0 $0 $0 0.00% $16,954,894 ---- - - - - -- ---------- $17,471,422 ---- - - - - -- ---- ---- - - - - -- ---- $516,528 - - - - -- -- - - - - -- -- 3.05% - - - - -- - - - - -- NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. 2013 GENERAL PROPERTY TAX LEVY PAYABLE 2014 GENERAL LEVY GENERAL FUND $8,688,800 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,245,800 BONDEDINDEBTEDNESS G.O. 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,621,422 -------- - - - - -- -------------- Last Updated 8/21113 MINNESOTA- REVENUE 2014 Levy Limit Form COMPLETE AND RETURN BYJULY 19, 2013, T0: Minnesota Department of Revenue Property Tax Division Mail Station 3340 St. Paul, MN 55146 -3340 Phone: 651 -556 -6095 Email: Bill.Sparks @state.mn.us Date: Name of Governmental Unit: Name and Title of Person Filling out Form: Email Address: Telephone: 7 -83 13 City of Rosemount Jeffrey A. May, Finance Director jeff.may @ci.rosemount.mn.us 651 - 322 -2031 Total amount of: Pay 2012 Pay 2013 1. Bonded Indebtedness (Based on Net Tax Capacity) 441,326 377,394 2. Certificates of Indebtedness 3. Payments for Bonds of Another Local Unit of Government 4. Principal and Interest on Armory Bonds 86,000 86,000 5. Market Value Based Referendum Levies 6. Preparing for or Repairing the Effects of Natural Disasters 7. Levies for Economic Development Tax Abatements under M.S. 469.1815 8. Levy for Storm Sewer Improvement District Costs under M.S. 444.20 9. Levy for All Other Purposes Not Listed Above 9,804,500 9,996,300 10. Total Payable Certified Levies 110,331,826 10,459,694 *Note: You must return this completed form to the Department of Revenue by July 19, 2013. MINNESOTA- REVENUE 2014 LOCAL GOVERNMENT AID NOTICE July 30, 2013 ROSEMOUNT CITY OF CLERK - CITY HALL 2875 145TH ST W ROSEMOUNT, MN 55068 THE 2014 CERTIFIED LGA FOR YOUR CITY IS: $0 Based on Laws of Minnesota 2013, Chapter 143, Article 2, the following is the determination of your 2014 Local Government Aid (LGA). 1. Certified 2013 LGA: $0 2. Certified 2014 LGA: $0 3. Difference between 2013 and 2014 LGA: $0 Local Government Aid is calculated using a number of need -based and capacity, or ability to pay, factors. Each city's factor values and calculation are available on our website: http: / /www.i-evenue.state.mn.us /local g_ov/prop tax admin/Pages /Iga.aspx Sincerely, Bill Sparks and Chelsea Griffin If you have any questions regarding this certification, contact Bill Sparks at bill.sparks(2cstate.mn.us and (651) 556 -6095 or Chelsea Griffin at chel sea. criffin@statexn n.us and (651) 556 -6101. Property Tax Division Mail Station 3345 St. Paul, MN 55146 -3345 Tel: 651 -556 -6095 Fos: 651 -556 -3128 7TY: Call 711 for Minnesota Relay An equal opportunity employer 1 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,471,422 Less: Internal Revenues 6,092,800 6,357,600 6,495,200 6,850,000 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,621,422 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,621,422 County Auditor Adjustments (All Subtractions): Fiscal Disparities Distribution Levy (Metro Area) 1,299,717 1,252,954 1,235,453 1,208,535 (2) Spread Levy Used to Compute Local Tax Rate 9,518,780 (1) 9,078,872 (1) 9,224,241 (1) 9,412,887 Increase /(Decrease) from Previous Year in Spread Levy -4.62% 1.60% 2.05% 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 815113 (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 - 8121/13 !1 FOc .0� o35 a n -1 - 1 ° m < m 1 K L1 a m x 1 ° p Oy Z °o -0 ' % 0 N#$ 0 { q i 1 x 1 and „ x J A 0 0 I m ° c e to 0 n m m °c o v o c ° m y °0' v 3 0 n ° ° o-° . o m0 0 0 m W O C Ol j C y 2 n J O 8.12. W l0 11W OOION OOWW o< ry 11 A Z r N II N II N O N C 1 o v W ^� w�. 2 �° n q �1 m % m, 2 �n c m nu 0 w T 11 V II 'D V N+ W tp oAC w a II tr II O (Vii 00 AJAOVi ° 3 3 3 3 O J � + I I ,�.. II N I N II J A 0 0 I N J A J (q (] n Z N T O+ II tT II b U�!I N+ W fp W J A O (pW�1 :0g S II iNp II I OA ON W C C Ol j C y 2 n J O 11 O V W W l0 11W OOION OOWW O J � + I I ,�.. N W �� w N N A % T O tp (] n Z N T O+ II tT II b U�!I N+ W fp W J A O N m m W a II W II W W O A I O V+ W N N C C Ol j C y 2 n J O y o o< ry 11 A Z r N II N II N O N C 1 p1 0 WWW 0, m C r T II II II II T <� N w G N 0 w T 11 V II 'D V N+ W tp 0 O 3 a II tr II O (Vii 00 AJAOVi O J � b of N Q a �• ,G W d 6 I I ,�.. N W �� w N •'�• O w % II A O O m N m w r31n M N 99.S a 6 W k �' po N J C Ol j C y 2 n J O y C 1 d a _ 3 o D T <� N Z8 I N NN N m N N N N J � pWp OVOA� W � W Of Oo O A A 11 � m � m m m q 3 [[[v]]] 3 A q q fp 0 3 0 et T N O O O V Z 6 S Sgq Om n � N n� d d d 3 a m n °v m a o dmm �D_ n0 M -z -zi� q 43. � o < w q T L a R D D° A o 3 p1 m 7 m i 1 Xn N fia n. N o ° $o w1 O m o 01 � q m O S ii i I 0Q00 8 N Q� �; A OO��I pppyA Nppp W { gip 8 N I S00 II ON W A OOD i O Np Op II W �{JpA0 W I W O V II (f(T�I A N o W ONOO II W � AOUIiNN WW I I SO II A � OAO f00 � OV O so- pop II N q II pppp O ONNAI O II A pNp ONI W V INp 8N0 11 O ASNW S G 11 I OW O W OV.J1 u w u '0 II yy o ii 8jo 11 N {N�myN AtO1O A N v II A A O tr W Ol A N (O A II A + W O O O O O O O O O O O .. W N ± A I I S N OO II A W A A II N N S p >pppp SS 11 GA1 LQ pp A °1 O H O II W pppp9O� I ANN N O O O 11 V W b W O A N A N OWO O 000 II+ � C II 1 SQ�j (y o3 (y�JII 8Q O II A tpW0pWipp1 N W V A m D II N N ON II O AOWiNb O � � II N O +O A i A N OWO 0 000 it I o �, I p 11 pgpo pO II A Ap+p{pm. 10p v II (!J !� p j W W II S I W 10 + W I II A I 4 O W I A n o w N + II I ? II I 0 0 0 q 99 p Sp I I O I O N N A r I I N N o N NW II p �tWO °NjN O � II m > W W W W �SN II S J+tD W A II V OIA00 OO W to NS II Y II I O O O SQO�S II 11- poop �o ONIJ Qp4p� 0 j II W I°O N ilApO ++ U& O W O J OOO N N OVo poop ppS NBO II W °Oi(v� W ppppAppO� W II N O 0 0 II A m Y ^ A 0 II CJ � N II O I A W O� N A A W II N W V I+ W V+ 11 N I O W O N I OWO m OWl O I �jW Npp i O(p�p� N Cppp + II A i 0 f° O f0!' � W 0°iC W fNil 1 00 d 1 3 m ; O % JZ' A A 3 0 � G `! 3 I+ a a+ w 0 0 0 I� M m OMs A 00o ii 8 OSS I � ��OlI pNppp fJ> � +SS II N 01A Ni1OO O N W - O O O ONO II N I OWWO IVtO� N01 W W W W 6899 11 A N V W J + wm O SE D SNS 11 OtDD m (1OTN+ W N O N S I I O A W+ 10 W N ;2 °• x p I I I n c N 00o ii v'0 _ poop ON O II A (pUOp�1I W S �A�p �N S II N NOONiA V I 3 p t 2 ^m boo II I +�1 0 0 o Ii poop N + o n 0o0 11 W pW. f ��VII W ygqw D S N S II W A O! + yy O N N W I p W 1 mm q� • 6 a 0 O, O O O II N b N z° (n O 00 II 00 000 A Q 880 S o o S I I m W O N J ., i m N m 9 °q m A A S n o ��i +lo O- O N I" Yr d N N 9 2 00p0 io N S 11 N o pN W p0>� N + V ? C C o 0 11 A W pJyyJaapp AtD O N 6 3 D W O II N N O W is �am OQ II I 6 ... N O S V 11 W I N V W A tJ A # C 0 0 0 N H m M oq li -• O000 am N A A OOH� X3 II O IJ W A w D S II OObo W I°N tO j A m Qm NO �� + 0� O A I I�� pop II d O 8 I I A f) i A A l0 N O II N mom. OO pop 8ppS I V 8�0 11 tNil AOINN W 111 0 00 0 II N I d O O O 11 O O O O 0 OOO II + ON (WW�A A SNS II b W tVDA V W m 3' SA W WO� N+ N I m O N S I II I O A OI + fp W I 3 2 o 7 O O O I I I W � N NO O ONO I II A O OU�IpJp W N a^ a I II N N N O W I I O O O bob ii 0 II CJ � N II O I A W O� N A A W II N W V I+ W V+ 11 N I O W O N I OWO m OWl O I �jW Npp i O(p�p� N Cppp + II A i 0 f° O f0!' � W 0°iC W fNil 1 00 d 1 3 m ; O % JZ' A A 3 0 � G `! 3 I+ a a+ w 0 0 0 I� M m OMs A 00o ii 8 OSS I � ��OlI pNppp fJ> � +SS II N 01A Ni1OO O N W - O O O ONO II N I OWWO IVtO� N01 W W W W 6899 11 A N V W J + wm O SE D SNS 11 OtDD m (1OTN+ W N O N S I I O A W+ 10 W N ;2 °• x p I I I n c N 00o ii v'0 _ poop ON O II A (pUOp�1I W S �A�p �N S II N NOONiA V I 3 p t 2 ^m boo II I +�1 0 0 o Ii poop N + o n 0o0 11 W pW. f ��VII W ygqw D S N S II W A O! + yy O N N W I p W 1 mm q� • 6 a 0 O, O O O II N b N z° (n O 00 II 00 000 A Q 880 S o o S I I m W O N J ., i m N m 9 °q m A A S n o ��i +lo O- O N I" Yr d N N 9 2 00p0 io N S 11 N o pN W p0>� N + V ? C C o 0 11 A W pJyyJaapp AtD O N 6 3 D W O II N N O W is �am OQ II I 6 ... N O S V 11 W I N V W A tJ A # C 0 0 0 N H m M oq li -• O000 am N A A OOH� X3 II O IJ W A w D S II OObo W I°N tO j A m Qm NO �� + 0� O A I I�� pop II d O 8 I I A f) i A A l0 N O II N mom. OO pop 8ppS I V 8�0 11 tNil AOINN W 111 0 00 0 II N I d O O O 11 O O O O 0 OOO II + ON (WW�A A SNS II b W tVDA V W m 3' SA W WO� N+ N I m O N S I II I O A OI + fp W I 3 2 o 7 Page One 2014 BUDGET WORKSHEETS GENERAL FUND REVENUES September 3, 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 (1) Mobile Home Taxes (1) Gravel Taxes (1) Franchise Taxes - Regular Fees (1) Franchise Taxes - PEG Fees (1) Forfeited Tax Sale Apportionment (1) Federal Grants & Aids (1) Police Training Reimbursement (1) Post Board Training Reimb State Aid (Tied to PERA) MSA for Streets - Maintenance (1) Ag Preserves Credit (1) Other State Grants & Aids (1) Other County Grants & Aids (1) Police Services Levy -ISD #196 (1) Liaison Funding Total Intergovernmental (1) PAGE TOTALS 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 6 $7,480,265 From County 1,208,535 From County 8,688,800 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 ISO #196 580,800 9,707,900 6 Page Two 2014 BUDGET WORKSHEETS GENERAL FUND REVENUES September 3, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 101 34103.00 Zoning & Subdivision Fees (C) 33,310 31,865 29,854 32,000 32,000 101 34104.00 Plan Checking Fees (C) 89,313 71,774 105,669 75,000 90,000 101 34105.00 Sales of Maps & Publications (C) 364 377 215 500 300 Maps & Spec Books 101 34106.00 Deputy Registrar Fees (C) 0 0 0 0 0 Dakota County Took Over Feb. 2009 101 34108.00 Admin Fees - Other Funds (C) 95,000 101 34108.01 Applicable Funds Except Const. 25,000 25,000 25,000 25,000 25,000 101 34108.02 Construction Funds 10,027 36,093 97,462 0 70,000 85% of 5% Fee for Const. Projects 101 34109.00 Other Charges for Service (C) 6,286 3,981 4,939 4,000 4,500 101 34110.00 Service Chg on Returned Chks (C) 148 60 210 100 100 101 34112.00 Utility Permit Application Fee (C) 1,120 0 0 0 0 101 34113.00 Application Fees (C) 0 0 2,500 0 0 101 34150.00 User Fees - SKB (C) 112,314 74,655 124,362 120,000 155,000 SKB Fees - C & D Cell Fees 101 34151.00 User Fees /Host Agreements - SKB(C) 162,306 180,672 140,248 165,000 180,000 101 34151.00 Landscaping Agreement 25,000 Landscaping Agreement 101 34151.00 Trust Fund - City Portion 155,000 101 34152.00 User Fees - SKB (C) 16,885 10,850 15,879 20,000 20,000 SKB Fees - MSW Ash Charges 101 34153.00 User Fees - SKB (C) 135,229 167,857 145,029 120,000 170,000 SKB Fees - Base Service Charges 101 34160.00 National Guard Maint Fees (C) 48,456 45,084 49,854 46,000 46,000 101 34160.00 Shared Space Maint. Agreement 16,000 Snow Removal / Mowing 101 34160.00 Building Maintenance Contract 30,000 101 34201.00 Special Police Services (C) 15,160 25,322 12,570 19,000 19,000 Contractual O/r for Officers 101 34202.00 Fire Services - Burning Permits (C) 850 750 750 200 200 No Longer Charge for Permits 101 34203.00 Accident Reports (C) 25 43 2 0 0 '10134204.00 Day Care Inspection Fees (C) 500 150 150 200 200 101 34206.00 Other Police Services (C) 550 0 50 0 0 101 34207.00 Other Fire Protection Services (C) 21,043 20,209 41,146 18,000 101 34207.01 U of M Fire Contract 8,000 5,200 101 34207.02 Coates Fire Contract 10,000 10,700 101 34207.03 Other Billed Fire Calls 1,000 2,100 101 34303.00 Mow Weeds (C) 1,331 1,580 1,696 1,500 1,500 101 34304.00 Sweep /Plow Streets (C) 730 733 1,149 300 500 101 34306.00 Other Highway & Street Rev (C) 11,982 61,031 28,954 10,000 10,000 Street Light Bills - Developers 101 34310.00 Right -of -Way Permits (C) 4,715 3,146 10,905 3,400 4,000 101 34407.00 City Share of Metro SAC Chgs (C) 2,154 1,677 2,860 1,800 2,000 Total Charges for Services (C) 699,796 762,906 841,451 663,000 +~ 848,300 101 35101.00 Court Fines (F) 113,675 123,245 129,343 125,000 125,000 From County Total Fines & Forfeits (F) _ 113,675 123,245 129,343 125,000 125,000 101 34718.00 Tournament Fees (R) 0 0 11,685 7,000 9,000 New Fee for 2012 101 34719.00 Player Maintenance Fees (R) 0 1,894 0 0 0 New Fee for 2011 101 34720.00 Park Reservations (R) 3,984 3,605 3,526 4,000 4,000 101 34721.00 Softball Revenues (R) 66,288 59,135 50,946 58,000 52,000 101 34724.00 Tennis Revenues (R) 2,490 1,710 2,460 2,100 2,400 101 34725.00 Tiny Tot Revenues (R) 5,934 0 0 0 0 Eliminated Program in 2010 101 34726.00 Rosettes Revenues (R) 1,974 2,150 1,987 2,100 2,100 101 34727.00 Field Trip Revenues (R) 5,000 101 34727.01 Youth/Teen Trips 0 450 300 200 400 10134727.02 Adult/SeniorTrips 1,384 791 5,077 1,000 4,600 101 34728.00 Adult Soccer League Revenues (R) 14,866 13,319 12,527 13,000 13,000 101 34730.00 Run for the Gold Revenues (R) 4,527 4,956 4,410 4,600 4,600 101 34731.00 Youth Soccer Lessons (R) 4,011 3,782 2,814 3,700 3,000 101 34732.00 Adult Basketball Revenues (R) 2,147 1,400 1,774 1,400 1,400 101 34733.00 Other Programs Revenues (R) 20,298 21,064 20,032 20,000 20,000 101 34735.00 Camps Revenues (R) 19,571 20,000 21,256 19,000 19,000 101 34736.00 T -Ball Lessons (R) 5,887 4,330 5,250 4,500 4,500 101 38080.00 Banquet Room Fees (R) 55,435 60,124 46,427 60,000 60,000 101 38081.00 Auditorium Fees (R) 8,535 7,981 5,480 8,000 6,000 101 38082.00 Gymnasium Fees (R) 25,062 23,098 26,943 24,000 27,000 101 38086.00 Classroom Fees (R) 7,548 7,476 8,497 8,000 8,500 101 38096.00 Liquor Provider Fees (R) 540 630 795 800 800 101 38097.00 AN Rental Fees (R) 255 520 1,100 500 1,000 101 38154.00 Teen Night Revenues (R) 100 0 750 0 0 Eliminated Program in 2010 101 38201.00 Rental Revenues 6,575 19,750 17,830 18,000 8,000 Steeple Center Operations 101 38203.00 Rental Revenue - Churches 0 500 0 0 0 Steeple Center Operations 101 38205.00 AN Rental Revenues 0 428 25 500 500 Steeple Center Operations 101 38209.00 Miscellaneous Revenues 0 280 93 0 0 Steeple Center Operations 101 38211.00 Security Services 700 2,050 1,050 2,000 1,000 Steeple Center Operations 101 38301.00 Rental Revenues 0 0 0 750 750 Senior / Activity Center Operations 101 38305.00 AN Rental Revenues 0 0 0 50 50 Senior / Activity Center Operations Total Recreation Fees (R) 258,110 261,422 253,033 263,200 253,600 PAGE TOTALS _ 1,071,581 1,147,572 1,223,827 1,051,200 1,226,900 `b Page Three 2014 BUDGET WORKSHEETS GENERAL FUND REVENUES September 3, 2013 R 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 36101.00 Principal - Special Assessments (M) 9,450 9,244 8,369 1,000 1,000 From County - 101 Funded Projects 101 36102.00 Penalties & Interest - S/A (M) 113 0 2 0 0 From County 101 36210.00 Interest Earnings - Investments (M) 165,773 189,675 94,204 145,000 85,000 101 36214.00 Net Change in FV- Investments (M) (43,787) 5,947 2,588 0 0 Annual Market Value Changes 101 36215.00 Interest Earnings (M) 1,349 610 743 500 500 From Checking Account 101 36220.00 Rents & Royalties (M) 19,325 18,329 19,237 15,700 12,700 101 36220.01 Verizon Antenna Rent 12,700 101 36220.02 Athletic Complex Land Rental 0 New Fields Constructed in 2013 101 36220.03 MVTA -RCC Parking Lot Rental 0 Move to New Lot 101 36230.00 Contribution /Donations (M) 18,639 25,622 42,638 0 0 101 36260.00 Other Revenue (M) 98,882 2,785 6,369 2,000 2,000 101 36262.00 Special Settlements (M) 0 0 0 0 0 101 36265.00 Use of Reserve Funds (M) 0 0 0 0 20,000 Elections Balancing 101 38090.00 City Concessions (M) 4,903 5,295 4,538 5,000 4,500 Total Misc Revenues (M) 274,645 257,507 178,689 169,200 125,700 101 39202.00 Contribution from Enterprises (T) 3,500 3,500 3,500 3,500 3,500 Arena - Building & Grounds Maint. 101 39203.00 Transfer From (T) 0 61,422 0 0 0 Funds Returned from Projects Total Transfers In (T) 3,500 64,922 3,500 3,500 3,500 PAGE TOTALS $278,145 $322,429 $182,189 $172,700 $129,200 FUND TOTALS $10,838,551 $11,197,697 $10,903,894 $10,728,600 $11,064,000 INTERNAL REVENUES $2,628,847 $2,657,988 $2,678,610 $2,249,300 $2,375,200 Grand Total Less: Ad Valorem & Fiscal Disparities R Page Four 2014 BUDGET WORKSHEETS GENERAL FUND REVENUES September 3, 2013 Account# Description 101 34108.00 101 34108.01 101 34108.02 101 34108.03 101 34108.04 101 34108.05 101 34108.06 101 34108.07 101 34108.08 101 34108.09 General Fund Admin Fees Fund 201 Fund 202 Fund 203 Fund 206 Fund 207 Fund 605 Fund 606 Fund 607 Fund 650 Admin Fees Breakdown Totals Comments N 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 N CITY COUNCIL The City Council is responsible for establishing the mission and vision for the City of Rosemount. The Council also establishes community goals and supervises the activities of the City Administrator. POLICY DEVELOPMENT • Provides for the legislative and policy- making activities for all of municipal government. • Provides for the planning and control of all City expenditures through the adoption of the City's annual budget. • Provides for the definition of the City's tax structure through the levying of taxes and approval of user fees and rate structures. • Provides for citizen input to policy- making process by establishing, appointing and managing advisory commissions, ad hoc committees and community groups. GENERAL OPERATIONS • Provides funding for general government projects and needs such as: • City Newsletter • Chamber of Commerce Directory Page One 2014 BUDGET WORKSHEETS COUNCIL September 3, 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 41110 01 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 41110 01 319.01 Education Reimbursement 101 41110 01 319.02 Intergovernmental Initiatives 101 41110 01 321.00 Telephone Costs 101 41110 01 321.01 Mayor's Pager 101 41110 01 321.02 Mayor's Cell Phone 101 41110 01 329.00 Other Communication Costs 101 41110 01 331.00 Travel Expense 101 41110 01 331.01 NLC Conference 101 41110 01 331.02 Miscellaneous Travel 101 41110 01 433.00 Dues & Subscriptions 101 41110 01 433.01 LMC Dues 101 41110 01 433.02 AMM Dues 101 41110 01 433.03 Dak Cty Regional Chamber 101 41110 01 433.04 NLC Dues 101 41110 01 433.05 Miscellaneous Dues 101 41110 01 435.00 Books & Pamphlets 101 41110 01 437.00 Conferences & Seminars 101 41110 01 437.01 Registration & Hotel -LMC Conf 101 41110 01 437.02 Registration & Hotel -NLC Conf 101 41110 01 437.03 Miscellaneous Conferences 101 41110 01 439.00 Other Miscellaneous Charges 101 41110 01 598.00 Council Designated 101 4111001 598.01 Library Site Expenditures 101 41110 01 598.02 Sales Tax Exemption Savings 101 41110 01 598.03 Salary & Benefit Contingency 101 41110 01 599.00 Employee Recognition Costs 101 41110 01 599.01 Employee Recognition Costs 101 41110 01 599.02 Vending Machine Costs 101 41110 01 599.03 Commemorations 101 41110 01 599.04 Commission/Volunteer Recognition PAGE TOTALS DEPARTMENT TOTALS 2010 2011 2012 Actual Actual Actual 2013 2014 Object 2014 Adopted Detail Proposed Budget Amount Budget Comments $35,761 $36,148 $36,785 $36,800 25,000 25,026 25,000 24,799 25,000 Reduce From 5 to 3 Newsletters 20,237 18,300 14,475 18,300 15,000 2,138 1,069 1,069 1,100 1,100 0 0 0 0 0 0 3,058 1,501 5,000 6,067 15,243 4,196 12,000 12,000 903 0 769 5,000 5,000 0 0 0 0 0 378 375 389 400 400 252 0 0 500 150 0 740 5,250 1,200 5,200 1,009 1,453 1,564 1,500 1,600 - -- -- - - - - -- ---------------------------------------------- All Salary Costs Inclusive of $36,800 Salary, Taxes, PERA & Benefits 25,000 SKB Agreement, Arbor Day, etc. 16,100 6,951 7,263 Reduce From 5 to 3 Newsletters 2,500 Promotions, Marketing, etc. 17,000 30 400 800 500 Newspaper Ads / Open Houses 6,800 1,549 25,900 1,600 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 (90,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 --- ----- --------------- $162,600 $142,309 -- - - - - -- -------- $410,458 -- - - - - -- -- - - - - -- $176,072 -- - - - - -- -- - - - - -- $247,700 -- - - - - -- -- -- - - - - -- -- - - - - -- - - - - -- $162,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. 11 STAFFING ADMINISTRATION DEPARTMENT - Page 3 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) 2� 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) 2� Page One 2014 BUDGET WORKSHEETS ADMINISTRATION September 3, 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 41320 101.00 Salaries & Benefits $408,204 $426,536 $415,333 $410,600 $422,600 Salary, Taxes, PERA & Benefits 101 41320 102.00 Full -Time Overtime 0 0 0 300 0 101 41320 103.00 Part-Time Salaries & Benefits 2,056 0 8,599 700 0 Temp Receptionist Coverage 101 41320 01 209.00 Other Office Supplies 94 0 0 300 300 Miscellaneous Purchases 101 41320 01 313.00 Temporary Service Fees 0 0 0 0 0 101 4132001 319.00 Other Professional Services 0 0 0 0 0 101 41320 01 321.00 Telephone Costs 1,083 1,363 1,324 1,500 1,500 Administration Cell Phones 101 41320 01 331.00 Travel Expense 1,200 101 41320 01 331.01 NLC Conference 0 0 0 0 0 101 41320 01 331.02 ICMA Conference 422 274 288 600 700 101 41320 01 331.03 Miscellaneous Travel 325 448 289 500 500 101 41320 01 433.00 Dues & Subscriptions 2,500 101 41320 01 433.01 MCMA Dues 215 261 264 300 270 101 41320 01 433.02 MAMA Dues 45 0 0 50 0 101 41320 01 433.03 MCFOA Dues 35 35 0 50 50 101 41320 01 433.04 Munici -Pals 85 25 85 100 90 101 41320 01 433.05 IIMC Dues 0 0 0 0 200 City Clerk Association 101 41320 01 433.06 ICMA Dues 1,716 1,742 1,759 1,800 1,800 101 41320 01 433.07 APMP Dues 90 30 55 100 90 1014`1320 01 435.00 Books & Pamphlets 0 61 0 100 100 101 41320 01 437.00 Conferences & Seminars 7,300 101 41320 01 437.01 Registration & Hotel - LMC 500 709 295 800 500 101 41320 01 437.02 Registration & Hotel - MCMA 1,633 1,318 724 1,500 1,500 101 41320 01 437.04 Staff (1) Each 0 0 0 0 0 101 41320 01 437.05 Miscellaneous Seminars 240 (193) 0 300 300 ULI / Greening Initiatives 101 41320 01 437.06 Registration & Hotel - ICMA 2,306 2,059 2,998 2,500 3,000 101 41320 01 437.07 City Clerk Training 680 594 679 1,200 1,800 All MCFOA Events -IIMC 101 41320 01 437.08 Registration & Hotel - NLC 0 0 0 0 0 101 41320 01 437.09 Miscellaneous Meetings 6 209 187 200 200 101 41320 01 439.00 Other Miscellaneous Charges 0 0 200 100 200 101 41320 01 580.00 Other Equipment Purchases 841 214 73 500 200 PAGE TOTALS -- ---- --- - - - -- 420,574 ----- --- -- - - - -- 435,687 ----------- -- 433,150 - -- ----- --- --- 424,100 ---- --- - --- - -- --------------- 435,900 14 Page Two 2014 BUDGET WORKSHEETS ADMINISTRATION September 3, 2013 26 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 41320 31 305.01 Pre- Employment Physicals 597 1,704 525 600 600 101 41320 31 305,02 Employee Drug Testing 658 658 1,020 1,200 1,200 101 41320 31 305.03 PCORI Fees 0 0 0 0 0 101 41320 31 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 41320 31 315.02 Health & Wellness 51 38 50 500 500 Wellness & Health Management 101 41320 31 319.00 Other Professional Services 4,000 101 41320 31 319.01 Labor Consultant 694 0 1,318 300 500 101 41320 31 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 41320 31 341.00 Employment Advertising 1,727 972 1,100 1,000 1,000 Vacancies 101 41320 31 433.00 Dues & Subscriptions 600 101 41320 31 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 41320 31 437.03 Safety, Supervisor, Policy 0 0 0 0 0 101 41320 41 315.00 Special Programs 0 0 500 101 41320 41 315.01 General Marketing 0 0 200 1,000 500 101 41320 41 315.02 Historical Monuments 0 0 0 0 0 101 41320 41 319.00 Other Professional Services 1,043 3,600 101 41320 41 319.01 Website 0 1,100 275 3,600 3,600 101 41320 41 319.02 Website Improvements 0 10,000 0 0 0 101 41320 41 328.00 Cable Supply Costs 2 60 759 500 1,000 Cable Supplies, Software 101 41320 41 329.00 Other Communication Costs 0 0 0 46,100 101 41320 41 329.01 Cable JPA Payment - General City 41,998 42,902 54,717 44,300 46,000 101 41320 41 329.02 Video Streaming Council Mtgs 4,799 0 60 0 100 101 41320 41 329.03 Bulk E -Mail System 2,508 2,508 209 0 0 101 41320 41 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 -- - - - - -- -- - - - - -- 26 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 O�� Page One 2014 BUDGET WORKSHEETS ELECTIONS September 3, 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 41410 01 409.02 Maintenance for Accuvotes 101 41410 01 412.00 Building Rental 101 41410 01 439.00 Other Miscellaneous Charges 101 41410 01 580.00 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 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 -- - - - - -- -- - - - - -- z� 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. 0 FINANCE DEPARTMENT - Page 2 PAYROLL • 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. all 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) 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 �I Page One 2014 BUDGET WORKSHEETS FINANCE September 3, 2013 Account # Description 101 41520 101.00 Salaries & Benefits 101 41520 102.00 Full -Time Overtime 101 41520 103.00 Part-Time Salaries & Benefits 101 41520 01 321.00 Telephone Costs 101 41520 01 331.00 Travel Expense 101 41520 01 331.01 Finance Director 101 41520 01 331.02 Staff 101 41520 01 391.00 P.C. Maintenance 101 41520 01 391.01 Civic Systems Applications Support 101 41520 01 391.02 Citrix Maintenance Renewal 101 41520 01 391.03 Incode Software Maintenance 101 41520 01 391.04 General Network Support 101 4152001 391.06 Fixed Asset Maint Contract 101 41520 01 391.07 Miscellaneous Repairs & Maint. 101 41520 01 391.08 Anti -Virus Software Renewal 101 41520 01 391.09 File Server Software Maintenance 101 41520 01 392.00 P.C. Accessories & Supplies 101 4152001 393.00 P.C. Hardware Purchases 101 41520 01 394.00 P.C. Software Purchases 101 41520 01 394.01 Annual Microsoft Office Payment 101 41520 01 394.02 Miscellaneous S/W Purchases 101 41520 01 409.00 Other Contracted R & M 101 41520 01 433.00 Dues & Subscriptions 101 41520 01 433.02 MnGFOA - Finance Director 101 41520 01 433.03 MnGFOA - Staff 101 41520 01 433.04 GFOA - Finance Director & Asst. 101 41520 01 433.05 Magazine Subscriptions 101 41520 01 435.00 Books & Pamphlets 101 41520 01 435.01 Accounting Related Books 101 41520 01 435.02 Finance Related Books 101 41520 01 437.00 Conferences & Seminars 101 41520 01 437.02 MnGFOA Annual Conf (F /D & Ass't) 101 41520 01 437.03 GFOA National Conf (F /D) 101 41520 01 437.04 Staff Development 101 41520 01 437.05 Miscellaneous Seminars 101 41520 01 439.00 Other Miscellaneous Charges 101 41520 01 570.00 Office Equipment & Furnishings 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 $294,584 $303,823 $310,869 $318,800 $394,000 Salary, Taxes, PERA & Benefits 2,327 2,302 570 2,300 1,500 41,202 43,796 46,816 47,800 0 Propose Making P/T Position F/T 1,245 1,293 1,324 1,400 1,400 Cell Phone Allowances (2) 1,300 457 358 372 1,200 1,200 Miscellaneous (National Added) 0 0 99 100 100 48,600 5,428 5,482 0 0 0 Moved to Utilities 962 1,656 962 1,000 1,000 7,939 7,967 8,334 8,700 8,700 20,000 20,000 20,000 20,000 20,000 190 Hours of Support Time 1,384 1,384 1,384 1,400 1,400 902 1,793 2,335 2,500 2,500 4,866 3,023 3,063 5,000 3,000 7,160 7,801 8,049 8,000 12,000 3,383 3,565 3,174 4,000 4,000 City System Supplies 2,351 1,892 2,412 2,500 2,500 5,000 9,846 0 0 0 0 2015 End of Life for Office 2010 3,008 5,286 3,605 5,000 5,000 165 180 180 200 200 Non - Computer Equipment 800 60 60 60 70 70 360 360 360 380 380 340 340 340 350 350 0 0 0 0 0 100 0 0 27 50 50 0 0 0 50 50 3,300 565 571 571 1,000 1,000 0 0 0 1,500 1,500 Cut for 2011 & 2012 218 0 135 400 400 652 292 314 400 400 Misc. Meetings, Lunches, etc. 151 114 34 200 200 Contingencies 910 969 495 1,000 500 - -- ---- --- --- $410,465 ---- ----- ------ $414,308 - ---- -- - ---- $415,886 ---- --- -- - - - -- $435,300 ------ -- - --- -- --------------- $463,400 $410,465 $414,308 $415,886 $435,300 $463,400 3Z 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. 3� 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. Page One 2014 BUDGET WORKSHEETS GENERAL GOVERNMENT September 3, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 101 41810 01 202.00 Duplicating & Copying $14,000 101 41810 01 202.01 Records Retention 40 0 0 0 0 Moved to "391.00" Below 101 41810 01 202.02 Copying Costs 13,747 12,453 12,911 14,000 14,000 101 41810 01 203.00 Printed Forms & Paper 9,000 101 41810 01 203.01 Copy Paper 4,328 6,811 3,743 7,000 5,000 101 41810 01 203.02 General Receipt Books 0 800 573 800 800 101 41810 01 203.03 Purchase Orders 0 1,707 0 1,700 1,700 101 41810 01 203.04 Payroll & A/P Checks 394 326 1,578 500 500 101 41810 01 203.06 Miscellaneous Forms 180 735 277 1,000 1,000 Business Cards, etc. 101 41810 01 204.00 Envelopes & Letterheads 4,700 101 41810 01 204.01 Letterhead 784 1,223 967 1,200 1,200 101 41810 01 204.02 Plain Envelopes 1,587 0 557 1,800 1,800 101 41810 01 204.03 A/P & Payroll Envelopes 454 766 523 500 500 101 41810 01 204.04 10 x 13 Envelopes 0 1,202 0 1,200 1,200 101 41810 01 204.05 10 x 15 Envelopes 0 0 0 0 0 101 41810 01 209.00 Other Office Supplies 14,605 14,288 14,318 16,000 15,000 General Office Supplies 101 41810 01 221.00 Equipment Parts 0 0 0 0 0 City Hall Equipment Repairs 101 41810 01 242.00 Minor Equipment 300 101 41810 01 242.01 "Future Use" 0 0 0 0 0 101 41810 01 242.02 Credit Card Equipment 0 0 1,106 300 300 $500 -$700 for One Terminal 101 41810 01 301.00 Auditing & Accounting Services 70,000 101 41810 01 301.01 Audit & General Consulting Fees 56,045 59,383 56,932 64,000 62,000 101 41810 01 301.02 Dakota County Assessment Fees 4,389 5,456 5,614 6,000 6,000 101 41810 01 301,03 Dak Cty Truth In Taxation Costs 1,913 1,860 1,554 2,000 2,000 101 41810 01 303.00 Engineering Fees 8,163 5,402 11,738 0 0 101 41810 01 304.00 Legal Fees 55,007 60,931 51,637 80,000 60,000 General City Legal Fees 101 4181001 319.00 Other Professional Services 38,000 101 41810 01 319.01 City Code Update 1,495 2,568 4,024 2,500 2,700 101 41810 01 319.02 City Code Web Fees 0 0 250 300 300 101 4181001 319.03 State Building Report (Springsteds) 4,995 4,703 4,470 6,000 5,000 Fees Paid to Springsted 101 41810 01 319.04 Continuing Disclosure Fees 3,621 4,321 2,000 4,500 4,000 Fees Paid to Springsted (Bonds) 101 41810 01 319.05 Annual User Fee Study Update 5,370 5,710 4,780 7,000 6,000 Fees Paid to Springsted 101 41810 01 319.06 Arbitrage /Rebate Calculations 10,855 15,750 18,750 7,000 10,000 Fees Paid to Springsted (Bonds) 101 41810 01 319.10 Wore Professional Services 30,816 12,868 64,050 5,000 10,000 101 4181001 320.00 Credit Card Activity Fees 22,300 101 41810 01 320.01 Utilities' Fees 1,474 1,675 2,127 1,700 0 OIL Added - Moved to Utilities 101 41810 01 320.02 Parks & Recreation Fees 5,437 5,692 5,012 6,000 6,000 101 41810 01 320.03 Building Fees 12,095 16,319 12,824 15,000 15,000 101 41810 01 320.04 General Fees 814 1,258 1,093 1,300 1,300 101 41810 01 321.00 Telephone Costs 44,100 101 41810 01 321.01 General Phone Costs (& Internet) 42,188 43,928 41,133 39,000 34,000 Aded Fiber to Buildings in 2013 101 41810 01 321.02 Domain Housing 60 60 60 100 100 101 41810 01 321.03 Software Maintenance Costs 0 0 6,101 7,000 8,000 Added Additional Licenses 101 41810 01 321.04 Phone System Hardware 0 0 0 0 2,000 Phone Upgrades, Headsets, etc. 101 41810 01 322.00 Postage Costs 16,705 16,344 16,142 17,000 17,000 101 41810 01 339.00 Other Transportation Expenses 802 221 954 800 800 Vehicle Licensing 101 41810 01 351.00 Legal Notices Publishing 3,800 101 41810 01 351.01 Costs for Public Notices 2,475 2,564 3,467 3,000 3,000 All Departments 101 41810 01 351.02 Truth in Taxation Notices 0 0 0 300 300 Newspaper Notice Publication 101 41810 01 351.03 Budget & Audit Publications 123 457 648 500 500 State Mandated Publications 101 41810 01 391.00 P.C. Maintenance 9,476 9,745 9,962 15,500 16,800 Laserfishe Maintenance 101 41810 01 392.00 P.C. Software Purchases 11,414 0 0 4,900 15,300 Laserfishe Software 101 41810 01 393.00 P.C. Hardware Purchases 2,200 0 2,707 4,300 6,600 Scanner Purchase 101 41810 01 433.00 Dues & Subscriptions 867 956 943 1,000 1,000 Newspapers 101 41810 01 439.00 Other Miscellaneous Charges 250 270 510 500 500 Direct Deposit Filing Fees /Flex 101 41810 01 450.00 Sales Tax on Purchases 9,829 0 0 0 0 Sales Tax Audit 101 41810 01 580.00 Other Equipment Purchases 33,414 33,304 36,663 35,000 35,000 Office Machine Leases -All Bldgs. PAGE TOTALS $368,411 $352,051 $402,695 $383,200 $374,200 DEPARTMENT TOTALS $368,411 $352,051 $402,695 $383,200 $374,200 W; 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. 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. r 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. �J Page One 2014 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT September 3, 2013 Account # Description 101 41910 101.00 Salaries & Benefits 101 41910 101.00 Economic Development Coor 101 41910 102.00 Full -Time Overtime 101 41910 99 103.00 Part-Time Salaries & Benefits 101 41910 01 201.00 Office Accessories 101 41910 01 202.00 Duplicating & Copying 101 41910 01 203.00 Printed Forms & Paper 101 41910 01 205.00 Drafting Supplies 101 41910 01 208.00 Miscellaneous Supplies 101 41910 01 209.00 Other Office Supplies 101 41910 01 219.00 Other Operating Supplies 101 41910 01 241.00 Small Tools 101 4191001 302.00 Architects' Fees 101 41910 01 319.00 Other Professional Services 101 4191001 329.00 Other Communication Costs 101 41910 01 331.00 Travel Expense 101 41910 01 391.00 P.C. Maintenance 101 41910 01 392.00 P.C. Accessories & Supplies 101 41910 01 393.00 P.C. Hardware Purchases 101 41910 01 409.00 Other Contracted Repair & Maint. 101 41910 01 433.00 Dues & Subscriptions 101 41910 01 433.01 APA/AICP 101 41910 01 433.02 [CC 101 41910 01 433.03 AMBO 101 41910 01 433.04 10,000 Lakes 101 41910 01 433.05 "Future Use" 101 41910 01 433.06 Trade Magazines 101 41910 01 433.07 Planner's Journal 101 41910 01 433.08 Sensible Land Use Coalition 101 41910 01 433.09 AACEO /MAHCO 101 41910 01 433.10 Other Dues & Subscriptions 101 41910 01 435.00 Books & Pamphlets 101 41910 01 437.00 Conferences & Seminars 101 41910 01 437.01 State Bldg Official School 101 41910 01 437.02 Spring & Fall Code Updates 101 41910 01 437.03 Building Inspector Training 101 41910 01 437.04 Computer Training 101 41910 01 437.05 Clerical Seminars 101 41910 01 437.06 Planning Seminars 101 41910 01 437.07 ISTS Training 101 41910 01 437.08 State Planning Conference (2) 101 41910 01 437.09 Planning Commissioner Training 101 41910 01 437.10 Gent Seminars 101 41910 01 437.11 Code Enforcement Training 101 41910 01 439.00 Other Miscellaneous Charges PAGE TOTALS DEPARTMENT TOTALS $890,419 $846,393 $857,950 $896,800 $926,100 $890,419 $846,393 $857,950 $896,800 $926,100 it"" 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $870,501 $827,265 $840,012 $864,700 $892,700 Salary, Taxes, PERA & Benefits 0 0 0 0 0 Proposed New Position 1,695 1,020 407 1,000 1,000 1,485 2,932 2,957 4,500 4,500 Planning Commission Members 0 0 0 0 0 Calendars, Planners, etc. 1,990 2,234 1,788 2,500 2,500 2,640 765 0 1,500 1,000 Forms, Stickers, Tags, etc. 0 0 0 0 0 89 106 19 0 0 438 232 71 600 600 Dictation Devices & Tapes 1,397 1,110 242 1,500 1,500 191 30 230 200 200 Inspectors' Tools 0 0 0 0 0 5 0 0 1,000 1,000 Consultant 2,078 1,871 2,036 2,500 2,500 Cell Phones & Pagers 273 350 290 600 600 2,124 2,190 3,031 4,200 4,200 Permitworks Support 0 0 223 300 300 0 0 0 0 0 0 0 0 0 1,500 Mow Weeds -From Street Maint. 3,300 1,360 1,390 1,425 1,500 1,500 200 100 225 200 200 50 300 200 300 300 0 150 115 150 150 0 0 0 0 0 85 85 0 200 200 0 0 0 0 0 0 0 0 300 300 35 0 90 100 100 588 269 307 550 550 452 549 467 700 700 Manuals, References, IBC Books 7,600 421 365 400 550 550 255 400 400 400 400 1,040 669 756 1,000 1,000 0 0 0 200 200 0 0 60 300 300 268 328 320 2,000 2,000 426 150 500 500 500 0 1,258 589 1,400 1,400 48 82 435 200 500 40 150 354 300 300 146 44 0 450 450 100 0 0 400 400 Contingencies $890,419 $846,393 $857,950 $896,800 $926,100 $890,419 $846,393 $857,950 $896,800 $926,100 it"" 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 (NIAAG) 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. q4 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. 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. pal 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 2012 .99 2012 .20 2012 46 2007 2008 2009 2010 2011 2012 Total # 428 398 411 334 336 270 Reported Rate per 2196 1860 1872 1513 1469 1180 100,000 Part II 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 2012 659 2881 2012 57% 2007 2008 2009 2010 2011 2012 Number 251 236 141 101 106 119 of Arrests Rate per 1291 1291 642 457 463 520 100,000 4� 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 u� Page One 2014 BUDGET WORKSHEETS POLICE September 3, 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/T 101 42110 103.00 Part-Time Salaries & Benefits 101 42110 22 103.00 Part-Time Receptionist (2) 101 42110 23 103.00 Part-Time Secretary 101 42110 9S 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,633,100 Salary, Taxes, PERA & Benefits 66,069 75,223 67,587 70,000 72,500 Propose New Sergeant 7 /1/14 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 P/T 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 Lie, 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 ~� 3,247,200 NO Page Two 2014 BUDGET WORKSHEETS POLICE September 3, 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 01 396.01 Records Management 101 42110 01 396.02 CJDN Connection Charges 101421 '10 01 396.03 MCD Connection Charges 101 42110 01 396.04 MCD Maintenance & Cellular 101 42110 01 396.05 LOGIS Annual Fees 101 42110 01 433.00 Dues & Subscriptions 101 42110 01 433.01 Mufti- Agency Assistance Group -MAAG 101 42110 01 433.02 IACP Chiefs 101 42110 01 433.03 MN Chiefs of Police 101 42110 01 433.04 Dakota Cty Chiefs of Police 101 42110 01 433.05 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 01433.10 P.O.S.T. Licenses 101 42110 01 433.11 FBI Nat] Academy Association 101 42110 01 433.12 Miscellaneous 101 42110 01435.00 Books & Pamphlets 101 42110 01 436.00 Towing Charges 101 42110 01437.00 Conferences & Seminars 101 42110 01 437.01 Firearms - Range 101 42110 01 437.02 Chiefs Spring Conference 101 42110 01 437.03 Investigations 101 42110 01437.04 IACP Conference 101 42110 01 437.05 Supervision 101 42110 01437.06 Use of Force 101 42110 01 437.07 Emergency Driving 101 42110 01 437.08 First Aid 101 42110 01 437.09 Narcotic Enforcement 101 42110 01437.10 Tactical 101 42110 01 437.11 Support Services 101 42110 01 437.12 Patrol Ops. 101 42110 01 437.13 Emergency Management 101 42110 01439.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 CJIINlProPhoenix 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 W, $98,900 $3,006,075 --- - - - --- --------- $3,054,877 --- -- - - -- --- -- - - -- $3,084,331 --- - - - - -- - -- - - - - -- $3,187,800 --- - - - - -- --- --- - - - - -- --- - - - - -- - - - - -- $3,346,100 --- - - - --- --- - - - --- q-1 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. 4a 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. u 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. n/a — Information Not Available 51 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 51 Page One 2014 BUDGET WORKSHEETS FIRE September 3, 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 42210 01 202.02 Computer Printers 101 42210 01 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 4221001 218.00 Fire Department Clothing 101 42210 01 218.01 Uniforms 101 42210 01 218.02 Station Wear (2015) 101 42210 01 219.00 Other Operating Supplies 101 42210 01 219.01 Gloves 101 42210 01 219.02 Bandages 101 42210 01 219.03 Equipment 101 42210 01 219.04 Tyvek Suits 101 42210 01 219.05 Consummable Medical 101 42210 01 219.06 Oxygen 101 42210 01 229.00 Other Maintenance Supplies 101 42210 01 229.01 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 4221001 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 4221001 241.01 Axes, Bars & Other 101 42210 01 241.02 Grass Fire 101 42210 01 241.03 Hand Tools 101 42210 01 305.00 Medical & Dental Fees 101 42210 0`1306.00 Personnel Testing & Recruitment 101 42210 01 306.01 New Physicals (4) 101 42210 01 306.02 Hepatitis Shots (4) 101 42210 01 306.03 Background Checks (4) 101 42210 01 306.04 Drug Testing (4) 101 4221001 308.00 Instructors' Fees 101 4221001 308.01 Fire Fighter 1 (4) 101 4221001 308.02 Fire Fighter 1 Certificates (4) 101 42210 01 308.03 Fire Fighter Re- Certificates (14) 101 42210 01 308.04 First Responder (4) 101 4221001 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 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 0 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 Him Page Two 2014 BUDGET WORKSHEETS FIRE September 3, 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 42210 01 310.04 SCBA Hydro Testing (Next 2016) 0 0 0 0 0 101 42210 013`13.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 42210 01 313.05 SOT Joint Powers 2,605 2,605 3,496 5,800 5,800 101 42210 01 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 42210 01 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 42210 01 319.05 Summer Park Education 313 0 309 0 0 101 42210 01 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 42210 01 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 101422`10 01 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 42210 01 329.04 Mobile Repairs 0 0 0 200 200 101 42210 01 329.05 800 MHZ User Fee 10,356 10,604 9,769 14,000 14,000 101 42210 01 329.06 Mobile Computers 0 0 371 1,200 1,200 Monthly Air Time Fees 101 42210 01 331.00 Travel Expense 3,900 101 4221001 331.01 Minnesota Chiefs Conference 1,621 854 2,500 2,000 2,000 101 42210 01 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 42210 01 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 01 433.02 VFBA Insurance 328 305 361 350 350 101 42210 01 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 42210 01 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 42210 01 437.01 State Fire Conference 0 0 0 400 400 101 42210 01 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 42210 01 439.02 Extinguisher 0 559 692 550 550 101 42210 01 439.03 Plaques 13 221 51 50 50 101 42210 01 439.04 Paint 0 360 0 100 100 101 42210 01 439.05 Station Needs 1,346 5,419 880 1,000 1,000 101 42210 01 580.00 Other Equipment Purchases 23,600 101 42210 01 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 42210 01 580.03 Hose & Fittings 0 1,719 2,901 1,000 1,000 101 42210 01 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 42210 01 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 -- - -- - -- -- - - - - -- 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. 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 resurfaces) • Administration / Community Development (2 cars, 2 trucks, 1 van) • Utility Department (1 Jetter, 1 Vactor, 2 trucks) • Streets and Parks Maintenance (2 sweepers, 3 tractors, 2 loaders, 2 skidsters, 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. 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(eso 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 est 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 S/ Page One 2014 BUDGET WORKSHEETS GOVERNMENT BUILDINGS September 3, 2013 Account # Description 101 41940 101.00 Salaries & Benefits 101 41940 79 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 41940 01 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 41940 01 319.02 Heating /Cooling Maint Contract 101 41940 01 319.03 Annual Boiler Inspections / Maint. 101 4194001 319.04 Pest Control 101 41940 01 319.05 Fire Extinguishers 101 41940 01 319.06 Fire Suppression System Check 101 4194001 319.07 Janitorial Service-Fire Stations 101 41940 01 319.08 Janitorial Service-P.W. Building 101 41940 01 319.09 Janitorial Service-City Hall 101 41940 01 319.10 Floor Mats - Monthly Charges 101 4194001 319.11 Other Janitorial Services 101 41940 01 319.12 Annual Monument Maintenance 101 41940 01 321.00 Telephone Costs 101 41940 01 381.00 Electric Utilities 101 41940 01 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 393.00 P.C. Hardware Purchases 101 4194001 401.00 Contracted Building Repairs 101 41940 01 401.01 Electrical Repairs 101 41940 01 401.02 Siren Replacement Program 101 41940 01 401.03 Miscellaneous Repairs 101 41940 01 401.04 Roof Inspections 101 41940 01 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 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 Firs, 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 10- YrAverage Expenditures 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 -- - - -- -- -- - - -- -- �_T Page One 2014 BUDGET WORKSHEETS FLEET MAINTENANCE September 3, 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 43100 01 212.00 Motor Fuels 101 43100 01 213.00 Lubricants & Additives 101 43100 01 215.00 Shop Materials 101 43100 01 221.00 Equipment Parts 101 43100 01 222.00 Tires 101 43100 01 241.00 Small Tools 101 43100 01 242.00 Minor Equipment 101 4310001 318.00 Contract Engineer 101 43100 01 321.00 Telephone Costs 101 43100 01 323.00 Radio Units - Warranty 101 43100 01 384.00 Refuse Disposal 101 43100 01 394.00 P.C. Software Purchases 101 43100 01 394.01 Licensing & Maintenance 101 43100 01 394.02 Online Subscriptions 101 43100 01 394.03 New Software Purchases 101 43100 01 404.00 Contracted Mach & Equip Repairs 101 43100 01 404.01 Contracted Repairs 101 43100 01 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 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 16 3, 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 145,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 -- - - - - -- -- - - - - -- 1) Page One q1 2014 BUDGET WORKSHEETS STREET MAINTENANCE September 3, 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 43121 78 101.00 TechnicallClerical 63,978 47,215 49,966 52,400 53,600 101 43121 7S 101.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 99 103.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 01 203.00 Printed Forms & Paper 200 101 43121 01 203.01 R/W Permit & Inspection Forms 0 0 0 200 200 101 43121 01 203.03 City Specification Books 0 0 0 0 0 101 43121 01205.00 Drafting Supplies 900 101 43121 01 205.01 Plotter Ink and Paper 136 752 114 500 500 Split with 101- 45292 -01- 205.00 101 43121 01205.02 Off-Site Reproductions 53 0 147 400 400 101 43121 01209.00 Other Office Supplies 1,231 0 70 500 500 101 43121 01216.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 01224.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 01 225.00 Landscaping Materials 16,900 101 43121 01225.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 01 225.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 01 231.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 01 235.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 01 242.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 City(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 01 324.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 300 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 q1 Page Two 2014 BUDGET WORKSHEETS STREET MAINTENANCE September 3, 2013 Account # Description 101 43121 01 402.00 Parking Lot Maintenance 101 43121 01 403.00 Contracted Repair & Maintenance 101 43121 01403.01 Street Lights 101 43121 01 403.02 Signal Lights 101 43121 01403.03 Light Replacements 101 43121 01404.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 01 410.00 Concrete Sidewalk/Curb Repairs 101 43121 01410.01 General Repairs 101 43121 01 410.02 Pedestrian Improvements 101 43121 01411.00 Contracted Snow Removal 101 43121 01 411.01 Community Center 101 43121 01411.02 Steeple Center 101 43121 01411.04 Dakota County Library 101 43121 01415.00 Equipment Rental 101 43121 01433.00 Dues & Subscriptions 101 43121 01433.01 American Public Works Ass'n 101 43121 01433.03 City Engineers' Association 101 43121 01 433.07 MN Street Superintendent Assn 101 43121 01435.00 Books & Pamphlets 101 43121 01435.02 "Future Use" 101 43121 01437.00 Conferences & Seminars 1014312101437.01 APWA 101 43121 01 437.03 Clerical 101 43121 01437.05 Maintenance Expo 101 43121 01437.06 Cartegraph, ESRI, GIS 101 43121 01 437.07 Snow Conference 101 43121 01 437.08 MN Dot 101 43121 01 437.09 Miscellaneous Training 101 43121 01 439.00 Other Miscellaneous Charges 101 43121 01 570.00 Office Equipment & Furnishings PAGE TOTALS DEPARTMENT TOTALS 2013 2014 Objed 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 13,577 0 25,000 25,000 65,000 Next 10 -Yr Average Expenditures 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 --- - - - - -- - -- - - - - -- --- - - -- -- --- - --- -- -- - -- - -- -- - -- -- -- --------- --- -- - - -- --- - - - - -- --- - - -- -- -- - -- - -- --- - - - --- Page One 2014 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE September 3, 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 45202 01 216.01 Herbicides(General Park Use) 101 45202 01 216.02 Fertilizer 101 45202 01 219.00 Other Operating Supplies 101 45202 01 219.01 Seed, Sod, etc. 101 45202 01 219.02 Red Rock, Sand, Gravel, etc. 101 45202 01 219.03 Repair Supplies 101 45202 01 219.04 Bituminous 101 45202 01 219.05 Wood Chips 101 45202 01 221.00 Equipment Parts 101 45202 01 221.01 Playground Equipment Repair 101 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 45202 01 225.01 Trees, Shrubs, Sod, etc. 101 45202 01 225.02 Timbers, Fence, etc. 101 45202 01 226.00 Sign Repair Materials 101 45202 01 229.00 Other Maintenance Supplies 101 45202 01 241.00 Small Tools 101 45202 01 242.00 Minor Equipment 101 45202 01 303.00 Engineering Fees 101 45202 01 305.00 Medical and Dental Fees 101 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 45202 01 321.00 Telephone Costs 101 45202 01 323.00 Radio Units 101 4520201 341.00 Employment Advertising 101 45202 01 381.00 Electric Utilities 101 45202 01 381.01 Skating Rinks 101 45202 01 381.02 Softball Fields 101 4520201 381.03 Irrigation 101 4520201 383.00 Gas Utilities 101 45202 01 393.00 P.C. Hardware Purchases 101 45202 01 394.00 P.C. Software Purchases 101 45202 01 394.01 Licensing & Maintenance 101 45202 01 394.02 Online Subscriptions 101 45202 01 394.03 New Software Purchases PAGE TOTALS 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,500 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 Page Two 2014 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE September 3, 2013 Account # Description 101 45202 01 403.00 Contracted Repair & Maintenance 101 45202 01 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 0`1409.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 45202 01 433.00 Dues & Subscriptions 101 45202 01 433.01 MN Park Supervisors Assn 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 M, 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 10- YrAverage Expenditures $90,442 $132,187 $132,682 $152,800 $219,200 $684,742 -- - - - - -- -------- $738,485 -- - - - - -- -- - - - - -- $688,834 -- - - - --- -- - - - - -- $739,100 -- -- - - -- -- -- - - -- -- - - - - -- -- - -- - -- $831,600 - - - - - - -- - - - -- - -- M, 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. 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 Page One 2014 BUDGET WORKSHEETS PARKS & RECREATION September 3, 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 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 1/2 Time 7 11/14 101 4510083 103.00 Playground Recreation Leaders 24,955 18,501 25,631 20,000 24,000 1014510094 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 1014510001 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 45100 01 208.00 Miscellaneous Supplies 94 60 43 0 0 101 4510001 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 45100 01 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 45100 01 221.00 Equipment Parts 10,556 6,050 8,688 8,000 8,000 101 4510001 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 45100 01 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 45100 01 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 45100 01 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 45100 01 341.00 Employment Advertising 333 100 0 0 0 101 45100 01 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 45100 01 349.03 Special Marketing 3,835 3,835 3,528 3,900 3,900 Garage Sale Ad 101 45100 01 381.00 Electric Utilities 27,331 30,295 30,969 29,000 30,000 101 45100 01 383.00 Gas Utilities 23,885 26,328 22,141 28,000 25,000 101 45100 01 384.00 Refuse Disposal 3,737 3,699 3,517 4,000 4,000 101 45100 01 392.00 P.C. Accessories & Supplies 0 0 0 0 0 101 45100 01 393.00 P.C. Hardware Purchases 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 45100 01 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 45100 01 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 45100 01 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 45100 01 433.02 Miscellaneous 1,761 1,927 2,008 400 400 Paper, Magazines, etc. 101 45100 01 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 45100 01 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 45100 01 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 (fi Page Two 2014 BUDGET WORKSHEETS PARKS & RECREATION - STEEPLE CENTER ** September 3, 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 0 700 TOTAL REVENUES 101 45100 30 103.00 Salaries & Benefits 101 45100 30 103.00 Building Attendants 101 45100 30 211.00 Cleaning Supplies 101 45100 30 219.00 Other Operating Supplies 101 45100 30 221.00 Equipment Parts 101 45100 30 223.00 Building Repair Supplies 101 45100 30 241.00 Small Tools 101 45100 30 242.00 Minor Equipment 101 45100 30 312.00 Custodial Services 101 45100 30 321.00 Telephone Costs 101 45100 30 349.00 Other Advertising 101 45100 30 365.00 Workers' Comp Insurance 101 45100 30 369.00 Other Insurance 101 45100 30 381.00 Electric Utilities 101 45100 30 383.00 Gas Utilities 101 45100 30 384.00 Refuse Disposal 101 45100 30 401.00 Contracted Building Repairs 101 45100 30 404.00 Contracted Mach & Equip Repairs 101 45100 30 409.00 Other Contracted Repairs & Main 101 45100 30 415.00 Other Equipment Rental 101 45100 30 439.00 Other Miscellaneous Charges 101 45100 30 521.00 Building & Structure Purchases PAGE/EXPENDITURE TOTALS - SENIOR CENTER " Account # Description 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $6,575 $19,750 $17,830 $18,000 0 500 0 0 0 428 25 500 0 280 93 0 700 2,050 1,050 2,000 $7,275 $23,008 $18,998 $20,500 2.324 15,425 14,435 15,000 1,654 4,207 2,247 3,000 4,539 1,538 1,205 1,500 2,089 990 145 1,500 3,998 4,251 3,233 5,000 74 0 0 500 1,304 1,273 1,339 1,000 0 0 1,480 0 276 1,751 2,069 1,800 1,220 325 0 1,500 0 0 0 500 0 0 0 2,000 5,590 5,669 4,863 5,500 10,632 9,905 7,023 9,000 323 1,142 1,149 1,000 13,855 11,523 8,493 11,000 6,423 3,553 6,793 4,200 0 0 0 0 910 789 718 500 0 0 0 0 1,604 0 0 0 $56,815 $62,340 $55,193 $64,500 $8,000 0 Rental Revenues 500 $0 0 $750 1,000 $9,500 A/V Rental Revenues $15,000 Salary, Taxes, PERA & Benefits 15,000 Event Staff 3,000 1,500 Events Supplies 1,000 0 4,500 0 500 1,000 TOTALREVENUES 800 $0 2,000 $800 500 103.00 500 Salaries & Benefits 0 Pay from Insurance Fund 4,500 7,000 103.00 1,200 Building Attendants 11,000 0 4,200 7,800 2,500 Holiday Lights 500 Cleaning Supplies 0 0 0 300 $61,200 219.00 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 TOTALREVENUES $0 $0 $0 $800 101 45100 31 103.00 Salaries & Benefits 101 45100 31 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 45100 31 221.00 Equipment Parts 0 0 0 400 101 45100 31 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 1014510031 349.00 Other Advertising 0 0 0 100 101 45100 31 365.00 Workers' Comp Insurance 0 0 0 200 101 45100 31 369.00 Other Insurance 0 0 0 500 101 4510031 381.00 Electric Utilities 0 0 0 1,500 101 45100 31 383.00 Gas Utilities 0 0 0 500 101 45100 31 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 45100 31 415.00 Other Equipment Rental 0 0 0 100 101 45100 31 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 Page Three �1 2014 BUDGET WORKSHEETS PARKS & RECREATION September 3, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments $111,500 101 45100 80 Art Classes $0 $0 $0 $1,000 $1,000 101 45100 81 Softball 51,127 44,877 44,160 45,000 45,000 101 45100 82 Volleyball 0 0 0 0 0 1014510084 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 1014510086 Rosettes 1,595 1,747 1,646 1,700 1,700 1014510087 Trips 1,700 916 4,677 1,000 4,600 101 45100 88 Broomball 0 0 0 0 0 101 45100 90 Run for the Gold 4,358 4,693 4,615 4,500 4,500 1014510091 Camps 19,254 21,289 14,583 21,000 15,000 101 45100 92 Adult Basketball 0 0 0 600 600 101 45100 93 Other Programs 17,843 17,658 17,055 17,000 17,000 101 45100 95 T -Ball 5,410 4,960 4,894 5,000 5,000 101 45100 96 Teen Night 480 0 786 0 0 Eliminated Program in 2010 101 45100 97 Adult Soccer League 13,702 12,137 11,205 12,000 12,000 No League in 2009 101 45100 98 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 45100 81 219.00 Operating Supplies 12,208 9,041 10,318 9,000 9,000 101 45100 81 311.00 Officiating Fees 26,509 24,574 23,853 25,000 25,000 101 45100 81 319.00 Other Professional Services 5,213 5,113 2,609 5,000 5,000 101 45100 82 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 82 219.00 Operating Supplies 0 0 0 0 0 101 45100 82 311.00 Officiating Fees 0 0 0 0 0 101 45100 82 319.00 Other Professional Services 0 0 0 0 0 101 45100 84 103.00 Part-Time Salaries 1,175 1,065 1,767 1,100 1,100 101 45100 84 219.00 Operating Supplies 41 0 0 500 500 101 45100 85 103.00 Part-Time Salaries 8,799 377 0 0 0 101 45100 85 219.00 Operating Supplies 385 0 0 0 0 101 45100 86 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 45100 87 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 87 219.00 Operating Supplies 4,600 101 45100 87 219.01 Youth/Teen Trips Supplies 0 407 274 500 500 101 45100 87 219.02 Adult/Senior Trips Supplies 1,700 509 4,403 500 4,100 101 45100 88 219.00 Operating Supplies 0 0 0 0 0 101 45100 88 311.00 Officiating Fees 0 0 0 0 0 101 45100 90 219.00 Operating Supplies 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 45100 92 219.00 Operating Supplies 0 0 0 600 600 101 45100 93 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 45100 95 103.00 Part-Time Salaries 3,885 3,514 3,289 3,500 3,500 1014510095 219.00 Operating Supplies 1,525 1,445 1,605 1,500 1,500 101 45100 96 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 96 219.00 Operating Supplies 480 0 786 0 0 101 45100 97 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 97 219.00 Operating Supplies 1,702 1,637 1,545 1,500 1,500 101 45100 97 311.00 Officiating Fees 12,000 10,500 9,660 10,500 10,500 101 45100 98 103.00 Part-Time Salaries 1,699 2,377 1,695 2,300 2,300 101 45100 98 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 �1 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. IN Page One 2014 BUDGET WORKSHEETS OTHER FINANCING USES September 3, 2013 Comments Excess F/B 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 F/B Transfers I 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. H X a l�lz z �3 � R m m aym to 2'2'c 2'cR a nm �loe�mm m �Tn T �G N� GnT O_ma a° N R m ;Oz- �• Cam') m a f. 3�Sr a;aH 0 �38 m9m 3Q0 1 m RM '33 38 R os^ z�3.m3m ��o my m�3 U' $ 3mm 3 a' �mm mLi1 3 H °a gmo�I F_.>> m N m 2 N O� to � n R� < 3 R cmo<mm�m3 -. c�mm 3R �mm oumlmy3'm^m a a m N m j C O IN J y y d 0 c S3� m 3 3 p � C m 3 3 3 m m m m m m o N � N p m m m O H a m y N � � O m m 0 O + m � O +m � p n�T a 'm 3 3 m ' J 3 n a m ° o n mO T a c m 9 s m d ' 3 m m dwy q C C C N m H 8 O y N m C N W m < N C C N y N m 0 m n T T m C 3 m m O A N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N N 0 0 N 0 m A a A A A a A A A A A a A A A A A A A A A A A A A L A A a A A A A A A W W W W W W N N N N N N N N N N ++ + ++ 1p pp V N N A W N+ �NO� +Am = �xQ m m-a .C^o0 3 F T . m m fcn n mA. Am.oWm 2 . 30 4an mo n m m .m3�S mN AmO TT A m . i 0 2 p 7 ma _ o a m T ( ' �o 3 - 1 0 0Tna R RAm m o . m n .= 0 O m " 3O m N =r a y g < 8 o2 A A y co x ym# mox 'nl smm f �O o 3p 3;m 3 3 � 3 °�N mOm c 50 Z m _u 0 O v 3°333 a m c y qq XZ 31 ' m w ';A n o. Cc ymro 3 2a AmmA�wa m m 3 c m 'y o m 0 dNC)m'u�m m3 m y R N ym mmmm j .D3 � BOA m°�3m3a .0otn ^� wOV cramp 3 3, iac o N� 3 3 we �' 2"m + m m ^_y 5 N + 3 m co o "' �o (� nc Am N O m N N T n m 3 3 P- m N C N a y.mo W O N y of j l�D m N ^, = Q. wis °o opp j m+ o mT o m `m' X N O^ 1D A N m m 40 T n F � m m x 3 r T T I c T T c c ca T T c c au T T c c o'o'o T -01-0 c c -cam T c o T T o o - ' -' T T o o ° -'� T T o m T T m m Mu m m T T m m 0 Q m m T 21212111 1°'D d 5 T n �. waawwaaoo a"2-�T �?�Z-;,L =? m m > m'm > >R=2: 0 0 0 0 0 0 0 � � 0 0 0 A p Ji' N JZ' O 5000 O A m N tp0 w A 0 A O W N NNN m'ON+NA N tVI�N O NO N +Z; N O 0 0 0 0 0 0 0 0 O 0 O N 0 0 O O 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 T 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 n m 0 0 m 0 0 e o O O O C o N u N O N O a k o � ' s , NV N O N S N O O S O S { 'S,-, � .. r. yi y 'N _lai N v N N O c m � o kz 3 91 O to O O O O O O S 0 O O o 0 o 0 0 O O O O O O O 0 0 O O O O O O 0 o 0 O O o 0 O A to N W N + O O N O O O V t0 N N N a V O N� N A O O N O O NOON N N O N O O1 O N O O O 8 p O O O O O O O S S O O O O O S O O O O O O O O O O O O O S O O O O O 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. 11- Page One 2014 BUDGET WORKSHEETS INSURANCE - REVENUES September 3, 2013 Account # Description 206 31010.00 Current Ad Valorem Taxes 206 33100.00 Federal Grants & Aids 206 36210.00 Interest Eamings- Investments 206 36214.00 Net Change in FV- Investments 206 36215.00 Interest Eamings 206 36260.00 Other Revenue 206 36265.00 Use of Reserve Funds 0 0 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 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. 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 -- - - - - -- -- - - - - -- -- - - - - -- -- - - -- -- 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. 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $2,621 $10,834 $1,955 $8,000 $5,000 Liability & Auto Deductible Pymts 500 500 4,230 500 500 Unreimbursable Legal Fees 11,850 9,742 3,597 12,000 6,000 Work Comp Deductible Pymts 2,500 2,500 2,500 2,500 2,500 Yearly Fee Per Policy F -3 18,300 Risk Management Consultant 10,500 6,000 6,000 6,000 6,000 12,300 12,300 12,300 12,300 12,300 105,374 106,210 103,113 110,000 110,000 Annual Premium 163,362 80,309 89,713 85,000 95,000 Annual Premium - General Liability (Changed to High Deductible) 33,016 0 0 0 0 Liability & Auto Deductible Pymts 8,651 57,602 49,577 55,000 55,000 Liability & Auto Deductible Pymts 1,000 0 0 0 0 (Changed to High Deductible) 351,675 -- - - - - -- -------- 285,997 -- - - - - -- -- - - - - -- 272,986 -- - - - - -- -- - - - - -- 291,300 -- - - - - -- -- - - - - -- -- - - - - -- -- - - - - -- 292,300 -- - - - - -- -- - - - - -- 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. PORT AUTHORITY GENERAL / ADMINISTRATIVE • The Rosemount Port Authority is the successor to the Rosemount Housing and Redevelopment Authority (HRA) and the Rosemount Economic Development Authority (EDA). As such, the Port Authority is responsible for both redevelopment and economic development activities in the City. • The Port Authority concentrates much of its activity on the development of the Rosemount Business Park and on the redevelopment of downtown Rosemount. • The Port Authority will continue to work on other development and redevelopment projects related to commercial and industrial development. Page One 2014 BUDGET WORKSHEETS PORT AUTHORITY - REVENUES May 21, 2013 Account # Description 201 31010.00 Current Ad Valorem Taxes 201 31050.00 Tax Increments 201 33130.00 Federal Grants -CDBG 201 33425.00 Other State Grants & Aids 201 34109.00 Other Charges for Services 201 36210.00 Interest Earnings - Investments 201 36215.00 Interest Earnings 20136230.00 $58,000 Contributions /Donations 201 36260.00 Other Revenue 201 36265.00 Use of Reserve Funds 201 39101.00 Sales of General Fixed Assets 0 0 FUND TOTALS EXPENDITURES Account # Description 201 46300 99 103.00 Part-Time Salaries & Benefits 201 46300 01 303.00 Engineering Fees 201 46300 01 304.00 Legal Fees 201 46300 01 317.00 General Fund Administrative Fees 201 46300 01 319.00 Other Professional Services 201 46300 01 319.01 Project Management Consultant 201 46300 01 319.02 Marketing - REDE - City Share 201 46300 01 319.03 County TIF Charges 201 46300 01 319.04 P/A Property Tax Payments 201 46300 01 319.05 Other Consultants 201 46300 01 319.07 Central Park Survey Work 201 46300 01 322.00 Postage Costs 201 46300 01 331.00 Travel Expense 201 46300 01 349.00 Other Advertising 201 46300 01 359.00 Other Printing & Binding Costs 201 46300 01 365.00 Workers Comp Insurance 201 46300 01 369.00 Other Insurance 201 46300 01 381.00 Electric Utilities 201 46300 01 383.00 Gas Utilities 201 46300 01 389.00 Other Utility Services 201 46300 01 403.00 Contracted Repairs & Maintenance 201 46300 01 433.00 Dues & Subscriptions 201 46300 01 433.01 Professional Organizations /Journ< 201 46300 01 433.02 Foreign Trade Zone Commission 201 46300 01 437.00 Conferences & Seminars 201 46300 01 439.00 Other Miscellaneous Charges 201 46300 01 521.00 Building & Structure Purchases 201 46300 01 525.00 Building & Structure Purchases 201 46300 01 530.00 Improvements Other Than Bldgs 201 46300 01 710.00 Transfers FUND TOTALS 2013 2014 Objecl 2014 2010 2011 2012 2013 2014 Objecl 2014 Proposed 2010 2011 2012 Adopted Detail Proposed Amount Actual Actual Actual Budget Amount Budget Comments $50,000 $58,600 $58,600 $58,000 $58,000 Operating Levy 0 0 0 0 0 Admin Fees Portion Only 0 0 0 0 0 0 0 0 0 0 0 LCDA Downtown Grant 0 0 0 0 0 Genz -Ryan Tenant Utility Pymts 10 81 50 100 100 Interest Earned on CD's 320 39 86 100 100 Checking Interest & Misc 0 0 0 0 0 0 0 575 0 0 0 10,853 0 0 0 0 0 10,564 0 0 0 0 0 0 $50,330 --- - - - - -- --------- $59,295 --- - - - - -- --- - - - - -- $58,735 --- - -- - -- --- - -- - -- $58,200 --- - - - - -- --- - - - - -- $58,200 --- - - -- -- --- - - -- -- --- - - - - -- --- - - - - -- 2013 2014 Objecl 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $3,433 $3,868 $3,302 $5,000 $5,000 Salary, Taxes, PERA & Benefits Port Authority Members 0 4,400 0 2,000 2,000 714 900 1,209 3,000 3,000 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Policy F -3 17,400 0 0 0 2,000 2,000 7,741 10,853 10,231 10,000 10,000 Twin Cities Marketing Initiative 10,564 0 0 0 0 0 0 0 0 0 0 0 0 5,400 5,400 0 0 0 0 0 132 87 0 800 800 291 0 0 0 0 401 3,972 2,939 11,800 10,000 Additional Marketing 855 321 0 2,000 2,000 538 521 540 500 500 Commissioners 5,079 2,282 1,532 2,000 2,000 Property Insurance 193 223 287 500 500 Business Park & Other Properties 0 0 0 0 0 Other Properties 0 0 0 0 0 Utility Fees 0 0 0 0 0 1,700 Prof Organizations /Journals 1,483 2,380 1,790 1,700 1,700 0 0 0 0 0 3,034 4,125 2,419 5,000 5,000 Development/TIF /Miscellaneous 86 48 110 500 500 Contingencies 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $40,543 --- - - - - -- --------- $39,979 --- - - - - -- --- - - - - -- $30,360 --- - - - - -- --- - - - - -- $58,200 - -- - - -- -- --- - - - - -- --- - - - - -- - -- - - - - -- $56,400 --- - - - - -- --- - - - - -- Page One 2014 BUDGET WORKSHEETS DOWNTOWN /BROCKWAY DISTRICT(0108) - REVENUES May 21, 2013 2010 Account # Description Actual 2011 Actual 2012 Actual 2013 Adopted Budget 2014 Object Detail Amount 2014 Proposed Budget Comments 242 31010.00 Current Ad Valorem Taxes $37,968 $46,811 $0 $0 $0 MVHC Payments 242 31050.00 Tax Increments 410,286 576,675 660,056 554,000 670,000 242 33400.00 State Grants & Aids 1,876 0 0 0 0 242 33425.00 Other State Grants & Aids 139,965 0 0 0 0 242 33620.00 Other County Grants & Aids 0 0 0 0 0 242 36210.00 Interest Earnings - Investments 73 724 879 0 0 242 36215.00 Interest Earnings 244 130 75 0 0 242 36220.00 Rents & Royalties 2,425 0 0 0 0 242 36230.00 Other Revenue 0 0 0 0 0 242 36260.00 Contribution/Donation- Private 125 0 0 0 0 242 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $592,961 --- - - - - -- --- --------- --- $624,339 - - - --- - - - --- $661,010 --- - -- - -- --- - -- - -- $554,000 -- - - - - -- -- - - - - -- -- - - - - -- -- - - - - -- $670,000 -- - -- - -- -- - - - - -- EXPENDITURES 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 242 49042 01 303.00 Engineering Fees $3,690 $0 $0 $0 $0 242 49042 01 304.00 Legal Fees 0 0 0 0 0 242 49042 01 319.00 Other Professional Services 4,730 16,053 10,699 20,000 20,000 County TIF Charges (in 2011) 242 49042 01 522.00 Building & Structure Purchases 0 103 0 0 0 242 49042 01 530.00 Improvements Other Than Buildings 0 0 0 0 0 242 49042 01 533.00 Waterford Grant Reimbursement 139,965 0 0 0 0 242 49042 01 601.00 Principal on Waterford PAYG 0 19,108 44,979 44,000 63,000 Waterford Pay -As- You -Go 242 49042 01 611.00 Interest on Waterford PAYG 0 63,880 83,340 90,000 80,000 Waterford Pay -As- You -Go 242 49042 01 710.00 Transfers 280,000 350,000 350,000 400,000 400,000 P & I for 2008A & 2008B Issues FUND TOTALS $428,385 --- - - - - -- --- --------- --- $449,144 - - - --- - - - --- $489,018 - -- - - - - -- --- - - - - -- $554,000 -- - -- - -- -- - -- - -- -- - - - - -- -- - - - - -- $563,000 -- - - - - -- -- - - - - -- -'N DEBT SERVICE FUNDS GENERAL / ADMINISTRATIVE • Debt Service Funds are Governmental Funds set up to provide for the repayment of debt of the City. This debt is normally accomplished through the issuance of bonds secured by the full faith and credit of the City. Repayment of the debt is usually accomplished through the collection of special assessments; general levies of the City collected through property taxes; tax increment funds; core funds; transfers from Enterprise Funds (Revenue Debt Issues) and transfers from other areas. 11� Page One - EXPENDITURES - 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 617 47000 01 317.00 General Fund Admin Fees 617 47000 01 319.00 Other Professional Services 617 47000 01 601.00 Bond Principal 617 47000 01 611.00 Bond Interest 617 47000 01 614.00 Amortization of Bond Discount 617 47000 01 621.00 Bond Paying Agent Fees 617 47000 01 710.00 Transfers FUND TOTALS $0 $0 $0 $0 $0 0 0 0 0 0 80,000 85,000 90,000 95,000 100,000 30,538 26,397 21,925 19,200 14,200 209 0 0 1,400 0 374 374 374 400 800 0 0 0 0 0 $111,122 $111,771 $112,299 $116,000 $115,000 --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - -- - -- --------- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- Comments Comments 90 2014 BUDGET WORKSHEETS DEBT SERV FUND 617 - G.O. WATER REVENUE BONDS, 2000A -REVENUES- September 3, 2013 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 617 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 617 36101.00 Principal - Special Assessments 0 0 0 0 0 617 36102.00 Penalties & Interest - S/A 0 0 0 0 0 617 36210.00 Interest Earnings - Investments 190 105 65 0 0 617 36215.00 Interest Earnings 40 13 21 0 0 617 36265.00 Use of Reserve Funds 0 0 0 0 0 617 37145.00 Surcharge on Water Revenues 0 0 0 0 0 617 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 617 39201.00 Transfer From General Fund 0 0 0 0 0 617 39202.00 Contribution From Enterprises 0 0 0 0 0 617 39203.00 Transfer From 0 0 0 0 0 617 39204.00 Transfer From Water Core 114,000 114,000 116,000 116,000 115,000 617 39205.00 Transfer From Sewer Core 0 0 0 0 0 617 39206.00 Transfer From Storm Core 0 0 0 0 0 617 39207.00 Transfer From Port Authority 0 0 0 0 0 617 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $114,229 --- - - - - -- --------- --------------- $114,119 --- - - - - -- --- - - - - -- --- - -- - - -- $116,086 --- - - - - -- --- - - - - -- - - - -- -- - - --- -- $116,000 --- - - - - -- --- - - - - -- --------------- - $115,000 --- - - - - -- --- - - - - -- - EXPENDITURES - 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 617 47000 01 317.00 General Fund Admin Fees 617 47000 01 319.00 Other Professional Services 617 47000 01 601.00 Bond Principal 617 47000 01 611.00 Bond Interest 617 47000 01 614.00 Amortization of Bond Discount 617 47000 01 621.00 Bond Paying Agent Fees 617 47000 01 710.00 Transfers FUND TOTALS $0 $0 $0 $0 $0 0 0 0 0 0 80,000 85,000 90,000 95,000 100,000 30,538 26,397 21,925 19,200 14,200 209 0 0 1,400 0 374 374 374 400 800 0 0 0 0 0 $111,122 $111,771 $112,299 $116,000 $115,000 --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - -- - -- --------- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- Comments Comments 90 Page One - EXPENDITURES- 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 301 47000 01 317.00 General Fund Admin Fees 301 47000 01 319.00 Other Professional Services 301 47000 01 601.00 Bond Principal 301 47000 01 611.00 Bond Interest 301 47000 01 621.00 Bond Paying Agent Fees 301 47000 01710. 00 Transfers FUND TOTALS $0 $0 0 0 105,000 110,000 91,690 87,790 403 403 0 0 •--- --- - - --- - -- -- -- -- - -- - -- $197,093 $198,193 - - - - - -- --- - - - - -- $0 0 115,000 83,571 403 0 $198,974 $0 $0 0 0 120,000 125,000 79,200 74,500 500 500 0 0 $199,700 $200,000 Comments Comments 2014 BUDGET WORKSHEETS DEBT SERV FUND 301 - G.O. CAPITAL IMPROVEMENT PLAN (CIP) BONDS, 2005A -REVENUES - September 3, 2013 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 301 31010.00 Current Ad Valorem Taxes $209,846 $0 $211,486 $212,011 $212,011 301 36101.00 Principal - Special Assessments 0 0 0 0 0 301 36102.00 Penalties & Interest - S/A 0 0 0 0 0 301 36210.00 Interest Earnings - Investments 58 32 411 0 0 301 36215.00 Interest Earnings 113 8 34 0 0 301 36265.00 Use of Reserve Funds 0 0 0 0 0 301 37145.00 Surcharge on Water Revenues 0 0 0 0 0 301 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 301 39201.00 Transfer From General Fund 0 210,764 0 0 0 301 39202.00 Contribution From Enterprises 0 0 0 0 0 301 39203.00 Transfer From 0 0 0 0 0 301 39204.00 Transfer From Water Core 0 0 0 0 0 301 39205.00 Transfer From Sewer Core 0 0 0 0 0 301 39206.00 Transfer From Storm Core 0 0 0 0 0 301 39207.00 Transfer From Port Authority 0 0 0 0 0 301 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS - -- $210,017 — --- ----- - --- $210,805 --------- -- - -- --- $211,931 -- ---- --- - - - - -- $212,011 -- ---- --- - -- -• $212,011 - EXPENDITURES- 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 301 47000 01 317.00 General Fund Admin Fees 301 47000 01 319.00 Other Professional Services 301 47000 01 601.00 Bond Principal 301 47000 01 611.00 Bond Interest 301 47000 01 621.00 Bond Paying Agent Fees 301 47000 01710. 00 Transfers FUND TOTALS $0 $0 0 0 105,000 110,000 91,690 87,790 403 403 0 0 •--- --- - - --- - -- -- -- -- - -- - -- $197,093 $198,193 - - - - - -- --- - - - - -- $0 0 115,000 83,571 403 0 $198,974 $0 $0 0 0 120,000 125,000 79,200 74,500 500 500 0 0 $199,700 $200,000 Comments Comments Page One 2014 BUDGET WORKSHEETS DEBT SERV FUND 303 - G.O. FIRE STATION REFUNDING BONDS, 2005D (Old 1996A) - REVENUES- September 3, 2013 - EXPENDITURES - 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 303 47000 01 317.00 General Fund Admin Fees 303 47000 01 319.00 Other Professional Services 303 47000 01 601.00 Bond Principal 303 47000 01 611.00 Bond Interest 303 47000 01 621.00 Bond Paying Agent Fees 303 47000 01 710.00 Transfers FUND TOTALS $0 $0 $0 $0 $0 2013 2014 0 0 2010 2011 2012 Adopted Proposed Account# Description Actual Actual Actual Budget Budget 303 31010.00 Current Ad Valorem Taxes $142,273 $143,654 $0 $0 $0 303 36101.00 Principal - Special Assessments 0 0 0 0 0 303 36102.00 Penalties & Interest - S/A 0 0 0 0 0 303 36210.00 Interest Earnings - Investments 233 130 1,858 0 0 303 36215.00 Interest Earnings 121 134 17 0 0 303 36265.00 Use of Reserve Funds 0 0 0 131,400 132,200 303 37145.00 Surcharge on Water Revenues 0 0 0 0 0 303 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 303 39201.00 Transfer From General Fund 355,000 0 0 0 0 303 39202.00 Contribution From Enterprises 0 0 0 0 0 303 39203.00 Transfer From 0 0 0 0 0 303 39204.00 Transfer From Water Core 0 0 0 0 0 303 39205.00 Transfer From Sewer Core 0 0 0 0 0 303 39206.00 Transfer From Storm Core 0 0 0 0 0 303 39207.00 Transfer From Port Authority 0 0 0 0 0 303 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $497,628 --- - - - - -- --------- -- $143,918 --- - - - - -- --- - - - - -- - -- -- - --- $1,874 --- - - - - -- --- - - - - -- - ---- --- -- - -- -- $131,400 --- - - - - -- --- - - - - -- --- - - - - - -- $132,200 --- - - - - -- --- - - - - -- - EXPENDITURES - 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 303 47000 01 317.00 General Fund Admin Fees 303 47000 01 319.00 Other Professional Services 303 47000 01 601.00 Bond Principal 303 47000 01 611.00 Bond Interest 303 47000 01 621.00 Bond Paying Agent Fees 303 47000 01 710.00 Transfers FUND TOTALS $0 $0 $0 $0 $0 0 0 0 0 0 110,000 110,000 115,000 115,000 120,000 27,313 23,655 19,829 15,900 11,700 403 403 403 500 500 0 0 0 0 0 $137,715 $134,058 $135,231 $131,400 $132,200 Comments Comments Page One 2014 BUDGET WORKSHEETS DEBT SERV FUND 326 - G.O. IMPROVEMENT BONDS, 20068 - REVENUES- September 3, 2013 Account # Description 326 31010.00 Current Ad Valorem Taxes 326 36101.00 Principal - Special Assessments 326 36102.00 Penalties & Interest - S/A 326 36210.00 Interest Earnings - Investments 326 36215.00 Interest Earnings 326 36265.00 Use of Reserve Funds 326 37145.00 Surcharge on Water Revenues 326 37160.00 Penalties - Surcharge Revenues 326 39201.00 Transfer From General Fund 326 39202.00 Contribution From Enterprises 326 39203.00 Transfer From 326 39204.00 Transfer From Water Core 326 39205.00 Transfer From Sewer Core 326 39206.00 Transfer From Storm Core 326 39208.00 Transfer From Street CIP 326 39310.00 Bond Proceeds 2,087 FUND TOTALS - EXPENDITURES - Account # Description 326 47000 01 317.00 General Fund Admin Fees 326 47000 01 319.00 Other Professional Services 326 47000 01 601.00 Bond Principal 326 47000 01 611.00 Bond Interest 326 47000 01 621.00 Bond Paying Agent Fees 326 47000 01 710.00 Transfers FUND TOTALS $1,836,454 $288,738 $353,118 $521,700 $509,000 --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --------- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- 2013 2014 2010 2011 2012 Adopted Proposed Actual Actual Actual Budget Budget --- ----- --- - - - --- --- - ------------ -------- - - - --- - -- ------ -- -- ---- ------- -- ---- -- $0 $0 $0 $0 $0 0 0 0 0 0 425,000 430,000 435,000 440,000 445,000 133,100 116,000 98,700 81,200 63,500 431 431 431 500 500 0 0 0 0 0 -- ----- ---- - --- -- - --- ---- --- - - -- -- ------ -- -- - -- -- - ----- ---- -- - --- --------------- - $558,531 $546,431 $534,131 $521,700 $509,000 --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --------- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- Comments Comments na 2013 2014 2010 2011 2012 Adopted Proposed Actual Actual Actual Budget Budget $0 $0 $0 $0 $0 179,754 87,175 149,677 0 0 7,889 174 1,309 0 0 851 1,260 2,087 0 0 325 130 45 0 0 0 0 0 321,700 309,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200,000 0 0 447,635 0 0 0 0 200,000 200,000 0 200,000 200,000 0 0 0 0 0 0 0 0 0 0 1,000,000 0 0 0 0 0 0 0 0 0 $1,836,454 $288,738 $353,118 $521,700 $509,000 --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --------- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- 2013 2014 2010 2011 2012 Adopted Proposed Actual Actual Actual Budget Budget --- ----- --- - - - --- --- - ------------ -------- - - - --- - -- ------ -- -- ---- ------- -- ---- -- $0 $0 $0 $0 $0 0 0 0 0 0 425,000 430,000 435,000 440,000 445,000 133,100 116,000 98,700 81,200 63,500 431 431 431 500 500 0 0 0 0 0 -- ----- ---- - --- -- - --- ---- --- - - -- -- ------ -- -- - -- -- - ----- ---- -- - --- --------------- - $558,531 $546,431 $534,131 $521,700 $509,000 --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --------- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- Comments Comments na Page One - EXPENDITURES - 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 611 47000 01 317.00 General Fund Admin Fees 611 47000 01 319.00 Other Professional Services 611 47000 01 601.00 Bond Principal 611 47000 01 611.00 Bond Interest 611 47000 01 614.00 Amortization of Bond Discount 611 47000 01 621.00 Bond Paying Agent Fees 611 47000 01 710.00 Transfers FUND TOTALS $0 2014 BUDGET WORKSHEETS $0 $0 $0 0 0 DEBT SERV FUND 611 - G.O. WATER REVENUE BONDS, 2007A 0 0 105,000 110,000 115,000 -REVENUES - 125,000 41,150 36,767 32,183 29,400 September 3, 2013 (2,574) (2,574) (2,574) 300 200 4,210 4,210 4,210 4,300 4,300 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 611 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 611 36101.00 Principal - Special Assessments 0 0 0 0 0 611 36102.00 Penalties & Interest - S/A 0 0 0 0 0 611 36210.00 Interest Earnings - Investments 233 130 80 0 0 611 36215.00 Interest Earnings 58 26 43 0 0 611 36265.00 Use of Reserve Funds 0 0 0 0 0 611 37145.00 Surcharge on Water Revenues 0 0 0 0 0 611 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 611 39201.00 Transfer From General Fund 0 0 0 0 0 611 39202.00 Contribution From Enterprises 0 0 0 0 0 611 39203.00 Transfer From 148,000 0 0 0 0 611 39204.00 Transfer From Water Core 0 154,000 154,000 154,000 154,000 611 39205.00 Transfer From Sewer Core 0 0 0 0 0 611 39206.00 Transfer From Storm Core 0 0 0 0 0 611 39207.00 Transfer From Port Authority 0 0 0 0 0 611 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS -- - -- - - - -- ----- $148,291 --- - - - - -- --- --------- --- -- - - ---- - $154,156 - - - - -- - - - - -- -------- -- - - -- $154,123 --- - - - - -- --- - - - - -- --- ---- -- --- - -- $154,000 --- - - - - -- --- - - - - -- -- ------ - --- -- $154,000 --- - - - - -- --- - - - - -- - EXPENDITURES - 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 611 47000 01 317.00 General Fund Admin Fees 611 47000 01 319.00 Other Professional Services 611 47000 01 601.00 Bond Principal 611 47000 01 611.00 Bond Interest 611 47000 01 614.00 Amortization of Bond Discount 611 47000 01 621.00 Bond Paying Agent Fees 611 47000 01 710.00 Transfers FUND TOTALS $0 $0 $0 $0 $0 0 0 0 0 0 105,000 110,000 115,000 120,000 125,000 41,150 36,767 32,183 29,400 24,500 (2,574) (2,574) (2,574) 300 200 4,210 4,210 4,210 4,300 4,300 0 0 0 0 0 ----------- ----- — --- - --- ---- -- -- - - ---- $147,786 $148,403 $148,819 $154,000 $154,000 Comments Comments 0 Page One 2014 BUDGET WORKSHEETS DEBT SERV FUND 381 - G.O. TAXABLE TIF 2008A & G.O. TIF 2008B - REVENUES- September 3, 2013 Account # Description 381 31010.00 Current Ad Valorem Taxes 381 31050.00 Tax Increments 381 36101.00 Principal - Special Assessments 381 36102.00 Penalties & Interest - S/A 381 36210.00 Interest Earnings - Investments 381 36215.00 Interest Earnings 381 36265.00 Use of Reserve Funds 381 37145.00 Surcharge on Water Revenues 381 37160.00 Penalties - Surcharge Revenues 381 39201.00 Transfer From General Fund 381 39202.00 Contribution From Enterprises 381 39203.00 Transfer From 381 39204.00 Transfer From Water Core 381 39205.00 Transfer From Sewer Core 381 39206.00 Transfer From Storm Core 381 39207.00 Transfer From Port Authority 381 39310.00 Bond Proceeds 0 0 FUND TOTALS - EXPENDITURES - Account # Description 381 47000 01 317.00 General Fund Admin Fees 381 47000 01 319.00 Other Professional Services 381 47000 01 601.00 Bond Principal 381 47000 01 611.00 Bond Interest 381 47000 01 621.00 Bond Paying Agent Fees 381 47000 01 710.00 Transfers FUND TOTALS $280,045 $350,063 $350,177 $350,000 $400,000 2013 2014 2010 2011 2012 Adopted Proposed Actual Actual Actual Budget Budget $0 $0 $0 $0 $0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 145 0 0 45 63 32 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 280,000 350,000 350,000 350,000 400,000 0 0 0 0 0 $280,045 $350,063 $350,177 $350,000 $400,000 0 0 0 0 0 - --- -- ---- ---- --- ---- - - -- -- -- --- --- -- -- ---- --- --- --- -- - - - --- --------------- - $277,485 $277,485 $311,610 $349,000 $379,300 Comments Comments f? 2013 2014 2010 2011 2012 Adopted Proposed Actual Actual Actual Budget Budget $0 $0 $0 $0 $0 0 0 0 0 0 0 0 35,000 75,000 110,000 276,635 276,635 275,760 273,100 268,400 850 850 850 900 900 0 0 0 0 0 - --- -- ---- ---- --- ---- - - -- -- -- --- --- -- -- ---- --- --- --- -- - - - --- --------------- - $277,485 $277,485 $311,610 $349,000 $379,300 Comments Comments f? Page One - EXPENDITURES- 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 323 47000 01 317.00 General Fund Admin Fees 323 47000 01 319.00 Other Professional Services 323 47000 01 601.00 Bond Principal 323 47000 01 611.00 Bond Interest 323 47000 01 621.00 Bond Paying Agent Fees 323 47000 01 710.00 Transfers FUND TOTALS $0 2014 BUDGET WORKSHEETS $0 $0 $0 0 0 DEBT SERV FUND 323 - G.O. EQUIPMENT CERTIFICATES, 2008A 0 0 65,000 75,000 80,000 -REVENUES - 85,000 14,065 11,272 8,180 5,000 September 3, 2013 0 0 0 0 0 0 0 0 0 0 -- -------- --- - - -- ---- $79,065 --- - - - - -- --- --------- --- 2013 2014 ------ - - ---- ---- $85,000 - - - - -- --- - - - - -- --- ---- - -- --- $86,700 - - - - -- - - - - -- 2010 2011 2012 Adopted Proposed Account# Description Actual Actual Actual Budget Budget 323 31010.00 Current Ad Valorem Taxes $92,157 $0 $0 $0 $0 323 36101.00 Principal - Special Assessments 0 0 0 0 0 323 36102.00 Penalties & Interest - S/A 0 0 0 0 0 323 36210.00 Interest Earnings - Investments 313 207 85 0 0 323 36215.00 Interest Earnings 66 23 6 0 0 323 36265.00 Use of Reserve Funds 0 0 0 85,000 86,700 323 37145.00 Surcharge on Water Revenues 0 0 0 0 0 323 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 323 39201.00 Transfer From General Fund 0 0 0 0 0 323 39202.00 Contribution From Enterprises 0 0 0 0 0 323 39203.00 Transfer From 0 0 0 0 0 323 39204.00 Transfer From Water Core 0 0 0 0 0 323 39205.00 Transfer From Sewer Core 0 0 0 0 0 323 39206.00 Transfer From Storm Core 0 0 0 0 0 323 39207.00 Transfer From Port Authority 0 0 0 0 0 323 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $92,535 --- - - - - -- --- --------- --- $229 - - - - -- - - - - -- $91 --- - - - - -- --- - - - - -- $85,000 --- - - - - -- --- - - - - -- $86,700 --- - - - - -- --- - - - - -- - EXPENDITURES- 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 323 47000 01 317.00 General Fund Admin Fees 323 47000 01 319.00 Other Professional Services 323 47000 01 601.00 Bond Principal 323 47000 01 611.00 Bond Interest 323 47000 01 621.00 Bond Paying Agent Fees 323 47000 01 710.00 Transfers FUND TOTALS $0 $0 $0 $0 $0 0 0 0 0 0 65,000 75,000 80,000 80,000 85,000 14,065 11,272 8,180 5,000 1,700 0 0 0 0 0 0 0 0 0 0 -- -------- --- - - -- ---- $79,065 --- - - - - -- --- --------- --- -- --- - - - - -- ----- $86,272 - - - - -- --- - - - - -- --- --- -- - - - - --- -- $88,180 - - - - -- --- - - - - -- --- ------ - - ---- ---- $85,000 - - - - -- --- - - - - -- --- ---- - -- --- $86,700 - - - - -- - - - - -- Comments Comments C10 Page One - EXPENDITURES - 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 614 47000 01 317.00 General Fund Admin Fees 614 47000 01 319.00 Other Professional Services 614 47000 01 601.00 Bond Principal 614 47000 01 611.00 Bond Interest 614 47000 01 614.00 Amortization of Bond Discount 614 47000 01 621.00 Bond Paying Agent Fees 614 47000 01 710.00 Transfers FUND TOTALS $0 2014 BUDGET WORKSHEETS $0 $0 $0 0 0 DEBT SERV FUND 614 - G.O. UTILITY REVENUE REFUNDING BONDS, 2010A (2001 B, 2002B & 2003B) 0 0 -REVENUES - 0 290,000 310,000 310,000 1,943 September 3, 2013 21,186 19,300 15,400 2,643 2,643 2,643 2,700 2,700 0 7,337 7,762 2013 2014 0 0 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 614 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 614 31050.00 Tax Increments 0 0 0 0 0 614 36101.00 Principal - Special Assessments 0 6,810 (3,016) 0 0 614 36102.00 Penalties & Interest - S/A 0 0 0 0 0 614 36210.00 Interest Earnings - Investments 0 411 505 0 0 614 36215.00 Interest Earnings 0 56 21 0 0 614 36265.00 Use of Reserve Funds 0 0 0 0 0 614 37145.00 Surcharge on Water Revenues 0 0 0 0 0 614 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 614 39201.00 Transfer From General Fund 0 0 0 0 0 614 39202.00 Contribution From Enterprises 0 60,000 84,000 89,000 90,000 614 39203.00 Transfer From 0 31,201 0 0 0 614 39204.00 Transfer From Water Core 0 16,000 148,000 155,000 160,000 614 39205.00 Transfer From Sewer Core 0 0 0 0 0 614 39206.00 Transfer From Storm Core 0 60,000 84,000 89,000 90,000 614 39207.00 Transfer From Port Authority 0 0 0 0 0 614 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $0 --- - - - - -- --------- $174,479 --- - - - - -- --- - - - - -- $313,510 --- - - - - -- --- - - - - -- $333,000 --- - - - - -- --- - - - - -- $340,000 --- - - - - -- --- - - - - -- - EXPENDITURES - 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 614 47000 01 317.00 General Fund Admin Fees 614 47000 01 319.00 Other Professional Services 614 47000 01 601.00 Bond Principal 614 47000 01 611.00 Bond Interest 614 47000 01 614.00 Amortization of Bond Discount 614 47000 01 621.00 Bond Paying Agent Fees 614 47000 01 710.00 Transfers FUND TOTALS $0 $0 $0 $0 $0 0 0 0 0 0 0 0 290,000 310,000 310,000 1,943 23,313 21,186 19,300 15,400 2,643 2,643 2,643 2,700 2,700 0 7,337 7,762 500 7,800 0 0 0 0 0 $4,586 --- - - - - -- --- --------- --- $33,293 - - - - -- - - - - -- $321,591 --- - - - - -- --- - - - - -- $332,500 --- - - - - -- --- - - - - -- $335,900 --- - - - - -- --- - - - - -- Comments Comments Page One 2014 BUDGET WORKSHEETS DEBT SERV FUND 383 - G.O. PORT AUTHORITY PUBLIC FACILITY REFUNDING BONDS, 2010B (2001 C) - REVENUES- September 3, 2013 - EXPENDITURES - Comments 2013 2013 2014 2010 2011 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 383 31010.00 Current Ad Valorem Taxes $0 $0 $166,892 $165,383 $163,611 383 36101.00 Principal - Special Assessments 0 0 14,192 0 0 383 36102.00 Penalties & Interest - S/A 0 0 60 0 0 383 36210.00 Interest Earnings - Investments 1,414 0 2,560 0 0 383 36215.00 Interest Earnings 0 3 24 0 0 383 36260.00 Other Revenue 0 2,871 0 0 0 383 36265.00 Use of Reserve Funds 0 0 0 0 0 383 37145.00 Surcharge on Water Revenues 0 0 0 0 0 383 39101.00 Sale of General Fixed Assets 0 0 0 0 0 383 39201.00 Transfer From General Fund 0 0 0 0 0 383 39202.00 Contribution From Enterprises 0 0 0 0 0 383 39203.00 Transfer From 0 0 343,087 0 0 383 39204.00 Transfer From Water Core 0 0 0 0 0 383 39205.00 Transfer From Sewer Core 0 0 0 0 0 383 39206.00 Transfer From Storm Core 0 0 0 0 0 383 39207.00 Transfer From Port Authority 0 0 0 0 0 383 39310.00 Bond Proceeds 1,355,000 0 0 0 0 FUND TOTALS -- --- - - -- $1,356,414 - --- ------ - -- $2,875 --- --- --- -- -- -- $526,814 --- - - -- - -- $165,383 --------------- - $163,611 - EXPENDITURES - Comments 102, 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget Comments 383 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 383 47000 01 319.00 Other Professional Services 34,732 0 0 0 0 383 47000 01 601.00 Bond Principal 0 0 1,275,000 125,000 125,000 2/1/12 Escrow Pymt for 2001C 383 47000 01 611.00 Bond Interest 0 20,337 33,945 33,300 31,700 383 47000 01 621.00 Bond Paying Agent Fees 11,179 0 425 500 500 383 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS - ------ --- - - - - -- -- $45,911 --- - - - - -- --- --------- --- ----- ---- - - - - -- $20,337 - - - - -- - - - - -- --- -- --- - - -- -- $1,309,370 --- - - - - -- --- - - - - -- -- ------ --- - - - - -- $158,800 --- - - - - -- --- - - - - -- --------------- -- $157,200 --- - - - - -- --- - - - - -- 102, Page One 2014 BUDGET WORKSHEETS DEBT SERV FUND 327 - G.O. IMPROVEMENT BONDS, 2011A - REVENUES- September 3, 2013 $0 $0 $0 $0 0 0 0 0 0 0 0 2013 2014 415,000 0 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 327 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 327 36101.00 Principal - Special Assessments 0 0 1,300,268 0 0 327 36102.00 Penalties & Interest - S/A 0 0 0 0 0 327 36210.00 Interest Earnings - Investments 0 22 409 0 0 327 36215.00 Interest Earnings 0 4 104 0 0 327 36265.00 Use of Reserve Funds 0 0 0 423,300 431,100 327 37145.00 Surcharge on Water Revenues 0 0 0 0 0 327 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 327 39201.00 Transfer From General Fund 0 0 0 0 0 327 39202.00 Contribution From Enterprises 0 0 0 0 0 327 39203.00 Transfer From 0 0 0 0 0 327 39204.00 Transfer From Water Core 0 0 0 0 0 327 39205.00 Transfer From Sewer Core 0 0 0 0 0 327 39206.00 Transfer From Storm Core 0 0 0 0 0 327 39208.00 Transfer From Street CIP 0 0 0 0 0 327 39310.00 Bond Proceeds 0 9,876 0 0 0 FUND TOTALS $0 --- - - - - -- --- --------- --- $9,902 - - - - -- - - - - -- $1,300,781 --- - - - - -- --- - - - - -- $423,300 --- - - - - -- --- - - - - -- $431,100 --- - - - - -- --- - - - - -- - EXPENDITURES - 2013 2014 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 327 47000 01 317.00 General Fund Admin Fees 327 47000 01 319.00 Other Professional Services 327 47000 01 601.00 Bond Principal 327 47000 01 611.00 Bond Interest 327 47000 01 621.00 Bond Paying Agent Fees 327 47000 01 710.00 Transfers FUND TOTALS $0 $0 $0 $0 $0 0 0 0 0 0 0 0 0 405,000 415,000 0 0 13,237 17,800 15,600 0 0 425 500 500 0 0 0 0 0 $0 --- - - - - -- --- --------- --- $0 - - - - -- --- - - - - -- --- $13,662 - - - - -- - - - - -- $423,300 --- - - - - -- --- - - - - -- $431,100 --- - - - - -- --- - - - - -- Comments Comments RAN 4 Page One - EXPENDITURES - Account # Description 328 47000 01 317.00 General Fund Admin Fees 328 47000 01 319.00 Other Professional Services 328 47000 01 601.00 Bond Principal 328 47000 01 611.00 Bond Interest 328 47000 01 621.00 Bond Paying Agent Fees 328 47000 01 710.00 Transfers FUND TOTALS 2014 BUDGET WORKSHEETS 2013 2014 2010 2011 DEBT SERV FUND 328 - G.O. IMPROVEMENT BONDS, 2012A Proposed Actual Actual Actual Budget -REVENUES - $0 $0 $0 $0 $0 September 3, 2013 0 425 0 0 0 0 0 0 155,000 0 0 2013 2014 5,100 0 2010 2011 2012 Adopted Proposed Account # Description Actual Actual Actual Budget Budget 328 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 328 36101.00 Principal - Special Assessments 0 0 0 0 0 328 36102.00 Penalties & Interest - S/A 0 0 0 0 0 328 36210.00 Interest Earnings - Investments 0 0 4 0 0 328 36215.00 Interest Earnings 0 0 25 0 0 328 36265.00 Use of Reserve Funds 0 0 0 5,500 160,600 328 37145.00 Surcharge on Water Revenues 0' 0 0 0 0 328 37160.00 Penalties - Surcharge Revenues 0 0 0 0 0 328 39201.00 Transfer From General Fund 0 0 0 0 0 328 39202.00 Contribution From Enterprises 0 0 0 0 0 328 39203.00 Transfer From 0 0 0 0 0 328 39204.00 Transfer From Water Core 0 0 0 0 0 328 39205.00 Transfer From Sewer Core 0 0 0 0 0 328 39206.00 Transfer From Storm Core 0 0 0 0 0 328 39208.00 Transfer From Street CIP 0 0 0 0 0 328 39310.00 Bond Proceeds 0 0 284 0 0 FUND TOTALS $0 --- - - - - -- --- --------- --- — ----------------- $0 - - - - -- - - - - -- $313 --- - - - - -- --- - - - - -- - ------ - - -- -- $5,500 --- - - - - -- --- - - - - -- ----- --- - - - - -- $160,600 --- - - - - -- --- - - - - -- - EXPENDITURES - Account # Description 328 47000 01 317.00 General Fund Admin Fees 328 47000 01 319.00 Other Professional Services 328 47000 01 601.00 Bond Principal 328 47000 01 611.00 Bond Interest 328 47000 01 621.00 Bond Paying Agent Fees 328 47000 01 710.00 Transfers FUND TOTALS Comments Comments W 4q A. 2013 2014 2010 2011 2012 Adopted Proposed Actual Actual Actual Budget Budget $0 $0 $0 $0 $0 0 0 425 0 0 0 0 0 0 155,000 0 0 0 5,000 5,100 0 0 0 500 500 0 0 0 0 0 $0 --- - - - - -- --------- $0 --- - - - - -- --- - - - - -- $425 --- - - - - -- --- - - - - -- $5,500 --- - - - --- --- - - - - -- $160,600 --- - - - - -- --- - - - - -- Comments Comments W 4q A. 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 10 Page One 10 2014 BUDGET WORKSHEETS WATER UTILITY -REVENUES - July 8, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 601 33425.00 Other State Grants & Aids $1,208 $0 $19,960 $0 $0 601 34108.00 Administrative Fees -Other Funds 590 2,123 5,733 0 0 5% of 5% Fees -Const Projects 601 34109.00 Other Gent Govt Chgs for Services 10,380 0 14,000 0 0 601 36101.00 Principal - Special Assessments 48,772 54,354 59,342 50,000 50,000 601 36102.00 Penalties & Interest - S/A 10,808 (5,989) (3,093) 0 0 601 36210.00 Interest Earnings - Investments 72,361 60,496 60,556 60,000 60,000 601 36214.00 Net Change in FV- Investments (6,319) 3,794 5,131 0 0 Annual Market Value Changes 601 36215.00 Interest Earnings 736 1,280 427 1,000 500 601 36220.00 Rents & Royalties 70,594 80,745 84,223 80,000 90,000 Antenna Leases 601 36260.00 Other Revenues 0 750 0 0 0 601 36265.00 Use of Reserve Funds 0 0 0 0 0 601 37110.00 Residential Water Revenues 999,856 1,079,507 1,258,104 1,050,000 1,200,000 601 37120.00 Apartment Water Revenues 71,064 75,444 79,934 73,000 75,000 601 37125.00 Institutional Water Revenues 72,159 70,470 87,847 70,000 75,000 60137130.00 Commercial Water Revenues 71,616 71,131 84,393 65,000 70,000 601 37140.00 Industrial Water Revenues 64,269 73,851 70,693 70,000 70,000 601 37160.00 Penalties - Water Revenues 8,861 9,378 10,470 8,000 8,000 601 37165.00 Meter Maint Water Revenues 0 0 0 0 0 601 37170.00 Other Water Revenues 0 0 0 0 0 601 37180.00 Water Meter Sales Revenue 32,138 27,498 42,497 30,000 35,000 601 39103.00 Gain or Loss from F/A Disposal 0 (1,532) (739) 0 0 601 39203.00 Transfer From 0 0 0 0 0 FUND TOTALS $1,529,091 $1,603,302 $1,879,477 $1,557,000 $1,733,500 10 Page One 2014 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - July 8, 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 601 49400 101.00 Salaries & Benefits $423,600 Salary, Taxes, PERA & Benefits 601 49400 77 101.00 Administrative 117,561 110,344 120,763 107,300 110,400 601 49400 78 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 164,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 6014940099 103.01 Utility Commission Wages (50%) 1,000 50% -601; 50% -602 601 49400 99 103.02 Maintenance Labor 7,000 100%-601 601 49400 01 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 49400 01 219.00 Other Operating Supplies 0 465 97 200 200 Maintenance Supplies 601 49400 01 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 49400 01 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 49400 01 228.00 Meter Repair Materials 0 0 0 300 0 601 49400 01 229.00 Other Maintenance Supplies 14,200 601 49400 01 229.01 Supplies for Hydrants 5,398 5,849 4,599 6,000 6,000 601 49400 01 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 49400 01 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 49400 01 303.04 Miscellaneous Fees 30,959 40,828 28,450 20,000 20,000 601 49400 01 304.00 Legal Fees 0 94 1,269 1,000 1,000 601 49400 01 310.00 Testing Services 44,000 601 49400 01 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 313.00 Temporary Service Fees 1,913 23,401 6,190 0 0 601 49400 01 315.00 Special Programs 0 601 49400 01 315.01 Public Information 0 0 0 0 0 601 49400 01 315.02 Plan Amendments 0 0 0 0 0 601 49400 01 315.03 Seminars 0 0 0 0 0 601 49400 01 318.00 Contract Engineer 6,000 7,000 8,000 7,000 7,000 Contracted Engineer for City(20 %) 601 49400 01 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 49400 01 319.03 Hazardous Chemical Permits 0 0 725 1,000 1,000 MN Department of Public Safety 601 49400 01 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 49400 01 320.00 Credit Card Activity Fees 0 0 0 0 2,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 49400 01 322.00 Postage Costs 4,299 4,504 4,678 5,000 5,000 Billings with Inserts 601 49400 01 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 6014940001 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 49400 01 369.00 Other Insurance 19,414 10,487 10,746 20,000 12,000 Water's Share of Premiums 601 49400 01 391.00 P.C. Maintenance 467 491 2,700 601 49400 01 391.01 U/B Software Maintenance 0 0 1,827 2,000 2,000 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 0 0 585 700 700 Added to Utility Budgets in 2012 601 49400 01 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 49400 01 394.00 P.C. Software Purchases 5,378 4,574 7,800 601 49400 01 394.01 Licensing & Maintenance 0 0 4,843 4,800 6,500 Cadegraph, GIS 601 49400 01 394.02 Online Subscriptions 0 0 308 300 800 Pictometry 601 49400 01 394.03 New Software Purchases 0 0 7,868 4,400 500 AV Enhancements at PW 601 49400 01 395.00 P.C. Repairs 0 0 0 500 500 PAGE TOTALS 722,489 664,963 705,356 713,800 �~ _ 768,900 q1 Page Two 2014 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - July 8, 2013 Account # Description 2010 Actual 2011 Actual 2012 Actual 2013 Adopted Budget 2014 Object Detail Amount 2014 Proposed 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 49400 01 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 Expansion(See 521) 601 49400 01 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 1,236,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 49407 01 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 49408 01 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 49408 01 38300 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 49408 01 530.00 Improvements Other Than Bldgs 11,700 1,809 0 1,000 0 TOTAL - WELL #8 15,748 19,736 24,385 y 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 49409 01 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 �L Page Three 2014 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - July 8, 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 49410 01 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 49410 01 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 6014941101 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) 601 49412 01 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 49412 01 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 49412 01 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 49414 01 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 49414 01 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 49414 01 409.00 Other Contracted Repairs & Maint 0 2,138 0 3,000 7,000 SCADA Reconfiguration, PLC 601 49414 01 439.00 Other Miscellaneous Charges 0 100 0 100 100 Contingencies 601 49414 01 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 49425 01 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 49425 01 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 49425 01 409.00 Other Contracted Repairs & Maint 0 0 0 2,500 500 601 49425 01 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 0 Page Four 2014 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - July 8, 2013 Account # Description 601 49415 01 221.00 Equipment Parts 601 49415 01 319.00 Other Professional Services 601 49415 01 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 49416 01 221.00 Equipment Parts 601 4941601 319.00 Other Professional Services 601 49416 01 381.00 Electric Utilities 601 49416 01 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 01 221.00 Equipment Parts 601 49417 01 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 49417 01 530.00 Improvements Other Than Bldgs TOTAL - WATER TOWER #4 (Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 601 4941801 319.00 Other Professional Services 601 49418 01 381.00 Electric Utilities 601 4941801 409.00 Other Contracted Repairs & Maint 601 49418 01 439.00 Other Miscellaneous Charges 601 49418 01 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 M0 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,158 429 2,600 2,600 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,500,900 - - -- ---- - - - --- - - -- ---- - - -- -- 1� 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 Gtq Page One III 2014 BUDGET WORKSHEETS SEWER UTILITY -REVENUES - July 8, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # 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 262 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 259,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,810,300 -- -- - - -- --- - - - --- -- - - - - -- --- - - - - -- III Page One 2014 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - July 8, 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 602 49450 101.00 Salaries & Benefits $423,600 Salary, Taxes, PERA & Benefits 602 49450 77 101.00 Administrative 117,536 110,563 120,762 107,300 110,400 602 49450 78 101.00 Technical /Clerical 158,239 136,305 144,154 144,200 148,400 602 49450 79 101.00 Maintenance 137,759 138,718 146,589 159,300 164,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 2,000 1/3 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 Prog. 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 Btdgs 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 �� 729,400 �11 Page Two 2014 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - July 8, 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 49453 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 (Haw(ins) 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 (Drumclrffe) TOTAL - LIFT STATION #6 2013 2014 Object 2014 2010 2011 2012 Adopted Actual Actual Actual Budget 923,221 981,478 940,900 1,030,000 3,554 3,232 2,893 0 0 172,451 10,493 0 1,435,129 1,625,124 1,447,906 1,742,900 0 0 0 100 182 4,215 21 800 0 0 0 200 0 5,499 0 0 948 1,058 925 1,500 0 0 0 200 0 0 0 100 1,129 10,772 947 2,900 0 0 0 100 0 2,697 59 800 0 0 0 200 211 211 105 0 558 620 554 700 0 0 0 200 0 0 0 100 769 3,528 719 2,100 0 0 0 100 9,421 338 0 800 0 0 0 200 3,546 3,154 3,578 3,500 0 0 230 200 0 0 0 100 12,967 3,492 3,808 4,900 0 0 0 100 3,387 478 2,001 800 0 0 0 200 5,560 4,898 5,377 6,000 0 3,195 0 200 0 0 0 100 8,947 8,571 7,377 7,400 0 0 0 100 724 31,500 0 800 0 0 0 200 0 0 0 0 0 0 0 0 5,125 5,609 5,879 6,000 0 0 0 200 0 0 0 100 5,849 37,108 5,879 7,400 0 0 0 100 203 118 4,247 800 0 0 0 200 5,060 6,614 3,788 7,500 0 0 0 200 0 0 0 100 5,263 6,732 8,035 8,900 Detail Proposed Amount Budget Comments 1,030,000 MWCC Charges 0 P.W. Building Expansion(See 521) 0 Transfers for Other Improvements 1,759,400 100 800 200 0 1,500 200 100 Contingencies 2,900 100 800 200 0 700 200 100 Contingencies 2,100 100 800 200 4,000 200 100 Contingencies 5,400 100 800 200 6,000 10,000 Alarm Upgrades, SCADA, PLC 100 Contingencies 17,200 100 800 200 0 0 7,000 200 100 Contingencies 8,400 100 800 200 5,000 3,000 Alarm Upgrades 100 Contingencies 9,200 8 Page Three 2014 BUDGET WORKSHEETS SEWER UTILITY • EXPENDITURES - July 8, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 602 49457 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49457 01 221.00 Equipment Parts 1,659 0 0 500 500 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49457 01 321.00 Telephone Costs 0 0 0 0 0 602 49457 01 381.00 Electric Utilities 982 1,103 1,176 1,200 1,200 602 49457 01 403.00 Contracted R & M - Other Impr 0 0 0 200 200 602 49457 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Glendalough 51h) TOTAL - LIFT STATION #9 W 2,641 1,103 1,176 2,300 2,300 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49458 01 221.00 Equipment Parts 237 6,612 353 500 500 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49458 01 321.00 Telephone Costs 0 0 0 0 0 602 49458 01 381.00 Electric Utilities 473 552 522 800 800 602 49458 01 403.00 Contracted R & M - Other Impr 0 0 0 200 200 602 49458 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Meadows of) TOTAL - LIFT STATION #8 _ 710 7,164 875 1,900 1,900 (Bloomfield) 602 49460 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49460 01 221.00 Equipment Parts 0 497 294 500 500 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49460 01 321.00 Telephone Costs 0 0 0 0 0 602 49460 01 381.00 Electric Utilities 183 295 251 400 400 602 49460 01 403.00 Contracted R & M - Other Impr 0 0 0 200 200 602 49460 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Glen Rose) TOTAL - LIFT STATION #10 183 793 545 1,500 1,500 GRAND TOTAL - ALLDEPTS. $1,473,586 $1,704,387 $1,477,266 $1,782,200 $1,810,300 rl� 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. [P Page One 2014 BUDGET WORKSHEETS STORM WATER UTILITY - REVENUES- July 8, 2013 Account # Description 603 33400.00 State Grants & Aids 603 33425.00 Other State Grants & Aids 603 34108.00 Administrative Fees -Other Funds 603 36101.00 Principal - Special Assessments 603 36102.00 Penalties & Interest - SIA 603 36210.00 Interest Earnings - Investments 603 36214.00 Net Change in FV- Investments 603 36215.00 Interest Earnings 603 36260.00 Other Revenues 603 36265.00 Use of Reserve Funds 603 37300.00 Storm Water Utility Revenues 603 37360.00 Penalties - Storm Water Utility 603 39203.00 Transfer From 300 0 FUND TOTALS 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $3,816 $0 $0 $0 $0 1,208 0 0 0 0 590 2,123 5,733 0 0 5% of 5% Fees -Const Projects 17,868 22,204 22,418 20,000 20,000 0 732 514 0 0 28,485 45,136 24,205 30,000 20,000 (11,555) 2,198 479 0 0 Annual Market Value Changes 617 245 262 400 300 0 0 0 0 0 0 0 0 0 0 835,434 879,551 908,679 860,000 900,000 3,901 3,690 5,416 3,600 4,700 0 0 0 0 0 $880,364 --- - - - - -- --------- $955,878 --- - - - - -- -- - - - - - -- $967,705 --- - - - - -- --- - - - - -- $914,000 --- - - - - -- --- - - --- - - - - -- --- - - $945,000 - - -- --- - - - - -- - - -- --- - - - - -- 0 Page One 2014 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - July 8, 2013 Account # Description 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 603 49500 101.00 Salaries & Benefits 1,195 1,726 0 0 603 49500 77 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 6034950079 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 603 49500 102.00 Full -Time Overtime 4,296 4,568 3,958 6,000 603 49500 99 103.00 Part-Time Salaries & Benefits 7,954 9,334 6,824 8,000 603 49500 01 203.00 Printed Forms & Paper 603 49500 01 204.00 Envelopes & Letterhead 603 49500 01 208.00 Miscellaneous Supplies 603 49500 01 215.00 Shop Materials 603 49500 01 219.00 Other Operating Supplies 603 49500 01 221.00 Equipment Parts 603 49500 01 224.00 Street Maintenance Materials 603 49500 01 225.00 Landscaping Materials 603 49500 01 225.01 Rip -Rap, Matting, Rock, etc. 603 49500 01 225.02 Black Dirt, Seed, Sod, etc. 603 49500 01 226.00 Sign Repair Materials 603 49500 01 230.00 Equipment Repair Material 603 49500 01 241.00 Small Tools 603 49500 01 242.00 Minor Equipment 603 49500 01 303.00 Engineering Fees 603 49500 01 303.01 Problem Area Investigations 603 49500 01 303.02 NPDES Phase II 603 49500 01 303.03 CSMP Update 603 49500 01 303.04 Miscellaneous 603 49500 01 303.05 GIS 603 49500 01 304.00 Legal Fees 603 49500 01 310.00 Testing Services 603 49500 01 312.00 Contract Inspection Fees 603 49500 01 313.00 Temporary Service Fees 603 49500 01 315.00 Special Programs (County Program) 603 49500 01 318.00 Contract Engineer 603 49500 01 319.00 Other Professional Services 603 49500 01 320.00 Credit Card Activity Fees 603 49500 01 321.00 Telephone Costs 603 49500 01 322.00 Postage Costs 603 49500 01 323.00 Radio Units 603 49500 01 352.00 General Notices & Public Info 603 49500 01 365.00 Workers Comp Insurance 603 49500 01 369.00 Other Insurance 603 49500 01 384.00 Refuse Disposal 603 49500 01 389.00 Other Utility Services 603 49500 01 391.00 P.C. Maintenance 603 49500 01 391.01 U/B Software Maintenance 603 49500 01 391.02 Auto Read Software Support 603 49500 01 393.00 P.C. Hardware Purchases 603 49500 01 394.00 P.C. Software Purchases 603 49500 01 394.01 Licensing & Maintenance 603 49500 01 394.02 Online Subscriptions 603 49500 01 394.03 New Software Purchases 603 49500 01 403.00 Contracted R & M - Other Impr 603 49500 01 403.01 Ditching 603 49500 01 403.02 Miscellaneous Repairs 603 49500 01 416.00 Machinery Rental 603 49500 01 433.00 Dues & Subscriptions 603 49500 01 435.00 Books & Pamphlets 603 49500 01 437.00 Conferences & Seminars 603 49500 01 437.01 Storm Water Management 603 49500 01 437.03 Wetlands Training 603 49500 01 437.04 Cartegraph, ESRI, GIS 603 49500 01 437.05 Miscellaneous Training 603 49500 01 439.00 Other Miscellaneous Charges 603 49500 01 530.00 Improvements Other Than Bldgs 603 49500 01 530.01 CRP of Storm Sewer 603 49500 01 560.00 Furniture & Fixture Purchases 603 49500 01 580.00 Other Equipment Purchases 603 49500 01 586.00 Computer Equipment Purchases PAGE TOTALS 1,258 1,195 1,726 0 0 0 0 0 352 0 0 0 0 0 0 0 0 0 1,578 406 1,199 408 1,751 1,386 299 1,962 1,370 287 926 0 204 534 881 0 0 87 2,747 332 221 31,441 28,763 15,076 8,525 0 0 0 0 1,275 4,500 6,000 0 0 2,284 4,299 1,083 58 2,640 4,927 0 0 467 0 0 0 5,378 0 0 0 10,003 0 22,880 29,866 0 234 0 0 9,706 4,500 7,000 3,356 0 2,312 4,504 1,210 0 2,875 2,393 0 0 491 0 0 320 4,574 0 0 0 3,501 29,749 36 4,186 1,672 0 0 0 0 3,850 8,000 0 0 2,647 4,678 1,116 0 2,654 2,362 0 0 1,500 0 1,600 0 0 0 2,000 2,000 2,000 2,000 2,000 500 1,000 1,000 2,000 10,000 30,000 0 30,000 5,000 2,000 1,000 500 0 5,000 7,000 5,000 0 2,500 5,000 1,500 1,000 3,500 6,000 600 500 10,000 30,000 0 30,000 5,000 1,827 2,000 2,000 585 700 700 1,362 4,000 50,000 4,779 4,800 6,500 308 300 800 7,772 4,400 500 0 0 0 5,000 5,000 46,150 22,899 17,830 50,000 50,000 939 43 0 4,000 500 140 140 140 0 0 0 0 500 4,000 875 875 965 1,000 1,200 0 0 0 500 0 0 157 270 1,500 1,500 0 0 0 0 1,000 145 144 153 0 SCADA 11,997 2,669 597 150,000 150,000 0 0 0 500 Public Info Brochure 0 0 0 2,000 0 0 0 0 500 360,346 299,624 284,731 547,100 3,000 500 548,200 � 6� All Salary Costs Inclusive of $176,800 Salary, Taxes, PERA & Benefits 0 6,000 8,000 1,500 0 500 Stakes, Ribbons, Level, etc. 0 0 0 2,000 Blacktop & Gravel Washouts 4,000 500 1,000 1,000 2,000 Misc. Nozzles for Vac Truck 75,000 2,000 1,000 Water Quality Tests (M) 500 3rd Part Inspection Program (M) 0 5,000 Wetland Health & Evaluation Proj 7,000 Contracted Engineer for City(20 %) 5,000 SCADA 2,000 1/3 Cost of C/C Pymt Processing 2,500 Cell Phones, Modems, GPS 5,000 Billings & Into Mailings 1,500 24 Units' $300 (Split 5 Ways) 1,000 Public Info Brochure 3,500 Storm Waters Share of Premiums 4,000 Storm Water's Share of Premiums 0 0 2,700 Added to Utility Budgets in 2012 Added to Utility Budgets in 2012 3,000 AV Enhancements at PW 7,800 Cartegraph, GIS Pictometry AV Enhancements at PW 55,000 Storm System Maint., Catch Basins 4,000 Pumps 200 SUSA(AJ, Dick) 50% Split w /Storm 500 Utility Information 3,700 Stormwater Collab, Flygt Training User Group, Conference, Training 0 150,000 Annual Pavement Management 500 2,000 500 548,200 � 6� Page Two 2014 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - July 8, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount 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/1/08 603 49500 01 710.03 112 of 2011 P & I Payments(2001B) 54,000 0 0 0 0 Bonds Called 211/11 603 49500 01 710.04 1/2 of 2011 P & I Payments(2001 D) 0 0 0 0 0 Bonds Paid off 2/1/08 603 49500 01 710.05 1/2 of 2011 P & I Payments(2002B) 33,000 8,000 0 0 0 Bonds Called 2/1/11 603 49500 01 710.06 112 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 635,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 - ALLDEPTS. $510,737 $700,152 $441,779 $647,600 $659,700 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 l0 Page One 2014 BUDGET WORKSHEETS ARENA - REVENUES September 3, 2013 2013 2014 Object 2014 2010 2011 2012 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 650 36210.00 Interest Earnings - Investments $274 $486 $897 $0 $0 650 36215.00 Interest Earnings 274 137 142 100 100 650 36230.00 Contributions /Donations 0 0 0 0 0 650 36260.00 Other Revenue - Learn to Skate 39,709 30,122 33,551 31,000 31,000 Learn to Skate Program (LTS) 650 36265.00 Use of Reserve Funds 0 0 0 0 19,900 650 38060.00 Prime Time Ice Fees 247,457 251,519 238,721 251,000 245,000 650 38061.00 Non -Prime Time Ice Fees 87,068 73,792 55,772 74,000 65,000 650 38063.00 Open Skating Ice Fees 5,216 5,259 4,587 6,000 5,000 650 38064.00 Broomball Revenues 0 0 0 0 0 Moved to Prime /Non -Prime Times 650 38065.00 Other Events - Arena 0 0 0 0 0 Dry Floor Events 650 38066.00 Advertising Revenue - Arena 13,000 3,500 8,375 10,000 10,000 650 38067.00 Skate Sharpening Revenue - Arena 3,636 3,322 2,628 3,500 3,000 650 38090.00 Concessions 3,900 3,900 3,900 3,900 3,900 650 38091.00 Vending Machine Revenues 5,974 5,771 4,737 6,000 5,000 650 38095.00 Pro Shop Revenues 837 863 658 1,000 1,000 Tape, Laces, Mouthguards, etc. 650 39103.00 Gain or Loss from F/A Disposal 0 0 0 0 0 650 39201.00 Transfer From General Fund 115,000 115,000 115,000 115,000 115,000 Subsidy for Operations FUND TOTALS -- -------- 522,345 - - - - -- 493,669 -- - - - - -- -- - - - - -- 468,968 -- - - - - -- -- - - - - -- 501,500 -- - -- - -- -- - -- - -- 503,900 -- - - - - -- -- - -- - -- -- - - - - -- -- - - - - -- Page One 2014 BUDGET WORKSHEETS ARENA - EXPENDITURES September 3, 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 650 45130 101.00 Salaries & Benefits $158,000 Salary, Taxes, PERA & Benefits 650 45130 77 101.00 Administrative 43,775 42,725 40,250 40,500 41,700 650 45130 78 101.00 Technical /Clerical 34,427 35,363 36,545 37,600 38,600 650 45130 79 101.00 Maintenance 67,022 73,447 76,702 81,300 77,700 650 45130 xx 101.00 Salary & Benefit Contingency 0 0 0 0 0 650 45130 79 102.00 Full -Time Overtime 2,456 1,494 490 2,000 2,000 650 45130 103.00 Part -Time Salaries & Benefits 40,000 650 45130 89 103.00 Learn -To -Skate Program 20,097 16,286 16,975 17,000 17,000 650 45130 99 103.00 Building Attendants 24,507 22,000 26,885 23,000 23,000 And Other PIT Positions 650 45130 01 207.00 Training & Instructional Supplies 0 0 0 100 100 650 45130 01 208.00 Miscellaneous Supplies 700 650 45130 01 208.01 Skate Magnets 0 100 0 100 100 650 45130 01 208.02 Other Supplies 0 484 0 600 600 650 45130 01 209.00 Other Office Supplies 185 0 47 500 500 Learn to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 3,409 4,198 4,079 4,000 4,000 650 45130 01 212.00 Motor Fuels 0 0 0 0 0 Zamboni Maintenance 650 45130 01 216.00 Chemicals & Chemical Products 4,835 4,249 5,535 5,000 5,000 Cooling Tower 650 45130 01 219.00 Other Operating Supplies 38 156 209 500 500 Events Supplies 650 45130 01221 .00 Equipment Parts 3,034 7,425 4,836 6,000 6,000 650 45130 01 223.00 Building Repair Supplies 826 2,590 1,335 3,000 3,000 650 45130 01 265.00 Other Items for Resale 333 269 484 600 600 Pro Shop Supplies 650 45130 01 305.00 Medical & Dental Fees 0 0 0 0 0 650 45130 01 311.00 Officiating Fees 0 0 0 0 0 650 45130 01 317.00 General Fund Admin Fees 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Admin Fee Policy 650 45130 01 321.00 Telephone Costs 1,174 1,340 1,413 1,300 1,300 650 45130 01 331.00 Travel Expense 0 0 0 100 100 650 45130 01 341.00 Employment Advertising 0 0 0 0 0 650 45130 01 349.00 Other Advertising 110 115 115 400 400 650 45130 01 365.00 Workers Comp Insurance 3,567 3,254 3,402 3,500 3,500 650 45130 01 369.00 Other Insurance 7,671 3,679 4,637 8,000 8,000 650 45130 01 381.00 Electric Utilities 115,700 125,740 130,420 120,000 125,000 650 45130 01 383.00 Gas Utilities 23,885 26,328 22,141 27,000 24,000 650 45130 01 384.00 Refuse Disposal 3,178 2,817 2,833 3,500 3,000 650 45130 01 401.00 Contracted Building Repairs 1,928 10,189 5,580 7,000 7,000 650 45130 01 404.00 Contracted Mach & Equip Repairs 19,230 22,730 35,889 22,000 25,000 650 45130 01 415.00 Other Equipment Rental 0 0 0 300 300 650 45130 01 433.00 Dues & Subscriptions 868 720 745 1,000 1,000 MIAMA & MRPA Dues 650 45130 01 437.00 Conferences & Seminars 0 0 0 400 400 MIAMA & MRPA Seminars 650 45130 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 Contingencies 650 45130 01 521.00 Building & Structure Purchases 0 0 0 0 0 650 45130 01 580.00 Other Equipment Purchases 42,000 12,000 15,541 60,000 75,000 Cooling Tower, Skate Sharpener 650 45130 01 710.00 Transfers 3,500 650 45130 01 710.01 Yearly Maintenance 3,500 3,500 3,500 3,500 3,500 650 45130 01 710.02 0 0 0 0 0 650 45130 01 710.03 0 0 0 0 0 FUND TOTALS 433,757 429,196 ° °- 446,587 --- - --------- 485,800 ----- -- ---- ------- - -- - --- 503,900