The URL can be used to link to this page

Committee of the Whole Packet 2003 09-16-03 k �u 0 United City of Yorkville • EST. County Seat of Kendall County 1Qi ��— 1836 800 Game Farm Road ��-- U) Yorkville, o '1 L� O Phone:630-553-4350Illinois60560 "A ww.c, ��2 Fax:630-553-7575 `4LE \v AGENDA COMMITTEE OF THE WHOLE Tuesday, September 16, 2003 7:00 PM City Conference Room REVISED: 9/12/03 Public Hearing: None Presentations: 1. John Watson - Draft Pollution Ordinance 2. John Weber of PTW Accounting & Management - Draft 2002- 2003 Audit Note: "CA" denotes a recommendation by the respective Committee for that item to go on the Consent Agenda of the City Council Agenda. • Mayor: 1. Prairie Parkway TAG Update 2. IMLRMA Revised Intergovernmental Contract and By-Laws Public Works Committee: 1. Human Resource Committee - List of Street Name Nominees *PW 8/25/03 2. Water Conservation Ordinance with Sod Permit Application *PW 6/23/03 & COW 7/15/03 1 3. Certificate of Occupancy - Site Inspection Form Economic Development Committee: 1. PC 2002-06 Menard's Residential Preliminary Plan *EDC 9/15/03 Page 2 • Committee of the Whole September 16, 2003 Public Safety Committee: 1. New Sergeant's Position Request *PS 8/28/03 Administration Committee: 1. An Ordinance Amending City Code to Allow Telephone Conference Voting by Alderman *Admin 9/11/03 Park Board: 1. No Report. Additional Business: • c • UNITED CITY OF YORKVILLE AGENDA COMMITTEE OF THE WHOLE Tuesday, September 16, 2003 7:00 PM CITY CONFERENCE ROOM STATUS: PRESENTATIONS: c/ 1. John Watson -Draft Pollution Ordinance � (7c.) ,;.? "' ) -'3 2. John Weber of PTW Account &Management -Draft 2002 - 2003 Audit MAYOR: ID r 1//// : 1. Prairie Parkway TAG Update __ ,' L, 2. IMLRMA Revised Intergovernmental Contract and By-Laws rf) (C_ 1 `-.. <- 13 `.,L l V. l._. k-*i PUBLIC WORKS COMMITTEE: ir-\--2--.1- /--f'-'( } -727)il-P.....-..L- 71-2.9- .!-IL-Nr- 1 - .'...//L't ,,(..r / .., / d'‘I.W.Alf t ;. C.J/ E,i.,-01i e41. Human Resource Committee -List of Street Name Nominees f • . -. 1 v , ,(:) .._, - - %) • (Iit' ',, 2. Water Conservation Ordinance with Sod Permit Application , -ii /-,A- L 3. Certificate of Occupancy- Site Inspection Form / ECONOMIC DEVELOPMENT COMMITTEE: - 1 U4-21- - ,1 (.._.° t-i--$ r "t-"- 1.0 v'. I (' .-- 1. PC 2002-06 Menard's Residential Preliminary Plan.) , - z /I/ -2_et:(_-_,t...i.---_ i i ,, ,I.kt,.r. 4- ,,,i, ,i-m, .4 74dik-- '4 -C.' 0 Axt-' .I-' ' r.,„ir_yri i 2, ,9171c,e,- •(/7 1,1 PUBLIC SAFETY COMMITTEE: ( 7i(1,2 ___ , -„ .d I.:-•-.----- - . -/ ii-,..:•,-t-r-ty "-:, •-•-_11/ct ---) . / -- C,. I -, , c-1,,,•. - jA - ( , L-' --"--=3 1- - I 1. New Sergeant's Position Request L i ADMINISTRATION COMMITTEE: f J - / • L1a)/ ‘/,,. cfi1. An Ordinance Amending City Code to Allow Telephone Conference Voting .4,- / by Alderman . 1 1 1 . 1 , • PARK BOARD: Ai ).1—_ --' - 1. No Report. Additional Business4E4— ! vb. 1 t:JY4.-41' sk L°'‘' if-t217-• i....4.4._.e.,,(//12.4- •G <-_, • V 71• /L; .1_,e't Z"(4./v '''' ....j -----7 7 / .:0-'• ) c ' — --- 1,79$ 1 i tl • 1 I c\ °kp 0- A ti3 UNITED CITY OF YORKVILLE, ILLINOIS MANAGEMENT LETTER FOR THE YEAR ENDED APRIL 30, 2003 UNITED CITY OF YORKVILLE,ILLINOIS MANAGEMENT LETTER APRIL 30,2003 TABLE OF CONTENTS PAGE Management Letter Introduction 1 PART A. Prior Points Implemented 2 PART B. Prior Points Not Repeated 2 PART C. Recommendations for Improvement 4 PART D. New Pronouncements 7 PART E. Other Matters 8 INTRODUCTION To the Honorable Mayor and Members of the City Council United City of Yorkville, Illinois In planning and performing our audit of the financial statements of the United City of Yorkville for the year ended April 30, 2003, we considered the City's internal control structure to determine our auditing procedures for the purpose of expressing an opinion on the financial statements and not to provide assurance on the internal control structure. However, during our audit we became aware of several matters that are opportunities for strengthening internal controls and operating efficiency. The memorandum that accompanies this letter summarizes our comments and suggestions regarding those matters. This letter does not affect our report dated July 18, 2003, on the financial statements of the United City of Yorkville. This report is intended solely for the information and use of the City's Council and management and is not intended to be and should not be used by anyone other than those specified parties. We will review the status of these comments during our next audit engagement. We have already discussed many of these comments and suggestions with various City personnel, and we will be pleased to discuss them in further detail at your convenience, to perfoicil any additional study of these matters, or to assist you in implementing the recommendations. Sincerely, PTW& Co. Oak Brook, Illinois July 18, 2003 1 UNITED CITY OF YORKVILLE, ILLINOIS MANAGEMENT LETTER APRIL 30, 2003 PART A. PRIOR POINTS IMPLEMENTED 1. FIXED ASSETS CAPITALIZATION POLICY It was noted in prior years that the City did not have a formal Board policy for capitalizing fixed assets. The City has implemented our recommendation and has adopted a dollar limit for capital expenditures. 2. FIXED ASSETS INVENTORY In prior years it was noted that since the appraisal of the City's fixed assets was performed, the City has not updated the inventory by recording subsequent fixed asset additions and deletions. It was also noted that land and infrastructure records were not maintained by the City. The City is currently in the process of updating its fixed asset records including values for land and infrastructure fixed assets. The City has purchased a new accounting system and is working towards maintaining a full fixed asset inventory for GASB implementation. PART B. PRIOR POINTS NOT REPEATED 1. ACCOUNTING MANUAL In prior years it was noted that the City does not have an accounting procedures manual. A well-devised accounting manual can help to ensure that accounting principles used are proper and that records are produced in the form desired by management. It was further noted that the City is relying heavily on one individual to process the general ledger activity. Management has determined that the user manuals supplied by the City's new accounting software vendor, MSI will be sufficient to meet the needs of the City's Finance/Accounting Department until more formal procedures can be implemented during fiscal year 2004. Management also feels that having the Finance Director available for back-up coverage in the Finance/Accounting Department is sufficient to meet the needs of the Department. 2 UNITED CITY OF YORKVILLE, ILLINOIS MANAGEMENT LETTER APRIL 30, 2003 PART B. PRIOR POINTS NOT REPEATED (Continued) 2. CASH FLOW PROJECTIONS We recommended in prior years that the City perform monthly cash flow forecasting that extends no less than one year to a maximum of five years. These cash flow forecasts should be reviewed on a regular basis and revised as needed. The cash flows will help the City with long term capital planning and debt management. Management currently projects revenues one year in advance and reviews cash flows monthly, with revisions at the six month mark if necessary. City staff has also prepared five year capital asset schedules as a future planning tool. As the City grows, staff has recognized that revenue projections beyond 1 year are necessary for proper fiscal & budgetary planning, and has taken steps towards longer term forecasting. 3. WORKING CASH FUND In prior years it was noted that the City should consider eliminating the Working Cash Fund in the future and moving the remaining cash to either the General or Water Fund. The City has consulted with its legal counsel the Working Cash Fund should be closed by October 2003. 4. FUND CONSOLIDATION/ELIMINATION In prior years it was recommended that the City should consider combining funds with similar purposes and using separate departments within each fund to account for the different types of related activities. With the implementation of GASB Statement No. 34, the City has consolidated some funds for ease of reporting. With respect to the four equipment capital funds, they are maintained separately for internal tracking purposes. Management believes the current fund structure is sufficient for the needs of the City. 3 • UNITED CITY OF YORKVILLE, ILLINOIS MANAGEMENT LETTER APRIL 30, 2003 PART C. RECOMMENDATIONS FOR IMPROVEMENT 1. FUND EQUITY (REPEAT) The City has not adopted a fund balance policy. RECOMMENDATION: As the City continues to grow in the upcoming years, the City Council should consider creating a policy that would establish guidelines to follow in order to establish sufficient fund balance amounts. As a general rule, the City should attempt to maintain General Fund Balance between a minimum of four months (33.3%) to eight months (66.7%) of expenditures. In addition, spending down of accumulated fund balance should be a strategic decision also addressed in this policy. MANAGEMENT RESPONSE: Fortunately, the City has not recently had insufficient fund balances. Because of this, the City has not acted quickly on an official fund balance policy. The Finance Director and the City Treasurer are working to establish a policy in order to maintain appropriate fund balances for the City's future. 2. INTERFUND RECEIVABLES/PAYABLES (REPEAT) The City processes payroll checks for the Parks, Recreation, and Library funds through its General Fund payroll account. When the payroll checks are issued, the City records interfund receivables from these respective funds in the General fund to represent the amount owed from these funds to the General fund. The City does not, however, record reciprocal interfund payables in the Parks, Recreation, and Library funds. This causes the City's total interfund receivables/payables to be out of balance and therefore misstated. RECOMMENDATION: When processing payroll checks for the Parks, Recreation, and Library funds through the General Fund payroll account, the City should continue recording interfund receivables in the General fund, and, in addition, they should record corresponding interfund payables in the Parks, Recreation, and Library funds. When the Parks, Recreation, and Library funds issue checks to the General fund as repayment, the city should remove the applicable interfund receivables in the General Fund and interfund payables in the Parks, Recreation, and Library funds. 4 UNITED CITY OF YORKVILLE, ILLINOIS MANAGEMENT LETTER APRIL 30, 2003 PART C. RECOMMENDATIONS FOR IMPROVEMENT (Continued) 2. INTERFUND RECEIVABLES/PAYABLES (REPEAT) (Continued) MANAGEMENT RESPONSE: With the implementation of our new accounting software, there is no need for inter- fund receivables and payables. The system creates the appropriate offsetting entry while payroll is processed. 3. COLLECTION FUND (REPEAT) The City uses the Collection Fund, and agency fund, to account for fees that are billed and/or collected on behalf of other entities. Over time, the fund has accumulated significant receivable/payable balances. While these balances do offset each other with no net impact on the City's overall financial position, the amounts are individually larger than would be expected based on average monthly amounts. RECOMMENDATION: The City should review the activity and balances in its Collection Fund for reasonableness during fiscal year 2004. Amounts collected on behalf of other agencies should be compared to the amounts paid to the entities to determine if the receivable/payable balances are properly stated. This review should be conducted as soon as possible in fiscal year 2004 so that proper beginning balances can be loaded on the City's new financial accounting software. Also, while conducting the review, the City may identify changes to the chart of accounts for this fund that it wishes to make to simplify the recording of the activity in the fund. MANAGEMENT RESPONSE: The City is in the process of reviewing this, and this fund will be adjusted based on this review and the 2002/2003 audit. The process should be completed by October 2003. 4. COMPENSATED ABSENCES The City's Employee Manual states that "Provided the employee has made a reasonable effort to take vacation time, but such time was denied due to scheduling problems, one week (40 hours) of unused vacation time may be carried over into the next year, or the employee shall receive pay for the unused vacation. The decision shall be made by the department head." However, per review of the vacation time log, it was determined that 3 employees had in excess of 200 hours of vacation time accrued at April 30, 2003. 200 hours would be the maximum number of vacation time accrued for any employee at the City at one time. (160 hours earned within one year plus the 40 hours allowed to be carried over from the prior year.) 5 UNITED CITY OF YORKVILLE, ILLINOIS MANAGEMENT LETTER APRIL 30, 2003 PART C. RECOMMENDATIONS FOR IMPROVEMENT (Continued) 4. COMPENSATED ABSENCES (Continued) RECOMMENDATION: The City should ensure that the Employee Manual policy is followed for all employees at the City regarding the accrual of vacation time. Any department head approved exception to the policy should be documented in writing and placed in the respective employee's personnel file to ensure that no disagreements arise as to the amount of vacation time an employee has accrued at any one time. 5. GENERAL LEDGER ACTIVITY MONITORING Per review of the fiscal year 2003 pre-audit general ledger received from the City, the following was noted: • The Fox Industrial Fund was out of balance by$6,088 as of April 30,2003. • A $45,068 "automatic update" utility billing posting was recorded in the Water Operations fund and Sewer Maintenance fund. No documentation was on file to support the nature and purpose of this journal entry. RECOMMENDATION: The City should monitor the general ledger of each individual fund on a timely basis to ensure that all transactions for the period are recorded correctly in the ledger therefore ensuring each fund is in balance. Each transaction recorded should have supporting documentation. 6. DEPOSIT COLLATERALIZATION During our testing of cash, we noted that the City maintained deposits in a single financial institution in excess of Federal Deposit Insurance Corporation (FDIC) coverage without having sufficient additional collateral pledged to secure its deposits. The amount of uncollateralized deposits at April 30, 2003 was $631,840 RECOMMENDATION: We recommend that the City consult with its various financial institutions to ensure that all of the City's deposits are fully collateralized at all times. 6 UNITED CITY OF YORKVILLE, ILLINOIS MANAGEMENT LETTER APRIL 30, 2003 PART D. NEW PRONOUNCEMENTS 1. FINANCIAL REPORTING—GASB NO. 34 A future area of focus for the City will be implementation of Governmental Accounting Standards Board (GASB) Statement No. 34, Basic Financial Statements — and Management's Discussion and Analysis — For State and Local Governments. This GASB Statement, which was adopted June 30, 1999 will be effective for the City's financial statements for the fiscal year ended April 30, 2005 although prior implementation is encouraged by GASB. The critical component of the implementation will be presentation matters. The City will be required to include a new section in the financial statements — Management's Discussion and Analysis. This section will need to contain the following information: - Condensed financial statements - Analysis of significant changes in financial statements amounts - Analysis of significant budgetary variations - Capital asset and long-term debt activity - Changes in government-wide financial position - Currently known facts expected to have a material effect on financial condition In addition, major changes have been introduced which will effect the presentation of the financial statements. Such changes include: government-wide statements requiring consolidations of balances, a focus on `major' funds, the inclusion of fixed assets and long-term debt in the governmental fund reporting, mandatory reconciliation's on the face of financial statements and changes in budget based statements. Further, fixed assets, including infrastructure, will need to be capitalized and depreciated, which may require the City to do a great deal of research. 7 UNITED CITY OF YORKVILLE, ILLINOIS MANAGEMENT LETTER APRIL 30, 2003 PART E. OTHER MATTERS 1. FRINGE BENEFITS Fringe benefits have fallen under increased scrutiny by the Internal Revenue Service. Because of this scrutiny, governmental units should pay particular attention to the personal use of employer owned vehicles, as this has become a key area of focus. Additionally, personal use of employer provided cell phones has been called into question. Employers should be able to show that they are attempting to monitor this benefit and either seeking reimbursement from the employee for personal use or reporting the value of the benefit as income to the employee. The following is a summary of the rules for personal use of vehicles, as summarized in an IRS Public Employers Outreach Guide issued in January 2003: Municipally-Owned Vehicles The personal use of a municipally-owned vehicle is a taxable fringe benefit. Personal use includes the value of commuting to and from work in a municipal vehicle, even if the vehicle is taken home for the convenience of the employer. The value of the fringe benefit must be included in wages and is subject to income and employment taxes. There are three methods that can be used to determine the value of the vehicle provided to the employee: commuting value rule, cents-per-mile rule and automobile lease rule. Control employees, who for a government employer includes elected officials (such as a mayor) and employees who earn at least Federal Executive Level V salary ($125,400 for 2003), can only use the cents-per-mile rule of the automobile lease rule. All of an employee's use of a qualified non-personal use vehicle qualifies as a working condition fringe. You can exclude the value of that use from your employee's income. A qualified non-personal use vehicle is any vehicle the employee is not likely to use more than minimally for personal purposes because of its design. Qualified non-personal use vehicles include: • Clearly marked police and fire vehicles. • Unmarked vehicles used by law enforcement officers. The officer MUST be authorized to carry a firearm, execute search warrants and make arrests. • An ambulance or hearse used for its specific purpose. • Any vehicle designed to carry cargo with a loaded gross vehicle weight over 14,000 pounds. • Delivery trucks with seating for the driver only, or driver plus a folding jump seat. • A passenger bus with a capacity of at least 20 passengers used for its specific purpose. • School buses. • Tractors and other special purposes farm vehicles. 8 UNITED CITY OF YORKVILLE, ILLINOIS MANAGEMENT LETTER APRIL 30, 2003 PART C. OTHER MATTERS (Continued) 1. FRINGE BENEFITS (Continued) All Other Employer-Provided Vehicles If you have an employer-provided vehicle that does not qualify as a non-personal use vehicle, and the employee uses the vehicle for personal use, which includes commuting, the personal use of the vehicle is a non-cash taxable fringe benefit. It is the employer's responsibility to determine the actual value of this fringe benefit and to include the taxable portion in the employee's income. Examples: A town-owned pickup truck has the name of the town marked on the vehicle. Usually the employee is allowed to take the vehicle home because he/she is "on call." The vehicle is not a qualified non-personal use vehicle, thus the commuting is a non-cash taxable fringe benefit. An employee takes a city vehicle home in order to avoid exposing it to harm. The vehicle has a city seal on the door and is not to be used for personal use. If the vehicle is not a qualified non-personal use vehicle as discussed earlier, the employee would have a taxable commuting benefit if he/she takes a city vehicle home. Recordkeeping To conform to the accountable plan rules, employees using a vehicle for business purposes (regardless of which special valuation rule is used) must keep track of business miles by keeping a log containing the following information: 1. Date 2. Mileage (beginning and ending) 3. Destination 4. Business purpose 5. Personal use mileage 6. Commuting This information should be kept on a daily basis. We would be pleased to work with management on any questions that may arise with respect to vehicle use and assigning/reporting a value for it as a taxable fringe benefit. 9 4 11 DRAFT UNITED CITY OF YORKVILLE, ILLINOIS FINANCIAL STATEMENTS FOR THE YEAR ENDED APRIL 30, 2003 y I UNITED CITY OF YORKVILLE, ILLINOIS TABLE OF CONTENTS APRIL 30, 2003 REFERENCE PAGE Independent Auditor's Report 1 General Purpose Financial Statements (Combined Statements - Overview) Combined Balance Sheet - All Fund Types and Account Groups STATEMENT 1 3 Combined Statement of Revenues, Expenditures and Changes in Fund Balances - All Governmental Fund Types STATEMENT 2 5 Combined Statement of Revenues, Expenditures and Changes in Fund Balances - Budget (Budgetary Basis) and Actual - All Governmental Fund Types With Legally Adopted Budgets STATEMENT 3 6 g Y P g Combined Statement of Revenues, Expenses and Changes in Retained Earnings/Fund Balance - Proprietary Fund Type and Non-Expendable Trust Fund STATEMENT 4 8 Combined Statement of Changes in Plan Net Assets - Pension Trust Fund STATEMENT 5 9 Combined Statement of Cash Flows - Proprietary Fund Type and Nonexpendable Trust Fund STATEMENT 6 10 Notes to Financial Statements 11 Required Supplementary Information: IMRF - Schedule of Funding Progress 31 IMRF - Schedule of Employer Contributions 32 Police Pension - Schedule of Funding Progress and Schedule of Employer Contributions 33 Combining and Individual Fund and Account Group Financial Statements and Schedules General Fund Balance Sheet EXHIBIT 1 34 Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary Basis) and Actual EXHIBIT 2 35 Schedule of Revenues - Budget (Budgetary Basis) and Actual EXHIBIT 3 36 Schedule of Expenditures - Budget (Budgetary Basis) and Actual EXHIBIT 4 38 it r UNITED CITY OF YORKVILLE, ILLINOIS TABLE OF CONTENTS APRIL 30, 2003 REFERENCE PAGE Combining and Individual Fund and Account Group Financial Statements and Schedules (Continued) Special Revenue Funds All Funds Combining Balance Sheet EXHIBIT 5 42 Combining Statement of Revenues, Expenditures and Changes in Fund Balances EXHIBIT 6 44 Library Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary Basis) and Actual EXHIBIT 7 46 Motor Fuel Tax Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary Basis) and Actual EXHIBIT 8 48 Recreation Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary Basis) and Actual EXHIBIT 9 49 Land Cash Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary Basis) and Actual EXHIBIT 10 51 Sewer Maintenance Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary Basis) and Actual EXHIBIT 11 52 Land Acquisition Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary Basis) and Actual EXHIBIT 12 53 Park Equipment Capital Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary Basis) and Actual EXHIBIT 13 54 UNITED CITY OF YORKVILLE, ILLINOIS TABLE OF CONTENTS APRIL 30, 2003 REFERENCE PAGE Combining and Individual Fund and Account Group Financial Statements and Schedules (Continued) Special Revenue Funds (Continued) Public Works Equipment Capital Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary Basis) and Actual EXHIBIT 14 55 Police Equipment Capital Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary basis) and Actual EXHIBIT 15 56 Parks Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary basis) and Actual EXHIBIT 16 57 Recreation Equipment Capital Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary basis) and Actual EXHIBIT 17 59 Fox Industrial Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary basis) and Actual EXHIBIT 18 60 Capital Projects Funds All Funds Combining Balance Sheet EXHIBIT 19 61 Combining Statement of Revenues, Expenditures and Changes in Fund Balances EXHIBIT 20 62 Municipal Building Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary Basis) and Actual EXHIBIT 21 63 Sanitary Improvement Expansion Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary Basis) and Actual EXHIBIT 22 64 c i UNITED CITY OF YORKVILLE, ILLINOIS TABLE OF CONTENTS APRIL 30, 2003 REFERENCE PAGE Combining and Individual Fund and Account Group Financial Statements and Schedules (Continued) Capital Projects Funds (Continued) Water Improvement Expansion Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget (Budgetary Basis) and Actual EXHIBIT 23 65 Enterprise Fund Water Operating Fund Schedule of Revenues, Expenses and Changes in Retained Earnings - Budget (Budgetary Basis) and Actual EXHIBIT 24 66 Fiduciary Funds All Funds Combining Balance Sheet EXHIBIT 25 68 Non-Expendable Trust Fund Statement of Revenues, Expenditures and Changes in Fund Balance EXHIBIT 26 69 Agency Fund Combining Statement of Changes in Assets and Liabilities EXHIBIT 27 70 Supplemental Schedule Schedule of Assessed Valuations, Tax Rates, Tax Extensions and Tax Collections SCHEDULE 1 71 INDEPENDENT AUDITOR'S REPORT To the Honorable Mayor and City Council United City of Yorkville Yorkville, Illinois We have audited the accompanying general purpose financial statements of the United City of Yorkville, Illinois, as of April 30, 2003, and for the year then ended, as listed in the table of contents. These general purpose financial statements are the responsibility of the United City of Yorkville's management. Our responsibility is to express an opinion on these general purpose financial statements based on our audit. We conducted our audit in accordance with auditing standards generally accepted in the United States of America. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the general purpose financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall general purpose financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. In our opinion, the general purpose financial statements referred to in the first paragraph present fairly, in all material respects, the financial position of the United City of Yorkville, Illinois, as of April 30, 2003, and the results of its operations and cash flows of its proprietary and similar trust funds for the year then ended in conformity with accounting principles generally accepted in the United States of America. As described in Note 1.k. to the general purpose financial statements, the United City of Yorkville is required to adopt the provisions of GASB Statement No. 34, Basic Financial Statements - and Management's Discussion and Analysis-for State and Local Governments, GASB Statement No. 37,Basic Financial Statements - and Management's Discussion and Analysis -for State and Local Governments: Omnibus; GASB Statement No. 38, Certain Financial Statement Note Disclosures and GASB Interpretation No. 6, Recognition and Measurement of Certain Liabilities and Expenditures in Governmental Fund Financial Statements, as of May 1, 2004. This will result in a change to the format and content of the United City of Yorkville's basic financial statements for the year ended April 30, 2005, and thereafter. Our audit was conducted for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The combining and individual fund and account group financial statements and schedules listed in the table of contents are presented for purposes of additional analysis and are not a required part of the general purpose financial statements of the United City of Yorkville, Illinois. Such information has been subjected to the auditing procedures applied in the audit of the general purpose financial statements and, in our opinion, is fairly stated, in all material respects, in relation to the financial statements taken as a whole. 1 Y , The required supplementary information listed in the table of contents is not a required part of the basic financial statements but is supplementary information required by the Governmental Accounting Standards Board. We have applied certain limited procedures, which consisted principally of inquiries of management regarding the methods of measurement and presentation of the supplementary information. However, we did not audit the information and do not express an opinion on it. l'•; # FT Oak Brook, Illinois July 18, 2003 2 (This page left blank intentionally) 1111. f UNITED CITY OF YORKVILLE, ILLINOIS COMBINED BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUPS APRIL 30, 2003 GOVERNMENTAL FUND TYPES GENERAL SPECIAL DEBT CAPITAL FUND REVENUE FUNDS SERVICE FUND PROJECTS FUND ASSETS AND OTHER DEBITS Assets: Cash and Investments $ 772,921 $ 1,172,173 $ 8,443 $ 3,450,171 Property Taxes Receivable 1,195,571 234,944 - - Intergoverrtnental Receivable 722,017 - - - Accounts Receivable 23,695 96,087 - - Interfund Receivable 492,171 244,716 - - Other Assets 69,469 988 - - Property, Plant & Equipment (Net of Accumulated Depreciation) - - - - Other Debits: Amount Available in Debt Service - - - - Amount to be Provided for Retirement of Long-Term Debt - - - - TOTAL ASSETS AND OTHER DEBITS $ 3,275,844 $ 1,748,908 $ 8,443 $ 3,450,171 LIABILITIES, FUND EQUITY AND OTHER CREDITS LIABILITIES Accounts Payable $ 118,030 $ 22,828 $ - $ 315,867 Accrued Payroll 47,927 20,905 - - Interfund Payable 480,166 156,578 - - Deposits Payable 150,660 - - - Deferred Revenue 1,412,924 234,944 - - Other Liabilities - 23,905 - - Loans Payable - - - - Compensated Absences 42,465 9,326 - - Bonds Payable - - - Debt Certificates Payable - - - - TOTAL LIABILITIES 2,252,172 468,486 - 315,867 FUND EQUITY AND OTHER CREDITS Fund Equity: Contributed Capital - - - - Retained Earnings - Unreserved - - - - Fund Balance - Unrestricted 954,203 1,279,434 8,443 3,134,304 Fund Balance - Reserved for Prepaid Items 69,469 988 - - Fund Balance - Reserved for Pension Benefits - - - - Other Credits: Investment in General Fixed Assets - - - - TOTAL FUND EQUITY AND OTHER CREDITS 1,023,672 1,280,422 8,443 3,134,304 TOTAL LIABILITIES, FUND EQUITY AND OTHER CREDITS $ 3,275,844 $ 1,748,908 $ 8,443 $ 3,450,171 The accompanying notes to the financial statements are an integral part of this statement. 3 STATEMENT 1 PROPRIETARY FIDUCIARY FUND TYPE FUND TYPES ACCOUNT GROUPS ENTERPRISE TRUST AND GENERAL GENERAL TOTAL FUND AGENCY FUNDS FIXED ASSETS LONG-TERM DEBT (MEMORANDUM ONLY) $ 262,087 $ 629,463 $ - $ - $ 6,295,258 - - - - 1,430,515 - - - - 722,017 164,783 437,870 - - 722,435 280,518 - - - 1,017,405 - - - - 70,457 1,841,806 - 5,435,542 - 7,277,348 - - - 8,443 8,443 - - - 7,225,923 7,225,923 $ 2,549,194 $ 1,067,333 $ 5,435,542 $ 7,234,366 $ 24,769,801 $ 19,873 $ 57,209 $ - $ - $ 533,807 4,385 - - - 73,217 - 380,661 - - 1,017,405 - - - - 150,660 - - - - 1,647,868 - - - 1,890 25,795 - - - 2,259,209 2,259,209 9,326 - - 75,583 136,700 - - - 625,000 625,000 - - - 4,272,684 4,272,684 33,584 437,870 - 7,234,366 10,742,345 655,124 - - - 655,124 1,860,486 - - - 1,860,486 - 111,569 - - 5,487,953 - - - - 70,457 - 517,894 - - 517,894 - - 5,435,542 - 5,435,542 2,515,610 629,463 5,435,542 - 14,027,456 $ 2,549,194 $ 1,067,333 $ 5,435,542 $ 7,234,366 $ 24,769,801 4 (This page left blank intentionally) STATEMENT 2 UNITED CITY OF YORKVILLE, ILLINOIS COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES For the Year Ended April 30, 2003 GENERAL SPECIAL DEBT CAPITAL TOTAL FUND REVENUE FUNDS SERVICE FUND PROJECTS FUND (MEMORANDUM ONLY) REVENUES Property Taxes $ 1,125,872 $ 229,072 $ - S - $ 1,354,944 Sales Tax 1,520,080 - - - 1,520,080 Income Tax 402,578 - - - 402,578 Motor Fuel Tax - 183,908 - - 183,908 Utility Tax 475,638 - - - 475,638 Other Taxes 360,331 - - - 360,331 Sewer Maintenance Fees - 293,966 - - 293,966 Licenses, Permits & Fees 1,126,167 164,901 - 70,466 1,361,534 Fines 74,203 2,200 - - 76,403 Fees for Services - 125,857 - - 125,857 Deviation Fees - 134,550 - - 134,550 Investment Income 10,870 24,441 2,333 17,139 54,783 Other Revenue 25,662 131,959 90,022 10,139 257,782 Contributions - 8,622 - - 8,622 Connection Fees - 67,515 - 927,911 995,426 Grants 68,934 7,736 - - 76,670 TOTAL REVENUES 5,190,335 1,374,727 92,355 1,025,655 7,683,072 EXPENDITURES Current: General Government 2,206,797 - 42,321 142,919 2,392,037 Public Safety 1,368,970 - - - 1,368,970 Streets & Sanitation 1,017,092 768,718 - 868,593 2,654,403 Culture & Recreation - 903,282 - - 903,282 Sewer Maintenance - 161,203 - - 161,203 Miscellaneous - 44,250 - - 44,250 Capital Outlay - 305,614 - - 305,614 Debt Service: Principal - - 429,894 - 429,894 Interest - 31,238 133,262 - 164,500 TOTAL EXPENDITURES 4,592,859 2,214,305 605,477 1,011,512 8,424,153 Excess (deficiency) of revenues over expenditures 597,476 (839,578) (513,122) 14,143 (741,081) OTHER FINANCING SOURCES (USES) Loan Proceeds 18,694 94,306 - - 113,000 Proceeds from Debt Certificates Sold - - - 2,899,365 2,899,365 Proceeds from Bonds - - 1,280,000 - 1,280,000 Operating Transfers In 375,372 1,259,263 475,175 291,192 2,401,002 Operating Transfers Out (1,281,180) (286,852) - (855,995) (2,424,027) Payment to Escrow Agent - - (1,240,011) - (1,240,011) TOTAL OTHER FINANCING SOURCES (USES) (887,114) 1,066,717 515,164 2,334,562 3,029,329 Excess (deficiency) of revenues over expenditures and other sources (uses) (289,638) 227,139 2,042 2,348,705 2,288,248 Fund Balances at beginning of year 1,313,310 1,053,283 6,401 785,599 3,158,593 Fund Balances at end of year $ 1,023,672 $ 1,280,422 $ 8,443 $ 3,134,304 $ 5,446,841 The accompanying notes to the financial statements are an integral part of this statement. 5 UNITED CITY OF YORKVILLE, ILLINOIS A COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET (BUDGETARY BASIS) AND ACTUAL ALL GOVERNMENTAL FUND TYPES WITH LEGALLY ADOPTED BUDGETS For the Year Ended April 30, 2003 GENERAL SPECIAL FUND REVENUE FUNDS Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) REVENUES Property Taxes $ 1,134,557 $ 1,125,872 $ (8,685) $ 228,445 $ 229,072 $ 627 Sales Tax 1,375,000 1,520,080 145,080 - - - Income Tax 452,416 402,578 (49,838) - - - Motor Fuel Tax - - - 180,000 183,908 3,908 Utility Tax 525,000 475,638 (49,362) - - - Other Taxes 270,213 360,331 90,118 - - - Sewer Maintenance Fees - - - 179,584 293,966 (14,683) Licenses, Permits & Fees 1,110,102 1,126,167 16,065 177,744 164,901 (12,843) Fines 74,000 74,203 203 2,000 2,200 200 Fees for Services - - - 119,294 125,857 6,563 Deviation Fees - - - 124,000 134,550 10,550 Investment Income 10,500 10,870 370 24,500 24,441 (59) Other Revenue 18,200 25,662 7,462 241,200 131,959 (109,241) Contributions - - - 5,200 8,622 3,422 Connection Fees - - - 65,000 67,515 2,515 Grants 67,382 68,934 1,552 113,000 7,736 (105,264) Carry Over 618,750 289,638 (329,112) 233,954 46,678 (187,276) TOTAL REVENUES 5,656,120 5,479,973 (176,147) 1,851,177 1,421,405 (429,772) EXPENDITURES Current: General Government 2,285,837 2,206,797 79,040 - - - Public Safety 1,444,619 1,368,970 75,649 - - - Streets & Sanitation 1,038,550 1,017,092 21,458 976,406 768,718 207,688 Culture & Recreation - - - 954,280 903,282 50,998 Sewer Maintenance - - - 356,384 161,203 195,181 Miscellaneous - - - 165,364 44,250 121,114 Capital Outlay - - - 446,442 305,114 141,328 Debt Service: Principal - - - - - - Interest - - - 19,000 31,238 (12,238) TOTAL EXPENDITURES 4,769,006 4,592,859 176,147 2,917,876 2,213,805 704,071 Excess (deficiency) of revenues over expenditures 887,114 887,114 - (1,066,699) (792,400) 274,299 OTHER FINANCING SOURCES (USES) Loan Proceeds 18,694 18,694 - 94,306 94,306 - Proceeds from Debt Certificates Sold - - - - - Proceeds from Bonds - - - - - - Operating Transfers In 375,372 375,372 - 1,259,263 1,259,263 Operating Transfers Out (1,281,180) (1,281,180) - (286,840) (286,852) (12) Payment to Escrow Agent - - - - - - TOTAL OTHER FINANCING SOURCES (USES) (887,114) (887,114) - 1,066,729 1,066,717 (12) Excess (deficiency) of revenues over expenditures and other sources (uses) $ - - $ - $ 30 274,317 $ 274,287 Fund Balances at beginning of year 1,313,310 1,044,986 Budgeted Carry Over Expended (289,638) (46,678) Fund Balances at end of year $ 1,023,672 $ 1,272,625 The accompanying notes to the financial statements are an integral part of this statement. 6 STATEMENT 3 DEBT CAPITAL SERVICE FUND PROJECTS FUND Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) $ - $ - $ - $ - $ - $ - - 69,000 70,466 1,466 - 2,333 2,333 12,500 17,139 4,639 85,500 90,022 4,522 - 10,139 10,139 - - - 890,000 927,911 37,911 - - - 950,000 - (950,000) - - - 433,736 15,525 (418,211) 85,500 92,355 6,855 2,355,236 1,041,180 (1,314,056) - 42,321 (42,321) 106,900 142,919 (36,019) - - - 4,692,791 868,593 3,824,198 428,959 429,894 (935) - - - 131,716 133,262 (1,546) - - - 560,675 605,477 (44,802) 4,799,691 1,011,512 3,788,179 (475,175) (513,122) (37,947) (2,444,455) 29,668 2,474,123 - - - 2,780,556 2,899,365 118,809 - 1,280,000 1,280,000 - - - 475,175 475,175 - 291,192 291,192 - - - - (627,293) (855,995) (228,702) - (1,240,011) (1,240,011) - - - 475,175 515,164 39,989 2,444,455 2,334,562 (109,893) $ - 2,042 $ 2,042 $ - 2,364,230 $ 2,364,230 6,401 774,925 - (15,525) $ 8,443 $ 3,123,630 1 1 7 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) c. Fixed Assets (Continued) 2. Proprietary Fund (Enterprise Fund) Fixed assets in the Enterprise Fund acquired prior to 1959 have not been capitalized within the fund Also, contributions made to the City by developers have not been recorded. The net book value o these assets are immaterial at April 30, 2003. Fixed assets acquired by the Enterprise Fund after 1959 are capitalized at cost within the fund. Depreciation is being computed on the straight-line method over each asset's estimated useful life. d. Investments Investments are recorded at fair value. The City's investments consist of money market accounts. e. Allowance for Uncollectible Taxes No provision for uncollectible taxes on the current year's levy has been provided for based on the City's collection experience. The City's policy is to write-off uncollected taxes receivable of prior years. f. Estimates Management uses estimates and assumptions in preparing financial statements. Those estimates and assumptions affect the reported amounts of assets and liabilities, the disclosure of contingent assets and liabilities, and the reported revenues and expenditures. Actual results could differ from those estimates. g. Compensated Absences Vested or accumulated vacation leave that is expected to be liquidated with expendable available financial resources is reported as an expenditure and fund liability of the governmental fund that will pay it. Amounts of vested or accumulated vacation leave that are not expected to be liquidated with expendable financial resources are reported in the general long-term debt account group. Vested or accumulated vacation leave of proprietary funds is recorded as an expense and liability of those funds as the benefits accrue to employees. In addition, an accrual for sick time has been made in the long term debt account group for eligible employees. The City's policy allows employees who have been employed by the City for twenty years or more to receive payment for 50% of their unused accumulated sick time at retirement. h. Total Columns on Combined Statements Total columns on the Combined Statements are captioned Memorandum Only to indicate that they are presented only to facilitate financial analysis. Data in these columns does not present financial position, results of operations, or changes in financial position in conformity with accounting principles generally accepted in the United States of America. Neither is such data comparable to a consolidation. Interfund eliminations have not been made in the aggregation of this data. 14 • • UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) i. Budgets and Budgetary Accounting Budgets are adopted on a basis consistent with generally accepted accounting principles, except for budgeted carry overs in governmental funds and depreciation expense in its proprietary fund. Certain governmental funds include carry overs as a revenue item, which represent a budgeted reduction of prior years' accumulations of fund equity. This presentation is not consistent with GAAP. Actual amounts are included in these funds to the extent that expenditures and other financing sources/(uses) exceeded revenues and there is sufficient fund equity to cover the budgeted amount and current year deficit. The City does not budget for depreciation expense in its proprietary fund. Annual budgets are adopted for the General, Library, Motor Fuel Tax, Recreation, Land Cash, Sewer Maintenance, Land Acquisition, Debt Service, Park Equipment Capital, Public Works Equipment Capital, Police Equipment Capital, Parks, Municipal Building, Fox Industrial, Sanitary Improvement Expansion, Water Improvement Expansion and Water Operating. All annual appropriations lapse at fiscal year end. The City follows these procedures in establishing the budgetary data reflected in the financial statements: 1. Prior to May 1, the Mayor submits to the City Council the proposed budget for the fiscal year commencing the following May 1. The operating budget includes proposed expenditures and the means of financing them. 2. Public hearings are conducted at the City Offices to obtain taxpayer comments. 3. Prior to May 1, the budget is legally adopted by a vote of the City Council through passage of an ordinance. 4. Formal budgetary integration is employed as a management control device during the year for the General Fund, Special Revenue Funds, Debt Service Fund and Capital Projects Funds. 5. The budget officer is authorized to transfer budgeted amounts between departments within any fund; however, any revisions that alter the total expenditures of any fund must be approved by the City Council. Supplementary appropriations were approved throughout the year as follows: Original Final Budget Amendments Budget General Fund Revenues $ 5,836,699 $ (180,579) $ 5,656,120 Expenditures 4,966,126 (197,120) 4,769,006 Other Financing Uses 1,264,639 16,541 1,281,180 Motor Fuel Tax Fund Revenues 223,897 129,184 353,081 Expenditures 204,697 130,043 334,740 Other Financing Uses 19,200 (859) 18,341 Sewer Maintenance Fees Fund Revenues 399,862 80,000 479,862 Expenditures 276,384 80,000 356,384 15 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) i. Budgets and Budgetary Accounting (Continued) Original Final Budget Amendments Budget Municipal Building Revenues $ 240,525 $ (170,000) $ 70,525 Expenditures 270,525 (163,625) 106,900 Other Financing Sources 30,000 6,375 36,375 Sanitary Improvement Expansion Fund Revenues 900,211 142,000 1,042,211 Expenditures 2,726,778 (1,868,313) 858,465 Other Financing Sources 2,183,500 (2,000,000) 183,500 Other Financing Uses 356,933 10,313 367,246 Water Improvement Expansion Fund Revenues 1,208,000 34,500 1,242,500 Expenditures 3,799,826 34,500 3,834,326 Debt Service Fund Revenues 90,000 (4,500) 85,500 Expenditures 544,696 15,979 560,675 Other Financing Sources 454,696 20,479 475,175 Public Works Equipment Capital Fund Revenues 191,995 29,000 220,995 Expenditures 251,995 29,000 280,995 Police Equipment Capital Fund Revenues 56,198 4,050 60,248 Expenditures 125,425 4,050 129,475 Water Operating Fund Operating Revenues 1,285,175 10,000 1,295,175 Operating Expenses 1,079,498 10,000 1,089,498 Land Cash Fund Revenues 177,744 1,840 179,584 Expenditures 74,652 1,840 76,492 j. Cash and Cash Equivalents For purposes of reporting cash flows, cash and cash equivalents include cash on hand, demand deposits, and time deposits with maturities of less than three months. k. Future Reporting Standards The City will be required to implement new accounting standards beginning May 1, 2004 for its fiscal year ending April 30, 2005. These standards include GASB Statement No. 34,Basic Financial Statements - and Management's Discussion and Analysis -for State and Local Governments; GASB Statement No. 37, Basic Financial Statements - and Management's Discussion and Analysis - for State and Local Governments: Omnibus; GASB Statement No. 38, Certain Financial Statement Note Disclosures and 16 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) k. Future Reporting Standards (Continued) GASB Interpretation No. 6, Recognition and Measurement of Certain Liabilities and Expenditures in Governmental Fund Financial Statements. The standards establish new financial reporting requirements for state and local governments throughout the United States. When implemented, they will require new information and restructure much of the information that governments have presented in the past. Comparability with reports issued in all prior years will be affected. The City has not yet determined the full impact that adoption of these standards will have on the financial statements. 1. Accounting For Proprietary Fund Activities The City has chosen the option to apply all applicable GASB pronouncements and all FASB Statements and Interpretations, Accounting Principles Board (APB) Opinions and Accounting Research Bulletins (ARB) issued on or before November 30, 1989, unless they conflict with or contradict GASB pronouncements to the proprietary fund activities. 2. CHANGES IN LONG-TERM DEBT The following is a summary of changes in the general long-term debt account group of the City for the year ended April 30, 2003: Balance Balance May 1, 2002 Additions Reductions April 30, 2003 Conover Sewer Recapture $ 1,890 $ - $ - $ 1,890 Compensated Absences 43,402 32,181 - 75,583 IEPA Loan L17-013000 351,863 - 26,619 325,244 Kendall County EDC Loan 154,559 - 86,332 68,227 YNB Loan 235,921 - 119,013 116,908 Castle Bank Loan 218,431 - 40,064 178,367 IEPA Loan L17-115300 1,494,351 - 68,269 1,426,082 YNB Loan - New City Hall 1,284,000 - 1,284,000 - YNB Loan - 2000 Squad Car 12,753 - 12,753 - YNB Loan - Two 2001 Squad Cars 61,225 - 29,844 31,381 2002 G.O. Bonds (Alternate Revenue Source) 625,000 - - 625,000 YNB Loan - Four 2003 Squad Cars - 113,000 - 113,000 2002 Capital Appreciation Debt Certificates* - 2,992,684 - 2,992,684 2002A Refunding Debt Certificates - 1,280,000 - 1,280,000 $ 4,483,395 $4,417,865 $ 1,666,894 $ 7,234,366 *Note: $93,319 of the additions for this bond represents the accretion of interest. 17 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 2. CHANGES IN LONG-TERM DEBT (Continued) Conover Sewer Recapture $1,890 owed to John Conover as reimbursement for sewer extensions. $ 1,890 Compensated Absences Vested or accumulated vacation leave that is not expected to be paid in the upcoming Fiscal Year. $ 75,583 IEPA Loan L17-013000 $549,081 debt to the Illinois Environmental Protection Agency for Sewer Construction assistance at 3.58% interest maturing January, 2013 $ 325,244 Kendall County Loan $700,000 debt to Kendall County for Sewer Construction Assistance at 4.75% interest maturing February, 2004 $ 68,227 YNB Loan $1,107,000 debt to Yorkville National Bank at 5.10% interest maturing October, 2003 $ 116,908 Castle Bank of Yorkville Loan - River Crossing $324,595 debt to Castle Bank at 4.75% interest maturing December, 2003 $ 178,367 IEPA Loan L17-115300 $1,656,809 debt to Illinois Environmental Protection Agency for Sewer Construction Assistance at 2.625% interest maturing September, 2019 $ 1,426,082 YNB Loan - Two 2001 Squad Cars $79,000 debt to Yorkville National Bank at 4.97% interest maturing December, 2003 $ 31,381 Series 2002 G.O. Bonds (Alternate Revenue Source) $625,000 payable to BNY Midwest Trust Company at an interest rate ranging from 3.00% to 4.75% and maturing December, 2012. $ 625,000 YNB Loan - Four 2003 Squad Cars and Equipment $113,000 debt to Yorkville National Bank at 2.69% interest maturing May, 2004 $ 113,000 18 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 2. CHANGES IN LONG-TERM DEBT (Continued) Series 2002 Capital Appreciation Debt Certificates During fiscal year 2003, the City issued $2,899,365 in capital appreciation debt certificates. The Series 2002 Certificates outstanding as of April 30, 2003 totaling $2,992,684 bear interest ranging from 2.5% to 5.4%. Interest is not paid but rather accretes to principal each May 1. The principal matures May 1, 2004 - May 1, 2021 in accreted values totaling $5,420,000. $ 2,992,684 Series 2002A Refunding Debt Certificates $1,280,000 payable to BNY Midwest Trust Company at an interest rate ranging from 2.15% to 5.15% and maturing January, 2022. The Debt Certificates, Series 2002 were issued to advance refund $1,237,000 of outstanding Installment Contract Certificates, Series 1999. The net proceeds from the Debt Certificates, Series 2002 were used to purchase U.S. Government securities. Those securities were deposited to an irrevocable trust with an escrow agent to provide for funds to call the outstanding 1999 Installment Contract Certificates on February 1, 2003. The City's advance refunding of the 1999 Installment Contract Certificates increased the City's total debt service payments over the next 19 years by $633,452 and resulted in an economic loss (difference between the present values of the debt service payments on the old and new debt) of$22,353. $ 1,280,000 The debt payment schedule to maturity for the Capital Appreciation Debt Certificates is as follows: Series 2002 Capital Fiscal Year Appreciation Debt Certificates Ending Principal April 30, Accretion Repayment 2004 $ 144,175 $ 25,000 2005 150,569 25,000 2006 157,166 25,000 2007 164,025 35,000 2008 170,796 60,000 2009-2013 879,669 1,450,000 2014-2018 619,246 2,375,000 2019-2021 141,670 1,425,000 Totals $ 2,427,316 $ 5,420,000 Accreted value at April 30, 2003 $ 2,992,684 19 _1 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 2. CHANGES IN LONG-TERM DEBT (Continued) The debt payment schedule to maturity including interest for the above debt excluding the Capital Appreciation Debt Certificates is as follows: Conover Compen- Sewer sated IEPA Loan Kendall County Yorkville National Due in Recapture Absences L17-013000 EDC Loan Bank Loan Fiscal Year Principal Principal Principal Interest Principal Interest Principal Interest 2004 $ - $ - $ 27,581 $ 11,399 $ 68,227 $ 1,716 $ 116,908 $ 3,241 2005 - - 28,577 10,403 - - - - 2006 - - 29,609 9,371 - - - - 2007 - - 30,679 8,301 - - - - 2008 - - 31,787 7,193 - - - - 2009-13 - - 177,011 17,889 - - - - 2014-18 - - - - - - - - 2019-23 1,890 75,583 - - - - - - Totals $ 1,890 $ 75,583 $ 325,244 $ 64,556 $ 68,227 $ 1,716 $ 116,908 $ 3,241 Castle Bank Loan- IEPA Loan Yorkville Nat. Bank Loan Series 2002 Due in River Crossing L17-115300 Two 2001 Squad Cars G.O. Bonds(Alt.Rev. Source) Fiscal Year Principal Interest Principal Interest Principal Interest Principal Interest 2004 $ 178,367 $ 5,150 $ 70,073 $ 36,978 $ 31,381 $ 1,548 $ 50,000 $ 25,793 2005 - - 71,924 35,127 - - 55,000 24,293 2006 - - 73,825 33,226 - - 55,000 22,450 2007 - - 75,775 31,276 - - 60,000 20,415 2008 - - 77,778 29,273 - - 60,000 17,793 2009-13 - - 420,822 114,432 - - 345,000 48,846 2014-18 - - 479,434 55,820 - - - - 2019-23 - - 156,451 4,122 - - - - Totals $ 178,367 $ 5,150 $ 1,426,082 $ 340,254 $ 31,381 $ 1,548 $ 625,000 $ 159,590 Yorkville Nat. Bank Loan Series 2002A Refunding Due in Four 2003 Squad Cars Debt Certificates Total Fiscal Year Principal _ Interest Principal Interest Principal Interest 2004 $ 55,800 $ 2,964 $ 45,000 $ 58,452 $ 643,337 $ 147,241 2005 57,200 1,564 50,000 54,998 262,701 126,385 2006 - - 50,000 53,923 208,434 118,970 2007 - - 50,000 52,423 216,454 112,415 2008 - - 50,000 50,923 219,565 105,182 2009-13 - - 295,000 221,470 1,237,833 402,637 2014-18 - - 370,000 149,355 849,434 205,175 2019-23 - - 370,000 48,528 603,924 52,650 Totals $ 113,000 $ 4,528 $ 1,280,000 $ 690,072 $ 4,241,682 $ 1,270,655 20 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 3. FIXED ASSETS The following is a summary of changes in the general fixed assets account group during the fiscal year: Balance Balance April 30, May 1, 2002 Additions Deletions 2003 Land $ 118,715 $ - $ - $ 118,715 Land Improvements 316,520 - - 316,520 Building and Building Improvements 2,784,999 1,510 - 2,786,509 Vehicles and Moveable Equipment 1,925,903 287,895 - 2,213,798 Total $ 5,146,137 $ 289,405 $ - $ 5,435,542 The following is a summary of proprietary-fund type fixed assets at April 30, 2003. Enterprise Fund Current Balance Balance Year April 30, May 1, 2002 Activity 2003 Water Distribution System $ 2,559,872 $ - $2,559,872 Equipment 75,174 - 75,174 Construction in Progress - 228,702 228,702 Less: Accumulated Depreciation (970,121) (51,821) (1,021,942) Net Fixed Assets $ 1,664,925 $ 176,881 $ 1,841,806 4. DEFINED BENEFIT PENSION PLANS Illinois Municipal Retirement Fund The City's defined benefit pension plan, Illinois Municipal Retirement (IMRF) provides retirement, disability, annual cost of living adjustments and death benefits to plan members and beneficiaries. IMRF is an agent multiple employer pension plan that acts as a common investment and administrative agent for local Governments and school districts in Illinois. The Illinois Pension Code establishes the benefit provisions of the plan that can only be amended by the Illinois General Assembly. IMRF issues a publicly available financial report that includes financial statements and required supplementary information. That report may be obtained by writing to the Illinois Municipal Retirement Fund, 2211 York Road, Suite 500, Oak Brook, Illinois 60523. Employees participating in IMRF are required to contribute 4.50 percent of their annual covered salary The member rate is established by state statute. The City is required to contribute at an acttvar=� � determined rate. The employer rate for calendar year 2002 was 5.58 percent of payroll. The employer contribution requirements are established and may be amended by the IMRF Board of Trustees. IMRF's unfunded actuarial accrued liability is being amortized as a level percentage of projected payroll on a closed basis. The remaining amortization period at December 31, 2002 was 10 years. 21 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 4. DEFINED BENEFIT PENSION PLANS (Continued) Illinois Municipal Retirement Fund (Continued) For December 31, 2002, the City's annual pension cost of$66,662 was equal to City's required and actual contributions. The required contribution was determined as part of the December 31, 2000 actuarial valuation using the entry age actuarial cost method. The actuarial assumptions included (a) 7.50% investment rate of return (net of administrative expenses), (b) projected salary increases of 4.00% a year attributable to inflation, (c) additional projected salary increases ranging from 0.4% to 11.6% per year depending on age and service, attributable to seniority/merit, and (d)post-retirement benefit increases of 3% annually. The actuarial value of IMRF assets was determined using techniques that smooth the effects of short-term volatility in the market value of investments over a five-year period. The assumptions used for the 2001 actuarial valuation were based on the 1996-1998 experience study. However, the 2002 actuarial valuation information shown on the Schedule of Funding Progress is based on the assumptions derived from 1999 - 2001 Experience Study. The effect of the assumption change decreased the unfunded actuarial accrued liability by $4,333. TREND INFORMATION Actuarial Percentage Valuation Annual Pension Of APC Net Pension Date Cost (APC) Contributed Obligation 12/31/02 $ 66,662 100% $0 12/31/01 105,124 100% 0 12/31/00 120,515 100% 0 12/31/99 121,714 100% 0 12/31/98 120,377 100% 0 12/31/97 119,648 100% 0 12/31/96 94,581 100% 0 Police Pension During fiscal year 2002, the City's police force began making contributions to the newly formed Police Pension Fund. As of April 30, 2003, $517,894 had been deposited into the fund. The following is a description of the plan: 22 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 4. DEFINED BENEFIT PENSION PLANS (Continued) Police Pension (Continued) 1. Plan Description: Police sworn personnel are covered by the Police Pension Fund, which is a defined benefit single- employer pension plan. Although this is a single-employer pension plan, the defined benefits and employee and employer contributions levels are governed by Illinois Compiled Statutes(40 ILCS 5/3) and may be amended only by the Illinois legislature. The City accounts for the plan as a pension trust fund. At April 30, 2003, the Police Pension Fund membership consisted of: Retirees and Beneficiaries Currently Receiving Benefits and Terminated Employees Entitled to Benefits but not yet receiving them - Current Employees Vested - Nonvested 17 TOTAL 17 The following is a summary of the Police Pension Fund as provided for in Illinois Compiled Statutes. The Police Pension Fund provides retirement benefits as well as death and disability benefits. Employees attaining the age of 50 or more with 20 or more years of creditable service are entitled to receive an annual retirement benefit of one-half of the salary attached to the rank held on the last day of service, or for one year prior to the last day, whichever is greater. The pension shall be increased by 2% of such salary for each additional year of service over 20 years up to 30 years, and 1% of such salary for each additional year of service over 30 years, to a maximum of 75% of such salary. Employees with at least 8 years but less than 20 years of credited service may retire at or after age 60 and receive a reduced benefit. The monthly pension of a police officer who retired with 20 or more years of service after January 1, 1977, shall be increased annually, following the first anniversary date of retirement and be paid upon reaching the age of at least 55 years, by 3% of the original pension and 3% simple interest annually thereafter. 23 Now UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 4. DEFINED BENEFIT PENSION PLANS (Continued) Police Pension (Continued) 2. Summary of Significant Accounting Policies and Plan Asset Matters: Basis of Accounting The financial statements are prepared using the cash basis of accounting. Employee contributions are recognized as additions in the period in which employee services are performed. Method Used to Value Investments Investments are reported at fair value. Short-term investments are reported at cost, which approximates fair value. Investment income is recognized when earned. Gains and losses on sales and exchanges of fixed-income securities are recognized on the transaction date. 3. Contributions: Covered employees are required to contribute 9.91% of their base salary to the Police Pension Fund. If an employee leaves covered employment with less than 20 years of service, accumulated employee contributions may be refunded without accumulated interest. The City is required to contribute the remaining amounts necessary to finance the plan as actuarially determined by an enrolled actuary at the Illinois Department of Insurance. Future administrative costs are expected to be financed through investment earnings. 4. Concentrations of Investments: The Police Pension Fund had no other investments, other than those issued or guaranteed by the U.S. Government, which represent 5% or more of net assets. 24 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 5. INTERFUND RECEIVABLES AND PAYABLES Individual fund receivable and payable balances at April 30, 2003 are as follows: Interfund Interfund Receivables Payables General Recreation $ 51,095 $ - Library 34,777 - Parks 25,638 - Collection 380,661 - Sewer Maintenance Fees - 244,716 Water Operations - 235,450 Total 492,171 480,166 Sewer Maintenance Fees General 244,716 - Water Operating - 45,068 Total 244,716 45,068 Parks General - 25,638 Total - 25,638 Library General - 34,777 Total - 34,777 Recreation General - 51,095 Total - 51,095 Collection General - 380,661 Total - 380,661 Water Operating General 235,450 - Sewer Maintenance Fees 45,068 - Total 280,518 - Total all funds $ 1,017,405 $ 1,017,405 25 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 6. PROPERTY TAX CALENDAR The following information gives significant dates on the property tax calendar of the City. - The property tax lien date is January 1; - The annual tax levy ordinance for 2002 was passed on December 17, 2002. - Property taxes are due to the County Collector in two installments, June 2 and September 1; - Property taxes for the 2002 levy are normally received monthly beginning in June and generally ending in September, 2003. Property tax revenue recorded during the current fiscal year represents receipts of the 2001 tax levy. The entire 2002 property tax levy has been reflected as deferred revenue even though a portion of the levy was collected prior to April 30, as it is the City's policy to recognize this revenue as available for the 2003-04 fiscal year. 7. DEPOSITS AND INVESTMENTS The Government maintains a cash and investment pool that is available for use by most funds. Each fund type's portion of this pool is displayed on the combined balance sheet as "cash and investments". The Government is authorized by State statute and their own local ordinances to invest in the following: - Certificates of Deposit - Money Markets - Illinois Funds - Deposit Account - Saving Accounts Cash on hand in the amount of$ 375 has been excluded from the amounts shown below. The following are the cash/deposit balances at year end: Book Balance $ 6,294,883 Bank Balance $ 6,659,770 Bank Balance Category 1 - Deposits covered by depository insurance or collateral held by the City or its agent in the City name. $ 6,027,930 Category 2 - Deposits covered by collateral held by a financial institution's trust department or by its agent in the City name. - Category 3 - Deposits which are uninsured and uncollateralized. 631,840* TOTAL $ 6,659,770 * $517,894 of the balance in category 3 consists of Pension Fund accounts 26 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 8. FUND EQUITY The following adjustments were made to beginning Fund Balances: General Fund Library Fund Ending Fund Balance as reported, April 30, 2002 $ 1,753,210 $ 235,861 Correct prior year recognition of property taxes (415,976) (86,591) Correct prior year accounts receivable (23,924) - Beginning Fund Balance as reported, April 30, 2003 $ 1,313,310 $ 149,270 9. OPERATING TRANSFERS Transfer Out Transfer In General Water Operating $ - $ 104,360 Sewer Maintenance Fees - 21,012 Water Improvement - 100,000 Sanitary Improvement Expansion 150,000 150,000 Police Equipment Capital 13,850 - Recreation 172,772 - Parks 260,183 - Debt Service 19,975 - Fox Industrial 628,025 - Municipal Building 36,375 Total 1,281,180 375,372 Municipal Building General - 36,375 Total - 36,375 Police Equipment Capital General - 13,850 Debt Service 38,929 - Total 38,929 13,850 Public Works Equipment Capital Water Operating - 30,000 Sewer Maintenance Fees - 30,000 Total - 60,000 Park Equipment Capital Land Cash Fees - 14,220 Park s - 3,000 Total - 17,220 Sanitary Improvement Expansion General 150,000 150,000 Sewer Maintenance Fees - 33,500 Debt Service 217,246 - Total 367,246 183,500 27 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 9. OPERATING TRANSFERS (Continued) Transfer Out Transfer In Water Improvement Expansion Water Operating $ 228,702 $ 71,317 Debt Service 160,047 - General 100,000 - Total 488,749 71,317 Debt Service General - 19,975 Water Improvement Expansion - 160,047 Sewer Maintenance Fees - 38,978 Sanitary Improvement Expansion - 217,246 Police Equipment Capital - 38,929 Total - 475,175 Water Operating Water Improvement Expansion 71,317 228,702 General 104,360 - Public Works Equipment Capital 30,000 - Total 205,677 228,702 Sewer Maintenance Debt Service 38,978 - General 21,012 - Sanitary Improvement Expansion 33,500 - Public Works Equipment Capital 30,000 - Total 123,490 - Land Cash Park Equipment Capital 14,220 - Land Acquisition 88,872 - Total 103,092 - Land Acquisition Land Cash Fees - 88,872 Total - 88,872 Parks General - 260,183 Park Equipment Capital 3,000 - Total 3,000 260,183 Recreation General - 172,772 Total - 172,772 28 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 9. OPERATING TRANSFERS (Continued) Transfer Out Transfer In Fox Industrial General $ - $ 628,025 Motor Fuel Tax - 18,341 Total - 646,366 Motor Fuel Tax Fox Industrial 18,341 - Total 18,341 - TOTAL ALL FUNDS $ 2,629,704 $ 2,629,704 10. SEGMENT INFORMATION The City maintains an Enterprise Fund and segment information for the year ended is as follows: Water Operating Fund Operating Revenues $ 1,039,922 Depreciation, Depletion and Amortization Expense 51,821 Operating Income (Loss) 398,325 Operating Transfers: In 228,702 Out (205,677) Net Income (Loss) 431,710 Plant, Property and Equipment: Additions 228,702 Net Working Capital 393,286 Total Assets 2,549,194 Total Equity 2,515,610 11. RISK MANAGEMENT The City is exposed to various risks of loss related to torts; theft of, damage to, and destruction of assets; errors and omissions; injuries to employees; and natural disasters. These risks are covered by commercial insurance purchased from independent third parties. The City also purchased its employee health and accident insurance from commercial carriers. Settled claims from these risks have not exceeded commercial insurance coverage for the past three years. There were no significant reductions in insurance coverage during the fiscal year ended April 30, 2003. 29 UNITED CITY OF YORKVILLE, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 2003 12. EXPENDITURES OVER BUDGET The following funds had an excess of expenditures over budget: Debt Service $ 44,802 Recreation 54,221 Recreation Equipment Capital 500 Municipal Building 36,019 13. RECONCILIATION OF COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL TO COMBINED STATEMENT OF REVENUES EXPENDITURES AND CHANGES IN FUND BALANCE. Special Capital Revenue Funds Projects Fund Fund Balances at end of year (Statement 3) $ 1,272,625 $ 3,123,630 Funds Not Budgeted: South Sewer - 10,674 Recreation Equipment Capital 7,797 - Total Fund Balances at end of year (Statement 2) $ 1,280,422 $ 3,134,304 14. SUBSEQUENT EVENT In June 2003, the City Council approved an ordinance authorizing and providing for an Installment Purchase Agreement for the purpose of paying a portion of the cost of waterworks improvements, and authorizing and providing for the issuance of$4,800,000 Debt Certificates, Series 2003. 30 UNITED CITY OF YORKVILLE, ILLINOIS REQUIRED SUPPLEMENTARY INFORMATION IMRF SCHEDULE OF FUNDING PROGRESS APRIL 30, 2003 Actuarial Actuarial Accrued Unfunded UAAL as a Actuarial Value of Liability (AAL) AAL Funded Covered Percentage of Valuation Assets Entry Age (UAAL) Ratio Payroll Covered Payroll Date (a) (b) (b-a) (a/b) (c) ((b-a)/c) 12/31/2002 $ 2,634,906 $ 2,415,010 $ (219,896) 109.11% $ 1,194,657 -18.41% 12/31/2001 3,530,307 3,819,354 289,047 92.43% 1,757,922 16.44% 12/31/2000 3,771,735 3,348,239 (423,496) 112.65% 1,545,071 0.00% 12/31/1999 3,369,675 3,074,106 (295,569) 109.61% 1,440,412 0.00% 12/31/1998 2,746,240 2,664,737 (81,503) 103.06% 1,377,309 0.00% 12/31/1997 2,390,369 2,465,227 74,858 96.96% 1,304,648 5.74% 12/31/1996 1,974,950 2,088,963 114,013 94.54% 1,143,666 9.97% 12/31/1995 1,701,060 1,920,271 219,211 88.58% 1,008,568 21.73% 12/31/1994 1,534,077 1,554,196 20,119 98.71% 979,281 2.05% On a market value basis, the actuarial value of assets as of December 31, 2002 is $1,754,377. On a market basis, the funded ratio would be 72.64%. *Digest of Changes 2002 Assumptions The actuarial assumptions used to determine the actuarial accrued liability for 2002 are based on the 1999-2001 Experience Study. The principal changes were: - Fewer members are expected to take refunds early in their career. - For Regular members, fewer normal and early retirements are expected to occur. 31 UNITED CITY OF YORKVILLE, ILLINOIS REQUIRED SUPPLEMENTARY INFORMATION IMRF SCHEDULE OF EMPLOYER CONTRIBUTIONS APRIL 30, 2003 Actuarial Annual Valuation Employer Required Percent Date Contributions Contribution Contributed 12/31/2002 $ 66,662 $ 66,662 100% 12/31/2001 105,124 105,124 100% 12/31/2000 120,515 120,515 100% 12/31/1999 121,714 121,714 100% 12/31/1998 120,377 120,377 100% 12/31/1997 119,648 119,648 100% 12/31/1996 94,581 94,581 100% 12/31/1995 85,442 85,442 100% 12/31/1994 87,548 87,548 100% 32 UNITED CITY OF YORKVILLE, ILLINOIS REQUIRED SUPPLEMENTARY INFORMATION POLICE PENSION FUND SCHEDULE OF FUNDING PROGRESS APRIL 30, 2003 Actuarial Actuarial Accrued Unfunded UAAL as a Actuarial Value of Liability (AAL) AAL Funded Covered Percentage of Valuation Assets Entry Age (UAAL) Ratio Payroll Covered Payroll Date (a) (b) (b-a) (a/b) (c) ((b-a)/c) 4/30/2003 $ 517,894 NA NA NA NA NA NA - The pension fund was formed during fiscal year 2002, as such, no actuarial study was complete at the time of this report. POLICE PENSION FUND SCHEDULE OF EMPLOYER CONTRIBUTIONS APRIL 30, 2003 Actuarial Annual Valuation Employer Required Percent Date Contributions Contribution Contributed 4/30/2003 $ 117,713 NA NA NA - The pension fund was formed during fiscal year 2002, as such, no actuarial study was complete at the time of this report. 33 EXHIBIT 1 UNITED CITY OF YORKVILLE, ILLINOIS GENERAL FUND BALANCE SHEET APRIL 30, 2003 ASSETS Cash and Investments S 772,921 Property Taxes Receivable 1,195,571 Intergovernmental Receivable 722,017 Accounts Receivable 23,695 Interfund Receivable 492,171 Other Assets 69,469 TOTAL ASSETS S 3,275,844 LIABILITIES AND FUND BALANCE LIABILITIES Accounts Payable S 118,030 Accrued Payroll 47,927 Interfund Payable 480,166 Deposits Payable 150,660 Deferred Revenue 1,412,924 Compensated Absences 42,465 TOTAL LIABILITIES 2,252,172 FUND BALANCE Unrestricted 954,203 Reserved for Prepaid Items 69,469 TOTAL FUND BALANCE 1,023,672 TOTAL LIABILITIES AND FUND BALANCE S 3,275,844 34 EXHIBIT 2 UNITED CITY OF YORKVILLE, ILLINOIS GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Property Taxes $ 1,134,557 $ 1,125,872 $ (8,685) Sales Tax 1,375,000 1,520,080 145,080 Income Tax 452,416 402,578 (49,838) Utility Tax 525,000 475,638 (49,362) Other Taxes 270,213 360,331 90,118 Licenses, Permits & Fees 1,110,102 1,126,167 16,065 Fines 74,000 74,203 203 Investment Income 10,500 10,870 370 Other Revenue 18,200 25,662 7,462 Grants 67,382 68,934 1,552 Carry Over 618,750 289,638 (329,112) TOTAL REVENUES 5,656,120 5,479,973 (176,147) EXPENDITURES Current: General Government 2,285,837 2,206,797 79,040 Public Safety 1,444,619 1,368,970 75,649 Streets & Sanitation 1,038,550 1,017,092 21,458 TOTAL EXPENDITURES 4,769,006 4,592,859 176,147 Excess (deficiency) of revenues over expenditures 887,114 887,114 - OTHER FINANCING SOURCES (USES) Loan Proceeds 18,694 18,694 - Operating Transfers In 375,372 375,372 - Operating Transfers Out (1,281,180) (1,281,180) - TOTAL OTHER FINANCING SOURCES (USES) (887,114) (887,114) - Excess (deficiency) of revenues over expenditures and other sources (uses) $ - - $ - Fund Balance at beginning of year 1,313,310 Budgeted Carryover Expended (289,638) Fund Balance at end of year $ 1,023,672 35 EXHIBIT 3 UNITED CITY OF YORKVILLE, ILLINOIS GENERAL FUND SCHEDULE OF REVENUES - BUDGET (BUDGETARY BASIS) AND ACTUAL For the Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Property Taxes Real Estate Taxes $ 1,038,757 $ 1,036,545 $ (2,212) Personal Property Replacement Taxes 10,800 8,421 (2,379) Township Road & Bridge Taxes 85,000 80,906 (4,094) Total Property Taxes 1,134,557 1,125,872 (8,685) Sales Tax Municipal Sales Taxes 1,375,000 1,520,080 145,080 Income Tax Illinois State Income Taxes 452,416 402,578 (49,838) Utility Tax Municipal Utility Taxes 525,000 475,638 (49,362) Other Taxes NICOR Franchise Fees 23,000 22,628 (372) Photo Processing Sales Taxes 4,828 1,792 (3,036) Use Tax 64,160 54,433 (9,727) Cable TV Franchise Taxes 40,000 24,549 (15,451) Telephone Franchise Taxes 100,000 218,883 118,883 Hotel Taxes 16,500 17,208 708 Reimbursements - Other Governments 19,875 19,000 (875) Reimbursements - Police Protection 1,850 1,838 (12) Total Other Taxes 270,213 360,331 90,118 Licenses, Permits & Fees Development Fees - Public Work 335,000 355,544 20,544 Liquor Licenses 18,000 15,105 (2,895) Other Licenses 1,800 1,050 (750) Building Permits 560,000 586,345 26,345 Filing Fees 40,000 36,688 (3,312) Garbage Surcharge 139,302 114,764 (24,538) Collection Fees - YBSD 15,000 15,000 - Sidewalk Construction 1,000 1,671 671 Total Licenses, Permits & Fees 1,110,102 1,126,167 16,065 Fines Traffic Fines 70,000 70,928 928 City Ordinance Fines 4,000 3,275 (725) Total Fines 74,000 74,203 203 Investment Income Working Cash Interest 2,100 1,864 (236) Investment Income 8,400 9,006 606 Total Investment Income 10,500 10,870 370 36 EXHIBIT 3 (CONTINUED) UNITED CITY OF YORKVILLE, ILLINOIS GENERAL FUND SCHEDULE OF REVENUES — BUDGET (BUDGETARY BASIS) AND ACTUAL For the Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) Other Revenue Refuse Sticker $ - $ 95 $ 95 Miscellaneous Income 17,000 24,367 7,367 DARE Donations 1,200 1,200 - Total Other Revenue 18,200 25,662 7,462 Grants ICJIA - Juvenile 17,820 17,820 - Tobacco Enforcement Grant - 100 100 Cops Grants I - Officers 30,000 30,387 387 Cops Grant IV - Vests 1,562 1,292 (270) Grant - Rob Roy Creek Flood Study 18,000 19,335 1,335 Total Grants 67,382 68,934 1,552 Carry Over 618,750 289,638 (329,112) TOTAL REVENUES S 5,656,120 $ 5,479,973 $ (176,147) 37 EXHIBIT 4 UNITED CITY OF YORKVILLE, ILLINOIS GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET (BUDGETARY BASIS) AND ACTUAL For the Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) EXPENDITURES General Government Finance Secretarial Salaries $ 72,808 $ 76,443 $ (3,635) Overtime 500 222 278 Employee Salary - Part-Time 36,000 35,791 209 City Attorney Salary 11,899 11,635 264 Mayor Salary 4,500 4,535 (35) Liquor Commissioner Salary 1,000 1,000 City Clerk Salary 3,600 3,635 (35) City Treasurer Salary 3,600 3,600 - Alderman Salary 22,600 24,400 (1,800) Admin Car 18,694 18,694 - NICOR Gas 28,000 27,197 803 Social Security Tax 130,100 126,011 4,089 City Share - IMRF 42,079 50,403 (8,324) Unemployment Compensation Tax 10,290 10,367 (77) Group Health Insurance 319,091 318,904 187 Group Life Insurance 16,000 12,742 3,258 Vision & Dental Assistance 30,000 25,402 4,598 Min/Max Insurance Reserve 7,614 7,614 - Marketing (Hotel Tax) 16,500 17,043 (543) General Liability Insurance 96,589 90,225 6,364 Bonding 1,300 1,360 (60) Audit Fees & Expenses 14,613 14,613 - Legal Services 17,000 17,295 (295) Legal (Filing) Fees 4,000 3,062 938 Maintenance - Equipment 1,000 - 1,000 Maintenance - Computers 4,000 3,715 285 Maintenance - Photocopiers 12,000 8,697 3,303 Maintenance - Telephone System 5,000 2,474 2,526 Contractual Services 12,000 14,186 (2,186) Dues 1,500 1,863 (363) Illinois Municipal League Dues 550 551 (1) Training & Conferences 6,000 5,489 511 Travel Expenses 14,000 14,419 (419) Publishing/Advertising 800 599 201 Printing/Copying 4,000 3,822 178 Subscriptions 500 384 116 Codification 4,750 4,421 329 Accounting Assistance 4,000 3,583 417 Accounting Study 4,398 4,398 - Accounting System Review 15,100 15,664 (564) Postage/Shipping 8,500 5,853 2,647 Telephone 18,000 17,334 666 Office Supplies 9,500 10,000 (500) Operating Supplies 5,000 5,066 (66) Computer Supplies 13,000 12,769 231 Employee Assistance 1,400 1,737 (337) Wearing Apparel 1,200 839 361 Cellular Phones 6,300 6,357 (57) Miscellaneous 100 245 (145) 38 EXHIBIT 4 (CONTINUED) UNITED CITY OF YORKVILLE, ILLINOIS GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET (BUDGETARY BASIS) AND ACTUAL For the Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) Engineering Salaries $ 110,000 $ 113,328 $ (3,328) Engineering Supplies 8,000 8,529 (529) Engineering Review 35,000 53,375 (18,375) Contingency 131,798 124,815 6,983 Office Equipment 4,000 3,860 140 Facade Program 20,000 9,906 10,094 Metra Study 4,000 1,200 2,800 City Tax Rebate 1,125 1,124 1 GASB34 14,000 10,445 3,555 Cable Consortium Fee 8,000 - 8,000 Public Relations 6,000 6,086 (86) Sales Tax Rebate 110,000 77,218 32,782 Office Cleaning 14,500 14,261 239 Administrative Salaries 258,439 262,860 (4,421) Building Inspections 500,000 472,622 27,378 Maintenance Office Equipment - 510 (510) Total General Government 2,285,837 2,206,797 79,040 Public Safety Police Department Employee Salaries 352,176 328,567 23,609 Crossing Guard Salaries 9,050 8,418 632 Chief of Police 81,000 80,579 421 Overtime 50,000 46,964 3,036 Employee Salary - Part-Time 27,000 25,738 1,262 COPS Salaries 206,000 212,694 (6,694) Lieutenant/Sergeants 229,154 237,442 (8,288) Tuition Reimbursement 11,000 10,980 20 Clerk Salaries 79,000 80,915 (1,915) SRT Fee 1,000 1,000 - Lethal & Non Lethal Weapons 6,260 5,215 1,045 Bike Patrol 1,500 1,443 57 Police Commission 7,200 6,935 265 Maintenance - Office Equipment 2,250 1,073 1,177 Gun Range Fees 625 300 325 Cops Grant IV - Vests 1,562 1,640 (78) Clasy Grant 4,000 - 4,000 ICJIA 22,452 22,216 236 Maintenance - Equipment 7,320 6,909 411 Maintenance - Vehicles 20,000 19,866 134 Dues 2,000 2,044 (44) Training & Conferences 9,200 9,898 (698) Travel Expenses 5,000 4,155 845 Publishing/Advertising 900 880 20 Printing/Copying 1,700 1,591 109 Subscriptions 250 158 92 Postage/Shipping 2,200 2,489 (289) Telephone 15,750 16,071 (321) Office Supplies 6,000 6,457 (457) 39 MIL EXHIBIT 4 (CONTINUED) UNITED CITY OF YORKVILLE, ILLINOIS GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET (BUDGETARY BASIS) AND ACTUAL For the Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) Operating Supplies $ 15,000 $ 14,897 $ 103 Gasoline 21,000 22,236 (1,236) Police Recruiting Academy 1,095 1,095 - Wearing Apparel 21,500 21,443 57 Ammunition 6,500 7,633 (1,133) Psychological Services 500 500 - Health Service 1,600 1,583 17 Legal Service 10,000 13,132 (3,132) Maintenance - Computers 1,800 1,745 55 Cellular Phones 5,200 5,229 (29) Pagers 1,600 1,078 522 Community Relations 4,750 4,718 32 MTD - Alerts Fee 1,848 1,848 - Contingency 9,144 7,930 1,214 Computers/Software 5,500 3,553 1,947 Pension Contributions 176,033 117,713 58,320 Total Public Safety 1,444,619 1,368,970 75,649 Streets & Sanitation Streets & Alley Employee Salaries 85,000 85,632 (632) Overtime 12,500 13,335 (835) Employee Salary - Part-Time 5,000 6,002 (1,002) Gravel 4,000 135 3,865 Maintenance - Traffic Signals 8,500 8,130 370 Maintenance - Equipment 5,000 4,543 457 Maintenance - Street Lights 12,000 11,129 871 Maintenance - Vehicles 15,000 15,903 (903) Maintenance - Storm Sewer 8,000 858 7,142 Contractual Services 2,000 2,296 (296) Engineering 500 - 500 Electricity 35,000 35,476 (476) Training & Conferences 2,000 1 1,999 Inspections and Licenses 100 82 18 Rental Equipment 500 169 331 Street Lighting 4,200 1,620 2,580 Sidewalk Construction 16,000 15,793 207 Operating Supplies 8,000 3,616 4,384 Gasoline 12,400 12,023 377 Hand Tools 1,000 497 503 Wearing Apparel 4,500 3,440 1,060 Safety Equipment 1,000 518 482 Maintenance Supplies - Streets 9,000 3,919 5,081 Cellular Phones 5,000 5,209 (209) Maintenance Supplies - Storm Sewer - 233 (233) Contingency 6,000 2,620 3,380 Walnut Street 141,000 141,653 (653) Crack Sealing 16,500 16,451 49 Public Infrastructure Engineering 57,000 50,435 6,565 40 EXHIBIT 4 (CONTINUED) UNITED CITY OF YORKVILLE, ILLINOIS GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET (BUDGETARY BASIS) AND ACTUAL For the Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) Fox & Kennedy Safety $ 4,000 $ 7,021 $ (3,021) Asphalt Pavement Rehab 30,000 28,481 1,519 Game Farm Traffic Signal - 366 (366) Rob Roy Creek Flood Study 55,000 53,221 1,779 Tree Stump Removal 12,000 9,650 2,350 Total Streets & Alley 577,700 540,457 37,243 Health & Sanitation Garbage Service 330,000 359,468 (29,468) Leaf Pickup 4,000 1,200 2,800 Total Health & Sanitation 334,000 360,668 (26,668) Building & Zoning Legal Services 4,500 3,078 1,422 Contractual Services 16,000 18,886 (2,886) Dues 200 120 80 Publishing/Advertising 4,000 2,360 1,640 Printing/Copying 700 415 285 Economic Development Costs 45,000 45,000 - Planning Consultant Fees 16,000 10,806 5,194 Operating Supplies 1,000 850 150 Books and Maps 500 150 350 Golf Course Study 6,125 6,319 (194) Transportation Study 10,000 5,158 4,842 Park Land Use Plan 17,225 17,225 - Downtown Study 5,600 5,600 - Total Building & Zoning 126,850 115,967 10,883 Total Streets & Sanitation 1,038,550 1,017,092 21,458 TOTAL EXPENDITURES $ 4,769,006 $ 4,592,859 $ 176,147 41 UNITED CITY OF YORKVILLE, ILLINOIS ALL SPECIAL REVENUE FUNDS COMBINING BALANCE SHEET APRIL 30, 2003 LIBRARY MOTOR FUEL RECREATION LAND SEWER FUND TAX FUND FUND CASH FUND MAINTENANCE FUND ASSETS Cash and Investments $ 189,799 $ 193,491 $ 96,782 $ 237,853 $ - Property Taxes Receivable 234,944 - - - - Accounts Receivable - 29,909 - - 66,178 Interfund Receivable - - - - 244,716 Other Assets - - 988 - - TOTAL ASSETS $ 424,743 $ 223,400 $ 97,770 $ 237,853 $ 310,894 LIABILITIES AND FUND BALANCE LIABILITIES Accounts Payable $ - $ 225 $ 1,211 $ - $ 20,090 Accrued Payroll 4,073 - 7,310 - 2,374 Interfund Payable 34,777 - 51,095 - 45,068 Other Liabilities - - 23,905 - - Deferred Revenue 234,944 - - - Compensated Absences - - 3,992 - 791 TOTAL LIABILITIES 273,794 225 87,513 - 68,323 FUND BALANCE Unrestricted 150,949 223,175 9,269 237,853 242,571 Reserved for Prepaid Items - - 988 - TOTAL FUND BALANCE 150,949 223,175 10,257 237,853 242,571 TOTAL LIABILITIES AND FUND BALANCE $ 424,743 $ 223,400 $ 97,770 $ 237,853 $ 310,894 42 EXHIBIT 5 PUBLIC RECREATION FOX LAND PARK EQUIPMENT WORKS EQUIPMENT POLICE EQUIPMENT PARKS EQUIPMENT INDUSTRIAL TOTAL ACQUISITION FUND CAPITAL FUND CAPITAL FUND CAPITAL FUND FUND CAPITAL FUND FUND CURRENT YEAR S 147,264 $ 33,703 $ 123,314 $ 6,051 $ 57,400 $ 7,797 $ 78,719 $ 1,172,173 - - - - - - 234,944 - - - - - - - 96,087 - - - - - - - 244,716 - - - - - - - 988 $ 147,264 $ 33,703 $ 123,314 $ 6,051 $ 57,400 $ 7,797 $ 78,719 $ 1,748,908 S - $ - $ - S - $ 1,302 $ - S - $ 22,828 7,148 - - 20,905 - - - - 25,638 - - 156,578 - - - - - - 23,905 - - - - - - - 234,944 - - - - 4,543 - - 9,326 - - - - 38,631 - - 468,486 147,264 33,703 123,314 6,051 18,769 7,797 78,719 1,279,434 - - - - - 988 147,264 33,703 123,314 6,051 18,769 7,797 78,719 1,280,422 S 147,264 $ 33,703 $ 123,314 $ 6,051 $ 57,400 $ 7,797 $ 78,719 $ 1,748,908 43 UNITED CITY OF YORKVILLE, ILLINOIS ALL SPECIAL REVENUE FUNDS STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Year Ended April 30, 2003 LIBRARY MOTOR FUEL RECREATION LAND SEWER FUND TAX FUND FUND CASH FUND MAINTENANCE FUND REVENUES Property Taxes $ 218,473 $ - $ - $ - $ - Motor Fuel Tax - 183,908 - - - Sewer Maintenance Fees - - - - 293,966 Licenses, Permits & Fees - - - 164,901 - Fines 2,200 - - - - Fees for Services 957 - 79,450 - - Deviation Fees - - - - - Investment Income 2,587 5,289 1,237 - 10,609 Other Revenue 48,498 - 49,661 - - Contributions 3,047 - - - - Connection Fees - - - 67,515 Grants 7,736 - - - - TOTAL REVENUES 283,498 189,197 130,348 164,901 372,090 EXPENDITURES Current: Streets & Sanitation - 216,991 - - - Culture & Recreation 281,819 - 353,187 - - Sewer Maintenance - - - - 161,203 Miscellaneous - - - 28,505 - Capital Outlay - - - - - Debt Service: Interest - - - - - TOTAL EXPENDITURES 281,819 216,991 353,187 28,505 161,203 Excess (deficiency) of revenues over expenditures 1,679 (27,794) (222,839) 136,396 210,887 OTHER FINANCING SOURCES (USES) Loan Proceeds - - - - - Operating Transfers In - - 172,772 - - Operating Transfers Out - (18,341) - (103,092) (123,490) TOTAL OTHER FINANCING SOURCES (USES) - (18,341) 172,772 (103,092) (123,490) Excess (deficiency) of revenues over expenditures and other sources (uses) 1,679 (46,135) (50,067) 33,304 87,397 Fund Balances at beginning of year 149,270 269,310 60,324 204,549 155,174 Fund Balances at end of year $ 150,949 $ 223,175 $ 10,257 $ 237,853 $ 242,571 44 • EXHIBIT 6 PUBLIC RECREATION FOX LAND PARK EQUIPMENT WORKS EQUIPMENT POLICE EQUIPMENT PARKS EQUIPMENT INDUSTRIAL TOTAL ACQUISITION FUND CAPITAL FUND CAPITAL FUND CAPITAL FUND FUND CAPITAL FUND FUND CURRENT YEAR $ - $ - $ - $ - $ - $ - $ 10,599 $ 229,072 - - - - - - 183,908 - - - - - - - 293,966 - - - - - - - 164,901 - - - - - - - 2,200 - - - 45,450 - - - 125,857 - - 134,550 - - - - 134,550 - - - - - - 4,719 24,441 - - 33,800 - - - - 131,959 - - - 3,475 2,100 - - 8,622 - - - - - - - 67,515 - - - - - - - 7,736 - - 168,350 48,925 2,100 - 15,318 1,374,727 - - - - - - 551,727 768,718 - - - - 268,276 - - 903,282 - - - - - - 161,203 15,745 - - - - - - 44,250 13,534 168,231 123,349 - 500 - 305,614 - - - - - - 31,238 31,238 15,745 13,534 168,231 123,349 268,276 500 582,965 2,214,305 (15,745) (13,534) 119 (74,424) (266,176) (500) (567,647) (839,578) - - 94,306 - - - 94,306 88,872 17,220 60,000 13,850 260,183 - 646,366 1,259,263 - - (38,929) (3,000) - - (286,852) 88,872 17,220 60,000 69,227 257,183 - 646,366 1,066,717 73,127 3,686 60,119 (5,197) (8,993) (500) 78,719 227,139 74,137 30,017 63,195 11,248 27,762 8,297 - 1,053,283 $ 147,264 $ 33,703 $ 123,314 $ 6,051 $ 18,769 $ 7,797 $ 78,719 $ 1,280,422 45 EXHIBIT 7 UNITED CITY OF YORKVILLE, ILLINOIS LIBRARY FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Property Taxes Real Estate Taxes $ 216,645 $ 215,430 $ (1,215) Personal Property Replacement Taxes 2,000 3,043 1,043 Total Property Taxes 218,645 218,473 (172) Fines Library Fines 2,000 2,200 200 Fees for Services Photocopier 900 957 57 Investment Income 1,500 2,587 1,087 Other Revenue Sales of Books 500 896 396 Rental Income 1,000 752 (248) Subscription Cards 5,000 7,700 2,700 Developer Fees 15,000 19,575 4,575 Development Fees - Books 15,000 19,575 4,575 Total Other Revenue 36,500 48,498 11,998 Contributions Memorials 1,000 3,047 2,047 Grants Library Per Capita Grant 7,000 7,736 736 Carry Over 29,386 - (29,386) TOTAL REVENUES 296,931 283,498 (13,433) EXPENDITURES Culture & Recreation Employee Salaries 135,000 146,257 (11,257) Books - Development Fees 15,000 19,264 (4,264) Building Expansion 9,000 8,260 740 Social Security Tax 10,125 9,265 860 City Share - IMRF 4,300 4,156 144 Health Insurance 14,142 13,780 362 Group Life 100 - 100 Vision and Dental Assistance 2,200 1,798 402 Bonding 1,400 1,014 386 Maintenance 4,000 158 3,842 Maintenance - Copier 3,000 2,370 630 Training & Conference 500 510 (10) Publishing/Advertising 300 224 76 Subscriptions 2,300 1,864 436 Telephone 1,700 1,679 21 Attorney 1,500 - 1,500 Postage/Shipping 900 693 207 46 EXHIBIT 7 (CONTINUED) UNITED CITY OF YORKVILLE, ILLINOIS LIBRARY FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) Electricity $ 2,500 $ 1,562 $ 938 Library Supplies 5,500 4,455 1,045 Custodial Supplies 3,500 2,596 904 Photocopier 2,000 718 1,282 Library Programming 6,500 4,621 1,879 Memorials and Gifts 1,000 2,904 (1,904) Public Relations 600 206 394 Library Board 250 49 201 Developer Fees 15,000 8,340 6,660 Contingency 2,314 737 1,577 Automation 17,000 9,566 7,434 Computer 8 Software 3,000 2,948 52 Mileage - Library 500 363 137 Employee Recognition 1,000 844 156 Alarm Monitoring 800 854 (54) Books - Adult 9,000 8,385 615 Books - Juvenile 8,500 8,467 33 Books - Audio 3,500 3,470 30 Books - Reference 8,000 8,577 (577) Videos 1,000 865 135 TOTAL EXPENDITURES 296,931 281,819 15,112 Excess (deficiency) of revenues over expenditures $ - 1,679 $ 1,679 Fund Balance at beginning of year 149,270 Fund Balance at end of year $ 150,949 47 EXHIBIT 8 UNITED CITY OF YORKVILLE, ILLINOIS MOTOR FUEL TAX FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Motor Fuel Tax $ 180,000 $ 183,908 $ 3,908 Investment Income 7,000 5,289 (1,711) Other Revenue 120,000 - (120,000) Grants 6,000 - (6,000) Carry Over 40,081 40,081 - TOTAL REVENUES 353,081 229,278 (123,803) EXPENDITURES Streets & Sanitation PW Materials 35,000 33,035 1,965 Other 10,000 - 10,000 Engineering 15,000 5,923 9,077 Rt34/Game Farm Signal 131,000 130,403 597 IDOT Rt34 Improvements 44,000 12,751 31,249 Signs 9,000 5,290 3,710 Grant - IDOT 6,000 - 6,000 Reserve 84,740 29,589 55,151 TOTAL EXPENDITURES 334,740 216,991 117,749 Excess (deficiency) of revenues over expenditures 18,341 12,287 (6,054) OTHER FINANCING SOURCES (USES) Operating Transfers Out (18,341) (18,341) - TOTAL OTHER FINANCING SOURCES (USES) (18,341) (18,341) - Excess (deficiency) of revenues over expenditures and other sources (uses) $ - (6,054) $ (6,054) Fund Balance at beginning of year 269,310 Budgeted Carry Over Expended (40,081) Fund Balance at end of year S 223,175 48 EXHIBIT 9 UNITED CITY OF YORKVILLE, ILLINOIS RECREATION FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Fees for Services Fees for Programs $ 62,000 $ 72,014 $ 10,014 Trips - Days 500 (84) (584) Youth Activities 8,500 5,078 (3,422) Skate Park Revenue 2,394 2,442 48 Total Fees for Services 73,394 79,450 6,056 Investment Income 1,500 1,237 (263) Other Revenue Rental Income 400 85 (315) Donations 18,500 14,990 (3,510) Concessions 2,258 2,308 50 Miscellaneous Income 200 - (200) Vending Machine Income 250 440 190 Golf Outing 15,797 15,797 - Safety Town Building Project 3,300 3,300 - Youth Special Events 3,750 3,750 - Beecher Expense 5,000 8,526 3,526 Farmer's Market Revenue 445 465 20 Total Other Revenue 49,900 49,661 (239) Carry Over 1,400 1,400 - TOTAL REVENUES 126,194 131,748 5,554 EXPENDITURES Culture & Recreation Custodial Salary 16,560 21,277 (4,717) Director Salary 16,962 25,553 (8,591) Program Supervisor Salary 22,240 30,247 (8,007) Instructor Salaries 24,000 38,875 (14,875) Superintendent Salary 47,271 59,973 (12,702) Social Security Tax 10,200 15,000 (4,800) City Share - IMRF 5,800 12,178 (6,378) Youth Services Grant 3,000 3,359 (359) Skate Park Revenue 7,379 7,762 (383) Maintenance 6,000 5,169 831 Maintenance - Equipment 2,000 2,095 (95) Maintenance - Vehicles 400 573 (173) Dues 600 - 600 Travel Expenses 900 443 457 Publishing/Advertising 8,000 7,904 96 Subscriptions 2,000 1,644 356 Mileage 250 32 218 Rental - Buildings 3,000 1,480 1,520 Postage/Shipping 5,000 4,898 102 Telephone 2,200 900 1,300 Cellular Phones 3,640 3,443 197 Portable Toilets 4,200 1,962 2,238 49 EXHIBIT 9 (CONTINUED) UNITED CITY OF YORKVILLE, ILLINOIS RECREATION FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) Office Supplies $ 6,000 $ 5,695 $ 305 Program Supplies 15,000 14,526 474 Gasoline 600 660 (60) School Facility Usage 5,000 5,000 Comm. Survey 6,744 6,744 - Research 4,000 3,921 79 Concessions 2,531 505 2,026 Secretarial Salaries 26,917 34,002 (7,085) Recording Secretary 1,440 1,294 146 Day Trip Expenses 500 22 478 Miscellaneous 500 50 450 Golf Outing 11,315 12,134 (819) Contingency 8,917 8,917 - Beecher Expense 5,000 4,238 762 Books and Publications 500 - 500 Youth/Special Events 7,000 7,284 (284) Rec. Software 1,000 1,034 (34) Safety Town Bldg Project Expenditures 1,400 - 1,400 Recreation Equipment 3,000 2,394 606 TOTAL EXPENDITURES 298,966 353,187 (54,221) Excess (deficiency) of revenues over expenditures (172,772) (221,439) (48,667) OTHER FINANCING SOURCES (USES) Operating Transfers In 172,772 172,772 - TOTAL OTHER FINANCING SOURCES (USES) 172,772 172,772 - Excess (deficiency) of revenues over expenditures and other sources (uses) $ - (48,667) $ (48,667) Fund Balance at beginning of year 60,324 Budgeted Carry Over Expended (1,400) Fund Balance at end of year $ 10,257 50 EXHIBIT 10 UNITED CITY OF YORKVILLE, ILLINOIS LAND CASH FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Licenses, Permits & Fees Land Cash - Fox Hill $ - S 1,706 $ 1,706 Land Cash - Cannonball Hill - 14,751 14,751 Land Cash - Wildwood 2,452 2,754 302 Land Cash - Country Hill 7,690 8,459 769 Land Cash - Greenbriar 12,852 12,852 - Land Cash - White Oak 2,812 9,662 6,850 Land Cash - Cimnaron Ridge - 1,786 1,786 Land Cash - Woodworth - 3,213 3,213 Land Cash - Fox Highlands 14,788 17,600 2,812 Land Cash - Sunflower 14,440 6,859 (7,581) Land Cash - Klyn's Crossing 23,550 14,915 (8,635) Land Cash - Countryside #9 1,840 1,840 - Land Cash - Rivers Edge 40,260 26,292 (13,968) Land Cash - Foxfield - 1,688 1,688 Land Cash - Heartland 40,000 22,569 (17,431) Land Cash - Prairie Garden 18,900 17,955 (945) TOTAL REVENUES 179,584 164,901 (14,683) EXPENDITURES Miscellaneous Reserve 22,204 8,996 13,208 Purcell Park Expense 500 - 500 Cobb park Expense 500 - 500 Beecher Expense 3,500 - 3,500 Prairie Expense 500 - 500 Riverfront Park Expense 14,500 21 14,479 Town Square Park Expense 1,200 - 1,200 Greenbrior Expense 3,500 - 3,500 Fox Hill Expense 1,700 - 1,700 Other Park Expense 3,000 - 3,000 Van Enmon Expense 5,900 - 5,900 Heartland Expense 19,488 19,488 - TOTAL EXPENDITURES 76,492 28,505 47,987 Excess (deficiency) of revenues over expenditures 103,092 136,396 33,304 OTHER FINANCING SOURCES (USES) Operating Transfers Out (103,092) (103,092) - TOTAL OTHER FINANCING SOURCES (USES) (103,092) (103,092) - Excess (deficiency) of revenues over expenditures and other sources (uses) $ - 33,304 $ 33,304 Fund Balance at beginning of year 204,549 Fund Balance at end of year $ 237,853 51 EXHIBIT 11 UNITED CITY OF YORKVILLE, ILLINOIS SEWER MAINTENANCE FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Sewer Maintenance Fees $ 335,000 $ 293,966 $ (41,034) Investment Income 10,000 10,609 609 Connection Fees 65,000 67,515 2,515 Carry Over 69,892 - (69,892) TOTAL REVENUES 479,892 372,090 (107,802) EXPENDITURES Sewer Maintenance Employee Salaries 78,000 77,031 969 Overtime 4,500 4,373 127 Sewer Chemicals 5,500 5,277 223 Social Security Tax 7,000 6,270 730 City Share - IMRF 6,000 7,590 (1,590) Legal (Filing) Fees 200 - 200 Maintenance - Sanitary Sewer 11,000 11,075 (75) Maintenance - Equipment 8,500 1,110 7,390 Training & Conference 1,000 - 1,000 Printing/Copying 2,000 1,980 20 Rental Equipment 1,000 - 1,000 Electricity 1,000 1,000 - Cellular Phones 4,000 5,248 (1,248) Miscellaneous 2,000 520 1,480 Office Supplies 400 489 (89) Operating Supplies 9,300 9,558 (258) Gasoline 4,000 4,450 (450) Hand Tools 550 137 413 Wearing Apparel 3,500 2,058 1,442 Lift Station Maintenance 5,000 4,132 868 Safety Equipment 1,000 - 1,000 Contingency 8,000 5,349 2,651 Computer & Software 1,000 - 1,000 Reserve 187,934 12,660 175,274 Gravel 1,000 562 438 Shop Supplies 1,000 334 666 Enclosed Trailer 2,000 - 2,000 TOTAL EXPENDITURES 356,384 161,203 195,181 Excess (deficiency) of revenues over expenditures 123,508 210,887 87,379 OTHER FINANCING SOURCES (USES) Operating Transfers Out (123,478) (123,490) (12) TOTAL OTHER FINANCING SOURCES (USES) (123,478) (123,490) (12) Excess (deficiency) of revenues over expenditures and other sources (uses) $ 30 87,397 $ 87,367 Fund Balance at beginning of year 155,174 Fund Balance at end of year $ 242,571 52 EXHIBIT 12 UNITED CITY OF YORKVILLE, ILLINOIS LAND ACQUISITION FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES $ - $ - $ - EXPENDITURES Miscellaneous 88,872 15,745 73,127 TOTAL EXPENDITURES 88,872 15,745 73,127 Excess (deficiency) of revenues over expenditures (88,872) (15,745) 73,127 OTHER FINANCING SOURCES (USES) Operating Transfers In 88,872 88,872 - TOTAL OTHER FINANCING SOURCES (USES) 88,872 88,872 - Excess (deficiency) of revenues over expenditures and other sources (uses) $ - 73,127 $ 73,127 Fund Balance at beginning of year 74,137 Fund Balance at end of year $ 147,264 • 53 EXHIBIT 13 UNITED CITY OF YORKVILLE, ILLINOIS PARK EQUIPMENT CAPITAL FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Carry Over S 18,752 $ - $ (18,752) TOTAL REVENUES 18,752 - (18,752) EXPENDITURES Capital Outlay Park Equipment 35,972 13,534 22,438 TOTAL EXPENDITURES 35,972 13,534 22,438 Excess (deficiency) of revenues over expenditures (17,220) (13,534) 3,686 OTHER FINANCING SOURCES (USES) Operating Transfers In 17,220 17,220 - TOTAL OTHER FINANCING SOURCES (USES) 17,220 17,220 - Excess (deficiency) of revenues over expenditures and other sources (uses) S - 3,686 $ 3,686 Fund Balance at beginning of year 30,017 Fund Balance at end of year S 33,703 54 EXHIBIT 14 UNITED CITY OF YORKVILLE, ILLINOIS PUBLIC WORKS EQUIPMENT CAPITAL FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Deviation Fees $ 124,000 $ 134,550 $ 10,550 Other Revenue 33,800 33,800 - Carry Over 63,195 - (63,195) TOTAL REVENUES 220,995 168,350 (52,645) EXPENDITURES Capital Outlay Streets & Alley Tools 4,000 1,358 2,642 Sewer Camera 10,000 7,695 2,305 Street Light Indicator 2,000 1,709 291 Skidsteer/Snowblower 15,100 15,022 78 Public Works Equipment Air Compressor 2,000 1,999 1 I Ton Dump Truck 36,252 36,252 - Truck Accessories 8,000 4,551 3,449 Power Saw Bander 500 500 - 5 YD Dump Truck 72,246 72,246 - Enclosed Trailer 2,000 - 2,000 Bobcat Exchange 3,500 3,500 - Floor Jacks & Stands 1,000 - 1,000 Hydraulic Trench Shoring 20,000 - 20,000 Pick-Up Truck - PW Director 23,399 23,399 - Future Building 75,998 - 75,998 Tarps for Dump Truck 5,000 - 5,000 TOTAL EXPENDITURES 280,995 168,231 112,764 Excess (deficiency) of revenues over expenditures (60,000) 119 60,119 OTHER FINANCING SOURCES (USES) Operating Transfers In 60,000 60,000 - TOTAL OTHER FINANCING SOURCES (USES) 60,000 60,000 - Excess (deficiency) of revenues over expenditures and other sources (uses) $ - 60,119 $ 60,119 Fund Balance at beginning of year 63,195 Fund Balance at end of year $ 123,314 55 EXHIBIT 15 UNITED CITY OF YORKVILLE, ILLINOIS POLICE EQUIPMENT CAPITAL FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Fees for Services Police Development Fees S 45,000 $ 45,450 $ 450 Other Revenue Sale of Assets 1,000 - (1,000) Contributions Miscellaneous Income - 375 375 K-9 Donations 500 595 95 In-car Video Donations 2,500 2,505 5 Total Contributions 3,000 3,475 475 Carry Over 11,248 5,197 (6,051) TOTAL REVENUES 60,248 54,122 (6,126) EXPENDITURES Capital Outlay Police Equipment Equipment - Police 5,400 5,105 295 Vehicles - Police 94,306 92,969 1,337 Reserve 7,579 2,324 5,255 Speed Trailer 22,190 22,951 (761) TOTAL EXPENDITURES 129,475 123,349 6,126 Excess (deficiency) of revenues over expenditures (69,227) (69,227) - OTHER FINANCING SOURCES (USES) Loan Proceeds 94,306 94,306 - Operating Transfers In 13,850 13,850 - Operating Transfers Out (38,929) (38,929) - TOTAL OTHER FINANCING SOURCES (USES) 69,227 69,227 - Excess (deficiency) of revenues over expenditures and other sources (uses) S - - $ - Fund Balance at beginning of year 11,248 Budgeted Carry Over Expended (5,197) Fund Balance at end of year S 6,051 56 EXHIBIT 16 UNITED CITY OF YORKVILLE, ILLINOIS PARKS FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Contributions Tree Donations $ 1,200 $ 2,100 $ 900 Grants Illinois First Grant 100,000 - (100,000) TOTAL REVENUES 101,200 2,100 (99,100) EXPENDITURES Culture & Recreation Park Operations IL First Grant 100,000 - 100,000 Maintenance - Equipment 4,000 4,167 (167) Training & Conferences 1,000 1,170 (170) Subscriptions 300 186 114 Rental Equipment 500 1,163 (663) Office Supplies 500 356 144 Operating Supplies 5,000 5,742 (742) Gasoline 3,000 - 3,000 Hand Tools 500 498 2 Wearing Apparel 4,500 3,828 672 Cellular Phones 3,500 748 2,752 Contingency 1,351 1,350 1 Office Equipment 1,600 1,461 139 Maintenance - Parks 15,000 20,025 (5,025) Public Improvement 1,000 1,019 (19) Park Contractual 7,500 7,954 (454) Flowers/Trees 3,200 3,984 (784) Christmas Decorations 3,500 3,500 - Travel Expenses 300 - 300 Comprehensive Plan 9,250 9,735 (485) Total Park Operations 165,501 66,886 98,615 Parks Salaries Overtime 15,700 15,450 250 Employee Salary - Part-Time 15,000 9,597 5,403 Social Security Tax 10,500 13,146 (2,646) City Share - IMRF 7,500 11,109 (3,609) Director Salaries 16,962 19,224 (2,262) Park Salaries 127,220 132,864 (5,644) Total Parks Salaries 192,882 201,390 (8,508) Total Culture & Recreation 358,383 268,276 90,107 TOTAL EXPENDITURES 358,383 268,276 90,107 57 EXHIBIT 16 (CONTINUED) UNITED CITY OF YORKVILLE, ILLINOIS PARKS FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) Excess (deficiency) of revenues over expenditures S (257,183) $ (266,176) $ (8,993) OTHER FINANCING SOURCES (USES) Operating Transfers In 260,183 260,183 - Operating Transfers Out (3,000) (3,000) - TOTAL OTHER FINANCING SOURCES (USES) 257,183 257,183 - Excess (deficiency) of revenues over expenditures and other sources (uses) S - (8,993) $ (8,993) Fund Balance at beginning of year 27,762 Fund Balance at end of year S 18,769 58 • EXHIBIT 17 UNITED CITY OF YORKVILLE, ILLINOIS RECREATION EQUIPMENT CAPITAL FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 EQUIPMENT CAPITAL FUND Variance Favorable Budget Actual (Unfavorable) REVENUES S - $ - $ EXPENDITURES Capital Outlay Recreation Equipment Photocopier - 500 (500) TOTAL EXPENDITURES - 500 (500) Excess (deficiency) of revenues over expenditures S - (500) $ (500) Fund Balance at beginning of year 8,297 Fund Balance at end of year S 7,797 59 111114. 4 EXHIBIT 18 UNITED CITY OF YORKVILLE, ILLINOIS FOX INDUSTRIAL FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Property Taxes $ 9,800 $ 10,599 $ 799 Investment Income 4,500 4,719 219 TOTAL REVENUES 14,300 15,318 1,018 EXPENDITURES Streets & Sanitation Fox Industrial Park 619,466 527,164 92,302 Fox Industrial - Non MFT 20,000 24,563 (4,563) Other 200 - 200 Legal (Filing) Fees 2,000 - 2,000 Total Streets & Sanitation 641,666 551,727 89,939 Debt Service: Interest 19,000 31,238 (12,238) TOTAL EXPENDITURES 660,666 582,965 77,701 Excess (deficiency) of revenues over expenditures (646,366) (567,647) 78,719 OTHER FINANCING SOURCES (USES) Operating Transfers In 646,366 646,366 - TOTAL OTHER FINANCING SOURCES (USES) 646,366 646,366 - Excess (deficiency) of revenues over expenditures and other sources (uses) $ - 78,719 $ 78,719 Fund Balance at beginning of year - Fund Balance at end of year $ 78,719 60 EXHIBIT 19 UNITED CITY OF YORKVILLE, ILLINOIS CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET APRIL 30, 2003 SANITARY MUNICIPAL IMPROVEMENT WATER IMPROVEMENT SOUTH TOTAL BUILDING FUND EXPANSION FUND EXPANSION FUND SEWER FUND CURRENT YEAR ASSETS Cash and Investments $ 72,040 $ 1,021,978 $ 2,345,479 $ 10,674 $ 3,450,171 TOTAL ASSETS $ 72,040 $ 1,021,978 $ 2,345,479 $ 10,674 $ 3,450,171 LIABILITIES AND FUND BALANCE LIABILITIES Accounts Payable $ 22,565 $ 15,687 $ 277,615 $ - $ 315,867 TOTAL LIABILITIES 22,565 15,687 277,615 - 315,867 FUND BALANCE Unrestricted 49,475 1,006,291 2,067,864 10,674 3,134,304 TOTAL FUND BALANCE 49,475 1,006,291 2,067,864 10,674 3,134,304 TOTAL LIABILITIES AND FUND BALANCE $ 72,040 $ 1,021,978 $ 2,345,479 $ 10,674 $ 3,450,171 61 EXHIBIT 20 UNITED CITY OF YORKVILLE, ILLINOIS CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Year Ended April 30, 2003 SANITARY MUNICIPAL IMPROVEMENT WATER IMPROVEMENT SOUTH TOTAL BUILDING FUND EXPANSION FUND EXPANSION FUND SEWER FUND CURRENT YEAR REVENUES Licenses, Permits & Fees $ 54,300 $ 16,166 $ - S - $ 70,466 Investment Income - - 17,139 - 17,139 Other Revenue - - 10,139 - 10,139 Connection Fees - 640,436 287,475 - 927,911 TOTAL REVENUES 54,300 656,602 314,753 - 1,025,655 EXPENDITURES Current: General Government 142,919 - - - 142,919 Streets & Sanitation - 159,550 709,043 - 868,593 TOTAL EXPENDITURES 142,919 159,550 709,043 - 1,011,512 Excess (deficiency) of revenues over expenditures (88,619) 497,052 (394,290) - 14,143 OTHER FINANCING SOURCES (USES) Proceeds from Debt Certificates Sold - - 2,899,365 - 2,899,365 Operating Transfers In 36,375 183,500 71,317 - 291,192 Operating Transfers Out - (367,246) (488,749) - (855,995) TOTAL OTHER FINANCING SOURCES (USES) 36,375 (183,746) 2,481,933 - 2,334,562 Excess (deficiency) of revenues over expenditures and other sources (uses) (52,244) 313,306 2,087,643 - 2,348,705 . Fund Balances at beginning of year 101,719 692,985 (19,779) 10,674 785,599 Fund Balances at end of year $ 49,475 $ 1,006,291 $ 2,067,864 $ 10,674 $ 3,134,304 62 EXHIBIT 21 UNITED CITY OF YORKVILLE, ILLINOIS MUNICIPAL BUILDING FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Licenses, Permits & Fees Building Development Fee $ 55,000 $ 54,300 $ (700) Carry Over 15,525 15,525 - TOTAL REVENUES 70,525 69,825 (700) EXPENDITURES General Government Architect 67,000 75,088 (8,088) Municipal Building 10,000 9,022 978 Reserve - 1,055 (1,055) PW Building Exp. - Tower 2,000 2,618 (618) Building Improvement - Beecher 5,000 4,248 752 Building Improvement - Parks 1,100 10,014 (8,914) Building Improvement - Library 3,000 1,857 1,143 Building Improvement - Riverfront 7,500 28,543 (21,043) Building Improvement - City Hall 6,000 5,974 26 General Maintenance 5,300 4,500 800 TOTAL EXPENDITURES 106,900 142,919 (36,019) Excess (deficiency) of revenues over expenditures (36,375) (73,094) (36,719) OTHER FINANCING SOURCES (USES) Operating Transfers In 36,375 36,375 - TOTAL OTHER FINANCING SOURCES (USES) 36,375 36,375 - Excess (deficiency) of revenues over expenditures and other sources (uses) S - (36,719) $ (36,719) Fund Balance at beginning of year 101,719 Budgeted Cary Over Expended (15,525) Fund Balance at end of year $ 49,475 63 EXHIBIT 22 UNITED CITY OF YORKVILLE, ILLINOIS SANITARY IMPROVEMENT EXPANSION FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Licenses, Permits & Fees River Crossing Fees $ 14,000 $ 16,166 $ 2,166 Connection Fees 610,000 640,436 30,436 Carry Over 418,211 - (418,211) TOTAL REVENUES 1,042,211 656,602 (385,609) EXPENDITURES Streets & Sanitation Engineering 200,000 54,127 145,873 Reserve 548,465 17,922 530,543 Contractual Services 20,000 11,736 8,264 Blackberry Creek Envir. Study 45,000 60,761 (15,761) Lift Station 20,000 2,701 17,299 Rob Creek Sanitary 25,000 12,303 12,697 TOTAL EXPENDITURES 858,465 159,550 698,915 Excess (deficiency) of revenues over expenditures 183,746 497,052 313,306 OTHER FINANCING SOURCES (USES) Operating Transfers In 183,500 183,500 - Operating Transfers Out (367,246) (367,246) - TOTAL OTHER FINANCING SOURCES (USES) (183,746) (183,746) - Excess (deficiency) of revenues over expenditures and other sources (uses) $ - 313,306 $ 313,306 Fund Balance at beginning of year 692,985 Fund Balance at end of year $ 1,006,291 64 EXHIBIT 23 UNITED CITY OF YORKVILLE, ILLINOIS WATER IMPROVEMENT EXPANSION FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) REVENUES Investment Income S 12,500 $ 17,139 $ 4,639 Other Revenue - 10,139 10,139 Connection Fees 280,000 287,475 7,475 Grants 950,000 - (950,000) TOTAL REVENUES 1,242,500 314,753 (927,747) EXPENDITURES Streets & Sanitation Engineering 5,000 18,474 (13,474) Maintenance - Water Tower 2,780,556 - 2,780,556 Legal Services 25,000 18,158 6,842 Reserve 731,463 194,917 536,546 Water Studies 15,000 14,962 38 Radium Engineering 250,000 316,416 (66,416) Debt Certificate Expenses 27,307 146,116 (118,809) TOTAL EXPENDITURES 3,834,326 709,043 3,125,283 Excess (deficiency) of revenues over expenditures (2,591,826) (394,290) 2,197,536 OTHER FINANCING SOURCES (USES) Proceeds from Debt Certificates Sold 2,780,556 2,899,365 118,809 Operating Transfers In 71,317 71,317 - Operating Transfers Out (260,047) (488,749) (228,702) TOTAL OTHER FINANCING SOURCES (USES) 2,591,826 2,481,933 (109,893) Excess (deficiency) of revenues over expenditures and other sources (uses) S - 2,087,643 $ 2,087,643 Fund Balance at beginning of year (19,779) Fund Balance at end of year S 2,067,864 65 y EXHIBIT 24 UNITED CITY OF YORKVILLE, ILLINOIS WATER OPERATING FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) OPERATING REVENUES Other Revenue Water Meters $ 100,000 $ 107,010 $ 7,010 Water Fees Water Sales 875,000 929,362 54,362 Bulk Water Sales 2,000 3,550 1,550 Total Water Fees 877,000 932,912 55,912 Carry Over 303,675 - (303,675) Total operating revenues 1,280,675 1,039,922 (240,753) OPERATING EXPENSES Cost of Sales & Services Employee Salaries 100,000 107,241 (7,241) Overtime 24,350 21,525 2,825 Salaries - Part-Time 3,500 3,435 65 Social Security Tax 13,136 11,937 1,199 City Share - IMRF 10,934 9,936 998 Maintenance - Computers 2,600 2,541 59 Maintenance - Equipment 4,000 2,262 1,738 Maintenance - Control System 4,000 940 3,060 Meter Reading Services 9,600 15,685 (6,085) Engineering 1,000 142 858 Electricity 83,000 88,130 (5,130) Cathodic Protection 950 - 950 Water Samples 18,000 17,127 873 Operating Supplies 41,300 45,699 (4,399) Gasoline 5,000 4,582 418 Hand Tools 1,200 803 397 Wearing Apparel 4,500 1,402 3,098 Safety Equipment 8,000 1,182 6,818 Rental Equipment 1,000 584 416 Secretarial Salaries 31,485 34,016 (2,531) Chlorine 3,700 1,477 2,223 Fluoride 1,800 1,112 688 Meters & Parts 115,000 119,266 (4,266) Refunds 2,000 1,730 270 Reserve 453,492 - 453,492 Hydrant Replacements 3,300 3,276 24 Gravel 5,000 3,089 1,911 H2O Maintenance Project/Engineering 46,151 - 46,151 Total Cost of Sales & Services 997,998 499,119 498,879 Administration Legal (Filing) Fees 3,500 8,021 (4,521) Contractual Services 4,000 2,437 1,563 Dues 750 721 29 Training & Conference 3,600 3,366 234 66 EXHIBIT 24 (CONTINUED) UNITED CITY OF YORKVILLE, ILLINOIS WATER OPERATING FUND STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS BUDGET (BUDGETARY BASIS) AND ACTUAL For The Year Ended April 30, 2003 Variance Favorable Budget Actual (Unfavorable) Travel Expenses S 2,000 $ 2,343 $ (343) Publishing/Advertising 1,550 742 808 Printing/Copying 2,500 4,448 (1,948) Subscriptions 250 194 56 Postage/Shipping 10,000 10,874 (874) Telephone 15,500 17,083 (1,583) Cellular Phones 6,000 6,258 (258) JULIE Service 4,500 3,950 550 Contingency 9,250 5,220 4,030 Computer & Software 3,100 - 3,100 Accounting System Review 25,000 25,000 - Total Administration 91,500 90,657 843 Total operating expenses 1,089,498 589,776 499,722 Operating income 191,177 450,146 258,969 NONOPERATING REVENUES (EXPENSES) Investment Income 14,000 10,360 (3,640) Other Revenue 500 - (500) Total Nonoperating revenues (expenses) 14,500 10,360 (4,140) Income before operating transfers 205,677 460,506 254,829 OPERATING TRANSFERS Operating Transfers In - 228,702 228,702 Operating Transfers Out (205,677) (205,677) - Total operating transfers (205,677) 23,025 228,702 Net Income S - 483,531 $ 483,531 Retained Earnings at beginning of year 1,428,776 Retained Earnings at end of year S 1,912,307 67 h. EXHIBIT 25 UNITED CITY OF YORKVILLE, ILLINOIS FIDUCIARY FUNDS COMBINING BALANCE SHEET APRIL 30. 2003 NONEXPENDABLE PENSION TRUST FUND AGENCY FUND TRUST FUND WORKING COLLECTION POLICE TOTAL CASH FUND FUND PENSION FUND CURRENT YEAR ASSETS Cash and Investments $ 113,433 $ - $ 517,894 $ 631,327 Accounts Receivable - 437,870 - 437,870 TOTAL ASSETS $ 113,433 $ 437,870 $ 517,894 $ 1,069,197 LIABILITIES AND FUND BALANCE LIABILITIES Accounts Payable $ - $ 57,209 $ - $ 57,209 lnterfund Payable - 380,661 - 380,661 TOTAL LIABILITIES - 437,870 - 437,870 FUND BALANCE Unrestricted 113,433 - - 113,433 Reserved for Pension Benefits - - 517,894 517,894 TOTAL FUND BALANCE 113,433 - 517,894 631,327 TOTAL LIABILITIES AND FUND BALANCE $ 113,433 $ 437,870 $ 517,894 $ 1,069,197 68 EXHIBIT 26 UNITED CITY OF YORKVILLE, ILLINOIS NON-EXPENDABLE TRUST FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE For the Year Ended April 30, 2003 OPERATING REVENUES S - OPERATING EXPENSES - Net Income - Fund Balance at beginning of year 111,569 Fund Balance at end of year S 111,569 69 EXHIBIT 27 UNITED CITY OF YORKVILLE, ILLINOIS STATEMENT OF CHANGES IN ASSETS AND LIABILITIES - AGENCY FUND FOR THE YEAR ENDED APRIL 30, 2003 Balance Balance May 1, April 30, COLLECTION FUND 2002 Additions Deductions 2003 Assets Cash $ - $ 1,356,586 $ 1,356,586 $ - Accounts Receivable- Customers 541,690 1,356,586 1,460,406 437,870 Total Assets $ 541,690 $ 2,713,172 $ 2,816,992 $ 437,870 Liabilities Due to Other Funds $ 431,615 $ 1,353,947 $ 1,404,901 $ 380,661 Accounts Payable 110,075 1,359,225 1,412,091 57,209 Total Liabilities $ 541,690 $ 2,713,172 $ 2,816,992 $ 437,870 70 I r SCHEDULE 1 UNITED CITY OF YORKVILLE, ILLINOIS SCHEDULE OF ASSESSED VALUATIONS,TAX RATES, TAX EXTENSIONS AND TAX COLLECTIONS APRIL 30, 2003 Tax Years 2002 2001 2000 1999 1998 1997 Assessed Valuations Farm $ 700,520 $ 815,985 $ 768,854 $ 692,281 $ 636,939 $ 780,379 Real Estate Lots 164,461,506 134,511,183 116,881,878 109,711,442 104,124,981 98,573,017 Railroads 12,718 10,966 12,995 8,345 6,702 29,977 Total Assessed Valuations $165,174,744 $135,338,134 $117,663,727 $110,412,068 $104,768,622 $ 99,383,373 Tax Rates General Fund: General Corporate 0.1990 0.2205 0.3155 0.2893 0.2964 0.3070 Garbage 0.1151 0.1211 0.1411 0.1504 0.1498 0.1523 Police Protection 0.0713 0.0750 0.0750 0.0748 0.0742 0.0750 Crossing Guard 0.0034 0.0035 0.0036 0.0037 0.0045 0.0045 Illinois Municipal Retirement Fund and Social Security 0.1462 0.1451 0.1961 0.2208 0.2195 0.2128 Liability Insurance 0.0613 0.0520 0.0551 0.0662 0.0514 0.0524 Audit 0.0113 0.0119 0.0128 0.0150 0.0158 0.0187 Unemployment Tax 0.0089 0.0093 0.01.15 0.0118 0.0125 0.0091 Police Pension 0.1083 0.1302 - - - - Total General Fund 0.7248 0.7686 0.8107 0.8320 0.8241 0.8318 Library Fund 0.1426 0.1600 0.1606 0.1497 0.1565 0.1591 Total Tax Rates 0.8674 0.9286 0.9713 0.9817 0.9806 0.9909 Tax Extensions General Fund $ 1,194,170 $ 1,039,162 $ 953,902 $ 918,630 $ 864,401 $ 826,674 Library Fund 234,944 216,323 188,967 165,287 162,962 158,117 Total Tax Extensions $ 1,429,114 $ 1,255,485 $ 1,142,869 $ 1,083,917 $ 1,027,363 $ 984,791 TaLColltaiims_-_Allfunsis Collected to April 30,2003 $ 1,251,975 $ 1,144,706 $ 1,087,4.44 $ 1,021,520 $ 984,831 (Cash Basis) Percentage of Extensions Collected 99.72% 100.16% 100.33% 99.43% 100.00% 71 --- - MUNICIPAL LEAGUE f Risk Management Association 4 = ' Kenneth A. Alderson. Managing Director • July 15, 2003 Memo To: Illinois Municipal League Risk Management Association Member From: Kenneth A. Alderson, Managing Director Subject: IMLRMA Intergovernmental Contract and By-Laws The IMLRMA Board of Directors has approved the following summary of revisions to the IMLRMA Intergovernmental Contract and By-Laws. We have detailed all of the changes that have been made to the original documents that we started the program with in 1980. Due to changes in the self-insurance market and Illinois law we have determined that corrections were needed to both documents at this time. Illinois law now requires our self-insurance pool members to execute a new Intergovernmental Contract at least once every 12 years. Therefore, we request all of our current members to resign the Intergovernmental Contract and return a copy to our office no later than October 1, 2003. If you have any questions, please do not hesitate to call us at 217/525-1220. • Please Return By: October 1 , 2003 To: IMLRMA P.O. Box 5180 Springfield, IL 62705-5180 I.M.L/RISK MANAGEMENT 500 EAST CAPITOL AVE. P.O.BOX 5180 SPRINGFIELD,IL 62705 217/525-1220 Changes to the Illinois M(micipal League Risk Management Association By-Laws and Intergovernmental Cooperation Contract Approved by the IMLRMA Board of Directors May 1,2003 The Illinois Municipal League Risk Management Association has not changed its By-Laws or Intergovernmental Cooperation Contract since the inception of the program in 1981. After 23 years we believe that certain corrections,clarifications and changes are warranted.The following is a summary of the changes: By-Laws Cover Page—Change address to reflect current information. Page 3, Section 1.1 a)—Change references from insurance to coverage. Page 5, Section 3.2 e)—Change "contracts of insurance"to"coverage contracts". Page 7, Section 4.3—Remove the requirement to send receipts for all "fees and dues"and remove the redundant wording of"papers and documents" after records. Page 7, Section 5.2 a)—Remove the "liability claims" wording to reflect that all claims are included. Page 7, Section 5.2 g)—Remove wording referring to"insurance". Page 7, Section 5.2 i)—Remove all of paragraph i)requiring development of a "Master Risk Management Plan". Page 8, Section 6.2 a) and b)—Will now require municipalities to provide information and maintain a safety program required by the Association rather than the Operations Committee. Page 9, Section 8.1 b)—Replace the word "insurance"with "excess insurance or reinsurance". Page 9, Section 8.1 c)—Remove the reference to"insurance". Page 9, Section 9.1 —Remove wording requiring IML legal counsel to be counsel to IMLRMA. Page 10,Section 10.1 c)—Change the address to reflect current information. Intergovernmental Cooperation Contract Page 1,Authority To Execute Contract—Change the statutory citation to reflect the current location of the Intergovernmental Cooperation Act. Page 1,Article 1 (h)—Remove the reference to a"Master Risk Management Plan". Page 2,Article 2—Change the Association address to reflect current information. Page 2,Article 3 (b)and (c)—Change wording of catastrophe and stop gap insurance to insurance or reinsurance. Page 3,Article 6—In the third paragraph, add"reinsurance"to types of coverage. Page 3, Article 7—Change the phrase "or any insurance"to "nor any coverage". ILLINOIS MUNICIPAL LEAGUE RISK MANAGEMENT Association .1yr 4k-, INTERGOVERNMENTAL COOPERATION CONTRACT ILLINOIS MUNICIPAL LEAGUE RISK MANAGEMENT ASSOCIATION PO Box 5180 • • 500 East Capitol Avenue Springfield, Illinois 62705-5180 (h) "Risk Management Service" shall mean the management, administration and entire oper- ation of the Cooperative programs of Risk Management of the Association. (i) "Managing Director"means the individual who supervises the day-to-day operation of the Association and shall be the same person who is the Executive Director of the Illinois Municipal League. ARTICLE 2. ASSOCIATION NAME There is hereby created an entity, the full legal name of which shall be the "Illinois Municipal League Risk Management Association," and which may be referred to herein as the "Association." The principal office of the Association shall be the same as the principal office of the Illinois Municipal League which is located at 500 East Capitol Avenue, Springfield, Illinois. ARTICLE 3. ASSOCIATION POWERS (a) The Association shall have the power and the duty to establish and operate a program of Risk Management. (b) The Association is authorized to make and enter into contracts necessary to accomplish the purposes of this Contract. The foregoing powers include, but are not limited to, the power to contract for excess insurance or reinsurance, provide claims administration services and provide consulting servic- es, make inspections of participant facilities and administer a safety program. (c) By this Contract the parties hereto through the Association agree to provide and pay the cost of all of the Risk Management Services described herein, to jointly obtain and pay the costs of pre- miums for excess insurance or reinsurance as may be found by the Committee to be necessary from time to time, and to make contributions to the Association as required by this Contract. ARTICLE 4. ADMINISTRATION The Association shall be governed by its Board of Directors and the directions of the Board shall be carried out by the Operations Committee,all as more fully described in the By-Laws of the Association. The Chairman of the Board and of the Operations Committee shall be the President of the Illinois Municipal League. ARTICLE 5. MEMBERS,TERMS,WITHDRAWAL,EXPULSION (a) Each municipality which is a member of the Illinois Municipal League is eligible to join the Association. (b) Each municipality which is a party to this Contract is a "Member" of the Association and is entitled to the rights and privileges and is subject to the obligations of Members, all as provided for in this Contract and the By-Laws. (c) New Members shall be accepted upon application to the Association and acceptance by the prospective Member of the financial requirements and fund contribution requirements then in force and effect. (d) A municipality which is a party to this Contract hereby agrees to remain a Member of the Association for not less than one (1) year. A Member may withdraw its membership for any year there- after upon the giving of not less than sixty (60) days written notice to the Managing Director. No mem- bership may terminate prior to the last day of December of any given year. Page 2 of 5 RMA 5/1/2003 i (e) A party to this Contract may be excluded from membership when it: (1) Fails to comply with the terms of the Contract or; (2) Fails to comply with a written term or condition imposed by a majority vote of the Operations Committee including the operations safety standards established by the Committee. (f) The Board may, by a majority vote, terminate and exclude the offending Member from any and all benefits of membership in the Association which shall include forfeiture of any and all monies theretofore paid by that Member or assessed against that Member. (g) If a municipality withdraws or is expelled as a Member of the Association, any contribu- tions of that Member remaining in the funds of the Association at that time shall be the property of the Association. If this Contract is finally terminated as to all parties which are then Members, any money or assets in possession of the Association after the payment of all liabilities, costs, expenses and charges incurred pursuant to this Contract shall be returned to those parties in proportion to their contributions thereto determined as of the date of termination. ARTICLE 6. PLAN OF COVERAGE AND COST Each Member hereby agrees to contribute to the Association a sum of money to be determined by the Association at the time of application based on the needs of the Association and the loss experience of the member, which sum shall constitute the cost of the Member's first-year contribution for membership in the Association. Membership contributions for second and subsequent years shall be calculated in accordance with the loss experience of the City,and the needs of the Association including total losses and expenditures of the Self-Insured Retention Fund of the Association. The Committee shall determine if any Member has a risk or risks which the Committee determines to be unusual or extraordinary. If it is determined that such a risk or risks exists and that the coverage of such risk will be unusual or extraordinary, the Committee may at the option of the Member either increase the annual contribution of that Member or exclude the particular risk from coverage. Each Member will be covered in its operations against risk of loss as described in this Contract and the coverage terms which accompany the Contract. Coverage will consist of: 1) a self-insured reten- tion (S.I.R.), established by the Association from Member contributions, which will pay the amounts and be subject to the deductibles as set forth in the coverage terms;and 2)excess insurance or reinsurance cov- erage(to pay losses that exceed the S.I.R. limits set forth in the coverage terms) with limits as established by the Operations Committee. Each year the Committee shall determine the payments to be made by the members for the follow- ing year. ARTICLE 7. LIMITATIONS ON LIABILITY COVERAGE It is the intention of all participants in the Association that neither this Contract nor any coverage purchased by the Association shall extend to or provide coverage for any liability from which any mem- ber is immune under the provisions of the Illinois Local Government and Governmental Employees Tort Immunity Act, as it is now constituted or may hereafter be amended. Page 3 of 5 RMA 5/1/2003 ARTICLE S. MANAGEMENT SERVICES The Association will utilize the services, facilities and personnel of the Illinois Municipal League for Association purposes so long as it is practical and desirable in the opinion of the Board. It will reim- burse the League for the actual cost of any such services, use of facilities or use of personnel. In addition to paying the cost of services, facilities and personnel utilized from the League offices the Association will pay to the League an annual management fee as approved by the Committee. ARTICLE 9. PROHIBITION AGAINST ASSIGNMENT No Member may assign any right, claim or interest it may have under this Contract, and no cred- itor,assignee or third party beneficiary of any member shall have any right,claim or title to any part, share, interest, funds, premium or asset of the Association. ARTICLE 10. ENFORCEMENT The Association and the parties hereto shall have the power to enforce this Contract by action brought in any court of law having proper jurisdiction. It is agreed that such a suit may be filed only in Sangamon County, Illinois. ARTICLE 11. INVALIDITY Should any portion,term,condition or provision of this Contract be determined by a court of com- petent jurisdiction to be invalid under any law of the State of Illinois or be otherwise rendered unenforce- able or ineffectual, the validity of the remaining portions, terms, conditions and provisions shall not be affected thereby. ARTICLE 12. BY-LAWS INCORPORATED BY REFERENCE The Association and its Members shall be subject to and governed by the By-Laws which are by this reference, made a part of this Contract. ARTICLE 13. CONTRACT COMPLETE The foregoing constitutes the full and complete Contract of the member municipalities. There are no oral understandings or agreements not set forth in writing herein. The Contract is binding on each Member of the Association. ARTICLE 14. DATE CONTRACT EFFECTIVE This Contract shall become effective upon the occurrence of the following events: (1) each Member executing a copy of the Contract; (2)each Member depositing with the Association the contribu- tions required by this Contract; and(3) determination being made by the Committee that a sufficient num- ber of Members have subscribed and contributions been made to fund the cost of providing the services Page 4 of 5 RMA 5/1/2003 and benefits required under the Contract. Each Member which has agreed in writing to become a party of this Contract shall be bound to continue as a Member for the minimum period set forth in this Contract and thereafter may withdraw only as provided by this Contract and the By-Laws adopted by the Association. Each municipality which is a Member of this Association agrees upon the execution of the Contract to appropriate each year, by ordinance, a sum of money sufficient to pay all charges and assess- ments set forth in Article 6 plus its pro rata share of any deficits which may occur in the Self-Insured Retention Fund. ARTICLE 15. TERM OF AGREEMENT This Contract shall continue in effect until it is rescinded by mutual consent of the parties hereto terminated in the manner provided herein or in the By-Laws. ARTICLE 16. TERMINATION This Contract may be terminated at any time on or after one (1) year from its effective date by a vote of two-thirds of the members of the Board of Directors. Remaining assets after the payments of all claims, and expenses and establishment of necessary reserves shall be distributed pro rata among the Members. ARTICLE 17. AMENDMENT This Contract may be amended upon the affirmative vote of two-thirds of the members of the Board. A copy of any amendment so approved shall be mailed to each member of the Association. IN WITNESS WHEREOF, the parties hereto have entered into this Contract by the execution of a signature page which will be attached to the official master copy of this Contract and by the execution of a duplicate copy of the Contract which duplicate copy will be retained by the Member. The master copy shall be retained in the offices of the Association. Executed by the of pursuant to Ordinance No. . Adopted and approved the day of , 20 MAYOR or PRESIDENT Attest: CLERK Page 5 of 5 RMA 5/1/2003 I UNITED CITY OF YORKVILLE To: Tony Graff City Administr or k U , From: Joe Wywrot, City Engineer Subject: Street Name List Date: September 3, 2003 Attached find the proposed street name list from the Human Resource Commission. We have checked the list and found that the name"Wheeler" is already in use. All of the other names were cleared through the Yorkville Post Office and KENCOM. Please place this list on the Committee of the Whole agenda for consideration. NOMINATION OF STREET NAMES MEMORANDUM DATE: August 19, 2003 TO: Public Works Committee FROM: Human Resource Commission RE: Street Name Nominee The following name(s) are in the process of being reviewed and are being recommended by the Human Resource Commission to be placed on the official list of potential street names for the City of Yorkville. Bud Farren Dr. William E. Kinnett Chancy Goddard Albert H. Litchfield William Goddard Robert McMurtrie James McClellan Gale Dr. Robert Alexander McClelland, Sr. Rulief F. Duryea James McClellan, Sr. William T. Boston Justus Nading Jacob P. Black Jack Purcell Elias A. Black Dale Perkins Andrew H. Arnold Ira Perkins Benjamin Franklin Alden Edward Symes Lang Richardson Albert M. Hobbs George D. Richardson Franklin M. Hobbs Absalom Townsend Seely Titus Howe John Short, Sr. Luther J. Jeter Susan E. Surre Short Daniel G. Johnson Dr. Calvin Wheeler Jesse Ketchum Judge James Wilson Lenora Wissmiller Ellsworth Windett It is now the Public Works Committee's responsibility to contact the following groups to verify this name is not a duplicate of any United City of Yorkville street name. (a) United City of Yorkville's Engineering Department (b) Yorkville Post Office (c) Ken Com When this is completed, please forward the name to the Committee of the Whole. Respectfully, Human Resource Commission 08/01/2003 12. 10 FAX 630 553 5764 DANIEL J. KRAMER Ij001/007 PG0 AN ORDINANCE ADOPTING WATER CONSERVATION REGULATIONS FOR THE CITY WHERAS, the population of the United City of Yorkville has grown substantially in recent years and is projected to continue to grow at a rapid pace; and WHEREAS,prolonged dry periods, increased Water demand, equipment failures from time to time may threaten the Water resources and jeopardize the health, safety, and Welfare of the residents of the United City of Yorkville; and WHEREAS, Water is a limited natural resource that must be protected and the conservation of City water supplies is good and proper stewardship of those resources; and WHEREAS, it is the finding of the Mayor and City Council of the United City of Yorkville that certain mandatory Water conservation measures be imposed on the Water users of the City water supply system; and that a Water Conservation Regulations Ordinance be enacted; and NOW, THEREFORE BE IT ORDAINED, BY THE MAYOR AND CITY COUNCIL OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS, AS FOLLOWS; Article A. The Yorkville Municipal Code of 1994 as amended, shall be and is hereby further amended to adopt and incorporate therein certain water conservation measures in the City, limiting watering of lawns and other uses of water during certain hours and establishing other regulations, and shall be titled as follows: TITLE 7 Water and Sewer CHAPTER 5 Water Conservation Regulations The Yorkville Municipal Code of 1994, as amended, shall be and is hereby further amended to provide for the collection of unpaid fines assessed for violation of the Water Conservation Regulations herein adopted, by adding the amount of any unpaid fine to the water bill due for the property at which the offense occurred, as follows: OB/01/2003 12: 10 FAX 630 553 5764 DANIEL J. KRAMER Q02/007 Section 1, Definitions. The following words and phrases when used in this Article shall, for the purpose of this Article,have the following meanings: Drip-Irrigation System: A soaking hose that when in use does not result in an actual dissipation of Water. Drip-Line: Pertaining to a tree or shrub,the ground area immediately beneath the branches of the tree or shrub. Landscape/Landscaping: Sod and seeded turf lawns, gardens,trees, shrubs, and other living plants, Permitted Hours of Water Use: A time period between 5:00a.m. and 9:00a.m., and between 7:00p.m. and 11:00 p.m., each day. Person: Any individual, firm,partnership, association,corporation, company, organization, or entity of any kind. City: The United City of Yorkville. Water: The water provided by and obtained by a person from the City water supply and distribution system. Section 2. A. The provisions of this Article shall apply to all Persons using Water, and to all properties within the City or unincorporated areas which are connected to the City's Water supply and distribution system,regardless of whether any Person using the Water has a contract for service with the City. B. The provisions of this Article shall apply annually from May 1 through September 30, subject to any modifications thereof, including application of these or other regulations during this or any other time, by an Emergency Proclamation issued pursuant to Section(1)below. Section 3. Restricted Hours and Days for Specified Uses A. Water may be used for landscape watering or the filling of swimming pools only as follows: 1. All properties with even-numbered street numbers (i.e.,numbers ending in 0,2,4,6, or 8)may use Water for landscape watering or for pool filling, only on even-numbered calendar dates during Permitted Hours of Water Use. 08/01/2003 12. 10 FAX 630 553 5764 DANIEL J. KRAMER 2003/007 2, All properties with odd-numbered street numbers (i.e.,number ending in 1,3,5,7, or 9)may use Water for landscaping watering, or for pool filing, only on odd-numbered calendar dates during Permitted Hours of Water Use. 3. There shall be no restrictions as to hours or days when Water may be used for any of the following: a) Landscape watering or sprinkling where such watering or sprinkling is done by a Person using a hand-held watering device; b) Filling swimming pools with a volume of fifty(50) gallons or less, and any other children's recreational use, including but not limited to running through sprinklers and playing and filling water toys; c) The automatic watering of trees and shrubs by means of automatic root-feed or Drip-Irrigation Systems within the Drip Line of the tree or shrub; or d) Vehicle and equipment washing; or e) Any other lawful use of Water such as bathing, clothes washing, and other normal household uses not otherwise specifically restricted by the provisions of this Article. Section 4. Restrictions for Sod Laying and Lawn Seeding for New Lawns. Notwithstanding the provisions of Section 8-3-3 above, the following special regulations shall apply: A Sod laying,lawn seeding, and the planting of other landscaping for the establishment of a new lawn or new landscaping is prohibited from July 1 through August 31 each year. B. From May 1 through June 30, and from September 1 through September 30, Water may be used on new lawns (sod or seed), only as follows: 1. On the day new sod or seed has been placed on a property, a Person may use an automatic sprinkling device to apply Water to the sod or seed for a total period of time not to exceed eight (8) hours 2. For the next nine(9)days thereafter, a Person may apply water to said sod or seed each day during Permitted Hours of Water Use. 08/01/2003 12: 10 FAX 630 553 5764 DANIEL J. KRAMER a004/007 3. Following the first ten(10) days after the sod or seed is placed,the provisions of this Ordinance shall apply. C. Prior to the execution of any real estate contract for the sale of newly constructed property, the builder or owner of such new construction shall: 1. Inform prospective purchasers of the restrictions upon the installation of new lawns set forth in this Article; 2. Attach a Copy of these regulations to the contract; and 3. Obtain the signature of the purchaser(s) on a statement that he, she or they has (have) been informed of the new lawn installation restrictions set forth in this Article. D. The applicant for a certificate of occupancy for any newly constructed property shall submit as a part of his application, and as a condition of issuance of such certificate, a copy of said signed statement. When an application for certificate of occupancy is submitted prior to sale of the property, and the future occupant is unknown, the applicant shall submit his signed statement that he shall comply with the requirements of this Section at the time the real estate contract is executed, E. Waste of Water Prohibited. No Person shall allow a continuous stream of Water to run off into any gutter, ditch, drain, or street inlet while using Water for restricted purposes during the Permitted Hours of Water Use. F. Exceptions. The provisions of the article shall not apply any commercial or industrial entity for which use of Water is necessary to continue normal business operations, or to maintain stock or inventory. Provided, however, this exception shall not apply to any and all uses of Water not essential to normal business operations or maintenance of inventory or stock, and specifically shall not apply to landscape watering or pool filling. G. Bulk Water Rates. Bulk Water rates shall be increased to three (3) times the non-resident Water rate during the time described within this Ordinance, 08/01/2003 12. 10 FAX 630 553 5764 DANIEL J. KRAMER (1005/007 H. Hydrant Use Prohibited. Hydrants connected to the City water supply and distribution system for the purpose of providing Water for fire fighting purposes shall not be opened by any Person, other than authorized City or Fire District personnel, except for the purpose of fighting a fire, 1. Emergency proclamation, 1. Whenever the Water supply of the City is diminished from any cause, including but not limited to prolonged dry period, increased Water demand, equipment failure, or Water quality concerns,to an amount which in the opinion of the City Engineer or Director of Public Works is or is likely to become dangerous to the health and safety of the public, the City Mayor is hereby authorized and empowered to issue an Emergency Proclamation specifying different or additional regulations on the use of water, 2. Such regulations may provide for limitations on the usage of Water, limitations on days and hours of use of Water for some or all purposes, and the prohibition of specified uses of Water, 3. Upon issuing such Proclamation, the City Mayor shall make the contents thereof known to the public by posting a copy at the City Hall, and by new release to local newspapers and radio media, and may also endeavor to notify the City residents and other Persons in any other practical manner that he or she shall devise. Further,the City Mayor shall immediately deliver notice of such Proclamation, and the regulations that have been imposed by such Proclamation,to all members of the City Council. 4. The Emergency Proclamation of the City Mayor, and the regulations imposed thereby, shall remain in full force and effect until any one of the following shall first occur: a. The City Mayor determines that the emergency no longer exists and that the Emergency Proclamation, and the regulations imposed thereby, shall no longer continue in effect. b. The City Council modifies or repeals the Emergency Proclamation, and the regulations imposed thereby,by means of an ordinance enacted at any regular or special meeting of the City Council c. The first regular meeting of the City Council occurring more than 30 days after the date of the Emergency Proclamation of the City Mayor. 5. Any City employee or officer may, at the direction of the City Mayor, notify and warn any Person of the effect of said Emergency Proclamation and direct said Person to comply with said watering or sprinkling restrictions. If any said Person, after having first been warned about said restrictions of the Emergency Proclamation, then shall be deemed to be in violation of this Article. J. Penalty. 1.1.1.11111.1111111111111111.1110.111111.111111.111111.111.1111.1111.1.10.111111...... 08/01/2003 12. 10 FAX 630 553 5764 DANIEL J. KRAMER a006/007 1. Any person who or which violates, disobeys, neglects, fails to comply with or resists enforcement of the provisions of this Article other than Section(3)(A)(3) or Section(3)(F) above, shall,within ten(10)days of receiving notice of such violation, pay at the Office of the City Clerk, a fine, as follows: a. $50.00 for a first offense; b. 5125.00 for a second offense; and c. $500.00 for each subsequent offense. 2. Any person who violates this Article shall,within thirty(30) days of receiving a notice of such violation, shall be subject to imposition of a fine up to $750.00 for each offense. 3. Each day a violation occurs or continues shall be considered a separate violation for purposes of this article. 4. The amount of any fine due pursuant to Section 4(J) above, if not paid as provided therein, shall be added to the bill for water consumption for the property at which the offense occurred. 5. The amount of any fine due pursuant to Title 7, for a violation of the provisions of Title 7 occurring at a property in the City, it has not otherwise been paid as provided therein, shall be added to the amount of any bill for water consumption rendered in respect to said property pursuant to this section. Section 5.REPEALER: All ordinances or parts of ordinances conflicting with any of the provisions of this ordinance shall be and the same are hereby repealed. Section 6. SEVERABILITY: If any section, subsection, sentence,clause, phrase or portion of this ordinance is for any reason held invalid or unconstitutional by any court of competent jurisdiction, such portion shall be deemed a separate, distinct, and independent provision, and such holding shall not affect the validity of the remaining portions hereof. Section 7. EFFECTIVE DATE: Except for Section 4 of this ordinance which shall have an effective date of May 1, 2004, this ordinance shall be in effect from and after its passage, approval and publication in pamphlet form as provided by law. Any and all ordinances, resolutions, and orders, or parts thereof, which are in conflict with the provisions of this Ordinance, to the extent of any such conflict, are hereby superseded and waived. IN WITNESS WHEREOF, this Ordinance has been enacted this day of ,2003. 08/01/2003 12. 10 FAX 630 553 5764 DANIEL J. KRAMER a007/007 PAUL JAMES MARTY MUNNS RICHARD STICKA WANDA OHARE VALERIE BURR ROSE SPEARS LARRY KOT JOSEPH BESCO APPROVED by me, as Mayor of the United City of Yorkville,Kendall County, Illinois, this day of ,A.D. 2003. MAYOR PASSED by the City Council of the United City of Yorkville, Kendall County, Illinois this day of ,A.D. 2003. Attest: CITY CLERK This Document Prepared by: Law Offices of Daniel J. Kramer 1107A South Bridge Street Yorkville, Illinois 60560 630-553-9500 09/11/2003 13:43 630553437777 CITYHOFOYORKVILLE PAGE 01 United City of Yorkville Sod Watering Permit Name Date Address Start Date Ending Date Official Sod Watering Rules 1. Sod laying, lawn seeding, and the planting of other landscaping for the establishment of a new lawn or new landscaping is prohibited from Julyl through August 31 of each year. 2. From May 1 through June 30, and September 1 through the end of the season, water may be used on new lawns(sod or seed), only as follows: a. On the day new sod or seed has been placed on a property, a person may use an automatic sprinkling device to apply water to the sod or seed for a total period of time not to exceed eight(8)hours. b. For the next nine (9)days thereafter, a person may apply water to said sod or seed each day during permitted hours of water use. c. Following the first ten (10)days after the sod or seed is placed, the provisions of Section 8-3-3 attached shall apply. Signature of Responsible Party " ( fi UNITED CITY OF YORKVILLE To: Tony Graf City Administra r From: Joe Wywrot, City Engineer ?, Subject: Certificate of Occupancy—Sit Insp 'on Form Date: September 8, 2003 Attached find a site inspection form that we propose to use before a Certificate of Occupancy is issued for a new home, commercial property, etc. We have had complaints from some developers that the builders in their developments are not taking care when constructing their buildings. Consequently, items such as manholes,B-Boxes, etc. are buried or broken during construction of the building. This results in a longer punchlist that the developer has to complete before the city accepts the public improvements. The site inspection would be performed by Engineering and Public Works personnel before a CO is issued. Items identified would have to be repaired by the builder before a final CO is issued, or an escrow account would have to be set up to guarantee satisfactory completion of the work. If the builder doesn't complete the work,we would have the developer perform the work and turn those funds over to him. Listing an item as"pass" on the form would not constitute acceptance of an improvement,but hopefully would result in shorter punchlists and less frequent arguments by developers that they shouldn't have to fix items broken by others. The Public Works Committee recommended that this additional inspection be performed beginning October 1, 2003. Please place this item on the Committee of the Whole agenda of September 16,2003 for discussion. Cc: Dan Kramer, City Attorney Bill Dettmer, Building Inspector Eric Dhuse, Director of Public Works UNITED CITY OF YORKVILLE PUBLIC WORKS/ENGINEERING CERTIFICATE OF OCCUPANCY CHECK SHEET ADDRESS: DATE: Remote Meter Reader Pass Fail Parkway Tree Pass Fail B-Box Operation Pass Fail Mailbox Position Pass Fail Storm Structures Pass Fail Water Structures Pass Fail Sanitary Structures Pass Fail Sidewalk Condition Pass Fail Drainage Overflow Path Pass Fail Landscape Plan Pass Fail (Non-residential) NOTES: SIGNATURE: NOTE: A passing inspection does not relieve the builder/developer of responsibility should a problem occur at a later date. This inspection checklist is for the purpose of occupancy only, not acceptance of improvements. • Qo j o ..i tillt 114 Equipment vI • Radios, P.B.T.s, Noise Monitor, Remote mics, Road Spikes, Defibs, Nextel Phone System, Pagers, Video equipment, etc. Neighborhood Watch/Crime Prevention through Environmental Control °-.9,4. .a Uniform Quartermaster Citizen Police Academy Alumni YORKVILLE POLICE DEPARTMENT Plan Council Representative CHIEF OF POLICE 804 Game Farm Road Phone (630) 553-4340 River Front Representative Harold O.Martin ill Yorkville,Illinois 60560 Fax (630) 553-1141 KenCom Board Representative Projects - i.e. National Night Out, Character Counts Week, School Traffic issues reference to games etc., BASSET Training, CPA Date: September 12, 2003 Classes, Red Ribbon Week, Safety Town, to name just a To: Committee of the Whole few. From: Chief Harold Martin Reference: Creation of New Sergeant I have the money in my current budget and will not need to ask for any funds to fund this position. The cost would be approximately The following is my explanation why I believe we need another $3,000. I have met with Finance Director Traci Pleckham, and we Sergeant. Currently we are working 12 hour shifts on the street. The would take this money out of the Over-Time Budget line item. I would shifts work as such: like to promote this person on or about November 25th, 2003. This would be approximately when the two new people would have completed their 10 week FTO period. This move would greatly Squad A Squad B Squad C Squad D enhance our supervision ability. Dav Shift Day Shift Night Shift Night Shift Sergeant Sergeant Sergeant Sergeant Officer Officer Officer Officer Officer Officer Officer Officer New-Officer New-Officer New-Officer New-Officer P-T Officer P-T Officer P-T Officer P-T Officer Operations/Administration Sergeant Building • Currently working Monday-Friday with the build-out • Handles all the day to day issues with the building Squad Cars • We currently maintain 15 squads • This includes Radios, Computers, Sirens, Light-bars, Lights, and Radars etc. • New Training Equipment Trailer • Speed Trailer - Puts together locations, Takes to locations, and monitors, speed studies etc. 09/12/2003 07.41 FAX 630 553 5784 DANIEL J. KRAMER rd,001/001 STATE OF ILLINOIS ) revised 9-12-03 )ss COUNTY OF KENDALL ) ORDINANCE NO.2003- AN ORDINANCE AMENDING TITLE ONE,CHAPTER FIVE,SECTION TWO OF THE CITY CODE OF THE UNITED CITY OF YORKVILLE TO ALLOW TELEPHONE CONFERENCE VOTING BY AN ALDERMAN WHEREAS, the demands of modern life have made required long-distance travel more common,while at the same time the issues facing municipal Iegislators are more serious, numerous and urgent than ever before;and WHEREAS, current technology has made it possible for public debate to be held by telephone conference calls in such a way that an absent Alderman can fully and publicly participate in a debate and vote on an issue, and the Illinois Attorney General has opined that such a teleconferenced presence is generally consistent with the structure of the Open Meetings Act; and WHEREAS, the current United City of Yorkville regulations as codified in Title One, Chapter Five, Section Two do not provide for the possibility of an Alderman to vote by teleconference call in appropriate circumstances; and WHEREAS,the United City of Yorkville possesses full authority to regulate the conduct and procedures of its City Council Meetings; and WHEREAS, the City Council and Mayor find that there are circumstances where allowing a Alderman absent from a regular Council Meeting to debate and vote on an issue 09/12/2003 07: 24 FAX 630 553 5764 DANIEL J. KRAMER 0003/005 pursuant to a conference telephone call is in the interest of the public;and WHEREAS, the City Council has duly considered the recommendation to amend Title One, Chapter Five, Section Two of the City Code of the United City of Yorlcville concerning the telephone conference voting by an Alderman; and NOW THERE UPON MOTION DULY MADE, SECONDED,AND APPROVED BY A MAJORITY OF THOSE CITY COUNCIL MEMBERS VOTING, TITLE ONE, CHAPTER FIVE, SECTION TWO OF THE CITY CODE OF THE UNITED CITY OF YORKVILLE IS AMENDED AS FOLLOWS: PARAGRAPH D: Any matter requiring a roll call vote at a regular meeting of the City Council may be voted on by an absent Aldeman via a conference telephone call between the absent Alderman and the rest of the Council present at the regular meeting under the following conditions: 1, The absent Alderman cannot be physically present at the regular meeting at which the matter is put to vote. 2. The absent Alderman's voice on the conference telephone call, after being identified by the rest of the Council as belonging to the Alderman, shall be simultaneously broadcast to the public present at the regular meeting and pen to the media, and the absent Alderman shall also be able to hear any public comment regarding the issue elicited at the meeting, if any,before the vote is taken. 3. Prior to voting, the Alderman shall publicly state the reason for not being present at the regular meeting to vote in person, 4, That no more than three(3)Aldermen shall be permitted to vote via a 09/12/2003 07:24 FAX 630 553 5764 DANIEL J. KRAMER a 004/005 conference telephone call at any public meeting. REPEALER: All ordinances or parts of ordinances conflicting with any of the provisions of this ordinance shall be and the same are hereby repealed. SEVERABILITY: If any section,subsection,sentence,clause,phrase or portion of this ordinance is for any reason held invalid or unconstitutional by any court of competent jurisdiction, such portion shall be deemed a separate, distinct, and independent provision, and such holding shall not affect the validity of the remaining portions hereof. EFFECTIVE DATE:This ordinance shall be in effect from and after its passage, approval and publication in pamphlet form as provided by law. IN WITNESS WHEREOF, this Ordinance has been enacted this day of ,2003. PAUL JAMES MARTY MUNNS RICHARD STICKA WANDA OHARE VALERIE BURR ROSE SPEARS LARRY KOT JOSEPH BESCO APPROVED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this _day of_ ,A.D. 2003. MAYOR PASSED by the City Council of the United City of Yorkville,Kendall County,Illinois this day of ,A.D. 2003. Attest CITY CLERK 09/12/2003 07 24 FAX 630 553 5764 DANIEL J. KRAMER Q005/005 This Document Prepared by: Law Offices of Daniel J. Kramer 1107A South Bridge Street Yorkville,Illinois 60560 630-553-9500