The URL can be used to link to this page

Home My WebLink About13.F.2. 2008 Budget Update /3. F. 2,. OF SHAKO PEE ( I) CITY Memorandum TO: Mayor and Council Mark McNeill, City Administrator FROM: Gregg Voxland, Finance Director SUBJ: 2008 Budget Update DATE: October 31, 2007 Introduction Council discussion and direction on several items for the 2008 budget is requested. Background General Fund A. 2007 budget status; Councilor Menden asked about the "under-spend" status for 2007. Based on the follow data, it appears that the "under-spend" may be less than anticipated in the budget which was 4% and may be 1 to 2%. Therefore, Council should consider reducing the under-spend factor built into the 2008 budget. YTD 9/30 12/31 2004 66% 95% 2005 65% 92% 2006 65% 93% 2007 70% B. 2008 changes. See attachment B. With the exception of reducing a building inspector position, the changes selected by council at the last budget meeting have been incorporated plus refinement of revenue for permits and changes in the budget amounts for insurance. c. The Springsted model was updated for "unbillable" time (breaks, training, counter time, etc. ) in the Inspection division and time for inspections based on the new protocols. This resulted in the model indicating that a reduction in the number of inspectors was not supported. D. Funding for roofing management program. See attached memo C. E. Items listed as "one time" with funding from MVHC or fund balance are listed below. The first half of 2007 MVCH has been received in the amount of $260,296. Should any of these items be built into the 2008 budget? Fire Dept anniversary 10,000 IT back up plan 56,000 Library noise/solar mitigation 46,000 . Green/Energy initiatives 50,000 Fire Station 51 parking lot 15,000 Fire Station 51 concrete apron 50,000 Comm_ Center Painting 55,000 Comm. Center Parking lot 25,000 Comm. Center carpet 20,000 Comm. Center point of sale equip 20,400 Subtotal 347,400 F. Billing for Fire Calls was brought up last year and again this year for consideration during the budget process. Attached (D) is a 2005 memo from the League of Minnesota Cities concerning billing for fire calls. Several items to consider are raised in the memo, particularly on page 4. 0 Billing when the owner did not call for service. 0 Certifying for collection with taxes. 0 Uniform rates for fees. 0 Is charging a fee the best choice for residents. 0 Collecting the fee when insurance does not pay, failure to do so may be insurance fraud. G. Taxes as a percent of revenue. See attachment G. Taxes as a percent of revenue have gone from 50% in 2003 to 75% in 2008. Over the long term, where does Council want that percentage to be? Utility Funds Attached are the Sewer and Storm Fund budgets for 2008. They are similar to 2007 and the projects were included in the CIP list reviewed earlier. Rates are proposed to remain unchanged for 2008. Park Reserve Fund MSA 394 "Cash payments received must be used only for the acquisition and development or improvement of parks, recreational facilities, playgrounds, trails, wetlands, or open space based on the approved park systems plan. Cash payments must not be used for ongoing operation or maintenance of parks, recreational facilities, playgrounds, trails, wetlands, or open space." A. Staff time: Council previously directed that staff time be charged to projects at 1.3 times the wage. Engineering time is charged to projects at 2.5 times the wage. . Does Council want to stay at 1.3 times the wage? . Does this apply to just the Landscape Designer or all non- engineering staff? B. Preliminary project staff time: Park projects typically have a longer lead time to get to the point of actually having a project to design. At what point should staff time be charged to a project? Until just recently, staff time was not charged to projects. An example is the dog park. Staff time is spent on this concept but it is advance time trying to find a location etc., not designing and administering the "bricks and mortar" part. C. Park signagejnaming: this was included in the CIP for Park Reserve funding but seems it would be better funded from the Recreation Fund - fund balance. D. Inter-fund loan: the inter-fund loan has not been recorded yet. The cash balance of the fund went into the negative in June. When first considered, it was a five year loan. When the park CIP was presented for 2008 it was extended to 10 years. If the loan goes past 5 years, I recommend that Council re-examine the timing of projects or allocate additional funding to the Park Reserve Fund to keep the loan at 5 years or less. It is proposed to borrow money from the Sewer Fund at 5.0% interest effective June 2007 in the amount of $2,000,000. For a 5 year term, the annual payment would be $462,000 and interest would total $310,000 but for a 10 year term, the annual payment would be $259,000 and interest would total $590,000. Action Discuss and give staff direction. Gre~Xland Finance Director H,\Finance\budget\ B 1 2 3 Tax Rate Tax Rate Tax Rate 31.938 31.938 31.938 Levy increase 12.18% 12.18% 12.18% SUMMARY GENERAL FUND - 2008 GF Total Revenue 15,563,060 15,588,060 15,588,060 (612,000) Less Building Revenues Transfer In 1,740,000 1,740,000 1,740,000 Total Revenue & Transfers 17,303,060 17,328,060 16,716,060 GF Expend 17,307,640 17,412,760 17,412,760 (820,540) Less Building Expenditures Options to cut Engineering charge to sewers (30,000) Inc. Inc. Engineering position (60,000) Inc. Inc. Engineering position Building Inspection position (80,000) Recreation position (40,000) Admin Office Service position (30,000) Inc. Inc. Unemployment 21,000 Inc. Inc. Fire pension (90,000) Inc. Inc. Options to add Fire Chief 100,000 Inc. Inc. SCBA coordinators 3,500 Inc. Inc. Park building "rent" 112,000 Inc. Inc. I Police officers (2) (part year) 64,500 Inc. Inc. Home Town Messenger 24,000 Inc. Inc. Insurance Inc. Inc. Roofing program 30,140 30,140 EDA Transfer out 26,000 26,000 26,000 Recreation Transfer out 1,099,000 1,120,010 1,120,010 Total Expenditures and Transfers 18,427,640 18.588,910 17,768,370 Net surplus (deficit) (1,124,580) (1,260,850) (1,052,310) Funding From Fund Balance 800 MZH 456,000 456,000 456,000 Entrance monument 25,000 25,000 25,000 4% underspend 692,306 696,510 696,510 Net surplus (deficit) 48,726 (83,340) 125,200 11/1/2007 8:55 AM R5509BUD .001 CITY OF .PEE 10/.9:01:27 Budget Report Page - 1 Fiscal Period: 9 / 7 Level Of Rollup 5 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 01000 GENERAL FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 7,326,802- 8,741,111- 9.471,594- 5,191,969- 11,560,500- 12,979,410- 12,979,410- 12,979,410- 4100 SPECIAL ASSESSMENT 6,786 2,892- 6,597- 1,106- 2,000- 2,000- 2,000- 2,000- 4200 LICENSES AND PERMITS 3,197,690- 3,177,521- 1,644,174- 790,016- 1,504,700- 820,000- 820,000- 820,000- 4400 INTERGOVERNMENTAL 364,979- 434,211- 506,239- 237,210- 402,820- 344,000- 344,000- 344,000- 4500 CHARGES FOR SERVICE 1,574,649- 1,573,955- 1,294,733- 800,263- 1,558,800- 607,650- 607,650- 607,650- 4820 FINES & FORFEITS 255,763- 277,774- 374,808- 297,435- 280,000- 430,000- 430,000- 430,000- 4830 MISCELLANEOUS 174,088- 287,650- 452,508- 78,146- 283,500- 405,000- 405,000- 405,000- 4001 REVENUES 12,887,186- 14,495,114- 13,750,653- 7,396,145- 15,592,320- 15,588,060- 15,588,060- 15,588,060- 6000 EXPENDITURES 6001 WAGES & BENEFITS 7,056,538 7,689,039 8,482,664 6,937,753 9,807,350 10,504,560 10,295,330 10,295,330 6200 SUPPLIES AND SERVICES 4,063,966 4,377,291 5,115,228 4,520,431 6,163,220 6,210,030 6,322,030 6,322,030 6600 MISCEllANEOUS 86,086 99,939 91,297 115,526 254,150 181,400 181,400 181,400 6700 CAPITAL OUTLAY 12,930 93,703 173,063 71,495 574,350 614,000 614,000 614,000 6000 EXPENDITURES 11,219,519 12,259,971 13,862,251 11,645,205 16,799,070 17,509,990 17.412,760 17,412,760 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 1,342,560- 1,373,131- 1,586,979- 1,188,000- 1,609,730- 1,740,000- 1,740,000- 1,740,000- 8005 TOTAL TRANSFERS IN 1,342,560- 1,373,131. 1,586,979- 1,188,000- 1,609,730- 1,740,000- 1,740,000- 1,740,000- 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 1.408,191 1,175,986 1,309,889 1,134,638 1,178,770 1,151,500 1,146,010 1,146,010 8050 TOTAL TRANSFERS OUT 1.408,191 1,175,986 1,309,889 1,134,638 1,178,770 1,151,500 1,146,010 1,146,010 4000 REVENUES AND EXPENDITURES 1,602,035- 2.432,288- 165.492- 4,195,697 775,790 1,333.430 1,230,710 1,230,710 01000 GENERAL FUND 1,602,035- 2,432,288- 165,492- 4,195,697 775,790 1,333.430 1,230,710 1,230,710 tr , - D CITY OF SHAKOPEE Memorandum TO: Mayor and Council Mark McNeill, City Administrator FROM: Gregg Voxland, Finance Director SUBJ: Roof Preventive Maintenance DATE: October 26, 2007 Introduction The city has been approached to implement a preventative/long term maintenance program for roofing, similar to the maintenance program for streets. Background After the 2008 budget was assembled, Tremco met with city staff to propose a preventative/long term maintenance program for roofing. They offered case studies to show long term savings on roof maintenance and replacement by extending the life of roofing materials. Phase one would cost $30,139.20 comprised of diagnostics $14,364.28, repair work to reach a startup standard of $6,491.72 and one year leak response of $9,283.20. This proposal is good until 12/22/07. They would repair any leaks for one year for that fixed price. They would examine the roofing in detail and establish and maintain a database on the roofs. The next phase is to develop a plan of action for each building consisting of maintenance, renovation or replacement. Work would be staged based on Council's timing and/or funding level. The goal is to get the most value out of the roofing dollar and keep roofing materials in good condition as opposed to waiting until failure and replacement. There are nine buildings covered under the proposal totaling 227,448 square feet. Tremco is a vendor covered by a National Joint Powers Alliance (Minnesota based) contract. Shakopee would need to join that organization to utilize the contract. The City of Rochester was contacted as a reference and started with Tremco a year ago and reported all positive results. Action Discuss and give staff direction. AJ Gregg Voxland Finance Director H,\Finance\docs\ 6- ~ Ii) CD ,.... CO o 0 0 0 o 0 0 0 0 N N N N N . . 0 IlD . U) Q) ~ snouellaos!ll'.J c: (I) > Q) ~ "C c: ~ LL sa6Je48 aO!AJas - CO '- (I) c: lA06JalUI (I) C) Sl!WJad/Oll 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 I 0 0 ci 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .q- N ci ex:> <0 .q- N ..- ..- ..- {- League of Minnesota Cities 145 University Avenue West, St. Paul, MN 55103-2044 Leag.u. 0/ Min_ow CitiflS (651) 281-1200 · (800) 925-1122 Fax: (651) 281-1299 . TDD: (651) 281-1290 C;u..s pnmwting _1/,,,,,,,, www.lmnc.org CHARGING FOR FIRE CALLS November 2005 Authority to Charge for Fire Calls For many years, the authority to charge for fire calls has been unclear. However, in 2003, the Minnesota Legislature passed legislation giving cities express authority to impose fees for emergency services, including fire protection. A city's ability to charge fire fees involves an interplay between three statutes. Minn. Stat. S 415.01, subd. 2, allows cities to charge for emergency services by passing an ordinance that specifies the amount and manner of the charge. The exact text is as follows: A city may exercise the power under sections 366.011 and 366.012 relating to charges for emergency services only if the city adopts an ordinance authorizing the manner and amount of charging for those services. Minn. Stat. s~ 366.011 and 366.012 apply to towns. Under Minn. Stat. S 366.011, a town can impose fees for fire protection services provided by or contracted for by the town. If the charge is not paid, the town can use any means available to private parties to collect it or may certify the unpaid charge with the county auditor for collection with taxes to any real property within the state. Minn. Stat. ~ 366.012 explains the process for certifying charges with the county auditor. By its terms, Minn. Stat. ~ 415.01, subd. 2 give cities these same powers. In 2005, the Legislature amended Minn. Stat. SS 366.011 and 366.012 to specifically give towns, and thereby cities, the authority to certify the unpaid charge to the auditor of any county in the state in which the person who received fire protection services owns real property. The AN EQUAL OPPORTUNITY/AFFIRMATIVE ACTION EMPLOYER county auditor is responsible for remitting to the city all charges collected on behalf of the city. Therefore, a city can certify unpaid fees regardless of where the property is located in the state. An important note to remember is that fire services generally include not only fire fighting, but first responders as well. Any ordinance authorizing fire service charges should define fire services broadly enough to include both of these activities. Contractual Issues in Collecting Charges While this law clarifies a long-standing question about city authority, collecting these fees may be complicated in some situations by a 1959 Attorney General opinion that applied contract law to the provision of fire services; the opinion stated that there should be a request for service before the city has an enforceable claim against the property for reimbursement. I When a homeowner calls the city for services, the homeowner likely agrees to pay the fee, especially if the city publicizes that it charges a fee. The situation is less clear if someone other than the property owner contacts the fire department. Ignoring such fires could be dangerous to nearby property and persons; accordingly, for public safety reasons a fire department would generally not stand by while a building bums. Even in these situations, a city could avoid contractual problems by using implied contract theory. The elements of an implied contract are (1) a benefit conferred by one party to another (2) appreciation of that benefit by the receiving party and (3) acceptance of that benefit when retention without payment is inequitable.2 Most citizens have an expectation of fire service if a city has a fire department. Moreover, a city can show in the vast majority of cases that preventing property from burning down is a benefit to the property owner. lA.G. op. 688-a (Oct. 6, 1959). 28 Dunnell Minn. Digest, Contracts ~ 2.05a (5th ed. 2003). 2 Providing Service to Property Outside ofthe City Many cities contract with towns or other cities to provide fire protection, requiring the city fire department to provide service outside of the city. These contracts typically authorize cities to bill the recipient of the fire protection service who lives outside the city. Cities have the authority to use any means available to private parties to collect unpaid charges, regardless of where the property is located.3 Minn. Stat. S 415.01, subd. 2, also gives cities the ability to certify for collection with taxes the unpaid fire charges on property located outside of city limits that is anywhere within the state. This statute states that cities may exercise the "power under sections 366.011 and 366.012 relating to charges for emergency services.,,4 One of these powers is certifying unpaid fire charges. With the 2005 amendment, the Legislature did not limit a city's authority to certify unpaid charges to property within a city's borders. Different Rate Structures Fire departments often respond to car fires, sometimes to non-residents of the city, or to another entity covered by a fire protection contract. Cities have inquired whether they can charge higher rates for these calls. Unequal fees implicate several constitutional concerns. The Supreme Court ruled in Mem'! Hosp. v. Maricopa County, that denial of "basic necessities of life" impedes the constitutional right to travel. 5 Fire protection might be a basic necessity and unequal charges may be a form of denying this basic necessity. Additionally, higher taxes and more stringent licensing requirements imposed on non-residents have run afoul of both the Constitution's equal protection and commerce clauses.6 Because of the possible constitutional 3 Minn. Stat. ~ ~ 366.011,415.01, subd. 2. 4 Minn. Stat. ~ 415.01, subd. 2. 5 Mem '1 Hosp. v. Maricopa County, 415 U.S. 250 (1974) (denying non-residents free non-emergency medical care violated the right to travel). 6 Metro. Life Ins. Co. v. Ward, 470 U.S. 869 (1985) (taxing non-residents at higherrate than residents violated equal protection clause); State v. Kolla, 672 N.W.2d 1 (Minn. Ct. App. 2003) (charging higher state license fee to non- residents violated commerce clause); 9 McQuillin, Municipal Corporations, ~ 26.48 (3rd ed. Revised 1995). 3 implications resulting from different rates, it is probably preferable to have a uniform policy when charging for fire calls. Policv Considerations Since this law was enacted, several cities have passed ordinances charging fire fees and more are considering this option. Aside from the concerns mentioned above, cities should consider the following issues before charging fire protection fees. First, the city should consider whether charging fire fees is the best choice. Some citizens may argue that the mechanisms for collecting and enforcing property taxes are already in place and that paying for fire services out of general revenue may be a better option than charging for fire calls. Second, the city should decide whether it is prepared to collect charges when the fee is not covered by insurance. Some insurance policies will only pay if the property owner has an obligation to the city. Ifthe city only collects fees in limited instances, the insurance company could argue that the property owner does not really have an obligation to the city. Furthermore, if the city aggressively attempts to collect fees from persons having insurance but looks the other way for persons not having insurance, the city could be committing insurance fraud. Third, if the city decides to charge fire fees, the statutes do not limit the amount of fees a city may charge. However, as is usually true for city fees, the fee should be reasonably related to the city's cost in providing the service. Finally, keep in mind that all fire fee collections belong to the city, not the fire relief association or fire department, and should be deposited in the city's accounts. Model Ordinances . Ordinance A: This is the basic model ordinance. The city will use all practical and reasonable means to collect the unpaid charge and may certify 4 the amount to the auditor in any county in which the service recipient owns real property. . Ordinance B: The city charges the town or other city, rather than the individual, for fire services pursuant to a Fire Protection Contract. The fees would have to be specified in the Contract. S ORDINANCE NO. AN ORDINANCE ESTABLISHING FEES FOR EMERGENCY PROTECTION FIRE SERVICES [Ordinance A: The basic model ordinance.] THE CITY COUNCIL OF THE CITY OF , MINNESOTA DOES ORDAIN: SECTION ONE: PURPOSES AND INTENT This ordinance is adopted for the purpose of authorizing the City of to charge for fire service as authorized by Minn. Stat. SS 366.011, 366.012, and 415.01. SECTION TWO: DEFINITIONS (A) "Fire service" means any deployment of fire fighting personnel and/or equipment to extinguish a fire or perform any preventative measure in an effort to protect equipment, life, or property in an area threatened by fire. It also includes the deployment of fire fighting personnel and/or equipment to provide fire suppression, rescue, extrication, and any other services related to fire and rescue as may occasionally occur. (B) "Fire service charge" means the charge imposed by the City for receiving fire service. (C) "Motor vehicle" means any self-propelled vehicle designed and originally manufactured to operate primarily upon public roads and highways, and not operated exclusively upon railroad tracks. It includes semi trailers. It does not include snowmobiles, manufactured homes, all terrain vehicles, or park trailers. (D) "Fire protection contract" means a contract between the City and a town or other city for the City to provide fire service. (E) "Mutual aid agreement" means an agreement between the City and a town or other city for the City's fire department to provide assistance to the fire department of a town or other city. SECTION THREE: PARTIES AFFECTED (A) Owners of property within the City who receive fire service. (B) Anyone who receives fire service as a result of a motor vehicle accident or fire within the City. (C) Owners of property in towns or cities to which the City provides fire service pursuant to a fire protection contract. SECTION FOUR: RATES [insert rate schedule] SECTION FIVE: BILLING AND COLLECTION (A) Parties requesting and receiving fire services may be billed directly by the City. Additionally, if the party receiving fire services did not request services but a fire or other situation exists which, at the discretion of the fire department personnel in charge requires fire service, the party will be charged and billed. All parties will be billed whether or not the fire service is covered by insurance. Any billable amount of the fire 6 charge not covered by a party's insurance remains a debt of the party receiving the fire servIce. (B) Parties billed for fire service will have _ days to pay. If the fire service charge is not paid by that time, it will be considered delinquent and the City will send a notice of delinquency. (C) If the fire service charge remains unpaid for 30 days after this notice of delinquency is sent, the City will use all practical and reasonable legal means to collect the fire service charge. The party receiving fire service shall be liable for all collection costs incurred by the City including, but not limited to, reasonable attorney fees and court costs. (D) If the fire service charge remains unpaid for 30 days after the notice of delinquency is sent, the City Council may also, on or before October 15 of each year, certify the unpaid fire service charge to the county auditor in which the recipient of the services owns real property for collection with property taxes. The county auditor is responsible for remitting to the city all charges collected on behalf of the city. The City must give the property owner notice of its intent to certify the unpaid fire service charge by September 15. (E) False alarms will [or won't] be billed as a fire call. SECTION SIX: MUTUAL AID AGREEMENT When the City fire department provides fire service to another fire department pursuant to a Mutual Aid Agreement, the billing will be determined by the Mutual Aid Agreement. SECTION SEVEN: APPLICATION OF COLLECTIONS TO BUDGET All collected fire charges will be city funds and used to offset the expenses of the City fire department in providing fire services. SECTION EIGHT: EFFECTIVE DATE The ordinance shall become effective Passed by the Council this day of , Mayor Attested: Clerk 7 ORDINANCE NO. AN ORDINANCE ESTABLISHING FEES FOR EMERGENCY PROTECTION FIRE SERVICES [Ordinance B: The city charges the town or other city, rather than the individual, for fire services, pursuant to a Fire Protection Contract.] THE CITY COUNCIL OF THE CITY OF , MINNESOTA DOES ORDAIN: SECTION ONE: PURPOSES AND INTENT This ordinance is adopted for the purpose of authorizing the City of to charge for fire service as authorized by Minn. Stat. SS 366.011,366.012, and 415.0l. SECTION TWO: DEFINITIONS (A) "Fire service" means any deployment of fire fighting personnel and/or equipment to extinguish a fire or perform any preventative measure in an effort to protect equipment, life, or property in an area threatened by fire. It also includes the deployment of fire fighting personnel and/or equipment to provide fire suppression, rescue, extrication, and any other services related to fire and rescue as may occasionally occur. (B) "Fire service charge" means the charge imposed by the City for receiving fire service. (C) "Motor vehicle" means any self-propelled vehicle designed and originally manufactured to operate primarily upon public roads and highways, and not operated exclusively upon railroad tracks. It includes semi trailers. It does not include snowmobiles, manufactured homes, all terrain vehicles, or park trailers. (D) "Fire protection contract" means a contract between the City and a town or other city for the City to provide fire service. (E) "Mutual aid agreement" means an agreement between the City and a town or other city for the City's fire department to provide assistance to the fire department of a town or other city. SECTION THREE: PARTIES AFFECTED (A) Owners of property within the City who receive fire service. (B) Anyone who receives fire service as a result of a motor vehicle accident or fire within the City. (C) Owners of property in towns or cities to which the City provides fire service pursuant to a fire protection contract. SECTION FOUR: RATES [insert rate schedule] 8 SECTION FIVE: BILLING AND COLLECTION (A) Parties requesting and receiving fire services will be billed directly by the City of within _ days of the fire service. Additionally, if the party receiving fire services did not request services but a fire or other situation exists which, at the discretion of the fire department personnel in charge requires fire service, the party will be charged and billed. All parties will be billed whether or not the fire service is covered by insurance. Any billable amount ofthe fire charge not covered by a party's insurance remains a debt of the party receiving the fire service. (B) Parties billed for fire service will have _ days to pay. If the fire service charge is not paid by that time, it will be considered delinquent and the City will send a notice of delinquency. (C) If the fire service charge remains unpaid for 30 days after this notice of delinquency is sent, the City will use all practical and reasonable legal means to collect the fire service charge. The party receiving fire service shall be liable for all collection costs incurred by the City including, but not limited to, reasonable attorney fees and court costs. (D) If the fire service charge remains unpaid for 30 days after the notice of delinquency is sent, the City Council may also, on or before October 15 of each year, certify the unpaid fire service charge to the county auditor in which the recipient of the services owns real property for collection with taxes. The county auditor is responsible for remitting to the city all charges collected on behalf of the city. The City must give the property owner notice of its intent to certify the unpaid fire service charge by September 15. (E) False alarms will [or won't] be billed as a fire call. SECTION SIX: MUTUAL AID AGREEMENT When the City fire department provides fire service to another fire department pursuant to a Mutual Aid Agreement, the billing will be determined by the Mutual Aid Agreement. SECTION SEVEN: BILLING PROCEDURE FOR_FIRE PROTECTION CONTRACTS WITH TOWNS OR OTHER CITIES When the City fire department provides fire service to another fire department pursuant to a Fire Protection Contract, the billing will be determined by the Contract. SECTION EIGHT: APPLICATION OF COLLECTIONS TO BUDGET All collected fire charges will be city funds and used to offset the expenses of the City fire department in providing fire services. SECTION NINE: EFFECTIVE DATE The ordinance shall become effective Passed by the Council this day of , Mayor Attested: Clerk 9 SANITARY SEWER FUND 2008 BUDGET ACTIVITY: Activity in this enterprise fund reflects the operations of the Municipal Sanitary Sewer System. OBJECT DESCRIPTION: Description of lines items: Salaries: Share of publi c Works staff/Engineering staff including GIS Specialist. Supplies and Materials: Repair and maintain current sewer lines including; manhole replacement, repairing lines, GIS/CMMS software and hardware, motor fuels, miscellaneous. Professional Services: Attorney, engineering consultant for projects, televising, foaming, lining of sewer mains, Lift Station Maintenance, Gopher State One Call, GIS/CMMS consultant. Rentals: Building rent and equipment rent. Utility Service: Capital Equipment: Wireless lift station monitoring equipment ($8,000 and software) , extended jetter ($18,000) . Capital Improvements: Per CIP MCES Treatment Cost: Metro Council Environmental Services. Depreciation: Includes equipment and infrastructure. R5509BUD .001 CITY OF .PEE 10.7'11:11:01 Fiscal Period: 9 I 7 Budget Report Page - 1 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 07100 SEWER FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4100 SPECIAL ASSESSMENT 4110 SPECIAL ASSESSMENT PRINCIPAL 36,892- 4100 SPECIAL ASSESSMENT 36,892- 4200 LICENSES AND PERMITS 4250 PERMITS 4400 INTERGOVERNMENTAL 4410 FEDERAL GRANTS 4500 CHARGES FOR SERVICE 4720 SEWER CHARGES 4721 SEWER CHARGES 2,186,873- 2,229,920- 2,349,612- 1,465,412- 2,488,000- 2,488,000- 2,488,000- 2,488,000- 4723 METRO SAC CHARGES 13,136- 2,871- 10,720 102,607- 4725 CITY SAC CHARGES 438,300- 458,100- 188,550- 113,500- 200,000- 50,000- 50,000- 50,000- 4735 TRUNK CHARGE - SANITARY 365,131- 280,711- 638,611- 28,295- 200,000- 50,000- 50,000- 50,000- 4720 SEWER CHARGES 3,003,440- 2,971,601- 3,166,053- 1,709,814- 2,888,000- 2,588,000- 2,588,000- 2,588,000- 4750 REFUSE 4500 CHARGES FOR SERVICE 3,003,440- 2,971,601- 3,166,053- 1,709,814- 2,888,000- 2,588,000- 2,588,000- 2,588,000- 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 4833 INTEREST 311,802- 311,677- 686,190- 125,886- 300,000- 400,000- 400,000- 400,000- 4850 MISCELLANEOUS 1- 5,025- 4832 INVESTMENT INCOME 311,802- 311,677- 686,190- 130,911- 300,000- 400,000- 400,000- 400,000- 4830 MISCELLANEOUS 311,802- 311,677- 686,190- 130,911- 300,000- 400,000- 400,000- 400,000- 4960 PROCEEDS FROM DEBT ISSUED 4970 CAPITAL CONTRIBUTIONS 4971 CAPITAL CONTRIBUTIONS 3,399,873- 2,176,387- 1,762,782- 4970 CAPITAL CONTRIBUTIONS 3,399,873- 2,176,387- 1,762,782- 4001 REVENUES 6,715,115- 5,459,665- 5,615,025- 1,877,616- 3,188,000- 2,988,000- 2,988,000- 2,988,000- R5509BUD LOGIS001 CITY OF SHAKOPEE 10/16/200711 :11 :01 Fiscal Period: 9 / 7 Budget Report Page - 2 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 28,249 46,968 78.455 52,006 86,700 6003 WAGES FT REG 101,700 101,700 101,700 6005 OVERTIME-FT 234 1,792 2,122 1,279 3,000 3,000 3,000 3,000 6010 PREMIUM PAY 295 150 6015 WAGES- PARTTIMEITEMP 2,340 538 975 1,179 5,000 5,000 5,000 5,000 6002 WAGES 30,823 49,298 81,847 54,614 94,700 109,700 109,700 109,700 6100 BENEFITS 6122 PERA 1,688 2,692 4,838 3,330 5,920 6,610 6,610 6,610 6124 FICA 2,150 3,511 5,763 3,855 7,240 7,780 7,780 7,780 6135 HEALTH 6,531 11,742 14,940 7,680 16,000 14,700 14,700 14,700 6139 POST EMPLOYMENT HEALTH PLAN 176 349 510 318 700 700 700 700 6140 L1FEfL TD 177 259 391 265 600 600 600 600 6145 DENTAL 279 401 622 396 700 800 800 800 6170 WORKERS COMPENSATION 1,709 1,781 2,347 2,676 4,000 4,000 4,000 4,000 6100 BENEFITS 12,711 20,735 29.411 18,519 35,160 35,190 35,190 35,190 6001 WAGES & BENEFITS 43,534 70,033 111,258 73,133 129,860 144,890 144,890 144,890 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 1,203 8,193 23,526 16,900 25,000 30,000 30,000 30,000 6203 TOOLS 69 245 6210 OFFICE SUPPLIES 156 1,618 6215 MATERIALS 64 232 5,000 5,000 5,000 5,000 6222 MOTOR FUELS & LUBRICANTS 1,745 3,311 4,155 4,385 6,000 6,500 6,500 6,500 6240 EQUIPMENT MAINTENANCE 8,382 7,092 7,380 6,183 16,000 13,000 13,000 13,000 6201 SUPPLIES & SERVICES 11,330 18,731 35.463 29,318 52,000 54,500 54,500 54,500 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 2,147 2,061 146 5,000 5,000 5,000 5,000 6312 ENGINEERING CONSULTNTS 40,473. 5,855 18,063 137,532 120,000 80,000 80,000 80,000 6316 EQUIPMENT MAINTENANCE 700 3,196 2,139 800 10,000 10,000 10,000 6327 OTHER PROF SERVICES 28,828 65,970 111.490 38,321 85,000 85,000 85,000 85,000 6300 PROFESSIONAL SERVICES 10,945- 77,167 133,752 176,000 210,800 180,000 180,000 180,000 6330 COMMUNICATIONS . . . R5509BUD LOGIS001 CITY OF SHAKOPEE 10/16/200711 :11:01 Fiscal Period: 9/7 Budget Report Page - 2 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code 1 Description Amount Amount Amount Actual Budget Budget Budget Budget 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 28,249 46,968 78,455 52,006 86,700 6003 WAGES FT REG 101,700 101,700 101,700 6005 OVERTIME-FT 234 1,792 2,122 1,279 3,000 3,000 3,000 3,000 6010 PREMIUM PAY 295 150 6015 WAGES - PART TIMEfTEMP 2,340 538 975 1,179 5,000 5,000 5,000 5,000 6002 WAG.ES 30,823 49,298 81,847 54,614 94,700 109,700 109,700 109,700 6100 BENEFITS 6122 PERA 1,688 2,692 4,838 3,330 5,920 6,610 6,610 6,610 6124 FICA 2,150 3,511 5,763 3,855 7,240 7,780 7,780 7,780 6135 HEALTH 6,531 11,742 14,940 7,680 16,000 14,700 14,700 14,700 6139 POST EMPLOYMENT HEALTH PLAN 176 349 510 318 700 700 700 700 6140 L1FE/L TD 177 259 391 265 600 600 600 600 6145 DENTAL 279 401 622 396 700 800 800 800 6170 WORKERS COMPENSATION 1,709 1,781 2,347 2,676 4,000 4,000 4,000 4,000 6100 BENEFITS 12,711 20,735 29,411 18,519 35,160 35,190 35,190 35,190 6001 WAGES & BENEFITS 43,534 70,033 111,258 73,133 129,860 144,890 144,890 144,890 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 1,203 8,193 23,526 16,900 25,000 30,000 30,000 30,000 6203 TOOLS 69 245 6210 OFFICE SUPPLIES 156 1,618 6215 MATERIALS 64 232 5,000 5,000 5,000 5,000 6222 MOTOR FUELS & LUBRICANTS 1,745 3,311 4,155 4,385 6,000 6,500 6,500 6,500 6240 EQUIPMENT MAINTENANCE 8,382 7,092 7,380 6,183 16,000 13,000 13,000 13,000 6201 SUPPLIES & SERVICES 11,330 18,731 35,463 29,318 52,000 54,500 54,500 54,500 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 2,147 2,061 146 5,000 5,000 5,000 5,000 6312 ENGINEERING CONSULTNTS 40,473- 5,855 18,063 137,532 120,000 80,000 80,000 80,000 6316 EQUIPMENT MAINTENANCE 700 3,196 2,139 800 10,000 10,000 10,000 6327 OTHER PROF SERVICES 28,828 65,970 111,490 38,321 85,000 85,000 85,000 85,000 6300 PROFESSIONAL SERVICES 10,945- 77,167 133,752 176,000 210,800 180,000 180,000 180,000 6330 COMMUNICATIONS R5509BUD .001 CITY OF .PEE 10.711:11:01 Fiscal Period: 9 / 7 Budget Report Page - 3 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6332 POSTAGE 33 1.000 6334 TELEPHONE 538 1.187 1.078 1.000 1.500 1,500 1.500 6336 PRINTING/PUBLISHING 739 141 1,089 1.000 500 500 500 6330 COMMUNICATIONS 1.277 1.328 2.200 3.000 2.000 2,000 2,000 6350 INSURANCE 6352 LIABILITY 10,078 3,557 4.151 5,000 5.000 5,000 5.000 6356 AUTO 1.603 1.461 1,794 2,731 2,000 3,000 3,000 3,000 6350 INSURANCE 11,681 5,018 5,945 2.731 7.000 8,000 8,000 8.000 6360 UTILITY SERVICE 8.000 8,000 8.000 8,000 6362 ELECTRIC 953 6364 WATER 83 6365 GAS 2,044 6366 SEWER 3,573 23.251 50,848 48,125 46,000 60.000 60,000 60,000 6368 STORM 208 6369 CURRENT USE CHARGES 1.439.160 1,572.940 1,767.872 1.418,770 1.980,000 2,114.400 2,114.400 2,114.400 6360 UTILITY SERVICE 1.442,733 1.596.191 1,822,009 1.466.895 2,034.000 2,182.400 2,182.400 2,182.400 6400 RENTALS 6420 EQUIPMENT RENT 3.000 6,000 6.000 6,000 6425 EQUIPMENT RENT (IS FUND) 27,204 6430 BUILDING RENT (IS FUND) 9,660 7.479 12,000 12.000 12,000 12,000 6400 RENTALS 27,204 9,660 7.479 15.000 18,000 18,000 18.000 6470 DUESITRAININGITRAVEL 6472 CONFERENCElSCHOOLITRAINING 1,200 1,548 2.098 3.862 5,000 5,000 5,000 5,000 6475 TRAVEUSUBSISTENCE 24 6490 SUBSCRIPTIONS/PUBLICATIONS 70 6470 DUESITRAININGITRAVEL 1,200 1,548 2.098 3,956 5,000 5,000 5.000 5,000 6498 EXPENSE CHARGED BACK 20,800 9.000 32.479 6200 SUPPLIES AND SERVICES 1.504,002 1.708.933 2,042.733 1,688,579 2.326,800 2.449,900 2.449,900 2.449,900 6500 DEPRECIATION 6501 DEPRECIATION EXPENSE 6502 DEPRECIATION EXPENSE 461,930 559,332 602.904 700,000 750,000 750.000 750,000 6501 DEPRECIATION EXPENSE 461.930 559,332 602.904 700,000 750,000 750,000 750.000 6500 DEPRECIATION 461,930 559.332 602,904 700,000 750.000 750,000 750,000 R5509BUD LOGIS001 CITY OF SHAKOPEE 10/16/200711 :11 :01 Fiscal Period: 9 / 7 Budget Report Page - 4 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6600 MISCELLANEOUS 6610 AWARDS & DAMAGES 10,750 6600 MISCELLANEOUS 10,750 6700 CAP IT AL OUTLAY 6740 EQUIPMENT 138,000 26,000 26,000 26,000 6760 IMPROVEMENTS 29,339 516,708 6700 CAP IT AL OUTLAY 29,339 516,708 138,000 26,000 26,000 26,000 6800 DEBT SERVICE 6840 DEBT SERVICE INTEREST 6000 EXPENDITURES 2,009.466 2,349,048 2,786,235 2,278.421 3,294,660 3,370,790 3,370}90 3,370,790 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 8053 TRANSFERS OUT 159,694 25,000 25,000 25,000 25,000 8056 OPERATING TRANSFER/CAPITAL FD 65,356 1.427 1,175,525 8052 TRANSFERS OUT 225,049 1.427 1,175,525 25,000 25,000 25,000 25,000 8050 TOTAL TRANSFERS OUT 225,049 1.427 1,175,525 25,000 25,000 25,000 25,000 8100 GAIN/LOSS ON DISPOSAL OF ASSET 8101 PROCEEDS FROM SALE (GAIN/LOSS) ."-' 4000 REVENUES AND EXPENDITURES 4.480,599- 3,109,191- 1,653,266- 400,805 131,660 407,790 407,790 407,790 07100 SEWER FUND 4,480,599- 3,109,191- 1,653,266- 400,805 131,660 407,790 407,790 407,790 . . . R5509BUD LOGIS001 CITY OF SHAKOPEE 10/16/2007'11 :11 :01 Fiscal Period: 9 / 7 Budget Report Page - 4 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6600 MISCELLANEOUS 6610 AWARDS & DAMAGES 10,750 6600 MISCELLANEOUS 10,750 6700 CAPITAL OUTLAY 6740 EQUIPMENT 138,000 26,000 26,000 26,000 6760 IMPROVEMENTS 29,339 516,708 6700 CAPITAL OUTLAY 29,339 516,708 138,000 26,000 26,000 26,000 6800 DEBT SERVICE 6840 DEBT SERVICE INTEREST 6000 EXPENDITURES 2,009.466 2,349,048 2,786,235 2,278.421 3,294,660 3,370,790 3,370,790 3,370,790 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 8053 TRANSFERS OUT 159,694 25,000 25,000 25,000 25,000 8056 OPERATING TRANSFER/CAPITAL FD 65,356 1,427 1,175,525 8052 TRANSFERS OUT 225,049 1.427 1,175,525 25,000 25,000 25,000 25,000 8050 TOTAL TRANSFERS OUT 225,049 1.427 1,175,525 25,000 25,000 25,000 25,000 8100 GAIN/LOSS ON DISPOSAL OF ASSET 8101 PROCEEDS FROM SALE (GAIN/LOSS) 4000 REVENUES AND EXPENDITURES 4,480,599- 3,109,191- 1,653,266- 400,805 131,660 407,790 407,790 407,790 07100 SEWER FUND 4,480,599- 3,109,191- 1,653,266- 400,805 131,660 407,790 407,790 407,790 STORM DRAINAGE FUND 2008 BUDGET ACTIVITY: Activity in this enterprise fund reflects the operations of the Municipal Storm Drainage System. OBJECT DESCRIPTION: Description of lines items: Salaries: Share of Public Works staff/Engineering staff including GIS. Supplies and Services: Materials for maintaining/repairing storm sewer facilities, GIS/CMMS software and hardware, motor fuels. Professional Services: Engineering consultant to update storm water plans, storm water model, review of storm water utility policy and procedures and rate study, GIS/CMMS consultant service, Gopher State One Call, small maintenance projects. Rentals: Building Rental ($12,000) and equipment rental (Track Hoe $10,000). Utility Service: ($12,800) . Capital Equipment: Street Sweeper. Capital Improvements: Per CIP. Purchase of Right of Way Pond: $550,000 (MNDOT payment for TH 169 ponds) Depreciation: Includes equipment and infrastructure. R5509BUD .001 CITY OF .PEE 10.710:58:43 Fiscal Period: 9 / 7 Budget Report Page - 5 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 07300 STORM FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4010 PROPERTY TAX 4011 CURRENT PROPERTY TAX 156,309- 4010 PROPERTY TAX 156,309- 4005 TAXES 156,309- 4100 SPECIAL ASSESSMENT 4200 LICENSES AND PERMITS 4400 INTERGOVERNMENTAL 4450 STATE GRANTS & AIDS 4500 CHARGES FOR SERVICE 4670 PUBLIC WORKS 4680 MISC PUBLIC WORKS 195- 4670 PUBLIC WORKS 195- 4720 SEWER CHARGES 4740 STORM DRAINAGE 4745 STORM CHARGES 1,134,073- 1,097,835- 1,171,063- 710,241- 1,032,000- 1,032,000- 1,032,000- 1,032,000- 4746 TRUNK CHARGE - STORM 466,759- 793,401- 688,849- 172,544- 300,000- 50,000- 50,000- 50,000- 4740 STORM DRAINAGE 1,600,832- 1,891,235- 1,859,912- 882,785- 1,332,000- 1,082,000- 1,082,000- 1,082,000- 4500 CHARGES FOR SERVICE 1,600,832- 1,891,430- 1,859,912- 882,785- 1,332,000- 1,082,000- 1,082,000- 1,082,000- 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 4833 INTEREST 235,624- 237,145- 538,084- 100,842- 179,260- 350,000- 350,000- 350,000- 4850 MISCELLANEOUS 46,000- 0 4832 INVESTMENT INCOME 235,624- 283,145- 538,084. 100,842- 179,260- 350,000- 350,000- 350,000- 4830 MISCELLANEOUS 235,624- 283,145- 538,084- 100,842- 179,260- 350,000- 350,000- 350,000- 4960 PROCEEDS FROM DEBT ISSUED 4970 CAPITAL CONTRIBUTIONS R5509BUD LOGIS001 CITY OF SHAKOPEE 10/16/20071 0:58:43 Fiscal Period: 9 / 7 Budget Report Page - 6 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 4971 CAPITAL CONTRIBUTIONS 2,812,721- 3,587,434- 2,215,105- 4970 CAPITAL CONTRIBUTIONS 2,812,721- 3,587,434- 2,215,105- 4001 REVENUES 4,805,485- 5,762,009- 4,613,101- 983,627- 1,511,260- 1,432,000- 1,432,000- 1,432,000- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 99,014 115,364 104,653 109,741 111,700 6003 WAGES FT REG 126,700 126,700 126,700 6005 OVERTIME-FT 1,854 3,268 1,559 699 6,000 3,000 3,000 3,000 6010 PREMIUM PAY 225 240 6015 WAGES - PART TIMElTEMP 7,762 6,262 8,152 6,516 6,500 13,000 13,000 13,000 6002 WAGES 108,631 124,893 114,589 117,196 124,200 142,700 142,700 142,700 6100 BENEFITS 6122 PERA 5,692 6,557 6,382 6,908 7,760 8,240 8,240 8,240 6124 FICA 7,675 8,917 8,123 8,217 9,500 9,700 9,700 9,700 6135 HEALTH 16,993 17,405 14,336 14,132 19,000 18,150 18,150 18,150 6139 POST EMPLOYMENT HEALTH PLAN 783 728 623 685 800 1,000 1,000 1,000 6140 L1FE/L TD 496 530 468 537 600 800 800 800 6145 DENTAL 776 824 760 802 800 1,000 1,000 1,000 6170 WORKERS COMPENSATION 3,797 3,786 6,150 6,874 7,000 7,300 7,300 7,300 6100 BENEFITS 36,212 38,747 36,841 38,154 45,460 46,190 46,190 46,190 6001 WAGES & BENEFITS 144,843 163,640 151,431 155,350 169,660 188,890 188,890 188,890 6200 SUPPLIES AND SERVICES 6201 SUPP(iES & SERVICES 6202 OPERATING SUPPLIES 11,933 8,178 33,307 18,162 18,000 20,000 20,000 20,000 6203 TOOLS 245 6210 OFFICE SUPPLIES 156 1,618 6215 MATERIALS 1,547 13,667 1,089 18,245 12,000 20,000 20,000 20,000 6222 MOTOR FUELS & LUBRICANTS 2,931 6,195 6,968 6,891 8,500 10,000 10,000 10,000 6240 EQUIPMENT MAINTENANCE 18,065 14,834 31,797 27,641 30,000 6201 SUPPLIES & SERVICES 34,476 42,873 73,562 72,557 68,500 50,000 50,000 50,000 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 27 662 1.150 2,859 5,000 5,000 5,000 5,000 6312 ENGINEERING CONSULTNTS 31,064 65,273 140,915 36,777 75,000 75,000 75,000 75,000 6316 EQUIPMENT MAINTENANCE 69 59 148 40,000 40,000 40,000 . . . R5509BUD LOGIS001 CITY OF SHAKOPEE 10/16/20071 0:58:43 Fiscal Period: 9 1 7 Budget Report Page - 6 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code 1 Description Amount Amount Amount Actual Budget Budget Budget Budget 4971 CAPITAL CONTRIBUTIONS 2,812,721- 3,587,434- 2,215,105- 4970 CAPITAL CONTRIBUTIONS 2,812,721- 3,587,434- 2,215,105- 4001 REVENUES 4,805,485- 5,762,009- 4,613,101- 983,627- 1,511,260- 1,432,000- 1,432,000- 1,432,000- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 99,014 115,364 104,653 109,741 111,700 6003 WAGES FT REG 126,700 126,700 126,700 6005 OVERTIME-FT 1,854 3,268 1,559 699 6,000 3,000 3,000 3,000 6010 PREMIUM PAY 225 240 6015 WAGES - PART TIMErrEMP 7,762 6,262 8,152 6,516 6,500 13,000 13,000 13,000 6002 WAGES 108,631 124,893 114,589 117,196 124,200 142,700 142,700 142,700 6100 BENEFITS 6122 PERA 5,692 6,557 6,382 6,908 7,760 8,240 8,240 8,240 6124 FICA 7,675 8,917 8,123 8,217 9,500 9,700 9,700 9,700 6135 HEALTH 16,993 17,405 14,336 14,132 19,000 18,150 18,150 18,150 6139 POST EMPLOYMENT HEALTH PLAN 783 728 623 685 800 1,000 1,000 1,000 6140 L1FE/L TD 496 530 468 537 600 800 800 800 6145 DENTAL 776 824 760 802 800 1,000 1,000 1,000 6170 WORKERS COMPENSATION 3,797 3,786 6,150 6,874 7,000 7,300 7,300 7,300 6100 BENEFITS 36,212 38,747 36,841 38,154 45,460 46,190 46,190 46,190 6001 WAGES & BENEFITS 144,843 163,640 151,431 155,350 169,660 188,890 188,890 188,890 6200 SUPPLIES AND SERVICES 6201 suppLIeS & SERVICES 6202 OPERATING SUPPLIES 11,933 8,178 33,307 18,162 18,000 20,000 20,000 20,000 6203 TOOLS 245 6210 OFFICE SUPPLIES 156 1,618 6215 MATERIALS 1,547 13,667 1,089 18,245 12,000 20,000 20,000 20,000 6222 MOTOR FUELS & LUBRICANTS 2,931 6,195 6,968 6,891 8,500 10,000 10,000 10,000 6240 EQUIPMENT MAINTENANCE 18,065 14,834 31,797 27,641 30,000 6201 SUPPLIES & SERVICES 34,476 42,873 73,562 72,557 68,500 50,000 50,000 50,000 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 27 662 1,150 2,859 5,000 5,000 5,000 5,000 6312 ENGINEERING CONSULTNTS 31,064 65,273 140,915 36,777 75,000 75,000 75,000 75,000 6316 EQUIPMENT MAINTENANCE 69 59 148 40,000 40,000 40,000 R5509BUD .001 CITY OF .PEE 10/.71 0:58:43 Fiscal Period: 9 / 7 Budget Report Page - 7 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6327 OTHER PROF SERVICES 42,043 37,192 18,086 12,729 40,000 60,000 60,000 60,000 6300 PROFESSIONAL SERVICES 73,134 103,195 160,211 52,513 120,000 180,000 180,000 180,000 6330 COMMUNICATIONS 6332 POSTAGE 1,000 6334 TELEPHONE 100 382 1,619 698 1,000 1,000 1,000 1,000 6336 PRINTING/PUBLISHING 185 534 736 243 2,000 1,000 1,000 1,000 6330 COMMUNICATIONS 285 915 2,355 941 4,000 2,000 2,000 2,000 6350 INSURANCE 6352 LIABILITY 2,030 1,797 4,482 6,000 6,000 6,000 6,000 6354 PROPERTY 1,000 806 692 513 800 800 800 6356 AUTO 434 1,283 834 887 2,000 2,000 2,000 2,000 6350 INSURANCE 3,464 3,886 6,008 1,400 8,000 8,800 8,800 8,800 6360 UTILITY SERVICE 433 12,800 12,800 12,800 12,800 6362 ELECTRIC 309 719 1,649 546 6364 WATER 83 6365 "GAS 2,044 6366 SEWER 78 6367 REFUSE 162 6368 STORM 208 6360 UTILITY SERVICE 904 719 4,062 546 12,800 12,800 12,800 12,800 6400 RENTALS 6420 EQUIPMENT RENT 23,077 21,697 9,095 9,276 5,000 10,000 10,000 10,000 6425 EQUIPMENT RENT (IS FUND) 40,248 6430 BUILDING RENT (IS FUND) 9,660 7,479 12,000 12,000 12,000 12,000 6400 RENTALS 63,325 21,697 18,755 16,755 17,000 22,000 22,000 22,000 6470 DUESrrRAININGrrRAVEL 6472 CONFERENCE/SCHOOLrrRAINING 1,664 3,000 3,000 3,000 3,000 6475 TRAVEUSUBSISTENCE 24 6480 DUES 895 20 6490 SUBSCRIPTIONS/PUBLlCATIONS 70 6470 DUESrrRAININGrrRAVEL 895 1,778 3,000 3,000 3,000 3,000 6498 EXPENSE CHARGED BACK 28,200 18,000 23,679 6200 SUPPLIES AND SERVICES 203,788 191,286 289,526 146,489 233,300 278,600 278,600 278,600 R5509BUD LOGIS001 CITY OF SHAKOPEE 10/16/20071 0:58:43 Fiscal Period: 9 / 7 Budget Report Page - 8 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6500 DEPRECIATION 6501 DEPRECIATION EXPENSE 6502 DEPRECIATION EXPENSE 578,131 636,071 723,721 750,000 750,000 750,000 750,000 6501 DEPRECIATION EXPENSE 578,131 636,071 723,721 750,000 750,000 750,000 750,000 6500 DEPRECIATION 578,131 636,071 723,721 750,000 750,000 750,000 750,000 6600 MISCELLANEOUS 6620 PROPERTY TAX/SPECIAL ASSESS 325 302 285 300 300 300 300 6600 MISCELLANEOUS 325 302 285 300 300 300 300 6700 CAPITAL OUTLAY 6740 EQUIPMENT 85,000 6760 IMPROVEMENTS 357 A02 5,000- 550,000 550,000 550,000 550,000 6700 CAPITAL OUTLAY 357A02 5,000- 635,000 550,000 550,000 550,000 6800 DEBT SERVICE 6802 DEBT SERVICE PRINCIPAL 6840 DE8T SERVICE INTEREST 6850 DEBT SERVICE INTEREST 14,380 7,801 605 6860 FISCAL AGENT FEES 375 750 375 6840 DEBT SERVICE INTEREST 14,755 8,551 980 6800 DEBT SERVICE 14,755 8,551 980 6000 EXPENDitURES 941,841 999,849 1,523,344.. 296,839 1,788,260 1,767,790 1,767,790 1,767,790 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 159,694- 8010 OPERATING TRANSFERS IN 159,694- 8005 TOTAL TRANSFERS IN 159,694- 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 8053 TRANSFERS OUT 156,309 48,040 48,040 48,040 48,040 8056 OPERATING TRANSFER/CAPITAL FD 672,755 644 566,664 8052 TRANSFERS OUT 829,064 644 566,664 48,040 48,040 48,040 48,040. . . R55098UD LOGIS001 CITY OF SHAKOPEE 10/16/20071 0:58:43 Fiscal Period: Budget Report Page - 8 9 / 7 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code I Description Amount Amount Amount Actual Budget l3udget Budget Budget 6500 DEPRECIATION 6501 DEPRECIATION EXPENSE 6502 DEPRECIATION EXPENSE 578,131 636,071 723,721 750,000 750,000 750,000 750,000 6501 DEPRECIATION EXPENSE 578,131 636,071 723,721 750,000 750,000 750,000 750,000 6500 DEPRECIATION 578,131 636,071 723,721 750,000 750,000 750,000 750,000 6600 MISCELLANEOUS 6620 PROPERTY TAX/SPECIAL ASSESS 325 302 285 300 300 300 300 6600 MISCELLANEOUS 325 302 285 300 300 300 300 6700 CAPITAL OUTLAY 6740 EQUIPMENT 85,000 6760 IMPROVEMENTS 357,402 5,000- 550,000 550,000 550,000 550,000 6700 CAPITAL OUTLAY 357,402 5,000- 635,000 550,000 550,000 550,000 6800 DEBT SERVICE 6802 DEBT SERVICE PRINCIPAL 6840 DEBT SERVICE INTEREST 6850 DEBT SERVICE INTEREST 14,380 7,801 605 6860 FISCAL AGENT FEES 375 750 375 6840 DEBT SERVICE INTEREST 14,755 8,551 980 6800 DEBT SERVICE 14,755 8,551 980 6000 EXPENDITURES 941,841 999,849 1,523,344 296,839 1,788,260 1,767,790 1,767,790 1,767,790 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 159,694- 8010 OPERATING TRANSFERS IN 159,694- 8005 TOTAL TRANSFERS IN 159,694- 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 8053 TRANSFERS OUT 156,309 48,040 48,040 48,040 48,040 8056 OPERATING TRANSFER/CAPITAL FD 672,755 644 566,664 8052 TRANSFERS OUT 829,064 644 566,664 48,040 48,040 48,040 48,040 R5509BUD .001 CITY OF .PEE 10.710:58:43 Fiscal Period: 9 I 7 Budget Report Page - 9 Level Of Rollup 7 2004 2005 2006 9/30/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code I Description Amount Amount Amount Actual Budget Budget Budget Budget 8050 TOTAL TRANSFERS OUT 829,064 644 566,664 48,040 48,040 48,040 48,040 8100 GAINILOSS ON DISPOSAL OF ASSET 8101 PROCEEDS FROM SALE (GAIN/LOSS) 4000 REVENUES AND EXPENDITURES 3,194,274- 4,761,516- 2,523,092- 686,788- 325,040 383,830 383,830 383,830 07300 STORM FUND 3,194,274- 4,761,516- 2,523,092- 686,788- 325,040 383,830 383,830 383,830 2008-2012 CIP Working Summary - 10.26.07 ..............................................................................................l........................................I~.~.~........................................ ........!;1!.!!.!!!~.t~....... ...f..~!}!!!!}ii1.l!.Q.~!~!... .............~.9.Q!.............. ..........~.9..9.!!......................~Q9..~.......... ...........~.9.~.9........... ..........~9..1..1........... ............~.9.:1.~............ ...........~.Q.'!).!!!~.~.t~............ ......................................................~[~ff.!??~.M?.~!!?.~f.l;....................g9.m.'!'.~r.9j~!!.8~~!9.~f.l;!!~!...................................................................................................................................................................................................................................................................................................9.Q~.I?!=:.p.~.f.~Y.i,~YY..!:ID.9.~rway .I?~..!~.y.y...........................................................................t.......,...........................................................................................................................,................................................................................................................................................................................................................................................................................... [D~:~i~~~~~:~~:~~~=-:~:~~::~:~::::::::::::::::~~:::=-:::::~rSE:~~~::::::~:;~::::::~~::::::~~[~~~~~;~':c~~:~' Total Revenue/Credits 2364375 1,191900 1,040900 1,251,400 990,000 3,630,500 :~i:a.~i~'.:=:~~:s.::~::~:~~::~o.~:~~~:.::::::::::.::::::tg;~~~~~t:~c.;~~~~~;.~!:~~::::::::::::::::::::::::::::..::::::::::::::::::::::::~i~~:::~~~:~:.~~;;:::::::::::::::::::::::::::::::::;:~;;::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::.:::::~~~:::::::::::::::::::::::::::::.::::::::'::::::::':::::::::::::::::::::::::::::::::::~~o.j:~~:~:".~:=~~::::::::: Valley Creek Crossing Park Design and Construction ................................... By Developer Project underway Construction Administration 3.075 Park Reserve 3,075 .:!?~~6::~~~~:t.ii!):c~0:i~ii.i::::::::::::::::::::::::::::::::::::::::::. Q~~[iii~r.:~::9.9.r.:~!f.!!.~j)9.r.::::::::::::::::::::::::::::::::::::::: ::::::::::::::::::i~~:QQg:: :E~i:ii:B~~~:iY.~:::::::::::: ::::::::::::::::j:!j~;9.9.9.::: ::::::::::::::::::::::::::::::. ::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::. :::::::::::::::::::::::::::::::::: 'Iayments. Archery Range Relocation Design and Construction ....................~.q,Q.qQ.. Grants 20,000 DonationslContrib ............................................................................................. 9g.~~~r!!."~l2.~..(r.gi!:!!.'!.@.Y.)"....................................... :::::::::::::::::::::::::::~:::::: .E~.~.!3.~~.~.~.~............................................... ............................... ............................... ............................... ............................... .................................. ...-..lil>ayments. Off.Leash Dog Area Design and Development ....................~.1.,Q.qQ.. Park Reserve 24,000 .................................,............................................................. p..~~.!g!}.i!:~.!!..p.~y.~!QP..m~!}L.................................. ....................~.q,Q.qQ.. .!?.Q!}!1~!Q.~~!.9.2~.!~.~... ................................... ..............~Q,Q9,Q... ............................... ............................... ............................... .................................. ............................................... Lions Park Improvements Ice Rink ..................!.~.?,~.qQ.. Park Reserve 167,500 ~~.~.I.\~,(.i!:~.!!..I~!}~.!~..f.i!:9!.\\Y.................,...........,...... ..................?~.?,Q.qQ.. .P..2~.~.\!2.~~!.9.Q~.!!:\~... ..................................................?~,Q9,Q.. ...............,............... ............................... ..............?Q,Q9,Q.................!!9,Q..,Q.9.Q.. ............................................... Ei!:~g~.Y.~.!2J?!!!!!.~.!.~D.~U!.~!!.q!!}g........................ ...............1.,Q~.?,~.qQ.. .Ei!:r.~.!3.~~.~.~.~............ ................!..??.,.9.9,Q... ...........:?!.i?,!!9,Q... ............................... .............................. ............................... .................................. .E?r.~..iQ..~.9.Q!..,.!?~.U.q!.~g. in 2008. p..~~.!g!}.i!:!}!!..9.Q~.~!.(!!g!!.Q!}...............................,.....................1.,f.~.!.,~.?Q...E~.~.!3.~~.~.~.~.......................................................................................1...~~~.,i??.9................................................................................................................................................. !!}~~!1!!..E!1.~..~!l:lQi!:l:l~..................................,.............. ....................!..q,Q.qQ.. .Ei!:~.!3.~1!.~.~.~..........................,..................... ..............:?9.,Q9,Q... ..............~!!,9,Q.9.................................. ............................ ................................................................................ Land Acquisition and Assessments 549,500 Park Reserve 549,500 includes potential purchase price for Parcel 7 MNDOT & Active Park Development ..................945:2'00.. Park Reserve 945,200 Tahpah .Park"imj)rovemeiits.................... . ..........ribgk7~b~f~.rOje.ct............................................... . ::::::::::::::::::::~~:~~~:: .~{ir'~ese'lVe"'"'''''' ..................66:00.0... ............................... .............................. ......,........ .............. ............................... .................~,Q...9..9.Q.... ...;....,,,.'l''''Il;;liiih\llil>ayments , Ball Field and lighting ...............3'i.ii;iioo.. Park Reserve 96,500 218,000' H'" Lighting ..................200:000.. Donations/Contrib 200,000 Ball Field ..................100:000. Grants 100,000 'Quarry'Lake' Pa.ii{................................................. ..... CleanuplDesignlConstruction ::::::::::::::::::~i!:;QQg:: Park Reserve 289,500 ..............24{.500... Grant funding may expire if not used. Construction 421,000 Grants 210,500 210,500 Construction ..................200:0.00.. Donations 100,000 100,000 :~~~~;~~~~~~~e~~:~~~::::::::::::::::::::::::::::::::::::: ~~~~iif~~~~~9.gi~f~j~~~;::::::::::::::::::::::::::::::: ::::::::::::::::::1~~:~~~:: :~~~~:l~~r::::::::: ::::::::::::::::;~~:~~~::: ::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::: :::::::::A19.:9.9.9.::: :::::::::::::::::::::::::::::::::: .......................:;~;;~;~~~:;ayments Phase 1: Park Oevelopment ::::::::::::::::::::::::::::::::::: Assessments Fillmore Str~el';;'iid'Alley Improvements Phase 1: Park Development Donations/Contrib Reimbursement from others for work Phase 2: Bank Stabilization ::::::::::::::::::~g:Q:g:Qg:: Park Reserve 500,000 Added Park Reserve funding per CouncU dire Phase 2 Bank Stabilization 1,900,000 Grants 1,900,000 ..1.7Ih.Aven.ue.Sports.compi.ex.............................. BuiiCiiiig'an.,i"F'iiiai.siie'Wo.ii{............'....'............ :::::::::::::::::3Q;!i.Q!i.: .Park.RaselVe............ ...................5.0:'600... ..................,............ ............................... ............................... ............................... .................................. ,:i!j!1j)lll~!~~i:~~~!ll\!m~]payments. Fietd Lighting 230,000 Park Reserve 230.000 ...............................................................................................f.!~.!!!..~!9~.!!~.g................................................................................!Q.q,Q.qQ...P..2~.~.\!Q.~~!.9..2~.!~.~..................................................................................................................................................................................!.9.9....9.QQ................................................ ..B!y.~.~.i.q~.!!!.~f.(~.p..?r.!!..(gi!:~.\.p..~i!:~..!,,!1.~~.L........ P..~~.lg.~..?!}!!..9.Q~.~!.(!!.!:!!.Q~.........................................................~~.?,!.,?9.. .E~.~.!3.~~.~.~.~............................................................................. ............................... ............................... ............................... ..............9.~.:?,.!.!!9.................................................. 11E~~~!~~I~~:~-~~:~~lr~Ii:~~~~~~:~:~~_)~]~~~~~~~~~~)))~~~~I~~)~-))~)]]]]~:~ .B!y.~.~.i.~:,'!..E~.~.Ei!:~!~.g..~9.!..................................... Ei!:r.!!!~.g..~9.!..9.Q~.~!.(!!.!:!!.Q~................m.................... ....................?~,?.29.. .E~I!s.!3~~.~.~.~................................................ .............................................................. ............................... ............................... .................!..?...!..?.9... ............................................... ..~~.~~(Qp...E~,~..!?~.Y.~.!2.e!!!~.~!......................,........... P..~~.i.g!.!.i!:~.9,.9..Q~.~!.(!!-")!.Q!}...................................... ...............1.,f.~.q,Q.2Q.. .E~.~.B.~~.~.~.~............ ................................... .............................. ............................... .............................. ............................... ...........!.,i??,Q,g,9.Q.. ............................................... .9.Q!!!!!!~!.!!~Y..Ei!:.~..~P..2r.!~..9.Q!!!p..i.~~.............,........ P..~~.lg.!.!..~~.!!..9.Q~.~!.(!!.s:!!Q~..................,.........,.......... ...........,...1.,f.~.q,Q.qQ.. .Ei!:~.!3.~~.~.~.~............ ................................... .............................. ............................... ............................... .............................. ...........!.,i??.9....9..9.Q.. ............................................... High School Field Lighting Field Lighting 340,000 Park Reserve 340,000 ...............................................................................................f.!~.!9..~!9t!!!~.g......................................,..........................................!.Q.2,Q.q9...P..Q~.!1.\l2.~~!.9..Q~.m.~..................................................................................................................................................................................!.,Q.9.,.9.QQ................................................. Small Improvement Projects Construction 100.000 Park Reserve 20,000 20,000 20,000 20,000 20,000 2007 toward off-leash dog area. Interfund Loan Payback Financing, 5 year payback 1,353,000 Park Reserve 259,000 259.000 259,000 259,000 259,000 10-year payoff Total Expenditures 17,366,525 874,000 2,293,250 879,000 769,000 11.290,200 I I I I I I Net Revenues (Expenditures) 317.900 (1,252,350) 372,400 221,000 (7,659.700) Cash Balance 9/30/2007 ~ 12/31 Ending Park Reserve Balance I I I "..... 11/1/2007