Loading...
HomeMy WebLinkAbout2.f. Budget DiscussionJ ROSEMOUNT EXECUTIVE SUMMARY CITY COUNCIL City Council Workshop Meeting June 15, 2011 AGENDA ITEM: 2012 Budget Discussion AGENDA SECTION: PREPARED BY: Dwight Johnson, City Administrator AGENDA NO. ATTACHMENTS: Budget worksheets, Ice Arena spreadsheets, chart of major positive and negative factors APPROVED BY: RECOMMENDED ACTION: Discussion Item EXECUTIVE SUMMARY The recommended budget for 2012 proposes a reduction of $9 in the City taxes assessed to a median value home. The City tax levy would decline by 0.20% and the overall increase in City funding needs would be 0.95 %. With the reduction of $77 in taxes for the median home in 2010, and a further reduction of $56 in 2011 and $9 for 2012, the three year property tax decline for the median home will be $142 or 13.85 %. The median family home paid $1,025 in City taxes in 2009 and would pay $883 in 2012 with this proposed budget. The levy is proposed to decline slightly despite significant headwinds. Undercurrent law, the City will lose $80,000 in State Market Value Homestead Credit, which will cost the City part of its revenues even though we do not budget any funds from this program. Health insurance increased by 18% in 2011 and we are budgeting a 20% increase until we get the final cost on August 18th. With all bargaining contracts up at the end of 2011, salaries are another unknown that require some contingency planning. Finally, fuel costs are projected to increase substantially over the current budgeted levels. Offsetting these headwinds, debt levies will decrease by $225,842 due to a wise use of 2010 General Fund surplus funds to further reduce our debt levy requirements. Other important factors benefitting us include the proposal to not fill two currently vacant positions (building inspector and GIS Coordinator). We will not save the full salary and benefits of either position, because the building inspector was only budgeted for six months in 2011 and it is expected that a portion of the GIS work will have to be contracted with WSB, our engineering consultants. Finally, SKB funds have increased notably, which directly helps our CIP funds (Capital Improvement Program funds) and indirectly provides an opportunity to benefit the General Fund by moving two capital expenditures currently in the General Fund to the CIP. The principal changes in the 2012 budget are a new proposal to increase pay for the Fire Department, the movement of funding for new trail construction from the General Fund to the Capital Improvement Fund and the reduction of bond levy requirements. These items are discussed in more detail below. A summary of key characteristics of the proposed 2012 budget are shown in the following table: Budget Facts at a Glance Loss of property tax base from 2011 Average reduction in residential values General fund spending change: Total funding change — all funds Total funding change — all tax impacted funds Change in overall tax levy from 2010 City share of tax impact on median value home Percentage tax reduction on median value home Change in estimated tax rate (City share only) .-2.98% -5.48% +1.42% +$157,183 - $73,517 - $22,234 -$9 - 1.01.% +5.71% (from .44661 to .47211) 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 2011 -2012 on April 5, 2011. 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. We have also reviewed our long term needs for parking lot maintenance for the first time. By request of the Council, we also looked at the financial impact of possibly closing the Ice Arena during summer months. Finally, we looked at the overall budget strategically one more time for its overall balance, consistency, impact on taxpayers, and long term impacts on finances for 2012 and beyond. Our hope was to develop the most conservative budget_ possible that: (1) is consistent with Council goals (2) is consistent with previous council direction on levels of service, (3) does not weaken the City's long range financial outlook. (4) is balanced not only between revenues and expenditures, but also is well balanced internally between personnel, equipment, technology, operating needs and capital expenditures. The City continues to look for new savings and efficiencies. The savings from new boilers in the Steeple Center are noticeable in the 2012 budget. We also benefitted from using our insurance reserves to help us move to a higher deductible plan in the last year. In 2012, we expect to have an ongoing plan for the use of improved technology or software in such areas as utility billing, building permits, a web portal for Cartegraph information, internal document circulation through Laserfiche, and customer service tracking. These items are consistent with the Council's adopted goal to "embrace technology initiatives that improve citizen access to City services." 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. 4 6 GENERAL FACTORS AFFECTING THE BUDGET Tax Base For the third consecutive year, the overall tax base in the community has declined. The overall tax capacity value within the City is estimated to be 2.98% lower in 2012 that it was in 2011. This is on top of a 4.35% decline for 2010 and a 5.12% decline for 2011. The decline in market value of the median home in Rosemount is even higher, with an average decrease in market value of 5.48 %. The overall tax base did not decline by that much because growth in the community offset some of the decline in existing property values. State Budget and Legislative Impacts Rosemount has not received any Market Value Homestead Credit (MVHC) Funds from the State of Minnesota since October, 2008. We have budgeted assuming that we would not receive any MVHC in each budget since 2008. The 2012 budget has been prepared assuming no,MVHC funds will be received. Nevertheless, Rosemount will lose an estimated $80,000 in MVHC in 2012. This is because of the decrease in existing values. As values decrease properties are eligible for larger credits and the larger credits ultimately must come from our levy. The Legislature has adjourned without reaching agreement with the Governor on the next state budget and tax bill. Until a tax bill is agreed upon, we will°not know what levy limits will be imposed on us. In the last several years, we have not had any problems staying under state mandated levy limits. REVENUES Property taxes fund 79% of the General Fund budget and 65% of the overall City Budget. As noted above, our tax base is decreased by 2.98% for 2012. However, there are several other categories of General Fund revenues that are also important to the City. The chart below compares budgeted revenue for 2011 with estimated revenue in 2012 for several key categories of revenues. Licenses & Permits Intergovernmental Charges for Services (no SKB) Fines & Forfeits Recreational Revenues Miscellaneous Revenues SKB Revenue (General Fund portion) 20112011 Budget 2012 Estimated Change 360,100 362,300 +2,200 624,700 633,900 +9,200 233,400 243,400 +10,000 125,000 125,000 , -0- 252,300 254,900 +2,600 181,300 186,300 +5,000 425,000 425,000 -0- Non -tax revenues are relatively stable overall, although projected interest on our balances is projected to fall another $10,000 due to very low investment and bank rates. Two of the most important non -tax revenues are building permit revenues and SKB fees. Building Permit Revenues During 2010, about 80 new dwelling units were built in' Rosemount. We are anticipating that the final results for 2011 and 2012 will be about the same, and have budgeted building permit revenues to be about the same as in 2011. New construction by D.R. Horton and Lennar,in Prestwick Place on Akron Avenue should help offset the expected completion of Glendalough in Evermoor.. 3 SKB Revenues The City approved a new agreement with SKB Environmental in 2008 that has been increasing our percentage of revenues from SKB's operations in Rosemount. In addition, SKB has had significant new contracts with 3M and Xcel Energy. Consequently, current revenue collections have exceeded our estimates for 2010 and 2011 to date. The draft budget for 2012,continues to designate $425,000 of SKB funds to support the operating budgets. We estimate that up to $500,000 will be available for capital budgeting purposes in 2011 and $400,000 for 2012. These funds will help fund council goals relating to senior housing and a senior center and a possible partnership with DCTC and the Y for new indoor recreation facilities. The capital improvement budgets will be .presented for review later this year. Market Value Homestead Credit While the State's Market Value Homestead Credit law was intended to provide a reimbursement to local governments for tax revenue lost due to credits on homeowners tax bills, it is actually turning into a direct cost for Rosemount. The City has not received any MVHC funds since 2008, but the credit given to homeowners continues to increase. As a result, if the current law is not repealed or amended in a special session of the Legislature this year, Rosemount will lose an estimated $80,000 from the amount we levy for taxes in December. This anticipated loss of funds that we never received must still be accounted for in. balancing our overall budget. EXPENDITURES Salaries Rosemount currently employs 77 full time employees. This.number does not include two positions currently budgeted which we do not plan to fill in 2012: Building Inspector and GIS Coordinator. The Building Inspection employee was laid off in 2010 and we do not project that we will need to recall or refill that position in' 2012. However, whenever permit numbers and revenues increase, staff anticipates requesting reinstatement of that position. One -half of the building inspector position was budgeted in 2011. In place of hiring anew GIS Coordinator, the plan is,to promote the current GIS Technician to a full time position from the current 30 hour position and also budget for contractual GIS assistance from WSB. Once the GIS Technician is made full-time we will have 78 full-time employees, down from 80 a year ago. Union contracts with all four of our bargaining units expire on December 31, 2011. Negotiations are expected to begin later this summer or early fall. There is no established trend for metro area wage settlements for 2012 at this early date. The trend for settlements in 2011 appears to be about 1.1% for public safety personnel and about 0.6 % for all other employees, union and non - union. Just over one -half of all cities in our survey gave wage increases in 2011. Under State law, state arbitrators have the power to set City wages for the police officers and sergeants. It'is too soon to determine whether we should consider an increase in wages for 2012, but given current trends and future uncertainties, we are not comfortable without any contingency for wages at this early date and have therefore included a contingency for wages in the Council designated account. Health Insurance Health insurance contract renewal rates will not be known until about August 18th. Last year, the City absorbed an 18% increase. Because of this, a 20% increase in health insurance premiums has been assumed in this first budget draft. Hopefully, this amount can be reduced prior to adoption of the preliminary levy in September. The assumption of a 20% increase in health insurance added about $120,000 to the General Fund (taxes) and $142,000 city -wide. 4 Fire Department Pay The current very low cost of our paid -on -call Fire Department (2nd lowest cost per capita expenditure among 225 cities compared by the State Auditor) is not sustainable over the long term. While we believe our fire pension is reasonably competitive, our pay for calls and our support for the management capacity of the department are well under other area departments. A recent survey showed that no other department pays less than $10 per hour, while our pay is currently $2 per call. While most of our calls are one hour or less, a few calls such as the Akron Avenue house fire can last many hours. On the management side, we are the only area department with no full-time staff. The current combined stipends of all of our officers, including the Chief, Assistant Chief, four Captains, four Lieutenants, two Training Officers and the Secretary is less than $25,000. Meanwhile, the complexity of managing a modern Fire Department keeps increasing over time. The ISO update of our Fire Insurance Rating this month will take 300 hours of work. The task of buying the new pumper truck that the Council recently approved also takes many hours. Our east Rosemount industrial base requires us to train on many different types of hazards. Medical calls keep increasing. Recruiting new firefighters is an ongoing effort, and we have not yet met our goal of having 50 firefighters after Station 2 was opened. While we do not have a specific proposal to offer at this writing, the 2012 budget proposes to allocate $67,000 for improving the pay of firefighters and building our Fire Department management capacity. If this proposal helps forestall the need to Hire full-time firefighters and staff for awhile, it will be a good investment. Fuel.cost assumptions Fuel costs for 2012 will not be very predictable until December when we will sign a new fuel consortium agreement with the State. In this draft budget, we are increasing the expected price of fuel based on current market conditions. The increase shows up in the Fleet Maintenance budget where the motor fuel line item is increased by $45,000. Ice Arena The Council specifically asked that the staff review the possibilities for cost savings by closing the City's Ice Arena for several months in the summer. An attachment to this memo shows information about both total monthly costs and revenues for the arena as well as the marginal costs and revenues attributable to the summer time operation of the arena. Information is also presented regarding the users of the arena in the summer. Notable other cost increases or decreases Other cost increases in the General Fund include Equipment Parts ($20,000) and Sidewalk Repairs ($12,000) in the Street Maintenance Division. The increase in equipment parts is based on past expenditure trends, extending the life of some items of equipment, and a difficult winter this year. Sidewalk repairs have. also been under budgeted in recent years, and funds were taken from the new construction fund at times to make the repairs. $15,000 has also been added to the Park Maintenance fund to allow for the reasonable probability that the City will enter into a partnership for use of the new DCTC east baseball field in 2012. It is not known yet whether we would contract for this work or add part-time staff and equipment. Two cost decreases are natural gas costs for our Government Buildings budget (- $18,000) which is partially due to our new efficient boilers in the Steeple Center and a reduction of our Dakota Communications Center (DCC) costs (- $14,400). The DCC cost is based on usage and Rosemount's calls are down. 5 Capital Budgets The City currently has three capital improvement program (CIP) funds: Equipment, Streets, and Buildings. Staff has not yet done a detailed review of the CIP and plans to bring a proposed 10 -year CIP to the Council later this summer. At this time, a review of the trends for the purpose of setting CIP levies for 2012 has been done. The forecast for the Equipment CIP last year showed a need to increase the levy for 2012 to $460,000, an increase of $21,000. This levy is recommended for the long term replacement of the fleet and is not based on expenditures in 2012 or any other particular year. This strategy allowed us to buy a $520,000 fire pumper this year without issuing debt. Actual recommendations for equipment replacement will come later this summer. A new, federal mandate on street sign retro- reflectivity goes into effect next year and requires the change out of most of our 750 regulatory and warning signs by January 2015. Guide signs and street name signs must be replaced by January 2018. We have a total of about 2,200 signs. Finally, we are planning to include funds for the eventual replacement of our cable TV equipment in the Equipment CIP fund. Accordingly, $100,000 will be placed in the Equipment CIP for these purposes io be used over the next several years. Surplus 'SKB funds from 2011 will be allocated to the Equipment CIP to offset this expenditure. The Street CIP is proposed to have a levy•of $720,000 for 2012. 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. However, it is recommended that the trail and sidewalk construction appropriation of $125,000 per year in the General Fund be 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. It is proposed that $125,000 of SKB revenue per year be 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 2012 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 seniofhousing /senior center redevelopment project north of the Steeple Center and also may provide some funds for a possible partnership on an indoor recreational facility on DCTC property. It will also fund some improvements and updates planned for the Community Center. 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. Enterprise Fund Budgets The City's Enterprise Funds include the Water Fund, Sewer Fund and Stormwater Fund. The Water Fund includes $154,000 for the interior painting of the Chippendale water tower next year. The Sewer Fund shows an increase in the Met Council sewer charges due to an increase in those charges to us for 2011. The staff and the Utility Commission are updating our 10 -year rate model for these funds and plan to present any proposed rate adjustments in July. Debt Service Funds The City ended 2010 with a General Fund surplus. The Council approved a strategy that committed most of the surplus to continuing to offset existing debt levies, similar to what was approved for the previous two years. Enough funds were available from the 2010 surplus to make - all of the remaining debt service payments on two debt issues, saving $225,842 in tax levies for 2012. Implementation of this strategy is once again a major reason why we have been able to propose an overall reduced tax levy for 2012. 11 CONCLUSION Cities have some of the same issues with expenses beyond our control that many families experience. This year, we have to prepare for higher fuel costs, substantial increases in health insurance, loss of local tax levy dollars due to Market Value Homestead Credits given by the State, new federal mandates (street sign replacement) and even salaries are in some cases not within our final control under state law. We also should not indefinitely postpone our need to properly fund our very efficient Fire Department so that it can continue its fine service well into the future. At the same time, we benefit from a continuing reduction in debt levy requirements due to good management of past surplus funds, and we will benefit significantly from increased SKB revenues. We also are getting continually more efficient with new energy saving measures, new technology, and'reallocation of personnel. We are pleased that we can present a responsible, sustainable budget to you for your consideration that lowers the actual overall City tax levy for the third consecutive year, is projected to reduce taxes on the median home by an additional $9, and addresses .the Council's goals. 7 ??- ROSEMOUNT To: Dwight Johnson, City Administrator c/ From: Dan Schultz, Parks and Recreation Director 7b Date:' May 31, 2011 Subject: Summer Ice Operations Information Staff were recently asked to review our summer ice rentals for the Rosemount Arena. Included with this memo are documents that contain information regarding the direct operating costs of the arena with a focus on summer ice rentals, along with the operations for the remainder of the year. The first attachment identifies the revenues that are collected for the ice arena on an annual basis listed by month and revenue category. Please keep in mind that the revenues shown on the line titled "Total Arena Revenue" are based on when staff collects the revenues. The line titled "Revenue by Use" shows the revenues based on hours of ice used. Also included in this spreadsheet are the monthly expenditures. The second attachment is a detailed listing of all of the expenditures for the arena operations in 2010. The third and final attachment is an analysis of the summer ice rentals with the addition of the month of September. The analysis reviews the revenues collected by use and compares the revenues to most direct expenditures for the summer operations. Some of the costs that are directly related to summer ice operations include utility costs over the baseline cost of $7,800, which are paid whether the arena is open or closed. Staff does expect that if we were to close for the summer we would find some operational efficiencies that would allow us to lower our utility costs. Because we have never been shut down for more than 30 days, we do not have any data to review. Other costs that are directly related to summer ice use are part -time staff, Learn to Skate staffing, some repairs and limited supplies. Staff has also created a pie chart that identifies four summer ice user groups. The first user group is Rosemount users, who use approximately 42% of the summer ice. The Rosemount users are mainly skaters who participate in RAHA or Rosemount High School programs. The second user group is a mixed group of users who use 31% of the summer ice. The mixed group includes skaters from Rosemount along with skaters from neighboring communities. The third user group is the non- resident group, who uses 23% of the summer ice and includes skaters from communities that might host a clinic or summer camp in Rosemount. This would include skaters from Northfield High School, Apple Valley High School or other groups made up mainly of skaters from other communities. The fourth user group is made up of Parks and Recreation Department programs and includes offerings such as Learn to Skate, public open skating and a couple of hours for Adventure Kid's Camp. If you have questions regarding this information, please let "'me know., PARKS AND RECREATION M E M O R A N D U M To: Dwight Johnson, City Administrator c/ From: Dan Schultz, Parks and Recreation Director 7b Date:' May 31, 2011 Subject: Summer Ice Operations Information Staff were recently asked to review our summer ice rentals for the Rosemount Arena. Included with this memo are documents that contain information regarding the direct operating costs of the arena with a focus on summer ice rentals, along with the operations for the remainder of the year. The first attachment identifies the revenues that are collected for the ice arena on an annual basis listed by month and revenue category. Please keep in mind that the revenues shown on the line titled "Total Arena Revenue" are based on when staff collects the revenues. The line titled "Revenue by Use" shows the revenues based on hours of ice used. Also included in this spreadsheet are the monthly expenditures. The second attachment is a detailed listing of all of the expenditures for the arena operations in 2010. The third and final attachment is an analysis of the summer ice rentals with the addition of the month of September. The analysis reviews the revenues collected by use and compares the revenues to most direct expenditures for the summer operations. Some of the costs that are directly related to summer ice operations include utility costs over the baseline cost of $7,800, which are paid whether the arena is open or closed. Staff does expect that if we were to close for the summer we would find some operational efficiencies that would allow us to lower our utility costs. Because we have never been shut down for more than 30 days, we do not have any data to review. Other costs that are directly related to summer ice use are part -time staff, Learn to Skate staffing, some repairs and limited supplies. Staff has also created a pie chart that identifies four summer ice user groups. The first user group is Rosemount users, who use approximately 42% of the summer ice. The Rosemount users are mainly skaters who participate in RAHA or Rosemount High School programs. The second user group is a mixed group of users who use 31% of the summer ice. The mixed group includes skaters from Rosemount along with skaters from neighboring communities. The third user group is the non- resident group, who uses 23% of the summer ice and includes skaters from communities that might host a clinic or summer camp in Rosemount. This would include skaters from Northfield High School, Apple Valley High School or other groups made up mainly of skaters from other communities. The fourth user group is made up of Parks and Recreation Department programs and includes offerings such as Learn to Skate, public open skating and a couple of hours for Adventure Kid's Camp. If you have questions regarding this information, please let "'me know., v 'o to O O O O 0 a) 00 C!) r-. I O N CO O O O) M O O °A O N O r O ` O' M O I- r- cD O CO N I- u7 Wl U) 1� N I- N O r- U) V CD (::: I N O O M O LO CT N Q) Cl) 00 M O M u") r• .rt..'S Cl) N 00 O Cl) M 4�<ir O U) O O CD O O O O N O 00 't! • p O U) O lC') N O O O O O N O O 00 .G :�+ O c0 t) co (D CT) O N O O i- M u) 1� N N 00 O CC) u) O O M s C Q CD 00 O I- M U) O M I` co Cl) N O N M O O et cD O O O U) M r O C DM N O N M C0 O O O 00 O O O O U) O O CO O U) O a . 6 C', T U7 1— N O U) N �. CO T N O M M M M d' -�t ti u) d' N U) M. O M N O O O co O N U T O T O O O T V' O CO U" 'x - I- N N O M � O O N CD LO N (0 U') CO Cf) O U) N tD co T O M M ..• t '� "" O N O O O M O O O O O d' O M O O N O O U) O N 1� M N U) O O N N O M cc t0 N cc - N U) N O) CA �y 3• ' N :d '� O O O O co (D O O O O O tD u) IV U) O cD tf) O O O O O O M O O co O N O O - N o 0 ulj O M W c) M N tD C " CO T T N M ;. >" yw •` '? O N O O - co 00 O O O U') O co co P. © O O O O U) M O O O N O tO O ti U) O M V O N O N M N a- O M N M C O Cn O O O O CD O O O O CO 1.0 O O O t 0 O M O O O O O HC-4 N tT O Ch N t0 6) O N C6 N cq — M O t O O O O O co O U°) 07 O O O O O O N (.0 O 00 O ui t` I- et c- )- V U) O M a0 C O C7) M u) C� 0 O O M M et Q' t Uw �r M tD T t V O O co O O O O tt) 04 O 1.- (0 O O O O O O O O O Co U') to to O T O O N � O o Ui o N 00 o V o o tci T tci v N V 1-- N N O U') CO O O O O O N r- CO N O U') tL7 N N O O O O 00 •,1' M n �, O N c0 M O co O O O O m of •+ rF'4 tQ M CD M � C) V c(D O Q1 t r : _ _ � N N ( U) O O O M ( O O O O N 'LLpj O I� O O O O O O O O T U• I r c i lt7 O U) O U) CT u) U) O O O U') 00 O C I O O M N_ O M N co O d' �f T N M M N C 1- Cl) O O N CD "' of y£ O O O O O LO LC) O O- O co O OR n O O O O O N O O O N 0o M M O N O - N CO O M cco ccoo T - cOfl M 0 0 tcY N co U C Y U) .. CO O V W fi 5 O w Q Z W - + w < > C • �C •t F c N W N 4) V N W W ti M _> 0) C 0) C O Z W U O E N C m c Q Z kr + o w E E w t= c e w m a > to m CD a) E m C O a X .,. W W W CD Y W E c N > C` C c co I -> . W = 'C O C1 _0 Y O C0 O` O W CC O O o 0 0 0 CD 0 0 0 0 0 0 0 o O o O o O o 0 O u7 C7 N O O O Ch O c0 O I` O u) , N CD M N co M CD M a0 M co M co M co M O c0 c7 O W c7 O co M O 00 M p,� y U) In u7 u7 U) U) LO u U C� u) (D O co O Q M 33 �✓ W W L � 0 X N LU CD O d O o O CD O 0 O A 0 O 0 O 0 O y� 0 �j?' 0 0 0 o 0 d 0 Cl 0 0 0 o MY 0 o 0 0 0 0 0 0 0 0 0 o 0 d 0 o 0 o ' 0 « p Cl O 0 o 0 0 0 o 0 p 0 o 0 0 LO I C m V I� O Lo O O O Y� lf'i m T d O V' LP M O OO M V Cl) O CD N m M `. M£ C) O O 1� O O t-- CD 1� O O Lo m m !� +. N N O M O m c0 O O O O O W et$ , •� M a) O N Fr:, Cl) M O _ L M cD P I. L!') 00 M T M O) N 6) 00 O N LC M M M g m C-4 'S : "•r > T'.. M O M f� M O O O f 0 00 m O CD O O m N �Y 00 V hw ( 0 0 0 0 0 r O O O y %; O V d 0 0 0 0 i� O O m d' M m T m CT 0 0 0 0 0 �? co O O CD O d LC) tO T O O O O O O m 110 M O tO O co O O O O O 00 M 00 Lo p M m Lo M co N d CV O O, Lo - IT Ct ti v - " M .': CO Il C • O" O 1� Lo M . cD CD . N O O CD Y; O '. co O O d N O ."". 0 0 0 0 0 0( Lo I— �•t - 0 0 0 0 0 0 0 N t ��"" �,.i O O O C) 0 'r 0 0 0 0 Liz CO O wx 0 O O Ln O O O O O O O O N I� O 0 O 0 O 0 O 0 O 0 O 0 O 0 O a? ""two N co M N N I O to C'4 Z m M O O O'r m 0 0 cD O O O O O O O O M C' t1• V' O O O O O 0) i3.. I- M O N M q C O O O m 0) O •7 N O '- O M 0 0 0 0 m m 0 0 0 0 0 co cp m N C Cq O O O O cn" O N' m O O" O O O O� T M �f., r- cn 0 0 0 0 0 w "• ;'. m CD M O CO , N m CD M M tl' CD G M • $ Qr- N N Lo T N j M 2 'S". , y, (D e7' co O N L!7 M •k. 0 O 0 O 0 O r<,• O �." O ti CO M CD O N LC) O O O sssppp���,,, O t•` O O O 0 O 0 O 0 O 0 N Lo O D) C9 O "t O CV O 0 O 0 OO 0 0 O 0 �! m O co U7 r + O O O O m CV m r O O 0 0 0 0 0 0 CD m O ti M 0 0 0 0 0 L(7 co I- N M m O O '. F '•, LO O co co 1— 1� O 61 cO . N • 00 N N `_ N N Lo T -- 7a Oi N 9 t 3CSS».. Q> t ` O O T O O O" O O ls, O LO LO m m M 0 O 0 O Lf') LO 0 5i O O O CO cD 0 O 0 O 0 O 0 O C7) N m M M_ 0 0 0 0 0 0 0 0 < r•c. m T M m N ,� O O O O co O O N M M j O CD O O O O O 00 O w O O O O O M .N m CO CD N r-- O :. co N m Lo cD M ^� M cD O M N N N k ry ' i" N co O M O O O �- O' O M to N N O O M O O O O M 'd' N • Lo T 0 0 0 0 0 s •` O� r m I� O O 0 O 0 O 0 O O� d ci CD to M LC) . L N O C) O O M m O C) O 0 O 0 O 0 O 'V N I-- U') N M j 0) ti T I- O O Cl O' O O O O O O N O rzfi, M CD et • ft- i M co O M O N O O - m �`" 0 t O 0 O 0 O O p co d O O O O r-- c'M O O O O O M M 0 0 0 0 0 M m O N O O O O O <C G O O 0 0 0 H ' 0 0 0 0 0 O CD �_ CV % 0 0 0 0 4.:. m O CD I— m Cl O M m 0 0 0 0 Lf) N O N O m 0 0 0 0 0 0 0 c•'i O N CS) N M V L M ti m CJ) O O O O O O O G O m tn. <r r- O 0 r— Lo M LL') O O O O co M pp 6 O 0 CD 0 O 0 O 0 m C7) O cD O O v Lf') O O O O O O O O O O co N M Lo O O O Lo co M O t O M O O O O to to O d O Lo O O O wi i T• 0 3` m M O - CD Y,. k .. ti i` m N LP) I� N n N m O N N O O a;�- N CN Lo ' t(n R �Pf fir•. Q> M r— a' N N N O Lq M � 0 O O O O O }, O M O O O CD N m 0* 0 0 0 0 0 0 0 0 0 O X 0 0 0 0 0 ?5 O M O O O O T r— 0 O T 0 0 0 0 0 +• ty,��; m OD O M d' N O .t O O O O O O T° O M m O O O O d N M co 0 0 ti p 0 0 CD O O 7 M N N to N N O N aj$ ���SSS m cc Lf) M (( k CO . :. co CN 0 0 0 p M O O O co 0 0 0 CD M 0 C:> 0 0 0 0 0 I- OO M Imo 0 . 0 0 0 0 0 I� LO, C ) (A CV O O V r— O 0 O C) O 0 M Cl) 0 0 0 0 0 0 0 0 LO c7) M m M ? O M O 0 O 0 O 0 O 0 O 0 M ooc L� C' m N N m C M LLn RRRRRR'- m r N d .. } n a". •,�, w Qf; Lc') CA O 1.16 O T O Li') M n O O O O O O O - p Lo V V• M O O m CO 0 O 0 O 0 O c') c'M 0 0 0 0 0 0 m Lc) co M .—_ V �'. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 n ^i r•"'' LO m Lf) O O O i, O N M C7 I- O ,, O 3 O M O O O� '7 m LA 0 0 0 0 0 0 M ••, O m UD Oc (7) M N m O d• CD Cl) m M O O CD CO � n ! .4. - N N Lo N y r C m N �r N N Cl) � M O (D O m 00 O LO CO 'D O 0 O 0 O 'S? co N r— CD Lo O O LO O 0 O "' O Cl) O O M O O O O ;iY 775� 0 0 0 0 0 0 0 O O) Cl) O 0 0 0 Oi M N m O C7 CV O 0 O 0 O M M O O O O Lo r— Cl 0 0 0 0 0 0 0 >4 0 CD 0 O 0 O Lc') N O CD O 0 O 0 n M R r— : oc Lo LC) m N M � c .; m N N N' m a O m CA O) d O C^ N N LO N F: O M N M V N Lo M N ....ap.. - iF O O O O O O O k, 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O 0 O 0 d 0 0 0 0 0 CD 0 0 0 0 0 0 0 0 0 0 0 0 G X my Lo m O CD •. T CD LO O O LO O O CD O O '-T CV O 0 O O Lo 0 O 0 O 0 M 0 LL") 0 'C 0 O 0 LO 0 + Q d cO ( O- ch M co Cl) co C=) LO C) '6 L() N M Cl N 3 M M CD N N N V' � 0 ril F C CO, N N EL CL y YL E2 co a CL Fa d N d d 12 �1SY [p CD- C N w R R L ..n Q? U �• a N�.. C jj., C N C O a N c U C N = N L ¢ N N N R U Q .0 CD .�L N R C O. cn CL C> C co R O O Cn rn d O N rn y= co N R C � 'Si U c Y o °tS rn O1 0 4 m a) �. v Cn otS m m a) n sz N N E_ 3 Lt_ U D.. c n °) E 0 U N - y o y m a g 'o E n n N E a N c R ip.. L6 R e m e x a t Cn O N R N N :O N C CL N > N O Tj Cn` N rn N t— N qe L " N t L LS 4; N N N t O d R N O O L O O N O ,. �•C] ¢ H m ,P' O U 101 w m 0 s "i (5 F i= 0 O w O m U U O O U O> I- y, U••a ":; $ O O O O O O O O O O O 0 0 N 0 ^+- 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 �yI 0 p. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1� 0 C.') m 0 d 0 N N CO N d N N N Q N N L!') r cD N I� M N M M M O T M LC) C0 M CS) co M W M 00 V m M O et O to M Cl) Cl) O m O •¢ V �" t� m Q) C7) d �•L• M M +.7 L[') I� t` 00 C7) .' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2010 SPRING /SUMMER ICE REPORT i� .N' `, �`1 Su Descry ton " 4 � Y May10 +d un 10� 1" L'p,'- Jut`1� �'" 5 Jq i4 0� • �a' � P' p ? - b �r TOTALS INCOME (by use) $ 4,250.21 $ 14,417.65 $ 22,408.81 $ 26,886.25 $ 24,935.85 $ 92,898.77 Utilities ($7,800 baseline cost) $ - $ 1,654.00 $ 4,021.00 $ 7,544.00 $ 5,964.00 $ 19,183.00 Part -Time Staff $ 1,654.00 $ 2,952.00 $ 1,404.00 $ 1,402.00 $ 1,017.00 $ 8,429.00 Supplies $ 938.42 $ 1,013.70 $ 1,752.73 $ 895.49 $ 1,777.99 $ 6,378.33 Operating Expenses` $ 271.60 $ 269.98 $ 283.22 $ 268.13 $ 269.87 $ 1,362.80 Repairs $ 1,089.54 $ 2,150.72 $ 6,907.11 $ 1,238.70 $ 310.60 $ 11,696.67 Leam to Skate staff $ 1,132.00 $ - $ 818.00 $ 1,576.00 $ 1,085.00 $ 4,611.00 TOTAL $ 5,085.56 $ 8,040.40 $ 15,186.06 $ 12,924.32 $ 10,424.46 $ 51,660.80 Profit/(Loss) $ (835.35) $ 6,377.25 $ 7,222.75 $ 13,961.93 $ 14,511.391 $ 41,237.97 w POSITIVE FACTORS INFLUENCING THE 2012 BUDGET 1. Reduction of debt levies $225,842 2. Move funding for new trails to Capital Improvement Program $125,000 NEGATIVE FACTORS 1. Possible increase in health insurance $120,000 2. Loss of Market Value Homestead Credit $80,000 3. Increase in fuel costs $45,000 FUNDING REQUIREMENTS - USES (INCLUDING FIRE STATION LEVY) June 3, 2011 NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. 2011 2012 Adopted Proposed Departments Budget Budget Difference Percentage Council Budget $237,100 $280,500 $43,400 18.30% Administration Budget 516,600 515,700 (900) -0.17% Elections Budget 22,000 42,000 20,000 90.91% Finance Budget 422,400 425,800 3,400 0.80% General Government Budget 385,100 378,500 (6,600) -1.71% Community Development Budget 929,500 911,500 (18,000) -1.94% Police Budget 3,118,500 3,104,600 (13,900) -0.45% Fire Budget 303,600 377,700 74,100 24.41% Public Works Operating Budgets: Government Buildings Budget 491,900 484,400 (7,500) -1.52% Fleet Maintenance Budget 569,800 638,700 68,900 12.09% Street Maintenance Budget 1,370,100 - 1 (43,900) -3.20% Parks Maintenance Budget 736,200 773,100 36,900 5.01% Park & Rec Budget - General Operating 1,072,700 1,095,300 22,600 2.11% Park & Rec Budget - Steeple Ctr. Operations 87,500 58,900 (28,600) - 32.69% Park & Rec Budget - Special Programs 102,400 101,600 (800) - 0.78% Transfers - Arena Assistance 115,000 115,000 ._M- 0 0.00% Total Operating Budgets - General Fund $10,480,400 --- ----- $10,629,500 ---'-------------- $149,100 ---------- - - 1.42% Transfers - Debt Service Levies 362,376 0 (362,376) n/a Total Of All Budgets - General Fund $10,842,776 $10,629,500 ($213,276) _ -1.97% Building GIP Requirements 44,000 24,000 (20,000) - 45.45% Street CIP Requirements 710,000 720,000 10,000 1.41% Equipment CIP Requirements 439,000 460,000 21,000 4.78% Insurance Budget Requirements 245,000 245,000 0 0.00 % Port Authority Operating Levy 58,600 58,600 0 0.00% Bonded Indebtedness 168,914 441,327 272,413 161.27% Bonded Indebtedness - Fire Station Levy 143,654 0 (143,654) - 100.00% Armory Anticipatory Levy (Value 2/18/10) 86,000 86,000 0 0.00% "$2,060,560,350 x.00798% = $164,433 "` Water Enterprise Fund 1,173,000 1,267,300 94,300 8.04% Sewer Enterprise Fund 1,678,100 1,785,800 107,700 6.42% Storm Water Enterprise Fund 610,000 610,200 200 0.03% Arena Enterprise Fund 426,400 454,900 28,500 6.68% Total Funding Requirements $16,625,444 $16,782,627 $157,183 N 0.95% __________ _______ _ __ _ ___ _ _ _ _ __ ___ _ _ _ _ __ NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. FUNDING REQUIREMENTS -SOURCES (INCLUDING FIRE STATION LEVY) June 3, 2011 Levy Sources Special Levies 2011 2012 128,759 32.31% General Levy Adopted Proposed (150,993) +/- Types Budget Budget Difference Percentage Internal Revenue Generated: $429;507 $509,790 $80,283 18.69% Licenses and Permits 360,100 362,300 2,200 0.61% Intergovern mental 624,700 633,900 9,200 1.47% Charges for Services 658,400 668,400 10,000 1.52% Fines & Forfeits 125,000 125,000 0 0.00% Recreational Fees 252,300 254,900 ` 2,600 1.03% Miscellaneous Revenues 181,300 186,300 5,000 2.76% Transfers In 3,500 3,500 0 0.00% Enterprise Revenues 3,887,500 4,118,200 230,700 5.93% Total Internal Revenues 6,092,800 — 6,352,500 259,700 4.26% MVHC Cuts Made Later To Include in Levy 429,507 509,790 Levy Sources Special Levies 398,568 527,327 128,759 32.31% General Levy 10,563,583 10,412,590 (150,993) -1.43% Total Levy $10,962,151 $10,939,917 ($22,234) -0.20% Loss of MVHC from State Funding $429;507 $509,790 $80,283 18.69% Total Revenue Sources, $16,625,444 $16,782,627 $157,183 0.95% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Arm6ry Anticipatory Levies. 2011 GENERAL PROPERTY TAX LEVY PAYABLE 2012 GENERAL LEVY GENERAL FUND $8,904,990 BUILDING CIP FUND $24,000 STREET CIP FUND $720,000 EQUIPMENT CIP FUND $460,000 INSURANCE FUND $245,000 PORT AUTHORITY OPERATING LEVY $58,600 TOTAL GENERAL LEVY $10,412,590 BONDED INDEBTEDNESS G.O. PUBLIC FACILITY BONDS 2001C (Port Authority) (Authorized - $169,675) $0 G.O.- COMMUNITY CENTER REFUNDING BONDS 2001 E (Authorized - $93,311) $0 G.O. IMPROVEMENT BONDS 2003A (Authorized - $86,354) (City Assumed Special Assessments) $0 G.O. CAPITAL IMPROVEMENT PLAN (CIP) BONDS 2005A (Authorized - $211,486) $211,486 G.O. IMPROVEMENT BONDS 2006B (Authorized - $267,642) $0 G.O. EQUIPMENT CERTIFICATES 2007B (Authorized - $108,780) $0 PUBLIC SAFETY REVENUE BONDS 2007 (Dakota Communications Center) (Authorized - $62,948) $62,948 G.O. EQUIPMENT CERTIFICATES 2008A (Authorized - $90,913) $0 G.O. PUBLIC FACILITY REFUNDING BONDS 20106 (Old 2001C) (Port Authority) (Authorized - $166,893' $166,893 TOTAL BONDED INDEBTEDNESS $441,327 MARKET VALUE BASED REFERENDUMS 'G.O. FIRE STATION REFUNDING BONDS, 2005D (Authorized - $139,488) $0 ------------------- - - - - -- TOTAL FIRE STATION LEVY $p, PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($2,034,727,200 x.00798% = $162,372) (As of 1/8/11) $86,000 (Authorized - $162,372 - Only Levy Amount Due MSABC) ------ -- ----- _ ---- _ ---- TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS $86,000 - - -- --------------- - - -- GRAND TOTAL 2011 PROPERTY TAX LEVY $10,939,917 Last Updated 5/27/11 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) Total Funding Requirements Less: Internal Revenues Less: Market Value Based Levy - Fire Station (See Below) Equals: Revenues Needed Add Back in State MVHC Cuts to Reflect'Actual Levy Levy Certified by City to County Auditor County Auditor Adjustments (All Subtractions): Fiscal Disparities Distribution Levy (Metro Area) Spread Levy Used to Compute Local Tax Rate Increase /(Decrease) from Previous Year in Spread Levy Market Value Based Referendum Levy - Fire Station 1,141,159 1,195,913 1,299,717 1,299,717 (2) 10,140,221 (1) 9,801,133' (1) 9,518,780 (1) 9,640,200 - 3.34 - 2.88% 1.28% 146,084 142,273 143,654 0 (3) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2012 Number Provided by Dakota County as of x1xx111 (Until provided using 2011 number) (3) Market Value Based Levy for Fire Station - Based on $139,488 Levy Spread to Taxable Market Value on 118/11 Last Update from Dakota County 1/8/11 Shows the Levy of $139,488 / $2,034,727,200 = $.0686 per $1,000 as our Estimate (For 2012 No Levy needed so no impact on the taxpayers) Last Updated - 5127/11 ti (Proposed) 2009 2010 2011 2012 17,288, 034 17,059,244 16,625,444 16,782, 627 6,210,900 6,332,500 6,092,800 6,352,500' 146,084 142,273 143,654 0 (3) 10,931,050 10,584,471 10,388,990 10,430,127 350,330 412,575 429,507 509,790 11,281,380 10,997,046 10,818,497 10,939,917 1,141,159 1,195,913 1,299,717 1,299,717 (2) 10,140,221 (1) 9,801,133' (1) 9,518,780 (1) 9,640,200 - 3.34 - 2.88% 1.28% 146,084 142,273 143,654 0 (3) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2012 Number Provided by Dakota County as of x1xx111 (Until provided using 2011 number) (3) Market Value Based Levy for Fire Station - Based on $139,488 Levy Spread to Taxable Market Value on 118/11 Last Update from Dakota County 1/8/11 Shows the Levy of $139,488 / $2,034,727,200 = $.0686 per $1,000 as our Estimate (For 2012 No Levy needed so no impact on the taxpayers) Last Updated - 5127/11 ti a °01 0 Q R 3 1- - 5 ° o m y - m m x x m O m y n --1 m 0'2 y o m 0.7 N 0 o d m x x m 3 m m C n y o m #�— m m �i o Kto0 (7m o a t� p #� m q — $y()C!(1 m w n o n m m n ° M m v �y()C1N o a f� m Y. w ynn n w m a ' m t7 ° c f p °m �'"� m °O —.e m O' ° c 3= o �� m m m < o c o nma m °c p �'"� W Q m C1 �.- ° 3 fD — o .—° 2.'z o W d a > a� m '� m m a2• m m O A ,Z q D •2 m` 0 m z m p Iz . 0 It 11 W A OD �I z mmy °c 11 N 11 N T N N °c iom pmio o m 5. 2 m. m �- I x c0 w m• c 3 3 3 3 it 11 c o o I u I I N II II I 000 ii I I II j I �I coo 0 � Np O O 0 0 0 0 II j I U 0 0 0 II + O O O O p N d W O W O O o J � II S V +tO(D O I I W O J� V W V �Sm II j 10 W o OSN I II N N NN + �N N A II t 11 fF I I I O O O g I 11 + 1 0000 10 Q I II y i i O O O COO O II I I II + i 0000 I I p l N I II N I A + ++ goo S N C O II N I NA l0 d L +` II ti N N p O II ip6 I N AtN0A N + I + II O i � Lp N D� j V N W m Wow II m I tO S' O II O W �O V II jt i ( S t N °Ito i NNtDA OD t 1 A u i I II j 1 ( ii I I 11 ii i n I I o 0 o go o ri ! n o 0 0 0 ( ( ii I c o o II + 1 I I m II UIi Aj +++ ONS 11 6j N�I II ?I n IINI IVI + o o ONS n 5 II OW!UTINOV N NIm II N II Ol II N I O W NONN +A mm ! NO W OJTO) V N W W ONS W NO W II N 10+N II ( 1 DNA+ II W ml O O � I O 11 d> I N W I II 10 � +N+A 11 tp I N W 01J +NTO �m W N N O N Q OI OI V' Ot0 11 N I tO +N j 11 10NA+ I N N I ^.. p V +V 1101D10+ I I W O+ V 11 D7 b101D+ A O w O to �. O' 9. H ?. + Z a m m w x m o O q Z C y y N 0 —3 0 M i N m K m x N =39, C)a m 3 x 0 m y x ° a O O 1 N �•.°. Q. H II M II V + A + + N m 00 Z N T T O m m 0 1p II J_ II („f W jNJJ 11 II W W W+ OI O+ O �_ _ G II Of II O OI 10 W I N J A O a, 8 rn v jo W I N OI tIN m v O W 0.- S d 0 N 10 m 4 d O w w N m m m w O. T J a O �Z r 2 2 a it O II N I II N W 01 W O. m T m 7 N W A N II W II N N N W NOI N I N N N+ 0 3 6'`�m a o O m 3 N T + W d ® m 3 a 0 p m O 8 x w w C ii ii - q o O u L7 d -` 0m a _ w It 11 W A OD W N C d V W O � N + O 11 N 11 N T N N I N N+ w O to �. O' 9. H ?. + Z a m m w x m o O q Z C y y N 0 —3 0 M i N m K m x N =39, C)a m 3 x 0 m y x ° a O O 1 q m N I N N X N o O O N + S O 1 O a, 8 rn v jo W I N OI tIN m v O W 0.- S d 0 N 10 � d O w w N m m m w o O 2 2 a O p O D 3 o d a o O m 3 N T + W d w CO w. S 5 o 3 a 0 p - q o a _ w 0 0 00 � N + O 0 9 c 0 ii I I ii I 11 y O O O II 0 0 0 0 I N I II I j O O m O II + 8 Y O O O O O O O N m 8 N S II O I . N I O I 11 A i A 0 I A y 00 G O G N II O! �0 W N W N OON II O m10 OIN N I II J ' +V +V 11D�p W A ° II S O)OOIN W 0 z ii I I ii I 1i m II' I II GCC " I .T7 y O O O I I p p p p I N I O) I ! O O O 000 II O O N N A g l l S II N N O O O II O I O N N m A q 3 O N II N I j O) t A II I O N O II N N 10 A N W n $ I. 1p IO pI N O O I I A O + N N W O N O I I I t0 + O) + I W d Ol In II 01 ( tONAS N I + I II tp i +m+W ON JJ Hm p II tONAOI W O m 2 V O+ II W I W 0+ O 1 0 II m i+ N N p I N fp N V v V II W I 1p t0 10 + W j a I 10 q ii I i ii n I f p A Cf i II I I N I m o 1 00o ii o000 j 1! I co ii I o00o I 9 p j O N II m N t V I fii ! II N j ONO 11 O O N N A N N.I m G II N 10 +N N 11 m i A _ NNtp ONp 11 _N 1 �1 t0 N W Ot0 11 Ol I StDN+ O » I 11 W I +N N> N0. �• W OtD 11 I tON A+ W l 0 3. s o J+ V J J 11 W I f 0 10 { O+ W I I+ .� 11101 c ° 0 0 II I I 11 ! I 11 I I 1 v m m C 0 0 0 O o 0 O O O I I C 00 O O t N I I I 1 1 bob I +! O O O O I N 6 000 11 O N N A 0 11 N _ i 00"000 II O O N N A ! < II OI N W N N J II II I A N V W W Z 1 N (a S I I N I 3 D II V NONN II +A+A i 10 O1 t0 t0 NNO1 11 O I W NNN I 3 X OIAN II t0 A V V+ 11 J 1 010 W N +AmN ��N II N V. +10 W 0),I ! I'll Ca II I I t o I I 11 I I 11 11 I 'w O O O I I O O O O O N I O ' 1 O O o I I C 0.. I I t p I p N N A I O I' Z I I N + 000 SST II v A+NN (b e II N 1 ONQ II O O O l N I + tp II 10 ++A I i II A A ttpp A y Ol O N � II ep I 1p+0I O pI pl V V N II N I tp W m A 1 � II N I+ N+ A I t0 10 W N N O II m i f0 N A 01 + A W II W I W O)A O i � 11 N +NAN NNNO V� V 11 y l tD tD 10-+ N I S 71 II m II I II � 11 I I I II I I 000 II I N I N m 0 0 "II o 100oo I N N A X I 1 0 0 0 I I N 2 X m i x m n m T S N O _ O 0 0 u 3 S m 0 m ^ n w N O O N O o - . 8 a� o N O N O 0 0 pp N O I I A A A O S 11 i 10 + S W I b I m II > I A �tD 1p 1Ap N OG J W W 11 tO 101S + W I 19d 11 V i + (PA V I SSfT S + N + 0 i Y II I m II I i 0 0 0 I I + I I w II 0 0 0 II O O O O N C II N N S 11 O I W N W O I m 1 W_ p I t0 V J I V II O I Oo 1001N II W S NN I A W 10N �SN 11 N I J +tOy H II O NOO OGII I NOIO V C I. I I II O NO II N � W 10 A I i d II OOS II rpOp1 I ONN A I s l a 11 W W I OOO II ; INI II O GO II +! 0 0 0 0 I i i II I I II t0 N A II O1 V N N N W v V m w q O t o C1 7;-: m m 3� m 1 q m q � X N m 0 w 0 A � � q d 10 � 0 N I N J I I O O N N A ONO II N + 1°Ip N j O i m I m V � � II dr t0 t0 1 + OI I I 0 N O N m 000 II bob OO�OpO II O ONNA o�N II N I .! O I O 000 O O II S 1 d i m 1N0A W .O o; + io O O O II 0 0 0 0 I N I O O N 2. A ON II � � NJ {.J NO+b II m I NtO t O I N( j IN O' N W � A 1 5 Page One June 3, 2011 Account # 2012 BUDGET WORKSHEETS GENERAL FUND REVENUES Description 2008 Actual r 2009 Actual 2010 Actual 2011 Adopted Budget 2012 Object Detail Amount 2012 Proposed Budget 101 31010.00 Current Ad Valorem Taxes $6,732,360 $6,697,852 $7,013,792 $7,767,266 $7,605,273 From County (Includes No D/S Levies) 101 31040.00 Fiscal Disparities 968,892 1,141,159 1,195,913 1,299,717 1,299,717 From County Total Taxes (Tax) 7,701,252 7,839,011 8,209,705 9,066,983 8,904,990 Total Property Tax Levy for Fund 101 (429,507) (509,790) State Cuts in MVHC 8,637,476 8,395,200 Actual Property Taxes to Receive 101 32110.00 Alcoholic Beverage Licenses (L) 32,657 36,035 51,533 40,000 40,000 101 32160.00 Licenses to do Business (L) 7,730 8,430 10,455 7,500 8,000 Garbage Haulers, Ped Licenses, etc. 101 32162.00 Lic to do Business - Rental Housing (L) 13,191 1,345 15,337 1,000 13,000 101 32210.00 Building Permit Revenue (L) 489,002 281,984 272,975 200,000 200,000 101 32212.00 Mineral Extraction Permit (L) 2,180 1,480 1,110 1,500 1,200 101 32220.00 Electrical Permit Revenue (L) 15,795 13,238 13,555 13,000 13,000 101 32221.00 Admin Fee - Electrical Permits (L)" 7,990 7,040 7,270 7,000 7,000 101 32230.00 Plumbing Permit Revenue (L) 53,994 30,058 26,250 35,000 30,000 101 32240.00 Animal Licenses (L) 2,442 2,663 2,397 2,500 2,500 101 32250.00 Sewer Permit Revenue (L) 7,252 6,585 12,891 7,000 7,000 101 32255.00 County Recording Fee - City's (L) 30 100 70 100 100 ` 101 32260.00 HVAC Permit Revenue (L) 66,133 41,073 39,117 45,000 40,000 101 32290.00 Other Non -Bus Lic & Permits (L) = 360 520 940 500 500 Alarm Permits & Fireworks Permits Total Licenses & Permits (L) 698,755 430,551 453,900 360,100 362,300 101 31010.00 Current Ad Valorem Taxes (1) 91,000 w 80,000 80,000 86,000 86,000 Included in Debt LevyFigure 101 31010.01 MSABC Armory Payments 86,000 101 31020.00 Delinquent Ad Valorem Taxes (1) 139,641 150,317 169,891 0 0 From County 101 31030.00 Mobile Home Taxes (1) 8,834 15,330 13,026 9,000 12,000 From County 101 31710.00 Gravel Taxes (1) 15,348 13,390 46,073 45,000 40,000 From County 101 31810.00 Franchise Taxes - Regular Fees (1) 169,415 185,886 193,997 180,000 190,000 From Cable Company 101 31811.00 Franchise Taxes - PEG Fees (1) 23,905 25,001 24,739 25,000 25,000 From Cable Company 101 31920.00 Forfeited Tax Sale Apportionment (1) 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 (1) 147,847 145,036 147,975 144,000 From State 101 33416.01 Post Board Training Reimb 7,500 4,000 101 33416.02 State Aid (Tied to PERA) 139,500 140,000 101 33418.00 MSA for Streets - Maintenance (1) 29,115 30,165 30,165 30,000 30,000 From State 101 33423.00 Ag Preserves Credit (1) 628 659 1,484 500 700 From State 101 33425.00 Other State Grants & Aids (I) 21,882 44,537 31,087 21,000 25,000 From State -PERA Aid & Safe & Sober 101 33620.00 Other County Grants & Aids (1) 82,803 60,100 19,500 19,000 19,000 Dakota County Recycling Funds 101 33630.00 Police Services Levy -ISD #196 (1)' 63,620 64,603 67,284 62,200 62,200 101 33630.00 Liaison Funding 62,200 From ISD #196 Total Intergovernmental (1) 794,038 815,023 825,221 624,700 633,900 PAGE TOTALS 9,194,045 9,084,585 9,488,825 9,622,276 9,391,400 D Page Two June 3, 2011 Account # 2012 BUDGET WORKSHEETS GENERAL FUND REVENUES, Description r 2008 Actual 2009 Actual 2010 Actual 2011 Adopted Budget 2012 Object Detail Amount 2012 Proposed Budget Comments 101 34103.00 Zoning & Subdivision Fees (C) 39,000 28,215 33,310 35,000 35,000 101 34104.00 Plan Checking Fees (C) 174,452 89,352 89,313 80,000 80,000 101 34105.00 Sales of Maps & Publications (C) 1,102 517 364 1,000 500 Maps & Spec Books 101 34106.00 Deputy Registrar Fees (C) 58,703 8,731 0 0 0 Dakota County Took Over Feb. 2009 101 34108.00 Admin Fees - Other Funds (C) 47,750 25,000 101 34108.01 Applicable Funds Except Const. 25,000 25,000 25,000 25,000 25,000 101 34108.02 Construction Funds 91,434 79,141 10,027 0 0 101 34109.00 Other Charges for Service (C) 8,309 7,074 6,286 7,000 6,000 101 34110.00 Service Chg on Returned Chks (C) 180 90 148 200 200 101 34112.00 Utility Permit Application Fee (C) 2,129 0 1,120 1,000 1,000 101 34113.00 Application Fees (C) 5,000 0 0 0 0 101 34150.00 User Fees - SKB (C) 339,518 128,745 112,314 200,000 120,000 SKB Fees - C & D Cell Fees 101 34151.00 User Fees /Host Agreements - SKB(C) 25,000 102,955 162,306 105,000 165,000 101 34151.00 Landscaping Agreement 25,000- Landscaping Agreement (Yr 9 of 10) 101 34151.00 Trust Fund - City Portion 140,000 101 34152.00 User Fees - SKB (C) 0 8,782 16,885 20,000 20,000 SKB Fees - MSW Ash Charges 101 34153.00 User Fees - SKB (C) 0 100,491 135,229 100,000 120,000 SKB Fees - Base Service Charges 101 34160.00 National Guard Maint Fees (C) 51,445 47,488 48,456 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) 52,675 18,199 15,160 19,000 19,000 Contractual O/T for Officers 101 34202.00 Fire Services - Burning Permits (C) 800 300 850 0 0 No Longer Charge for Permits 101 34203.00 Accident Reports (C) 19 0 25 0 0 101 34204.00 Day Care Inspection Fees (C) 100 350 500 200 200 101 34206.00 Other Police Services (C) 713 12,944 550 0 0 101 34207.00 Other Fire Protection Services (C) 21,510 15,700 21,043 17,000 101 34207.01 U of M Fire Contract 6,000 6,000 101 34207.02 Coates Fire Contract 4,000 10,000 101 34207.03 Other Billed Fire Calls 5,000 1,000 101 34303.00 Mow Weeds (C) 2,551 1,662 1,331 1,500 1,500 101 34304.00 Sweep /Plow Streets (C) 0 0 730 0 0 101 34306.00 Other Highway & Street Rev (C) 20,551 6,245 11,982 0 6,000 Street Light Bills - Developers 101 34310.00 Right -of -Way Permits (C) 17,990 4,934 4,715 0 4,000 101 34407.00 City Share of Metro SAC Chgs (C) 6,742 2,209 2,154 2,500 2,000 Total Charges for Services (C) 992,674 689,124 699,796 658,400 668,400 101 35101.00 Court Fines (F) 127,239 121,618 113,675 125,000 125,000 From County Total Fines & Forfeits (F) 127,239 121,618 113,675 125,000 125,000 101 34718.00 Tournament Fees ® 0 0 0 0 7,000 New Fee for 2012 101 34719.00 Player Maintenance Fees (R) 0 0 0 9,000 9,000 New Fee for 2011 101 34720.00 Park Reservations (R) 4,881 3,789 3,984 3,500 4,000 101 34721.00 Softball Revenues (R) 64,980 54,636 66,288 54,000 45,000 101 34722.00 Volleyball Revenues (R) 0 0 0 0 0 101 34724.00 Tennis Revenues (R) 2,522 2,016 2,490 2,000 2,400 101 34725.00 Tiny Tot Revenues (R) 18,334 13,674 5,934 0 0 Eliminated Program in 2010 101 34726.00 Rosettes Revenues (R) 1,110 1,625 1,974 1,600 1,600 101 34727.00 Field Trip Revenues (R) 4,500 1,000 101 34727.01 Youth/Teen Trips 4,658 799 0 0 10134727.02 Adulf/SeniorTrips 1,735 3,897 1,384 1,000 101 34728.00 Adult Soccer League Revenues (R) 10,391 0 14,866 10,000 10,000 No League in 2009 101 34730.00 Run for the Gold Revenues (R) 4,397 4,659 4,527 4,600 4,600 101 34731.00 Youth Soccer Lessons (R) 3,335 3,648 4,011 3,500 4,000 101 34732.00 Adult Basketball Revenues (R) 1,406 1,870 2,147 2,000 2,000 101 34733.00 Other Programs Revenues (R) 13,468 13,981 20,298 14,000 20,000 101 34735.00 Camps Revenues (R) 13,095 15,960 19,571 14,000 19,000 101 34736.00 T -Ball Lessons (R) 5,287 5,092 5,887 5,000 6,000 101 38080.00 Banquet Room Fees (R) 75,555 60,413 55,435 62,000 60,000 101 38081.00 Auditorium Fees (R) 6,059 7,331 8,535 7,000 9,000 101 38082.00 Gymnasium Fees (R) 28,864 32,174 25,062 30,000 27,000 101 38086.00 Classroom Fees (R) 9,386 9,838 7,548 10,000 8,000 101 38096.00 Liquor Provider Fees (R) 1,230 900 540 1,300 800 101 38097.00 A/V Rental Fees (R) 1,221 530 255 800 500 101 38154.00 Teen Night Revenues (R) 6,660 2,697 100 0 0 Eliminated Program in 2010 101 38201.00 Rental Revenues 0 0 6,575 7,500 10,500 Steeple Center Operations 101 38203.00 Rental Revenue - Churches 0 0 0 2,000 0 Steeple Center Operations 101 38205.00 A/V Rental Revenues 0 0 0 500 500 Steeple Center Operations 101 38207.00 Liquor Provider Revenues 0 0 0 500 0 Steeple Center Operations 101 38209.00 Miscellaneous Revenues 0- 0 0 3,000 3,000 Steeple Center Operations 101 38211.00 Security Services 0 0 700 0 0 Steeple Center Operations Total Recreation Fees (R) 278,574 239,528 258,110 252,300 254,900 PAGE TOTALS 1,398,487 1,050,271 1,071,581 1,035,700 1,048,300 c Page Three June 3, 2011 Account# 2012 BUDGET WORKSHEETS GENERAL FUND REVENUES Description 2008 Actual 2009 Actual 2010 Actual 2011 Adopted Budget 2012 Object Detail Amount 2012 Proposed Budget Comments 101 36101.00 Principal - Special Assessments (M) 15,680 10,803 9,450 5,000 1,000 From County - 101 Funded Projects 101 36102.00 Penalties & Interest - S/A (M) 31 17 113 0 0 From County 101 36210.00 Interest Earnings - Investments (M) 223,236 180,401 165,773 150,000 140,000 101 36214.00 Net Change in FV- Investments (M) 3,624 (8,113) (43,787) 0 0 Annual Market Value Changes 101 36215.00 Interest Earnings (M) 1,128 3,063 1,349 2,000 1,000 From Checking Account 101 36220.00 Rents & Royalties (M) 45,281 59,948 19,325 17,300 17,300 101 36220.01 Verizon Antenna Rent a 12,500 101 36220.02 Athletic Complex Land Rental 3,000 Leasing Less Land Leasing Less Land 101 36220.03 MVTA -RCC Parking Lot Rental 1,800 101 36230.00 Contribution /Donations (M) 22,580 37,764 18,639 0 0 101 36260.00 Other Revenue (M) 5,582 40,497 98,882 2,000 2,000 101 36262.00 Special Settlements (M) 0 0 0 0 0 101 36265.00 Use of Reserve Funds (M) 0 0 0 0 20,000 Elections Balancing 101 38090.00 City Concessions (M) 4,986 4,846 4,903 5,000 5,000 Total Misc Revenues (M) 322,127 329,229 274,645 181,300 186,300 101 39202.00 Contribution from Enterprises (T) 3,500 3,500 3,500 3,500 3,500 Arena - Building & Grounds Maint. 101 39203.00 Transfer From (T) 7,133 19,964 0 0 0 Funds Returned from Project Total Transfers In (T) 10,633 23,464 3,500 3,500 3,500 PAGE TOTALS $332,760 $352,693 $278,145 $184,800 $189,800 FUND TOTALS $10,925,291 $10,487,548 $10,838,551 $10,842,776 $10,629,500 INTERNAL REVENUES $3,224,040 $2,648,537 $2,628,847 $2,205,300 $2,234,300 Grand Total Less: Ad Valorem -- ---------- ---- - - - - -- --- - - - - -- - &Fiscal Disparities Page Four 2012 BUDGET WORKSHEETS GENERAL FUND REVENUES June 3, 2011 Account # ` Description 101 34108.00 101 34108.01 101 34108.02 101 34108.03 101 34108.04 101 34108.05 101 34108.06 101 34108.07 101 34108.08 101 34108.09 General Fund Admin Fees Fund 201 Fund 202 Fund 203 Fund 206 Fund 207 Fund 605 Fund 606 Fund 607 Fund 650 Admin Fees Breakdown Totals Comments 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $25,000 $25,000 $25,000 $25,000 $25,000 6,000 2,500 2;500 2,500 2,500 1,000 1,000 1,000 6,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 Comments Page One 2012 BUDGET WORKSHEETS COUNCIL June 3, 2011 Account # Description 101 41110 103.00 Salaries & Benefits 101 41110 01 225.00 Landscaping Materials 101 41110 01 307.00 City Promotional Fees 101 41110 01 307.01 Newsletter 101 41110 01 307.02 Chamber of Commerce Directory 101 41110 01 307.03 Community Survey 101 41110 01 319.00 Other Professional Services 101 41110 01 319.01 Education Reimbursement 101 41110 01 319.02 Intergovernmental Initiatives 101 41110 01 319.04 Technology Study 101 41110 01 321.00 Telephone Costs 101 41110 01 321.01 Mayor's Pager 101 4111001 321.02 Mayor's Cell Phone 101 4111001 329.00 Other Communication Costs 101 4111001 331.00 Travel Expense 101 4111001 331.01 NLC Conference 101 41110 01 331.02 Miscellaneous Travel 101 41110 01 43100 Dues & Subscriptions 101 41110 01 433.01 LMC Dues 101 41110 01 433.02 AMM Dues 101 41110 01 433.03 Dak Cty Regional Chamber 101 41110 01 433.04 NLC Dues 101 41110 01 433.05 Miscellaneous Dues 101 41110 01 435.00 Books & Pamphlets 101 41110 01 437.00 Conferences & Seminars 101 41110 01 437.01 Registration & Hotel -LMC Conf 101 4111001 437.02 Registration & Hotel -NLC Conf 101 41110 01 437.03 Miscellaneous Conferences 101 41110 01 439.00 Other Miscellaneous Charges 101 4111001 598.00 Council Designated 101 4111001 598.01 Library Site Expenditures 101 4111001 598.02 Future Capital Expenditures 101 4111001 598.03 Salary & Benefit Contingency 101 41110 01 599.00 Employee Recognition Costs 101 41110 01 599.01 Employee Recognition Costs 101 41110 01 599.02 Vending Machine Costs 101 41110 01 599.03 Commemorations 100,000 PAGE TOTALS 8,838 DEPARTMENT TOTALS 24,400 14,368 14,191 14,806 2011 2012 Object 2012 6,423 2008 2009 2010 Adopted Detail Proposed 1,302 Actual Actual Actual Budget Amount Budget Comments 1,600 1,600 120 0 140 All Salary Costs Inclusive of ^ $31,253 $36,017 $35,761 $36,800 0 $36,000 Salary, Taxes, PERA & Benefits 25,154 77,500 25,026 25,000 25,000 SKB Landscaping Agreement 515 350 590 1,000 1,000 19,100 4,363 27,718 25,005 20,237 18,000 18,000 540 Reduce From 5 to 3 Newsletters 2,130 0 2,138 1,100 1,100 145 231 0 20,000 0 0 0 18,935 100,000 100,000 150,000 Yearly Contingencies 8,838 1,788 0 9,000 0 5,834 11,473 6,067 12,000 8,000 0 0 0 903 3,000 1,000 Contingency for Negotiations 1,000 0 0 0 0 400 0 0 0 0 0 63 378 378 400 400 0 2,760 252 500 500 Newspaper Ads / Open Houses 2,700 1,627 964 0 1,200 1,200 1,185 1,133 1,009 1,500 1,500 24,400 14,368 14,191 14,806 15,000 15,000 6,423 6,782 6,912 7,000 7,000 579 1,302 (651) 800 800 1,432 2,978 1,489 1,600 1,600 120 0 140 0 0 46 0 0 100 100 6,000 515 350 590 1,000 1,000 4,363 2,768 0 4,000 4,000 540 1,185 150 1,000 1,000 16 145 231 100 300 36,815 3,257 18,935 100,000 100,000 150,000 Yearly Contingencies 8,838 1,788 0 0 0 254,648 0 0 0 0 0 0 0 0 50,000 Contingency for Negotiations 7,000 3,108 2,498 3,487 2,700 2,700 3,607 4,063 3,406 3,500 3,500 0 723 1,044 800 800 $431,383 $217,261 $142,309 $237,100 N $280,500 $431,383 $217,261 $142,309 $237,100 $280,500 Offset by Revenue from Machines B io Page One 2012 BUDGET WORKSHEETS ADMINISTRATION June 3, 2011 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget' Comments All Salary Costs Inclusive of 101 41320 101.00 Salaries & Benefits $369,001 $393,980 $408,204 $434,000 $443,300 Salary, Taxes, PERA & Benefits 101 41320 102.00 Full -Time Overtime 1,712 0 0 300 300 101 41320 103.00 Part-Time Salaries & Benefits 6,549 4,232 2,056 700 700 Temp Receptionist Coverage 101 41320 01 209.00 Other Office Supplies 129 0 94 300 300 Miscellaneous Purchases 101 41320 01 306.00 Personnel Testing & Recruitment 0, 0 0 0 0 101 41320 01 313.00 Temporary Service Fees 28,774 0 0 0 0 101 4132001 319.00 Other Professional Services 0 0 0 0 0 101 41320 01 321.00 Telephone Costs 1,094 1,311 1,083 1,500 1,500 Administration Cell Phones 101 41320 01 331.00 Travel Expense 1,000 101 41320 01 331.01 NLC Conference 0 317 0 0 0 101 4132001 331.02 ICMA Conference 873 0 422 500 600 101 41320 01 331.03 Miscellaneous Travel 40 348 325 400 400 101 41320 01 433.00 Dues & Subscriptions 2,400 101 41320 01 433.01 MCMA Dues 191 199 215 200 300 101 41320 01 433.02 MAMA Dues 80 45 45 50 50 101 41320 01 433.03 MCFOA Dues 0 35 35 50 50 101 41320 01 433.04 Munici -Pals 25 25 85 50 100 101 41320 01 433.06 ICMA Dues 2,213 741 1,716 1,500 1,800 101 41320 01 433.07 APMP Dues 63 45 90 50 100 101 41320 01 435.00 Books & Pamphlets 92 0 0 200 100 101 41320 01 437.00 Conferences & Seminars 6,300 101 41320 01 437.01 Registration & Hotel - LMC 0 200 500 500 800 101 41320 01 437.02 Registration & Hotel - MCMA 1,033 1,287 1,633 1,300 1,500 101 41320 01 437.04 Staff (1) Each 75 0 0 200 200 101 41320 01 437.05 Miscellaneous Seminars 2,579 955 240 500 300 ULI / Greening Initiatives 101 41320 01 437.06 Registration & Hotel.- ICMA 2,415 0 2,306 2,500 2,500 101 41320 01 437.07 City Clerk Training 1,020 689 680 800 800- All MCFOA Events 101 41320 01 437.08 Registration & Hotel - NLC 0 1,219 0 0 0 101 41320 01 437.09 Miscellaneous Meetings 95 309 6 400 200 101 41320 01 439.00 Other Miscellaneous Charges 26 295 0 100 100 101 41320 01 580.00 Other Equipment Purchases, 895 536 841 900 900 PAGE TOTALS - 418,975 -- ---- - - - --- 406,766 --- - - - --- 420,574 - --- --- ---- -- 447,000 - ----- - - - - -- 456,900 Page Two 2012 BUDGET WORKSHEETS ADMINISTRATION June 3, 2011 I* iz 2011 2012 Object 2012 2008 2009 2010 Adopted Detail . Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 101 41320 31 305.00 Medical & Dental Fees 1,500 Employee Drug Testing 101 4132031 305.01 Pre - Employment Physicals 846 558 597 500 500 101 4132031 305.02 Employee Drug Testing 871 164 658 1,000 1,000 101 4132031 315.00 Special Programs 1,500 101 41320 31 315.01 Employee Training 1,629 1,178 212 1,000 1,000 101 41320 31 315.02 Health & Wellness 1,427 1,842 51 1,000 500 Wellness & Health Management 101 41320 31 315.03 EAP 699 0 0 0 0 E Now Covered with Insurance 101 41320 31 319.00 Other Professional Services 4,000 101 41320 31 319.01 Labor Consultant 600 0 694 300 300 1014132031319.02 Labor Legal, Issues 0 2,835 0 900 700 101 41320 31 319.04 COBRA Consultant 0 692 624 800 800 101 41320 31 319.05 . FlexIVEBA Administrative Fees 2,325 1,746 1,751 2,200 2,200 101 41320 31 319.06 SWWC Co- Operative Dues 0 0 0 0 0 101 41320 31 331.00 Travel Expense 517 188 313 400 400 101 41320 31 341.00 Employment Advertising 2,504 709 1,727 700 700 Vacancies 101 41320 31 433.00 Dues & Subscriptions 500 101 41320 31 433.01 "Future Use" 350 0 0 0 0 101 41320 31 433.02 IPMA Dues 145 145 145 200 200 101 41320 31 433.03 MPELRA Dues 400 345 290 300 300 101 41320 31 435.00 Books & Pamphlets 315 233 0 200 100 Books & Training Materials 101 41320 31 437.00 Conferences & Seminars 500 101 41320 31 437.01 MPELRA State Conference 370 315 0 300 300 101 41320 31 437.02 Personnel Seminars 105 107 300 200 200 101 41320 31 437.03 Safety, Supervisor, Policy 0 0 0 0 0 101 41320 41 315.00 Special Programs 4,243 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 10141320 41 319.00 Other Professional Services 1,020 2,356 1,043 1,100 101 41320 41 319.01 Website 0 0 0 1,100 1',100 101 41320 41 319.02 Website Improvements 0 0 0 10,000 0 101 41320 41 328.00 Cable Supply Costs 198 340 2 500 500 Cable Supplies, Software 101 41320 41 329.00 Other Communication Costs 0 0 0 45,600 101 41320 41 329.01 Cable JPA Payment - General City 41,462. 42,823 41,998 43,000 43,000 101 41320 41 329.02 Video Streaming Council Mtgs 4,739 4,760 4,799 0 0 101 4132041 329.03 Bulk E -Mail System 2,508 2,508 2,508 2,600 2,600 101 41320 41 331.00 Travel Expenses 174 60 40 200 200 101 41320 41 433.00 Dues & Subscriptions 60 120 200 100 100 MAGC 101 41320 41 437.00 Conferences & Seminars 55 75 0 100 100 Technical Courses 101 41320 41 580.00 Other Equipment Purchases 988 2,242 827 1,000 1,000 PAGE TOTALS - -- - $68,550 -- ---- --- -- $66,341 - - - --- - $58,779 --- ----- --- - -- $69,600 -- ---------- - --- ---- - - - - -- $58,800 DEPARTMENT TOTALS $487,524 $473,107 $479,353 $516,600 $515,700 I* iz Page One 2012 BUDGET WORKSHEETS ELECTIONS June 3, 2011 rf Account # Description 101 4141001 103.00 Part-Time Salaries 101 4141001 203.00 Printed Forms & Paper 101 4141001 208.00 Miscellaneous Supplies 101 41410 01 219.00 Other Operating Supplies 101 41410 01 242.00 Minor Equipment 101 41410 01 304.00 Legal Fees 101 41410 01 319.00 Other Professional Services 101 41410 01 321.00 Telephone Costs 101 41410 01 351.00 Legal Notices Publishing 161 41410 01 409.00 Other Contracted Repair & Maint 101 41410 01 409.01 Maintenance for AutoMarks 101 41410 01 409.02 Maintenance for Accuvotes 101 41410 01 412.00 Building Rental 101 41410 01 439.00 Other Miscellaneous Charges 101 41410 01 580.00 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 127 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $30,001 $133 $20,755 $10,000 $35,000 Election Judges 3,311 0 0 2,200 1,500 Ballots & Programming 617 0 656 400 1,000 777 0 236 300 300 Food for Election Judges 1,218 0 192 500 1,000 Signs & Miscellaneous 0 0 2,017 0 0 0 0 0 0 0 86 0 0 0 0 0 0 0 0 0 Election Publications 2,600 1,225 1,225 1,225 1,300 1,400 Voting Machines 1,000 1,000 1,000 1 1,200 Voting Machines 0 0 0 0 0 Possible Rent for Locations 0 0 0 0 0 1,234 600 638 6,300 600 $39,468 $2,958 - - $26,719 --- --- - -- $22,000 -- -- ------ ----- --- --- $42,000 $39,468 $2,958 $26,719 $22,000 $42,000 127 Page One 2012 BUDGET WORKSHEETS FINANCE June 3, 2011 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of - 101 41520 101.00 Salaries & Benefits $248,981 $284,536 $294,584 $305,100 $312,800 Salary, Taxes, PERA & Benefits 101 41520 102.00 Full -Time Overtime 2,257 2,689 2,327 1,500 2,000 101 41520 103.00 Part-Time Salaries & Benefits 35,363 37,214 41,202 45,900 46,600 101 41520 01 321.00 Telephone Costs 137 659 1,245 1;400 1,300 Cell Phone Allowances (2) 101 4152001 331.00 Travel Expense 700 101 41520 01 331.01 Finance Director 1,015 678 457 500 500 Miscellaneous (National Cut) 101 41520 01 331.02 Staff 6 18 0 200 200 101 41520 01 391.00 P.C. Maintenance 46,600 101 41520 01 391.01 Civic Systems Applications Support 5,187 5,316 5,428 5,700 0 Move to Utilities 101 41520 01 391.02 Citrix Maintenance Renewal 959 959 962 1,000 1,000 101 4152001 391.03 Incode Software Maintenance 6,642 7,593 7,939 8,000 8,700 101 4152001 391.04 General Network Support 49,657 25,000 20,000 20,000 20,000 200 Hours of Support Time 101 41520 01 391.06 Fixed Asset Maint Contract 1,211 1,383 1,384 1,400 1,400 10141520 01 391.07 Miscellaneous P.C. Repairs 1,957 2,697 902 2,800 2,500 101 41520 01 391.08 Anti -Virus Software Renewal 7,493 5,951 4,866 4,000 5,000 101 41520 01 391.09 File Server Software Maintenance " 795 1,475 7,160 9,000 8,000 101 41520 01 392.00 P.C. Accessories & Supplies 3,059 3,478 3,383 4,000 4,000 City System Supplies 101 41520 01 393.00 P.C. Hardware Purchases 13,679 1,967 2,351 2,500 2,500 101 4152001 394.00 P.C. Software Purchases 5,000 101 41520 01 394.01 Annual Microsoft Office Payment 9,811 9,811 9,846 0 0 Final Pymt 2010 Thru 2011 101 41520 01 394.02 Miscellaneous SAN Purchases 160 2,779 3,008 5,000 5,000 101 41520 01 409.00 Other Contracted R & M 105 165 165 200 200 Non - Computer Equipment 101 41520 01 433.00 Dues & Subscriptions 800 101 41520 01 433.02 MnGFOA - Finance Director s 60 60 60 1 70 101 41520 01 433.03 MnGFOA - Staff 360 360 360 450 380 101 41520 01 433.04 GFOA - Finance Director & Asst. 325 335 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 37 0 0 50 50 101 41520 01 435.02 Finance Related Books 0 0 0 50 50 101 41520 01 437.00 Conferences & Seminars 2,000 101 41520 01 437.02 MnGFOA Annual Conf (F /D & Ass't) 551 558 565 1,000 1,000' 101 41520 01 437.03 GFOA National Conf (F /D) 1,111 1,437 0 0 0 Cut for 2011 & 2012 101 41520 01 437.04 Staff Development 0 125 218 500 500 101 41520 01 437.05 Miscellaheous Seminars 230 245 652 500 500 101 41520 01 439.00 Other Miscellaneous Charges 155 220 151 200 200 Contingencies 101 41520 01 570.00 Office Equipment & Furnishings 0 889 910 1,000 1,000 Office Chairs PAGE TOTALS $391,299 $398,596 $410,465 $422,400 $425,800 DEPARTMENT TOTALS $391,299 $398,596 $410,465 $422,400 $425,800 14- Page One 2012 BUDGET WORKSHEETS GENERAL GOVERNMENT June 3, 2011 Account # Description 101 41810 01 202.00 Duplicating & Copying 101 41810 01 202.01 Records Retention 101 41810 01 202.02 Copying Costs 101 41810 01 203.00 Printed Forms & Paper 101 41810 01 203.01 Copy Paper 101 41810 01 203.02 General Receipt Books 101 41810 01 203.03 Purchase Orders 101 41810 01 203.04 Payroll & A/P Checks 101 41810 01 203.06 Miscellaneous Forms 101 41810 01 204.00 Envelopes & Letterheads 101 41810 01 204.01 Letterhead 101 41810 01 204.02 Plain Envelopes 101 41810 01 204.03 A/P & Payroll Envelopes 101 41810 01 204.04 10 x 13 Envelopes 101 41810 01 204.05 10 x 15 Envelopes 101 41810 01 209.00 Other Office Supplies 101 41810 01 221.00 Equipment Parts 101 41810 01 242.00 Minor Equipment 101 41810 01 242.01 "Future Use" 101 41810 01 242.02 Credit Card Equipment 101 41810 01 301.00 Auditing & Accounting Services 101 4181001 301.01 Audit & General Consulting Fees 101 4181001 301.02 Dakota County Assessment Fees 101 4181001 301.03 Dak Cty Truth In Taxation Costs 101 41810 01 301.04 Printing of Budget Books 101 41810 01 303.00 Engineering Fees 101 4181001 304.00 Legal Fees 101 41810 01 319.00 Other Professional Services 101 41810 01 319.01 City Code Update 101 41810 01 319.02 City Code Web Fees 101 4181001 319.03 State Building Report (Springsteds) 101 4181001 319.04 Continuing Disclosure Fees 101 41810 01 319.05 Annual User Fee Study Update 101 4181001 319.06 Arbitrage /Rebate Calculations 101 4181001 319.10 UMore Professional Services 101 4181001 320.00 Credit Card Activity Fees 101 4181001 320.01 Utilities' Fees 101 4181001 320.02 Parks & Recreation Fees 101 4181001 320.03 Building Fees 101 41810 01 320.04 General Fees 101 41810 01 321.00 Telephone Costs 101 41810 01 321.01 General Phone Costs (& Internet) 101 41810 01 321.02 Domain Housing 101 41810 01 321.03 Software Maintenance Costs 101 41810 01 322.00 Postage Costs 101 41810 01 339.00 Other Transportation Expenses 101 41810 01 351.00 Legal Notices Publishing 101 41810 01 351.01 Costs for Public Notices 101 4181001 351.02 Truth in Taxation Notices 101 4181001 351.03 Budget & Audit Publications 101 4181001 391.00 P.C. Maintenance 101 41810 01 392.00 P.C. Software Purchases 101 41810 01 393.00 P.C. Hardware Purchases 101 41810 01 433.00 Dues & Subscriptions 101 41810 01 439.00 Other Miscellaneous Charges 101 41810 01 450.00 Sales Tax on Purchases 101 41810 01 580.00 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 16 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $14,000 7,535 8,973 40 0 0 Moved to "391.00" Below 9,741 10,632 13,747 12,000 14,000 13,000 7,321 5,678 4,328 8,000 8,000 743 0 0 800 800 1,602 0 0 1,700 1,700 2,100 339 394 1,500 1,500 362 986 '180 1,000 1,000 Business Cards, etc. 5,500 2,054 528 784 2,000 2,000 1,327 1,850 1,587 1,800 1,800 0 0 454 500 500 1,155 0 0 1,200 1,200 0 0 0 0 0 17,228 18,015 14,605 19,000 1 General Office Supplies 0 55 0 0 0 City Hall Equipment Repairs 300 0 0 0 0 0' 0 0 0 300 300 75,000 72,635 62,929 56,045 68,000 68,000 3,373 4,085 4,389 4,500 5,000 1,832 1,841 1,913 2,000 2,000 0 0 0 0 0 2,978 1,251 8,163 0 0 63,370 78,235 55,007 80,000 80,000 General City Legal Fees 31,800 1,853 2,375 1,495 2,500 2,500 250 0 0 300 300 3,870 6,120 4,995 7,000 6,000 Fees Paid to Springsted 2,000 3,607 3,621 4,000 4,000 Fees Paid to Springsted (Bonds) 4,675 14,128 5,370 9,000 7,000 Fees Paid to Springsted 3,750 1,305 10,855 7,000 7,000 Fees Paid to Springsted (Bonds) 3,005 11,465 30,816 5,000 5,000 22,000 1,127 1,299 1,474 1,500 1,500 4,236 4,760 5,437 4,800 4,800 3,347 14,212 12,095 15,000 15,000 593 693 814 700 700 44,600 73,941 63,179 42,188 45;000 39,000 60 0 60 100 100 0 0 0 0 6,500 20,029 17,756 16,705 22,000 23,000 Absentee Voting 813 74 802 800 800 Vehicle Licensing 3,800 2,643 2,202 2,475 3,000 3,000 All Departments 586 0 0 600 600 Newspaper Notice Publication 689 549 123 800 200 State Mandated Publications 0 0 9,476 12,000 12,000 Laserfishe Maintenance 0 0 11,414 6,000 0 Laserfishe Software (CIP) 0 0 -2,200 3,200 3,200 Scanner Purchase. 841 773 867 1,000 1,000 Newspapers 260 269 250 500 500 Direct Deposit Filing Fees /Flex 0 0 9,829 0 0 Sales Tax Audit 24,974 31,889 33,414 29,000 29,000 Office Machine Leases -All Bldgs. $348,898 $372,052 - -- $368,411 - $385,100 - $378,500 $348,898 $372,052 $368,411 $385,100 $378,500 16 Page One 2012 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT June 3, 2011 2011` 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41910 101.00 Salaries & Benefits $832,464 $878,708 $870,501 $896,600 $877,400 Salary, Taxes, PERA & Benefits 101 41910 102.00 Full -Time Overtime 0 0 1,695 1,000 1,000 �. 101 41910 99 103.00 Part-Time Salaries & Benefits 3,367 2,024 1,485 3,500 4,500 Planning Commission Members 101 41910 01 201.00 Office Accessories 0 521 0 0 0 Calendars, Planners, etc. 101 41910 01 202.00 Duplicating & Copying 7,557 7,306 1,990 3,000 2,500 101 41910 01 203.00 Printed Forms & Paper, 4,100 529 2,640 4,000 3,500 Forms, Stickers, Tags, etc. 101 41910 01 205.00 Drafting Supplies 0 0 0 0 0 101 41910 01 208.00 Miscellaneous Supplies 53 998 89 0 0 101 41910 01 209.00 Other Office Supplies 77 180 438 600 600 Dictation Devices & Tapes 101 4191001 219.00 Other Operating Supplies 638 2,176 1,397 2,000 1,500 Chairs 101 41910 01 241.00 Small Tools 0 344 191 200 200 Inspectors' Tools 101 4191001 302.00 Architects' Fees 0 0 0 0 0 101 4191001 319.00 Other Professional Services 0 299 5 1,000 1,000 Consultant 101 4191001 329.00 Other Communication Costs 2,443 2,327 2,078 2,500 2,500 Cell Phones & Pagers 101 4191001 331.00 Travel Expense 472 6 273 600 600 101 41910 01 391.00 P.C. Maintenance 2,318 2,016 2,124 2,700 4,200 Permitworks Support 101 4191001 392.00 P.C. Accessories & Supplies 0 0 0 300 300 101 4191001 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,131 1,209 1,360 1,300 1,500 101 41910 01 433.02 ICC 0 260 200 200 200 101 41910 01 433.03 AMBO 260 275 50 300 300 101 41910 01 433.04 10,000 Lakes 115 325 0 150 150 101 4191001 433.05 "Future Use" 0 0 0 0 0 101 41910 01 433.06 Trade Magazines 0 0 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 150 0 0 300 300 101 41910 01 433.09 AACEO /MAHCO 0 25 35 100 100 101 41910 01 433.10 Other Dues & Subscriptions 562 3,398 588 550 550 101 41910 01 435.00 Books & Pamphlets 557 631 452 700 700 Manuals, References, IBC Books 101 41910 01 437.00 Conferences & Seminars 7,300 101 41910 01 437.01 State Bldg Official School 495 550 421 550 550 101 41910 01 437.02 Spring & Fall Code Updates 370 150 255 400 400 101 41910 01 437.03 Building Inspector Training 952 619 1,040 1,000 1,000 101 41910 01 437.04 Computer Training 32 0 0 300 200 101 41910 01 437.05 Clerical Seminars 743 0 0 400 300 . 101 41910 01 437.06 Planning Seminars 5,094 110 268 1,800 2,000 101 41910 01 437.07 ISTS Training 0 500' 426 500 500 101 41910 01 437.08 State Planning Conference (2) 104 1,665 0 1,000 1,400 101 41910 01 437.09 Planning Commissioner Training 305 32 48 250 200- 101 41910 01 437.10 Gen'I Seminars 1 0 1,667 40 400 300 101 41910 01 437.11 Code Enforcement Training 239 290 146 700 450 101 41910 01 439.00 Other Miscellaneous Charges 90 120 100 400 400 Contingencies PAGE TOTALS $864,689 $909,262 -- --- $890,419 ------ $929,500 --- -- ------- --- $911,500 DEPARTMENT TOTALS $864,689 $909,262 $890,419 $929,500 $911,500 Page One 2012 BUDGET WORKSHEETS POLICE June 3, 2011 Account # Description 101 42110 101.00 Salaries & Benefits 101 42110 102.00 Full -Time Overtime 101 42110 102.01 Regular Overtime Hours 101 42110 102.02 Contracted O/T 101 42110 103.00 Part-Time Salaries & Benefits 101 42110 2 2 103.00 Part-Time Receptionist (2) 101 42110 23 103.00 Part-Time Secretary 10142110 9S 103.00 Part-Time CSO's 101 42110 01 202.00 Duplicating & Copying 101 42110 01 203.00 Printed Forms & Paper 101 42110 01 204.00 Envelopes & Letterheads 101 42110 01 207.00 Training & Instructional Supplies 10142110 01207.01 Practice Ammunition 101 42110 01 207.02 Service Ammunition 101 42110 01 207.03 Other Supplies 101 42110 01 207.04 M.A.A.G. Ammunition 101 42110 01 208.00 Miscellaneous Supplies 101 42110 01 208.01 DARE Donations 101 42110 01 208.02 Equipment Donations /Forfeitures 101 42110 01 209.00 Other Office Supplies 101 42110 01 211.00 Cleaning Supplies 101 42110 01211.01 Blanket Cleaning 101 42110 01 211.02 Squad Interior Cleaning 101 42110 01 217.00 Clothing Allowance 101 42110 01 217.01 CSO's 101 42110 01 217.02 Reserves 101 42110 01 217.03 Other Supplies 101 42110 01 219.00 Other Operating Supplies 101 42110 01 219.01 Evidence Bags, Drug Kits, Misc. 101 42110 01 219.02 Accurint Database Services 101 42110 01 221.00 Equipment Parts 101 42110 01 241.00 Small Tools 101 42110 01 241.01 Evidence Processing Equipment 101 42110 01241 .02 Camera and Video Supplies 101 42110 01 241.03 Other Supplies 101 42110 01 242.00 Minor Equipment 101 42110 01 242.01 Less Lethal Tactical Equipment 101 42110 01 242.02 MAAG Equipment 101 4211001304.00 Legal Fees `101 42110 01 305.00 Medical & Dental Fees 101 42110 01 305.01 Employee Drug Testing 101 42110 01 305.02 Seized Narcotic Testing 101 42110 01 306.00 Personnel Testing & Recruitment 101 42110 01 313.00 Temporary Service Fees 101 42110 01 315.00 Special Programs 101 42110 01 316.00 Animal Care Services 101 42110 01 316.01 Impound & Care Fees 101 42110 01 316.02 " "Future Use" 101 42110 01 319.00 Other Professional Services 101 42110 01 319.01 Dispatch Services - Operations 101 42110 01 319.02 Policy Development & Training 101 42110 01 321.00 Telephone Costs 101 42110 01 321.01 Cell Phones 101 42110 01 321.03 "Future Use" 101 42110 01 323.00 Radio Units 101 42110 01 323.01 Radios ($380 per Unit) 101 42110 01 323.02 Radars 101 42110 01 331.00 Travel Expense 101 42110 01 331.01 MN Chiefs Spring Conference 101 42110 01 331.02 IACP Conference 101 42110 01 331.03 Outstate Investigations & Conf. 101 42110 01 331.04 MAAG Conference 101 42110 01 331.05 CAN -AM Narcotic Conference 101 42110 01 331.06 Juvenile Officers Conference 101 42110 01 331.07 Meeting Reimbursements PAGE TOTALS 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $2,144,449 $2,263,404 $2,342,838 $2,409,400 $2,418,300 Salary, Taxes, PERA & Benefits 112,323 79,326 66,069 70,000 70,000 51,000 19,000 109,800 0 41,681 37,691 51,400 51,800 2 P/T Receptionists - 44 Hrs/Wk 9,618 11,989 16,025 20,400 19,000 PIT Secretary - 16 Hours/Wk 27,204 28,447 35,777 40,400 39,000 CSO's - Up To 50 Hours/Wk 25 0 0 0 0 747 762 846 800 1,200 Evid. Logs, Animal Lic, E- Tickets 0 103 0 200 200 Business Cards 11,100 5,345 4,654 4,739 5,000 5,000 79 7,046 0 1,000 1,000 229 0 0 100 100 0 0 4,322 5,000 5,000 0 Donated & Forfeited Funds 2,657 2,078 2,409 0 0 7,842 10,224 7,279 0 0 591 826 1,019 1,000 1,000 Video, CD's & Miscellaneous 500 0 0 0 0 0 0 124 621 500 500 2,500 967 790 269 1,000 750 1,965 0 1,299 1,000 1,000 0 1,304 289 1,000 750 13 3,000 843 1,361 2,190 2,000 2,000 380 626 859 800 1,000 1,775 2,048 2,457 2,500 3,000 Squad Emergency Equip Repairs 3,500 Crime Scene Kit Supplies 800 558 682 750 750 206 1,163 430 500 2,000 Squad Camera Maintenance 970_ 1,000 395 750 750 Digital Recorders 1,500 943 658 1,177 1,000 1,000 Training Supplies, Taser Batteries 499 500 667 500 500 54,996 56,499 56,652 57,900 60,000 Prosecution 1,500 809 478 380 1,000 500 663 1,429 761 1,000 1,000 Blood Draws 875 868 0 1,000 1,000 Medical & Psychological 464 106 764 1,200 800 Interpreter Services 0 0 0 0 0 3,000 10,943 11,240 12,226 6,000. 3,000 0 0 0 0 0 296,400 232,800 338,412 297,671 307,100 292,700 24,586 0 0 10,000 3,700 5,400 4,371 5,225 5,953 4,800 5,400 74 0 0 0 0 12,000 6,944 9,213 9,648 11,500 11,500 800 MHz Subscriber Fees 430 520 831 500 500 Radar & LIDAR Repairs 2,500 0 387 297 500 500 1,865 0 0 0 0 693 430 117 500 500 624 733 201 600 600 0 245 285 300 300 325 785 210 500 500 190 48 130 100 100 2,662,125 2,887,269 2,916,475 3,021,500 3,008,200 [fi Page Two 2012 BUDGET WORKSHEETS POLICE June 3, 2011 Account # Description 101 42110 01 333.00 Freight & Express Expenses 101 42110 01 394.00 P.C. Software Purchases 101 42110 01 394.01 Automated Pawn System 101 42110 01 394.02 Pictometry 101 42110 01 394.03 CJIIN System 101 42110 01 396.00 Computer Maintenance 101 42110 01 396.01 Records Management 101 42110 0139&02 CJDN Connection Charges 101 42110 01 396.03 MCD Connection Charges 101 42110 01 396.04 MCD Maintenance & Cellular 101 42110 01 396.05 LOGIS Annual Fees 101 42110 01 433.00 Dues & Subscriptions 101 42110 01 433.01 Mufti- Agency Assistance Group -MAAG 101 42110 01 433.02 ACID Chiefs 101 42110 01 433.03 MN Chiefs of Police 101 42110 01 433.04 Dakota Cty Chiefs of Police 101 42110 01 433.05 Wakota CAER 101 42110 01 433.06 Metro Emergency Managers 101 42110 01 433.07 MN Sex Crimes Investigators 101 42110 01 433.08 Tri- County Investigators 101 42110 01 433.09 MN Crime Prevention Association 101 42110 01 433.10 P.O.S.T. Licenses 101 42110 01 433.11 FBI Nat'l Academy Association 101 42110 01 433.12 Miscellaneous 101 42110 01 435.00 Books & Pamphlets 101 42110 01 436.00 Towing Charges 101 42110 01 437.00 Conferences & Seminars 101 42110 01 437.01 Firearms - Range 101 42110 01 437.02 Chiefs Spring Conference 101 42110 01 437.03 Investigations 101 42110 01 437.04 IACP Conference 101 42110 01 437.05 Supervision 101 42110 01 437.06 Use of Force 101 42110 01 437.07 Emergency Driving 101 42110 01437.08 First Aid 101 42110 01 437.09 Narcotic Enforcement 101 42110 01 437.10 Tactical 101 42110 01 437.11 Support Services 101 42110 01 437.12 Patrol Ops. 101 42110 01 437.13 Emergency Management 10142110 01439.00, Other Miscellaneous Charges 101 42110 01 580.00 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 2008 Actual 2009 Actual 2010 Actual 2011 Adopted Budget 2012 Object Detail Amount 2012 Proposed Budget Comments 141 38 110 200 200 Repairs 12,300 240 240 240 300 300 1,388 1,388 1,193 1,400 0 In Public Works Budget 10,474 10,474 10,474 13,500 12,000 65,600 34,377 35,188 32,172 33,000 33,000 2,981 3,443 3,904 2,800 2,800 1,845 1,620 1,744 2,000 2,000 15,115 18,647 17,316 20,000 20,000 7,275 2,779 7,763 7,800 7,800 6,600 3,000 3,200 3,200 3,200 5,000 e. 120 120 120 125 125 165 215 265 225 265., 35 0 35 50 50 0 0 0 20 0 0 0, 0 0 0 0 0 0 20 20 0 , 50 50 60 50 90 0 60 65 65 360 1,080 720 400 900 0 0 0 0 0 165 75 155 135 125 943 238 281 1,000 1,000 Crime Prevention Materials 0 0 0 200 200 Disabled Squads 10,000 5,931 2,085 988 2,000 2,000 Range Rental 0 420 325 500 500 1,920 1,710 731 1,700 1,700 275 0 0 0 0 755 480 675 500 500 100 1,750 750 900 900 1,120 2,740 420 1,000 1,000 0 950 0 1,000 300 0 1 100 100 200 200 0 1,320 280 1,000 1,000 245 15 1,017 200 200 618 105 3,325 800 1,500 0 0 0 200 200 282 476 1,188 500 500 Refreshments for Meetings & Compliance Checks 0 0 0 0 0 $89,961 $90,947 $89,600 $97,000 $96,400 $2,752,086 $2,978,235 $3,006,075 $3,118,500 $3,104,600 fk Page One 2012 BUDGET WORKSHEETS FIRE June 3, 2011 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 42210 103.00 Salaries & Benefits $75,329 $54,810 $54,192 $55,000 $122,000 Salary, Taxes, PERA & Benefits 10142210 10101 Salaries 52,000 101 42210 103.02 Training Pay /Stipends 10,000 101 42210 103.03 Call Pay /Stipends 59,900 101 42210 103.04 Class Pay /Stipends 100 101 42210 01202. 00 Duplicating & Copying 100 101 42210 01 202.01 Copy Toner 0 43 414 50 50 101 42210 01 202.02 Computer Printers 0 69 0 50 50 101 42210 01 204.00 Envelopes & Letterhead 100 101 42210 01 204.01 Envelopes 0 0 0 25 25 101 42210 01 204.02 Letterhead 0 0 0 25 25 .101 42210 01 204.03 Forms 0 422 0 50 50 101 42210 01 208.00 Miscellaneous Supplies 0 Supplies for Fire Marshal 101 42210 01 208.01 Supplies, Computer Support 1,040 0 0 0 0 101 4221001 208.02 Film Developing 101 0 0 0 0 101 42210 01 208.03 Memberships 0 0 0 0 0 101 42210 01 208.04 Code Books 140 0 0 0 0 101 42210 01 208.05 Training 700 0 0 0 0 101 42210 01 211.00 Cleaning Supplies 800 101 42210 01 211.01 Soaps 140 937 293 550 550 101 42210 01 211.02 Chamois, Towels, etc. 0 0 0 50 50 101 42210 01 211.03 Sponges, etc. 0 18 18 50 50 101 42210 01 211.04 SCBA Cleaner 0 59 118 150 150 101 42210 01 218.00 Fire Department Clothing 0 3,495 453 400 400 4 Uniforms @ $100 Each 101 42210 01 219.00 Other Operating Supplies 4,800 Medical Supplies 101 42210 01 219.01 Gloves 314 633 500 1,000 1,000 101 42210 01 219.02 Bandages 0 0 0 100 100' 101 42210 01 219.03 Equipment 937 637 0 1,000 1,000 101 42210 01 219.04 Tyvek Suits 0 0 0 100 100 101 42210 01 219.05 Consummable Medical 891 437 2,953 2,200 2,200 101 42210 01219.06 Oxygen 146 74 160 400 400 101 42210 01 229.00 Other Maintenance Supplies 700 101 42210 01 229.01 Vehicle Repairs 45 0 0 200 400 101 42210 01 229.02 Pickup Trucks 0 45 70 100 0 101 42210 01 229.03 Rescue & Other 650 67 11 300 0 101 42210 01 229.04 Vehicle Modifications 72 380 2,223 100 300 101 42210 01 230.00 Equipment Repair Materials 2,100 101 42210 01 230.01 Light Bars 0 0 0 100 100 101 42210 01 230.02 Smoke Machines 0 0 0 250 250 101 42210 01 230.03 Lanterns & Miscellaneous 61 356 274 250 250 101 42210 01 230.04 Small Tool Repairs 543 3,658 712 600 600 101 42210 01 230.05 Opticom 0 0 0 300 300 101 42210 01 230.06 Station 1,624 477 628 600 600 101 42210 01 241.00 Small Tools 700 101 42210 01 241.01 Axes, Bars & Other 110 162 675 150 150 101 42210 01 241.02 Grass Fire 0 85 29 250 250 101 42210 01 241.03 Hand Tools 378 430 971 300 300 101 42210 01 305.00 Medical & Dental Fees 2,850 611 3,604 3,500 3,800 Annual Medical Tests 101 42210 01 306.00 Personnel Testing & Recruitment 2,300 101 42210 01 306.01 New Physicals (5) 2,925 2,181 408 1,325 1,325 101 42210 01 306.02 Hepatitis Shots (5) 151 102 106 625 625 10142210 01 306.03 Background Checks (5) 121 146 121 125 125 101 42210 01 306.04 Drug Testing (5) 0 0 0 225 225 101 4221001 308.00 Instructors' Fees 9,000 101 4221001 308.01 Fire Fighter 1 (4) 1,198 480 2,500 2,000 1,600 101 4221001 308.02 Fire Fighter 1 Certificates (4 +4) 120 241 590 200 450 101 42210 01 308.03 Fire Fighter Re- Certificates (10) 195 100 200 340 200 101 42210 01 308.04 First Responder (4) 0 762 1,455 1,200 1,000 101 42210 01 308.05 First Responder Refresher (1/2) 1,200 1,200 1,200 1,400 1,400 101 42210 01 308.06 Outside Schools ($/2) 5,651 3,558 5,547 3,550 3,350 101 4221001 308.07 Haz -Mat Training (4) 0 0 1,000 1,250 1,000 101 4221001 308.08 Apparatus Re- Certificates 45 0 0 60 0 PAGE TOTALS 97,679 76,673 81,429 80,500 146,800 a- Page Two 2012 BUDGET WORKSHEETS FIRE June 3, -2011 - Y 2011 2012 Object 2012 2008 2009 2010 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 0 750 1,336 1,000 1,000 101 42210 01 310.02 Ladders 0 474 0 500 500 101 4221001 310.03 Pumpers (3) (Next 2014) 855 0 0 0 1,200 101 4221001 310.04 SCBA Hydro Testing (Next 2016) 0 0 0 0 0 101 4221001 313.00 Temporary Service Fees 8,600 101 42210 01 313.01 SCBA Maintenance 557 2,315 1 2,300 2,300 101 42210 01 313.02 SCBA Flow Test 269 2,047 1,551 2,000 2,000 101 4221001 313.04 Security Contract 617 631 559 800 800 101 42210 01 313.05 SOT Joint Powers 2,724 2,637 2,605 2,700 3,500 101 42210 01 314.00 Annual Fire Relief Contribution 152,000 156,500 161,200 166,000 171,000 101 4221001 319.00 Other Professional Services 1,300 Fire Prevention Education 101 4221001 319.01 School Literature 0 0 59 200 200 101 42210 01 319.02 Door Prizes 212 0 0 200 200 101 42210 01 319.03 Fire Prevention Week Promos 538 1,028 833 500 500 101 42210 01 319.04 Food at Open House 402 300 353 200 200 101 4221001 319.05 Summer Park Education 66 98 313 100 100 101 42210 01 319.06 National Night Out 0 0 95 100 100 101 42210 01 321.00 Telephone Costs 900 101 4221001 321.01 Fire Dept. Cell Phones 1,103 822 542 1,300 900 101 42210 01 321.02 Fire Marshal Cell Phone 250 1,024 318 0 0 101 42210 01 321.03 "Future Use" 334 306 0 0 0 101 4221001 321.04 Numeric Pagers 92 93 0 0 0 101 4221001 322.00 Postage Costs 0 13 0 100 100 UPS Costs 101 42210 01 329.00 Other Communication Costs 17,000 101 4221001 329.01 Base Repairs 0 0 0 100 300 101 42210 01 329.02 Pager Repairs 937 930 546 1,500 1,000 101 4221001 329.03 Hand Held Repairs 0 51 0 100 300 101 42210 01 329.04 Mobile Repairs 0 0 0 100 200 101 42210 O1 329.05 800 MHZ User Fee 7,604 10,400 10,356 14,000 14,000 101 42210 01 329.06 Mobile Computers 0 0 0 0 1,200 Monthly Air Time Fees 101 4221001 331.00 Travel Expense 3,900 101 42210 01 331.01 Minnesota Chiefs Conference 1,484 1,584 1,621 2,000 2,000 101 42210 01 331.02 Fire Department Association 2,159 294 1,852 1,600 1,600 101 4221001 331.03 Outside Schools 0 0 710 300 300 101 4221001 333.00 Freight & Express Expense 10 0 0 0 0 101 42210 01 433.00 Dues & Subscriptions 1,300 101 4221001 433.01 Capital City 50 50 50 50 50 101 42210 01 433.02 VFBA Insurance 354 0 328 550 550 101 42210 01 433.03 State Fire 360 360 `360 300 340 101 42210 01 433.04 State Chiefs 290 145 530 250 250 101 42210 01 433.05 DCFC 75 75 75 60 60 10142210 01 433.06 WAKOTA Mutual Aid 50 100 50 50 50 101 42210 01 433.07 Purchasing Consortium 35 0 0 40 0 101 42210 01 433.08 NFPA 150 0 0 0 0 101 42210 01 433.09 "Future Use" 0 0 0 0 0 101 42210 01 437.00 Conferences & Seminars 900 101 42210 01 437.01 State Fire Conference 0 594 0 400 400 101 42210 01 437.02 State Chiefs Conference 0 320 565 500 500 101 42210 01 439.00 Other Miscellaneous Charges 1,600 101 42210 01 439.01 Food & Coffee 59 18 81 150 150 101 42210 01 439.02 Extinguisher 0 196 0 300 300 101 42210 01 439.03 Plaques 60 102 13 40 40 101 42210 01 439.04 Paint 0 0 0 70 70 101 42210 01 439.05 Station Needs 1,017 649 1,346 1,040 1,040 101 4221001 580.00 Other Equipment Purchases 21,600 101 42210 01 580.01 Bunker Gear (8) 16,282 15,901 20,614 15,000 18,600 101 4221001 580.02 Pagers 0 4,231 7,015 3,600 0 Replacements 101 4221001 580.03 Hose & Fittings 0 2,099 0 1,000 1,000 101 42210 01 580.04 Replace Damaged Items 2,336 3,542 1,960 2,000 2,000 101 4221001 581.00 Other Equipment Purchases 0 0 0 0 0 101 4221001 586.00 Other Equipment Purchase 7,069 4,228 0 0 0 PAGE TOTALS --------------- $200,398 --- - ----- ---- $214,907 - ----- --- - -- $218,950 - - - - - -- $223,100 ---- ------ ---- - - -- - -- $230,900 DEPARTMENT TOTALS $298,077 $291,580 $300,379 $303,600 $377,700 B Page One 2012 BUDGET WORKSHEETS GOVERNMENT BUILDINGS June 3, 2011 k 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41940 101.00 Salaries & Benefits $0 Salary, Taxes, PERA & Benefits 101 41940 79 101.01 Maintenance Staff 10,521 0 0 0 0 Increase to "319.09" Below 101 41940 102.00 Full -Time Overtime 0 0 0 0 0 101 41940 01 208.00 Miscellaneoui Supplies 16,717 16,399 15,626 19,000 19,000 Cleaning Supplies, Towels 101 41940 01 219.00 Other Operating Supplies 0 0 0 0 2,000 Flags 101 41940 01 223.00 Building Repair Supplies 9,231 8 9,030 9,200 9,200 101 41940 01 225.00 Landscaping Materials 466 116 947 1,500 1,500 Trees & Shrubs (Fire Stations) 101 4194001 241.00 Small Tools 9 179 246 200 200 Hand Tools, Bits, Blades, etc. 101 41940 01 242.00 Minor Equipment 2,066 1,468 811 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,500 1,500 1,500 Contracted Engineer for City (5 %) 101 41940 01 319.00 Other Professional Services 79,000 101 41940 01 319.01 Elevator Maintenance 1,498 1,695 2,051 1,500 1,500 101 41940 01 319.02 Heating /Cooling Maint Contract 7,048 8,310 7,646 7,000 8,000 Includes all City Facilities 101 41940 01 319.03 Annual Boiler Inspections / Maint. 476 1,128 120 1,500 1,500 101 41940 01 319.04 Pest Control 2,146 2,180 2,210 2,500 2,500 101 41940 01 319.05 Fire Extinguishers 2,308 738 1,769 2,500 2,500 101 41940 01 319.06 Fire Suppression System Check 3,044 3,484 3,131 3,500 3,500 101 4194001 319.07 Janitorial Service -Fire Stations 10,452 10,908 10,016 10,500 11,000 101 4194001 319.08 Janitorial Service -P.W. Building 10,555 11,104 10,529 11,500 12,000 1014,1940 01,319.09 Janitorial Service -City Hall 25,826 26,183 24,534 25,000 25,500 101 41940 01 319.10 Floor Mats - Monthly Charges 0 3,817 3,257 4,000 4,000 101 41940 01 319.11 Other Janitorial Services 0 0 4,701 7,000 7,000 Waxing Floors, Carpet Cleaning 101 41940 01 381.00 Electric Utilities 64,821 62,637 63,008 70,000 70,000 101 41940 01 382.00 Water Utilities 0 0 0 0 0 101 41940 01 383.00 Gas Utilities 80,087 61,001 46,942 80,000 62,000 101 41940 01 384.00 Refuse Disposal 30,000 101 41940 01384:01 General Buildings & Parks 14,169 15,175 15,713 16,000 16,000 101 41940 01 384.02 Recycling /Cleanup 12,858 12,201 11,090 14,000 14,000 2 Cleanup Days per Year 101 41940 01 389.00 Other Utility Services 3,528 0 0 0 0 Moved to "319.10" Above 101 41940 01 401.00 Contracted Building Repairs 40,000 101 41940 01 401.01 Electrical Repairs 6,112 4,202 1,839 5,000 5,000 101 41940 01 401.02 Siren Replacement Program 10,000 10,000 8,157 10,000 10,000 101 41940 01 401.03 Miscellaneous Repairs 22,493 25,353 24,462 25,000 25,000 101 41940 01 401.04 Roof Inspection 0 123 0 0 0 101 41940 01 415.00 Other Equipment Rental 0 103 0 1,000 1,000 Scaffolding, Cleaners - 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 142,196 84,606 69,836 70,000 76,000 Next 5 -year Average Expenditure 101 41940 01 601.00 Bond Principal 46,000 48,421 41,886 60,600 60,600 MSABC Payment (211) 10141940 01 611.00 Bond Interest 33,186 29,034 33,717 25,400 25,400 MSABC Payments (2/1 & 8/1) 101 41940 01 621.00 Bond Paying Agent Fees 0 0 1,549 0 0 PAGE TOTALS, - --- - -- $539,315 -- -- - - - - - -- $450,974 ----------- -- $416,324 -- $491,900 - -_- - $484,400 DEPARTMENT TOTALS $539,315 $450,974 $416,324 $491,900 $484,400 F1 711 Page One 2012 BUDGET WORKSHEETS FLEET MAINTENANCE June 3, 2011 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43100 101.00 Salaries & Benefits $168,800 Salary, Taxes, PERA & Benefits ,101 43100 77 101 .00 Administrative 10,954 11,274 11,555 12,000 12,300 101 43100 79 101.00 Maintenance 138,537 143,260 147,683 152,900 156,500 101 43100 102.00 Full -Time Overtime 1,786 1,971 2,561 3,000 3,000 101 43100 0121 1.00' Cleaning Supplies 1,022 987 1,111 1,000 1,000 Shop & Vehicles 101 43100 01 212.00 Motor Fuels 173,858 126,007 187,081 175,000 220,000 Price Estimate (See Below) 101 43100 01 213.00 Lubricants & Additives 8,712 7,891 10,699 10,000 12,000 Price Increase 101 43100 01 215.00 Shop Materials 18,535 12,732 16,433 17,000 17,000 101 43100 01 221.00 Equipment Parts 115,712 102,642 153,416 120,000 140,000 10143100 01 222.00 Tires 15,718 11,854 35,695 20,000 20,000 101 43100 01 241.00 Small Tools 4,444 3,504 2,396 4,000 4,000 101 43100 01 242.00 Minor Equipment 6,246 4,339 3,198 4,000 4,000 101 4310001 318.00 Contract Engineer 3,000 3,000 3,000 3,000 3,000 Contracted Engineer for City(10 %) 101 43100 01 321.00 Telephone Costs 0 0 0 0 0 101 43100 01 323.00 Radio Units 284 1,104 150 3,000 1,000 Warranty 101 43100 01 384.00 Refuse Disposal 158 10' 25 300 300 Shop Hazardous Waste 101 4310001 394.00 P.C. Software Purchases 0 284 529 1,600 3,100 101 43100 01 394.01 Licensing & Maintenance 1,600 CarteGraph 101 43100 01 394.02 Online Subscriptions 1,500 ALLDATA 101 43100 01 394.03 New Software Purchases 0 101 43100 01 404.00 Contracted Mach& Equip Repairs 25,340 44,680 39,152 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 226 295 263 0 0 More Accurate Allocations (433.00) 101 43100 01 433.00 Dues & Subscriptions 75 1,575 90 1,600 100 DOT Cert($1500 moved to 394.02) , 101 43100 01 435.00 Books & Pamphlets 51 129 56 100 100 DOT Decals and Inspection Pads 101 43100 01 437.00 Conferences & Seminars 0 348 0 300 300 $100 - CarteGraph; $200 -Misc. PAGE TOTALS - --- -------- - $524,657 - ------ ------ $477,886 - --- - -- - -- $615,092 -------- --- - -- $569,800 --- --- -- - -- ---- --- - -- - -- $638,700 DEPARTMENT TOTALS $524,657 $477,886 $615,092 $569,800 $638,700 Page One 2012 BUDGET WORKSHEETS STREET MAINTENANCE June 3, 2011 2011 2012 Objecl 2012 ` 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43121 101.00 Salaries & Benefits $528,000 Salary, Taxes, PERA & Benefits 101 43121 77 101.00 Administrative 32,861 33,821 34,665 36,000 36,700 101 43121 78 101.00 Technical /Clerical 60,134 62,847 63,978 67,100 48,500 101 43121 7S 101.00 Maintenance 376,362 389,176 372,144 428,200 442,800 101 43121 102.00 Full -Time Overtime 11,817 13,177 13,457 14,000 14,000 Maintenance 101 43121 9S 103.00 Part-Time Salaries & Benefits 25,630 33,759 28,696 31,500 33,500 Includes Funds for Horticulturist 101 43121 01 201.00 Office Accessories 0 0 0 100 100 101 43121 01 203.00 Printed Forms & Paper 200 101 43121 01 203.01 R/W Permit & Inspection Forms 0 0 0 200 200 101 43121 01 203.02 Work Orders 0 0 0 0 0 Work Orders Through CarteGraph 101 43121 01 203.03 City Specification Books 0 1,956 0 0 0 101 43121 01205.00 Drafting Supplies 1,400 101 43121 01 205.01 Paper for Plan Reproductions 856 936 136 1,000 1,000 Plotter (Ink and Paper) 101 43121 01 205.02 Off -Site Reproductions 88 246 53 400 400 101 43121 01 205.03 Film & Developing 0 0 0 0 0 101 43121 01 205.04 Miscellaneous Tools 0 0 0 0 0 101 43121 01 209.00 Other Office Supplies 492 154 1,231 500 500 101 43121 01 216.00 Chemical & Chemical Products 79,449 48,212 72,845 75,000 80,000 101 43121 01 224.00 Street Maintenance Materials 3,500 101 43121 01 224.01 Paint 105 208 481 500 500 101 43121 01 224.02 Mail Boxes 465 611 493 500 1,500 101 43121 01 224.03 Light Bulbs /Lenses 613 396 304 1,500 1,500 Replace with LED Bulbs 101 43121 01 225.00 Landscaping Materials 17,500 101 43121 01 225.01 Sod 1,917 0 0 1,500 1,500 101 43121 01 225.02 Seed 298 0 0 200 200 101 43121 01 225.03 Black Dirt 820 250 51 1,000 1,000 101 43121 01 225.04 Trees 490 469 0 500 500 101 43121 01 225.05 Hanging Baskets 0 4,571 4,379 5,000 5,000 101 43121 01 225.06 Entrance Monuments 0 0 0 6,000 6,000 101 43121 01 225.07 Downtown Planters 0 0 0 1,300 1,300 101 43121 01 225.08 Park Signs & RCC 0 0 0 2,000 2,000 101 43121 01 226.00 Sign Repair Materials 14,507 12,483 9,950 15,000 15,000 Move Mandated Share to CIP 101 43121 01 231.00 Bituminous Patching Materials 28,566 32,495 25,664 40,000 32,500 101 43121 01 232.00 Crushed Rock 23,550 29,395 25,155 30,000 32,500 101 43121 01233.00 Dust Control Materials 21,101 35,197 30,154 25,000 25,000 Nothing East of Akron Avenue 101 43121 01 234.00 De -Icing Sand / Rock 0 3,531 1,955 5,000 3,000 Gravel Road Ice Control(Estimate) 101 43121 01 235.00 Shouldering Gravel 1,107 576 0 a 0 0 101 43121 01 241.00 Small Tools 1,248 1,657 863 2,000 2,000 Shovels, Brooms, etc. 101 43121 01 242.00 Minor Equipment . 902 3,506 4,184 4,000 4,000 Safety Equipment / Power Tools 101 43'121 01303.00 Engineering Fees 22,578 45,778 13,237 8,500 10 General Non - Project Related 101 43121 01 304.00 Legal Fees 440 578 877 0 0 101 43121 01 305.00 Medical & Dental Fees 0 0 0 600 600 Employment Physicals 101 43121 01 310.00 Testing Services 0 0 0 0 0 101 43121 01 313.00 Temporary Service Fees 0 0 1,275 0 0 101 43121 01 318.00 Contract Engineer 6,000 6,000 6,000 6,000 6,000 Contracted Engineer for City(20 %) 101 43121 01 319.00 Other Professional Services 0 544 32 500 10,500 101 43121 01 319.01 Random Drug Testing 0 0 0 0 500 101 43121 01 319.02 GIS Consulting Services 0 0 0 0 10,000 101 43121 01 321.00 Telephone Costs 2,484 3,073 2,609 3,000 .; 3,000 Includes Wireless Technology 101 43121 01 323.00 Radio Units 0 0 1,083 1,500 1,500 800 MHZ Monthly Charges 101 43121 01 324.00 Messenger Services 29 0 0 100 100 101 43121 01 331.00 Travel Expense 35 206 417 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 149,837 159,178 158,067 170,000 170,000 101 43121 01 361.02 Signal Lights & Sirens 4,940 4,272 2,989 6,000 5,000 101 43121 01 384.00 Refuse Disposal 2,000 101 43121 01 384.01 Hazardous Waste Disposal 121 0 609 500 500 101 43121 01 384.02 Roadside Garbage 326 392 697 900 900 101 43121 01 384.03 Tree Disposal 0 0 53 600 600 101 43121 01 391.00 P.C. Maintenance 14,800 101 43121 01 391.01 Gopher State One -Call 0 0 0 0 0 101 43121 01 391.02 State Aid 0 0 0 0 0 101 43121 01 391.03 Pavement Management Syst Sup 21,888 0 5,450 10,000 10,000 101 43121 01 391.04 R -O -W Permit On -Line Service 4,360 4,800 4,800 4,800 4,800 101 43121 01 392.00 P.C. Accessories & Supplies 0 0 0 0 0 101 43121 01 393.00 P.C. Hardware Purchases 0 0 0 500 1,800 GIS Server to Host Web Maps 101 43121 01 394.00 P.C. Software Purchases 901 4,574 3,240 5,500 8,900 101 43121 01 394.01 Licensing & Maintenance 4,600 CarteGraph, GIS 101 43121 01 394.02 Online Subscriptions 300 Pictometry 101 43121 01 394.03 New Software Purchases 4,000 Cartegraph Web Portal PAGE TOTALS 897,318 939,026 892,272 1,014,500 1,027,400 Page Two 2012 BUDGET WORKSHEETS STREET MAINTENANCE June 3, 2011 Account # . Description 101 43121 01402.00 Parking Lot Maintenance 101 43121 01403.00 'Contracted Repair & Maintenance 101 43121 01 403.01 Street Lights 101 43121 01403.02 Signal Lights 101 43121 01 403.03 Light Replacements 101 43121 01 404.00 Contracted Mach & Equip Repairs 101 43121 01 405.00 Street Striping 101 43121 01 406.00 Street Sweeping 101 43121 01 408.00 Street Crack Sealing 101 43121 01 409.00 Tree Trimming 101 43121 01410.00 Concrete Sidewalk/Curb Repairs 101 43121 01 410.01 General Repairs 101 43121 01410.02 Pedestrian Improvements 101 43121 01411.00 Contracted Snow Removal 101 43121 01 411.01 Community Center 101 43121 01 411.02 Steeple Center 101 43121 01 411.03 Genz -Ryan 101 43121 01411.04 Dakota County Library 101 43121 01415.00 Equipment Rental 101 43121 01 433.00 Dues & Subscriptions 101 4312101433.01 American Public Works Ass'n 101 43121 01 433.02 "Future Use" 101 43121 01433.03 City Engineers' Association 101 43121 01 433.04 Professional Secretaries 101 43121 01 433.05 MN Society for Professional Eng. 101 43121 01 433.06 American Society of Civil Eng. 101 43121 01 433.07 MN Street Superintendent Ass'n 101 43121 01 433.08 "Future Use" 101 43121 01 435.00 Books & Pamphlets 101 43121 01 435.01 "Future Use' 101 43121 01 435.02 "Future Use" 101 43121 01437.00 Conferences & Seminars 1014312101437.01 APWA 101 43121 01 437.02 Computer Training 101 43121 01 437.03 Clerical 101 43121 01 437.04 Gravel Road Maintenance 101 43121 01 437.05 Maintenance Expo 101 43121 01 437.06 Cartegraph, ESRI, GIS 101 43121 01 437.07 Snow Conference 101 43121 01 437.08 MN Dot 101 43121 01 437.09 Miscellaneous Training 101 43121 01 439.00 Other Miscellaneous Charges 101 43121 01 570.00 Office Equipment & Furnishings PAGE TOTALS DEPARTMENT TOTALS 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Actual Actual Actual Budget Amount, Budget Comments 16,871 10,000 13,577 5,000 25,000 Next 5-year Average Expenditure 29,000 31,440 14,231 1,421 28,500 28,500 Repair 9 Street Lights (Annually) 792 767 0 500 500 0 1,471 0 0 0 0 0 0 15,000 15,000 Quiet Zones - Railroad Maint Costs 25,523 36,202 40,811 40,000 60,000 0 0 0 0 0 42,960 49,153 44,913 60,000 60,000 Increased Street Overlays 8,362 2,109 19,959 7,500 10,000 20,000 9,436 3,508 16,839 8,000 20,000 123,457 124,381 125,000 125,000 0 Moved $125,000 to Street CIP 45,000 9,512 9,869 21,970 12,000 20,000 8,814 4,775 8,329 9,500 10,000 5,778 0 0 0 0 0 9,340 16,310 10,000 15,000 13,251 24,531 27,917 30,000 30,000 Bucket Truck / OSHA 900 633 652 671 600 700 - Annual Membership 0 0 0 0 0 0 20 33 0 0 0 80 0 0 0 0 0 0 0 0 0 0 0 0 0 70 70 120 100 200 0 0 0 0 0 0 0 0 0 0 0 0 140 0 0 0 3,400 215 59 0 .1,000 1,000 Spring / Fall Conferences 99 0 0 0 0 0 80 97 150 150 MuniciPals (Twice Annually) 0 210 0 0 0 24 50 0 300 300 0 250 0 450 450 User Group, Conference, Training 90 0 165 0 0 0 160 0 0 0 Simulator 3,557 436 785 1,500 1,500 DCTC Defensive Driving Training 211 216 496 500 500 Host CONDAC, RL & CD Notary 0 0 0 0 0 $301,095 $292,758 $339,412 $355,600 $298,800 $1,198,413 $1,231,784 $1,231,684 $1,370,100 $1,326,200 Page One June 3, 2011 2012 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE Account # Description 101 45202 101.00 Salaries & Benefits 101 45202 77 101.00 Administrative 101 45202 7S 101.00 Maintenance 101 45202 102.00 Full -Time Overtime 101 45202 9S 103.00 Part-Time Salaries & Benefits 101 45202 01 205.00 Drafting Supplies 101 45202 01 216.00 Chemical & Chemical Products 101 45202 01 216.01 Herbicides(General Park Use) 101 45202 01216.02 Fertilizer 101 45202 01 219.00 Other Operating Supplies 101 45202 01 219.01 Seed, Sod, etc. 101 45202 01 219.02 Red Rock, Sand, Gravel, etc. 101 45202 01 219.03 Repair Supplies 101 45202 01 219.04 Bituminous 101 45202 01 219.05 Wood Chips 101 45202 01 221.00 Equipment Parts 101 45202 01 221.01 Playground Equipment Repair 101 45202 01 221.02 Irrigation Repair(Non- Contract) 101 45202 01 221.03 Miscellaneous 101 45202 01 221.04 Park Sign Replacements 101 45202 01 223.00 Building Repair Supplies 101 45202 01 223.01 Paint, Stain, etc. 101 45202 01 223.02 Shingles, Boards, etc. 101 45202 01 223.03 Miscellaneous 101 45202 01 223.04 Shelter /Shed Repairs 101 45202 01 225.00 Landscaping Materials 101 45202 01 225.01 Trees, Shrubs, Sod, etc. 101 45202 01 225.02 Timbers, Fence, etc. 101 45202 01 226.00 Sign Repair Materials 101 45202 01 229.00 Other Maintenance Supplies 101 45202 01 241.00 Small Tools 101 45202 01 242.00 Minor Equipment 101 45202 01 303.00 Engineering Fees 101 45202 01 305.00 Medical and Dental Fees 10145202 01318.00 Contract Engineer 101 45202 01 319.00 Other Professional Services 101 45202 01 321.00 Telephone Costs 101 45202 01 323.00 Radio Units 101 45202 01 341.00 Employment Advertising 101 45202 01 381.00 Electric Utilities 101 45202 01 381.01 Skating Rinks 101 45202 01 381.02 Softball Fields 101 45202 01 381.03 Irrigation 101 45202 01 383.00 Gas Utilities 101 45202 01 393.00 P.C. Hardware Purchases 101 45202 01 394.00 P.C. Software Purchases 101 45202 01 394.01 Licensing & Maintenance 101 45202 01 394.02 Online Subscriptions 101 45202 01 394.03 New Software Purchases PAGE TOTALS 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inciusive'of s $445,900 Salary, Taxes, PERA & Benefits 10,954 11,274 11,555 12,000 12,300 381,555 396,110 401,187 422,700 433,600 14,556 14,214 15,185 14,000 14,000 35,190 42,088 49,894 49,500 49,500 0 0 0 100 100 17,000 Includes all City Facilities 8,651 2,954 8,520 6,000 6,000 21,579 21,785 21,330 11,000 11,000 15,500 2,952 4,917 3,440 3,000 3,000 1,085 2,409 7,079 2,500 2,500 512 0 0 1,000 1,000 0 0 0 0 0 6,760 8,484 8,972 9,000 9,000 Special Wood Chips - Playgrounds 13,500 4,509 4,886 4,387 4,500 4,500 7,450 7,418 4,341 7,500 7,500 108 3,434 864 2,500 1,500 648 0 127 0 0 10,000 1,696 2,950 315 1,500 1,500 1,915 1,515 592 2,000' 2,000 1,706 755 1,570 1,500 1,500 29,580 3,168 2,301 5,000 5,000 3,500 2,218 740 1,891 2,500 2,500 684 227 1,772 1,000 1,000 0 0 202 500 500 5,288 5,701 13,981 7,000 15,000 Paint, Chalk, Field Dry (& DCTC) 1,539 2,572 3,181 2,500 2,500 Hand Tools, Blades, Bits, etc. 2,627 2,406 1,589 2,500 2,500 Weed Whips, Chain Saws - Powered 0 0 0' 0 0 0 0 0 600 600 Employment Physicals 1,500 1,500 1,500 1,500 1,500 Contracted Engineer for City (5 %) 0 0 0 3,000 3,000 Maintenance of Open Spaces -New 2,905 3,460 3,284 3,100 3,100 Includes Wireless Technology 0 603 1,083 1,300 1,500 800 MHZ Monthly Charges 11 0 0 0 0 21,000 6,697 5,975 6,738 6,000 8,000 Service Connect / Disconnect 7,030 7,542 6,560 8,000 8,000 3,402 3,982 3,637 5,000 5,000 2,509 2,133 1,844 2,800 2,000 0 0 0 500 1,800 GIS Server to Host Web Maps 0 4,609 5,378 5,500 8,900 4,600 Cartegraph, GIS 300 Pictometry 4,000 Cargegraph Web Portal 567,816 569,809 594,300 608,600 632,900 Page Two June 3, 2011 2012 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE Account # Description 101 45202 01 403.00 Contracted Repair & Maintenance 101 45202 01 403.01 Irrigation Repairs 101 45202 01 403.02 Electrical Repairs 101 45202 01 403.03 Miscellaneous Repairs 101 45202 01 409.00 ' Other Contracted Repair & Maint 101 45202 01409.01 Chemlawn Services 101 45202 01 409.02 Library / St. Joe's / RCC 101 45202 01 409.03 Fire Station #1 101 45202 01 409.04 Fire Station #2 101 45202 01 409.05 City Hall / Central Park 101 45202 01 409.06 DCTC Baseball Field 101 45202 01 416.00 Machinery Rental 101 45202 01 416.01 Mower Leases 101 45202 01 416.02 Miscellaneous Rentals 101 45202 01 433.00 Dues & Subscriptions 101 45202 01 433.01 MN Park Supervisors Ass'n 101 45202 01 433.02 Miscellaneous Dues 101 45202 01 435.00 Books & Pamphlets 101 45202 01 437.00 Conferences & Seminars 101 45202 01 437.01 Seminars & Workshops 101 45202 01 437.02 School & Tuition 101 45202 01 437.03 CarteGraph, ESRI, GIS 101 45202 01 439.00 Other Miscellaneous Charges 101 45202 01 530.00 Improvements Other Than Bldgs PAGE TOTALS DEPARTMENT TOTALS 13 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 16,000 2,985 3,686 3,847 13,000 12,000 RPZ- Inspect & Replace(& Blowout) 3,951 3,299 2,475 6,000 3,000 36 601 1,330 3,000 1,000 3,806 5,537 38,100 0 0 2,133 2,000 2,000 0 0 7,531 6,000 8,500 Mowing and Chemical Application 0 0 0 2,500 3,700 Mowing and Chemical Application 0 0 0 2,000 2,600 Mowing and Chemical Application 0 0 0 4,000 6,300 Mowing and Chemical Application 0 0 0 0 15,000 DCTC Baseball Field Maintenance 17,500 14,584 15,685 3,727 19,000 16,000 3 John Deere's 1,425 1,689 3,580 1,500 1,500 100 0 0 0 50 50 70 60 '45 50 50 0 0 0 0 0 3,300 616 967 726 1,500 1,500 Green Expo, MPSA, Playgrounds 1,285 1,219 156 1,300 1,300 Turf School, Power Limited Tech. 0 0 0 500 500 User Group, Conference, Training 0 0 0 200 200 Contingencies 124,572 50,000 64,892 65,000 65,000 Next 5 -Year Average Expenditures (Cut $30,000 from Calculation) $153,330 $82,763 $90,442 $127,600 $140,200 $721,147 $652,572 $684,742 $736,200 $773,100 Page One 2012 BUDGET WORKSHEETS PARKS & RECREATION June 3, 2011 2011 2012 Objecl 2012 2008 2009 2010 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 45100 101.00 Salaries & Benefits $664,811 $650,239 $677,923 $695,400 $723,600 Salary, Taxes, PERA & Benefits 101 45100 102.00 Full -Time Overtime 9,443 6,844 4,396 5,000 5,000 101 45100 103.00 Part-Time Salaries & Benefits 131,200 101 45100 10 103.00 PIT Receptionist 30,760 33,014 35,011 35,200 35,200 101 45100 12 103.00 Building Attendants 56,912 62,401 53,294 50,000 53,000 101 45100 83 103.00 Playground Recreation Leaders 24,155 20,757 24,955 21,000 24,000 101 45100 94 103.00 Warming House Attendants 16,453 16,400 15,190 17,000 17,000 101 45100 99 103.00 Park & Rec Committee 1,560 1,559 1,754 2,500 2,000 101 45100 71 103.00 P/T Horticulturist 3,449 7,480 9,738 0 0 Moved to Public Works Budget 101 45100 01 203.00 Printed Forms & Paper 43 0 0 0 0 101 45100 01 205.00 Drafting Supplies 237 149 1,039 500 500 Laminating 101 45100 01 207.00 Training & Instructional Supplies 0 0 0 100 0 101 45100 01 208.00 Miscellaneous Supplies 69 70 94 100 0 101 45100 01 209.00 Other Office Supplies 70 455 1,062. 500 500 Envelopes, Forms, Rulers, etc. 101 45100 01 211.00 Cleaning Supplies 4',406 4,080 3,757 6,000 4,000 101 45100 01 216.00 Chemicals & Chemical Products 789 652 35 1,000 500 101 45100 01 219.00 Other Operating Supplies 5,604 6,816 6,690 6,000 7,000 Rec Programs, 1 st Aid Sup, etc. 101 45100 01 221.00 Equipment Parts 7,854 8,586 10,556 8,500 9,000 101 45100 01 223.00 Building Repair Supplies 3,654 1,063 1,908 3,500 3,500 101 45100 01 229.00 Other Maintenance Supplies 44 0 0 0 5,000 Tournament Supplies 101 45100 01 312.00 Custodial Services 8,307 7,042 4,232 9,000 6,000 Custodial Services- Banquet Rm 101 45100 01 315.00 Special Programs 14,700 101 45100 01 ,, 315.01 Sunday Night Specials 3,002 5,096 6,007 5,500 5,500 Performances (Add Movies) 101 45100 01 315.02 Leprechaun Days 212 242 283 250 250 Trophies & Awards 101 4510001 315.03 "Future Use" 129 0 0 0 0 101 4510001 315.04 Ground Pounders(Running) 54 127 0 200 200 Ribbons & Mailings 101 45100 01 315.05 Nature Programs (Arbor Day) 3,257 3,622 3,018 4,700 4,700 180 Trees 101 4510001 315.06 Puppet Programs 230 11 294 150 150 Tapes, Fuses, Puppets, etc. 101 45100 01 315.07 Special Events 1,751 56 441 1,000 1,000 Publicity & Supplies 101 45100 01 315.08 Adopt -A -Park Program 932 81 453 500 500 Flyers, Signs 101 45100 01 315.09 Miscellaneous Programs 557 0 1,787 2,000 2,000 Start Up Costs 101 45100 01 315.10 ADA Programs 0 20 0 400 400 ADA Program Supplies 101 45100 01 319.00 Other Professional Services 2,723 2,773 1,466 2,500 4,000 ADA Services /Eng.LA Sery Test 101 45100 01 321.00 Telephone Costs 2,973 3,024 3,620 3,100 3,700 Pagers & Cellular Phones 101 45100 01 331.00 Travel Expense , 380 338 160 500 500 101 4510001 341.00 Employment Advertising 696 0 333 700 700 General Employment Ads 1014510001 349.00 Other Advertising 33,900 101 45100 01 349.01 Brochures 36,688 36,914 35,140 28,000 28,000 City Newsletter (3 Per Year) 101 45100 01 349.02 Yellow Pages 4,893 2,148 1,607 2,000 2,000 Rec Ads 101 45100 01 349.03 Special Marketing 4,799 3,871 3,835 3,900 3,900 Garage Sale Ad 101 45100 01 381.00 Electric Utilities 27,864 26,990 27,331 30,000 28,000 101 45100 01 383.00 Gas Utilities 37,862 31,542 23,885 35,000 28,000 101 45100 01 384.00 Refuse Disposal 4,363 3,887 3,737 04,000 4,000 101 45100 01 392.00 P.C. Accessories & Supplies 0 0 0 0 0 101 45100 01 393.00 P.C. Hardware Purchases 1,764 0 1,550 0 0 101 45100 01 394.00 P.C. Software Purchases 13,000 3,742 2,167 2,500 0 See "433.03" Below 101 45100 01 401.00 Contracted Building Repairs 6,408 7,472 7,162 10,000 8,000 101 45100 01 404.00 Contracted Mach & Equip Repairs 1,571 3,840 5,195 8,000 6,000 101 45100 01 409.00 Other Contracted Repair & Maint 19,594 23,507 23,624 23,000 24,000 Air Handler Maintenance Contract 101 45100 01 412.00 Building Rental 16,800 16,800 16,800 16,800 16,800 Monthly Rent Payments to Guard 101 4510001 415.00 Other Equipment Rental 13,054 15,327 17,757 19,000 19,000 Portable Toilets & Other(New Pks) 101 4510001 433.00 Dues & Subscriptions 4,800 101 4510001 433.01 MRPA Dues 1,259 1,426 1,437 1,700 1,700 Minn Recreation & Parks Ass'n 101 4510001 433.02 Miscellaneous 583 1,002 1,761 400 400 Paper, Magazines, etc. 101 45100 01 433.03 On -Line Registrafn Subscription 1,332 181 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,300 101 45100 01 437.01 MRPA State Conference 2,494 1,260 1,055 1,300 1,300 101 45100 01 437.02 MIAMA State Conference 190 0 0 0 0 101 45100 01 437.03 Workshops, Schools, & Tuition 972 1,521 2,432 1,500 2,000 101 45100 01 439.00 Other Miscellaneous Charges 7,586 21,722 9,857 0 0 Donation Account 101 45100 01 530.00 Improvements Other Than Bidgs 0 0 0 0 0 PAGE TOTALS $1,058,589 $1,046,152 $1,055,824 $1,072,700 $1,095,300 General Operating DEPARTMENT TOTALS $1,058,589 $1,046,152 $1,055,824 $1,072,700 $1,095,300 Page Two 2012 BUDGET WORKSHEETS STEEPLE CENTER BUDGET PARKS &' RECREATION June 3, 2011 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 38201.00 Rental Revenues $0 $0 $6,575 $7,500 $14,500 101 38203.00 Rental Revenue - Churches 0 0 0 2,000 0 101 38205.00 A/V Rental Revenues 0 0 0 500 500 101 38207.00 Liquor Providor Revenues 0 0 0 500 0 101 38209.00 Miscellaneous Revenues 0 0 0 3,000 3,000 101 38211.00 Security Services 0 0 700 0 0 TOTAL REVENUES $0 $0 $7,275 $13,500 $18,000 101 45100 30 103.00 Salaries & Benefits $8,000 Salary, Taxes, PERA & Benefits 101 45100 30 103.00 Building Attendants 0 0 2,324 8,000 8,000 101 45100 30 211.00 Cleaning Supplies 0 0 1,654 1,500 1,500 101 45100 30 219.00 Other Operating Supplies 0 0 4,539 1,500 1,500 Events Supplies 101 45100 30 221.00 Equipment Parts 0 0 2,089 1,500 1,500 101 45100 30 223.00 Building Repair Supplies 0 0 3,998 5,000 5,000 101 45100 30 241.00 Small Tools 0 0 74 1,000 500 101 45100 30 242.00 Minor Equipment 0 0 1,304 1,000 1,000 1014510030 321.00 Telephone Costs 0 0 276 1,200 1,200 1014510030 349.00 Other Advertising 0 0 1,220 1,500 1,500 101 4510030 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 0 5,590 15,200 7,000 101 45100 30 383.00 Gas Utilities 0 0 10,632 31,000 12,000 101 45100 30 384.00 Refuse Disposal 0 0 323 1,900 1,000 101 45100 30 401.00 Contracted Building Repairs 0 0 13,855 10,000 10,000 101 45100 30 404.00 Contracted Mach & Equip Repairs 0 0, 6,423 4,200 4,200 101 45100 30 415.00 Other Equipment Rental 0 0 910 500 500 101 45100 30 439.00 Other Miscellaneous Charges 0 0 0 0 0 101 45100 30 521.00 Building & Structure Purchases 0 0 1,604 0 0 101 45100 30 580.00 Other Equipment Purchases 0 0 0 0 0 PAGE/EXPENDITURE TOTALS $0 $0 $56,815 $87,500 $58,900 Page Three 2012 BUDGET WORKSHEETS PARKS & RECREATION June 3, 2011 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments $101,600 101 45100 86 Art Classes $0 $0 $0 $1,000 $1,000 10145100'81 Softball 49,985 44,648 51,127 45,000 40,000 101 45100 82 Volleyball 0 0 0 0 0 101 4510084 Tennis 1,893 1,744 1,215 2,000 2,000 101 45100 85 Tiny Tots 18,543 10,751 9,184 0 0 Eliminated Program in 2010 1014510086 Rosettes 1,111 1,378 1,595 1,200 1,200 101 45100 87 Trips 7,013 5,642 1,700 4,500 1,700 101 45100 88 Broomball 0 0 0 0 0 101 45100 90 Run for the Gold 3,027 4,241 4,358 4,000 4,000 101 45100 91 Camps` 10,846 16,710 19,254 12,000 19,000 101 4510092 Adult Basketball 859 0 0 600 600 101 45100 93 Other Programs 11,218 9,987 17,843 14,500 14,500 101 45100 95 T -Ball 5,286 4,371 5,410 5,000 5,000 101 4510096 Teen Night 5,478 5,279 480 0 0 Eliminated Program in 2010 101 4510097 Adult Soccer League 9,627 0 13,702 10,000 10,000 No League in 2009 101 45100 98 Youth Soccer Lessons 3,406 2,875 2,839 2,600 2,600 128,294 107,625 128,707 102,400 101,600 101 45100 80 219.00 Operating Supplies 0 0 0 1,000 1,000 101 4510081 103.00 Part-Time Salaries 7,332 7,797 7,197 7,000 7,000 101 45100 81 219.00 Operating Supplies 10,037 9,011 12,208 8,000 3,000 101 45100 81 311.00 Officiating Fees 27,470 11,788 26,509 27,000 27,000 101 45100 81 319.00 Other Professional Services 5,146 16,052 5,213 3,000 3,000 101 4510082 103.00 Part-Time Salaries 0 0 0 0 0 101 4510082 219.00 Operating Supplies 0 0 0 0 0 101 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,604 1,475 1,175 1,500 1,500 101 45100 84 219.00 Operating Supplies 290 269 41, 500 500 101 45100 85 103.00 Part-Time Salaries 17,685 10,097 8,799 0 0 101 45100 85 219.00 Operating Supplies 857 654 385 0 0 101 45100 86 103.00 Part-Time Salaries 490 575 711 400 400 101 45100 86 219.00 Operating Supplies 621 803 885 800 800 101 45100 87 103.00 Part-Time Salaries 638 73 0 500 0 101 45100 87 219.00 Operating Supplies 1,700 101 45100 87 219.01 Youth/Teen Trips Supplies 4,561 920 0 0 0 1014510087 219.02 Adult/Senior Trips Supplies 1,815 4,649 1,700 4,000 1,700 101 45100 88 219.00 Operating Supplies 0 0 0 0 0 101 45100 88 311.00 "Officiating Fees 0 0 0 0 0 101 45100 90 219.00 Operating Supplies 3,027 4,241 4,358 4,000 4,000 101 4510091 103.00 Part-Time Salaries 3,297 7,636 10,236 5,000 10,000 101 4510091 219.00 Operating Supplies 7,549 9,074 9,018 7,000 9,000 101 45100 92 219.00 Operating Supplies 859 0 0 600 600 101,45100 93 10100 Part-Time Salaries 3,069 2,469 4,467 3,000 3,000 101 45100 93 219.00 Operating Supplies 7,859 7,318 13,376 11,500 11,500 101 45100 93 319.00 Other Professional Services 290 200 0 0 0 101 45100 95 103.00 Part-Time Salaries 3,435 2,810 3,885 3,500 3,500 1014510095 219.00 Operating Supplies 1,850 1,561 1,525.. 1,500 1,500 101 45100 96 103.00 Part-Time Salaries 1,262 1,011 0 0 0 101 45100 96 219.00 Operating Supplies 4,216 4,268 480 0 0 101 45100 97 103.00 Part-Time Salaries 0 0 0 0 0 1014510097 219.00 Operating Supplies 717 0 1,702 1,000 1,000 1014510097 311.00 Officiating, Fees 8,910 0 12,000 9,000 9,000 1014510098 103.00 Part-Time Salaries 1,989 1,765 1,699 1,000 1,000 1014510098 219.00 Operating Supplies 1,418 1,110 1,140 1,600 1,600 SPECIAL PROGRAM TOTALS 128,294 107,625 128,707 102,400 101,600 GRAND TOTAL - PARK & REC $1,186,883 $1,153,777 $1,241,347 $1,262,600 $1,255,800 Page One 2012 BUDGET WORKSHEETS OTHER FINANCING USES June 3, 2011 Account # Description 101 - 49300 -01 710.00 Transfers 101 - 49300 -01 710.01 Arena Operations Assistance 101 - 49300 -01 710.02 Debt Service Levies FUND TOTALS 2008 2009' Actual Actual $165,000 $115,000 0 0 0 0 $165,000 $115,000 2010 Actual $115;000 0 0 $115,000 2011 2012 Object 2012 Adopted Detail Proposed Budget Amount Budget $477,376 $115,000 0 115,000 0 0 $477,376 $115,000 Comments Unknown at this time a m_m_m a any ` m tnm -,d 'gym a m n n o o> N m a c 0 o o 0 m 3 a N N� x � c m 3m ° » m c m _mm mm <9°n mm 3 ov ^.� 0 — m � c� J C 3 m m a m � a � m = m m m o F J m m w S 0 J m S C C 3 J V V (Jp m S ^ 2 J N O 3 c J v Q c m m �3 m v d 3 0 0 o m m < Q m m 01 m m m o m y � o " m ° + m � ON .a 2 , nay V m d ° 0 3 3 m m 3 n n m O O EF n o M p a. 4m � m m m m 3 m ^ m J N N m m � c m m A c m m Ng� m m 01 0 ! » N mWz N m x m C3 m m 'p J J m C m w m N N N N NNN N N N N N N N NNNN 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 NN N N m3'' H HIH 11 - n y ++ +V V vK _0 0 ZImC m — D;o;D (�1 ;o ;o 0 ggA V m> >> - 0 - 0 F in Q. 3 a n m m O �_m o a m ry o O m O n» 0 0 d m d � 3° ° y o m m °1 ' m 3ng -- yo m zda a0 m m m 3; mxx O m m m a J = D _. :�S '" a cn 0 c — 6 ° =.33 3 C F Q C F m O m J m m ° N 0 o ? A m m' J 4� l _ o 3 m 3 v m m O m m x m m m o< A V a F m a J F m n p m C 0 m f7 W 0 m Z7 m m d n m m 1 3 Y x m W » A r m o m g m -o o m J 3 m M A m L O ? ^ @ 3 m m C V a 3 N m p m d m J C N J 0 3 a m W °ow _m J m< m G f 3 m 3 _ y c J J m N m J _ c c c c c c c c c o 0 o a�i o m m m m m m m ry ry ry j p p 0 D vvvo o o o vo - =-' =x m f o mmn���mmm o o o o o ° A Pp N N O) N O �•— O O (n O 4 E V v N t 0000v O N V Ut O o0 O 00 ° o O ° o o w o N W N N D mi `- N V j � y *. m a€�:m 6 m 3 ra. ff��FF O 03m.3 mdm- a . o =o C 0 0 o 0 ° o o $ C3N O p v N r o- m � m N O O O O 0 0 O O 0 0 O 0 O O O V O O o O O O A A A A A W W N N N V O] A W W N N w OI++ ff ILI 0 0 0 0 0 0 0 o w o o 0 0 A o m o 0 o 0 0 0 0 0 ........ 0 0 0 0 0 0 0 0 _s___ Page One 2012 BUDGET WORKSHEETS INSURANCE - REVENUES June 3, 2011 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account# - Description Actual Actual Actual Budget Amount Budget Comments 206 31010.00 Current Ad Valorem Taxes $275,000 $275,000 $275,000 $245,000 $245,000 206 33100.00 Federal Grants & Aids 0 0 0 0 0 206 36210.00 Interest Earrings- Investments 24,345 14,596 11,778 15,000 8,000 206 36214.00 Net Change in FV- Investments (375) 596 (172) 0 0 Annual Market Value Changes 206 36215.00 Interest Earnings 409 654 308 800 300 206 36260.00 Other Revenue 19,713 38,312 41,905 24,000 38,000 Insurance Refunds /Dividends 206 36265.00 Use of Reserve Funds 0 0 0 0 0 FUND TOTALS -- - - - - -- 319,091 ---- --- - -- 329,159 --- -- -- ---- 328,818 --- ------- 284,800 --- --- -- - - -- --- -- -- - - -- 291,300 INSURANCE - EXPENDITURES 2011 2012 Object 2012 2008 2009. 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 206 49006 01 221.00 Equipment Parts $0 $5,069 $2,621 $2,500 $8,000 Liability & Auto Deductible Pymts 206 49006 01 304.00 Legal Fees 0 500 500 500 500 Unreimbursable Legal Fees 206 49006 01 305.00 Medical & Dental Fees 5,051 5,071 11,850 6,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 10,100 6,000 10,500 6,000 6,000 206 49006 01 319.02 CHESS Consultant 8,200 12,300 12,300 12,300 12,300 206 49006 01 365.00 Worker's Compensation Insurance 88,429 95,224 105,374 100,000 110,000 Annual Premium 206 49006 01 369.00 Other Insurance 165,746 165,849 163,362 100,000 85,000 Annual Premium - General Liability (Changed to High Deductible) 206 49006 01 403.00 Contracted R & M -Other Impr. 0 0 33,016 0 0 Liability & Auto Deductible Pymts 206 49006 01 409.00 Other Contracted Repair & Maint 10,120 8,728 8,651 55,000 55,000 Liability & Auto Deductible Pymts 206 49006 01 439.00 Other Miscellaneous Charges 0 1,000 1,000 0 0 (Changed to High Deductible) FUND TOTALS 290,145 302,242 351,675 284,800 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. Page One Account # 201 31010.00 201 31050.00 201 33130.00 201 33425.00 201 34109.00 201 36210.00 201 36215.00 201 36230.00 201 36260.00 201 36265.00 201 39101.00 EXPENDITURES. May 17, 2011 2012 BUDGET WORKSHEETS PORT AUTHORITY - REVENUES a Account # 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments Current Ad Valorem Taxes $50,000 $50,000 $50,000 $58,600 $58,600 All Salary Costs Inclusive of $3,870 $2,468 $3,433 $5,000 0 $5,000 Salary, Taxes, PERA & Benefits Federal Grants -CDBG 0 0 0 0 0 Port Authority Members 0 1,900 0 4,000 0 2,000 LCDA Downtown Grant 1,596 565 714 3,000 200 3,000 Genz -Ryan Tenant Utility Pymts 6,000 6,000 6,000 6,000 500 6,000 Yearly Fee Per Policy F -3 Interest Earnings 204 265 320 200 17,400 Checking Interest & Misc 3,150 0 0 2,000 2,000 0 0 416 7,741' 10,000 10,000 0 Twin Cities Marketing Initiative 7,996 10,112 10,564 0 0 0 10,546 0 0` 1;000 0 0 0 0 0 0 5,400 - ------ ---- -- $59,500 ---- - ----- --- ---- ---- -- - --- $59,300 7,307 1,603 0 0 0 117 241 132 800 800 0 0 291 0 0 2,050 4,644 401 10,000 11,800 Additional Marketing 491 365" 855 3,100 3,100 456 488 538 500 500 Commissioners 4,385 5,154 5,079 5,400 2,000 Property Insurance 4,420 479 193 500 500 Business Park & Other Properties 9,814 1,279 0 500 0 Other Properties 1,871 239 0 500 0 Utility Fees 0z 0 0 0 0 1,700 Prof Organizations /Journals 1,195 1,674 1,483 1,700 1,700 0 0 0 0 0 4,697 2,731 3,034 5,000 5,000 Development(TIF /Miscellaneous 89 200 86 500 500 Contingencies 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $70,049 $40,559 - _ $40,543 - - - $59,500 - - -- --- --- - --- - -- $59,300 a Account # Description 201 46300 99 103.00 Part-Time Salaries & Benefits 201 46300 01 303.00 Engineering Fees 201 46300 01 304.00 Legal Fees 201 46300 01 317.00 General Fund Administrative Fees 201 46300 01 319.00 Other Professional Services 201 46300 01 319.01 Project Management Consultant 201 46300 01 319.02 Marketing - REDE - City Share 201 46300 01 319.03 County TIF Charges 201 46300 01 319.04 P/A Property Tax Payments 201 46300 01 319.05 Other Consultants 201 46300 01 319.07 Central Park Survey Work 201 46300 01 322.00 Postage Costs 201 46300 01 331.00 Travel Expense 201 46300 01 349.00 Other Advertising 201 46300 01 359.00 Other Printing & Binding Costs 201 46300 01 365.00 Workers Comp Insurance 201 46300 01 369.00 Other Insurance 201 46300 01 381.00 Electric Utilities 201 46300 01 383.00 Gas Utilities 201 46300 01 389.00 Other Utility Services 201 46300 01 403.00 Contracted Repairs & Maintenance 201 46300 01 433.00 Dues & Subscriptions 201 46300 01 433.01 Professional Organizations/Journ< 201 46300 01 433.02 Foreign Trade Zone Commission 201 46300 01 437.00 Conferences & Seminars 201 46300 01 439.00 Other Miscellaneous Charges 201 46300 01 521.00 Building & Structure Purchases 201 46300 01 525.00 Building & Structure Purchases 201 46300 01 530.00 Improvements Other Than Bldgs 201 46300 01 710.00 Transfers_. FUND TOTALS 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Description Actual Actual Actual Budget Amount Budget Comments Current Ad Valorem Taxes $50,000 $50,000 $50,000 $58,600 $58,600 Operating Levy Tax Increments 0 0 0 0 0 Admin Fees Portion Only Federal Grants -CDBG 0 0 0 0 0 Other State Grants & Aids 0 4,474 0 0 0 LCDA Downtown Grant Other Charges for Services 13,319 605 0 200 0 Genz -Ryan Tenant Utility Pymts Interest Earnings - Investments 632 824 10 500 500 Interest Earned on CD's Interest Earnings 204 265 320 200 200 Checking Interest & Misc Contributions/Donations 0 0 0 0 0 Other Revenue 421 0 0 0 0 Use of Reserve Funds 0 01 0 0 0 Sales of General Fixed Assets 0 0 0 0 0 FUND TOTALS $64,576 -- --- - $56,168 -- -- ----- $56,330 - ------ ---- -- $59,500 ---- - ----- --- ---- ---- -- - --- $59,300 Description 201 46300 99 103.00 Part-Time Salaries & Benefits 201 46300 01 303.00 Engineering Fees 201 46300 01 304.00 Legal Fees 201 46300 01 317.00 General Fund Administrative Fees 201 46300 01 319.00 Other Professional Services 201 46300 01 319.01 Project Management Consultant 201 46300 01 319.02 Marketing - REDE - City Share 201 46300 01 319.03 County TIF Charges 201 46300 01 319.04 P/A Property Tax Payments 201 46300 01 319.05 Other Consultants 201 46300 01 319.07 Central Park Survey Work 201 46300 01 322.00 Postage Costs 201 46300 01 331.00 Travel Expense 201 46300 01 349.00 Other Advertising 201 46300 01 359.00 Other Printing & Binding Costs 201 46300 01 365.00 Workers Comp Insurance 201 46300 01 369.00 Other Insurance 201 46300 01 381.00 Electric Utilities 201 46300 01 383.00 Gas Utilities 201 46300 01 389.00 Other Utility Services 201 46300 01 403.00 Contracted Repairs & Maintenance 201 46300 01 433.00 Dues & Subscriptions 201 46300 01 433.01 Professional Organizations/Journ< 201 46300 01 433.02 Foreign Trade Zone Commission 201 46300 01 437.00 Conferences & Seminars 201 46300 01 439.00 Other Miscellaneous Charges 201 46300 01 521.00 Building & Structure Purchases 201 46300 01 525.00 Building & Structure Purchases 201 46300 01 530.00 Improvements Other Than Bldgs 201 46300 01 710.00 Transfers_. FUND TOTALS Page One May 17, 2011 Account # 242 31010.00 242 31050.00 242 33400.00 242 33425.00 242 33620.00 242 36210.00 242 36215.00 242 36220.00 242 36230.00 242 36260.00 242 39310.00 2012 BUDGET WORKSHEETS DOWNTOWNIBROCKWAY DISTRICT(0108) - REVENUES Description Current Ad Valorem Taxes Tax Increments State Grants & Aids Other State Grants & Aids Other County Grants & Aids Interest Earnings - Investments Interest Earnings Rents & Royalties Other Revenue Contribution /Donation - Private Bond Proceeds FUND TOTALS EXPENDITURES 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $0 $21,420 $37,968 $0 $0 MVHC Payments 296,735 357,931 410,286 350,000 1 470,000 422,179 242,085 1,876 0 0 0 12,551 139,965 0 0 100,000 0 0 0 0 427 37 73 0 0 99 294 244 0 0 30,252 875 2,425 0 0 9,500 0 0 0 0 0 0 125 0 0 6,040,000 0 0 0 0 $6,899,192 $635,193 $592,961 $350,000 $470,000 Account # Description 2008 Actual 2009 Actual 2010 Actual 2011 2012 Object Adopted Detail Budget Amount 2012 Proposed Budget Comments 242 49042 01 303.00 Engineering Fees $201,758 $42,777 $3,690 $0 $0 242 49042 01 304.00 Legai Fees 434 128 0 0 0 242 49042 01 319.00 Other Professional Services 177,259 18,129 4,730 15,000 15,000 County TIF Charges (in 2011) 242 49042 01 522.00 Building & Structure Purchases 900,945 57,700 0 0 0 242 49042 01 530.00 Improvements Other Than Buildings 1,944,456 160,445 0 0 0 242 49042 01 533.00 Waterford Grant Reimbursement 0 0 139,965 0 0 242 49042 01 601.00 Principal on Waterford PAYG 0 0 0 0 48,000 Waterford Pay -As- You -Go 242 49042 01 611.00 Interest on Waterford PAYG 34,825 0 0 0 72,000 Waterford Pay -As- You -Go 242 49042 01 710.00 Transfers 86,000 420,000 280,000 335,000 335,000 P & I for 2008A & 2008B Issues FUND TOTALS $3,345,677 $699,178 $428,385 $350,000 $470,000 ra Page One 2012 BUDGET WORKSHEETS ARENA- REVENUES June 3, 2011 r 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 650 36210.00 Interest Earnings - Investments $0 $0 $274 $0 $0 650 36215.00 Interest Earnings 47 320 274 100 100 650 36230.00 Contributions /Donations 0 597 0 0 0 650 36260.00 Other Revenue - Learn to Skate 44,774 31,648 39,709 34,000 39,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 221,861 236,606 247,457 230,000 247,000 650 38061.00 Non -Prime Time Ice Fees 81,056 74,964 87,068 75,000 85,000 650 38063.00 Open Skating Ice Fees 8,917 6,163 5,216 6,000 6,000 650 38064.00 Broomball Revenues 8,220 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 7,700 6,220 13,000 10,000 10,000 650 38067.00 Skate Sharpening Revenue - Arena 4,672 3,844 3,636 4,000 4,000 650 38090.00 Concessions 3,900 3,900 3,900 3,900 3,900 650 38091.00 Vending Machine Revenues 8,472 6,653 5,974 8,000 6,000 '650 38095.00 Pro Shop Revenues 1,058 965 837 1,200 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 165,000 115,000 115,000 115,000 115,000 Subsidy for Operations FUND TOTALS 555,678 486,881 522,345 487,200 517,000 ra Page One 2012 BUDGET WORKSHEETS ARENA - EXPENDITURES June 3, 2011 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 650 45130 101.00 Salaries & Benefits $155,200 Salary, Taxes, PERA & Benefits 650 45130 77 101.00 Administrative 29,814 39,280 43,775 38,900 40,000 650 45130 78 101.00 Technical /Clerical 28,383 33,224 34,427 35,700 36,900 650 45130 79 101.00 Maintenance 89,495 60,654 67,022 70,500 78,300 650 45130 xx 10 1. 00 Salary & Benefit Contingency 0 0 0 0 2,400 650 45130 79 102.00 Full -Time Overtime 3,826 3,836 2,456 2,000 2,000 650 45130 103.00 Part-Time Salaries & Benefits 50,000 650 45130 89 103.00 Learn -To -Skate Program 24,985 23,641 20,097 25,000 25,000 650 45130 99 103.00 Building Attendants 33,493 31,815 24,507 25,000 25,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 0 100 100 650 45130 01 208.02 Other Supplies 418 176 0 600 600 650 45130 01 209.00 Other Office Supplies 687 54 185 500 500 Learn to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 3,811 2,961 3,409 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 2,528 4,217 4,835 3,000 5,000 Cooling Tower 650 45130 01 219.00 Other Operating Supplies 16 2,523 38 500 500 Events Supplies 650 45130 01 221.00 Equipment Parts 4,302 4,374 3,034 4,000 6,000 Camera Replacements 650 45130 01 223.00 Building Repair Supplies 1,952 2,149 826 3,000 3,000 650 45130 01 265.00 Other Items for Resale 600 517 333 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 1,080 0 0 0 0 650 45130 01 317.00 General Fund Admin Fees 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Admin Fee Policy 650 45130 01 321.00 Telephone Costs 1,000 833 1,174 1,000 1,200 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 284 110 110 400 400 650 45130 01 365.00 Workers Comp Insurance 2,994 2,730 3,567 3,200 3,500 650 45130 01 369.00 Other Insurance 7,772 7,884 7,671 8,000 8,000 650 45130 01 381.00 Electric Utilities 110,858 112,239 115,700 120,000 120,000 650 45130 01 383.00 Gas Utilities 37,862 27,568 23,885 31,000 31,000 650 45130 01 384.00 Refuse Disposal 3,613 3,237 3,178 3,500 3,500 650 45130 01 401.00 Contracted Building Repairs 3,096 6,754 1,928 7,000 7,000 650 45130 01 404.00 Contracted Mach & Equip Repairs 16,101 23,788 19,230 16,000 16,000 650 45130 01 415.00 Other Equipment Rental 0 300 0 300 300 650 45130 01 433.00 Dues & Subscriptions 350 1,165 868 500 1,000 MIAMA & MRPA Dues, 650 45130 01 437.00 Conferences & Seminars 0 220 0 400 400 MIAMA Seminars 650 45130 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 Contingencies e 650 45130 01 521.00 Building & Structure Purchases 64,921 0 0 0 0 650 45130 01 580.00 Other Equipment Purchases 2,822 0 42,000 12,000 23,000 Lighting 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 - _ 486,563 -- 405,748 - -- - 433,757 - ----- --- --- ----- 426,400 - - - --- - - -- 454,900' J Page One 2012 BUDGET WORKSHEETS WATER UTILITY - REVENUES- June 3, 2011 Account # Description 601 33425.00 Other State Grants & Aids 601 34108.00 Administrative Fees -Other Funds 601 34109.00 Other Gen'I Govt Chgs for Services 601 36101.00 Principal - Special Assessments 601 36102.00 Penalties & Interest - S/A 601 36210.00 Interest Earnings - Investments 601 36214.00 Net Change in FV- Investments 601 36215.00 Interest Earnings 601 36220.00 Rents & Royalties 601 36260.00 Other Revenues 601 36265.00 Use of Reserve Funds 601 37110.00 Residential Water Revenues 601 37120.00 Apartment Water Revenues 601 37125.00 Institutional Water Revenues 601 37130.00 Commercial Water Revenues 601 37140.00 Industrial Water Revenues 601 37160.00 Penalties - Water Revenues 601 37165.00 Meter Maint Water Revenues 601 37170.00 Other Water Revenues 601 37180.00 Water Meter Sales Revenue 601 39103.00 Gain or Loss from F/A Disposal 601 39203.00 Transfer From (6,319) FUND TOTALS 2008 Actual 2009 Actual 2010 Actual 2011 Adopted Budget 2012 Object 2012 Detail Proposed Amount Budget Comments $0 $0 $1,208 $0 $0 5,378 4,655 590 0 0 5% of 5% Fees -Const Projects 2,500 2,500 10,380 0 0 45,448 56,332 48,772 50,000 50,000 (28) 280 10,808 0 0 88,409 77,357 72,361 60,000 60,000 7,341 1,691 (6,319) 0 0 Annual Market Value Changes 554 980 736 1,000 1,000 49,709 51,646 70,594 50,000 65,000 Antenna Leases ` 0 0 0 0 0 0 0 0 0 0 907,400 919,742 999,856 1,050,000 1,050,000 68,576 75,721 71,064 70,000 70,000 45,900 36,079 72,159 35,000 50,000 55,094 56,092 71,616 55,000 60,000 54,720 56,702 64,269 55,000 60,000 9,652 8,750 8,861 8,000 8,000 0 0 0 0 0 0 0 0 0 0 56,669 30,714 32,138 30,000 30,000 0 (3,290) 0 0 0 0 0 0 0 0 $1,397,321 $1,375,951 $1,529,091 $1,464,000 $1,504,000 Page One 2012 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES - June 3, 2011 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 601 49400 101.00 Salaries & Benefits $404,500 Salary, Taxes, PERA & Benefits 601 49400 77 101.00 Administrative 100,662 117,241 117,561 113,100 114,700 6014940078 101.00 Technical/Clerical 150,848 161,253 158,239 171,600 145,900 601 49400 79 101.00 Maintenance 127,752 131,861 137,759 145,200 143,900 601 49400 xx 101.00 Salary & Benefit Contingency 0 0 0 0 6,600 601 49400 102.00 Full -Time Overtime 6,825 6,851 8,493 7,500 7,500 601 49400 103.00 Part-Time Salaries & Benefits 6,758 10,979 8,521 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 Primed Forms & Paper 1,742 1,576 1,832 2,000 2,000 Inserts & Water Bill Statements 601 49400 01 209.00 Other Office Supplies 280 190 97 200 200 Disks, Ribbons, etc. 601 49400 01 216.00 Chemicals & Chemical Products 64,796 66,479 62,382 90,000 65,000 Chlorine, Flouride, Polyphos 601 49400 01 219.00 Other Operating Supplies 231 0 0 200 200 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 35,400 Meters, MIU's & CU Horns 601 49400 01 220.01 For Replacements 19,081 912 6,275 0 10,000 From Water Rate Model 601 49400 01 220.02 For New Homes 61,712 12,333 53,511 40,000 25,400 From Water Rate Model 601 49400 01 224.00 Street Maintenance Materials 2,534 524 1,468 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 0 68 0 500 500 Topsoil, Seed & Sod 601 49400 01 227.00 Utility System Maintenance Supplier 130 0 0 0 0 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,000 601 49400 01 229.01 Supplies for Hydrants 4,422 5,546 5,398 5,500 5,500 601 49400 01 229.02 Valve & Curb Boxes 510 226 1,355 1,300 1,300 601 49400 01 229.03 Valve Replacement / Inspection 0 91 0 2,200 2,200 601 49400 01 229.04 Miscellaneous Supplies 3,225 1,722 2,035 5,000 5,000 601 49400 01 241.00 Small Tools 1,263 2,393 1,607 2,000 2,000 Wrenches, Shovels, etc. 601 49400 01 242.00 Minor Equipment 3,000 601 49400 01 242.01 Miscellaneous Purchases 2,811 1,684 2,897 3,000 3,000 601 4940001 303.00 Engineering Fees 34,000 601 49400 01 303.01 Water Conserv'n & Emergency 2,132 0 0 0 0 6014940001 303.02 GIS 10,257 9,103 0 7,000 22,000 601 49400 01 303.03 Rate Study 162 0 159 0 0 6014940001 303.04 Miscellaneous Fees 12,317 38,195 30,959 12,000 12,000 6014940001 304.00 Legal Fees 769 282 0 1,000 1,000 601 49400 01 310.00 Testing Services 43,000 601 4940001 310.01 Bacteria & Water Quality 1,960 1,560 1,616 2,000 2,000 Radon, Tri-Chl. 601 4940001 310.02 V.O.C., Pesticides, etc. 0 0 0 1,000 , 1,000 601 49400 01 310.03 CU -PB Testing 37,831 38,454 40,487 40,000 40,000 $6.36 /Connection - Annual Fee (M) 601 49400 01 312.00 Gopher State One -Call 3,500 2,346 2,315 3,500 3,500 Gopher State One -Call (M) 601 49400 01 31100 Temporary Service Fees 0 0 1,913 0 0 601 49400 01 315.00 Special Programs 11,500 601 49400 01 315.01 Public Information 0 0 0 5,500 5,500 Wellhead Protection Plan 601 49400 01 315.02 Plan Amendments 0 0 0 5,000 5,000 Wellhead Protection Plan 601 4940001 315.03 Seminars 0 0 0 1,000 1,000 Wellhead Protection Plan 601 49400 01 315.04 Vulnerability Assessment Imp. 0 0 0 0 0 601'4940001 318.00 Contract Engineer 6,000 6,000 6,000 6,000 6,000 Contracted Engineer forCity(20 %) 601 49400 01 319.00 Other Professional Services 21,100 601 49400 01 319.01 Thaw Pipes, Check Leaks, etc. 3,557 3,061 870 1,500 1,500 601 49400 01 319.02 Supervisory Controls 11,522 500 7,329 5,000 5,000 601 49400 01 319.03 Hazardous Chemical Permits 1,000 525 0 1,000 1,000 MN Department of Public Safety 601 49400 01 319.04 Annual Drinking Water Report 2,271 0 0 2,500 2,500 601 49400 01 319.05 Hazardous Chemical Inventory 1,100 100 0 1,100 1,100 601 4940006 319.06 Contracted Hydrant Painting 6,936 7,412 9,996 10,000 10,000 100 - 150 Hydrants / Yr ($68 each) 601 49400 01 321.00 Telephone Costs 3,013 3,261 2,284 2,500 2,500 Cell Phones, Modesm, GPS 601 49400 01 322.00 Postage Costs 3,975 4,214 4,299 6,000 6,000 Billings with Inserts 601 49400 01 323.00 Radio Units 150 729 1,083 1,500 1,500 800 MHZ Monthly Charges 601 49400 01 331.00 Travel Expense 0 0 0 0 0 AWWA National Seminar 601 49400 01 333.00 Freight & Express Expenses 0 0 0 100 100 Mail -in Repairs 601 4940001 341.00 Employment Advertising 0 0 0 0 0 P/Ters & Personnel Changes 601 49400 01 349.00 Other Advertising 0 0 0 500 500 PAGE TOTALS 664,034 637,671 678,741 T 715,800 682,400 Page Two 2012 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES - June 3, 2011 Account # Description 2008 Actual 2009 Actual 2010 Actual 2011 Adopted Budget 2012 Objecl Detail Amount 2012 Proposed Budget Comments 601 49400 01 352.00 General Notices & Public Info 0 0 0 500. 500 Newsletters 601 49400 01 365.00 Workers Comp Insurance 5,612 6,325 6,641 6,000 6,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 19,794 20,713 19,414 20,000 20,000 Water's Share of Premiums 601 49400 01 391.00 P.C. Maintenance 2,431 446 467 3,000 3,000 Auto Read Software Support 601 4940001 392.00 P.C. Accessories & Supplies 171 392 359 200 200 -601 4940001 393.00 P.C. Hardware Purchases 985 8,414 11,488 500 3,300 GIS Server for Web Maps, Laptops 601 49400 01 394.00 P.C. Software Purchases 2,500 4,574 5,378 5,500 8,900 601 49400 01 394.01 Licensing & Maintenance 0 0 0 0 4,600 Cartegraph, GIS Cartegraph, GIS 601 49400 01 394.02 Online Subscriptions 0 0 0 0 300 Pictometry Pictometry Pictometry 601 49400 01 394.03 New Software Purchases 0 0 0 0 4,000 Cartegraph' Web Portal 601 49400 01 395.00 P.C. Repairs 0 0 0 500 500 601 49400 01 403.00 Contracted R & M - Other Impr 0 5,245 970 6,000 6,000 Watermain Breaks 601 49400 01 416.00 Machinery Rental 0 0 0 2,000 2,000 601 49400 01 433.00 Dues & Subscriptions 1,712 1,796 1,794 1,800 1,800 Suburban Utility Supt Assn, AWWA 601 49400 01 435.00 Books & Pamphlets 61 0 0 300 300 Reference Materials 601 49400 01 437.00 Conferences & Seminars 2,800 601 49400 01 437.01 MN Health Department School 957 586 778 1,000 1,000 Water School, 50% Split w/ 602 (M) 601 49400 01 437.02 AWWA Conference 0 135 0 500 500 601 49400 01 437.03 CarteGrapti, ESRI, GIS 0 0 0 500 1,300 User Group, Conference, Training 601 49400 01 439.00 Other Miscellaneous Charges 13,609 15,850 12,741 15,000 15,000 DNR Annual Water Use (M) 60149400 01 521.00 Building & Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W. Building (14 of 20) 601 49400 01 530.00 Improvements Other Than Bldgs 314,000 601 49400 01 530.01 Well Inspections / Recondition 18,422 16,653 560 0 0 None Scheduled in 2012 601 49400 01 530.02 Miscellaneous Improvements' 0 0 5,237 10,000 10,000 601 49400 01 530.03 CRP of Watermain 0 318,026 0 150,000 150,000 Annual Pavement Management 601 49400 01 530.04 Tower Inspection, Maintenance 0 3,000 0 0 154,000 Interior Paint - Chippendale Tower 601 49400 01 530.05 0 0 0 0 0 601 49400 01 530.06 0 0 0 0 0 601 4940001 530.07 0 0 0 0 0 601 49400 01 560.00 Furniture & Fixture Purchases 0 0 0 0 0 601 49400 01 570.00 Office Equipment Purchases 0 0 42 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 4,153 3,861 3,554 0 0 P.W. Building Expansion(See 521) 601 49400 01 710.00 Transfers 0 0 0 0 0 Transfers for Other Improvements 601- 49400 -01 TOTALS 734,442 1,043,686 748,165 950,100 1,077,700 601 49403 01 221.00 Equipment Parts 43,862 0 0 0 0 Well Capped in 2008 601 49403 01 223.00 Building Repair Supplies 0 0 0 0 0 Well Capped in 2008 601 49403 01 319.00 Other Professional Services 0 0 0 0 0 Well Capped in 2008 601 49403 01 321.00 Telephone Costs 0 0 0 0 0 Well Capped in 2008 601 49403 01 381.00 Electric Utilities 387 0 0 0 0 Well Capped in 2008 601 49403 01 383.00 Gas Utilities 626 0 0 0 0 Well Capped in 2008 601 49403 01 409.00 Other Contracted Repairs & Maint 0 0 0 0 0 601 49403 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 TOTAL - WELL #3 44,874 0 ` 0 0 0 601 49406 01 221.00 Equipment Parts 0 0 77 500 500 601 49406 01 223.00 Building Repair Supplies 0 0 0 500 500 6014940601 319.00 Other Professional Services 0 0 0 1,000 1,000 601 49406 01 321.00 Telephone Costs 0 0 0 0 0 6014940601 381.00 Electric Utilities 1,245 1,245 1,003 1,000 1,000 Pumping & Lighting 601 49406 01 383.00 Gas Utilities 0 0 0 0 0 Heat Only TOTAL - EAST SIDE W/M VAULT 1,245 1,245 1,080 3,000 3,000 601 49407 01 221.00 Equipment Parts 7,782 2,259 720 1,200 1,200 601 49407 01 223.00 Building Repair Supplies 0 0' 0 300 300 601 49407 01 319.00 Other Professional Services 0 0 0 0 0 6014940 01 321.00 Telephone Costs 211 211 211 0 0 601 49407 01 381.00 Electric Utilities 21,819 20,002 19,548 22,000 22,000 Pumping & Lighting ` 601 4940701 383.00 Gas Utilities ' 0 0 0 0 0 601 49407 01 409.00 Other Contracted Repairs & Maint 0 0 0 600 600 RTU's, Pump Motor, etc. 601 49407 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49407 01 530.00 Improvements Other Than Bldgs 0 0 0 10,000 0 TOTAL - WELL #7 29,812 22,472 20,479 34,200 ��� 24,200 Page Three 2012 BUDGET WORKSHEETS WATER UTILITY - EXPENDITURES - June 3, 2011 2011 2012 Objecl 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 601 49408 01 221.00 Equipment Parts 3,513 45 491 1,500 1,500 601 49408 01 223.00 Building Repair Supplies 0 0 0 Soo 500 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 601 49408 01 321.00 Telephone Costs 0 0 0 0 0 601 49408 01 381.00 Electric Utilities 11,269 9,881 3,060 13,000 13,000 Pumping & Lighting 601 49408 01 383.00 Gas Utilities 741 598 497 600 600 Heat Only 601 49408 01 530.00 Improvements Other Than Bldgs 0 0 11,700 0 0 TOTAL - WELL #8 15,523 10,524 15,748 15,600 15,600 601 49409 01 221.00 Equipment Parts 2,021 2,998 10,602 1,500 1,500 601 49409 01 223.00 Building Repair Supplies 0 0 34 100 100 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 601 49409 01 321.00 Telephone Costs 0 0 0 0 0 601 4940901 381.00 Electric Utilities 23,975 23,439 20,988 25,000 25,000 Pumping & Lighting 601 49409 01 383.00 Gas Utilities 971 737 609 1,500 1,500 Heat Only . 601 4940901 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49409 01 530.00 Improvements Other Than Bldgs 0 0 13,000 7,000 0 TOTAL - WELL #9 26,967 27,174 45,234 35,200 28,200 601 4941001 219.00 Other Operating Supplies 0 0 0 500 500 601 49410 01 221.00 Equipment Parts 990 6,535 4,150 500 500 601 49410 01 223.00 Building Repair Supplies 0 23 0 100 100 601 49410 01 321.00 Telephone Costs 722 750 765 0 0 601 49410 01 381.00 Electric Utilities 14,391 12,881 12,182 14,000 14,000 Pumping & Lighting 601 49410 01 409.00 Other Contracted Repairs & Maint 0 0 0 3,000 0 TOTAL - WELL #10 16,103 20,189 17,097 18,100 15,100 Rural Water System 6014941101 221.00 Equipment Parts 590 4,118 1,426 0 0 601 49411 01 381.00 Electric Utilities 0 0 0 0 0 Pumping & Lighting TOTAL - WELL #11 590 4,118 1,426 0 �^ 0 Rural Water System ( #2) 6014941201 221.00 Equipment Parts 1,186 1,006 550 1,000 1,000 601 49412 01 223.00 Building Repair Supplies 0, 0 0 500 500 601 4941201 319.00 Other Professional Services 7,989 0 0 0 0 601 49412 01 321.00 Telephone Costs 0 0 0 0 0 601 49412 01 381.00 Electric Utilities 24,122 20,959 15,214 25,000 25,000 Pumping & Lighting 601 49412 01 383.00 Gas Utilities 0 0 0 1,500 1,500 Heat Only 601 49412 01 409.00 Other Contracted Repairs & Maint 0 0 0 6,500 0 601 49412 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL - WELL #12 33,297 21,965 15,764 34,600 28,100 6014941401 221.00 Equipment Parts 599 193 1,545 500 500 601 49414 01 223.00 Building Repair Supplies 0 0 0 100 100 601 49414 01 319.00 Other Professional Services 908 3,973 0 1,000 1,000 601 49414 01 321.00 Telephone Costs 0 0 0 0 0 601 4941401 381.00 Electric Utilities 32,645 26,936 27,328 30,000 30,000 Pumping & Lighting 601 49414 01 383.00 Gas Utilities 0 0 0 1,000 1,000 Heat Only 601 49414 01 409.00 Other Contracted Repairs & Maint 0 0 0 2,000 0 601 49414 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49414 01 530.00 Improvements Other Than Bldgs 0 0 0 1,800 0 TOTAL - WELL #14 _ 34,151 31,102 28,872 36,500 32,700 601 49425 01 221.00 Equipment Parts 0 346 1,962 500 500 601 4942501 223.00 Building Repair Supplies 0 0 0 100 100 601 49425 01 319.00 Other Professional Services 11,960 0 0 500 500 601 49425 01 321.00 Telephone Costs 2,154 0 0 0 0 601 49425 01 381.00 Electric Utilities 0 25,492 27,050 30,000 30,000 Pumping & Lighting 601 49425 01 383.00 Gas Utilities 0 0 0 1,000 1,000 Heat Only 601 49425 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49425 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL- WELL #15 14,114 25,838 29,012 32,200 32,200 Page Four 2012 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES - June 3, 2011 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 601 4941501 221.00 Equipment Parts 211 1,151 600 500 500 Touch -up Paint 601 4941501 319.00 Other Professional Services 0 0 0 3,000 0 601 49415 01 381.00 Electric Utilities 0 0 0 0 0 601 49415 01 409.00 Other Contracted Repairs & Maint 0 0 0 500 500 601 49415 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 49415 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL - WATER TOWER #1 211 1,151 600 4,200 1,200 f (Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 394 3,428 383 500 500 Touch -up Paint 601 4941601 319.00 Other Professional Services 0 882 0 0 0 Tower Inspection 601 49416 01 321.00 Telephone Costs 0 0 0 0 0 6014941601 381.00 Electric Utilities 933 1,392 1,325 1,400 1,400 601 49416 01 409.00 Other Contracted Repairs & Maint 0 1,323 0 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 1,327 7,025 1,708 2,600 2,600 (Connemara Water Tower) 601 49417 01 221.00 - Equipment Parts 536 615 28 500 500 601 49417 01 319.00 Other Professional Services 1,044 5,853 0 0 0 Tower Inspection 601 49417 01 321.00 Telephone Costs 2,984 0 0 0 0 601 49417 01 381.00 Electric Utilities 0 4,723 4,539' 2,000 2,000 601 49417 01 409.00 Other Contracted Repairs & Maint 0 0 0 500 500 601 4941701 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 4,564 11,191 4,567 3,500 3,500 (Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 3,548 1,920 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 Utilitiei 1,756 2,160 1,885 2,000 2,000 601 49418 01 409.00 Other Contracted Repairs & Maint 1,922 0 3,000 500 500 601 49418 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 4941801 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL - WATER TOWER #3 7,226 4,080 4,885 3,200 3,200 (East Side Water Tower) GRAND TOTAL - ALLDEPTS. $964,445 $1,231,760 $934,635 $1,173,000 $1,267,300 Page One June 3, 2011 Account # 602 33425.00 602 34108.00 602 36101.00 602 36102.00 602 36210.00 602 36214.00 602 36215.00 602 36260.00 602 36265.00 602 37210.00 602 37220.00 602 37225.00 602 37230.00 602 37240.00 602 37260.00 602 39103.00 602 39203.00 2012 BUDGET WORKSHEETS SEWER UTILITY -REVENUES - Description Other State Grants '& Aids Administrative Fees -Other Funds Principal - Special Assessments Penalties & Interest - SIA Interest Earnings - Investments Net Change in FV- Investments Interest Earnings Other Revenues Use of Reserve Funds Residential Sewer Revenues Apartment Sewer Revenues Institutional Sewer Revenues Commercial Sewer Revenues Industrial Sewer Revenues Penalties - Sewer Revenues Gain or Loss from F/A Disposal Transfer From FUND TOTALS 11 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments :$0 $0 $1,208 $0" $0 5,378 4,655 590 0 0 5% of 5% Fees -Const Projects 65,559 78,438 69,472 70,000 70,000 771 534 0 0 0 94,216 65,357 58,124 60,000 60,000 5,640 (1,399) (2,364) 0 0 Annual Market Value Changes 840 1,093 754 1,000 1,000 0 0 0 0 0 0 0 0 47,100 159,800 1,122,524 1,115, 312 1,080,354 1,270, 000 1,270, 000 87,525 91,567 95,269 90,000 90,000 22,669 21,059 21;443 25,000 20,000 53,466 55,305 61,252 55,000 55,000 29,574 56,341 47,286 50,000 50,000 12,742 10,994 11,308 10,000 10,000 0 (5,111) 0 0 0 0 0 0 0 0 $1,500,905 $1,494,146 $1,444,695 $1,678,100 $1,785,800 11 Page One 2012 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - June 3, 2011 Account # Description 602 49450 101.00 Salaries & Benefits 602 49450 77 101.00 Administrative 602 49450 78 101.00 Technical /Clen6al 602 49450 79 101.00 Maintenance 602 49450 xx 101.00 Salary & Benefit Contingency 602 49450 102.00 Full -Time Overtime 602 49450 103.00 Part-Time Salaries & Benefits 602 49450 99 103.01 Utility Commission Wages (50 %) 602 49450 99 103.02 Maintenance Labor 602 49450 01 203.00 Printed Forms & Paper 602 49450 01 209.00 Other Office Supplies 602 49450 01 216.00 Chemicals & Chemical Products 602 49450 01 219.00 Other Operating Supplies 602 49450 01 224.00 Street Maintenance Materials 602 49450 01 225.00 Landscaping Materials 602 49450 01 227.00 Utility System Maintenance Supplies 602 49450 01 241.00 Small Tools 602 49450 01 242.00 Minor Equipment 602 49450 01 303.00 Engineering Fees 602 49450 01 303.01 GIS 602 49450 01 303.02 Rate Study 602 49450 01 303.03 42/52 Sewer Study 602 49450 01 303.04 Miscellaneous 602 49450 01 304.00 Legal Fees 602 49450 01 312.00 Gopher State One -Call 602 49450 01 313.00 Temporary Service Fees 602 49450 01 318.00 Contract Engineer 602 49450 01 319.00 Other Professional Services 602 49450 01 319.01 Televising 602 49450 01 319.02 Root Control 602 49450 01 319.03 Supervisory Controls(Maint Cont) 602 49450 01 321.00 Telephone Costs 602 49450 01 322.00 Postage Costs 602 49450 01 323.00 Radio Units 602 49450 01 331.00 Travel Expense 602 49450 01 333.00 Freight & Express Expenses 602 49450 01 341.00 Employment Advertising 602 49450 01 349:00 Other Advertising 602 49450 01 365.00 Workers Comp Insurance 602 49450 01 369.00 Other Insurance 602 49450 01 391.00 P.C. Maintenance 602 49450 01 392.00 P.C. Accessories & Supplies 602 49450 01 393.00 P.C. Hardware Purchases 602`49450 01 394.00 P.C. Software Purchases 602 49450 01 394.01 Licensing & Maintenance 602 49450 01 394.02 Online Subscriptions 602 49450 01 394.03 New Software Purchases 602 49450 01 395.00 P.C. Repairs 602 49450 01; 403.00 Contracted R & M - Other Impr 602 49450 01 415.00 Other Equipment Rental 602 49450 01 416.00 Machinery Rental 602 49450 01 433.00 Dues & Subscriptions 602 49450 01 435.00 Books & Pamphlets 602 49450 01 437.00 Conferences & Seminars 602 49450 01 437.01 Sewer School 602 49450 01 437.02 Collection System Conference 602 49450 01 437.03 CarteGraph, ESRI, GIS 602 49450 01 439.00 Other Miscellaneous Charges 602 49450 01 521.00 Building & Structure Purchases 602 49450 01 530.00 Improvements Other Than Bldgs 602 49450 01 530.01 Miscellaneous Improvements 602 49450 01 530.02 Misc. Improvements /Repairs 602 49450 01 530.03 CRP of Sewermain 602 49450 01 530.04 602 49450 01 530.05 602 49450 01 540.00 Heavy Machinery Purchases 602 49450 01 560.00 Furniture & Fixture Purchases 602 49450 01 570.00 Office Equipment Purchases PAGE TOTALS 2008 2009 2010 Actual Actual Actual 2011 2012 Objecl 2012 Adopted Detail Proposed Budget Amount Budget Comments 100,622 116,971 117,536 113,100 150,848 161,240 158,239 171,600 127,753 131,861 137,759 145,200 0 0 0 0 6,825 6,850 8,493 7,500 9,758 11,990 8,291 9,000 1,742 1,418 1,258 1,500 0 0 0 200 0 0 0 500 0 362 0 200 637 1,333 1,550 2,500 0 0 0 400 1,852 410 667 3,000 452 346 185 500 2,935 2,198 2,897 3,000 7,245 2,786 121 7,000 0 0 0 0 9,974 0 0 0 1,786 17,327 4,721 15,000 0 0 0 500 3,500 2,346 2,315 4,000 0 0 1,913 0 6,000 6,000 6,000 6,000 1,890 2,028 1,550 3,000 73 399 2,307 2,000 7,436 0 0 5,000 3,013 3,261 2,284 2,500 3,975 4,214 4,299 3,500 150 729 1,083 1,500 '0 0 0 200 0 0 0 100 0 0 0 300 0 0 0 500 5,612 6,325 6,643 7,000 10,595 11,768 10,766 15,000 2,340 446 467 1,000 171 104 138 200 985 4,708 1,370 500 2,500 4,574 5,378 5,500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500 0 248 18,926 2,000 0 0 0 200 0 0 0 2,000' 100 100 50 100 0 0 0 300 962 1,455 1,001 0 0 0 800 0 0 0 1,000 0 0 0 500 145 177 145 100 0 0 0 10,000 434 0 0 0 0 0 0 0 472,309 114,700 145,900 143,900 1,000 8,000 22,000 0 15,000 3,000 2,000 5,000 4,600 300 4,000 800 1,000 1,300 All Salary Costs Inclusive of $404,500 Salary, Taxes, PERA & Benefits 6,600 7,500 9,000 50% -602; 50% -601 100%-602 1,500 Inserts & Water Bill Statements 200 Disks, Ribbons, etc. 500 Root Killer, Degreaser 200 2,500 Patching 400 Topsoil, Seed & Sod 3,000 Manhole Castings 500 Wrenches, Shovels, etc. 3,000 800 MHZ Monthly Charges 200 Use 437.00 37,000 Mail -in Repairs Sewer Repairs 500 4,000 Gopher State One -Call (M) 0 6,000 Contracted Engineer forCity(20 %) 10,000 2,000 200 2,000 100 Suburban LIN. Supt. Ass'n(50 %) 300 Reference Materials 3,100 User Group, Conference, Training 100 Contingencies 10,000 Pymt on P.W. Building (14 of 20) 160,000 0 0 10,000 SCADA System 2,500 Cell Phones, Modems, GPS 3,500 Billings with Inserts 1,500 800 MHZ Monthly Charges 200 Use 437.00 100 Mail -in Repairs 300 Pliers & Personnel Changes 500 1 " 7,000 Sewers Share of Premiums 15,000 Sewers Share of Premiums 1,000 Auto Read Software Support 200 0 1,800 GIS Server to Host Web Maps 8,900 0 0 Cartegraph, GIS 500 Pictometry 500 Cartegraph Web Portal 500 500 2,000 200 2,000 100 Suburban LIN. Supt. Ass'n(50 %) 300 Reference Materials 3,100 User Group, Conference, Training 100 Contingencies 10,000 Pymt on P.W. Building (14 of 20) 160,000 0 0 10,000 10,000 0 0 0 0 234,399 0 150,000 150,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500 500 0 0 500 500 738,373 508,353 717,000 718,700 Annual Pavement Management Page Two 2012 BUDGET WORKSHEETS SEWER UTILITY - EXPENDITURES - June 3, 2011 Account # Description 602 49450 01 602.00 Sewer Service Charges 602 49450 01 611.00 Interest on Lease Payments 602 49450 01 710.00 Transfers 602- 49450 -01 TOTALS 602 49451 01 219.00 Other Operating Supplies 602 49451 01 221.00 Equipment Parts 602 49451 01 229.00 Other Maintenance Supplies 602 49451 01 321.00 Telephone Costs 602 49451 01 381.00 Electric Utilities 602 49451 01 403.00 Contracted R & M - Other Impr 602 49451 01 439.00 Other Miscellaneous Charges (City Hall) TOTAL - LIFT STATION #1 602 49452 01 219.00 Other Operating Supplies 602 49452 01 221.00 Equipment Parts 602 49452 01 229,00 Other Maintenance Supplies 602 49452 01 321.00 Telephone Costs 602 49452 01 381.00 Electric Utilities 602 49452 01 40100 Contracted R & M -Other Impr 602 49452 01 439.00 Other Miscellaneous Charges (Bloomfield 5th) TOTAL - LIFT STATION #7 602 49453 01 219.00 Other Operating Supplies 602 49453 01 221.00 Equipment Parts 602 49453 01 229.00 Other Maintenance Supplies 602 49453 01 321.00 Telephone Costs 602 49453 01 381.00 Electric Utilities 602 49453 01 403.00 Contracted R & M - Other Impr 602 49453 01 439.00 Other Miscellaneous Charges (Shannon Pond) TOTAL - LIFT STATION #3 602 4945401 219.00 Other Operating Supplies 602 49454 01 221.00 Equipment Parts 602 49454 01 229.00 Other Maintenance Supplies 602 49454 01 321.00 Telephone Costs 602 49454 01 381.00 Electric Utilities 602 49454 01 403.00 Contracted R & M - Other Impr 602 49454 01 439.00 Other Miscellaneous Charges (Hawkins) TOTAL - LIFT STATION #4 602 49455 01 219.00 Other Operating Supplies 602 49455 01 221.00 Equipment Parts 602 49455 01 229.00 Other Maintenance Supplies 602 49455 01 303.00 Engineering Fees 602 49455 01 310.00 Testing Services 602 49455 01 321.00 Telephone Costs 602 49455 01 381.00 Electric Utilities 602 49455 01 403.00 Contracted R & M - Other Impr 602 49455 01 439.00 Other Miscellaneous Charges (LeForet Add'n) TOTAL - LIFT STATION #5 602 49456 01 219.00 Other Operating Supplies 602 49456 01 221.00 Equipment Parts 602 49456 01 229.00 Other Maintenance Supplies 602 49456 01 321.00 Telephone Costs 602 49456 01 381.00 Electric Utilities 602 49456 01 403.00 Contracted R & M - Other Impr 602 49456 01 439.00 Other Miscellaneous Charges (Drumcliffe) TOTAL - LIFT STATION #6 2011 2012 Objecl 2012 2008 2009 2010 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 785,283 846,623 923,221 924,000 1,030,000 MWCC Charges 4,153 3,861 3,554 0 0 P.W. Building Expansion(See 521) 0 0 0 01 0 Transfers for Other Improvements 1,261,745 1,588,857 1,435,129 1,641, 000 1,748,700 0 0 0 100 100 7,286 3,785 182' 800 800 0 0 0 200 200 0 0 0 0 0 1,445 836 948 1,500 1,500 0 0 0 200 200 0 0 0 100 100 Contingencies 8,731 4,622 1,129 2,900 2,900 0 0 0 100 100 0 0 0 800 800 0 0 0 200 200 211 211 211 0 0 485 571 558 500 500 0 0 0 200 200 0 0 0 100 100 Contingencies 696 782 769 1,900 1,900 0 0 0 100 100 8,330 4,021 9,421 800 800 0 0 0 200 200 0 0 0 0 0 3,052 3,559 3,546 3,500 3,500 0 0 0 200 200 0 0 0 100 100 Contingencies 11,382 7,580 12,967 4,900 4,900 0 0 0 100 100 2,548 3,550 3,387 800 800 0 0 0 200 200 0 0 0 0 0 3,877 5,317 5,560 4,000 4,000 0 0 0 200 200 0 0 0 100 100- Contingencies 6,425 8,867 8,947 5,400 5,400 0 0 0 a 100 100 962 6,836 724 800 800 0 0 0 200 200 0 5,833 0 0 0 0 1,575 0 0 0 0 0 0 0 0 5,702 5,546 5,125 6,000 6,000 0 42,379 0 200 200 0 0 0 100 100 Contingencies 6,664 62,168 5,849 7,400 7,400 0 0 0 100 100 229 6,400 203 800 800 0 0 0 200 w 200 0 0 0 0 0 7,364 2,024 5,060 7,500 7,500 0 0 0 200 200 0 0 0 100 100 Contingencies 7,593 8,424 5,263 8,900 8,900 Page Three 2012 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES - June 3, 2011 2011 2012 Object 2012 2008 2009 2010 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 546 589 1,659 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 469 679 982 800 800 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 (Gtendalough 5th) TOTAL - LIFT STATION #9 1,015 1,268 2,641 1,900 1,900 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49458 01 221.00 Equipment Parts 211 762 237 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 388 428 473 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 H 0 100 100 Contingencies (Meadows of) TOTAL- LIFT STATION #8 599 1,190 710 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 211 142 0 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 145 180 183 800 800 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 356 321 183 1,900 1,900 GRAND TOTAL - ALLDEPTS. $1,305,205 --- - - - - -- --------- .$1,684,079 --- - - - - -- --- - - - - -- $1,473,586 -- - - - - - -- --- - - - - -- $1,678,100 - -- - - - - -- -- - - - - -- - -- - - - - -- -- - - - - -- $1,785,800 --- - - - - -- --- -- - - -- Page One AV 2012 BUDGET WORKSHEETS STORM WATER UTILITY -REVENUES - June 3, 2011 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 603 33400.00 State Grants & Aids $0 $575,600 $3,816 $0 $0 603 33425.00 Other State Grants & Aids 0 0 1,208 0 0 603 34108.00 Administrative Fees -Other Funds 5,378 4,655 590 0 4 0 5% of 5% Fees -Const Projects 603 36101.00 Principal - Special Assessments 17,405 20,582 17,868 20,000 20,000 603 36102.00 Penalties & Interest - S/A 278 330 0 0 0 603 36210.00 Interest Earnings - Investments 39,863 28,398 28,485 25,000 25,000 603 36214.00 Net Change in FV- Investments 491 312 (11,555) 0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 283 549 617 500 500 603 36260.00 Other Revenues 2,000 0 0 0 0 603 36265.00 Use of Reserve Funds 0 0 0 0 0 603 37300.00 Storm Water Utility Revenues 745,805 787,850 835,434 800,000 820,000 603 37360.00 Penalties - Storm Water Utility 4,159 3,473 3,901 3,500 3,500 603 39203.00 Transfer From 0 0 0 0 0 FUND TOTALS $815,663 $1,421,751 $880,364 $849,000 $869,000. AV Page One 2012 BUDGET WORKSHEETS STORM WATER UTILITY - EXPENDITURES - June 3, 2011 2011 2012 Object 2012 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 603 49500 101.00 Salaries & Benefits $156,100 Salary, Taxes, PERA & Benefits 603 49500 77 101.00 Administrative 0 0 0 0 0 603 49500 78 101.00 Technical /Clerical 87,908 99,414 95,473 101,500 84,100 603 49500 79 101.00 Maintenance 63,876 65,930 68,879 72,600 72,000 603 49500 xx 101.00 Salary & Benefit Contingency 0 0 .0 0 2,700 603 49500 102.00 Full -Time Overtime 3,602 3,496 4,296 6,000 6,000 603 49500 99 103.00 Part -Time Salaries & Benefits 0 0 7,954 8,000 8,000 603 49500 01 203.00 Printed Forms & Paper 1,742 1,418 1,258 1,500 1,500 603 49500 01 204.00 Envelopes & Letterhead 0 0 0 0 0 603 49500 01 208.00 Miscellaneous Supplies 0 159 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 3,798 1,505 1,578 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. 4,940 462 408 3,000 3,000 603 49500 01 225.02 Black Dirt, Seat, Sod, etc. 5 492 299 1,000 1;000 603 49500 01 225.03 0 0 0 0 0 603 49500 01 226.00 'Sign Repair Materials 223 0 287 500 500 603 49500 01 230.00 Equipment Repair Material 959 555 204 1,000 1,000 603 49500 01 241.00 Small Tools 920 629 0 1,000 1,000 603 49500 01 242.00 Minor Equipment 255 269 2,747 2,000 2,000 Misc. Nozzles for Vac Truck 60349500 01 303.00 Engineering Fees 80,000 603 49500 01 '303.01 Problem Area Investigations 69,780 34,272 31,441 10,000 10,000 603 49500 01 303.02 NPDES Phase II 22,097 20,908 28,763 30,000 30,000 603 49500 01 303.03 CSMP Update 2,318 8,955 15,076 0 0 603 49500 01 303.04 Miscellaneous 26,464 10,900 8,525 30,000 30,000 603 49500 01 303.05 GIS 0 0 0 0 10,000 603 49500 01 304.00 Legal Fees 0 207 0 2,000 2,000 603 49500 01 310.00 Testing Services 0 0 0 1,000 1,000 Water Quality Tests (M) 603 49500 01 312.00 Contract Inspection Fees 0 0 0 500 500 3rd Part Inspection Program (M) 603 49500 01 313.00 Temporary Service Fees 0 0 1,275 0 0 603 49500 01 315.00 Special Programs (County Program) 3,850 4,500 4,500 5,000 5,000 Wetland Health & Evaluation Proj 603 49500 01 318.00 Contract Engineer 6,000 6,000 6,000 6,000 6,000 Contracted Engineer for City(20 %) 603 49500 01 319.00 Other Professional Services 0 0 0 5,000 5,000 SCADA 603 49500 01 321.00 Telephone Costs 0 0 2,284 2,500 2,500 Cell Phones, Modems, GPS 603 49500 01 322.00 Postage Costs 3,975 4,214 4,299 5,000 5,000 Billings & Info Mailings 603 49500 01 323.00 Radio Units 150 729 1,083 1,500 1,500 800 MHZ Monthly Charges 603 49500 01 331.00 Travel Expense 0 0 0 200 200 603 49500 01 352.00 General Notices & Public Info 0 0 58 1,000 1,000 Public Info Brochure 603 4950001 365.00 Workers Comp Insurance 2,232 2,572 2,640 3,500 3,500 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 5,660 5,020 4,927 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 2,340 446 467 3,000 3,000 Auto Read Software Support 603 49500 01 393.00 P.C. Hardware Purchases 1,145 4,708 0 500 "1,800 GIS Server to Host Web Maps 603 49500 01 394.00 P.C. Software Purchases 0 4,674 5,378 5,500 8,900 603 49500 01 394.01 Licensing & Maintenance 0 0 0 0 4,600 Cartegraph, GIS 603 49500 01 394.02 Online Subscriptions 0 0 0 0 300 Pictometry 603 49500 01 394.03 New Software Purchases 0 0 0 0 4,000 Cargegraph Web Portal 603 49500 01 403.00 Contracted R & M - Other Impr 55,000 603 49500 01 403.01 Ditching 0 0 0 5,000 5,000 603 49500 01 403.02 Miscellaneous Repairs 26,217 7,201 46,150 50,000 50,000 Storm Maintenance Work 603 49500 01 404.00 Contracted Mach & Equip Repairs 0 0 0 0 0 603 49500 01 416.00 Machinery Rental 0 50 939 5,000 5,000 Pumps 603 49500 01 433.00 Dues & Subscriptions 140 1,015 140 0 0 603 49500 01 435.00 Books & Pamphlets 0 0 0 500 500 Utility Information 603 49500 01 437.00 Conferences & Seminars 2,800 603 49500 01 437.01 Storm Water Management 875 0 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 603 49500 01 437.04 Cartegraph, ESRI, GIS 0 0 0 500 1,300 User Group, Conference, Training 603 49500 01 439.00 Other Miscellaneous Charges 145 147 145 0 0 603 49500 01 530.00 Improvements Other Than Bldgs 150,000 603 49500 01 530.01 CRP of Storm Sewer 2,603 131,031 11,997 150,000 150,000 Annual Pavement Management 603 49500 01 530.02 0 0 0 0 0 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 344,221 421,875 360,346 536,500 536,700 10 Page Two 2012 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES - June 3, 2011 2011 2012 Object 2012 v 2008 2009 2010 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 603 49500 01 710.00 Transfers 63,000 603 49500 01 710.01 1/2 of 2011 P & I Payments(1996B) 83,000 0 0 0 0 Bonds Called 2/1/08 603 49500 01 710.02 1/2 of 2011 P & 1 Payments(1999C) 16,500 0 0 0 0 Bonds Called 2/1/08 603 49500 01 710.03 1/2 of 2011 P & I Payments(2001 B) 54,000 53,000 54,000 0 0 Bonds Called 2/1/11 603 49500 01 710.04 1/2 of 2011 P & I Payments(2001 D) 70,000 0 0 0 0 Bonds Paid off 2/1108 603 49500 01 710.05 1/2 of 2011 P & I Payments(2002B) 28,000 28,000 33,000 8,000 8,000 Bonds Called 2/1/11 603 49500 01 710.06 1/2 of 2011 P & I Payments(2010A) 0 0 0 10,000 10,000 New Refunding Issue 12/10 603 49500 01 710.07 1/2 of 2011 P & I Payments(2003A) 42,000 42,000 42,000 45,000 45,000 Storm Share of Connemara Proj. 603 49500 01 710.10 Projects 0 0 9,542 0 0 603 - 49500 -01 TOTALS 637,721 544,875 498,888 599,500 599,700 603 49511 01 221.00 Equipment Parts 211 836 1,771 "500 500 603 49511 01 321.00 Telephone Costs 0, 0 0 0 0 603 49511 01 381.00 Electric Utilties 206 231 269 500 500 (Copper Pond) TOTAL - LIFT STATION #1 416 1,068 2,040 1,000 1,000 603 49512 01 221.00 Equipment Parts 211 500 237 500 500 603 49512 01 321.00 Telephone Costs 0 0 0 0 0 603 49512 01 381.00 Electric Utilities 0 0 0 500 500 (Schwarz Pond) TOTAL- LIFT STATION #2 211 500 237 1,000 1,000 603 49513 01 221.00 Equipment Parts 211 2,205 0 500 500 603 49513 01 321.00 Telephone Costs 0 0 0 0 0 603 49513 01 381.00 Electric Utilities 3,352 1,673 7,844 3,500 3,500 (Birger Pond) TOTAL - LIFT STATION #3 3,563 3,878 7,844 4,000 M � ^ 4,000 603 49514 01 221.00 Equipment Parts 1,651 r 0 0 500 500 603 49514 01 321.00 Telephone Costs 0 0 0 0 0 603 49514 01 381.00 Electric Utilities 1,964 506 1,265 2,000 2,000 (Marcotte Pond) TOTAL - LIFT STATION #4 3,615 506 1,265 2,500 2,500 603 49515 01 221.00 Equipment Parts 211 231 0 500 500 603 49515 01 321.00 Telephone Costs 0 0 0 0 0 603 49515 01 381.00 Electric Utilities 0 0 0 500 500 (Hawkins Pond) TOTAL - LIFT STATION #5 211 231 0 1,000 1,000 603 49516 01 221.00 Equipment Parts 211 589 0 500 500 603 49516 01 321.00 Telephone Costs 0 0 0 0 0 603 49516 01 381.00 Electric Utilities 219 262 463 500 500 (Glendalough 7th) TOTAL - LIFT STATION #6 430 851 463 1,000 1,000 GRAND TOTAL - ALL DEPTS. $646,166 $551,909 $510,737 $610,000 $610,200