The URL can be used to link to this page

Home My WebLink About3. BILLS & FINANCIALS 09/18/2007 VILLAGE OF MOUNT PROSPECT CASH POSITION September 01 -12,2007 Cash & Invstmt Receipts Disbursements Disbursements Cash & Invstmt Balance 09/01/07 Per Attached Per Attached Balance 09/01/07 09/12/07 List of Bills List of Bills 09/12/07 General Fund 6,878,613 1,342,230 723,727 7,497,116 Special Revenue Funds Refuse Disposal Fund 1,002,614 105,673 1,108,287 Motor Fuel Tax Fund 734,234 3,615 4,731 733,118 Local Law Enforcement Block Grant Fund 105 105 Community Development Blk Grant Fund 84,635 117 84,518 Asset Seizure Fund 79,129 454 78,675 DEA Shared Funds 50,566 7,030 43,536 DUI Fine Fund 43,958 43,958 Foreign Fire Tax Board Fund 51,609 51,609 Debt Service Funds 1,072,184 600 1,071,584 Capital Proiects Funds Capital Improvement Fund 602,066 10,175 591,891 Downtown Redevelopment Const Fund 1,581,644 1,581,644 Street Improvement Construction Fund 1,721,466 32,672 1,688,794 Flood Control Construction Fund 638,353 638,353 Enterprise Funds Water & Sewer Fund 4,522,252 373,827 32,734 4,863,345 Village Parking System Fund 87,128 4,300 20 91,408 Parking System Revenue Fund (17,661 ) 2,805 47 (14,903) Internal Service Funds Vehicle Maintenance Fund 597,272 39,864 557,408 Vehicle Replacement Fund 6,634,923 191,796 6,443,127 Computer Replacement Fund 714,736 22,712 692,024 Risk Management Fund 2,847,628 8,010 48,085 2,807,553 Trust & Aaencv Funds Police Pension Fund 42,062,790 1,808 42,060,982 Fire Pension Fund 42,073,214 2,307 42,070,907 Flexcomp Trust Fund 26,860 97 13,635 13,322 Escrow Deposit Fund 1,800,930 290,686 9,694 34,317 2,047,605 115,891 ,248 2.131,243 34,317 116,845,966 TOTAL DISBURSEMENTS PER ATTACHED LISTS OF BILLS 1,176,525 REPORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 RUN: WEDNESDAY SEP122007 15:34 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 001 02919 303 CAB ASSOCIATION, INC. SENIOR TAXI PROGRAM 381.65 05452 AAA EMPLOYMENT TEMPORARY EMP: TYMIE MORROW 776.10 02572 ABM OFFI CE EQUI PMENT MAINTENANCE CONTRACT FOR FAX M 395.00 08366 ABT ELECTRONI CS FEE FOR PICK UP OF FREEZER 29.00 09656 ACCURINT - ACCOUNT#103 73 32 BACKGROUND CHECKS 60.00 01561 AMERICAN CHARGE SERVICE SENIOR TAXI PROGRAM 66.50 01620 AMERICAN LANDSCAPING INC. LAWN MOWING I YRD CLEAN UP I TRIM 650.00 08824 AMERICAN NATIONAL SKYLINE, INC. ANNUAL WINDOW CLEANING CONTRAC 1005.00 09796 AMERICAN TEST CENTER TEST & INSPECTION ON REPORT 570.50 01833 ANDERSON LOCK COMPANY REPLACEMENT ELECTRIC STRIKE PA 336.00 02270 AT&T INTERNET SERVI CE 290.83 05044 AVIS RENT A CAR SYSTEM TAC UNIT LEASE-AUGUST 2007 799.09 02566 BASIC FIRE PROTECTION INC. ANNUAL INSPECTION OF VEHICLES 281.85 06287 BEDCO MECHANI CAL REPAIRS TO CARRIER ROOF TOP UN 621.90 REPAIRS TO HOT WATER PUMP - 652.75 REPAIRS TO IGNITION PACK - 170 449.20 REPAIRS TO BRYAN BOILER - VILL 270.00 ______ _M_____ 1993.85 02757 BESSE MEDICAL SUPPLY NURSING SUPPLIES 510.24 NURSING SUPPLIES 6.08 ----- ----_.-- 516.32 01008 BUSSE I S FLOWERS & GIFTS FLORAL DELIVERY - O'NEILL (HUF 70.00 01049 CDW GOVERNMENT I INC 10 874317 HP 94 Ink Black for 179.99 09516 CENTRAL LAWN SPRINKLERS I INC. UNDERGROUND SPRINKLER SYSTEM 612.50 01061 CERTIFIED LABORATORIES 55 Gallon Drum 15w40 10w30 5w3 250 9.6 5 01066 CHARTERHOUSE PUBLISHING CO. TIME AND PAY RECORDS 2008 70.96 08975 CHICAGO OFFICE TECHNOLOGY GROUP QTLY MA COPIES 258.71 08573 CHIOVARI, CORY REAL ESTATE TAX REBATE 930.00 00309 COONEY, WILLIAM J. REIMBURSE FOR CHAMBER OF COMME 157.27 04543 CORPORATE EXPRESS REPLACEMENT CHAIR MATS - PUBLI 1389.29 REPORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 RUN: WEDNESDAY SEP122007 15:34 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 ..... - -...... - - - - -. - - - -...... __a _.... _..... - _.. - - ___.... - _.... - - _.... - - - - _.. __.. _...................... __ __.... _................. _...... __...................... __.......................... ___. _..... _. - __ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ~ -. - ~ -. - - - - - ~ - -.... -. --. -........ -- - --. -. -. - --. - - - -... - - --. -.-.. -.. - - -.... - -.. -.-.... - - - -.... -- - -... -. -. - -..... - - - - -.. - -. - -.. - -. --. -. --. MISC. OFFICE SUPPLIES 260.73 .---.--.----- 1650.02 08589 CRITICAL REACH ANNUAL SERVICE & SUPPORT FEES 500.00 08065 CVS - PHARMACY, INC. PRISONER MEDS#07 -14999 ZACHARS 36.00 04833 DODT, BLAINE TOOL REIMBURSEMENT 500.00 01347 EMPLOYEE DATA FORMS, INC. 200 2008 EMPLYOEE DATA CALENDA 39.00 01356 ENVIRONMENTAL SAFETY GROUP I INC HOSES/CONVERSION KIT 4535.00 HANDLE BATTERY ASSEMBLY 83.44 .--..----..-- 4618.44 01361 ESRI INC. REGISTRATION FEES-GREG NICHOLS 285.00 09653 ETERNO, DAVID G. ADMINISTRATIVE ADJUDICATION 562.50 ADMINITRATIVE ADJUDICATION 583.75 ----.. -. ----. 1146.25 08425 FARNSWORTH GROUP DESIGN ENGINEERING FOR MELAS S 3028.80 01377 FEDERAL EXPRESS CORP PLANNING DIVISION 23.44 PICK-UP FOR KUSSMACH ELECTRONI 16.47 SHIPPING 50.96 ...- -----.._- 90.87 07176 FIRE DEPARTMENT TRAINING NETWORK, INC. MEMBERSHIP-TRUTY FDTN ANNUAL R 240.00 00102 FIRE PENSION FUND PAYROLL FOR - 083007 19870.53 09159 FRANCES I WILLIAM REIMBURSE EXPENSES 40.00 01446 FULTON TECHNOLOGIES I INC. TECHNICAL SERVICE VAN WITH ONE 1491.55 BATTERY I BATTERY CHARGERS I FUSE 540.80 -... ..----.-- 2032.35 09198 GE CAPITOL TOSHIBA LEASE AUGUST 117 .18 TOSHIBA LEASE AUGUST 117.16 TOSHIBA LEASE AUGUST 117.16 TOSHIBA LEASE-SEPT 468.66 . -----..----- 820.16 08154 GLOBAL EMERGENCY PRODUCTS REPAIR PARTS BELT CAP RADIATOR 387.40 01522 GRAINGER INC. LAUNDRY DETERGENT 100# 156.16 LAUNDRY DETERGENT 100# 37.22 2-GENERATOR 5. 5KW,GAS 1258.20 .----.......---- - 1451.58 :EPORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 RUN: WEDNESDAY SEP122007 15: 34 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION 06420 927818309/7653665/53662/684996 GRAYBAR ELECTRI C CO. 09113 HEALY ASPHALT COMPANY, LLC. PATCHING MATERIALS 01578 HENDRICKSEN, ROBERT W. EMERGENCY CONTRACTUAL TREE SER EMERGENCY CONTRACTUAL TREE SER 08573 HENQUINET I EILEEN REAL ESTATE TAX REBATE 10322 HIGHWAY TECHNOLOGIES I INC. 20-T3 BARRICADES 01595 HILTI I INC RAFAELA GARCIA, C. SCHERBAUM 10104 HOTEL PERE MARQUETTE LODGING FOR R. KANE FOR IDEOA 09995 HP PRODUCTS 30 CASES IF STYRI CUPS 01652 ICMA STUDENT ASSOC.MEMBERSHIP 10257 ICMA 401A PLAN PAYROLL FOR - 083007 00107 ICMA RETIREMENT TRUST - 457 PAYROLL FOR - 083007 06690 ILLINOIS AMERICAN WATER CO. SERVICE ATT#09-0013685-4 01669 ILLINOIS CITY/COUNTY MGMT ASSOC. ( ILCMA) STUDENT ASSOC.MEMBERSHIP 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 083007 01698 ILLINOIS MUNICIPAL LEAGUE 2 EMPLOYMENT AD LISTINGS 01701 ILLINOIS PAPER CO. 10 BOXES HIGH TECH WHITE PAPER WHITE/GREEN PAPER 40 CARTONS T 01122 ILLINOIS STATE DISBURSEMENT UNIT PAYROLL FOR - 083007 PAYROLL FOR - 083007 PAYROLL FOR - 083007 PAYROLL FOR - 083007 PAYROLL FOR - 083007 PAYROLL FOR - 083007 10295 ILLINOIS STUDENT ASSISTANCE COMMISSION PAYROLL FOR - 08-30-07 07433 IMAGETEC LP ID#90133759828 ID#90133759827 PATROL COPIER LEASE PAYMENT RECORDS COPIER LEASE PAYMENT OPEN PURCHASE ORDER/ Copier Le COPIER LEASE PAYMENT FOR FEB- D COPIER LEASE PAYMENT FOR FEB-D PAGE AMOUNT 2901. 73 74.21 21260.00 58769.70 80029.70 1028.00 210.00 198.00 198.48 576.00 25.00 2697.04 21660.05 185.14 25.00 22777 . 61 40.00 270.00 1114.0 0 1384.00 357.69 646.10 116.31 520.75 200.00 300.00 214 o.s 5 205.41 356.00 275.00 275.00 390.00 320.35 0.18 585.95 REPORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 RUN: WEDNESDAY SEP122007 15: 34 RELEASE ID ; PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 ~....... -.................. ---....... --................................................................................ --.. -- -- --.. --- ---................................ -_.... --................ --.................... --...................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ............................................. --...... --............................................ --.................. --...........................-.......... --.................. ---................................................. --.............. ADMIN. COPIER LEASE PAYMENT 220.35 ADMIN. COPIER LEASE PAYMENT 100.00 MONTHLY LEASE PAYMENT FOR TOSH 236.00 -- ---..-..-- --.. 2758.83 09562 IMRF PAYROLL FOR - 083007 383.78 PAYROLL FOR - 083007 37105.95 PAYROLL FOR - 083007 17669.44 -------- -- --- 55159.17 08169 INFINITY UNLIMITED INC. NOAA-DESK AM/FM RADIO 45.00 09563 IRS PAYROLL FOR - 083007 179133.44 01783 JOURNAL & TOPICS NEWSPAPERS PZ-25-07 /PZ2607 /PZ2707 /PZ2807 / 692.76 PZ3106THRU PZ3407 582.32 ----------- -- 1275.08 01794 KALE UNIFORMS, INC. UNIFORM SUPPLIES:R.KANE 186.45 01818 KERSTEIN, JUNE BLOOD DRIVE REIMBURSEMENT 90.60 01819 KIEFT BROTHERS INC. 24 X 24 INLET WITH CAST BOTTOM 160.00 01838 KRAMER TREE SPECIALISTS EMERGENCY CONTRACTUAL TREE SER 47565.68 06855 KUSSMAUL ELECTRONICS REBUILD SUPER AUTO EJECT 264.16 01861 LANDS' END BUSINESS OUTFITTERS 2 Shirts with Village Logo/ 95.95 ADDITIONAL SHPG CHGS 1. 50 INV#05675067 ,5691928,05701970 1538.00 ------------- 1635.45 01862 LANDSCAPE FORMS, INC 2 - PETOSKEY BENCH - BLACK 2740.00 2 - SCARBOROUGH LITTER CAN - 1760.00 REPLACEMENT PETOSKEY INTERIOR 285.00 ------ ----..-- 4785.00 09766 LANER MUCHIN LABOR LEGAL EXPENSES 6347.26 01872 LATTOF ARLINGTON HEIGHTS 2 AC BLOWEOR RES I STORS , 1 REMOT 120.53 08631 LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEANI 114.14 00379 LINDELOF, CHARLES M. ADVANCE-TO ATTEND UW-MADISON 292.00 09584 LOGSDON OFFI CE SUPPLY OFFI CE SUPPLIES 121.92 05521 LORMAN EDUCATION SERVICES LORMAN TRAINING PERFORMANCE EV 299.00 01918 LUNDSTROM'S NURSERY, INC. TURF MOWING AT VARIOUS LOCATIO 3169.56 LANDSCAPING MAINTENANCE THROUG 6690.56 REPORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 RUN: WEDNESDAY SEP122007 15: 34 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 DEPT VENDOR NBR INVOICE DESCRIPTION VENDOR NAME 10297 LYNCOLE INDUSTRIES, INC. SUPPLIES FOR EMERG .REPAIRS 10308 MARK DRUG MEDICAL SUPPLIES 01965 MARTAM CONSTRUCTION HAULING AND DISPOSAL OF SWEEP I EMERGENCY CONTRACTUAL SERVI CES CONTRACTUAL SERVICES 08698 MARTINEZ, MIGUEL REIMBURSE EXPENSES 04339 MCGUFFIN, MARK REIMBURSE EXPENSES 01990 MCMASTER-CARR SUPPLY CO. SUPPLIES FOR EMERG. REPAIRS 00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 083007 06291 METROPOLITAN IND., INC. SERVICE TO BOTH 30/40 MPC STAT 01058 MEYER LABORATORY, INC. CUSTOD IAL SUPPLIES 02007 MEYER MATERIAL CO. PATCHING MATERIALS 02046 MOBILE PRINT INC. BUSINESS CARDS FOR BOB ROELS BROCHURE 02058 MORTON GROVE AUTOMOTIVE 02064 MOTOROLA, INC. 02067 MOUNT PROSPECT HISTORICAL SOC. 09912 MOUNT PROSPECT PAINT, INC. 10313 MSU EXTENS I ON - OAKLAND COUNTY 02116 NATIONAL COUNCIL ON THE AGING 00123 NATIONWIDE MUTUAL INSURANCE COMPANY 02148 NEOPOST INC. 02155 NEXTEL COMMUNI CAT IONS 1 STARTER MOTOR 1 ALTERNATOR Micellaneous Motorola XTS3000 BUDGET ALLOCAT I ON - OCTOBER 07 PAINTING SUPPLIES 8/07 REGISTRATION FEE MEMBERSHIP RENEWAL MEMBER PAYROLL FOR - 083007 MONEY ENTERED INTO POSTAGE MAC ACCT#157600518 JULY 2007 ACCT#l57600518 JULY 2007 ACCT#157600518 JULY 2007 ACCT#l57600518 JULY 2007 ACCT#157600518 JULY 2007 ACCT#157600518 JULY 2007 ACCT#157600518 JULY 2007 ACCT#157600518 JULY 2007 ACCT#157600518 JULY 2007 PAGE AMOUNT 9860.12 1478.00 206.80 1400.00 52976.15 22759.20 77135.35 40.00 1209.00 2022.55 2275.00 639.00 506.53 93.38 26.19 98.94 125.13 500.00 536.22 3333.33 37.81 30.00 195.00 18185.79 3000.00 1057.38 173 . 84 646 . 96 27.26 22.58 209.50 1355.31 120.00 219.51 ~EPORT: APBOARDRPT GENERATED: 09 FEB 07 18: 58 RUN: WEDNESDAY SEP122007 15:34 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - -... -............... --.................................................................................................................. -- --- --........................................................................... --... ---......... -- ---............ --............ --......... --.................................... --........ ACCT#157600518 JULY 2007 495.72 ACCT#157600518 JULY 2007 57.86 ACCT#157600518 JULY 2007 425.19 ------------- 4811.11 05236 NFPA MEMBERSHIP-W. SCHROEDER 150.00 09228 NIU CUSTOMER SERVICE TRAINING 379.00 07549 NORTHEASTERN ILL. PUB. SAFETY TRNG. REGISTER C. CHARAK FOR SIMUNTIO 550.00 02193 NORTHWEST ELECTRICAL SUPPLY Station In Supplies for Bunkr 62.21 SUPPLIES FOR EMERG. REPAIRS 45.79 6 120V 20AMP PLUG ENDS 70.01 ------------- 178.01 05124 NORTHWESTERN UNIVERSITY LODGING FOR M. MCGUFFIN FOR SCH 6189.00 02206 NOWAK, THOMAS J. REIMBURSE EXPENSES 40.00 10314 OAKTON GLASS & MIRROR, INC. MIRROR & INSTALLATION 395.60 02229 OFFICE DEPOT OFFICE SUPPLIES 77. 31 OFFI CE SUPPLIES 165.25 ACCTft1Q2055352 OFFICE SUPPLIES 174.92 ------... --- --... 417 .4 8 06765 OLLECH, DIRK REIMBURSE EXPENSES 148.00 10163 ON TIME INC. UNIFORM SUPPLIES 311.50 02256 PADDOCK PUBLICATIONS INC FINE ARTS FESTIVAL EXPENSE 291.60 02301 PETTY CASH - FINANCE DEPT. MI SCELLANEOUS 56.78 MI SCELLANEOUS 31.09 MISCELLANEOUS 63.49 MISCELLANEOUS 58.36 MISCELLANEOUS 31.54 MI SCELLANEOUS 17.00 MISCELLANEOUS 26.65 MI SCELLANEOUS 39.00 MISCELLANEOUS 23.49 MI SCELLANEOUS 18.49 MISCELLANEOUS 8.10 MISCELLANEOUS 82.75 -...-...... ---... --...... 456.74 02310 PIECZYNSKI, LINDA S. ROLL CALL NEWS SUBSCRI PTI ON RE 60.00 00124 POLICE PENSION FUND PAYROLL FOR - 083007 23733.43 04921 POPE, ELIZABETH A. PAYROLL FOR - 083007 923.08 REPORT': APBOARDRPT GENERATED: 09 FEB 07 18:58 RUN: WEDNESDAY SEP122007 15: 34 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 -. - - - - -............ -. -... -........... --...... --........................................ --.................... -- --.... -- -.............................................. ---.............. ---.......... --.............................. ---- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ...................... --........ --.. ---...... --.......... --............ --.............................. ---- --................ --.............................. ----................ --.....-......................-.......................... 10258 POWELL TREE CARE, INC. TREE REMOVAL CONTRACT 21663.00 EMERGENCY CONTRACTUAL TREE SER 25238.75 --------- ---- 46901.75 02358 PRO- SAFETY, INC REPLACEMENT HARD HATS 118.75 06815 PURE AIR AND WATER SYSTEMS, INC. I-Dynamic Overhead Electronic 1220.00 10271 RANDALL INDUSTRIES, INC. RENTAL OF CLUB-CARS-7/4/07 PAR 218.00 02424 REX RADIATOR & WELDING CO, INC. REPAIR OIL COOLER FOR #516 GEN 268.00 07964 RMS BUSINESS SYSTEMS, INC. CISCO WS-C3560G-24-PS-S SWITCH 3805.00 1000BASE- ZX EXTENDED REACH SFP 5433.00 FIBER PATCH CABLES (SC TO LC), 72 .00 10Db IN-LINE OPTICAL ATTENUATO 90.00 FREIGHT 10.00 -- --- --.. ---_.. 9410.00 09712 ROSCOR CORP. LASER FICHE SCANNER 423.69 LASERFI CHE SCANNER 423.69 ---- ---.. -- --- 847.38 10319 SALERNO'S PIZZA PIZZA 94.50 07529 SCHAMBACH SOFTWARE SOLUTIONS, INC. CONSULTING SERVI CES 5642.00 02525 SECRETARY OF STATE LI CENSE PLATES AND TITLE 300.00 00433 SMITH, ROBERT REIMBURSE EXPENSES 24.00 02627 STEINER ELECTRI C COMPANY S002176698- 002, CR#S002236450-0 282.45 02660 SUBURBAN PRINTING PRINTING EXPENSE 853.00 09903 SYMBOLARTS, LLC FRE I GHT FOR ORDERED BADGES 25.00 02691 THOMPSON ELEVATOR INSPECTIONS 2007 ELEVATOR INSPECTIONS 5299.00 00447 TRUTY, CHRIS J. 1- HDTV INDOOR ANTENNA 75.94 05686 ULINE INC. 1 CART FOR ADMIN. 164.54 02756 UNITED STATES POSTAL SERVI CE POSTAGE 7/19-8/28/07 1007.28 POSTAGE 7/19-8/28/07 4.67 .... --- --.. ----.. 1011.95 00127 UNITED WAY PAYROLL FOR - 083007 312.35 02763 UNIVERSITY OF ILLINOIS AT CHICAGO 2007 FALL DIVERSITY CAREER FAI 225.00 02766 UNIVERSITY OF WISCONSIN REGISTRATION FEE-9/13-9/14/07 795.00 EPORT: APBOARDRPT GENERATED: 09 FEB 07 18 :58 RUN: WEDNESDAY SEP122007 15:34 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .... - - -.... - -... --- -............ --... --- -.......................................... --......... -... - -......... --........................ --............ - -... --...... --............ --......... --..... - -........... -.............................. --.... --........ --........ --.. 07860 UPS MISELLANEOUS SHIPPING CHARGES 49.46 02775 USA BLUEBOOK ELECTRICAL SUPPLIES 177 . 46 09216 UTILITY DYNAMICS CORP. STREETLIGHT FOUNDATION REPAIRS 1706.00 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 083007 311.30 101 S. MAPLE STREET 21.36 .. ---- ---- ---- 312 .66 05746 WISCTF PAYROLL FOR - 083007 542.48 TOTAL 723727 . 33 jO 01148 COMMONWEALTH EDISON STREET LIGHTING RATE 25 3731.32 05709 MEADE ELECTRIC CO. INC. 2007 TRAFFIC SIGNAL MAINTENANC 1000.00 TOTAL 4731.32 70 09198 , GE CAPITOL TOSHIBA LEASE AUGUST 117 .16 TOTAL 117 .16 30 01461 GALL'S, INC. CONVERTIBLE DOUBLE DOOR SECURI 453.99 TOTAL 453.99 35 10316 SOS TECHNOLOGIES AED MACHINES & ACCESSORIES 7029.95 TOTAL 7029.95 JO 09852 BANK OF NEW YORK BANK FEES 300.00 TOTAL 300.00 )0 09852 BANK OF NEW YORK BANK FEES 300.00 TOTAL 300.00 lO 10321 BRUSSEAU DESIGN GROUP, LLC. SPACE NEEDS STUDY 5800.00 10238 ECS ILLINOIS, LLC Phase I Environmental Assessme 2000.00 08425 FARNSWORTH GROUP PROFESSIONAL SERIVCE TO PROGRA 2375.00 TOTAL 10175.00 iO EPORT: APBOARDRPT GENERATED: 09 FEB 07 18: 58 RUN: WEDNESDAY SEP122007 15: 34 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -.. -. - - - - - - --. - - - - - - - - - - - -- -- -- - - - - -- - - - - - - - - -- - - - - - - - - - - - -- - - - - - - - - - -- - - - - - - - - - - -- - - - -- - - - - - - - -- - -- - - - - - - - - - - - - - - - - - - - - - - - - -- - - -- 10318 CITGO REFUND MFT-PAID TWICE 1868.36 07267 LPS PAVEMENT CO. REPAIR HANDICAP BRICK RAMPS 1580.00 04813 UNITED RENTALS HIGHWAY TECHNOLOGIES NEIGHBORRHOOD TRAFFIC SIGN PRO 29223.80 TOTAL 32672 .16 10 01773 AMERI CAN WATER WORKS ASSOC. WATER WELL REHABILITATION AND 89.95 08567 A VNY DR., WARREN REFUND FINAL WATER BILL 38.64 05773 BAXTER & WOODMAN, INC. PROFESSIONAL ENGINEERING SERVI 7009.21 PROFESSIONAL ENGINEERING SERVI 7000.00 -------._---- 14009.21 01049 CDW GOVERNMENT, INC REPLACEMENT APC BATTERIES FOR 292.96 INV#GHF9797, GGC8494 1.00 ---------- --- 293.96 01211 CUES, INC. REPAIR PARTS FOR SEWER TELEVIS 606.77 08567 DISCOVERY HOMES 1521 STONEGATE LN. - REFUND WATE 82.87 08829 ENGLEWOOD ELECTRI CAL SUPPLY 6-REPLACEMENT 1747BA MEMORY RE 786.31 ANNUAL SCADA SOFTWARE AGREEMEN 5683.50 - - ---- - -- ---- 6469.81 01377 FEDERAL EXPRESS CORP COURIER SERVICES 2007 278.12 01436 FREDRIKSEN FIRE EQUIPMENT CO., INC 233 CO CYLINDER RECHARGE 103.75 01546 HACH COMPANY CHLORINE REAGENT KIT AND CARRY 331.64 01544 HBK WATER METER SERVI CE 2007 CONTRACT FOR WATER METER 223.99 2007 CONTRACT FOR WATER METER 527.99 2007 CONTRACT FOR WATER METER 218.02 -----_._----- 970.00 07433 IMAGETEC LP MONTHLY LEASE PAYMENT FOR TOSH 236.00 08567 KABBELMAN, DEBORAH REFUND FINAL UTILITY BILL 22.50 01862 LANDSCAPE FORMS, INC 'REPLACEMENT PETOSKEY INTERIOR 30.00 2 - REPLACEMENT PETOSKEY FACE 110 .00 FREIGHT CHARGES TO DELVER REPL 250.00 - - - - - ---- .--. 390.00 08631 LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEANI 114.13 01918 LUNDSTROM'S NURSERY, INC. TURF MOWING AT VARIOUS LOCATIO 481.24 REPORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 RUN: WEDNESDAY SEP122007 15: 34 RELEASE lD : PAGE 10 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 01965 MARTAM CONSTRUCTION HAULING AND DISPOSAL OF SWEEPI 1600.00 HAULING AND DISPOSAL OF SWEEPI 1499.76 .. ----------- 3099.76 01990 MCMASTER - CARR SUPPLY CO. CREDIT#71068798 REGULATOR 131.3 3 02155 NEXTEL COMMUNI CATI ONS ACCT#157600518 JULY 2007 655.75 ACCT#157600518 JULY 2007 33.51 ------------- 689.26 09228 NIU CUSTOMER SERVICE TRAINING 379.00 08567 STAFFORD, MIKE REFUND FOR 306 N. MAIN ST. 16.82 08567 TUBIKANEC, FRANK REFUND FINAL UTILITY BILL 5.68 02756 UNITED STATES POSTAL SERVICE POSTAGE 7/19-8/28/07 1910.33 02775 USA BLUEBOOK FLOATS FOR LIFT STATIONS 266.34 02832 WALMART COMMUNITY WATER SAMPLING PACKING/SHPG 25.58 08567 WIECHERT, SIEGFRIED REFUND FINAL UTILITY BILL 182.87 02914 ZIEBELL WATER SERVICE PRODUCTS COUPLINGS I IRRIGATION SYSTEM RE 1508.89 TOTAL 32734.45 620 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS 20.00 TOTAL 20.00 630 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS 46.00 MISCELLANEOUS 1. 00 ------------- 47.00 TOTAL 47.00 660 02184 ABBOTT RUBBER CO., INC. COUPLING/STRIPE RUBBER 52.64 07423 ALEXANDER EQUIP. CO. , INC. LOCKING PIN 26.85 09676 AMERICAN MESSAGING PAGER MESSAGING SERVI CE 53.52 03958 CHICAGO INTERNATIONAL TRUCK INT I L CAMSHAFT SENSOR 166.60 05579 ELMHURST LINCOLN MERCURY FORD STROBE BULB 232.32 10196 GAS DEPOT INC. OCTQANE UNLEADED GASOLINE 21248.19 DIESEL FUEL 15504.37 EPORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 RUN: WEDNESDAY SEP122007 15: 34 PAGE 11 RELEASE m : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 . ~ -. -.. - - - - - - - - - -.. - - - - - - - -- - -- - -- - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - -- - -- - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - - - - --- - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - - - - - - - - - - - - - - - - - -- - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - -- - - - - - - - - - - - --- - - - -- - - - - - - -- ------------- 36752.56 08705 GENUINE PARTS COMPANY-NAPA INV#243258,243585 398.37 01872 LATTOF ARLINGTON HEIGHTS INV#257443-1 PARTS/SERV. AUG07 28.99 02058 MORTON GROVE AUTOMOTIVE NEW REPLACEMENT/REBUILT STARTE 360.00 02104 NAFA, INC. MEMBERSHI P m# 0 0 72 4 6 440.00 02155 NEXTEL COMMUNICATIONS ACCTm7600518 JULY 2007 350.36 02610 STANDARD EQUIPMENT COMPANY REPAIR AND RECHARGE ACCUMULATO 863.20 02684 TERRACE SUPPLY COMPANY HELIUM VALVE RUBBER TIP 17.70 02769 UPTOWN AUTO SUPPLY CHEVROLET REPAIR PARTS 39.90 02861 WEST S IDE TRACTOR SALES JOHN DEERE TRANSFER FUEL PUMP 81.03 TOTAL 39864.04 70 02184 ABBOTT RUBBER CO., INC. COUPLING/STRIPE RUBBER 49.19 07422 CURRIE MOTORS 2 - 2008 FORD F450 4 X 4 26,00 69526.00 08059 NAVISTAR FINANCIAL CORP. 2008 INT'L 7400 SFA 4X2 CAB&CH 56262.00 2008 INT'S 7400 SFA 6X4 CAB&CH 65869.00 ----- -------- 122131.00 02870 WHOLESALE DIRECT INC. TRAILER PLUG/ASSEMBLY 89.48 TOTAL 191795.67 80 01568 AMERICAN COMPUTER & COMMUN. INC JULIE Teleticket Server Replac 4225.00 08146 DELL MARKETING L. P . DELL PRECISION 690, DUAL CORE 4025.37 DELL POWEREDGE 2900, QUAD CORE 6131.75 DELL POWEREDGE 2950, QUAD CORE 5331.50 DELL PV114T 2U DLT VS160 TAPE 2998.40 - - ---------.- 18487.02 TOTAL 22712.02 i90 10051 CCMSI W/C REIMBURSEMENT 8/30/07 45091.57 01102 GAB ROBINS N .A., INC - CITIBANK INSURANCE CLAI MS - GAB 2314.19 02195 NORTHWEST FORD TRUCK CENTER Windshield for #535 351.01 10320 SUBURBAN TRIM & GLASS LABOR AND INSTALL OF WINDSHIEL 228.50 REPORT: APBOARDRPT GENERATED: 09 FEB 07 18: 58 RUN: WEDNESDAY SEP122007 15: 34 PAGE 12 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 . - - - --..... -........ --.................................... --...................... -....-................... -- --.......................................... --........................ -- --...... --............................................... --........ --.. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .......... --........... --_...... --..... --............................-... --...... --... -_............................................................................... --.......... --.... --.. --.................................................. --........ 02684 TERRACE SUPPLY COMPANY PAINT SUPPLIES/ACCIDENT REPAIR 99.70 TOTAL 48084.97 710 01027 CAPITAL GAINS INC. POLICE PENSION 1808.00 TOTAL 1808.00 720 01027 CAPITAL GAINS INC. FIRE PENSION 2307.00 TOTAL 2307.00 770 02667 BEHUN, DAVID FLEX COMP 422.96 00308 CONNOLLY, JUDY FLEX COMP 518.74 00322 EISEN, BARRY FLEX COMP 500.00 08107 ERB, DAVID FLEX COMP 238 .62 00330 FELTEN, BARBARA FLEX COMP 132 .96 01418 FLORY, JAMES M. FLEX COMP 102.91 05093 GRANDGEORGE, ARRON FLEX COMP 156.00 08178 GUARDIAN EMP DENTAL PLAN PREMIUM 638 9.2 8 08896 HALVERSON, BRIAN FLEX COMP 331.33 08928 HERMANN, JAMES FLEX COMP 409.63 00349 HOSKINSON, THOMAS FLEX COMP 333.28 10020 JAROG, LYNN FLEX COMP 416.66 01902 LIVINGSTON, CHARLES E. FLEX COMP 82.10 10037 PARK, CHRISTINA FLEX COMP 460.09 06040 REDLIN, RON FLEX COMP 193.58 02433 RICKER, JEFFREY FLEX COMP 24.00 02473 RUMORE, CINDY JO FLEX COMP 299.09 09778 SCHRAEDER, TRICIA FLEX COMP 44.12 00429 SEMKIU, MICHAEL J. FLEX COMP 1106.57 09237 SLOAN, CLARE FLEX COMP 10.00 02635 STEWARD, DALE R. FLEX COMP 191.87 RUN: WEDNESDAY SEP122007 15: 34 RELEASE ID : PORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 PAGE 13 IEPT VENDOR NBR - - - -.. -. - - - - - - - - - - ---- - - - - - - - - - - -- - - -- - - - - - - - - - - - - - - - - - _.- - - - - - - - - - - - - - -- - - - - - - --- - - - - - - - -- - - - - - - - -- -- - -- - - - - - - - -- - - - - - - - - - - -- - -- AMOUNT VENDOR NAME INVOICE DESCRIPTION - - - - - - - - - - - - - - - - - -- - -- -- -- - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - -- - - - - - - - -- - - - - - - - - - -- - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - -- - - -- - - - - - - - - - - -- 02710 09222 10 01712 10309 03524 09023 02689 TRACY, RICHARD L. FLEX COMP WHEATELY I CLAIRE FLEX COMP TOTAL 13634.74 750.00 ILLINOIS STATE POLICE ASSET FORFEITURE SEC. SEIZED MONEY TO BE TURNED OVER LA RUSSO, MARTY ESCROW REFUND 071671 RI CHTER, THERESA ESCROW REFUND 071667 STARBUCKS REFUND FOR DUPLICATE PAYMENT THIRD DISTRICT CIRCUIT COURT BOND MONEY BOND MONEY BOND MONEY BOND MONEY TOTAL GRAND TOTAL 520.95 341.00 75.00 75.00 10.00 1400.00 2075.00 2900.00 2818.00 9193.00 9694.00 1142208.80 REPORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 RON: WEDNESDAY SEP122007 15:34 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 30 2007 TO SEPTEMBER 12 2007 SUMMARY BY FUND 001 GENERAL FUND 72 372 7.3 3 050 MOTOR FUEL TAX FUND 4731.32 070 COMMUNITY DEVELPMNT BLOCK GRNT 117.16 080 ASSET SEIZURE FUND 453.99 085 DEA SHARED FUNDS FUND 7029.95 190 SERIES 2003 B&I, VILLAGE HALL 300.00 290 SERIES 1999 B&I, TIF 300.00 510 CAPITAL IMPROVEMENT FUND 10175.00 560 STREET IMPROVEMENT CONST FUND 32672.16 610 WATER AND SEWER FUND 32734.45 620 VILLAGE PARKING SYSTEM FUND 20.00 630 PARKING SYSTEM REVENUE FUND 47.00 660 VEHI CLE MAINTENANCE FUND 39864.04 670 VEHI CLE REPLACEMENT FUND 191795.67 680 COMPUTER REPLACEMENT FUND 22712.02 690 RISK MANAGEMENT FUND 48084.97 710 POLICE PENSION FUND 1808.00 720 FIRE PENSION FUND 2307.00 770 FLEXCOMP ESCROW FUND 13634.74 790 ESCROW DEPOSIT FUND 9694.00 ---.---.-.-.-- TOTAL : 1142208.80 PAGE 14 Village of Mount Prospect List of Escrow Checks Presented to the Board of Trustees 09/01/07 To 09/12/07 09/14/07 EMR025 Paid to Permit # AQUA PLUMBING SERVICES 071499 ARCHADECK OF LAKE COOK 071164 BAUMGARTNER, JOHN 070790 BRIGHTON, JOY T CHOWANSKI, STEVEN COCONATE, GRACE 072110 071694 072050 CRYSTAL TOWERS REC BLDG 062162 CZECH, TIM/JILL 071594 DALTON PLUMBING & SEWER 071928 DESMOND LANDSCAPE 071915 DNR CONSTRUCTION INC 071121 EPPERSON, DAVID 052417C FERNANDEZ, CARLOS 070784 FILSINGER, LEONARD E FOX, ROBERT 071880 072060 HANSEN, R IGLESIAS, CARLOS M JACOBSEN, AMY JAMES MICHAEL DEV 072014 071410 071 761 05R530 KAFKAKIS, ANTHONY 071093 KAND, ALVIN 071866 LABAHN, STEVEN C LEENEY, DAVID 071513 071944 LOMBARDO (TRUST), LINDA 070615 MACNAK, GUY MARTY LA RUSSO 072062 071671 MAU, ERIC 060781 MICUN, THOMAS W 062172 NORMANDY BUILDERS 070472 OLIVETO, ANTHONY 071846 PAGLINI, JOSEPH AND LISA 071754 PLUMMER, ELAINE M 070727 PRUS, ADAM 070532 RICHTER, THERESA 071667 ROYAL PLUMBING 072057 SLOSAR, EDWARD F 071030 SMAGLINSKI, CHRISTIAN 070594 STRYKER, ANN SUN SPACE DESIGN/PARADISE ROOMS T & K ENTERPRISES 072061 070791 050330A VARGHESE, MOHAN 072020 WEILER, EDWARD 070566 WORKMASTER INC 060626A l'age 1 Check # Amount 13001667 75.00 13001668 200.00 13001669 200.00 13001670 125.00 13001671 200.00 13001672 125.00 13001673 500.00 13001674 200.00 13001675 125.00 13001676 200.00 13001677 375.00 13001665 150.00 13001678 450.00 13001679 200.00 13001680 125.00 13001681 125.00 13001682 450.00 13001683 200.00 13001666 20,442.00 13001684 200.00 13001685 200.00 13001686 200.00 13001687 200.00 13001688 500.00 13001689 200.00 13001655 75.00 13001690 500.00 13001691 350.00 13001692 500.00 13001693 200.00 13001694 150.00 13001695 450.00 13001696 200.00 13001660 75.00 13001697 125.00 13001698 200.00 13001699 200.00 13001700 125.00 13001701 500.00 13001702 4,000.00 13001703 200.00 13001704 200.00 13001705 300.00 .. VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES August 1- August 31,2007 09/12/2007 12,19,21 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 08/31/07 ... Cur Mo Received Y-T-D Received 8 Months 4 Months 2007 Budget 66.6% 33.3% unreceived Balance Completed Remaining Unreceived Percent 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,452 983,697 321,216 1,041,051 2,071,626 65,223 707,453 16,892 265,376 o 5,497,986 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 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 ESCROW DEPOSIT FUND 2,188,357 244,423 144,897 4 39,962 1,982 137 1,374 190 1,712 1,261 1,895 o o 1,225 86 4,150 499 47,829 60,641 o o o 2,819 8,939 148,110 2,630 904,848 9,471 10,134 157,839 113,489 18,898 674,082 346,057 359,972 o 6,524,115 7,159,904 2,695,742 8,515,199 13,918,372 397,091 6,402,281 190,656 2.924,018 o 48,727,378 20,982,892 2,473,685 997,852 35 132,725 9,238 1,073 15,686 1,659 215,477 201,103 311,565 o o 585,532 849 19,346 49,695 222,998 281,299 2 o o 43,504 688,551 774,533 21,819 6,574,979 71,199 69,202 1,103,444 816,486 138,807 4,594,502 3,635,709 3,689,573 o 1 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 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 o 6,850,837 8,224,755 259,146 7,965,610 7,491,361 155,909 -900,331 80,584 2,048,686 60,000 32,236,557 17,437,331 1,827,066 630,898 965 417,084 -6,638 1,427 4,664 49,841 -214,477 193,397 614,685 o o 490,968 -849 30,021 38,812 359,935 453,951 -2 o o 219,296 531,501 936,567 10,181 4,574,121 25,539 41,898 469,909 277,140 50,740 1,879,437 489,791 403,717 o 51.2 53.5 8.8 48.3 35.0 28.2 -16.4 29.7 41.2 100.0 39.8 45.4 42.5 38.7 96.5 75.9 -255.3 57.1 22.9 96.8 **** * 49.0 66.4 45.6 60.8 43.9 61. 7 61. 7 83.4 43.6 54.7 31. 8 41. 0 26.4 37.7 29.9 25.3 26.8 29.0 11.9 9.9 09/12/2007 12:19:21 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 - 08/31/07 8 Months 4 Months 66.6% 33.3% Completed Remaining ... Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent SSA #6 GEORGE/ALBERT B&I 66 552 0 -552 SERIES 2002 LIBRARY BND ESCROW 8 1,807 0 -1,807 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 5,497,986 48,727,378 80,963,935 32,236,557 39.8 2 09/12/2007 8 Months 66.6% Completed 12:19:48 VILLAGE OF 4 Months 33.3% Remaining FRRBRR03 MOUNT PROSPECT SUM 021 Budget Revenue by Category within Fund Summary 01/01/07 08/31/07 Cur Mo Y-T-D 2007 Unreceived unreceived Received Received Budget Balance Percent GENERAL FUND 40 PROPERTY TAXES 19,258 4,848,312 10,050,926 5,202,614 51. 8 41 OTHER TAXES 727,132 3,923,261 8,447,000 4,523,739 53.6 42 LICENSES, PERMITS & FEES 318,936 2,680,106 2,935,250 255,144 8.7 43 INTERGOVERMENT REV. 899,876 7,523,121 14,162,700 6,639,579 46.9 44 CHARGES FOR SERVICE 97,595 1,060,347 1,551,507 491,160 31. 7 45 FINES AND FORFEITS 62,215 375,323 531,000 155,677 29.3 46 INVESTMENT INCOME 41,081 356,191 397,000 40,809 10.3 47 REIMBURSEMENTS 16,520 149,056 189,740 40,684 21.4 48 OTHER REVENUE 5,744 67,175 155,100 87,925 56.7 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL GENERAL FUND 2,188,357 20,982,892 38,420,223 17,437,331 45.4 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 3,572 964,669 2,016,276 1,051,607 52.2 44 CHARGES FOR SERVICE 236,066 1,455,127 2,211.475 756,348 34.2 46 INVESTMENT INCOME 4,785 53,807 72,000 18,193 25.3 48 OTHER REVENUE 0 82 1,000 918 91.8 TOTAL REFUSE DISPOSAL FUND 244,423 2,473,685 4,300,751 1,827,066 42.5 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 141,175 951,742 1,587,500 635,758 40.0 46 INVESTMENT INCOME 3,722 44,078 34,750 -9,328 -26.8 47 REIMBURSEMENTS 0 2,032 6,500 4,468 68.7 TOTAL MOTOR FUEL TAX FUND 144,897 997,852 1,628,750 630,898 38.7 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 0 0 1,000 1,000 100.0 46 INVESTMENT INCOME 4 35 0 -35 TOTAL LAW ENFORCEMENT BLOCK GRANT 4 35 1,000 965 96.5 COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 0 40,336 489,809 449,473 91. 8 46 INVESTMENT INCOME 312 1,365 0 -1,365 48 OTHER REVENUE 39,650 91,024 60,000 -31,024 -51.7 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 39,962 132,725 549,809 417,084 75.9 ASSET SEIZURE FUND 45 FINES AND FORFEITS 1,706 6,866 1,000 -5,866 -586.6 46 INVESTMENT INCOME 276 2,372 1,600 -772 -48.3 TOTAL ASSET SEIZURE FUND 1,982 9,238 2,600 -6,638 -255.3 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 0 0 1,000 1,000 100.0 46 INVESTMENT INCOME 137 1,073 1,500 427 28.5 1 09/12/2007 12:19:48 FRRBRR03 SUM021 8 Months 4 Months 66.6% 33.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 08/31/07 Cur Mo Received TOTAL DEA SHARED FUNDS FUND 137 DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 1,302 72 TOTAL DUI FINE FUND 1,374 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 190 o TOTAL FOREIGN FIRE TAX BOARD FUND 190 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME 765 947 TOTAL SERIES 1987A B&I, PW FACILITY 1,712 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 730 531 o TOTAL SERIES 2001 B&I, VILLAGE HALL 1,261 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 1,127 768 o TOTAL SERIES 2003 B&I, VILLAGE HALL 1,895 SERIES 2002B B&I, PUBLIC BLDGS 40 PROPERTY TAXES 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 1,039 186 o TOTAL SERIES 1999 B&I, TIF 1,225 2 Y-T-D Received 1,073 14,902 784 15,686 o 1,659 o 1,659 209,650 5,827 215,477 197,119 3,984 o 201,103 304,365 7,200 o 311,565 o o o o o 564,922 20,610 o 585,532 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 1,053,500 23,000 o 1,076,500 o o o o o Unreceived Balance 1,427 5,098 -434 4,664 46,500 3,341 o 49,841 -208,650 -5,827 -214,477 193,381 16 o 193,397 611,885 2,800 o 614,685 488,578 2,390 o 490,968 Completed Remaining Unreceived Percent 57.1 25.5 -124.0 22.9 100.0 66.8 96.8 ****.* ****.* 49.5 0.4 49.0 66.8 28.0 66.4 o o o o o 46.4 10.4 45.6 Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent 0 0 0 0 86 849 0 -849 86 849 0 -849 . 09/12/2007 12:19:48 FRRBRR03 SUM 021 8 Months 4 Months 66.6% 33.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 08/31/07 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 49,067 300 30,427 -406 4,010 140 18,640 706 TOTAL SERIES 1998A B&I, FLOOD 4,150 19,346 49,367 30,021 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 86 413 46,817 2,878 87,307 1,200 40,490 -1,678 TOTAL SERIES 1998C B&I, TIF 499 49,695 88,507 38,812 IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 47,637 192 221,448 1,550 582,933 o 361,485 -1,550 TOTAL IEPA FLOOD CONTROL LOANS B&I 47,829 222,998 582,933 359,935 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 276,557 4,742 728,000 7,250 451,443 2,508 59,491 1,150 60,641 281,299 735,250 453,951 TOTAL SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME o o o 2 o o TOTAL SERIES 2002B B&I, FLOOD o 2 o SERIES 1998A B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME o o o o o o TOTAL SERIES 1998A B&I, STREET IMP. o o o SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME o o o o o o TOTAL SERIES 2002B B&I, STREET IMP. o o o CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE Completed Remaining 62.0 -135.3 60.8 46.4 -139.8 43.9 62.0 61. 7 62.0 34.6 61.7 o -2 -2 o o o o o o 0 0 239,800 239,800 100.0 2,819 29,113 8,500 -20,613 -242.5 0 0 0 0 0 14,391 14,500 109 0.8 3 09/12/2007 12:19:48 FRRBRR03 SUM 021 8 Months 4 Months 66.6% 33.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 - 08/31/07 Cur Mo Received 49 OTHER FINANCING SOURCES TOTAL CAPITAL IMPROVEMENT FUND 2,819 DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES 1,151 7,788 o o TOTAL DOWNTOWN REDEVLPMNT CONST 8,939 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 140,421 o 7,689 o o TOTAL STREET IMPROVEMENT CONST FUND 148,110 FLOOD CONTROL CONST FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 2,630 o TOTAL FLOOD CONTROL CONST FUND 2,630 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 2,730 1,780 879,640 19,848 o 850 o TOTAL WATER AND SEWER FUND 904,848 VILLAGE PARKING SYSTEM FUND 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 500 8,674 297 o TOTAL VILLAGE PARKING SYSTEM FUND 9,471 PARKING SYSTEM REVENUE FUND 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE o o 10,134 o o 4 Y-T-D Received o 43,504 626,080 62,471 o o 688,551 720,439 o 54,094 o o 774,533 o 21,819 o 21,819 761,740 9,590 5,624,026 153,965 1,083 24,575 o 6,574,979 6,046 62, 713 2,440 o 71,199 o o 69,202 o o 2007 Budget o 262,800 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 7,638 88,500 600 o 96,738 o o 110,000 1,100 o Unreceived Balance o 219,296 541,472 -9,971 o o 531,501 968,261 o -31,694 o o 936,567 o 10,181 o 10,181 772,360 2,410 3,795,974 14,035 -1,083 -9,575 o 4,574,121 1,592 25,787 -1,840 o 25,539 o o 40,798 1,100 o Completed Remaining Unreceived Percent o 83.4 46.4 -19.0 43.6 57.3 -141.5 54.7 31. 8 31.8 50.3 20.1 40.3 8.4 -63.8 41.0 20.8 29.1 -306.7 26.4 37.1 100.0 '09/12/2007 12:19:48 FRRBRR03 SUM 021 8 Months 4 Months 66.6% 33.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 - 08/31/07 Cur Mo Received 49 OTHER FINANCING SOURCES TOTAL PARKING SYSTEM REVENUE FUND 10,134 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 155,595 2,244 o TOTAL VEHICLE MAINTENANCE FUND 157,839 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 4 8 OTHER REVENUE 49 OTHER FINANCING SOURCES 84,963 28,526 o o TOTAL VEHICLE REPLACEMENT FUND 113,489 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 15,872 3,026 TOTAL COMPUTER REPLACEMENT FUND 18,898 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 4 8 OTHER REVENUE 583,087 9,277 372 81,346 674,082 TOTAL RISK MANAGEMENT FUND POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 271,444 74,613 TOTAL POLICE PENSION FUND 346,057 FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 296,799 63,173 TOTAL FIRE PENSION FUND 359,972 ESCROW DEPOSIT FUND 46 INVESTMENT INCOME TOTAL ESCROW DEPOSIT FUND SSA #6 GEORGE/ALBERT B&I 41 OTHER TAXES 46 INVESTMENT INCOME 5 Y-T-D Received o 69,202 1,089,169 14,275 o 1,103,444 594,739 221,747 o o 816,486 113,932 24,875 138,807 3,849,117 72,551 38,485 634,349 4,594,502 2,541,726 1,093,983 3,635,709 2,691,134 998,439 3,689,573 o o o 66 o 552 2007 Budget 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 2,204,500 1,888,790 4,093,290 o o Unreceived Balance o 41,898 466,784 3,125 o 469,909 254,887 -37,747 o 60,000 277,140 45,615 5,125 50,740 1,614,008 19,449 36,515 209,465 1,879,437 -410,726 900,517 489,791 -486,634 890,351 403,717 o o o o o -552 Completed Remaining unreceived Percent o 37.7 30.0 18.0 29.9 30.0 -20.5 100.0 25.3 28.6 17.1 26.8 29.5 21.1 48.7 24.8 29.0 -19.3 45.2 11.9 -22.1 47.1 9.9 o o 09/12/2007 12,19,48 FRRBRR03 SUM021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 - 08/31/07 8 Months 4 Months 66.6% 33.3% Completed Remaining Cur Mo Received Y-T-D Received 2007 Budget Unreceived Balance Unreceived Percent TOTAL SSA #6 GEORGE/ALBERT B&I 66 552 o -552 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME 8 1,807 o -1,807 TOTAL SERIES 2002 LIBRARY BND ESCROW 8 1,807 o -1,807 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 '09/12/2007 12,18,21 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 08/31/07 Cur Mo Expended Y-T-D Expended 2007 Budget 66.6% 33.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 INTER FUND TRANSFERS Total All Funds 2,687,341 675,814 20,846 437,981 1,382,407 70,948 474,356 127,682 6,343 o 76,064 14,396 5,585 22,390 10,321 279,025 o 372,197 o o 6,663,696 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 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 DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND 3,715,985 342,892 68,692 o 16,557 2,756 o 870 o o o o o o o o o o o o o o 79,465 385,003 197,910 3,838 801,690 8.915 16,103,623 5,650,121 227,056 3,469,807 9,430.389 335,297 4,981,633 1,028,596 126,943 o 107,621 155,592 532,644 196,613 764,883 1,795,231 1,118,302 1,276,389 1,800 o 47,302,540 24,291,526 2,489,424 1,609,922 670 131,144 4,878 o 7,502 2,582 405,000 91,883 216,097 o 915,800 o 1,698 4,288 326,323 41,371 o o o 367,128 533,287 477,867 9,863 5,787,901 56,852 1 24,621,815 9,104,278 457,138 5,131,797 16,330,762 735,159 7,174,552 1,575,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 916,100 o 67,795 153,575 613,356 727,743 o o o 1.026,993 2,455,187 2,258,907 244,000 11,675,919 123,154 8,518,192 3,454,157 230,082 1,661,990 6,900,373 399,862 2, 192, 919 546,661 1,851,057 50,000 210,599 215,443 1,034,166 1,222,345 1,369,251 2,801,354 1,755,893 52,644 1,200 o 34,468,188 13,901,458 1,540,183 154,379 330 621,165 -3,878 1,000 -6,502 7,891 o 291,882 680,497 o 300 o 66,097 149,287 287,033 686,372 o o o 659,865 1,921,900 1,781,040 234,137 5,888,018 66,302 34.6 37.9 50.3 32.4 42.3 54.4 30.6 34.7 93.6 100.0 66.2 58.1 66.0 86.1 64.2 60.9 61.1 4.0 40.0 42.2 36.4 38.2 8.8 33.0 82.6 -387.8 100.0 -650.2 75.3 76.1 75.9 97.5 97.2 46.8 94.3 64.3 78.3 78.8 96.0 50.4 53.8 09/12/2007 12,18,21 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 - 08/31/07 8 Months 4 Months 66.6% 33.3% Completed Remaining Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent PARKING SYSTEM REVENUE FUND 15,898 85,386 156,448 71,062 45.4 VEHICLE MAINTENANCE FUND 151,988 928,853 1,578,353 649,500 41.2 VEHICLE REPLACEMENT FUND 5,149 402,296 1,406,810 1,004,514 71.4 COMPUTER REPLACEMENT FUND 13,121 125,756 249,050 123,294 49.5 RISK MANAGEMENT FUND 418,697 4,546,778 6,585,214 2,038,436 31. 0 POLICE PENSION FUND 210,753 1,657,224 2,465,133 807,909 32.8 FIRE PENSION FUND 223,517 1,783,241 2,627,958 844,717 32.1 SSA #6 GEORGE/ALBERT B&I 0 0 0 0 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 6,663,696 47,302,540 81,770,728 34,468,188 42.2 2 '09/12/2007 12:20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/31/07 PUBLIC REPRESENTATION Cur Mo Expended PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 03 ADVISORY BOARDS & COMMISSIONS 4,080 1,281 Totals 5,361 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 3,012 569 490 1,062 228 o Totals 5,361 SOURCE OF FUNDS 001 GENERAL FUND 5,361 Totals 5,361 1 Y-T-D Expended 85,289 13,141 98,430 26,143 4,711 490 65,167 364 1,555 98,430 98,430 98,430 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 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 25,981 3,869 29,850 9,323 1,650 2,510 12,186 136 4,045 29,850 29,850 29,850 23.3 22.7 23.3 26.3 25.9 83.7 15.8 27.2 72 .2 23.3 23.3 23.3 09/12/2007 12:20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 08/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 51,145 41,344 29,266 110,740 9,102 Totals 241,597 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 96,079 32,557 2,072 107,898 1,823 935 233 o Totals 241,597 SOURCE OF FUNDS 001 GENERAL FUND 241,597 Totals 241,597 2 Y-T-D Expended 361,026 337,349 167,164 552,196 81,237 1,498,972 591.107 193,412 20,481 680,563 4,746 6,673 1,990 o 1,498,972 1,498,972 1,498,972 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 66.6% 33.3% Unexpended Balance 148,524 293,401 120,139 369,139 62,135 993,338 307,432 88,213 25,919 535,033 5,399 4,812 24,930 1,600 993,338 993,338 993,338 Completed Remaining Unexpended Percent 29.1 46.5 41.8 40.1 43.3 39.9 34.2 31.3 55.9 44.0 53.2 41.9 92.6 100.0 39.9 39.9 39.9 . 09/12/2007 8 Months 66.6% Completed 12:20:26 VILLAGE OF MOUNT PROSPECT 4 Months 33.3% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 08/31/07 Cur Mo Y-T-D 2007 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 13,531 79,668 130,245 50,577 38.8 04 INTERGOVERNMENTAL PROGRAMMING 4,642 26,359 48,322 21,963 45.5 Totals 18,173 106,027 178,567 72,540 40.6 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 10,871 64,788 102,484 37,696 36.8 51 EMPLOYEE BENEFITS 4,214 27,647 41,133 13,486 32.8 52 OTHER EMPLOYEE COSTS 965 1,500 2,650 1,150 43.4 54 CONTRACTUAL SERVICES 472 5,545 13,150 7,605 57.8 55 UTILITIES 810 1,831 1,600 -231 -14.4 57 COMMODITIES & SUPPLIES 841 3,663 7,050 3,387 48.0 67 OTHER EQUIPMENT 0 1,053 10,500 9,447 90.0 Totals 18,173 106,027 178,567 72,540 40.6 SOURCE OF FUNDS 001 GENERAL FUND 18,173 106,027 178,567 72,540 40.6 Totals 18,173 106,027 178,567 72,540 40.6 3 09/12/2007 8 Months 66.6% Completed 12:20:26 VILLAGE OF MOUNT PROSPECT 4 Months 33.3% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 - 08/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 21,179 129,547 205,188 75,641 36.9 Totals 21,179 129,547 205,188 75,641 36.9 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 12,808 77,459 113,075 35,616 31.5 51 EMPLOYEE BENEFITS 4,634 30,329 43,977 13,648 31.0 52 OTHER EMPLOYEE COSTS 937 1,207 2,625 1,418 54.0 54 CONTRACTUAL SERVICES 1,440 16,516 38,748 22,232 57.4 55 UTILITIES 794 1,132 1,650 518 31.4 57 COMMODITIES & SUPPLIES 566 2,904 5,113 2,209 43.2 Totals 21,179 129,547 205,188 75,641 36.9 SOURCE OF FUNDS 001 GENERAL FUND 21,179 129,547 205,188 75.641 36.9 Totals 21,179 129,547 205,188 75,641 36.9 4 09/12/2007 8 Months 66.6% Completed 12,20,26 VILLAGE OF MOUNT PROSPECT 4 Months 33.3% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 08/31/07 Cur Mo Y-T-D 2007 Unexpended Unexpended FINANCE DEPARTMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 29,886 213,638 301,287 87,649 29.1 02 ACCOUNTING 41,798 299,188 444,679 145,491 32.7 04 DUPLICATING SERVICES 0 0 0 0 05 INSURANCE PROGRAMS 53,130 363,297 521,445 158,148 30.3 06 CUSTOMER SERVICES 44,252 263,408 409,237 145,829 35.6 07 CASH MANAGEMENT 12,942 32,189 49,732 17,543 35.3 Totals 182,008 1,171,720 1,726,380 554,660 32.1 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 90,344 520,230 796,825 276,595 34.7 51 EMPLOYEE BENEFITS 31,256 199,551 295,144 95,593 32.4 52 OTHER EMPLOYEE COSTS 341 5,981 10,640 4,659 43.8 54 CONTRACTUAL SERVICES 11,862 114,303 137,776 23,473 17.0 55 UTILITIES 2,748 4,470 5,150 680 13 .2 56 INSURANCE 45,061 315,424 450,605 135,181 30.0 57 COMMODITIES & SUPPLIES 396 11,461 24,240 12,779 52.7 65 OFFICE EQUIPMENT 0 300 6,000 5.700 95.0 Totals 182,008 1,171,720 1,726,380 554,660 32.1 SOURCE OF FUNDS 001 GENERAL FUND 182,008 1,171,720 1,726,380 554,660 32.1 Totals 182,008 1,171,720 1,726,380 554,660 32.1 5 09/12/2007 12:20:26 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/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 27,147 28,822 8,499 85,099 48,806 14,179 Totals 212,552 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 144,084 49,524 2,350 11,239 5,355 o o Totals 212,552 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 212,552 o Totals 212,552 6 Y-T-D Expended 158,027 182,741 67,688 520,487 296,013 82,075 1,307.031 821,554 337,593 14,787 113,161 12,730 7,206 o 1,307,031 1,306,131 900 1,307.031 2007 Budget 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 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 82,602 82,839 41,748 292,004 194,167 46,243 739,603 434,091 160,074 15,776 99,323 5,825 11,514 13,000 739,603 739,603 o 739,603 34.3 31. 2 38.1 35.9 39.6 36.0 36.1 34.6 32.2 51.6 46.7 31.4 61.5 100.0 36.1 36.2 36.1 '09/12/2007 12:20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/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 10,214 o o 6,343 Totals 16,557 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 62 LAND IMPROVEMENTS 64 BUILDING IMPROVEMENTS 69 INFRASTRUCTURE 7,697 2,378 o 139 o 6,343 o o o Totals 16,557 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 16,557 Totals 16,557 7 Y-T-D Expended 57,902 32,500 o 40,742 131,144 38,724 14,805 2,534 34,339 o 40,742 o o o 131,144 131,144 131,144 2007 Budget 83,309 134,000 310,000 225,000 752,309 52,004 20,697 6,020 147,639 949 190,000 o o 335,000 752,309 752,309 752,309 66.6% 33.3% Unexpended Balance 25,407 101,500 310,000 184,258 621,165 13,280 5,892 3,486 113,300 949 149,258 o o 335,000 621,165 621,165 621,165 Completed Remaining Unexpended Percent 30.5 75.7 100.0 81. 9 82.6 25.5 28.5 57.9 76.7 100.0 78.6 100.0 82.6 82.6 82.6 09/12/2007 12,20,26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/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 25,366 38,120 27,320 2,719 o Totals 93,525 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 54,286 21,409 220 11,887 2,774 1,907 1,042 Totals 93,525 SOURCE OF FUNDS 001 GENERAL FUND 93,525 Totals 93,525 8 Y-T-D Expended 131,201 227,198 121,649 20,202 o 500,250 317,963 116,797 1,407 40,506 5,434 5,272 12,871 500,250 500,250 500,250 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 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 45,076 115,629 70,332 24,720 o 255,757 160,223 54,808 2,493 13,095 2,566 31,943 -9,371 255,757 255,757 255,757 25.6 33.7 36.6 55.0 33.8 33.5 31.9 63.9 24.4 32.1 85.8 -267.7 33.8 33.8 33.8 .09/12/2007 12,20,26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/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 167,313 857,532 33,953 118,968 243 75,377 Totals 1,253,386 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 891,122 186,544 4,037 132,231 12,334 18,585 o 8,533 Totals 1,253,386 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND 1,249,760 o 2,756 o 870 Totals 1,253,386 Y-T-D Expended 1,738,268 5,307,866 189,192 769,532 14,963 539,302 8,559,123 5,449,889 1,897,730 90,300 982,857 31,448 80,560 7,355 18,984 8,559,123 8,546,073 670 4,878 o 7,502 8,559,123 9 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 66.6% 33.3% Unexpended Balance 1,206,822 2,910,463 153,554 436,146 14,417 272,451 4,993,853 3,142,960 1,287,579 32,700 444,288 17,752 34,863 6,645 27,066 4,993,853 5,002,903 330 -3,878 1,000 -6,502 4,993,853 Completed Remaining Unexpended Percent 41.0 35.4 44.8 36.2 49.1 33.6 36.8 36.6 40.4 26.6 31.1 36.1 30.2 47.5 58.8 36.8 36.9 33.0 -387.8 100.0 -650.2 36.8 09/12/2007 12,20,26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/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 93,308 743,560 o 57,538 9,862 49,106 1,891 3,404 o o Totals 958,669 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 744,797 143,155 2,861 o 42,551 7,757 8,361 2,005 o 7,182 Totals 958,669 SOURCE OF FUNDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 958,669 o Totals 958,669 10 Y-T-D Expended 1,226,378 4,618,384 15,515 349,219 42,255 337,127 16,415 15,303 o 2,582 6,623,178 4,524,531 1,557,035 53,821 473 320,417 36,228 91,281 2,591 111 36,690 6,623,178 6,620,596 2,582 6,623,178 2007 Budget 2,259,288 6,929,243 21,731 544,561 64,500 505,633 37,885 35,748 o 10,473 10,409,062 6,833,619 2,691,797 151,640 473 462,819 43,200 128,039 4,000 4,000 89,475 10,409,062 10,398,589 10,473 1.0,409,062 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 1,032,910 2,310,859 6,216 195,342 22,245 168,506 21,470 20,445 o 7,891 3,785,884 2,309,088 1,134,762 97,819 o 142,402 6,972 36,758 1,409 3,889 52,785 3,785,884 3,777,993 7,891 3,785,884 45.7 33.3 28.6 35.9 34.5 33.3 56.7 57.2 75.3 36.4 33.8 42.2 64.5 30.8 16.1 28.7 35.2 97.2 59.0 36.4 36.3 75.3 36.4 89/12/2007 12:20:26 FRRDBROl SUM031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/31/07 PUBLIC WORKS - ADMINISTRATION Cur Mo Expended PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 123,043 Totals 123,043 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 26,379 14,123 3,771 75,252 1,252 2,138 o 128 Totals 123,043 SOURCE OF FUNDS 001 GENERAL FUND 123,043 Totals 123,043 11 Y-T-D Expended 866,237 866,237 161,837 94,724 15,644 571,630 10,443 11,312 o 647 866,237 866,237 866,237 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 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 393,522 393,522 75,356 40,752 14,451 250,205 8,547 3,163 1,090 -42 393,522 393,522 393,522 31.2 31.2 31.8 30.1 48.0 30.4 45.0 21. 9 100.0 -6.9 31.2 31.2 31.2 09/12/2007 12,20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 08/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 13 STORM EVENT 13,819 118,959 170,880 13,645 o 19,414 3,056 12,576 8,915 15,898 o o Totals 377,162 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 136,335 39,422 103,221 5,129 317 14,622 o o o 78,116 o Totals 377,162 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 306,734 45,615 8,915 15,898 Totals 377,162 12 Y-T-D Expended 94,798 594,361 330,104 522,283 o 114,295 41,502 82,491 56,852 85,386 o o 1,922,072 880,408 264,062 368,292 17,194 2,220 293,877 o o 14,252 81,767 o 1,922,072 1,534,389 245,445 56,852 85,386 1,922,072 2007 Budget 146,860 1,002,815 514,141 445,928 o 178,890 70,548 119,916 123,154 156,448 o 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 66.6% 33.3% Unexpended Balance 52,062 408,454 184,037 -76,355 o 64,595 29,046 37,425 66,302 71,062 o o 836,628 228,172 90,449 327,743 117,450 952 7,116 o 6,365 5,148 53,233 o 836,628 721,539 -22,275 66,302 71,062 836,628 Completed Remaining Unexpended Percent 35.5 40.7 35.8 -17.1 36.1 41.2 31.2 53.8 45.4 30.3 20.6 25.5 47.1 87.2 30.0 2.4 100.0 26.5 39.4 30.3 32.0 -10.0 53.8 45.4 30.3 '09/12/2007 12,20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 08/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 23,615 52,838 97,724 5,447 Totals 179,624 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 83,837 24,952 o 67,466 3,369 o Totals 179,624 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 179,624 o Totals 179,624 13 Y-T-D Expended 142,434 313,278 547,977 57,181 1,060,870 468,768 155,383 456 375,725 47,023 13,515 1,060,870 1,060,870 o 1,060,870 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 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 73,673 230,107 398,812 38,817 741,409 228,394 73,023 3,099 388,566 23,447 24.880 741,409 728,146 13,263 741,409 34.1 42.3 42.1 40.4 41.1 32.8 32.0 87.2 50.8 33.3 64.8 41.1 40.7 100.0 41.1 09/12/2007 12:20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/31/07 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 87,010 41,759 Totals 128,769 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 73,083 20,624 o 12,221 17,103 4,796 o o 942 Totals 128,769 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 105,692 23,077 Totals 128,769 14 Y-T-D Expended 516,786 263,595 780,381 422,201 131,411 1,530 64,339 118,320 22,773 o o 19,807 780,381 650,424 129,957 780,381 2007 Budget 768,027 526,180 1,294,207 622,116 191,927 5,390 156,669 239,000 26,985 530 1,590 50,000 1,294,207 1,010,867 283,340 1,294,207 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 251,241 262,585 513,826 199,915 60,516 3,860 92,330 120,680 4,212 530 1,590 30,193 513,826 360,443 153,383 513,826 32.7 49.9 39.7 32.1 31.5 71.6 58.9 50.5 15.6 100.0 100.0 60.4 39.7 35.7 54.1 39.7 09/12/2007 12:20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/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 131,022 24,267 12,737 77,630 63,901 32,451 35,313 60,609 38,691 7,171 317,898 Totals 801,690 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 216,219 69,171 2,802 456,332 12,746 13,566 13,986 o o 6,547 10,321 o Totals 801,690 SOURCE OF FUNDS 610 WATER AND SEWER FUND 801,690 Totals 801,690 15 Y-T-D Expended 950,913 119,099 56,028 471,042 409,884 199,307 224,605 424,264 247,927 774,566 1,910,266 5,787,901 1,134,678 421,301 16,638 3,083,188 89,980 94,965 109,591 o 4,709 67,968 764,883 o 5,787,901 5,787,901 5,787,901 2007 Budget 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 1,468,391 193,622 102,407 947,524 1,441,252 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 517,478 74,523 46,379 476,482 1,031,368 164,990 131,216 181,827 276,934 1,448,782 1,538,039 5,888,018 648,659 212,655 16,987 2,655,155 112,895 40,699 95,694 o 2,706 733,317 1,369,251 o 5,888,018 5,888,018 5,888,018 35.2 38.5 45.3 50.3 71.6 45.3 36.9 30.0 52.8 65.2 44.6 50.4 36.4 33.5 50.5 46.3 55.6 30.0 46.6 36.5 91. 5 64.2 50.4 50.4 50.4 09/12/2007 12:20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/31/07 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 327,938 14,954 Totals 342,892 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 20,374 6,665 o 306,475 27 5,266 4,085 Totals 342,892 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 342,892 Totals 342,892 16 Y-T-D Expended 2,402,714 86,710 2,489,424 117,106 42,019 o 2,282,455 270 36,862 10,712 2,489,424 2,489,424 2,489,424 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 66.6% 33.3% Unexpended Balance 1,423,124 117,059 1,540,183 113,438 29,427 1,785 1,371,897 320 15,798 7,518 1,540,183 1,540,183 1,540,183 Completed Remaining Unexpended Percent 37.2 57.4 38.2 49.2 41.2 100.0 37.5 54.2 30.0 41.2 38.2 38.2 38.2 -09/12/2007 12,20,26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 08/31/07 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 02 VEHICLE MAINTENANCE PROGRAM 17,132 134,856 Totals 151,988 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 74,319 24,230 o 3,994 68 49,377 o o o Totals 151,988 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 151,988 Totals 151,988 17 Y-T-D Expended 115,306 813,547 928,853 425,775 154,762 280 39,273 707 307,556 o o 500 928,853 928,853 928,853 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 66.6% 33.3% Unexpended Balance 70,477 579,023 649,500 269,766 82,269 1,970 38,878 353 247,814 o 530 7,920 649,500 649,500 649,500 Completed Remaining Unexpended Percent 37.9 41.6 41.2 38.8 34.7 87.6 49.7 33.3 44.6 100.0 94.1 41.2 41.2 41.2 09/12/2007 12:20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 08/31/07 COMMUNITY SERVICE PROGRAMS Cur Mo Expended PROGRAM TOTALS 02 COMMUNITY GROUPS & MISe 03 4TH OF JULY & CIVIC EVENTS,ETC 04 HOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM 6,412 7,014 765 166 Totals 14,357 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 1,695 387 8,557 o 3,718 o Totals 14,357 SOURCE OF FUNDS 001 GENERAL FUND 14,357 Totals 14,357 18 Y-T-D Expended 65,534 87,618 17,444 1,576 172,172 60,462 6,849 89,842 o 15,108 -89 172,172 172,172 172,172 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 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 60,566 49,067 69,734 1,311 180,678 28,188 9,361 119,033 o 14,007 10,089 180,678 180,678 180,678 48.0 35.9 80.0 45.4 51.2 31.8 57.7 57.0 48.1 100.9 51.2 51. 2 51.2 -09/12/2007 12:20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/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 79,465 o 385,003 3,838 197,910 5,149 13,121 Totals 684,486 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 71 BOND PRINCIPAL 72 INTEREST EXPENSE 80 INTERFUND TRANSFERS 19,557 o o o 74,059 13,121 5,585 o 199,967 o 372,197 o Totals 684,486 SOURCE OF FUNDS 050 MOTOR FUEL TAX FUND 510 CAPITAL IMPROVEMENT 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 o 79,465 385,003 197,910 3,838 o 5,149 13,121 Totals 684,486 19 Y-T-D Expended 367,128 o 532,387 9,863 1,712,387 402,296 125,756 3,149,817 166,905 o 86,290 o 105,030 128,256 532.644 43,004 1,693,657 o 394,031 o 3,149,817 1,234,520 367,128 532,387 477,867 9,863 o 402,296 125,756 3,149,817 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 o 42,300 o 8,897,838 1,257,791 1,026,993 2,454,287 2,258,907 244,000 o 1,406,810 249,050 8,897,838 66.6% 33.3% Unexpended Balance 524,865 60,000 1,921,900 234, 13 7 1,879,311 1,004,514 123,294 5,748,021 219,195 o 1,691,710 50,000 202,825 165,794 1,034,166 353,134 2,382,928 o -351,731 o 5,748,021 23,271 659,865 1,921,900 1,781,040 234,137 o 1,004,514 123,294 5,748,021 Completed Remaining Unexpended Percent 58.8 100.0 78.3 96 .0 52.3 71.4 49.5 64.6 56.8 95.1 100.0 65.9 56.4 66.0 89.1 58.5 - 831. 5 64_6 1.9 64.3 78.3 78.8 96 .0 71.4 49.5 64.6 09/12/2007 12:20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/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 Totals EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS Totals SOURCE OF FUNDS 140 SERIES 1987A B&I, PW FACILITY 180 SERIES 2001 B&I, VILLAGE HALL 190 SERIES 2003 B&I, VILLAGE HALL 230 SERIES 2002A B&I, TIF 290 SERIES 1999 B&I, TIF 340 SERIES 1996A B&I, FLOOD 350 SERIES 1998A B&I, FLOOD 360 SERIES 1998C B&I, TIF 380 IEPA FLOOD CONTROL LOANS B&I 390 SERIES 2000 B&I, FLOOD CONTROL 400 SERIES 2002B B&I, FLOOD 430 SERIES 1998A B&I, STREET IMP. 440 SERIES 2002B B&I, STREET IMP. 830 SSA #6 GEORGE/ALBERT B&I Totals 20 Y-T-D Expended o o o o o 712,980 920,088 369,392 o o o 2.002.460 o o o o o o 1,118,302 882,358 1,800 o o 2.002.460 o o o o o o o o o o o o o o 405,000 91,883 216,097 o 915,800 o 1,698 4,288 326,323 41,371 o o o o o 2.002.460 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 916,100 o 67,795 153,575 613,356 727,743 o o o o 4,163,928 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent 972,379 149,587 1,039,502 o o 2,161,468 o 1,755,893 404,375 1,200 o 2,161,468 o 291,882 680,497 o 300 o 66,097 149,287 287,033 686,372 o o o o 2,161,468 57.7 14.0 73.8 51. 9 61.1 31.4 40.0 51.9 76.1 75.9 97.5 97.2 46.8 94.3 51.9 " 09/12/2007 12:20:26 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/31/07 8 Months 4 Months 66.6% 33.3% Completed Remaining Cur Mo Y-T-D 2007 Unexpended Unexpended RETIREE PENSIONS Expended Expended Budget Balance Percent PROGRAM TOTALS 01 MISCELLANEOUS PENSIONS 3,711 29,688 44,533 14,845 33.3 02 POLICE PENSIONS 210,753 1,657,224 2,465,133 807,909 32.8 03 FIRE PENSIONS 223,517 1,783,241 2,627,958 844,717 32.1 Totals 437,981 3,470,153 5,137,624 1,667,471 32.5 EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES Totals 437,981 3,469,334 5,131,324 1,661,990 32.4 0 750 5,800 5.050 87.1 0 69 500 431 86.2 437,981 3,470,153 5,137,624 1,667,471 32.5 SOURCE OF FUNDS 001 GENERAL FUND 3,711 29,688 44,533 14,845 33.3 710 POLICE PENSION FUND 210,753 1,657,224 2,465,133 807,909 32.8 720 FIRE PENSION FUND 223,517 1,783,241 2,627,958 844,717 32.1 Totals 437,981 3,470,153 5,137,624 1,667,471 32.5 21 09/12/2007 12:20:26 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/31/07 8 Months 4 Months 66.6% 33.3% Completed Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 38,135 1,155,211 1,360,353 205,142 15.1 380,562 3,391,567 5,211,598 1,820,031 34.9 418.697 4.546.778 6.571.951 2.025.173 30.8 RISK MANAGEMENT PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 67 OTHER EQUIPMENT Totals 8,551 14,616 34,000 19,384 57.0 410,146 4,532,162 6,532,451 2,000,289 30.6 0 0 5,500 5,500 100.0 418.697 4.546.778 6.571.951 2.025.173 30.8 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 418,697 4,546,778 6,571,951 2,025,173 30.8 Totals 418.697 4.546.778 6.571.951 2.025.173 30.8 22 69/12/2007 12:20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/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 Y-T-D Expended 2007 Budget o o o o o o o o o o o o o o o o 23 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o o o o o 09/12/2007 12:20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/31/07 CAPITAL FIXED ASSETS Cur Mo Expended 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 66.6% 33.3% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o '09/12/2007 12,20:26 FRRDBROl SUM 031 8 Months 4 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 08/31/07 MOUNT PROSPECT LIBRARY Cur Mo Expended Y-T-D Expended Unexpended Balance Unexpended 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 66.6% 33.3% Completed Remaining 8,572,028 100.0 8,572,028 1.00.0 8,572,028 100.0 8,572,028 1.00.0 8,572,028 100.0 8,572,028 1.00.0