The URL can be used to link to this page

Home My WebLink About3. BILLS & FINANCIALS 6/19/07 VILLAGE OF MOUNT PROSPECT CASH POSITION June 01 - 13, 2007 Cash & Invstmt Receipts Disbursements Disbursements Cash & Invstmt Balance 06/01/07 Per Attached Per Attached Balance 06/01/07 06/13/07 List of Bills List of Bills 06/13/07 General Fund 8,999,734 1,650,765 580,041 10,070,458 Soecial Revenue Funds Refuse Disposal Fund 1,669,603 84,628 319,908 1,434,323 Motor Fuel Tax Fund 735,873 146,659 211,934 670,598 Local Law Enforcement Block Grant Fund 767 767 Community Development Blk Grant Fund 70,785 1,666 69,119 Asset Seizure Fund 79,812 500 79,312 DEA Shared Funds 50,160 50,160 DUI Fine Fund 38,929 1,682 520 40,091 Foreign Fire Tax Board Fund 52,906 52,906 Debt Service Funds 1,693,162 111,292 118,404 1,686,050 Caoital Proiects Funds Capital Improvement Fund 802,008 6,579 9,864 798,723 Downtown Redevelopment Const Fund 1,997,001 1,203 1,995,798 Street Improvement Construction Fund 1,755,279 114,216 9,490 1,860,005 Flood Control Construction Fund 640,099 1,000 639,099 Enterorise Funds Water & Sewer Fund 4,584,538 331,074 408,737 4,506,875 Village Parking System Fund 80,368 4,180 92 84,456 Parking System Revenue Fund (13,906) 3,455 402 (10,853) Internal Service Funds Vehicle Maintenance Fund 466,218 7,735 458,483 Vehicle Replacement Fund 6,418,161 51 ,362 6,366,799 Computer Replacement Fund 753,198 753,198 Risk Management Fund 2,658,015 27,563 426,834 2,258,744 Trust & Aaency Funds Police Pension Fund 40,627,616 29,513 5,033 40,652,096 Fire Pension Fund 40,559,050 25,011 3,267 40,580,794 Flexcomp Trust Fund 23,233 10,653 19,173 14,713 Escrow Deposit Fund 1,622,438 211,386 13,254 22,400 1,798,170 116,365,047 2,758,656 2,190,419 22,400 116,910,884 TOTAL DISBURSEMENTS PER ATTACHED LISTS OF BILLS 2,212,819 REPORT: A~BOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 001 09656 ACCURINT - ACCOUNTI1037332 BACKGROUND CHECKS 65.35 01071 ADDISON BUILDING MATERIAL CO. HARDWARE & BUILDING SUPPLIES 62.25 HARDWARE & BUILDING SUPPLIES 73.43 HARDWARE & BUILDING SUPPLIES 15.29 HARDWARE & BUILDING SUPPLIES 15.54 HARDWARE & BUILDING SUPPLIES 167.23 ------------- 333.74 05205 AIRGAS NORTH CENTRAL OXYGEN RENTAL 131.11 08573 ALAN O.AMOS & ASSOC., P.C. REAL ESTATE TAX VOID 330.00 09619 ALANIZ LANDSCAPING GROUP SPRING 2007 TREE PRANTING 9405.00 SPRING 2007 TREE PRANTING 4264.00 --------- ---- 13669.00 01335 ALEXIAN BROTHERS CORPORATE HEALTH SERVI CES PRE - EMPLOYMENT HEALTH SCREENIN 228.00 PRE - EMPLOYMENT HEALTH SCREENIN 272.00 PRE-EMPLOYMENT DT/PHYSICALS 532.00 INV#232257 PRE-EMPLOY PHYSICAL 228.00 ------------- 1260.00 10170 AMERA-CHEM, INC. DRUG IDENTIFICATION BIBLE 41.95 01620 AMERICAN LANDSCAPING INC. RETAINING WALL REPAIRS 300.00 CUT LAWN & SPRAYED WEEDS 357.00 ------------- 657.00 08824 AMERICAN NATIONAL SKYLINE, INC. ANNUAL WINDOW CLEANING CONTRAC 1285.00 09544 ANDRES MEDICAL BILLING,LTD AMBULANCE COLLECT I ON FEES 5688.73 08911 APPLIED CONTROLS, INC. SERVI CE AND MAINTENANCE AGREEM 1980.00 02001 ARAMARK UNI FORM SERVI CES , INC. OPEN PURCHASE ORDER/ Uniform 52.96 02070 ARLINGTON HEIGHTS FORD DEDUCTIBLE FOR REPAIR #503 100.00 REPAIR KIT 10.68 ..-......._------- 11 D.6 8 01124 ARTHUR CLESEN, INC. 6 - 27" ALUMINUM HANDLES 218.19 6 - 47" WOODEN HANDLES 226.50 ---...---....-....- 444.69 09252 ASSOCIATED BAG COMPANY ET SUPPLIES 204.49 02270 AT&T SERVICE 18.00 SERVICE 60.01 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 PAGE DEPT VENDOR NBR .... - -.. --......" --.......... --.................................................. --............ --.......................... --.......... --........-.. --.......................... ---.......... --............................ --.............. AMOUNT VENDOR NAME INVOICE DESCRIPTION .......... ---...... --.................................................... --.......... --...................................................................... --.......................................................................... --.. --........ 02270 05044 01555 00435 10173 02823 08576 08573 10181 SERVICE SERVICE SERVICE SERVICE SERVI CE SERVICE SERVICE SERVICE SERVI CE SERVI CE SERVICE SERVI CE SERVICE SERVICE SERVI CE SERVICE AT&T LONG DISTANCE SERVICE SERVICE SERVICE SERVI CE SERVI CE SERVI CE SERVI CE SERVI CE SERVICE SERVI CE SERVI CE SERVICE SERVI CE SERVI CE SERVICE SERVI CE A VI S RENT A CAR SYSTEM TAC UNIT LEASE-MAY 2007 B . HANEY & SONS, INC. 65 YARDS OF MULCH DELIVERED FRT. BEACH, JUSTIN REIMBURSE EXPENSES BEVERLY, CHRISTOPHER REIMBURSEMENT BILL'S POWER EQUIPMENT & REPAIR REPAIR PARTS BIO-TRON INC ANNUAL PREVENTATIVE MAINT. BOARINI. BARBARA & MATTHEW REAL ESTATE TAX REBATE BONDAR, MlHAIL RE - INSPECTION REFUND 12.00 18.00 120.02 60.01 228.04 60.01 90.02 156.03 48.01 48.01 216.04 1218.23 1194.23 768.15 228.68 290.83 4834.32 0.29 0.98 0.20 0.29 1.96 0.98 3.72 0.98 1.47 2.54 0.78 0.78 3.52 19.85 19.46 12.51 70.31 769.99 815.00 40.00 855.00 20.00 119.3 5 23.70 300.00 1010.00 50.00 REPORT:AP~OARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 ~ - - - - - -. - - - -- - - -.. -.. -.... -...... -.... - --...... -............ -.. -.............. - -...................... -.. - -.................. -.............. --.............................. --.................................................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ............ --.............. --.................................................... --.............................................................................................................. -- --.... --.............................................. 05339 BOUND TREE MEDICAL, LLC 1 Manniquin Case 175 .12 01014 CAnE INDUSTRIES CUSTODIAL SUPPLIES 2764.0 0 ADDITIONAL CHARGES 79.50 REPLACMENT RIBBED MATS - VARIO 182 9.2 5 ADDT I L RIBBED FLOOR MAT /FRT 298.75 ------------- 4971.50 10175 CARDOZA, ADAM REIMBURSEMENT 91.79 01056 CENTRAL CONTINENTAL BAKERY CAKE AND COOKIES 117.63 05375 CENTURY CLEANERS UNI FORM CLEANING 267.77 01060 CENTURY TILE DEEP CLEANING CARPET FOAM 31.68 10187 CHICAGO'S NORTH SUBURBS CVB SNOW VISIONS LODGING EVENT 805.76 07281 CL GRAPHI CS, INC. INVI42938,42960 ,43019,43016 732 .00 03800 CLARK, SANDRA M. REIMBURSEMENT 37.42 08865 CLOSED CIRCUIT INNOVATIONS, INC. IVACS MAINTENANCE 427.00 01147 COMMONWEALTH EDISON MALES/SPECIAL EVENT LIGHTING 178.27 04543 CORPORATE EXPRESS OFFI CE SUPPLI ES 45.52 MISC. OFFICE SUPPLIES 220.70 --------..-..-- 266.22 08573 DAGGETT, MARY B. REAL ESTATE TAX REBATE 548.00 10182 DASH MEDI CAL GLOVES DI SPOSABLE GLOVES 674.10 09758 DAVIS, LAURA REIMBURSE EXPENSES 120.00 09837 DISPLAYS2GO DPORTABLE TABLETOP DDISPLAY BO 518.00 FRT. 12.43 ----- -------.. 530.43 01287 DOOR SYSTEMS, INC. REPAIRS TO WEST DOOR - PUBLIC 2596.53 01828 EL METENNANI, MAURA REIMBURSEMENT 69.00 05843 ENH OMEGA PHYS I CALS 446.00 PHYSICAL R KADZIELAWSKI 487.00 ------------- 933.00 08107 ERB, DAVID REIMBURSE TRAVEL & MEETINGS 326.00 01374 FAWLEY'S INC. HELMET SHIELDS ID TAGS 349.00 01377 FEDERAL EXPRESS CORP MOREL CASE 68.62 IEPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 . _ _ _ a _. _ _........ _................ _ _ __.... __.......................................................................... __................................................................................ __............ __ __........................ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ---.. ---.... -.. -------.. ----- ----- --- --- -----------.. --..- ---.. --.. ---- -----......... -.---- ---...... ---.---...... ------ ----- -..-..._..... ---- ---- --- ---- --_..... FEDEX PICK UP 310.85 DELIVERY TO KTJ 19.70 ... ----.. --- -.._- 399 .17 06311 FEDERAL SIGNAL-EMERG.PROD. SPEAKER W!O BRKT 123.55 01394 FIRE ENGINEERING SUBSCRIPTION 100.00 00102 FIRE PENSION FUND PAYROLL FOR - 060707 23390.72 05334 FIRST SECURITY SYSTEMS, INC. SERVICE TO STROBE CIRCUIT - 230.06 08573 FISHER, JAMES REAL ESTATE TAX REBATE 1080.00 10183 FORESIGHT RECONSTRUCTION, INC. PROFESS I ONAL SERVI CES 6301.01 01430 FORREST KEELING NURSERY ARBOR DAY SEEDLINGS (600 PCS) 405.12 01431 FOSTER COACH SALES INC. REPAIR PARTS FOR 1523 97.40 01461 GALL'S, INC. DISPOSABLE EMERGENCY BLANKETS 462.09 08154 GLOBAL EMERGENCY PRODUCTS ROCKER STYLE SWITCHES 231.84 05519 GRAPHIC ENTERPRISES K & E 3036 PLAN COPIER - 36.12 06420 GRAYBAR ELECTRIC CO. REPLACEMENT TRANSFORMERS AND 952.90 09205 HEALTH ENDEAVORS PRE- EMPLOYMENT WILEY, JEFFERY 802.00 09113 HEALY ASPHALT COMPANY,LLC. PATCHING AND PAVING SUPPLIES 644.94 08948 HEART PRINTING INC. CRIME FREE HOUSING BOOKS 689.40 CRIME FREE HOUSING BOOKS 594.50 CULVERS COUPONS FOR PHS 128.00 ----......._----- 1411.90 01610 HOME DEPOT CREDIT SERVICES HARDWARE & BUILDING SUPPLIES 13.11 HARDWARE & BUILDING SUPPLIES 168.94 -.....---...------ 182.05 09425 HSBC BUSINESS SOLUTIONS INV#39071 75.95 INV#025957 29.34 INV#010004 17.22 INV#001239, 008491, 039987 32.99 INV'001239, 008491, 039987 19.99 INVI001239, 008491, 039987 27.99 INV#14835!014678 47.51 INVI068090 16.31 ------------- 267.30 00107 ICMA RETIREMENT TRUST - 457 PAYROLL FOR - 060707 19579.48 lEPORT: AP?OARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 RELEASE ID ; PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 DEFT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - ~ - - - - -. - - - - - - - - - - - - - - - - -. - ~...... -.. - -.. - - - - -.. -.. - -.. -- - - - -.. - - - - - - - - -.. -.. - - - - - - -.. -.. - - - - - -- --.. -...... -- -.. - - - - - - -.. - - -.. - -.... - - - - - -- - - - -...... -...... -.. 10161 IDOA & ICPA 2007 TRAINING CONFERENCE REG I STER - ROSCOP & OLLECH 450.00 06690 ILLINOIS AMERICAN WATER CO. SERVICE AT 2000 KENSINGTON RD 211.32 07367 ILLINOIS CENTURY NETWORK INTERNET SERVICES 310.00 01671 ILLINOIS CPA SOCIETY DUES - CAROL WIDMER 255.00 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 060707 24568.15 01657 ILLINOIS LANDSCAPE CONTRACTORS ASSOC. CLT TRAINING SESSION FEE - MIC 35.00 01701 ILLINOIS PAPER CO. 40 CARTONS PAPER 1097.00 09898 ILLINOIS PUBLIC SAFETY AGENCY NETWORK PIMS CHARGE 1380.00 07763 ILLINOIS STATE CHAPTER SISTER CITIES STATE CHAPTER MEMBERSHIP 35.00 01122 ILLINOIS STATE DISBURSEMENT UNIT PAYROLL FOR - 060707 357.69 PAYROLL FOR - 060707 969.24 PAYROLL FOR - 060707 116.31 PAYROLL FOR - 060707 442.31 PAYROLL FOR . 060707 520.75 PAYROLL FOR - 060707 200.00 PAYROLL FOR - 060707 300.00 ------------- 2906.30 01712 ILLINOIS STATE POLICE FINGERPRINGING (NEW HIRE) 44.00 07433 IMAGETEC L P STAPLES FOR COPIERS 325.50 07433 IMAGETEC LP ID#90133759827 275.00 ID #90133759828 356.00 ID#90133770128 356.00 ID# 90133770 131 ,90133770126 115.00 ID#90133770131,90133770126 275.00 MONTHLY LEASE PAYMENT FOR TOSH 236.00 ID #90133643910 320.35 COPIER LEASE PAYMENT FOR FEB-D 586.13 OPEN PURCHASE ORDER/ Copier Le 320.35 ID #90133627542 169.00 ------------- 3008.83 09562 IMRF PAYROLL FOR . 060707 433.58 PAYROLL FOR . 060707 38410.71 PAYROLL FOR - 060707 18290.77 ---- --..------ 57135.06 01725 INLAND DIESEL, INC. REPAIR POWER PROBLEM #516 2651.07 07694 INTERNATIONAL CODE COUNCIL ASSOCIATE MEMBERSHIP 35.00 09832 INTERNATIONAL UNION OF OPERATING ENGINEERS PAYROLL FOR - 060707 776.17 PAYROLL FOR . 060707 242.55 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 PAGE DEPT VENDOR NBR - ~ - -. - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- AMOUNT 09563 00353 02408 10185 01794 09810 10123 01838 01872 08631 01897 01918 06479 01965 01990 05021 VENDOR. NAME INVOICE DESCRIPTION IRS PAYROLL FOR - 060707 JANONIS, MICHAEL E. LUNCH MEETING LUNCH MEET ING JOlIN E. REID AND ASSOCIATES PRE-EMPLOYMENT TESTING 1 SPECIFIC APPLICANT/ElLEY J. JUNIUS, MI CHAEL REIMBURSEMENT KALE UNIFORMS, INC. UNIFORM SUPPLIES BODY ARMOR KARLSTEDT LANDSCAPE, INC. REPLACEMENT SHRUBS KLEICH, MARIA K. REBATE FOR 5 SQUARES OF PUBLI C KRAMER TREE SPECIALISTS 2007 TREE REMOVAL CONTRACT LATTOF ARLINGTON HEIGHTS REPAIR PARTS FOR APRIL & MAY LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEANI 2007 UNIFORM RENTAL AND CLEANI LIFE ASSIST Zoll EKG Paper, Yellow Blanket LUNDSTROM'S NURSERY, INC. LANDSCAPING MAINTENANCE THROOG TURF MOWING AT VARIOUS LOCATIO REPLACEMENT SHRUBS M & B LANDSCAPING REMOVE AND REPLACE RETAINING W MARTAM CONSTRUCTION CONTRACTUAL HAULING CONTRACTUAL HAULING CONTRACTUAL HAULING MCMASTER-CARR SUPPLY CO. CANTILEVER STORAGE RACK FOR MENARDS 4' CHAIR GUIDES MISC. HARDWARE SUPPLIES 1018.72 195728.04 37.26 86.08 123.34 175.00 175.00 350.00 108.75 123.00 1350.00 1473.00 1030.00 235.00 6755.00 811. 96 228.27 114.14 342.41 489.94 6690.56 4513.8 5 173 7.2 5 12941. 66 4462 . 50 980.00 408.05 50.00 1438.05 832.93 39.96 41.21 81.17 REPORT: A~BOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 01996 MERCOMMBE I INC. CAT6 CABLE (3 SPOOLSl 169.39 CAT6 CABLE (3 SPOOLS 1 284.00 ~...................... - 453.39 00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 060707 2310.00 00117 METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - 060707 742.50 02046 MOBILE PRINT INC. Annual Inspections Forms 8 1/2 411.2 8 BUSINESS CARDS MORGAN & PERSIN 52.38 BUSINESS CARDS I MEMO PADS 78.57 ----..... ..------ 542.23 02058 MORTON GROVE AUTOMOTIVE 2 - ALTERNATOR REBUILDS mo 250.00 02067 MOUNT PROSPECT HISTORICAL SOC. BUDGET ALLOCATION FOR MAY 07 3333.33 2007 BUDGET ALLOCATION-JUNE 3333.33 ------------- 6666.66 02135 NATIONAL SAFETY COUNCIL ANNUAL MEMBERSHIP FEE 285.00 00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 060707 17250.79 08566 NEVERS I REGINALD REFUND OVERPAYMENT 24.00 09783 NEWSCLIP NEWSCLIP SERVICE 137 . 00 02155 NEXTEL COMMUNI CATIONS ACCT#157600518 1161.84 ACCT#157600518 208.37 ACCT#157600518 774.86 ACCT#157600518 30.36 ACCT#157600518 239.90 ACCT#l57600518 1396.49 ACCT#157600518 120.00 ACCT#157600518 727.91 ACCT#157600518 221.49 ACCT#157600518 582 .26 ACCT#157600518 96.59 ACCT#157600518 466.53 ACCT#157600518 99.99 NEW PHONE#847-875-1419 29.07 -----.... -- ---- 6155.66 08517 NI CHOLS I GREG REIMBURSEMENT 125.00 02170 NORTH EAST MULTI REGIONAL TRNG REGISTRATION 125.00 09168 NORTHCENTER CAMERA FILM PROCESSING 12.18 02182 NORTHERN ILLINOIS POLICE ALARM SYSTEM ANNUAL NIPAS MEETING 88.00 02189 NORTHWEST CENTRAL DISPATCH SYS SERVICES RENDERED 39390.57 \EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 RELEASE ID : PAGE VI LLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 . -. - - - -............................ - - -.. --.........................................-................................................................................................................................ --................................ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ....................... --.............. --...................................................................................................................... --...................................................... --.................................... SERVICES RENDERED 9847.60 -._---------- 49238.17 10164 NORTHWEST SUBURBAN UNITED WAY COMMUNITY CELEBRATION 60.00 10163 ON TIME INC. UNIFORM EMBLEMS 582.85 08930 OTIS ELEVATOR COMPANY ELEVATOR MAINTENANCE AGREEMENT 2233.77 02256 PADDOCK PUBLICATIONS SUBSCRIPTION 49.50 10177 PANCRATZ I JOlIN REIMBURSEMENT 119.3 5 10176 PETRAS, JUSTINE REIMBURSEMENT 47.91 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS 50.00 MISCELLANEOUS 46.90 MISCELLANEOUS 54.00 MISCELLANEOUS 23.22 MISCELLANEOUS 24.12 MISCELLANEOUS 7.91 MISCELLANEOUS 15.00 MISCELLANEOUS 32.00 MISCELLANEOUS 29.35 MI SCELLANEOUS 7.60 MISCELLANEOUS 25.00 MISCELLANEOUS 35.28 MISCELLANEOUS 149.47 ------------- 499.85 00124 POLICE PENSION FUND PAYROLL FOR - 060707 26430.09 04921 POPE, ELIZABETH A. PAYROLL FOR - 060707 923.08 02358 PRO-SAFETY, INC 2 CASES - EARPLUGS 39.90 SLUSH BOOTS - VARIOUS SIZES 103.50 .. ..----------- 143.40 02536 PROFORMA CUSTOMIZED GRAPHICS OPEN HOUSE GIVE-HAYS 191.10 02399 REBEL'S TROPHIES I INC. NAMEPLATE FOR BOARD ROOM 235.48 RESOLUTION PLAQUE 50.00 --------- ---- 285.48 09423 RONCO INDUSTRIAL SUPPLY I' X 10' AND l' X 8' WOV-N-WIR 280.00 02524 SEARS COMMERCIAL ONE TOOLS AND HARDWARE SUPPLIES 25.65 THERMOMETER W/LASER POINTER 66.24 .. ----.. ------.. 91.89 02525 SECRETARY OF STATE TITLE AND PLATES 150.00 PLATE STICKER RENEWAL 78.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION 09267 SECURE ECO SHRED SHREDDING 10165 SHERATON GREENSBORO HOTEL AT FOUR SEASONS LODGING FOR S. BURRELL 02559 SIRCHIE FINGER PRINT LABORATOR ET SUPPLIES 10179 SOLANKI, GIDION BUILDING REFUND-PERMIT 06-629 09165 STAPLES BUSINESS ADVANTAGE SUPPLI ES PRINTER CARTRIDGES SUPPLIES 02627 STEINER ELECTRIC COMPANY REPLACEMENT BALASTS 09915 SUPER WAREHOUSE GOV REPLACEMENT HP 5500DTN PRINTER HIGH GLOSS PLOTTER PAPER #Q143 04532 TAYLOR RENTAL CENTER 12 STANTION WHITE LINE DIVIDER 02722 TRI -STATE ELECTRONIC CORP STREETLIGHT REPAIR SUPPLIES 06509 TRITON COLLEGE REGISTRATION FEE FOR JIM PICAR 05686 ULINE INC. ET SUPPLIES 00127 UNI TED WAY PAYROLL FOR - 060707 04025 UNIVERSITY OF ILLINOIS REGISTER A TEEVAN 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 060707 04314 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES PAYROLL FOR - 060707 02814 VILLAREAL, JOEL REIMBURSEMENT 09893 VOLER CORPORATION CAR SEAT ORGANIZER SHIPPING 02835 WAREHOUSE DIRECT SUPPLIES 10178 WILLIAMS, JOAN REBATE FOR 5 SQ OF PUBLIC WALK 05746 WISCTF PAYROLL FOR - 060707 09315 WORKPLUS OCCUPATIONAL HEALTH - RHC MICHAEL DEE/RYAN RIVARD 10171 ZINGER , DAVID REIMBURSEMENT PAGE AMOUNT 228.00 357.75 351.80 196.01 25.00 258.58 28.50 190.23 477.31 574.72 487.00 342.00 829.00 123.20 30.00 350 .00 105.70 314.3 5 412 9.2 8 23915.69 2395.86 50.00 23.96 6.95 30.91 172.91 235.00 542.48 230.00 108.75 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 PAGE 10 RELEASE I D : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 -.- - - ----.. ---- -- - -----.._-- -..- --..--- --.. -.. --- ---.. --.. ---- -- .--.-.. --.. -.......- --...---- -..- ------ --.. --.. -._-----.. -- --- -._----- .._--_...._--_........_- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - --.. ----...... -----........ ---..-.. --.... -- --- --.. -.-........ -- --.... --- ---.... -- ..--- ---------- ----- ---.. -- -...... -- ---- ---- -------..--.... ---.._-_..-- ------ --.. TOTAL : 580040.51 l30 Olon ADDISON BUILDING MATERIAL CO. HARDWARE & BUILDING SUPPLIES 102.57 02016 ARC DISPOSAL C(XolPANY MAY COLLECTIONS 77254.96 MAY COLLECTIONS 13728.23 MAY COLLECTIONS 46164.54 MAY COLLECTIONS 31021. 23 MAY COLLECTIONS 5396.54 MAY COLLECTIONS 2323.19 MAY COLLECTIONS 37422.00 ---...... ------.. 213310.69 02270 AT&T SERVI CE 24.00 02270 AT&T LONG DISTANCE SERVI CE 0.39 02155 NEXTEL COMMUNICATIONS ACCTm7600518 92.12 02536 PROFORMA CUSTOMI ZED GRAPHI CS OPEN HOUSE GIVE-A-WAYS 39.84 09887 SCHAEFER SYSTEMS INTERNATIONAL, INC. RECYCLING CARTS 2205.00 09635 WELLS FARGO BANK TIPPING FEES 97667.78 FIXED COSTS 6465.94 -........-----....- 104133. n TOTAL 319908.33 )50 02167 ARROW ROAD CONSTRUCTION 2007 STREET RESURFACING PROJEC 192833.49 10103 CIVILTECH ENGINEERING, INC. 2007 PEDESTRIAL SIGNAL IMPROVE 935.53 2007 PEDESTRIAL SIGNAL IMPROVE 13415.58 ------..------ 14351.11 01148 COMMONWEALTH EDI SON STREET & TRAFFIC LIGHTING 3749.87 05709 MEADE ELECTRI C CO. INC. 2007 TRAFFIC SIGNAL MAINTENANC 1000.00 TOTAL 211934.47 170 09573 SLOAN, CLARE TUITION REIMBURSEMENT 1666.00 TOTAL 1666.00 80 09425 HSBC BUSINESS SOLUTIONS INVN039987 499.98 TOTAL 499.98 86 EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 PAGE 11 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 - - - - - - -. - - - -. -.. - - - - -. - -. - - -. - - - - - - - - - - - - - - - - - --- - - - - - - - - - - - - - - - - - -.. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - --- - - - - - - - - - - - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- 08049 KARA COMPANY INC. BATTERIES 520.00 TOTAL 520.00 80 06752 ILLINOIS EPA IEPA LOAN L17.1087 #5 42047.57 P & I DUE 6/3/07 16205.22 IEPA LOAN Ll7-0857 #1 46075.74 P & I DUE 6/10/07 14074.99 ------------- 118403.52 TOTAL 118403.52 10 05007 LANDMARK FORD (11) 2007 FORD CROWN VICTORIA 7752.00 10156 MERIDIAN IT INC. INV#M4355- IN 750.00 06406 SRBL ARCHITECHTS, LTD. FACILITY STUDY 1211. 90 09028 ZIEBART TIDY CAR UNDERCOAT UNDERSIDE OF CAR 150.00 TOTAL 9863.90 50 09619 ALANIZ LANDSCAPING GROUP SPRING 2007 TREE PRANTING 600.00 09788 KARLSTEDT LANDSCAPE, INC. SUMMER, FALL AND WINTER URN 603.00 TOTAL 1203.00 50 02167 ARROW ROAD CONSTRUCTION CURB & GUTTER INSTALLATION 9490.00 TOTAL 9490.00 10 10180 HARDERS I STEPHEN & LORETTA FLOOD PREVENTION REBATE 1000.00 TOTAL 1000.00 lO 01071 ADDISON BUILDING MATERIAL CO. HARDWARE & BUILDING SUPPLIES 7.55 HARDWARE & BUILDING SUPPLIES 520.46 - - --- -- -_.- -- 528.01 01335 ALEX IAN BROTHERS CORPORATE HEALTH SERVICES PRE-EMPLOYMENT HEALTH SCREENIN 272.00 01620 AMERICAN LANDSCAPING INC. PARKWAY RESTORATION AT VARIOUS 2508.91 PARKWAY RESTORATION AT VARIOUS 1420.14 - ---- --- ----- 3929.05 02270 AT&T SERVICE 1622 .66 SERVICE 1602.29 IE PORT : APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 PAGE 12 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 .~ -. - -............. ----- -- -- ------- --..... -- -- ----.. - --.. ------.. -- --------------------..-.... --- --.. --.......... -- ---.. ---- ----- ---.. ---- -------- ----...... --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ...................................................... --.......................................................... .......-............ --...... -_........ --................................................................................... -- --................... SERVI CE 300.29 -------- --...... 3525.24 02270 AT&T LONG DISTANCE SERVICE 26.09 09852 BANK OF NEW YORK WATER 174498.00 POWER 9784.00 0& M 36460.00 FIXED 83355.00 ------------- 304097.00 04572 BIGUS, BOB REIMBURSEMENT 10.00 06476 BURNS & MCDONNELL ENGINEERING DISINFECTION BIPRODUCTS PHASE 46363.92 DISINFECTION BIPPRODUCT 2167.92 ------------- 48531.84 09682 CE DESIGN, LTD. PROFESSIONAL SERVICES FOR PROS 2581.43 05375 CENTURY CLEANERS UNIFORM CLEANING 267.76 05434 CORRPRO COMPANIES I INC. ANNUAL INSPECTION OF CATHODIC 2000.00 ADD r L CHARGE 70.00 ----------- -. 2070.00 08319 CRESCENT ELECTRIC SUPPLY CO 80 OW HEATER - ELEVATED TANK 309.15 01283 DIXON ENGINEERING PROFESSIONAL SERVICES - TANK 2760.00 08567 DRAKONTAIDIS I ANTONI OS REFUND FINAL UTILITY BILL 50.61 01313 DUPAGE TOPSOI L INC. 3 LOADS OF PULVERIZED TOPSOIL 720.00 06045 EARTH INC. 2 - LOADS OF PULVERIZED TOPSOI 470.00 01323 EAST JORDAN IRONWORKS 6 - 2' MANHOLE ADJUSTING RINGS 660.00 08425 FARNSWORTH GROUP GENERATOR STUDY 8242.77 01377 FEDERAL EXPRESS CORP COURIER SERVICES 2007 162.13 08567 FINN, MARY REFUND FINAL UTILITY BILL 5.68 01522 GRAINGER INC. RECHARGEABLE BATTERIES AND CHA 232.92 01559 HANSEN INFORMATION TECHNOLOGY TRAVEL EXPENSES FOR GIS/GEO 4002.67 10174 HANSON, KRYSTAL REIMBURSEMENT 59.65 01544 HBK WATER METER SERVI CE 2007 CONTRACT FOR WATER METER 268.68 2007 CONTRACT FOR WATER METER 633.31 2007 CONTRACT FOR WATER METER 261.51 2007 CONTRACT FOR WATER METER 390.95 EPORT: Af'~OARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15: 26 RELEASE ID : PAGE 13 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - -. - - - -- - - - - - - - - - - -. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - -- 2007 CONTRACT FOR WATER METER 921.53 2007 CONTRACT FOR WATER METER 380.52 .--- -._--- --- 2856.50 09883 lID WATERWORKS, LTD. 3 - 280359 MAIN VALVE REAIR KI 684.45 07433 IMAGETEC LP MONTHLY LEASE PAYMENT FOR TOSH 236.00 01819 KIEFT BROTHERS INC. MANHOLES RISERS 150.00 08631 LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEANI 228.27 2007 UNIFORM RENTAL AND CLEANI 114.13 ------------- 342.40 01918 LUNDSTROM I S NURSERY, INC. TURF MOWING AT VARIOUS LOCATIO 685.35 01965 MARTAM CONSTRUCTION CONTRACTUAL HAULING 1566.31 08567 MILLER, STEVEN REFUND FINAL UTILITY BILL 139.06 02155 NEXTEL COMMUNICATIONS ACCT#157600518 596.50 ACCT#157600518 34.00 ------ ------- 630.50 08567 NGUYEN, THANH V. REFUND FINAL UTILITY BILL 10.00 05256 NI COR SERVI CE 296.68 02358 PRO- SAFETY, INC SLUSH BOOTS - VARIOUS SIZES 103.50 02536 PROFORMA CUSTOMIZED GRAPHICS OPEN HOUSE GIVE. HAYS 148.68 OPEN HOUSE GIVE-HAYS 48.19 ------- ------ 196.87 09475 SHARP, LUKE REIMBURSEMENT 46.00 10172 SKOWERA, JEFF REIMBURSEMENT 80.24 07139 STRADA CONSTRUCTION CO. 2007 CONCRETE RESTORATION PROJ 16613.47 09915 SUPER WAREHOUSE GOV REPLACEMENT HP 5500DTN PRINTER 487.00 02839 WATER ENVIRONMENT FEDERATION ANNUAL MEMBERSHIP FEE - LUKE S 99.00 TOTAL 408737.33 !O 10184 DITANTO, TONY MR. REFUND METRA PARKING 52.00 10186 EVERS, DEBBIE REFUND METRA PARKING CARD MONI 30.00 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS 10.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142001 15:26 RELEASE ID : PAGE 14 VILLAGE OF MOUNT PROSPECf LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2001 TO JUNE 13 2007 - - - - - - -.. -.. -......... -.. --........................................................ --................................................... --.............................................................................................................. DEFT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ...................... --.................................... --.......................... --................................. -......................................................................... ---........................................................ TOTAL : 92.00 630 01147 COMMONWEALTH EDISON MALES/SPECIAL EVENT LIGHTING 300.31 05256 NI COR SERVI CE 101.25 TOTAL 401.56 560 01187 AETNA TRUCK PARTS GROTE LIGHTING MODULE 194.80 09676 AMERICAN MESSAGING PAGER MESSAGING SERVICE 53.53 02108 ARLINGTON POWER EQUI PMENT STIHL OIL FILTER CAP 6.30 02270 AT&T SERVICE 60.04 02270 AT&T LONG DISTANCE SERVI CE 0.98 06468 BP GASOLINE 58.03 03958 CHICAGO INTERNATIONAL TRUCK REPLACE FUEL INJECfION PUMP 3015.46 08705 GENUINE PARTS COMPANY -NAPA AUTOMOTIVE REPAIR PARTS 530.80 02486 JOlIN SAKASH COMPANY I INC. REPAIR ROPE 100.00 06691 JUST TIRES E RANGE TIRES & STATE TIRE FEE 493.36 GOODYEAR TIRES 263.56 ------------- 756.92 01872 LATTOF ARLINGTON HEIGHTS PARTS & SERVICE 672.67 PARTS & SERVICE 14.83 ------------ .. 687.50 02155 NEXTEL COMMUNICATIONS ACCT#157600518 385.92 07663 PRAIRIE INTERNATIONAL TRUCK SALES FUEL SHUT OFF SOLENOID 129.58 02424 REX RADIATOR & WELDING CO,INC. CLEAN INSIDE OF FUEL TANK 248.00 09423 RONCO INDUSTRIAL SUPPLY GRIT BORE POLISHER 166.05 02524 SEARS COMMERCIAL ONE TOOLS AND HARDWARE SUPPLI ES 46.08 08184 SNAP ON INDUSTR IAL SNAP ON SCANNER UPDATE 698.00 02581 SOLVENT SYSTEMS INT r L. INC. GREASE GATOR 200.00 02684 TERRACE SUPPLY COMPANY RENTAL OF WELDING CYLINDERS FO 14.40 HEL242 HELIUM CLINDERS 278.28 ------------- 292.68 ,EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 PAGE 15 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 . ~ ~ - - -- - - - -- - - - - - - - - - - -. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT . - - - - __ __ - ____ __ ____ _________ - - w_ _ _ _ ____ _ _ _ ___ _ __ _w _ _ ____ ____________ __ ___ _____ ___ ____ ___ __ __ _ ________________ _ _ _ __ _ __ _ _._ _____ ____ 02769 UPTOWN AUTO SUPPLY MOTORCRAFT WATER PUMP 68.19 02870 WHOLESALE DIRECT INC. FREIGHT CHARGE 36.60 TOTAL 7735.46 ;70 04579 CUSTOM VEHICLE SYSTEMS, INC. INSTALL POLICE EMERGENCY LIGHT 1969.90 INSTALL POLICE EMERGENCY LIGHT 1412.40 ---- - - ------- 3382.30 05007 LANDMARK FORD (11) 2007 FORD CROWN VICTORIA 34884.00 01872 LATTOF ARLINGTON HEIGHTS PARTS & SERVICE 116.32 01914 LUND INDUSTRIES, INC. PUBLIC SAFETY LIGHT BAR 1756.00 07663 PRAIRIE INTERNATIONAL TRUCK SALES EXTENDED WARRANTY FOR NEW 2007 380.00 EXTENDED WARRANTY FOR NEW 2007 mo.oo -- ----- ------ 1560.00 02569 R.G. SMITH EQUIPMENT CO. F - 5 ROOT UNDERBODY 10 I SCRAPER 6274.00 F-5 ROOT UNDERBODY HYDRAULIC 1019.00 - ----- --- ---- 7293.00 02870 WHOLESALE DIRECT INC. 6 - LL839J CODE 3 PSE 39' AMBE 2220.00 09028 ZIEBART TIDY CAR UNDERCOAT UNDERSIDE OF CAR 150.00 TOTAL 51361.62 90 10072 CANNON COCHRAN MANAGEMENT SERVlCES,INC. CLAIMS ADMIN -GENERAL DATA CONV 2250.00 CLAIMS ADMIN -GENERAL CLAIMS RU 14525.00 ------------- 16775.00 01737 INTERGOVERNMENTAL PER. BEN. COOP INSURANCE FOR JUNE 36777 .28 INSURANCE FOR JUNE 119126.90 INSURANCE FOR JUNE 2162.99 INSURANCE FOR JUNE 250189.71 --------- - --- 408256.88 05024 JULIANO, JAMES REFUND OF MEDICAL PREMIUM 1286.83 08625 KALAPODIS, MR. REPLACEMENT OF MAl LBOX 125.00 02192 NORTHWEST COMMUNITY HOSPITAL EXPOSURE BLOOD TESTING 144.00 EXPOSURE BLOOD TESTING 121.00 ------------- 265.00 10166 TZAVOS, WILLIAM REPLACEMENT OF MAILBOX 125.00 :EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 RELEASE ID : PAGE 16 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 -.- ..--.-.. ..... --.. .----.-- ------- --.. -- -_.- - - --- - -----------.. ---- -- --- __a _________.... ______ ____ ______________ ________ ______ ___ ____.__ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .. -- - --... -- ---- ----- ------- --- --- --- -- --- ---.. --- ___a ___ - __ __.. ___ ______________ _.___ ______ ___.. __.. ___ __________ ___.. ___.. __ ___.. __ ____ _.. TOTAL : 426833.71 10 01027 CAPITAL GAINS INC. POLICE PENSION 1798 .63 WITHOLDING FOR REFUND OF CONTR 483.90 REFUND OF CONTRIBUTIONS 1935.58 POLl CE PENS I ON - BANK CHARGES 814.92 TOTAL 5033.03 FIRE PENSION 2336.58 FIRE PENSION-BANK CHARGES 930.74 TOTAL 3267.32 FLEX COMP 523.36 FLEX COMP 182.32 FLEX COMP 3157.49 FLEX COMP 522 .56 FLEX COMP 110 .00 FLEX COMP 145.90 FLEX COMP 139 .21 FLEX COMP 432.25 FLEX COMP 228.00 FLEX COMP 482.00 EMP . DENTAL PLAN 6211.05 FLEX COMP 272.88 FLEX COMP 99.98 FLEX COMP 100.00 FLEX COMP 116.12 FLEX COMP 416.66 FLEX COMP 338.92 FLEX COMP 2000.00 09563 IRS 09302 SIENKIEWICZ, ZACHARY 09635 WELLS FARGO BANK 20 01027 CAPITAL GAINS INC. 0963 5 WELLS FARGO BANK 70 02513 ABERNETHY, JANET T. 04203 ADDANTE, ANTHONY 00372 ANDLER, GLEN 02667 BEHUN, DAVID 10081 BRATU, CATHY 00308 CONNOLLY, JUDY 01219 DAHLBERG, JOlIN K. 00321 DRAFFONE, RICHARD 00330 FELTEN, BARBARA 01418 FLORY, JAMES M. 08178 GUARDIAN 08928 HERMANN, JAMES 00349 HOSKINSON I THOMAS 01625 HUEMANN I ANTHONY 01722 INGEBRIGTSEN I JAMES 10020 JAROG, LYNN 10087 JAROSZ I DOREEN 05117 KUHAR, JIM REPORT~ APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 RELEASE ID : PAGE 17 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 01908 LUBASH, DOUGLAS D. 02033 MILLER, DAVID L. 06040 REDLIN, RON 02450 ROELS, ROBERT J. 02473 RUMORE, CINDY JO 02508 SCHULTZ, WALTER 00429 SEMKIU, MI CHAEL J. 10090 SIWAK, FRANK 02631 STEPHENSON, MI CHAEL R. 02644 STRAHL, DAVID 02710 TRACY, RICHARD L. 10093 WIDMER, CAROL 02901 WULBECKER, JEFFREY A. FLEX COMP 525.23 FLEX COMP 183.00 FLEX COMP 416.42 FLEX COMP 152.84 FLEX COMP 150.81 FLEX COMP 79.30 FLEX COMP 357.00 FLEX COMP 121.93 FLEX COMP 45.00 FLEX COMP 583.63 FLEX COMP 778 . 94 FLEX COMP 160.00 FLEX COMP 140.00 TOTAL 19172.80 OVERPAYMENT 5.00 OVERPAYMENT 10.00 OVERPAYMENT 5.00 OVERPAYMENT 5.00 PREMIUM FOR JUNE 684.00 BOND MONEY 1100.00 BOND MONEY 4200.00 BOND MONEY 4850.00 BOND MONEY 2395.00 -. ----------- 12545.00 TOTAL 13254.00 GRAND TOTAL 2190418.54 790 08572 DAY AND NIGHT LIMOUSINE 08572 HOLODENKO, GERTRUD 08572 KROMELIS, VIRGINIJUS 08572 MAJERCZYK, PAULINA 01719 NCPERS GROUP LI FE 02689 THIRD DISTRICT CIRCUIT COURT REPORT: I\PBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY JUN142007 15:26 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 01 2007 TO JUNE 13 2007 SUMMAR Y BY FUND 001 GENERAL FUND 580040.51 030 REFUSE DISPOSAL FUND 319908.33 050 MOTOR FUEL TAX FUND 211934.47 070 COMMUNITY DEVELPMNT BLOCK GRNT 1666.00 080 ASSET SEIZURE FUND 499.98 086 DUI FINE FUND 520 . 00 380 IEPA FLOOD CONTROL LOANS B&I 118403.52 510 CAPITAL IMPROVEMENT FUND 9863.90 550 DOWNTOWN REDEVLPMNT CONST 1203.00 560 STREET IMPROVEMENT CONST FUND 9490.00 590 FLOOD CONTROL CONST FUND 1000.00 610 WATER AND SEWER FUND 408737.33 620 VILLAGE PARKING SYSTEM FUND 92.00 630 PARKING SYSTEM REVENUE FUND 401.56 660 VERI CLE MAINTENANCE FUND 7735.46 670 VERI CLE REPLACEMENT FUND 51361.62 690 RISK MANAGEMENT FUND 426833.71 710 POLICE PENSION FUND 5033.03 720 FIRE PENSION FUND 3267.32 770 FLEXCOMP ESCROW FUND 19172.80 790 ESCROW DEPOSIT FUND 13254.00 -------------- TOTAL : 2190418.54 PAGE 18 <6/14/07 ~MR025 Village of Mount Prospect List of Escrow Checks Presented to the Board of Trustees 06/01/07 To 06/13/07 Paid to 3D BRICK PAVING CO AHMED, AYED ALL AMERICAN HVAC CO ALTRA CONSTRUCTION ANDERSON, JAMES W BA VONE, ANTHONY & CAROLYN BEKAS, NICK BENNETT, WILLIAM & NANCY BRIGHTON CONSTRUCTION CAVANAUGH, MIKE CHAMPION WINDOW COMPANY OF CHICAGO CIOLEK, LUCYNA CONLIN, C DE NICOLO, ANTOINETTE DELUCA, SAM DERINGER, E DISCOVERY HOMES LLC EFRAINS BRICKPAVING & LANDSCAPING ERCK, WALTER F & F CEMENT CONSTRUCTION FCE INC FORTIS CONCRETE CO FOUR SEASON'S INC GERVASI, RALPH A HEARTLAND LUXURY BATH SYSTEMS,INC HEMMERLIGHT INC JUSICK, SHARON KIMBREL, RAY C KOCH, HERBERT MACINO, DOMINIC MAHMOOD, ROGER MALISZEWSKI, JACK MAREK K CONCRETE SPEC INC MICLEA AND VRABIE, MARIA AND FLORIN MIKOLAJCZYK, BEATA MIRO, DOUGLAS MITRO POULOS , PAUL A Permit # 070746 Check # Amount 80474 200.00 070651 80475 125.00 070858 80476 125.00 070930 80477 200.00 070934 80478 200.00 070937 80479 200.00 070944 80480 200.00 070947 80481 200.00 1,000.00 * 070988 80482 500.00 070966 80483 200.00 070786 80484 200.00 052285A 80485 175.00 070808 80486 200.00 051491A 80487 150.00 070200 80488 500.00 071059 80489 200.00 070485 80490 200.00 070458 80491 75.00 070085 80492 250.00 070731 80493 200.00 061344 80494 500.00 070745 80495 200.00 070588 80496 200.00 070974 80497 200.00 070975 80498 200.00 400.00 * 071016 80499 200.00 070602 80500 200.00 070958 80501 75.00 070916 80502 200.00 070343 80503 200.00 070922 80504 75.00 070598 80505 200.00 070788 80506 200.00 071096 80507 125.00 070519 80508 200.00 071018 80509 200.00 070969 80510 200.00 070874 80511 200.00 070757 80512 200.00 070666 80513 200.00 070880 80514 200.00 070873 80515 150.00 Page 1 06/14/97 Village of Mount Prospect Page 2 EMR025. List of Escrow Checks Presented to the Board of Trustees 06/01/07 To 06/13/07 Paid to Permit # Check # Amount MOLINARE CONSTRUCTION 070740 80516 200.00 NICHOLAS, CRAIG P 061682 80517 450.00 OSOWSKI, RONALD H 070689 80518 200.00 PAOLINI, JOHN 070967 80519 200.00 PARENTI & AFFAELLI 063006 80520 500.00 PAWLIS, PATRICK/DAWN 070360 80521 200.00 QUALITY BLACKTOP INC 071032 80522 200.00 RICK'S SEWER & DRAINAGE 070425 80523 125.00 070448 80524 125.00 070802 80525 125.00 375.00 * SEARLES, DAVID 070902 80526 200.00 SOLANS, ENRIC P 070917 80527 200.00 SOLARZ, SANDRA 070794 80528 200.00 TRAVIOLA, BRADFORD A 061401 80529 300.00 VARGHESE, JERSON T 070557 80530 200.00 VOTZMEYER, LISA & RAYMOND 070398 80531 200.00 WALTERS, WILLIAM 070387 80532 200.00 WIDALSKI, KRZYSZTOF 070722 80533 200.00 ZANDER, JOSEPH & ELIZABETH 052224A 80534 9,750.00 *** TOTAL NUMBER OF CHECKS 61 22,400.00 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES May 1 - May 30, 2007 06/12/2007 11:18:53 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 05/31/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 25,777 958,916 521,516 1,400,382 2,040,443 96,083 -166,717 19,578 201,815 o 5,097,793 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,933,383 294,495 139,695 9 11,316 1,205 136 2,391 214 2,336 1,854 3,125 o o 6,870 173 3,558 675 41,182 51,926 o o o 3,712 o 12,052 130,490 2,825 695,363 10,852 10,072 157,388 114,183 21,232 671,254 -94,406 -133,286 1 Y-T-D Received 5,205,611 5,535,283 1,968,721 4,049,843 8,367,936 181,918 2,048,779 146,145 2,250,149 o 29,754,385 12,647,779 1,929,267 577,678 28 67,360 6,664 667 8,767 1,055 209,260 196,563 304,710 o o 572,063 50,555 23,713 47,962 246,099 213,481 2 o o 27,498 o 656,894 677,246 13,702 4,232,624 43,005 41,927 630,461 475,521 81,937 2,693,339 1,569,999 1,504,429 5 Months 7 Months 2007 Budget 13,374,952 15,384,659 2,954,888 16,480,809 21,409,733 553,000 5,501,950 271,240 4,972,704 60,000 80,963,935 38,420,223 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 41.6% 58.3% Unreceived Balance 8,169,341 9,849,376 986,167 12,430,966 13,041,797 371,082 3,453,171 125,095 2,722,555 60,000 51,209,550 25,772,444 2,371,484 1,051,072 972 482,449 -4,064 1,833 11,583 50,445 -208,260 197,937 621,540 o o 504,437 -50,555 25,654 40,545 336,834 521,769 -2 o o 235,302 o 563,158 1,033,854 18,298 6,916,476 53,733 69,173 942,892 618,105 107,610 3,780,600 2,555,501 2,588,861 Completed Remaining Unreceived Percent 61.1 64.0 33.4 75.4 60.9 67.1 62.8 46.1 54.7 100.0 63.2 67.1 55.1 64.5 97.2 87.7 -156.3 73.3 56.9 98.0 **** * 50.2 67.1 46.9 52.0 45.8 57.8 71.0 89.5 46.2 60.4 57.2 62.0 55.5 62.3 59.9 56.5 56.8 58.4 61. 9 63.2 06/12/2007 11:18:53 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 05/31/07 5 Months 7 Months 41.6% 58.3% 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 71 347 0 -347 SERIES 2002 LIBRARY BND ESCROW 1,448 1,783 0 -1,783 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 5,097,793 29,754,385 80,963,935 51,209,550 63.2 2 06/12/2007 5 Months 41.6% Completed 11:19:28 7 Months 58.3% Remaining FRRBRR03 VILLAGE OF MOUNT PROSPECT SUM 021 Budget Revenue by Category within Fund Swmnary 01/01/07 05/31/07 Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent GENERAL FUND 40 PROPERTY TAXES 17,417 3,555,552 10,050,926 6,495,374 64.6 41 OTHER TAXES 730,534 2,382,651 8,447,000 6,064,349 71.8 42 LICENSES, PERMITS & FEES 519,494 1,959,456 2,935,250 975,794 33.2 43 INTERGOVERMENT REV. 1,266,689 3,464,739 14,162,700 10,697,961 75.5 44 CHARGES FOR SERVICE 234,370 736,766 1,551,507 814,741 52.5 45 FINES AND FORFEITS 92,883 168,547 531,000 362,453 68.3 46 INVESTMENT INCOME 43,994 222,093 397,000 174,907 44.1 47 REIMBURSEMENTS 19,578 105,510 189,740 84,230 44.4 48 OTHER REVENUE 8,424 52,465 155,100 102,635 66.2 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL GENERAL FUND 2,933,383 12,647,779 38,420,223 25,772,444 67.1 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 4,653 949,884 2,016,276 1,066,392 52.9 44 CHARGES FOR SERVICE 282,539 943,753 2,211,475 1,267,722 57.3 46 INVESTMENT INCOME 7,303 35,523 72,000 36,477 50.7 48 OTHER REVENUE 0 107 1,000 893 89.3 TOTAL REFUSE DISPOSAL FUND 294,495 1,929,267 4,300,751 2,371,484 55.1 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 133,692 544,768 1,587,500 1,042,732 65.7 46 INVESTMENT INCOME 6,003 30,972 34,750 3,778 10.9 47 REIMBURSEMENTS 0 1,938 6,500 4,562 70.2 TOTAL MOTOR FUEL TAX FUND 139,695 577,678 1,628,750 1,051,072 64.5 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 0 0 1,000 1,000 100.0 46 INVESTMENT INCOME 9 28 0 -28 TOTAL LAW ENFORCEMENT BLOCK GRANT 9 28 1,000 972 97.2 COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 1 40,336 489,809 449,473 91.8 46 INVESTMENT INCOME 284 620 0 -620 48 OTHER REVENUE 11,031 26,404 60,000 33,596 56.0 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 11,316 67,360 549,809 482,449 87.7 ASSET SEIZURE FUND 45 FINES AND FORFEITS 900 5,159 1,000 -4,159 -415.9 46 INVESTMENT INCOME 305 1,505 1,600 95 5.9 TOTAL ASSET SEIZURE FUND 1,205 6,664 2,600 -4,064 -156.3 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 0 0 1,000 1,000 100.0 46 INVESTMENT INCOME 136 667 1,500 833 55.5 1 06/12/2007 11,19,28 FRRBRR03 SUM 021 5 Months 7 Months 41.6% 58.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 05/31/07 Cur Mo Received TOTAL DEA SHARED FUNDS FUND 136 DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 2,300 91 TOTAL DUI FINE FUND 2,391 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 214 o TOTAL FOREIGN FIRE TAX BOARD FUND 214 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME 1,287 1,049 TOTAL SERIES 1987A B&I, PW FACILITY 2,336 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 951 903 o TOTAL SERIES 2001 B&I, VILLAGE HALL 1,854 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 1,469 1,656 o TOTAL SERIES 2003 B&I, VILLAGE HALL 3,125 SERIES 2002B B&I, PUBLIC BLDGS 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 2,948 3,922 o 2 Y-T-D Received 667 8,212 555 8,767 1,055 o 1,055 206,377 2,883 209,260 194,098 2,465 o 196,563 299,700 5,010 o 304,710 o o o o o o 558,821 13,242 o 2007 Budget 2,500 20,000 350 20,350 o 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,833 11,788 -205 11,583 46,500 3,945 o 50,445 -205,377 -2,883 -208,260 196,402 1,535 o 197,937 616,550 4,990 o 621,540 494,679 9,758 o Completed Remaining Unreceived Percent 73.3 58.9 -58.6 56.9 100.0 78.9 98.0 ****.* ****.* 50.3 38.4 50.2 67.3 49.9 67.1 o o o o o o 47.0 42.4 06/12/2007 11,19,28 FRRBRR03 SUM 021 5 Months 7 Months Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 - 05/31/07 Cur Mo Received Y-T-D Received 2007 Budget Unreceived Balance 41.6% 58.3% Completed Remaining Unreceived Percent TOTAL SERIES 1999 B&I, TIF 6,870 46.9 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,449 109 TOTAL SERIES 1998A B&I, FLOOD 3,558 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 40,971 211 TOTAL IEPA FLOOD CONTROL LOANS B&I 41,182 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 51,167 759 TOTAL SERIES 2000 B&I, FLOOD CONTROL 51,926 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 173 173 244 431 675 3 572,063 49,975 580 50,555 23,396 317 23,713 46,311 1,651 47,962 244,742 1,357 246,099 211,800 1,681 213,481 o o o o o o o o o 1,076,500 504,437 o o -49,975 -580 -50,555 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 25,671 -17 25,654 40,996 -451 40,545 338,191 -1,357 o o 336,834 516,200 5,569 521,769 o o o o o o o 52.3 -5.7 52.0 47.0 -37.6 45.8 58.0 57.8 70.9 76.8 71.0 o -2 -2 o o o o o o 06/12/2007 11,19,28 FRRBRR03 SUM 021 5 Months 7 Months 41.6% 58.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 05/31/07 Cur Mo Received CAPITAL IMPROVEMENT FUND 43 46 47 48 49 INTERGOVERMENT REV. INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES o 3,712 o o o TOTAL CAPITAL IMPROVEMENT FUND 3,712 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 3,267 8,785 o o TOTAL DOWNTOWN REDEVLPMNT CONST 12,052 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 123,083 o 7,407 o o TOTAL STREET IMPROVEMENT CONST FUND 130,490 FLOOD CONTROL CONST FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 2,825 o TOTAL FLOOD CONTROL CONST FUND 2,825 WATER AND SEWER FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 4 8 OTHER REVENUE 49 OTHER FINANCING SOURCES 3,253 1,270 666,191 21,330 o 3,319 o TOTAL WATER AND SEWER FUND 695,363 4 Y-T-D Received o 19,686 o 7,812 o 27,498 o o o 619,318 37,576 o o 656,894 646,300 o 30,946 o o 677,246 o 13,702 o 13,702 751,969 5,640 3,361,342 94,021 1,083 18,569 o 4,232,624 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 -11,186 o 6,688 o 235,302 o o o 548,234 14,924 o o 563,158 1,042,400 o -8,546 o o 1,033,854 o 18,298 o 18,298 782,131 6,360 6,058,658 73,979 -1,083 -3,569 o 6,916,476 Completed Remaining Unreceived Percent 100.0 -131.6 46.1 89.5 o o o 47.0 28.4 46.2 61. 7 -38.2 60.4 57.2 57.2 51. 0 53.0 64.3 44.0 -23.8 62.0 06/12/2007 11:19:28 FRRBRR03 SUM 021 5 Months 7 Months 41.6% 58.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 05/31/07 Cur Mo Received VILLAGE PARKING SYSTEM FUND 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 752 9,787 313 o TOTAL VILLAGE PARKING SYSTEM FUND 10,852 PARKING SYSTEM REVENUE FUND 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 4 8 OTHER REVENUE 49 OTHER FINANCING SOURCES o o 10,072 o o o TOTAL PARKING SYSTEM REVENUE FUND 10,072 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 4 8 OTHER REVENUE 155,595 1,793 o TOTAL VEHICLE MAINTENANCE FUND 157,388 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 84,963 29,220 o o TOTAL VEHICLE REPLACEMENT FUND 114,183 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 17,872 3,360 TOTAL COMPUTER REPLACEMENT FUND 21,232 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 579,054 9,751 o 82,449 TOTAL RISK MANAGEMENT FUND 671,254 POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE -146,591 52,185 TOTAL POLICE PENSION FUND -94,406 5 Y-T-D Received 3,625 37,912 1,468 o 43,005 o o 41,927 o o o 41,927 622,379 8,082 o 630,461 339,852 135,669 o o 475,521 66,316 15,621 81,937 2,217,689 43,378 37,614 394,658 2,693,339 659,686 910,313 1,569,999 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,013 50,588 -868 o 53,733 o o 68,073 1,100 o o 69,173 933,574 9,318 o 942,892 509,774 48,331 o 60,000 618,105 93,231 14,379 107,610 3,245,436 48,622 37,386 449,156 3,780,600 1,471,314 1,084,187 2,555,501 Completed Remaining Unreceived Percent 52.5 57.2 -144.7 55.5 61. 9 100.0 62.3 60.0 53.6 59.9 60.0 26.3 100.0 56.5 58.4 47.9 56.8 59.4 52.9 49.8 53.2 58.4 69.0 54.4 61. 9 06/12/2007 11:19:28 FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 - 05/31/07 5 Months 7 Months 41.6% 58.3% Completed Remaining FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent -177,693 664,608 2,204,500 1,539,892 69.9 44,407 839,821 1,888,790 1,048,969 55.5 -133,286 1,504,429 4,093,290 2,588,861 63.2 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 71 o 347 o o o -347 TOTAL SSA #6 GEORGE/ALBERT B&I 71 347 o -347 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME 1,448 1,783 o -1,783 TOTAL SERIES 2002 LIBRARY BND ESCROW 1,448 1,783 o -1,783 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 .06/12/2007 11:17:18 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 05/31/07 Cur Mo Expended Y-T-D Expended 2007 Budget 41. 6%- 58.3% 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,809,331 589,464 38,517 447,692 1,514,129 18,279 597,719 151,198 28,170 o 23,319 34,446 198,983 43,286 302,822 617,712 o 353,837 300 o 6,769,204 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,883,799 357,124 670,877 670 49,594 669 o 2,000 o o 91,883 215,797 o o o o 1,398 3,988 o 41,071 o o o 70,647 o 12,865 10,007 o 1 9,527,469 2,551,302 147,444 2,152,378 5,397,501 129,831 3,064,108 664,811 64,543 o 25,110 41,462 334,863 103,197 491,451 943,014 244,359 797,338 1,200 o 26,681,381 13,517,916 1,474,463 1,188,109 670 79,629 1,622 o 5,612 682 405,000 91,883 216,097 o o 73,050 o 1,398 3,988 188,275 41,371 o o o 151,179 o 86,272 10,007 o 24,621,815 9,104,278 457,138 5,131,797 16,317,762 745,159 7,174,552 1,578,257 1,978,000 50,000 318,220 371,035 1,566,810 1,418,958 2,134,134 4,596,585 2,874,195 1,329,033 3,000 o 81,770,728 38,192,984 4,029,607 1,764,301 1,000 752,309 1,000 1,000 1,000 10,473 405,000 383,765 896,594 o o 916,100 o 67,795 153,575 613,356 727,743 o o o 1,026,993 o 2,455,187 2,258,907 244,000 15,094,346 6,552,976 309,694 2,979,419 10,920,261 615,328 4,110,444 913,446 1,913,457 50,000 293,110 329,573 1,231,947 1,315,761 1,642,683 3,653,571 2,629,836 531,695 1,800 o 55,089,347 24,675,068 2,555,144 576,192 330 672,680 -622 1,000 -4,612 9,791 o 291,882 680,497 o o 843,050 o 66,397 149,587 425,081 686,372 o o o 875,814 o 2,368,915 2,248,900 244,000 61. 3 72 .0 67.7 58.1 66.9 82.6 57.3 57.9 96.7 100.0 92.1 88.8 78.6 92.7 77.0 79.5 91.5 40.0 60.0 67.4 64.6 63.4 32.7 33.0 89.4 -62.2 100.0 -461.2 93.5 76.1 75.9 92.0 97.9 97.4 69.3 94.3 85.3 96.5 99.6 100.0 06/12/2007 11,17:18 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 - 05/31/07 Cur Mo Expended Y-T-D Expended 2007 Budget 41. 6% 58.3% Unexpended Balance Completed Remaining Unexpended Percent 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 SSA #6 GEORGE/ALBERT B&I GENERAL FIXED ASSETS ACCT GP GENERAL LONG-TERM DEBT ACCT GP Total All Funds 1,057,340 6,769 10,649 111,093 163,028 30,424 533,531 214,864 229,117 o o o 6,769,204 2 3,253,009 34,305 53,452 547,376 278,093 30,424 2,813,331 1,021,905 1,112,263 o o o 26,681,381 11,675,919 123,154 156,448 1,578,353 1,406,810 249,050 6,585,214 2,465,133 2,627,958 o o o 81,770,728 8,422,910 88,849 102,996 1,030,977 1,128,717 218,626 3,771,883 1,443,228 1,515,695 o o o 55,089,347 72.1 72.1 65.8 65.3 80.2 87.8 57.3 58.5 57.7 67.4 . 06/12/2007 11:20:02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/07 NON-DEPARTMENTAL Cur Mo Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 00 ADMINISTRATION Totals EXPENDITURE CLASSIFICATION 72 INTEREST EXPENSE Totals SOURCE OF FUNDS 930 GENERAL LONG-TERM DEBT ACCT GP Totals 1 Y-T-D Expended 2007 Budget o o o o o o o o o o o o 41.6% Completed 58.3% Remaining o o o o o o o o o o o o 06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/07 PUBLIC REPRESENTATION Cur Mo Expended PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 03 ADVISORY BOARDS & COMMISSIONS 42,451 912 Totals 43,363 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 2,683 512 o 40,114 o 54 Totals 43,363 SOURCE OF FUNDS 001 GENERAL FUND 43,363 Totals 43,363 2 Y-T-D Expended 72,459 10,064 82,523 17,810 3,125 o 60,811 77 700 82,523 82,523 82,523 2007 Budget 111,270 17,010 128,280 35,466 6,361 3,000 77,353 500 5,600 128,280 128,280 128,280 41. 6% 58.3% Unexpended Balance 38,811 6,946 45,757 17,656 3,236 3,000 16,542 423 4,900 45,757 45,757 45,757 Completed Remaining Unexpended Percent 34.9 40.8 35.7 49.8 50.9 100.0 21.4 84.6 87.5 35.7 35.7 35.7 '06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/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 37,224 63,081 27,708 103,499 6,823 Totals 238,335 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 63,803 24,186 5,192 142,659 476 1,142 877 o Totals 238,335 SOURCE OF FUNDS 001 GENERAL FUND 238,335 Totals 238,335 3 Y-T-D Expended 238,537 190,286 99,524 319,085 43,410 890,842 363,383 112,303 14,647 393,725 1,824 3,261 1,699 o 890,842 890,842 890,842 2007 Budget 509,550 630,750 287,303 921,335 143,372 2,492,310 898,539 281,625 46,400 1,215,596 10,145 11,485 26,920 1,600 2,492,310 2,492,310 2,492,310 41.6% 58.3% Unexpended Balance 271,013 440,464 187,779 602,250 99,962 1,601,468 535,156 169,322 31,753 821,871 8,321 8,224 25,221 1,600 1,601,468 1,601,468 1,601,468 Completed Remaining Unexpended Percent 53.2 69.8 65.4 65.4 69.7 64.3 59.6 60.1 68.4 67.6 82.0 71.6 93.7 100.0 64.3 64.3 64.3 06/12/2007 5 Months 41. 6% Completed 11,20,02 VILLAGE OF MOUNT PROSPECT 7 Months 58.3% Remaining FRRDBROl SUM 031 Department Budget Expenditure Sununary 01/01/07 05/31/07 Cur Mo Y-T-D 2007 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 9,941 47,783 130,245 82,462 63.3 04 INTERGOVERNMENTAL PROGRAMMING 3,133 15,400 48,322 32,922 68.1 Totals 13,074 63,183 178,567 115,384 64.6 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 7,204 38,790 102,484 63,694 62.2 51 EMPLOYEE BENEFITS 3,619 16,121 41,133 25,012 60.8 52 OTHER EMPLOYEE COSTS 0 535 2,650 2,115 79.8 54 CONTRACTUAL SERVICES 941 3,373 13,150 9,777 74.3 55 UTILITIES 2 630 1,600 970 60.6 57 COMMODITIES & SUPPLIES 1,308 2,681 7,050 4,369 62.0 67 OTHER EQUIPMENT 0 1,053 10,500 9,447 90.0 Totals 13,074 63,183 178,567 115,384 64.6 SOURCE OF FUNDS 001 GENERAL FUND 13,074 63,183 178,567 115,384 64.6 Totals 13,074 63,183 178,567 115,384 64.6 4 06(12(2007 5 Months 41.6% Completed 11,20,02 VILLAGE OF MOUNT PROSPECT 7 Months 58.3% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 05/31/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 18,291 79,938 205,188 125,250 61. 0 Totals 18,291 79,938 205,188 125,250 61.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 8,608 47,574 113,075 65,501 57.9 51 EMPLOYEE BENEFITS 3,916 17,888 43,977 26,089 59.3 52 OTHER EMPLOYEE COSTS 35 105 2,625 2,520 96 .0 54 CONTRACTUAL SERVICES 5,654 13,103 38,748 25,645 66.2 55 UTILITIES 1 143 1,650 1,507 91.3 57 COMMODITIES & SUPPLIES 77 1,125 5,113 3,988 78.0 Totals 18,291 79,938 205,188 125,250 61. 0 SOURCE OF FUNDS 001 GENERAL FUND 18,291 79,938 205,188 125,250 61. 0 Totals 18,291 79,938 205,188 125,250 61.0 5 06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 05/31/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 26,355 37,496 o 50,741 29,982 2,776 Totals 147,350 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 61,227 26,276 578 13,384 3 45,061 821 o Totals 147,350 SOURCE OF FUNDS 001 GENERAL FUND 147,350 Totals 147,350 6 Y-T-D Expended 135,607 182,303 o 208,683 160,852 13,695 701,140 309,292 116,078 3,061 85,921 979 180,242 5,267 300 701,140 701,140 701,140 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 41.6% 58.3% Unexpended Balance 165,680 262,376 o 312,762 248,385 36,037 1,025,240 487,533 179,066 7,579 51,855 4,171 270,363 18,973 5,700 1,025,240 1,025,240 1,025,240 Completed Remaining Unexpended Percent 55.0 59.0 60.0 60.7 72 .5 59.4 61.2 60.7 71.2 37.6 81.0 60.0 78.3 95.0 59.4 59.4 59.4 06/12/2007 11:20:02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 05/31/07 COMMUNITY DEVELOPMENT Cur Mo Expended PROGRAM TOTALS 01 COMMUNITY DEVELOPMENT ADMIN 02 PLANNING & ZONING 03 ECONOMIC DEVELOPMENT 05 BUILDING INSPECTIONS 06 HOUSING INSPECTIONS 07 HEALTH INSPECTIONS 18,763 20,701 8,015 66,157 40,490 9,931 Totals 164,057 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 95,928 45,218 2,396 18,770 1,146 599 o Totals 164,057 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 164,057 o Totals 164,057 7 Y-T-D Expended 94,171 101,679 41,322 304,907 165,567 48,310 755,956 477,627 196,704 10,278 59,853 4,590 6,904 o 755,956 755,056 900 755,956 2007 Budget 41.6% 58.3% Completed Remaining Unexpended Unexpended Balance Percent 240,629 265,580 109,436 812,491 490,180 128,318 2,046,634 1,255,645 497,667 30,563 212,484 18,555 18,720 13,000 2,046,634 2,045,734 900 2,046,634 146,458 163,901 68,114 507,584 324,613 80,008 1,290,678 778,018 300,963 20,285 152,631 13,965 11,816 13,000 1,290,678 1,290,678 o 1,290,678 60.9 61. 7 62.2 62.5 66.2 62.4 63.1 62.0 60.5 66.4 71. 8 75.3 63.1 100.0 63.1 63.1 63.1 06/12/2007 11:20:02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/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,298 15,126 o 28,170 Totals 49,594 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 20 15,497 o 28,170 o o Totals 49,594 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 49,594 Totals 49,594 8 Y-T-D Expended 31,518 15,126 o 32,985 79,629 20,800 8,441 868 16,535 o 32,985 o o 79,629 79,629 79,629 2007 Budget 83,309 134,000 310,000 225,000 752,309 52,004 20,697 6,020 147,639 949 190,000 o 335,000 752,309 752,309 752,309 41.6% 58.3% Unexpended Balance 51,791 118,874 310,000 192,015 672,680 31,204 12,256 5,152 131,104 949 157,015 o 335,000 672,680 672,680 672,680 Completed Remaining Unexpended Percent 62.2 88.7 100.0 85.3 89.4 60.0 59.2 85.6 88.8 100.0 82.6 100.0 89.4 89.4 89.4 06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/07 HUMAN SERVICES Cur Mo Expended PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 02 SOCIAL SERVICES 03 NURSING/HEALTH SERVICES 04 SENIOR CTR. LEISURE ACTIVITIES 05 YOUTH ACTIVITIES 15,430 27,058 13,235 2,392 o Totals 58,115 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 36,110 14,624 o 4,403 173 805 2,000 Totals 58,115 SOURCE OF FUNDS 001 GENERAL FUND 58,115 Totals 58,115 9 Y-T-D Expended 70,374 137,174 67,401 11,461 o 286,410 192,734 66,380 894 19,969 1,544 2,889 2,000 286,410 286,410 286,410 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 41.6% 58.3% Unexpended Balance 105,903 205,653 124,580 33,461 o 469,597 285,452 105,225 3,006 33,632 6,456 34,326 1,500 469,597 469,597 469,597 Completed Remaining Unexpended Percent 60.1 60.0 64.9 74.5 62.1 59.7 61.3 77.1 62.7 80.7 92.2 42.9 62.1 62.1 62.1 06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/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 99,502 667,917 26,707 97,434 2,310 74,156 Totals 968,026 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 642,059 174,812 9,171 125,772 1,374 9,868 848 4,122 Totals 968,026 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND 964,687 670 669 o 2,000 Totals 968,026 10 Y-T-D Expended 686,823 3,146,775 106,233 463,330 12,709 311,178 4,727,048 3,263,552 728,232 57,687 605,155 11,762 44,723 6,630 9,307 4,727,048 4,719,144 670 1,622 o 5,612 4,727,048 2007 Budget 2,945,090 8,218,329 342,746 1,205,678 29,380 811,753 13,552,976 8,592,849 3,185,309 123,000 1,427,145 49,200 115,423 14,000 46,050 13,552,976 13,548,976 1,000 1,000 1,000 1,000 13,552,976 41.6% 58.3% Unexpended Balance 2,258,267 5,071,554 236,513 742,348 16,671 500,575 8,825,928 5,329,297 2,457,077 65,313 821,990 37,438 70,700 7,370 36,743 8,825,928 8,829,832 330 -622 1,000 - 4 , 612 8,825,928 Completed Remaining Unexpended Percent 76.7 61. 7 69.0 61. 6 56.7 61. 7 65.1 62.0 77.1 53.1 57.6 76.1 61.3 52.6 79.8 65.1 65.2 33.0 -62.2 100.0 -461.2 65.1 .06/12/2007 11:20:02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/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 76,898 537,722 3,642 43,148 1,071 42,436 4,945 1,593 o o Totals 711.455 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 496,399 133,268 18,023 o 35,096 958 14,841 103 o 12,767 Totals 711.455 SOURCE OF FUNDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 711,455 o Totals 711.455 11 Y-T-D Expended 388,715 2,718,331 14,546 204,363 23,355 193,307 9,355 8,532 o 682 3.561.186 2,665,241 548,958 40,271 473 199,291 19,765 60,308 586 o 26,293 3.561.186 3,560,504 682 3.561.186 2007 Budget 2,256,288 6,929,243 21,731 547,561 64,500 505,633 37,885 35,748 o 10,473 10.409.062 6,833,619 2,691,797 151,640 473 459,819 43,200 131,039 4,000 4,000 89,475 10.409.062 10,398,589 10,473 10.409.062 41.6% 58.3% Unexpended Balance 1,867,573 4,210,912 7,185 343,198 41,145 312,326 28,530 27,216 o 9,791 6.847.876 4,168,378 2,142,839 111,369 o 260,528 23,435 70,731 3,414 4,000 63,182 6.847.876 6,838,085 9,791 6.847.876 Completed Remaining Unexpended Percent 82.8 60.8 33.1 62.7 63.8 61. 8 75.3 76.1 93.5 65.8 61. 0 79.6 73.4 56.7 54.2 54.0 85.4 100.0 70.6 65.8 65.8 93.5 65.8 06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/07 PUBLIC WORKS - ADMINISTRATION Cur Mo Expended PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 115,893 Totals 115,893 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 EQUI PMENT 17,282 12,566 1,640 80,097 316 3,992 o o Totals 115,893 SOURCE OF FUNDS 001 GENERAL FUND 115,893 Totals 115,893 12 Y-T-D Expended 507,495 507,495 97,676 55,076 7,110 334,872 5,718 6,815 o 228 507,495 507,495 507,495 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 41. 6% 58.3% Unexpended Balance 752,264 752,264 139,517 80,400 22,985 486,963 13,272 7,660 1,090 377 752,264 752,264 752,264 Completed Remaining Unexpended Percent 59.7 59.7 58.8 59.3 76.4 59.3 69.9 52.9 100.0 62.3 59.7 59.7 59.7 06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 05/31/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,028 25,353 56,499 o 11,597 2,097 11,811 6,769 10,649 o Totals 216,419 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 89,034 31,816 48,372 1,526 317 45,119 o o o 235 o Totals 216,419 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 168,377 30,624 6,769 10,649 Totals 216,419 13 Y-T-D Expended 59,396 327,539 92,264 473,221 o 60,717 30,329 44,505 34,305 53,452 o 1,175,728 558,965 161,194 188,727 5,255 1,269 260,083 o o o 235 o 1,175,728 889,865 198,106 34,305 53,452 1,175,728 2007 Budget 146,860 1,002,815 514,141 445,928 o 178,890 70,548 119,916 123,154 156,448 o 2,758,700 1,108,580 354,511 696,035 134,644 3,172 300,993 o 6,365 19,400 135,000 o 2,758,700 2,255,928 223,170 123,154 156,448 2,758,700 41.6% 58.3% Unexpended Balance 87,464 675,276 421,877 -27,293 o 118,173 40,219 75,411 88,849 102,996 o 1,582,972 549,615 193,317 507,308 129,389 1,903 40,910 o 6,365 19,400 134,765 o 1,582,972 1,366,063 25,064 88,849 102,996 1,582,972 Completed Remaining Unexpended Percent 59.6 67.3 82.1 -6.1 66.1 57.0 62.9 72.1 65.8 57.4 49.6 54.5 72 .9 96.1 60.0 13 .6 100.0 100.0 99.8 57.4 60.6 11. 2 72 .1 65.8 57.4 06/12/2007 11:20:02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 05/31/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,560 55,626 84,651 3,094 Totals 159,931 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 56,437 20,725 60 70,222 3,437 9,050 Totals 159,931 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 159,931 o Totals 159,931 14 Y-T-D Expended 83,244 162,988 279,856 12,916 539,004 259,520 87,677 456 170,627 7,209 13,515 539,004 539,004 o 539,004 2007 Budget 216,107 543,385 946,789 95,998 1,802,279 697,162 228,406 3,555 764,291 70,470 38,395 1,802,279 1,789,016 13 , 263 1,802,279 41.6% 58.3% Unexpended Balance 132,863 380,397 666,933 83,082 1,263,275 437,642 140,729 3,099 593,664 63,261 24,880 1,263,275 1,250,012 13,263 1,263,275 Completed Remaining Unexpended Percent 61.5 70.0 70.4 86.5 70.1 62.8 61.6 87.2 77.7 89.8 64.8 70.1 69.9 100.0 70.1 06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/07 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 60,990 30,474 Totals 91,464 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 47,800 16,797 o 13,433 11,614 1,820 o o o Totals 91,464 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 71,505 19,959 91,464 Totals 15 Y-T-D Expended 298,654 122,231 420,885 244,712 76,472 562 31,245 55,816 12,078 o o o 420,885 367,185 53,700 420,885 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 41.6% 58.3% Unexpended Balance 469,373 403,949 873,322 377,404 115,455 4,828 115,424 193,184 14,907 530 1,590 50,000 873,322 643,682 229,640 873,322 Completed Remaining Unexpended Percent 61.1 76.8 67.5 60.7 60.2 89.6 78.7 77.6 55.2 100.0 100.0 100.0 67.5 63.7 81. 0 67.5 06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/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 132,077 12,987 3,750 67,030 71,126 31,177 28,988 60,609 61,596 318,340 269,660 Totals 1,057,340 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 120,834 53,801 1,272 523,827 689 13,566 25,635 o 297 14,597 302,822 o Totals 1,057,340 SOURCE OF FUNDS 610 WATER AND SEWER FUND 1,057,340 Totals 1,057,340 16 Y-T-D Expended 577,848 64,451 20,890 219,741 228,568 123,137 140,330 242,437 160,071 493,496 982,040 3,253,009 646,996 241,301 10,840 1,686,899 21,120 54,266 53,900 o 409 45,827 491,451 o 3,253,009 3,253,009 3,253,009 2007 Budget 1,468,391 193,622 102,407 945,024 1,443,752 364,297 355,821 606,091 524,861 2,223,348 3,448,305 11,675,919 1,783,337 633,956 33,625 5,738,343 202,875 135,664 205,285 o 7,415 801,285 2,134,134 o 11,675,919 11,675,919 11,675,919 41.6% 58.3% Unexpended Balance 890,543 129,171 81,517 725,283 1,215,184 241,160 215,491 363,654 364,790 1,729,852 2,466,265 8,422,910 1,136,341 392,655 22,785 4,051,444 181,755 81,398 151,385 o 7,006 755,458 1,642,683 o 8,422,910 8,422,910 8,422,910 Completed Remaining Unexpended Percent 60.6 66.7 79.6 76.7 84.2 66.2 60.6 60.0 69.5 77.8 71.5 72.1 63.7 61. 9 67.8 70.6 89.6 60.0 73.7 94.5 94.3 77.0 72.1 72 .1 72.1 06/12/2007 11:20:02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/07 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 347,332 9,792 Totals 357,124 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 13,199 5,439 o 332,341 o 5,266 879 Totals 357,124 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 357,124 Totals 357,124 17 Y-T-D Expended 1,424,178 50,285 1,474,463 67,738 24,090 o 1,357,127 165 21,064 4,279 1,474,463 1,474,463 1,474,463 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 41.6% 58.3% Unexpended Balance 2,401,660 153,484 2,555,144 162,806 47,356 1,785 2,297,225 425 31,596 13,951 2,555,144 2,555,144 2,555,144 Completed Remaining Unexpended Percent 62.8 75.3 63.4 70.6 66.3 100.0 62.9 72.0 60.0 76.5 63.4 63.4 63.4 06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 05/31/07 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 02 VEHICLE MAINTENANCE PROGRAM 13,780 97,313 Totals 111,093 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 46,204 19,785 130 4,168 1 40,305 o o 500 Totals 111,093 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 111,093 Totals 111,093 18 Y-T-D Expended 71,059 476,317 547,376 252,390 90,404 130 19,740 443 183,769 o o 500 547,376 547,376 547,376 2007 Budget 185,783 1,392,570 1,578,353 695,541 237,031 2,250 78,151 1,060 555,370 o 530 8,420 1,578,353 1,578,353 1,578,353 41.6% 58.3% Unexpended Balance 114,724 916,253 1,030,977 443,151 146,627 2,120 58,411 617 371,601 o 530 7,920 1,030,977 1,030,977 1,030,977 Completed Remaining Unexpended Percent 61. 8 65.8 65.3 63.7 61. 9 94.2 74.7 58.2 66.9 100.0 94.1 65.3 65.3 65.3 .06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 05/31/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 3,167 1,719 551 218 Totals 5,655 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 520 197 4,442 o 496 o Totals 5,655 SOURCE OF FUNDS 001 GENERAL FUND 5,655 Totals 5,655 19 Y-T-D Expended 38,642 1,824 15,577 1,028 57,071 2,669 858 44,882 o 8,751 -89 57,071 57,071 57,071 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 41. 6% 58.3% Completed Remaining Unexpended Unexpended Balance Percent 87,458 134,861 71,601 1,859 295,779 85,981 15,352 163,993 o 20,364 10,089 295,779 295,779 295,779 69.4 98.7 82.1 64.4 83.8 97.0 94.7 78.5 69.9 100.9 83.8 83.8 83.8 06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 05/31/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 70,647 o 12,865 o 630,301 163,028 30,424 Totals 907,265 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 34,915 o o o 23,216 30,424 198,983 2,250 617,477 o o Totals 907,265 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 620,294 70,647 o 12,865 10,007 o o 163,028 30,424 Totals 907,265 20 Y-T-D Expended 151,179 o 85,372 o 946,310 278,093 30,424 1,491,378 98,832 o 31,647 o 24,524 30,424 334,863 6,474 942,779 21,835 o 1,491,378 936,303 151,179 o 85,372 10,007 o o 278,093 30,424 1,491,378 2007 Budget 891,993 60,000 2,454,287 244,000 3,591,698 1,406,810 249,050 8,897,838 386,100 o 1,778,000 50,000 307,855 294,050 1,566,810 396,138 4,076,585 42,300 o 8,897,838 1,257,791 1,026,993 o 2,454,287 2,258,907 244,000 o 1,406,810 249,050 8,897,838 41. 6% 58.3% Unexpended Balance 740,814 60,000 2,368,915 244,000 2,645,388 1,128,717 218,626 7,406,460 287,268 o 1,746,353 50,000 283,331 263,626 1,231,947 389,664 3,133,806 20,465 o 7,406,460 321,488 875,814 o 2,368,915 2,248,900 244,000 o 1,128,717 218,626 7,406,460 Completed Remaining Unexpended Percent 83.1 100.0 96.5 100.0 73.7 80.2 87.8 83.2 74.4 98.2 100.0 92 .0 89.7 78.6 98.4 76.9 48.4 83.2 25.6 85.3 96.5 99.6 100.0 80.2 87.8 83.2 .06/12/2007 11:20:02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/07 DEBT SERVICE Cur Mo Expended PROGRAM TOTALS 02 DEBT SERVICE - PROPERTY TAXES 03 DEBT SERVICE - TAX INCREMENT 04 DEBT SERVICE - H/R SALES TAX 1 05 DEBT SERVICE - H/R SALES TAX 2 06 SPECIAL SERVICE AREA B & I 307,680 3,988 42,469 o o Totals 354,137 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS SOURCE OF FUNDS 140 180 190 200 230 290 340 350 360 380 390 400 430 440 830 o o 353,837 300 o Totals 354,137 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 91,883 215,797 o o o o 1,398 3,988 o 41,071 o o o o Totals 354,137 21 Y-T-D Expended 712,980 77,038 231,044 o o 1,021,062 o 244,359 775,503 1,200 o 1,021,062 405,000 91,883 216,097 o o 73,050 o 1,398 3,988 188,275 41,371 o o o o 1,021,062 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 41.6% 58.3% Unexpended Balance 972,379 992,637 1,177,850 o o 3,142,866 o 2,629,836 511,230 1,800 o 3,142,866 o 291,882 680,497 o o 843,050 o 66,397 149,587 425,081 686,372 o o o o 3,142,866 Completed Remaining Unexpended Percent 57.7 92.8 83.6 75.5 91.5 39.7 60.0 75.5 76.1 75.9 92.0 97.9 97.4 69.3 94.3 75.5 06/12/2007 11,20,02 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 05/31/07 5 Months 7 Months 41.6% 58.3% Completed Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 3,711 18,556 44,533 25,977 58.3 214,864 1,021,905 2,465,133 1,443,228 58.5 229,117 1,112,263 2,627,958 1,515,695 57.7 447,692 2,152,724 5,137,624 2,984,900 58.1 RETIREE PENSIONS PROGRAM TOTALS 01 MISCELLANEOUS PENSIONS 02 POLICE PENSIONS 03 FIRE PENSIONS EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES Totals 447,692 2,151,905 5,131,324 2,979,419 58.1 0 750 5,800 5,050 87.1 0 69 500 431 86.2 447,692 2,152,724 5,137,624 2,984,900 58.1 SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FUND 720 FIRE PENSION FUND Totals 3,711 18,556 44,533 25,977 58.3 214,864 1,021,905 2,465,133 1,443,228 58.5 229,117 1,112,263 2,627,958 1,515,695 57.7 447,692 2,152,724 5,137,624 2,984,900 58.1 22 .06/12/2007 11,20,02 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 05/31/07 5 Months 7 Months 41.6% 58.3% Completed Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 122,700 700,799 1,360,353 659,554 48.5 410,831 2,112,532 5,211,598 3,099,066 59.5 533,531 2,813,331 6,571,951 3,758,620 57.2 RISK MANAGEMENT PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 67 OTHER EQUI PMENT Totals 22 6,064 34,000 27,936 82.2 533,509 2,807,267 6,532,451 3,725,184 57.0 0 0 5,500 5,500 100.0 533,531 2,813,331 6,571,951 3,758,620 57.2 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 533,531 2,813,331 6,571,951 3,758,620 57.2 Totals 533,531 2,813,331 6,571,951 3,758,620 57.2 23 06/12/2007 11:20:02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/07 NON-DEPARTMENTAL Cur Mo Expended PROGRAM TOTALS 01 CONTINGENCIES Totals EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS Totals SOURCE OF FUNDS 001 GENERAL FUND 560 STREET IMPROVEMENT CONST FUND 670 VEHICLE REPLACEMENT FUND Totals 24 Y-T-D Expended 2007 Budget o o o o o o o o o o o o o o o o 41.6% 58.3% Completed . Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o o o o o · 06/12/2007 11,20,02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/07 CAPITAL FIXED ASSETS Cur Mo Expended Unexpended Percent PROGRAM TOTALS 00 CAPITAL FIXED ASSETS Totals EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES Totals SOURCE OF FUNDS 910 GENERAL FIXED ASSETS ACCT GP Totals 25 Y-T-D Expended 2007 Budget o o o o o o o o o o o o 41.6% 58.3% Unexpended Balance o o o o o o Completed Remaining o o o o o o 06/12/2007 11:20:02 FRRDBROl SUM 031 5 Months 7 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 05/31/07 MOUNT PROSPECT LIBRARY Cur Mo Expended Unexpended Balance Unexpended Percent PROGRAM TOTALS 02 LIBRARY SERVICES Totals EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES Totals SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND Totals 26 Y-T-D Expended o o o o o o 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 41.6% 58.3% 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