The URL can be used to link to this page

Home My WebLink About3. BILLS & FINANCIALS VILLAGE OF MOUNT PROSPECT CASH POSITION April 27 - May 09, 2007 Cash & Invstmt Receipts Disbursements Other Cash & Invstmt Balance 04/27/07 Per Attached Credits/ Balance 04/27/07 05/09/07 List of Bills Debits 05/09/07 General Fund 8,983,309 1,840,374 257,813 10,565,870 SDecial Revenue Funds Refuse Disposal Fund 1,902,599 27,550 215,416 1,714,733 Motor Fuel Tax Fund 1,265,118 133,692 299,375 1,099,435 Local Law Enforcement Block Grant Fund 4,550 4,550 Community Development Blk Grant Fund 109,064 80 108,984 Asset Seizure Fund 79,275 900 80,175 DEA Shared Funds 50,024 50,024 DUI Fine Fund 38,538 38,538 Foreign Fire Tax Board Fund 52,692 52,692 Debt Service Funds 2,063,528 95,587 354,136 1 ,804,979 CaDital Proiects Funds Capital Improvement Fund 868,943 58,252 810,691 Downtown Redevelopment Const Fund 1,997,813 5,154 1,992,659 Street Improvement Construction Fund 1,634,797 98,305 1,733,102 Flood Control Construction Fund 637,274 637,274 EnterDrise Funds Water & Sewer Fund 4,838,199 299,563 203,745 4,934,017 Village Parking System Fund 76,285 2,415 1,823 76,877 Parking System Revenue Fund ( 13,329) 1,954 5,304 (16,679) Internal Service Funds Vehicle Maintenance Fund 436,944 28,558 408,386 Vehicle Replacement Fund 6,467,006 126,316 6,340,690 Computer Replacement Fund 762,390 762,390 Risk Management Fund 2,520,291 48,965 75,187 2,494,069 Trust & Aaency Funds Police Pension Fund 40,848,898 8,113 40,840,785 Fire Pension Fund 40,846,190 7,618 40,838,572 Flexcomp Trust Fund 23,975 128 22,827 1,276 Escrow Deposit Fund 1,690,414 34,678 29,671 1,695,421 118,184,787 2,584,111 1,699,388 119,069,510 EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY MAY092007 17: 09 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 - -.. ~ --.......... --- --...... ---.............-........ --.................................. --......- ---.......... ----.................. --..- -- --...... -- --.... ---......................... ---.... --.. --.................- DEPT VENDOR NBR VENDOR NAME INVOI CE DESCRI PTI ON AMOUNT .................... --...... ---.......... --- --............................ --.................. -- ..---........ --.................. --.. --...... -- ----........ --...................... --.......... ---...... ...... ---...... --.. 101 08695 2/90 SIGN SYSTEMS 16 - DISPLAY FRAMES 1155.20 FREIGHT 15.00 ADDL CHARGE 15.66 ------o...----- 1185.86 01071 ADDISON BUILDING MATERIAL CO. BUILDING & HARDWARE SUPPLIES 57.20 BUILDING & HARDWARE SUPPLIES 108.66 BUILDING & HARDWARE SUPPLIES 11.65 ------------- 177 . 51 10119 ADVANCED ORTHOPEDIC & SPORTS INJURY CTR,LTD. LEGAL-GENERAL COUNSEL 750.00 CONSULTING SERVICES-MOREL 5000.00 ------------- 5750.00 01227 AIR ONE EQUIPMENT, INC. 6 HAZMAT TRAINING SUITES .RS58 690.00 SHIPPING CHARGES 34.08 ------------- 72 4.0 8 01246 AIRGAS NORTH CENTRAL OXYGEN CYLINDER RENTAL 192.12 01335 ALEXIAN BROTHERS MEDI CAL CENTR BLS INSTRUCTOR CARDS 7.00 01561 AMERICAN CHARGE SERVICE SENIOR TAXI PROGRAM 75.90 01699 AMERI CAN PUBLI C WORKS ASSOC. REGISTRATION FEE FOR WEB-CAST 150.00 10095 AMSAN, LLC SUPPLIES FOR COVERTAMATIC FLOO 658.35 01833 ANDERSON LOCK COMPANY OPEN & REPLACE KNOB LOCK 170.10 BUILDING MATERIALS 76.47 ------- ------ 246.57 00372 ANDLER, GLEN REIMBURSEMENT FOR CDL RENEWAL 50.00 08566 ANDREWS, JOHN H. REFUND SENIOR RATE 24.00 10113 ANZALONE, ANGELO REIMBURSE EXPENSES 142.40 01973 APt/A CHI CAGO METRO CHAPTER REGISTRATION FEE FOR SNOW PLOW 240.00 02001 ARAMARK UNIFORM SERVICES I INC. UNI FORM EXPENSE MECHANICS 79.44 10108 ARS OF ILLINIOS BUILDING REFUND 25.00 BUI LD ING REFUND 25.00 ------------- 50.00 01124 ARTHUR CLESEN, INC. RONSTARG (2 BAGS) WEED KILLER 172.00 SNAPSHOT (2 BAGS) WEED KILLER 184.50 --------- __a. IPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY HAY092007 17: 09 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 ... __ __........ _w___.. __.... _..__.. __ ___...... ___.. __ __.... __........................ __.................. ____...._.................................................. ___............. .._..... __ __ __ ___.._............ JEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ................................. --...... ----.. --........................................ --.. --........ ---.................. ---............ --........ --.. -...... --...... -oO.......... ___ __........ ____ __.......................... 356.50 02848 ARTHUR WEILER, INC. SPRING PARKWAY TREE PLANTING 5950.00 SPRING PARKWAY TREE PLANTING 2500.00 SPRING PARKWAY TREE PLANTING 327.50- ------------- 8122.50 02270 AT&T SERVI CE 290.85 10128 BALDINI, CAROL REFRESHMENTS 40.53 08566 BERGER, M.J. OVERPAYMENT 36.00 05339 BOUND TREE MEDICAL, LLC 3 Replacement Batteries for 204.75 05774 BOUNDTREE MEDI CAL, LLC. Paramedic Equipment, AED's, 10294.28 00477 BURES, PAUL CLOTHING ALLOWANCE 92.63 REIMBURSEMENT 64.16 .........---........-- 156.79 01014 CADE INDUSTRIES CUSTODIAL SUPPLIES 3332.90 CUSTODIAL SUPPLIES 64.20 -....-----......-- 3397.10 05707 CASH AUDIT FOR ERIC SCHMITT SOUTH C 100.00 01049 COW GOVERNMENT, INC MS ISA SERVER STD 2006 FOR 1612.96 ANNUAL SMARTNET FOR CISCO 1721 98.00 ANNUAL SMARTNET FOR CISCO 2811 380.00 ANNUAL CISCO SMARTNET FOR CISC 1218.00 1 VGA/AUDIO CABLE - 351 1 SONY 196.52 1 DVO/VCR FOR STATION #12 102.99 ------------.. 3608.47 09682 CE DESIGN,LTD. PLAT OF EASEMENT FOR EMERSON 228.00 05375 CENTURY CLEANERS UNIFORM CLEANING 151.53 03800 CLARK, SANDRA M. REIMBURSEMENT-TRAVEL/POSTAGE 6.00 REIMBURSEMENT - TRAVEL/POSTAGE 3.12 REIMBURSEMENT-TRAVEL/POSTAGE 26.37 REIMBURSE- LUNCH/TOLL EXPENSES 60.04 REIMBURSEMENT FOR COL RENEWAL 50.00 -..............---.... 145.53 01138 COLLEGE OF DUPAGE REGISTRATION 300.00 01147 COMMONWEALTH EDISON 133 0 - 4 0 II CENTRAL - ACCOUNT 197.08 01153 COMMUNITY CAB CO. SENIOR TAXI PROGRAM 416.75 ;PORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY HAY092001 11: 09 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2001 TO MAY 09 2001 .... -............ --...... --....-.. --.. --.. --.. --............ --............... --........................ -- --........ --- --.... --.. -- --.. -- --.......-.............. ...-- --.... -----........ --.... ....-..- --........ lEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -.................. ---........................ --.............. ---.. --.......- --...-.......... --.............. --................ --.... --.. --........-.. --........ --............... .----.........- -_...................-........-- 06345 CONSERV F/S, INC. PENDULIUM 2G HERBICIDE 18.40 00309 COONEY, WILLIAM J. MILEAGE REIMBURSEMENT 184 .23 04543 CORPORATE EXPRESS MISC. OFFICE SUPPLIES AND TONER 225.68 07530 DAVE'S SPECIALTY FOODS CATERING SERVICE MAY 15,2007 260.00 01287 DOOR SYSTEMS, INC. SERCI CIE TO ELEVATED DOOR. P . SA 437.41 SERVI CE TO OVERHEAD DOOR . 4/1 749.41 ------.----..- 1186.82 10045 DR.MICHAEL GITELIS LEGAL - GENERAL COUNSEL 250.00 06045 EARTH INC. 3 SEMI LOADS OF PULVERIZED TOP 675.00 08566 EDMONDS, DONNA OVERPAYMENT 12.00 01340 EMBASSY COFFEE SERVICE COFFEE AND SUPPLIES 72.30 05843 ENH OMEGA PHYSICAL EXAN:J .DAHLBERG 91.00 01356 ENVIRONMENTAL SAFETY GROUP, INC TURNOUT GEAR REPAIR 151.60 01317 FEDERAL EXPRESS CORP DELIVERY 13.70 DELIVERY 13 .51 ------------- 27.21 10112 FILIPEK, SCOTT REIMBURSE EXPENSES 142.40 01422 FOLGERS FLAG & DECORATING, INC STREET BANNER INSTALL/HOWE 1275.00 08573 FORTE PROPERTIES, INC. REAL ESTATE TAX VOID 825.00 00337 FOWLE, LAURA REIMBURSE- PURCHSE OF LABELS 18.09 09159 FRANCES, WILLIAM REIMBURSE EXPENSES 154.00 01031 FRED PRYOR SEMINARS REGI STRATI ON FEE 149.00 04537 GALETON GLOVES 25 DOZEN - 90Z BROWN JERSEY GL 103.48 01461 GALL'S, INC. MAG CHARGER SLEEVES 77.46 08566 GONEH, JESSICA REFUND 36.00 08566 GRAHN, RAY OVERPAYMENT 36.00 01522 GRAINGER INC. UPRIGHT VACUUM BRUSH ROLL 28.67 05519 GRAPHIC ENTERPRISES ANNUAL INSPECTION AND MAINTENA 742.00 00341 GRIFFIN, TIMOTHY REIMBURSE EXPENSES 36.00 01559 HANSEN INFORMATION TECHNOLOGY HANSEN 8 MI GRATI ON 3179.73 ~PORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY HAY092007 17: 09 RELEASE ID : PAGE VI LLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 ................... --- --.. ---.. ---........ --- --.................... --.................... --......-................ --.. --.. --.......... --...... ---...... ---........ -......... --- -...... -- -...... --.... ......- ---.... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .................... -- -- -- ---.. -.. -- --.. --.. --.. --........ --...... --...... ---.. --........ -- ..-_.... --.... --.. ---...... --................................................... --.................... -.... --........ -.... QUARTERLY MAINTENANCE 11700.00 -------..----- 15479.73 09521 HARRIS C(Xr!PUTER SYSTEMS INC. ANNUAL MAINTENANCE 30232.00 09205 HEALTH ENDEAVORS EVALUATION-SCHWEGLER 50.00 KNOLL/STUCKEY/HUNT 431.00 ---------......... 481. 00 09113 HEALY ASPHALT COMPANY,LLC. PATCHING MATERIAL 643.87 14.40 TONS OF UPM - PATCHING 1580.76 ------..---.....- 2224.63 01578 HENDRI CKSEN, ROBERT Ii. WINTER TREE TRIMMING PER - PER 8064.00 08566 HOLLAND, THOMAS G. OVERPAYMENT 24.00 01610 HOME DEPOT CREDIT SERVICES MISC. HARDWARE AND SUPPLIES 83.00 09425 HSBC BUSINESS SOLUTIONS INV#062042 26.99 CAKE INV#013392 15.99 INV#027562/037384 90.62 INV#027057 80.87 ------------- 214.47 01689 I GFOA TRAVEL & MEETINGS 210.00 01686 IL FIRE SERVICE INSTITUTE CONFINED SPACE OPERATIONS TOM 725.00 10059 ILIENT LTD. ILIM SYSAID HELPDESK SOFTWAR 449.00 10126 ILLINOIS FIRE SERVICE ADMIN. PROFESSIONALS 2007 MEMBERSHIP-LIZ HEREDIA 55.00 MEMBERSHIP- NELSON, NINA 55.00 ------------- 110.00 07433 IMAGETEC LP ID#90133759827 275.00 ID#90133759828 356.00 MONTHLY LEASE PAYMENT FOR TOSH 236.00 COPIER LEASE PAYMENT FOR FEB-D 586.13 -----..-.._---- 1453.13 10054 INSTITUTE FOR PARTICIPATORY MOO & PLNG 1 {Advisor Committee's Trainin 315.00 07694 INTERNATIONAL CODE COUNCIL PLAN REVIEW INSTITUTE 1360.00 01753 IPELRA Registration/04 (20) Attendees 1500.00 10101 ISTOCKPHOTO INTERNATIOINAL INC. IMAGE IiEB SITE CREDITS 120.00 00354 JANOIiICK, TIMOTHY REIMBURSE EXPENSES 25.00 ;PORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY MAY092007 17 :09 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 ....... - _a.. __ ___.............. --.......... ---............ --.......................................... -- --............-.......... --..-.. --.......... ---..-.. ..-- -- ---- --.......... -- --.....................-.......-..-- JEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ................... ...---............ --.. --..-.................. ---.....-.... ---...-.... --...... ---...-.....-.. --..-...........................-.. ---.......... --.............-.................. --.......... ...--.... --.. ..-_..-- 01783 JOURNAL & TOPICS NEWSPAPERS HOSE BID AD 90.36 05656 KANUPKE, JOSEPH REIMBURSE EXPENSES 24.00 01818 KERSTEIN, JUNE BLOOD DRIVE REIMB. 51.60 06995 KGI LANDSCAPING SPRING PARKWAY TREE PLANTING 5525.00 SPRING PARKWAY TREE PLANTING 2977 . 50 ....----------- 8502.50 04802 KING KONCRETE, INC. CONTRACTUAL SNOW PLOW SERVI CES 5175.00 01838 KRAMER TREE SPECIALISTS 2007 TREE REMOVAL CONTRACT 2880.00 01851 LAB SAFETY SUPPLY ET SUPPLIES 135.50 10076 LABARBERA, RICHARD REIMBURSE EXPENSES 142.40 07297 LAKE COOK LAND SURVEY PREPARE PLAT 400.00 08631 LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEANI 247.58 05678 LEIB, JASON CLOTHING ALLOWANCE 135 . 90 08566 LISOWSKI, MARK P. REFUND 24.00 01918 LUNDSTROM I S NURSERY, INC. LANDSCAPING MAINTENANCE THROUG 6690.56 TURF MOWING AT VARIOUS LOCATIO 3063.81 REPAIR PLOW DAMAGE THROUGHOUT 3000.00 REPAIR PLOW DAMAGE THROUGHOUT 500.00 --------..---- 13254.37 01922 LYNN PEAVEY COMPANY ET SUPPLIES 96.94 08566 MAGIERSKI, ALLAN OVERPAYMENT 36.00 06844 MALCOLM X COLLEGE REGISTRATION 250.00 01941 MALCOLM, JOHN EXPENSES - 04 MALCOLM CONFERENCE 272.95 EXPENSES 243.40 ------------- 516.35 08731 MALKO ELECTRI C CO. SERVICE TO PLX-500 BOARD ON 945.00 01965 MARTAM CONSTRUCTION CONTRACTUAL HAULING OF SNOW 2/ 4585.00 CONTRACTUAL HAULING OF SNOW 2/ 2640.00 --..---------- 7225.00 08894 MEETINGHOUSE COMPANIES, INC. RENTAL OF DECOR 2714.75 05021 MENARDS MISC. BUILDING AND HARDWARE 35.84 MISC. BUILDING AND HARDWARE 59.79 LASER TAPE AND ALKALINE BATTER 37.86 EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY MAY092007 17:09 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 PAGE DEFT VENDOR NBR INVOICE DESCRIPTION -- -oo - __........_.... __.......... __ __.. __.... _.................. __.. __...... __.. __.. __ ___.. __ __.. ___.. _...... ____............ __.. _____...... __......... ___...... __.. _.......... __................ _.. _.... AMOUNT VENDOR NAME .. --- ---.... -- --_..-...... -- -- -.... --..oo _.. __ __ __........... ___ _oo.. ......... _............... ....._ __.... ___.......... __........ ___.. _.... __.... __.. __........................ __.... _oo_.... __ _.. ___........ 06719 METEORLOGIX RENTAL OF WEATHER MONITORING 01058 HEYER LABORATORY, INC. CUSTODIAL SUPPLIES 00395 MICHALIK, JOEL REIMBURSEMENT 09523 HI CRO TECH SYSTEMS, INC. TECHNICAL SERVICE TO HP5500DTN 04322 MIDDLETON, JOAN OFFICE SUPPLIES MITEL PONE DEMO 02018 MIDWAY TRUCK PARTS BATTERY 02028 MI GHTY HI TES AWARDS & SONS ENGRAVED PLAQUE-ANDY GOMEZ RET 02046 MOBILE PRINT INC. NOTE SHEETS BUSINESS CARDS PHARMACEUTICAL DRILL 08025 MORTON SUGGESTI ON CO. BASEBALL HATS 09912 MOUNT PROSPECT PAINT, INC. PAINTING MATERIALS PAINTING MATERIALS 02148 NEOPOST INC. POSTAGE LABELS & INKJET MONEY ENTERED INTO POSTAGE MAC 02170 NORTH EAST MULTI REGIONAL TRNG REGISTRATION LAWS OF ARREST & SEIZURE IN HO 02182 NORTHERN ILLINOIS POLICE ALARM SYSTEM LANGUAGE LlNE-FEB,07 02189 NORTHWEST CENTRAL DISPATCH SYS SERVICES RENDERED JUNE 2007 SERVICES RENDERED JUNE 2007 02190 NORTHWEST COMMUNITY EMS DEFT ADMINISTRATIVE FEE ANNUAL IT SUPPORT 07039 O.C.TANNER RECOONITION CO. GOMEZ RETIREMENT GIFT 133 .49 807.00 403.19 51.76 492.95 37.98 8.90 46.88 41.24 113.60 33.62 26.17 143.20 202.99 1776.96 4.30 14.02 18.32 203.00 3000.00 3203.00 100.00 807.78 907.78 1ll.00 39390.57 9847.60 49238.17 3328.00 2000.00 5328.00 169.78 ~EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY MAY092007 17: 09 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 ..... --.....-.. .--........ --.... --.. --.. --........ ---.............. --.. ----........ ..---............. ----.... ---........ ---... --....- --....- --....- ---........................ --..... -_......................_- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .......... --.. --.... --.............. ---..-................ --.............. --.... ---...... --..........-.. ---..............-.. --...... -- --...... -.... .....-....... .._-..- --........ --........ --.... ----...................... 10003 OFFlCETEAM TEMPORARY EMPLOYEE 800.88 TEMPORARY EMPLOYEE 645.00 ---- -------.... 1445.88 10114 OLA, ANTHONY REIMBURSE EXPENSES 142.40 02256 PADDOCK PUBLICATIONS, INC. PUBLICATION OF BID NOTICE 33.75 PUBLICATION OF BID NOTICES 109.60 ------------- 143.35 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS 36.13 MI SCELLANEOUS 163.61 MI SCELLANEOUS 21.68 MI SCELLANEOUS 39.00 MISCELLANEOUS 59.43 MISCELLANEOUS 20.00 MISCELLANEOUS 30.00 MI SCELLANEOUS 21.00 MISCELLANEOUS 5.00 MI SCELLANEOUS 7.02 MI SCELLANEOUS 3.22 MISCELLANEOUS 127.83 .. --- --- ------ 533.92 02304 PETTY CASH - POLICE DEPT. TRNG/TRAVEL&MTGS/EMP. TESTING 80.00 TRNG/TRAVEL&MTGS/EMP. TESTING 50.00 TRNG/TRAVEL&MTGS/EMP. TESTING 34.00 TRNG/TRAVEL&MTGS/EMP. TESTING 10.00 TRNG/TRAVEL&MTGS/EMP. TESTING 34.61 TRNG/TRAVEL&MTGS/EMP. TESTING 12.31 TRNG/TRAVEL&MTGS/EMP. TESTING 60.81 ------------- 281.73 02315 PIONEER PRESS RENEWAL SUBSCRIPTION 21. 95 08566 PLATT I THOMAS OVERPAYMENT 12.00 09005 POSITIONING SOLUTIONS CO. REPAIRS TO SPECTRA LASER HR500 439.30 MARKING PAINT 33.00 ------ ------- 472.30 02334 POSTMASTER POSTAGE STAMPS 50@$8.20/EA 410.00 08566 POWER, JOHN OVERPAYMENT 24.00 06592 PRO-TECH SECURITY SALES CAMERA ADAPTER ASSEMBLY 56.50 02536 PROFORMA CUSTOMIZED GRAPHICS OPEN HOUSE GlVE-A-WAYS 139 .3 7 OPEN HOUSE GIVE-HAYS 222 4.5 8 --- -------..-- 2363.95 EPORT: APBOARDRPT GENERATED: 09 AUG 06 16: 39 RUN: WEDNESDAY MAY092007 17:09 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 ~.. a................................... ___ __.. __........ __.......... __.........._ __ ___ __.. __........................ __ __.. __ __.. __ __.............. ___ __ __...... __ ___...... __.... ___................. ___......__ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .......... -oO...... _____.... ---__.. __.. __ __ __.................. __.......................... __... __ __........ __ _.. __ _.............. ___.... ____....... ___................. ..__ ...__.... _..... __............ __ __........ 08509 PROPERTY INSIGHT TRACK SEARCH-700 & 702 IVANHOE 60.00 08711 QUALITY MAINTENANCE SYSTEMS, INC. 2007 CONTRACT FOR CUSTODIAL SE 8276.8 5 02379 QUILL CORPORATION MISC OFFICE AND TONER SUPPLIES 269.95 01288 R.A.DORAN & ASSOCIATES REGISTER c.cALDWELL 295.00 08566 RAPACZ, WANDA REFUND 36.00 02429 RIC MAR INDUSTRIES, INC. 1 CASE - HARMONY (SOAP) 127.34 09277 ROSEN, JUDY BOWLING PARTY 194.62 10056 SAFETY INCORPORATED Chemical Sui ts 1070.62 08566 SCHUETTNER, ERI CA OVERPAYMENT 24.00 02525 SECRETARY OF STATE TITLE AND PLATES 143.00 PLATE STICKER RENEWAL 78.00 ------...._---- 221.00 09058 SELEEN, WENDY PHARMACEUTICAL DRILL 69.96 10124 SHRIBER, JOHN REIMBURSE FOR COST SHARE FEES 100.00 02546 SIDWELL COMPANY COOK COUNTY LEASE ATLAS - VOLU 482.50 05019 SILL, GREGORY REIMBURSE EXPENSES 80.00 02587 SOUTHERN KANE COUNTY TRNG ASSC REGISTER -JAMES EAST 50.00 08030 SOUTHtlEST UNITED FIRE DISTRICTS THREE OFFI CER DEVELOPMENT CLAS 150.00 04139 STANARD & ASSOCIATES PERSONNEL RECRUITMENT 800.00 09165 STAPLES BUSINESS ADVANTAGE CUSTOM STAMP 24.50 40 CARTONS OF PAPER 413.20 40 CARTONS OF PAPER 413.20 40 CARTONS OF PAPER 413 .20 -----------..... 1264.10 02622 STATE OF ILLINOIS ANNUAL BOILER INSPECTIONS PURL 210.00 02627 STEINER ELECTRIC COMPANY STREETLIGHT REPAIR SUPPLIES 565.29 02632 STERLING CODIFIERS, INC. SUPPLEMENT #22 4608.00 02660 SUBURBAN PRINTING ASH BORER INSPECTION DOOR TAGS 141.00 9" X 12" POLY BAGS "TREE CITY" 1060.00 PRINTING OF OPEN HOUSE POSTERS 129.00 ----------..-.. 1330.00 05328 SUPERIOR OVERHEAD DOOR CO. 16" OF AIR HOSE 56.00 .EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY MAY092001 11 :09 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 21 2007 TO MAY 09 2007 -.. --.. --.......... --..-........................ --- --.............. -- ..---..-.....-.......... --................ --.................. --...... --............- ----........................................-....-...................... DEPT VENDOR NBR VENDOR NAME INVOI CE DESCRI PTI ON AMOUNT ............-....- ---...................... --.. --............ ...--........................................................... --....................-.........-.. ---....... --................................ --.......... --...... --............ REPLACE/REPAIR BOTTOM AND TWO 3135.50 -- ----------- 3191. 50 02684 TERRACE SUPPLY COMPANY Paint Supplies Amb#523 and Mis 561. 09 10118 THE HOSPICE OF NAPLES DONATION TO HOSPICE OF NAPLES 50.00 02691 THOMPSON ELEVATOR INSPECTIONS ELEVATOR INSPECTIONS 3256.00 09552 THORNE, JUDY POTLUCK DINNER SUPPLIES 59.62 08841 TOEPPEN, RACHEL POTLUCK DINNER SUPPLIES 9.09 lOon TRI PLE CROWN SUPPLY WHEELCHAIR REPAIR 30.00 08566 TRISTAN, BERTHA OVERPAYMENT 24.00 08779 U KEEP US IN STITCHES, INC. GIFTS FOR VOLUNTEER APPRECIATI 935.53 10055 U . S. FOAM TECHNOLOGIES, INC. Training Foam Super Concentrat 1731.15 05686 ULINE INC. 4 PK DVD-R'S 82.21 08821 UNIFORMITY INCORPORATED LIEUTENANT BUFFALO INITIAL 159.95 04813 UNITED RENTALS HIGHWAY TECHNOLOGIES HOLDING 35'MESH TRAFFIC SIGN 265.47 04025 UNIVERSITY OF ILLINOIS REGISTER-TOM WANG 725.00 10115 US I EDUCATION & GOVERNMENT SALES 2 ROLLS OF LAMINATE 109.99 05783 VALENTINE, PAUL EXPENSES 52.00 10116 VILLAGE OF HANOVER PARK HANOVER PARK TICKET TAKEN IN E 30.00 02821 VON BRIESEN & ROPER,S.C. CURRENT FEES 385.00 01229 W.S. DARLEY CO. Multiple Adapters and Fittings 1318 .13 10117 WALCZAK, DARIUSZ PLAN REVIEW FEE REFUND 25.00 08566 WATERS, DANIEL OVERPAYMENT 36.00 09881 WHEATLEY I MARY ELLEN SUPPLI ES FOR PROGRAM 43.07 10044 WINDY CITY ORTHOPEDICS & SPORTS MEDICINE LEGAL-GENERAL COUNSEL 4800.00 05248 XPEDX STORES DIVISION MISC. OFFI CE SUPPLIES 139.90 TOTAL 257813 .46 030 02016 ARC DISPOSAL COMPANY APRIL COLLECTIONS 77254.95 APRIL COLLECTIONS 13728.23 APRIL COLLECTIONS 46164.54 APRIL COLLECTIONS 31470.05 EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY HAY092007 17: 09 RELEASE ID : PAGE 10 VI LLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 DEPT VENDOR NBR .............................. --.... --.... --- -..-.. --.............. -- ---......... --........ --.. --.......... --_............ -.... --.....- ..-.................. -- --......... -...-...................... --........-.. -- -.......... AMOUNT VENDOR NAME INVOICE DESCRIPTION . --.................. -.... ---.. --...... ---.................. --........ --........ -- ..-.. ----.... --................................ --......................- ---.............. --........................ --..................... ---.. 09625 02536 050 02167 01148 04355 05709 01718 05211 070 02301 08509 180 APRIL COLLECTIONS APRIL COLLECTIONS APRIL COLLECTIONS 5396.54 322 5.9 5 37422.00 214662.26 H.H.H. INC. 6' X 8' YARD MATERIAL DECALS - 261. 34 PROFORMA CUSTOMI ZED GRAPH I CS OPEN HOUSE GlVE-A-WAYS OPEN HOUSE GlVE-A-WAYS 29.06 463.80 492.86 TOTAL 215416.46 ARROW ROAD CONSTRUCTION 2007 STREET RESURFACING PRCllEC 256547 .10 COMMONWEALTH EDISON ACCT#22430-55005 MUNICIPAL STR ACCT#08170-84003 STREET/TRAFFI 8135.20 3749.92 11885.12 COOK COUNTY TREASURER MAINTENANCE OF TRAFFIC SIGNALS 147 5.2 5 MEADE ELECTRIC CO. INC. 2007 TRAFFIC SIGNAL MAINTENANC 1269.43 NORTH AMERICAN SALT COMPANY 530.05 TONS OF ROAD SALT DELIV 23672.04 STATE TREASURER VILLAGE SHARE OF TRAFFIC SIGNA 4526.16 TOTAL 299375.10 PETTY CASH - FINANCE DEPT. MISCELLANEOUS 20.00 PROPERTY INSIGHT ORDER #9635766 994 WHEELING RD 60.00 TOTAL 80.00 09852 BANK OF NEW YORK 190 BANK PAYING AGENT FEES 300.00 2001 91582.50 -_.._-------..- 91882.50 TOTAL 91882.50 2003 215796.88 TOTAL 215796.88 GO BOND INTEREST DUE 6/1/07 1397.50 TOTAL 1397 . 50 09852 BANK OF NEW YORK 350 09852 BANK OF NEW YORK IPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY MAY092001 17:09 PAGE 11 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 .. - -... -.........................- ----.......... ---............................................ ---...... --................. --........-...... .....-.......... ...-_.. --...... --.... --........ --- ..---.............. --............ --.................. )EPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .......... --...... ---.. -- --... --.......... --.................. --......... --..............................-........-........ --......... --........ ---..... ...-- --- --............................................ --................. -- ---....... -_...........-- 50 09852 BANK OF NEW YORK GO BOND INTEREST DUE 6/1/07 3987.50 TOTAL 3987.50 90 09852 BANK OF NEW YORK GO BOND INTEREST DUE 6/1/07 41071.25 TOTAL 41071.25 10 01580 HENRICKSEN & COMPANY, INC. ADDITIONAL TRACK MOUNTED 2452.26 ADDITIONAL GUEST CHAIR 611. 52 FIRE DEFT FURNITURE 9412.11 MODULAR FURNITURE SYSTEM 9988.87 ------------- 22464.76 05007 LANDMARK FORD (11) 2007 FORD CROWN VICTORIA 27387.45 06406 SENTE RUBEL BOSMAN LEE, LTD FACILITES STUDY PROJ 0613 9 8400.00 TOTAL 58252.21 50 09918 LAUBE CONSULTING GROUP LLC FINANCIAL ADVISORY WORK RELATE 1881.00 02084 MUNDIE & CO. APPRAISAL SERVICES 2500.00 05777 V3 COMPANIES STREETSCAPE DESIGN SERVICE 772.71 TOTAL 5153.71 10 04391 ALEXANDER CHEMI CAL CHLORINE CYLINDER RENTAL (9 UN 180.00 01620 AMERICAN LANDSCAPING INC. PARKWAY RESTORATION AT VARIOUS 7964.50 PARKWAY RESTORATION AT VARIOUS 4508.20 ------------- 12472.70 01773 AMERI CAN WATER WORKS ASSOC. REGISTRATION FEE FOR SEAN DORS 275.00 02451 BADGER METER INC COMPOUND TURBO WATER METERS 3846.66 WATER METER REPAIR PARTS 349.79 24 - M25 5/8' WATER METERS 739.46 4 - 2" WATER METER WITH TRACE 1806.59 2 . BATTERY PACKS 317.02 FAST PACK CHARGER ASSY. 238.00 -----..------- 7297.52 06476 BURNS & MCDONNELL ENGINEERING DISINFECTION BIPPRODUCT 26288.08 01049 CDW GOVERNMENT, INC KINGSTON 512MB MEMORY DDRm 91.99 ,EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY MAY092007 17: 09 PAGE 12 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 -............. ~...... --........... --............. -..... --................ --............ --........................................ --.. ---.................. -- --........ ....... -- --.... .....-..- ---..................... -..-................. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ........ -............. -.... --.... --. ---.. ..--- ---.. ---.......... -................................. -................... --...... -... --.... ..-............. --.... -- --............. ...-........... -.. ----.. -..... --........ -... ---.. 09682 CE DESIGN/LTD. PROFESSIONAL SERVICES FOR PROS 15267.45 05375 CENTURY CLEANERS UNIFORM CLEANING 151.52 08567 CHlEBOWSKI/PAULA REFUND FINAL UTILITY BILL 26.45 04543 CORPORATE EXPRESS MISC.OFFICE SUPPLIES AND TONER 225.68 08567 CUTRO, GEORGE REFUND FINAL UTILITY BILL 34.08 01323 EAST JORDAN IRONWORKS 4 - 1050Z 12' SLEEVE ADAPTER S 700.00 09572 ELAN TECHNOLOGIES / INC. SANITARY SEWER FLOW MONITORING 36436.00 01377 FEDERAL EXPRESS CORP COURIER SERVICES 2007 288.76 08567 G.E MEDICAL SYSTEMS INC. REFUND FINAL UTILITY BILL 54.29 04537 GALETON GLOVES 25 DOZEN - 90Z BROWN JERSEY GL 103.47 01546 HACH COMPANY CHLORINE PILLOWS (1000) AND TE 550.00 01559 HANSEN INFORMATION TECHNOLOGY HANSEN 8 MIGRATION 3779.73 01544 HBK WATER METER SERVICE 2007 CONTRACT FOR WATER METER 639.42 2007 CONTRACT FOR WATER METER 1507.21 2007 CONTRACT FOR WATER METER 622 .3 7 2007 CONTRACT FOR WATER METER 969.64 2007 CONTRACT FOR WATER METER 2285.58 2007 CONTRACT FOR WATER METER 943.78 ---------..--- 6968.00 07433 lMAGETEC LP MONTHLY LEASE PAYMENT FOR TOSH 236.00 01757 I SAWtlA REGISTRATION FEE FOR GLEN ANDL 105.00 REGISTRATION FEE FOR JOHN FRAN 105.00 ------------- 210.00 10023 J. CONGDON SEWER SERVI CE, INC. PROSPECT MEADOWS WATERMAIN 72843.98 01791 K - PLUS ENVIRONMENTAL, INC. PROFESSIONAL SERVICES L.U.S.T. 2219.00 01838 KRAMER TREE SPECIALISTS REMOVAL OF THREE PARKWAY TREES 1375.00 08631 LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEANI 247.58 01918 LUNDSTROM I S NURSERY / INC. TURF MOWING AT VARIOUS LOCATIO 465.19 TRANSPLANT TWO 3' TREES FROM 1 675.00 .......-....-.... ..-..... 1140.19 08567 MAGO, N. REFUND FINAL UTILITY BILL 124.96 05021 MENARDS PROPANE CYCLINDER AND TORCH KI 91.72 ~PORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY MAY092007 17: 09 PAGE 13 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 ~. --............ -- --...... ----.... --.... -...................................... --.... --.. --.. --.................... -- ----...... --...... ---.. -- --.. --.... ----............................ ..-_.... --.. ..----....- JEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .......................-...................... -- -_.........- --....-..............-............ ---.................................. ---.. ---............ --........... ---.... ----....................... --............................ --.. 02826 MICHAEL WAGNER & SONS, INC. REPAIR PARTS FOR WELL PUMPS AT 759.71 09514 NASSCO INC. MANUAL OF SEWER CONDITION 75.00 02143 NEENAII FOUNDRY COMPANY MANHOLE FRAME RINGS 439.50 05256 NI COR GAS SERVI CE 162.46 02536 PROFORMA CUSTOMIZED GRAPHICS 4800 - 11" X 15" RESIDENT 1981.05 OPEN HOUSE GIVE-HAYS 108.43 OPEN HOUSE GIVE-HAYS 35.14 OPEN HOUSE GIVE-HAYS 1730.69 OPEN HOUSE GIVE-HAYS 560.93 ----..----....-- 4416.24 02379 QUI LL CORPORATION MISC OFFICE AND TONER SUPPLIES 269.95 10129 SCHMICK, TROY PLUMBING REFUND 75.00 PLUMBING REFUND 273.50 ---..--------- 348.50 08567 SCHOEN, JENNI FER REFUND FINAL UTILITY BILL 176.30 08567 SCHOENBERG, FRANK REFUND FINAL UTILITY BILL 119.06 02610 STANDARD EQUIPMENT COMPANY CLEANING TOOLS FOR 2007 CIPP 4275.00 02660 SUBURBAN PRINTING PRINTING OF OPEN HOUSE POSTERS 129.00 04209 TAPCO 2 - ROLL-UP DURALATCH 48' X 48 537.25 10132 TLC CONTROLS INC. PHASE MONITOR AND CONTROL TRAN 242.04 07387 TOMKO, SUSAN REIMBURSE FOR SEWER CONTRACTOR 1500.00 02839 WATER ENVIRONMENT FEDERATION 2007 MEMBERSHIP DUES-G.ANDLER 59.00 02914 ZIEBELL WATER SERVICE PRODUCTS 6" MJ RW MUELLER VALVE 556.80 TOTAL 203744.96 20 08711 QUALITY MAINTENANCE SYSTEMS, INC. 2007 CONTRACT FOR CUSTODIAL SE 1822.86 TOTAL 1822.86 30 01060 CENTURY TILE SEALERS CHOICE LATICRETE CUSTO 20.08 01147 COMMONWEALTH EDISON 11 E NORTHWEST HIGHWAY - ACCOU 279.39 13 E NORTHWEST HIGHWAY - ACCOU 76.69 ....--- -----..-- 356.08 01790 K.D. IRON WORKS (3) IRON RAILS FOR REPAIR AT T 260.00 PORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY HAY092007 17: 09 RELEASE 10 : PAGE 14 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 'EPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 05021 MENARDS MISC. BUILDING AND HARDWARE 180.22 05256 NICOR GAS SERVICE 896.24 02301 PETTY CASH . FINANCE DEPT. MISCELLANEOUS 5.00 08711 QUALITY MAINTENANCE SYSTEMS / INC. 2007 CONTRACT FOR CUSTODIAL SE 296.96 02754 UNION PACIFIC RAILROAD LAND LEASE 3289.83 TOTAL 5304.41 iO 09676 AMERICAN MESSAGING PAGER MESSAGING SERVICE 53.53 02108 ARLINGTON POWER EQUIPMENT ROTATILLER TIRE 34.23 02617 BEARING DISTRIBUTORS / INC. BROWNING SHEAVE 129.32 TIMKEN BEARING CONE 142.45 -~-..._------- 271. 77 02938 BOWMAN DISTRIBUTION CENTER NUTS / BOLTS / HOWE APRIL 2007 782.77 06468 BP GASOLINE 53.99 03958 CHICAGO INTERNATIONAL TRUCK CREDIT 2860 104.81 01289 DOUGLAS TRUCK PARTS CRC AEROSALE BRAKE CLEANER 475.20 05579 ELMHURST LINCOLN MERCURY FORD TRUCK LOCK CYLINDER 54.30 08705 GENUINE PARTS COMPANY -NAPA AUTOMOTIVE REPAIR PARTS 220.85 06691 JUST TIRES P225/60R16 GOODYEAR EAGLE RSA 970.92 STATE TIRE FEE 20.00 ADDT I L CHARGE STATE TIRE FEE 10.00 P235/55WR17 GOODYEAR EAGLE RSA 1150.32 STATE TIRE FEE 30.00 ------------ .. 2181.24 01872 LATTOF ARLINGTON HEIGHTS PARTS AND SERVICE APRIL 2007 216.00 PARTS AND SERVICE APRIL 2007 772.68 ------------- 988.68 02089 MUNICIPAL FLEET MANAGERS ASSOCIATION CASTELLANOS/CASTRO/GUENTHER 75.00 DAVE RISTOW 25.00 ------------- 100.00 09593 PAYLINE WEST I INC. NEW HOLLAND THROTTLE CABLE 98.66 07663 PRAIRIE INTERNATIONAL TRUCK SALES WATER PUMP GASKET 24.08 RADIATOR CAP/MOUNTING BOLTS 60.50 EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY MAY092001 11: 09 RELEASE ID : PAGE 15 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2001 TO MAY 09 2007 . -....................... --.... -- --...... ..-- --..................- --............ --.... ---.............. --.................. --.. --.... --.............. --.... --........................ --.. --- --.. --.... --......... -- --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ...... --............................ --........ --..-.. --...................... --.............. --...... --.......................... --... --............ ---................. --..-................ --......... ---...........-.. ...--.... --- TRUCK-LITE FLASHERS 209.85 GROTE LED OVAL STOP 554.56 INTERNATIONAL EXHAUST PIPE 643.31 INTERNATIONAL TRUCK PARTS 154 . 58 .--------..--- 2246.8 8 02402 REDI STRI P COMPANY PARTS 370.00 PLOOUTION CONTROL SURCHARGE 29.60 .------..----... 399.60 09423 RONCO INDUSTRIAL SUPPLY GASOLINE SAFETY CANS 210.37 02491 SAUBER MFG. CO. AUTOMOTIVE LED RESISTOR 18.60 FREIGHT 4.18 .------------ 22.78 02581 SOLVENT SYSTEMS INT I L. INC. PARTS WASHER RENTAL AND SERVIC 100.83 DISPOSAL OF USED OIL FILTERS 331.50 ------------- 432 .3 3 02610 STANDARD EQUIPMENT COMPANY PARTS & SUPPLIES 77 .21 02660 SUBURBAN PRINTING PRE-TRIP 2 PART FORMS (10,000) 705.00 MAINTENANCE FORM 2-PART (3,500 255.00 MAINTENANCE FORM 2-PART (3,500 614.00 -----....--..--... 1574.00 02684 TERRACE SUPPLY COMPANY RENTAL OF WELDING CYLINDERS FO 14 .88 04472 TEXOR PETROLEUM CO FUEL 17571.50 02169 UPTOWN AUTO SUPPLY 3) BXT6S-750 MOTORSHAFT 263.07 ALTERNATOR ASSEMBLY 175 . 77 IGNITION WIRE SET/SPARK PLUGS 80.99 WATER PUMP-VEH IP-21 68.19 .------------ 588.02 TOTAL 28557.60 670 02796 ALPHA PRIME COMMUNICATIONS 4 - CM300 MOTOROLA VHF 20 CHAN 1812.00 4 - FOUR YEAR WARRANTY 200.00 ------------- 2012.00 02617 BEARING DISTRIBUTORS, INC. BROWNING SHEAVE 473.78 04629 INDUSTRIAL STEEL SERV. CTR. ROUND STEEL TUBING 262 .02 05007 LANDMARK FORD (11) 2007 FORD CROWN VICTORIA 123243.55 PORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY HAY092007 17: 09 RELEASE ID : PAGE 16 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 .......... _................ --.. --.. -- ---.............. ...__.................... ..___...... __ ..._.. _.. ___........... __....................... __........ WoO __.. __ ___...._........ __.. __.. __ __....._.... __.......... __...... IEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ................... --.... --.. ---............ ----.............. -.............. --..-....... --............ ..--- --.. ................ --................. ---.... --.... --........................ --.... --.. --......... --.... --........ 04951 SUBURBAN ACCENTS INC. REPAIR GRAPHICS & LETTERING 325.00 TOTAL 126316.35 10 10072 CANNON COCHRAN MANAGEMENT SERVI CES, INC. CLAIMS ADMIN . GENERAL 2583.32 10051 CCMS I W/C REIMBURSEMENT.ADD.DRAFFONE 7763.17 W/C REIMBURSEMENT 5/8/07 47104.01 --oO_--------- . 54867.18 01102 GAB ROBINS N .A., INC - CITIBANK INSURANCE CLAIMS-GAB 1523.21 06420 GRAYBAR ELECTRIC CO. REPLACEMENT LIGHT POLES 4284.13 REPLACEMENT LIGHT POLE 2894.20 -....--....------ 7178.33 05943 IL DEPT. OF EMPLOYMENT SECURITY WILLIAMS/MOREL/KRIESE 6243.50 05024 JULIANO, JAMES REFUND OF MEDICAL PREMIUM 2573.66 10131 LETSOS, ANGELA MS. REPLACEMENT OF MAILBOX 125.00 10130 MARTIN, RUTH MS. REPLACEMENT OF MAILBOX 59.10 02514 SCHWANDT, ALAN RX FOR MR. SCHWANDT 33.99 TOTAL 75187.29 10 04849 IPPFA (IL PUBLIC PENSION FUND) SEMINARS & ASSOCIATIONS 175.00 SEMINARS & ASSOCIATIONS 650.00 ------------- 825.00 04890 SEGALL BRYANT & HAMILL POLICE PENSION-INVESTMENT 6423.38 09635 WELLS FARGO BANK, N .A. POLICE PENSION-BANK CHARGES 865.10 TOTAL 8113.48 720 04890 SEGALL BRYANT & HAMILL FIRE PENS ION- INVESTMENT 6633.46 09635 WELLS FARGO BANK, N .A. FIRE PENS ION- BANK CHARGES 984.52 TOTAL 7617.9 8 770 04203 ADDANTE, ANTHONY FLEX COMP 251.80 00477 BURES, PAUL FLEX COMP 1097.62 05987 BURKEMPER, LI SA FLEX COMP 1200.00 ~PORT: APBOARDRPT GENERATED: 09 AUG 06 16: 39 RUN: WEDNESDAY HAY092007 17: 09 PAGE 11 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 . - --... ~.........", --... --......... ..--........ -- --_............-............ --...... -..---.................. --..................... --...... --.................. ---.. ---..... --..............-.................. --...............-... --..... -- --- --... -- ---......... --...... )EPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -- --.....................-.................. --...................................... --............................................. --... ---... --..................... --...................................................... --........................... --...... --.....-... -- --... --.....-.................. --............. 01094 CHRISTENSEN, RI CHARD FLEX COMP 608.35 01219 DAHLBERG, JOlIN K. FLEX COMP 361.17 01241 DAWSON, HENRY C. FLEX COMP 4635.00 00321 DRAFFONE, RICHARD FLEX COMP 53.17 08107 ERB, DAVID FLEX COMP 318.12 01418 FLORY, JAMES M. FLEX COMP 281.16 08178 GUARDIAN EMPLOYER DENTAL PLAN-MAY 2007 6729.87 00343 GUTIERREZ, JULIE M. FLEX COMP 62.57 00345 HANNEMAN, LESTER A. FLEX COMP 425.00 01625 HUEMANN, ANTHONY FLEX COMP 711.99 10020 JAROG, LYNN FLEX COMP 98.08 FLEX COMP 416.66 ------------- 514.74 01844 KRUPA, FRANK M. FLEX COMP 447.69 07611 LAMBEL, BRIAN FLEX COMP 545.61 01941 MALCOLM, JOlIN FLEX COMP 92.79 02450 ROELS, ROBERT J. FLEX COMP 509.34 02473 RUMORE, CINDY JO FLEX COMP 196.00 02508 SCHULTZ, WALTER FLEX COMP 152.88 00429 SEMKIU, MICHAEL J. FLEX COMP 181.20 05019 SILL, GREGORY FLELX COMP 240.00 10090 SIWAK, FRANK FLEX COMP 503.04 06950 SLAASTED, SCOTT FLEX COMP 363.11 09237 SLOAN, CLARE FLEX COMP 50.00 02631 STEPHENSON, MI CHAEL R. FLEX COMP 265.00 02644 STRAHL, DAVID FLEX COMP 534.78 10092 WEGER, MARK FLEX COMP 600.00 02854 WERNER, MICHAEL T. FLEX COMP 895.20 TOTAL 22827.20 EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY MAY092007 17:09 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 PAGE 18 DEPT VENDOR NBR -........ --.............. ----.... -- -_.... -- --.... - -.. --.... --.......... --.. --.. ---.... -.._- --...... -- --.......... ---............ --.. --...... --............................ --......... ---.... --.... -_.... --.. AMOUNT VENDOR NAME INVOICE DESCRIPTION 01719 ..-................... -...... ----..... ---..... --............ ---............ -- --.......... --.... -- --................. --.......... --........ --...... --..... --.... --.... --........ --............... -- --............................-...... 90 02689 02808 02886 NCPERS GROUP LIFE PREMIUM FOR MONTH OF MAY 2007 THIRD DISTRICT CIRCUIT COURT BOND MONEY BOND MONEY BOND MONEY BOND MONEY VILLAGE OF MOUNT PROSPECT INSPECTION WISCONSIN DEPARTMENT OF REVENUE WISC. INCOME TAX FOR APRIL 07 TOTAL GRAND TOTAL 668.00 3655.00 1800.00 100.00 4352.00 9907.00 18500.00 596.37 29671.37 1699390.07 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY MAY092007 17: 09 RELEASE ID : PAGE 19 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 27 2007 TO MAY 09 2007 - -. - -- - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - -- - - - _.- - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - -- SUMMARY BY FUND - - - - - - - - - - - - -- - - - -- - -- - - -- -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - -- 001 GENERAL FUND 257B13 .46 030 REFUSE or SPOSAL FUND 215416.46 050 MOTOR FUEL TAX FUND 299375.10 070 COMMUNITY DEVELPMNT BLOCK GRNT BO.OO 1BO SERIES 2001 B&I, VILLAGE HALL 91BB2.50 190 SERIES 2003 B&I, VILLAGE HALL 215796. BB 350 SERIES 199BA 8&1, FLOOD 1397.50 360 SERIES 199BC B&I, TIF 39B7.50 390 SERIES 2000 B&I, FLOOD CONTROL 41071.25 510 CAPITAL IMPROVEMENT FUND 5B252.21 550 DOWNTOWN REDEVLPMNT CONST 5153.71 610 WATER AND SEWER FUND 203744.96 620 VILLAGE PARKING SYSTEM FUND IB22. B6 630 PARKING SYSTEM REVENUE FUND 5304.41 660 VEHI CLE MAINTENANCE FUND 2B557.60 670 VEHI CLE REPLACEMENT FUND 126316.35 690 RISK MANAGEMENT FUND 751B7.29 710 POLICE PENSION FUND 8113.4B 720 FIRE PENSION FUND 7617.9B 770 FLEXCOMP ESCROW FUND 22B27.20 790 ESCROW DEPOSIT FUND 29671.37 -------- ------ TOTAL : 1699390.07 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES Aprill - April 30, 2007 65/09/2007 14:35:48 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 04/30/07 Cur Mo Received REVENUE BY CLASSIFICATION PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES Total All Funds 484,393 1,127,858 591,942 1,256,369 1,753,875 32,542 1,101,741 28,664 288,198 o 6,665,582 REVENUE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND SERIES 2003 PROJECT FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND POLICE PENSION FUND FIRE PENSION FUND 2,898,827 256,267 143,019 10 3,402 299 136 1,743 210 20,192 18,887 29,430 o o 90,586 213 3,607 7,621 42,504 52,783 1 o o 9,870 o 104,823 134,294 2,727 751,727 10,229 9,869 157,195 112,544 19,061 634,885 591,330 557,138 Y-T-D Received 5,179,836 4,576,369 1,447,206 2,649,460 6,327,492 85,835 2,215,498 126,566 2,048,335 o 24,656,597 9,714,399 1,634,773 437,983 19 56,044 5,459 531 6,377 842 206,924 194,709 301,587 o o 565,192 50,382 20,155 47,287 204,917 161,555 2 o o 23,786 o 644,841 546,756 10,878 3,537,260 32,152 31,855 473,073 361,337 60,705 2,022,083 1,664,406 1,637,716 1 4 Months 8 Months 2007 Budget 10,740,712 15,384,659 2,954,888 16,480,809 21,409,733 553,000 5,501,950 271,240 4,972,704 60,000 78,329,695 35,785,983 4,300,751 1,628,750 1,000 549,809 2,600 2,500 20,350 51,500 1,000 394,500 926,250 o o 1,076,500 o 49,367 88,507 582,933 735,250 o o o 262,800 o 1,220,052 1,711,100 32,000 11,149,100 96,738 111,100 1,573,353 1,093,626 189,547 6,473,939 4,125,500 4,093,290 33.3% 66.6% Completed Remaining Unreceived Balance 5,560,876 10,808,290 1,507,682 13,831,349 15,082,241 467,165 3,286,452 144,674 2,924,369 60,000 53,673,098 26,071,584 2,665,978 1,190,767 981 493,765 -2,859 1,969 13,973 50,658 -205,924 199,791 624,663 o o 511,308 -50,382 29,212 41,220 378,016 573,695 -2 o o 239,014 o 575,211 1,164,344 21,122 7,611,840 64,586 79,245 1,100,280 732,289 128,842 4,451,856 2,461,094 2,455,574 Unreceived Percent 51.8 70.3 51. 0 83.9 70.4 84.5 59.7 53.3 58.8 100.0 68.5 72 .9 62.0 73.1 98.1 89.8 -110.0 78.8 68.7 98.4 **** * 50.6 67.4 47.5 59.2 46.6 64.8 78.0 90.9 47.1 68.0 66.0 68.3 66.8 71.3 69.9 67.0 68.0 68.8 59.7 60.0 05/09/2007 14:35:49 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 - 04/30/07 4 Months 8 Months 33.3% 66.6% Completed Remaining Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent ESCROW DEPOSIT FUND 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 69 277 0 -277 SERIES 2002 LIBRARY BND ESCROW 84 335 0 -335 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 6.665.582 24.656,597 78,329.695 53,673.098 68.5 2 {)S/09/2007 4 Months 33.3% Completed 14:36:44 8 Months 66.6% Remaining FRRBRR03 VILLAGE OF MOUNT PROSPECT SUM 021 Budget Revenue by Category within Fund Summary 01/01/07 - 04/30/07 Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent GENERAL FUND 40 PROPERTY TAXES 330,817 3,538,135 7,416,686 3,878,551 52.3 41 OTHER TAXES 641,658 1,652,120 8,447,000 6,794,880 80.4 42 LICENSES, PERMITS & FEES 589,219 1,439,963 2,935,250 1,495,287 50.9 43 INTERGOVERMENT REV. 1,118,709 2,198,050 14,162,700 11,964,650 84.5 44 CHARGES FOR SERVICE 116,234 502,397 1,551,507 1,049,110 67.6 45 FINES AND FORFEITS 30,898 75,664 531,000 455,336 85.8 46 INVESTMENT INCOME 48,425 178,099 397,000 218,901 55.1 47 REIMBURSEMENTS 21,031 85,931 189,740 103,809 54.7 48 OTHER REVENUE 1,836 44,040 155,100 111,060 71.6 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL GENERAL FUND 2,898,827 9,714,399 35,785,983 26,071,584 72.9 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 88,379 945,231 2,016,276 1,071,045 53.1 44 CHARGES FOR SERVICE 161,138 661,215 2,211,475 1,550,260 70.1 46 INVESTMENT INCOME 6,770 28,220 72,000 43,780 60.8 48 OTHER REVENUE -20 107 1,000 893 89.3 TOTAL REFUSE DISPOSAL FUND 256,267 1,634,773 4,300,751 2,665,978 62.0 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 134,483 411,075 1,587,500 1,176,425 74.1 46 INVESTMENT INCOME 6,598 24,970 34,750 9,780 28.1 47 REIMBURSEMENTS 1,938 1,938 6,500 4,562 70.2 TOTAL MOTOR FUEL TAX FUND 143,019 437,983 1,628,750 1,190,767 73.1 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 0 0 1,000 1,000 100.0 46 INVESTMENT INCOME 10 19 0 -19 TOTAL LAW ENFORCEMENT BLOCK GRANT 10 19 1,000 981 98.1 COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 3,177 40,335 489,809 449,474 91. 8 46 INVESTMENT INCOME 225 336 0 -336 48 OTHER REVENUE 0 15,373 60,000 44,627 74.4 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 3,402 56,044 549,809 493,765 89.8 ASSET SEIZURE FUND 45 FINES AND FORFEITS 0 4,259 1,000 -3,259 -325.9 46 INVESTMENT INCOME 299 1,200 1,600 400 25.0 TOTAL ASSET SEIZURE FUND 299 5,459 2,600 -2,859 -110.0 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 0 0 1,000 1,000 100.0 46 INVESTMENT INCOME 136 531 1,500 969 64.6 1 05/09/2007 14:36:44 FRRBRR03 SUM 021 4 Months 8 Months 33.3% 66.6% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 - 04/30/07 Cur Mo Received TOTAL DEA SHARED FUNDS FUND 136 DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 1,644 99 TOTAL DUI FINE FUND 1,743 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 210 o TOTAL FOREIGN FIRE TAX BOARD FUND 210 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME 19,253 939 TOTAL SERIES 1987A B&I, PW FACILITY 20,192 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 18,059 828 o TOTAL SERIES 2001 B&I, VILLAGE HALL 18,887 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 27,885 1,545 o TOTAL SERIES 2003 B&I, VILLAGE HALL 29,430 SERIES 2002B B&I, PUBLIC BLOGS 40 PROPERTY TAXES 46 INVESTMENT INCOME TOTAL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 87,137 3,449 o 2 Y-T-O Received 531 5,912 465 6,377 o 842 o 842 205,090 1,834 206,924 193,147 1,562 o 194,709 298,233 3,354 o 301,587 o o o o o o 555,872 9,320 o 2007 Budget 2,500 20,000 350 20,350 46,500 5,000 o 51,500 1,000 o 1,000 390,500 4,000 o 394,500 916,250 10,000 o 926,250 o o o o o o 1,053,500 23,000 o o o o o o o Unreceived Balance 1,969 14,088 -115 13,973 46,500 4,158 o 50,658 -204,090 -1,834 -205,924 197,353 2,438 o 199,791 618,017 6,646 o 624,663 497,628 13,680 o Completed Remaining Unreceived Percent 78.8 70.4 -32.9 68.7 100.0 83.2 98.4 ****.* ****.* 50.5 61. 0 50.6 67.5 66.5 67.4 o o o o o o 47.2 59.5 '05/09/2007 14,36,44 FRRBRR03 SUM 021 4 Months 8 Months Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 - 04/30/07 Cur Mo Received Y-T-D Received 2007 Budget unreceived Balance 33.3% 66.6% Completed Remaining Unreceived Percent TOTAL SERIES 1999 B&I, TIF 90,586 47.5 SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 3,520 87 TOTAL SERIES 1998A B&I, FLOOD 3,607 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 7,221 400 TOTAL SERIES 1998C B&I, TIF 7,621 IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 41,820 684 TOTAL IEPA FLOOD CONTROL LOANS B&I 42,504 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 52,227 556 TOTAL SERIES 2000 B&I, FLOOD CONTROL 52,783 SERIES 2002B B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 2002B B&I, STREET IMP. o 213 213 3 565,192 49,975 407 50,382 19,947 208 20,155 46,067 1,220 47,287 203,771 1,146 204,917 160,633 922 161,555 o 1 1 o o o o o o 1,076,500 49,067 300 49,367 87,307 1,200 88,507 582,933 o 582,933 728,000 7,250 735,250 o 2 2 o o o o o o o o 511,308 -49,975 -407 o -50,382 29,120 92 29,212 41,240 -20 41,220 379,162 -1,146 o o 378,016 567,367 6,328 573,695 o o o o o o o 59.3 30.7 59.2 47.2 -1. 7 46.6 65.0 64.8 77.9 87.3 78.0 o -2 -2 o o o o o o 05/09/2007 14:36:44 FRRBRR03 SUM 021 4 Months 8 Months 33.3% 66.6% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 - 04/30/07 Cur Mo Received CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES o 3,705 o 6,165 o TOTAL CAPITAL IMPROVEMENT FUND 9,870 SERIES 2003 PROJECT FUND 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 2003 PROJECT FUND DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES 96,571 8,252 o o TOTAL DOWNTOWN REDEVLPMNT CONST 104,823 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 127,731 o 6,563 o o TOTAL STREET IMPROVEMENT CONST FUND 134,294 FLOOD CONTROL CONST FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 2,727 o TOTAL FLOOD CONTROL CONST FUND 2,727 WATER AND SEWER FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 69,973 350 657,805 20,701 o 2,898 o TOTAL WATER AND SEWER FUND 751,727 4 Y-T-D Received o 15,974 o 7,812 o 23,786 o o o 616,051 28,790 o o 644,841 523,217 o 23,539 o o 546,756 o 10,878 o 10,878 748,716 4,370 2,695,151 72,690 1,083 15,250 o 3,537,260 2007 Budget 239,800 8,500 o 14,500 o 262,800 o o o 1,167,552 52,500 o o 1,220,052 1,688,700 o 22,400 o o 1,711,100 o 32,000 o 32,000 1,534,100 12,000 9,420,000 168,000 o 15,000 o 11,149,100 Unreceived Balance 239,800 -7,474 o 6,688 o 239,014 o o o 551,501 23,710 o o 575,211 1,165,483 o -1,139 o o 1,164,344 o 21,122 o 21,122 785,384 7,630 6,724,849 95,310 -1,083 -250 o 7,611,840 Completed Remaining Unreceived Percent 100.0 -87.9 46.1 90.9 o o o 47.2 45.2 47.1 69.0 -5.1 68.0 66.0 66.0 51.2 63.6 71.4 56.7 -1. 7 68.3 '05/09/2007 14:36:44 4 Months 8 Months 33.3% 66.6% FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 - 04/30/07 Cur Mo Received VILLAGE PARKING SYSTEM FUND 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 2,373 7,556 300 o TOTAL VILLAGE PARKING SYSTEM FUND 10,229 PARKING SYSTEM REVENUE FUND 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES o o 9,869 o o o TOTAL PARKING SYSTEM REVENUE FUND 9,869 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 155,595 1,600 o TOTAL VEHICLE MAINTENANCE FUND 157,195 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 84,963 27,581 o o TOTAL VEHICLE REPLACEMENT FUND 112,544 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 15,872 3,189 TOTAL COMPUTER REPLACEMENT FUND 19,061 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 544,843 8,430 5,695 75,917 TOTAL RISK MANAGEMENT FUND 634,885 POLICE PENSION FUND 46 INVESTMENT INCOME 4 8 OTHER REVENUE 485,156 106,174 591,330 TOTAL POLICE PENSION FUND 5 Y-T-D Received 2,873 28,125 1,154 o 32,152 o o 31,855 o o o 31,855 466,784 6,289 o 473,073 254,888 106,449 o o 361,337 48,444 12,261 60,705 1,638,633 33,627 37,614 312,209 2,022,083 806,278 858,128 1,664,406 2007 Budget 7,638 88,500 600 o 96,738 o o 110,000 1,100 o o 111,100 1,555,953 17,400 o 1,573,353 849,626 184,000 o 60,000 1,093,626 159,547 30,000 189,547 5,463,125 92,000 75,000 843,814 6,473,939 2,131,000 1,994,500 4,125,500 Unreceived Balance 4,765 60,375 -554 o 64,586 o o 78,145 1,100 o o 79,245 1,089,169 11,111 o 1,100,280 594,738 77,551 o 60,000 732,289 111,103 17,739 128,842 3,824,492 58,373 37,386 531,605 4,451,856 1,324,722 1,136,372 2,461,094 Completed Remaining unreceived Percent 62.4 68.2 -92.3 66.8 71.0 100.0 71.3 70.0 63.9 69.9 70.0 42.1 100.0 67.0 69.6 59.1 68.0 70.0 63.4 49.8 63.0 68.8 62.2 57.0 59.7 05/09/2007 14:36:44 FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 04/30/07 4 Months 8 Months 33.3% 66.6% Completed Remaining FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent 461,910 842,300 2,204,500 1,362,200 61.8 95,228 795,416 1,888,790 1,093,374 57.9 557,138 1,637,716 4,093,290 2,455,574 60.0 TOTAL FIRE PENSION FUND ESCROW DEPOSIT FUND 46 INVESTMENT INCOME o o o o TOTAL ESCROW DEPOSIT FUND o o o o SSA #6 GEORGE/ALBERT B&I 41 OTHER TAXES 46 INVESTMENT INCOME o 69 o 277 o o o -277 TOTAL SSA #6 GEORGE/ALBERT B&I 69 277 o -277 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME 84 335 o -335 TOTAL SERIES 2002 LIBRARY BND ESCROW 84 335 o -335 GENERAL FIXED ASSETS ACCT GP 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES o o o o o o o o TOTAL GENERAL FIXED ASSETS ACCT GP o o o o MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES o o 8,572,028 8,572,028 100.0 TOTAL MOUNT PROSPECT LIBRARY FUND o o 8,572,028 8,572,028 100.0 6 4 Months 8 Months . 05/09/2007 14:34:52 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 04/30/07 Cur Mo Expended Y-T-D Expended 2007 Budget 33.3% 66.6% Unexpended Balance Completed Remaining Unexpended Percent EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS PENSION BENEFITS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES LAND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS INFRASTRUCTURE BOND PRINCIPAL INTEREST EXPENSE BANK AND FISCAL FEES INTERFUND TRANSFERS Total All Funds 1,778,745 588,025 28,889 445,598 1,196,308 28,533 575,089 140,475 31,647 o 1,308 3,848 73,978 12,648 163,344 319,009 129,341 39,289 o o 5,556,074 EXPENDITURE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND SERIES 2003 PROJECT FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND 2,732,502 330,144 365,125 o 5,985 152 o 3,612 473 o o o o o o o o o 168,630 o o o o 8,958 o 37,205 o o 7,718,135 1,961,855 108,928 1,704,683 3,883,373 111,551 2,466,389 513,614 36,373 o 1,791 7,017 135,880 59,911 188,630 325,302 244,359 443,501 900 o 19,912,192 10,634,134 1,117,341 517,231 o 30,034 953 o 3,612 682 405,000 o 300 o o 73,050 o o o 188,275 300 o o o 80,532 o 73,407 o o 1 24,621,815 6,470,038 452,438 5,131,324 16,012,741 745,159 7,105,878 1,566,987 1,978,000 o 255,365 351,035 1,065,470 1,319,820 1,724,800 3,565,000 2,874,195 1,329,033 3,000 o 76,572,098 35,371,051 4,029,607 1,729,610 1,000 527,309 1,000 1,000 1,000 10,000 405,000 383,765 896,594 o o 916,100 o 67,795 153,575 613,356 727,743 o o o 738,000 o 1,881,200 2,071,000 244,000 16,903,680 4,508,183 343,510 3,426,641 12,129,368 633,608 4,639,489 1,053,373 1,941,627 o 253,574 344,018 929,590 1,259,909 1,536,170 3,239,698 2,629,836 885,532 2,100 o 56,659,906 24,736,917 2,912,266 1,212,379 1,000 497,275 47 1,000 -2,612 9,318 o 383,765 896,294 o o 843,050 o 67,795 153,575 425,081 727,443 o o o 657,468 o 1,807,793 2,071,000 244,000 68.7 69.7 75.9 66.8 75.7 85.0 65.3 67.2 98.2 99.3 98.0 87.2 95.5 89.1 90.9 91.5 66.6 70.0 74.0 69.9 72 .3 70.1 100.0 94.3 4.7 100.0 -261.2 93.2 100.0 100.0 92.0 100.0 100.0 69.3 100.0 89.1 96 .1 100.0 100.0 05/09/2007 14:34:52 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 - 04/30/07 4 Months 8 Months 33.3% 66.6% Completed Remaining Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent WATER AND SEWER FUND 740,447 2,195,671 11,131,631 8,935,960 80.3 VILLAGE PARKING SYSTEM FUND 7,669 27,535 123,154 95,619 77.6 PARKING SYSTEM REVENUE FUND 9,495 42,800 156,448 113,648 72 .6 VEHICLE MAINTENANCE FUND 118,614 436,284 1,573,353 1,137,069 72 .3 VEHICLE REPLACEMENT FUND 73,978 115,065 961,470 846,405 88.0 COMPUTER REPLACEMENT FUND 0 0 249,050 249,050 100.0 RISK MANAGEMENT FUND 510,921 2,279,801 6,514,196 4,234,395 65.0 POLICE PENSION FUND 208,922 807,039 2,465,133 1,658,094 67.3 FIRE PENSION FUND 233,242 883,146 2,627,958 1,744,812 66.4 SSA #6 GEORGE/ALBERT B&I 0 0 0 0 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 5,556,074 19,912,192 76,572,098 56,659,906 74.0 2 iJ5/09/2007 4 Months 33.3% Completed 14:37:55 VILLAGE OF MOUNT PROSPECT 8 Months 66.6% Remaining FRRDBROl SUM031 Department Budget Expenditure Sununary 01/01/07 - 04/30/07 Cur Mo Y-T-D 2007 Unexpended Unexpended PUBLIC REPRESENTATION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 3,287 30,010 111,270 81,260 73 .0 03 ADVISORY BOARDS & COMMISSIONS 1,025 9,155 17,010 7,855 46.2 Totals 4,312 39,165 128,280 89,115 69.5 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 2,660 15,127 35,466 20,339 57.3 51 EMPLOYEE BENEFITS 509 2,617 6,361 3,744 58.9 52 OTHER EMPLOYEE COSTS 0 0 3,000 3,000 100.0 54 CONTRACTUAL SERVICES 1,098 20,698 77,353 56,655 73.2 55 UTILITIES 18 77 500 423 84.6 57 COMMODITIES & SUPPLIES 27 646 5,600 4,954 88.5 Totals 4,312 39,165 128,280 89,115 69.5 SOURCE OF FUNDS 001 GENERAL FUND 4,312 39,165 128,280 89,115 69.5 Totals 4,312 39,165 128,280 89,115 69.5 1 05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months B Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 VILLAGE MANAGER'S OFFICE Cur Mo Expended PROGRAM TOTALS 01 VILLAGE MANAGER'S OFFICE 02 LEGAL SERVICES 03 PERSONNEL SERVICES 04 INFORMATION TECHNOLOGY 05 PUBLIC INFORMATION 36,741 53,372 1B,363 69,021 1B,197 Totals 195,694 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 62,403 23,945 2,292 105,006 397 l,lB1 470 o Totals 195,694 SOURCE OF FUNDS 001 GENERAL FUND 195,694 Totals 195,694 2 Y-T-D Expended 201,311 127,206 71,B16 215,5BB 36,5B9 652,510 299,5BO BB,l1B 9,455 251,069 1,346 2,120 B22 o 652,510 652,510 652,510 2007 Budget 509,550 630,750 2B7,303 919,135 143,372 2,490,110 B9B,539 2B1,625 46,400 1,213,396 10,145 l1,4B5 26,920 1,600 2,490,110 2,490,110 2,490,110 33.3% 66.6% Unexpended Balance 30B,239 503,544 215,4B7 703,547 106,7B3 1,837,600 59B,959 193,507 36,945 962,327 B,799 9,365 26,09B 1,600 1,837,600 l,B37,600 1,837,600 Completed Remaining Unexpended Percent 60.5 79.B 75.0 76.5 74.5 73.8 66.7 6B.7 79.6 79.3 B6.7 B1.5 96.9 100.0 73.8 73.B 73.8 .05/09/2007 4 Months 33.3% Completed 14:37:56 VILLAGE OF MOUNT PROSPECT 8 Months 66.6% Remaining FRRDBROl SUM 031 Department Budget Expenditure Sununary 01/01/07 - 04/30/07 Cur Mo Y-T-D 2007 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 9,305 37,842 130,245 92,403 70.9 04 INTERGOVERNMENTAL PROGRAMMING 3,210 12,267 48,322 36,055 74.6 Totals 12,515 50,109 178,567 128,458 71.9 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 7,426 31,586 102,484 70,898 69.2 51 EMPLOYEE BENEFITS 3,658 12,501 41,133 28,632 69.6 52 OTHER EMPLOYEE COSTS 0 535 2,650 2,115 79.8 54 CONTRACTUAL SERVICES 934 2,432 13 , 150 10,718 81.5 55 UTILITIES 123 628 1,600 972 60.8 57 COMMODITIES & SUPPLIES 374 1,374 7,050 5,676 80.5 67 OTHER EQUIPMENT 0 1,053 10,500 9,447 90.0 Totals 12,515 50,109 178,567 128,458 71.9 SOURCE OF FUNDS 001 GENERAL FUND 12,515 50,109 178,567 128,458 71.9 Totals 12,515 50,109 178,567 128,458 71.9 3 05/09/2007 4 Months 33.3% Completed 14:37:56 VILLAGE OF MOUNT PROSPECT 8 Months 66.6% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 - 04/30/07 Cur Mo Y-T-D 2007 Unexpended Unexpended VILLAGE CLERK'S OFFICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 13,859 61,647 200,188 138,541 69.2 Totals 13,859 61,647 200,188 138,541 69.2 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 8,538 38,966 113,075 74,109 65.5 51 EMPLOYEE BENEFITS 3,904 13,972 43,977 30,005 68.2 52 OTHER EMPLOYEE COSTS 0 70 2,625 2,555 97.3 54 CONTRACTUAL SERVICES 1,008 7,449 33,748 26,299 77.9 55 UTILITIES 61 142 1,650 1,508 91.4 57 COMMODITIES & SUPPLIES 348 1,048 5,113 4,065 79.5 Totals 13,859 61,647 200,188 138,541 69.2 SOURCE OF FUNDS 001 GENERAL FUND 13,859 61,647 200,188 138,541 69.2 Totals 13,859 61,647 200,188 138,541 69.2 4 .05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 FINANCE DEPARTMENT Cur Mo Expended PROGRAM TOTALS 01 FINANCE ADMINISTRATION 02 ACCOUNTING 04 DUPLICATING SERVICES 05 INSURANCE PROGRAMS 06 CUSTOMER SERVICES 07 CASH MANAGEMENT 25,729 36,919 o 50,741 34,397 2,776 Totals 150,562 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 60,641 26,176 405 16,770 233 45,061 1,276 o Totals 150,562 SOURCE OF FUNDS 001 GENERAL FUND 150,562 Totals 150,562 Y-T-D Expended 109,255 144,808 o 157,940 130,865 10,920 553,788 248,064 89,803 2,483 72,537 976 135,181 4,444 300 553,788 553,788 553,788 5 2007 Budget 301,287 444,679 o 521,445 409,237 49,732 1,726,380 796,825 295,144 10,640 137,776 5,150 450,605 24,240 6,000 1,726,380 1,726,380 1,726,380 33.3% 66.6% Unexpended Balance 192,032 299,871 o 363,505 278,372 38,812 1,172,592 548,761 205,341 8,157 65,239 4,174 315,424 19,796 5,700 1,172,592 1,172,592 1,172,592 Completed Remaining Unexpended Percent 63.7 67.4 69.7 68.0 78.0 67.9 68.9 69.6 76.7 47.4 81.0 70.0 81. 7 95.0 67.9 67.9 67.9 05/09/2007 14:37:56 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 4 Months 8 Months 33.3% 66.6% Completed Remaining Cur Mo Y-T-D 2007 Unexpended Unexpended COMMUNITY DEVELOPMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 COMMUNITY DEVELOPMENT ADMIN 18,146 75,409 240,629 165,220 68.7 02 PLANNING & ZONING 20,430 80,976 265,580 184,604 69.5 03 ECONOMIC DEVELOPMENT 8,362 33,307 109,436 76,129 69.6 05 BUILDING INSPECTIONS 61,088 238,751 812,491 573,740 70.6 06 HOUSING INSPECTIONS 40,117 125,078 490,180 365,102 74.5 07 HEALTH INSPECTIONS 9,653 38,379 128,318 89,939 70.1 Totals 157,796 591,900 2,046,634 1,454,734 71.1 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 95,008 381,697 1,255,645 873,948 69.6 51 EMPLOYEE BENEFITS 45,063 151,487 497,667 346,180 69.6 52 OTHER EMPLOYEE COSTS 1,265 7,882 30,563 22,681 74.2 54 CONTRACTUAL SERVICES 13,665 41,083 212,484 171,401 80.7 55 UTILITIES 954 3,444 18,555 15,111 81.4 57 COMMODITIES & SUPPLIES 1,841 6,307 18,720 12,413 66.3 65 OFFICE EQUIPMENT 0 0 13,000 13,000 100.0 Totals 157,796 591,900 2,046,634 1,454,734 71.1 SOURCE OF FUNDS 001 GENERAL FUND 157,796 591,000 2,045,734 1,454,734 71.1 550 DOWNTOWN REDEVLPMNT CONST 0 900 900 0 Totals 157,796 591,900 2,046,634 1,454,734 71.1 6 .05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 04/30/07 COMMUNITY DEVELOPMENT - CDBG Cur Mo Expended PROGRAM TOTALS 04 CDBG ADMINISTRATION 05 CDBG COMMUNITY PROGRAMS 06 ACCESSIBLTY & NEIGHBRHD IMPRV 07 CDBG RESIDENTIAL REHAB 6,137 -152 o o Totals 5,985 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 64 BUILDING IMPROVEMENTS 69 INFRASTRUCTURE 4,000 1,907 o 78 o o o o Totals 5,985 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 5,985 Totals 5,985 Y-T-D Expended 25,219 o o 4,815 30,034 16,800 6,534 848 1,037 o 4,815 o o 30,034 30,034 30,034 7 2007 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 83,309 134,000 85,000 225,000 527,309 52,004 20,697 6,020 147,639 949 190,000 o no,ooo 527,309 527,309 527,309 58,090 134,000 85,000 220,185 497,275 35,204 14,163 5,172 146,602 949 185,185 o no,ooo 497,275 497,275 497,275 69.7 100.0 100.0 97.9 94.3 67.7 68.4 85.9 99.3 100.0 97.5 100.0 94.3 94.3 94.3 05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 HUMAN SERVICES Cur Mo Expended PROGRAM 01 02 03 04 05 TOTALS HUMAN SERVICES ADMINISTRATION SOCIAL SERVICES NURSING/HEALTH SERVICES SENIOR CTR. LEISURE ACTIVITIES YOUTH ACTIVITIES 12,410 29,287 13,790 2,185 o Totals 57,672 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 38,118 14,778 200 3,827 392 357 o Totals 57,672 SOURCE OF FUNDS 001 GENERAL FUND 57,672 Totals 57,672 8 Y-T-D Expended 54,944 110,115 54,167 9,068 o 228,294 156,623 51,754 894 15,567 1,372 2,084 o 228,294 228,294 228,294 2007 Budget 176,277 342,827 191,981 44,922 o 756,007 478,186 171,605 3,900 53,601 8,000 37,215 3,500 756,007 756,007 756,007 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 121,333 232,712 137,814 35,854 o 527,713 321,563 119,851 3,006 38,034 6,628 35,131 3,500 527,713 527,713 527,713 68.8 67.9 71.8 79.8 69.8 67.2 69.8 77 .1 71.0 82.9 94.4 100.0 69.8 69.8 69.8 .05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 POLICE Cur Mo Expended PROGRAM TOTALS 01 POLICE ADMINISTRATION 02 PATROL & TRAFFIC ENFORCEMENT 03 CRIME PREVTN & PUBLIC SERVICES 04 INVESTIGATIVE & JUVENILE PRGM 05 CROSSING GUARDS 06 EQUIPMENT MAINTENANCE 152,253 609,021 20,225 90,458 2,328 77,765 Totals 952,050 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 607,849 175,349 19,491 130,733 2,909 8,249 3,266 4,204 Totals 952,050 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND 948,286 o 152 o 3,612 Totals 952,050 Y-T-D Expended 587,319 2,478,859 79,527 365,895 10,397 237,023 3,759,020 2,621,493 553,420 48,516 479,383 10,387 34,853 5,783 5,185 3,759,020 3,754,455 o 953 o 3,612 3,759,020 9 2007 Budget 1,612,340 8,218,329 342,746 1,205,678 29,380 811,753 12,220,226 8,592,849 1,852,559 123,000 1,427,145 49,200 115,423 14,000 46,050 12,220,226 12,216,226 1,000 1,000 1,000 1,000 12,220,226 33.3% 66.6% Unexpended Balance 1,025,021 5,739,470 263,219 839,783 18,983 574,730 8,461,206 5,971,356 1,299,139 74,484 947,762 38,813 80,570 8,217 40,865 8,461,206 8,461,771 1,000 47 1,000 -2,612 8,461,206 Completed Remaining Unexpended Percent 63.6 69.8 76.8 69.7 64.6 70.8 69.2 69.5 70.1 60.6 66.4 78.9 69.8 58.7 88.7 69.2 69.3 100.0 4.7 100.0 -261. 2 69.2 05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 FIRE Cur Mo Expended PROGRAM TOTALS 01 FIRE ADMINISTRATION 02 FIRE DEPARTMENT OPERATIONS 03 FIRE TRAINING ACADEMY 04 FIRE PREVENTION 05 FIRE COMMUNICATIONS 06 EQUIPMENT MAINTENANCE 07 EMERGENCY PREPARDENESS PRGM 08 PAID-ON-CALL PROGRAM 09 EMERGENCY ASSISTANCE PROGRAM 10 FOREIGN FIRE INSURANCE 79,303 531,792 380 40,191 3,917 45,744 1,801 1,903 o 473 Totals 705,504 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 502,126 132,718 3,306 473 48,782 2,961 10,912 o o 4,226 Totals 705,504 SOURCE OF FUNDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 705,031 473 Totals 705,504 10 Y-T-D Expended 311,820 2,180,609 10,903 161,216 22,285 150,873 4,410 6,939 o 682 2,849,737 2,168,842 415,695 22,250 473 164,194 18,808 45,466 483 o 13,526 2,849,737 2,849,055 682 2,849,737 2007 Budget 944,298 6,929,243 13,631 546,561 64,500 505,633 35,715 35,748 o 10,000 9,085,329 6,833,619 1,390,307 146,940 o 454,019 43,200 119,769 4,000 4,000 89,475 9,085,329 9,075,329 10,000 9,085,329 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 632,478 4,748,634 2,728 385,345 42,215 354,760 31,305 28,809 o 9,318 6,235,592 4,664,777 974,612 124,690 -473 289,825 24,392 74,303 3,517 4,000 75,949 6,235,592 6,226,274 9,318 6,235,592 67.0 68.5 20.0 70.5 65.4 70.2 87.7 80.6 93.2 68.6 68.3 70.1 84.9 63.8 56.5 62.0 87.9 100.0 84.9 68.6 68.6 93.2 68.6 .05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 PUBLIC WORKS - ADMINISTRATION Cur Mo Expended PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 114,445 Totals 114.445 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 17,161 12,546 317 81,578 1,092 1,751 o o Totals 114,445 SOURCE OF FUNDS 001 GENERAL FUND 114,445 Totals 114,445 11 Y-T-D Expended 391,601 391,601 80,393 42,511 5,470 254,774 5,402 2,823 o 228 391,601 391,601 391,601 2007 Budget 1,259,759 1,259,759 237,193 135,476 30,095 821,835 18,990 14,475 1,090 605 1,259,759 1,259,759 1,259,759 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 868,158 868,158 156,800 92,965 24,625 567,061 13,588 11,652 1,090 377 868,158 868,158 868,158 68.9 68.9 66.1 68.6 81. 8 69.0 71.6 80.5 100.0 62.3 68.9 68.9 68.9 05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 PUBLIC WORKS - STREETS/BLDGS Cur Mo Expended PROGRAM TOTALS 01 STREET DIVISION ADMINISTRATION 02 MAINTENANCE - PUBLIC BUILDINGS 04 STREET MAINTENANCE 05 SNOW REMOVAL 06 LEAF REMOVAL 07 STORM SEWER & BASIN MAINT 08 MAINTENANCE OF STATE HIGHWAYS 09 TRAFFIC SIGN MAINTENANCE 10 VILLAGE PARKING LOT MAINT 11 PARKING LOT MAINTENANCE 12 FLOOD CONTROL 9,616 82,130 21,780 47,119 o 14, 414 3,222 9,054 7,669 9,495 o Totals 204,499 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 64 BUILDING IMPROVEMENTS 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 80 INTERFUND TRANSFERS 82,291 30,709 41,660 924 317 48,598 o o o o o Totals 204,499 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 152,322 35,013 7,669 9,495 Totals 204,499 12 Y-T-D Expended 49,781 245,513 66,910 416,721 o 49,121 28,233 32,694 27,535 42,800 o 959,308 469,931 129,381 140,353 3,728 952 214,963 o o o o o 959,308 721,492 167,481 27,535 42,800 959,308 2007 Budget 146,860 982,815 504,141 445,928 o 178,890 70,548 119,916 123,154 156,448 o 2,728,700 1,108,580 354,511 676,035 134,644 3,172 300,993 o 6,365 19,400 125,000 o 2,728,700 2,225,928 223,170 123,154 156,448 2,728,700 33.3% 66.6% Completed ' Remaining Unexpended Unexpended Balance Percent 97,079 737,302 437,231 29,207 o 129,769 42,315 87,222 95,619 113,648 o 1,769,392 638,649 225,130 535,682 130,916 2,220 86,030 o 6,365 19,400 125,000 o 1,769,392 1,504,436 55,689 95,619 113,648 1,769,392 66.1 75.0 86.7 6.5 72.5 60.0 72.7 77.6 72 .6 64.8 57.6 63.5 79.2 97.2 70.0 28.6 100.0 100.0 100.0 64.8 67.6 25.0 77 .6 72 .6 64.8 05/09/2007 14,37,56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 PUBLIC WORKS - FORESTRY/GRNDS Cur Mo Expended PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 02 MAINTENANCE OF GROUND 03 FORESTRY PROGRAM 04 PUBLIC GROUNDS BEAUTIFICATION 16,558 35,334 85,442 2,518 Totals 139,852 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUI PMENT 49,942 19,619 o 67,125 3,166 o Totals 139,852 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 139,852 o Totals 139,852 13 Y-T-D Expended 66,687 107,365 195,203 9,821 379,076 203,085 66,952 396 100,405 3,773 4,465 379,076 379,076 o 379,076 2007 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 216,107 517,535 841,572 95,998 1,671,212 697,162 228,406 3,555 644,224 70,470 27,395 1,671,212 1,660,293 10,919 1,671,212 149,420 410,170 646,369 86,177 1,292,136 494,077 161,454 3,159 543,819 66,697 22,930 1,292,136 1,281,217 10,919 1,292,136 69.1 79.3 76.8 89.8 77.3 70.9 70.7 88.9 84.4 94.6 83.7 77.3 77.2 100.0 77 .3 05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 59,778 29,694 Totals 89,472 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 45,350 16,432 o 7,671 13,103 6,916 o o o Totals 89,472 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 75,369 14,103 Totals 89,472 14 Y-T-D Expended 237,665 91,755 329,420 196,911 59,675 562 17,812 44,202 10,258 o o o 329,420 295,679 33,741 329,420 2007 Budget 768,027 526,180 1,294,207 622,116 191,927 5,390 146,669 249,000 26,985 530 1,590 50,000 1,294,207 1,010,867 283,340 1,294,207 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 530,362 434,425 964,787 425,205 132,252 4,828 128,857 204,798 16,727 530 1,590 50,000 964,787 715,188 249,599 964,787 69.1 82.6 74.5 68.3 68.9 89.6 87.9 82.2 62.0 100.0 100.0 100.0 74.5 70.7 88.1 74.5 .05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 PUBLIC WORKS - WATER/SEWER Cur Mo Expended PROGRAM TOTALS 01 WATER & SEWER DIVISION ADMIN 02 MAINTENANCE OF BUILDINGS 03 MAINTENANCE OF GROUNDS 04 WATER SUPPLY MAINT & REPAIR 05 WATER DISTRBT MAINT & REPAIR 06 WATER VALVE/HYDRNT MAINT & REP 07 WATER METER MAINT & REPL 08 EQUIPMENT MAINTENANCE 09 SANITARY SEWER MAINT & REPAIR 10 WATER & SEWER SYSTEM IMPROV 12 LAKE MICHIGAN WATER SUPPLY 133,792 14,031 4,302 34,607 45,240 30,503 26,640 60,609 40,631 163,344 186,748 Totals 740,447 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 68 DISTRIBUTION SYSTEMS 71 BOND PRINCIPAL 136,652 55,522 1,613 351,676 5,280 13,566 8,464 o 112 4,218 163,344 o Totals 740,447 SOURCE OF FUNDS 610 WATER AND SEWER FUND 740,447 Totals 740,447 15 Y-T-D Expended 445,770 51,464 17,143 152,710 157,441 91,961 111,343 181,827 98,475 175,157 712,380 2,195,671 526,161 187,504 9,567 1,163,070 20,431 40,699 28,267 o 112 31,230 188,630 o 2,195,671 2,195,671 2,195,671 2007 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 1,468,391 193,622 102,407 880,371 1,390,832 364,297 355,821 606,091 491,494 1,830,000 3,448,305 11,131,631 1,783,337 633,956 33,625 5,603,389 202,875 135,664 205,285 o 7,415 801,285 1,724,800 o 11,131,631 11,131,631 11,131,631 1,022,621 142,158 85,264 727,661 1,233,391 272,336 244,478 424,264 393,019 1,654,843 2,735,925 8,935,960 1,257,176 446,452 24,058 4,440,319 182,444 94,965 177,018 o 7,303 770,055 1,536,170 o 8,935,960 8,935,960 8,935,960 69.6 73.4 83.3 82.7 88.7 74.8 68.7 70.0 80.0 90.4 79.3 80.3 70.5 70.4 71.5 79.2 89.9 70.0 86.2 98.5 96.1 89.1 80.3 80.3 80.3 05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 04/30/07 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 320,352 9,792 Totals 330,144 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 13,011 5,407 o 306,435 25 5,266 o Totals 330,144 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 330,144 Totals 330,144 16 Y-T-D Expended 1,076,847 40,494 1,117,341 54,540 18,651 o 1,024,787 165 15,798 3,400 1,117,341 1,117,341 1,117,341 2007 Budget 3,825,838 203,769 4,029,607 230,544 71,446 1,785 3,654,352 590 52,660 18,230 4,029,607 4,029,607 4,029,607 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 2,748,991 163,275 2,912,266 176,004 52,795 1,785 2,629,565 425 36,862 14,830 2,912,266 2,912,266 2,912,266 71.9 80.1 72.3 76.3 73.9 100.0 72 .0 72.0 70.0 81.3 72.3 72.3 72.3 .05/09/2007 14,37,56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 02 VEHICLE MAINTENANCE PROGRAM 12,715 105,899 118,614 Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 45,049 19,586 o 6,954 61 46,964 o o o Totals 118,614 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 118,614 Totals 118,614 17 Y-T-D Expended 57,281 379,003 436,284 206,186 70,619 o 15,573 443 143,463 o o o 436,284 436,284 436,284 2007 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 185,783 1,387,570 1,573,353 695,541 237,031 2,250 78,151 1,060 555,370 o 530 3,420 1,573,353 1,573,353 1,573,353 128,502 1,008,567 1,137,069 489,355 166,412 2,250 62,578 617 411,907 o 530 3,420 1,137,069 1,137,069 1,137,069 69.2 72.7 72.3 70.4 70.2 100.0 80.1 58.2 74.2 100.0 100.0 72.3 72 .3 72.3 05/09/2007 14:37:56 FRRDBROl SUM031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 COMMUNITY SERVICE PROGRAMS Cur Mo Expended PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 03 4TH OF JULY & CIVIC EVENTS,ETC 04 HOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM 308 o 551 217 Totals 1,076 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 520 197 308 o 51 o Totals 1,076 SOURCE OF FUNDS 001 GENERAL FUND 1,076 Totals 1,076 18 Y-T-D Expended 35,476 105 15,027 811 51,419 2,150 661 40,441 o 8,256 -89 51,419 51,419 51,419 2007 Budget 126,100 136,685 87,178 2,887 352,850 88,650 16,210 208,875 o 29,115 10,000 352,850 352,850 352,850 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 90,624 136,580 72,151 2,076 301,431 86,500 15,549 168,434 o 20,859 10,089 301,431 301,431 301,431 71.9 99.9 82.8 71.9 85.4 97.6 95.9 80.6 71.6 100.9 85.4 85.4 85.4 . 05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 CAPITAL IMPROVEMENT PROJECTS Cur Mo Expended PROGRAM TOTALS 01 VILLAGE IMPROVEMENTS & EQUIP 02 COMMUNITY IMPROVEMENT PROJECTS 03 DOWNTOWN REDEVELOPMENT CONST 04 FLOOD CONTROL PROJECTS 06 STREET IMPROVEMENT PROJECTS 09 MOTOR EQUIPMENT REPLACEMENT 10 COMPUTER REPLACEMENT 8,958 o 37,205 o 316,009 73,978 o Totals 436,150 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 55 UTILITIES 59 OTHER EXPENDITURES 62 LAND IMPROVEMENTS 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 66 MOBILE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 72 INTEREST EXPENSE 80 INTERFUND TRANSFERS 10,208 o 31,647 o 1,308 o 73,978 o 319,009 o o Totals 436,150 SOURCE OF FUNDS 050 MOTOR FUEL TAX FUND 510 CAPITAL IMPROVEMENT FUND 526 SERIES 2003 PROJECT FUND 550 DOWNTOWN REDEVLPMNT CONST 560 STREET IMPROVEMENT CONST FUND 590 FLOOD CONTROL CONST FUND 630 PARKING SYSTEM REVENUE FUND 670 VEHICLE REPLACEMENT FUND 680 COMPUTER REPLACEMENT FUND 316,009 8,958 o 37,205 o o o 73,978 o Totals 436,150 19 Y-T-D Expended 80,532 o 72,507 o 316,009 115,065 o 584,113 63,917 o 31,647 o 1,308 o 135,880 4,224 325,302 21,835 o 584,113 316,009 80,532 o 72,507 o o o 115,065 o 584,113 2007 Budget 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 653,000 10,000 1,880,300 244,000 3,369,100 961,470 249,050 7,366,920 369,100 o 1,778,000 o 245,000 274,050 1,065,470 313,000 3,280,000 42,300 o 7,366,920 1,223,100 738,000 o 1,880,300 2,071,000 244,000 o 961,470 249,050 7,366,920 572,468 10,000 1,807,793 244,000 3,053,091 846,405 249,050 6,782,807 305,183 o 1,746,353 o 243,692 274,050 929,590 308,776 2,954,698 20,465 o 6,782,807 907,091 657,468 o 1,807,793 2,071,000 244,000 o 846,405 249,050 6,782,807 87.7 100.0 96 .1 100.0 90.6 88.0 100.0 92.1 82.7 98.2 99.5 100.0 87.2 98.7 90.1 48.4 92.1 74.2 89.1 96 .1 100.0 100.0 88.0 100.0 92.1 05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 DEBT SERVICE Cur Mo Expended PROGRAM 02 03 04 05 06 TOTALS DEBT SERVICE - PROPERTY TAXES DEBT SERVICE - TAX INCREMENT DEBT SERVICE - H/R SALES TAX 1 DEBT SERVICE - H/R SALES TAX 2 SPECIAL SERVICE AREA B & I o o 168,630 o o Totals 168,630 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS o 129,341 39,289 o o Totals 168,630 SOURCE OF FUNDS 140 180 190 200 230 290 340 350 360 380 390 400 430 440 830 SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. SSA #6 GEORGE/ALBERT B&I o o o o o o o o o 168,630 o o o o o Totals 168,630 20 Y-T-D Expended 405,300 73,050 188,575 o o 666,925 o 244,359 421,666 900 o 666,925 405,000 o 300 o o 73,050 o o o 188,275 300 o o o o 666,925 2007 Budget 1,685,359 1,069,675 1,408,894 o o 4,163,928 o 2,874,195 1,286,733 3,000 o 4,163,928 405,000 383,765 896,594 o o 916,100 o 67,795 153,575 613,356 727,743 o o o o 4,163,928 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent 1,280,059 996,625 1,220,319 o o 3,497,003 o 2,629,836 865,067 2,100 o 3,497,003 o 383,765 896,294 o o 843,050 o 67,795 153,575 425,081 727,443 o o o o 3,497,003 76.0 93.2 86.6 84.0 91.5 67.2 70.0 84.0 100.0 100.0 92.0 100.0 100.0 69.3 100.0 84.0 . 05/09/2007 14:37:56 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 4 Months 8 Months 33.3% 66.6% Completed Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 3,711 14,844 44,533 29,689 66.7 208,922 807,039 2,465,133 1,658,094 67.3 233,242 883,146 2,627,958 1,744,812 66.4 445,875 1,705,029 5,137,624 3,432,595 66.8 RETIREE PENSIONS PROGRAM 01 02 03 TOTALS MISCELLANEOUS PENSIONS POLICE PENSIONS FIRE PENSIONS EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES Totals 445,125 1,704,210 5,131,324 3,427,114 66.8 750 750 5,800 5,050 87.1 0 69 500 431 86.2 445,875 1,705,029 5,137,624 3,432,595 66.8 SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FUND 720 FIRE PENSION FUND Totals 3,711 14,844 44,533 29,689 66.7 208,922 807,039 2,465,133 1,658,094 67.3 233,242 883,146 2,627,958 1,744,812 66.4 445,875 1,705,029 5,137,624 3,432,595 66.8 21 05/09/2007 14:37:56 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 4 Months 8 Months 33.3% 66.6% Completed Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 102,664 578,099 1,360,353 782,254 57.5 408,257 1,701,702 5,142,924 3,441,222 66.9 510,921 2,279,801 6,503,277 4,223,476 64.9 RISK MANAGEMENT PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 67 OTHER EQUI PMENT Totals 42 6,042 34,000 27,958 82.2 510,879 2,273,759 6,463,777 4,190,018 64.8 0 0 5,500 5,500 100.0 510,921 2,279,801 6,503,277 4,223,476 64.9 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 510,921 2,279,801 6,503,277 4,223,476 64.9 Totals 510,921 2,279,801 6,503,277 4,223,476 64.9 22 .05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 NON-DEPARTMENTAL Cur Mo Expended Y-T-D Expended 2007 Budget PROGRAM TOTALS 01 CONTINGENCIES o o Totals o o EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS o o Totals o o SOURCE OF FUNDS 001 GENERAL FUND 560 STREET IMPROVEMENT CONST FUND 670 VEHICLE REPLACEMENT FUND o o o o o o Totals o o 23 33.3% 66.6% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o o o o o 05/09/2007 14:37:56 FRRDBROl SUM 031 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 CAPITAL FIXED ASSETS Cur Mo Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 00 CAPITAL FIXED ASSETS Totals EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES Totals SOURCE OF FUNDS 910 GENERAL FIXED ASSETS ACCT GP Totals 24 Y-T-D Expended 2007 Budget o o o o o o o o o o o o 33.3% Completed 66.6% Remaining o o o o o o o o o o o o . 05/09/2007 14,37,56 FRRDBROl SUM03l 4 Months 8 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 04/30/07 MOUNT PROSPECT LIBRARY Cur Mo Expended Y-T-D Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 LIBRARY SERVICES o Totals o EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES o Totals o SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND o Totals o 25 2007 Budget o 8,572,028 o 8,572,028 o 8,572,028 o 8,572,028 o 8,572,028 o 8,572,028 33.3% 66.6% Completed Remaining 8,572,028 100.0 8,572,028 100.0 8,572,028 100.0 8,572,028 100.0 8,572,028 100.0 8,572,028 100.0