Loading...
HomeMy WebLinkAbout9.a. 2013 Budget 4ROSEN4GUI'4T EXECUTIVE SUMMARY CITY COUNCIL City Council Regular Meeting September 4, 2012 AGENDA ITEM: Adoption of Preliminary 2013 Budget, AGENDA SECTION: Tax Levies, and Public Hearing Date New Business PREPARED BY: Dwight Johnson, City Administrator and Jeff May, Finance Director AGENDA NO. .a� ATTACHMENTS: Resolution and Preliminary Budget APPROVED BY: tD� RECOMMENDED ACTION: Motion to Adopt A Resolution Setting the Preliminary 2013 General Fund Operating Budget, the Preliminary 2013 C.I.P. Budgets, the Preliminary 2013 Insurance Budget, the Preliminary 2013 Port Authority Operating Levy, the Preliminary 2012 Levy, and the Budget Hearing Date (Tuesday, December 4, 2012) Required by the City of Rosemount. INTRODUCTION Each year the City Council must approve a preliminary budget and tax levy by September 15`h. We are also required to set a date and time for a public hearing at this time. The City Council has met several times on the budget so far this year. State law says that the tax levy adopted in September may be reduced when the final budget is approved in December,but may not be increased (except in rare, special circumstances). EXECUTIVE SUMMARY The recommended budget for 2013 proposes no increase in the City taxes levied on a median value home. The City tax levy would increase by 1.26% and the overall increase in City funding needs would be 1.76%. With the reductions of$33 in City taxes for the median home in 2009, $77 in 2010, $56 in 2011, $38 for 2012 and$0 projected for 2013, the five year property tax decline for the median home is estimated to be $204 or 19.3%. The median family home paid$1,058 in City taxes in 2008 and would pay an estimated $854 in 2013 with this proposed budget. The levy is proposed to increase by$130,068 due to proposed additional funding for Fire Department compensation, salary adjustments approved in union contracts for 2012 and 2013, the proposed addition of a senior center, additional maintenance for our new ball fields at UMore Park, elimination of the player maintenance fees for athletic fields, additional maintenance of parks,investments in new technologies and an increase in contingency funds. Offsetting these increases, debt levies will decrease by$60,638 due to a wise use of 2011 General Fund surplus funds to further reduce our debt levy requirements. Other important factors benefitting us include the proposal to not fill two positions that had retirements in 2012 (Receptionist and Public Works Operations Superintendent). We will not save the full salary and benefits of either position, however. The Receptionist position still has some money budgeted for 2013 if it is decided that the position must be filled by a part-time employee at a later date. There was a reorganization of the Public Works Department to partially shift responsibilities of the Operation Superintendent that caused other positions to be reevaluated and subsequent salary adjustments were made. A summary of key characteristics of the proposed 2013 budget are shown in the following table: Budget Facts at a Glance Estimated Loss of property tax base from 2012 -2.27% Average reduction in residential values -3.34% General fund spending change: +2.13% Total funding change—all funds +$293,968 Total funding change—all tax impacted funds +$169,468 Change in overall tax levy from 2011 +$130,068 City share of tax impact on median value home -$0 Percentage tax reduction on median value home 0.00% Change in estimated tax rate (City share only) +4.25% (from .46994 to .48991) BUDGET PROCESS 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 2012-2013 on February 21, 2012. This draft budget was initially developed by the Department Directors and the Finance Director. I met with each Department Director and reviewed every line item with them. Revenues were generally estimated by the Finance Director with input from the Departments. In addition, as a part of the budget review, we have looked again at 10 year needs projections for street improvements, equipment replacement,buildings and the Ice Arena. Finally, we looked at the overall budget strategically one more time for its overall balance, consistency, impact on taxpayers, and long term impacts on finances for 2013 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. The City continues to look for new savings and efficiencies. The savings from the reduction of staff due to two retirements are examples of this. In the past several years,we have also saved money with new boilers in the Steeple Center, used our insurance reserves to help us move to a higher deductible plan,and improved technology or software in such areas as our new web site,paperless council packets, and internal document handling. Other such improvements in the works include a new customer friendly utility billing system and access to certain building permits on-line. 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. 2 GENERAL FACTORS AFFECTING THE BUDGET Tax Base For the fourth consecutive year, the overall tax base in the community has declined. The overall tax capacity value within the City is estimated to be 2.27%lower in 2013 that it was in 2012. This is on top of a 4.51% decline for 2010, a 5.12% decline for 2011 and an 8.39% decline for 2012 (largely because of the market value exclusion adjustments). The decline in market value of the median home in Rosemount is lower than other communities in Dakota County this year,with an average decrease in market value of 3.34%. The overall tax base did not decline by that much because new growth in the community offset some of the decline in existing property values. REVENUES Property taxes fund 79% of the General Fund budget and 61% of the overall City Budget. As noted above, our tax base is decreased by 2.27% for 2013. However, there are several other categories of General Fund revenues that are also important to the City. The chart below compares budgeted revenue for 2012 with estimated revenue in 2013 for several key categories of revenues. 2012 Budget 2013 Estimated Change Licenses &Permits 362,300 382,300 +20,000 Intergovernmental 634,500 643,100 +8,600 Charges for Services (no SKB) 243,400 238,000 -5,400 Fines &Forfeits 125,000 125,000 -0- Recreational Revenues 254,900 263,200 +8,300 Miscellaneous Revenues 186,300 194,200 +7,900 SKB revenue (General Fund portion) 425,000 425,000 -0- Non-tax revenues are relatively stable overall. Two of the most important non-tax revenues are building permit revenues and SKB fees. Building Permit Revenues During 2011, 53 new dwelling units were built in Rosemount. We are anticipating that the final results for 2012 and 2013 will be about the same, and have budgeted building permit revenues to be about the same as in 2012 with a slight increase for anticipated commercial/industrial development. New construction by D.R. Horton and Lennar in Prestwick Place and the new Greystone Addition on Akron Avenue has helped offset the completion of Glendalough in Evermoor. SKB Revenues The draft budget for 2013 continues to designate $425,000 of SKB funds to support the operating budgets. We estimate that up to $550,000 will be available for capital budgeting purposes for 2013. This is a reduction from the amount available the past several years based on recent trends. These funds will help fund council goals relating to a senior center, downtown and community amenities identified in the Council's 2012-2013 goals 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. 3 EXPENDITURES Salaries Rosemount currently employs 76 full time employees. This compares with 81 full time employees at the beginning of 2008. Union contracts with all four of our bargaining units are in place until December 31, 2013. Salary increases for 2012 were 1% for all employees and for 2013 there will be a 1%increase on January 1St and 1% on July 1S`. With contracts in place for all employees, no salary contingency is necessary for 2013 such as was required for the 2012 budget. Health Insurance Increases in recent years have varied between 0% and 18%. In order to moderate these extremes, the Council approved a plan to use excess fund 2011 fund balance as a reserve to help moderate the increases from year to year. Therefore, the proposed budget contains a health insurance increase of 7.65%which is the average of the last three years. The actual increase for 2013 will be 6.4%, so our reserve will not need to be utilized in 2013. Fire Department Pay As you know,in the development of the 2012 budget staff discussed a concern that the compensation in the Fire Department needed to be addressed to help assure the long range future of our paid-on-call department. The Council approved funding in 2012 that allowed the pay per call to increase from$2 to $6 for the firefighters. The estimated cost of this increase was approximately $52,000. Our studies in early 2012 showed that the average compensation for paid-on-call firefighters in the area is about$12 per hour (not per call). Since our fire pension is above the average of other area cities,Rosemount's compensation would need to be between$9 and$10 per hour to reach a level of parity with other departments in total compensation. However, the most important reason to consider further compensation increases is to help assure that we can maintain or increase our number of paid-on-call firefighters. The proposed budget includes an additional$50,000 in 2013 to further address firefighter compensation needs. In future years, additional funds may also be needed for a Duty Crew concept to help with daytime fire response and full or part-time staffing. The budget does not include any increase for the Fire pension fund. It may take five years or longer to bring the Fire Department to the point where we can consider that we have a sustainable framework for the next ten to twenty years. Fuel Cost Assumptions Fuel costs for 2013 will not be very predictable until December when we will sign a new fuel consortium agreement with the State. In this budget for 2013,we are decreasing the expected price of fuel based on current market conditions and actual consumption records. The decrease shows up in the Fleet Maintenance budget where the motor fuel line item is decreased by $10,000. Dakota Communications Center(DCC) The DCC budget line with the Police Department budget is showing an increase of$45,700 compared with the current 2012 budget. This is not because the DCC has increased its assessment (it's actually slightly lower) but rather because a one-time cost saving applied over the past three years has now expired. In 2009, the DCC determined that it could rebate some of its balance to the member cities and all were given the choice of taking the rebate all in one year or taking it in three equal portions over three years. Rosemount elected the three year option to moderate the impact when the rebate ended,but there is still a noticeable change in this line item. Senior Center Operation The City is working with a developer to build senior housing and a senior center just north of the Steeple Center. At this writing, no development agreement has been signed yet. An estimate has been made of utility and other operating costs as well as the cost of a part-time person for the center. It is also possible 4 that the City may wish to contract for the staffing and programming needs. Working on the assumption that the project may be complete about October 1,2013,we have included 25% of the operating costs and 33%of the staffing costs in 2013 for the senior center. A small amount of operating revenue for the last quarter of 2013 is also included. Notable Other Cost Increases or Decreases Other cost increases in the General Fund include $8,000 in the Parks Maintenance budget for additional chemicals in the parks. In 2010, as part of the Council's general overview of City services,it was determined that the City's budget for fertilizing and herbiciding in the City parks should be reduced. However,by this spring, the negative results of this initiative were greater than expected. Therefore, a restoration of the$8,000 in the Parks Maintenance budget is being added to that budget. Also,in the area of technology initiatives, the 2013 budget includes ongoing maintenance funding for Workflow which is an add-on application for our Laserfiche document handling program. This application will allow more paperless transactions between various staff members such as approval of purchase orders or preparation of agenda reports. An amount of$50,000 (same as in 2012) is included in the CIP for other software improvements throughout the City. Contingency Account The line item in the Council budget named Council Designated really acts as a contingency fund for overall City operations for unexpected expenses or opportunities. For example, funds from this account were used to pay for recovering from the winter kill of the soccer fields at DCTC a year ago. Over the past few years, our goal has been to budget about$100,000 in this account. In 2012, the amount is $95,000. For 2013,we are seeking a somewhat higher amount of$109,000 because of uncertainties in our g g engineering contract for 2013 and also uncertainties regarding Fire Department staffing. 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 this fall. At this time, a review of the trends for the purpose of setting CIP levies for 2013 has been done. The levy for the Equipment is proposed to continue to be $460,000. The Street CIP is proposed to have a levy of$730,000 for 2013, an increase of$10,000 to reflect the modest growth rate of the City and the current good ratings of the street system. Within the next five years, the Council will need to consider more significant increases in this fund based on projected needs later in this decade. The low inflation rate and the minimal construction of new streets over the last year and the current high pavement management ratings indicate that no major increase is needed at this time. For 2012 and forward the trail and sidewalk construction appropriation of$125,000 per year in the General Fund has been transferred to the Street CIP account to relieve the General Fund tax of this burden and to also segregate capital construction projects from the General Fund which is intended primarily for the City's operational costs. Beginning in 2012, $125,000 of SKB revenue per year is being allocated to the Street CIP to fund the ongoing trail and sidewalk construction projects. The Building CIP has an ongoing levy of$24,000 for 2013 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 of the downtown and neighborhood amenities in the Council's 2012-2013 goals and improvements and updates planned for the Community Center. No tax levy above the current$24,000 is proposed. Additional SKB funds in the future along with proceeds from past General Fund surpluses will provide the funds for these projects. 5 Enterprise Fund Budgets The City's Enterprise Funds include the Water Fund, Sewer Fund and Storm Water Fund. The Water Fund includes an increase of$69,000 mostly for the pump reconditions at two of the City's well sites. The Sewer Fund shows a very slight increase in the operational budget for 2013 as does the Storm Water Fund. Debt Service Funds The City ended 2011 with a General Fund surplus. The Council approved a strategy that committed a portion of the surplus to continuing to offset existing debt levies, similar to what was approved for the previous three years. Funds were available from the 2011 surplus to use for the remaining debt service payments on the DCC debt that all cities and the County have shared in paying for the last 5 years. The City will save $60,638 for 2013 (the final year that we must levy to repay our share of that debt). Implementation of this strategy is once again a major reason why we have been able to propose an overall flat tax on the median valued home for 2013. CONCLUSION We are pleased that for the fifth year in a row,we can propose a budget that does not increase taxes on the median value home. In fact, City taxes on the median home are 19.3%lower than in 2008. While we continue to implement cost saving measures in City government and reduce our debt levies,we are also addressing important priorities including our Fire Department, Senior Center and our Park and Recreation facilities. Accordingly,we recommend approval of the preliminary 2013 budget and tax levy as presented and establishing a public hearing date for the budget on December 4, 2012, at 7:30 p.m. 6 2013 CITY BUDGET REPORT 4ROSEMOUNT MINNESOTA 2013 ANNUAL BUDGET SECTION 1 COUNCIL ACTION (PINK) SECTION 2 OTHER INFORMATION (DARK BLUE) SECTION 3 GENERAL FUND REVENUES (GRAY) SECTION 4 GENERAL FUND EXPENDITURES (LIGHT YELLOW) SECTION 5 GENERAL FUND DEPARTMENT BUDGETS (BROWN) SECTION 6 CIP FUND BUDGETS (MEDIUM GREEN) SECTION 7 INSURANCE FUND BUDGET (LIGHT BLUE) SECTION 8 PORT AUTHORITY BUDGET (RED) SECTION 9 DEBT SERVICE FUND BUDGETS (LIGHT AMBER) SECTION 10 UTILITY FUND BUDGETS (ORANGE) WATER FUND SEWER FUND STORM WATER FUND SECTION 11 ICE ARENA BUDGET (LIGHT GREEN) 2013 ANNUAL BUDGET PREPARED BY: MAYOR WILLIAM DROSTE CITY COUNCIL MEMBER MARK DEBETTIGNIES CITY COUNCIL MEMBER MATT KEARNEY CITY COUNCIL MEMBER KIM SHOE-CORRIGAN CITY COUNCIL MEMBER JEFF WEISENSEL CITY ADMINISTRATOR DWIGHT D. JOHNSON FINANCE DIRECTOR JEFFREY A. MAY POLICE CHIEF . ERIC WERNER FIRE CHIEF SCOTT AKER CITY ENGINEER/PUBLIC WORKS DIRECTOR ANDREW J. BROTZLER COMMUNITY DEVELOPMENT DIRECTOR KIMBERLY J. LINDQUIST DIRECTOR OF PARKS & RECREATION DANIEL L. SCHULTZ ASSISTANT CITY ADMINISTRATOR EMMY L. FOSTER PUBLIC WORKS SUPERVISOR JIM KOSLOWSKI BOARDS, COMMISSIONS AND COMMITTEES PARK & REC COMMITTEE PORT AUTHORITY MAUREEN BARTZ WILLIAM DROSTE JOANNE COPE MATT KEARNEY JASON EISOLD BOB LEUTH MICHAEL ELIASON CARL PETERSON BARBARA FARRELL MARY RILEY JEFF WEISENSEL PLANNING COMMISSION DAN WOLF VANESSA DEMUTH BRUNO DINELLA UTILITY COMMISSION VALERIE EGE DON HARMSEN SYED AMMAR HUSAIN SHAWN MULHERN WADE MILLER DAVID SPEICH JOHN POWELL MIKE WEBER BUDGETS ADOPTED General Fund December 3, 2012 10-Year CIP Program Funds December 3, 2012 Insurance Fund December 3, 2012 Arena Fund December 3, 2012 Port Authority Fund June 5, 2012 Utilities Funds (Water, Sewer & Storm Water) July 9, 2012 Truth in Taxation Public Hearing December 3, 2012 3 CITY OF ROSEMOUNT DAKOTA COUNTY, MINNESOTA RESOLUTION 2012 - A RESOLUTION SETTING THE PRELIMINARY 2013 GENERAL FUND OPERATING BUDGET, THE PRELIMINARY 2013 C.I.P. BUDGETS, THE PRELIMINARY 2013 INSURANCE BUDGET, THE PRELIMINARY 2013 PORT AUTHORITY OPERATING LEVY AND THE PRELIMINARY 2012 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 2013 will be in the amount of$16,520,000 for the General Operating Fund, the three CIP Funds, the Insurance Fund, the Port Authority Fund and the Enterprise Funds; and WHEREAS, the City Council has determined that special levies for Bonded Indebtedness and the Armory Project total $463,394; and WHEREAS, the City Council has determined that actual incomes, fund transfers and anticipated aids will total $6,521,500. NOW, THEREFORE BE IT RESOLVED, that the total Preliminary Levy certified to the Dakota County Auditor shall be $10,461,894; 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 4, 2012, at 7:30 P.M., in the Council Chambers at the City Hall. ADOPTED this 4t" day of September, 2012. William H. Droste, Mayor ATTEST: Amy Domeier, City Clerk RESOLUTION 2012 - 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 4th day of September, 2012, as disclosed by the records of said City in my possession. (SEAL) Amy Domeier, Rosemount City Clerk DAKOTA COUNTY City of Rosemount PROPERTY TAXATION & RECORDS TAXING DISTRICT NAME • PAYABLE 2013 PROPOSED LEVY CERTIFICATION FORM FORM B peed aue dget: : aca Qte : : :Cef ed Ie :f:::::::::: ..:..:......... . ::::::.... .... ::::::.. : : ........ : : .::::::::::::::::::::::::::::::::::::::.••••::::.• :::C • eg. .. ............ ......R ulrem�nt.... ......GmtAid .... ....::::::RQOUrce ::;::::::.:::::::?: ::: D- :::::::::::::::::::::::::::::::::.:....................... ...... .......,... . ... . .......... .... .. .. '#;, l ,�:• ,�'�„-�'3,•,zs<f, t .ym�. ¢ P��:- # ':', ,�" �7�,� �r a� z `s�. - �"" ti.;� �• s- rs� P ; TAXCAPACITY BASED LEVY,,, ,. .r 0ree C , Atritils ,t � ' i % General Revenue $ 16,520,000 $ -0- $ 6,521,500 $ 9,998,500 Debt-General Obligation* 463,394 -0- -0- 463,394 Debt-Other* Road and Bridge • Other (identify) Total Tcap Based Levy $ 16,983,394 $ -0- $ 6,521,500 $ • 10,461,894 • MARKET REFERENDUM BASED LEVY " x . s� ...w;. -�,,..F..�. .., om.,e_ r .....-,. ,. u:.. ., . ...... o.�..!:? �...� - _, ,..__ ..., :,. F.: .z tog m ;'�I 't»,o +S i • Debt-General Obligation* -0- _0_ Debt-Other* Other Total Mkt Referendum Levy $ -0- $ $ $ _0_ Total, of•all Levies $ , 1:6,983.,394 $ _0 =. $ 6,521,500 $ 10,46.1,894 * 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..... Levy certified to the County Treasurer-Auditor. ROUND TO THE NEAREST WHOLE DOLLAR.DO N01 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 REPORTED MATCH ANY OTHER SUPPORTING DOCUMENTATION INCLUDED '. , Cert•f d 4-vy o f t is form matches amount on your taxing district's resolution, etc.) (651) 322-2031 Signaturepf 1.n completing form Phone number (including area-code) Finance Director 9-7-12 Title Date :::::<:..`:`;'.:::.E.:THUS„FORM MUST BE RETURNED TO P.ROP.ER :;::::: ::>:::::;:.: :;:.:..., ::;: .. BY.;SEPTEMBER 17..2x1 <: >:: : .:.;.. .....::. . 2012 GENERAL PROPERTY TAX LEVY PAYABLE 2013 GENERAL LEVY GENERAL FUND $8,481,500 BUILDING CIP FUND $24,000 STREET CIP FUND $730,000 EQUIPMENT CIP FUND $460,000 INSURANCE FUND $245,000 PORT AUTHORITY OPERATING LEVY $58,000 TOTAL GENERAL LEVY $9,998,500 BONDED INDEBTEDNESS G.O. CAPITAL IMPROVEMENT PLAN (CIP) BONDS 2005A(Authorized-$212,011) $212,011 G.O. IMPROVEMENT BONDS 2006B (Authorized-$266,872) $0 PUBLIC SAFETY REVENUE BONDS 2007(Dakota Communications Center)(Authorized-$60,638) $0 G.O. EQUIPMENT CERTIFICATES 2008A(Authorized-$92,811) $0 G.O. PUBLIC FACILITY REFUNDING BONDS 2010B(Old 2001 C) (Port Authority) (Authorized-$165,383) $165,383 G.O. IMPROVEMENT BONDS 2011A(Authorized-$6,626) $0 TOTAL BONDED INDEBTEDNESS $377,394 MARKET VALUE BASED REFERENDUMS G.O. FIRE STATION REFUNDING BONDS, 2005D (Authorized-$140,511) $0 TOTAL FIRE STATION LEVY $0 PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($1,931,934,605 x .00798% =$154,168) (As of 3/9/12) $86,000 (Authorized-$154,168-Only Levy Amount Due MSABC) TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS $86,000 GRAND TOTAL 2011 PROPERTY TAX LEVY $10,461,894 Last Updated 8/20/12 7 -., Frbbbb bbbbb0000b b d cnC`zififo 0 o c 3 3 3 mmmmcoc) co d —N D1 N a a a 5/--0 V a c c N -0 O O1'<`� DDDA 3 3 3-5'OU TCD3 N ,D< N W 0 S 7'S N 3 3 3 W N d 7 7 5 fT CL w c O m m m m-_I 0 C0 CO CO m. 3 3 A N j Cp O ,W 0 CD Q m x 7 7 7 n n n 7 Cn 0 O C 0 0 0 C7 c Q-,•-• C N N 0 d a 7 �..- a O O) C N DC a_ y N N N CW N N O O N O 7 .. 7 N N N A,m ,000 0 N N N 0 O g r:Nm 00 NC Si OOO�N0, z �00V(nON 000,_, co0omy_ 7 DC O 0DC)D„0 0 DmD- o© 3 N (D --CO C7 0 0 0 co O N N C N 3 O D 7 3 ° a °o N O m 2 3 C D g O 0 7 a ° 0. m 0 m N - 0 0 8 00 > C) 0 0 co 03 co -, A W N N N N N CO N 7 IV(V W A W)IV V O O N V 0 8 A O 0 ' 0 n Dn n N O n N O 0O 000 0O 0 b 0 0 0 0 0 0 O O O O O O O O O -s() O 1 0 0 0 0 O O O O O O 0 O O 0 O O O N N I _ V to A A A _, _, N O A i O)+N-OD Na -4 O I N 0 0 0 N N N 0 .0 .0 0 .0 O- CD CC) n O 0 0 0 0 0 0 O 0 0 0 0 O O O W 0 ' 0 0 0 0 0 0 O O O O O O O O 7 y A O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 P. ✓ 4 _ 94 N oV W CO (NO N CO W N O 4 ...4 ...>-. (5,11, -• N O O 1 In A N-,N O O O V N O CO CO �10 O� CCD N 7 (C) 01 0 V N N V W W 0 0 00 0 W 01 W iJ CD N I 000Cn V 01NVO-.WOVOONNW M 0 CO O O O O N N in (n O in,.I O in 0 0 in O I-I CD N I O O O O O N O 0 0 -4 CCC 0 0 0 O O O N a. O ; W W -. . —N A 0t -. s s 0) 0t N A N (n W N W 0 W 0 0 N -{ G-I CO CO CD V A Co N 0 A N j A O (O 0) CO ' CO j A U N O O 10 V N CD"co -co 10 C) A O _) N O O O N V N V W O W O O V O O W N W - C (D 7 CO I 0 0 0 0 N N Cn N O 01 V O N O O (n O V CO N 0 0 0 O O N O O O V N 0 0 0 0 0 0(n CD m c N 0 A _ A (C) m O CO C• NO CAO V A N Cn A N-3 A-3 0 co i 3 3 In O0 N_A 0) O fD CD V N)10 CO CO CO CO Cap O 0 0 0 N V O N V O-W 00 V CO O O N 0 W CD C P w CO I 0 0 0 O Cn O N (n O O) V O Cn O O(n O V A V , 0 0 0 0 0 0 O O O V N O O O O O O (n CD Ir I.. A It i 000000000 0 0 7 A -+7 C A Di d 4U DI W d d 07 d OI CT N y pj O N Oi 0 < -cc -cn N WN W N "co j p CD `< on.)-, CD 6 w — N) m r v 7 7 7 N 7 7 7 7 7 N 7 A. co W 01 pl N N W N O) O) d N N DC 0 < co 0) - CD 'C A I O .. 000 O -i 0. y 0 0 0 0 0 -(7-7 m co 23 43-0 CD N 0 CO CD CD 0 CD z m m m m o o z Cn m”c' o' z z z z CD C c C C N 7 7 7 7 CD N N_D D D(n N CD N N w co co a a 0.a 5. co w in 7 7 O N CD CD O N CA N 0 0C N if 0 3 3 3 m C :D m n Q. N 7 0 O C a CD 0 7 11 c c 7 n A (0 a m m x a 0 7 m 0 0 g DAKOTA COUNTY OFFICE OF PROPERTY TAXATION & RECORDS PAYABLE 2013 TRUTH IN TAXATION PUBLIC BUDGET MEETING DATE CERTIFICATION FORM A Taxing District Name: City of Rosemount Public Meeting Date: Tuesday, December 4, 2012 Time of meeting: 7:30 P.M. Place of meeting: Rosemount City Hal 1 (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 E a www.ci .rosemount.mn.us No or personal m (homeil )a-maiAddress:l If you would like an e-mail contact or your website listed on the notice, addresses please. please complete.Not you not equired to provide this information. Signature of person / completing this form: Title: Finance Di rector Phone number: (651) 322-2031 Date: September 7, 2012 ****Please include area code when identifying phone numbers**** • CITIES AND COUNTY;This_form must be returned to:PT&R h .Se tember< 7 20< SC HE3QL OISTRIGTS Thais fc�rrn must fae returned to PT&R.by Oetob+�r'), �Q� FUNDING REQUIREMENTS-USES (INCLUDING FIRE STATION LEVY) September 4,2012 2012 2013 Adopted Proposed +/- Departments Budget Budget Difference Percentage Council Budget $280,800 $252,700 ($28,100) -10.01% Administration Budget 510,200 484,300 (25,900) -5.08% Elections Budget 42,000 22,000 (20,000) -47.62% Finance Budget 421,600 435,000 13,400 3.18% General Government Budget 378,500 383,200 4,700 1.24% Community Development Budget 898,400 904,600 6,200 0.69% Police Budget 3,061,700 3,206,800 145,100 4.74% Fire Budget 377,500 437,000 59,500 15.76% Public Works Operating Budgets: Government Buildings Budget 484,400 540,500 56,100 11.58% Fleet Maintenance Budget 635,900 645,100 9,200 1.45% Street Maintenance Budget 1,315,300 1,268,800 (46,500) -3.54% Parks Maintenance Budget 764,700 738,900 (25,800) -3.37% Park&Rec Budget-General Operating 1,085,300 1,129,500 44,200 4.07% Park&Rec Budget-Steeple Ctr.Operations 58,900 64,500 5,600 9.51% Park&Rec Budget-Senior/Activity Center 0 14,000 14,000 100.00% Park&Rec Budget-Special Programs 101,600 113,900 12,300 12.11% Transfers-Arena Assistance 115,000 115,000 0 0.00% Total Operating Budgets-General Fund $10,531,800 $10,755,800 $224,000 2.13% Transfers-Debt Service Levies 0 0 0 n/a Total Of All Budgets-General Fund $10,531,800 $10,755,800 $224,000 2.13% Building CIP Requirements 24,000 24,000 0 0.00% Street CIP Requirements 720,000 730,000 10,000 1.39% Equipment CIP Requirements 460,000 460,000 0 0.00% Insurance Budget Requirements 245,000 245,000 0 0.00% Port Authority Operating Levy 58,600 58,000 (600) -1.02% Bonded Indebtedness 441,326 377,394 (63,932) -14.49% Bonded Indebtedness-Fire Station Levy 0 0 0 0.00% Armory Anticipatory Levy(Value 3/9/12) 86,000 86,000 0 0.00% **$1,931,934,605 x.00798%=$154,168** Water Enterprise Fund 1,261,900 1,330,900 69,000 5.47% Sewer Enterprise Fund 1,780,400 1,782,800 2,400 0.13% Storm Water Enterprise Fund 628,800 647,800 19,000 3.02% Arena Enterprise Fund 451,600 485,700 34,100 7.55% Total Funding Requirements $16,689,426 $16,983,394 $293,968 1.76% NOTE: Special Levies include(1)Bonded Indebtedness,(2)Fire Station Levy and(3)Armory Anticipatory Levies. /0 FUNDING REQUIREMENTS-SOURCES (INCLUDING FIRE STATION LEVY) September 4,2012 2012 2013 Adopted Proposed +/- Types Budget Budget Difference Percentage Internal Revenue Generated: Licenses and Permits 362,300 382,300 20,000 5.52% Intergovernmental 634,500 643,100 8,600 1.36% Charges for Services 668,400 663,000 (5,400) -0.81% Fines&Forfeits 125,000 125,000 0 0.00% Recreational Fees 254,900 263,200 8,300 3.26% Miscellaneous Revenues 186,300 194,200 7,900 4.24% Transfers In 3,500 3,500 0 0.00% Enterprise Revenues 4,122,700 4,247,200 124,500 3.02% - ----------------------------------------------------------- Total Internal Revenues 6,357,600 6,521,500 163,900 2.58% Levy Sources: Special Levies 527,326 463,394 (63,932) -12.12% General Levy 9,804,500 9,998,500 194,000 1.98% Total Levy $10,331,826 $10,461,894 $130,068 1.26% Loss of MVHC from State Funding $0 $0 $0 0.00% Total Revenue Sources $16,689,426 $16,983,394 $293,968 1.76% NOTE: Special Levies include(1)Bonded Indebtedness,(2)Fire Station Levy and(3)Armory Anticipatory Levies. (1 2012 GENERAL PROPERTY TAX LEVY PAYABLE 2013 GENERAL LEVY GENERAL FUND $8,481,500 BUILDING CIP FUND $24,000 STREET CIP FUND $730,000 EQUIPMENT CIP FUND $460,000 INSURANCE FUND $245,000 PORT AUTHORITY OPERATING LEVY $58,000 TOTAL GENERAL LEVY $9,998,500 BONDED INDEBTEDNESS G.O. CAPITAL IMPROVEMENT PLAN (CIP) BONDS 2005A(Authorized-$212,011) $212,011 G.O. IMPROVEMENT BONDS 2006B (Authorized-$266,872) $0 PUBLIC SAFETY REVENUE BONDS 2007(Dakota Communications Center) (Authorized-$60,638) $0 G.O. EQUIPMENT CERTIFICATES 2008A(Authorized-$92,811) $0 G.O. PUBLIC FACILITY REFUNDING BONDS 2010B(Old 2001C) (Port Authority) (Authorized-$165,383) $165,383 G.O. IMPROVEMENT BONDS 2011A(Authorized-$6,626) $0 TOTAL BONDED INDEBTEDNESS $377,394 MARKET VALUE BASED REFERENDUMS G.O. FIRE STATION REFUNDING BONDS,2005D(Authorized-$140,511) $0 TOTAL FIRE STATION LEVY $0 PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($1,931,934,605 x.00798%=$154,168) (As of 3/9/12) $86,000 (Authorized-$154,168-Only Levy Amount Due MSABC) TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS $86,000 GRAND TOTAL 2011 PROPERTY TAX LEVY $10,461,894 Last Updated 8/20/12 is MINNESOTA- REVENUE 2013 LOCAL GOVERNMENT AID NOTICE July 30, 2012 ROSEMOUNT CITY OF CLERK CITY HALL 2875 145TH ST W ROSEMOUNT, MN 55068 THE 2013 CERTIFIED LGA FOR YOUR CITY IS: $0 Based on Laws of Minnesota 2012, Chapter 294, Article 1, Section 3, the following is the determination of your 2013 Local Government Aid (LGA). Cities with a population of 5,000 or more will automatically receive aid equivalent to their 2012 Certified LGA amount. Cities with a population less than 5,000 will receive the greater of: 1) 2012 Certified LGA; or 2) the result of the 2013 LGA formula. 1. 2012 Certified LGA: $0 2. 2013 LGA Formula (applicable only to cities <5,000 population): NA 3. Greater of 1 or 2: $0 4. Certified 2013 LGA(same as 3): $0 If you have any questions regarding this certification, contact Bill Sparks at bill.sparks(cr�state.mn.us or at (651) 556-6095. Property Tax Division Tel: 651-556-6095 Mail Station 3345 Fax: 651-556-3128 St.Paul,MN 55146-3345 TTY: Call 711 for Minnesota Relay An equal opportunity employer SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) (Proposed) 2010 2011 2012 2013 Total Funding Requirements 17,059,244 16,625,444 16,689,426 16,983,394 Less: Internal Revenues 6,332,500 6,092,800 6,357,600 6,521,500 Less: Market Value Based Levy-Fire Station(See Below) 142,273 143,654 0 0 (3) Equals: Revenues Needed 10,584,471 10,388,990 10,331,826 10,461,894 Add Back in State MVHC Cuts to Reflect Actual Levy 412,575 429,507 0 0 (4) Levy Certified by City to County Auditor 10,997,046 10,818,497 10,331,826 10,461,894 County Auditor Adjustments(All Subtractions): Fiscal Disparities Distribution Levy(Metro Area) 1,195,913 1,299,717 1,252,954 1,235,453 (2) Spread Levy Used to Compute Local Tax Rate 9,801,133 (1) 9,518,780 (1) 9,078,872 (1) 9,226,441 Increase/(Decrease)from Previous Year in Spread Levy -2.88% -4.62% 1.63% Market Value Based Referendum Levy-Fire Station 142,273 143,654 0 0 (3) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2013 Number Provided by Dakota County as of 8/17/12 (3) For 2012&2013 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-8/20/12 I 0 05no a 0551 x x m E i o N2o a oN� 1 11 < m ,w. o O`z m ° O`er N v 01 m O.�m 3 °1 �`7 ° x x m o a m #d a 30 0�13 an mmn p t7 cam m n m°^°^#w vn o n mIO� m Grp(7nnn ggg- d o d a fD 0 1 C d I=°a n tl m ° p°i ry a° m 0 3 1 O O1 A m° o d d E m^m m c $^ c ?� c 3^d -°Qc m c 3^ o,7 ea a D ? m� = O d . Mm 'm g m m D a.m,< 3 O d A I O l 0 1 m a m% i = .. p t m N 1 A�n w = .. A i m o = w a d tm a g k amp a m ��i m w �. m,Am uci a m m a .. m m m 3 3` 3 w a "' 3 3 ii I i i i 1 II j I 7 0 0 0 1 I I o00 11 hl boo I+ I 0000 cl i �1 bbb ii + I 0000 Iji II W f.J . 828 O 1 0 ' O N N A W I N N O O O II O O N N A II V _p 0 1 +JO)N O Npp U �p tO A + O N O II U 1 UUIO P N I I 11 (O 1 J N V -4,m m U 88 1 W I O+p O ILO A O U U m O N O 11 0+01 + II N 1 OICD+J I 801 V v.V 18 VV.'S' O , ES i tNUO 2822 W Om II 0 1 2mt+ W 1 + I V J I i I ; II I 1 I 0000 I ; o0o I N. : °° I ON bA N I j W I n II ° o 0 0 o m O O O 0 + { pIU jA I W 1D W(O I p W T W O W+ O N p p 8 d 48 p N I O J 1 O i +° .p O N O 1 A ' U 2A 8 C N W N 1 W 1J+AOU N+2 NVO 1 2 T A N A S I l O U 1 8 N V O 8 N U A p 0�"O 1 2I 2,282 U O U 1 1 I 1 i 1 0 0 0 1 1 I N I I j I p 3 1 I < O 0 0 O V IW ' d 0 0 0 " 0 0 W t!.!..' W + O N O j I .0,-. NI w i 9 I N °;$ 1j i U A:m + N S O 5 ° V EO p p A i,10 I I NO +O p i ^ I 0 j W Zit'A O U m V j W m I ' O + O ^ N: C +c O 3 2 , x a x d O I I Q 11 11 II v C II O O O 1 I I N 1 O O O 1 a D m 1 _ 1 °O O + 0000 81 2. I OO O G 1 + 0000 N v N d.OQ d,w I S1 A +++ OP I ° 88A d I IN + ONO I ° ONjd N + 9 1 T O ry 0 0 Z N T 1W 1 O W j 1.IV 0 O p o Im O+6 + 1 j A 10 A co CO O N.6 1 O O U O m p T O C ^O m fV 1208 2 U OO A y° 1 00 O U A O A 1 I U A A W 8220 mom I O OUIA+j i m N m R N N p a X a 1 I 1 I 1 1 I ° -.m 7 a 0 n 3.d 1 n c o o 1 1 O o a - 0000 N .A 1 000 4 "o.3 X d ^s bI °° 1 O N W P A l . A a I N Np I O N" + 2 D m N d ? ry O 1_9 G a N m IO ° ..=:-‘-.; 0° IA U +p N 00 I A P N +j U p ONO I A A A p N pOl m i 5 6 ?N m r IW I Np O A W2 t .W p 1N N A N O al O O D : tot O V j U U�� 1 2 g OO . 0I O N ±a Z m Q G sm.zm O a N F I 0 0 I I N I I coo v m m w t c i i oo 1 o000 I W m I N i 0000 o+N m a ? g q p m i na 1' ° V .++N u I + Eva A I N I N 0 0 0 1 j o N W A + W mI ," 3 O m T N a y 1V I N+ W W J O N -. ° A N W A " N I U +A O +j U 0 U-O I 28 p b N^ w 1p I W O V O V+p T ° 1 . N O 0O 1 I A P O p J O ( CO° moo- U 3 H 4 d � ...5%P.2 z 3 .5;3 J+ I I (pOpII 0 0 J N 5 V z 3 a °'N *3 n am -2=02 N � �� � ii I ` 1 1 ?c mmz N° So .: 5,2 w x m O O O 1 O 1 O O O 1 N J° SN + d j m 1 d 0 60 0 No PO O P p v I O O m I + 0 0 0 0 T 01W p;NN m 021 0 0M M A _, O ` l7 C 1 m N ° N =° a d N D A N 0 1V mW+P I W A .p A V O O I O ( + A 53 D C_ j C<J ° O Cd V N II OI OA O I N 08A O OW p W OlJ 0 I CE. O " Y v m 1 d N v .. Og N f,T, o m ^2' 11 u S I 1 mm 31 y 3 " - oOO O o Ooo NX I oo O 0 N n% m X R O 3 ? p NO I > A�NN O N S ; r oN w A ++ 6 >A+O C a t g o 0 N j O 1 m 2 8 2 W O I O NNp N O p + „7,, 5 U I d A 0 0 TACT.' Lis I O A O N R T 3 m a d a1, °N O I OO p C d DX P9 °N IAA C 1 1 1 N T'' a V o I o + m a Iv a" W N ^ � J 808 i + oNNo N X 1 o OO oo W V m N A n $ m IO OW N A it 8 NN O r2' 1 ° w =Poi V A Up ° Q Wing V N m 3 8 G O O Wm nn =0 i o m 1 I 1 c m.N N N 1 ag. U W ] 2 4 O O O + O NO O N C I W O O O I + 0 0 0 0 C la N1m444.m TFyi a3 ++ ON ; U1 I 1 N + OO8 10 I ONNA N N I Om O N O W R2 N O 888 18 + - 0 U +000 NO 1 O ;p0A + I° j O O N O A nS e e J�V 1 p OU A p H I p +U+O W W O U V OJ 1 p I 8 O A m O N 0 0 0 1 ppp N 1 1 N m I 0O V > > m 7 OCO 1 _ 0000 sIz Iw + O O O 1 N+ I O O N o 0 N N O W eee1 mro -- m ° I N p0.p N d j U U +p J !OO! O N 00 0 O o 0 j .W p I N 0 0 aa o,1,3a i° m m a o o o 1 a ? N °O°° 17. P9PP °o v0 i 7 I o 0 0 o 1M, W c 333 , m N d G N O S N O A (U�°t1+t m 11 W N O N 1 A i '91t2 W A m D ?AlT IO f E U o Ir W O It °IAN m O I 11 N +m I =:288 pW U+ I I OUi y m ll i R - 1-a ee +p I IO .0.- tlq i '� II t° 0(007) 1 N W I O N O p+ W i i i vsv m m vsv v..N.Nv v - C n n m 01.22 ,m..1 v v W 'Z O .Nip N <w m a d 3 W w _ d O d X ;4 >0 o w ^w a? d A U m °i d ° to m I a N P 1 O A i I''. W s I o> /S GENERAL FUND REVENUES September 4,2012 2012 ADOPTED 2013 PROPOSED +/- TYPES BUDGET BUDGET DIFFERENCE PERCENTAGE GENERAL FUND REVENUES General Property Taxes $8,296,900 $8,481,500 184,600 2.22% Licenses and Permits 362,300 382,300 20,000 5.52% Intergovernmental 634,500 643,100 8,600 1.36% Charges for Services 668,400 663,000 (5,400) -0.81% Fines and Forfeits 125,000 125,000 0 0.00% Recreational Fees 254,900 263,200 8,300 3.26% Miscellaneous Revenues 186,300 194,200 7,900 4.24% Transfers In 3,500 3,500 0 0.00% TOTAL GENERAL FUND REVENUES $10,531,800 $10,755,800 $224,000 2.13% Page One 2013 BUDGET WORKSHEETS GENERAL FUND REVENUES September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget 101 31010.00 Current Ad Valorem Taxes $6,697,852 $7,013,792 $7,239,992 $7,043,946 $7,246,047 From County 101 31040.00 Fiscal Disparities 1,141,159 1,195,913 1,299,717 1,252,954 1,235,453 From County Total Taxes(Tax) 7,839,011 8,209,705 8,539,709 8,296,900 8,481,500 Total Property Tax Levy for Fund 101 0 0 State MVHC-Eliminated in 2012 8,296,900 8,481 500 Actual Property Taxes to Receive 101 32110.00 Alcoholic Beverage Licenses(L) 36,035 51,533 38,825 40,000 40,000 101 32160.00 Licenses to do Business(L) 8,430 10,455 5,880 8,000 7,000 Garbage Haulers,Ped Licenses,etc. 101 32162.00 Lic to do Business-Rental Housing(L) 1,345 15,337 4,010 13,000 4,000 101 32210.00 Building Permit Revenue(L) 281,984 272,975 249,558 200,000 230,000 101 32212.00 Mineral Extraction Permit(L) 1,480 1,110 1,070 1,200 1,200 101 32220.00 Electrical Permit Revenue(L) 13,238 13,555 16,467 13,000 13,000 101 32221.00 Admin Fee-Electrical Permits(L) 7,040 7,270 8,274 7,000 7,000 101 32230.00 Plumbing Permit Revenue(L) 30,058 26,250 29,795 30,000 30,000 101 32240.00 Animal Licenses(L) 2,663 2,397 2,491 2,500 2,500 101 32250.00 Sewer Permit Revenue(L) 6,585 12,891 5,325 7,000 7,000 101 32255.00 County Recording Fee-City's(L) 100 70 60 100 100 101 32260.00 HVAC Permit Revenue(L) 41,073 39,117 26,270 40,000 40,000 101 32290.00 Other Non-Bus Lic&Permits(L) 520 940 590 500 500 Alarm Permits&Fireworks Permits Total Licenses&Permits(L) 430,551 453,900 388,616 362,300 382,300 101 31010.00 Current Ad Valorem Taxes(I) 80,000 80,000 86,000 86,000 86,000 Included in Debt Levy Figure 101 31010.01 MSABC Armory Payments 86,000 101 31020.00 Delinquent Ad Valorem Taxes(I) 150,317 169,891 131,114 0 0 From County 101 31030.00 Mobile Home Taxes(I) 15,330 13,026 12,746 12,000 12,000 From County 101 31710.00 Gravel Taxes(I) 13,390 46,073 39,679 40,000 20,000 From County 101 31810.00 Franchise Taxes-Regular Fees(I) 185,886 193,997 199,067 190,000 200,000 From Cable Company 101 31811.00 Franchise Taxes-PEG Fees(I) 25,001 24,739 24,037 25,000 25,000 From Cable Company 101 31920.00 Forfeited Tax Sale Apportionment(I) 0 0 0 0 0 From County 101 33100.00 Federal Grants&Aids(I) 0 0 0 0 0 101 33416.00 Police Training Reimbursement(I) 145,036 147,975 152,637 150,000 From State 101 33416.01 Post Board Training Reimb 4,000 7,000 101 33416.02 State Aid(Tied to PERA) 140,000 143,000 101 33418.00 MSA for Streets-Maintenance(I) 30,165 30,165 30,165 30,000 32,600 From State 101 33423.00 Ag Preserves Credit(I) 659 1,484 1,007 700 1,000 From State 101 33425.00 Other State Grants&Aids(I) 44,537 31,087 38,277 25,000 30,000 From State-PERA Aid&Safe&Sober 101 33620.00 Other County Grants&Aids(I) 60,100 19,500 22,400 19,000 22,500 Dakota County Recycling Funds 101 33630.00 Police Services Levy-ISD#196(I) 64,603 67,284 62,242 62,800 64,000 101 33630.00 Liaison Funding 64,000 From ISD#196 Total Intergovernmental(I) 815,023 825,221 799,371 634,500 643,100 PAGE TOTALS 9,084,585 9,488,825 9,727,696 9,293,700 9,506,900 17 Page Two 2013 BUDGET WORKSHEETS GENERAL FUND REVENUES September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 34103.00 Zoning&Subdivision Fees(C) 28,215 33,310 31,865 35,000 32,000 101 34104.00 Plan Checking Fees(C) 89,352 89,313 71,774 80,000 75,000 101 34105.00 Sales of Maps&Publications(C) 517 364 377 500 500 Maps&Spec Books 101 34106.00 Deputy Registrar Fees(C) 8,731 0 0 0 0 Dakota County Took Over Feb.2009 101 34108.00 Admin Fees-Other Funds(C) 25,000 101 34108.01 Applicable Funds Except Const. 25,000 25,000 25,000 25,000 25,000 101 34108.02 Construction Funds 79,141 10,027 36,093 0 0 101 34109.00 Other Charges for Service(C) 7,074 6,286 3,981 6,000 4,000 101 34110.00 Service Chg on Returned Chks(C) 90 148 60 200 100 101 34112.00 Utility Permit Application Fee(C) 0 1,120 0 1,000 0 101 34113.00 Application Fees(C) 0 0 0 0 0 101 34150.00 User Fees-SKB(C) 128,745 112,314 74,655 120,000 120,000 SKB Fees-C&D Cell Fees 101 34151.00 User Fees/Host Agreements-SKB(C) 102,955 162,306 180,672 165,000 165,000 101 34151.00 Landscaping Agreement 25,000 Landscaping Agreement(Yr 10 of 10) 101 34151.00 Trust Fund-City Portion 140,000 101 34152.00 User Fees-SKB(C) 8,782 16,885 10,850 20,000 20,000 SKB Fees-MSW Ash Charges 101 34153.00 User Fees-SKB(C) 100,491 135,229 167,857 120,000 120,000 SKB Fees-Base Service Charges 101 34160.00 National Guard Maint Fees(C) 47,488 48,456 45,084 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) 18,199 15,160 25,322 19,000 19,000 Contractual O/T for Officers 101 34202.00 Fire Services-Burning Permits(C) 300 850 750 0 200 No Longer Charge for Permits 101 34203.00 Accident Reports(C) 0 25 43 0 0 101 34204.00 Day Care Inspection Fees(C) 350 500 150 200 200 101 34206.00 Other Police Services(C) 12,944 550 0 0 0 101 34207.00 Other Fire Protection Services(C) 15,700 21,043 20,209 19,000 101 34207.01 U of M Fire Contract 6,000 8,000 101 34207.02 Coates Fire Contract 10,000 10,000 101 34207.03 Other Billed Fire Calls 1,000 1,000 101 34303.00 Mow Weeds(C) 1,662 1,331 1,580 1,500 1,500 101 34304.00 Sweep/Plow Streets(C) 0 730 733 0 300 101 34306.00 Other Highway&Street Rev(C) 6,245 11,982 61,031 6,000 10,000 Street Light Bills-Developers 101 34310.00 Right-of-Way Permits(C) 4,934 4,715 3,146 4,000 3,400 101 34407.00 City Share of Metro SAC Chgs(C) 2,209 2,154 1,677 2,000 1,800 ---------- ---------------- ------------- --- Total Charges for Services(C) 689,124 699,796 762,906 668,400 663,000 101 35101.00 Court Fines(F) 121,618 113,675 123,245 125,000 125,000 From County Total Fines&Forfeits(F) 121,618 113,675 123,245 125,000 125,000 101 34718.00 Tournament Fees® 0 0 0 7,000 7,000 New Fee for 2012 101 34719.00 Player Maintenance Fees(R) 0 0 1,894 9,000 0 New Fee for 2011 101 34720.00 Park Reservations(R) 3,789 3,984 3,605 4,000 4,000 101 34721.00 Softball Revenues(R) 54,636 66,288 59,135 45,000 58,000 101 34724.00 Tennis Revenues(R) 2,016 2,490 1,710 2,400 2,100 101 34725.00 Tiny Tot Revenues(R) 13,674 5,934 0 0 0 Eliminated Program in 2010 101 34726.00 Rosettes Revenues(R) 1,625 1,974 2,150 1,600 2,100 101 34727.00 Field Trip Revenues(R) 1,000 1,200 101 34727.01 Youth/Teen Trips 799 0 450 200 101 34727.02 Adult/Senior Trips 3,897 1,384 791 1,000 101 34728.00 Adult Soccer League Revenues(R) 0 14,866 13,319 10,000 13,000 No League in 2009 101 34730.00 Run for the Gold Revenues(R) 4,659 4,527 4,956 4,600 4,600 101 34731.00 Youth Soccer Lessons(R) 3,648 4,011 3,782 4,000 3,700 101 34732.00 Adult Basketball Revenues(R) 1,870 2,147 1,400 2,000 1,400 101 34733.00 Other Programs Revenues(R) 13,981 20,298 21,064 20,000 20,000 101 34735.00 Camps Revenues(R) 15,960 19,571 20,000 19,000 19,000 101 34736.00 T-Ball Lessons(R) 5,092 5,887 4,330 6,000 4,500 101 38080.00 Banquet Room Fees(R) 60,413 55,435 60,124 60,000 60,000 101 38081.00 Auditorium Fees(R) 7,331 8,535 7,981 9,000 8,000 101 38082.00 Gymnasium Fees(R) 32,174 25,062 23,098 27,000 24,000 101 38086.00 Classroom Fees(R) 9,838 7,548 7,476 8,000 8,000 101 38096.00 Liquor Provider Fees(R) 900 540 630 800 800 101 38097.00 AN Rental Fees(R) 530 255 520 500 500 101 38154.00 Teen Night Revenues(R) 2,697 100 0 0 0 Eliminated Program in 2010 101 38201.00 Rental Revenues 0 6,575 19,750 10,500 18,000 Steeple Center Operations 101 38203.00 Rental Revenue-Churches 0 0 500 0 0 Steeple Center Operations 101 38205.00 AN Rental Revenues 0 0 428 500 500 Steeple Center Operations 101 38209.00 Miscellaneous Revenues 0 0 280 3,000 0 Steeple Center Operations 101 38211.00 Security Services 0 700 2,050 0 2,000 Steeple Center Operations 101 38301.00 Rental Revenues 0 0 0 0 750 Senior/Activity Center Operations 101 38305.00 AN Rental Revenues 0 0 0 0 50 Senior/Activity Center Operations Total Recreation Fees(R) 239,528 258,110 261,422 254,900 263,200 PAGE TOTALS 1,050,271 1,071,581 1,147,572 -1,048,300 1,051,200 ig Page Three 2013 BUDGET WORKSHEETS GENERAL FUND REVENUES September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 36101.00 Principal-Special Assessments(M) 10,803 9,450 9,244 1,000 1,000 From County-101 Funded Projects 101 36102.00 Penalties&Interest-S/A(M) 17 113 0 0 0 From County 101 36210.00 Interest Earnings-Investments(M) 180,401 165,773 189,675 140,000 170,000 101 36214.00 Net Change in FV-Investments(M) (8,113) (43,787) 5,947 0 0 Annual Market Value Changes 101 36215.00 Interest Earnings(M) 3,063 1,349 610 1,000 500 From Checking Account 101 36220.00 Rents&Royalties(M) 59,948 19,325 18,329 17,300 15,700 101 36220.01 Verizon Antenna Rent 12,700 101 36220.02 Athletic Complex Land Rental 3,000 Leasing Less Land 101 36220.03 MVTA-RCC Parking Lot Rental 0 Move to New Lot 101 36230.00 Contribution/Donations(M) 37,764 18,639 25,622 0 0 101 36260.00 Other Revenue(M) 40,497 98,882 2,785 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 20,000 0 Elections Balancing 101 38090.00 City Concessions(M) 4,846 4,903 5,295 5,000 5,000 Total Misc Revenues(M) 329,229 274,645 257,507 186,300 194,200 101 39202.00 101 39203.00 Contribution from Enterprises(T) 3,500 3,500 3,500 3,500 3,500 Arena-Building &Grounds Maint. Transfer From (T) 19,964 0 61,422 0 0 Funds Returned from Projects Total Transfers In(T) 23,464 3,500 64,922 3,500 3,500 PAGE TOTALS $352,693 $278,145 $322,429 $189,800 $197,700 FUND TOTALS $10,487,548 $10,838,551 $11,197,697 $10,531,800 $10,755,800 INTERNAL REVENUES $2,648,537 $2,628,847 $2,657,988 $2,234,900 $2,274,300 Grand Total Less: Ad Valorem &Fiscal Disparities /9 Page Four 2013 BUDGET WORKSHEETS GENERAL FUND REVENUES September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 34108.00 General Fund Admin Fees $25,000 $25,000 $25,000 $25,000 $25,000 101 34108.01 Fund 201 6,000 101 34108.02 Fund 202 2,500 101 34108.03 Fund 203 2,500 101 34108.04 Fund 206 2,500 101 34108.05 Fund 207 2,500 101 34108.06 Fund 605 1,000 101 34108.07 Fund 606 1,000 101 34108.08 Fund 607 1,000 101 34108.09 Fund 650 6,000 Admin Fees Breakdown Totals $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 .2 0 GENERAL FUND EXPENDITURES September 4,2012 2012 ADOPTED 2013 PROPOSED +/- CLASSIFICATIONS/DEPARTMENTS BUDGET BUDGET DIFFERENCE PERCENTAGE GENERAL GOVERNMENT Council $280,800 $252,700 ($28,100) -10.01% Administration 510,200 484,300 (25,900) -5.08% Elections 42,000 22,000 (20,000) -47.62% Finance 421,600 435,000 13,400 3.18% General Government 378,500 383,200 4,700 1.24% Community Development 898,400 904,600 6,200 0.69% Transfers-Arena Assistance 115,000 115,000 0 0.00% TOTAL GENERAL GOVERNMENT $2,646,500 $2,596,800 ($49,700) -1.88% PUBLIC SAFETY Police $3,061,700 $3,206,800 $145,100 4.74% Fire 377,500 437,000 59,500 15.76% --------------------- TOTAL PUBLIC SAFETY $3,439,200 $3,643,800 $204,600 5.95% PUBLIC WORKS Government Buildings $484,400 $540,500 $56,100 11.58% Fleet Maintenance 635,900 645,100 9,200 1.45% Street Maintenance 1,315,300 1,268,800 (46,500) -3.54% Parks Maintenance 764,700 738,900 (25,800) -3.37% TOTAL PUBLIC WORKS $3,200,300 $3,193,300 ($7,000) -0.22% PARKS&RECREATION Park&Rec-General $1,085,300 $1,129,500 $44,200 4.07% Park&Rec-Steeple Center 58,900 64,500 5,600 9.51% Park&Rec-Senior/Activity Center 0 14,000 14,000 100.00% Park&Rec-Revenue Producing Programs 101,600 113,900 12,300 12.11% TOTAL PARKS&RECREATION $1,245,800 $1,321,900 $76,100 6.11% GRAND TOTALS-GENERAL FUND $10,531,800 $10,755,800 $224,000 2.13% 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 2013 BUDGET WORKSHEETS COUNCIL September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41110 103.00 Salaries&Benefits $36,017 $35,761 $36,148 $36,000 $36,800 Salary,Taxes,PERA&Benefits 101 41110 01 225.00 Landscaping Materials 77,500 25,026 25,000 25,000 25,000 SKB Landscaping Agreement (Year 10 of 10) 101 41110 01 307.00 City Promotional Fees 19,400 101 41110 01 307.01 Newsletter 25,005 20,237 18,300 18,000 18,300 Reduce From 5 to 3 Newsletters 101 41110 01 307.02 Chamber of Commerce Directory 0 2,138 1,069 1,100 1,100 101 41110 01 307.03 Community Survey 20,000 0 0 0 0 101 41110 01 315.00 Special Programs 0 0 3,058 5,000 5,000 Promotions,Marketing,etc. 101 41110 01 319.00 Other Professional Services 13,000 101 41110 01 319.01 Education Reimbursement 11,473 6,067 15,243 8,000 12,000 101 41110 01 319.02 Intergovernmental Initiatives 0 903 0 1,000 1,000 101 41110 01 321.00 Telephone Costs 400 101 41110 01 321.01 Mayor's Pager 0 0 0 0 0 101 41110 01 321.02 Mayor's Cell Phone 378 378 375 400 400 101 41110 01 329.00 Other Communication Costs 2,760 252 0 500 500 Newspaper Ads/Open Houses 101 41110 01 331.00 Travel Expense 2,700 101 41110 01 331.01 NLC Conference 964 0 740 1,200 1,200 101 41110 01 331.02 Miscellaneous Travel 1,133 1,009 1,453 1,500 1,500 101 41110 01 433.00 Dues&Subscriptions 25,200 101 41110 01 433.01 LMC Dues 14,191 14,806 14,957 15,000 15,300 101 41110 01 433.02 AMM Dues 6,782 6,912 6,951 7,300 7,500 101 41110 01 433.03 Dak Cty Regional Chamber 1,302 (651) 30 800 800 101 41110 01 433.04 NLC Dues 2,978 1,489 1,549 1,600 1,600 101 41110 01 433.05 Miscellaneous Dues 0 140 0 0 0 101 41110 01 435.00 Books&Pamphlets 0 0 0 100 100 101 41110 01 437.00 Conferences&Seminars 6,700 101 41110 01 437.01 Registration&Hotel-LMC Conf 350 590 1,619 1,000 1,700 101 41110 01 437.02 Registration&Hotel-NLC Conf 2,768 0 3,249 4,000 4,000 101 41110 01 437.03 Miscellaneous Conferences 1,185 150 964 1,000 1,000 101 41110 01 439.00 Other Miscellaneous Charges 145 231 98 300 300 101 41110 01 598.00 Council Designated 3,257 18,935 271,718 95,000 109,000 2011-Assignment for Health Ins. 101 41110 01 598.01 Library Site Expenditures 1,788 0 0 0 0 101 41110 01 598.02 Future Capital Expenditures 0 0 0 0 0 101 41110 01 598.03 Salary&Benefit Contingency 0 0 0 50,000 0 Contingency for Negotiations 101 41110 01 599.00 Employee Recognition Costs 8,600 101 41110 01 599.01 Employee Recognition Costs 2,498 3,487 2,462 2,700 2,700 101 41110 01 599.02 Vending Machine Costs 4,063 3,406 4,358 3,500 3,500 Offset by Revenue from Machines 101 41110 01 599.03 Commemorations 723 1,044 1,118 800 1,200 101 41110 01 599.04 CommissionNolunteer Recognition 0 0 0 0 1,200 ---- ------------- ----- PAGE TOTALS $217,261 $142,309 $410,458 $280,800 $252,700 DEPARTMENT TOTALS $217,261 $142,309 $410,458 $280,800 $252,700 ca.3 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,g ty o p ance, 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 ty Council including the preparation, distribution and maintenance of City Council meeting documents. RECORDS MANAGEMENT • Provides for the preparation and maintenance of official records for the City including Council, Port Authority and Commission minutes. • Prepares and assures publication and posting of official notices. • Provides public information on ordinances, contracts and policies. • Administers the collection, storage and dissemination of data. • Provides for the maintenance, training and supervision of the digital document management system. RECEPTION • Provides General Government/City Hall reception administration. 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. aCC. ADMINISTRATION DEPARTMENT - Page 3 STAFFING • For 2013, the department will consist of four positions: • City Administrator • Assistant City Administrator • Communications Coordinator • City Clerk PERFORMANCE MEASURES Worker's Compensation Modification Factor 2007 2008 2009 2010 2011 2012 .83 .82 .86 .85 .90 n/a Turnover Rate of City Personnel 2007 2008 2009 2010 2011 2012 2.5% 2.5% 0.0% 2.5% 5.1% 0.0% (4 Months) Average Monthly Unique Views on City Website 2007 2008 2009 2010 2011 2012 6,683 8,444 6,368 7,005 6,555 7,162 (4 Months) n/a—Information Not Available acp Page One 2013 BUDGET WORKSHEETS ADMINISTRATION September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41320 101.00 Salaries&Benefits $393,980 $408,204 $426,536 $437,600 $410,500 Salary,Taxes,PERA&Benefits 101 41320 102.00 Full-Time Overtime 0 0 0 300 300 101 41320 103.00 Part-Time Salaries&Benefits 4,232 2,056 0 700 700 Temp Receptionist Coverage 101 41320 01 209.00 Other Office Supplies 0 94 0 300 300 Miscellaneous Purchases 101 41320 01 313.00 Temporary Service Fees 0 0 0 0 0 101 41320 01 319.00 Other Professional Services 0 0 0 0 0 101 41320 01 321.00 Telephone Costs 1,311 1,083 1,363 1,500 1,500 Administration Cell Phones 101 41320 01 331.00 Travel Expense 1,100 101 41320 01 331.01 NLC Conference 317 0 0 0 0 101 41320 01 331.02 ICMA Conference 0 422 274 600 600 101 41320 01 331.03 Miscellaneous Travel 348 325 448 400 500 101 41320 01 433.00 Dues&Subscriptions 2,400 101 41320 01 433.01 MCMA Dues 199 215 261 300 300 101 41320 01 433.02 MAMA Dues 45 45 0 50 50 101 41320 01 433.03 MCFOA Dues 35 35 35 50 50 101 41320 01 433.04 Munici-Pals 25 85 25 100 100 101 41320 01 433.06 ICMA Dues 741 1,716 1,742 1,800 1,800 101 41320 01 433.07 APMP Dues 45 90 30 100 100 101 41320 01 435.00 Books&Pamphlets 0 0 61 100 100 101 41320 01 437.00 Conferences&Seminars 6,500 101 41320 01 437.01 Registration&Hotel-LMC 200 500 709 800 800 101 41320 01 437.02 Registration&Hotel-MCMA 1,287 1,633 1,318 1,500 1,500 101 41320 01 437.04 Staff(1)Each 0 0 0 200 0 101 41320 01 437.05 Miscellaneous Seminars 955 240 (193) 300 300 ULI/Greening Initiatives 101 41320 01 437.06 Registration&Hotel-ICMA 0 2,306 2,059 2,500 2,500 101 41320 01 437.07 City Clerk Training 689 680 594 800 1,200 All MCFOA Events-MC 101 41320 01 437.08 Registration&Hotel-NLC 1,219 0 0 0 0 101 41320 01 437.09 Miscellaneous Meetings 309 6 209 200 200 101 41320 01 439.00 Other Miscellaneous Charges 295 0 0 100 100 101 41320 01 580.00 Other Equipment Purchases 536 841 214 900 500 PAGE TOTALS 406,766 420,574 435,687 451,200 424,000 cal Page Two 2013 BUDGET WORKSHEETS ADMINISTRATION September 4,2012 2012 2013 Object 2013 2009 2010 2011 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 558 597 1,704 500 600 101 41320 31 305.02 Employee Drug Testing 164 658 658 1,200 1,200 101 41320 31 306.00 Personnel Testing&Recruitment 0 0 0 0 0 101 41320 31 315.00 Special Programs 1,500 101 41320 31 315.01 Employee Training 1,178 212 1,066 1,000 1,000 101 41320 31 315.02 Health&Wellness 1,842 51 38 500 500 Wellness&Health Management 101 41320 31 319.00 Other Professional Services 3,800 101 41320 31 319.01 Labor Consultant 0 694 0 300 300 101 41320 31 319.02 Labor Legal Issues 2,835 0 0 700 700 101 41320 31 319.04 COBRA Consultant 692 624 692 800 800 101 41320 31 319.05 Flex/VEBA Administrative Fees 1,746 1,751 1,777 2,200 2,000 101 41320 31 319.06 SWWC Co-Operative Dues 0 0 0 0 0 101 41320 31 331.00 Travel Expense 188 313 343 400 400 101 41320 31 341.00 Employment Advertising 709 1,727 972 700 1,000 Vacancies 101 41320 31 433.00 Dues&Subscriptions 500 101 41320 31 433.01 "Future Use" 0 0 0 0 0 101 41320 31 433.02 IPMA Dues 145 145 149 200 200 101 41320 31 433.03 MPELRA Dues 345 290 150 300 300 101 41320 31 435.00 Books&Pamphlets 233 0 0 100 100 Books&Training Materials 101 41320 31 437.00 Conferences&Seminars 500 101 41320 31 437.01 MPELRA State Conference 315 0 300 300 300 101 41320 31 437.02 Personnel Seminars 107 300 74 200 200 101 41320 31 437.03 Safety,Supervisor,Policy 0 0 0 0 0 101 41320 41 315.00 Special Programs 0 0 0 1,000 101 41320 41 315.01 General Marketing 0 0 0 1,000 1,000 Special Mailings 101 41320 41 315.02 Historical Monuments 0 0 0 0 0 101 41320 41 319.00 Other Professional Services 2,356 1,043 3,600 101 41320 41 319.01 Website 0 0 1,100 1,100 3,600 101 41320 41 319.02 Website Improvements 0 0 10,000 0 0 101 41320 41 328.00 Cable Supply Costs 340 2 60 500 500 Cable Supplies,Software 101 41320 41 329.00 Other Communication Costs 0 0 0 44,300 101 41320 41 329.01 Cable JPA Payment-General City 42,823 41,998 42,902 43,000 44,300 101 41320 41 329.02 Video Streaming Council Mtgs 4,760 4,799 0 0 0 101 41320 41 329.03 Bulk E-Mail System 2,508 2,508 2,508 2,600 0 101 41320 41 331.00 Travel Expenses 60 40 25 200 100 101 41320 41 433.00 Dues&Subscriptions 120 200 60 100 100 MAGC 101 41320 41 437.00 Conferences&Seminars 75 0 0 100 100 Technical Courses 101 41320 41 580.00 Other Equipment Purchases 2,242 827 196 1,000 1,000 ------------ ------------- PAGE TOTALS $66,341 $58,779 $64,774 $59,000 $60,300 DEPARTMENT TOTALS $473,107 $479,353 $500,460 $510,200 $484,300 q2 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 2007 2008 2009 2010 2011 2012 1,578 1,671 1,836 1,807 1,871 1,891 (4 Months) n/a—Information Not Available gg Page One 2013 BUDGET WORKSHEETS ELECTIONS September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 41410 01 103.00 Part-Time Salaries $133 $20,755 $0 $35,000 $0 Election Judges 101 41410 01 203.00 Printed Forms&Paper 0 0 688 1,500 0 Ballots&Programming 101 41410 01 208.00 Miscellaneous Supplies 0 656 0 1,000 0 101 41410 01 219.00 Other Operating Supplies 0 236 0 300 0 Food for Election Judges 101 41410 01 242.00 Minor Equipment 0 192 0 1,000 0 Signs&Miscellaneous 101 41410 01 304.00 Legal Fees 0 2,017 0 0 0 101 41410 01 319.00 Other Professional Services 0 0 0 0 0 101 41410 01 321.00 Telephone Costs 0 0 0 0 0 101 41410 01 351.00 Legal Notices Publishing 0 0 0 0 0 Election Publications 101 41410 01 409.00 Other Contracted Repair&Maint 2,600 101 41410 01 409.01 Maintenance for AutoMarks 1,225 1,225 1,225 1,400 1,400 Voting Machines 101 41410 01 409.02 Maintenance forAccuvotes 1,000 1,000 1,000 1,200 1,200 Voting Machines 101 41410 01 412.00 Building Rental 0 0 0 0 0 Possible Rent for Locations 101 41410 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 101 41410 01 580.00 Other Equipment Purchases 600 638 0 600 19,400 PAGE TOTALS $2,958 $26,719 $2,913 $42,000 $22,000 DEPARTMENT TOTALS $2,958 $26,719 $2,913 $42,000 $22,000 3$CS 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. 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 workers comp insurance requirements, handles all property&liability claims and prepares documents for all yearly renewals of policies. 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 mailing and collection of all utility bills. Handles on the computer system, the preparation of final bills and the setup of new accounts. Fields and responds to utility billing questions and complaints. Compiles operating statistical information which is available to other departments as needed. ACCOUNTS PAYABLE • Processes purchase orders prepared by all departments, checking for accuracy and matching with invoices and all other supporting documentation so payments can be made in a timely manner. Also,prepares all checks and supporting reports that accompany each check run. Coordinates the review of bills by Council by providing applicable reports and supporting documentation. ACCOUNTS RECEIVABLE / CASH RECEIPTS • Prepares invoices for all departments for items/services that must be billed to outside sources. Maintains records that allow for the timely collection of invoiced items/services. Receipts monies on a daily basis and deposits those monies daily in designated banking institutions. Maintains a system that allows for the appropriate reporting of all monies collected within the accounting system. FINANCE DEPARTMENT - Page 3 FIXED ASSETS • Responsible for the maintenance of the fixed asset system. This includes all additions, deletions and changes in fixed assets for the City. It also includes the periodic physical reinventory of all current fixed assets. Also responsible for the corresponding reporting requirements that go along with the system, including year-end information,insurance renewal information and individual department information. SPECIAL ASSESSMENTS • Responsible for the maintenance of 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 2013, 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) 31 FINANCE DEPARTMENT - Page 4 PERFORMANCE MEASURES City Bond Rating 2007 2008 2009 2010 2011 2012 Aa3 Aa3 Aa3 Aa2 Aa2 Aa2 (10/1/07) (4/16/10) GFOA Certificate of Achievement Award Received 2007 2008 2009 2010 2011 2012 Yes Yes Yes Yes (Applied) n/a # Of Accounts Payable Checks Processed 2007 2008 2009 2010 2011 2012 3,098 3,081 3,326 3,179 3,263 n/a # Of Utility Bills Processed 2007 2008 2009 2010 2011 2012 29,000 (est.) 29,092 29,160 29,362 29,563 n/a n/a—Information Not Available 3Y{ Page One 2013 BUDGET WORKSHEETS FINANCE September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41520 101.00 Salaries&Benefits $284,536 $294,584 $303,823 $308,600 $318,500 Salary,Taxes,PERA&Benefits 101 41520 102.00 Full-Time Overtime 2,689 2,327 2,302 2,000 2,300 101 41520 103.00 Part-Time Salaries&Benefits 37,214 41,202 43,796 46,600 47,800 101 41520 01 321.00 Telephone Costs 659 1,245 1,293 1,300 1,400 Cell Phone Allowances(2) 101 41520 01 331.00 Travel Expense 1,300 101 41520 01 331.01 Finance Director 678 457 358 500 1,200 Miscellaneous(National Added) 101 41520 01 331.02 Staff 18 0 0 200 100 101 41520 01 391.00 P.C.Maintenance 46,600 101 41520 01 391.01 Civic Systems Applications Support 5,316 5,428 5,482 0 0 Moved to Utilities 101 41520 01 391.02 Citrix Maintenance Renewal 959 962 1,656 1,000 1,000 101 41520 01 391.03 Incode Software Maintenance 7,593 7,939 7,967 8,700 8,700 101 41520 01 391.04 General Network Support 25,000 20,000 20,000 20,000 20,000 190 Hours of Support Time 101 41520 01 391.06 Fixed Asset Maint Contract 1,383 1,384 1,384 1,400 1,400 101 41520 01 391.07 Miscellaneous Repairs&Maint. 2,697 902 1,793 2,500 2,500 101 41520 01 391.08 Anti-Virus Software Renewal 5,951 4,866 3,023 5,000 5,000 101 41520 01 391.09 File Server Software Maintenance 1,475 7,160 7,801 8,000 8,000 101 41520 01 392.00 P.C.Accessories&Supplies 3,478 3,383 3,565 4,000 4,000 City System Supplies 101 41520 01 393.00 P.C.Hardware Purchases 1,967 2,351 1,892 2,500 2,500 101 41520 01 394.00 P.C.Software Purchases 5,000 101 41520 01 394.01 Annual Microsoft Office Payment 9,811 9,846 0 0 0 Final Pymt 2010 Thru 2011 101 41520 01 394.02 Miscellaneous S/W Purchases 2,779 3,008 5,286 5,000 5,000 101 41520 01 409.00 Other Contracted R&M 165 165 180 200 200 Non-Computer Equipment 101 41520 01 433.00 Dues&Subscriptions 800 101 41520 01 433.02 MnGFOA-Finance Director 60 60 60 70 70 101 41520 01 433.03 MnGFOA-Staff 360 360 360 380 380 101 41520 01 433.04 GFOA-Finance Director&Asst. 335 340 340 350 350 101 41520 01 433.05 Magazine Subscriptions 0 0 0 0 0 101 41520 01 435.00 Books&Pamphlets 100 101 41520 01 435.01 Accounting Related Books 0 0 0 50 50 101 41520 01 435.02 Finance Related Books 0 0 0 50 50 101 41520 01 437.00 Conferences&Seminars 3,300 101 41520 01 437.02 MnGFOA Annual Conf(F/D&Ass't) 558 565 571 1,000 1,000 101 41520 01 437.03 GFOA National Conf(F/D) 1,437 0 0 0 1,500 Cut for 2011 &2012 101 41520 01 437.04 Staff Development 125 218 0 500 400 101 41520 01 437.05 Miscellaneous Seminars 245 652 292 500 400 101 41520 01 439.00 Other Miscellaneous Charges 220 151 114 200 200 Contingencies 101 41520 01 570.00 Office Equipment&Furnishings 889 910 969 1,000 1,000 PAGE TOTALS $398,596 $410,465 $414,308 $421,600 $435,000 DEPARTMENT TOTALS $398,596 $410,465 $414,308 $421,600 $435,000 NOTE: Proposed making P/T Clerk Position F/T 3g 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 eneral office supplies utilized by all departments. g City y a �' p EQUIPMENT PARTS • Provides for the maintenance and repair of general office equipment. AUDITING & ACCOUNTING SERVICES • Provides for the annual audit of the City's accounting transactions for all funds of the City and for the preparation of the Comprehensive Annual Financial Report. Also provides for other services as required of the City's financial and accounting consultants. LEGAL FEES • Provides for general legal and special legal services provided by the City Attorney or other law firms utilized by the City for such services. GENERAL GOVERNMENT - Page 2 OTHER PROFESSIONAL SERVICES • Provides for the administration costs of the City's code updates, code web fees, annual updates to the user fee study,preparation of the State building report and continuing disclosure fees. TELEPHONE COSTS • Provides for the costs of the City's telephone system, monthly service fees,long distance calls and miscellaneous installation costs. Also,provides for fees associated with the City's e-mail and web services. POSTAGE COSTS • Provides for postage costs for all departments and maintenance agreements for the postage machine and postage allocator. OTHER TRANSPORTATION EXPENSES • Provides for two-year renewals of City vehicle license plates, emission fees and duplicate plates, titles or tags,if needed. LEGAL & GENERAL NOTICES PUBLISHING • Provides for the publication of legal documents from all departments except when publication costs are charged to specific projects. LEASE AGREEMENTS • Provides for leasing of copy machines and other office machines at City Hall, Community Center and the Police Department. 37 Page One 2013 BUDGET WORKSHEETS GENERAL GOVERNMENT September 4,2012 2012 2013 Object 2013 2009 2010 2011 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 8,973 40 0 0 0 Moved to"391.00"Below 101 41810 01 202.02 Copying Costs 10,632 13,747 12,453 14,000 14,000 101 41810 01 203.00 Printed Forms&Paper 11,000 101 41810 01 203.01 Copy Paper 5,678 4,328 6,811 8,000 7,000 101 41810 01 203.02 General Receipt Books 0 0 800 800 800 101 41810 01 203.03 Purchase Orders 0 0 1,707 1,700 1,700 101 41810 01 203.04 Payroll&A/P Checks 339 394 326 1,500 500 101 41810 01 203.06 Miscellaneous Forms 986 180 735 1,000 1,000 Business Cards,etc. 101 41810 01 204.00 Envelopes&Letterheads 4,700 101 41810 01 204.01 Letterhead 528 784 1,223 2,000 1,200 101 41810 01 204.02 Plain Envelopes 1,850 1,587 0 1,800 1,800 101 41810 01 204.03 NP&Payroll Envelopes 0 454 766 500 500 101 41810 01 204.04 10 x 13 Envelopes 0 0 1,202 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 18,015 14,605 14,288 19,000 16,000 General Office Supplies 101 41810 01 221.00 Equipment Parts 55 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 0 300 300 $500-$700 for One Terminal 101 41810 01 301.00 Auditing&Accounting Services 72,000 101 41810 01 301.01 Audit&General Consulting Fees 62,929 56,045 59,383 68,000 64,000 101 41810 01 301.02 Dakota County Assessment Fees 4,085 4,389 5,456 5,000 6,000 101 41810 01 301.03 Dak Cty Truth In Taxation Costs 1,841 1,913 1,860 2,000 2,000 101 41810 01 303.00 Engineering Fees 1,251 8,163 5,402 0 0 101 41810 01 304.00 Legal Fees 78,235 55,007 60,931 80,000 80,000 General City Legal Fees 101 41810 01 319.00 Other Professional Services 32,300 101 41810 01 319.01 City Code Update 2,375 1,495 2,568 2,500 2,500 101 41810 01 319.02 City Code Web Fees 0 0 0 300 300 101 41810 01 319.03 State Building Report(Springsteds) 6,120 4,995 4,703 6,000 6,000 Fees Paid to Springsted 101 41810 01 319.04 Continuing Disclosure Fees 3,607 3,621 4,321 4,000 4,500 Fees Paid to Springsted(Bonds) 101 41810 01 319.05 Annual User Fee Study Update 14,128 5,370 5,710 7,000 7,000 Fees Paid to Springsted 101 41810 01 319.06 Arbitrage/Rebate Calculations 1,305 10,855 15,750 7,000 7,000 Fees Paid to Springsted(Bonds) 101 41810 01 319.10 UMore Professional Services 11,465 30,816 12,868 5,000 5,000 101 41810 01 320.00 Credit Card Activity Fees 24,000 101 41810 01 320.01 Utilities'Fees 1,299 1,474 1,675 1,500 1,700 101 41810 01 320.02 Parks&Recreation Fees 4,760 5,437 5,692 4,800 6,000 101 41810 01 320.03 Building Fees 14,212 12,095 16,319 15,000 15,000 101 41810 01 320.04 General Fees 693 814 1,258 700 1,300 101 41810 01 321.00 Telephone Costs 46,100 101 41810 01 321.01 General Phone Costs(&Internet) 63,179 42,188 43,928 39,000 39,000 101 41810 01 321.02 Domain Housing 0 60 60 100 100 101 41810 01 321.03 Software Maintenance Costs 0 0 0 5,500 7,000 Added Additional Licenses 101 41810 01 322.00 Postage Costs 17,756 16,705 16,344 23,000 17,000 101 41810 01 339.00 Other Transportation Expenses 74 802 221 800 800 Vehicle Licensing 101 41810 01 351.00 Legal Notices Publishing 3,800 101 41810 01 351.01 Costs for Public Notices 2,202 2,475 2,564 3,000 3,000 All Departments 101 41810 01 351.02 Truth in Taxation Notices 0 0 0 600 300 Newspaper Notice Publication 101 41810 01 351.03 Budget&Audit Publications 549 123 457 200 500 State Mandated Publications 101 41810 01 391.00 P.C.Maintenance 0 9,476 9,745 12,000 15,500 Laserfishe Maintenance 101 41810 01 392.00 P.C.Software Purchases 0 11,414 0 0 4,900 Laserfishe Software 101 41810 01 393.00 P.C.Hardware Purchases 0 2,200 0 3,200 4,300 Scanner Purchase 101 41810 01 433.00 Dues&Subscriptions 773 867 956 1,000 1,000 Newspapers 101 41810 01 439.00 Other Miscellaneous Charges 269 250 270 500 500 Direct Deposit Filing Fees/Flex 101 41810 01 450.00 Sales Tax on Purchases 0 9,829 0 0 0 Sales Tax Audit 101 41810 01 580.00 Other Equipment Purchases 31,889 33,414 33,304 29,000 35,000 Office Machine Leases-All Bldgs. PAGE TOTALS $372,052 $368,411 $352,051 $378,500 $383,200 DEPARTMENT TOTALS $372,052 $368,411 $352,051 $378,500 $383,200 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. 39 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. `I0 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. '1l COMMUNITY DEVELOPMENT - Page 4 PERFORMANCE MEASURES Planning Application Processed Within 60 Days 2007 2008 2009 2010 2011 2012 86% 87% 86% 92% 83% 78% Requested Inspections Completed Within One Day 2007 2008 2009 2010 2011 2012 n/a n/a 100% 100% 100% 100% Residential Plan Reviews Fully Completed Within 10 Working Days 2007 2008 2009 2010 2011 2012 n/a n/a 90% 90% 86% 87% Code Complaints Resolved 2007 2008 2009 2010 2011 2012 98% 95% 99% 99% 99% 44% Existing Businesses Visited 2007 2008 2009 2010 2011 2012 n/a n/a 31 31 24 1 n/a—Information Not Available All 2012 figures are estimates for the first 4 months of the year. VI Page One 2013 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41910 101.00 Salaries&Benefits $878,708 $870,501 $827,265 $864,300 $872,500 Salary,Taxes,PERA&Benefits 101 41910 102.00 Full-Time Overtime 0 1,695 1,020 1,000 1,000 101 41910 99 103.00 Part-Time Salaries&Benefits 2,024 1,485 2,932 4,500 4,500 Planning Commission Members 101 41910 01 201.00 Office Accessories 521 0 0 0 0 Calendars,Planners,etc. 101 41910 01 202.00 Duplicating&Copying 7,306 1,990 2,234 2,500 2,500 101 41910 01 203.00 Printed Forms&Paper 529 2,640 765 3,500 1,500 Forms,Stickers,Tags,etc. 101 41910 01 205.00 Drafting Supplies 0 0 0 0 0 101 41910 01 208.00 Miscellaneous Supplies 998 89 106 0 0 101 41910 01 209.00 Other Office Supplies 180 438 232 600 600 Dictation Devices&Tapes 101 41910 01 219.00 Other Operating Supplies 2,176 1,397 1,110 1,500 1,500 101 41910 01 241.00 Small Tools 344 191 30 200 200 Inspectors'Tools 101 41910 01 302.00 Architects'Fees 0 0 0 0 0 101 41910 01 319.00 Other Professional Services 299 5 0 1,000 1,000 Consultant 101 41910 01 329.00 Other Communication Costs 2,327 2,078 1,871 2,500 2,500 Cell Phones&Pagers 101 41910 01 331.00 Travel Expense 6 273 350 600 600 101 41910 01 391.00 P.C.Maintenance 2,016 2,124 2,190 4,200 4,200 Permitworks Support 101 41910 01 392.00 P.C.Accessories&Supplies 0 0 0 300 300 101 41910 01 393.00 P.C.Hardware Purchases 0 0 0 0 0 101 41910 01 433.00 Dues&Subscriptions 3,300 101 41910 01 433.01 APA/AICP 1,209 1,360 1,390 1,500 1,500 101 41910 01 433.02 ICC 260 200 100 200 200 101 41910 01 433.03 AMBO 275 50 300 300 300 101 41910 01 433.04 10,000 Lakes 325 0 150 150 150 101 41910 01 433.05 "Future Use" 0 0 0 0 0 101 41910 01 433.06 Trade Magazines 0 85 85 200 200 101 41910 01 433.07 Planner's Journal 0 0 0 0 0 101 41910 01 433.08 Sensible Land Use Coalition 0 0 0 300 300 101 41910 01 433.09 AACEO/MARCO 25 35 0 100 100 101 41910 01 433.10 Other Dues&Subscriptions 3,398 588 269 550 550 101 41910 01 435.00 Books&Pamphlets 631 452 549 700 700 Manuals,References,IBC Books . 101 41910 01 437.00 Conferences&Seminars 7,300 101 41910 01 437.01 State Bldg Official School 550 421 365 550 550 101 41910 01 437.02 Spring&Fall Code Updates 150 255 400 400 400 101 41910 01 437.03 Building Inspector Training 619 1,040 669 1,000 1,000 101 41910 01 437.04 Computer Training 0 0 0 200 200 101 41910 01 437.05 Clerical Seminars 0 0 0 300 300 101 41910 01 437.06 Planning Seminars 110 268 328 2,000 2,000 101 41910 01 437.07 ISIS Training 500 426 150 500 500 101 41910 01 437.08 State Planning Conference(2) 1,665 0 1,258 1,400 1,400 101 41910 01 437.09 Planning Commissioner Training 32 48 82 200 200 101 41910 01 437.10 Gen'I Seminars 1,667 40 150 300 300 101 41910 01 437.11 Code Enforcement Training 290 146 44 450 450 101 41910 01 439.00 Other Miscellaneous Charges 120 100 0 400 400 Contingencies PAGE TOTALS $909,262 $890,419 $846,393 $898,400 $904,600 DEPARTMENT TOTALS $909,262 $890,419 $846,393 $898,400 $904,600 `13 POLICE DEPARTMENT The Department provides police services through its staff on a 24/7/365 basis. Staffing levels have grown along with the community and services have been enhanced and expanded as the additional staffing has been added. Specific functions completed within the Department include: ADMINISTRATION AND MANAGEMENT This budget provides for the overall planning, coordination and management of personnel and administration of activities within the Police Department. This includes the collection,preparation and filing of crime data and miscellaneous reports with the State of Minnesota;preparation and oversight of the operating and capital improvements budgets; and strategic planning for the future needs of the Department and the community. PATROL This is the most visible function of the Department. Patrol officers are recognized in the community because of their uniforms and marked police squads. They also are the first responders to calls for service—regardless of whether it is a medical response, motor vehicle crash or a criminal act. The overall goal of the patrol officers is the protection of life and property and the creation of a sense of security in the community. This is accomplished through visible patrolling, the enforcement of traffic laws, the arresting of criminal offenders and the delivery of other non-emergency services. CRIMINAL INVESTIGATION Patrol officers and detectives are responsible for the investigation of criminal incidents through the gathering, analysis and presentation of evidence and testimony. Investigations that are more complex or cross municipal boundaries are coordinated by the detectives. This is accomplished by working cooperatively with other police agencies, the County Attorney's Office, Child Protection,victim services and other federal and state law enforcement agencies. CRIME PREVENTION AND COMMUNITY EDUCATION PROGRAMS A significant effort is made by the police department to inform residents of crime within the community, methods that citizens can take to help prevent crimes and building relationships with community members. While these objectives are part of each officers' daily responsibilities, there are specific programs that are frequently associated with community policing and that emphasize the need for the police and citizens to work together to prevent criminal activity and reduce the opportunities for criminals to commit crimes. y�f POLICE DEPARTMENT - Page 2 • School Liaison- Officers serve as a liaison to the Rosemount Middle and High Schools. One officer is assigned full-time to the High School and a second officer spends one- quarter time at the Middle School. The liaison officers investigate criminal incidents that occur at the schools or that involve students at the schools. In addition, the liaisons work with the school staff to enhance the safety and security for both staff and students. Presentations on a variety of topics are made by the liaison to classes at all grade levels. The Middle School officer also spends time at each of the elementary schools,working with staff on any issues and making presentations in classes. • Community Education- In order to work together with the community,police must share information concerning criminal activity and crime prevention with the community. Officers are available to make presentations to community groups and organizations on a variety of topics. In addition, officers provide prevention tips to persons on a daily basis whom report criminal activity. Several events are also held throughout the year in an effort to build relationships with the residents and business persons. These include National Night Out block parties and gatherings, Neighborhood Watch meetings and Public Safety in the Park events. • Reserve Officer Program—Reserve officers are volunteers whom supplement the staff of sworn officers of the Department. The reserve officers are utilized to handle traffic and crowd control duties during city festivals and celebrations or emergencies, such as hazardous materials spills or leaks, damage resulting from tornadoes or other severe weather and major criminal incidents. Reserve officers patrol on some evenings and handle service calls, for example, assisting stalled motorists and animal complaints. They are also utilized regularly to provide crime prevention information to citizens at community events or through other programs. • Chaplain Program—The Police Chaplains are used by officers to assist in a variety of situations in which individuals or families are having difficulties. Chaplains are able to provide support to persons that are experiencing stress as a result of the death of a loved one, marital or family problems, financial struggles or any other event. By utilizing the chaplains to console and counsel persons in crisis, police officers are able to get back to other duties,while the chaplains are able to remain with the persons involved in the crisis. ANIMAL CONTROL The Police Department is responsible for the enforcement of ordinances related to the control and care of domestic animals. These tasks are mainly handled by Community Service Officers. Their duties include the licensing of dogs 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. 7c POLICE DEPARTMENT - Page 3 CODE ENFORCEMENT The Police Department assists the Community Development Department with code enforcement of city ordinances related to property maintenance and outside storage. The Department's Community Service Officers primarily handle this effort. Property owners that are observed to be in violation of an ordinance are notified of the violation and given an explanation of how to remedy the violation. The enforcement of city ordinances is important to maintain community standards,which help the City attain its mission of providing a safe, healthy and pleasant community. EMERGENCY MANAGEMENT The City has an all-hazards emergency plan and the Chief of Police serves as the City's emergency manager. The emergency manager is responsible for the development of emergency plans in the event of a chemical, technical or natural disaster in the community, e.g. tornado, flooding or hazardous materials release. PERFORMANCE MEASURES Number of Licensed Officers per 1,000 Residents 2007 2008 2009 2010 2011 2012 .97 .98 .97 .99 .99 n/a Number of Non-licensed Employees per 1,000 Residents 2007 2008 2009 2010 2011 2012 .21 .20 .20 .20 .20 n/a Number of Car Crashes with Personal Injury Resulting 2007 2008 2009 2010 2011 2012 33 30 45 30 23 n/a y t0 POLICE DEPARTMENT — Page 4 Part I Crimes (**) 2006 2007 2008 2009 2010 2011 Total # 467 428 398 411 334 336 Reported Rate per 2578 2196 1860 1872 1513 1469 100,000 Part II Crimes (**) 2006 2007 2008 2009 2010 2011 Total# 858 1020 952 809 686 719 Reported Rate per 4737 5248 4450 3686 3109 3143 100,000 Case Clearance Rate of Reported Crimes (Percent Solved) 2006 2007 2008 2009 2010 2011 57% 61% 62% 53% 52% 54% DWI Arrests 2006 2007 2008 2009 2010 2011 Number 170 251 236 141 101 106 of Arrests Rate per 938 1291 1291 642 457 463 100,000 Night to Unite (National Night Out) Neighborhood Parties 2006 2007 2008 2009 2010 2011 Number 34 25 31 36 25 33 of Events Response Time to Priority 1 Calls for Service (**) 2006 2007 2008 2009 2010 2011 6.00 5.97 6.38 6.22 6.24 6.75 (**) —Required Performance Measures for State Program n/a—Information Not Available 17 Page One 2013 BUDGET WORKSHEETS POLICE September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments - All Salary Costs Inclusive of - 101 42110 101.00 Salaries&Benefits $2,263,404 $2,342,838 $2,356,994 $2,380,900 $2,470,900 Salary,Taxes,PERA&Benefits 101 42110 102.00 Full-Time Overtime 79,326 66,069 75,223 70,000 70,000 101 42110 102.01 Regular Overtime Hours 51,000 101 42110 102.02 Contracted 011 19,000 101 42110 103.00 Part-Time Salaries&Benefits 111,000 101 42110 22 103.00 Part-Time Receptionist(2) 41,681 37,691 50,322 51,800 53,000 2 P/T Receptionists-44 Hrs/ Wk 101 42110 22 103.00 Part-Time Secretary 11,989 16,025 14,530 19,000 19,000 P/T Secretary-14 Hours/Wk 101 42110 99 103.00 Part-Time CSO's 28,447 35,777 33,759 39,000 39,000 CSO's-Up To 50 Hours/Wk 101 42110 01 202.00 Duplicating&Copying 0 0 0 0 0 101 42110 01 203.00 Printed Forms&Paper 762 846 975 1,200 1,200 Evid.Logs,Animal Lic,E-Tickets 101 42110 01 204.00 Envelopes&Letterheads 103 0 388 200 200 Business Cards 101 42110 01 207.00 Training&Instructional Supplies 11,100 101 42110 01 207.01 Practice Ammunition 4,654 4,739 4,963 5,000 5,000 101 42110 01 207.02 Service Ammunition 7,046 0 546 1,000 1,000 101 42110 01 207.03 Other Supplies 0 0 27 100 100 101 42110 01 207.04 M.A.A.G.Ammunition 0 4,322 4,920 5,000 5,000 101 42110 01 208.00 Miscellaneous Supplies 0 Donated&Forfeited Funds 101 42110 01 208.01 DARE Donations 2,078 2,409 156 0 0 101 42110 01 208.02 Equipment Donations/Forfeitures 10,224 7,279 6,875 0 0 101 42110 01 209.00 Other Office Supplies 826 1,019 245 1,000 1,000 Video,CD's&Miscellaneous 101 42110 01 211.00 Cleaning Supplies 500 101 42110 01 211.01 Blanket Cleaning 0 0 0 0 0 101 42110 01 211.02 Squad Interior Cleaning 124 621 321 500 500 101 42110 01 217.00 Clothing Allowance 2,500 101 42110 01 217.01 CSO's 790 269 1,661 750 750 101 42110 01 217.02 Reserves 0 1,299 550 1,000 1,000 101 42110 01 217.03 Other Supplies 1,304 289 1,860 750 750 101 42110 01 219.00 Other Operating Supplies 3,000 101 42110 01 219.01 Evidence Bags,Drug Kits,Misc. 1,361 2,190 983 2,000 2,000 101 42110 01 219.02 Accurint Database Services 626 859 871 1,000 1,000 101 42110 01 221.00 Equipment Parts 2,048 2,457 3,199 3,000 3,000 Squad Emergency Equip Repairs 101 42110 01 241.00 Small Tools 3,500 Crime Scene Kit Supplies 101 42110 01 241.01 Evidence Processing Equipment 558 682 1,084 750 750 101 42110 01 241.02 Camera and Video Supplies 1,163 430 1,140 2,000 2,000 Squad Camera Maintenance 101 42110 01 241.03 Other Supplies 1,000 395 407 750 750 Digital Recorders 101 42110 01 242.00 Minor Equipment 1,500 101 42110 01 242.01 Less Lethal Tactical Equipment 658 1,177 937 1,000 1,000 Training Supplies,Taser Batteries 101 42110 01 242.02 MAAG Equipment 500 667 688 500 500 101 42110 01 304.00 Legal Fees 56,499 56,652 57,780 60,000 61,200 Prosecution 101 42110 01 305.00 Medical&Dental Fees 2,000 101 42110 01 305.01 Physicals 478 380 380 1,000 1,000 101 42110 01 305.02 Seized Narcotic Testing 1,429 761 427 1,000 1,000 Blood Draws 101 42110 01 306.00 Personnel Testing&Recruitment 868 0 1,329 1,000 1,000 Medical&Psychological 101 42110 01 313.00 Temporary Service Fees 106 764 14 800 800 Interpreter Services 101 42110 01 315.00 Special Programs 0 0 0 0 0 101 42110 01 316.00 Animal Care Services 3,000 101 42110 01 316.01 Impound&Care Fees 11,240 12,226 7,632 3,000 3,000 101 42110 01 316.02 "Future Use" 0 0 0 0 0 101 42110 01 319.00 Other Professional Services 342,100 101 42110 01 319.01 Dispatch Services-Operations 338,412 297,671 307,043 292,700 338,400 101 42110 01 319.02 Policy Development&Training 0 0 6,850 3,700 3,700 101 42110 01 321.00 Telephone Costs 5,400 101 42110 01 321.01 Cell Phones 5,225 5,953 5,137 5,400 5,400 101 42110 01 321.03 "Future Use" 0 0 0 0 0 101 42110 01 323.00 Radio Units 13,700 101 42110 01 323.01 Radios 9,213 9,648 10,674 11,500 11,500 800 MHz Subscriber Fees 101 42110 01 323.02 Radars 520 831 0 500 500 Radar&LIDAR Repairs 101 42110 01 323.03 Radio Warranty 0 0 0 0 1,700 Warranty Radio 101 42110 01 331.00 Travel Expense 4,500 101 42110 01 331.01 MN Chiefs Spring Conference 387 297 271 500 500 101 42110 01 331.02 IACP Conference 0 0 0 0 2,000 101 42110 01 331.03 Outstate Investigations&Conf. 430 117 352 500 500 101 42110 01 331.04 MAAG Conference 733 201 380 600 600 101 42110 01 331.05 CAN-AM Narcotic Conference 245 285 318 300 300 101 42110 01 331.06 Juvenile Officers Conference 785 210 440 500 500 101 42110 01 331.07 Meeting Reimbursements 48 130 139 100 100 PAGE TOTALS 2,887,289 2,916,475 2,962,788 2,971,300 3,113,100 qjr Page Two 2013 BUDGET WORKSHEETS POLICE September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 42110 01 333.00 Freight&Express Expenses 38 110 13 200 200 Repairs 101 42110 01 394.00 P.C.Software Purchases 6,300 101 42110 01 394.01 Automated Pawn System 240 240 204 300 300 101 42110 01 394.02 Pictometry 1,388 1,193 1,538 0 0 In Public Works Budget 101 42110 01 394.03 CJIIN System 10,474 10,474 11,610 6,000 6,000 101 42110 01 396.00 Computer Maintenance 67,000 101 42110 01 396.01 Records Management 35,188 32,172 33,120 34,000 34,700 101 42110 01 396.02 CJDN Connection Charges 3,443 3,904 2,520 2,800 2,800 101 42110 01 396.03 MCD Connection Charges 1,620 1,744 1,845 2,000 2,000 101 42110 01 396.04 MCD Maintenance&Cellular 18,647 17,316 18,432 18,600 19,000 101 42110 01 396.05 LOGIS Annual Fees 2,779 7,763 7,890 8,200 8,500 101 42110 01 433.00 Dues&Subscriptions 6,500 101 42110 01 433.01 Multi-Agency Assistance Group-MAAG 3,200 3,200 3,200 5,000 5,000 101 42110 01 433.02 IACP Chiefs 120 120 170 125 175 101 42110 01 433.03 MN Chiefs of Police 215 265 265 265 265 101 42110 01433,04 Dakota Cty Chiefs of Police 0 35 0 50 50 101 42110 01 433.05 Wakota CAER 0 0 0 0 0 101 42110 01433.06 Metro Emergency Managers 0 0 0 0 0 101 42110 01 433.07 MN Sex Crimes Investigators 0 0 0 20 20 101 42110 01 433.08 Tri-County Investigators 50 50 50 50 50 101 42110 01 433.09 MN Crime Prevention Association 0 60 0 65 65 101 42110 01 433.10 P.O.S.T.Licenses 1,080 720 360 900 700 101 42110 01 433.11 FBI Nat'l Academy Association 0 0 0 0 0 101 42110 01 433.12 Miscellaneous 75 155 35 125 175 101 42110 01 435.00 Books&Pamphlets 238 281 0 1,000 1,000 Crime Prevention Materials 101 42110 01 436.00 Towing Charges 0 0 168 200 200 Disabled Squads 101 42110 01 437.00 Conferences&Seminars 12,000 101 42110 01 437.01 Firearms-Range 2,085 988 2,113 2,000 4,000 Range Rental 101 42110 01 437.02 Chiefs Spring Conference 420 325 420 500 500 101 42110 01 437.03 Investigations 1,710 731 921 1,700 1,200 101 42110 01 437.04 IACP Conference 0 0 0 0 300 101 42110 01 437.05 Supervision 480 675 25 500 500 101 42110 01 437.06 Use of Force 1,750 750 2,380 900 1,000 101 42110 01 437.07 Emergency Driving 2,740 420 1,730 1,000 1,000 101 42110 01 437.08 First Aid 950 0 400 300 400 101 42110 01 437.09 Narcotic Enforcement 100 100 100 200 200 101 42110 01 437.10 Tactical 1,320 280 1,450 1,000 1,000 101 42110 01 437.11 Support Services 15 1,017 123 200 200 101 42110 01 437.12 Patrol Ops. 105 3,325 820 1,500 1,500 101 42110 01 437.13 Emergency Management 0 0 0 200 200 101 42110 01 439.00 Other Miscellaneous Charges 476 1,188 187 500 500 Refreshments for Meetings& Compliance Checks 101 42110 01 580.00 Other Equipment Purchases 0 0 0 0 0 -------------------------------- --- --- --- PAGE TOTALS $90,947 $89,600 $92,090 $90,400 $93,700 DEPARTMENT TOTALS $2,978,235 $3,006,075 $3,054,877 $3,061,700 $3,206,800 yCi FIRE DEPARTMENT MISSION / VISION / GOALS The Rosemount Fire Department's mission is an intricate component of the overall mission of the City of Rosemount in that the Fire Department is dedicated to the saving of life and property. This component which the Fire Department provides compliments and provides a necessary service so that the City may reach its broader mission of providing a safe, healthy and pleasant community in which to live and work. This service is provided by a paid-on-call department,which is the most fiscally sound method of delivery at this point in the City of Rosemount's development. The Rosemount Fire Department enhances the overall vision that is set for the City of Rosemount in that it provides the opportunity for individuals to demonstrate their pride in the community by serving on a "volunteer" fire department and assisting their neighbors. The "volunteer" Fire Department has historically been associated with the kind of small town character that Rosemount is striving to maintain. ADMINISTRATIVE / MANAGEMENT • Provides for the overall administration and management of the Fire Department. Included is the collection, preparation and dissemination of information; the preparation of operating budgets,Capital Improvement Projects (CIP) budgets and state reports; and planning for the long and short term needs with respect to training, fire protection, emergency medical response, facilities, staffing and the acquisition and maintenance of equipment,along with the coordination of efforts between other emergency response agencies and those of the City of Rosemount. FIRE SUPPRESSION / INVESTIGATION • Provides for the controlling and extinguishing of all types of fires in order to minimize injury, loss of life and loss of property within the City of Rosemount,both to its citizens and visitors. • Provides for the controlling and extinguishing of all types of fires in order to minimize injury,loss of life and loss of property within the contracted areas of Coates and the University of Minnesota, along with the railroad right-of-ways. • Provides for the provision of all of these fire services to all the cities of Dakota County and many of the cities of Washington County via a mutual aid agreement by which these services can be reciprocated on an as needed basis. FIRE DEPARTMENT — Page 2 • Provides for the investigation of fires by the local Fire Marshal. Also provides for the coordination of joint investigations by the local Fire Marshal and the State Fire Marshal. RESCUE SQUAD • Provides for emergency operations pertaining to bodily injury or serious illness requiring emergency services within the City of Rosemount,both to its citizens and visitors. • Provides for emergency operations pertaining to bodily injury or serious illness requiring emergency services within the contracted areas of Coates and the University of Minnesota. • Provides for the provision of all of these emergency operations to all the cities of Dakota County and many of the cities of Washington County via a mutual aid agreement by which these services can be reciprocated on an as needed basis. HAZARDOUS MATERIAL RESPONSE / CONFINED SPACE RESPONSE • Provides a team of Operations Level,Technician Level and Specialists, trained to respond to hazardous material accidents,identify, secure and coordinate the efforts of outside agencies that are trained to contain, mitigate and clean up the spill. • Trains all firefighters to respond to confined space incidents, evaluate the situation and mitigate or coordinate the rescue effort. TRAINING / EDUCATION • Provides for the necessary monthly and annual training requirements. • Allows for training in areas above those that are required,in order that fire and rescue personnel may sharpen existing skills and acquire new skills. • Allows for training of fire fighters to prepare themselves for the acceptance of a position of leadership within the Fire Department. FIRE DEPARTMENT — Page 3 HEALTH TESTING • Provides for the screening and medical certification of potential new fire fighters. • Allows for the continuous health monitoring of existing personnel. • Provides for the protection of personnel from blood-borne pathogens and communicable disease. EQUIPMENT / MAINTENANCE • Allows for the replacement or addition of equipment necessary for fire and medical response,including both consumable and nonconsumable items. • Provides for the emergency contracting with outside providers for repairs of fire vehicles and specialized equipment. STAFFING • In 2012, the Fire Department consisted of 41 paid on-call firefighters serving in various capacities within the department. This number is constantly changing due to retirements and new additions. We have 7 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. PERFORMANCE MEASURES Total Number of Paged Calls 2007 2008 2009 2010 2011 Fire n/a 229 303 298 288 Medical n/a 540 329 332 402 Average Response Time: High Priority Calls (**) 2007 2008 2009 2010 2011 n/a n/a n/a 7:41 7:24 FIRE DEPARTMENT — Page 4 Number of Attendances at Outside Training 2007 2008 2009 2010 2011 n/a 10 36 20 28 Total Number of Fire Fighters 2007 2008 2009 2010 2011 Total 41 43 42 43 44 Added n/a 4 5 1 5 Net Change n/a 2 -1 1 1 Number of Customer Complaints 2007 2008 2009 2010 2011 n/a 0 1 0 1 Insurance Industry Rating of Fire Services (ISO Rating) (**) 2007 2008 2009 2010 2011 City 5 5 5 5 4/5 Rural 9 9 9 9 10 (**) —Required Performance Measures for State Program n/a—Information Not Available 3 Page One 2013 BUDGET WORKSHEETS FIRE September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 42210 103.00 Salaries&Benefits $54,810 $54,192 $56,593 $172,000 Salary,Taxes,PERA&Benefits 101 42210 103.01 Salaries 52,000 0 101 42210 103.02 Training Pay/Stipends 10,000 0 Detail to be Determined 101 42210 103.03 Call Pay/Stipends 59,900 0 101 42210 103.04 Class Pay/Stipends 100 0 101 42210 01 202.00 Duplicating&Copying 100 101 42210 01 202.01 Copy Toner 43 414 0 50 50 101 42210 01 202.02 Computer Printers 69 0 97 50 50 101 42210 01 204.00 Envelopes&Letterhead 100 101 42210 01 204.01 Envelopes 0 0 0 25 25 101 42210 01 204.02 Letterhead 0 0 0 25 25 101 42210 01 204.03 Forms 422 0 293 50 50 101 42210 01 211.00 Cleaning Supplies 800 101 42210 01 211.01 Soaps 937 293 835 550 550 101 42210 01 211.02 Chamois,Towels,etc. 0 0 0 50 50 101 42210 01 211.03 Sponges,etc. 18 18 0 50 50 101 42210 01 211.04 SCBA Cleaner 59 118 0 150 150 101 42210 01 218.00 Fire Department Clothing 3,495 453 1,013 400 1,400 101 42210 01 218.01 Uniforms 0 0 0 0 400 4 Uniforms @$100 Each 101 42210 01 218.02 Station Wear 0 0 0 0 1,000 Next-2015 101 42210 01 219.00 Other Operating Supplies 4,800 Medical Supplies 101 42210 01 219.01 Gloves 633 500 535 1,000 1,000 101 42210 01 219.02 Bandages 0 0 0 100 100 101 42210 01 219.03 Equipment 637 0 2,076 1,000 1,000 101 42210 01 219.04 Tyvek Suits 0 0 0 100 100 101 42210 01 219.05 Consummable Medical 437 2,953 3,531 2,200 2,200 101 42210 01 219.06 Oxygen 74 160 175 400 400 101 42210 01 229.00 Other Maintenance Supplies 700 101 42210 01 229.01 Vehicle Repairs 0 0 0 400 400 101 42210 01 229.02 Pickup Trucks 45 70 0 0 0 101 42210 01 229.03 Rescue&Other 67 11 0 0 0 101 42210 01 229.04 Vehicle Modifications 380 2,223 0 300 300 101 42210 01 230.00 Equipment Repair Materials 1,500 101 42210 01 230.01 Light Bars 0 0 0 100 100 101 42210 01 230.02 Smoke Machines 0 0 0 250 300 101 42210 01 230.03 Lanterns&Miscellaneous 356 274 908 250 300 101 42210 01 230.04 Small Tool Repairs 3,658 712 734 600 600 101 42210 01 230.05 Opticom 0 0 0 300 100 101 42210 01 230.06 Station 477 628 339 600 100 101 42210 01 241.00 Small Tools 700 101 42210 01 241.01 Axes,Bars&Other 162 675 354 150 150 101 42210 01 241.02 Grass Fire 85 29 166 250 250 101 42210 01 241.03 Hand Tools 430 971 673 300 300 101 42210 01 305.00 Medical&Dental Fees 611 3,604 3,339 3,800 3,800 Annual Medical Tests 101 42210 01 306.00 Personnel Testing&Recruitment 2,400 101 42210 01 306.01 New Physicals(4) 2,181 408 2,237 1,325 1,600 101 42210 01 306.02 Hepatitis Shots(4) 102 106 0 625 500 101 42210 01 306.03 Background Checks(4) 146 121 122 150 100 101 42210 01 306.04 Drug Testing(4) 0 0 0 0 200 101 42210 01 308.00 Instructors'Fees 8,700 101 42210 01 308.01 Fire Fighter 1 (4) 480 2,500 449 1,600 1,600 101 42210 01 308.02 Fire Fighter 1 Certificates(4) 241 590 225 450 280 101 42210 01 308.03 Fire Fighter Re-Certificates(14) 100 200 360 200 280 101 42210 01 308.04 First Responder(4) 762 1,455 1,200 1,000 1,000 101 42210 01 308.05 First Responder Refresher(1/2) 1,200 1,200 0 1,400 1,200 101 42210 01 308.06 Outside Schools 3,558 5,547 3,065 3,350 3,300 101 42210 01 308.07 Haz-Mat Training(4) 0 1,000 0 1,000 1,000 101 42210 01 308.08 Other Re-Certificates(2) 0 0 60 0 40 - - ------------- PAGE TOTALS 76,673 81,429 79,378 146,600 197,000 sy Page Two 2013 BUDGET WORKSHEETS FIRE September 4,2012 2012 2013 Object 2013 2009 2010 2011 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 750 1,336 1,188 1,000 1,000 101 42210 01 310.02 Ladders 474 0 0 500 500 101 42210 01 310.03 Pumpers(3)(Next 2014) 0 0 0 1,200 1,200 101 42210 01 310.04 SCBA Hydro Testing(Next 2016) 0 0 0 0 0 101 42210 01 313.00 Temporary Service Fees 12,600 101 42210 01 313.01 SCBA Maintenance 2,315 1,112 4,771 2,300 4,000 101 42210 01 313.02 SCBA Flow Test 2,047 1,551 0 2,000 2,000 101 42210 01 313.04 Security Contract 631 559 641 800 800 101 42210 01 313.05 SOT Joint Powers 2,637 2,605 2,605 3,500 5,800 101 42210 01 314.00 Annual Fire Relief Contribution 156,500 161,200 166,000 171,000 171,000 101 42210 01 319.00 Other Professional Services 2,200 Fire Prevention Education 101 42210 01 319.01 School Literature 0 59 461 200 400 101 42210 01 319.02 Door Prizes 0 0 150 200 200 101 42210 01 319.03 Fire Prevention Week Promos 1,028 833 703 500 700 101 42210 01 319.04 Food at Open House 300 353 350 200 300 101 42210 01 319.05 Summer Park Education 98 313 0 100 0 101 42210 01 319.06 National Night Out 0 95 621 100 600 101 42210 01 321.00 Telephone Costs 2,100 101 42210 01 321.01 Cell Phones 822 542 802 900 300 101 42210 01 321.02 Computer Cards 1,024 318 44 0 1,800 101 42210 01 321.03 "Future Use" 306 0 88 0 0 101 42210 01 321.04 Numeric Pagers 93 0 0 0 0 101 42210 01 322.00 Postage Costs 13 0 0 100 100 UPS Costs 101 42210 01 329.00 Other Communication Costs 17,000 101 42210 01 329.01 Base Repairs 0 0 0 300 300 101 42210 01 329.02 Pager Repairs 930 546 282 1,000 1,000 101 42210 01 329.03 Hand Held Repairs 51 0 252 300 300 101 42210 01 329.04 Mobile Repairs 0 0 0 200 200 101 42210 01 329.05 800 MHZ User Fee 10,400 10,356 10,604 14,000 14,000 101 42210 01 329.06 Mobile Computers 0 0 0 1,200 1,200 Monthly Air Time Fees 101 42210 01 331.00 Travel Expense 3,900 101 42210 01 331.01 Minnesota Chiefs Conference 1,584 1,621 854 2,000 2,000 101 42210 01 331.02 Fire Department Association 294 1,852 1,572 1,600 1,600 101 42210 01 331.03 Outside Schools 0 710 168 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 0 328 305 550 350 101 42210 01 433.03 State Fire 360 360 710 340 725 101 42210 01 433.04 State Chiefs 145 530 0 250 250 101 42210 01 433.05 DCFC 75 75 75 60 75 101 42210 01 433.06 WAKOTA Mutual Aid 100 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 594 0 0 400 400 101 42210 01 437.02 State Chiefs Conference 320 565 487 500 500 101 42210 01 439.00 Other Miscellaneous Charges 2,400 101 42210 01 439.01 Food&Coffee 18 81 664 150 700 101 42210 01 439.02 Extinguisher 196 0 559 300 550 101 42210 01 439.03 Plaques 102 13 221 40 50 101 42210 01 439.04 Paint 0 0 360 70 100 101 42210 01 439.05 Station Needs 649 1,346 5,419 1,040 1,000 101 42210 01 580.00 Other Equipment Purchases 23,600 101 42210 01 580.01 Bunker Gear(8) 15,901 20,614 17,423 18,600 18,600 101 42210 01 580.02 Pagers 4,231 7,015 0 0 2,000 Replacements 101 42210 01 580.03 Hose&Fittings 2,099 0 1,719 1,000 1,000 101 42210 01 580.04 Replace Damaged Items 3,542 1,960 4,760 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 4,228 0 7,196 0 0 PAGE TOTALS $214,907 $218,950 $232,151 $230,900 $240,000 DEPARTMENT TOTALS $291,580 $300,379 $311,529 $377,500 $437,000 cc 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 25 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. So 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, Steeple Center, the Rosemount Trail Library (plowing only), and the Family Resource Center. Maintenance and operation of the Community Center / Ice Arena is not included in this budget. FLEET MAINTENANCE This budget provides for the maintenance of all City-owned vehicles and over 250 pieces of large and small equipment. It provides funding for all fuels, oils,parts, tires, shop supplies, and contracted vehicle maintenance. The City-owned vehicles include: • Police Department (11 cars, 3 trucks) • Fire Department (6 pickup trucks, 7 fire/rescue trucks) • Parks and Recreation (1 truck, 1 van, 1 car, 1 SUV, 1 ice resurfacer) • Administration / Community Development (2 cars, 2 trucks, 1 van) • Utility Department (1.letter, 1 Vactor, 2 trucks) • Streets and Parks Maintenance (2 sweepers, 3 tractors, 2 loaders, 2 skidsters, 7 dump trucks, 6 mowers, 13 trucks, 2 compactors, 1 roller, 1 ATV, 4 snow blowers) • 5 large trailers STREET MAINTENANCE This budget provides for the maintenance and preservation of 103 miles of City roads, 86 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 and 12 parks with shelters or pavilions. It includes the maintenance of all park trails and 10 other municipal areas,including City Hall, two Fire Stations and the Community Center. It also includes the installation and maintenance of playground equipment, landscaping projects,ice rink construction and maintenance (4 hockey rinks, 6 pleasure rinks), and other miscellaneous construction activities. 17 PUBLIC WORKS — Page 3 PERFORMANCE MEASURES Average Overall (Network) City Street Pavement Condition Rating (**) 2007 2008 2009 2010 2011 2012 n/a n/a n/a 73.83 73.69 n/a Value of Projects Ordered (Contract Amount) 2007 2008 2009 2010 2011 2012(est) $3,160,046 $4,057,030 $1,414,284 $5,400,000 $5,462,900 $2,600,000 % Change from Prior Year (Above) 2007 2008 2009 2010 2011 2012(est) -62.5% 28.45% -65.1% 282% 0.1% -52.4% Average Number of Hours for Full Snow Clearing Event 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13(est) n/a n/a 7.125 6.80 6.92 7.0 of Mechanics'Time Spent on Repair / Maintenance 2007 2008 2009 2010 2011 2012(est) 93% 93% 96% 93% 97% 95% Park Acres Maintained 2007 2008 2009 2010 2011 2012 135 127 133 133 134 134 (**) —Required Performance Measures for State Program n/a—Information Not Available ST Page One 2013 BUDGET WORKSHEETS GOVERNMENT BUILDINGS September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41940 101.00 Salaries&Benefits $71,200 Salary,Taxes,PERA&Benefits 101 41940 79 101.01 Facility Specialist 0 0 0 0 71,200 80%of FIT Person 101 41940 102.00 Full-Time Overtime 0 0 0 0 0 101 41940 01 208.00 Miscellaneous Supplies 16,399 15,626 16,542 19,000 17,000 Cleaning Supplies,Towels 101 41940 01 219.00 Other Operating Supplies 0 0 0 2,000 2,000 Flags 101 41940 01 223.00 Building Repair Supplies 8,910 9,030 13,423 9,200 9,200 101 41940 01 225.00 Landscaping Materials 116 947 941 1,500 1,500 Trees&Shrubs(Fire Stations) 101 41940 01 241.00 Small Tools 179 246 228 200 200 Hand Tools,Bits, Blades,etc. 101 41940 01 242.00 Minor Equipment 1,468 811 1,996 2,000 2,000 Equipment Replacement 101 41940 01 302.00 Architects'Fees 0 0 0 0 0 Estimates 101 41940 01 318.00 Contract Engineer 1,500 1,500 1,750 1,500 1,800 Contracted Engineer for City(5%) 101 41940 01 319.00 Other Professional Services 77,600 101 41940 01 319.01 Elevator Maintenance 1,695 2,051 1,832 1,500 1,500 101 41940 01 319.02 Heating/Cooling Maint Contract 8,310 7,646 6,167 8,000 8,000 Includes all City Facilities 101 41940 01 319.03 Annual Boiler Inspections I Maint. 1,128 120 647 1,500 800 101 41940 01 319.04 Pest Control 2,180 2,210 2,505 2,500 2,500 101 41940 01 319.05 Fire Extinguishers 738 1,769 1,135 2,500 1,800 101 41940 01 319.06 Fire Suppression System Check 3,484 3,131 3,033 3,500 3,500 101 41940 01 319.07 Janitorial Service-Fire Stations 10,908 10,016 10,016 11,000 10,100 101 41940 01 319.08 Janitorial Service-P.W.Building 11,104 10,529 10,529 12,000 10,600 101 41940 01 319.09 Janitorial Service-City Hall 26,183 24,534 24,534 25,500 24,600 101 41940 01 319.10 Floor Mats-Monthly Charges 3,817 3,257 3,578 4,000 4,000 101 41940 01 319.11 Other Janitorial Services 0 4,701 6,946 7,000 9,200 Wax Firs,Carpet Cing,Windows 101 41940 01 319.12 Annual Monument Maintenance 0 0 800 0 1,000 $900-$1200(Hot Wax) 101 41940 01 381.00 Electric Utilities 62,637 63,008 66,212 70,000 70,000 101 41940 01 382.00 Water Utilities 0 0 0 0 0 101 41940 01 383.00 Gas Utilities 61,001 46,942 51,688 62,000 62,000 101 41940 01 384.00 Refuse Disposal 33,000 101 41940 01 384.01 General Buildings&Parks 15,175 15,713 18,377 16,000 19,000 Added Sites in 2011 101 41940 01 384.02 Recycling/Cleanup 12,201 11,090 13,535 14,000 14,000 2 Cleanup Days per Year 101 41940 01 401.00 Contracted Building Repairs 42,000 101 41940 01 401.01 Electrical Repairs 4,202 1,839 3,027 5,000 4,000 101 41940 01 401.02 Siren Replacement Program 10,000 8,157 311 10,000 10,000 101 41940 01 401.03 Miscellaneous Repairs 25,353 24,462 27,419 25,000 28,000 101 41940 01 401.04 Roof Inspection 123 0 0 0 0 101 41940 01 415.00 Other Equipment Rental 103 0 0 1,000 0 101 41940 01 439.00 Other Miscellaneous Charges 0 0 0 5,000 5,000 Energy Efficiency Improvements 101 41940 01 530.00 Improvements Other Than Buildings 84,606 69,836 69,944 76,000 60,000 Next 5-year Average Expenditure 101 41940 01 601.00 Bond Principal 48,421 41,886 60,526 60,600 65,400 MSABC Payment(2/1) 101 41940 01 611.00 Bond Interest 29,034 33,717 24,973 25,400 20,600 MSABC Payments(2/1 &8/1) 101 41940 01 621.00 Bond Paying Agent Fees 0 1,549 0 0 0 ------------- PAGE TOTALS $450,974 $416,324 $442,613 $484,400 $540,500 DEPARTMENT TOTALS $450,974 $416,324 $442,613 $484,400 $540,500 S9 Page One 2013 BUDGET WORKSHEETS FLEET MAINTENANCE September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43100 101.00 Salaries&Benefits $179,000 Salary,Taxes,PERA&Benefits 101 43100 77 101.00 Administrative 11,274 11,555 11,876 12,100 10,700 101 43100 78 101.00 Technical/Clerical 0 0 0 0 9,600 101 43100 79 101.00 Maintenance 143,260 147,683 152,060 153,900 158,700 101 43100 102.00 Full-Time Overtime 1,971 2,561 619 3,000 3,000 101 43100 01 211.00 Cleaning Supplies 987 1,111 1,577 1,000 1,000 Shop&Vehicles 101 43100 01 212.00 Motor Fuels 126,007 187,081 174,864 220,000 210,000 Price Estimate 101 43100 01 213.00 Lubricants&Additives 7,891 10,699 10,546 12,000 12,000 Price Increase 101 43100 01 215.00 Shop Materials 12,732 16,433 19,779 17,000 17,000 101 43100 01 221.00 Equipment Parts 102,642 153,416 147,760 140,000 140,000 101 43100 01 222.00 Tires 11,854 35,695 22,830 20,000 22,500 101 43100 01 241.00 Small Tools 3,504 2,396 2,195 4,000 4,000 101 43100 01 242.00 Minor Equipment 4,339 3,198 4,703 4,000 4,000 101 43100 01 318.00 Contract Engineer 3,000 3,000 3,500 3,000 3,500 Contracted Engineer for City(10%) 101 43100 01 321.00 Telephone Costs 0 0 0 0 0 101 43100 01 323.00 Radio Units 1,104 150 4,645 1,000 1,300 Warranty(24 Units @$53 each) 101 43100 01 384.00 Refuse Disposal 10 25 25 300 300 Shop Hazardous Waste 101 43100 01 394.00 P.C.Software Purchases 284 529 1,892 6,000 101 43100 01 394.01 Licensing&Maintenance 1,600 1,800 CarteGraph 101 43100 01 394.02 Online Subscriptions 1,500 2,700 All Fleet Software Updates 101 43100 01 394.03 New Software Purchases 0 1,500 CAT Software 101 43100 01 404.00 Contracted Mach&Equip Repairs 44,680 39,152 37,962 40,000 40,000 101 43100 01 416.00 Machinery Rental 0 0 0 1,000 1,000 101 43100 01 417.00 Uniforms Rental 295 263 181 0 0 More Accurate Allocations(433.00) 101 43100 01 433.00 Dues&Subscriptions 1,575 90 1,500 100 100 DOT Certification 101 43100 01 435.00 Books&Pamphlets 129 56 273 100 100 DOT Decals and Inspection Pads 101 43100 01 437.00 Conferences&Seminars 348 0 247 300 300 $150-CarteGraph;$150-Misc. PAGE TOTALS $477,886 $615,092 $599,035 $635,900 $645,100 DEPARTMENT TOTALS $477,886 $615,092 $599,035 $635,900 $645,100 k)0 Page One 2013 BUDGET WORKSHEETS STREET MAINTENANCE September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43121 101.00 Salaries&Benefits $483,800 Salary,Taxes,PERA&Benefits 101 43121 77 101.00 Administrative 33,821 34,665 35,630 36,200 21,300 101 43121 78 101.00 Technical/Clerical 62,847 63,978 47,215 47,800 52,400 101 43121 75 101.00 Maintenance 389,176 372,144 426,887 434,200 410,100 101 43121 102.00 Full-Time Overtime 13,177 13,457 10,055 14,000 14,000 Maintenance 101 43121 95 103.00 Part-Time Salaries&Benefits 33,759 28,696 16,553 33,500 20,000 Includes Funds for Horticulturist 101 43121 01 201.00 Office Accessories 0 0 0 100 100 101 43121 01203.00 Printed Forms&Paper 200 101 43121 01 203.01 R/W Permit&Inspection Forms 0 0 0 200 200 101 43121 01 203.03 City Specification Books 1,956 0 0 0 0 101 43121 01205.00 Drafting Supplies 900 101 43121 01 205.01 Plotter Ink and Paper 936 136 752 1,000 500 Split with 101-45202-01-205.00 101 43121 01 205.02 Off-Site Reproductions 246 53 0 400 400 101 43121 01 209.00 Other Office Supplies 154 1,231 0 500 500 101 43121 01 216.00 Chemical&Chemical Products 48,212 72,845 77,386 80,000 75,000 101 43121 01 224.00 Street Maintenance Materials 8,500 101 43121 01 224.01 Paint 208 481 738 500 500 101 43121 01 224.02 Mail Boxes 611 493 2,955 1,500 1,500 101 43121 01 224.03 Light Bulbs/Lenses 396 304 20 1,500 1,500 Replace with LED Bulbs 101 43121 01 224.04 Holiday Decorations 0 0 0 0 5,000 Begin Replacement Program 101 43121 01 225.00 Landscaping Materials 15,300 101 43121 01 225.01 Sod 0 0 235 1,500 1,500 101 43121 01 225.02 Seed 0 0 1,572 200 200 101 43121 01 225.03 Black Dirt 250 51 923 1,000 1,000 101 43121 01 225.04 Trees 469 0 2,990 500 500 101 43121 01 225.05 Hanging Baskets 4,571 4,379 3,638 5,000 5,000 101 43121 01 225.06 Entrance Monuments 0 0 656 6,000 2,000 101 43121 01 225.07 Downtown Planters 0 0 1,575 1,300 1,600 101 43121 01 225.08 Park Signs&RCC 0 0 1,112 2,000 2,000 101 43121 01 225.09 Library 0 0 0 0 1,500 101 43121 01 225.10 Banners 0 0 0 0 0 101 43121 01 226.00 Sign Repair Materials 12,483 9,950 13,682 15,000 15,000 101 43121 01 231.00 Bituminous Patching Materials 32,495 25,664 39,430 32,500 32,500 101 43121 01 232.00 Crushed Rock 29,395 25,155 30,236 32,500 32,500 101 43121 01 233.00 Dust Control Materials 35,197 30,154 24,848 25,000 30,000 None East of Akron,Price Increase 101 43121 01 234.00 De-Icing Sand/Rock 3,531 1,955 2,853 3,000 3,000 Gravel Road Ice Control(Estimate) 101 43121 01 235.00 Shouldering Gravel 576 0 0 0 0 101 43121 01 241.00 Small Tools 1,657 863 658 2,000 2,000 Shovels,Brooms,etc. 101 43121 01 242.00 Minor Equipment 3,506 4,184 2,095 4,000 4,000 Safety Equipment/Power Tools 101 43121 01 303.00 Engineering Fees 45,778 13,237 40,096 10,000 10,000 General Non-Project Related 101 43121 01 304.00 Legal Fees 578 877 0 0 0 101 43121 01 305.00 Medical&Dental Fees 0 0 0 0 0 101 43121 01 310.00 Testing Services 0 0 56 0 0 101 43121 01 313.00 Temporary Service Fees 0 1,275 9,706 0 0 101 43121 01 318.00 Contract Engineer 6,000 6,000 7,000 6,000 7,000 Contracted Engineer for City(20%) 101 43121 01 319.00 Other Professional Services 544 32 114 10,000 101 43121 01 319.01 Random Drug Testing 0 0 0 0 0 101 43121 01 319.02 GIS Consulting Services 0 0 0 10,000 10,000 101 43121 01 321.00 Telephone Costs 3,073 2,609 2,812 3,000 3,000 Includes Wireless Technology 101 43121 01 323.00 Radio Units 0 1,083 1,211 1,500 1,500 24 Units @$280(Split 5 Ways) 101 43121 01 324.00 Messenger Services 0 0 0 100 100 101 43121 01 331.00 Travel Expense 206 417 0 500 500 101 43121 01 341.00 Employment Advertising 0 0 0 0 0 101 43121 01 381.00 Electric Utilities 175,000 101 43121 01 381.01 Street Lights 159,178 158,067 170,065 170,000 170,000 101 43121 01 381.02 Signal Lights&Sirens 4,272 2,989 3,003 5,000 5,000 101 43121 01 384.00 Refuse Disposal 2,000 101 43121 01 384.01 Hazardous Waste Disposal 0 609 463 500 500 101 43121 01 384.02 Roadside Garbage 392 697 231 900 900 101 43121 01 384.03 Tree Disposal 0 53 0 600 600 _ 101 43121 01 391.00 P.C.Maintenance 10,800 101 43121 01 391.03 Pavement Management Syst Sup 0 5,450 10,254 10,000 10,000 101 43121 01 391.04 R-O-W Permit On-Line Service 4,800 4,800 4,800 4,800 800 New County Online Permiting 101 43121 01 392.00 P.C.Accessories&Supplies 0 0 320 0 0 101 43121 01 393.00 P.C.Hardware Purchases 0 0 0 1,800 4,000 New GPS Unit,Server Upgrades 101 43121 01 394.00 P.C.Software Purchases 4,574 3,240 4,574 5,100 101 43121 01 394.01 Licensing&Maintenance 4,600 4,800 CarteGraph,GIS 101 43121 01 394.02 Online Subscriptions 300 300 Pictometry 101 43121 01 394.03 New Software Purchases 4,000 0 CG Upgrades(YourGOV,Mobile) ^ ` PAGE TOTALS 939,026 892,272 999,396 Y1,016,500 966,300 (o 1 Page Two 2013 BUDGET WORKSHEETS STREET MAINTENANCE September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 43121 01 402.00 Parking Lot Maintenance 10,000 13,577 0 25,000 25,000 Next 5-year Average Expenditure 101 43121 01403.00 Contracted Repair&Maintenance 30,000 101 43121 01 403.01 Street Lights 14,231 1,421 27,543 28,500 28,500 Repair 9 Street Lights(Annually) 101 43121 01403.02 Signal Lights 767 0 763 500 1,500 101 43121 01 403.03 Light Replacements 1,471 0 0 0 0 101 43121 01404.00 Contracted Mach&Equip Repairs 0 0 0 15,000 15,000 Quiet Zones-Railroad Maint Costs 101 43121 01 405.00 Street Striping 36,202 40,811 46,887 60,000 60,000 101 43121 01 408.00 Street Crack Sealing 49,153 44,913 59,267 60,000 60,000 Increased Street Overlays 101 43121 01409.00 Tree Trimming 2,109 19,959 4,309 10,000 10,000 101 43121 01410.00 Concrete Sidewalk/Curb Repairs 20,000 101 43121 01410.01 General Repairs 3,508 16,839 26,252 20,000 20,000 101 43121 01 410.02 Pedestrian Improvements 124,381 125,000 130,604 0 0 Moved$125,000 to Street CIP 101 43121 01 411.00 Contracted Snow Removal 45,000 101 43121 01 411.01 Community Center 9,869 21,970 30,268 20,000 20,000 101 43121 01 411.02 Steeple Center 4,775 8,329 9,993 10,000 10,000 101 43121 01 411.03 Genz-Ryan 0 0 0 0 0 101 43121 01411.04 Dakota County Library 9,340 16,310 12,219 15,000 15,000 101 43121 01415.00 Equipment Rental 24,531 27,917 35,508 30,000 30,000 101 43121 01433.00 Dues&Subscriptions 900 101 43121 01 433.01 American Public Works Ass'n 652 671 695 700 700 Annual Membership 101 43121 01 433.03 City Engineers'Association 20 33 0 0 0 101 43121 01 433.04 Professional Secretaries 80 0 0 0 0 101 43121 01433.07 MN Street Superintendent Assn 70 120 70 200 200 101 43121 01 435.00 Books&Pamphlets 0 101 43121 01435.02 "Future Use" 140 0 0 0 0 101 43121 01437.00 Conferences&Seminars 6,100 101 43121 01 437.01 APWA 59 0 0 1,000 1,000 Spring/Fall Conferences 101 43121 01 437.03 Clerical 80 97 0 150 150 MuniciPals(Twice Annually) 101 43121 01 437.04 Gravel Road Maintenance 210 0 0 0 0 101 43121 01 437.05 Maintenance Expo 50 0 0 300 300 101 43121 01437.06 Cartegraph,ESRI,GIS 250 0 231 450 1,500 User Group,Conference,Training 101 43121 01 437.07 Snow Conference 0 165 0 0 300 101 43121 01 437.08 MN Dot 160 0 0 0 300 Simulator 101 43121 01 437.09 Miscellaneous Training 436 785 1,332 1,500 2,550 DCTC Defensive Driving Training 101 43121 01 439.00 Other Miscellaneous Charges 216 496 105 500 500 Host CONDAC,RL&CD Notary 101 43121 01 570.00 Office Equipment&Furnishings 0 0 0 0 0 PAGE TOTALS $292,758 $339,412 $386,045 $298,800 $302,500 DEPARTMENT TOTALS $1,231,784 $1,231,684 $1,385,441 $1,315,300 $1,268,800 c4a Page One 2013 BUDGET WORKSHEETS PARKS&GROUNDS MAINTENANCE September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 45202 101.00 Salaries&Benefits $375,600 Salary,Taxes,PERA&Benefits 101 45202 77 101.00 Administrative 11,274 11,555 11,877 12,100 21,300 101 45202 78 101.00 Technical/Clerical 0 0 0 0 19,100 101 45202 79 101.00 Maintenance 396,110 401,187 411,767 426,000 335,200 101 45202 102.00 Full-Time Overtime 14,214 15,185 9,366 14,000 14,000 101 45202 99 103.00 Part-Time Salaries&Benefits 42,088 49,894 68,823 49,500 63,000 101 45202 01 205.00 Plotter Ink and Paper 0 0 0 100 500 Split with 101-43121-01-205.01 101 45202 01 216.00 Chemical&Chemical Products 25,000 Includes all City Facilities 101 45202 01 216.01 Herbicides(General Park Use) 2,954 8,520 6,165 6,000 0 101 45202 01 216.02 Fertilizer 21,785 21,330 8,295 11,000 0 101 45202 01 219.00 Other Operating Supplies 17,500 101 45202 01 219.01 Seed,Sod,etc. 4,917 3,440 2,139 3,000 3,000 101 45202 01 219.02 Red Rock,Sand,Gravel,etc. 2,409 7,079 5,299 2,500 2,500 101 45202 01 219.03 Repair Supplies 0 0 0 1,000 0 101 45202 01 219.04 Bituminous 0 0 0 0 0 101 45202 01 219.05 Wood Chips 8,484 8,972 7,214 9,000 12,000 Special Chips,Jaycee Playground 101 45202 01 221.00 Equipment Parts 13,500 101 45202 01 221.01 Playground Equipment Repair 4,886 4,387 4,643 4,500 6,000 Repairs on Aging Equipment 101 45202 01 221.02 Irrigation Repair(Non-Contract) 7,418 4,341 5,046 7,500 6,000 101 45202 01 221.03 Miscellaneous 3,434 864 1,599 1,500 1,500 101 45202 01 221.04 Park Sign Replacements 0 127 0 0 0 101 45202 01 223.00 Building Repair Supplies 9,000 101 45202 01 223.01 Paint,Stain,etc. 2,950 315 2,749 1,500 2,500 101 45202 01 223.02 Shingles,Boards,etc. 1,515 592 1,268 2,000 1,500 1 101 45202 01 223.03 Miscellaneous 755 1,570 1,647 1,500 1,500 101 45202 01 223.04 Shelter/Shed Repairs 3,168 2,301 3,018 5,000 3,500 101 45202 01 225.00 Landscaping Materials 3,500 101 45202 01 225.01 Trees,Shrubs,Sod,etc. 740 1,891 1,648 2,500 2,500 101 45202 01 225.02 Timbers,Fence,etc. 227 1,772 1,241 1,000 1,000 101 45202 01 226.00 Sign Repair Materials 0 202 0 500 500 101 45202 01 229.00 Other Maintenance Supplies 5,701 13,981 12,276 15,000 15,000 Paint,Chalk,Field Dry(&DCTC) 101 45202 01 241.00 Small Tools 2,572 3,181 2,456 2,500 2,500 Hand Tools,Blades,Bits,etc. 101 45202 01 242.00 Minor Equipment 2,406 1,589 3,264 2,500 2,500 Weed Whips,Chain Saws-Powered 101 45202 01 303.00 Engineering Fees 0 0 0 0 0 101 45202 01 305.00 Medical and Dental Fees 0 0 0 0 0 101 45202 01 318.00 Contract Engineer 1,500 1,500 1,750 1,500 1,800 Contracted Engineer for City(5%) 101 45202 01 319.00 Other Professional Services 5,500 101 45202 01 319.01 Maintenance of Open Spaces 0 0 3,120 3,000 3,000 101 45202 01 319.02 Central/Erickson Prairie 0 0 0 0 2,500 Controlled Burn at Erickson 101 45202 01 321.00 Telephone Costs 3,460 3,284 3,806 3,100 3,100 Includes Wireless Technology 101 45202 01 323.00 Radio Units 603 1,083 1,211 1,500 1,500 24 Units @$280(Split 5 Ways) 101 45202 01 341.00 Employment Advertising 0 0 0 0 0 101 45202 01 381.00 Electric Utilities 21,000 101 45202 01 381.01 Skating Rinks 5,975 6,738 7,108 8,000 8,000 Service Connect/Disconnect 101 45202 01 381.02 Softball Fields 7,542 6,560 7,026 8,000 8,000 101 45202 01 381.03 Irrigation 3,982 3,637 3,461 5,000 5,000 101 45202 01 383.00 Gas Utilities 2,133 1,844 2,124 2,000 2,000 101 45202 01 393.00 P.C.Hardware Purchases 0 0 320 1,800 4,000 New GPS Unit,Server Upgrades 101 45202 01 394.00 P.C.Software Purchases 4,609 5,378 4,574 5,100 101 45202 01 394.01 Licensing&Maintenance 4,600 4,800 Cartegraph,GIS 101 45202 01 394.02 Online Subscriptions 300 300 Pictometry 101 45202 01 394.03 New Software Purchases 4,000 0 CG Upgrades(YourGOV,Mobile) ------------ PAGE TOTALS 569,809 594,300 606,299 624,500 586,100 63 Page Two 2013 BUDGET WORKSHEETS PARKS&GROUNDS MAINTENANCE September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 45202 01 403.00 Contracted Repair&Maintenance 12,000 101 45202 01 403.01 Irrigation Repairs 3,686 3,847 6,186 12,000 8,000 RPZ-Inspect&Replace(&Blowout) 101 45202 01 403.02 Electrical Repairs 3,299 2,475 3,484 3,000 3,000 101 45202 01 403.03 Miscellaneous Repairs 601 1,330 3,529 1,000 1,000 101 45202 01 409.00 Other Contracted Repair&Maint 5,537 44,000 101 45202 01 409.01 Chemlawn Services 0 2,133 1,947 2,000 2,000 101 45202 01 409.02 Library/St.Joe's/RCC 0 7,531 8,108 8,500 10,000 Mowing and Chemical Application 101 45202 01 409.03 Fire Station#1 0 0 3,500 3,700 5,000 Mowing and Chemical Application 101 45202 01 409.04 Fire Station#2 0 0 2,450 2,600 4,000 Mowing and Chemical Application 101 45202 01 409.05 City Hall/Central Park 0 0 6,000 6,300 8,000 Mowing and Chemical Application 101 45202 01 409.06 UMore Baseball Fields 0 0 0 15,000 15,000 UMore Baseball Field Maintenance 101 45202 01 416.00 Machinery Rental 17,500 101 45202 01 416.01 Mower Leases 15,685 3,727 27,855 16,000 16,000 3 John Deere's 101 45202 01 416.02 Miscellaneous Rentals 1,689 3,580 1,301 1,500 1,500 101 45202 01 433.00 Dues&Subscriptions 200 101 45202 01 433.01 MN Park Supervisors Ass'n 0 0 0 50 50 101 45202 01 433.02 Miscellaneous Dues 80 45 0 50 150 101 45202 01 435.00 Books&Pamphlets 0 0 0 0 0 101 45202 01 437.00 Conferences&Seminars 3,900 101 45202 01 437.01 Seminars&Workshops 967 726 659 1,500 1,100 Green Expo,MPSA,Playgrounds 101 45202 01 437.02 School&Tuition 1,219 156 1,771 1,300 1,300 Turf School,Power Limited Tech. 101 45202 01 437.03 CarteGraph,ESRI,GIS 0 0 157 500 1,500 User Group,Conference,Training 101 45202 01 439.00 Other Miscellaneous Charges 0 0 250 200 200 Contingencies 101 45202 01 530.00 Improvements Other Than Bldgs 50,000 64,892 64,988 65,000 75,000 Next 5-Year Average Expenditures PAGE TOTALS $82,763 $90,442 $132,187 $140,200 $152,800 DEPARTMENT TOTALS $652,572 $684,742 $738,485 $764,700 $738,900 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 and performances. Staff coordinates the rentals,maintenance and capital improvement projects of the facility. c PARKS & RECREATION DEPARTMENT — Page 2 PERFORMANCE MEASURES Hours of Use at Community Center 2007 2008 2009 2010 2011 19,149 22,761 18,151 18,296 19,390 Total Community Center Rental Income and% Change from Prior Fiscal Year 2007 2008 2009 2010 2011 Income $118,094 $122,315 $111,186 $97,375 $99,829 % Change +7.0% +3.5% -9.0% -12.5% +2.5% Number of Acres in the Park System and % Change from Prior Fiscal Year 2007 2008 2009 2010 2011 Income 430.84 430.52 440.24 440.24 467.24 % Change +0.00% -0.07% +2.4% +0.0% +6.8% 2009 —Added DCTC Soccer Fields 2011 —Added UMore Ball Fields Percentage of Costs Received for All Recreation Programs 2007 2008 2009 2010 2011 Revenues $154,229 $151,378 $124,554 $149,377 $134,981 Expenses $133,556 $128,292 $107,625 $128,707 $113,336 Net $20,673 $23,086 $16,929 $20,670 $21,645 n/a—Information Not Available Page One 2013 BUDGET WORKSHEETS PARKS&RECREATION September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 45100 101.00 Salaries&Benefits $650,239 $677,923 $703,800 $713,600 $745,800 Salary,Taxes,PERA&Benefits 101 45100 102.00 Full-Time Overtime 6,844 4,396 4,864 5,000 5,000 101 45100 103.00 Part-Time Salaries&Benefits 140,300 101 45100 10 103.00 P/T Receptionist 33,014 35,011 35,361 35,200 36,300 101 45100 12 103.00 Building Attendants 62,401 53,294 54,009 53,000 54,000 101 45100 15 103.00 P/T Recreation Specialist 0 0 0 0 11,000 1/3 Year 101 45100 83 103.00 Playground Recreation Leaders 20,757 24,955 18,501 24,000 20,000 101 45100 94 103.00 Warming House Attendants 16,400 15,190 14,523 17,000 17,000 101 45100 99 103.00 Park&Rec Committee 1,559 1,754 1,814 2,000 2,000 101 45100 71 103.00 P/T Horticulturist 7,480 9,738 0 0 0 Moved to Public Works Budget 101 45100 01 203.00 Printed Forms&Paper 0 0 0 0 0 101 45100 01 205.00 Drafting Supplies 149 1,039 117 500 500 Laminating 101 45100 01 207.00 Training&Instructional Supplies 0 0 0 0 0 101 45100 01 208.00 Miscellaneous Supplies 70 94 60 0 0 101 45100 01 209.00 Other Office Supplies 455 1,062 119 500 500 Envelopes,Forms,Rulers,etc. 101 45100 01 211.00 Cleaning Supplies 4,080 3,757 4,326 4,000 4,000 101 45100 01 216.00 Chemicals&Chemical Products 652 35 109 500 500 101 45100 01 219.00 Other Operating Supplies 6,816 6,690 6,655 7,000 7,000 Rec Programs,1st Aid Sup,etc. 101 45100 01 221.00 Equipment Parts 8,586 10,556 6,050 9,000 8,000 101 45100 01 223.00 Building Repair Supplies 1,063 1,908 1,169 3,500 3,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 7,042 4,232 5,258 6,000 6,000 Custodial Services-Banquet Rm 101 45100 01 315.00 Special Programs 16,200 101 45100 01 315.01 Sunday Night Specials 5,096 6,007 5,329 5,500 5,500 Performances(Add Movies) 101 45100 01 315.02 Leprechaun Days 242 283 613 250 250 Trophies&Awards 101 45100 01 315.03 Umore Maint.Agreement 0 0 0 0 500 1/4 Year 101 45100 01 315.04 Ground Pounders(Running) 127 0 297 200 200 Ribbons&Mailings 101 45100 01 315.05 Nature Programs(Arbor Day) 3,622 3,018 4,291 4,700 4,700 180 Trees 101 45100 01 315.06 Puppet Programs 11 294 54 150 150 Tapes,Fuses,Puppets,etc. 101 45100 01 315.07 Special Events 56 441 124 1,000 1,000 Publicity&Supplies 101 45100 01 315.08 Adopt-A-Park Program 81 453 389 500 500 Flyers,Signs 101 45100 01 315.09 Miscellaneous Programs 0 1,787 2,552 2,000 3,000 Start Up Costs-Community Garden 101 45100 01 315.10 ADA Programs 20 0 0 400 400 ADA Program Supplies 101 45100 01 319.00 Other Professional Services 2,773 1,466 5,393 4,000 6,000 ADA Services/Eng.LA Sery Test 101 45100 01 321.00 Telephone Costs 3,024 3,620 3,898 3,700 3,900 Pagers&Cellular Phones 101 45100 01 331.00 Travel Expense 338 160 181 500 500 101 45100 01 341.00 Employment Advertising 0 333 100 700 0 101 45100 01 349.00 Other Advertising 33,400 101 45100 01 349.01 Brochures 36,914 35,140 28,889 28,000 28,000 City Newsletter(3 Per Year) 101 45100 01 349.02 Yellow Pages 2,148 1,607 1,430 2,000 1,500 Rec Ads 101 45100 01 349,03 Special Marketing 3,871 3,835 3,835 3,900 3,900 Garage Sale Ad 101 45100 01 381.00 Electric Utilities 26,990 27,331 30,295 28,000 29,000 101 45100 01 383.00 Gas Utilities 31,542 23,885 26,328 28,000 28,000 101 45100 01 384.00 Refuse Disposal 3,887 3,737 3,699 4,000 4,000 101 45100 01 392.00 P.C.Accessories&Supplies 0 0 0 0 0 101 45100 01 393.00 P.C.Hardware Purchases 0 1,550 0 0 0 101 45100 01 394.00 P.C.Software Purchases 3,742 2,167 2,066 0 0 See"433.03"Below 101 45100 01 401.00 Contracted Building Repairs 7,472 7,162 11,486 8,000 8,000 101 45100 01 404.00 Contracted Mach&Equip Repairs 3,840 5,195 4,170 6,000 6,000 101 45100 01 409.00 Other Contracted Repair&Maint 23,507 23,624 24,745 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 15,327 17,757 16,827 19,000 19,000 Portable Toilets&Other(New Pks) 101 45100 01 433.00 Dues&Subscriptions 4,800 101 45100 01 433.01 MRPA Dues 1,426 1,437 1,576 1,700 1,700 Minn Recreation&Parks Ass'n 101 45100 01 433.02 Miscellaneous 1,002 1,761 1,927 400 400 Paper,Magazines,etc. 101 45100 01 433.03 On-Line Registrat'n Subscription 181 0 0 2,700 2,700 101 45100 01 435.00 Books&Pamphlets 0 0 0 100 100 101 45100 01 437.00 Conferences&Seminars 3,700 101 45100 01 437.01 MRPA State Conference 1,260 1,055 1,520 1,300 1,300 101 45100 01 437.03 Workshops,Schools,&Tuition 1,521 2,432 2,112 2,000 2,400 101 45100 01 439.00 Other Miscellaneous Charges 21,722 9,857 19,590 0 0 Donation Account 101 45100 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 YY_ PAGE TOTALS $1,046,152 $1,055,824 $1,077,250 $1,085,300 $1,129,500 General Operating DEPARTMENT TOTALS $1,046,152 $1,055,824 $1,077,250 $1,085,300 $1,129,500 (47 Page Two 2013 BUDGET WORKSHEETS ***STEEPLE CENTER BUDGET*** PARKS&RECREATION September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 38201.00 Rental Revenues $0 $6,575 $19,750 $14,500 $18,000 101 38203.00 Rental Revenue-Churches 0 0 500 0 0 101 38205.00 AN Rental Revenues 0 0 428 500 500 101 38207.00 Liquor Providor Revenues 0 0 0 0 0 101 38209.00 Miscellaneous Revenues 0 0 280 3,000 0 101 38211.00 Security Services 0 700 2,050 0 2,000 TOTAL REVENUES ---$0 -$7,275 $23,008 $18,000 -- --$20,500 101 45100 30 103.00 Salaries&Benefits $15,000 Salary,Taxes,PERA&Benefits 101 45100 30 103.00 Building Attendants 0 2,324 15,425 8,000 15,000 Event Staff 101 45100 30 211.00 Cleaning Supplies 0 1,654 4,207 1,500 3,000 101 45100 30 219.00 Other Operating Supplies 0 4,539 1,538 1,500 1,500 Events Supplies 101 45100 30 221.00 Equipment Parts 0 2,089 990 1,500 1,500 101 45100 30 223.00 Building Repair Supplies 0 3,998 4,251 5,000 5,000 101 45100 30 241.00 Small Tools 0 74 0 500 500 101 45100 30 242.00 Minor Equipment 0 1,304 1,273 1,000 1,000 101 45100 30 321.00 Telephone Costs 0 276 1,751 1,200 1,800 101 45100 30 349.00 Other Advertising 0 1,220 325 1,500 1,500 101 45100 30 365.00 Workers'Comp Insurance 0 0 0 500 500 101 45100 30 369.00 Other Insurance 0 0 0 2,000 2,000 101 45100 30 381.00 Electric Utilities 0 5,590 5,669 7,000 5,500 101 45100 30 383.00 Gas Utilities 0 10,632 9,905 12,000 9,000 101 45100 30 384.00 Refuse Disposal 0 323 1,142 1,000 1,000 101 45100 30 401.00 Contracted Building Repairs 0 13,855 11,523 10,000 11,000 101 45100 30 404.00 Contracted Mach&Equip Repairs 0 6,423 3,553 4,200 4,200 101 45100 30 415.00 Other Equipment Rental 0 910 789 500 500 101 45100 30 439.00 Other Miscellaneous Charges 0 0 0 0 0 101 45100 30 521.00 Building&Structure Purchases 0 1,604 0 0 0 PAGE/EXPENDITURE TOTALS -- $0 $56,815 $62,340 $58,900 $64,500 ***SENIOR I ACTIVITY CENTER***(All Budget Numbers Calculated for 1/4 Year) 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 38301.00 Rental Revenues $0 $0 $0 $0 $750 101 38305.00 AN Rental Revenues 0 0 0 0 50 101 38309.00 Miscellaneous Revenues 0 0 0 0 0 ----------- ----------- ------------- --------- TOTAL REVENUES $0 $0 $0 $0 $800 101 45100 31 103.00 Salaries&Benefits $7,800 Salary,Taxes,PERA&Benefits 101 45100 31 103.00 Building Attendants 0 0 0 0 7,800 Event Staff 101 45100 31 211.00 Cleaning Supplies 0 0 0 0 300 101 45100 31 219.00 Other Operating Supplies 0 0 0 0 400 Events Supplies 101 45100 31 221.00 Equipment Parts 0 0 0 0 400 101 45100 31 223.00 Building Repair Supplies 0 0 0 0 500 101 45100 31 242.00 Minor Equipment 0 0 0 0 300 101 45100 31 321.00 Telephone Costs 0 0 0 0 300 101 45100 31 349.00 Other Advertising 0 0 0 0 100 101 45100 31 365.00 Workers'Comp Insurance 0 0 0 0 200 101 45100 31 369.00 Other Insurance 0 0 0 0 500 101 45100 31 381.00 Electric Utilities 0 0 0 0 1,500 101 45100 31 383.00 Gas Utilities 0 0 0 0 500 101 45100 31 384.00 Refuse Disposal 0 0 0 0 300 101 45100 31 401.00 Contracted Building Repairs 0 0 0 0 500 101 45100 31 404.00 Contracted Mach&Equip Repairs 0 0 0 0 300 101 45100 31 415.00 Other Equipment Rental 0 0 0 0 100 101 45100 31 439.00 Other Miscellaneous Charges 0 0 0 0 0 PAGE/EXPENDITURE TOTALS $0 $0 $0 $0 $14,000 10 Page Three 2013 BUDGET WORKSHEETS PARKS&RECREATION September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments $113,900 �� --Y-�---- 101 45100 80 Art Classes $0 $0 $0 $1,000 $1,000 101 45100 81 Softball 44,648 51,127 44,877 40,000 45,000 101 45100 82 Volleyball 0 0 0 0 0 101 45100 84 Tennis 1,744 1,215 1,065 2,000 1,600 101 45100 85 Tiny Tots 10,751 9,184 377 0 0 Eliminated Program in 2010 101 45100 86 Rosettes 1,378 1,595 1,747 1,200 1,700 101 45100 87 Trips 5,642 1,700 916 1,700 1,000 101 45100 88 Broomball 0 0 0 0 0 101 45100 90 Run for the Gold 4,241 4,358 4,693 4,000 4,500 101 45100 91 Camps 16,710 19,254 21,289 19,000 21,000 101 45100 92 Adult Basketball 0 0 0 600 600 101 45100 93 Other Programs 9,987 17,843 17,658 14,500 17,000 101 45100 95 T-Ball 4,371 5,410 4,960 5,000 5,000 101 45100 96 Teen Night 5,279 480 0 0 0 Eliminated Program in 2010 101 45100 97 Adult Soccer League 0 13,702 12,137 10,000 12,000 No League in 2009 101 45100 98 Youth Soccer Lessons 2,875 2,839 3,617 2,600 3,500 107,625 128,707 113,336 101,600 113,900 101 45100 80 219.00 Operating Supplies 0 0 0 1,000 1,000 101 45100 81 103.00 Part-Time Salaries 7,797 7,197 6,149 7,000 6,000 101 45100 81 219.00 Operating Supplies 9,011 12,208 9,041 3,000 9,000 101 45100 81 311.00 Officiating Fees 11,788 26,509 24,574 27,000 25,000 101 45100 81 319.00 Other Professional Services 16,052 5,213 5,113 3,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,475 1,175 1,065 1,500 1,100 101 45100 84 219.00 Operating Supplies 269 41 0 500 500 101 45100 85 103.00 Part-Time Salaries 10,097 8,799 377 0 0 101 45100 85 219.00 Operating Supplies 654 385 0 0 0 101 45100 86 103.00 Part-Time Salaries 575 711 691 400 700 101 45100 86 219.00 Operating Supplies 803 885 1,056 800 1,000 101 45100 87 103.00 Part-Time Salaries 73 0 0 0 0 101 45100 87 219.00 Operating Supplies 1,000 101 45100 87 219.01 Youth/Teen Trips Supplies 920 0 407 0 500 101 45100 87 219.02 Adult/Senior Trips Supplies 4,649 1,700 509 1,700 500 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,241 4,358 4,693 4,000 4,500 101 45100 91 103.00 Part-Time Salaries 7,636 10,236 11,623 10,000 11,000 101 45100 91 219.00 Operating Supplies 9,074 9,018 9,666 9,000 10,000 101 45100 92 219.00 Operating Supplies 0 0 0 600 600 101 45100 93 103.00 Part-Time Salaries 2,469 4,467 2,825 3,000 3,000 101 45100 93 219.00 Operating Supplies 7,318 13,376 14,833 11,500 14,000 101 45100 93 319.00 Other Professional Services 200 0 0 0 0 101 45100 95 103.00 Part-Time Salaries 2,810 3,885 3,514 3,500 3,500 101 45100 95 219.00 Operating Supplies 1,561 1,525 1,445 1,500 1,500 101 45100 96 103.00 Part-Time Salaries 1,011 0 0 0 0 101 45100 96 219.00 Operating Supplies 4,268 480 0 0 0 101 45100 97 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 97 219.00 Operating Supplies 0 1,702 1,637 1,000 1,500 101 45100 97 311.00 Officiating Fees 0 12,000 10,500 9,000 10,500 101 45100 98 103.00 Part-Time Salaries 1,765 1,699 2,377 1,000 2,300 101 45100 98 219.00 Operating Supplies 1,110 1,140 1,240 1,600 1,200 SPECIAL PROGRAM TOTALS 107,625 128,707 113,336 101,600 113,900 GRAND TOTAL-PARK&REC $1,153,777 $1,241,347 $1,252,926 $1,245,800 $1,321,900 41 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. 10 Page One 2013 BUDGET WORKSHEETS OTHER FINANCING USES September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101-49300-01 710.00 Transfers $115,000 $115,000 $477,376 $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 0 323,138 0 0 Excess F/B Transfers FUND TOTALS $115,000 $115,000 $800,514 $115,000 $115,000 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 2013 only. As part of a long-range planning process, a 10-year CIP working plan has been adopted for the years 2013 through 2022. This is a working plan only,with the current year (2013 in this case) being approved as part of the formal budget process. ,,,....=m- N N N N N N N N N N N NNN N N N N N N N N N N N N N N N N N N N m C O O O O O O o 0 0 0 0 0 0 0 C O 0 0 0 0 0 o C C C 0 0 0 0 0 0 0 0 0 m V 3 iHH W m x N W m m A W C W C +W O ON N V ir m N N 3< N N V+N N (O W V O N,W U2-0 0 m? V J mO n o^A Cc w ro N - O O O ,OC oC F c,7, m 1 7�++�-i- +x 3?o1-V m 0DO(N 3,'Nn ZW f Z,f?4'g C °8 m> >J m �' 3 c O O 4 m O , ° °'-Nm O• ce a J7 >=m n E Em 2. '42- „c „EL, Nx> . . . -, 0,. . .9 > > 2p c3 m 0E, m a- Ac.)1ao c 2mc c (o m 3 y aaV_q .V g a m O C m o o- o ' m c y m ono o.o m. E >m 3 3 °.m a F c V A y u 3 ? <m- - J m N d O N J m inn Oo Jmc§ p mN y m . V x m 33 mOc �2oo ov3 _0,n tu* *2 ?„ m ,�m ' . Do=om >TO iom ^o a Vn O v2 g d 3300 -1A4'Am m 3.vmm a_m m n%If 232y3 3 V 'm,- Mc i "#n 9' m38 -( m n mycc ^N D3 ;m ,n oa m T m 2aAm mA a m rm 3 c V m m mu cm n< N o 3 o m m' J .. m-A m x x ? g Tm of Vyo - # 3 AA. c-m _a - 00 mm # . ,=_ 3 N m o2N 3o 35a ;' N + O O J 7 S 3+m m m m A T 3 V ^ - 3 J .a w ym ak mv V 21Ny g =m c"O0 m 31 °" m m D H i AC O ? ^3 g C m _A#W O N<W m W A Q a o c, 3 o m oo°= ° °o° ;!:HL:I m m P o . N mm° D < _ o +_m m g�y �7, E4-9- y w m m m - o z 8 ;m ry n ri m y R m m o m „ -V 2 V V 2 V V V V V V V V V V—..V V V V V V V'^ `T V V V V V W_ E Q D c c c c c c c c c c c c c c`c c c o 0 0 0 c m'm m m m m mo 55,-m HI a n nm*****�****�**�***gym m m m , , w ' c'3 O o 0 0 0 0 0 0 0 0 0 0 0 0 0 o G O o o to m m 4Fi m N N m m 4Fi m Fi m m w N in m Fi w p m Q N N m f J m o A O O n.6 J Q j l f O p °O 00 911' m 'I G J C N Q m o O v m+ N UNi co 90,9 m m a a 0 0 o og 0 0 00 a� m c J O d m 3 3 W C O W A A N W N N N N N N+ A N+ N N C C NON t0 O O W 3 N G o 0 0 0 0 0 0 0 0 0 0 o m o V 000 00 088 o T73 o c o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O G o m 3 0 o 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000 0 0 o G 0 3 c m m 3 0 o N N m Pm m O' N -. ° 0 o O 0 N m m ° ° ...-. + -y @a; m m .Tim 0 N N O 3 pm ° o v o ++ m odm N NJ ma=w m o. �o a 0 m 3.w D. 9 ° ' n=g� O t°4 Q m a 3 3 'm m m m 3 0 m q m 3 a J n K14 m m N C O - ELK ^�J O amm 0 E om m -a N O m- J w m m _.+ O + 0 0 ° ° Mm m n N T O° 0 o ;11 c 8 ° o 8 _y w x o o ° 7x fnm T A ry N o 0 C O J O ill N 0 O J O m 1 - -O o(1' C N N A A N A+ N N C G G G O O 0 O O 88880 88 0 8888 O (0 C G O O O O----000 00000 O ^ /^YrwY„^©^I^u© II ^^u.iai,,,,,,,,MO0 O ”. w 0 0 W Q� N W W W W W W N N N W N A N(n N+O L 0 N N 0 0 0` =V n A G N O N N O O(J'O W W O O N O O N 0 m A+W O N C 0 0 0 O(O O O O O U'O N mg N C O O O O O O O O O O O O O O O W+O O V 0 0 0 G C C C O 0 0 0 0 0 0 0 0 O 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 O C 0 0 0 0 0 0 C 0 0 0 O C 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O G 0 0 0 0 0 0 0 0 0 0 -73 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. ti• Page One 2013 BUDGET WORKSHEETS INSURANCE-REVENUES September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 206 31010.00 Current Ad Valorem Taxes $275,000 $275,000 $245,000 $245,000 $245,000 206 33100.00 Federal Grants&Aids 0 0 0 0 0 206 36210.00 Interest Earnings-Investments 14,596 11,778 8,360 8,000 8,000 206 36214.00 Net Change in FV-Investments 596 (172) 0 0 0 Annual Market Value Changes 206 36215.00 Interest Earnings 654 308 201 300 300 206 36260.00 Other Revenue 38,312 41,905 71,767 38,000 38,000 Insurance Refunds/Dividends 206 36265.00 Use of Reserve Funds 0 0 0 0 0 FUND TOTALS 329,159 328,818 325,328 291,300 291,300 INSURANCE-EXPENDITURES 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 206 49006 01 221.00 Equipment Parts $5,069 $2,621 $10,834 $8,000 $8,000 Liability&Auto Deductible Pymts 206 49006 01 304.00 Legal Fees 500 500 500 500 500 Unreimbursable Legal Fees 206 49006 01 305.00 Medical&Dental Fees 5,071 , 11,850 9,742 12,000 12,000 Work Comp Deductible Pymts 206 49006 01 317.00 General Fund Administrative Fees 2,500 2,500 2,500 2,500 2,500 Yearly Fee Per Policy F-3 206 49006 01 319.00 Other Professional Services 18,300 Risk Management Consultant 206 49006 01 319.01 Risk Management Consultant 6,000 10,500 6,000 6,000 6,000 206 49006 01 319.02 CHESS Consultant 12,300 12,300 12,300 12,300 12,300 206 49006 01 365.00 Worker's Compensation Insurance 95,224 105,374 106,210 110,000 110,000 Annual Premium 206 49006 01 369.00 Other Insurance 165,849 163,362 80,309 85,000 85,000 Annual Premium-General Liability (Changed to High Deductible) 206 49006 01 403.00 Contracted R&M-Other Impr. 0 33,016 0 0 0 Liability&Auto Deductible Pymts 206 49006 01 409.00 Other Contracted Repair&Maint 8,728 8,651 57,602 55,000 55,000 Liability&Auto Deductible Pymts 206 49006 01 439.00 Other Miscellaneous Charges 1,000 1,000 0 0 0 (Changed to High Deductible) FUND TOTALS 302,242 351,675 285,997 291,300 291,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. lr 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. °PO Page One 2013 BUDGET WORKSHEETS PORT AUTHORITY-REVENUES June 5,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 201 31010.00 Current Ad Valorem Taxes $50,000 $50,000 $58,600 $58,600 $58,000 Operating Levy 201 31050.00 Tax Increments 0 0 0 0 0 Admin Fees Portion Only 201 33130.00 Federal Grants-CDBG 0 0 0 0 0 201 33425.00 Other State Grants&Aids 4,474 0 0 0 0 LCDA Downtown Grant 201 34109.00 Other Charges for Services 605 0 0 0 0 Genz-Ryan Tenant Utility Pymts 201 36210.00 Interest Earnings-Investments 824 10 81 500 100 Interest Earned on CD's 201 36215.00 Interest Earnings 265 320 39 200 100 Checking Interest&Misc 201 36230.00 Contributions/Donations 0 0 0 0 0 201 36260.00 Other Revenue 0 0 575 0 0 201 36265.00 Use of Reserve Funds 0 0 0 0 0 201 39101.00 Sales of General Fixed Assets 0 0 0 0 0 FUND TOTALS $56,168 $50,330 $59,295 $59,300 $58,200 EXPENDITURES 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 201 46300 99 103.00 Part-Time Salaries&Benefits $2,468 $3,433 $3,868 $5,000 $5,000 Salary,Taxes,PERA&Benefits Port Authority Members 201 46300 01 303.00 Engineering Fees 1,900 0 4,400 2,000 2,000 201 46300 01 304.00 Legal Fees 565 714 900 3,000 3,000 201 46300 01 317.00 General Fund Administrative Fees 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Policy F-3 201 46300 01 319.00 Other Professional Services 17,400 201 46300 01 319.01 Project Management Consultant 0 0 0 2,000 2,000 201 46300 01 319.02 Marketing-REDE-City Share 416 7,741 10,853 10,000 10,000 Twin Cities Marketing Initiative 201 46300 01 319.03 County TIF Charges 10,112 10,564 0 0 0 201 46300 01 319.04 P/A Property Tax Payments 0 0 0 0 0 201 46300 01 319.05 Other Consultants 0 0 0 5,400 5,400 201 46300 01 319.07 Central Park Survey Work 1,603 0 0 0 0 201 46300 01 322.00 Postage Costs 241 132 87 800 800 201 46300 01 331.00 Travel Expense 0 291 0 0 0 201 46300 01 349.00 Other Advertising 4,644 401 3,972 11,800 11,800 Additional Marketing 201 46300 01 359.00 Other Printing&Binding Costs 365 855 321 3,100 2,000 201 46300 01 365.00 Workers Comp Insurance 488 538 521 500 500 Commissioners 201 46300 01 369.00 Other Insurance 5,154 5,079 2,282 2,000 2,000 Property Insurance 201 46300 01 381.00 Electric Utilities 479 193 223 500 500 Business Park&Other Properties 201 46300 01 383.00 Gas Utilities 1,279 0 0 0 0 Other Properties 201 46300 01 389.00 Other Utility Services 239 0 0 0 0 Utility Fees 201 46300 01 403.00 Contracted Repairs&Maintenance 0 0 0 0 0 201 46300 01 433.00 Dues&Subscriptions 1,700 Prof Organizations/Journals 201 46300 01 433.01 Professional Organizations/Journi 1,674 1,483 2,380 1,700 1,700 201 46300 01 433.02 Foreign Trade Zone Commission 0 0 0 0 0 201 46300 01 437.00 Conferences&Seminars 2,731 3,034 4,125 5,000 5,000 Development/TIF/Miscellaneous 201 46300 01 439.00 Other Miscellaneous Charges 200 86 48 500 500 Contingencies 201 46300 01 521.00 Building&Structure Purchases 0 0 0 0 0 201 46300 01 525.00 Building&Structure Purchases 0 0 0 0 0 201 46300 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 201 46300 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $40,559 $40,543 $39,979 $59,300 $58,200 Page One 2013 BUDGET WORKSHEETS DOWNTOWN/BROCKWAY DISTRICT(0108)-REVENUES June 5,2012 2012 2013 Objecl 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 242 31010.00 Current Ad Valorem Taxes $21,420 $37,968 $46,811 $0 $0 MVHC Payments 242 31050.00 Tax Increments 357,931 410,286 576,675 470,000 554,000 242 33400.00 State Grants&Aids 242,085 1,876 0 0 0 242 33425.00 Other State Grants&Aids 12,551 139,965 0 0 0 242 33620.00 Other County Grants&Aids 0 0 0 0 0 242 36210.00 Interest Earnings-Investments 37 73 724 0 0 242 36215,00 Interest Earnings 294 244 130 0 0 242 36220.00 Rents&Royalties 875 2,425 0 0 0 242 36230.00 Other Revenue 0 0 0 0 0 242 36260.00 Contribution/Donation-Private 0 125 0 0 0 242 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $635,193 $592,961 $624,339 $470,000 $554,000 EXPENDITURES 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 242 49042 01 303.00 Engineering Fees $42,777 $3,690 $0 $0 $0 242 49042 01 304.00 Legal Fees 128 0 0 0 0 242 49042 01 319.00 Other Professional Services 18,129 4,730 16,053 15,000 20,000 County TIF Charges(in 2011) 242 49042 01 522.00 Building&Structure Purchases 57,700 0 103 0 0 242 49042 01 530.00 Improvements Other Than Buildings 160,445 0 0 0 0 242 49042 01 533.00 Waterford Grant Reimbursement 0 139,965 0 0 0 242 49042 01 601.00 Principal on Waterford PAYG 0 0 19,108 48,000 44,000 Waterford Pay-As-You-Go 242 49042 01 611.00 Interest on Waterford PAYG 0 0 63,880 72,000 90,000 Waterford Pay-As-You-Go 242 49042 01 710.00 Transfers 420,000 280,000 350,000 335,000 400,000 P&I for 2008A&2008B Issues FUND TOTALS $699,178 $428,385 $449,144 $470,000 $554,000 DEBT SERVICE FUNDS GENERAL / ADMINISTRATIVE • Debt Service Funds are Governmental Funds set up to provide for the repayment of debt of the City. This debt is normally accomplished through the issuance of bonds secured by the full faith and credit of the City. Repayment of the debt is usually accomplished through the collection of special assessments;general levies of the City collected through property taxes; tax increment funds;core funds; transfers from Enterprise Funds (Revenue Debt Issues) and transfers from other areas. Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 617-G.O.WATER REVENUE BONDS,2000A -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 617 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 617 36101.00 Principal-Special Assessments 0 0 0 0 0 617 36102.00 Penalties&Interest-S/A 0 0 0 0 0 617 36210.00 Interest Earnings-Investments 2,261 190 105 0 0 617 36215.00 Interest Earnings 53 40 13 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 112,000 114,000 114,000 116,000 116,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,314 $114,229 $114,119 $116,000 $116,000 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 617 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 617 47000 01 319.00 Other Professional Services 0 0 0 0 0 617 47000 01 601.00 Bond Principal 75,000 80,000 85,000 90,000 95,000 617 47000 01 611.00 Bond Interest 34,395 30,538 26,397 23,800 19,200 617 47000 01 614.00 Amortization of Bond Discount 1,351 209 0 1,400 1,400 617 47000 01 621.00 Bond Paying Agent Fees 374 374 374 800 400 617 47000 01 710.00 Transfers 0 0 0 0 0 -------------- ---- --- FUND TOTALS $111,120 $111,122 $111,771 $116,000 $116,000 110 . Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 304-G.O.COMMUNITY CENTER REFUNDING BONDS,2001E -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 304 31010.00 Current Ad Valorem Taxes $93,713 $0 $0 $0 $0 304 36101.00 Principal-Special Assessments 0 0 0 0 0 304 36102.00 Penalties&Interest-S/A 0 0 0 0 0 304 36210.00 Interest Earnings-Investments 2,349 2,521 826 0 0 304 36215.00 Interest Earnings 203 101 9 0 0 304 36265.00 Use of Reserve Funds 0 0 0 86,300 87,500 304 37145.00 Surcharge on Water Revenues 0 0 0 0 0 304 39101.00 Sale of General Fixed Assets 0 0 0 0 0 304 39201.00 Transfer From General Fund 0 0 0 0 0 304 39202.00 Contribution From Enterprises 0 0 0 0 0 304 39203.00 Transfer From 0 0 0 0 0 304 39204.00 Transfer From Water Core 0 0 0 0 0 304 39205.00 Transfer From Sewer Core 0 0 0 0 0 304 39206.00 Transfer From Storm Core 0 0 0 0 0 304 39207.00 Transfer From Port Authority 0 0 0 0 0 304 39310.00 Bond Proceeds 0 0 0 0 0 --- -------------- FUND TOTALS $96,265 $2,621 $835 $86,300 $87,500 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 304 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 304 47000 01 319.00 Other Professional Services 0 0 0 0 0 304 47000 01 601.00 Bond Principal 75,000 75,000 80,000 80,000 85,000 304 47000 01 611.00 Bond Interest 15,788 12,619 9,248 5,700 2,000 304 47000 01 621.00 Bond Paying Agent Fees 603 403 403 600 500 304 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $91,390 $88,021 $89,650 $86,300 $87,500 g Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 301 -G.O.CAPITAL IMPROVEMENT PLAN(CIP)BONDS,2005A -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 301 31010.00 Current Ad Valorem Taxes $208,454 $209,846 $0 $211,486 $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 1,234 58 32 0 0 301 36215.00 Interest Earnings 292 113 8 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 0 210,764 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 $209,980 $210,017 $210,805 $211,486 $212,011 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 301 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 301 47000 01 319.00 Other Professional Services 0 0 0 0 0 301 47000 01 601.00 Bond Principal 105,000 105,000 110,000 115,000 120,000 301 47000 01 611.00 Bond Interest 95,365 91,690 87,790 83,600 79,200 301 47000 01 621.00 Bond Paying Agent Fees 403 403 403 500 500 301 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $200,768 $197,093 $198,193 $199,100 $199,700 va Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 610-G.O.WATER REVENUE BONDS,2005C -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 610 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 610 36101.00 Principal-Special Assessments 1,734 0 537 0 0 610 36102.00 Penalties&Interest-S/A 0 0 0 0 0 610 36210.00 Interest Earnings-Investments 31,180 9,353 5,339 0 0 610 36215.00 Interest Earnings 273 144 67 0 0 610 36265.00 Use of Reserve Funds 0 0 0 0 1,238,600 Will Call Bonds 2/1/13 610 37145.00 Surcharge on Water Revenues 0 0 0 0 0 610 37160.00 Penalties-Surcharge Revenues 0 0 0 0 0 610 39201.00 Transfer From General Fund 0 0 0 0 0 610 39202.00 Contribution From Enterprises 0 0 0 0 0 610 39203.00 Transfer From 0 360,000 364,000 0 0 610 39204.00 Transfer From Water Core 360,000 0 0 363,000 115,000 610 39205.00 Transfer From Sewer Core 0 0 0 0 0 610 39206.00 Transfer From Storm Core 0 0 0 0 0 610 39207.00 Transfer From Port Authority 0 0 0 0 0 610 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $393,186 $369,497 $369,944 $363,000 $1,353,600 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 610 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 610 47000 01 319.00 Other Professional Services 0 0 0 0 0 610 47000 01 601.00 Bond Principal 275,000 285,000 295,000 305,000 1,325,000 Will Call Bonds 2/1/13 610 47000 01 611.00 Bond Interest 79,865 69,919 59,623 53,500 24,100 610 47000 01 614.00 Amortization of Bond Discount 3,949 3,949 3,519 4,000 4,000 610 47000 01 621.00 Bond Paying Agent Fees 403 403 403 500 500 610 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $359,216 $359,270 $358,545 $363,000 $1,353,600 ?3 Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 303-G.O.FIRE STATION REFUNDING BONDS,2005D(Old 1996A) -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 303 31010.00 Current Ad Valorem Taxes $146,084 $142,273 $143,654 $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 3,431 233 130 0 0 303 36215.00 Interest Earnings 186 121 134 0 0 303 36265.00 Use of Reserve Funds 0 0 0 135,400 131,400 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 0 355,000 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 $149,701 $497,628 $143,918 $135,400 $131,400 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 303 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 303 47000 01 319.00 Other Professional Services 0 0 0 0 0 303 47000 01 601.00 Bond Principal 105,000 110,000 110,000 115,000 115,000 303 47000 01 611.00 Bond Interest 30,834 27,313 23,655 19,900 15,900 303 47000 01 621.00 Bond Paying Agent Fees 403 403 403 500 500 303 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $136,236 $137,715 $134,058 $135,400 $131,400 Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 326-G.O.IMPROVEMENT BONDS,2006B -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 326 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 326 36101.00 Principal-Special Assessments 139,978 179,754 87,175 0 0 326 36102.00 Penalties&Interest-S/A 7,471 7,889 174 0 0 326 36210.00 Interest Earnings-Investments 4,253 851 1,260 0 0 326 36215.00 Interest Earnings 413 325 130 0 0 326 36265.00 Use of Reserve Funds 0 0 0 334,200 321,700 326 37145.00 Surcharge on Water Revenues 0 0 0 0 0 326 37160.00 Penalties-Surcharge Revenues 0 0 0 0 0 326 39201.00 Transfer From General Fund 0 0 0 0 0 326 39202.00 Contribution From Enterprises 0 0 0 0 0 326 39203.00 Transfer From 0 447,635 0 0 0 326 39204.00 Transfer From Water Core 200,000 200,000 200,000 200,000 200,000 326 39205.00 Transfer From Sewer Core 0 0 0 0 0 326 39206.00 Transfer From Storm Core 0 0 0 0 0 326 39208.00 Transfer From Street CIP 0 1,000,000 0 0 0 326 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $352,115 $1,836,454 $288,738 $534,200 $521,700 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 326 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 326 47000 01 319.00 Other Professional Services 0 0 0 0 0 326 47000 01 601.00 Bond Principal 425,000 425,000 430,000 435,000 440,000 326 47000 01 611.00 Bond Interest 150,100 133,100 116,000 98,700 81,200 326 47000 01 621.00 Bond Paying Agent Fees 431 431 431 500 500 326 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $575,531 $558,531 $546,431 $534,200 $521,700 8‘ Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 611 -G.O.WATER REVENUE BONDS,2007A -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 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 198 233 130 0 0 611 36215.00 Interest Eamings 158 58 26 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 131,947 148,000 0 0 0 611 39204.00 Transfer From Water Core 135,000 0 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 $267,303 $148,291 $154,156 $154,000 $154,000 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 611 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 611 47000 01 319.00 Other Professional Services 0 0 0 0 0 611 47000 01 601.00 Bond Principal 85,000 105,000 110,000 115,000 120,000 611 47000 01 611.00 Bond Interest 45,283 41,150 36,767 34,100 29,400 611 47000 01 614.00 Amortization of Bond Discount (2,574) (2,574) (2,574) 600 300 611 47000 01 621.00 Bond Paying Agent Fees 4,210 4,210 4,210 4,300 4,300 611 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $131,919 $147,786 $148,403 $154,000 $154,000 Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 322-G.O.EQUIPMENT CERTIFICATES,2007B -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 322 31010.00 Current Ad Valorem Taxes $102,908 $105,079 $0 $0 $0 322 36101.00 Principal-Special Assessments 0 0 0 0 0 322 36102.00 Penalties&Interest-S/A 0 0 0 0 0 322 36210.00 Interest Earnings-Investments 560 229 151 0 0 322 36215.00 Interest Earnings 184 106 34 0 0 322 36265.00 Use of Reserve Funds 0 0 0 100,800 102,300 322 37145.00 Surcharge on Water Revenues 0 0 0 0 0 322 37160.00 Penalties-Surcharge Revenues 0 0 0 0 0 322 39201.00 Transfer From General Fund 185,000 0 0 0 0 322 39202.00 Contribution From Enterprises 0 0 0 0 0 322 39203.00 Transfer From 0 0 0 0 0 322 39204.00 Transfer From Water Core 0 0 0 0 0 322 39205.00 Transfer From Sewer Core 0 0 0 0 0 322 39206.00 Transfer From Storm Core 0 0 0 0 0 322 39207.00 Transfer From Port Authority 0 0 0 0 0 322 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $288,652 $105,414 $185 $100,800 $102,300 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 322 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 322 47000 01 319.00 Other Professional Services 0 0 0 0 0 322 47000 01 601.00 Bond Principal 80,000 85,000 90,000 95,000 100,000 322 47000 01 611.00 Bond Interest 14,388 11,541 8,500 5,300 1,800 322 47000 01 621.00 Bond Paying Agent Fees 431 431 431 500 500 322 47000 01 710.00 Transfers 0 0 0 0 0 ----- -- ---------------- FUND TOTALS $94,819 $96,973 $98,931 $100,800 $102,300 ii), . Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 381-G.O.TAXABLE TIF 2008A&G.O.TIF 2008B -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 381 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 381 31050.00 Tax Increments 0 0 0 0 0 381 36101.00 Principal-Special Assessments 0 0 0 0 0 381 36102.00 Penalties&Interest-S/A 0 0 0 0 0 381 36210.00 Interest Earnings-Investments 0 0 0 0 0 381 36215.00 Interest Earnings 86 45 63 0 0 381 36265.00 Use of Reserve Funds 0 0 0 0 0 381 37145.00 Surcharge on Water Revenues 0 0 0 0 0 381 37160.00 Penalties-Surcharge Revenues 0 0 0 0 0 381 39201.00 Transfer From General Fund 0 0 0 0 0 381 39202.00 Contribution From Enterprises 0 0 0 0 0 381 39203.00 Transfer From 0 0 0 0 0 381 39204.00 Transfer From Water Core 0 0 0 0 0 381 39205.00 Transfer From Sewer Core 0 0 0 0 0 381 39206.00 Transfer From Storm Core 0 0 0 0 0 381 39207.00 Transfer From Port Authority 420,000 280,000 350,000 320,000 350,000 381 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $420,086 $280,045 $350,063 $320,000 $350,000 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 381 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 381 47000 01 319.00 Other Professional Services 0 0 0 0 0 381 47000 01 601.00 Bond Principal 0 0 0 35,000 75,000 381 47000 01 611.00 Bond Interest 276,635 276,635 276,635 275,800 273,100 381 47000 01 621.00 Bond Paying Agent Fees 850 850 850 900 900 381 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $277,485 $277,485 $277,485 $311,700 $349,000 i)Y . Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 323-G.O.EQUIPMENT CERTIFICATES,2008A -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 323 31010.00 Current Ad Valorem Taxes $88,457 $92,157 $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 0 313 207 0 0 323 36215.00 Interest Earnings 96 66 23 0 0 323 36265.00 Use of Reserve Funds 0 0 0 88,700 85,000 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 256,000 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 $344,553 $92,535 $229 $88,700 $85,000 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 323 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 323 47000 01 319.00 Other Professional Services 0 0 0 0 0 323 47000 01 601.00 Bond Principal 0 65,000 75,000 80,000 80,000 323 47000 01 611.00 Bond Interest 11,564 14,065 11,272 8,200 5,000 323 47000 01 621.00 Bond Paying Agent Fees 0 0 0 500 0 323 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $11,564 $79,065 —$86,272 $88,700 $85,000 Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 614-G.O.UTILITY REVENUE REFUNDING BONDS,2010A(2001B,2002B&2003B) -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 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 0 6,810 0 0 614 36102.00 Penalties&Interest-S/A 0 0 0 0 0 614 36210.00 Interest Earnings-Investments 0 0 411 0 0 614 36215.00 Interest Earnings 1 0 56 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 0 60,000 84,000 89,000 614 39203.00 Transfer From 0 0 31,201 0 0 614 39204.00 Transfer From Water Core 0 0 16,000 148,000 155,000 614 39205.00 Transfer From Sewer Core 0 0 0 0 0 614 39206.00 Transfer From Storm Core 0 0 60,000 84,000 89,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 $1 $0 $174,479 $316,000 $333,000 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 614 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 614 47000 01 319.00 Other Professional Services 0 0 0 0 0 614 47000 01 601.00 Bond Principal 0 0 0 290,000 310,000 614 47000 01 611.00 Bond Interest 0 1,943 23,313 22,200 19,300 614 47000 01 614.00 Amortization of Bond Discount 0 2,643 2,643 2,700 2,700 614 47000 01 621.00 Bond Paying Agent Fees 0 0 7,337 500 500 614 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $0 $4,586 $33,293 $315,400 $332,500 90 Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 383-G.O.PORT AUTHORITY PUBLIC FACILITY REFUNDING BONDS,2010B(2001C) -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 383 31010.00 Current Ad Valorem Taxes $0 $0 $0 $166,893 $165,383 383 36101.00 Principal-Special Assessments 0 0 0 0 0 383 36102.00 Penalties&Interest-S/A 0 0 0 0 0 383 36210.00 Interest Earnings-Investments 0 1,414 0 0 0 383 36215.00 Interest Earnings 0 0 3 0 0 383 36260.00 Other Revenue 0 0 2,871 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 0 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 0 1,355,000 0 0 0 FUND TOTALS $0 $1,356,414 $2,875 $166,893 $165,383 -EXPENDITURES- 2012 2013 2009 2010 2011 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 0 34,732 0 0 0 383 47000 01 601.00 Bond Principal 0 0 0 0 125,000 All payments prior to 2/1/12 383 47000 01 611.00 Bond Interest 0 0 20,337 34,000 33,300 come from an escrow fund 383 47000 01 621.00 Bond Paying Agent Fees 0 11,179 0 500 500 383 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $0 $45,911 $20,337 $34,500 $158,800 9t Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 327-G.O.IMPROVEMENT BONDS,2011A -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 327 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 327 36101.00 Principal-Special Assessments 0 0 0 0 0 327 36102.00 Penalties&Interest-S/A 0 0 0 0 0 327 36210.00 Interest Earnings-Investments 0 0 22 0 0 327 36215.00 Interest Earnings 0 0 4 0 0 327 36265.00 Use of Reserve Funds 0 0 0 14,500 423,300 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 0 9,876 0 0 FUND TOTALS $0 $0 $9,902 $14,500 $423,300 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 327 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 327 47000 01 319.00 Other Professional Services 0 0 0 0 0 327 47000 01 601.00 Bond Principal 0 0 0 0 405,000 327 47000 01 611.00 Bond Interest 0 0 0 14,000 17,800 327 47000 01 621.00 Bond Paying Agent Fees 0 0 0 500 500 327 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $0 $0 $0 $14,500 $423,300 Page One 2013 BUDGET WORKSHEETS DEBT SERV FUND 328-G.O.IMPROVEMENT BONDS,2012A -REVENUES- September 4,2012 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 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 0 0 0 328 36215.00 Interest Earnings 0 0 0 0 0 328 36265.00 Use of Reserve Funds 0 0 0 0 5,500 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 0 0 0 FUND TOTALS $0 $0 $0 $0 $5,500 -EXPENDITURES- 2012 2013 2009 2010 2011 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 328 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 328 47000 01 319.00 Other Professional Services 0 0 0 0 0 328 47000 01 601.00 Bond Principal 0 0 0 0 0 328 47000 01 611.00 Bond Interest 0 0 0 0 5,000 328 47000 01 621.00 Bond Paying Agent Fees 0 0 0 0 500 328 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $0 $0 $0 $0 $5,500 g3 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 125 miles of water main. PERFORMANCE MEASURES Operating Cost Per 1,000,000 Gallons of Water Pumped/Produced (**) 2007 2008 2009 2010 2011 2012(est) n/a n/a n/a $1,132 $1,392 $1,400 (**) —Required Performance Measures for State Program n/a—Information Not Available Page One 2013 BUDGET WORKSHEETS WATER UTILITY -REVENUES- July 9,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 33425.00 Other State Grants&Aids $0 $1,208 $0 $0 $0 601 34108.00 Administrative Fees-Other Funds 4,655 590 2,123 0 0 5%of 5%Fees-Const Projects 601 34109.00 Other Gen'I Govt Chgs for Services 2,500 10,380 0 0 0 601 36101.00 Principal-Special Assessments 56,332 48,772 54,354 50,000 50,000 601 36102.00 Penalties&Interest-S/A 280 10,808 (5,989) 0 0 601 36210.00 Interest Earnings-Investments 77,357 72,361 60,496 60,000 60,000 601 36214.00 Net Change in FV-Investments 1,691 (6,319) 3,794 0 0 Annual Market Value Changes 601 36215.00 Interest Earnings 980 736 1,280 1,000 1,000 601 36220.00 Rents&Royalties 51,646 70,594 80,745 65,000 80,000 Antenna Leases 601 36260.00 Other Revenues 0 0 750 0 0 601 36265.00 Use of Reserve Funds 0 0 0 0 0 601 37110.00 Residential Water Revenues 919,742 999,856 1,079,507 1,050,000 1,050,000 601 37120.00 Apartment Water Revenues 75,721 71,064 75,444 70,000 73,000 601 37125.00 Institutional Water Revenues 36,079 72,159 70,470 50,000 70,000 601 37130.00 Commercial Water Revenues 56,092 71,616 71,131 60,000 65,000 601 37140.00 Industrial Water Revenues 56,702 64,269 73,851 60,000 70,000 601 37160.00 Penalties-Water Revenues 8,750 8,861 9,378 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 30,714 32,138 27,498 30,000 30,000 601 39103.00 Gain or Loss from F/A Disposal (3,290) 0 (1,532) 0 0 601 39203.00 Transfer From 0 0 0 0 0 FUND TOTALS $1,375,951 $1,529,091 $1,603,302 $1,504,000 $1,557,000 1 Page One 2013 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- July 9,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of-�- 601 49400 101.00 Salaries&Benefits $411,400 Salary,Taxes,PERA&Benefits 601 49400 77 101.00 Administrative 117,241 117,561 110,344 113,600 107,300 601 49400 78 101.00 Technical/Clerical 161,253 158,239 136,304 144,100 144,000 601 49400 79 101.00 Maintenance 131,861 137,759 138,854 141,400 160,100 601 49400 xx 101.00 Salary&Benefit Contingency 0 0 0 6,600 0 601 49400 102.00 Full-Time Overtime 6,851 8,493 9,378 7,500 8,000 601 49400 103.00 Part-Time Salaries&Benefits 10,979 8,521 6,289 8,000 8,000 601 49400 99 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,576 1,832 1,196 2,000 2,000 Inserts&Water Bill Statements 601 49400 01 209.00 Other Office Supplies 190 97 238 200 200 Disks,Ribbons,etc. 601 49400 01 216.00 Chemicals&Chemical Products 66,479 62,382 59,746 65,000 65,000 Chlorine,Flouride,Polyphos 601 49400 01 219.00 Other Operating Supplies 0 0 465 200 200 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 40,000 Meters,MIU's&CU Horns 601 49400 01 220.01 For Replacements 912 6,275 0 10,000 10,000 Water Rate Model 601 49400 01 220.02 For New Homes 12,333 53,511 23,283 25,400 30,000 Water Rate Model(3%Growth) 601 49400 01 224.00 Street Maintenance Materials 524 1,468 3,720 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 68 0 279 500 500 Topsoil,Seed&Sod 601 49400 01 228.00 Meter Repair Materials 0 0 0 300 300 Miscellaneous Meter Parts 601 49400 01 229.00 Other Maintenance Supplies 14,200 601 49400 01 229.01 Supplies for Hydrants 5,546 5,398 5,849 5,500 6,000 601 49400 01 229.02 Valve&Curb Boxes 226 1,355 554 1,300 1,000 601 49400 01 229.03 Valve Replacement/Inspection 91 0 0 2,200 2,200 601 49400 01 229.04 Miscellaneous Supplies 1,722 2,035 4,626 5,000 5,000 601 49400 01 241.00 Small Tools 2,393 1,607 1,513 2,000 2,000 Wrenches,Shovels,etc. 601 49400 01 242.00 Minor Equipment 3,000 601 49400 01 242.01 Miscellaneous Purchases 1,684 2,897 2,095 3,000 3,000 601 49400 01 303.00 Engineering Fees 30,000 601 49400 01 303.01 Water Conserv'n&Emergency 0 0 0 0 0 601 49400 01 303.02 GIS 9,103 0 0 22,000 10,000 601 49400 01 303.03 Rate Study 0 159 0 0 0 601 49400 01 303.04 Miscellaneous Fees 38,195 30,959 40,828 12,000 20,000 601 49400 01 304.00 Legal Fees 282 0 94 1,000 1,000 601 49400 01 310.00 Testing Services 44,000 601 49400 01 310.01 Bacteria&Water Quality 1,560 1,616 1,734 2,000 2,000 Radon,Tri-Chl. 601 49400 01 310.02 V.O.C.,Pesticides,etc. 0 0 1 1,000 1,000 601 49400 01 310.03 CU-PB Testing 38,454 40,487 40,901 40,000 41,000 $6.36/Connection-Annual Fee(M) 601 49400 01 312.00 Gopher State One-Call 2,346 2,315 2,098 3,500 3,500 Gopher State One-Call(M) 601 49400 01 313.00 Temporary Service Fees 0 1,913 23,401 0 0 601 49400 01 315.00 Special Programs 0 601 49400 01 315.01 Public Information 0 0 0 5,500 0 601 49400 01 315.02 Plan Amendments 0 0 0 5,000 0 601 49400 01 315.03 Seminars 0 0 0 1,000 0 601 49400 01 318.00 Contract Engineer 6,000 6,000 7,000 6,000 7,000 Contracted Engineer for City(20%) 601 49400 01 319.00 Other Professional Services 18,600 601 49400 01 319.01 Thaw Pipes,Check Leaks,etc. 3,061 870 200 1,500 1,500 601 49400 01 319.02 Supervisory Controls 500 7,329 3,015 5,000 5,000 SCADA 601 49400 01 319.03 Hazardous Chemical Permits 525 0 0 1,000 1,000 MN Department of Public Safety 601 49400 01 319.04 Annual Drinking Water Report 0 0 0 2,500 0 No more Printing/Mailing Costs 601 49400 01 319.05 Hazardous Chemical Inventory 100 0 0 1,100 1,100 601 49400 06 319.06 Contracted Hydrant Painting 7,412 9,996 9,800 10,000 10,000 120 Hydrants/Yr($82 each) 601 49400 01 321.00 Telephone Costs 3,261 2,284 2,354 2,500 2,500 Cell Phones,Modesm,GPS 601 49400 01 322.00 Postage Costs 4,214 4,299 4,504 6,000 5,000 Billings with Inserts 601 49400 01 323.00 Radio Units 729 1,083 1,211 1,500 1,500 24 Units*$280(Split 5 Ways) 601 49400 01 333.00 Freight&Express Expenses 0 0 0 100 100 Mail-in Repairs 601 49400 01 341.00 Employment Advertising 0 0 0 0 0 PIT'ers&Personnel Changes 601 49400 01 349.00 Other Advertising 0 0 0 500 500 601 49400 01 352.00 General Notices&Public Info 0 0 0 500 500 Newsletters 601 49400 01 365.00 Workers Comp Insurance 6,325 6,641 7,089 6,000 6,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 20,713 19,414 10,487 20,000 20,000 Water's Share of Premiums 601 49400 01 391.00 P.C.Maintenance 446 467 491 3,000 2,700 601 49400 01 391.01 U/B Software Maintenance 0 0 0 0 2,000 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 0 0 0 0 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C.Accessories&Supplies 392 359 128 200 200 601 49400 01 393.00 P.C.Hardware Purchases 8,414 11,488 320 3,300 4,000 New GPS Unit,Server Upgrades 601 49400 01 394.00 P.C.Software Purchases 4,574 5,378 4,574 9,500 601 49400 01 394.01 Licensing&Maintenance 0 0 0 4,600 4,800 Cartegraph,GIS 601 49400 01 394.02 Online Subscriptions 0 0 0 300 300 Pictometry 601 49400 01 394.03 New Software Purchases 0 0 0 4,000 4,400 CG Upgrades(Your GOV,Mobile) 601 49400 01 395.00 P.C.Repairs 0 0 0 500 500 ------------------------------ ---- - ---------- PAGE TOTALS 678,534 722,489 664,963 719,400 714,400 96 Page Two 2013 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- July 9,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49400 01 403.00 Contracted R&M-Other Impr 5,245 970 10,544 6,000 6,000 Watermain Breaks 601 49400 01 416.00 Machinery Rental 0 0 0 2,000 1,000 601 49400 01 433.00 Dues&Subscriptions 1,796 1,794 45 1,800 1,800 Suburban Utility Supt Assn,AWWA 601 49400 01 435.00 Books&Pamphlets 0 0 0 300 300 Reference Materials 601 49400 01 437.00 Conferences&Seminars 3,000 601 49400 01 437.01 MN Health Department School 586 778 588 1,000 1,000 Water School,50%Split w/602(M) 601 49400 01 437.02 AWWA Conference 135 0 0 500 500 New CG Mobile S/W Training 601 49400 01 437.03 CarteGraph,ESRI,GIS 0 0 157 1,300 1,500 User Group,Conference,Training 601 49400 01 439.00 Other Miscellaneous Charges 15,850 12,741 15,235 15,000 15,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(15 of 20) 601 49400 01 530.00 Improvements Other Than Bldgs 305,600 601 49400 01 530.01 Well Inspections 16,653 560 560 0 600 Move Recon to Individual Wells 601 49400 01 530.02 Miscellaneous Improvements 0 5,237 0 10,000 5,000 601 49400 01 530.03 CRP of Watermain 318,026 0 0 150,000 150,000 Annual Pavement Management 601 49400 01 530.04 Tower Inspection,Maintenance 3,000 0 0 154,000 150,000 Interior Paint-East Side Tower 601 49400 01 560.00 Furniture&Fixture Purchases 0 0 0 0 0 601 49400 01 570.00 Office Equipment Purchases 0 42 0 1,000 1,000 601 49400 01 586.00 Computer Equipment Purchases 0 0 0 0 0 601 49400 01 611.00 Interest on Lease Payments 3,861 3,554 3,232 0 0 P.W.Building Expansion(See 521) 601 49400 01 710.00 Transfers 0 0 298,666 0 0 Transfers for Other Improvements 601-49400-01 TOTALS 1,043,686 748,165 993,991 1,072,300 1,058,100 601 49406 01 221.00 Equipment Parts 0 77 512 500 500 601 49406 01 223.00 Building Repair Supplies 0 0 0 500 200 601 49406 01 319.00 Other Professional Services 0 0 0 1,000 1,000 601 49406 01 381.00 Electric Utilities 1,245 1,003 1,304 1,000 1,300 Pumping&Lighting P 9 9 9 601 49406 01 383.00 Gas Utilities 0 0 0 0 0 Heat Only TOTAL-EAST SIDE W/M VAULT 1,245 1,080 1,816 3,000 3,000 601 49407 01 221.00 Equipment Parts 2,259 720 779 1,200 2,000 Chlorinator($1300) 601 49407 01 223.00 Building Repair Supplies 0 0 0 300 200 601 49407 01 319.00 Other Professional Services 0 0 0 0 0 601 49407 01 321.00 Telephone Costs 211 211 211 0 300 601 49407 01 381.00 Electric Utilities 20,002 19,548 18,322 22,000 22,000 Pumping&Lighting 601 49407 01 409.00 Other Contracted Repairs&Maint 0 0 3,741 600 4,500 Vapor Lights,Wash,Antenna Cable 601 49407 01 439.00 Other Miscellaneous Charges 0 0 100 100 100 Contingencies 601 49407 01 530.00 Improvements Other Than Bldgs 0 0 3,219 0 0 ---------- ---------------- ------ ------- TOTAL-WELL#7 22,472 20,479 26,370 24,200 29,100 601 49408 01 221.00 Equipment Parts 45 491 2,390 1,500 2,000 Chlorinator($1300) 601 49408 01 223.00 Building Repair Supplies 0 0 0 500 200 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 601 49408 01 381.00 Electric Utilities 9,881 3,060 14,969 13,000 15,000 Pumping&Lighting 601 49408 01 383.00 Gas Utilities 598 497 468 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs&Maint 0 0 0 0 7,000 Roof,Windows,Gutters,Lights 601 49408 01 439.00 Other Miscellaneous Charges 0 0 100 0 100 Contingencies 601 49408 01 530.00 Improvements Other Than Bldgs 0 11,700 1,809 0 1,000 Blacktop Pad for Generator TOTAL-WELL#8 10,524 15,748 19,736 15,600 25,900 601 49409 01 221.00 Equipment Parts 2,998 10,602 1,009 1,500 3,000 2 Chlorinators($1300 Each) 601 49409 01 223.00 Building Repair Supplies 0 34 0 100 200 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 601 49409 01 381.00 Electric Utilities 23,439 20,988 27,268 25,000 28,000 Pumping&Lighting 601 49409 01 383.00 Gas Utilities 737 609 547 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs&Maint 0 0 0 0 2,000 Gutters,Paint Generator&Door 601 49409 01 439.00 Other Miscellaneous Charges 0 0 100 100 100 Contingencies 601 49409 01 530.00 Improvements Other Than Bldgs 0 13,000 1,809 0 22,500 Pump Recondition for 2013 TOTAL-WELL#9 27,174 ---45,234 30,732 28,200 57,300 97 Page Three 2013 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- July 9,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49410 01 219.00 Other Operating Supplies 0 0 0 500 500 601 49410 01 221.00 Equipment Parts 6,535 4,150 1,469 500 3,500 Chlorinator,Dehumidifier 601 49410 01 223.00 Building Repair Supplies 23 0 9 100 200 601 49410 01 321.00 Telephone Costs 750 765 765 0 800 601 49410 01 381.00 Electric Utilities 12,881 12,182 12,489 14,000 14,000 Pumping&Lighting 601 49410 01 409.00 Other Contracted Repairs&Maint 0 0 0 0 1,500 Gutters 601 49410 01 439.00 Other Miscellaneous Charges 0 0 50 0 100 Contingencies 601 49410 01 530.00 Improvements Other Than Bldgs 0 0 0 0 1,000 Blacktop Pad for Generator TOTAL-WELL#10 20,189 17,097 14,782 15,100 21,600 Rural Water System 601 49411 01 221.00 Equipment Parts 4,118 1,426 1,565 0 0 601 49411 01 381.00 Electric Utilities 0 0 0 0 0 Pumping&Lighting 601 49411 01 439.00 Other Miscellaneous Charges 0 0 50 0 0 TOTAL-WELL#11 4,118 1,426 1,615 0 0 Rural Water System(#2) 601 49412 01 221.00 Equipment Parts 1,006 550 1,134 1,000 1,000 601 49412 01 223.00 Building Repair Supplies 0 0 0 500 200 601 49412 01 319.00 Other Professional Services 0 0 0 0 0 601 49412 01 381.00 Electric Utilities 20,959 15,214 19,190 25,000 25,000 Pumping&Lighting 601 49412 01 383.00 Gas Utilities 0 0 0 1,500 0 Electricity Only 601 49412 01 409.00 Other Contracted Repairs&Maint 0 0 6,101 0 5,000 Gutters,Painting,Vapor Lights 601 49412 01 439.00 Other Miscellaneous Charges 0 0 100 100 100 Contingencies TOTAL-WELL#12 21,965 15,764 26,525 28,100 31,300 601 49414 01 221.00 Equipment Parts 193 1,545 1,104 500 500 601 49414 01 223.00 Building Repair Supplies 0 0 0 100 200 601 49414 01 319.00 Other Professional Services 3,973 0 0 1,000 1,000 601 49414 01 381.00 Electric Utilities 26,936 27,328 29,008 30,000 30,000 Pumping&Lighting 601 49414 01 383.00 Gas Utilities 0 0 0 1,000 0 Electricity Only 601 49414 01 409.00 Other Contracted Repairs&Maint 0 0 2,138 0 3,000 Gutters,Painting,Vapor Lights 601 49414 01 439.00 Other Miscellaneous Charges 0 0 100 100 100 Contingencies 601 49414 01 530.00 Improvements Other Than Bldgs 0 0 0 0 22,500 Pump Recondition for 2013 TOTAL-WELL#14 31,102 28,872 32,349 32,700 57,300 601 49425 01 221.00 Equipment Parts 346 1,962 1,096 500 500 601 49425 01 223.00 Building Repair Supplies 0 0 0 100 200 601 49425 01 319.00 Other Professional Services 0 0 353 500 500 601 49425 01 381.00 Electric Utilities 25,492 27,050 25,190 30,000 30,000 Pumping&Lighting 601 49425 01 383.00 Gas Utilities 0 0 0 1,000 0 Electricity Only 601 49425 01 409.00 Other Contracted Repairs&Maint 0 0 0 0 2,500 Gutters,Lights,Electrical 601 49425 01 439.00 Other Miscellaneous Charges 0 0 48 100 100 Contingencies 601 49425 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL-WELL#15 25,838 29,012 26,687 32,200 33,800 g Page Four 2013 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- July 9,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49415 01 221.00 Equipment Parts 1,151 600 122 500 500 Touch-up Paint 601 49415 01 319.00 Other Professional Services 0 0 0 0 0 Tower Inspection 601 49415 01 381.00 Electric Utilities 0 0 0 0 0 601 49415 01 409.00 Other Contracted Repairs&Maint 0 0 0 500 500 601 49415 01 439.00 Other Miscellaneous Charges 0 0 100 200 200 Contingencies 601 49415 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 - TOTAL-WATER TOWER#1 1,151 600 222 1,200 (Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 3,428 383 2,500 500 500 Touch-up Paint 601 49416 01 319.00 Other Professional Services 882 0 0 0 0 Tower Inspection 601 49416 01 321.00 Telephone Costs 0 0 0 0 0 601 49416 01 381.00 Electric Utilities 1,392 1,325 712 1,400 1,400 601 49416 01 409.00 Other Contracted Repairs&Maint 1,323 0 2,945 500 500 601 49416 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 49416 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL-WATER TOWER#2 7,025 1,708 6,158 2,600 2,600 (Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 615 28 4,261 500 500 601 49417 01 319.00 Other Professional Services 5,853 0 0 0 0 Tower Inspection 601 49417 01 321.00 Telephone Costs 0 0 0 0 0 601 49417 01 381.00 Electric Utilities 4,723 4,539 4,267 2,000 2,000 601 49417 01 409.00 Other Contracted Repairs&Maint 0 0 122 500 500 601 49417 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 49417 01 530.00 Improvements Other Than Bldgs 0 0 0 300 300 Contingencies TOTAL-WATER TOWER#4 11,191 4,567 8,651 3,500 3,500 (Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 1,920 0 0 500 500 601 49418 01 319.00 Other Professional Services 0 0 0 0 0 Tower Inspection 601 49418 01 321.00 Telephone Costs 0 0 0 0 0 601 49418 01 381.00 Electric Utilities 2,160 1,885 1,648 2,000 5,000 601 49418 01 409.00 Other Contracted Repairs&Maint 0 3,000 0 500 500 601 49418 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 49418 01 530.00 Improvements Other Than Eldgs 0 0 0 0 0 ---------- ------- ----- ------ ------- TOTAL-WATER TOWER#3 4,080 4,885 1,648 3,200 6,200 (East Side Water Tower) GRAND TOTAL-ALL DEPTS. $1,231,760 $934,635 $1,191,281 $1,261,900 $1,330,900 9q 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 6,400 service connections for the collection and treatment of sewage. $1,030,000 covers one line item of the 2013 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 2007 2008 2009 2010 2011 2012(est) 22.0% 31.2% 25.6% 31.7% 31.3% 33% Number of Sewer Blockages on City System Per 100 Connections (**) 2007 2008 2009 2010 2011 2012 n/a n/a n/a 0.08 0.0 n/a (**) —Required Performance Measures for State Program n/a—Information Not Available /00 Page One 2013 BUDGET WORKSHEETS SEWER UTILITY -REVENUES- July 9,2012 2012 2013 Objecl 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 33425.00 Other State Grants&Aids $0 $1,208 $0 $0 $0 602 34108.00 Administrative Fees-Other Funds 4,655 590 2,123 0 0 5%of 5%Fees-Const Projects 602 36101.00 Principal-Special Assessments 78,438 69,472 77,214 70,000 75,000 602 36102.00 Penalties&Interest-S/A 534 0 2,775 0 0 602 36210.00 Interest Earnings-Investments 65,357 58,124 40,077 60,000 50,000 602 36214.00 Net Change in FV-Investments (1,399) (2,364) 3,447 0 0 Annual Market Value Changes 602 36215.00 Interest Earnings 1,093 754 282 1,000 500 602 36260.00 Other Revenues 0 0 2,212 0 0 602 36265.00 Use of Reserve Funds 0 0 0 154,400 268,300 602 37210.00 Residential Sewer Revenues 1,115,312 1,080,354 1,135,626 1,270,000 1,150,000 602 37220.00 Apartment Sewer Revenues 91,567 95,269 101,697 90,000 100,000 602 37225.00 Institutional Sewer Revenues 21,059 21,443 22,231 20,000 21,000 602 37230.00 Commercial Sewer Revenues 55,305 61,252 63,367 55,000 61,000 602 37240.00 Industrial Sewer Revenues 56,341 47,286 47,106 50,000 47,000 602 37260.00 Penalties-Sewer Revenues 10,994 11,308 11,327 10,000 10,000 602 39103.00 Gain or Loss from F/A Disposal (5,111) 0 (3,421) 0 0 602 39203.00 Transfer From 0 0 0 0 0 FUND TOTALS $1,494,146 $1,444,695 $1,506,064 $1,780,400 $1,782,800 /o1 Page One 2013 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- July 9,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 602 49450 101.00 Salaries&Benefits $411,400 Salary,Taxes,PERA&Benefits 602 49450 77 101.00 Administrative 116,971 117,536 110,563 113,600 107,300 602 49450 78 101.00 Technical/Clerical 161,240 158,239 136,305 144,100 144,000 602 49450 79 101.00 Maintenance 131,861 137,759 138,718 141,400 160,100 602 49450 xx 101.00 Salary&Benefit Contingency 0 0 0 6,600 0 602 49450 102.00 Full-Time Overtime 6,850 8,493 9,029 7,500 7,500 602 49450 103.00 Part-Time Salaries&Benefits 11,990 8,291 8,880 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,418 1,258 1,195 1,500 1,500 Inserts&Water Bill Statements 602 49450 01 209.00 Other Office Supplies 0 0 0 200 200 Disks,Ribbons,etc. 602 49450 01 216.00 Chemicals&Chemical Products 0 0 0 500 500 Root Killer,Degreaser 602 49450 01 219.00 Other Operating Supplies 362 0 0 200 200 602 49450 01 224.00 Street Maintenance Materials 1,333 1,550 1,425 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 Supplier 410 667 18 3,000 5,000 MH Castings Replacement Prog. 602 49450 01 241.00 Small Tools 346 185 417 500 500 Wrenches,Shovels,etc. 602 49450 01 242.00 Minor Equipment 2,198 2,897 1,285 3,000 3,000 602 49450 01 303.00 Engineering Fees 20,000 602 49450 01 303.01 GIS 2,786 121 129 22,000 5,000 602 49450 01 303.02 Rate Study 0 0 0 0 0 602 49450 01 303.03 42/52 Sewer Study 0 0 0 0 0 602 49450 01 303.04 Miscellaneous 17,327 4,721 4,148 15,000 15,000 Sewer Repairs 602 49450 01 304.00 Legal Fees 0 0 0 500 500 602 49450 01 312.00 Gopher State One-Call 2,346 2,315 2,092 4,000 3,500 Gopher State One-Cat(M) 602 49450 01 313.00 Temporary Service Fees 0 1,913 14,559 0 0 602 49450 01 318.00 Contract Engineer 6,000 6,000 7,000 6,000 7,000 Contracted Engineer for City(20%) 602 49450 01 319.00 Other Professional Services 10,000 602 49450 01 319.01 Televising 2,028 1,550 1,720 3,000 3,000 602 49450 01 319.02 Root Control 399 2,307 0 2,000 2,000 602 49450 01 319.03 Supervisory Controls(Maint Cont) 0 0 3,356 5,000 5,000 SCADA System 602 49450 01 321.00 Telephone Costs 3,261 2,284 2,312 2,500 2,500 Cell Phones,Modems,GPS 602 49450 01 322.00 Postage Costs 4,214 4,299 4,504 3,500 5,000 Billings with Inserts 602 49450 01 323.00 Radio Units 729 1,083 1,211 1,500 1,500 24 Units*$280(Split 5 Ways) 602 49450 01 331.00 Travel Expense 0 0 0 200 0 Use 437.00 602 49450 01 333.00 Freight&Express Expenses 0 0 0 100 100 Mail-in Repairs 602 49450 01 341.00 Employment Advertising 0 0 0 300 300 P/T'ers&Personnel Changes 602 49450 01 349.00 Other Advertising 0 0 0 500 500 602 49450 01 365.00 Workers Comp Insurance 6,325 6,643 7,109 7,000 7,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 11,768 10,766 5,307 15,000 15,000 Sewer's Share of Premiums 602 49450 01 391.00 P.C.Maintenance 446 467 491 1,000 2,700 602 49450 01 391.01 U/B Software Maintenance 0 0 0 0 2,000 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 0 0 0 0 700 Added to Utility Budgets in 2012 602 49450 01 392.00 P.C.Accessories&Supplies 104 138 0 200 200 602 49450 01 393.00 P.C.Hardware Purchases 4,708 1,370 320 1,800 4,000 New GPS Unit,Server Upgrades 602 49450 01 394.00 P.C.Software Purchases 4,574 5,378 4,574 9,500 602 49450 01 394.01 Licensing&Maintenance 0 0 0 4,600 4,800 Cartegraph,GIS 602 49450 01 394.02 Online Subscriptions 0 0 0 300 300 Pictometry 602 49450 01 394.03 New Software Purchases 0 0 0 4,000 4,400 CG Upgrades(YourGOV,Mobile) 602 49450 01 395.00 P.C.Repairs 0 0 0 500 500 602 49450 01 403.00 Contracted R&M-Other Impr 248 18,926 0 2,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 100 50 23 100 100 Suburban Util.Supt.Ass'n(50%) 602 49450 01 435.00 Books&Pamphlets 0 0 0 300 300 Reference Materials 602 49450 01 437.00 Conferences&Seminars 1,455 1,001 3,300 602 49450 01 437.01 Sewer School 0 0 23 800 800 602 49450 01 437.02 Collection System Conference 0 0 950 1,000 1,000 New CG Mobile S/W Training 602 49450 01 437.03 CarteGraph,ESRI,GIS 0 0 158 1,300 1,500 User Group,Conference,Training 602 49450 01 439.00 Other Miscellaneous Charges 177 145 144 100 100 Contingencies 602 49450 01 521.00 Building&Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W.Building(15 of 20) 602 49450 01 530.00 Improvements Other Than Bldgs 160,000 602 49450 01 530.01 Miscellaneous Improvements 0 0 0 10,000 10,000 SCADA Reconfiguration,PCL's 602 49450 01 530.02 Misc.Improvements/Repairs 0 0 0 0 0 602 49450 01 530.03 CRP of Sewermain 234,399 0 0 150,000 150,000 Annual Pavement Management 602 49450 01 530.04 0 0 0 0 0 602 49450 01 530.05 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 738,373 508,353 467,964 713,300 713,500 / 1 Page Two 2013 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- July 9,2012 2012 2013 Object 2013 • 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 49450 01 602.00 Sewer Service Charges 846,623 923,221 981,478 1,030,000 1,030,000 MWCC Charges 602 49450 01 611.00 Interest on Lease Payments 3,861 3,554 3,232 0 0 P.W.Building Expansion(See 521) 602 49450 01 710.00 Transfers 0 0 172,451 0 0 Transfers for Other Improvements 602-49450-01 TOTALS 1,588,857 1,435,129 1,625,124 1,743,300 1,743,500 602 49451 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49451 01 221.00 Equipment Parts 3,785 182 4,215 800 800 602 49451 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49451 01 303.00 Engineering Fees 0 0 5,499 0 0 602 49451 01 321.00 Telephone Costs 0 0 0 0 0 602 49451 01 381.00 Electric Utilities 836 948 1,058 1,500 1,500 602 49451 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (City Hall) TOTAL-LIFT STATION#1 4,622 1,129 10,772 2,900 ^^� 2,900 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49452 01 221.00 Equipment Parts 0 0 2,697 800 800 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49452 01 321.00 Telephone Costs 211 211 211 0 0 602 49452 01 381.00 Electric Utilities 571 558 620 500 700 602 49452 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Bloomfield 5th) TOTAL-LIFT STATION#7 782 769 3,528 1,900 2,100 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49453 01 221.00 Equipment Parts 4,021 9,421 338 800 800 602 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49453 01 321.00 Telephone Costs 0 0 0 0 0 602 49453 01 381.00 Electric Utilities 3,559 3,546 3,154 3,500 3,500 602 49453 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49453 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Shannon Pond) TOTAL-LIFT STATION#3 7,580 12,967 3,492 4,900 4,900 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49454 01 221.00 Equipment Parts 3,550 3,387 478 800 800 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49454 01 321.00 Telephone Costs 0 0 0 0 0 602 49454 01 381.00 Electric Utilities 5,317 5,560 4,898 4,000 6,000 602 49454 01 403.00 Contracted R&M-Other Impr 0 0 3,195 200 200 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies _ Y Y (Hawkins) TOTAL-LIFT STATION#4 8,867 8,947 8,571 5,400 7,400 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49455 01 221.00 Equipment Parts 6,836 724 31,500 800 800 602 49455 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49455 01 303.00 Engineering Fees 5,833 0 0 0 0 602 49455 01 310.00 Testing Services 1,575 0 0 0 0 602 49455 01 321.00 Telephone Costs 0 0 0 0 0 602 49455 01 381.00 Electric Utilities 5,546 5,125 5,609 6,000 6,000 602 49455 01 403.00 Contracted R&M-Other Impr 42,379 0 0 200 200 602 49455 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (LeForet Add'n) TOTAL-LIFT STATION#5 62,168 5,849 37,108 7,400 7,400 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49456 01 221.00 Equipment Parts 6,400 203 118 800 800 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49456 01 321.00 Telephone Costs 0 0 0 0 0 602 49456 01 381.00 Electric Utilities 2,024 5,060 6,614 7,500 7,500 602 49456 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Drumdiffe) TOTAL-LIFT STATION#6 8,424 5,263 6,732 8,900 8,900 /03 Page Three 2013 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- July 9,2012 2012 2013 Object 2013 2009 2010 2011 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 589 1,659 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 679 982 1,103 800 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 5th) TOTAL-LIFT STATION#9 1,268 2,641 1,103 1,900 2,300 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49458 01 221.00 Equipment Parts 762 237 6,612 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 428 473 552 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 1,190 710 7,164 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 142 0 497 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 180 183 295 800 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 321 183 793 1,900 1,500 GRAND TOTAL-ALL DEPTS. $1,684,079 $1,473,586 $1,704,387 $1,780,400 $1,782,800 I /0‘t 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 2007 2008 2009 2010 2011 2012(est) 188 149 59 62 411* 75 * 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 of those that have been rated 2 for the past several years (just below the threshold for cleaning) received a rating of 3 in 2011. We expect the number of 3 or 4 ratings to decrease again in 2012. 1°c Page One 2013 BUDGET WORKSHEETS STORM WATER UTILITY -REVENUES- July 9,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 603 33400.00 State Grants&Aids $575,600 $3,816 $0 $0 $0 603 33425.00 Other State Grants&Aids 0 1,208 0 0 0 603 34108.00 Administrative Fees-Other Funds 4,655 590 2,123 0 0 5%of 5%Fees-Const Projects 603 36101.00 Principal-Special Assessments 20,582 17,868 22,204 20,000 20,000 603 36102.00 Penalties&Interest-S/A 330 0 732 0 0 603 36210.00 Interest Earnings-Investments 28,398 28,485 45,136 25,000 30,000 603 36214.00 Net Change in FV-Investments 312 (11,555) 2,198 0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 549 617 245 500 400 603 36260.00 Other Revenues 0 0 0 0 0 603 36265.00 Use of Reserve Funds 0 0 0 0 0 603 37300.00 Storm Water Utility Revenues 787,850 835,434 879,551 820,000 860,000 603 37360.00 Penalties-Storm Water Utility 3,473 3,901 3,690 3,500 3,600 603 39203.00 Transfer From 0 0 0 0 0 FUND TOTALS $1,421,751 $880,364 $955,878 $869,000 $914,000 /fib •. Page One 2013 BUDGET WORKSHEETS STORM WATER UTILITY -EXPENDITURES- July 9,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 603 49500 101.00 Salaries&Benefits $171,900 Salary,Taxes,PERA&Benefits 603 49500 77 101,00 Administrative 0 0 0 0 10,700 603 49500 78 101.00 Technical/Clerical 99,414 95,473 76,109 83,000 79,400 603 49500 79 101.00 Maintenance 65,930 68,879 69,358 70,700 81,800 603 49500 xx 101.00 Salary&Benefit Contingency 0 0 0 2,700 0 603 49500 102.00 Full-Time Overtime 3,496 4,296 4,568 6,000 6,000 603 49500 99 103.00 Part-Time Salaries&Benefits 0 7,954 9,334 8,000 8,000 603 49500 01 203.00 Printed Forms&Paper 1,418 1,258 1,195 1,500 1,500 603 49500 01 204.00 Envelopes&Letterhead 0 0 0 0 0 603 49500 01 208.00 Miscellaneous Supplies 159 0 0 1,600 1,600 Stakes,Ribbons,Level,etc. 603 49500 01 215.00 Shop Materials 0 0 0 0 0 603 49500 01 219.00 Other Operating Supplies 0 0 0 0 0 603 49500 01 221.00 Equipment Parts 0 0 0 0 0 603 49500 01 224.00 Street Maintenance Materials 1,505 1,578 406 2,000 2,000 Blacktop&Gravel Washouts 603 49500 01 225.00 Landscaping Materials 4,000 603 49500 01 225.01 Rip-Rap,Matting,Rock,etc. 462 408 1,751 3,000 2,000 603 49500 01 225.02 Black Dirt,Seed,Sod,etc. 492 299 1,962 1,000 2,000 603 49500 01 225.03 0 0 0 0 0 603 49500 01 226.00 Sign Repair Materials 0 287 926 500 500 603 49500 01 230.00 Equipment Repair Material 555 204 534 1,000 1,000 603 49500 01 241.00 Small Tools 629 0 0 1,000 1,000 603 49500 01 242.00 Minor Equipment 269 2,747 332 2,000 2,000 Misc.Nozzles for Vac Truck 603 49500 01 303.00 Engineering Fees 75,000 603 49500 01 303.01 Problem Area Investigations 34,272 31,441 10,003 10,000 10,000 603 49500 01 303.02 NPOES Phase II 20,908 28,763 0 30,000 30,000 603 49500 01 303.03 CSMP Update 8,955 15,076 22,880 0 0 603 49500 01 303.04 Miscellaneous 10,900 8,525 29,866 30,000 30,000 603 49500 01 303.05 GIS 0 0 0 10,000 5,000 603 49500 01 304.00 Legal Fees 207 0 234 2,000 2,000 603 49500 01 310.00 Testing Services 0 0 0 1,000 1,000 Water Quality Tests(M) 603 49500 01 312.00 Contract Inspection Fees 0 0 0 500 500 3rd Part Inspection Program(M) 603 49500 01 313.00 Temporary Service Fees 0 1,275 9,706 0 0 603 49500 01 315.00 Special Programs(County Program) 4,500 4,500 4,500 5,000 5,000 Wetland Health&Evaluation Proj 603 49500 01 318.00 Contract Engineer 6,000 6,000 7,000 6,000 7,000 Contracted Engineer for City(20%) 603 49500 01 319.00 Other Professional Services 0 0 3,356 5,000 5,000 SCADA 603 49500 01 321.00 Telephone Costs 0 2,284 2,312 2,500 2,500 Cell Phones,Modems,GPS 603 49500 01 322.00 Postage Costs 4,214 4,299 4,504 5,000 5,000 Billings&Info Mailings 603 49500 01 323.00 Radio Units 729 1,083 1,210 1,500 1,500 24 Units'$280(Split 5 Ways) 603 49500 01 331.00 Travel Expense 0 0 0 200 0 603 49500 01 352.00 General Notices&Public Info 0 58 0 1,000 1,000 Public Info Brochure 603 49500 01 365.00 Workers Comp Insurance 2,572 2,640 2,875 3,500 3,500 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 5,020 4,927 2,393 6,000 6,000 Storm Water's Share of Premiums 603 49500 01 384.00 Refuse Disposal 0 0 0 600 600 Roadside Debris 603 49500 01 389.00 Other Utility Services 0 0 0 500 500 Hazardous Materials Disposal 603 49500 01 391.00 P.C.Maintenance 446 467 491 3,000 2,700 603 49500 01 391.01 U/B Software Maintenance 0 0 0 0 2,000 Added to Utility Budgets in 2012 603 49500 01 391.02 Auto Read Software Support 0 0 0 0 700 Added to Utility Budgets in 2012 603 49500 01 393.00 P.C.Hardware Purchases 4,708 0 320 1,800 4,000 New GPS Unit,Server Upgrades 603 49500 01 394.00 P.C.Software Purchases 4,674 5,378 4,574 9,500 603 49500 01 394.01 Licensing&Maintenance 0 0 0 4,600 4,800 Cartegraph,GIS 603 49500 01 394.02 Online Subscriptions 0 0 0 300 300 Pictometry 603 49500 01 394.03 New Software Purchases 0 0 0 4,000 4,400 CG Upgrades(YourGOV,Mobile) 603 49500 01 403.00 Contracted R&M-Other lmpr 55,000 603 49500 01 403.01 Ditching 0 0 0 5,000 5,000 603 49500 01 403.02 Miscellaneous Repairs 7,201 46,150 22,899 50,000 50,000 Storm System Maint.,Catch Basins 603 49500 01 416.00 Machinery Rental 50 939 43 5,000 4,000 Pumps 603 49500 01 433.00 Dues&Subscriptions 1,015 140 140 0 0 603 49500 01 435.00 Books&Pamphlets 0 0 0 500 500 Utility Information 603 49500 01 437.00 Conferences&Seminars 3,000 603 49500 01 437.01 Storm Water Management 0 875 875 1,000 1,000 MN Cities Stormwater Collaboration 603 49500 01 437.02 Hydrocad Training 0 0 0 0 0 603 49500 01 437.03 Wetlands Training 0 0 0 500 500 New CG Mobile S/W Training 603 49500 01 437.04 Cartegraph,ESRI,GIS 0 0 157 1,300 1,500 User Group,Conference,Training 603 49500 01 439.00 Other Miscellaneous Charges 147 145 144 0 0 603 49500 01 530.00 Improvements Other Than Bldgs 150,000 603 49500 01 530.01 CRP of Storm Sewer 131,031 11,997 2,669 150,000 150,000 Annual Pavement Management 603 49500 01 540.00 Heavy Machinery Purchases 0 0 0 0 0 603 49500 01 560.00 Furniture&Fixture Purchases 0 0 0 500 500 603 49500 01 580.00 Other Equipment Purchases 0 0 0 2,000 2,000 603 49500 01 586.00 Computer Equipment Purchases 0 0 0 500 500 PAGE TOTALS 421,875 360,346 299,624 534,300 547,300 Page Two 2013 BUDGET WORKSHEETS STORM WATER UTILITY -EXPENDITURES- July 9,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 603 49500 01 710.00 Transfers 89,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 1/2 of 2011 P&I Payments(2001B) 53,000 54,000 0 0 0 Bonds Called 2/1/11 603 49500 01 710.04 1/2 of 2011 P&I Payments(2001D) 0 0 0 0 0 Bonds Paid off 2/1/08 603 49500 01 710.05 1/2 of 2011 P&I Payments(2002B) 28,000 33,000 8,000 0 0 Bonds Called 2/1/11 603 49500 01 710.06 1/2 of 2011 P&I Payments(2010A) 0 0 60,000 84,000 89,000 New Refunding Issue 12/10 603 49500 01 710.07 1/2 of 2011 P&I Payments(2003A) 42,000 42,000 90,000 0 0 Bonds Called 12/1/11 603 49500 01 710.10 Projects 0 9,542 233,607 0 0 603-49500-01 TOTALS 544,875 498,888 691,232 618,300 636,300 603 49511 01 221.00 Equipment Parts 836 1,771 0 500 500 603 49511 01 381.00 Electric Utilities 231 269 264 500 500 (Copper Pond) TOTAL-LIFT STATION#1 1,068 2,040 264 1,000 1,000 603 49512 01 221.00 Equipment Parts 500 237 880 500 500 603 49512 01 381.00 Electric Utilities 0 0 0 500 500 (Schwarz Pond) TOTAL-LIFT STATION#2 _^-500 237 880 1,000 1,000 603 49513 01 221.00 Equipment Parts 2,205 0 375 500 500 603 49513 01 381.00 Electric Utilities 1,673 7,844 4,401 3,500 4,500 (Birger Pond) TOTAL-LIFT STATION#3 3,878 7,844 4,776 4,000 5,000 603 49514 01 221.00 Equipment Parts 0 0 931 500 500 603 49514 01 381.00 Electric Utilities 506 1,265 1,653 2,000 2,000 (Marcotte Pond) TOTAL-LIFT STATION#4 506 1,265 2,585 2,500 2,500 603 49515 01 221.00 Equipment Parts 231 0 0 500 500 603 49515 01 381.00 Electric Utilities 0 0 0 500 500 (Hawkins Pond) TOTAL-LIFT STATION#5 231 0 0 1,000 1,000 603 49516 01 221.00 Equipment Parts 589 0 0 500 500 603 49516 01 381.00 Electric Utilities 262 463 415 500 500 (Glendalough 7th) TOTAL-LIFT STATION#6 851 463 _ - 415 1,000 1,000 GRAND TOTAL-ALL DEPTS. $551,909 $510,737 $700,152 $628,800 $647,800 /4 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 2007 2008 2009 2010 2011 2,456 2,544 2,466 2,577 2,514 n/a—Information Not Available /09 Page One 2013 BUDGET WORKSHEETS ARENA-REVENUES September 4,2012 I 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed 1 Account# Description Actual Actual Actual Budget Amount Budget Comments 650 36210.00 Interest Earnings-Investments $0 $274 $486 $0 $0 650 36215.00 Interest Earnings 320 274 137 100 100 650 36230.00 Contributions/Donations 597 0 0 0 0 650 36260.00 Other Revenue-Learn to Skate 31,648 39,709 30,122 39,000 31,000 Learn to Skate Program(LTS) 650 36265.00 Use of Reserve Funds 0 0 0 0 0 650 38060.00 Prime Time Ice Fees 236,606 247,457 251,519 247,000 251,000 650 38061.00 Non-Prime Time Ice Fees 74,964 87,068 73,792 85,000 74,000 650 38063.00 Open Skating Ice Fees 6,163 5,216 5,259 6,000 6,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 6,220 13,000 3,500 10,000 10,000 650 38067.00 Skate Sharpening Revenue-Arena 3,844 3,636 3,322 4,000 3,500 650 38090.00 Concessions 3,900 3,900 3,900 3,900 3,900 650 38091.00 Vending Machine Revenues 6,653 5,974 5,771 6,000 6,000 650 38095.00 Pro Shop Revenues 965 837 863 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 486,881 522,345 493,669 517,000 501,500 110 Page One 2013 BUDGET WORKSHEETS ARENA-EXPENDITURES September 4,2012 2012 2013 Object 2013 2009 2010 2011 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 650 45130 101.00 Salaries&Benefits $159,300 Salary,Taxes,PERA&Benefits 650 45130 77 101.00 Administrative 39,280 43,775 42,725 39,300 40,500 650 45130 78 101.00 Technical/Clerical 33,224 34,427 35,363 36,200 37,500 650 45130 79 101.00 Maintenance 60,654 67,022 73,447 76,400 81,300 650 45130 roc 101.00 Salary&Benefit Contingency 0 0 0 2,400 0 650 45130 79 102.00 Full-Time Overtime 3,836 2,456 1,494 2,000 2,000 650 45130 103.00 Part-Time Salaries&Benefits 40,000 650 45130 89 103.00 Learn-To-Skate Program 23,641 20,097 16,286 25,000 17,000 650 45130 99 103.00 Building Attendants 31,815 24,507 22,000 25,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 0 100 100 100 650 45130 01 208.02 Other Supplies 176 0 484 600 600 650 45130 01 209.00 Other Office Supplies 54 185 0 500 500 Learn to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 2,961 3,409 4,198 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,217 4,835 4,249 5,000 5,000 Cooling Tower 650 45130 01 219.00 Other Operating Supplies 2,523 38 156 500 500 Events Supplies 650 45130 01 221.00 Equipment Parts 4,374 3,034 7,425 6,000 6,000 Camera Replacements 650 45130 01 223.00 Building Repair Supplies 2,149 826 2,590 3,000 3,000 650 45130 01 265.00 Other Items for Resale 517 333 269 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 833 1,174 1,340 1,200 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 110 115 400 400 650 45130 01 365.00 Workers Comp Insurance 2,730 3,567 3,254 3,500 3,500 650 45130 01 369.00 Other Insurance 7,884 7,671 3,679 8,000 8,000 650 45130 01 381.00 Electric Utilities 112,239 115,700 125,740 120,000 120,000 650 45130 01 383.00 Gas Utilities 27,568 23,885 26,328 31,000 27,000 650 45130 01 384.00 Refuse Disposal 3,237 3,178 2,817 3,500 3,500 650 45130 01 401.00 Contracted Building Repairs 6,754 1,928 10,189 7,000 7,000 650 45130 01 404.00 Contracted Mach&Equip Repairs 23,788 19,230 22,730 16,000 22,000 650 45130 01 415.00 Other Equipment Rental 300 0 0 300 300 650 45130 01 433.00 Dues&Subscriptions 1,165 868 720 1,000 1,000 MIAMA&MRPA Dues 650 45130 01 437.00 Conferences&Seminars 220 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 0 42,000 12,000 23,000 60,000 Skate Tile 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 405,748 433,757 429,196 451,600 485,700 111 °• 3 o • 3 - 3 " • S .c▪ d _5. m . g) -0 0 7 `� 0 -0 v m m 3m 3<c1 cr -+ -, N CO N s -> N -> -> O, - - -+ N CO N N) N3 N N N O. O 01 O O CO CO O) V N CO CO CD CO CO w w O N O A N N 0o -> O O O O co N V V O N A CO O N N UI O N CO CO A O N ANOONO -+ (n ONtnA O NA w (11O AOA CO Co O O 0 0 0 0 0 0 0 0 0 0 N 0 0 0 0 0 0 0 0 0 0 0 CA to m 3DC 3so — _ N) N N D CS - Aw000O _ CD CnOOO Co O: C p C D al Cn -,I C O A C O CO 4 A O A 0 0 Cn 4 A Cn 7 N v O) O O CO -7 01 CO -7 O CO 3 N -4 O- � CO -� .J w Cn O-co p A A O CO w (O--co-co CO CO 0 O 0 0 0 0 0 Cn O O O O . 0 0 0 0 0 0 0 0 0 0 0 p O 0 0 0 0 0 0 0 0 0 0 W 0 0 0 0 0 0 0 0 0 0 0 v 60 Ca Ca (A Co C)1 CA CA CA 6 N \ O �1 O -4 O Cn A co Cn A O : - (O CO -4 CO N O CO Cn co = o Co O Co 0) N CO A .I 0 v v m e O CO A O CO (O CO N CO CO cm O CO O N (O CO CO CO CO NCO o e o a o o e e e e e A e e e e e e e o e a o O 0 0 0 0 0 0 0 0 0 0 0 0 0 m to 3fa 3d M S a - p p 7 N CO CO O w O CO O CO N A 7 N p Co O W N (O O CO A O (O A p 0 0 0 0 0 0 0 0 0 0 0 0 p 00000000000 co 0 n n � Ne -> -> A 4. 0 0 0 -> -> -+ O e Q1 7 o O ? Co in �I • e CC) N N O w O Co O (O O CO CO o 0 o e o e o 0 o e e CD D1 co to 3N 3m M S . CD O COCn O -4 w O NCn GO C4 m 0 W N A CANOCJw -7C)0Cn W N O Cn000A0wON0Cn 0• 3 p Ei Ui 0 0 0 0 0 0 0 0 0 0 0 p CD N 0 0 0 0 0 0 0 0 0 0 0 0 = 4k 4k 4k 4k 4# 4k 4k 4k 4k 4k 4k0 0 M O 0000000000 = a NwCV NCoCOIs NIs NNa O0 << << << << << < 3 e it a in w iv in iO b) . 3 e 0 Ei 0 0 0 0 0 0 0 0 0 0 CO -1 V O O w CO CO O A CO — CD ee 8.Z. \ \e \ \ \e \e \ \ee rt 0 0 0 0 0 0 0 m 3 m 3 it 3 101 CD Cr N CO N N_ N N 4. NJ NJ a Q W N COnal -CO co+ vNA000jQCO -4W N O O O O O O O O O 0 0 ' 0) 0 0 0 0 0 0 0 0 0 0 0 p 4k 4k 4k 4k 4k 4k 4k 4k 4k 4k 4k C) '_, C) 00000000DDOS (a aoo � 44oviop) Cova go .< < < < < < < < < < < 0 ° w0oA 0000007 e O 0 0 0 0 0 O O O O O Cfl O O w CO —7 O w -> CO o Cfl — to o o e o 0 0 0 0 o e e 0 co co 3� 3d O: A V cn - - W O V CO nN) 0 0 Q. A W m 0Cn0OA wwCNw W N 0 0 0 0 0 0 0 0 0 0 0 V 0 0 0 0 0 0 0 0 0 0 0 it 4k 4k 4k 4k 4k 4k 4k 4k 4k 4k C) C) O ODDODOOOOO � y = = 644Oh44OD6 46 : a « « « « « < 0 Ovao6 � Co v6At e O O O O O CJ O O O O CDC c V K3 -4 o c ; p p p p0 — A e e e e e e e e e e e e 'O -0 co m 3m 3d O: CD O CT o O W CO O -1 N CO CO Q: CCD 7 N co O O O co O N V �I 7 N OOOCn OO00000 CO 0 0 0 0 0 0 0 0 0 0 0 N 4k 4k 4k It 4k 4k 4k 4k 4k 4k 4k n C) O DDOODODODOS N W Cn in ANA w 1> IV W s << << << << << < 7 e CO O Co A Co in A io V A 7 e O 0 0 0 0 0 0 0 0 0 PC o 0 n 0 0 0 0o 0 0 om CD e e e e e e e e e e e e