Loading...
HomeMy WebLinkAbout3. BILLS AND FINANCIALS 03/20/2007 VILLAGE OF MOUNT PROSPECT CASH POSITION March 01 - 14,2007 Cash & Invstmt Receipts Disbursements Other Cash & Invstmt Balance 03/01/07 Per Attached Credits/ Balance 03/01/07 03/14/07 list of Bills Debits 03/14/07 General Fund 7,333,401 2,269,768 656,101 8,947,068 Special Revenue Funds Refuse Disposal Fund 1 ,762,363 333,822 103,004 1,993,181 Motor Fuel Tax Fund 1,470,853 153,941 50,328 1,574,466 Local Law Enforcement Block Grant Fund 743 743 Community Development Blk Grant Fund 15,656 7,590 110 23,136 Asset Seizure Fund 74,559 74,559 DEA Shared Funds 49,758 49,758 DUI Fine Fund 40,299 40,299 Foreign Fire Tax Board Fund 52,737 52,737 Debt Service Funds 983,550 347,382 600 1,330,332 Capital Proiects Funds Capital Improvement Fund 921,694 57,700 863,994 Downtown Redevelopment Const Fund 1,557,608 144,077 1,701,685 Street Improvement Construction Fund 1,334,872 1,334,872 Flood Control Construction Fund 631,731 631,731 Enterprise Funds Water & Sewer Fund 4,148,643 572,889 344,114 4,377,418 Village Parking System Fund 71,813 4,881 1,823 74,871 Parking System Revenue Fund (9,639) 3,847 5,449 (11,241) Internal Service Funds Vehicle Maintenance Fund 420,891 14 48,428 372,477 Vehicle Replacement Fund 6,350,691 34,100 6,316,591 Computer Replacement Fund 724,254 724,254 Risk Management Fund 2,211,188 120,529 494,894 1,836,823 Trust & AQencv Funds Police Pension Fund 40,153,802 212,221 40,366,023 Fire Pension Fund 40,268,255 195,365 40,463,620 Flexcomp Trust Fund 33,612 10,972 31 ,560 13,024 Escrow Deposit Fund 1,689,529 30,994 21,598 1,698,925 112,292,863 4,408,292 1,849,809 114,851,346 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16 :39 RUN: THURSDAY MAR152007 11:41 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 _ w _ _ ___... _ _... ___ _ _... _ ~ _.................. __... __........................ __...... ___... __...... ___..................... __......... __ __.............................. __............ __...... __ __..................... ____..................... __ __ __... ___......... __ ____ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ............... --............ ---.................. --...... -- -- -- --......... --- --......... --.................. --........................ --_............ --............ --...... --...... --........................... --............... -_............ -- -.................................... --........................ 001 08573 ALAN O.AMOS & ASSOC., P .C. REAL ESTATE TAX VOID 330.00 02796 ALPHA PRIME COMMUNICATIONS REPLACEMENT STANDARD BATTERY 16.00 06338 ALPHA TERRA SCIENCE INC. SAFETY AND HEALTH PROGRAM SERV 1113.75 09544 ANDRES MEDICAL BILLING,LTD AMBULANCE BILLING 677 7.4 5 09179 API FUND FOR PAYROLL EDUCATION, INC. CALCULATING PAYCHECKS 2007 344.00 09189 ARMOR HOLDINGS FORENSICS I INC. ET COVERALLS 89.70 ET SUPPLIES 129.35 ------------- 219.05 02270 AT&T AT & T PHONE SERVICE 0.21 AT & T PHONE SERVICE 0.75 AT & T PHONE SERVICE 0.15 AT & T PHONE SERVICE 0.23 AT & T PHONE SERVI CE LSO AT & T PHONE SERVICE 0.75 AT & T PHONE SERVICE 2.85 AT & T PHONE SERVICE 0.75 AT & T PHONE SERVICE 1.13 AT & T PHONE SERVICE 1.95 AT & T PHONE SERVICE 0.60 AT & T PHONE SERVICE 0.60 AT & T PHONE SERVICE 2.70 AT & T PHONE SERVICE 15.23 AT & T PHONE SERVI CE 14.93 AT & T PHONE SERVICE 9.60 ACCrn 847253-2141 5772 860.19 ACCT#847 253-2141 5772 249.84 ACCT#847 Z97-5414 7966 209.86 ------------- 1373.82 02283 ATLAS BOBCAT INC. RENTAL OF EXCAVATOR 200.00 05044 AVIS RENT A CAR SYSTEM TAC UNIT LEASE-FEB.2007 769.99 10052 BALAS, DANIEL REIlolBURSEllJENT FOR STOP PAYMENT 30.00 06287 BEDCO MECHANICAL BI -MONTHLY HVAC SERVICES 1/07 2132.47 FILTER CHANGE IN GUN RANGE - 460.00 REPAIRS TO l-lAXITROL DISCHARGE 278.85 ------------- 2871.32 09609 BONO,CSR,LTD., KATHLEEN COURT REPORTER 559.50 06064 BRUNSWICK ZONE-MT. PROSPECT MENTOR PROGRAM BOWLING 375.00 09846 BUCKLEY, TERRANCE SNOW PLOWING 2/24/07 6 HRS 120.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152001 11:41 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROl~ MARCH 01 2001 TO MARCH 14 2001 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - ~ - - -- ~ ~ - - --. - -- - - - - - - -- - -- -- - - -- - - - - - - - - - - - -- -- - - - -- -- - - - - - -- - - --- - - - -- - - - -- -- - - - - - - - - - - - - - - - - -- - - - - - - - - - - - _.- - - - - - - -- -- 01014 CADE INDUSTRIES CUSTODIAL SUPPLIES 3044.00 08566 CANNISTRA, JOHN SENIOR RARE OVERPAYMENT 24.00 00303 CASTRO, JOSE REIMBURSEMENT FOR CDL RENEWAL 50.00 SAFETY SHOE PURCHASE REIMBURSE 114.18 ------------- 164.18 09516 CENTRAL LAWN SPRINKLERS, INC. DRAWING & DESIGN SERVICES 4465.00 05315 CENTURY CLEANERS UNIFORM CLEANING-SUPERVISORS 240.45 01091 CINTAS CORP REPLACEMENT GARMENTS - MAINTEN 141.33 10048 CITY OF URBANA CANOPY TREE POSTERS 17. 00 03800 CLARK, SANDRA M. RWlBURSEMENT 120.00 08865 CLOSED CIRCUIT INNOVATIONS, INC. IVACS MAINT. AGREEMENT 427.00 01144 COMMERCIAL LIGHTING SUPPLY 4000 - 50 WHITE LIGHT STRANDS 8000.00 01147 COMMONWEALTH EDISON SPECIAL EVENTS /MELAS ACCOUNT 226.43 MUNICIPAL STREET LIGHTING RATE 12918.52 1330-40 W CENTRAL - MELAS 256.19 ------------- 13461.14 00309 COONEY, WILLIAM J. NATIONAL AMERICAN PLANNING 940.80 INTERNATIONAL CONFERENCE 732.29 ------------- 1673.09 01200 CRAIN'S CHICAGO BUSINESS SUBSCRIPTION 69.00 06992 DEVELOPMENTAL SERVICES CENTER MI SC. TARGETS FOR RANGE 1138.50 05538 DILTZ, TOM SNOW PLOWING 2/24/07 10.5 HRS 210.00 06343 EDDINGTON, RI CHARD REIMBURSE EXPENSES 52.26 09464 EDWARDS MEDICAL SUPPLY INC. ~IEDICAL SUPPLIES 38.15 ~IEDICAL SUPPLIES 6.15 ~IEDICAL SUPPLIES 408.64 --- - ---- - - --- 452.94 05843 ENH OMEGA PRE-EMPLOYMENT TESTING 66.00 09653 ETERNO I DAVID G. HEARING SERVICES 281.25 01366 EXPERIAN PRE - EMPLOYMENT BACKGROUND CHEC 91.34 01377 FEDERAL EXPRESS CORP DELIVERY TO KT J 13 .63 06311 FEDERAL SIGNAL-EMERG.PROD. MS100 SPEAKER W/O BRACKET 123.55 ~EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152007 11:41 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 . -- ~ - -. - - - - -- - -.. - - - - - - -- -- -- - - - - - - - -- -- - - - - - - - - -.- -- - -- -- - - - - - -- -- - - - - - - --- - - -- - --- - - - - - - - - - - --- - - - - -- - - - - -- -- - - - -- - - - - - - - - - - - - --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT . - - - - -- - - - - - - - - - - - - - - - --- - - --- -- - -- - -- - - - - - - -- -- - - - - - - - -- - -- - -- - -- - -- - -- - - - - - -- - - - -- - - - - - -- - - - - - -- - - - -- - - - - -- -- -- - - - - - - - - - -- - - - -- -- MS100 SPEAKER W/O BRACKET 123.55 ------------- 247.10 09487 FELLOW I MI CHAEL REIMBURSElf,ENT FOR THE PURCHASE 100.23 00331 FIGOLAH, MICHAEL REIMBURSEMENT 144.12 00102 FIRE PENSION FUND PAYROLL FOR - 030107 22973.91 01414 FLINK COMPANY FLINK HINGE BOLT 146.39 04537 GALETON GLOVES 25 DOZEN - 90Z BROWN JERSEY GL 123.70 09198 GE CAPITOL ID U90133712112 TOSHIBA LEASE 109.50 ID U90133712112 TOSHIBA LEASE 109.50 ID U90133712112 TOSHIBA LEASE 109.50 ------------- 328.50 01522 GRAINGER INC. 4 - 32G68 50# LAUNDRY DETERGEN 167 .96 1 - 480 V UNIT HEATER 561.00 1 - 3- 10 KW MOUNTING BRACKET 56.99 SHIPPING 10.63 ------------- 796.58 06420 GRAYBAR ELECTRIC CO. 700 - STR-GRN-2500R GENERIC WI 828.99 REPLACEMIINT WALL SPIIAKER - PAG 43.68 PAGE SYSTEM SPEAKIIR 43.68 ------------. 916.35 00342 GUENTHIIR, JAMIIS E. CLOTHING ALLOWANCE 169.96 09113 HE:ALY ASPHALT COMPANY, LLC. PATCHING MATERIALS 565.25 01578 HE:NDRICKSEN, ROBIIRT W. WINTER TREE TRIMMING PIIR - PIIR 6869.00 01589 HHI INC. RANGE PRIIVIINTATIVII MAINT. 254.00 01645 IAFSM ANNUAL MEMBERSHIP - CHUCK LIND 20.00 00106 ICMA RETIRIIMENT TRUST - 401 PAYROLL FOR - 030107 850.00 EDDINGTON-401K 408.49 ------------- 1258.49 00107 ICMA RETIREMIINT TRUST - 457 PAYROLL FOR - 030107 19014.95 01689 I GFOA DUES & MIIMBIIRSHIPS 260.00 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 030107 24900.39 01676 ILLINOIS DIVISION OF LA.L IAI CONFERIINCE 4/12-13/07 120.00 01708 ILLINOIS SAFETY COUNCIL ANNUAL MEMBERSHIP DUES 125.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152007 11:41 RELEASE ID : VILLAGE OF l~OUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION - ~ - - - - - ~ - - - - -- - ~ - - - - - -.- - - --- - - - - -- - - ~ - -- - - - - - - -- - - - - - - - - - - - -- -- -- - -- - -- - -- - - -- - -- - - - - - - - - - - - - - - - - - - - - - - - --- - - -- - - - -- -- -- - - - -- -- - -- AMOUNT 01122 ILLINOIS STATE DISBURSEMENT UNIT PAYROLL FOR - 030107 PAYROLL FOR - 030107 PAYROLL FOR - 030107 PAYROLL FOR - 030107 07433 lMAGETEC LP SERVICE/MAINTENANCE AGREEMENT IDU90133759828 ID U90133770128 IDU90133770131 IDU90133770126 MONTHLY LEASE PAYMENT FOR TOSH ID U90133643910 LEASE PMT COPIER LEASE PAYMENT FOR FEB-D 09397 HIL INC. ADAPTER CABLE FOR BOSCH DRILL 09562 PAYROLL FOR - 030107 PAYROLL FOR - 030107 PAYROLL FOR - 030107 IMRF 01744 INTERNATIONAL COUNCIL OF SHOPING CENTERS MEMBERSHIP DUES 09832 INTERNATIONAL UNION OF OPERATING ENGINEERS PAYROLL FOR - 030107 PAYROLL FOR - 030107 09563 IRS PAYROLL FOR - 030107 01747 ISA CERTIFICATION FEE FOR DAVID HU 00353 JANONIS, MI CHAEL E. LUNCH MEETING 02408 JOHN E. REID AND ASSOCIATES PRE - EMPLOYMENT TESTING 01794 KALE UNIFOR1~S, INC. UNIFORM SUPPLIES 01818 KERSTEIN, JUNE BLOOD DRIVE REIMBURSEMENT 04802 KING KONCRETE, INC. CONTRACTUAL SNOW REMOVAL 2/14 01849 KUSTOM SIGNALS, mc. EQUIPMENT REPAIR 01861 LANDS' END BUSINESS OUTFITTERS THERMACK CAPS WITH LOGO SET - UP 09918 LAUBE CONSULTING GROUP LLC FINANCIAL ADVISORY WORK 01880 LEARNKEY I INC. NetworkExpert annual fee (Comp 08631 LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEANI PAGE 800.00 116.31 520.75 1169.24 2606.30 474.00 356 .00 356.00 390.00 275.00 236.00 320 .35 586.13 2993.48 145.00 334.16 41016.98 19531.83 60882.97 100.00 779.22 242.55 1021. 77 204897 .06 45.00 87.45 175.00 158.35 48.70 24785.00 396.31 52.45 957.00 2500.00 228 .27 \EPORT: APBOARDRPT GENERATED: 09 AUG 06 16;39 RUN: THURSDAY MAR152007 11:41 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO ~lARCH 14 2007 PAGE DEPT INVOICE DESCRIPTION .. - - - -~- - - - - -. - - -- - - -- -- - - - -- - -- - -- - - - - - - - - - - - - - -- - - - -- -- - - -. -- - --- -- - - - -- - - - - - - - - - - - - -- -- - - - - -- --- - - - --- - - - - - - - - - - - - - - - - - - - - - - - - -- AMOUNT VENDOR NBR VENDOR NAME . - - - - - - - - - - -- -- - - --- - - - -- - -- - - - - - - - - - - -- - - - - -- -- -- - - - - -- - - ----- - - -- - - -- - - - - - - - - - - - - - - - - -- - -- - - - - - - -- --- -- - -- - - -- - - -- - - - -- - - - - - - - - -- 05744 LICARI, NICK CLOTHING ALLOWANCE 05521 LORMAN EDUCATION SERVICES REGISTER T .JANOWICK 01922 LYNN PEAVEY COMPANY ET EQUIPMENT 06641 MANZO I S BANQUETS FOOD FOR PROMOTI ON RECEPTION 01965 MARTAl" CONSTRUCTION CONTRACTUAL HAULING CONTRACTUAL HAULING 09848 MATSUI, ALVIN SNOW PLOWING 2/24/07 llHRS 08348 ME I STER I JACQUE SNOW PLOWING 2/24/07 12 HRS 05021 MENARDS MISC. SUPPLIES AND HARDWARE 00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 030107 ARBOR GREEN FOR 2006 CONTRACT 00117 METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - 030107 08783 METROPOLITAN MAYORS CAUCUS MAYORS MEMBERSHIP 02046 MOBILE PRINT INC. PRINTING OF MATERIALS BUS INESS CARDS BUSINESS CARDS MEMO PADS FOR VJAYOR WILKS BUSINESS CARDS F. SIWAK 08566 MOUNT PROSPECT VACATIONS REFUND 02085 MUNICIPAL CLERKS ASSOCIATION DINNER MEETING 3/15/07 02098 llliRRAY AND TRETTEL INC. 2007 - STORM WARNING SERVICE 08566 MUSCIA, JACK REFUND 10047 NATIONAL ASSOCIATION OF BOARDS OF PHARMACY OVERPAYMENT 00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 030107 02148 NEOPOST INC. POSTAGE LABELS MONEY ENTERED INTO POSTAGE MAC 02155 NEXTEL COMMUNICATIONS ACCTU57600518 ACCTU57600518 ACCT#157600518 150.00 329.00 213.00 270.00 637.50 291.40 928 . 90 220.00 240.00 98.84 2240.00 26158.38 28398.38 687.50 1981.88 606.44 27 .00 25.36 27.65 26.18 712.63 36.00 30.00 1100.00 12.00 350 .00 1613 7.04 61.90 3000.00 3061.90 683 .48 159.79 164.00 REPORT: APBOARDRPT DEPT VENDOR NBR 01718 02170 09168 02189 02193 02196 02199 05124 09786 08566 07039 10003 02256 GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152007 11:41 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 VENDOR NAME NORTH AMERICAN SALT CO~lPANY NORTH EAST MULTI REGIONAL TRNG NORTHCENTER CAMERA NORTHWEST CENTRAL DISPATCH SYS NORTHI'IEST ELECTRICAL SUPPLY NORTHWEST MUNI CI PAL CONFERENCE NORTHWEST STATIONERS INC. NORTHl'IESTERN UNIVERSITY NUMARA SOFTWARE I INC. o I BOYLE I THOMAS O.C.TANNER RECOGNITION CO. OFFICETEAM PADDOCK PUBLICATIONS INVOICE DESCRIPTION ACCT#157600518 ACCT#157600518 ACCT#157600518 ACCT#157600518 ACCT#157600518 ACCT#157600518 ACCT#1S7600518 ACCT#157600518 ACCT#157600518 700.46 TON OF ROAD SALT DELIVE REGISTRATION FILr~ PROCESSING/CMIERA FLASH FILM PROCESSING & CAMERA FLASH MEMBER ASSESSMENT APRIL 2007 MEMBER ASSESSMENT APRIL 2007 ELECTRICAL SUPPLIES FOR 2/07 ELECTRICAL SUPPLIES FOR 2/07 SEMINARS- FIERRO, BROWN, ROELS I PE SEMINARATTENDED BY D. JAROSZ COFFEE SUPPLIES OFFICE SUPPLIES REGISTRATION D. OKON FOOTPRINTS AGENT LI CENSE PRO- RATED MAINTENANCE FOR ADD I REFUND CAR SOLD R.CLINGER RETIREMENT GIFT TEMPORARY EMPLOYEES HELP WANTED ADVERTISING PERMIT CLERK PAGE AMOUNT 659.18 1252.33 120.00 145.75 328.92 27.59 350.17 211.98 208.88 4312.07 13000.00 365.00 324.65 324.64 649.29 42402.65 10600.66 53003.31 600.03 163.90 763.93 300.00 85.00 385.00 50.59 94.25 144.84 1000.00 1055.00 197.81 1252.81 36.00 163.05 1362.00 2494.00 638.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152oo7 11:41 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 PAGE DEPT VENDOR NBR INVOICE DESCRIPTION ~ - - - - - - - - - - - - - - - - - -.. - -- - - -- - - - - -- - - - - -- - - -. - - - - - - - - - - - - -- - -- - - - - - - - - - - - - - - - - - - - - -- - - -- - - - - - -- - - - - - -- -- - -- -- - - - - - --- - -- - - --- - - -- - -- AMOUNT VENDOR NAl~E - - - - - - - - - - - -- - - - - - - - - - -- -- - ----- - - - - - - -- - - -- - - - - - -- - - - - - - - - - -- -- - - - - - - - -- -- -- - - - - - - -- - - - - -- - - - - - -- - - - -- -- - - - -- - - - - - - -- - - - - -- -- - - - -- 02256 PADDOCK PUBLICATIONS I INC. NOTICE OF PUBLI C HEARING 07689 PETTY CASH-HUMAN SERVICES REn~URSEMENT REIMBURSEMENT REIMBURSEMENT REIMBURSEMENT REIMBURSEMENT REIMBURSEMENT REIMBURSEMENT 00124 POLICE PENSION FUND PAYROLL FOR - 030107 06041 POPE, BRANDEN SNOW PLOWING 2/24/07 12HRS 04921 POPE, ELIZABETH A. PAYROLL FOR - 030107 08509 PROPERTY INSIGHT TRACT SEARCH 08711 QUALITY ~lAINTENANCE SYSTEMS, INC. 2007 CONTRACT FOR CUSTODIAL SE 02379 QUILL CORPORATION lHSC. OFFI CE SUPPLIES MISC. OFFI CE SUPPLIES 10022 R. A. DAUGHERTY SALES I INC. REPAIR OF BOOSTER PUMP AT VILL 00418 ROSCOP, WILLIAM REIMBURSE EXPENSES 07529 SCHAMBACH SOFTWARE SOLUTIONS, INC. CONSULTING SERVICES 02542 SHEPP PEST CONTROL MONTHLY PEST CONTROL SERVICES 04139 STANARD & ASSOCIATES PRE- EMPLOYMENT TESTING 09165 STAPLES BUSINESS ADVANTAGE SUPPLIES FLASH DRIVES FOR VIDEO RECORDI 09509 STECK MFG. CO. 4 SETS OF LOCK OUT TOOLS 02627 STEINER ELECTRIC CO. 18/6 SHIELDED CABLE 02627 STEINER ELECTRI C COMPANY DURALlNE UNDERGROUND CONDUIT BALLAST #LUM MHKT-250-CWA-MT- 3 WHITE GLOBE #llUB- K07 -17" 00441 STRAHL , DAVID LUNCH MEETING 02652 SUBURBAN BUILDING OFFI eIALS CO PLAN REVIEW T. LEWIN 3132.00 75.00 15.87 12,91 5.70 7.99 20.00 22.45 7.35 92.27 25047.78 240.00 923.08 60.00 8276.8 5 60.96 385.91 446.87 1294.00 26.93 572 8.75 425.00 1125.00 207.11 175.00 382 .11 239.80 379.86 394.90 101.28 78.34 574.52 30.28 95.00 REPORT: APBOARDRPT DEPT VENDOR NBR 09915 09668 04209 02691 05686 08821 GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152001 11:41 RELEASE ID : VILLAGE OF I~OUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO ~lARCH 14 2007 VENDOR NAME INVOICE DESCRIPTION SUPER WA.ltEHOUSE REPLACEMENT INK CARTRIDGES AND T ,P.r. PLUMBING INSPECTION TAPCO 2 ROLLS - 15" X 50 YARDS 1177 FREIGHT 12 I 2# GREEN RIB BACK U CHANNE ESTIMATED FREIGHT THO~lPSON ELEVATOR INSPECTIONS ARCHITECTUAL ELEVATOR PLAN ULINE INC. CD- RS FOR PHOTOS UNI FORMITY INCORPORATED UNIFORM SUPPLIES UNIFORM EXPENSES 02747 UNISOURCE GREAT LAKES 40 CARTONS WHITE COpy PAPER 02756 UNITED STATES POSTAL SERVICE VEHICLE MAILING POSTAGE 00127 UNITED WAY PAYROLL FOR - 030107 07291 UNIVERSITY OF ILLINOIS SUBSCRIPTION RENEWAL - HOME, Y 07860 UPS MISC. SHIPPING CHARGES 02794 VFW POST 133 7 MEMORIAL DAY PARADE 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 030107 101 S. I~PLE ST. SERVICE 04314 04381 02883 05746 00464 030 02270 02155 09635 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES PAYROLL FOR - 030107 WELCH, JOHN SNOW PLOWING 2/24/07 6 HRS WIPECO INC RECYCLED POLO RAGS WI SCTF PAYROLL FOR - 030107 WULBECKER, JEFFREY CLOTHING ALLOWANCE TOTAL 656100.82 80.41 AT&T AT & T PHONE SERVI CE NEXTEL COMMUNI CAT! ONS ACCT#157600s18 WELLS FARGO BANK TIPPING FEES FIXED COSTS PAGE AMOUNT 116.00 40.00 580,00 13 .01 1225.00 113.75 1931.76 75.00 65.22 613.70 6000.00 6613.70 1087.80 6905.63 348.85 20.00 15.88 1000.00 23951.48 10.68 23962.16 2385.44 120.00 69.00 542.48 0.30 91. 90 96389.35 6522.05 IEPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152007 11:41 RELEASE In : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 PAGE DEPT VENDOR NBR - - - - - ~ -- - -. -- -......... --- -- -- - -... - -............................. -- -- --...... -- -- -- --... --- --......... --............ -... --- --......... --... --...... ---......... -_... --......... --... -- -- --...... -_... --...... --............ - -_......... AMOUNT VENDOR NAME INVOICE DESCRIPTION .......... --............... --......... --...... --...... -- -- --......... -- ----............ --...... -- ----............ -- -- ----... --...... -_...... --......... ---... --........................ -- ---......... -- --... -- -- ---............... --... ----......... --... 150 01147 05709 01718 )70 09198 190 09852 190 09852 jl0 09218 09812 jl0 01699 02270 02451 TOTAL 103003.60 102911.40 COMMONWEALTH EDISON STREET LIGHT ING RATE 25 MEADE ELECTRIC CO. INC. 2007 TRAFFIC SIGNAL MAINTENANC NORTH AMERICAN SALT COMPANY 700.46 TON OF ROAD SALT DELIVE 369.36 TONS OF ROAD SALT DELIV 155.15 TON OF ROAD SALT DELIVE 7620.88 1000.00 18282.55 16495.61 6929.44 TOTAL 50328.48 41707.60 GE CAPITOL ID >>90133712112 TOSHIBA LEASE TOTAL 109.50 109.50 BANK OF NEW YORK BANK FEES TOTAL 300.00 300.00 BANK OF NEW YORK BANK FEES TOTAL 300.00 300.00 KLOA, INC. TRAFFIC ENGINEERING SERVICES l~ORROW BROTHERS FORD 1 INC. 2007 FORD F350 TOTAL 57700.30 20815.00 AMERICAN PUBLIC WORKS ASSOC. REGISTRATION FEE FOR vlEBINAR AT&T AT & T PHONE SERVICE ACCT#847 253-0198 1389 ACCT# 847 253-9377 0708 BADGER METER INC 10 - R70 I" WATER METERS WITH 2 - 1.5" M120 WATER METERS WIT 1 - 2" R170 TRANSMITTER REGIST 50 - I" RUBBER WASHERS 2 - BATTERY PACKS 4 - R170 2 n TRACE REGISTERS 2 - 2" COMPOUND WATER METERS W FREIGHT 36885.30 150.00 20.02 1429.41 277.77 1727 .20 1559.83 518.56 103.84 730.58 272.00 626.68 2696.20 39.58 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152007 11: 41 RELEASE ID : PAGE 10 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 - ~ ~ - - - - --. - - - - - - - - - - - - - - - - -- - - - - - -.- - - - - -- - - -- - - -- - -- - - - - - - - - - - - - - - - - - -- - - - - -- - - - - - - - - - - - -- - -- -- - - - - - - - - - - - - - -- - - - - - - - --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AI,IOUNT - - - - - - - - - - - -- - - - -- - - - - -- - - - - - - - - - - - - - - - - - - -- - - -- -- -- -- - -_.- - - - - -- - - - - - - - - - - - -- - --- - - - - -- - -- - -- - - -- - - -- - - - - - -- - - - - - - -- - - - - -- - - - - - - -- 20 - R70 1" WATER MATER WITH T 3105.05 5 - SEAL PRESS 429.35 2 - 2" COMPOUND WATER METERS 2709.94 24 - 1" RCDL MODEL 40 WATER ME 2170.62 24 - 1" RCDL 70 WATER METERS 2595.18 MODEL #25 5/8" WATER MATERS WI 13820.00 --- ------ ---- 31377 .41 09852 BANK OF NEW YORK WATER 142231.00 POWER 5277.00 o & M 27907.00 FIXED 81274 .00 ------------- 256689.00 08567 BERMUDEZ, MI CHAEL REFUND FINAL BILL 5.68 06476 BURNS & MCDONNELL ENGINEERING DISINFECTION BIPRODUCT 20221.60 05375 CENTURY CLEANERS UNIFORM CLEANING-SUPERVISORS 240.45 08567 COLDWELL BANKER REFUND FINAL BILL 17.04 04543 CORPORATE EXPRESS MISC. OFFICE SUPPLIES 124.42 08319 CRESCENT ELECTRIC SUPPLY CO HEATHER 68.52 01211 CUES I INC. EMERGENCY REPAIRS TO SEWER 1840.03 08567 DAD PROPERTIES REFUND FINAL BILL 50.61 08567 FORBES, JAMES R. REFUND FINAL BILL 17.04 04537 GALETON GLOVES 25 DOZEN - 90Z BROWN JERSEY GL 123.70 09883 HD WATERWORKS I LTD. 14 - 6 X 10 REPAIR CLAMPS 1176.00 07433 IMAGETEC LP MONTHLY LEASE PAyt.lENT FOR TOSH 236.00 01791 K - PLUS ENVIRONMENTAL, INC. PROFESSIONAL SERVICES L. U. S. T . 15175.00 08567 LARSEN, ilAYNE REFUND FINAL BILL 28.40 08631 LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEANI 228.27 06403 LINDCO EQUIPMENT SALES J INC. SNOW PLOW CUTTING EDGE 358.20 01965 MARTAM CONSTRUCTION CONTRACTUAL HAULING 2103.75 CONTRACTUAL HAULING 1384.26 - - _.--- -- - --- 3488.01 08567 MEIER, JASON REFUND FINAL BILL 16.82 05021 MENARDS MISC. SUPPLIES AND HARDWARE 191.95 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152007 11:41 RELEASE ID : PAGE 11 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 - - - - -. - - - - - - -- - - - - -- -- - - - - - - - -- - - - - - - - --- - - - - -- -- - - - - - - - - - - --- - -- - - - - - -- -- - - - - -- -- -- - - - - - - -- - - - -- - -- - -- - -- -- - - - -- - - - - - - -- - - - --- - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - -. - - - - -- - - - -- - -- - - -- - - - - - - - -- - - - - - - -- - - - - - - - - - - - - -- - - - - - - -- -- -- - - -- - -- - - - -- - -- - - -- - - - - - - - -- - - - - -- -- - - - - - - - - - - - -- - - - - - - - -- ---- 02155 NEXTEL COMMUNICATIONS ACCTm7600518 33.93 ACCT#157600518 517.36 ---. - --- ----- 551.79 02162 NI COR 117 N WAVERLY - ACCOUNT 169.03 SERVI CE 993.26 ------------- 1162.29 02193 NORTHWEST ELECTRI CAL SUPPLY ELECTRICAL SUPPLIES FOR 2/07 228.38 03567 OWL ENTERPRISES INC. REFUND FINAL BILL 10.73 03567 PAPIERNIAK, DAN REFUND FINAL BILL 6.60 04417 QUALITY BLACKTOP INC. RETAINER-ASPHALT RESTORATION 2402.00 RETAINER-ASPHALT RESTORATION 2401. 99 ------.------ 4803.99 02660 SUBURBAN PRINTING 1,000 RED TAG "SHUT OFF" NOTIC 152.00 03567 SUBWAY REFUND FINAL BILL 73.34 02756 UNITED STATES POSTAL SERVICE WATER BILLING POSTAGE 1789.31 WATER BILLING POSTAGE 397.49 ------------- 2686.30 03567 VODENICHAROV, SIMEON REFUND FINAL BILL 131.90 03887 WATERISAC 2007 SUBSCRIPTION FEE 300.00 08567 WHEATLAND TITLE GUARANTY REFUND FINAL BILL 107.92 08567 WILLIAMSON, MATT REFUND FINAL BILL 9.37 02883 WIPECO INC RECYCLED POLO RAGS 223.00 RECYCLED POLO RAGS 108.00 - ---_. ------- 336.00 TOTAL 344113.96 620 03711 QUALITY MAINTENANCE SYSTEMS, INC. 2007 CONTRACT FOR CUSTODIAL SE 1322.36 TOTAL 1822.86 630 01147 COMMONWEALTH ED I SON 13 E NORTHWEST HIGHWAY #447577 11 E NORTHWEST HIGHWAY ACCOUNT 13 E NORTHWEST HIGHWAY #447577 11 E NORTHWEST HIGHWAY #447576 188.61 250.38 55.48 317.27 811. 74 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152007 11:41 PAGE 12 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 - - - - -. - - ~ - - - - - - - ~ -- - - -_. - - -- - - ~ - - - - --- -- - -- - - - - - - - - _.- -- -- - - - - - - - - - - - - - - - - -- - - - - - -- -- -- - - - - - -- - - - - - - - - - - - - - - - - - -- -- - -- - - - - - - - - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - -- - - - - - - - - -- - - - - -- - - - - - - - - - -- - - - - - - - - - -- -- -- - - - - - - -.- - - - - - - - - - - - - - - -- - - -- - - - - - - - -- - - - - -- - -- - - - - - - _.- -- - - - - - - - - - - - - - - - -- - - -- - - - -- -- 02162 NICOR 11 E NORTHWEST HI GHWAY ACCOUNT 421.98 SERVICE 773 .40 -------- - -_.- 1195.38 09990 PARKEON FREIGHT 6.33 500 PARKING DEBIT CARDS WITH 1150.00 ------------- 1156.33 08711 QUALITY MAINTENANCE SYSTEMS, INC. 2007 CONTRACT FOR CUSTODIAL SE 296.96 02754 UNION PACIFIC RAILROAD LAND LEASE FOR FEB.2007 1949.12 02806 VILLAGE OF MOUNT PROSPECT 19 E. NORTHWEST HIGHWAY SERVIC 39.08 TOTAL 5448.61 660 01187 AETNA TRUCK PARTS GATES CUMMINS WATER PUMP 113.66 02796 ALPHA PRIME COMMUNICATIONS REPAIR MOTOROLA 2-WAY MOBILE 118.50 09676 AMERICAN MESSAGING PAGER MESSAGING SERVICE 75.42 02270 AT&T AT & T PHONE SERVICE 0.75 02541 BARSON CHEM I CAL CO. OIL SPILL CLEAN-UP 282.50 06468 BP GASOLINE 61.02 03958 CHICAGO INTERNATIONAL TRUCK INTERNATIONAL COOLING FAN 173.70 09166 CYLINDERS I INC. 2 SINGLE ACTING SNOW PLOW LIFT 194.50 01276 DIRTBUSTERS AUTO DETAILING, INC. COMPLETE INTERIOR & EXTERIOR 160.00 08600 DOALL COMPANY DOALL WELDED BAND SAW BLADE 668.88 05579 ELMHURST LINCOLN MERCURY VICTORIA ENGINE BLOCK HEATER 31.70 08705 GENUINE PARTS C01~PANY-NAPA AUTOMOTIVE REPAIR PARTS 415.75 01750 INTERSTATE BATTERY MHO INTERSTATE BATTERY 381.75 01872 LATTOF ARLINGTON HEIGHTS PARTS & SERVICE FEB.2007 535.60 06470 L mCR AUTO GROUP - FORD FRONT LICENSE PLATE BRACKET 22.18 02018 MIDWAY TRUCK PARTS REBUILT WATER PUMP 182.36 INTERNATIONAL FAN CLUTCH 630.46 -_. ----- ----- 812.82 02058 MORTON GROVE AUTOMOTIVE NEW REPLACEMENT OR REBUILT STA 110.00 EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152007 11: 41 RELEASE ID : PAGE 13 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 - - ~ - - -- - - - - -- - - - ~ - - - - - - - - - -- - - -- - - - - - - - - - - - -- - -- - - - - - - -- -- - - - - - -- - - - - - - -- -- -- - - - - -- -- - --- - - - --. - --- -- - - - - - - - - - - -- - - - - - - -- -- - -- -- -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AIolOUNT -. - -- - - - - - -- -- - - -- - - - - - - - - --. - - - - - - - - - - - - - - - - - - -- - - -- - - - -- - - -- - - -- - - - - - - - -- - ---- - -- -- -- - - - - -- - - - -- - - - - - - -.- - - - -- - - -- - -- -- --- - - - --- 02155 NEXTEL COM/olUNICATIONS ACCT#157600518 273 . 82 02250 OVERHEAD MATERIAL HANDLING IL. I INC. ANNUAL OVERHEAD CRANE INSPECTI 555.20 07663 PRAIRIE INTERNATIONAL TRUCK SALES AIR HORN KIT/COOLING FAN DRIVE 440.51 INTERNATIONAL TRUCK REPAIR PAR 1203.52 ------ ------- 1644.03 02581 SOLVENT SYSTEMS INT I L. INC. PARTS WASHER RENTAL AND SERVI C 100.83 02610 STANDARD EQUIPIolENT COMPANY TRACKLESS THROTTLE CABLE 540.22 ELGIN SWEEPER PARTS 3421.63 ------------- 3961.85 04472 TEXOR PETROLEUM CO 7000 GALLONS PREMIUM FUEL 17119.80 8001 87 UNLEADED GASOLINE 17726.85 -- ----- --- --- 34846.65 04813 UNITED RENTALS HIGHWAY TECHNOLOGIES BEMIS 2200SE APF CONTROL 815.60 02791 VEHICLE MAINTENANCE PROGRAM INC. WAGNER LIGHT BULBS AND FLASHER 539.20 PHILLIPS BULB 71.70 -- - --- -- ----- 610.90 02861 WEST SIDE TRACTOR SALES 1'169117/118/119/9224/9225 952.73 ROCKER COVER O-RING 72 .00 --._-- -- - ---- 1024.73 02883 WI PECO INC RECYCLED POLO RAGS 436.00 TOTAL 48428.34 70 01982 MCCANN INDUSTRIES, INC 2007 TO\'INMASTER MODEL TRAILER 18685.00 02610 STANDARD EQUI P!~ENT COMPANY TARCO TTL-1 VACUUM LEAF MACHIN 15415.00 TOTAL 34100.00 90 09867 BIOMECHANICS CONSULTING, INC. LEGAL-SPECIAL COUNSEL 6000.00 08109 CAMBRIDGE INTEGRATED SERVICE W/C REIMBURSEMENT 13671.17 W/C REIMBURSEMENT 9758.96 CLAIMS ADMIN.-CREDIT 0171148 726.00 ------------- 24156.13 10051 CCMSI 1'1/ C REIMBURSEMENT 50000.00 01102 GAB ROBINS N .A., INC - CITIBANK INSURANCE CLAI MS - GAB 1569.42 INSURANCE CLAI MS - GAB 3929.50 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152007 11: 41 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 PAGE 14 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION - - - - --- - - p - -- - -- - -- - - -- - - - -- - - - -- -- - - - - - - - - - - - - - - - - - -- -- - - - --- - - - - - - - -- -- - -- - - - - - -- - - - - - - - - - - --.- - - - - - - - - - - - - - -- - - - - - - - - - - - - -- - - - -- AMOUNT - - - - - - -. -. - - - -- - - - - - - - - - - - - _.- -- - -- - - - - - - - - - - - - - - - - - - - - - - - - - -- -- - -- - - - - - - - - - - - - - --- -- --- -- - - - - - - - - -- - - -- - -- - - - - - - - -- - - - - -- - - -- 01737 INTERGOVERNMENTAL PER. BEN. COOP INSURANCE FOR MARCH 2007 INSURANCE FOR MARCH 2007 INSURANCE FOR MARCH 2007 INSURANCE FOR MARCH 2007 06470 LYNCH AUTO GROUP - FORD FRONT LICENSE PLATE BRACKET 02193 NORTHWEST ELECTRICAL SUPPLY ELECTRICAL SUPPLIES FOR 2/07 TOTAL 770 00301 ADAMCZYK, TED D. 00372 ANDLER, GLEN 04551 BUFFALO, PHILLIP 00477 BURES, PAUL 03761 BURGER, DONALD L. 01001 BURRELL, STEVE 01094 CHRISTENSEN, RICHARD 00321 DRAFFONE, RICHARD 04840 EVANS, MARGARET 01381 FELSKI I ARTHUR VI. 00330 FELTEN, BARBARA 05093 GRAND GEORGE , ARRON 08178 GUARDIAN 00342 GUENTHER, JAMES E. 00345 HANNEMAN, LESTER A. 01560 HANSEN, DONALD E. 08928 HERMANN, JAMES 01625 HUEMANN I ANTHONY 01722 INGEBRIGTSEN, JAMES 10020 JAROG, LYNN FLEX COMP FLEX COMP FLEX COMP FLEX COMP FLEX COMP FLEX COMP FLEX COMP FLEX COMP FLEX COMP FLEX COMP FLEX COMP FLEX COMP EMPLOYER DENTAL PLAN. MARCH 07 FLEX COMP FLEX COMP FLEX COMP FLEX COMP FLEX COMP FLEX COMP FLEX COMP 5498.92 36777.28 119126.90 2162.99 250189.71 408256.88 22.18 960.00 494894.11 456.23 714.00 2750.00 874.59 780.94 1200.00 385.18 1037.16 22.60 300.00 102.00 65.00 5898.04 654.00 89.90 500.00 212.30 564.31 4194.00 416 .66 {EPORT: APBOARDRPT GENERATED: 09 AOG 06 16:39 RUN: THURSDAY MAR152007 11:41 RELEASE ID : PAGE 15 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 - - - - - - - - -.... -............. -_.... -_........ ---...... -_............ --...... --............................ --- --...... -- -- -- -- ----- --........ --.... -- --.......... -- ---- -_...... --.... -- -- ---- ---.. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -.................... --.... ---.......... -_.... --........-.......... --........ -_.... --...... --............ ---.... --.. --.................... --.... --.. --.................... --...... --.............. ---.. ---...... --....-- 01781 JONES, DANIEL G. FLEX COMP 73.17 05656 KANUPKE, JOSEPH FLEX COMP 200.00 07611 LAMBEL, BRIAN FLEX COMP 694.45 01902 LIVINGSTON, CHARLES E. FLEX COMP 528.20 09238 LYONS, PATRICK FLEX CaMP 2500.00 04350 MEISTER, MICHAEL FLEX COMP 500.00 02033 MILLER, DAVID L. FLEX COMP 370.22 02034 MILLER, JAMES FLEX COMP 35.13 06040 REDLIN, RON FLEX CaMP 700.00 02450 ROELS, ROBERT J. FLEX CaMP 522.50 02473 RUMORE, CINDY JO FLEX CaMP 970.89 09896 SCHMITZ, JEFFREY FLEX CaMP 45.00 09530 SCHNITTKER, JOHN FLEX CaMP 299.42 09778 SCHRAEDER, TRI CIA FLEX CaMP 62.33 02508 SCHULTZ, WALTER FLEX CaMP 18.00 09058 SELEEN, WENDY FLEX CaMP 938 .84 00429 SEMKIU, mCHAEL J. FLEX COMP 46.20 02631 STEPHENSON, MICHAEL R. FLEX CaMP 195.40 02644 STRAHL, DAVID FLEX COMP 1058.05 02710 TRACY, RI CHARD L. FLEX COMP 400.00 02872 WIDMER, CAROL L. FLEX CaMP 185.00 TOTAL 31559.71 90 01719 NCPERS GROUP LIFE PREMIUM FOR MONTH OF I~CH 07 668.00 02689 THIRD DISTRICT CIRCUIT COURT BOND MONEY 1025.00 BOND MONEY 3680.00 BOND MONEY 2550.00 BOND MONEY 875.00 ------------- 8130.00 02808 VILLAGE OF MOUNT PROSPECT INSPECTION 12500.00 OTHER 300.00 ------------- ~EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR1S2001 11: 41 RELEASE 10 : PAGE 16 DEPT VENDOR NBR ~ - ~ - - - - - - - - - - - - -- - - - - - - - - - --- - - - --- - - -- ~ - - - -- - - - - - - -- - - - - - - - - - - -- - - - - - - - - - - - -- - - -- --- - - -- - -- - - - - - - - - - - - - -- - - - - -- - - - - - - - -- - -- - - - - --- AMOUNT VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM Vu;RCH 01 2007 TO MARCH 14 2007 VENDOR NAME INVOICE DESCRIPTION - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - -- - - - - - - - - - -.- - - - - - - - - - -- -- - - - -- -- -- -- - - -- -- - - - - -- - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- TOTAL GRAND TOTAL 12800.00 21598.00 1849B08.29 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: THURSDAY MAR152007 11: 41 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM MARCH 01 2007 TO MARCH 14 2007 SUMMARY BY FUND 001 GENERAL FUND 656100.82 030 REFUSE DISPOSAL FUND 103003.60 050 MOTOR FUEL TAX FUND 50328.48 070 COMMUNITY DEVELPMNT BLOCK GRNT 109.50 190 SERIES 2003 B&I, VILLAGE HALL 300.00 290 SERIES 1999 B&I, TIF 300.00 510 CAPITAL IMPROVEMENT FUND 57700.30 610 WATER AND SEWER FUND 344113.96 620 VILLAGE PARKING SYSTEM FUND 1822. B6 630 PARKING SYSTEM REVENUE FUND 544B.61 660 VERI CLE MAINTENANCE FUND 4842 B. 34 670 VEHI CLE REPLACEMENT FUND 34100.00 690 RISK MANAGEMENT FUND 494B94.11 770 FLEXCOMP ESCROW FUND 31559.71 790 ESCROW DEPOSIT FUND 2159B.00 -------------- TOTAL : 1849BOB.29 PAGE 17 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES February 1 - February 28, 2007 03/13/2007 11,06,09 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 02/28/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 1,018,308 788,217 353,250 592,475 1,749,172 20,102 846,246 27,463 387,340 o 5,782,573 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 1,825,670 341,230 137,396 2 24,877 282 122 2,784 197 40,244 38,065 59,019 o o 126,536 16,320 5,399 10,596 52,888 35,402 o o o 3,758 o 144,569 149,395 2,488 776,419 7,532 5,803 156,837 109,633 18,663 637,202 500,776 552,326 1 Y-T-D Received 1,104,440 1,458,303 489,717 601,686 2,803,629 56,585 951,323 60,279 668,232 o 8,194,194 2,711,911 572,493 146,076 4 42,557 591 265 4,525 413 43,675 41,335 64,238 o o 141,739 29,777 9,843 11,949 96,496 64,592 o o o 9,879 o 166,258 276,533 5,334 1,494,471 16,527 14,190 158,626 135,588 22,568 741,527 558,233 611,682 2 Months ( 10 Months ( 2007 Budget 10,740,712 15,384,659 2,954,888 16,480,809 21,409,733 553,000 5,501,950 271,240 4,972,704 60,000 78,329,695 35,785,983 4,300,751 1,628,750 1,000 549,809 2,600 2,500 20,350 51,500 1,000 394,500 926,250 o o 1,076,500 o 49,367 88,507 582,933 735,250 o o o 262,800 o 1,220,052 1,711,100 32,000 11,149,100 96,738 111,100 1,573,353 1,093,626 189,547 6,473,939 4,125,500 4,093,290 16.6% ) Completed 83.3% ) Remaining Unreceived Balance 9,636,272 13,926,356 2,465,171 15,879,123 18,606,104 496,415 4,550,627 210,961 4,304,472 60,000 70,135,501 33,074,072 3,728,258 1,482,674 996 507,252 2,009 2,235 15,825 51,087 -42,675 353,165 862,012 o o 934,761 -29,777 39,524 76,558 486,437 670,658 o o o 252,921 o 1,053,794 1,434,567 26,666 9,654,629 80,211 96,910 1,414,727 958,038 166,979 5,732,412 3,567,267 3,481,608 Unreceived Percent 89.7 90.5 83.4 96 .3 86.9 89.8 82.7 77.8 86.6 100.0 89.5 92 .4 86.7 91. 0 99.6 92.3 77.3 89.4 77.8 99.2 **** * 89.5 93.1 86.8 80.1 86.5 83.4 91.2 96 .2 86.4 83.8 83.3 86.6 82.9 87.2 89.9 87.6 88.1 88.5 86.5 85.1 03/13/2007 11,06,09 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 02/28/07 2 Months ( 10 Months ( 16.6% ) Completed 83.3% ) Remaining ESCROW DEPOSIT FUND SSA #6 GEORGE/ALBERT B&I SERIES 2002 LIBRARY BND ESCROW GENERAL FIXED ASSETS ACCT GP Total All Funds Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent 0 0 0 0 65 135 0 -135 78 164 0 -164 0 0 0 0 5,782,573 8,194,194 78,329,695 70,135,501 89.5 2 03/13/2007 11:06:36 2 Months ( 10 Months ( FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/07 02/28/07 Summary Cur Mo Received GENERAL FUND 40 PROPERTY TAXES 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 45 FINES AND FORFEITS 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 695,721 118,049 350,315 433,999 134,752 17,415 31,187 27,499 16,733 o TOTAL GENERAL FUND 1,825,670 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 185,865 148,889 6,412 64 TOTAL REFUSE DISPOSAL FUND 341,230 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 133,643 5,597 -1,844 TOTAL MOTOR FUEL TAX FUND 137,396 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME TOTAL LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 48 OTHER REVENUE 24,833 44 o TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 24,877 ASSET SEIZURE FUND 45 46 FINES AND FORFEITS INVESTMENT INCOME o 282 TOTAL ASSET SEIZURE FUND 282 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME o 122 1 Y-T-D Received 754,585 533,710 484,782 440,923 278,637 52,317 86,266 42,114 38,577 o 2,711,911 201,591 358,608 12,187 107 572,493 133,643 11,435 998 146,076 o 2 2 27,120 64 15,373 42,557 o 591 591 o 265 2007 Budget 7,416,686 8,447,000 2,935,250 14,162,700 1,551,507 531,000 397,000 189,740 155,100 o 35,785,983 2,016,276 2,211,475 72,000 1,000 4,300,751 1,587,500 34,750 6,500 1,628,750 o 4 1,000 o 4 1,000 489,809 o 60,000 549,809 1,000 1,600 2,600 1,000 1,500 16.6% ) Completed 83.3% ) Remaining Unreceived Balance 6,662,101 7,913,290 2,450,468 13,721,777 1,272,870 478,683 310,734 147,626 116,523 o 33,074,072 1,814,685 1,852,867 59,813 893 3,728,258 1,453,857 23,315 5,502 1,482,674 1,000 -4 996 462,689 -64 44,627 507,252 1,000 1,009 2,009 1,000 1,235 Unreceived Percent 89.8 93.7 83.5 96.9 82.0 90.1 78.3 77.8 75.1 92.4 90.0 83.8 83.1 89.3 86.7 91. 6 67.1 84.6 91.0 100.0 99.6 94.5 74.4 92.3 100.0 63.1 77.3 100.0 82.3 03/13/2007 11,06,36 FRRBRR03 SUM 021 2 Months ( 10 Months ( Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/07 02/28/07 Summary Cur Mo Received Y-T-D Received 2007 Budget 16.6% ) Completed 83.3% ) Remaining Unreceived Balance Unreceived Percent 2,235 89.4 TOTAL DEA SHARED FUNDS FUND DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 2,687 97 TOTAL DUI FINE FUND 2,784 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME 40,099 145 TOTAL SERIES 1987A B&I, PW FACILITY 40,244 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 122 265 2,500 20,000 350 20,350 46,500 5,000 o 51,500 1,000 o 1,000 4,268 257 4,525 o 197 o o 413 o 15,732 93 78.7 26.6 197 413 43,466 209 43,675 15,825 77 .8 46,500 4,587 o 100.0 91. 7 51,087 99.2 -42,466 ****.* -209 -42,675 ****. * 37,980 41,193 390,500 349,307 89.5 85 142 4,000 3,858 96.5 0 0 0 0 38,065 41,335 394,500 353,165 89.5 TOTAL SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 58,643 63,605 916,250 852,645 93.1 376 633 10,000 9,367 93.7 0 0 0 0 59,019 64,238 926,250 862,012 93.1 TOTAL SERIES 2003 B&I, VILLAGE HALL 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 125,172 1,364 o 2 o o o o o o 138,643 3,096 o o o o o o o 1,053,500 23,000 o o o o o o o o o o o o o 914,857 19,904 o 86.8 86.5 03/13/2007 11,06,36 FRRBRR03 SUM 021 2 Months ( 10 Months ( 16.6% ) Completed 83.3% ) Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 02/28/07 ~ Cur Mo Received Y-T-D Received 2007 Budget Unreceived Balance Unreceived Percent TOTAL SERIES 1999 B&I, TIF 126,536 86.8 SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 16,320 o TOTAL SERIES 1996A B&I, FLOOD 16,320 SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 5,365 34 TOTAL SERIES 1998A B&I, FLOOD 5,399 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 10,373 223 TOTAL SERIES 1998C B&I, TIF 10,596 IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 52,888 o TOTAL IEPA FLOOD CONTROL LOANS B&I 52,888 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 35,402 o TOTAL SERIES 2000 B&I, FLOOD CONTROL 35,402 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. 3 141,739 29,777 o 29,777 9,788 55 9,843 11,490 459 11,949 96,496 o 96,496 64,592 o 64,592 o o o o o o o o o 1,076,500 o 49,067 300 49,367 87,307 1,200 88,507 582,933 o 582,933 728,000 7,250 735,250 o o o o o o o o o o o o 934,761 o o -29,777 o -29,777 39,279 245 80.1 81. 7 39,524 80.1 75,817 741 86.8 61. 8 76,558 86.5 486,437 o 83.4 486,437 83.4 663,408 91.1 7,250 100.0 670,658 91. 2 o o o o o o o o o o o o o o o 03/13/2007 11,06,36 FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/07 02/28/07 2 Months ( 10 Months ( 16.6% ) Completed 83.3% ) Remaining Sununary CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent 0 0 239,800 239,800 100.0 3,758 8,232 8,500 268 3.2 0 0 0 0 0 1,647 14,500 12,853 88.6 0 0 0 0 3,758 9,879 262,800 252,921 96.2 TOTAL CAPITAL IMPROVEMENT FUND SERIES 2003 PROJECT FUND 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o o o o o o o o TOTAL SERIES 2003 PROJECT FUND o o o o DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES TOTAL DOWNTOWN REDEVLPMNT CONST 138,723 153,652 1,167,552 1,013,900 86.8 5,846 12,606 52,500 39,894 76.0 0 0 0 0 0 0 0 0 144,569 166,258 1,220,052 1,053,794 86.4 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 144,183 265,619 1,688,700 1,423,081 84.3 0 0 0 0 5,212 10,914 22,400 11,486 51. 3 0 0 0 0 0 0 0 0 149,395 276,533 1,711,100 1,434,567 83.8 TOTAL STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 0 0 0 0 2,488 5,334 32,000 26,666 83.3 0 0 0 0 2,488 5,334 32,000 26,666 83.3 TOTAL FLOOD CONTROL CONST FUND 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 141,742 154,536 1,534,100 1,379,564 89.9 910 2,410 12,000 9,590 79.9 611,495 1,294,918 9,420,000 8,125,082 86.3 15,776 32,034 168,000 135,966 80.9 0 0 0 0 6,496 10,573 15,000 4,427 29.5 0 0 0 0 776,419 1,494,471 11,149,100 9,654,629 86.6 TOTAL WATER AND SEWER FUND 4 03/13/2007 11,06,36 FRRBRR03 SUM 021 2 Months ( 10 Months ( Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/07 02/28/07 Summary Cur Mo Received VILLAGE PARKING SYSTEM FUND 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 2,025 5,236 271 o TOTAL VILLAGE PARKING SYSTEM FUND 7,532 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 5,803 o o o TOTAL PARKING SYSTEM REVENUE FUND 5,803 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 155,595 1,242 o TOTAL VEHICLE MAINTENANCE FUND 156,837 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 84,963 24,670 o o TOTAL VEHICLE REPLACEMENT FUND 109,633 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 15,872 2,791 TOTAL COMPUTER REPLACEMENT FUND 18,663 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 4 8 OTHER REVENUE 586,567 7,124 1,808 41,703 TOTAL RISK MANAGEMENT FUND 637,202 POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 332,780 167,996 TOTAL POLICE PENSION FUND 500,776 5 Y-T-D Received 2,525 13,450 552 o 16,527 o o o o 14,190 o o o 14,190 155,595 3,031 o 158,626 84,963 50,625 o o 135,588 16,701 5,867 22,568 586,567 17,644 17,167 120,149 741,527 311,207 247,026 558,233 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 16.6% ) Completed 83.3% } Remaining Unreceived Balance 5,113 75,050 48 o 80,2H o o 95,810 1,100 o o 96,910 1,400,358 14,369 o 1,414,727 764,663 133,375 o 60,000 958,038 142,846 24,133 166,979 4,876,558 74,356 57,833 723,665 5,732,412 1,819,793 1,747,474 3,567,267 Unreceived Percent 66.9 84.8 8.0 82.9 87.1 100.0 87.2 90.0 82.6 89.9 90.0 72 .5 100.0 87.6 89.5 80.4 88.1 89.3 80.8 77.1 85.8 88.5 85.4 87.6 86.5 03/13/2007 11,06,36 FRRBRR03 SUM 021 Budget VILLAGE Revenue by 01/01/07 OF MOUNT PROSPECT Category within Fund 02/28/07 Summary FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE TOTAL FIRE PENSION FUND ESCROW DEPOSIT FUND 46 INVESTMENT INCOME TOTAL ESCROW DEPOSIT FUND SSA #6 GEORGE/ALBERT B&I 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SSA #6 GEORGE/ALBERT B&I SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME TOTAL SERIES 2002 LIBRARY BND ESCROW GENERAL FIXED ASSETS ACCT GP 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES TOTAL GENERAL FIXED ASSETS ACCT GP MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES TOTAL MOUNT PROSPECT LIBRARY FUND 2 Months ( 10 Months ( 16.6% ) Completed 83.3% ) Remaining Cur Mo Y-T-D 2007 Unreceived Unreceived Received Received Budget Balance Percent 397,978 376,902 2,204,500 1,827,598 82.9 154,348 234,780 1,888,790 1,654,010 87.6 552,326 611,682 4,093,290 3,481,608 85.1 o o o o o o o o o 65 o 135 o o o -135 65 135 o -135 78 164 o -164 78 164 o -164 o o o o o o o o o o o o o o 8,572,028 8,572,028 100.0 o o 8,572,028 8,572,028 100.0 6 03/13/2007 11,05,13 2 Months ( 10 Months ( VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 02/28/07 Cur Mo Expended Y-T-D Expended 2007 Budget 16.6% ) Completed 83.3% } Remaining Unexpended Balance 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,896,752 548,238 18,301 420,000 920,724 38,208 715,769 91,866 4,674 o o 1,673 5,630 13,694 700 6,293 o 21,835 300 o 4,704,657 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 8&1, 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,719,396 112,058 12,743 o 10,695 801 o o 209 o o o o o o o o o o 300 o o o 13,874 o 35,029 o o 1 3,747,030 689,934 56,562 841,356 1,293,886 41,065 1,321,086 130,796 4,674 o o 2,956 5,630 13,874 700 6,293 115,018 404,212 300 o 8,675,372 4,738,499 303,609 12,743 o 15,629 801 o o 209 405,000 o o o o 72,750 o o o 19,645 300 o o o 13,874 o 35,029 o o 24,621,815 6,470,038 452,438 5,131,324 16,012,741 745,159 7,105,878 1,566,987 1,978,000 o 255,365 351,035 1,065,470 1,319,820 1,724,800 3,565,000 2,874,195 1,329,033 3,000 o 76,572,098 35,371,051 4,029,607 1,729,610 1,000 527,309 1,000 1,000 1,000 10,000 405,000 383,765 896,594 o o 916,100 o 67,795 153,575 613,356 727,743 o o o 738,000 o 1,881,200 2,071,000 244,000 20,874,785 5,780,104 395,876 4,289,968 14,718,855 704,094 5,784,792 1,436,191 1,973,326 o 255,365 348,079 1,059,840 1,305,946 1,724,100 3,558,707 2,759,177 924,821 2,700 o 67,896,726 30,632,552 3,725,998 1,716,867 1,000 511,680 199 1,000 1,000 9,791 o 383,765 896,594 o o 843,350 o 67,795 153,575 593,711 727,443 o o o 724,126 o 1,846,171 2,071,000 244,000 84.8 89.3 87.5 83.6 91.9 94.5 81.4 91. 7 99.8 100.0 99.2 99.5 98.9 100.0 99.8 96.0 69.6 90.0 88.7 86.6 92.5 99.3 100.0 97.0 19.9 100.0 100.0 97.9 100.0 100.0 92.1 100.0 100.0 96.8 100.0 98.1 98.1 100.0 100.0 03/13/2007 11,05,13 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 02/28/07 2 Months ( 10 Months ( 16.6% ) Completed 83.3% ) Remaining Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent WATER AND SEWER FUND 590,982 739,333 11,131,631 10,392,298 93.4 VILLAGE PARKING SYSTEM FUND 11,064 12,369 123,154 110,785 90.0 PARKING SYSTEM REVENUE FUND 18,562 21,463 156,448 134,985 86.3 VEHICLE MAINTENANCE FUND 105,466 187,611 1,573,353 1,385,742 88.1 VEHICLE REPLACEMENT FUND 5,630 5,630 961,470 955,840 99.4 COMPUTER REPLACEMENT FUND 0 0 249,050 249,050 100.0 RISK MANAGEMENT FUND 651,559 1,256,876 6,514,196 5,257,320 80.7 POLICE PENSION FUND 199,139 398,956 2,465,133 2,066,177 83.8 FIRE PENSION FUND 217,150 435,046 2,627,958 2,192,912 83.4 SSA #6 GEORGE/ALBERT B&I 0 0 0 0 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 4,704,657 8,675,372 76,572,098 67,896,726 88.7 2 03/13/2007 lL07,08 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/07 2 Months ( 10 Months 16.6% ) Completed 83.3% ) Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 10,114 21,408 111,270 89,862 80.8 3,140 6,906 17,010 10,104 59.4 13,254 28,314 128,280 99,966 77.9 PUBLIC REPRESENTATION PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 03 ADVISORY BOARDS & COMMISSIONS EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES Totals 4,584 9,752 35,466 25,714 72.5 798 1,551 6,361 4,810 75.6 0 0 3,000 3,000 100.0 7,295 16,434 77,353 60,919 78.8 36 36 500 464 92.8 541 541 5,600 5,059 90.3 13,254 28,314 128,280 99,966 77.9 SOURCE OF FUNDS 001 GENERAL FUND 13,254 28,314 128,280 99,966 77.9 Totals 13,254 28,314 128,280 99,966 77.9 1 03/13/2007 11:07:08 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/07 2 Months ( 10 Months 16.6% ) Completed 83.3% ) Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 70,427 119,611 509,550 389,939 76.5 39,940 40,190 630,750 590,560 93.6 14,259 35,074 287,303 252,229 87.8 51,924 77,442 919,135 841,693 91. 6 5,706 10,667 143,372 132,705 92.6 182,256 282,984 2,490,110 2,207,126 88.6 VILLAGE MANAGERIS OFFICE PROGRAM TOTALS 01 VILLAGE MANAGER'S OFFICE 02 LEGAL SERVICES 03 PERSONNEL SERVICES 04 INFORMATION TECHNOLOGY 05 PUBLIC INFORMATION 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 Totals 89,990 163,138 898,539 735,401 81. 8 22,939 35,339 281,625 246,286 87.5 633 6,494 46,400 39,906 86.0 67,728 76,615 1,213,396 1,136,781 93.7 228 531 10,145 9,614 94.8 386 515 11,485 10,970 95.5 352 352 26,920 26,568 98.7 0 0 1,600 1,600 100.0 182,256 282,984 2,490,110 2,207,126 88.6 SOURCE OF FUNDS 001 GENERAL FUND 182,256 282,984 282,984 2,490,110 2,207,126 88.6 Totals 182,256 2,490,110 2,207,126 88.6 2 03/13/2007 11,07,08 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/07 2 Months ( 10 Months 16.6% ) Completed 83.3% ) Remaining Totals Cur Mo Y-T-D 2007 Unexpended unexpended Expended Expended Budget Balance Percent 9,449 16,730 130,245 113,515 87.2 3,258 5,533 48,322 42,789 88.5 12,707 22,263 178,567 156,304 87.5 TV SERVICES DIVISION PROGRAM TOTALS 02 CABLE TV OPERATIONS 04 INTERGOVERNMENTAL PROGRAMMING EXPENDITURE CLASSIFICATION Totals 8,613 15,552 102,484 86,932 84.8 3,518 4,635 41,133 36,498 88.7 0 535 2,650 2,115 79.8 335 1,164 13,150 11,986 91.1 241 355 1,600 1,245 77.8 0 22 7,050 7,028 99.7 0 0 10,500 10,500 100.0 12,707 22,263 178,567 156,304 87.5 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT SOURCE OF FUNDS 001 GENERAL FUND 12,707 22,263 178,567 156,304 87.5 Totals 12,707 22,263 178,567 156,304 87.5 3 03/13/2007 1'1,07,08 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/07 2 Months ( 10 Months 16.6% ) Completed 83.3% ) Remaining VILLAGE CLERK'S OFFICE Cur Mo Expended Y-T-D Expended 2007 Budget Unexpended Balance Unexpended Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 13,592 27,931 200,188 172,257 86.0 Totals 13,592 27,931 200,188 172,257 86.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES Totals SOURCE OF FUNDS 001 GENERAL FUND 8,538 16,962 113,075 96,113 85.0 3,483 4,903 43,977 39,074 88.9 0 40 2,625 2,585 98.5 940 5,435 33,748 28,313 83.9 120 5 1,650 1,645 99.7 511 586 5,113 4,527 88.5 13,592 27,931 200,188 172,257 86.0 13,592 27,931 200,188 172,257 86.0 Totals 13,592 27,931 200,188 172,257 86.0 4 03/13/2007 2 Months ( 16.6% ) Completed ~~,07,08 VILLAGE OF MOUNT PROSPECT 10 Months 83.3% ) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 02/28/07 Cur Mo Y-T-D 2007 Unexpended Unexpended FINANCE DEPARTMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 30,232 49,844 301,287 251,443 83.5 02 ACCOUNTING 35,290 64,003 444,679 380,676 85.6 04 DUPLICATING SERVICES 0 0 0 0 05 INSURANCE PROGRAMS 50,544 55,241 521,445 466,204 89.4 06 CUSTOMER SERVICES 35,557 54,910 409,237 354,327 86.6 07 CASH MANAGEMENT 2,684 4,821 49,732 44,911 90.3 Totals 154,307 228,819 1,726,380 1,497,561 86.7 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 58,624 114,787 796,825 682,038 85.6 51 EMPLOYEE BENEFITS 23,018 32,431 295,144 262,713 89.0 52 OTHER EMPLOYEE COSTS 1,055 1,275 10,640 9,365 88.0 54 CONTRACTUAL SERVICES 24,640 33,171 137,776 104,605 75.9 55 UTILITIES 457 457 5,150 4,693 91.1 56 INSURANCE 45,061 45,061 450,605 405,544 90.0 57 COMMODITIES & SUPPLIES 1,152 1,337 24,240 22,903 94.5 65 OFFICE EQUIPMENT 300 300 6,000 5,700 95.0 Totals 154,307 228,819 1,726,380 1,497,561 86.7 SOURCE OF FUNDS 001 GENERAL FUND 154,307 228,819 1,726,380 1,497,561 86.7 Totals 154,307 228,819 1,726,380 1,497,561 86.7 5 03/13/2007 11:07:08 FRRDBROl SUM 031 2 Months ( 10 Months Department Budget 01/01/07 VILLAGE OF MOUNT PROSPECT Expenditure Summary 02/28/07 COMMUNITY DEVELOPMENT PROGRAM TOTALS 01 COMMUNITY DEVELOPMENT ADMIN 02 PLANNING & ZONING 03 ECONOMIC DEVELOPMENT 05 BUILDING INSPECTIONS 06 HOUSING INSPECTIONS 07 HEALTH INSPECTIONS Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST Totals Cur Mo Expended 20,503 19,027 8,468 61,344 27,884 10,332 147,558 91,802 40,273 1,664 11,867 805 1,147 o 147,558 146,658 900 147,558 6 Y-T-D Expended 34,556 35,225 14,491 105,331 46,588 17,170 253,361 177,820 54,660 3,267 13,764 1,327 2,523 o 253,361 252,461 900 253,361 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 16.6% ) Completed 83.3% } Remaining Unexpended Balance 206,073 230,355 94,945 707,160 443,592 111,148 1,793,273 1,077,825 443,007 27,296 198,720 17,228 16,197 13,000 1,793,273 1,793,273 o 1,793,273 Unexpended Percent 85.6 86.7 86.8 87.0 90.5 86.6 87.6 85.8 89.0 89.3 93.5 92.8 86.5 100.0 87.6 87.7 87.6 03/13/2007 2 Months ( 16.6% ) Completed 11,07,08 VILLAGE OF MOUNT PROSPECT 10 Months 83.3% ) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 02/28/07 Cur Mo Y-T-D 2007 Unexpended Unexpended COMMUNITY DEVELOPMENT - CDBG Expended Expended Budget Balance Percent PROGRAM TOTALS 04 CDBG ADMINISTRATION 5,932 10,866 83,309 72,443 87.0 05 CDBG COMMUNITY PROGRAMS 0 0 134,000 134,000 100.0 06 ACCESSIBLTY & NEIGHBRHD IMPRV 0 0 85,000 85,000 100.0 07 CDBG RESIDENTIAL REHAB 4,763 4,763 225,000 220,237 97.9 Totals 10,695 15,629 527,309 511,680 97.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 4,000 7,931 52,004 44,073 84.7 51 EMPLOYEE BENEFITS 1,710 2,377 20,697 18,320 88.5 52 OTHER EMPLOYEE COSTS 218 218 6,020 5,802 96 .4 54 CONTRACTUAL SERVICES 4 340 147,639 147,299 99.8 57 COMMODITIES & SUPPLIES 0 0 949 949 100.0 59 OTHER EXPENDITURES 4,763 4,763 190,000 185,237 97.5 64 BUILDING IMPROVEMENTS 0 0 0 0 69 INFRASTRUCTURE 0 0 110,000 110,000 100.0 Totals 10,695 15,629 527,309 511,680 97.0 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 10,695 15,629 527,309 511,680 97.0 Totals 10,695 15,629 527,309 511,680 97.0 7 03/13/2007 11,07,08 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/07 2 Months ( 10 Months 16.6% ) Completed 83.3% ) Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 16,183 27,149 176,277 149,128 84.6 25,583 47,664 342,827 295,163 86.1 13,053 21,980 191,981 170,001 88.6 2,442 3,907 44,922 41,015 91. 3 0 0 0 0 57,261 100,700 756,007 655,307 86.7 HUMAN SERVICES PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 02 SOCIAL SERVICES 03 NURSING/HEALTH SERVICES 04 SENIOR CTR. LEISURE ACTIVITIES 05 YOUTH ACTIVITIES EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT Totals 38,199 73,948 478,186 404,238 84.5 13,231 19,161 171,605 152,444 88.8 279 419 3,900 3,481 89.3 4,666 5,841 53,601 47,760 89.1 433 595 8,000 7,405 92.6 453 736 37,215 36,479 98.0 0 0 3,500 3,500 100.0 57,261 100,700 756,007 655,307 86.7 SOURCE OF FUNDS 001 GENERAL FUND 57,261 100,700 756,007 655,307 86.7 Totals 57,261 100,700 756,007 655,307 86.7 8 03/13/2007 11,07,08 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/07 2 Months ( 10 Months 16.6% ) Completed 83.3% ) Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 138,970 241,795 1,612,340 1,370,545 85.0 616,448 1,202,318 8,218,329 7,016,01l 85.4 19,531 37,622 342,746 305,124 89.0 89,911 169,138 1,205,678 1,036,540 86.0 2,822 5,506 29,380 23,874 81.3 72,050 86,855 811,753 724,898 89.3 939,732 1,743,234 12,220,226 10,476,992 85.7 POLICE PROGRAM TOTALS 01 POLICE ADMINISTRATION 02 PATROL & TRAFFIC ENFORCEMENT 03 CRIME PREVTN & PUBLIC SERVICES 04 INVESTIGATIVE & JUVENILE PRGM 05 CROSSING GUARDS 06 EQUIPMENT MAINTENANCE 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 Totals 624,372 1,267,168 8,592,849 7,325,681 85.3 170,065 190,979 1,852,559 1,661,580 89.7 6,040 26,042 123,000 96,958 78.8 120,605 230,331 1,427,145 1,196,814 83.9 3,006 4,228 49,200 44, 972 91.4 13,822 21,201 115,423 94,222 81. 6 1,021 2,304 14,000 11,696 83.5 801 981 46,050 45,069 97.9 939,732 1,743,234 12,220,226 10,476,992 85.7 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND Totals 938,931 1,742,433 12,216,226 10,473,793 85.7 0 0 1,000 1,000 100.0 801 801 1,000 199 19.9 0 0 1,000 1,000 100.0 0 0 1,000 1,000 100.0 939,732 1,743,234 12,220,226 10,476,992 85.7 9 03/13/2007 11,07,08 FRRDBROl SUM 031 2 Months ( 10 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/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 95,630 529,825 10,470 40,215 11,650 44,608 348 1,860 o 209 Totals 734,815 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 521,617 129,033 3,168 o 41,618 9,445 21,265 o o 8,669 Totals 734,815 SOURCE OF FUNDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 734,606 209 Totals 734,815 10 Y-T-D Expended 138,647 1,066,506 10,470 72,564 12,335 60,573 348 2,677 o 209 1,364,329 1,091,079 142,594 6,887 o 79,083 10,130 25,887 o o 8,669 1,364,329 1,364,120 209 1,364,329 2007 Budget 944,298 6,929,243 13,631 546,561 64,500 505,633 35,715 35,748 o 10,000 9,085,329 6,833,619 1,390,307 146,940 o 454,019 43,200 119,769 4,000 4,000 89,475 9,085,329 9,075,329 10,000 9,085,329 16.6% ) Completed 83.3% ) Remaining Unexpended Balance 805,651 5,862,737 3,161 473,997 52,165 445,060 35,367 33,071 o 9,791 7,721,000 5,742,540 1,247,713 140,053 o 374,936 33,070 93,882 4,000 4,000 80,806 7,721,000 7,711,209 9,791 7,721,000 Unexpended Percent 85.3 84.6 23.2 86.7 80.9 88.0 99.0 92.5 97.9 85.0 84.0 89.7 95.3 82.6 76.6 78.4 100.0 100.0 90.3 85.0 85.0 97.9 85.0 03/13/2007 11:07:08 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/07 2 Months ( 10 Months 16.6% ) Completed 83.3% ) Remaining PUBLIC WORKS - ADMINISTRATION Cur Mo Expended Y-T-D Expended 2007 Budget Unexpended Balance Unexpended Percent PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 113,584 136,062 1,259,759 1,123,697 89.2 Totals 113,584 136,062 1,259,759 1,123,697 89.2 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 Totals 20,462 37,492 237,193 199,701 84.2 12,254 15,135 135,476 120,341 88.8 1,540 3,106 30,095 26,989 89.7 75,419 76,684 821,835 745,151 90.7 3,459 3,019 18,990 15,971 84.1 450 626 14,475 13,849 95.7 0 0 1,090 1,090 100.0 0 0 605 605 100.0 113,584 136,062 1,259,759 1,123,697 89.2 SOURCE OF FUNDS 001 GENERAL FUND 113,584 136,062 1,259,759 1,123,697 89.2 Totals 113,584 136,062 1,259,759 1,123,697 89.2 11 03/13/2007 11,07,08 FRRDBROl SUM 031 2 Months ( 10 Months Department Budget 01/01/07 VILLAGE OF MOUNT PROSPECT Expenditure Summary 02/28/07 PUBLIC WORKS STREETS/BLDGS 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 MAl NT 11 PARKING LOT MAINTENANCE 12 FLOOD CONTROL Totals 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 Totals SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND Totals Cur Mo Expended 12,908 68,986 16,414 64,124 o 11,474 4,504 9,191 11,064 18,562 o 217,227 124,327 31,874 48,242 458 317 12,009 o o o o o 217,227 185,876 1,725 11,064 18,562 217,227 12 Y-T-D Expended 21,203 99,755 28,849 72,039 o 20,929 6,587 14,571 12,369 21,463 o 297,765 192,997 43,520 48,242 458 317 12,231 o o o o o 297,765 262,208 1,725 12,369 21,463 297,765 2007 Budget 146,860 982,815 504,141 445,928 o 178,890 70,548 119,916 123,154 156,448 o 2,728,700 1,108,580 354,511 676,035 134,644 3,172 300,993 o 6,365 19,400 125,000 o 2,728,700 2,225,928 223,170 123,154 156,448 2,728,700 16.6% ) Completed 83.3% ) Remaining Unexpended Balance 125,657 883,060 475,292 373,889 o 157,961 63,961 105,345 110,785 134,985 o 2,430,935 915,583 310,991 627,793 134,186 2,855 288,762 o 6,365 19,400 125,000 o 2,430,935 1,963,720 221,445 110,785 134,985 2,430,935 Unexpended Percent 85.6 89.9 94.3 83.8 88.3 90.7 87.8 90.0 86.3 89.1 82.6 87.7 92.9 99.7 90.0 95.9 100.0 100.0 100.0 89.1 88.2 99.2 90.0 86.3 89.1 "03/13/2007 11,07,08 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/07 2 Months ( 10 Months 16.6% ) Completed 83.3% ) Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 15,771 29,717 216,107 186,390 86.2 22,460 42,015 517,535 475,520 91.9 25,621 46,775 841,572 794,797 94.4 2,283 4,334 95,998 91,664 95.5 66,135 122,841 1,671,212 1,548,371 92.6 PUBLIC WORKS - FORESTRY/GRNDS PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 02 MAINTENANCE OF GROUND 03 FORESTRY PROGRAM 04 PUBLIC GROUNDS BEAUTIFICATION EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT Totals 50,375 98,770 697,162 598,392 85.8 15,464 23,473 228,406 204,933 89.7 0 276 3,555 3,279 92.2 0 26 644,224 644,198 100.0 296 296 70,470 70,174 99.6 0 0 27,395 27,395 100.0 66,135 122,841 1,671,212 1,548,371 92.6 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 66,135 o 122,841 o 1,660,293 10,919 1,537,452 10,919 92.6 100.0 Totals 66,135 122,841 1,671,212 1,548,371 92.6 13 03/13/2007 11,07,08 FRRDBROl SUM 031 Department Budget 01/01/07 VILLAGE OF MOUNT PROSPECT Expenditure Summary 02/28/07 2 Months ( 10 Months 16.6% ) Completed 83.3% ) Remaining Cur Mo Y-T-D 2007 Unexpended Unexpended PUBLIC WORKS - ENGINEERING Expended Expended Budget Balance Percent PROGRAM TOTALS 01 ENGINEERING SERVICES 61,877 106,086 768,027 661,941 86.2 05 TRAFFIC CNTRL & STREET LGHTNG 19,913 27,659 526,180 498,521 94.7 Totals 81,790 133,745 1,294,207 1,160,462 89.7 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 50,557 94,476 622,116 527,640 84.8 51 EMPLOYEE BENEFITS 15,178 22,624 191,927 169,303 88.2 52 OTHER EMPLOYEE COSTS 170 417 5,390 4,973 92 .3 54 CONTRACTUAL SERVICES 4,501 4,844 146,669 141,825 96.7 55 UTILITIES 10,018 10,018 249,000 238,982 96.0 57 COMMODITIES & SUPPLIES 1,366 1,366 26,985 25,619 94.9 65 OFFICE EQUIPMENT 0 0 530 530 100.0 67 OTHER EQUIPMENT 0 0 1,590 1,590 100.0 69 INFRASTRUCTURE 0 0 50,000 50,000 100.0 Totals 81,790 133,745 1,294,207 1,160,462 89.7 SOURCE OF FUNDS 001 GENERAL FUND 70,772 122,727 1,010,867 888,140 87.9 050 MOTOR FUEL TAX FUND 11,018 11,018 283,340 272,322 96 .1 Totals 81,790 133,745 1,294,207 1,160,462 89.7 14 63/13/2007 ll,07,OB FRRDBROl SUM031 2 Months ( 10 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/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 125,791 12,178 3,437 29,229 40,162 18,443 14, 878 60,609 17,312 o 268,943 Totals 590,982 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 135,226 44,892 3,534 380,159 9,086 13,566 3,819 o o o 700 o Totals 590,982 SOURCE OF FUNDS 610 WATER AND SEWER FUND 590,982 Totals 590,982 15 Y-T-D Expended 163,339 23,135 7,214 53,571 64,055 40,258 28,043 60,609 30,166 o 268,943 739,333 257,706 65,603 7,586 380,770 9,490 13,566 3,912 o o o 700 o 739,333 739,333 739,333 2007 Budget 1,468,391 193,622 102,407 880,371 1,390,832 364,297 355,821 606,091 491,494 1,830,000 3,448,305 1.1.,1.31.,631. 1,783,337 633,956 33,625 5,603,389 202,875 135,664 205,285 o 7,41.5 801.,285 1,724,800 o 11,131.,631 11.,131,631. 1.1.,1.31.,631. 16.6% ) Completed 83.3% ) Remaining Unexpended Balance 1.,305,052 1.70,487 95,193 826,800 1.,326,777 324,039 327,778 545,482 461.,328 1.,830,000 3,1.79,362 1.0,392,298 1,525,631 568,353 26,039 5,222,619 193,385 122,098 201,373 o 7,415 801.,285 1.,724,1.00 o 1.0,392,298 10,392,298 1.0,392,298 Unexpended Percent 88.9 88.1 93.0 93.9 95.4 88.9 92 .1 90.0 93.9 100.0 92 .2 93.4 85.5 89.7 77.4 93.2 95.3 90.0 98.1 100.0 100.0 1.00.0 93.4 93.4 93.4 03/13/2007 2 Months ( 16.6% ) Completed 11:07:08 VILLAGE OF MOUNT PROSPECT 10 Months 83.3% ) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 02/28/07 Cur Mo Y-T-D 2007 Unexpended Unexpended PUBLIC WORKS - REFUSE DISPOSAL Expended Expended Budget Balance Percent PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 102,879 286,494 3,825,838 3,539,344 92.5 02 REFUSE LEAF REMOVAL PROGRAM 9,179 17,115 203,769 186,654 91. 6 Totals 112,058 303,609 4,029,607 3,725,998 92.5 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 13,902 26,644 230,544 203,900 88.4 51 EMPLOYEE BENEFITS 4,427 6,585 71,446 64,861 90.8 52 OTHER EMPLOYEE COSTS 0 0 1,785 1,785 100.0 54 CONTRACTUAL SERVICES 88,353 265,004 3,654,352 3,389,348 92.7 55 UTILITIES 110 110 590 480 81.4 56 INSURANCE 5,266 5,266 52,660 47,394 90.0 57 COMMODITIES & SUPPLIES 0 0 18,230 18,230 100.0 Totals 112,058 303,609 4,029,607 3,725,998 92.5 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 112,058 303,609 4,029,607 3,725,998 92.5 Totals 112,058 303,609 4,029,607 3,725,998 92.5 16 03/13/2007 2 Months ( 16.6% ) Completed 11,07,08 VILLAGE OF MOUNT PROSPECT 10 Months 83.3% ) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 02/28/07 Cur Mo Y-T-D 2007 Unexpended Unexpended PUBLIC WORKS - VEHICLE MAINT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 15,018 24,028 185,783 161,755 87.1 02 VEHICLE MAINTENANCE PROGRAM 90,448 163,583 1,387,570 1,223,987 88.2 Totals 105.466 187.611 1.573.353 1.385.742 88.1 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51,044 99,356 695,541 596,185 85.7 51 EMPLOYEE BENEFITS 15,989 24,127 237,031 212,904 89.8 52 OTHER EMPLOYEE COSTS 0 0 2,250 2,250 100.0 54 CONTRACTUAL SERVICES 3,529 5,030 78,151 73,121 93.6 55 UTILITIES 306 306 1,060 754 71.1 57 COMMODITIES & SUPPLIES 34,598 58,792 555,370 496,578 89.4 59 OTHER EXPENDITURES 0 0 0 0 65 OFFICE EQUIPMENT 0 0 530 530 100.0 67 OTHER EQUIPMENT 0 0 3,420 3,420 100.0 Totals 105.466 187.611 1.573,353 1,385.742 88.1 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 105,466 187,611 1,573,353 1,385,742 88.1 Totals 105,466 187,611 1,573,353 1,385.742 88.1 17 03/13/2007 11,07,08 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/07 2 Months ( 10 Months ( 16.6% ) Completed 83.3% ) Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 23,300 30,492 126,100 95,608 75.8 0 105 136,685 136,580 99.9 2,230 6,236 87,178 80,942 92.8 216 380 2,887 2,507 86.8 25,746 37,213 352,850 315,637 89.5 COMMUNITY SERVICE PROGRAMS PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 03 4TH OF JULY & CIVIC EVENTS,ETC 04 HOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES To tal s 520 1,452 88,650 87,198 98.4 92 237 16,210 15,973 98.5 25,172 35,457 208,875 173,418 83.0 0 0 0 0 51 156 29,115 28,959 99.5 -89 -89 10,000 10,089 100.9 25,746 37,213 352,850 315,637 89.5 SOURCE OF FUNDS 001 GENERAL FUND 25.746 37,213 352,850 315,637 89.5 Totals 25,746 37,213 352,850 315,637 89.5 18 '03/13/2007 11,07,08 FRRDBROl SUM 031 2 Months ( 10 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/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 13,874 o 34,129 o o 5,630 o Totals 53,633 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 15,651 o o o o o 5,630 4,224 6,293 21,835 Totals 53,633 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 o 13,874 o 34,129 o o o 5,630 o Totals 53,633 19 Y-T-D Expended 13,874 o 34,129 o o 5,630 o 53,633 15,651 o o o o o 5,630 4,224 6,293 21,835 53,633 o 13,874 o 34,129 o o o 5,630 o 53,633 2007 Budget 653,000 10,000 1,880,300 244,000 3,369,100 961,470 249,050 7,366,920 369,100 o 1,778,000 o 245,000 274,050 1,065,470 313,000 3,280,000 42,300 7,366,920 1,223,100 738,000 o 1,880,300 2,071,000 244,000 o 961,470 249,050 7,366,920 16.6% ) Completed 83.3% ) Remaining Unexpended Balance 639,126 10,000 1,846,171 244,000 3,369,100 955,840 249,050 7,313,287 353,449 o 1,778,000 o 245,000 274,050 1,059,840 308,776 3,273,707 20,465 7,313,287 1,223,100 724,126 o 1,846,171 2,071,000 244,000 o 955,840 249,050 7,313,287 Unexpended Percent 97.9 100.0 98.2 100.0 100.0 99.4 100.0 99.3 95.8 100.0 100.0 100.0 99.5 98.7 99.8 48.4 99.3 100.0 98.1 98.2 100.0 100.0 99.4 100.0 99.3 03/13/2007 2 Months ( 16.6% ) Completed 11,07,09 VILLAGE OF MOUNT PROSPECT 10 Months 83.3% ) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 02/28/07 Cur Mo Y-T-D 2007 Unexpended Unexpended DEBT SERVICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 DEBT SERVICE - PROPERTY TAXES 0 405,000 1,685,359 1,280,359 76.0 03 DEBT SERVICE - TAX INCREMENT 0 72,750 1,069,675 996,925 93.2 04 DEBT SERVICE - H/R SALES TAX 1 300 19,945 1,408,894 1,388,949 98.6 05 DEBT SERVICE - H/R SALES TAX 2 0 0 0 0 06 SPECIAL SERVICE AREA B & I 0 0 0 0 Totals 300 497,695 4,163,928 3,666,233 88.0 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 0 0 0 0 71 BOND PRINCIPAL 0 115,018 2,874,195 2,759,177 96.0 72 INTEREST EXPENSE 0 382,377 1,286,733 904,356 70.3 73 BANK AND FISCAL FEES 300 300 3,000 2,700 90.0 80 INTERFUND TRANSFERS 0 0 0 0 Totals 300 497,695 4,163,928 3,666,233 88.0 SOURCE OF FUNDS 140 SERIES 1987A B&I, PW FACILITY 0 405,000 405,000 0 180 SERIES 2001 B&I, VILLAGE HALL 0 0 383,765 383,765 100.0 190 SERIES 2003 B&I, VILLAGE HALL 0 0 896,594 896,594 100.0 200 SERIES 2002B B&I, PUBLIC BLDGS 0 0 0 0 230 SERIES 2002A B&I, TIF 0 0 0 0 290 SERIES 1999 B&I, TIF 0 72,750 916,100 843,350 92.1 340 SERIES 1996A B&I, FLOOD 0 0 0 0 350 SERIES 1998A B&I, FLOOD 0 0 67,795 67,795 100.0 360 SERIES 1998C B&I, TIF 0 0 153,575 153,575 100.0 380 IEPA FLOOD CONTROL LOANS B&I 0 19,645 613,356 593,711 96.8 390 SERIES 2000 B&I, FLOOD CONTROL 300 300 727,743 727,443 100.0 400 SERIES 2002B B&I, FLOOD 0 0 0 0 430 SERIES 1998A B&I, STREET IMP. 0 0 0 0 440 SERIES 2002B B&I, STREET IMP. 0 0 0 0 830 SSA #6 GEORGE/ALBERT B&I 0 0 0 0 Totals 300 497,695 4,163,928 3,666,233 88.0 20 03/13/2007 11,07,09 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/07 2 Months ( 10 Months 16.6% ) Completed 83.3% ) Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 3,711 7,423 44,533 37,110 83.3 199,139 398,956 2,465,133 2,066,177 83.8 21 7,150 435,046 2,627,958 2,192,912 83.4 420,000 841,425 5,137,624 4,296,199 83.6 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 420,000 841,356 5,131,324 4,289,968 83.6 0 0 5,800 5,800 100.0 0 69 500 431 86.2 420,000 841,425 5,137,624 4,296,199 83.6 SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FUND 720 FIRE PENSION FUND Totals 3,711 7,423 44,533 37,110 83.3 199,139 398,956 2,465,133 2,066,177 83.8 217,150 435,046 2,627,958 2,192,912 83.4 420,000 841,425 5,137,624 4,296,199 83.6 21 03/13/2007 11,07,09 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 02/28/07 2 Months ( 10 Months ( 16.6% ) Completed 83.3% ) Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 174,628 371,688 1,360,353 988,665 72.7 476,931 885,188 5,142,924 4,257,736 82.8 651,559 1,256,876 6,503,277 5,246,401 80.7 RISK MANAGEMENT PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 67 OTHER EQUIPMENT Totals 0 0 34,000 34,000 100.0 651,559 1,256,876 6,463,777 5,206,901 80.6 0 0 5,500 5,500 100.0 651,559 1,256,876 6,503,277 5,246,401 80.7 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 651,559 1,256,876 6,503,277 5,246,401 80.7 Totals 651,559 1,256,876 6,503,277 5,246,401 80.7 22 03/13/2007 ll,07:09 FRRDBROl SUM 031 2 Months ( 10 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 02/28/07 NON-DEPARTMENTAL Cur Mo Expended Unexpended Unexpended Balance Percent 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 16.6% ) Completed 83.3% ) Remaining o o o o o o o o o o o o o o o o 03/13/2007 11,07,09 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 02/28/07 2 Months ( 10 Months 16.6% ) Completed 83.3% ) Remaining CAPITAL FIXED ASSETS Cur Mo Expended Y-T-D Expended 2007 Budget Unexpended Unexpended Balance Percent PROGRAM TOTALS 00 CAPITAL FIXED ASSETS o o o o Totals o o o o EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES o o o o Totals o o o o SOURCE OF FUNDS 910 GENERAL FIXED ASSETS ACCT GP o o o o Totals o o o o 24 03/13/2007 11,07,09 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 02/28/07 2 Months ( 10 Months 16.6% ) Completed 83.3% ) Remaining MOUNT PROSPECT LIBRARY Cur Mo Expended Y-T-D Expended 2007 Budget Unexpended Balance Unexpended Percent PROGRAM TOTALS 02 LIBRARY SERVICES o o 8,572,028 8,572,028 100.0 Totals o o 8,572,028 8,572,028 100.0 EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES o o 8,572,028 8,572,028 100.0 Totals o o 8,572,028 8,572,028 100.0 SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND o o 8,572,028 8,572,028 100.0 Totals o o 8,572,028 8,572,028 100.0 25