The URL can be used to link to this page

3. 1998 Budget Work SessionCITY OF � CHANHASSEN 690 COULTER DRIVE • P.O. BOX 147 • CHANHASSEN, MINNESOTA 55317 (612) 937 -1900 0 FAX (612) 937 -5739 MEMORANDUM TO: Mayor and City Council FROM: Don Ashworth, City Manager DATE: October 30, 1997 SUBJ: 1998 Budget Work Session I have divided this portion of our work session into four general topic areas to hopefully get us one step closer to balancing the 1998 budget. The four discussion areas and a brief description of each are as follows: • 3a. Significant Changes from 1997: I have asked Pam to compare 1998 requests to 1.997 and note either major revenue or expenditure changes. The council may wish to discuss how to prioritize these; however, except' far increases in revenue, most of the remaining expend; tare items will have to be deleted. I would anticipate that this section of the agenda will also include ideas by council members as to other means to increase revenues /decrease expenses. • 3b. Inspection Division Staffing: I believe Steve Kirchman did an excellent job in examining staffing capabilities to inspection requirements. The attached graph is extremely useful, in my own mind, in depicting that over the years building inspectors have achieved higher performance outputs than would normally be expected. Hopefully we can discuss the council's perception as to what 1998 may bring. I would also like to discuss how other cities have solved the dilemma of how to best use inspection services as a community moves from a rapidly growing new community into a fully built -out older community. • 3c. Utility Franchise Revenues: I sincerely believe that the city should consider enacting a franchise fee for our electric and gas utilities. We should be able to set a fee that would be virtually neutral on lower valued homes, but having a tremendous advantage for more expensive homes. As I mentioned during our last meeting, I received very few complaints as to property taxes from owners having homes in the $100,000 to $150,000 price range. This statement is not true as it deals with our newer neighborhoods having typical home values of Mayor and City Council October 30, 1997 Page 2 $200,00 0 to $ 350,000. �' ou It is this of property owners who would extremely benefit from p paying a franchise fee versus collecting the same number of dollars through a property tax system that highly discriminates against higher valued properties. I would hope to have one y g Y or more visuals completed prior to Monday evening. ' Information Requested b Nanc • 3d. Additional Infor q Y Y Mancino: This item has a separate index listing Y in the enclosures that Nancy requested. The only item which was requested that was not included is an overall accounting for city hall expenditures. That document will be completed prior to Monday evening and distributed then. p After going through each of the above items I would anticipate a discussion as to, "What's next ?" will occur. g: \user\karen \98budget 11 -3.doc CITY OF 361k, SSE 690 COULTER DRIVE • P.O. BOX 147 • CHANHASSEN, MINNESOTA 55317 (612) 937 -1900 0 FAX (612) 937 -5739 DATE: October 28 1997 TO: Don Ashworth, City Manager FROM: Pam Snell Finance Director SUBJ: 1998 Budget I've identified significant program changes from 1997 and other key areas in wh =c' to revisit in an effort to balance the 1998 Proposed Budget. Recreation Center Equipment $ 28,000 Reconstruction of Lake Ann Park road and parking lot $15000 Irrigation & ballfield light monitoring system 1998 total expenditure impact is $. General Fund Impact is $ 65,000 Re- estimate of Building Permit Fees $185 Outdoor earning Sirens $125,000 Creation of additional positions: Split Public Works Director /City Engineer position into Mro positions (132,137,70.2) 1998 total expenditure impact is $11,600. General Fund Impact is $ 46,000 Street Maintenance Light Equipment Operator (mid year hire) $ 19,000 GIS Specialist (part time) $ 20,000 ' Custodian (part -time) $ 10,000 Fire Department Secretary (part time) $ 13 Park Maintenance Light Equipment Operator $ 39,000 Intern -Park & Recreation $ 4 Upgrade of CSO to Police Officer $ 9 1998 Clinton Cop grant program Salary grade reclassification of two Finance Account Clerks from III to IV 1998 total expenditure impact is $1,000. General Fund Impac:.s $ 400 Operating costs associated with senior congregate dining (117) $ 3,200 Public works facility study /pre - design (132,137,702) - total is $45,000 - General IFt nd impact is $ 30,000 Three year lease -to -own photocopier (137 -4703) $ 300 City of Chanhassen Staffing Levels 1997 19 98 Addition to 1 1 - City Manager Assistant City Manager 1 1 1 1 " Building Maintenance 0 PT 1 PT 1 PT Custodian Cust 1 1 Ir MIS Coordinator 0 PT 1 PT 1 PT GIS Sp ecialist Office Manager 1 2 PT 1 2 PT - Receptionist 1 1 _ Receptionist 1 _ Secretary Y 1 1 _ Clerk Typist Public Safety Director 1 1 1 1 - Deputy Public Safety Director 1 1 _ t Education Coordinator Public Safety 1 Public Safety Officer 0 2 PT 1 1 PT (1) PT C ommunity mmunit Service Officer 1 " Building Official 1 1 1 _ Asst. Building Official 1 1 _ ' ' Inspector II Building p 2 _ Building Inspector 1 2 1 _ Mechanical Inspector II 1 1 _ Mechanical Inspector 1 Mecha p 1 2 PT 2 PT _ Mechanical Inspector I 1 _ Fire Marshal 1 1 1 _ Fire Inspector ' rs Volunteer Firefighte 45 FF 45 FF3 y _ Secretary Y 1 PT 2 PT _ 1 PT Secretary Park & Recreation Directo r 1 2 1 2 - _ Recreation Supervisor 1 1 PT 1 PT _ C ' ' Coordinator ..Senior Citizen 1 PT 0 PT (1 } PT Senior Linkage Line Coordinator 1 _ Sup erintendent Park Sup 1 1 _ Park Foreman 1 1 1 " Park HEO /Laborer 1 2 1 Park LEO /Laborer 2 2 _ Park LEO /Laborer DT Public Works Director /City Engineer 1 0 ( 1 City E n g ineer 0 1 . 1 1 - Assistant City Engineer 1 _ Project Engineer � 1 2 2 _ Engineering Technician II 2 PT 2 PT - ' rin Secretary Engineering Y Page 1 City of Chanhassen" Staffing Levels 1997 1998 Addition to Public Works Director 0 1 1 Public Works Secretary 1 1 - Street Superintendent 1 1 - HEO /Foreman 1 1 - H EO /Laborer 1 1 - LEO /Laborer 5 6 1 Shop Superintendent 1 1 - Mechanics - 2 2 - Utility Superintendent 1 1 - Sr. Utility Maintenance Operator 2 2 - Utility Maintenance Operator 4 4 - Planning Director 1 1 - Senior Planner 1 1 - Planner II 1 1 - Planner 1 1 1 - Water Resources Coordinator 1 1 - Environmental Resource Specialist 1 1 - Congregate Dining Coordinator 1 PT 1 PT - Finance Director 1 1 - Accountant 11 1 1 - Accounting Clerk 2 2 - Equivalents: 66 FT 70 FT 4 FT 12 PT 13 PT 1 PT 45 FF 45 FF - FF "All employees are Full Time unless otherwise noted This does not account for: PT employees at the Recreation Center seasonal employees interns for administration, parks, engineering, planning Page 2 Bituminous overlay-Pleasant View Road from Powers Blvd. To Trunk Highway 101. ( 132- 4540): $ 42,000 Sidewalks Repair & Maintenance (132 -4541) $ 5,000 Rallocate Computer purchases & training to Capital Projects Administration Fund Alternative Revenue Sources street lighting utility charge franchise fees -gas, electric, telephone, etc. contractor licensing Fund 950 revisit capital program CITY OF CHANHASSEN 1998 BUDGET ALL FUNDS INTFRNAL SPECIAL CAPITAL. MIST PIRFS TAX INCR G.U. [DEBT 1998 GENERAL SERVICE REVENUE PROJECTS ENTRPRS TRUST DISTRICT SERVICE TOTAL ACCOUNT DESCRIPTION FUND FUND FUNDS FUNDS FUNDS FUND FUNDS FUNDS FUNDS GENERAL PROPERTY TAX 3001 Property Tax (Cert) 3,200,796 460,000 120,000 - - - - 367,566 4,148,362 3002 Allowance for Delinquents (96,024) - - - - - - - (96,024) 3011 Delinquent Property Tax 112,028 - - - - - - - 112,028 3012 Tax Increment Receipts - - - - - - 6,780,000 - 6,780,000 3041 Homestead Credit 841,286 - - - - - - - 841,286 3080 Franchise Fees - - 70,000 - - - - - 70,000 j 3090 Other Property Taxes 2,000 - - - - - - - 2,000 GENERAL PROPERTY TAX 4,060,086 460,000 190,000 - - - 6,780,000 367,566 11,857,652 LICENSES 54,300 - - - - - - - 54,300 PERMITS 524,800 - - 400,000 7,000 - - - 931,800 FINES .,& PENALTIES 31,500 - - - - - - - 31,500 INTERGOVERNMENTAL REVENUE 41,800 - 77,000 - - - - - 118,800 CHARGES FOR CURRENT SERVICES 480,300 - 2,000 380,000 2,603,500 100 - - 3,465,900 OTHER REVENUE 117,800 23,000 34,000 75,500 440,500 244,000 110,000 19,022 1,063,822 '* TOTAL REVENUE 5 483 303,000 855,500 3 244,100 6 386,588 17,523 PERSONAL SERVICES 3,387,773 - 82,500 152,700 634,100 201,000 205,400 - 4,663,473 MATERIALS & SUPPLIES 554,451 - 16,100 1,000 123,800 18,500 1,600 - 715,451 CONTRACTUAL SERVICES 2,401,321 - 149,130 61,000 2,104,900 56,800 166,010 - 4,939,161 CAPITAL OUTLAY 295,390 459,000 10,000 354,000 180,000 6,000 28,630 - 1,333,020 MISCELLANEOUS (405,911) - - 30,000 - 155,995 - - (219,9161 DEBT SERVICE - - - - 300,723 - 1,661,300 427,980 2,390,003 ** TOTAL EXPENDITURES 6 459 257 598 3,343 438 2 427,980 13 REVENUE OVER/(UNDER) EXPENSE (922 24,000 45 256 (292 (194 4 (41,392) 3,702,582 1 FUND BALANCE FORWARD 1 472 884 863 3,575,833 2,054 112,953 431,269 10 BOND PROCEEDS - - - TRANSFER IN /(OUT) - 65 9 000 - - (100,000) - (4,909 - (4 LESS REQUIRED RESERVE 918,326 561,510 930 993,073 3 1 30,416 389 8,867 TOTAL RESOURCES OVER /(UNDER) LIAB - - - 127,232 - - - - 127,232 4 CITY OF Z� SSE N MEMORANDUM 690 COULTER DRIVE • P.O. BOX 147 • CHANHASSEN, MINNESOTA 55317 (612) 937 -1900 9 FAX (612) 937 -5739 TO: Mayor and City Council Don Ashworth, City Manager FROM: Steve A. Kirchman, Building Official THROUGH: Scott Harr, Public Safety Directo 2 �. DATE October 13, 1997 SUBJECT: Inspections Division staffing The purpose of this memo is to respond to questions from the Mayor and council members at the October 9 1997 budget meeting regarding staffing levels and work load of Inspections Division staff. Background: Past staffing level records are available for over a decade. Revenue records are readily available in an electronic format from 1990. Records on numbers of monthly inspections are available from 1990. Attachment A shows the history of staffing levels. Analysis: Method for determining staffing. What is the most appropriate method for determining Inspections Division staffing levels? Valuation of construction? Revenue? Number of permits? Number of inspections? • Valuation of construction. There is no direct correlation between valuation and workload. A bulk flour storage silo is valued at $158,000 and will require two or three inspections or $52,666 of value per inspection. An average deck valued at $1,200 will require three inspections or $400 of value per inspection. • Revenue. Valuation and revenue are directly related and, as such, there is no direct correlation between revenue workload. Using the same example, the silo revenue would be $1230.68 or $410.23 per inspection. The deck revenue would be $29.60 or $9.86 per inspection. • Number of permits. A large building requiring one building permit will require 30 to 100 inspections, while a single permit for a deck will require.). to 3 inspections. It's not practical to use the number of permits issued to determine staffing levels. • Number of inspections. The building code stipulates required inspections. Additionally, staff makes it clear to homeowner /contractors that they may request additional inspections at no cost (it's easier Mayor and City Council October 13, 1997 Page 2 to explain requirements before the work is done than require it to be redone). Inspections are done as required by code and as requested regardless of other factors. Revenue is not considered when making inspections. Decks and the City Hall expansion are examples of minimal or non revenue producing inspections. Inspections are certainly an accurate measurement of a large percentage of an inspectors workload. I use the number of inspections to analyze staffing requirements. Current staff. There are currently nine positions budgeted for Inspections Division staff: one building official, one assistant building official, one building- inspector 1, two building inspector 2, one mechanical inspector 1, one mechanical inspector 2, two part time, temporary inspectors. • Building Official. About 25 % of my time is spent on commercial plan review, with the remaining 75% spent on administrative duties. I continue to do some inspections (ISTS, filling in during sickness, problem inspections), but they involve less than I% of my time. • Assistant Building Official. This position was created in June, 1995, and filled with an existing staff member. The ABO's primary responsibility is plan review. His secondary responsibility is to help me with administration. He also continues to do some inspections about 15% of his workload. • Building Inspector I. We have one BI -I. His responsibilities are inspections and residential plan review. He also does some commercial plan review. • Building Inspector II. This position was created in May, 1995 as a cost saving move. All inspectors previously started salary grade V. New hires with no municipal experience now start BI -II's at salary grade IV. Their responsibilities are the same as a BI -I, but they do no commercial plan review. We have two. • Mechanical Inspector I. We have one MI -I. His primary responsibilities are HVAC and plumbing inspections and plan review. • Mechanical Inspector II. We have one. He is at the same salary grade as BI -II's, and has the same responsibilities as the NII -I. • Temporary Inspector(s). Temporary inspectors were first added to the. budget in 1994, when a temporary inspector was used to fill in during the process of hiring a building inspector. We have, continued to use one of the two budgeted positions as a mechanical inspector since 1994. The other position has never been filled. Inspections Divisions staff is required to put in some overtime to keep pace with the demand for services. Numbers of inspectors in the attached graphs reflect field inspectors - staff actually available for inspections. Inspection levels. The number of inspections performed varies from month to month and year to year, but the number of inspections an inspector can competently perform remains fairly constant. A 40 hour per week work schedule translates to 2080 hours per year. To calculate the number of hours an inspector is available for inspections, hours not available must be subtracted. 2050 hours per year in 40 hour work week - 96 hours per year of holidays - 88 average hours per year of vacation time - 48 average hours per year of training time -116 hours per year of meeting time "24-8- hours per year used for lunc-ham break time 16' Mayor and City Council y y October 13 1997 Page 3 -372 hours per year used for office time -55 average hours per year of used sick time 1057 hours available for inspections. Each inspection is allotted a one -half hour time slot. Inspection times vary, but one -half hour has proven to be a good average time. This gives each inspector the ability to do 2114 inspections per year or 176 inspections per month. The attached graphs show actual and possible numbers of inspections per month. Possible inspections are based on 176 per month. Other staff activities. 176 inspections per month assumes an inspector has no duties or other activities which can't be completed within the daily allotted 1' /2 hours of office time. This is never the case. All inspectors have other duties and activities for which they are responsible. Time spent on these activities varies and can't be accurately predicted or traced. Some examples are: • One inspector spent over 140 hours (25 of which were overtime hours) on the Oak Hills litigation. He will continue to spend time on this project. This time represents 230 lost inspections. • Another inspector has spent 187 hours doing computer related work for the city. 70% of this work was related to configuring, debugging, etc. the PERMITS software. The balance was spent on helping other staff with general computer problems and assisting the new MIS coordinator. This represents 374 lost inspections. • One inspector is responsible for determining Building Code Effectiveness Grading Schedule (BCEGS) requirements, training staff and implementing compliance procedures. The BCEGS is a nationwide system for grading building inspection department effectiveness. Minnesota will be graded in 1999. The inspector spends about one hour per week on this project or 8 lost inspections per month. • One inspector moderates the monthly Building Officials Area Training meeting in Medina. Preparation for this meeting takes about two hours per month or 4 lost inspections. • All Inspections Division staff are involved in varying degrees in training for implementation of the City's Emergency Management Plan. Time spent in this area is not currently tracked. • Three Inspections Division staff spent a total of 48 hours helping flood damaged cities with cleanup and inspections. • Residential plan review continues to consume ever increasing amounts of an inspector's time. The use of manufactured components, increasing square footage and increasing complexity has increased the plan review time over the years. It is estimated that we'll do about 10,400 inspections this year or 160 inspections per inspector per month. This leaves 8 hours per month or less than one -half hour per day for each inspector that is not accounted for. The activities listed above easily account for all work time of all inspectors. Additionally, there are a number of projects which haven't been completed or started due to lack of time. Staffing requirements. Current staff is able to handle the existing workload in most cases. Inspections Division goals and future code enforcement requirements may not be achievable with today's staffing levels. • We are supposed to be in the process of developing an inspection scheduling and tracking module for our PERMITS software with the software developer. This software should save time in the long run, but will use lots of staff time during development. • Two of the stated goals of the Inspections Division are: Mayor and City Council October 13, 1997 Page 4 1. Issue 95 /o of residential permits that are correctly submitted Within ten days. 2. Perform 95 / o p ° o f all inspections within eight hours of the requested time. We are not able to consistently meet these goals. • We are experiencing . an increasing number of housing code related complaints, but the City has no adopted housing code. Enforcement of a housing code is a more time consuming process, on a per complaint basis, than enforcement of the building code. When adoption of a housing code become a reality, p li development and enforcement will require additional staff. • We have many complaints length about the of time it takes to process simple residential permit g reroofs basement finishes, etc.). Staff is seldom available to review these applications (decks, immediately. . This would be a valuable customer service to be able to provide. inspections, shorter permit and inspection turnaround, or incorporat Increasing number of mspec ion of ro p g additional rams would all necessitate an additional staff person. Recommendations: I recommend current staffing levels be maintained and workload be monitored and reported. enclosures: Attachment A, Staffing (data) Attachment B 1, Revenue, inspections, inspectors (data) Attachment Inspections, ent B2 Ins ections possible inspections, inspectors - by month (graph) Attachment Inspections, t B3 Ins ections possible inspections, inspectors trend (graph) p ossible Attachment C, Inspections, inspections, inspectors trend, 1998 estimate with current inspectors (graph) GAsafetylsak\memos\cc\stating 1 STAFFING s 1988 1989 1990 J F M A M J J A S O N D J F M A M J J A S O N D J F M A M J J A S O N D BO RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ RJ SK SK SK SK SK SK SK SK SK SK SK SK ABO 1311 SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK TC TC TC TC TC TC ST ST ST ST ST B11 SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN B12 B12 M11 CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB Mil JT JT JT JT JT JT RD RD RD RD RD RD RD RD RD RD RD RD RD M12 CS M12 I: TBI TMI 1991 1992 1993 J F M A M J J A S O N D J F M A M J J A S O N D J F M A M J J A S O N D 4;r BO SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK ABO 1311 ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST Bll SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN SN JM JM JM JM JM B12 B12 MI1 CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB M11 RD R RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD M12 M12 TBI TM'1 1994 1995 1996 J F M A M J J A S O N D J F M A M J J A S O N D J F M A M J J A S O N D BO SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK SK ABO ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST B11 ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST ST - B11 JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM JM B12 DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH DH B12 BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR BR M11 CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB CB M11 RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD RD M12 JK JK JK JK JK JK JK JK JK JK JK JK M12 - TBI TR BR BR BR BR BR BR BR BR BR BR BR BR BR BR TMI LW LW LW LW LW LW LW LW LW LW LW LW LW LW LW LW LW LW 1997 J F M A M J J A S O N D LEGEND: BO= building official, ABO= assistant building official, B11 = building inspector 1, B12= building inspector 2, SK SK SK SK SK SK SK SK SK BO M11= mechanical inspector 1, M12= mechanical inspector2, TBI= temporary building inspector, TMI= tmeporary mechanical inspector ABO ST ST ST ST ST ST ST ST ST Bl1 B11 JM JM JM JM JM JM JM JM JM B12 DH DH DH DH DH DH DH DH DH B12 BR BR BR BR BR BR BR BR BR M11 M11 RD RD RD RD RD RD RD RD RD M12 JK JK JK JK JK JK JK JK JK M12 TBI TMI LW LW LW LW LW R*44c%c%WAv% Izl REVENUE/INSPECTIONS/INSPECTORS NUMBER OF NUMBER OF PERMIT NUMBER OF NUMBER OF NUMBER OF PERMIT NUMBER OF REVENUE INSPECTIONS INSPECTORS POSSIBLE REVENUE INSPECTIONS INSPECTORS POSSIBLE DATE (/744) (x50) INSPECTIONS DATE ( /100) (x50) INSPECTIONS Jan -94 419.97 705 200 704 Jan-90 378.45 698 150 761.17 735 200 704 589.28 736 200 704 871.68 1251 200 704 146.58 629 200 704 704 Apr-94 675.80 1097 200 704 Apr -90 341.02 748 200 774.88 1106 200 704 399.94 799 200 704.' 872.13 1369 300 1056 315.21 894 200 704 704 Jul -94 558.69 1158 300 1056 Jul -90 419.47 592 200 528 1080.19 1355 300 1056 468.93 967 150 715.85 1111 300 1056 333.93 599 200 704 704 Oct -94 806.41 1121 300 1056 Oct -90 391.19 700 200 553.24 1026 250 880 242.98 589 200 704 835.04 914 250 880 263.91 430 200 704 704 Jan-95 617.38 875 250 880 Jan-91 212.56 458 200 597.82 780 250 880 1 87.69 460 200 704 610.22 968 250 880 383.19 367 200 704 704 Apr -95 581.18 1118 250 880 Apr -91 283.32 676 200 782.99 1315 300 1056 399.11 681 200 704 1018:29 1294 350 1232 543.11 707 200 704 704 Jul -95 734.21 1128 300 1056 Jul -91 409.23 797 200 896.78 1297 300 1056 330.39 917 200 704 791.97 1045 250 880 268.64 632 200 704 704 Oct -95 953.54 1086 250 880 Oct -91 357.35 700 200 690.22 1048 200 704 102.78 461 200 704 831.37 759 200 704 229.28 464 200 704 704 Jan -96 561.85 899 250 880 Jan -92 210.77 502 200 � 625.44 1010 250 880 249.87 487 200 704 560.28 1071 250 880 444.55 539 2 704 704 Apr -96 461.96 1156 250 Apr -92 312.45 743 200 737.49 1058 250 880 341.44 691 200 704 809.44 935 250 880 671.77 808 200 704 Jul -96 827.94 1171 300 1056 Jul-92 521.52 840 200 704 439.90 1063 300 1056 488.48 759 200 704 47032 910 300 1056 396.59 929 200 704 704 Oct -96 . 494.92 1010 300 1056 Oct -92 384.37 813 200 597.38 850 250 880 367.90 637 200 704 458.12 674 250 880 415.87 -- 622 200 704 Jan -97 599.54 654 250 880 Jan-93 336.43 591 200 704 208.78 665 250 880 424.66 602 200 704 359.43 831 250 880 3812 6 802 200 704 704 Apr -97 368.77 861 250 880 Apr -93 403.38 774 200 613.92 777 250 880 546.81 855 200 704 647 971 300 1056 458.24 815 200 704 Jul-97 545.15 1014 300 1056 Jul-93 J 552.26 847 150 •528 589.46 1048 300 1056 474.15 1016 200 704 Sep -97 887.82 917 300 1056 423.36 916 200 704 Oct -93 558.92 874 200 704 ------ 422.88 921 200 704 605.09 814 200 704 N 44t INSPECTIONS-POSSIBLE INSPECTIONS-INSPECTORS-BY MONTH offim 1000 800 :ZOO 400 200 0 0 0 — — cm co co Ir U) w . CID W rl 91 m m 91 T cp T C? T cp T c cc 2 c c C CL c c c c 19 A 2 - 10 im 0 NUM3MOF mpecncw NUMBM OF WPECKM (X50) A NUMEROF POSE 13LE I i,sPWMN4 - Linear (NUMBER O WPECTIONS - linear (NUMBER O POSSIBLE rISPEcnONS) - Linear (NUMBER OF WSPEC ORS (x50)) INSPECTIONS- POSSIBLE INSPECTIONS - INSPECTORS -TREND 1400 1200 1000 800 600 400 200 0 ! ► I I I I I i I 0 CD ,- N m M d' Lo Cfl cr) 0) I,, d0 Q C C C IL C C C C Cn C as cd co co co c f CIO co Linear (NUMBER OF INSPECTORS (x50)) Linear (NUMBER OF POSSIBLE INSPECTIONS) Linear (NUMBER OF INSPECTIONS INSPECTIONS /POSSIELE INSPECTIONS /'INSPECT°ORS�TR�N ®THROIJON 199 VU'ITH SAME ST�1�� 4 1994 franchise Revenue Data Top 20 Gross Franchise Revenues city PQpulatiQn F Revenue 1 MINNEAPOLIS 366480 $18,144,488 2 ST. PAUL 271660 $15,493,624 3 COON RAPIDS 58991 $1,707,073 4 ST. CLOUD 50143 $1,255,318 5 ALBERT LEA 18338 $1,045,257 6 DULUTH 85746 $1,015,886 7 WINONA 25805 $648,465 8 WEST ST. PAUL 19332 $459,820 �l 9 SOUTH ST. PAUL 20396 $416,807 — 1 10 BLOOMINGTON 86683 - $31,267 11 ROCHESTER 76865 $322,592 72 CROOKSTON 8163 $291,749 13 MOUNDS VIEW 12552 $266,836 14 MOORHEAD 33618 $245,196 15 BURNSVILLE 54525 $239,509 16 EAGAN 54957 $229,$50 17 MINNETONKA 50569 $211,240 18 EDINA 46841 $206,261 19 EDEN PRAIRIE 44189 .,$196 20 ST. LOUIS PARK 43641 $170,561 1994 Franchise Revenue Data Top 20 per Capita Franchise Revenues cfty- Population Per Capita 1 ST,- PAUL 271660 $57.03 2 ALBERT LEA 18338 $57.00 3 MINNEAPOLIS 366480 $49.51 4 CROOKSTON 8163 $35.74 5 COON RAPIDS .58091 $28.94 6 LAKE CRYSTAL 2143 $25.14 7 WINONA 25805 $25.13 8 ST. CLOUD 50143 $25.03 9 WEST ST. PAUL 79332 $23.79 10 MOUNDS VIEW 12552 $21.76 11 SOUTH ST. PAUL 20396 $20.44 12 ORR 264 $15.83 13 EAST GRAND FOR 8947 $ 14 DULUTH 85746 $11,485 15 WASECA 8184 $11.40 16 LAKE CITY 4507 $11.34 17 WALKER 973 $10.64 18 ST. PETER 0782 $8.67 19 RICE 657 $7.48 20 MOORHEAD 33618 $7.29 1994 Franchise Revenue Data Top 20 Franchise Revenue as 'a % of Total Revenue Population la 1 ALBERT L.EA 18338 8.76 2 ST. PAUL 271660 5.45 3 LAKE CRYSTAL 2143 5.39% 4 WEST ST. PAUL 193,32 5.21% 5 COON RAPIDS 58991 5.19% 6 CROOKSTON 8163 4.57% 7 MINNEAPOLIS 368480 4.30/ 8 MOUNDS VIEW 12552 4.03% 9 WINONA 25805 3.92 io PINE SPRINGS 434 3.68% 11 ST. CLOUD 50143, 3.61 12. SOUTH ST. PAUL 20396 3.21 13 SKYLINE 341 279 14 WASECA 8184 2.33% 15 ST, PETER 9782 1.96% 16 ORR 264 1.83% 17 KASOTA 669 1.74% 18 LAKE CITY 4507 1,66% 19 EAST GRAND FOR 8947 1.63 20 NORTH OAKS 3644 6'% • s ( revenue data) 1994 franchise taxe ON FRANCHISE To TAL REV perc�.p % of tot _rev 4.30 o - POPULATI CITY $49.51 480 $18,144,488 $422,415 366 4 258, 956 $57.43 $28 5. 45% MINNEAPOLIS ST. PAUL 71660 $159493,624 2 $32,9069138 . $1,707,073 $28.94 5. � 9% COON RAPIDS 91 589 642 50143 $ 1,2559318 $34,788, $25.03 3.61 a 8.76 /o ST'. CLOUD 183x38 $1,045,257 $11,931,2 $87,872,716 $11 ° 1,16 /o ALBERT L EA DULUTH 85746. $1,015, 8S6 2 5805. $648,465. $16, 527,420 $25.1 . ° /° 3.92 21 6 WINONA P AUL WEST ST. P 8 829,974 19332 $459 $ � $416, $12 ,999,437 8 $23.79 $20.44 • 3.21 SOUTH ST. PAUL 20396 8 6683 $3319267 $84',32 5 66.8 $8.82. $4.20 0.39% 0. BLOOMINGTON .. 7 6865 $322 $ 62-17 43 181 6 .. $63384962-3 $35.74 4 ROCHESTER C ROOKSTO N 8163 $291,749 12552 . $6,624,878 $266,836 $21.26 � 4.03% a 1.43 /o MOUNDS VIEW 336 18 $245,196 $17,1 6 7, 420 $7.29 $4.39 0,81 M OO RH EAD B U R N SV I LLE 5 9.43 4525 $239,509 $29, ! $229,850 $29, 820,723 $4.18 o 0.77 /o EAGAN 54957 50569 $211,240 $ 29 9 477 $4 $4.40. a 72 % 0.77% MINNETON KA 46841 $206, 261 $26,771,756 $31,41 6 196 $4.4C 0 EDINA EDEN PRAIRIE 441 89 $196,952- , 436 41 $170,561 $24,115,802 $3.91 1'% 0.7 / 0.81 °/ ST. LOUIS PARK VA LLEY VA 39188 $143,830 $ 1-7 ; 763, 441 $141 $22 ,552,431 $3.67 $4.02 0.63% 0 APPLE RICHFIELD 35261 2 5804 $ 136,64 0 $11,756,209 $ 5.30 $3.17 1.16 /b o 0.$ 4l0 WHITE BEAR LAKE 41656 _ $ 1 . 32 , 105 $ $2-49262)573 $3.49. 4 .48% ELAINE RC�SEVILLE 38674 $117,464 8947 $116,442.. � 7 123,771 $13.01 1 .63% 1.33% AND FORKS EAST GR 162Q0 $ 1 08,1 88 ,163,557 $6.68 $3.27 ° 0.54 /o HASTINGS LAKEVILLE 3 2978 $107,866 $195° $93,581 $ $4.6 0.6 /o 0 OWATONNA 2028 0 8 184 $93 ,303 $41008,490 $11.40 $3.52 2.33 / 0.87 % WASECA SHOREVIEW 25 957 $91,419 $ 10 1 549,616 $91,212 $8,26 $6.77. 1.10 % o NEW ULM 477 � 3 $14,687,625 8104 $8$,874 2 $3.1 $8.67 0.61 /o o 1.96 /o FRIDLEY ST. PETER 782 $84,8 $41337, 653 � $13,297,227 18492 $77,942 $4.2.1... o 0.59 /o ° 0/° FARIBAULT 22328 $75,895 $1838 $3.40 $4,89 �•4 a' 72% NEW BRIGH rtoN 1 5352 $75,070 $ 1 464,252 $4.35 o 0.6.8 /° NORTHFIELD 02 396 16536 $71,866 $10,5 , $ 11,545,562 $3.80 o.6 2% HOPKIN5 ; COLUMBIA HEIGHTS COLD 18882 $71,756 $G8,4 95 $10,018,744 $5.00 0.68% SAVAGE � 13703 � 15645 $58 , 793 $1 4 255 511 $3.76 $2.61 0.41% 0.38% RED WING AUSTIN 9 SSS 2039 $!57 $15,25 , 2 $53,876 $25.14 5.39 % o LAKE CRYSTAL 2143 9232 $53,406 $10,5 320020 $5.78 $11.34 0.51 /o 1 66 o /o . VIRGINIA LAKE CITY 507 $51,087 $3,07 42 4 - . $47,380 $15,352. $3.45 d 4.31 /° CHASKA 1 3721 1 2559 $45,125 $8,575, $3.50 $3.51 .0.53 0.52% PRIOR LAKE MARSHALL 2397 $437473 1 39� $3.51 $43,094 $16, 0.26% CHANHASSEN 14316 4 12 521 $429490 $7,824,7 $3.39 0.54 /° BRAINERD 1994 frandmise taxes (revenue data) 13041 $4 $14,935,887 $3.12 0.27% SHAKOP EC 9225 $40,064 $3,853,750 $ 4-S4 1.04% LITTLE CANADA 9x92 , 38,428 $ $3,625,946 $4.01 1,06°fo FOUND 551 � $34,410 630 $8 .24 1.05% 0.67 MONTEVIDEO 8251 $33.516 $5,0 (),'D60 $4.06 ALEXANDRIA 1108E $26,91$ $6,805 $ 2.43 0.40 FlOSEMOUNY 7989 '2b 387 $ $3,874,413 $3.32 0.68n/a '� ANTHONY ST. ANTHO 7595 $25,412 r �,04t�,�09 $ 99/ � 3,35 0.500/0' ° J� LITY'LE FAL 5 $22. ►982 $1 $3.8.3 1.24 OAK GROVE 8946 $ ?.0 G4� $6,383 $2.31 0.32% SANK nAPIDS 639 7 $14 $3,309 $2.86 U.55% FOVIES 1 LAKE S A.3 $18,11 U $5, 728 $2.25 0.34 ° /a THIEF RIVER FAI .L3 4 p r�r 4 $17,340 $2., .IS8,529 $3.80 0.73% NIPESTONE s0 3 � 60 � 17 337 $3.046,847 $4.49 0.48 °�0 WAYZA YA 31 U 06 � $16,844 $1 9,$029860 $ o.�� 0.09 MANKATO 87 02 $16,021 $ U6,044 $1. 0.76% EAST BETHLL 13 So $15, 610 $7,094,053 $1.34 0.26210/0 FAI RMONT 1 22 7� $15,11 �- $2 $6.63 U. 74 ° Jo PAYNESVILLE 3 6 44 $14,691 $938,757. $4.03 1.56 °l0 NOR I'H O AKS � 33 54 $14 204 $2, x, $4.23 0.70 ° /n MOUNTAIN IRON M 5297 $13 $1 894, 359. $2.60 0.73 " /0 FALCON tEIGHTS 4002 $13,57 $3,865,638 $3 .39 0.35 ° (d EVELETN y A 11 $� 3,453 $2,908,218 $2.7d 0.45 °J° RFbWOOD FAILS 6870 $13,274 $6161 $1.93 0.`4 °l0 FARMINGTUN _ 66 6 $13182 $2 023,500 $1.99 U.65ofo _ LAKE PA G RK SPRING 4 C� 24 $10180 $1 $3.11 0.86 /° W . 3 3706 $1;3 $2,037 $3.51 0.64 '• EYE SLEEPY ,• $1 2,9129 $:1,956,270 x.36 $2 4.33'" WRITE PARK 2657 $12,401 $.1,568,820 $4.67 4.79 " /0 MELRn�E 71 44 71 $ 1 2,484' $21,687,80b $2.75 0.46% LLIVERNE 52 08 $1 1 367 , , $1,385,670 $ ?• 1 �} na 0.62 h► HUGO 3f '16 $11.249 $2,630,886 $3.12 0.4$% TWO HARBOR$ 3348 $110180 $2- $2.57 0,54% ST. JAMES 923 4923 $11,OOfi $2,669,8.'.1, 2.24 0.41% G LEIVC4E $1 U s $2,111,101 ��.�6 0.52 NEW PRAGUE 72 95 $10,776 $4 $1.48 0.24 DETROIT LAKES. 9825 2 $10,71 $2,532,452 $1.09 042`'/° HAM LAKE 3224 $16,6 d $2,223,285 $3.29 0.44% HENSON r. $10,43.► 0 6188 $3, 1 , $2.801 0.35% E ARTH DLUE- EARTH 973 $10 $1 $10.64 0197% WALKER 1926 $913fi8 $1,061,158 $4.86 0.88/0 MADISON 2067 $8 $ $3.11 0.5210/0 PLAINVIFW �' 695 $8 $1,670,113 $1.90 0.5311/16 CIRCLE PINES c718 $8,657 $982,766 $3,19 0.88% LAUDERDALE 1615 $8,844 $1,179,236 $5.35 4.739'0 bAW�ON 5222 $8,503 $3,482, D41 $1.63 0.24% CAMBRIDGE 3710 $13,410 $2 $9.27 0.38% BRECrKENRIDr E 3079 $7,918 $1,600,394 $ 2.57 ° 0.49 r� GOODVIEW 1766 $7,911 $513,948 $4.48 1.61 EAGLE 1 AKE 2922 $7, 844 $ 1 , 404 1 9-45 $2 68 0.56 CALEDONIA 3016 $7,283 $1 $2.41 0.61% PROCTOf1 1994 tranohise taxes (rcvcnue date) 2'343 $7,244 $1,394,751 $3.09 0.52 °h IELD CHAT FIELD dRTONVILLE 2094 $1 $1,5061910 $3,40 0.40 MOOSE LADE 1605 $7 ,212 $623,983 $4,40 1.15 °l0 �ORCORAN 5508 $7 $1. $1. 29 0.40% PAM nAPIDS 2968 $7 $2,026,788 $2.39 0.35 ° /Q WINNEBAGO 1554 $6,796 $1,23 ,164 $4.37 0.55% LI N 051 ROM 206 $6,705 $1,60.5,240 $2.80 0.42 ° /Q- ST. CHARLES 2899 $6,704 $1,333 $2.31 0.50% NORTH IUTANKAT p 11183 $ 5,268 $U839013 $0.56 0.10% CHISAGO CITY 2055 $6 $11508,466 $3.00 0.41 STAPLES 2945 $6,114 $1,610,553 $2.U8 0.38°/0 H ERMANTOWN 7237 $5 $2,753 $0.82 0.22% 0000E C;EN rER 2077 $ 5 600 $2, 208,238 32.79 JANEB V ILL E 1397 $5,092 $917 $2.82 0.61% BLOOMING PRAIRIE 2U5U $5,597 $1,047,017 32.73 0.53% LA CRESCENT 4478 $5,575 $1 81.24 0.33% HOWARD LAKE 1542 $5 $1,416 $3.49 0.38 TSEGO 6423 $5 $1 ,253,263 $U.8*1 0.42°ry JORDAN ?.1982 $5,207 $1,974,253 $1.75 0.26°x° NILE f57 $4,191 ? $430,676 $7.48 1.14% GILSIEH 1 1910 $4,769 $1,F3F�,,R7f $2.5p 0.26 ° /d PINE CITY 2757 $4,757 $11130132 $1.73 0 .42% BASS BROOK 2110 $4,698 $1,049,005 $2.23 0.4.71% STARSUCK 1148 $4,567 $188,001 $3.98 0.58`'/4 ANNANDALE 2308 $4,490 $1,68 /,814 $1.05 0.27% HILLTOP 774 $4,437 $487 $5 .73 U.-01 % EYOTA 1522 $4 1 263 $503 1 730 $2 .80 0.8b% LEXINGTON 2234 $41200 $7119,058 $1.88 0058% R OR R 264 $4,179 $228 $15.83 1.83% DAY X1938 $4,107 $1,403,968 $0.E�3 0.29% B1WaBIK 1078 $4,101 $2,700,102 $3.00 0.15 "m NORTH BRANCH 5140 $3,940 $1,671,160 $0.77 4.24% MADELIA 2232 $3,808 $1,223,296 $1. 0.31% ST. M ICHAEL 3A4q $3,762 $836,932 $'1.23 0,45% WAlliRVILLE 17.44 $3 $1,389,516 $2.05 0426% NEW YORK MILLS 960 $3,614 $��.. $3.74 0.38 MAPLE PLAIN 2094 $3,612 $1,1 63,7 )7 $1.72 0.31% VV(NSTED 1603 $3,240 $1,154 .1.x11 0.28% MAPLE�'nN y 560 $3,198 $795,998 $2:05 0.40% KASOTA 669 $3, 184 31 ,384 W $4.70 1.74% CENTERVILLE 2101 $3,136 $1,659,283 $1.49 0.19% LAKEFIELD 168.0 $3,047 $1,140,9$9 $1.81 0.27 LE CENTER 2079 $2,980 $77 1,829 $1.43 0039% AVON 1033 $2,x]30 $1,057,304 $2.84 0.?8% SPRING GROVE 1234 $2,747 $733,460 $2.23 0.37% NEW RIC;HI AND 11 97 $2,7.07 $532 $2.26 0.51 SANDSTONE 2025 $2 $1,097,819 $1.30 0.24% ROGERS 978 $2,551 $1,486,671 $2.61 n 0.17 '. ALBANY 1589 $2 $1,086,618 $1.58 0.23% TRACY 2054 .$2,500 $1,275,550 $1.22 0.20% FAIRFAX 1335 $2,464 $708,708 $1.86 0135% g41ranohise EaXOS (reventip. data) 19_ 1208 $2,465 $706,028 $2.U3 0.35% LF STEFt PRAIRIE 1 R9B • b2 $2 4 $9,94,077 $1.44 0.25% 0.71 A DA MORRISTOWN 819 r $2 $345,014 �� 437 $1,145,$76 $2,98 $1.54 0.21 BUSH CITY 1 J 3� � 622 $2,332. n C $24�,�i,�8 $ 3.7� $2.09 0.�s% , 0,56% �.ANDFA LL EDGERTQN 11 06 $22310 $2' 3C?� $464,685 $y87,995 X1.18 0.23Q/,o FOLFY 1953 - 1288 $2,.242 $66g�4�3 � 1.74 $1.68 0.33% 0.22% TRUMAN RENVILLE 1311 1311 1165 $2, $3,140 $995,r�4 $718,759 $ 1.84 0.30% B RA H/�M 503 $2 o04 $30,938 $3.9g $2. SA O.GS 0.65% 0.31 Q� F RANKLI N jRE N1l) 751 1 948 $ , $62�',489 .,, 4.15 U. 1'3 °fo MASEL LA PRAIRIC 4s 3 $1,921 $1,918 $262,215 39,054 , $2.85 o 0.4$ !° CL FARWAT�1 6 ?3 809 �'i1 ►a 89 $456,998 $3.0�/ 0.41 Q /d 0.42 MARINE ON ST CR X 902 $ $439 $ 2.31 11.29 °o SILVER LAKE 1324 ' 1 838 $ , $625,143 $1.39 $1.33 0.33 0 /o BI RD ISLAND L.C�NSDALE _ 1348 $ $ '1 774 $548, 080 $434,:�U4 $2.24 0.41 BROWNTON 701 � 5 8q , $1,`�4C ,� $231,834 . 2.99 $ 0.76 0.20% J Sp ER p $8'&,-,7l4g7 $1.91 $2.27 4.72 !a B U H L CI EVELAND 720 679 r 34 X1,6 $1,5:31 $227 $261,991 2.34 0.61% ST. CLAIR 9c2 $� � 5 � 5 19 $1,391,8 $1.64 0.11% 2.79 _. MOR(�AN SKYLINE SKY 3 41 $1.,537 $1,45 7 $55,058 $429,612 $ 4.5 1 $ $2.07 0.35% MADISON LAKE 718 .� • 461 $ 1 4RO $3,112,960 $0.35 0.45`'!4 0.58 °�0 BAXTER BUT'TERFIELD 572 $1 ,471 $1,417 $253, $38,462 .2.57 $ $3,26 3.88°/6 � , , PINE of'RI NGS 434 43 4 $1,412 $703,814 $1. 65 0.20 0f6 0.48% WATKINS GLEN1�lLL� 754. 859 X1,4 06 $1 ,015 $290,339 r. $49.x,429 $1.80 '1.64 $ 0. 28% p�RTILE HOLDI NGFORD 560. 1387 $1,387 $1 ,380 $4163358 ,� - $1 X 3,71 b $2.45 $ 3.0 0.33% 1.10 °l0 GEM LAKE 449 1527 $ 1 364 $043,355 $0.89 $ 1.93 0.14% 0.26% PRESTON 8 gg $1 ,351 $541,525 $1 V.74 °!0 1NADASSO CLARKS GROVE 6 85 72 0 � $1,33. $1,329 $180,891 $561, ?16 .94 $1.83 0 .24% °h EDEN V ALLEY . 5 $1 , 256 $345,285 $2.2/ 0.36 F-LLEN DALE 590 $1,225 $322,230 $ 0.18% SACRED HEART 1026 $1 $679,716 $1.17 0.29 MONTROSE MEnFORD 7sU $1 $ 154 $410,760 $2967 68, $ 1 . 55 $2.04 0.43% FREEPORT 566 559 , $1,146 $206,041 , 2.05 $ 0 ° /a °! VEFiNDALE EAGLE SEND 527 $ 1 118 $ 1 U4 $312 $528,26.1 $2.12 $1.30 0,36 o 0.21 % . WESTBROO K 840. 757 1 1 $1,100 $1,123,299 $ 1.46 4.14 0 43 °10 TAYLORS FALLS 1145 $1,095 $256,586 $u,96 0.31% STACY rQnD THIJND�- 565 $1 ,092 $ 1 orr $350,921 5248,633 $ 1.93 $1 0,43% AM©DY 556 $61 , $1 ,054 .. $1,Ub 1,088 $ 1.88 0.10% FLOODWOO D 'se taxes ( reverme data) 1994 tran�ht • 587 $1 03 � 304 852 $1.76 s 1 0.34% U Fi CITY 1 724 $ 1 000 $1 0,284,640 ' $0.58 $1.41 008% 027`�a AITK N N OKAH 7t�3 � 4 9 g $ 302 $298,608 $1.49 0.330 ST. STEPHEN 6Ei7 475 $ 9au $330 ,134 $2.06 0.34% o.i X /4 Hit L CITY CL�4F�EMUM . 53 5 $977 $957 $67f%884 $1 $1 .a3 $0.34 0.07% LONG PRAIRIE 2ti41 559 . A�i2 ' $304,627 $1.70 0.26 % n.fin% DANUBE 449 $927 $154,11 $ 2.06 $i .32 {1.25% GENEVA G E ELMORE 696 5 $91 g $ 862 $371,346 $14705x3 $1 .70 0.58% SASIN ,,b7 11194 $855 $6,5359252 �0.07 $1.99 0,011 4 133% BEMIDJI MAYNARD 428 $850 $788 $257 $432 $0 .8�1 0.18% . . VER PINE KI 3 8 30g $7,19 $90, 415 $?.40 $3.71 0 0.75 0.91 q H ARTLAND WA HKON 13$ �' 94 $G9 3 $80 $1 41,237 $2.33 0.49% F REEBORN F 298 . sos �� 0 $181,445 $1.14 $2.30 0.371a 0.65 HILLS CURRIE 295. 89 $6 , � � $631 $1061195 $847,997 $ 1 . 42 0.06 °10 �, N ELY�IA 44s p $630 $ 897, 347 cntl .0.07 °�0 BRANQH 2 x.88 $ 55$ $1?2 �- $1.97 $ 4.84 0.4 U.12-% HOLLANDALE WhVER�.Y b 16 $516 $ 4�5 $d1. x,866 $156 .$1.62. 0.32% FIFTY LAKES 32s 372 $440 $12ro,770 $1 1 s 0.35 °Io FO R ESTON 213 $423 ' 629 � 63 $1.99 0.66% 0.13% NORTH REDWOOD 246 $ 3s1 $285,145 $1.55 0.33% 1�lNNEY 224- $262 $84,298, $ 1.17 $0.29 0,07% CAMPBELL ., CLr�RI�bQ 629 $ 81 $35 $277,030 $36,264 $0.20 � 0.1 0°f� 174 FORl1 DA 2"1 Additional information requested by Mayor Mancino: 1997 Budget vs. Year to Date Actual expenditures for 1996 -1992 Valuation numbers for the past 10 years Expenditures associated with congregate diningproject Legal fees by firm, fund. �i:� Cf Chuc�haccEa Income Statement 09/30/97 Actual v. Budget 25% Remaining Variance - Variance Variance - Variance 1996 Variance - Favorable Variance as a % 12/31/96 1996 Budget Favorable (Unfavorable) as a of budget 9 09/30197 1997 Favorable as a % 09/30/96 al Budget YTD Actual (Unfav ud et of b g YTD Actual YTD Actual Budget orable (Unfav ) budget of bu 98,163 146,742 48,579 % 33° 130,064 192,373 146,742 223,124 16,678 30,751 110% 14 /o E x p enditures: General Government p 89 ,4 29 .149,575 60,146 � 40% 109,032 223,124 114,092 5 /° 168,635 183,362 14,727 8% 111 Legislative 164,450 24 239 1, , 74674 31 % 32% 123,048 183,362 60,314 33% 99,099 80 000 (18,099) ( ?3 %°) 112 Administration 97,781 142,804 45,023 80 000 25% 70,004 � 9,996 12% 36% 48,913 72,600 23,687 33% 113 Finance 114 Legal 62.,480 1,770 3 000 8 , 74,050 ?.0,520 72,280 ° 46,202 72,600 98% _ 26,398 _ ° 0 % _ 176,850 _ (21,038) 0% (12 %) Assessment 115 Property Assess 4,151 26,800 22,649 _ 85% 172145 176,850 4,705 3% 197,888 41,969 32 000 (9,969) (31%) ( 116 M.I.S. II 16 .1,605 196,350 34,745 4 500 18°/ 58 %° 15,647 32,000 16 353 5 31 / 877,941 914,678 36,737 4% 117 City Ha 3,250 7,750 ° 6345241 914,678 36 /° 280,437 118 Elections 584,916 919,453 334,531 Total General Government Page 1 �. City of Chanhacccn Income Statement 09/30/97 Actual v. Budget 25% Remaining Pack 2 Variance - Variance Variance - Variance Variance - Variance 09/30/97 1997 Favorable as a % 09/30/96 1996 Favorable as a % 12/31/96 1996 Favorable as a % YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget Public Safety Expenditures: 121 Police Administration 284,599 694,474 409,875 59% 408,207 682,793 274,586 40% 673,858 682,793 8,935 1% 122 Fire Prevention 169,800 279,435 109,635 39% 163,589 267,807 104,218 39% 250,792 267,807 17,015 6% 123 Public Safety Commission 2,350 2,375 25 1% 2 2,325 78 3% 2,315 2,325 10 0% 125 Code Enforcement 491,217 675,850 184,633 2.7 %0 408,299 586,200 177,901 30% 548,886 586,200 37,314 6% 126 Animal Control 75,119 123 48,431 39% 77,329 116,000 38,671 33% 102,571 116,000 13,429 12% Total Public Safety 1 1 752 42% 1,059,671 1 595 36% 1 1,655 76 5% Pack 2 city Cf Chu:�!�wcccr Income Statement 09/30/97 Actual v. Budget 25% Remaining Public Works Expenditures: 131 Engineering 132 Street Maintenance 135 Street Lighting & Signals 137 City Garage Total Public Works Variance - Variance Variance - Variance 09/30/97 1997 Variance - Favorable Variance % as a / 09/30/96 1996 Favorable as a %. 12/31/96 YTD Actual 1996 Budget Favorable (Unfavorable) as a ° of bu g et YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget 81,104 1 28,300 47,196 ° 37% 81,388 126,790 45,172 _:191,007 36% 30% 114,195 583,805 126,560 627 12 43,985 10% 7% 541,331 702,370 161,039 23% ° 436,783 104,468 627790 , 151,280 46,812 31 % 148,823 151,280 2,457 2% 129,857 1 171,440 237,850 41,583 69,103 24% 29 % 154, ?_37 ?_22,250 68,013 31% 211,911 1 ?_22,250. 1 10,339 69,146 6% 921039 1 318 26% 776,876 1 351,004 31% City of Income Statement 09/30/97 Actual v. Budget 25% Remaining Page 4 09/30/97 YTD Actual 1997 Budget Variance - Favorable (Unfavorable) Variance as a % of budget 09/30/96 YTD Actual 1996 Budget Variance - Favorable (Unfavorable) Variance as a % of budget 12/31/96 YTD Actual 1996 Budget Variance - Favorable (Unfavorable) Variance as a % of budget Parks & Recreation Expenditures: 141 Park & Rec Commission 1,016 2,075 1,059 51% 843 2,125 1,282 60% 1,028 2,125 1,097 52% 142 Park & Rec Administration 52,794 72,050 19,256 27% 47,881 68,113 20,232 30% 63,333 68,113 4,780 7% 143 Recreation Center 213,884 257,500 43,616 17% 172,406 250,495 78,089 31% 259,586 250,495 (9,091) (4 %) 144 Senior Center Operation 23,075 37,300 14,225 38% 23,176 33,885 10,709 32% 30,919 33,885 2,966 9% 145 Recreation Programs 1 146 Self- Supporting Programs 116,891 33,368 168,480 51,589. 31% 115,741 145,236 29,495 20% 131,016 145,236 14,220 10% 56,410 23,042 41% 40,293 52,877 12,584 24% 48,877 52,877 4,000 8% .147 Lake Ann Park Operations 30,365 70,805 40,440 57% 28,571 59,303 30,732 52% 49,332 59,303 9,971 17% 148 Park Maintenance 253,409 407,750 154,341 38% 288,023 384,750 96,727 25% 383,836 384,750 914 0% Total Parks & Recreation 724 1 347,568 32% 716 996 279,850 28% 967 996 28 3% Page 4 City 0,11. C 14ii11a�.J J^r�i Income Statement 09/30/97 Actual v. Budget 25% Remaining Variance - Variance Variance - Variance Favorable as a % Variance - Variance ° 12/31/96 1996 as a % 09/30/96 1996 Favorable as a% / et YTD Actual Budget (Unfavorable) of budget 09/30/97 1997 Favorable of bud (Unfavorable) of budget YTD Actual Budget (Unfavorable) g YTD Actual Budget (Unfav ) ° 5,439 5,400 ( (1 %) 4,140 5,400 1,260 23 /° 33,586 25% 480 Community Development Expenditures: 5,750 2,306 40% 58,240 43% 100,894 134,480 Commission 3,444 76,240 134, 1,816 3,250 1,434 44% 151 Planning 873 183,200 73,327 40% 3,019 93% ' Administration .892 49% 231 3,250 ° 108,149 143,130 34,981 24% 152 Planning 11,358 22,250 10, 62,519 44 /° 153 Senior Facility Commission 86 41% 80,611 143,130 Total Community Development 1249675 211,200 City of Chanhassen Income Statement 09/30/97 Actual v. Budget 25% Remaining Page 6 09/30/97 YTD Actual 1997 Budget Variance - Favorable (Unfavorable) Variance as a % of budget 09/30/96 YTD Actual 1996 Budget Variance - Favorable (Unfavorable) Variance as a % of budget 12/31/96 YTD Actual 1996 Budget Variance - Favorable (Unfavorable) Variance as a % of budget General Fund Revenue: Taxes 1,937,892 3,698,256 (1,760,364) (48 %) 1,724,653 3,313,146 (1,588,493) (48 %) 2,437,642 2,373,703 63,939 3% Licenses 44,069 54,200 10,131 ( } 19% ( ) 53,678 54,200 (522) °) (1 /o 54,841 54,200 641 1% Permits 479,563 740,900 (261,337) (35 %) 549,462 763,900 (214,438) (28 %) 704,514 763,900 (59,386) (8 %) Fines and Forfeits 30,095 28,000 2,095 7% 23,095 27,500 (4,405) (16 %) 33,331 27,500 5,831 21% Intergovernmental 13,241 51,800 (38,559) (74 %) 33,399 51,800 (18,401) (36 %) 1,031,973 991,243 40,730 4% Charges for Services 245,286 527,600 (282,314) (54 %) 223,993 517,600 (293,607) (57 %) 458,255 517,600 ( 59,345 ) 11 ( ) Other Total General Fund Revenue 102,571 2,852 118,000 5 (15,429) (2 (13 %) (45 %) 101,716 2 118,500 4,846,646 (16,784) (2 (14% (44 %) 192 815 4 118 500 4 74 ,315 66 63% 1% Total General Fund Expenditures 3 5,218,667 1 35% 3 4 1 32% 4 4 246 5% Revenue Over /(Under) Expenditures (525 89 (525,889) (558 9 (567,386) 322,198 9 313,149 Page 6 CE:y C;. Chanhucccn Income Statement 09/30/97 Actual v. Budget 25% Remaining Variance - Variance Page 7 Variance - Variance ° 09/30/96 1996 Variance - Favorable Variance as a % 12/31/96 YTD Actual 1996 Budget Favorable as a % of bud et (Unfavorable) g 09/30/97 1997 Favorable Fa (Unfavorable) as a% /° of budget YTD Actual Budget ble ( Unfavorable) of budget YTD Actual Budge _ 53,800 (53,800) (100 %) 69,179 53,800 ' 15,379 29% . - 57,800 (57,800) ° ) (100 / ° 62,112 50,200 (11 912) (24 %) , 210 CATV Fund Revenue 29,100 50,200 21,100 42% Ex enditures 67,466 64,500 210 C�,TV Fund p ( 2,966) (5 %) 3,600 (32,700} 7,067 3 3,467 67 466 (6,700) Over /(Under) Expenditures ( ) (60,766) ( ?.9,100) Revenue 97 to update electronics in the City Council Chambers. equipment purchases that were made in the fiat half of ' es include 09/30/97 expend�tur major capital Page 7 City cf Chanhassen Income Statement 09/30/97 Actual v. Budget 25% Remaining Page 8 Variance - Variance Variance - Variance Variance - Variance 09/30/97 1997 Favorable as a % 09/30/96 1996 Favorable as a % 12/31/96 1996 Favorable as a % YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget 211 Environmental Protection Revenue 47,987 118 (70 (59 %) 55 134,500 (78 (58 %) 155 134 21 16% Expenditures: 231 Recycling 20,331 44,150 23,819 54% 32 44,350 11,622 26% 45 44,350 (1 (4 %) 235 Lake Management - 35,000 35,000 100% 15,897 35 19,103 55% 22,396 35,000 12,604 36% 236 Reforestation 20 44,000 23 54% 8 32,000 23 73% 26,943 32,000 5 16% Revenue Over /(Under) Expenditures 7 (5 12,387 (1 23,150 (24 60 23 37 Page 8 400 Capital Project Admin Revenue 400 Capital Project Admin Expend. Revenue Over /(Under) Expenditures Page 9 city of GNA& Income Statement \ 09/30/97 Actual v. Budget 25% Remaining Variance - Variance Variance nce - Variance a % 12/31196 1996 Variance - Favorable Variance as a % 09/30/97 0 1997 Favorable as a % 09/30/96 1996 Budget Favorable (Unfavorable) as of budget YTD Actual Budget (Unfavorable) of budget YT D Actual Budget (Unfavorable) of budget YTD Actual 384,427 (20 5% (5%) 542 405,000 137 34% 366 385,000 18 528) (5 %) .405,000 583 565 (18 (3 %) 280,578 325,100 44,522 ° 14% 328,094 405,000 76 906 19% 56,333 (40,880) (160,000) 119,120 85,894 59,900 255994 56133 Page 9 City of Cl h & ccen Income Statement 09/30/97 Actual v. Budget 25% Remaining Page 10 Variance - Variance Variance - Variance Variance - Variance 09/30/97 1997 Favorable as a % 09/30/96 1996 Favorable as a % 12/31/96 1996 Favorable as a % YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget 410 Park Trailways Acq & Dev Revenue 391 319,000 72,625 23% 360,670 449,000 (88,330) (20 %) 506 449,000 57,383 13% 410 Park Trailways Acq & Dev Expend. 281,897 391 109,103 28% 237,451 273,600 36,149 13% 431 273 (158 (58 %) Revenue Over /(Under) Expenditures 109 (72,000) 181 123 175,400 (52,181) 74 175,400 (100 Page 10 city c# ch: �:�lucscrt Income Statement 09/30/97 Actual v. Budget 25% Remaining Page 11 09/30/97 YTD Actual 1997 Budget Variance - Favorable (Unfavorable) Variance as a % of bud et g T 09/30/96 YTD Actual 1996 Budget Variance - Favorable (Unfavorable) Variance as a % of budget 12/31/96 I YTD Actua 1996 Bud et Variance - Favorable (Unfavorable) Variance as a of budget 460 Tax Increment District #1 Revenue 460 Tax Increment District #1 Expend. Revenue Over /(Under) Expenditures 4,149,247 1 3 6 1,627,5 44 4,432,456 (1 601 (1 (32 %) � 37% 21736,453 1 1 5,798,000 1,915,97.5 3, 882 (3,061,547) 483,266 (2,578,281} (5 3% ) 25% 5 2 3,309,429 51798,000 1,915,975 3 (9 (562 (572 (0 %) (29 %) "1996 budgeted expenditures did not take into account several new special assessment payments made to new businesses. Page 11 City of Chanhasscn Income Statement 09/30/97 Actual v. Budget 25% Remaining ' 1996 & 1997 expenditures include special assessment payments for the Recreation Center /School Project as per agreement between the City of Chanhassen and ISD 112. Page 12 Variance - Variance Variance - Variance Variance - Variance 09/30/97 1997 Favorable as a % 09/30/96 1996 Favorable as a % 12/31/96 1996 Favorable as a % YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget 468 Economic Dev. District #2 Revenue 340,135 730,000 (389 (53 %) 306,090 720,000 (413,910) (57 %) 650,706 720,000 (69,294) (10 %) 468 Economic Dev. District #2 Expend. 216 60,300 (155,812) (258 %) 127 65,500 (61 (94 %) 369 65 (303 (464 %) Revenue Over /(Under) Expenditures 124 669,700 (545,677) 178 654,500 (475,707) 281 654,500 (373,176) ' 1996 & 1997 expenditures include special assessment payments for the Recreation Center /School Project as per agreement between the City of Chanhassen and ISD 112. Page 12 City of Chanhas�cn Income Statement 09/30/97 Actual v. Budget 25% Remaining 700 S & W Utility Revenue Expenses: 701 Utility Administration 702 S & W Operations Revenue Over/(Under) Expenses Page 13 Variance - Variance Variance Variance 1996 Variance - Favorable Variance as a % 12/31/96 1996 Budget Favorable (Unfavorable) as a % of budge t 09/30/97 1997 Favorable as a % 09130/96 YTD Actual Budget U nf avorab le ) of budget YTD Actual YTD Actual Budget ( Unfavorable) of budget (490,000) ( 25% ) 213079955 11959,100 3489855 18% 1,404,314 29122,100 (717,786) (3 4% ) 114699100 1,959,100 91,730 1339000 419270 31 % 127,805 11784,851 133,000 197729500 5195 (12,351) ° 4° ° ( / ) 739953 121,500 47,547 39% 17% 1,366,804 1,772,500 405,696 2 3% 1633,841 1,973,900 340,059 395,299 53,600 3419699 109566 539600 (439034) (3039480) 26,700 (330 Page 13 City of Charhacscn Income Statement 09/30/97 Actual v. Budget 25% Remaining Page 14 Variance - Variance Variance - Variance Variance - Variance 09/30/97 1997 Favorable as a % 09/30/96 1996 Favorable as a % 12/31/96 1996 Favorable as a % YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget 710 Sanitary S &W Expansion Revenue 293 350,000 (56,986) (16 %) 292,740 350,000 (57,260) (16 %) 1,058 350,000 708 203% 710 Sanitary S &W Expansion Expense 308 863 554,787 64% 282,982 859,385 576,403 67% 391 859 468 54% Revenue Over /(Under) Expenses (15 (513,750) 497,801 9 (509,385) 519,143 667 (509,385) 1 Page 14 Cit of chanhasSi r Income Statement 09/30/97 Actual v. Budget 25% Remaining Variance - Variance Variance - Variance 1996 Favorable as a Variance - Variance 996 Favorable as a % 12131/96 09130/96 et YTD Actual Budget (Unfavorable) of budget 1997 Favorable as a% Unfavorable) of budg 09/30/97 of bud et YTD Actual Budget ( YTD Actual Budget (Unfavorable) 9 ° 257 830 315,000 (57,170) (18 %) ° 296,810 315,000 (18,190) (6%) ' 415,000 (1,332) ( / °) 4469900 224,929 50% 720 Surface Water Mgmt Utility Revenue 413,668 266919 60% 221,971 338 677 77% 179,981 446,900 ' it E 99,823 438 � 35,859 (131,900) 167,759 720 Surface Water Mgmt utility P 116,829 (131,900} 248,729 Revenue Over/(Under) Expenses 313,845 (23,500) 337,345 City of Churhucscn Income Statement 09/30/97 Actual v. Budget 25% Remaining 800 Historic Preservation Trst Revenue 800 Historic Preservation Trst Expend. Revenue Over /(Under) Expenditures 09/30/97 1997 Variance - Favorable Variance as a % 09/30/96 1996 Variance - Favorable Variance as a % 12/31/96 1996 Variance - Favorable Variance as a % YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget 46,598 518 (471 (91 %) 756 897 (140,792) (16 %) 894 897 (3 (0 %) 311 461 150,536 33% 354 476 121 25% 464 476 11 2% (264 56 (320,966) 401,352 421,070 (19 429,173 421 8,103 Page 16 City of �� r ,. ., �+ r � , u �� uJJ�+ Income Statement 09/30/97 Actual v. Budget 25% Remaining Variance - Variance Variance - Variance 1996 Favorable as a % Variance as a% % 12131196 of budget Variance 6 1996 Favorable YTD Actual Budget (Unfavorable) as a % 0913019 of budget 0197 1997 Favorable Bu d (Unfavorable) 0913 (Unfavorable) of budget YTD Actual g et YTD Actual Budget ( 73,000 22,785 31% 0 (56,354) (77 %) 959785 73,00 55,900 (17,976) (32 %) 59,772) (75 %) 169646 3 876 20,228 80,000 ( 00 46,824 84% 7 39876 ' 850 Firefighters' Relief Revenue 9,076 55,9 41809 2,1.. 55,900 53,800 96% 17,100 5 9 850 Firefighters' Relief Expenditures 00 71570 .17,100 (9 30 1 ) 21,90 Ex enditures 18,128 24,100 (51972) RRevenue Over /(finder) p Page 17 City of Chunhao ,sen Income Statement 09/30/97 Actual v. Budget 25% Remaining . Variance - Variance Variance - Variance Variance - Variance 09/30/97 1997 Favorable as a % 09/30/96 1996 Favorable as a % 12/31/96 1996 Favorable as a % YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget YTD Actual Budget (Unfavorable) of budget 950 Vehicle /Equip Maint. Revenue 215,049 460 (244,951) (53 %) 232,035 500,000 (267,965) (54 %) 542 500,000 42 9% 950 Vehicle /Equip Maint. Expenses 644,760 493 (151 (31 %) 785 900,000 114 13% 635 900 264,782 29% Revenue Over /(Under) Expenses (429,711) (33,000) (396,711) (553 (400,000) (153,064) (92,459) (400,000) 307 Page 18 STATEMENTS CITY OF CHANHASSEN, MINNESOTA GENERAL FUND SCHEDULE OF EXPENDITUR DD 3GE996ND ACTUAL FOR THE YEAR ENDED 1996 1995 -- Budget Actual Variance Actual EXPENDITURES: General Government: Legislative - Current: . Personal services Materials and supplies Contractual services Total current Administrative office - Current: r Personal services Materials and supplies Contractual services Allocation to capital projects Total current Capital outlay Finance - Current: Personal services Materials and supplies Contractual services Allocation to capital projects Total current Capital outlay Election - Current: Personal services Materials and supplies Contractual services Total current Capital outlay Legal - Current: Contractual services Property assessment - Current: Contractual services City Hall - Current: Materials and supplies Contractual services Total current Capital outlay Total current Total capital outlay Total General Government 28,500 $ 26 $ 2,298 $ 37,950 375 900 1179342 823 103,039 77 14,303. 186,251 146, 742 130,064 169678 224,576 201,400 1839410 179990 (87) 169,237 19,828 21 550 ' 539630 21 49,105 4, 525 40,843 (54,456) 61,779 7,323 55,144 174,764 222,124 192,373 29,751 1,000 _ 1 000 - 1299700 1 ( 40,965) 2,806 1279364 29 077 59320 539850 2,514 53,355 495 2,'440 429800 35,.680 45 248 ' 47,688 178,846 ( 3 5, 224 136 143.. 622 ' 39,740 38,589 _ -� 11151 -- 289755 16,600 18,161 (1 (902) " - 19400 6 250 2,302 159114 8,664 _ " ' 24, 250 35 11 327 ) ( , ' 79750 69392 19358 80,000 98 189099 84,275 72,600 48 913 23,687 45,399 129500 91405 188,483 31 09 .5 (249633 6,082 79,268 163 850 ' 1769350 197 ( 21,538 85,350 519 500 865,688 - 881 760 � 500 16,072 750,925 29,274 48, 990 44,981 926, 741 49009 12, 063 780,199 914 (Continued) 58 Al CITY OF CHANHASSEN, MINNESOTA GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED DECEMBER 31, 1996 STATEMENT 9 (Continued 1996 1 995 Public Safety: Budget Actual Variance Actual Police - Current: Personal services $ 206,300 $ 211,832 5 53 $ ( 2) $ 185 Materials and supplies 6,500 6 (415) 5 Contractual services 501,829 492 9 464 Allocation to capital projects (35 43,244 7 39 12 Total current 678 667, 861 10 616,739 Capital outlay Fire department - 4 5,997 1 897 302 Current: Personal services 141 136 5 326 122,389 Materials and supplies 37 40,566 (3 37 607 Contractual services 94,950 79 15 89,777 Allocation to capital projects (14,343) (14,343) (14 4,123 1 220 (220 - ( ) 1 5 482 ( ) Total current 259,507 241 17 234 Capital outlay Code enforcement - 8,300 9,106 806 16 284 Current: Personal services 532 505,127 27,753 449 Materials and supplies 15 18,758 (2 17,335 Contractual services 23 20 2 26 Total current 572 544 27 492,885 Capital outlay 13,850 4,310 9 2,032 Animal control - Current: Personal services 81 75 6,268 72 125 Materials and supplies 10,600 7 2,966 7 Contractual services 18 16 2 20 ,Total current 111 99 11 100 Capital outlay 5 3 1 535 Public safety commission - Current: Personal services _ - - 224 Material and supplies 650 680 (30) 703 Contractual services 1 1, 635 40 1,781 Total current 2 2 10 2 Total current 19623,875 19555 68 1,446,814 Total capital outlay 31 22,660 81590 19,153 Total Public Safety 1 1,578,422 76 1;465,967 59 (Continued) STATEMENT 9 CITY OF CHANHASSEN MINNESOTA (continued) GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED DECEMBER 31 1996 1996 1995 gudaet Actual Variance Actual Public Works: Engineering - Current: Personal services $ 140 $ 137,917 $ 2 $ 131 Materials and supplies 6 5 1 3 Contractual services 8,700 7 1 3 9 654 Allocation to capital projects (31 (37 ) 6 (33 9 572) Total current 124 112 11 105 Capital outlay 2,500 1 911 2,487 Street maintenance - , Current: Personal services 374,500 370,947 3 342 Materials and supplies 165,300 186 (20 163 Contractual services 191 151,466 40 196 Allocation to expendable trust fund 110,760 (131 075) 20 (127 Total current 620 577,590 43 575 Capital outlay P Y 7 6,215 '985 1,589 Street lighting - Current: Materials and supplies 2 2 (77) 282 Contractual services 192 194 (1 175 Allocation to expendable trust fund (42 (47 4 (42 Total current 151 148,823 2 133,733 City garage - Current: Personal services 167 165 1 156 Materials and supplies 9 8 996 8 Contractual services 41 33 8,260 29 Total current 218 207 10,590 194, 966 Capital outlay P Y 4 4 (251) 7 Total current 1 1,046,579 67,501 1 Total capital outlay 13 12,155 1 11 Total Public Works 1 1 69 1,021,029 60 (Continued) CITY OF CHANHASSEN, MINNESOTA GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL FOR TH E YEAR ENDED DECEMBER 31, 1996 STATEMENT 9 (Continued) 61 (Continued) 1996 1995 Budget Actual Variance Actual Parks and Recreation: Parks and Recreation Commission - Current: Materials and supplies $ 275 $ 15 $ 260 $ 55 Contractual services 1,850 1,013 837 1,300 Total current 2,125 1,028 1,097 1 Parks and Recreation Administration - Current: Personal services 55,200 55,320 (120) 49,440 Materials and supplies 1 2,379 (516) 1 Contractual services 11,050 5,634 5,416 17,691 Total current 68,113 63,333 4 68,802 Recreation Center - Current: Personal services 172,955 180 (7 38,129 Materials and supplies 22,670 21,736 934 7,576 Contractual services 54,870 56,919 (2,049) 20,453 Total current 250,495 259,586 (9,091) 66,158 Senior Citizen Center - Current: Personal services 26,900 18,234 8,666 26,827 Materials and supplies 3,475 721 2,754 2,446 Contractual services 3,510 4,736 ' (1,226) 3,125 Total current 33,885 23,691 10,194 32,398 Recreation Programs - Current: Personal services 76,237 73,438 2 69,283 Materials and supplies 14,907 13 1,303 11,021 Contractual services 54,092 43,974 10,118 60,083 Total current 145,236 131,016 14,220 140,387 Self- supporting Programs - Current: Personal services 20,781 26,709 (5 22,197 Materials and supplies 13,470 8,489 4 7 Contractual services 18,626 13,679 4,947 21,003 Total current 52,877 48,877 4,000 50,804 Lake Ann Park Operations - Current: Personal services 16,500 14 1 15,069 Materials and supplies 8,866 7,307 1 8 Contractual services. 33,937 27,121 6,816. 33,311 Total current 59 49,332 9,971 57,299 Park maintenance - Current: Personal services 214,200 229 (15 199 Materials and supplies 68 89,174 (21,174) 54,644 Contractual services 84,550 46,992 37,558 61,434 Total current 366,750 365,569 1,181 316,031 Capital outlay 18,000 18,267 (267) 4,185 Total current 978,784 942,432 36,352 733,234 Total capital outlay 18,000 18,267 (267) 4,185 Total Parks and Recreation 996,784 960,699 36,085 737,419 61 (Continued) CITY OF CHANHASSEN9 MINNESOTA STATEMENT 9 (Continued) GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL FO R THE YEAR E NDED DECEMBER 31,1996 �I 62 1996 1995 Budget Actual Variance Actual Community Development: Planning commission - Current: 0 Materials and supplies • $ 200 5,200 2 _ $ 5,439 $ 200 ( 239 $ 122 3 Contractual services 5 5 439 ' (39) 4,000 Total current Planning administration - Current: 1289700 122,776 5,924 120,$82 Personal services t ' . 2,400 1,359 1,041 19586 Materials and supplies 36 000 11,795 2 4,205 10 Contractual services ion to capital projects Allocat p P l (33,620) 35,036 1,416 32,586. __ (33,581) 99 , 275 Total current Tot 133,480 - 100 - 1,000 _ Capital outlay 1,000 - Senior Facility Commission - Current: 7 (7 8 Personal services 1,05 0 1,141 (91) 124 Materials and supplies • 200 2, 675 1,525 19370. Contractual services - 3 9,044 - (5,794 9,697 Total current 142,130 115,377 26,753 112 To tal current To _ 1, 000 _ 1, 000 - Total capital outlay P Total Community Development 143 115,377 27,753 112,972 Total current without - allocation to capital projects and expendable 5,093,380 4,959,846 133 4 trust fund - all departments Total allocation to capital projects and expendable trust fund - all departments - (368,823) (417,936) 49 382,138 Total capital outlay - all 113,040 98,0 63 14,977 63,857 de artments P Total all departments $ 4 4 639,973 $ , $ 197,624 $ 4,117,586 �I 62 CITY OF CHANHASSEN, MINNESOTA COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUND FOR THE YEAR ENDED DECEMBER 31, 1996 EXPENDITURES: Governmental Fund Types Current: Special Debt Capital General Revenue Service Project REVENUES: Public safety 1,555,762 73,876 - General property taxes (Note 1) $ 2,897,642 $ 137,500 $ 724,907 $ - Tax increment - - - 6,497,502 Special assessments - - 3,005,522 7,393 Licenses and permits 759,355 - - 406,915 Intergovernmental 1,031,973 69,697 - 754,252 Charges for services 458,255 5,967 - 377,008 Fines and forfeits 33,331 - - - Interest ors investments . 78,450 44,430 270,184 470,851 Other 114,365 63,426 7,546 413,270 Total revenues 5,373,371 321,020 4,008,159 8,927,191 EXPENDITURES: Current: General government 881,760 132,901 - 390,717 Public safety 1,555,762 73,876 - - Public works 1,046,579 - - - Parks and recreation 942,432 - - - Community development 115,377 - - - Interfund interest - - 140,090 186,620 Contractual services and other - - 15,678 1,818,918 Capital outlay 98,063 24,739 - 9,666,579 Debt service: Principal - - 9,335,000 406,999 Interest and paying agent fees - - 2,678,597 41,063 Special assessment payments - - - 1,858,723 Other - - - 698,821 Total expenditures 4,639,973 231,516 12,169,365 15,068,440 EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES 733,398 89,504 (8,161,206) (6,141,249) OTHER FINANCING SOURCES (USES): Operating transfers in - - 4,057,432 240,979 Operating transfers out (460,000) - (87,255) (4,028,556) Bond proceeds - - 1,232,024 8,809,355 Total other financing sources (uses) (460,000) - 5,202,201 5,021,778 EXCESS (DEFICIENCY) OF REVENUES AND OTHER SOURCES OVER EXPENDITURES AND OTHER USES 273,398 89,504 (2,959,005) (1,119,471) FUND BALANCES AT BEGINNING OF YEAR, as restated (Note 18) 1,702,677 744,543 8,711,784 4,113,497 EQUITY TRANSFERS (Note 1) - - (6,062) 6,062 FUND BALANCES AT END OF YEAR $ 1,976,075 $ 834,047 $ 5,746,717 $ 3,000,088 See notes to financial statements. 22 STATEMENT 2 Fiduciary _ Fund Type Expendable Totals (Memorandum Only Trust 1996 1995 _ $ 3,7601049 '�$ 3,280,754 - 6,497,502✓ 5,954,834 - 3,012,915 ✓ 2,937,666 _ 1,166,270 ✓ 1,433,301 _ 1,855,922 ✓ 2,105,306 841,230 586,888 _ 33,331 ✓ 34,243 97,729 961,644%,✓ 2,636,291 796,369 894,098 1,394,976- 19,523,839 1,623,169 20,592,452 455,615 1,860,993 1,753,048 1,629,638 1,4461814 _ 1,046,579 1,009,784 _ 942,432 733,234 _ 115,377 112,972 _ 326,710 247,356 _ 1,834,596 2,278,713 9,310 9,798,691 5,756,653 _ 9,741,999w 17,598,855 _ 2,719,660 ✓ 3,756,768 _ 1,858,723 1,373,362 _ _ 698,821 442,690 464,925 32,574,219 _ 36,510,249 429,173 (13,050,380) (15,917,797) _ 4,298,411 % 17,796,067 _ (4,575,811) (18,161,423) _ 10,041,379 9,790,434 _ 9,763,979 9,425,078 429,173 (3,286,401) (6,492,719) 1,733,169 17,005,670 23,468,771 _ _ 29,618 $ 2,1 62,342 $ 13,719,269 $ 17,005,670 CITY OF CHANHASSEN, MINNESOTA COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUND YEAR ENDED DECEMBER 31, 1995 Governmental Fund Tvaes REVENUES: General property taxes (Note 1) Tax increment Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Interest on investments Rents and other Total revenues EXPENDITURES: Current: General government Public safety Public works Parks and recreation Community development Interfund interest Contractual services and other Capital outlay Debt service: Principal Interest and paying agent fees Special assessment payments Valuation writedown of investment Other Total expenditures EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES OTHER FINANCING SOURCES (USES): Operating transfers in Operating transfers out Bond proceeds Total other financing (uses) sources EXCESS (DEFICIENCY) OF REVENUES AND OTHER SOURCES OVER EXPENDITURES AND OTHER USES FUND BALANCES AT BEGINNING OF YEAR EQUITY TRANSFERS (Note 1) FUND BALANCES AT END OF YEAR See notes to financial statements. 4,949,025 Special Debt Capital General Revenue Service Project $ 2,423,281 $ 104,502 $ 719,971 17,796,067 75,298 172,058 $ 5,954,834 63,857 839 5,390,284 2,933,546 4,120 968,246 9,628,759 (339,485) 465,055 1,028,787 7,280 1,028,128 358,550 2,409 (11,972,481) 225,879 34,243 575,986 20,862,836 175,294 89,357 28,201 952,006 565,226 4,949,025 191,414 4,635,023 8,677,745 750,925 131,803 392,417 1,446,814 1,009,784 58,772 733,234 (1,368,919) 112,972 17,796,067 75,298 172,058 (339,485) 2,860 2,275,853 63,857 839 5,390,284 17,598,855 3,756,768 1,373,362 4,117,586 132.642 21,433,781 10,046,664 83 1,439 58,772 (16,798,758) (1,368,919) 17,796,067 (339,485) (13,131,465). (4,690,473) 161,675 9,628,759 (339,485) 4,826,277 4,938,286 491,954 58,772 (11,972,481) 3,569,367 1,210,723 575,986 20,862,836 175,294 (178,571) 208,189 $ 1,702,677 $ 634,758 $ 8,711,784 $ 3,952,850 22 STATEMENT 2 Fiduciary Fund Type Totals Expendable (Memorandum Only) Trust 1995 1994 $ 3,247,754 $ 2,822,135 5,954,834 5,499,412 2,937,666 2,417,638 1,433,301 1,541,035 2,064,195 1,067,920 $ 50 586,888 618,145 34,243 28,745 996,135 2,630,925 1,178,362 1,063,583 1,623,169 1,262,006 2,059,768 20,512,975 16,435,398 403,183 1,678,328 1,656,622 1,446,814 1,312,456 1,009,784 934,844 733,234 564,350 112,972 109,458 247,356 251,026 2,278,713 2,662,214 462,320 5,917,300 4,638,334 17,598,855 4,152,871 3,756,768 3,625,424 1,373,362 1,325,151 3,972,372 442,690 563,068 865,503 36,596,176 25,768,190 1,194,265 (16,083,201) (9,332,792) 17,796,067 4,487,690 (18,161,423) (4,525,390) 9,790,434 11,079,884 9,425,078 11,042,184 1,194,265 (6,658,123) 1,709,392 538,904 23,363,743 21,654,351 29,618 $ 1,733,169 S 16,735,238 $ 23,363,743 23 CITY OF CHANHASSEN, MINNESOTA COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES -ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUND YEAR ENDED DECEMBER 31, 1994 Governmental Fund Tvoes REVENUES: General property taxes (Note 1) Tax increment Special assessments Licenses and permits Intergovernmental Charges for services Fines and forfeits Interest on investments Rents and other Total revenues EXPENDITURES: Current: General government Public safety Public works Parks and recreation Community development Interfund interest Contractual services and other Capital outlay Debt service: Principal Interest and paying agent fees Special assessment payments Valuation writedown of investment Other Total expenditures EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES OTHER FINANCING SOURCES (USES): Operating transfers in Operating transfers out Bond proceeds Total other financing (uses) sources (DEFICIENCY) EXCESS OF REVENUES AND OTHER SOURCES OVER EXPENDITURES AND OTHER USES FUND BALANCES AT BEGINNING OF YEAR EQUITY TRANSFERS (Note 1) FUND BALANCES AT END OF YEAR See notes to financial statements. 699 Special Debt Capital General Revenue Service Project $ 2 $ 122,008 $ 697 109,458\/ 77,747 V $ 5 J 2 3,055 977,333 6,090 563 997 8,242 { r 4,152,871'' 3,625,424 61,769 366,566 3 247,917 28,745 1,143,569 � 82,575 30 741,094 324,383 53,200 ✓ 43,094 52,402 499,584 4,509 207,266 3,905,079 7,199 699 137,382 ✓ (695,850) 370,883.' 1,312,456`/, 2,206,400 12,267,084 (354,600) 1 349,826 ✓ 109,458\/ 77,747 V J 2t}4,500 ✓ 173,279-- 2,457,714 49,734 V 6,090 4 { r 4,152,871'' 3,625,424 1,325 � 1,143,569 � / 563,068- 3,670,410 _ 143,472 8,060,542 10,597,445 839,045 63,794 (870,300) (870,300) (4,155 (3 4 398,240 (695,850) (2 8,873,484 2,206,400 12,267,084 (354,600) (31 63,794 8,111,621 (3,752,223) 1 512 12,751 3 30,000) 30,000 $ 1.210.723 $ 575.986 $ 20.862.83 $ 175.29 24 STATEMENT 2 Fiduciary Fund Type Totals Expendable _ (Memorandum Only Trust 1994 1993 2,822J35 2,726,999 5,499,412 5,153,195 2,332 2,417,6381 1,541,035 v 799,450 1,067,920 2,000,209 50 618,145 ✓ 28,745 859,098'' 23,224 '✓ 1,178,362` 2,281,406 613,726 1,262,006 r/ 635,914 613,776 16,435,398 16,811,641 448,789 1,656,622 - - 1,471,276 1,312,456 1,182 1,149,368 1,100,434 3219198261./ 271,713 109,458 V 107,848 251,026.., 323,292 18,729 `'� 2,662,214 _. 4,638,334 _� 1,588 10 4,152,871 3,560,000 3,625,424 2,683,201 ✓ 1,325,151 1,269,700 2;828 3,972,372 625,488 563.068 908,848 3,296,321 25,768,190 25,9651348 (2,682,545) (9,332,792) (9 4,487 v 690 ' 4,653,292 (4,525,390) (5,183,746) 11,079,884 15,508,056 11,042,184 14,977,602 (21,682,545) 1 6,173,349 3,221,449 21,654,351 15,884,349 (53,893 538 g 23.363 S 21.654 25 CITY OF CHANHASSEN, MINNESOTA COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES -ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUND YE AR ENDED DECEMBE 31, 1993 See notes to financial statements. 24 Governmental Fund Types Special Debt Capital General Revenue Service Project REVENUES: General property taxes (Note 1) $ 2,123,071 $ 84,713 $ 519,215 Tax increment $ 5,153,195 Special assessments 2 Licenses and permits 632,571 166,879 Intergovernmental 779,778 37,586 182,786 1 Charges for services 400,148 8,013 450,887 Fines and forfeits 23,224 Interest on investments 237 55,581 750,878 912,247 Valuation writedown of investments (12,168) (395,562) , Rents and other 64,037 42,401 55,832 222,654 Total revenues 4,247,829 228,294 3,840,857 7,510,359 EXPENDITURES: Current: General government 734,276 116,334 385,150 Public safety 1,182,192 Public works 1,100 Parks and recreation 2 71, 713 Community development 107,848 Interfund interest 9 313,654 Contractual services and other 53,850 1 Capital outlay 31,072 2 10,836,968 Debt service: Principal 3, 560,000 1,269, 700 Interest and paying agent fees 2,683,201 908,848 Total expenditures 3,427,535 118,441 6,306,689 15,249,419 EXCESS (DEFICIENCY) OF REVENUES OVER EXPENDITURES 820,294 109,853 (2,465,832) (7 OTHER FINANCING SOURCES (USES): 1 Operating transfers in 3 795,000 Operating transfers out (775,000) (21,000) (4,038,292) Bond proceeds 2,112,906 13,395,150 , Total other financing sources (uses) (775,000) (21,000) 5,971,198 10,151,858 EXCESS (DEFICIENCY) OF REVENUES AND OTHER SOURCES OVER EXPENDITURES AND OTHER USES 45,294 88,853 3 2 FUND BALANCES AT BEGINNING OF YEAR 1 423,339 9,649,196 1 EQUITY TRANSFERS (Note 1) (403,347) FUND BALANCES AT END OF YEAR $ 1,271,978 $ 512,192 $ 12,751,215 $ 3,897,517 See notes to financial statements. 24 STATEMENT 2 Fiduciary Fund Type___ Totals Expendable (Memorandum Only) Trust 1993 1992 $ 2 $ 2 5,153,195 6 2 2,17 7,120 799,450 739,094 $ 50 2 859,098 1 845,993 23,224 36,760 325,532 2,281,406 2 (217,758) (625,488) 250.990 635,914 2,250,699 358,814 16 18 235,516 1,471,276 1 1 1,079, 793 1,100 1,011 271 218,865 107,848 108,477 323,292 596,032 1,588,949 887,952 2 10,872,407 10,087,265 4 6 3,592.049 2,998,698 237,776 25,339,860 24,745.620 121,038 (9,153, 707) (6,468,461) 4 6 (4,834,292) (6 15,508,056 4,940,354 15,327,056 4,940,354 121,038 6,173,349 (1,528,107) 3 15,884,349 19,224,962 (403,347) (1,812,506) $ 3,221,449 $ 21,654,351 $ 15,884,349 25 TABLE 13 CITY OF CHANHASSEN, MINNESOTA PROPERTY VALUE AND CONSTRUCTION LAST TEN FISCAL YEARS Commercial Construction Residential Number Construction of Units Value 1987 Number $ 1,951,000 Market Property Value of Units Value Commercial Residential Nontaxable* 337 $ 31,192,500 $ 40,630 $ 251 $ 416 38,428 49 300,501 387 35,663,800 70,581 354 162 25 93,086,600 421,019,700 191 27,519 114 478,925 229 34 102,972,700 527,470,600 66,282,900 267 44 107,522,700 561,471,100 379 62,922,100 106,481,100 594 478 62,380,800 110,875,000 681 207 43,828,600 122,913,865 789,164,135 Fiscal Number Year of Units Value 1987 6 $ 1,951,000 1988 18 7 1989 8 31 1990 8 9 1991 31 4,056,000 1992 52 5,469,400 1993 45 5,221 1994 58 16,431 1995 67 19 1996 65 13,339,700 Information is only available every sixth year. 11A twt taaawawtttttattttttttrra wwaaaatawtttwtttwatatwaawra atawttwwtwt wtwtawwttt CONTRACT CONTINUATION.SHEET taawtwatwwtta waattatawtwtt taattwaww twaawwawtwaaaataw wtttattawwa ttttttwtwtt tawaaatttt,tawwwtaaataa PROJECTOWNER City of Chanhassen Project: Chanhassen Kitchen Application #4 trt ttawaaaawatwwtttttttttat Construction Manager: ttataaawtawtttatttaatattttt AMCON CM. ttaaaaaatat tttttwtaaa atwtaaatttatt wtawwttttawaa Period Ending : 9/30/97 tatatttaw wtatatwtwwttttaaa wawwawtttta ttawtwwaaww Page wttttataww,tttawtatwtrw No. 2 of 2 A B C D E F G H I J K L - - - - -- --------- M - - - - -- - - -- -------------------------- - - - - -- ----- •-------- •-------------- - - - - -- Contractor --------- - - - - -- Original ------ ------ Change ----------- - - - - -- Contract ----------- - - - - -- Total Compl. ------ - - - - -- ---------------- - - - - -- --------- - - - - -- --------- - - - - -- Current ------- Balance or Contract Orders To Sum To and Stored Total Earned Previous Payment % to # Description Supplier Sum Contract Date to Date Ret. Less Ret. Requests Due Completed - - - - -- --------- Finish - - - - -- - - -- -------------------------- - - - - -- 1 Concrete ----------------------------- - - - - -- Goebel Construction --------- - - - - -- 2,400 ------- - - - - -- 0 ----------- - - - - -- 2,400 ----------- - - - - -- 2,400 ------ - - - - -- 120 ---------------- - - - - -- --------- 2,280 - - - - -- --------- 2,280 - - - - -- 0 ------- 100% 0 2 Carpentry & Gyp. Board Friedges Drywall, Inc. 7,500 0 7,500 0 0 0 0 0 0% 7,500 3 Tile Work Twin City Tile 3,600 0 3,600 1,400 70 1,330 0 1,330 39% 2,200 4 Acoustical Tile & FRP Architectural Sales 4,521 0 4,521 4,000 200 3,800 0 3,800 88% 521 5 Kitchen Equipment St. Cloud Kitchen 33,989 250 34,239 0 0 0 0 0 0% 34,239 6 Mechanical McGuire Mechanical 65,211 0 65,211 50,303 2,515 47,788 32,776 15,012 77% 14,908 7 Electrical Page Electrical 12,750 0 12,750 9,000 450 8,550 8,550 0 71% 3,750 0 0 0 0 0 0 0% 0 Roofing Kato Roofing /Base Contract 4,872 -4,872 0 0 0 0 0 0 0% 0 Painting Rainbow, Inc. 820 0 820 0 0 0 0 0 0% 820 Doors Bredemus 950 177 1,127 1,127 0 1,127 902 225 100% 0 0 0 0 0 0 0 0 0 0% 0 0 0 0 0 0 0 0 0 0% 0 0 0 0 0 0 0 0% 0 General Conditions Various 7,556 0 7,556 6,979 0 6,979 5,606 1,373 92% 577 CM Fee Amcon CM 2,500 0 2,500 2,300 0 2,300 2,070 230 92% 200 Contingency City 0 0 0 - -- 0 ------- - - - -- 0 -------- - - - - -- 0 -------- - - - - -- 0 -------- - - - - -- 0% -------- - - - - -- 0 ----- - - - - -- --------------------- - - - - -- GRAND TOTALS --------------------- - - - - -- --------- - - - - -- $146,669 ------ - - - - -- ($4,445) -------- - - - - -- $142,224 -------- - - - $77,509 - $3,355 $74,154 $52,184 $21,970 54% $64,715 w 9/30/97 age: 1 ate: 10/28/97 at 4:21 PM City of Chanhassen General Ledger Detail Report - Single Segment Only From period 01/1997 to 10/1997 For Segment = 4 Segment Value: 601, Segment2 = 4, Segment Value: From 601 to 601 Exclude Zero Activity Accounts Ck.# Rec.# ccount Number Account Description Batch Other Debit Amount Credit Amount Short Entry ran Date Src Transaction Description Begin. Balance Net Change Ending Balance Description PRG No 601 SENIOR CENTER 061 - 458 - 000 -601 ContrRet- CtyHLExp - *- SrCenter eginning Balance 0.00 7/16/1997 AP IV# 7397 BREDEMUS HARDWARE 001083 76646 0.00 47.50 r; 47.50) SR CENTER EXP -D 7/16/1997 AP IV# 72597 GOEBEL CONSTRUCTION CO, 1 001083 76694 0.00 120.00 167.50) SR CENTER EXP -C 7/16/1997 AP IV# 72197 MCGUIRE MECHANICAL SERVIC 001083 76715 0.00 1 1 SR CENTER EXP -M 7/16/1997 AP IV# 73097 PAGE ELECTRICAL CONTR. 001083 76741 0.00 337.50 f 1,590.65) ST CENTER EXP-E 3/29/1997 AP IV# 081897 MCGUIRE MECHANICAL SERVI 001181 77313 0.00 639.40 t; 2 MECHANICAL -SR D 3/29/1997 AP IV# 083097 PAGE ELECTRICAL CONTR. 001181 77329 0.00 112.50 2 ELECTRICAL -SR. ?/23/1997 AP IV# 092397 ARCHITECTURAL SALES ON M 001222 77461 0.00 200.00 t; 2 ACOUSTICAL TREA ?/23/1997 AP IV# 093097 MCGUIRE MECHANICAL SERVI 001222 77578 0.00 790.10 3 VECHANI CAL-SR C ?/26/1997 AP IV# 091997 TWIN CITY TILE & MARBLE 001222 77656 0.00 70.00 3 402 65) TILE WORK-SR C -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - Account Total: $ 0.00 0.00 3,402.65 ($ 3 ($ 3,,402.65) 300 - 458 - 000 --601 Sery Fee - CtyHLExp - *- SrCenter ginning Ba €ance 0.00 3/01/1997 AP IV# 97207 AMCON CM 001084 76627 4,052.32 0.00 4 SR CENTER EXP -C ?/07/1997 AP IV# 97209 AMCON CM 001182 77228 202.73 0.00 4 CONSTRUCTION MG ?113/1997 AP IV# 97211 AMCON CM 001222 77456 1 0.00 - 5 WORK FOR SR DIN x/22/1997 AP IV# 097209 AMCON CM 001222 77456 1,200.00 0.00 7 CONSTRUCTION MG Account Total: $ 0.00 7,057.59 0.00 $ 7 $ 7,057.59 r51- 458 -000 -601 ConstrCo- CtyHLExp - *- SrCenter :ginning Balance 0.00 x/16/1997 AP IV# 7397 BREDEMUS HARDWARE 001083 76646 950.00 0.00 950.00 SR CENTER EXP -D x/16/1997 AP IV# 72597 GOEBEL CONSTRUCTION CO, 1 001083 76694 2 0.00 3 SR CENTER EXP -C x/16/1997 AP IV# 72197 MCGUIRE MECHANICAL SERVIC 001083 76715 21 0.00 25 SR CENTER EXP -M x/16/1997 AP IV# 73097 PAGE ELECTRICAL CONTR. 001083 76741 6 0.00 31 ST CENTER EXP -E 3/29/1997 AP IV# 081897 MCGUIRE MECHANICAL SERVI 001181 77313 12 0.00 44 MECHANICAL -SR D 3/29/1997 AP IV# 083097 PAGE ELECTRICAL CONTR. 001181 77329 2,250.00 0.00 46 ELECTRICAL -SR. )/23/1997 AP IV# 092397 ARCHITECTURAL SALES ON M 001222 77461 4 0.00 50 ACOUSTICAL TREA )/23/1997 AP IV# 103582 BREDEMUS HARDWARE 001222 77483 177.00 0.00 51 HARDWARE-SR. CE )/2311997 AP IV# 093097 MCGUIRE MECHANICAL SERVI 001222 77578 15 0.00 66 MECHANICAL -SR C V26/1997 AP IV# 091997 TWIN CITY TILE & MARBLE 001222 77656 1 0.00 68 TILE WORK -SR. C Page: 2 r Date: 10/28/97 at 4:21 PM City of Chanhassen General Ledger Detail Report - Single Segment Only From period 01/1997 to 10/1997 For Segment = 4, Segment Value: 601, Segment2 = 4, Segment Value: From 601 to 6C1 Exclude Zero Activity Accounts Ck.# Rec.# Account Number Account Description Batch Other Debit Amount Credit Amount Short Entry Tran Date Src Transaction Description Begin. Balance Net Change Ending Balance Description 4751 - 458 - 000 -601 --------- - - - - -- ------ - - - - -- Account Total: $ 0.00 68 1 230.00 - - -- ---- - - - - --- 0.00 -------------- -- $ 68,230.00 $ 68,230.00 PRG Total: 0.00 75 1 287.59 3.,402.65 $ 71 71,884.94 Grand Totals: $ 0.00 75,287.59 3 ;1 402.65 $ 71,884.94 $ 711384.94 ?a 1 )ate: 10/29/97 Cit of Chanhassen Current Period Active Pa Vendor Number Name ====> CAMICUU CAMPBELL, KNUTSON, SCOTT & FUCHc.-;, P :nv No. Chk Date Check No. T Distribution Ac(.",.ount Pa amount )083197 10/13/97 77496 Re Ck 4300-423-000-000 11296.60 )1311997 04/14/97 74678 Re Ck 4306-101-114-000 5,315.86 -- )1311997 04/14/97 74678 Re Ck 4300-700-702-000 132. )13197 04/14/97 74799 Re Ck 4300-101-114-000 5,315.86-- )13197 04/14/97 74799 Re Ck 4300-700-702-000 132. 001 )13197 04/14/97 74799 Re Ck 4300-101-114-000 - 5,315.86 --- )13197 04/14/97 74799 Re Ck 4300-700-702-000 - .132.00*- )13197 04/14/97 74799 Re Ck 4300-460-000-000 1, 051.5812 )22897 04/24/97 75146 Re Ck 4302-480-000-000 150.00C) )22897 04/24/97 75146 Re Ck 4302-623-000-000 !/2 )22897 04/24/97 75146 Re Ck 4302-656-000-000 74.50X )22897 04/24/97 75146 Re Ck 4302 - 675 -000 -000 30.00-1- )22897 04/24/97 75146 Re Ck 4302- 101 -114 -000 1,010.29 -- )3311997 05/27/97 75491 Re Ck 4302-101-114-000 205.00 ---- )3311997 05/27/97 75491 Re Ck 4302 - 623 -000 -0 987.87 )3311997 05/27/97 75491 Re Ck 4302-675-000-000 28.10+ )33197 04/24/97 75146 Re Ck 4300-423•-000-000 1 075.92 143097 05/27/97 75386 Re Ck 4300-460-000-000 39.005 143097 05/27/97 75386 Re Ck 4300-491-000-000 678.30 15-01-97 06/09/97 75727 Re Ck 4300-460-000-000 444.0013 15-02-97 06/09/97 75727 Re Ck 4300-460-000-000 827.69F-1 15/31/977 07/28/97 76580 Re Ck 4300- 460 -000 -000 625.90�:l 150197 06/09/97 75592 Re Ck 4300-623-000-000 235.58 150197 06/09/97 75592 Re Ck 4300-656--000-000 15. 00 150197 06/09/97 75592 Re Ck 4300-101-114-000 1 150297 06/09/97 75592 Re Ck 4300-101-114-000 8,229.75-° ►50297 06/09/97 75592 Re Ck 4300-494-000-000 30.00 153197 07/28/97 76580 Re Ck 4;301-460-000-000 17.20P ►6/3097 09/08/97 77195 Re Ck 4302-460-000-000 1f274.301:1 ►63097 09/08/97 77195 Re Ck 4301-460-000-000 101.58V ►7311997 09/22/97 77247 Re Ck 4300-423-000-000 192. 173197 09/22/97 77374 Re Ck 4300-460-000-000 2,580.35 i�l ►80897 09/22/97 77374 Re Ck 4302-460-000-000 5.301D ►83197 10/13/97 77496 Re Ck 4302-101-114-000 2,190.26-- 183197 10/13/97 77496 Re Ck 4302-480--000-000 30.000 183197 10/13/97 77496 Re Ck 4302 - 623 - 000 -000 95.00 190397 09/08/97 77051 Re Ck 4300-423-000-000 860.6 .1-30-96 01/13/97 73195 Re Ck 4300-101-131-000 127.50 .1/30/96 01/13/97 73195 Re Ck 4300-101-131-000 72.00 .11296 01/13/97 73311 Re Ck 4300-460-000-000 45 Z-3 .1301996 01/13/97 73195 Re Ck 4300-480-000-000 60.000 .1301996 01/13/97 73195 Re Ck 4300-623--000-000 1 .1301996 01/13/97 73195 Re Ck 4300-101-114-000 4, 18 9. 15--- ,13096 01/13/97 73311 Re Ck 4300-460-000-000 963.65�2 2-31-96 03/10/97 74226 Re Ck 43 -101 -114 -000 996.00°'' 2-31-96 03/10/97 74226 Re Ck 4300-480-000-000 525.000 Page: 2 Date: 10/29/97 City of Chanhassen Current Period Active Payments vendor Number / Name ====> CAMKNU / CAMPBELL, KNUTS 011, SCOTT' & FUCHc-; , P Inv No. Chk Date Check No. Type Distribution Ac.c:ount Payment amount 12-31-96 03/10/97 74226 Re g Ck 4300 - 623 -000 -000 v"' 444.00 12 -31 -96 03/10/97 74226 Reg Ck 4300 - 666 - 000 -000 15.00 12 -31 -96 03/10/97 74226 Reg Ck 4300 -675- 000 -000 645.00 -'" 123196 01/27/97 73341 Reg Ck 4300 -423- 000 -000 576.00 13197 02/24/97 74034 Reg Ck 4300- 423 -000 -000 90.00 22897 04/14/97 74678 Reg Ck 4300 - 423 -000 -000 733.92 3311997 05/27/97 75491 Reg Ck 4302 -101-- 114 -000 7 33197 05/27/97 75548 Reg Ck 4302- 460 - 000 -000 1 5 -31 -97 07/23/97 76410 Reg Ck 4300 - 101 -- 114 --000 7,432.71 -- 5 31/97 07/23/97 76410 Reg Ck 4300 -672•- 000 -000 109.50 5/31/97 07/23/97 76410 Reg Ck 4300 - 480 - 000 -000 105.000 5/31/97 07/23/97 76410 Reg Ck 4300 -623 -000 -000 ,/ 172.83 5/31/97 07/23/97 76410 Reg Ck 4300 -101- 114 -000 1 53197 07/28/97 76580 Reg Ck 4300 - 460- - 000 -000 18.00 6/30/97 09/08/97 77051 Reg Ck 4302 - 101 -114 -000 6 6301997 09/22/97 77247 Reg Ck 4300 -423 -000 -000 126.00 63097 09/08/97 77051 Reg Ck 4300 - 101 - 114 -000 1,489.58-- 63097 09/08/97 77051 Reg Ck 4300 -101 -114 -000 - 1 63097 09/08/97 77051 Reg Ck 4302- 480 -- 000 -000 215.00' 63097 09/08/97 77051 Reg Ck 4302 - 623 - 000 -000 265.00 63097 09/08/97 77051 Reg Ck 4302- 101 -114 -000 1,009.58°-x' 73197 09/22/97 77247 Reg Ck 4300- 101 - 114 -000 4,784.94 80897 09/22'./97 77247 Reg Ck 4302 - 623 -000 -000 / 22.00 80897 09/22/97 77247 Reg Ck 4302- 101 -114 -000 1,102:18'" 83197 10/13/97 77684 Reg Ck 4300 -460 -000 -000 1,503.52 A G311997 10/13/97 77684 Reg Ck 4302 - 460 -000 -000 1,032.90 AUG3197 10/13/97 77496 Reg Ck 4302- 101 -114 -000 4 AUG3197 10/13/97 77496 Reg Ck 4302 -410-- 000 -000 22.00 D311996 03/10/97 74371 Reg Ck 4300- 460- -000 -000 285.00E D311996 03/10/97 74371 Reg Ck 4300 - 491 - 000 -000 -- 27.00 D3196 02/10/97 73883 Reg Ck 4300 -460 -000 -000 244.50 DEC311996 03/10/97. 74226 Reg Ck 4300- 101 - 114 -000 7,215.96 - DEC3196 03/10/97 74371 Reg Ck 4300 -491 -000 -000 ,_,... 42.50 DEC3196 03/10/97 74371 Reg Ck 4300 -460- 000 -000 1 1 030.00 DEC3196 03/10/97 74371 Reg Ck 4300 - 491 - 000 -000 -42.50 DEC3196 03/10/97 74371 Reg Ck 4300 - 460 --000 -000 - 1,030.00 DEC3196 03/10/97 74371 Reg Ck 4300 - 491 - 000 -000 42.50 DEC3196 03/10/97 74371 Reg Ck 4300 - 460 - 000 -000 1 F281997 04/28/97 75136 Reg Ck 4300 -460- 000 -000 796.75 F2897 04/28/97 75136 Reg Ck 4300 -460- 000 -000 147.62 FEB2797 04/ 2 8/9 75136 Reg g Ck 4300- 460 -000 -000 1, 964.55 FEB97 04/24/97 75146 Reg Ck 4300- 101 - 114 -000 5,005.16 FEB97 04/24/97 75146 Reg Ck 4300 - 700- 702 -000 55.OQ' J3197 .04/14/97 74678 Reg Ck 4300- 101 -114 -000 4,896.21--- J3197 04/14/97 74678 Reg Ck 4300 -623- 000 -000 948.50 J3197 04/14/97 74678 Reg Ck 4300 - 675 - 000 -000 10.00. , a g e: 3 ►ate: 10/29/97 Cit of Chanhassen I- Current Period, A ctive Fa ents Vendor Number Name ====> CAMKNU / C AMPBELL, KNUTS011, SCOTT & FUCH.S', P ,nv No. Chk Date Check No. T Distribution Accoount Pa amount AN3197 04/14/97 74799 Re Ck 4300-460-000-000 30.00 7:11 ULY3197 09/22/97 77374 Re Ck 4300-460-000-000 365.30 1�3 13197 05/27/97 75548 Re Ck 4302-460-000-000 214.80 P 1301996 01/13/97 73195 Re Ck 4300-101-114-000 4,540.42 --- 13096 01/13/97 73311 Re Ck 4300-460-000-000 658. 1 � g � WAF, A 6/7 rz d ,2 • l� 4, ee IA 7 � 44 yam ,p !" 4"s ��.�kr�+,,'r�_.e� {�J/��'/N(��••�N -�� it ��lj�'1�r. `/ -70 oe-- -17V 7 Nt v11- I '' �� r �— 7 T _ Tt:E 10.41 FAX . - - - t� FAX 61� .. 45 55 tCAMPBELL �j t�t1 LIV ,NT BILLING SUM'N4ARY REPORT CRAN ]E'D ' llin �a • 629.0 ccO Matt Genera Total Amount Hours $ 679.80 4.55 Feet �x�enses - $ 574.00 $ 16.6 629, 007 3(j Z Chaaas Bo wl $ 2,983.80 22.00 $2,952W .00 $135.44 629,012 4�0 *7-- q bee � s $ 60.00 440 60-00 0-00 629 .01 ^ 43ol� 1 Tires Plus Groupe 255 0.00 0.0 S 0. 62 14 x}30 �. prop erty ��rd � p 226. 2.40 330-00 �4...� CITY OF CHANHASSEN B lllina 594-0 �. ,tte� • Medical Arts Total Hours $ 7 , 081.63 61•�� Fees BNPM Fees .�-- ' 6 a $1,6? 1. ��4 . X96 �3Q - � f l- Gar Kirt Real � �s��.t e 'transaction ? ,5a0.63 1 � . 6� $ 1,90 -7 . 50 56554 )age: 1 )ate: 10/29/97 City of Chanhassen Current Period Active Payments Vendor Number / Name =- _ _ > KENNGR / KENNEDY & GR-WEN .nv No. Chk Date Check No. Type Distribution Ac:r_ount Payment amount 120697 02/24/97 74137 Reg Ck 4300 - 460 - 000 -000 935.02 � 120697 02/24/97 74137 Reg Ck 4300 - 491 - 000 -000 1,405.44 140897 04/28/97 75139 Reg Ck 4300 - 460 - 000 -000 1,456.16+ 40897 04/28/97 75139 Reg Ck 4300 - 491 - 000 -000 1,228.80- 150997 05/27/97 75478 Reg Ck 4300- 491 - 000 -000 1,194.25- 150997 05/27/97 75478 Reg Ck 4300 - 460 - 000 -000 493 .18 161197 06/23/97 75869 Reg Ck 4300 - 492 - 000 -000 438.45 -1- �61197 06/23/97 75869 Reg Ck 4300 - 490 - 000 -000 " 17/08/97 07/28/97 76476 Reg Ck 4300 - 494 - 000 -000 297.36o 1 70897 07/28/97 76476 Reg Ck 4300 - 490 - 000 -000 30.00 70897 07/28/97 76476 Reg Ck 4300 - 495 -000 -000 346.60n 91297 10/13/97 77689 Reg Ck 4300 - 491 -000 -000 337.68- 91297 10/1/97 77689 Reg Ck 4300- 460 - 000 -000 627.07 L-" 2059E 01/13/97 73312 Reg Ck 4300 - 460 - 000 -000 473.07✓ 2596 01/13/97 73235 Reg Ck 4300 - 492 - 000 -000 229.45+ 3453 01/21/97 73569 Reg Ck 4300 - 460 -000 -000 57.50 ✓ 3454 01/27/97 73550 Reg Ck 4300 - 492 - 000 -000 24.981 3594 01/21/97 73569 Reg Ck 4300 - 460 - 000 -000 448.50 3595 01/21/97 73569 Reg Ck 4300 - 491 - 000 -000 65.60 — 3596 01/21/97 73569 Reg Ck 4300 - 491 -000 -000 57.50° 3597 01/21/97 73569 Reg Ck 4300- 491 - 000 -000 86.25- 3710 03/2/97 74593 Reg Ck 4300 - 460 -00.0 -000 60.00"' 4529 03/24/97 74517 Reg Ck 4300 - 460 - 000 -000 46.08,x° 4670 03/24/97 74593 Reg Ck 4300 - 460 - 000 -000 60.00' 4671 03/2/97 74517 Reg Ck 4300 - 491 - 000 -000 513.55- 4672 03/24/97 74593 Reg Ck 4300- 491 - 000 -000 330.00- 4673 03/2/97 74593 Reg Ck 4300 - 491 - 000 -000 331.47- 4674 03/24/97 74517 Reg Ck 4300 - 494 - 000 -000 1,648.00° 4675 03/24/97 74593 Reg Ck 4300 - 460 - 000 -000 564.00" 5155 04/28/97 75139 Reg Ck 4300 - 460 - 000 -000 1 84.0 0Y" 6029 06/23/97 75986 Reg Ck 4300- 460 - 000 -000 3 6031 06/23/97 75869 Reg Ck 4300 - 492 - 000 -000 438.45- 6214 06/23/97 75986 Reg Ck 4300 - 491 -000 -000 348.45- 6215 06/23/97 75986 Reg Ck 4300 - 491 - 000 -000 474.85-- 6215 06/23/97 75986 Reg Ck 4300 - 491 - 000 -000 474.85- 6215 06/23/97 75986 Reg Ck 4300 - 491 -000 -000 - 474.85! 6216 06/23/97 75986 Reg Ck 4300 - 491 - 000 -000 325.05 -- 6217 06/23/97 75869 Reg Ck 4300 - 494 -000 -000 2 6220 06/23/97 75869 Reg Ck 4300 - 495 - 000 -000 809.21 1:� 6947 08/25/97 76993 Reg Ck 4300 - 491 - 000 -000 236.80-- 6947 08/25/97 76993 Reg Ck 4300 - 491 - 000 -000 236.80 -- 6947 08/25/97 76993 Reg Ck 4300 - 491 - 000 -000 - 236.80 -- 6948 08/25/97 76992 Reg Ck 4300 -491- 000 -000 302.00 -- 6949 08/25/97 76903 Reg Ck 4300 - 494 - 000 -000 567.760 6950 08/25/97 76992 Reg Ck 4300 - 460 - 000 -000 420.0 0 sP' 5951 08/25%97 76903 Reg Ck 4300 - 495 -000 -000 60.00 0 Page: 2 Date: 10/29/97 City of Chanhassen Current Period Active Payments Vendor Number / Name ====> KENNGR./ KENNED)' & GRAVEN Inv No. Chk Date Check No Type Distribution Ac:c.ount Payment amount 17108 08/25/97 76992 Reg Ck 4300- 460- 000 -000 1 L , 494.06 '' 17109 08/25/97 76992 Reg Ck 4300 - 460 - 000 -000 442.95 17111 08/25/97 76903 Reg Ck 4300- 495 -000 -000 516.00 0 18190 10/27/97 77863 Re g Ck 4300- 460 - 000 -000 159.68 ' 18191 10/27/97 77793 Reg Ck 4300- 490 - 000 -000 180.00 1 18192 10/27/97 77793 Reg Ck 4300- 495- - 000 -000 180.00 t 18380 10/27/97 77863 Reg Ck 4300 -491 -- 000 -000 532.44 18381 10/27/97 77793 Reg Ck 4300 - 494 - 000 -000 448.280 2697 02/24/97 74076 Reg Ck 4300 - 494- 000 -000 2,772.000 40897 04/28/97 75032 Reg Ck 4300- 494- 000 -000 2 50997 05/27/97 75513 Reg Ck 4300 - 494 -000 -000 2 50997 05/27/97 75513 Reg Ck 4302 -495- 000 -000 1 70897 07/28/97 76582 Reg Ck 4300- 460 -000 -000 1 855.44'" 70897 07/28/97 76582 Reg Ck 4300- 491 - 000 -000 403.51° 91297 10/13/97 77566 Reg Ck 4300- 494- 000 -000 48.000 D51996 01/13/97 73235 Reg Ck 4300 -490- 000 -000 86.25 DEC51996 01/13/97 73312 Reg Ck 4300- 460- 000 -000 34.50 DEC51996 01/13/97 73312 Reg Ck 4300- 491 -- 000 -000 1, 368.19 DEC596 01/13/97 73235 Reg Ck 4300- 494 - 000 -000 575.000' S1297 10/13/97 77566 Reg Ck 4300 -495- 000 -000 974.96 S1297 10/13/97 77566 Reg Ck 4300- 490- 000 -000 19.52 51297 10/13/97 77566 Reg Ck 4300 -495 -000 -000 934.48 T S1297 10/13/97 77566 Reg Ck 4300 -490 --000 -000 60.00 - S1297 10/13/97 77566 Reg Ck 4300 - 495 - 000 -000 - -974.961 S1297 10/13/97 77566 Reg Ck 4300 -490- 000 -000 -19.52 0 76 quo. Ll 3ai Nall- I r,�: t y :? r ' 4 l ' 470 Pillsbury Center e 200 South Sixth Street Minneapolis MN 55402 • (612) 337 -9300 telephone ' (612) 337 -9310 fax e -mail: at s@kenned - m tY raven.co Y g CHARTERED _� ".. �,.._ •° i f CH 130 -1 General 4 $60.00 CH130 -17 Economic Development TIF District tf o8 J-f 3 o Z - 060 $32.50 CH130 -27 Oak Ponds Housing roject ! } -� _ - g J � $1,376.22 CH 130 -43 � --- - ._ .. Movie Theater Project $3,438.05 CH 130-44 Bowling Center Project $2,599.11 CH 130-45 , Frontier Center Project $1 CH 130-48 North Bay TIF -j $13 CH 130-51 Chanhassen PRN Tax Appeal q 2, f, J - $8 CH 130-52 0 PR (-,ontract Litioati0n 73 CH 130 -61 Contract for Private Redevelopment L4 r fl $24.98 CH 130 -63 Lotus Housing Project Q ' 3 01 $1 CH130 -64 TIF District No. 6 -1 COD $21473.09 Page: 1 Date: 10/29/97 City of Chanhassen Current Period Active Payments Vendor Number / Name =___> MOSBAR / MOSS BARNETT' Inv No. Chk Date Check No. , Type Distribution Ac count Payment amount 256189 02/10/97 73765 Reg Ck 4300- 210 -000 -000 33.38 257605 03/24/97 74536 Reg Ck 4300- 210 - 000 -000 1 259327 04/14/97 74747 Reg Ck 4300 - 210 - 000 -000 963.45 261097 05/27/97 75432 Reg Ck 4300- 210 - 000 -000 1 262413 05/27/97 75432 Reg Ck 4300 - 210 -000 -000 2 264215 07/28/97 76499 Reg Ck 4300 - 210- 000 -000 169.47 265495 08/11/97 76730 Reg Ck 4300- 210 - 000 -000 557.37 266547 08/25/97 76926 Reg Ck 4300 - 210 - 000 -000 747.64 268643 10/13/97 77598 Reg Ck 4300- 210 - 000 -000 618.89 269831 10/27/97 77810 Reg Ck 4300 -210 --000 -000 2 �� - 2-JO W �� 7 43 , 2 1998 BUDGET ALL FUNDS ACCOUNT DESCRIPTION GENERAL FUND INTERNAL SERVICE FUND SPECIAL REVENUE FUNDS CAPITAL PROJECTS FUNDS ENTRPRS FUNDS HIST PRES T °UST FUND TAX INCR DISTRICT FUNDS G.O. DEBT SERVICE FUNDS 1998 TOTAL FUNDS GENERAL PROPERTY TAX 3001 Property Tax (Cert) 3,200,796 460,000 120,000 - - - - 367,566 4,148,362 3002 Allowance for Delinquents (96,024) - - - - - - - (96,024) 3011 Delinquent Property Tax 112,028 - - - - - - - 112,028 3012 Tax Increment Receipts - - - - - - 6,780,000 - 6,780,000 3041 Homestead Credit 841,286 - - - - - - - 841,286 3080 Franchise Fees - - 70,000 - - - - - 70,000 3090 Other Property Taxes 2,000 - - - - - - - 2,000 GENERAL PROPERTY TAX 4,060,086 460,000 190,000 - - - 6,780,000 367,566 11,857,652 LICENSES 54,300 - - - - - - - 54,300 PERMITS 524,800 - - - 7,000 - - - 531,800 FINES & PENALTIES 31,500 - - - - - - - 31,500 INTERGOVERNMENTAL REVENUE 41,800 - 77,000 - - - - - 118,800 CHARGES FOR CURRENT SERVICES 480,300 - 2,000 380,000 2,603,500 100 - - 3,465,900 OTHER REVENUE 117,800 23,000 34,000 6,500 440,500 244,000 110,000 19,022 994,822 ** TOTAL REVENUE 5,310,586 483,000 303,000 386,500 3,051,000 244,100 6,890,000 386,588 17,054,774 PERSONAL SERVICES 3,403,273 - 82,500 137,000 634,100 201,000 205,400 - 4,663,273 MATERIALS & SUPPLIES 558,451 - 16,100 - 123,800 18,500 1,600 - 718,451 CONTRACTUAL SERVICES 2,401,321 - 149,130 30,000 2,104,900 56,800 166,010 - 4,908,161 CAPITAL OUTLAY 328,890 459,000 10,000 - 180,000 6,000 28,630 - 1,012,520 MISCELLANEOUS (405,911) - - - - - 155,995 - - (249,916) DEBT SERVICE - - - - 300,723 - 1,661,300 ^.2?,g80 2,390,003 ** TOTAL EXPENDITURES 6,286,024 459,000 257,730 167,000 3,343,523 438,295 2,062,940 427,980 13,442,492 REVENUE OVER /(UNDER) EXPENSE (975,438) 24,000 45,270 219,500 (292,523) (194,195) 4,827,060 (41,392) 3,612,282 FUND BALANCE FORWARD 1,840,764 472,510 884,792 261,573 3,575,833 2,054 112,953 431,269 9,634,629 BOND PROCEEDS - - - - - - TRANSFER IN /(OUT) - 65,000 - - (100,000) - (4,909,597) - (4,944,597) LESS REQUIRED RESERVE 865,326 561,510 930,062 481,073 3,183,310 1,860,740 30,416 389,877 8 TOTAL RESOURCES OVER /(UNDER) LIAB CITY OF SSE 690 COULTER DRIVE • P.O. BOX 147 • CHANHASSEN, MINNESOTA 55317 (612) 937 -1900 0 FAX (612) 937 -5739 Date: 10/08/97 Note: The question of To: Don Ashworth, City Manager :reserves &their purpose 203 was discussed at Monday From: Pam Snell, Finance Director night's work session. RE: Description of Reserve Accounts and Individual Funds ... .. }i.�.. :.:::::Yi. R......n.: ....:n.. .nn .F R• ..v.. .4.: .. ..:. .4. .:. ..h Fund Accounting A fund is a fiscal and accounting entity with a self- balancing set of accounts in which cash and other financial resources, all related liabilities and residual equities, o!, balances, and changes therein, are recorded and segregated to carry on specific activities or attain certain objectives in accordance with special regulations, restrictions or limitations. Internal Service Funds are used to account for the financing of goods or services prov;ded by one Hannrtmant to nthar risznartmontc Fund # Fund Name 1997 Description 203 Firefighters' Relief Estimated Revenues that are received from the State of Minnesota Reserve (which is a reimbursement of a special tax placed on fire Fund # Fund Name Amount Descrip 950 Vehicle /Equipment 472,510 This fund was established to provide: (1) a means by Maintenance w hich long range motor vehicle purchases could be monitored and planned, (2) a control center for the 210 CATV 138 purchase, maintenance ant usage of vehicles and equipment; and (3) a means to separate from the operating costs the peaks and valleys 0, C, d by major p urchases occurring or not occurring in sr one year. Fund # Fund Name 1997 Esti m ated Reserve Amount Description 203 Firefighters' Relief 165,293:: Revenues that are received from the State of Minnesota (which is a reimbursement of a special tax placed on fire insurance policies written within individual cities) and a special City levy dedicated for firefighter relief both represent dedicated monies to be used only for fire - relief 'u oses. 210 CATV 138 Under the terms of the franchise agreement with Tri Cablevision, the City is to receive 5% of the revenues derived from cable television sales within the City. These monies are dedicated solely to i �nproving public broadcasting capabilities, studio improvements, and other capital expenditures imp rovinq the overa] system. Special Revenue Funds are established to account for taxes and other revenues set aside for a articular purp ose. ::,... 211 Environmental 580,972 Revenues received from a special city levy are dedicated 400 Protection 261 to provide funding for projects and activities that have a Administration Reserve significant impact on our environment (i.e. recycling, lake Fund # Fund N ame Amount management, and reforestation Capital Project Funds are used to account for the construction and financing of large projects. Most capital projects are singular in purpose and their revenue /expenditure cannot be used for subsidizing any other operating fund. In each of these cases, bonds or other revenues rE .1ceived cc-in only be used for these specific activities. Fund # Fund Name 1997 Estimated Reserve Amount Desc ription 400 Capital Project 261 This reserve represents monies collected from developers Administration Reserve for administrative services on projects which include Fund # Fund N ame Amount administration of special assessment rolls and debt 700 Sewer & Water Utility 2 service accounts during the period of special assessments. 410 Park Acquisition and 412,000 Cities may require the dedica of land associated with Development all new developments within the community or, in lieu of land, the City may establish a permit charge equivalent to the value of the land. The City has set a consistent permit 710 Sewer & Water 1 fee to be charged against all new developments, except if Expansion partial land credits are /were given. All monies received through this permit process are recorded here and are dedicated for park purposes. Enterprise Funds are established to account for operations financed and operated in a manner similar to private business enterprises. The governing body intends that these costs of providing goods and services to the general public on a continuing basis be financed or recoverE , .d prim2.rily through user charaes. 1997 Estimated Reserve Fund # Fund N ame Amount Description 700 Sewer & Water Utility 2 This fund accounts for the operation cf the City -owned sewer and water system. Funds are generated solely from user fees collected from customer;► of the municipal utility system. The City cannot operate Ca public utility at a deficit, nor may a City subsidize other general operating expenses via sewer and water revenues. 710 Sewer & Water 1 This fund accounts for additions to the sewer and water Expansion system. Funding is derived from sanitary sewertwater hook -up charges and are dedicated to paying the oversizing and other general benefit casts of the sewer and water utility system. Revenues in this fund fluctuate greatly in that collections are based on development in areas where trunk costs were not assessed and used to finance cons ;ruction projects. 720 Surface Water 174 This fund accounts for operations within the City's surface Management water management district bcased on Minnesota Chapter 509 legislation for local governments to provide a financing mechanism to build and maintain storm sewers and drainage ponds and generally control the surface water drainage from storms, spring thaw, etc. Property owners are billed on a quarterly basis in conjunction with the utility billing. Properties are iden and charged according to the rate schedule adopted by the City Council. C I T Y OF SSE 690 COULTER DRIVE • P.O. BOX 147 • CHANHASSEN, MINNESOTA 55317 �f (612) 937 -1900 FAX (612) 937 -5739 MEMORANDUM Finance Director TO: Pam Snell, FROM: Todd Hoffman, Park and Recreation Director DATE: October 14, 1997 SUBJ. • q 1998 Park and Trail Acquisition and Development Capital Improvement Program Request. , City Council October 20t bud get meeting, please find attached the In preparation for the C y g 1998 Park and Trail Acquisition and Development Capital Improvement Project. The Park and Recreation Commission established this program at their September 23, 1997 meeting. At the conclusion of their discussion that evening, the following motion was b made. " Following a win lengthy discussion regarding the proposed 1.998 Park g y re g Acquisition & Development CIP, the commission recommended the following expenditures: re Community y Park $100,000 Chanhassen Estates Park Parking Improvements 12,000 Kerber Pond Park Si na e 2,000 g g Chanhassen Recreation Center Irrigation 80 100000 City Center Park , Lake Ann Park g Contin ency 5,000 Lake Ann Park Concession/Restroom Building 75,0 Meadow Green Park East Trail Connector 30,000 Picnic Tables/Benches 3,000 30,000 Miscellaneous Signage 2,000 Scout Projects 11000 Contingency 105000 g Y Recycling Containers 55000 � g Trails, Asphalt 15,000 Furthermore it was recommended that the following reserves be established: V Pam Snell October 14, 1997 Page 2 Lake Ann Park Expansion (per year) 50 Arts /Theater (per year) 50 These are in addition to the reserves already in place. In addition, it was recommended that the general reserve be raised from $300,000 to $400,000. Upon concluding their discussion, Commissioner Meger moved, Commissioner Berg seconded to recommend that the city council approve the 1998 Park & Trail Acquisition and Development CIP as presented. All voted in favor and the motion carried." The proposed expenditures are more aggressive than the commission_ typically p ro recommends. They will be reviewing the ram at their October 28 g 8th meeting. An g updated proposal will be forwarded to you on October 29 g: \park \th \98 Park- TrailAcquistion Chanhassen Park and Recreation Commission 1998 Park &Trail Acquisition and Development Park Name Bandimere Community Park Bandimere Heights Park Bluff Creek Park Carver Beach Park Carver Beach Park Carver Beach Park Carver Beach Playground Chanhassen Estates Park Chanhassen Hills Park Kerber Pond Park Kerber Pond Park Chanhassen Recreation Center Chanhassen Recreation Center Chanhassen Recreation Center City Center Park Cunt' Farms Park Galpin Boulevard Parkland Greenwood Shore Park Herman Field Park Herman Field Park Lake Ann Park Lake Ann Park Lake Susan Park Meadow Green Park Minnewashta Heights Park North Lotus Lake Park Pheasant Hill Park Power Hill Park Prairie Knoll Park Rice Marsh Lake Park Round House Park Round House Park South Lotus Lake Park Sunset Ridge Park Stone Creek Parkland Other Improvements City Center Park 12,000 Miscellaneous 30 Lake Ann Park Expansion 5.0,000 Arts /Theater 50,000 Picnic Tables, Benches 3 F Total Reserve Signage 2 Scout Projects 1 Contingency 10 Recycling Containers 5,000 Trails /Asphalt 15 Totals $470 Reserves City Center Park 12,000 Bluff Creek Watershed 10000 Lake Ann Park Expansion 5.0,000 Arts /Theater 50,000 General Reserve 400,000 F Total Reserve $612,000 g. \park \th \98cip.doc 1998 PROPOSED PUBLIC WORKS CIP PROTECT: WATER SUPPLY WELL NO. S Justification-/P=ose To maintain adequate, potable water supply and fire flow protection PP Y p as the City continues to add 300 to 400 new single - family homes annually along with anticipated significant growth and office /industrial development over the next few years. Estimated Project Cost $800,000 which includes land acquisition, drilling, wellhouse construction, and on -site emergency power generation. Land Acquisition A suitable site has been located within the newly constructed Highover subdivision located south of Lake Lucy Road and east of Trunk Highway 41. The actual land acquisition still needs to take place. Funding Source Fund 710 - Utility Enterprise. PROTECT: 2.0 MG WATER STORAGE TANK Project Justification/Purpose To maintain adequate water storage and fire flow protection as well as assisting in overall stabilization of the water system. Estimated Project Cost $2.8 Million which includes land acquisition. Land Acquisition The proper land has recently been acquired adjacent to Trunk Highway 41 south of Trunk Highway 5 within to the Arboretum Business Park (Wrase property). 1 Potential Funding Sources Tax increment financing and Fund 710 - Utility Enterprise. PROTECT: COULTER BOULEVARD, PHASE III (ARBORETUM BUSINESS PARK) Project Justification/Purpose To construct this Municipal State -Aid road segment from its current terminus at the west end of the Autumn Ridge development to the proposed Century Boulevard and ultimately south to 82nd. Street in the Arboretum Business Park and complete an east/west local collector route south of Trunk Highway 5 between Trunk Highway 101 and Trunk Highway 41. Estimated Project Cost $900,000. Land Acquisition Requirements All the necessary right -of -way has been dedicated with the Arboretum Business Park development. Potential Funding Sources: Tax increment funding and Municipal State -Aid Street Fund. 1998 Surface Water Projects 1998 Projects Lake Ann Park Treatment Ponds Estimated Cost � • 1 111 Funding Surface Water Utility Fund Kerber Pond Park Fix Erosive Storm Channel Minnewashta Heights Repair Outlet into Lake Construct Grit Chambers Lake Susan Restoration Lake -wide Alum Treatment BWSR wetland Restoration Bluff Creek Projects $ 1 5,000 $ 95,000 $ 60,000 $200,000 Surface Water Utility Fund S WMP SWMP B W S R Grant Watershed District All projects funded through Storm Water Utility fund unless special grant or funding is noted. g: \eng \Phillip \98SurtWaterMgtProjects PROJECT: LAKE LUCY ROAD (between the Brenden Pond development and the Woodridge Heights development) Project Justification/Purpose To complete the final segment of this overall Municipal State -Aid east/west collector route in northern Chanhassen which extends from Trunk Highway 41 to Nez g Y Perce Drive. Estimated Proiect Cost $100,000 consisting of street construction and storm sewer. Land Acquisition Requirements The right -of -way is required to be dedicated by the developer of the Brenden Pond subdivision. Potential Funding Sources Assessments and General Fund. PRO JECT: PUBLIC WORKS FACILITY EXPANSION (space needs & Dre- design Project Justification/Purpose To provide for near -term and long -term facility needs with regards to storage, operation, and maintenance of the Public Works vehicles, equipment, and material supply, as well as administrative space. Estimated Project Cost $45,000 to conduct the needs analysis and pre - design. Land Acquisition Requirements Speeds needs analysis will determine options as to whether or not the existing site is capable of meeting the long -term needs or whether or not another site (existing building or vacant land) needs to be acquired. Potential Funding Sources General Fund and remotely, a referendum. \\cfsl \vol2\engNcharles\98 proposed public works cip.doc