The URL can be used to link to this page

Home My WebLink About2.b. Budget DiscussionAGENDA ITEM: Budget Discussion AGENDA SECTION: Discussion PREPARED BY: Kim Lindquist, Acting City Administrator AGENDA NO. 2.B. ATTACHMENTS: Draft Budget and CIP APPROVED BY: lb RECOMMENDED ACTION: Discussion Only 4 ROSEMOUNT CITY COUNCIL City Council Work Session: August 13, 2008 EXECUTIVE SUMMARY DISCUSSION The Council discussed the draft budget at work sessions in June and July. Adjustments have been made to the budget reflecting those discussions which are in the attached draft. Unfortunately, the County has been unable to provide us with additional information which will give us the final numbers on fiscal disparities and the tax increment tax capacity. We are also awaiting the final numbers relating to household growth. The attached draft budget reflects modifications to the specific line items listed below but it is expected that further modifications will need to be made when those numbers are available. Under the current condition, the general levy increases by 5.1% but the total levy increases by .88 The tax rate chart, in yellow, shows a slight decrease in the tax rate of 0.10 From a timing standpoint it was hoped that this would be the final budget discussion prior to setting of the preliminary budget levy. If the above numbers come back from the County warranting significant changes to the budget another meeting may be necessary prior to taking action on September 2, 2008. Another option is to have a special meeting on the 10 prior to diving into the work session items. The preliminary levy must be approved and forwarded to the County by September 15. If the numbers are not a dramatic departure from the current figures, staff can make some minor modifications to the budget to keep the tax rate flat, a stated goal for the 2009 budget. BUDGET CHANGES Operating Budget The following lists the items changed in the attached draft budget: Decrease by $40,000 from the Parks and Grounds Maintenance Budget due to scheduling of maintenance activities on a 5 -year cycle. Decrease the administration budget by $10,500 due to shifting all the safety consultant costs to the insurance budget. Decrease the administration budget by $2000 from the Cable Commission dues and add an additional $2000 to allow purchase of an additional historic plaque in 2009. Decrease in finance budget by $15,100 due to maintaining the deputy registrar position as part- time. Increase of $40,000 in recognition of rising natural gas prices. The increase is spread over three budgets, government buildings ($10,000), community center ($15,000) and ice arena ($15,000). There is $45,000 set aside in the Parks and Recreation budget for some type of program expansion. While staff has not completed all the listening sessions with the various senior groups, there are some themes that are emerging. One is that the different senior housing groups do not "mingle" with the Rosemount Area Seniors which results in some program redundancy. In other words a senior housing project like Cameo Place is providing some activities that the City is also providing. Additionally, if more seniors had access to transportation, it appears they would participate in some of the programs currently being offered by the City. Finally, based upon stated interest, there may be additional programming opportunities that would benefit both the Rosemount Area Seniors and seniors within the various housing complexes. In reliance on this preliminary information, staff is suggesting using approximately $30,000 to allocate to a part -time program coordinator. This 20 -hour a week coordinator would work with all seniors in the community, not just focus on the existing Rosemount Area Senior group. The Council has indicated they would like to assist the seniors more; staff believes this is one way to service more of the exiting Rosemount senior population and not one specific organized group. It is understood that the Rosemount Area Seniors Group has indicated that they would prefer their own building space outside of the Community Center. While St. Joseph's school, church or gathering space may be an option, that space will not be available until next summer. Meanwhile the programmer could begin to provide services that would serve a greater population than the current condition. Capital Improvement Program There have been several minor modifications to the CIP in reaction to discussions by the Council and a more careful assessment of vehicle replacement. Overall the CIP levy will decrease by $30,000 under the current proposal from what was previously presented to the Council. Staff is recommending maintenance of $70,000 as a placeholder to assist in future purchases, recognizing that 2010 and 2011 undoubtedly will be more financially difficult for the City. The goal, similar to the parks and grounds budget and government buildings budget, staff is trying to level the projected expenditures so there is a less variation in the levy over time. Under the current CIP it is not anticipated that equipment certificates will be used. As the Council reviews the budget, please note that equipment certificate payments drop from the expenditures. The one exception is in 2011. Staff will be recommending that equipment certificates be used for significant equipment purchases like the tender truck and fire engine currently listed. Further discussion regarding these two purchases, and the projected city share of the 42/52 interchange project, will be necessary to address a projected CIP levy of just over $2,000,000 in 2011. Other changes include: Shift in the CIP of $200,000 from the Pavement Management program to St. Joes in 2009. The $200,000 is the amount projected from SKB under the current financing agreement. It is anticipated that additional modifications will be made based upon the discussion on St. Joes also scheduled for the 13 Remove purchase of two fire trucks in 2009 equipment CIP. The two trucks were shifted to 2014 in the CIP. Increase building CIP by $5000 for Library enhancement. RECOMMENDATION Provide Staff direction. 2 Page One August 13, 2008 2009 BUDGET WORKSHEETS ARENA EXPENDITURES 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 650 45130 101.00 Salaries Benefits $132,800 Salary, Taxes, PERA Benefits 650 45130 77 101.00 Administrative 12,281 36,329 34,081 35,300 36,900 650 45130 78 101.00 Technical/Clerical 44,193 26,193 26,936 28,300 34,400 650 45130 79 101.00 Maintenance 87,352 91,489 96,916 101,700 61,500 650 45130 79 102.00 Full -Time Overtime 4,642 5,393 5,180 4,700 4,700 650 45130 103.00 Part-Time Salaries Benefits 42,000 650 45130 89 103.00 Leam To-Skate Program 25,290 27,785 27,100 27,000 27,000 650 45130 99 103.00 Building Skate Guard Attendant 15,245 18,386 15,392 15,000 15,000 650 45130 01 207.00 Training Instructional Supplies 0 0 0 200 200 650 45130 01 208.00 Miscellaneous Supplies 1,000 650 45130 01 208.01 Skate Magnets 234 0 0 200 200 650 45130 01 208.02 Other Supplies 0 51 0 800 800 650 45130 01 209.00 Other Office Supplies 110 407 575 500 500 Leam to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 3,139 3,605 3,302 4,000 4,000 650 45130 01 212.00 Motor Fuels 2,323 2,400 0 2,400 2,400 Battery for Maintenance 650 45130 01 216.00 Chemicals Chemical Products 2,483 3,200 2,814 3,200 3,200 Assorted Products 650 45130 01 219.00 Other Operating Supplies 29 269 434 1,000 1,000 Events Supplies 650 45130 01 221.00 Equipment Parts 1,600 2,983 2,605 4,000 4,000 650 45130 01 223.00 Building Repair Supplies 535 2,544 1,444 4,000 4,000 650 45130 01 241.00 Small Tools 0 0 0 0 0 650 45130 01 242.00 Minor Equipment 0 0 0 0 0 650 45130 01 265.00 Other Items for Resale 662 544 515 800 600 Pro Shop Supplies 650 45130 01 305.00 Medical Dental Fees 0 0 0 500 500 650 45130 01 311.00 Officiating Fees 0 0 2,075 2,400 2,400 Broomball Leagues Referees 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 500 650 45130 01 349.00 Other Advertising 93 98 210 800 800 650 45130 01 385.00 Workers Comp Insurance 2,091 2,488 2,691 2,500 2,500 650 45130 01 369.00 Other Insurance 6,552 7,789 7,746 13,000 8,000 650 45130 01 381.00 Electric Utilities 101,374 109,878 114,332 101,000 115,000 650 45130 01 383.00 Gas Utilities 34,957 31,488 34,232 33,000 50,000 650 45130 01 384.00 Refuse Disposal 2,881 2,962 3,455 3,500 3,500 650 45130 01 401.00 Contracted Building Repairs 6,212 4,359 13,014 5,000 5,000 650 45130 01 404.00 Contracted Mach Equip Repairs 26,933 15,482 11,028 15,000 15,000 650 45130 01 415.00 Other Equipment Rental 0 0 0 300 300 650 45130 01 433.00 Dues Subscriptions 592 450 475 900 900 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 500 Contingencies 650 45130 01 521.00 Building Structure Purchases 0 0 0 90,000 0 650 45130 01 580.00 Other Equipment Purchases 0 0 0 9,000 0 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 7,800 0 0 0 0 650 45130 01 710.03 3,200 0 0 0 0 FUND TOTALS 403,301 407,071 417,050 522,000 416,300 August 13, 2008 Departments FUNDING REQUIREMENTS USES (INCLUDING FIRE STATION LEVY) 2008 2009 Adopted Proposed Budget Budget Difference Percentage Council Budget $673,500 $283,200 ($390,300) 57.95% Administration Budget 542,000 556,400 14,400 2.66% Elections Budget 61,800 40,000 (21,800) 35.28% Finance Budget 448,400 422,900 (25,500) 5.69% General Govemment Budget 395,000 403,300 8,300 2.10% Community Development Budget 930,300 932,600 2,300 0.25% Police Budget 2,812,000 2,994,300 182,300 6.48% Fire Budget 318,500 289,000 (29,500) -9.26% Public Works Operating Budgets: Govemment Buildings Budget 526,500 502,000 (24,500) -4.65% Fleet Maintenance Budget 504,600 578,500 73,900 14.65% Street Maintenance Budget 1,206,100 1,301,400 95,300 7.90% Parks Maintenance Budget 769,400 688,100 (81,300) 10.57% Park Rec Budget General Operating 1,093,500 1,154,400 60,900 5.57% Park Rec Budget Special Programs 128,300 123,700 (4,600) -3.59% Transfers Arena Assistance 165,000 115,000 (50,000) 30.30% Total Operating Budgets General Fund $10,574,900 $10,384,800 ($190,100) 4.80% Building CIP Requirements 124,000 84,000 (40,000) 32.26% Street CIP Requirements 765,000 765,000 0 0.00% Equipment CIP Requirements 221 ,000 445,000 224,000 101.36% Insurance Budget Requirements 275,000 275,000 0 0.00% Port Authority Operating Levy 50,000 50,000 0 100.00% Bonded Indebtedness 1,433,000 1,252,293 (180,707) 12.61% Bonded Indebtedness Fire Station Levy 144,417 146,084 1,667 1.15% Armory Anticipatory Levy (Value 2/21/08) 283,795 80,000 (203,795) 71.81% "195,000 ($2,374,641,200 x .00798 Water Enterprise Fund 1,164,000 1,224,900 60,900 5.23% Sewer Enterprise Fund 1,480,100 1,502,400 22,300 1.51% Storm Water Enterprise Fund 818,100 665,700 (152,400) 18.63% Arena Enterprise Fund 522,000 416,300 (105,700) 20.25% Total Funding Requirements $17,855,312 $17,291,477 ($563,835) -3.16% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. August 13, 2008 Types 2008 2009 Adopted Proposed Budget Budget Difference Percentage Levy Sources: Special Levies General Levy Total Levy Loss of MVHC from State Funding Total Revenue Sources FUNDING REQUIREMENTS SOURCES (INCLUDING FIRE STATION LEVY) Internal Revenue Generated: Licenses and Permits 572,600 486,600 (86,000) 15.02% Intergovernmental 596,000 616,000 20,000 3.36% Charges for Services 822,400 679,100 (143,300) 17.42% Fines Forfeits 90,000 110,000 20,000 22.22% Recreational Fees 248,600 253,800 5,200 2.09% Miscellaneous Revenues 209,000 254,500 45,500 21.77% Transfers In 3,500 3,500 0 0.00% Enterprise Revenues 3,984,200 3,809,300 (174,900) -4.39% Total Internal Revenues 6,526,300 6,212,800 (313,500) -4.80% MVHC Cuts Made Later To Include in Levy 350,330 1,861,212 1,478,377 (382,835) 20.57% 9,467,800 9,950,630 482,830 5.10% $11,329,012 $11,429,007 $99,995 0.88% $0 $350,330 $350,330 rda $17,855,312 $17,291,477 ($563,835) -3.16% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. 2008 GENERAL PROPERTY TAX LEVY PAYABLE 2009 GENERAL LEVY GENERAL FUND $8,331,630 BUILDING CIP FUND $84,000 STREET CIP FUND $765,000 EQUIPMENT CIP FUND $445,000 INSURANCE FUND $275,000 PORT AUTHORITY OPERATING LEVY $50,000 TOTAL GENERAL LEVY $9,950,630 BONDED INDEBTEDNESS G.O. MUNICIPAL BUILDING REFUNDING BONDS 1998A (Authorized $248,908) (Call 2/1/09) $0 G.O. PUBLIC FACILITY BONDS 2001C (Port Authority) (Authorized $172,074) $172,074 G.O. COMMUNITY CENTER REFUNDING BONDS 2001E (Authorized $93,713) $93,713 G.O. IMPROVEMENT BONDS 2003A (Authorized $86,354) (City Assumed Special Assessments) $86,354 G.O. CAPITAL IMPROVEMENT PLAN (CIP) BONDS 2005A (Authorized $208,454) $208,454 G.O. EQUIPMENT CERTIFICATES 2005B (Authorized $346,290) $346,290 G.O. EQUIPMENT CERTIFICATES 2006A (Authorized $87,767) $87,767 G.O. IMPROVEMENT BONDS 2006B (Authorized $268,690) G.O. EQUIPMENT CERTIFICATES 2007B (Authorized $102,908) $102,908 PUBLIC SAFETY REVENUE BONDS 2007 (Dakota Communications Center) (Authorized $64,733) $64,733 G.O. EQUIPMENT CERTIFICATES 2008A (Estimated $90,000) $90,000 TOTAL BONDED INDEBTEDNESS $1,252,293 MARKET VALUE BASED REFERENDUMS G.O. FIRE STATION REFUNDING BONDS, 2005D (Authorized $146,084) TOTAL FIRE STATION LEVY ARMORY ANTICIPATORY LEVIES ($95,000 ($2,374,641,200 x .00798 (As of 2/21/08) (Authorized $284,496 Only Levy Amount Due MSABC) TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS Last Updated 8/6/08 PRINCIPAL AND INTEREST ON ARMORY BONDS $146,084 $146,084 $80,000 $80,000 GRAND TOTAL 2008 PROPERTY TAX LEVY $11,429,007 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) (Based on 3.9% 1.68% Levy Limit) (Proposed) 2006 2007 2008 2009 Total Funding Requirements 16,072,890 17,341,719 17,855,312 17,291,477 (4) Less: Internal Revenues 6,886,700 7,189,300 6,526,300 6,212,800 Less: Market Value Based Levy Fire Station (See Below) 154,308 142,527 144,417 146,084 (3) Equals: Revenues Needed 9,031,882 10,009,892 11,184,595 10,932,593 Add Back in State MVHC Cuts to Reflect Actual Levy 350,330 350,330 0 350,330 Levy Certified by City to County Auditor 9,382,212 10,360,222 11,184,595 11,282,923 County Auditor Adjustments (All Subtractions): Fiscal Disparities Distributuion Levy (Metro Area) Spread Levy Used to Compute Local Tax Rate 8,611,924 (1) 9,489,708 (1) 10,215,703 (1) 10,314,031 Increase from Previous Year in Spread Levy 10.19% 7.65% 0.96% Market Value Based Referendum Levy Fire Station 154,308 142,527 144,417 146,084 (3) 770,288 870,514 968,892 968,892 (2) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2008 Number Provided by Dakota County as of 816107 (3) Market Value Based Levy for Fire Station Based on $146,084 Levy Spread to Taxable Market Value on 2121/08 Last Update from Dakota County 2121/08 Shows the Levy of $146,084 $2,374,641,200 $.0615 per $1,000 as our Estimate (4) In 2004 Started Including the Water, Sewer, Storm Water Arena Enterprise Funds in These Figures Last Updated 816108 8 8 N N 8 g s xxg N 0000 s .4ug N o S NN N N O 000! 8 COO O 8 8x88 N C Yq O O sxgg N y COO O 8 `1.,811 8 8xxg 4 0000 N ARV. X05_ FiN gam O O Y RE r 1 O A r (4 sa oNgta tl. .1Y Y Y F A n 1 0 1 8 8 N 8 g a SSE g ocoo py 8x COO O ...6 tl O loo! S 0 8 8888 C g gxgg ao -a if!f =255! adad SEE r O �A 11. o f o gree ;MG!! 2 I 1F mij 1 Mil is! LH' lisl 3 9 9 F 1 1 3 Page One August 13, 2008 Account 101 31010.00 101 31040.00 101 32110.00 101 32160.00 101 32161.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 33418.02 101 33418.00 101 33423.00 101 33425.00 101 33620.00 101 33630.00 101 33630.00 2009 BUDGET WORKSHEETS GENERAL FUND REVENUES Description Current Ad Valorem Taxes Fiscal Disparities Total Taxes (Tax) Alcoholic Beverage Licenses (1) Licenses to do Business (L) Licenses to do Bus Kennels (L) Building Permit Revenue (L) Mineral Extraction Pemtft (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) Current Ad Valorem Taxes (I) MSABC Armory Payments Delinquent Ad Valorem Taxes (I) Mobile Home Taxes (I) Gravel Taxes (1) 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 Other County Grants Aids (I) Police Services Levy -ISD #196 (I) DA.R.EJLiaison Funding Total Intergovernmental (I) 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $3,872,826 $4,630,971 $5,920,729 $7,063,908 804,414 770,288 870,514 968,892 4,677,240 5,401,259 6,791,243 8,032,800 0 8,032,800 32,583 33,040 34,525 30,000 32,000 7,360 5,710 6,390 7,000 6,500 Garbage Haulers, Ped Licenses, etc. 0 0 0 0 0 908,188 575,778 435,956 410,000 300,000 2,695 4,330 740 4,000 4,000 25,628 21,059 15,626 15,000 15,000 12,616 10,250 9,040 10,000 9,000 86,502 50,589 57,039 36,000 45,000 2,214 2,759 2,829 2,000 2,000 22,699 18,862 13,773 12,000 12,000 120 190 80 100 100 91,801 75,329 73,866 45,000 60,000 1,700 1,755 770 1,500 1,000 Alarm Permits Fireworks Permits Total Licenses Permits (L) 1,194,106 799,651 650,635 572,600 91,000 91,000 91,000 91,000 80,000 79,338 80,280 110,316 70,000 70,000 From County 8,675 8,342 10,635 9,000 9,000 From County 29,690 13,670 18,811 15,000 15,000 From County 131,522 148,080 158,698 150,000 150,000 From Cable Company 12,506 23,118 23,936 15,000 20,000 From Cable Company 0 0 0 0 0 From County 60,000 0 0 0 0 122,641 133,872 147,061 142,000 From State 7,000 7,000 120,000 135,000 26,715 26,910 29,115 26,000 26,000 From State 1,197 1,135 1,163 0 0 From State 17,668 19,465 35,475 15,000 24,000 From State -PERA Aid Safe Sober 15,000 18,500 15,400 16,000 16,000 Dakota County Recycling Funds 48,512 59,548 68,727 62,000 64,000 64,000 From ISD #196 644,465 623,920 710,336 596,000 PAGE TOTALS 6,515,811 6,824,831 8,152,214 9,201,400 $7,362,738 From County 968,892 From County 8,331,630 Total Property Tax Levy for Fund 101 (350,330) State Cuts in MVHC 7,981,300 Actual Property Taxes to Receive 486,600 80,000 Included in Debt Levy Figure 616,000 9,083,900 Page Two August 13, 2008 2009 BUDGET WORKSHEETS GENERAL FUND REVENUES 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 34103.00 Zoning Subdivision Fees (C) 72,304 47,917 76,425 50,000 50,000 101 34104.00 Plan Checking Fees (C) 405,606 259,610 185,934 200,000 130,000 101 34105.00 Sales of Maps Publications (C) 2,632 1,123 1,859 1,000 1,000 Maps Spec Books 101 34106.00 Deputy Registrar Fees (C) 52,406 58,563 56,373 55,000 5,000 Dakota County Taking Over in 2009 101 34107.00 Assessment Searches (C) 0 160 0 0 0 101 34108.00 Admin Fees Other Funds (C) 341,127 34,770 75,000 101 34108.01 Applicable Funds Except Const 25,000 25,000 25,000 25,000 101 34108.02 Construction Funds 187,875 96,785 100,000 50,000 101 34109.00 Other Charges for Service (C) 11,370 8,423 7,749 6,000 6,000 101 34110.00 Service Chg on Returned Chks (C) 210 240 270 200 200 101 34112.00 Utility Permit Application Fee (C) 575 550 1,550 500 500 101 34113.00 Application Fees 0 15.000 0 0 0 101 34150.00 User Fees SKB 255,923 257,556 315,490 260,000 300,000 SKB Fees from New Ceps C D 101 34151.00 User Fees/Host Agreements SKB 25,000 25,000 25,000 25,000 25,000 Landscaping Agreement (Yr 6 of 10) 101 34160.00 National Guard Maint Fees (C) 46,715 43,469 47,488 46,000 48,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) 18,285 16,117 23,145 20,000 21,000 Contractual OR for Officers 101 34202.00 Fire Services Buming Permits (C) 435 450 300 0 0 No Longer Charge for Permits 101 34203.00 Accident Reports (C) 266 114 5 200 100 101 34204.00 Day Care Inspection Fees (C) 658 450 250 500 300 101 34206.00 Other Police Services (C) 1,645 136 176 0 0 101 34207.00 Other Fire Protection Services (C) 11,005 11,780 15,655 14,000 101 34207.01 U of M Fire Contract 5,800 6,000 101 34207.02 Coates Fire Contract 3,800 4,000 101 34207.03 Other Billed Fire Calls 3,400 4,000 101 34301.00 Street, Sidewalk Curb Repairs (C) 0 0 0 0 0 101 34303.00 Mow Weeds (C) 1,815 1,349 2,448 0 0 101 34306.00 Other Highway Street Rev (C) 27,676 18,990 2,852 15,000 2,000 Street Light Baps Developers 101 34407.00 City Share of Metro SAC Chgs (C) 8,007 4,821 3,594 5,000 3,000 Total Charges for Services (C) 1,283,660 1,019,461 888,346 822,400 679,100 101 35101.00 Court Fines (F) 87,888 87,971 120,093 90,000 110,000 From County Total Fines Forfeits (F) 87,888 87,971 120,093 90.000 110,000 101 34720.00 Park Reservations (R) 2,455 879 2,417 1,500 2,500 Loss of Church 101 34721.00 Softball Revenues (R) 62,931 55,128 61,401 55,000 80.000 101 34722.00 Volleyball Revenues (R) 1,120 1,200 0 1,200 0 101 34724.00 Tennis Revenues (R) 1,659 1,990 2,354 1,500 2,300 101 34725.00 Thy Tot Revenues (R) 20,630 21,928 21,932 21,000 22,000 101 34726.00 Rosettes Revenues (R) 748 949 510 1,200 1,200 101 34727.00 Reid Trip Revenues (R) 10,777 11,000 7,300 101 34727.01 Youth/Teen Trips 0 9,794 4,988 5,000 101 34727.02 Adult/SeniorTrips 0 1,284 1,749 2,300 101 34728.00 Soccer League Revenues (R) 0 0 13,741 0 0 No League In 2009 101 34729.00 Outdoor Skating Lessons (R) 299 0 0 0 0 101 34730.00 Run for the Goid Revenues (R) 3,636 4,273 3,971 4,000 4,000 101 34731.00 Soccer Lessons (R) 0 2,008 1,980 2,000 2,000 101 34732.00 Adult Basketball Revenues (R) 1,326 1,052 2,108 1,000 2,000 101 34733.00 Other Programs Revenues (R) 14,310 14,072 16,227 14,000 14,000 101 34735.00 Camps Revenues (R) 13,314 12,743 13,028 12,000 12,000 101 34736.00 T-Ball Lessons (R) 4,675 5,150 5,176 5,000 5,000 101 34737.00 Leprechaun Days Revenues (R) 0 0 0 0 0 101 34790.00 Other Recreation Revenues (R) 0 0 0 0 0 101 38080.00 Banquet Room Fees (R) 58,281 56,790 64,852 58,000 62,000 101 38081.00 Auditorium Fees (R) 7,308 10,045 6,219 12,000 8.000 101 38082.00 Gymnasium Fees (R) 24,363 25,007 32,290 24,000 30,000 101 38086.00 Classroom Fees (R) 9,381 16,307 12,725 16,000 12,000 101 38096.00 Liquor Provider Fees (R) 1,050 1,170 1,320 1,500 1,300 101 38097.00 AN Rental Fees (R) 1,587 1,795 688 1,500 1,000 101 38154.00 Teen Night Revenues (R) 8,092 5,297 5,064 5,200 5,200 Total Recreation Fees (R) 247,942 248,857 274,740 248,600 253,800 PAGE TOTALS 1,619,489 1,356,289 1,283,179 1,161,000 1,042,900 Page Three August 13, 2008 2009 BUDGET WORKSHEETS GENERAL FUND REVENUES 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 36101.00 Principal Special Assessments (M; 14,063 14,878 12,119 15,000 10,000 From County -101 Funded Projects 101 36102.00 Penalties Interest S/A (M) 101 93 15 0 0 From County 101 36210.00 Interest Eamings Investments (M) 176,951 215,024 277,199 180,000 180,000 101 36214.00 Net Change in FV- Investments (M) (34,216) (3,216) 90,546 0 0 Annual Market Value Changes 101 36215.00 Interest Eamings (M) 722 690 428 1,000 500 From Checking Account 101 36220.00 Rents Royaltles (M) 5,712 5,712 5,236 6,000 57,000 101 36220.01 Verizon Antenna Rent 6,000 101 36220.02 St. Joseph's School Rental 51,000 7 Months Rent 101 36230.00 Contribution/Donations (M) 33,765 25,608 25,823 0 0 101 36260.00 Other Revenue (M) 4,531 1,636 17,154 2,000 2,000 101 36262.00 Special Settlements (M) 0 50,010 31,200 0 0 101 36265.00 Use of Reserve Funds (M) 0 0 0 0 0 101 38090.00 City Concessions (M) 4,574 5,171 5,108 5,000 5,000 Total Misc Revenues (M) 206,201 315,606 464,828 209,000 254,500 101 39202.00 Contribution from Enterprises (T) 3,500 3,500 3,500 3,500 3,500 Arena Building Grounds Makd. 101 39203.00 Transfer From (1) 0 0 85,469 0 0 Funds Retumed from Project Total Transfers In (T) 3,500 3,500 88,969 3,500 3,500 PAGE TOTALS $209,701 $319,106 $553,797 $212,500 $258,000 FUND TOTALS $8,345,001 $8,500,226 $9,989,191 $10,574,900 $10,384,800 INTERNAL REVENUES $3,667,761 $3,098,967 $3,197,947 $2,542,100 $2,403,500 Grand Total Less: Ad Valorem =r---.--.- -.=r= Fiscal Disparities Page Four August 13, 2008 2009 BUDGET WORKSHEETS GENERAL FUND REVENUES 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 101 34108.00 General Fund Admin Fees $25,000 $25,000 $25,000 $25,000 $25,000 101 34108.01 Fund 201 6,000 101 34108.02 Fund 202 2,500 101 34108.03 Fund 203 2,500 101 34108.04 Fund 206 2,500 101 34108.05 Fund 207 2,500 101 34108.06 Fund 605 1,000 101 34108.07 Fund 606 1,000 101 34108.08 Fund 607 1,000 101 34108.09 Fund 650 6,000 Adman Fees Breakdown Totals $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 Comments Page One August 13, 2008 2009 BUDGET WORKSHEETS COUNCIL 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41110 103.00 Salaries Benefits $26,850 $26,001 $34,338 $33,900 $33,900 Salary, Taxes, PERA Benefits 101 41110 01 225.00 Landscaping Materials 41,220 25,021 25,005 25,000 25,000 SKB Landscaping Agreement 101 41110 01 307.00 Management Fees 50,100 101 41110 01 307.01 Newsletter 12,830 13,756 22,263 28,000 29,000 101 41110 01 307.02 Chamber of Commerce Directory 1,065 1,065 1,065 1,100 1,100 101 41110 01 307.03 Community Survey 16,500 0 18,500 20,000 20,000 101 41110 01 310.00 Temporary Service Fees 5,034 0 0 0 0 101 41110 01 319.00 Other Professional Services 11,114 548 0 13,000 101 41110 01 319.01 Education Reimbursement 11,897 10,909 7,000 8,000 101 41110 01 319.02 HIPP Initiatives 48 0 5,000 5,000 101 41110 01 319.04 Technology Study 0 24,500 0 0 101 41110 01 321.00 Telephone Costs 0 79 600 101 41110 01 321.01 Mayor's Pager 0 27 0 0 101 41110 01 321.02 Mayor's Cell Phone 0 0 600 600 101 41110 01 329.00 Other Communication Costs 263 70 0 1,000 1,000 Newspaper Ads Open Houses 101 41110 01 331.00 Travel Expense 184 3,000 101 41110 01 331.01 NLC Conference 894 1,450 3,418 1,500 2,000 101 41110 01 331.02 Miscellaneous Travel 459 229 1,448 700 1,000 101 41110 01 433.00 Dues Subscriptions 23,000 101 41110 01 433.01 LMC Dues 11,203 12,523 13,397 14,000 14,500 101 41110 01 433.02 AMM Dues 4,952 5,357 5,734 5,800 6,200 101 41110 01 433.03 NDCC Dues 1,086 579 0 600 600 101 41110 01 433.04 NLC Dues 1,273 1,324 1,377 1,400 1,400 101 41110 01 433.05 Miscellaneous Dues 0 120 120 300 300 101 41110 01 435.00 Books Pamphlets 0 0 44 100 100 101 41110 01 437.00 Conferences Seminars 8,000 101 41110 01 437.01 Registration Hotel -LMC Conf 0 1,243 677 2,000 2,000 101 41110 01 437.02 Registration Hotel -NLC Conf 1,421 3,697 4,379 4,000 4,000 101 41110 01 437.03 Miscellaneous Conferences 1,669 961 628 2,000 2,000 101 41110 01 439.00 Other Miscellaneous Charges 5,066 169 107 0 0 101 41110 01 510.00 Land Purchases 119,604 0 0 0 0 101 41110 01 525.00 Building Structure Purchases 13,000 0 0 0 0 101 41110 01 598.00 Council Designated 108,899 59,330 15,330 40,000 120,000 Yearly Contingencies 101 41110 01 598.01 Library Site Expenditures 0 21,372 56,005 0 101 41110 01 598.02 Future Capital Expenditures 0 0 0 474,000 101 41110 01 599.00 Employee Recognition Costs 7,549 5,500 101 41110 01 599.01 Employee Recognition Costs 2,201 2,273 2,500 2,500 101 41110 01 599.02 Vending Machine Costs 3,513 3,914 3,000 3,000 Offset by Revenue from Machines PAGE TOTALS $392,134 $192,553 $245,458 $673,500 $283,200 DEPARTMENT TOTALS $392,134 $192,553 $245,458 $673,500 $283,200 Page One August 13, 2008 Account 101 41320 101.00 Salaries Benefits 101 41320 102.00 Full -Time Overtime 101 41320 103.00 Part-Time Salaries Benefits 101 41320 01 209.00 Other Office Supplies 101 41320 01 306.00 101 41320 01 313.00 101 41320 01 319.00 101 41320 01 321.00 101 41320 01 331.00 101 41320 01 331.01 101 41320 01 331.02 101 41320 01 331.03 101 41320 01 394.00 101 41320 01 433.00 101 41320 01 433.01 101 41320 01 433.02 101 41320 01 433.03 101 41320 01 433.04 101 41320 01 433.05 101 41320 01 433.06 101 41320 01 433.07 101 41320 01 435.00 101 41320 01 437.00 101 41320 01 437.01 101 41320 01 437.02 101 41320 01 437.03 101 41320 01 437.04 101 41320 01 437.05 101 41320 01 437.06 101 41320 01 437.07 101 41320 01 437.08 101 41320 01 437.09 101 41320 01 439.00 2009 BUDGET WORKSHEETS ADMINISTRATION Description Personnel Testing Recruitment Temporary Service Fees Other Professional Services Telephone Costs Travel Expense NLC Conference ICMA Conference Miscellaneous Travel P.C. Software Purchases Dues Subscriptions MCMA Dues MAMA Dues MCFOA Dues Munici -Pals IPMA Dues ICMA Dues APMP Dues Books Pamphlets Conferences Seminars Registration Hotel LMC Registration Hotel MCMA Personnel Conferences Staff (1) Each Miscellaneous Seminars Registration Hotel ICMA City Clerk Training Registration Hotel NLC Miscellaneous Meetings Other Miscellaneous Charges 101 41320 01 580.00 Other Equipment Purchases 2005 2006 2007 Actual Actual Actual $347,771 67 0 $381,348 $353,911 $387,400 1,159 20 2,000 8,863 6,224 7,000 669 455 165 800 O 0 0 0 O 1,370 0 0 4,119 1,706 180 2,000 1,347 1,976 2,027 1,600 PAGE TOTALS 363,713 408,392 374,558 418,600 2008 2009 Object 2009 Adopted Detail Proposed Budget Amount Budget 669 967 642 800 800 O 382 395 800 800 51 362 396 0 400 0 0 0 0 All Salary Costs Inclusive of $409,000 Salary, Taxes, PERA Benefits 2,000 7,000 Temp Receptionist Coverage 500 Miscellaneous Purchases 0 266 1,265 0 900 900 Comments 0 0 1,500 Updating KFS Models 1,600 Administration CeII Phones 1,600 2,100 180 187 194 200 200 50 40 40 100 100 35 35 35 50 50 120 165 25 150 150 O 0 0 0 0 Moved Below to H/R 1,420 2,111 909 1,500 1,500 O 20 0 100 100 915 606 322 1,000 1,000 11,700 0 394 340 500 500 491 498 1,132 1,200 1,200 O 0 0 0 0 Moved Below to H/R 250 0 70 200 200 2,287 577 1,893 4,000 4,000 ULI Greening Initiatives 1,080 1,422 3,389 2,500 2,500 O 450 410 1,200 800 All MCFOA Events 1,835 1,890 1,257 2,500 2,500 72 18 490 0 0 20 125 92 100 100 439,000 Page Two August 13, 2008 2009 BUDGET WORKSHEETS ADMINISTRATION 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 101 41320 41 433.00 Dues Subscriptions 119 60 60 200 101 41320 41 437.00 Conferences Seminars 24 0 0 400 101 41320 41 580.00 Other Equipment Purchases 608 3,350 5,616 900 PAGE TOTALS $119,816 $98,541 $83,454 $123,400 DEPARTMENT TOTALS $483,529 $506,933 $458,013 $542,000 $117,400 $556,400 Comments 101 41320 31 305.00 Medical Dental Fees 115 2,000 Employee Drug Testing 101 41320 31 305.01 Pre Employment Physicals 0 0 500 500 Additional Training for 2006 101 41320 31 305.02 Employee Drug Testing 0 0 1,500 1,500 101 41320 31 315.00 Special Programs 4,498 8,000 101 41320 31 315.01 Employee Training 858 219 5,000 5,000 Additional Training for 2006 101 41320 31 315.02 HIPP Initiatives 2,419 663 2,000 2,000 Wellness Health Management 101 41320 31 315.03 EAP 0 717 1,000 1,000 101 41320 31 319.00 Other Professional Services 6,700 101 41320 31 319.01 Labor Consultant 4,302 (567) 0 2,000 1,000 101 41320 31 319.02 Labor Legal Issues 608 125 249 900 900 101 41320 31 319.03 CHESS Consultant 5,400 0 0 5,400 0 Moved to Insurance Fund 101 41320 31 319.04 COBRA Consultant 0 0 0 1,000 1,000 101 41320 31 319.05 Flex VEBAAdministrative Fees 4,172 2,855 2,279 3,300 3,300 101 41320 31 319.06 SWWC Co-Operative Dues 0 0 0 500 500 101 41320 31 331.00 Travel Expense 520 298 51 400 400 101 41320 31 341.00 Employment Advertising 4,852 11,672 975 8,000 6,000 Vacancies 101 41320 31 433.00 Dues Subscriptions 700 101 41320 31 433.01 "Future Use 310 310 0 0 0 101 41320 31 433.02 IPMA Dues 160 145 145 300 300 101 41320 31 433.03 MPELRA Dues 300 150 0 400 400 101 41320 31 435.00 Books Pamphlets 233 402 84 500 300 Books Training Materials 101 41320 31 437.00 Conferences Seminars 1,0 101 41320 31 437.01 MPELRA State Conference 300 0 0 500 300 101 41320 31 437.02 Personnel Seminars 255 13 249 400 400 101 41320 31 437.03 Safety, Supervisor, Policy 315 0 0 500 300 101 41320 41 315.00 Special Programs 39,936 39,439 24,489 25,000 25,000 Gen'I Marketing, Special Mailings 101 41320 41 319.00 Other Professional Services 14,920 160 1,354 5,000 5,000 Consultants Cable TV 101 41320 41 328.00 Cable Supply Costs 5,391 382 178 3,000 3,000 Cable Supplies, Software 101 41320 41 329.00 Other Communication Costs 32,490 36,285 0 55,600 101 41320 41 329.01 Cable JPA Payment General City 0 0 37,929 42,000 43,000 101 41320 41 329.02 Video Streaming Council Meeting: 0 0 2,765 8,400 8,400 101 41320 41 329.03 Bulk E -Mail System 0 0 5,014 4,200 4,200 101 41320 41 331.00 Travel Expenses 104 185 304 200 200 200 MAGC 400 Technical Courses 2,900 Historical Monument ($2,000) Page One August 13, 2008 2009 BUDGET WORKSHEETS ELECTIONS 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 41410 01 103.00 Part -Time Salaries $0 $19,339 $0 $37,300 $0 Election Judges 101 41410 01 203.00 Printed Forms Paper 0 306 0 3,300 0 Ballots Programming 101 41410 01 208.00 Miscellaneous Supplies 0 489 (18) 300 0 101 41410 01 219.00 Other Operating Supplies 0 428 (25) 800 0 Food for Election Judges 101 41410 01 242.00 Minor Equipment 105 2,397 0 2,000 0 Booths Signs 101 41410 01 319.00 Other Professional Services 0 0 0 0 0 101 41410 01 321.00 Telephone Costs 303 352 57 200 100 101 41410 01 351.00 Legal Notices Publishing 0 0 0 100 0 Election Publications 101 41410 01 409.00 Other Contracted Repair Maint 0 0 0 2,300 2,300 101 41410 01 409.01 Maintenance for AutoMarks 1,300 Voting Machines Voting Machines 101 41410 01 409.02 Maintenance forAccuvotes 1,000 Voting Machines Voting Machines 101 41410 01 412.00 Building Rental 0 0 400 500 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 54,000 15,000 60,000 15,000 37,600 PAGE TOTALS $54,408 $38,311 $60,415 $61,800 $40,000 DEPARTMENT TOTALS $54,408 $38,311 $60,415 $61,800 $40,000 Page One August 13, 2008 2009 BUDGET WORKSHEETS FINANCE 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget All Salary Costs Inclusive of 101 41520 101.00 Salaries Benefits $219,263 $194,877 $206,431 $317,100 $341,100 Salary, Taxes, PERA Benefits 101 41520 102.00 Full -Time Overtime 1,484 1,957 1,557 3,000 3,000 101 41520 103.00 Part-Time Salaries Benefits 0 20,023 31,448 42,600 0 Moved to F/T Above 101 41520 01 319.00 Other Professional Services 0 0 0 0 0 F/A Now Done Internally 101 41520 01 331.00 Travel Expense 1,500 101 41520 01 331.01 Finance Director 997 472 894 1,200 1,200 National Convention Misc 101 41520 01 331.02 Staff 16 10 80 300 300 101 41520 01 391.00 P.C. Maintenance 49,200 101 41520 01 391.01 Civic Systems Applications Support 4,595 4,810 5,035 5,000 5,500 101 41520 01 391.02 CitrixMaintenance Renewal 0 0 1,240 1,200 1,400 101 41520 01 391.03 Incode Software Maintenance 5,858 6,082 6,329 6,500 6,500 101 41520 01 391.04 General Network Support 30,000 40,000 50,000 40,000 25,000 250 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,300 101 41520 01 391.07 Miscellaneous P.C. Repairs 1,350 1,290 2,133 2,800 2,800 101 41520 01 391.08 Anti-Virus Software Renewal 4,205 2,260 4,163 5,200 5,200 101 41520 01 391.09 File Server Software Maintenance 0 0 1,204 0 1,500 101 41520 01 392.00 P.C. Accessories Supplies 3,699 2,929 2,788 3,000 4,000 City System Supplies 101 41520 01 393.00 P.C. Hardware Purchases 1,198 1,218 1,447 2,000 3,000 101 41520 01 394.00 P.C. Software Purchases 15,000 101 41520 01 394.01 Annual Microsoft Office Payment 0 9,811 9,811 10,000 10,000 Annual Payment Thru 2011 101 41520 01 394.02 Miscellaneous S/W Purchases 0 0 0 1,000 5,000 Potential True -Up Costs 101 41520 01 409.00 Other Contracted R M 60 105 105 300 300 Cash Register Repairs/Maint 101 41520 01 433.00 Dues Subscriptions 700 101 41520 01 433.01 "Future Use" 0 0 0 0 0 101 41520 01 433.02 MnGFOA Finance Director 40 40 40 50 50 101 41520 01 433.03 MnGFOA Staff 200 200 200 200 200 101 41520 01 433.04 GFOA Finance Director Asst. 295 305 315 350 350 101 41520 01 433.05 Magazine Subscriptions 0 0 0 100 100 101 41520 01 435.00 Books Pamphlets 100 101 41520 01 435.01 Accounting Related Books 127 0 0 100 50 101 41520 01 435.02 Finance Related Books 0 0 0 100 50 101 41520 01 437.00 Conferences Seminars 4,500 101 41520 01 437.01 "Future Use" 0 0 0 0 0 101 41520 01 437.02 MnGFOA Annual Conf (F/D Asst) 526 526 551 1,000 1,000 101 41520 01 437.03 GFOA National Conf (F/D) 986 0 1,270 1,500 1,500 101 41520 01 437.04 Staff Development 0 644 930 1,000 1,000 101 41520 01 437.05 Miscellaneous Seminars 922 791 370 1,000 1,000 101 41520 01 439.00 Other Miscellaneous Charges 191 134 553 500 500 Contigencies 101 41520 01 570.00 Office Equipment Furnishings 0 4,127 0 0 0 PAGE TOTALS $277,222 $293,820 $330,105 $448,400 $422,900 DEPARTMENT TOTALS $277,222 $293,820 $330,105 $448,400 $422,900 Comments Page One August 13, 2008 Account 101 41810 01 202.00 101 41810 01 202.01 101 41810 01 202.02 101 41810 01 203.00 101 41810 01 203.01 101 41810 01 203.02 101 41810 01 203.03 101 41810 01 203.04 101 41810 01 203.05 101 41810 01 203.06 101 41810 01 204.00 101 41810 01 204.01 101 41810 01 204.02 101 41810 01 204.03 101 41810 01 204.04 101 41810 01 204.05 101 41810 01 209.00 101 41810 01 221.00 101 41810 01 242.00 101 41810 01 242.01 101 41810 01 242.02 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 301.05 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 393.00 101 41810 01 433.00 101 41810 01 439.00 101 41810 01 450.00 2009 BUDGET WORKSHEETS GENERAL GOVERNMENT Description Duplicating Copying Records Retention Copying Costs Printed Forms Paper Copy Paper General Receipt Books Purchase Orders Payroll A/P Checks "Future Use" Miscellaneous Forms Envelopes Letterheads Letterhead Plain Envelopes A/P Payroll Envelopes 10 x 13 Envelopes 10 x 15 Envelopes Other Office Supplies Equipment Parts Minor Equipment State Purchasing Program Credit Card Equipment Auditing Accounting Services Audit General Consulting Fees Dakota County Assessment Fees Dak Cty Truth In Taxation Costs Printing of Budget Books "Future Use" 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. Hardware Purchases Dues Subscriptions Other Miscellaneous Charges Sales Tax on Purchases 101 41810 01 580.00 Other Equipment Purchases 101 41810 01 598.00 Emergency Operations Cost PAGE TOTALS DEPARTMENT TOTALS 2005 2006 2007 Actual Actual Actual 773 695 1,542 1,500 2,355 1,310 2,464 900 0 0 0 800 845 1,095 0 600 O 0 0 400 19,079 18,859 16,068 18,000 532 0 0 800 O 0 0 350 2008 2009 Object 2009 Adopted Detail Proposed Budget Amount Budget 1,600 1,600 500 600 200 O 467 0 250 250 Comments $24,000 9,624 8,200 7,998 7,000 9,000 9,487 8,490 14,282 15,000 15,000 10,000 5,596 4,513 4,911 4,800 5,000 O 0 774 1,200 800 O 1,528 0 1,500 1,500 355 280 284 3,000 1,500 O 0 0 0 0 3,458 564 1,991 500 1,200 Business Cards, etc. 4,500 18,000 General Office Supplies 500 City Hall Equipment Repairs 600 350 Yearly Fees for Program 82,000 57,226 61,167 64,204 80,000 75,000 Increased GASB Requirements 1,941 2,922 3,449 4,000 4,000 1,579 1,741 1,840 2,500 2,500 243 393 (205) 1,000 500 O 0 0 0 0 Moved to Administration O 7,631 12,767 0 0 50,459 62,728 63,537 75,000 75,000 General City Legal Fees 45,800 540 567 540 2,300 2,300 Moved from Administration 0 0 250 1,500 1,500 Moved from Administration 8,453 8,390 8,760 9,000 11,000 Fees Paid to Springsted 4,050 2,000 2,000 5,000 4,000 Fees Paid to Springsted (Bonds) 6,075 0 14,225 6,000 11,000 Fees Paid to Springsted 6,500 9,450 11,900 15,000 15,000 Fees Paid to Springsted 0 0 0 0 1,000 2,300 2,711 0 12,000 Add' Services at City Hall O 141 980 1,000 O 510 4,158 6,000 O 187 1,080 2,000 O 228 245 1,000 120 140 721 300 473 10,195 260 500 19,853 0 0 0 29,824 22,097 26,212 29,000 O 0 0 0 $333,097 $326,722 $360,463 $395,000 $333,097 $326,722 $360,463 $395,000 1,000 6,000 4,000 1,000 70,100 63,106 62,916 70,048 65,000 70,000 O 0 0 0 100 20,036 17,783 19,569 20,000 20,000 75 801 33 800 800 General Costs 5,000 3,806 3,824 2,850 4,000 4,000 All Departments 156 340 268 500 500 Billing from Dakota County 428 362 459 1,000 500 State Mandated Publications 3,750 1,500 0 6,000 5,000 Docuware Service Hours O 0 0 0 0 Docuware Scanners $403,300 $403,300 500 Newspapers 500 Direct Deposit Filing Fees/Flex 0 Sales Tax Audit 29,000 Copy Machine Leases All Bldgs 0 Mercury Spill (Fax Machine Postage Meter) Page One August 13, 2008 Account 101 41910 101.00 101 41910 102.00 101 41910 99 103.00 101 41910 99 103.01 101 41910 01 201.00 101 41910 01 202.00 101 41910 01 203.00 101 41910 01 205.00 101 41910 01 208.00 101 41910 01 209.00 101 41910 01 219.00 101 41910 01 241.00 101 41910 01 302.00 101 41910 01 312.00 101 41910 01 319.00 101 41910 01 329.00 101 41910 01 331.00 101 41910 01 391.00 101 41910 01 392.00 101 41910 01 393.00 101 41910 01 433.00 101 41910 01 433.01 101 41910 01 433.02 101 41910 01 433.03 101 41910 01 433.04 101 41910 01 433.05 101 41910 01 433.06 101 41910 01 433.07 101 41910 01 433.08 101 41910 01 433.09 101 41910 01 433.10 101 41910 01 435.00 101 41910 01 437.00 101 41910 01 437.01 101 41910 01 437.02 101 41910 01 437.03 101 41910 01 437.04 101 41910 01 437.05 101 41910 01 437.06 101 41910 01 437.07 101 41910 01 437.08 101 41910 01 437.09 101 41910 01 437.10 101 41910 01 437.11 101 41910 01 439.00 2009 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT Description Salaries Benefits Full -Time Overtime Part-lime Salaries Benefits Planning Commission Members Office Accessories Duplicating Copying Printed Forms Paper Drafting Supplies Miscellaneous Supplies Other Office Supplies Other Operating Supplies Small Tools Architects' Fees Contract Inspection Fees Other Professional Services Other Communication Costs Travel Expense P.C. Maintenance P.C. Accessories Supplies P.C. Hardware Purchases Dues Subscriptions APA/AICP ICC AMBO 10,000 Lakes "Future Use" Trade Magazines Planner's Joumal Sensible Land Use Coalition AACEO/MAHCO Other Dues Subscriptions Books Pamphlets Conferences Seminars State Bldg Official School Spring Fall Code Updates Building Inspector Training Computer Training Clerical Seminars Planning Seminars ISTS Training State Planning Conference (2) Planning Commissioner Training Gen'I Seminars Code Enforcement Training Other Miscellaneous Charges 101 41910 01 570.00 Office Equipment Furnishings PAGE TOTALS DEPARTMENT TOTALS 2005 2006 2007 Actual Actual Actual All Salary Costs Inclusive of $771,360 $763,813 $797,187 $889,700 $891,300 Salary, Taxes, PERA Benefits O 1,758 435 3,000 2,000 11,620 6,118 2,587 5,000 5,000 5,000 30 9 0 400 11,489 3,267 1,344 8,000 1,163 1,111 3,712 3,000 O 0 0 100 81 15 21 200 252 331 295 600 1,657 944 1,302 1,500 53 106 160 400 O 0 275 0 O 0 0 0 14 911 250 1,000 1,475 1,710 3,128 2,200 653 1,279 540 600 2,016 2,566 2,184 3,000 0 0 0 500 O 0 0 0 1,374 1,187 1,006 1,500 100 100 100 200 200 480 200 300 50 50 75 150 0 0 0 0 189 50 42 200 48 0 0 100 O 448 201 400 0 0 0 300 O 33 533 50 352 134 910 700 280 525 70 550 270 295 60 300 40 255 184 1,000 O 537 0 400 274 70 0 500 693 1,521 1,783 1,500 409 830 429 500 630 245 0 1,000 O 25 0 250 498 1,218 955 400 402 293 0 400 140 0 0 400 0 0 0 0 $807,810 $792,234 $819,969 $930,300 $807,810 $792,234 $819,969 $930,300 2008 2009 Object 2009 Adopted Detail Proposed Budget Amount Budget 1,500 200 300 150 0 200 100 400 300 50 550 300 1,000 400 500 1,500 500 1,000 250 400 400 Comments 400 Calendars, Planners, etc. 8,000 Comprehensive Plan Copies 4,000 Forms, Stickers, Tags, etc. 100 Zipatone, Spray Mount 200 Calculators 600 Dictation Devices Tapes 1,500 400 Inspectors' Tools 0 0 Fees for Contracted/Temp Sery 1,000 Consultant 2,800 Cellular Phone Pagers 700 3,000 Permitworks Support 500 0 3,200 700 Manuals, References, IBC Books 6,800 400 Contingencies 0 $932,600 $932,600 Page One August 13, 2008 Account 101 42110 101.00 101 42110 102.00 101 42110 102.01 101 42110 102.02 101 42110 103.00 101 42110 23 103.00 101 42110 99 103.00 101 42110 01 202.00 101 42110 01 203.00 101 42110 01 204.00 101 42110 01 207.00 101 42110 01 207.01 101 42110 01 207.02 101 42110 01 207.03 101 42110 01 208.00 101 42110 01 208.01 101 42110 01 208.02 101 42110 01 209.00 101 42110 01 211.00 101 42110 01 211.01 101 42110 01 211.02 101 42110 01 217.00 101 42110 01 217.01 101 42110 01 217.02 101 42110 01 217.03 101 42110 01219.00 101 42110 01 219.01 101 42110 01 219.02 101 42110 01 221.00 101 42110 01 241.00 101 42110 01 241.01 101 42110 01 241.02 101 42110 01 241.03 101 42110 01 242.00 101 42110 01 242.01 101 42110 01 242.02 101 42110 01 304.00 101 42110 01 305.00 101 42110 01 305.01 101 42110 01 305.02 101 42110 01 306.00 101 42110 01 313.00 101 42110 01 315.00 101 42110 01 316.00 101 42110 01 316.01 101 42110 01 316.02 101 42110 01 319.00 101 42110 01 319.01 101 42110 01 319.02 101 42110 01 321.00 101 42110 01 321.01 101 42110 01 321.02 101 42110 01 321.03 101 42110 01 323.00 101 42110 01 323.01 101 42110 01 323.02 101 42110 01 331.00 101 42110 01 331.01 101 42110 01 331.02 101 42110 01 331.03 101 42110 01 331.04 101 42110 01 331.05 101 42110 01 331.06 101 42110 01 331.07 2009 BUDGET WORKSHEETS POLICE Description Salaries Benefits Full -Time Overtime Regular Overtone Hours Contracted OR Part-Tune Salaries Benefits Part-Tyne Secretary Part-Tone CSO's Duplicating Copying Printed Forms Paper Envelopes Letterheads Training Instructional Supplies Practice Ammunition Service Ammunition Other Supplies Miscellaneous Supplies DARE Donations Equipment Donations/Forfeitures Other Office Supplies Cleaning Supplies Blanket Cleaning Squad Interior Cleaning Clothing Allowance CSO's Reserves Other Supplies Other Operating Supplies Evidence Bags, Drug Kits, Misc. Accurint Database Services Equipment Parts Small Tools Evidence Processing Equipment Camera and Video Supplies Other Supplies Minor Equipment Less Lethal Tactical Equipment MAAG Equipment Legal Fees Medical Dental Fees Employee Drug Testing Seized Narcotic Testing Personnel Testing Recruitment Temporary Service Fees Special Programs Animal Care Services Impound Care Fees "Future Use Other Professional Services Dispatch Services Operations "Future Use" Telephone Costs Cell Phones Pagers LOGIS Communications Line Radio Units Radios ($380 per Unit) Radars Travel Expense MN Chiefs Spring Conference IACP Conference Outstate investigations Conf. MAAG Conference CAN-AM Narcotic Conference Juvenile Officers Conference Meeting Reimbursements 2008 2005 2006 2007 Adopted Actual Actual Actual Budget $1,764,519 $1,894,055 $1,995,799 $2,223,800 62,916 76,321 72,650 65,000 60,900 7,469 8,434 10,006 21,300 22,200 PIT Secretary -16 Hours/Wk 31,500 32,242 28,501 35,700 38,700 CSO's Total 50 Hours/Wk 242 0 0 200 1,043 718 1,630 800 O 93 159 0 3,429 2,098 3,656 2,500 O 0 515 400 64 64 0 100 2,091 2,406 2,659 0 63,395 8,313 7,781 0 564 850 1,035 1,000 O 0 0 100 O 608 509 300 5,132 4,724 4,826 4,800 134 0 0 0 481 444 444 500 260 116 302 500 O 0 1,639 1,500 711 315 120 500 450 436 441 400 412 430 258 400 249 243 610 300 121 74 160 100 PAGE TOTALS 2,096,106 2,212,108 2,477,720 2,717,100 2009 Object 2009 Detail Proposed Amount Budget 45,000 20,000 3,000 400 100 0 0 0 500 9,590 10,224 9,918 13,000 12,000 O 0 0 0 0 68,124 90,240 232,230 232,800 304,200 4,422 4,611 19,608 23,600 0 4,800 0 500 500 1,500 500 400 400 300 100 Comments All Salary Costs Inclusive of $2,354,600 Salary, Taxes, PERA Benefts 65,000 0 800 Evidence Logs, Anonal Lb, etc. 200 Business Cards 3,500 0 Donated Forfeled Funds 1,000 Video, CD's Miscellaneous 500 4,000 500 1,291 331 1,500 1,000 2,434 1,612 1,127 2,000 2,000 26 923 1,590 500 1,000 2,006 1,905 30 2 1,999 2,000 2,000 405 300 400 2,488 2,786 3,919 2,500 2,500 Squad Emergency Equip Repairs 2,000 Crime Scene Kk Supplies 523 515 145 750 750 514 1,017 758 500 500 569 574 417 750 750 Digital Recorders 861 2 849 538 760 1,500 1,500 Training Supplies, Taser Batteries 456 849 383 500 500 54,996 54,996 55,010 56,000 56,000 Prosecution 2,000 1,255 736 1,074 1,500 1,500 368 224 340 500 500 700 4,254 825 1,500 1,000 Medical Psychobgical O 0 715 1,200 1,200 Interpreter Services O 0 11,994 0 0 12,000 304,200 5,300 14,000 1,103 911 221 13,500 13,500 800 MHz Subscriber Fees O 61 220 500 500 Radar LIDAR Repairs 3,700 2,898,800 Page Two August 13, 2008 2009 BUDGET WORKSHEETS POLICE 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 42110 01 333.00 Freight Express Expenses 147 202 138 200 200 Repairs 101 42110 01 341.00 Employment Advertising 797 0 0 0 0 101 42110 01 394.00 P.C. Software Purchases 13 .E 101 42110 01 394.01 Automated Pawn System 432 432 432 500 500 101 42110 01 394.02 Pictometry 1,988 0 1,504 2,000 2,000 101 42110 01 394.03 CJIIN System 8,421 10,474 10,474 10,500 10,500 101 42110 01 398.00 Computer Maintenance 65,600 101 42110 01 396.01 Records Management 42,252 41,623 31,069 30,500 32,500 CAD Included in DCC h 2007 101 42110 01 396.02 CJDN Connection Charges 2,351 3,443 2,520 2,800 2,800 101 42110 01 396.03 MCD Connection Charges 2,464 1,573 1,384 3,000 2,000 101 42110 01 396.04 MCD Maintenance Cellular 19,652 22,391 17,753 20,000 20,500 101 42110 01 396.05 LOGIS Annual Fees 7,875 7,844 6,942 7,300 7,800 101 42110 01 396.06 "Future Use" 3,593 0 0 0 0 101 42110 01 433.00 Dues Subscriptions 4,500 101 42110 01 433.01 Mutual Aid Assistance Group -MAAG 2,000 2,100 2,100 3,000 3,000 101 42110 01 433.02 IACP Chiefs 100 100 100 100 100 101 42110 01 433.03 MN Chiefs of Police 225 245 165 250 250 101 42110 01 433.04 Dakota Cty Chiefs of Police 50 50 35 50 50 101 42110 01 433.05 Wakota CAER 0 0 20 20 20 101 42110 01 433.06 Metro Emergency Managers 0 0 0 0 0 101 42110 01 433.07 MN Sex Crimes Investigators 18 18 18 20 20 101 42110 01 433.08 Tri- County Investigators 60 60 60 60 60 101 42110 01 433.09 MN Crime Prevention Association 0 40 55 55 55 101 42110 01 433.10 P.O.S.T. Licenses 460 1,080 810 400 800 101 42110 01 433.11 FBI Nat9 Academy Association 60 0 0 60 60 101 42110 01 433.12 Miscellaneous 55 40 55 85 85 101 42110 01 435.00 Books Pamphlets 297 998 1,118 300 500 Crime Prevention Materials 101 42110 01 436.00 Towing Charges 88 184 0 200 200 Disabled Squads 101 42110 01 437.00 Conferences Seminars 11,000 101 42110 01 437.01 Fkeamts Training 3,896 1,757 2,071 2,000 2,000 Range Rental 101 42110 01 437.02 Chiefs Spring Conference 345 575 425 500 500 101 42110 01 437.03 Investigations 361 1,183 2,020 1,500 1,500 101 42110 01 437.04 IACP Conference 0 0 275 250 250 101 42110 01 437.05 Supervision 650 407 665 1,000 750 101 42110 01 437.06 Use of Force 1,625 21 0 600 600 101 42110 01 437.07 Emergency Driving 1,365 1,365 2,100 1,400 1,400 101 42110 01 437.08 First Aid 1,690 0 700 1,500 1,250 101 42110 01 437.09 Narcotic Enforcement 100 200 307 750 500 101 42110 01 437.10 Tactical 670 480 690 1,000 750 101 42110 01 437.11 Support Services 40 65 40 500 250 101 42110 01 437.12 Patrol 1,228 1,820 1,050 2,000 1,250 101 42110 01 439.00 Other Miscellaneous Charges 412 643 510 500 500 Refreshments for Meetings Compliance Checks 101 42110 01 580.00 Other Equipment Purchases 3,091 1,181 0 0 0 PAGE TOTALS $108,856 $102,594 $87,605 $94,900 $95,500 DEPARTMENT TOTALS $2,204,962 $2,314,702 $2,565,325 $2,812,000 $2,994,300 Page One August 13, 2008 Account 101 42210 103.00 101 42210 103.01 101 42210 103.02 101 42210 103.03 101 42210 103.04 101 42210 103.05 101 42210 01 202.00 101 42210 01 202.01 101 42210 01 202.02 101 42210 01 204.00 101 42210 01 204.01 101 42210 01 204.02 101 42210 01 204.03 101 42210 01 208.00 101 42210 01 208.01 101 42210 01 208.02 101 42210 01 208.03 101 42210 01 208.04 101 42210 01 208.05 101 42210 01 211.00 101 42210 01 211.01 101 42210 01 211.02 101 42210 01 211.03 101 42210 01 211.04 101 42210 01 218.00 101 42210 01 219.00 101 42210 01 219.01 101 42210 01 219.02 101 42210 01 219.03 101 42210 01 219.04 101 42210 01 219.05 101 42210 01 219.06 101 42210 01 229.00 101 42210 01 229.01 101 42210 01 229.02 101 42210 01 229.03 101 42210 01 229.04 101 42210 01 230.00 101 42210 01 230.01 101 42210 01 230.02 101 42210 01 230.03 101 42210 01 230.04 101 42210 01 230.05 101 42210 01 230.06 101 42210 01 241.00 101 42210 01 241.01 101 42210 01 241.02 101 42210 01 241.03 101 42210 01 305.00 101 42210 01 306.00 101 42210 01 306.01 101 42210 01 306.02 101 42210 01 306.03 101 42210 01 306.04 101 42210 01 308.00 101 42210 01 308.01 101 42210 01 308.02 101 42210 01 308.03 101 42210 01 308.04 101 42210 01 308.05 101 42210 01 308.06 101 42210 01 308.07 101 42210 01 308.08 2009 BUDGET WORKSHEETS FIRE Description Salaries Benefits Salaries Training Pay /Stipends Call Pay /Stipends Class Pay /Stipends P/T Fire Marshal Duplicating Copying Copy Toner Computer Printers Envelopes Letterhead Envelopes Letterhead Forms Miscellaneous Supplies Supplies, Computer Support Film Developing Memberships Code Books Training Cleaning Supplies Soaps Chamois, Towels, etc. Sponges, etc. SCBA Cleaner Fire Department Clothing Other Operating Supplies Gloves Bandages Equipment Tyvek Suits Consummable Medical Oxygen Other Maintenance Supplies Aerial- Pumpers Tanker Pickup Trucks Rescue Other Vehicle Modifications Equipment Repair Materials Light Bars Smoke Machines Lantems Miscellaneous Small Tool Repairs Opticom Station Small Tools Axes, Bars Other Grass Fire Hand Tools 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $82,244 $100,280 $96,884 $90,800 30,000 4,000 20,900 100 0 0 355 107 50 50 O 0 0 50 50 O 0 0 25 25 O 0 0 25 25 42 134 0 50 50 731 699 851 700 0 O 183 217 100 0 35 35 35 0 0 210 0 82 200 0 595 1,171 905 800 0 1,044 53 1,217 300 550 0 33 116 100 50 0 0 39 25 50 O 0 75 75 150 140 67 45 300 400 5 Uniforms (51$80 Each 4,300 Medical Supplies 0 424 659 800 1,000 0 505 0 100 100 494 744 751 500 500 O 0 0 100 100 280 1,826 2,105 1,800 2,200 111 122 137 200 400 O 123 0 800 800 O 0 13 100 100 0 300 0 100 100 12 3,148 0 100 100 O 0 0 100 100 0 0 0 250 250 0 0 478 250 250 205 285 700 600 600 O 0 0 300 300 O 504 307 300 300 126 253 245 150 150 66 0 195 250 250 782 1,803 998 300 300 PAGE TOTALS 99,900 124,591 123,792 114,500 Comments All Salary Costs Inclusive of $55,000 Salary, Taxes, PERA Benefits Position Eliminated in 2008 100 100 800 0 Supplies for Fire Marshal 1,100 1,800 700 Medical Dental Fees 2,741 2,734 2,805 3,500 3,500 Annual Medical Tests Personnel Testing Recruitment 2,700 New Physicals (5) 1,133 1,540 1,955 1,000 1,325 Hepatitis Shots (5) 29 293 651 500 625 Background Checks (5) 96 261 29 100 125 Drug Testing (5) 0 0 0 500 625 Instructors' Fees 8,600 Fire Fighter 1 (5) 0 0 974 1,200 1,500 Fire Fighter 1 Certificates (5 5) 0 0 645 150 600 Fire Fighter Re- Certificates (6) 315 90 0 240 90 First Responder (5) 0 0 2,210 1,000 1,200 First Responder Refresher (1/2) 2,040 1,820 715 2,000 1,400 Outside Schools ($/2) 6,430 4,806 6,647 2,550 2,560 Haz -Mat Training (5) 0 0 0 1,000 1,250 Apparatus Re- Certificates 0 0 0 60 0 79,100 Page Two August 13, 2008 2009 BUDGET WORKSHEETS FIRE 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 42210 01 310.00 Testing Services 1,500 101 42210 01 310.01 Aerial (Next 2009) 795 0 821 1,000 1,000 101 42210 01 310.02 Ladders (Next 2009) 0 0 0 500 500 101 42210 01 310.03 Pumpers (3) (Next 2010) 0 750 0 900 0 101 42210 01 310.04 SCBA Hydro Testing (Next 2010) 1,450 0 0 0 0 101 42210 01 313.00 Temporary Service Fees 6,200 101 42210 01 313.01 SCBA Contract 388 777 592 400 2,300 101 42210 01 313.02 SCBA Maintenance 209 1,270 2,922 200 600 101 42210 01 313.03 Copier Fax Contract 0 0 0 400 0 101 42210 01 313.04 Security Contract 286 603 380 700 600 101 42210 01 313.05 SOT Joint Powers 1,381 1,598 2,301 2,700 2,700 101 42210 01 314.00 Annual Fire Relief Contribution 139,100 143,300 147,600 152,000 156,500 101 42210 01 319.00 Other Professional Services 1,300 Fire Prevention Education 101 42210 01 319.01 School Literature 0 0 0 250 200 101 42210 01 319.02 Door Prizes 0 38 0 150 200 101 42210 01 319.03 Fire Prevention Week Promos 2,897 1,764 525 900 500 101 42210 01 319.04 Food at Open House 0 247 511 150 200 101 42210 01 319.05 Summer Park Education 0 248 44 200 100 101 42210 01 319.06 National Night Out 0 78 0 150 100 101 42210 01 321.00 Telephone Costs 1,400 101 42210 01 321.01 Fire Dept. Cell Phones (5) 382 396 599 900 1,300 101 42210 01 321.02 Fire Marshal Cell Phone (1) 17 56 124 500 0 101 42210 01 321.03 Rescue 41 167 140 0 0 101 42210 01 321.04 Numeric Pagers 83 74 78 100 100 101 42210 01 322.00 Postage Costs 14 10 0 100 100 UPS Costs 101 42210 01 329.00 Other Communization Costs 19,200 101 42210 01 329.01 Base Repairs 0 50 0 200 100 101 42210 01 329.02 Pager Repairs 915 361 808 400 900 101 42210 01 329.03 Hand Held Repairs 364 179 330 300 100 101 42210 01 329.04 Mobile Repairs 323 211 125 300 100 101 42210 01 329.05 800 MHZ User Fee 0 0 0 16,500 18,000 101 42210 01 331.00 Travel Expense 4,900 101 42210 01 331.01 Minnesota Chiefs Conference 2,882 2,202 1,632 2,000 2,000 101 42210 01 331.02 Fire Department Association 817 979 1,736 900 1,600 101 42210 01 331.03 Outside Schools 589 893 489 2,000 1,300 101 42210 01 333.00 Freight Express Expense 0 22 0 0 0 101 42210 01 433.00 Dues Subscriptions 1,300 101 42210 01 433.01 Capital City 0 50 50 50 50 101 42210 01 433.02 VFBA Insurance 30 544 324 550 550 101 42210 01 433.03 State Fire 300 300 165 300 300 101 42210 01 433.04 State Chiefs 0 200 165 250 250 101 42210 01 433.05 DCFC 50 0 100 60 60 101 42210 01 433.06 WAKOTA Mutual Aid 25 50 0 50 50 101 42210 01 433.07 Purchasing Consortium 35 35 35 50 40 101 42210 01 433.08 NFPA 0 0 0 195 0 101 42210 01 433.09 MN Ass'n Fire Marshals 0 0 0 195 0 Fire Marshal Dues 101 42210 01 437.00 Conferences Seminars 900 101 42210 01 437.01 State Fire Conference 0 510 0 500 400 101 42210 01 437.02 State Chiefs Conference 450 840 450 400 500 101 42210 01 439.00 Other Miscellaneous Charges 1,600 101 42210 01 439.01 Food Coffee 328 376 50 250 150 101 42210 01 439.02 Extinguisher 0 73 860 400 300 101 42210 01 439.03 Plaques 65 0 0 40 40 101 42210 01 439.04 Paint 0 0 0 70 70 101 42210 01 439.05 Station Needs 664 2,673 2,496 840 1,040 101 42210 01 580.00 Other Equipment Purchases 101 42210 01 580.01 Bunker Gear (9) 2,803 4,409 11,627 9,000 9,000 101 42210 01 580.02 Pagers (6) 0 1,541 3,204 3,000 3,000 101 42210 01 580.03 Hose Replacement 0 0 4,694 1,000 1,000 101 42210 01 580.04 Replace Damaged Items 1,238 11,241 7,141 2,000 2,000 101 42210 01 581.00 Other Equipment Purchases 0 7,356 0 0 PAGE TOTALS $158,920 $186,473 $193,116 $204,000 15,000 $209,900 DEPARTMENT TOTALS $258,821 $311,063 $316,909 $318,500 $289,000 0 Page One August 13, 2008 Account 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 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 530.00 101 41940 01 530.01 101 41940 01 530.02 101 41940 01 601.00 101 41940 01 611.00 101 41940 01 621.00 2009 BUDGET WORKSHEETS GOVERNMENT BUILDINGS Description Salaries Benefits Maintenance Staff Full -Time Overtime Miscellaneous Supplies Building Repair Supplies Landscaping Materials Small Tools Minor Equipment Architects' Fees Contract Engineer Other Professional Services Elevator Maintenance Heating/Cooling Maint Contract Ahnual Boiler Inspections 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 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 Improvements Other Than Buildings Public Works Office Bldg Paint/Caulk Fire Station #1 Paint/Caulk Bond Principal Bond Interest Bond Paying Agent Fees PAGE TOTALS DEPARTMENT TOTALS 2005 2006 2007 Actual Actual Actual 46,046 48,114 49,402 0 2,869 3,137 2,689 0 15,483 13,558 20,513 17,000 6,499 7,053 5,924 9,000 1,316 81 169 500 115 0 355 200 2,038 719 2,804 2,000 0 0 3,000 0 1,500 2,250 750 3,000 800 167 456 3,339 4,070 2,000 8,979 673 10,018 10,000 12,871 53,025 40,332 13,000 O 0 0 500 397 0 307 1,000 0 0 0 1,000 O 0 10,000 62,000 80,000 38,737 41,158 43,579 46,000 39,811 41,043 37,205 44,400 775 775 0 600 $361,796 $389,249 $422,060 $526,500 $361,796 $389,249 $422,060 $528,500 2008 2009 Object 2009 Adopted Detail Proposed Budget Amount Budget 1,206 1,277 2,702 1,500 1,500 1,553 2,469 1,107 8,000 8,000 Includes all City Facilities 1,015 30 659 1,500 1,500 1,570 1,598 2,036 2,000 2,000 1,750 1,209 1,805 2,000 2,000 2,350 2,613 2,825 4,000 4,000 3,515 3,515 10,633 7,000 10,500 10,288 10,288 13,266 10,500 11,500 O 0 0 24,000 25,000 O 0 0 0 3,800 76,312 72,810 62,795 75,000 75,000 0 0 40 0 0 54,161 51,360 63,317 60,000 80,000 35,000 11,502 11,505 13,399 20,000 20,000 Added Parks 14,893 11,157 12,381 15,000 15,000 2 Cleanup Days per Year 3,790 3,694 3,810 3,800 0 Moved to "319.10" Above 5,000 10,000 25,000 500 All Salary Costs Inclusive of $0 Salary, Taxes, PERA Benefits O Increase to "319.09" Below 0 20,000 Cleaning Supplies, Towels, etc. 9,000 500 Trees Shrubs 200 Hand Tools, Bits, Blades, etc. 2,000 Equipment Replacement 0 Estimates 3,000 Contracted Engineer for City (5 69,800 40,500 City Hall 1,000 Scaffolding, Cleaners 1,000 Contingencies 85,000 48,500 MSABC Payment (2/1) 30,000 MSABC Payments (2/1 8/1) 1,500 $502,000 $502,000 Comments Page One August 13, 2008 2009 BUDGET WORKSHEETS FLEET MAINTENANCE Account Description Actual Actual Actual Budget Amount Budget 101 43100 101.00 Salaries Benefits 101 43100 77 101.00 Administrative 10,976 10,123 10,506 11,000 11,400 101 43100 79 101.00 Maintenance 123,318 128,087 131,936 137,500 145,000 101 43100 102.00 Full -Time Overtime 1,601 424 1,185 7,500 101 43100 01 211.00 Cleaning Supplies 735 1,377 1,082 1,000 1,000 Shop Vehicles 101 43100 01 212.00 Motor Fuels 115,276 135,325 167,365 160,000 230,000 Price Estimate' 101 43100 01 213.00 Lubricants Additives 3,636 5,035 9,188 5,500 5,500 101 43100 01 215.00 Shop Materials 11,937 17,092 14,649 17,000 17,000 101 43100 01 221.00 Equipment Parts 92,730 78,242 90,275 95,000 95,000 101 43100 01 222.00 Tires 11,258 6,841 9,976 16,000 12,000 101 43100 01 241.00 Small Tools 3,633 5,102 3,898 4,000 4,000 101 43100 01 242.00 Minor Equipment 4,528 1,973 2,633 6,000 6,000 101 43100 01 318.00 Contract Engineer 3,000 4,500 1,500 4,500 4,500 Contracted Engineer for City(10 101 43100 01 321.00 Telephone Costs 0 0 0 0 0 101 43100 01 323.00 Radio Units 473 2,257 850 2,000 2,000 Repair/Replace Units 101 43100 01 331.00 Travel Expense 0 0 0 0 0 101 43100 01 341.00 Employment Advertising 0 0 0 0 0 101 43100 01 384.00 Refuse Disposal 151 30 154 500 500 Shop Hazardous Waste 101 43100 01 394.00 P.C. Software Purchases 0 32 0 500 500 General Software Support 101 43100 01 404.00 Contracted Mach Equip Repairs 27,680 43,038 20,524 35,000 35,000 101 43100 01 416.00 Machinery Rental 0 0 0 1,000 1,000 101 43100 01 417.00 Uniforms Rental 83 145 139 0 0 101 43100 01 433.00 Dues Subscriptions 0 0 0 100 100 DOT Certification 101 43100 01 435.00 Books Pamphlets 190 376 51 0 0 101 43100 01 437.00 Conferences Seminars 75 999 364 500 500 $300 CarteGraph; $200 -Misc. PAGE TOTALS DEPARTMENT TOTALS Unleaded $3.25 /gallon x 40,000 gallons $130,000 Diesel $3.60 /gallon x 25,000 gallons 90,000 unleaded tax 5,500 diesel tax 2,000 Total for motor fuels $227,500 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed $411,281 $440,997 $466,276 $504,600 $578,500 $411,281 $440,997 $466,276 $504,600 $578,500 Comments All Salary Costs Inclusive of $156,400 Salary, Taxes, PERA Benefits 7,500 Page One August 13, 2008 2009 BUDGET WORKSHEETS STREET MAINTENANCE Account Description Actual Actual Actual Budget Amount Budget All Salary Costs Inclusive of 101 43121 101.00 Salaries Benefits $489,300 Salary, Taxes, PERA Benefits 101 43121 77 101.00 Administrative 32,930 30,368 31,519 32,800 34,200 101 43121 78 101.00 TechnicavClerical 44,643 53,684 57,671 60,200 63,500 101 43121 79 101.00 Maintenance 326,704 342,342 360,684 375,300 391,600 101 43121 102.00 Full-Time Overtime 7.396 5,164 10,601 16,000 16,000 Maintenance 101 43121 99 103.00 Part-Time Salaries Benefits 16,833 15,146 19,167 25,000 25,000 101 43121 01 201.00 Office Accessories 79 0 151 100 100 101 43121 01 203.00 Printed Forms Paper 300 101 43121 01 203.01 RAN Permit Inspection Forms 0 0 0 200 200 101 43121 01 203.02 Work Orders 51 27 0 50 100 Work Orders Through CarteGraph 101 43121 01 203.03 City Specification Books 2,953 0 0 0 0 101 43121 01 205.00 Drafting Supples 306 2 101 43121 01 205.01 Paper for Plan Reproductions 0 534 547 900 900 $600 for Plotter Ink, Paper 101 43121 01 205.02 Off-Site Reproductions 0 367 95 450 450 101 43121 01 205.03 Fllm Developing 0 0 0 200 200 101 43121 01 205.04 Miscellaneous Tools 50 0 0 550 550 Inspection Equipment 101 43121 01 209.00 Other Office Supplies 279 205 144 500 500 101 43121 01 216.00 Chemical Chemical Products 59,193 37,122 65,339 60,000 80,000 Road Salt 101 43121 01 224.00 Street Maintenance Materials 2,500 101 43121 01 224.01 Paint 475 312 543 500 500 101 43121 01 224.02 Mail Boxes 261 134 662 500 500 101 43121 01 224.03 Light Bulbs/Lenses 85 468 684 1,500 1,500 Replace with LED Bulbs 101 43121 01 225.00 Landscaping Materials 10,200 101 43121 01 225.01 Sod 35 19 37 3,000 1,500 101 43121 01 225.02 Seed 0 577 0 300 200 101 43121 01 225.03 Black Dirt 72 312 195 2,000 1,000 101 43121 01 225.04 Trees 0 73 0 1,000 500 101 43121 01 225.05 Planters Brackets 0 0 0 0 7,000 101 43121 01 226.00 Sign Repair Materials 7,941 13,133 9,146 15,000 15,000 101 43121 01 231.00 Bituminous Patching Materials 26,433 29,963 36,565 27,000 40,000 101 43121 01 232.00 Crushed Rock 33,061 23,805 30,077 30,000 30,000 101 43121 01 233.00 Dust Control Materials 18,460 27,600 29,368 30,000 35,000 101 43121 01 234.00 De -Icing Sand 3,742 2,649 2,476 1,200 1,200 300 Tons 101 43121 01 235.00 Shouldering Gravel 2,543 0 2,465 3,000 3,000 101 43121 01 241.00 Small Tools 1,125 1,499 1,603 2,000 2,000 Shovels, Brooms, etc. 101 43121 01 242.00 Minor Equipment 3,063 3,223 2,835 4,000 4,000 Safety Equipment 101 43121 01 303.00 Engineering Fees 62,545 76,428 37,886 8,500 8,500 General Non Project Related 101 43121 01 304.00 Legal Fees 12,183 493 1,063 2,000 2,000 Appeals of Closed Projects 101 43121 01 305.00 Medical Dental Fees 0 242 0 600 600 Employment Physicals 101 43121 01 310.00 Testing Services 537 0 0 1,200 1,200 101 43121 01 313.01 Temporary Service Fees 14,043 2,723 681 0 0 101 43121 01 318.00 Contract Engineer 6,000 9,000 3,000 9,000 9,000 Contracted Engineer for City(20%) 101 43121 01 319.00 Other Professional Services 5,887 658 1,727 500 500 Random Drug Testing to Admin 101 43121 01 321.00 Telephone Costs 1,842 3,501 2,442 3,000 3,000 Includes Wireless Technology 101 43121 01 324.00 Messenger Services 80 0 0 100 100 101 43121 01 331.00 Travel Expense 110 399 512 500 500 101 43121 01 341.00 Employment Advertising 1,949 0 0 0 0 101 43121 01 381.00 Electric Utlities 8 160 .E 101 43121 01 381.01 Street Lights 124,546 138,852 142,407 140,000 150,000 Price Increases 101 43121 01 381.02 Signal Lights Sirens 3,740 4,203 5,613 10,000 10,000 101 43121 01 384.00 Refuse Disposal 2,800 101 43121 01 384.01 Hazardous Waste Disposal 0 0 0 1,000 1,000 101 43121 01 384.02 Roadside Garbage 542 917 894 1,200 1,200 101 43121 01 384.03 Tree Disposal 0 0 173 600 600 101 43121 01 391.00 P.C. Maintenance 15,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 1,000 101 43121 01 391.03 Pavement Management Syst Sup 194 0 1,729 10,000 10,000 101 43121 01 391.04 R-O-W Permit On -Line Service 0 0 0 0 4,800 101 43121 01 392.00 P.C. Accessories Supplies 0 0 0 0 0 101 43121 01 394.00 P.S. Software Purchases 298 314 1,843 5,000 5,000 CarteGraph Maiit., GEOX Upgrade PAGE TOTALS 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed 823,217 826,457 862,542 887,450 965,200 Comments Page Two 2009 BUDGET WORKSHEETS STREET MAINTENANCE August 13, 2008 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget PAGE TOTALS $222,024 $247,148 $272,528 $318,650 $336,200 DEPARTMENT TOTALS $1,045,241 $1,073,605 $1,135,070 $1,206,100 $1,301,400 r__m =_xx xxax¢xxxx ax_ =axxxe xs--- -r^+- xxxaaxxc x x=xxe a Comments 101 43121 01 402.00 Parking Lot Seal Coating 0 0 0 16,000 10,000 101 43121 01 403.00 Contracted Repair Maintenance 34,000 101 43121 01 403.01 Street Lights 20,811 25,946 26,390 28,500 28,500 Repair 9 Street Lights (Annually) 101 43121 01 403.02 Signal Lights 29 1,891 0 500 500 101 43121 01 403.03 Light Replacements 115 0 0 500 5,000 101 43121 01 405.00 Street Striping 15,652 17,958 20,808 25,000 25,000 101 43121 01 406.00 Street Sweeping 3,160 4,557 2,175 5,000 0 101 43121 01 407.00 Bituminous Overlays 0 0 0 0 0 101 43121 01 408.00 Street Crack Sealing 19,891 31,434 33,091 35,000 45,000 101 43121 01 409.00 Tree Trimming 4,979 3,633 4,649 5,000 10,000 101 43121 01 410.00 Concrete Sidewalk/Curb Repairs 133,000 101 43121 01 410.01 General Repairs 424 3,706 7,843 8,000 8,000 101 43121 01410.02 Pedestrian Improvements 124,615 126,465 125,268 125,000 125,000 101 43121 01 411.00 Contracted Snow Removal 15,686 35,000 101 43121 01411.01 Community Center 0 4,008 13,060 12,000 15,000 101 43121 01 411.02 St. Joseph's 0 4,820 9,241 6,000 8,000 101 43121 01 411.03 Genz -Ryan 0 0 2,888 6,000 4,000 101 43121 01 411.04 Dakota County Library 0 0 0 0 8,000 101 43121 01 415.00 Equipment Rental 4,452 15,364 23,863 35,000 35,000 Bucket Truck Rental 101 43121 01 416.00 Snow Plow Loader Rental 7,199 0 0 0 0 101 43121 01 433.00 Dues Subscriptions 1.100 101 43121 01 433.01 American Public Works Ass'n 429 750 484 500 500 101 43121 01 433.02 "Future Use" 0 0 0 0 0 101 43121 01433.03 City Engineers' Association 0 0 28 0 0 101 43121 01 433.04 Professional Secretaries 100 0 0 0 0 101 43121 01 433.05 MN Society for Professional Eng. 375 0 0 0 0 101 43121 01 433.06 American Society of Civil Eng. 0 0 0 0 0 101 43121 01433.07 MN Street Superintendent Ass'n 0 0 0 100 100 101 43121 01 433.08 MN CPV Program 0 0 0 500 500 State Coop Purchasing Agreement 101 43121 01 435.00 Books Pamphlets 800 101 43121 01 435.01 MUTCD 0 0 0 200 200 101 43121 01 435.02 MN Dot Updates 121 0 0 600 600 101 43121 01 437.00 Conferences Seminars 5,300 101 43121 01 437.01 APWA 989 233 549 1,200 1,200 101 43121 01 437.02 Computer Training 251 384 0 500 500 101 43121 01 437.03 Clerical 100 249 0 150 200 101 43121 01 437.04 Gravel Road Maintenance 0 150 0 150 150 101 43121 01 437.05 Maintenance Expo 0 0 0 300 300 Was City Management Training 101 43121 01 437.06 CarteGraph User Conference 0 0 0 300 300 Was CEAM 101 43121 01437.07 Snow Conference 0 0 0 650 650 Was MN Pavement Management 101 43121 01 437.08 MN Dot 0 0 440 0 0 101 43121 01 437.09 Miscellaneous Training 554 3,648 1,014 4,000 2,000 101 43121 01439.00 Other Miscellaneous Charges 2,091 590 738 2,000 2,000 Host CONDAC, Cartegraph Mtngs. 101 43121 01 570.00 Office Equipment Furnishings 0 1,362 0 0 0 Page One August 13, 2008 Account 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 2009 BUDGET WORKSHEETS PARKS GROUNDS MAINTENANCE Description Salaries Benefits Administrative Maintenance Ful�Time Overtime Part-Time Salaries Benefits 101 45202 01 303.00 Engineering Fees 101 45202 01 305.00 Medical and Dental Fees 101 45202 01 318.00 Contract Engineer 101 45202 01 321.00 Telephone Costs 101 45202 01 323.00 Radio Units 101 45202 01 331.00 Travel Expense 101 45202 01 341.00 Employment Advertising 101 45202 01 381.00 Electric Utilities 101 45202 01 381.01 Skating Rinks 101 45202 01 381.02 Softball Fields 101 45202 01 381.03 Irrigation 101 45202 01 383.00 Gas Utilities 101 45202 01 394.00 P.C. Software Purchases 101 45202 01 530.00 Improvements Other Than Bldgs 101 45202 01 530.01 Jaycee Rink 101 45202 01 530.02 Claret Tennis Court 101 45202 01 530.03 Bloomfield Tennis court 101 45202 01 530.04 Schwarz Pond Park Parking Lot PAGE TOTALS DEPARTMENT TOTALS 2005 Actual 2006 2007 Actual Actual 2008 2009 Object 2009 Adopted Detali Proposed Budget Amount Budget Comments At Salary Costs Inclusive of $409,100 Salary, Taxes, PERA Benefits 10,977 10,123 10,506 11,000 11,400 310,226 346,649 366,723 386,400 397,700 5,578 7,018 11,384 14,000 14,000 31,516 19,544 15,478 35,000 35,000 Drafting Supplies 0 0 0 Chemical Chemical Products Herbicides(General Park Use) 8,027 9,230 6,081 12,000 12,000 Fertilizer 18,780 16,426 18,304 22,000 22,000 Other Operating Supplies Seed, Sod, etc. 2,561 2,492 3,426 3,000 3,000 Red Rock, Sand, Gravel, etc. 2,222 5,964 3,472 7,000 7,000 Repair Supplies 0 16 334 3,000 3,000 Bituminous 0 0 0 0 0 Wood Chips 0 0 0 6,000 6,000 Equipment Parts Playground Equipment Repair 4,464 2,855 7,791 4,500 4,500 Irrigation Repair(Non- Contract) 2,707 3,357 5,735 5,000 7,500 Miscellaneous 843 883 3,289 2,500 2,500 Park Sign Replacements 4,290 5,473 0 2,500 2,500 Building Repair Supplies Paint, Stain, etc. 1,270 2,152 981 1,500 1,500 Shingles, Boards, etc. 1,998 1,705 1,012 2,000 2,000 Miscellaneous 784 1,502 1,503 1,500 1,500 Shelter/Shed Repairs 7,238 4,809 5,219 30,000 5,000 Landscaping Materials Trees, Shrubs, Sod, etc. 2,301 6,082 4,536 Timbers, Fence, etc. 2,302 456 629 Sign Repair Materials 284 0 492 Other Maintenance Supplies 3,982 6,196 3,731 Small Tools 1,660 2,584 2,377 Minor Equipment 1,326 2,089 1,053 4,031 6,506 2,138 2,487 0 5,104 8,740 2,929 2,292 0 5,831 5,937 3,190 2,574 0 101 45202 01 403.00 Contracted Repair Maintenance 101 45202 01 403.01 Irrigation Repairs 0 0 913 1,500 5,000 101 45202 01 403.02 Electrical Repairs 1,860 4,308 7,362 3,000 6,000 101 45202 01 403.03 Miscellaneous Repairs 160 2,080 6,013 5,000 3,000 101 45202 01 409.00 Other Contracted Repa Maint 3,913 16,459 4,222 8,000 101 45202 01 416.00 Machinery Rental 101 45202 01 416.01 Mower Leases 14,100 14,100 18,395 17,000 19,000 101 45202 01 416.02 Miscellaneous Rentals 973 1,758 1,851 1,500 1,500 101 45202 01 433.00 Dues Subscriptions 101 45202 01 433.01 MN Park Supervisors Ass'n 35 0 0 50 50 101 45202 01 433.02 Miscellaneous Dues 0 70 35 150 150 101 45202 01 435.00 Books Pamphlets 152 0 0 100 101 45202 01 437.00 Conferences Seminars 101 45202 01 437.01 Seminars Workshops 1,085 346 726 1,500 1,500 101 45202 01 437.02 School Tuition 891 445 475 400 400 101 45202 01 439.00 Other Miscellaneous Charges 348 0 0 200 O 0 0 58,000 O 0 0 10,000 O 0 0 4,000 O 0 0 52,500 $467,286 $521,414 $535,318 0769,400 $467,286 $521,414 $535,318 $769,400 100 100 34,000 Includes all City Facilities 6,000 10,000 5,000 3,300 5,000 6,000 10,000 5,000 19,000 Special Wood Chips- Playgrounds 17,000 Koch Trap Sign Replacement 10,000 7,000 3,500 3,500 3,500 3,500 500 6,000 6,000 Paint, Chafc, Bases, Field Dry,etc. 2,500 2,500 Hand Tools, Blades, Bits, etc. 5,000 2, O 0 0 0 0 O 0 0 600 600 Employment Physicals 1,500 2,250 750 3,000 3,000 Contracted Engineer for City (5 1,773 2,928 2,988 3,100 3,100 Includes WirelessTechnobgy O 0 0 500 500 Handheld Radios O 0 0 0 0 O 0 0 0 0 21,000 3,300 5,000 CarteGraph Maint, GEOX Upgrade 14,000 System Blow -Out 8,000 Chemical Lawn Services 20,500 Exmark, 2 John Deere $688,100 $688,100 200 Was MRPA 100 1,900 Green Expo, MPSA, Playgrounds Turf School, Power Limited Tech. 200 Contingencies 50,000 Annual Total Expenditures Page One August 13, 2008 Account 101 45100 101.00 101 45100 102.00 101 45100 103.00 101 45100 10 103.00 101 45100 12 103.00 101 45100 83 103.00 101 45100 94 103.00 101 45100 99 103.00 101 45100 71 103.00 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 2009 BUDGET WORKSHEETS PARKS RECREATION Description Salaries Benefits Full -Time Overtime Part-Time Salaries Benefits P/T Receptionists (2) Building Attendants Playground Recreation Leaders Warming House Attendants Park Rec Committee P/T Horticulturist 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 101 45100 01 401.00 Contracted Building Repaks 101 45100 01 404.00 Contracted Mach Equip Repairs 101 45100 01 409.00 Other Contracted Repair Maint 101 45100 01 412.00 Building Rental 101 45100 01 415.00 Other Equipment Rental 101 45100 01 433.00 Dues Subscriptions 101 45100 01 433.01 MRPA Dues 101 45100 01 433.02 Miscellaneous 101 45100 01433.03 On -Line Registrat'n Subscription 101 45100 01 435.00 Books Pamphlets 101 45100 01 437.00 Conferences Seminars 101 45100 01 437.01 MRPA State Conference 101 45100 01 437.02 MIAMA State Conference 101 45100 01 437.03 Workshops, Schools, Tuition 101 45100 01439.00 Other Miscellaneous Charges 101 45100 01 530.00 Improvements Other Than Bldgs PAGE TOTALS General Operating DEPARTMENT TOTALS 2005 2006 2007 Actual Actual Actual All Salary Costs Inclusive of $576,211 $608,445 $644,547 $673,500 $661,000 Salary, Taxes, PERA Benefits 9,458 10, 899 12,871 11,000 11,000 140,800 23,770 28,168 20,723 43,000 44,800 2 Part-Tine Receptionists 50,603 52,065 47,070 49,000 49,000 16,262 19,160 22,902 22,000 23,000 9,442 10,811 10,511 13,000 15,000 2,396 1,877 1,595 2,500 2,500 14 2,976 4,985 6,500 6,500 285 0 46 0 408 782 706 1,000 O 0 0 200 O 74 100 500 437 1,102 282 1,600 4,254 5,669 5,171 6,000 1,181 2,009 1,408 2,000 4,903 6,779 5,709 7,000 9,424 9,483 8,932 9,500 4,194 4,213 3,555 5,500 O 148 0 0 2008 2009 Object 2009 Adopted Detail Proposed Budget Amount Budget Comments 0 1,000 Film, Devebping Laminating 200 Books, Tapes, etc. 500 Meeting Supplies 1,600 Envelopes, Forms, Rulers, etc. 6,000 2,000 7,000 Rec Programs, 1st Aid Sup, etc. 9,500 5,500 0 O 0 0 0 0 O 230 50 800 800 Employment Physicals 4,899 5,700 9,074 6,500 9,000 Custodial Services- Banquet Rm 16,200 2,295 2,150 3,139 3,000 6,000 Performances (Add Movies) 600 800 200 600 600 Trophies Awards 204 130 16 500 0 46 270 53 400 400 Ribbons Mailings 2,157 2,057 2,619 3,900 3,900 Trees 291 299 0 500 500 Tapes, Fuses, Puppets, etc. 601 971 197 1,000 1,000 Publicity Supplies 172 345 1,357 1,000 1,000 Flyers, Signs 827 756 2,009 2,000 2,000 Start Up Costs O 0 0 800 800 ADA Program Supplies 1,804 2,437 393 2,500 2,500 ADA Services/Eng.LA Sery Test 2,425 2,234 2,351 3,100 3,100 Pagers Cellular Phones 149 147 196 500 500 1,602 0 675 2,800 2,800 General Employment Ads 42,300 24,792 26,047 36,019 35,000 35,000 Clty Newsletter (4 Per Year) 3,692 4,363 5,080 3,400 3,400 Rec Ads 1,753 2,284 2,250 3,900 3,900 Garage Sale Ad 23,240 25,383 27,291 26,000 27,000 34,957 31,488 34,232 33,600 50,000 3,106 3,190 3,720 4,000 4,000 O 3,431 0 0 0 O 1,409 0 0 0 O 0 0 13,000 13,000 On -Line Registration S/W Supp. 7,862 9,049 12,066 10,000 11,000 4,810 6,799 8,793 8,000 8,000 19,389 19,268 22,736 30,000 30,000 Air Handler Maintenance Contract 16,800 16,800 16,800 16,800 16,800 Monthly Rent Payments to Guard 14,060 13,213 12,367 18,000 18,000 Portable Toilets Other Rentals 3,700 1,259 1,259 1,259 1,900 767 941 867 400 O 0 0 1,200 O 0 0 100 1,721 1,260 1,677 2,000 O 0 0 300 463 997 469 2,200 25,004 7,595 19,991 0 O 0 0 0 $914,988 $957,960 $1,019,058 $1,093,500 $914,988 $957,960 $1,019,058 $1,093,500 2,100 400 1,200 2,000 300 2,200 Minn Recreation Parks Ass'n Paper, Magazines, JC Dues, etc. 100 4,500 0 Donation Account 45,000 New Initiatives $1,154,400 $1,154,400 Page Two August 13, 2008 Account 2009 BUDGET WORKSHEETS PARKS RECREATION Description 101 45100 81 Softball 101 45100 82 Volleyball 101 45100 84 Tennis 101 45100 85 Tiny Tots 101 45100 86 Rosettes 101 45100 87 Trips 101 45100 88 Broomball 101 45100 89 Outdoor Skating Lessons 101 45100 90 Run for the Gob 101 45100 91 Camps 101 45100 92 Adult Basketball 101 45100 93 Other Programs 101 45100 95 T -BaU 101 45100 96 Teen Night 101 45100 97 Soccer League 101 45100 98 Soccer Lessons 101 45100 81 103.00 101 45100 81 219.00 101 45100 81 311.00 101 45100 81 319.00 101 45100 82 103.00 101 45100 82 219.00 101 45100 82 311.00 101 45100 82 319.00 101 45100 84 103.00 101 45100 84 219.00 101 45100 85 103.00 101 45100 85 219.00 101 45100 86 103.00 101 45100 86 219.00 101 45100 87 103.00 101 45100 87 219.00 101 45100 87 219.01 101 45100 87 219.02 101 45100 88 219.00 101 45100 88 311.00 101 45100 89 103.00 101 45100 89 219.00 101 45100 90 219.00 101 45100 91 103.00 101 45100 91 219.00 101 45100 92 219.00 101 45100 93 103.00 101 45100 93 219.00 101 45100 93 319.00 101 45100 95 103.00 101 45100 95 219.00 101 45100 96 103.00 101 45100 98 219.00 101 45100 97 103.00 101 45100 97 219.00 101 45100 97 311.00 101 45100 98 103.00 101 45100 98 229.00 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $47,639 $44,625 $43,973 $51,000 $45,000 40 335 85 900 0 1,042 1,137 1,727 800 2,000 18,739 21,285 22,769 19,000 21,500 784 817 1,281 2,000 1,200 10,737 10,667 7,327 11,000 8,300 0 0 0 0 0 135 0 0 400 0 2,655 3,405 3,966 3,000 4,000 13,634 14,918 11,917 14,000 12,000 176 0 501 1,900 600 11,331 13,017 14,348 13,000 14,500 4,354 5,320 6,587 5,000 7,000 7,575 5,245 5,322 5,000 5,000 0 844 11,071 0 0 365 1,211 2,682 1,300 2,600 $123,700 Comments No League In 2009 119,205 122,828 133,556 128,300 123,700 Part-Time Salaries 25,910 7,746 6,568 7,000 7,000 Operating Supplies 9,178 5,609 7,521 11,000 8,000 Officiating Fees 8,784 28,000 26,266 28,000 27,000 Other Professional Services 3,767 3,270 3,617 5,000 3,000 Part-Time Salaries 0 0 0 0 0 Operating Supplies 40 335 85 900 0 Officiating Fees 0 0 0 0 0 Other Professional Services 0 0 0 0 0 Part-Time Salaries 898 1,061 1,223 650 1,500 Operating Supplies 45 76 504 150 500 Part-Tine Salaries 16,289 18,829 21,617 18,000 20,000 Operating Supplies 2,451 2,455 1,152 1,000 1,500 Part-Tine Salaries 247 356 346 1,200 400 Operating Supplies 537 460 935 800 800 Part-Time Salaries 769 859 799 1,000 1,000 Operating Supplies 9,969 9,807 10,000 7,300 Youth/Teen Trips Supplies 0 0 4,369 4,300 Adult/Senior Trips Supplies 0 0 2,159 3,000 Operating Supplies 0 0 0 0 0 Officiating Fees 0 0 0 0 0 Part-Time Salaries 135 0 0 400 0 Operating Supplies 0 0 0 0 0 Operating Supplies 2,655 3,405 3,966 3,000 4,000 Part-Time Salaries 6,772 6,773 4,319 7,000 5,000 Operating Supplies 6,862 8,145 7,598 7,000 7,000 Operating Supplies 176 0 501 1,900 600 Part-Tine Salaries 2,750 3,013 3,093 3,000 3,000 Operating Supplies 8,581 10,004 10,265 10,000 11,500 Other Professional Services 0 0 990 0 0 Part-Time Salaries 3,103 3,641 4,585 4,000 5,500 Operating Supplies 1,251 1,679 2,002 1,000 1,500 Part-Time Salaries 1,220 1,273 1,684 0 0 Operating Supplies 8,355 3,971 3,638 5,000 5,000 Part-Time Salaries 0 806 0 0 0 Operating Supplies 0 38 821 0 0 Officiating Fees 0 0 10,250 0 0 Part-Time Salaries 0 273 1,571 300 1,000 Operating Supplies 365 938 1,112 1,000 1,600 SPECIAL PROGRAM TOTALS 119,205 122,826 133,556 128,300 123,700 GRAND TOTAL PARK REC $1,034,194 $1,080,786 $1,152,615 $1,221,800 $1,278,100 Page One 101 49300 01710.00 Transfers 2009 BUDGET WORKSHEETS OTHER FINANCING USES August 13, 2008 2007 2008 Object 2008 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget FUND TOTALS $0 $0 $100,000 $165,000 $0 $0 $100,000 $165,000 $115,000 Comments $115,000 Arena Operations Assistance Page One August 13, 2008 Account 206 31010.00 206 33100.00 206 36210.00 206 36214.00 206 36215.00 206 36260.00 Account 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 208 49006 01 369.00 206 49006 01 409.00 206 49006 01 439.00 2009 BUDGET WORKSHEETS INSURANCE REVENUES Description Current Ad Valorem Taxes Federal Grants Aids Interest Eamings Investments Net Change in FV- Investments Interest Eamings Other Revenue FUND TOTALS INSURANCE EXPENDITURES Description 206 49006 01 221.00 Equipment Parts 2005 2006 2007 Actual Actual Actual $255,000 $260,000 $260,000 $275,000 0 0 0 0 12,452 23,660 29,968 23,000 0 0 562 0 401 292 161 500 40,083 14,775 26,743 20,000 307,936 298,727 317,433 318,500 2005 2006 2007 Actual Actual Actual $232 $1,163 $2,653 $2,000 Legal Fees 0 0 0 1,000 Medical Dental Fees 3,517 6,543 7,260 8,000 General Fund Administrative Fees 2,500 2,500 2,500 2,500 Other Professional Services 16,970 17,495 18,240 18,000 Risk Management Consultant CHESS Consultant Worker's Compensation Insurance 61,648 70,877 76,437 75,000 Other insurance 133,147 180,146 178,524 200,000 Other Contracted Repair Maint 11,677 11,136 17,747 12,000 Other Miscellaneous Charges 0 0 97 0 FUND TOTALS 229,691 289,860 303,458 318,500 NOTE: Levy of $275,000 covers costs for all insurance premiums. All other expenditures covered through interest eamings and insurance refunds/dividends. 2008 2009 Object 2009 Adopted Detail Proposed Budget Amount Budget 324,500 2008 2009 Object 2009 Adopted Detail Proposed Budget Amount Budget 9,500 10,500 $275,000 0 28,000 0 Annual Market Value Changes 500 21,000 insurance Refunds/Dividends $3,000 Liability Auto Deductible Pymts 1,000 8,000 2,500 20,000 85,000 Annual Premium 190,000 Annual Premium General Liability 15,000 Liability Auto Deductible Pymts 0 324,500 Comments Comments Unreimbursable Legal Fees Work Comp Deductible Pymts Yearly Fee Per Policy F -3 Risk Management Consultant Page One August 19, 2008 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 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 48300 01 437.00 201 46300 01 439.00 201 46300 01 521.00 201 46300 01 525.00 201 46300 01 530.00 201 46300 01 710.00 2009 BUDGET WORKSHEETS PORT AUTHORITY REVENUES Description Current Ad Valorem Taxes Tax Increments Federal Grants -CDBG Other State Grants Aids Other Charges for Services Principal on Notes Interest Eamings Investments Interest Eamings Blake Interest Eamings Contributions/Donations Other Revenue Use of Reserve Funds Sales of General Fixed Assets FUND TOTALS Description EXPENDITURES Part-Time Salaries Benefits 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/Joumt Foreign Trade Zone Commission Conferences Seminars Other Miscellaneous Charges Building Structure Purchases Building Structure Purchases Improvements Other Than Bldgs Transfers FUND TOTALS 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $60,000 $60,000 $0 $50,000 $50,000 Operating Levy O 0 0 0 0 Admin Fees Portion Only O 0 0 0 0 O 0 0 0 0 LCDA Downtown Grant O 0 11,258 8,000 0 Genz -Ryan Tenant Utility Pymts 41,512 38,064 499,021 0 0 Blake UT Lease Sold in 2007 2,816 5,552 5,254 2,000 2,000 Interest Eamed on CD's 6,998 6,484 3,072 0 0 Blake L/T Lease Sold in 2007 274 355 418 200 200 Checking Interest Misc O 0 0 0 0 15,000 0 0 0 0 O 0 0 25,000 22,500 O 0 0 0 0 5126,599 5110,454 $519,021 $85,200 574,700 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $3,140 $4,233 $5,393 $5,000 55,000 0 1,421 0 7,000 4,000 4,744 3,834 6,254 5,000 5,000 525 0 0 0 0 (EIS) or (AUAR) O 0 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 O 0 0 0 0 6,000 6,000 6,400 6,000 6,000 Yearly Fee Per Policy F -3 8,000 981 919 3,750 2,000 2,000 11,482 14,599 70 0 0 Moved to "349.00" Below 3,240 3,152 7,066 4,000 4,000 888 834 2,170 1,000 1,000 0 0 0 0 1,000 0 0 85 3,000 3,000 O 73 163 20,000 20,000 Additional Marketing O 0 0 200 200 197 0 0 10,000 10,000 368 399 429 500 500 Commissioners 2,225 1,454 4,323 5,000 2,500 Property Insurance 175 3,207 7,229 4,000 1,000 Business Park Other Properties O 846 8,314 4,000 0 Other Properties 668 1,258 1,789 1,000 1,000 Utility Fees O 0 964 0 0 2,000 Prof Organizations/Joumals 448 1,365 1,360 2,000 2,000 15,000 15,000 15,000 0 0 4,403 4,844 7,106 5,000 6,000 Development/TIF/Miscellaneous 457 788 139 500 500 Contingencies O 0 0 0 0 67,000 0 558,910 0 0 O 0 0 0 0 Special Downtown Projects O 0 0 0 0 $121,943 $64,224 $636,913 585,200 $74,700 Comments Comments All Salary Costs Inclusive of Salary, Taxes, PERA Benefits Port Authority Members Page One 2009 BUDGET WORKSHEETS DOWNTOWN /BROCKWAY DISTRICT(0108) REVENUES August 13, 2008 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 242 31050.00 Tax Increments $0 $14,675 $134,224 $150,000 $300,000 242 36210.00 Interest Eamings Investments 1,217 0 803 0 0 242 36215.00 Interest Eamings 157 70 258 0 0 242 36220.00 Rents Royalties 0 9,679 65,041 0 0 242 36260.00 Other Revenue 0 0 10,000 0 0 FUND TOTALS FUND TOTALS EXPENDITURES $1,374 $24,425 $210,326 $150,000 $300,000 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments Comments 242 49042 01 319.00 Other Professional Services $56,880 $6,188 $89,898 $0 $0 242 49042 01 522.00 Building Structure Purchases 194,590 2,460,390 356,987 0 0 242 49042 01 530.00 Improvements Other Than Buildings 0 0 35,139 75,000 0 242 49042 01 611.00 Interest on Internal Loan 17,785 64,376 127,656 75,000 0 242 49042 01 710.00 Transfers 0 0 0 0 300,000 P I for 2008A 2008B Issues $269,255 $2,530,954 $609,681 $150,000 $300,000 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 332 G.O. IMPROVEMENT BONDS, 1998A REVENUES- September 2, 2008 2008 2009 2005 2006 2007 Adopted Proposed Account* Description Actual Actual Actual Budget Budget 332 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 332 36101.00 Principal Special Assessments 64,895 73,499 86,344 0 0 332 36102.00 Penalties Interest S/A 1,942 (6,516) 29 0 0 332 36210.00 Interest Eamings Investments 12,385 19,970 10,361 0 0 332 36215.00 Interest Eamings 28 45 56 0 0 332 36265.00 Use of Reserve Funds 0 0 0 198,500 189,900 332 37145.00 Surcharge on Water Revenues 0 0 0 0 0 332 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 332 39202.00 Contribution From Enterprises 0 0 0 0 0 332 39203.00 Transfer From 0 0 0 0 0 332 39204.00 Transfer From Water Core 0 0 0 0 0 332 39205.00 Transfer From Sewer Core 0 0 0 0 0 332 39206.00 Transfer From Storm Core 0 0 0 0 0 332 39207.00 Transfer From Port Authority 0 0 0 0 0 332 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $79,250 $86,998 $96,790 $198,500 $189,900 EXPENDITURES- 2008 2009 2005 2006 2007 Adopted Proposed Account* Description Actual Actual Actual Budget Budget Comments Comments 332 47000 01 317.00 General Fund Admin Fees $0 $0 $0 SO $0 332 47000 01 319.00 Other Professional Services 0 0 0 0 0 332 47000 01 601.00 Bond Principal 195,000 195,000 190,000 185,000 185,000 332 47000 01 611.00 Bond Interest 38,674 30,094 21,480 13,000 4,400 332 47000 01 621.00 Bond Paying Agent Fees 526 425 200 500 500 332 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $234,200 $225,519 $211,680 8198,500 $189,900 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 384 G.O. PORT AUTHORITY MUNICIPAL BUILDING REFUNDING BONDS, 1998A REVENUES September 2, 2008 Account Description Actual Actual Actual Budget Budget 384 31010.00 Current Ad Valorem Taxes $383,516 $412,806 $566,710 $251,389 $0 384 36101.00 Principal Special Assessments 0 0 8,546 0 0 384 36102.00 Penalties Interest S/A 0 0 10 0 0 384 36210.00 Interest Eamings Investments 8,026 27,508 47,256 0 0 384 36215.00 Interest Eamings 34 32 50 0 0 384 36265.00 Use of Reserve Funds 0 0 0 0 1,752,300 384 37145.00 Surcharge on Water Revenues 0 0 0 0 0 384 39101.00 Sale of General Fixed Assets 0 0 0 0 0 384 39202.00 Contribution From Enterprises 0 0 0 0 0 384 39203.00 Transfer From 0 144,786 55,799 0 0 384 39204.00 Transfer From Water Core 0 0 0 0 0 384 39205.00 Transfer From Sewer Core 0 0 0 0 0 384 39206.00 Transfer From Storm Core 0 0 0 0 0 384 39207.00 Transfer From Port Authority 0 0 0 0 0 384 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $391,576 $585,132 $678,371 $251,389 $1,752,300 EXPENDITURES 2008 2009 2005 2006 2007 Adopted Proposed 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments Comments 384 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 384 47000 01 319.00 Other Professional Services 0 0 0 0 0 384 47000 01 601.00 Bond Principal 135,000 135,000 145,000 155,000 1,710,000 Call Bonds in Full 2/1/09 384 47000 01 611.00 Bond Interest 107,268 101,260 94,924 88,100 42,300 384 47000 01 621.00 Bond Paying Agent Fees 0 0 0 0 0 384 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $242,268 $236,260 $239,924 $243,100 $1,752,300 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 335 G.O. IMPROVEMENT BONDS, 1999A REVENUES September 2, 2008 Account 335 31010.00 335 36101.00 335 36102.00 335 36210.00 335 36215.00 335 36260.00 335 36265.00 335 37145.00 335 37160.00 335 39202.00 335 39203.00 335 39204.00 335 39205.00 335 39206.00 335 39207.00 335 39310.00 Account 335 47000 01 317.00 335 47000 01 319.00 335 47000 01 601.00 335 47000 01 611.00 335 47000 01 621.00 335 47000 01 710.00 Description Current Ad Valorem Taxes $0 $0 $0 $0 $0 Principal Special Assessments 32,367 30,821 29,275 0 0 Penalties Interest S/A 0 0 0 0 0 Interest Eamings Investments 30,999 40,278 50,968 0 0 Interest Earnings 44 60 33 0 0 Other Revenue 0 0 0 0 0 Use of Reserve Funds 0 0 0 295,700 279,200 Surcharge on Water Revenues 0 0 0 0 0 Penalties Surcharge Revenues 0 0 0 0 0 Contribution From Enterprises 0 0 0 0 0 Transfer From 0 0 0 0 0 Transfer From Water Core 0 0 0 0 0 Transfer From Sewer Core 0 0 0 0 0 Transfer From Storm Core 0 0 0 0 0 Transfer From Port Authority 0 0 0 0 0 Bond Proceeds 0 0 0 0 0 FUND TOTALS EXPENDITURES Description General Fund Admin Fees Other Professional Services Bond Principal Bond Interest Bond Paying Agent Fees Transfers 2005 Actual 2008 2006 2007 Adopted Actual Actual Budget 2009 Proposed Budget 563,411 $71,159 $80,277 $295,700 $279,200 2005 2006 Actual Actual 2008 2007 Adopted Actual Budget 2009 Proposed Budget Comments Comments $0 $0 $0 so $0 0 0 0 0 0 475,000 265,000 260,000 255,000 250,000 79,058 63,148 51,730 40,300 28,800 403 403 403 400 400 0 0 0 0 0 FUND TOTALS $554,460 $328,550 $312,133 $295,700 $279,200 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 617 G.O. WATER REVENUE BONDS, 2000A REVENUES September 2, 2008 Account Description Actual Actual Actual Budget Budget 617 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 617 36101.00 Principal Special Assessments 0 0 0 0 0 617 36102.00 Penalties Interest S/A 0 0 0 0 0 617 36210.00 Interest Eamings Investments 2,656 5,038 6,673 0 0 617 36215.00 Interest Earnings 8 25 15 0 0 617 36265.00 Use of Reserve Funds 0 0 0 0 0 617 37145.00 Surcharge on Water Revenues 0 0 0 0 0 617 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 617 39202.00 Contribution From Enterprises 0 0 0 0 0 617 39203.00 Transfer From 428 0 0 0 0 617 39204.00 Transfer From Water Core 115,000 112,000 115,000 117,000 113,000 617 39205.00 Transfer From Sewer Core 0 0 0 0 0 617 39206.00 Transfer From Storm Core 0 0 0 0 0 617 39207.00 Transfer From Port Authority 0 0 0 0 0 617 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $118,092 $117,063 $121,688 $117,000 $113,000 EXPENDITURES 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget 617 47000 01 317.00 General Fund Admin Fees 617 47000 01 319.00 Other Professional Services 617 47000 01 601.00 Bond Principal 65,000 65,000 70,000 75,000 75,000 617 47000 01 611.00 Bond Interest 47,819 44,799 41,532 39,500 35,900 617 47000 01 614.00 Amortization of Bond Discount 1,351 1,351 1,351 1,400 1,400 617 47000 01 621.00 Bond Paying Agent Fees 316 374 374 600 700 617 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS 2008 2009 2005 2006 2007 Adopted Proposed Comments Comments $o $o $o $o $o 0 0 0 0 0 $114,487 $111,524 $113,257 $116,500 $113,000 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 612 G.O. STORM WATER REVENUE BONDS, 2001B REVENUES- September 2, 2008 Account Description Actual Actual Actual Budget Budget 612 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 612 36101.00 Principal Special Assessments 0 0 0 0 0 612 36102.00 Penalties Interest S/A 0 0 0 0 0 612 36210.00 Interest Eamings Investments 2,805 7,195 9,316 0 0 612 36215.00 Interest Earnings 12 28 25 0 0 612 36265.00 Use of Reserve Funds 0 0 0 0 0 612 37145.00 Surcharge on Water Revenues 0 0 0 0 0 612 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 612 39202.00 Contribution From Enterprises 53,000 54,000 53,000 55,000 53,000 612 39203.00 Transfer From 0 0 0 0 0 612 39204.00 Transfer From Water Core 0 0 0 0 0 612 39205.00 Transfer From Sewer Core 0 0 0 0 0 612 39206.00 Transfer From Storm Core 53,000 54,000 53,000 55,000 53,000 612 39207.00 Transfer From Port Authority 0 0 0 0 0 612 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $108,817 $115,222 $115,341 $110,000 $106,000 EXPENDITURES 2008 2009 2005 2006 2007 Adopted Proposed 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments Comments 612 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 612 47000 01 319.00 Other Professional Services 0 0 0 0 0 612 47000 01 601.00 Bond Principal 60,000 65,000 65,000 70,000 70,000 612 47000 01 611.00 Bond Interest 43,451 40,868 38,268 36,700 33,900 612 47000 01 614.00 Amortization of Bond Discount 1,303 1,303 1,303 1,300 1,300 612 47000 01 621.00 Bond Paying Agent Fees 403 403 403 400 400 612 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $105,156 $107,573 $104,973 $108,400 $105,600 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 382 G.O. PORT AUTHORITY PUBLIC FACILITY BONDS, 2001C REVENUES September 2, 2008 Account 382 31010.00 382 36101.00 382 36102.00 382 36210.00 382 36215.00 382 36265.00 382 37145.00 382 39101.00 382 39202.00 382 39203.00 382 39204.00 382 39205.00 382 39206.00 382 39207.00 382 39310.00 Account 382 47000 01 317.00 382 47000 01 319.00 382 47000 01 601.00 382 47000 01 611.00 382 47000 01 621.00 382 47000 01 710.00 Description FUND TOTALS EXPENDITURES Description General Fund Admin Fees Other Professional Services Bond Principal Bond Interest Bond Paying Agent Fees Transfers FUND TOTALS 2008 2005 2006 2007 Adopted Actual Actual Actual Budget Current Ad Valorem Taxes $169,764 $171,864 $168,504 $170,394 $172,074 Principal Special Assessments 0 0 0 0 0 Penalties Interest S/A 0 0 0 0 0 Interest Eamings Investments 3,071 9,034 10,168 0 0 Interest Earnings 30 22 17 0 0 Use of Reserve Funds 0 0 0 0 0 Surcharge on Water Revenues 0 0 0 0 0 Sale of General Fixed Assets 0 0 0 0 0 Contribution From Enterprises 0 0 0 0 0 Transfer From 0 0 0 0 0 Transfer From Water Core 0 0 0 0 0 Transfer From Sewer Core 0 0 0 0 0 Transfer From Storm Core 0 0 0 0 0 Transfer From Port Authority 0 0 0 0 0 Bond Proceeds 0 0 0 0 0 2005 2006 Actual Actual 2009 Proposed Budget $172,865 $180,920 $178,689 $170,394 $172,074 2008 2007 Adopted Actual Budget 2009 Proposed Budget Comments Comments $0 $0 50 50 50 0 0 0 0 0 75,000 75,000 80,000 80,000 85,000 88,180 85,180 82,080 78,900 75,600 403 431 431 500 500 0 0 0 0 0 $163,583 $160,611 $162,511 $159,400 $161,100 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 304 G.O. COMMUNITY CENTER REFUNDING BONDS, 2001 E REVENUES- September 2, 2008 Account Description Actual Actual Actual Budget Budget 304 31010.00 Current Ad Valorem Taxes $99,878 $91,945 $94,704 $96,941 $93,713 304 36101.00 Principal Special Assessments 0 0 0 0 0 304 36102.00 Penalties Interest S/A 0 0 0 0 0 304 36210.00 Interest Eamings Investments 1,464 3,835 5,310 0 0 304 36215.00 Interest Eamings 48 28 32 0 0 304 36265.00 Use of Reserve Funds 0 0 0 0 0 304 37145.00 Surcharge on Water Revenues 0 0 0 0 0 304 39101.00 Sale of General Fixed Assets 0 0 0 0 0 304 39202.00 Contribution From Enterprises 0 0 0 0 0 304 39203.00 Transfer From 0 0 0 0 0 304 39204.00 Transfer From Water Core 0 0 0 0 0 304 39205.00 Transfer From Sewer Core 0 0 0 0 0 304 39206.00 Transfer From Storm Core 0 0 0 0 0 304 39207.00 Transfer From Port Authority 0 0 0 0 0 304 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS EXPENDITURES 2008 2009 2005 2006 2007 Adopted Proposed $101,389 $95,808 $100,046 $96,941 $93,713 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments Comments 304 47000 01 317.00 General Fund Admin Fees $0 $0 SO $0 $0 304 47000 01 319.00 Other Professional Services 0 0 0 0 0 304 47000 01 601.00 Bond Principal 65,000 70,000 65,000 70,000 75,000 304 47000 01 611.00 Bond Interest 26,130 23,845 21,381 18,800 15,800 304 47000 01 621.00 Bond Paying Agent Fees 374 403 603 400 400 304 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $91,504 $94,248 $86,984 $89,200 $91,200 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 338 G.O. IMPROVEMENT BONDS, 2002A REVENUES September 2, 2008 Account Description Actual Actual Actual Budget Budget 338 31010.00 Current Ad Valorem Taxes $0 $6,913 $10,772 $0 $0 338 36101.00 Principal Special Assessments 672,930 620,059 531,748 0 0 338 36102.00 Penalties Interest S/A 2,381 2,802 299 0 0 338 36210.00 Interest Eamings Investments 6,751 11,644 29,467 0 0 338 36215.00 Interest Eamings 53 42 35 0 0 338 36265.00 Use of Reserve Funds 0 0 0 625,600 59,100 338 37145.00 Surcharge on Water Revenues 0 0 0 0 0 338 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 338 39202.00 Contribution From Enterprises 0 0 0 0 0 338 39203.00 Transfer From 0 0 0 0 0 338 39204.00 Transfer From Water Core 0 0 0 0 0 338 39205.00 Transfer From Sewer Core 0 0 0 0 0 338 39206.00 Transfer From Storm Core 0 0 0 0 0 338 39208.00 Transfer From Street CIP 0 0 0 0 0 338 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $682,115 $641,460 $572,321 $625,600 $59,100 EXPENDITURES 2008 2009 2005 2006 2007 Adopted Proposed 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments Comments 338 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 338 47000 01 319.00 Other Professional Services 0 0 0 0 0 338 47000 01 601.00 Bond Principal 655,000 635,000 620,000 605,000 50,000 338 47000 01 611.00 Bond Interest 78,956 60,425 40,825 20,200 8,700 338 47000 01 621.00 Bond Paying Agent Fees 374 403 403 400 400 338 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $734,330 $695,828 $661,228 $625,600 $59,100 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 619 G.O. WATER STORM WATER REVENUE BONDS, 2002B REVENUES September 2, 2008 Account Description Actual Actual Actual Budget Budget 619 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 619 36101.00 Principal Special Assessments 7,858 608 1,294 0 0 619 36102.00 Penalties Interest S/A 15 0 11 0 0 619 36210.00 Interest Earnings Investments 725 1,523 2,511 0 0 619 36215.00 Interest Earnings 54 31 26 0 0 619 36265.00 Use of Reserve Funds 0 0 0 0 0 619 37145.00 Surcharge on Water Revenues 0 0 0 0 0 619 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 619 39202.00 Contribution From Enterprises 19,000 29,000 29,000 28,000 28,000 619 39203.00 Transfer From 0 0 0 0 0 619 39204.00 Transfer From Water Core 58,000 57,000 60,000 56,000 54,000 619 39205.00 Transfer From Sewer Core 0 0 0 0 0 619 39206.00 Transfer From Storm Core 19,000 29,000 29,000 28,000 28,000 619 39207.00 Transfer From Port Authority 0 0 0 0 0 619 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS $104,651 $117,163 $121,842 $112,000 $110,000 EXPENDITURES 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget 619 47000 01 317.00 General Fund Admin Fees 619 47000 01 319.00 Other Professional Services 2008 2009 2005 2006 2007 Adopted Proposed Comments Comments $0 $0 $0 so 0 0 0 0 0 0 619 47000 01 601.00 Bond Principal 50,000 70,000 70,000 70,000 70,000 619 47000 01 611.00 Bond Interest 44,233 42,183 40,018 38,700 36,300 619 47000 01 614.00 Amortization of Bond Discount 1,441 1,441 1,441 1,500 1,500 619 47000 01 621.00 Bond Paying Agent Fees 374 403 403 500 500 619 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $96,047 $114,026 $111,862 $110,700 $108,300 Page One September 2, 2008 Account 2009 BUDGET WORKSHEETS DEBT SERV FUND 339 G.O. IMPROVEMENT BONDS, 2003A REVENUES 339 31010.00 339 36101.00 339 36102.00 339 36210.00 339 36215.00 339 36265.00 339 37145.00 339 37160.00 339 39202.00 339 39203.00 339 39204.00 339 39205.00 339 39206.00 339 39208.00 339 39310.00 Account 339 47000 01 317.00 339 47000 01 319.00 339 47000 01 601.00 339 47000 01 611.00 339 47000 01 621.00 339 47000 01 710.00 Description Current Ad Valorem Taxes $0 $86,354 $86,354 $86,354 $86,354 Levy for St. Joe's Assumed S/A Principal Special Assessments 234,868 153,630 88,174 0 0 Penalties Interest S/A 518 3 358 0 0 Interest Eamings Investments 2,688 8,354 18,148 0 0 Interest Eamings 58 88 16 0 0 Use of Reserve Funds 0 0 0 63,046 52,646 Surcharge on Water Revenues 0 0 0 0 0 Penalties Surcharge Revenues 0 0 0 0 0 Contribution From Enterprises 44,000 44,000 44,000 42,000 42,000 Transfer From 0 81,165 0 0 0 Transfer From Water Core 0 0 0 0 0 Transfer From Sewer Core 0 0 0 0 0 Transfer From Storm Core 44,000 44,000 44,000 42,000 42,000 Transfer From Street CIP 0 0 0 0 0 Bond Proceeds 0 0 0 0 0 FUND TOTALS Description General Fund Admin Fees Other Professional Services Bond Principal Bond Interest Bond Paying Agent Fees Transfers EXPENDITURES 2008 2005 2006 2007 Adopted Actual Actual Actual Budget 2009 Proposed Budget $326,131 $417,594 $281,049 $233,400 $223,000 2008 2005 2006 2007 Adopted Actual Actual Actual Budget 2009 Proposed Budget Comments Comments 0 $0 $0 $0 $0 0 0 0 0 0 210,000 195,000 195,000 195,000 190,000 51,128 47,078 42,690 37,900 32,600 403 403 403 500 400 0 0 0 0 0 FUND TOTALS $261,530 $242,480 $238,093 $233,400 $223,000 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 613 G.O. WATER REVENUE BONDS, 2003B REVENUES- September 2, 2008 Account 613 31010.00 613 36101.00 613 36102.00 613 36210.00 613 36215.00 613 36265.00 613 37145.00 613 37160.00 613 39202.00 613 39203.00 613 39204.00 613 39205.00 613 39206.00 613 39207.00 613 39310.00 Account Description Current Ad Valorem Taxes $0 $0 $0 $0 $0 Principal Special Assessments 0 0 0 0 0 Penalties Interest S/A 0 0 0 0 0 Interest Eamings Investments 142 231 517 0 0 Interest Eamings 35 26 4 0 0 Use of Reserve Funds 0 0 0 0 0 Surcharge on Water Revenues 0 0 0 0 0 Penalties Surcharge Revenues 0 0 0 0 0 Contribution From Enterprises 0 0 0 0 0 Transfer From 0 0 0 0 0 Transfer From Water Core 134,000 132,000 140,000 136,000 138,000 Transfer From Sewer Core 0 0 0 0 0 Transfer From Storm Core 0 0 0 0 0 Transfer From Port Authority 0 0 0 0 0 Bond Proceeds 0 0 0 0 0 FUND TOTALS EXPENDITURES Description 613 47000 01 317.00 General Fund Admin Fees 613 47000 01 319.00 Other Professional Services 613 47000 01 601.00 Bond Principal 613 47000 01 611.00 Bond Interest 613 47000 01 614.00 Amortization of Bond Discount 613 47000 01 621.00 Bond Paying Agent Fees 613 47000 01 710.00 Transfers FUND TOTALS 2008 2005 2006 2007 Adopted Actual Actual Actual Budget 2009 Proposed Budget $134,176 $132,257 $140,521 $136,000 $138,000 2008 2009 2005 2006 2007 Adopted Proposed Actual Actual Actual Budget Budget $0 $0 $0 $0 $0 0 0 0 0 0 0 105,000 110,000 110,000 115,000 27,568 26,024 24,078 22,800 20,300 1,852 1,852 1,852 1,900 1,900 403 403 403 400 400 $29,822 $133,278 $136,332 $135,100 5137,600 Comments Comments Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 301 G.O. CAPITAL IMPROVEMENT PLAN (CIP) BONDS, 2005A REVENUES- September 2, 2008 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 301 31010.00 Current Ad Valorem Taxes $0 $208,978 $210,737 $212,313 $208,454 301 36101.00 Principal Special Assessments 0 0 0 0 0 301 36102.00 Penalties S Interest S/A 0 0 0 0 0 301 36210.00 Interest Earnings Investments 123 1,139 2,016 0 0 301 36215.00 Interest Earnings 28 11 21 0 0 301 36265.00 Use of Reserve Funds 0 0 0 0 0 301 37145.00 Surcharge on Water Revenues 0 0 0 0 0 301 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 301 39202.00 Contribution From Enterprises 0 0 0 0 0 301 39203.00 Transfer From 0 0 0 0 0 301 39204.00 Transfer From Water Core 0 0 0 0 0 301 39205.00 Transfer From Sewer Core 0 0 0 0 0 301 39206.00 Transfer From Storm Core 0 0 0 0 0 301 39207.00 Transfer From Port Authority 0 0 0 0 0 301 39310.00 Bond Proceeds 65,306 0 0 0 0 FUND TOTALS $65,457 $210,128 $212,774 $212,313 $208,454 EXPENDITURES 2008 2009 2005 2006 2007 Adopted Proposed Account* Description Actual Actual Actual Budget Budget Comments 301 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 301 47000 01 319.00 Other Professional Services 0 1,300 0 0 0 301 47000 01 601.00 Bond Principal 0 0 95,000 100,000 105,000 301 47000 01 611.00 Bond Interest 0 117,320 102,365 99,000 95,400 301 47000 01 621.00 Bond Paying Agent Fees 0 403 403 400 400 301 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $0 $119,022 $197,768 $199,400 $200,800 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 302 G.O. EQUIPMENT CERTIFICATES, 2005B REVENUES- September 2, 2008 Account 302 31010.00 302 36101.00 302 36102.00 302 36210.00 302 36215.00 302 36265.00 302 37145.00 302 37160.00 302 39202.00 302 39203.00 302 39204.00 302 39205.00 302 39206.00 302 39207.00 302 39310.00 Account 302 47000 01 317.00 302 47000 01 319.00 302 47000 01 601.00 302 47000 01 611.00 302 47000 01 621.00 302 47000 01 710.00 Description Current Ad Valorem Taxes $0 $347,219 $349,198 $345,395 $346,290 Principal Special Assessments 0 0 0 0 0 Penalties Interest S/A 0 0 0 0 0 Interest Eamings Investments 0 0 0 0 0 Interest Eamings 5 0 2 0 0 Use of Reserve Funds 0 0 0 0 0 Surcharge on Water Revenues 0 0 0 0 0 Penalties Surcharge Revenues 0 0 0 0 0 Contribution From Enterprises 0 0 0 0 0 Transfer From 0 0 0 0 0 Transfer From Water Core 0 0 0 0 0 Transfer From Sewer Core 0 0 0 0 0 Transfer From Storm Core 0 0 0 0 0 Transfer From Port Authority 0 0 0 0 0 Bond Proceeds 1,759 0 0 0 0 FUND TOTALS EXPENDITURES Description General Fund Admin Fees Other Professional Services Bond Principal Bond Interest Bond Paying Agent Fees Transfers FUND TOTALS 2008 2005 2006 2007 Adopted Actual Actual Actual Budget $1,764 $347,219 $349,200 $345,395 $346,290 2008 2005 2006 2007 Adopted Actual Actual Actual Budget 2009 Proposed Budget 2009 Proposed Budget $0 $0 50 $0 $0 0 0 0 0 0 O 290,000 300,000 305,000 315,000 20,566 40,685 32,570 24,000 14,800 O 403 403 400 400 Comments Comments O 0 0 0 0 $20,566 $331,088 $332,973 $329,400 $330,200 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 610 G.O. WATER REVENUE BONDS, 2005C REVENUES September 2, 2008 Account 610 31010.00 610 36101.00 610 36102.00 610 36210.00 610 36215.00 610 36265.00 610 37145.00 610 37160.00 610 39202.00 610 39203.00 610 39204.00 610 39205.00 610 39206.00 610 39207.00 610 39310.00 Account Description FUND TOTALS Description 610 47000 01 317.00 General Fund Admin Fees 610 47000 01 319.00 Other Professional Services 610 47000 01 601.00 Bond Principal 610 47000 01 611.00 Bond Interest 610 47000 01 614.00 Amortization of Bond Discount 610 47000 01 621.00 Bond Paying Agent Fees 610 47000 01 710.00 Transfers Current Ad Valorem Taxes $0 $0 $0 $0 $0 Principal Special Assessments 10,052 4,148 552 0 0 Penalties Interest S/A 606 0 0 0 0 Interest Eamings Investments 5,704 21,194 36,267 0 0 Interest Eamings 87 103 32 0 0 Use of Reserve Funds 0 0 0 0 0 Surcharge on Water Revenues 233,683 202,870 0 0 0 For 1/1/07 Used for WTP Penalties Surcharge Revenues 1,814 1,998 0 0 0 Contribution From Enterprises 0 0 0 0 0 Transfer From 0 0 0 0 0 Transfer From Water Core 0 0 340,000 364,000 364,000 Transfer From Sewer Core 0 0 0 0 0 Transfer From Storm Core 0 0 0 0 0 Transfer From Port Authority 0 0 0 0 0 Bond Proceeds 22,119 0 0 0 0 EXPENDITURES FUND TOTALS 2005 2006 Actual Actual 2008 2007 Adopted Actual Budget 2009 Proposed Budget $274,066 $230,313 $376,851 $364,000 $364,000 2008 2005 2006 2007 Adopted Actual Actual Actual Budget 2009 Proposed Budget $159,381 $110,714 $338,174 $364,000 $363,400 Comments Comments $0 $0 $0 $0 $0 O 0 0 0 0 140,000 0 235,000 270,000 275,000 2005 Final Pymt on '93C Issue 14,810 106,363 98,823 93,500 83,900 658 3,949 3,949 0 4,000 3,913 403 403 500 500 O 0 0 0 0 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 303 G.O. FIRE STATION REFUNDING BONDS, 2005D (Old 1996A) REVENUES September 2, 2008 EXPENDITURES 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget 303 31010.00 Current Ad Valorem Taxes $153,426 $154,308 $142,527 $144,417 $146,084 303 36101.00 Principal Special Assessments 0 0 0 0 0 303 36102.00 Penalties Interest S/A 0 0 0 0 0 303 36210.00 Interest Eamings Investments 1,832 12,939 7,809 0 0 303 36215.00 Interest Eamings 36 35 20 0 0 303 36265.00 Use of Reserve Funds 0 0 0 0 0 303 37145.00 Surcharge on Water Revenues 0 0 0 0 0 303 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 303 39202.00 Contribution From Enterprises 0 0 0 0 0 303 39203.00 Transfer From 0 0 0 0 0 303 39204.00 Transfer From Water Core 0 0 0 0 0 303 39205.00 Transfer From Sewer Core 0 0 0 0 0 303 39206.00 Transfer From Storm Core 0 0 0 0 0 303 39207.00 Transfer From Port Authority 0 0 0 0 0 303 39310.00 Bond Proceeds 1,109,248 0 0 0 0 FUND TOTALS $1,264,542 $167,282 $150,356 $144,417 $146,084 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments Comments 303 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 303 47000 01 319.00 Other Professional Services 4,999 0 0 0 0 303 47000 01 601.00 Bond Principal 75,000 1,165,000 85,000 100,000 105,000 1996A Called 2/1/06 303 47000 01 611.00 Bond Interest 68,033 61,873 37,079 34,200 30,900 303 47000 01 621.00 Bond Paying Agent Fees 13,553 861 403 400 400 303 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $161,584 $1,227,734 $122,481 $134,600 $136,300 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 321 G.O. EQUIPMENT CERTIFICATES, 2006A REVENUES September 2, 2008 Account Description 321 31010.00 Current Ad Valorem Taxes $0 $0 $87,955 $85,237 $87,767 321 36101.00 Principal Special Assessments 0 0 0 0 0 321 36102.00 Penalties Interest S/A 0 0 0 0 0 321 36210.00 Interest Eamings Investments 0 0 0 0 0 321 36215.00 Interest Eamings 0 25 13 0 0 321 36265.00 Use of Reserve Funds 0 0 0 0 0 321 37145.00 Surcharge on Water Revenues 0 0 0 0 0 321 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 321 39202.00 Contribution From Enterprises 0 0 0 0 0 321 39203.00 Transfer From 0 0 0 0 0 321 39204.00 Transfer From Water Core 0 0 0 0 0 321 39205.00 Transfer From Sewer Core 0 0 0 0 0 321 39206.00 Transfer From Storm Core 0 0 0 0 0 321 39207.00 Transfer From Port Authority 0 0 0 0 0 321 39310.00 Bond Proceeds 0 9,178 0 0 0 FUND TOTALS $0 $9,204 $87,968 $85,237 $87,767 EXPENDITURES 2008 2009 2005 2006 2007 Adopted Proposed Actual Actual Actual Budget Budget 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments Comments 321 47000 01 317.00 General Fund Admin Fees 80 $0 80 $0 $0 321 47000 01 319.00 Other Professional Services 0 0 0 0 0 321 47000 01 601.00 Bond Principal 0 0 0 70,000 70,000 321 47000 01 611.00 Bond Interest 0 0 16,062 11,400 9,900 321 47000 01 621.00 Bond Paying Agent Fees 0 0 431 400 500 321 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $0 $0 $16,493 $81,800 980,400 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 326 G.O. IMPROVEMENT BONDS, 2006B REVENUES September 2, 2008 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget 326 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 326 36101.00 Principal Special Assessments 0 4,000 584,237 0 0 326 36102.00 Penalties Interest S/A 0 0 0 0 0 326 36210.00 Interest Eamings Investments 0 0 8,497 0 0 326 36215.00 Interest Eamings 0 63 84 0 0 326 36265.00 Use of Reserve Funds 0 0 0 407,800 375,600 326 37145.00 Surcharge on Water Revenues 0 0 0 0 0 326 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 326 39202.00 Contribution From Enterprises 0 0 0 0 0 326 39203.00 Transfer From 0 0 0 0 0 326 39204.00 Transfer From Water Core 0 0 200,000 200,000 200,000 326 39205.00 Transfer From Sewer Core 0 0 0 0 0 326 39206.00 Transfer From Storm Core 0 0 0 0 0 326 39208.00 Transfer From Street CIP 0 0 0 0 0 326 39310.00 Bond Proceeds 0 117,467 0 0 0 FUND TOTALS EXPENDITURES $0 $121,530 $792,817 $607,800 $575,600 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments Comments 326 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 326 47000 01 319.00 Other Professional Services 0 0 0 0 0 326 47000 01 601.00 Bond Principal 0 0 0 440,000 425,000 326 47000 01 611.00 Bond Interest 0 0 205,567 167,400 150,100 326 47000 01 621.00 Bond Paying Agent Fees 0 0 431 400 500 326 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $0 $0 $205,998 $607,800 $575,600 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 611 G.O. WATER REVENUE BONDS, 2007A REVENUES- September 2, 2008 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget 611 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 611 36101.00 Principal Special Assessments 0 0 0 0 0 611 36102.00 Penalties Interest S/A 0 0 0 0 0 611 36210.00 Interest Eamings Investments 0 0 0 0 0 611 36215.00 Interest Eamings 0 0 2,033 0 0 611 36265.00 Use of Reserve Funds 0 0 0 0 0 611 37145.00 Surcharge on Water Revenues 0 0 0 0 0 611 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 611 39202.00 Contribution From Enterprises 0 0 0 0 0 611 39203.00 Transfer From 0 0 0 0 0 611 39204.00 Transfer From Water Core 0 0 0 40,000 133,000 611 39205.00 Transfer From Sewer Core 0 0 0 0 0 611 39206.00 Transfer From Storm Core 0 0 0 0 0 611 39207.00 Transfer From Port Authority 0 0 0 0 0 611 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS EXPENDITURES 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 611 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 $0 611 47000 01 319.00 Other Professional Services 0 0 0 0 0 611 47000 01 601.00 Bond Principal 0 0 0 0 85,000 611 47000 01 611.00 Bond Interest 0 0 11,535 38,500 46,700 611 47000 01 614.00 Amortization of Bond Discount 0 0 (536) 1,000 800 611 47000 01 621.00 Bond Paying Agent Fees 0 0 787 500 500 611 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $0 $0 $2,033 $40,000 $133,000 $0 $0 $11,786 $40,000 $133,000 Comments Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 322 G.O. EQUIPMENT CERTIFICATES, 2007B REVENUES- September 2, 2008 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget 322 31010.00 Current Ad Valorem Taxes $0 $0 $0 $105,431 $102,908 322 36101.00 Principal Special Assessments 0 0 0 0 0 322 36102.00 Penalties Interest S/A 0 0 0 0 0 322 36210.00 Interest Earnings Investments 0 0 0 0 0 322 36215.00 Interest Eamings 0 0 663 0 0 322 36265.00 Use of Reserve Funds 0 0 0 0 0 322 37145.00 Surcharge on Water Revenues 0 0 0 0 0 322 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 322 39202.00 Contribution From Enterprises 0 0 0 0 0 322 39203.00 Transfer From 0 0 0 0 0 322 39204.00 Transfer From Water Core 0 0 0 0 0 322 39205.00 Transfer From Sewer Core 0 0 0 0 0 322 39206.00 Transfer From Storm Core 0 0 0 0 0 322 39207.00 Transfer From Port Authority 0 0 0 0 0 322 39310.00 Bond Proceeds 0 0 6,300 0 0 FUND TOTALS EXPENDITURES $0 $0 $6,963 $105,431 $102,908 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments Comments 322 47000 01 317.00 General Fund Admin Fees $0 30 $0 30 30 322 47000 01 319.00 Other Professional Services 0 0 0 0 0 322 47000 01 601.00 Bond Principal 0 0 0 0 80,000 322 47000 01 611.00 Bond Interest 0 0 0 12,600 14,400 322 47000 01 621.00 Bond Paying Agent Fees 0 0 1,800 400 500 322 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS $0 $0 $1,800 $13,000 $94,900 Page One 2009 BUDGET WORKSHEETS DEBT SERV FUND 381 G.O. TAXABLE TIF 2008A G.O. TIF 2008B REVENUES September 2, 2008 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 381 31010.00 Current Ad Valorem Taxes $0 $0 $0 $0 381 31050.00 Tax Increments 0 0 0 0 277,700 381 36101.00 Principal Special Assessments 0 0 0 0 0 381 36102.00 Penalties Interest S/A 0 0 0 0 0 381 36210.00 Interest Earnings Investments 0 0 0 0 0 381 36215.00 Interest Earnings 0 0 0 0 0 381 36265.00 Use of Reserve Funds 0 0 0 0 0 381 37145.00 Surcharge on Water Revenues 0 0 0 0 0 381 37160.00 Penalties Surcharge Revenues 0 0 0 0 0 381 39202.00 Contribution From Enterprises 0 0 0 0 0 381 39203.00 Transfer From 0 0 0 0 0 381 39204.00 Transfer From Water Core 0 0 0 0 0 381 39205.00 Transfer From Sewer Core 0 0 0 0 0 381 39206.00 Transfer From Storm Core 0 0 0 0 0 381 39207.00 Transfer From Port Authority 0 0 0 0 0 381 39310.00 Bond Proceeds 0 0 0 0 0 FUND TOTALS EXPENDITURES- $0 $0 $0 $0 $277,700 2008 2009 2005 2006 2007 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 381 47000 01 317.00 General Fund Admin Fees $0 $0 $0 $0 381 47000 01 319.00 Other Professional Services 0 0 0 0 0 381 47000 01 601.00 Bond Principal 0 0 0 0 0 381 47000 01 611.00 Bond Interest 0 0 0 0 276,700 381 47000 01 621.00 Bond Paying Agent Fees 0 0 0 0 1,000 381 47000 01 710.00 Transfers 0 0 0 0 0 FUND TOTALS so $0 $0 $0 $277,700 Page One 2009 BUDGET WORKSHEET WATER UTILITY REVENUES July 7, 2008 2008 2009 Object 2009 2005 2006 2007 Adopted Deta0 Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 33425.00 Other State Grants Aids $0 $0 $0 $0 $0 601 34108.00 Administrative Fees -Other Funds 18,595 11,051 5,693 5,000 3,000 5% of 5% Fees -Const Projects 601 34109.00 Other Gen'I Govt Chgs for Services 0 0 0 0 0 601 36101.00 Principal Special Assessments 29,049 96,261 32,075 40,000 30,000 601 36102.00 Penalties Interest- S/A 1,330 1,966 2,409 0 0 601 36210.00 Interest Earnings Investments 86,611 101,383 129,301 90,000 100,000 601 36214.00 Net Change in FV- Investments (5,141) (2,305) 15,790 0 0 Annual Market Vale Changes 601 36215.00 Interest Earnings 291 386 216 200 200 601 36220.00 Rents Royalties 50,841 81,473 47,705 60,000 50,000 Antenna Leases 601 36260.00 Other Revenues 100 0 0 0 0 601 36265.00 Use of Reserve Funds 0 0 0 0 0 601 37110.00 Residential Water Revenues 722,666 857,057 902,174 750,000 825,000 601 37120.00 Apartment Water Revenues 58,756 92,229 68,187 60,000 65,000 601 37125.00 Institutional Water Revenues 33,635 29,207 33,006 30,000 30,E 601 37130.00 Commercial Water Revenues 50,509 58,007 63,450 50,000 60,000 601 37140.00 Industrial Water Revenues 41,678 31,011 30,214 30,000 30,E 601 37160.00 Penalties Water Revenues 7,652 10,971 9,080 6,000 7,000 601 37165.00 Meter Malnt 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 121,369 85,230 65,604 70,000 50,000 601 39103.00 Gain or Loss from F/A Disposal (6,898) 0 0 0 0 601 39203.00 Transfer From 109,536 0 0 0 0 FUND TOTALS $1,320,579 $1,453,927 $1,404,903 $1,191,200 Y ====s $1,250,200 Page One July 7, 2008 Account 601 49400 101.00 601 49400 77 101.00 601 49400 78 101.00 601 49400 79 101.00 601 49400 102.00 601 49400 103.00 601 49400 99 103.01 601 49400 99 103.02 2009 BUDGET WORKSHEET WATER UTILITY EXPENDITURES Description Salaries Benefits Administrative Technical/Clertcal Maintenance Full-Time Overtime Part -Time Salaries Benefits Utility Commission Wages (50 Maintenance Labor 89,591 108,348 122,362 12,674 10,253 601 49400 01 203.00 Printed Forms Paper 2,750 601 49400 01 209.00 Other Office Supplies 146 601 49400 01 216.00 Chemicals Chemical Products 37,013 601 49400 01 219.00 Other Operating Supplies 0 601 49400 01 220.00 Water Meter Purchases 601 49400 01 220.01 For Replacements 29,325 601 49400 01 220.02 For New Homes 79,457 601 49400 01 224.00 Street Maintenance Materials 141 601 49400 01 225.00 Landscaping Materials 0 601 49400 01 227.00 Utility System Maintenance Supplier 5,130 601 49400 01 228.00 Meter Repair Materials 17 601 49400 01 229.00 Other Maintenance Supplies 601 49400 01 229.01 Supplies for Hydrants 1,330 601 49400 01 229.02 Valve Curb Boxes 85 601 49400 01 229.03 Valve Replacements (2) 2,229 601 49400 01 229.04 Miscellaneous Supples 0 601 49400 01 241.00 Small Tools 1,381 601 49400 01 242.00 Minor Equipment 601 49400 01 242.01 Miscellaneous Purchases 2,478 601 49400 01 242.02 1,479 601 49400 01 303.00 601 49400 01 303.01 601 49400 01 303.02 601 49400 01 303.03 601 49400 01 303.04 601 49400 01 304.00 601 49400 01 310.00 601 49400 01 310.01 601 49400 01 310.02 601 49400 01 310.03 601 49400 01 312.00 601 49400 01 313.00 601 49400 01 313.01 601 49400 01 315.00 601 49400 01 315.01 601 49400 01 315.02 601 49400 01 315.03 601 49400 01 315.04 601 49400 01 318.00 601 49400 01 319.00 601 49400 01 319.01 601 49400 01 319.02 601 49400 01 319.03 601 49400 01 319.04 601 49400 01 319.05 601 49400 06 319.06 601 49400 01 321.00 601 49400 01 322.00 601 49400 01 323.00 601 49400 01 331.00 601 49400 01 333.00 601 49400 01 341.00 601 49400 01 349.00 Engineering Fees Water Conserv'n Emergency GIS Update of Asbui is Rate Study Miscelaneous Fees Legal Fees Testing Services Bacteria Water Quality V.O.C., Pesticides, etc. CU -PB Testing Gopher State One -Call Temporary Service Fees Temp Service Fees Special Programs Public Information Plan Amendments Seminars Vulnerability Assessment Imp. Contract Engineer Other Professional Services Thaw Pipes, Check Leaks, etc. Supervisory Controls Hazardous Chemical Permits Annual Drinking Water Report Hazardous Chemical Inventory Contracted Hydrant Painting Telephone Costs Postage Costs Radio Units Travel Expense Freight Express Expenses Employment Advertising Other Advertising PAGE TOTALS 2005 2006 Actual Actual 103,612 132,293 126,546 4,701 20,251 1,903 328 36,349 0 10,710 2,091 1,078 2,983 1,686 2008 2009 Object 2009 2007 Adopted Detal Proposed Actual Budget Amount Budget 108,458 143,055 125,239 10,405 28,523 1,988 142 43,422 0 1,355 138 0 1,941 963 106,000 151,800 135,200 10,000 9,000 2,500 200 55,000 200 109,500 164,400 140,700 7,960 7,693 0 0 77,055 80,268 130,000 130,000 1,905 2,811 2,000 2,000 Patching for Breaks 491 0 500 500 Topsol, Seed Sod 895 1,916 0 0 196 0 300 300 Miscellaneous Meter Parts 12,500 4,000 1,300 2,200 5,000 2,000 4,000 1,300 2,200 5,000 920 487 3,000 3,000 402 0 0 Comments All Salary Costs Inclusive of $414,600 Salary, Taxes, PERA Benefits 10,000 9,000 1,000 50% 601; 50% 602 8,000 100% 601 0 2,500 200 55,000 200 130,000 Inserts Water B7 Statements Disks, Ribbons, etc. Chlorine, Fkwride, Poiyphos Maintenance Supples Meters, MIU's CU Homs 2,000 Wrenches, Shovels, etc. 3,000 19,000 93,865 1,346 23,523 0 O 0 0 7,000 O 0 3,348 0 O 1,177 13,553 12,000 5,010 0 63 1,000 1,000 43,000 1,305 1,560 1,873 2,000 2,000 Radon,Tri -ChL 28,165 0 0 1,000 1,000 O 32,976 37,284 35,000 40,000 66.36/Connection Annual Fee (M) 4,779 3,985 3,269 7,000 7,000 Gopher State One -Cal (M) 20,033 0 0 0 0 7,000 0 12,000 21,065 4,085 1,021 0 0 11,500 2,356 0 0 5,500 5,500 Wellhead Protection Plan O 0 0 5,000 5,000 Wellhead Protection Plan O 0 0 1,000 1,000 Wellhead Protection Plan O 0 3,656 0 0 6,000 13,413 3,000 9,000 9,000 Contracted Engineer for CIty(20 15,100 2,088 12,549 6,022 1,500 1,500 3,500 343 0 3,000 3,000 O 0 0 500 500 MN Department of Public Safety 610 0 0 7,500 2,500 525 0 0 600 600 O 0 0 7,000 7,000 125 Hydrants per Year 975 1,181 1,529 1,500 2,000 Includes Wireless Technology 4,089 4,918 5,428 6,000 6,000 Minns wltt Inserts 563 873 1,422 1,000 1,000 Phones Moved to 321.00 O 10 0 1,000 1,000 AWWA National Seminar O 0 38 100 100 Mall-in Repairs O 0 0 700 700 Pfrers Personnel Changes O 0 0 500 500 701,119 612,768 663,831 736,600 758,700 Page Two July 7, 2008 Account it 601 49400 01 352.00 601 49400 01 365.00 601 49400 01 369.00 601 49400 01 391.00 601 49400 01 392.00 601 49400 01 393.00 601 49400 01 394.00 601 49400 01 395.00 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 2009 BUDGET WORKSHEET WATER UTILITY EXPENDITURES Description General Notices Public Info 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 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 Weil Inspections Recondition Miscellaneous Improvements CRP of Watermain Water Tower Inspection Furniture Fixture Purchases Office Equipment Purchases Computer Equipment Purchases Interest on Lease Payments Transfers 601- 49400-01 TOTALS 601 49403 01 221.00 Equipment Parts 601 49403 01 223.00 Building Repair Supplies 601 49403 01 319.00 Other Professional Services 601 49403 01 321.00 Telephone Costs 601 49403 01 381.00 Electric Utilities 601 49403 01 383.00 Gas UtBties 601 49403 01 409.00 Other Contracted Repairs Matti 601 49403 01 439.00 Other Miscellaneous Charges 601 49406 01 221.00 601 49406 01 223.00 601 49406 01 319.00 601 49406 01 321.00 601 49406 01 381.00 601 49406 01 383.00 TOTAL WELL #3 Equipment Parts Building Repair Suppers 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 2008 2009 Objed 2009 2005 2006 2007 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget O 0 0 500 500 Newsletters 4,633 5,153 5,514 4,500 4,500 Water's Share of Premiums 16,758 20,813 21,446 20,000 20,000 Waters Share of Premiums O 338 2,178 500 1,000 Auto Read Software Support O 248 0 200 200 0 3,423 101 4,000 4,000 Laptops 298 2,663 1,215 5,000 5,000 Cartegraph Malnt., GEOX Upgrade O 0 0 500 500 534 2,200 7,427 3,000 3,000 306 0 0 4,000 4,000 428 363 1,205 1,300 1,300 AWWA, Suburban Uti. Supt. Assn. O 0 0 300 300 Reference Materials 1,500 695 106 944 900 900 Water School, 50% Spfl w/ 602 (M) 405 573 0 600 600 9,962 13,024 13,023 15,000 15,000 DNR Annual Water Use (M) O 0 0 10,000 10,000 Pymt on P.W. Building (11 of 20) 188,000 O 13,932 23,939 20,000 25,000 Rural Wel S #11 Recondition 9,872 28 10,118 10,000 10,000 165,466 3,036 0 150,000 150,000 Annual Pavement Management 62,251 0 14,435 0 3,000 East Side Tower O 18,149 0 0 0 O 0 16,851 0 0 O 0 21,928 0 0 582 1,362 0 0 0 188 1,181 233 1,000 1,000 O 0 0 0 0 4,949 4,696 4,432 0 0 P.W. Building Expansion(See 521) 91,849 0 330,035 0 Comments O Transfers for Other Improvements 1,070,296 704,057 1,138,853 987,900 1,018,500 5,190 1,549 666 0 0 CapWel O 1,659 0 0 0 Cap Wel O 0 0 0 0 Cap Wei 211 18 18 0 0 Cap Weil 7,139 2,562 328 0 0 Cap Wel 913 839 939 2,000 2,000 Heat Engine Backup 2,050 0 0 0 0 O 0 0 100 100 Contingencies 15,503 6,627 1,950 2,100 2,100 311 185 0 500 500 O 0 0 500 500 O 0 0 1,000 1,000 O 0 0 0 0 1,801 1,246 1,164 1,000 1,000 Pumping Lighting O 0 0 0 0 Heat Only 2,112 1,431 1,164 3,000 3,000 1,092 3,608 1,515 1,200 1,200 O 0 0 0 7 5 0 50 0 500 Independent Inspections 211 211 211 0 0 20,307 18,100 18,242 18,000 18,000 Pumping Lighting O 0 0 0 0 O 0 0 600 600 RTU's, Pump Motor, etc. O 0 0 100 100 Contingencies O 0 0 0 0 21,610 21,918 27,518 20,700 20,700 Page Three July 7, 2008 Account# Description Actual Actual Actual Budget Amount Budget 601 49411 01 221.00 Equipment Paris 601 49411 01 381.00 Electric Utlkies 2009 BUDGET WORKSHEET WATER UTILITY EXPENDITURES 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed TOTAL WELL #10 10,241 15,868 44,656 13,000 13, TOTAL WELL #11 TOTAL WELL #15 O 0 0 1,900 32,200 Comments 601 49408 01 221.00 Equipment Parts 6,959 6,817 1,883 1500 1,50 601 49408 01 223.00 Building Repair Supplies 0 550 0 500 500 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 601 49408 01 321.00 Telephone Costs 211 18 0 0 0 601 49408 01 381.00 Electric Utilities 16,367 16,230 10,068 18,000 18,000 Pumping Lighting 601 49408 01 383.00 Gas Utilities 450 620 703 600 600 Heat Only TOTAL WELL #8 23,987 24,235 12,652 20,600 20.6 601 49409 01 221.00 Equipment Parts 2,929 4,296 1,765 1,500 1, 601 49409 01 223.00 Building Repair Supplies 0 0 0 100 1 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 601 49409 01 321.00 Telephone Costs 211 18 0 0 0 601 49409 01 381.00 Electric Utilities 28,475 33,779 30,690 35,000 35,000 Pumping Lighting 601 49409 01 383.00 Gas Utilities 1,042 647 1,007 1,500 1,500 Heat Only 601 49409 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL WELL #9 32,656 38,739 33,462 38,200 38 601 49410 01 219.00 Other Operating Supplies 0 0 0 500 500 601 49410 01 221.00 Equipment Parts 156 6,768 34,078 500 500 601 49410 01 223.00 Buiding Repair Supplies 0 0 0 100 1 601 49410 01 321.00 Telephone Costs 935 742 723 0 0 601 49410 01 381.00 Electric Utilities 7,961 8,358 9,855 9,000 9,000 Pumping Lighting 601 49410 01 409.00 Other Contracted Repairs Maint 1,189 0 0 2,900 2,90 O 6,045 46,727 0 0 O 0 0 0 0 Pumping Lighting O 6,045 46,727 0 0 601 49412 01 221.00 Equipment Parts 398 2,023 4,810 1,000 1,000 601 49412 01 223.00 Building Repair Supplies 0 41 0 500 500 601 49412 01 319.00 Other Professional Services 0 0 250 0 0 601 49412 01 321.00 Telephone Costs 0 0 0 0 0 601 49412 01 381.00 Electric Utilities 1,019 28,254 28,012 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 1,417 30,318 33,072 33,100 33,100 601 49414 01 221.00 Equipment Parts 0 0 285 500 500 601 49414 01 223.00 Building Repair Supplies 0 0 0 100 100 601 49414 01 319.00 Other Professional Services 0 0 495 1,000 1,000 601 49414 01 321.00 Telephone Costs 0 0 0 0 0 601 49414 01 381.00 Electric Utilities 0 1,415 26,704 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 TOTAL WELL #14 0 1,415 27,484 32,700 32,700 601 49425 01 221.00 Equipment Parts 0 0 0 100 500 601 49425 01 223.00 Building Repair Supplies 0 0 0 100 10 601 49425 01 319.00 Other Professional Services 0 0 0 100 500 601 49425 01 321.00 Telephone Costs 0 0 0 0 0 601 49425 01 381.00 Electric Utilities 0 0 0 1,000 30,000 Pumping Lighting 601 49425 01 383.00 Gas Utilities 0 0 0 500 1,000 Heat Only 601 49425 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies Page Four July 7, 2008 2009 BUDGET WORKSHEET WATER UTILITY EXPENDITURES Account# Description Actual Actual Actual Budget Amount Budget 601 49415 01 221.00 Equipment Parts 0 769 676 500 500 Touch -up Paint 601 49415 01 319.00 Other Professional Services 0 5,500 0 0 0 Tower Inspection 601 49415 01 381.00 Electric Utilities 0 0 0 0 0 601 49415 01 409.00 Other Contracted Repairs Maint 0 957 0 500 500 601 49415 01 439.00 Other Miscellaneous Charges 0 120 0 200 200 Contingencies TOTAL WATER TOWER #1 0 7,346 676 1,200 1,200 (Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 0 785 0 500 500 Touch-up Paint 601 49416 01 319.00 Other Professional Services 0 0 730 0 0 Tower Inspection 601 49416 01 321.00 Telephone Costs 211 18 0 0 0 601 49416 01 381.00 Electric Utilities 1,259 1,395 1,604 1,400 1,400 601 49416 01 409.00 Other Contracted Repairs Maint 0 0 2,542 500 500 601 49416 01 439.00 Other Miscellaneous Charges 0 0 56 200 200 Contingencies 601 49416 01 530.00 Improvements Other Than Bldgs 0 0 552,579 0 0 TOTAL WATER TOWER #2 1,470 2,196 557,511 2,600 2,600 (Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 0 0 8,970 500 500 601 49417 01 319.00 Other Professional Services 0 0 0 0 0 Tower Inspection 601 49417 01 321.00 Telephone Costs 0 0 0 0 0 601 49417 01 381.00 Electric Utilities 0 331 2,019 2,000 2,000 601 49417 01 409.00 Other Contracted Repairs Maint 0 0 0 500 500 601 49417 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 49417 01 530.00 Improvements Other Than Bldgs 0 0 0 300 300 Contingencies TOTAL WATER TOWER #4 0 331 10,989 3,500 3,500 (Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 0 979 0 500 500 601 49418 01 319.00 Other Professional Services 0 0 0 0 0 Tower Inspection 601 49418 01 321.00 Telephone Costs 1,874 132 0 0 0 601 49418 01 381.00 Electric Utilities 1,647 1,953 1,750 2,000 2,000 601 49418 01 409.00 Other Contracted Repairs Maint 3,200 0 0 500 500 601 49418 01 439.00 Other Miscellaneous Charges 75 0 0 200 200 Contingencies 601 49418 01 530.00 Improvements Other Than Bldgs 0 0 0 300 300 TOTAL WATER TOWER #3 (East Side Water Tower) GRAND TOTAL ALL DEPTS. 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed 6,796 3,064 1,750 3,500 3,500 $1,186,089 $863,591 $1,938,465 $1,164,000 $1,224,900 Comments Page One 2009 BUDGET WORKSHEETS SEWER UTILITY REVENUES- July 7, 2008 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget 602 33425.00 Other State Grants Aids $0 $0 $2,500 $0 602 34108.00 Administrative Fees -Other Funds 18,595 11,051 5,693 5,000 3,000 5% of 5% Fees -Const Projects 602 36101.00 Principal Special Assessments 44,888 54,093 57,251 50,000 50,000 602 36102.00 Penalties Interest S/A 2,077 3,021 2,318 0 0 602 36210.00 Interest Eamings Investments 98,577 106,066 102,710 90,000 90,000 602 36214.00 Net Change in FV- Investments (18,832) (5,812) 35,821 0 0 Annual Market Value Changes 602 36215.00 Interest Eamings 273 297 288 400 400 602 36260.00 Other Revenues 0 0 0 0 0 602 36265.00 Use of Reserve Funds 0 0 0 74,700 95,000 602 37210.00 Residential Sewer Revenues 1,011,697 1,134,471 1,169,455 1,100,000 1,100,000 602 37220.00 Apartment Sewer Revenues 53,042 63,806 81,053 60,000 70,000 602 37225.00 Institutional Sewer Revenues 27,870 22,879 22,291 30,000 25,000 602 37230.00 Commercial Sewer Revenues 52,136 54,448 55,087 55,000 55,000 602 37240.00 Industrial Sewer Revenues 4,966 5,434 4,143 6,000 4,000 602 37260.00 Penalties Sewer Revenues 9,829 14,941 11,288 9,000 10,000 602 39103.00 Gain or Loss from F/A Disposal (32,940) 0 0 0 0 602 39203.00 Transfer From 17,355 0 0 0 0 FUND TOTALS $1,289,532 $1,464,696 $1,549,898 $1,480,100 $1,502,400 Comments Page One July 7, 2008 Account 602 49450 101.00 602 49450 77 101.00 602 49450 78 101.00 602 49450 79 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 313.01 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 2009 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES Description Salaries Benefits Administrative Technical/Clerical Maintenance Full-The Overtime Part-Tine 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 Supplies Smat Tools Minor Equipment Engineering Fees GIS Update of Asbuilts Rate Study 42/52 Sewer Study Miscellaneous Legal Fees Gopher State One -Cap Temporary Service Fees Temp Service Fees Contract Engineer Other Professional Services Televising Root Control Supervisory Controis(Maiint 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 Impr 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 602 49450 01 602.00 Sewer Service Charges 602 49450 01 611.00 Interest on Lease Payments 602 49450 01 710.00 Transfers 602- 49450-01 TOTALS 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $414,600 Salary, Taxes, PERA Benefits 89,591 103,611 108,457 106,000 109,500 108,348 132,293 143,055 151,800 164,400 122,362 126,545 125,239 135,200 140,700 12,674 4,701 10,405 10,000 10,000 9,289 24,842 20,410 9,000 9,000 1,000 50% 602; 50% 601 8,000 100% 602 2,100 779 1,729 1,500 1,500 Inserts Water BB Statements O 0 0 200 200 Disks, Ribbons, etc. O 0 0 500 500 Root Killer, Degreaser 8 112 0 200 200 O 116 2,160 2,500 2,500 Patching O 685 19 400 400 Topsoll, Seed Sod 316 1,541 560 3,000 3,000 Manhole Castings 156 179 843 500 500 Wrenches, Shovels, etc. 646 2,428 6,697 3,000 3,000 12,000 O 0 1,674 7,000 7,000 10,064 17,983 15,158 0 0 O 0 10,319 0 0 O 0 0 5,000 5,000 156 85 0 500 500 4,769 3,985 3,269 7,000 7,000 Gopher State One -Call (M) 20,033 0 21,065 4,085 1,021 0 0 6,000 9,000 3,000 9,000 9,000 Contracted Engineer forCity(20 8,000 O 0 0 3,000 3,000 3,506 0 0 2,000 2,000 1,404 196 532 3,000 3,000 610 0 0 0 0 494 1,181 1,530 1,500 1,500 3,230 3,684 3,673 3,500 3,500 552 846 1,422 500 500 O 0 0 200 200 O 0 0 100 100 O 0 0 300 300 O 0 0 500 500 4,619 5,138 5,499 5,000 5,000 9,342 11,899 11,319 15,000 15,000 O 337 2,026 300 1,000 O 0 0 200 200 O 3,423 0 4,000 4,000 298 2,663 1,215 5,000 5,000 O 0 0 500 500 176 2,200 3,713 2,000 2,000 O 0 0 200 200 O 0 0 2,000 2,000 O 23 96 100 100 O 0 0 300 300 1,300 23 833 1,000 1,000 122 115 145 100 100 597,249 672,585 721,350 775,000 4,949 4,697 4,432 0 185,980 162,061 252,815 0 1,432,730 1,313,336 1,530,162 1,448,600 1,470,900 SCADA System Includes Wireless Technology Billings with Inserts Phones Moved to 321.00 Use 437.00 Mat-in Repass Pliers Personnel Changes Sewer's Share of Premiums Sewer's Share of Premiums Auto Read Software Support CarteGraph Maid., GEOX Upgrade Suburban UN. Supt Ass'n(50 Reference Materials Sewer School, 50% Spilt with 601 Contingencies O 0 0 10,000 10,000 Pymt on P.W. Building (11 of 20) 160,000 O 0 5,059 10,000 10,000 O 4,538 0 0 0 108,590 2,277 0 150,000 150,000 Annual Pavement Management 62,251 0 14,435 0 0 O 4,851 0 0 0 O 0 7,273 0 0 O 0 16,851 0 0 O 0 21,928 0 0 40,193 (2,869) 0 0 0 287 0 0 500 500 O 500 0 500 500 775,000 MWCC Charges O P.W. Building Expansion(See 521) O Transfers for Other Improvements Page Two 2009 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES July 7, 2006 2008 2009 Object 2009 2005 2006 2007 Adopted Detali Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 49451 01 219.00 Other Operating Supplies 0 358 0 100 100 602 49451 01 221.00 Equipment Parts 2,764 726 0 800 800 602 49451 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49451 01 321.00 Telephone Costs 211 18 0 0 0 602 49451 01 381.00 Electric Utilities 565 786 1,038 800 800 602 49451 01 403.00 Contracted R M Other Impr 0 0 0 200 200 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (City Hap) TOTAL LIFT STATION #1 3,540 1,888 1,038 2,200 2,200 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 10 602 49452 01 221.00 Equipment Parts 0 1,104 1,732 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 377 438 456 800 800 602 49452 01 403.00 Contracted R M Other Impr 0 0 0 200 200 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Bloomfield 5th) TOTAL LIFT STATION #7 588 1,753 2,399 2,200 2.2 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49453 01 221.00 Equipment Parts 3,979 5,940 240 800 800 602 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49453 01 321.00 Telephone Costs 211 18 0 0 0 602 49453 01 381.00 Electric Utilities 2,904 3,495 2,804 5,000 5,000 602 49453 01 403.00 Contracted R M Other Impr 0 0 0 200 20 602 49453 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Shannon Pond) TOTAL LIFT STATION #3 7,095 9,453 3,044 6,400 6,400 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49454 01 221.00 Equipment Parts 7,925 293 0 800 800 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49454 01 321.00 Telephone Costs 211 18 0 0 0 602 49454 01 381.00 Electric Utilities 3,612 2,542 3,403 5,000 5, 602 49454 01 403.00 Contracted R M Other Impr 0 0 0 200 200 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Country Hills) TOTAL LIFT STATION #4 11,748 2,852 3,403 6,400 6,400 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49455 01 221.00 Equipment Parts 230 2,053 15,746 800 600 602 49455 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49455 01 321.00 Telephone Costs 211 18 0 0 0 602 49455 01 361.00 Electric Utilities 3,785 4,024 4,593 5,000 5,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 4,226 6,095 20,338 6,400 6,400 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49456 01 221.00 Equipment Parts 700 6,379 0 800 800 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49456 01 321.00 Telephone Costs 169 14 0 0 0 602 49456 01 381.00 Electric Utilities 709 540 1,487 800 800 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 (Drumcl ffe) TOTAL LIFT STATION #6 1,578 6,934 1,487 2,200 2,200 Page Three July 7, 2008 2009 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES Account# Description Actual Actual Actual Budget Amount Budget 602 49457 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49457 01 221.00 Equipment Parts 0 175 922 500 50 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 0 272 354 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 0 447 1,276 1,900 1,900 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49458 01 221.00 Equipment Parts 0 939 356 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 0 285 362 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 0 1,224 718 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 0 1,062 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 0 160 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 0 1,222 1,900 1,900 GRAND TOTAL ALL DEPTS. 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed $1.461,504 $1,343,983 $1,565,087 $1,480,100 $1,502,400 Comments Page One July 7, 2008 2009 BUDGET WORKSHEETS STORM WATER UTILITY REVENUES- 2008 2009 Object 2009 2005 2006 2007 Adopted Detak Proposed Account# Description Actual Actual Actual Budget Amount Budget 603 33425.00 Other State Grants Aids $0 $0 $2,500 $0 $0 603 34108.00 Administrative Fees -Other Funds 18,595 11,051 5,693 5,000 3,000 5% of 5% Fees -Const Projects 603 36101.00 Principal Special Assessments 8,111 15,777 12,617 10,000 10,000 603 36102.00 Penalties Interest S/A (115) 722 386 0 0 603 36210.00 Interest Earnings Investments 57,468 58,397 62,368 60,000 60,000 603 36214.00 Net Change in FV- Investments (6,472) (252) 9,008 0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 183 344 303 300 300 603 36260.00 Other Revenues 0 0 0 0 0 603 36265.00 Use of Reserve Funds 0 0 0 38,800 0 603 37300.00 Storm Water Utility Revenues 624,529 665,905 731,323 700,000 700,000 603 37360.00 Penalties Storm Water Utility 2,959 6,157 4,027 4,000 4,000 603 39203.00 Transfer From 47,845 0 0 0 0 FUND TOTALS $753,103 $758,101 $828,226 $818,100 $777,300 .ax.a:new s==== Comments Page One July 7, 2008 Account 2009 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES Description 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 102.00 Full -Tine Overtime 603 49500 99 103.00 Part-Time Salaries Benefits 603 49500 01 203.00 Printed Forms Paper 603 49500 01 204.00 Envelopes Letterhead 603 49500 01 205.00 Drafting Supplies 603 49500 01 208.00 Miscellaneous Supplies 603 49500 01 215.00 Shop Materials 603 49500 01 219.00 Other Operating Supplies 603 49500 01 221.00 Equipment Parts 603 49500 01 224.00 Street Maintenance Materials 603 49500 01 225.00 Landscaping Materials 603 49500 01 225.01 Rip -Rap, Matting, Rock, etc. 603 49500 01 225.02 Black Dirt, Seet, Sod, etc. 603 49500 01 225.03 226.00 Sign Repair Materials 230.00 Equipment Repair Material 241.00 Small Tools 242.00 Minor Equipment 603 49500 01 603 49500 01 603 49500 01 603 49500 01 603 49500 01 303.00 603 49500 01 303.01 603 49500 01 303.02 803 49500 01 303.03 803 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 313.01 603 49500 01 315.00 603 49500 01 318.00 603 49500 01 319.00 803 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 Engineering Fees Problem Area Investigations NPDES Phase II CSMP Update Miscellaneous Legal Fees Testing Services Contract Inspectinn Fees Temporary Service Fees Temporary Service Fees Special Programs (County Program) Contract Engineer Other Professional Services Postage Costs Radio Units Travel Expense General Notices Public Info Workers Comp Insurance Other Insurance Refuse Disposal Other UtBty Services P.C. Maintenance P.C. Hardware Purchases P.C. Software Purchases 603 49500 01 403.00 Contracted R M Other Impr 603 49500 01 403.01 Dkching 603 49500 01 403.02 Miscellaneous Repairs 603 49500 01 404.00 Contracted Mach Equip Repairs 603 49500 01 416.00 Machinery Rental 803 49500 01 433.00 Dues Subscriptions 603 49500 01 435.00 Books Pamphlets 603 49500 01 437.00 Conferences Seminars 603 49500 01 437.01 Storm Water Management 603 49500 01 437.02 Hydrocad Training 603 49500 01 437.03 Wetlands Training 603 49500 01 439.00 Other Miscellaneous Charges 603 49500 01 530.00 Improvements Other Than Bldgs 603 49500 01 530.01 CRP of Storm Sewer 603 49500 01 530.02 603 49500 01 530.03 603 49500 01 530.04 603 49500 01 540.00 Heavy Machinery Purchases 603 49500 01 560.00 Furniture Fixture Purchases 603 49500 01 580.00 Other Equipment Purchases 603 49500 01 586.00 Computer Equipment Purchases PAGE TOTALS 2005 Actual 2008 2009 Object 2009 2006 2007 Adopted Detail Proposed Actual Actual Budget Amount Budget All Salary Costs Inclusive of $167,700 Salary, Taxes, PERA Benefits O 0 0 0 0 60,657 77,793 85,070 88,200 97,300 70,574 63,273 62,620 67,600 70,400 6,838 2,526 5,372 10,000 10,000 O 0 0 8,000 8,000 749 779 1,729 1,500 1,500 O 0 0 0 0 O 0 0 0 0 0 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 191 536 2,292 2,000 2,000 Blacktop Gravel Washouts 4,000 191 0 2,174 3,000 3,000 332 0 11 1,000 1,000 O 0 0 0 0 O 0 0 500 500 666 134 236 1,000 1,000 156 581 152 1,000 1,000 O 0 0 0 0 70,000 42,415 31,486 96,644 10,000 10,000 2,625 27,441 55,281 30,000 30,000 O 0 63,466 0 0 O 0 459 30,000 30,000 271 0 6,094 2,000 O 0 0 1,000 O 0 0 500 0 14,043 2,723 681 0 3,850 3,850 3,850 5,000 5,000 6,000 9,000 3,000 9,000 9,000 O 844 0 0 3,000 3,230 3,684 3,673 3,000 3,000 403 503 339 600 600 O 0 0 200 200 O 0 0 1,000 1,000 1,813 2,019 2,162 3,500 3,500 5,077 6,349 6,029 6,000 6,000 0 0 0 600 600 0 0 0 500 500 O 337 2,026 300 1,000 O 3,423 0 4,000 4,000 298 2,663 1,215 5,000 5,000 412,952 301,283 596,004 513,600 529,200 Comments 2,000 1,000 Water Quality Tests (M) 500 3rd Part Inspection Program (M) 0 Wetland Health Evaluation Pro' Contracted Engineer for City(20 SCADA Bilirrgs Info Malings Replacements Repairs Pubic Info Brochure Storm Water's Share of Premiums Storm Water's Share of Premiums Roadside Debris Hazardous Materials Disposal Auto Read Software Support CarteGraph Maint, GEOX Upgrade 55,000 O 0 0 5,000 5,000 O 36,496 151,306 50,000 50,000 Storm Maintenance Work O 0 0 1,000 1,000 Repairs Sent Out O 0 401 5,000 5,000 Backhoe, Lowboy, Pumps, etc. 101 976 976 0 0 O 13 0 500 500 Utility Information 1,500 240 25 42 1,000 1,000 MN Cities Stormwater Collaboration O 0 0 0 0 O 0 0 500 500 122 115 145 0 0 151,919 2,277 150,000 O 0 0 150,000 150,000 Annual Pavement Management O 0 7,273 0 0 O 0 14,435 0 0 O 0 16,851 0 0 40,193 21,438 0 0 0 O 0 0 500 500 O 0 0 2,000 2,000 O 0 0 500 500 Page Two July 7, 2008 Account 603 49500 01 710.00 Transfers 603 49500 01 710.01 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 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 603 49511 01 221.00 603 49511 01 321.00 603 49511 01 381.00 (Copper Pond) 603 49512 01 221.00 603 49512 01 321.00 603 49512 01 381.00 (Schwarz Pond) 603 49513 01 221.00 603 49513 01 321.00 603 49513 01 381.00 (Binger Pond) 603 49514 01 221.00 603 49514 01 321.00 603 49514 01 381.00 (Marcotte Pond) 603 49515 01 221.00 603 49515 01 321.00 603 49515 01 381.00 (Hawkins Pond) 603 49516 01 221.00 603 49516 01 321.00 603 49516 01 381.00 (Glendalough 7th) 2009 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES Description 603 49500 -01 TOTALS Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #1 Equipment Parts Telephone Costs Electric Utilit TOTAL LIFT STATION #2 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #3 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #4 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #5 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #6 GRAND TOTAL ALL DEPTS. 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget 50,000 50,000 52,000 52,000 0 42,000 41,000 43,000 41,000 0 53,000 54,000 53,000 54,000 53,000 75,000 77,000 75,000 74,000 0 19,000 29,000 29,000 28,000 28,000 26,000 26,000 25,000 0 0 44,000 44,000 44,000 42,000 42,000 80,797 200,811 186,144 0 0 123,000 Comments Bonds Called 2/1/08 Bonds Called 2/1/08 Bonds Paid off 2/1/08 Storm Share of Water /Storm Issue Bonds Defeased 3/1/07 Storm Share of Connemara Proj. 802,749 823,094 1,103,148 804,600 652,200 O 185 0 500 500 211 18 0 0 0 210 193 224 500 500 421 395 224 1,000 1,000 O 360 0 500 500 211 18 0 0 0 O 0 0 500 500 211 378 0 1,000 1,000 350 418 1,362 500 500 422 35 0 0 0 5,151 2,211 2,968 5,000 5,000 5,922 2,664 4,329 5,500 5,500 O 185 0 500 500 42 4 0 0 0 177 135 372 3,500 3,500 220 324 372 4,000 4,000 O 98 0 500 500 O 0 0 0 0 O 0 0 500 500 O 98 0 1,000 1,000 O 22 0 500 500 O 0 0 0 0 O 0 245 500 500 O 22 245 1,000 1,000 $809,523 $826,974 $1,108,318 $818,100 $665,700 Page One August 13, 2008 2009 BUDGET WORKSHEETS ARENA REVENUES 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 650 36210.00 Interest Eamings Investments $243 $0 $0 $0 $0 650 36215.00 Interest Eamings 76 3 0 100 100 650 36260.00 Other Revenue Leam to Skate 33,440 38,823 32,075 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 211,297 207,851 216,710 210,000 220,000 650 38061.00 Non -Prime Time Ice Fees 45,571 69,733 76,677 65,000 75,000 650 38063.00 Open Skating Ice Fees 8,973 9,599 9,864 9,000 9,000 650 38064.00 Broomball Revenues 0 0 5,761 6,000 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 11,650 4,820 13,500 10,000 10,000 650 38067.00 Skate Sharpening Revenue Arena 4,817 5,196 5,472 5,000 5,500 650 38090.00 Concessions 3,900 3,900 3,900 3,900 3,900 650 38091.00 Vending Machine Revenues 10,425 10,702 8,367 12,000 10,000 650 38095.00 Pro Shop Revenues 1,133 1,184 1,178 1,000 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 0 100,000 165,000 115,000 Subsidy for Operations FUND TOTALS 331,524 351,811 473,504 522,000 484,700 Comments Page One August 13, 2008 2009 BUDGET WORKSHEETS ARENA EXPENDITURES 2008 2009 Object 2009 2005 2006 2007 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget All Salary Costs Inclusive of 650 45130 101.00 Salaries Benefits $132,800 Salary, Taxes, PERA Benefits 650 45130 77 101.00 Administrative 12,281 36,329 34,081 35,300 36,900 650 45130 78 101.00 Technical/Clerical 44,193 26,193 26,936 28,300 34,400 650 45130 79 101.00 Maintenance 87,352 91,489 96,916 101,700 61,500 650 45130 79 102.00 Full-Time Overtime 4,642 5,393 5,180 4,700 4,700 650 45130 103.00 Part-Time Salaries Benefits 42,000 650 45130 89 103.00 Leam-To-Skate Program 25,290 27,785 27,100 27,000 27,000 650 45130 99 103.00 Building Skate Guard Attendant: 15,245 18,386 15,392 15,000 15,000 650 45130 01 207.00 Training Instructional Supplies 0 0 0 200 200 650 45130 01 208.00 Miscellaneous Supplies 1,000 650 45130 01 208.01 Skate Magnets 234 0 0 200 200 650 45130 01 208.02 Other Supplies 0 51 0 800 800 650 45130 01 209.00 Other Office Supplies 110 407 575 500 500 Leam to Skate Program Supplies 650 45130 01 211.00 Cleaning Supplies 3,139 3,605 3,302 4,000 4,000 650 45130 01 212.00 Motor Fuels 2,323 2,400 0 2,400 2,400 Battery for Maintenance 650 45130 01 216.00 Chemicals Chemical Products 2,483 3,200 2,814 3,200 3,200 Assorted Products 650 45130 01 219.00 Other Operating Supplies 29 269 434 1,000 1,000 Events Supplies 650 45130 01 221.00 Equipment Parts 1,600 2,983 2,605 4,000 4,000 650 45130 01 223.00 Building Repair Supplies 535 2,544 1,444 4,000 4,000 650 45130 01 241.00 Small Tools 0 0 0 0 0 650 45130 01 242.00 Minor Equipment 0 0 0 0 0 650 45130 01 265.00 Other Items for Resale 662 544 515 800 600 Pro Shop Supplies 650 45130 01 305.00 Medical Dental Fees 0 0 0 500 500 650 45130 01 311.00 Officiating Fees 0 0 2,075 2,400 2,400 Broomball Leagues Referees 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 500 650 45130 01 349.00 Other Advertising 93 98 210 800 800 650 45130 01 365.00 Workers Comp Insurance 2,091 2,488 2,691 2,500 2,500 650 45130 01 369.00 Other Insurance 6,552 7,789 7,746 13,000 8,000 650 45130 01 381.00 Electric Utilities 101,374 109,878 114,332 101,000 115,000 650 45130 01 383.00 Gas Utilities 34,957 31,488 34,232 33,000 50,000 650 45130 01 384.00 Refuse Disposal 2,881 2,962 3,455 3,500 3,500 650 45130 01 401.00 Contracted Building Repairs 6,212 4,359 13,014 5,000 5,000 650 45130 01 404.00 Contracted Mach Equip Repairs 26,933 15,482 11,028 15,000 15,000 650 45130 01 415.00 Other Equipment Rental 0 0 0 300 300 650 45130 01 433.00 Dues Subscriptions 592 450 475 900 900 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 500 Contingencies 650 45130 01 521.00 Building Structure Purchases 650 45130 01 580.00 Other Equipment Purchases FUND TOTALS Comments O 0 0 90,000 0 O 0 0 9,000 0 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 7,800 0 0 0 0 650 45130 01 710.03 3,200 0 0 0 0 403,301 407,071 417,050 522,000 416,300 1 11111 1 I O O O In O co O CD CO O O O O O 0 CO 000000 N 1-00 0000 C 0 1: N 0 0 0 0 0 or) 00 0(0 (0 O O O O O N O CD OD C) 0 O O 0 N r 0 O CL) f` N O M co OO 0 0 c c c c c c C C o o 0 0 0 0 c m m 0 0 0 0 0 o 00000 iiu. c (0 0 0 eeee N mm a f )a 1 E ayi c LL N N y y G a) a) m d a) 8888 o2 •c r r 00 Ea a) .5 C 9 w a) 0 0) CO a) C lU N E E E E a c a W W W W N OO OD 1s 0 0 a LL O 0 0 0 a U U NNNNCAJaa NMct 14)0 n 00 0) 0) 0) 0 0) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N 0 0 O O 8 CO u. 0 O 0 N 0 00000 M O 00 CO 00 0 0 0 0 0 0 0) 0 0 0 0) 0 0 0 0 0 0 0 0 1 0 0 0 O O C O cq 'V'' C CD O V 0 0h- CO O CO N N 0) 0 co O O O 88 0 0 O O 0 0 0 0 0 0 O O N O O 8 8 N N 0 0 y 0 0 0 0 0 0 N@ C0 0 0 0 0 0 7 7 7 7 7 0 O.a0. a aaaaaaaa N 0 D 05 S O U m d o ut o v -5 E(Nn T, w C O O ot1 a) 5 U Q Y S U c 4 m CO N 7 O a CO 6 E C T CL 'S N ro Y O- y E O (0 c 2 L U a a) a 4 U E•� .v�0 co o d co f0 7 0. l N O m C fO Tr ess 0 C O E 7 a (n N U a Q l0 0_ C co O 8 co c O 7 J 'O U C E CD C in O C (0 'O a) W O a) W U o 5 E C •5 a)U p D p a d U X 2 Z W W CI a d d U 5. 0 a N M'V O (00- 0000 a- CV N N N 0) 0 0 0 0 0) 0) 0 0) 0 0 11 0) 0 0 0 0 0 0 0 0 0 0 p 0 0 0 0 0 0 0 0 0 0 0 0 O N N N N N N N N N N N N O N O O O O N O a 7 M N O N Ul OD (4) C C`7 CD 0) O O r- 73 0 O co O O 0 O O O co O 8 O O N 0 0 co O o co O N V O 0 mm 00 0 O O O O O O 0 in°°NN N N 0I d'Q' y y as as oa oa U O Epoop a) co <00000U. U' a. Y �d a ca CO CV C CD CD 0 ma E w O n tit) of) vii) E3a w 8 e CO CO CO ca 0 v m O 8888 n Is Hof0 tt. F. F. cG Ewa) O c c p 0 c c 0 N yy a 4 d §8888 c L•6 (v d j w 0 eccc"E4°at c f0 8 c a c )p E EEE co 000 0. 0, 0. CO 0 o O L O N Q V 0.7.5.5.7 aa) CO 178 c W c a X 0000 a a)) co a 3 c na a) U c4 NNNN IO 2CLZI Q c0D W O NM V t0 m f, m O 0•- N M tO m 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N N N N N N N N 0 0) 0 M 0 t0 c 0 0 O O N co m 0) P- 0 t0 O 0 0 0 O 0) 0) 0 O O t0 O O O O t0 0 0 0 O N O co O t0 O O O O O t0 O O O to O O O co O O O O O O O t0 N O O O N U) M M 0 t0 0 N 0) CD C.- N O O O 0) M M CO N m 0 O N a 0 0 0 n N co M m N N 1) O co m 0 0 0 O O O 8 O O 8 N •L 3 a a' 0) O O O O O N O O O O O N O O O 8 0 O O O O O O 0 8 r E a co co a) a c N 2 m a N O O O M 8 O co N O O O O 8 O V cn O 3 a a' M co O a c co ce 8 0. E O. U a c N N 0 0 0 O N N 0 O O O tf) N 8 p O N N Y a 0 2 N 0 U m N 0 O O O O r N O 8 3 m LL a) E 0 to N N 0 0 0 0 0 0 0 0 00000000 N N N N N N N N 0 m 0. Ct 0. C a a F 0 0 0 O 0) N 8 O O O O O O O N f0 O 0) O 0 O O O 0 0 O 0 co 0 2 E 0 0 a 0 O O c 3 N N O 0 0 N O 0 O rs 3 0 0 0 O 0) O O O 0) 8 U a co 8 0 0 O O O O O 8 N LL c E 8 a 0) c a a O 0 O O O co 8 N LL 0 0 N O (0 a) a 0 0 0 a O 0 O O LO 8 0 f0 0 0 0 0 n 0 O N 0 0 O 0 O N 2 LL c O 2 a) c F 03 0 O O O CD 0 0 0 O O O O 8 O O 0) c O w 0) LL a) Z 0) 0 LO O 8 LO 0 0)) 0 0 c :00 U O O 0 n 8 O to c co a 0 W a 0 co co m 0 O O N 8 O O N 06 a N 0 E co a CO O m 0 8 N O O O O O 8 O O O O 0 0({ a 0 O O O O 8 a 0 c E a W co 0 O O 0 To v, c v c m a 0 N 0 co O O 8 a O O O no 8 a0 8 a O 0 O O LO 8 O N 0 8 a) 2 0 0 O N O O O O O O O 8 a a0 03 O N O O 8 a O 0 O N O O N 8 00 m 2 a 0 D a as v 8 O N 0 O N 0 O O O O cst M O O O O O N O O O O O 0 O 8 O O O O O 8 a N N 0 O O O O CO m O O O CO O O co O O a c 0 2 (0 0 U (6) 3 0 CC N O co v N A c 3 M N 0 O O O O O 0 a a' Tr N 0 O O O N 8 O (4) N 8 0) a a O N O O 42 a a N O 0 U co a 0) 0 v n O E 4- O N 0 O M M O O M 0 a a M 0 f0 a 0 a 1 7 n N 0 O M M M U m N M co a 0 a 0 U a 1- 0) N 0 O M O O M co a M co a) U 0 0 K m 0) a 0 U a CO N 8 M M 0 3 a a M 8 a y a T- o F 0 M 0 O O M O O M a M Nr- W 8 a re 2 0 M 0 O O 0 M 0 0 N co a 2 co 0 N M 0000000000000000000000000000000 N 42 a O O M co 0 a a' 8 O 0 CO N O O O O O O O 0 O O 0) a0 8 N N l0 O N V 0) A a 0 2 m N c 3 40 04 CO of 0 o o o o 0 0 0D CO O 0 0 O "rS o o 0 0 o 0 ao u O. 0: CL 0 0 0 0 000 co O O O O (O O 0 M V O O O 0 O 0 0 O 0 0 O in O r M V 0 0 co C C U a) V N w d O O O (n F- to C.) c o O 0 0 E 000. 8 o 8 W a 0 0 C N N M V N N N N 0 0 0 0 N N Cl N 0 O O 0 m 0 O 0) c U N N O N 0 O O O O) 0 0 0 o 0) c U N O N 00 0 0 0 0 O O 0 CO O N O O O O O V t 8 m m 0 N E a 8 0 ce 0 m 0) FL U 0 C a7 O_ W 03 N N O O N N 0 O O 0 0) 0 C7 0 0 O N V U 0) N 0 0 0 0 0 0 0 0) r M 0 0 0 of cc 0. a O r N N 0 0 N N 0 O O a0 8 a O l0 .(0 0 a W c c m a D U) m m n O N 0 0 O O 0 0 0) «O N N 0 0 O N 88 00 O) c 0 O m O Din e 1J O u- a 0 0 O O 0 a) w W CO V' N N O O N N 0 0 0 N 8 a c E 8 O. (1 0 E w 0 N O N 0 O O O M 0 0 O M 8 0 (O N O N 0 O O 0 M 0 0 0 M 8 o a a) 0 U m H 8 0. (0 I••• N O cos, co 0 O O) O N O) O 0 M O O O O) 0 0 0 0 O O o(i 0 n 0 M (0 i cn N m 8 ra ca 0 M 0 0) N N O O N N 0 O O V 8 O 0 8 0 a a. O N N O N 0 O O O O O O O O O N 0 0 0 0 O 0 0 0 8 0 8 0 8 0 .0 7 N O N 0 O O N N N N p N 0 0 0 (O N 0 O O co co 0 as CL O. c l0 N 0 M 8 •g _m m a m a) a c n c c o 0 IT 'ar M V N N N N N N 0 O O O M 0 0 0 M O .0 M 0 c t a) O) 8 0 N N N 0 0 0 0 0 0 o (O M 0 0 0 00 (Dh v ca ca a a 0 N N N N 0 N 0 V O M 8 (0 a 0) a E o. i CO N N N 0 0 0 0 .0 a 1- 0 8 (0 a 0 0 a) 0 o) N N O N 0 O O N 0 0 0 0 N 0 0 a 0 M N N 0 O O 0) 0 0 0 O 0 0 O 8 a M N N 40 O O O V 0) N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 W 0 O 0 n 0 of M co 1- 0 O ai c 2 0 0 O N d (0 E 2 O O O O O O co O O O O r O O O N O O N O O N O O O O O t` O M C1O CO O O O O N O O o co O co O O N O O C5 U o o o 0 0 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CO 0 0 0 a 0 0 0 0 0 0 0 0 o o 0 0 0 0 0 0 1 O O 0 0 (0 O O 0 0 O O O O O O O O N O o 0 0 0 0 0 N 0 o 0 V O C V t o (n C` (f) O (C) O O o O r a) 0) r co a t0 M r N N N O 0 a 0 M r N CO CO N CO CO 0 0 N N N N cO V f.1 y y y y y y 0 0 0 y y U) 8 (7 0 0 0 0 0 0 0 0 0 0 >>mmm i388 0000000000000000000 aaaaaaacaaa 0 0 c c= a) 0 U a a a a a a a a a a a aaan.aaaa x 1- r• O a) O Z N N N 0 1-_- N E C0 yccocop o (0 .0 o o in a O CO W `m c eo 1-3 co N .y 0 ,5 n O> C y— O (0 V a) o N N CO O CO 0 y CO y CO 0.0 0 V co E O Z C O C r e.. E a O ON p y m LL c 0 N d y y N Ct E O C o n N O O 2 ad cc a o r d !IT- E a c ee CO o m E E a c •am co c 3 c v vt E amw f. 5 c a' ONO o o U U 8 m C C E 7 w N co E S L w m c c �2 0i 3 E Ea v a II" c N 10 d r cc) c v m U in .5 N io cc E m y m� 0 ix� F 3 E ti 8 o �v•� E 6 m oil `o a)ac o a F 3 2 uiV m> E v c ro co OC N N a O. vz a N t a o v a a i sma or r N M a O CO t` O O) o 01 CO a (O O N. CO 0) 0 r N CO a O CO N N 01 N N N N CO M CO CO CO CO 0) CO CO CO CO M CO CO CO CO CO CO 01 M M 0) M 0) 0 0 0 0 0 0 0 N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N 0 N CO O r 01 CO et (O Iii iiiiiiiiiiimplippimpi I IH I INIIIIOH HH IIIIIHI IIIIIH IO IIHH L n n l n�i� immiimmimmummimmilimil immmommiummummommil mmimimmimmommommil mmimmimmilimmilimmimmil mmommimmimmommommi liiiiiiiiiiiiiiiiimmimmommt mommimmmomilimmimi ntwtHtlmmmmmmm ,_1 I ii,..gl, 0 u.:::.<0 i ,:E 1; 1 ,i ft 8 1 ii s d Li r 3 °s A B Lu ii cDt-gW cc 3 re S 0 0 rn 0 0 0 0 m k 8 0 8 0 0 0 0 0 0 k 0 0 0 8 8 k 0 0 2 8 co 8 co 0 0 0 2 2 Ito 0 0 0 0 G 0 tri I R 0 S J 0 A 2 0 cm 0 0 8 CO 8 a To k J 0 0 0 0 8 a 0 8 0 0 a 0 0 0 8 a 0 8 co 8 0 0 0 0 8 0 0 k a 0 0 0 0 0 CN 8 0 0 8 0 0 0 0 8 0 E A a 2 0 0 p 2 k k 8 k k 0 0 p .0 g 0 tri k a 0 8 k a E ID c e a 0 01nv1ot.100 0CT710ow100) 10(1010110(010101010100W10 10 00 (010(0 000000000000000000000 op 0 cm 0 0 0 8 0 8 0 8 0 0 0 0 0 0 0 8 8 0 0 a 0 0 0 0 0 0 O O O 0) O O O 0 01 c 0 0 N V a) U E 0. 0 0 N 0 0 O O N L. N M O 0 0 O N O O 0 N 8 V O O O O O O O 8 a o c V (0 a) ce O 0 0 O co 0 0 0 0) 8 (0 O 0 0 V O 8 O 0 O O O O O to '0 n 0 0 0 0 O N 0 0 0 0 0 N O O 0 0 0 O O 0 0 O O 0 co .o E 2° 2 Q E 0) co (0 C 2 E a O O O O 0 N O 8 0) O O 0 N M 8 O N M .o a O 0 O O (f) co O 8 N Co en 3 a a 8 0. ct 0) 2 0 (0 (O (O CO CO CO CO CO CO CO CO N N 0 0 0 0 0 0 0 0 N O O O 0 O O 0) O N O O O O 0) O p O O O O O O O O 8 O O O 0 0 O N O 8 O 0) b9 v v to 3 d 0 U w a a) E 8 m N 0 a E a) N 0) E U m Z co N Q V :o a O O O O O 0 o o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o000 000(0 Oi 0016 0)0(0 -NnNV N V nn O O N n Is- I's nIs- nnnn 000000000000 N N N N N N N N N N N N 0 O O O O 0 0 0 0 8 8 LL CO O 0 0 0 (ri r O O ui 2 LL 0 0 0 7 (0 rn 8 m 0. 0 2 1- y 2 N CO O N 0 0 0 0 O O O O 0 O 0 m A O 0 M CO N 0 0 0 v N O 8 a co O N 0 0 O O V N 8 a c 0. 0 J Q y 8 CL O CO O N o o 00 00 0 O O O O O O O 8 0 O 0 O N .iC d a o a O n O co O O N N 0 0 0 0 0 N O O O 0 0 N O O O O 0 O O 0 0 O O 8 0 0 O 8 0. E 0 0 a E m rn (0 m 2 E a a0 O O N 0 0 0 0 0 M O O O 0 0 0 M c O C w W 0 c Q d o m N 0 m 0 0 0 ai 0 O O O O O O O 8 O O O 0 0 0 O O O O O O 0 O O 0 M M 0 0 0 N. O O O N O Vl N L (0 0 c (0 m O 2 m 0) c 0 c •0 N 0 O U m 0. m 60 c c o m 0 c m 0 0 0 c N M M hU O O 8 69 a, y c c g r 41 Q L_ C 04 O O m 2 0 Q C C •O 282 X N ED- 'co d d aNi� Um. OD (C a> o E x a U p 2 0 m a Q a 3m_`' s54-31 c E Q C N- 0 8 W O v 3 m 0 8 m a 0 L O G N E c Z N h E :0 �1 C X .c (0 (00 L_ 8 E 60 LQ C 8 00 0 v CT CO 0 260 0. L m 0 N O 0 W C C (0 C E C C o N C �7 8 s m CD 7 .c I OOti O 7g U g 8 W 8 9 8 8 8 R 8 2898 O N i 0 GGcG R Nm1+1N GOO TO 8 8 sq° 88 N 9 88 G N 8 6.66 N -x82 ooGo 88(118 N N91Ng °o ng�w N 66:6 N N O Y Nh1 G O O G N O N N W mood 58 Aggg 11 N N O b 11 N 88 p tl 8 O O 2. 8g8 °V 000 Era 0 °I n2 O al^ N m g� "s 2 3 5 1, 4V A IONN N 2 N n2 m N N 0 ID Y Y 2 E A O N 0 41 8 8 8 8 9 8888 oGod b 1RM0 G O O ARUJ °2912 8 8898 2000 8 g Y G N g GG O N g a 0'000 HT! °eoa 891 ee oN 221.- I 4S K" 55 m „yG ffiI F-sv� H iY 9 m 1121,T,& w 8 12 as Qo o V L t} g av2 U UUUN2 o 2g b goo gg 1 y L U UUUN� agg 0UUtll _2Us 2 m O Y b __O Y of x o 'O 46,9g L' Y f H r 811 a` U N D U' 2 Y F H H U m 0 S 6.66 OS M N m Q O N oa H cig If N0 tl tg ER W" Sam at ln 1 22 2 0 a� m 33 q YXig X '2 j 4 2 4 5 1 as o 2 w a 3 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) (Based on 3.9% 1.68% Levy Limit) 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 Distributuion 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 8/13/08 2006 16,072,890 17,341,719 6,886,700 7,189,300 154,308 142,527 9,031,882 10,009,892 350,330 9,382,212 2007 2008 350,330 10,360,222 17,855,312 6,526,300 144,417 11,184,595 0 11,184,595 770,288 870,514 968,892 1,141,159 (2) (Proposed) 2009 17,291,477 (4) 6,212,800 146,084 (3) 10,932,593 350,330 11,282,923 8,611,924 (1) 9,489,708 (1) 10,215,703 (1) 10,141,764 10.19% 7.65% -0.72% 154,308 14 2, 527 144,417 (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2009 Number Provided by Dakota County as of 8/12/08 (3) Market Value Based Levy for Fire Station Based on $146,084 Levy Spread to Taxable Market Value on 2/21/08 Last Update from Dakota County 2/21/08 Shows the Levy of $146,084 $2,374,641,200 $.0615 per $1,000 as our Estimate (4) In 2004 Started Including the Water, Sewer, Storm Water Arena Enterprise Funds in These Figures 146,084 (3) Clcrics F7e 4ROSEMOUNT kwys 1 2.0. MINNESOTA M E M O R A N D U M To: Jeff May From: Judy Miller Date: August 8, 2008 Subject: Requested staff estimates and responsibilities I have put together some detailed information on the following pages that describe several main areas of responsibility within our department that require additional staff time. When the Deputy Registrar function is moved to the Dakota County Library, it will free up time from our current staff equivalent to approximately one full time person. On the pages that follow, I list the Finance work tasks that require additional staff attention, based on a percentage of one full time person. Based on the current volume of work, and what we anticipate for additional assessment needs, I would break down the position as follows in the same manner that we use for the Springsted employee detail reports: Assessments Existing and added functions 25% Insurance Claims processing 10% Insurance Policy Renewal Assistance 5% Fixed Assets Current functions 20% Fixed Assets Reassigned duties and Physical Re- inventory 15% General Finance Dept. Assistance 10% Documentation Manual Creation (all areas) 1_526 100% 1 4ROSEMOUNT MINNESOTA M E M O R A N D U M Insurance Insurance claim summary for year -to -date 2008: General Liability claims 5 claims processed this year, all for single claimants. Automobile claims 7 claims processed this year, all for single vehicles. Property claims 8 claims processed this year, involving 15 locations and /or pieces of equipment. For a very simple claim, I would say a minimum number of hours spent processing would be two hours. Not many claims fall into this low number of hours, but they do occur. For a very complex claim, like the April incident involving lightning damage to three city locations, I would say I spent about 30 hours total on the claim. This involved working with a large number of employees and vendors, and was much more complicated to track and balance all the code expenditures accurately between our insurance adjuster and our accounting records. I discovered an overcharge by a vendor that resulted in a refund of almost $600 during my reconciliation. In general, I will outline the various tasks associated with some of the main steps of processing a claim so you will have access to this information if Council inquires. Not all items are needed for every claim, but the more complex claims can involve many of them. Information gathering: speak with supervisor and the employee involved, request pictures, request police report, request repair estimates, request information on employee labor hours, pull timesheets /paycheck copies /CarteGraph tracking information for labor cost calculation, possible discussion with risk manager or claims adjuster. Filing the claim: complete the excel claim form and print, fax to the League with all appropriate documentation, scan to our risk manager, copy for the safety committee and add to the quarterly summary report for discussion, file appropriately. Claims adjuster contact: phone calls and emails as necessary to discuss claim and convey needed information (photos, estimates, adjustments to estimates, police reports, etc.), review questions and update on claim status. Follow up on reimbursements as necessary. Vendor contact: directly contact vendor when necessary for invoice information, breakdown of labor and materials, or additional questions as they develop. City reimbursement: receive final bill from vendors, write purchase orders, copy P.O.'s for insurance file, submit to the League, receive League's check, review budget code balances in A/R for correct reimbursement, encode check for receipting, add file notes and close file. Follow -up if needed: court restitution follow -up in some cases requires additional contact with the police department, adjuster and Dakota County court system. 2 ROSEMOUNT M E M O R A N D U M For an estimate of the total claims we may see this year, since I have processed 20 claims in 31 weeks during 2008, I will estimate that we may have a total of 34 claims that will likely be processed prior to the end of the year if this pace continues. If 6 hours is spent on the average claim, then I would estimate that approximately 204 hours will be spent processing claims this calendar year. I would say that is roughly 10% of my time. However, since I would also say that I put in considerably more than 200 extra hours per year, this could easily be worked into the deputy hours that are freed up due to the relocation of these duties to the library. I have included these hours as approximately 10°10 of a full time person's duties in my summary. As a side note to the insurance issues, there is much more to the insurance area than just claims processing, and I would continue to work with our risk manager in policy review and coverage issues, as well as working with our insurance agency on necessary insurance certificates, the annual property /liability policy renewal application, insurance schedules for blanket coverage limits, the worker's comp. renewal application and annual audit, and general coverage questions from employees (like vehicle transport coverage for PD training classes and the recent RNC special coverage investigation). Assessments What we are doing now: Engineering Dept. prepares the street and utility assessment rolls and sets up the pre- payment period. Finance accepts any pre payments, writing receipts and recording payment information. When pre payment period expires, Engineering Dept. revises tax roll and sends input form to the County for set -up of new assessment. Finance Dept. prepares entire tax roll for delinquent utilities that are certified twice per year and sent to Dakota County after removal from the utility accounts. Engineering Dept prepares certifications related to unpaid weed notices and sends input forms to the County. Finance receives printed reports from the County containing new assessment information (both summary pages and book sheets showing the amortization schedule by parcel). Reports are checked for accuracy based on PID #'s, assessment amounts per parcel and total, interest rates, etc. County is contacted to make corrections of any errors that are found. Finance staff receives electronic title transfer reports from the County on a daily basis. These are forwarded to the Utility Billing Dept. and Building Inspections for record updating. These are also reviewed and copied for any changes to City parcels that need to be updated in the fixed asset system. 3 MINNESOTA 4 ROSEMOUNT 4 MINNESOTA M E M O R A N D U M Finance receives printed reports from the County for paid receipts, deletions or corrections of any kind to any special assessment. Reports are reviewed for accuracy and filed according to the assessment number. Finance receives printed Division Reports from the County for any lot splits or lot combinations that occur. These are first reviewed for any outstanding assessment balances on the old parcels listed on the report. If balances exist, investigation must be completed to determine how to re- allocate the outstanding balance to the new parcels. This often involves the Engineering Dept. for lot splits due to platting of new developments and review of subdivision agreements. Input forms have to be completed and sent to Dakota County for corrections from the old to the new parcels. These Division Reports are also copied to the Utility Billing and Building Inspections Departments for record updating. Finance receives calls from realtors and title companies to verify pending and levied assessments. City records must be checked for unpaid and certified utility account balances as well as pending street assessments for current projects, and county records must be checked for balances of assessments added to the current year's property taxes and the remaining balances for levied assessments. If balance payoffs are received at the City, Finance Dept. verifies the correct balance, encodes the amount to the correct fund and writes receipt. A receipt for payment of the special assessment(s) is then completed and sent to the County so the property tax system can by updated and adjusted accordingly. Finance Dept. addresses special situations and investigates as necessary to resolve. Corrections and Deletions are sent to the County if needed on additional input forms Finance Dept. receives monthly payments from SA collections at Dakota County. The totals are calculated by fund and receipts are written. Finance Dept. receives annual printout from Dakota County listing all outstanding assessments by SA# and parcel. The City provides this to our auditors for their use in establishing the assessments receivable balance at the end of the fiscal year. What we are NOT doing now and should be doing. Recording new assessments and all assessment activity in a tracking system, recording the applicable special assessment number, fund, number of years, interest rates, parcels and balances. Recording monthly payments in the tracking system that are received from Dakota County and any balance pay -offs received at the City, as well as the payments received from the County through regular property tax and delinquent tax distributions. Updating the system by parcel number and amount paid so year -end balances will be correct and verifiable to County records. 4 ROSEMOUNT MINNESOTA M E M O R A N D U M Tracking deferred assessments by SA fund and parcel. Maintain balance according to interest rate and deferred principal amounts, to be able to verify the County balances at the end of the year. Filing book sheets by PID number for easier access to answer questions from residents. Tracking balances that are paid or expired (the assessment has had the final installment added to the tax roll at the County). Moving those sheets from the PID files to the archived files by SA number. Reconciling year -end balances to the County printouts that are provided. Including duties covering the current assessment functions and the additional duties that we should be doing on a regular and annual basis, I have included these hours as approximately 25% of a full time person's duties in my summary. Additional Assessment Notes I have contacted eight other cities in Dakota County to discuss how special assessments are handled through their city. Three of the cities pay for LOGIS assessment software called the "Property Data System I contacted LOGIS to get a quote for that system if we were to implement it. I was given an estimated cost for the first year of $7700, and a second year fee of approximately $8350. The yearly fee is subject to increase based on normal inflationary rates and is also subject to increase based on the overall number of parcels in the City and the number of active special assessments the City is maintaining. One city utilizes a custom written data base, but the contractor who wrote it cannot be located so they can no longer do any maintenance or updating on their system. It continues to work for them, but they can't modify it in any way. All other cities use a manual tracking system for keeping their assessment balances, most utilizing an Excel spreadsheet system to do this. A couple of the cities have shared their spreadsheets with me by e -mail, so I can try to develop a better system for our tracking based on some of the shared files. This would allow us to have a checks and balance system with overall totals provided by Dakota County, and would provide us with a way to zero in on possible errors and process necessary corrections in a timely way. Since the input forms we use to send information for new assessments to the County is in an Excel file, we should be able to import much of the information for new assessment additions directly into our new tracking spreadsheet if created. There is not a system that exists that will allow automatic comparisons between City and County records. The LOGIS system does allow for automatic uploads of new assessment 5 4 ROSEMOUNT 6 MINNESOTA M E M O R A N D U M information into the County system from City generated files. However, it cannot accept information from the County in a reverse manner, and cities using it must still send all other communications to the County manually. Rozanna Byers from Dakota County stated during our discussion that typically a lower level staff person is managing the day -to -day activities of assessment processing. Per my conversations with other cities, this appears to be the case, involving upper level Finance staff only during the annual reconciliation to County records in preparation for audit. Rozanna also mentioned that the County is currently doing an analysis of software from Tyler Technologies to enable them to move their entire property tax system (including a module for special assessments) to a new system. (Their current system is outdated and was written and is maintained by in -house employees.) Since our Invision software is connected through the parent company to Tyler Technologies, it may be an option in the future to add their assessment module that would integrate directly with the County. At the earliest, the County is looking towards 2010 before the new system would be implemented. Additional General Department Notes Virginia's time has now been increased because of the implementation of the new Metro Area Transit Tax as of 07/01/08. This has added many hours on to her accounts payable run preparation due to tracking the correct tax rate charged by vendors and contacting the vendors who are incorrectly charging us. This will likely result in requiring us to submit refund applications to the state on a regular basis as some vendors cannot separate general sales tax from special local taxes and are overcharging us. This new review requirement is consuming the time that she used to be able to devote to fixed asset assistance, which we have estimated at 10% of her time; therefore, these hours will need to be shifted to other staff members. In addition, the general requirements and volume for accounts payable are increasing at a level that make it difficult for Ginny to get her job duties done in a 40 hour work- week and she often has overtime as a result. She has worked approximately 50 hours of overtime in the first half of this year, which is prior to the implementation of the new Transit Tax. Although her overtime during the audit preparation period cannot be avoided, I can still see her working 100 —150 hours of OT this year due to the Transit Tax changes and general A/P volume increases. With this increase in Accounts Payable and other general Finance staff assistance, I have included these hours as approximately 10% of a full time person's duties in my summary. (Fixed Asset assistance percentage is included later.) Michelle has added many hours per month to her job duties for the review of bank statements to actual checks processed through accounts payable and payroll records to verify compliance with audit requirements. We are estimating that this takes approximately 10 hours per month to complete the cross reference review of all 4 ROSEMOUNT MINNESOTA M E M O R A N D U M applicable checks and reports. Therefore, this new requirement has added about 120 hours per year to Michelle's job duties, which we are adjusting for in Michelle's percentages for the 2008 Springsted review of employee details (separate from this analysis). We want to begin implementing a new physical re- inventory schedule for the fixed asset system so a third of the city could be reviewed each year. This cycle basis would result in a complete re- inventory every three years. This has not been done yet in 2008 due to time constraints. Adding this job function to Virginia's time previously allocated to fixed assets that she will not have available, I have included these hours as approximately 15% of a full time person's duties in my summary. On -going fixed asset updating should be done on a monthly basis, processing new additions and recording transfers and disposals. Each year I don't have time to start the process until approximately July to August due to other project requirements throughout the year (audit, fee study update for annual state building report, etc.). This is a large factor in the insurance renewal schedules not being completed until very late in the year and the main reason why the physical re- inventory has not been done yet for the portion due in 2008. I have included these hours as approximately 20% of a full time person's duties in my summary. The annual insurance renewal documents, including updated property and equipment schedules, are not normally completed until approximately December 1, which is the actual policy renewal date. It should be submitted weeks ahead of the renewal date, but has not been able to be completed earlier in the year due to current time and staff constraints. I have included hours to assist in the renewal application process as approximately 5% of a full time person's duties in my summary. As one last function that I see as necessary and not done at this time is the completion of documentation manuals for the areas of assessments, insurance, and fixed assets. As a department, we have been striving to complete manuals for Utility Billing, Payroll and Accounts Payable, but have not had the staff time to put the documentation together for these other functions. We have had to complete much more stringent risk assessments during the last year as a newly implemented audit requirement, and the completion of additional documentation manuals is showing a good effort toward consistency and internal controls. I have included these hours as approximately 15% of a full time person's duties in my summary. Deputy Registrar I have reviewed the number of hours that each of our three staff members are spending on duties at the front counter and at their desks completing all of the necessary reports and bank deposits associated with deputy registrar functions. I used the task allocations completed for the Springsted review of our department staff as a starting point, and had each of the three update it for the current year. I then used the same number of hours 7 4ROSEMOUNT M E M O R A N D U M worked that Springsted uses for each of the three staff members to calculate the estimated hours per year that are devoted to the current deputy functions. Based on the information, the Deputy Registrar function takes approximately one full time person's annual hours. As a result of evaluating the additional needs of our department, I feel the hours previously spent on providing Deputy Registrar services could be very productively used as outlined above. MINNESOTA