The URL can be used to link to this page

2003-08-18 - Village Board Regular Meeting - Agenda Packet VI VILLAGE OF u «AGE OF 13ufovefalo Gr BUFFALO GROVE Fifty Raupp Blvd. Buffalo Grove,IL 60089-2100 Meetingof the Village of Buffalo Grove Board of Trustees Phone 847-459-2500 g Fax 847-459-0332 Regular Meeting August 18, 2003 7:30 PM I. Call to Order I1. Pledge of Allegiance III. Roll Call IV. Approval of Minutes A. Minutes of the August 4, 2003 Village Board Meeting V. Approval of Warrant Warrant#988 VI. Village President Report A. Resolution No. 2003-37, Commending Marla Chorney for her Years of Service to Buffalo Grove as a Member of the Commission for Residents with Disabilities (Trustee Kahn) B. Proclamation: School's Open - Safety Week (President Hartstein) C. ESDA Commission Appointment - Robert Giddens, Village of Buffalo Grove (President Hartstein) VII. Reports from the Trustees VIII. Village Manager's Report A. Monthly Report for July 2003 B. Overview of the Village's second annual Buffalo Grove Invitational Fine Art Festival. IX. Special Business X. Questions from the Audience Discussion on questions from the audience will be limited to 10 minutes. Presentations before the Village Board should be scheduled through the Village Manager's Office five days prior to each meeting. Xl. Consent Agenda All items listed on the Consent Agenda, which are available in this room this evening, are considered to be routine by the Village Board and will be enacted by one motion. There will be no separate discussion of these items unless a Board member or citizen so requests, in which event, the item will be removed from the General Order of Business and considered after all other Regular Agenda items. (Attached). XII. Ordinances and Resolutions A. Ordinance 2003: An Ordinance Authorizing the Disposal of Surplus Village Personal Property. (Trustee Johnson) XIII. Old Business XIV. New Business A. Authorization to Executive 2nd Year Option of 3-Year Custodial Service Contract. (Trustee Braiman) XV. Executive Session XVI. Adjournment: Approximately 10:30 p.m. The Village Board will make every effort to accommodate all items on the agenda by 10:30 p.m. The Board, does, however, reserve the right to defer consideration of matters to another meeting should the discussion run past 10:30 p.m. The Village of Buffalo Grove, in compliance with the Americans With Disabilities Act, requests that persons with disabilities, who require certain accommodations to allow them to observe and/or participate in this meeting or have questions about the accessibility of the meeting or facilities, contact the ADA Coordinator at 459-2518 to allow the Village to make reasonable accommodations for those persons. Consent Agenda August 18, 2003 7:30 PM Xl. Ordinances and Resolutions None New Business A. Annual Report of Condition-Firefighter's Pension Fund-Tax Year 2003 (Trustee Johnson) RECOMMENDATION: Approve by motion. SUMMARY: State law requires that the Fire Pension Fund Board of Trustees submit a report prior to the adoption of the Village's 2003 property tax levy regarding it's fiscal condition. B. Annual Report of Condition-Police Pension Fund-Tax Year 2003 (Trustee Johnson) RECOMMENDATION: Approve by motion. SUMMARY: State law requires that the Police Pension Fund Board of Trustees submit a report prior to the adoption of the Village's 2003 property tax levy regarding it's fiscal condition C. Authorization to Purchase Microsoft Office XP Standard and Windows XP Operating System using the State of Illinois Purchasing Contract# E901359 (Trustee Johnson) RECOMMENDATION: Approve by motion. SUMMARY: Old Business None Meeting of the Village of Buffalo Grove Board of Trustees Regular Meeting August 18, 2003 7:30 PM I. Call to Order II. Pledge of Allegiance III. Roll Call IV. Approval of Minutes V. Approval of Warrant VI. Village President Report VII. Reports from the Trustees Vill. Village Manager's Report IX. Special Business X. Questions from the Audience Discussion on questions from the audience will be limited to 10 minutes. Presentations before the Village Board should be scheduled through the Village Manager's Office five days prior to each meeting. XI. Consent Agenda None XII. Ordinances and Resolutions XIII. Old Business XIV. New Business XV. Executive Session XVI. Adjournment: Approximately 10.30 p.m. The Village Board will make every effort to accommodate all items on the agenda by 10.30 p.m. The Board, does, however, reserve the right to defer consideration of matters to another meeting should the discussion run past 10.30 p.m. The Village of Buffalo Grove, in compliance with the Americans With Disabilities Act, requests that persons with disabilities, who require certain accommodations to allow them to observe and/or participate in this meeting or have questions about the accessibility of the meeting or facilities, contact the ADA Coordinator at 459-2518 to allow the Village to make reasonable accommodations for those persons. Consent Agenda August 18, 2003 7:30 PM XI. Ordinances and Resolutions None New Business None Old Business None DRAFT COPY 11397 8/4/03 MINUTES OF THE REGULAR MEETING OF THE VILLAGE BOARD OF THE VILLAGE OF BUFFALO GROVE,HELD IN THE COUNCIL CHAMBERS,50 RAUPP BOULEVARD, BUFFALO GROVE,ILLINOIS ON MONDAY,AUGUST 4,2003 CALL TO ORDER President Hartstein called the meeting to order at 7:33 P.M. Those present stood and pledged allegiance to the Flag. ROLL CALL Roll call indicated the following present: President Hartstein;Trustees Braiman,Glover,Berman,Johnson,Kahn and Trilling. Also present were:William Balling,Village Manager;William Raysa,Village Attorney;William Brimm,Assistant Village Manager/Finance Director; Ghida Neukirch,Assistant Village Manager;Art Malinowski,Human Resources Director;Robert Giddens,MIS Director;Richard Kuenkler,Village Engineer;Robert Pfeil,Village Planner; Greg Summers,Assistant Village Planner;Police Chief Balinski; Sgt.Jamie Dunne; and Joe Tenerelli,Village Treasurer. APPROVAL OF MINUTES Moved by Glover,seconded by Berman,to approve the minutes of the July 21,2003 Regular Meeting.Upon roll call,Trustees voted as follows: AYES: 5—Braiman,Glover,Berman,Kahn,Trilling NAYS: 0—None ABSTAIN: 1 —Johnson Motion declared carried. WARRANT#987 Mr.Tenerelli read Warrant#987. Moved by Braiman,seconded by Glover,to approve Warrant#987 in the amount of $1,202,313.30 authorizing payment of bills listed. Upon roll call,Trustees voted as follows: AYES: 6—Braiman,Glover,Berman,Johnson,Kahn,Trilling NAYS: 0—None Motion declared carried. BUFFALO GROVE ARTS FESTIVAL President Hartstein thanked everyone involved in making the second annual Buffalo Grove Arts Festival a tremendous success. Special recognition will be given to all the volunteers at the August 18,2003 Regular Board Meeting. RELAY FOR LIFE President Hartstein read a letter from the American Cancer Society thanking the Village of Buffalo Grove for all of its support in this year's Relay for Life,which raised over$100,000;he again commended the students of Buffalo Grove and Stevenson High Schools,the Board and the community for making this such a successful event. BLOOD DRIVE Trustee Kahn reminded everyone of the Blood Drive to be held on Saturday,August 30,2003 in conjunction with Buffalo Grove Days,and he urged residents to mark that date and donate at that time. DRAFT COPY 11398 8/4/03 914 HOBSON DRIVE Mr.Balling sun narized and presented an update on the street ponding issue at 914 Hobson Drive;details on this issue may be found in the Village Board Meeting Agenda Item Overview. Lengthy discussion took place with regard to the best way to handle this situation; staff answered many questions from the Board primarily regarding safety and liability. Moved by Johnson,seconded by Berman,to defer this issue until the September 8,2003 Special Meeting,at which time staff will be able to provide further recommendation. QUESTIONS FROM THE AUDIENCE President Hartstein asked if there were any questions from the audience;there were none. CONSENT AGENDA President Hartstein explained the Consent Agenda,stating that any member of the audience or the Board could request that an item be removed for full discussion;it was requested that Item XI.B.be removed from the Consent Agenda. The Village Clerk then read a brief synopsis of each of the items on the Consent Agenda. Moved by Braiman,seconded by Glover,to approve the Consent Agenda. ORDINANCE No.2003-58—Ernmency Access Lanes Motion to approve Ordinance No.2003-58,providing for Emergency Access Lanes for the Buffalo Grove Town Center. ORDINANCE NO.2003-60—Title 10 Motion to approve Ordinance No.2003-60,amending Title 10 of the Village of Buffalo Grove Municipal Code (Designation of No Parking within the Windsor Ridge subdivision). RESOLUTION NO.2003-36—Stormwater Covenant Motion to approved Resolution No.2003-36,authorizing the execution of a Stowmwater Covenant. PARKWAY TREE REPLACEMENT—Authorization to bid Motion to authorize to bid the 2003 Parkway Tree Replacement. SANITARY&STORMWATER TELEVISING—Award of Bid Motion to authorize the award of bid—Sanitary and Stormwater Televising for 2003. Upon roll call,Trustees voted as follows: AYES: 6—Braiman,Glover,Berman,Johnson,Kahn,Trilling NAYS: 0—None Motion declared carried. ORDINANCE#2003-59—TACOS OF BUFFALO GROVE Moved by Johnson,seconded by Berman,to pass Ordinance#2003-59,amending Chapter 5.20,Liquor Controls, Class B,Tacos of Buffalo Grove. Upon roll call,Trustees voted as follows: AYES: 6—Braiman,Glover,Berman,Johnson,Kahn,Trilling NAYS: 0—None DRAFT COPY Motion declared carried. 11399 8/4/03 ORDINANCE#2003-60—WINDSOR RIDGE PARKING Trustee Braiman explained the reason that he had asked that this item be removed from the Consent Agenda,which related to the time period that the parking restriction would be in effect. Moved by Berman,seconded by Johnson,to pass Ordinance#2003-60,amending Title 10 of the Village of Buffalo Grove Municipal Code(designation of No Parking within the Windsor Ridge Subdivision). Upon roll call,Trustees voted as follows: AYES: 6—Braiman,Glover,Berman,Johnson,Kahn,Trilling NAYS: 0—None Motion declared carried. ZBA APPEAL—218 THOMPSON Beth Cohen,218 Thompson Boulevard,explained the safety issue that she and husband believe exists at her home, and she sunnnarized the reason that they are appealing the denial by the Zoning Board of Appeals to construct a circular driveway on their lot. Commissioner Sandler reviewed the deliberations and decision of the ZBA. After further discussion,it was moved by Kahn,seconded by Braiman,to reverse the decision made by the ZBA in accordance with the terms outlined in documentation provided to the Board. It was noted that the Board is very hesitant to overturn decisions made by the ZBA,but in this particular case,it does appear to be a unique circumstance. Upon roll call,Trustees voted as follows: AYES: 4—Braiman,Johnson,Kahn,Trilling NAYS: 2—Glover,Bennan Motion declared carried. MOBILE DATA TERMINAL SYSTEMS Moved by Johnson,seconded by Kahn,to authorize bids for Mobile Data Terminal Systems as presented. Upon roll call,Trustees voted as follows: AYES: 6—Braiman,Glover,Berman,Johnson,Kahn,Trilling NAYS: 0—None Motion declared carried. EXECUTIVE MEETING Moved by Johnson,seconded by Braiman,to move to Executive Meeting for the purpose of discussing Personnel and Land Acquisition. Upon roll call,Trustees voted as follows: AYES: 6—Braiman,Glover,Berman,Johnson,Kahn,Trilling NAYS: 0—None Motion declared carried. The Board moved to Executive Meeting from 8:47 P.M.until 9:47 P.M. DRAFT COPY 11400 8/4/03 ADJOURNMENT Moved by Glover,seconded by Braiman,to adjourn the meeting. Upon voice vote,the motion was unanimously declared carried. The meeting was adjourned at 9:47 P.M. Janet M. Sirabian,Village Clerk APPROVED BY ME THIS DAY OF ,2003 Village President VILLAGE OF BUFFALO GROVE WARRANT#988 18-Aug-03 Corporate Fund: Reimbursement 25,028.68 Unemployment Insurance 0.00 Revenue Reimbursements 133,782.62 Legislative 2,338.47 Office of Village Manager 5,683.53 Planning 0.00 Management Information Systems 10,047.21 Legal ' 4,414.06 Finance&General Services 17,602.60 Fire Services 98,328.45 Police Services 114,377.80 Building&Zoning 12,381.78 Engineering Services 7,541.74 Building&Grounds 15,579.47 Street& Bridge Operations 14,630.42 Street&Bridge Administration 5,248.46 Forestry f1,763.19 Central Garage 11,193.30 ESDA 276.05 Transfer/Non Operating 52,859.56 Total 543,077.39 IMRF: Employee Contributions 0.00 Employer Contributions 0.00 Total 0.00 Parking Lot Fund: 3,829.09 Motor Fuel Tax Fund: 0.00 Capital Projects-Facilities: 9,219.00 Capital Projects-Streets: 16,526.73 Contractual Street Maintenance Debt Service Fund: 0.00 Bond& Interest Fund#1: 0.00 Bond &Interest Fund#2: 0.00 Bond& Interest Fund#3: 0.00 Facilities Development Debt Service: 0.00 Police Pension Fund: 0.00 Fire Pension Fund: 4,037.50 R.H.S. 0.00 Water Fund: Reimbursements 7,052.00 Revenue Reimbursements 1,500.00 Water Operations 35,587.84 Sewer Operations 146,037.67 Total 190,177.51 Buffalo Grove Golf Fund: Reimbursements 0.00 Expenses 38,678.43 Total 38,678.43 Arboretum Golf Fund: Reimbursements 1,375.00 Expenses 55,367.49 Total 56,742.49 MIS Replacement Fund 8,874.02 Refuse Service Fund: 72,467.39 PAYROLL PERIOD ENDING 08/10/03 650,775.47 PAYROLL PERIOD ENDING TOTAL WARRANT#988 1,591405.02 APPROVED FOR PAYMENT BY THE PRESIDENT AND BOARD OF TRUSTEES OF THE VILLAGE OF BUFFALO GROVE, ILLINOIS Village Clerk Village President 08110103 AdJ Bonus(Sept) Balance Net Earnings 389,997.82 389,997.82 Federal W/H PENMO 945 0.00 Federal W/H BW 941 70,186.42 70,186.42 Federal W/H MO 941 0.00 Credit Union 23,886.31 23,886.31 State W/H 14,898.88 14,898.88 State W/H Wisc 557.88 557.88 United Way 251.00 251.00 AFLAC 13.30 13.30 Police Pension 16,562.87 16,562.87 Fire Pension 12,444.11 12,444.11 Flex Savings 2,127.22 : 2,127.22 Dependent Care 411.30 411.30 Retiree Health Sav 1,214.18 1,214.18 ICMA Employee 25,859.70 25,859.70 ICMA Employer 1,813.07 1,813.07 PPO Premium Deduct 8,814.51 8,814.51 I PBC/Retirees 0.00 FICA 16,478.19 16,478.19 32,956.38 FOP 85.00 85.00 Medicare 7,434.99 7,434.99 14,869.98 47,826.36 Fire Dues 1,248.00 1,248.00 Life Insurance 0.00 PC Purchase 1,296.83 1,296.83 Garnishments 4,195.09 4,195.09 Suspension 0.00 General Fund Fire 236.00 236.00 Sub-total 600,012.67 0.00 0.00 600,012.67 623,925.85 IMRF-Supplement 141.30 141.30 IMRF-Employee 0.00 11,087.52 11,087.52 IMRF-Employer 0.00 15,620.80 16,620.80 Gross Payroll 626,862.29 0.00 0.00 626,862.29 650,775.47 Bank Transfer Equals total of Payd Dist by Org ;ee Pay Adjustment Register, Current Employer Expense Payroll Gross 650,775.47 Bank Sheets should always=this# Water/Sewer 23,316.32 Police Pension Fire Pension BG Golf 26,631.67 Arb Golf 25,171.64 Difference between Pyrl Gross 575,655.84 Total Other Funds 75,119.63 less water/golf/pension f T Date: 08/14/03 10:45 Village of Buffalo Grove Page: 1 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000010 CORPORATE FUND VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 99998 MARK CONLEY 181060 064064 224 DEP DIA 1,000.00 181067 064075 224 DEP DIA 1,000.00 181079 063970 224 DEP DIA 1,000.00 183301 064068 224 DEP DIA 1,000.00 *TOTAL VENDOR -> ONE-TIME VENDORS 4,000.00 422850 I.P.B.C. SEPT 2003 064210 221 GRP MED & LIFE 7,916.66 SEPT 2003 064210 221 GRP MED & LIFE 2,190.54 *TOTAL VENDOR I.P.B.C. 10,107.20 * 902750 VILLAGE OF BUFFALO GROVE 8/1/03 064180 136 PERS PROP REP TAX 1,375.97 *TOTAL VENDOR VILLAGE OF BUFFALO 1,375.97 * 903010 VILLAGE OF BUFFALO GROVE JULY 03 064171 127 INT INV POOL 1,104.36 *TOTAL VENDOR VILLAGE OF BUFFALO 1,104.36 903030 VILLAGE OF BUFFALO GROVE JULY 03 064168 123 INT INV POOL 68.47 *TOTAL VENDOR VILLAGE OF BUFFALO 68.47 * 903040 VILLAGE OF BUFFALO GROVE JULY 03 064169 124 INT INV POOL 1,840.59 *TOTAL VENDOR VILLAGE OF BUFFALO 1,840.59 * 903080 VILLAGE OF BUFFALO GROVE 8/1/03 064176 126 PERS PROP REP TAX 256.54 JULY 03 064170 126 INT INV POOL 5.89 *TOTAL VENDOR VILLAGE OF BUFFALO 262.43 * 903130 VBG-FAC DEV DEBT SERV FND 8/1/03 064177 128 PERS PROP REP TAX 1,383.75 8/1/03 064177 128 PERS PROP REP TAX 419.79 8/1/03 064177 128 PERS PROP REP TAX 2,394.35 *TOTAL VENDOR VBG-FAC DEV DEBT SE 4,197.89 * 903140 VILLAGE OF BUFFALO GROVE 8/7/03 064175 131 PERS PROP REP TAX 76.58 *TOTAL VENDOR VILLAGE OF BUFFALO 76.58 * Date: 08/14/03 10:45 Village of Buffalo Grove Page: 2 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000010 CORPORATE FUND VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 903240 VILLAGE OF BUFFALO GROVE 8/7/03 064174 130 PERS PROP REP TAX 67.72 *TOTAL VENDOR VILLAGE OF BUFFALO 67.72 * 903280 VILLAGE OF BUFFALO GROVE JULY 03 064172 132 INT INV POOL 160.50 *TOTAL VENDOR VILLAGE OF BUFFALO 160.50 * 903340 VILLAGE OF BUFFALO GROVE JULY 03 064173 133 INT INV POOL 1,766.97 *TOTAL VENDOR VILLAGE OF BUFFALO 1,766.97 * **TOTAL CORPORATE FUND 25,028.68 I I Date: 08/14/03 10:45 Village of Buffalo Grove Page: 3 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000210 CORPORATE REVENUE VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 48410 ANDRES MEDICAL BILLING 15252 064188 1259 AMB TRANSP FEES 2,368.30 *TOTAL VENDOR ANDRES MEDICAL BILL 2,368.30 * 364410 EDWARD HINES LUMBER CO MAY 2003 064028 1073 ST SALES TAX/HOME 43,052.00 MAY 2003 064028 1053 ST SALES TAX/HOME 86,104.00 *TOTAL VENDOR EDWARD HINES LUMBER 129,156.00 * 433300 INTOXIMETERS, INC. 7/22/03 063988 1299 DUE ASS PURCH 2,070.00 *TOTAL VENDOR INTOXIMETERS, INC. 2,070.00 * 598510 NCI, INC 48956 064223 1253 VILLAGE ORD FINES 154.00 *TOTAL VENDOR NCI, INC 154.00 * 687700 PADDOCK PUBLICATIONS,INC. T3087063 063998 1299 ALL OTHER EXP 34.32 *TOTAL VENDOR PADDOCK PUBLICATION 34.32 * **TOTAL CORPORATE REVENUE 133,782.62 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 4 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000401 LEGISLATIVE VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 36570 AMERICAN CHARGE SERVICE 7/21/03 064057 4942 SR CIT TAXI 20.00 *TOTAL VENDOR AMERICAN CHARGE SER 20.00 * 124403 CART MART, INC. 126594 064191 3718 ARTS COMM 230.00 *TOTAL VENDOR CART MART, INC. 230.00 * 160360 CROWN TROPHY MULTIPLE 064065 3722 ALL OTHER EXP/ART 50.00 MULTIPLE 064065 3718 ALL OTHER EXP/ART 70.00 *TOTAL VENDOR CROWN TROPHY 120.00 * 325970 GREAT FRAME UP 5260373 064126 3718 ARTS COMM 166.40 *TOTAL VENDOR GREAT FRAME UP 166.40 326042 HOWARD GREEN 8/8/03 064071 3722 SYMP BAND 1,000.00 *TOTAL VENDOR HOWARD GREEN 1,000.00 589550 MUNICIPAL MARKING DIST. 28143 064076 3713 MISC SUPP/BG DAYS 108.75 *TOTAL VENDOR MUNICIPAL MARKING D 108.75 * 842100 303 TAXI 93771 064084 4942 SR CIT TAXI 12.50 *TOTAL VENDOR 303 TAXI 12.50 * 881082 UNITED RENTALS HWY TECH 1039384 064054 3718 ARTS COMM 382.00 *TOTAL VENDOR UNITED RENTALS HWY 382.00 * 903230 VBG VIL MGRS OFFICE 8/13/03 064235 3215 MISC EXP 5.09 8/13/03 064235 3718 MISC EXP 21.00 *TOTAL VENDOR VBG VIL MGRS OFFICE 26.09 * 933660 WHITE WAY SIGN & MAINT 204859 064121 4935 ALL OTHER EXP 272.73 *TOTAL VENDOR WHITE WAY SIGN & MA 272.73 * **TOTAL LEGISLATIVE 2,172.07 166.40 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 5 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000405 LEGISLATIVE VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED Date: 08/14/03 10:45 Village of Buffalo Grove Page: 6 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000405 OFC VLG MANAGER VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 10550 AIM BUSINESS PRINTERS MISC 064185 3240 OFF SUPP 95.00 *TOTAL VENDOR AIM BUSINESS PRINTE 95.00 * 80000 WILLIAM R BALLING 4865 JLY 0 064059 3211 TELEPHONE 64.87 *TOTAL VENDOR WILLIAM R BALLING 64.87 * 139072 CHICAGO HILTON HOTEL DEAL MAKIN 064061 4935 ALL OTHER EXP 96.00 *TOTAL VENDOR CHICAGO HILTON HOTE 96.00 * 155034 CORPORATE EXPRESS MULTIPLE 064199 3240 OFFICE SUPP 25.30 *TOTAL VENDOR CORPORATE EXPRESS 25.30 * 160360 CROWN TROPHY MULTIPLE 064065 4935 ALL OTHER EXP/ART 9.45 *TOTAL VENDOR CROWN TROPHY 9.45 * 307637 GES EXPOSITION SERV 10/2-3/03 064070 4935 ALL OTHER EXP 215.05 *TOTAL VENDOR GES EXPOSITION SERV 215.05 * 376000 ILCMA YR 03-04-V 064074 3113 MEMBERSHIP/DUES 100.00 *TOTAL VENDOR ILCMA 100.00 * 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 176.27- SEPT 2003 064210 3111 GRP MED & LIFE 4,502.03 *TOTAL VENDOR I.P.B.C. 4,325.76 * 719413 PROGRESSIVE MGMT SERV 7/29/03 064080 3215 REC COMM AFF 82.19 *TOTAL VENDOR PROGRESSIVE MGMT SE 82.19 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 560.00 *TOTAL VENDOR VILLAGE OF BUFFALO 560.00 * 903230 VBG VIL MGRS OFFICE 8/13/03 064235 4935 MISC EXP 1.91 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 7 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000405 OFC VLG MANAGER VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 8/13/03 064235 3112 MISC EXP 108.00 *TOTAL VENDOR VBG VIL MGRS OFFICE 109.91 **TOTAL OFC VLG MANAGER 5,683.53 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 8 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000407 MIS VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 78.01- *TOTAL VENDOR I.P.B.C. 78.01-* 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 2,806.22 *TOTAL VENDOR I.P.B.C. 2,806.22 * 620200 NOVA BUS TECHNOLOGIES MULTIPLE 064077 3221 COMP SERV 945.00 MULTIPLE 064077 3221 COMP SERV 3,255.00 *TOTAL VENDOR NOVA BUS TECHNOLOGI 4,200.00 * 749500 RMS INFO TECH INTEG MULTIPLE 064081 4313 OFF EQUIP/COMP SE 2,104.00 MULTIPLE 064081 3221 OFF EQUIP/COMP SE 775.00 *TOTAL VENDOR RMS INFO TECH INTEG 2,879.00 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 240.00 *TOTAL VENDOR VILLAGE OF BUFFALO 240.00 * **TOTAL MIS 10,047.21 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 9 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000408 LEGAL SERVICES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 200412 DYNAMEX 149859 064066 3617 MSGR FEES 36.88 *TOTAL VENDOR DYNAMEX 36.88 * 512800 LAKE CO RECORDER MULTIPLE 064214 3615 RECORDING FEES 164.00 *TOTAL VENDOR LAKE CO RECORDER 164.00 * 687700 PADDOCK PUBLICATIONS,INC. 8/2/03 064229 3618 LEGAL NOTICES 75.60 *TOTAL VENDOR PADDOCK PUBLICATION 75.60 * 735200 WILLIAM RAYSA AUG 03 064003 3611 RETAINER FEE 4,137.58 *TOTAL VENDOR WILLIAM RAYSA 4,137.58 * **TOTAL LEGAL SERVICES 4,414.06 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 10 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000410 FIN & GEN SERVICES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 10550 AIM BUSINESS PRINTERS MISC 064185 3219 OFF SUPP 572.50 *TOTAL VENDOR AIM BUSINESS PRINTE 572.50 * 58181 AT&T 8889 JUN/J 064190 3211 TELEPHONE 23.32 *TOTAL VENDOR AT&T 23.32 * 114850 BUFFALO GROVE POSTMASTER 7/31/03 064125 3212 POSTAGE 2,400.00 *TOTAL VENDOR BUFFALO GROVE POSTM 2,400.00 155034 CORPORATE EXPRESS MULTIPLE 064199 3240 OFFICE SUPP 10.22 *TOTAL VENDOR CORPORATE EXPRESS 10.22 * 302443 GALLAGHER BENE ADMIN MULTIPLE 064027 3111 GRP MED & LIFE 202.50 MULTIPLE 064027 3111 GRP MED & LIFE 216.00 *TOTAL VENDOR GALLAGHER BENE ADMI 418.50 * 374510 HR SIMPLIFIED 13097 064145 3111 GRP MED & LIFE 25.00 *TOTAL VENDOR HR SIMPLIFIED 25.00 * 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 394.46- SEPT 2003 064210 3111 GRP MED & LIFE 9,490.47 *TOTAL VENDOR I.P.B.C. 9, 096.01 * 422950 I.P.M.A. 10037130 064146 3714 FIRE & POLICE COM 2,537.50 *TOTAL VENDOR I.P.M.A. 2,537.50 * 512962 LANER, MUCHIN, DOMBROW, 223417 064148 3618 SPECIAL COUNCIL 420.72 *TOTAL VENDOR LANER, MUCHIN, DOMB 420.72 * 545495 ART MALINOWSKI 8/13/03 064216 3137 EMP RECOG 500.00 *TOTAL VENDOR ART MALINOWSKI 500.00 * 598773 NEOPOST LEASING Date: 08/14/03 10:45 Village of Buffalo Grove Page: 11 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000410 FIN & GEN SERVICES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 3254540 064224 3216 MAINT CONTR 178.00 *TOTAL VENDOR NEOPOST LEASING 178.00 * 687708 PADDOCK PUB T3087464 064228 3224 RECRUIT CHGS 480.00 *TOTAL VENDOR PADDOCK PUB 480.00 * 772015 SBC 8151 JLY 0 064232 3211 TELEPHONE 19.90 *TOTAL VENDOR SBC 19.90 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 800.00 *TOTAL VENDOR VILLAGE OF BUFFALO 800.00 * 903220 VILLAGE OF BUFFALO GROVE 8/6/03 064183 4935 MISC EXP 17.00 8/6/03 064183 3212 MISC EXP 12.59 *TOTAL VENDOR VILLAGE OF BUFFALO 29.59 * 964520 XEROX CORPORATION 97128747 064236 3216 MAINT CONTR 91.34 *TOTAL VENDOR XEROX CORPORATION 91.34 * **TOTAL FIN & GEN SERVICES 15,202.60 2,400.00 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 12 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000421 FIRE SERVICES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 10408 AGA LINDE HEALTHCARE 9300428407 064015 3250 MISC SUPP 71.54 *TOTAL VENDOR AGA LINDE HEALTHCAR 71.54 10700 AIR ONE EQUIPMENT, INC. 33757 064186 3216 MAINT CONTR 572.17 34283 064131 4111 M&R DEPT EQUIP 407.00 33805 063962 4111 M&R DEPT EQUIP 198.00 *TOTAL VENDOR AIR ONE EQUIPMENT, 1,177.17 51035 ARCH WIRELESS M2277580H 064017 3217 EQUIP RENTAL 541.72 *TOTAL VENDOR ARCH WIRELESS 541.72 51210 ARLINGTON POWER EQUIP 207007 063963 4111 M&R DEPT EQUIP 529.25 *TOTAL VENDOR ARLINGTON POWER EQU 529.25 103512 BOUND TREE MEDICAL, LLC MULTIPLE 064240 3250 MISC SUPP/SMALL E 19.55 MULTIPLE 064240 3824 MISC SUPP/SMALL E 427.52 MULTIPLE 064240 3824 MISC SUPP/SMALL E 51.99 MULTIPLE 064240 4111 MISC SUPP/SMALL E 11.70 MULTIPLE 064240 3250 MISC SUPP/SMALL E 108.95 MULTIPLE 064240 3824 MISC SUPP/SMALL E 54.30 *TOTAL VENDOR BOUND TREE MEDICAL, 674.01 152889 CDW GOVERNMENT, INC JB46771 064140 3240 OFF SUPP 271.15 *TOTAL VENDOR CDW GOVERNMENT, INC 271.15 * 153460 CONNECTIONS UNLIMITED 71678 064197 3115 CLOTH ALLOW 213.80 *TOTAL VENDOR CONNECTIONS UNLIMIT 213.80 * 276200 F & F OFFICE SUPPLIES MULTIPLE 063978 3240 OFF SUPP/SUPP REC 62.82 *TOTAL VENDOR F & F OFFICE SUPPLI 62.82 * 284255 FIVE ALARM FIRE & SAF EQ 25092-00 063979 3117 EMP SAFETY EQUIP 409.62 25090-00 064202 3117 SAFETY EQUIP 165.35 *TOTAL VENDOR FIVE ALARM FIRE & S 574.97 * Date: 08/14/03 10:45 Village of Buffalo Grove Page: 13 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000421 FIRE SERVICES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 312802 GLOBAL FIRE EQUIP-MES MULTIPLE 063983 4316 OPER EQ DEPT 157.34 MULTIPLE 063983 4316 OPER EQ DEPT 2,370.23 *TOTAL VENDOR GLOBAL FIRE EQUIP-M 2,527.57 * 326000 GREAT LAKES FIRE & SAFETY 137808 063985 3115 CLOTH ALLOW 32.50 *TOTAL VENDOR GREAT LAKES FIRE & 32.50 * 419023 IMAGISTICS MULTIPLE 064243 3216 MAINT CONTR 91.28 *TOTAL VENDOR IMAGISTICS 91.28 * 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 73,153.15 SEPT 2003 064210 3111 GRP MED & LIFE 2,285.25- *TOTAL VENDOR I.P.B.C. 70,867.90 * 482300 KALE UNIFORMS, INC. MULTIPLE 063989 3115 CLOTH ALLOW 784.91 *TOTAL VENDOR KALE UNIFORMS, INC. 784.91 * 495700 KRAFT PAPER SALES CO MULTIPLE 063990 3250 MISC SUPP 1,086.93 *TOTAL VENDOR KRAFT PAPER SALES C 1,086.93 * 570111 MID AMERICA TRUCK & EQ CO MULTIPLE 063993 4218 AUTO PARTS/CONT A 1,350.00 MULTIPLE 064220 4218 CONT AUTO SERV 1,183.50 *TOTAL VENDOR MID AMERICA TRUCK & 2,533.50 * 612100 N W CENTRAL DISPATCH SYS 6602 064038 4914 MEMBERS ASSES 10,239.41 *TOTAL VENDOR N W CENTRAL DISPATC 10,239.41 * 687707 PADDOCK PUBLICATIONS 408484 OCT 064040 3218 SUB/PUB 36.00 *TOTAL VENDOR PADDOCK PUBLICATION 36.00 * 708500 PIONEER PRESS 138529 YR 064245 3218 SUB/PUB 19.95 *TOTAL VENDOR PIONEER PRESS 19.95 * Date: 08/14/03 10:45 Village of Buffalo Grove Page: 14 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000421 FIRE SERVICES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 755930 ROGAN'S SHOES MULTIPLE 064005 3115 CLOTH ALLOW 150.00 MULTIPLE 064005 3115 CLOTH ALLOW 150.00 *TOTAL VENDOR ROGAN'S SHOES 300.00 * 804650 SOUND INCORPORATED D1161964 064162 4111 M&R DEPT EQUIP 148.53 *TOTAL VENDOR SOUND INCORPORATED 148.53 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 5,280.00 *TOTAL VENDOR VILLAGE OF BUFFALO 5,280.00 * 988700 ZIMMERMAN HARDWARE MULTIPLE 064056 3250 11.69 MULTIPLE 064056 3824 2.06 MULTIPLE 064056 3240 7.18 MULTIPLE 064056 4923 42.74 MULTIPLE 064056 4111 21.84 MULTIPLE 064056 4111 13.52 MULTIPLE 064056 3824 113.91 MULTIPLE 064056 3916 42.51 MULTIPLE 064056 4935 8.09 *TOTAL VENDOR ZIMMERMAN HARDWARE 263.54 **TOTAL FIRE SERVICES 98,328.45 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 15 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000431 POLICE SERVICES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 82510 DANILLE BARON 7/31/03 063965 3115 CLOTH ALLOW 393.57 *TOTAL VENDOR DANILLE BARON 393.57 * 93597 BIKE PROS 1251 063969 3359 OPER EQ CPCR 31.95 *TOTAL VENDOR BIKE PROS 31.95 * 114740 BUFFALO GROVE 8/4/03 064124 4935 ALL OTHER INCOME 17.00 *TOTAL VENDOR BUFFALO GROVE 17.00 163110 CULLIGAN WATER-WHEELING MULTIPLE 063975 3345 MISC EXP 55.61 MULTIPLE 063975 3275 MISC EXP 55.61 MULTIPLE 063975 4337 MISC EXP 55.62 MULTIPLE 063975 3343 MISC EXP 166.84 *TOTAL VENDOR CULLIGAN WATER-WHEE 333.68 * 240500 ENTENMANN-ROVIN CO. 420153 064067 3115 CLOTH ALLOW 49.50 *TOTAL VENDOR ENTENMANN-ROVIN CO. 49.50 * 276200 F & F OFFICE SUPPLIES MULTIPLE 063978 3347 OFF SUPP/SUPP REC 110.98 *TOTAL VENDOR F & F OFFICE SUPPLI 110.98 * 302400 ANTHONY GALLAGHER 7/24/03 063980 3112 PRO TRNG 288.15 *TOTAL VENDOR ANTHONY GALLAGHER 288.15 * 302460 GALL'S INC. 5656815200 064069 3115 CLOTH ALLOW 94.98 565656770 063981 3115 CLOTH ALLOW 198.93 *TOTAL VENDOR GALL'S INC. 293.91 * 375251 IACP-POLICE CHIEF 8/13/03 064238 3112 PRO TRNG 30.00 *TOTAL VENDOR IACP-POLICE CHIEF 30.00 417570 I.C.P.A. YR 2004 063986 3113 MEMBERSHIP/DUES 40.00 YR 2004 063986 3113 MEMBERSHIP/DUES 40.00 *TOTAL VENDOR I.C.P.A. 80.00 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 16 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000431 POLICE SERVICES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 2,729.94- SEPT 2003 064210 3111 GRP MED & LIFE 80,444.13 *TOTAL VENDOR I.P.B.C. 77,714.19 482300 KALE UNIFORMS, INC. MULTIPLE 063989 3115 CLOTH ALLOW 88.82 MULTIPLE 063989 3115 CLOTH ALLOW 21.64- MULTIPLE 063989 3115 CLOTH ALLOW 52.90- MULTIPLE 063989 3115 CLOTH ALLOW 155.92 *TOTAL VENDOR KALE UNIFORMS, INC. 170.20 506000 KUSTOM SIGNALS, INC MULTIPLE 063991 4318 DUI ASS PURCH 71.20 MULTIPLE 063991 4318 DUI ASS PURCH 249.13 *TOTAL VENDOR KUSTOM SIGNALS, INC 320.33 605128 NEXTEL COMMUNICATIONS 251253222- 064037 3211 TELEPHONE 1,179.21 *TOTAL VENDOR NEXTEL COMMUNICATIO 1, 179.21 612100 N W CENTRAL DISPATCH SYS 6602 064038 4914 MEMBERS ASSES 23,778.78 *TOTAL VENDOR N W CENTRAL DISPATC 23,778.78 620500 RAY O'HERRON CO. , INC. 322659 064039 3336 SAFETY EQ PAT 914.25 MULTIPLE 063996 3115 CLOTH ALLOW/SAF E 29.41 MULTIPLE 063996 3336 CLOTH ALLOW/SAF E 69.68 *TOTAL VENDOR RAY O'HERRON CO. , I 1,013.34 * 654250 ORPHANS OF THE STORM MULTIPLE 063997 4918 ANIMAL CONTROL 60.00 *TOTAL VENDOR ORPHANS OF THE STOR 60.00 * 699905 PERFECT CIRCLE PAINTBALLS 1057 064226 3349 SUPP TRNG 360.00 *TOTAL VENDOR PERFECT CIRCLE PAIN 360.00 * 720090 QUALIFICATION TARGETS 20301126 064001 3357 OPER EQ TRNG 104.40 *TOTAL VENDOR QUALIFICATION TARGE 104.40 * Date: 08/14/03 10:45 Village of Buffalo Grove Page: 17 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000431 POLICE SERVICES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 804650 SOUND INCORPORATED D1162641 064082 3211 M&R DEPT EQ/COMP 121.00 *TOTAL VENDOR SOUND INCORPORATED 121.00 * 844750 JAMES TOMASO 8/13/03 064234 3112 PRO TRNG 250.00 *TOTAL VENDOR JAMES TOMASO 250.00 * 850005 TONETEK 4593 064009 3347 SUPP RECORDS 132.60 *TOTAL VENDOR TONETEK 132.60 * 888910 U.S. CAVALRY MULTIPLE 064011 3115 NIPAS/CLOTH ALLOW 69.88- MULTIPLE 064011 4949 NIPAS/CLOTH ALLOW 241.83 *TOTAL VENDOR U.S. CAVALRY 171.95 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 6,960.00 *TOTAL VENDOR VILLAGE OF BUFFALO 6,960.00 * 903220 VILLAGE OF BUFFALO GROVE 8/6/03 064183 4952 MISC EXP 13.65 8/6/03 064183 4954 MISC EXP 9.76 8/6/03 064183 4118 MISC EXP 3.18 8/6/03 064183 4118 MISC EXP .90 8/6/03 064183 3347 MISC EXP 7.57 *TOTAL VENDOR VILLAGE OF BUFFALO 35.06 * 949000 WOODFIELD BUS. PROD. INC 172181 064013 4935 ALL OTHER EXP 378.00 *TOTAL VENDOR WOODFIELD BUS. PROD 378.00 * **TOTAL POLICE SERVICES 114,330.80 47.00 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 18 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000441 BUILDING & ZONING VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 10550 AIM BUSINESS PRINTERS MISC 064185 3240 OFF SUPP 30.00 *TOTAL VENDOR AIM BUSINESS PRINTE 30.00 36552 AMERICAN BACKFLOW PREV AS 8/22/03 064122 3112 PRO TRNG 85.00 *TOTAL VENDOR AMERICAN BACKFLOW P 85.00 155034 CORPORATE EXPRESS MULTIPLE 063974 3240 OFF SUPP 33.22 *TOTAL VENDOR CORPORATE EXPRESS 33.22 * 417882 ILLINOIS FIRE INSP ASSOC 4016 063987 3112 PRO TRNG 50.00 *TOTAL VENDOR ILLINOIS FIRE INSP 50.00 * 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 11,431.80 SEPT 2003 064210 3111 GRP MED & LIFE 417.12- *TOTAL VENDOR I.P.B.C. 11, 014.68 * 687707 PADDOCK PUBLICATIONS 92530 OCT 064078 3218 SUB/PUB 26.88 *TOTAL VENDOR PADDOCK PUBLICATION 26.88 * 842000 THOMPSON ELEVATOR INSP. 03-2215 064166 4913 CONS FEES OTHER 38.00 03-2191 064085 4913 CONS FEES OTHER 304.00 *TOTAL VENDOR THOMPSON ELEVATOR I 342.00 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 800.00 *TOTAL VENDOR VILLAGE OF BUFFALO 800.00 * **TOTAL BUILDING & ZONING 12,296.78 85.00 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 19 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000445 ENGINEERING SERVICES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 147400 CLIFFORD-WALD CO. 22224 064062 3240 OFF SUPP 45.68 *TOTAL VENDOR CLIFFORD-WALD CO. 45.68 155034 CORPORATE EXPRESS MULTIPLE 064199 3240 OFFICE SUPP 4.85 *TOTAL VENDOR CORPORATE EXPRESS 4.85 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 5,770.28 SEPT 2003 064210 3111 GRP MED & LIFE 194.65- *TOTAL VENDOR I.P.B.C. 5,575.63 * 505750 RICHARD KUENKLER TRAVEL 8/2 064147 3112 PRO TRNG 500.00 *TOTAL VENDOR RICHARD KUENKLER 500.00 * 771155 SAVANNAH ENV. INC 21040 064231 4111 M&R DEPT EQUIP 901.38 *TOTAL VENDOR SAVANNAH ENV. INC 901.38 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 480.00 *TOTAL VENDOR VILLAGE OF BUFFALO 480.00 * 903220 VILLAGE OF BUFFALO GROVE 8/6/03 064183 3250 MISC EXP 30.25 8/6/03 064183 4111 MISC EXP 3.95 *TOTAL VENDOR VILLAGE OF BUFFALO 34.20 * **TOTAL ENGINEERING SERVICES 7,541.74 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 20 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000451 BUILDING SERVICES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 10550 AIM BUSINESS PRINTERS MISC 064185 3240 OFF SUPP 5.80 *TOTAL VENDOR AIM BUSINESS PRINTE 5.80 * 32250 ALDRIDGE ELECTRIC,INC. MULTIPLE 064187 3913 M&R STREET LITES 4,273.00 *TOTAL VENDOR ALDRIDGE ELECTRIC,I 4,273.00 * 50760 ARAMARK UNIFORM SERV. 57001 JLY 064189 3114 199.80 *TOTAL VENDOR ARAMARK UNIFORM SER 199.80 * 91700 G.W. BERKHEIMER CO,INC. 815937 064018 3250 MISC SUPP 192.42 *TOTAL VENDOR G.W. BERKHEIMER CO, 192.42 * 91730 BERLAND'S HOUSE OF TOOLS 64621 063967 3250 MISC SUPP 6.99 *TOTAL VENDOR BERLAND'S HOUSE OF 6.99 * 152700 COM ED 56003 JLY 064195 3825 ELEC FAC 3,980.76 71004 JLY 064063 3825 ELEC FAC 1,003.58 *TOTAL VENDOR COM ED 4,984.34 * 152750 COMMONWEALTH EDISON MULTIPLE 064194 3825 ELEC FAC 241.93 *TOTAL VENDOR COMMONWEALTH EDISON 241.93 * 155034 CORPORATE EXPRESS MULTIPLE 064199 3240 OFFICE SUPP 3.37 MULTIPLE 063974 3240 OFF SUPP 3.37 *TOTAL VENDOR CORPORATE EXPRESS 6.74 * 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 4,282.79 SEPT 2003 064210 3111 GRP MED & LIFE 148.71- *TOTAL VENDOR I.P.B.C. 4,134.08 * 562190 MC MASTER-CARR SUPPLY CO. 74508338 064034 3250 MISC SUPP 20.26 *TOTAL VENDOR MC MASTER-CARR SUPP 20.26 * Date: 08/14/03 10:45 Village of Buffalo Grove Page: 21 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000451 BUILDING SERVICES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 568287 METRO POWER INC 3376 064218 3216 MAINT CONTR 160.00 *TOTAL VENDOR METRO POWER INC 160.00 * 588910 MUNCH'S SUPPLY CO, INC MULTIPLE 063994 3916 MAINT BLDG & FAC 20.17 *TOTAL VENDOR MUNCH'S SUPPLY CO, 20.17 * 729350 QUILL CORPORATION 2841829 064002 3240 OFFICE SUPP 85.56 *TOTAL VENDOR QUILL CORPORATION 85.56 * 737421 RENTAL MAX L.L.C. 379059-03 064230 3217 EQUIP RENTAL 12.00 *TOTAL VENDOR RENTAL MAX L.L.C. 12.00 * 852308 TRANS-TEK IND SUPP 273322 064053 3916 MAINT BLDG & FAC 157.34 *TOTAL VENDOR TRANS-TEK IND SUPP 157.34 * 856400 THYSSENKRUPP ELEV. CORP. 353915 064008 3216 MAINT CONTR 600.00 *TOTAL VENDOR THYSSENKRUPP ELEV. 600.00 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 320.00 *TOTAL VENDOR VILLAGE OF BUFFALO 320.00 * 988700 ZIMMERMAN HARDWARE MULTIPLE 064237 3913 MISC EXP 41.07 MULTIPLE 064237 3916 MISC EXP 34.49 MULTIPLE 064237 3250 MISC EXP 83.48 *TOTAL VENDOR ZIMMERMAN HARDWARE 159.04 **TOTAL BUILDING SERVICES 15,579.47 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 22 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000461 STREET OPERATIONS VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 10550 AIM BUSINESS PRINTERS MISC 064185 3240 OFF SUPP 5.80 *TOTAL VENDOR AIM BUSINESS PRINTE 5.80 * 50760 AR.AMARK UNIFORM SERV. 57001 JLY 064189 3114 330.50 *TOTAL VENDOR ARAMARK UNIFORM SER 330.50 * 103500 BOTTS WELDING & TRUCK SRV 354537 063971 3250 MISC SUPP 73.20 *TOTAL VENDOR BOTTS WELDING & TRU 73.20 * 147200 ARTHUR CLESEN, INC. 174100 063973 3250 MISC SUPP 47.52 *TOTAL VENDOR ARTHUR CLESEN, INC. 47.52 * 155034 CORPORATE EXPRESS MULTIPLE 064199 3240 OFFICE SUPP 3.37 MULTIPLE 063974 3240 OFF SUPP 3.37 *TOTAL VENDOR CORPORATE EXPRESS 6.74 * 326655 GRIMCO, INC 1891331 064072 3822 TR & STREET SIGNS 106.15 *TOTAL VENDOR GRIMCO, INC 106.15 * 418830 IL EPA-FISC SERV SECT ILR400303 064073 4611 C/P BLDG IMP 1, 000.00 *TOTAL VENDOR IL EPA-FISC SERV SE 1, 000.00 * 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 334.09- SEPT 2003 064210 3111 GRP MED & LIFE 7,944.39 *TOTAL VENDOR I.P.B.C. 7,610.30 * 568030 MENARDS 30994 064217 3250 MISC SUPP 3.60 *TOTAL VENDOR MENARDS 3.60 * 589550 MUNICIPAL MARKING DIST. 28143 064076 3250 MISC SUPP/BG DAYS 12.00 *TOTAL VENDOR MUNICIPAL MARKING D 12.00 * 729350 QUILL CORPORATION Date: 08/14/03 10:45 Village of Buffalo Grove Page: 23 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000461 STREET OPERATIONS VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 2841829 064002 3240 OFFICE SUPP 85.56 *TOTAL VENDOR QUILL CORPORATION 85.56 * 772000 SAVIN CORPORATION 4648116 064006 3216 MAINT CONTR 331.20 *TOTAL VENDOR SAVIN CORPORATION 331.20 * 809400 STANDARD EQUIPMENT CO MULTIPLE 064047 3250 MISC SUPP 4.72 *TOTAL VENDOR STANDARD EQUIPMENT 4.72 * 841010 TAPCO 183834 064050 3822 TRAFFIC & ST SIGN 492.66 *TOTAL VENDOR TAPCO 492.66 * 842300 3M MULTIPLE 064051 3822 TRAFFIC & ST SIGN 3,137.16 *TOTAL VENDOR 3M 3,137.16 852162 TRAFFIC SAFETY BRACKETS 208 064010 3822 TR & ST SIGNS 157.50 *TOTAL VENDOR TRAFFIC SAFETY BRAC 157.50 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 720.00 *TOTAL VENDOR VILLAGE OF BUFFALO 720.00 * 906950 VULCAN MAT FIN CO 193496 064012 3912 M&R STS & HWYS 465.51 *TOTAL VENDOR VULCAN MAT FIN CO 465.51 988700 ZIMMERMAN HARDWARE 1577 JLY 0 064014 3250 MISC SUPP 40.30 *TOTAL VENDOR ZIMMERMAN HARDWARE 40.30 **TOTAL STREET OPERATIONS 14,630.42 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 24 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000462 PUB WRKS ADM VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 10550 AIM BUSINESS PRINTERS MISC 064185 3240 OFF SUPP 99.00 *TOTAL VENDOR AIM BUSINESS PRINTE 99.00 155034 CORPORATE EXPRESS MULTIPLE 064022 3240 OFF SUPP/M&R DEPT 64.66 MULTIPLE 064022 4111 OFF SUPP/M&R DEPT 197.79 *TOTAL VENDOR CORPORATE EXPRESS 262.45 204757 ELECTRICTIY FORUM, INC 9686811 063977 3218 SUB/PUB 29.50 *TOTAL VENDOR ELECTRICTIY FORUM, 29.50 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 191.16- SEPT 2003 064210 3111 GRP MED & LIFE 4,628.72 *TOTAL VENDOR I.P.B.C. 4,437.56 * 708500 PIONEER PRESS 146768 7/0 064079 3218 SUB/PUB 19.95 *TOTAL VENDOR PIONEER PRESS 19.95 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 400.00 *TOTAL VENDOR VILLAGE OF BUFFALO 400.00 * **TOTAL PUB WRKS ADM 5,248.46 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 25 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000463 FORESTRY VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 10550 AIM BUSINESS PRINTERS MISC 064185 3240 OFF SUPP 5.80 *TOTAL VENDOR AIM BUSINESS PRINTE 5.80 * 50760 ARAMARK UNIFORM SERV. 57001 JLY 064189 3114 449.20 *TOTAL VENDOR ARAMARK UNIFORM SER 449.20 * 51210 ARLINGTON POWER EQUIP 210472 064239 4215 LUBRICANTS 23.94 *TOTAL VENDOR ARLINGTON POWER EQU 23.94 * 147200 ARTHUR CLESEN, INC. 174769 064242 3250 MISC SUPP 9.47 *TOTAL VENDOR ARTHUR CLESEN, INC. 9.47 * 155034 CORPORATE EXPRESS MULTIPLE 063974 3240 OFF SUPP 3.37 MULTIPLE 064199 3240 OFFICE SUPP 3.37 *TOTAL VENDOR CORPORATE EXPRESS 6.74 * 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 302.30- SEPT 2003 064210 3111 GRP MED & LIFE 10,502.86 *TOTAL VENDOR I.P.B.C. 10,200.56 729350 QUILL CORPORATION 2841829 064002 3240 OFFICE SUPP 85.56 *TOTAL VENDOR QUILL CORPORATION 85.56 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 800.00 *TOTAL VENDOR VILLAGE OF BUFFALO 800.00 * 917055 WALL ENTERPRISES, INC G-0411-6 064055 3250 MISC SUPP 181.92 *TOTAL VENDOR WALL ENTERPRISES, I 181.92 * **TOTAL FORESTRY 11,763.19 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 26 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000465 CENTRAL GARAGE VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 50760 ARAMARK UNIFORM SERV. 57001 JLY 064189 3114 284.80 *TOTAL VENDOR AR.AMARK UNIFORM SER 284.80 * 51150 ARLINGTON HEIGHTS FORD 674 7/03 064058 4213 AUTO PARTS 34.97 674 7/03 064058 4213 AUTO PARTS 119.93 *TOTAL VENDOR ARLINGTON HEIGHTS F 154.90 * 51215 ARLINGTON TRANSMISSION 105 063964 4218 CONT AUTO SERV 1,335.40 *TOTAL VENDOR ARLINGTON TRANSMISS 1,335.40 * 103807 BP AMOCO 5931220015 063972 4211 GASOLINE 22.68 *TOTAL VENDOR BP AMOCO 22.68 * 204600 EL-COR INDUSTRIES, INC MULTIPLE 063976 4213 AUTO PARTS/MISC S 179.55 MULTIPLE 063976 4213 AUTO PARTS/MISC S 32.38 MULTIPLE 064026 4213 AUTO PARTS 37.21 MULTIPLE 063976 3250 AUTO PARTS/MISC S 183.25 MULTIPLE 064026 4213 AUTO PARTS 43.06 *TOTAL VENDOR EL-COR INDUSTRIES, 475.45 * 417740 IL LAWN EQUIPMENT INC. 568178 064029 4213 AUTO PARTS 56.07 *TOTAL VENDOR IL LAWN EQUIPMENT I 56.07 * 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 5,673.05 *TOTAL VENDOR I.P.B.C. 5,673.05 * 515900 LATTOF MOTOR SALES CO. 6704 JLY 0 063992 4218 CONT AUTO SERV 42.00 *TOTAL VENDOR LATTOF MOTOR SALES 42.00 * 570111 MID AMERICA TRUCK & EQ CO MULTIPLE 063993 4213 AUTO PARTS/CONT A 52.36 MULTIPLE 063993 4213 AUTO PARTS/CONT A 18.15 MULTIPLE 063993 4213 AUTO PARTS/CONT A 251.49 *TOTAL VENDOR MID AMERICA TRUCK & 322.00 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 27 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000465 CENTRAL GARAGE VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 596770 NAPA-HEIGHTS AUTOMOTIVE 790 JLY 03 063995 4213 AUTO PARTS 1,414.12 *TOTAL VENDOR NAPA-HEIGHTS AUTOMO 1,414.12 * 690672 PARTS PLUS OF PROS HTS 811270 JLY 063999 4213 AUTO PARTS 576.89 *TOTAL VENDOR PARTS PLUS OF PROS 576.89 * 712175 POMP'S TIRE SERV INC. 307384 064000 4213 AUTO PARTS 96.00 *TOTAL VENDOR POMP'S TIRE SERV IN 96.00 * 779901 SECY OF STATE 8/4/03 064128 4218 CONT AUTO SERV 312.00 *TOTAL VENDOR SECY OF STATE 312.00 822060 SWID SALES CORP. 17904 064007 4213 AUTO PARTS 122.50 *TOTAL VENDOR SWID SALES CORP. 122.50 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 400.00 *TOTAL VENDOR VILLAGE OF BUFFALO 400.00 * 988700 ZIMMERMAN HARDWARE MULTIPLE 064237 4213 MISC EXP 18.62 *TOTAL VENDOR ZIMMERMAN HARDWARE 18.62 * **TOTAL CENTRAL GARAGE 10,994.48 312.00 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 28 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000471 ESDA VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 139282 CINGULAR WIRELESS MULTIPLE 064192 3211 TELEPHONE 44.46 *TOTAL VENDOR CINGULAR WIRELESS 44.46 * 139282 CINGULAR WIRELESS MULTIPLE 064192 3211 TELEPHONE 15.56 *TOTAL VENDOR CINGULAR WIRELESS 15.56 * 163110 CULLIGAN WATER-WHEELING MULTIPLE 063975 4935 MISC EXP 62.09 *TOTAL VENDOR CULLIGAN WATER-WHEE 62.09 * 189140 BRUCE DIAMOND 9085 064200 4316 OPER EQ DEPT 130.95 *TOTAL VENDOR BRUCE DIAMOND 130.95 * 988700 ZIMMERMAN HARDWARE MULTIPLE 064237 4316 MISC EXP 22.99 *TOTAL VENDOR ZIMMERMAN HARDWARE 22.99 * **TOTAL ESDA 276.05 1 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 29 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000010 DEPT NO. 000481 TRANSFER NON-OPER VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 841147 TFW SURVEYING & MAPPING 15716 064083 4935 ALL OTHER EXP 766.00 *TOTAL VENDOR TFW SURVEYING & MAP 766.00 * 903030 VILLAGE OF BUFFALO GROVE FY 03-04 064182 4813 FND TRANS 36,079.38 *TOTAL VENDOR VILLAGE OF BUFFALO 36,079.38 903140 VILLAGE OF BUFFALO GROVE 8/1/03 064179 4823 PERS PROP REP TAX 8,403.56 *TOTAL VENDOR VILLAGE OF BUFFALO 8,403.56 * 903240 VILLAGE OF BUFFALO GROVE 8/1/03 064178 4822 PERS PROP REP TAX 7,610.62 *TOTAL VENDOR VILLAGE OF BUFFALO 7,610.62 * **TOTAL TRANSFER NON-OPER 52,859.56 ***TOTAL CORPORATE FUND 540,180.17 3, 010.40 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 30 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000014 DEPT NO. 000503 SPEC REVENUE-PARKING LOT VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 9210 ADVANCE ELECT SUPP CO S1369378-0 063961 3916 MAINT BLDG & FAC 46.53 *TOTAL VENDOR ADVANCE ELECT SUPP 46.53 * 325900 W.W. GRAINGER, INC. 140-701948 063984 3916 MAINT BLDG & FAC 17.16 *TOTAL VENDOR W.W. GRAINGER,INC. 17.16 * 687600 PACE/PARK & RIDE MAY-JLY 03 064244 4951 PARK LOT FEES 3,745.17 *TOTAL VENDOR PACE/PARK & RIDE 3,745.17 * 988700 ZIMMERMAN HARDWARE MULTIPLE 064237 3916 MISC EXP 20.23 *TOTAL VENDOR ZIMMERMAN HARDWARE 20.23 * **TOTAL SPEC REVENUE-PARKING LOT 3,829.09 ***TOTAL PARKING LOT FUND 3,829.09 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 31 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000021 DEPT NO. 000021 CAP PROD-FACILITIES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 103570 CHRISTY BOURBONNAIS COMP PURCH 063968 147 REC ALL OTHER 2,703.00 *TOTAL VENDOR CHRISTY BOURBONNAIS 2,703.00 **TOTAL CAP PROJ-FACILITIES 2,703.00 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 32 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000021 DEPT NO. 000511 CAP PROJ-FACILITIES VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 83450 BAXTER & WOODMAN, INC 79865 063966 4677 BUFFALO CREEK ERO 136.00 *TOTAL VENDOR BAXTER & WOODMAN, I 136.00 * 102770 THE BOELTER COMPANIES 90617200 064134 4670 AGC MAINT BLDG PL 3,482.00 *TOTAL VENDOR THE BOELTER COMPANI 3,482.00 696100 MARTIN PETERSEN CO. , INC S10407 064042 4655 PSC MEZ STOR 1,178.00 *TOTAL VENDOR MARTIN PETERSEN CO. 1,178.00 * 945056 SHELBY WILLIAMS 439964 064184 4670 AGC MAINT BLDG PL 1,720.00 *TOTAL VENDOR SHELBY WILLIAMS 1,720.00 * **TOTAL CAP PROD-FACILITIES 6,516.00 ***TOTAL CAP PROD-FACILITIES 9,219.00 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 33 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000022 DEPT NO. 000512 CAP PROJ-ST & HIGWYS VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 139900 CIVILTECH ENGINEERING CO. 30021 064241 4537 DFLD & 93 PKWY 526.73 *TOTAL VENDOR CIVILTECH ENGINEERI 526.73 * 903030 VILLAGE OF BUFFALO GROVE FY 03-04 064182 4540 FND TRANS 16,000.00 *TOTAL VENDOR VILLAGE OF BUFFALO 16,000.00 * **TOTAL CAP PROJ-ST & HIGWYS 16,526.73 ***TOTAL CAP PROD-STREETS 16,526.73 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 34 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000042 DEPT NO. 000532 PENSION-FIRE VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 654400 OTTOSEN, TREVARTHEN, 25661 064157 4935 ALL OTHER EXP 4,037.50 *TOTAL VENDOR OTTOSEN, TREVARTHEN 4,037.50 **TOTAL PENSION-FIRE 4, 037.50 ***TOTAL FIRE PENSION FUND 4,037.50 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 35 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000051 DEPT NO. 000051 WATER & SEWER FUND VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 903100 VILLAGE OF BUFFALO GROVE MULTIPLE 064181 120 FND TRANS/EMP CON 7,052.00 *TOTAL VENDOR VILLAGE OF BUFFALO 7,052.00 **TOTAL WATER & SEWER FUND 7,052.00 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 36 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000051 DEPT NO. 000251 WATER REVENUE VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 48400 LAWRENCE ANDRES 8/11/03 064123 1299 ALL OTHER INCOME 1,500.00 *TOTAL VENDOR LAWRENCE ANDRES 1,500.00 **TOTAL WATER REVENUE 1,500.00 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 37 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000051 DEPT NO. 000541 WATER OPERATIONS VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 10550 AIM BUSINESS PRINTERS MISC 064185 3240 OFF SUPP 5.80 *TOTAL VENDOR AIM BUSINESS PRINTE 5.80 * 50760 AR.AMARK UNIFORM SERV. 57001 JLY 064189 3114 308.70 *TOTAL VENDOR ARAMARK UNIFORM SER 308.70 * 115751 BUILT BEST FENCE CO. , INC 16716 064060 4412 C/P SYS IMP 5,980.00 *TOTAL VENDOR BUILT BEST FENCE CO 5, 980.00 * 155034 CORPORATE EXPRESS MULTIPLE 064199 3240 OFFICE SUPP 3.37 MULTIPLE 063974 3240 OFF SUPP 3.37 *TOTAL VENDOR CORPORATE EXPRESS 6.74 * 189715 DISCLOSURE VIDEO SYSTEMS SO WELL #1 064024 4412 C/P SYS IMP 9, 950.00 *TOTAL VENDOR DISCLOSURE VIDEO SY 9, 950.00 304000 GASVODA & ASSOC. INC. 3ICBT0015 063982 4412 C/P SYS IMP 2,260.00 *TOTAL VENDOR GASVODA & ASSOC. IN 2,260.00 * 304210 GATEWOOD CRANE SERV, INC 261800 064203 4412 SYSTEM IMPROVEMEN 350.00 *TOTAL VENDOR GATEWOOD CRANE SERV 350.00 * 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 8, 785.57 SEPT 2003 064210 3111 GRP MED & LIFE 236.29- *TOTAL VENDOR I.P.B.C. 8,549.28 * 433755 I W S, INC 73103-A 064211 4412 C/P SYS IMP 4,050.00 *TOTAL VENDOR I W S, INC 4,050.00 * 568287 METRO POWER INC 3376 064218 3216 MAINT CONTR 97.50 *TOTAL VENDOR METRO POWER INC 97.50 * 570131 MID AMERICAN WATER OF Date: 08/14/03 10:45 Village of Buffalo Grove Page: 38 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000051 DEPT NO. 000541 WATER OPERATIONS VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 32889W 064221 4014 M&R RESERVOIRS 138.00 *TOTAL VENDOR MID AMERICAN WATER 138.00 * 729350 QUILL CORPORATION 2841829 064002 3240 OFFICE SUPP 85.56 *TOTAL VENDOR QUILL CORPORATION 85.56 * 737455 REVERE ELEC SUPP CO 5083226-00 064004 4412 C/P SYS IMP 730.38 *TOTAL VENDOR REVERE ELEC SUPP CO 730.38 * 772015 SBC 9357 JLY 0 064045 4412 TELEPHONE 26.70 *TOTAL VENDOR SBC 26.70 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 640.00 MULTIPLE 064181 3125 FND TRANS/EMP CON 2,396.42 *TOTAL VENDOR VILLAGE OF BUFFALO 3,036.42 * 988700 ZIMMERMAN HARDWARE MULTIPLE 064237 4012 MISC EXP 12.76 *TOTAL VENDOR ZIMMERMAN HARDWARE 12.76 * **TOTAL WATER OPERATIONS 35, 587.84 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 39 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000051 DEPT NO. 000542 SEWER OPERATIONS VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 10550 AIM BUSINESS PRINTERS MISC 064185 3240 OFF SUPP 5.80 *TOTAL VENDOR AIM BUSINESS PRINTE 5.80 * 50760 ARAMARK UNIFORM SERV. 57001 JLY 064189 3114 151.80 *TOTAL VENDOR ARAMARK UNIFORM SER 151.80 * 152889 CDW GOVERNMENT, INC IZ43697 064196 4018 LIFT STATIONS 120.86 *TOTAL VENDOR CDW GOVERNMENT, INC 120.86 * 155034 CORPORATE EXPRESS MULTIPLE 064199 3240 OFFICE SUPP 3.37 MULTIPLE 063974 3240 OFF SUPP 3.37 *TOTAL VENDOR CORPORATE EXPRESS 6.74 * 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 1,351.81 SEPT 2003 064210 3111 GRP MED & LIFE 64.80- *TOTAL VENDOR I.P.B.C. 1,287.01 * 468230 JULIE, INC 7-3-181 064212 3217 EQUIP RENTAL 501.50 *TOTAL VENDOR JULIE, INC 501.50 * 512500 LAKE CO PUBLIC WORKS DEPT JLY/AUG 03 064213 3819 SEWER TREAT 141, 903.10 *TOTAL VENDOR LAKE CO PUBLIC WORK 141, 903.10 * 568287 METRO POWER INC 3376 064218 3216 MAINT CONTR 160.00 *TOTAL VENDOR METRO POWER INC 160.00 * 568300 MET WATER RECLAMATION 10815 064035 4935 ALL OTHER EXP 645.57 *TOTAL VENDOR MET WATER RECLAMATI 645.57 * 729350 QUILL CORPORATION 2841829 064002 3240 OFFICE SUPP 85.56 *TOTAL VENDOR QUILL CORPORATION 85.56 * 903100 VILLAGE OF BUFFALO GROVE Date: 08/14/03 10:45 Village of Buffalo Grove Page: 40 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000051 DEPT NO. 000542 SEWER OPERATIONS VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED MULTIPLE 064181 3125 FND TRANS/EMP CON 849.17 *TOTAL VENDOR VILLAGE OF BUFFALO 849.17 * 903100 VILLAGE OF BUFFALO GROVE FY 03/04 064246 3512 UNEMPLOY INS 240.00 *TOTAL VENDOR VILLAGE OF BUFFALO 240.00 * 988700 ZIMMERMAN HARDWARE MULTIPLE 064237 4018 MISC EXP 80.56 *TOTAL VENDOR ZIMMERMAN HARDWARE 80.56 * **TOTAL SEWER OPERATIONS 146, 037.67 ***TOTAL WATER & SEWER FUND 188,677.51 1,500.00 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 41 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000055 DEPT NO. 000546 GOLF OPERATION-BGGC VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 10550 AIM BUSINESS PRINTERS MISC 064185 3240 OFF SUPP 30.00 *TOTAL VENDOR AIM BUSINESS PRINTE 30.00 * 50000 AQUATIC WEED TECHNOLOGY 212441S 064016 3917 M&R GOLF COURSE 2, 805.00 *TOTAL VENDOR AQUATIC WEED TECHNO 2,805.00 * 114800 BUFFALO GROVE GOLF COURSE 8/8/03 064135 3219 MISC EXP 10.00 8/8/03 064135 3260 MISC EXP 43.39 8/8/03 064135 3212 MISC EXP 25.55 8/8/03 064135 3240 MISC EXP 31.94 *TOTAL VENDOR BUFFALO GROVE GOLF 110.88 * 124403 CART MART, INC. 126601 064136 3380 GOLF CART RENTAL 532.00 *TOTAL VENDOR CART MART, INC. 532.00 * 124406 CASTLEROCK SANITATION 8236 064019 3917 M&R GOLF COURSE 579.00 *TOTAL VENDOR CASTLEROCK SANITATI 579.00 * 138450 CHEMSEARCH 864393 064020 3260 SUPP GOLF COURSE 169.55 *TOTAL VENDOR CHEMSEARCH 169.55 * 147200 ARTHUR CLESEN, INC. MULTIPLE 064021 3823 CHEM/FERT 3,920.53 *TOTAL VENDOR ARTHUR CLESEN, INC. 3,920.53 * 155105 COUNTRY BUMPKIN 192436 064023 3917 M&R GOLF COURSE 221.00 *TOTAL VENDOR COUNTRY BUMPKIN 221.00 * 192670 DRUMMOND AMER CORP 1078464 064025 4111 M&R DEPT EQUIP 319.88 *TOTAL VENDOR DRUMMOND AMER CORP 319.88 * 276200 F & F OFFICE SUPPLIES 240696-0 064201 4935 ALL OTHER EXP 210.66 *TOTAL VENDOR F & F OFFICE SUPPLI 210.66 * Date: 08/14/03 10:45 Village of Buffalo Grove Page: 42 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000055 DEPT NO. 000546 GOLF OPERATION-BGGC VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 373301 BRUCE HOUDEK 8/6/03 064207 3270 OPER EQUIP 800.00 *TOTAL VENDOR BRUCE HOUDEK 800.00 417720 IL DEPT OF REVENUE JLY 03 064127 3395 STATE SALES TAX 746.15 *TOTAL VENDOR IL DEPT OF REVENUE 746.15 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 115.36- SEPT 2003 064210 3111 GRP MED & LIFE 3,135.66 *TOTAL VENDOR I.P.B.C. 3, 020.30 * 468270 J.W. TURF, INC 678692 064030 4111 M&R DEPT EQUIP 347.16 *TOTAL VENDOR J.W. TURF, INC 347.16 * 511045 LA JOLLA CLUB GOLF CO 122720 064215 3370 MERCH PURCH 342.93 *TOTAL VENDOR LA JOLLA CLUB GOLF 342.93 * 522900 LESCO INC. MULTIPLE 064031 3824 CHEM/SM TOOLS & E 351.48 MULTIPLE 064031 3824 CHEM/SM TOOLS & E 295.00 MULTIPLE 064031 3917 CHEM/SM TOOLS & E 559.90 MULTIPLE 064031 3823 CHEM/SM TOOLS & E 395.20 MULTIPLE 064031 3824 CHEM/SM TOOLS & E 163.30 MULTIPLE 064031 3823 CHEM/SM TOOLS & E 1, 722.50 MULTIPLE 064031 3823 CHEM/SM TOOLS & E 190.70 *TOTAL VENDOR LESCO INC. 3,678.08 * 523100 LEWIS EQUIPMENT CO P88917 064032 4111 M&R DEPT EQUIP 55.80 *TOTAL VENDOR LEWIS EQUIPMENT CO 55.80 * 568288 METRO PROF PROD INC MULTIPLE 064219 3260 SUPP GOLF COURSE 432.06 *TOTAL VENDOR METRO PROF PROD INC 432.06 * 570600 MIDWEST TIME RECORDER INC 85497 064152 3240 OFFICE SUPP 46.80 *TOTAL VENDOR MIDWEST TIME RECORD 46.80 * Date: 08/14/03 10:45 Village of Buffalo Grove Page: 43 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000055 DEPT NO. 000546 GOLF OPERATION-BGGC VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 596510 NADLER GOLF CART SALES MULTIPLE 064153 3380 GOLF CART RENTAL 9,388.05 *TOTAL VENDOR NADLER GOLF CART SA 9,388.05 596510 NADLER GOLF CART SALES MULTIPLE 064153 3380 GOLF CART RENTAL 24.85 *TOTAL VENDOR NADLER GOLF CART SA 24.85 * 598325 NATURAL JUICE COMPANY 250 JU/JL 064036 3260 SUPP GOLF COURSE 516.00 250 JU/JL 064036 3260 SUPP GOLF COURSE 80.00 *TOTAL VENDOR NATURAL JUICE COMPA 596.00 * 598600 NCS 858655 064155 3240 OFF SUPP 26.25 *TOTAL VENDOR NCS 26.25 * 687800 PALATINE OIL CO. , INC 4175 MAY/J 064041 4211 GASOLINE 2,203.02 *TOTAL VENDOR PALATINE OIL CO. , I 2,203.02 * 700550 PHOENIX IRR. SUPP. INC. 22591 064043 3919 IRRIGATION SYSTEM 146.40 *TOTAL VENDOR PHOENIX IRR. SUPP. 146.40 * 736000 R.C. TOPSOIL MULTIPLE 064044 3917 M&R GOLF COURSE 333 .60 *TOTAL VENDOR R.C. TOPSOIL 333.60 * 795473 SIMPLOT PARTNERS 320419SI 064046 3823 CHEM/FERT 1,912.50 *TOTAL VENDOR SIMPLOT PARTNERS 1,912.50 * 804650 SOUND INCORPORATED D1162641 064082 4111 M&R DEPT EQ/COMP 121.00 *TOTAL VENDOR SOUND INCORPORATED 121.00 * 822060 SWID SALES CORP. 17863 064049 4111 M&R DEPT EQUIP 34.96 *TOTAL VENDOR SWID SALES CORP. 34.96 * 822150 SWISHER MULTIPLE 064165 3916 MAINT BLDG & FAC 98.00 *TOTAL VENDOR SWISHER 98.00 * Date: 08/14/03 10:45 Village of Buffalo Grove Page: 44 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000055 DEPT NO. 000546 GOLF OPERATION-BGGC VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 851157 TOWN & COUNTRY LANDSCAPE 29761 064052 3917 M&R GOLF COURSE 1,267.50 *TOTAL VENDOR TOWN & COUNTRY LAND 1,267.50 * 903100 VILLAGE OF BUFFALO GROVE MULTIPLE 064181 3125 FND TRANS/EMP CON 3,270.12 FY 03/04 064246 3512 UNEMPLOY INS 800.00 *TOTAL VENDOR VILLAGE OF BUFFALO 4, 070.12 * 988700 ZIMMERMAN HARDWARE MULTIPLE 064056 3824 88.40 *TOTAL VENDOR ZIMMERMAN HARDWARE 88.40 * **TOTAL GOLF OPERATION-BGGC 37, 932.28 746.15 ***TOTAL BUFFALO GROVE GOLF CLUB 37,932.28 746.15 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 45 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000056 DEPT NO. 000547 GARAGE OPERATIONS VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 99998 MARC COHEN 8/8/03 064139 1227 LOCKER FEES 37.50 *TOTAL VENDOR -> ONE-TIME VENDORS 37.50 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 150.68- *TOTAL VENDOR I.P.B.C. 150.68-* **TOTAL GARAGE OPERATIONS 113.18- ***TOTAL CENTRAL GARAGE FUND 113.18- Date: 08/14/03 10:45 Village of Buffalo Grove Page: 46 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000057 DEPT NO. 000257 GOLF-AGC REVENUE VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 99998 MIKE SCHWARTZ 8/8/03-ARB 064161 1225 SEASON PAS 1,375.00 *TOTAL VENDOR -> ONE-TIME VENDORS 1,375.00 **TOTAL GOLF-AGC REVENUE 1,375.00 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 47 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000057 DEPT NO. 000548 GOLF OPERATIONS-AGC VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 5805 ACE HDWRE MULTIPLE 064129 3824 SMALL EQUIP/M&R D 319.98 *TOTAL VENDOR ACE HDWRE 319.98 * 5805 ACE HDWRE MULTIPLE 064129 4111 SMALL EQUIP/M&R D 21.99 *TOTAL VENDOR ACE HDWRE 21.99 * 9450 AEREX PEST CONTROL SERVCS 597401 064130 3916 MAINT CONTR 55.00 *TOTAL VENDOR AEREX PEST CONTROL 55.00 * 50760 ARAMARK UNIFORM SERV. MULTIPLE 064132 3114 UNIF RENTAL 191.34 57001 JLY 064189 3114 41.32- *TOTAL VENDOR ARAMARK UNIFORM SER 150.02 * 99850 BLUE BOY PORTABLE TOILETS 27931 064133 3260 SUPP GOLF COURSE 187.00 *TOTAL VENDOR BLUE BOY PORTABLE T 187.00 * 139080 CHICAGOLAND PAVING 3063 064137 3917 M&R GOLF COURSE 1, 500.00 *TOTAL VENDOR CHICAGOLAND PAVING 1, 500.00 * 147200 ARTHUR CLESEN, INC. MULTIPLE 064138 3823 CHEM/FERT-SM EQUI 185.88 MULTIPLE 064138 3824 CHEM/FERT-SM EQUI 59.81 *TOTAL VENDOR ARTHUR CLESEN, INC. 245.69 * 152495 COMCAST AD SALES 132540 064193 3391 AD/PROMO 1,382.50 *TOTAL VENDOR COMCAST AD SALES 1,382.50 * 152750 COMMONWEALTH EDISON MULTIPLE 064194 3811 ELEC FAC 6,086.39 MULTIPLE 064194 3811 ELEC FAC 1.39 *TOTAL VENDOR COMMONWEALTH EDISON 6,087.78 * 153600 CONSERV FARM SUPPLY 188316 064198 3823 CHEM/FERT 633.80 *TOTAL VENDOR CONSERV FARM SUPPLY 633.80 * Date: 08/14/03 10:45 Village of Buffalo Grove Page: 48 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000057 DEPT NO. 000548 GOLF OPERATIONS-AGC VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 155105 COUNTRY BUMPKIN GW-191372 064141 4613 C/P GOLF COURSE 44.00 *TOTAL VENDOR COUNTRY BUMPKIN 44.00 * 192670 DRUMMOND AMER CORP 1072834 064142 4111 M&R DEPT EQUIP 135.83 *TOTAL VENDOR DRUMMOND AMER CORP 135.83 * 307010 GEMPLER'S, INC P092636700 064143 3260 SUPP GOLF COURSE 72.92 *TOTAL VENDOR GEMPLER'S, INC 72.92 * 321060 GOTTA HAVE IT GOLF 3210 064204 4611 C/P BLDG IMP 1,049.27 *TOTAL VENDOR GOTTA HAVE IT GOLF 1,049.27 * 355100 HELLER LUMBER MULTIPLE 064144 4613 C/P GOLF COURSE 403.90 *TOTAL VENDOR HELLER LUMBER 403.90 * 361915 H & H PRESS, INC. 4294 064205 3219 PRINTING 572.00 *TOTAL VENDOR H & H PRESS, INC. 572.00 * 373000 HORNUNGS PRO GOLF SALES 539660 064206 3260 SUPP GOLF COURSE 724.10 *TOTAL VENDOR HORNUNGS PRO GOLF S 724.10 * 417720 IL DEPT OF REVENUE JLY 03 064127 3395 STATE SALES TAX 425.85 *TOTAL VENDOR IL DEPT OF REVENUE 425.85 417740 IL LAWN EQUIPMENT INC. 568003 064208 4111 M&R DEPT EQUIP 49.21 *TOTAL VENDOR IL LAWN EQUIPMENT I 49.21 * 422525 INTRINSIC PER GARDENS 11826 064209 4613 C/P GOLF COURSE 328.50 *TOTAL VENDOR INTRINSIC PER GARDE 328.50 * 422850 I.P.B.C. SEPT 2003 064210 3111 GRP MED & LIFE 5,152.65 SEPT 2003 064210 3111 GRP MED & LIFE 97.57- *TOTAL VENDOR I.P.B.C. 5,055.08 * Date: 08/14/03 10:45 Village of Buffalo Grove Page: 49 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000057 DEPT NO. 000548 GOLF OPERATIONS-AGC VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 522900 LESCO INC. MULTIPLE 064149 3260 SUPP GOLF COURSE 179.65 MULTIPLE 064149 3260 SUPP GOLF COURSE 37.90 *TOTAL VENDOR LESCO INC. 217.55 568032 MENARD'S MULTIPLE 064150 4613 SM EQ/SUPP GC/SUP 81.47 MULTIPLE 064150 3824 SM EQ/SUPP GC/SUP 106.05 MULTIPLE 064150 3260 SM EQ/SUPP GC/SUP 27.28 *TOTAL VENDOR MENARD'S 214.80 568288 METRO PROF PROD INC MULTIPLE 064151 3260 SUPP GOLF COURSE 434.68 *TOTAL VENDOR METRO PROF PROD INC 434.68 573650 MINOLTA BUS SOLUTIONS 3720930030 064222 4111 M&R DEPT EQUIP 402.74 *TOTAL VENDOR MINOLTA BUS SOLUTIO 402.74 596510 NADLER GOLF CART SALES MULTIPLE 064153 3380 GOLF CART RENTAL 10, 025.10 MULTIPLE 064153 3380 GOLF CART RENTAL 295.00 *TOTAL VENDOR NADLER GOLF CART SA 10,320.10 598325 NATURAL JUICE COMPANY 77 JUN/JLY 064154 3260 SUPP GOLF COURSE 150.00 77 JUN/JLY 064154 3260 SUPP GOLF COURSE 137.00 *TOTAL VENDOR NATURAL JUICE COMPA 287.00 605135 NIELSEN ASSOCIATES, INC MULTIPLE 064225 3391 AD/PROMO 5,557.99 *TOTAL VENDOR NIELSEN ASSOCIATES, 5,557.99 * 620392 OFFICE MAX CEDIT PLAN 5942J175 064156 3260 SUPP GOLF COURSE 18.97 *TOTAL VENDOR OFFICE MAX CEDIT PL 18.97 * 687800 PALATINE OIL CO. , INC 383 JUN/JL 064227 4211 GASOLINE 1,330.20 *TOTAL VENDOR PALATINE OIL CO. , I 1,330.20 * 736000 R.C. TOPSOIL Date: 08/14/03 10:45 Village of Buffalo Grove Page: 50 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000057 DEPT NO. 000548 GOLF OPERATIONS-AGC VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED MULTIPLE 064158 4613 C/P GOLF COURSE 549.45 *TOTAL VENDOR R.C. TOPSOIL 549.45 * 736930 RICK REED 8/8/03 064159 4613 DUES-C/P GOLF COU 125.00 8/8/03 064159 3113 DUES-C/P GOLF COU 100.00 *TOTAL VENDOR RICK REED 225.00 * 772015 SBC 9112 MAY 0 064160 3211 TELE 312.72 *TOTAL VENDOR SBC 312.72 * 804650 SOUND INCORPORATED D1162939 064233 4111 M&R DEPT EQUIP 271.24 *TOTAL VENDOR SOUND INCORPORATED 271.24 * 820710 SUBURBAN TRIM & GLASS 123669 064163 3260 SUPP GOLF COURSE 89.42 *TOTAL VENDOR SUBURBAN TRIM & GLA 89.42 * 822060 SWID SALES CORP. 17884 064164 4111 M&R DEPT EQUIP 53.60 *TOTAL VENDOR SWID SALES CORP. 53.60 * 881408 UPLINK CORP. ARB1005 064167 3392 GPS EXPENSE 11,692.41 *TOTAL VENDOR UPLINK CORP. 11,692.41 * 903100 VILLAGE OF BUFFALO GROVE MULTIPLE 064181 3125 FND TRANS/EMP CON 3,096.33 FY 03/04 064246 3512 UNEMPLOY INS 800.00 *TOTAL VENDOR VILLAGE OF BUFFALO 3,896.33 * 988700 ZIMMERMAN HARDWARE MULTIPLE 064056 3260 48.87 *TOTAL VENDOR ZIMMERMAN HARDWARE 48.87 * **TOTAL GOLF OPERATIONS-AGC 54, 941.64 425.85 ***TOTAL ARBORETUM GOLF CLUB FUND 56,316.64 425.85 Date: 08/14/03 10:45 Village of Buffalo Grove Page: 51 User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 FUND NO. 000058 DEPT NO. 000058 MIS OPERATIONS FUND VENDOR# VENDOR NAME INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 546300 MARK ONE COMPUTERS 137754 064033 223 RES CAP REP 8,874.02 *TOTAL VENDOR MARK ONE COMPUTERS 8,874.02 **TOTAL MIS OPERATIONS FUND 8,874.02 ***TOTAL MIS OPERATIONS FUND 8,874.02 t D Date: 08/14/03 10:45 Village of Buffalo Grove Page: 52 U User: huntsa EXPENDITURE APPROVALS LIST Warrant Date 08/18/03 I FUND NO. 000059 l DEPT NO. 000550 REFUSE SERVICE OPERATIONS VENDOR# VENDOR NAME I] INVOICE# VOUCHER ACCT# TSK OPT C-CTR ITEM DESCRIPTION EXP AMOUNT HAND-ISSUED 821400 SWANCC TRUST #35883008 1279 064048 4922 USER FEES 72,467.39 *TOTAL VENDOR SWANCC TRUST #35883 72,467.39 **TOTAL REFUSE SERVICE OPERATIONS 72,467.39 ***TOTAL REFUSE SERVICE FUND 72,467.39 Board Agenda Item Submittal VI-A Requested By: Phillip W Versten Entered By: Phillip W Versten Agenda Item Title: Resolution No.2003-37, Commending Marla Chorney for her Years of Service to Buffalo Grove as a Member of the Commission for Residents with Disabilities Date Submitted: Meeting Date Agenda Place Requested: Requested: Department: 08/13/2003 08/18/2003 0 Consent Agenda OVM Regular Agenda 0 None Does this item Does this item include Will AV equipment be relate to another additional reference required to present item on the info separate from the this item to the agenda? Board packet? board? 0 Yes 0No 0 Yes 0No 0 Yes 0No Item Description Will this action involve an expenditure in 0 Yes 0 NO funds? Additional Notes regarding Expenditures: Type the body of the cover memo here. Requests cannot be submitted if this field is blank. The attached resolution expresses appreciation for Marla Chorney's commitment to the Buffalo Grove Commission for Residents with Disabilities, and to the community since 1992 when the commission was formed. During her tenure, the respite program was formed, transportation issues for persons with disabilities came to the fore, ordinances concerning housing and parking were created to help people with disabilities, as well as many other accomplishments. Marla's dedication, work motivation, and concern for all people benefited the Village of Buffalo Grove. Letter-Sized Legal-Sized Ledger-Sized Odd-Sized Attached Files Attached Files Attached Files Attached Files 73 Resolution for Marla Chorney. Approval Section: Name: Date and Time: Submitted By: Pre-Approved By: Approved By: Published to Web: RESOLUTION NO.2003-37 A RESOLUTION COMMENDING MARLA CHORNEY FOR HER YEARS OF SERVICE TO BUFFALO GROVE AS A MEMBER OF THE COMMISSION FOR RESIDENTS WITH DISABILITIES WHEREAS, Marla Chorney has served on the Commission for Residents with Disabilities since its inception in 1992, and WHEREAS, during that time, Marla has contributed to the betterment of the community by serving in an advisory capacity to the Board of Trustees on matters concerning disabilities, and WHEREAS, during that time, Marla has also monitored and addressed specific concerns of persons with disabilities in Buffalo Grove, and their caregivers, and WHEREAS, during that time, Marla contributed to the creation of a Buffalo Grove respite program that enables caregivers in Buffalo Grove to get assistance in the sometimes difficult task of caring daily for a loved one with disabilities, and WHEREAS, the respite program became a successful suburban-wide initiative, and WHEREAS, the many other accomplishments to which Marla contributed include: an award from the National Organization on Disabilities recognizing the efforts of the Commission, the creation of ordinances addressing housing needs and parking needs, discussions concerning transportation needs, and the establishment of programs designed to improve the experience ofpersons with disabilities in community events, and WHEREAS, Marla Chorney's motivation and concern for disabilities issues in Buffalo Grove and her commitment to the Buffalo Grove Commission for Residents with Disabilities made her a tremendous asset that will be missed as she now leaves Buffalo Grove NOW,THEREFORE,BE IT RESOLVED BY THE PRESIDENT AND BOARD OF TRUSTEES OF THE VILLAGE OF BUFFALO GROVE,ILLINOIS as follows: 1. That Marla Chorney be commended on behalf of the citizens of Buffalo Grove for her exemplary and distinguished service to the Village. 2. That this resolution be presented to Marla Chorney with gratitude and best wishes for her future endeavors. AYES: NAYS: ABSENT: PASSED: 2003 APPROVED: 2003 ATTEST: APPROVED: Village Clerk ELLIOTT HARTSTEIN,Village President A PROCLAMATION DEDICATING AUGUST 25-29, 2003 AS "SCHOOL'S OPEN SAFETY WEEK" IN BUFFALO GROVE WHEREAS, the Village of Buffalo Grove seeks to make the return to school as safe as possible each year for our students, and WHEREAS, the 2003-04 school session will soon be underway, and WHEREAS, the Village wishes to encourage parents to spend some time with their children discussing safety, especially the following safety tips regarding the crossing of streets: • Stop and look in all directions. Make sure the road is clear of traffic. • Cross streets at corner cross walks. Do not cross from between cars. • Cross on the proper signal. • Watch for turning cars. • Be visible at night. • Be extra alert in bad weather when visibility is low and roads are slippery, and WHEREAS, the Village recognizes that the promotion of safe motoring practices will aid in the prevention of tragedies, such as paying attention to crossing guards, and reviewing driver's rules that apply specifically to school zones, and WHEREAS, the Village wishes to promote all of these safety reminders by establishing a week long reminder of the need for safety upon the beginning of the new school year, NOW, THEREFORE, I, Elliott Hartstein, President of the Village of Buffalo Grove, do hereby proclaim the week of August 25 through August 29 as "School's Open - Safety Week"in Buffalo Grove. Proclaimed this 18'h day of August, 2003 Board Agenda Item Submittal VI-C Requested By: Ghida Neukirch Entered By: Ghida Neukirch Agenda Item Title: ESDA Commission Appointment-Robert Giddens,Village of Buffalo Grove Date Submitted: Meeting Date Agenda Place Requested: Requested: Department: 08/08/2003 08/18/2003 0 Consent Agenda OVM 0 Regular Agenda 0 None Does this item Does this item include Will AV equipment be relate to another additional reference required to present item on the info separate from the this item to the agenda? Board packet? board? 0 Yes 0No 0 Yes 0No 0 Yes 0No Item Description Will this action involve an expenditure in 0 Yes 0 NO funds? Additional Notes regarding Expenditures: Type the body of the cover memo here. Requests cannot be submitted if this field is blank. It is recommended that Robert Giddens,Village of Buffalo Grove IT Director,be appointed to the ESDA (Emergency Services Disaster Agency) Commission. The Commission currently consists of 10 individuals: 1) Paul Soucy, Chair 2) David Morton,Member 3) Paul Zucker, Member 4) Bill Balling, Office of the Village Manager 5) Greg Boysen,Public Works 6) Bill Brimm,Finance and General Services 7) Dick Kuenkler, Engineering 8) Dan Pearson, Fire Department 9) Ray Rigsby,Public Works 10) Ed Schar,Building &Zoning Rob is currently involved with the ESDA Committee and would add great value to the Commission by addressing computer and data technological issues, and also assisting with general administrative duties such as the Emergency Preparedness Plan, ESDA accreditation,the annual report, and other on-going activities. Rob has been employed with the Village of Buffalo Grove since February, 1995;he is also a resident of the community. The Commission meets on a quarterly basis. Approval is recommended. Letter-Sized Legal-Sized Ledger-Sized Odd-Sized Attached Files Attached Files Attached Files Attached Files Approval Section: Name: Date and Time: Submitted By: Pre-Approved By: Approved By: Published to Web: VILI AGE OF BUFFALO GROVE Fifty Raupp Blvd. MANAGEMENT REPORT Buffalo Grove,IL 60089-2100 Fax 847-459-7906 #259 William R.Balling First Quarter July, 2003 Village Manager 847-459-2525 1. Cash& Investment Portfolio - July, 2003 2. Real Estate Transfer Tax Activity—July, 2003 3. Sales Tax Collections—July, 2003 4. Golf Course Operating Statistics—July, 2003 5. Report on Marketing Activities, Arboretum Club—June & July, 2003 6. Corporate Fund Revenue & Expense Analysis—July, 2003 7. Water Fund Revenue& Expense Analysis—July, 2003 8. Income Tax Proceeds—July, 2003 9. Public Safety Report A. E.S.D.A. Monthly Activities -July, 2003 B. Fire Department Activities—July, 2003 C. Police Department Activities—July, 2003 10. Public Works Monthly Activity—July, 2003 A. Monthly Pumpage Report B. Central Garage Fleet Cost Detail 11. Community Development Report A. Compilation of Permit Activity—July, 2003 B. Certificates of Occupancy—July, 2003 C. Public Safety Activity Report—July, 2003 D. Public Utilities Construction Report—July, 2003 WILLIAM R. BALLING Village Manager CM C - x(p N oo O * W o0 A O N ^ I N M W a p p� w l+nft4i � lgg� O � O � W OaNi, v AGO O pj N M < aD N O LLLLII F C � 888888888 8 $ 88 b OD ��p iD N �Ap Epp N fD N �oN pm� ipD m W N t'7 H !V O n N N O N n W h n N O n W OD O rz W N tp8 A8N $ $8 $ $8A � : $ $S8$ $S$ $$ $S$ $$ $8$$$ $8$ $$ $S$ $$ $8$ $$8 $p O1 N 8,MLU O O O N N O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 p p 0 0 0 0 0 �� a8 8 � Ng99999 � ;i8C $89a12 !9Aus a of W 1n $ � � `e� °�i. h � _ � NtlN 888101a�, f .g, 8S38 $ 8 `�3 � OOU NOYfO � MNN � � �D WWI 0 ��p � Iqaq � aM � m � �aafo N h aq It 1p p o �p �p ♦ 1� 1� n N ai N CD ^ O G N g O Hf Nf r M lN7 W N W N O V Ol m i4',Ft4x N N n b ED N Ol N W /V p p p p p p p p p p p p p p p p p p p p p 8N 88s39 : 8888888888 $ 88888888888 < _ � W opompp ppt� oy� oo p ® ooppp 1p`' W N N Q W �- e- > _ 84 $ 88 � � � 8 $ 8888g8888888 $ 8888888 C11 W V ♦ < b b S N n f0 M O O 10 Y N V �tYtbff O � N V N O O IL yy aR aR �apR aR a�pR aooR �R aaR ayN�� ta�ppR aR aR amR apR apR �R yb� aR aR �R aR 7b� ayR� ZR tpR o� � F A � ONBWI+f Nl9 W BOSONOhBI+IOO �O 81[f Rf O - W W 0 0 0 �-' N fV N M M lV M M M a N N pl Ml N lh N M M M M N J W U } aBM $ 8 Z Z Z Z qq. aa WWW 000 �: 00 000 .- o o � 000S � o � oo � o .- 000 � O M J Q Z W Z a � g M 4 YFWW- LLYIL ? > O c6 (q 2 Y - U W ~ � � owl� OOZ y F w y H p < O Q WSy �1�,1 WpN ty?ll� W {4�l < q yy0.,O Y '' 10�: F m U F < W Z �W W 8 1 �Z1�uOO -Jm �m7LL � :5W � " Cj 0 O-° � fp a U ~ Z ZLU = m IQ— N P Z U U U Z Z Z tI J p < ~ Z < y�y11�LL �O� S WWI} � � dy < > ao 1�q�7 y —'� � 1� .L' V1� F- � I- .� Ga�a } F- iil <a< g7S[� Z<`> <Z<OW $ LL OU - JaU� � � < mZUJMYU � mY � maILU W LL � �N U N 800 8 � OtD P N O tV lV 0 6 0 •' a 80 O l cm 01 0 0/ N O H (7j l+f M S 0 0 0 0 § § g 8 v g ai ei vi ei 1C4 �S Cp m H N cm N �pOp Op N a R 10 �d � Cp Y N 88H888888888888 $ 88 $ 8 � �i, � O O "�, N H $ $ $ $ HH $ 88H8H b � H W HO � NbHYf8HH8H � �� MH � � a HHR/ NfaHO � Y1NH $ HN r N 8 8 8g853 �388888g8888 $ �3 � s o8N 8884889988888 p� sh�yy Nci1:paa M(� ID H O Ol O N N 1D N N 0 0 0 m O CV f M Ol l+ H O l0 CD O s e H N H s O S .- N 888888888888888888888 $$ 8888888888888888 O OOOOOO Op Oo pO Op pO OOOOOD �OO �fI I OO pOpO pO OOO pO OO OppOO b HCD 8888888888 `8'. 88088888888888888 888. 88888888 `8! 8888 80 80 58 88 88 80 88 58 88 88 0 0 0 0 0 �0p 0 p0 p0 0 p0 0 0 0 0p 0 ® off O to 0 0 p0 0 0 00 0 p0 0 0 0o V O 11 W HOIH < � 1O � H1fl8HH (OH C^D96 I I I I I I I $ H �iCNDHtD � 1pN H n Hii to l7 N M M N N CV l7 M Y h Y N m — •' O O O b tV N M M M M /V 1(1 l7 lH N QN g CL as aaa nr7r a a o o o o ? O O 00 O O F O O Z O Z w aw aw o a � r-W � LU> w h w ww a ww YgZZyILy mKZ �U'�NgF YgmwJ�mCUrr� YZ�S mZ�g��io�YYZm� mdWaLL' YZoa Qt�`ZD�6Ya�o �YYwg �Ywg �YwgmYJg Uy�jJ JQ XQ[j4 NJ JQ �U o NZ �4f~ - ( ��Xm O'�Ja�-�� Z Now a Q Zz �OO. o w m ZZ 2 Kz< Z < < Utu m Z m2 Y LL < LL< W� p Z Z IOZ < Y 7 > LM 8 a g Q N QZ ggq OSYNKw Y U. YZy << ~ N Z myp w O mQp a � � 3o OfAO No a > y NW Q F FU OQmO J 66 A VU WKC� � m � LLa � R * * r *In � � pO p�� Ol t�I O Np Ol N {7 N O (09 Pl l+1 N N N N N N O w m $ fp m CQ^D O A rCOD v? f� N N O m N 0, f N O 1 1 9 O O n W CD O N N Z P1 N 8 O O O O O O O O S g g $ $ $ O O O $ N (n � NN NN W InNN W 8 OpN 01 � � �Cpp �CpD � $ m N P Y N N CD C09 r O r N pCY� C�pp pppp O �N � N p 0� mppCND �9Op �O $N �3O �� . 0 . ci MUM kh 0 C8p8ppop $ p N1 ON C94 C8N V CM pp pp 1� p p p C.p- a CPS pN� (p Cp tp p p p 1� p 'a" OY� f(O�p O N tD N O O Cr pp (n0, ems- n $ CD CCQpD1 (O� CD ((Opp (O Y� 1n N CC?p (. �qOp. O O C/hp (pO� f. O 1� (O F p�p N co i Ip Y� I I N f� If1 N e' W N m C�y M P CD 10 � CD V 1 f O CND. N O r OD $ �NO� IA O A N pP� T N Cpp N O Cad CND O N R V N N N N N N 8 V V V V O V S O O 1ff C-4 N000l+1 N b10 $ NO V $ $ N 1 1 1 ' ( I I I I ( NNNNN 0D - � 0N CC04 co N 10 b $ N m g $ O N I I I I I I I I I N 8 N N � 2 - 28 32 w � m to C7 N N CO N Y CV Q O O O O O O O O o o 0 0 0 o Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z ww ww ww ww wwwwwwwwwwwwwww 0. a. as as as amaaaaaao. an. aaan. 0 00 00 00 00 0000000O0000000 w a � a � w w 0 � a o 0 K y ZF a wa. z W V~,; Q w co a w fn u~i w (OJ 00w ca > W Z H Z ca j Z W a y W a rn0no °z z c z W W °z W nza za z J ~ W w � OQ a m a m a w Ya Y > > � � Qmm � ►- � to rn rn m mx mm pa U.7. LL Dam 4a $ �[ tm9 U 0 0 a W �WWWW < g W < w wUQ ? < W Uw U o U N x ~ J U Z Y ~ w g Z N m Z Z J J W � J Q J W J N Y Z > o o o m g to z ►a-- ~ mF0- > 000� wy mF Niyv7 ►a- � m '' NZ � o O mt'na � ZU yW WOO UZ UZ 0Z UZ_ 2O0 yZ_ � � F WO .B $ :3 w , > WooQ ug 0o m > �" p m > �" z m > z m > a > �" OW `�'a "° moLLLLm w OyLL > f x W aZj w a0 W 4 > w am aafliglom , to W �" 0QaQ 0 � ac~nLL rinv~, LL 1u~iLL � �ai 5LL v v�u� WZQq¢ 0 <co xOU � ZaU � LLLL W a j W U � WUJ w (7 � OUJWaO -iUJZ > > U' 7 0 0 0 0 a age a- * at O h N W O n O N O O O Go Go N N O r, o (7 O n 88 O O O O � n O $ o0 m m o n 0 m m m coo �i n c9i m o OD aormi In to 1A N N pp p W Qp Q�pp pp Q�pp pp a .- N pp Y 8 h 8 N O r W W d b < O N < - r,�, N O m OWO. N r 8 0 m N ems- N m r t0 � fD m $ r fh m rn r r o r rS ui rS LO ao ai v m ad m a m o ri of m ri W W ppppaalppprrNmMnr c+� W Ym O_ m mNr) Optpp m rm � mY N � rNQ V MrOm � Nmmdow w rrrOrmO O INONmO O W m � N N N a V Go N ODN ODco to N N N N r N r ((00 N N08_ 8p8p �8pp8m " 88_ t8888888828Np8888888p$ $$$R $ 8 -R$ m888888 .- 8 $ CO MSmmO O O O �0�T ��pp tD Y to (Npp Q EO 1 m pp pOp_t0 1p� CrD ErD OrD 1OaOr�D N ppMp ppMp r pQMp ®N N N m N IWW� G O 1q N N N V f W Y N m m N r) N N N W �V N N Q ErD V' N N Y Q co Q A n W N Q O m N 888888888888888888088888888888888808888mm $ NpppoS881� 8881p� 1� 1p1pA8888888888m� O N N N 10 O W fV O O N N N IN N O N N b 1q i[l 1[l O N N ' �+ N8r1m08 p88 pm80001p0� 188 a88282O8N80080 pN01888O08 ppp0 pN0 pm800 �O NN. 0 pO rmmf tNO.l7 N {8{pp.�O a�a (g(pp N �D Y O r1 0 ((pp Y O b (O m�m N pN 18f pO Om N b t0 aD V 1rq_O N ems- 00 U (O M V co N O Y r N SLO M N 0 0 l0 CrD b V O l'� N l7 l+f l7 m N N W m 0 0 a•- N 2 � ' ' W V N r O l7 m N r- �"' N YI N r N r P �' l0 r N N N N H1 N N r� aE aEaQaEaQa� e � aeaQ34 � a� aEa� � Ito � ae0a� aeaQrlN a � 3EaeaE pE � 3 aeaR o � 8w �bE N m m 0 �! $ V N V r M g r r N m r N r CD O 8 8 n m g N fD 0 m m m r 1ff r O/ Y t0 m tO Of 8 O m a N W m m m N O m N i9 O l0 m Omf P) r 1G r m v� Sri r H m m r m N � m r r W m uI m N m b V b m m Y UI N m m m m m m m N O m m O .- of — r» rrrrrrr 00 0 � � � mr ZZZ2 000 �Ooo � � � � � ooOc g .?i � uZiT, u`� uZu� u� u� u'Su'Su� u�3u� mu� �nau�iuQSN1nu'S �i �7iuZ �Ti �n � inin � wwww _ _ _ _ a a a a o � � o c H z a zo w F- 0Z LL co w 0 0 0 O O O O O O O O O O O O O O O O O O O 0 O O O p D O LL D 0 0 0 O O O O 0 w Y Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z > O O o O O o O o o O o O 000000 OOOOO 0000 O O O o O O O 0900000000 ? w a mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmcommmmmaomto w r > > r > rr > r > rr » r > r > � r } rrr } arr » r > > r } rrr z >z � � m rc rc rc m m m m m m m m m m m m m m m m m m m m a WW w v> wwwww wwwwwwwwwwwwwcocaa wwwQwwwQwfQ= fQ7QwwwwwQwwwfQAQ = w > oa K K W W W W W W w W W W W W > > > U W O hW h F F l-- � tw- F �00 W 0KKF_ (Y � w m1 - NaZu' z Z Z Z Z Z z Z Z z Z Z Z Z Z Z Z Z Z Z Z z Z Z Z Z Z pz Z z Z Z z Z Z Z Z Z x H F_ F N Q F O d (L0. S6o. adaaag, ? j � ? j ? jdjjjjjj ? � j � jj7j ? j jwviw 0 - atYi� W » » » » » 00000000000000000000 000000000000000000aaa z m 'aw0 � 0 00000000000000oc� 0000000000000000000o0v0aaQ 0 wma � oLL 0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 < LL a f F w F w w Wm Wrc Wm {�� W �W �W W W mW W� W Wm mW Wm mW W Wm Wm Ww Wm mW W W Wm �W �W {�� W� Wm mW Wm W W� W W� Wm z z z w Cl) v� u� m N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N C7C7C7 � U -- 2 u LL aR M U) N Co M N R 88 O N V 88 O r Cl) M v yB� QgQ$ Q�u, Qggyg� Qg $g� QggQgQgQyg� gQgQgQgQgQgQgQQgQgQggQSg� gQQgQggQQgQgQgQgQgQgQgQgSg� QgQgQggQgQgQgSg� �gjRgQg �i, 252525ZS2S �2S25b ?525252S2S252S2575Z5252i2525252S2S25ZS25 25 25 25 25 25 25 25 25 25 25 25 25 25 �25 25 25 25 25 25 25u�'i' 88888 $ 8 �388888 $ $ 885i8888888888 � 8888808 � 5� � 88m � 8888888m �$pp �_ppS N (O O N Y N N M IR ly o N O N b N 0 {O M Y ED O 10 tr r O N 08 � 88$ 8 � 888 �889oo8mo8moo � og9888898 9 i8m888899 8888 $ 88 $ 8 $ 88 $ 8 $ $ 888 $ 88 $ g $ 588888g88 $ 8gg8 $ 88888 $ 888 $ � 888888888888m8888558888m88888g88888o8m8 � o8m � 888888Sm 8 $ 8888888 $ $ $ 88 $ 888 � 888888g88 $ gg8888 $ 888gg $ $ 88S $ 88 $ 8 881f) 000+ B �i $ 88 S (O $ � � ID 108aD8 � CbD $ $ $ SS V 0000 � 08 � 10 � W OmYB � $ S $ 88N , � O� � � � Nt0bt0OalnrMU 0 U) N V � N N N ui N N N N M M M N CV b � wi N Q f0 f ui (O W* N N N N N N N N N N N t0 N N .- N N N N N V pI M M M M M M M M M M M M M M M M O O O O O O O < M M (j M M MO M O O M 0 0 0 0 M O Q 0 0 O O Z 0 o gp� o 0 0 00 Qp a o � NO � ON � N � ON �! (� r � f� 1N Na � hlTl c� \ P ao �N ao � NNa NNNR iNNRra 0. oo � ol- RHOHN 15 zvz � E � Ssz-omi " zo $ � � 000 � o � � ao � � oo0S � � � ° C0 Z o m ca Y Y Y LL > y y Y Y gm Y Y Q � a In z a < 1- zQ lz Q Z Z m O Z ` Z Z J Y f" m J m Z m J W m Y Z Z m J x mz Q Zp < Q ZZ yVfZ Z � J Z ay < V mZ C7m y 7 mm Q Om Z � F F- Z Z Z m m Z 2 Z y' Z ZQ wm j ~ W W Q Y Z O < Z i x OQ Y O W Y mR' Q W Z m Z m Z m 0 O ! 5 m H Z Z Y Q m W Z a m LL O Z > >_ m 2 < Y Z U Y p<p O Z Q ~a U < W Z Z Y OQ Y W m W my O V Z Z Z OZ0 � G<OUQY °0- !0 -jzZOmm � mmQz WZqN OMMM X � m -J+ ZZQZZa 'J W W FYU~1W a6Z < — QaQxLLS0yWm � J3 > OxOWmZmmjW jmo < m7 � z (0) Q0ZW OU W WO > w. =) < W OY W ma 20WUZQJOF" Fx Oj fop !<- F — jj •.f ap > W r- W ZQ W YYZW j � 0.' O W W UF- � mz w < aao' 5 � 92 � aoy°000ao 000w� awmXLrixwwoaW < :3wwzx -- - TOLU o < m mx m LL = Z M 0 Z O0. x 0 CO) xUU U 0. 0U O. 2i WLL0 < aLLZm m c9 E < to 7m S' LLUY � (n � l- 0 mr O � rto g 80 8 � � mmp� 8Nj88 Q n ! O Ol Ol N F M N o m ;; r N g 88 888 8888 $ o � o00 8 8 NNN N N �° � a88 mc88 8 W W M N iV m O a��cCCbpD b/fph W (op� xa�NS ro Npp yy2pp��5 pp f � �p Omp Op poj M S� O Or CIA n wcDvp Y aQQHoiVICOO Flog) H F O1 r0pNp1 M BpQ25pO8Q25 pO8Q2S pOb N P m -O SO2�S pQO�2p5 pQO2^5 OppQ25 Bp�pyOtp�S pQO25 rpQO2SDp —Y N pQO2S pO�pQO2aO5D � NOl9 BCD n00 � MNCp� O {prO� 1nO� �QOp1 ��pp ��Npp � p®YO � ONC? 888885 � � ��eMpp- M SOOlhOY8O 8O $ ��C�Npp� mpO Qr Ei 12: .O V NO� Opf /D d? m 101�Nv oO SO 8O �ttl+yf lON � Am pW CpbCOp iV N V r 1fl N eM- b r N ,D a A N O � l9 N O Sf CD ; S O W O V CD N r N M N V r r M N r N co � °a� 8888888 $ $ 8888 $ 8 c Coo 1.4 88888888888888 80, SSC4 ; $ M$8 $ 8 SR& 88 $ 88888888 $ 88888 8899 Na gIN N � 88 � �i8N81° � N I I I I $ I 8 � 8 8889� � 8 � fO � NOOrCD N Or, O V rO B � m rmO W O1tf (DrOD t; O CDI� P- . mi CD M m N b m m V h Iq r r O O M M M M N CV N M M r r f� O N N N V ' m CD O CD CD Z Z Z Z Z Z Y Y Q y Z ZZZZ Z �gj �UfSS Yi CCVV iX' cwc�� W W W W � uZAr � dsu� � g g 0 o 000 a o c o $ r r o O O O p 0 c o c r s a o o O F O CZ,z a Z a d I Z as z wu~i w ? w Z O (A O p t Z Z O W W cr Y yy U. � Q U V m 4 m m Q Q � � � W Z � hc Z � O OZ Q W �HHOZ 0' pNlYS � u�u� �C2F N & a wZZ ►� < zz 1Zm apJ c9 1llopU Z �O qq zc� , N !Z wa zz 15� rrg J S J < Zu °r° umi o w U. xZ m nrc W 000 °a $ w oo $ wI �u p at ug �p p6Jp �cw c�-ivzF � zfl ae W� jw JaQazJ zzJ a xm m � 21=L R' y Z41 JOWWW7 OJJSSOJoJ F oQ. lr �- zZ aM Fa O_ JJO12 JwU � 1 O_ yZZwa a �aa�p� � o� aQoo�<< a ►- a o .ems o � � O � U� Jo a jm J � ~ � WNZC ZZS �ip � a � 00Zz � i LL -1 U.D ziImu W g �N�<AQavy��t7�t��711 >pz¢�¢(( � �19 N t) Z � Z = W W WLL U.W {�� W W W WRWa' W W WZ QUy aVJ w ILZZ0UU.. IIL KUIigIL aam � f IF- N �tFFNNu f LLF- U m 3 ■ � © � oo � k & § & coo � § # # # # ■ # # # 2 2KK ° Kg - � cic ■ # # ■ � � ■ « CIA # ■ © F Rk kk m # © E # �k k ° a | | | | ( | | i kk k / o - o - zz zz kK ko & ) § J § ww ww k % 2 kEz 2 B & Ui w w § 0 W, - , w <- § § k$ K §$ t e wz � w z § w ° 7 ° ' © g ' 12 9 g 2fk2 2f � � & §2 � § 2 � � L 'Q0) 000O C O) O O O O 0 r N N N N Vim ■ ■ ■ ■ G 0 W > N > Z O �-- N OC pC o C' w W O U. G. CO) w401� .J Z o � Q a Nmo Q �W O m W 75 Z � ; LL ~ 0u- Ir O a W W � C� � a � J Q L J W a L C� G LL cis O O O O O O O O O O O O O O O O O c N O 000 to d' N r r r r L. VO) 0000 C 0 Q Co o o 0 N N N N v d � o W > z 0 N O o 0 W N J Q c) F- d LU ti O to 3 WCM .J W Q o CLi LL Q � 73 NmG J Q O C W W = W = � Z m J LL �, ZOca V � O o� L W W a cc 40 J = � LL cc 0 0 0 0 0 0 0 0 0 0 0 to o o LO N N L 'a 0) O O O O cc) O O o O C) v- NNNN v d ZM M �+ !V CM W o 0 W t0 OC- J It w/ V� W Ir V- 3 W 40). Q MC7W O N m o QJ 3 Jao � Dw U. } LU = U. F' � HaW ONw m Wcc � LL. oc U. J 2 oQ L CL W Q c ccL Q L LL Em J J � �a 0 0 0 0 C 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 �p to d' M N r' VILLAGE OF BUFFALO GROVE 07/31/03 BUFFALO GROVE GOLF CLUB OPERATING STATISTICS THROUGH JULY 31,2003 FISCAL PAID ROUNDS THRU PERCENT OF FINIAL REVENUE FINAL EXPENSE EXPENSE PER YEAR ROUNDS SEPT 30 ANNUAL ROUNDS REVENUE PER ROUND EXPENSE PER ROUND RND-OPERA 1978 35,096 32,271 0.9195 341,798.00 9.74 338,437.00 9.64 7.11 1979 38,122 35,195 0.9230 396,243.00 10.13 300,100.00 9.45 7.03 1980 39,076 35,938 0.9197 428,105.00 10.90 394,800.00 10.10 7.85 1981 41,80 38,488 0.9197 475,323.00 11.36 448,747.00 10.68 8.67 1982 44,217 40,392 0.9135 515,686.00 11.66 502,614.00 11.37 9.22 19M 44,798 41,429 0.9248 SW,022.00 12.28 535,287.00 11.95 9.76 1984 43,551 40,036 0.9172 623,882.00 14.29 573,5W.00 13.14 10.24 1985 49,231 45,888 0.9316 667,638.00 13.50 620,488.00 12.60 10.15 1988 47,148 43,779 0.9285 691,839.00 14.67 826,068.00 13.28 10.83 1987 48,315 44,281 0.9165 761,359.00 15.76 781,462.00 16.17 12.29 1988 47,861 43,748 0,9141 809,857.00 18.92 842,208.00 17.60 14.08 1909 50,781 46,097 0.9078 954,771.00 18.80 951,289.00 18.73 16.19 1990 49,988 44,398 0.8882 950,456.00 19.01 1,031,744.00 20.84 15.18 1991 48,000 44,133 0.9194 1,030,200.00 21.46 1,020,280.00 21.26 16.01 1992 42,610 38,751 0.9094 973,811.00 22.85 1,010,905.00 23.72 20.12 1993 41,170 36,941 0.8973 999,652.00 24.28 1,077,153.00 28.16 23.78 1994 46,618 40,442 0.8855 1,211,322.00 26.55 1,190,571.00 26.10 24.11 1995 41,624 38,010 0.9132 1,109,438.00 28.10 1,197,062.00 28.52 24.58 1996 39,079 35,577 0.9104 1,182,099.00 29.74 1,242,680.00 31.80 29.68 1997 44,391 40,002 0.9192 1,349,932.00 30.41 1,282,152.00 28.88 27.64 1998 46,283 41,211 0.8904 1,412,486.00 30.52 1,377,727.00 29.77 28.12 1999 42,822 37,219 0.0892 1,389,089.00 32.44 1,459,020.00 34.07 25.13 2000 43,422 39,019 0.8988 1,440,585.22 33.18 1,404,862.97 32.35 28.90 2001 40,599 36,259 0.8931 1,431,898.48 35.27 1,388,345.84 34.20 30.48 2002 41,166 36,853 0.8963 1,347,522.00 32.73 1,419,105.00 34.47 28.62 2003 24.105 24,105 1.0000 825,235.00 34.24 868,641.00 27.74 17.74 TOTAL 1,121,018 1,021,229 0.9110 23,558,548.70 21.02 23,394,850.81 20.87 17.98 2003 ROUNDIINCOME BREAKDOWN: GREENS NUMBER REVENUE PERCENTTO FEE ROUNDS TOTAL 37.00 3,8W 143,116.W 16.05% FY 2003 COMPARISON AT JULY 31: 2003 2002 28.00 2,346 65,688.00 9.73% 27.00 1,793 48,411.00 7.44%RESIDENT PAID ROUNDS 24,105 24,836 22.00 1,086 23,892.00 4.51% PERCENTAGE CHANGE-2003 -2.94% 21.00 372 7,812.00 1.54% 21.00 790 16,590.00 3.28%RESIDENT REVENUE 825,235 816,713 18.00 422 7,596.00 1.75%RESIDENT %BUDGET REALIZED 58.13% 35.83% 16.00 5,280 84,460.00 21.90% REVENUE PER ROUND 34.24 32.89 16.00 524 8,384.00 2.17%RESIDENT PERCENTAGE CHANGE-2003 1.04% 13.00 1,338 17,394.00 5.55% 12.00 2,253 27,035.00 9.35%RESIDENT EXPENSE 868,641 619,616 12.00 834 10,008.00 3.48% %BUDGET REALIZED 48.02% 31.29% 10.50 1,335 14,017.50 5,54%RESIDENT EXPENSE PER ROUND 27.74 24.95 10.00 132 1,320.00 0.55%RESIDENT PERCENTAGE CHANGE-2003 7.91% 800 1,292 10,338.00 5.36%RESIDENT 7.00 204 1,428.00 0.85%RESIDENT OPEN 236 3,183.25 0.98% TOTAL 24,105 490,691.75 100.00% WEATHER CONDITIONS(AT LEAST PART OF DAY-SINCE 04/03): H S 2 TYPE MONTH TO-DATE PRIOR YEAR RAIN 4 20 18 CLOSED 0 5 1 AVERAGE GREENS FEESIPAID ROUND: 20.36 NO-CARTS 0 2 2 RESIDENT ROUNDS 8,745 36.28% TOTAL DAYS 31 121 121 NON-RESIDENT ROUNDS 15,124 62.74% FIRST SNOW: OPEN ROUNDS 238 0.98% ROUNDS %ALL ROUNDS MEMBERSHIPS AVGIROUND MEMBER ROUNDS 6,484 21.20% 101,591.50 15.67 TOTAL PLAY 30,589 amR :RaRPm N11�p p�R aR3 - aYR � aR � V�Rrz 2�Rp o�p m p�OR 4 b�aL NaR �D p�R 2Nt OapoR mA�R PaRyaRN P N 9CIOD S V a0 P O coO O OD N pOp 1f1 t0 i m7m7 O N f a dD N O a GD f7 IOp_ f Y iD O N �Npp a �p �pp ED QO�pp �O�pp t0 V Yrf O A pf N N O Yf QO O V O V eO- N N N O Q � f � ODF O � O O O Ul N O O O O N CND Y1 01 O A W O W Pj aD l'9 Orl N ^ N N j O O O 9 CA Rf ,h N O O B O O N O N Y� Y .7 � N N m m CD Q O Q CCDp v Cp N p N N Z O O O w O V NaWD N O O S OC § Fb O O §paDf �p �^ �wl Os § VN vW OAf cq O In N N O O O IR A sl O O O N Q t� rsn P co G Qcm f0 Of h N N CV (O d Cp CWp pp �p /pp+ppl Cpp a 1lQN�V Cp 1CpNpV � M ED O O O c m n A O fD N CD ? CID N O n O N N g ODY 11! O Cp Ng � � N � Cpp N 0 aD O O � O fH 1pp� � O CD N CPS � � CD � i0 O O Rl CCpp m r O N p1 e- f N r .- N r M N '7 In N C7 1 N l0 10 CD N CD �1� N � �f {��pf N W (h�y h pg O O O COD (0 O O O O � N n aD Y W O� lV� f O ♦ lOV YOf. Ol t8 PNf_ N COODD N 1fOl 1� Op Y v 00 N NN R O Q O l+l 8 •�•10 F N �- 10 co 10 ^ v O N O� Op� Cry Cry p C� Opp 77((;; P in N N 8 N to O Cps A er- O O q ZV O R' CD � l+l N 10 P. h CD Ld a' OOG0N 0 O l7 eN- r h 0 O N 0 0 W O O O O la N N 9 C4 h 01 N fV co A a �, N N N N � m {p O CD O O O O O O N 1/1 m O N O m O O Q O Oa Q O U. vi O N N N U. O N a 0 0 0 w 0 0 W O OD 0 0 0 0 Z O N 0 0 0 0 0 cml0 g ZZ CD CD CO p �, t0 op p N IlJ W U N p = Z Q W a m w m O� m a a N w m �ja a T o � y0 rza w < � � _ u~iK � J Q �L < wJ � ZK tATwLU JLL �pJ � zwco Lu � � wCL w � mWwLu � LLw Jwwa > �z Qw m � LL $ � arc �a0:v=, o0� 00 �miXr 9 wd � Ud � wWIi it zaa1Zg oi esmJXDJ� � d �J 0VF z °zJW Z Oyy O2a � Ya mNW Vm UZ W W W <-d �if w � �I � aym � LTIi I QQJ LL. � a � a > VILLAGE OF BUFFALO GROVE 07/31103 ARBORETUM GOLF COURSE OPERATING STATISTICS THROUGH JULY 31,2003 FISCAL PAID ROUNDS THRU PERCENT OF FINAL REVENUE FINAL EXPENSE EXPENSE PER YEAR ROUNDS SEPT.30 ANNUAL ROUNDS REVENUE(1) PER ROUND EXPENSE(2) PER ROUND RND-OPERATING 1990 16,406 14,097 0.84115 818,665.00 49.54 882,836.00 53.65 32.05 1991 24,389 22,692 0.9304 770,431.00 31.59 1,105,930A) 45.36 30.85 1992 24,311 22,399 0.9214 854,941.00 35.17 1,170,499.00 48.15 33.61 1993 25,569 23,283 0.9100 023,276.00 36.11 1,245,315.00 48.70 34.80 1994 28,713 24,382 0.9120 1,019.636.00 38.17 1.346,782.00 50.42 38.96 1995 24,805 22,W8 0.9165 981,915.00 39.46 1.289,942.00 51.84 39.67 1995 27,907 25,537 0.9151 1,105,497.00 39.85 1,355,953.00 48.62 39.55 1997 29,090 28,462 0.9097 1,176,296.00 40.44 1,402,408.00 4821 38.32 1998 28,516 25,581 0.8971 1,182,135.00 41.46 1,507,525.00 52.87 39.01 1999 25,955 23,890 0.8883 1,154,20.00 42.82 1,542.510.00 5723 42.50 2000 25,722 24,177 0.9048 1,120,590.01 41.94 1,420,418.79 53.16 38.40 2001 21,795 20,451 0.9383 973,710.30 44.88 1,271,916.44 58.35 40.03 2002 22,152 20,070 0.9053 859,505.00 38.80 1,488,034.00 67.17 49.85 2003 14,228 14,228 10000 74092328 52.08 768,112.04 53.99 25.70 TOTAL 339,718 310,043 0.9144 13,880,712.66 40.27 17,799,17927 52.39 37.43 (2)INCLUDES PRINCIPAL AND INTEREST DEBT SERVICE 2003 ROUNDNNCOME BREAKDOWN: GREENS NUMBER REVENUE PERCENTTO FEE ROUNDS TOTAL 56.00 2,405 132,275.00 16.90% FY 2W3 COMPARISON AT JULY 31: 2003 2002 45.00 401 18,045.00 2.82% 42.00 2.171 91,182.00 1526% PAID ROUNDS 14,228 12,352 41.00 1,829 74,989.W 12.85%RESIDENT PERCENTAGE CHANGE-2003 15.19% 40.00 194 7,760.00 1.30% 35.00 214 7,490.00 1.50%RESIDENT REVENUE 740,923 471,556 34.00 85 2,890.00 0.60% %BUDGET REALIZED 80.61% 21.67% 32.00 151 4,530.00 1.00% REVENUE PER ROUND 52.08 38.18 30.00 1,040 312M.00 7.31%RESIDENT PEtCENTAGECHANGE2003 57.12% 30.00 317 9,510.00 2.23% 27.00 10 270.00 0.07% EXPENSE 788,112 659,454 25.00 29 725.00 020% %BUDGET REALIZED 47.30% 50.73% 24.00 854 20AN.00 8.00% EXPENSE PER ROUND 53.99 53.39 24.00 75 1,800.00 0.53%RESIDENT PERCENTAGECHANGE•2003 16,48% 23.00 61 1,403.00 0.43%RESIDENT 20.00 2-IN 45,920.00 16.14% WEATHER CONDITIONS(AT LEAST SOME OF DAY-SINCE 04)01): 20.00 350 7,000.00 2.48%RESIDENT TYPE MONTH TO-DATE PRIOR YEAR 18.00 32 570.00 022% RAIN 6 22 16 10.00 57 1,026.00 0.40%RESIDENT CLOSED 0 1 18 17.50 752 13,100.00 529%RESIDENT NO-CARTS 0 0 0 15.00 88 1,280.00 0.00%RESIDENT TOTAL DAYS 31 122 91 15.00 111 1,055.00 0.78% FIRST SNOW: 4nA3 14.00 32 448.00 022%RESIDENT 13.00 101 1,313.00 0.71%RESIDENT 12.00 7 64.00 0.05% 12.00 318 3,018.00 2.24%RESIDENT 10.00 28 280.00 0.20%RESIDENT OPEN 222 5,323.10 1.56% TOTAL 14=0 488,400.10 100.00% HS 0 AVERAGE GREENS FEESIPAID ROUND: 34.19 RESIDENT ROUNDS 4,943 34.74% NON-RESIDENT ROUNDS 9,083 63.70% OPEN ROUNDS 222 1.55% ROUNDS %ALL ROUNDS MEMBERSHIPS AVGIROUND MEMBER ROUNDS 1,553 9.84% 24,046.00 15.48 TOTAL PLAY 15,781 (1)DOES NOT INCLUDE PROPERTY TAX EXTENSION OR OPERATING TRANSFER REVENUE OF: 1991 181,088 1995 125,020 1999 233,342 2003 94,384 1992 152,356 1998 619,738 2000 240,598 1993 149,885 1997 133,497 2001 457,901 1994 157,001 1998 204,047 2002 488,093 l�7p W lfof <pD 99483 � 8 S 2 " 8 � N{�f N{�f � ED aR s s F O N O 0 b V ED 0 0 ED I to A m O O C C 00 A O m N N 0 1p YI 11C11~�� O O off O § O O O Q Q O Yf O O O 1p C7 O_ C p 1A V' 1� in IA N O N ? N 1n Nj_ �17j_ 1� t�l pl N 47 hj A C < tV N N a m W N 1pp1�� fp{{{{ Epp dap m �Wp Epp m g O I O V m 1 1 A < � O O 8 W � J aD N N O N O O O N V O� � aD i Yf 8 c N A N O O N N O N O 0 f0 N W W A A H 0 0 0 0 0 8 U A 0 O O O O O 9 O 0 Iz N g F- A O U c 0 O O O O O O 1R l0 A Q 0 0 0 O c0 W �O aQ O O 4. 8 a. 1Q0�+pp1 WNW V m w Ival+� �j O O O O O O g N IN O A pV O a cm .0.. N v^ vA iV a J O 1n Y O a0 O O N v O N W A O O m Y Op/ In a O O O O O OD O O O C4 9 O A . N N l7 C N N m V EN N O O O �p 0 A Oj O O O Z OO * 0 mN O m b W 0 �IVQ WW h Y Ci lh N W a0 (Qpp l9 Ono N O O 8 Y - 0 W N b gYg O 10 NPf N Y 01pD N GA N A W lh gY ED %p N O t� •- A 2 N lA7 N O O O N 2 N O 0 N v 0J W O M O O N fV O N fV [V 0 N O Epp N O O O ap Q N N W f Pf v 0 0 < N lq N N N N lV O O O O O O O N O 0 0 8N O O O N IR N O f0 O O pp O O W A O g m m r A f v N C N l7 O C O O O O g O O O O O O O O O O O O O O O O O O O O O O O O O O O O O m O cq Ep W N m O w C WLL O 0 0 0 0 0 0 0 OD O O O O N O O O N iR O O O O O O O O O O O O O O O O 9 a m m m 0 C N QRI w w K `'• N J Z W O Z 5� J p F j J m 0 Oa F cOiy � Q mw m :, � � W aJ ww F- J W J } 0 W F a w LL N W j W w 0 ] W2W a' µ� LL' U w W w W 0 6 � JW a 20w � W w4 � Z2Z F W � � ZaC7US2 -< IT � z O m_mp WX W a � J w � O a h W Ud' � W O � Z � O < IQ-� .2F � Z �"' LLU � 9 O � Z � JGFQ- Fw0F W (A � ►- � w UFO O O z M WHO kH 0 I<- Z rc z d' 6 uj Z W to z m f f- J W z z �at31 tQi. W CO w qi �C. m f- 1- �- J w 90 d' w W LL' O a' W J O J W 6. Qw ID CO J = B O O W ty O 7 K W J O W J W J O O W < W w0aa0z0 -j 0wC7viN ? UaF- a K aao20 -520 gozw < - a CDVOrC9NN Wm00 � n � � Mn Or� NOMDyNjCOMN N aE Cp m mqq CCp% Co V:lnrrr I��p CDN 1f10f �nph NNr NQQCpp . Q� N O � vrOi � :r � � vvN8 gj O NNNNNNNNNrNNg a3 � CND rNCEN CO NONI YM $ N OOONN � � 00 NO NOS N �Q O rA N Op M O r�C1 0 w0 O i 0 i ppf Cp pp pp p� N vWr- SCp) NNOIQ � N O � cm V cm VO' n V' t7 Wr- N O N v V' n CO N Of r D r r C V r r O r N p O O N m 0 Z r Z pp �p N COO a ONnNNN N � � ONE 10 U) MCON NaR � H rnn8 t - . g aDcorne%> m wI nti r' M N N N C V Cl) M N m N N m V r t=r N r r 1 n r O ci s Cl 0 O pMp �O�pp M r- .p NO) NO NnaR W aQ r �prn �bp C.ppO fO n M aQ Of C'7 nACD n CO Nm Qm� C � Ner- O ItR rN � Q� oN 0. It le It ;rv0 c3 $ W �vv V'vriaiNM NMI % 8 r (0 r p� pp �Cpp r o OD � CMD MMNtO VM' N � p NOAOCrD NOQN CD � rp n2ONNrOnr V' N O O V CO NOP M n n g r-ronnaonr._ mn � n � � pp V V 0Wi Wivvvv V Co 99 Q r n 0 Q r 0 n -� naCrO OrC� N O f0 crm rQp to NO1 OI N 040N O o O at rrON0 ivO CQO �p000 �r ww nmr OJco cowwcocoCoecr:r. CD j riioarV avvvn� rCP� nob ODD1pOO coC' O (Q� � � nOfMN � CDrOc4ir� MObnONf- CO vOtOaM �CON N 0 V NM1pto CO r in _WA Z O = 0 w 0 O 1, 0 r:h n n ^ n ^ rOr � v V• V7 Sri vvv v v 4 V 4 rCV v n M MCpp �Op CD O) C�pO �C) na<; n � Capp COp MCD �CppNN �p CDn M N �; } OQON or°tg r Or � n W N fO f'7NNO �NMnm N CO 46 . m 0 n 0 rO W M �m y o ui Q t i ai M M V• M M M tV M 9 Or c6 0 0 rO) ODOCOn pN� O O �(yy a, CND O �m CO NCO r O NNO M CDN tF N W nfrOm M DO co NNMMNMC ri vi vi o rrrrr C-4 rmr � rCp uz n0 IA0NCS4 O v Of aQ OrCfO) NNM OINONCOaQ rnQ a2 Z pp�pp N ON 't vco N rCO M cn CIA ffOO LLLL11 p 0 O �O � CD D1vvmO � �. ON r vMNY r r r O) N p N O p O pp F r J bC-i m -M AO � M18Non Cl � n aE 000000000000 O 0 ry rrrr � Clr � V N V 2 w O m p Z D W j LL O m � 1 JOJ OOrON nOOrntO CO � � vy * 0 000000000000 * 01 000 rrrr r v rrn CO 0 0 0 p LL I'c1 Q' N IyLI f� Q r C tOL c O C 0 ' 'WW w CC 0 � Y Y ON w 0w 0p p` � � Ow Om mg LL LL �Q V } O K y 552� 0 } A K } 580� �l�Ja � Ny 250gSO wa � } m m N rr r rr CIA C-4 OQIL t0 rrrrrNNNNF-' QdOQ LL � 0 Le Niels n Associates INCORPORATED Village of Buffalo Grove —The Arboretum Club Monthly Report on Marketing Activities June 2003 Focus of Month's Activities The primary activities for the month of May were directed to: 1)marketing calls to meeting and golf outing planners; 2)television advertising during national golf events; 3) website content creation and coordination between golf and banquet sites;4) communication between Village Board,Arboretum staff and website team to coordinate website enhancements with both sites. Hours Devoted to Account Hours for the month were above contract levels of 20 hours per month. Key Outcomes Accomnlisbed Many important aspects of this project were completed during May,and many were initiated. 1. Comcast advertising ran during national golf events. Story on Grand Opening finally appeared in Daily Herald Community section. A meeting with the JT Clark agency was held to preview golf ads and marketing pieces they have accomplished for other golf facilities with the possibility of working together on future more extensive marketing programs (perhaps in budget year 2004). 2. Marketing phone calls to approximately 200 event and golf outing planners were made during May. Of those calls,approximately 30 resulted in live contact and conversations regarding the Arboretum's new banquet facilities and readiness for corporate outings. Information was sent to all who requested it and currently there are 8 individuals who would like to play the course(with its recent enhancements)and tour the facilities. Appointments and tee times will be confirmed with these individuals over the next few weeks. A CEO of a Milwaukee company is coming down in late June with 2 other event planners to play the course with prospect for next year's outings for his company. 3. The biggest focus during May was completion of the www.arboretumclub website and coordination with AdNet for changes and improvements to the www.arboretumgolf website. This was accomplished by end of May and ongoing updates and additions are currently slated to occur monthly. There are minor edits Nielsen Associates, Inc. 2003 Village of Buffalo Grove—The Arboretum Club June 2003 Report to be done in early June. 4. Networking at the Lake County Chamber of Commerce in early May resulted in interest from several attendees in receiving information on the Arboretum Club and golf packages. 5. Finding newsworthy events and hooks to get the press in to obtain more coverage of the course/facility is always a challenge. WGN was out to Buffalo Grove Golf Course during May to conduct live segments with Paula Wagasky, LPGA Pro at BGGC. We took this opportunity to photograph Paula with the sportscaster and create a brief"bragging story"to place on the BG website. This is to highlight Paula's teaching expertise and draw additional patrons for lessons. 6. Monitoring of golf staff from a consumer perspective is ongoing. Creation of a survey for customers is underway. Directions for Coming Month For the month of July, continued promotion and press for the golf and banquet facilities, as well as advertising and promoting the Wild Goose Caf6. One-to-one marketing efforts will continue be geared to increased booking of golf outings and meetings. Advertising efforts will be focused on fall golf and winter meeting site. Nielsen Personnel on Account • Kathy Nielsen—overall strategy and account management; branding facilitation and direction; input into creative materials required; coordination with Progressive Management team; and coordination with Village. • Al Viehman—administrative support and liaison to advertisers; survey designer and data collector; logistical coordinator of print jobs and golf show setup. • Todd Milliner—oversee website coordination between golf and banquets; creative input into special events. Lynne Marie Parsons—graphic designer and creator of The Arboretum Club brochure, buck slips,rate cards, and ads. Nielsen Associates, Inc. 2003 LNiels n J .A ssociates INCORPORATED Village of Buffalo Grove — The Arboretum Club Monthly Report on Marketing Activities July 2003 Focus of Month's Activities The primary activities for the month of July were directed to: 1)assessing success of marketing/advertising for the first 6 months of operation; 2)planning for next 6 months of advertising and special events; 3)discussion and decision on a new folder and brochure to fit both golf and banquet sides of the business; 4)discussion of Chicks with Sticks charity event; and 5)photography of exteriors and course for use in advertisements and brochure/folder. Hours Devoted to Account Hours for the month were well above contract levels of 20 hours per month. Key Outcomes Accomcrlished Many important aspects of this project were completed during July,and many were initiated. 1. On July 2, a joint meeting with Carmen Molinaro and Greg Lundgren was held to determine success/outcomes of marketing/advertising for first 6 months of operation. As part of this discussion,Nielsen presented a spreadsheet of advertisers used and costs incurred to keep within fiscal year budget. Remaining advertising money was allocated to Comcast and Golf Chicago for balance of 2003. 2. Marketing phone calls to approximately 200 event and golf outing planners were made during July. Of those calls, approximately 15 resulted in live contact and conversations regarding the Arboretum's new banquet facilities and readiness for corporate outings. Information was sent to all who requested it. 3. It was determined that a 3 or 4-fold color brochure would be the most useful mailer for both golf and banquet sides. In addition,a new folder/press kit container was determined to be needed. Writing of the brochure and inside front cover of the folder, as well as photography were to be initiated during July and completed in August. Nielsen Associates, Inc. 2003 Village of Buffalo Grove—The Arboretum Club July 2003 Report 4. Ongoing updates and additions were made to both golf and banquet websites. 5. Extensive photographs were taken of club exteriors,the golf course, amenities, and interiors for use in advertising and new brochure and press kit folder. 6. Planning of fall/winter events/activities continued with no firm decisions on football/golf program or Chicks with Sticks charity event. 7. Creation of a survey for regular customers is being completed. Directions for Coming Month For the month of August, continued promotion and press for the golf and banquet facilities, as well as advertising and promoting the Wild Goose Cafe. Publicity for the Goldie Bateson Pro-Am will be the primary event to be highlighted. The Ladies' Club Championship at Buffalo Grove Golf Course and the Club Championship at The Arboretum Club will be featured in upcoming website updates. Completion of customer survey will be targeted for late August. Completion of brochure and folder is also targeted for late August, early September. Nielsen Personnel on Account • Kathy Nielsen—overall strategy and account management; branding facilitation and direction; input into creative materials required; coordination with Progressive Management team; and coordination with Village. • Al Viehman—administrative support and liaison to advertisers; survey designer and data collector; logistical coordinator of print jobs and golf show setup. • Todd Milliner—oversee website coordination between golf and banquets; creative input into special events. • Lynne Marie Parsons—graphic designer and creator of The Arboretum Club brochure,buck slips,rate cards, and ads. Nielsen Associates, Inc. 2003 pl. Ci 1�Ngj x N r l+j O 1Aj N '�+ m � h cpY l�f {� p p Y �p �(yp g M N N �j N 9 4 S N $ ie N !�j O N 0 A � N m O O ;R O o o yt o o O o It O yt 0 yt O yt 8 8 S 8 8 � 8 � 8 8 8 8 a o a o 0 0 0 0 0 0 0 0 0 o st o jt O X o yt O yt 0 O dt 0 yt o 0 yt O X o yt 8 8 8 8 8 8 8 8 8 8 8 rc O O O O O O O O O O O O o x o o yt o yt o � o yt o yt o yt o yt o yt o yt o yc s 8 8 8 8 8 8 8 8 s s m O O O O O O O O O O O O W W 0 0 �c 0 0 ;R o o yt o � o yt o yt o yt o yt o yt $ g S 8 8 8 8 8 8 8 Z c c o 0 0 0 o c o o c o C. o yt o yt o o yt o yt O 0 7t o Yt O yt o aR o X 8 8 8 8 $ 8 8 8 8 8 8 WU O O O O O O o O O O O 0 O o yt o yt o o yt o yt o 0 o yt o 0 o yt o yt > 0 0 0 0 0 0 0 0 0 0 0 0 0 z o yt o o yt o y o yt o o o o y o yt o K o yt s s 8 8 8 8 8 8 8 U O O 0 O O O O O o O 0 O O oit0 yt 0 X 0 yt o o yt o yt o o yt 0 ,yt o yt o yt 8 $ 8 $ S 8 8 8 8 8 G. o O 0 0 0 o c o 0 0 0 0 o yt o 0 0 o yt o yt o o y o yt 0 R o R o � 0 0 0 0 6 0 0 0 0 0 0 0 O p! O V OROD N vt Z N b W ^ O CAD m ® N Vco C4 Yf ci N m m O C O O m W N y ip 0 s f N m N N ti R O f0 U fV `/X lyj N O aJ Z Q z } co o w '� '� LL O m F t' V, z W Q < W yLLy W LL U w w J F F N H W F W U W W U HIl1 Z LL r XX �7 yy11 CL Z 6 0 O W 0 < H (Z9 O C O � R O > O F > > > > H O 7 O Z > > 7 W 7 W F W 0 W K m w m m K m U. LLwLLw m U. O m z�u m m m m �` m m rc w U g a $ 0 0 0 W 0 0 J 0 w O O O w 0 J 0 0 F r N O Ci O f M m co m OD N N O spy h 0 .gym ^ N mj O Mf m $ f N Y N mci � � arD h r 0 o yt o x o x o o o x o o yt o o ;R o o yt o yc o ;R o ye o ye 0 �8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 a O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 < 0 y 0 X 0 yt O yt O yt 0 0 aR o X O o yt o yt o yt o yt o 7R o 7R 0 X 0 0 8 8 8 8 8 8 8 8 8 8 8 g 8 8 8 8 a o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o yt o yt o yt o yt o yt o o yt o yt o � o � o � 0 71t 0 aR o yt o yt o x o 8 8 8 8 8 8 8 8 8 8 s 8 8 8 8 m 0 0 0 0 0 0 0 0 0 0 0 0 0 G 0 0 0 0 yt o y o o 0 o yt o yt o yt o yt 0 Yt 0 yt 0 Yt 0 0 o yt o o K 0 8 8 8 8 8 g 8 8 8 8 8 8 8 Z o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o yt o y o ye 0 yt 0 ye 0 yt o y o yt o 0 yt o yt 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 U 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 yt o o yt o ;R o 7R 0 o yt o Jt o O 0 yt o yt 0 X o yt o yt o o :R 0 s s 8 8 8 8 8 8 8 8 8 8 > 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O Z V 0 0 0 O O O O O O C 0 0 0 0 0 0 0 O o yt o yt o �(t 0 0 y 0 0 yt 0 yt 0 yt o yt 0 0 o 0 yt 0 0 0 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 a o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 w o yt 0 yt 0 yt 0 yt 0 0 ;R o X o 0 yt 0 yt 0 yt 0 yt o yt o yt o o � 0 0 s 8 8 8 8 8 8 8 8 8 8 8 0 8 n 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 < �p cp f �cgp o 0 w �j I- Cm O $ Q m r N aD j W O M W Y q q 0 M Y h Or $ aD lN7_ Y7 O W N 0 CI rci Z O p f f 7 N N Wj l7 f N Vf 7 t3 tm� o allo R m aR " `R 0 n � c N N J., �j pp V- C',Z < to Cij tZ w (� W c� a r t� w i z w J O W w OW > y Z > F a < Z W m C W O < O (W7 Wz CD z 11> CD �J1 r {(r�7 W W o r r w r Y w r r a = LL > Q �+ 0. p m W > >> w V. W j 7 O j 3IL 0 > } :) � p w CD O X Or r Z W m m w m m m m W m w m Z m W m Z m W m V 1p�� N 1 m� 1m� 1m. z m J W (W� Q O 0 � Z W o o ow o V o p u p w J O W Cj z O < O K w p m > O t O N O O W O J O � t7 � m Z O � � F a O w > 0 > w U. 7R W IR eR O yt 7R Z 7R eR :R p 7R 7R W 7R w yt W m J 0 a J U. a m w m m a a w a # # § ■ # # E _ $ / § | A § Act It ■ !_ § k § " | kK m # ® ■ - - - - - � " © ° ■ � � � � , $ © f © § ° § ° § | ° . ° § ° § e § ° § ° § � ° § ° § ° k ° o ° § a ; | ■ | ■ ■ 2 § § | $ § | © � ' © 2 � & g ■ ■ � © � � � k | ° . - # f ® § ° § m cIt ° a ° § § § $ . - | § | ■ e ■ I L m r N N N N V v m 0 W z > O O a 0 Cl) O CD J ' a a N LL W M� W � 40 00 W W LL (� o O v 0' W � Z g M � �ii W o. Nmo CD a a �Qo� W W J cc XaZ ov LL 0 0 0 0 0 0 0 0 0 0 0 0 co W M N MEMORANDUM DATE: August 4, 2003 TO: William R. Balling Village Manager FROM: Paul A. Soucy 615 ESDA Coordinator SUBJECT: Monthly ESDA Activities Below is a tally of ESDA activities beginning July 1, 2003 through July 31, 2003: ACTIVITY HOURS REMARKS Emergency Management 15.0 Emergency Preparedness Plan update Homeland Security Training/Drills 30.0 Mobilecomm Operational SOP —Art Festival Meetings Monthly 6.0 Upgrade emergency communications of EOC LCEMCC 1.5 NIEMC Meeting Quarterly ESDC Meeting Other Homeland Security Meeting MIS Meeting Bioterrorism Preparedness Planning Comm. Response Fire Police Public Works Projects 88.0 Art Festival TOTAL 140.5 PAS/bf i � 5k �* VA a n{ `ivyj & be O t _ 8 $ a s � ups#' ,5�e �%'#. •• w� Z _vv t } w 0 Ned), > W � s 0 a � oc wf�� 0 m a p400 JwJcm J LL, Q wwv D z C � b A.w a b6, y 000000 00000 LOqqtCMN�- M a r N 0 M U Z � m W U � p Q a �W " J O J N a ui U. W 0 ° > > W Q OrLL c!) O J N a IE L m N T � � T a) U � M 0 W r LO o LO o � N N r T'll 'Del, �% Z w � moo0> ,. IL w Dcv) Z Woo C\i ccN H s/k LL !0 w (� > > >„ °/� O m ��' '% <o 6, O M s LL Q �0 LL co Tel D M W T Qc /- YO ws s� 0 0 0 0 0 0 �r o Ln 0 Ln s N T T W C) Cr r> LL W o� Rio o10 o> W Z G OaWN s� Oa W J r,Vo U. a °C � LLWL � 0�4' �s �S G0i cS� CC ell O O O O O O �'WS' O 00 C0 q' N T BUFFALO GROVE POLICE DEPARTMENT July 2003 Calendar Calendar Year to Date: July July Yr To Date July July July July July PART I CRIMES 2003 2002 2003 2002 2001 2000 1999 1998 Homicide 0 0 1 0 0 0 0 0 Forcible Rape/Agg.Criminal Sexual Assault 0 0 0 1 0 0 0 0 Criminal Sexual Assault 0 0 0 0 3 1 0 1 Robbery 0 0 0 0 0 4 4 6 Aggravated Battery 0 0 3 0 4 2 2 2 Aggravated Assault 0 1 3 4 2 6 2 4 Burglary 2 5 30 21 20 31 33 30 Burglary from Auto 10 15 68 92 103 87 115 ill Theft 39 37 218 186 219 187 172 201 Auto Theft 2 1 8 12 14 11 9 7 Arson 2 1 3 2 1 4 1 0 Tot. I Crimes 55 60 334 318 366 333 339 362 Part II Offenses 227 260 1397 1551 1519 1923 1757 1808 Part III Codes 1654 1742 9938 10273 10657 10453 10861 10285 Incidents 1936 2062 11669 12142 12542 12709 12957 12455 ARREST DATA Part I 4 14 50 62 47 45 51 58 Part II 86 110 655 704 623 1012 905 916 Part III 3 1 36 28 31 47 60 56 Traffic 1287 1197 9088 9120 8913 12332 12183 13034 Ordinance 444 554 2808 3413 2474 3436 3180 3970 MANPOWER ANALYSIS - PATROL DIVISION MANPOWER ANALYSIS - PATROL DIVISION July 2003 July 2002 Equivalent Equivalent Part I 55 x 3 = 165 Part I 60 x 3 = 180 Part II 227 x 1.5 = 341 Part II 260 x 1.5 = 390 Part III 1480 x .5 = 740 Part III 1564 x .5 = 782 Accidents 174 x 1.5 = 261 Accidents 178 x 1.5 = 267 Traffic 1287 x .25 = 322 Traffic 1197 x .25 = 299 Ordinance 444 x .08 = 35 Ordinance 554 x .08 = 44 Total dedicated hours 1864 (formulated) Total dedicated hours 1963 (formulated) Total man-hours: 5378 Total man-hours: 5144 Undedicated Dedicated Ratio Undedicated Dedicated Ratio 3514 (divided by) 1864 = 1.89:1 3181 (divided by) 1963 = 1.62:1 v t v � 3 � � r i v z O � > r C W c 3 N : f+ C cc W 0 ch £� 3 V O � a ._ C4 o O >% as ■ O 0 L cc C cm � c o � O N r C N • �n W > N O �v cm �= O ■ W N ■ eh t O O O O N N O 0 T T Q ■ a0O C Cf) O N d v n _ V ❑ a N cc IL D N ■ E cc L La ba _v N O >+ > a a O ® ■ L 0 0 N CO) '� vs � m V o Ncc a � cis o LMJ O N N cc 0 a N O QO O $O O O O O O O O O O N N w r- M La !"f N 0 r 0 LA PUBLIC WORKS DEPARTMENT OPERATIONS DIVISION July-03 WATER PUMPAGE REPORT (month) TOTAL THIS PERIOD FISCAL YEAR TO DATE LOCATION CURRENT LAST YEAR CURRENT LAST YEAR Well/Pumping Station#1 345 So.Arlington,Heights Rd. Well Pumpage(mil.gal.) 0.000 0.000 0.000 0.000 Lake Water Pumpage(mil.gal.) 16,661 19,984 42.165 47.627 TOTAL PUMPAGE 16.661 19.984 42.165 47.627 Well/Pumping Station#2 525 No.Arlington Heights Rd. Well Pumpage(mil.gal.) 0.000 0.000 0.000 0.000 Lake Water Pumpage(mil.gal.) 38,216 42,991 127.564 139,526 TOTAL PUMPAGE(mil.gal.) 38.216 42.991 127.564 139.526 Well/Pumping Station#6 120 Horatio Blvd. Well Pumpage(mil.gal.) 0.000 0.000 0.000 0.000 Lake Water Pumpage(mil.gal.) 52.581 83,751 125.464 136,573 TOTAL PUMPAGE(mil.gal.) 52.581 83.751 125.464 136.573 Pumping Station#7 401 LaSallle Ln. Lake Water Pumpage(mil.gal.) 71,260 108,475 202,116 246,466 TOTAL PUMPAGE(mil.gal.) 71.260 108.475 202.116 246.466 Total Well Pumpage(mil.gal.) 0.000 0.000 0.000 0.000 Total Lake Water Pumpage(mil.gal.) 178.71 255,201 497,309 570,192 TOTAL GALLONS PUMPED(mil.gal.) 178.718 255.201 497.309 570.192 AVERAGE DAILY USAGE(mgd) 5.765 8.232 5.406 6.198 Comments Submitted by: t a ran werSecf1oh Supervisor Reviewed by: S ntendent P17 Wol Operations g:com/quUwater/reporVmonthy/pump96 Village of Buffalo Grove Public Works Department July 2003 Central Garage Section Fleet Cost Detail This Fiscal Year This Fiscal Year Last Fiscal Year Last Fiscal Year Current Period Year-To-Date Current Period Year-To-Date Usage-Miles/Hours 107,593.0 307,409.0 98,310.0 300,277.0 Fuel-Gasoline Gallons 7,088.7 19,971.0 7,538.7 21,675.6 Fuel-Diesel Gallons 5,634.0 13,338.9 3,816.6 13,870.8 Fuel Usage-MPG/MPH 8.46 9.23 8.66 8.45 En-Oil-Usage/Qt. 0.0 0.0 0.0 0.0 2nd-Oil-Usage/Qt. 0.0 0.0 0.0 0.0 Road Calls 5.0 9.0 2.0 7.0 #Repairs 532.0 1,450.0 193.0 1,041.0 Shop Hours 721.5 1,912.0 566.0 1,864.5 Down Hours 0.0 0.0 0.0 0.0 $Cos $Cost $/Mile $Cos $LAdlla $cost vmk 4211 -Gasoline 8,364.68 0.078 23,980.33 0.078 8,524.11 0.079 24,974.2 0.081 4212-Diesel 5,915.72 0.055 14,442.99 0.047 3,663.91 0.034 13,316.0 0.043 4215-Add Eng-Oil 0.00 0.000 0.00 0.000 0.00 0.000 0.0 0.000 4215-Add 2nd-Oil 0.00 0.000 0.00 0.000 0.00 0.000 0.0 0.000 4213-Shop Parts 7,960.91 0.074 25,922.18 0.084 7,196.83 0.067 17,194.8 0.056 4214-Shop Labor 19,173.99 0.178 50,704.17 0.165 14,972.16 0.139 50,585.6 0.165 4218-Outside Repair 1,743.39 0,016 4,807.25 0-M 2,379.60 0,022 7,489.0 0,094 TOTAL 43,158.69 0.401 119,856.92 0.390 36,736.61 0.374 113,559.57 0.378 Submitted by: Central Gara Superv' r L Reviewed by: (a Superintendent P 7 Work Operations g:\common\garage\reports\monthiy\moriendO3.xis W} Q~ p1�A`�001 CD OpnpD M 2U� tQl aNO��N m1n � O 34} Q Yj fi: W 0uj t a } c p c p y W W 7 Z f�Oi 1fi chi p pnp�� o pO 01 t�+v0� a�aj NCN . p�pg. Y W fAO.N�0�1 pf 8 Ol Q NO M Ol h l��00 W ? lL K Stu,mM V 10 ff$? > fV O1 r� m mnt0a w U, a ~ > o a� Uw H 40 O m o �S 0 O a Occ F j t 0 a Q y y Z Zzs oQ000QoQoQR�o o8888-888 aUwzw o 9zB�.�o o1k R r= s0O � z R z _ �a W S�9^4 O 1 O W O m 0 0�f1 O M O'-O N iff M O l o g J Z m m 1l1 N �VVF U W 7 -iUw y UO Z 2 jg Z OF m aZ� m �C pro < g0: Q Q z 8 8y 8 8 v 8 8!9 Q�o o o o Q o ��o o K <O~ K V Z z �w �tuSooB c� �Q 25`m8� �S 9° "pia WWz u5'm�d Qwaiadri�. our aD w �a• N d> ' �- fV OWF Hot, 1m NYon�N t0 N l7M mm OOOOmO�/f a-�O�IA N W�y WUW Z �f 10 07 ��8 aJ a.Z QQ�1 � ,d Z W 3Z � �y Z ppppppp p z 8 888 mm8 �p LL.(QP Ul87F�> Zy8�O O po O�N O O trp p O m ZO O o O O o o O O O 21�Oy 2 f O N 7 y Z J yu O Va' s W ^IY QED NO 'Mf aDm 1-Q co !�NN� m A C� l�l W W 1 �lsl BeoN v of N zD c� itS e� �_ �q Z y �Kw JyK Www8 Z GnD b N b 0 W 1p Z m O N O O O O N O M O N g p= C� O CWCW (MO 00 Rz' C 0 a >2 >> wy0y } � Uz Uz you a a wg yw 2 r40 W w 6~ N O w N Z w(~j ~y� `U U. '� a 68 o m ~W a Z y F O TQQQNgCjj JZ !-(w7 �I OZ~Z W~8QRP Z W --I.- a Z=m U. wWwW�� Om C 7�� j!-�W�U' (yz(y� WzW w zmwm 005 M w w W LL LL LL W W O w J }}_ �m Z O a ~ O m w O} 4 W LL"�fl695 w Jo '�' w �d wya � 9 v� m 6 rn 82 W U. (7 0 U— F W C7 O u.LL.W uLLl�U U W W w W F W W ^g� Z2—�,22 MZ w �,d Z J�J�� m�K ZZZm a �U2 iqm Zs y m�QIt It 0: J WWaFa wwmzs m e ~wWm O �T4, I JJ U W W Q V' CJ7�J1- wo OW W J 6 Nwyw WUW J W O JJ W ZI=.F O j W ZZ>Xj OOLLw~ O W HZH W F7 00� maW2a oo �} m a �� UU??�dOOa U. 0 a0 Oa G W m ca M M M Or) CM H) O 00 00 O O to O I t15 (� P P, iz W o Oo co Q H � W W 0. i > U UU c a c c m 34) 33 G a. H H F°- t°- a � o amiCO) N 2 =LU = 2 m 04 04 � � 4) Z U IL a� O N! M O CO) M C eo O I? O ° O w O LL. O co O .�. M M p z �. N c U) O N O m y O m m 0 N O L1J N p to V >, Q 1- c O O c C U c (a °� O U c E C U c U C� C C C C C O C ti O C li N W C W C W c CO C W m C W C m E _ W m v N m 0 O N co E m U —, z3 04 qCe) co Nqno 0 ¥ mqq \ - mCO . 0 � � a zn CA2D � tr- 0 0 0 / � 0 wf - - k ~ k 04 (D04 $ CN � 2 g k� 2 � m lqt 00 06� k � w � z� w S/ $ n I � § 22G � G � � ^ \ 2G � % 25 2 b� ¥ ƒ � $$ Gp § w � q & n $ mo km 04 wa k CV) m � Rm � 22 ¥ ongn � oo \ � k k / ® o o § E U S § ■ e k t $ k § 2@ 0 c 0 0 Co c k� 9 g � CL w k \ akk ts $ kk \ $ a � > 2 � @ S@i c M 'D o fE £ Cl) a Q . . m - - two c F 2 S > Z0 c � $ $ 0 $ Z > � > 777 -8i> De g « e@q � ma7c c � ■ CL � -W � « � G G e ■ 2o- $ CL�f777E ° 2k � k / � � o7 � E § U. o o � � c § c ° # 0 m w@ � � � _ o@ o= © o � - ee ■ o � ■ E mcQ _ e . ( @ E 2 E ° @ - c LL Q C 00: > m A e w ■ _ § zW @off = $ � § 2E7E@ . . . . . . . . . . . . . . 0kE7 0 wLL � 0@Ew2 � NaLL@wI Rbm = F I $ / .. Imo ~ ƒ bqD 0 cak 2 00tA000NNNd to0 ►l- Nomow M � � etNNN .- N � MNN � NN O O N 7 Z H O N CO tL') � w m o w m a N Cl) co O O � N Z jLL � U m Q Ow HLL ZQ wC0 O O � U Qm wa 0 U Z m o O0 ac 00 O •� c pp L M > � UU V U -Op O Z 5� C H N rn r- M r Co t N U fA rn - w j_ m m U _ Z C '— .0 +' C � N LL Q O 7 DI O O y p arvmaw � = u. cn QNa = 65u_ CL0 ~ w z ww Sao U N O Q J > rL. IL m W D 0 — To: Edward Schar Building Commissioner From: Brian P. Sheehan, R.S. Health Officer Date: August 1, 2003 Subject: Health Department Activity Report for the Month of July. Day Care Center/Day Care Home 2 Food Service Inspections 47 Food Service Re-inspections 16 Food Service Construction Inspections 30 Foodstore Inspections 2 Food Service Pre-opening Inspections 17 Plan Reviews 29 Complaint Inspections&Follow-up 68 Property Maintenance Inspections 79 Microwave Inspections 7 Carbon Monoxide(Commercial/Residential) 6 Radon Kit Installation&Follow-up 3 Vending Machine License Inspections 29 Mobile Vendor Licenses/Inspections 3 Swimming Pool Inspections/Re-inspections 43 Temporary Foodservice/Inspections 9 Emergency Inspections&Re-inspections 0 Assistance to Public 340 Meetings&Training: July 17,2003: Board of Health Meeting cc: Board of Health DEPARTMENT OF BUILDING AND ZONING PUBLIC SAFETY ACTIVITY REPORT JULY, 2003 IV. LITIGATION REPORT See Attached . V. CODE CONFERENCES July 17, 2003—Bill Visconti,Vapor Bus International, 1010 Johnson Drive July 22, 2003 —David Radomski, Concord Homes/Michael Fitzgerald, Otis Koglin Wilson/Chris Meier, Otis Koglin Wilson- Turnberry Condominiums July 31, 2003 —Seth Pines,Pines Development VI. PROPERTY MANAGEMENT: BUFFALO COURT: No action required. BUFFALO GROVE SHOPPES: No action required. CAMBRIDGE COMMONS: No action required. CAMBRIDGE WEST: No action required. CHASE PLAZA: No action required. COUNTRY COURT: No action required. CREEKSIDE COMMONS: No action required. DUNDEE POINT: No action required. DUNELL CENTER: No action required. THE GROVE: No action required. GROVE COURT: No action required. GROVE POINT PLAZA: No action required. HIGHLAND OAKS: No action required. PLAZA(THE): Several items remain to be corrected as noted on previous reports. The landscaping is in the process of being addressed. PLAZA VERDE: No action required. THE SHOPS AT APTAKISIC CREEK: No action required. SPOERLEIN COMMONS: No action required. STRATHMORE SHOPPING CENTER: The rear lot in the area of the dumpster is in the process of clean up. The resurfacing of the parking lot has been delayed to fall of 2003. STRATHMORE SQUARE: No action required. TOWN CENTER: The garbage dumpster was relocated to the dock area in an attempt to help control the area better. The garbage area behind the Mongolian Barbeque Restaurant was heavily soiled with grease that had leaked out of the dumpster. The manager was notified to contact the garbage refuse company to obtain a new container and to clean the area in question thoroughly. This are will be re-inspected for compliance. VILLAGE PLAZA: No action required. WOODLAND COMMONS: The parking lots are being monitored Respectfully submitted, Building Commissioner ES/jck DEPARTMENT OF BUILDING&ZONING Attachment PUBLIC SAFETY ACTIVITY REPORT JULY, 2003 LIMITED DISTRIBUTION IV. There was no Housing Court activity for the month of July, 2003. The next regularly scheduled Housing Court date is September 3, 2003 at 9:00 a.m. ENGINEERING SERVICES MONTHLY REPORT DULY,2003 Turnberry Condominiums Work continues on utilities. Noah's Landins? Work continues on drives and walks. Parkview Townhomes Work continues on water and storm relocation. Work continues on detention basin. Busch Grove Park Watermain work begins. Belmont Village Work completed on site grading. Brentwood Work continues on drives and walks. 750 Hastings Storm sewer completed. Plaza Verde Work continues on entrance curbing. Work continues on walk improvements. J Ric ar K. Kuenkler, P.E. .>.` .. Daniel J. K Village Engineer Engineering Technician G:\ENGINEER\DJKVu103.doc a �+ w Y ^1 `O �N q � rA;O F 0 0� A F 4 h y O W h o � w � x ti N w w w , V w � w y w `jrn o AQ co w � 0 w `� � a � 3 � � � y o � � � �� a�9q �E �� o 40 � � � � � � �� 4 a x o � ti v � � � � ti U �' � � � Q, 4 Board Agenda Item Submittal VIII-B Requested By: Ghida Neukirch Entered By: Ghida Neukirch Agenda Item Title: Overview of the Village's second annual Buffalo Grove Invitational Fine Art Festival. Date Submitted: Meeting Date Agenda Place Requested: Requested: Department: 08/13/2003 08/18/2003 0 Consent Agenda OVM 0 Regular Agenda 0 None Does this item Does this item include Will AV equipment be relate to another additional reference required to present item on the info separate from the this item to the agenda? Board packet? board? 0 Yes 0No 0 Yes 0No 0 Yes 0No Item Description Will this action involve an expenditure in 0 Yes 0 No funds? Additional Notes regarding Expenditures: Type the body of the cover memo here. Requests cannot be submitted if this field is blank. An overview of the Village's second annual Buffalo Grove Invitational Fine Art Festival will be provided by staff. A short power point presentation will be provided. Attached is an overview of several planning details for the art festival. The Village President and Board of Trustees have also requested that volunteers assisting with the coordination of the festival be recognized at the Board meeting. Certificates of Appreciation will be provided to volunteers. Letter-Sized Legal-Sized Ledger-Sized Odd-Sized Attached Files Attached Files Attached Files Attached Files Details2003Board.do Approval Section: Name: Date and Time: Submitted By: Pre-Approved By: Approved By: Published to Web: Buffalo Grove Invitational Fine Art Festival Planning Details Overview of Festival Art Fest Office— Unit 226 Friday set-up, 5 pm. 3whi-& Saturday and Sunday, July 26 & 27, 2003, 10:00 a.m. — 5:00 p.m. Special private preview for residents with disabilities - 9:00 a.m., Saturday. VIP reception and awards breakfast—8:00 a.m., Sunday, tent on site. I N V I T A T I O N A L VIP tour, 9:00 a.m., Sunday. Tour by Amdur staff. r,.n^*rr rr errM%s L, # of artists— 165; 56 returning artists. eSkape community party—Saturday, 5:30 pm — 8:30 pm. ✓ Jury—2/19 &2/20, 9 - 3 p.m., Highland Park C.C. Packet to artists (second week in April) Welcome letter from Village Restaurant/dining guide Shopping center guide Inspection info to food vendors Eskape brochure and flyer promoting Saturday evening program. Arts & Crafts Vendor Fee ($20 per artist). Proceeds will apply to the Art Purchase Program. Marketing ✓ Letter to Town Center businesses —week of 2/24. ✓ Spring Village newsletter ✓ Water Bill info—June and July mailing. 6/3/2003. ✓ Channel 6, News List, web site, marquee. 6/3/2003. ✓ PPI —5/15/03, 4:00 pm.; Board approved. ✓ Post cards to artists and also direct mail. ✓ Commission for Residents with Disabilities— direct mail of post cards, 6/2003. ✓ Streetscape banners ✓ Sponsors - Chicago Tribune, WBBM, Pepsi, WNUA, CLTV sponsors. ✓ LaSalle Bank— provided sponsorship to offset costs of volunteer t-shirts. Made In Illinois Art Books —free. Pick up locations —stores will be open Saturday and Sunday, festival hours. Confirmed 6/17/03. ✓ Books Again! Unit 178 ✓ Eclectic Unit 210 ✓ Keno Optical Unit 158 ✓ Piano Experts Unit 132 ✓ Shoes for the Soul Unit 210 Art Festival merchandise—will be sold by the Arts Commission • Fans. • T-shirts. • Bottled water (Pepsi product-sponsor). 1 Overflow Parking • Target • Congregation Beth Am • BG Post Office • Lou Malnati's ✓ Trolley between Target and the Town Center. Transportation ✓ CRD program — shuttle residents with disabilities and guests. 4 seat golf cart. Entertainment ✓ Cirrus Falcon — main entertainment ✓ Clifton Demarks —jazz ✓ Encore, BG Park District, 2-3 pm, Saturday. ✓ BG Symphonic Band —Village, 12-2 pm, Sunday. "Eskape with the Artists" Saturday night - Co-chairs Sandy Sklansky & Laura Ander Pizza, pasta buffet dinner, soft drinks, dessert. $10 artist cost with ID; $12 general admittance. Food Vendors 1) Mediterranean Cuisine (pita sandwiches, gyros, chix breast, brats, hot dogs, gourmet pretzels). 2) Susie's Funnel Cake (plus chix sticks, nachos) 3) Great Plaines - kettle corn 4) Almonds & More - (pecans, cashews, etc). 5) Maui Wow- smoothies 6) Eatery - lemonade carts ✓ All of the restaurants on site (Giordano's, Grill Works, Jimmy John's, Cold Stone, and India House) were highlighted in the festival program book. ✓ The Village coordinated a lunch and dessert delivery service for the artists; Grill Works and Cold Stone Creamery provided food service to interested artists for a set cost. Security Police, Fire, & ESDA 2 Board Agenda Item Submittal XI-A Requested By: William H Brimm Entered By: William H Brimm Agenda Item Title: Annual Report of Condition-Firefighter's Pension Fund-Tax Year 2003 Date Submitted: Meeting Date Agenda Place Requested: Requested: Department: Consent Agenda 08/05/2003 08/18/2003 0 Regular Agenda Finance&GS 0 None Does this item Does this item include Will AV equipment be relate to another additional reference required to present item on the info separate from the this item to the agenda? Board packet? board? 0 Yes 0No 0 Yes 0No 0 Yes 0No Item Description Will this action involve an expenditure in 0 Yes 0 NO funds? Additional Notes regarding Expenditures: Type the body of the cover memo here. Requests cannot be submitted if this field is blank. Illinois Compiled Statutes, Chapter 40, Section 5/4-134 require that the Fire Pension Fund Board of Trustees submit a report prior to the adoption of the Village's 2003 property tax levy regarding its fiscal condition. This Report of Condition has been prepared on behalf of the Village of Buffalo Grove Firefighter's Pension Fund Board of Trustees by William H. Brimm, staff liaison. The estimates provide for all sources and uses of funds as required by the Illinois Pension Code. In this Report of Condition, the Board is required to certify to the Village Board the following: 1. Assets in the custody of the Board at the time of Report preparation and their current market value at the end of the most recent fiscal year (April 30, 2003); 2. The estimated receipts during the next succeeding fiscal year from deductions from the salaries or wages of firefighters, and from all other sources; and 3. The estimated amount necessary during said fiscal year to meet the annual actuarial requirements of the Fund as provided in Section 5/4-118 and 5/4-120; and 4. The total net income received from the investment of assets, compared to such income received during the preceding fiscal year (period ended April 30, 2002). Each of the above reporting requirements shall be noted individually for presentation purposes. Letter-Sized Legal-Sized Ledger-Sized Odd-Sized Attached Files Attached Files Attached Files Attached Files fpension.pdf Approval Section: Name: Date and Time: Submitted By: Pre-Approved By: Approved By: Published to Web: TO: President and Board of Trustees FROM: Buffalo Grove Firefighter's Pension Fund DATE: August 1,2003 SUBJECT: Annual Report of Condition Illinois Compiled Statutes,Chapter 40,Section 5/4-134 require that the Fire Pension Fund Board of Trustees submit a report prior to the adoption of the Village's 2003 property tax levy regarding it's fiscal condition. This Report of Condition has been prepared on behalf of the Village of Buffalo Grove Firefighter's Pension Fund Board of Trustees by William H. Brimm,staff liaison.The estimates provide for all sources and uses of funds as required by the Illinois Pension Code. In this Report of Condition,the Board is required to certify to the Village Board the following: 1. Assets in the custody of the Board at the time of Report preparation and their current market value at the end of the most recent fiscal year(April 30,2003); 2. The estimated receipts during the next succeeding fiscal year from deductions from the salaries or wages of firefighters,and from all other sources;and 3. The estimated amount necessary during said fiscal year to meet the annual actuarial requirements of the Fund as provided in Section 5/4-118 and 5/4-120;and 4. The total net income received from the investment of assets,compared to such income received during the preceding fiscal year(period ended April 30,2002). Each of the above reporting requirements shall be noted individually for presentation purposes. Assets in the Custody of the Board:As of April 30,2003,the Village of Buffalo Grove Firefighter's Pension Fund had in its depository custody from the accumulation of property taxes,interest income,net gains on security transactions,Corporate Personal Property Replacement Taxes,and salary deductions,less any payments for operating expenditures and pension obligations,the following assets stated at book value: Savings Account/Cash on Hand $ 22,344.91 Illinois Funds 2,379,605.67 Illinois Metropolitan Investment Trust 527,096.22 Certificates of Deposit 4,637,000.00 Annuity Contract-(Equity) 89,525.93 Mutual Funds-Equities 1,678,098.08 Reserve Money Market 60,366.20 U.S.Treasury Zero Coupon Bonds/Notes 6,164,000.00 Total Asset Value-April 30,2003 $15,558,037.01 The amount of unearned discount on securities purchased,as of April 30,2002 was$2,242,165.21,which equates to a net book value of$13,315,871.80($12,362,106.67 as of April 30,2002). Market value as of April 30,2003 is estimated at $13,593,071.63 a variance of 2.08%from book value. Discount is amortized annually following generally accepted accounting principals utilizing the interest rate method of amortization to maturity. The Fund continues to participate in holding equities with recurring purchases of either equity annuities or mutual fund positions as permitted by statute;periodic additional investments will continue to be made into these programs. Gains or losses will be accounted for as gains or losses in conformance with generally accepted accounting principles as they apply to equity investing. Cash and investments are maintained on behalf of the Fund by the Village as part of its overall financial accounting system, this Fund being considered a Non-Expendable Pension Trust Fund. Additional deposits will continue to be made into the Illinois Funds with eventual transfer to higher earning,authorized investment programs. The Pension Board strives to maintain the least possible level of low interest-bearing funds,those being savings, in order to maximize the earnings potential of the portfolio. The book value shown above for all assets as of the Report date compare to an April 30,2002 value of$15,057,296.05, an increase of$500,740.96 or 3.33% Estimated Receipts From Salaries and Wages: Chapter 40, Section 5/4-118.1 establishes the basis for salary and wage contributions deducted from member firefighter's eligible earnings. The basic payroll deduction,is 6.955%and salary and wages are to include annual salary plus any longevity pay;an additional 1.50%deduction from the same base shall also be made to help defray the mandatory pension increases as provided for within Section 5/4-109.1. The estimated wage base for FY 2003-2004 is $4,266,950 and is consistent with the salary estimation for those firefighter/ paramedics that are members of the Fund.Based on the estimated salaries and longevity pay,extended by both requirements established within Article 4 of the Pension Code,the following should be received,at a minimum,from payroll deductions in FY 2003-2004: Basic Contribution @ 6.955% $296,766.00 Automatic Pension Increase Fund @ 1.50% 64,004.00 Total $360,770.00 This level of personal contributions assumes no further legislative changes to the formula for member pension plan deductions from eligible wages and salary. Estimated Receipts From PrgpgM Taxes:The tax levy established by the Village should be sufficient to cover the following requirements of Section 5/4-118,which when added to the deductions from salaries and wages of members,along with receipts from all other sources,will equal a sum sufficient to meet the annual actuarial requirements of the Fund. The annual requirements to be provided by such tax levy are equal to: 1. The normal actuarial cost requirements of the Fund,or 17.5%of the salaries and wages to be paid to firefighters for the year involved,whichever is greater,plus 2. The amount necessary to provide for the amortization of any unfunded actuarial liabilities as provided for in Section 5/4-118. The normal cost is the cost assigned to the Fund for the current year,compiled as a level percentage of pay,such that the accumulated value at the expected retirement date for any individual is sufficient to pay benefits due. Total normal cost is determined by an actuarial study of the membership and takes into account service considerations such as payroll deductions from members,member salaries and wages,earnings on investments,length of service and current age.Additionally,factors such as attained age at time of disability or retirement,sex,annual salary or pension,and completed years of service of each individual participant as of the date of the valuation balance sheet are used in calculating the actuarial liabilities of the Fund. The unfunded actuarial liability equals the difference between current net assets and accrued liabilities due to members. If negative,the liability will be amortized over a 40-year period beginning July 1, 1993. The amortization of any liability in any one year shall not be less than the annual amount required to amortize said liability, including interest,through equal annual payments over the number of years remaining in the amortization period. Level dollar amount methodology is employed which is more conservative(provides a higher level of annual funding)and attempts to reduce this liability sooner when compared to the level percentage of payroll method,which is an acceptable,alternative funding approach. Eventually,Fund reserves accumulated shall be equal to the estimated total actuarial requirements of the Fund. The Village continues to levy property taxes utilizing values provided by its independent actuary,Hewitt Associates.The Village is permitted to retain an independent,enrolled actuary in order to determine the required tax levy based on the requirements of Section 5/4-118. For 2002(collected in FY 2003-2004)the Village utilized an alternative levy recommended by Hewitt Associates which totaled$896,876. That levy was based on Fund performance,characteristics and statutory obligations rather than statewide actuarial applied methodology. The Department of Insurance did provide a comparative levy recommendation for 2002 equal to$925,495. The final levy will be extended and collected in FY 2003-2004. The components of the levy request are as follows: To provide for the employer'normal actuarial cost $652,041 requirements of the Fund To amortize the unfunded actuarial liability of 244,835 $3,043,153 as contemplated by Section 5/4-118 Total Levy $896,876 The final Actuarial Report as of April 30,2001,upon which the levy is based,is attached to this memo.Please note the content of the Report from Hewitt and the methodology followed. It should be noted that actuarial assumptions were last modified beginning in 1993 for that and later year levies due to changes in benefits enacted into law,combined with the effects of new actuarial information that has become the basis for applicable statistical programming. Statewide values are as follows: Funding Method Used: Entry Age Normal Cost Interest Rate Assumption: 7.00% Mortality Rate Assumption: 1971 Group Annuity Table Disability Assumption: Experience Tables Salary Progression: 5.5%Annually Status of Social Security: None Amortization of Unfunded Actuarial July 1, 1993 Liability-40 Years From: Where the local Fund deviates from the above values are in interest returns where 7.5%is assumed and in salary progression where 5.00%is considered valid over the long-term perspective of the Fund. The Fund Board is on record to reduce any accrued actuarial liability as quickly as possible. While the State followed a reduction method known as the level percentage of payroll method,the Village will apply the level dollar amount process. It is the opinion of the actuary that using a level percentage of pay to amortize an unfunded liability would significantly lower the funded ratio of any particular pension plan over time.The level dollar amortization process is a conservative approach that will limit reductions in an overall fimding ratio. It is anticipated,based on historical collection efforts,that approximately 100%of any tax levy will be collected and credited against the requirements of the Fund. This would equal nearly$896,876 in collections in FY 2003-2004 based on the Hewitt levy alternative for the tax year 2002 levy. Estimated Receipts From Corporate Personal Property Replacement Taxes: The Fund will receive to its credit approximately$4,900.00 in distribution of the replacement tax in FY 2003-2004. Estimated Receipts From Interest Earnings:Interest earnings assumptions take into consideration the holding of the current portfolio until maturity except for balances in money market or other near-cash investments that are managed based on interest rate trends, assumptions and pension board action. It is further assumed that: (1) any cash gain or loss from investment trading will not be calculated for this Report in that such gains or losses cannot be readily quantified,(2)the amortization of remaining net discount on securities held to be taken in FY 2003-2004 will not be reflected as an interest receipt and(3)any unrealized gains from the Fund's equity position will not be realized as cash receipts in FY 2003-2004. The interest estimates reflect only direct cash earnings from investments.Interest earnings are rolled over as quickly as possible in order to maximize the earnings potential of each cash receipt. Interest earnings will continue to increase as greater balances become available and opportunities for investment broaden although the majority of investments are not expected to generate cash income. It is estimated that approximately$387,600 in interest income will be earned during FY 2003-2004 depending on both the movement of interest rates and the mix of investments utilized by the Fund based on the nature of the portfolio in place. Amount RetLuired to Pay All Pensions and Obligations:Based on the current and assumed service profile of the member firefighter/paramedics,there will be amounts necessary in FY 2003-2004 for the payment of retirement and other pension plan obligations. The amount estimated for payment in FY 2003-2004 for service related disability benefits are approximately$79,600. It is assumed that there will not be any further service disabilities or retirements in FY 2003-2004. Other costs anticipated are for possible separation refunds,investment management fees,seminar and training sessions,plus the annual registration payment to the Illinois Department of Insurance. These amounts will be minimal and approximate $40,000. Amount Enuired to Meet Annual Requirements of Fund:Section 5/4-120 requires that a reserve be established to insure the payment of all obligations incurred under the Article. The reserve,identified as an accrued liability,to be accumulated shall be equal to the estimated actuarial requirements of the Fund.As of 4/30/01,the amount required to be provided totaled $14,324,444 with net present assets totaling$11,281,291 for an unfunded actuarial liability of$3,043,153. The liability is the unfunded reserve requirement of 5/4-120 as of April 30, 2001 and is the value of liabilities due active and retired/disabled participants less net present assets.The Fund is required to amortize this liability over a 40-year period ending June 30,2033 under current pension code law. The 2002 tax levy requirement(for amortization of liability) is $244,835, or 27.30% of the overall levy as contemplated under Section 5/4-120 in order to clear the obligation on a programmatic basis. The unfunded liability declined from$3,190,401 in 2000 to the current$3,043,153. In addition to providing for the amortization of the unfunded accrued liability,the annual Normal Cost is to be provided. The normal cost is that assigned to the current year as a level percentage of pay,such that the accumulated value at the expected retirement date of the members of the group is sufficient to provide expected retirement benefits. For 2003,that amount is equal to$652,041 compared to$608,544 necessary in calendar 2002. For purposes of disclosure,it should be noted that the level of funding based on the satisfaction of the Fund's Pension Benefit Obligation has improved from 74.4%to 78.8%. The Pension Benefit Obligation is a standardized disclosure is intended to measure the present value of pension benefits to be credited compared to the net assets available for the payment of benefits. This value has been calculated as of April 30,2001 and is a component of the recommended levy for tax year 2002,collected in FY 2003-2004. Income From Investment of Assets:A comparison is to be provided on the total net income received from the investment of Fund assets for the most recent completed fiscal period as compared to the preceding fiscal period. For FY 2002-2003, the following was earned: Investment Income/Discount Amortization $752,442.72 Unrealized Loss on Equity Investments 582,884.31 Total Income $ 169,558.41 Pot FY 2001-2002,the following was earned: Investment Income/Discount Amortization $572,761.27 Unrealized Gains on Equity Investments 146,139.24) Total Income $718,900.51 The overall change was a decrease of$549,342.10 on an inter-period basis. Not reflected within net income received from investment activity is the book entry required to"mark-to-market"fixed income securities. The estimated market value of fixed income securities exceeds book value by$229,94227(as of April 30,2002,book exceeding market by$28,268.35). The intent of the Fund to hold all securities to maturity unless there are compelling reasons to sell into a position. Book-to- market variances should continue to remain positive as market conditions moderate and as securities approach final maturity. A requirement is placed upon the Village to have an independent certified public accountant verify the current market value of the assets of the Fund. That review is currently being undertaken as part of the Village's FY 2001-2002 audit process and market/book value comparisons will be provided as part of the comprehensive annual financial report narrative. Conclusion:The preparation and submission of this Annual Report of Condition satisfies the requirements of Section 5/4- 134 of the Illinois Pension Code and conforms to assumptions and estimates previously used to calculate receipt and earnings estimates. William H.Brimm Board Agenda Item Submittal XI-B Requested By: William H Brimm Entered By: William H Brimm Agenda Item Title: Annual Report of Condition-Police Pension Fund-Tax Year 2003 Date Submitted: Meeting Date Agenda Place Requested: Requested: Department: Consent Agenda 08/05/2003 08/18/2003 0 Regular Agenda Finance&GS 0 None Does this item Does this item include Will AV equipment be relate to another additional reference required to present item on the info separate from the this item to the agenda? Board packet? board? 0 Yes 0No 0 Yes 0No 0 Yes 0No Item Description Will this action involve an expenditure in 0 Yes 0 NO funds? Additional Notes regarding Expenditures: Type the body of the cover memo here. Requests cannot be submitted if this field is blank. Illinois Compiled Statutes, Chapter 40, Section 5/3-143 require that the Police Pension Fund Board of Trustees submit a report prior to the adoption of the Village's 2003 property tax levy regarding it's fiscal condition. This Report of Condition has been prepared on behalf of the Village of Buffalo Grove Police Pension Fund Board of Trustees by William H. Brimm, staff liaison. The estimates provide for all sources and uses of funds as required by the Illinois Pension Code. In this Report of Condition, the Board is required to certify to the Village Board the following: 1. Assets in the custody of the Board at the end of the fiscal year (April 30, 2003); 2. The estimated receipts during the next succeeding fiscal year from deductions from the salaries of police officers, and from all other sources; 3. The estimated amount required during the next succeeding fiscal year to (a) pay pensions and other obligations provided in the Code (Chapter 40) and (b) to meet the annual requirements of the Fund as provided in Section 5/3-125 and 5/3-127; and 4. The total net income received from investment of assets, compared to such income received during the preceding fiscal year (period ended April 30, 2002). Each of the above reporting requirements shall be noted individually for presentation purposes. Letter-Sized Legal-Sized Ledger-Sized Odd-Sized Attached Files Attached Files Attached Files Attached Files ppension.pdf Approval Section: Name: Date and Time: Submitted By: Pre-Approved By: Approved By: Published to Web: TO: President and Board of Trustees FROM: Buffalo Grove Police Pension Fund DATE: August 1,2003 SUBJECT: Annual Report of Condition Illinois Compiled Statutes,Chapter 40,Section 5/3-143 require that the Police Pension Fund Board of Trustees submit a report prior to the adoption of the Village's 2003 property tax levy regarding its fiscal condition. This Report of Condition has been prepared on behalf of the Village of Buffalo Grove Police Pension Fund Board of Trustees by William H.Brimm, staff liaison. The estimates provide for all sources and uses of funds as required by the Illinois Pension Code. In this Report of Condition,the Board is required to certify to the Village Board the following: 1. Assets in the custody of the Board at the end of the fiscal year(April 30,2003); 2. The estimated receipts during the next succeeding fiscal year from deductions from the salaries of police officers,and from all other sources; 3. The estimated amount required during the next succeeding fiscal year to(a) pay pensions and other obligations provided in the Code(Chapter 40)and(b)to meet the annual requirements of the Fund as provided in Section 5/3-125 and 5/3-127;and 4. The total net income received from investment of assets,compared to such income received during the preceding fiscal year(period ended April 30,2002). Each of the above reporting requirements shall be noted individually for presentation purposes. Assets in the Custody of the Board:As of April 30,2003,the Village of Buffalo Grove Police Pension Fund had in ifs custody from the accumulation of property taxes,interest income,net gains on security transactions,Corporate Personal Property Replacement Taxes,and salary deductions,less payments for operating expenditures and pension obligations,the following assets: Savings/Cash on Hand $ 48,663.49 Insurance Annuity Contracts(Equities) 1,147,823.64 Mutual Fund Equity Investment 2,419,524.59 Reserve Money Market 33.52 U.S.Treasury Bonds-Zero Coupon/Notes 20,000,000.00 Illinois Funds 2,479,651.17 U.S.Government-National Mortgage Assn. 11,383.29 Total Asset Value-April 30,2002 $26,107,079.07 The amount of unearned discount on securities purchased,as of April 30,2003 was$4,169,831.18,which equates to net investments of$21,937,248.52($20,700,731.49 as of April 30,2002). Market value as of April 30,2003 is estimated at $23,731,708.39,a variance of 8.18%from the net book value of Fund investments. Discount is amortized annually following generally accepted accounting principals utilizing the interest rate method of amortization to maturity. The Fund continues to participate in holding equities with recurring purchases of either equity annuities or mutual fund positions as permitted by statute;periodic additional investments will continue to be made into these programs.Gains or losses will be accounted for in conformance with generally accepted accounting principles as they apply to equity investing. Cash and investments are maintained on behalf of the Fund by the Village as part of its overall financial accounting system, this Fund being considered a Non-Expendable Pension Trust Fund. Additional deposits will continue to be made into the Illinois Funds with eventual transfer to higher earning,authorized investment programs. The Pension Board strives to maintain the least possible level of low interest-bearing funds,those being savings, in order to maximize the earnings potential of the portfolio. The total par value shown above for all assets as of the Report date compares to an April 30,2002 value of$25,817,412.38, an increase of$289,666.69 or 1.12%. Estimated Receipts From Salaries and Wages:Chapter 40,Section 5/3-125.1 establishes the basis for salary and wage contributions deducted from member police officers'eligible earnings. The basic deduction is 9.91%of salary and wages, such salary and wages to include annual salary plus any longevity pay. The estimated wage base for FY 2003-2004 is $5,031,430 and is consistent with the salary estimation for those sworn police officers that are members of the Fund. Based on the estimated salaries and longevity pay,$498,615 should be received,at a minimum,from the basic payroll deduction for contributions during FY 2003-2004. This level of personal contributions assumes no further legislative changes to the formula for member pension plan deductions from eligible wages and salary. Estimated Receipts From Property Taxes:The tax levy established by the Village Board should be sufficient to cover the following requirements of Section 5/3-125,which when added to the deductions from salaries and wages of members,along with receipts from all other sources,will equal a sum sufficient to meet the annual requirements of the Fund. The annual requirements to be provided by such tax levy are equal to: 1. The normal actuarial cost requirements of the Fund for the year involved,plus 2. The amount necessary to provide for the amortization of any unfunded actuarial liabilities as provided for in Section 5/3-127. The normal cost is the cost to the Fund assigned to the current year,compiled as a level percentage of pay,such that the accumulated value at the expected retirement date of any individual is sufficient to pay benefits due. Total normal cost as determined by the actuarial study of the membership and takes into account service considerations such as payroll deductions from members,member salaries and wages,earnings on investments,length of service and current age.Additionally,factors such as attained age at time of disability or retirement,sex,annual salary or pension,and completed years of service of each individual participant as of the date of the valuation balance sheet are used in calculating the actuarial liabilities of the Fund. The unfunded actuarial liability equals the difference between current assets and accrued liabilities due to members.If negative,the liability will be amortized over a 40-year period beginning July 1, 1993. The amortization of any liability in any one-year shall not be less than the annual amount required to amortize said liability, including interest,through equal annual payments over the number of years remaining in the amortization period. Level dollar amount methodology, is employed which is more conservative(provides a higher level of annual funding) and attempts to reduce this liability sooner when compared to the level percentage of payroll method,which is an acceptable alternative funding approach. Eventually, Fund reserves accumulated shall be equal to the estimated total actuarial requirements of the Fund. The Village continues to levy property taxes by utilizing values provided by its independent actuary,Hewitt Associates.The Village is permitted to retain an independent,enrolled actuary in order to determine the required tax levy based on the requirements of Section 5/3-125. For 2002(collected in FY 2003-2004)the Village utilized an alternative levy recommended by Hewitt Associates which totaled$793,475. That levy was based on Fund performance,characteristics and statutory obligations rather than statewide actuarial applied methodology. The Department of Insurance did provide a comparative levy recommendation for 2002 equal to$881,881. The final levy will be extended and collected in FY 2003-2004. The components of the levy request are as follows: To provide for the employer'normal actuarial cost $487,974 requirements of the Fund To amortize the unfunded actuarial liability of 305,501 $6,494,032 as contemplated by Section 5/3-127 Total Levy $793,475 The final Actuarial Report as of April 30,2001,upon which the levy is based,is attached to this memo. Please note the content of the Report from Hewitt and the methodology followed. It should be noted that actuarial assumptions were last modified beginning in 1993 for that and later year levies due to changes in benefits enacted into law,combined with the effects of new actuarial information that has become the basis for new statistical programming. Statewide values are as follows: Funding Method Used: Entry Age Normal Cost Interest Rate Assumption: 7.00% Mortality Rate Assumption: 1971 Group Annuity Table Disability Assumption: Experience Tables Salary Progression: 5.5%Annually Status of Social Security: None Amortization of Unfunded Actuarial July 1, 1993 Liability-40 Years From: Where the local Fund deviates from the above values are in interest returns where 7.5%is assumed and in salary progression where 5.00%is considered valid over the long-term perspective of the Fund. The Fund Board is on record to reduce any accrued actuarial liability as quickly as possible. While the State followed a reduction method known as the level percentage of payroll method,the Village will apply the level dollar amount process. It is the opinion of the actuary that by using a level percentage of pay to amortize an unfunded liability would significantly lower the funded ratio of any particular pension plan over time.The level dollar amortization process is a conservative approach that will limit reductions in an overall funding ratio. It is anticipated,based on historical collection efforts,that approximately 100%of any tax levy will be collected and credited against the requirements of the Fund. This would equal nearly$793,475 in collections in FY 2003-2004 based on the Hewitt levy alternative for the tax year 2002 levy. Estimated Receipts From Corporate Personal Property Replacement Taxes: The Fund will receive to it's credit approximately$4,300.00 in distribution of the replacement tax in FY 2003-2004. Estimated Receipts From Interest Earnings:Interest earnings assumptions take into consideration the holding of the current portfolio until maturity except for balances in money market or other near-cash investments that are managed based on interest rate trends, assumptions and pension board action. It is further assumed that: (1) any cash gain or loss from investment trading will not be calculated for this Report in that such gains or losses cannot be readily quantified,(2)the amortization of remaining net discount on securities held to be taken in FY 2003-2004 will not be reflected as an interest receipt and(3)any unrealized gains from the Fund's equity position will not be realized as cash receipts in FY 2003-2004. The interest estimates reflect only direct cash earnings from investments.Interest earnings will be rolled over as quickly as possible in order to maximize the earnings potential of each cash receipt. Interest earnings will continue to increase as greater balances become available and opportunities for investment broaden although the majority of investments are not expected to generate cash income. It is estimated that approximately$101,700 in interest income will be earned during FY 2003-2004 depending on both the movement of interest rates and the mix of investments utilized by the Fund based on the nature of the portfolio in place. Amount Required to Pay All Pensions and Obligations:Based on the current and assumed service profile of the member police officers,there will be amounts necessary in FY 2003-2004 for the payment of retirement and other pension plan obligations. There will also be current members eligible for a service-related pension having reached 20-years of credible service but at this time have not made decisions relative to employment continuation although some retirements can be anticipated. The estimated FY 2003-2004 retirement benefits payments are$710,560. In addition,there will be payments for service-related disabilities in FY 2003-2004 estimated at$37,585. Other costs anticipated are for possible separation refunds,investment management fees,seminar and training costs plus the annual registration payment to the Illinois Department of Insurance. These amounts,minimal relative and approximate$50,000. Amount Required to Meet Annual Requirements of Fund Section 5/3-127 requires that a reserve be established to insure the payment of all obligations incurred under the Article. The reserve,identified as an accrued liability,to be accumulated shall be equal to the estimated actuarial requirements of the Fund.As of 4/30/01,the amount required to be provided totaled $26,771,281 with net present assets totaling$20,277,249 for an unfunded actuarial liability of$6,494,032. The liability is the unfunded reserve requirement of 5/3-127 as of April 30, 2001 and is the value of liabilities due active and retired/disabled participants less the net present assets. The Fund is required to amortize this liability over a 40-year period ending June 30,2033 under current pension code law. The 2002 tax levy requirement(for amortization of liability) is $305,501 or 38.50% of the proposed levy as contemplated by Section 5/3-127 in order to clear the obligation on a programmatic basis. The unfunded liability increased by$2,513,108 as posted in 2000 to the current$6,494,032. In addition to providing for the amortization of the unfunded accrued liability,the annual Normal Cost is to be provided. The normal cost is that assigned to the current year as a level percentage of pay,such that the accumulated value at the expected retirement date of the members of the group is sufficient to provide expected retirement benefits. For 2003,that amount is equal to$487,974 compared to$536,680 necessary in calendar 2002. For purposes of disclosure,it should be noted that the level of funding based on the satisfaction of the Fund's Pension Benefit Obligation has increased from 82.8%to 83.1%. The Pension Benefit Obligation is a standardized disclosure and is intended to measure the present value of pension benefits to be credited compared to the net assets available for the payment of benefits. This value has been calculated as of April 30,2001 and is a component of the recommended levy for tax year 2002,collected in FY 2003-2004. Income From Investment of Assets:A comparison is to be provided on the total net income received from the investment of Fund assets for the most recent completed fiscal period as compared to the preceding fiscal period. For FY 2002-2003, the following was earned: Investment Income/Discount Amortization $ 316,228.96 Total Income $ 316,228.96 For FY 2001-2002,the following was earned: Investment Income/Discount Amortization $1,004,447.46 Unrealized Loss on Equity Investments 306,683.80 Total Income $ 697,763.66 The overall change was an decrease of$381,534.70 on an inter-period basis.Not reflected within net income received from investment activity is the book entry required to "mark-to-market" fixed income securities. The market value of fixed income securities exceeds the estimated book value by$1,995,058.52. It is the intent of the Fund to hold all securities to maturity unless there are compelling reasons to sell into a position. Book-to-market variances should continue to remain positive as market conditions moderate and as securities approach final maturity. A requirement is placed upon the Village to have an independent certified public accountant verify the current market value of the assets of the Fund. That review is currently being undertaken as part of the Village's FY 2002-2003 audit process and market/book value comparisons will be provided as part of the comprehensive annual financial report narrative. Conclusion:The preparation and submission of this Annual Report of Condition satisfies the requirements of Section 5/3- 143 of the Illinois Pension Code and conforms to assumptions and estimates previously used to calculate receipt and earnings estimates. William H.Brimm Board Agenda Item Submittal XI-C Requested By: Robert B Giddens Entered By: Robert B Giddens Agenda Item Title: Authorization to Purchase Microsoft Office XP Standard and Windows XP Operating System using the State of Illinois Purchasing Contract#E901359 Date Submitted: Meeting Date Agenda Place Requested: Requested: Department: 08/08/2003 08/18/2003 � Consent Agenda OVM 0 Regular Agenda 0 None Does this item Does this item include Will AV equipment be relate to another additional reference required to present item on the info separate from the this item to the agenda? Board packet? board? 0 Yes 0No 0 Yes 0No 0 Yes 0No Item Description Will this action involve an expenditure in 0 Yes 0 No Yes 0 No funds? Is this a budgeted item.? Projected total budget impact: $67,266 Additional Notes regarding Expenditures: This update is a budgeted expense which will make our PC operating systems more compatible with software advancements over the past few years. Type the body of the cover memo here. Requests cannot be submitted if this field is blank. Due to technical and software advances over the past few years, we are now in need of upgrading our Personal Computer Operating Systems and Office suite. This upgrade is primarily due to the fact that software that we order no longer works with our current operating system of Windows 98. In 1998, we standardized on Microsoft Windows 98 and Office 97. At the time this was a very good solution for the Village. However, five years later as technology changes, we need to re-establish our standards to take advantage of current efficiencies. The funding for this upgrade has been anticipated. It is a budgeted expense and is available in the MIS Computer replacement fund. Staff is requesting to purchase this software using the State of Illinois Purchasing program contract # E901359 (See attached contract) which is held by ASAP Software (a Buffalo Grove business) . In addition, to verify that they provided the most competitive costs, prices were requested from three other vendors of the same software as noted below: Software ASAP CDW Spectrum Software Office XP Standard for Windows $250.00 $323.60 $216.00 Windows XP Operating System $205.00 $160.96 $120.33 In order to be software compliant, we are requesting the purchase of 200 copies of both the operating system and the office software which will put our investment as follows: ASAP Software Office XP Standard for Windows $43,200.00 Windows XP Operating System $24,066.00 Total $67,266.00 Summary: Authorization to purchase from the State of Illinois contract 200 copies of Office XP Standard and 200 copies of Windows XP Operating System for a total investment of$67,266.00 Letter-Sized Legal-Sized Ledger-Sized Odd-Sized Attached Files Attached Files Attached Files Attached Files Ll ASAP Contract.pdi Approval Section: Name: Date and Time: Submitted By: Pre-Approved By: Approved By: Published to Web: Select Agreement Number NOT FOR USE WITH THE MICROSOFT BUSINESS AGREEMENT MICROSOFr STATE AND LOCAL GOVERNMENT SELECT AGREEMENT This MICROSOFT STATE AND LOCAL GOVERNMENT SELECT AGREEMENT is entered into between the following entities as of the effective date identified below.If different from the main contact information,any notices must be addressed to the contact and locations outlined in the notices section below. We will notify you in writing if our address information changes.You must notify us in writing if your address changes. Custo r am Name and address of contracting Microsoft affiliate d L O i`i o S MSLI,GP Street Address and/or post office box Street Address and/or post office box 6100 Neil Road / eyso h Suite 210 City and State/Provinc City n State/Province `s sL Reno,NV Coun and P ode Country and Postal Code a 5 USA 89511-1137 ntact'Name Account Manager Name,Location,and E-mail Address: i- ' Phone Number Phone Number a 6 775-823-5600 Fax Number Fax Number _ ._ 775-826-7287 vA I Email Address Email Address SelquestQa microsoft.com For the Att of: For the Attention of: Dept.551,Volume Licensing Customer Notices Information(if different from above) The agreement and attached documents should be sent to the above address for approval and processing. Customer Name All NOTICES should have Copy To: Microsoft Corporation,Law and Corporate Affairs Street Address and/or post office box One Microsoft Way City and State/Province Redmond,WA Country and Postal Code USA 98052 Contact Name Phone Number Fax Number 425-936-7329 Email Address Microsoft.com For the Attention of: For the Attention of: Volume Licensing Attome iA4 Microsoft State and Local Government Select Agreement Cover Page Page 1 of 10 (MSLI)v.5.1 (North American)November 20,2000 This agreement consists of(1)this cover page,(2)the License Purchase Forecast Form,(3)the attached terms and conditions,(4)the Product List, (5)the product use rights applicable to products licensed under this agroement,and(6)any enrollment entered into under this agreement By signing below,you represent that the information you provide on each of the attached forms is accurate. Nam of Cuftner / Name): Name of contncdag Microsoft affiliate: O T �� MSI'I,GP B B (Signature) (Signature) Name: '4A Name: (Printed) Title: Title: (Printed) Effective Date: MiamoJt State and Local Government Select Agreement Cover Page Page 2 of 10 (MSLI)v.S.1 (North American)November 20,2000 LICENSE PURCHASE FORECAST FORM Part 1• Select Price Level/Forecast DWL7nation• In order to determine your initial Select price level,you must select one of the options described below. Note:when we refer to Enterprise Enrollment,we mean either an Enterprise Enrollment or an Enterprise Select Agreement. If neither you nor an affiliate is party to an existing Enterprise Enrollment (nor is entering into an Enterprise Enrollment concurrently with this agreement),then you must use Option 1. Under Option 1,you must provide a good faith forecast of the number of points you will acquire during the term of this agreement. Your forecasted purchases will be checked against your actual purchases each year and your pricing may be adjusted going forward to account for any discrepancy. If you or an affiliate is party to an existing Enterprise Enrollment(or is entering into an Enterprise Enrollment concurrently with this agreement),then you may use Option I or Option 2. If you choose to use Option 2,then for all enterprise products covered by the Enterprise Enrollment you will use the desktop count to establish your Select price level for corresponding product pools rather than a forecast. You must still provide a forecast for any pools you choose (in Option 2, section 3) which are not covered by the Enterprise Enrollment. The price levels for the pools covered by the Enterprise Enrollment will not be adjusted during the term of the Enterprise Enrollment,but price levels based on your forecast may be adjusted based on actual purchases each year. You may only check one of the below options. Option 1. You must use this option if neither you nor an affiliate is party to an existing Enterprise Enrollment(nor is entering into an Enterprise Enrollment concurrently with this agreement). You orecast that during the term of this agreement you and your affiliates will acquire at least the number of points circled below from the corresponding product pool. You do not need to acquire products from all pools. Each product is assigned the number of points specified in the Product List. Minimum Points for Price Application Pool System Pool Server Pool Level (Circle one if applicable) (Circle one if applicable) (Circle one if applicable) A 1,000 A A A B 8,000 B B B C 20,000 C © C D 50,000 ) D If+ou have selected OL&n 1 you may proceed to Part L"Un-front Payment ODtiod' Option 2. You mgy use this option if either you or an affiliate is party to an existing Enterprise Enrollment(or is entering into an Enterprise Enrollment concurrently with this agreement). Please enter the Enterprise Enrollment information below. (If you or an affiliate is entering into an Enterprise Enrollment concurrently with this agreement, we will assign the number.) [Please Note: If you (or your affiliates)are party to more than one Enterprise Enrollment, you may only identify and receive credit for your purchases under a single Enterprise Enrollment.] Com n Name Enterprise Enrollment Agreement Number Expiration Date Please fill in the appropriate boxes in Section I below to indicate the enterprise products covered by the Enterprise Enrollment and indicate the qualified desktop count. For those pools applicable to the enterprise products covered by the Enterprise Enrollment, please use the table in Section 2 below to detertine the appropriate-corresponding Select price level for that product pool. You must provide a forecast in Section 3 below for purchases in all other pools not included in the above referenced Enterprise Enrollment and these forecasted pools may receive a price level adjustment during the term of this agreement. Microsoft State and Local Government Select Agreement Cover Page Page 3 of 10 (MSLI)v.5.1 (North American)November 20,2000 LICENSE PURCHASE FORECAST FORM Section 1: Use this chart to determine the applicable Select product pool(s) and price level(s) for the enterprise products covered by the Enterprise Enrollment. The chart in Section 2 below will assist you in determining your Select price level(s). These pools will not receive a price level adjustment during the term of the Enterprise Enrollment. i. If you or an affiliate selected the Enterprise Desktop Professional Platform on the Enterprise Enrollment, please fill in the table below by entering the number of qualified desktops and the corresponding Select price level from Section 2 below. You do not have to fill out Section 3 below. Enterprise Product Applicable Number of Qualified Select price level Select Pool Desktops *selected from the chart in Section 2 below Enterprise Desktop Professional All 3 Select Platform Pools If you or an affiliate selected one or two of the enterprise products listed in the below table on the Enterprise Enrollment, please fill in the table below by entering the number of qualified desktops and the corresponding Select price level from Section 2 below for each enterprise product selected. You must fill out Section 3 below for the product pools not covered by the Enterprise Enrollment Enterprise Product Applicable Number of Qualified Select price level Select Pool Desktops *selected from the chart in Section 2 below Office Professional Application Pool Windows Desktop Operating System Systems Pool Upgrade BackOffice Client Access Licenses Server Pool Section 2. The Select price level for the pools applicable to the enterprise products will be based on the table below for the number of qualified desktops you entered above. Number of Desktops Application System Pool Server Pool Pool 500 to 3,999 A A A 4,000 to 9,999 B B B 10,000 to 24,999 C C C 25,000 and above D D D Section 3: For any pool not covered by the Enterprise Enrollment, you must make your forecast for the tern of this agreement by circling the appropriate point level for that pool below.The price levels for these pools may be adjusted during the term of this agreement. Minimum Points for Price Application Pool System Pool Server Pool Level (Circle one if applicable) (Circle one if applicable) (Circle one if applicable) A 1,000 A A A B 8,000 B B B C 20,000 C C C D 50,000 D D D Microsoft State and Local Government Select Agreement Cover Page Page 4 of 10 (MSLI)v.5.1 (North American)November 20,2000 LICENSE PURGE ASE FORECAST'FORM Part 2: Up-frost Pays t Option. If you are level A or B in one or more chosen pools identified in Part 1,you qualify to receive a discount on the first order submitted with the first enrollment under this agreement.To obtain this discount,the enrolled affiliate must order from its designated reseller at the time this agreement and initial enrollment are signed, a minimum of 1000 points(if it is a level A customer)or 8000 points(if it is a Level B customer)within the product pool for which they want the discount to apply. You must place an"X"in the appropriate box below if you or an enrolled affiliate is participating in the"Up-front Payment Option"for the designated pool: Application Pool F-I System Pool a Server Pool Micrwoft State and Local Government Select Agreement Cover Page Page S of 10 (MSLI)v.5.1 (North American)November 20,2000 MICROSOFT STATE AND LOCAL GOVERNMENT SELECT AGREEMENT TERMS AND CONDITIONS 1. Definitions.In this agreement,"you"means the entity that has entered into this agreement with us,and"we"or"us"means the Microsoft company which has signed this agreement. In addition,the following definitions apply: "affiliates" means (i) with regard to you, any government agency, department, instrumentality, division, unit or other office that is supervised by or is part of you,or which supervises you or of which you are a part; together with,as mandated by law,any county, borough, commonwealth, city, municipality, town, township, special purpose district, or other similar type of governmental instrumentality located within your jurisdiction and geographic boundaries,provided that a state and its affiliates shall not,for purposes of this definition,be considered to be affiliates of the federal government and its affiliates; and(ii)with regard to us,legal entities that we own,which own us,or which are under common ownership with us; "enrolled affiliate"means the party,either you or any of your affiliates,that has entered into an enrollment under this agreement; "enrollment"means the document that you or your affiliate submits to us or one of our affiliates before orders can be placed under this agreement; "license confirmation"means the evidence of license provided by us or by one of our affiliates; "product"means any product available to you for license under this agreement,as described on the Product List; "Product List"means,with respect to any licensing program,the statement published by Microsoft from time to time which identifies the products available under the Select program and any product-specific conditions or limitations on the acquisition of licenses for the product; "reseller"means a Large Account Reseller authorized by us or one of our affiliates to resell licenses in an enrolled affiliate's area under this program;and "run"or"use"means to copy,install,use,access,display,run or otherwise interact with. 2. Select license program. Upon entering into this agreement,you and your affiliates may submit enrollments that allow enrolled affiliates to license certain products at volume price levels. Enrolled affiliates can sublicense to affiliates which do not enter into an enrollment,in order to allow them to share the benefits of this agreement. Enrolled affiliates may not acquire licenses under this agreement for the use or benefit of any person or entity other than affiliates. Each enrollment will expire on the expiration or earlier termination of this agreement. a. Products. You or an enrolled affiliate may order licenses for any products available for government select licensing at the time of your order,in any pool or pools that you have chosen.The Product List provides information on Microsoft products available for licensing under this program, information on point values, product pools, product upgrade a• license qualification criteria, and additional product information. New versions of the Product List will be made available to you and enrolled affiliates. You may order standard or upgrade licenses where applicable. You may order an upgrade license mly if you already have and retain a qualifying license. If you order a product for which the price is payable in installments,you are obligated to make all installment payments in full at the time the order is placed,with no option to defer all or part of such payments. b. Price levels. The price level assigned for each product pool is based on your total forecast of license acquisitions in that pool as indicated on the License Purchase Forecast Form. You may make your own forecast, or if you or an affiliate is party to an Enterprise Enrollment(or is entering into an Enterprise Enrollment concurrently with this agreement),you may choose to have your price level for that pool established based on the size of the enterprise included in that agreement. c. Terms of use. You and any affiliate may run the products for which an enrolled affiliate orders corresponding licenses in a timely manner. In place of a copy of the version licensed,you and your affiliates may run a copy of any prior version of the same product, subject to the product use rights applicable to the version licensed. Use of any product that you license from us is governed by product use rights specific to each product and version and by the terms of this agreement. The product use rights applicable to any version of any product released on or before the date of an enrollment will be the product use rights in effect on the enrollment date for that product and version. The product use rights applicable to a version or product released after the date of an enrollment will be the product use rights for that version or product in effect on the date of commercial release under the Select License program. In place of a copy of the language version licensed,you and your affiliates may run a copy of any other language version,provided that the language version you or your affiliate wish to run is available under Microsoft Select at the same or a lower price compared to the product and language on the issue date identified in the license confirmation. In lieu of your obligation to indemnify us under various provisions of the product use rights, you agree that you will be completely responsible for any costs and damages arising from any claim or action to which your indemnity obligation would otherwise apply. We will provide you with a copy of the applicable product use rights,or will make them available to you either by publication on the World Wide Web at a site we identify to you or by some other reasonable means.You acknowledge that you have access to the World Wide Web. We do not transfer any ownership rights in any licensed product and we reserve all rights not expressly granted. Microsoft State and Local Government Select Agreement Cover Page Page 6 of 10 (MSLI)v.S.l (North American)November 20,2000 d. License confirmations. Once an enrolled affiliate has received a license confirmation, the listed licenses(but not rights,if any, to future releases of products)become perpetual,as long as the products are used only as permitted by this agreement and the product use rights. We or one of our affiliates will issue license confirmations covering all licenses ordered. We may issue license confirmations either via post,express courier,facsimile,or Internet display.The license confirmations are evidence of license. Product support is not included with the licenses under this agreement. e. Transfers of licenses. Once an enrolled affiliate has received a license confirmation,it may transfer the licenses identified on the license confirmation to an affiliate. For all other transfers of licenses,our written consent is required. We will not withhold our consent unreasonably. In order to transfer licenses,an enrolled affiliate must physically transfer the relevant license confirmations. If transferring only some of the licenses listed on the license confirmation, the enrolled affiliate must record the transfer on the face of the license confirmation and provide a photocopy of the revised license confirmation to the entity to which the licenses are being transferred. In addition,no license transfer will be valid unless the entity to which the licenses are being transferred accepts in writing the applicable product use rights,use restrictions and limitations of liability. Upgrade Advantage subscription rights may not be transferred to,or used for the benefit of,a third party other than an affiliate. Licenses cannot be transferred on a short-term basis. An enrolled affiliate may transfer an upgrade license for an operating system product licensed under this agreement only as part of the sale or transfer of the computer system on which the product was first installed. Any transfer made in violation of the requirements or restrictions of this section will be void. L Resellers. Each enrolled affiliate must choose and retain a reseller authorized in the enrolled affiliates area. If at any time during the term of its enrollment the enrolled affiliate wishes to terminate the relationship with its designated reseller, or if we discontinue the reseller's authority to resell licenses under this program,the enrolled affiliate must choose a replacement. If the enrolled affiliate intends to change resellers,it may do so by notifying us and its former reseller of the proposed change in writing,on a form that we provide,at least thirty(30)days prior to the date on which the change is to take effect. You will be completely responsible for all cost and damages arising out of any change of reseller initiated by you. 3. Ordering licenses. Starting on the effective date of each enrollment,the enrolled affiliate may order licenses. Orders must be placed with the reseller named on the applicable enrollment. A license must be ordered in the month in which the copy of a product is first run from a particular computer or similar device. Your order must specify version number,language and country of usage for each license. Price and payment terms for all licenses ordered are determined by agreement with the chosen reseller. 4. Restrictions on use. You may not: • Separate the components of a product made up of multiple components by running them on different computers,by upgrading or downgrading them at different times, or by transferring them separately, except as otherwise provided in the product use rights; • Rent,lease or lend or host products,except where we agree by separate agreement; • Reverse engineer,de-compile or disassemble products,except to the extent expressly permitted by applicable law despite this limitation. • Transfer licenses to,or sublicense,products to the U.S.Government. You acknowledge that products licensed under this arrangement are of US-origin.You agree to comply with all applicable international and national laws that apply to these products,including the U.S. Export Administration Regulations,as well as end-user,end-use and destination restrictions issued by U.S. and other governments. For additional information on exporting Microsoft products, see htto://www.microsofLcom/ex22rting/. 5. Price level adjustments. Every year,on the anniversary of this agreement,we will review your license acquisitions within each pool for which you provided a forecast. Your price level going forward will be increased,,decreased or remain the same based on that review. For the first review we will double your 12-month acquisition history to determine whether your level will be reset.If you extend this agreement,then on each subsequent anniversary we will review your license acquisitions for the previous 24 months to determine whether your level will be reset. For any pool for which your price level was established based upon an Enterprise Enrollment,your price level will not be reset for the terra of the Enterprise Enrollment. If your license acquisitions from a pool fall below the minimum point count for the A price level,you and your affiliates will no longer be able to acquire licenses from that pool under this agreement. 6. Making copies of software. Each enrolled affiliate may make as many copies of the products licensed under its enrollment as necessary to distribute the products to its users. All copies must be true and complete copies(including copyright and trademark notices) and be made from CD-ROMs,disk sets or a network source acquired from or made available by a Microsoft approved fulfillment source. Each enrolled affiliate may also have a third party make and distribute or pre-install copies on computer hardware in its place,but the enrolled affiliate is responsible for third party actions to the same extent it would be if the third party were its employee. MicrosgJf State and Local Government Select Agreement Cover Page Page 7 of 10 (MSLI)v.5.l (North American)November 20,2000 You acid your affiliates must make reasonable efforts to make employees, agents and other individuals running a product aware that the product is licensed from us and may only be run or transferred subject to the terms of this agreement. In addition, each enrolled affiliate has the right to(i)run up to 20 copies of any product in a dedicated training facility on its premises;(ii)run up to 10 copies of any product for a 60-day evaluation period;and(iii)make and retain one copy of any licensed product for back-up or archival purposes for each of its distinct geographic locations. 7. Confidentiality. The terms and conditions of this agreement shall be disclosed only in accordance with the requirements of your public records law and regulations, if any. In the absence of such law and regulations, the temis and conditions of this agreement are confidential. Neither you nor we will disclose such terms and conditions,or the substance of any discussions that led to them,to any third party other than your or our affiliates or agents, or to your designated or prospective resellers who: (i) have a need to know such information in order to assist in carrying out this agreement; and(ii)have been instructed by you or us that all such information is to be handled in strict confidence. 8. Warranties. a. Limited product warranty. We warrant that each version of a product will perform substantially in accordance with our user documentation.This warranty is valid for a period of 90 days from the date you first run a copy of the version. Any warranties imposed by law concerning the products are limited to the same 90-day period. This warranty does not apply to components of products which you are permitted to redistribute under applicable product use rights, or if failure d'the product has resulted from accident, abuse or misapplication. If you notify us within the warranty period that a product does not meet this warranty,then we will,at our option,either (i)return the price paid for the product or(ii)repair or replace the product. This is your exclusive remedy for any failure of any product to function as described in this paragraph. b. Year 2000 warranty. For purposes of this section, "Year 2000 Warranted Product" means the specific version of each product identified in the Product Guide on the effective date of this agreement,by version number and language, as"compliant,"and any new products (including new versions of products)released after the effective date, and "Product Guide"means the Microsoft Year 2000 Product Guide located on the Microsoft Year 2000 Resource Center web page (www.microsofLconYtechnetlyear2k/product/product.asp). We warrant that each Year 2000 Warranted Product, when run with accurate date data and in accordance with its documentation and the recommendations and exceptions set forth in the Product Guide,will recognize the year 2000 as a leap year and will not produce material errors processing date data in connection with the year change from 1999 to 2000, as long as, and only to the extent that, all other information technology used in combination with such Year 2000 Warranted Product(e.g.,software,firmware,hardware)properly exchanges date data with it.This warranty does not extend or apply to user customizable features or third party add-on features or products, including items such as macros and custom programming or formatting features. Except as provided in the next sentence, if you or an enrolled affiliate reports to us on or before June 1,2000 that a product does not meet this warranty,we will:(i)exercise commercially reasonable efforts to correct any material non-compliance which is generally reported by other users; and(ii)provide any resulting correction,without charge,when it is made available generally.The June 1,2000 date will be extended to January 1,2001 for the following products and future versions thereof Windows NT Workstation 4.0&3.51,Windows 98&95,Windows NT Server 4.0&3.51,SQL Server 6.5 &7.0,Microsoft Exchange 5.5,Site Server 3.0; SNA Server 4.0,Systems Management Server 1.2,Proxy Server 2.0,Internet Information Server 4.0,Office 97&95(Microsoft Word,Excel, Access, Outlook, PowerPoint), Works 4.0-4.5a, Visual C++ 6.0, Visual Basic 6.0, Visual Fox Pro 6.0, Visual J++ 6.0 and Visual SourceSafe 6.0. This is the exclusive remedy for any failure of a product to function as described in this section,or for any other Year 2000-related failure of a product. c.NO OTHER WARRANTIES. TO THE EXTENT PERMITTED BY APPLICABLE LAW,WE DISCLAIM ALL WARRANTIES AND CONDITIONS,WHETHER EXPRESS,IMPLIED OR STATUTORY, OTHER THAN THOSE IDENTIFIED EXPRESSLY IN THIS AGREEMENT, INCLUDING BUT NOT LIMITED TO WARRANTIES OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE PRODUCTS OR RELATED MATERIALS. WE WILL NOT BE LIABLE FOR ANY SERVICES OR PRODUCTS PROVIDED BY THIRD PARTY VENDORS, DEVELOPERS OR CONSULTANTS IDENTIFIED OR REFERRED TO YOU BY US UNLESS SUCH THIRD PARTY PRODUCTS OR SERVICES ARE PROVIDED UNDER WRITTEN AGREEMENT BETWEEN YOU AND US, AND THEN ONLY TO THE EXTENT EXPRESSLY PROVIDED IN SUCH AGREEMENT. 9. Defense of infringement claim. We will defend you against any claim by an unaffiliated third party that any product infringes its patent or copyright,and will pay the amount of any resulting adverse final judgment(or settlement to which we consent). You must notify us promptly in writing of the claim and give us sole control over its defense or settlement. You agree to provide us with reasonable assistance in defending the claim, and we will reimburse you for reasonable out of pocket expenses that you incur in providing that assistance. Our obligations will not apply to the extent that the claim or adverse final judgment is based on(i)your running of the product after we notify you to discontinue running due to such a claim; (ii) your combining the product with a non-Microsoft product,data or business process; (iii) use of, or access to,the product by any person or entity other than an employee of you or one of your affiliates;(iv)your distribution of the product to an unaffiliated third party;or(v)your altering the product. You will be completely responsible for any costs or damages that result from these actions. Mieroso)?State and Local Government Select Agreement Cover Page Page 8 of 10 (MSL/)v.5.I (North American)November 20, 2000 If we receive information concerning an infringement claim related to a product,we may,at our expense and without obligation to do so, either(i) procure for you the right to continue to run the allegedly infringing product, or(ii) modify the product or replace it with a functional equivalent,to make it non-infringing,in which case you will stop running the allegedly infringing product immediately. If,as a result of an infringement claim, your use of a product is enjoined by a court of competent jurisdiction, we will use commercially reasonable efforts to either procure the right to continue its use, replace it with a functional equivalent, or modify it to make it non- infringing. If any other type of third party claim is brought against you regarding our intellectual property,you must notify us promptly in writing. We may,at our option,choose to treat these claims as being covered by this section. 10. Limitation of liability. a. Limitation. There may be situations in which you have a right to claim damages or payment from us. Except as otherwise specifically provided in this paragraph, whatever the legal basis for your claim, our liability will be limited, to the maximum extent permitted by applicable law,to direct damages up to the amount you have paid for the product giving rise to the claim. In the case of our responsibilities with respect to third party patent or copyright infringement claims,our obligation to defend such claims will not be subject to the preceding limitation,but our liability to pay damages resulting from any final adjudication(or settlement to which we consent)will be. In the case of free product or code you are authorized to redistribute to third parties without separate payment to Microsoft,our total liability to you will not exceed US55000. The limitations contained in this paragraph will not apply with respect to our obligations under Section 7(confidentiality). b. No liability for certain damages. To the maximum extent permitted by applicable law,neither party nor any of their affiliates or suppliers will be liable for any indirect damages(including,without limitation,consequential,special or incidental damages,damages for loss of profits or revenues,business interruption,or loss of business information)arising in connection with this agreement or any product or service,even if advised of the possibility of such damages or if such possibility was reasonably foreseeable. This exclusion of liability does not apply to either parry's liability to the other for violation of its confidentiality obligation or of the other parry's intellectual property rights. c. Application. The limitations on and exclusions of liability for damages in this agreement apply regardless of whether the liability is based on breach of contract,tort(including negligence),strict liability,breach of warranties,or any other legal theory. 11. Verifying compliance. You must keep records relating to the products you and any affiliate run. We have the right to verify compliance,at our expense,during the term of this agreement or any enrollment and for a period of one year thereafter. To do so,we will engage an independent accountant from a nationally recognized public accounting firm, which will be subject to a confidentiality obligation. Verification will take place upon not fewer than 15 days notice,during normal business hours and in a manner that does not interfere unreasonably with your operations. As an alternative,we may require you to accurately complete our self-audit questionnaire relating to the products you and any affiliates use. If verification or self-audit reveals unlicensed use of products,you must promptly order sufficient licenses to permit all product usage disclosed.If material unlicensed use is found(license shortage of 5%or more),you must reimburse us for the costs we have incurred in verification and acquire the necessary additional licenses as single retail licenses within 30 days. If we undertake such verification and do not find material unlicensed use of products,we will not undertake another verification of the same entity for at least one year. We and our auditors will use the information obtained in compliance verification only to enforce our rights and to determine whether you are in compliance with the terms of this agreement. By invoking the rights and procedures described above,we do not waive our rights to enforce this agreement or to protect our intellectual property by any other means permitted by law. 12. Term and termination. a. Term. This agreement will remain in effect for 24 full calendar months following the effective date. b. Extension. You and we may agree to extend the term of this agreement for an additional 24 full calendar months.We will send notice 60 days prior to an extension. If you choose not to extend you must notify us by replying to this notice. Extension of this agreement automatically extends the term of each enrollment. If you wish to continue licensing any subscription-based product,you must submit a purchase order for that product to your reseller. c. Termination. Either party to an enrollment may terminate it for cause. If we terminate an enrollment for cause,we may also terminate this agreement and all other enrollments under it. Except where the cause for termination is by its nature not curable(or not curable within 30 days),the terminating party will give 30 days notice and opportunity to cure. If we give such notice to an enrolled affiliate,we will give you a copy of that notice as well. If an enrolled affiliate ceases to be your affiliate you must notify us of this fact,and we may terminate its enrollment. Unless terminated for cause,an enrollment will expire or terminate upon the expiration or termination of this a$reemt You agree that neither you nor any of your affiliates will reproduce any software unless sufficient funds have been duly appropriated. Notwithstanding any deferred payment schedule for upgrade licenses that may be available to non-governmental customers,you agree that, due to the uncertainty of future appropriations,any payments for upgrade licenses ordered in connection with this agreement shall be made in full at the time the order is placed,with no option to defer all or part of such payments. Microsoft State and Local Government Select Agreement Cover Page Page 9 of 10 (MSLI)v.5.1 (North American)November 20, 2000 Upon expiration or termination of this agreement or any enrollment,the enrolled affiliate must order licenses for all copies of products it has run for which it has not submitted orders. Termination of this agreement will not affect your or your affiliates'right to run copies of products for which the enrolled affiliate already ordered licenses. 13. Miscellaneous. a. Notices. All notices,authorizations,and requests given or made in connection with this agreement must be sent by post,express courier,facsimile,or email to the addresses and numbers indicated in the applicable cover page to this agreement.Notices will be deemed delivered on the date shown on the postal return receipt or on the courier,facsimile or email confirmation of delivery. b. Assignment. This agreement may be assigned by either party only to an affiliate,but assignment will not relieve the assigning patty of its obligations under the assigned agreement If either party assigns this agreement or any enrollment,it must notify the other party of the assignment in writing. c. Severability. If a court holds any provision of this agreement to be illegal, invalid or unenforceable,the remaining provisions will remain in full force and effect and the parties will amend the agreement to give drect to the stricken clause to the maximum extent possible. d. Waiver.No waiver of any breach of this agreement shall be a waiver of any other breach,and.no waiver shall be effective unless made in writing and signed by an authorized representative of the waiving party. e. Force Ma jeure. To the extent that either parry's performance is prevented or delayed,either totally or in part,for reasons beyond that party's control,then that party will not be liable,so long as it resumes performance as soon as practicable after the reason preventing or delaying performance no longer exists. L Note on Java Support. The products may contain support for programs written in Java.Java technology is not fault tolerant and is not designed, manufactured, or atended for use or resale as online control equipment in hazardous environments requiring fail-safe performance, such as in the operation of nuclear facilities, aircraft navigation or communication systems, air traffic control, direct life support machines, or weapons systems,in which the failure of Java technology could lead directly to death,personal injury, or severe physical or environmental damage.Sun Microsystems,Inc.has contractually obligated Microsoft to make this disclaimer. g. Limitations on actions. Except for any different period required by applicable law,any action arising under this agreement must be brought within two years from the date that the cause of action arose. h. Entire agreement. The documents identified on the cover page to this agreement constitute the entire agreement concerning the subject matter hereof,and supersede any prior or contemporaneous communications.The terms of these documents shall control in the following order. (i)this State and Local Government Select Agreement;(ii)the product use rights;(iii)the Product List rights;and(iv) any and all enrollments under this agreement. The terms of any purchase order or any general terms and conditions you or your affiliates maintain,other than those mandatory terms required by statute or regulation,do not apply. This agreement(except the product use rights and the Product List)can be changed only by an amendment signed by both parties. 1. Survival. Licenses identified in license confirmations and provisions regarding warranties, limitations of liability, compliance verification and obligations on termination or expiration will survive termination or expiration of this agreement or any enrollment. J. Independent contractors. Resellers are independent contractors who act in their own name and for their own account,and have no authority to bind or impose any obligation or liability upon us. -- k. Applicable law. This agreement shall be interpreted in accordance with and governed by the laws of your Statcy without giving efRDa to its conflicts of law provisions. This choice of law does not prevent either party from seeking injunctive relief with respect to a violation of intellectual property rights or confidentiality obligations in any appropriate jurisdiction.Disputes relating to this agreement will be subject to applicable dispute resolution statutes and regulations of your State,if any. 1. Copyright Violation. Except to the extent you are licensed under this agreement, you shall be responsible for your violation of our copyright in the products,including payment of license fees specified in this agreement for unlicensed use. m. Cost or Pricing Data. We will not, under any circumstances, accept an enrollment that would require the submission of cost or pricing data. Microsoft State and Local Government Select Agreement Cover Page Page 10 of 10 (MSLi)v.5.1 (North American)November 20,2000 To be completed by Microsof? Microsoft Select Agreement Number AMENDMENT No. 1 TO MICROSOFT STATE AND LOCAL GOVERNMENT SELECT AGREEMENT This amends the Microsoft State and Local Government Select Agreement identified above between the State of Illinois and MSLI, GP (the "agreement"). All terms used but not defined in this amendment will have the meanings assigned to such terms in the agreement. I. Amendment. 1. Section 2.a,Products,of the agreement is hereby amended and restated as follows: a. Products. You or an enrolled affiliate may order licenses for any products available for government select licensing at the time of your order, in any pool or pools that you have chosen. The Product List provides information on Microsoft products available for licensing under this program, information on point values, product pools, product upgrade or license qualification criteria, and additional product information. New versions of the Product List will be made available to you and enrolled affiliates. You may order standard or upgrade licenses where applicable. You may order an upgrade license only if you already have and retain a qualifying license. If you order a product for which the price is payable in installments,except as set forth in Section 12.c, you are obligated to make all installment payments. 2. Section 2.d,license confirmations,of the agreement is hereby amended and restated as follows: d. License confirmations. Except as set forth in Section 12(c), once an enrolled affiliate has received a license confirmation, the listed licenses (but not rights, if any, to future releases of products)become perpetual,as long as the products are used only as permitted by this agreement and the product use rights. We or one of our affiliates will issue license confirmations covering all licenses ordered. We may issue license confirmations either via post, express courier, facsimile, or Internet display. The license confirmations are evidence of license. Product support is not included with the licenses under this agreement. 3. The second and third paragraphs of Section 12 c, Termination, of the agreement are hereby deleted in their entirety and the following inserted in lieu thereof: c.Termination. Upon expiration or termination of this agreement or any enrollment, the enrolled affiliate must order licenses for all copies of products it or its affiliates have run under its enrollment for which the enrolled affiliate has not previously submitted an order. Except as set forth below, in the event of termination all unpaid installments of the price for any licenses will immediately become due and payable, and the enrolled affiliate will be entitled to perpetual licenses only after all such payments have been made. However, if(i) an enrolled affiliate terminates its enrollment as a result of our breach, (U) we terminate an enrolled affiliate's enrollment Because it has ceased to be your affiliate, or #Ui we_terminate an enrollmentfor non-payment due to non-appropriation of funds, then the enrolled affiliate will have the following options. It may immediately pay the total remaining amount due, including all installments, in which case the enrolled afliliate will have perpetual licenses for all copies of the products it has ordered. As an alternative, it may pay only amounts due and payable as of the termination date, in which case the enrolled affiliate will have perpetual licenses for (i) all copies of all products for which payment has been made in full, and(h)the number of copies of products for which payment has been made in installments that is proportional to the amount SA 5.1 S&L Amendment—(North America)(English) that has been paid as of the termination date. If you elect not to make all installment payments, (i) license confirmations issued for products for which installment payments are not made will be void, and(ii), we will re-issue license confirmations reflecting amounts paid by you under this paragraph. 4. The following paragraphs are hereby added to section 13 of the agreement: &A VAILABIL177 OF APPROPRM TIONS(30ILCS 500110-60):AGENCY shall use its best efforts to secure sufficient appropriations to fund this CONTRACT.However, the AGENCY'S obligations hereunder shall cease immediately, without penalty or further payment being required if the Illinois General Assembly or federal funding source fails to make an appropriation sufficient to pay such obligation. The AGENCYshall determine whether amounts appropriated are sufficient.AGENCYshall give VENDOR notice of insufficient funding as soon as practicable after AGENCY becomes aware of the insufficiency. VENDORS obligation to perform shall cease upon . receipt of the notice. o.AUDITIRETENTION OF RECORDS(30ILCS 500/20-65): VENDOR and its subcontractors shall maintain books and records related to performance of this CONTRACT or subcontract and necessary to support amounts charged to the State in accordance with applicable law, terms and conditions of this CONTRACT, and generally accepted accounting practice. VENDOR shall maintain these book and records for a minimum of three(3)years after the completion of the CONTRACT,final payment, or completion of any CONTRACT audit or litigation, whichever is later.All books and records shall be available for review or audit by the AGENCY, its representatives, the Illinois Auditor General, and other governmental entities with monitoring authority upon reasonable notice and during normal business hours. VENDOR agrees to cooperate fully with any such review or audit.If any audit indicates overpayment to VENDOR, or subcontractor, the AGENCY shall adjust future or final payments otherwise due.If no payments are due and owing to VENDOR, or if the overpayment exceeds the amount otherwise due, VENDOR shall immediately refund all amounts which may be due to the AGENCY.Failure to maintain the books and records required by this Section shall establish a presumption in favor of the AGENCYfor the recovery of arty funds paid by the AGENCY under the CONTRACT for which adequate books and records are not available to support the purported disbursement. p.INDEPENDENT CONTRACTOR: The VENDOR shall be an independent contractor. Supplies provided and/or services performed pursuant to this CONTRACT are not rendered as an employee of the AGENCY or of the State of Illinois.Amounts paid pursuant to this CONTRACT do not constitute compensation paid to an employee. q.LIABILITYAND INSURANCE: d) The AGENCY assumes no liability for actions of VENDOR and is unable to indemnify or hold VENDOR harmless for claims based on this CONTRACT or use of VENDOR provided supplies or services. Unless provided by law, VENDOR is not eligible for indemnity under the State Employee Indemnification Act(5ILCS 35011 et seq.).Any liability for damages that the State might have is expressly limited by and subject to the provisions of the Illinois Court of Claims Act(705 ILCS 50511)and to the availability ofsuitable appropriations. r. TAX COMPLIANCE: VENDOR shall be in compliance with applicable tax requirements and shall be current in payment of such taxes.. S.NON-DISCRIMINATION:In compliance with the State and Federal Constitutions, the Illinois Human Rights Act, the U. S. Civil Rights Act, and Section 504 of the Federal Rehabilitation Act, the AGENCY does not unlawfully discriminate in employment, contracts, or any other activity. t LEGAL ABILITY TO CONTRACT.-As a condition of this contract, we certify that we are under no legal prohibition on contracting with the State of Illinois. we further specifically certifies that, the best of our knowledge: SA 5.1 S&L Amendment—(North America)(English) a)we and our employees and subcontractors will comply with applicable provisions of the U.S. Civil Rights Act,Section 504 of the Federal Rehabilitation Act, the Americans with Disabilities Act(42 U.S.C. 12101 et seq.)and rules applicable to each in all aspects of performance under this contract. b) VENDOR is not in default on an educational loan(S ILCS 38513). c) VENDOR has informed the director of the AGENCY in writing if VENDOR was formerly employed by that AGENCY and has received an early retirement incentive under Section 14-108.3 orl 6-133.3 of the Illinois Pension Code(30 ILCS 105/1 Sa). d) VENDOR has not been convicted of bribing or attempting to bribe an ofcer or employee of the State of Illinois or any other State,nor has made an admission on the record of having so bribed or attempted to bribe(30 ILCS 500/50-5). e)If VENDOR has been convicted of a felonry, at least five years have passed after the date of completion of the sentence for such felonry, unless no person held responsible by a prosecutor's office for the facts upon which the conviction was based continues to have any involvement with the business(30 ILCS 500150-10). f VENDOR has not paid any money or valuable thing to induce any person to refrain from bidding on a State contract, nor has VENDOR accepted any money or other valuable thing, or acted upon the promise of same,for not bidding on a State contract(30 ILCS 500150-25). g) VENDOR has disclosed, and agrees it is under a continuing obligation to disclose to the AGENCY,financial or other interests(public or private, direct or indirect)that may be a potential conflict of interest under Article 50 of the Illinois Procurement Code(30 ILCS 500/50), or which may conflict in any manner with the VENDOR'S obligation under this CONTRACT;that it shall not employ any person with a conflict to perform under this CONTRACT,and that no person has an interest in this CONTRACT that would violate Illinois law, including 30 ILCS 500150-13. h) VENDOR is not in violation of the "Revolving Door"section of the Illinois Procurement Code(30 ILCS 500150-30). i) VENDOR will report to the Illinois Attorney General and the chief procurement osicer any suspected collusion or other anticompetitive practice among any bidders, offerors, contractors,proposers or employees of the State(30 ILCS 500150-40);(30 ILCS S00/50- 45); (30 ILCS 500150-50). j) VENDOR will,pursuant to the Drug Free Workplace Act,provide a drug free workplace, and if an individual, shall not engage in the unlawful manufacture, distribution, dispensations,possession or use of a controlled substance in the performance of the CONTRACT. This certification applies to CONTRACTS of$5000 or more with: individuals; and to entities with twenty-five(25)or more employees(30 ILCS 580). k)Neither VENDOR nor any substantially owned affiliate is participating or shall participate in an international boycott in violation of the U.S.Export Administration Act of 1979 or the applicable regulations of the U.S. Department of Commerce. This certification applies to CONTRACTS that exceed$10,000(30 ILCS 582). 1) VENDOR has not been convicted of the offense of bid rigging or bid rotating or any similar offense of any State or of the United States(720 ILCS 5/33E--3); (720 ILCS S/33E-4). m) VENDOR complies with the Illinois Department of Human Rights Act and rules applicable to public contracts, including equal employment opportunity, refraining from unlawful discrimination, and having written sexual harassment policies(775 ILCS 105). n) VENDOR does not pay dues to, or reimbura_e or subsidize payments by its employees for, arty clues orfees to arty "discriminatory ctubr(775ILCS"23/2j. II. Effect of Amendment. SA 5.1 S&L Amendment—(North America)(English) Except as specifically amended by this amendment, all provisions of the agreement identified above shall remain unchanged and in full force and effect.When this amendment is fully executed,you will receive a confirming copy. You must execute and return two(2)copies of this amendment to the below address on or before September 30,2001 in order for the terns and conditions of this amendment to apply. MSLI,GP Attn:Dept.551,Volume Licensing 6100 Neil Road,Suite 210 Reno,NV 89511-1137 Organization: Contracting Microsoft Affiliate: State of Illinois MSLI,GP Name of Organization Name of contracting Microsoft affiliate By By Name,Title IF Name,Title Date Date Prepared by: Forrest Silverman,Licensing Executive, Microsoft Corporation Agent for MSLI,GP Sri 3J S&L Amendment—(North Amerka)(Engltah) For Microsoft Internal Use Purposes Enrollment Number .."' ',., v, t:; Select Agreement Expiration Date ' Reseller must complete the following: Select Agreement Number + `,} NOT FOR USE WITH THE MICROSOFT BUSINESS AGREEMENT MICROSOFT STATE AND LOCAL GOVERNMENT SELECT ENROLLMENT This MICROSOFT'STATE AND LOCAL GOVERNMENT SELECT ENROLLMENT is entered into between the following entities as of the effective date identified below. If different from the main contact information, any notices must be addressed to the contact and locations outlined in the notices section below. We will notify you in writing if our address information changes. You must notify us in writing if your address changes. Customer ame Name and address of contracting Microsoft affiliate I/ G MSLI,GP Street Address and/or post office box Street Address and/or post office box lo�4> u/�1 S Suite 210 Neil Road City and State/Province City and State/Province Reno,NV Coun and'I ode Country and Postal Code 40-2 [) USA 89511-1137 Contact N e err f ' Phone Number Phone Number -7S 775-823-5600 Fax Number _ Fax Number �/ — SS 775-826-7287 Email Address Email Address /' •S • L• Sel uest microsoft.com For the Atteuddh of For the Attention of. Dept.551,Volume Licensing Customer Notices Information(if different from above) The enrollment and attached documents should be sent to the above address for approval and processing, Customer Name All NOTICES should have Copy To: Microsoft Corporation,Law and Corporate Affairs Street Address and/or post office box One Microsoft Way City and State/Province Redmond,WA Country and Postal Code USA 98052 Contact Name Phone Number Fax Number 425-936-7329 Email Address Microsoft.com For the Attention of: For the Attention of: Volume Licensing Attorney Microsoft State and Local Government Select Enrollment Cover Page Page 1 of 5 (MSLI)v5.I (North American)November 20,2000 ' 1 Terms used in this enrollment shall have the meanings assigned to than in the State and Local Government Select Agreement identified above. By signing this enrollment,you represent and warrant that: . RL a. You have read and understood the State and Local Government Select Agreement identified above,including any addenda and amendments to that agreement(specifically including but not limited to the current version of the product use rights), and agree to be bound by those terms. b. You are the entity which signed the State and Local Government Select Agreement identified above or its affiliate. e- You expect to acquire licenses equivalent to at least 500 points during the term of this enrollment. This enrollment consists of(1)this cover page,(2)the Shipping Information Form, (3)the Reseller Information Form,and(4)the Product List. By signing below you agree that you are bound by the terms of the State and Local Govermnent Select Agreement identified above and the product use rights applicable to products ordered under this enrollment. By signing below,you also represent that the information that you provide on each of the attached forms is accurate. Name of Customer(Entity Name): Name of contracting Microsoft affiliate: r, MSLTGP B B (Signature) Name IY7z G-A d L/J • sG.X Name: (Printed) Title: Title: (Printed) Date: Effective Date: Kt Microsoft State and Local Government Select Enrollment Cover Page Page 2 of 5 (MSLI)v5.1 (North American)November 20,2000 ResdIer Iniormstton Forst Ad MM-01 57 � .. eon.. Tim sudwslaW confirm that dw Reveller Worm du d eerreet. aE . e'e rsnawr s) (ppixt . rile: Microsq,4 State and Local Government Select Enrollment Cover Pose Pase J of J (MSLI)vJ./ (North American)November 20.2000 CONTRACT RENEWAL obligation#: CMSS The undersigned Centrar management Services (AGENCY) and (VENDOR), agree to RENEW the described CONTRACT as follows: 1. DESCRIPTION OF CONTRACT BEING RENEWED: Original Contract#: E901359 Microsoft Software and support of those products. Vendor#: 2. TERMS AND CONDITIONS: This RENEWAL is on the same terms and conditions as the CONTRACT being renewed except as changed and described herein. All required certifications and disclosures have been made and are current. 3. RENEWAL TERM: This RENEWAL shall begin July 1.2001 and shall run through June 30, 2003. 4. CHANGES FROM CONTRACT BEING RENEWED(INCLUDING COMPENSATION): 5. COST(DESCRIBE CALCULATION AND/OR COST BASIS, IF APPLICABLE): 6. ATTACHMENTS: IN WITNESS WHEREOF,the undersigned parties have caused this RENEWAL to be executed on the dates shown below by representatives authorized to bind the respective PARTIES. VENDOR ;V of gar AGELiz Signature: Signature: Printed Na e. DOUGLAS B GAL OWAY Title: --2 / / Title: ACCOUNT MANAGER Date: Date: 04/11/01 Address: 850 Asbury Drive CENTRAL MANAGEMENT SERVICES Buffalo Grove, IL 60089 Signature: Phone Number: 800-883-8443 Title: Fax Number: 847-465-3277 Date: STATE USE ONLY- Source Selection: _IFS(including Multi--step) _RFP _RFP/P&A Small Purchase _Sole Source _Emergency Exempt from Code _Other(describe) j Payment Method: Payable In Advance _Other(specify) j 2000rene.doc ASAP Software Express AUG-31-1999 10:25 CMS CONTRACT ADM1N 217 524 0718 P.02/03 .. _. ... .,&j %".t,m.k.I nu-i.if 217 524 0718 P.02/W EMI?X ASAP Son""$xpM Foam And OdwD= nmb bMPOOddJv Mm MOW Aft NAME OF)PORN DATE Fa M ADDED DATE FORM DO EM AM VM ALS AND HgffYAU M�eoB Qom Sdoct M Lw t°M UP a Sept mm Master Contract Update (rev. 8199) p� A-10, Contract for Supplies and Services - E901359 INITIAL Contract Renewal of E901359 7/1/01 - 6/30/03 A 05/08/31/1999 10:25AM Board Agenda Item Submittal xII-A Requested By: Raymond O Rigsby Entered By: Raymond O Rigsby Agenda Item Title: Ordinance 2003: An Ordinance Authorizing the Disposal of Surplus Village Personal Property. Date Submitted: Meeting Date Agenda Place Requested: Requested: Department: 08/13/2003 08/18/2003 0 Consent Agenda PW Regular Agenda 0 None Does this item Does this item include Will AV equipment be relate to another additional reference required to present item on the info separate from the this item to the agenda? Board packet? board? 0 Yes 0No 0 Yes 0No 0 Yes 0No Item Description Will this action involve an expenditure in 0 Yes 0 No funds? Additional Notes regarding Expenditures: Type the body of the cover memo here. Requests cannot be submitted if this field is blank. Attached is an Ordinance declaring designated Village equipment surplus pursuant to Chapter 65 Section 5/11.76.4 of the Illinois Compiled Statutes. It has been determined by Chief Sashko, with concurrence by Superintendent Rigsby, that the Village's 1991, Emergency One, 1250 GPM Quint, as detailed on Exhibit A of the attached no longer serves the best interests of the Village and should be disposed. Approval of the attached Ordinance authorizes the Village Manager to take all necessary action to dispose of said surplus property. Staff has conducted extensive research regarding the process by which the equipment should be disposed. It has been determined that the use of a broker would best serve the Village. This method has been utilized by the Village of Buffalo Grove in the past and other municipalities with great success including significant cost savings. A broker would handle every aspect of the sale, plus provide necessary national exposure. The only department requirement would be to provide a bill of sale, transfer the title, and collect the check. Staff has researched a number of companies, including those operating in the east and west cost. It is recommended that B&P Apparatus, Inc. be utilized for broker services for this equipment. Attached is information regarding the company, the broker process, as well as a partial reference list. The Village has utilized the brokerage services of B&P in the past for a number of vehicles such as aerial ladders, mini pumpers, and an ambulance. Subject to approval of the attached Ordinance, staff would work with B&P to pursue brokerage services and finalize the sale of the Emergency One Quint. Approval of the attached Ordinance is recommended. Letter-Sized Legal-Sized Ledger-Sized Odd-Sized Attached Files Attached Files Attached Files Attached Files El Surplus Equipment Ord and supplemental ite Approval Section: Name: Date and Time: Submitted By: Pre-Approved By: Approved By: Published to Web: ORDINANCE 2003 - AN ORDINANCE AUTHORIZING THE DISPOSAL OF SURPLUS VILLAGE PERSONAL PROPERTY WHEREAS, the Village of Buffalo Grove is a Home Rule unit pursuant to the Illinois Constitution of 1970: and WHEREAS, in the opinion of a majority of the Corporate Authorities of the Village of Buffalo Grove, it is no longer necessary, useful or in the best interest of the Village of Buffalo Grove to retain ownership of the personal property hereinafter described; and WHEREAS, the property described is a part of the Village Fixed Asset Inventory Control System and procedurally must be deleted through Ordinance adopted by the Corporate Authorities; and WHEREAS, the property described will be disposed of through trade-in, sale, a broker retained for the sale of any items declared surplus, or outright disposal, whatever is best deemed appropriate. NOW, THEREFORE BE IT ORDAINED BY THE PRESIDENT AND BOARD OF TRUSTEES OF THE VILLAGE OF BUFFALO GROVE, COOK AND LAKE COUNTIES, ILLINOIS, that: SECTION 1. The foregoing WHEREAS clauses are hereby made a part hereof. SECTION 2. Pursuant to the Village's Home Rule powers, the President and Board Trustees of the Village of Buffalo Grove find that the items of personal property described in Exhibit "A" now owned by the Village of Buffalo Grove are no longer necessary or useful to the Village of Buffalo Grove and the best interests of the village will be served by disposal. SECTION 3. The Village Manager is hereby authorized to take all necessary action to dispose of said surplus property. SECTION 4. This Ordinance shall be in full force and effect from and after its passage by a vote of a majority of the Corporate Authorities, and approval in the manner provided by law. AYES: NAYE S: ABSENT: PASSED: ,2003 APPROVED: , 2003 ATTEST: Village President Village Clerk EXHIBIT "A" INVENTORY# YEAR MAKE MODEL VIN # 602-0241 1991 Emergency One 1250 GPM Quint 46JBBAA86M1003700 TO: William R. Balling, Village Manager FROM: Raymond O. Rigsby, Superintendent of Public Works Operations DATE: August 13, 2003 RE: ORDINANCE DECLARING SURPLUS EQUIPMENT Bill, I have attached the ordinance declaring designated Village equipment surplus pursuant to Chapter 65 Section 5/11.76.4 of the Illinois complied Statutes. Chief Tim Sashko is suggesting the use of a broker for the sale of the Quint. I concur with the Chiefs recommendation. We are requesting that the Village President and Board of Trustees approve this ordinance at the next scheduled meeting of the Village Board on August 18, 2003. If you have any questions,please let me know. Raymond O. Rigsby, Superintendent of Public Works Operations 1. attachment K:AgarageAordinanceAsurplusord Jul 30 03 01 : 21p B & P RPPRRRTUS INC 630-978-1604 p. 2 B & P APPARATUS INC . 1552 BRYAN CT. ♦AURORA, IL. 60504 QMAW P Phone 630-978-1455♦ Fax 630-978-1604 Email—bnpappQcomcast.net e°"""'"` WEB SITE:www.bpapparatus.com July 30,2003 B &P Apparatus Inc.,operates a successful nationwide used Fire Apparatus Brokerage Service. After execution of a brokerage sales contract, B &P Apparatus assumes full responsibility for marketing your used apparatus. Advertising is placed in our Internet Web site at www.bpapparatus.com as well as our own direct mail advertising newsletter. The "Newsletter" is periodically distributed to over 17,000 Volunteer Fire Departments Nationwide. Volunteers are far and away the primary consumers of used fire apparatus in the U.S. after listing,one of our representatives will videotape and photograph your used trucks. When we receive a qualified inquiry on a vehicle,we send still photos, a video tape and a detailed description of the unit to the prospective customer. If a continued interest is shown by the customer, he may fly in to Chicago to view the apparatus. Our representative will meet the prospects at the airport and escort them to the apparatus. Tn addition to direct mail advertising, B&P Apparatus has developed a network of over 60 used apparatus dealers across the country and Canada whom we cooperate. This multiples the potential exposure of your apparatus to prospective purchasers. When an offer is received from the prospect,we review that offer with the village officials for approval. If the offer is acceptable,the purchaser will place a deposit of 10%of the sale price with B&P Apparatus to take the unit off the market.At that time the purchaser will be advised to pick up the used truck. The purchaser provides a cashier's or certified check in the amount of the outstanding balance(90%)payable to the village or Department at the time of delivery. After final payment, he takes possession of the vehicle,certificate of title and bill of sale specifically acknowledging the fact that the vehicle is sold "as is" and there are no express or implied warranties on the apparatus.The 10%deposit is retained by B&P Apparatus as a sales commission for the marketing services provided. Even if a second dealer is involved in this sale, our brokerage fee will never exceed 10%of the gross selling price of the apparatus. Advantages of a brokerage sale include: a. Substantially higher retained value for the village than a trade-in. b. No additional risk or investment by the village. All sales activities and expenses are borne by B &P Apparatus. Fire Department officials are not distracted by calls and visits from prospective purchasers. Officials have the opportunity to set minimum acceptable offer amount for each apparatus and retain the right of final approval of each sale. c. Better advertising exposure through our Newsletter. JUL 30 '03 13:41 630 978 1604 PAGE.02 Jul 30 03 01 : 22p B a P RPPRRRTUS INC 630-978-1604 p. 3 B & P APPARATUS INC . 1552 BRYAN CT. ♦AURORA, IL. 60504 B. P; Phone 630-978-1455♦ Fax 630-978-1604 Email—bnpapp@comcast.net "'"°""" WEB SITE:www.bpapparatus.com July 30,2003 The Newsletter reaches the highest number of potential customers directly. Advertising in national trade magazines will often result in low offers, if any at all. We have brokered a number of units which were also advertised directly by the owner previously with unsatisfactory results. In one case the owner received only 2 bids for$5,000.00 and $7,000.00 respectively as a result of their own a. Through brokerage sale, they received a offer of over$35,000.00 for the same truck. In another case, a Village expected to realize approximately $20,000.00 from the sale of a piece of their used Fire Apparatus. Through B &P Apparatus marketing efforts,that Municipality netted$40,000.00 when the unit was sold, After deduction of our 10%sales commission. d. Local representation results in improved service. By virtue B &P Apparatus location in the Chicago Suburban area, We can better serve your needs and readily be available to assist you in the sale of your apparatus. Enclosed for your benefit is a current copy of our"Newsletter" and our standard brokerage contract. Should you wish to make a change or amendment to the standard contract,we would be willing to consider any reasonable modification. If you have any questions,please don't hesitate to call me a 1-800-215-3722. Respectfully yours, Brian Clark President B&P Apparatus Inc JUL 30 103 13:41 630 976 1604 PAGE.03 Jul 30 03 01 : 22p B & P RPPRRRTUS INC 630-978-1604 p. 4 B & P APPARATUS INC . 1552 BRYAN CT. ♦AURORA, IL. 60504 B IT—N11111 P. Phone 630-978-1455♦ Fax 630-978-1604 Email-bnpapp@comcast.net WEB SITE:www.bpapparatus.com July 30,2003 PARTIAL REFERENCE LIST F_I_RE DEPARTMENTS ENGINES LADDER TANKERISOUAD AMB Lombard 2-Engines 2-Ladder Glen Ellyn 1 Engine I-Ladder Pleasantview l-Engine l-Snorkel I-Tanker 1-Amb Rolling Meadows 2- Engines 1-Snorkel Arlington Heights 4-Engines 1-Ladder Aurora 7-Engines 1-Ladder Schaumburg 6-Engines 2-Ladder 1-Squad Elmwood Park I- Engine I-Ladder Lisle Woodridge 2-Engines Darien Woodridge 4-Engines 1-Pumper Tanker Willmette 3-Engines Monee 1-Engine South Chicago Heights 1-Snorkel Crete 1-Pumper Crete Township 1-Tanker Hinckley 1-Pumper Plano 2-Pumpers 1-Tanker Northfield 1-Ladder Oakbrook Terrace 2-Pumpers 1-Snorkcl 1-Tanker 1-Squad Franklin Park I-Snorkle I-Squad Buffalo Grove 3-Pumpers 2-Ladders 1-Midi Pumper 1-Amb Lynwood Fire 3-Pumpers Long Grove . 2-Pumpers Willow Springs 2-Pumper 1-Midi Pumper 2-Amb Addison 1-Pumper Burns Harbor IN 2-Pumpers I-Squad Beecher 2-Pumpers 2-Tankers Glenview 5-Pumpers 1-Snorkel 1- Inf. Boat 2-Amb York Center 2-Pumpers 1-Midi Pumper 3-Amb Yorkfield 1-Pumper Tinley Park 3-Pumper North Park 2-Pumper Palos FPD 2-Pumpers Oak Brook 2-Pumpers I-Squad Orland Park 3 Pumper 3-Amb Homer 1- Pumper 1-Mini Pumper Oak Park 1-Pumper HiEx Foam trailer 1-Midi Pumper Wood Dale 1-Ladder JUL 30 '03 13:42 630 976 1604 PAGE.04 Jul 30 03 01 : 22P B & P RPPRRRTUS INC 630-978-1604 P. 5 B & P APPARATUS INC . 1552 BRYAN CT. ♦AURORA, IL. 60504 B P' Phone 630-978-1455 ♦ Fax 630-978-1604 Email-bnpapp@comcast.net WEB SITE:www.bpapparatus.com July 30,2003 PARTIAL REFERENCE LIST FIRE DEPARTMENTS ENGINES LADDER TANKER/SQUAD AMB East Joliet 1- Pumper 1-Tanker 2-Squad Braidwood 1-all terrain North Park 2-Pumpers Boone County 1-Pumper 1-Tanker Argonne 1-Quint North Palos 2-Pumpers Pingree Grove 1-Squad Evergreen Park 2-Pumper 2-Ladder 1-Mini Pumper Roselle Fire District 2-Pumper 1-Ladder 1-Pumper Tanker Bartlett 4-Pumpers 1-Amb Warrenville 1-Pumper Craig Hanson 1-Pumper 1-Platform Wheeling 3-Pumpers 1-Amb Evansville WI 2-Pumpers Footville WI 2-Tanker Wind Lake WI 1-Pumper/Tanker Wheaton 1-Pumper Elite Fire & Safety FL 16-Pumpers 3-Ladder 2-Squad 3-amb Marengo IL 1-Pumper Al Kaston & Son 4-Pumpers 2-Tanker/Pumper 3-Squad Cahokia IL 1-Pumper Manhattan 1-Pumper Polo IL 1-Pumper 1-Squad Nunda Rural 1-Pumper Broadview 1-Pumper 1-Squad Salem IL 1-Snorkel Cary IL 1-Amb Oak Lawn 1- Pumper Ottawa 1-Pumper Aaron Auto Broker 1-Pumper North Lake 1-Amb Romeoville 1-Amb Deerfield 1-Amb Peotone 1-Tanker 1-Amb Emergency Veh 1-Squad Dwight IL 1-Pumper Gordon Safety 1-Pumper 3-Skid Mid-America Truck 1-Pumper 1-Squad Mokena FD 1-Squad JUL 30 103 13:42 630 978 1604 PAGE.05 Jul 30 03 01 : 22P B a P APPARATUS INC 630-978-1604 P. 6 B & P APPARATUS INC . 1552 BRYAN CT. ♦AURORA, IL. 60504 B .P Phone 630-978-1455 1 Fax 630-978-1604 Email-bnpapp@comcast.net WEB SITE:www.bpapparatus.com July 30,2003 Palatine Rural 1-Tele Squirt Milton WI 1-Tanker Black Jack MO 1-Pumper Berkley MO 1-Pumper Monroe Center 1-Mini Pumper Mc Cook 1-Pumper West County MO 1-Pumper Naperville 3-Pumper Tuscaloosa FE 4-Pumpers Downers Grove 1-Squad Jeffersonville IN 1-Pumper JUL 30 103 13:42 630 976 1604 PAGE.06 Board Agenda Item Submittal xIV A Requested By: Raymond O Rigsby Entered By: Raymond O Rigsby Agenda Item Title: Authorization to Executive 2nd Year Option of 3-Year Custodial Service Contract. Date Submitted: Meeting Date Agenda Place Requested: Requested: Department: 08/13/2003 08/18/2003 0 Consent Agenda PW Regular Agenda 0 None Does this item Does this item include Will AV equipment be relate to another additional reference required to present item on the info separate from the this item to the agenda? Board packet? board? 0 Yes 0No 0 Yes 0No 0 Yes 0No Item Description Will this action involve an expenditure in 0 Yes 0 No Yes 0 No funds? Is this a budgeted item.? Projected total budget impact: $83,771 Additional Notes regarding Expenditures: Type the body of the cover memo here. Requests cannot be submitted if this field is blank. Staff respectfully requests that the Village President and Board of Trustees authorize staff to execute the 2nd year option of the 3-year Custodial Service contract. Attached is Bruce Czaplicki's memo dated August 13, 2003 and a copy of the Bid Forms dated May 27, 2002 for your information. Contract Cleaning Maintenance, Inc. proposed adjusted unit costs to reflect a 2%increase in the FY 03-04 contract; the total budget impact is $83,770.56. Letter-Sized Legal-Sized Ledger-Sized Odd-Sized Attached Files Attached Files Attached Files Attached Files 73 1 custcon.pdf Approval Section: Name: Date and Time: Submitted By: Pre-Approved By: Approved By: Published to Web: TO: William R. Balling FROM: Raymond O. Rigsby DATE: August 13, 2003 SUBJECT: AUTHORIZATION TO EXECUTE 2nd YEAR OPTION OF 3 YEAR CUSTODIAL SERVICE CONTRACT I concur with Bruce Czaplicki's recommendation and request that the Village President and Board of Trustees authorize staff to execute the 2nd year option of the 3-year Custodial Service contract. I have attached Bruce Czaplicki's memo dated August 13, 2003 and a copy of the Bid Form dated May 27, 2002 for you information. Contract Cleaning Maintenance, Inc. proposed adjusted unit costs to reflect a 2% increase in the FY 03-04 contract. I request that this item be placed on the August 18, 2003 agenda for Village Board consideration. If you have any questions, please let me know. Rally ion id irk Rigsby attachments k:/building custcont/2ndyearauth.doc TO: Raymond O.Rigsby Superintendent of Public Works Operations FROM: Bruce Czaplicki Building Maintenance Supervisor DATE: 13 August 2003 RE: CUSTODIAL SERVICES CONTRACT Contract Cleaning Maintenance,Inc.has provided us a very satisfactory level of service during fiscal year 2002/2003. I would recommend retaining them on the second year option for 2003/2004, With the second year option increase of two percent,the total contract for 2003/2004 is $83,770.56. I3�ce zapl cki 13ID FORM 1 GENLR-= L The undersigned, having carefully examined the Contract Specifications, all data made available and having visited the facilities of the work and having become fully informed as to all existent conditions and limitations, including the obstacles which may be encountered, local restrictions, and all other relevant matters concerning the work to be; performed, hereby proposes to perform everything required to be performed, and to provide all the '�''or, materials, necessary tools, expendable equipment, all applicable taxes, fees and bonds, and provide all utility and transportation services necessary to perform and complete in a workmanlike manner the work indicated hereinafter: Contract Custodial Services of same in conjunction with and in accordance with the Contract Specifications as prepared by the Village of Buffalo Grove, 50 Raupp Boulevard, Buffalo Grove, Illinois. A) BID - Custodial Services Public Service Center One thousand one Hundred fifty Dollars (S 1 , 150 : 00 )iNfonth. B) BID - Custodial Services Village Hall nnp thn„sang three Hundred fifty Dollars (S 1 , 350 . 00 )/-Month. C) BID - Custodial Services Youth Center Two Hundred------------------------------ 200 . 00 dollars (S_ )/tilorth. D) BID - Custodial Services Police Headquarters Three thousand one hundred nineteen Dollars (S 3 , 119 . 00 )/Month. E) BID - Custodial Services Fire Administration Building -six u„ndl-ed------------ ----_______— Dollars (S 600 . 00 )/Month. F) BID - Custodial Services Metra Commuter Station Two Hundred Fourty------------------------Dollars S 2 1t 0 . 0 0 ( _ )/vlonth. G) BID - Custodial Services Pace Bus Driver Facility Qne Hundred eighty five------------------Dollars (S 185) . 00 )/Month. 13 „,,,,,,. woos 'rw.wruoM�wr uuur rrm uuarumwro. i N�n,wwr BID FORM "� lu�� r, irroua�h � � -4> 7�003 Total Contract Cost FY 02-03 °d Year Option the unit prices as shown above shall be ��, � 01 NI I adjusted by.?,5 percent 1. 200 — . , . 2004 Total Contract Cost FY 0 -04 3'' Year Option the unit prices as shown above shall be adjusted by 2% i_ J _ percent (-, ) I S P °' tda 1. 2004 2005 Total Contract Cost FY 04-05 5. REJECTION AND WITHDRAWAL OF BID: In submitting this Bid, it is understood that the right is reserved by the Owner to reject any and all Bids and to waive any informalities in the Bids. It is agreed that this bid may not be withdrawn for a period of sixty (60) days from the opening thereof. 6. TIME OF COMPLETION: If a-warded the Bid, the undersigned agrees) to perform same in a professional manner as specified in the Contract Specification. 7. BID DOCUMENTS: The term "Contract Specification” is hereby defined to mean those documents containing the Bid Requirements and other Contract Documents listed in the Table of Contents. The Contract Specification is hereby made a part of this Bid Form. upon successful award of the Bid, the Contractor shall enter into a contract with the Owner. 14 13ID FORM The undersigned acknowledges that the Village rnav adjust the stated bid by acjustirg quantities per the stated unit prices. The contractor shall be responsible for taking all measurements required to perform the work. It is agreed that the Proposal is for the total work not withstanding any error made in the contractor's measurements. Firm Name: -Contract Cleaning Maintenance , Inc . Telephone: 847-4R3-51 nn Official Address: 51 0 0 N wPort- Dr 4 h cT Meadows , TT,_ 6 o o 8 By: Signature Date: 5-27-02 Where Contractor is a Corporation, Add: Illinois Attest: Secretary (Seal) Date: 5=2 7-0 2 15