The URL can be used to link to this page

Administration Packet 2012 02-16-12 so C►r y z o United City of Yorkville J y y _1% 800 Game Farm Road EST , 1836 Yorkville, Illinois 60560 .4 Telephone: 630-553-4350 O� a 4 Fax: 630-553-7575 ALL E AGENDA ADMINISTRATION COMMITTEE MEETING Thursday, February 16, 2012 6:00 p.m. City Hall Conference Room Citizen Comments: Minutes for Correction/Approval: January 19, 2012 New Business: 1. ADM 2012-08 Monthly Budget Report for January 2012 2. ADM 2012-09 Monthly Treasurer's Report for January 2012 3. ADM 2012-10 Cash Statement for December 2011 4. ADM 2012-11 SSA Refinancing 5. ADM 2012-12 Non-home Rule Sales Tax - Business Disclosure Authorization 6. ADM 2012-13 Cell Phone Usage During Meetings 7. ADM 2012-14 Copier RFP Old Business: 1. ADM 2011-40 Employee Manual Revision— Sections 5 & 6 Additional Business: UNITED CITY OF YORKVILLE WORKSHEET ADMINISTRATION COMMITTEE Thursday, February 16, 2012 6:00 PM City Hall Conference Room --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1. January 19, 2012 ❑ Approved ❑ As presented ❑ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2012-08 Monthly Budget Report for January 2012 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2012-09 Monthly Treasurer's Report for January 2012 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2012-10 Cash Statement for December 2011 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 4. ADM 2012-11 SSA Refinancing ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 5. ADM 2012-12 Non-home Rule Sales Tax—Business Disclosure Authorization ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 6. ADM 2012-13 Cell Phone Usage During Meetings ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 7. ADM 2012-14 Copier RFP ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- OLD BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2011-40 Employee Manual Revision— Sections 5 & 6 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- ADDITIONAL BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 0 CIP Reviewed By: Agenda Item Number J� 6 Legal ❑ Minutes EST. 1&36 Finance El Engineer ❑ Tracking Number Gy City Administrator El r� 9 _© Public Works ❑ Agenda Item Summary Memo Title: Minutes of the Administration Committee—January 19, 2012 Meeting and Date: Administration Committee 2/16/12 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Committee Approval Submitted by: Minute Taker Name Department Agenda Item Notes: DRAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING Thursday, January 19, 2012 6:00pm City Hall Conference Room COMMITTEE MEMBERS IN ATTENDANCE: Chairman Rose Spears Alderman Carlo Colosimo Alderman George Gilson Absent: Alderman Marty Munns OTHER CITY OFFICIALS IN ATTENDANCE: Mayor Gary Golinski City Administrator Bart Olson Alderman Chris Funkhouser(arr. 7:35pm) Human Resources Manager Meghan Ostreko GUESTS: Matt Seng, Fox Highlands (arr. 6:45pm) Jill Duchnowski, Yorkville Patch(arr. 7:18pm) The meeting was called to order at 6:02pm by Chairman Rose Spears. Citizen Comments: None Minutes for Correction/Approval -December 15, 2011 Page 1: Item#1 under New Business, last sentence should read ..."when F. E. Wheaton closes..." (not"is closes") Page 4: First paragraph, last sentence should read "Ward 2 will..." Going forward, committee members not in attendance at the committee meetings will be documented in the minutes as being absent. The minutes were then approved as corrected. New Business: 1. ADM 2012-01 Monthly Budget Report for December 2011 It was noted that the budget is at 67% at this time. The committee then discussed several items in the report as follows. 1 Page 2: Alderman Gilson questioned Administration overtime. It was attributed to employees cashing out comp time, also some overtime was paid for water bills litigation (Mr. Olson to check on line item for this), FOIA requests and legal discovery for Ocean Atlantic. The December amount was $660, bringing the total to $1,030 with a budget of $575. Mr. Gilson questioned how the City could ever accurately budget this category. Page 3: Mr. Gilson noted the part-time police salaries and overtime were very high. These salaries will be offset by the lack of cadets and Mr. Olson said the Chief of Police had already predicted this category would be high. The projected amount of overtime is $125,000 for the year. Bart Olson will check on the details of professional services costs. Page 4: Alderman Spears asked about the expenditures in the wearing apparel category. This is due to new hires in the Police Department with a cost of about $2,000 to $2,500 per officer. Alderman Gilson asked how much more would be spent on inspections. The total spent is $27,500 for the year with $4,000 more being anticipated. Page 5: The Administration expenses for Professional Services are at 121% of the budget. This is the IT/GIS line item and the expense was for the City server. This will be transferred to contingency and the Council has already approved. Page 7: Alderman Gilson questioned the Public Works Professional Services being 123% over budget. Mr. Olson said this is lien fees and the City will recoup that money. Page 10: Chairman Spears questioned the Lift Station Maintenance at 95.48%. Expense was a pump motor. Page 9: Mr. Gilson said Publicity and Advertising for Water Operations is at budget. He questioned Professional Services at 180%. Water liens are coded here and will be recouped. Mr. Olson will research the $15,000 spent for Repair and Maintenance in November. Page 12: Part-time salaries for Parks were questioned by Mr. Gilson and determined to be seasonal employees. Overtime could be attributed to snowplowing. Copier expenses are coded to Professional Services with $5,000 being spent per month. Professional Services are program instructors; for example, All Star Baseball instructors receive 80% of the fees charged. The possibility of a separate line item for contractual services will be explored. The program refunds are high and were from fall classes. Salaries of$75,000 for employees and $50,000 for contracted employees were questioned by Mr. Gilson. He also suggested separate lines for expenses and revenues. He noted program fees are 17-18%behind, however, memberships are doing well. This monthly budget report moves forward to the Council consent agenda. 2. ADM 20-12 02 Monthly Treasurer's Report for December 2011 Mr. Olson commented that bond payments are made in December. This moves forward to the Council consent agenda. 2 3. ADM 20-12 03 Cash Statement for November 2011 Information only, moves forward to Council consent agenda. 4. ADM 2012-04 Quarterly Comp Time Report This committee had requested this report. Alderman Colosimo asked if an offer had been made to employees. The offer was made and some employees took advantage of it. This report will come back to committee every 6 months for review. 5. ADM 2012-05 NIMEC Bid for Electric Accounts Administrator Olson said NIMEC bids out to potential electric power suppliers. When the winning bid is determined, it will be presented to the City and a decision is required within 24 hours. The City Administrator and Finance Director are seeking approval to make a decision on behalf of the City. This item will be moved forward to Council for a motion to approve on the consent agenda. 6 ADM 2012-06 Audit RFP— Vendor Selection All bidders were qualified and the low bidder was Lauterbach and Amen. Mr. Fredrickson had previous experience with this company and they were selected. This item will move to the Council consent agenda. 7. ADM 2012-07 Revision to Procedural Ordinance Mr. Olson said this proposed revision resulted from the bike path discussion. The revision would require an agenda item with a negative committee recommendation, to move forward to the Council level. Attorney Orr suggested giving discretion to committees to discuss and put items on the Council agenda and she said the Mayor always reviews committee agendas. Alderman Colosimo said he thinks there are enough safeguards to place items on agendas and not all items proceed to the Council level. He said although "killing" items in committee has a bad connotation, committees are in place to filter information. Following discussion, this proposed revision was defeated in the committee. Old Business 1. ADM 2011-41 Redistricting— Ward Maps Mr. Olson said there are 2 maps in the packet and on Alternate 2 a change was made placing Bristol Bay in Ward 3. Another suggestion was to place a section of Heartland Circle & Heartland into Ward 2. Alternate I keeps Heartland Circle and Heartland in Ward 4. Ward 4 still has the highest number of residents and is the fastest-growing. Alternate 2 places Heartland Circle in Ward 2 and leaves Heartland subdivision in Ward 4. Alternate 2 has the most even population distribution and also sets Ward 4 as the lowest populated ward allowing for future growth. 3 All committee members preferred Alternate map 2. The next step is to move this choice forward and schedule a March Public Hearing for formal adoption. Alderman Colosimo asked that this map be placed on the website for citizen review. After the Public Hearing, the recommendation would move forward to the Council consent agenda. 2. ADM 2011-40 Employee Manual Revision —Sections 3 & 4 Human Resource Manager Meghan Ostreko said Section 3 is compensation and 4 is benefits. Many clarifications were made to better administer the policies and benefits. She opened the floor to questions. Page 65: Gilson questioned callback pay and asked if it is standard to pay 1.5 times regular pay. This is standard and the revision spells out that if an employee is called in on a holiday, they receive 2 times their normal pay. Page 66: Gilson asked for clarification on the longevity change. Meghan explained longevity relating to bargaining units. She cited the example of 2 employees who left the City, then returned and she said their years of service do not count towards their longevity. Alderman Colosimo pointed out that continuous service means no break from service and suggested the wording could be interpreted differently. Mr. Olson said some employees may have been grandfathered in under a previous policy. However, if someone is laid off and then brought back without another job in between, Mr. Olson said that would be continuous service under this policy. Aldermen Spears and Colosimo agreed, however George Gilson said it should not be continuous service. He said if the City adopts this policy, there should be a time limit for someone who was laid off. Alderman Colosimo said this change in the longevity is one of the benefits the City can extend in this economy. Page 67: Chairman Spears asked what the probationary time period is. It is 12 months. Page 68: It was noted that a new hire would receive 1 week of vacation after 6 months employment giving earlier access to vacation. Previously it was 2 weeks after 1 year. Mr. Gilson said most companies do not allow vacation after just 6 months. He raised the scenario of an employee using vacation after 6 months and then leaving the City. Ms. Ostreko said pro-rated vacation is paid to an employee who leaves within a year. Mr. Gilson questioned whether a part-time employee should receive the same vacation as a full-time person as stated in the policy. There was discussion on this and Mr. Olson said there was a clause stating it would only be given to an eligible part time employee if it was a compensation package approved by the Mayor. Alderman Spears and Colosimo said there should be a definition of an eligible part-time person. Staff will revise the language for this section. Non-exempt employees can now receive 200 hours of vacation after 16 years, which was previously capped at 160 hours. This mirrors the Public Works contract. Mr. Gilson questioned the Public Works double time pay vs. time and one-half for regular employees, plus holiday pay for holiday call-ins. The Public Works manual will be checked and staff will make a recommendation for next month. 4 In general discussion, Ms. Ostreko commented that the City might want to consider a Paid Time Off(PTO) Policy whereby the employee has one pool of time off. She said it has pros and cons and is somewhat complicated to implement. It is used in Naperville and has 2 tiers. Alderman Gilson said he is on a PTO policy and it works well. Alderman Colosimo said if certain categories are separated such as bereavement, military etc., then it creates more categories like the present policy. Mayor Golinski asked how many more days would be added if a PTO policy was instituted. Basically the number of days are decreased, but the flexibility is increased. Mr. Olson said the employees could be asked their opinion of such a program. He also noted that currently, sick time can be banked. Alderman Colosimo asked if PTO can be given to other employees who are sick. The policy could be changed to accommodate according to Bart. City employees and also other towns will be surveyed for their opinion. Page 69: Alderman Gilson asked if the 960-hour accrual of sick leave would continue It depends if PTO accrual is adopted according to Mr. Olson. He said there is a recommendation that it cannot be cashed out unless the employee works 20 years. Ms. Ostreko said she also did a survey of other towns and some of them have no limits on accruals.. Page 71: Alderman Colosimo said the "Mayor" should be included in the language approving emergency or bereavement leave. Page 74: Ms. Spears said the term"Cobra" should be included in the section regarding continuation of medical coverage. The Education section language was also discussed. The current language states reimbursement will occur at the discretion of the Mayor& City Council. Revised language agreed on is: Upon approval pursuant to Section a, the City shall pay tuition and fees only". Carlo also said a grade of"B-" or greater, should be required for reimbursement. Page 75: The rate of$150 for lodging and meals for a night was questioned, but it was decided this is close to the going rate. It was noted the City receives a per diem rate. Alderman Spears noted a revision is needed in the 4th sentence under Lodging where it says "...City credit card when feasible taken..." Alderman Gilson questioned the phrase "within the narrative of the budget"under the heading "Training and Certificates". Mr. Olson said this phrase requires details of the trip prior to attending. Ms. Ostreko said after the last 2 sections are discussed, the Labor Attorney will review the document. It is hoped to have it completed by May 1St. Mayor Golinski said this was a good comprehensive update. 5 3. 2011-44 City Services Survey Committee members reviewed the survey on-line and Mr. Olson said it took about 10-15 minutes for City employees to finish. He added that abundant analysis can be derived from the survey. It will proceed to the consent agenda for a February Council meeting. Additional Business: Chairman Spears said she received a call from the UPS store that has a concern since the City has an account with UPS. UPS and the UPS store are totally different businesses. The store representative said City employees drop packages off there, however, they do not receive any money from this transaction. The store has been processing the packages nonetheless. He said UPS and the UPS store charge the same amount unless the City has the daily pickup service. The store does not charge for weigh bills, but UPS does. Bart Olson will speak with the store rep for further information. --------------- --------------- Ms. Spears also received a call regarding Com Ed and City power outages. The resident said this shuts down his internet service where he receives Doctor information and he wished to know what action the City is taking. Alderman Gilson also noted there are power surges occurring especially on the south side. Mr. Olson said the resident should contact Com Ed who logs problems and a year-end report is provided to the City. Mr. Gilson asked if the City could do anything now. Mr. Olson will also report the problem to the Com Ed rep. Aldermen Colosimo and Gilson would like to see a Com Ed report of the outages. Com Ed is starting to roll out a GIS report of where surges occur, but is not completely reliable yet. The City will be receiving upgrades in the next couple years according to Bart Olson. ----------------- ----------------- Alderman Gilson inquired about the funding for the River Road bridge. Mr. Olson said State funds are available through an inter-governmental agreement. The City asked the County to front-fund the money for the City portion. Bond payments are due in December and the front-funding will help cash flow. ----------------- ----------------- Mayor Golinski said he is going to bring an item back that had been killed in committee. This concerns the Blackberry Creek agreement. Public Works did not agree with some of the language in the agreement, since IDOT had changed some language. It is hoped there will be an agreement by end of January to take advantage of a grant. It will then be moved forward to City Council. A 6-month extension has been received for the bike path according to Bart Olson. There was no further business and the meeting adjourned at 7:56pm. Minutes transcribed by Marlys Young, Minute Taker 6 0 CIP Reviewed By: Agenda Item Number J� a► Legal ❑ NB #1 W36 EST. Finance ■ Engineer ❑ Tracking Number Gy City Administrator ■ r� _© Consultant E] ADM 2012-08 Agenda Item Summary Memo Title: Budget Report for January 2012 Meeting and Date: Administration Committee 2/16/12 Synopsis: January budget report and income statement. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Discussion Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-71 June-71 July-11 August-11 September-11 October-11 November-11 December-11 January-12 Totals BUDGET %.f Budget GENERAL FUND REVENUES 01-000-40-00-4000 PROPERTY TAXES-CORPORATE LEVY 366,362 754,059 28,630 281,365 743,499 66,066 42,265 - 2,282,246 2,290,964 99.62% 01-000-40-00-4010 PROPERTY TAXES-POLICE PENSION 57,847 119,062 4,521 44,426 117,395 10,431 6,673 - 360,356 375,000 96.09% 01-000-40-00-4012 PROPERTY TAXES-FOX INDUSTRIAL - - - - - - - - 67,334 67,334 - 0.00% 01-000-40-00-4030 MUNICIPAL SALES TAX 169,093 210,574 209,931 225,649 247,713 227,536 226,355 222,449 201,136 1,940,435 2,550,000 76.10% 01-000-40-00-4040 ELECTRIC UTILITY TAX - 136,433 - - 141,597 - - 182,519 - 460,549 591,600 77.85% 01-000-40-00-4041 NATURAL GAS UTILITY TAX - 102,673 - - 37,606 - - 29,711 26,744 196,734 290,700 67.68% 01-000-40-00-4043 TELECOMMUNICATIONS TAX 39,597 40,525 44,672 41,132 41,314 41,029 41,820 40,859 40,552 371,500 535,500 69.37% 01-000-40-00-4044 TELEPHONE UTILITY TAX 3,303 - 1,626 1,607 1,588 3,117 - 1,515 1,499 14,254 - 0.00% 01-000-40-00-4045 CABLE FRANCHISE FEES 56,358 - - 57,242 - - 58,018 - - 171,618 204,000 84.13% 01-000-40-00-4050 HOTEL TAX 2,934 4,014 6,018 5,900 5,018 6,542 4,124 2,643 3,420 40,613 30,600 132.72% 01-000-40-00-4060 AMUSEMENT TAX 181 252 780 90,372 624 162 24,790 - 909 118,069 134,000 88.11% 01-000-40-00-4065 ADMISSIONS TAX - - - - - - 190,627 - - 190,627 190,000 100.33% 01-000-40-00-4070 BUSINESS DISTRICT TAX 18,453 25,565 23,787 24,471 27,616 23,037 22,407 25,315 22,054 212,706 300,000 70.90% 01-000-40-00-4075 AUTO RENTAL TAX 687 909 800 651 772 807 930 793 829 7,177 7,140 100.52% 01-000-40-00-4080 PARA-MUTUEL TAX 2,733 3,793 - 1,811 4,447 1,706 1,655 1,672 1,669 19,486 15,000 129.91% 01-000-41-00-4100 STATE INCOME TAX - 142,890 193,873 156,645 101,008 - 130,850 90,021 169,172 984,460 1,340,000 73.47% 01-000-41-00-4105 LOCAL USE TAX 19,635 21,844 20,408 19,884 21,970 17,584 20,942 15,883 19,973 178,124 210,000 84.82% 01-000-41-00-4110 ROAD&BRIDGE TAX 28,104 54,613 2,193 22,098 52,838 4,128 2,921 - - 166,896 164,296 101.58% 01-000-41-00-4120 PERSONAL PROPERTY REPL TAX 3,033 - 2,114 529 - 3,530 - 510 2,173 11,889 13,000 91.45% 01-000-41-00-4160 FEDERAL GRANTS 176 - 5,447 - 235 - 498 6,356 9,200 69.09% 01-000-41-004170 STATE GRANTS 3,876 1,650 590 390 - 6,506 - 0.00% 01-000-41-00-4182 MISC INTERGOVERNMENTAL - - - - - - - - 2,000 0.00% 01-000-42-00-4200 LIQUOR LICENSE 1,010 938 1,325 245 - 50 100 825 4,493 40,000 11.23% 01-000-42-00-4205 OTHER LICENSES&PERMITS 623 194 269 10 269 2,775 - - - 4,139 3,000 137.97% 01-000-42-00-4210 BUILDING PERMITS 21,392 9,173 12,816 9,503 36,108 13,637 10,025 7,276 3,087 123,017 122,400 100.50% 01-000-42-00-4220 FILING FEES - - - - - - - - - - 250 0.00% 01-000-43-00-4310 TRAFFIC FINES 14,457 6,470 4,875 5,495 5,427 6,953 4,249 4,210 5,056 57,191 95,000 60.20% 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 1,816 1,791 1,625 2,445 1,870 1,888 2,456 1,054 2,802 17,747 30,000 59.16% 01-000-43-00-4325 POLICE TOWS 8,000 7,500 5,000 5,500 5,500 9,000 8,500 5,500 8,000 62,500 90,000 69.44% 01-000-44-00-4400 GARBAGE SURCHARGE 124 203,755 98 205,203 191 205,290 119 206,170 26 820,976 1,175,000 69.87% 01-000-44-00-4405 COLLECTION FEE-YBSD - - - - - 123,932 0.00% 01-000-44-00-4412 SERVICE CHARGE-LIBRARY - - 0.00% 01-000-44-00-4474 POLICE SPECIAL DETAIL - 350 - - 350 5,000 7.00% 01-000-44-00-4475 OFFENDER REGISTRATION FEES 105 105 - 0.00% 01-000-45-00-4500 INVESTMENT EARNINGS 3 89 301 310 384 553 466 752 579 3,438 2,000 171.91% 01-000-46-004601 REIMB-LEGAL EXPENSES 6,032 1,043 1,140 1,090 8,976 2,672 324 4,746 555 26,578 12,000 221.48% 01-000-46-00-4604 REIMB-ENGINEERING EXPENSES 5,488 - 1,513 966 7,967 - 0.00% 01-000-46-00-4650 REDAB-TRAFFIC SIGNAL - - - - - - 28,582 - - 28,582 15,000 190.54% 01-000-46-00-4668 REIMB-COBRA CONTRIBUTIONS - 2,362 3,934 - 2,200 2,200 3,543 2,200 1,756 18,196 20,000 90.98% 01-000-46-00-4669 REIMB-RETIREE CONTRIBUTIONS 3,475 4,429 4,428 4,428 5,380 2,942 3,894 4,847 2,942 36,764 50,000 73.53% 01-000-46-00-4670 REIMB-EMP INS CONTRIBUTIONS 8,166 8,023 7,408 7,498 7,379 8,368 7,309 7,402 7,287 68,837 190,000 36.23% 01-000-46-00-4671 REIMB-LIFE INSURANCE 325 320 280 270 270 311 253 267 267 2,564 4,800 53.41% 01-000-46-00-4672 REIMB-LIBRARY INSURANCE 7,657 7,228 7,934 - 15,868 7,934 7,934 7,934 7,934 70,421 - 0.00% 01-000-46-00-4680 REIMB-LIABILITY INSURANCE - 706 22,083 508 - 1,818 896 - 195 26,206 5,000 524.13% 01-000-46-00-4681 REIMB-WORKERS COMP 18,853 - - - - - - 18,853 - 0.00% 01-000-46-00-4685 REIMB-CABLE CONSORTIUM 19,505 - - - - 19,039 - - - 38,544 40,000 96.36% 01-000-46-00-4690 REIMB-MISCELLANEOUS 416 703 296 1,952 454 2,605 2,998 396 884 10,705 4,000 267.64% 01-000-48-00-4820 RENTAL INCOME 1,100 545 630 655 970 545 610 655 600 6,310 9,000 70.11% 01-000-48-00-4845 DONATIONS 50 - - - - - - - - 50 2,000 2.50% 01-000-48-00-4850 MISCELLANEOUS INCOME - - (13) 1,693 - 16 0 - 195 1,891 5,000 37.83% 01-000-49-00-4951 TRANSFER FROM WATER 7,655 7,655 7,655 7,655 7,655 7,655 7,655 7,655 7,655 68,897 91,863 75.00% 01-000-49-00-4952 TRANSFER FROM SEWER 6,920 6,920 6,920 6,920 6,920 6,920 6,920 6,920 6,920 62,284 83,045 75.00% 01-000-49-00-4972 TRANSFER FROM LAND CASH 1,674 1,674 1,674 1,674 1,674 1,674 1,674 1,674 1,674 15,063 20,084 75.00% 01-000-49-00-4984 TRANSFER FROM LIBRARY DVLP - - 328,644 328,644 332,500 98.84% TOTAL REVENUES:GENERAL FUND 901,625 1,889,075 630,030 1 1,243 931 1,652 500 1,044,652 873,711 886,276 617,447 9,739 247 11,823 874 82.37% 1 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-71 June-71 July-11 August-11 September-11 October-11 November-11 December-11 January-12 Totals BUDGET %of Budget ADMINISTRATION EXPENDITURES 01-110-50-00-5001 SALARIES-MAYOR 860 925 860 825 825 860 860 825 825 7,665 11,000 69.68% 01-110-50-00-5002 SALARIES-LIQUOR COMM 83 83 83 83 83 83 83 83 83 750 1,000 75.01% 01-110-50-00-5003 SALARIES-CITY CLERK 777 742 642 742 642 642 777 742 742 6,445 9,000 71.61% 01-110-50-00-5004 SALARIES-CITY TREASURER 500 500 400 500 500 500 500 500 500 4,400 6,500 67.69% 01-110-50-00-5005 SALARIES-ALDERMAN 4,175 4,200 4,145 4,000 3,900 4,280 4,145 3,800 3,800 36,445 50,320 72.43% 01-110-50-00-5010 SALARIES-ADMINISTRATION 14,330 14,537 18,100 18,100 27,149 18,099 18,099 19,567 18,099 166,081 195,000 85.17% 01-110-50-00-5020 OVERTIME - - 113 119 - 138 660 - - 1,030 575 179.20% 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,735 1,843 2,187 2,184 3,023 2,212 2,249 2,293 2,183 19,908 25,000 79.63% 01-110-52-00-5214 FICA CONTRIBUTION 1,434 1,446 1,690 1,692 2,324 1,710 1,750 1,780 1,668 15,494 20,106 77.06% 01-110-54-00-5412 TRAINING&CONFERENCES - 339 25 - 605 620 27 72 - 1,688 3,000 56.27% 01-110-54-00-5415 TRAVEL&LODGING - - - 1,565 - - 1,565 - 0.00% 01-110-54-00-5423 PUBLIC RELATIONS - - - - - - 150 0.00% 01-110-54-00-5426 PUBLISHING&ADVERTISING 6 - 10 151 13 87 235 - 502 2,000 25.11% 01-110-54-00-5430 PRINTING&DUPLICATION 292 753 - 668 326 512 371 770 3,691 6,750 54.68% 01-110-54-00-5440 TELECOMMUNICATIONS 596 1,052 1,062 1,195 1,306 1,174 1,186 1,179 8,751 21,200 41.28% 01-110-54-00-5451 CODIFICATION - - - - - 2,483 - 500 2,983 8,000 37.29% 01-110-54-00-5452 POSTAGE&SHIPPING 142 3,197 (579) 117 117 196 185 76 3,452 14,000 24.66% 01-110-54-00-5462 PROFESSIONAL SERVICES 2,210 2,051 1,878 1,001 2,963 105 (929) 916 10,194 11,000 92.67% 01-110-54-00-5473 KENDALL COUNTY PARATRANSIT - - - - - - - 11,775 11,775 30,000 39.25% 01-110-54-00-5480 UTILITIES - 764 657 612 814 678 1,183 - 1,703 6,411 28,000 22.90% 01-110-54-00-5485 RENTAL&LEASE PURCHASE 143 143 143 143 143 143 143 986 143 2,130 - 0.00% 01-110-54-00-5488 OFFICE CLEANING - - 1,196 1,196 1,196 1,196 2,392 143 1,046 8,365 14,400 58.09% 01-110-54-00-5490 DUES&SUBSCRIPTIONS 1,384 6,174 230 592 95 - 1,179 1,196 2,600 13,450 16,600 81.02% 01-110-56-00-5610 OFFICE SUPPLIES 70 2,295 166 191 564 103 700 1,453 587 6,129 15,000 40.86% 01-110-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - - - - - - 850 0.00% 01-110-56-00-5640 REPAIR&MAINTENANCE - - - - - - - 69 69 100 69.00 TOTAL EXPENDITURES:ADMINISTRATION 25,492 37,236 37,692 33 350 44,995 37,553 39,304 34,488 49,264 339,374 489,551 69.32% FINANCE EXPENDITURES 01-120-50-00-5010 SALARIES&WAGES 12,812 13,604 12,812 12,812 19,218 12,812 12,812 15,084 12,812 124,780 175,000 71.30% 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTIO 1,233 1,308 1,233 1,247 1,856 1,247 1,247 1,463 1,264 12,098 17,500 69.13% 01-120-52-00-5214 FICA CONTRIBUTION 967 1,028 974 985 1,473 985 985 1,159 985 9,542 13,005 73.37% 01-120-54-00-5412 TRAINING&CONFERENCES - - - - - - - 195 95 290 2,000 14.50% 01-120-54-00-5414 AUDITING SERVICES 2,000 12,000 13,000 11,000 6,800 - - 44,800 45,000 99.56% 01-120-54-00-5415 TRAVEL&LODGING - - - - - 70 45 115 1,000 11.53% 01-120-54-00-5430 PRINTING&DUPLICATING - - 500 0.00% 01-120-54-00-5440 TELECOMMUNICATIONS 45 45 45 45 45 45 45 45 360 600 60.00% 01-120-54-00-5452 POSTAGE&SHIPPING - - 107 5 - 112 500 22.38% 01-120-54-00-5460 DUES&SUBSCRIPTIONS 80 - 35 - - - - - 170 285 850 33.53% 01-120-54-00-5462 PROFESSIONAL SERVICES 1,847 1,945 56 290 78 1,138 2,598 11,359 155 19,467 42,000 46.35% 01-120-54-00-5485 RENTAL&LEASE PURCHASE 143 1,615 879 143 143 143 143 1,543 143 4,895 15,000 32.63% 01-120-54-00-5495 OUTSIDE REPAIR&MAINTENANC - - - - 250 - - - - 250 1,800 13.89° 01-120-56-00-5610 OFFICE SUPPLIES 343 128 136 - 270 97 297 1,271 2,500 50.84% 01-120-56-00-5630 SMALL TOOLS&EQUIPMENT - - - - - - - 250 0.00% 01-120-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 797 797 2,500 31.89% 01-120-56-00-5640 REPAIR&MAINTENANCE - - - - - - - - - - 500 0.00% TOTAL EXPENDITURES:FINANCE 17,082 19,888 18,161 27,766 36,063 27,646 25,427 31,015 16,012 219,061 320 505 68.35% COMMUNITY RELATIONS EXPENDITURES O1-130-54-00-5426 PUBLISHING&ADVERTISING 333 1 - 333 1 333 100.00% TOTAL EXPENDITURES:COMMUNITY RELATIONS 333 333 333 100.00% ENGINEERING EXPENDITURES 01-150-50-00-5010 SALARIES&WAGES 12,929 55,188 10,006 78,123 172,000 45.42% 01-150-50-00-5020 OVERTIME - - - - 500 0.00% 01-150-52-00-5212 RETIREMENT PLAN CONTRIBUTIO 1,230 5,248 952 7,430 16,500 45.03% 01-150-52-00-5214 FICA CONTRIBUTION 960 4,193 765 5,918 13,236 44.71% 01-150-54-00-5412 TRAINING&CONFERENCES - - - - 2,250 0.00% 01-150-54-00-5415 TRAVEL&LODGING - 3 3 400 0.80% 01-150-54-00-5430 PRINTING&DUPLICATING 38 139 109 286 1,500 19.07% UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-11 October-11 November-11 December-11 January-12 Totals BUDGET %of Budget 01-150-54-00-5440 TELECOMMUNICATIONS 104 103 207 2,200 9.39% 01-150-54-00-5452 POSTAGE&SHIPPING - - 23 23 500 4.50% 01-150-54-00-5460 DUES&SUBSCRIPTIONS - - - - - 1,200 0.00% 01-150-54-00-5462 PROFESSIONAL SERVICES 508 1,098 98 - - 198 - - 1,901 32,550 5.84% 01-150-54-00-5485 RENTAL&LEASE PURCHASE 137 137 137 137 137 137 137 137 137 1,229 - 0.00% 01-150-54-00-5495 OUTSIDE REPAIR&MAINTENANC - 27 - - - - - - - 27 1,500 1.81% 01-150-56-00-5600 WEARING APPAREL 100 0.00% 01-150-56-00-5610 OFFICE SUPPLIES 7 7 1,000 0.70% 01-150-56-00-5622 ENGINEERING SUPPLIES 1,500 0.00% 01-150-56-00-5630 SMALL TOOLS&EQUIPMENT 500 0.00% 01-150-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 4,550 0.00% 01-150-56-00-5640 REPAIR&MAINTENANCE - 1,000 0.00% O]-150-56-00-5645 BOOKS&PUBLICATIONS - - - - - - 150 0.00% TOTAL EXPENDITURES:ENGINEERING 15,255 65,450 13,199 257 249 137 334 137 137 95,153 253,136 37.59% POLICE EXPENDITURES 01-210-50-00-5010 SALARIES-POLICE OFFICERS 87,672 95,900 85,295 78,245 120,451 88,252 87,352 90,619 91,379 825,165 1,250,000 66.01% 01-210-50-00-5012 SALARIES-LIEUT/SERGEANTS/CHIEF 44,835 49,174 51,592 46,735 66,038 44,215 44,847 47,283 47,230 441,949 610,000 72.45% 01-210-50-00-5013 SALARIES-POLICE CLERKS 11,204 15,227 7,747 8,715 14,557 9,468 9,411 9,922 9,423 95,674 120,000 79.73% 01-210-50-00-5014 SALARIES-CROSSING GUARD 1,110 583 - - 1,193 1,029 1,110 931 611 6,566 20,000 32.83% 01-210-50-00-5015 PART-TIME SALARIES 6,068 3,090 4,155 2,990 5,923 2,928 2,837 3,423 2,562 33,977 39,000 87.12% 01-210-50-00-5017 CADET PROGRAM 875 1,375 1,247 1,231 - - - - 1,208 5,936 13,500 43.97% 01-210-50-00-5020 OVERTIME 6,970 6,898 12,214 6,859 14,226 8,799 6,903 7,062 12,074 82,006 75,000 109.34% 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTIO 1,075 1,417 624 742 1,290 860 860 860 871 8,598 15,900 54.07% 01-210-52-00-5213 EMPLOYER CONTRI-POE PEN 57,847 119,062 4,521 44,426 117,395 10,431 6,673 - - 360,356 375,000 96.09% 01-210-52-00-5214 FICA CONTRIBUTION 11,692 12,762 11,978 10,642 16,444 11,377 11,201 11,716 12,125 109,936 170,000 64.67% 01-210-54-00-5410 TUITION REIMBURSEMENT - - - - 1,510 - - - - 1,510 2,800 53.93% 01-210-54-00-5411 POLICE COMMISSION 563 - - 581 590 1,219 2,242 24 9,614 14,832 15,000 98.88% 01-210-54-00-5412 TRAINING&CONFERENCES 50 920 150 (230) 495 - 418 2,295 3,178 7,276 12,000 60.64% 01-210-54-00-5415 TRAVEL&LODGING 183 1,264 83 946 195 (332) 1,057 2,150 19 5,566 10,000 55.66% 01-210-54-00-5426 PUBLISHING&ADVERTISING - - - 11 - - - - - 11 200 5.60% 01-210-54-00-5430 PRINTING&DUPLICATING 87 143 120 74 111 70 761 1,437 2,804 4,500 62.31% 01-210-54-00-5440 TELECOMMUNICATIONS 1,757 1,748 1,927 3,077 2,892 2,908 1,856 1,874 18,039 36,500 49.42% 01-210-54-00-5452 POSTAGE&SHIPPING 11 81 26 259 (60) 47 - - 35 399 3,000 13.30% 01-210-54-00-5460 DUES&SUBSCRIPTIONS 90 80 (20) 210 50 - 100 25 170 705 1,350 52.22% 01-210-54-00-5462 PROFESSIONAL SERVICES 85 598 1,034 141 300 228 990 3,428 6,804 4,000 170.10% 01-210-54-00-5466 LEGAL SERVICES - - - - - - - - - - 10,000 0.00% 01-210-54-00-5467 ADMEN ADJ-HEARING OFFICER 325 1,400 2,260 975 2,100 1,000 1,600 1,518 564 11,742 15,000 78.28% 01-210-54-00-5469 NEW WORLD LIVE SCAN - - - - - 8,949 - - - 8,949 15,000 59.66% 01-210-54-00-5472 KENDALL CO.JUVE PROBATION - - 2,389 2,389 3,000 79.62% 01-210-54-00-5484 MDT-ALERTS FEE 3,330 - - - - 3,330 - - - 6,660 6,660 100.00% 01-210-54-00-5485 RENTAL&LEASE PURCHASE 277 277 352 427 352 352 352 352 352 3,093 - 0.00% 01-210-54-00-5495 OUTSIDE REPAIR&MAINTENANCI 1,125 2,537 2,810 2,610 8,411 2,901 928 3,851 3,300 28,473 51,000 55.83% 01-210-56-00-5600 WEARING APPAREL 375 - 1,290 611 725 2,795 685 8,369 1,190 16,040 10,000 160.40% 01-210-56-00-5610 OFFICE SUPPLIES - 91 196 245 269 - 422 95 359 1,677 4,000 41.93% 01-210-56-00-5620 OPERATING SUPPLIES 13 787 148 550 54 4 95 318 4 1,972 8,000 24.65% 01-210-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - 55 312 70 300 - 628 1,365 7,000 19.50% 01-210-56-00-5640 REPAIR&MAINTENANCE 1,554 576 875 - 1,171 - 4,175 12,250 34.08% 01-210-56-00-5669 GREAT PROGRAM - - - 3,000 0.00% 01-210-56-00-5670 COMMUNITY RELATIONS 45 45 500 9.02% 01-210-56-00-5673 NEIGHBORHOOD WATCH 1,531 0.00% 01-210-56-00-5674 CITIZENS POLICE ACADEMY 1,839 0.00% 01-210-56-00-5678 COMPLIANCE CHECKS - - 7 7 500 1.41% 01-210-56-00-5690 ISUPPLIES-GRANT REIMBURSABL 69 - - 3,030 - - - - 3,099 4,200 73.79% 01-210-56-00-5695 IGASOLINE 7,814 1 7,028 7,473 6,531 6,368 5,861 5,410 5,324 51,809 85,000 60.95 01-210-56-00-5696 AMMUNITION - - - - 2,000 0.00% TOTAL EXPENDITURES:POLICE 235,690 324,292 196,183 218,967 386,292 207,365 188,466 201,000 211,348 2,169,603 3,018,230 71.88% COMMUNITY DEVELOPMENT EXPENDITURES 01-220-50-00-5010 ISALARIES&WAGES 17,750 1 26,622 1 11,148 1 8,690 1 20,292 1 15,444 1 15,078 1 13,960 1 13,479 0 142,463 1 240,000 59.36% 3 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-ll October-11 November-11 December-11 January-12 Totals BUDGET %of Budget 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTIO 1,688 2,532 1,060 826 1,807 1,298 1,268 1,298 1,295 13,072 27,275 47.93% 01-220-52-00-5214 FICA CONTRIBUTION 1,279 1,958 831 643 1,523 1,155 1,127 1,041 1,007 10,561 17,260 61.19% 01-220-54-00-5412 TRAINING&CONFERENCES - - - - - 480 79 - 305 864 1,200 72.00% 01-220-54-00-5415 TRAVEL&LODGING 21 226 - 247 700 35.36% 01-220-54-00-5426 PUBLISHING&ADVERTISING - - 64 - - - - - 64 150 42.40% 01-220-54-00-5430 PRINTING&DUPLICATING 38 60 - 109 74 115 110 39 544 1,500 36.27% 01-220-54-00-5440 TELECOMMUNICATIONS 109 108 112 111 187 150 148 148 1,075 1,500 71.67% 01-220-54-00-5452 POSTAGE&SHIPPING - - 63 - - - - - 63 500 12.53% 01-220-54-00-5459 INSPECTIONS 680 - 7,061 6,128 7,701 1,120 1,270 1,190 25,150 20,000 125.75% 01-220-54-00-5460 DUES&SUBSCRIPTIONS 422 453 - - - - - 75 950 1,500 63.33% 01-220-54-00-5462 PROFESSIONAL SERVICES - - 562 94 - 656 6,000 10.93% 01-220-54-00-5466 LEGAL SERVICES - 101 44 846 - 101 - - 856 1,948 6,400 30.44% 01-220-54-00-5485 RENTAL&LEASE PURCHASE 137 137 137 137 137 137 137 137 137 1,229 - 0.00% 01-220-54-00-5486 ECONOMIC DEVELOPMENT - - - - - - - - 45,000 45,000 45,000 100.00% 01-220-56-00-5610 OFFICE SUPPLIES 16 52 67 3 - 138 500 27.59% 01-220-56-00-5620 OPERATING SUPPLIES I - - 79 29 233 242 13 596 3,000 19.87% 01-220-56-00-5630 SMALL TOOLS&EQUIPMENT - - - 125 0.00% 01-220-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - 2,500 0.00% O1-220-56-00-5645 BOOKS&PUBLICATIONS - - 394 - - - 394 500 78.88% TOTAL EXPENDITURES:COMMUNITY DEVELP 20,854 32 614 13 920 19 003 30,189 27,384 19,544 17 976 63 530 245,013 375,610 65.23% PUBLIC WORKS-STREET OPERATIONS EXPENDITURES 01-410-50-00-5010 SALARIES&WAGES 18,990 19,377 19,377 19,377 30,015 19,377 19,377 19,377 19,377 184,640 270,000 68.39% 01-410-50-00-5020 OVERTIME - - - 71 89 - 239 744 1,855 2,998 15,000 19.99% 01-410-52-00-5212 RETIREMENT PLAN CONTRIBUTIO 1,806 1,843 1,843 1,849 2,863 1,843 1,865 1,913 2,047 17,872 30,000 59.57% 01-410-52-00-5214 FICA CONTRIBUTION 1,408 1,438 1,438 1,443 2,251 1,438 1,457 1,493 1,578 13,944 23,500 59.33% 01-410-54-00-5412 TRAINING&CONFERENCES - - - - - - - - - - 2,000 0.00% 01-410-54-00-5440 TELECOMMUNICATIONS 198 196 205 204 192 200 195 217 1,608 4,020 40.00% 01-410-54-00-5455 MOSQUITO CONTROL 6,500 - - - - - - - 6,500 7,000 92.86% 01-410-54-00-5458 TREE&STUMP REMOVAL 400 - 2,275 300 - 1,825 1,225 - 6,025 10,000 60.25% 01-410-54-00-5462 PROFESSIONAL SERVICES 84 46 20 66 20 109 - 600 945 1,000 94.51% 01-410-54-00-5480 UTILITIES 5,199 6,868 6,988 3,865 3,605 4,144 4,200 9,276 44,145 80,000 55.18% 01-410-54-00-5485 RENTAL&LEASE PURCHASE 33 540 33 33 33 33 182 33 33 952 1,000 95.24% 01-410-54-00-5495 OUTSIDE REPAIR&MAINTENANC 275 - 845 1,486 3,969 2,826 1,675 - 11,075 30,000 36.92% 01-410-56-00-5600 WEARING APPAREL 93 144 174 259 126 228 260 316 84 1,684 5,000 33.68% 01-410-56-00-5620 OPERATING SUPPLIES 34 1,632 1,564 949 377 766 647 22 257 6,248 9,500 65.77% 01-410-56-00-5626 HANGING BASKETS 1,832 209 - - - - - - 2,041 2,000 102.06% 01-410-56-00-5630 SMALL TOOLS&EQUIPMENT 64 (64) - - - - - - 29 29 1,750 1.65% 01-410-56-00-5640 REPAIR&MAINTENANCE 2,780 1,251 2,192 3,281 945 1,342 4,473 665 16,929 36,500 46.38% 01-410-56-00-5656 PROPERTY&BUILDING MAINT 66 1,238 664 2,471 1,241 115 611 2,416 652 9,474 30,000 31.58% 01-410-56-00-5695 GASOLINE 2,886 1,279 2,914 4,062 2,185 1,685 3,235 1,293 19,538 33,600 58.15% O1-410-60-00-6041 SIDEWALK CONSTRUCTION I - - - 734 135 - - - 869 4,000 21.73% TOTAL EXP:PUBLIC WORKS-STREET OPS 22,494 46,299 34,940 42,626 50,392 34,715 36,769 41,318 37,962 347,516 595,870 58.32% PW-HEALTH&SANITATION EXPENDITURES 01-540-54-00-5442 GARBAGE SERVICES 100,361 1 - 200,660 1 99,975 1 100,018 1 99,803 1 99,438 1 99,352 E 799,606 1 1,195,000 1 66.91% 01-540-54-00-5443 ILEAFPICKUP 600 1 - 4,320 E 4,920 6,000 1 82.00% TOTAL EXPENDITURES:PW HEALTH&SAN m 100,361 600 200,660 99,975 100,018 99,803 99,438 103,672 E 804,526 1,201,000 66.99% ADMINISTRATIVE SERVICES EXPENDITURES 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES 350 - - - - - - - 350 5,000 7.00% 01-640-52-00-5216 GROUP HEALTH INSURANCE 201,872 113,613 97,253 97,135 88,841 90,913 12,522 171,646 19,716 893,510 1,204,000 74.21% 01-640-52-00-5222 GROUP LIFE INSURANCE 1,275 1,237 1,252 1,035 1,161 1,166 1,162 1,145 1,158 10,592 26,000 40.74% 01-640-52-00-5223 DENTAL&VISION INSURANCE 15,474 9,695 7,432 8,431 7,952 7,784 839 15,310 839 73,755 114,000 64.70% 01-640-52-00-5224 EMPLOYEE ASSISTANCE - - - - - - - - - - 150 0.00% 01-640-52-00-5230 UNEMPLOYMENT INSURANCE 12,508 - 18,762 - - 18,762 - 8,584 - 58,615 60,000 97.69% 01-640-52-00-5231 LIABILITY INSURANCE 49,629 53,504 10,470 10,470 53,504 10,470 18,913 79,023 285,983 339,200 84.31 01-640-54-00-5456 CORPORTATE COUNSEL 11,046 8,493 9,889 14,193 5,708 8,150 3,544 5,491 66,512 130,000 51.16% 01-640-54-00-5461 LITIGATION COUNSEL 65 10,719 10,750 8,255 3,809 12,890 6,528 53,016 60,000 88.36% 01-640-54-00-5462 PROFESSIONAL SERVICES 450 5,843 2,160 - 40,486 11,150 444 25 60,558 50,000 121.12% 01-640-54-00-5463 SPECIAL COUNSEL 135 5,785 495 270 1,080 2,448 1,960 12,172 25,000 48.69% UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-I I June-11 July-11 August-11 September-11 October-11 November-11 December-11 January-12 Totals BUDGET %of Budget 01-640-54-00-5465 ENGINEERING SERVICES - - 15,732 13,353 136,575 19,340 184,999 - 0.00% 01-640-54-00-5475 CABLE CONSORTIUM FEE - 19,039 19,620 - - - 19,508 58,167 85,000 68.437/. 01-640-54-00-5479 COMMUNITY RELATIONS 440 - - - - - - 440 - 0.00% 01-640-54-00-5481 HOTEL TAX REBATE 3,612 5,416 5,310 4,516 5,888 3,711 2,379 30,833 27,540 111.96% 01-640-54-00-5491 CITY PROPERTY TAX REBATE - - - 1,532 - - - 1,532 1,050 145.89% 01-640-54-00-5492 SALES TAX REBATE - 322,675 168,802 - 1,720 170,364 11,649 675,210 900,000 75.02% 01-640-54-00-5493 BUSINESS DISTRICT REBATE 23,787 24,471 27,616 23,037 22,407 25,315 22,054 168,688 300,000 56.23% 01-640-54-00-5494 ADMISSIONS TAX REBATE - - - - 104,845 - - 104,845 114,000 91.97% 01-640-54-00-5499 BAD DEBT - - - 1,250 0.00% 01-640-56-00-5625 REIMBURSEABLE REPAIRS 2,655 2,655 5,000 53.09% 01-640-70-00-7799 CONTINGENCIES - - - - - - - - 64,617 0.00% 01-640-99-00-9923 TRANSFER TO CITY WIDE CAPIT 10,417 10,417 10,417 10,417 10,417 10,417 10,417 10,417 10,417 93,750 125,000 75.00% 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 8,645 8,645 8,645 1 8,645 8,645 8,645 8,645 8,645 8,645 77,805 103,740 75.00% 01-640-99-00-9979 1 TRANSFER TO PARK&RECREATION 61,059 61,059 61,059 61,059 61,059 61,059 65,059 61,059 61,059 553,533 732,710 75.55% 01-640-99-00-9982 TRANSFER TO LIBRARY OPS - - 328,644 328,644 332,500 98.84 TOTAL EXPENDITURES:ADMIN SERVICES 361,328 275,608 268,125 591,593 475,870 622,480 277,706 653,664 269 790 3,796 163 4,805,757 78.99% TOTAL FUND REVENUES 901,625 1,889,075 630,030 1,243 931 1,652 500 1,044,652 873,711 886,276 617,447 9,739,247 11,823,874 82.37% TOTAL FUND EXPENDITURES 698,195 902,080 582,820 1,134,222 1,124,024 1,057,297 687,353 1,079,036 751,715 8,016,742 11,059,992 72.49 FUND SURPLUS(DEFICIT) 203,430 986,995 47,210 109,709 1 528,476 12,645 186,358 192,760 (134,268)M 1,722,505 1 763,882 FOX HILL SSA REVENUES 11-000-40-00-4011 PROPERTY TAXES-FOX HILL SSA 599 1,272 64 576 1,126 88 60 m 3,786 3,786 100.00% 11-000-45-00-4500 1 INVESTMENT EARNINGS m 01 11 1 1 1 1 1 1 11 1 I 1 m 6 - 0.00% TOTAL REVENUES:FOX HILL SSA 599 1 1,273 1 64 1 577 1 1,1271 89 1 61 1 1 1 m 3,792 3 786 1 100.15% FOX BILL SSA EXPENDITURES 11-111-54-00-5495 OUTSIDE REPAIR&MAINTENANC 614 767 614 614 767 614 307 4,295 3,804 112.92 TOTAL FUND REVENUES 599 1,273 64 577 1,127 89 61 1 1 3,792 3,786 100.15 TOTAL FUND EXPENDITURES 614 767 614 614 767 614 307 4,295 3,804 1 112.92 FUND SURPLUS(DEFICIT) m 5991 659 (703) (37)1 513 678 553 306) 1 504 (18)1 1 SUNFLOWER SSA REVENUES 12-000-40-00-4012 PROPERTY TAXES-SUNFLOWER SSE 1,3621 2,2841 1181 1,391 1 1,937 1 84 1 354 1 - 7,530 1 7,530 100.00% 12-000-45-00-4500 IfNVESTMENT EARNINGS m 01 1 1 1 1 1 1 1 1 1 1 1 1 01 ON 7 - 0.00% TOTAL REVENUES:SUNFLOWER SSA 1,3621 2,284 1 1201 1,3921 1,9381 85 1 355 1 0 1 7,537 7,530 1 100.09 SUNFLOWER SSA EXPENDITURES 12-112-54-00-5495 1 OUTSIDE REPAIR&MAINTENANC 1,309 1 650 1 1,309 1 1,309 1 1,439 1 520 1 385 1 6,921 1 9,078 76.24 TOTAL FUND REVENUES 1,362 2,284 1 120 1,392 1,938 1 85 355 0 0 7,537 1 7,530 100.09% TOTAL FUND EXPENDITURES 1,3091 650 1 1,3091 1,3091 1,4391 5201 385 1 m 6,921 1 9,078 1 76.24 FUND SURPLUS EFICIT 1,362 1 975 530 83 1 629 1,354 165 385 0 m 616 1,548 5 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL 1ACCOUNT NUMBER DESCRIPTION May-71 June-1l July-11 August-11 September-11 October-I1 November-11 December-11 January-12 Totals BUDGET %.f Budget MOTOR FUEL TAX REVENUES 15-000-41-00-4112 MOTOR FUEL TAX 34,752 34,093 31,723 36,973 36,308 32,528 36,140 38,180 35,591 316,288 355,000 89.10% 15-000-41-00-4113 MET HIGH GROWTH - - - - - - - - - - 20,000 0.00% 15-000-41-00-4172 ILLINOIS JOBS NOW PROCEEDS 73,122 73,122 142,000 51.49% 15-000-45-00-4500 INVESTMENT EARNINGS 29 28 24 25 26 28 51 69 69 349 1,000 34.93% 15-000-46-00-4605 REIMB-OLD JAIL/DWTWN PARKIN - - 493,000 0.00% 15-000-46-00-4690 REIMB-MISCELLANEOUS 0.00% 15-000-48-00-4850 IMISCELLANEOUS INCOME 0.00% TOTAL REVENUES:MOTOR FUEL TAX 34,781 34,122 31,747 110,120 36,334 32,556 36,191 38,249 35,660 389,760 1,011,000 38.55 MOTOR FUEL TAX EXPENDITURES 15-155-56-00-5618 SALT - - - - - - - 39,614 - 39,614 220,000 18.01% 15-155-56-00-5619 SIGNS 1,426 1,966 999 348 27 362 5,127 18,000 28.48% 15-155-56-00-5632 PATCHING - - - - - - - - 50,000 0.00% 15-155-56-00-5633 COLD PATCH - - - - - 1,431 1,009 2,440 10,600 23.02% 15-155-56-00-5634 HOT PATCH 1,728 2,729 3,044 988 2,045 750 - 11,284 13,000 86.80% 15-155-60-00-6072 DOWNTOWN PARKING LOT - - - - 875 - - - 875 55,000 1.59% 15-155-60-00-6073 GAME FARM ROAD PROJECT 28,200 4,400 6,400 19,177 7,970 1,940 68,086 150,000 45.39% 15-155-60-00-6075 IRIVER ROAD BRIDGE PROJECT 1 1021 920 1 (1,022) 25,000 0.00% 15-155-60-00-6079 IROUTE 47 EXPANSION 1 2,379 7,859 36,855 1 m 47,093 119,400 39.44% TOTAL FUND REVENUES 9r 34,781 34,122 31,747 110,120 36,334 32,556 36,191 38,249 35,660 389,760 1,011,000 38.55% TOTAL FUND EXPENDITURES 28,200 6,128 10,555 5,010 2,861 24,051 18,956 77,748 1,009 E 174,518 661,000 26.40% FUND SURPLUS EFICIT 6,581 27,993 21 192 105,110 33,472 8,505 1 17 235 39,499 34,651 E 215,241 1 350,000 MUNICIPAL BUILDING REVENUES 16-000-42-00-4214 1 DEVELOPMENT FEES 1,050 300 750 300 2,700 300 300 5,700 5,250 108.57% TOTAL REVENUES:MUNICIPAL BUILDING 1,050 300 750 300 2,700 300 300 5,700 5,250 1 108.57% TOTAL FUND REVENUES 1,050 300 750 300 2,700 300 300 5,700 5,250 108.57 TOTAL FUND EXPENDITURES FUND SURPLUS(DEFICIT) m 1,050 300 750 300 2,700 300 300 5,700 5,250 POLICE CAPITAL REVENUES 20-000-42-00-4214 DEVELOPMENT FEES 1,800 300 1,500 450 5,250 450 450 10,200 10,500 97.14% 20-000-42-00-4217 WEATHER WARNING SIREN FEES - - - - - - - - 6,000 0.00% 20-000-43-00-4315 DUI FINES 1,127 323 261 136 18 455 155 158 93 2,726 - 0.00% 20-000-43-00-4316 ELECTRONIC CITATION FEE - 184 54 60 70 62 78 46 58 612 - 0.00% 20-000-43-00-4340 SEIZED VEHICLE PROCEEDS - - - - - 1,585 - 1,585 5,000 31.70% 20-000-45-00-4500 INVESTMENT EARNINGS 5 4 4 4 4 4 4 7 7 44 - 0.00% 20-000-48-004880 1 SALE OF FIXED ASSETS 1,200 - - 12,700 - 13,900 0.00% TOTAL REVENUES:POLICE CAPITAL 4,132 812 1,819 650 5,341 971 14,972 211 158 E 29,067 21,500 135.20 POLICE CAPITAL EXPENDITURES 20-200-54-00-5462 PROFESSIONAL SERVICES 95 2,350 2,445 1,500 163.00% 20-200-54-00-5495 OUTSIDE REPAIR&MAINTENANC - I I I I I I I - 10,000 1 0.00% 20-200-56-00-5620 OPERATING SUPPLIES 2,500 0.00% 20-200-60-00-6060 EQUIPMENT 20,000 0.00% 20-200-60-00-6070 VEHICLES 20,000 0.00% TOTAL FUND REVENUES 4,132 812 1,819 650 5,341 971 14,972 211 158 29,067 21,500 135.20 TOTAL FUND EXPENDITURES W 95 2,350 2,445 1 54,000 1 4.53 FUND SURPLUS(DEFICIT) m 4,037 812 1,819 650 5,341 1 971 1 14,972 1 (2,139)1 158 E 26,622 1 (32,500 6 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL IACCOUNT NUMBER DESCRIPTION May-II June-1l July-11 August-11 September-11 October-11 November-11 December-11 January-12 Totals BUDGET %.f Budget PUBLIC WORKS CAPITAL REVENUES 21-000-42-00-4214 DEVELOPMENT FEES 4,400 900 3,500 1,150 12,350 1,150 1,150 - 24,600 24,500 100.41% 21-000-44-00-4418 MOWING INCOME 419 3,430 2,193 713 (494) 1,790 676 (2,250) (188) 6,290 7,900 79.62% 21-000-45-00-4500 INVESTMENT EARNINGS 3 2 2 2 2 2 2 2 2 18 - 0.00% 21-000-48-00-4850 MISCELLANEOUS INCOME - - - - - - - - - 0.00% 21-000-48-00-4880 SALE OF FIXED ASSETS - - - - - - - - - - - 0.00% 21-000-49-00-4922 TSFR FROM PARK&REC CAPITAL 292 292 292 292 292 292 292 292 292 2,625 3,500 75.00% TOTAL REVENUES:PW CAPITAL REVENUES 5,114 4,624 5,986 2,157 12,149 3,234 2,119 1,955 106 33 533 35,900 93.41% PUBLIC WORKS CAPITAL EXPENDITURES 21-211-54-00-5462 PROFESSIONAL SERVICES - 980 49 294 245 323 235 98 352 2,576 1,800 143.11% 21-211-54-00-5485 RENTAL&LEASE PURCHASE - - - 4,000 - - - 4,000 4,500 88.89% 21-211-56-00-5620 OPERATING SUPPLIES - - 2,000 0.00% 21-211-60-00-6060 EQUIPMENT 2,000 0.00% 21-211-60-00-6070 VEHICLES - - - - - - - - - - - 0.00% 21-211-92-00-8000 PRINCIPLE PAYMENT-PW BUILDING 4,587 2,312 2,324 2,336 2,348 2,360 2,373 2,385 2,397 23,422 28,254 82.90% 21-211-92-00-8050 INTEREST PAYMENT-PWBUILDING 9,129 4,546 4,534 4,522 4,510 4,498 41485 4,473 4,461 45,158 54,041 83.56% TOTAL FUND REVENUES 5,114 4,624 5,986 2,157 12,149 1 3,234 1 2,119 1,955 106 E 33,533 1 35,900 1 93.41% TOTAL FUND EXPENDITURES W 13,716 7,838 6,907 7,152 11,103 1 7,181 1 7,093 1 6,956 1 7,210 M 75,155 1 92,595 1 81.17 FUND SURPLUS(DEFICIT) m (8,602)1 (3,214)1 (921 4,995 1,046 1 (3,947)1 (4,974)1 (8,911) (7,104)E (41,622)1 (56,695 PARK&RECREATION CAPITAL REVENUES 22-000-42-00-4215 PARKS CAPITAL FEES 250 500 950 1,700 1,750 97.14% 22-000-45-00-4500 INVESTMENT EARNINGS 8 8 8 10 37 37 35 38 38 219 80 273.23% 22-000-46-00-4690 REIMBURSEMNT-MISCELLANEOU - I I I - 1 1 10,702 1 - 10,702 1 - 0.00% 22-000-48-00-4880 SALE OF FIXED ASSETS m - I I 1 900 - 900 1 1,000 90.00% TOTAL REVENUES:PARK&RECREATION CAPITAL E 258 1 81 81 1,4101 37 1 10,739 1 985 1 38 1 38 E 13,521 1 2,830 1 477.77% PARK&RECREATION CAPITAL EXPENDITURES 22-222-60-00-6012 CRAWFORD PARK TRAIL 0.00% 22-222-60-00-6035 RAINTREE PARK 120,000 0.00% 22-222-60-00-6042 BASEBALL FIELD CONSTRUCTION 0.00% 22-222-60-00-6060 EQUIPMENT 0.00% 22-222-99-00-9921 TRANSFER TO PW CAPITAL 292 1 292 1 292 1 292 1 292 1 292 1 292 292 1 292 2,625 1 3,500 75.00% TOTAL FUND REVENUES 258 8 8 1,410 37 10,739 985 38 1 38 13,521 2,830 477.77% TOTAL FUND EXPENDITURES 292 292 292 292 292 292 292 292 1 292 2,625 123,500 2.13 FUND SURPLUS EFICIT 33 284 284 1,118 254 10,447 694 254 254 10,896 1 (120,670 CITY-WIDE CAPITAL REVENUES 23-000-41-004170 STATE GRANTS - - - - - - - - 231,000 0.00% 23-000-42-00-4210 BUILDING PERMITS - - - - - 17,600 0.00% 23-000-42-004213 ENGINEERING CAPITAL FEES 500 500 100 1,700 100 100 - 3,000 3,000 100.00% 23-000-42-00-4214 DEVELOPMENT FEES - 85 - 700 1,700 500 4,289 755 8,029 20,000 40.14% 23-000-42-00-4222 ROAD CONTRIBUTION FEE 4,000 - 6,000 - 12,000 - - - 22,000 20,000 110.00% 23-000-45-00-4500 INVESTMENT EARNINGS 2 2 2 3 13 13 13 13 13 74 - 0.00% 23-000-46-004690 IREIMB-MISCELLANEOUS m 4,469 1 3,560 1,549 - 9,578 0.00% 23-000-49-00-4901 ITRANSFER FROM GENERAL m 10,4171 10,417 1 10,417 1 10,417 1 10,4171 10,417 1 10,417 1 10,417 1 10,417 E 93,750 1 125,000 1 75.00% TOTAL REVENUES:CITY-WIDE CAPITAL m 19,388 1 14,064 1 16,9191 12,769 1 25,829 1 11,0291 14,8181 10,430 1 11,185 E 136,431 1 416,600 1 32.75% 7 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-71 June-11 July-I1 August-11 September-11 October-11 November-11 December-11 January-12 Totals BUDGET %of Budget CITY-WIDE CAPITAL EXPENDITURES 23-230-60-00-6070 VEHICLES 4,000 0.00% 23-230-60-00-6092 SAFE ROUTE TO SCHOOL PROJECT - 1,049 1,171 (2,073) 948 1,095 1 231,000 1 0.47% 23-230-97-00-8000 1PRINCIPLE PMT-CLARK PRPTY E 125,000 - 1 125,000 125,000 1 100.00% TOTAL FUND REVENUES 9r 19,388 14,064 16,919 12,769 25,829 11,029 14,818 10,430 1 11,185 136,431 416,600 32.75% TOTAL FUND EXPENDITURES E 125,000 1,049 1 1,171 1 (2,073)1 948 E 126,095 1 360,000 35.03% IL FUND SURPLUS EFICIT (105,612)1 14,064 1 16,919 1 12,769 1 25,829 1 9,981 1 13,647 1 12,502 1 10,237 E 10,336 1 56,600 DEBT SERVICE REVENUES 42-000-40-00-4006 PROPERTY TAXES-2005A BOND 51,906 106,836 4,056 39,864 105,340 9,360 5,988 - - 323,350 324,179 99.74% 42-000-42-00-4208 RECAPTURE FEES-WATER&SEWE 200 50 125 50 400 50 50 - - 925 - 0.00% 42-000-45-00-4500 INVESTMENT EARNINGS 0 12 39 40 50 72 62 2 2 279 - 0.00% 42-000-49-00-4901 TRANSFER FROM GENERAL 8,645 8,645 8,645 8,645 8,645 8,645 8,645 8,645 8,645 77,805 103,740 75.00% 42-000-49-00-4985 TRANSFER FROM FOX IND TIFF - - - - - 78,563 214 - - 78,777 - 0.00% TOTAL REVENUES:DEBT SERVICE 60,752 115,542 12,866 48,599 114,434 96,690 14,959 8,647 8,647 481,136 427,919 112.44% DEBT SERVICE EXPENDITURES 42-420-54-00-5498 PAYING AGENT FEES 375 375 749 750 99.87% 42-420-81-00-8000 PRINCIPLE PAYMENT-2004C 95,000 95,000 95,000 100.00% 42-420-81-00-8050 INTEREST PAYMENT-2004C 4,370 4,370 8,740 8,740 100.00% 42-420-82-00-8000 PRINCIPLE PAYMENT-2005A 195,000 195,000 195,000 100.00% 42-420-82-00-8050 INTEREST PAYMENT-2005A 64,589 64,589 129,179 129,179 100.00% IF TOTAL FUND REVENUES 60,752 115,542 12,866 48,599 114,434 96,690 14,959 8,647 8,647 481,136 427,919 112.44% TOTAL FUND EXPENDITURES 68,959 375 358,959 375 428,668 428,669 100.00% FUND SURPLUS EFICIT 60,752 46,583 12,866 48,225 114,434 96,690 1 14,959 350,313 8,273 E 52,468 750 WATER FUND REVENUES 51-000-40-00-4007 PROPERTY TAXES-2007A BOND 21,434 44,117 1,675 16,461 43,499 3,865 2,473 - - 133,524 133,866 99.74% 51-000-44-00-4424 WATER SALES 3,611 287,381 2,266 331,018 3,507 293,000 (4,586) 293,672 3,943 1,213,811 1,674,750 72.48% 51-000-44-00-4425 BULK WATER SALES - 950 - - - - (771) - - 179 500 35.88% 51-000-44-00-4430 WATER METER SALES 3,405 780 2,235 875 8,550 875 1,360 - - 18,080 25,000 72.32% 51-000-44-00-4440 WATER INFASTRUCTURE FEE 305 115,440 137 115,635 587 115,871 196 116,454 103 464,728 600,000 77.45% 51-000-44-00-4450 WATER CONNECTION FEE 16,710 7,400 10,640 5,030 34,290 5,030 5,030 - - 84,130 125,000 67.30% 51-000-45-00-4500 INVESTMENT EARNINGS 4 9 19 21 35 22 1 21 18 21 170 2,000 8.48% 51-000-46-00-4690 REIMS-MISCELLANEOUS - - - - - 1,340 - 430 1,771 - 0.00% 51-000-48-00-4821 BAD DEBT RECOVERY - - - - 3,517 - - - - 3,517 - 0.00% 51-000-48-00-4822 RENTAL INCOME-WATER TOWER 311 2,524 2,524 2,524 4,738 2,524 4,324 4,324 4,324 28,118 50,000 56.24% 51-000-48-00-4850 MISCELLANEOUS INCOME - - - - - 63 - - - 63 - 0.00% 51-000-49-00-4952 TRANSFER FROM SEWER 6,989 6,989 6,989 6,989 6,989 6,989 6,989 6,989 6,989 62,897 83,863 75.00% TOTAL REVENUES:WATER FUND 52,768 465,589 26,486 478,553 105,711 429,579 15,035 421,887 15,380 2,010 990 2,694,979 74.62% WATER OPERATIONS EXPENSES 51-510-50-00-5010 SALARIES&WAGES 26,985 27,920 27,335 26,064 46,015 20,542 17,556 19,932 22,337 234,685 365,000 64.30% 51-510-50-00-5020 OVERTIME - - 95 22 1,130 741 1,542 424 632 4,587 12,000 38.22% 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTIO 2,566 2,655 2,609 2,481 4,483 2,024 1,816 1,936 2,214 22,785 37,500 60.76% 51-510-52-00-5214 FICA CONTRIBUTION 1,984 2,055 2,018 1,915 3,497 1,559 1,405 1,497 1,688 17,616 28,200 62.47% 51-510-54-00-5412 TRAINING&CONFERENCES - - - 330 - - - - - 330 2,000 16.50% 51-510-54-00-5415 TRAVEL&LODGING - - 278 - - 278 1,600 17.36% 51-510-54-00-5426 PUBLISHING&ADVERTISING 934 - 119 119 1,172 1,000 117.20% 51-510-54-00-5429 WATER SAMPLES 4,236 33 25 - - 4,294 14,000 30.67% 51-510-54-00-5430 PRINTING&DUPLICATING - - - - 12 3 - - 8 23 2,500 0.93% 51-510-54-00-5440 TELECOMMUNICATIONS 1,453 1,446 1,495 1,998 1,558 1,550 1,555 1,545 12,601 24,500 51.43% 51-510-54-00-5452 POSTAGE&SHIPPING 3,226 583 2,760 269 1,695 683 287 1,986 11,489 22,000 52.22% 51-510-54-00-5460 DUES&SUBSCRIPTIONS 435 - - - - - 107 - 542 1,250 43.39% 51-510-54-00-5462 PROFESSIONAL SERVICES 783 1,411 1,650 2,281 1,331 3,103 272 481 11,312 61 000 188.53% 51-510-54-00-5466 LEGAL SERVICES - - - 2,000 0.00% 51-510-54-00-5480 JUTILITIES 11,508 1 23,852 1 23,444 1 16,943 1 19,367 21,987 1 19,242 1 4,935 141,277 304,500 46.40% UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-11 October-11 November-11 December-11 January-12 Totals BUDGET %of Budget 51-510-54-00-5483 JULIE SERVICES 1,780 - - 1,645 - - 3,426 3,500 97.88% 51-510-54-00-5485 RENTAL&LEASE PURCHASE 33 33 37 33 33 29 33 33 33 297 1,000 29.707/. 51-510-54-00-5495 OUTSIDE REPAIR&MAINTENANC 485 181 684 16 37 238 1,208 2,849 10,000 28.49% 51-510-54-00-5499 BAD DEBT - - - - - - - - - 6,000 0.00% 51-510-56-00-5600 WEARING APPAREL 93 255 174 259 275 228 106 448 209 2,048 5,000 40.96% 51-510-56-00-5620 OPERATING SUPPLIES - 793 2,563 1,969 489 433 712 2,840 425 10,226 20,500 49.88% 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT 64 (64) - - - 29 - 75 - 104 2,000 5.18% 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - 265 - - 90 355 1,600 22.19% 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 20 16,563 17,190 28,518 23,630 16,675 - 31,220 9,274 143,090 240,000 59.62% 51-510-56-00-5640 REPAIR&MAINTENANCE 59 3,335 3 - 1,665 1,694 15,706 53 151 22,667 9,500 238.60% 51-510-56-00-5664 METERS&PARTS 1,452 465 439 2,326 5,884 1,860 531 151 5,653 18,761 46,000 40.78% 51-510-56-00-5695 GASOLINE - 2,886 1,278 2,914 4,062 2,239 2,367 5,824 1,293 22,863 35,700 64.04% 51-510-60-00-6079 ROUTE 47 EXPANSION - - - - - - 1,685 - - 1,685 96,000 1.76% 51-510-75-00-7502 GRANDE RESERVE COURT ORDER 22,989 22,989 22,989 22,989 22,989 22,989 22,989 22,989 22,989 206,899 275,868 75.00% 51-510-83-00-8000 PRINCIPLE PAYMENT-2007A - - - - - - - 10,000 - 10,000 10,000 100.00% 51-510-83-00-8050 INTEREST PAYMENT-2007A - 61,933 61,933 123,866 123,866 100.00% 51-510-85-00-8000 PRINCIPLE PMT-2002 CAP APPREC 285,000 - - 285,000 285,000 100.00% 51-510-86-00-8000 PRINCIPLE PMT-2003 DEBT CERT - - - - - 0.00% 51-510-86-00-8050 INTEREST PMT-2003 DEBT CERT 16,575 16,575 33,150 33,150 100.00% 51-510-87-00-8000 PRINCIPLE PAYMENT-2006A - 70,000 70,000 70,000 100.00% 51-510-87-00-8050 INTEREST PAYMENT-2006A 44,253 44,253 88,506 88,506 100.00% 51-510-88-00-8000 PRINCIPLE PAYMENT-2005C - 90,000 90,000 90,000 100.00% 51-510-88-00-8050 INTEREST PAYMENT-2005C 38,863 38,863 77,725 77,725 100.00% 51-510-89-00-8000 PRINCIPLE PAYMENT-IEPA 15630 - 42,534 - 42,534 85,600 49.69% 51-510-89-00-8050 INTEREST PAYMENT-IEPA 156300 - - 19,981 - - 19,981 39,430 50.67% 51-510-99-00-9901 TRANSFER TO GENERAL 7,655 7,655 7,655 7,655 7,655 7,655 7,655 7,655 7,655 68,897 91,863 75.00% TOTAL FUND REVENUES 52,768 465,589 26,486 478,553 1 105,711 429,579 15,035 421,887 1 15,380 2,010,990 2,694,979 74.62 TOTAL FUND EXPENSES 353,135 268,835 112,610 189,554 1 144,283 104,587 101,585 448,522 1 84,809 1,807,920 1 2,571,858 1 70.30 FUND SURPLUS EFICIT (300,367)1 196,755 86,124 288,999 38,572 324,992 86,550 26,635 (69,428)M 203,070 1 123,121 SEWER FUND REVENUES 52-000-40-00-4009 PROPERTY TAXES-2004B BOND 41,414 85,240 3,236 31,806 84,046 7,468 4,778 257,989 258,650 99.74% 52-000-40-00-4013 PROPERTY TAXES-2005D BOND 221,914 456,751 17,342 170,429 450,354 40,018 25,601 1,382,408 1,385,950 99.74% 52-000-40-00-4014 PROPERTY TAXES-2008 BOND 17,627 36,281 1,378 13,538 35,773 3,179 2,034 - 109,809 110,090 99.74% 52-000-44-00-4435 SEWER MAINTENANCE FEES 184 123,655 79 123,755 254 123,734 107 123,964 73 495,805 714,000 69.44% 52-000-44-00-4455 SW CONNECTION FEES-OPS 800 400 600 200 1,400 200 200 - 3,800 5,000 76.00% 52-000-44-004456 SW CONNECTION FEES-CAPITAL 7,200 3,600 5,400 1,800 12,600 1,800 1,800 34,200 30,000 114.00% 52-000-44-00-4457 SW CONNECTION FEES-ROB ROY 294,000 - - - - - 278,000 572,000 600,000 95.33% 52-000-45-00-4500 1INVESTMENT EARNINGS 63 129 316 322 365 488 412 89 86 2,270 1,800 126.11% 52-000-46-00-4690 jREfMB-MISCELLANEOUS 155 - - - - - 155 - 0.00% TOTAL REVENUES:SEWER FUND 583,357 706,056 28,351 341,850 584,793 176,886 312,931 124,053 159 2,858,436 3,105,490 92.04% SEWER OPERATIONS EXPENSES 52-520-50-00-5010 SALARIES&WAGES 18,877 30,792 18,877 14,258 21,387 17,710 11,042 11,042 11,043 155,030 256,000 60.56% 52-520-50-00-5020 OVERTIME 76 - - 49 - - - - - 125 2,000 6.23% 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,802 2,928 1,795 1,361 2,034 1,684 1,050 1,050 1,064 14,769 25,000 59.08% 52-520-52-00-5214 FICA CONTRIBUTION 1,391 2,297 1,401 1,051 1,584 1,204 826 826 826 11,407 20,230 56.39% 52-520-54-00-5412 TRAINING&CONFERENCES - - - - - - - - - - 500 0.00% 52-520-54-00-5415 TRAVEL&LODGING - - - - - - - - - 500 0.00% 52-520-54-00-5440 TELECOMMUNICATIONS 129 127 133 132 125 130 127 127 1,031 1,800 57.30% 52-520-54-00-5462 PROFESSIONAL SERVICES 45 237 46 604 56 144 35 2,727 3,896 5,000 77.91% 52-520-54-00-5480 UTILITIES 1,331 1,278 1,322 1,296 1,146 1,477 1,837 1,688 11,375 40,000 28.44% 52-520-54-00-5485 RENTAL&LEASE PURCHASE 33 33 33 33 33 33 33 33 33 297 1,000 29.70% 52-520-54-00-5495 OUTSIDE REPAIR&MAINTENANC - - 243 684 - 541 52 26 1,546 4,000 38.65% 52-520-56-00-5600 WEARING APPAREL 93 144 174 259 126 228 270 152 244 1,690 2,500 67.61% 52-520-56-00-5610 OFFICE SUPPLIES 44 - - - - 450 494 2,000 24.71% 52-520-56-00-5613 LIFT STATION MAINTENANCE 702 1,000 2,241 3,153 7,227 - - 14,322 15,000 95.48% 52-520-56-00-5620 OPERATING SUPPLIES 425 558 806 419 154 146 122 161 2,790 4,500 62.00% 52-520-56-00-5630 SMALL TOOLS&EQUIPMENT 64 1 462 - (64) - 462 1 2,500 18.48% UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-i l June-11 July-11 August-11 September-11 October-11 November-11 December-11 January-12 Totals BUDGET %of Budget 52-520-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - 70 - - - - 70 1,200 5.83% 52-520-56-00-5640 REPAIR&MAINTENANCE 119 905 1 459 232 137 60 778 2,690 25,000 10.76% 52-520-56-00-5695 GASOLINE 2,886 1,278 2,914 4,062 2,185 1,685 3,235 1,293 19,538 27,300 71.57% 52-520-56-00-5699 BAD DEBT - - - - - - - - - 1,500 0.00% 52-520-60-00-6079 ROUTE 47 EXPANSION - - 24,600 0.00% 52-520-75-00-7500 LENNAR-RAINTREE SWR RECAP 30,996 - 30,996 30,996 100.00% 52-520-84-00-8000 PRINCIPLE PAYMENT-2004B - - 160,000 160,000 160,000 100.00% 52-520-84-00-8050 INTEREST PAYMENT-2004B 49,325 49,325 - 98,650 98,650 100.00% 52-520-90-00-8000 PRINCIPLE PAYMENT-2003IRRB - - - 95,000 95,000 95,000 100.00% 52-520-90-00-8050 INTEREST PAYMENT-2003IRRB 35,071 - 35,071 70,142 70,143 100.00% 52-520-91-00-8000 PRINCIPLE PAYMENT-2004A - - 170,000 - 170,000 170,000 100.00 52-520-91-00-8050 INTEREST PAYMENT-2004A 12,046 12,046 24,093 24,093 100.00% 52-520-92-00-8000 PRINCIPAL 2011 REFUNDING - - - - 0.00% 52-520-92-00-8050 INTEREST 2011 REFUNDING 66,281 66,281 - 0.00% 52-520-93-00-8000 PRINCIPLE PAYMENT-2005D - - - 1,000,000 0.00% 52-520-93-00-8050 INTEREST PAYMENT-2005D 192,975 139,371 332,346 385,950 86.11% 52-520-94-00-8050 INTEREST PAYMENT-2008 REF 55,045 - 39,755 - 94,800 110,090 86.11% 52-520-95-00-8000 PRINCIPLE PAYMENT-IEPA 01300 - 18,155 - 18,480 36,635 36,635 100.00% 52-520-95-00-8050 INTEREST PAYMENT-IEPA 01300 1,335 1,010 2,345 2,344 100.06% 52-520-96-00-8000 PRINCIPLE PAYMENT-IEPA 11530 - 42,883 - 42,883 86,329 49.67% 52-520-96-00-8050 INTEREST PAYMENT-IEPA 115300 - - 10,642 - 10,642 20,721 51.36% 52-520-99-00-9901 TRANSFER TO GENERAL 6,920 6,920 6,920 6,920 1 6,920 6,920 1 6,920 1 6,920 1 6,920 62,284 83,045 75.00% 52-520-99-00-9952 TRANSFER TO WATER 6,989 6,989 6,989 6,989 6,989 6,989 6,989 6,989 6,989 62,897 83,863 75.00% TOTAL FUND REVENUES 583,357 706,056 28,351 341,850 584,793 176,886 312,931 124,053 159 2,858,436 3,105,490 92.04% TOTAL FUND EXPENSES m 67,241 365,636 96,134 92,152 49,952 45,829 210,516 490,583 183,482 1,601,525 2,919 989 54.851 FUND SURPLUS(DEFICIT) E 516,117 1 340,420 1 (67,783)1 249,698 1 534,841 1 131,057 1 102,415 1 (366,530) (183,323)M 1,256,911 1 185,501 LAND CASH REVENUES 72-000-41-00-4170 STATE GRANTS 1 400,0000 400,000 1 400,000 1 100.00% 72-000-47-00-4702 WHISPERING MEADOWS(K HILL) - - - 0.00% 72-000-47-00-4703 AUTUMN CREEK 3,077 2,051 1,026 11,281 1,026 1,026 19,486 20,000 97.43% 72-000-47-00-4704 BLACKBERRY WOODS - - - - - - - - 500 0.00% TOTAL REVENUES:LAND CASH 3,077 2,051 1,026 11,281 1,026 1,026 400,11(111 419,486 420,500 99.76% LAND CASH EXPENDITURES 72-720-60-00-6032 MOSIER HOLDING COSTS 11,000 11,000 11,000 100.00% 72-720-60-00-6036 RAINTREE VILLAGE 78,878 1 3,173 1 54,417 1 49,658 1 958 1 11,545 18,497 1 3,746 1 15,131 0 236,003 270,000 87.41% 72-720-60-00-6044 HOPKINS PARK 0.00% 72-720-60-00-6045 RIVERFRONT PARK 0.00% 72-720-99-00-9901 TRANSFER TO GENERAL 1,674 1,674 1,674 1,674 1,674 1,674 1,674 1,674 1,674 15,063 20,084 75.00% TOTAL FUND REVENUES 3,077 2,051 1,0261 11 281 1,026 1,026 400,000 419,486 420,500 99.76% TOTAL FUND EXPENDITURES E 80,552 4,847 56,091 62,331 1 2,632 13,219 20,170 5,419 16,805 262,066 301,084 87.04% FUND SURPLUS EFICIT 77,475 (4,847)1 54,040 61,306 8,650 (12,193)1 19,145 (5,419)1 383,195 E 157,420 1 119,4161 PARK&RECREATION REVENUES 79-000-44-00-4402 SPECIAL EVENTS - 1,320 20 - 885 3,800 510 400 - 6,935 - 0.00% 79-000-44-00-4403 CHILD DEVELOPMENT 5,557 3,653 400 6,089 5,727 2,193 2,404 4,580 4,829 35,430 0.00% 79-000-44-00-4404 ATHLETICS AND FITNESS 18,466 12,412 29,027 7,343 2,074 29,295 3,445 2,867 2,060 106,988 - 0.00% 79-000-44-00-4440 PROGRAM FEES 26,232 3,125 3,092 495 240 1,784 7,685 - 180 42,832 180,000 23.80% 79-000-44-00-4441 CONCESSION REVENUE 14,297 16,042 3,906 613 1,838 - - - 36,696 30,000 122.32% 79-000-44-00-4443 HOMETOWN DAYS 4,250 350 3,660 12,242 70,352 10,107 100,960 135,000 74.79% 79-000-45-00-4500 INVESTMENT EARNINGS 12 14 10 9 7 8 15 20 21 116 300 38.74% 79-000-46-00-4690 REIMB-MISCELLANEOUS 2,916 70 - 350 - - - - - 3,336 - 0.00% 79-000-48-00-4820 RENTAL INCOME 38,944 400 1,250 (300) (1,764) (590) 250 250 250 38,690 86,000 44.99% 79-000-48-00-4825 PARK RENTALS 14,374 6,681 (215) 1,026 1,500 1,477 35 - - 24,878 - 0.00% 79-000-48-00-4846 SPONSORSHIPS/DONANTIONS 490 200 - 804 315 220 270 670 630 3,599 11,200 32.13% 79-000-48-00-4850 MISCELLANEOUS INCOME 18 486 1,376 180 638 40 - - - 2,738 500 547.50% UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 77% 25% 33% 42% 50% 58% 67% 75% Year-to-Date I ANNUAL ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September ll October-11 November-11 December-11 January-12 Totals BUDGET %of Budget 79-000-49-00-4901 TRANSFER FROM GENERAL 61,059 61,059 61,059 61,059 61,059 61,059 65,059 61,059 61,059 553,533 1 732,710 1 75.55 TOTAL REVENUES:PARK&RECREATION 186,615 105,812 103,585 89,909 142,870 109,392 79,673 69,846 69 029 956,731 1,175 710 81.37% PARKS DEPARTMENT EXPENDITURES 79-790-50-00-5010 SALARIES&WAGES 28,371 27,641 27,664 28,899 42,348 29,096 27,789 27,749 27,699 267,257 370,000 72.23% 79-790-50-00-5015 PART-TIME SALARIES 763 4,309 4,698 4,204 2,961 - - - - 16,934 17,000 99.61% 79-790-50-00-5020 OVERTIME - - - - - - 30 - - 30 3,000 1.00% 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTIO 2,698 2,629 2,631 2,763 4,042 2,781 2,660 2,653 2,685 25,541 37,730 67.69% 79-790-52-00-5214 FICA CONTRIBUTION 2,164 2,379 2,411 2,479 3,407 2,172 2,076 2,069 2,067 21,224 30,000 70.75% 79-790-54-00-5412 TRAINING&CONFERENCES - 100 - - - - 1,535 - 935 2,570 2,600 98.85% 79-790-54-00-5415 TRAVEL&LODGING - - - - - 144 - - 144 750 19.24% 79-790-54-00-5440 TELECOMMUNICATIONS 323 251 191 349 315 288 329 329 2,375 3,780 62.84% 79-790-54-00-5462 PROFESSIONAL SERVICES - 49 - 46 245 183 - - 523 4,500 11.63% 79-790-54-00-5466 LEGAL SERVICES 555 416 196 (196) - 416 185 1,573 4,000 39.31% 79-790-54-00-5485 RENTAL&LEASE PURCHASE 178 178 25 320 178 178 178 178 221 1,635 2,500 65.38% 79-790-56-00-5600 WEARING APPAREL - 336 317 155 155 229 320 124 581 2,218 4,100 54.10% 79-790-56-00-5610 OFFICE SUPPLIES 47 - - - 75 - - 171 293 300 97.72% 79-790-56-00-5620 OPERATING SUPPLIES 3,417 604 379 3,021 2,018 4,540 572 286 14,837 22,500 65.94% 79-790-56-00-5630 SMALL TOOLS&EQUIPMENT - 10 34 - 30 183 - 240 496 2,250 22.05% 79-790-56-00-5635 COMPUTER EQUIPMENT&SOFT W - - - - - - - - - 500 0.00% 79-790-56-00-5640 REPAIR&MAINTENANCE - 11,588 6,051 1,075 1,818 1,434 11,227 1,257 7,323 41,773 48,000 87.03% TOTAL EXPENDITURES:PARKS DEPT 34,174 52,947 45,267 40,914 58,520 38,378 51,152 35,348 42 723 399 423 553,510 72.16% RECREATION DEPARTMENT EXPENDITURES 79-795-50-00-5010 SALARIES&WAGES 14,458 16,152 14,692 14,692 22,037 14,692 15,442 14,692 14,692 141,546 190,000 74.50% 79-795-50-00-5015 PART-TIME SALARIES 1,406 637 1,773 1,360 1,745 1,385 1,703 1,649 949 12,606 25,000 50.42% 79-795-50-00-5020 OVERTIME - - - - - - - - - - 300 0.00% 79-795-50-00-5045 CONCESSION WAGES 2,868 3,059 2,522 - 2,217 - - - - 10,665 12,500 85.32% 79-795-50-00-5046 PRE-SCHOOL WAGES 3,410 1,557 13 10 3,033 1,795 1,970 1,930 1,690 15,408 25,000 61.63% 79-795-50-00-5052 INSTRUCTORS WAGES 1,195 2,182 2,115 1,004 1,498 1,611 1,618 482 511 12,215 25,000 48.86% 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTIO 1,768 1,939 1,712 1,547 2,581 1,702 1,827 1,728 1,675 16,479 22,000 74.90% 79-795-52-00-5214 FICA CONTRIBUTION 1,763 1,794 1,563 1,242 2,255 1,427 1,523 1,371 1,286 14,224 20,000 71.12% 79-795-54-00-5412 TRAINING&CONFERENCES - - - - 150 - - - 220 370 2,000 18.50% 79-795-54-00-5415 TRAVEL&LODGING - - - - - 1,000 0.00% 79-795-54-00-5426 PUBLISHING&ADVERTISING - 8,289 - - - 8,304 - 16,594 27,000 61.46% 79-795-54-00-5440 TELECOMMUNICATIONS 253 251 224 268 (133) 163 227 249 1,502 4,300 34.93% 79-795-54-00-5447 SCHOLARSHIPS 1,000 0.00% 79-795-54-00-5452 POSTAGE&SHIPPING - - 177 800 - 147 800 - 257 2,181 8,000 27.27% 79-795-54-00-5462 PROFESSIONAL SERVICES 2,278 5,479 18,245 6,521 3,995 4,827 4,947 4,005 4,669 54,964 47,000 116.95% 79-795-54-00-5480 UTILITIES - 1,811 1,014 965 749 338 752 614 - 6,243 22,000 28.38% 79-795-54-00-5485 RENTAL&LEASE PURCHASE - 25 - - 20 25 - - 70 4,500 1.55% 79-795-54-00-5490 DUES&SUBSCRIPTIONS - - - 162 1,100 1,262 1,500 84.13% 79-795-54-00-5495 OUTSIDE REPAIR&MAINTENANC - - - 106 - - - - - 106 1,000 10.57% 79-795-54-00-5496 PROGRAM REFUNDS 480 1,005 1,452 1,480 1,156 329 288 203 751 7,144 7,000 102.05% 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 1,629 - 34,015 19,098 23,528 6,612 - 100 - 84,982 100,000 84.98% 79-795-56-00-5606 PROGRAM SUPPLIES 2,500 2,797 2,359 851 3,350 624 3,857 5,542 96 21,975 55,000 39.95% 79-795-56-00-5607 CONCESSION SUPPLIES 1,561 4,882 4,832 215 - 35 - - 11,525 18,000 64.03% 79-795-56-00-5610 OFFICE SUPPLIES 120 70 - 158 63 33 427 116 988 3,000 32.93% 79-795-56-00-5620 OPERATING SUPPLIES 966 1,121 244 969 438 400 747 80 80 5,045 5,500 91.73% 11 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-11 October-11 November-11 December-11 January-12 Totals BUDGET %of Budget 79-795-56-00-5630 SMALL TOOLS&EQUIPMENT - - 2,000 0.00% 79-795-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - 1,446 1,446 500 289.207/. 79-795-56-00-5640 REPAIR&MAINTENANCE 34 (34) 179 111 399 19 707 2,000 35.37% 79-795-56-00-5645 BOOKS&PUBLICATIONS 100 0.00% 79-795-56-00-5690 SUPPLIES-GRANT REIMBURSABL 500 0.00 79-795-56-00-5695 GASOLINE - 44 81 84 72 340 135 31 787 000 26.24% [TOTAL RECREATION DEPT 36,403 44,816-1 87,0841 59,580 1 69,313 37,739 ____36_,2_49_F_41,576j 28,275 E 441,034 1 635,700 69.38% TOTAL FUND REVENUES 186,615 105,812 103,585 89,909 1 142,870 109,392 79,673 69,846 1 69,029 956,731 1,175,710 81.37 TOTAL FUND EXPENDITURES 70,577 97,763 1 132,351 1 100,494 1 127,833 76,117 1 87,401 1 76,924 1 70,998 W 840,458 1 1,189 210 1 70.67 FUND SURPLUS(DEFICIT) 116,039 1 8,049 28,767 (10,585)1 15,038 1 33,275 7,729 7,078 1,969 116,273 (13,500)1 1 RECREATION CENTER REVENUES 80-000-44-00-4440 PROGRAM FEES 7,814 4,553 2,680 9,804 7,313 6,771 13,391 7,895 9,517 69,738 125,000 55.79% 80-000-44-00-4441 CONCESSION REVENUE 975 900 813 868 704 602 643 855 1,057 7,416 12,500 59.32% 80-000-44-00-4444 MEMBERSHIP FEES 42,167 41,211 36,594 36,534 36,527 35,059 37,103 41,121 45,677 351,993 410,000 85.85% 80-000-44-00-4445 GUEST FEES 580 723 776 518 598 601 696 771 789 6,052 3,500 172.91% 80-000-44-00-4446 SWIM CLASS FEES 5,577 6,106 2,744 2,472 1,136 874 1,164 1,585 2,417 24,075 35,000 68.79% 80-000-44-00-4447 PERSONAL TRAINING FEES 336 816 308 1,044 - 36 52 257 1,439 4,288 15,000 28.59% 80-000-44-00-4448 TANNING SESSION FEES 575 129 160 108 115 70 123 198 253 1,731 2,500 69.22 80-000-48-00-4820 RENTALINCOME 6 31 299 174 1,118 2,049 1,106 919 2,396 8,097 5,000 161.93% 80-000-48-00-4845 DONATIONS 230 - - 295 - - 135 100 - 760 2,000 38.00% 80-000-48-00-4850 MISCELLANEOUS INCOME 37 32 5 17 6 22 1 5 37 160 500 32.00% TOTAL REVENUES:RECREATION CTR REVENUES 58,296 54,501 44,378 51,834 47,517 46,083 54,413 1 53,706 63,581 474,308 611,000 77.63 RECREATION CENTER EXPENSES 80-800-50-00-5010 SALARIES&WAGES 2,631 4,509 2,000 2,000 3,000 2,000 2,000 2,000 2,000 22,140 34,200 64.74% 80-800-50-00-5015 PART-TIME SALARIES 7,934 8,337 6,533 6,872 10,009 6,037 6,688 6,502 6,611 65,522 98,000 66.86% 80-800-50-00-5020 OVERTIME - - - - - - - - - - 500 0.00% 80-800-50-00-5046 PRE-SCHOOL WAGES 4,092 105 86 148 4,710 3,335 3,271 3,120 2,456 21,322 35,000 60.92% 80-800-50-00-5052 INSTRUCTORS WAGES 3,555 4,350 4,488 5,394 6,351 2,940 4,680 2,786 4,175 38,718 65,000 59.57% 80-800-52-00-5212 RETIREMENT PLAN CONTRIBUTIO 1,043 956 562 504 1,038 737 856 798 703 7,197 10,000 71.97% 80-800-52-00-5214 FICA CONTRIBUTION 1,382 1,318 1,003 1,107 1,849 1,103 1,281 1,110 1,174 11,326 17,708 63.96% 80-800-54-00-5415 TRAVEL&LODGING - - - - - - - - - - 200 0.00% 80-800-54-00-5426 PUBLISHING&ADVERTISING - - - - - - - - 1,500 0.00% 80-800-54-00-5440 TELECOMMUNICATIONS 394 358 363 369 (230) 242 288 298 2,081 3,600 57.81% 80-800-54-00-5447 SCHOLARSHIPS - - - - - - - - 900 0.00% 80-800-54-00-5452 POSTAGE&SHIPPING - - - - - - - - - - 600 0.00% 80-800-54-00-5462 PROFESSIONAL SERVICES 853 3,090 1,553 1,064 868 922 1,556 807 841 11,555 17,700 65.28% 80-800-54-00-5480 UTILITIES - 3,746 3,657 5,388 4,135 123 6,220 736 3,606 27,611 49,000 56.35% 80-800-54-00-5485 RENTAL&LEASE PURCHASE 36,198 18,198 19,050 18,698 18,764 18,581 18,765 18,698 18,741 185,694 226,500 81.98% 80-800-54-00-5490 DUES&SUBSCRIPTIONS - - - 114 - - - - - 114 200 57.20% 80-800-54-00-5495 OUTSIDE REPAIR&MAINTENANC - - 361 447 - - - 527 315 1,650 21,200 7.78% 80-800-54-00-5496 PROGRAM REFUNDS 318 664 434 693 133 333 436 450 305 3,765 5,500 68.45% 80-800-54-00-5497 PROPERTY TAX PAYMENT 30,751 - 30,751 - - - - - - 61,503 53,680 114.57% 80-800-56-00-5606 PROGRAM SUPPLIES 37 611 1,307 307 935 826 3,976 260 779 9,038 17,000 53.16% 80-800-56-00-5607 CONCESSION SUPPLIES - 889 468 879 238 251 534 319 281 3,858 6,300 61.24% 80-800-56-00-5610 OFFICE SUPPLIES - 37 46 158 - 75 427 116 - 859 2,600 33.04% 80-800-56-00-5620 OPERATING SUPPLIES 287 270 1,330 296 519 990 519 582 1,296 6,088 6,200 98.20% 80-800-56-00-5630 SMALL TOOLS&EQUIPMENT - - - - - - - - - - 6,300 0.00% 80-800-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - 1,000 - 1,000 1,000 100.00% 80-800-56-00-5640 REPAIR&MAINTENANCE 362 327 996 195 318 119 547 2,865 11,000 26.04% 80-800-56-00-5645 BOOKS&PUBLICATIONS - - 50 0.00% 80-800-56-00-5695 GASOLINE 44 1 81 1 84 1 72 1 - 282 300 1 93.84% TOTAL FUND REVENUES 58,296 54,501 44,378 51,834 1 47,517 46,083 54,413 53,706 1 63,581 474,308 611,000 77.63 TOTAL FUND EXPENSES 89,079 1 47,882 1 74,394 1 45,514 1 53,184 1 39,339 1 51,570 1 39,100 1 44,126 W 484,188 1 691,738 1 70.00 FUND SURPLUS(DEFICIT) E (30,783)1 6,620 30,010 6,320 1 (5,667)1 6,744 1 2,843 1 14,606 1 19,454 E (9,880) 80,738 12 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-11 June-1l July-11 August-11 September-11 October-11 November-11 December-11 January-12 Totals BUDGET %.f Budget LIBRARY OPERATIONS REVENUES 82-000-40-00-4005 PROPERTY TAXES-LIBRARY 108,080 222,457 8,329 82,993 219,338 19,487 12,461 - 673,145 675,000 99.73% 82-000-40-00-4012 PROPERTY TAXES-FOX IND TIF - - - - - - - - 19,331 19,331 - 0.00% 82-000-41-00-4120 PERSONAL PROPERTY TAX 755 700 175 1,170 169 720 3,690 5,000 73.79% 82-000-41-00-4170 STATE GRANTS - - - - - - 17,231 - 17,231 17,200 100.18% 82-000-42-00-4211 DEVELOPMENT FEES-BOOKS 875 - - 2,175 - 3,975 250 - - 7,275 8,000 90.94% 82-000-43-00-4330 LIBRARY FINES 1,397 1,377 1,053 1,310 1,052 990 980 527 1,069 9,755 13,000 75.04% 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 1,306 1,234 627 1,313 1,457 424 515 592 865 8,331 8,000 104.14% 82-000-44-00-4422 COPY FEES 320 332 347 263 328 258 171 183 321 2,522 3,000 84.08% 82-000-44-00-4440 PROGRAM FEES 20 23 - 20 - - 47 - - 110 2,000 5.50% 82-000-45-00-4500 INVESTMENT EARNINGS 1 7 10 9 13 20 19 27 35 142 250 56.70% 82-000-48-00-4820 RENTAL INCOME 111 140 185 320 217 489 151 112 167 1,892 1,500 126.13% 82-000-48-00-4824 DVD RENTAL INCOME 441 601 458 560 387 434 444 348 415 4,087 4,000 102.18% 82-000-48-00-4832 MEMORIALS 1,000 400 - 1,120 161 1,065 130 411 4,286 - 0.00% 82-000-48-00-4850 MISCELLANEOUS INCOME 7 40 72 62 133 130 17 48 110 619 82-000-48-00-4881 SALE OF BOOKS - - - - - - - - 0.00% 82-000-49-00-4901 TRANSFER FROM GENERAL - 328,644 - - 328,644 332,500 0.00% TOTAL REVENUES:LIBRARY 113,557 227,366 11,780 90,321 223,086 357,086 15,055 19,366 23 442 19081,060 1 069,450 101.09% LIBRARY OPERATIONS EXPENDITURES 82-820-50-00-5010 SALARIES&WAGES 18,661 19,302 18,707 18,707 28,060 18,707 18,707 18,707 18,707 178,263 241,000 73.97% 82-820-50-00-5015 PART-TIME SALARIES 16,163 14,802 14,474 15,031 21,905 14,819 14,414 13,869 12,786 138,262 193,000 71.64% 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTIO 1,775 1,836 1,779 1,779 2,669 1,779 1,779 1,779 1,803 16,977 22,500 75.45% 82-820-52-00-5214 FICA CONTRIBUTION 2,608 2,553 2,483 2,525 3,767 2,509 2,478 2,436 2,354 23,714 40,000 59.29% 82-820-52-00-5216 GROUP HEALTH INSURANCE - 7,295 7,295 - 14,590 7,295 7,295 7,295 7,295 58,360 87,975 66.34% 82-820-52-00-5222 GROUP LIFE INSURANCE 63 63 127 63 63 63 63 507 1,000 50.68% 82-820-52-00-5223 DENTAL&VISION INSURANCE 575 575 1,151 575 575 575 575 4,604 6,950 66.24% 82-820-54-00-5412 TRAINING&CONFERENCES - - - - - - - - - 0.00% 82-820-54-00-5415 TRAVEL&LODGING 77 77 500 15.30% 82-820-54-00-5423 PUBLIC RELATIONS - 0.00% 82-820-54-00-5426 PUBLISHING&ADVERTISING - - - - - - - - - 100 0.00% 82-820-54-00-5440 TELECOMMUNICATIONS 694 705 699 700 702 709 724 724 5,655 8,500 66.53% 82-820-54-00-5452 POSTAGE&SHIPPING - - - - - - 27 - 27 2,000 1.35% 82-820-54-00-5460 DUES&SUBSCRIPTIONS - - (234) 195 - 2,286 4,010 995 7,252 14,000 51.80% 82-820-54-00-5462 PROFESSIONAL SERVICES 1,746 1,960 2,444 2,820 1,638 1,349 2,922 1,484 16,364 29,000 56.43% 82-820-54-00-5466 LEGAL SERVICES - - - - - - - - - 2,000 0.00% 82-820-54-00-5468 AUTOMATION 7 4,247 214 7 3,393 - 16,956 24,825 30,000 82.75% 82-820-54-00-5480 UTILITIES 582 276 283 236 614 540 1,086 3,617 15,000 24.11% 82-820-54-00-5485 RENTAL&LEASE PURCHASE - - - - - - - - - 0.00% 82-820-54-00-5495 OUTSIDE REPAIR&MAINTENANC - 139 1,594 444 - 1,394 3,571 4,000 89.28% 82-820-56-00-5610 OFFICE SUPPLIES 1,053 - 433 644 674 191 174 3,169 8,000 39.62% 82-820-56-00-5620 OPERATING SUPPLIES 631 579 248 469 238 706 308 3,179 9,000 35.32% 82-820-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - - - - - - - 0.00% 82-820-56-00-5640 REPAIR&MAINTENANCE - - - 0.00% 82-820-56-00-5671 LIBRARY PROGRAMMING 162 8 9 180 2,000 8.98% 82-820-56-00-5676 EMPLOYEE RECOGNITION - - - 0.00% 82-820-56-00-5680 ADULTBOOKS 0.00% 82-820-56-00-5681 .JUVENILE BOOKS 0.00% 82-820-56-00-5682 REFERENCE BOOKS 0.00% 82-820-56-00-5683 AUDIO BOOKS 0.00% 82-820-56-00-5684 COMPACT DISCS&OTHER MUSIC - - 0.00% 82-820-56-00-5685 DVD'S - - - 115 - - 115 2,000 5.75% 82-820-56-00-5686 BOOKS-DEVELOPMENT FEES 143 - 905 807 473 157 95 2,579 8,000 32.24% 82-820-56-00-5698 MEMORIALS&GIFTS 453 485 154 374 881 400 244 2,992 0.00% 82-820-56-00-5699 MISCELLANEOUS 1 38 - - 38 1 250 15.29% 13 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-ll October-I1 November-11 December-11 January-12 Totals BUDGET %of Budget 82-820-70-00-7799 CONTINGENCIES 30 30 1,000 3.00% 82-820-99-00-9984 ITRANSFER TO LIBRARY DVLP 332,519 332,519 332,500 100.01% TOTAL FUND REVENUES 113,557 227,366 11,780 90,321 223,086 357,086 15,055 19,366 23,442 1,081,060 1,069,450 101.09% TOTAL FUND EXPENDITURES 39,207 50,713 49,851 378,509 78,445 52,219 56,487 54,402 67,044 826,875 1,060,275 77.99% FUND SURPLUS EFICIT 74,351 1 176,654 38,071 288,18 144,641 1 304,867 41,432 35,036 43,601 254,185 1 9,175 LIBRARY DEBT SERVICE REVENUES 83-000-40-00-4015 PROPERTY TAXES 115,416 1 237,557 1 8,894 1 88,627 1 234,227 1 20,810 1 13,307 1 718,839 1 720,800 11 99.73% 83-000-45-00-4500 JINVESTMENT EARNINGS 81 61 81 13 1 25 1 40 1 32 1 7E 140 0.00% TOTAL REVENUES:LIBRARY DEBT SERVICE 115,416 237,565 8,900 88,635 234,240 20,836 13,347 32 7 718,978 720,800 99.73% LIBRARY DEBT SERVICE EXPENDITURES 83-830-83-00-8000 PRINCIPLE PAYMENT-2005B 175,000 175,000 175,000 100.00% 83-830-83-00-8050 INTEREST PAYMENT-2005B 158,063 158,063 316,125 316,125 100.00% 83-830-84-00-8000 PRINCIPLE PAYMENT-2006 175,000 175,000 175,000 100.00% 83-830-84-00-8050 INTEREST PAYMENT-2006 27,338 27,338 54,675 54,675 100.00% TOTAL FUND REVENUES 115,416 237,565 8,900 88,635 234,240 20,836 13,347 32 7 718,978 720,800 99.75 TOTAL FUND EXPENDITURES 185,400 535,400 720,800 720,800 100.00 1 IL FUND SURPLUS(DEFICIT) 115,416 52,165 8,900 88,635 234,240 20,836 1 13,347 1 (535,368) 7 E (1,822) - LIBRARY CAPITAL REVENUES 84-000-42-00-4212 DEVELOPMENT FEES 875 2,175 3,975 250 7,275 8,000 90.94% 84-000-45-00-4500 JINVESTMENTEAPNINGS 13 12 13 14 14 4 0 0 0 71 500 14.13% 84-000-49-00-4982 1 TRANSFER FROM LIBRARY OPS 332,519 332,519 332,500 100.017/o TOTAL REVENUES:LIBRARY CAPITAL 888 12 13 334,708 14 1 3,979 1 250 1 ol 0 339,864 1 341,000 1 205.08% LIBRARY CAPITAL EXPENDITURES 84-840-60-00-6020 1BUILDINGS AND STRUCTURES 3,130 7,835 1 - 10,965 1 4,000 1 274.13% 84-840-99-00-9901 ITRANSFER TO GENERAL - 328,644 1 - I 1 328,644 1 332,500 1 98.84% TOTAL FUND REVENUES 888 12 13 334,708 1 14 3,979 250 0 I 0 339,864 341,000 99.67% TOTAL FUND EXPENDITURES 3,130 7,835 328,644 339,609 336,500 1 100.92% FUND SURPLUS(DEFICIT) 888 1 (3,118)1 13 1 334,708 1 (7,821) (324,665)1 250 1 0 1 0 N 255 1 4,500 FOX INDUSTRIAL TIF REVENUES 85-000-40-00-4085 PROPERTY TAXES-FOX IND 0 22,114 1 111,3271 6,311 1 9,005 1 103,4121 1,0451 5,837 1 259,052 1 - 0.00% 85-000-45-00-4500 1 INVESTMENT EARNINGS m 15 1 21 1 45 1 47 1 47 1 55 1 45 1 275 1 - 0.00% TOTAL REVENUES:FOX INDUSTRIAL TIF m 22,130 1 111,3491 6,356 1 9,052 1 103,459 1 1,1001 5,882 1 259,327 1 0.00% FOX INDUSTRIAL TIF EXPENDITURES 85-850-54-00-5420 ADMINISTRATIVE FEES - 214 - 907 74 1,138 1,232 3,565 0.00% 85-850-56-00-5619 SIGNS - - - 6,050 11,236 (6,050) 11,236 0.00% 85-850-98-00-8000 PRINCIPLE PAYMENT-2002 - - 70,000 70,000 0.00% 85-850-98-00-8050 INTEREST PAYMENT-2002 3,391 - 3,391 6,783 0.00% 85-850-99-00-9942 TRANSFER TO DEBT SERVICE - 78,563 214 - 78,777 0.00% 85-850-99-00-9999 TIF LIQUIDATION I - - - - - - - 658,757 658,757 0.00% TOTAL FUND REVENUES 22,130 1 111,349 6,356 9,052 103,459 1 1,100 5,882 259,327 0.00 TOTAL FUND EXPENDITURES 3,391 1 214 907 1 74 1 85,750 1 86,074 1 652,707 829,116 1 0.00 FUND SURPLUS(DEFICIT) 18,738 1 111,135 1 6,356 1 8,145 1 103,385 1 (84,651) (80,191) (652,707) - E (569,790) 14 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING JANUARY 31,2012 ACTUALS BY MONTH(Cash Basis) of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% 75% Year-to-Date ANNUAL 1ACCOUNT NUMBER DESCRIPTION May-71 June-11 July-11 August-11 September-11 October-11 November-11 December-11 January-12 Totals BUDGET %.f Budget COUNTRYSIDE TIF REVENUES 87-000-40-00-4087 PROPERTY TAXES-CNTRYSDE 1 4,188 1 0 4,188 1 6,250 67.02% 87-000-45-00-4500 JrNVESTMENT EARNINGS 37 1 106 1 288 1 288 1 285 1 273 1 223 1 307 1 237 E 2,043 1 4,000 51.07% TOTAL REVENUES:COUNTRYSIDE TIF 37 106 288 288 285 4,461 223 307 237 E 6,231 10,250 118.09% COUNTRYSIDE TIF EXPENDITURES 87-870-54-00-5420 ADMINISTRATIVE FEES 93 185 1 409 1 - 6871 1,0001 68.67% 87-870-54-00-5498 PAYING AGENT FEES - - - - 400 0.00% 87-870-80-00-8000 PRINCIPLE PAYMENT-2005 175,000 175,000 1 175,000 100.00% 87-870-80-00-8050 INTEREST PAYMENT-2005 65,571 65,571 131,143 131,143 100.00% TOTAL FUND REVENUES 37 106 288 288 285 4,461 223 307 237 6,231 10,250 60.79% TOTAL FUND EXPENDITURES E 65,571 1 1 93 1851 240,980 306,829 1 307,543 99.77% FUND SURPLUS(DEFICIT) E (65,535)1 13 1 288 1 288 1 285 1 4,276 1 (240,757)1 307 1 237 E (300,598) (297,293) DOWNTOWN TIF REVENUES 88-000-40-00-4088 IPROPERTY TAXES-DOWNTOWN TIM 4,450 1 38,640 1 1,2321 923 1 19,054 1 1,6881 1,821 67,807 1 88,550 76.58% 88-000-45-00-4500 JINWSTMENT EARNINGS m 61 71 151 15 1 15 1 191 161 91 9m 112 - 0.00% TOTAL REVENUES:DOWNTOWN TIF m 4,455 1 38,647 1 1,2471 939 1 19,069 1 1,7071 1,8371 9 1 9 m 67,919 1 88,550 1 76.700/. DOWNTOWN TIF EXPENDITURES 88-880-54-00-5420 ADMINISTRATIVE FEES 879 1 370 1 555 1 1,314 1 1,203 1 779 1 (4,782)1 0 317 1 1,500 1 21.11% 88-880-54-00-5466 LEGAL SERVICES - - - - - - 5,097 5,097 10,000 50.97% 88-880-60-00-6000 PROJECT COSTS m m - 10,000 1 0.00% 88-880-60-00-6079 IROUTE 47 EXPANSION m m - 515,340 1 0.00% IV TOTAL FUND REVENUES 4,455 38,647 1,247 939 19,069 1,707 1,837 9 9 67,919 88,550 76.70 TOTAL FUND EXPENDITURES 879 1 370 1 555 1 1,3141 1,2031 779 1 3151 m 5,4131 536,840 1 1.01 FUND SURPLUS EFICTT 4,455 1 37,769 1 877 1 384 1 17,755 1 504 1 1,058 306 9 m 62,506 448,290 15 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Period Ending January 31, 2012 % of January YTD YTD to FY 2012 Actual Actual Budget Budget GENERAL FUND (01) Revenues Local Taxes Property Taxes 67,334 2,709,935 101.6% 2,665,964 Municipal Sales Tax 201,136 1,940,435 76.1% 2,550,000 Non-Home Rule Sales Tax - - 0.0% - Electric Utility Tax - 460,549 77.8% 591,600 Natural Gas Tax 26,744 196,734 67.7% 290,700 Telecommunications/Telephone Utility Tax 42,051 385,754 72.0% 535,500 Cable Franchise Fees - 171,618 84.1% 204,000 Hotel Tax 3,420 40,613 132.7% 30,600 Amusement Tax 909 118,069 88.1% 134,000 Admissions Tax - 190,627 100.3% 190,000 Business District Tax 22,054 212,706 70.9% 300,000 Auto Rental Tax 829 7,177 100.5% 7,140 Para Mutuel Tax 1,669 19,486 129.9% 15,000 Total Taxes 366,145 6,453,703 85.9% 7,514,504 Intergovernmental State Income Tax 169,172 984,460 73.5% 1,340,000 Local Use Tax 19,973 178,124 84.8% 210,000 Road& Bridge Tax - 166,896 101.6% 164,296 Personal Property Replacement Tax 2,173 11,889 91.5% 13,000 Other Intergovernmental 498 15,485 138.3% 11,200 Total Intergovernmental 191,816 1,356,854 78.0% 1,738,496 Licenses and Permits Liquor Licenses - 4,493 11.2% 40,000 Building Permits 3,087 123,017 100.5% 122,400 Other Licenses &Permits - 4,139 127.4% 3,250 Total Licenses &Permits 3,087 131,649 79.5% 165,650 Fines and Forfeits Traffic Fines 5,056 57,191 60.2% 95,000 Administrative Adjudication 2,802 17,747 59.2% 30,000 Police Tows 8,000 62,500 69.4% 90,000 Total Fines and Forfeits 15,858 137,438 63.9% 215,000 16 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Period Ending January 31, 2012 % of January YTD YTD to FY 2012 Actual Actual Budget Budget GENERAL FUND (01) Charges for Services Garbage Surcharge 26 820,976 69.9% 1,175,000 Collection Fee - YBSD - - 0.0% 123,932 Other Services 105 455 9.1% 5,000 Total Charges for Services 131 821,431 63.0% 1,303,932 Investment Earnings 579 3,438 171.9% 2,000 Reimb/Miscellaneous/Other Financing Sources Reimb - Legal Expenses 555 26,578 221.5% 12,000 Reimb - Engineering Expenses 966 7,967 0.0% - Reimb - Traffic Signal - 28,582 190.5% 15,000 Reimb - Health Ins Contributions 20,185 196,781 74.3% 264,800 Other Reimbursements 1,079 91,686 187.1% 49,000 Rental Income 600 6,310 70.1% 9,000 Miscellaneous Income 195 1,942 27.7% 7,000 Transfers In 16,249 474,889 90.0% 527,492 Total Miscellaneous 39,831 834,734 94.4% 884,292 Total Revenues and Transfers 617,447 9,739,247 82.4% 11,823,874 Expenditures Administration 49,264 339,374 69.3% 489,551 Salaries 24,049 222,816 81.5% 273,395 Benefits 3,850 35,403 78.5% 45,106 Contractual Services 20,708 74,957 48.3% 155,100 Supplies 656 6,198 38.9% 15,950 Finance 16,012 219,061 68.3% 320,505 Salaries 12,812 124,780 71.3% 175,000 Benefits 2,249 21,640 70.9% 30,505 Contractual Services 653 70,574 64.6% 109,250 Supplies 297 2,068 36.0% 5,750 Community Relations - 333 100.0% 333 Salaries - - 0.0% - Benefits - - 0.0% - Contractual Services - 333 100.0% 333 Supplies - - 0.0% - 17 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Period Ending January 31,2012 % of January YTD YTD to FY 2012 Actual Actual Budget Budget GENERAL FUND (01) Engineering 137 95,153 37.6% 253,136 Salaries - 78,123 45.3% 172,500 Benefits - 13,348 44.9% 29,736 Contractual Services 137 3,675 8.7% 42,100 Supplies - 7 0.1% 8,800 Police 211,348 2,169,603 71.9% 3,018,230 Salaries 152,413 1,409,266 68.7% 2,052,500 Overtime 12,074 82,006 109.3% 75,000 Benefits 12,996 478,889 85.4% 560,900 Contractual Services 26,359 119,252 62.8% 190,010 Supplies 7,505 80,190 57.4% 139,820 Community Development 63,530 245,013 65.2% 375,610 Salaries 13,479 142,463 59.4% 240,000 Benefits 2,302 23,633 53.1% 44,535 Contractual Services 47,750 77,789 92.1% 84,450 Supplies - 1,128 17.0% 6,625 PW- Street Ops & Sanitation 141,634 1,152,041 64.1% 1,796,870 Salaries 19,377 184,640 68.4% 270,000 Overtime 1,855 2,998 20.0% 15,000 Benefits 3,624 31,815 59.5% 53,500 Contractual Services 113,798 875,776 65.6% 1,336,020 Supplies 2,980 55,943 47.3% 118,350 Capital Outlay - 869 21.7% 4,000 Administrative Services 269,790 3,796,163 79.0% 4,805,757 Salaries - 350 7.0% 5,000 Benefits 100,736 1,322,455 75.9% 1,743,350 Contractual Services 88,933 1,416,971 83.7% 1,693,840 Supplies - 2,655 53.1% 5,000 Contingencies - - 0.0% 64,617 Transfers Out 80,121 1,053,732 81.4% 1,293,950 Total Expenditures and Transfers 751,715 8,016,742 72.5% 11,059,992 Variance (134,268) 1,722,505 763,882 * January represents 75%of the fiscal year 18 0 CIP Reviewed By: Agenda Item Number J� a► Legal ❑ NB #2 W36 EST. Finance ■ Engineer ❑ Tracking Number Gy City Administrator El r� _© Consultant El ADM 2012-09 Agenda Item Summary Memo Title: Treasurer's Report for January 2012 Meeting and Date: Administration Committee 2/16/12 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: UNITED CITY OF YORKVILLE TREASURER'S REPORT-for the period ended January 31,2012 Cash Basis %of %of Projected BGN Fund January Revenues YTD January Expenses YTD Ending Fund Balance Revenues YTD Revenues Budget Budget Expenses YTD Expenses Budget Budget Balance General Fund 01 -General (271,900) 617,447 9,739,247 11,823,874 82% 751,715 8,016,742 11,059,992 72% 1,450,605 Special Revenue Funds 15-Motor Fuel Tax 640,399 35,660 389,760 1,011,000 39% 1,009 174,518 661,000 26% 855,641 79-Parks and Recreation 231,558 69,029 956,731 1,175,710 81% 70,998 840,458 1,189,210 71% 347,831 72-Land Cash (388,625) 400,000 419,486 420,500 100% 16,805 262,066 301,084 87% (231,205) 85-Fox Industrial TIF 569,790 - 259,327 - 0% - 829,116 - 0% - 87-Countryside TIF 2,178,550 237 6,231 10,250 61% 306,829 307,543 100% 1,877,952 88-Downtown TIF 209,760 9 67,919 88,550 77% 5,413 536,840 1% 272,266 11 -Fox Hill SSA 17,942 1 3,792 3,786 100% 4,295 3,804 113% 17,438 12-Sunflower SSA 11,922 0 7,537 7,530 100% - 6,921 9,078 76% 12,538 Debt Service Fund 42-Debt Service 8,653 8,647 481,136 427,919 112% 375 428,668 428,669 100% 61,121 Capital Funds 16-Municipal Building (587,024) - 5,700 5,250 109% - - - - (581,324) 22-Park and Recreation Capital 51,443 38 13,521 2,830 478% 292 2,625 123,500 2% 62,339 20-Police Capital 194,947 158 29,067 21,500 135% - 2,445 54,000 5% 221,569 21-Public Works Capital 108,743 106 33,533 35,900 93% 7,210 75,155 92,595 81% 67,121 23-City-Wide Capital 652 11,185 136,431 416,600 33% 948 126,095 360,000 35% 10,989 Enterprise Funds* 51-Water 695,723 15,380 2,010,990 2,694,979 75% 84,809 1,807,920 2,571,858 70% 898,793 52-Sewer 2,377,831 159 2,858,436 3,105,490 92% 183,483 1,601,525 2,919,989 55% 3,634,742 80-Recreation Center (195,087) 63,581 474,308 611,000 78% 44,126 484,187 691,738 70% (204,967) Library Funds 82-Library Operations 317,336 23,443 1,081,060 1,069,450 101% 67,044 826,875 1,060,275 78% 571,521 83-Library Debt Service - 7 718,978 720,800 100% - 720,800 720,800 100% (1,822) 84-Library Capital - 0 339,864 341,000 100% - 339,609 336,500 101% 255 Total Funds 6,172,614 1,245,087 20,033,054 23,993,918 83% 1,228,811 16,862,265 23,428,475 72% 9,343,403 As Treasurer of the United City of Yorkville,I hereby attest,to the best of my knowledge,that the information contained in this Treasurer's Report is accurate as of the date detailed herein. Further information is available in the Finance Department. William Powell,Treasurer Prepared by the Finance Department *Fund Balance Equivalent 0 CIP Reviewed By: Agenda Item Number J� a► Legal ❑ NB #3 W36 EST. Finance ■ Engineer ❑ Tracking Number Gy City Administrator ■ r� �! �© Consultant E] ADM 2012-10 Agenda Item Summary Memo Title: Cash Statements for December 2011 Meeting and Date: Administration Committee 2/16/12 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: UNITED CITY OF YORKVILLE CASH AND INVESTMENT SUMMARY-as of December 31,2011 CASH Cash-Operations Cash-Special Purpose IL Funds IL Funds Operations Aurora Special Purpose Grand Old Second Castle E-Pay Acct IMET Totals Old Second Castle IMET Earthmovers Totals Totals General Fund 01-General (2,538,602) 9,721 2,406,742 (122,140) 2,335 - 15,722 123 18,179 (103,960) Special Revenue Funds 15-Motor Fuel Tax - - - 786,238 - - 786,238 786,238 72-Land Cash (614,298) (614,298) - - (614,298) 85-Fox Industrial TIF - - - - - - 87-Countryside TIF 214,819 968,960 1,183,778 693,936 693,936 1,877,715 88-Downtown TIF 272,257 - 272,257 - - 272,257 11-Fox Hill SSA 17,438 17,438 17,438 12-Sunflower SSA 12,538 12,538 - - - - 12,538 Debt Service Fund 42-Debt Service 52,849 52,849 - - - - 52,849 Capital Funds 16-Municipal Building (581,324) (581,324) - - - - (581,324) 20-Police Capital 218,961 218,961 - - - - 218,961 21-Public Works Capital 73,787 73,787 - - - - 73,787 23-City-Wide Capital 671 - 671 - - 55,832 55,832 56,503 Enterprise Funds 51-Water 513,238 19,674 1 532,914 - - - - 532,914 52-Sewer 2,684,709 6,039 2,690,748 - - 2,690,748 Agency Funds 90-Developer Escrow 164,763 - - 164,763 - - - 164,763 95-Escrow Deposit 182,936 - 24,313 - 207,249 - - - - - 207,249 Total City Funds 674,742 - 59,747 1 3,375,701 4,110,191 696,271 786,238 71,554 123 1,554,185 5,664,376 Distribution% 11.91% 1.05% 0.00% 59.60% 12.29% 13.88% 1.26% 0.00% Library Funds 82-Library Operations 544,579 - - 79,818 - 624,397 - - - - - 624,397 83-Library Debt Service (272,082) - 270,253 (1,829) - - (1,829) 84-Library Develp Fees - - - 255 255 255 Totals 272,497 - 350,071 622,568 255 255 622,823 Distribution% 43.75% 56.21% 0.04% Park and Recreation Funds 79-Parks and Recreation - 403,856 - 403,856 - - 25 25 403,881 22-Park&Rec Capital 62,325 62,325 - - 147,850 147,850 210,175 80-Recreation Center (218,538) (218,538) - - - - - (218,538) Totals 247,643 247,643 - 147,850 25 147,875 395,518 Distribution% 62.61% 37.38% 0.01% CfTy Reviewed By: X06 Legal Agenda Item Number Finance El NB #4 EST. -� __ti 1838 Engineer ❑ City Administrator 0 : Human Resources ❑ Tracking Number Community Development ❑ Police ❑ ADM 2012-11 Public Works ❑ Agenda Item Summary Memo Title: SSA refinancing Meeting and Date: Administration February 16, 2012 Synopsis: Discussion of the possibility of refinancing SSA bonds to reduce the burden on existing residents. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: N/A Council Action Requested: Discussion Submitted by: Bart Olson Administration Name Department Agenda Item Notes: Information will be presented verbally at the meeting. 0 CIP Reviewed By: Agenda Item Number J� a► Legal ❑ NB #5 W36 El El Engineer ❑ Tracking Number Gy City Administrator El r� �! �© Consultant El ADM 2012-12 Agenda Item Summary Memo Title: Non-home Rule Sales Tax—Business Disclosure Authorization Meeting and Date: Administration Committee 2/16/12 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: Memorandum EST. 1 _ lass To: Administration Committee Ob From: Rob Fredrickson, Finance Director Boa, p' Date: February 10, 2012 <Ld N `.. ,� Subject: IDOR Reciprocal Agreement— Sales Tax Information The attached agreement with the Illinois Department of Revenue (IDOR)would enable to City to receive sales tax information for all business in the City. Staff is requesting that the City Council authorize the Mayor to sign the agreement, and designate the City Administrator and Finance Director to request sales tax information from the IDOR. Sales tax information received from the State will be used by staff to enhance sales tax and cash flow projections and to ensure compliance with the new non-home rule sales tax (effective January 1, 2012). As stated in the agreement, all sales tax information will remain confidential and access will be restricted. RECIPROCAL AGREEMENT ON EXCHANGE OF INFORMATION BETWEEN THE UNITED CITY OF YORKVILLE AND THE ILLINOIS DEPARTMENT OF REVENUE The Illinois Department of Revenue (the "Department"), in accordance with the statutes of the State of Illinois, agrees to share under the terms of this Reciprocal Agreement on Exchange of Information (the "Reciprocal Agreement") with the United City of Yorkville (the "Municipality") returns and return information obtained pursuant to the Illinois Retailers' Occupation Tax Act, the Service Occupation Tax Act, the Use Tax Act, and the Service Use Tax Act (the "Tax Acts"). It is further agreed that all returns and return information exchanged will be used only for the official purposes of the State and of the Municipality and shall be kept confidential in accordance with the Tax Acts. Each party agrees to take appropriate steps to protect from unauthorized disclosure the tax information obtained pursuant to the Reciprocal Agreement and to destroy it when no longer needed by shredding or other appropriate means. The Municipality agrees to follow the procedures to protect the confidentiality of information provided in "Minimum Standards Required to Safeguard Information Given as a Result of a Reciprocal Agreement on the Exchange of Information", which is incorporated into the Reciprocal Agreement as Attachment A. Both parties understand and agree that the Department will not provide any information under the Reciprocal Agreement to the Municipality unless and until the Municipality signs Attachment A. It is agreed that only the chief executive of the Municipality may request information, inspect returns, or receive related information from the Department. The chief executive of the Municipality will provide the Department with a list of names and official titles of personnel designated by him or her to request information, inspect returns, or receive related information on his or her behalf. If the Municipality is a village that does not levy any real property taxes for village operations and that receives more than 60% of its general corporate revenue from taxes under the Tax Acts, the officers eligible to request information, inspect returns, or receive related information from the Department under this Reciprocal Agreement are the village manager and the chief financial officer of the village. In such case, the village manager and/or the chief financial officer of the village will provide the Department with a list of names and official titles of personnel designated by him or her to request information, inspect returns, or receive related information on his or her behalf. The Department agrees to provide the Municipality with a written list showing the names and official titles of personnel designated by it to request information, inspect returns, or receive related information from the Municipality. Both parties agree to furnish additions to and deletions from the lists as they occur. It is agreed that no information provided under the Reciprocal Agreement will be provided by telephone or pursuant to a telephone request. It is further agreed that either party for administrative reasons may refuse to share information. 1 The Reciprocal Agreement may be cancelled by either party at any time and will be cancelled in the event of any unauthorized use or disclosure of State tax returns or return information obtained pursuant to the Reciprocal Agreement or failure to abide by the procedures set forth by the Department for safeguarding the confidentiality of such returns or return information. Illinois Department of Revenue United City of Yorkville Director Mayor Date City Clerk Date 2 ATTACHMENT A MINIMUM STANDARDS REQUIRED TO SAFEGUARD INFORMATION GIVEN AS A RESULT OF A RECIPROCAL AGREEMENT ON THE EXCHANGE OF INFORMATION 1. All requests for information under the Reciprocal Agreement on the Exchange of Information (the "Reciprocal Agreement") will be in writing and addressed to the appropriate contact person at the Illinois Department of Revenue (the "Department"). 2. Information received under the Reciprocal Agreement will be kept in a locked storage facility, e.g., locked file cabinet, closet, desk, etc., that is only accessible by persons authorized under the Reciprocal Agreement to receive information. 3. Any Municipality that receives information under the Reciprocal Agreement will promptly notify the Department when an employee, who has been authorized to receive information under the Reciprocal Agreement, leaves employment of the Municipality or otherwise is no longer authorized by statute or by the Municipality to receive the information. 4. Any Municipality that receives information under the Reciprocal Agreement will report immediately to the Department any possible or suspected breach of confidentiality of the information. 5. The proper method for destruction of information that is no longer needed is shredding. 6. Any Municipality that receives information under the Reciprocal Agreement agrees to allow the Department to physically view its facilities to insure proper compliance with these standards. The United City of Yorkville agrees to abide by the aforementioned standards in safeguarding the information that it receives pursuant to the Reciprocal Agreement on the Exchange of Information, which it has entered into with the Illinois Department of Revenue. Signature Title Date 3 Reviewed By: Agenda Item Number 4 ' �► Legal ❑ NB #6 Finance ❑ EST. -�` _ ti W36 Engineer ❑ �:--- g Tracking Number �! City Administrator ❑ Consultant ❑ ❑ ADM 2012-13 ALE Agenda Item Summary Memo Title: Cell Phone Usage During Meetings Meeting and Date: Administration Committee 2/16/12 Synopsis: Discussion regarding the use of cell phones (including texting) during meetings. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Alderperson Spears Name Department Agenda Item Notes: 0 CIP Reviewed By: Agenda Item Number J� a► Legal ❑ NB #7 W36 El El Engineer ❑ Tracking Number Gy City Administrator El r� �! �© Consultant El ADM 2012-14 Agenda Item Summary Memo Title: Copier RFP Meeting and Date: Administration Committee 2/16/12 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: ,��D C/ry United City of Yorkville t 800 Game Farm Road EST. 1836 Yorkville, Illinois, 60560 0 Telephone: 630-553-4350 Fax: 630-553-7575 <ILE % Copier Equipment Request for Proposal The United City of Yorkville ("City")is requesting proposals for the fulfillment of six(6)multifunction copiers to be used at City offices. Please fill out all applicable sections of this proposal. There is no expressed or implied obligation for the United City of Yorkville to reimburse responding firms for any expenses incurred in preparing proposals in response to this request. To be considered,please submit your proposal no later than 4:30 p.m.on March 16th,2012. Proposals may be submitted via e-mail to Rob Fredrickson,Finance Director, at rfredrickson(a)yorkville.il.us or mailed in a sealed envelope to the following address: United City of Yorkville Attn: Rob Fredrickson—Finance Director 800 Game Farm Road Yorkville,Illinois 60560 Questions on the proposal can be submitted to the e-mail address listed above. Any response will be submitted to all firms,who the City has knowledge of,who may be submitting a proposal. Introduction The City is looking to replace its fleet of multifunction copiers with new equipment as our current lease is ending November 1,2012. We are looking for proposals from established businesses experienced with the lease, maintenance, supply and support of multifunction copiers. All of the proposed copiers are to be leased with the option to purchase at the end of term at fair-market value. In addition to the lease of the equipment,we are seeking a maintenance and supply contract that will run concurrent with the lease agreement. One vendor will be selected to service and supply all of the copiers. All costs are to be laid out in this proposal and are to be fixed for the term of the lease and maintenance contract. The City retains the right to reject any or all submissions. It is anticipated that final approval of the selected proposal will be given by our City Council at the March 27th,2012 City Council meeting. Submission Vendor is to submit to the City a proposal for the lease of six(6)new copiers with an accompanying maintenance contract. The guidelines for the lease and maintenance contract are outlined below. All proposals must include an Page 1 of 6 option for a 36,48 or 60 month lease term. All pricing should be broken down per-copier,with the costs for optional features defined. The vendor shall specify if they are unable to meet or exceed any criteria laid out in the following sections. Furthermore, a Cost Summary Worksheet(Appendix A;page 6 of RFP)will be completed and submitted for each copier proposed in response to this RFP. A. Vendor Information 1. Please provide us with some information about your company. Particularly let us know the length of time your company has been in business, an approximate number of businesses you serve and an approximate number of businesses you serve with similar needs to ours. 2. Please provide us with at least 3 references of other companies you have serviced in our area. B. General Technical Specifications 1. General Equipment Requirements Unless specified in Section F of this document, all copiers are to have the following minimum technical specifications. a) All copiers are to be newly manufactured with no used or refurbished parts. b) All copiers must be rated at a printing speed of 50 black and white pages per minute. c) All copiers must have the capability to scan documents; .pdf and .tif formats, color(if color capable) and black and white, at least 300dpi, and single and duplex capabilities are required. i) The vendor will specify if there is a cost to add scanning capability to the copier. ii) The vendor will specify if there is a cost-per-scan associated with the scanning function. d) All copiers must have the capability to be network printable via an internal ethernet print server. i) The vendor will specify if there is a cost to add printing capability to the copier. e) All copiers must be capable of printing double-sided documents. f) All copiers must have a bypass tray for the purpose of printing on specialized paper,including envelopes. The bypass tray should have a minimum capacity of 50 sheets of standard 8 '/2 x 11 copy paper. g) All copiers must have an automated document feeder with a minimum capacity of 50 sheets of standard 8'/2 x 11 copy paper. h) All copiers must be capable of printing on 8'/2 x 11, 8'/2 x 14 and 11 x 17 paper. Paper sizes can be supported through the use of an adjustable tray. i) All copiers must have these minimum paper tray capacities: i) 8%2 x 11 — 1,000 sheets ii) 8'/2 x 14—500 sheets iii) 11 x 17—500 sheets j) All copiers must be functional as"walk-up"copiers. k) All copiers must be capable of sorting/collating. 1) Ideally the control panels for all copier models should be the same or have the same"look and feel" between models. 2. Networking Requirements a) All networked copiers are to be installed as multi-function printers on a Windows network. All printers must be able to be installed as a network shareable printer on a Windows 2008 Server and allow printing from Windows XP and Windows 7 PC's and laptops. b) Ideally, all models of printers will have a unified print driver or print drivers that have a consistent"look Page 2 of 6 and feel"between them. c) All copiers must be able to scan documents in color(if color capable)or black and white, .PDF or .TIF format, single or duplexed documents,to an SMB share on a Windows 2008 server. The vendor shall specify the technical requirements for this capability. C. Supplies and Service In addition to the proposal of the lease of equipment,the vendor should also provide a breakdown of costs for services, maintenance, supplies not covered by the maintenance agreement, delivery and network configuration. 1. Maintenance and Installation a) Vendor shall specify the warranty period of the provided equipment. b) The warranty period shall begin when the equipment is installed and accepted by the City. c) Any necessary repair or replacement during the warranty period shall be performed at no cost to the City. d) The maintenance agreement shall begin at the end of the specified warranty period. e) The vendor shall provide a toll-free number for placing service calls.Upon placing a service call,the vendor shall respond to the City within two business (2)hours and, if necessary,a service technician shall arrive at the City offices within four business (4)hours to begin work. Business hours for the City are defined as 8:00 a.m. through 4:30 p.m.,Monday through Friday excluding holidays. f) The City requests that all copiers have the ability to be programmed and maintained over the internet. This includes the ability to program mailboxes and other functions online;place service calls and order supplies via the internet; and auto-send maintenance calls. g) Any defect in equipment will be remedied within forty-eight(48)hours of the placement of the initial service call. h) If a defect cannot be remedied by the vendor within forty-eight(48)hours the vendor will provide the City with a comparable loaner copier, at no charge. i) The vendor will guarantee the availability of replacement equipment and parts for the duration of the maintenance agreement. j) The vendor will specify any and all installation or delivery fees for the equipment. k) It will be necessary to remove our current copier equipment and return it to the previous leasing company. Vendor will specify their cost to perform this service. 1) Vendor shall specify if any necessary hard-wiring will need to be performed prior to installation. Hard wiring for data and power will be performed by the City prior to installation by the vendor. m) If vendor feels they offer service above and beyond what is specified in this section(e.g. fleet management software, automated services, etc.),please specify. 2. Training a) Vendor will provide training of staff and IT at the time of installation at no cost to the City. b) Vendor will provide additional training at no cost to the City,within reason, due to significant re-staffing or alteration of equipment. A Pricing and Terms 1. Lease of Equipment a) Vendors shall provide three different pricing options for a 36-month,48-month and 60-month lease on all equipment. The City will decide which option it will pursue after receiving and reviewing all proposals. b) Pricing will be locked-in for the length of the lease and maintenance agreement. Page 3 of 6 c) At the end of term,the City shall be provided with an option to purchase any or all equipment at a fair market value. d) At the end of term,the City shall be provided with an option to extend the lease and maintenance agreement on a month-by-month basis. The pricing during this extension period shall be the same as the original agreement pricing. e) Vendor shall specify their terms for the upgrade or downgrade of equipment to accommodate for a change of usage during the lease period. 2. Maintenance Agreement Pricing a) Concurrent with the length of the lease,the vendor shall provide a maintenance agreement on all equipment. b) Maintenance agreement pricing shall include all maintenance,repairs,parts and consumable supplies (excluding paper). If any consumable supplies are not included in the maintenance agreement,vendor shall specify what is excluded and will provide a cost-estimate for the excluded supplies. c) Shipping costs for any consumable supplies covered by the maintenance agreement shall be included in the maintenance agreement. d) Pricing for the maintenance agreement will be a cost-per-copy(including scanned documents,if applicable)charge with no minimums or overages. e) It is assumed that there will be a pricing difference between color and black and white copies. Any copier provided with the ability to print in color must be able to track the number of color copies separately from black and white copies and thus charges will be generated accordingly. 3. Billing a) Vendor will outline their standard billing procedures. Particularly billing intervals, forms of accepted payment, late fees and grace periods. b) Vendor will outline how the number of copies performed will be obtained by the vendor for the purposes of billing. c) Due to the structure of City government, checks for invoices may only be issued at specific times throughout the month and only after invoices are approved to be paid by City Council.Vendor must be willing to accommodate delays in payment due to this by either an extended grace period or waiving of late fees. E. Timeline Please provide a timeline for the implementation of the new equipment. This timeline should include the removal of old equipment(once the current lease expires on November 1,2012, installation of new equipment and training of staff. F. Specific Technical Specifications Listed below is a summary of requested specifications for copiers that will deviate from the general specifications listed in Section B above. This chart includes finishing functions,minimum tray capacity requirements and other capabilities. Also included on this list is our current average monthly volume of copies on the copier. For each of these additional functions,please specify the additional cost of adding the feature to the copier or, if necessary, changing to another model of copier. Page 4 of 6 Copier 1 Color Hole Staple Fax 8 V2 x 11 Monthly Punch capacity Volume Admin X X X X 2500 15k Police 1 X X X X 2500 l Ok Police 2 X 1000 3k Comm Dvlp X X X 2500 3k Public Works X 1000 lk Rec. Center X X X 1000 14k Page 5 of 6 ,��u c►Ty Appendix A °% United City of Yorkville 800 Game Farm Road EST. $ 1836 Yorkville, Illinois, 60560 Telephone: 630-553-4350 .tea Fax: 630-553-7575 Copier Equipment Request for Proposal - Cost Summary Worksheet One form to be completed per make/model proposed by vendor, and returned with RFP. This worksheet covers the following Copier t t copiers(indicate with an 11x11): capacity Volume Admin X X X X 2500 15k Police 1 X X X X 2500 10k Police 2 X 1000 3k Comm Dv1p X X X 2500 3k Public Works X 1000 lk Rec.Center X X X 1000 14k List make/model of proposed equipment: Equipment Lease Price Maintenance Contract Price (please list as rice/month) (please list as price/month) 36-month lease 48-month lease 60-month lease 36-month lease 48-month lease 60-month lease Cost for features as outlined on Page 5 of RFP,or supplies(excluding paper)not covered under maintenance contract: 36-month lease 48-month lease 60-month lease Included in Feature or Supplies Indicate price rating(i.e. Indicate price rating(i.e. Indicate price rating(i.e. price above? per month,per copy,etc.) per month,per copy,etc.) per month,per copy,etc.) (Y or N) Page 6 of 6 Reviewed By: Agenda Item Number 4 ' �► Legal ❑ OB #1 Finance ❑ EST. -�` _ ti W36 Engineer ❑ �:--- g Tracking Number �! City Administrator ■ =t� Consultant ❑ ADM 2011-40 LE ��' Human Resources ■ Agenda Item Summary Memo Title: Employee Manual Revision— Sections 5 & 6 Meeting and Date: Administration Committee—02/16/2012 Synopsis: First draft of revised employee manual— Sections 5 & 6. Council Action Previously Taken: Date of Action: 02/10/2004 Action Taken: Approval of current employee manual. Item Number: Type of Vote Required: Council Action Requested: Discussion Submitted by: Meghan Ostreko Human Resources Name Department Agenda Item Notes: See attached memo. Memorandum To: Administration Committee EST. -� 1836 From: Meghan Ostreko, HR Manager -C � d -� � Date: February 8, 2012 O� Subject: Employee Manual Revision- Sections 5 & 6 LEw�a�co�y This month the Administration Committee is being asked to review and comment on Sections 5 and 6. The commentary below is intended to act as a guide. Section 5 Separation —Overall this section is new to the employee manual. The old manual sporadically referred to employee separation in some sections, but staff felt it was necessary to create a cohesive section to address the topic. Section Title Comments 5.1 Termination (New to employee manual). Taken from St. Charles' employee handbook. Reflects Mayoral responsibility in termination process. 5.2 Employee Termination&Exit (New to employee manual). Process Taken from St. Charles' employee handbook. 5.2.5 Layoff (Replaces old Section 2.4). Changes recall period from 2 years to 1 year. Address the possibility of severance pay. 5.2.9.1 Continuation of Benefits for (New to employee manual). Retirees Added to address municipal continuation requirement. 5.3 Use of Paid Time (New to employee manual). Taken from St. Charles' employee handbook. 5.4 Vacation Pay-Out at Termination (Old Section 7.169). Taken from current employee manual—added phrase"in good standing."Needs labor attorney review. Also addressed in Section 4.1 of revised manual. 5.5 Sick Pay-Out at Termination (Old Section 7.3.4) Taken from current employee manual—changed years of service required to cash out to 20 years. Also addressed in Section 4.3.4 of revised manual. 5.6 COBRA (New to employee manual). Taken from St. Charles' employee handbook. 5.7 Re-Employment (New to employee manual). Per the Committee's discussion at the 1/19/12 meeting, this section has been revised to distinguish between employees who resigned and employees who were laid off in regards to prior service credit. 5.8 References (New to employee manual). Taken from Geneva's employee handbook. 1 Section 6 Personnel Practices — This section has been re-vamped to ensure consistency in personnel practices of the City. Section Title Comments 6.1 Equal Employment (Old Section 3.1) Taken from current employee manual. Adds Mayor to assist in civil rights compliance. 6.2 Recruitment (Old Section 2.1.1) Taken from current employee manual—no changes. 6.3 Hiring Policy (Old Sections 2.1.2 &2.1.3) Taken from approved hiring policy(Res. 2006-77) and staff recommendations. 6.4 Job Description Creation (New to employee manual). Section created by staff. 6.5 Personnel Records (Old Section 2.2) Added section on Employee Review of Records. Other changes red-lined. 6.6 Probationary Period (Old Section 2.3) Shortens probationary period from 12 months to 6 months. Requires performance evaluations after 90 days and at end of probationary period. Revisions to/Comments on previously reviewed sections The comments and revisions below were not discussed at the meetings during which discussion by the Committee on each respective section took place. They are being presented now for your review. 1. Section 2.7.1.2.4 Random Testing(Non-DOT Employees) At the December 15, 2011 meeting, the Administration Committee determined that the City should implement random drug testing for all full-time, non-DOT employees. In sorting through old records I have come across a legal opinion from 2007 in which our previous labor attorney strongly cautioned against conducting random drug testing for all employees. This section will be marked for rigorous review by our current labor attorney. 2. Section 2.9 Uniforms and Dress Code Finance Director Fredrickson provided language from the IRS regarding clothing provided to employees by the City as a taxable benefit. Section 2.9.1.1 Taxation of Uniforms The value of work clothing provided by the employer is not taxable to the employee i : 1. The employee must wear the clothing as a condition of employment, and 2. The clothes are not suitable° or everyday wear. If the clothing does not qualify as a deductible expense (i.e. as a uniform), then these payments must be treated as a taxable fringe benefit and are subject to income, social security, and Medicare taxes. Thus, a police officer uniform qualifies for exclusion from income. However, a detective's suit jacket and related clothing, since they are suitable for everyday wear, do not quali&as a uniform and are taxable to the employee. 2 3. Section 2.17.3 Personal Protective Equipment Public Works Director Dhuse provided revised language for the section below so that we may maintain compliance with federal standards. Section 2.17.3.4 Safety Vest A hi,yh-visibility safety vest shall be worn when an employee is in a flagging position and/or when working in a traveled right-of-way, in accordance with the provisions set forth in the U.S. Department of Transportation Federal Hi, hhwwayAdministration's Manual on Uniform Traffic Control Devices (MUTCD). 4. Section 4.1 Vacation Leave At the January 19, 2012 meeting, the Administration Committee agreed to amend the vacation time schedule to match the schedule that was approved in the Public Works union contract and to create a separate schedule for exempt employees. Upon further review of the Public Works union contract, it was determined that, in addition to adding a 200-hour level of vacation time, the schedule also expedited the years of service required to achieve the next level of time by one year. For example, according to the current employee manual, employees must work 6 years to earn 120 hours of vacation. Per the Public Works union contract, employees only need work 5 years to earn 120 hours of vacation. That change has now been reflected in the proposed amendment to the employee manual and formatted in an easier to read table. Non-exempt y a eliki le N* *ime employees Years of Service Completed Vacation Time Credited 6 months 40 hours 1 year 40 hours 2, 3, 4 80 hours per year 5, 6, 7, 8, 9 120 hours (per year 10, 11, 12, 13, 14 160 hours (per year 15+ 200 hours (per year 40 lteuF_Q One (4) vear 40 heur& L th.nea. h teH (40) tvars 420 h e ..nn EleveH 11 t1 1 fifteeH 1 160 1 vear-s A*teen N 6) years or mere inn "= "129 I'aa Exempt employees Years o 'Ser vice Completed Vacation Time Credited 6 months 40 hours 1 year 80 hours 2,3 4 120 hours 5, 6, 7, 8, 9 160 hours 10+ 200 hours *h th rau > less- th,H „ wai, �n hours EleveH (41) vear-s or mare inn h 3 Next Steps A clean copy of the revised Employee Manual, incorporating all changes made by the Administration Committee, will be sent to our Labor Attorney for review. Should the labor attorney determine that substantial changes to the content of the Manual are needed, it will be brought back to the Administration Committee to review those changes. It is my hope that a final copy of the revised Employee Manual will be presented to the City Council for approval in April for an effective Date of May 1,2012. 4 TRACK CHANGES COPY—DRAFT EMPLOYEE MANUAL 02-07-12 C^ SECTION 5 Sevar-ationSEPARATION Tt MEFY l.°... fne f to rwittir-e employee's inveltiat t; .a from City sefviee with due to laek of work or ftmds. The required number of employees may be laid off in the Ordef Of the4 in a*y or-def. Ew.13loyees shall be notified by eer"ed mail at 1 (90) da-vs befefe theif separ-ation. Reasons for-seleetine the employees to be separ-ated shall be doeumented and maintaine4-on file to .,t t; , taken. in the event of a 1 , >.ff emploi,ees laid off shall be Waged oo:Lpfg&-,°„t;.,l hir-itw list for-a i3efiod of no less diaii two (2) Yeafs. Re hifi.iiR shall be in fevefse ofder-of separ- idi tha4 the ° loy ° laid of has the shills and ability for-the job t., be filled. No employee be fedueed in r-a-nk, pay, of title fof any feasoft othef than diseii3linafy fe sons. Reduetion of fafik; ,oav: or-title r-equir-es 2i3 .ate of the City r,., nei for-all ° to >° Section 5.12 Termination An employee may be terminated only the Mayor, following a recommendation by the Department Head and the Dir-eet^r of Human Resources Manager to the City Administrator. The Department Head shall consult with the Human Resources lenManager prior to such action to assure proper and complete documentation is on hand and to forward copies of such documentation to Human Resources at that time. A full-time employee who is terminated will be paid for all unused vacation leave at the time of termination (employees who do not leave in good standing are not accorded the benefit of payment for accumulated vacation leave). I[B025iThe employee shall receive his/her final check on the first pay date following the date of his/her termination. Section 5.23 Employee Termination and Exit Process Section 5.23.1 Service Retirement This is voluntary termination after having satisfied the age and length of employment requirements of the applicable state retirement system. The Eemployee must receive retirement wages upon termination to be considered as retired. Section 5.23.2 Disability Resignation This is voluntary termination necessitated by an injury or illness, which renders the employee incapable of performing his/her usual job. The termination is preceded by a memo/letter by the employee to his/her supervisor advising of the disability ruling, date of termination, supporting documentation, and a ruling by the gppropriate Board or Industrial Insurance Division verifying the disabili�y and approving the resignation. Section 5.23.3 Employee-Initiated Resignation This is voluntary termination for any reason other than formal retirement. A non-exempt employee wanting to leave the City in ,good standing shall hall provide a written resignation to his/her immediate supervisor at least fourteen (14) calendar days prior to the effective date of resignation. An exempt employee is required to notify the immediate supervisor at least thiM (30) calendar days prior to - 84 - TRACK CHANGES COPY—DRAFT EMPLOYEE MANUAL 02-07-12 the effective date of resignation to leave the City in good standing. The resignation letter should include the reason for leaving, as well as the proposed effective date. Notice is understood to mean that the resigning employee will be available for work during this time so as to aid in the training replacement. Failure to provide proper notice may result in a forfeit of accumulated vacation and/or sick leave time. Exceptions to the time limit requirement may be granted by the Department Head and Human Resources DifeetorManager. Section 5.23.4 Probationary Termination This is termination of an employee during the established introductory period, usually for the inability to meet position/department requirements. An robationary termination occurs only after the supervisor's consultation with the Human Resources lenManager, and must be reviewed by the City Administrator and approved by the Mayor. Section 5.23.5 Layoff A reduction in work force is accomplished in accordance with labor contracts and civil service rules; however, work schedules should be planned to keep periodic or recurring layoffs to a minimum. In layoff, recall and filling regular job vacancies, the City shall give equal consideration to an employee's ability and performance of the duties required in the job, and consideration to an emplo. length of continuous service with the City in the classification. In applyin_provision, where qualifications, experience and performance are equal, seniority, s�govern. Every effort will be made for transfers to other departments when a position is open for which the employee qualifies. The Ci . shall provide an employee with at least two (2) weeks advance notification prior to layoff, except in case of emergency. Severance pay may be offered at the discretion of the Mayor with input from the City Council. An employee on layoff must keep the City informed of the address and telephone number where he/she can be contacted. If the City is unable to contact the employee within seven (7) calendar days, the City's obligation to recall the employee shall cease. The City shall have no obligation to recall an employ after he/she has been on continuous layoff for a period which exceeds one (1) year. Should an employee not return to work when recalled, the City shall have no further obligation to recall him/her. Section 5.23.6 Exit Interview Human Resources will schedule an exit interview with the employee on his/her last day of employment. Temporary employees do not participate in the exit interview process unless information can be gained which will improve or enhance present employment conditions. Prior to the exit interview, a letter concerning COBRA or continued health insurance will be sent out to the employee (full-time only; see Medical/Dental Continuation Plan. The employee should bring the COBRA insurance letter to the exit interview for further discussion. Human Resources will also review the following with the employee where applicable: • IMRF withdrawal form - 85 - TRACK CHANGES COPY—DRAFT EMPLOYEE MANUAL 02-07-12 •vacation, sick, and compensato try ime pay due •partial pay for exempt employ • flexible spending plan • tuition reimbursement • items to be returned to the City • terminating or extending other benefits (for example, supplemental life insurance) The employee should also turn in his City ID card and any City building keys at this time. Human Resources will then conduct the actual exit interview. The information collected in the interview is used to monitor employee morale and correct problems, if necessary. Typical questions asked in the interview include: 1. What did you like best/least about working for the City? 2. What did you like best/least about.position? 3. Were you satisfied with the working relationship,you had with your sLipervisor? 4. How would you improve department or City,procedures to make this a better place to work? 5. Would you recommend the City to friends and/or relatives as a place to work? 6. Why are you leaving the e City? 7. Do you have any other comments or suggestions? Special questions may also be developed by the Human Resources 13ivisienManager and/or Department Head for the exit interview. Copies of the completed exit interview will be distributed to the appropriate Department Head and the City Administrator. Employees shall receive pay for work performed through the last hour worked and for unused benefits as stipulated by policy and laws governing such payments. Termination pay shall be reduced by any authorized legal deductions, authorized pension plan, credit union, tax-sheltered annuity, t4ited bunion dues and any other amounts specifically agreed upon orally or in writing by the employee and the City. Section 5.23.7 Final Paycheck Before the final paycheck is issued to the employee, the employee shall be required to follow the clearance process. The terminating employee is responsible for ensuring all appropriate items have been returned. Failure by the terminating employee to return City equipment may result in delay of receipt of the final paycheck. Section 5.23.8 Termination Date The official date of termination will be the last full day the employee reports for work. Section 5.23.9 Continuation of Benefits Benefits continue through the time actually worked by the employee. Section 5.2.9.1 Continuation of Benefits for Retirees - 86 - TRACK CHANGES COPY—DRAFT EMPLOYEE MANUAL 02-07-12 Retirees may elect to continue participation in the City's group health, dental, and vision insurance plans. To take advantage of this benefit, a retiree must have 8 years or more of creditable service under the Illinois Municipal Retirement Fund and be eligible to immediately receive a pension or have 20 years or more of creditable service under the Police Pension program. The retiree must accept or reject the plan at the time of retirement and may not join at a later date. Acceptance must be shown by written consent within 15 days of receiving the notice from the City that the plan may be continued as provided for in the Illinois Insurance Code. The Plan will be extended to the retiree and only to those dependents covered prior to the time of retirement of the City employee. The retiree will pay the entire premium as established by the insurance carrier, and the City will administer the plan. Failure to pay premiums will result in termination from the plan. Once the retiree or any of his dependents leaves or is terminated from the plan, the insurance is not renewable. When a retiree becomes eligible for Medicare, the plan provides for a reduction in benefits and premium. The spouse of a deceased employee is eligible to continue on the plan until his or her death or remarriage under normal plan provisions. In the case of dependents, they may remain covered following normal plan provisions. The provisions of the Public Safety Employee Benefits Act, 820 ILCS 320/1, et sec., shall apply to those employees who are full-time police officers killed or catastrophically injured in the line of duty. Section 5.23.10 Pension Contribution Refunds For those employees who are not retiring, moneys accumulated in the employee's retirement account are refundable; however, employees should check with their pension plan about the advantages and disadvantages before making a decision. Forms required to request this refund are available in the Human Resources Division. Section 5.23.11 Unemployment Compensation All claims for unemployment compensation as filed by a terminating employee shall be processed by the Human Resources Division and the Finance Department. Requests for information about unemployment compensation should be forwarded to the Human Resources Division immediately to avoid unauthorized charges against the City's account. Section 5.34 Use of Paid Time Paid time (e.g. personal days, vacation days, compensatory time) or time off for all employees may not be used during the last two (2) weeks of employment unless approved by Human Resources. Section 5.4- Vacation Pay-Out at Termination - 87 - TRACK CHANGES COPY—DRAFT EMPLOYEE MANUAL 02-07-12 Empiv¢°c-cs--c:cre to be eempensated fef all ,,,,,,"cd=cccccccroir leave—cr ccnirnrcrcrvrr if they leave 3 ge B026] Upon termination of employment, the employees �yho leave in good standin�[M0271 shall receive prorated accumulated vacation pay on the basis of 1/12 for each full month worked past the employ. eppointment date, based upon the employee's vacation time determined by length of employ Section 5.56 Sick Pay-Out at Termination An employee who is eligible upon separation to collect a retirement pension under IMRF or the Police Pension Fund, who leaves the City's employment [through retirement, a reduction in force, or voluntary resignation] and has been employed by the City for more than tenrtwen 0920) years shall be paid for all unused sick leave at fifty (50%) of his regular rate of pay for all accumulated and unused sick leave up to 960 hours. Section 5.68 Medical/Dental Continuation Plan (COBRA) Under the Consolidated Omnibus Budget Reconciliation Act of 1985 (COBRA), all employers, including state and local governments, are required to extend continuing health care coverage to employees and their dependents following termination, a reduction in hours (full-time to part-time), retirement, divorce or death. If an employee terminates employment for any reason, other than gross misconduct, or reduces hours and such employee was covered under the City's Group Insurance Plan on the day preceding termination or reduction, then such employ. e�y continue medical/dental coverage for himself/herself and any eligible dependents who were also covered during such time by making payment for the cost of such coverage. Section 5.68.1 Eligibility Requirements Individuals eligible for continuation or coverage include an employee and his/her covered dependents whose coverage would otherwise terminate due to: 1. Termination of employment for any reason other than gross misconduct; 2. Reduction of hours worked by the employ 3. Retirement, but only if the employee's coverage under the City's plan terminated on the date of his/her retirement; 4. An employee's spouse and dependents upon the death of a covered employee, divorce or legal separation; 5. The covered employee becoming entitled to benefits under Medicare, but only if at that time the employee's coverage and the employee's dependents coverage under the City's group health plan terminates; 6. A dependent child when he/she no longer qualifies as a dependent under the City's group health plan. Any of these individuals who are eligible for continuation of coverage shall be referred to as the "COBRA Applicant." Section 5.68.2 End of COBRA Coverage The coverage of the COBRA Applicant will end on the earliest of the following dates: - 88 - TRACK CHANGES COPY—DRAFT EMPLOYEE MANUAL 02-07-12 1. The date on which the COBRA Applicant becomes a covered employee under any other group health plan; 2. The date on which the COBRA Applicant becomes eligible for coverage under Medicare. In this case, any eligible_ dependents of the COBRA Applicant will, sub ect to payment of the required premium, be entitled to their COBRA health continuation for the remainder of the period; 3. The date on which the City's plan terminates; 4. The date which is: • Eighteen (18) months after the date on which the employee, as the COBRA Applicant, becomes eligible for the COBRA health continuation; or • Thirty-six (36) months after the date on which the widowed spouse, the former spouse, the legally separated spouse, or a dependent child, as a COBRA Applicant, becomes eligible for the COBRA health continuation. If a person's COBRA health continuation ends at the end of the maximum period (i.e., eighteen (18) months or thirty six (36) months), such person will be eligible for any health conversion coverage that is available under the group health plan. Section 5.7 Re-Employment Any former regular employee who resigned from the Ci . in good standing or who was laid off as part of a reduction in work force is eligible for re-employment. Persons interested in re-employment should file a completed city application with the Human Resources Division. The individual will then proceed through the regular hiring_procedures with other applicants as described in the Hiring Pfoeess Policy in Section 6.3 of this manual. If this individual is re-hired, he/she must ffwe4coMplete a pre- employment physical and drug test and a background check. An individual re-employed in his/her former position may be paid at the same pay rate at the time he/she left the City, provided however, that the re-employment is within one (1) year of the previous resignation; otherwise the individual will be paid in accordance with Human Resource polio The compensation of an employee re-hired to a position other than the former position will be subject to provisions for new hires. Any individual who voluntarily resigns from full-time employment the City shall forfeit all seniority and accrued years of service. Should that individual become re-employed by the City all benefits for which the employee is eligible will be subject to the same provisions as a new hire and will coincide with the re-employment date. Any individual who is laid off from full-time employment and who later becomes re-employed by the City shall retain service credit for prior years worked. The City shall take into account previous service credit when calculating benefits for which the employee is eligible; however, future benefits will coincide with the re-employment date. V.,e do el; ib l;t .will be based on weviatts City serviee ;f,-0 1,;,-e . .;t1,;,, one The date of hife will take the per-son's ofevious sef-viee with the City into aeeettot; howevef, fittufe will eeineide with the, employment date. The ,,.7;..idua 's *•+-c-`vivp—p-r-sopmcl file will be—r-e activated viiee fe employed by the - 89 - TRACK CHANGES COPY—DRAFT EMPLOYEE MANUAL 02-07-12 All individuals re-employed by the City must complete a new introductory_period. Section 5.89 References The City shall normally provide limited disclosures regarding former employees' work history, which shall be limited to: the dates of employment; descriptions of the jobs performed, salary or wage rates. However, if the former employee has signed an "Employment Reference Release Form" (Appendix M), additional information maegiven. "Employment Reference Release Forms" outline what information relating to the former employee, the City will disclose and to whom it may be disclosed. Release forms may be obtained from the Human Resources Division. Signed "Employ Reference Release Forms" shall be maintained in the employee's personnel file in the Human Resources Office. - 90 - TRACK CHANGES COPY—DRAFT EMPLOYEE MANUAL 02-07-12 Seed(mSECTION 6 Person„* Draetiee°PERSONNEL PRACTICES Section 6.1 Equal Employment The United City of Yorkville has adopted an Equal Employment Policy as described in Resolution 93-18 (10-25-1993). It reads as follows with modified changes to be currently compliant with Federal, State, and Local laws: a. It is the policy of the United City of Yorkville to promote nondiscriminatory practices in its hiring and its contractual undertakings. It is the policy of the City to conform with all aspects of Federal Civil Rights legislation including the Equal Employment Opportunity Act(42 USC §2000), and all State Civil Rights Legislation. b. No person shall, on the grounds of race, color, religion, sex, age, national origin, physical or mental disability, ancestry, martital status, sexual orientation, or veteran status (except those dishonorably discharged), all in accordance with applicable law or any other status protected by law be excluded from participation in or be subjected to discrimination in any program or activity funded in whole or in part by Federal funds. C. The City Administrator and Mayor shall oversee civil rights compliance. Section 6.2 Recruitment It is the policy of the United City of Yorkville to afford equal employment opportunity in all personnel practices to all qualified individuals without regard to race, color, religion, sex, sexual orientation, age, national origin, physical or mental disability, ancestry, marital status, or veteran status (except those dishonorably discharged), all in accordance with applicable law. Section 6.34 Hiring Policy Section 6.34.1 Applicability to other policies, regulations, and agreements Whenever the provisions of this policy are in conflict with state or federal law or regulations, or a collectively bargained agreement between the City and a certified bargaining unit, the provisions of the collective-bargained agreement and/or governmental law or regulation will prevail. Section 6.34.2 Approval to Recruit Personnel In order to recruit personnel for a:ob opening, the Department Head must have an gPproved, description and identified, approved funding in the annual operating budget. If both of these conditions are met, recruitment may begin at the budget designated point for new positions, or immediately for existing but vacant positions. If the position is not approved with the adoption of the annual operating budget, the requesting department must provide Human Resources with written justification as to the need, reasoning and financing of the new position. This information will be forwarded to the City Administrator for review - 91 - TRACK CHANGES COPY—DRAFT EMPLOYEE MANUAL 02-07-12 and recommendation. The request will then be submitted for City Council consideration, with the City Administrator's recommendation attached. If an approved job description does not exist, the requesting department must follow the Job Description Creation Policy, as outlined in Section 6.5. Section 6.34.3 Job Posting Process For all job postings, an internal and external posting shall be completed. The following procedures for both postings shall apply: a. Internal: Applications and/or resumes must be submitted to Human Resources. Human Resources will announce the position opening to all City personnel via email and by posting notices on City Hall bulletin boards. City departments will be responsible for posting position announcement to their respective departmental personnel to assess interest and qualifications of internal candidates. Announcements for internal postings will be open for a minimum of five (5) working days. b. External: Position opening will be announced by Human Resources, and will be open for a minimum of ten (10) working days. Applications and/or resumes must be submitted to Human Resources. Posting will be made available on City Hall bulletin boards and other means as Human Resources and the department heads decide to generate the best pool of qualified candidates. Announcements shall summarize the primary duties of the position, standards for consideration, compensation, and application deadline. C. For all hiring processes, no applications will be accepted after the closing date. Section 6.34.4 Selection Process Human Resources and the appropriate department head and/or supervisor will base the selection on the requirements and qualifications established for the position and the relevant work experience, technical knowledge, educational background, general aptitude, compatibility and personal and professional references of the candidates. Aside from the screening process, selection techniques may include oral interviews, reference checks, written examinations, medical examinations, physical agility tests, psychological evaluations, performance evaluations, assessment centers and other measures that are job related and reliable as a predictor of performance. Section 6.34.5 Job Offer Upon selection of a final candidate, a salary offer will be made within the approved salary range for the position with review and approval by the City Administrator, except for salary offers made at the minimum of a range, which do not require City Administrator approval. Acceptance of the offer shall be documented via offer letter. All offer letters and acquisition of official employment status with the City shall be contingent upon satisfactory completion of a background check and drug and alcohol test, which shall be administered immediately after offer acceptance and completed prior to the starting date of the employee. Section 6.4- Job Description Creation - 92 - TRACK CHANGES COPY-DRAFT EMPLOYEE MANUAL 02-07-12 Section 6.45.1 New Positions New job descriptions shall be reviewed and/or revised by Human Resources and reviewed and/or revised and approved or denied by the City Administrator and Mayor. For all new positions, department heads and supervisors are encouraged to contact Human Resources to assist in the first-draft of the job description. New position job descriptions shall be drafted in a format approved by Human Resources. The job descriptions shall be created with consideration for the position's role in the organizational hierarchy in the present and short-term and long-term future. Section 6.45.2 Existing positions All requests for amendments to an existing_position's job description shall be reviewed and/or revised by Human Resources and reviewed and/or revised and approved or denied by the CitX Administrator and Mayor. No job description amendment to an existing_position shall result in a salary range reclassification, as salary ranges are approved by City Council. Requests for amendments to job descriptions that substantially alter the position's roles and responsibilities, educational and experience requirements, FLSA status, positions supervised, or positions supervised by may be treated as new positions, and subject to [Section x.x3.11. Section 6.56 Personnel Records Section 6.56.1 Maintenance of Records I3 ien4 14eadsHuman Resources shall maintain personnel records of each employee containing the employee's name, title, department, starting date, salary, change in employment status, training received, disciplinary actions, or other such information as may be considered pertinent. Medical records shall be filed separately from personnel records. Work-/&Salary historyies will be maintained permanently. Section 6.56.2 Confidentiality All employee records shall be considered "CONFIDENTIAL" and shall not be released to outside parties except where consistent with the Illinois Personnel Record Review Act, 820 ILCS 40/01.01 et. seq., or as authorized by the individual employee. Section 6.56.2.1 Employmeen4 review of records TEXT FROM4,AW An employee y request to review his or her personnel file, pursuant to the limitations set forth in the Illinois Personnel Record Review Act (820 ILCS 40n. The City shall ,grant employees at least 2 inspection requests in a calendar year. [BO281 Section 6.56.3 Standardized forms Personnel evaluation,_abseffteeir, I g ie� cas, and othef-job performance and employment records shall be standardized by Human Resources, and will apply to all City personnel. Section 6.56.4 Notification process for Employment Status Changes*& 4;,,.,nee )Weet^" - 93 - TRACK CHANGES COPY–DRAFT EMPLOYEE MANUAL 02-07-12 With the promotion, demotion, or termination of employment of any employee, the appropriate Department Head must file a written notice ofd said action with Human Resources, the Finance Director, and the City Administrator, who will notify the Mayor.- Section 6.6-7 IX—Probationary Period A formalized sixtwelve-month evaluation and probationary period are in effect for all newly hired and promoted employees. The supervisor of the newly hired or promoted employee shall furnish a performance evaluation report to their supervisor at the 90-day mark and at the end of the probationary ep riod„t the time of appointment for- al employees. The evaltiation per-i to be t-Feated as an Serious evaluation shall be made as to the employee's work record, attendance, compatibility, and any other aspect of job performance deemed necessary to insure the highest level of performance. immediate . The existenee an&or- eompletion of the evaluation and pr-obationafy period do not imply dia4 the employee has a eentfaettial right to eenfii+iied emplayi:nent with the Upon a satisfactory performance evaluation, the employ. eiprobationM period shall be deemed complete, and the employee shall attain unencumbered full-time or part-time status. Upon an unsatisfactory performance evaluation, the employ. e�y be transferred to a previous position or terminated by the Department Head with the concurrence of the City Administrator. - 94 -