Loading...
Committee of the Whole Packet 2007 05-01-07 o United City of Yorkville 800 Game Farm Road ESnT -L 1836 Yorkville, Illinois 60560 1 Telephone: 630-553-4350 o� L� a.)Y � p Fax: 630-553-7575 K. COUmy �� <CE AGENDA PUBLIC SAFETY COMMITTEE ADMINISTRATION COMMITTEE COMMITTEE OF THE WHOLE Tuesday, May 1, 2007 7:00 p.m. City Conference Room Public Hearing: None Presentations: None Public Safety Committee: 1. PS 2007-06 Police Reports for April 2007 Administration Committee: 1. ADM 2007-36 Monthly Budget Report for March 2007 2. ADM 2007-37 Monthly Treasurer's Report for March 2007 3. ADM 2007-38 Petty Cash Policy 4. ADM 2007-26 Comp Time Discussion 5. ADM 2007-27 Verification of Driver's Licenses 6. ADM 2007-32 Video Producer Fees Discussion 7. ADM 2007-39 Minute Taker's Hourly Wages 8. ADM 2007-40 Draft Ordinance Providing for the Imposition of a Garbage and Refuse Pick-Up Surcharge Detail Board Report (Bill List): Park Board: 1. No Report. Page 2 Committee of the Whole May 1, 2007 Human Resource Commission: 1. Sponsorship Request for the Optimist Club 2. Approval of Historical Street Names a. Barbra Joan Groesch b. Ralph and Arlene Blake 3. Honorary Street Names —Nomination of Founding Fathers by HRC: Delbert Trummel, Wayne Larson, Russ Hughes, Bill Randels, Dick Mitchell Mayor: 1. No Report. Additional Business: UNITED CITY OF YORKVILLE AGENDA Public Safety Committee Administration Committee COMMITTEE OF THE WHOLE Tuesday, May 1, 2007 7:00 PM CITY CONFERENCE ROOM PUBLIC HEARING: 1. None PRESENTATIONS: 1. None PUBLIC SAFETY COMMITTEE: 1. PS 2007-06 Police Reports for April 2007 ADMINISTRATION COMMITTEE: 1. ADM 2007-36 Monthly Budget Report for March 2007 2. ADM 2007-37 Monthly Treasurers Report for March 2007 3. ADM 2007-38 Petty Cash Policy 4. ADM 2007-26 Comp Time Discussion 5. ADM 2007-27 Verification of Driver's Licenses 6. ADM 2007-32 Video Producer Fees Discussion 7. ADM 2007-39 Minute Taker's Hourly Wages 8. ADM 2007-40 Draft Ordinance Providing for the Imposition of a Garbage and Refuse Pick-Up Surcharge DETAIL BOARD REPORT BILL LIST): PARK BOARD: 1. No Report HUMAN RESOURCE COMMISSION: 1. Sponsorship Request for the Optimist Club 2. Approval of Historical Street Names a. Barbra Joan Groesch b. Ralph and Arlene Blake 3. Honorary Street Names—Nomination of Founding Fathers by HRC: Delbert Trummel, Wayne Larson, Russ Hughes, Bill Randels, Dick Mitchell MAYOR: 1. No Report ADDITIONAL BUSINESS: ♦,��0 CO. Reviewed By: Agenda Item Number Ja 4 DT Legal ❑ u Finance ❑ 1836 Engineer ❑ City Administrator El Tracking Number pl ''20 Consultant ❑ 06 < E `�♦, El k City Council Agenda Item Summary Memo Title: Police Reports for April 2007 City Council/Committee of the Whole Date: COW 5/2/07 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Chief Harold O. Martin III Police Name Department Agenda Item Notes: March 26, 2007 Dear Officer Groesch- Thank you so much for taking our Daisy Troop #291 through the Yorkville Police Station on March 12. We had a lot of fun seeing the whole station, and meeting so many people - including the Police Chief! We appreciate your time in teaching us about how the police do their jobs. We also loved the extra stickers, badges and Pez dispensers you gave to each of us! Sho �9 Best re nrds �I�Ixawo Daisy Troop #291, Gemini Service Unit Girl Scouts Fox Valley Council 10 04%Cv e%NL� L a �eo r) Irwo + Ib PO Ka� A � r vrxvt ctc rVIc cc %U coo Ve WdAt 7� md�A wou T i if ri was t u �' s G Car Wks NM pouce t � c 9 i > r t vt a ..w P • en on All f Liquor icense Holders* The Yorkville Police Department will be offering a course on: ALCOHOL SELLER & SERVER EDUCATION TRAINING Officer Barry Groesch will be teaching this course on Thursday, May 10, 2007 from 2:00pm to 10:00pm at the Yorkville Middle School, 702 Game Farm Road, Yorkville. Dinner will be served at the training. This course if offered FREE OF_CHAR GE! ; Please contact Officer Barry Groesch at 630-553-8511 to reserve a spot. Please be sure to leave the business name, employee name and contact number. -_ ,? a 0 EST. 1836 SCE YORKVILLE POLICE DEPARTMENT Harold O. Martin lll, Chief of Police 804 Game Farm Road I Yorkville, Illinois 60560 Phone: 630-553-4340 1 Fax: 630-553-1141 Date: April 4, 2007 To: Chief Harold O. Martin III From: S/Sergeant Ron Diederich Reference: Monthly Mileage Report During the month of March 2007, the Yorkville Police Department logged a total of 29,144 miles. Individual squad miles are: Monthly Currey Reassign/ Squad Vehicle Squad Usage miles 11es Replace Date M-1 2006 Dodge Charger Patrol/K-9 1,991 11,854 2009/2010 M-2 2006 Chevrolet Impala Chief 2,259 'I7,499'; 2011/2012 M-3 1998 Ford Crown Victoria Detective 386 4 1411,l't2 2006/2007 M-4 2002 Chevrolet Impala Police Cadet 1,432 „ 9U8,6: 2006/2007 M-5 1998 Ford Crown Victoria Administration 0 A40,165 M-6 2003 Chevrolet Impala Lieutenant 587 1107 2007/2008 M-7 2001 Ford Crown Victoria DARE 068,14 2009/2010 M-8 2004 Ford Crown Victoria Patrol 27237,54$ 2007/2008 M-9 2000 Ford Crown Victoria Lieutenant 821 79,167; 2008/2009 M-10 1991 Ford Thunderbird DARE 3454, 31', _ _ 2004/2005 M-10 2006 Chevrolet Impala Patrol 2,123 =13,60fD:" 2009/2010 M-11 2003 Ford Crown Victoria YHS—SRO 968 2009/2010 M-12 1999 Ford Expedition Operations 588 71,,439 , .. 2007/2008 M-13 2001 Ford Crown Victoria Patrol/K-9 2,015 ,84, 2010/2011 M-14 2003 Ford Crown Victoria Patrol Sergeant 1,384 2005/2006 M-15 2004 Ford Crown Victoria Patrol/K-9 1,561 ° 1,576: 2008/2009 M-16 2004 Ford Expedition Patrol Sergeant 1,022 65,70381 , , „ . 2008/2009 M-17 2004 Chevrolet Im ala Detective 593 ,924 2014/2015 M-18 2005 Chevrolet Impala Patrol 1,577 8,771 2008/2009 M-19 2005 Chevrolet Impala Patrol 1,395 37;936_ 2008/2009 M-20 2005 Chevrolet Tahoe Patrol/Trucks 990 2011/2012 M-21 2007 Ford Crown Victoria Patrol 2,294 12,691; 2009/2010 M-22 2007 Ford Crown Victoria Patrol 2,043 (1,323; ,,,. „ 2009/2010 M-23 2007 Ford Crown Victoria Patrol 2,498 X6,593 �'.,' 2009/2010 S/Sgt. Ronald E. Diederich #203 Yorkville Police Department - Overtime Manhour Utilization Report - 04-14-07 Date Court Training Relief Details Admin Emerg Invest Cam Sery Full Time Part Time 05 13 06 2.00 0.00 1.00 11.00 0.00 0.00 27.50 6.00 47.50 70.00 05 27 06 2.50 22.00 0.00 24.00 0.00 0.00 16.50 2.00 67.00 120.75 06/10 06 14.00 3.00 0.00 32.00 7.00 0.00 6.25 0.00 62.25 98.00 06 24 06 7.50 0.00 18.50 6.00 0.00 0.00 4.00 0.00 36.00 102.00 07 OS 06 4.00 6.00 0.00 12.00 3.00 0.00 6.00 0.00 31.0_0 128.75 07 22 06 4.00 0.00 10.00 12.00 16.00 0.00 7.00 7.00 56.00 122.75 08/05/06 14.00 0.00 14.00 0.00 0.0_0 5.50 9.75 _4.00 _4_7.2_5 64.00 08 19 06 14.50 0.00 36.00 44.50 6.50 0.00 13.75 0.00 115.25 100.75 09/02/06 9.00 0.00 2.00 33.00 0.00 0.00 3.50 0.00 47.50 83.50 09 16 06 8.00 0.00 0.00 35.50 2.00 0.00 15.50 0.00 61.00 113.25 09/30/06 2.25 0.00 0.00 6.50 8.00 0.00 13.00 6.00 35.75 135.75 J06 8.00 8.00 3.00 34.50 0.00 0.00 82.00 0.00 135.50 103.50 10 28 06 12.50 2.00 3.00 0.00 9.00 0.00 38.50 5.00 70.00 139.00 11/11 06 15.50 0.00 5.00 0.00 0.00 0.00 70.50 5.00 96.00 199.50 11 25 06 5.50 7.50 8.50 0.00 0.00 0.00 13.50 0.00 35.00 118.50 12/09/06 11.00 8.00 0.00 10.00 6.00 0.00 15.75 4.00 54.75 111.75_ 12 23 06 4.50 0.00 0.00 46.00 0.00 2.00 25.00 0.00 77.50 136.75 01 06 07 9.25 0.00 0.00 191.25 2.00 0.00 6.25 0.00 208.75 183.00 01/20 07 0.00 0.00 0.00 21.00 2.00 0.00 15.50 0.00 38.50 206.00 02 17 07 2.00 0.00 8.00 3.50 0.00 0.00 2.00 0.00 15.50 111.50 03 03 07 6.00 0.00 0.00 8.00 0.00 6.50 24.50 0.00 45.00 121.50 03 17 07 4.00 0.00 0.00 0.00 2.00 0.00 1.50 0.00 7.50 100.00 03L3y0,_7 10.00 0.00 19.00 4.00 19.00 0.00 20.50 3.00 7_5_.50 134.25 04114107 6.00 0.00 0.00 7.00 0.00 0.00 3.50 10.00 26.50 100.00 0.00 0.00 FY05-06 Court Trainina Relief Details Admin Emera Invest Cam Sery Full Time Part Time Totals 176.00 56.50 128.00 541.75' 82.50 14.00 441.75 52.00 1492.50 2904.75 Percents 12% 4% 9% 36% 6% 1% 30% 3% 100% N/A Average 7.33 2.35 5.33 22.57 3.44 1 0.58 18.41 2.17 57.40 121.03 LAST YEAR'S STATISTICS FOR MANHOUR UTILIZATION FY04-05 Court Trainina Relief Details Admin Emerq invest Cam Sery Full Time Part Time Totals 125.00 79.25 231.50 , 299.00" 88.25 14.00 377.00 113.50 1327.50 1867.00 Percents 9% 6% 17% 23% 7% 1% 28% 9% 100% N/A Avera a 4.81 3.OS 8.90 11.50 3.39 0.54 14.50 4.37 51.06 71.81 Prepared by Molly Batterson 4/16/2007 Pagel Yorkville Police Department Offense Report -March 2007 r y Arson 0 1 0 0 0 0 0 _0 0 0 1 0 0 0 0 Assault 2 0 0 0 0 1 0 1 4 1 , 11 0 0 3 3 Battery 10 7 12 8 8 9 15 9 13 9 123 15 14 14 43 Burglary 4 5 2 1 12 20 21 14 8 8 118 5 11 6 22 _Cannabis Offenses 5 1 _2 2 _2 _0 3 2 1 2 29 1 5 1_ 7 Controlled Substance Offenses 0 0� 1 0 0 1 0 1 0 0 7 0 1 0 1 Crimes Involving Children 5 0 3 1 3 4 5 2 1 2 34 5 0 2 7 Criminal Damage 15 14 13 13 16 35 26 17 28 25 222 19 22 9 50 De__ceptive Practices 1 5 4 2 5 5 7 1 6 7_ 54 12 9 8 29 Drug Paraphernalia Offenses 5 1 3 0 1 1 1 3 2 4 32 2 3 2 7 Firearms Offenses 1 0 0 0 0 1 2 1 2 0 8 0 0 0 0 Gambling Offenses 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Kidna in 1 0 1 2 0 0 2 0 0 0 7 0 0 0 0 Liquor Offenses 7 4 2 3 5 2 2 3 6 11 56 2 0 3 5 Murder 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Robbery 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 Sex Offenses 0 0 1 0 0 0 0 0 2 1 10 1 0 1 2 Theft 10 19 11 18 20 18 22 32 18 12 204 15 10 14 39 All Other Criminal Offenses 15 20 24 19 28 21 14 17 17 22 240 17 24 23 64 Drivin Under The Influence 9 0 2 2 5 5 6 4 5 2 53 4 1 11 16 License/Re istration Violations 74 49 28 37 47 31 38 27 47 53 591 54 31 31 116 Seatbelt Citations 19 29 54 39 15 3 9 10 4 5 224 7 7 12 26 Seatbelt Warnings 24 24 18 1 0 10 9 17 14 7 19 157 5 5 3 13 Speeding Citations 53 28 32 43 60 51 60 77 151 135 791 71 48 136 255 Speeding Warnings 54 36 33 48 34 30 45 56 66 83 610 0 0 51 51 Transportation of Alcohol 2 2 1 0 3 2 2 0 0 5 18 1 1 1 3 Uninsured Motor Vehicle 57 44 30 40 40 30 41 25 56 50 529 47 40 49 136 'X't�talititiils i� te�d _ ...... 1 ` =t9Z 212 . llr; 3" ,. 5; ... � 43 - 5 2 '11 Tdta1 Verb i Warnin 'I , 0 Al 0 ry 2 . ,. Totaf,W ritten Wair10h ,,16 laced ti.;., S97 X94 :278 . X19 ;X73 276 27� 22 2 88', ,34'i``' 40 3, "3275 243 NOW Hit and Run Accident 9 2 7 2 3 7 4 4 6 9 59 4 3 5 12 Property Damage Accident 34 22 39 31 37 31 31 29 50 43 392 38 33 34 105 Personal Injury Accident 6 3 2 2 4 5 5 4 4 5 42 5 3 0 8 �i4 4 ' .. 0 493 , 47";: 39 **Unlawful Visitation Interference is reported under the Kidnapping Section of the Illinois Uniformed Crime Reporting system. The Kidnapping line item includes this offense in its totals. Yorkville Police Department Manhour Report - March 2007 Accidents 32.42 18.75 26.58 26.42 29.25 34.80 26.00 32.75 37.33 41.02 36.00 26.25 26.42 Administrative Activity 403.75 357.42 270.92 440.67 376.75 542.00 596.00 737.25 624.25 415.00 343.58 309.67 366.58 Animal Complaints 3.50 5.671 6.67 6.00 4.171 3.92 6.50 7.921 7.50 4.75 6.67 5;251 6.42 Arrest Activity 46.53 30.83 28.33 22.92 32.75 19.80 27.00 25.67 33.83 32.83 33.50 30.83 36.50 Assist Agencies 180.50 139.67 154.58 179.17 192.72 183.25 172.03 241.17 196.18 177.23 214.50 191.23 187.33 Community Relations 37.42 49.50 36.83 38.58 45.33 30.58 36.25 27.83 41.92 25.73 29.92 13.33 42.08 Departmental Duties 163.67 171.58 138.92 120.08 118.92 125.75 140.58 174.33 169.92 215.88 178.73 130.50 115.58 Investigations 58.83 24.83 18.17 10.00 36.92 37.08 29.25 15.75 35.22 42.83 41.42 78.83 12.33 Ordinance/Traffic Violations 179.92 101.25 94.58 82.67 94.77 90.67 106.33 69.33 129.37 98.58 87.70 64.98 78.50 Personnel Activity 540.75 581.08 616.50 713.83 635.92 759.08 606.42 826.42 640.20 898.50 664.67 552.75 591.20 Preventive Patrol 764.00 741.50 669.58 725.30 654.87 674.17 810.47 712.72 814.50 908.10 911.07 767.88 775.90 Public Complaints 90.75 99.17 95.67 103.92 124.00 126.33 147.92 129.75 87.03 138.10 96.42 108.40 118.25 Public Services 35.17 28.00 63.33 41.92 40.33 46.42 43.00 36.931 46.67 55.07 44.50 60.00 41.58 Report Activity 222.58 179.83 159.75 155.75 175.33 236.75 245.83 236.75 222.58 208.50 203.58 196.25 216.42 School Activity 189.83 88.33 143.58 7.75 0.00 30.25 91.42 122.68 79.25 13.00 0.00 2.17 0.00 Traffic Activity 386.67 233.92 231.001 308.92 291.831 271.08 254.67 271.35 303.43 278.67 303.501 266.42 289.00 Training 130.33 150.58 192.921 209.42 108.251 90.831 166.50 163.17 187.50 89.67 118.25 197.08 301.67 MR Canine Officers/Training 346.66 346.66 346.66 Chie 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 Community Programs Director N/A N/A N/A 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 CPAT Officer 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 173.33 Crossing Guards(In Days) 61.50 40.50 66.00 6.00 0.00 12.00 40.00 41.50 51.00 55.50 80.00 74.00 68.00 Detectives 519.99 519.99 519.99 346.66 346.66 346.66 346.66 346.66 346.66 346.66 346.66 346.66 346.66 Lieutenants 173.33 173.33 173.33 346.66 346.66 346.66 346.66 346.66 346.66 346.66 346.66 346.66 346.66 Office&Records Supervisor 173.33 173.33 259.99 346.66 346.66 346.66 346.66 346.66 346.66 346.66 346.66 346.66 346.66 Records Clerks 346.66 346.66 259.99 173.33 173.33 173.33 173.33 173.33 333.33 346.66 346.66 346.66 346.66 School Resource Officers ----- ----- ----- ----- ----- ----- ----- ----- 173.331 346.66 346.66 346.66 346.66 3 Yorkville Police Department Incident Report Summary Page 1 of 3 March 27, 2007 through April 19, 2007 070792 through 071007 E Accidents Canine Training Sessions (continued) 070799..........03-27-07..............Route 34/Countryside Pky 070923 ......... 04-11-07 070809..........03-28-07..............Route 34/Cannonball Trail 070924 .........04-11-07 070829..........03-30-07..............Countryside/McHugh Rd 070931 .........04-12-07 070830..........03-30-07.............. 1300 Blk. Game Farm Rd 070933 .........04-12-07 070852..........04-02-07.............. 100 Blk.W.Somonauk St 070938 .........04-12-07 070855..........04-02-07..............Route 71/Route 47 070968 .........04-16-07 070883..........04-06-07..............Route 34/Autumn Creek 070974 ......... 04-16-07 070906..........04-09-07..............Route 47/Elizabeth Street 070981 .........04-17-07 070909..........04-09-07..............Route 47/Van Emmon St 070987 .........04-18-07 070925..........04-11-07..............Route 126/Route 71 070989 .........04-18-07 070927..........04-11-07..............Route 34/Route 47 070999 .........04-19-07 070932..........04-12-07..............Route 47/Route 71 071001 .........04-19-07 070977..........04-16-07..............Rout e47/Countryside Pky 071003 .........04-19-07 070992..........04-18-07..............Route 47/Fox Street 071007..........04-19-07..............0 Blk.W.Veterans Parkway Citizen Assist(Civil/Keep the Peace/etc.) 070853 ......... 04-02-07..............300 Blk. E.Washington St Aggravated Assault 070870 .........04-04-07..............200 Blk. Hillcrest Avenue 070888..........04-06-07..............200 Blk. S.Bridge Street 070884 .........04-06-07..............Desk Report 070886 .........04-06-07..............Route 47/Corneils Road Assist Business Agencies 070904 .........04-09-07..............2000 Blk. Muir field Drive 070935 .........04-12-07..............2300 Blk. Iroquois Lane Assist Law Enforcement/Fire/Ambulance Agencies 070957 .........04-14-07..............600 Blk. N.Bridge Street 070800..........03-27-07..............400 Blk. Bristol Bay Drive . 070803..........03-28-07..............600 Blk. Tower Lane . Criminal Damage to Property 070919..........04-10-07..............1300 Blk. Game Farm Rd 070811 .........03-28-07..............500 Blk. Redbud Drive 070945..........04-13-07..............300 Blk. Garden Circle 070860 .........04-03-07..............500 Blk. Powers Court 070962..........04-15-07..............0 Blk. Highview Drive 070865 ......... 04-04-07..............2700 Blk. Goldenrod Drive 070967..........04-15-07..............2800 Blk. Old Glory Drive 070869 .........04-04-07..............300 Blk.Walter Street 070951 .........04-14-07..............900 Blk. Morgan Street Assist Schools 070972 ......... 04-16-07..............700 Blk. E.Veterans Pkwy 070939..........04-12-07..............3100 Blk. Grande Trail 070988 ......... 04-18-07..............300 Blk. Mulhern Court 071000 .........04-19-07..............700 Blk. Game Farm Road Batteries 070833..........03-31-07..............300 Blk.Windett Ridge Rd Criminal Sexual Assault 070850..........04-02-07..............2700 Blk. N.Bridge Street 071006..........04-19-07..............300 Blk. E.Veterans Pkwy Criminal Trespass to Property 070841 ......... 04-01-07..............6700 Blk. Route 47 Canine Training Sessions 070793..........03-27-07 Disorderly Conduct 070796..........03-27-07 070940 ."*...... 04-11-07..............700 Blk. Game Farm Road 070804..........03-28-07 070955 .........04-14-07..............Walsh Dr/Burning Bush Dr 070805..........03-28-07 070963 .........04-15-07..............500 Blk. S.Bridge Street 070814..........03-29-07 070815..........03-29-07 Domestic Battery 070823..........03-30-07 070846 .........04-01-07..............2900 Blk. Ellsworth Drive 070825..........03-30-07 070851 .........04-01-07..............2200 Blk. Beresford Drive 070849..........04-02-07 070878 .........04-06-07..............200 Blk. River Street 070857..........04-03-07 070892 .........04-07-07..............1300 Cannonball Trail 070864..........04-04-07 070922 .........04-11-07..............1300 Blk.Willow Way 070873..........04-05-07 070949 ......... 04-14-07..............500 Blk.W.Hydraulic Ave 070874..........04-05-07 070879..........04-08-07 Domestic Trouble 070903..........04-09-07 070832 .........03-31-07..............100 Blk. S.Bridge Street 070915..........04-10-07 070837 .........03-31-07..............1800 Blk. Country Hills Dr 070917..........04-10-07 070838 .........03-31-07..............1300 Blk. Cannonball Trail �2 gD C/ryr Yorkville Police Department Incident Report Summary Page 2 of 3 March 27, 2007 through April 19, 2007 070792 through 071007 �E Domestic Trouble (continued) Lockouts/Motorist Assists (continued) 070843..........04-01-07..............Desk Report 070895 ......... 04-07-07 070914..........04-10-07.............. 1000 Blk. Dalton Avenue 070898 .........04-07-07 070934..........04-12-07..............300 Blk. Mulhern Court 070899 .........04-07-07 070950..........04-14-07..............2100 Blk. Muirfled Court 070900 ......... 04-08-07 070960..........04-14-07.............. 1400 Blk. Aspen Lane 070901 ......... 04-08-07 070964..........04-15-07..............300 Blk. Mulhern Court 070911 .........04-09-07 070965..........04-15-07..............300 Blk. Mulhern Court 070920 .........04-10-07 070921 .........04-10-07 DUI's 070928 ......... 04-11-07 070820..........03-29-07..............Route 34/Sycamore Road 070936 .........04-12-07 070942 .........04-13-07 Fights/Riots/Brawls 070946 ......... 04-13-07 070953 ......... 04-14-07 Fraud/Deceptive Practices/Forgeries 070966 .........04-15-07 070912..........04-09-07..............Desk Report 070969 .........04-16-07 070952..........04-14-07..............300 Blk. E.Veterans Pkwy 070970 ......... 04-16-07 070985..........04-17-07..............2500 Blk. Alan Dale Lane 070971 ......... 04-16-07 071005..........04-19-07..............500 Blk. Madison Street 070978 .........04-16-07 070980 .........04-16-07 Harassing Phone Calls 070982 .........04-17-07 070817..........03-29-07..............200 Blk. E.Kendall Drive 070983 ......... 04-17-07 070907..........04-09-07.............. 100 Blk. E.Schoolhouse 070990 ......... 04-18-07 070910..........04-09-07.............. 100 Blk. E.Schoolhouse 070991 .........04-18-07 070984..........04-17-07..............Desk Report 070993 .........04-18-07 070994 ......... 04-19-07 Intimidation 070995 .........04-18-07 070801 ..........03-27-07..............2000 Blk. Muirfield Drive 071004 .........04-19-07 Juvenile/Runaway Lost/Found Articles 070913..........04-10-07..............300 Blk. Windham Drive 070797 .........03-27-07 070810 .........03-28-07 Lockouts/Motorist Assists 070818 ......... 03-27-07 070794..........03-27-07 070854 .........04-02-07 070795..........03-27-07 070856 .........04-03-07 070798..........03-27-07 070897 .........04-07-07 070806..........03-28-07 070943 ......... 04-13-07 070807..........03-28-07 070979 .........04-16-07 070808..........03-28-07 070997 .........04-19-07 070812..........03-28-07 070998 ......... 04-19-07 070813..........03-29-07 071002 .........04-19-07 070822..........03-30-07 070826..........03-30-07 Mandatory Supervised Release Notifications 070828..........03-30-07 070816 .........03-29-07..............Desk Report 070831 ..........03-30-07 070836 .........03-21-07..............Desk Report 070834..........03-31-07 070835..........03-31-07 Mischievous Conduct 070840..........04-01-07 070844..........04-01-07 Neighborhood Trouble 070845..........04-01-07 070861.......:..04-04-07 Other Public Complaints 070867..........04-04-07 070819 .........03-29-07..............100 Blk. Colonial Parkway 070871 ..........04-05-07 070842 ......... 04-01-07..............0 Blk.W.Countryside Pkwy 070872..........04-05-07 070859 .........04-03-07..............Parkside Ln/Hartfield Ave 070887..........04-06-07 070944 .........04-13-07..............8200 Blk. Shadow Creek 070893..........04-07-07 070954 ......... 04-14-07..............500 Blk. Parkside Lane Yorkville Police Department Incident Report Summary Page 3 of 3 March 27, 2007 through April 19, 2007 070792 through 071007 Other Public Service Thefts/Burglaries (continued) 070821 ..........03-30-07.............. 1400 Blk. Cannonball Trail 070986 ......... 04-17-07..............2000 Blk. S.Bridge Street 070937..........04-13-07..............800 Blk. Morgan Street Towed Abandoned Vehicle Possession of Alcohol by Minor 070929 .........04-11-07..............400 Blk. E.Main Street Possession of Cannabis Warrant Arrests 070882..........04-06-07.............. Route 71/Sleepy Hollow 070802 .........03-27-07..............100 Blk. Appletree Court 070877 .........04-05-07..............1400 Blk. N.Bridge Street Possession of Drug Paraphernalia 070902 .........04-08-07..............100 Blk. Colonial Parkway 070996 .........04-18-07..............1300 Blk. Marketplace Dr Possession of Illegal Weapon 070973..........04-16-07..............700 Blk. Game Farm Road Reckless Driving 070956..........04-17-07:.............Route 47/Carpenter Street Sex Offender Registration 070827..........03-30-07..............Desk Report 070918..........04-10-07..............Desk Report 070975..........04-16-07..............Desk Report Suspended/Revoked Licenses/Invalid License Arrests 070792..........03-27-07..............Route 34/Game Farm Rd 070839..........04-01-07..............Route 47/Route 34 070863..........04-04-07..............Route 47/Route 34 070866..........04-04-07..............Route 47/Cannonball Trail 070868..........04-04-07..............Galena Road/E.Beecher 070889..........04-07-07..............Route 47Center Street 070890..........04-07-07..............Cannonball Trail/Route 47 070896..........04-07-07..............Cannonball Trail/Route 34 070926..........04-11-07..............Route 47/Route 71 070930..........04-12-07..............Route 47/Greenbriar Road 070941 ..........04-13-07..............Galena Road/Route 47 070948..........04-13-07..............Route 34/Route 47 070958..........04-14-07..............Route 71/High Point Road 070959..........04-14-07..............Route 71/Sleepy Hollow Suspicious Circumstances 070961..........04-14-07.............. 1400 Blk. Cannonball Trail Thefts/Burglaries 070824..........03-30-07..............700 Blk. Game Farm Road 070847..........04-01-07.............. 1900 Blk. Route 34 070858..........04-03-07.............. 100 Blk. Commercial Drive 070875..........04-05-07.............. 1000 Blk. Hampton Lane 070876..........04-05-07..............200 Blk. E.Veterans Pkwy 070880..........04-06-07..............400 Blk. Fairhaven Drive 070881 ..........04-06-07..............2000 Blk. S.Bridge Street 070885..........04-06-07..............400 Blk. W.Washington St 070891 ..........04-07-07.............. 100 E.Schoolhouse Road 070894..........04-07-07.............. 1400 Blk. N.Bridge Street 070905..........04-09-07..............200 Blk. Faxon Road 070908..........04-09-07.............. 100 Blk. Colonial Parkway 070947..........04-13-07..............700 Blk. Game Farm Road 070976..........04-16-07.............. Desk Report Reviewed By: ❑ City Council Legal Finance ❑ rn EST. ,,1836 Engineer ❑ Agenda Item Tracking Number G o, ,� ;� City Administrator ❑ '" M ` `�O Consultant ❑ J'� �[��" CLE, 1V� City Council Agenda Item Summary Memo Title: March Budget Report City Council/Committee of the Whole Date: COW 5/1/07 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Jennifer Milewski Finance Name Department Agenda Item Notes: FISCAL YTD FISCAL YEAR FISCAL YTD FUND PAGE#ACCOUNT NUMBER DESCRIPTION ACTUAL BUDGET ACTUAL% EXPLANATION OF%OVERAGE ADMIN 3 01-110-50-00-5137 OVERTIME 3,690.92 3,600.00 102.5 Staftagesi Research for current audit findings ADMIN 4 01-110-62-00-5421 WEARING APPAREL 28.00 28.00 100 Adjusted with budget review,spending completed for year ADMIN 4 01-110-62-00-5436 TELEPHONE 15,733.79 15,000.00 104.8 Increase in monthly usage ADMIN 4 01-110-62-00-5437 ACCTG SYSTEM SERVICE FEE 9,652.00 9,652.00 100 Increase in modules ADMIN 4 01-110-64-00-5600 DUES 5,116.75 5,000.00 102.3 Annual Membership Dues to various organization ADMIN 4 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 900.00 900.00 100 Increase in participants ADMIN 4 01-110-64-00-5604 TRAINING&CONFERENCES 19,047.69 18,508.00 102.9 Pre-paid training classes ADMIN 4 01-110-64-00-5606 PROMOTIONAL/MARKETING EXPENSE 2,276.67 577.00 394.5 Flyers Posters and Brouchers for upcoming events ADMIN 4 01-110-65-00-5800 CONTINGENCIES 561,015.09 560,015.00 100.1 Expenditure per dept head request. ADMIN 5 01-110-65-00-5804 OPERATING SUPPLIES 13,242.55 12,450.00 106.3 Finance Director will inform staff to seek approval before further spending ADMIN 5 01-110-72-00-6501 SOCIAL SECURITY&MEDICARE 54,944.76 51,151.00 107.4 Increase in employees&overtime ADMIN 5 01-110-78-00-9003 SALES TAX REBATE 513,768.11 500,000.00 102.7 Sufficent funds not budgeted ENGINEERING 6 01-150-62-00-5401 CONTRACTUAL SERVICES 76,444.54 53,000.00 144.2 No response from Department Head POLICE 8 01-210-62-00-5410 MAINT-OFFICE EQUIPMENT 2,625.00 2,625.00 100 Fumiture needed for new employees POLICE 8 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 6,117.35 6,000.00 101.9 Additional unanticipated maintenance was needed for one of the sirens. POLICE 8 01-210-62-00-5423 CLASY GRANT 1,000.00 1,000.00 100 Senior Police Academy/Increased community programs POLICE 9 01-210-64-00-5609 POLICE RECRUIT ACADEMY 15,712.12 10,500.00 149.6 Planned testing active hiring of patrol officers PLANNING&DEV. 10 01-220-62-00-5432 ECONOMIC DEVELOPMENT 45,000.00 45,000.00 100 Annual Payment to YEDC STREETS"- 12 01-410-62-00-5409 MAINTENANCE-VEHICLE 15,732.47 15,000.00 104.8 Unexpected repairs on vehicles,will need to adjust with budget review STREETS 12 01-410-62-00-5414 MAINTENANCE-TRAFFIC SIGNALS 18,438.33 18,000.00 102.4 Will adjust.We state pay back STREETS 12 01-410-62-00-5435 ELECRICITY 61,258.90 60,000.00 102 Increase in street lights and increase in electricty costs STREETS 12 01-410-75-00-4404 HANGING BASKETS 2,242.18 2,442.00 100 Offset by donations in revenue line item STREETS 12 01-410-75-00-5418 MOSQUITO CONTROL 28,414.00 28,414.00 100 Additional rainfall and manholes required additional abatement HEALTH&SAN. 13 01-540-62-00-5443 LEAF PICKUP 5,232.00 5,232.00 100 Adjust with mid year budget adjustments.Done for year MOTOR FUEL TAX 14 15-000-65-00-5818 SALT 63,801.46 60,000.00 106.3 Will fix with MFT audit PUBLIC WORKS CAP 20 21-000-75-00-7015 SKIDSTEER UPGRADE 4,500.00 4,500.00 100 One time cost SANITARY IMPROV. 24 37-000-62-00-5402 ENG/LGL/CONTINGNCY-COUNTRYSIDE 31,663.36 0.00 100 Payments made to contractors as construction progresses. SANITARY IMPROV. 24 37-000-62-00-5405 ENG/GLG/CONTINGENCY-BRUELL ST -5.50 0.00 100 Account closed SANITARY IMPROV. 25 37-000-75-00-7503 COUNTRYSIDE INTERCEPTOR 22,587.52 0.00 100 Funding of projects begun in a previous fiscal year. SANITARY IMPROV. 25 37-000-75-00-7505 ROB ROY CREEK SANITARY 4,159,610.10 3,130,000.00 132.8 Expenses based on actual construction costs,and funded by bond revunue. WATER IMPROV. 27 41-000-61-00-5301 ENGINEERING-GENERAL SERVICES 1,120,871.16 20,000.00 5604.3 Seperating contracts B.1,B.2,&8.3 and will adjust with budget review WATER IMPROV. 27 41-000-61-00-5402 ENGINEERING-SW H2O PROJECT 233,296.46 165,000.00 141.3 SW water improvements WATER IMPROV. 28 41-000-61-00-5410 ENGINEERING-CENTRAL ZONE C 11,206.97 10,000.00 112 Funding of projects begun in a previous fiscal year. WATER IMPROV. 28 41-000-61-00-5418 F6 GREENBRIAR ROAD EXTENSION 13,198.75 0.00 100 New project per SW annexation agreements-developer funded WATER IMPROV. 28 41-000-61-00-5420 F8 FOX ROAD RESURFACE 15,008.50 0.00 100 New project per SW annexation agreements-developer funded WATER IMPROV. 28 41-000-61-00-5421 F9 PAVILION ROAD 54,808.32 0.00 100 New project per SW annexation agreements-developer funded WATER IMPROV. 28 41-000-61-00-5422 DRAINAGE STUDY 34,986.75 0.00 100 New project per SW annexation agreements-developer funded WATER IMPROV. 28 41-000-65-00-5421 GIS SYSTEM 8,465.28 5,000.00 169.3 GIS account used to partially fund Gawne Ln.watermain design engineering. WATER IMPROV. 28 41-000-75-00-7504 NORTH WATER TOWER-CONTRACT A 4,817.75 0.00 100 Should have been budgeted DEBT SERVICES 30 42-000-66-00-6001 CITY HALL BONDS-PRINCIPAL PMT 50,000.00 50,000.00 100 Payment of debt cert. DEBT SERVICES 30 42-000-66-00-6003 IRBB-BRUELL ST INTEREST PMTS 83,795.00 83,795.00 100 Payment of debt cert. DEBT SERVICES 30 42-000-66-00-6004 IRBB-BRUELL ST PRINCIPAL PYMT 80,000.00 80,000.00 100 Payment of debt cert. DEBT SERVICES 30 42-000-66-00-6006 NORTH H2O TOWER PRINCIPAL PYMT -374.00 22,169.00 -1.6 Adjustment made DEBT SERVICES 30 42-000-66-00-6007 4.8 MILLION DEBT CER INT PYMT 233,150.00 233,150.00 100 Payment of debt cert. DEBT SERVICES 30 42-000-66-00-6008 COUNTRYSIDE ALT REV PRINC PYMT 125,000.00 125,000.00 100 Payment of debt cert. DEBT SERVICES 30 42-000-66-00-6009 COUNTRYSIDE ALT REV INT PYMT 118,012.00 117,638.00 100.3 Payment of debt cert. DEBT SERVICES 30 42-000-66-00-6010 COMED/HYDRAULIC INTEREST PMT 41,328.00 41,328.00 100 Payment of debt cert. DEBT SERVICES 30 42-000-66-00-6011 COMED/HYDRAULIC CERT.PRINC 140,000.00 140,000.00 100 Payment of debt cert. DEBT SERVICES 30 42-000-66-00-6049 SANITARY SIPHON INTEREST PMT 8,301.00 8,301.00 100 Payment of debt cert. DEBT SERVICES 30 42-000-66-00-6055 LOAN PAYMENT-SSES IEPA L171153 107,050.70 75,775.00 141.2 Payment of debt cert. DEBT SERVICES 30 42-000-66-00-6070 $650K ROAD IMPROV PROG INT 26,070.00 26,070.00 100 Payment of debt cert. DEBT SERVICES 30 42-000-66-00-6071 $650K ROAD IMPROV PROG PRINC 65,000.00 65,000.00 100 Payment of debt cert. DEBT SERVICES 30 42-000-66-00-6072 $2 Mil Alt Rev B.2&3 INT PMT 234,139.38 97,923.00 239.1 Sufficent funds not budgeted WATER OP. 34 51-000-66-00-8200 INTEREST EXPENSE -30,050.00 0.00 100 Audit entry SEWER MAINT. 37 51-000-65-00-5812 GASOLINE 16,330.06 16,000.00 102 Adjust at year end SEWER MAINT. 37 52-000-66-00-8200 INTEREST EXPENSE -175,119.00 0.00 100 Audit entry LAND CASH 40 72-000-75-00-7327 GRANDE RESERVE PARK DEV. 25,972.65 24,152.00 107.5 Will be reimbursed from Developer. It is Planning and Design costs. LAND CASH 40 72-000-75-00-7328 _PRAIRIE MEADOWS 16,055.76 14,356.00 111.8 Originially planned to be designed in-house but was contracted out LAND CASH 40 72-000-75-00-7333 RAINTREE VILLAGE 72,538.50 29,258.00 247.9 No response from Department Head LAND CASH 40 72-000-75-00-7334 HOOVER HOLDING COSTS 178,518.32 116,638.00 ...153.0 Codand billed us in FY06/07 for a payment that was for FY05/06. PARK&REC 44 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 8,028.90 8,000.00 100.3 No response from Department Head PARK&REC 44 79-610-62-00-5438 CELLULAR TELEPHONE 3,879.94 3,800.00 102.1 No response from Department Head PARK&REC 44 79-610-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 1,159.32 0.00 100.0 No response from Department Head PARK&REC 44 79-610-64-00-5605 TRAVEL EXPENSE 4,284.66 3,800.00 112.7 No response from Department Head PARK&REC 46 79-650-62-00-5408 MAINTENANCE SUPPLIES 5,217.56 5,000.00 104.3 No response from Department Head PARK&REC 46 79-650-62-00-5409 MAINTENANCE-VEHICLE 1,946.51 1,765.00 110.2 Unexpected tires for van,engine repairs for old squad car PARK&REC 46 79-650-62-00-5606 PARK DEPOSIT REFUNDS 4,145.00 4,145.00 100 Based on revenue PARK&REC 46 79-650-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 458.00 0.00 100 Item should be reclassed to different line item. This account is always adjusted in Nov.-the event is over and we profited PARK&REC 46 79-650-65-00-5827 GOLF OUTING EXPENSES 22,177.31 22,177.00 100 apprxo.$17,000 PARK&REC 46 79-650-65-00-5841 PROGRAM REFUNDS 8,120.41 8,000.00 101.5 No way to control cancellations.Don't anticipate much for March/April PARK&REC 47 79-650-78-00-9009 RESERVE 16,835.00 11,603.00 145 No response from Department Head FOX INDUSTRIAL 52 85-000-66-00-6021 FOX IND BOND PRINCIPAL PMT 60,000.00 60,000.00 100 1 time bond payment FOX INDUSTRIAL 52 85-000-66-00-6022 FOX IND BOND INT PMT 20,415.00 20,415.00 100 1 time bond payment UNITED CITY OF YORKVILLE BUDGET INDEX General Fund Revenue 1 Sanitary Sewer Improvement& Expansion 24 Finance 3 Water Improvement & Expansion 27 Engineering 6 Debt Service Fund 30 Police 7 Water Operations 32 Planning and Development 10 Sewer Maintenance 36 Streets 11 Land Cash 39 Health and Sanitation 13 Land Acquisition 42 Motor Fuel Tax Fund 14 Parks&Recreation 43 Municipal Building 16 Library 48 Police Equipment Capital 18 Fox Industrial 52 Public Works Equipment Capital 20 Countryside TIF 54 Parks &Recreation Equipment Capital 22 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 1 TTME: 15:34:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL a ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ GENERAL REVENUES TAXES 01-000-40-00-3996 ROAD CONTRIBUTION FEE 22,000.00 810,661.00 11500,000.00 54.0 01-000-40-00-3997 IN TOWN ROAD PROGRAM FUNDING 2,782,173.00 2,782,274.92 2,070,000.00 134.4 01-000-40-00-3998 MPI BRISTOL RIDGE RD FUNDING 0.00 0.00 1,600,000.00 0.0 01-000-40-00-3999 RESERVE FUND BALANCE 0.00 5,184.50 372,849.00 1.3 01-000-40-00-4000 REAL ESTATE TAXES 0.00 1,319,394.91 1,571,133.00 83.9 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX 0.00 99,155.41 105,000.00 94.4 01-000-40-00-4002 FOX HILL LEVY REVENUE 0.00 18,204.23 18,000.00 101.1 01-000-40-00-4010 PERSONAL PROPERTY TAX 1,449.94 10,032.25 10,000.00 100.3 01-000-40-00-4020 STATE INCOME TAX 104,615.53 650,697.27 885,000.00 73.5 01-000-40-00-4030 MUNICIPAL SALES TAX 207,493.75 2,079,032.56 2,845,000.00 73.0 01-000-40-00-4032 STATE USE TAX 16,770.59 114,151.80 137,000.00 83.3 01-000-40-00-4040 MUNICIPAL UTILITY TAX 122,105.94 355,712.81 375,000.00 94.8 01-000-40-00-4041 UTILITY TAX - NICOR 0.00 162,748.24 250,000.00 65.0 01-000-40-00-4042 UTILITY TAX - CABLE TV 0.00 99,833.46 90,000.00 110.9 01-000-40-00-4043 UTILITY TAX - TELEPHONE 71,193.96 330,064.99 425,000.00 77.6 01-000-40-00-4050 HOTEL TAX 1,457.31 17,321.12 20,000.00 86.6 01-000-40-00-4060 TRAFFIC SIGNAL REVENUE 0.00 0.00 5,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TAXES 3,329,260.02 8,854,469.47 12,278,982.00 72.1 LICENSES & PERMITS 01-000-41-00-4100 LIQUOR LICENSE 0.00 15,190.95 26,000.00 58.4 01-000-41-00-4101 OTHER LICENSES 321.90 1,457.65 4,500.00 32.3 01-000-41-00-4110 BUILDING PERMITS 130,975.00 1,201,118.75 1,550,000.00 77.4 --------------------------------------------------------------------------------- TOTAL LICENSES & PERMITS 131,296.90 1,217,767.35 1,580,500.00 77.0 CHARGES FOR SERVICES 01-000-42-00-4205 FILING FEES 699.40 9,774.60 25,000.00 39.0 01-000-42-00-4206 GARBAGE SURCHARGE 172.12 203,786.15 227,648.00 89.5 01-000-42-00-4208 COLLECTION FEE - YBSD 32,915.60 32,915.60 35,000.00 94.0 01-000-42-00-4210 DEVELOPMENT FEES 24,463.61 1,144,920.10 1,475,000.00 77.6 01-000-42-00-4211 ENGINEERING CAPITAL FEE 3,300.00 35,800.00 52,000.00 68.8 01-000-42-00-4281 BEECHER DEPOSITS (150.00) 1,110.00 0.00 100.0 01-000-42-00-4286 BEECHER RENTALS 0.00 2,235.00 0.00 100.0 P1 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 2 TIME: 15:34:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL a ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 61,400.73 1,430,541.45 1,814,648.00 78.8 FINES & FORFEITS 01-000-43-00-4310 TRAFFIC FINES 10,405.66 74,901.87 75,000.00 99.8 01-000-43-00-4315 REIMBURSE POLICE TRAINING 0.00 0.00 11,805.00 0.0 01-000-43-00-4320 ORDINANCE FEES 250.00 2,775.00 2,500.00 111.0 --------------------------------------------------------------------------------- TOTAL FINES & FORFEITS 10,655.66 77,676.87 89,305.00 86.9 MISCELLANEOUS 01-000-44-00-4401 DARE DONATIONS 0.00 0.00 1,250.00 0.0 01-000-44-00-4402 ROB ROY CREEK HYDRAULIC STUDY 0.00 0.00 0.00 0.0 01-000-44-00-4403 WEARING APPAREL DONATIONS 0.00 400.00 1,140.00 35.0 01-000-44-00-4404 HANGING BASKET DONATIONS 0.00 3,820.00 3,820.00 100.0 01-000-44-00-4411 REIMBURSEMENTS-POLICE PROTECTN 173.00 3,022.90 3,000.00 100.7 01-000-44-00-4490 MISCELLANEOUS INCOME 144.18 15,906.20 10,000.00 159.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 317.18 23,149.10 19,210.00 120.5 INTERGOVERNMENTAL 01-000-45-00-4505 COPS GRANT - VESTS 0.00 5,280.00 2,500.00 211.2 01-000-45-00-4511 POLICE-STATE TOBACCO GRANT 0.00 1,540.00 1,250.00 123.2 01-000-45-00-4525 GRANTS 0.00 0.00 30,000.00 0.0 01-000-45-00-4540 BEAVER ST DEVELOPMENT GRANT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 6,820.00 33,750.00 20.2 INTEREST 01-000-46-00-4600 INVESTMENT INCOME 36,366.83 136,592.51 75,000.00 182.1 --------------------------------------------------------------------------------- TOTAL INTEREST 36,366.83 136,592.51 75,000.00 182.1 TRANSFERS 01-000-49-00-4915 TRANSFER FROM WATER OPERATIONS 0.00 187,500.00 250,000.00 75.0 01-000-49-00-4920 TRANSFER FROM SEWER MAINT. 0.00 52,500.00 70,000.00 75.0 01-000-49-00-4925 TRANSFER FROM SAN. SEWER IMPR 0.00 112,500.00 150,000.00 75.0 01-000-49-00-4930 TRANSFER FROM WATER IMPROVE. 0.00 150,000.00 200,000.00 75.0 P2 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 3 TIME: 15:34:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ GENERAL REVENUES TRANSFERS 01-000-49-00-4935 TRANSFER FROM LAND CASH 0.00 12,000.00 16,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 514,500.00 686,000.00 75.0 TOTAL REVENUES: GENERAL 3,569,297.32 12,261,516.75 16,577,395.00 73.9 EXPENSES -- UNDEFINED CODE --- 01-000-72-00-6500 IMRF PARTICIPANT 0.00 0.00 0.00 0.0 01-000-72-00-6501 SOC. SECURITY/MEDICARE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL --- UNDEFINED CODE --- 0.00 0.00 0.00 0.0 FINANCE & ADMINISTRATION EXPENSES PERSONNEL SERVICES 01-110-50-00-5100 SALARIES - MAYOR (750.00) 5,800.00 7,500.00 77.3 01-110-50-00-5101 SALARIES - CITY CLERK 0.00 2,875.00 3,600.00 79.8 01-110-50-00-5102 SALARIES - CITY TREASURER 0.00 2,805.00 3,600.00 77.9 01-110-50-00-5103 SALARIES - ALDERMAN 0.00 23,140.00 29,080.00 79.5 01-110-50-00-5104 SALARIES - LIQUOR COMMISSIONER 750.00 750.00 1,000.00 75.0 01-110-50-00-5105 SALARIES - CITY ATTORNEY 884.80 10,175.60 11,502.00 88.4 01-110-50-00-5106 SALARIES - ADMINISTRATIVE 51,162.74 637,266.24 693,715.00 91.8 01-110-50-00-5136 SALARIES - PART TIME 3,431.75 26,116.55 35,000.00 74.6 01-110-50-00-5137 SALARIES - OVERTIME 510.83 3,690.92 3,600.00 102.5 01-110-50-00-5202 BENEFITS - UNEMPLOY. COMP. TAX 0.00 14,453.50 19,255.00 75.0 01-110-50-00-5203 BENEFITS - HEALTH INSURANCE 7,007.10 687,635.09 852,458.00 80.6 01-110-50-00-5204 BENEFITS - GROUP LIFE INSURANC 1,677.42 20,321.70 23,668.00 85.8 01-110-50-00-5205 BENEFITS - DENTAL/VISION ASST 6,789.37 65,433.66 74,049.00 88.3 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 71,464.01 1,500,463.26 1,758,027.00 85.3 PROFESSIONAL SERVICES P3 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 4 TIME: 15:34:02 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL °s ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ FINANCE & ADMINISTRATION EXPENSES PROFESSIONAL SERVICES 01-110-61-00-5300 LEGAL SERVICES 11,166.40 134,331.23 150,000.00 89.5 01-110-61-00-5304 AUDIT FEES & EXPENSES 1,530.00 46,783.24 48,675.00 96.1 01-110-61-00-5305 ACCOUNTING ASSISTANCE 0.00 2,784.96 3,000.00 92.8 01-110-61-00-5310 EMPLOYEE ASSISTANCE 0.00 2,298.75 4,500.00 51.0 01-110-61-00-5311 CODIFICATION 0.00 1,822.00 5,000.00 36.4 01-110-61-00-5314 BUILDING INSPECTIONS 73,855.85 851,876.70 1,115,000.00 76.4 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 86,552.25 1,039,896.88 1,326,175.00 78.4 CONTRACTUAL SERVICES 01-110-62-00-5400 INSURANCE-LIABILITY & PROPERTY 6,859.00 169,714.70 169,720.00 99.9 01-110-62-00-5401 CONTRACTUAL SERVICES 7,439.80 34,965.69 38,000.00 92.0 01-110-62-00-5403 SPECIAL CENSUS 0.00 0.00 0.00 0.0 01-110-62-00-5404 CABLE CONSORTIUM FEE 0.00 25,608.00 30,000.00 85.3 01-110-62-00-5406 OFFICE CLEANING 625.00 6,487.32 7,500.00 86.4 01-110-62-00-5410 MAINTENANCE - OFFICE EQUIPMENT 0.00 129.18 500.00 25.8 01-110-62-00-5411 MAINTENANCE - COMPUTERS 0.00 1,363.74 2,000.00 68.1 01-110-62-00-5412 MAINTENANCE - PHOTOCOPIERS 1,964.69 20,565.52 22,000.00 93.4 01-110-62-00-5421 WEARING APPAREL 0.00 28.00 28.00 100.0 01-110-62-00-5427 FACADE PROGRAM 0.00 0.00 30,000.00 0.0 01-110-62-00-5436 TELEPHONE 2,028.72 15,733.79 15,000.00 104.8 01-110-62-00-5437 ACCTG SYSTEM SERVICE FEE 0.00 9,652.00 9,652.00 100.0 01-110-62-00-5438 CELLULAR TELEPHONE 216.17 2,206.15 2,300.00 95.9 01-110-62-00-5439 TELEPHONE SYSTEMS MAINTENANCE 0.00 3,648.45 5,000.00 72.9 01-110-62-00-5440 BEAVER ST GRANT EXPENSE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 19,133.38 290,102.54 331,700.00 87.4 PROFESSIONAL DEVELOPMENT 01-110-64-00-5600 DUES 1,060.00 5,116.75 5,000.00 102.3 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 0.00 900.00 900.00 100.0 01-110-64-00-5603 SUBSCRIPTIONS 45.00 483.45 500.00 96.6 01-110-64-00-5604 TRAINING & CONFERENCES 540.00 19,047.69 18,508.00 102.9 01-110-64-00-5605 TRAVEL/MEALS/LODGING 83.33 2,844.50 3,000.00 94.8 01-110-64-00-5606 PROMOTIONAL/MARKETING EXPENSES 2,276.67 2,276.67 577.00 394.5 P4 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 5 TIME: 15:34:02 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL °s ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ FINANCE & ADMINISTRATION EXPENSES PROFESSIONAL DEVELOPMENT 01-110-64-00-5607 PUBLIC RELATIONS 533.40 11,918.96 18,000.00 66.2 01-110-64-00-5608 SPONSORSHIPS 370.00 370.00 1,500.00 24.6 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 4,908.40 42,958.02 47,985.00 89.5 OPERATIONS 01-110-65-00-5800 CONTINGENCIES 300.85 561,015.09 560,015.00 100.1 01-110-65-00-5802 OFFICE SUPPLIES 594.56 13,768.24 15,000.00 91.7 01-110-65-00-5804 OPERATING SUPPLIES 1,742.84 13,242.55 12,450.00 106.3 01-110-65-00-5808 POSTAGE & SHIPPING 1,696.77 15,287.49 17,500.00 87.3 01-110-65-00-5809 PRINTING & COPYING (8.26) 15,157.24 15,905.00 95.2 01-110-65-00-5810 PUBLISHING & ADVERTISING 0.00 3,566.33 5,000.00 71.3 01-110-65-00-5844 MARKETING - HOTEL TAX 1,362.47 14,657.32 20,000.00 73.2 --------------------------------------------------------------------------------- TOTAL OPERATIONS 5,689.23 636,694.26 645,870.00 98.5 RETIREMENT 01-110-72-00-6500 IMRF PARTICIPANTS 6,986.86 53,575.99 54,471.00 98.3 01-110-72-00-6501 SOCIAL SECURITY & MEDICARE 4,799.71 54,944.76 51,151.00 107.4 --------------------------------------------------------------------------------- TOTAL RETIREMENT 11,786.57 108,520.75 105,622.00 102.7 CAPITAL OUTLAY 01-110-75-00-7002 COMPUTER EQUIP & SOFTWARE 3,770.17 22,597.76 28,000.00 80.7 01-110-75-00-7003 OFFICE EQUIPMENT 0.00 2,875.89 3,000.00 95.8 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 3,770.17 25,473.65 31,000.00 82.1 OTHER OPERATING EXPENSES 01-110-78-00-9001 CITY TAX REBATE 0.00 57.15 2,000.00 2.8 01-110-78-00-9002 NICOR GAS 5,546.39 18,544.64 24,144.00 76.8 01-110-78-00-9003 SALES TAX REBATE 95,498.44 513,768.11 500,000.00 102.7 01-110-78-00-9004 MISCELLANEOUS 0.00 0.00 0.00 0.0 01-110-78-00-9005 MERIT/PAY INCREASE 0.00 0.00 0.00 0.0 01-110-78-00-9006 FORMER POST OFFICE BUILDING 0.00 0.00 0.00 0.0 P5 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 6 TIME: 15:34:03 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL OTHER OPERATING EXPENSES 101,044.83 532,369.90 526,144.00 101.1 TRANSFERS 01-110-99-00-9923 TRANSFER TO LIBRARY 2,937.50 32,312.50 35,250.00 91.6 01-110-99-00-9925 TRANSFER TO SAN SEWER 0.00 112,500.00 150,000.00 75.0 01-110-99-00-9940 TRANSFER TO PARK & RECREATION 4,949.00 876,721.50 1,015,107.00 86.3 01-110-99-00-9941 TRANSFER TO PARK/REC CAPITAL 0.00 150,000.00 150,000.00 100.0 01-110-99-00-9942 TRANSFER TO POLICE CAPITAL 0.00 56,250.00 82,402.00 68.2 01-110-99-00-9945 TRANSFER TO MUNICIPAL BLDG 0.00 23,148.75 64,647.00 35.8 01-110-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 219,644.25 292,859.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 7,886.50 1,470,577.00 1,790,265.00 82.1 TOTAL EXPENSES: FINANCE & ADMINISTRATION 312,235.34 5,647,056.26 6,562,788.00 86.0 ENGINEERING EXPENSES PERSONNEL SERVICES 01-150-50-00-5107 SALARIES-EMPLOYEES 20,685.68 240,046.55 265,000.00 90.5 01-150-50-00-5137 SALARIES-OVERTIME 0.00 714.67 1,000.00 71.4 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 20,685.68 240,761.22 266,000.00 90.5 CONTRACTUAL SERVICES 01-150-62-00-5401 CONTRACTUAL SERVICES 30,887.22 76,444.54 53,000.00 144.2 01-150-62-00-5402 GIS SYSTEM 0.00 294.00 5,000.00 5.8 01-150-62-00-5403 FEES 0.00 1,000.00 2,000.00 50.0 01-150-62-00-5409 MAINTENANCE-VEHICLES 143.64 1,078.50 2,000.00 53.9 01-150-62-00-5410 MAINTENANCE-OFFICE EQUIP 0.00 163.52 1,000.00 16.3 01-150-62-00-5411 MAINTENANCE-COMPUTERS 0.00 486.52 3,000.00 16.2 01-150-62-00-5421 WEARING APPAREL 0.00 269.20 1,400.00 19.2 01-150-62-00-5438 CELLULAR TELEPHONE 216.17 2,136.35 3,360.00 63.5 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 31,247.03 81,872.63 70,760.00 115.7 P6 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 7 TIME: 15:34:03 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL a ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ ENGINEERING PROFESSIONAL DEVELOPMENT 01-150-64-00-5600 DUES 0.00 339.00 400.00 84.7 01-150-64-00-5604 TRAINING & CONFERENCES 39.65 544.65 3,000.00 18.1 01-150-64-00-5605 TRAVEL EXPENSE 220.54 466.68 1,000.00 46.6 01-150-64-00-5608 TUITION REIMBURSEMENT 0.00 0.00 1,245.00 0.0 01-150-64-00-5616 BOOKS Sc PUBLICATIONS 0.00 0.00 200.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 260.19 1,350.33 5,845.00 23.1 OPERATIONS 01-150-65-00-5801 ENGINEERING SUPPLIES 140.01 746.37 3,000.00 24.8 01-150-65-00-5802 OFFICE SUPPLIES 146.58 1,388.25 2,500.00 55.5 01-150-65-00-5809 PRINTING & COPYING 10.50 1,556.12 2,000.00 77.8 01-150-65-00-5820 ENGINEERING CAPITAL 0.00 0.00 52,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 297.09 3,690.74 59,500.00 6.2 RETIREMENT 01-150-72-00-6500 IMRF PARTICIPANTS 1,574.18 18,825.46 24,830.00 75.8 01-150-72-00-6501 SOCIAL SECURITY & MEDICARE 1,552.02 18,067.92 24,044.00 75.1 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,126.20 36,893.38 48,874.00 75.4 CAPITAL OUTLAY 01-150-75-00-7002 COMPUTER EQUIPMENT & SOFTWARE 2,967.35 5,192.23 7,900.00 65.7 01-150-75-00-7003 OFFICE EQUIPMENT 0.00 892.16 3,000.00 29.7 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 2,967.35 6,084.39 10,900.00 55.8 TOTAL EXPENSES: ENGINEERING 58,583.54 370,652.69 461,879.00 80.2 PUBLIC SAFETY/POLICE DEPT. EXPENSES PERSONNEL SERVICES 01-210-50-00-5107 SALARIES - EMPLOYEES 105,220.44 754,625.62 822,230.00 91.7 P7 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 8 TIME: 15:34:03 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL °s ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PUBLIC SAFETY/POLICE DEPT. EXPENSES PERSONNEL SERVICES 01-210-50-00-5131 SALARIES-CHIEF/LIEUTENANT/SERG 48,441.85 535,650.66 612,203.00 87.4 01-210-50-00-5133 SALARIES - COPS 18,193.80 103,316.90 106,226.00 97.2 01-210-50-00-5134 SALARIES - CROSSING GUARD 2,423.50 15,756.75 19,500.00 80.8 01-210-50-00-5135 SALARIES - POLICE CLERKS 10,835.47 111,917.76 122,418.00 91.4 01-210-50-00-5136 SALARIES - PART TIME 1,414.54 20,476.98 35,000.00 58.5 O1-210-50-00-5137 SALARIES - OVERTIME 4,029.41 41,662.78 65,000.00 64.0 01-210-50-00-5200 CADET PROGRAM 1,028.00 14,616.51 22,000.00 66.4 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 191,587.01 1,598,023.96 1,804,577.00 88.5 PROFESSIONAL SERVICES 01-210-61-00-5300 LEGAL SERVICES 4,461.25 31,731.04 29,000.00 109.4 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 4,461.25 31,731.04 29,000.00 109.4 CONTRACTUAL SERVICES 01-210-62-00-5408 MAINTENANCE - EQUIPMENT (64.00) 8,749.58 8,814.00 99.2 01-210-62-00-5409 MAINTENANCE - VEHICLES 4,436.60 30,785.51 32,000.00 96.2 01-210-62-00-5410 MAINT-OFFICE EQUIPMENT 0.00 2,625.00 2,625.00 100.0 01-210-62-00-5411 MAINTENANCE - COMPUTERS 0.00 5,639.62 6,118.00 92.1 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 603.73 6,117.35 6,000.00 101.9 01-210-62-00-5421 WEARING APPAREL 1,317.04 19,133.99 30,000.00 63.7 O1-210-62-00-5422 COPS GRANT IV - VESTS 0.00 2,207.32 3,000.00 73.5 01-210-62-00-5423 CLASY GRANT 0.00 1,000.00 1,000.00 100.0 01-210-62-00-5429 PSYCHOLOGICAL TESTING 500.00 2,250.00 3,250.00 69.2 01-210-62-00-5430 HEALTH SERVICES 865.00 4,276.04 7,500.00 57.0 O1-210-62-00-5431 LABORATORY FEES 0.00 0.00 0.00 0.0 01-210-62-00-5436 TELEPHONE 1,690.00 14,465.28 16,000.00 90.4 01-210-62-00-5438 CELLULAR TELEPHONE 1,297.05 12,029.44 14,500.00 82.9 01-210-62-00-5441 MTD-ALERTS FEE 0.00 5,038.00 7,918.00 63.6 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 10,645.42 114,317.13 138,725.00 82.4 PROFESSIONAL DEVELOPMENT 01-210-64-00-5600 DUES 0.00 2,500.00 2,500.00 100.0 P8 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 9 TIME: 15:34:04 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL °s ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PUBLIC SAFETY/POLICE DEPT. EXPENSES PROFESSIONAL DEVELOPMENT 01-210-64-00-5603 SUBSCRIPTIONS 0.00 316.15 350.00 90.3 01-210-64-00-5604 TRAINING & CONFERENCE 1,080.00 13,022.57 19,950.00 65.2 01-210-64-00-5605 TRAVEL EXPENSES 797.86 7,206.12 10,500.00 68.6 01-210-64-00-5606 COMMUNITY RELATIONS 100.00 5,614.40 11,800.00 47.5 01-210-64-00-5607 POLICE COMMISSION 0.00 7,583.01 10,000.00 75.8 01-210-64-00-5608 TUITION REIMBURSEMENT 1,216.64 12,518.39 14,000.00 89.4 01-210-64-00-5609 POLICE RECRUIT ACADEMY 0.00 15,712.12 10,500.00 149.6 01-210-64-00-5610 GUN RANGE FEES 0.00 0.00 700.00 0.0 01-210-64-00-5611 SRT FEE 1,490.00 3,490.00 3,500.00 99.7 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 4,684.50 67,962.76 83,800.00 81.1 OPERATIONS 01-210-65-00-5802 OFFICE SUPPLIES 515.27 7,290.53 7,803.00 93.4 01-210-65-00-5804 OPERATING SUPPLIES 622.64 16,304.89 19,800.00 82.3 01-210-65-00-5808 POSTAGE & SHIPPING 434.09 3,343.94 3,500.00 95.5 01-210-65-00-5809 PRINTING & COPYING 0.00 4,856.55 5,725.00 84.8 01-210-65-00-5810 PUBLISHING & ADVERTISING 0.00 521.20 522.00 99.8 01-210-65-00-5812 GASOLINE 5,017.68 44,569.23 63,000.00 70.7 01-210-65-00-5813 AMMUNITION 990.00 2,071.60 5,500.00 37.6 --------------------------------------------------------------------------------- TOTAL OPERATIONS 7,579.68 78,957.94 105,850.00 74.5 RETIREMENT 01-210-72-00-6500 IMRF PARTICIPANTS 808.78 9,098.70 9,671.00 94.0 01-210-72-00-6501 SOCIAL SECURITY & MEDICARE 14,670.05 122,727.20 137,591.00 89.1 01-210-72-00-6502 POLICE PENSION 0.00 248,987.74 250,000.00 99.5 --------------------------------------------------------------------------------- TOTAL RETIREMENT 15,478.83 380,813.64 397,262.00 95.8 CAPITAL OUTLAY 01-210-75-00-7002 COMPUTER EQUIP & SOFTWARE 3,170.82 7,368.82 9,500.00 77.5 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 3,170.82 7,368.82 9,500.00 77.5 P9 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 10 TIME: 15:34:04 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCALs ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PUBLIC SAFETY/POLICE DEPT. OTHER OPERATING EXPENSES 01-210-78-00-9004 BIKE PATROL 0.00 0.00 1,500.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING EXPENSES 0.00 0.00 1,500.00 0.0 TOTAL EXPENSES: PUBLIC SAFETY/POLICE DEPT. 237,607.51 2,279,175.29 2,570,214.00 88.6 PLANNING & DEVELOPMENT EXPENSES PERSONNEL SERVICES 01-220-50-00-5107 EMPLOYEE SALARIES 17,339.46 94,994.60 115,000.00 82.6 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 17,339.46 94,994.60 115,000.00 82.6 PROFESSIONAL SERVICES 01-220-61-00-5300 LEGAL SERVICES 0.00 28,804.81 40,000.00 72.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 28,804.81 40,000.00 72.0 CONTRACTUAL SERVICES 01-220-62-00-5401 CONTRACTUAL SERVICES 125.00 11,711.35 45,000.00 26.0 01-220-62-00-5430 PLANNING CONSULTANT 16,058.35 16,058.35 38,000.00 42.2 01-220-62-00-5432 ECONOMIC DEVELOPMENT 0.00 45,000.00 45,000.00 100.0 01-220-62-00-5438 CELULAR TELEPHONE 86.47 898.82 1,500.00 59.9 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 16,269.82 73,668.52 129,500.00 56.8 PROFESSIONAL DEVELOPMENT 01-220-64-00-5600 DUES 0.00 732.00 2,000.00 36.6 01-220-64-00-5604 TRAINING & CONFERENCES 458.80 4,303.35 5,000.00 86.0 01-220-64-00-5605 TRAVEL EXPENSE 132.04 765.33 2,000.00 38.2 01-220-64-00-5616 BOOKS & PUBLICATIONS 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 590.84 5,800.68 9,000.00 64.4 P10 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 11 TIME: 15:34:04 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL °s ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PLANNING & DEVELOPMENT OPERATIONS 01-220-65-00-5804 OPERATING SUPPLIES 272.88 4,373.44 10,500.00 41.6 01-220-65-00-5809 PRINTING & COPYING 47.64 526.50 2,500.00 21.0 01-220-65-00-5810 PUBLISHING & ADVERTISING 0.00 2,190.00 4,000.00 54.7 01-220-65-00-5814 BOOKS & MAPS 0.00 1,941.00 4,000.00 48.5 --------------------------------------------------------------------------------- TOTAL OPERATIONS 320.52 9,030.94 21,000.00 43.0 RETIREMENT 01-220-72-00-6500 IMRF PARTICIPANTS 1,319.53 7,353.96 17,222.00 42.7 01-220-72-00-6501 SOCIAL SECURITY & MEDICARE 1,319.32 7,230.18 16,677.00 43.3 --------------------------------------------------------------------------------- TOTAL RETIREMENT 2,638.85 14,584.14 33,899.00 43.0 CAPITAL OUTLAY 01-220-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 21,458.54 50,000.00 42.9 01-220-75-00-7003 OFFICE EQUIPMENT 0.00 401.23 18,000.00 2.2 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 21,859.77 68,000.00 32.1 TOTAL EXPENSES: PLANNING & DEVELOPMENT 37,159.49 248,743.46 416,399.00 59.7 STREETS EXPENSES PERSONNEL SERVICES 01-410-50-00-5107 SALARIES - EMPLOYEE 16,826.64 195,919.06 215,000.00 91.1 01-410-50-00-5136 SALARIES - PART TIME 0.00 3,096.00 5,000.00 61.9 01-410-50-00-5137 SALARIES - OVERTIME 1,720.78 11,645.05 20,000.00 58.2 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 18,547.42 210,660.11 240,000.00 87.7 PROFESSIONAL SERVICES 01-410-61-00-5313 ENGINEERING - IN TOWN RD PROG 0.00 0.00 261,802.00 0.0 01-410-61-00-5314 INSPECTIONS & LICENSES 0.00 399.00 400.00 99.7 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 399.00 262,202.00 0.1 P11 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 12 TIME: 15:34:05 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ STREETS CONTRACTUAL SERVICES 01-410-62-00-5401 CONTRACTUAL SERVICES 390.00 2,658.92 3,000.00 88.6 01-410-62-00-5408 MAINTENANCE-EQUIPMENT 397.08 5,714.86 6,500.00 87.9 01-410-62-00-5409 MAINTENANCE-VEHICLES 1,888.57 15,732.47 15,000.00 104.8 01-410-62-00-5414 MAINTENANCE-TRAFFIC SIGNALS 2,008.77 18,438.33 18,000.00 102.4 01-410-62-00-5415 MAINTENANCE-STREET LIGHTS 876.61 14,439.38 25,000.00 57.7 01-410-62-00-5420 MAINTENANCE-STORM SEWER 53.94 2,170.95 8,000.00 27.1 01-410-62-00-5421 WEARING APPAREL 363.20 3,828.45 6,000.00 63.8 01-410-62-00-5434 RENTAL-EQUIPMENT 0.00 1,270.54 2,000.00 63.5 01-410-62-00-5435 ELECTRICITY 4,829.52 61,258.90 60,000.00 102.0 01-410-62-00-5438 CELLULAR TELEPHONE 370.15 2,698.03 3,300.00 81.7 01-410-62-00-5440 STREET LIGHTING 0.00 200.00 6,000.00 3.3 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 11,177.84 128,410.83 152,800.00 84.0 PROFESSIONAL DEVELOPMENT 01-410-64-00-5604 TRAINING & CONFERENCES 0.00 926.65 2,000.00 46.3 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 926.65 2,000.00 46.3 OPERATIONS 01-410-65-00-5804 OPERATING SUPPLIES 705.77 12,760.37 25,000.00 51.0 01-410-65-00-5812 GASOLINE 4;677.83 30,527.92 35,850.00 85.1 01-410-65-00-5815 HAND TOOLS 6.86 186.83 1,000.00 18.6 01-410-65-00-5817 GRAVEL 0.00 1,672.18 5,000.00 33.4 --------------------------------------------------------------------------------- TOTAL OPERATIONS 5,390.46 45,147.30 66,850.00 67.5 RETIREMENT 01-410-72-00-6500 IMRF PARTICIPANTS 1,411.49 16,251.84 19,390.00 83.8 01-410-72-00-6501 SOCIAL SECURITY & MEDICARE 1,418.89 16,127.99 19,426.00 83.0 --------------------------------------------------------------------------------- TOTAL RETIREMENT 2,830.38 32,379.83 38,816.00 83.4 CAPITAL OUTLAY 01-410-75-00-4404 HANGING BASKETS 0.00 2,442.18 2,442.00 100.0 01-410-75-00-5418 MOSQUITO CONTROL 0.00 28,414.00 28,414.00 100.0 P12 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 13 TIME: 15:34:05 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: GENERAL FUND FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ STREETS EXPENSES CAPITAL OUTLAY 01-410-75-00-7004 SAFETY EQUIPMENT 0.00 1,792.58 2,000.00 89.6 01-410-75-00-7099 GRANDE RESERVE PERIMETER ROADS 0.00 385,659.21 1,600,000.00 24.1 01-410-75-00-7100 STREET REHAB PROJECTS 0.00 52,754.98 75,000.00 70.3 01-410-75-00-7101 IN TOWN ROAD PROGRAM 0.00 78,672.57 1,588,198.00 4.9 01-410-75-00-7102 TREE & STUMP REMOVAL 0.00 9,622.50 24,995.00 38.4 01-410-75-00-7103 SIDEWALK CONSTRUCTION 0.00 0.00 25,000.00 0.0 01-410-75-00-7104 FOX HILL SSA EXPENSES 0.00 8,625.00 18,000.00 47.9 01-410-75-00-7106 ROAD CONTRIBUTION FUND PROJ 0.00 37,935.76 38,000.00 99.8 01-410-75-00-7107 ROAD CONTRIBUTION FUND-RESERVE 0.00 0.00 1,500,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 605,918.78 4,902,049.00 12.3 TRANSFERS 01-410-99-00-9930 TRANSFER TO WATER IMPROVEMENT 0.00 165,000.00 220,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 165,000.00 220,000.00 75.0 TOTAL EXPENSES: STREETS 37,946.10 1,188,842.50 5,884,717.00 20.2 HEALTH & SANITATION EXPENSES CONTRACTUAL SERVICES 01-540-62-00-5442 GARBAGE SERVICES 64,608.90 609,043.58 676,163.00 90.0 01-540-62-00-5443 LEAF PICKUP 0.00 5,235.00 5,235.00 100.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 64,608.90 614,278.58 681,398.00 90.1 TOTAL EXPENSES: HEALTH & SANITATION 64,608.90 614,278.58 681,398.00 90.1 TOTAL FUND REVENUES 3,569,297.32 12,261,516.75 16,577,395.00 73.9 TOTAL FUND EXPENSES 748,140.88 10,348,748.78 16,577,395.00 62.4 FUND SURPLUS (DEFICIT) 2,821,156.44 1,912,767.97 0.00 100.0 P13 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 14 TIME: 15:34:05 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: MOTOR FUEL TAX FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES TAXES 15-000-40-00-3999 CARRY OVER BALANCE 0.00 505,226.00 305,226.00 165.5 15-000-40-00-4060 MOTOR FUEL TAX ALLOTMENTS 28,465.38 280,263.11 318,601.00 87.9 --------------------------------------------------------------------------------- TOTAL TAXES 28,465.38 785,489.11 623,827.00 125.9 MISCELLANEOUS 15-000-44-00-4490 MISCELANOUS INCOME 0.00 11,806.00 0.00 100.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 11,806.00 0.00 100.0 INTEREST 15-000-46-00-4600 INVESTMENT INCOME 2,040.92 22,072.80 12,000.00 183.9 --------------------------------------------------------------------------------- TOTAL INTEREST 2,040.92 22,072.80 12,000.00 183.9 TOTAL REVENUES: 30,506.30 819,367.91 635,827.00 128.8 EXPENSES OPERATIONS 15-000-65-00-5800 CONTINGENCY 0.00 455.00 39,237.00 1.1 15-000-65-00-5818 SALT 19,716.08 63,801.46 60,000.00 106.3 --------------------------------------------------------------------------------- TOTAL OPERATIONS 19,716.08 64,256.46 99,237.00 64.7 CAPITAL OUTLAY 15-000-75-00-7007 SIGNS 0.00 9,574.22 9,990.00 95.8 15-000-75-00-7008 CRACK FILLING 0.00 18,758.87 40,000.00 46.8 15-000-75-00-7107 CONSTRUCTION ENGINEERING 11,050.37 34,889.50 150,000.00 23.2 15-000-75-00-7110 COLD PATCH 0.00 1,895.51 8,000.00 23.6 15-000-75-00-7111 HOT PATCH 0.00 3,162.71 9,600.00 32.9 15-000-75-00-7113 COUNTRYSIDE PKWY CONSTRUCTION 0.00 201,442.44 300,000.00 67.1 15-000-75-00-7114 ROUTE 126/71 TRAFFIC SIGNALS 0.00 0.00 19,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 11,050.37 269,723.25 536,590.00 50.2 P14 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 15 TIME: 15:34:06 DETAILED REVENUE & EXPENSE REPORT F—YR: 07 ID: GL4B3000.WOW FUND: MOTOR FUEL TAX FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL e ACCOUNT MARCH YEAR—TO—DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ---—-—--——--—--------—---—-------—------------—------------------—-------------—--------------------------------------—---—--------- TOTAL EXPENSES: 30,766.45 333,979.71 635,827.00 52.5 TOTAL FUND REVENUES 30,506.30 819,367.91 635,827.00 128.8 TOTAL FUND EXPENSES 30,766.45 333,979.71 635,827.00 52.5 FUND SURPLUS (DEFICIT) (260.15) 485,388.20 0.00 100.0 P15 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 16 TIME: 15:34:06 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: MUNICIPAL BUILDLING FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 16-000-40-00-3999 CARRY OVER BALANCE 0.00 (208,136.00) 32,500.00 (640.4) --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 (208,136.00) 32,500.00 (640.4) - CHARGES FOR SERVICES 16-000-42-00-4211 DEVELOPMENT FEES-BUILDING 5,550.00 75,450.00 137,423.00 54.9 16-000-42-00-4215 BEECHER RENTAL FEE 1,000.00 11,100.00 12,000.00 92.5 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 6,550.00 86,550.00 149,423.00 57.9 TRANSFERS 16-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 23,148.75 64,647.00 35.8 16-000-49-00-4902 TRANSFER FROM LAND ACQUISITION 0.00 0.00 13,618.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 23,148.75 78,265.00 29.5 TOTAL REVENUES: 6,550.00 (98,437.25) 260,188.00 (37.8) EXPENSES CONTRACTUAL SERVICES 16-000-62-00-5402 RECREATION RENTAL FEE 0.00 0.00 12,500.00 0.0 16-000-62-00-5416 MAINT-GENERAL BLDG & GROUNDS 0.00 150.00 31000.00 5.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 0.00 150.00 15,500.00 0.9 CAPITAL OUTLAY 16-000-75-00-7008 ENTRY WAY SIGNS 0.00 0.00 4,000.00 0.0 16-000-75-00-7200 BLDG IMPROV- BEEHCER/RIVFRNT 238.45 11,172.76 12,000.00 93.1 16-000-75-00-7203 BLDG IMPROVEMENTS-PUBLIC WORKS 150.00 8,638.75 12,000.00 71.9 16-000-75-00-7204 BLDG MAINT - CITY HALL 63.59 4,461.71 14,000.00 31.8 16-000-75-00-7205 BLDG IMPROVEMENTS-LIBRARY 0.00 0.00 0.00 0.0 16-000-75-00-7206 LANDSCAPING-PUBLIC BUILDINGS 0.00 1,677.59 2,000.00 83.8 16-000-75-00-7210 BLDG IMPROV-POST OFFICE 1,315.78 98,263.02 98,265.00 99.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 1,767.82 124,213.83 142,265.00 87.3 P16 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 17 TIME: 15:34:06 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: MUNICIPAL BUILDLING FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL a ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TRANSFERS 16-000-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 76,817.25 102,423.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 76,817.25 102,423.00 75.0 TOTAL EXPENSES: 1,767.82 201,181.08 260,188.00 77.3 TOTAL FUND REVENUES 6,550.00 (98,437.25) 260,188.00 (37.8) TOTAL FUND EXPENSES 1,767.82 201,181.08 260,188.00 77.3 FUND SURPLUS (DEFICIT) 4,782.18 (299,618.33) 0.00 100.0 P17 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 18 TIME: 15:34:07 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 20-000-40-00-3999 CARRY OVER -WEATHER WARN SIREN 0.00 165,558.00 165,558.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 165,558.00 165,558.00 100.0 CHARGES FOR SERVICES 20-000-42-00-4212 DEV FEES - POLICE 14,100.00 130,200.00 188,000.00 69.2 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 14,100.00 130,200.00 188,000.00 69.2 MISCELLANEOUS 20-000-44-00-4402 K-9 DONATIONS 1,827.00 2,977.00 1,000.00 297.7 20-000-44-00-4403 IN CAR VIDEO DONATIONS 1,236.00 10,950.00 9,714.00 112.7 20-000-44-00-4404 DONATIONS 0.00 41.61 1,000.00 4.1 20-000-44-00-4405 WEATHER WARNING SIREN 0.00 8,357.85 20,000.00 41.7 20-000-44-00-4431 SALE OF POLICE SQUADS 0.00 0.00 500.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 3,063.00 22,326.46 32,214.00 69.3 TRANSFERS 20-000-49-00-4901 TRANSFER FROM GENERAL FUND 7,402.00 63,652.00 82,402.00 77.2 --------------------------------------------------------------------------------- TOTAL TRANSFERS 7,402.00 63,652.00 82,402.00 77.2 TOTAL REVENUES: 24,565.00 381,736.46 468,174.00 81.5 EXPENSES WEAPONS 20-000-65-00-5811 LETHAL/NON-LETHAL WEAPONS 0.00 6,846.62 7,000.00 97.8 --------------------------------------------------------------------------------- TOTAL WEAPONS 0.00 6,846.62 7,000.00 97.8 CAPITAL OUTLAY 20-000-75-00-7001 EQUIPMENT 0.00 13,623.25 36,722.00 37.0 20-000-75-00-7002 K-9 EQUIPMENT 0.00 372.11 1,500.00 24.8 P18 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 19 TIME: 15:34:07 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL e ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CAPITAL OUTLAY 20-000-75-00-7005 VEHICLES 4,031.97 101,253.14 104,624.00 96.7 20-000-75-00-7006 CAR BUILD OUT 0.00 38,754.31 49,415.00 78.4 20-000-75-00-7008 NEW WEATHER WARNING SIRENS 0.00 0.00 37,000.00 0.0 20-000-75-00-7009 RESERVE-WEATHER WARNING SIREN 0.00 0.00 82,648.00 0.0 20-000-75-00-7010 NEW WORLD SOFTWARE 0.00 0.00 125,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 4, 031.97 154,002.81 436,909.00 35.2 OTHER 20-000-78-00-9009 RESERVE 0.00 0.00 24,265.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 24,265.00 0.0 TOTAL EXPENSES: 4,031.97 160,849.43 468,174.00 34.3 TOTAL FUND REVENUES 24,565.00 381,736.46 468,174.00 81.5 TOTAL FUND EXPENSES 4,031.97 160,849.43 468,174.00 34.3 FUND SURPLUS (DEFICIT) 20,533.03 220,887.03 0.00 100.0 P19 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 20 TIME: 15:34:07 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 21-000-40-00-3999 CARRY OVER BALANCE 0.00 585,955.00 175,000.00 334.8 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 585,955.00 175,000.00 334.8 CHARGES FOR SERVICES 21-000-42-00-4213 DEVELOPMENT FEES-PUBLIC WORKS 35,700.00 319,000.00 435,000.00 73.3 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 35,700.00 319,000.00 435,000.00 73.3 MISCELLANEOUS 21-000-44-00-4430 SALE OF EQUIPMENT 0.00 0.00 40,000.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 0.00 40,000.00 0.0 TRANSFERS 21-000-49-00-4915 TRANSFER FROM WATER FUND 0.00 37,500.00 50,000.00 75.0 21-000-49-00-4920 TRANSFER FROM SEWER FUND 0.00 22,500.00 30,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 60,000.00 80,000.00 75.0 TOTAL REVENUES: 35,700.00 964,955.00 730,000.00 132.1 EXPENSES CAPITAL OUTLAY 21-000-75-00-7001 EQUIPMENT 0.00 0.00 150,000.00 0.0 21-000-75-00-7005 VEHICLES 0.00 286,326.00 309,000.00 92.6 21-000-75-00-7015 SKIDSTEER UPGRADE 0.00 4,500.00 4,500.00 100.0 21-000-75-00-7107 TRUCK ACCESSORIES 0.00 5,185.00 14,000.00 37.0 21-000-75-00-7130 BLDG ADDITION - SALT DOME 0.00 7,442.49 192,342.00 3.8 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 303,453.49 669,842.00 45.3 OTHER 21-000-78-00-9009 RESERVE 55,676.00 60,158.00 60,158.00 100.0 P20 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 21 TIME: 15:34:08 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL OTHER 55,676.00 60,158.00 60,158.00 100.0 TOTAL EXPENSES: 55,676.00 363,611.49 730,000.00 49.8 TOTAL FUND REVENUES 35,700.00 964,955.00 730,000.00 132.1 TOTAL FUND EXPENSES 55,676.00 363,611.49 730,000.00 49.8 FUND SURPLUS (DEFICIT) (19, 976.00) 601,343.51 0.00 100.0 P21 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 22 TIME: 15:34:08 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL % ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 22-000-40-00-3999 CARRY OVER BALANCE 0.00 11,454.00 11,454.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 11,454.00 11,454.00 100.0 CHARGES FOR SERVICES 22-000-42-00-4216 PARKS CAPITAL FEE 1,200.00 15,700.00 26,000.00 60.3 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 1,200.00 15,700.00 26,000.00 60.3 MISCELLANEOUS 22-000-44-00-4430 SALE OF VEHICLES/EQUIPMENT 0.00 0.00 10,000.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 0.00 10,000.00 0.0 TRANSFERS 22-000-49-00-4930 TRANSFER FROM GENERAL FUND (1,200.00) 150,000.00 150,000.00 100.0 -------------------------------------------------------------------------------- TOTAL TRANSFERS (1,200.00) 150,000.00 150,000.00 100.0 TOTAL REVENUES: 0.00 177,154.00 197,454.00 89.7 PARKS EXPENSES CAPITAL OUTLAY 22-610-75-00-7006 PICK UP TRUCK 336.96 68,721.96 75,000.00 91.6 22-610-75-00-7009 COMPUTER WORKSTATIONS 0.00 0.00 1,500.00 0.0 22-610-75-00-7013 PLAYGROUND REPAIRS 0.00 0.00 0.00 0.0 22-610-75-00-7014 SIGN REPLACEMENT 0.00 0.00 0.00 0.0 22-610-75-00-7015 MOWER 454.75 3,449.75 15,000.00 22.9 22-610-75-00-7017 RECREATION EQUIPMENT 0.00 0.00 954.00 0.0 22-610-75-00-7018 PARK RE-DEVELOPEMENTS 0.00 0.00 105,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 791.71 72,171.71 197,454.00 36.5 P22 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 23 TIME: 15:34:08 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL EXPENSES: PARKS 791.71 72,171.71 197,454.00 36.5 TOTAL FUND REVENUES 0.00 177,154. 00 197,454.00 89.7 TOTAL FUND EXPENSES 791.71 72,171.71 197,454.00 36.5 FUND SURPLUS (DEFICIT) (791.71) 104,982.29 0.00 100.0 P23 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 24 TIME: 15:34:09 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 37-000-40-00-3999 CARRY OVER 0.00 6,102,651.00 3,130,000.00 194.9 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 6,102,651.00 3,130,000.00 194.9 CHARGES FOR SERVICES 37-000-42-00-4220 CONNECTION FEES 93,800.00 981,866.00 1,576,800.00 62.2 37-000-42-00-4221 RIVER CROSSING FEES 0.00 1,354.00 20,000.00 6.7 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 93,800.00 983,220.00 1,596,800.00 61.5 INTEREST 37-000-46-00-4600 INVESTMENT INCOME 3,434.13 155,702.81 150,000.00 103.8 --------------------------------------------------------------------------------- TOTAL INTEREST 3,434.13 155,702.81 150,000.00 103.8 OTHER OPERATING RECEIPTS 37-000-48-00-4803 ROB ROY INTERCEPTOR 0.00 360,755.20 0.00 100.0 37-000-48-00-4804 SOUTHWEST SVC AREA INTERCEPTOR 0.00 56, 180.51 5, 500,000.00 1.0 37-000-48-00-4805 COUNTRYSIDE INTERCEPTOR (70,802.86) 1,216,732.24 0.00 100.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS (70,802.86) 1,633,667.95 5,500,000.00 29.7 TRANSFERS 37-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 112,500.00 150,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 112,500.00 150,000.00 75.0 TOTAL REVENUES: 26,431.27 8,987,741.76 10,526,800.00 85.3 EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5401 CONTRACTURAL/PROFESSIONAL SERV 0.00 5,952.79 40,000.00 14.8 37-000-62-00-5402 ENG/LGL/CONTINGNCY-COUNTRYSIDE 1,511.71 31,663.36 0.00 (100.0) 37-000-62-00-5405 ENG/LGL/CONTINGENCY-BRUELL ST. 0.00 (5.50) 0.00 (100.0) P24 DATE: 04/24/2007 UNITED CITY OF YORKVILLE - PAGE- 25 TIME: 15:34:09 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5406 ENG/LGL/CONTINGENCY-HYDRAULIC 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 1,511.71 37,610.65 40,000.00 94.0 OTHER 37-000-65-00-5421 GIS SYSTEM 0.00 0.00 5,000.00 0.0 37-000-65-00-5800 CONTINGENCY 0.00 0.00 796,759.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 801,759.00 0.0 DEBT SERVICE 37-000-66-00-6012 DEBT ISSUANCE COSTS 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL DEBT SERVICE 0.00 0.00 0.00 0.0 CAPITAL OUTLAY 37-000-75-00-7503 COUNTRYSIDE INTERCEPTOR (166,675.45) 22,587.52 0.00 (100.0) 37-000-75-00-7504 BRUELL STREET LIFT STATION 0.00 0.00 0.00 0.0 37-000-75-00-7505 ROB ROY CREEK SANITARY 1,614.88 4,159,610.10 3,130,000.00 132.8 37-000-75-00-7506 SOUTHWEST SVC AREA INTERCEPTOR 218.88 51,291.11 51500,000.00 0.9 37-000-75-00-7507 SEWER IMPROVEMENTS 0.00 0.00 0.00 0.0 37-000-75-00-7508 MANHOLE REHAB PROJECT 0.00 0.00 15,000.00 0.0 37-000-75-00-7509 SCADA SYSTEM 0.00 0.00 100,000.00 0.0 37-000-75-00-7510 FOX HILL SANITARY SEWER RECAP. 0.00 0.00 150,000.00 0.0 37-000-75-00-7515 HEARTLAND ONSITE INTERCEPTOR 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY (164,841.69) 4,233,488.73 8,895,000.00 47.5 TRANSFERS 37-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 112,500.00 150,000.00 75.0 37-000-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 480,030.75 640,041.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 592,530.75 790,041.00 75.0 TOTAL EXPENSES: (163,329.98) 4,863,630.13 10,526,800.00 46.2 P25 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 26 TIME: 15:34:09 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL t ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL FUND REVENUES 26,431.27 8,987,741.76 10,526,800.00 85.3 TOTAL FUND EXPENSES (163,329.98) 4,863,630.13 10,526,800.00 46.2 FUND SURPLUS (DEFICIT) 189,761.25 4,124,111.63 0.00 100.0 P26 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 27 TIME: 15:34:10 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: WATER IMPROV. EXPANSION FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL $ ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 41-000-40-00-3999 CARRY OVER 6,349.00 1,381,009.00 1,381,009.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 6,349.00 1,381,009.00 1,381,009.00 100.0 CHARGES FOR SERVICES 41-000-42-00-4220 CONNECTION FEES 147,632.00 1,234,704.55 2,083,000.00 59.2 41-000-42-00-4221 SOUTHWEST WATER MAIN REVENUE 0.00 514.93 2,648,276.00 0.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 147,632.00 1,235,219.48 4,731,276.00 26.1 INTEREST 41-000-46-00-4600 INVESTMENT INCOME 3,161.35 41,265.22 55,000.00 75.0 --------------------------------------------------------------------------------- TOTAL INTEREST 3,161.35 41,265.22 55,000.00 75.0 OTHER OPERATING RECEIPTS 41-000-48-00-4800 LOAN PROCEEDS-CONTRACT B.1 0.00 1,402,853.00 1,412,960.00 99.2 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 0.00 1,402,853.00 1,412,960.00 99.2 TRANSFERS 41-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 165,000.00 220,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 165,000.00 220,000.00 75.0 TOTAL REVENUES: 157,142.35 4,225,346.70 7,800,245.00 54.1 EXPENSES PROFESSIONAL SERVICE 41-000-61-00-5300 LEGAL SERVICES 0.00 428.00 4,000.00 10.7 41-000-61-00-5301 ENGINEERING - GENERAL SERVICES 3,622.60 1,120,871.16 20,000.00 5604.3 41-000-61-00-5400 RADIUM COMPLIANCE-CONT. B2 & 3 0.00 265,992.70 266,000.00 99.9 41-000-61-00-5401 ENGINEERING-RADIUM CONT B2 & 3 0.00 241,564.07 242,000.00 99.8 41-000-61-00-5402 ENGINEERING-SW H2O PROJECT-F 51,396.14 233,296.46 165,000.00 141.3 P27 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 28 TIME: 15:34:10 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: WATER IMPROV. EXPANSION FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL $ ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES PROFESSIONAL SERVICE 41-000-61-00-5405 PROF. SVCS- RADIUM CONT B2 & 3 0.00 15,829.89 20,000.00 79.1 41-000-61-00-5406 CONTRACT B.1 PROFESSIONAL SVCS 0.00 0.00 75,000.00 0.0 41-000-61-00-5407 CONTRACT B.1 CONSTRUCTION 0.00 17,510.66 1,582,005.00 1.1 41-000-61-00-5408 CENTRAL ZONE - CONTRACT C 0.00 45,209.53 102,702.00 44.0 41-000-61-00-5410 ENGINEERING-CENTRAL ZONE C 0.00 11,206.97 10,000.00 112.0 41-000-61-00-5414 CONTRACT D SCADA SYSTEM 0.00 0.00 0.00 0.0 41-000-61-00-5415 USGS GROUNDWATER STUDY 0.00 8,000.00 10,500.00 76.1 41-000-61-00-5416 USGS GROUNDWATER COUNTYWIDE 0.00 13,128.00 15,000.00 87.5 41-000-61-00-5417 USGS GROUNDWATER SHALLOW WATER 7,500.00 36,716.00 50,000.00 73.4 41-000-61-00-5418 F6 GREENBRIAR ROAD EXTENSION 448.50 13,198.75 0.00 (100.0) 41-000-61-00-5419 F7 GREENBRIAR/RT 47 TRAFIC SGN 0.00 0.00 0.00 0.0 41-000-61-00-5420 F8 FOX ROAD RESURFACE 0.00 15,008.50 0.00 (100.0) 41-000-61-00-5421 F9 PAVILION ROAD 14,579.12 54,808.32 0.00 (100.0) 41-000-61-00-5422 DRAINAGE STUDY 3,660.00 34,986.75 0.00 (100.0) --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICE 81,206.36 2,127,755.76 2,562,207.00 83.0 OTHER 41-000-65-00-5421 GIS SYSTEM 0.00 8,465.28 5,000.00 169.3 41-000-65-00-5800 CONTINGENCY 0.00 0.00 1,124,677.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 8,465.28 1,129,677.00 0.7 CAPITAL OUTLAY 41-000-75-00-7503 SOUTHWEST WATER MAIN PROJECT F 0.00 0.00 2,484,240.00 0.0 41-000-75-00-7504 NORTH WATER TOWER-CONTRACT A 0.00 4,817.75 0.00 (100.0) 41-000-75-00-7507 OVERSIZING - HEARTLAND CIRCLE 0.00 0.00 0.00 0.0 41-000-75-00-7509 SCADA SYSTEM 0.00 103,095.51 450,000.00 22.9 41-000-75-00-7520 WATERMAIN PROJECTS 0.00 0.00 311,000.00 0.0 41-000-75-00-7522 IN TOWN ROAD PROG WATER PROJ 0.00 0.00 220,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 107,913.26 3,465,240.00 3.1 TRANSFERS 41-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 150,000.00 200,000.00 75.0 P28 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 29 TIME: 15:34:10 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: WATER IMPROV. EXPANSION FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES TRANSFERS 41-000-99-00-9965 TRANSFER TO DEBT FUND 0.00 332,340.75 443,121.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 482,340.75 643,121.00 75.0 TOTAL EXPENSES: 81,206.36 2,726,475.05 7,800,245.00 34.9 TOTAL FUND REVENUES 157,142.35 4,225,346.70 7,800,245.00 54.1 TOTAL FUND EXPENSES 81,206.36 2,726,475.05 7,800,245.00 34.9 FUND SURPLUS (DEFICIT) 75,935.99 1,498,871.65 0.00 100.0 P29 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 30 TIME: 15:34:11 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: DEBT SERVICE FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES MISCELLANEOUS 42-000-44-00-4440 RECAPTURE-WATER/SEWER 9,535.25 148,332.07 132,773.00 111.7 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 9,535.25 148,332.07 132,773.00 111.7 TRANSFERS 42-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 219,644.25 292,859.00 75.0 42-000-49-00-4925 TRANSFER FROM SANITARY SEWER 0.00 480,030.75 640,041.00 75.0 42-000-49-00-4930 TRANSFER FROM WATER IMPRV FUND 0.00 332,340.75 443,121.00 75.0 42-000-49-00-4940 TRANSFER FROM MUNICIPAL BLDG 0.00 76,817.25 102,423.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 1,108,833.00 1,478,444.00 75.0 TOTAL REVENUES: 9,535.25 1,257,165.07 1,611,217.00 78.0 EXPENSES DEBT SERVICE 42-000-66-00-6001 CITY HALL BONDS-PRINCIPAL PMT 0. 00 50,000.00 50, 000.00 100.0 42-000-66-00-6002 CITY HALL BONDS - INTEREST PMT 0.00 52,422.50 52,423.00 99.9 42-000-66-00-6003 IRBB-BRUELL ST. INTEREST PMTS 0.00 83,795.00 83,795.00 100.0 42-000-66-00-6004 IRBB-BRUELL ST. PRINCIPAL PYMT 0.00 80,000.00 80,000.00 100.0 42-000-66-00-6005 NORTH H2O TOWER INTEREST PYMT 0.00 0.00 2,832.00 0.0 42-000-66-00-6006 NORTH H2O TOWER PRINCIPAL PYMT (374.00) (374.00) 22,169.00 (1.6) 42-000-66-00-6007 4.8 MILLION DEBT CERT INT PYMT 0.00 233,150.00 233,150.00 100.0 42-000-66-00-6008 COUNTRYSIDE ALT REV PRINC PYMT 0.00 125,000.00 125,000.00 100.0 42-000-66-00-6009 COUNTRYSIDE ALT REV INT PYMT 0.00 118,012.00 117,638.00 100.3 42-000-66-00-6010 COMED/HYDRAULIC INTEREST PYMT (374.00) 41,328.00 41,328.00 100.0 42-000-66-00-6011 COM ED/HYDRAUL DEBT CERT PRINC 0.00 140,000.00 140,000.00 100.0 42-000-66-00-6045 LOAN PMT - SSES IEPA PRINCIPAL 0.00 0.00 31,275.00 0.0 42-000-66-00-6049 SANITARY SIPHON INTEREST PMT 8,301.00 8,301.00 8,301.00 100.0 42-000-66-00-6050 SANITARY SIPHON-PRINCIPAL PMT (8,301.00) 30,678.98 30,679.00 99.9 42-000-66-00-6055 LOAN PAYMENT-SSES IEPA L171153 0.00 107,050.70 75,775.00 141.2 42-000-66-00-6070 $650K ROAD IMPROV PROG INT 0.00 26,070.00 26,070.00 100.0 42-000-66-00-6071 $650K ROAD IMPROV PROG PRINC (374.50) 65,000.00 65,000.00 100.0 42-000-66-00-6072 $2 MIL ALT REV B.2&3 INT PYMT 0.00 234,139.38 97,923.00 239.1 P30 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 31 TIME: 15:34:11 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: DEBT SERVICE FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL °s ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES DEBT SERVICE 42-000-66-00-6073 2 MIL ALT REV (B.2 & B3) PRINC 0.00 0.00 35,000.00 0.0 42-000-66-00-6074 $3.825 MIL IN TOWN ROAD - INT. 0.00 183,869.71 262,859.00 69.9 42-000-66-00-6075 $3.825 MIL IN TOWN ROAD PRINC 0.00 0.00 30,000.00 0.0 --------------------------------------------------------------------------------- TOTAL DEBT SERVICE (1,122.50) 1,578,443.27 1,611,217.00 97.9 TOTAL FUND REVENUES 9,535.25 1,257,165.07 1,611,217.00 78.0 TOTAL FUND EXPENSES (1,122.50) 1,578,443.27 1,611,217.00 97.9 FUND SURPLUS (DEFICIT) 10,657.75 (321,278.20) 0.00 100.0 P31 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 32 TIME: 15:34:12 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000_WOW FUND: WATER OPERATIONS FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 51-000-40-00-3999 CARRY OVER BALANCE 0.00 600,497.00 600,497.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 600,497.00 600,497.00 100.0 CHARGES FOR SERVICES 51-000-42-00-4240 BULK WATER SALES (572.00) 13,157.78 10,000.00 131.5 51-000-42-00-4241 WATER SALES 10,200.86 1,152,544.92 1,150,000.00 100.2 51-000-42-00-4242 WATER METER SALES 35,050.00 398,753.00 220,000.00 181.2 51-000-42-00-4243 LEASE REVENUE - H2O TOWER 1,966.91 21,320.40 25,000.00 85.2 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 46,645.77 1,585,776.10 1,405,000.00 112.8 MISCELLANEOUS 51-000-44-00-4490 MISCELLANEOUS INCOME 0.00 488.45 2,000.00 24.4 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 488.45 2,000.00 24.4 INTEREST 51-000-46-00-4600 INVESTMENT INCOME 11,918.57 67,977.70 15,000.00 453.1 --------------------------------------------------------------------------------- TOTAL INTEREST 11,918.57 67,977.70 15,000.00 453.1 TOTAL REVENUES: 58,564.34 2,254,739.25 2,022,497.00 111.4 EXPENSES PERSONNEL 51-000-50-00-5107 SALARIES - EMPLOYEE 23,185.72 237,860.50 318,439.00 74.6 51-000-50-00-5136 SALARIES-PART TIME 0.00 2,765.63 3,000.00 92.1 51-000-50-00-5137 SALARIES - OVERTIME 4,192.53 36,757.40 40,000.00 91.8 --------------------------------------------------------------------------------- TOTAL PERSONNEL 27,378.25 277,383.53 361,439.00 76.7 PROFESSIONAL SERVICES 51-000-61-00-5300 LEGAL SERVICES 0.00 0.00 2,000.00 0.0 P32 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 33 TIME: 15:34:12 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: WATER OPERATIONS FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL °s ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES PROFESSIONAL SERVICES 51-000-61-00-5303 JULIE SERVICE 0.00 9,029.15 10,000.00 90.2 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 9,029.15 12,000.00 75.2 CONTRACTURAL SERVICES 51-000-62-00-5401 CONTRACUAL SERVICES 0.00 4,648.78 7, 000.00 66.4 51-000-62-00-5407 TREATMENT FACILITIES 0&M 4,180.67 77,284.53 100,000.00 77.2 51-000-62-00-5408 MAINTENANCE-EQUIPMENT 411.05 6,529.38 9,000.00 72.5 51-000-62-00-5409 MAINTENANCE - VEHICLES 484.34 1,971.28 7,000.00 28.1 51-000-62-00-5411 MAINTENANCE-COMPUTERS 0.00 150.00 1, 000.00 15.0 51-000-62-00-5413 MAINTENANCE-CONTROL SYSTEM 750.00 1,697.50 10,000.00 16.9 51-000-62-00-5421 WEARING APPAREL 225.80 3,926.85 5,500.00 71.3 51-000-62-00-5422 WATER TOWER PAINTING 0.00 0.00 0.00 0.0 51-000-62-00-5434 RENTAL - EQUIPMENT 0.00 240.00 2,000.00 12.0 51-000-62-00-5435 ELECTRICITY 14,902.08 80,791.10 130,000.00 62.1 51-000-62-00-5436 TELEPHONE 2,161.23 32,642.86 35,000.00 93.2 51-000-62-00-5438 CELLULAR TELEPHONE 313.39 3,097.52 5,700.00 54.3 --------------------------------------------------------------------------------- TOTAL CONTRACTURAL SERVICES 23,428.56 212,979.80 312,200.00 68.2 PROFESSIONAL DEVELOPMENT 51-000-64-00-5600 DUES 0.00 1,140.13 1,500.00 76.0 51-000-64-00-5603 SUBSCRIPTIONS 0.00 21.15 250.00 8.4 51-000-64-00-5604 TRAINING & CONFERENCES 0.00 2,177.86 5,000.00 43.5 51-000-64-00-5605 TRAVEL EXPENSES 0.00 448.42 5,000.00 8.9 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 3,787.56 11,750.00 32.2 OPERATIONS 51-000-65-00-5800 CONTINGENCIES 0.00 0.00 30,000.00 0.0 51-000-65-00-5804 OPERATING SUPPLIES 3,446.47 41,881.34 48, 500.00 86.3 51-000-65-00-5808 POSTAGE & SHIPPING 148.91 12,443.63 15,000.00 82.9 51-000-65-00-5809 PRINTING & COPYING 280.00 7,691.35 9,075.00 84.7 51-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 888.95 1,500.00 59.2 51-000-65-00-5812 GASOLINE 2,510.08 27,060.73 28, 000.00 96.6 P33 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 34 TIME: 15:34:13 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: WATER OPERATIONS FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES OPERATIONS 51-000-65-00-5815 HAND TOOLS 0.00 0.00 1,000.00 0.0 51-000-65-00-5817 GRAVEL 426.56 2,858.07 6,000.00 47.6 51-000-65-00-5820 CHEMICALS 8,865.01 50,377.06 34,000.00 148.1 51-000-65-00-5821 CATHODIC PROTECTION 0.00 0.00 0.00 0.0 51-000-65-00-5822 WATER SAMPLES 368.90 10,238.90 12,000.00 85.3 --------------------------------------------------------------------------------- TOTAL OPERATIONS 16,045.93 153,440.03 185,075.00 82.9 --- UNDEFINED CODE --- 51-000-66-00-8200 INTEREST EXPENSE 0.00 (30,050.00) 0.00 (100.0) --------------------------------------------------------------------------------- TOTAL --- UNDEFINED CODE --- 0.00 (30,050.00) 0.00 (100.0) RETIREMENT 51-000-72-00-6500 IMRF PARTICIPANTS 2,083.49 23,469.44 28,317.00 82.8 51-000-72-00-6501 SOCIAL SECURITY & MEDICARE 2,143.22 23,556.52 27,650.00 85.1 --------------------------------------------------------------------------------- TOTAL RETIREMENT 4,226.71 47,025.96 55,967.00 84.0 CAPITAL OUTLAY 51-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 78.00 2,260.77 5,000.00 45.2 51-000-75-00-7004 SAFETY EQUIPMENT 28.90 946.51 2,000.00 47.3 51-000-75-00-7506 METER READERS 766.50 6,352.76 11,500.00 55.2 51-000-75-00-7507 HYDRANT REPLACEMENT 0.00 0.00 6,000.00 0.0 51-000-75-00-7508 METERS & PARTS 26,423.16 201,351.49 265,000.00 75.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 27,296.56 210,911.53 289,500.00 72.8 OTHER 51-000-78-00-9005 REFUND 0.00 0.00 1,500.00 0.0 51-000-78-00-9006 MERIT 0.00 0.00 10,543.00 0.0 51-000-78-00-9008 RESERVE-H2O TOWER MAINTENANCE 0.00 0.00 30,000.00 0.0 51-000-78-00-9009 RESERVE 0.00 0.00 452,523.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 494,566.00 0.0 P34 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 35 TIME: 15:34:13 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: WATER OPERATIONS FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TRANSFERS 51-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 187,500.00 250,000.00 75.0 51-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 0.00 37,500.00 50,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 225,000.00 300,000.00 75.0 TOTAL EXPENSES: 98,376.01 1,109,507.56 2,022,497.00 54.8 TOTAL FUND REVENUES 58,564.34 2,254,739.25 2,022,497.00 111.4 TOTAL FUND EXPENSES 98,376.01 1,109,507.56 2,022,497.00 54.8 FUND SURPLUS (DEFICIT) (39,811.67) 1,145,231.69 0.00 100.0 P35 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 36 TIME: 15:34:13 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: SEWER MAINTENANCE FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 52-000-40-00-3999 CARRY OVER/FUND BALANCE 0.00 657,374.00 350,000.00 187.8 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 657,374.00 350,000.00 187.8 CHARGES FOR SERVICES 52-000-42-00-4240 LIFT STATION INCOME 0.00 19,096.84 8,000.00 238.7 52-000-42-00-4250 SEWER MAINTENANCE FEES 306.81 474,237.40 475,000.00 99.8 52-000-42-00-4251 SEWER CONNNECTION FEES 21,800.00 130,060.00 260,000.00 50.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 22,106.81 623,394.24 743,000.00 83.9 INTEREST 52-000-46-00-4600 INVESTMENT INCOME 11,918.57 68,012.74 15,000.00 453.4 --------------------------------------------------------------------------------- TOTAL INTEREST 11,918.57 68,012.74 15,000.00 453.4 TOTAL REVENUES: 34,025.38 1,348,780.98 1,108,000.00 121.7 EXPENSES PERSONNEL SERVICES 52-000-50-00-5108 SALARIES-REGULAR 9, 970.49 104,187.08 141,858.00 73.4 52-000-50-00-5136 PART TIME 0.00 3,622.40 4,200.00 86.2 52-000-50-00-5137 SALARIES-OVERTIME 102.68 3,174.48 12,000.00 26.4 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 10,073.17 110,983.96 158,058.00 70.2 CONTRACTUAL SERVICES 52-000-62-00-5401 CONTRACTUAL SERVICES 0.00 895.40 4,000.00 22.3 52-000-62-00-5408 MAINTENANCE-EQUIPMENT 767.96 2,476.92 5,000.00 49.5 52-000-62-00-5409 MAINTENANCE-VEHICLES 17.81 1,334.24 4,000.00 33.3 52-000-62-00-5419 MAINTENANCE-SANITARY SEWER 173.62 1,346.29 20,000.00 6.7 52-000-62-00-5421 WEARING APPAREL 225.80 3,661.59 4,200.00 87.1 52-000-62-00-5422 LIFT STATION MAINTENANCE 0.00 10,010.50 20,000.00 50.0 52-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 P36 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 37 TIME: 15:34:14 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.W0W FUND: SEWER MAINTENANCE FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CONTRACTUAL SERVICES 52-000-62-00-5435 ELECTRICITY 0.00 65,834.47 74,400.00 88.4 52-000-62-00-5438 CELLULAR TELEPHONE 313.41 2,976.23 3,500.00 85.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 1,498.60 88,535.64 136,100.00 65.0 PROFESSIONAL DEVELOPMENT 52-000-64-00-5604 TRAINING & CONFERENCES 0.00 40.00 3,000.00 1.3 52-000-64-00-5605 TRAVEL/MEALS/LODGING 603.10 779.40 2,000.00 38.9 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 603.10 819.40 5,000.00 16.3 OPERATIONS 52-000-65-00-5800 CONTINGENCIES 0.00 0.00 10,000.00 0.0 52-000-65-00-5802 OFFICE SUPPLIES 63.46 2,272.24 3,500.00 64.9 52-000-65-00-5805 SHOP SUPPLIES 159.52 1,716.00 2,500.00 68.6 52-000-65-00-5812 GASOLINE 2,510.09 16,330.06 16,000.00 102.0 52-000-65-00-5815 HAND TOOLS 0.00 0.00 2,000.00 0.0 52-000-65-00-5817 GRAVEL 0.00 0.00 3,000.00 0.0 52-000-65-00-5823 SEWER CHEMICALS 0.00 2,073.55 5,000.00 41.4 --------------------------------------------------------------------------------- TOTAL OPERATIONS 2,733.07 22,391.85 42,000.00 53.3 --- UNDEFINED CODE --- 52-000-66-00-8200 INTEREST EXPENSE 0.00 (175,119.00) 0.00 (100.0) --------------------------------------------------------------------------------- TOTAL --- UNDEFINED CODE --- 0.00 (175,119.00) 0.00 (100.0) RETIREMENT 52-000-72-00-6500 IMRF PARTICIPANTS 766.56 8,582.61 12,155.00 70.6 52-000-72-00-6501 SOCIAL SECURITY & MEDICARE 770.60 8,501.14 12,091.00 70.3 --------------------------------------------------------------------------------- TOTAL RETIREMENT 1,537.16 17,083.75 24,246.00 70.4 CAPITAL OUTLAY 52-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 693.00 792.98 2,500.00 31.7 P37 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 38 TIME: 15:34:14 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: SEWER MAINTENANCE FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CAPITAL OUTLAY 52-000-75-00-7003 OFFICE EQUIPMENT 0.00 523.58 6,000.00 8.7 52-000-75-00-7004 SAFETY EQUIPMENT 0.00 1,421.06 2,000.00 71.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 693.00 2,737.62 10,500.00 26.0 OTHER 52-000-78-00-9005 MERIT 0.00 0.00 5,282.00 0.0 52-000-78-00-9009 RESERVE 0.00 0.00 626,814.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 632,096.00 0.0 TRANSFERS 52-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 52,500.00 70,000.00 75.0 52-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 0.00 22,500.00 30,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 75,000.00 100,000.00 75.0 TOTAL EXPENSES: 17,138.10 142,433.22 1,108,000.00 12.8 TOTAL FUND REVENUES 34,025.38 1,348,780.98 111081000.00 121.7 TOTAL FUND EXPENSES 17,138.10 142,433.22 1,108,000.00 12.8 FUND SURPLUS (DEFICIT) 16,887.28 1,206,347.76 0.00 100.0 P38 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 39 TIME: 15:34:14 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: LAND CASH FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 72-000-40-00-3999 CARRY OVER 0.00 (200,757.00) (200,767.00) 99.9 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 (200,757.00) (200,767.00) 99.9 CONTRIBUTIONS 72-000-47-00-4700 OSLAD GRANT 0.00 0.00 128,000.00 0.0 72-000-47-00-4701 GREENBRIAR-LAND CASH 0.00 1,071.00 1,071.00 100.0 72-000-47-00-4703 PRAIRIE GARDEN-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4705 COUNTRY HILLS-LAND CASH 0.00 2,307.00 2,307.00 100.0 72-000-47-00-4707 FOX HIGHLANDS-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4709 SUNFLOWER-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4712 RIVER'S EDGE-LAND CASH 0.00 2,013.00 2,013.00 100.0 72-000-47-00-4715 WHITE OAK UNIT 1&2-LAND CASH 0.00 1,226.00 1,226.00 100.0 72-000-47-00-4716 WHITE OAK UNIT 3&4-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4717 KYLN'S CROSSING-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4718 FOXFIELD II PARK LC 1,688.00 1,688.00 0.00 100.0 72-000-47-00-4719 WILDWOOD-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4722 KYLN'S RIDGE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4723 HEARTLAND CIRCLE-LAND CASH 5,000.00 30,000.00 22,000.00 136.3 72-000-47-00-4725 WINDETTE RIDGE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4727 GRAND RESERVE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4731 MONTALBANO HOMES LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4732 RAINTREE VILLAGE LAND CASH 0.00 133,400.00 133,000.00 100.3 72-000-47-00-4734 WHISPERING MEADOWS (K. HILL) 5,075.01 42,291.75 33,833.00 125.0 72-000-47-00-4735 PRAIRIE MEADOWS(MENARDS RES) 0.00 0.00 0.00 0.0 72-000-47-00-4736 BRIARWOOD 0.00 0.00 0.00 0.0 72-000-47-00-4737 CALEDONIA 0.00 0.00 158,000.00 0.0 72-000-47-00-4738 AUTUMN CREEK 7,705.76 14,841.23 7,135.00 208.0 72-000-47-00-4739 WYNSTONE TOWNHOMES 0.00 0.00 0.00 0.0 72-000-47-00-4740 VILLAS AT THE PRESERVE 0.00 0.00 0.00 0.0 72-000-47-00-4741 BAILEY MEADOWS 0.00 0.00 0.00 0.0 72-000-47-00-4742 BLACKBERRY WOODS 0.00 0.00 0.00 0.0 72-000-47-00-4743 CORNEILS CROSSING 0.00 0.00 0.00 0.0 72-000-47-00-4744 HUDSON LAKES 0.00 0.00 0.00 0.0 72-000-47-00-4745 PRESTWICK 0.00 0.00 0.00 0.0 P39 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 40 TIME: 15:34:15 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: LAND CASH FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL °s ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CONTRIBUTIONS 72-000-47-00-4746 WESTBURY 0.00 0.00 0.00 0.0 72-000-47-00-4747 WESTHAVEN 0.00 0.00 0.00 0.0 72-000-47-00-4748 WILLMAN 0.00 0.00 0.00 0.0 72-000-47-00-4749 BLACKBERRY WOODS 75,000.00 75,000.00 0.00 100.0 --------------------------------------------------------------------------------- TOTAL CONTRIBUTIONS 94,468.77 303,837.98 488,585.00 62.1 TRANSFERS 72-000-49-00-4901 TRANSFER FROM GENERAL FUND 4,949.00 4,949.00 0.00 100.0 72-000-49-00-4902 TRANSFER FROM LAND ACQUISITION 150,000.00 150,000.00 150,000.00 100.0 72-000-49-00-4903 TRANSFER FROM PARK & REC 0.00 0.00 4,949.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 154, 949.00 154,949.00 154,949.00 100.0 TOTAL REVENUES: 249,417.77 258,029.98 442,767.00 58.2 EXPENSES CAPITAL OUTLAY 72-000-75-00-7201 RIVERFRONT BUILDING IMPROV. 0.00 66,495.85 66,496.00 99.9 72-000-75-00-7300 GREENBRIAR 0.00 0.00 0.00 0.0 72-000-75-00-7304 SUNFLOWER 0.00 33,221.10 115,230.00 28.8 72-000-75-00-7308 RIVERS EDGE PARK #2 0.00 0.00 0.00 0.0 72-000-75-00-7311 CANNONBALL ESTATES/KYLIN 0.00 65.00 65.00 100.0 72-000-75-00-7317 HEARTLAND CIRCLE 0.00 0.00 0.00 0.0 72-000-75-00-7324 TOWN SQUARE 0.00 0.00 0.00 0.0 72-000-75-00-7326 MOSIER HOLDING COSTS 0.00 15,685.32 15,686.00 99.9 72-000-75-00-7327 GRANDE RESERVE PARK DEV. 1,821.43 25,972.65 24,152.00 107.5 72-000-75-00-7328 PRAIRIE MEADOWS (MENARDS RES) 1,700.00 16,055.76 14,356.00 111.8 72-000-75-00-7329 ELSIE LOUISE GILBERT PARK 0.00 0.00 0.00 0.0 72-000-75-00-7330 WHISPERING MEADOWS (K. HILL) 0.00 34,578.50 34,579.00 99.9 72-000-75-00-7331 WINDETT RIDGE 0.00 0.00 0.00 0.0 72-000-75-00-7332 CALEDONIA 0.00 0.00 0.00 0.0 72-000-75-00-7333 RAINTREE VILLAGE 0.00 72,538.50 29,258.00 247.9 72-000-75-00-7334 HOOVER HOLDING COSTS 0.00 178,518.32 116,638.00 153.0 P40 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 41 TIME: 15:34:15 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: LAND CASH FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CAPITAL OUTLAY 72-000-75-00-7700 PARK MAINTENANCE FACILITY 0.00 10,306.49 10,307.00 99.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 3,521.43 453,437.49 426,767.00 106.2 OTHER 72-000-78-00-9009 RESERVE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 0.00 0.0 TRANSFERS 72-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 12,000.00 16,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 12,000.00 16,000.00 75.0 TOTAL EXPENSES: 3,521.43 465,437.49 442,767.00 105.1 TOTAL FUND REVENUES 249,417.77 258,029.98 442,767.00 58.2 TOTAL FUND EXPENSES 3,521.43 465,437.49 442,767.00 105.1 FUND SURPLUS (DEFICIT) 245,896.34 (207,407.51) 0.00 100.0 P41 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 42 TIME: 15:34:15 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: LAND ACQUISITION FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL g ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 73-000-40-00-3999 CARRY OVER BALANCE 0.00 213,618.00 213,618.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 213,618.00 213,618.00 100.0 EXPENSES OTHER 73-000-65-00-5800 CONTINGENCY 0.00 0.00 50,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 50,000.00 0.0 TRANSFERS 73-000-99-00-9935 TRANSFER TO LAND CASH 150,000.00 150,000.00 150,000.00 100.0 73-000-99-00-9945 TRANSFER TO MUNICIPAL BUILDING 0.00 0.00 13,618.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 150,000.00 150,000.00 163,618.00 91.6 TOTAL EXPENSES: 150,000.00 150,000.00 213,618.00 70.2 TOTAL FUND REVENUES 0.00 213,618.00 213,618.00 100.0 TOTAL FUND EXPENSES 150,000.00 150,000.00 213,618.00 70.2 FUND SURPLUS (DEFICIT) (150,000.00) 63,618.00 0.00 100.0 P42 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 43 TIME: 15:34:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: PARKS & RECREATION FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 79-000-40-00-3999 CARRY OVER BALANCE 0.00 77,292.00 50,000.00 154.5 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 77,292.00 50,000.00 154.5 CHARGES FOR SERVICES 79-000-42-00-4270 FEES FOR PROGRAMS 20,870.00 233,970.28 218,000.00 107.3 79-000-42-00-4280 CONCESSIONS/ALL SALE ITEMS 225.00 14,357.20 15,000.00 95.7 79-000-42-00-4281 DEPOSITS (200.00) 1,070.00 1,500.00 71.3 79-000-42-00-4285 VENDING MACHINE INCOME 0.00 207.28 250.00 82.9 79-000-42-00-4286 RENTAL INCOME 0.00 445.00 0.00 100.0 79-000-42-00-4287 PARK RENTAL INCOME 35.00 490.00 500.00 98.0 79-000-42-00-4288 GOLF OUTING REVENUE 0.00 40,888.00 40,888.00 100.0 79-000-42-00-4291 HOMETOWN DAYS 0.00 72,543.35 72,545.00 99.9 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 20,930.00 363,971.11 348,683.00 104.3 MISCELLANEOUS 79-000-44-00-4400 DONATIONS 930.00 10,460.57 9,500.00 110.1 79-000-44-00-4404 TREE DONATIONS 300.00 1,405.00 1,105.00 127.1 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 1,230.00 11,865.57 10,605.00 111.8 INTERGOVERNMENTAL 79-000-45-00-4550 YOUTH SERVICES GRANT 0.00 2,000.00 2,000.00 100.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 2,000.00 2,000.00 100.0 INTEREST 79-000-46-00-4600 INVESTMENT INCOME 187.22 10,928.15 10,740.00 101.7 --------------------------------------------------------------------------------- TOTAL INTEREST 187.22 10,928.15 10,740.00 101.7 TRANSFERS 79-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 871,772.50 1,015,107.00 85.8 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 871,772.50 1,015,107.00 85.8 P43 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 44 TIME: 15:34:16 DETAILED REVENUE& EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: PARKS & RECREATION FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL a ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL REVENUES: 22,347.22 1,337,829.33 1,437,135.00 93.0 EXPENSES --- UNDEFINED CODE --- 79-000-99-00-9935 TRANSFER TO LAND CASH 0.00 0.00 4,949.00 0.0 --------------------------------------------------------------------------------- TOTAL --- UNDEFINED CODE --- 0.00 0.00 4,949.00 0.0 PARKS EXPENSES PERSONNAL SERVICES 79-610-50-00-5107 SALARIES-EMPLOYEES 28,254.18 288,490.39 324,571.00 88.8 79-610-50-00-5136 SALARIES - PART-TIME 0.00 40,315.13 48,000.00 83.9 79-610-50-00-5137 SALARIES - OVERTIME 34.35 1,049.17 6,000.00 17.4 --------------------------------------------------------------------------------- TOTAL PERSONNAL SERVICES 28,288.53 329,854.69 378,571.00 87.1 CONTRACTUAL SERVICES 79-610-62-00-5405 PARK CONTRACTUAL 0.00 12,903.94 18,000.00 71.6 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 1,891.27 8,028.90 8,000.00 100.3 79-610-62-00-5417 MAINTENANCE-PARKS 0.00 29,868.20 45,000.00 66.3 79-610-62-00-5421 WEARING APPAREL 445.52 5,473.81 7,000.00 78.1 79-610-62-00-5434 RENTAL-EQUIPMENT 0.00 1,819.41 2,500.00 72.7 79-610-62-00-5438 CELLULAR TELEPHONE 0.00 3,879.94 3,800.00 102.1 79-610-62-00-5440 LAND DEVELOPER 0.00 0.00 0.00 0.0 79-610-62-00-5445 LEGAL EXPENSES 0.00 1,124.50 4,000.00 28.1 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 2,336.79 63,098.70 88,300.00 71.4 PROFESSIONAL DEVELOPMENT 79-610-64-00-5602 PROFESSIONAL GROWTH/SUBSCRPT 338.67 1,159.32 0.00 (100.0) 79-610-64-00-5604 TRAINING & CONFERENCE 0.00 0.00 4,800.00 0.0 79-610-64-00-5605 TRAVEL EXPENSE 3,095.82 4,284.66 3,800.00 112.7 79-610-64-00-5612 CONTINUING EDUCATION 0.00 3,563.74 4,200.00 84.8 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 3,434.49 9,007.72 12,800.00 70.3 P44 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 45 TIME: 15:34:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: PARKS & RECREATION FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PARKS OPERATIONS 79-610-65-00-5802 OFFICE SUPPLIES 0.00 430.99 1,500.00 28.7 79-610-65-00-5804 OPERATING SUPPLIES 577.59 23,448.15 32,000.00 73.2 79-610-65-00-5812 GASOLINE 0.00 1,041.81 3,500.00 29.7 79-610-65-00-5815 HAND TOOLS 17.99 2,299.59 3,000.00 76.6 79-610-65-00-5824 CHRISTMAS DECORATIONS 4, 620.00 6,628.78 7,000.00 94.6 79-610-65-00-5825 PUBLIC DECORATION 0.00 1,064.34 3,000.00 35.4 --------------------------------------------------------------------------------- TOTAL OPERATIONS 5,215.58 34,913.66 50,000.00 69.8 RETIREMENT 79-610-72-00-6500 IMRF PARTICIPANTS 2,152.72 22,611.39 28,000.00 80.7 79-610-72-00-6501 SOCIAL SECURITY/MEDICARE 2,153.01 25,085.76 31,000.00 80.9 --------------------------------------------------------------------------------- TOTAL RETIREMENT 4,305.73 47,697.15 59,000.00 80.8 CAPITAL OUTLAY 79-610-75-00-7003 OFFICE EQUIPMENT 0.00 1,420.94 6,000.00 23.6 79-610-75-00-7701 FLOWERS/TREES 0.00 1,711.52 7,000.00 24.4 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 3,132.46 13,000.00 24.0 OTHER 79-610-78-00-9005 MERIT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 0.00 0.0 TOTAL EXPENSES: PARKS 43,581.12 487,704.38 601,671.00 81.0 RECREATION EXPENSES PERSONNEL SERVICES 79-650-50-00-5107 EMPLOYEE SALARIES 27,883.66 312,002.10 356,002.00 87.6 79-650-50-00-5108 CONCESSION STAFF 58.50 2,533.61 4,000.00 63.3 79-650-50-00-5109 PRE SCHOOL SALARIES 5,860.00 53,380.35 55,000.00 97.0 P45 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 46 TIME: 15:34:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: PARKS & RECREATION FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ RECREATION EXPENSES PERSONNEL SERVICES 79-650-50-00-5137 SALARIES-OVERTIME 0.00 0.00 0.00 0.0 79-650-50-00-5150 SALARIES-INSTRUCTOR CONTRACTUA 6,399.13 64,542.07 65,000.00 99.2 79-650-50-00-5155 SALARIES-RECORDING SECRETARY 158.00 2,247.50 2,400.00 93.6 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 40,359.29 434,705.63 482,402.00 90.1 CONTRACTUAL SERVICES 79-650-62-00-5408 MAINTENANCE SUPPLIES 975.36 5,217.56 5,000.00 104.3 79-650-62-00-5409 MAINTENANCE-VEHICLES 181.95 1,946.51 1,765.00 110.2 79-650-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 0.00 6,352.74 6,500.00 97.7 79-650-62-00-5426 YOUTH SERVICES GRANT EXPENSES 0.00 231.21 2,000.00 11.5 79-650-62-00-5437 TELEPHONE/INTERNET 27.80 1,543.91 1,600.00 96.4 79-650-62-00-5438 CELLULAR TELEPHONE 0.00 3,918.34 4,700.00 83.3 79-650-62-00-5445 PORTABLE TOILETS 0.00 2,567.97 3,500.00 73.3 79-650-62-00-5603 PUBLISHING/ADVERTISING 5,414.36 21,488.71 25,700.00 83.6 79-650-62-00-5605 BOOKS/PUBLICATIONS 199.03 580.53 750.00 77.4 79-650-62-00-5606 PARK DEPOSIT REFUND 0.00 4,145.00 4,145.00 100.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 6,798.50 47,992.48 55,660.00 86.2 PROFESSIONAL DEVELOPMENT 79-650-64-00-5600 DUES 0.00 2,371.60 2,700.00 87.8 79-650-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 0.00 458.00 0.00 (100.0) 79-650-64-00-5604 TRAINING AND CONFERENCES 318.76 7,579.96 8,000.00 94.7 79-650-64-00-5605 TRAVEL EXPENSE 174.29 1,576.99 2,500.00 63.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 493.05 11,986.55 13,200.00 90.8 OPERATIONS 79-650-65-00-5802 OFFICE SUPPLIES 83.70 6,852.40 7,000.00 97.8 79-650-65-00-5803 PROGRAM EXPENSES 660.45 48,646.18 50,000.00 97.2 79-650-65-00-5804 OPERATING SUPPLIES 1,199.46 2,858.62 4,200.00 68.0 79-650-65-00-5805 RECREATION EQUIPMENT 0.00 3,531.63 4,000.00 88.2 79-650-65-00-5808 POSTAGE & SHIPPING 0.00 6,502.85 7,200.00 90.3 79-650-65-00-5812 GASOLINE 247.21 3,311.97 3,600.00 91.9 P46 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 47 TIME: 15:34:18 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: PARKS & RECREATION FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ RECREATION EXPENSES OPERATIONS 79-650-65-00-5826 MILEAGE 0.00 390.94 500.00 78.1 79-650-65-00-5827 GOLF OUTING EXPENSES 0.00 22,177.31 22,177.00 100.0 79-650-65-00-5828 CONCESSIONS 350.00 10,628.11 11,000.00 96.6 79-650-65-00-5833 HOMETOWN DAYS EXPENSES 0.00 78,862.84 78, 863.00 99.9 79-650-65-00-5840 SCHOLARSHIPS 0.00 412.60 3,600.00 11.4 79-650-65-00-5841 PROGRAM REFUND 542.66 8, 120.41 8, 000.00 101.5 --------------------------------------------------------------------------------- TOTAL OPERATIONS 3,083.48 192,295.86 200,140.00 96.0 RETIREMENT 79-650-72-00-6500 IMRF PARTICIPANTS 2,308.51 26,163.24 26,666.00 98.1 79-650-72-00-6501 SOCIAL SECURITY/MEDICARE 2,833.68 30,471.29 35,544.00 85.7 --------------------------------------------------------------------------------- TOTAL RETIREMENT 5,142.19 56,634.53 62,210.00 91.0 CAPITAL OUTLAY 79-650-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 5,296.51 5,300.00 99.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 5,296.51 5,300.00 99.9 OTHER 79-650-78-00-9005 MERIT 0.00 0.00 0.00 0.0 79-650-78-00-9009 RESERVE 0.00 16,835.00 11,603.00 145.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 16,835.00 11,603.00 145.0 TOTAL EXPENSES: RECREATION 55,876.51 765,746.56 830,515.00 92.2 TOTAL FUND REVENUES 22,347.22 1,337,829.33 1,437, 135.00 93.0 TOTAL FUND EXPENSES 99,457.63 1,253,450.94 1,437,135.00 87.2 FUND SURPLUS (DEFICIT) (77,110.41) 84,378.39 0.00 100.0 P47 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 48 TIME: 15:34:18 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B30OO.WOW FUND: LIBRARY FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL °s ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES TAXES 82-000-40-00-3996 CARRY OVER- BOOK DEV FEES 0.00 102,125.00 102,125.00 100.0 82-000-40-00-3997 CARRY OVER - BLDG DEV FEES 0.00 1,557,975.41 5,461,107.00 28.5 82-000-40-00-3998 CARRY OVER-MEMORIALS 0.00 1,522.00 1,522.00 100.0 82-000-40-00-3999 CARRY OVER BALANCE 0.00 5,461,107.00 1,557,975.00 350.5 82-000-40-00-4000 REAL ESTATE TAXES 0.00 385,935.43 464,741.00 83.0 82-000-40-00-4010 PERSONAL PROPERTY TAX 0.00 3,182.15 2,500.00 127.2 82-000-40-00-4015 TRANSFER FROM GENERAL FUND 8,862.50 32,312.50 35,250.00 91.6 --------------------------------------------------------------------------------- TOTAL TAXES 8,862.50 7,544,159.49 7,625,220.00 98.9 CHARGES FOR SERVICES 82-000-42-00-4211 DEVELOPMENT FEES - BUILDING 7,700.00 86,300.00 95,000.00 90.8 82-000-42-00-4215 DEVELOPMENT FEES - BOOKS 22,379.00 71,621.00 95,000.00 75.3 82-000-42-00-4260 COPY FEES 234.70 1,232.00 900.00 136.8 82-000-42-00-4261 LIBRARY SUBSCRIPTION CARDS 2,008.95 11,689.00 8,000.00 146.1 82-000-42-00-4286 RENTAL INCOME 451.99 1,549.59 1,000.00 154.9 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 32,774.64 172,391.59 199,900.00 86.2 FINES 82-000-43-00-4330 LIBRARY FINES 729.86 4,597.21 3,000.00 153.2 --------------------------------------------------------------------------------- TOTAL FINES 729.86 4,597.21 3,000.00 153.2 MISCELLANEOUS 82-000-44-00-4432 SALE OF BOOKS 72.00 857.69 500.00 171.5 82-000-44-00-4450 MEMORIALS 180.00 6,636.50 5,000.00 132.7 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 252.00 7,494.19 5,500.00 136.2 INTERGOVERNMENTAL 82-000-45-00-4550 GRANTS 0.00 0.00 1,000.00 0.0 82-000-45-00-4560 LIBRARY PER CAPITA GRANT 0.00 0.00 7,700.00 0.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 0.00 8,700.00 0.0 P48 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 49 TIME: 15:34:18 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: LIBRARY FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL °s ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ INTEREST 82-000-46-00-4600 INVESTMENT INCOME 1, 686.28 26,309.98 1, 500.00 1753.9 82-000-46-00-4601 INVESTMENT INCOME-BLDG 3,988.66 123,886.14 100,000.00 123.8 --------------------------------------------------------------------------------- TOTAL INTEREST 5,674.94 150,196.12 101,500.00 147.9 TOTAL REVENUES: 48,293.94 7,878,838.60 7,943,820.00 99.1 EXPENSES PERSONNEL SERVICES 82-000-50-00-5107 SALARIES-EMPLOYEES 27,233.68 235,494.31 332,950.00 70.7 82-000-50-00-5203 GROUP HEALTH INSURANCE 0.00 36,231.93 55,000.00 65.8 82-000-50-00-5204 GROUP LIFE INSURANCE 0.00 723.45 2,000.00 36.1 82-000-50-00-5205 DENTAL & VISION ASSISTANCE 0.00 3,055.42 6,000.00 50.9 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 27,233.68 275,505.11 395,950.00 69.5 PROFESSIONAL SERVICES 82-000-61-00-5322 BONDING 0.00 1,875. 00 2, 000.00 93.7 82-000-61-00-5323 ATTORNEY 0.00 0.00 2,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 1,875.00 4,000.00 46.8 CONTRACTUAL SERVICES 82-000-62-00-5401 CONTRACT SERVICES 140.57 2,179.06 3,000.00 72.6 82-000-62-00-5407 MAINTENANCE-BLDG/JANITORIAL 804.57 5,327.05 6,500.00 81.9 82-000-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT (1,160.18) 2,470.39 4,500.00 54.8 82-000-62-00-5412 MAINTENANCE-PHOTOCOPIER 67.49 197.05 1,000.00 19.7 82-000-62-00-5435 ELECTRICITY 0.00 206.94 2,500.00 8.2 82-000-62-00-5436 TELEPHONE (51.60) 1,757.70 2,700.00 65.1 82-000-62-00-5437 GAS HEAT 0.00 0.00 7,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES (199.15) 12,138.19 27,200.00 44.6 PROFESSIONAL DEVELOPMENT 82-000-64-00-5603 SUBSCRIPTIONS 659.00 3,478.38 4,000.00 86.9 P49 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 50 TIME: 15:34:19 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000_W0W FUND: LIBRARY FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES PROFESSIONAL DEVELOPMENT 82-000-64-00-5604 TRAINING & CONFERENCES 0.00 60.00 1,500.00 4.0 82-000-64-00-5607 PUBLIC RELATIONS 135.00 978.13 1,000.00 97.8 82-000-64-00-5616 EMPLOYEE RECOGNITION (464.41) 1,615.71 2,100.00 76.9 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 329.59 6,132.22 8,600.00 71.3 OPERATIONS 82-000-65-00-5800 CONTINGENCIES 818.43 15,046.15 22,031.00 68.2 82-000-65-00-5802 OFFICE SUPPLIES (570.07) 5,685.63 7,500.00 75.8 82-000-65-00-5806 LIBRARY SUPPLIES (1,190.53) 5,750,35 9,200.00 62.5 82-000-65-00-5807 CUSTODIAL SUPPLIES (3,796.68) 7,785.58 13,000.00 59.8 82-000-65-00-5808 POSTAGE & SHIPPING 0.00 574.12 1,000.00 57.4 82-000-65-00-5810 PUBLISHING & ADVERTISING (285.95) 333.15 1,000.00 33.3 82-000-65-00-5826 MILEAGE 0.00 373.13 1,000.00 37.3 82-000-65-00-5832 VIDEOS (232.67) 3,353.84 5,000.00 67.0 82-000-65-00-5833 ALARM MONITORING 0.00 488.95 1,000.00 48.8 82-000-65-00-5834 LIBRARY PROGRAMMING 756.84 3,456.02 12,000.00 28.8 82-000-65-00-5835 LIBRARY BOARD EXPENSES 504.41 665.59 1,000.00 66.5 82-000-65-00-5836 BOOKS-ADULT 0.00 9,188.81 10,000.00 91.8 82-000-65-00-5837 BOOKS-JUVENILE (2.60) 4,461.97 10,000.00 44.6 82-000-65-00-5838 BOOKS-AUDIO 626.44 1,651.18 10,000.00 16.5 82-000-65-00-5839 BOOKS-REFERENCE (4,078.73) 8,787.22 16,000.00 54.9 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE (3,290.40) 37,448.30 95,000.00 39.4 82-000-65-00-5841 MEMORIALS/GIFTS (291.50) 3,124.41 5,000.00 62.4 82-000-65-00-5842 BLDG-DEVELOPMENT FEES 0.00 6,495.00 95,000.00 6.8 82-000-65-00-5843 GRANT EXPENSE 0.00 0.00 1,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS (11,033.01) 114,669.40 315,731.00 36.3 RETIREMENT 82-000-72-00-6500 IMRF PARTICPANTS 872.27 9,134.81 9,250.00 98.7 82-000-72-00-6501 SOCIAL SECURITY/MEDICARE 2,083 .42 18,014.84 26,250.00 68.6 --------------------------------------------------------------------------------- TOTAL RETIREMENT 2,955.69 27,149.65 35,500.00 76.4 P50 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 51 TIME: 15:34:19 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: LIBRARY FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ CAPITAL OUTLAY 82-000-75-00-7003 AUTOMATION 6, 869.34 24,502.59 164,700.00 14.8 82-000-75-00-7703 BUILDING EXPANSION 275,604.97 5,864,098.28 6,992,139.00 83.8 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 282,474.31 5,888,600.87 7,156,839.00 82.2 TOTAL EXPENSES: 301,761.11 6,326,070.44 7,943,820.00 79.6 TOTAL FUND REVENUES 48,293.94 7,878,838.60 7,943,820.00 99.1 TOTAL FUND EXPENSES 301,761.11 6,326,070.44 7,943,820.00 79.6 FUND SURPLUS (DEFICIT) (253,467.17) 1,552,768.16 0.00 100.0 P51 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 52 TIME: 15:34:20 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: FOX INDUSTRIAL FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES TAXES 85-000-40-00-3999 CARRY OVER BALANCE 0.00 32,799.00 32,799.00 100.0 85-000-40-00-4090 TIF REVENUES 0.00 130,078.44 75,000.00 173.4 --------------------------------------------------------------------------------- TOTAL TAXES 0.00 162,877.44 107,799.00 151.0 INTEREST 85-000-46-00-4600 INVESTMENT INCOME 477.69 4,907.76 3,000.00 163.5 --------------------------------------------------------------------------------- TOTAL INTEREST 477.69 4,907.76 3,000.00 163.5 TRANSFERS 85-000-49-00-4905 TRANSFER FROM MFT FUND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL REVENUES: 477.69 167,785.20 110,799.00 151.4 EXPENSES DEBT SERVICES 85-000-66-00-6021 FOX IND BOND-PRINCIPAL PMT 0.00 60,000.00 60,000.00 100.0 85-000-66-00-6022 FOX IND BOND-INT PAYMENT 0.00 20,415.00 20,415.00 100.0 --------------------------------------------------------------------------------- TOTAL DEBT SERVICES 0.00 80,415.00 80,415.00 100.0 CAPITAL OUTLAY 85-000-75-00-7901 FOX INDUSTRIAL - NON MFT 0.00 0.00 0.00 0.0 85-000-75-00-7902 FOX INDUSTRIAL EXPENSES 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.0 OTHER 85-000-78-00-9007 ADMINSITRATION FEES 17.75 283.50 300.00 94.5 85-000-78-00-9010 RESERVE-FUTURE BOND PYMTS 0.00 0.00 30,084.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 17.75 283.50 30,384.00 0.9 P52 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 53 TIME: 15:34:20 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: FOX INDUSTRIAL FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL EXPENSES: 17.75 80,698.50 110,799.00 72.8 TOTAL FUND REVENUES 477.69 167,785.20 110,799.00 151.4 TOTAL FUND EXPENSES 17.75 80,698.50 110,799.00 72.8 FUND SURPLUS (DEFICIT) 459.94 87,086.70 0.00 100.0 P53 DATE: 04/24/2007 UNITED CITY OF YORKVILLE PAGE: 54 TIME: 15:34:20 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL4B3000.WOW FUND: COUNTRYSIDE TIF PROJECT FOR 11 PERIODS ENDING MARCH 31, 2007 REVISED FISCAL FISCAL °s ACCOUNT MARCH YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 87-000-40-00-3999 CARRY OVER BALANCE 0.00 3,463,672.00 3,463,672.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 3,463,672.00 3,463,672.00 100.0 INTEREST 87-000-46-00-4600 INVESTMENT INCOME 8,084.91 90,992.34 75,000.00 121.3 --------------------------------------------------------------------------------- TOTAL INTEREST 8,084.91 90,992.34 75,000.00 121.3 TOTAL REVENUES: 8,084.91 3,554,664.34 3,538,672.00 100.4 EXPENSES OTHER FINANCING 87-000-66-00-6002 COUNTRYSIDE TIF-INTEREST PMT 0.00 0.00 0.00 0.0 87-000-66-00-6022 BOND - INT PAYMENT 0.00 142,867.50 142,868.00 99.9 --------------------------------------------------------------------------------- TOTAL OTHER FINANCING 0.00 142,867.50 142,868.00 99.9 OTHER 87-000-78-00-9007 ADMINISTRATION FEES 0.00 18.60 2,500.00 0.7 87-000-78-00-9009 RESERVE 0.00 0.00 0.00 0.0 87-000-78-00-9010 RESERVE - FUTURE BOND PAYMENT 0.00 500,000.00 3,393,304.00 14.7 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 500,018.60 3,395,804.00 14.7 TOTAL EXPENSES: 0.00 642,886.10 3,538,672.00 18.1 TOTAL FUND REVENUES 8,084.91 3,554,664.34 3,538,672.00 100.4 TOTAL FUND EXPENSES 0.00 642,886.10 3,538,672.00 18.1 FUND SURPLUS (DEFICIT) 8,084.91 2,911,778.24 0.00 100.0 P54 O'D C/ry Reviewed By: Legal E] City Council Finance ❑ ig-D KY) EST. `� 1836 Engineer ❑ "�- Agenda Item Tracking Number ,f y City Administrator ❑ Consultant ❑ �`�I� i'V1 �G 7 — 3 7 City Council Agenda Item Summary Memo Title: March Treasurer's Report City Council/Committee of the Whole Date: COW 5/1/07 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Jennifer Milewski Finance Name Department Agenda Item Notes: United City of Yorkville Monthly Treasurer's Report Pre Audit Financial Summary As of March 31, 2007 FY FY Beginning March March Ending FYTD Budeted FYTD Budgeted Fund Balance Revenues Expenses Balance Revenues Revenue Expenses Expenses 01 General * 5,364,989 1,385,395 1,599,989 5,150,395 12,261,517 16,577,395 10,348,749 16,577,395 15 Motor Fuel Tax 443,649 30.506 30.766 443,389 819,368 635,827 333,980 635,827 16 Municipal Building (304,401) 6,550 1.768 (299,619) (98,437) 260,188 201,181 260,188 20 PD Capital 200,354 20,533 0 220,887 381,736 468,174 160,849 468,174 21 PW Capital 621,320 35,700 55,676 601,344 964,955 730,000 363,611 730,000 22 Parks&Rec Equip Capital 105,774 0 792 104,982 177.154 197,454 72,172 197,454 37 Sanitary Sewer Improvement 1,234,196 710,796 521,035 1,423,957 8,987,742 10,526,800 4,863,630 10,526,800 41 Water Improvement Exp 2,166 220,794 144,858 78,101 4,225347 7,800,245 2,726.475 7,800,245 42 Debt Service (366,431) 10.658 0 (355,773) 1,257,165 1,611,217 1,578,443 1,611,217 51 Water 1,233,214 136,181 302,561 1,066,834 2,254,739 2,022,497 1,109,508 2,022,497 52 Sewer 1,054,532 73,985 106,132 1,022,385 1,348,781 1,108,000 142,433 1,108,000 72 Land Cash (453,304) 249,418 3,521 (207,408) 258,030 442,767 465,437 442,767 73 Land Acquisition 213,618 0 150,000 63,618 213.618 213,618 150,000 213,618 79 Parks&Recreation 111,326 35,773 100,809 46,291 1337,829 1,437,135 1,253,451 1,437,135 82 Library 1,806,236 367,958 621,425 1,552,768 7.878,839 7,943,820 6,326,070 7,943,820 85 Fox Industrial 86,627 478 18 87,087 167,785 110,799 80,699 110,799 87 Countryside TIF Project 2,903,693 8,085 0 2,911,778 3,554,664 3,538,672 642,886 3,538,672 95 Trust&Agency 1,485,776 291,749 1,656,494 121,032 2,976,953 0 2,631,241 0 Totals 15,743,332 3,584,560 5,295,843 14,032,048 48,967,785 55,624,608 33,450,815 55,624,608 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. Full detail detail i/nfffoormation is a 'able in the Finance Departme William Powell,Treasurer *Beginning balances updated to reflect entries posted to previous periods per reconciliations Prepared by:Jennifer Milewski-Senior Accounting Clerk 4/18/2007 cip Reviewed By: J= �� Legal ❑ City Council g Finance ❑ EST. "� 1836 Engineer ❑ City Administrator F1 Agenda Item Tracking Number Consultant ❑ T) Gy l -,139 City Council Agenda Item Summary Memo Title: Petty Cash Policy City Council/Committee of the Whole Date: COW 5/01/07 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Approve the Petty Cash Policy Submitted by: Susan Mika Finance Name Department Agenda Item Notes: United City of Yorkville Petty Cash Policy Policy Statement This policy sets forth the procedures for the handling of petty cash monies located in several departments within the City of Yorkville. Departments are responsible for adequate security and control of their petty cash funds. These funds should be secure at all times in a locked place. Since there is no insurance available to cover losses from the fund, theft and any other losses of petty cash are the responsibility of the department. Purpose and Use Petty cash can be used by individuals for non-travel, out-of-pocket expenditures up to $25.00 per transaction. Petty cash can be used in place of the City's purchasing process where appropriate, for example, for the purchase of or reimbursement for small incidental department expenses when it is infeasible or impractical to use normal purchasing means. Petty cash should be used in this manner only when absolutely necessary. Examples of acceptable uses of Petty Cash: ➢ Background Checks ➢ Copies ➢ Postage ➢ Highway Tolls ➢ Admission/Entry fees ➢ Other with department head approval Prohibitions Petty cash should NOT be used for the following: ➢ Travel advances and expense reimbursements (submit travel reimbursement claim forms through Accounts Payable) ➢ Payment to vendors when invoices can be received and processed through Accounts Payble ➢ Payments to independent contractors, consultants, or non-City employees. These should be processed through the Accounts Payable for processing and payment ➢ Payments to employees for services, awards, bonuses ➢ Personal borrowing or the cashing of personal checks Initiating a Petty Cash Fund A Department Head should send a memo or e-mail request to the Finance Director stating the purpose and use of the fund. A custodian, aside from the Department Head, should be named at this time along with the requested amount for the fund to be established. The final amount of the fund should be no more than $100. Responsibilities of the custodian include the following: ➢ Ensure that this fund is used to cover only those expense items for which it is not possible, or is infeasible or impractical to use normal purchasing methods. ➢ Ensure that fund use is consistent with the manner described in the documentation that initially established the fund. ➢ Perform a full reconciliation of the fund monthly, which will be provided to the Finance Department. This includes utilizing the petty cash master spreadsheet provided by the Finance department. ➢ Handle fund replenishment. ➢ Ensure the sum of vouchers and cash on hand total the amount of the fund establishment at all times. ➢ Ensure vouchers are not submitted and approved by the same person. Petty Cash Custodian The petty cash fund should be secured at all times. It is the responsibility of the department head to appoint a staff member as custodian to monitor its use and replenishment. A custodian should be appointed by the department head; a custodian cannot appoint or approve himself/herself. Changing the Fund Amount Should a situation arise where it is determined that the size of the petty cash fund should be increased or decreased, a memo should be forwarded to the Finance Director requesting this change. An increase to petty cash fund is subject to the approval of the Finance Director, as well as the Department Head. Closing a Petty Cash Account The petty cash fund should be closed when the purpose for which the fund was established has been complete, as determined by the Department Head or the Finance Director. In addition, the Finance Department may conduct periodic usage reviews and, based on the results, can request closure or reduction of the fund. When closing the fund, the Department Head should submit all remaining funds to the Finance Department for deposit. Audit Each petty cash transaction will be subject to audit by the Finance Department. In addition, the Finance Department and/or external auditors may perform periodic unannounced audits of the fund to ensure proper control is maintained. If misuse of the Fund is found in violation of established policies, the Finance Director may recommend closure of the petty cash fund. If a recommendation is made to close the account, the discussion will be brought to the City Administrator for a final decision. STATE OF ILLINOIS ) )ss COUNTY OF KENDALL ) RESOLUTION NO. 2007- RESOLUTION APPROVING A PETTY CASH POLICY WHEREAS, the City Council of the United City of Yorkville has considered and discussed establishing a policy concerning the handling of petty cash monies, and WHEREAS,the City Council has determined that it desires to establish such a policy, and WHEREAS,the text of the policy the City Council now desires to establish concerning Petty Cash is set forth on the attached Exhibit"A"which is incorporated herein, and NOW THEREFORE,upon Motion duly made, seconded and approved by the majority of those members of the City Council voting, the Petty Cash Policy is hereby approved by the City Council of the United City of Yorkville in the form set forth on Exhibit"A" attached hereto and incorporated herein. JAMES BOCK JOSEPH BESCO VALERIE BURD PAUL JAMES GARY GOLINSKI MARTY MUNNS ROSE SPEARS JASON LESLIE Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this day of ,A.D. 2007. MAYOR Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this day of , A.D. 2007. ATTEST: CITY CLERK Prepared by: John Justin Wyeth City Attorney United City of Yorkville 800 Game Farm Road Yorkville, IL 60560 k4 0 United City of Yorkville 800 Game Farm Road M -� 1836 Yorkville, Illinois, 60560 S� ■� oy Telephone: 630-553-4350 SCE Date: April 25,2007 To: Mayor and City Council From: John H. Crois,Interim City Administrator Subject: Comp Time The City Council has requested that staff review the policy of allowing nonunion employees to accrue up to 240 hours of comp time. This matter has been discussed at a Department Head staff meeting. The discussion resulted in a number of variables and options which require research and review. Susan Mika and Bart Olson have been directed to review the various cost factors and present the option at a staff session for further discussion. A position memo, laying out pros and cons of the issue,and a draft policy proposal will be presented at your June Administrative Committee Meeting. C1Ty Reviewed By: J� R �-�► Legal ❑ City Council ❑ Finance �}D L11 EST. _ Engineer ❑ ~ City Administrator El Agenda Item Tracking Number �,. H D 1) S► `�O Consultant ❑ City Council Agenda Item Summary Memo Title: Verification of Driver's License for City Employees City Council/Committee of the Whole Date: COW 5/1/07 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Denise Kasper Human Resources Manager Name Agenda Item Notes: CIT D United City of Yorkville Memo 800 Game Farm Road EST -1 1836 Yorkville, Illinois 60560 Telephone: 630-553-4350 .p p Fax: 630-553-7575 SCE 1�'v Date: April 25, 2007 To: Committee of the Whole From: Denise Kasper, Human Resources Manager Re: Valid Drivers License Staff has been requested to research a policy related to driver's license audits. I have spoken to legal council and they have notified me that it is permissible under management rights to audit the status of employee's driver's license that currently operate city vehicles on a daily basis. At this time Chief Martin is researching the time and dollar amount that will need to be allocated should this policy move forward. Listed below is the pertinent section of the employee manual that relate to this topic and the suggested addition. Current Employee Manual(Appendix I.III Criteria,C.) Current Employee Driving Standard. Employees who currently drive a city vehicle or their own vehicle on city business must maintain a valid driver's license,vehicle insurance and with good driving record. The city recognizes that drivers who consistently violate state motor vehicle codes expose themselves and the community to potential bodily injury and/or property damage. Proposed Addition Any employee whose driver's license is revoked or suspended while employed with the city is required to notify their department head within 24 hours of the incident. In addition those employees whose job description requires them to hold a valid drivers license will be subjected to an annual audit to be conducted by the Police Department. C/T� Reviewed By: Agenda Item Number J' �-�► Legal ❑ Finance ❑ r� EST isss Engineer ❑ ED M -C City Administrator ❑ Tracking Number O Consultant ❑ LE �`'♦♦ Human Resources -7 City Council Agenda Item Summary Memo Title: Video recorder fees discussion City Council/COW Agenda Date: COW May 1, 2007 Synopsis: See attached memo. Council Action Previously Taken: Date of Action: N/A Action Taken: Item Number: Type of Vote Required: N/A Council Action Requested: Discussion and further direction Submitted by: Bart Olson Administration Name Department Agenda Item Notes: 1p.o United City of Yorkville Memo 800 Game Farm Road Esr. 1836 Yorkville, Illinois 60560 Telephone: 630-553-4350 o ;t �p Fax: 630-553-7575 <LE Date: April 25, 2007 To: Committee of the Whole From: Bart Olson, Assistant City Administrator CC: Glory Spies, Community Relations Officer Subject: Video Recorder fees discussion The current compensation for the video recorder is broken down on a per meeting basis. If the meeting lasts 3 hours or shorter,the compensation is set at$50. If the meeting lasts longer than 3 hours, the compensation is set at $100. As it works out hourly,the current system pays the recorder—$17 per hour at minimum and—$33 per hour at maximum. For the "Inside Yorkville"tapings, the recorder is compensated at$250 for each episode. Each episode requires 6-8 hours of work. In researching how other municipalities record their meetings and how they compensate the individual or company, I found a few different methods. The first method, and most common according to my survey, is to have a city employee record the meetings. The person that does this in other municipalities may be dedicated solely to video production(as in Naperville), or may be a staff member who accepts the duties "as assigned" (Morton Grove and Skokie). In Naperville, the"Video Production Specialist"has a range of$16.45 to $23.85 per hour. The second method is to contract with a company to record all meetings. The Village of Bartlett has contracted with a company to record 60 meetings a year. For Bartlett, said company quoted 1 person for 60 meetings per year at $11,700, and Bartlett entered into a contract for 2 persons for 60 meetings per year at$23,000 total. Each meeting past the 60th meeting is billed at $65 per hour. The final method found is the method we use, which is to contract with an individual affiliated with our local cable consortium. I have shared our method of service to an employee in Buffalo Grove, who has indicated she would be pursuing the method we use when she begins to start video taping Buffalo Grove's meetings (as opposed to hiring someone or contracting with a company). In talking to staff, a fourth method has been discussed; purchasing a stand-alone camera and filming the meetings without an employee/contractor operating the camera. This could be done for less than $1,000 in one-time hardware costs. While this would not present the most exciting presentation of City Council meetings, it appears to be the most cost effective. Since this discussion is a City Council initiative, staff is looking for further direction on the topic. Cl?, Reviewed By: Agenda Item Number �-c► Legal ❑ Finance ❑ EST. � _...:,_1$36 Engineer ❑ -4 City Administrator ❑ Tracking Number !' , : Consultant ❑ C ALE" ,��,� Human Resources El _ ADM �.� OD7 —� l City Council Agenda Item Summary Memo Title: Minute takers' hourly rate City Council/COW Agenda Date: COW May 1, 2007 Synopsis: See attached memo. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: N/A Council Action Requested: Discussion and direction on hourly rate Submitted by: Bart Olson Administration Name Department Agenda Item Notes: C/r o United City of Yorkville Memo 800 Game Farm Road EST 1 1836 Yorkville, Illinois 60560 Telephone: 630-553-4350 Fax: 630-553-7575 <LE Date: April 26, 2007 To: Committee of the Whole From: Bart Olson, Assistant City Administrator CC: Jackie Milschewski, City Clerk Subject: Minute-takers' hourly rate I have attached a memo from Jackie Milschewski, City Clerk, dated September 2, 2003. The minute takers' hourly rate is outlined in the memo. Based on the fact that minute takers' hourly rate has not been adjusted since 2003, I feel it would be prudent to make an adjustment at this time. Last week, I talked to representatives from a few area municipalities,who indicated their minute takers' hourly rate (whether done by an in-house employee or contracted out)were in the $20 per hour range. Yorkville's hourly rate, based on any meeting that lasts longer than 1 hour is $13.16 per hour. UNITED CITY OF YORKVILLE From the Desk of jgckl; XItischewski City Clerk FS � � 7 P — 2 2003 September 2, 2003 By TO: All Minute Takers RE: Salary At the August 26, 2003 City Council meeting,the Council approved a salary increase for the minute takers. The base pay will now be $35.00 for up to a two-hour meeting. The rate for any time over two hours will be $17.50/hour. Transcription time is still $10.00/hour however it will be based on twice the length of the meeting. For example,transcription time for a one-hour meeting will be two hours or$20.00. The Council has asked that every effort be made to have minutes returned in a timely manner. Please return minutes at least one week before the next scheduled Committee meeting. Also,please reference the meeting start and end time on your invoices to the city. If you have any questions,please feel free to contact me at 630-553-8537 Thanks, Jackie Cc: Kim King, Accounting Clerk STATE OF ILLINOIS ) ss COUNTY OF KENDALL ) ORDINANCE NO.2007- AN ORDINANCE AMENDING ORDINANCE 1994-41 PROVIDING FOR THE IMPOSITION OF A GARBAGE AND REFUSE PICK-UP SURCHARGE—CHANGE TO SURCHARGE AMOUNT WHEREAS,the United City of the Village of Yorkville is authorized and empowered under Illinois Compiled Statutes to provide for the protection of the public health, and welfare; and WHEREAS, City Ordinance 1994-41 established a garbage and refuse pick-up surcharge amount; and WHEREAS, The City now deems it prudent to change said surcharge amount. NOW, THEREFORE, BE IT ORDAINED BY THE MAYOR AND CITY COUNCIL OF THE UNITED CITY OF THE VILLAGE OF YORKVILLE, KENDALL COUNTY, ILLINOIS AS FOLLOWS: 1. Paragraph#1 of said Ordinance 1994-41 is hereby stricken in its entirety and in its place shall be substituted the following new Paragraph#1,to wit: "That a garbage surcharge shall be placed on the regular billing of City Water bills for the sum of per month commencing 2. No other changes are made to Ordinance No. 1994-41. 3. Said surcharge shall continue to be imposed until further Ordinance of the City of Yorkville. JAMES BOCK JOSEPH BESCO VALERIE BURD PAUL JAMES GARY GOLINSKI MARTY MUNNS ROSE SPEARS JASON LESLIE APPROVED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois,this Day of , A.D. 2007. MAYOR PASSED by the City Council of the United City of Yorkville, Kendall County, Illinois this Day of , A.D. 2007. ATTEST: CITY CLERK Prepared by: John Justin Wyeth City Attorney United City of Yorkville 800 Game Farm Road Yorkville, IL 60560 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 1 IME: 10:24:48 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- ACVB AURORA AREA CONVENTION 033107-SUPER 04/16/07 01 ADMIN-FEB. HOTEL TAX 01-110-65-00-5844 05/08/07 1,543.61 MARKETING - HOTEL TAX INVOICE TOTAL: 1,543.61 VENDOR TOTAL: 1,543.61 LFORDR RICHARD ALFORD, PH.D. 042307 04/23/07 01 POLICE-2 EVALUATIONS 01-210-62-00-5430 00303876 05/08/07 250.00 HEALTH SERVICES 02 POLICE-2 EVALUATIONS 01-210-62-00-5429 250.00 PSYCHOLOGICAL TESTING INVOICE TOTAL: 500.00 VENDOR TOTAL: 500.00 CEL ANCEL, GLINK, DIAMOND, BUSH, 6145 04/18/07 01 AR-LEGAL MATTERS 01-000-13-00-1375 05/08/07 86,584.59 A/R LANDFILL INVOICE TOTAL: 86,584.59 VENDOR TOTAL: 86,584.59 PA AMERICAN PLANNING ASSOCIATION 163093-070304 03/09/07 01 PLAN/DEV-MEMBERSHIP 01-220-64-00-5600 05/08/07 313.00 DUES INVOICE TOTAL: 313.00 VENDOR TOTAL: 313.00 QUAFIX AQUAFIX, INC. 2579 04/05/07 01 SEWER OP-CHEMICALS 52-000-65-00-5823 00202967 05/08/07 702.83 SEWER CHEMICALS INVOICE TOTAL: 702.83 VENDOR TOTAL: 702.83 �I P1 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 2 IME: 10:24:48 DETAIL BOARD REPORT :D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- RROLAB ARRO LABORATORY, INC. 37182 04/05/07 01 WATER OP-SAMPLES 51-000-65-00-5822 05/08/07 230.00 WATER SAMPLES INVOICE TOTAL: 230.00 37215 04/13/07 01 WATER OP-SAMPLES 51-000-65-00-5822 05/08/07 110.00 WATER SAMPLES INVOICE TOTAL: 110.00 VENDOR TOTAL: 340.00 SOCTECH ASSOCIATED TECHNICAL SERVICES 17077 03/28/07 01 WATER OP-LEAK LOCATION 47 & 51-000-65-00-5804 00203506 05/08/07 584.00 OPERATING SUPPLIES 02 CENTER ** COMMENT ** INVOICE TOTAL: 584.00 VENDOR TOTAL: 584.00 TT AT&T 630R061269-0407 04/16/07 01 ADMIN-CITY HALL FIRE 01-110-62-00-5436 05/08/07 34.78 TELEPHONE 02 POLICE-CITY HALL FIRE 01-210-62-00-5436 34.78 TELEPHONE INVOICE TOTAL: 69.56 630R262965-0407 04/16/07 01 ADMIN-CITY HALL NORTEL 01-110-62-00-5436 05/08/07 861.37 TELEPHONE 02 POLICE-CITY HALL NORTEL 01-210-62-00-5436 861.37 TELEPHONE 03 WATER OP-CITY HALL NORTEL 51-000-62-00-5436 861.36 TELEPHONE INVOICE TOTAL: 2,584.10 708Z911001-0407 04/16/07 01 WATER OP-ALARMS 51-000-62-00-5436 05/08/07 73.76 TELEPHONE INVOICE TOTAL: 73.76 VENDOR TOTAL: 2,727.42 P2 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 3 IME: 10:24:48 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- TTINTER AT&T INTERNET SERVICES 842804266-0407 04/24/07 01 ADMIN-T.1 SERVICE 01-110-62-00-5436 05/08/07 463.20 TELEPHONE INVOICE TOTAL: 463.20 VENDOR TOTAL: 463.20 TTLONG AT&T LONG DISTANCE 828932136-0407 04/01/07 01 ADMIN-MONTHLY USAGE 01-110-62-00-5436 05/08/07 8.73 TELEPHONE 02 POLICE-MONTHLY USAGE 01-210-62-00-5436 192.20 TELEPHONE 03 WATER OP-MONTHLY USAGE 51-000-62-00-5436 45.49 TELEPHONE INVOICE TOTAL: 246.42 VENDOR TOTAL: 246.42 ATTERYS BATTERY SERVICE CORPORATION 162573 04/11/07 01 STREETS-BATTERIES 01-410-65-00-5804 00203483 05/08/07 272.85 OPERATING SUPPLIES INVOICE TOTAL: 272.85 VENDOR TOTAL: 272.85 CBS BLUE CROSS BLUE SHIELD 040607 04/06/07 01 ADMIN-MAY HEALTH INSURANCE 01-110-50-00-5203 05/08/07 65,158.74 BENEFITS - HEALTH INSURANC INVOICE TOTAL: 65,158.74 VENDOR TOTAL: 65,158.74 BENSON CRAIG H. BENSON, PHD, PE DPY-07-03 04/14/07 01 AR-LEGAL MATTERS 01-000-13-00-1375 05/08/07 10,744.53 A/R LANDFILL INVOICE TOTAL: 10,744.53 VENDOR TOTAL: 10,744.53 P3 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 4 IME: 10:24:49 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- ENTLEY BENTLEY SYSTEMS, INCORPORATED 47043159 02/28/07 01 ENG-WATER & STORM CAD 01-150-75-00-7002 00102492 05/08/07 270.00 COMPUTER EQUIPMENT & SOFTW INVOICE TOTAL: 270.00 VENDOR TOTAL: 270.00 PAMOCO BP AMOCO OIL COMPANY 8576346 04/06/07 01 POLICE-FUEL 01-210-65-00-5812 05/08/07 154.07 GASOLINE INVOICE TOTAL: 154.07 8576397 04/06/07 01 STREET-FUEL 01-410-65-00-5812 05/08/07 195.84 GASOLINE 02 WATER OP-FUEL 51-000-65-00-5812 195.84 GASOLINE 03 SEWER OP-FUEL 52-000-65-00-5812 195.85 GASOLINE INVOICE TOTAL: 587.53 VENDOR TOTAL: 741.60 RENART BRENART EYE CLINIC 479065 04/18/07 01 POLICE-EXAM 01-210-62-00-5430 05/08/07 40.00 HEALTH SERVICES INVOICE TOTAL: 40.00 VENDOR TOTAL: 40.00 AMBRIA CAMBRIA SALES COMPANY INC. 24109 04/12/07 01 ADMIN-TOWELS, T. LINERS 01-110-65-00-5804 05/08/07 81.30 OPERATING SUPPLIES INVOICE TOTAL: 81.30 VENDOR TOTAL: 81.30 ARGILL CARGILL, INC P4 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 5 IME: 10:24:49 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- ARGILL CARGILL, INC 1878951 03/28/07 01 WATER OP-SALT 51-000-62-00-5407 00203504 05/08/07 2,099.86 TREATMENT FACILITIES O&M INVOICE TOTAL: 2,099.86 1878955 03/28/07 01 WATER OP-SALT 51-000-62-00-5407 00203504 05/08/07 2,131.85 TREATMENT FACILITIES O&M INVOICE TOTAL: 2,131.85 1880434 03/30/07 01 WATER OP-SALT 51-000-62-00-5407 00203504 05/08/07 2,092.76 TREATMENT FACILITIES O&M INVOICE TOTAL: 2,092.76 VENDOR TOTAL: 6,324.47 DWG CDW GOVERNMENT INC. FBL5194 04/05/07 01 PLAN/DEV-COMPUTER, CASE, 01-220-75-00-7002 00102481 05/08/07 2,416.99 COMPUTER EQUIP & SOFTWARE 02 DOCKING STATION ** COMMENT ** INVOICE TOTAL: 2,416.99 FBR7153 04/07/07 01 PLAN/DEV-WARRANTY FOR COMPUTER 01-220-75-00-7002 00102481 05/08/07 280.00 COMPUTER EQUIP & SOFTWARE INVOICE TOTAL: 280.00 FCP4489 04/12/07 01 PLAN/DEV-OFFICE & 6 LICENSES 01-220-75-00-7002 00102487 05/08/07 1,716.87 COMPUTER EQUIP & SOFTWARE INVOICE TOTAL: 1,716.87 FCQ0889 04/12/07 01 PLAN/DEV-MONITOR 01-220-75-00-7002 00102490 05/08/07 195.93 COMPUTER EQUIP & SOFTWARE INVOICE TOTAL: 195.93 VENDOR TOTAL: 4,609.79 ENTDIST CENTURY DISTRIBUTING, INC. P5 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 6 IME: 10:24:50 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ' ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- ENTDIST CENTURY DISTRIBUTING, INC. 13001 04/05/07 01 ENG-2 SCREW MOUNTS 01-150-62-00-5409 05/08/07 30.56 MAINTENANCE-VEHICLES INVOICE TOTAL: 30.56 VENDOR TOTAL: 30.56 INTAS CINTAS FIRST AID & SAFETY 0343410786 04/09/07 01 SEWER OP-REFILL MED. CABINET 52-000-65-00-5805 05/08/07 53.68 SHOP SUPPLIES INVOICE TOTAL: 53.68 VENDOR TOTAL: 53.68 LARKL LARRY M. CLARK 033107 03/31/07 01 AR-LEGAL MATTERS 01-000-13-00-1375 05/08/07 57,307.50 A/R LANDFILL INVOICE TOTAL: 57,307.50 VENDOR TOTAL: 57,307.50 LINEA ANGELA FULLER CLINE 314 04/17/07 01 LAND CASH-CABOOSE 72-000-75-00-7330 05/08/07 10,500.00 WHISPERING MEADOWS (K. HIL INVOICE TOTAL: 10,500.00 VENDOR TOTAL: 10,500.00 OMDIR COMMUNICATIONS DIRECT INC SR78770 04/20/07 01 POLICE-M20 REPAIRS 01-210-62-00-5409 05/08/07 44.75 MAINTENANCE - VEHICLES INVOICE TOTAL: 44.75 VENDOR TOTAL: 44.75 ONSTELL CONSTELLATION NEW ENERGY P6 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 7 IME: 10:24:50 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- ONSTELL CONSTELLATION NEW ENERGY 01405539 04/12/07 01 WATER OP-CITY WELLS 51-000-62-00-5435 05/08/07 244.37 ELECTRICITY INVOICE TOTAL: 244.37 VENDOR TOTAL: 244.37 RYSTAL CRYSTALTECH 704080118488205 04/09/07 01 ADMIN-ADDITIONAL SPACE 01-110-62-00-5401 05/08/07 21.33 CONTRACTUAL SERVICES INVOICE TOTAL: 21.33 VENDOR TOTAL: 21.33 ENVIS DENTAL VISION REIMBURSEMENT 041107 04/11/07 01 ADMIN-VISION ASSISTANCE 01-110-50-00-5205 05/08/07 54.40 BENEFITS - DENTAL/VISION A INVOICE TOTAL: 54.40 041807 04/18/07 01 ADMIN-VISION ASSISTANCE 01-110-50-00-5205 05/08/07 136.80 BENEFITS - DENTAL/VISION A INVOICE TOTAL: 136.80 VENDOR TOTAL: 191.20 EPO DEPO COURT REPORTING SVC, INC 12990 04/19/07 01 AR-LANDFILL MINUTES 01-000-13-00-1375 05/08/07 750.00 A/R LANDFILL INVOICE TOTAL: 750.00 12991 04/23/07 01 AR-LANDFILL MINUTES 01-000-13-00-1375 05/08/07 1,635.50 A/R LANDFILL INVOICE TOTAL: 1,635.50 VENDOR TOTAL: 2,385.50 DEUCHLER WALTER E. DEUCHLER ASSOCIATES P7 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 8 IME: 10:24:50 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- EUCHLER WALTER E. DEUCHLER ASSOCIATES 20403 03/31/07 01 SEWER IMPROV-COUNTRYSIDE 37-000-62-00-5402 05/08/07 298.48 ENG/LGL/CONTINGNCY-COUNTRY 02 INTERCEPTOR P.S. ** COMMENT ** INVOICE TOTAL: 298.48 20404 03/31/07 01 ARO-SOUTHWEST INTERC. 01-000-13-00-1372 05/08/07 882.70 A/R-OTHER INVOICE TOTAL: 882.70 20405 03/31/07 01 SEWER IMPROV-ROB ROY INTERC. 37-000-75-00-7505 05/08/07 302.78 ROB ROY CREEK SANITARY INVOICE TOTAL: 302.78 20406 03/31/07 01 ARO-AUX SABLE CREEK 01-000-13-00-1372 05/08/07 284.48 A/R-OTHER INVOICE TOTAL: 284.48 VENDOR TOTAL: 1,768.44 LT DLT SOLUTIONS, INC. GSA 04/23/07 01 ENG-AUTOCAD, MAP SUBSCRIPTIONS 01-150-75-00-7002 00102497 05/08/07 1,881.07 COMPUTER EQUIPMENT & SOFTW 02 PLAN/DEV-AUTOCAD, MAP 01-220-75-00-7002 750.53 COMPUTER EQUIP & SOFTWARE 03 SUBSCRIPTIONS ** COMMENT ** INVOICE TOTAL: 2,631.60 VENDOR TOTAL: 2,631.60 JEQUIP EJ EQUIPMENT 0022992 04/03/07 01 STREETS-AIR FILTER, SWEEPER 01-410-62-00-5409 00203492 05/08/07 388.83 MAINTENANCE-VEHICLES 02 BROOMS ** COMMENT ** INVOICE TOTAL: 388.83 VENDOR TOTAL: 388.83 P8 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 9 IME: 10:24:51 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- NGSUPPL ENGINEER SUPPLY 31964 04/19/07 01 PLAN/DEV-FILE 01-220-75-00-7003 00102493 05/08/07 913.74 OFFICE EQUIPMENT INVOICE TOTAL: 913.74 VENDOR TOTAL: 913.74 STILUNV EASTERN ILLINOIS UNIVERSITY 042007 04/20/07 01 ADMIN-MEMBERSHIP FEE 01-110-64-00-5600 05/08/07 80.00 DUES INVOICE TOTAL: 80.00 VENDOR TOTAL: 80.00 ARREN FARREN HEATING & COOLING 5143 04/06/07 01 MUNICIPAL BLDG-AC REPAIRS 16-000-75-00-7204 05/08/07 393.87 BLDG MAINT - CITY HALL INVOICE TOTAL: 393.87 VENDOR TOTAL: 393.87 IRST FIRST PLACE RENTAL 151171 04/11/07 01 SEWER OP-PAINT, FLAGS 52-000-62-00-5419 00203481 05/08/07 227.43 MAINTENANCE-SANITARY SEWER INVOICE TOTAL: 227.43 VENDOR TOTAL: 227.43 IRSTNON FIRST NONPROFIT UNEMPLOYEMENT 122719N-07-2Q 04/16/07 01 ADMIN-2ND QTR. UNEMPLOYMENT 01-110-50-00-5202 05/08/07 5,854.00 BENEFITS - UNEMPLOY. COMP. INVOICE TOTAL: 5,854.00 VENDOR TOTAL: 5,854.00 OXFLOOR FOX FLOORING P9 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 10 IME: 10:24:51 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- OXFLOOR FOX FLOORING 2191 03/26/07 01 MUNICIPAL BLDG-CARPET 16-000-75-00-7210 00403236 05/08/07 425.00 BLDG IMPROV-POST OFFICE INVOICE TOTAL: 425.00 VENDOR TOTAL: 425.00 OXVALLE FOX VALLEY TROPHY & AWARDS 21796 04/09/07 01 ADMIN-4 PLAQUES 01-110-64-00-5607 00102486 05/08/07 194.50 PUBLIC RELATIONS INVOICE TOTAL: 194.50 VENDOR TOTAL: 194.50 ENESCUS GENE'S CUSTOM CAKES & COOKIES 120106 12/01/06 01 POLICE-350 DARE COOKIES 01-210-64-00-5606 00303858 05/08/07 222.50 COMMUNITY RELATIONS INVOICE TOTAL: 222.50 VENDOR TOTAL: 222.50 JOVIKFD GJOVIK FORD-MERCURY, INC. 219925 04/16/07 01 POLICE-HVAC REPAIR 01-210-62-00-5409 00303873 05/08/07 772.99 MAINTENANCE - VEHICLES INVOICE TOTAL: 772.99 VENDOR TOTAL: 772.99 RAINCO GRAINCO FS. , INC. 033107 03/31/07 01 STREETS-FUEL 01-410-65-00-5812 00203485 05/08/07 1,272.38 GASOLINE 02 STREETS-TIRES 01-410-62-00-5408 71.00 MAINTENANCE-EQUIPMENT INVOICE TOTAL: 1,343.38 VENDOR TOTAL: 1,343.38 P10 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 11 IME: 10:24:51 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM VENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- REATAME GREATAMERICA LEASING CORP. 6411145 04/06/07 01 WATER OP-PW LEASE 51-000-65-00-5809 05/08/07 140.00 PRINTING & COPYING 02 ADMIN-LEASE 7 COPIERS 01-110-62-00-5412 1,964.69 MAINTENANCE - PHOTOCOPIERS INVOICE TOTAL: 2,104.69 VENDOR TOTAL: 2,104.69 ACH HACH COMPANY 5106831 04/12/07 01 WATER OP-CHLORINE, TUBE 51-000-65-00-5804 05/08/07 161.95 OPERATING SUPPLIES INVOICE TOTAL: 161.95 VENDOR TOTAL: 161.95 DSUPPLY HD SUPPLY WATERWORKS, LTD. 4882588 03/21/07 01 WATER OP-METERS & PARTS 51-000-75-00-7508 00203505 05/08/07 250.00 METERS & PARTS INVOICE TOTAL: 250.00 4883647 03/21/07 01 WATER OP-CREDIT 51-000-75-00-7508 00203505 05/08/07 -280.00 METERS & PARTS INVOICE TOTAL: -280.00 4952415 04/03/07 01 WATER OP-METERS & PARTS 51-000-75-00-7508 00203505 05/08/07 2,985.25 METERS & PARTS INVOICE TOTAL: 2,985.25 4952423 04/02/07 01 WATER OP-METERS & PARTS 51-000-75-00-7508 00203505 05/08/07 152.64 METERS & PARTS INVOICE TOTAL: 152.64 5007582 04/16/07 01 WATER OP-METERS & PARTS 51-000-75-00-7508 00203505 05/08/07 710.27 METERS & PARTS INVOICE TOTAL: 710.27 P11 l TE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 12 'IME: 10:24:52 DETAIL BOARD REPORT AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ------------------------------------------------------------------------------------------------------------------------------------ DSUPPLY HD SUPPLY WATERWORKS, LTD. 5007748 04/16/07 01 WATER OP-METERS & PARTS 51-000-75-00-7508 00203505 05/08/07 382.00 METERS & PARTS INVOICE TOTAL: 382.00 VENDOR TOTAL: 4,200.16 ERVAS HERVAS, CONDON & BERSANI, P.C. 6657 02/28/07 01 ADMIN-VARIOUS LEGAL MATTERS 01-110-61-00-5300 05/08/07 2,554.46 LEGAL SERVICES INVOICE TOTAL: 2,554.46 6658 02/28/07 01 ADMIN-VARIOUS LEGAL MATTERS 01-110-61-00-5300 05/08/07 16,899.40 LEGAL SERVICES INVOICE TOTAL: 16,899.40 6695 03/31/07 01 ADMIN-VARIOUS LEGAL MATTERS 01-110-61-00-5300 05/08/07 2,329.86 LEGAL SERVICES INVOICE TOTAL: 2,329.86 6696 03/31/07 01 ADMIN-VARIOUS LEGAL MATTERS 01-110-61-00-5300 05/08/07 9,765.41 LEGAL SERVICES INVOICE TOTAL: 9,765.41 VENDOR TOTAL: 31,549.13 OPKINS HOPKINS, SHAMIM 041107 04/11/07 01 POLICE-WEARING APPAREL 01-210-62-00-5421 05/08/07 32.09 WEARING APPAREL INVOICE TOTAL: 32.09 VENDOR TOTAL: 32.09 CCI INTERNATIONAL CODES 20070417 04/23/07 01 ADMIN-MIDDLE APRIL PERMITS 01-110-61-00-5314 05/08/07 33,338.10 BUILDING INSPECTIONS INVOICE TOTAL: 33, 338.10 VENDOR TOTAL: 33,338.10 P12 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 13 IME: 10:24:52 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- CE ICE MOUNTAIN 07DO118718238 04/10/07 01 ADMIN-14 JUGS OF WATER @ 7.25 01-110-65-00-5804 05/08/07 106.86 OPERATING SUPPLIES 02 LESS DEPOSIT RETURN ** COMMENT ** INVOICE TOTAL: 106.86 VENDOR TOTAL: 106.86 CMA INTERNATIONAL CITY/COUNTY MGMT 143636 04/25/07 01 ADMIN-7/1/07 YEARLY DUES FOR 01-110-64-00-5600 05/08/07 768.00 DUES 02 CITY ADMINISTRATOR ** COMMENT ** INVOICE TOTAL: 768.00 VENDOR TOTAL: 768.00 DOAICPA IDOA & ICPA 042307 04/23/07 01 POLICE-TRAINING CONFERENCE 01-210-64-00-5604 00303877 05/08/07 450.00 TRAINING & CONFERENCE INVOICE TOTAL: 450.00 VENDOR TOTAL: 450.00 LEAS ILLINOIS LAW ENFORCEMENT 040507-07 04/05/07 01 POLICE-ANNUAL DUES 01-210-65-00-5804 05/08/07 50.00 OPERATING SUPPLIES INVOICE TOTAL: 50.00 VENDOR TOTAL: 50.00 ILEPAADM IL EPA DIVISION OF ADMIN. 041307 04/13/07 01 WATER OP-YEARLY WATER TESTING 51-000-65-00-5822 00203509 05/08/07 5,112.75 WATER SAMPLES INVOICE TOTAL: 5,112.75 VENDOR TOTAL: 5,112.75 P13 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 14 IME: 10:24:52 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM VENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- LSROA ILSROA 041807 04/18/07 01 POLICE-CONFERENCE DUES 01-210-64-00-5604 00303868 05/08/07 300.00 TRAINING & CONFERENCE INVOICE TOTAL: 300.00 VENDOR TOTAL: 300.00 LSTATPD ILLINOIS STATE POLICE 033107 03/31/07 01 ADMIN-BACKGROUND CHECKS 01-110-65-00-5800 05/08/07 10.00 CONTINGENCIES INVOICE TOTAL: 10.00 VENDOR TOTAL: 10.00 CM JCM UNIFORMS, INC. 592620 04/18/07 01 POLIE-UNIFORMS 01-210-62-00-5421 00303874 05/08/07 310.51 WEARING APPAREL INVOICE TOTAL: 310.51 592622 04/11/07 01 POLICE-PINS, BAR, CLUTCH BACKS 01-210-62-00-5421 05/08/07 47.40 WEARING APPAREL INVOICE TOTAL: 47.40 VENDOR TOTAL: 357.91 IFFY JIFFY LUBE 5493311 03/08/07 01 POLICE-OIL CHANGE 01-210-62-00-5409 05/08/07 49.48 MAINTENANCE - VEHICLES INVOICE TOTAL: 49.48 5494508 03/26/07 01 POLICE-OIL CHANGE 01-210-62-00-5409 05/08/07 29.69 MAINTENANCE - VEHICLES INVOICE TOTAL: 29.69 5495177 04/06/07 01 POLICE-OIL CHANGE 01-210-62-00-5409 05/08/07 32.99 MAINTENANCE - VEHICLES INVOICE TOTAL: 32.99 P14 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 15 IME: 10:24:53 DETAIL BOARD REPORT :D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- IFFY JIFFY LUBE 5495901 04/17/07 01 POLICE-OIL CHANGE 01-210-62-00-5409 05/08/07 33.49 MAINTENANCE - VEHICLES INVOICE TOTAL: 33.49 5496031 04/20/07 01 POLICE-OIL CHANGE 01-210-62-00-5409 05/08/07 32.99 MAINTENANCE - VEHICLES INVOICE TOTAL: 32.99 VENDOR TOTAL: 178.64 ULIE JULIE, INC. 03-07-1726 04/23/07 01 WATER OP-MARCH LOCATES 51-000-61-00-5303 00040307 05/08/07 662.65 JULIE SERVICE INVOICE TOTAL: 662.65 VENDOR TOTAL: 662.65 UPITER JUPITER IMAGES 609435 04/11/07 01 ADMIN-1 YEAR LIQUID LIBRARY 01-110-64-00-5606 00102495 05/08/07 664.08 PROMOTIONAL/MARKETING EXPE 02 WEB SUBSCRIPTION ** COMMENT ** INVOICE TOTAL: 664.08 VENDOR TOTAL: 664.08 CACP KENDALL COUNTY ASSOCIATION 042007 04/23/07 01 POLICE-APRIL MEETING 01-210-64-00-5605 05/08/07 30.00 TRAVEL EXPENSES INVOICE TOTAL: 30.00 VENDOR TOTAL: 30.00 CRECORD KENDALL COUNTY RECORD 95 03/31/07 01 ADMIN-BUDGET, TRASH 01-110-65-00-5810 05/08/07 40.00 PUBLISHING & ADVERTISING P15 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 16 IME: 10:24:53 DETAIL BOARD REPORT :D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- CRECORD KENDALL COUNTY RECORD 95 03/31/07 02 WATER OP-SUNFLOWER & FOX 51-000-65-00-5810. 05/08/07 248.00 PUBLISHING & ADVERTISING 03 HILL MOWING ADS ** COMMENT ** 04 ADMIN-50TH ANNIVERSARY 01-000-14-00-1401 165.60 PREPAID EXP-COY 50TH ANNIV 05 ARO-DTD INVEST. , F.2, YBSD, 01-000-13-00-1372 415.60 A/R-OTHER 06 CASTLE BANK, CORN HOLDINGS ** COMMENT ** INVOICE TOTAL: 869.20 VENDOR TOTAL: 869.20 'ENPRINT KENDALL PRINTING 15233 04/12/07 01 POLICE-DARE PROGRAMS 01-210-64-00-5606 00303869 05/08/07 269.10 COMMUNITY RELATIONS INVOICE TOTAL: 269.10 VENDOR TOTAL: 269.10 LIMEKD DANIELLE KLIMEK 041807 04/18/07 01 POLICE-WEARING APPAREL 01-210-62-00-5421 00303870 05/08/07 282.12 WEARING APPAREL INVOICE TOTAL: 282.12 VENDOR TOTAL: 282.12 EPPERTL LAURA LEPPERT 109 04/12/07 01 ADMIN-2/6/07 COW MINUTES 01-110-62-00-5401 05/08/07 98.75 CONTRACTUAL SERVICES INVOICE TOTAL: 98.75 VENDOR TOTAL: 98.75 ACOUPIN MACOUPIN MONTGOMERY COUNTIES 042007 04/20/07 01 POLICE-CONFERENCE 01-210-64-00-5604 05/08/07 125.00 TRAINING & CONFERENCE INVOICE TOTAL: 125.00 VENDOR TOTAL: 125.00 P16 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 17 IME: 10:24:53 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- ARKER RICHARD MARKER ASSOCIATES 042407 04/24/07 01 LAND CASH-REIMBURSEMENT 72-000-47-00-4723 05/08/07 1,000.00 HEARTLAND CIRCLE-LAND CASH INVOICE TOTAL: 1,000.00 VENDOR TOTAL: 1,000.00 ARTPLMB MARTIN PLUMBING & HEATING CO. 270333 04/11/07 01 MUNICIPAL BLDG-BEECHER 16-000-75-00-7200 05/08/07 98.00 BLDG IMPROV- BEEHCER/RIVFR 02 CLEANED P-TRAP IN SINK ** COMMENT ** INVOICE TOTAL: 98.00 VENDOR TOTAL: 98.00 CCUE MC CUE BUILDERS, INC. 042407 04/24/07 01 LAND CASH-REIMBURSEMENT 72-000-47-00-4723 05/08/07 4,000.00 HEARTLAND CIRCLE-LAND CASH INVOICE TOTAL: 4,000.00 VENDOR TOTAL: 4,000.00 EADE MEADE ELECTRIC COMPANY, INC. 628735 04/02/07 01 STREETS-REPAIR LOOP AT 34 & 01-410-62-00-5414 00203484 05/08/07 1,679.80 MAINTENANCE-TRAFFIC SIGNAL 02 GAME FARM TRAFFIC SIGNAL ** COMMENT ** INVOICE TOTAL: 1,679.80 VENDOR TOTAL: 1,679.80 ENLAND MENARDS - YORKVILLE 33673 03/28/07 01 WATER OP-COUPLING, BUSHINGS, 51-000-65-00-5804 05/08/07 22.10 OPERATING SUPPLIES 02 ELBOW ** COMMENT ** INVOICE TOTAL: 22.10 P17 %TE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 18 ME: 10:24:54 DETAIL BOARD REPORT AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 NVOICE # INVOICE ITEM NDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- ENLAND MENARDS - YORKVILLE 35068 04/02/07 01 ENG-BATTERIES 01-150-65-00-5801 05/08/07 8.88 ENGINEERING SUPPLIES INVOICE TOTAL: 8.88 35299 04/03/07 01 STREETS-CORN IRON, PROPANE 01-410-65-00-5804 05/08/07 12.75 OPERATING SUPPLIES 02 CYLINDER ** COMMENT ** INVOICE TOTAL: 12.75 35522 04/04/07 01 POLICE-BATTERIES 01-210-65-00-5804 05/08/07 8.88 OPERATING SUPPLIES INVOICE TOTAL: 8.88 35528 04/04/07 01 STREETS-ELECTRICAL TAPE 01-410-62-00-5415 05/08/07 11.82 MAINTENANCE-STREET LIGHTS INVOICE TOTAL: 11.82 35534 04/04/07 01 STREETS-PRIMER, CEMENT 01-410-65-00-5804 05/08/07 22.94 OPERATING SUPPLIES INVOICE TOTAL: 22.94 37152 04/11/07 01 WATER OP-GLOVES 51-000-65-00-5804 05/08/07 27.87 OPERATING SUPPLIES INVOICE TOTAL: 27.87 37207A 04/11/07 01 STREETS-HEAT SHRINK 01-410-62-00-5415 05/08/07 1.49 MAINTENANCE-STREET LIGHTS INVOICE TOTAL: 1.49 37451 04/12/07 01 POLICE-HINGED ROUGH TOTE 01-210-65-00-5804 05/08/07 13.87 OPERATING SUPPLIES INVOICE TOTAL: 13.87 37656 04/13/07 01 WATER OP-MULCH 51-000-65-00-5804 05/08/07 2.00 OPERATING SUPPLIES INVOICE TOTAL: 2.00 VENDOR TOTAL: 132.60 P18 4 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 19 IME: 10:24:54 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- ETLIFE METLIFE SMALL BUSINESS CENTER 041607 04/16/07 01 ADMIN-LIFE INSURANCE 01-110-50-00-5204 05/08/07 2,228.95 BENEFITS - GROUP LIFE INSU 02 ADMIN-DENTAL INSURANCE 01-110-50-00-5205 6,357.51 BENEFITS - DENTAL/VISION A INVOICE TOTAL: 8,586.46 VENDOR TOTAL: 8,586.46 IDAM MID AMERICAN WATER 36282A 03/30/07 01 SEWER OP-PVC PIPE 52-000-62-00-5419 05/08/07 74.20 MAINTENANCE-SANITARY SEWER INVOICE TOTAL: 74.20 VENDOR TOTAL: 74.20 JELECT MJ ELECTRICAL SUPPLY, INC. 1082561-01 03/20/07 01 STREETS-TRAFFIC LIGHT EQUIP. 01-410-62-00-5415 05/08/07 72.00 MAINTENANCE-STREET LIGHTS INVOICE TOTAL: 72.00 1082593-01 03/20/07 01 STREET-TRAFFIC LIGHT EQUIP. 01-410-62-00-5415 05/08/07 149.00 MAINTENANCE-STREET LIGHTS INVOICE TOTAL: 149.00 1083859-01 04/11/07 01 STREETS-LIGHT BULBS 01-410-62-00-5415 00203493 05/08/07 233.00 MAINTENANCE-STREET LIGHTS INVOICE TOTAL: 233.00 VENDOR TOTAL: 454.00 OONBEAM MOONBEAM MEDIA 1-LF 04/03/07 01 AR-3/7-3/10 TAPING 01-000-13-00-1375 05/08/07 4,392.65 A/R LANDFILL INVOICE TOTAL: 4,392.65 P19 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 20 IME: 10:24:54 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- OONBEAM MOONBEAM MEDIA 2-LF 04/08/07 01 AR-3/12-3/17 TAPINGS 01-000-13-00-1375 05/08/07 5,694.40 A/R LANDFILL INVOICE TOTAL: 5,694.40 29 04/10/07 01 ADMIN-CC VIDEO TAPING ON 4/10 01-110-64-00-5607 05/08/07 50.00 PUBLIC RELATIONS INVOICE TOTAL: 50.00 3-LF 04/12/07 01 AR-3/19-3/24 TAPING 01-000-13-00-1375 05/08/07 5,738.90 A/R LANDFILL INVOICE TOTAL: 5,738.90 4-LF 04/12/07 01 AR-3/26-3/31 TAPING 01-000-13-00-1375 05/08/07 4,383.55 A/R LANDFILL INVOICE TOTAL: 4,383.55 VENDOR TOTAL: 20,259.50 ATLACOP NATIONAL ASSOCIATION OF CHIEFS 041307 04/13/07 01 POLICE-ANNUAL DUES 01-210-65-00-5804 05/08/07 50.00 OPERATING SUPPLIES INVOICE TOTAL: 50.00 VENDOR TOTAL: 50.00 CI NORTHWEST COLLECTORS INC 020107 04/13/07 01 WATER OP-COMM. ON COLLECTIONS 51-000-62-00-5401 05/08/07 92.56 CONTRACUAL SERVICES INVOICE TOTAL: 92.56 VENDOR TOTAL: 92.56 ICOR NICOR GAS 616041100090407 04/11/07 01 ADMIN-610 TOWER LANE 01-110-78-00-9002 05/08/07 432.68 NICOR GAS INVOICE TOTAL: 432.68 P20 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 21 IME: 10:24:55 DETAIL BOARD REPORT AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ------------------------------------------------------------------------------------------------------------------------------------ ICOR NICOR GAS 667044694290407 04/11/07 01 ADMIN-100 RAINTREE ROAD 01-110-78-00-9002 05/08/07 69.19 NICOR GAS INVOICE TOTAL: 69.19 838000100070407 04/11/07 01 ADMIN-610 TOWER LANE UNIT B 01-110-78-00-9002 05/08/07 250.41 NICOR GAS INVOICE TOTAL: 250.41 951610100040407 04/11/07 01 ADMIN-1 ROUTE 47 01-110-78-00-9002 05/08/07 554.48 NICOR GAS INVOICE TOTAL: 554.48 VENDOR TOTAL: 1,306.76 FFWORK OFFICE WORKS 114539I 04/20/07 01 POLICE-VARIOUS OFFICE SUPPLIES 01-210-65-00-5802 00303875 05/08/07 460.02 OFFICE SUPPLIES INVOICE TOTAL: 460.02 VENDOR TOTAL: 460.02 HERROND RAY O'HERRON COMPANY, INC. 0710564-IN 04/10/07 01 PD CAPITAL-SQUAD BUILD OUT 20-000-75-00-7006 00303871 05/08/07 1,419.95 CAR BUILD OUT INVOICE TOTAL: 1,419.95 0710631-IN 04/11/07 01 PD CAPITAL-18 TASER CARTRIDGES 20-000-75-00-7001 00303864 05/08/07 458.01 EQUIPMENT 02 16 HOLSTERS, 5 TARGETS ** COMMENT ** INVOICE TOTAL: 458.01 0710632-IN 04/11/07 01 PD CAPITAL-3 TASERS 20-000-75-00-7001 00303863 05/08/07 2,399.85 EQUIPMENT INVOICE TOTAL: 2,399.85 P21 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 22 IME: 10:24:55 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- HERROND RAY O'HERRON COMPANY, INC. 0710633-IN 04/11/07 01 PD CAPITAL-4 TASER CAMS 20-000-75-00-7001 00303862 05/08/07 1,627.69 EQUIPMENT INVOICE TOTAL: 1,627.69 VENDOR TOTAL: 5,905.50 RRK KATHLEEN FIELD ORR & ASSOC. 12140 04/01/07 01 ADMIN-LEGAL MATTERS 01-110-61-00-5300 05/08/07 1,954.25 LEGAL SERVICES INVOICE TOTAL: 1,954.25 VENDOR TOTAL: 1,954.25 ATTEN PATTEN INDUSTRIES, INC. P5300096021 03/23/07 01 WATER OP-OIL KIT 51-000-62-00-5408 00203507 05/08/07 299.00 MAINTENANCE-EQUIPMENT INVOICE TOTAL: 299.00 VENDOR TOTAL: 299.00 ITBOW PITNEY BOWES 1970458-AP07 04/13/07 01 ADMIN-QUARTERLY LEASE 01-110-65-00-5808 05/08/07 246.00 POSTAGE & SHIPPING 02 POLICE-QUARTERLY LEASE 01-210-65-00-5808 246.00 POSTAGE & SHIPPING INVOICE TOTAL: 492.00 VENDOR TOTAL: 492.00 ITNEYBO PITNEY BOWES INC 549782 04/15/07 01 ADMIN-POSTAGE TAPES 01-110-65-00-5802 05/08/07 30.59 OFFICE SUPPLIES INVOICE TOTAL: 30.59 VENDOR TOTAL: 30.59 P22 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 23 IME: 10:24:55 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- OSTNET POSTNET IL 124 40853 04/13/07 01 ARO-CALEDONIA, X-PAC 01-000-13-00-1372 05/08/07 66.30 A/R-OTHER INVOICE TOTAL: 66.30 VENDOR TOTAL: 66.30 RINTPER PRINT PERFECT 00050364 04/09/07 01 WATER OP-NEWSLETTER 51-000-65-00-5809 00102496 05/08/07 2,107.50 PRINTING & COPYING 02 ADMIN-NEWSLETTER 01-110-65-00-5809 702.50 PRINTING & COPYING INVOICE TOTAL: 2,810.00 VENDOR TOTAL: 2,810.00 RODCHEM PRODUCERS CHEMICAL COMPANY 120896 04/13/07 01 SEWER OP-DEGREASER 52-000-62-00-5422 00203480 05/08/07 722.00 LIFT STATION MAINTENANCE INVOICE TOTAL: 722.00 VENDOR TOTAL: 722.00 UILL QUILL CORPORATION 6053891 04/10/07 01 PLAN/DEV-STAPLER, FOLDERS, 01-220-65-00-5804 00102488 05/08/07 687.15 OPERATING SUPPLIES 02 PENS, POST ITS, PAPER CLIPS, ** COMMENT ** 03 BINDER CLIPS, TAPE, MARKERS, ** COMMENT ** 04 MAT, SORTER, WASTEBASKET ** COMMENT ** INVOICE TOTAL: 687.15 6081928 04/11/07 01 ENG-LEAD, POST ITS, PENS, 01-150-65-00-5802 05/08/07 84.86 OFFICE SUPPLIES 02 ENVELOPES ** COMMENT ** INVOICE TOTAL: 84.86 VENDOR TOTAL: 772.01 P23 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 24 IME: 10:24:56 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM VENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- 0000197 JUANITA CURRY 041507 04/15/07 01 ADMIN-BEECHER DEPOSIT REFUND 01-000-42-00-4281 05/08/07 50.00 BEECHER DEPOSITS INVOICE TOTAL: 50.00 VENDOR TOTAL: 50.00 0000321 JILL HARKER 041007 04/10/07 01 ADMIN-50TH ANNIVERSARY CAKE, 01-000-14-00-1401 05/08/07 296.31 PREPAID EXP-COY 50TH ANNIV 02 FOOD, TABLE CLOTHES ** COMMENT ** INVOICE TOTAL: 296.31 VENDOR TOTAL: 296.31 0000323 JENNIFER MARTINEZ 041307 04/13/07 01 ADMIN-BEECHER DEPOSIT REFUND 01-000-42-00-4281 05/08/07 400.00 BEECHER DEPOSITS INVOICE TOTAL: 400.00 VENDOR TOTAL: 400.00 0000324 THE KILTS FOUNDATION 040407 04/04/07 01 ADMIN-BEECHER DEPOSIT REFUND 01-000-42-00-4281 05/08/07 50.00 BEECHER DEPOSITS INVOICE TOTAL: 50.00 VENDOR TOTAL: 50.00 0000325 EKREM ASHIKU 042307 04/23/07 01 ADMIN-OVERPAYMENT REFUND 01-000-00-00-1480 05/08/07 45.55 UNAPPLIED CASH INVOICE TOTAL: 45.55 VENDOR TOTAL: 45.55 0000326 SUE AHRENS P24 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 25 ME: 10:24:56 DETAIL BOARD REPORT AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- 0000326 SUE AHRENS 042107 04/21/07 01 ADMIN-BEECHER DEPOSIT REFUND 01-000-42-00-4281 05/08/07 50.00 BEECHER DEPOSITS INVOICE TOTAL: 50.00 VENDOR TOTAL: 50.00 0000327 STEVEN BUILDERS 042407 04/24/07 01 LAND CASH-REIMBURSEMENT 72-000-47-00-4723 05/08/07 1,000.00 HEARTLAND CIRCLE-LAND CASH INVOICE TOTAL: 1,000.00 VENDOR TOTAL: 1,000.00 0000328 TIM GREYER BUILDERS 042407 04/24/07 01 LAND CASH-REIMBURSEMENT 72-000-47-00-4723 05/08/07 4,000.00 HEARTLAND CIRCLE-LAND CASH INVOICE TOTAL: 4,000.00 VENDOR TOTAL: 4,000.00 0000329 SL REAL PROPERTY 042407 04/24/07 01 LAND CASH-REIMBURSEMENT 72-000-47-00-4723 05/08/07 1,000.00 HEARTLAND CIRCLE-LAND CASH INVOICE TOTAL: 1,000.00 VENDOR TOTAL: 1,000.00 UBERT R.A. UBERT CONSTRUCTION, INC 1-SMITH 04/20/07 01 STREETS-UTILITY IMPROVEMENTS 01-410-75-00-7101 05/08/07 237,562.20 IN TOWN ROAD PROGRAM INVOICE TOTAL: 237,562.20 VENDOR TOTAL: 237,562.20 SECGROUP SEC GROUP, INC. P25 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 26 IME: 10:24:56 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- ECGROUP SEC GROUP, INC. 343560 03/30/07 01 MFT-GAME FARM & SOMONAUK 15-000-75-00-7107 05/08/07 12.68 CONSTRUCTION ENGINEERING INVOICE TOTAL: 12.68 VENDOR TOTAL: 12.68 ERVMASC SERVICEMASTER COMM. CLEANING 133312 04/15/07 01 ADMIN-MONTHLY CLEANINGS 01-110-62-00-5406 05/08/07 625.00 OFFICE CLEANING INVOICE TOTAL: 625.00 VENDOR TOTAL: 625.00 HELL SHELL OIL CO. 065356230704 04/08/07 01 POLICE-FUEL 01-210-65-00-5812 05/08/07 4,380.86 GASOLINE INVOICE TOTAL: 4,380.86 VENDOR TOTAL: 4,380.86 HREDIT SHRED-IT 021199381 04/17/07 01 ADMIN-SHREDDING CHARGE 01-110-62-00-5401 05/08/07 204.00 CONTRACTUAL SERVICES 02 ADMIN-DISCOUNT 01-110-62-00-5401 -20.00 CONTRACTUAL SERVICES INVOICE TOTAL: 184.00 VENDOR TOTAL: 184.00 EESPLUS TEE'S PLUS 237892 03/14/07 01 POLICE-AWARDS 01-210-64-00-5606 00303820 05/08/07 664.98 COMMUNITY RELATIONS INVOICE TOTAL: 664.98 VENDOR TOTAL: 664.98 P26 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 27 IME: 10:24:57 DETAIL BOARD REPORT :D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT •----------------------------------------------------------------------------------------------------------------------------------- INSTAR TIN STAR ELECTRONIC SERVICE 3570 04/06/07 01 POLICE-M23 LIGHT REPAIRS 01-210-62-00-5409 05/08/07 45.00 MAINTENANCE - VEHICLES INVOICE TOTAL: 45.00 3583 04/10/07 01 PD CAPITAL-CHIEF'S CAR 20-000-75-00-7006 00303872 05/08/07 1,663.73 CAR BUILD OUT 02 BUILD OUT ** COMMENT ** INVOICE TOTAL: 1,663.73 VENDOR TOTAL: 1,708.73 RUCKCEN TRUCK CENTERS, INC. P103735 04/06/07 01 STREETS-DIPSTICK 01-410-62-00-5409 05/08/07 102.37 MAINTENANCE-VEHICLES INVOICE TOTAL: 102.37 VENDOR TOTAL: 102.37 LRICH ULRICH CHEMICAL, INC. 345876 04/11/07 01 WATER OP-CHEMICALS 51-000-65-00-5820 00203501 05/08/07 999.20 CHEMICALS INVOICE TOTAL: 999.20 345877 04/13/07 01 WATER OP-RETURNED CONTAINERS 51-000-65-00-5820 05/08/07 -950.00 CHEMICALS INVOICE TOTAL: -950.00 345898 04/11/07 01 WATER OP-CHEMICALS 51-000-65-00-5820 00203501 05/08/07 929.80 CHEMICALS INVOICE TOTAL: 929.80 345899 04/13/07 01 WATER OP-RETURNED CONTAINERS 51-000-65-00-5820 05/08/07 -600.00 CHEMICALS INVOICE TOTAL: -600.00 VENDOR TOTAL: 379.00 P27 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 28 IME: 10:24:57 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ' ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- PS UNITED PARCEL SERVICE 00004296X2147 04/07/07 01 ADMIN-4 PACKAGES SHIPPED 01-110-65-00-5808 05/08/07 106.07 POSTAGE & SHIPPING 02 WATER OP-1 PACKAGE SHIPPED 51-000-65-00-5808 9.64 POSTAGE & SHIPPING INVOICE TOTAL: 115.71 00004296X2157 04/14/07 01 ADMIN-1 PACKAGE SHIPPED 01-110-65-00-5808 05/08/07 27.39 POSTAGE & SHIPPING 02 WATER OP-6 PACKAGES SHIPPED 51-000-65-00-5808 167.50 POSTAGE & SHIPPING INVOICE TOTAL: 194.89 00004296X2167 04/21/07 01 ADMIN-3 PACKAGES SHIPPED 01-110-65-00-5808 05/08/07 68.92 POSTAGE & SHIPPING 02 WATER OP-1 PACKAGE SHIPPED 51-000-65-00-5808 9.64 POSTAGE & SHIPPING INVOICE TOTAL: 78.56 VENDOR TOTAL: 389.16 IKICHEM VIKING CHEMICAL COMPANY 161738 04/03/07 01 WATER OP-CHEMICALS 51-000-65-00-5820 00203502 05/08/07 717.50 CHEMICALS INVOICE TOTAL: 717.50 VENDOR TOTAL: 717.50 SP VISION SERVICE PLAN 041707 04/17/07 01 ADMIN-MAY VISION PLAN 01-110-50-00-5205 05/08/07 954.21 BENEFITS - DENTAL/VISION A INVOICE TOTAL: 954.21 VENDOR TOTAL: 954.21 AREHOUS WAREHOUSE DIRECT P28 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 29 IME: 10:24:57 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- AREHOUS WAREHOUSE DIRECT 203575-0 04/20/07 01 ADMIN-LABELS 01-110-65-00-5802 05/08/07 11.85 OFFICE SUPPLIES INVOICE TOTAL: 11.85 VENDOR TOTAL: 11.85 ATERS THE WATERS CONSULTING 4001965 04/05/07 01 ADMIN-YEARLY SUBSCRIPTION 01-110-64-00-5603 05/08/07 250.00 SUBSCRIPTIONS INVOICE TOTAL: 250.00 VENDOR TOTAL: 250.00 HEATONT WHEATON TRENCHING 040607-EEI 04/06/07 01 ENG-RAYMOND STORM SEWER 01-150-62-00-5401 05/08/07 2,229.70 CONTRACTUAL SERVICES INVOICE TOTAL: 2,229.70 VENDOR TOTAL: 2,229.70 HITAKER WHITTAKER CONSTRUCTION & 022407-EEI 02/24/07 01 WATER IMPROV-FINAL CONTRACT 41-000-61-00-5301 05/08/07 91,906.80 ENGINEERING - GENERAL SERV 02 B.1 WELLS #3 & 4 WELL HOUSE ** COMMENT ** 03 AND TREATMENT FACILITY ** COMMENT ** INVOICE TOTAL: 91,906.80 VENDOR TOTAL: 91,906.80 HOLTIRE WHOLESALE TIRE 118524 04/11/07 01 ENG-OIL CHANGE 01-150-62-00-5409 05/08/07 24.95 MAINTENANCE-VEHICLES INVOICE TOTAL: 24.95 118570 04/13/07 01 POLICE-M19 BATTERY 01-210-62-00-5409 05/08/07 79.95 MAINTENANCE - VEHICLES INVOICE TOTAL: 79.95 VENDOR TOTAL: 104.90 P29 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 30 IME: 10:24:58 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- TRPRD WATER PRODUCTS, INC. 0197855 04/04/07 01 WATER OP-METERS & PARTS 51-000-75-00-7508 00203508 05/08/07 12,912.00 METERS & PARTS INVOICE TOTAL: 12,912.00 0197942 04/09/07 01 WATER OP-REPAIR CLAMP 51-000-65-00-5804 00203508 05/08/07 525.34 OPERATING SUPPLIES INVOICE TOTAL: 525.34 0198044 04/13/07 01 WATER OP-METERS & PARTS 51-000-75-00-7508 00203508 05/08/07 8,369.00 METERS & PARTS INVOICE TOTAL: 8,369.00 VENDOR TOTAL: 21,806.34 YETHATY JOHN JUSTIN WYETH 877 04/23/07 01 ADMIN-ADMIN. LEGAL MATTERS 01-110-61-00-5300 05/08/07 2,962.50 LEGAL SERVICES INVOICE TOTAL: 2,962.50 878 04/23/07 01 ADMIN-EDC LEGAL MATTERS 01-110-61-00-5300 05/08/07 450.00 LEGAL SERVICES INVOICE TOTAL: 450.00 879 04/23/07 01 ADMIN-PW'S LEGAL MATTERS 01-110-61-00-5300 05/08/07 450.00 LEGAL SERVICES INVOICE TOTAL: 450.00 880 04/23/07 01 AR-LANDFILL LEGAL MATTERS 01-000-13-00-1375 05/08/07 2,625.00 A/R LANDFILL INVOICE TOTAL: 2,625.00 881 04/23/07 01 ARO-HARLEM IRVING 01-000-13-00-1372 05/08/07 675.00 A/R-OTHER INVOICE TOTAL: 675.00 P3O ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 31 IME: 10:24:58 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- YETHATY JOHN JUSTIN WYETH 882 04/23/07 01 ARO-TUSCANY PLAZA 01-000-13-00-1372 05/08/07 150.00 A/R-OTHER INVOICE TOTAL: 150.00 883 04/23/07 01 ARO-DTD DEVELOPMENT 01-000-13-00-1372 05/08/07 150.00 A/R-OTHER INVOICE TOTAL: 150.00 884 04/23/07 01 ARO-FOUTAIN VIEW 01-000-13-00-1372 05/08/07 300.00 A/R-OTHER INVOICE TOTAL: 300.00 VENDOR TOTAL: 7,762.50 BSD YORKVILLE BRISTOL 0480-000481528 03/31/07 01 WATER OP-MARCH SLUDGE 51-000-62-00-5407 05/08/07 4,299.70 TREATMENT FACILITIES O&M INVOICE TOTAL: 4,299.70 VENDOR TOTAL: 4,299.70 ORKACE YORKVILLE ACE & RADIO SHACK 108708 04/09/07 01 STREETS-MORTAR MIX 01-410-62-00-5420 05/08/07 59.90 MAINTENANCE-STORM SEWER INVOICE TOTAL: 59.90 108814 04/13/07 01 WATER OP-BOLT, HOOK, CHAIN 51-000-65-00-5804 05/08/07 34.08 OPERATING SUPPLIES INVOICE TOTAL: 34.08 108982 04/20/07 01 WATER OP-BATTERY 51-000-65-00-5804 05/08/07 33.99 OPERATING SUPPLIES INVOICE TOTAL: 33.99 VENDOR TOTAL: 127.97 P31 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 32 IME: 10:24:58 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- ORKCLER YORKVILLE CLERK'S ACCOUNT 100155 04/20/07 01 ARO-CALEDONIA, X-PAC 01-000-13-00-1372 05/08/07 159.00 A/R-OTHER 02 WATER OP-LIEN 51-000-42-00-4240 40.00 BULK WATER SALES INVOICE TOTAL: 199.00 VENDOR TOTAL: 199.00 ORKGFPC YORKVILLE GENERAL FUND 042307 04/23/07 01 ADMIN-MEALS FOR EXCEL CLASS 01-110-64-00-5605 05/08/07 17.36 TRAVEL/MEALS/LODGING 02 ADMIN-REFUND WASTE STICKERS 01-000-42-00-4206 26.00 GARBAGE SURCHARGE 03 ADMIN-TITLE FOR DARE CAR 01-110-65-00-5804 65.00 OPERATING SUPPLIES INVOICE TOTAL: 108.36 VENDOR TOTAL: 108.36 ORKNAPA YORKVILLE NAPA AUTO PARTS 788060 03/22/07 01 POLICE-WRENCH 01-210-65-00-5804 05/08/07 12.01 OPERATING SUPPLIES INVOICE TOTAL: 12.01 VENDOR TOTAL: 12.01 ORKPDPC YORKVILLE POLICE DEPT. 042307 04/23/07 01 ADMIN-BACKGROUND CHECK 01-110-61-00-5300 05/08/07 20.00 LEGAL SERVICES 02 POLICE-BACKGROUND CHECKS 01-210-65-00-5804 40.00 OPERATING SUPPLIES INVOICE TOTAL: 60.00 VENDOR TOTAL: 60.00 ORKSCHO YORKVILLE SCHOOL DIST #115 P32 ATE: 04/25/07 UNITED CITY OF YORKVILLE PAGE: 33 IME: 10:24:59 DETAIL BOARD REPORT D: AP441000.WOW INVOICES DUE ON/BEFORE 05/08/2007 INVOICE # INVOICE ITEM ENDOR # DATE # DESCRIPTION ACCOUNT # P.O. # DUE DATE ITEM AMT ----------------------------------------------------------------------------------------------------------------------------------- ORKSCHO YORKVILLE SCHOOL DIST #115 032907 04/24/07 01 AR-RENT SCHOOL FOR HEARINGS 01-000-13-00-1375 05/08/07 4,321.90 A/R LANDFILL INVOICE TOTAL: 4,321.90 040507 04/18/07 01 AR-RENT SCHOOL FOR HEARINGS 01-000-13-00-1375 05/08/07 1,885.30 A/R LANDFILL INVOICE TOTAL: 1,885.30 VENDOR TOTAL: 6,207.20 ORKSELF YORKVILLE SELF STORAGE, INC 050107-45 04/24/07 01 POLICE-MAY STORAGE 01-210-65-00-5804 05/08/07 75.00 OPERATING SUPPLIES INVOICE TOTAL: 75.00 050107-76 05/01/07 01 MUNICIPAL BLDG-MAY STORAGE 16-000-75-00-7203 05/08/07 75.00 BLDG IMPROVEMENTS-PUBLIC W INVOICE TOTAL: 75.00 050107-83 05/01/07 01 MUNICIPAL BLDG-MAY STORAGE 16-000-75-00-7203 05/08/07 75.00 BLDG IMPROVEMENTS-PUBLIC W INVOICE TOTAL: 75.00 VENDOR TOTAL: 225.00 TOTAL ALL INVOICES: 791,094.13 P33 UNITED CITY OF YORKVILLE PAYROLL SUMMARY 4/14/2007 SOCIAL REGULAR OVERTIME TOTAL IMRF SECURITY TOTALS ADMINISTRATION $28,048.04 $0.00 $28,048.04 $2,068.08 $2,117.50 $32,233.62 LANDFILL $457.13 $457.13 $34.78 $34.97 $526.88 ENGINEERING $10,342.85 $85.49 $10,428.34 $793.60 $782.56 $12,004.50 POLICE $76,450.09 $1,473.07 $77,923.16 $410.27 $5,925.16 $84,258.59 C. DEVELOPMENT $8,726.64 $0.00 $8,726.64 $664.10 $664.02 $10,054.76 PUBLIC WORKS $25,344.07 $3,224.13 $28,568.20 $2,108.15 $2,180.56 $32,856.91 PARKS $14,644.59 $147.35 $14,791.94 $1,125.66 $11125.08 $17,042.68 RECREATION $16,760.93 $0.00 $16,760.93 $11149.73 $1,280.69 $19,191.35 LIBRARY $13,759.95 $0.00 $13,759.95 $438.59 $1,052.71 $15,251.25 TOTALS $194,077.16 $5,387.17 $199,464.331 $8,792.96 $15,163.25 $223,420.54 TOTAL PAYROLL 4/14/2007 $223,420.54 TOTAL INVOICES 5/8/2007 $791 ,094.13 TOTAL DISBURSEMENTS $1,014,514.67 P34 f XT of(, p„IKs&„ Yorkville Parks& Recreation Dept 201 W.Hydraulic St Yorkville, IL 60560 630.553.4357 630.553.4360 fax e-mail:recrea*m@yorkville.il.us Memo To: HRC From: Sue Swithin,Superintendent of Receration Date: 3-28-07 Cc: file, Dave Mogle, Scott Sleezer Re: Optimist Club Request The Optimist Club of Yorkville is requesting the use of the Riverfront Park on Sept.29, 2007 for an Octoberfest Event, from 12:00 to 10:00 pm. They would like the City to waive the rental fee for the park, $100.00 and receive in-kind hours from the Paris Dept. and Recreation Dept.. Staff recommendation is to waive the park rental fee of$100.00 and provide them in-kind hours. The in-kind hours will be decided.and agreed upon by the Park Superintendent at a later date. The Recreation.Dept has already assisted with an insignificant amount of in-kind hours. Thank you, C' Sue 1 STANDARD APPLICATION FOR SHELTERS, GAZEBOS, AND PARKS RESERVATION UNITED C11Y OF YORKVILLE PARK AND RECREATION DEPARTMENT RESERVATION REQUESTS SHALL BE APPROVED BEGINNING ON THE FOLLOWING DATES: SPRING SEASON (MARCH-MAY) FEBRUARY 15T" SUMMER SEASON (JUNE-AUGUST) APRIL 1 5' - FALL SEASON (SEPTEMBER- NOVEMBER) JULY 15T" PLEASE INDICATE TYPE OF GROUP REQUESTING USE BY CIRCLING THE APPROPRIATE CATEGORY CATEGORY A-- GOVERNMENT AND NON-PROFIT ORGANIZATION WHICH ARE LOCATED WITHIN THE UNITED CITY OF YORKVILLE CATEGORY B PRIVATE GROUPS AND INDIVIDUALS WHO ARE COMPRISED OF PREDOMINATELY CAT LEAST 80 0/6) UNITED CITY OF YORKVILLE RESIDENTS CATEGORY C BUSINESS OR CORPORATIONS WHICH ARE LOCATED WITHIN THE UNITED CRY OF YORKVILLE BOUNDARIES CATEGORY D GOVERNMENTAL AND NON-PROFIT ORGANIZATIONS WHICH ARE LOCATED OUTSIDE THE UNITED CITY OF YORKVILLE BOUNDARIES CATEGORY E PRIVATE GROUPS AND INDIVIDUAL WHO DO NOT FALL INTO THE PREDOMINATELY RESIDENT CLASSIFICATION (CATEGORY B) CATEGORY F BUSINESS OR CORPORATIONS WHICH ARE LOCATED OUTSIDE OF THE UNITED CITY OF YORKVILLE BOUNDARIES � ' O r.K v► I le- Q Cl GROUP OR INDIVIDUAL NAME � n CONTACT PERSON -I 5a- HOME PHONE ( V� VJ O�J WORK PHONE i - l 2-1 LOCATION REQUESTED" T` Y L.,I T f V n+ P �\ , WCCS� 72Z O Q OyY� DATE O O BEGIN TIME 1 7,.n Q om, END TIME O • W ryl PURPOSE 0 C� SPECIAL USE REQUESTS (CONCESSION, WATER, ELECTRICAL, OTHER) d4c_frtcoA ,snow4in_u EXPECTED ATTENDANCE OR VISITORS TO YOUR EVENT (PLEASE NOTE: PUBLIC SAFETY MAY REQUIRE ADDITIONAL POLICE PRESENT PENDING THE TYPE OF EVENT AND ATTENDANCE THIS MAY RESULT IN AN ADDITIONAL FEE ASSESSED TO THE GROUP n FOR THIS SERVICE) i�' /'�D, �.���'' WILL YOU BE SELLING ANY PRODUCTS, FOOD, OR MISCELLANEOUS RE V MS?YES (PLEASE EXPLAIN) 4P DJ16yyI J NO J SECURITY DEPOSITS WILL BE FORFEITED IF THE PARK, SHELTER OR GAZEBO IS NOT RESTORED TO THE ORIGINAL STATE, ALL LITTER REMOVED, OR IF`DAMAGE OCCURS AS A RESULT OF MISUSE OR ABUSE TO THE.UNITED CITY OF YORKVILLE PARK AND RECREATION EQUIPMENT OR PROPERTY, INSPECTIONS WILL BE COMPLETED FOLLOWING YOUR EVENT BY A UNITED CITY OF YORKVILI ' PARK AND RECREATION DEPARTMENT STAFF. INDIVIDUALS MAY BE ASSESSED ADDITIONAL CHARGES FOR ExrENDING TIMES PAST THE SCHEDULED RESERVATION. W AND ASIDE_ SIGNED , 0- 242-2107 IN ORDER CO LETS THE REQUEST, THE FOLLOWING DOCUMENTS MUST BE FORWARDED TO THE RECREATION DEPARTMENT: (GROUPS AND ORGANIZATIONS) -A CERTIFICATE OF INSURANCE CO-NAMING THE UNITED CITY OF YORKVILLE AS AN ADDITIONAL INSURED, ASSUMPTION OF LIABILITY AND WAIVER OF SUBROGATION. OFFICIAL USE ADDITIONAL INFORMATION REQUESTED RESERVATION AMOUNT ` V DEPOSIT AMOUNT($1 00) DATE OF REQUEST DATE RECEIVED STAFF INITIALS APPROVED/DENIED REFUND REQUESTED LOCATION ASSIGNED CONCESSION STAND, MERCHANT LICENSE APPLICATIONS NEEDED: YES/NO HEALTH DEPARTMENT PERMIT NEEDED:YES/NO REQUEST FORM FOR SPONSORSHIP FROM THE UNITED CITY OF YORKVILLE PLEASE NOTE: All requests must be received by the City Clerk, United City of Yorkville, 800 Game Farm Road, Yorkville, IL 64560, at least 60 days prior to your event for submittal to the Yorkville Human Resource Commission (HRC), which meets on the third Wednesday of each month.` For example: if your event is to be held on September 15`t',your request should be in the City office no later than June 30 to be considered at the Ady HRC meeting. Requests are limited to$25]0 per year,per organization Event --b Date/Time:g l2� /l 10 Location: R I Vf r4 Y 7f PP a A X ame of Organization Y � m C� b eh�d�,rAddress I I )5 C ret a 'br i ve. City r L State I L- Zip �D0S� a�;� o�-I I W e5f l 22 Co ho+MQ+ Phone: �e-(ODD Fax:�86 2- (0 Name of Contact Person/Title L i'�—& w e 5f IL tc,a-I U Comm 1+1a � 16u r Approximately how many Yorkville residents does your organization,serve each year? 600+ What is the purpose of your organization?-O b Y` n ouL- ' ' `t be- i n K i d S +h rouj ConnrntiniEi siryiecpoa-ramlt? HoVV,d es your or anization b e t the Yorkvi t mm nity? covino b o, C t l oo Co-n 15-e- ' Is your event considered to be(please check all that apply): Fine Arts _Sports Community _Scouting Religion-based Other non-profit Who will benefit from the fun es raised? Youths Adu is Se o bled persons_ o o . b o Please check one: Cash or "In Kind' If ,amount requ t • S �• Staff? V' Yes o If es,number of h ��D ime; If In.Kind, are you in need of S —.N y OR Building space Name of City facility/park to be used V r PLEASE NOTE: If requesting staff dine or use of building faciliiieMpark, both are subject to availability on the date you have chosen. DEPOSIT FEES WILL NOT BE 'WANED. IF FACILITIES ARE RETURNED TO SAME CONDITION AS BEFORE USE, 100036 DEPOSIT REFUND WILL BE .RETURNED WITHIN 10 BUSINESS DAYS. For OfffcWHRC use only HRC Approved: Date: or _"in Idnd" OFFICE: Date Received: Building/facility Requested: Requested Facility/Park: _Available Not Available Signed: Requested Staff: Available Not Available Signed: Date of Notice to by City Council: Date Not Approved Reason: cc xevieea 03/28/06 CC Approved 03/28/06 United City of Yorkville Historical Street Naming Program Name of nominated individual: Barbra Joan Groesch Phone number: 920 563-9052 Reason for nomination: Barbra Joan Groesch moved to the outskirts of Yorkville in 1967 with her three children and husband Richard. The young family found Yorkville very inviting where Barb, a florist at trade,believed in the rural city so much that she felt it would be the perfect setting for her new florist business. The florist was named after her trade specialty, "The Brides Flower Shop". The business started in the basement at her residence,but quickly grew out of that cramped quarters. A downtown Yorkville location was than obtained along with a business partner Donna Diehl, and the business officially started in 1973. During this venture she was a member of the American Business Women's Associations,Aurora chapter and always felt that the Yorkville area was large enough to have their own charter. After talking to several business women of the area a few organizational meetings were conducted. The Yorkville associations' goal would be to assist local women to obtain their college degree through scholarship money produced by their local chapter. A charter newsletter that would encompass the Kendall County area was composed; the name would be, The POSY(Plano Oswego Sandwich Yorkville) Patch. This newsletter was imperative to the cohesiveness of the American Business Women's Association's meetings. In the beginning the POSY Patch was a one woman's show that consisted of writing, copying, and mailing to all members on a monthly basis. The meetings were arranged on a monthly foundation that entailed setting a location and speaker for each. The general meetings would also need to be prepared for by setting an agenda and completing all executive business. With the help of the Aurora Chapter the responsibility of these duties fell squarely on the shoulders of the founder, Barb. These duties motivated her further to make this organization the best it could be which enthralled her to learn the inter-workings of the local government and businesses alike. As a woman in business this was a time in society when it was a delicate road to navigate. Barb's warmth and upbeat personality endeared all to work with her for the betterment of Yorkville. Barb worked with ABWA for over 17 years proudly working on the executive board as president,vice-president, and secretary,and than retired to Wisconsin with her husband. The American Business Women's Association, LaFox Chapter is still in existence to this day helping the future generations of women with the rigorous ventures of starting and thriving in the Kendall County business world. During Barb's passion of starting the Yorkville chapter of ABWA her contribution did not end there but more like splintered off into several other undertakings. Her love of horticulture that carries onto today brought her to a new project. In 1972, Barb worked with the Yorkville School District 115 in an attempt to bring updated classes to the students of Yorkville. A new program at the time was a joint venture through several school districts to create a vocational school. The steering committee that Barb was part of assisted in creating the Indian Valley Vocational Center(IVVC). This multi-school district partnership allowed students to learn and take that knowledge directly to the workplace. The Illinois Extension Office created a Home Extension Association that Barb was very committed to. During the years of 1972-1980 she was very resourceful and helped the association help other people. She taught several classes at the extension office and was also on the executive board working as their president for several terms. Barb was also the Yorkville Chamber of Commerce Executive Director for two years in the 1980's. She worked diligently helping the local businesses through initiating more business from outside Kendall County for the individual member and worked on enlarging their membership. This program was the preface of the Economic Development Commission that she also was a member of. Barb was the first woman to be a member of this organization. On a personal level Barb was very active at St. Patrick's church and worked with the St. Patrick's Women's Auxiliary. She held several executive board positions including president, vice president, and secretary during her tenure there. The Christian organizations mission was to help parish members that extended throughout the entire community. They were also very dedicated to fundraising in an effort to financially help the school and church. I'm writing this on behave of my mother who not only educated her children on how to be good citizens, but also showed us by example on how to be good citizens. This type of education has a ripple effect that only magnifies her actions through her children's deeds,which continues her course of positive moral character,to touch future generations. Name of nominators: Barry Groesch, Laurie Houle, and Rick Groesch Address: 37 Ponderosa Drive Yorkville, IL 60560 Phone number: 630 553-7693 E-mail: bgroesch @yorkville.il.us J `��9 CITY Open Letter to the Community United City of Yorkville's Human Resource Commission 800 Game Farm Road, Yorkville, IL 60560 The Human Resource Commission of the United City of Yorkville has been asked to spearhead a Historical Street Naming process for the City. Due to growth within the City, many new roads will need to be named. We believe that there are many people in our community who could be honored by the City naming a street in their honor The Human Resource Commission is accepting names of deserving citizens, living or deceased for this honor The following is a list of guidelines for names submitted to the Commission: 1. Streets should be named after a citizen or family, whether living or deceased; important event; historical location or company. 2. If living,the person being recognized should be consulted. If deceased, the family should be consulted. 3. In order to be considered, an individual should have lived in the city or have made a major historical contribution to the community. Major contribution is defined as a significant contribution to the community, which has enriched or improved the community and the people living in the community. 4. This individual(s) general reputation shall have been above reproach. 5. This major contribution could be accomplished through financial means, community service, active work, or leadership in the community. 6. In order to be considered, an individual must have completed the contribution for which he/she is being recogni zed. 7. Any citizen the United City of Yorkville or from outside the community can nominate an individual(s) name as a historical street name. be ongoing, new names will be added to the recommended list at 8. Compilation of the list of names will least annually. 9. All nominations will be reviewed by the Human Resource Commission, which will make a recommen- dation to the City Council. 10. All recommended historical street names will be reviewed by the City Engineer, KenCom, and the U.S. Post Office to avoid duplications. with a minimum one name from the recommended list unless 11. Developers must use a minimum of ten percent determined otherwise by the City Council. 12. Priorities may change based on recommendations from the Human Resource Commission. 13. Decisions regarding historical street names will be made by the Yorkville City Council; and, its decisions will be considered final. — — — — — — - - - - - - - — — — — — — — — — - - — — — — ——— ——— — United City of Yorkville Historical Street Naming domination Mail to: United City of Yorkville,Attn: Human Resource Commission, 800 Game Farm Road,Yorkville, IL 60560 Name of nominated individual/family Phone number O1 Last known address .: s /..r./�/ ^, •jam_ � ' � ' •' R Reason for nomination «•. L/ 7 < Name of nominator • ' -< 4.�ddress J`^J�`�'"JAI l E-mail if applicable Phone number rit lv 9/05 Ralph and Arlene Blake came to Yorkville in 1937, and lived here until moving to a retirement community in 2002 . During these years, they were active in the Yorkville Methodist Church, with Arlene teaching Sunday .School for several years . In addition to rearing five children, Arlene was active in the community. She taught vocal music at Yorkville Grade School in the 50s . She had previously taught at country schools, and went ., on to finish her teaching career in Plano. Arlene was a Girl Scout leader for several years, and also taught Red Cross First-Aid courses . In 1955, Arlene ' s inspiation initiated Yorkville ' s 4th of July celebration, which the city enjoys to this day. Ralph joined the Bristol-Kendall Fire Department in 1937, and retired in 1973 , after serving as chief for several years . During the 40s and 50s , he also served as a County Sheriff ' s Deputy, under three different sheriffs, his last four years as Chief Deputy. He taught Red Cross First-Aid in the 50s . Ralph volunteered many years for the Crop Walk, first as a walker, later manning a station. After retiring, he helped for several years at the Kendall County Food Pantry. C/r O United City of Yorkville Memo 800 Game Farm Road EST. 1 _ 1636 Yorkville, Illinois 60560 Telephone: 630-553-4350 Fax: 630-553-7575 <�E ��'�• To: Mayor Art Prochaska, City Council Fr: Glory Spies, Community Relations Officer Re: Historical Street Nominations for Founding Fathers of the United City of Yorkville Date: 04/26/2007 In honor of the United City of Yorkville's 50'h Anniversary Celebration the Human Resources Commission has nominated the names of five original Founding Fathers who currently have not been nominated. Those names include Delbert Trummel, Dick Mitchell, Wayne Larson, Russ Hughes and Bill Randels. These names, along with the names of Ralph and Arlene Blake, and Barbra Joan Groesch have been recommended by the HRC to move to the Committee of the Whole and then to City Council for final approval. In a memo dated April 13 from Jennifer Fischer in the Engineering Department,the name Dick Mitchell is unavailable. In order to properly honor Mr. Mitchell as a Founding Father two recommendations were made by the HRC. The first recommendation is to make an exception to the guidelines and use Mr. Mitchell's full name—Richard Mitchell. In this case any developer who chooses the name would have to use Richard Mitchell as the proper street name. The second recommendation is to contact one of Mr. Mitchell's relatives and see if his middle name would be available. Any other recommendations on how to honor Mr. Mitchell would be open for discussion. The HRC would like a recommendation from the City Council on how to proceed with the honoring of Mr. Mitchell in order to move the names forward for the remaining 50th Anniversary celebration. United City of Yorkville ESt ` 1836 County Seat of Kendall County `r 800 Game Farm Road Yorkville, Illinois, 60560 Telephone: 630-553-8528 <<E Fax: 630-553-3436 Website: www.yorkville.il.us Date: April 13,2007 To: Glory Spies,Public Relations Manager Cc: Police Chief Harold Martin Alderman Jim Bock City Engineer Joe Wywrot From: Jennifer Fischer,Engineering Admin.Assistant Subject: Historical Street Names/New proposals/ Glory, as we agreed, I have checked the names of those proposed &/or nominated as historical persons for street signage; for duplications and similarities to street names existing & reserved in Yorkville and the surrounding unincorporated area.Below are the findings: Ralph&Arlene Blake:All three names are available for use as of 4-13-07. Delbert Trummel:Both names are available for use as of 4-13-07. Dick Mitchell: Richard &Mitchell are both unavailable for use. Written request made by Kencom not to use the name Dick Wayne Larson:Both names are available for use as of 4-13-07. Russ Hughes:Russ/Russell is available for use as of 4-13-07.Hughes is unavailable for use. Bill Randels:Bill&Randels are both available for use as of 4-13-07.William is unavailable for use. Ton&Theresa Kager: All three names are available for use as of 3-30-07. Theresa was misspelled on the original nomination submission,but verbally corrected by the nominator. Barbra Joan Groesch:All three names are available for use as of 3-30-07.The spelling of Barbra has been confirmed with the nominator as correct. Although the above names have been checked for availability, none of the above has been added to the list of approved historical street names; this is just to make the Human Resource Commission aware of what is&what is not available as of the above dates, should they wish to take this into account when considering the nominations. Approval by the HRC may not necessarily constitute use of a person's name as a street name in Yorkville, due to street names already existing & reserved for use in Yorkville and the surrounding unincorporated areas. Please advise as soon as possible if the HRC has approved any of the above names, so that I may reserve them for use at a later date. Please remember also that the County does not check the City's database of reserved names for their developments; therefore although a particular name may be available now, it may no longer be such when a developer selects it for use in their development at a later date.