Loading...
HomeMy WebLinkAboutAgenda Packets - 2002/10/28CITY OF MOUNDS VIEW CITY COUNCIL MEETING AGENDA Monday, October 28, 2002 7:00 p.m. 1. CALL TO ORDER 2. ROLL CALL: Sonterre, Quick, Marty, Stigney, Thomas 3. APPROVAL OF AGENDA 4. PUBLIC INPUT: Citizens may speak to issues not on tonight’s agenda. Before speaking, please give your full name and address for the minutes. Also, please limit your comments to three minutes. 5. JUST AND CORRECT CLAIMS 6. CONSENT AGENDA a. Licenses for Approval b. Resolution 5868, Approving a Contract Award for Weather Service for the 2002-2003 Winter Season c. Resolution 5869, Authorizing the execution of the State of Minnesota Grant Agreement for the fiscal year 2003 Oak Wilt Grant d. Resolution 5863, a Resolution Approving the Development Agreement for MoundsView Business Properties, LLC 7. COUNCIL BUSINESS 7:05 pm A. Public Hearing and Consideration of Resolution 5858, a Resolution Approving a Conditional Use Permit for Automotive Repair at 2135 Program Avenue, Site of the Wash-Me Car Wash – Atkinson B. Consideration of Resolution 5867, a Resolution Ordering the Abatement of Hazardous Conditions Existing at 2240 Kingsway Lane – Anderson C. Second Reading and Adoption of Ordinance 705, an Ordinance Amending Title 100, Chapter 105 of the Mounds View Municipal Code by Amending Section 105.03 as to the Compensation of the Mayor and Councilmembers in the City of Mounds View -- Miller Roll Call Vote: Stigney Marty Quick Thomas Sonterre City Council Agenda October 28, 2002 Page 2 D. Second Reading and Adoption of Ordinance 706, an Ordinance Amending Title 400, Chapter 401 of the Mounds View Municipal Code by Amending Section 401.02 Subdivision 1 as to the Membership of the Planning and Zoning Commission – Miller Roll Call Vote: Marty Quick Thomas Stigney Sonterre E. Second Reading and Adoption of Ordinance 707, an Ordinance Amending Title 400, Chapter 405 of the Mounds View Municipal Code by Amending Section 405.02 Subdivision 1 as to the Appointment of Members to the Parks and Recreation Commission – Miller Roll Call Vote: Quick Thomas Stigney Marty Sonterre F. Finance Department Quarterly Report G. 2003 Street Improvement Project - Resolution No. 5870, Authorizing the preparation of a Preliminary Feasibility Report and Consultant Selection – Lee H. Water Tower Rehabilitation Project – Resolution No. 5871, Approve of the Preliminary Feasibility Report, Waive Public Improvement Hearing, Order the Project, Approve execution of a supplemental letter of agreement with Short Elliott Hendrickson Inc., Authorize the preparation of Plans and Specifications – Lee I. 2002 Well Rehabilitation Project – Resolution No. 5872, Waive Public Improvement Hearing, Order the Project, Authorize the preparation of Plans and Specifications – Lee J. Resolution 5880, Purchase of Used Mini-Pumper – Nyle Zikmund K. Condsideration of Innovative Images, LLC/Mounds View Community Center Banquet Facility Proposal to Dismiss all Claims Against the City of Mounds View—Scott Riggs (Oral Report) 8. SPECIAL ORDER OF BUSINESS A. Resolution 5866 Recognizing Dan Coughlin for Service on the Park and Recreation Commission B. Resolution 5865, A Resolution of Appreciation to Mark Pothen for Service on the Park and Recreation Commission C. Resolution 5864 Appointing a Chair and Vice Chair for the Park and Recreation Commission City Council Agenda October 28, 2002 Page 3 9. REPORTS 10. APPROVAL OF MINUTES A. October 14, 2002 City Council Minutes. 11. CLOSED SESSION A. Labor Negotiations B. Pending Litigation 12. Next Council Work Session: November 4, 2002 Next Council Meeting: November 12, 2002 13. ADJOURNMENT Item No. 06A Type of Business: CA WK: Work Session; PH: Public Hearing; CA: Consent Agenda; CB: Council Business City of Mounds View Staff Report To: Mayor and City Council From: Barb Benesch Item Title/Subject: CONTRACTOR LICENSES FOR APPROVAL Meeting Date: October 28, 2002 Please consider the following contractor licenses for approval. All contractor licenses will expire on December 31, 2002. All applicants have submitted appropriate fees and proof of insurance. All licenses are renewals unless noted “new” following the company name. Those companies with “new” after the company name include applicants that have never been licensed with the City or they may have been licensed with the City in the past, but were not licensed in 2001. Those companies with a renewal license were licensed, at a minimum, in the year 2001. GENERAL (COMMERCIAL) KVA Engineering Inc. – New HVAC Faircon Service Co. – New Staff Recommendation: Approve license applications as requested. Item No. 6B Type of Business: CA WK: Work Session; PH: Public Hearing; CA: Consent Agenda; CB: Council Business City of Mounds View Staff Report To: Honorable Mayor and City Council From: Greg Lee, Director of Public Works Item Title/Subject: Resolution No. 5868 Approving a Contract Award for Weather Service for the 2002 – 2003 Winter Season Meeting Date: October 28, 2002 Background: Annually, the City budgets for funds to provide weather service, which assists the City in making decisions pertaining to weather related activities. Specifically, this pertains to activities related to snow plowing and removal activities. Discussion: Having winter storm information is critical for proper maintenance of city streets. Since 1996, the City has contracted with Great Lakes Weather Services to provide the City with weather related services to assist the Public Works Department in making decisions as to how to best maintain the drivability of City streets during and following a snow or ice event. These decisions include: the appropriate maintenance strategy to apply, the proper equipment to deploy, and when to deploy it. Two companies that provide the necessary weather service were contacted to receive bids for the aforementioned service. Details on service and fees follow: Great Lakes Weather Services - $502 (if submitted by November 1st) for the 2002 – 2003 winter season Meteorlogix - $89/month for a minimum of 36 months - $3204 contract amount Great Lakes Weather Service contract begins with the first storm of the year and terminates with the last. Meteorlogix is a three-year minimum contract. Great Lakes provides warnings in the form of a telephone call two hours prior to a storm event. Meteorlogix provides up-to-date satellite images sent via computer. Meteorlogix also provides many other year-round weather data parameters such as wind direction and speed (possibly useful for summer pesticide applications). As previously mentioned, the City has used Great Lakes Weather Service since 1996 with great satisfaction. Staff believes that the services provided by Meteorlogix are in excess of what is actually needed by the City and the benefit does not justify the cost. Staff is therefore recommending that Council award a contract to Great Lakes Weather Service. The 2002 adopted budget has $800.00 in funds allocated for professional services in the Snow and Ice Department of the General Fund (Account No. 100- 4472-3030). Recommendation: Staff recommends that the City Council approve a contract with Great Lakes Weather Service in the estimated amount of $502 to provide the City with weather related services for the 2002-2003 winter season. Respectfully Submitted, Greg Lee, Director of Public Works RESOLUTION NO. 5868 APPROVING THE CONTRACT AWARD FOR WEATHER SERVICE CITY OF MOUNDS VIEW COUNTY OF RAMSEY STATE OF MINNESOTA WHEREAS, the City annually budgets for funds to provide weather service, which assists the City in making decisions pertaining to weather related activities; and WHEREAS, having winter storm information is critical for proper maintenance of city streets; and WHEREAS, two companies that provide the necessary weather service were contacted to receive bids; and WHEREAS, Great Lakes Weather Services submitted a favorable bid in the amount $502 for the 2002 – 2003 winter season; and WHEREAS, the City has used Great Lakes Weather Service since 1996 with great satisfaction; and WHEREAS, the 2002 adopted budget has $800 in funds allocated to weather service reports in the General Fund (Account No. 100-4472-3030). NOW, THEREFORE BE IT RESOLVED, THAT the Mounds View City Council does hereby approve a contract with Great Lakes Weather Service in the estimated amount of $502 to provide the City with weather related services for the 2002-2003 winter season. Adopted this 28th day of October 2002. ________________________________ Richard Sonterre, Mayor ATTEST: ________________________________ Kathleen F. Miller, City Administrator Motion by: Second: Sonterre: Stigney: Quick: Marty: Thomas: M:\MasterFiles\1999 thru 2010\2002\City Council\Council Packets\10-28-02\Item 07C 2nd Rdg & Adopt of Ordinance 705, Compensation of the Mayor and Councilmembers.doc Item No.7C Type of Business: CA WK: Work Session; PH: Public Hearing; CA: Consent Agenda; CB: Council Business City of Mounds View Staff Report To: Honorable Mayor and City Council From: Kathleen Miller, City Administrator Item Title/Subject: Second Reading and Adoption of Ordinance705, an Ordinance Amending Title 100, Chapter 105 of the Mounds View City Code by Amending Section 105.03 as to the Compensation of the Mayor and Councilmembers of Mounds View Date of Report: October 28, 2002 Background At the October 7, 2002 Work Session Councilmember Roger Stigney suggested that staff draft a resolution to increase the salaries for Mayor and City Council. After reviewing the City’s Charter and Municipal Code staff found that a revision to the City’s Code is required. Specifically, the City’s Charter authorizes that the “Mayor and Councilmembers shall receive compensation as is fixed by the Council in accordance with state law.” The City’s Code defines the level of compensation for the Mayor and Councilmembers as “fixed at five thousand one hundred dollars” and ‘four thousand five hundred dollars” respectively per year. The Mounds View City Council’s last salary increase was adopted July 26, 1993. Councilmember Stigney suggested that staff research the increase staff had received since the Council’s last increase. The finance director has put together a Summary of Employee Salary or Wage Increases for the years 1994 through 2002; that information was presented to the Council at the October 14, 2002 Council Meeting. The Association of Metropolitan Municipalities salary survey also was reviewed and revealed that 2002 average salary for elected officials was $6,255 for Mayors and $5,033 for Councilmembers. The attached Ordinance No. 705 Proposes an Amendment to the Mounds View City Code by Amending Chapter 105.03, Subdivisions 1 and 2. This ordinance was reviewed and amended by the City Council at the October 14, 2002 City Council Meeting. The attached ordinance includes those changes, specifically increasing the Mayor and Councilmembers’ annual salary by $1,200.00 or $6,300.00 annually for the Mayor and $5,700.00 annually for Councilmembers. This is the second reading of the proposed ordinance and assuming the Council adopts it this evening the Ordinance will be published in the Focus News on October 31, 2002 and will take effect on January 1, 2003. Recommendation: M:\MasterFiles\1999 thru 2010\2002\City Council\Council Packets\10-28-02\Item 07C 2nd Rdg & Adopt of Ordinance 705, Compensation of the Mayor and Councilmembers.doc Motion to adopt Ordinance No. 705, an Ordinance Amending Title 100, Chapter 105 of the Mounds View Municipal code by Amending Section 105.03 as to the Compensation of the Mayor and Councilmembers in the City of Mounds View. Respectfully Submitted, ___________________________ Kathleen F. Miller City Administrator M:\MasterFiles\1999 thru 2010\2002\City Council\Council Packets\10-28-02\Item 07C 2nd Rdg & Adopt of Ordinance 705, Compensation of the Mayor and Councilmembers.doc ORDINANCE NO. 705 CITY OF MOUNDS VIEW COUNTY OF RAMSEY STATE OF MINNESOTA AN ORDINANCE AMENDING TITLE 100, CHAPTER 105 OF THE MOUNDS VIEW MUNICIPAL CODE BY AMENDING SECTION 105.03 AS TO THE COMPENSATION OF THE MAYOR AND COUNCILMEMBERS IN THE CITY OF MOUNDS VIEW THE CITY OF MOUNDS VIEW ORDAINS: SECTION 1. Section 105.03 of the Mounds View Municipal Code relating to the compensation of the mayor and councilmembers of the city of Mounds View is hereby amended by the addition of the bold and double underlined language and the deletion of the bold and stricken language as follows: 105.03: COMPENSATION Subd. 1. Mayor's Compensation: The salary of the Mayor is fixed at five thousand one hundred six thousand three hundred dollars ($5,100.00 6,300.00) per year. Subd. 2. Councilmembers' Salaries: The salary of the Councilmembers is fixed at four thousand five hundred five thousand seven hundred dollars ($4,500.00 5,700.00) per year. Subd. 3. Method Of Payment: Said compensation shall be paid monthly. SECTION 2. This ordinance shall take effect January 1, 2003 after its publication. Read by the City Council of the City of Mounds View on this 14th day of _October, 2002. Read and passed by the City Council of the City of Mounds View this 28th day of November, 2002. _____________________________________ ATTEST: Rich Sonterre, Mayor (SEAL) _____________________________________ Kathleen Miller, Clerk-Administrator APPROVED AS TO FORM: _________________________ City Attorney M:\MasterFiles\1999 thru 2010\2002\City Council\Council Packets\10-28-02\Item 07D 2nd Rdg & Adoption of Ordinance 706, Ordinance Amending Section 401.02 subd. 1 as to the Membership of the Planning and Zoning Commission.doc Item No.7D Type of Business: CA WK: Work Session; PH: Public Hearing; CA: Consent Agenda; CB: Council Business City of Mounds View Staff Report To: Honorable Mayor and City Council From: Kathleen Miller, City Administrator Item Title/Subject: Second Reading and Adoption of Ordinance706, an Ordinance Amending Title 100, Chapter 401 of the Mounds View City Code by Amending Section 401.02, Subdivision 1 as to the Membership of the Planning and Zoning Commission Date of Report: October 28, 2002 Background At the September 3, 2002 Work Session the City Council directed staff to amend the Municipal Code to reflect a reduction in the number of members on the Planning and Zoning Commission from nine to seven. The Ordinance Proposing an Amendment to the Mounds View City Code by Amending Title 100, Chapter 401 of the Mounds View Municipal Code by Amending Section 401.02, Subdivision 1 as to the Membership of the Planning and Zoning Commission was reviewed by the City Council at the October 14, 2002 City Council Meeting. Ordinance No. 706 is attached for the second reading, if adopted this ordinance will be published in the Focus News and will take effect 30 days after publication. Respectfully Submitted, ___________________________ Kathleen F. Miller City Administrator M:\MasterFiles\1999 thru 2010\2002\City Council\Council Packets\10-28-02\Item 07D 2nd Rdg & Adoption of Ordinance 706, Ordinance Amending Section 401.02 subd. 1 as to the Membership of the Planning and Zoning Commission.doc ORDINANCE NO. 706 CITY OF MOUNDS VIEW COUNTY OF RAMSEY STATE OF MINNESOTA AN ORDINANCE AMENDING TITLE 400, CHAPTER 401 OF THE MOUNDS VIEW MUNICIPAL CODE BY AMENDING SECTION 401.02, SUBD. 1 AS TO MEMBERSHIP OF THE PLANNING AND ZONING COMMISSION THE CITY OF MOUNDS VIEW ORDAINS: SECTION 1. Section 401.02, Subd. 1 of the Mounds View Municipal Code relating to membership of the Planning and Zoning Commission is hereby amended by the addition of the bold and double underlined language and the deletion of the bold and stricken language as follows: 401.02: MEMBERSHIP; TERMS; OATH; COMPENSATION: Subd. 1. Membership; Terms: The Planning and Zoning Commission shall consist of nine (9)seven (7) members from the resident population of Mounds View, other than persons elected to a public body, to be appointed by the Mayor with approval of the City Council, from applications submitted. The appointees shall have three (3) year staggered terms; at least two (2) of these terms, but not more than three (3) terms, shall expire each year on December 31. Based upon the recommendation of the Planning and Zoning Commission, the Mayor, with approval of the City Council, shall appoint a chairperson. SECTION 2. This ordinance is effective 30 days after its publication. Read by the City Council of the City of Mounds View on this ____ day of ___________, 2002. Read and passed by the City Council of the City of Mounds View this day of _______________, 2002. _____________________________________ ATTEST: Rich Sonterre, Mayor (SEAL) _____________________________________ Kathleen Miller, Clerk-Administrator APPROVED AS TO FORM: _________________________ City Attorney M:\MasterFiles\1999 thru 2010\2002\City Council\Council Packets\10-28-02\Item 07E 2nd Rdg & Adopt. of Ordinance 707, an Ordinance Amending Chpation 405 Section 405.02 subd 1 to Appoint. of Members Parks and Rec Commission.doc Item No.7E Type of Business: CA WK: Work Session; PH: Public Hearing; CA: Consent Agenda; CB: Council Business City of Mounds View Staff Report To: Honorable Mayor and City Council From: Kathleen Miller, City Administrator Item Title/Subject: Second Reading and Adoption of Ordinance 707, an Ordinance Amending Title 100, Chapter 405 of the Mounds View City Code by Amending Section 405.02, Subdivision 1 as to the Appointment of Members of the Parks and Recreation Commission Date of Report: October 28, 2002 Background At the September 3, 2002 Work Session the City Council directed staff to amend the Municipal Code to reflect a reduction in the number of members on the Park and Recreation Commission from nine to seven. The Ordinance Proposing an Amendment to the Mounds View City Code by Amending Title 100, Chapter 405 of the Mounds View Municipal Code by Amending Section 405.02, Subdivision 1 as to the Appointment of Members of the Park and Recreation Commission was reviewed by the City Council at the October 14, 2002 City Council Meeting. This ordinance is back before you this evening for the second reading and adoption by the City Council. If adopted by the City Council, the Ordinance will be published in the Focus News and will take effect 30 days after publication. Respectfully Submitted, ___________________________ Kathleen F. Miller City Administrator M:\MasterFiles\1999 thru 2010\2002\City Council\Council Packets\10-28-02\Item 07E 2nd Rdg & Adopt. of Ordinance 707, an Ordinance Amending Chpation 405 Section 405.02 subd 1 to Appoint. of Members Parks and Rec Commission.doc ORDINANCE NO. 707 CITY OF MOUNDS VIEW COUNTY OF RAMSEY STATE OF MINNESOTA AN ORDINANCE AMENDING TITLE 400, CHAPTER 405 OF THE MOUNDS VIEW MUNICIPAL CODE BY AMENDING SECTION 405.02, SUBD. 1 AS TO APPOINTMENT OF MEMBERS OF THE PARKS AND RECREATION COMMISSION THE CITY OF MOUNDS VIEW ORDAINS: SECTION 1. Section 405.02, Subd. 1 of the Mounds View Municipal Code relating to appointment of members of the Parks and Recreation Commission is hereby amended by the addition of the bold and double underlined language and the deletion of the bold and stricken language as follows: 405.02: MEMBERSHIP; OATH; COMPENSATION: Subd. 1. Appointment of Members: The Commission shall consist of nine (9)seven (7) members appointed by the Mayor with the approval of the majority of the Council. The Mayor, with approval of the City Council, shall appoint a chairperson at the first regular meeting of the Council in January. SECTION 2. This ordinance is effective 30 days after its publication. Read by the City Council of the City of Mounds View on this ____ day of ___________, 2002. Read and passed by the City Council of the City of Mounds View this day of ____________, 2002. _____________________________________ ATTEST: Rich Sonterre, Mayor (SEAL) _____________________________________ Kathleen Miller, Clerk-Administrator APPROVED AS TO FORM: _________________________ City Attorney Item No. 7F Type of Business: CB WK: Work Session; PH: Public Hearing; CA: Consent Agenda; CB: Council Business City of Mounds View Staff Report To: Honorable Mayor and City Council From: Charles Hansen, Finance Director Item Title/Subject: Financial Report for the Quarter Ended Sept. 30, 2002 Date of Report: October 25, 2002 Attached is the September 30, 2002 Quarterly Financial Report. General Fund: The end of the third quarter gives us sufficient data to start drawing some conclusions for the year 2002. I expect revenues in total to roughly equal the budget of $4,555,628. Several individual revenues are worthy of note. For Franchise taxes, the September Year-to-Date (YTD) figures for both years actually represent eight months of revenue. If this trend holds through year-end, 2002 revenues will total about $171,500. This results from energy prices being significantly lower in 2002 than they were in 2001. There are some predictions for higher energy prices in 2003. We may want to revise down the amount in the 2003 budget which currently is $190,000. The next major group of revenues after taxes is licenses and permits. The YTD business licenses portion of this is tracking well with 2001 and with the 2002 budget. However, the building and related permits portion is off significantly. This runs from plan check fees (100-3268) through sewer & water surcharge (100-3286). YTD 2002 totals $112,901.79, compared with $162,495.33 YTD in 2001. This is a reduction of $49,593.54 or 31%. At least one major permit inflated the 2001 total and major permits may come in yet in the fourth quarter of 2002. At least some of the decline in permits is probably the result of the downturn in the economy. Actual permit revenue in 2003 will probably be no more than the amount budgeted unless there are one or more major projects. Following this is the intergovernmental revenue category that contains the local government aid. The City is due to receive second half aid payments of almost $400,000, which normally would be delivered to us on about December 30th. This is at risk given the State’s budget problems. Court fines are also down somewhat, although they aren’t a significant revenue item for the City. Interest revenue significantly exceeded the budget in 2001. Given the lower interest rates in the financial markets, I expect interest income to be close to the budget for 2002. On the expenditure side of the General Fund budget, only the Police Department stands out for comment. In the 2001 budget, appropriations for two additional police officers were included as part of a COPS grant. The grant wasn’t received and the officers were not hired. Appropriations for another officer were added in the 2002 budget, but none was hired due to anticipation of the state’s budget crisis. The Police Chief’s position has been vacant for all of 2002. These unfilled positions have generated much of the budget surplus in 2001 and 2002, but won’t be there in 2003. In 2001, total expenditures were $484,222 under budget. The September 2002 YTD expenditures are very close to the September 2001 YTD expenditures. This points to the possibility of a similar surplus in 2002. With revenues tracking to be on budget in total and expenditures tracking about $400,000 under budget, we can look for about a $400,000 surplus at year-end. If the State cuts the December state aid payment by some amount that will directly reduce the surplus. Any surplus should be retained in the General Fund to deal with state aid cuts that should be expected for 2003. Other Funds: Community Center operations have deteriorated compared to 2001. This will be reviewed in detail in the 2003 budget on November 6th. The tax increment financing districts are having a better year than was anticipated either by the 2002 budget or by Ehlers & Associates when they reported to the City Council last spring. TIF tax collections are a little better than expected and either a small transfer or no transfer to the EDA fund will be needed. This is the result of the EDA having a quieter year than 2001 and a state DTED grant being collected in 2002 that related to project expenditures in 2001. The MSA Construction Fund receives allocations from the State of Minnesota gas tax collections. It is possible for this fund to accumulate a cash balance and ours had a balance of $191,600 as of December 31, 1999. During 2000 and 2001, modest expenditures were made for engineering studies, mostly for Edgewood Drive, Highway 10, and County Road H2 design. In 2002, H2 expenditures picked up and have included major construction payments in the past month. I presume that all expenditures charged into the MSA fund are eligible for reimbursement from the State. To get distributions from the State, it is necessary for the city engineer (currently SEH) to submit claims for reimbursement. I expect that at a minimum, a claim for reimbursement should be submitted to the State at least once a year. No reimbursements have been received from the State since sometime in 1999. H2 construction payments have put the MSA fund in the position of a cash deficit of $494,243 as of today. I recommend that claims for reimbursement for all costs since 1999 be submitted to the State as soon as possible. The Golf Course is having a difficult year with low revenues due to poor weather and effects of the strike. This will be reviewed in detail in the 2003 budget on November 6th. Finance Department Operations: Major third quarter activities for the Finance Department included the completion of the 2001 Annual Financial Report, sale of water revenue refunding bonds, placement of the insurance policies for the period July 2002 through June 2003, and work on the 2003 budget. Insurance premiums have been allocated to funds and departments based upon the factors the LMCIT used to determine the premiums. Fourth quarter Finance Department priorities will include completion of the 2003 budget and re-establishing the long-range financial plan for the City. The next City Council work session dealing with the budget will be on Wednesday, November 6, 2002. For Monday meetings, we try to have the agenda packet completed the preceding Thursday. Since this will be a Wednesday meeting, I would like to hand out the agenda packet on Monday, November 4th, which is a work session night. This will give me time to maximize the completion of work on the budgets for all funds. Some preparations have started for the GASB Statement No. 34, the new financial reporting model that must be incorporated into the City’s 2003 Annual Financial Report. These preparations will need to accelerate beginning in January 2003. Respectfully Submitted, Charles Hansen Page 1 City of Mounds View, Minnesota Quarterly Financial Report All Funds For the Quarter-Ended September 30, 2002 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- General Fund Revenues Taxes 100-3101 Advalorem taxes-Current 2,641,215.00 861,509.41 792,741.07 32.62%2,166,916.00 1,615,530.53 100-3102 Ad valorem taxes - delinquent - 10,995.01 9,652.06 0.00%- 14,789.06 100-3111 Mobile home taxes - current 13,000.00 - 0.00%13,000.00 16,806.45 100-3112 Mobile home taxes - delinquent 4,000.00 5,113.37 3,346.18 127.83%4,000.00 7,219.95 100-3121 Fiscal disparity - current - 351,489.45 267,421.61 0.00%- 543,300.27 100-3125 Excess TIF 9,000.00 11,837.98 16,829.04 131.53%18,000.00 38,252.38 100-3180 Franchise tax 200,000.00 129,524.22 163,218.25 64.76%168,000.00 216,140.34 100-3190 Penalties & interest 700.00 1,303.05 1,150.32 186.15%700.00 1,606.89 100-3192 Forfeited tax sale apportionments 800.00 - - 0.00%800.00 - 100-3195 Hotel-Motel Tax 30,000.00 27,004.22 90.01%- 9,857.47 Total Taxes 2,898,715.00 1,398,776.71 1,254,358.53 48.26%2,371,416.00 2,463,503.34 Licenses and Permits 100-3211 Liquor: on-sale license 18,000.00 15,370.00 18,270.30 85.39%16,000.00 21,720.30 100-3212 Liquor: off-sale 650.00 600.00 650.00 92.31%600.00 650.00 100-3214 Sunday liquor sales - - 200.00 0.00%- 400.00 100-3215 Malt liquor: on-sale license - 1,000.00 1,000.00 0.00%- 1,000.00 100-3216 Malt liquor: off sale license 250.00 200.00 500.00 80.00%250.00 500.00 100-3221 Tobacco license 2,500.00 2,550.00 2,400.00 102.00%2,500.00 2,550.00 100-3223 Amusement device license 2,000.00 975.00 935.00 48.75%2,900.00 1,040.00 100-3230 Sunday liquor sales 200.00 3,400.00 200.00 1700.00%- 200.00 100-3231 Bowling alley license 480.00 640.00 640.00 133.33%480.00 640.00 100-3232 Garbage hauling license 2,000.00 2,160.00 1,400.00 108.00%2,000.00 1,495.00 100-3233 Gasoline station license 1,000.00 740.00 710.00 74.00%1,200.00 710.00 100-3234 Used car sales license 150.00 150.00 150.00 100.00%150.00 150.00 100-3235 Kennel license 150.00 - 0.00%150.00 80.00 100-3236 Restraurant license 4,300.00 3,300.00 4,290.00 76.74%4,300.00 4,565.00 100-3238 Transient & solicitor license 800.00 832.50 340.00 104.06%800.00 560.00 100-3239 Apartment license 8,700.00 6,445.00 7,000.00 74.08%8,700.00 8,820.00 100-3241 Dog license 1,000.00 562.50 525.00 56.25%800.00 683.00 100-3250 General contractor license 1,000.00 440.00 680.00 44.00%1,500.00 955.00 100-3251 HVAC contractor license 2,500.00 1,520.00 1,280.00 60.80%2,500.00 2,760.00 100-3252 Cement contractor license 80.00 120.00 150.00%75.00 - 100-3253 Asphalt contractor license 400.00 280.00 400.00 70.00%450.00 680.00 Page 2 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 100-3254 Excavating contractor license 120.00 40.00 40.00 33.33%50.00 80.00 100-3255 Sign & billboard license 400.00 200.00 250.00 50.00%400.00 410.00 100-3256 Sewer & water contractor license 200.00 115.00 80.00 57.50%200.00 80.00 100-3257 Other contractor license 600.00 480.00 480.00 80.00%600.00 600.00 100-3258 License check fee 1,000.00 739.61 715.00 73.96%- 1,010.35 100-3260 Fire permits 200.00 - 400.00 0.00%- 500.00 100-3268 Plan check fee 17,000.00 25,870.95 39,860.42 152.18%- 44,816.99 100-3270 Building permits 70,000.00 55,271.83 68,816.24 78.96%75,000.00 84,675.06 100-3271 Building permit - fixed fee 7,500.00 11,941.08 12,491.69 159.21%6,000.00 16,223.94 100-3272 Wetland buffer permit 400.00 - 25.00 0.00%400.00 25.00 100-3273 HVAC permit 9,000.00 8,179.94 26,873.43 90.89%9,000.00 29,072.25 100-3274 Plumbing permit 4,000.00 2,883.00 4,056.25 72.08%6,000.00 4,979.75 100-3275 Non-building permit 4,000.00 4,810.50 4,555.00 120.26%3,000.00 5,707.00 100-3277 Fire Department permits - - 250.00 0.00%- 300.00 100-3279 Conditional use permit 1,200.00 300.00 400.00 25.00%1,200.00 500.00 100-3280 Building surcharge (500.00) 3,312.18 4,714.77 -662.44%(500.00) 2,646.85 100-3281 Fixed fee building surcharge - 117.25 63.06 0.00%- 8.98 100-3282 Mechanical/Commercial surcharge - 115.83 300.95 0.00%- 36.28 100-3283 HVAC surcharge 100.00 70.33 38.76 70.33%100.00 1.52 100-3284 Plumbing surcharge - 27.40 24.76 0.00%- 4.03 100-3286 Sewer & water surchage - 1.50 25.00 0.00%- 25.00 Total licenses and permits 161,380.00 155,761.40 206,030.63 96.52%146,805.00 241,861.30 Intergovernmental 100-3318 Federal police grant - - 0.00%68,000.00 - 100-3341 Local government aid 789,466.00 394,733.00 380,281.00 50.00%760,562.00 760,562.00 100-3342 Homestead credit - - 194,617.50 0.00%389,235.00 389,235.00 100-3343 Homestead credit - mobile homes - - 0.00%- 11,148.00 100-3346 PERA aid 8,671.00 4,335.50 4,335.50 50.00%8,671.00 8,671.00 100-3347 Low Income Housing Aid 10,321.00 10,321.00 4,226.00 100.00%4,226.00 4,226.00 100-3348 Civil Defense 1,300.00 - 1,188.00 0.00%1,300.00 1,188.00 100-3351 MSA - street maintenance 82,000.00 97,020.00 46,007.50 118.32%82,000.00 92,015.00 100-3355 Police insurance premium tax 90,000.00 - 0.00%92,000.00 76,554.00 100-3356 Police training aid 5,000.00 6,854.57 6,880.49 137.09%5,000.00 6,880.49 100-3357 State police grant 975.00 - 0.00%- - 100-3359 Other state grants 2,000.00 10,050.00 5,000.00 502.50%2,000.00 5,000.00 100-3371 ISD # 621 DARE aid 47,610.00 63,989.11 10,023.00 134.40%47,610.00 10,023.00 Total intergovernmental 1,037,343.00 587,303.18 652,558.99 56.62%1,460,604.00 1,365,502.49 Charges for services 100-3415 Housing Inspections - 150.00 300.00 0.00%- 350.00 100-3416 Recording Fees - 39.00 49.00 0.00%- 49.00 100-3417 Spec. assessment & A/R search 400.00 - 10.00 0.00%400.00 10.00 Page 3 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 100-3418 HRA Inspections 750.00 - 720.00 0.00%750.00 3,480.00 100-3419 Investigations 500.00 360.00 72.00%500.00 - 100-3421 Police reports 1,500.00 1,169.50 549.13 77.97%1,500.00 841.13 100-3422 Copies 300.00 117.58 168.31 39.19%300.00 199.31 100-3423 Customer service 500.00 522.50 418.23 104.50%500.00 488.23 100-3426 Reimbursed staff time 1,000.00 1,426.49 142.65%1,000.00 1,000.00 100-3430 Right-of-way - - 600.00 0.00%- 600.00 100-3431 Street opening fee 50.00 80.00 59.80 160.00%50.00 79.80 100-3432 Tree removal charges 6,000.00 2,151.75 1,992.00 35.86%6,000.00 11,031.50 100-3433 Overload permits 5,000.00 5,580.00 6,460.00 111.60%5,000.00 6,460.00 100-3460 Easement vacation - - 250.00 0.00%- 250.00 100-3461 Subdivision fee 750.00 3,650.00 3,400.00 486.67%750.00 3,600.00 100-3462 Variance 1,000.00 2,500.00 1,200.00 250.00%1,000.00 1,800.00 100-3463 Rezoning 1,000.00 17,532.50 750.00 1753.25%500.00 750.00 100-3464 Development fee - non refundable 1,000.00 2,298.00 1,262.50 229.80%800.00 2,012.50 Total charges for services 19,750.00 37,577.32 18,188.97 190.26%19,050.00 33,001.47 Fines and forfeits 100-3510 Ramsey County municipal court 32,000.00 16,986.67 20,697.92 53.08%38,000.00 28,137.60 100-3515 MN Highway Patrol 1,500.00 401.67 521.67 26.78%3,000.00 641.67 100-3520 Administrative offenses 5,500.00 1,565.00 1,365.00 28.45%5,500.00 1,670.00 100-3525 Alarm Violations 6,000.00 1,925.00 2,375.00 32.08%7,000.00 3,075.00 Total fines and forfeits 45,000.00 20,878.34 24,959.59 46.40%53,500.00 33,524.27 Miscellaneous revenue 100-3610 Interest revenue 79,000.00 - 0.00%79,000.00 162,769.48 100-3634 Equipment rental - - 1,680.00 0.00%- 1,680.00 100-3650 Donations - 1,620.00 0.00%- - 100-3656 Tree Sales - 1,338.00 0.00%- 650.79 100-3665 Park site rental 1,750.00 2,269.00 2,080.00 129.66%1,750.00 1,600.00 100-3675 Rentals 7,000.00 7,000.00 100.00%- - 100-3680 Miscellaneous revenue 10,000.00 4,041.75 5,495.95 40.42%10,000.00 8,156.38 100-3681 Sales tax - 1.56 0.00%- - 100-3685 Insurance Reimbursement 15,000.00 - 2,002.00 0.00%10,000.00 15,260.89 100-3690 Cash over & short - 18.27 0.00%- 11.12 100-3911 Sale of assets 2,000.00 6,920.00 1,176.75 346.00%2,000.00 1,676.75 100-3912 Sale of materials 500.00 250.36 3,194.07 50.07%500.00 3,263.89 100-3972 Transfer from other funds 278,190.00 - 0.00%273,990.00 273,990.00 Total Miscellaneous revenue 393,440.00 23,457.38 15,630.33 5.96%377,240.00 469,059.30 *100 Total Revenue 4,555,628.00 2,223,754.33 2,171,727.04 48.81%4,428,615.00 4,606,452.17 Page 4 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Expenses City Council 100-4100-0100 Salaries, regular 23,100.00 17,757.48 23,414.36 76.87%31,570.00 31,741.06 100-4100-0110 Salaries, overtime - - 239.90 0.00%- 239.90 100-4100-0150 Salaries, part-time regular pay - 110.05 0.00%- - 100-4100-0300 Social Security 2,975.00 1,086.48 1,524.11 36.52%4,090.00 2,067.79 100-4100-0321 PERA coordinated - employer contribution - 519.24 819.09 0.00%- 1,115.06 100-4100-0400 Health insurance - employer contribution - - 356.01 0.00%600.00 481.59 100-4100-0410 Life insurance - employer contribution - 101.43 0.00%- 135.14 100-4100-0420 Dental insurance - employer contribution - 44.50 0.00%- 60.68 100-4100-0500 Workers compensation 90.00 70.00 61.15 77.78%135.00 91.83 100-4100-1600 Operating supplies 3,000.00 66.03 2,618.72 2.20%3,300.00 2,960.48 100-4100-2100 Books & periodicals - - 0.00%100.00 - 100-4100-3030 Other professional services 26,150.00 6,188.00 11,123.65 23.66%33,650.00 13,386.29 100-4100-3100 Telephone - - 0.00%500.00 - 100-4100-3610 Memberships 13,150.00 12,035.45 13,262.00 91.52%17,500.00 14,439.00 100-4100-3630 Training & conferences 5,000.00 2,836.17 5,202.96 56.72%7,000.00 7,408.94 100-4100-4800 Insurance & bonds 1,400.00 1,179.00 885.73 84.21%1,400.00 885.73 100-4100-7030 Equipment - - 372.66 0.00%- 372.66 *4100 Total City Council 74,865.00 41,847.90 60,026.27 55.90%99,845.00 75,386.15 Advisory Commissions 100-4110-0150 Salaries, part-time - - 0.00%250.00 - 100-4110-0300 Social Security - - 0.00%19.00 - 100-4110-0500 Workers compensation - 0.23 0.46 0.00%1.00 0.69 100-4110-1600 Operating supplies 700.00 - 135.62 0.00%700.00 135.62 100-4110-2100 Books & periodicals 100.00 - 0.00%100.00 - 100-4110-3030 Other professional services 8,000.00 3,939.88 641.36 49.25%2,000.00 1,006.86 100-4110-3630 Training & conferences 1,250.00 99.00 7.92%500.00 - 100-4110-3900 Grants to other organizations 4,000.00 783.15 3,952.87 19.58%4,000.00 4,000.00 *4110 Total Advisory Commissions 14,050.00 4,822.26 4,730.31 34.32%7,570.00 5,143.17 City Administrator 100-4130-0100 Salaries, regular 140,649.00 97,284.90 64,340.49 69.17%92,350.00 90,693.99 100-4130-0110 Salaries, overtime 14.49 0.00% 100-4130-0150 Salaries, part-time regular pay 54.30 0.00% 100-4130-0300 Social Security 19,243.00 7,634.02 5,039.93 39.67%12,310.00 7,138.48 100-4130-0321 PERA coordinated - employer contribution - 5,372.85 3,330.24 0.00%- 4,698.10 100-4130-0400 Health insuranace - employer contrib 8,321.00 3,585.34 1,520.65 43.09%6,285.00 2,056.36 100-4130-0410 Life insurance - employer contribution - 1,038.47 1,281.51 0.00%- 2,087.97 100-4130-0420 Dental insurance - employer contribution - 504.76 189.61 0.00%- 258.79 100-4130-0500 Workers compensation 1,222.00 695.12 321.60 56.88%710.00 482.97 100-4130-0990 Severence pay - 721.23 0.00%- - Page 5 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 100-4130-1600 Operating supplies - 28.45 186.01 0.00%500.00 971.26 100-4130-2100 Books & periodicals - - 509.14 0.00%950.00 568.29 100-4130-3030 Other professional services 1,500.00 4,401.00 293.40%3,000.00 - 100-4130-3100 Telephone - - 0.00%150.00 - 100-4130-3430 Printing 100.00 28.22 28.22%150.00 - 100-4130-3610 Memberships 1,995.00 1,336.83 1,434.50 67.01%1,700.00 1,933.25 100-4130-3630 Training & conferences 4,795.00 258.80 1,279.05 5.40%5,850.00 1,858.18 100-4130-3800 Mileage & Parking 3,000.00 2,112.61 2,017.83 70.42%3,000.00 2,886.45 100-4130-7030 Equipment 2,500.00 - 494.49 0.00%- 494.49 *4130 Total City Administrator 183,325.00 125,071.39 81,945.05 68.22%126,955.00 116,128.58 Elections 100-4140-0100 Salaries, regular 9,019.00 6,211.19 2,900.67 68.87%4,235.00 4,128.56 100-4140-0110 Salaries, overtime - 578.51 119.95 0.00%- 119.95 100-4140-0150 Salaries, part-time regular pay 9,036.00 4,331.33 38.65 47.93%- 187.02 100-4140-0300 Social Security 1,926.00 846.92 228.53 43.97%565.00 322.49 100-4140-0321 PERA coordinated - employer contribution - 375.22 156.50 0.00%- 220.11 100-4140-0400 Health insurance - employer contribution 534.00 464.72 177.99 87.03%300.00 240.78 100-4140-0410 Life insurance - employer contribution - 31.89 50.75 0.00%- 67.61 100-4140-0420 Dental insurance - employer contribution - 33.97 22.29 0.00%- 30.38 100-4140-0500 Workers compensation 129.00 63.17 13.59 48.97%30.00 20.41 100-4140-1140 Miscellaneous office supplies - - 0.00%100.00 - 100-4140-1600 Operating supplies 600.00 672.16 112.03%500.00 - 100-4140-3030 Other professional services 4,000.00 - 259.92 0.00%100.00 259.92 100-4140-3410 Legal notices 700.00 9.00 1.29%- - 100-4140-7030 Equipment 8,000.00 - 0.00%- - *4140 Total Elections 33,944.00 13,618.08 3,968.84 40.12%5,830.00 5,597.23 Finance 100-4150-0100 Salaries, regular 135,940.00 86,001.08 71,295.26 63.26%117,409.00 110,901.04 100-4150-0110 Salaries, overtime 710.00 - 0.00%686.00 - 100-4150-0150 Salaries, part-time regular pay 14,040.00 8,715.30 62.07%- - 100-4150-0300 Social Security 20,615.00 7,210.91 5,776.61 34.98%15,745.00 8,013.91 100-4150-0321 PERA coordinated - employer contribution - 5,439.45 3,499.24 0.00%- 5,077.24 100-4150-0400 Health insurance - employer contribution 12,970.00 8,725.32 4,632.26 67.27%8,280.00 7,119.23 100-4150-0410 Life insurance - employer contribution - 218.06 349.04 0.00%- 390.65 100-4150-0420 Dental insurance - employer contribution - - 120.44 0.00%- 120.44 100-4150-0500 Workers compensation 605.00 380.16 231.00 62.84%510.00 346.91 100-4150-0990 Severence pay - - 9,673.85 0.00%- 9,673.85 100-4150-1140 Miscellaneous office supplies - - 9.55 0.00%125.00 9.55 100-4150-1600 Operating supplies 375.00 133.42 41.74 35.58%250.00 41.74 100-4150-2100 Books & periodicals 375.00 285.00 76.00%375.00 (299.00) 100-4150-3030 Other professional services 8,000.00 10,024.67 16,029.02 125.31%8,200.00 59,978.31 Page 6 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 100-4150-3430 Printing 2,000.00 476.11 84.52 23.81%2,000.00 814.07 100-4150-3610 Memberships 260.00 230.00 75.00 88.46%520.00 75.00 100-4150-3630 Training & conferences 1,950.00 1,628.90 676.03 83.53%3,950.00 3,304.03 100-4150-5130 Repairs, equipment 3,300.00 251.58 384.90 7.62%2,950.00 5,569.72 100-4150-7030 Equipment 2,000.00 958.50 1,245.00 47.93%2,000.00 1,827.19 *4150 Total Finance 203,140.00 130,678.46 114,123.46 64.33%163,000.00 212,963.88 Central Services 100-4160-0100 Salaries, regular 12,854.00 9,688.73 52,236.55 75.38%46,675.00 73,686.79 100-4160-0110 Salaries, overtime 566.00 - 0.00%1,100.00 - 100-4160-0150 Salaries, part-time regular pay 13,331.00 926.04 1,225.12 6.95%52,395.00 2,089.05 100-4160-0300 Social Security 3,661.00 837.14 4,064.16 22.87%12,525.00 5,777.23 100-4160-0321 PERA coordinated - employer contribution - 532.62 2,705.74 0.00%- 3,818.67 100-4160-0400 Health insurance - employer contribution 4,759.00 1,111.13 3,220.84 23.35%6,795.00 4,516.44 100-4160-0410 Life insurance - employer contribution - 64.25 438.39 0.00%- 588.39 100-4160-0420 Dental insurance - employer contribution - 19.99 191.68 0.00%- 262.87 100-4160-0500 Workers compensation 184.00 303.10 443.90 164.73%980.00 666.64 100-4160-1110 Stationery 900.00 894.87 257.39 99.43%900.00 257.39 100-4160-1120 Copy supplies 3,000.00 917.44 30.58%3,000.00 - 100-4160-1140 Miscellaneous office supplies 13,000.00 3,017.37 10,749.33 23.21%12,500.00 15,305.51 100-4160-1210 Supplies, building & grounds - 123.69 2,013.44 0.00%6,000.00 3,223.38 100-4160-1600 Operating supplies - 4,993.71 482.57 0.00%500.00 670.54 100-4160-2100 Books & periodicals 1,525.00 979.80 730.05 64.25%1,400.00 730.05 100-4160-3010 General legal services 55,000.00 50,037.65 25,372.77 90.98%55,000.00 44,204.47 100-4160-3030 Other professional services 53,620.00 50,467.02 41,953.73 94.12%36,600.00 54,555.49 100-4160-3100 Telephone 18,000.00 10,252.56 10,043.22 56.96%18,000.00 15,599.15 100-4160-3200 Water & sewer 1,000.00 217.42 200.02 21.74%1,000.00 543.59 100-4160-3210 Electricity 17,000.00 10,248.95 11,979.71 60.29%17,000.00 16,994.22 100-4160-3220 Natural gas 7,500.00 3,979.23 10,264.43 53.06%7,500.00 12,221.36 100-4160-3300 Postage 14,800.00 6,770.11 8,546.58 45.74%15,500.00 8,831.72 100-4160-3410 Legal notices 6,000.00 3,715.54 4,013.38 61.93%6,000.00 4,574.78 100-4160-3420 Advertising 6,000.00 2,683.52 1,918.56 44.73%6,000.00 4,894.06 100-4160-3430 Printing 10,000.00 5,304.47 5,134.16 53.04%12,000.00 7,666.52 100-4160-3530 Refuse collection 3,750.00 2,645.40 2,333.60 70.54%3,750.00 3,243.23 100-4160-3610 Memberships - - 0.00%400.00 - 100-4160-3630 Training & conferences 6,800.00 219.03 1,290.80 3.22%6,800.00 1,310.75 100-4160-3800 Mileage & Parking - 2.24 24.84 0.00%400.00 24.84 100-4160-4010 Rental, equipment 15,900.00 9,658.02 9,352.37 60.74%16,400.00 12,087.76 100-4160-4800 Insurance & bonds 22,000.00 14,891.22 13,918.63 67.69%22,000.00 13,918.63 100-4160-5110 Repairs, buildings & grounds - 387.84 4,451.51 0.00%7,000.00 5,093.91 100-4160-5130 Repairs, equipment 5,000.00 2,985.60 5,726.96 59.71%8,000.00 11,461.36 100-4160-7010 Buildings - - 0.00%- 20,000.00 Page 7 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 100-4160-7030 Equipment 25,000.00 10,391.95 17,841.92 41.57%25,000.00 23,027.52 *4160 Total Central Services 321,150.00 209,267.65 253,126.35 65.16%409,120.00 371,846.31 Community Development 100-4180-0100 Salaries, regular 238,855.00 152,300.42 103,595.39 63.76%191,815.00 153,444.77 100-4180-0110 Salaries, overtime - 120.60 0.00%- - 100-4180-0150 Salaries, part-time regular pay 5,200.00 221.22 4.25%10,400.00 - 100-4180-0300 Social Security 33,390.00 7,645.06 7,375.36 22.90%26,955.00 10,997.50 100-4180-0321 PERA coordinated - employer contribution - 10,510.35 5,366.08 0.00%- 7,948.21 100-4180-0400 Health insurance - employer contribution 28,500.00 18,250.10 12,308.98 64.04%17,940.00 16,702.80 100-4180-0410 Life insurance - employer contribution - 179.21 86.80 0.00%- 121.60 100-4180-0420 Dental insurance - employer contribution - 386.38 110.50 0.00%- 192.82 100-4180-0500 Workers compensation 2,205.00 1,321.07 713.40 59.91%1,575.00 1,071.37 100-4180-1600 Operating supplies 1,075.00 814.12 90.68 75.73%1,095.00 109.82 100-4180-2100 Books & periodicals 715.00 135.00 331.16 18.88%595.00 676.16 100-4180-3030 Other professional services 22,076.00 21,577.09 2,830.74 97.74%16,250.00 6,148.57 100-4180-3034 Building inspections - contractual - 2,828.40 29,926.03 0.00%55,000.00 40,648.64 100-4180-3040 Consultants - other 12,000.00 4,357.73 3,240.21 36.31%14,600.00 5,307.91 100-4180-3100 Telephone 915.00 999.59 109.24%- - 100-4180-3300 Postage 8.50 #DIV/0! 100-4180-3430 Printing 2,000.00 374.99 876.98 18.75%2,250.00 1,383.12 100-4180-3610 Memberships 970.00 656.00 60.00 67.63%1,270.00 255.00 100-4180-3630 Training & conferences 5,100.00 1,842.91 2,354.28 36.14%5,900.00 3,194.93 100-4180-3800 Mileage & Parking 200.00 9.00 54.82 4.50%200.00 54.82 100-4180-7030 Equipment 3,200.00 408.04 222.22 12.75%3,800.00 222.22 *4180 Total Community Development 356,401.00 224,945.78 169,543.63 63.12%349,645.00 248,480.26 Police 100-4200-0100 Salaries, regular 1,195,909.00 644,224.63 647,241.09 53.87%1,041,781.00 906,166.46 100-4200-0110 Salaries, overtime 13,600.00 9,294.08 7,659.75 68.34%18,859.00 10,790.19 100-4200-0150 Salaries, part-time regular pay 19,219.00 33,381.00 38,990.56 173.69%43,924.00 53,732.68 100-4200-0300 Social Security 130,401.00 8,340.88 9,472.19 6.40%116,695.00 12,897.24 100-4200-0321 PERA coordinated - employer contribution - 61,960.33 60,865.66 0.00%- 86,058.11 100-4200-0400 Health insurance - employer contribution 128,910.00 70,633.79 57,787.71 54.79%95,115.00 80,667.25 100-4200-0410 Life insurance - employer contribution - 1,544.70 1,956.22 0.00%- 1,768.20 100-4200-0420 Dental insurance - employer contribution - 1,644.19 1,109.82 0.00%- 1,661.52 100-4200-0500 Workers compensation 32,537.00 23,610.63 13,037.79 72.57%28,516.00 19,519.02 100-4200-0990 Severence pay - 217.59 8,944.94 0.00%- 16,570.54 100-4200-1140 Miscellaneous office supplies - 70.71 56.80 0.00%1,050.00 598.87 100-4200-1210 Supplies, building & grounds 1,150.00 512.33 26.83 44.55%300.00 70.22 100-4200-1600 Operating supplies 5,050.00 2,860.55 2,773.78 56.64%4,000.00 4,974.89 100-4200-1700 Motor fuels & lubricants 21,600.00 10,566.02 11,650.44 48.92%32,430.00 15,933.75 100-4200-2100 Books & periodicals 1,000.00 20.91 697.03 2.09%1,000.00 1,195.42 Page 8 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 100-4200-2400 Uniform & clothing 16,135.00 14,572.66 14,854.53 90.32%21,620.00 17,662.91 100-4200-3020 Prosecuting attorney services 47,000.00 32,559.90 32,340.00 69.28%44,600.00 47,058.00 100-4200-3030 Other professional services 21,300.00 11,928.90 2,635.65 56.00%17,175.00 16,845.04 100-4200-3050 Dispatching - contractual 70,875.00 32,130.90 32,134.46 45.33%67,500.00 64,268.92 100-4200-3055 Information system fees 4,970.00 1,890.00 1,680.00 38.03%4,600.00 3,420.00 100-4200-3070 COPS events 2,000.00 464.23 23.21%2,000.00 594.51 100-4200-3080 Veternarian services 2,200.00 1,200.00 1,475.00 54.55%2,200.00 2,020.00 100-4200-3100 Telephone 5,500.00 3,785.98 3,565.21 68.84%3,200.00 5,717.16 100-4200-3210 Electricity 250.00 156.96 156.96 62.78%250.00 235.44 100-4200-3430 Printing 1,500.00 344.66 365.28 22.98%1,500.00 373.94 100-4200-3610 Memberships 1,595.00 1,146.00 1,020.00 71.85%1,680.00 1,020.00 100-4200-3630 Training & conferences 12,960.00 5,160.75 5,464.92 39.82%12,325.00 7,533.57 100-4200-4010 Rental, equipment 4,500.00 3,409.79 3,503.36 75.77%7,640.00 4,509.80 100-4200-4800 Insurance & bonds 23,400.00 14,330.30 13,981.91 61.24%22,100.00 13,981.91 100-4200-5100 Repairs, computers 12,300.00 4,991.52 5,030.32 40.58%12,800.00 7,563.08 100-4200-5130 Repairs, equipment 5,500.00 2,724.54 3,244.54 49.54%4,100.00 5,786.45 100-4200-6300 Grant matching 5,000.00 - 0.00%5,000.00 - 100-4200-7030 Equipment 24,720.00 6,436.34 12,917.62 26.04%64,600.00 21,736.25 100-4200-7030 Equipment LLEBG-FY 2000 - - 1,216.00 0.00%- 1,216.00 100-4200-7040 Vehicles 74,200.00 36,762.55 19,611.00 49.55%24,300.00 23,053.92 *4200 Total Police 1,885,281.00 1,042,878.32 1,017,467.37 55.32%1,702,860.00 1,457,201.26 Fire 100-4210-3030 Other professional services - - 6,654.84 0.00%28,000.00 8,769.84 100-4210-3032 Contractual fire services 148,200.00 148,200.00 139,214.00 100.00%139,077.00 139,214.00 100-4210-3050 Dispatching - contractual 3,500.00 3,437.36 98.21%3,500.00 - 100-4210-7040 Vehicles 13,005.00 13,000.50 8,553.00 99.97%8,690.00 8,553.00 *4210 Total Fire 164,705.00 164,637.86 154,421.84 99.96%179,267.00 156,536.84 Recreation 100-4350-0100 Salaries, regular - - 0%- 101.29 100-4350-0600 Unemployment - - 0%- (1,644.18) 100-4350-1140 Miscellaneous office supplies - - 0%500.00 - 100-4350-1600 Operating supplies 700.00 - 0.00%200.00 - 100-4350-3036 Contractual recreation 126,575.00 88,924.50 62,067.00 70.25%111,575.00 82,756.00 100-4350-3060 School coordinator 10,800.00 4,440.41 8,415.59 41.11%10,500.00 11,830.57 100-4350-3300 Postage 800.00 579.45 599.99 72.43%1,200.00 899.98 100-4350-3430 Printing 6,000.00 3,096.17 5,134.16 51.60%6,500.00 7,664.66 100-4350-4800 Insurance & bonds 3,000.00 1,183.63 1,897.98 39.45%3,000.00 1,897.98 100-4350-5110 Repairs, buildings & grounds 490.00 - 0.00%490.00 - *4350 Total Recreation 148,365.00 98,224.16 78,114.72 66.20%133,965.00 103,506.30 Park Maintenence 100-4360-0100 Salaries, regular 83,530.00 48,175.33 71,549.52 57.67%73,430.00 102,469.11 Page 9 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 100-4360-0110 Salaries, overtime 5,274.00 2,571.87 3,224.01 48.77%5,072.00 4,278.62 100-4360-0150 Salaries, part-time regular pay 17,893.00 23,438.64 26,678.25 130.99%17,893.00 32,511.25 100-4360-0300 Social Security 14,021.00 5,458.72 7,462.65 38.93%12,304.00 10,245.65 100-4360-0321 PERA coordinated - employer contribution - 3,012.02 4,388.89 0.00%- 6,288.41 100-4360-0400 Health insurance - employer contribution 11,860.00 6,772.55 10,237.08 57.10%9,462.00 13,908.36 100-4360-0410 Life insurance - employer contribution - 42.34 69.82 0.00%- 93.43 100-4360-0420 Dental insurance - employer contribution - - 0.30 0.00%- 0.30 100-4360-0500 Workers compensation 2,694.00 2,811.20 1,121.79 104.35%2,339.00 1,479.41 100-4360-0700 Salaries, on call pay 3,671.00 - 0.00%3,530.00 - 100-4360-1210 Supplies, buildings & grounds 17,800.00 10,019.45 7,375.01 56.29%19,900.00 9,019.07 100-4360-1220 Supplies, vehicles 4,200.00 2,467.51 3,857.58 58.75%4,000.00 7,671.45 100-4360-1230 Supplies, equipment 2,650.00 189.74 91.39 7.16%3,150.00 126.81 100-4360-1600 Operating supplies 10,300.00 546.89 4,059.95 5.31%10,100.00 4,565.56 100-4360-1700 Motor fuels & lubricants 4,340.00 1,228.85 2,909.05 28.31%3,575.00 3,404.76 100-4360-2400 Uniform & clothing 2,080.00 1,815.47 1,224.31 87.28%1,940.00 1,741.98 100-4360-3030 Other professional services 4,030.00 427.66 5,430.22 10.61%3,900.00 7,533.71 100-4360-3100 Telephone 4,860.00 2,140.76 2,362.41 44.05%4,890.00 3,505.25 100-4360-3200 Water & sewer 3,950.00 1,662.24 1,717.85 42.08%4,500.00 5,842.73 100-4360-3210 Electricity 7,110.00 2,637.72 3,414.51 37.10%6,900.00 4,834.65 100-4360-3220 Natural gas 5,000.00 1,585.09 2,392.77 31.70%2,500.00 2,987.58 100-4360-3530 Refuse collection - - 1,567.51 0.00%5,470.00 3,010.26 100-4360-3630 Training & conferences 970.00 517.39 337.00 53.34%920.00 409.00 100-4360-3900 Grants to other organizations 11,626.00 11,626.00 100.00%7,500.00 7,762.42 100-4360-4030 Satellites 6,400.00 5,575.26 3,451.76 87.11%5,300.00 6,486.20 100-4360-4800 Insurance & bonds 6,500.00 2,564.54 4,112.33 39.45%6,500.00 4,112.33 100-4360-5110 Repairs, buildings & grounds 2,200.00 1,396.10 25.16 63.46%2,700.00 117.36 100-4360-7030 Equipment 24,000.00 24,437.19 100,615.21 101.82%225,900.00 227,948.37 100-4360-7050 Construction - 157.92 3,894.53 0.00%- 3,894.53 *4360 Total Park Maintenence 256,959.00 163,278.45 273,570.86 63.54%443,675.00 476,248.56 Athletic Field Maintenance 100-4367-0100 Salaries, regular 4,020.00 5,175.99 3,743.04 128.76%3,865.00 5,306.40 100-4367-0110 Salaries, overtime 940.00 2,756.10 1,223.18 293.20%901.00 1,702.42 100-4367-0150 Salaries, part-time regular pay 5,965.00 3,060.15 51.30%5,964.00 - 100-4367-0300 Social Security 1,135.00 809.92 361.83 71.36%1,093.00 511.87 100-4367-0321 PERA coordinated - employer contribution - 486.21 257.29 0.00%- 363.12 100-4367-0400 Health insurance - employer contribution 625.00 1,020.56 647.66 163.29%500.00 862.05 100-4367-0410 Life insurance - employer contribution - 9.52 4.39 0.00%- 5.61 100-4367-0420 Dental insurance - employer contribution - 5.10 0.00%- - 100-4367-0500 Workers compensation 270.00 162.41 117.42 60.15%252.00 174.70 100-4367-1600 Operating supplies 5,450.00 1,442.63 1,712.66 26.47%4,950.00 2,673.69 100-4367-4800 Insurance & bonds 2,900.00 1,144.17 1,834.72 39.45%2,900.00 1,834.72 Page 10 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 100-4367-7030 Equipment 8,000.00 - 0.00%22,000.00 5,560.45 *4367 Total Athletic Field Maintenance 29,305.00 16,072.76 9,902.19 54.85%42,425.00 18,995.03 Forestry 100-4380-1200 Supplies, landscaping 5,000.00 1,272.68 2,647.90 25.45%4,900.00 3,050.15 100-4380-1210 Supplies, building & grounds 850.00 222.48 232.38 26.17%850.00 357.64 100-4380-1600 Operating supplies 80.00 - 0.00%80.00 - 100-4380-3030 Other professional services 11,000.00 272.00 6,886.84 2.47%10,500.00 9,693.11 100-4380-3033 Forester - joint powers 24,100.00 16,497.00 10,514.00 68.45%24,100.00 21,475.00 100-4380-3520 Tree removal 16,000.00 4,459.97 472.21 27.87%13,500.00 19,232.57 100-4380-3630 Training & conferences 500.00 - 0.00%500.00 - 100-4380-3900 Grants to other organizations 2,500.00 - 0.00%2,500.00 - *4380 Total Forestry 60,030.00 22,724.13 20,753.33 37.85%56,930.00 53,808.47 P/W Administration 100-4410-0100 Salaries, regular 48,939.00 27,941.12 57.09%- - 100-4410-0300 Social Security 6,698.00 1,944.18 29.03%- - 100-4410-0321 PERA coordinated - employer contribution - 1,203.43 0.00%- - 100-4410-0400 Health insurance - employer contribution 5,495.00 1,674.26 30.47%- - 100-4410-0410 Life insurance - employer contribution - 20.82 0.00%- - 100-4410-0420 Dental insurance - employer contribution - 35.12 0.00%- - 100-4410-0500 Workers compensation 841.00 367.37 43.68%- - 100-4410-2400 Uniform & clothing 270.00 484.37 179.40%- - *4410 Total P/W Administration 62,243.00 33,670.67 - 54.10%- - Building & Grounds Maintenance 100-4460-0100 Salaries, regular 4,020.00 2,823.63 2,749.83 70.24%3,865.00 3,879.49 100-4460-0110 Salaries, overtime - 927.55 705.67 0.00%- 1,049.50 100-4460-0300 Social Security 550.00 270.08 243.35 49.11%516.00 351.76 100-4460-0321 PERA coordinated - employer contribution - 208.37 164.03 0.00%- 240.36 100-4460-0400 Health insurance - employer contribution 625.00 530.58 432.87 84.89%498.00 577.57 100-4460-0410 Life insurance - employer contribution - 2.68 2.51 0.00%- 6.07 100-4460-0500 Workers compensation 125.00 83.24 57.07 66.59%126.00 85.71 100-4460-1210 Supplies, buildings & grounds 5,500.00 678.27 88.38 12.33%- 88.38 100-4460-1230 Supplies, equipment 650.00 255.76 365.76 39.35%650.00 365.76 100-4460-1600 Operating supplies 6,700.00 6,242.40 4,092.48 93.17%6,400.00 4,635.97 100-4460-2400 Uniforms & clothing 1,000.00 512.93 428.26 51.29%940.00 428.26 100-4460-3030 Other professional services 17,340.00 6,065.78 808.44 34.98%1,120.00 1,164.69 100-4460-3210 Electricity 5,000.00 2,979.66 3,348.36 59.59%4,850.00 4,758.74 100-4460-3220 Natural gas 7,500.00 2,381.72 3,864.08 31.76%3,750.00 4,847.92 100-4460-3530 Refuse collection 9,550.00 5,335.92 3,141.27 55.87%6,550.00 4,277.51 100-4460-3610 Memberships 100.00 155.00 90.00 155.00%80.00 90.00 100-4460-4010 Rental, equipment - - 75.62 0.00%875.00 171.83 100-4460-4800 Insurance & bonds 18,750.00 12,753.59 11,862.44 68.02%18,750.00 11,862.44 Page 11 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 100-4460-5110 Repairs, buildings & grounds 9,400.00 6,758.86 1,078.97 71.90%3,400.00 1,211.50 100-4460-5130 Repairs, equipment 5,200.00 971.58 2,018.77 18.68%1,800.00 3,481.02 100-4460-7030 Equipment 4,500.00 - 0.00%6,200.00 - *4460 Total Building & Grounds Maintenance 96,510.00 49,937.60 35,618.16 51.74%60,370.00 43,574.48 Squad & Staff Car Maintenance 100-4462-0100 Salaries, regular 16,075.00 11,294.46 10,999.39 70.26%15,459.00 15,518.05 100-4462-0110 Salaries, overtime 2,320.00 1,275.11 1,033.07 54.96%2,230.00 1,178.00 100-4462-0300 Social Security 2,520.00 903.44 874.54 35.85%2,359.00 1,214.13 100-4462-0321 PERA coordinated - employer contribution - 698.73 638.25 0.00%- 879.83 100-4462-0400 Health insurance - employer contribution 2,500.00 1,711.34 1,467.54 68.45%1,992.00 2,005.26 100-4462-0410 Life insurance - employer contribution - 10.29 9.89 0.00%- 13.27 100-4462-0500 Workers compensation 565.00 376.33 258.18 66.61%570.00 387.73 100-4462-1220 Supplies, vehicles 10,025.00 6,065.95 3,593.17 60.51%11,525.00 6,995.57 100-4462-1600 Operating supplies 3,600.00 1,300.67 3,536.02 36.13%3,600.00 4,493.03 100-4462-1700 Motor fuel & lubricants 6,250.00 976.10 1,146.83 15.62%4,010.00 1,282.05 100-4462-2100 Books & periodicals 925.00 - 0.00%925.00 - 100-4462-2400 Uniforms & clothing 1,150.00 451.09 605.35 39.23%1,105.00 956.74 100-4462-3030 Other professional services 150.00 45.00 136.82 30.00%150.00 136.82 100-4462-3610 Memberships 60.00 154.00 60.00 256.67%60.00 60.00 100-4462-3630 Training & conferences 1,150.00 42.00 265.00 3.65%950.00 265.00 100-4462-5120 Repairs, vehicles 11,000.00 508.17 821.29 4.62%4,700.00 964.84 *4462 Total Squad & Staff Car Maintenance 58,290.00 25,812.68 25,445.34 44.28%49,635.00 36,350.32 Vehicle & Equipment Maintenance 100-4465-0100 Salaries, regular 4,020.00 2,823.63 2,749.83 70.24%3,865.00 3,879.49 100-4465-0110 Salaries, overtime 1,160.00 493.45 562.14 42.54%1,115.00 613.06 100-4465-0300 Social Security 710.00 238.94 240.74 33.65%667.00 326.74 100-4465-0321 PERA coordinated - employer contribution - 184.36 171.55 0.00%- 232.71 100-4465-0400 Health insurance - employer contribution 625.00 434.91 402.44 69.59%498.00 536.87 100-4465-0410 Life insurance - employer contribution - 3.39 3.86 0.00%- 4.73 100-4465-0420 Dental insurance - employer contribution - 0.19 0.50 0.00%- 0.50 100-4465-0500 Workers compensation 160.00 106.26 72.48 66.41%160.00 108.85 100-4465-1220 Supplies, vehicles 2,350.00 2,617.36 2,928.41 111.38%1,350.00 3,632.54 100-4465-1230 Supplies, equipment 3,250.00 2,867.69 4,763.44 88.24%2,275.00 5,461.77 100-4465-1600 Operating supplies 1,900.00 89.93 613.81 4.73%1,900.00 613.81 100-4465-2400 Uniforms & clothing 575.00 133.02 53.09 23.13%550.00 228.87 100-4465-3030 Other professional services 200.00 16.00 195.62 8.00%200.00 240.62 100-4465-3630 Training & conferences 275.00 150.00 32.00 54.55%375.00 52.00 100-4465-4010 Rental, equipment 300.00 180.86 66.00 60.29%400.00 66.00 100-4465-5120 Repairs, vehicles 1,500.00 3,020.43 2,930.62 201.36%750.00 2,930.62 100-4465-7030 Equipment 8,700.00 2,000.00 10,698.21 22.99%11,600.00 10,698.21 *4465 Total Vehicle & Equip. Maintenance 25,725.00 15,360.42 26,484.74 59.71%25,705.00 29,627.39 Page 12 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Street Pavement Management 100-4470-0100 Salaries, regular 24,115.00 17,977.03 43,705.15 74.55%65,457.00 56,547.74 100-4470-0110 Salaries, overtime 3,515.00 713.35 1,247.09 20.29%3,379.00 1,743.97 100-4470-0150 Salaries, part-time regular pay 4,160.00 - 4,910.95 0.00%4,159.00 7,737.20 100-4470-0300 Social Security 4,100.00 1,544.41 4,619.71 37.67%9,495.00 5,848.08 100-4470-0321 PERA coordinated - employer contribution - 1,372.29 2,505.35 0.00%- 3,342.74 100-4470-0400 Health insurance - employer contribution 2,125.00 2,122.08 3,396.54 99.86%5,186.00 4,256.67 100-4470-0410 Life insurance - employer contribution - 302.54 292.18 0.00%- 388.38 100-4470-0420 Dental insurance - employer contribution - 304.35 242.38 0.00%- 333.39 100-4470-0500 Workers compensation 1,310.00 1,024.25 1,008.24 78.19%1,989.00 1,460.31 100-4470-0990 Severence pay - - 10,761.68 0.00%- 10,761.68 100-4470-1230 Supplies, equipment 300.00 146.04 80.90 48.68%300.00 80.90 100-4470-1260 Supplies, traffic control 360.00 121.29 33.69%360.00 297.83 100-4470-1600 Operating supplies 2,300.00 526.59 1,702.05 22.90%2,300.00 1,996.05 100-4470-1700 Motor fuels & lubricants 4,250.00 3,086.16 8,361.04 72.62%2,645.00 7,370.36 100-4470-2400 Uniforms & clothing 975.00 740.35 779.24 75.93%1,070.00 1,033.03 100-4470-3030 Other professional services 10,450.00 3,130.49 2,090.67 29.96%9,950.00 9,569.69 100-4470-3630 Training & conferences 500.00 85.14 107.64 17.03%500.00 216.02 100-4470-4010 Rental, equipment 3,880.00 389.41 29.92 10.04%3,810.00 29.92 100-4470-7030 Equipment - - 11,293.11 0.00%11,300.00 11,293.11 100-4470-7050 Construction 125,000.00 9,943.79 28,195.47 7.96%125,000.00 109,658.03 *4470 Total Street Pavement Management 187,340.00 43,529.56 125,329.31 23.24%246,900.00 233,965.10 Snow & Ice Control 100-4472-0100 Salaries, regular 32,150.00 22,866.38 22,092.06 71.12%30,917.00 31,129.37 100-4472-0110 Salaries, overtime 3,515.00 3,850.04 6,309.87 109.53%3,379.00 8,239.00 100-4472-0300 Social Security 4,880.00 2,037.12 2,163.92 41.74%4,572.00 3,011.38 100-4472-0321 PERA coordinated - employer contribution - 1,474.43 1,471.22 0.00%- 2,039.29 100-4472-0400 Health insurance - employer contribution 2,835.00 2,051.32 1,599.39 72.36%2,400.00 2,095.11 100-4472-0410 Life insurance - employer contribution - 399.56 417.07 0.00%- 552.82 100-4472-0420 Dental insurance - employer contribution - 375.76 347.02 0.00%- 479.92 100-4472-0500 Workers compensation 1,465.00 951.71 764.52 64.96%1,372.00 1,076.35 100-4472-1230 Supplies, equipment 2,900.00 938.59 3,925.37 32.37%1,900.00 4,077.94 100-4472-1600 Operating supplies 33,660.00 25,877.07 17,511.81 76.88%21,160.00 34,361.17 100-4472-1700 Motor fuels & lubricants 4,760.00 1,032.22 3,121.89 21.69%3,975.00 4,184.05 100-4472-2400 Uniforms & clothing 1,180.00 780.67 807.02 66.16%900.00 944.81 100-4472-3030 Other professional services 800.00 46.33 5.79%800.00 435.00 100-4472-3610 Memberships 160.00 180.00 135.00 112.50%145.00 135.00 100-4472-3630 Training & conferences 1,600.00 61.38 91.69 3.84%1,100.00 186.50 100-4472-4010 Rental, equipment 500.00 - 16.22 0.00%655.00 16.22 100-4472-7030 Equipment 2,300.00 2,211.11 1,712.75 96.14%4,000.00 1,712.75 *4472 Total Snow & Ice Control 92,705.00 65,133.69 62,486.82 70.26%77,275.00 94,676.68 Page 13 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Street Sign Maintenance 100-4475-0100 Salaries, regular 16,075.00 11,433.05 11,045.67 71.12%15,459.00 15,564.27 100-4475-0110 Salaries, overtime - 330.71 409.69 0.00%- 731.77 100-4475-0300 Social Security 2,200.00 900.02 875.65 40.91%2,063.00 1,250.55 100-4475-0321 PERA coordinated - employer contribution - 649.58 593.45 0.00%- 844.19 100-4475-0400 Health insurance - employer contribution 1,420.00 844.20 701.19 59.45%1,200.00 954.53 100-4475-0410 Life insurance - employer contribution - 188.45 181.79 0.00%- 243.95 100-4475-0420 Dental insurance - employer contribution - 180.75 160.93 0.00%- 221.60 100-4475-0500 Workers compensation 665.00 430.92 351.46 64.80%618.00 491.92 100-4475-1220 Supplies, vehicles 300.00 289.11 186.91 96.37%300.00 186.91 100-4475-1600 Operating supplies 4,000.00 3,579.30 3,130.42 89.48%4,550.00 4,139.08 100-4475-1700 Motor fuels & lubricants 500.00 - 0.00%375.00 - 100-4475-2400 Uniforms & clothing 475.00 149.21 31.41%450.00 218.50 100-4475-3211 Electricity, traffic signals 6,000.00 3,140.46 3,433.00 52.34%7,000.00 5,038.17 100-4475-3630 Training & conferences 500.00 276.90 223.00 55.38%450.00 223.00 100-4475-5130 Repairs, equipment 500.00 - 90.40 0.00%500.00 90.40 *4475 Total Street Sign Maintenance 32,635.00 22,392.66 21,383.56 68.62%32,965.00 30,198.84 Convention & Visitors Bureau 100-4653-3045 Contractual N. Metro Conf Bureau 28,500.00 19,896.90 69.81%- 9,364.62 *4653 Total Convention & Visitors Bureau 28,500.00 19,896.90 69.81%- 9,364.62 Miscellaneous 100-4700-0300 Social Security - 44.66 77.15 0.00%- 103.74 100-4700-0400 Health insurance - employer contribution - 127.91 116.51 0.00%- 291.44 100-4700-0410 Life insurance - employer contribution - 4.06 2.00 0.00%- 2.44 100-4700-0420 Dental insurance - employer contribution - 1.10 12.27 0.00%- 12.27 100-4700-0750 Fitness programs 5,000.00 2,758.38 2,496.61 55.17%4,750.00 4,455.14 100-4700-3065 Contractual youth services 16,435.00 16,432.00 16,082.00 99.98%16,082.00 16,082.00 100-4700-9100 Contingency 85,112.00 - 0.00%50,000.00 - 100-4700-9900 Transfer to Vehicle & Equipment Fund 25,000.00 - 0.00%25,000.00 25,000.00 100-4700-9900 Transfer to Special Projects Fund - - 0.00%1,200,000.00 1,200,000.00 100-4700-9990 Transfer to community center operations 50,000.00 - 0.00%50,000.00 50,000.00 *4700 Total Miscellaneous 181,547.00 19,368.11 18,786.54 10.67%1,345,832.00 1,295,947.03 Debt Service 100-4750-8010 Debt, principal 40,125.00 20,062.50 19,000.00 50.00%38,000.00 38,000.00 100-4750-8020 Debt, interest 18,488.00 9,244.00 15,423.00 50.00%30,846.00 30,846.00 *4750 Total Debt Service 58,613.00 29,306.50 34,423.00 50.00%68,846.00 68,846.00 Total Expenditures 4,555,628.00 2,582,475.99 2,591,651.69 56.69%5,628,615.00 5,144,392.50 Excess of Revenues over(under) Expenditure - (358,721.66) (419,924.65) (1,200,000.00) (537,940.33) Page 14 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Cable TV Revenue 210-3180 Franchise tax 80,000.00 61,248.29 40,854.40 76.56%65,000.00 62,592.41 210-3370 Other local government revenue 2,500.00 - - 0.00%2,500.00 - 210-3610 Interest revenue 5,000.00 - - 0.00%5,000.00 4,872.89 210-3680 Miscellaneous revenue - 50.00 65.00 0.00%- 65.00 Total Revenue 87,500.00 61,298.29 40,919.40 70.06%72,500.00 67,530.30 Expenditures 210-4350-0100 Salaries, regular 43,702.00 2,922.44 1,892.13 6.69%5,000.00 3,232.97 210-4350-0150 Salaries, part-time regular pay 3,520.00 12,501.39 22,760.15 355.15%25,000.00 31,956.84 210-4350-0300 Social Security 6,249.00 1,256.33 1,906.69 20.10%2,698.00 2,664.65 210-4350-0321 PERA coordinated - employer contribution - 673.58 1,077.01 0.00%- 1,537.66 210-4350-0400 Health insurance - employer contribution 6,420.00 892.89 1,638.63 13.91%1,650.00 2,378.02 210-4350-0410 Life insurance - employer contribution - 60.90 40.68 0.00%- 49.68 210-4350-0420 Dental insurance - employer contribution - 42.40 60.10 0.00%- 64.46 210-4350-0500 Workers compensation 198.00 108.54 43.94 54.82%97.00 65.99 210-4350-0990 Severence pay - 723.42 (569.05) 0.00%- 569.05 210-4350-1600 Operating supplies 1,450.00 723.45 1,289.67 49.89%1,450.00 1,520.75 210-4350-3030 Other professional services 3,465.00 0.00% 210-4350-3630 Training & conferences 1,000.00 - 0.00%500.00 907.16 210-4356-3800 Mileage & Parking - 124.56 - 0.00%- - 210-4350-3900 Grants to other organizations 16,500.00 17,411.94 17,275.01 105.53%16,500.00 17,275.01 210-4350-5130 Repairs, equipment 1,500.00 - 460.54 0.00%1,500.00 460.54 210-4350-7030 Equipment 10,000.00 480.63 8,337.52 4.81%15,000.00 9,234.83 Total Expenditures 90,539.00 41,387.47 56,213.02 45.71%69,395.00 71,917.61 Excess of Revenues over(under) Expenditure (3,039.00) 19,910.82 (15,293.62) 3,105.00 (4,387.31) Page 15 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- D.A.R.E. Revenues 220-3511 Controlled substance abuse 2,000.00 930.40 1,006.73 46.52%2,000.00 1,529.08 220-3610 Interest revenue 1,129.00 0.00%1,028.00 1,050.98 220-3650 Donations 500.00 0.00%500.00 220-3680 Miscellaneous revenue 5.00 2,039.50 0.00%- 2,039.50 Total Revenues:3,629.00 935.40 3,046.23 25.78%3,528.00 4,619.56 Expenses 220-4200-1600 Operating supplies 1,500.00 645.53 1,100.94 43.04%1,500.00 2,164.34 220-4200-3030 Other professional services 100.00 200.00 0.00%- 200.00 220-4200-3430 Printing 0.00%100.00 220-4200-3610 Memberships 90.00 35.00 38.89% 220-4200-3630 Training & conferences 500.00 2,302.26 415.98 460.45%500.00 850.98 Total Expenses:2,190.00 2,982.79 1,716.92 136.20%2,100.00 3,215.32 Excess of Revenues over(under) Expenditures:1,439.00 (2,047.39) 1,329.31 1,428.00 1,404.24 Police Grant Revenues 222-3318 Federal police grant 6,311.32 13,081.27 -- 14,829.19 222-3370 Other local government revenue - - -- - 222-3610 Interest revenue - - - -- 493.04 Total Revenues:- 6,311.32 13,081.27 -- 15,322.23 Expenses 222-4200-0100 Salaries, regular - - -- 5,922.11 222-4200-7030 Equipment LLEBG-FY 2000 - 3,166.41 -- 3,166.41 Total Expenses:- - 3,166.41 -- 9,088.52 Excess of Revenues over(under) Expenditures:- 6,311.32 9,914.86 -- 6,233.71 Page 16 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Forfeiture Fund Revenues 225-3514 Forfietures - 230.00 - 0.00%- - 225-3610 Interest revenue - - - 0.00%- 990.42 225-3680 Miscellaneous revenue 2,500.00 2,260.45 3,400.00 90.42%2,500.00 3,997.00 Total Revenues:2,500.00 2,490.45 3,400.00 99.62%2,500.00 4,987.42 Expenses 225-4200-1600 Operating supplies 500.00 9.59 1,872.89 1.92%500.00 2,786.18 225-4200-3030 Other professional services 50.00 627.00 0.00%- 627.00 225-4200-7030 Equipment 2,500.00 0.00%2,500.00 Total Expenses:3,000.00 59.59 2,499.89 1.99%3,000.00 3,413.18 Excess of Revenues over(under) Expenditures:(500.00) 2,430.86 900.11 (500.00) 1,574.24 Economic Development Fund Revenues 230-3359 Other state grants 196,689.00 24,256.00 0.00%- 24,256.00 230-3410 Advertising revenue 750.00 0.00%750.00 230-3425 Remodeling Planbook 948.00 76.00 0.00%- 116.00 230-3610 Interest revenue (1,500.00) 0.00%(1,500.00) 230-3615 Interest received on notes 1,885.92 0.00%1,884.92 230-3635 Residence rental 8,066.00 7,787.50 0.00%- 11,437.50 230-3680 Miscellaneous revenue 3,056.00 28,469.00 0.00%- 40,654.69 230-3911 Sale of assets - 97,395.47 0.00%- 49,639.00 230-3972 Transfer from other funds 483,785.00 0.00%468,650.00 747,873.16 230-3983 Principal repaid on notes 68,338.38 0.00%- 230-3993 Bond proceeds 0.00%- 737,897.02 Total Revenues:483,035.00 306,154.47 130,812.80 63.38%467,900.00 1,613,758.29 Page 17 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Expenses 230-4650-0100 Salaries, regular 78,100.00 50,341.25 45,384.83 64.46%72,085.00 55,413.71 230-4650-0110 Salaries, overtime 1,894.74 0.00% 230-4650-0300 Social Security 10,415.00 4,061.78 3,726.94 39.00%9,610.00 4,433.19 230-4650-0321 PERA coordinated - employer contribution 2,908.62 2,327.22 0.00%- 2,791.92 230-4650-0400 Health insurance - employer contribution 5,400.00 443.67 1,652.63 8.22%4,545.00 1,787.03 230-4650-0410 Life insurance - employer contribution 564.98 412.00 0.00%- 504.72 230-4650-0420 Dental insurance - employer contribution 604.15 210.78 0.00%- 210.78 230-4650-0500 Workers compensation 640.00 413.64 267.25 64.63%590.00 401.35 230-4650-0990 Severand pay 3,164.37 0.00%- 3,164.37 230-4650-1600 Operating supplies 500.00 196.68 0.00%- 329.56 230-4650-1600 Operating supplies House #1 - 0.00%500.00 35.58 230-4650-2100 Books & periodicals 430.00 75.00 75.00 17.44%430.00 75.00 230-4650-3030 Other professional services 140,100.00 33,343.75 73,464.57 23.80%135,600.00 595,132.75 230-4650-3420 Advertising 2,000.00 475.00 0.00%2,000.00 475.00 230-4650-3430 Printing 2,700.00 40.50 298.29 1.50%2,700.00 298.29 230-4650-3610 Memberships 4,650.00 4,304.00 275.00 92.56%4,650.00 275.00 230-4650-3630 Training & conferences 2,950.00 689.28 (40.00) 23.37%2,950.00 396.13 230-4650-3800 Mileage & Parking 150.00 640.46 644.78 426.97%150.00 912.86 230-4650-5210 Housing replacement program 0.00%- 473.43 230-4650-5210 Housing replace - 7861 Groveland 663.21 513.41 0.00%- 2,021.67 230-4650-5210 Housing replace - 3016 Cty Rd H2 1,368.00 150,647.30 0.00%- 150,172.42 230-4650-5210 Housing replacement program House #4 79,769.58 0.00%- 82,119.58 230-4650-5210 Housing replace - 8283 Long Lake Road 20.54 0.00%- 230-4650-5220 Highway 10 redevelopment 14,950.42 38,316.06 0.00%- 78,936.93 230-4650-7050 Construction 210,000.00 165.16 1,545.04 0.08%210,000.00 230-4650-7050 Construction House #2 0.00%- 230-4650-7050 Construction House #3 0.00%- 1,500.00 230-4650-9300 Business loans 25,000.00 0.00%25,000.00 631,897.02 Total Expenses:483,035.00 117,493.15 403,326.73 24.32%470,810.00 1,613,758.29 Excess of Revenues over(under) Expenditures:- 188,661.32 (272,513.93) (2,910.00) - Page 18 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Community Fund Revenues 235-3610 Interest revenue 100,000.00 - 0.00%125,000.00 44,069.94 Total Revenues:100,000.00 - - 0.00%125,000.00 44,069.94 Expenses 0.00% Total Expenses:- - - 0.00%- - Excess of Revenues over(under) Expenditures:100,000.00 - - 125,000.00 44,069.94 Street Lighting Fund Revenues 240-3610 Interest revenue 6,000.00 0.00%5,500.00 6,120.03 240-3716 Penalties & interest 2,000.00 (51.64) (9.79) -2.58%2,700.00 (13.63) 240-3740 Street light charges 50,000.00 41,683.63 41,753.11 83.37%46,800.00 57,465.31 Total Revenues:58,000.00 41,631.99 41,743.32 71.78%55,000.00 63,571.71 Expenses 240-4416-0100 Salaries, regular 1,980.00 1,391.53 1,326.06 70.28%1,905.00 1,895.18 240-4416-0110 Salaries, overtime 5.84 0.00%25.48 240-4416-0300 Social Security 275.00 84.85 81.81 30.85%255.00 119.99 240-4416-0321 PERA coordinated - employer contribution 77.20 68.68 0.00%- 99.49 240-4416-0400 Health insurance - employer contribution 305.00 218.85 189.72 71.75%250.00 256.95 240-4416-0410 Life insurance - employer contribution 1.34 1.29 0.00%- 1.74 240-4416-0500 Workers compensation 10.00 6.64 4.53 66.40%10.00 6.80 240-4416-0990 Severance pay 0.00%47.14 240-4416-3030 Other professional services 150.00 0.00%150.00 240-4416-3210 Electricity 56,700.00 35,889.47 34,016.58 63.30%56,700.00 52,067.65 240-4416-5150 Repairs, utility 15,000.00 1,491.00 2,008.42 9.94%4,500.00 2,227.42 240-4416-7060 Street light installations 8,000.00 3,021.00 46,145.00 37.76%8,000.00 240-4416-7950 Depreciation 8,000.00 0.00%8,000.00 2,718.62 Total Expenses:90,420.00 42,187.72 83,842.09 46.66%79,770.00 59,466.46 Excess of Revenues over(under) Expenditures:(32,420.00) (555.73) (42,098.77) (24,770.00) 4,105.25 Page 19 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Storm Water Fund Revenues 245-3370 Other local government revenue 0.00%12,490.00 245-3610 Interest revenue 25,000.00 0.00%21,000.00 30,267.46 245-3716 Penalties & interest 1,000.00 (103.08) (16.33) -10.31%- (23.71) 245-3730 Surface water charges 100,000.00 74,303.50 74,517.65 74.30%100,000.00 103,224.82 245-3735 Surface water connections 8,000.00 0.00%8,000.00 245-3736 Penalties & interest - 0.00%1,000.00 Total Revenues:134,000.00 74,200.42 74,501.32 55.37%130,000.00 145,958.57 Expenses 245-4415-0100 Salaries, regular 5,225.00 3,707.17 3,585.29 70.95%5,025.00 5,053.89 245-4415-0110 Salaries, overtime 1,045.00 128.76 157.33 12.32%1,005.00 238.71 245-4415-0150 Salaries, part-time regular pay - 108.96 0.00%- - 245-4415-0300 Social Security 460.00 (10.15) (7.18) -2.21%805.00 2.97 245-4415-0321 PERA coordinated - employer contribution 400.00 211.94 193.83 52.99%- 274.15 245-4415-0400 Health insurance - employer contribution 600.00 274.53 221.90 45.76%650.00 301.81 245-4415-0410 Life insurance - employer contribution 85.00 48.11 47.18 56.60%- 63.07 245-4415-0420 Dental insurance - employer contribution 100.00 53.62 47.51 53.62%- 65.50 245-4415-0500 Workers compensation 260.00 170.54 124.80 65.59%240.00 179.35 245-4415-0700 Salaries, on call pay 100.00 0.00%100.00 245-4415-0990 Severance pay 0.00%941.12 245-4415-1230 Supplies, equipment 500.00 366.72 0.00%500.00 363.11 245-4415-1240 Supplies, streets 400.00 0.00%400.00 245-4415-1600 Operating supplies 1,675.00 242.47 368.47 14.48%1,675.00 436.53 245-4415-1700 Motor fuels & lubricants 2,250.00 0.00%1,950.00 3,575.00 245-4415-2400 Uniform & clothing 800.00 833.05 994.40 104.13%700.00 1,278.47 245-4415-3030 Other professional services 16,800.00 5,345.83 4,676.44 31.82%15,800.00 6,913.94 245-4415-3630 Training & conferences 300.00 10.00 3.33%300.00 245-4415-4010 Rental, equipment 220.00 180.85 40.12 82.20%150.00 40.12 245-4415-5150 Repairs, utility 25,000.00 9,748.03 38.99%25,000.00 245-4415-7030 Equipment 5,631.96 0.00%5,400.00 245-4415-7050 Construction 22,011.14 0.00%- 245-4415-7950 Depreciation 0.00%- 12,449.54 Total Surface Water 56,220.00 21,053.71 38,459.91 37.45%59,700.00 32,177.28 245-4417-0100 Salaries, regular 6,030.00 4,277.90 4,137.73 70.94%5,800.00 5,832.29 Page 20 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 245-4417-0110 Salaries, overtime 1,045.00 146.06 257.25 13.98%1,005.00 352.39 245-4417-0150 Salaries, part-time regular pay - 108.96 0.00%- - 245-4417-0300 Social Security 800.00 658.95 629.72 82.37%905.00 877.41 245-4417-0321 PERA coordinated - employer contribution 170.00 244.30 227.62 143.71%- 320.30 245-4417-0400 Health insurance - employer contribution 700.00 316.78 255.97 45.25%750.00 348.24 245-4417-0410 Life insurance - employer contribution 100.00 57.61 60.27 57.61%- 79.30 245-4417-0420 Dental insurance - employer contribution 105.00 62.68 57.45 59.70%- 78.47 245-4417-0500 Workers compensation 295.00 193.78 144.23 65.69%275.00 206.73 245-4417-0700 Salaries, on call pay 150.00 0.00%150.00 245-4417-1230 Supplies, equipment 600.00 126.92 129.53 21.15%600.00 1,016.08 245-4417-1600 Operating supplies 5,500.00 1,640.75 1,982.64 29.83%5,500.00 3,566.17 245-4417-1700 Motor fuels & lubricants 1,975.00 0.00%1,705.00 245-4417-2400 Uniform & clothing 700.00 344.02 86.75 49.15%600.00 269.55 245-4417-3530 Refuse collection 500.00 0.00%500.00 245-4417-3630 Training & conferences 1,200.00 0.00%1,200.00 250.00 245-4417-4010 Rental, equipment 70.00 0.00%70.00 Total Street Cleaning 19,940.00 8,178.71 7,969.16 41.02%19,060.00 13,196.93 Total Expenses:76,160.00 29,232.42 46,429.07 38.38%78,760.00 45,374.21 Excess of Revenues over(under) Expenditures:57,840.00 44,968.00 28,072.25 51,240.00 100,584.36 Park Dedication Fund Revenues 251-3610 Interest revenue 18,600.00 0.00%18,600.00 18,837.56 251-3652 Donations - Park 50,000.00 2,110.00 1,483.00 4.22%50,000.00 93,789.00 251-3680 Miscellaneous revenue 0.00%703.33 Total Revenues:68,600.00 2,110.00 1,483.00 3.08%68,600.00 113,329.89 Expenses 251-4160-1600 Operating supplies - 222.09 0.00%- - 251-4350-7030 Equipment - 0.00%- - 251-4470-7050 Construction 50,000.00 1,608.00 3.22%50,000.00 50,099.29 Total Expenses:50,000.00 1,830.09 - 3.66%50,000.00 50,099.29 Excess of Revenues over(under) Expenditures:18,600.00 279.91 1,483.00 18,600.00 63,230.60 Page 21 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Community Center Operations Recreation Operations (4350) Recreation Revenues 6,850.00 1,662.68 1,952.19 24.27%6,850.00 7,113.83 Recreation Expenditures 9,000.00 14,260.44 6,837.31 158.45%7,000.00 8,393.75 Net Recreation Operations (2,150.00) (12,597.76) (4,885.12) 585.94%(150.00) (1,279.92) Banquet Center (4730) Banquet Revenues 267,860.00 172,807.46 147,811.35 64.51%73,350.00 215,730.04 Banquet Expenditures 258,622.00 184,250.02 127,623.58 71.24%41,230.00 227,197.83 Net Banquet Operations 9,238.00 (11,442.56) 20,187.77 -123.86%32,120.00 (11,467.79) YMCA (4732) YMCA Revenues 73,700.00 19,238.50 22,137.48 26.10%73,700.00 98,074.48 YMCA Expenditures 202,213.00 153,207.21 150,253.86 75.77%205,122.00 238,818.15 Net YMCA Operations (128,513.00) (133,968.71) (128,116.38) 104.25%(131,422.00) (140,743.67) Community Education (4734) Community Ed Revenues 55,728.00 36,647.73 36,070.60 65.76%51,800.00 54,394.47 Community Ed Expenditures 8,360.00 8,087.64 - 96.74%- 153.61 Net Community Ed Operations 47,368.00 28,560.09 36,070.60 60.29%51,800.00 54,240.86 Creative Kids Child Care Center (4736) Creative Kids Revenues 62,935.00 41,952.88 30,052.19 66.66%40,100.00 47,259.02 Creative Kids Expenditures 14,440.00 8,426.90 - 58.36%- 265.30 Net Creative Kids Operations 48,495.00 33,525.98 30,052.19 69.13%40,100.00 46,993.72 Total Revenues 467,073.00 272,309.25 238,023.81 58.30%245,800.00 422,571.84 Total Expenditures 492,635.00 368,232.21 284,714.75 74.75%253,352.00 474,828.64 Net Income (25,562.00) (95,922.96) (46,690.94) 375.26%(7,552.00) (52,256.80) Page 22 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Recreation Operations (4350) Recreation Revenues 252-3610 Interest revenue 2,200.00 0.00%2,200.00 3,355.17 252-3634 Equipment rental 60.00 0.00%- 60.00 252-3650 Donations 300.00 20.00 0.00%300.00 20.00 252-3679 Commission-Vending machines 4,600.00 1,591.34 1,912.59 34.59%4,600.00 2,893.59 252-3680 Miscellaneous revenue 750.00 71.34 (40.40) 9.51%750.00 59.60 252-3681 Sales tax (1,000.00) 0.00%(1,000.00) 252-3685 Insurance Reimbursement #DIV/0!- 725.47 Total Recreation Revenues 6,850.00 1,662.68 1,952.19 24.27%6,850.00 7,113.83 Recreation Expenditures 252-4350-0110 Salaries, overtime (786.75) 0.00%- 252-4350-0300 Social Security 82.62 0.00% 252-4350-0321 PERA coordinated - employer contribution 63.02 0.00% 252-4350-0400 Health insurance - employer contribution 174.63 0.00% 252-4350-0410 Life insurance - employer contribution 1.44 0.00% 252-4350-0500 Workers compensation 284.11 0.00% 252-4350-1210 Supplies, building & grounds 4,000.00 135.89 6,837.31 3.40%2,000.00 8,393.75 252-4350-1600 Operating supplies 933.19 0.00% 252-4350-2400 Uniform & clothing 150.53 0.00% 252-4350-3030 Other professional services 1,812.00 0.00% 252-4350-3100 Telephone 454.08 0.00% 252-4350-3210 Electricity 9,454.32 0.00% 252-4350-3220 Natural gas 202.21 0.00% 252-4350-3530 Refuse collection 296.64 0.00% 252-4350-4800 Insurance & bonds 833.28 0.00% 252-4350-5110 Repairs, buildings & grounds 169.23 0.00% 252-4350-5130 Repairs, equipment 5,000.00 0.00% 252-4350-7030 Equipment - 0.00%5,000.00 Total Recreation Expenditures 9,000.00 14,260.44 6,837.31 158.45%7,000.00 8,393.75 Net Recreation Operations (2,150.00) (12,597.76) (4,885.12) 585.94%(150.00) (1,279.92) Page 23 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Banquet Center (4730) Banquet Revenues 252-3638 Processing fee 25.00 0.00% 252-3639 Security 1,200.00 2,100.00 502.50 175.00%900.00 2,497.50 252-3640 Banquet center-liquor 4,500.00 21,574.93 3,244.39 479.44%4,500.00 20,170.09 252-3641 Banquet center-catering 208,610.00 120,427.71 112,383.91 57.73%16,100.00 153,588.02 252-3642 Banquet center-credit card fees (500.00) 421.30 727.35 -84.26%(500.00) 861.91 252-3644 Banquet center-equipment rental 300.00 4,749.90 217.04 1583.30%300.00 217.04 252-3645 Banquet rental-weekend full 30,000.00 14,684.70 22,730.37 48.95%30,000.00 26,298.37 252-3646 Banquet rental-weekend partial 500.00 1,000.00 125.00 200.00%- 125.00 252-3647 Banquet rental-weekday full 20,100.00 4,170.39 1,375.00 20.75%20,100.00 2,950.00 252-3648 Banquet rental-weekday partial 1,200.00 2,814.41 2,176.74 234.53%- 3,222.04 252-3649 Banquet rental-discount rental 1,950.00 634.12 4,179.05 32.52%1,950.00 5,575.07 252-3651 Banquet rental-weekday; 1/3 room 180.00 0.00%75.00 252-3677 Banquet Center forfietures 25.00 150.00 0.00%- 150.00 Total Banquet Revenues 267,860.00 172,807.46 147,811.35 64.51%73,350.00 215,730.04 Banquet Expenditures 252-4730-0100 Salaries, regular 2,535.92 0.00% 252-4730-0110 Salaries, overtime 278.47 0.00% 252-4730-0150 Salaries, part-time regular pay 4,810.00 13,294.85 7,268.38 276.40%4,810.00 12,169.88 252-4730-0300 Social Security 400.00 902.78 221.23 225.70%- 591.63 252-4730-0321 PERA coordinated - employer contribution 240.00 347.91 11.58 144.96%640.00 150.74 252-4350-0400 Health insurance - employer contribution 539.61 0.00% 252-4350-0410 Life insurance - employer contribution 2.86 0.00%- 252-4730-0500 Workers compensation 210.00 139.45 95.12 66.40%210.00 142.85 252-4730-1140 Miscellaneous office supplies 200.00 106.93 130.17 53.47%200.00 211.19 252-4730-1210 Supplies, building & grounds 750.00 1,826.12 1,052.63 243.48%750.00 1,516.50 252-4730-1230 Supplies, equipment 200.00 0.00%200.00 252-4730-1600 Operating supplies 2,000.00 1,381.13 1,389.43 69.06%2,000.00 2,550.94 252-4730-3030 Other professional services 23,200.00 17,192.02 6,433.72 74.10%22,100.00 28,673.63 252-4730-3037 Contractual - Banquet Center 192,510.00 118,526.07 105,900.93 61.57%167,388.09 252-4730-3100 Telephone 500.00 265.87 53.17%120.00 252-4350-3200 Water & sewer 650.00 623.90 95.98%181.54 252-4350-3210 Electricity 4,615.00 2,239.75 48.53% 252-4350-3220 Natural gas 2,600.00 1,155.79 44.45% 252-4730-3300 Postage 250.00 0.00%250.00 252-4730-3420 Advertising 5,600.00 6,201.90 3,044.27 110.75%4,950.00 5,784.44 252-4730-3430 Printing 1,000.00 2,216.91 592.28 221.69%1,000.00 766.26 252-4350-3530 Refuse collection 585.00 317.28 54.24% 252-4350-3610 Memberships 300.00 0.00%- Page 24 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 252-4730-4010 Rental, equipment 300.00 4,946.93 24.16 1648.98%300.00 79.84 252-4350-4800 Insurance & bonds 572.00 112.19 19.61% 252-4350-5110 Repairs, buildings & grounds 520.00 791.97 152.30% 252-4730-5130 Repairs, equipment 2,860.00 1,950.34 398.92 68.19%1,000.00 1,692.98 252-4730-7030 Equipment 13,750.00 6,353.07 1,060.76 46.20%2,700.00 5,297.32 Total Banquet Center 258,622.00 184,250.02 127,623.58 71.24%41,230.00 227,197.83 Net Banquet Operations 9,238.00 (11,442.56) 20,187.77 -123.86%32,120.00 (11,467.79) Page 25 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- YMCA (4732) YMCA Revenues 252-3405 Recreation - % program profit 3,000.00 0.00%3,000.00 20,375.00 252-3660 Gym & meeting room rental 17,000.00 10,426.50 16,723.75 61.33%17,000.00 20,284.25 252-3661 Open gym participant fees 3,700.00 8,812.00 5,413.73 238.16%3,700.00 7,415.23 252-3972 Transfer from other funds 50,000.00 0.00%50,000.00 50,000.00 Total YMCA Revenues 73,700.00 19,238.50 22,137.48 26.10%73,700.00 98,074.48 YMCA Expenditures 252-4732-0100 Salaries, regular 30,930.00 14,825.47 7,741.21 47.93%27,851.00 20,859.76 252-4732-0110 Salaries, overtime 6,225.00 1,627.81 3,244.82 26.15%1,004.00 4,176.79 252-4732-0300 Social Security 4,085.00 1,030.28 236.47 25.22%3,850.00 1,308.66 252-4732-0321 PERA coordinated - employer contribution 1,000.00 827.60 168.05 82.76%- 216.31 252-4732-0400 Health insurance - employer contribution 3,500.00 3,154.69 520.93 90.13%3,000.00 604.80 252-4732-0410 Life insurance - employer contribution 40.00 16.73 2.15 41.83%- 3.05 252-4732-0500 Workers compensation 1,280.00 559.07 566.20 43.68%1,250.00 850.31 252-4732-1140 Miscellaneous office supplies 300.00 198.47 1,847.95 66.16%300.00 2,025.03 252-4732-1230 Supplies, equipment 500.00 471.69 0.00%500.00 557.78 252-4732-1600 Operating supplies 4,500.00 3,073.37 3,921.47 68.30%4,500.00 6,863.35 252-4732-2400 Uniform & clothing 1,850.00 824.17 744.51 44.55%1,800.00 1,156.70 252-4732-3030 Other professional services 102,425.00 91,541.76 76,013.52 89.37%93,205.00 100,068.91 252-4732-3100 Telephone 2,000.00 1,108.46 1,637.65 55.42%4,512.00 2,513.93 252-4732-3200 Water & sewer 2,850.00 2,735.50 (1,559.36) 95.98%1,400.00 4,866.21 252-4732-3210 Electricity 20,235.00 9,820.28 28,722.43 48.53%34,500.00 42,048.48 252-4732-3220 Natural gas 11,400.00 5,067.51 15,582.77 44.45%16,000.00 18,807.30 252-4732-3420 Advertising 29.50 0.00%- 29.50 252-4732-3530 Refuse collection 2,565.00 2,006.64 3,191.93 78.23%3,550.00 4,081.85 252-4732-3630 Training & Conferences 400.00 0.00%- 252-4732-4010 Rental, equipment 200.00 18.09 9.05%- 252-4732-4800 Insurance & bonds 2,508.00 491.92 2,657.17 19.61%4,200.00 2,657.17 252-4732-5110 Repairs, buildings & grounds 2,280.00 5,568.31 4,512.80 244.22%3,000.00 12,585.51 252-4732-5130 Repairs, equipment 1,140.00 1,791.19 157.12%700.00 12,536.75 252-4732-7030 Equipment 6,919.89 0.00% Total YMCA Expenditures 202,213.00 153,207.21 150,253.86 75.77%205,122.00 238,818.15 Net YMCA Operations (128,513.00) (133,968.71) (128,116.38) 104.25%(131,422.00) (140,743.67) Page 26 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Community Education (4734) 252-3633 Community Education Lease 55,728.00 36,647.73 36,070.60 65.76%51,800.00 54,394.47 Total Community Ed Revenues 55,728.00 36,647.73 36,070.60 65.76%51,800.00 54,394.47 Community Ed Expenditures 252-4734-0100 Salaries, regular 2,145.81 0.00% 252-4350-0110 Salaries, overtime 235.63 0.00% 252-4734-0300 Social Security 149.21 0.00% 252-4350-0321 PERA coordinated - employer contribution 119.77 0.00% 252-4350-0400 Health insurance - employer contribution 456.60 0.00% 252-4350-0410 Life insurance - employer contribution 2.44 0.00% 252-4350-1600 Operating supplies 7.31 0.00% 252-4350-3030 Other professional services 66.00 176.59 267.56% 252-4350-3200 Water & sewer 550.00 527.91 95.98%153.61 252-4350-3210 Electricity 3,905.00 1,895.19 48.53% 252-4350-3220 Natural gas 2,200.00 977.97 44.45% 252-4350-3530 Refuse collection 495.00 268.48 54.24% 252-4350-4800 Insurance & bonds 484.00 94.93 19.61% 252-4350-5110 Repairs, buildings & grounds 440.00 765.96 174.08% 252-4350-5130 Repairs, equipment 220.00 225.50 102.50% 252-4350-7030 Equipment 38.34 0.00% Total Community Ed Expenditures 8,360.00 8,087.64 - 96.74%- 153.61 Net Community Ed Operations 47,368.00 28,560.09 36,070.60 60.29%51,800.00 54,240.86 Creative Kids Child Care Center (4736) 252-3632 Creative Kids Lease 62,935.00 41,952.88 30,052.19 66.66%40,100.00 47,259.02 Total Creative Kids Revenues 62,935.00 41,952.88 30,052.19 66.66%40,100.00 47,259.02 Creative Kids Expenditures 252-4736-3030 Other professional services 114.00 305.03 267.57% 252-4736-3200 Water & sewer 950.00 911.85 95.98%265.30 252-4736-3210 Electricity 6,745.00 3,273.48 48.53% 252-4736-3220 Natural gas 3,800.00 1,689.22 44.45% 252-4736-3530 Refuse collection 855.00 463.72 54.24% 252-4736-4800 Insurance & bonds 836.00 163.97 19.61% 252-4736-5110 Repairs, buildings & grounds 760.00 1,504.25 197.93% 252-4736-5130 Repairs, equipment 380.00 115.38 30.36% Total Creative Kids Expenditures 14,440.00 8,426.90 - 58.36%- 265.30 Net Creative Kids 48,495.00 33,525.98 30,052.19 69.13%40,100.00 46,993.72 Page 27 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Lakeside Park Revenues 255-3370 Other local government revenue 11,626.00 11,626.00 100.00%7,500.00 7,500.00 255-3610 Interest revenue 0.00%- 545.33 255-3650 Donations (20.00) 0.00%- (20.00) 255-3665 Park site rental 305.00 0.00%- 500.00 255-3680 Miscellaneous revenue 150.00 0.00%350.00 150.00 255-3972 Transfer from other funds 11,626.00 11,626.00 100.00%7,500.00 7,500.00 Total Revenues:23,252.00 23,557.00 130.00 101.31%15,350.00 16,175.33 Expenses 255-4350-0100 Salaries, regular 0.00%9,895.00 6,712.93 255-4350-0150 Salaries, part-time regular pay 9,888.00 1,716.00 1,528.00 17.35%- 1,528.00 255-4350-0300 Social Security 756.00 131.29 116.90 17.37%757.00 630.44 255-4350-0500 Workers compensation 238.00 156.46 104.63 65.74%231.00 157.13 255-4350-1210 Supplies, building & grounds 600.00 441.91 73.65%95.00 255-4350-1600 Operating supplies 1,830.00 1,207.93 890.79 66.01%1,125.00 1,070.54 255-4350-2400 Uniform & clothing 0.00%150.00 255-4350-3030 Other professional services 4,452.04 0.00%- 4,452.04 255-4350-3100 Telephone 200.00 308.91 277.19 154.46%250.00 431.62 255-4350-3200 Water & sewer 900.00 210.21 226.16 23.36%917.00 1,130.92 255-4350-3210 Electricity 500.00 360.69 233.43 72.14%500.00 (0.95) 255-4350-3530 Refuse collection 750.00 440.01 124.03 58.67%780.00 276.13 255-4350-3630 Training & conferences 0.00%350.00 255-4350-4010 Rental, equipment 4,500.00 0.00%535.30 255-4350-4030 Satellites 390.00 301.04 527.78 77.19%300.00 255-4350-5130 Repairs, equipment 2,700.00 596.40 22.09% Total Expenses:23,252.00 5,870.85 8,480.95 25.25%15,350.00 16,924.10 Excess of Revenues over(under) Expenditures:- 17,686.15 (8,350.95) - (748.77) Page 28 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Special Projects Revenues 280-3550 Spec Assessmts - prepayments 2,500.00 297.12 1,142.89 11.88%2,500.00 2,629.13 280-3551 Spec Assessmts - current 12,932.38 14,314.34 0.00%- 28,110.56 280-3552 Spec Assessmts - delinquent 1,062.92 630.36 0.00%- 631.62 280-3553 Spec Assessmts - penalty & interest 106.38 89.72 0.00%- 131.96 280-3554 Spec Assessmts - tax forfiet 27.95 0.00%- - 280-3610 Interest revenue 88,000.00 0.00%88,000.00 97,054.68 280-3675 Rentals - 43,000.00 #DIV/0!- - 280-3972 Transfer from General Fund 0.00%1,200,000.00 1,200,000.00 Total Revenues:90,500.00 57,426.75 16,177.31 63.45%1,290,500.00 1,328,557.95 Expenses 280-4160-3030 Other professional services 500.00 382.50 385.00 76.50%500.00 385.00 280-4160-7050 Construction - 31,155.17 - #DIV/0!- - 280-4160-9900 Transfer out 90,000.00 0.00%90,000.00 90,000.00 Total Expenses:90,500.00 31,537.67 385.00 34.85%90,500.00 90,385.00 Excess of Revenues over(under) Expenditures:- 25,889.08 15,792.31 1,200,000.00 1,238,172.95 Street Improvement Funding Revenues 285-3180 Franchise tax 200,000.00 129,524.17 163,218.24 64.76%168,000.00 216,140.32 285-3610 Interest revenue 11,000.00 0.00%11,000.00 13,384.29 Total Revenues:211,000.00 129,524.17 163,218.24 61.39%179,000.00 229,524.61 Expenses Total Expenses:- - - - - Excess of Revenues over(under) Expenditures:211,000.00 129,524.17 163,218.24 179,000.00 229,524.61 Page 29 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Recycling Grant Revenues 290-3360 Other county grants 26,000.00 23,505.83 90.41%26,000.00 1,200.00 290-3610 Interest revenue 0.00%- (137.02) 290-3680 Miscellaneous revenue 0.00%- - Total Revenues:26,000.00 23,505.83 - 90.41%26,000.00 1,062.98 Expenses 290-4420-0100 Salaries, regular 7,760.00 4,478.61 5,304.09 57.71%7,610.00 7,682.48 290-4420-0300 Social Security 565.00 289.26 327.31 51.20%1,015.00 479.95 290-4420-0321 PERA coordinated - employer contribution 500.00 247.23 274.75 49.45%- 397.95 290-4420-0400 Health insurance - employer contribution 685.00 648.86 758.79 94.72%995.00 1,027.65 290-4420-0410 Life insurance - employer contribution 25.00 4.06 5.10 16.24%- 6.84 290-4420-0500 Workers compensation 35.00 23.24 15.85 66.40%35.00 23.80 290-4420-0990 Severence pay 180.31 0.00% 290-4420-3300 Postage 1,450.00 1,373.07 807.36 94.69%1,450.00 807.36 290-4420-3420 Advertising 3,900.00 839.16 2,935.14 21.52%3,900.00 2,935.14 290-4420-3430 Printing 2,600.00 1,976.42 2,480.39 76.02%2,600.00 2,480.39 290-4420-3530 Refuse collection 7,500.00 4,704.00 3,044.00 62.72%7,500.00 5,337.90 290-4420-3960 Awards 1,200.00 750.00 850.00 62.50%1,200.00 1,300.00 Total Expenses:26,220.00 15,514.22 16,802.78 59.17%26,305.00 22,479.46 Excess of Revenues over(under) Expenditures:(220.00) 7,991.61 (16,802.78) (305.00) (21,416.48) Page 30 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TIF District # 1 Revenues 410-3101 Advalorem taxes-Current 989,000.00 539,139.37 848,942.55 54.51%1,413,066.00 1,711,141.51 410-3102 Advalorem taxes-delinquent 628.12 0.00%- (612.27) 410-3610 Interest revenue 56,700.00 0.00%81,000.00 410-3615-300 Interest received on notes Dynex 60.94 0.00%- 60.94 410-3615-302 Interest received on notes Fina 176.90 214.90 0.00%- 255.92 410-3911 Sale of assets 0.00%40,000.00 410-3983-300 Principal repaid on notes Dynex 12,469.77 0.00%12,000.00 12,469.77 410-3983-302 Principal repaid on notes Fina 24,306.00 1,896.34 1,858.34 7.80%12,306.00 2,278.04 Total Revenues:1,070,006.00 541,212.61 864,174.62 50.58%1,558,372.00 1,725,593.91 Expenses 410-4650-3030 Other professional services 300.00 864.98 288.33%12,160.00 191.38 410-4650-3200 Water & sewer 200.00 - 20.54 0.00%- 94.69 410-4650-8010 Debt, principal 1,029,371.89 0.00%996,255.00 1,029,371.89 410-4650-8020 Debt, interest 133,005.00 36,875.01 258,737.43 27.72%214,471.00 238,637.05 410-4650-8030 Paying agent fees 82,564.00 - 375.19 0.00%376,960.00 375.19 410-4650-9900 Transfer to EDA 342,035.00 0.00%468,650.00 373,949.34 410-4650-9900 Transfer to debt service 1,094,968.00 39,983.75 3.65%1,012,562.50 Total Expenses:1,653,072.00 77,723.74 1,288,505.05 4.70%2,068,496.00 2,655,182.04 Excess of Revenues over(under) Expenditures:(583,066.00) 463,488.87 (424,330.43) (510,124.00) (929,588.13) TIF District # 2 Revenues 420-3101 Advalorem taxes-Current 80,000.00 77,010.59 86,992.35 96.26%114,514.00 173,305.49 420-3102 Ad valorem taxes - delinquent 1,794.40 786.47 0.00%- 786.47 420-3610 Interest revenue 5,000.00 0.00%7,200.00 10,158.52 420-3680 Miscellaneous revenue 225.00 100.00 0.00%- 100.00 Total Revenues:85,000.00 79,029.99 87,878.82 92.98%121,714.00 184,350.48 Expenses 420-4650-3030 Other professional services 500.00 369.70 73.94%500.00 220.68 420-4650-8010 Debt, principal 43,815.00 29,817.53 41,037.73 0.00%- 41,037.73 420-4650-8030 Paying agent fees - - #DIV/0!55,048.00 - 420-4650-9900 Transfer to EDA 27,575.00 0.00%- 420-4650-9900 Transfer to debt service 181,024.00 14,466.71 7.99%161,480.99 Total Expenses:252,914.00 44,653.94 41,037.73 17.66%55,548.00 202,739.40 Excess of Revenues over(under) Expenditures:(167,914.00) 34,376.05 46,841.09 66,166.00 (18,388.92) Page 31 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TIF District # 3 Revenues 430-3101 Advalorem taxes-Current 330,000.00 153,418.79 290,336.34 46.49%473,214.00 580,672.67 430-3610 Interest revenue 17,500.00 0.00%25,000.00 8,199.05 Total Revenues:347,500.00 153,418.79 290,336.34 44.15%498,214.00 588,871.72 Expenses 430-4650-3030 Other professional services 500.00 233.28 46.66%500.00 864.90 430-4650-8010 Debt, principal 171,932.00 68,124.42 207,037.08 39.62%163,745.00 207,037.08 430-4650-8020 Debt, interest 4,825.20 53,955.70 0.00%49,410.00 76,162.26 430-4650-8030 Paying agent fees 7,199.00 - 142.31 0.00%13,574.00 142.31 430-4650-9900 Transfer to EDA 114,175.00 0.00%- 373,949.34 430-4650-9900 Transfer to debt service 107,808.00 17,398.29 16.14%194,204.01 Total Expenses:401,614.00 90,581.19 261,135.09 22.55%227,229.00 852,359.90 Excess of Revenues over(under) Expenditures:(54,114.00) 62,837.60 29,201.25 270,985.00 (263,488.18) TIF District # 4 Revenues 440-3101 Advalorem taxes-Current - - -- - 440-3972 Transfer from other funds - - - -- 25.52 Total Revenues:- - - -- 25.52 Total Expenses:- - - -- - Excess of Revenues over(under) Expenditures:- - - -- 25.52 MSA Construction Revenues 499-3610 Interest revenue - - - 0.00%- 8,367.12 Total Revenues:- - - 0.00%- 8,367.12 Expenses 499-4470-3030 Other professional services 255,390.23 46,764.97 0.00%- 58,887.29 499-4470-7050 Construction 9,356.88 0.00%- 10,356.88 Total Expenses:- 255,390.23 56,121.85 0.00%- 69,244.17 Excess of Revenues over(under) Expenditures:- (255,390.23) (56,121.85) - (60,877.05) Page 32 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- TIF Refunding Bonds of 1994B Debt Service Fund Revenues 501-3972 Transfers from other funds 987,160.00 33,580.00 - 3.40%- 909,211.25 Total Revenues:987,160.00 33,580.00 - 3.40%- 909,211.25 Expenses 501-4650-8010 Debt, principal 845,000.00 845,000.00 100.00% 501-4650-8020 Debt, interest 97,972.00 97,791.25 99.82% Total Expenses:942,972.00 942,791.25 - 99.98%- - Excess of Revenues over(under) Expenditures:44,188.00 (909,211.25) - - 909,211.25 TIF Refunding Bonds of 1996A Debt Service Fund Revenues 502-3972 Transfers from other funds 398,730.00 31,865.00 - 7.99%- 355,685.00 Total Revenues:398,730.00 31,865.00 - 7.99%- 355,685.00 Expenses 502-4650-8010 Debt, principal 315,000.00 315,000.00 100.00% 502-4650-8020 Debt, interest 72,550.00 72,550.00 100.00% 502-4650-8030 Paying agent fees 575.00 #DIV/0! Total Expenses:387,550.00 388,125.00 - 100.15%- - Excess of Revenues over(under) Expenditures:11,180.00 (356,260.00) - - 355,685.00 TIF Refunding Bonds of 1996B Debt Service Fund Revenues 503-3972 Transfers from other funds 107,808.00 6,403.75 - 5.94%- 103,351.25 Total Revenues:107,808.00 6,403.75 - 5.94%- 103,351.25 Expenses 503-4650-8010 Debt, principal 95,000.00 95,000.00 100.00% 503-4650-8020 Debt, interest 14,755.00 14,755.00 100.00% Total Expenses:109,755.00 109,755.00 - 100.00%- - Excess of Revenues over(under) Expenditures:(1,947.00) (103,351.25) - - 103,351.25 Page 33 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Vehicle & Equipment Replacement Fund Revenues 640-3610 Interest revenue 38,000.00 0.00%38,000.00 53,477.22 640-3972 Transfer from other funds 85,000.00 0.00%85,000.00 55,000.00 Total Revenues:123,000.00 - - 0.00%123,000.00 108,477.22 Expenses 640-4160-9900 Transfer out 99,500.00 - 0.00%91,600.00 91,600.00 Total Expenses:99,500.00 - - 0.00%91,600.00 91,600.00 Excess of Revenues over(under) Expenditures:23,500.00 - - 0.00%31,400.00 16,877.22 Page 34 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Water Fund Revenues 700-3424 Meter charge 32,989.83 32,556.15 0.00%- 43,942.62 700-3426 Reimbursed staff time 49.02 - 0.00%- - 700-3610 Interest revenue 160,000.00 17.64 0.00%160,000.00 36,938.97 700-3631 Water tower rental 55,000.00 29,302.49 27,122.95 53.28%45,000.00 27,749.95 700-3680 Miscellaneous revenue 6,500.00 800.00 6,874.20 12.31%6,500.00 7,623.24 700-3685 Insurance Reimbursement 11,575.37 0.00%- 3,631.84 700-3710 Water sales 680,000.00 433,121.93 444,263.18 63.69%680,000.00 704,374.82 700-3713 Minn-Safe Water Fee (15.64) (9.53) 0.00%- 1,479.84 700-3714 Water Service Fee 34,880.75 23,188.72 0.00%- 34,753.38 700-3715 Water connections 3,000.00 862.50 1,075.00 28.75%3,000.00 1,475.00 700-3716 Penalties & interest 6,500.00 (215.18) (80.92) -3.31%6,500.00 (182.87) 700-3913 Meter sale 1,000.00 0.00%2,500.00 700-3972 Transfer from other funds 27,000.00 0.00%10,000.00 5,400.00 Total Revenues:939,000.00 543,351.07 535,007.39 57.86%913,500.00 867,186.79 Expenses Administration 700-4820-0100 Salaries, regular 9,820.00 6,929.05 6,382.54 70.56%9,000.00 8,997.27 700-4820-0110 Salaries, overtime 570.00 25.62 4.49%545.00 153.17 700-4820-0300 Social Security 800.00 532.09 488.22 66.51%1,275.00 701.32 700-4820-0321 PERA coordinated - employer contribution 620.00 384.06 330.60 61.95%- 473.96 700-4820-0400 Health insurance - employer contribution 800.00 0.00%750.00 700-4820-0410 Life insurance - employer contribution 85.00 78.76 67.76 92.66%- 94.62 700-4820-0420 Dental insurance - employer contribution 0.00%- 2.14 700-4820-0500 Workers compensation 45.00 29.88 20.39 66.40%45.00 30.62 700-4820-0990 Severence pay 0.00%(10,009.81) 700-4820-1600 Operating supplies 300.00 94.83 0.00%300.00 94.83 700-4820-3030 Other professional services 5,200.00 4,597.92 3,155.36 88.42%4,550.00 5,534.14 700-4820-3300 Postage 2,400.00 1,662.50 1,612.50 69.27%2,400.00 2,137.50 700-4820-3430 Printing 1,500.00 0.00%1,500.00 700-4820-3630 Training & conferences 1,300.00 0.00%1,000.00 700-4820-5130 Repairs, equipment 2,700.00 154.96 731.30 5.74%2,550.00 6,249.32 700-4820-7030 Equipment 4,000.00 0.00%1,500.00 700-4820-8010 Debt, principal 135,000.00 135,000.00 130,000.00 100.00%130,000.00 700-4820-8020 Debt, interest 115,068.00 115,067.50 121,297.50 100.00%121,298.00 118,803.86 700-4820-8030 Paying agent fees 750.00 486.76 486.76 64.90%750.00 486.76 700-4820-9900 Transfer out 79,500.00 0.00%74,500.00 79,500.00 Total Administration 360,458.00 264,949.10 264,667.76 73.50%351,963.00 213,249.70 Page 35 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Utility Distribution 700-4823-0100 Salaries, regular 138,234.00 96,124.58 98,552.86 69.54%141,850.00 134,244.05 700-4823-0110 Salaries, overtime 4,086.00 4,825.62 4,609.54 118.10%3,930.00 6,440.53 700-4823-0150 Salaries, part-time regular pay 8,302.00 15,694.60 16,149.75 189.05%8,300.00 16,149.75 700-4823-0300 Social Security 11,106.00 8,609.67 9,636.92 77.52%20,067.00 12,394.26 700-4823-0321 PERA coordinated - employer contribution 9,000.00 5,734.24 5,318.76 63.71%- 7,262.44 700-4823-0400 Health insurance - employer contribution 17,000.00 9,480.78 8,797.06 55.77%15,612.00 11,572.20 700-4823-0410 Life insurance - employer contribution 785.00 275.04 260.04 35.04%- 338.94 700-4823-0420 Dental insurance - employer contribution 1,000.00 543.42 426.07 54.34%- 579.54 700-4823-0500 Workers compensation 3,022.00 2,855.00 1,472.56 94.47%3,251.00 2,211.46 700-4823-0990 Severence pay 10,445.15 0.00%1,200.00 10,445.15 700-4823-1210 Supplies, building & grounds 4,100.00 866.10 701.57 21.12%4,100.00 731.26 700-4823-1220 Supplies, vehicles 750.00 602.14 233.05 80.29%750.00 559.31 700-4823-1230 Supplies, equipment 1,030.00 73.24 800.19 7.11%1,030.00 876.41 700-4823-1240 Supplies, streets 8,100.00 4,116.34 3,891.49 50.82%8,100.00 5,211.34 700-4823-1250 Supplies, utilities 7,575.00 2,093.99 2,621.71 27.64%7,525.00 5,848.68 700-4823-1260 Supplies, traffic control 200.00 30.00 0.00%200.00 30.00 700-4823-1600 Operating supplies 5,050.00 4,739.31 1,361.94 93.85%3,200.00 4,969.97 700-4823-1700 Motor fuels & lubricants 4,295.00 498.57 1,944.93 11.61%2,235.00 2,187.58 700-4823-2400 Uniform & clothing 1,450.00 1,324.44 1,163.33 91.34%1,300.00 1,632.85 700-4823-3030 Other professional services 11,200.00 1,967.16 3,954.17 17.56%9,850.00 6,405.19 700-4823-3100 Telephone 2,250.00 2,758.10 3,527.60 122.58%2,010.00 5,326.00 700-4823-3200 Water & sewer 134.63 262.00 0.00%- 353.37 700-4823-3210 Electricity 13,237.92 0.00%- 13,237.92 700-4823-3220 Natural gas 9,000.00 4,329.27 7,424.02 48.10%8,800.00 9,205.63 700-4823-3610 Memberships 350.00 311.00 88.86%350.00 700-4823-3630 Training & conferences 2,550.00 840.51 1,782.78 32.96%2,550.00 1,782.78 700-4823-4010 Rental, equipment 1,250.00 912.61 1,793.69 73.01%1,250.00 2,006.52 700-4823-4800 Insurance & bonds 21,000.00 13,641.31 13,285.94 64.96%21,000.00 13,510.94 700-4823-5130 Repairs, equipment 1,400.00 992.18 43.71 70.87%1,400.00 256.77 700-4823-5150 Repairs, utility 29,250.00 17,775.08 1,907.18 60.77%39,250.00 11,676.05 700-4823-5155 Water service repair 17,327.46 27,420.71 0.00%- 45,854.85 700-4823-5160 Repairs, system maintenance 30,000.00 1,987.00 751.13 6.62%28,000.00 30,879.05 700-4823-7030 Equipment 51,000.00 66,481.55 27,025.37 130.36%31,400.00 700-4823-7950 Depreciation 230,000.00 0.00%230,000.00 187,268.56 700-4823-9100 Contingency 15,000.00 0.00%15,000.00 Total Utility Distribution 629,335.00 287,914.94 270,833.14 45.75%613,510.00 551,449.35 Water Production 700-4825-0100 Salaries, regular 20,900.00 14,793.07 14,299.19 70.78%20,100.00 20,173.40 700-4825-0110 Salaries, overtime 1,160.00 1,358.53 1,870.97 117.11%1,115.00 2,553.29 Page 36 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 700-4825-0150 Salaries, part-time regular 1,416.44 0.00% 700-4825-0300 Social Security 1,800.00 1,343.62 1,236.97 74.65%2,830.00 1,738.58 700-4825-0321 PERA coordinated - employer contribution 1,220.00 891.92 837.65 73.11%- 1,177.30 700-4825-0400 Health insurance - employer contribution 1,500.00 1,161.08 949.37 77.41%1,560.00 1,275.61 700-4825-0410 Life insurance - employer contribution 105.00 74.66 77.92 71.10%- 95.83 700-4825-0420 Dental insurance - employer contribution 240.00 178.18 167.07 74.24%- 237.77 700-4825-0500 Workers compensation 500.00 438.67 269.51 87.73%595.00 404.74 700-4825-0700 Salaries, on call pay 200.00 0.00%200.00 700-4825-1600 Operating supplies 22,475.00 9,734.07 12,292.90 43.31%18,250.00 16,678.75 700-4825-1700 Motor fuels & lubricants 5,575.00 292.96 1,895.09 5.25%4,235.00 1,970.43 700-4825-2400 Uniform & clothing 1,070.00 206.03 19.26%1,000.00 216.48 700-4825-3030 Other professional services 10,770.00 4,278.30 8,772.90 39.72%10,770.00 11,649.25 700-4825-3210 Electricity 57,400.00 32,871.71 27,885.49 57.27%55,700.00 45,497.58 700-4825-3630 Training & conferences 800.00 50.00 0.00%800.00 50.00 Total Water Production 125,715.00 69,039.24 70,605.03 54.92%117,155.00 103,719.01 Total Expenses:1,115,508.00 621,903.28 606,105.93 55.75%1,082,628.00 868,418.06 Excess of Revenues over(under) Expenditures:(176,508.00) (78,552.21) (71,098.54) 44.50%(169,128.00) (1,231.27) Water Systems Contributions Revenues 705-3610 Interest revenue 0.00%- 19,519.54 705-3717 WAC charges 2,025.00 2,628.00 0.00%- 4,725.00 705-3718 SWM charges 1,962.23 23,684.72 0.00%- 27,444.40 Total Revenues:- 3,987.23 26,312.72 0.00%- 51,688.94 Expenses Total Expenses:- - - - - Excess of Revenues over(under) Expenditures:- 3,987.23 26,312.72 - 51,688.94 Page 37 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Waste Water Fund Revenues 730-3610 Interest revenue 60,000.00 0.00%65,000.00 98,829.04 730-3680 Miscellaneous revenue 1,500.00 (600.00) 0.00%1,500.00 2,100.00 730-3685 Insurance Reimbursement 0.00%- 3,631.84 730-3716 Penalties & interest (414.87) (134.50) 0.00%- (261.26) 730-3720 Sewer charges 1,185,000.00 866,376.51 857,854.16 73.11%1,185,000.00 1,154,689.67 730-3721 SAC charges 45,483.00 51,841.00 0.00%- (41,206.50) 730-3722 Unit Charge 300.00 300.00 0.00%- 700.00 730-3725 Wastewater connections 2,000.00 287.50 125.00 14.38%2,000.00 225.00 730-3726 Penalties & interest 7,500.00 0.00%7,500.00 730-3728 Contractual Wastewater Service 46,636.89 40,535.65 0.00%- 55,085.43 730-3972 Transfer from other funds 2,500.00 0.00%6,000.00 5,400.00 Total Revenues:1,258,500.00 958,669.03 949,921.31 76.18%1,267,000.00 1,279,193.22 Expenses Administration 730-4820-0100 Salaries, regular 9,820.00 6,954.64 6,382.44 70.82%9,000.00 8,997.11 730-4820-0110 Salaries, overtime 570.00 212.85 116.49 37.34%545.00 305.01 730-4820-0300 Social Security 800.00 546.65 497.30 68.33%1,275.00 713.15 730-4820-0321 PERA coordinated - employer contribution 620.00 395.80 336.62 63.84%- 481.81 730-4820-0400 Health insurance - employer contribution 780.00 49.88 6.39%750.00 12.44 730-4820-0410 Life insurance - employer contribution 100.00 78.70 68.65 78.70%- 95.26 730-4820-0420 Dental insurance - employer contribution 5.00 2.22 0.00%- 3.85 730-4820-0500 Workers compensation 45.00 28.74 18.12 63.87%40.00 27.21 730-4820-0990 Severance pay 0.00%(9,702.82) 730-4820-1600 Operating supplies 300.00 0.00%300.00 730-4820-3030 Other professional services 5,200.00 4,597.93 3,155.37 88.42%4,550.00 4,467.57 730-4820-3300 Postage 2,400.00 1,600.00 1,612.50 66.67%2,400.00 2,200.00 730-4820-3430 Printing 1,500.00 0.00%1,500.00 730-4820-3630 Training & conferences 1,300.00 0.00%1,000.00 730-4820-5130 Repairs, equipment 2,700.00 154.96 231.30 5.74%2,550.00 5,749.32 730-4820-7030 Equipment 1,500.00 0.00%1,500.00 730-4820-9900 Transfer out 53,690.00 0.00%48,690.00 53,690.00 Total Administration 81,330.00 14,620.15 12,421.01 17.98%74,100.00 67,039.91 Page 38 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Utility Distribution 730-4823-0100 Salaries, regular 126,177.00 79,330.22 80,284.20 62.87%130,255.00 105,381.20 730-4823-0110 Salaries, overtime 4,985.00 3,332.01 2,074.60 66.84%4,795.00 3,981.44 730-4823-0150 Salaries, part-time regular pay 4,160.00 3,591.90 86.34%4,160.00 730-4823-0300 Social Security 10,061.00 6,194.11 6,791.45 61.57%18,320.00 8,730.21 730-4823-0321 PERA coordinated - employer contribution 8,200.00 (115.94) (301.49) -1.41%- (185.55) 730-4823-0400 Health insurance - employer contribution 13,580.00 9,222.01 8,967.18 67.91%11,940.00 11,436.78 730-4823-0410 Life insurance - employer contribution 160.00 112.43 83.55 70.27%- 107.90 730-4823-0420 Dental insurance - employer contribution 200.00 151.41 63.58 75.71%- 87.29 730-4823-0500 Workers compensation 2,677.00 1,813.61 1,520.73 67.75%2,835.00 2,358.88 730-4823-0990 Severence pay 70.37 10,996.65 0.00%750.00 13,199.03 730-4823-1210 Supplies, building & grounds 800.00 178.27 66.58 22.28%250.00 116.11 730-4823-1230 Supplies, equipment 4,700.00 433.43 517.75 9.22%4,700.00 517.75 730-4823-1240 Supplies, streets 500.00 0.00%500.00 730-4823-1250 Supplies, utilities 2,400.00 82.12 543.80 3.42%6,100.00 540.19 730-4823-1260 Supplies, traffic control 300.00 0.00%300.00 730-4823-1600 Operating supplies 5,800.00 1,822.70 1,391.64 31.43%5,800.00 1,853.68 730-4823-2400 Uniform & clothing 4,200.00 1,301.07 845.83 30.98%1,980.00 1,218.03 730-4823-3030 Other professional services 3,300.00 266.60 297.60 8.08%3,300.00 686.20 730-4823-3039 Collection expense 3,500.00 0.00%3,500.00 730-4823-3100 Telephone 2,200.00 1,931.19 3,112.11 87.78%1,750.00 4,496.96 730-4823-3200 Water & sewer 298.17 326.98 0.00%- 518.99 730-4823-3210 Electricity 1,600.00 772.05 819.45 48.25%1,500.00 1,142.97 730-4823-3230 Waste water disposal 665,500.00 522,381.00 498,235.31 78.49%635,000.00 614,189.97 730-4823-3231 Waste water charges - other cities 1,250.00 1,690.88 1,962.74 135.27%- 3,397.60 730-4823-3630 Training & conferences 2,250.00 629.00 1,554.45 27.96%2,250.00 1,914.45 730-4823-4010 Rental, equipment 2,440.00 2,146.87 1,628.32 87.99%1,150.00 2,221.90 730-4823-4800 Insurance & bonds 21,000.00 13,641.31 13,285.94 64.96%21,000.00 13,285.94 730-4823-5130 Repairs, equipment 1,445.00 1,776.04 0.00%1,445.00 1,776.04 730-4823-5150 Repairs, utility 4,000.00 866.38 0.00%4,000.00 4,517.48 730-4823-5155 Utility service repair - 4,447.50 - #DIV/0!- - 730-4823-5160 Repairs, system maintenance 65,000.00 13,998.53 8,537.18 21.54%5,000.00 32,863.56 730-4823-7030 Equipment 3,250.00 256.54 6,149.44 7.89%9,400.00 730-4823-7950 Depreciation 148,000.00 0.00%148,000.00 149,493.19 730-4823-9100 Contingency 15,000.00 0.00%15,000.00 Total Utility Distribution 1,128,635.00 669,979.36 652,397.99 59.36%1,044,980.00 979,848.19 Page 39 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Underground Inspection 730-4826-0100 Salaries, regular 76,355.00 39,240.54 48,793.19 51.39%73,430.00 63,221.04 730-4826-0110 Salaries, overtime 5,275.00 2,942.06 3,411.31 55.77%5,075.00 4,775.77 730-4826-0150 Salaries, part-time regular pay 4,160.00 6,203.30 3,747.75 149.12%4,160.00 3,747.75 730-4826-0300 Social Security 4,085.00 3,650.30 4,247.03 89.36%10,785.00 5,423.29 730-4826-0321 PERA coordinated - employer contribution 7,400.00 7,019.32 7,149.09 94.86%- 9,249.94 730-4826-0400 Health insurance - employer contribution 11,000.00 4,752.92 5,672.01 43.21%9,465.00 7,014.61 730-4826-0410 Life insurance - employer contribution 160.00 93.88 91.82 58.68%- 118.28 730-4826-0420 Dental insurance - employer contribution 275.00 160.46 146.01 58.35%- 196.21 730-4826-0500 Workers compensation 1,935.00 1,373.61 1,605.25 70.99%2,325.00 2,585.89 730-4826-0990 Severence pay 121.52 1,286.82 0.00%- 5,239.08 730-4826-1220 Supplies, vehicles 530.00 455.91 79.64 86.02%530.00 470.17 730-4826-1230 Supplies, equipment 2,800.00 41.70 51.91 1.49%2,100.00 820.07 730-4826-1600 Operating supplies 3,050.00 1,021.89 247.02 33.50%3,050.00 366.18 730-4826-1700 Motor fuels & lubricants 10,000.00 5,074.94 839.77 50.75%7,950.00 887.48 730-4826-2400 Uniform & clothing 2,280.00 440.05 1,223.11 19.30%1,880.00 1,575.34 730-4826-3030 Other professional services 750.00 0.00%750.00 730-4826-3630 Training & conferences 1,550.00 300.00 399.95 19.35%1,550.00 399.95 730-4826-5130 Repairs, equipment 2,000.00 2,944.81 199.11 147.24%1,000.00 1,402.98 730-4826-7030 Equipment 7,700.00 13,503.24 175.37%1,000.00 Total Underground Inspection 141,305.00 89,340.45 79,190.79 63.23%125,050.00 107,494.03 Total Expenses:1,351,270.00 773,939.96 744,009.79 57.28%1,244,130.00 1,154,382.13 Excess of Revenues over(under) Expenditures:(92,770.00) 184,729.07 205,911.52 -22,870.00 124,811.09 Page 40 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Golf Course Fund Golf Course Revenues Miscellaneous Revenues 750-3610 Interest revenue 5,000.00 0.00%5,000.00 14,790.71 750-3680 Miscellaneous revenue 3,000.00 33.00 0.00%3,000.00 33.00 750-3681 Sales tax (53,770.00) (31,999.89) (37,757.33) 59.51%(53,770.00) (44,396.99) 750-3685 Insurance Reimbursement 0.00%- 1,281.96 750-3690 Cash over & short (461.23) 77.09 0.00%- (685.35) Total Miscellaneous (45,770.00) (32,461.12) (37,647.24) 70.92%(45,770.00) (28,976.67) Green Fee Revenues 750-3800 Golf course revenue 607,500.00 (99.00) 0.00%640,000.00 (99.00) 750-3800-709 Golf course revenue League Fees 129,323.00 118,933.50 0.00%- 118,933.50 750-3800-711 Golf course revenue Special Events 2,722.00 8,509.67 0.00%- 8,872.17 750-3800-728 Golf course revenue Green Fee Temp 742.00 673.00 0.00%- 3,250.00 750-3800-729 Golf course revenue Fall Rate 0.00%- 26,827.90 750-3800-730 Golf course revenue Pull Cart 5,000.00 2,430.00 3,322.00 48.60%- 3,530.00 750-3800-731 Golf course revenue Power Cart 25,000.00 24,473.40 27,810.00 97.89%- 30,036.00 750-3800-734 Golf course revenue Club Rental 2,500.00 1,092.00 1,491.00 43.68%- 1,708.00 750-3800-750 Golf course revenue Administrative Fee 16,982.62 20,186.03 0.00%- 17,087.78 750-3800-757 Golf course revenue Green Fee Youth Weekend 14,100.00 15,786.00 0.00%- 15,786.00 750-3800-758 Golf course revenue Green Fee Employee 180.00 922.00 0.00%- 968.00 750-3800-760 Golf course revenue Green Fee Weekday 58,317.00 82,058.00 0.00%- 83,654.00 750-3800-761 Golf course revenue Green Fee Senior Weekday 30,554.00 37,944.00 0.00%- 39,564.00 750-3800-762 Golf course revenue Green Fee Weekend 10P 8,998.00 11,708.00 0.00%- 11,774.00 750-3800-763 Golf course revenue Green Fee 2nd Round 2,044.00 2,247.00 0.00%- 2,898.00 750-3800-764 Golf course revenue Green Fee Weekend 108,855.00 137,790.00 0.00%- 137,790.00 750-3800-765 Golf course revenue Green Fee Senior Weekend 17,160.00 23,668.00 0.00%- 23,668.00 750-3800-766 Golf course revenue PC B4 Noon 5,529.00 5,880.00 0.00%- 6,840.00 750-3800-767 Golf course revenue Patron card 2,350.00 3,945.00 0.00%- 3,945.00 750-3800-777 Golf course revenue Handicaps 748.00 1,100.00 0.00%- 1,100.00 Total Gross Green Fees 640,000.00 426,600.02 503,874.20 66.66%640,000.00 538,133.35 Merchandise Revenues 750-3805 Club House Revenue 32,000.00 0.00%100,000.00 750-3805-700 Club House Sox 230.70 398.70 0.00%- 477.90 750-3805-701 Club House Shoes 2,335.50 3,411.25 0.00%- 3,637.45 750-3805-702 Club House Clubs 2,422.70 6,532.30 0.00%- 7,123.25 750-3805-703 Club House Sweater 2,568.80 3,267.35 0.00%- 4,182.65 750-3805-704 Club House Shirts 1,127.65 2,649.15 0.00%- 3,586.90 750-3805-705 Club House Balls 4,711.36 7,417.20 0.00%- 8,487.96 750-3805-706 Club House Gloves 3,793.95 4,826.70 0.00%- 5,089.35 750-3805-707 Club House Caps 1,661.64 2,685.53 0.00%- 2,972.39 Page 41 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 750-3805-708 Club House Grips 298.70 620.20 0.00%- 632.20 750-3805-725 Club House Gift Certificates 45.00 0.00%- - Total Gross Merchandise Revenues 32,000.00 19,196.00 31,808.38 59.99%100,000.00 36,190.05 750-3805-Club House Merchandise Cost of sales (20,700.46) 0.00%- (1,387.23) Merchandise Net Revenues 32,000.00 (1,504.46) 31,808.38 -4.70%100,000.00 34,802.82 Food Revenues 750-3805-739 Club House Food Department 68,000.00 4,541.40 5,430.75 6.68%- 5,685.00 750-3805-741 Club House Tees 451.35 646.75 0.00%- 690.75 750-3805-742 Club House Jar Balls 1,035.80 1,035.03 0.00%- 1,177.03 750-3805-745 Club House Pop machine 1,376.50 2,288.50 0.00%- 2,462.25 750-3805-746 Club House Employee Pop 530.00 619.00 0.00%- 756.25 750-3805-747 Club House Employee Food 1,017.40 870.30 0.00%- 1,004.80 750-3805-748 Club House Coffee 263.75 351.50 0.00%- 396.25 750-3805-749 Club House Hot Cocoa 54.00 39.75 0.00%- 61.25 750-3805-789 Club House Employee Merchandise 2,999.05 7,766.78 0.00%- 8,308.58 750-3805-790 Club House Beer 7,155.50 8,946.02 0.00%- 9,815.17 750-3805-791 Club House Bottled Pop 12,156.77 13,449.30 0.00%- 14,109.80 750-3805-792 Club House Wine Cooler 958.05 699.75 0.00%- 753.75 750-3805-793 Club House Cappuccino 24.75 35.25 0.00%- 39.00 750-3805-794 Club House Merchanise 1,243.39 1,125.56 0.00%- 1,188.77 750-3805-795 Club House Candy 1,139.75 1,207.42 0.00%- 1,300.92 750-3805-796 Club House Chips 390.00 471.00 0.00%- 520.50 750-3805-799 Club House Beverage Cart 18,593.26 28,698.75 0.00%- 29,205.00 Total Gross Food Revenues 68,000.00 53,930.72 73,681.41 79.31%- 77,475.07 750-3805-800 Club House Beverage Cost of sales (21,312.15) 0.00%- (1,387.23) Net Food Revenues 68,000.00 32,618.57 73,681.41 47.97%- 76,087.84 Driving Range Revenues 750-3810 Driving range income 150,000.00 0.00%150,000.00 750-3810-718 Driving range income Token #3 32,960.00 39,515.00 0.00%- 40,745.00 750-3810-719 Driving range income Token #2 46,452.00 60,427.50 0.00%- 63,451.50 750-3810-720 Driving range income Token #1 15,290.00 17,894.00 0.00%- 19,094.00 750-3810-723 Driving range income H.S. Round 746.00 1,416.00 0.00%- 1,488.00 750-3810-724 Driving range income H.S. Bucket 1,212.00 1,570.00 0.00%- 2,178.00 750-3810-725 Driving range income Gift Certificate (5,512.42) (6,276.61) 0.00%- (8,127.01) 750-3820 Golf lessons 23,000.00 15,333.50 13,474.00 66.67%23,000.00 13,499.00 Total Driving Range 173,000.00 106,481.08 128,019.89 61.55%173,000.00 132,328.49 Total Gross Revenues:867,230.00 573,746.70 699,736.64 66.16%867,230.00 755,150.29 Total Cost of Sales - (42,012.61) - - (2,774.46) Total Net Revenues 867,230.00 531,734.09 699,736.64 867,230.00 752,375.83 Page 42 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Expenses Golf Course Operations 750-4900-0100 Salaries, regular 379,381.00 13,996.39 20,299.67 3.69%379,381.00 27,941.55 750-4900-0101 Salaries, reg-other 31,005.44 38,292.94 0.00%- 45,978.94 750-4900-0110 Salaries, overtime 1,304.16 5,012.57 0.00%- 6,460.53 750-4900-0150 Salaries, part-time regular pay 50,756.58 55,767.55 0.00%- 71,663.88 750-4900-0152 Salaries,PT reg-other 254.25 2,139.80 0.00%- 2,139.80 750-4900-0300 Social Security 7,448.46 9,117.62 0.00%- 11,028.19 750-4900-0321 PERA coordinated - employer contribution 4,041.34 4,954.04 0.00%- 6,608.14 750-4900-0400 Health insurance - employer contribution 3,645.67 1,144.83 0.00%- 1,184.08 750-4900-0410 Life insurance - employer contribution 57.82 46.46 0.00%- 46.81 750-4900-0420 Dental insurance - employer contribution 384.66 763.73 0.00%- 1,060.83 750-4900-0500 Workers compensation 879.07 0.00%- - 750-4900-0600 Unemployment 3,416.00 0.00%- - 750-4900-0990 Severence pay 6,116.71 0.00%- (7,190.54) 750-4900-1210 Supplies, building & grounds 21,000.00 29,309.82 15,485.97 139.57%21,000.00 25,969.55 750-4900-1220 Supplies, vehicles 15,400.00 5,260.81 11,831.58 34.16%14,000.00 13,675.23 750-4900-1230 Supplies, equipment 3,200.00 221.96 4,559.26 6.94%3,000.00 4,824.53 750-4900-1600 Operating supplies 8,500.00 3,187.45 5,293.70 37.50%8,000.00 6,053.43 750-4900-1700 Motor fuels & lubricants 9,000.00 3,933.98 4,967.87 43.71%8,100.00 5,710.56 750-4900-2400 Uniform & clothing 3,500.00 1,049.50 2,631.03 29.99%3,500.00 3,411.44 750-4900-3030 Other professional services 16,200.00 41,151.47 52,979.19 254.02%7,700.00 79,333.64 750-4900-3100 Telephone 500.00 3,588.74 1,166.11 717.75%500.00 2,902.82 750-4900-3210 Electricity 4,250.00 4,553.53 6,679.98 107.14%4,000.00 8,554.55 750-4900-3530 Refuse collection 1,100.00 399.86 660.97 36.35%1,000.00 982.30 750-4900-3610 Memberships 600.00 368.00 95.00 61.33%1,200.00 95.00 750-4900-3630 Training & conferences 1,200.00 10.00 997.92 0.83%3,400.00 1,039.92 750-4900-4010 Rental, equipment 3,000.00 1,106.52 0.00%3,000.00 1,106.52 750-4900-4030 Satellites 1,800.00 1,518.90 (284.80) 84.38%1,800.00 459.40 750-4900-4800 Insurance & bonds 2,000.00 789.08 1,265.33 39.45%2,000.00 1,265.33 750-4900-5110 Repairs, buildings & grounds 12,000.00 4,710.03 4,382.85 39.25%12,000.00 4,685.12 750-4900-5130 Repairs, equipment 9,000.00 3,534.58 4,127.34 39.27%8,500.00 7,071.79 750-4900-7010 Buildings 1,500.00 40.23 2.68%3,000.00 750-4900-7030 Equipment 40,000.00 36,739.31 91.85%35,000.00 750-4900-7050 Construction 25,000.00 88.18 0.00%25,000.00 750-4900-7070 Landscaping 7,500.00 514.77 0.00%9,500.00 750-4900-7950 Depreciation 120,000.00 0.00%95,000.00 107,227.74 750-4900-7955 Amortization of bond discount 4,811.00 0.00%4,811.00 4,811.00 750-4900-8010 Debt, principal 120,000.00 0.00%85,000.00 Page 43 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 750-4900-8020 Debt, interest 196,145.00 87,070.60 89,323.13 44.39%200,650.00 210,237.66 750-4900-8030 Paying agent fees 400.00 386.76 580.14 96.69%410.00 580.14 750-4900-9150 Unreimbursed insurance claims 0.00%3,000.00 750-4900-9900 Transfer out 15,000.00 0.00%3,000.00 Total Golf Course Operations 1,021,987.00 351,131.16 345,991.25 34.36%946,452.00 656,919.88 Club House Operation 750-4901-0100 Salaries, regular 34,612.19 23,992.95 0.00%- 33,239.20 750-4901-0110 Salaries, overtime 28.98 1,503.40 0.00%- 1,503.40 750-4901-0150 Salaries, part-time regular pay 24,105.10 14,778.43 0.00%- 19,952.24 750-4901-0300 Social Security 4,093.91 2,895.02 0.00%- 3,705.67 750-4901-0321 PERA coordinated - employer contribution 2,438.57 1,837.03 0.00%- 2,375.54 750-4901-0400 Health insurance - employer contribution 4,443.78 3,827.58 0.00%- 5,171.88 750-4901-0410 Life insurance - employer contribution 25.94 26.10 0.00%- 34.80 750-4901-0500 Workers compensation 1,006.39 0.00%- - 750-4901-0600 Unemployment 2,688.00 0.00%- - 750-4901-0990 Severence pay 0.00%- - 750-4901-1210 Supplies, building & grounds 46,000.00 4,099.20 72,049.47 8.91%61,000.00 78,868.19 750-4901-1230 Supplies, equipment 2,000.00 4,368.50 0.00%2,000.00 4,368.50 750-4901-1600 Operating supplies 9,200.00 3,893.42 7,716.92 42.32%9,100.00 8,349.52 750-4901-2400 Uniform & clothing 1,000.00 314.85 0.00%1,500.00 508.35 750-4901-3030 Other professional services 9,150.00 7,129.54 3,044.77 77.92%7,800.00 6,347.77 750-4901-3100 Telephone 5,000.00 1,488.47 2,082.16 29.77%6,500.00 2,142.01 750-4901-3200 Water & sewer 1,000.00 654.50 626.50 65.45%1,000.00 786.89 750-4901-3210 Electricity 4,500.00 4,012.12 4,894.75 89.16%4,500.00 6,455.87 750-4901-3220 Natural gas 2,000.00 522.82 830.09 26.14%1,000.00 942.23 750-4901-3300 Postage 800.00 105.35 13.17% 750-4901-3420 Advertising 6,000.00 3,330.93 6,238.34 55.52%10,000.00 6,238.34 750-4901-3430 Printing 6,000.00 1,560.67 26.01% 750-4901-3450 Advertising-Chartiable Contributions 0.00%500.00 750-4901-3530 Refuse collection 1,200.00 452.22 1,106.00 37.69%1,200.00 1,483.82 750-4901-3610 Memberships 1,560.00 819.00 1,877.05 52.50%2,000.00 1,670.05 750-4901-3630 Training & conferences 1,000.00 5,093.87 0.00%7,000.00 5,093.87 750-4901-4800 Insurance & bonds 5,400.00 5,805.56 3,416.38 107.51%5,400.00 3,661.38 750-4901-5110 Repairs, buildings & grounds 1,500.00 363.84 940.96 24.26%4,500.00 947.93 750-4901-5130 Repairs, equipment 1,000.00 257.06 25.71%1,000.00 99.50 750-4901-7030 Equipment 1,011.80 0.00%1,000.00 750-4901-7050 Construction 0.00%10,000.00 Total Club House Operation 104,310.00 107,937.56 164,472.92 103.48%137,000.00 193,946.95 Page 44 Y-T-D Y-T-D 2002 Year-end 2002 Sept Sept % Spent/2001 2001 Account#Account Title Budget 2002 2001 Received Budget Actual ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Practice Range - Course Design/Construction 750-4902-0100 Salaries, regular 2,310.00 0.00%- 2,310.00 750-4902-0110 Salaries, overtime 780.12 0.00%- 780.12 750-4902-0150 Salaries, part-time regular pay 11,932.20 0.00%- 11,932.20 750-4902-0300 Social Security 1,149.25 0.00%- 1,149.25 750-4902-0321 PERA coordinated - employer contribution 406.81 0.00%- 406.81 750-4902-1210 Supplies, building & grounds 1,500.00 0.00%1,500.00 750-4902-1220 Supplies, vehicles 1,000.00 205.27 2,687.09 20.53%1,000.00 2,687.09 750-4902-1600 Operating supplies 7,500.00 5,425.64 7,867.03 72.34%7,500.00 10,906.28 750-4902-3210 Electricity 2,000.00 0.00%2,000.00 750-4902-5130 Repairs, equipment 0.00%5,000.00 - 750-4902-7030 Equipment 0.00%5,000.00 750-4903-0100 Salaries, regular 0.00%20,000.00 750-4903-0500 Workers compensation - 1,087.10 0.00%2,400.00 1,632.58 750-4903-1210 Supplies, building & grounds 0.00%4,000.00 750-4903-1220 Supplies, vehicles 0.00%2,000.00 750-4903-1700 Motor fuels & lubricants 0.00%1,500.00 750-4903-5130 Repairs, equipment 0.00%1,000.00 750-4903-7030 Equipment 0.00%500.00 Total Course Design/Construction 12,000.00 5,630.91 28,219.60 46.92%53,400.00 31,804.33 Total Expenses:1,138,297.00 464,699.63 538,683.77 40.82%1,136,852.00 882,671.16 Excess of Revenues over(under) Expenditure (271,067.00) 67,034.46 161,052.87 -24.73%(269,622.00) (130,295.33) Item No. 7G Type of Business: CB WK: Work Session; PH: Public Hearing; CA: Consent Agenda; CB: Council Business City of Mounds View Staff Report To: Honorable Mayor and City Council From: Greg Lee, Director of Public Works Item Title/Subject: 2003 Street Improvement Project Resolution No. 5870 Authorizing the preparation of a Preliminary Feasibility Report and Consultant Selection for the 2003 Street Improvement Project Meeting Date: October 28, 2002 Background: At the October Work Session, Council directed staff to proceed with a street improvement project to be implemented during the 2003 construction season. The streets to be considered for this project are those contained in the area bounded by County Road 10 to the north and east, County Road H2 to the south, and the Pleasant View Drive to the west. Discussion: Preliminary Report - The first step in a public improvement process is the preparation of a preliminary engineering report. It is recommended that the preliminary report be ordered at this time to determine the need and feasibility, both physical and economic, of providing the necessary public improvements. Consultant Selection – There are several engineering consultants within the City’s “consultant pool” from whom services could be obtained. Staff has interviewed two of these firms and found one to be best able to implement a project of this nature and serve the City’s needs. Staff recommends that the Council retain the services of the engineering firm of Bonestroo, Rosene, Anderlik, and Associates (BRAA) to assist in the preparation of the preliminary engineering report and other aspects of this project, as directed by City Council. Recommendation: It is recommended the City Council adopt a resolution authorizing the preparation of a preliminary feasibility report and the selection of a consultant for the 2003 Street Improvement Project. Respectfully Submitted, Greg Lee, Director of Public Works RESOLUTION NO. 5870 AUTHORIZING THE PREPARATION OF A PRELIMINARY FEASIBILITY REPORT AND CONSULTANT SELECTION FOR THE 2003 STREET IMPROVEMENT PROJECT CITY OF MOUNDS VIEW COUNTY OF RAMSEY STATE OF MINNESOTA WHEREAS, on October 7, 2002 at a Council Work Session, City Council expressed a desire to initiate a street improvement project for the 2003 construction season; and WHEREAS, the streets to be considered for this project are those contained in the area bounded by County Road 10 to the north and east, County Road H2 to the south, and the Pleasant View Drive to the west; and WHEREAS, there are several engineering consultants within the City’s “consultant pool” from whom services could be obtained; and WHEREAS, staff recommends that the Council retain the services the engineering firm of Bonestroo, Rosene, Anderlik, and Associates (BRAA) to assist in the preparation of the preliminary engineering report and other aspects of this project, as directed by City Council. NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Mounds View, Ramsey County, Minnesota as follows: 1. It is hereby authorized that the preliminary report for the 2003 Street Improvement Project be prepared. Said preliminary report shall include an analysis as to whether the proposed improvements are necessary, cost effective and feasible. 2. The services the engineering firm of Bonestroo, Rosene, Anderlik, and Associates (BRAA) shall be retained to assist in the preparation of the preliminary engineering report and other aspects of this project, as directed by City Council. Adopted this 28th day of October 2002. ________________________________ Richard Sonterre, Mayor ATTEST: ________________________________ Kathleen F. Miller, City Administrator Motion by: Second: Sonterre: Stigney: Quick: Marty: Thomas: Item No. 7I Type of Business: CB WK: Work Session; PH: Public Hearing; CA: Consent Agenda; CB: Council Business City of Mounds View Staff Report To: Honorable Mayor and City Council From: Greg Lee, Director of Public Works Item Title/Subject: 2002 Well Rehabilitation Project Resolution No. 5872 Waive Public Improvement Hearing Order the Project Authorize the preparation of Plans and Specifications Meeting Date: October 28, 2002 Background: The City of Mounds View has a total of six wells, with one of the wells (well number 4) out of commission since 1992 due to poor water quality. To properly maintain the wells, the pumps and other equipment must be periodically evaluated, inspected, and repaired or replaced. The City established a maintenance program whereby the wells would be evaluated and rehabilitated on a seven-year cycle. A longer period of eleven years was tried; however, it was discovered that this period was too long to identify minor problems and correct them before they became major replacements. Discussion: Wells Number 1 and 2 were last rehabilitated in 1995. Based on the seven-year evaluation schedule, they are therefore due for rehabilitation this year. Wells Number 3 and 5 were last done in 1997 and are scheduled for rehabilitation in 2004. The 2002 adopted budget has a total of $30,000 for well inspection and preventative maintenance. Typically, this is the amount needed to rehabilitate one well. Past practice has been to rehabilitate two wells per contract. Economy of scale is realized due to the reduced cost of administrating two separate projects. A larger project also improves the possibility of receiving favorable bids. Given this, staff recommends that two wells be rehabilitated in 2002. To fund the additional well, staff recommends that funds from the water repairs account (700- 4823-5150) be utilized. A line item exists in this account for the water tower inspection and rehabilitation. With the water tower project rescheduled for 2003, staff recommends that these funds be allocated to a well rehabilitation project this year and the water tower rehabilitation project be fully budgeted in the proposed 2003 budget – in the amount of $35,000. This proposal would also reduce a peak in the 2003 budget by avoiding the rehabilitation of the water tower and two wells all in one year. Preliminary Report - Based upon the nature of this project, the preparation of a preliminary engineering report will neither be necessary nor feasible. Waive Public Improvement Hearing – Financing for the 2002 Well Rehabilitation Project, which is comprised of Wells Number 1 and 2, will be derived entirely from the City of Mounds View Enterprise Fund. Because assessments are not a funding source, City staff is requesting that the public improvement hearing be waived. Ordering of Project – Should the Council wish to proceed with this project, the next step in the public improvement process is to order the project. Authorize Plans and Specifications – In an effort to reduce costs, staff will be developing the specifications. Staff recommends that plans and specifications be ordered at this time. What’s Next – Should the Council want to proceed with this project, the following is a tentative schedule for this project: November 12th Approve plans and specifications November 12th Set a December 3rd bid date November 20th & 27th Advertise bids December 3rd 10:00 a.m. Receive bids December 9th Award contract December 9th Start project February 28th 2003 Complete project Recommendation: It is recommended the City Council adopt a resolution ordering the project and authorizing the preparation of plans and specifications for the 2002 Well Rehabilitation Project. Respectfully Submitted, Greg Lee, Director of Public Works RESOLUTION NO. 5872 ORDER THE PROJECT, AUTHORIZE THE PREPARATION OF PLANS AND SPECIFICATIONS FOR THE 2002 WELL REHABILITATION PROJECT CITY OF MOUNDS VIEW COUNTY OF RAMSEY STATE OF MINNESOTA WHEREAS, the City established maintenance program whereby the wells would be evaluated and rehabilitated on a seven-year cycle; and WHEREAS, Wells Number 1 and 2 were last rehabilitated in 1995; and WHEREAS, staff recommends that two wells be rehabilitated in 2002 and that they be funded utilizing funds from the system maintenance account (700-4823-5160) and the water repairs account (700-4823-5150) the funds of which accounts were allocated to the water tower rehabilitation project; and WHEREAS, the financing for this project will be derived entirely from the City of Mounds View Enterprise Fund and that assessments are not a funding source. NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Mounds View, Ramsey County, Minnesota as follows: 1. Said improvements are hereby ordered and shall hereafter be known and referred to as the 2002 Well Rehabilitation Project. Said ordering of the improvements shall be valid for a period of eighteen (18) months from the date of adoption of this resolution. 2. It is hereby ordered that the 2002 Well Rehabilitation Project shall be made without a public hearing being that the entire cost of said improvements shall be funded through the City of Mounds View Enterprise Fund. 3. That the preparation of the construction plans and specifications for the 2002 Well Rehabilitation Project is hereby authorized. Adopted this 28th day of October 2002. ________________________________ Richard Sonterre, Mayor ATTEST: ________________________________ Kathleen F. Miller, City Administrator Motion by: Second: Sonterre: Stigney: Quick: Marty: Thomas: Item No. 07J Type of Business: CA WK: Work Session; PH: Public Hearing; CA: Consent Agenda; CB: Council Business City of Mounds View Staff Report To: Mayor and City Council From: Nyle Zikmund, Fire Chief Item Title/Subject: Resolution 5880 - Purchase of Used Mini-Pumper Meeting Date: October 28, 2002 Background: In August of this year the department experienced an unpredictable and sudden loss of all (3 individuals) of our daytime fire responders assigned to Station Four. Station Four provides primary protection to the east side of Blaine and NE portion of Mounds View. The three volunteers were supplemented with up to ten available Blaine City employees who are also responding members of the fire department. Recruitment efforts began immediately and included a mailing to approximately 1,000 residents in close proximity to the station, front page articles in the last two issues of the city newsletter, word of mouth, and advertising on the cable channel. To date we have received two contacts, neither of which submitted applications. Station Four historically experiences about 45 emergency runs during the weekday. Of these, a structure fire occurs about once every other year and we respond to upwards of a dozen crash rescue personal injury crashes. The remaining calls are car fires, grass fires, smoke in the area, alarms and the like. Options: Administrative and volunteer met to determine and explore all options. These numbered close to ten and were narrowed to six viable for the purpose of discussion. They include; closing the station, full time staff, duty crew, duty staff, relocating an engine to Blaine City Hall, and purchase of a mini- pumper to be housed at Blaine City Hall. Discussion: Recruitment has historically been difficult and is not unique to Blaine or the Station Four area. Had the cities not embraced the cooperative efforts of allowing certain employees to respond we would have staffing issues at all stations. Even if successful in recruitment, the nature of the volunteer service is the same problem could reoccur without notice or warning. Closing the station is not a practical solution, staffing of the stations is, and especially in this situation given the call volume, a very inefficient use of taxpayer resources, and relocation of an engine is not possible without construction of a heated garage area large enough. Purchase of a mini-pumper in combination of automatic mutual aid on all working structure fires allows us to provide similar or better protection to the true emergencies (structure fires and personal injury). A mini-pumper will fit into heated garage space already present in the police department. Given the ten city employees who respond and additional individual working across Radisson in an Industrial Operation we have eleven readily available long term staff members to respond. The combination of the current fiscal situation and low call volume also allows us to consider the purchase of a used unit which is unprecedented in the history of our operation. Recommendation: Purchase a used mini-pumper and house the unit at Blaine City Hall. While not readily available on the market, a nearby suburban department has a 1997 unit priced at $68,000. The unit has less than 8,000 miles, does fit into the facility, and is rigged with all emergency devices and radios. The fire department will use existing reserves to purchase the necessary loose equipment such as hose, rescue equipment, first aid supplies and the like. Financing: The City of Blaine will finance the purchase of the unit. Bob Therres has checked with their bond council (Jim Omera) who has informed him that all cities will be able to repay the debt outside of levy limits. Blaine will use existing reserves to purchase the unit now and issue the debt along with other capital purchase items next year. They intend to make a fund transfer at their November 7, 2002 Council meeting. The certificate of indebtedness will not occur until after the first of the year causing repayment to occur no sooner than 2002. Blaine has offered to cover all administrative expenses and provide repayment either in a single lump sum or over a five year period in five equal installments. Additionally, given the 2004 repayment the figure can become part of the fire department capital budget so it is integrated into the overall cost. Formula distribution based upon $68,000 purchase price: Blaine = $49,442 Mounds view = $11,200 Spring Lake Park = $7,358 Respectfully Submitted, ___________________________ Nyle Zikmund Fire Chief RESOLUTION NO. 5880 CITY OF MONDS VIEW COUNTY OF RAMSEY STATE OF MINNESOTA RESOLUTION APPROVING PURCHASE OF FIRE APPARTUS WHEREAS, The Spring Lake Park – Blaine – Mounds View Fire Department provides fire protection services to the cities comprising the department’s name on and; WHEREAS, Those services are detailed and set forth in a jointly signed contract with the fire department and three cities and; WHEREAS, The cities of Spring Lake Park, Blaine, and Mounds View enjoy financial control and oversight of the fire department and its operating and capital budget under the terms of the contract and within parameters established by a Joint Powers Agreement signed by the three cities and; WHEREAS, The Fire Department has proposed a need to purchase a mini-pumper in order to provide adequate and reliable emergency response to portions of the fire district and; WHEREAS, The Joint Powers Agreement sets forth Mounds Views portion of the purchase, estimated to be $68,000, at $11,200 with the City of Blaine financing the initial purchase with reimbursement to not occur before 2004 NOW, THEREFORE BE IT RESOLVED that the Mounds View City Council does hereby support the purchase of the mini-pumper at the estimated price of $68,000 with the Mounds View share equaling $11,200 and repayment to commence to the City of Blaine no sooner than January 1, 2004. Presented this 28th day of October, 2002. (ATTEST) ____________________________________ Rich Sonterre, Mayor (SEAL) ____________________________________ Kathleen F. Miller, City Administrator Motion By: Second By: Sonterre: Quick: Stigney: Thomas: Marty: RESOLUTION NO. 5866 CITY OF MOUNDS VIEW COUNTY OF RAMSEY STATE OF MINNESOTA RESOLUTION OF APPRECIATION TO DAN COUGHLIN WHEREAS, Dan Coughlin has served on the Mounds View Park and Recreation Commission; and WHEREAS, Mr. Coughlin has gained the respect and gratitude of those who have had the privilege of working with him on the Park and Recreation Commission. NOW, THEREFORE, BE IT RESOLVED that the City Council of the City of Mounds View, on behalf of the residents of the City of Mounds View, expresses its appreciation to Dan Coughlin for his dedicated and devoted service on the Mounds View Park and Recreation Commission. Adopted this 28th day of October, 2002. ATTEST: Mayor Rich Sonterre Councilmember Quick Councilmember Stigney Councilmember Thomas Councilmember Marty City Administrator Miller (SEAL) Motion by: Quick Second by: Thomas Sonterre: Aye Quick: Aye Stigney: Aye Thomas: Aye Marty: Aye RESOLUTION NO. 5865 CITY OF MOUNDS VIEW COUNTY OF RAMSEY STATE OF MINNESOTA RESOLUTION OF APPRECIATION TO MARK POTHEN WHEREAS, Mark Pothen has served on the Mounds View Park and Recreation Commission; and WHEREAS, Mr. Pothen has gained the respect and gratitude of those who have had the privilege of working with him on the Park and Recreation Commission. NOW, THEREFORE, BE IT RESOLVED that the City Council of the City of Mounds View, on behalf of the residents of the City of Mounds View, expresses its appreciation to Mark Pothen for his dedicated and devoted service on the Mounds View Park and Recreation Commission. Adopted this 28th day of October, 2002. ATTEST: Mayor Rich Sonterre Councilmember Quick Councilmember Stigney Councilmember Thomas Councilmember Marty City Administrator Miller (SEAL) Motion By: Quick Second By: Thomas Sonterre: Aye Quick: Aye Stigney: Aye Thomas: Aye Marty: Aye RESOLUTION NO. 5864 CITY OF MOUNDS VIEW COUNTY OF RAMSEY STATE OF MINNESOTA RESOLUTION APPOINTING A CHAIR AND VICE-CHAIR FOR THE CITY OF MOUNDS VIEW PARK AND RECREATION COMMISSION WHEREAS, members of the Park and Recreation Commission shall consist of nine members of the resident population of Mounds View; and WHEREAS, based upon the recommendation of the Park and Recreation Commission the City Council shall appoint a Chairperson and Vice-chairperson; and WHEREAS, the Park and Recreation Commission has sent forward a recommendation to appoint Mike Szczepanski as Chairperson and John Kroeger as Vice-chairperson. NOW, THEREFORE, BE IT RESOLVED that the Mounds View City Council does hereby certify the appointment of Mike Szczepanski as Chairperson and John Kroeger as Vice- chairperson of the Park and Recreation Commission. Adopted this 28th day of October, 2002 ATTEST: _______________________________ Richard Sonterre, Mayor (SEAL) _______________________________ Kathleen Miller, City Administrator Motion By: Second By: Sonterre: Quick: Stigney: Thomas: Marty: PROCEEDINGS OF THE MOUNDS VIEW CITY COUNCIL CITY OF MOUNDS VIEW RAMSEY COUNTY, MINNESOTA Regular Meeting October 14, 2002 Mounds View City Hall 2401 Highway 10, Mounds View, MN 55112 7:00 P.M. 1. MEETING IS CALLED TO ORDER 2. ROLL CALL: Sonterre, Quick, Marty, Stigney, and Thomas. 3. APPROVAL OF AGENDA A. Monday, October 14, 2002 City Council Agenda. Community Development Director Ericson asked to have item 8C removed from the Agenda as it is not ready at this time. Assistant City Administrator Reed asked whether Council would prefer to move the department quarterly reports to Council Business rather than the reports section of the meeting. Council agreed to move the quarterly reports to Council Business. Mayor Sonterre indicated there would be no item 11. City Administrator Miller asked that a discussion of scheduling a meeting to canvass the November 5, 2002 election results be added under Council Business. MOTION/SECOND: Marty/Stigney. To Approve the October 14, 2002, City Council Agenda as amended. Ayes - 5 Nays – 0 Motion carried. 4. PUBLIC INPUT David Jahnke of 8428 Eastwood Road said he had watched the work session and is concerned about appointing elected officials to the cable commission because he is afraid of politics going back into it. He then said that he is concerned about the budget as the time to approve the budget is approaching and he has heard of no further meetings to discuss reducing the numbers. He also said he would like to have each department come to Council with ways to cut budgets in light of difficult economic times. Mounds View City Council October 14, 2002 Regular Meeting Page 2 Mayor Sonterre indicated that each department head has been asked to find ways to cut costs and he then noted that there is an item on the agenda to schedule a work session to discuss budgets. City Administrator Miller indicated that she and the finance director are going through the department budgets line item by line item and meeting with each department head. Mr. Jahnke indicated he was concerned that the budget would be pushed late and before any discussion could take place Council would be forced to approve it. Council Member Quick asked someone to comment on the constraints that the state has put on the City. Mayor Sonterre noted that, due to aid to local government, the City maximized the levy as its initial levy statement and that has the City going backwards $41,000 from the current year’s budget. He then commented that the City not only needs to be wary of where it is spending dollars the City needs to go back $41,000 from the 2002 budget to hit the maximum dollar amount allowed by the state. Council Member Quick commented that anytime there is a zero increase in the budget you take inflation from the year before and that is the amount that the budget has been diminished. He further commented that a 3% inflation means there is a 3% decrease in the budget. He also commented that there were three positions removed from the budget. Mr. Jahnke said he commended Council for being more fiscally accountable in the past year. Council Member Stigney commented that the positions are in the budget even if they are not used so there is still an increase. Council Member Quick commented that any money left would go into the different funds but the City is backing up a minimum of 3%. Council Member Stigney said he disagreed because last year’s budget had funds for three positions so you still have the money from those three positions. He then said that he does not feel that last year’s budget was as fiscally responsible as it could be. City Administrator Miller clarified that the positions that were not filled are not in the proposed budget for next year. Jerry Skelly of 7095 Knollwood Drive addressed Council and commented as to the cable committee and his presence as cable commissioner from Mounds View. He then explained how the committee has worked over the years and noted that he has always been answerable to the City as he was appointed by the City Council. Mounds View City Council October 14, 2002 Regular Meeting Page 3 Mr. Skelly indicated that for years he made reports to City Administrators, Mayors, and Council and, as time passed, the City began televising cable commission meetings and created a City Administrator Advisory Committee that fed information into the Commission as well as providing abundant information to the cities. He then said that he wanted it to be clear to Council and the residents that he did not just wander over there and start attending meetings, he was appointed by the City. Mr. Skelly indicated the local committee has no connection with CTV other than all of the volunteer work that is done. He then said he made a mistake at the last meeting when he suggested that only three cities had non-elected officials because in reality, all but four had non- elected officials in the early days. Mr. Skelly commended the Charter Commission for providing a profound election forum. Barbara Haake of 3024 County Road I addressed Council and discussed the differences between a committee and commission. Ms. Haake provided handouts to Council. Ms. Haake clarified that the committee has never been paid and is not asking to ever be paid. She then noted the cable committee does have a budget that comes from the citizen subscriber fees. Ms. Haake recommended that Council keep the committee a committee and offered to meet with Council at a work session to discuss the matter. 5. JUST AND CORRECT CLAIMS Council Member Stigney asked what the commission dinner charge was for. City Administrator Miller indicated that item was cancelled. Council Member Stigney asked for clarification on the batteries plus charge as it seems the City uses a lot of batteries. Finance Director Hansen indicated he was not sure which batteries were in which vehicles but said he does know the City has a number of vehicles as well as things like emergency lights in buildings. He then invited Council Member Stigney to stop by his office to view the invoices for further information. Council Member Stigney asked why the City purchased ant killer if the City has an exterminator. Public Works Director Lee explained that Will Kill has a contract for pest control at City Hall and the Community Center and the supplies purchased were for some park buildings. Council Member Marty asked whether the City of Fridley residents were billed for water and sewer provided by the City. Mounds View City Council October 14, 2002 Regular Meeting Page 4 Finance Director Hansen explained that Fridley bills Mounds View for the services and Mounds View bills the residents. Council Member Marty commented that there was an invoice from Kennedy & Graven for the Kessel matter in the amount of $3,680, the Hammerschmidt matter for $5,907and the AFSCME matter for $256.00. He then asked for an explanation of the other claim. City Attorney Riggs indicated the matter was a claim being defended by the League of Minnesota Cities. Council Member Marty commented that the total to Kennedy & Graven was $22,000. Council Member Marty noted there was a charge of $530 for the City Administrator and the Assistant City Administrator to attend a seminar. City Administrator Miller clarified that the seminar is in town. Mayor Sonterre clarified that half of the $22,000 is to be reimbursed as part of the agreement on the golf course billboard matter. He then said that the approximate remaining amount of $11,000 is high but not as shocking as the $22,000. Council Member Marty asked whether the costs for a temporary employee were for the temporary police department employee and Finance Director Hansen indicated that was correct. Council Member Marty asked what Staff was doing to ensure that the City is reimbursed when there is not a closing. Community Development Director Ericson explained that Staff has put some language in the development application to make it clearer that the developer will be responsible for charges incurred as a result of the application being processed. Council Member Marty questioned the $432.00 on the SAC fee matter. Finance Director Hansen explained that the SAC fee of $43,000 was paid but there remains $432.00 in administrative costs yet to be paid on the matter. Council Member Stigney asked what the $409.50 to ECM publishers was for. Finance Director Hansen explained that the Community Center has been experimenting with different types of advertising to see if bookings increase. Council Member Stigney asked if advertising is in the budget for the Community Center. Mounds View City Council October 14, 2002 Regular Meeting Page 5 Finance Director Hansen indicated that the Community Center budget does contain funds for advertising. MOTION/SECOND: Marty/Stigney. To Approve Just and correct Claims as Presented. Ayes – 5 Nays – 0 Motion carried. 6. CONSENT AGENDA A. Licenses for Approval B. Set a Public Hearing for 7:05 p.m., Monday, October 28, 2002, to Consider a Conditional Use Permit request for Automotive Repair at 2135 Program Avenue, Site of the Wash-Me Car Wash C. Resolution No. 5859 Approving the Contract Award for the Upgrade of the City Hall Sump Pumps D. Resolution 5855 Approving the 2003 SCORE Recycling Grant Request to Ramsey County Council Member Stigney requested that Item C be removed for discussion. MOTION/SECOND: Quick/Marty. To Approve Consent Agenda Items A, B, and D as Presented. Ayes – 5 Nays – 0 Motion carried. MOTION/SECOND: Quick/Thomas. To Approve Consent Agenda Item C as Presented. Council Member Stigney said he was curious as to why he had not heard about a City Hall sump pump over the course of the last six years and now it is suddenly an issue. Public Works Director Lee said he was not sure why the sump pump was not addressed by previous Staff but said he feels the matter should be dealt with as each time the fuses are blown it costs the City $300.00. Ayes – 5 Nays – 0 Motion carried. 7. COUNCIL BUSINESS A. Consideration of Resolution 5857, a Resolution Approving a Development Review for SYSCO Minnesota. Planner Atkinson explained that SYSCO Minnesota was proposing two separate expansions totaling 36,300 additional square feet but the expansion would bring no additional employees so parking would not be affected. He then noted that all requirements were reviewed by Staff and Staff recommends approval of the request. Mounds View City Council October 14, 2002 Regular Meeting Page 6 Mayor Sonterre asked if Staff had any information on the approval of the drainage by Rice Creek. Planner Atkinson indicated that Staff had not yet heard from Rice Creek on the matter but said that any approval would be contingent upon approval from Rice Creek Watershed District. MOTION/SECOND: Quick/Marty. To Waive the Reading and Approve Resolution 5857, a Resolution Approving a Development Review for SYSCO Minnesota. Ayes – 5 Nays – 0 Motion carried. B. Resolution 5861 Authorizing the Expansion of Administrative Offenses to Specific Minor Moving Traffic Violations. Deputy Chief Brennan briefly explained the proposed Resolution. Council Member Stigney indicated that prior to the meeting someone asked him whether noise violations could be handled in this manner. Deputy Chief Brennan indicated the Code addresses loud parties and said that the police department usually addresses loud mufflers with court citations as the City does not use fix it tickets. He further explained that administrative offenses are used for loud parties. Council Member Marty indicated he had been asked by several residents if there was anything the City could do with regard to the use of Jake brakes coming into town on County Road I. Deputy Chief Brennan indicated he had seen that type of sign posted in other communities. Council Member Thomas indicated she had previous conversations with Community Development Director Ericson and understands that the City has no control of the state highway. Council Member Marty asked Staff to look into it and bring the matter back to a work session. Mayor Sonterre suggested using the information sharing list through the League of Minnesota Cities for possible assistance with more information and City Administrator Miller indicated she had the information and would provide it to Deputy Chief Brennan. Mayor Sonterre clarified that Resolution 5861 was amended to read 1988 not 1998. MOTION/SECOND: Marty/Stigney. To Waive the Reading and Approve Resolution 5861, a Resolution Authorizing the Expansion of Administrative Offenses to Specific Minor Moving Traffic Violations. Ayes – 5 Nays – 0 Motion carried. Mounds View City Council October 14, 2002 Regular Meeting Page 7 C. Resolution No. 5860, a Resolution Authorizing the Execution of a Joint Powers Agreement with Ramsey County for Improvement of the Rice Creek North Regional Trail Corridor on County Road H from Old Highway 8 to Edgewood Drive. Public Works Director Lee explained that on September 23, 2002 Council approved Change Order Number 1 authorizing the construction of a pathway contingent upon entering into a joint powers agreement with the County. He then indicated that the City would construct the pathway at a cost of approximately $55,000 and the County would then submit a request for regional park funds to the Metropolitan Council in an effort to reimburse the City. He further explained that there is no guarantee of reimbursement but it looks promising. MOTION/SECOND: Quick/Marty. To Waive the Reading and Approve Resolution No. 5860, a Resolution Authorizing the Execution of a Joint Powers Agreement with Ramsey County for Improvement of the Rice Creek North Regional Trail Corridor on County Road H from Old Highway 8 to Edgewood Drive. Council Member Thomas asked Staff to take measures to ensure the safety of children during the construction of the path. Public Works Director Lee said he did not think there would be conflict with the children and the construction because the construction is between four and ten feet back from the curb. T Council Member Thomas indicated she would encourage hazard fencing. Public Works Director Lee indicated that construction times could be specified to address the safety issues. Council Member Quick suggested contacting the County to close that section completely during the construction. Ayes – 5 Nays – 0 Motion carried. Council Member Quick asked Staff to notify Edgewood that construction would be starting. D. Consideration and First Reading of Ordinance 705, an Ordinance Amending Title 100, Chapter 105 of the Mounds View Municipal Code by Amending Section 105.03 as to the Compensation of the Mayor and Council Members in the City of Mounds View. City Administrator Miller indicated that at the October work session Council Member Stigney had suggested looking at the Mayor and Council salaries as they were last reviewed in July of Mounds View City Council October 14, 2002 Regular Meeting Page 8 1993. She then indicated that, after review, Staff has determined that changing the wages would require amending the Code. City Administrator Miller explained that Council Member Stigney had suggested looking at the increases that were given to staff members for those years. She then indicated that she and the Finance Director had provided a proposed increase based on a total compound increase of 31.04%. The Mayor’s salary would increase to $6,683.04 and Council salary would increase to $5,896.80. Council Member Thomas indicated that the personnel manual covers employees and not Council. She then said that the Charter and City Code govern the salary of Council and the Mayor and not the personnel manual. She further stated that she finds it odd to be considering a pay increase for Council when faced with an economic struggle. Council Member Stigney indicated the reason the question came up is because there has not been an increase since 1993. He then indicated that other cities, including Vadnais Heights, had recently increased salary for Council. He also indicated he would prefer to round the numbers off rather than use the odd amounts suggested. City Administrator Miller indicated she had provided in the packet a copy of the Association of Municipalities Salary Survey done in 2002 so that Council could review the average salaries of cities the same size as Mounds View. Council Member Quick asked for a five-minute recess. Council recessed at 8:10 p.m. Council reconvened at 8:15 p.m. Council Member Stigney suggested using a rounded figure such as an increase of $50, $75, or $100 per month. Council Member Marty asked how far off that suggestion would be from the averages for the other cities the same size as Mounds View. Mayor Sonterre indicated the average would require an increase of $96.00 per month for the Mayor and $44.00 for Council. Council Member Quick suggested $6,500 for Mayor and $5,500 for Council. Council Member Stigney suggested increasing both salaries by the same amount. City Administrator Miller indicated the same percentage was applied to the Mayor and Council positions. She then suggested rounding the figures provided by Staff up or down. Mounds View City Council October 14, 2002 Regular Meeting Page 9 Council Member Marty indicated he puts in a lot of time into reading information and attending events in addition to the Council meetings and, since there has been no increase since 1993, he feels it is time for an adjustment. Council Member Quick moved approval of the Ordinance with the increases changed to $100.00 for Mayor and Council Members. MOTION/SECOND: Quick/Stigney. To Waive the First Reading and Introduce the First Reading of Ordinance 705, an Ordinance Amending Title 100, Chapter 105 of the Mounds View Municipal Code by Amending Section 105.03 as to the Compensation of the Mayor and Council Members in the City of Mounds View as Amended. ROLL CALL: Stigney/Quick/Thomas/Marty/Sonterre. Ayes – 4 Nays – 1(Thomas) Motion carried. E. Consideration and First Reading of Ordinance 706, and Ordinance Amending Title 400, Chapter 401 of the Mounds View Municipal Code by Amending Section 401.02 Subdivision 1 as to the Membership of the Planning and Zoning Commission. City Administrator Miller explained that at the September work session Council discussed membership of the Commissions and heard from the Staff liaisons that it would be preferable to reduce the Commission members from 9 to 7 and the attached Ordinance would do that. MOTION/SECOND: Marty/Stigney. To Waive the Reading and Introduce the First Reading of Ordinance 706, and Ordinance Amending Title 400, Chapter 401 of the Mounds View Municipal Code by Amending Section 401.02 Subdivision 1 as to the Membership of the Planning and Zoning Commission. Council Member Thomas asked if there would be a way to increase the number to 9 if there were suddenly more interest in serving. Mayor Sonterre commented that it takes weeks to get one applicant but, if there is a situation where the City has numerous applicants, Council could revisit the matter and consider increasing the size of the Commissions. Council Member Marty pointed out that during the debate it was stated that this action had already been taken and that was not the case. Mayor Sonterre indicated he may have done so. City Administrator Miller clarified that it was the consensus of Council to reduce the numbers and was merely a matter of Staff bringing the Ordinance to Council for approval. Mounds View City Council October 14, 2002 Regular Meeting Page 10 Ayes – 5 Nays – 0 Motion carried. F. Consideration and First Reading of Ordinance 707, an Ordinance Amending Title 400, Chapter 405 of the Mounds View Municipal Code by Amending Section 405.02 Subdivision 1 as to the Appointment of Members of the Parks and Recreation Commission. MOTION/SECOND: Stigney/Marty. To Waive the Reading and Introduce the First Reading of Ordinance 707, an Ordinance Amending Title 400, Chapter 405 of the Mounds View Municipal Code by Amending Section 405.02 Subdivision 1 as to the Appointment of Members of the Parks and Recreation Commission. Ayes – 5 Nays – 0 Motion carried. G. Police Department Quarterly report Deputy Chief Brennan provided a brief overview of his quarterly report noting that the report spans the months of June through September. Deputy Chief Brennan reviewed the community events the police department has been involved with during the last quarter. Deputy Chief Brennan reviewed the training conducted during the last quarter. Deputy Chief Brennan reviewed equipment purchased and being used by the police department. Deputy Chief Brennan reviewed the grants that the police department continues to benefit from. Deputy Chief Brennan noted will need to replace the records management software. Deputy Chief Brennan noted that, after more than a year of investigation, the police were able to identify the person responsible for several assaults and he was arrested in New Brighton. He then indicated that, on August 12, 2002, police department representatives and the Ramsey County Health Department held a community forum at Townsedge Manufactured Home Park and it was a positive step toward addressing problems with the residents. Deputy Chief Brennan reviewed arrest and citation statistics with Council. Deputy Chief Brennan mentioned that officers are getting called to theft from autos on a regular basis and then stressed that residents should keep their eyes open and, if they see kids out after curfew, call the police to check it out. Mounds View City Council October 14, 2002 Regular Meeting Page 11 Council Member Stigney asked if there would be any chance of obtaining grant money for the MDC units. Deputy Chief Brennan indicated he is not a member but went to the National Chief’s Conference and had the opportunity to discuss grant availability and found that there is currently no funding at this time but said he would continue to monitor for funds. Council Member Stigney asked Deputy Chief Brennan to check where the bullet proof vests came from because he saw something on the news about vests from one of the large manufactures, possibly in Florida, failing. Deputy Chief Brennan indicated he would check on the department’s vests but said that any vests purchased would have to meet NIJ standards. Council Member Marty asked how many of the traffic tickets issued were for actual moving violations. Deputy Chief Brennan indicated he had run a report but said that he had not had time to analyze the numerous pages of detail. He then said that approximately 10% of the offenses are administrative offenses. Council Member Quick asked if the police department does any kind of radar patrol or speeding patrol on Long Lake Road in the vicinity of County Road H after school. Deputy Chief Brennan indicated that the officers are attempting to concentrate a presence at the school when not on a call. He then said that he knows that the area does get a lot of attention as he has seen radar logs. Council Member Marty indicated he had spoken to Deputy Chief Brennan concerning New Brighton setting up speed stops and was told that New Brighton has laser. He then asked how much it would cost the City for laser equipment. Deputy Chief Brennan indicated that the cost would be $5,000 to $6,000 per unit. Council Member Marty asked if there are grants available for the purchase of laser equipment. Deputy Chief Brennan indicated that New Brighton had won their unit through a drawing with the safe and sober program. Council Member Marty indicated he thought the City should have another AED unit to be able to keep one at the Community Center and one at the golf course and those in the squad cars. Deputy Chief Brennan indicated the units are nice to have but cautioned that the shelf life on the batteries is approximately18 months and the batteries are $200 each time so the City does not Mounds View City Council October 14, 2002 Regular Meeting Page 12 want to have too many units but four may be nice so one could be placed at the Community Center. Council Member Thomas asked how often they are used. Deputy Chief Brennan indicated they are deployed frequently but are not actually used for shocking very often. Council Member Thomas indicated she was not sure why the City would need anything more than four since the Community is relatively small. Mayor Sonterre commented that 85% of the children attending Sunnyside live in Mounds View but the area is predominantly patrolled by New Brighton. He then said that he is concerned with the absolute failure of motorists to obey the law with regard to pedestrian crossings. Council Member Quick asked if the department uses the unmarked vehicle for patrol. Deputy Chief Brennan indicated that since the unmarked squad was involved in an accident a number of years ago the policy has been not to use it as it does not have the same level of emergency lighting as the regular squads do. Mayor Sonterre asked if the unmarked squad would be adequately set up for speed patrol. Deputy Chief Brennan indicated that the unmarked vehicle could make traffic stops but said that it would not participate in pursuits once the marked squads have joined in. H. Community Development Quarterly Report Community Development Director Ericson provided a brief overview of his quarterly report. Community Development Director Ericson reviewed the third quarter budget figures with Council. Community Development Director Ericson provided Council with a development update. Council Member Stigney asked if the figures include TIF districts. Community Development Director Ericson indicated the funds were from building permit applications. Council Member Marty asked for clarification on the code violation information. Community Development Director Ericson explained that the first column indicates whether the code violation was proactive, meaning something the City found, or whether it was something complaint based. Mounds View City Council October 14, 2002 Regular Meeting Page 13 Council Member Marty asked if the City fines for code violations. Community Development Director Ericson indicated Staff could do an administrative offense or a court citation and there are pros and cons to both scenarios based upon the situation. Council Member Marty asked if the City receives funds to cover costs in the court citation issues. Community Development Director Ericson indicated the City does get something back but it does not cover the costs. Council Member Marty commented that NHHI had come to Council a few months ago for some assistance to write letters and asked if that issue had been resolved. Community Development Director Ericson indicated that NHHI did not request anything but Accessible Space Incorporated had come to Council and that is an affiliation of NHHI. Council Member Thomas commented that Colonial Craft must be the as of yet unnamed organization coming to the business park. Community Development Director Ericson indicated that Staff felt comfortable naming the business now because there was a recent article in the Twin Cities Business Journal concerning the move to Mounds View. Community Development Director Ericson provided Council with an overview of redevelopment activity in the City. Community Development Director Ericson provided Council with an overview of the housing activity in the City. Council Member Quick left the meeting at 9:29 p.m. Community Development Director Ericson indicated the Metropolitan Council would be having a meeting on October 16, 2002 on Blueprint 2030. Council Member Quick returned at 9:34 p.m. Council Member Thomas suggested putting the local police department telephone number on the City’s website. She then mentioned that residents could contact the Housing Resource Center for assistance with purchasing and installing insulating windows in an attempt to insulate from the noise of the highway while the City works on the sound wall issue. Council Member Marty asked City Administrator Miller to put item 4F on the next work session to discuss the back rent issue. He then thanked Mr. Ericson for getting the minutes and agendas on the website. Mounds View City Council October 14, 2002 Regular Meeting Page 14 Mayor Sonterre indicated that the Housing Resource Center is located in Shoreview and said that residents could go there for information. He then commented on the Blueprint 2030 and said he has attended four meetings and encouraged others to attend, if for no other reason, to see someone else in the hot seat. Council recessed at 9:38 p.m. Council reconvened at 9:44 p.m. 8. SPECIAL ORDER OF BUSINESS A. Resolution 5844 Approving a Seasonal Ice Rink Maintenance Position Assistant City Administrator Reed indicated this item was before Council at a previous work session as requested by the Public Works Director. She then read Resolution 5844. MOTION/SECOND: Quick/Marty. To Approve Resolution 5844, a Resolution Approving a Seasonal Ice Rink Maintenance Position. Mayor Sonterre asked how many hours per week the person would work. Public Works Director Lee indicated it would range from 20 to 40 hours based on need. Ayes – 5 Nays – 0 Motion carried. B. Resolution 5862 Establishing a Wage for the Former Clubhouse Clerk Assistant City Administrator Reed indicated that this item was discussed a number of times in closed session and the issue is that in 2001 the City Council abolished a three tired payment plan for those that gave golf course lessons and directed Staff to create a job description that included golf course lessons and operational duties. She then indicated that Labor Relations recommended 122 pay points with a maximum of $15.56 per hour for 2001. Assistant City Administrator Reed indicated that the City has been in discussions with AFSCME and they are looking at this situation differently than the City. She then indicated that it was the recommendation of Staff based on input from Council to set the wage at Step 2 effective June 16, 2001 through October 11, 2001 when he left employment with the City. MOTION/SECOND: Quick/Thomas. To Approve Resolution 5862, a Resolution Establishing a Wage for the Former Clubhouse Clerk. Assistant City Administrator Reed read Resolution 5862. Mounds View City Council October 14, 2002 Regular Meeting Page 15 Council Member Marty said he found it unacceptable that the City has not paid this individual for five months worth of pay from 2001. He then said that it seems to him that previously some of the information that was provided to Council, such as the Hayes points, have been adjusted and readjusted and he has seen this position in a memo linked to other positions in the City and he does not understand why this has been all over the board and the City has not paid for over a year. Assistant City Administrator Reed clarified that, as stated in the Staff report, this was an issue City Staff brought to Council in August of 2001 but AFSCME had asked that it be taken off the agenda until the contract was negotiated. She further clarified that the only reason this is back on the agenda is because Staff put it on the table during the last day of negotiations. She also noted that AFSCME is under the impression that the City was to negotiate an actual dollar per hour wage although there is nothing in state statute and nothing in the contract requiring the City to do so. Assistant City Administrator Reed indicated that Staff has spent a number of weeks explaining the City’s position and direction was given unanimously to establish the wage at Step 2 and that is what is before Council. Council Member Quick indicated he remembered when Council agreed to hold off on this at AFSCME’s urging the question was asked of the employee if that person was okay with holding off and he had said he was. He then said he is glad the matter is being resolved. City Administrator Miller emphasized that while AFSCME asked the City not to deal with this until the contract was negotiated, they never placed the matter on the table, the City did so on the final day of negotiations. Ayes – 4 Nays – 1(Marty) Motion carried. 9. REPORTS A. Schedule of Additional Work Session for the Budget Finance Director Hansen suggested using Monday, October 21, 2002 as a budget work session meeting. There was consent to discuss the general fund budget on October 21, 2002 at 6:00 p.m. There was consent to discuss the rest of the funds on November 6, 2002 at 6:00 p.m. B. Consider Innovative Images, LLC/Mounds View Community Center Banquet Facility Proposal to Dismiss all Claims Against the City of Mounds View. City Attorney Riggs handed out two handouts, one was correspondence from legal counsel for Innovative Images and the second item was correspondence the City forwarded to that counsel on Mounds View City Council October 14, 2002 Regular Meeting Page 16 November 21, 2001. He also noted that there was a document included that had been put together by the Finance Director with input from the City Administrator. Council Member Stigney asked for a legal recommendation on the matter. City Attorney Riggs said he thinks it is best to have closure on the matter. He then said that Council has before it information on what is perceived to be owed and what is owed by the City according to the Finance Director as well as the request and he is not sure what the request is based upon. Mayor Sonterre indicated that the $7,500 settlement number did not come with any detailed explanation as to where that number was derived from. He then said he would like to know what that number represents. Finance Director Hansen explained that during 2001 the City retained the services of MMKR to review contracts and one of those contracts was the Innovative Images contract. He then said that the evaluation was made that Innovative Images was overpaid leaving an amount of $1,901 owed to the city as of December 31, 2000. He then said that based on the fact that Elegant Thymes took over management of the banquet center in the spring of 2002, the City sought to pay Elegant Thymes for the appropriate share of the management fees regardless of who managed the center and allocated the money between the two firms based on business that was conducted under their management. Finance Director Hansen indicated that, based on that information, $2,587 was owed to Innovative Images and, taking the $1901 to the City for 2000 and the $2,587 from the City to Innovative Images for 2001 the net is that the City owes Innovative Images $686.00 based on the records and work of MMKR. Mr. Linke indicated the problem with those numbers is that they should be based on who wrote the contracts that got the business into the facility and Elegant Thymes did not do that through 2001. He then said that Innovative Images wrote most of those contracts and the payment should be based not on who was managing the facility but on who wrote the contract that brought the business to the City. Mayor Sonterre asked if that is in the contract. City Administrator Miller said no. Mr. Linke said yes. He then said there are conflicts as to amounts due based on net and gross including all fees collected which the City claims are not correct but that is a different issue. He then said that, as he understands it, his attorney came up with legal fees that have been expended and they want to get out of this thing and are willing to settle for $7,500. City Administrator Miller reminded Council that these numbers were put together by MMKR based on an analysis of the contract. Mounds View City Council October 14, 2002 Regular Meeting Page 17 Mayor Sonterre asked what the City spent on legal fees on this matter. City Administrator Miller indicated she did not have those figures at this time but could look into the matter. Council Member Stigney said the letter from Mr. Halva referenced a telephone conversation with the City Attorney. He then asked what was discussed. City Attorney Riggs indicated there was no discussion of a settlement proposal other than asking if the matter could be resolved. MOTION/SECOND: Quick/Stigney. To Table This Matter to the October 28, 2002 Meeting to Allow Time for Staff to Generate More Information. Ayes – 5 Nays – 0 Motion carried. Council Member Stigney indicated he would like a legal opinion from the City Attorney, including a valid settlement recommendation. Council Member Marty indicated he had attended the recent rotary meeting where AED was discussed and he would like the City to discuss purchasing another unit to keep at the Community Center. He also indicated that New Brighton is working on a video that would show how to operate the AED in an attempt to alleviate the fear of operation. Council Member Marty indicated the candidates’ speeches would be aired on CTV-15 on October 15, 2002 at 8:00 p.m. and asked if Staff could scroll that information on Channel 16 to inform residents. Council Member Marty indicated he had been approached by residents concerning the property on Woodale where fill is being dumped. He then said that the property contains a berm that has not been leveled out and he is concerned that, even after the leveling, that property would be higher than the neighboring properties. Council Member Thomas asked for a schedule of about when the grading will be completed. Public Works Director Lee indicated some grading had been done and leveled off a month ago but they are continuing to bring in fill periodically and will level it off. He then said that the property would be filled to the street elevation and slope to the north to allow for drainage and noted that no drainage would be allowed to flow from the subject property onto adjacent properties. He also indicated that the City uses the site as a fill location and the budget would need to be adjusted by $3,000 if the City is not able to use that location for depositing sand from street sweeping. Mounds View City Council October 14, 2002 Regular Meeting Page 18 Mayor Sonterre commented that every site has a maximum capacity and that needs to be looked at for this site. Council Member Marty commented that he is concerned with potential liability for the City. Public Works Director Lee said he is confident that the fill would have no adverse affect on the adjacent properties. Council Member Quick asked for an update on the system for pumping sump pump water into the streets. Public Works Director Lee indicated that Staff is surveying properties in that area to see how they are discharging sump water. He then said that SCH has been told that residents along H2 do not have sump pumps. Council Member Stigney indicated that rather than rebroadcast the last Charter Commission Meeting the Charter Commission has asked that the candidates’ forum be replayed during those times. Community Development Director Ericson indicated that there is a candidates’ forum scheduled for October 15, 2002 at City Hall from 7:00 p.m. to 9:00 p.m. Mayor Sonterre reminded Council that he had won a drawing for a $500.00 donation for recreational purposes at the League of Minnesota Cities convention. He then asked for authorization to place the $500.00 in the park dedication fund. It was the consent of Council to place the $500.00 in the park dedication fund. Mayor Sonterre reported that the City was to receive a $2,000 donation toward the City’s annual festival as part of the contract with the Visitor’s and Convention Bureau but he has learned that the president of the Festival in the Park Corporation sent an invoice for $2,000 to them and was sent a check that should have come to the City. He then asked City Attorney Riggs for direction as to how to proceed. City Attorney Riggs indicated it was his recollection that the money was to come to the City. He then said he would review the contract and report back. Mayor So nterre indicated that Pinewood held an open house on September 30, 2002 and said the improvements were very nice and something to be proud of. Mayor Sonterre indicated he had attended the Homeland Security Task Force meeting and the turnout was incredible. He then said that various agencies discussed services available and the next phase would be to work out joint powers agreements with other counties. Mounds View City Council October 14, 2002 Regular Meeting Page 19 Mayor Sonterre commented that the legislative outreach programs have all been good. He then said there was a forum for lieutenant governor candidates that proved the point that the candidates do not have a grasp of local issues but he noted that Representative Crinke answered the question as to what the local government aid formula and does it work the best by stating that he had no idea what the formula was as it has changed so much over time. Mayor Sonterre indicated that the Metropolitan Council is discussing redistricting and he is concerned with a preliminary proposal to tie together center cities with suburban areas. Mayor Sonterre reported that Woodcrest Baptist Church service that was a blue and white day tribute to firefighters and policemen in the area. He then said it was an unbelievable tribute to the work that law enforcement agents do in the City and a great event. 10. APPROVAL OF MINUTES A. Minutes for September 23, 2002 Council Member Thomas requested the following change: On Page 12 at the bottom clarify that the students do not have to cross anything and are not paying for buses. Council Member Marty requested the following changes: On Page 5, second to last sentence under Mayor Sonterre add the word “not”. On page 8, fifth line indicate that Council Member Marty questioned that it seemed that there were five spots for loading docks. On page 10, item e, third line add “that are now being forced to walk that were previously being bussed.” On page 13 in the middle of the page add that Council Member Marty asked if the City puts in a pathway on the south side and also on the north side, if the county would be more likely to provide further crosswalk markings. Council Member Stigney requested the following change: On page 3 second paragraph second sentence clarify that he also noted that the civic center provided breakfast but some chose to charge the City for their breakfast instead. MOTION/SECOND: Marty/Stigney. To Approve the Minutes of the City Council for September 23, 2002 as Amended. Ayes – 5 Nays – 0 Motion carried. 11. CLOSED SESSION None. 12. Next Council Work Session: Monday, November 4, 2002 Next Council Meeting: October 28, 2002 Mounds View City Council October 14, 2002 Regular Meeting Page 20 13. ADJOURNMENT Mayor Sonterre adjourned the meeting at 10:43 p.m. Transcribed and recorded by: Joan Lenzmeier Timesaver Off Site Secretarial, Inc.