Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Administration Packet 2011 06-16-11
o United City of Yorkville 800 Game Farm Road EST. '� 1836 Yorkville, Illinois 60560 -e. i Telephone: 630-553-4350 Fax: 630-553-7575 Cou* �? SCE AGENDA ADMINISTRATION COMMITTEE MEETING Thursday, June 16, 2011 6:00 p.m. City Hall Conference Room Citizen Comments: Minutes for Correction/Approval: May 19, 2011 New Business: 1. ADM 2011-26 General Fund Income Statement for May 2011 2. ADM 2011-27 Budget Report for May 2011 3. ADM 2011-28 Treasurer's Report for May 2011 4. ADM 2011-29 Cash Statement for April 2011 5. ADM 2011-30 Prevailing Wage Ordinance 6. EDC 2011-21 Proposed Policy for Dormant Zoning Applications/Petitions Deposits 7. CC 2011-48 City Debt Obligations and Options 8. ADM 2011-31 Committee Liasons Old Business: Additional Business: UNITED CITY OF YORKVILLE WORKSHEET ADMINISTRATION COMMITTEE Thursday, June 16, 2011 6:00 PM City Hall Conference Room --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1. May 19, 2011 ❑ Approved ❑ As presented ❑ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- l. ADM 2011-26 General Fund Income Statement for May 2011 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2011-27 Budget Report for May 2011 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2011-28 Treasurer's Report for May 2011 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 4. ADM 2011-29 Cash Statement for April 2011 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 5. ADM 2011-30 Prevailing Wage Ordinance ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 6. EDC 2011-21 Proposed Policy for Dormant Zoning Applications/Petitions Deposits ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 7. CC 2011-48 City Debt Obligations and Options ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 8. ADM 2011-31 Committee Liaisons ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- ADDITIONAL BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- c/Ty Reviewed By: Agenda Item Number 2 i o J a T Legal ❑ Minutes Finance ❑ EST. 1 � 1836 Engineer ❑ Tracking Number y City Administrator ❑ °^Y `O Public Works ❑ dal Cou^ty El`E Agenda Item Summary Memo Title: Minutes of the Administration Committee— May 19, 2011 Meeting and Date: Administration Committee 6/16/11 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: UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE Thursday, May 19, 2011 at 6:00 p.m. City Hall Conference Room COMMITTEE MEMBERS PRESENT: Carlo Colosimo,Alderman George Gilson,Alderman bry" Rose Spears,Alderman Marty Munns,Alderman OTHER CITY OFFICIALS PRESENT: $ Bart Olson, City Administrator Bill Powell, Treasurer _ Rob Fredrickson, City of Yorkville Alderman Spears called the meeting to order at 6:00 p.m. Citizen Comments: Ms. Kathy Neddo stated she is here for two things. She was advised by her alderman to attend to have the healthcare for alderman on the agenda. Ms. Neddo thinks that the people of Yorkville should vote on healthcare for the alderman. Ms. Neddo stated that she is struggling with the fact that the city is under financial stress and cutting all areas, but yet this item is costing us taxpayers a lot of money to do. Ms. Neddo stated that if the people are for it then okay. But she feels that it was a self imposed benefit. Ms. Neddo stated that she thinks it needs to be discussed in committee. She stated that she will get a petition to get a vote by the people if they don't address it. Alderman Spears stated that first it will go to committee then to council. Ms. Neddo stated that was fine. Ms. Neddo then addressed the senior garbage. Ms .Neddo stated that she knows that Alderman Spears wants to take care of the needs to the seniors. But Ms. Neddo stated that not every senior needs to have it. There needs to be some criteria. Ms. Neddo stated that the taxpayers continue to subsidize more than we need to. Ms. Neddo stated that our taxes went up 48% this year. Ms. Neddo stated that a criteria needs to be put in place for senior garbage. Ms. Neddo addressed adding two more alderman. She said that we are only 1000 people over to add two more alderman. Ms. Neddo stated that she doesn't think it is a good idea to add two more alderman for only that many more people. Mr. Olson stated that the number is 921. Ms. Neddo stated that shifting the wards might be a better solution to make them more equal. Minutes for Correction/Approval The minutes were approved from April 21, 2011. New Business: 1.ADM 2011 — 17 Number of Alderman and Redistricting Ms. Spears stated the bill HB59 70. Alderman Colosimo stated that bill has passed and we are able to use it. Alderman Colosimo stated that he agrees with Ms. Neddo. We do not need two more alderman. We are at the bottom of the population and redistricting would make sense. Alderman Spears agreed that 8 alderman is working fine. Mr. Olson stated that they can take that to the June 14th City Council meeting. Alderman Colosimo stated that they need to look at the map and the numbers. The numbers are a little skewed. The city administrator asked us what we value most on how we do the math. Alderman Colosimo stated that equally distributing the wards would be better and he said that he would like to keep the alderman in their wards. Alderman Colosimo stated that people know their alderman and feel comfortable with their alderman. Aldennan Spears agreed that the top priority would be keeping them in their existing wards and population second. Alderman Spears stated that she doesn't think that boundaries are that important. Alderman Spears stated that we could have public hearings to let the people know what we are doing. Mr. Olson stated that you can, but you do not have to. Alderman Colosimo stated that we have to have maps prepared when we do this. He stated that you cannot have a session to get input without a map. Mr. Olson asked if the alderman wanted a public input session. Alderman Gilson stated that he thinks we get a map put together first. Mr. Olson stated that we are 11 months out and the redistricting we don't have to do for over a year. Mr. Colosimo stated that the sooner the better so that those interested in running have time to decide. Mr. Olson stated that he will type up something regarding the four wards stating that we want to even the wards and keep everyone within their ward. Mr. Colosimo stated that he would like to keep the same ward numbers. Mr. Olson stated that the resolution will go forward to city council and the maps will be worked on. Alderman Spears asked who does the maps? Mr. Olson stated probably in-house. Mr. Olson stated that the alderman can then look at the maps and decide on which one they want to use. 2.ADM 2011 — 18 Senior Garbage Subsidy Alderman Spears stated that this has been brought up several times. Alderman Spears stated that she has minutes of a city council meeting in April 2010 discussing the senior garbage. Alderman Spears stated that she had an e-mail she received from the Northeastern Illinois Group on Aging. They are deciding on what programs they are cutting. They are proposing on cutting benefits by 50%. The Meals on Wheels state funding will be cut by 9%. Alderman Spears stated there are a lot of community based services being cut by 20.8%. Alderman Spears stated that the senior help line will be cut by 44%. Alderman Spears stated other cuts are 60%to grandparents raising grandchildren. Over 60% to foster grandparents program. Alderman Spears stated that over 40 million in other funds. Alderman Spears stated that these cuts are really going to affect our seniors. Alderman Spears stated that she is worried about how they are going to be affected. Alderman Spears stated that maybe we can get the seniors smaller cans since they don't have as much trash. Alderman Spears asked what the procedure is. Alderman Spears stated that it was to be left alone until April 2012 when the contract is going to be renewed. Alderman Spears stated that we should wait until then. Alderman Gilson stated that several seniors have contacted him personally. He stated that they stated they have fixed income and the standard of living is going up and incomes are staying the same. Alderman Gilson stated that the seniors want them to leave it where it is. Alderman Colosimo said the he is torn. He doesn't see it as you have the subsidy or you don't. Alderman Colosimo stated that there can be criteria and we can leave it until April 2012. Alderman Colosimo stated that maybe a tier system would work. He stated that getting rid of the subsidy would negatively affect many seniors in our community. Alderman Colosimo stated that everyone pays the same unless you bring in your tax return and see if you qualify for the subsidy. Alderman Colosimo stated that we can talk about options of bigger and smaller cans etc. Mr. Olson stated that you can do pay as you throw with stickers. Mr. Powell stated that we use containers. Mr. Olson stated that some places can do discounted stickers. Alderman Gilson stated that he doesn't want to get rid of the container program. Alderman Colosimo stated that the stickers could be a problem with a lot of complaints. Alderman Spears stated that she believes that there are smaller cans available. Mr. Olson stated that is the case, but you pay the same price. He stated that in the next contract we could recommend different price for different sizes. Alderman Colosimo stated that when the contract comes up we bring this back up. All alderman agreed. Mr. Olson stated that September or October would be a good time. 3. ADM—2011 19 Budget Report for April 2011 Mr. Olson stated that his general comment on this is this is a cash basis even though they are posted in April 2011 they are dated back to January. He stated that for the expense side the April 2011 numbers are not final. There are others to approve in June, maybe July and August. He stated that if it is before April 301h it goes in this fiscal year. Aldennan Spears asked on general fund revenue for cable utility tax she said they need to know exactly how many AT&T boxes are in there because they pay 1%. AT&T asked how many because that I% comes back to us. Mr. Olson stated that is a 5% franchise fee and a I%peg fee. He stated that we should be able to do the math on what they sent us. Mr. Olson stated that if they don't get anything, we have the authority to audit their books. Alderman Spears stated that the city will take care of it. Alderman Spears asked about Cobra insurance reimbursement. She asked for an explanation of that. Mr. Fredrickson stated that it has been broken down for greater detail. Alderman Spears asked if all employees are entitled to Cobra. Mr. Fredrickson stated yes for up to two years. Mr. Olson stated there is no subsidy from the federal government now. The former employees now pay 100%. Alderman Colosimo brought up the Rec Center numbers. He stated that we need to take a look at getting someone to take the lead on that department. There are many overages as far as what was budgeted and what was used. He stated that if you have someone full-time checking the numbers and you will get more efficiency. Alderman Colosimo stated that Mr. Olson is doing a good job, but might be overworked. Alderman Colosimo stated that all things are going over budget. Mr. Olson said there are three people that should be held accountable, him, the park board, and the facility coordinator. We have told them to talk to the employees when they go over budget on classes etc. Mr. Olson stated that in September and October we addressed it and addressed it and he thinks that it is fixed. Mr. Olson doesn't think that there is a need to add someone. Alderman Colosimo stated that with any department there needs to be a go to person to hold accountable. Alderman Colosimo stated that not all people want it, but we have it and need to stay within budget. Mr. Olson stated that we are trying to keep costs in-house. Alderman Munns stated that Mr. Olson needs to make a presence there once and awhile. Mr. Olson agreed. Mr. Olson gets reports regularly on how things are running at the Rec Center. Alderman Gilson stated that he has several issues with expenses at the Rec Center. Mr. Olson stated that the Mayor asked him to get together some information on the Rec Center for the June 14th meeting that way we can decide if we want to purchase the building versus paying for leasing it. Mr. Olson said that it was talked about at Park Board. Mr. Olson stated that it would be cheaper to purchase the building because we get rid of property tax. That is a financial threshold. It might be cheaper to run it. Alderman Colosimo stated that he doesn't know that it would be good to purchase, but he would like to see the numbers. Alderman Munns agreed. Mr. Olson stated that an appraisal would be $6,000 so the Mayor wanted to see if we wanted to spend the money on it. 4. ADM 2011 —20 Treasurer's Report for April 2011 Mr. Fredrickson read the numbers in budget. Alderman said the projected ending fund balance is positive. Mr. Fredrickson stated that it will probably be negative. There are expenses that need to be added and it will be closer to what you have in the budget document. 5. ADM 2011 —21 Cash Statement for March 2011 Mr. Fredrickson stated this is a listing of all the bank accounts the city has. It is divided between cash operations and cash for special purposes. Alderman Gilson was pleased to see a report like this. Mr. Fredrickson said that we are fully collateralized in a tri party system. Old Second pledges government securities so that if they go into default, we are protected. Alderman Gilson asked is there are any ramifications of that? Mr. Fredrickson stated that maybe a day or so because we are fully covered and should be okay. 6. ADM 2011 —22 IMET Presentation Mr. Fredrickson stated that IMET is a local government investment pool. We have funds coming in over the summer for our debt service. Illinois fund has a terrible rate right now it is one percent of one percent almost nothing. Mr. Fredrickson said that IMET offers us a better rate on return and liquidity. It is just as safe as keeping money in the bank. There is a one to three year fund. It has a five day liquidity. It is strictly U.S. Government securities. It is just a different investment tool that we can utilize as property tax money comes in this summer. We need to do a resolution at the June 14, 2011 meeting. 7. ADM 2011 —23 Committee Meeting Date and Time Alderman Spears stated that the meetings are the third Thursday every month. Everyone agreed on the time and date. 8. ADM 2011 — 24 City Council and Committee Meeting Procedures Alderman Spears stated that everyone agreed the governing ordinance was a bit too much. We had a lot of changes and amendments to it. It was difficult to follow in the meetings. Alderman Spears stated that she was in full agreement in repealing the ordinance and maybe we can come up with a different name for it. Alderman Gilson stated that it needs to be simplified and take the good things and clean it up. Alderman Munns agreed. Alderman Colosimo stated that it is a 10 page document and should be three. Alderman Colosimo stated that if we are not ethical we will not be in there for long and be in jail. The Alderman all agreed that it is redundant and not needed. Alderman Gilson stated that the people put their faith in us and we are not unethical the document just needs cleaned up. Alderman Colosimo stated that we might need some procedural things added. Alderman Colosimo believes that the Mayor appoints committees and could appoint vice chairman's too. The Mayor would like committee reports first. The Alderman discussed the purpose of committees and maybe raising number from three to four. Mr. Olson stated that the committees are used as a filter. Alderman Colosimo stated that if something doesn't clear a committee the four of us can still bring it up. Alderman discussed what name to use for the new document. Alderman agreed the Procedural Ordinance would work. Alderman wanted to look at document when done. 9. ADM 2011 —25 Account Signers—A/P Bank Account Mr. Fredrickson made the recommendation that the number of signers be reduced to four. I did ask auditors and they agreed that the fewer signers the better. Alderman Colosimo asked who else was able to sign previously. Mr. Fredrickson stated that all the Alderman could sign. Mr. Olson stated that it was helpful when there was an emergency situation. Mr. Fredrickson stated that the check number will be on the board report. Mayor or treasurer will need to sign all checks. Mr. Powell stated that signature sheets can be a big hassle. Mr. Powell is in favor of the new recommendation. All Alderman were in agreement. Mr. Fredrickson stated that the bank is already aware and the bank will issue new sheets. Mr. Powell stated that he thought we had to submit a letter to the bank as to who should be the new signers. Alderman Spears asked if we had to vote on this at committee level. Alderman voted and all were in favor. Old Business: There was no Old Business. Additional Business: sa. Kati, There being no further business, the Committee adjourned at 7:30 p.m. Minutes Respectfully Submitted by: Lisa Godwin, Minute Taker Reviewed By: Agenda Item Number Jam ' Legal ❑ NB #1 Finance EST. 183e Engineer El--��_ Tracking Number © 0 City Administrator El �! ,v. O� Consultant E] ADM 2011-26 ou ❑ LE Agenda Item Summary Memo Title: General Fund Consolidated Income Statement Meeting and Date: Administration Committee—June 16, 2011 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 STATEMENT OF REVENUES,EXPENDITURES AND TRANSFERS For the Period Ending May 31,2011 %of May YTD YTD to FY 2012 Actual Actual Budget Budget GENERAL FUND(01) Revenues Local Taxes Property Taxes 424,209 424,209 15.9% 2,665,964 Municipal Sales Tax 169,093 169,093 6.6% 2,550,000 Non-Home Rule Sales Tax - - 0.0% - Electric Utility Tax - 0.0% 591,600 Natural Gas Tax - - 0.0% 290,700 Telephone Utility Tax 42,899 42,899 8.0% 535,500 Cable Franchise Fees 56,358 56,358 27.6% 204,000 Hotel Tax 2,934 2,934 9.6% 30,600 Amusement Tax 181 181 0.1% 134,000 Admissions Tax - - 0.0% 190,000 Business District Tax 18,453 18,453 6.2% 300,000 Auto Rental Tax 687 687 9.6% 7,140 Para Mumel Tax 2,733 2,733 18.2% 15,000 Total Taxes 717,547 717,547 9.5% 7,514,504 Intergovernmental State Income Tax - - 0.0% 1,340,000 Local Use Tax 19,635 19,635 9.4% 210,000 Road&Bridge Tax 28,104 28,104 17.1% 164,296 Personal Property Replacement Tax 2,278 2,278 17.5% 13,000 Other Intergovernmental 4,052 4,052 36.2% 11,200 Total Intergovernmental 54,069 54,069 3.1% 1,738,496 Licenses and Permits Liquor Licenses 1,010 1,010 2.5% 40,000 Building Permits 21,392 21,392 17.5% 122,400 Other Permits/Licenses 623 623 19.2% 3,250 Total Licenses&Permits 23,025 23,025 13.9% 165,650 Fines and Forfeits Traffic Fines 14,457 14,457 15.2% 95,000 Administrative Adjudication 1,816 1,816 6.1% 30,000 Police Tows 8,000 8,000 8.9% 90,000 Total Fines and Forfeits 24,273 24,273 11.3% 215,000 Charges for Services Garbage Surcharge 124 124 0.0% 1,175,000 Collection Fee-YBSD - - 0.0% 123,932 Other Services - - 0.0% 5,000 Total Charges for Services 124 124 0.0% 1,303,932 Investment Earnings 3 3 0.2% 2,000 Reimb/Miscellaneous/Other Financing Sources Reimb-Legal Expenses 6,032 6,032 50.3% 12,000 Reimb-Health Ins Contributions 15,823 15,823 6.0% 264,800 Other Reimbursements 38,995 38,995 60.9% 64,000 Rental Income 1,100 1,100 12.2% 9,000 Miscellaneous Income 155 155 2.2% 7,000 Transfers In 16,249 16,249 8.3% 194,992 Total Miscellaneous 78,354 78,354 14.2% 551,792 Total Revenues and Transfers 897,396 897,396 7.8% 11,491,374 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES,EXPENDITURES AND TRANSFERS For the Period Ending May 31,2011 %of May YTD YTD to FY 2012 Actual Actual Budget Budget GENERAL FUND(01) Expenditures Administration 25,492 25,492 5.2% 489,551 Salaries 20,725 20,725 7.6% 273,395 Benefits 3,169 3,169 7.0% 45,106 Contractual Services 1,527 1,527 1.0% 155,100 Supplies 70 70 0.4% 15,950 Finance 17,243 17,243 5.4% 320,505 Salaries 12,812 12,812 7.3% 175,000 Benefits 2,350 2,350 7.7% 30,505 Contractual Services 2,081 2,081 1.9% 109,250 Supplies - - 0.0% 5,750 Community Relations 4,037 4,037 7.3% 54,950 Salaries 3,750 3,750 11.5% 32,500 Benefits 287 287 11.5% 2,500 Contractual Services - - 0.0% 16,550 Supplies - - 0.0% 3,400 Engineering 15,255 15,255 6.0% 253,136 Salaries 12,929 12,929 7.5% 172,500 Benefits 2,190 2,190 7.4% 29,736 Contractual Services 137 137 0.3% 42,100 Supplies - - 0.0% 8,800 Police 235,995 235,995 7.8% 3,018,230 Salaries 151,764 151,764 7.4% 2,052,500 Overtime 6,970 6,970 9.3% 75,000 Benefits 70,864 70,864 12.6% 560,900 Contractual Services 6,009 6,009 3.2% 190,010 Supplies 388 388 0.3% 139,820 Community Development 20,854 20,854 5.6% 375,610 Salaries 17,750 17,750 7.4% 240,000 Benefits 2,967 2,967 6.7% 44,535 Contractual Services 137 137 0.2% 84,450 Supplies - - 0.0% 6,625 PW-Street Ops&Sanitation 22,494 22,494 1.3% 1,796,870 Salaries 18,990 18,990 7.0% 270,000 Overtime - - 0.0% 15,000 Benefits 3,214 3,214 6.0% 53,500 Contractual Services 33 33 0.0% 1,336,020 Supplies 257 257 0.2% 118,350 Capital Outlay - - 0.0% 4,000 Administrative Services 380,181 380,181 8.6% 4,418,640 Salaries - - 0.0% 5,000 Benefits 281,158 281,158 16.1% 1,743,350 Contractual Services 18,903 18,903 1.1% 1,693,840 Supplies - - 0.0% 5,000 Contingencies - - 0.0% 10,000 Transfers Out 80,121 80,121 8.3% 961,450 Total Expenditures and Transfers 721,550 721,550 6.7% 10,727,492 Variance 175,846 175,846 763,882 A. D CO. Reviewed By: Agenda Item Number a� �.1% Legal ❑ NB #2 Finance EST. leas Engineer El~-� Tracking Number y City Administrator ■ �L7 Consultant ❑ ADM 2011-27 aLE ❑ Agenda Item Summary Memo Title: Budget Report for May 2011 Meeting and Date: Administration Committee 6/16/11 Synopsis: 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 MAY 31,2011 ACTUAL EXPENSES BY MONTH(Cash Basis) ear-to- ate NNU L ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-11 October-11 November-11 December-11 January-12 February-12 March-12 April-12 Totals BUDGET %of Budget GENERAL FUND REVENUES 01-000-40-00 4000 PROPERTY TAXES-CORPORATE LEVY 366,362 366,362 2,290,964 15.99% 01-000-40-00-4010 PROPERTY TAXES-POLICE PENSION 57,847 57,847 375,000 15.43% 01-000-40-00-4012 PROPERTY TAXES-FOX INDUSTRIAL 0.00% 01-000-40-00-4030 MUNICIPAL SALES TAX 169,093 169,093 2,550,000 6.63% 01-000-40-00-4040 ELECTRIC UTILITY TAX 591,600 0.00% 01-000-40-00-4041 NATURAL GAS UTILITY TAX 290,700 0.00% 01-000-40-00-4043 TELEPHONE UTILITY TAX 42,899 42,899 535,500 8.01% 01-000-40-00-4045 CABLE FRANCHISE FEES 56,358 56,358 204,000 27.63% 01-000-40-00-4050 HOTELTAX 2,934 2,934 30,600 9.59% 01-000-40-00-4060 AMUSEMENTTAX 181 181 134,000 0.13% 01-GOO-40-00-4065 ADMISSIONSTAX 190,000 0.00% 01-000-40-00-4070 BUSINESS DISTRICT TAX 18,453 18,453 300,000 6.15% 01-000-40-00-4075 AUTO RENTAL TAX 687 687 7,140 9.62% 01-G00-40-00-4080 PARA-MUTUELTAX 2,733 2,733 15,000 18.22% 01-G00-41-00-4100 STATE INCOME TAX 1,340,000 0.00% 01-000-41-00-4105 LOCAL USE TAX 19,635 19,635 210,000 9.35% 01-000-41-004110 ROAD&BRIDGE TAX 28,104 28,104 164,296 17.11% 01-000-41-00-4120 PERSONAL PROPERTY REPLTAX 2,278 2,278 13,000 17.52% 01-000-41-00-4160 FEDERALGRANT5 176 176 9,200 1.91% 01-GOO-41-00 4170 STATE GRANTS 3,876 3,876 0.00% 01-000-41-00-4182 MISC INTERGOVERNMENTAL 2,000 0.00% 01-000-42-00-4200 LIQUOR LICENSE 1,010 1,010 40,000 2.52% O1-GOO-42-00-4205 OTHER LICENSES 623 623 3,000 20.76% 01-000-42-00-0210 BUILDING PERMITS 21,392 21,392 122,400 17.48% O1-GOO-42-00-4220 FILING FEES 50 2 0.00% 01-000-43-00-4310 TRAFFIC FINES 14,457 14,457 95,000 15.22% 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 1,816 1,816 30,000 6.05% 01-000-43-00-4325 POLICE TOWS 8,000 8,000 90,000 8.89% 01-000-44-00-4400 GARBAGESURCHARGE 124 124 1,175,000 0.01% 01-G00-44-00-4405 COLLECTION FEE-YBSD 123,932 0.00% 01-G00-44-00-4412 SERVICE CHARGE-LIBRARY 0.00% 01-000-44-00-4414 OTHER SERVICES 0.00% 01-000-44-00-4417 REIMB.-MISCELLANEOUS 0.00% 01-000-44-00-4474 POLICE SPECIAL DETAIL 5,000 0.00% 01-000-45-00-4500 INVESTMENT EARNINGS 3 3 2,000 0.17% 01-GOO-46-OOA601 REIMB-LEGAL EXPENSES 6,032 6,032 12,000 50.27% 01-000-46-00-4650 REIMB-TRAFFIC SIGNAL 15,000 0.00% 01-G00-46-00-4668 REIMB-COBRA CONTRIBUTIONS 20,000 0.00% 01-000-46-00-4669 REIMB-RETIREE CONTRIBUTIONS 50,000 0.00% 01-000-46-00-4670 REIMB-EMP INS CONTRIBUTIONS 8,166 8,166 190,000 4.30% 01-000-46-004671 REIMB-LIFE INSURANCE 325 325 4,800 6.78% 01-000-46-00-4672 REIMB-LIBRARY INSURANCE 7,657 7,657 0.00% 01-GOO-46-00-4680 REIMB-LIABILITY INSURANCE 5,000 0.00% 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,505 40,000 48.76% 01-G00-46-00-4690 REIMB-MISCELLANEOUS 311 311 4,000 7.79% 01-G00-48-00-4820 RENTAL INCOME 1,100 1,100 9,000 12.22% 01-000-48-00-4821 BAD DEBT RECOVERY 0.00% 01-000-48-004845 DONANTION5 50 SO 2,000 2.50% 01-000-48-00-4850 MISCELLANEOUS INCOME 105 105 5,000 2.10% 01-000-49-00-4951 TRANSFER FROM WATER 7,655 7,655 91,863 8.33% 01-G00-49-00-4952 TRANSFER FROM SEWER 6,920 6,920 83,045 8.33% 01-000-49-00-4972 TRANSFER FROM LAND CASH 1,674 1,674 20,084 8.33% TOTAL REVENUES:GENERAL FUND 897,396 1 897,396 11,491,374 ADMINISTRATION EXPENDITURES 01-110-50-00-5001 SALARIES-MAYOR 860 860 11,000 7.82% 01-110-50-00-5002 SALARIES-LIQUOR COMM 83 83 1,000 8.33% 01-110-50-00-5003 SALARIES-CITY CLERK 777 777 9,000 8.63% 01-110-50-00-5004 SALARIES-CITY TREASURER 500 500 6,500 7.69% 01-110-50-00-5005 SALARIES-ALDERMAN 4,175 4,175 50,320 8.30% 01-110-50-00-5010 SALARIES-ADMINISTRATION 14,330 14,330 195,000 7.35% 01-110-50-00-5020 OVERTIME 575 0.00% 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUITION 1,735 1,735 25,000 6.94% 01-110-52-00-5214 FICA CONTRIBUTION 1,434 1,434 20,106 7.13% 01-110-54-00-5410 ITUITI ON REIMBURSEMENT 0.00% 01-110-54-00-5412 TRAINING&CONFERENCES 3,000 0.00% 01-110-54-00-5415 TRAVEL&LODGING 0.00% 01-110-54-00-5423 PUBLIC RELATIONS 150 0.00% 01-110-54-00-5426 PUBLISHING&ADVERTISING 2,000 0.00% 01-110-54-00-5430 PRINTING&DUPLICATION 6,750 0.00% 01-110-54-00-5440 TELECOMMUNICATIONS 21,200 0.00% 01-110-54-00-5451 CODIFICATION 8,000 0.00% 01-110-54-00-5452 POSTAGE&SHIPPING 14,000 0.00% 01-110-54-00-5462 PROFESSIONAL SERVICES 11,000 0.00% 01-110-54-00-5473 KENDALL COUNTY PARATRANSIT 30,000 0.00% 01-110-54-00-5474 SENIOR SERVICE FUNDING 0.00% 01-110-54.00-5477 BUILDING INSPECTIONS 0.00% 01-110-54-00-5480 UTILITIES 28,000 0.00% 01-110-54-00-5485 RENTAL&LEASE PURCHASE 143 143 0.00% 01-110-54-00-5487 SPONSORSHIPS 0.00% 01-110-54-00-5488 OFFICE CLEANING 14,400 0.00% 01-110-54-00-5490 DUES&SUBSCRIPTIONS 1,384 1,384 16,600 8.34% ACTUAL EXPENSES BY MONTH(Cash Basis) Year-to- ate ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-11 October-31 November-11 December-11 January-12 February-12 March-12 April-12 Totals BUDGET %of Budget 01-110-56-00-5600 IWEARING APPAREL 0.00% O1-110-56-00-5610 OFFICE SUPPLIES 70 70 15,000 0.47% O1-110-56-00-5630 SMALLTOOLS&EQUIPMENT 0.00% O1-110-56-00-5635 ICOMPUTER EQUIPMENT&SOFTWARE 850 0.00% 01-110-56-00-5640 1 REPAIR&MAINTENANCE 100 0.00% TOTAL EXPENDITURES:ADMINISTRATION 25,492 25,492 489,551 5.21% FINANCE EXPENDITURES O1-120-50-00-5010 SALARIES&WAGES 12,812 12,812 175,000 7.32% O1-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,233 1,233 17,500 7.04% O1-120-52-00-5214 FICA CONTRIBUTION 967 967 13,005 7.44% O1-120-52-00-5216 GROUP HEALTH INSURANCE 150 150 0.00% O1-120-54-00-5412 TRAINING&CONFERENCES 2,000 0.00% 01-120-54-00-5414 AUDITING SERVICES 45,000 0.00% O1-120-54-00-5415 TRAVEL&LODGING 1,000 0.00% O1-120-54-00-5430 PRINTING&DUPLICATING 500 0.00% 01-120-54-00-5440 TELECOMMUNICATIONS 600 0.00% O1-120-54-00-5452 POSTAGE&SHIPPING 500 0.00% O1-120-54-00-5460 DUES&SUBSCRIPTIONS 80 80 850 9.41% O1-120-54.00-5462 PROFESSIONAL SERVICES 1,858 1,858 42,000 4.42% 01-120-54-00-5485 RENTAL&LEASE PURCHASE 143 143 15,000 0.95% O1-120-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 1,800 0.00% 01-120-56-00-5610 OFFICE SUPPLIES 2,500 0.00% O1-120-56-00-5630 SMALLTOOLS&EQUIPMENT 250 0.00% O1-120-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 2,500 0.00% O1-120-56-00-5640 REPAIR&MAINTENANCE 500 0.00% TOTAL EXPENDITURES:FINANCE 17,243 17,243 320,505 5.38% COMMUNITY RELATIONS EXPENDITURES O1-130-50-00-5010 SALARIES&WAGES 3,750 3,750 0.00% 01-130-50-00-5016 PART-TIME SALARIES 32,500 0.00% O1-130-52-00-5212 RETIREMENT PLAN CONTRIBUTION 0.00% 01-130-52-00-5214 FICA CONTRIBUTION 2,500 0.00% O1-130-54-00-5423 PUBLIC RELATIONS 287 287 1,750 16.39% O1-130-54-00-5426 PUBLISHING&ADVERTISING 7,500 0.00% O1-130-54.00-5430 PRINTING&DUPLICATING 200 0.00% 01-130-54-00-5440 TELECOMMUNICATIONS 0.00% O1-130-54-00-5452 POSTAGE&SHIPPING 2,200 0.00% 01-130-54-00-5460 DUES&SUBSCRIPTIONS 100 0.00% O1-130-54-00-5462 PROFESSIONALSERVICES 4,800 0.00% O1-130-56-00-5600 WEARING APPAREL 0.00% O1-130-56-00-5610 OFFICE SUPPLIES 400 0.00% O1-130-56-00-5692 ICOMMUNITY EVENTS 3,000 0.00% TOTAL EXPENDITURES:COMMUNITY RELATIONS 4,037 4,037 54,950 7.35% ENGINEERING EXPENDITURES 01-150-50-00-5010 SALARIES&WAGES 12,929 12,929 172,000 7.52% O1-150-50-00-5020 OVERTIME 500 0.00% 01-150-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,230 1,230 16,500 7.45% O1-150-52-00-5214 FICA CONTRIBUTION 960 960 13,236 7.25% O1-150-54-00-5412 TRAINING&CONFERENCES 2,250 0.00% O1-150-54.00-5415 TRAVEL&LODGING 400 0.00% 01-150-54-00-5430 PRINTING&DUPLICATING 1,500 0.00% O1-150-54-00-5440 TELECOMMUNICATIONS 2,200 0.00% 01-150-54-00-5452 POSTAGE&SHIPPING 500 0.00% O1-150-54-00-5460 DUES&SUBSCRIPTIONS 1,200 0.00% O1-150-54-00-5462 PROFESSIONAL SERVICES 32,550 0.00% O1-150-54-00-5485 RENTAL&LEASE PURCHASE 137 137 0.00% O1-150-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 1,500 0.00% O1-150-56-00-5600 WEARING APPAREL 100 0.00% 01-150-56-00-5610 OFFICE SUPPLIES 1,000 0.00% O1-150-56-00-5622 ENGINEERING SUPPLIES 1,500 0.00% O1-150-56-00-5630 SMALLTOOLS&EQUIPMENT Soo 0.00% O1-150-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 4,550 0.00% 01-150-56-00-5640 REPAIR&MAINTENANCE 1,000 0.00% O1-150-56-00-5645 1 BOOKS&PUBLICATIONS 150 0.00% TOTAL EXPENDITURES:ENGINEERING 15,255 1 15,255 253,136 POLICE EXPENDITURES O1-210-50-00-5010 SALARIES-POLICE OFFICERS 87,672 87,672 1,250,000 7.01% 01-210-50-00-5012 SALARIES-UEUT/SERGEANTS/CHIE 44,835 44,835 610,000 7.35% O1-210-50-00-5013 SALARIES-POLICE CLERKS 11,204 11,204 120,000 9.34% O1-210-50-00-5014 SALARIES-CROSSING GUARD 1,110 1,110 20,OOD 5.55% O1-210-50-00-5015 PART-TIME SALARIES 6,068 6,068 39,000 15.56% O1-210-50-00-5017 CADET PROGRAM 875 875 13,500 6.48% O1-210-50-00-5020 OVERTIME 6,970 6,970 75,000 9.29% O1-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,075 1,075 15,900 6.76% O1-210-52-00-5213 EMPLOYER CONTRI-POLPEN 57,847 57,847 375,000 15.43% O1-210-52-00-5214 FICA CONTRIBUTION 11,692 11,692 170,000 6.88% O1-210-52-00-5216 GROUP HEALTH INSURANCE 250 250 0.00% 01-210-54-00-5410 TUITION REIMBURSEMENT 2,800 0.00% O1-210-54-00-5411 POLICE COMMISSION 563 563 15,000 3.75% O1-210-54-00-5412 TRAINING&CONFERENCES 50 50 12,000 0.42% O1-210-5400-5415 TRAVEL&LODGING 183 183 10,000 1.83% 01-210-54-00-5426 PUBLISHING&ADVERTISING 200 0.00% O1-210-54-00-5430 PRINTING&DUPLICATING 4,500 0.00% O1-210-54-00-5440 TELECOMMUNICATIONS 36,500 0.00% O1-210-54-00-5452 POSTAGE&SHIPPING 11 11 3,000 0.36% O1-210-54-00-5457 PSYCHOLOGICAL TESTING I 0.00% ACTUAL EXPENSES BY MONTH(Cash Basis) Year-to- ate ACCOUNT NUMBER DESCRIPTION db May-11 June-11 July-11 August-11 September-11 October-31 November-11 December-11 January-12 February-12 March-12 April-12 Totals BUDGET %of Budget O1-210-54-00-5460 DUES&SUBSCRIPTIONS 90 90 1,350 6.67% O1-210-54-00-5462 PROFESSIONAL SERVICES 55 55 4,000 1.37% 01-210-54-00-5466 LEGALSERVICES 10,000 0.00% O1-210-54.00-5467 ADMIN ADJ-HEARING OFFICER 325 325 15,000 2.17% 01-210-54-00-5469 NEW WORLD LIVE SCAN 15,000 0.00% O1-210-54-00-5472 KENDALL CO.JUVE PROBATION 3,000 0.00% O1-210-54-00-5484 MID-ALERTS FEE 3,330 3,330 6,660 50.00% O1-210-54-00-5485 RENTAL&LEASE PURCHASE 277 277 0.00% O1-210-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 1,125 1,125 51,000 2.21% O1-210-56-00-5600 WEARING APPAREL 375 375 10,000 3.75% O1-210-56-00-5610 OFFICE SUPPLIES 4,000 0.00% O1-210-56-00-5620 OPERATING SUPPLIES 13 13 8,000 0.16% O1-210-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 7,000 0.00% O1-210-56-00-5640 REPAIR&MAINTENANCE 12,250 0.00% O1-210-56-00-5669 GREAT PROGRAM 3,000 0.00% O1-210-56-00-5670 COMMUNITY RELATIONS 500 0.00% 01-210-56-00-5673 NEIGHBORHOOD WATCH 1,531 0.00% O1-210-56-00-5674 CITIZENS POLICE ACADEMY 1,839 0.00% O1-210-56-00-5678 COMPLIANCE CHECKS 500 0.00% O1-210-56-00-5690 SUPPLIES-GRANT REIMBURSABLE 4,200 0.00% 01-210-56-00-5695 GASOLINE 85,000 0.00% O1-210-56-00-5696 AMMUNITION 2,000 0.00% TOTAL EXPENDITURES:POLICE 1 235,995 1 235,995 3,018,230 7.82% COMMUNITY DEVELOPMENT EXPENDITURES O1-220-50-00-5010 ISALARIES&WAGES 17,750 17,750 240,000 7.40% O1-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,688 1,688 27,275 6.19% O1-220-52-00-5214 FICA CONTRIBUTION 1,279 1,279 17,260 7.41% O1-220-54-00-5412 TRAINING&CONFERENCES 1,200 0.00% O1-220-54-00-5415 TRAVEL&LODGING 700 0.00% O1-220-54-00-5426 PUBLISHING&ADVERTISING 150 0.00% O1-220-54-00-5430 PRINTING&DUPLICATING 1,500 0.00% 01-220-54-00-5440 TELECOMMUNICATIONS 1,500 0.00% O1-220-54-00-5452 POSTAGE&SHIPPING 500 0.00% 01-220-54-00-5459 IINSPECTIONS 1 20,000 0.00% O1-220-54.00-5460 DUES&SUBSCRIPTIONS 1,500 0.00% 01-220-54-00-5462 PROFESSIONAL SERVICES 5,000 0.00% 01-220-54-00-5466 LEGAL SERVICES 6,400 0.00% O1-220-54-00-5485 RENTAL&LEASE PURCHASE 137 137 0.00% O1-220-54-00-5486 ECONOMIC DEVELOPMENT 45,000 0.00% O1-220-56-00-5610 OFFICE SUPPLIES 500 0.00% O1-220-56-00-5620 OPERATING SUPPLIES 3,000 0.00% O1-220-56-00-5630 SMALLTOOLS&EQUIPMENT 125 0.00% 01-220-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 2,500 0.00% O1-220-56-00-5645 BOOKS&PUBLICATIONS 500 0.00% O1-220-56-00-5690 ISUPPLIES-GRANT REIMBURSABLE TOTAL EXPENDITURES:COMMUNITY DEVELOPMENT 20,854 20,854 1 375,610 PUBLIC WORKS-STREET OPERATIONS EXPENDITURES O1-410-50-00-5010 SALARIES&WAGES 18,990 18,990 270,000 7.03% 01-410-50-00-5020 OVERTIME 15,000 0.00% O1-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,806 1,806 30,000 6.02% 01-410-52-00-5214 FICA CONTRIBUTION 1,408 1,408 23,500 5.99% 01-410-54-00-5412 TRAINING&CONFERENCES 2,000 0.00% O1-410-54-00-5440 TELECOMMUNICATIONS 4,020 0.00% O1-410-54-00-5455 MOSQUITO CONTROL 7,000 0.00% O1-410-54-00-5458 TREE&STUMP REMOVAL 10,000 0.00% O1-410-54-00-5462 PROFESSIONAL SERVICES 1,000 0.00% O1-410-54-00-5480 UTILITIES 80,000 0.00% O1-410-54-00-5485 RENTAL&LEASE PURCHASE 33 33 1,000 3.30% O1-410-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 30,000 0.00% O1-410-56-00-5600 WEARING APPAREL 93 93 5,000 1.85% O1-410-56-00-5620 OPERATING SUPPLIES 34 34 9,500 0.36% 01-410-56-00-5626 HANGING BASKETS 2,000 0.00% 01-410-56-00-5630 SMALLTOOLS&EQUIPMENT 64 64 1,750 3.67% O1-410-56-00-5640 REPAIR&MAINTENANCE 36,500 0.00% O1-410-56-00-5656 PROPERTY&BUILDING MAINT 66 66 30,000 0.22% 01-410-56-00-5695 GASOLINE 33,600 0.00% 01-410-60-00-6040 IN-TOWN ROAD PROGRAM 0.00% O1-410-60-00-6041 SIDEWALK CONSTRUCTION 4,000 0.00% TOTAL EXP:PUBLIC WORKS-STREET OPERATIONS 22,494 22,494 S9S.870 3.77% ACTUAL EXPENSES BY MONTH(Cash Basis( ear-t.- ate ANNUAL ACCOUNT NUMBER DESCRIPTION May-11 lone-11 1.1,-11 August-11 September-11 October-31 November-11 December-11 January-12 February-12 March-12 April-12 Totals BUDGET %of Budget PW-HEALTH&SANITATION EXPENDITURES O1-540-54-00-5442 GARBAGE SERVICES 1,195,OOC 0.00% O1-540-54-00-5443 LEAF PICKUP 6,000 0.00% TOTAL EXPENDITURES:PW HEALTH&SANITATION 1,201,000 0.00% ADMINISTRATIVE SERVICES EXPENDITURES 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES 5,000 0.00% O1-640-52-00-5216 GROUP HEALTH INSURANCE 202,272 202,272 1,204,000 16.80% O1-640-52-00-5222 GROUP LIFE INSURANCE 1,275 1,275 26,000 4.90% O1-640-52-00-5223 DENTAL&VISION INSURANCE 15,474 15,474 114,000 13.57% O1-640-52-00-5224 EMPLOYEE AS515TANCE 150 0.00% O1-640-52-00-5230 UNEMPLOYMENT INSURANCE 12,508 12,508 60,000 20.85% O1-640-52-00-5231 LIABILITY INSURANCE 49,629 49,629 339,200 14.63% O1-640-54-00-5456 CORPORTATE COUNSEL 130,000 0.00% O1-640-54-00-5461 LITIGATION COUNSEL 60,000 0.00% O1-640-54-00-5462 PROFESSIONAL SERVICES 450 450 50,000 0.90% O1-640-54-00-5463 SPECIAL COUNSEL 25,000 0.00% O1-640-54-00-5475 CABLE CONSORTIUM FEE 85,000 0.00% O1-640-54-00-5481 MARKETING-HOTELTAX 27,540 0.00% O1-640-54-00-5491 CITY PROPERTY TAX REBATE 1,050 0.00% 01-640-54-00-5492 SALES TAX REBATE 900,000 0.00% O1-640-54-00-5493 BUSINESS DISTRICT REBATE 18,453 18,453 300,000 6.15% 01-640-54-00-5494 ADMISSIONS TAX REBATE 114,000 0.00% 01-640-54-00-5499 BAD DEBT 1,250 0.00% 01-640-56-00-5625 REIMBURSEABLE REPAIRS 5,000 0.00% 01-640-70-00-7799 CONTINGENCIES 10,000 0.00% O1-640-99-00-9923 TRANSFER TO CITY WIDE CAPITAL 10,417 10,417 125,000 8.33% O1-640-99-00-9942 ITRANSFER TO DEBT SERVICE 8,645 8,645 303,740 8.33% O1-640-99-00-9979 ITRANSFER TO PARK&RECREATION 61,059 61,059 732,710 8.33% TOTAL EXPENDITURES:ADMINISTRATIVE SERVICES 380,181 380,1811 4,418,640 8.60% TOTAL FUND REVENUES 897,396 897,396 11,491,374 7.81% TOTAL FUND EXPENDITURES 721,550 721,550 10,727,492 6.73% FU ND SURPLUS(DEFICIT) 175,846 175,84fi 763,882 FOX HILL SSA REVENUES 11-000-40-00-4011 PROPERTY TAXES-FOX HILL SSA 599 599 3,786 15.82% i1-000-45-00-0500 INVESTMENT EARNINGS 0.00% TOTAL REVENUES:FOX HILL SSA 599 599 3,786 15.82% FOX HILL SSA EXPENDITURES 11-111-54-00-5495 JOUTSIDE REPAIR&MAINTENANCE 3,804 0.00% TOTAL FUND REVENUES 599 1 3,786 15.82% TOTAL FUND EXPENDITURES 3,804 O.ao% FUND SURPLUS(DEFICIT( 599 (18( SUNFLOWER SSA REVENUES 12-000-40-00-4012 PROPERTYTA%ES-SUNFLOWERSSA 1,362 1,362 7,530 18.09% 12-D00-45-00-4500 INVESTMENT EARNINGS 0.00% TOTAL REVENUES:SUNFLOWER SSA m 1,362 1 1,3621 7,530 18.09% SUNFLOWER SSA EXPENDITURES 12-112-54-00-5495 JOUTSIDE REPAIR&MAINTENANCE 9,078 0.00% TOTAL FUND REVENUES m 1,362 1,362 7,530 18.09% TOTAL FUND EXPENDITURES _ 9,078 0.00% FUND SURPLUS(DEFICIT( 1,362 1,362 MOTOR FUEL TAX REVENUES 15-000-41-00-4112 MOTOR FUEL TAX 34,752 34,752 355,000 9.79% 15-G00-41-004113 MFT HIGH GROWTH 20,000 0.00% 15-000-41-00-4172 ILLINOIS JOBS NOW PROCEEDS 142,000 0.00% 15-000-45-00-4500 INVESTMENT EARNINGS 29 29 1,000 2.90% 15-000-46-004605 REIMB-OLD JAIL/DWTWN PARKING 493,000 0.00% 15-000-46-00-4690 REIMS-MISCELLANEOUS 0.00% 15-000-48-00-4850 MISCELLANEOUS INCOME 0.00% TOTAL REVENUES:MOTOR FUELTAX 34,781 34,781 1,011,000 3.44% MOTOR FUEL TAX EXPENDITURES 15-155-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 0.00% 15-155-56-00-5618 SALT 220,000 0.00% 15-155-56-00-5619 SIGNS 18,000 0.00% 15-155-56-00-5632 PATCHING 50,000 0.00% 15-155-56-00-5633 COLD PATCH 10,600 0.00% 15-155-56-00-5634 HOT PATCH 13,000 0.00% 15-155-56-00-5640 REPAIR&MAINTENANCE 0.00%m. 15-155-60-00-6072 DOWNTOWN PARKING LOT 55,000 0.00% 15-155-60-00-6073 GAME FARM ROAD PROJECT 28,200 28,200 150,000 18.80% 15-155-60-00-6074 FOX ROAD PROJECT 0.00% ACTUAL EXPENSES BY MONTH(Cash Basis) Year-to- ate ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-11 October-31 November-11 December-11 January-12 February-12 March-12 April-12 Totals BUDGET %of Budget 15-155-60-00-6075 RIVER ROAD BRIDGE PROJECF 25,000 0.00% 15-155-60-00-6079 ROUTE 47 EXPANSION 119,400 0.00% 15-155-70-00-7799 ICONTINGENCIES TOTALFUNDREVENUES 34,781 34,781 1,011,000 3.44% TOTAL FUND EXPENDITURES 28,200 28,200 661,000 4.27% FUND SURPLUS(DEFICIT) 6,581 6,581 350,000 MUNICIPAL BUILDING REVENUES 16-000-42-00-4214 DEVELOPMENT FEES 1,050 1,050 5,250 20.00% 16-000-45-00-4500 INVESTMENT EARNINGS 0.00% TOTAL REVENUES:MUNICIPAL BUILDING 1,050 1,050 5,250 20.00% TOTAL FUND REVENUES 1,050 1,050 5,250 20.00% _ TOTAL FUND EXPENDITURES FUND SURPLUS(DEFICIT) 1,050 1,050 5,250 POLICE CAPITAL REVENUES 20-000-42-004214 DEVELOPMENT FEES 1,800 1,800 10,500 17.14% 20-000-42-00-4217 WEATHER WARNING SIREN FEES 6,000 0.00% 20-000-43-00-4315 DUI FINES 1,127 1,127 0.00% 20-000-43-00-0340 IMPOUND FEES 5,000 0.00% 20-000-45-00-4500 INVESTMENT EARNINGS 0.00% 20-000-48-00-4845 DONANTIONS 0.00% 20-000-48-004850 MISCELLANEOUS INCOME 0.00% 20-000-48-00-4880 SALE OF FIXED ASSETS 1,200 1,200 0.00% TOTAL REVENUES:POLICE CAPITAL 4,127 4,127 21,500 19.20% POLICE CAPITAL EXPENDITURES 20-200-54-00-5462 PROFESSIONALSERVICES 95 95 1,500 20-200-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 10,000 20-200-56-00-5620 OPERATING SUPPLIES 2,500 20-200-56-00-5621 SMALL TOOLS&EQUIPMENT 20-200-60-00-6060 EQUIPMENT 20,000 20-200-60-00-6070 VEHICLES 20,000 TOTAL FUND REVENUES 4,127 4,127 21,500 19.20% TOTAL FUND 18 EXPENDITURES 95 95 54,000 0. % FUND SURPLUS(DEFICIT) 4,032 4,032 (32,500) PUBLIC WORKS CAPITAL REVENUES 21-000-42-004214 DEVELOPMENT FEES 4,400 4,400 24,500 17.96% 21-000-44-00-4418 MOWING INCOME 419 4191 7,900 5.31% 21-000-45-00-4500 INVESTMENT EARNINGS 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 ITSFR FROM PARK&REC CAPITAL 292 292 3,500 8.33% TOTAL REVENUES:PUBLIC WORKS CAPITAL REVENUES 5,111 5,1111 35,900 14.24% PUBLIC WORKS CAPITAL EXPENDITURES 21-211-54-00-5462 PROFESSIONAL SERVICES 1,800 0.00% 21-211-54-00-5485 RENTAL&LEASE PURCHASE 4,500 0.00% 21-211-56-00-5620 OPERATING SUPPLIES 2,000 0.00% 21-211-60-00-6020 BUILDINGS&STRUCTURES 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 4,587 28,254 16.24% 21-211-92-00-8050 INTEREST PAYMENT-PW BUILDING 9,129 %129 54,041 16.89% TOTAL FUND REVENUES 5,111 5,111 35,900 14.24% TOTAL FUND EXPENDITURES 13,716 13,716 92,595 14.81% FUND SURPLUS(DEFICIT (8,605) (8,605) (56,695) PARK&RECREATION CAPITAL REVENUES 22-000-42-004215 PARKS CAPITAL FEES 250 250 1,750 14.29% 22-000-45-00-4500 INVESTMENTEARNINGS 7 7 80 8.40% 22-000-46-00-4690 IN 0.00% 22-000-48-00-0845 IDONATIONS 0.00% 22-000-48-00-4880 ISALE OF FIXED ASSETS - 1,000 0.00% TOTAL REVENUES:PARK&RECREATION CAPITAL 257 257 2,830 9.07% PARK&RECREATION CAPITAL EXPENDITURES 22-222-60-00-6012 ICRAWFORD 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 1 EQUIPMENT 0.00% 22-222-99-00-9921 TRANSFER TO PW CAPITAL 292 292 3,500 8.33% TOTAL FUND REVENUES 257 2,830 9.07% TOTAL FUND EXPENDITURES 292 123,500 0.24% FUNDSURPIL (DEFICIT) (35) (120,670) ACTUAL EXPENSES BY MONTH(Cash Basis) ll ar-to- ate ANN ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-11 October-31 November-11 December-11 January-12 February-12 March-12 April-12 a Totals BUDGET 5'.of Budget CITY-WIDE CAPITAL REVENUES 23-000-41-00-4170 STATE GRANTS 231,000 0.00% 23-000-42-004210 BUILDING PERMITS 17,600 0.00% 23-000-42-00-4213 ENGINEERING CAPITAL FEES 500 500 3,000 16.67% 23-000-42-00-4214 DEVELOPMENT FEES 20,000 0.00% 23-000-42-004222 ROAD CONTRIBUTION FEE 4,000 4,000 20,000 20.00% 23-000-45-00-4500 INVESTMENT EARNINGS 2 2 0.00% 23-000-46-00-4690 REIMB-MISCELLANEOUS 4,469 4,469 0.00% 23-000-48-00-4880 SALE OF FIXED ASSETS 0.00% 23-000-49-00-4901 TRANSFER FROM GENERAL 10,417 10,417 125,000 8.33% TOTAL REVENUES:CITY-WIDE CAPITAL 19,388 19,388 416,600 4.65% CITY-WIDE CAPITAL EXPENDITURES 23-230-54-00-5495 JOUTSIDE REPAIR&MAINTENANCE 0.00% 23-230-60-00-6041 SIDEWALK CONSTRUCTION 0.00% 23-230-60-00-6070 VEHICLES 4,000 0.00% 23-230-60-00-6078 PALMER COURT 0.00% 23-230-60-00-6092 ISAFE ROUTE TO SCHOOL PROJECT 231,000 0.00% 23-230-97-00-8000 PRINCIPLE PAYMENT-CLARK PROPERTY 125,000 125,000 125,000 100.00% TOTAL FUND REVENUES 19,388 19,388 416,600 4.65% TOTAL FUND E%PENDITURES 125,000 125,000 360,000 34.72% FUND SURPLUS(DEFICIT) m (105,612) (105,612)1 56,600 DEBT SERVICE REVENUES 42-000-40-004006 PROPERTY TAXES-2005A BOND 51,906 51,906 324,179 16.01% 42-000-42-00-4208 RECAPTURE FEES-WATER&SEWER 200 200 0.00% 42-000-45-00-4500 INVESTMENT EARNINGS 0.00% 42-000-49-00-4901 ITRANSFER FROM GENERAL 8,645 8,645 103,740 8.33% TOTAL REVENUES:DEBT SERVICE 60,751 60,7511 427,919 14.20% DEBT SERVICE EXPENDITURES 42-420-54-00-5498 PAYING AGENT FEES 750 0.00% 42-420-81-00-8000 PRINCIPLE PAYMENT-20040 95,000 0.00% 42-420-81-00-8050 INTEREST PAYMENT-2004C 8,740 0.00% 42-420-82-00-8000 PRINCIPLE PAYMENT-2GOSA 195,000 0.00% 42-420-82-00-8050 INTEREST PAYMENT-2005A 129,179 0.00% TOTAL FUND REVENUES 60,751 60,751 427,919 14.20% TOTAL FUND EXPENDITURES 428,669 0.00% FUND SURPLUS(DEFICIT) 60,751 60,751 (750) WATER FUND REVENUES 51-000-40-00-4007 PROPERTY TAXES-2007A BOND 21,434 21,434 133,866 16.01% 51-000-44-00-4424 WATER SALES 3,611 3,611 1,674,750 0.22% 51-000-44-00-4425 BULK WATER SALES 500 0.00% 51-000-44-00-4430 WATER METER SALES 3,405 3,405 25,000 13.62% 51-000-44-00-4440 WATER INFASTRUCTURE FEE 305 305 600,000 0.05% 51-000-44-00-4450 WATER CONNECTION FEE 16,710 16,710 125,000 13.37% 51-000-44-00-4473 RECAPTURE FEES 0.00% 51-000-45-00-4500 INTEREST INCOME 2,000 0.00% 51-000-46-00-4690 REIMB-MISCELLANEOUS 0.00% 51-000-48-00-4821 BAD DEBT RECOVERY 0.00% 51-G00-48-00-4822 RENTAL INCOME-WATER TOWER 311 311 50,000 0.62% 51-G00-48-004850 MISCELLANEOUS INCOME 0.00% 51-000-48-00-4855 BAD DEBT RECOVERY 0.00% 51-000-49-004952 TRANSFER FROM SEWER 6,989 61989 83,863 8.33% 51-000-49-00-4998 CAPITAL CONTRIBUTIONS - - 0.00% 51-GOO-49-00-4999 DEVELOPER DONATIONS 0.00% TOTAL REVENUES:WATER FUND 52,764 52,764 2,694,979 WATER OPERATIONS EXPENSES 51-510-50-00-5010 SALARIES&WAGES 26,985 26,985 365,000 7.39% 51-510-50-00-5020 OVERTIME 12,000 0.00% 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,566 2,566 37,500 6.84% 51-510-52-00-5214 FICA CONTRIBUTION 1,984 1,984 28,200 7.03% 51-510-54-00-5412 TRAINING&CONFERENCES 2,000 0.00% 51-510-54-00-5415 TRAVEL&LODGING 1,600 0.00% 51-510-54-00-5426 PUBLISHING&ADVERTISING 1,000 0.00% 51-510-54-00-5429 WATER SAMPLES 4,236 4,236 14,000 30.26% 51-510-54-00-5430 PRINTING&DUPLICATING 2,500 0.00% 51-510-54-00-5440 ITELECOMMUNICATIONS I 1 24,500 0.00% 51-510-54-00-5452 POSTAGE&SHIPPING 22,000 0.00% 51-510-54-00-5460 DUES&SUBSCRIPTIONS 1,250 0.00% 51-510-54-00-5462 PROFESSIONAL SERVICES 140 140 6,000 2.33% 51-510-54-00-5466 LEGAL SERVICES 2,000 0.00% 51-510-54-00-5480 UTILITIES 304,500 0.00% 51-510-54-00-5483 JULIE SERVICES 3,500 0.00% 51-510-54-00-5485 RENTAL&LEASE PURCHASE 33 33 1,000 3.30% 51-510-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 10,000 0.00% 51-510-54-00-5499 BAD DEBT 6,000 0.00% 51-510-56-00-5600 IALLTOOLS ARINGAPPAREL 93 93 5,000 1.85% 51-510-56-00-5620 ERATING SUPPLIES 20,500 51-510-56-00-5625 MBURSABLE REPAIRS 51-510-56-00-5630 &EQUIPMENT 64 64 1 2,000 3.21% ACTUAL EXPENSES BY MONTH(Cash Basis( Year-to- ate ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-11 October-31 November-11 December-11 January-12 February-12 March-12 April-12 Totals BUDGET %of Budget 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 1,600 0.00% 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 20 20 240,000 0.01% 51-510-56-00-5640 REPAIR&MAINTENANCE 59 59 9,500 0.62% 51-510-56-00-5664 METERS&PARTS 1,452 1,452 46,000 3.16% 51-510-56-00-5695 GASOLINE 35,700 0.00% 51-510-60-00-6079 ROUTE 47 EXPANSION 96,000 0.00% 51-510-70-00-7799 CONTINGENCIES 0.00% 51-510-75-00-7502 GRANDE RESERVE COURT ORDER 22,989 22,989 275,868 8.33% 51-510-83-00-8000 PRINCIPLE PAYMENT-2007A 10,000 0.00% 51-510-83-00-8050 INTEREST PAYMENT-2007A 123,866 0.00% 51-510-85-00-8000 PRINCIPLE PAYMENT-2002 CAP APPREC 285,000 285,000 285,000 100.00% 51-510-86-00-8000 PRINCIPLE INTEREST-2003 DEBT CERT 0.00% 51-510-86-00-8050 INTEREST PAYMENT-2003 DEBT CERT 33,150 0.00% 51-510-87-00-8000 PRINCIPLE PAYMENT-2006A 70,000 0.00% 51-510-87-00-8050 INTEREST PAYMENT-2006A 88,506 0.00% 51-510-88-00-8000 PRINCIPLE PAYMENT-2005C 90,000 0.00% 51-510-88-00-8050 INTEREST PAYMENT-2005C 77,725 0.00% 51-510-89-00-8000 PRINCIPLE PAYMENT-IEPA 156300 85,600 0.00% 51-510-89-00-8050 1 INTEREST PAYMENT-IEPA 156300 39,430 51-510-99-00-9901 ITRANSFER TO GENERAL m 7,655 1 7,655 1 91,863 TOTAL FUND REVENUES 52,764 52,764 2,694,979 1.96% _ TOTAL FUND EXPENSES 353,274 353,274 2,571,858 13.74% FUND SURPLUS(DEFICIT) (300,510) (300,510( 123,121 SEWER FUND REVENUES 52-000-40-00-4009 1 PROPERTY TAXES-20046 BOND 41,414 41,414 258,650 16.01% 52-000-40-00-4013 PROPERTY TAXES-2005D BOND 221,914 221,914 1,385,950 16.01% 52-000-40-00-4014 PROPERTY TAXES-2008 BOND 17,627 17,627 110,090 16.01% 52-000-44-00-4435 SEWER MAINTENANCE FEES 184 184 714,000 0.03% 52-000-44-00-4455 SW CONNECTION FEES-OPERATIONS 800 800 5,000 16.00% 52-000-44-00-4456 SW CONNECTION FEES-CAPITAL 7,200 7,200 30,000 24.00% 52-000-44-00-4457 SW CONNECTION FEES-ROB ROY 294,000 294,000 600,000 49.00% 52-000-44-00-4460 SEWER INFRASTRUCTURE FEES 0.00% 52-000-44-00-4465 RIVER CROSSING FEES 0.00% 52-000-45-004500 INTEREST INCOME 97 97 1,800 5.41% 52-000-46-00-4690 REIMB-MISCELLANEOUS 155 155 0.00% 52-000-48-00-4821 BAD DEBT RECOVERY 0.00% 52-000-48-00AS50 MISCELLANEOUS INCOME 0.00% TOTAL REVENUES:SEWER FUND 583,392 583,392 3,105,490 18.79% SEWER OPERATIONS EXPENSES 52-520-50-00-5010 SALARIES&WAGES 18,877 18,877 256,000 7.37% 52-520-50-00-5020 OVERTIME 76 76 2,000 3.78% 52-520-52-00-5212 RETIREMENT PLAN CONRTRIBUTION 1,802 1,802 25,000 7.21% 52-520-52-00-5214 FICA CONTRIBUTION 1,391 1,391 20,230 6.88% 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 1,800 0.00% 52-520-54-00-5462 PROFESSIONAL SERVICES 58 58 5,000 1.17% 52-520-54-00-5480 UTILITIES 40,000 0.00% 52-520-54-00-5485 RENTAL&LEASE PURCHASE 33 33 1,000 3.30% 52-520-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 4,000 0.00% 52-520-56-00-5600 WEARING APPAREL 93 93 2,500 3.70% 52-520-56-00-5610 OFFICE SUPPLIES 2,000 0.00% 52-520-56-00-5613 LIFT STATION MAINTENANCE 15,000 0.00% 52-520-56-00-5620 OPERATING SUPPLIES 4,500 0.00% 52-520-56-00-5625 REIMBURSABLE REPAIRS 0.00% 52-520-56-00-5630 SMALLTOOLS&EQUIPMENT 64 64 2,500 2.57% 52-520-56-00-5635 MM PMENT&SOFTWARE 1,200 0.00% NCE 52-520-56-00-5640 REPAIR&MAINTENA 25,000 0.00% 52-520-56-00-5695 GASOLINE 27,300 0.00% 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-65-00-6500 DEPRECIATION EXPENSE 0.00% 52-520-66-00-6600 AMMORTIZATION EXPENSE 0.00% 52-520-70-00-7799 CONTINGENCIES 0.00% 52-520-75-00-7500 LENINAR-RAINTREESWR RE CAPTURE 30,996 30,996 30,996 100.00% 52-520-84-00-8000 PRINCIPLE PAYMENT-20048 160,000 0.00% 52-520-84-00-8050 INTEREST PAYMENT-20048 98,650 0.00% 52-520-90.00-8000 PRINCIPLE PAYMENT-20031RRB 95,000 0.00% 52-520-90-00-8050 INTEREST PAYMENT-2003IRRB 70,143 0.00% 52-520-91-00-8000 PRINCIPLE PAYMENT-2004A 170,000 0.00% 52-520-91-00-8050 INTEREST PAYM ENT-2004A 24,093 0.00% 52-520-93-00-8000 PRINCIPLE PAYMENT-2005D 1,000,000 0.00% 52-520-93-00-8050 INTEREST PAYMENT-20050 385,950 0.00% 52-520-94-00-8000 PRINCIPLE PAYMENT-2008 REF 0.00% 52-520-94-00-8050 INTEREST PAYM ENT-2008 REF 110,090 0.00% 52-520-95-00-8000 PRINCIPLE PAYMENT-IEPA 01300 36,635 0.00% 52-520-95-00-8050 INTEREST PAYMENT-IEPA 01300 2,344 0.00% 52-520-96-00-8000 PRINCIPLE PAYMENT-IEPA 115300 86,329 0.00% 52-520-96-00-8050 INTEREST PAYMENT-IEPA 115300 20,721 0.00% 52-520-99-00-9901 TRANSFER TO GENERAL 6,920 6,920 83,045 8.33% 52-520-99-00-9952 TRANSFER TO WATER 6,989 6,9891 83,863 TOTAL FUND REVENUES 583,392 583,392 3,105,490 18.79% TOTALFUNDEXPENSES 67,299 67,299 2,919,989 2.30% FUND SURPLUS(DEFICIT( 516,093 516,093 185,501 ACTUAL EXPENSES BY MONTH(Cash Basis( ar-to- ate ANN ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-11 October-31 November-11 December-11 January-12 February-12 March-12 Apri142 a Totals BUDGET %of Budget LAND CASH REVENUES 72-000-41-00-4170 STATE GRANTS 400,000 0.00% 72-000-45-004500 INVESTMENT EARNINGS 0.00% 72-000-47-00-4700 WHITE OAK UNIT 1&2 0.00% 72-000-47-00-4701 WHITE OAK UNIT 3&4 0.00% 72-000-47-00-0702 WHISPERING MEADOWS(K HILL( 312,655 312,655 0.00% 72-000-47-00-4703 AUTUMN CREEK 3,077 3,077 20,000 1538% 72-000-47-00-4704 BLACKBERRY WOODS 500 0.00% 72-000-47-004705 BRISTOL BAY 0.00% 72-000-47-00-4706 CALEDONIA 0.00% 72-000-47-00-4707 RIVER'S EDGE 0.00% 72-IXE47-00-4708 COUNTRY HILLS 0.00% 72-000-47-00-4709 BRIARWOOD 0.00% 72-000-47-00-4710 FOXFIELD II PARK 0.00% 72-000-47-00-4711 FOX HIGHLANDS 0.00% 72-000-47-004712 GREENBRIAR 0.00% 72-000-47-00-4713 PRESTWICK 0.00% 72-000-47-00-4714 HEARTLAND CIRCLE 0.00% 72-000-47-00-4715 KYLN'S RIDGE 0.00% 72-000-47-00-4716 MONTALBANO HOMES 0.00% 72-000-47-00-4717 PRAIRIE GARDEN 0.00% 72-000-47-00-0718 SUNFLOWER 0.00% 72-000-47-00-4719 VILLAS AT THE PRESERVE 0.00% 72-000-47-00-4720 WOODWORTH 0.00% TOTAL REVENUES:LAND CASH 315,732 315,7321 420,500 75.08% LAND CASH EXPENDITURES 72-720-60-00-6029 ICALEDONIA 0.00% 72-720-60-00-6031 HEARTLAND CIRCLE 0.00% 72-720-60-00-6032 MOSIER HOLDING COSTS 11,000 0.00% 72-720-60-00-6036 RAINTREE VILLAGE 85,280 85,280 270,000 31.59% 72-720-60-00-6037 GRANDE RESERVE BIKE TRAIL 0.00% 72-720-60-00-6038 WHEATON WOODS NATURE TRAIL 0.00% 72-720-60-00-6039 BRISTOL BAY-PARKA 0.00% 72-720-60-00-6043 BRISTOL BAY REGIONAL PARK 0.00% 72-720-60-00-6044 HOPKINS PARK 72-720-60-00-6045 "VERMONT PARK 72-720-99-00-9901 TRANSFERTOGENERAL 1,674 1,674 20,084 1 8.339/. TOTAL FUND REVENUES 315,732 315,732 420,500 75.08% TOTAL FUND EXPENDITURES 2 86,9531 301,084 28.88% FUND SURPLUS(DEFICIT( 228,779 228,779 119,416 PARK&RECREATION REVENUES 79-000-41-00-4182 IMISC INTERGOVERNMENTAL 0.00% 79-000-44-00-4402 SPECIAL EVENTS 0.00% 79-000-44-00-4403 CHILD DEVELOPMENT 5,557 5,557 0.00% 79-000-44-00-4404 ATHLETICS AND FITNESS 18,466 18,466 0.00% 79-000-4400-4440 PROGRAM FEES 26,232 26,232 180,000 14.57% 79-000-44-00-4441 CONCESSION REVENUE 14,297 14,297 30,000 47.656 79-000-44-00-4443 HOMETOWN DAYS 4,250 4,250 135,000 3.15% 79-000-45-00-4500 INVESTMENT EARNINGS 14 14 300 4.56% 79-000-46-00-4680 REIMB-LIABILITY INSURANCE 0.00% 79-000-46-00-4690 REIMB-MISCELLANEOUS 2,916 2,916 0.00% 79-000-48-00-4820 IREN TALINCOME 74,644 74,644 86,000 86.80% 79-000-48-00-4825 FACILITY AND PARK RENTALS 14,374 14,374 0.00% 79-000-48-00-4846 SPONSORSHIPS/DONANTIONS 490 490 11,200 4.38% 79-000-48-004850 1 MISCELLANEOUS INCOME 18 18 500 3.60% 79-000-49-00-4901 ITRANSFER FROM GENERAL 61,059 61,059 732,710 8.33% TOTAL REVENUES:PARK&RECREATION 222,317 222,317 1,175,710 18.9156 PARKS DEPARTMENT EXPENDITURES 79-790-50-00-5010 ISALARIES&WAGES 28,371 28,371 370,000 7.67% 79-790-50-00-5015 PART-TIME SALARIES 763 763 17,000 4.49% 79-790-50-00-5020 OVERTIME 3,000 0.00% 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,698 2,698 37,730 7.15% 79-790-52-00-5214 FICA CONTRIBUTION 2,164 2,164 30,000 7.21% 79-790-52-00-5216 GROUP HEALTH INSURANCE 0.00% 79-790-52-00-5625 REIMBURSABLE REPAIRS 0.00% 79-790-54-00-5412 TRAINING&CONFERENCES 2,600 0.00% 79-790-54-00-5415 TRAVEL&LODGING 750 0.00% 79-790-54-00-5440 TELECOMMUNICATIONS 3,780 0.00% 79-790-54-00-5462 PROFESSIONAL SERVICES 4,500 0.00% 79-790-54-00-5466 LEGALSERVICES 4,000 0.00% 79-790-54-00-5485 RENTAL&LEASE PURCHASE 178 178 2,500 7.12% 79-790-56-00-5600 WEARING APPAREL 4,100 0.00% 79-790-56-00-5610 OFFICE SUPPLIES 300 0.00% 79-790-56-00-5620 OPERATING SUPPLIES 22,500 0.00% 79-790-56-00-5630 SMALLTOOLS&EQUIPMENT 2,250 0.00% 79-790-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 500 0.00% 79-790-56-00-5640 REPAIR&MAINTENANCE 48,000 TOTAL EXPENSES:PARKS DEPARTMENT 34,174 34,174 553,510 RECREATION DEPARTMENT EXPENDITURES 79-795-50-00-5010 SALARIES&WAGES 14,458 14,458 190,000 79-795-50-00-$OS$ PART-TIMESALARIES 1,406 1,4061 22,000 6.39% ACTUAL EXPENSES BY MONTH(Cash Basis) Year-to- ate ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-11 October-31 November-11 December-11 January-12 February-12 March-12 April-12 Totals BUDGET %of Budget 79-795-50-00-5020 OVERTIME 300 0.00% 79-795-50-00-5045 CONCESSION WAGES 2,868 2,868 10,000 28.68% 79-795-50-00-5046 PRE-SCHOOL WAGES 3,410 3,410 20,000 17.05% 79-795-50-00-5052 INSTRUCTORS WAGES 1,195 1,195 16,000 7.47% 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,768 1,768 22,000 8.049i 79-795-52-00-5214 FICA CONTRIBUTION 1,763 1,763 20,000 8.82% 79-795-52-00-5216 GROUP HEALTH INSURANCE 0.00% 79-795-54-00-5412 TRAINING&CONFERENCES 2,000 0.00% 79-795-54-00-5415 TRAVEL&LODGING 1,000 0.00% 79-795-54-00-5426 PUBLISHING&ADVERTISING 27,000 0.00% 79-795-54-00-5440 TELECOMMUNICATIONS 4,300 0.00% 79-795-54-00-5447 SCHOLARSHIPS 1,000 0.00% 79-795-54-00-5452 POSTAGE&SHIPPING 8,000 0.00% 79-795-54-00-5462 PROFESSIONAL SERVICES 2,278 2,278 53,000 4.30% 79-795-54-00-5480 UTILITIES 22,000 0.00% 79-795-54-00-5485 RENTAL&LEASE PURCHASE 4,500 0.00% 79-795-54-00-5490 DUES&SUBSCRIPTION S 1,500 0.00% 79-795-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 1,00C 0.00%1 79-795-54-00-5496 PROGRAM REFUNDS 480 480 7,000 6.86% 79-795-56-00-5600 WEARING APPAREL 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 1,629 1,629 100,000 1.63% 79-795-56-00-5606 PROGRAM SUPPLIES 2,500 2,500 55,000 4.555. 79-795-56-00-5607 CONCESSION SUPPLIES 1,561 1,561 18,000 8.67% 79-795-56-00-5610 OFFICE SUPPLIES 120 120 3,000 4.00% 79-795-56-00-5620 OPERATING SUPPLIES 966 966 5,500 17.56% 79-795-56-00-5630 SMALLTOOLS&EQUIPMENT 2,000 0.00% 79-795-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 500 0.00% 79-795-56-00-5640 IREPAIR&MAINTENANCE 2,000 1 0.00% 79-795-56-00-5645 1 BOOKS&PUBLICATIONS 100 0.00% 79-795-56-00-5690 NANSFERTO PPLIES-GRANTRE11 BURSABLE 500 0.00% 79-795-56-00-5695 SOLINE 3,000 0.00% 79-795-70-00-7799 NTINGENCIES 0.00% 79-795-99-00-9901 GENERAL 0.00% TOTAL EXPENDITURES:RECREATION DEPARTMENT 36,402 36,402 622,200 5.85% TOTAL FUND REVENUES 222,317 222,317 1,175,710 18.91% TOTAL FUND EXPENDITURES 70,576 70,576 1,175,710 6.00% FUND SURPLUS(DEFICIT) m 151,740 151,740 RECREATION CENTER REVENUES 80-000-44-00-4440 I PROGRAM FEES 7,814 7,814 125,000 6.25% 80-000-44-00-4441 CONCESSION REVENUE 975 975 12,500 7.80% 80-000-44-00-4444 MEMBERSHIP FEES 42,167 42,167 410,000 1028% 80-000-44-00-4445 GUEST FEES 580 580 3,500 16.57% 80-000-44-00-4446 SWIM CLASS FEES 5,577 5,577 35,000 15.93% 80-000-44-00-4447 PERSONAL TRAINING FEES 336 336 15,000 2.24% 80-000-44-00-4448 TANNING SESSION FEES 575 575 2,500 23.00% 80-000-45-00-4500 INTEREST INCOME 0.00% 80-000-48-00-4820 RENTAL INCOME 6 6 5,000 1 0.12% 80-000-48-00-4845 DONANTIONS 230 230 2,000 11.50% 80-000-48-00-4850 MISCELLANEOUS INCOME 37 37 500 7.30% TOTAL REVENUES:RECREATION CENTER REVENUES 58,296 58,296 611,000 RECREATION CENTER EXPENSES 80-800-50-00-5070 ISALARIES&WAGES 2,631 2,631 34,200 7.69% 80-800-50-00-5015 PART-TIME SALARIES 7,934 7,934 98,000 8.10% 80-800-50-00-5020 OVERTIME 500 0.00% 80-800-50-00-5046 PRE-SCHOOL WAGES 4,092 4,092 35,000 11.69% 80-800-50-00-5052 INSTRUCTORS WAGES 3,555 3,555 65,000 5.47% 80-800-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,043 1,043 10,000 10.43% 80-800-52-00-5214 FICA CONTRIBUTION 1,382 1,382 17,708 0.00% 80-800-54-00-5412 TRAINING&CONFERENCES 0.00% 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 3,600 0.00% 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 853 17,700 4.82% 80-800-54-00-5480 UTILITIES 49,000 0.00% 80-800-54-00-5485 RENTAL&LEASE PURCHASE 36,198 36,198 226,500 15.98% 80-800-54-00-5490 DUES&SUBSCRIPTIONS 200 0.00% 80-800-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 21,200 0.00% 80-800-54-00-5496 PROGRAM REFUNDS 318 318 1 5,500 5.77% 80-800-54-00-5497 PROPERTY TAX PAYMENT 30,751 30,751 53,680 57.29% 80-800-56-00-5600 WEARING APPAREL 0.00% 80-800-56-00-5606 PROGRAM SUPPLIES 36 36 17,000 0.21% 80-800-56-00-5607 CONCESSION SUPPLIES 6,300 0.00% 80-800-56-00-5610 OFFICE SUPPLIES 2,600 0.00% 80-800-56-00-5620 OPERATING SUPPLIES 287 287 6,200 4.62% 80-800-56-00-5630 SMALLTOOLS&EQUIPMENT 6,300 0.00% 80-800-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 1,000 0.00% 80-800-56-00-5640 REPAIR&MAINTENANCE 11,000 0.00% 80-800-56-00-5645 1 BOOKS&PUBLICATIONS 50 0.00% 80-800-56-00-5695 GASOLINE 300 0.00% TOTAL FUND REVENUES 58,29fi 58,296 611,000 9.54% TOTALFUNDEXPENSES 89,078 69,078 691,738 12.88% FUND SURPLUS(DEFICIT) (30,782) (30,782) (80,738) ACTUAL EXPENSES BY MONTH(Cash Basis) r-to- ate ANN ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-11 October-31 November-11 December-11 January-12 February-12 March-12 April-12 ...Totals BUDGET %of Budget LIBRARY REVENUES 82-000-40-00-4005 PROPERTY TAXES-LIBRARY 108,835 108,835 675,000 16.12% 82-000-40-004015 PROPERTY TAXES-DEBT SERVICE 115,416 115,416 720,800 16.056 82-000-41-00-4120 PERSONAL PROPERTY TAX 5,000 0.00% 82-000-41-00-4170 STATE GRANTS 13,500 0.00% 82-000-42-004211 DEVELOPMENT FEES-BOOKS 875 875 0.00% 82-000-42-00-4212 DEVELOPMENT FEES-BUILDING 875 875 0.00% 82-000-42-00-4214 DEVELOPMENT FEES 0.00% 82-G00-43-004330 LIBRARY FINES 1,397 1,397 20,000 6.98% 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 1,306 1 1,306 17,000 7.68% 82-000-44-00-4422 COPY FEES 320 1 320 3,500 9.14% 82-000-44,00-4440 PROGRAM FEES 20 20 0.00% 82-GOO-45-00-4500 INVESTMENT EARNINGS 14 14 2,000 0.70% 82-000-46-00-4682 REIMBURSEMENT-INSURANCE 0.00% 82-000-46-00-4690 REIMBURSEMENT-MISCELLANEOUS 0.00% 82-G00-48-004820 RENTAL INCOME 111 111 2,500 4.44% 82-GOO-48-00-4824 DVD RENTAL INCOME 441 441 0.00% 82-000-48-00-4832 MEMORIALS 1,000 1,000 3,500 28.57% 82-000-48-00-4850 MISCELLANEOUS INCOME 7 7 0.00% 82-000-48-00-4881 SALE OF BOOKS 500 0.00% TOTAL REVENUES:LIBRARY 230,616 230,616 1,463,300 15.76% LIBRARY EXPENDITURES 82-820-50-00-5010 1 SALARIES&WAGES 34,824 34,824 475,000 7.33% 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,775 1,775 22,500 7.89% 82-820-52-00-5214 FICA CONTRIBUTION 2,608 2,608 40,000 6.52% 82-820-52-00-5216 GROUP HEALTH INSURANCE 70,000 0.00% 82-820-52-00-5222 GROUP LIFE INSURANCE 2,000 0.00% 82-820-52-00-5223 DENTAL&VISION INSURANCE 6,000 0.00% 82-820-54-00-5412 TRAINING&CONFERENCES 800 0.00% 82-820-54-00-5415 TRAVEL&LODGING 500 0.00% 82-820-54-00-5423 PUBLIC RELATIONS 1,000 0.00% 82-820-54-00-5426 PUBLISHING&ADVERTISING 500 0.00% 82-820-54-00-5440 TELECOMMUNICATIONS 5,000 0.00% 82-820-54-00-5452 POSTAGE&SHI PPING 2,000 0.00% 82-820-54-00-5460 DUES&SUBSCRIPTIONS 20,000 0.00% 82-820-54-00-5462 PROFESSIONAL SERVICES 44,000 0.00% 82-820-54-00-5466 LEGAL SERVICES 5,000 0.00% 82-820-54-00-5480 UTILITIES 15,000 0.00% 82-820-54-00-5485 RENTAL&LEASE PURCHASE 3,000 0.00% 82-820-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 20,000 0.00% 82-820-56-00-5600 WEARING APPAREL 0.00% 82-820-56-00-5610 OFFICE SUPPLIES 10,000 0.00% 82-820-56-00-5620 OPERATING SUPPLIES 16,000 0.00% 82-820-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 2,000 0.00% 82-820-56-00-5640 REPAIR&MAINTENANCE 3,000 0.00% 82-820-56-00-5670 COMMUNITY RELATIONS 10,000 0.00% 82-820-56-00-5676 EMPLOYEE RECOGNITION 0.00% 82-820-56-00-5680 ADULT BOOKS 15,000 0.00% 82-820-56-00-5681 JUVENILE BOOKS 30,000 0.00% 82-820-56-00-5682 REFERENCE BOOKS 1 20,000 0.00% 82-820-56-00-5683 AUDIO BOOKS 5,000 0.00% 82-820-56-00-5684 COMPACT DISCS&OTHER MUSIC 3,000 0.00% 82-820-56-00-5685 VIDEOS 5,000 0.00% 82-820-56-00-5686 BOOKS-DEVELOPMENT FEES 0.00% 82-820-56-00-5698 MEMORIALS&GIFTS 3,500 0.00% 82-820-56-00-5699 IMISCELLANEOUS 1,000 0.00% 82-820-70-00-7799 ICONTINGENCIES 10,000 0.00% 82-820-83-00-8000 PRINCIPLE PAYMENT-20058 175,000 0.00% 82-820-83-00-8050 INTEREST PAYMENT-2005B 316,125 0.00% 82-820-84-00-8000 PRINCIPLE PAYMENT-2006 175,000 0.00% 82-820-84-00-8050 INTEREST PAYMENT-2006 54,675 0.00% TOTAL FUND REVENUES 230,61fi 230,616 1,463,300 15.76% TOTAL FUND EXPENDITURES 39,207 39,207 1,586,600 2.47% FUND SURPLUS(DEFICIT) m 191,409 1 191,409 (123,300) ACTUAL EXPENSES BY MONTH(Cash Basis) ll ar-to- ate ANNUAL ACCOUNT NUMBER DESCRIPTION May-11 June-11 July-11 August-11 September-11 October-31 November-11 0ecember-11 January-12 February-12 March-12 April-12 eTotals BUDGET %o1 Budget FOX INDUSTRIAL TIF REVENUES 85-000-40-00-4085 PROPERTY TAXES-FOX INDUSTI 22,114 22,114 0.00% 85-000-45-00-4500 INVESTMENT EARNINGS 0.00% TOTAL REVENUES:FOX INDUSTRIAL TIF 22,114 22,114 FOX INDUSTRIALTIF EXPENDITURES 85-850-54-00-5420 ADMINISTRATIVE FEES 0.00% 85-850-98-00-8000 PRINCIPLE PAYMENT-2002 0.00% 85-850-98-00-8050 INTEREST PAYMENT-2002 3,391 3,391 0.00% 85-850-99-00-9999 TRANSFER OUT 0.00% TOTAL FUND REVENUES 22,114 0.00% TOTAL FUND EXPENDITURES 3,391 0.00% FUND SURPLUS(DEFICIT) 18,723 COUNTRYSIDE TIF REVENUES 87-0)040-00-4087 PROPERTYTAXES-C DUN TRYSIDETI 6,250 0.00% 87-000-45-00-4500 INVESTMENT EARNINGS 36 36 4,000 0.91% TOTAL REVENUES:COUNTRYSIDE TIF 36 36 10,250 0.91% COUNTRYSIDE TIF EXPENDITURES 87-870-54-00-5420 ADMINISTRATIVE FEES 1,000 0.00% 87-870-54-00-5498 PAYING AGENT FEES 400 0.00% 87-870-80-00-8000 PRINCIPLE PAYMENT-2005 175,000 0.00% 87-870-80-00-8050 INTERESTPAYMENT-2005 65,571 65,571 1 131,143 1 50.00% TOTAL FUND REVENUES 36 36 1 10,250 0.35% TOTAL FUND EXPENDITURES 65,571 25,571 307,543 21.32% FUND SURPLUS(DEFICIT) (65,535) (65,535) (297,293) DOWNTOWN TIF REVENUES 88-000-40-00-4088 PROPERTYTA%ES-DOWNTOWNTIF 4,450 4,450 88,550 5.03% 88-000-45-00-4500 INVESTMENT EARNINGS 0.00% TOTAL REVENUES:DOWNTOWN TIF 4,450 4,450 88,550 DOWNTOWN TIF EXPENDITURES 88-880-54-00-5420 ADMINISTRATIVE FEES 1,500 0.00% 88-880-54-00-5462 PROFESSIONAL SERVICES 0.00% 88-880-60-00-6079 1 ROUTE 47 EXPANSION 515,340 TOTAL FUND REVENUES 4,450 88;550 5.03% TOTAL FUND EXPENDITURES 516,840 0.00% FUND SURPLUS(DEFICIT) 4,450 (428,290) A. D CO. Reviewed By: Agenda Item Number a� �.1% Legal ❑ NB #3 Finance EST. leas Engineer El~-� Tracking Number y City Administrator ❑ �L7 Consultant El ADM 2011-28 aLE ❑ Agenda Item Summary Memo Title: Treasurer's Report for May 2011 Meeting and Date: Administration Committee 6/16/11 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 May 31,2011 Cash Basis Revenues %of YTD Expenses %of YTD May Revenues YTD Revenues Budget Budget May Expenses YTD Expenses Budget Budget General Fund O1-General 897,396 897,396 11,491,374 8% 721,550 721,550 10,727,492 7% Special Revenue Funds 15-Motor Fuel Tax 34,781 34,781 1,011,000 3% 28,200 28,200 661,000 4% 79-Parks and Recreation 222,317 222,317 1,175,710 19% 70,577 70,577 1,175,710 6% 72-Land Cash 315,732 315,732 420,500 75% 86,953 86,953 301,084 29% 85-Fox Industrial TIF 22,114 22,114 - 0% 3,391 3,391 - 0% 87-Countryside TIF 36 36 10,250 0% 65,571 65,571 307,543 21% 88-Downtown TIF 4,450 4,450 88,550 5% - - 516,840 0% 11-Fox Hill SSA 599 599 3,786 16% 3,804 0% 12-Sunflower SSA 1,362 1,362 7,530 18% 9,078 0% Debt Service Funds 42-Debt Service 60,751 60,751 427,919 14% 428,669 0% Capital Funds 16-Municipal Building 1,050 1,050 5,250 20% - - - - 22-Park and Recreation Capital 257 257 2,830 9% 292 292 123,500 0% 20-Police Capital 4,127 4,127 21,500 19% 95 95 54,000 0% 21-Public Works Capital 5,111 5,111 35,900 14% 13,716 13,716 92,595 15% 23-City-Wide Capital 19,388 19,388 416,600 5% 125,000 125,000 360,000 35% Enterprise Funds 51-Water 52,764 52,764 2,694,979 2% 353,274 353,274 2,571,858 14% 52-Sewer 583,392 583,392 3,105,490 19% 67,299 67,299 2,919,989 2% 80-Recreation Center 58,296 58,296 611,000 10% 89,079 89,079 691,738 13% Library Fund 82-Library 230,616 230,616 1,463,300 16% 39,207 39,207 1,586,600 2% Total Funds 2,514,539 2,514,539 22,993,468 1,664,205 1,664,205 22,531,500 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 A. D CO. Reviewed By: Agenda Item Number a� �.1% Legal ❑ NB #4 Finance EST. leas Engineer El~-� Tracking Number y City Administrator ■ �L7 Consultant ❑ ADM 2011-29 aLE ❑ Agenda Item Summary Memo Title: Cash Statements for April 2011 Meeting and Date: Administration Committee 6/16/11 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 April 30,2011 CASH Cash-Operations Cash-Special Purpose IL Funds IL Funds Operation Aurora Special Purpose Grand Old Second Castle E-Pay Corp Acct Totals Old Second Castle Earthmovers Totals Totals General Fund 01-General (1,648,367) 9,971 (1,638,396) 2,549 31,493 123 34,165 (1,604,231) Special Revenue Funds 15-Motor Fuel Tax - - 660,220 - 660,220 660,220 72-Land Cash (641,002) (641,002) - - (641,002) 85-Fox Industrial TIF 569,790 569,790 - - 569,790 87-Countryside TIF 17,428 1,161,043 1,178,471 1,000,079 1,000,079 2,178,549 88-Downtown TIF 209,760 - 209,760 - - 209,760 11-Fox Hill SSA 18,249 18,249 18,249 12-Sunflower SSA 12,442 12,442 12,442 Debt Service Funds 42-Debt Service 8,653 8,653 8,653 Capital Funds 16-Municipal Building (587,024) (587,024) (587,024) 20-Police Capital 195,154 195,154 195,154 21-Public Works Capital 101,885 101,885 - - 101,885 23-City-Wide Capital 32,118 32,118 55,771 55,771 87,889 Enterprise Funds 51-Water 119,023 17,640 - 136,663 - - 136,663 52-Sewer 1,874,889 6,194 400,000 2,281,083 2,281,083 Agency Funds 90-Developer Escrow 154,576 - - 154,576 154,576 95-Trust&Agency 414,924 24,941 - 439,865 - - - - 439,865 Total City Funds 852,497 58,746 1,561,043 2,472,286 1,002,628 747,484 123 1,750,234 4,222,520 Distribution% 20.19% 1.39% 36.97% 23.74% 17.70% 0.00% Library Fund 82-Library 349,841 - - - 349,841 - - - - 349,841 Distribution% 100.00% Park and Recreation Funds 79-Parks and Recreation - 387,584 387,584 - 25 25 387,609 22-Park&Rec Capital 51,344 51,344 158,384 158,384 209,728 80-Recreation Center (196,750) (196,750) - - - (196,750) Totals 242,179 242,179 158,384 25 158,409 400,588 Distribution% 60.46% 39.54% 0.01% A. D CO. Reviewed By: Agenda Item Number a� �.1% Legal ■ NB #5 Finance F-1 EST. � =` leas Engineer ❑ ~-� Tracking Number y City Administrator ■ �L7 Consultant ❑ ADM 2011-30 aLE ❑ Agenda Item Summary Memo Title: Prevailing Wage Ordinance Meeting and Date: Administration Committee 6/16/11 Synopsis: Ordinance that declares city's compliance with the Illinois Prevailing Wage Act. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Lisa Pickering Clerk's Office Name Department Agenda Item Notes: Please see attached information. Memorandum EST. -,XT 1836 To: Mayor and City Council From: Lisa Pickering, Deputy Clerk c� 5t= CC: Bart Olson, City Administrator K�U.0— Date: June 6 2011 r v Subject: Prevailing Wage Ordinance The city is required by state statute during the month of June of each year, to investigate and ascertain the prevailing rate of wages as defined in 820 ILCS 130—Prevailing Wage Act. To accomplish this, the city annually approves an ordinance declaring compliance with the Illinois Prevailing Wage Act. The purpose of the Prevailing Wage Act is to ensure that the general prevailing rate of wages for laborers, mechanics, and other workers engaged in the construction of public works coming under the jurisdiction of the city are the same as the prevailing rate of wages for construction work in the Kendall County area. The rate of wages is determined by the Illinois Department of Labor. I have attached the ordinance along with the list of Kendall County prevailing wages for June 2011. After the approval of the ordinance by City Council, a copy of the ordinance will be publicly posted in the glass case in the lobby, a public notice will be placed in the newspaper, and certified copies will be filed with the Secretary of State and the Illinois Department of Labor. COUNTY OF KENDALL ) ss STATE OF ILLINOIS ) ORDINANCE NO. 2011 - AN ORDINANCE DECLARING THE UNITED CITY OF YORKVILLE'S COMPLIANCE WITH ILLINOIS PREVAILING WAGE ACT WHEREAS,the State of Illinois has enacted"An ACT regulating wages of laborers, mechanics, and other workers employed in any public works by the State, County, City or any public body or any political subdivision or by anyone under contract for public works," approved June 26, 1941, as amended, being Chapter 820 ILCS 130/1-12 Illinois Compiled Statutes; and WHEREAS, the aforesaid Act requires that the United City of Yorkville investigate and ascertain the prevailing rate of wages as defined in said Act for laborers, mechanics, and other workers in the locality of said City employed in performing construction of public works, for said City. NOW, THEREFORE,be it ordained by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois as follows: SECTION 1 As required by "An Act regulating wages of laborers, mechanics and other workers employed in any public works by the State, County, City or any public body or any political subdivision or by anyone under contract for public works" approved June 26, 1941, as amended, the general prevailing rate of wages in the locality for laborers, mechanics, and other workers engaged in the construction of public works coming under the jurisdiction of this City is hereby ascertained to be the.same as the prevailing rate of wages for construction work in the Kendall County area as determined by the Department of Labor and the State of Illinois as of June 2011, a copy of that determination being attached hereto as Exhibit "A" and incorporated herein by reference. The definition of any terms appearing in this Ordinance which are also used in the aforesaid Act shall be the same as in said Act. SECTION 2 Nothing herein shall be construed to apply said general prevailing rate of wages as herein ascertained to any work or employment except public works of this City to the extent required by the aforesaid Act. SECTION 3 The City Clerk shall publicly post or keep available for inspection by any interested party in the main office of this City this determination of such prevailing rate of wage. SECTION 4 The City Clerk shall mail a copy of this determination to any employer, and to any association of employers and to any person or association of employees who have filed or file their names and addresses, requesting copies of any determination stating the particular rates and the particular class of workers whose wages will be affected by such rates. SECTION 5 The City shall promptly file a certified copy of this Ordinance with both the Secretary of State Index Division and the Department of Labor of the State of Illinois. SECTION 6 The City Clerk shall cause a notice to be published in a newspaper of general circulation within the area that the determination of prevailing wages has been made. Said notice shall conform substantially to the notice attached hereto as Exhibit`B". Such publication shall constitute notice that this is the determination of the City and is effective. PASSED by the City Council of the United City of Yorkville, Kendall County, Illinois, this Day of , A.D. 2011. City Clerk CHRIS FUNKHOUSER GEORGE GILSON, JR. CARLO COLOSIMO DIANE TEELING JACQUELYN MILSCHEWSKI� MARTY MUNNS ROSE SPEARS LARRY KOT APPROVED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this Day of , A.D. 2011. Mayor Kendall County Prevailing Wage for June 2011 http://www.state.il.us/agency/idol/rates/EVENMO/KENDAU9.htm EXHIBIT "A" Kendall County Prevailing Wage for June 2011 Trade Name RG TYP C Base FRMAN *M-F>8 OSA OSH H/W Pensn Vac Trng ASBESTOS ABT-GEN ALL 35.200 35.700 1.5 1.5 2.0 10.63 8.570 0.000 0.450 ASBESTOS ABT-MEC BLD 32.290 0.000 1.5 1.5 2.0 10.82 10.66 0.000 0.620 BOILERMAKER BLD 43.020 46.890 2.0 2.0 2.0 6.720 9.890 0.000 0.350 BRICK MASON BLD 39.030 42.930 1.5 1.5 2.0 8.800 10.67 0.000 0.740 CARPENTER ALL 40.770 42.770 1.5 1.5 2.0 9.840 9.800 0.000 0.490 CEMENT MASON ALL 41.550 43.550 2.0 1.5 2.0 7.900 10.81 0.000 0.150 CERAMIC TILE FNSHER BLD 33.600 0.000 2.0 1.5 2.0 6.950 8.020 0.000 0.540 COMMUNICATION TECH BLD 35.280 37.380 1.5 1.5 2.0 9.980 9.170 0.000 1.060 ELECTRIC PWR EQMT OP ALL 34.240 45.510 1.5 1.5 2.0 5.000 10.62 0.000 0.260 ELECTRIC PWR GRNDMAN ALL 26.480 45.510 1.5 1.5 2.0 5.000 8.200 0.000 0.200 ELECTRIC PWR LINEMAN ALL 41.000 45.510 1.5 1.5 2.0 5.000 12.71 0.000 0.310 ELECTRIC PWR TRK DRV ALL 27.420 45.510 1.5 1.5 2.0 5.000 8.500 0.000 0.210 ELECTRICIAN BLD 43.560 47.920 1.5 1.5 2.0 10.02 12.20 0.000 1.310 ELEVATOR CONSTRUCTOR BLD 47.410 53.340 2.0 2.0 2.0 10.53 10.71 2.840 0.000 FENCE ERECTOR ALL 43.300 45.460 2.0 2.0 2.0 8.140 17.29 0.000 0.400 GLAZIER BLD 38.000 39.500 1.5 2.0 2.0 10.19 13.64 0.000 0.790 HT/FROST INSULATOR BLD 43.050 45.550 1.5 1.5 2.0 10.82 11.86 0.000 0.620 IRON WORKER ALL 43.300 45.460 2.0 2.0 2.0 8.140 17.29 0.000 0.400 LABORER ALL 35.200 35.950 1.5 1.5 2.0 10.62 8.580 0.000 0.450 LATHER ALL 40.770 42.770 1.5 1.5 2.0 9.840 9.800 0.000 0.490 MACHINIST BLD 43.160 45.160 1.5 1.5 2.0 7.640 8.700 0.000 0.000 MARBLE FINISHERS ALL 29.100 0.000 1.5 1.5 2.0 8.800 10.67 0.000 0.740 MARBLE MASON BLD 39.030 42.930 1.5 1.5 2.0 8.800 10.67 0.000 0.740 MATERIAL TESTER I ALL 25.200 0.000 1.5 1.5 2.0 10.62 8.580 0.000 0.450 MATERIALS TESTER II ALL 30.200 0.000 1.5 1.5 2.0 10.62 8.580 0.000 0.450 MILLWRIGHT ALL 40.770 42.770 1.5 1.5 2.0 9.840 9.800 0.000 0.490 OPERATING ENGINEER BLD 1 45.100 49.100 2.0 2.0 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER BLD 2 43.800 49.100 2.0 2.0 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER BLD 3 41.250 49.100 2.0 2.0 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER BLD 4 39.500 49.100 2.0 2.0 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER BLD 5 48.850 49.100 2.0 2.0 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER BLD 6 46.100 49.100 2.0 2.0 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER BLD 7 48.100 49.100 2.0 2.0 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER HWY 1 43.300 47.300 1.5 1.5 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER HWY 2 42.750 47.300 1.5 1.5 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER HWY 3 40.700 47.300 1.5 1.5 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER HWY 4 39.300 47.300 1.5 1.5 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER HWY 5 38.100 47.300 1.5 1.5 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER HWY 6 46.300 47.300 1.5 1.5 2.0 11.70 8.050 1.900 1.150 OPERATING ENGINEER HWY 7 44.300 47.300 1.5 1.5 2.0 11.70 8.050 1.900 1.150 ORNAMNTL IRON WORKER ALL 43.300 45.460 2.0 2.0 2.0 8.140 17.29 0.000 0.400 PAINTER ALL 40.180 42.180 1.5 1.5 1.5 8.950 8.200 0.000 1.250 PAINTER SIGNS BLD 32.770 36.800 1.5 1.5 1.5 2.600 2.620 0.000 0.000 PILEDRIVER ALL 40.770 42.770 1.5 1.5 2.0 9.840 9.800 0.000 0.490 PIPEFITTER BLD 40.250 42.250 1.5 1.5 2.0 10.15 13.49 0.000 1.360 PLASTERER BLD 39.250 41.610 1.5 1.5 2.0 10.60 10.69 0.000 0.550 PLUMBER BLD 40.250 42.250 1.5 1.5 2.0 10.15 13.49 0.000 1.360 ROOFER BLD 37.650 40.650 1.5 1.5 2.0 7.750 6.570 0.000 0.430 SHEETMETAL WORKER BLD 41.660 43.660 1.5 1.5 2.0 8.810 10.66 0.000 0.780 SPRINKLER FITTER BLD 49.200 51.200 1.5 1.5 2.0 8.500 8.050 0.000 0.350 STEEL ERECTOR ALL 43.300 45.460 2.0 2.0 2.0 8.140 17.29 0.000 0.400 STONE MASON BLD 39.030 42.930 1.5 1.5 2.0 8.800 10.67 0.000 0.740 TERRAZZO FINISHER BLD 35.150 0.000 1.5 1.5 2.0 6.950 10.57 0.000 0.430 TERRAZZO MASON BLD 39.010 42.010 1.5 1.5 2.0 6.950 11.91 0.000 0.510 TILE MASON BLD 40.490 44.490 2.0 1.5 2.0 6.950 9.730 0.000 0.610 TRUCK DRIVER ALL 1 35.650 36.200 1.5 1.5 2.0 6.670 4.725 0.000 0.250 TRUCK DRIVER ALL 2 35.800 36.200 1.5 1.5 2.0 6.670 4.725 0.000 0.250 TRUCK DRIVER ALL 3 36.000 36.200 1.5 1.5 2.0 6.670 4.725 0.000 0.250 1 of 6 6/6/2011 12:13 PM Kendall County Prevailing Wage for June 2011 http://www.state.il.us/agency/idol/rates/EVENM0/KENI)ALL9.htm TRUCK DRIVER ALL 4 36.200 36.200 1.5 1.5 2.0 6.670 4.725 0.000 0.250 TUCKPOINTER BLD 39.200 40.200 1.5 1.5 2.0 7.830 10.25 0.000 0.770 Legend: M-F>8 (Overtime is required for any hour greater than 8 worked each day, Monday through Friday. OSA (Overtime is required for every hour worked on Saturday) OSH (Overtime is required for every hour worked on Sunday and Holidays) H/W (Health & Welfare Insurance) Pensn (Pension) Vac (Vacation) Trng (Training) Explanations KENDALL COUNTY The following list is considered as those days for which holiday rates of wages for work performed apply: New Years Day, Memorial Day, Fourth of July, Labor Day, Thanksgiving Day, Christmas Day and Veterans Day in some classifications/counties. Generally, any of these holidays which fall on a Sunday is celebrated on the following Monday. This then makes work performed on that Monday payable at the appropriate overtime rate for holiday pay. Common practice in a given local may alter certain days of celebration. If in doubt, please check with IDOL. EXPLANATION OF CLASSES ASBESTOS - GENERAL - removal of asbestos material/mold and hazardous materials from any place in a building, including mechanical systems where those mechanical systems are to be removed. This includes the removal of asbestos materials/mold and hazardous materials from ductwork or pipes in a building when the building is to be demolished at the time or at some close future date. ASBESTOS - MECHANICAL - removal of asbestos material from mechanical systems, such as pipes, ducts, and boilers, where the mechanical systems are to remain. CERAMIC TILE FINISHER The grouting, cleaning, and polishing of all classes of tile, whether for interior or exterior purposes, all burned, glazed or unglazed products; all composition materials, granite tiles, warning detectable tiles, cement tiles, epoxy composite materials, pavers, glass, mosaics, fiberglass, and all substitute materials, for tile made in tile-like units; all mixtures in tile like form of cement, metals, and other materials that are for and intended for use as a finished floor surface, stair treads, promenade roofs, walks, walls, ceilings, swimming pools, and all other places where tile is to form a finished interior or exterior. The mixing of all setting mortars including but not limited to thin-set mortars, epoxies, wall mud, and any other sand and cement mixtures or adhesives when used in the preparation, installation, repair, or maintenance of tile and/or similar materials. The handling and unloading of all sand, cement, lime, tile, fixtures, equipment, adhesives, or any other materials to be used in the preparation, installation, repair, or maintenance of tile and/or similar materials. Ceramic Tile Finishers shall fill all joints and voids regardless of method on all tile work, particularly and especially after installation of said tile work. Application of any and all protective coverings to all types of tile installations including, but not be limited to, all soap compounds, paper products, 2 of 6 6/6/2011 12:13 PM Kendall County Prevailing Wage for June 2011 http://www.state.il.us/agency/idol/rates/EVENM0/KENDALL9.htm tapes, and all polyethylene coverings, plywood, masonite, cardboard, and any new type of products that may be used to protect tile installations, Blastrac equipment, and all floor scarifying equipment used in preparing floors to receive tile. The clean up and removal of all waste and materials. All demolition of existing tile floors and walls to be re-tiled. COMMUNICATIONS TECHNICIAN Construction, installation, maintenance and removal of telecommunication facilities (voice, sound, data and video) , telephone, security, and data inside wire, interconnect, terminal equipment, central offices, PABX and equipment, micro waves, V-SAT, bypass, CATV, WAN (wide area network) , LAN (local area networks) , and ISDN (integrated system digital network) , pulling of wire in raceways, but not the installation of raceways. MARBLE FINISHER Loading and unloading trucks, distribution of all materials (all stone, sand, etc. ) , stocking of floors with material, performing all rigging for heavy work, the handling of all material that may be needed for the installation of such materials, building of scaffolding, polishing if needed, patching, waxing of material if damaged, pointing up, caulking, grouting and cleaning of marble, holding water on diamond or Carborundum blade or saw for setters cutting, use of tub saw or any other saw needed for preparation of material, drilling of holes for wires that anchor material set by setters, mixing up of molding plaster for installation of material, mixing up thin set for the installation of material, mixing up of sand to cement for the installation of material and such other work as may be required in helping a Marble Setter in the handling of all material in the erection or installation of interior marble, slate, travertine, art marble, serpentine, alberene stone, blue stone, granite and other stones (meaning as to stone any foreign or domestic materials as are specified and used in building interiors and exteriors and customarily known as stone in the trade) , carrara, sanionyx, vitrolite and similar opaque glass and the laying of all marble tile, terrazzo tile, slate tile and precast tile, steps, risers treads, base, or any other materials that may be used as substitutes for any of the aforementioned materials and which are used on interior and exterior which are installed in a similar manner. MATERIAL TESTER I: Hand coring and drilling for testing of materials; field inspection of uncured concrete and asphalt. MATERIAL TESTER II: Field inspection of welds, structural steel, fireproofing, masonry, soil, facade, reinforcing steel, formwork, cured concrete, and concrete and asphalt batch plants; adjusting proportions of bituminous mixtures. OPERATING ENGINEER - BUILDING Class 1. Asphalt Plant; Asphalt Spreader; Autograde; Backhoes with Caisson Attachment; Batch Plant; Benoto (requires Two Engineers) ; Boiler and Throttle Valve; Caisson Rigs; Central Redi-Mix Plant; Combination Back Hoe Front End-loader Machine; Compressor and Throttle Valve; Concrete Breaker (Truck Mounted) ; Concrete Conveyor; Concrete Conveyor (Truck Mounted) ; Concrete Paver Over 27E cu. ft; Concrete Paver 27E cu. ft. and Under: Concrete Placer; Concrete Placing Boom; Concrete Pump (Truck Mounted) ; Concrete Tower; Cranes, All; Cranes, Hammerhead; Cranes, (GCI and similar Type) ; Creter Crane; Crusher, Stone, etc. ; Derricks, All; Derricks, Traveling; Formless Curb and Gutter Machine; Grader, Elevating; Grouting Machines; Highlift Shovels 3 of 6 6/6/2011 12:13 PM Kendall County Prevailing Wage for June 2011 http://www.state.il.us/agency/idol/rates/EVENMO/KENDALL9.htin or Front Endloader 2-1/4 yd. and over; Hoists, Elevators, outside type rack and pinion and similar machines; Hoists, One, Two and Three Drum; Hoists, Two Tugger One Floor; Hydraulic Backhoes; Hydraulic Boom Trucks; Hydro Vac (and similar equipment) ; Locomotives, All; Motor Patrol; Lubrication Technician; Manipulators; Pile Drivers and Skid Rig; Post Hole Digger; Pre-Stress Machine; Pump Cretes Dual Ram; Pump Cretes: Squeeze Cretes-Screw Type Pumps; Gypsum Bulker and Pump; Raised and Blind Hole Drill; Roto Mill Grinder; Scoops - Tractor Drawn; Slip-Form Paver; Straddle Buggies; Tournapull; Tractor with Boom and Side Boom; Trenching Machines. Class 2. Boilers; Broom, All Power Propelled; Bulldozers; Concrete Mixer (Two Bag and Over) ; Conveyor, Portable; Forklift Trucks; Highlift Shovels or Front Endloaders under 2-1/4 yd. ; Hoists, Automatic; Hoists, Inside Elevators; Hoists, Sewer Dragging Machine; Hoists, Tugger Single Drum; Rock Drill (Self-Propelled) ; Rock Drill (Truck Mounted) ; Rollers, All; Steam Generators; Tractors, All; Tractor Drawn Vibratory Roller; Winch Trucks with "A" Frame. Class 3 . Air Compressor; Combination Small Equipment Operator; Generators; Heaters, Mechanical; Hoists, Inside Elevators; Hydraulic Power Units (Pile Driving, Extracting, and Drilling) ; Pumps, over 3" (1 to 3 not to exceed a total of 300 ft.) ; Low Boys; Pumps, Well Points; Welding Machines (2 through 5) ; Winches, 4 Small Electric Drill Winches; Bobcats (up to and including % cu yd. ) . Class 4. Bobcats and/or other Skid Steer Loaders (other than bobcats up to and including X cu yd.) ; Oilers; and Brick Forklift. Class 5. Assistant Craft Foreman. Class G. Gradall Class 7. Mechanics. OPERATING ENGINEERS - HIGHWAY CONSTRUCTION Class 1. Asphalt Plant; Asphalt Heater and Planer Combination; Asphalt Heater Scarfire; Asphalt Spreader; Autograder/GOMACO or other similar type machines: ABG Paver; Backhoes with Caisson Attachment; Ballast Regulator; Belt Loader; Caisson Rigs; Car Dumper; Central Redi-Mix Plant; Combination Backhoe Front Endloader Machine, (1 cu. yd. Backhoe Bucket or over or with attachments) ; Concrete Breaker (Truck Mounted) ; Concrete Conveyor; Concrete Paver over 27E cu. ft. ; Concrete Placer; Concrete Tube Float; Cranes, all attachments; Cranes, Tower Cranes of all types: Creter Crane: Crusher, Stone, etc. ; Derricks, All; Derrick Boats; Derricks, Traveling; Dowell Machine with Air Compressor; Dredges; Formless Curb and Gutter Machine; Grader, Elevating; Grader, Motor Grader, Motor Patrol, Auto Patrol, Form Grader, Pull Grader, Subgrader; Guard Rail Post Driver Truck Mounted; Hoists, One, Two and Three Drum; Hydraulic Backhoes; Backhoes with shear attachments; Lubrication Technician; Manipulators; Mucking Machine; Pile Drivers and Skid Rig; Pre-Stress Machine; Pump Cretes Dual Ram; Rock Drill - Crawler or Skid Rig; Rock Drill - Truck Mounted; Rock/Track Tamper; Roto Mill Grinder; Slip-Form Paver; Soil Test Drill Rig (Truck Mounted) ; Straddle Buggies; Hydraulic Telescoping Form (Tunnel) ; Tractor Drawn Belt Loader (with attached pusher - two engineers) ; Tractor with Boom; Tractaire with Attachments; Trenching Machine; Truck Mounted Concrete Pump with Boom; Raised or Blind Hole Drills (Tunnel Shaft) ; Underground Boring and/or Mining Machines 5 ft. in diameter and over tunnel, etc; Underground Boring and/or Mining Machines under 5 ft. in diameter; Wheel Excavator; Widener (APSCO) . 4 of 6 6/6/2011 12:13 PM Kendall County Prevailing Wage for June 2011 http://www.state.il.us/agency/idol/rates/EVENMO/KENDALL9.hti-n Class 2. Batch Plant; Bituminous Mixer; Boiler and Throttle Valve; Bulldozers; Car Loader Trailing Conveyors; Combination Backhoe Front Endloader Machine (Less than 1 cu. yd. Backhoe Bucket or over or with attachments) ; Compressor and Throttle Valve; Compressor, Common Receiver (3) ; Concrete Breaker or Hydro Hammer; Concrete Grinding Machine; Concrete Mixer or Paver 7S Series to and including 27 cu. ft. ; Concrete Spreader; Concrete Curing Machine, Burlap Machine, Belting Machine and Sealing Machine; Concrete Wheel Saw; Conveyor Muck Cars (Haglund or Similar Type) ; Drills, All; Finishing Machine - Concrete; Highlift Shovels or Front Endloader; Hoist - Sewer Dragging Machine; Hydraulic Boom Trucks (All Attachments) ; Hydro-Blaster; All Locomotives, Dinky; Off-Road Hauling Units (including articulating) /2 ton capacity or more; Non Self-Loading Ejection Dump; Pump Cretes: Squeeze Cretes - Screw Type Pumps, Gypsum Bulker and Pump; Roller, Asphalt; Rotary Snow Plows; Rototiller, Seaman, etc. , self-propelled; Scoops - Tractor Drawn; Self-Propelled Compactor; Spreader - Chip - Stone, etc. ; Scraper; Scraper - Prime Mover in Tandem (Regardless of Size) : Tank Car Heater; Tractors, Push, Pulling Sheeps Foot, Disc, Compactor, etc. ; Tug Boats. Class 3. Boilers; Brooms, All Power Propelled; Cement Supply Tender; Compressor, Common Receiver (2) ; Concrete Mixer (Two Bag and Over) ; Conveyor, Portable; Farm-Type Tractors Used for Mowing, Seeding, etc. ; Fireman on Boilers; Forklift Trucks; Grouting Machine; Hoists, Automatic; Hoists, All Elevators; Hoists, Tugger Single Drum; Jeep Diggers; Low Boys; Pipe Jacking Machines; Post-Hole Digger; Power Saw, Concrete Power Driven; Pug Mills; Rollers, other than Asphalt; Seed and Straw Blower; Steam Generators; Stump Machine; Winch Trucks with "A" Frame; Work Boats; Tamper-Form-Motor Driven. Class 4. Air Compressor; Combination - Small Equipment Operator; Directional Boring Machine; Generators; Heaters, Mechanical; Hydraulic Power Unit (Pile Driving, Extracting, or Drilling) ; Hydro- Blaster; Light Plants, All (1 through 5) ; Pumps, over 3" (1 to 3 not to exceed a total of 300 ft. ) ; Pumps, Well Points; Tractaire; welding Machines (2 through 5) ; Winches, 4 Small Electric Drill Winches. Class 5. Bobcats (all) ; Brick Forklifts; Oilers. Class 6. Field Mechanics and Field Welders Class 7. Gradall and machines of like nature. TRUCK DRIVER - BUILDING, HEAVY AND HIGHWAY CONSTRUCTION Class 1. Two or three Axle Trucks. A-frame Truck when used for transportation purposes; Air Compressors and Welding Machines, including those pulled by cars, pick-up trucks and tractors; Ambulances Batch Gate Lockers; Batch Hopperman; Car and Truck Washers; Carry-alls; Fork Lifts and Hoisters; Helpers; Mechanics Helpers and Greasers; Oil Distributors 2-man operation; Pavement Breakers; Pole Trailer, up to 40 feet; Power Mower Tractors; Self-propelled Chip Spreader; Skipman; Slurry Trucks, 2-man operation; Slurry Truck Conveyor Operation, 2 or 3 man; Teamsters; Unskilled dumpman; and Truck Drivers hauling warning lights, barricades, and portable toilets on the job site. Class 2. Four axle trucks; Dump Crets and Adgetors under 7 yards; Dumpsters, Track Trucks, Euclids, Hug Bottom Dump Turnapulls or Turnatrailers when pulling other than self-loading equipment or similar equipment under 16 cubic yards; Mixer Trucks under 7 yeards; Ready-mix Plant Hopper Operator, and Winch Trucks, 2 Axles. 5 of 6 6/6/2011 12:13 PM Kendall County Prevailing Wage for June 2011 http://www.state.it.us/agency/idol/rates/EVENM0/KENDA.L.L9.htm Class 3. Five axle trucks; Dump Crets and Adgetors 7 yards and over; Dumpsters, Track Trucks, Euclids, Hug Bottom Dump Turnatrailers or turnapulls when pulling other than self-loading equipment or similar equipment over 16 cubic yards; Explosives and/or Fission Material Trucks; Mixer Trucks 7 yards or over; Mobile Cranes while in transit; Oil Distributors, 1-man operation; Pole Trailer, over 40 feet; Pole and Expandable Trailers hauling material over 50 feet long; Slurry trucks, 1-man operation; Winch trucks, 3 axles or more; Mechanic--Truck welder and Truck Painter. Class 4. Six axle trucks; Dual-purpose vehicles, such as mounted crane trucks with hoist and accessories; Foreman; Master Mechanic; Self-loading equipment like P.B. and trucks with scoops on the front. TERRAZZO FINISHER The handling of sand, cement, marble chips, and all other materials that may be used by the Mosaic Terrazzo Mechanic, and the mixing, grinding, grouting, cleaning and sealing of all Marble, Mosaic, and Terrazzo work, floors, base, stairs, and wainscoting by hand or machine, and in addition, assisting and aiding Marble, Masonic, and Terrazzo Mechanics. Other Classifications of work: For definitions of classifications not otherwise set out, the Department generally has on file such definitions which are available. If a task to be performed is not subject to one of the classifications of pay set out, the Department will upon being contacted state which neighboring county has such a classification and provide such rate, such rate being deemed to exist by reference in this document. If no neighboring county rate applies to the task, the Department shall undertake a special determination, such special determination being then deemed to have existed under this determination. If a project requires these, or any classification not listed, please contact IDOL at 217-782-1710 for wage rates or clarifications. LANDSCAPING Landscaping work falls under the existing classifications for laborer, operating engineer and truck driver. The work performed by landscape plantsman and landscape laborer is covered by the existing classification of laborer. The work performed by landscape operators (regardless of equipment used or its size) is covered by the classifications of operating engineer. The work performed by landscape truck drivers (regardless of size of truck driven) is covered by the classifications of truck driver. 6 of 6 6/6/2011 12:13 PM Exhibit "B" Public Notice Notice of Ordinance No. Prevailing Wage Rates The United City of Yorkville has passed an Ordinance establishing the prevailing rate of wages hereby ascertained to be the same as the prevailing rate of wages for construction work in the Kendall County area as determined by the Department of Labor and the State of Illinois as of June 2011. Anyone wishing to inspect the ordinance may do so at: City Hall, 800 Game Farm Road, Yorkville, Illinois, Monday through Friday, between the hours of 8:00 A.M. and 4:30 P.M. BETH WARREN City Clerk BY: Lisa Pickering Deputy Clerk c/Ty Reviewed By: Agenda Item Number J� a 0-0 Legal ❑ NB #6 II Finance ❑ EST. , � 1836 Engineer ❑ Agenda Item Tracking Number y City Administrator ■ Consultant ❑ EDC 2011-21 dal County El`E City Council Agenda Item Summary Memo Title: Dormant Zoning Applications/Petitions Meeting and Date: Administration Committee—June 16, 2011 Synopsis: Proposed policy for dormant zoning applications/petitions and the refund of deposits. Council Action Previously Taken: Date of Action: N/A Action Taken: N/A Item Number: N/A Type of Vote Required: Discussion Council Action Requested: Direction to prepare ordinance for City Council consideration. Submitted by: Krysti Barksdale-Noble, AICP Community Development Name Department Agenda Item Notes: See attached staff memorandum. This item was also discussed at the 6/7/11 EDC meeting. Cpl 0 Memorandum EST. 1836 To: Economic Development Committee --� From: Krysti J. Barksdale-Noble, Community Development Director '{ 11 E CC: Bart Olson, City Administrator �d��o Ty •Z ��< Date: June 3, 2011 LE 1� Subject: Proposed Policy for Dismissing Dormant Zoning Applications/Petitions and Refund of Deposits Background Since the downturn in the housing market, there has been a backlog of developer petitions/applications with little to no activity for more than a year. Most of these applications have engineering and legal deposits associated with them. In total, there are approximately 30 development applications and nearly$110,000.00 in deposits. Staff has begun to identify which applications are dormant and have contacted the petitioner as to their intention to move forward with the project. We have also determined which applications with associated deposits are eligible for refund. It is important to note that the deposits are not associated with the city's general fund balance and the release of the funds will have no budgetary impact. Further, upon releasing the stagnant application deposits the city will have satisfied an audit obligation. Staff Recommendation Currently, the city does not have a policy which explicitly allows zoning applications to be dismissed in cases where the applicant has been unresponsive for an extended period of time. Therefore, staff is seeking direction from the committee to draft an ordinance that will allow the Community Development Director to dismiss any zoning application or petition submitted, if any of the circumstances exist: • The application is incomplete and the applicant has been notified of such deficiencies and has not responded or provided a timeline for completing the application within ninety (90) days from the time of notification; • The applicant has not responded in writing to a request for information or documentation from the initial Plan Council review within six (6) months from the date of the request; • The applicant has not responded to a request for legal or engineering deposit replenishment for city incurred costs and fees within ninety (90) days from the date of the request. Staff proposes that the applicant will be notified in writing by the Community Development Department of the intent to dismiss the application within thirty (30) days from the date of the written notice and all remaining legal and engineering deposits will be refunded at that the time of dismissal. Should it be the consensus of the committee to have such a policy in place regarding dormant zoning applications/petitions, staff will prepare draft ordinance language to present to the EDC at an upcoming meeting for further review. 1 A. D CO. Reviewed By: Agenda Item Number a� �.1% Legal ❑ NB #7 Finance F-1 EST. � =` leas Engineer ❑ ~-� Tracking Number City Administrator ❑ C? � Consultant El� CC 2011-48 CLE ❑ Agenda Item Summary Memo Title: City Debt Obligations and Options Meeting and Date: Administration Committee 6/16/11 Synopsis: Council Action Previously Taken: Date of Action: CC 5/24/11 Action Taken: Discussion Item Number: CC 2011-48 Type of Vote Required: Council Action Requested: Submitted by: Bart Olson Administration Name Department Agenda Item Notes: Meghan Ostreko From: Bart Olson Sent: Friday, June 10, 2011 8:34 AM To: Lisa Pickering; Meghan Ostreko Cc: Kevin McCanna; Kathleen Field Orr; Gary Golinski; rosea00 @aol.com Subject: FW: Refinancing--Additional thoughts Please use this email in the Admin packet for next Thursday, as well as all other information provided at the last City Council meeting. I will forward over one more piece of information too. Bart Olson City Administrator Interim Director of Parks and Recreation United City of Yorkville 800 Game Farm Road Yorkville, IL 60560 630-553-8537 direct 630-553-4350 City Hall 630-308-0582 cell bolson @yorkville.il.us From: Kevin McCanna [mailto:kmccanna @speerfinancial.com] Sent: Friday, May 27, 20118:13 AM To: 'Kathleen Field Orr'; Bart Olson Subject: Refinancing--Additional thoughts Good morning The schedule sent yesterday was for 10 years and used the $1,500,000 to accomplish the refinancing. If a longer schedule were preferred, it would use less of the $1,500,000 annually and add about$100,000 cost per year of extended term. So the $1,000,000 cost of 10 years would become $1,100,000 for 11 years; the present value savings also erodes by some$20,000 to $25,000 annually. As to timing, while the transaction can occur anytime over the next year,the concern is that inflation is coming back and this is likely to raise rates sooner rather than later. This suggests that a sale this year is probably better than next year, especially if the focus is on capturing the lower interest rates. Kevin The information provided is presented as an aid in decision making. Current and future market conditions and interest rates are subject to change and any information based on such market conditions and interest rates is not guaranteed. E-mails from this firm normally contain confidential and privileged material and are for the sole use of the intended recipient. Use or distribution by an unintended recipient is prohibited,and may be a violation of law. If you believe that you received this e-mail in error,please do not read this e-mail or any attached items. Please delete the email and all attachments including any copies thereof,and inform the sender that you have deleted the e-mail,all attachments and any copies thereof. Thank you. Speer Financial,Inc. A federally registered financial advisor and charter member of the National Association of Independent Public Financial Advisors"NAIPFA". 1 Meghan Ostreko From: Bart Olson Sent: Friday, June 10, 2011 8:35 AM To: Lisa Pickering; Meghan Ostreko Cc: Kevin McCanna; Gary Golinski; rosea00 @aol.com; Kathleen Field Orr Subject: FW: Refinancing Attachments: YORYSer 2011 Ref 2005D 2008 2021 km.xls Please use this email and spreadsheet in the packet for refinancing, also. Bart Olson City Administrator Interim Director of Parks and Recreation United City of Yorkville 800 Game Farm Road Yorkville, IL 60560 630-553-8537 direct 630-553-4350 City Hall 630-308-0582 cell bolson @vorkville.il.us From: Kevin McCanna [mailto:kmccanna @speerfinancial.com] Sent: Thursday, May 26, 2011 12:42 PM To: 'Kathleen Field Orr'; Bart Olson Subject: Refinancing HI Here is a sample 10 year issue. Savings from refinancing to a lower interest rate are about$120,000 on a present value(2011 dollars). The restructuring of the debt service to enable it to be paid from the sales taxes with NO property tax results in a nominal cost (current value) of some $998,000. The nominal cost is the price paid for moving some of the bond payment back to where it is affordable;for instance 2015 has a current debt of over$3,000,000 and this is reduced to $1,500,000 with the excess essentially moved back to the 2020-2021 period. I think there is also an equity issue here, as this is a long lived system that was financed very short under a certain development scenario and, in the current period, adding four years seems more equitable to the taxpayers. Kevin The information provided is presented as an aid in decision making. Current and future market conditions and interest rates are subject to change and any information based on such market conditions and interest rates is not guaranteed. E-mails from this firm normally contain confidential and privileged material and are for the sole use of the intended recipient. Use or distribution by an unintended recipient is prohibited,and maybe a violation of law. If you believe that you received this e-mail in error,please do not read this e-mail or any attached items. Please delete the email and all attachments including any copies thereof,and inform the sender that you have deleted the e-mail,all attachments and any copies thereof. Thank you. Speer Financial,Inc. A federally registered financial advisor and charter member of the National Association of Independent Public Financial Advisors"NAIPFA". 1 United City of Yorkville, Kendall County, Illinois Series 2011 Refunds 2005D and 2008 2021 Sources & Uses Dated 08/01/2011 1 Delivered 08/01/2011 Sources Of Funds Par Amount of Bonds $11,795,000.00 Total Sources $11,795,000.00 Uses Of Funds Total Underwriter's Discount (0.800%) 94,360.00 Costs of Issuance 117,950.00 Deposit to Current Refunding Fund 11,578,871.21 Rounding Amount 3,818.79 Total Uses $11,795,000.00 Ser 2011 Ref 2005D 2008 1 SINGLE PURPOSE 1 5/26/2011 1 12:31 PM Public Speer Financial, Inc. • United City of Yorkville, Kendall County, Illinois Series 2011 Refunds 2005D and 2008 2021 Debt Service Comparison Date Total P+I Net New D/S Old Net D/S Savings 12/30/2011 1,248,020.00 1,248,020.00 12/30/2012 1,474,921.74 1,474,921.74 2,054,540.00 579,618.26 12/30/2013 1,458,897.50 1,458,897.50 2,088,140.00 629,242.50 12/30/2014 1,461,305.00 1,461,305.00 2,317,590.00 856,285.00 12/30/2015 1,458,782.50 1,458,782.50 3,234,590.00 1,775,807.50 12/30/2016 1,461,170.00 1,461,170.00 1,095,090.00 (366,080.00) 12/30/2017 1,454,237.50 1,454,237.50 1,091,407.50 (362,830.00) 12/30/2018 1,461,722.50 1,461,722.50 (1,461,722.50) 12/30/2019 1,458,372.50 1,458,372.50 (1,458,372.50) 12/30/2020 1,469,060.00 1,469,060.00 (1,469,060.00) 12/30/2021 969,060.00 969,060.00 (969,060.00) Total $14,127,529.24 $14,127,529.24 $13,129,377.50 (998,151.74) PV Analysis Summary(Net to Net) Gross PV Debt Service Savings 115,564.06 Net PV Cashflow Savings @ 3.598%(AIC) 115,564.06 Contingency or Rounding Amount 3,818.79 Net Present Value Benefit $119,382.85 Net PV Benefit/ $9,300,000 Refunded Principal 1.284% Net PV Benefit/$11,795,000 Refunding Principal 1.012% Refunding Bond Information Refunding Dated Date 8/01/2011 Refunding Delivery Date 8/01/2011 Ser 2011 Ref 2005D 2008 1 SINGLE PURPOSE 1 5/26/2011 1 12:31 PM Public Speer Financial, Inc. .��0 Co.y o Memorandum " To: City Council EST. �Z 1836 From: Bart Olson, City Administrator .4 ` CC: O C u " p Date: May 18, 2011 Count�Y Seat Subject: City debt obligations and options �At Purpose Discussing options available to the City to address debt obligations due in FY 12 and beyond, in light of non-home rule sales tax referendum approval. Background To recap our current debt obligations, Finance Director Fredrickson has attached four spreadsheets. The first is a spreadsheet of all existing debt obligations for FY 12 (current), FY 13, and FY 14. This spreadsheet is labeled as "Spreadsheet A: List of all debt service"For ease of use, I have included a column within the spreadsheet that assigns a number to each debt (1- 19). The second spreadsheet is a list of all debt services that we did not abate last year, which will be paid by property taxes in summer 2011. This spreadsheet is labeled as "Spreadsheet B: List of debt service not abated last year(aka—debts paid by property taxes)". For every payment on this spreadsheet, we must decide by February 2012 whether these payments will be made with property taxes (in Summer 2012) or whether we will be find another source of revenue (i.e. non-home rule sales taxes). The third spreadsheet is a list of all debt services that we either abated last year, or for which no abatement was required. This spreadsheet is labeled as "Spreadsheet C: list of debt service abated or where no abatement was required". The fourth spreadsheet is a list of all debt services that we planned in the FY 12 budget to be paid by property taxes through FY 12, FY 13, and FY 14. This spreadsheet is labeled as "Spreadsheet D: Non-abatements planned in FY 12 budget". When deciding whether to refinance existing bonds, to abate bond payments in future years, and other scenarios, this spreadsheet is the most useful. Non-home rule sales tax In the 2011 municipal elections, the citizens authorized the City's use of a I% non-home rule sales tax. This sales tax must still be authorized by ordinance, and will be implemented on January 1, 2012 if approved by City Council. Because we do not currently have access to sales tax figures for individual businesses, it is difficult to pinpoint exactly how much non-home rule sales tax we expect to receive. However, a study of some of other municipalities shows our range could be anywhere from 50%to 75% of our current sales tax figures. At a $2.4 million current sales tax figures, this means our non-home rule sales tax is likely to generate between $1.2 million and $1.8 million per year. For purposes of illustrating the impact of this new revenue on our existing debt obligations, I have used a $1.5 million figure in "Spreadsheet E"to show the potential immediate reduction in property taxes as a result of the non-home rule sales tax. The calculations on property tax reductions are included at the bottom of the spreadsheet. Refinancing options Our financial advisor, Kevin McCanna of Speer Financial, has studied our debts and concluded that only the Rob Roy bonds (2005D and 2008) make sense to consider refinancing. His justification is attached in a memo. The memo also contains four debt service schedules for potential refinancing bonds of different terms. As you can see from the schedule, the refinancing would significantly reduce our yearly debt burden in the near term. The flexibility provided by the non-home rule sales tax allows us to almost completely eliminate the property taxes associated with debt payments for FY 13 and beyond(-90%), which is a major upside to residents who have had trouble making the current property tax payments. This is illustrated in "Spreadsheet F,"which shows a 20-year refinancing of our Rob Roy bonds. The downside to this option is that the total debt is stretched from about $11.3 million to between $16 million and $17 million due to new interest and bond issuance costs. Recommendation The issue to refinance is a policy decision for the City Council to make. The flexibility provided by the non-home rule sales tax makes the reduction in property taxes for FY 13 and beyond a reality. The question at hand is whether we want the City property taxes to decrease between 10% and 25% for the next few years (no refinancing) or if we want property taxes to decrease between 20% and 35% for the next few years (with refinancing). Spreadsheet A: List of all debt service Debt# Debt Issue Fund Total Debt Service FY 2012 FY 2013 FY 2014 1 Series 2002-Fox Industrial Fox Industrial TIF-85 76,783 78,563 2 Series 2005-Countryside Countryside TIF-87 306,143 304,668 302,738 3 Series 2004C-Road Improv Program Debt Service-42 103,740 99,465 - 4 Series 2005A-In Town Rd Frog Phase 1 Debt Service-42 324,179 326,379 328,179 427,919 425,844 328,179 5 Series 2007A Refunding Water-51 133,866 133,454 138,041 6 Series 2002 Cap Apprec Certs-North Water Twr Water-51 285,000 365,000 - 7 Series 2003 Debt Certificates Water-51 33,150 33,150 133,150 8 Series 2006A Refunding Debt Certs Water-51 158,506 574,806 610,606 9 Series 2005C-Improv to Water Dist Sys* Water-51 167,725 164,575 165,975 10 [EPA Loan L17-156300 Water-51 125,030 125,030 125,030 903,277 1,396,015 1,172,802 11 Series 2004B-Sanitary SW Autumn Creek Sewer-52 258,650 263,850 368,750 12 Series 2003 IRRB-Bruell St Lift Station Sewer-52 165,143 166,248 162,048 13 Series 2004A Debt Certs-SS Windett,Raintree Sewer-52 194,093 193,738 193,050 14 Series 2005D Rob Roy Sewer-52 1,385,950 1,944,450 1,978,050 15 Series 2008 Refunding Sewer-52 110,090 110,090 110,090 16 IEPA Loan L17-013000 Sewer-52 38,980 38,980 - 17 IEPA Loan L17-115300 Sewer-52 107,051 107,051 107,051 2,259,957 2,824,407 2,919,039 18 Series 2005B-Library Expansion Library-82 491,125 599,125 632,525 19 Series 2006-Library Expansion Library-82 229,675 196,363 139,238 720,800 795,488 771,763 * Sewer Fund will transfer 1/2 the debt service FY2012-$83,863 FY2013-$82,288 FY2014-$82,988 Spreadsheet B: List of debt service not abated last year(aka-debts paid by property taxes) Debt# Debt Issue Fund Total Debt Service FY 2012 4 Series 2005A- In Town Rd Prog Phase 1 Debt Service-42 324,179 5 Series 2007A Refunding Water-51 133,866 11 Series 2004B-Sanitary SW Autumn Creek Sewer-52 258,650 14 Series 2005D Rob Roy Sewer-52 1,385,950 15 Series 2008 Refunding Sewer-52 110,090 1,754,690 Total Not Abated-City 2,212,735 Library 18 Series 2005B-Library Expansion Library-82 491,125 19 Series 2006- Library Expansion Library-82 229,675 720,800 Spreadsheet C: list of debt service abated or where no abatement was requirec Debt# Debt Issue Fund Total Debt Service FY 2012 1 Series 2002-Fox Industrial Fox Industrial TIF-85 76,783 Abated-Ord 2010-65 2 Series 2005-Countryside Countryside TIF-87 306,143 Abated-Ord 2010-64 3 Series 2004C-Road Improv Program Debt Service-42 103,740 No abatement required 6 Series 2002 Cap Apprec Certs-North Water Twr Water-51 285,000 No abatement required 7 Series 2003 Debt Certificates Water-51 33,150 No abatement required 8 Series 2006A Refunding Debt Certs Water-51 158,506 No abatement required 9 Series 2005C-Improv to Water Dist Sys* Water-51 167,725 Abated-Ord 2010-66 10 IEPA Loan L17-156300 Water-51 125,030 No abatement required 769,411 12 Series 2003 IRRB-Bruell St Lift Station Sewer-52 165,143 No abatement required 13 Series 2004A Debt Certs-SS Windett,Raintree Sewer-52 194,093 No abatement required 16 IEPA Loan L17-013000 Sewer-52 38,980 No abatement required 17 IEPA Loan L17-115300 Sewer-52 107,051 No abatement required 505,267 Spreadsheet D: Non-abatements planned in FY 12 budget Debt# Debt Issue Fund Total Debt Service Notes on budgetary impact of abatement FY 2012 FY 2013 FY 2014 4 Series 2005A-In Town Rd Prog Phase 1 Debt Service-42 324,179 326,379 328,179 324,179 326,379 328,179 Direct hit on general fund 5 Series 2007A Refunding Water-51 133,866 133,454 138,041 Further depletion of water fund reserves,and 133,866 133,454 138,041 need to borrow for Rt 47 work 11 Series 20046-Sanitary SW Autumn Creek Sewer-52 258,650 263,850 368,750 Further depletion of sewer fund reserves, 14 Series 2005D Rob Roy Sewer-52 1,385,950 1,944,450 1,978,050 creating an unsustainable cash-flow 15 Series 2008 Refunding Sewer-52 110,090 110,090 110,090 position for the City. 1,754,690 2,318,390 2,456,890 Would result in new borrowing to fund operations. 18 Series 20056-Library Expansion Library-82 491,125 599,125 632,525 Would directly impact library fund. This debt 19 Series 2006-Library Expansion Library-82 229,675 196,363 139,238 was authorized by referendum. 720,800 795,488 771,763 Spreadsheet E: Non-home rule sales tax considerations Debt# Debt Issue Fund Total Debt Service FY 2012 FY 2013 FY 2014 4 Series 2005A-In Town Rd Prog Phase 1 Debt Service-42 324,179 326,379 328,179 324,179 326,379 328,179 5 Series 2007A Refunding Water-51 133,866 133,454 138,041 133,866 133,454 138,041 11 Series 20046-Sanitary SW Autumn Creek Sewer-52 258,650 263,850 368,750 14 Series 2005D Rob Roy Sewer-52 1,385,950 1,944,450 1,978,050 15 Series 2008 Refunding Sewer-52 110,090 110,090 110,090 1,754,690 2,318,390 2,456,890 Total property tax burden from debt 2,212,735 2,778,223 2,923,110 (except for Library) Expected non-home rule sales tax 500,000 1,500,000 1,500,000 (per fiscal year) Resulting budgetary burden per fiscal year 1,712,735 1,278,223 1,423,110 if we only use non-home rule sales tax to pay bonds Scenario 1 Assumptions: Utilize all non-home rule sales taxes to pay bonds No refinancing Cash borrowing between funds to make payments FY 2012* FY 2013 FY 2014 Percentage reduction in City property taxes for debts: -23% -54% -51% Percentage reduction in total City property tax: -10% -28% -27% Percentage reduction in total tax bill: -1% -3% -3% *Property taxes already levied for FY 12. Reduction in FY 12 is for illustrative purposes only. FY 12 reduction could be used for future debt payments. United City of Yorkville Kendall County, Illinois General Obligation Debt Review-Refunding Analysis Issue Status Issue Status Series 2002 Not Callable Series 20056 Neg.Savings(Call Date 12/30/13) Series 2003 DC Minimal Savings(.8%) Series 2005C Neg.Savings(Call Date 12/30/14) Series 2004A DC Not Callable Series 2006 Neg Savings(Call Date 12/30/16) Series 20046 Neg.Savings(Call Date 12/30/13) Series 2006A DC Neg Savings(Call Date 12/1/16) Series 2004C DC Not Callable Series 2007A Neg Savings(Call Date 12/30/16) Series 2005 Neg.Savings(Call Date 6/1/15) Series 2005A Neg Savings(Call Date 6/30/15) SPEER FINANCIAL, INC. PUBLIC FINANCE CONSULTANTS SINCE 1954 SUITE 4100•ONE NORTH LASALLE STREET•CHICAGO,ILLINOIS 60602• (312)346-3700•FAX(312)346-8833 UNITED CITY OF YORKVILLE Refinancing of Series 2005D and 2008 in 2005 the City issued $11,300,000 Alternate Bonds for a sewer system extension. As development was delayed, some of the payments were refinanced in 2008. With the passage of the safes tax referendum, it is proposed to refinance all of the debt, to extend the payment period and make the debt payments more affordable. The Series 2005D bonds had a 10 year term and an interest rate of 4.15%. The Series 2008 bonds mature in 2016-2017 at a rate of 5.45%. A refinancing of all debt will require a new bond approximately $11,500,000. The size includes all costs related to the transaction and refunds $11,320,000 of existing debt. The sizing will vary depending transaction time and current level of interest rates and amount of property taxes applied to refunding escrow. Alternative A presents a full refinancing in August. A-1 shows a 20 year term, which averages $950,000 annually. A-2 demonstrates a 15 year term, which as annual debt service of some $1,200,000. Alternative B is similar to Alternative A, except that the repayment term is shortened by applying water and sewer funds available beginning 2023, after existing water and sewer debt is repaid. Over the next 12 years, payments reach a high of$1,193,000; some $500,000 is applied in this option. As a result, Alternative B-1 is for a period of 17 years and is $650,000 less expensive that Alternative A-1. Alternative B-2 is for a period of 14 years and is $100,000 less expensive that A-2. Alternative C is an option to refinance only part of the outstanding issues. However, because the bonds are callable in December 2011, this only made economic sense for the 2011 maturity. This option can be applied to any of the other alternatives to result in an added savings of some $10,000. Note that it is important to complete the transaction in the Fall, as this permits the taxes levied for December 2011 debt service to be used for debt service payments on the refunding bonds in June 2012, for which insufficient sales taxes will have been collected. KWMImj 5/16/2011 Alternative:A-1 United City of Yorkville, Kendall County, Illinois Series 2011 Refunds 2005D and 2008 ORIGINAL 20 Year Debt Service Schedule Date Principal Coupon Interest Total P+I 12/30/2011 - - - - 12/30/2012 - - 627,798.48 627,798.48 12/30/2013 505,000.00 1.200% 444,022.50 949,022.50 12/30/2014 510,000.00 1.600% 437,962.50 947,962.50 12/30/2015 520,000.00 2.000% 429 802.50 949 802.50 12/30/2016 530,000.00 2.300% 4I9,402.50 949,402.50 12/30/2017 540,000.00 2.700% 407,212.50 947,212.50 12/30/2018 555,000.00 3.000% 392,632.50 947,632.50 12/30/2019 575,000.00 3.400% 375,982.50 950,982.50 12/30/2020 590,000.00 3.650% 356 432.50 946 432.50 12/3012021 615,000.00 3.850% 334,897.50 949,897.50 12/30/2022 640,000.00 4.000% 311,220.00 951,220.00 12/30/2023 665,000.00 4100% 285,620.00 950,620.00 12/30/2024 690,000.00 4.350% 257,690.00 947,690.00 12/30/2025 720,000.00 4.500% 227,675.00 947,675.00 12/30/2026 755,000.00 4.550% 195,275.00 950,275.00 12/30/2027 790,000.00 4.650% 160,922.50 950,922.50 12/30/2028 825,000.00 4.700% 124,187.50 949,187.50 12/30/2029 865,000.00 4.800% 85,4I2.50 950,412.50 12/30/2030 905,000.00 4.850% 43 892.50 948 892.50 Total 511,795,000.00 - $5,918,040.98 $17,713,040.98 Yield Statistics Bond Year Dollars $140,161.82 Average Life 11.883 Years Average CoEmon 4.2222918% Net Interest Cost IC 4.2896140% True Interest Cost TIC 4.2435351% Bond Yield for Arbitrage Purposes.._ 4.1551146% All Inclusive Cost AIC v 4.3554640% IRS Form 8038 Net Interest Cost _4.2222918% Weighted Average Maturity 11.883 Years Ser 2011 Ref 2005D 2008 2 l SMGLE PURPOSE 1 5/1612011 1 9:41 AM Public Finance Consultants Since 1954 Alternative A-2 United City of Yorkville, Kendall County, Illinois Series 2011 Refunds 2005D and 2008 ORIGINAL 15 Year Debt Service Schedule Date Principal Coupon Interest Total P+l 12/30/2011 - - - 12/30/2012 - - 612,203.28 612,203.28 12/30/20I3 760,000.00 1.550% 432,992.50 1,192,992.50 12/30/2014 770,000.00 1.950% 421,212.50 1,191,212.50 12/30/2015 790,000.00 2.350% 406 197.50 1,196,197.50 12/30/2016 805,000.00 2.650% 387,632.50 1,192,632.50 12/30/2017 825,000.00 3.050% 366,300.00 1,191,300.00 12/30/2018 855,000.00 3.400% 341,137,50 1,196,137.50 12/30/2019 880,000.00 3.750% 312,067.50 1,192,067.50 12/30/2020 915,000.00 4.000% 279,067.50 1,194 067.50 12/30/2021 950,000.00 4.200% 242,467.50 1,192,467.50 12/30/2022 990,000.00 4.500% 202,567.50 1,192,567.50 12/30/2023 1,035,000.00 4.700% 158,017.50 1,193,017.50 12/30/2024 1,085,000.00 4.850% 109,372.50 1,194,372.50 12/30/2025 1 135 000.00 5.000% 56 750.00 1,191,750.00 Total $11,795,000.00 - $4,327,985.78 $16,122,985.78 Yield Statistics Bond Year Dollars $104,911.82 Average Life 8.895 Years Average Coupon 4.1253558% Net Interest Cost(NIC) 4.2152980% True Interest Cost(TIC) 4.1766320% Bond Yield for Arbitrage Purposes 4.0665004% All Inclusive Cost(AIC) 4.3159900% IRS Form 8038 Net interest Cost 4.1253558% Wei hted Average Maturity 8.895 Years Ser 2011 Ref 2005D 20081 1 SINGLE PURPOSE 1 5/1612011 1 9:44 AM � r r .r- 7 Alternative B-1 United City of Yorkville,Kendall County, Illinois Series 2011 Refunds 2005D and 2008 17 Year Debt Service Schedule Date Principal Coupon Interest Total P+I 12/3W011 _ - - - 12/30/2012 - - 614,928.56 614,928.56 12/30/2013 505,000.00 1.200% 434,920.00 939,920.00 12/30/2014 510,000.00 1.600% 428,860.00 938,860.00 12/30/2015 520,000.00 2.000% 420,700.00 940,700.00 12/30/2016 530,000.00 2.300% 410,300.00 940,300.00 12/30/2017 540,000.00 2.700% 398,110.00 938,110.00 12/30/2018 555,000.00 3.000% 383,530.00 938,530.00 12/30/2019 575,000.00 3.400% 366,880.00 941,880.00 12/30/2020 590 000.00 3.650% 347,330.00 937,330.00 12/30/2021 615,000.00 3.850% 325,795.00 940,795.00 12/30/2022 640,000.00 4.000% 302,117.50 942,117.50 12/30/2023 1,200,000.00 4.200% 276,517.50 1,476,517,50 12/30/2024 1,250,000.00 4.350% 226,117.50 1,476,117.50 12/30/2025 1,300,000.00 4.500% 171,742.50 1,471,742.50 12/30/2026 1,380,000.00 4.550% 113,242.50 1,493,242.50 12/30/2027 1,085,000.00 4.650% 50,452.50 1,135,452.50 Total $11,795,000.00 - $5,271,543.56 $17,066,543.56 Yield Statistics Bond Year Dollars _$129,286.82 .Average Life 10.961 Years Average Coupon 4.0774022% Net Interest Cost(NIC) _ 4.1503872% True Interest Cost(TIC) 4.1200831% Bond Yield for Arbitrage Purposes _ -_mm 4.0271722% All Inclusive Cost(AIC) 4.2376425% IRS Form 8038 Net Interest Cost 4.0774022% Weighted Average Maturity _ 10.961 Years Ser 2011 Ref 2005D 2008 1 I SINGLE PURPOSE 1 5116x2011 1 9:50 AM Ell Alternative B-2 United City of Yorkville, Kendall County, Illinois Series 2011 Refunds 2005D and 2008 14 Year Debt Service Schedule Date Principal Coupon Interest Total P+1 12/30/2011 - - - - 12/30/2012 - - 608,58716 608,587.26 12/30/2013 760,000.00 1.550% 430,435.00 1,190,435.00 12/30/2014 770,000.00 1.950% 418,655.00 1,188,655.00 12/30/2015 790,000.00 2.350% 403,640.00 1,193,640.00 12/30/2016 805,000.00 2.650% 385,075.00 1,190,075.00 12/30/2017 825,000.00 3.050% 363,742.50 1,188,742.50 12/30/2018 855,000.00 3.400% 338,580.00 1,193,580.00 12/30/2019 880,000.00 3.750% 309,510.00 1,189,510.00 _1213012020 915,000.00 4.000% 276,510.00 1,191,510.00_ 12/30/2021 950,000.00 4.200% 239,910.00 1,189,910.00 12/30/2022 990,000.00 4,500% 200,010.00 1,190,010.00 12/30/2023 1,605,000.00 4.700% 155,460.00 1,760,460.00 12/30/2024 1,650,000.00 4.850% 80,025.00 1,730,025.00 Total $11,795,000.00 - $4,210,139.76 $16,005,139.76 Yield Statistics Bond Year Dollars _ $103,206.82 Average Life 8.750 Years Average Coupon 4.0793232% Net Interest Cost(NIC) 4.1707513% True Interest Cost(TIC) 4.1374443% Bond Yield for Arbitrage Purposes 4.0261276% All Inclusive Cost AIC 4.2782856% IRS Form 8038 Net Interest Cost _ 4.0793232% Weighted Average Maturity 8.750 Years Ser 2011 Ref 2005D 20681 1 SINGLE PURPOSE 1 5/1612011 1 9:55 AM Speeffinancial, Public • Spreadsheet F: Non-home rule sales tax and refi considerations(20 year refinancing) Debt# Debt Issue Fund Total Debt Service FY 2012 FY 2013 FY 2014 4 Series 2005A-In Town Rd Prog Phase 1 Debt Service-42 324,179 326,379 328,179 324,179 326,379 328,179 5 Series 2007A Refunding Water-51 133,866 133,454 138,041 133,866 133,454 138,041 11 Series 20046-Sanitary SW Autumn Creek Sewer-52 258,650 263,850 368,750 14 Series 2005D Rob Roy Sewer-52 - - - 15 Series 2008 Refunding Sewer-52 - - - 20 Series 2011 Refunding(20 year) Sewer-52 949,022 947,962 949,802 1,207,672 1,211,812 1,318,552 Total property tax burden from debt 1,665,717 1,671,645 1,784,772 (except for Library) Expected non-home rule sales tax 500,000 1,500,000 1,500,000 (per fiscal year) Resulting budgetary burden per fiscal year 1,165,717 171,645 284,772 if we only use non-home rule sales tax to pay bonds Scenario 2 Assumptions: Utilize all non-home rule sales taxes Refinance Rob Roy bonds with new 20 year refi FY 2012* FY 2013 FY 2014 Percentage reduction in City property taxes for debts: -30% -90% -84% Percentage reduction in total City property tax: -22% -35% -34% Percentage reduction in total tax bill: -2% -4% -4% *Property taxes already levied for FY 12. Reduction in FY 12 is for illustrative purposes only. FY 12 reduction could be used for future debt payments.