Loading...
HomeMy WebLinkAbout2.d. 2010 Budget DiscussionAGENDA ITEM: 2010 Budget Discussion AGENDA SECTION: i2 s i or' AGENDA NO. 2 7 PREPARED BY: Dwight Johnson, City Administrator ATTACHMENTS: Budget worksheets APPROVED BY: RECOMMENDED ACTION: Discussion Item ROSEMOUNT City Council Workshop Meeting July 15, 2009 EXECUTIVE SUMMARY The recommended budget for 2010 proposes the lowest overall spending since at least 2005. Economic conditions have caused both our tax base and other revenues such as permits to decline further from 2009 levels. The 2010 budget proposes no change in the number of full-time staff and no new vehicles other than police cars. The most notable areas for new spending are to begin maintaining the new soccer fields at DCTC coming on line this Fall and funds to open the former St. Joseph's Church to the public for events. A modest contingency fund is included for possible changes in salary and benefits for current staff, since we have four labor contracts expiring this year. Key characteristics of the proposed 2010 budget are shown in the following table: Budget Facts at a Glance CITY COUNCIL Loss of property tax base from 2009 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 2009 City share of tax impact on median value home Percentage tax reduction on median value home Change in estimated tax rate (City share only EXECUTIVE SUMMARY 4.35% 9.02% +0.95% $235,789 (4.36 $557,889 4.14 $277,644 2.43 $75 -7.43% +3.32% (from .42323 to .43728) BUDGET PROCESS The annual budget process really begins with the adoption of goals and work plans by the City Council early in the year. All participating staff members keep these goals and plans in mind as the budget is developed. At the April 15th workshop meeting, staff reviewed four budget scenarios with the Council. It was generally agreed by the majority of the council that the lowest and highest scenarios were not very realistic. In May, all department directors received budget forms from the Finance Department and developed a first draft of the 2010 budget. At the same time, I worked with staff to develop performance measurements for key city services to be included in the budget process for the first time. In late May, the Finance Director aggregated all of the draft budget requests and also estimated City revenues. The initial budgets developed by staff were very realistic and showed a reduction in the required tax levy. The Finance Director and I then met with each department director and reviewed overall operations as well as every line item in their budgets. We found a number of line items that could be reduced and some that needed to be increased, but the net savings was about $100,000. Next, we looked at long range needs for capital improvements and equipment to arrive at appropriate levies for our three capital funds. Finally, we looked at the overall budget strategically one more time for its overall balance, consistency, impact on taxpayers, and long term impacts on finances for 2011 and beyond. Our hope was to develop the most conservative budget possible that: (1) is consistent with council goals (2) maintains important services, (3) does not weaken the City's long range financial outlook. (4) is balanced not only between revenues and expenditures, but also is well balanced internally between personnel, equipment, technology, operating needs and capital expenditures. The question is often asked as to what the City is doing to save money and improve efficiency. Just in the past several months, the Council has seen and approved proposals and reports showing savings on our phone system, document imaging storage, salt usage, fuel consumption, water usage and other items. According to state law, the preliminary budget and levy must be adopted by September 15 and the final budget must be adopted by December 20th after a public hearing. OUTSIDE FACTORS AFFECTING THE BUDGET Loss of Market Value Homestead Credit On June 16, 2009, Governor Pawlenty announced his plan to unallot significant amounts of certain state aids to cities including Local Government Aid (LGA) and Market Value Homestead Credit (MVHC). Rosemount has not received any LGA in recent years, but did receive some MVHC payments as recently as October, 2008. The amount of MVHC estimated for Rosemount is $362,471 in 2009 and $412,575 in 2010. The Governor's announcement indicates that Rosemount will receive no MVHC payments in either 2009 or 2010. However, because of the way MVHC is calculated, and because it was estimated to increase in 2010 if there were no unallotment, the City actually loses $71,527 in revenue for 2010 based on State projections from earlier this year that were used when developing our first budget drafts. Levy Limits Levy limits were re- imposed by the Legislature for 2009 and will continue to be in effect for 2010. For 2009, the City was allowed an inflation factor of 3.9% plus half the percentage of household growth and half the percentage for new commercial /industrial growth. In 2010, the inflation factor is currently estimated at only .86% (less than 1 and our growth factor is estimated to be .8939% for household growth and .1353% for commercial /industrial growth. Although our overall levy is reduced from the 2009 amount, most of the reduction is in the tax levies for debt service which are outside of the levy limit calculation. The City Council previously designated about two- thirds of its operating surplus from 2008 for debt reduction. Therefore, staff has had to carefully review whether our proposed levy is within the new levy limit. Although staff estimates that we are within the levy limit, we will not have a final levy limit number until September. If necessary, we can invoke an exception to the levy limit for lost MVHC funds in 2008 and 2009 at that time. Staff is checking but this exception may have to be included in the preliminary levy if we are going to utilize this additional levy opportunity. Permit Revenues The economy is continuing to slow the growth of the City. The current 2009 budget was based upon an estimate of 135 new homes. For 2010, after a survey of active builders, we have determined that we should reduce our permit related revenues by an additional $165,000 from the 2009 permit revenues. The 2 2010 budget is based upon an estimate that 100 new homes will be built (60 multifamily and 40 single family homes). As in the past, no perinits for new commercial or industrial projects are assumed. Tax Base For the first time in recent history, the overall tax base in the community has declined. The overall tax capacity value within the City is estimated to be 4.35% lower in 2010 that it was in 2009. The decline in market value of the median home in Rosemount is even more dramatic, with an average decrease in market value of 9.02 The overall tax base did not decline by that much because commercial and industrial property had more moderate declines and new growth in the community offset some of the decline in existing property values. SKB Revenues The City approved a new agreement with SKB, inc. last year that will gradually increase our percentage of revenues from SKB's operations in Rosemount over the next several years. However, current revenue collections have been hindered by the slow economy as well the discovery of an overpayment to the City in early 2009 based upon somewhat incorrect estimates of previous volumes by SKB. Nevertheless, overall SKB revenues are expected to increase over tune, and the allocation of these funds is an important strategic decision. Emerald Ash Borer threat Recently, the Emerald Ash Borer was discovered in the St. Paul area which poses a major threat to Ash trees throughout Minnesota. Rosemount has a number of parks, right -of -ways, and public spaces with Ash trees that may be threatened. While no emerald ash borer insects have been verified in the immediate Rosemount area, it is important to consider the long range threat in looking at future City finances. REVENUES Property taxes fund 83.1% of the General Fund budget and 66.5% of the overall City Budget. As noted above, our tax base is decreased by 4.35% for 2010. However, there are several other categories of General Fund revenues that are also important to the City. The chart below compares budgeted revenue for 2009 with estimated revenue in 2010 for several key categories of revenues. Licenses Permits Intergovernmental Charges for Services Fines Forfeits Recreational Revenues Miscellaneous Revenues SKB revenue (General Fund) 2009 Budget $486,600 $616,000 (no SKB) $379,000 $110,000 $253,800 $254,500 $300,000 2010 Estimated Change $382,600 ($104,000) $566,500 ($49,500) $255,900 ($123,100) $125,000 $15,000 $253,800 0 $198,200 ($56,300) $400,000 $100,000 As can be seen, there are projected decreases in most of the major revenue categories. Without the proposal to increase the amount of SKB funding in the General Fund, the decrease in non -tax General Fund revenues would have been $317,500. The SKB funds are normally a part of the Charges for Services line, but are shown separately here to show their impact. The license permit revenues were detailed in a previous paragraph. The intergovernmental revenues have an $80,000 decrease in the budgeting of delinquent taxes (reduced to zero to offset anticipated collections in the current tax collections) that is offset by small increases in other areas to make the total reduction $49,500. The charges for services have two large decreases for plan check fees ($60,000 part of the permit process) and administrative fees for construction projects ($50,000 development related fees that are not anticipated for 2010). The miscellaneous revenues show a decrease mainly because of an 3 anticipated decrease in investment interest earnings of $10,000 and a decrease of $46,300 in rental revenues because of the loss of St. Joseph's rental of the old school and church as they will have moved into their new facilities in 2009. EXPENDITURES Salaries and Benefits Rosemount employs 82 full time employees. No new full time employees are proposed in this budget. A contingency for potential increases in salaries and /or health cares costs has been included in the proposed General Fund budget in the amount of $152,400. There is some uncertainty about both salaries and benefits at this writing since we have four labor contracts expiring at the end of 2009 and negotiations have not yet begun. Very few other cities have settled new contracts for 2010 either, adding to market uncertainty. With four bargaining units, the City can unilaterally determine 2010 salaries for only certain supervisory and managerial employees. All other salaries and benefits must be bargained. For certain "essential" employees such as police, the State can impose a wage settlement through a state arbitrator, as happened recently in Apple Valley. In addition, we do not receive new health insurance premium figures each year until August. More information should be available before the preliminaiy budget must be adopted in September. St Joe's Church The proposed budget includes operating funds to open the former St. Joe's church and adjacent "gathering space" to the public for events in 2010. The revenues and expenditures for the church property were detailed in a report to the Council in May, 2009. Sufficient capital dollars have already been accumulated in 2008 and 2009 to do minimal code and other improvements to open the building for public use. The net impact on the General Fund is $74,000. This item is included in the 2010 budget because it will make productive use of a significant asset and was also included in the Council's adopted goals and work plan for this year. DCTC soccer fields New soccer fields on DCTC property have been seeded and will be ready for play during 2010. The City must provide for the maintenance of these fields to make use of its investment next year. Additional part time staff is included in the budget for this purpose, but no new equipment is needed at this time. Capital Budgets The City currently has three capital improvement program (CIP) funds: Equipment, Streets, and Buildings. In the Equipment CIP, no new vehicles are proposed except for replacement of police cars. However, staff studies show that long range, the City needs a levy of approximately $400,000 for vehicle replacement, even if we extend the "normal" life of some vehicles by 20 to 50 While our overall Equipment CIP levy is $439,000, only $201,000 is available for current or future vehicles. In 2010 the Equipment CIP will have a surplus, but it faces a significant long range deficit unless the levy is increased in future years. Staff believes that if the levy for expiring Equipment Certificate debt is transferred to the Equipment CIP fund in 2013 and 2014 the long term deficit can be accommodated. The Street CIP is proposed to have a levy of $700,000 for 2010. Public Works Director /City Engineer Andy Brotzler has updated the rating of our streets and indicates that this levy is sufficient in the short run but in the longer term will lead to an overall average pavement rating of 62.5 which is somewhat below the Council's adopted standard (75 rating for collector streets and 60 for residential streets). Our current pavement ratings average 77.5, which is above the council adopted standard. Further analysis of our future street paving needs is in progress and will be available when we discuss the Capital Improvements Program in detail. Our streets have a net asset value of $31,092,317 according to our current CAFR report and represent one of our biggest assets. 4 The Building CIP has a levy of $24,000 for 2010 for the repayment of an internal loan for the current Public Works facility. This fund is not accumulating any funds for replacement or future additions to City buildings such as City Hall or Public Works facilities. Nor are any funds being accumulated for other opportunities or issues that may arise, such as matching grants or dealing with the Emerald Ash Borer threat. Accordingly, it is recommended that $100,000 of the overall SKB funding of $525,000 be allocated to a new CIP fund for these purposes, or that the current Building CIP fund be re- named and re- purposed for more general needs that may or may not include buildings. Items NOT included in 2010 Budget Proposal Earlier this year, a letter was received from the Rosemount Area Seniors Club requesting funding for a part -time senior coordinator. This item is not included in this budget proposal. While staff believes there is merit in this proposal and that this is the next best step to improve senior services in the community, it is difficult for us to recommend funding for a new staff position when no other new staff positions are being added and we have a declining tax base and other declining City revenues. Enterprise Fund Budgets. The Water utility has an anticipated increase of $129,000 from 2009 to 2010. Most of this increase is for improvements to the system including air conditioner temperature and humidity controls for the wells that currently do not have there, humidifiers for the well houses that do not have them, mixers for the water towers, and interior painting of the East Side Water Tower ($150,000). The Sewer utility has an anticipated increase of $144,900 from 2009 to 2010. Most of this increase is for an anticipated increase in the Metropolitan Waste Control Commission (MWXICC) charges that the City pays on an annual basis. The Storm Water utility basically maintains a budget that is constant from 2009 to 2010. The Arena fund has an anticipated increase of $43,600 from 2009 to 2010. This increase can be attributed to the replacement of compressors in the arena. Debt Service Funds. The City ended 2008 with a General Fund surplus. The Council approved a strategy that committed about two- thirds of the surplus to paying off existing debt. Enough funds were available to completely pay off three debt issues, saving not only $526,930 in tax levies for 2010, but also several years of lesser debt payments beyond 2010. Implementation of this strategy is the major reason why we have been able to propose an overall reduced tax levy for 2010 while still maintaining important services. CONCLUSION While it is always a challenge to draft a budget in a time of declining revenues, staff is pleased that a budget could be developed for 2010 that both reduces the tax burden by about $75 for the average resident while not resorting to temporary one -time fixes that could cause tax increases in the future. We believe that the proposed budget is appropriately conservative for the current economic situation, but also keeps us as ready as possible to accommodate economic recovery when it occurs and allows us to continue to address the Council's goals. We look forward to discussing it with you. 5 r July 15, 2009 Departments FUNDING REQUIREMENTS USES (INCLUDING FIRE STATION LEVY) 2009 2010 Adopted Proposed Budget Budget Difference Percentage Council Budget $330,100 $391,800 $61,700 18.69% Administration Budget 553,500 508,300 (45,200) -8.17% Elections Budget 40,000 40,000 0 0.00% Finance Budget 417,900 417,700 (200) -0.05% General Govemment Budget 403,300 387,700 (15,600) 3.87% Community Development Budget 930,000 933,800 3,800 0.41% Police Budget 2,974,200 2,995,900 21,700 0.73% Fire Budget 289,000 301,800 12,800 4.43% Public Works Operating Budgets: Government Buildings Budget 502,000 490,200 (11,800) -2.35% Fleet Maintenance Budget 576,800 606,600 29,800 5.17% Street Maintenance Budget 1,297,000 1,309,700 12,700 0.98% Parks Maintenance Budget 683,900 718,500 34,600 5.06% Park Rec Budget General Operating 1,148,400 1,142,300 (6,100) -0.53% Park Rec Budget Special Programs 123,700 123,700 0 0.00% Transfers Arena Assistance 115,000 115,000 0 0.00% Total Operating Budgets General Fund $10,384,800 $10,483,000 $98,200 0.95% Building CIP Requirements 84,000 24,000 (60,000) 71.43% Street CIP Requirements 765,000 700,000 (65,000) -8.50% Equipment CIP Requirements 445,000 439,000 (6,000) -1.35% Insurance Budget Requirements 275,000 275,000 0 0.00% Port Authority Operating Levy 50,000 50,000 0 0.00% Bonded Indebtedness 1,250,750 729,472 (521,278) 41.68% Bonded Indebtedness Fire Station Levy 146,084 142,273 (3,811) -2.61% Armory Anticipatory Levy (Value 2/19/09) 80,000 80,000 0 0.00% *$2,187,139,000 x .00798% $174,533 Water Enterprise Fund 1,224,900 1,353,900 129,000 10.53% Sewer Enterprise Fund 1,502,400 1,647,300 144,900 9.64% Storm Water Enterprise Fund 665,700 670,300 4,600 0.69% Arena Enterprise Fund 414,400 458,000 43,600 10.52% Total Funding Requirements $17,288,034 $17,052,245 ($235,789) -1.36% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. July 15, 2009 FUNDING REQUIREMENTS SOURCES (INCLUDING FIRE STATION LEVY) 2009 2010 Adopted Proposed Types Budget Budget Difference Percentage Internal Revenue Generated: Licenses and Permits 486,600 382,600 (104,000) 21.37% Intergovernmental 616,000 566,500 (49,500) -8.04% Charges for Services 679,100 655,900 (23,200) -3.42% Fines Forfeits 110,000 125,000 15,000 13.64% Recreational Fees 253,800 253,800 0 0.00% Miscellaneous Revenues 254,500 198,200 (56,300) 22.12% Transfers In 3,500 3,500 0 0.00% Enterprise Revenues 3,807,400 4,129,500 322,100 8.46% Total Internal Revenues 6,210,900 6,315,000 104,100 1.68% MVHC Cuts Made Later To Include in Levy 350,330 412,575 Levy Sources: Special Levies 1,476,834 951,745 (525,089) 35.56% General Levy 9,950,630 10,198,075 247,445 2.49% Total Levy $11,427,464 $11,149,820 ($277,644) 2.43% Loss of MVHC from State Funding $350,330 $412,575 $62,245 17.77% Total Revenue Sources $17,288,034 $17,052,245 ($235,789) -1.36% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. 2009 GENERAL PROPERTY TAX LEVY PAYABLE 2010 GENERAL LEVY GENERAL FUND $8,710,075 BUILDING CIP FUND $24,000 STREET CIP FUND $700,000 EQUIPMENT CIP FUND $439,000 INSURANCE FUND $275,000 PORT AUTHORITY OPERATING LEVY $50,000 TOTAL GENERAL LEVY $10,198,075 TOTAL BONDED INDEBTEDNESS BONDED INDEBTEDNESS G.O. PUBLIC FACILITY BONDS 2001C (Port Authority) (Authorized $173,403) $173,403 G.O. COMMUNITY CENTER REFUNDING BONDS 2001E (Authorized $95,537) G.O. IMPROVEMENT BONDS 2003A (Authorized $86,354) (City Assumed Special Assessments) $86,354 G.O. CAPITAL IMPROVEMENT PLAN (CIP) BONDS 2005A (Authorized $209,846) $209,846 G.O. EQUIPMENT CERTIFICATES 2005B (Authorized $346,540) G.O. EQUIPMENT CERTIFICATES 2006A (Authorized $84,854) G.O. IMPROVEMENT BONDS 2006B (Authorized $268,551) G.O. EQUIPMENT CERTIFICATES 2007B (Authorized $105,079) $105,079 PUBLIC SAFETY REVENUE BONDS 2007 (Dakota Communications Center) (Authorized $62,633) $62,633 G.O. EQUIPMENT CERTIFICATES 2008A (Authorized $92,157) $92,157 $729,472 MARKET VALUE BASED REFERENDUMS G.O. FIRE STATION REFUNDING BONDS, 2005D (Authorized $142,273) $142,273 TOTAL FIRE STATION LEVY $142,273 PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($2,187,139,000 x .00798% $178,954) (As of 2/19/09) $80,000 (Authorized $178,954 Only Levy Amount Due MSABC) TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS $80,000 GRAND TOTAL 2009 PROPERTY TAX LEVY $11,149,820 Last Updated 6123109 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 from Previous Year in Spread Levy Market Value Based Referendum Levy Fire Station Last Updated 6123109 2007 17,341,719 7,189,300 142,527 10,009,892 350,330 10,360,222 2008 17,855,312 6,526,300 144,417 11,184,595 0 11,184,595 870,514 968,892 9,489,708 (1) 10,215,703 (1) 7.65% 154,308 142,527 2009 17,288,034 6,210,900 146,084 10,931,050 350,330 11,281,380 1,141,159 10,140,221 (1) -0.74% 144,417 (Proposed) 2010 17,052,245 6,315,000 142,273 (3) 10,594,972 412,575 11,007,547 1,141,159 (2) 9,866,388 -2.70% (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2010 Number Provided by Dakota County as of 8/xx/09 (3) Market Value Based Levy for Fire Station Based on $142,273 Levy Spread to Taxable Market Value on 2/19/09 Last Update from Dakota County 2/19/09 Shows the Levy of $142,273 $2,187,139,000 $.0650 per $1,000 as our Estimate 142,273 (3) N 44 W 0 3 m p1 Ni 'm m O�U v mO,Z m v g g m n #i �fnnn$ m gw0000 m v 0 0 m m �c 20 m m 0 0 $�3 I oO1 m 8�`� m clml� mO� WV: m y ..W O� m j0 2 D .�7 IF m ^mp j0 m Z •c m m Am �1 8 ¢,1a 0 1 pm m m{ m m� O^ rt N 3 3 am H2 a2,-; Na `D m +m c° Wa 3 R. 1 1 I I PPP Ii I I y 9 888 g O O I O N 11 IPA I O OO O O P `I A W m N 1 W 2! 1 N A 0 11 IJ AN I J A '22 N N ^D II 4 L 10 A 8 pp 1 I J �+p M A In S 4 A N f�pp m 8 Hg —0 Oo r0 W ♦N j A W I W W W A O O 11 O tO fNiIN C O�NN �p I W O� W AO O I i 1 O O O I 8 8 I o 0000 N N II p I O O IJ N A A O O N A N N N 8 �p �1 ��pp p ypg 11 p H Np �N A 8 II A NA W�NOV j�j 1� O —0.W p O 0 N +W RIJO+ JW W W 88 O O 11 O co-“,, O O I fD +W+ HS ,ii 0 10 +t s m ao J N PPP °88 0... Q.J j N 0 r N+ 000 p Q p p p W N M N t0 W II O N O W 000 r0 (p 0 mip 1 O 0 W vA 11 1 it 000 0 8 1 PPP p N 8 RrR -4w 0000 N N A ow N N 0 0 o 000 l it N `8D `�uD 0 8 mp,pO 000N0 D f W J 4 8 i W O 0000 8 8 N N 8 Oro +m 0000 N is A W 03 N 0000 O N N A m(Jl1 c w41 01ACON POOP O O O O O N N A 0 W A O 0000 otiNA AA tO+EW w�S Ja w O m 0 O N 8 0 O N co tl In I N 1 tr W O Ij m u0 1 CO g N N 0 N 0 N 0 N O as �N� N A 01 0 10� m N A OD 1 N �11 A�tO fJ N J +JO1 +A W 000 1 P 86;88 IR1 PPP NW Jf j E j PPP. O �w:n. 0000 YJO !`D 8 p O O O O A p 3 p N N N 01 8 W t0 O p 0 O 0 N m+ N 8 2002 p A i N D1 N 0 UNN ID E W a 2202 pN O�Nf OtfD +00 OD p 0220 A N N 8 gig 8 0 m$- 0022 o w w if w 8 8 O 0 0 A 6 0 r 8 0 N m 0 y r� L OD iE :6 3 in 1 n 1 3 3E0 m om 8 •>0 0 m m g_65 ff I a Page One July 15, 2009 Account 101 31010.00 101 31040.00 101 32110.00 101 32160.00 101 32162.00 101 32210.00 101 32212.00 101 32220.00 101 32221.00 101 32230.00 101 32240.00 101 32250.00 101 32255.00 101 32260.00 101 32290.00 101 31010.00 101 31010.01 101 31020.00 101 31030.00 101 31710.00 101 31810.00 101 31811.00 101 31920.00 101 33100.00 101 33416.00 101 33416.01 101 33416.02 101 33418.00 101 33423.00 101 33425.00 101 33620.00 101 33630.00 101 33630.00 2010 BUDGET WORKSHEETS GENERAL FUND REVENUES Description Current Ad Valorem Taxes Fiscal Disparities Total Taxes (Tax) Alcoholic Beverage Licenses (L) Licenses to do Business (L) Lic to do Business Rental Housing (L) Building Permit Revenue (L) Mineral Extraction Permit (L) Electrical Permit Revenue (L) Admin Fee Electrical Permits (L) Plumbing Permit Revenue (L) Animal Licenses (L) Sewer Permit Revenue (L) County Recording Fee -City's (L) HVAC Permit Revenue (L) Other Non -Bus Lic Permits (L) Total Licenses Permits (L) Current Ad Valorem Taxes (I) MSABC Armory Payments Delinquent Ad Valorem Taxes (I) Mobile Home Taxes (I) Gravel Taxes (I) Franchise Taxes Regular Fees (I) Franchise Taxes PEG Fees (I) Forfeited Tax Sale Apportionment (I) Federal Grants Aids (I) Police Training Reimbursement (I) Post Board Training Reimb State Aid (Tied to PERA) MSA for Streets Maintenance (I) Ag Preserves Credit (I) Other State Grants Aids (I) Other County Grants Aids (I) Police Services Levy -ISD #196 (I) D.A.R.E./Liaison Funding Total Intergovernmental (I) 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $7,568,916 770,288 870,514 968,892 1,141,159 1,141,159 $4,630,971 $5,920,729 $6,732,360 $7,190,471 5,401,259 6,791,243 7,701,252 8,331,630 8,710,075 (350,330) (412,575) 7,981,300 8,297,500 799,651 650,635 698,755 486,600 382,600 623,920 710,336 794,038 616,000 566,500 PAGE TOTALS 6,824,831 8,152,214 9,194,045 9,083,900 9,246,600 From County From County Total Property Tax Levy for Fund 101 State Cuts in MVHC Actual Property Taxes to Receive 33,040 34,525 32,657 32,000 34,000 5,710 6,390 7,730 6,500 7,500 Garbage Haulers, Ped Licenses, etc. O 0 13,191 0 0 575,778 435,956 489,002 300,000 200,000 4,330 740 2,180 4,000 2,000 21,059 15,626 15,795 15,000 15,000 10,250 9,040 7,990 9,000 8,000 50,589 57,039 53,994 45,000 45,000 2,759 2,829 2,442 2,000 2,000 18,862 13,773 7,252 12,000 8,000 190 80 30 100 100 75,329 73,866 66,133 60,000 60,000 1,755 770 360 1,000 1,000 Alarm Permits Fireworks Permits 91,000 91,000 91,000 80,000 80,000 Included in Debt Levy Figure 80,000 80,280 110,316 139,641 70,000 0 From County 8,342 10,635 8,834 9,000 9,000 From County 13,670 18,811 15,348 15,000 15,000 From County 148,080 158,698 169,415 150,000 160,000 From Cable Company 23,118 23,936 23,905 20,000 22,000 From Cable Company O 0 0 0 0 From County O 0 0 0 0 133,872 147,061 147,847 145,000 From State 7,000 7,000 135,000 138,000 26,910 29,115 29,115 26,000 29,000 From State 1,135 1,163 628 0 500 From State 19,465 35,475 21,882 24,000 21,000 From State -PERA Aid Safe Sober 18,500 15,400 82,803 16,000 19,000 Dakota County Recycling Funds 59,548 68,727 63,620 64,000 66,000 66,000 From ISD #196 Page Two July 15, 2009 2010 BUDGET WORKSHEETS GENERAL FUND REVENUES 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 101 34103.00 Zoning Subdivision Fees (C) 47,917 76,425 39,000 50,000 40,000 101 34104.00 Plan Checking Fees (C) 259,610 185,934 174,452 130,000 70,000 101 34105.00 Sales of Maps Publications (C) 1,123 1,859 1,102 1,000 1,000 Maps Spec Books 101 34106.00 Deputy Registrar Fees (C) 58,563 56,373 58,703 5,000 0 Dakota County Taking Over in 2009 101 34107.00 Assessment Searches (C) 160 0 0 0 0 101 34108.00 Admin Fees Other Funds (C) 34,770 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 187,875 96,785 91,434 50,000 0 101 34109.00 Other Charges for Service (C) 8,423 7,749 8,309 6,000 7,000 101 34110.00 Service Chg on Retumed Chks (C) 240 270 180 200 200 101 34112.00 Utility Permit Application Fee (C) 550 1,550 2,129 500 1,000 101 34113.00 Application Fees (C) 15,000 0 5,000 0 0 101 34150.00 User Fees SKB (C) 257,556 315,490 339,518 300,000 400,000 SKB Fees 101 34151.00 User Fees /Host Agreements SKB(C) 25,000 25,000 25,000 25,000 25,000 Landscaping Agreement (Yr 8 of 10) 101 34160.00 National Guard Maint Fees (C) 43,469 47,488 51,445 46,000 46,000 101 34160.00 Shared Space Rental Agreement 16,000 101 34160.00 Building Maintenance Contract 30,000 101 34201.00 Special Police Services (C) 16,117 23,145 52,675 21,000 21,000 Contractual 0/7 for Officers 101 34202.00 Fire Services Burning Permits (C) 450 300 800 0 0 No Longer Charge for Permits 101 34203.00 Accident Reports (C) 114 5 19 100 0 101 34204.00 Day Care Inspection Fees (C) 450 250 100 300 200 101 34206.00 Other Police Services (C) 136 176 713 0 0 101 34207.00 Other Fire Protection Services (C) 11,780 15,655 21,510 15,000 101 34207.01 U of M Fire Contract 6,000 6,000 101 34207.02 Coates Fire Contract 4,000 4,000 101 34207.03 Other Billed Fire Calls 4,000 5,000 101 34301.00 Street, Sidewalk Curb Repairs (C) 0 0 0 0 0 101 34303.00 Mow Weeds (C) 1,349 2,448 2,551 0 1,500 101 34306.00 Other Highway Street Rev (C) 18,990 2,852 20,551 2,000 0 Street Light Bills Developers 101 34310.00 Right -of -Way Permits (C) 0 0 17,990 0 0 101 34407.00 City Share of Metro SAC Chgs (C) 4,821 3,594 6,742 3,000 3,000 Total Charges for Services (C) 1,019,461 888,346 992,674 679,100 655,900 101 35101.00 Court Fines (F) 87,971 120,093 127,239 110,000 125,000 From County Total Fines Forfeits (F) 87,971 120,093 127,239 110,000 125,000 101 34720.00 Park Reservations (R) 879 2,417 4,881 2,500 2,500 Loss of Church 101 34721.00 Softball Revenues (R) 55,128 61,401 64,980 60,000 60,000 101 34722.00 Volleyball Revenues (R) 1,200 0 0 0 0 101 34724.00 Tennis Revenues (R) 1,990 2,354 2,522 2,300 2,300 101 34725.00 Tiny Tot Revenues (R) 21,928 21,932 18,334 22,000 22,000 101 34726.00 Rosettes Revenues (R) 949 510 1,110 1,200 1,200 101 34727.00 Field Trip Revenues (R) 7,300 7,300 101 34727.01 Youth/Teen Trips 9,794 4,988 4,658 5,000 101 34727.02 Adult/SeniorTrips 1,284 1,749 1,735 2,300 101 34728.00 Soccer League Revenues (R) 0 13,741 10,391 0 0 No League in 2010 101 34730.00 Run for the Gold Revenues (R) 4,273 3,971 4,397 4,000 4,000 101 34731.00 Soccer Lessons (R) 2,006 1,980 3,335 2,000 2,000 101 34732.00 Adult Basketball Revenues (R) 1,052 2,108 1,406 2,000 2,000 101 34733.00 Other Programs Revenues (R) 14,072 16,227 13,468 14,000 14,000 101 34735.00 Camps Revenues (R) 12,743 13,028 13,095 12,000 12,000 101 34736.00 T -Ball Lessons (R) 5,150 5,176 5,287 5,000 5,000 101 34790.00 Other Recreation Revenues (R) 0 0 0 0 0 101 38080.00 Banquet Room Fees (R) 56,790 64,852 75,555 62,000 65,000 101 38081.00 Auditorium Fees (R) 10,045 6,219 6,059 8,000 7,000 101 38082.00 Gymnasium Fees (R) 25,007 32,290 28,864 30,000 30,000 101 38086.00 Classroom Fees (R) 16,307 12,725 9,386 12,000 10,000 101 38096.00 Liquor Provider Fees (R) 1,170 1,320 1,230 1,300 1,300 101 38097.00 AN Rental Fees (R) 1,795 688 1,221 1,000 1,000 101 38154.00 Teen Night Revenues (R) 5,297 5,064 6,660 5,200 5,200 Total Recreation Fees (R) 248,857 274,740 278,574 253,800 253,800 PAGE TOTALS 1,356,289 1,283,179 1,398,487 1,042,900 1,034,700 Comments Page Three July 15, 2009 2010 BUDGET WORKSHEETS GENERAL FUND REVENUES 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 36101.00 Principal Special Assessments (M) 14,878 12,119 15,680 10,000 10,000 From County 101 Funded Projects 101 36102.00 Penalties Interest S/A (M) 93 15 31 0 0 From County 101 36210.00 Interest Eamings Investments (M) 215,024 277,199 223,236 180,000 170,000 101 36214.00 Net Change in FV- Investments (M) (3,216) 90,546 3,624 0 0 Annual Market Value Changes 101 36215.00 interest Eamings (M) 690 428 1,128 500 500 From Checking Account 101 36220.00 Rents Royalties (M) 5,712 5,236 45,281 57,000 10,700 101 36220.01 Verizon Antenna Rent 6,000 101 36220.02 Athletic Complex Land Rental 3,700 101 36220.03 MVTA -RCC Parking Lot Rental 1,000 Partial Year Rent New Lot Opening 101 36230.00 Contribution /Donations (M) 25,608 25,823 22,580 0 0 101 36260.00 OtherRevenue(M) 1,636 17,154 5,582 2,000 2,000 101 36262.00 Special Settlements (M) 50,010 31,200 0 0 0 101 38090.00 City Concessions (M) 5,171 5,108 4,986 5,000 5,000 Total Misc Revenues (M) 315,606 464,828 322,127 254,500 198,200 101 39202.00 Contribution from Enterprises (T) 3,500 3,500 3,500 3,500 3,500 Arena Building Grounds Maint. 101 39203.00 Transfer From (T) 0 85,469 7,133 0 0 Funds Retumed from Project Total Transfers In (T) 3,500 88,969 10,633 3,500 3,500 PAGE TOTALS $319,106 $553,797 $332,760 $258,000 $201,700 FUND TOTALS $8,500,226 $9,989,191 $10,925,291 $10,384,800 $10,483,000 INTERNAL REVENUES $3,098,967 $3,197,947 $3,224,040 $2,403,500 $2,185,500 Grand Total Less: Ad Valorem Fiscal Disparities Page One July 15, 2009 2010 BUDGET WORKSHEETS COUNCIL 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41110 103.00 Salaries Benefits $26,001 $34,338 $31,253 $35,500 $36,400 Salary, Taxes, PERA Benefits 101 41110 01 225.00 Landscaping Materials 25,021 25,005 25,154 25,000 25,000 SKB Landscaping Agreement 101 41110 01 307.00 City Promotional Fees 26,100 101 41110 01 307.01 Newsletter 13,756 22,263 27,718 29,000 25,000 101 41110 01 307.02 Chamber of Commerce Directory 1,065 1,065 2,130 1,100 1,100 101 41110 01 307.03 Community Survey 0 18,500 0 20,000 0 101 41110 01 319.00 Other Professional Services 548 10,000 101 41110 01 319.01 Education Reimbursement 11,897 10,909 5,834 8,000 8,000 101 41110 01 319.02 HIPP Initiatives 48 0 0 5,000 2,000 101 41110 01 319.04 Technology Study 0 24,500 1,000 0 0 101 41110 01 321.00 Telephone Costs 79 600 101 41110 01 321.01 Mayor's Pager 0 27 0 0 0 101 41110 01 321.02 Mayor's Cell Phone 0 0 63 600 600 101 41110 01 329.00 Other Communication Costs 70 0 0 1,000 500 Newspaper Ads Open Houses 101 41110 01 331.00 Travel Expense 3,500 101 41110 01 331.01 NLC Conference 1,450 3,418 1,627 2,000 2,000 101 41110 01 331.02 Miscellaneous Travel 229 1,448 1,185 1,000 1,500 101 41110 01 433.00 Dues Subscriptions 24,600 101 41110 01 433.01 LMC Dues 12,523 13,397 14,368 14,500 15,000 101 41110 01 433.02 AMM Dues 5,357 5,734 6,423 6,200 7,000 101 41110 01 433.03 Dak Cty Regional Chamber 579 0 579 600 800 101 41110 01 433.04 NLC Dues 1,324 1,377 1,432 1,400 1,600 101 41110 01 433.05 Miscellaneous Dues 120 120 120 300 200 101 41110 01 435.00 Books Pamphlets 0 44 46 100 100 101 41110 01 437.00 Conferences Seminars 6,000 101 41110 01 437.01 Registration Hotel -LMC Conf 1,243 677 515 2,000 1,000 101 41110 01 437.02 Registration Hotel -NLC Conf 3,697 4,379 4,363 4,000 4,000 101 41110 01 437.03 Miscellaneous Conferences 961 628 540 2,000 1,000 101 41110 01 439.00 Other Miscellaneous Charges 169 107 16 0 100 101 41110 01 598.00 Council Designated 59,330 15,330 36,815 165,300 100,000 252,400 Yearly Contingencies 101 41110 01 598.01 Library Site Expenditures 21,372 56,005 8,838 0 0 101 41110 01 598.02 Future Capital Expenditures 0 0 254,648 0 0 101 41110 01 598.03 Salary Benefit Contingency 0 0 0 0 152,400 Contingency for Negotiations 101 41110 01 599.00 Employee Recognition Costs 6,500 101 41110 01 599.01 Employee Recognition Costs 2,201 2,273 3,108 2,500 3,000 101 41110 01 599.02 Vending Machine Costs 3,513 3,914 3,607 3,000 3,500 Offset by Revenue from Machines PAGE TOTALS $192,553 $245,458 $431,383 $330,100 $391,800 DEPARTMENT TOTALS $192,553 $245,458 $431,383 $330,100 $391,800 Page Four 2010 BUDGET WORKSHEETS GENERAL FUND REVENUES July 15, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 34108.00 General Fund Admin Fees $25,000 $25,000 $25,000 $25,000 $25,000 101 34108.01 Fund 201 6,000 101 34108.02 Fund 202 2,500 101 34108.03 Fund 203 2,506 101 34108.04 Fund 206 2,500 101 34108.05 Fund 207 2,500 101 34108.06 Fund 605 1,000 101 34108.07 Fund 606 1,000 101 34108.08 Fund 607 1,000 101 34108.09 Fund 650 6,000 Admin Fees Breakdown Totals $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 Page One July 15, 2009 2010 BUDGET WORKSHEETS ADMINISTRATION 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41320 101.00 Salaries Benefits $381,348 $353,911 $369,001 $405,700 $407,800 Salary, Taxes, PERA Benefits 101 41320 102.00 Full -Time Overtime 1,159 20 1,712 2,000 2,000 101 41320 103.00 Part-Time Salaries Benefits 8,863 6,224 6,549 7,000 7,000 Temp Receptionist Coverage 101 41320 01 209.00 Other Office Supplies 455 165 129 500 500 Miscellaneous Purchases 101 41320 01 306.00 Personnel Testing Recruitment 0 0 0 0 0 101 41320 01 313.00 Temporary Service Fees 1,370 0 28,774 0 0 101 41320 01 319.00 Other Professional Services 1,706 180 0 1,500 0 101 41320 01 321.00 Telephone Costs 1,976 2,027 1,094 1,600 1,500 Administration Cell Phones 101 41320 01 331.00 Travel Expense 1,700 101 41320 01 331.01 NLC Conference 967 642 0 800 500 101 41320 01 331.02 ICMA Conference 382 395 873 800 800 101 41320 01 331.03 Miscellaneous Travel 362 396 40 400 400 101 41320 01 433.00 Dues Subscriptions 2,100 101 41320 01 433.01 MCMA Dues 187 194 191 200 250 101 41320 01 433.02 MAMA Dues 40 40 80 100 100 101 41320 01 433.03 MCFOA Dues 35 35 0 50 50 101 41320 01 433.04 Munici -Pals 165 25 25 150 100 101 41320 01 433.06 ICMA Dues 2,111 909 2,213 1,500 1,500 101 41320 01 433.07 APMP Dues 20 0 63 100 100 101 41320 01 435.00 Books Pamphlets 606 322 92 1,000 200 101 41320 01 437.00 Conferences Seminars 7,500 101 41320 01 437.01 Registration Hotel LMC 394 340 0 500 500 101 41320 01 437.02 Registration Hotel MCMA 498 1,132 1,033 1,200 1,300 101 41320 01 437.04 Staff (1) Each 0 70 75 200 200 101 41320 01 437.05 Miscellaneous Seminars 577 1,893 2,579 4,000 1,000 ULI Greening Initiatives 101 41320 01 437.06 Registration Hotel ICMA 1,422 3,389 2,415 2,500 2,500 101 41320 01 437.07 City Clerk Training 450 410 1,020 800 800 All MCFOA Events 101 41320 01 437.08 Registration Hotel NLC 1,890 1,257 0 2,500 1,200 101 41320 01 437.09 Miscellaneous Meetings 18 490 95 0 500 101 41320 01 439.00 Other Miscellaneous Charges 125 92 26 100 100 101 41320 01 580.00 Other Equipment Purchases 1,265 0 895 900 900 PAGE TOTALS 408,392 374,558 418,975 436,100 431,300 Page Two July 15, 2009 2010 BUDGET WORKSHEETS ADMINISTRATION 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 101 41320 41 433.00 Dues Subscriptions 60 60 60 200 101 41320 41 437.00 Conferences Seminars 0 0 55 400 101 41320 41 580.00 Other Equipment Purchases 3,350 5,616 988 2,900 PAGE TOTALS $98,541 $83,454 $68,550 $117,400 DEPARTMENT TOTALS $506,933 $458,013 $487,524 $553,500 1,000 $77,000 $508,300 Comments 101 41320 -01 -31 -xxx is for Human Resources 101 41320 31 305.00 Medical Dental Fees 115 2,000 Employee Drug Testing 101 41320 31 305.01 Pre Employment Physicals 0 0 846 500 500 101 41320 31 305.02 Employee Drug Testing 0 0 871 1,500 1,500 101 41320 31 315.00 Special Programs 2,000 101 41320 31 315.01 Employee Training 858 219 1,629 5,000 2,000 101 41320 31 315.02 HIPP Initiatives 2,419 663 1,427 2,000 0 Wellness Health Management 101 41320 31 315.03 EAP 0 717 699 1,000 0 Now Covered with Insurance 101 41320 31 319.00 Other Professional Services 5,400 101 41320 31 319.01 Labor Consultant (567) 0 600 1,000 1,000 101 41320 31 319.02 Labor Legal Issues 125 249 0 900 900 101 41320 31 319.04 COBRA Consultant 0 0 0 1,000 1,000 101 41320 31 319.05 Flex/VEBA Administrative Fees 2,855 2,279 2,325 3,300 2,500 101 41320 31 319.06 SWWC Co- Operative Dues 0 0 0 500 0 101 41320 31 331.00 Travel Expense 298 51 517 400 400 101 41320 31 341.00 Employment Advertising 11,672 975 2,504 6,000 3,000 Vacancies 101 41320 -01-41 -xxx is for Communications 101 41320 31 433.00 Dues Subscriptions 600 101 41320 31 433.01 "Future Use" 310 0 350 0 0 101 41320 31 433.02 IPMA Dues 145 145 145 300 200 101 41320 31 433.03 MPELRA Dues 150 0 400 400 400 101 41320 31 435.00 Books Pamphlets 402 84 315 300 300 Books Training Materials 101 41320 31 437.00 Conferences Seminars 600 101 41320 31 437.01 MPELRA State Conference 0 0 370 300 300 101 41320 31 437.02 Personnel Seminars 13 249 105 400 300 101 41320 31 437.03 Safety, Supervisor, Policy 0 0 0 300 0 101 41320 41 315.00 Special Programs 39,439 24,489 4,243 25,000 7,300 101 41320 41 315.01 General Marketing 0 0 0 0 5,000 Special Mailings 101 41320 41 315.02 Historical Monuments 0 0 0 0 2,300 101 41320 41 319.00 Other Professional Services 160 1,354 1,020 5,000 2,500 Consultants Cable TV 101 41320 41 328.00 Cable Supply Costs 382 178 198 3,000 500 Cable Supplies, Software 101 41320 41 329.00 Other Communication Costs 36,285 0 0 50,600 101 41320 41 329.01 Cable JPA Payment General City 0 37,929 41,462 43,000 43,000 101 41320 41 329.02 Video Streaming Council MeetingF 0 2,765 4,739 8,400 5,000 101 41320 41 329.03 Bulk E -Mail System 0 5,014 2,508 4,200 2,600 101 41320 41 331.00 Travel Expenses 185 304 174 200 300 200 MAGC 300 Technical Courses Page One July 15, 2009 2010 BUDGET WORKSHEETS ELECTIONS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 41410 01 103.00 Part -Time Salaries $19,339 $0 $30,001 $0 $24,000 Election Judges 101 41410 01 203.00 Printed Forms Paper 306 0 3,311 0 4,200 Ballots Programming 101 41410 01 208.00 Miscellaneous Supplies 489 (18) 617 0 700 101 41410 01 219.00 Other Operating Supplies 428 (25) 777 0 800 Food for Election Judges 101 41410 01 242.00 Minor Equipment 2,397 0 1,218 0 1,500 Booths Signs 101 41410 01 319.00 Other Professional Services 0 0 0 0 0 101 41410 01 321.00 Telephone Costs 352 57 86 100 0 101 41410 01 351.00 Legal Notices Publishing 0 0 0 0 0 Election Publications 101 41410 01 409.00 Other Contracted Repair Maint 0 0 2,300 101 41410 01 409.01 Maintenance for AutoMarks 1,225 1,300 1,300 Voting Machines 101 41410 01 409.02 Maintenance for Accuvotes 1,000 1,000 1,000 Voting Machines 101 41410 01 412.00 Building Rental 0 400 0 0 0 Possible Rent for Locations 101 41410 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 101 41410 01 580.00 Other Equipment Purchases 15,000 60,000 1,234 37,600 6,500 PAGE TOTALS $38,311 $60,415 $39,468 $40,000 $40,000 DEPARTMENT TOTALS $38,311 $60,415 $39,468 $40,000 $40,000 Page One July 15, 2009 2010 BUDGET WORKSHEETS FINANCE 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41520 101.00 Salaries Benefits $194,877 $206,431 $248,981 $290,500 $292,100 Salary, Taxes, PERA Benefits 101 41520 102.00 Full -Time Overtime 1,957 1,557 2,257 3,000 3,000 101 41520 103.00 Part-Time Salaries Benefits 20,023 31,448 35,363 42,600 44,900 101 41520 01 321.00 Telephone Costs 0 0 137 600 1,000 Cell Phone Allowances (2) 101 41520 01 331.00 Travel Expense 1,400 101 41520 01 331.01 Finance Director 472 894 1,015 1,200 1,200 National Convention Misc 101 41520 01 331.02 Staff 10 80 6 300 200 101 41520 01 391.00 P.C. Maintenance 48,100 101 41520 01 391.01 Civic Systems Applications Support 4,810 5,035 5,187 5,500 5,500 101 41520 01 391.02 Citrix Maintenance Renewal 0 1,240 959 1,400 1,400 101 41520 01 391.03 Incode Software Maintenance 6,082 6,329 6,642 7,000 7,000 101 41520 01 391.04 General Network Support 40,000 50,000 49,657 25,000 20,000 200 Hours of Support Time 101 41520 01 391.05 "Future Use" 0 0 0 0 0 101 41520 01 391.06 Fixed Asset Maint Contract 1,211 1,211 1,211 1,300 1,400 Price Increase 101 41520 01 391.07 Miscellaneous P.C. Repairs 1,290 2,133 1,957 2,800 2,800 101 41520 01 391.08 Anti -Virus Software Renewal 2,260 4,163 7,493 8,000 8,000 101 41520 01 391.09 File Server Software Maintenance 0 1,204 795 1,500 2,000 101 41520 01 392.00 P.C. Accessories Supplies 2,929 2,768 3,059 4,000 4,000 City System Supplies 101 41520 01 393.00 P.C. Hardware Purchases 1,218 1,447 13,679 2,500 2,500 101 41520 01 394.00 P.C. Software Purchases 15,000 101 41520 01 394.01 Annual Microsoft Office Payment 9,811 9,811 9,811 10,000 10,000 Annual Payment Thru 2011 101 41520 01 394.02 Miscellaneous S/W Purchases 0 0 160 5,000 5,000 Potential True -Up Costs 101 41520 01 409.00 Other Contracted R M 105 105 105 200 200 Non Computer Equipment 101 41520 01 433.00 Dues Subscriptions 900 101 41520 01 433.02 MnGFOA Finance Director 40 40 60 50 100 101 41520 01 433.03 MnGFOA Staff 200 200 360 250 450 101 41520 01 433.04 GFOA Finance Director Asst. 305 315 325 350 350 101 41520 01 433.05 Magazine Subscriptions 0 0 0 50 0 101 41520 01 435.00 Books Pamphlets 100 101 41520 01 435.01 Accounting Related Books 0 0 37 50 50 101 41520 01 435.02 Finance Related Books 0 0 0 50 50 101 41520 01 437.00 Conferences Seminars 3,300 101 41520 01 437.02 MnGFOA Annual Conf (F /D Ass't) 526 551 551 1,000 1,000 101 41520 01 437.03 GFOA National Conf (F /D) 0 1,270 1,111 1,500 1,300 101 41520 01 437.04 Staff Development 644 930 0 1,000 500 101 41520 01 437.05 Miscellaneous Seminars 791 370 230 1,000 500 101 41520 01 439.00 Other Miscellaneous Charges 134 553 155 200 200 Contingencies 101 41520 01 570.00 Office Equipment Furnishings 4,127 0 0 0 1,000 Office Chairs PAGE TOTALS $293,820 $330,105 $391,299 $417,900 $417,700 DEPARTMENT TOTALS $293,820 $330,105 $391,299 $417,900 $417,700 Page One July 15, 2009 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 NP Payroll Envelopes 101 41810 01 204.04 10 x 13 Envelopes 101 41810 01 204.05 10 x 15 Envelopes 101 41810 01 209.00 Other Office Supplies 101 41810 01 221.00 Equipment Parts 101 41810 01 242.00 Minor Equipment 101 41810 01 242.01 "Future Use" 101 41810 01 242.02 Credit Card Equipment 101 41810 01 301.00 101 41810 01 301.01 101 41810 01 301.02 101 41810 01 301.03 101 41810 01 301.04 101 41810 01 303.00 101 41810 01 304.00 101 41810 01 319.00 101 41810 01 319.01 101 41810 01 319.02 101 41810 01 319.03 101 41810 01 319.04 101 41810 01 319.05 101 41810 01 319.06 101 41810 01 319.10 101 41810 01 320.00 101 41810 01 320.01 101 41810 01 320.02 101 41810 01 320.03 101 41810 01 320.04 101 41810 01 321.00 101 41810 01 321.01 101 41810 01 321.02 101 41810 01 322.00 101 41810 01 339.00 101 41810 01 351.00 101 41810 01 351.01 101 41810 01 351.02 101 41810 01 351.03 101 41810 01 391.00 101 41810 01 392.00 101 41810 01 393.00 101 41810 01 433.00 101 41810 01 439.00 101 41810 01 450.00 2010 BUDGET WORKSHEETS GENERAL GOVERNMENT Auditing Accounting Services Audit General Consulting Fees Dakota County Assessment Fees Dak Cty Truth In Taxation Costs Printing of Budget Books Engineering Fees Legal Fees Other Professional Services City Code Update City Code Web Fees State Building Report (Springsteds) Continuing Disclosure Fees Annual User Fee Study Update Arbitrage /Rebate Calculations UMore Professional Services Credit Card Activity Fees Utilities' Fees Parks Recreation Fees Building Fees General Fees Telephone Costs General Phone Costs Domain Housing Postage Costs Other Transportation Expenses Legal Notices Publishing Costs for Public Notices Truth in Taxation Notices Budget Audit Publications P.C. Maintenance P.C. Software Purchases P.C. Hardware Purchases Dues Subscriptions Other Miscellaneous Charges Sales Tax on Purchases 101 41810 01 580.00 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 2009 2010 Object 2006 2007 2008 Adopted Detail Actual Actual Actual Budget Amount $12,000 8,200 7,998 7,535 9,000 0 Moved to "391.00" Below 8,490 14,282 9,741 15,000 12,000 4,513 4,911 7,321 5,000 8,000 O 774 743 800 800 1,528 0 1,602 1,500 1,700 280 284 2,100 1,500 1,500 564 1,991 362 1,200 1,000 Business Cards, etc. 5,500 695 1,542 2,054 1,600 2,000 1,310 2,464 1,327 1,600 1,600 O 0 0 500 700 1,095 0 1,155 600 1,200 O 0 0 200 0 18,859 16,068 17,228 18,000 O 0 0 500 O 0 0 350 0 467 0 0 250 300 82,000 61,167 64,204 72,635 75,000 75,000 Increased GASB Requirements 2,922 3,449 3,373 4,000 4,500 1,741 1,840 1,832 2,500 2,000 393 (205) 0 500 500 7,631 12,767 2,978 0 0 62,728 63,537 63,370 75,000 75,000 General City Legal Fees 34,300 567 540 1,853 2,300 1,500 O 250 250 1,500 300 8,390 8,760 3,870 11,000 9,500 2,000 2,000 2,000 4,000 4,000 O 14,225 4,675 11,000 8,000 9,450 11,900 3,750 15,000 10,000 O 0 3,005 1,000 1,000 2,711 141 980 1,127 1,000 1,400 510 4,158 4,236 6,000 6,000 187 1,080 3,347 4,000 12,000 228 245 593 1,000 600 2010 Proposed Budget Comments 13,000 19,000 General Office Supplies O City Hall Equipment Repairs 300 Fees Paid to Springsted Fees Paid to Springsted (Bonds) Fees Paid to Springsted Fees Paid to Springsted 20,000 Add'I Services at City Hall 40,100 62,916 70,048 73,941 70,000 40,000 O 0 60 100 100 17,783 19,569 20,029 20,000 24,000 801 33 813 800 800 Vehicle Licensing 4,400 3,824 2,850 2,643 4,000 3,000 All Departments 340 268 586 500 600 Billing from Dakota County 362 459 689 500 800 State Mandated Publications 1,500 0 0 5,000 10,000 Laserfishe Maintenance O 0 0 0 14,600 Laserfishe Software (Phase 3) O 0 0 0 2,200 Scanner Purchase 140 721 841 500 10,195 260 260 500 O 0 0 0 22,097 26,212 24,974 29,000 $326,722 $360,463 $348,898 $403,300 $326,722 $360,463 $348,898 $403,300 1,000 Newspapers 500 Direct Deposit Filing Fees/Flex O Sales Tax Audit 29,000 Office Machine Leases -All Bldgs. $387,700 $387,700 Page One July 15, 2009 Account 2010 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT Description All Salary Costs Inclusive of 101 41910 101.00 Salaries Benefits $763,813 $797,187 $832,464 $888,700 $898,800 Salary, Taxes, PERA Benefits 101 41910 102.00 Full -Time Overtime 1,758 435 0 2,000 1,000 101 41910 99 103.00 Part-Time Salaries Benefits 6,118 2,587 3,367 5,000 4,500 Planning Commission Members 101 41910 01 201.00 Office Accessories 9 0 0 400 0 Calendars, Planners, etc. 101 41910 01 202.00 Duplicating Copying 3,267 1,344 7,557 8,000 3,000 101 41910 01 203.00 Printed Forms Paper 1,111 3,712 4,100 4,000 4,000 Forms, Stickers, Tags, etc. 101 41910 01 205.00 Drafting Supplies 0 0 0 100 0 101 41910 01 208.00 Miscellaneous Supplies 15 21 53 200 0 101 41910 01 209.00 Other Office Supplies 331 295 77 600 600 Dictation Devices Tapes 101 41910 01 219.00 Other Operating Supplies 944 1,302 638 1,500 2,000 Chairs 101 41910 01 241.00 Small Tools 106 160 0 400 200 Inspectors' Tools 101 41910 01 302.00 Architects' Fees 0 275 0 0 0 101 41910 01 319.00 Other Professional Services 911 250 0 1,000 1,000 Consultant 101 41910 01 329.00 Other Communication Costs 1,710 3,128 2,443 2,800 3,600 Cell Phones Pagers (Add F/M) 101 41910 01 331.00 Travel Expense 1,279 540 472 700 600 101 41910 01 391.00 P.C. Maintenance 2,566 2,184 2,318 3,000 2,700 Permitworks Support 101 41910 01 392.00 P.C. Accessories Supplies 0 0 0 500 300 101 41910 01 393.00 P.C. Hardware Purchases 0 0 0 0 0 101 41910 01 433.00 Dues Subscriptions 3,100 101 41910 01 433.01 APA/AICP 1,187 1,006 1,131 1,500 1,300 101 41910 01 433.02 ICC 100 100 0 200 200 101 41910 01 433.03 AMBO 480 200 260 300 300 101 41910 01 433.04 10,000 Lakes 50 75 115 150 150 101 41910 01 433.05 "Future Use" 0 0 0 0 0 101 41910 01 433.06 Trade Magazines 50 42 0 200 200 101 41910 01 433.07 Planner's Journal 0 0 0 100 0 101 41910 01 433.08 Sensible Land Use Coalition 448 201 150 400 300 101 41910 01 433.09 AACEO /MAHCO 0 0 0 300 100 101 41910 01 433.10 Other Dues Subscriptions 33 533 562 50 550 101 41910 01 435.00 Books Pamphlets 134 910 557 700 700 Manuals, References, IBC Books 101 41910 01 437.00 Conferences Seminars 7,300 101 41910 01 437.01 State Bldg Official School 525 70 495 550 550 101 41910 01 437.02 Spring Fall Code Updates 295 60 370 300 400 101 41910 01 437.03 Building Inspector Training 255 184 952 1,000 1,000 101 41910 01 437.04 Computer Training 537 0 32 400 300 101 41910 01 437.05 Clerical Seminars 70 0 743 500 400 101 41910 01 437.06 Planning Seminars 1,521 1,783 5,094 1,500 1,800 101 41910 01 437.07 ISTS Training 830 429 0 500 500 101 41910 01 437.08 State Planning Conference (2) 245 0 104 1,000 1,000 101 41910 01 437.09 Planning Commissioner Training 25 0 305 250 250 101 41910 01 437.10 Gen'I Seminars 1,218 955 0 400 400 101 41910 01 437.11 Code Enforcement Training 293 0 239 400 700 101 41910 01 439.00 Other Miscellaneous Charges 0 0 90 400 400 Contingencies PAGE TOTALS DEPARTMENT TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $792,234 $819,969 $864,689 $930,000 $933,800 $792,234 $819,969 $864,689 $930,000 $933,800 Comments Page One July 15, 2009 2010 BUDGET WORKSHEETS POLICE All Salary Costs Inclusive of 101 42110 101.00 Salaries Benefits $1,894,055 $1,995,799 $2,144,449 $2,334,500 $2,307,100 Salary, Taxes, PERA Benefits 101 42110 102.00 Full -Time Overtime 76,321 72,650 112,323 65,000 65,000 101 42110 102.01 Regular Overtime Hours 44,000 101 42110 102.02 Contracted O/T 21,000 101 42110 103.00 Part-Time Salaries Benefits 105,800 101 42110 22 103.00 Part-Time Receptionist (2) 0 0 0 0 49,800 2 P/T Receptionists 44 HrsMlk 101 42110 23 103.00 Part-Time Secretary 8,434 10,006 9,618 22,200 20,000 P/T Secretary 14 Hours/Wk 101 42110 99 103.00 Part-Time CSO's 32,242 28,501 27,204 38,700 36,000 CSO's Up To 50 Hours/Wk 101 42110 01 202.00 Duplicating Copying 0 0 25 0 0 101 42110 01 203.00 Printed Forms Paper 718 1,630 747 800 800 Evidence Logs, Animal Lic, etc. 101 42110 01 204.00 Envelopes Letterheads 93 159 0 200 200 Business Cards 101 42110 01 207.00 Training Instructional Supplies 5,100 101 42110 01 207.01 Practice Ammunition 2,098 3,656 5,345 3,000 5,000 101 42110 01 207.02 Service Ammunition 0 515 79 400 0 101 42110 01 207.03 Other Supplies 64 0 229 100 100 101 42110 01 208.00 Miscellaneous Supplies 0 Donated Forfeited Funds 101 42110 01 208.01 DARE Donations 2,406 2,659 2,657 0 0 101 42110 01 208.02 Equipment Donations/Forfeitures 8,313 7,781 7,842 0 0 101 42110 01 209.00 Other Office Supplies 850 1,035 591 1,000 1,000 Video, CD's Miscellaneous 101 42110 01 211.00 Cleaning Supplies 500 101 42110 01 211.01 Blanket Cleaning 0 0 0 0 0 101 42110 01 211.02 Squad Interior Cleaning 608 509 0 500 500 101 42110 01 217.00 Clothing Allowance 4,000 101 42110 01 217.01 CSO's 1,291 331 967 1,000 1,000 101 42110 01 217.02 Reserves 1,612 1,127 1,965 2,000 2,000 101 42110 01 217.03 Other Supplies 923 1,590 0 1,000 1,000 101 42110 01 219.00 Other Operating Supplies 1,905 30 13 2,800 101 42110 01 219.01 Evidence Bags, Drug Kits, Misc. 1,999 843 2,000 2,000 101 42110 01 219.02 Accurint Database Services 405 380 400 800 101 42110 01 221.00 Equipment Parts 2,786 3,919 1,775 2,500 2,500 Squad Emergency Equip Repairs 101 42110 01 241.00 Small Tools 2,000 Crime Scene KR Supplies 101 42110 01 241.01 Evidence Processing Equipment 515 145 800 750 750 101 42110 01 241.02 Camera and Video Supplies 1,017 758 206 500 500 101 42110 01 241.03 Other Supplies 574 417 970 750 750 Digital Recorders 101 42110 01 242.00 Minor Equipment 861 2,000 101 42110 01 242.01 Less Lethal Tactical Equipment 538 760 943 1,500 1,500 Training Supplies, Taser Batteries 101 42110 01 242.02 MAAG Equipment 849 383 499 500 500 101 42110 01 304.00 Legal Fees 54,996 55,010 54,996 56,000 56,700 Prosecution 101 42110 01 305.00 Medical Dental Fees 13,000 101 42110 01 305.01 Employee Drug Testing 736 1,074 809 1,500 1,000 101 42110 01 305.02 Seized Narcotic Testing 224 340 663 500 12,000 Sup. Ct. Decision Blood Draws 101 42110 01 306.00 Personnel Testing Recruitment 4,254 825 875 1,000 1,000 Medical Psychological 101 42110 01 313.00 Temporary Service Fees 0 715 464 1,200 1,200 Interpreter Services 101 42110 01 315.00 Special Programs 0 11,994 0 0 0 101 42110 01 316.00 Animal Care Services 12,000 101 42110 01 316.01 Impound Care Fees 10,224 9,918 10,943 12,000 12,000 101 42110 01 316.02 "Future Use" 0 0 0 0 0 101 42110 01 319.00 Other Professional Services 297,000 101 42110 01 319.01 Dispatch Services Operations 90,240 232,230 232,800 304,200 297,000 101 42110 01 319.02 "Future Use" 4,611 19,608 24,566 0 0 101 42110 01 321.00 Telephone Costs 4,800 101 42110 01 321.01 Cell Phones 4,724 4,826 4,371 4,800 4,800 101 42110 01 321.02 Pagers 0 0 0 0 0 101 42110 01 321.03 LOGIS Communications Line 444 444 74 500 0 Not Applicable Fiber Now Used 101 42110 01 323.00 Radio Units 12,000 101 42110 01 323.01 Radios ($380 per Unit) 911 221 6,944 13,500 11,500 800 MHz Subscriber Fees 101 42110 01 323.02 Radars 61 220 430 500 500 Radar LIDAR Repairs 101 42110 01 331.00 Travel Expense 3,700 101 42110 01 331.01 MN Chiefs Spring Conference 116 302 0 500 500 101 42110 01 331.02 IACP Conference 0 1,639 1,865 1,500 1,500 101 42110 01 331.03 Outstate Investigations Conf. 315 120 693 500 500 101 42110 01 331.04 MAAG Conference 436 441 624 400 400 101 42110 01 331.05 CAN -AM Narcotic Conference 430 258 0 400 400 101 42110 01 331.06 Juvenile Officers Conference 243 610 325 300 300 101 42110 01 331.07 Meeting Reimbursements 74 160 190 100 100 Account# Description Actual Actual Actual Budget Amount Budget PAGE TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed 2,212,108 2,477,720 2,662,125 2,878,700 2,900,200 Comments Page Two July 15, 2009 2010 BUDGET WORKSHEETS POLICE 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget DEPARTMENT TOTALS $2,314,702 $2,565,325 $2,752,086 $2,974,200 $2,995,900 Comments 101 42110 01 333.00 Freight Express Expenses 202 138 141 200 200 Repairs 101 42110 01 394.00 P.C. Software Purchases 12,500 101 42110 01 394.01 Automated Pawn System 432 432 240 500 500 101 42110 01 394.02 Pictometry 0 1,504 1,388 2,000 1,500 101 42110 01 394.03 CJIIN System 10,474 10,474 10,474 10,500 10,500 101 42110 01 396.00 Computer Maintenance 65,600 101 42110 01 396.01 Records Management 41,623 31,069 34,377 32,500 32,500 CAD Included in DCC in 2007 101 42110 01 396.02 CJDN Connection Charges 3,443 2,520 2,981 2,800 2,800 101 42110 01 396.03 MCD Connection Charges 1,573 1,384 1,845 2,000 2,000 101 42110 01 396.04 MCD Maintenance Cellular 22,391 17,753 15,115 20,500 20,500 101 42110 01 396.05 LOGIS Annual Fees 7,844 6,942 7,275 7,800 7,800 101 42110 01 433.00 Dues Subscriptions 4,700 101 42110 01 433.01 Mutual Aid Assistance Group -MAAG 2,100 2,100 3,000 3,000 3,200 101 42110 01 433.02 IACP Chiefs 100 100 120 100 100 101 42110 01 433.03 MN Chiefs of Police 245 165 165 250 175 101 42110 01 433.04 Dakota Cty Chiefs of Police 50 35 35 50 50 101 42110 01 433.05 Wakota CAER 0 20 0 20 20 101 42110 01 433.06 Metro Emergency Managers 0 0 0 0 60 101 42110 01 433.07 MN Sex Crimes Investigators 18 18 0 20 20 101 42110 01 433.08 Tri- County Investigators 60 60 0 60 60 101 42110 01 433.09 MN Crime Prevention Association 40 55 90 55 55 101 42110 01 433.10 P.O.S.T. Licenses 1,080 810 360 800 800 101 42110 01 433.11 FBI Nat'l Academy Association 0 0 0 60 0 101 42110 01 433.12 Miscellaneous 40 55 165 85 160 101 42110 01 435.00 Books Pamphlets 998 1,118 943 500 1,000 Crime Prevention Materials 101 42110 01 436.00 Towing Charges 184 0 0 200 200 Disabled Squads 101 42110 01 437.00 Conferences Seminars 11,000 101 42110 01 437.01 Firearms Training 1,757 2,071 5,931 2,000 2,000 Range Rental 101 42110 01 437.02 Chiefs Spring Conference 575 425 0 500 500 101 42110 01437.03 Investigations 1,183 2,020 1,920 1,500 1,500 101 42110 01 437.04 IACP Conference 0 275 275 250 250 101 42110 01 437.05 Supervision 407 665 755 750 750 101 42110 01 437.06 Use of Force 21 0 100 600 600 101 42110 01 437.07 Emergency Driving 1,365 2,100 1,120 1,400 1,400 101 42110 01 437.08 First Aid 0 700 0 1,250 1,250 101 42110 01 437.09 Narcotic Enforcement 200 307 0 500 500 101 42110 01 437.10 Tactical 480 690 0 750 750 101 42110 01 437.11 Support Services 65 40 245 250 250 101 42110 01 437.12 Patrol 1,820 1,050 618 1,250 1,250 101 42110 01 439.00 Other Miscellaneous Charges 643 510 282 500 500 Refreshments for Meetings Compliance Checks 101 42110 01 580.00 Other Equipment Purchases 1,181 0 0 0 0 PAGE TOTALS $102,594 $87,605 $89,961 $95,500 $95,700 Page One 2010 BUDGET WORKSHEETS FIRE July 15, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 42210 103.00 Salaries Benefits $100,280 $96,884 $75,329 $55,000 $55,000 Salary, Taxes, PERA Benefits 101 42210 103.01 Salaries 30,000 101 42210 103.02 Training Pay /Stipends 4,000 101 42210 103.03 Call Pay /Stipends 20,900 101 42210 103.04 Class Pay /Stipends 100 101 42210 103.05 P/T Fire Marshal 0 Position Eliminated in 2008 101 42210 01 202.00 Duplicating Copying 101 42210 01 202.01 Copy Toner 355 107 0 50 50 101 42210 01 202.02 Computer Printers 0 0 0 50 50 101 42210 01 204.00 Envelopes Letterhead 101 42210 01 204.01 Envelopes 0 0 0 25 25 101 42210 01 204.02 Letterhead 0 0 0 25 25 101 42210 01 204.03 Forms 134 0 0 50 50 101 42210 01 208.00 Miscellaneous Supplies 101 42210 01 208.01 Supplies, Computer Support 699 851 1,040 0 0 101 42210 01 208.02 Film Developing 183 217 101 0 0 101 42210 01 208.03 Memberships 35 35 0 0 0 101 42210 01 208.04 Code Books 0 82 140 0 0 101 42210 01 208.05 Training 1,171 905 700 0 0 101 42210 01 211.00 Cleaning Supplies 101 42210 01 211.01 Soaps 53 1,217 140 550 550 101 42210 01 211.02 Chamois, Towels, etc. 33 116 0 50 50 101 42210 01 211.03 Sponges, etc. 0 39 0 50 50 101 42210 01 211.04 SCBA Cleaner 0 75 0 150 150 101 42210 01 218.00 Fire Department Clothing 67 45 0 400 101 42210 01 219.00 Other Operating Supplies 101 42210 01 219.01 Gloves 424 659 314 1,000 1,000 101 42210 01 219.02 Bandages 505 0 0 100 100 101 42210 01 219.03 Equipment 744 751 937 500 1,000 101 42210 01 219.04 Tyvek Suits 0 0 0 100 100 101 42210 01 219.05 Consummable Medical 1,826 2,105 891 2,200 2,200 101 42210 01 219.06 Oxygen 122 137 146 400 400 101 42210 01 229.00 Other Maintenance Supplies 101 42210 01 229.01 Aerial- Pumpers- Tanker 123 0 45 800 200 101 42210 01 229.02 Pickup Trucks 0 13 0 100 100 101 42210 01 229.03 Rescue Other 300 0 650 100 300 101 42210 01 229.04 Vehicle Modifications 3,148 0 72 100 100 101 42210 01 230.00 Equipment Repair Materials 101 42210 01 230.01 Light Bars 0 0 0 100 100 101 42210 01 230.02 Smoke Machines 0 0 0 250 250 101 42210 01 230.03 Lanterns Miscellaneous 0 478 61 250 250 101 42210 01 230.04 Small Tool Repairs 285 700 543 600 600 101 42210 01 230.05 Qpticom 0 0 0 300 300 101 42210 01 230.06 Station 504 307 1,624 300 600 101 42210 01 241.00 Small Tools 101 42210 01 241.01 Axes, Bars Other 253 245 110 150 150 101 42210 01 241.02 Grass Fire 0 195 0 250 250 101 42210 01 241.03 Hand Tools 1,803 998 378 300 300 PAGE TOTALS 124,591 123,792 97,679 79,100 80,200 100 100 800 0 Supplies for Fire Marshal 400 5 Uniforms $80 Each 4,800 Medical Supplies 700 2,100 700 101 42210 01 305.00 Medical Dental Fees 2,734 2,805 2,850 3,500 3,500 Annual Medical Tests 101 42210 01 306.00 Personnel Testing Recruitment 2,300 101 42210 01 306.01 New Physicals (5) 1,540 1,955 2,925 1,325 1,325 101 42210 01 306.02 Hepatitis Shots (5) 293 651 151 625 625 101 42210 01 306.03 Background Checks (5) 261 29 121 125 125 101 42210 01 306.04 Drug Testing (5) 0 0 0 625 225 101 42210 01 308.00 Instructors' Fees 9,700 101 42210 01 308.01 Fire Fighter 1 (5) 0 974 1,198 1,500 1,500 101 42210 01 308.02 Fire Fighter 1 Certificates (5 5) 0 645 120 600 600 101 42210 01 308.03 Fire Fighter Re- Certificates (6) 90 0 195 90 200 101 42210 01 308.04 First Responder (5) 0 2,210 0 1,200 1,200 101 42210 01 308.05 First Responder Refresher (1/2) 1,820 715 1,200 1,400 1,400 101 42210 01 308.06 Outside Schools ($/2) 4,806 6,647 5,651 2,560 3,550 101 42210 01 308.07 Haz -Mat Training (5) 0 0 0 1,250 1,250 101 42210 01 308.08 Apparatus Re- Certificates 0 0 45 0 0 Page Two July 15, 2009 Account 2010 BUDGET WORKSHEETS FIRE Description 101 42210 01 310.00 Testing Services 3,700 101 42210 01 310.01 Aerial 0 821 0 1,000 1,000 101 42210 01 310.02 Ladders 0 0 0 500 500 101 42210 01 310.03 Pumpers (3) (Next 2012) 750 0 855 0 900 101 42210 01 310.04 SCBA Hydro Testing (Next 2013) 0 0 0 0 1,300 101 42210 01 313.00 Temporary Service Fees 7,800 101 42210 01 313.01 SCBA Contract Repairs 777 592 557 2,300 2,300 101 42210 01 313.02 SCBA Flow Test 1,270 2,922 269 600 2,000 101 42210 01 313.04 Security Contract 603 380 617 600 800 101 42210 01 313.05 SOT Joint Powers 1,598 2,301 2,724 2,700 2,700 101 42210 01 314.00 Annual Fire Relief Contribution 143,300 147,600 152,000 156,500 161,200 101 42210 01 319.00 Other Professional Services 1,300 Fire Prevention Education 101 42210 01 319.01 School Literature 0 0 0 200 200 101 42210 01 319.02 Door Prizes 38 0 212 200 200 101 42210 01 319.03 Fire Prevention Week Promos 1,764 525 538 500 500 101 42210 01 319.04 Food at Open House 247 511 402 200 200 101 42210 01 319.05 Summer Park Education 248 44 66 100 100 101 42210 01 319.06 National Night Out 78 0 0 100 100 101 42210 01 321.00 Telephone Costs 1,400 101 42210 01 321.01 Fire Dept. Cell Phones 396 599 1,103 1,300 1,300 101 42210 01 321.02 Fire Marshal Cell Phone 56 124 250 0 0 101 42210 01 321.03 "Future Use" 167 140 334 0 0 101 42210 01 321.04 Numeric Pagers 74 78 92 100 100 101 42210 01 322.00 Postage Costs 10 0 0 100 100 UPS Costs 101 42210 01 329.00 Other Communication Costs 16,800 101 42210 01 329.01 Base Repairs 50 0 0 100 100 101 42210 01 329.02 Pager Repairs 361 808 937 900 1,500 101 42210 01 329.03 Hand Held Repairs 179 330 0 100 100 101 42210 01 329.04 Mobile Repairs 211 125 0 100 100 101 42210 01 329.05 800 MHZ User Fee 0 0 7,604 18,000 15,000 101 42210 01 331.00 Travel Expense 3,900 101 42210 01 331.01 Minnesota Chief's Conference 2,202 1,632 1,484 2,000 2,000 101 42210 01 331.02 Fite Department Association 979 1,736 2,159 1,600 1,600 101 42210 01 331.03 Outside Schools 893 489 0 1,300 300 101 42210 01 333.00 Freight Express Expense 22 0 10 0 0 101 42210 01 433.00 Dues Subscriptions 101 42210 01 433.01 Capital City 50 50 50 50 50 101 42210 01 433.02 VFBA Insurance 544 324 354 550 550 101 42210 01 433.03 State Fire 300 165 360 300 300 101 42210 01 433.04 State Chiefs 200 165 290 250 250 101 42210 01 433.05 DCFC 0 100 75 60 60 101 42210 01 433.06 WAKOTA Mutual Aid 50 0 50 50 50 101 42210 01 433.07 Purchasing Consortium 35 35 35 40 40 101 42210 01 433.08 NFPA 0 0 150 0 0 101 42210 01 433.09 "Future Use" 0 0 0 0 0 101 42210 01 437.00 Conferences Seminars 101 42210 01 437.01 State Fire Conference 510 0 0 400 400 101 42210 01 437.02 State Chief's Conference 840 450 0 500 500 101 42210 01 439.00 Other Miscellaneous Charges 101 42210 01 439.01 Food Coffee 376 50 59 150 150 101 42210 01 439.02 Extinguisher 73 860 0 300 300 101 42210 01 439.03 Plaques 0 0 60 40 40 101 42210 01 439.04 Paint 0 0 0 70 70 101 42210 01 439.05 Station Needs 2,673 2,496 1,017 1,040 1,040 101 42210 01 580.00 Other Equipment Purchases 101 42210 01 580.01 Bunker Gear (7) 4,409 11,627 16,282 9,000 15,000 101 42210 01 580.02 Pagers (6) 1,541 3,204 0 3,000 3,600 101 42210 01 580.03 Hose Replacement 0 4,694 0 1,000 1,000 101 42210 01 580.04 Replace Damaged Items 11,241 7,141 2,336 2,000 2,000 101 42210 01 581.00 Other Equipment Purchases 7,356 0 0 0 101 42210 01 586.00 Computer Equipment Purchase 0 0 7,069 0 PAGE TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $186,473 $193,116 $200,398 $209,900 $221,600 DEPARTMENT TOTALS $311,063 $316,909 $298,077 $289,000 $301,800 Comments 1,300 900 1,600 21,600 0 0 Replacements Page One July 15, 2009 Account Description 101 41940 101.00 101 41940 79 101.01 101 41940 102.00 101 41940 01 208.00 101 41940 01 223.00 101 41940 01 225.00 101 41940 01 241.00 101 41940 01 242.00 101 41940 01 302.00 101 41940 01 318.00 101 41940 01 319.00 101 41940 01 319.01 101 41940 01 319.02 101 41940 01 319.03 101 41940 01 319.04 101 41940 01 319.05 101 41940 01 319.06 101 41940 01 319.07 101 41940 01 319.08 101 41940 01 319.09 101 41940 01 319.10 101 41940 01 319.11 101 41940 01 381.00 101 41940 01 382.00 101 41940 01 383.00 101 41940 01 384.00 101 41940 01 384.01 101 41940 01 384.02 101 41940 01 389.00 101 41940 01 401.00 101 41940 01 401.01 101 41940 01 401.02 101 41940 01 401.03 101 41940 01 401.04 101 41940 01 415.00 101 41940 01 439.00 101 41940 01 601.00 101 41940 01 611.00 101 41940 01 621.00 2010 BUDGET WORKSHEETS GOVERNMENT BUILDINGS Salaries Benefits Maintenance Staff Full -Time Overtime Miscellaneous Supplies Budding Repair Supplies Landscaping Materials Small Tools Minor Equipment Architects' Fees Contract Engineer Other Professional Services Elevator Maintenance Heating /Cooling Maint Contract Annual Boiler Inspections Maint. Pest Control Fire Extinguishers Fire Suppression System Check Janitorial Service -Fire Stations Janitorial Service -P.W. Building Janitorial Service -City Hall Floor Mats Monthly Charges Other Janitorial Services Electric Utilities Water Utilities Gas Utilities Refuse Disposal General Buildings Parks Recycling /Cleanup Other Utility Services Contracted Building Repairs Electrical Repairs Siren Replacement Program Miscellaneous Repairs Roof Inspection Other Equipment Rental Other Miscellaneous Charges 101 41940 01 530.00 Improvements Other Than Buildings Bond Principal Bond Interest Bond Paying Agent Fees PAGE TOTALS DEPARTMENT TOTALS 2006 2007 2008 Actual Actual Actual 2009 Adopted Budget 48,114 49,402 10,521 0 3,137 2,689 0 0 13,558 20,513 16,717 20,000 7,053 5,924 9,231 9,000 81 169 466 500 O 355 9 200 719 2,804 2,066 2,000 0 3,000 0 0 2,250 750 1,500 3,000 2010 Object 2010 Detail Proposed Amount Budget 1,277 2,702 1,498 1,500 1,500 2,469 1,107 7,048 8,000 7,000 Includes all City Facilities 30 659 476 1,500 1,500 1,598 2,036 2,146 2,000 2,500 1,209 1,805 2,308 2,000 3,000 2,613 2,825 3,044 4,000 3,500 3,515 10,633 10,452 10,500 10,500 10,288 13,266 10,555 11,500 11,500 O 0 25,826 25,000 25,000 O 0 0 3,800 3,800 O 0 0 0 7,000 Waxing Floors, Carpet Cleaning 72,810 62,795 64,821 75,000 75,000 O 40 0 0 0 51,360 63,317 80,087 80,000 80,000 30,000 11,505 13,399 14,169 20,000 16,000 11,157 12,381 12,858 15,000 14,000 3,694 3,810 3,528 0 800 167 3,339 4,070 6,112 5,000 673 10,018 10,000 10,000 53,025 40,332 22,493 25,000 O 0 0 500 O 307 0 1,000 O 0 0 1,000 O 10,000 142,196 85,000 41,158 43,579 46,000 48,500 41,043 37,205 33,186 30,000 775 0 0 1,500 $389,249 $422,060 $539,315 $502,000 5,000 10,000 25,000 0 40,000 $490,200 $389,249 $422,060 $539,315 $502,000 $490,200 Comments All Salary Costs Inclusive of $0 Salary, Taxes, PERA Benefits 0 Increase to "319.09" Below 0 17,000 Cleaning Supplies, Towels, etc. 9,200 2,500 Trees Shrubs 200 Hand Tools, Bits, Blades, etc. 2,000 Equipment Replacement 0 Estimates 1,500 Contracted Engineer for City (5 76,800 2 Cleanup Days per Year 0 Moved to "319.10" Above 1,000 Scaffolding, Cleaners 5,000 Energy Efficiency Improvements 70,000 50,900 MSABC Payment (2/1) 29,100 MSABC Payments (2/1 8/1) 0 Page One July 15, 2009 Account 101 43100 101.00 101 43100 77 101.00 101 43100 79 101.00 101 43100 102.00 101 43100 01 211.00 101 43100 01 212.00 101 43100 01 213.00 101 43100 01 215.00 101 43100 01 221.00 101 43100 01 222.00 101 43100 01 241.00 101 43100 01 242.00 101 43100 01 318.00 101 43100 01 321.00 101 43100 01 323.00 101 43100 01 384.00 101 43100 01 394.00 101 43100 01 404.00 101 43100 01 416.00 101 43100 01 417.00 101 43100 01 433.00 101 43100 01 435.00 101 43100 01 437.00 2010 BUDGET WORKSHEETS FLEET MAINTENANCE 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Description Actual Actual Actual Budget Amount Budget Salaries Benefits Administrative Maintenance Full -Time Overtime Cleaning Supplies Motor Fuels Lubricants Additives Shop Materials Equipment Parts Tires Small Tools Minor Equipment Contract Engineer Telephone Costs Radio Units Refuse Disposal P.C. Software Purchases Contracted Math Equip Repairs Machinery Rental Uniforms Rental Dues Subscriptions Books Pamphlets Conferences Seminars PAGE TOTALS DEPARTMENT TOTALS Estimated Fuel Cost for 2010 Unleaded $2.80 /gallon x 40,000 gallons Diesel $3.00 /gallon x 27,000 gallons unleaded tax diesel tax Total for motor fuels $440,997 $466,276 $524,657 $576,800 $606,600 $440,997 $466,276 $524,657 $576,800 $606,600 $112,000 81,000 10,000 2,300 $205,300 Comments All Salary Costs Inclusive of $152,900 Salary, Taxes, PERA Benefits 10,123 10,506 10,954 11,300 11,500 128,087 131,936 138,537 143,400 141,400 424 1,185 1,786 7,500 5,000 1,377 1,082 1,022 1,000 1,000 Shop Vehicles 135,325 167,365 173,858 230,000 210,000 Price Estimate (See Below) 5,035 9,188 8,712 5,500 10,000 Price Increase, Fleet Expansion 17,092 14,649 18,535 17,000 17,000 78,242 90,275 115,712 95,000 120,000 Fleet Expansion 6,841 9,976 15,718 12,000 40,000 Large Equipment Replacements 5,102 3,898 4,444 4,000 4,000 1,973 2,633 6,246 6,000 4,000 4,500 1,500 3,000 4,500 3,000 Contracted Engineer for City(10 0 0 0 0 0 2,257 850 284 2,000 2,000 Repair /Replace Units 30 154 158 500 300 Shop Hazardous Waste 32 0 0 500 500 General Software Support 43,038 20,524 25,340 35,000 35,000 0 0 0 1,000 1,000 145 139 226 0 0 0 0 75 100 100 DOT Certification 376 51 51 0 0 999 364 0 500 800 $600 CarteGraph; $200 -Misc. Page One July 15, 2009 Account 2010 BUDGET WORKSHEETS STREET MAINTENANCE Description PAGE TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget All Salary Costs Inclusive of 101 43121 101.00 Salaries Benefits $487,900 Salary, Taxes, PERA Benefits 101 43121 77 101.00 Administrative 30,368 31,519 32,861 33,900 34,300 101 43121 78 101.00 TechnicaVClerical 53,684 57,671 60,134 62,900 63,800 101 43121 79 101.00 Maintenance 342,342 360,684 376,362 388,100 389,800 101 43121 102.00 Full -Time Overtime 5,164 10,601 11,817 16,000 14,000 Maintenance 101 43121 99 103.00 Part-Time Salaries Benefits 15,146 19,167 25,630 25,000 25,000 101 43121 01 201.00 Office Accessories 0 151 0 100 100 101 43121 01 203.00 Printed Forms Paper 300 101 43121 01 203.01 R/W Permit Inspection Forms 0 0 0 200 200 101 43121 01 203.02 Work Orders 27 0 0 100 100 Work Orders Through CarteGraph 101 43121 01 203.03 City Specification Books 0 0 0 0 0 101 43121 01 205.00 Drafting Supplies 3,000 101 43121 01 205.01 Paper for Plan Reproductions 534 547 856 900 2,000 Plotter (Ink and Paper) 101 43121 01 205.02 Off -Site Reproductions 367 95 88 450 450 101 43121 01 205.03 Film Developing 0 0 0 200 0 101 43121 01 205.04 Miscellaneous Tools 0 0 0 550 550 Inspection Equipment 101 43121 01 209.00 Other Office Supplies 205 144 492 500 500 101 43121 01 216.00 Chemical Chemical Products 37,122 65,339 79,449 80,000 90,000 Road Salt, Price Increase -See P.2 101 43121 01 224.00 Street Maintenance Materials 2,500 101 43121 01 224.01 Paint 312 543 105 500 500 101 43121 01 224.02 Mail Boxes 134 662 465 500 500 101 43121 01 224.03 Light Bulbs/Lenses 468 684 613 1,500 1,500 Replace with LED Bulbs 101 43121 01 225.00 Landscaping Materials 8,200 101 43121 01 225.01 Sod 19 37 1,917 1,500 1,500 101 43121 01 225.02 Seed 577 0 298 200 200 101 43121 01 225.03 Black Dirt 312 195 820 1,000 1,000 101 43121 01 225.04 Trees 73 0 490 500 500 101 43121 01 225.05 Hanging Baskets 0 0 0 7,000 5,000 101 43121 01 226.00 Sign Repair Materials 13,133 9,146 14,507 15,000 15,000 101 43121 01 231.00 Bituminous Patching Materials 29,963 36,565 28,566 40,000 40,000 101 43121 01 232.00 Crushed Rock 23,805 30,077 23,550 30,000 30,000 101 43121 01 233.00 Dust Control Materials 27,600 29,368 21,101 35,000 35,000 101 43121 01 234.00 De -Icing Sand Rock 2,649 2,476 0 1,200 2,000 Gravel Road Ice Control -See P.2 101 43121 01 235.00 Shouldering Gravel 0 2,465 1,107 3,000 3,000 101 43121 01 241.00 Small Tools 1,499 1,603 1,248 2,000 2,000 Shovels, Brooms, etc. 101 43121 01 242.00 Minor Equipment 3,223 2,835 902 4,000 4,000 Safety Equipment Power Tools 101 43121 01 303.00 Engineering Fees 76,428 37,886 22,578 8,500 8,500 General Non Project Related 101 43121 01 304.00 Legal Fees 493 1,063 440 2,000 1,000 Appeals of Closed Projects 101 43121 01 305.00 Medical Dental Fees 242 0 0 600 600 Employment Physicals 101 43121 01 310.00 Testing Services 0 0 0 1,200 1,200 101 43121 01 313.01 Temporary Service Fees 2,723 681 0 0 0 101 43121 01 318.00 Contract Engineer 9,000 3,000 6,000 9,000 6,000 Contracted Engineer for City(20 101 43121 01 319.00 Other Professional Services 658 1,727 0 500 500 Random Drug Testing to Admin 101 43121 01 321.00 Telephone Costs 3,501 2,442 2,484 3,000 3,000 Includes Wireless Technology 101 43121 01 323.00 Radio Units 0 0 0 0 1,300 800 MHZ Monthly Charges 101 43121 01 324.00 Messenger Services 0 0 29 100 100 101 43121 01 331.00 Travel Expense 399 512 35 500 500 101 43121 01 341.00 Employment Advertising 0 0 0 0 0 101 43121 01 381.00 Electric Utilities 171,000 101 43121 01 381.01 Street Lights 138,852 142,407 149,837 150,000 165,000 Price Increases, More Lights 101 43121 01 381.02 Signal Lights Sirens 4,203 5,613 4,940 10,000 6,000 101 43121 01 384.00 Refuse Disposal 2,000 101 43121 01 384.01 Hazardous Waste Disposal 0 0 121 1,000 500 101 43121 01 384.02 Roadside Garbage 917 894 326 1,200 900 101 43121 01 384.03 Tree Disposal 0 173 0 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 1,000 0 101 43121 01 391.03 Pavement Management Syst Sup 0 1,729 21,888 10,000 10,000 101 43121 01 391.04 R -O -W Permit On -Line Service 0 0 4,360 4,800 4,800 101 43121 01 392.00 P.C. Accessories Supplies 0 0 0 0 0 101 43121 01 394.00 P.C. Software Purchases 314 1,843 901 5,000 5,000 CarteGraph Maintenance 826,457 862,542 897,318 960,800 978,000 Comments Page Two July 15, 2009 2010 BUDGET WORKSHEETS STREET MAINTENANCE 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 43121 01402.00 Parking Lot Seal Coating 0 0 16,871 10,000 11,500 101 43121 01 403.00 Contracted Repair Maintenance 29,000 101 43121 01 403.01 Street Lights 25,946 26,390 31,440 28,500 28,500 Repair 9 Street Lights (Annually) 101 43121 01 403.02 Signal Lights 1,891 0 792 500 500 101 43121 01 403.03 Light Replacements 0 0 0 5,000 0 101 43121 01 405.00 Street Striping 17,958 20,808 25,523 25,000 30,000 Price Increase, Added Bonaire 101 43121 01 406.00 Street Sweeping 4,557 2,175 0 0 0 101 43121 01408.00 Street Crack Sealing 31,434 33,091 42,960 45,000 45,000 101 43121 01409.00 Tree Trimming 3,633 4,649 8,362 10,000 10,000 101 43121 01 410.00 Concrete Sidewalk/Curb Repairs 133,000 101 43121 01 410.01 General Repairs 3,706 7,843 9,436 8,000 8,000 101 43121 01 410.02 Pedestrian Improvements 126,465 125,268 123,457 125,000 125,000 101 43121 01 411.00 Contracted Snow Removal 31,500 101 43121 01 411.01 Community Center 4,008 13,060 9,512 15,000 12,000 101 43121 01411.02 St. Joseph's 4,820 9,241 8,814 8,000 9,500 101 43121 01 411.03 Genz -Ryan 0 2,888 5,778 4,000 0 101 43121 01411.04 Dakota County Library 0 0 0 8,000 10,000 101 43121 01 415.00 Equipment Rental 15,364 23,863 13,251 35,000 35,000 Bucket Truck OSHA 101 43121 01 416.00 Snow Plow Loader Rental 0 0 0 0 0 101 43121 01 433.00 Dues Subscriptions 700 101 43121 01 433.01 American Public Works Ass'n 750 484 633 500 600 101 43121 01 433.02 "Future Use" 0 0 0 0 0 101 43121 01 433.03 City Engineers' Association 0 28 0 0 0 101 43121 01433.04 Professional Secretaries 0 0 0 0 0 101 43121 01433.05 MN Society for Professional Eng. 0 0 0 0 0 101 43121 01433.06 American Society of Civil Eng. 0 0 0 0 0 101 43121 01 433.07 MN Street Superintendent Ass'n 0 0 70 100 100 101 43121 01433.08 "Future Use" 0 0 0 500 0 101 43121 01 435.00 Books Pamphlets 0 101 43121 01 435.01 "Future Use" 0 0 0 200 0 101 43121 01 435.02 "Future Use" 0 0 0 600 0 101 43121 01437.00 Conferences Seminars 5,000 101 43121 01 437.01 APWA 233 549 215 1,200 500 101 43121 01 437.02 Computer Training 384 0 99 500 500 101 43121 01 437.03 Clerical 249 0 0 200 200 101 43121 01 437.04 Gravel Road Maintenance 150 0 0 150 200 101 43121 01 437.05 Maintenance Expo 0 0 24 300 350 101 43121 01 437.06 CarteGraph User Conference 0 0 0 300 600 101 43121 01437.07 Snow Conference 0 0 90 650 650 101 43121 01437.08 MN Dot 0 440 0 0 0 101 43121 01 437.09 Miscellaneous Training 3,648 1,014 3,557 2,000 2,000 101 43121 01 439.00 Other Miscellaneous Charges 590 738 211 2,000 1,000 Host CONDAC $500 101 43121 01 570.00 Office Equipment Furnishings 1,362 0 0 0 0 PAGE TOTALS $247,148 $272,528 $301,095 $336,200 $331,700 DEPARTMENT TOTALS $1,073,605 $1,135,070 $1,198,413 $1,297,000 $1,309,700 Estmated Road Salt Cost for 2010 Salt $58.75/ton x 500 tons $29,375 Treated Salt $74.00/ton x 750 tons 55,500 Total for Road Salt $84,875 Estimated De -Icing Gravel Cost for 2010 Gravel $15.50/ton x 70 tons $1,085 Treated Gravel $28.50/ton x 20 tons 570 Total for Road Salt $1,655 Page One July 15, 2009 Account 101 45100 101.00 Salaries Benefits $608,445 $644,547 $664,811 $655,000 101 45100 102.00 Fu8-Time Overtime 10,899 12,871 9,443 11,000 101 45100 103.00 Part-Time Salaries Benefits 101 45100 10 103.00 P/T Receptionists 28,168 20,723 30,760 44,800 101 45100 12 103.00 Building Attendants 52,065 47,070 56,912 49,000 101 45100 83 103.00 Playground Recreation Leaders 19,160 22,902 24,155 23,000 101 45100 94 103.00 Warming House Attendants 10,811 10,511 16,453 15,000 101 45100 99 103.00 Park Rec Committee 1,877 1,595 1,560 2,500 101 45100 71 103.00 P/T Horticulturist 2,976 4,985 3,449 6,500 101 45100 01 203.00 101 45100 01 205.00 101 45100 01 207.00 101 45100 01 208.00 101 45100 01 209.00 101 45100 01 211.00 101 45100 01 216.00 101 45100 01 219.00 101 45100 01 221.00 101 45100 01 223.00 101 45100 01 229.00 101 45100 01 303.00 101 45100 01 305.00 101 45100 01 312.00 101 45100 01 315.00 101 45100 01 315.01 101 45100 01 315.02 101 45100 01 315.03 101 45100 01 315.04 101 45100 01 315.05 101 45100 01 315.06 101 45100 01 315.07 101 45100 01 315.08 101 45100 01 315.09 101 45100 01 315.10 101 45100 01 319.00 101 45100 01 321.00 101 45100 01 331.00 101 45100 01 341.00 101 45100 01 349.00 101 45100 01 349.01 101 45100 01 349.02 101 45100 01 349.03 101 45100 01 381.00 101 45100 01 383.00 101 45100 01 384.00 101 45100 01 392.00 101 45100 01 393.00 101 45100 01 394.00 101 45100 01 401.00 101 45100 01 404.00 101 45100 01 409.00 101 45100 01 412.00 101 45100 01 415.00 101 45100 01433.00 101 45100 01 433.01 101 45100 01 433.02 101 45100 01 433.03 101 45100 01 435.00 101 45100 01 437.00 101 45100 01 437.01 101 45100 01 437.02 101 45100 01 437.03 101 45100 01 439.00 2010 BUDGET WORKSHEETS PARKS RECREATION Description Printed Forms Paper Drafting Supplies Training Instructional Supplies Miscellaneous Supplies Other Office Supplies Cleaning Supplies Chemicals Chemical Products Other Operating Supplies Equipment Parts Building Repair Supplies Other Maintenance Supplies Engineering Fees Medical Dental Fees Custodial Services Special Programs Sunday Night Specials Leprechaun Days Halloween Ground Pounders(Running) Nature Programs(Arbor Day, etc.) Puppet Programs Special Events Adopt -A -Park Program Miscellaneous Programs ADA Programs Other Professional Services Telephone Costs Travel Expense Employment Advertising Other Advertising Brochures Yellow Pages Special Marketing Electric Utilities Gas Utilities Refuse Disposal P.C. Accessories Supplies P.C. Hardware Purchases P.C. Software Purchases Contracted Building Repairs Contracted Mach Equip Repairs Other Contracted Repair Maint Building Rental Other Equipment Rental Dues Subscriptions MRPA Dues Miscellaneous On -Line Registrat'n Subscription Books Pamphlets Conferences Seminars MRPA State Conference MIAMA State Conference Workshops, Schools, Tuition Other Miscellaneous Charges 2006 2007 2008 Actual Actual Actual O 46 43 0 782 706 237 1,000 O 0 0 200 74 100 69 500 1,102 282 70 1,600 5,669 5,171 4,406 6,000 2,009 1,408 789 2,000 6,779 5,709 5,604 7,000 9,483 8,932 7,854 9,500 4,213 3,555 3,654 5,500 148 0 44 0 O 0 0 0 0 230 50 0 800 0 Employment Physicals 5,700 9,074 8,307 9,000 9,000 Custodial Services- Banquet Rm 15,300 2,150 3,139 3,002 6,000 6,000 Performances (Add Movies) 800 200 212 600 400 Trophies Awards 130 16 129 0 0 270 53 54 400 300 Ribbons Mailings 2,057 2,619 3,257 3,900 3,900 Trees 299 0 230 500 300 Tapes, Fuses, Puppets, etc. 971 197 1,751 1,000 1,000 Publicity Supplies 345 1,357 932 1,000 1,000 Flyers, Signs 756 2,009 557 2,000 2,000 Start Up Costs O 0 0 800 400 ADA Program Supplies 2,437 393 2,723 2,500 2,500 ADA Services /Eng.LA Sen. Test 2,234 2,351 2,973 3,100 3,100 Pagers Cellular Phones 147 196 380 500 500 O 675 696 2,800 700 General Employment Ads 43,300 26,047 36,019 36,688 35,000 36,000 City Newsletter (4 Per Year) 4,363 5,080 4,893 3,400 3,400 Rec Ads 2,284 2,250 4,799 3,900 3,900 Garage Sale Ad 25,383 27,291 27,864 27,000 30,000 31,488 34,232 37,662 50,000 42,000 3,190 3,720 4,363 4,000 4,000 3,431 0 0 0 0 1,409 0 1,764 0 2,000 O 0 13,000 13,000 5,000 On -Line Registration S/W Support 9,049 12,066 6,408 11,000 10,000 6,799 8,793 1,571 8,000 8,000 19,268 22,736 19,594 30,000 23,000 Air Handler Maintenance Contract 16,800 16,800 16,800 16,800 16,800 Monthly Rent Payments to Guard 13,213 12,367 13,054 18,000 17,000 Portable Toilets Other Rentals 3,700 1,259 1,259 1,259 2,100 941 867 583 400 O 0 1,332 1,200 O 0 0 100 1,260 1,677 2,494 2,000 O 0 190 300 997 469 972 2,200 7,595 19,991 7,586 0 O 0 0 45,000 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget 34,000 50,000 23,000 15,000 2,500 6,500 2,100 400 1,200 2,000 300 2,200 101 45100 01 530.00 Improvements Other Than Bldgs PAGE TOTALS $957,960 $1,019,058 $1,058,589 $1,148,400 $1,142,300 General Operating DEPARTMENT TOTALS $957,960 $1,019,058 $1,058,589 $1,148,400 $1,142,300 Comments All Salary Costs Inclusive of $657,000 Salary, Taxes, PERA Benefits 11,000 131,000 0 800 Film, Developing Laminating 100 Books, Tapes, etc. 200 Meeting Supplies 1,200 Envelopes, Forms, Rulers, etc. 6,000 1,500 6,000 Rec Programs, 1st Aid Sup, etc. 8,500 4,500 0 Minn Recreation Parks Ass'n Paper, Magazines, JC Dues, etc. 100 4,500 0 Donation Account 74,000 Net Effect for Si Joe's Operations Page One July 15, 2009 Account Description 101 45202 101.00 101 45202 77 101.00 101 45202 79 101.00 101 45202 102.00 101 45202 99 103.00 101 45202 01 205.00 101 45202 01 216.00 101 45202 01 216.01 101 45202 01 216.02 101 45202 01 219.00 101 45202 01 219.01 101 45202 01 219.02 101 45202 01 219.03 101 45202 01 219.04 101 45202 01 219.05 101 45202 01 221.00 101 45202 01 221.01 101 45202 01 221.02 101 45202 01 221.03 101 45202 01 221.04 101 45202 01 223.00 101 45202 01 223.01 101 45202 01 223.02 101 45202 01 223.03 101 45202 01 223.04 101 45202 01 225.00 101 45202 01 225.01 101 45202 01 225.02 101 45202 01 226.00 101 45202 01 229.00 101 45202 01 241.00 101 45202 01 242.00 101 45202 01 303.00 101 45202 01 305.00 101 45202 01 318.00 101 45202 01 321.00 101 45202 01 323.00 101 45202 01 341.00 101 45202 01 381.00 101 45202 01 381.01 101 45202 01 381.02 101 45202 01 381.03 101 45202 01 383.00 101 45202 01 394.00 101 45202 01 403.00 101 45202 01 403.01 101 45202 01 403.02 101 45202 01 403.03 101 45202 01 409.00 101 45202 01 409.01 101 45202 01 409.02 101 45202 01 416.00 101 45202 01 416.01 101 45202 01 416.02 101 45202 01 433.00 101 45202 01 433.01 101 45202 01 433.02 101 45202 01 435.00 101 45202 01 437.00 101 45202 01 437.01 101 45202 01 437.02 101 45202 01 439.00 2010 BUDGET WORKSHEETS PARKS GROUNDS MAINTENANCE Salaries Benefits Administrative Maintenance Full -Time Overtime Part-Time Salaries Benefits Drafting Supplies Chemical Chemical Products Herbicides(General Park Use) Fertilizer Other Operating Supplies Seed, Sod, etc. Red Rock, Sand, Gravel, etc. Repair Supplies Bituminous Wood Chips Equipment Parts Playground Equipment Repair Irrigation Repair(Non- Contract) Miscellaneous Park Sign Replacements Building Repair Supplies Paint, Stain, etc. Shingles, Boards, etc. Miscellaneous Shelter /Shed Repairs Landscaping Materials Trees, Shrubs, Sod, etc. Timbers, Fence, etc. Sign Repak Materials Other Maintenance Supplies Small Tools Minor Equipment Engineering Fees Medical and Dental Fees Contract Engineer Telephone Costs Radio Units Employment Advertising Electric Utilities Skating Rinks Softball Fields Irrigation Gas Utilities P.C. Software Purchases Contracted Repair Maintenance Irrigation Repairs Electrical Repairs Miscellaneous Repairs Other Contracted Repair Maint Chemlawn Services Library St. Joe's RCC Machinery Rental Mower Leases Miscellaneous Rentals Dues Subscriptions MN Park Supervisors Ass'n Miscellaneous Dues Books Pamphlets Conferences Seminars Seminars Workshops School Tukion Other Miscellaneous Charges 101 45202 01 530.00 Improvements Other Than Bldgs PAGE TOTALS DEPARTMENT TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $521,414 $535,318 $721,147 $683,900 $718,500 $521,414 $535,318 $721,147 $683,900 $718,500 Comments All Salary Costs Inclusive of $412,600 Salary, Taxes, PERA Benefits 10,123 10,506 10,954 11,300 11,500 346,649 366,723 381,555 393,600 401,100 7,018 11,384 14,556 14,000 14,000 19,544 15,478 35,190 35,000 49,500 Additional New 6 -Month Position O 0 0 100 100 34,000 Includes all City Facilities 9,230 6,081 8,651 12,000 12,000 16,426 18,304 21,579 22,000 22,000 16,500 2,492 3,426 2,952 3,000 3,000 5,964 3,472 1,085 7,000 3,500 16 334 512 3,000 1,000 O 0 0 0 0 O 0 6,760 6,000 9,000 Special Wood Chips Playgrounds 14,500 2,855 7,791 4,509 4,500 4,500 3,357 5,735 7,450 7,500 7,500 883 3,289 108 2,500 2,500 5,473 0 648 2,500 0 10,000 2,152 981 1,696 1,500 1,500 1,705 1,012 1,915 2,000 2,000 1,502 1,503 1,706 1,500 1,500 4,809 5,219 29,580 5,000 5,000 7,000 6,082 4,536 2,218 3,500 3,500 456 629 684 3,500 3,500 O 492 0 500 500 6,196 3,731 5,288 6,000 7,000 Paint, Chalk, Field Dry DCTC) 2,584 2,377 1,539 2,500 2,500 Hand Tools, Blades, Bits, etc. 2,089 1,053 2,627 2,500 2,500 Weed Whips, Chain Saws- Powered O 0 0 0 0 O 0 0 600 600 Employment Physicals 2,250 750 1,500 3,000 1,500 Contracted Engineer for City (5 2,928 2,988 2,905 3,100 3,100 Includes Wireless Technology O 0 0 500 1,300 800 MHZ Monthly Charges O 0 11 0 0 20,000 5,104 5,831 6,697 6,000 6,000 8,740 5,937 7,030 10,000 9,000 2,929 3,190 3,402 5,000 5,000 2,292 2,574 2,509 3,300 2,800 O 0 0 5,000 6,000 CarteGraph Maintenance 14,000 O 913 2,985 5,000 5,000 System Blow -Out 4,308 7,362 3,951 6,000 6,000 2,080 6,013 36 3,000 3,000 16,459 4,222 3,806 8,000 10,000 O 0 0 0 4,000 O 0 0 0 6,000 20,500 14,100 18,395 14,584 19,000 19,000 Exmark, 2 John Deere 1,758 1,851 1,425 1,500 1,500 200 O 0 0 50 50 70 35 70 150 150 O 0 0 100 100 2,500 346 726 616 1,500 1,500 Green Expo, MPSA, Playgrounds 445 475 1,285 400 1,000 Turf School, Power Limited Tech. O 0 0 200 200 Contingencies 124,572 50,000 65,000 Annual Total Expenditures Page Two 2010 BUDGET WORKSHEETS PARKS RECREATION July 15, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 101 45100 81 Softball $44,625 $43,973 $49,985 $45,000 $45,000 101 45100 82 Volleyball 335 85 0 0 0 101 45100 84 Tennis 1,137 1,727 1,893 2,000 2,000 101 45100 85 Tiny Tots 21,285 22,769 18,543 21,500 21,500 101 45100 86 Rosettes 817 1,281 1,111 1,200 1,200 101 45100 87 Trips 10,667 7,327 7,013 8,300 8,300 101 45100 88 Broomball 0 0 0 0 0 101 45100 90 Run for the Gold 3,405 3,966 3,027 4,000 4,000 101 45100 91 Camps 14,918 11,917 10,846 12,000 12,000 101 45100 92 Adult Basketball 0 501 859 600 600 101 45100 93 Other Programs 13,017 14,348 11,218 14,500 14,500 101 45100 95 T -Ball 5,320 6,587 5,286 7,000 7,000 101 45100 96 Teen Night 5,245 5,322 5,478 5,000 5,000 101 45100 97 Soccer League 844 11,071 9,627 0 0 101 45100 98 Soccer Lessons 1,211 2,682 3,406 2,600 2,600 122,826 133,556 128,294 123,700 123,700 Detail for Above $123,700 Comments No League in 2010 101 45100 81 103.00 Part-Time Salaries 7,746 6,568 7,332 7,000 7,000 101 45100 81 219.00 Operating Supplies 5,609 7,521 10,037 8,000 8,000 101 45100 81 311.00 Officiating Fees 28,000 26,266 27,470 27,000 27,000 101 45100 81 319.00 Other Professional Services 3,270 3,617 5,146 3,000 3,000 101 45100 82 103.00 Part-Time Salaries 0 0 0 0 0 101 45100 82 219.00 Operating Supplies 335 85 0 0 0 101 45100 82 311.00 Officiating Fees 0 0 0 0 0 101 45100 82 319.00 Other Professional Services 0 0 0 0 0 101 45100 84 103.00 Part-Time Salaries 1,061 1,223 1,604 1,500 1,500 101 45100 84 219.00 Operating Supplies 76 504 290 500 500 101 45100 85 103.00 Part-Time Salaries 18,829 21,617 17,685 20,000 20,000 101 45100 85 219.00 Operating Supplies 2,455 1,152 857 1,500 1,500 101 45100 86 103.00 Part-Time Salaries 356 346 490 400 400 101 45100 86 219.00 Operating Supplies 460 935 621 800 800 101 45100 87 103.00 Part-Time Salaries 859 799 638 1,000 1,000 101 45100 87 219.00 Operating Supplies 9,807 7.300 101 45100 87 219.01 Youth/Teen Trips Supplies 0 4,369 4,561 4,300 4,300 101 45100 87 219.02 Adult/Senior Trips Supplies 0 2,159 1,815 3,000 3,000 101 45100 88 219.00 Operating Supplies 0 0 0 0 0 101 45100 88 311.00 Officiating Fees 0 0 0 0 0 101 45100 90 219.00 Operating Supplies 3,405 3,966 3,027 4,000 4,000 101 45100 91 103.00 Part-Time Salaries 6,773 4,319 3,297 5,000 5,000 101 45100 91 219.00 Operating Supplies 8,145 7,598 7,549 7,000 7,000 101 45100 92 219.00 Operating Supplies 0 501 859 600 600 101 45100 93 103.00 Part-Time Salaries 3,013 3,093 3,069 3,000 3,000 101 45100 93 219.00 Operating Supplies 10,004 10,265 7,859 11,500 11,500 101 45100 93 319.00 Other Professional Services 0 990 290 0 0 101 45100 95 103.00 Part -Time Salaries 3,641 4,585 3,435 5,500 5,500 101 45100 95 219.00 Operating Supplies 1,679 2,002 1,850 1,500 1,500 101 45100 96 103.00 Part-Time Salaries 1,273 1,684 1,262 0 0 101 45100 96 219.00 Operating Supplies 3,971 3,638 4,216 5,000 5,000 101 45100 97 103.00 Part-Time Salaries 806 0 0 0 0 101 45100 97 219.00 Operating Supplies 38 821 717 0 0 101 45100 97 311.00 Officiating Fees 0 10,250 8,910 0 0 101 45100 98 103.00 Part-Time Salaries 273 1,571 1,989 1,000 1,000 101 45100 98 219.00 Operating Supplies 938 1,112 1,418 1,600 1,600 SPECIAL PROGRAM TOTALS 122,826 133,556 128,294 123,700 123,700 GRAND TOTAL PARK REC $1,080,786 $1,152,615 $1,186,883 $1,272,100 $1,266,000 Page One July 15, 2009 Account 2010 BUDGET WORKSHEETS OTHER FINANCING USES Description 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 101 49300 -01 710.00 Transfers $0 $100,000 $165,000 $115,000 $115,000 Arena Operations Assistance FUND TOTALS $0 $100,000 $165,000 $115,000 $115,000 I> (AI hl Page One July 15, 2009 Account Description 206 31010.00 206 33100.00 206 36210.00 206 36214.00 206 36215.00 206 36260.00 Account Current Ad Valorem Taxes Federal Grants Aids Interest Earnings investments Net Change in FV- Investments Interest Earnings Other Revenue 206 49006 01 221.00 Equipment Parts 206 49006 01 304.00 206 49006 01 305.00 206 49006 01 317.00 206 49006 01 319.00 206 49006 01 319.01 206 49006 01 319.02 206 49006 01 365.00 206 49006 01 369.00 2010 BUDGET WORKSHEETS INSURANCE REVENUES FUND TOTALS INSURANCE EXPENDITURES 2006 2007 2008 Description Actual Actual Actual Legal Fees Medical Dental Fees General Fund Administrative Fees Other Professional Services Risk Management Consultant CHESS Consultant Worker's Compensation Insurance Other Insurance 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $260,000 $260,000 $275,000 $275,000 $275,000 0 0 0 0 0 23,660 29,968 24,345 28,000 26,000 0 562 (375) 0 0 Annual Market Value Changes 292 161 409 500 500 14,775 26,743 19,713 21,000 20,000 Insurance Refunds /Dividends 298,727 317,433 319,091 324,500 321,500 $1,163 $2,653 $0 $3,000 0 0 0 1,000 6,543 7,260 5,051 8,000 2,500 2,500 2,500 2,500 17,495 18,240 10,100 9,500 10,500 8,200 10,500 13,500 70,877 76,437 88,429 85,000 180,146 178,524 165,746 190,000 206 49006 01 409.00 Other Contracted Repair Maint 11,136 17,747 10,120 15,000 206 49006 01 439.00 Other Miscellaneous Charges 0 97 0 0 FUND TOTALS 289,860 303,458 290,145 324,500 321,500 NOTE: Levy of $275,000 covers costs for all insurance premiums. All other expenditures covered through interest earnings and insurance refunds /dividends. 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget Comments Comments $2,500 Liability Auto Deductible Pymts 500 7,000 2,500 24,000 Unreimbursable Legal Fees Work Comp Deductible Pymts Yearly Fee Per Policy F -3 Risk Management Consultant 92,000 Annual Premium 183,000 Annual Premium General Liability 10,000 Liability Auto Deductible Pymts 0 Page One June 16, 2009 Account 201 31010.00 201 31050.00 201 33130.00 201 33425.00 201 34109.00 201 36105.00 201 36210.00 201 36212.00 201 36215.00 201 36230.00 201 36260.00 201 36265.00 201 39101.00 Account 201 46300 99 103.00 Part-Time Salaries Benefits 201 46300 01 303.00 201 46300 01 304.00 201 46300 01 307.00 201 46300 01 313.00 201 46300 01 315.00 201 46300 01 315.01 201 46300 01 315.02 201 46300 01 315.03 201 46300 01 315.04 201 46300 01 315.05 201 46300 01 317.00 201 46300 01 319.00 201 46300 01 319.01 201 46300 01 319.02 201 46300 01 319.03 201 46300 01 319.04 201 46300 01 319.07 201 46300 01 322.00 201 46300 01 349.00 201 46300 01 351.00 201 46300 01 359.00 201 46300 01 365.00 201 46300 01 369.00 201 46300 01 381.00 201 46300 01 383.00 201 46300 01 389.00 201 46300 01 403.00 201 46300 01 433.00 201 46300 01 433.01 201 46300 01 433.02 201 46300 01 437.00 201 46300 01 439.00 201 46300 01 521.00 201 46300 01 525.00 201 46300 01 530.00 Description FUND TOTALS Description 201 46300 01 710.00 Transfers 2010 BUDGET WORKSHEETS PORT AUTHORITY REVENUES Current Ad Valorem Taxes Tax Increments Federal Grants -CDBG Other State Grants Aids Other Charges for Services Principal on Notes Interest Earnings Investments Interest Earnings Blake Interest Earnings Contributions /Donations Other Revenue Use of Reserve Funds Sales of General Fixed Assets EXPENDITURES Engineering Fees Legal Fees Managment Fees Air Cargo Temporary Service Fees Special Programs Downtown Downtown Planning Consultant Downtown Communications Plan Downtown Ombudsman Downtown Design Standards Downtown Market Study Update General Fund Administrative Fees Other Professional Services Project Management Consultant Marketing County TIF Charges P/A Property Tax Payments Central Park Survey Work Postage Costs Other Advertising Legal Notices Publishing Other Printing Binding Costs Workers Comp Insurance Other Insurance Electric Utilities Gas Utilities Other Utility Services Contracted Repairs Maintenance Dues Subscriptions Professional Organizations /Journr Foreign Trade Zone Commission Conferences Seminars Other Miscellaneous Charges Building Structure Purchases Building Structure Purchases Improvements Other Than Bldgs FUND TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $60,000 0 0 0 0 38,064 5,552 6,484 355 0 0 0 0 $110,454 $519,021 $64,576 $74,700 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $4,233 $5,393 $3,870 $5,000 $5,000 Salary, ala Authority Taxes, Members ER Benefits 1,421 0 0 4,000 4,000 3,834 6,254 1,596 5,000 4,000 O 0 0 0 0 (EIS) or (AUAR) O 0 0 0 0 0 0 0 0 0 0 6,000 919 14,599 3,152 834 0 0 73 0 0 399 1,454 3,207 846 1,258 0 1,365 15,000 4,844 788 $0 0 0 0 11,256 499,021 5,254 3,072 418 0 0 0 0 0 0 0 0 0 6,400 3,750 70 7,066 2,170 0 85 163 0 0 429 4,323 7,229 8,314 1,789 964 1,360 15,000 7,106 139 O 0 O 558,910 O 0 $50,000 0 0 0 13,319 0 632 0 204 0 421 0 0 0 0 0 0 0 6,000 3,150 0 7,996 10,546 7,307 117 2,050 0 491 456 4,385 4,420 9,814 1,871 0 1,195 0 4,697 89 0 0 0 $50,000 0 0 0 0 0 2,000 0 200 0 0 22,500 0 0 0 0 0 0 6,000 2,000 0 4,000 1,000 1,000 3,000 20,000 200 10,000 500 2,500 1,000 0 1,000 0 0 0 0 0 0 2,000 0 0 1,000 0 2,000 1,700 0 0 6,000 500 0 0 0 $53,200 $64,224 $636,913 $70,049 $74,700 $53,200 Comments $50,000 Operating Levy 0 Admin Fees Portion Only 0 O LCDA Downtown Grant 1,000 Genz -Ryan Tenant Utility Pymts O Blake L/T Lease Sold in 2007 2,000 Interest Earned on CD's O Blake L/T Lease Sold in 2007 200 Checking Interest Misc 0 0 0 0 6,000 Yearly Fee Per Policy F -3 3,000 0 Moved to "349.00" Below 1,000 14,000 Additional Marketing 0 3,000 500 Commissioners 2,800 Property Insurance 1,000 Business Park Other Properties 700 Other Properties 1,000 Utility Fees 1,700 Prof Organizations/Joumals 5,000 Development/TIF/Miscellaneous 500 Contingencies 0 0 0 Special Downtown Projects 0 0 0 0 0 Page One June 16, 2009 Account 242 31050.00 242 33400.00 242 33620.00 242 36210.00 242 36215.00 242 36220.00 242 36260.00 242 39310.00 Account 242 49042 01 303.00 242 49042 01 304.00 242 49042 01 319.00 242 49042 01 522.00 242 49042 01 530.00 242 49042 01 611.00 242 49042 01 710.00 2010 BUDGET WORKSHEETS DOWNTOWNIBROCKWAY DISTRICT(0108) REVENUES Description Tax Increments State Grants Aids Other County Grants Aids Interest Earnings Investments Interest Eamings Rents Royalties Other Revenue Bond Proceeds FUND TOTALS Description E XP E ND IT U R ES 2006 2007 2008 Actual Actual Actual $14,675 $134,224 $296,735 $300,000 O 0 422,179 0 O 0 100,000 0 O 803 427 0 70 258 99 0 9,679 65,041 30,252 0 O 10,000 9,500 0 O 0 6,040,000 0 $24,425 $210,326 $6,899,192 $300,000 2006 2007 2008 Actual Actual Actual 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget $300,000 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget Comments FUND TOTALS $2,530,954 $609,681 $3,345,677 $300,000 $300,000 $300,000 0 0 0 0 0 0 0 Comments Engineering Fees $0 $0 $201,758 $0 Legal Fees 0 0 434 0 0 Other Professional Services 6,188 89,898 177,259 0 0 Building Structure Purchases 2,460,390 356,987 900,945 0 0 Improvements Other Than Buildings 0 35,139 1,944,456 0 0 Interest on Internal Loan 64,376 127,656 34,825 0 0 Transfers 0 0 86,000 300,000 300,000 P I for 2008A 20088 Issues Page One 2010 BUDGET WORKSHEET WATER UTILITY REVENUES July 13, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 601 33425.00 Other State Grants Aids $0 $0 $0 $0 601 34108.00 Administrative Fees -Other Funds 11,051 5,693 5,378 3,000 0 5% of 5% Fees -Const Projects 601 34109.00 Other Gen'I Govt Chgs for Services 0 0 2,500 0 0 601 36101.00 Principal Special Assessments 96,261 32,075 45,448 30,000 30,000 601 36102.00 Penalties Interest S/A 1,966 2,409 (28) 0 0 601 36210.00 Interest Eamings Investments 101,383 129,301 88,409 100,000 80,000 601 36214.00 Net Change in FV- Investments (2,305) 15,790 7,341 0 0 Annual Market Value Changes 601 36215.00 Interest Eamings 386 216 554 200 200 601 36220.00 Rents Royalties 81,473 47,705 49,709 50,000 50,000 Antenna Leases 601 36260.00 Other Revenues 0 0 0 0 0 601 36265.00 Use of Reserve Funds 0 0 0 0 0 601 37110.00 Residential Water Revenues 857,057 902,174 907,400 825,000 1,050,000 601 37120.00 Apartment Water Revenues 92,229 68,187 68,576 65,000 65,000 601 37125.00 Institutional Water Revenues 29,207 33,006 45,900 30,000 30,000 601 37130.00 Commercial Water Revenues 58,007 63,450 55,094 60,000 60,000 601 37140.00 Industrial Water Revenues 31,011 30,214 54,720 30,000 37,000 601 37160.00 Penalties Water Revenues 10,971 9,080 9,652 7,000 7,000 601 37165.00 Meter Maint Water Revenues 0 0 0 0 0 601 37170.00 Other Water Revenues 0 0 0 0 0 601 37180.00 Water Meter Sales Revenue 85,230 65,604 56,669 50,000 40,000 601 39103.00 Gain or Loss from F/A Disposal 0 0 0 0 0 601 39203.00 Transfer From 0 0 0 0 0 FUND TOTALS $1,453,927 $1,404,903 $1,397,321 $1,250,200 $1,449,200 Page One July 13, 2009 Account 2010 BUDGET WORKSHEET WATER UTILITY EXPENDITURES Description 601 49400 101.00 Salaries Benefits 601 49400 77 101.00 Administrative 601 49400 78 101.00 Technical/Clerical 601 49400 79 101.00 Maintenance 601 49400 xx 101.00 Salary Benefit Contingency 601 49400 102.00 Full -Time Overtime 601 49400 103.00 Part-Time Salaries Benefits 601 49400 99 103.01 Utility Commission Wages (50 601 49400 99 103.02 Maintenance Labor 601 49400 01 203.00 Printed Forms Paper 601 49400 01 209.00 Other Office Supplies 601 49400 01 216.00 Chemicals Chemical Products 601 49400 01 219.00 Other Operating Supplies 601 49400 01 220.00 Water Meter Purchases 601 49400 01 220.01 For Replacements 601 49400 01 220.02 For New Homes 601 49400 01 224.00 Street Maintenance Materials 601 49400 01 225.00 Landscaping Materials 601 49400 01 227.00 Utility System Maintenance Supplies 601 49400 01 228.00 Meter Repair Materials 601 49400 01 229.00 Other Maintenance Supplies 601 49400 01 229.01 Supplies for Hydrants 601 49400 01 229.02 Valve Curb Boxes 601 49400 01 229.03 Valve Replacements (2) 601 49400 01 229.04 Miscellaneous Supplies 601 49400 01 241.00 Small Tools 601 49400 01 242.00 Minor Equipment 601 49400 01 242.01 Miscellaneous Purchases 601 49400 01 242.02 601 49400 01 303.00 Engineering Fees 601 49400 01 303.01 Water Conserv'n Emergency 601 49400 01 303.02 GIS Update of Asbuilts 601 49400 01 303.03 Rate Study 601 49400 01 303.04 Miscellaneous Fees 601 49400 01 304.00 Legal Fees 601 49400 01 310.00 Testing Services 601 49400 01 310.01 Bacteria Water Quality 601 49400 01 310.02 V.O.C., Pesticides, etc. 601 49400 01 310.03 CU -PB Testing 601 49400 01 312.00 Gopher State One -Call 601 49400 01 313.00 Temporary Service Fees 601 49400 01 315.00 Special Programs 601 49400 01 315.01 Public Information 601 49400 01 315.02 Plan Amendments 601 49400 01 315.03 Seminars 601 49400 01 315.04 Vulnerability Assessment Imp. 601 49400 01 318.00 Contract Engineer 601 49400 01 319.00 Other Professional Services 601 49400 01 319.01 Thaw Pipes, Check Leaks, etc. 601 49400 01 319.02 Supervisory Controls 601 49400 01 319.03 Hazardous Chemical Permits 601 49400 01 319.04 Annual Drinking Water Report 601 49400 01 319.05 Hazardous Chemical Inventory 601 49400 06 319.06 Contracted Hydrant Painting 601 49400 01 321.00 Telephone Costs 601 49400 01 322.00 Postage Costs 601 49400 01 323.00 Radio Units 601 49400 01 331.00 Travel Expense 601 49400 01 333.00 Freight Express Expenses 601 49400 01 341.00 Employment Advertising 601 49400 01 349.00 Other Advertising PAGE TOTALS 2006 2007 Actual Actual 103,612 132,293 126,546 0 4,701 20,251 1,903 328 36,349 0 10,710 2,091 1,078 2,983 1,686 108,458 143,055 125,239 0 10,405 28,523 1,988 142 43,422 0 2009 2008 Adopted Actual Budget 100,662 150,848 127,752 0 6,825 6,758 1,742 280 64,796 231 109,500 164,400 140,700 0 10,000 9,000 2,500 200 55,000 200 7,960 7,693 19,081 0 0 77,055 80,268 61,712 130,000 40,000 1,905 2,811 2,534 2,000 2,500 Patching for Breaks 491 0 0 500 500 Topsoil, Seed Sod 895 1,916 130 0 0 196 0 0 300 300 Miscellaneous Meter Parts 14,000 1,355 138 0 1,941 963 4,422 510 0 3,225 1,263 4,000 1,300 2,200 5,000 2,000 2010 Object Detail Amount 108,300 164,700 137,200 10,700 7,500 8,000 1,000 50% 601; 50% 602 7,000 100% 601 5,500 1,300 2,200 5,000 920 487 2,811 3,000 3,000 402 0 0 0 0 0 7,000 0 12,000 612,768 663,831 664,034 758,700 706,300 2010 Proposed Budget Comments All Salary Costs Inclusive of $410,200 Salary, Taxes, PERA Benefits 2,000 200 90,000 200 40,000 Inserts Water Bill Statements Disks, Ribbons, etc. Chlorine, Flouride, Polyphos Maintenance Supplies Meters, Mill's CU Homs 2,000 Wrenches, Shovels, etc. 3,000 19,000 1,346 23,523 2,132 0 0 0 10,257 7,000 O 3,348 162 0 1,177 13,553 12,317 12,000 0 63 769 1,000 1,000 43,000 1,560 1,873 1,960 2,000 2,000 Radon, Tri -Chl. O 0 0 1,000 1,000 32,976 37,284 37,831 40,000 40,000 $6.36 /Connection Annual Fee (M) 3,985 3,269 3,500 7,000 3,500 Gopher State One -Call (M) 4,085 1,021 0 0 0 11,500 O 0 0 5,500 5,500 Wellhead Protection Plan 0 0 0 5,000 5,000 Wellhead Protection Plan O 0 0 1,000 1,000 Wellhead Protection Plan O 3,656 0 0 0 13,413 3,000 6,000 9,000 6,000 Contracted Engineer for City(20 21,100 12,549 6,022 3,557 1,500 1,500 343 0 11,522 3,000 5,000 0 0 1,000 500 1,000 MN Department of Public Safety 0 0 2,271 2,500 2,500 0 0 1,100 600 1,100 O 0 6,936 7,000 10,000 175 Hydrants per Year 1,181 1,529 3,013 2,000 2,200 Cell Phones, Modesm, GPS 4,918 5,428 3,975 6,000 6,000 Billings with Inserts 873 1,422 150 1,000 1,300 800 MHZ Monthly Charges 10 0 0 1,000 0 AWWA National Seminar 0 38 0 100 100 Mail -in Repairs O 0 0 700 0 Pliers Personnel Changes O 0 0 500 500 Page Two July 13, 2009 Account 601 49400 01 352.00 General Notices Public Info 601 49400 01 365.00 Workers Comp Insurance 601 49400 01 369.00 Other Insurance 601 49400 01 391.00 P.C. Maintenance 601 49400 01 392.00 P.C. Accessories Supplies 601 49400 01 393.00 P.C. Hardware Purchases 601 49400 01 394.00 P.C. Software Purchases 601 49400 01 395.00 P.C. Repairs 601 49400 01 403.00 601 49400 01 416.00 601 49400 01 433.00 601 49400 01 435.00 601 49400 01 437.00 601 49400 01 437.01 601 49400 01 437.02 601 49400 01 439.00 601 49400 01 521.00 601 49400 01 530.00 601 49400 01 530.01 601 49400 01 530.02 601 49400 01 530.03 601 49400 01 530.04 601 49400 01 530.05 601 49400 01 530.06 601 49400 01 530.07 601 49400 01 560.00 601 49400 01 570.00 601 49400 01 586.00 601 49400 01 611.00 601 49400 01 710.00 601 49403 01 221.00 601 49403 01 223.00 601 49403 01 319.00 601 49403 01 321.00 601 49403 01 381.00 601 49403 01 383.00 601 49403 01 409.00 601 49403 01 439.00 601 49406 01 221.00 601 49406 01 223.00 601 49406 01319.00 601 49406 01 321.00 601 49406 01 381.00 601 49406 01 383.00 2010 BUDGET WORKSHEET WATER UTILITY EXPENDITURES Description Contracted R M Other Impr Machinery Rental Dues Subscriptions Books Pamphlets Conferences Seminars MN Health Department School AWWA Conference Other Miscellaneous Charges Building Structure Purchases Improvements Other Than Bldgs Well Inspections Recondition Miscellaneous Improvements CRP of Watermain Water Tower Inspection Fumiture Fixture Purchases Office Equipment Purchases Computer Equipment Purchases Interest on Lease Payments Transfers 601 49400-01 TOTALS Equipment Parts Building Repair Supplies Other Professional Services Telephone Costs Electric Utilities Gas Utilities Other Contracted Repairs Maint Other Miscellaneous Charges TOTAL WELL #3 Equipment Parts Building Repair Supplies Other Professional Services Telephone Costs Electric Utilities Gas Utilities TOTAL EAST SIDE W/M VAULT 601 49407 01 221.00 Equipment Parts 601 49407 01 223.00 Building Repair Supplies 601 49407 01 319.00 Other Professional Services 601 49407 01 321.00 Telephone Costs 601 49407 01 381.00 Electric Utilities 601 49407 01 383.00 Gas Utilities 601 49407 01 409.00 Other Contracted Repairs Maint 601 49407 01 439.00 Other Miscellaneous Charges 601 49407 01 530.00 Improvements Other Than Bldgs TOTAL WELL #7 2006 2007 2008 Actual Actual Actual O 0 0 500 5,153 5,514 5,612 4,500 20,813 21,446 19,794 20,000 338 2,178 2,431 1,000 248 0 171 200 3,423 101 985 4,000 2,663 1,215 2,500 5,000 O 0 0 500 2,200 7,427 0 3,000 6,000 Watermain Breaks O 0 0 4,000 2,000 363 1,205 1,712 1,300 300 Suburban Utility Supt. Assn. O 0 61 300 300 Reference Materials 2,200 106 944 957 900 1,000 Water School, 50% Split w/ 602 (M) 573 0 0 600 1,200 (Part Moved from 433.00) 13,024 13,023 13,609 15,000 15,000 DNR Annual Water Use (M) O 0 0 10,000 13,932 23,939 18,422 25,000 28 10,118 0 10,000 3,036 0 0 150,000 O 14,435 0 3,000 18,149 0 0 0 O 16,851 0 0 O 21,928 0 0 1,362 0 0 0 1,181 233 0 1,000 O 0 0 0 4,696 4,432 4,153 0 O 330,035 0 0 704,057 1,138,853 734,442 1,018,500 1,549 666 43,862 0 1,659 0 0 0 O 0 0 0 18 18 0 0 2,562 328 387 0 839 939 626 2,000 O 0 0 0 O 0 0 100 6,627 1,950 44,874 2,100 185 0 0 500 O 0 0 500 O 0 0 1,000 O 0 0 0 1,246 1,164 1,245 1 ,000 O 0 0 0 1,431 1,164 1,245 3,000 3,608 1,515 7,782 1,200 O 7,550 0 300 O 0 0 500 211 211 211 0 18,100 18,242 21,819 18,000 O 0 0 0 O 0 0 600 O 0 0 100 O 0 0 0 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget 0 10.000 150,000 0 0 0 0 500 6,000 20,000 3,000 200 13,000 6,000 500 21,918 27,518 29,812 20,700 34,700 Newsletters Water's Share of Premiums Water's Share of Premiums Auto Read Software Support Laptops (Split) 2 New Readers Cartegraph ESRI Maintenance 10,000 Pymt on P.W. Building (12 of 20) 160,000 0 1,000 0 952,300 None Scheduled in 2010 Annual Pavement Management None Scheduled in 2010 O P.W. Building Expansion(See 521) O Transfers for Other Improvements O Cap Well O Cap Well O Cap Well O Cap Well O Cap Well 0 0 0 Comments 500 500 1,000 0 1,000 Pumping Lighting O Heat Only 3,000 1,200 300 500 Independent Inspections 0 22,000 Pumping Lighting 0 600 RTU's, Pump Motor, etc. 100 Contingencies 10,000 A/C Temp Humidity Controls Page Three July 13, 2009 Account Description Actual Actual Actual Budget Amount Budget 601 49411 01 221.00 Equipment Parts 601 49411 01 381.00 Electric Utilities 2010 BUDGET WORKSHEET WATER UTILITY EXPENDITURES 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed TOTAL WELL #10 15,868 44,656 16,103 13,000 13,000 TOTAL WELL #11 TOTAL WELL #15 0 0 14,114 32,200 34,000 Comments 601 49408 01 221.00 Equipment Parts 6,817 1,883 3,513 1,500 1,500 601 49408 01 223.00 Budding Repair Supplies 550 0 0 500 500 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 601 49408 01 321.00 Telephone Costs 18 0 0 0 0 601 49408 01 381.00 Electric Utilities 16,230 10,066 11,269 18,000 18,000 Pumping Lighting 601 49408 01 383.00 Gas Utilities 620 703 741 600 600 Heat Only 601 49408 01 530.00 Improvements Other Than Bldgs 0 0 0 0 10,000 A/C Temp Humidity Controls TOTAL WELL #8 24,235 12,652 15,523 20,600 30,600 601 49409 01 221.00 Equipment Parts 4,296 1,765 2,021 1,500 1,500 601 49409 01 223.00 Building Repair Supplies 0 0 0 100 100 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 601 49409 01 321.00 Telephone Costs 18 0 0 0 0 601 49409 01 381.00 Electric Utilities 33,779 30,690 23,975 35,000 35,000 Pumping Lighting 601 49409 01 383.00 Gas Utilities 647 1,007 971 1,500 1,500 Heat Only 601 49409 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49409 01 530.00 Improvements Other Than Bldgs 0 0 0 0 10,000 A/C Temp Humidity Controls TOTAL WELL #9 38,739 33,462 26,967 38,200 48,200 601 49410 01 219.00 Other Operating Supplies 0 0 0 500 500 601 49410 01 221.00 Equipment Parts 6,768 34,078 990 500 500 601 49410 01 223.00 Building Repair Supplies 0 0 0 100 100 601 49410 01 321.00 Telephone Costs 742 723 722 0 0 601 49410 01 381.00 Electric Utilities 8,358 9,855 14,391 9,000 9,000 Pumping Lighting 601 49410 01 409.00 Other Contracted Repairs Maint 0 0 0 2,900 2,900 6,045 46,727 590 0 0 0 0 0 0 0 Pumping Lighting 6,045 46,727 590 0 0 601 49412 01 221.00 EqulpmeMParts 2,023 4,810 1,186 1,000 1,000 601 49412 01 223.00 Building Repair Supplies 41 0 0 500 500 601 49412 01 319.00 Other Professional Services 0 250 7,989 0 0 601 49412 01 321.00 Telephone Costs 0 0 0 0 0 601 49412 01 381.00 Electric Utilities 28,254 28,012 24,122 30,000 30,000 Pumping Lighting 601 49412 01 383.00 Gas Utilities 0 0 0 1,500 1,500 Heat Only 601 49412 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL WELL #12 30,318 33,072 33,297 33,100 33,100 601 49414 01 221.00 Equipment Parts 0 285 599 500 500 601 49414 01 223.00 Building Repair Supplies 0 0 0 100 100 601 49414 01 319.00 Other Professional Services 0 495 908 1,000 1,000 601 49414 01 321.00 Telephone Costs 0 0 0 0 0 601 49414 01 381.00 Electric Utilities 1,415 26,704 32,645 30,000 30,000 Pumping Lighting 601 49414 01 383.00 Gas Utilities 0 0 0 1,000 1,000 Heat Only 601 49414 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49414 01 530.00 Improvements Other Than Bldgs 0 0 0 0 1,800 Humidifier TOTAL WELL #14 1,415 27,484 34,151 32,700 34,500 601 49425 01 221.00 Equipment Parts 0 0 0 500 500 601 49425 01 223.00 Building Repair Supplies 0 0 0 100 100 601 49425 01 319.00 Other Professional Services 0 0 11,960 500 500 601 49425 01 321.00 Telephone Costs 0 0 2,154 0 0 601 49425 01 381.00 Electric Utilities 0 0 0 30,000 30,000 Pumping Lighting 601 49425 01 383.00 Gas Utilities 0 0 0 1,000 1,000 Heat Only 601 49425 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49425 01 530.00 Improvements Other Than Bldgs 0 0 0 0 1,800 Humidifier Page Four July 13, 2009 Account 601 49415 01 221. 601 49415 01 319. 601 49415 01 381. 601 49415 01 409. 601 49415 01 439 601 49415 01 530 00 00 00 00 .00 .00 601 49416 01 221.00 601 49416 01 319.00 601 49416 01 321.00 601 49416 01 381.00 601 49416 01 409.00 601 49416 01 439.00 601 49416 01 530.00 601 49417 01 221.00 601 49417 01 319.00 601 49417 01 321.00 601 49417 01 381.00 601 49417 01 409.00 601 49417 01 439.00 601 49417 01 530.00 601 49418 01 221.00 601 49418 01 319.00 601 49418 01 321.00 601 49418 01 381.00 601 49418 01 409.00 601 49418 01 439.00 601 49418 01 530.00 2010 BUDGET WORKSHEET WATER UTILITY EXPENDITURES Description Equipment Parts Other Professional Services Electric Utilities Other Contracted Repairs Maint Other Miscellaneous Charges Improvements Other Than Bldgs TOTAL WATER TOWER #1 (Chippendale Water Tower) Equipment Parts Other Professional Services Telephone Costs Electric Utilities Other Contracted Repairs Maint Other Miscellaneous Charges Improvements Other Than Bldgs TOTAL WATER TOWER #2 (Connemara Water Tower) Equipment Parts Other Professional Services Telephone Costs Electric Utilities Other Contracted Repairs Maint Other Miscellaneous Charges Improvements Other Than Bldgs TOTAL WATER TOWER #4 (Bacardi Water Tower) Equipment Parts Other Professional Services Telephone Costs Electric Utilities Other Contracted Repairs Maint Other Miscellaneous Charges Improvements Other Than Bldgs TOTAL WATER TOWER #3 (East Side Water Tower) GRAND TOTAL ALL DEPTS. 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget 769 676 211 500 5,500 0 0 0 O 0 0 0 957 0 0 500 120 0 0 200 O 0 0 0 7,346 676 211 1,200 785 0 394 500 O 730 0 0 18 0 0 0 1,395 1,604 933 1,400 O 2,542 0 500 O 56 0 200 O 552,579 0 0 2,198 557,511 1,327 2,600 O 8,970 536 500 O 0 1,044 0 O 0 2,984 0 331 2,019 0 2,000 O 0 0 500 O 0 0 200 O 0 0 300 331 10,989 4,564 3,500 979 0 3,548 500 O 0 0 0 132 0 0 0 1,953 1,750 1,756 2,000 O 0 1,922 500 O 0 0 200 O 0 0 300 3,064 1,750 7,226 3,500 $863,591 $1,938,465 $964,445 $1,224,900 500 Touch -up Paint O Tower Inspection 0 500 200 Contingencies 5,000 Mixer 6,200 500 Touch -up Paint O Tower Inspection 0 1,400 500 200 Contingencies 5,000 Mixer 7,600 500 O Tower Inspection 0 2,000 500 200 Contingencies 300 Contingencies 3,500 500 O Tower Inspection 0 2,000 500 200 Contingencies 150,000 Interior Painting 153,200 $1,353,900 Comments Page One July 13, 2009 2010 BUDGET WORKSHEETS SEWER UTILITY REVENUES 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget FUND TOTALS $1,464,696 $1,549,898 $1,500,905 $1,502,400 $1,647,300 Comments 602 33425.00 Other State Grants Aids $0 $2,500 $0 $0 $0 602 34108.00 Administrative Fees -Other Funds 11,051 5,693 5,378 3,000 0 5% of 5% Fees -Const Projects 602 36101.00 Principal Special Assessments 54,093 57,251 65,559 50,000 50,000 602 36102.00 Penalties Interest S/A 3,021 2,318 771 0 0 602 36210.00 Interest Eamings Investments 106,066 102,710 94,216 90,000 90,000 602 36214.00 Net Change in FV- Investments (5,812) 35,821 5,640 0 0 Annual Market Value Changes 602 36215.00 Interest Eamings 297 288 840 400 400 602 36260.00 Other Revenues 0 0 0 0 0 60236265.00 Use of Reserve Funds 0 0 0 95,000 26,900 602 37210.00 Residential Sewer Revenues 1,134,471 1,169,455 1,122,524 1,100,000 1,270,000 602 37220.00 Apartment Sewer Revenues 63,806 81,053 87,525 70,000 90,000 602 37225.00 Institutional Sewer Revenues 22,879 22,291 22,669 25,000 25,000 602 37230.00 Commercial Sewer Revenues 54,448 55,087 53,466 55,000 55,000 602 37240.00 Industrial Sewer Revenues 5,434 4,143 29,574 4,000 30,000 602 37260.00 Penalties Sewer Revenues 14,941 11,288 12,742 10,000 10,000 602 39103.00 Gain or Loss from F/A Disposal 0 0 0 0 0 602 39203.00 Transfer From 0 0 0 0 0 Page One July 13, 2009 Account 602 49450 101.00 602 49450 77 101.00 602 49450 78 101.00 602 49450 79 101.00 602 49450 xx 101.00 602 49450 102.00 602 49450 103.00 602 49450 99 103.01 602 49450 99 103.02 602 49450 01 203.00 602 49450 01 209.00 602 49450 01 216.00 602 49450 01 219.00 602 49450 01 224.00 602 49450 01 225.00 602 49450 01 227.00 602 49450 01 241.00 602 49450 01 242.00 602 49450 01 303.00 602 49450 01 303.01 602 49450 01 303.02 602 49450 01 303.03 602 49450 01 303.04 602 49450 01 304.00 602 49450 01 312.00 602 49450 01 313.00 602 49450 01 318.00 602 49450 01 319.00 602 49450 01 319.01 602 49450 01 319.02 602 49450 01 319.03 602 49450 01 319.04 602 49450 01 321.00 602 49450 01 322.00 602 49450 01 323.00 602 49450 01 331.00 602 49450 01 333.00 602 49450 01 341.00 602 49450 01 349.00 602 49450 01 365.00 602 49450 01 369.00 602 49450 01 391.00 602 49450 01 392.00 602 49450 01 393.00 602 49450 01 394.00 602 49450 01 395.00 602 49450 01 403.00 602 49450 01 415.00 602 49450 01 416.00 602 49450 01 433.00 602 49450 01 435.00 602 49450 01 437.00 602 49450 01 439.00 602 49450 01 521.00 602 49450 01 530.00 602 49450 01 530.01 602 49450 01 530.02 602 49450 01 530.03 602 49450 01 530.04 602 49450 01 530.05 602 49450 01 530.06 602 49450 01 530.07 602 49450 01 530.08 602 49450 01 540.00 602 49450 01 560.00 602 49450 01 570.00 602 49450 01 602.00 602 49450 01 611.00 602 49450 01 710.00 2010 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES Description Salaries Benefits Administrative Technical/Clerical Maintenance Salary Benefit Contingency Full -Time Overtime Part-Time Salaries Benefits Utility Commission Wages (50 Maintenance Labor Printed Forms Paper Other Office Supplies Chemicals Chemical Products Other Operating Supplies Street Maintenance Materials Landscaping Materials Utility System Maintenance Supplie Small Tools Minor Equipment Engineering Fees GIS Update of Asbuilts Rate Study 42/52 Sewer Study Miscellaneous Legal Fees Gopher State One -Call Temporary Service Fees Contract Engineer Other Professional Services Televising Root Control Supervisory Controls(Maint Cont) Telephone Costs Postage Costs Radio Units Travel Expense Freight Express Expenses Employment Advertising Other Advertising Workers Comp Insurance Other Insurance P.C. Maintenance P.C. Accessories Supplies P C. Hardware Purchases P.C. Software Purchases P.C. Repairs Contracted R M Other lmpr Other Equipment Rental Machinery Rental Dues Subscriptions Books Pamphlets Conferences Seminars Other Miscellaneous Charges Building Structure Purchases Improvements Other Than Bldgs Miscellaneous Improvements Misc. Improvements /Repairs CRP of Sewermain Heavy Machinery Purchases Furniture Fixture Purchases Office Equipment Purchases Sewer Service Charges Interest on Lease Payments Transfers 602 49450 -01 TOTALS 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget 103,611 132,293 126,545 0 4,701 24,842 108,457 143,055 125,239 0 10,405 20,410 779 1,729 1,742 1,500 1,500 Inserts Water Bill Statements O 0 0 200 200 Disks, Ribbons, etc. O 0 0 500 500 Root Killer, Degreaser 112 0 0 200 200 116 2,160 637 2,500 2,500 Patching 685 19 0 400 400 Topsoil, Seed Sod 1,541 560 1,852 3,000 3,000 Manhole Castings 179 843 452 500 500 Wrenches, Shovels, etc. 2,428 6,697 2,935 3,000 3,000 0 17,983 0 0 85 3,985 4,085 9,000 0 0 196 0 1,181 3,684 846 0 0 0 0 5,138 11,899 337 0 3,423 2,663 0 0 0 4,538 2,277 0 4,851 0 0 0 (2,869) 0 500 1,674 15,158 10,319 0 0 3,269 1,021 3,000 0 0 532 0 1,530 3,673 1,422 0 0 0 0 5,499 11,319 2,026 0 0 1,215 0 0 5,059 0 0 14,435 0 7,273 16,851 21,928 0 0 0 100,622 150,848 127,753 0 6,825 9,758 7,245 0 9,974 1,786 0 3,500 0 6,000 1,890 73 7,436 0 3,013 3,975 150 0 0 0 0 5,612 10,595 2,340 171 985 2,500 0 434 0 0 0 0 0 0 0 0 0 0 109,500 164,400 140,700 0 10,000 9,000 7,000 0 0 5,000 500 7,000 0 9,000 3,000 2,000 3,000 0 1,500 3,500 500 200 100 300 500 5,000 15,000 1,000 200 4,000 5,000 500 0 10,000 10,000 0 150,000 0 0 0 0 0 0 500 500 1,313,336 1,530,162 1,261,745 1,470,900 108,300 164,700 137,200 Comments All Salary Costs Inclusive of $410,200 Salary, Taxes, PERA Benefits 10,700 7,500 9,000 1,000 50% 602; 50% 601 8,000 100% 602 7,000 0 0 15,000 3,000 2,000 5,000 0 10,000 0 150,000 0 0 0 0 0 22,000 1,610,200 Sewer Repairs 500 4,000 Gopher State One -Call (M) 0 6,000 Contracted Engineer for City(20 10,000 SCADA System 2,200 Cell Phones, Modems, GPS 3,500 Billings with Inserts 1,300 800 MHZ Monthly Charges 200 Use 437.00 100 Mail -in Repairs 300 P/T'ers Personnel Changes 500 6,000 Sewers Share of Premiums 15,000 Sewers Share of Premiums 3,000 Auto Read Software Support 200 3,000 Laptops (Split) 6,000 CarteGraph ESRI Maintenance 500 2,200 3,713 0 2,000 2,000 O 0 0 200 200 O 0 0 2,000 2,000 23 96 100 100 100 Suburban UtlI. Supt. Ass'n(50 O 0 0 300 300 Reference Materials 23 833 962 1,000 1,000 Sewer School, 50% Split with 601 115 145 145 100 100 Contingencies 10,000 Pymt on P.W. Building (12 of 20) 160,000 Annual Pavement Management 0 500 500 672,585 721,350 785,283 775,000 900,000 MWCC Charges 4,697 4,432 4,153 0 0 P.W. Building Expansion(See 521) 162,061 252,815 0 0 0 Transfers for Other Improvements Page Two July 13, 2009 Account 2010 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES Description 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget 602 49451 01 219.00 Other Operating Supplies 358 0 0 100 100 602 49451 01 221.00 Equipment Parts 726 0 7,286 800 800 602 49451 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49451 01 321.00 Telephone Costs 18 0 0 0 0 602 49451 01 381.00 Electric Utilities 786 1,038 1,445 800 1,500 602 49451 01 403.00 Contracted R M Other lmpr 0 0 0 200 200 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (City Hall) TOTAL LIFT STATION #1 1,888 1,038 8,731 2,200 2,900 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49452 01 221.00 Equipment Parts 1,104 1,732 0 800 800 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49452 01 321.00 Telephone Costs 211 211 211 0 0 602 49452 01 381.00 Electric Utilities 438 456 485 800 500 602 49452 01 403.00 Contracted R M Other lmpr 0 0 0 200 200 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Bbomfield 5th) TOTAL LIFT STATION #7 1,753 2,399 696 2,200 1,900 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49453 01 221.00 Equipment Parts 5,940 240 8,330 800 800 602 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49453 01 321.00 Telephone Costs 18 0 0 0 0 602 49453 01 381.00 Electric Utilities 3,495 2,804 3,052 5,000 3,500 602 49453 01 403.00 Contracted R M Other Impr 0 0 0 200 200 602 49453 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Shannon Pond) TOTAL LIFT STATION #3 9,453 3,044 11,382 6,400 4,900 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49454 01 221.00 Equipment Parts 293 0 2,548 800 800 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49454 01 321.00 Telephone Costs 18 0 0 0 0 602 49454 01 381.00 Electric Utilities 2,542 3,403 3,877 5,000 4,000 602 49454 01 403.00 Contracted R M Other lmpr 0 0 0 200 200 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Hawkins) TOTAL LIFT STATION #4 2,852 3,403 6,425 6,400 5,400 Comments 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49455 01 221.00 Equipment Parts 2,053 15,746 962 800 800 602 49455 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49455 01 321.00 Telephone Costs 18 0 0 0 0 602 49455 01 381.00 Electric Utilities 4,024 4,593 5,702 5,000 6,000 602 49455 01 403.00 Contracted R M Other Impr 0 0 0 200 200 602 49455 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (LeForet Add'n) TOTAL LIFT STATION #5 6,095 20,338 6,664 6,400 7,400 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49456 01 221.00 Equipment Parts 6,379 0 229 800 800 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49456 01 321.00 Telephone Costs 14 0 0 0 0 602 49456 01 381.00 Electric Utilities 540 1,487 7,364 800 7,500 602 49456 01 403.00 Contracted R M Other Impr 0 0 0 200 200 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Drumcliffe) TOTAL LIFT STATION #6 6,934 1,487 7,593 2,200 8,900 Page Three 2010 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES July 13, 2009 2009 2010 Objecl 2010 2006 2007 2008 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 175 922 546 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 272 354 469 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 (Glendalough 5th) TOTAL LIFT STATION #9 447 1,276 1,015 1,900 1,900 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49458 01 221.00 Equipment Parts 939 356 211 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 285 362 388 800 800 602 49458 01 403.00 Contracted R M Other Impr 0 0 0 200 200 602 49458 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Meadows of) TOTAL LIFT STATION #8 1,224 718 599 1,900 1,900 (Bloomfield) 602 49460 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49460 01 221.00 Equipment Parts 0 1,062 211 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 0 160 145 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 0 1,222 356 1,900 1,900 GRAND TOTAL ALL DEPTS. $1,343,983 $1,565,087 $1,305,205 $1,502,400 $1,647,300 Page One 2010 BUDGET WORKSHEETS STORM WATER UTILITY REVENUES July 13, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget FUND TOTALS $758,101 $828,226 $815,663 $777,300 $829,300 Comments 603 33425.00 Other State Grants Aids $0 $2,500 $0 $0 603 34108.00 Administrative Fees -Other Funds 11,051 5,693 5,378 3,000 0 5% of 5% Fees -Const Projects 603 36101.00 Principal Special Assessments 15,777 12,617 17,405 10,000 10,000 603 36102.00 Penalties Interest S/A 722 386 278 0 0 603 36210.00 Interest Eamings Investments 58,397 62,368 39,863 60,000 40,000 603 36214.00 Net Change in FV- Investments (252) 9,008 491 0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 344 303 283 300 300 603 36260.00 Other Revenues 0 0 2,000 0 0 603 36265.00 Use of Reserve Funds 0 0 0 0 0 603 37300.00 Storm Water Utility Revenues 665,905 731,323 745,805 700,000 775,000 603 37360.00 Penalties Storm Water Utility 6,157 4,027 4,159 4,000 4,000 603 39203.00 Transfer From 0 0 0 0 0 Page One July 13, 2009 Account 603 49500 101.00 Salaries Benefits 603 49500 77 101.00 Administrative 603 49500 78 101.00 Technical/Clerical 603 49500 79 101.00 Maintenance 603 49500 xx 101.00 Salary Benefit Contingency 603 49500 102.00 Full -Time Overtime 603 49500 99 103.00 Part-Time Salaries Benefits 603 49500 01 203.00 603 49500 01 204.00 603 49500 01 205.00 603 49500 01 208.00 603 49500 01 215.00 603 49500 01 219.00 603 49500 01 221.00 603 49500 01 224.00 603 49500 01 225.00 603 49500 01 225.01 603 49500 01 225.02 603 49500 01 225.03 603 49500 01 226.00 603 49500 01 230.00 603 49500 01 241.00 603 49500 01 242.00 603 49500 01 303.00 603 49500 01 303.01 603 49500 01 303.02 603 49500 01 303.03 603 49500 01 303.04 603 49500 01 304.00 603 49500 01 310.00 603 49500 01 312.00 603 49500 01 313.00 603 49500 01 315.00 603 49500 01 318.00 603 49500 01 319.00 603 49500 01 321.00 603 49500 01 322.00 603 49500 01 323.00 603 49500 01 331.00 603 49500 01 352.00 603 49500 01 365.00 603 49500 01 369.00 603 49500 01 384.00 603 49500 01 389.00 603 49500 01 391.00 603 49500 01 393.00 603 49500 01 394.00 603 49500 01 403.00 603 49500 01 403.01 603 49500 01 403.02 603 49500 01 404.00 603 49500 01 416.00 603 49500 01 433.00 603 49500 01 435.00 603 49500 01 437.00 603 49500 01 437.01 603 49500 01 437.02 603 49500 01 437.03 603 49500 01 439.00 603 49500 01 530.00 603 49500 01 530.01 603 49500 01 530.02 603 49500 01 530.03 603 49500 01 530.04 603 49500 01 540.00 603 49500 01 560.00 603 49500 01 580.00 603 49500 01 586.00 2010 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES Description Printed Forms Paper Envelopes Letterhead Drafting Supplies Miscellaneous Supplies Shop Materials Other Operating Supplies Equipment Parts Street Maintenance Materials Landscaping Materials Rip -Rap, Matting, Rock, etc. Black Dirt, Seet, Sod, etc. Sign Repair Materials Equipment Repair Material Small Tools Minor Equipment Engineering Fees Problem Area Investigations NPDES Phase II CSMP Update Miscellaneous Legal Fees Testing Services Contract Inspection Fees Temporary Service Fees Special Programs (County Program) Contract Engineer Other Professional Services Telephone Costs Postage Costs Radio Units Travel Expense General Notices Public Info Workers Comp Insurance Other Insurance Refuse Disposal Other Utility Services P.C. Maintenance P.C. Hardware Purchases P.C. Software Purchases Contracted R M Other lmpr Ditching Miscellaneous Repairs Contracted Mach Equip Repairs Machinery Rental Dues Subscriptions Books Pamphlets Conferences Seminars Storm Water Management Hydrocad Training Wetlands Training Other Miscellaneous Charges Improvements Other Than Bldgs CRP of Storm Sewer Heavy Machinery Purchases Fumiture Fixture Purchases Other Equipment Purchases Computer Equipment Purchases PAGE TOTALS 2006 2007 Actual Actual 31,486 96,644 27,441 55,281 O 63,466 O 459 O 6,094 O 0 0 0 2,723 681 3,850 3,850 9,000 3,000 844 0 O 0 3,684 3,673 503 339 O 0 O 0 2,019 2,162 6,349 6,029 O 0 O 0 337 2,026 3,423 0 2,663 1,215 2009 2010 Object 2010 2008 Adopted Detail Proposed Actual Budget Amount Budget 70,000 69,780 10,000 10,000 22,097 30,000 30,000 2,318 0 0 26,464 30,000 30,000 O 2,000 2,000 O 1,000 1,000 O 500 500 O 0 0 3,850 5,000 5,000 6,000 9,000 6,000 O 3,000 5,000 O 0 2,200 3,975 3,000 5,000 150 600 1,300 O 200 200 O 1,000 1,000 2,232 3,500 3,500 5,660 6,000 6,000 O 600 600 O 500 500 2,340 1,000 3,000 1,145 4,000 3,000 O 5,000 6,000 301,283 596,004 344,221 529,200 534,800 Comments All Salary Costs Inclusive of $166,000 Salary, Taxes, PERA Benefits O 0 0 0 0 77,793 85,070 87,908 97,300 97,400 63,273 62,620 63,876 70,400 68,600 O 0 0 0 4,400 2,526 5,372 3,602 10,000 6,000 O 0 0 8,000 8,000 779 1,729 1,742 1,500 1,500 0 0 0 0 0 0 0 0 0 0 O 0 0 1,600 1,600 Stakes, Ribbons, Level, etc. O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 536 2,292 3,798 2,000 2,000 Blacktop Gravel Washouts 4,000 O 2,174 4,940 3,000 3,000 0 11 5 1,000 1,000 0 0 0 0 0 0 0 223 500 500 134 236 959 1,000 1,000 581 152 920 1,000 1,000 O 0 255 0 2,000 Misc. Nozzles for Vac Truck Water Quality Tests (M) 3rd Part Inspection Program (M) Wetland Health Evaluation Proj Contracted Engineer for City(20 SCADA Cell Phones, Moderns, GPS Billings Info Mailings 800 MHZ Monthly Charges Public Info Brochure Storm Water's Share of Premiums Storm Water's Share of Premiums Roadside Debris Hazardous Materials Disposal Auto Read Software Support Laptops (Split) CarteGraph ESRI Maintenance 55,000 O 0 0 5,000 5,000 36,496 151,306 26,217 50,000 50,000 Storm Maintenance Work O 0 0 1,000 0 O 401 0 5,000 5,000 Pumps 976 976 140 0 0 13 0 0 500 500 Utility Information 1,500 25 42 875 1,000 1,000 MN Cities Stormwater Collaboration O 0 0 0 0 O 0 0 500 500 115 145 145 0 0 2,277 150,000 O 0 2,603 150,000 150,000 Annual Pavement Management O 7,273 0 0 0 O 14,435 0 0 0 O 16,851 0 0 0 21,438 0 0 0 0 O 0 0 500 500 O 0 0 2,000 2,000 O 0 0 500 500 Page Two July 13, 2009 Account 603 49500 01 710.00 603 49500 01 710.01 603 49500 01 710.02 603 49500 01 710.03 603 49500 01 710.04 603 49500 01 710.05 603 49500 01 710.06 603 49500 01 710.07 603 49500 01 710.10 Description 603 49511 01 221.00 Equipment Paris 603 49511 01 321.00 Telephone Costs 603 49511 01 381.00 Electric Utilities 603 49512 01 221.00 Equipment Parts 603 49512 01 321.00 Telephone Costs 603 49512 01 381.00 Electric Utilities (Schwarz Pond) 603 49513 01 221.00 Equipment Parts 603 49513 01 321.00 Telephone Costs 603 49513 01 381.00 Electric Utilities (Birger Pond) 603 49514 01 221.00 Equipment Parts 603 49514 01 321.00 Telephone Costs 603 49514 01 381.00 Electric Utilities (Marcotte Pond) 603 49515 01 221.00 Equipment Parts 603 49515 01 321.00 Telephone Costs 603 49515 01 381.00 Electric Utilities 603 49516 01 221.00 Equipment Parts 603 49516 01 321.00 Telephone Costs 603 49516 01 381.00 Electric Utilities 2010 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES Transfers 1/2 of 2008 P I Payments(1996B) 1/2 of 2008 P I Payments(1999C) 1/2 of 2008 P I Payments(2001B) 1/2 of 2008 P I Payments(2001D) 1/2 of 2008 P I Payments(2002B) 1/2 of 2008 P I Payments(2002C) 1/2 of 2008 P I Payments(2003A) Projects 603- 49500 -01 TOTALS (Copper Pond) TOTAL LIFT STATION #1 TOTAL LIFT STATION #2 TOTAL LIFT STATION #3 TOTAL LIFT STATION #4 (Hawkins Pond) TOTAL LIFT STATION #5 (Glendalough 7th) TOTAL LIFT STATION #6 GRAND TOTAL ALL DEPTS. 2006 2007 2008 Actual Actual Actual 2009 2010 Object 2010 Adopted Detail Proposed Budget Amount Budget 125,000 50,000 52,000 83,000 0 0 Bonds Called 2/1/08 41,000 43,000 16,500 0 0 Bonds Called 2/1/08 54,000 53,000 54,000 53,000 54,000 77,000 75,000 70,000 0 0 Bonds Paid off 2/1/08 29,000 29,000 28,000 28,000 29,000 Storm Share of Water /Storm Issue 26,000 25,000 0 0 0 Bonds Defeased 3/1/07 44,000 44,000 42,000 42,000 42,000 Storm Share of Connemara Proj. 200,811 186,144 0 0 0 823,094 1,103,148 637,721 652,200 659,800 185 0 211 500 500 18 0 0 0 0 193 224 206 500 500 395 224 416 1,000 1,000 360 0 211 500 500 18 0 0 0 0 O 0 0 500 500 378 0 211 1,000 1,000 98 0 211 1,000 1,000 Comments 418 1,362 211 500 500 35 0 0 0 0 2,211 2,968 3,352 5,000 3,500 2,664 4,329 3,563 5,500 4,000 185 0 1,651 500 500 4 0 0 0 0 135 372 1,964 3,500 2,000 324 372 3,615 4,000 2,500 98 0 211 500 500 O 0 0 0 0 O 0 0 500 500 22 0 211 500 500 O 0 0 0 0 O 245 219 500 500 22 245 430 1,000 1,000 $826,974 $1,108,318 $646,166 $665,700 $670,300 Page One 2010 BUDGET WORKSHEETS ARENA REVENUES July 15, 2009 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 650 36210.00 Interest Earnings Investments $0 $0 $0 $0 650 36215.00 Interest Earnings 3 0 47 100 100 650 36260.00 Other Revenue Learn to Skate 38,823 32,075 44,774 35,000 35,000 Leam to Skate Program (LTS) 650 36265.00 Use of Reserve Funds 0 0 0 0 0 650 38060.00 Prime Time Ice Fees 207,851 216,710 221,861 220,000 220,000 650 38061.00 Non -Prime Time Ice Fees 69,733 76,677 81,056 75,000 75,000 650 38063.00 Open Skating Ice Fees 9,599 9,864 8,917 9,000 9,000 650 38064.00 Broomball Revenues 0 5,761 8,220 0 0 Moved to Prime /Non -Prime Times 650 38065.00 Other Events Arena 0 0 0 0 0 Dry Floor Events 650 38066.00 Advertising Revenue Arena 4,820 13,500 7,700 10,000 10,000 650 38067.00 Skate Sharpening Revenue Arena 5,196 5,472 4,672 5,500 5,500 650 38090.00 Concessions 3,900 3,900 3,900 3,900 3,900 650 38091.00 Vending Machine Revenues 10,702 8,367 8,472 10,000 10,000 650 38095.00 Pro Shop Revenues 1,184 1,178 1,058 1,200 1,200 Tape, Laces, Mouthguards, etc. 650 39103.00 Gain or Loss from F/A Disposal 0 0 0 0 0 650 39201.00 Transfer From General Fund 0 100,000 165,000 115,000 115,000 Subsidy for Operations FUND TOTALS 351,811 473,504 555,678 484,700 484,700 Page One July 15, 2009 2010 BUDGET WORKSHEETS ARENA EXPENDITURES 2009 2010 Object 2010 2006 2007 2008 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 650 45130 101.00 Salaries Benefits $132,300 Salary, Taxes, PERA Benefits 650 45130 77 101.00 Administrative 36,329 34,081 29,814 36,500 36,800 650 45130 78 101.00 Technical /Clerical 26,193 26,936 28,383 33,800 34,100 650 45130 79 101.00 Maintenance 91,489 96,916 89,495 60,600 61,400 650 45130 xx 101.00 Salary Benefit Contingency 0 0 0 0 3,700 650 45130 79 102.00 Full -Time Overtime 5,393 5,180 3,826 4,700 4,700 650 45130 103.00 Part -Time Salaries Benefits 47,000 650 45130 89 103.00 Leam To-Skate Program 27,785 27,100 24,985 27,000 27,000 650 45130 99 103.00 Building Attendants 18,386 15,392 33,493 15,000 20,000 And Other P/T Positions 650 45130 01 207.00 Training Instructional Supplies 0 0 0 200 100 650 45130 01 208.00 Miscellaneous Supplies 700 650 45130 01 208.01 Skate Magnets 0 0 0 200 100 650 45130 01 208.02 Other Supplies 51 0 418 800 600 650 45130 01 209.00 Other Office Supplies 407 575 687 500 500 Leam to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 3,605 3,302 3,811 4,000 4,000 650 45130 01 212.00 Motor Fuels 2,400 0 0 2,400 0 Zamboni Maint. (Every 3rd Year) 650 45130 01 216.00 Chemicals Chemical Products 3,200 2,814 2,528 3,200 3,000 Assorted Products 650 45130 01 219.00 Other Operating Supplies 269 434 16 1,000 500 Events Supplies 650 45130 01 221.00 Equipment Parts 2,983 2,605 4,302 4,000 4,000 650 45130 01 223.00 Building Repair Supplies 2,544 1,444 1,952 4,000 3,000 650 45130 01 265.00 Other Items for Resale 544 515 600 600 600 Pro Shop Supplies 650 45130 01 305.00 Medical Dental Fees 0 0 0 500 0 650 45130 01 311.00 Officiating Fees 0 2,075 1,080 2,400 0 650 45130 01 317.00 General Fund Admin Fees 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Admin Fee Policy 650 45130 01 321.00 Telephone Costs 1,000 1,000 1,000 1,000 1,000 650 45130 01 331.00 Travel Expense 0 0 0 100 100 650 45130 01 341.00 Employment Advertising 0 0 0 500 0 650 45130 01 349.00 Other Advertising 98 210 284 800 400 650 45130 01 365.00 Workers Comp Insurance 2,488 2,691 2,994 2,500 3,200 650 45130 01 369.00 Other Insurance 7,789 7,746 7,772 8,000 8,000 650 45130 01 381.00 Electric Utilities 109,878 114,332 110,858 115,000 120,000 650 45130 01 383.00 Gas Utilities 31,488 34,232 37,862 50,000 45,000 650 45130 01 384.00 Refuse Disposal 2,962 3,455 3,613 3,500 3,500 650 45130 01 401.00 Contracted Building Repairs 4,359 13,014 3,096 5,000 5,000 650 45130 01 404.00 Contracted Mach Equip Repairs 15,482 11,028 16,101 15,000 15,000 650 45130 01 415.00 Other Equipment Rental 0 0 0 300 300 650 45130 01 433.00 Dues Subscriptions 450 475 350 900 500 MIAMA MRPA Dues 650 45130 01 437.00 Conferences Seminars 0 0 0 400 400 MIAMA Seminars 650 45130 01 439.00 Other Miscellaneous Charges 0 0 0 500 0 Contingencies 650 45130 01 521.00 Building Structure Purchases 0 0 64,921 0 0 650 45130 01 580.00 Other Equipment Purchases 0 0 2,822 0 42,000 New Compressors 650 45130 01 710.00 Transfers 3,500 650 45130 01 710.01 Yearly Maintenance 3,500 3,500 3,500 3,500 3,500 650 45130 01 710.02 0 0 0 0 0 650 45130 01 710.03 0 0 0 0 0 FUND TOTALS 407,071 417,050 486,563 414,400 458,000 dc0_ s Ic 1/x•10 1 Tb- Possible Strategies to Reduce the Tax Rate 2ODcklet- N cc f BS I 1. Need to reduce the proposed tax levy by an estimated additional $336,000 to get the same tax rate as 2009. 2. Items that could be reduced and comments (not necessarily in order). a. Apply all SKB money to saving operating levy ($100,000). Comment: This was not recommended by staff because we have historically used $200,000 from SKB for capital items such as St. Joe's or previously our Street Maintenance CIP fund and we have already reduced this to only $100,000. The City needs to keep a reasonable balance between capital needs and operating needs. b. Reduce the line item in the Streets budget for the construction of new trails and sidewalks. ($100,000). Comment: This could be done, but in a year or two we will probably want to restore funding for the construction of sidewalks and trails. We will then need to increase taxes perhaps even more than the current level at that time compared with keeping a steady, predictable funding level now. Finally, these funds have been identified as a likely source of matching funds for several pending grant applications. c. Reduce the contingency for personnel and benefit costs. (up to $100,000 Comment: Some reduction might be possible by December when some or all labor contracts may be settled. Salaries are only partially under our control since state arbitrators can and do impose wage increases for "essential" workers such as the police. We also do not have much control over health insurance increases and won't know the renewal rate until about August 20 d. Reduce the Equipment CIP levy. ($201,000). Comments: We are not proposing many new vehicles for 2010, so this levy could be lowered in the short run. However, studies of our long range vehicle replacement needs -even assuming a significantly longer replacement cycle -show that we need all of the current levy and also need to include the levies of expiring equipment certificates in future years for this fund. So, reducing this levy, similar to item b above, would result in a larger tax increase in the future. e. Do not proceed with opening of St. Joe's. ($20,000). Comment: This item saves only $20,000, since we would need to pay utilities for the church next year whether it is open or not. The capital dollars for the renovations are not coming from the proposed levy, and therefore would not help lower the 2010 levy. f. Reduce personnel. ($36,000 per person Comment: Workload indicators (such as total number of permits and inspections) do not show significantly decreased workload from last year. Planning work to update codes is still needed. Engineering work is handled mostly by contract where we pay by the project. Any savings in salaries are offset by almost 50% due to the need to pay unemployment benefits to anyone laid off. Less experienced staff would eventually be added back, potentially reducing efficiency.