Loading...
HomeMy WebLinkAbout3. BILLS &FINANCIALS 08/19/08 VILLAGE OF MOUNT PROSPECT CASH POSITION August 01 -13,2008 Cash & Invstmt Receipts Disbursements Disbursements Cash & Invstmt Balance 08/01/08 Per Attached Per Attached Balance 08/01/08 08/13/08 List of Bills List of Bills 08/13/08 General Fund 7,610,391 1,241,922 200,782 8,651,531 SDecial Revenue Funds Refuse Disposal Fund 1,381,225 19,204 1,400,429 Motor Fuel Tax Fund 129,258 123,493 29,593 223,158 Community Development Blk Grant Fund (28,764 ) 8,220 13,695 (34,239) Asset Seizure Fund 63,312 63,312 DEA Shared Funds 50,617 50,617 DUI Fine Fund 12,125 12,125 Foreign Fire Tax Board Fund 69,246 69,246 Debt Service Funds 4,614 118,981 123,595 Capital Proiects Funds Capital Improvement Fund 616,857 118,981 47,389 688,449 Downtown Redevelopment Const Fund 545,358 13,657 531,701 Street Improvement Construction Fund 547,187 120,444 9,359 658,272 Flood Control Construction Fund 482,755 6,290 476,465 Enterprise Funds Water & Sewer Fund 5,534,708 356,731 13,220 5,878,219 Village Parking System Fund 130,283 4,490 134,773 Parking System Revenue Fund (13,835) 4,203 (9,632) Internal Service Funds Vehicle Maintenance Fund 446,795 43,169 403,626 Vehicle Replacement Fund 6,594,361 6,333 6,588,028 Computer Replacement Fund 765,454 32,040 733,414 Risk Management Fund 3,374,670 17,136 455,512 2,936,294 Trust & Agencv Funds Police Pension Fund 40,870,737 40,870,737 Fire Pension Fund 41,227,216 41,227,216 Flexcomp Trust Fund 36,310 118 6,572 29,856 Escrow Deposit Fund 1,794,978 35,870 12,327 11 ,31 0 1,807,211 Series 2002 Library Bond Escrow 856 856 112,246,714 2,169,793 889,938 11,310 113,515,259 TOTAL DISBURSEMENTS PER ATTACHED LISTS OF BILLS 901,248 :EPORT: APBOARDRPT GENERATED: 12 FEB 08 12:17 RUN: TUESDAY AUGI22008 16:45 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 01 2008 TO AUGUST I3 2008 -.............. --.. --- --.... ---......................... --- --- --................ --..................... ---............................................ --................................. --.. --........... --.. ..--_............. -- ---.................. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ...-.... ---.... ---............. -- --... ----... --.... --............. --........... ---.. --.......... --.... -- -- ----......-............ --.............. ---.............. -- --................. --.................... --.................. --.. 01 10003 ACCOUNTEMPS TEMP .HELP-ACCOUNTS PAYABLE 1886.40 02955 ACME TRUCK BRAKE & SUPPLY CO. HUB CAP 62.94 01135 ADVANCED SYSTEMS GROUP, INC. MAINTENANCE AGREEMENTS 1245.00 01246 AIRGAS NORTH CENTRAL OXYGEN SUPPLIES 153.60 01335 ALEXIAN BROTHERS MEDICAL CENTR SEMINAR: PARKINSON I S DISEASE 50.00 10846 AMERICAN RED CROSS EMERGENCY PREPARDNESS KITS 23918.00 10769 ANDAX INDUSTRIES, LLC Absorbant Boom Absorbant Pad, 274.00 FREIGHT CHARGES FOR S008490 51.88 ------------- 325.88 09716 APEHAREX HEALTHCARE PRODUCTS MEDICAL SUPPLIES PILL BOXES 475.00 02001 ARAMARK UNIFORM SERVICES, INC. UNIFORM RENTAL MECHANICS 111.3 6 02108 ARLINGTON POWER EQUIPMENT PARTS FOR HONDA 599.00 02270 AT&T SERVICE-ACC# 841298-54147966 290.89 05044 A VIS RENT A CAR SYSTEM TAC UNIT LEASE - JUNE, 2008 984.29 02398 B & H INDUSTRIES 128 BOND COPIES 1152 SQ FT 207.36 02405 B & H PHOTO/VIDEO SHIPPING-SHORTAGE INV#31073173 IUD 02472 BAHNMAIER, IRENE VOLUNTEER DRIVER REIMBURSEMENT 38. SO 10128 BALDINI, CAROL WATER COOLER-SENIOR ACTIVITIES 17.99 06287 BEDCO MECHANICAL REPAIRS TO CARRIER ROOFS 2293.70 05600 BENCIC, CHARLES VOLUNTEER DRIVER REIMBURSEMENT 52.50 07142 BENNETT, CHARLES VOLUNTEER DRIVER REIMBURSEMENT 31.50 02757 BESSE MEDICAL SUPPLY MEDICAL SUPPLIES-BATTERIES 4.80 02935 BOURBONNAIS SUPPLY, INC. 2 - 041350 ROOT CYLINDER 135.71 6 - 041200 ROOT HINGE SHAFT 429.00 6 - 041300 ROOT MOUNTING TUBE 651.00 ESTIMATED FREIGHT 100.00 ------------- 1315.71 07930 BROGAN, KIRSTEN VOLUNTEER DRIVER REIMBURSEMENT 35.00 10847 BULLOCK, BRAD & ELI ZABETH REAL ESTATE TAX REBATE 650.00 05707 CASH FRIEDRICH'S DONATION-PW PICNIC 500.00 REPORT: APBOARDRPT GENERATED: 12 FEB 08 12: 17 RUN: TUESDAY AUG122008 16:45 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 01 2008 TO AUGUST 13 2008 ......... -_..... --... ---............................................. --.......... --... --................ --..... --................... ---......................... --............................. --................. --..... ---.. -- --.. ---........ --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ........ .............. --...-............ --.. --........ --............................ --........... --............. ---........ --.... --.............. --....... --........ --.................... -.......-... ---........ ----... --- -- --.... -_.....-- 01049 CDW GOVERNMENT, INC APC REPLACEMENT BATTERY 278.00 TRIPPLITE UPS 1000VA 238.00 SHIPPING 20.24 4 - 2009 Garmin GPS Map Update 223.40 ------------- 759.64 09610 CERTIFIED FLEET SERVICES, INC. COMMAND LIGHT SWITCHES 32.14 01061 CERTIFIED LABORATORIES 2 - 55 Gallon Barrels of 15W 4 2090.00 01084 CHICAGO TRIBUNE PERSONNEL RECRUITMENT 419.00 01088 CHIEF SUPPLY CORP. THREE RADIO BATTERIES 149.97 10848 CLARK ASSOCIATES, INC. SUPPLIES FOR HOME DELIV. MEALS 355.61 06670 CLARTON, FRANK VOLUNTEER DRIVER REIMBURSEMENT 31.50 08865 CLOSED CIRCUIT INNOVATIONS, INC. IVACS MAINTENANCE AGREEMENT 427.00 09422 COLACICCO, CAROL VOLUNTEER DRIVER REIMBURSEMENT 66.50 08751 COSTCO 2008-2009 MEMBERSHIP RENEWAL 370.00 06745 CROWN TROPHY RI BBONS / STREAMERS- ART S FESTIVA 96.62 01218 DAHLBERG, JOHN REFRESHMENTS FOR BOFPC 349.64 REIMBURSEMENT- FLORAL DELIVERY 110.00 ------------- 459.64 05153 DIALOGIC COMMUNICATIONS CORP. DCC ANNUAL SUPPORT 3265.00 10102 DOWLING, JOAN & ED VOLUNTEER DRIVER REIMBURSEMENT 42.00 01313 DUPAGE TOPSOIL INC. 2 LOADS OF PULVERIZED TOPSOIL 486.00 10858 DYNAMIC LIVING INC EQUIP-SENIOR TELEMERG.HELP SYS 91.49 01329 EL-DINARY, SAID VOLUNTEER DRIVER REIMBURSEMENT 59.50 06160 ENTERPRISE RENT-A-CAR RENTAL OF 4 CARS $650.00 PER M 350.00 RENTAL OF (1) PICK UP TRUCK 880.00 ------------- 1230.00 01356 ENVIRONMENTAL SAFETY GROUP, INC SHIPPING 35.28 2 SENSIT GOLD CGI - Gas Meter 3240.00 ------------- 3275.28 01361 ESRI INC. ESRJ ANNUAL MAINTENANCE (GIS) 14600.00 09653 ETERNO, DAVID G. JUL Y '08-HEARING FEES 72 4.5 0 REPORT: APBOARDRPT GENERATED: 12 FEB 08 12: 17 RUN: TUESDAY AUGI22008 16:45 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 01 2008 TO AUGUST 13 2008 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ........... --......... --.... --..... -- --.. -.................. -- --.......... --....... --..... ....-.......................................... --.... -- --.................... -- ---.................... --.. --- --.... -- --....... --............- 10851 EVANS, SUSAN REAL ESTATE TAX REBATE 790.00 01377 FEDERAL EXPRESS CORP PICK UP OF 3 SHIPMENTS 162.44 SHIPPING 21.18 ---------..--- 183.62 10860 FELDCO PLAN REVIEW FEE REFUND 25.00 PLAN REVI EW FEE REFUND 25.00 ------------- 50.00 00331 FIGOLAH, MICHAEL LUNCH-CONTRCTN MGMT COMMETTEE 67.00 LUNCH-PHASE I COMMITTEE 07/15 112.48 ------------- 179.48 01429 FORESTRY SUPPLIERS INC. 35' LOGGERS TAPE 16 4.5 8 10859 FRI DMAN, LEO PLUMBING REFUND 25.00 PLUMBING REFUND 8.00 ------------- 33.00 01443 FRIES AUTOMOTIVE SERVICES, INC VEHICLE #515 TOWED 305.00 10770 GARVEY'S OFFICE PRODUCTS OFFICE SUPPLIES 311.24 01488 GILLIGAN, FRANK VOLUNTEER DRIVER REIMBURSEMENT 35.00 08154 GLOBAL EMERGENCY PRODUCTS AIR COMPRESSOR & STEPS - #515 398.71 01522 GRAINGER INC. RANDOM SUPPLIES 22 .51 05519 GRAPHIC ENTERPRISES K & E 3036 PLAN COPIER BI -MONT 40.11 10386 GUZIEL, FRAN BLOCK PARTY-GRAPHIC DESIGN SVC 2585.00 07757 HEARTLAND SERVICES Repair Mouse Pad on #523 Veh L 250.37 10854 HINDMAN, LINDA VOLUNTEER DRIVER REIMBURSEMENT 3.50 04360 HOLTZ, RAY VOLUNTEER DRIVER REIMBURSEMENT 45.50 09425 HSBC BUSINESS SOLUTIONS INV #045675 172.56 INV #047392 548.71 INV #077303 14.89 INV #017153 78 .14 INV #052254 199.87 INV #077303 43.16 INV #077697 39.99 INV #065277 35.60 ------------- 1132.92 0165B ILCMA ANNUAL DUES 158.50 REPORT: APBOARDRPT GENERATED: 12 FEB 08 12: 17 RUN: TUESDAY AUGI22008 16:45 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 01 2008 TO AUGUST 13 2008 ............ - ---...... -_........................ --.... --.............. --........ ----................ -----...................... --........................ --.. -- --.. ----......... --................................. --.... ---.. -................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ......... --.......... ---............. --..... --..................... ...-.. --... -----.......... --................ --.......................... -- --....-.... ---.. --.. -- ----...... -_.... --.. -_.......- ---...... --.. -... ---.. ----- 07367 ILLINOIS CENTURY NETWORK PORT CHARGES-Tl/BANDWITH-l.5M 310.00 07430 ILLINOIS ENVIRONMENTAL HEALTH ASSC. '08-FOOD SAFETY CONFERENCE 50.00 '08-FOOD SAFETY CONFERENCE 50.00 ------------.. 100.00 01704 ILLINOIS PUBLIC HEALTH ASSOC '08-IL. SAFETY FOOD SYMPOSIUM 90.00 07433 IMAGETEC LP ID #90133770126 COPIER LEASE 275.00 ID #90133643910 COPIER LEASE 320.35 ID #90133770131 COPIER LEASE 390.00 ID #90133759828 356.00 ID #90133770128 COPIER LEASE 356.00 ID #90133759827 COPIER LEASE 275.00 ID #90133686576 COPIER LEASE 320.35 ID #90133643931 COPIER LEASE 586.13 ------------- 2878.83 10788 INDUSTRIAL FIRE WORLD Subscription/ Dawson for (3) Y 59.95 01725 INLAND DIESEL, INC. KIT FILTERS 215.06 01753 I PELRA IPERLA TRAINING 9/12/08 50.00 10853 JHL SUPPLY 800 EMERGENCY PONCHOS 637.00 01774 JIRAK, JIM & HAZEL VOLUNTEER DRIVER REIMBURSEMENT 35.00 01794 KALE UNIFORMS, INC. DRESS UNIFORM 25.00 04219 KIWANIS CLUB OF MT. PROSPECT MEMBERSH I P (VALENTINE - 20 0 8 260.00 05336 KLEINSTEIN, HOWARD TELLY AWARDS ACCEPTANCE FEE 325.00 SCSI CABLE-EXTERNAL HARD DRIVE 99.90 CREW MEAL - 4TH OF JULY PARADE 34.93 ------------- 459.83 04606 KNOX COMPANY 10 - Knox Boxes 1905.00 10798 KOEPKE, CRAIG REFUND-SIDEWALK COST SHARE FEE 96.DO 01838 KRAMER TREE SPECIALISTS REMOVAL OF TREES 1995.00 06855 KUSSMAUL ELECTRONICS Auto Eject Repair - Stock 13 4.2 5 09600 LASERFICHE USING LASERFICHE TRAINING 700.00 09918 LAUBE CONSULTING GROUP LLC FINAN .ADVISORY WORK-RANDHURST 1580.00 04744 LAW ENFORCEMENT LEGAL REVIEW SUBSCRIPTION RENEWAL 98.00 10861 LEANE, LORI OVERPAYMENT OF VEHICLE LICENSE 31.00 08631 LECHNER AND SONS 2008 UNIFORM RENTAL AND CLEANI 116.66 REPORT: APBOARDRPT GENERATED: 12 FEB 08 12:17 RUN: TUESDAY AUG122008 16: 45 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 01 2008 TO AOGUST 13 2008 .. -- -................ --................ -- -.. --- --............................ -- -..... ---...... ----.......... --................... -- --........ --........ --.. --.. -- --....... --..................... ----......................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .............................. --.. --.......... --............. --...... -- ----...... -- --............. ----................. --..................................... --................... --................. --..... --........ -- --.. -- --.......... 07923 LINSKEY, BARBARA & ED VOLUNTEER DRIVER REIMBURSEMENT 38.50 01915 LONDIN, RAY VOLUNTEER DRIVER REIMBURSEMENT 56.00 01918 LONDSTROM I S NURSERY, INC. TURF MOWING - VARIOUS LOCATION 3492.22 LANDSCAPE MAINTENANCE THROUGHO 7448.78 ------------- 10941.00 09238 LYONS, PATRICK REIMBURSMNT:CRIME FREE HOUSING 682.86 09163 MAALA, MARIO VOLUNTEER DRIVER REIMBURSEMENT 38.50 10857 MABAS DIVISION 3 INTERDISIONAL DRILL-MAY 2008 1890.36 01941 MALCOLM, JOHN EXPENSES: FIRE RESCUE' 08-DENVER 1644.00 10850 MARABOTTI, ANTHONY OVERPAYMENT OF TICKET 36.00 10308 MARK DRUG EQUIPMENT /SUPPLIES-LEND. CLOSE 4633.25 05021 MENARDS 3 GARDEN NOZZLES 16.86 06719 METEORLOGIX ANNUAL RENTAL OF WEATHER 824.00 ANNUAL RENTAL OF WEATHER 25.00 ------------- 849.00 06291 METROPOLITAN IND., INC. SEAL/SLEEVE/O-RING FOR PUMP #2 658.00 02826 MICHAEL WAGNER & SONS, INC. WATER SUPPLY REPAIR PARTS 307.33 WATER SUPPLY REPAIR PARTS 581.00 ------------- 888.33 04322 MIDDLETON, JOAN MILEAGE-GMIS, BARTLETT 23.40 BATTERY FOR BLACKBERRY 63.85 ------------- 87.25 02028 MIGHTY MITES AWARDS & SONS PLAQUE FOR C. CALDWELL 234.70 02046 MOBILE PRINT INC. BLOCK PARTY POSTCARDS 292.80 SUPPLES 61.11 MEMO PADS & BUSINESS CARDS 118 .3 4 WINDOW ENVELOPES 248.32 ------------- 720.57 08761 MOORE MEDICAL MEDICAL SUPPLIES 454.02 02112 NATIONAL ASSN. OF SOCIAL WORKERS RENEWAL 230.00 10562 NATURESCAPE DESIGN, INC. LAWN SPRINKLER MAINTENANCE AT 728 . 50 02148 NEOPOST INC. MONEY ENTERED INTO POST .MACHIN 3000.00 mORT: APBOARDRPT GENERATED: 12 FEB 08 12:17 RUN: TUESDAY AUG122008 16: 45 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 01 2008 TO AUGUST 13 2008 ~......... -- --........................... ---............. -- --...... ---........................ --......... --......... ---......... -- --...... -- --............................. --.......................................... -- --... --.................. --..................... ---...... --... --............... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ~...................................................... -- ----...... --...... --..... --................................. --.................. --......... --......... --............................. -_.....................................-.. --............................................ --.................. --... ---... ---- 02155 NEXTEL COMMUNICATIONS PHONE SERVICE 920.41 PHONE SERVICE 162.00 PHONE SERVICE 79.51 PHONE SERVICE 592.07 PHONE SERVICE 27 .42 PHONE SERVICE 229 .3 6 PHONE SERVICE 1409.80 PHONE SERVICE 120.00 PHONE SERVICE 193.34 PHONE SERVICE 461.40 PHONE SERVICE 22.58 PHONE SERVICE 330.95 ----.._------- 4548.84 05236 NFPA NFPA MEMBERSHI P-W. SCHROEDER 150.00 10497 NORTHWEST CENTRAL 9-1-1 SYSTEM STATION ALERTING FEE 4400.00 02196 NORTHWEST MUNICIPAL CONFERENCE 2008-2009 NWMC MEMBERSHIP DUES 24062.00 05124 NORTHWESTERN UNIVERSITY LODGING-D. ZBORIL&COMMAND SCHOO 6495.00 02228 OAKTON PAVILLION HEALTHCARE 880 HOME DELIVERED MEALS 2200.00 10003 OFFICETEAM TEMP .HELP-CUSTOMER SERVICE 892.50 02256 PADDOCK PUBLICATIONS DAILY HERALD JOB AD-AlP COORDI 2525.01 PERSONNEL RECRUITMENT 1575.00 PUBLICATION OF BID NOTICES 75.60 ------------- 4175.61 10862 PETRICCA, DAVID RE- INSPECTION REFUND 50.00 02315 PIONEER PRESS SUBSCRIPTION FOR 2008 25.00 02327 POMP'S TIRE SERVICE, INC. 2 - Tires 425/65R 22.5 Vehicle 1035.00 07927 POORE, MURIEL VOLUNTEER DRIVER REIMBURSEMENT 45.50 10258 POWELL TREE CARE, INC. 2008 PARKWAY TREE REMOVAL CONT 6782.00 02339 PRCHAL, ARLENE & PAUL VOLUNTEER DRIVER REIMBURSEMENT 45.50 02355 PRO FINISH WASH MOP ASSY!INTERIOR SHAMPOO 17 7.2 8 04954 PRO MIX AUDIO AND LIGHTING RENTAL OF SOUND EQUIPMENT 205.00 10646 RANDMARK, CLYDE VOLUNTEER DRIVER REIMBURSEMENT 10.50 02382 RCM & ASSOCIATES VOICE TUBE-SWITCHBOARD HEADSET 5.95 02399 REBEL'S TROPHIES, INC. NAMEPLATE & RETIREMENT PLAQUES 17 4.94 02424 REX RADIATOR SALES & DISTRIBUTION, INC AC COMPRESSOR 264.00 REPORT: APBOARDRPT GENERATED: 12 FEB 08 12:17 RUN: TUESDAY AUG122D08 16:45 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 01 2008 TO AUGUST 13 2008 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRI PTION AMOUNT 02448 ROEDA SIGNS INC. OUTDOOR SIGN (MPPD PATCH) 780.33 02465 ROTARY LUNCH CLUB MT. PROSPECT /PROSPECT HTS MEMBERSHIP DUES 203.00 ROTARY DUES 203.00 ------------- 406.00 00425 RZEPECKI, ROBERT L. REIMBURSEMENT:TRAINING CONFERE 920.84 02525 SECRETARY OF STATE VEHICLE TAPE 500.00 LICENSE PLATES & TITLES 1001.00 LICENSE PLATES & TITLES 150.00 ------------- 1651.00 07127 SERVICE SANITATION, INC. RESTROOM AND HANDWASH RENTAL 1280.00 06671 SHEEHAN, DOT & JACK VOLUNTEER DRIVER REIMBURSEMENT 52.50 02542 SHEPP PEST CONTROL MONTHLY PEST CONTRACT SERVICES 425.00 05019 SILL, GREGORY REIMBURSEMENT:TRAINING CONFERE 259.00 10090 SIWAK, FRANK EXPENSES :MAVRON VEHICLE BUILD 120.47 09997 SOBCZAK, EMILIA VOLUNTEER DRIVER REIMBURSEMENT 63.00 02601 SPRING ALIGN OF PALATINE 2 REAR SPRINGS-V#517 & #522 3165.40 10228 STANDARD & ASSOCIATES RECRUIT TESTING PROCESS 10319.02 09165 STAPLES BUSINESS ADVANTAGE SUPPLIES 205.68 10320 SUBURBAN TRIM & GLASS Replaced Hose Bed Cover for #5 975.00 09915 SUPER WAREHOUSE GOV Q5942X HP Toner 388.00 QH-4250MICR Toner Cartridge MI 284.00 ------------- 672.00 02672 SYSTEMS FORMS, INC. HOUSING INSPECTION FORMS 97.00 04532 TAYLOR RENTAL CENTER RENTAL OF TENTS&TABLES-FESTIVA 2071.60 02691 THOMPSON ELEVATOR INSPECTIONS ELEVATOR INSPECTION 74.00 ELEVATOR INSPECTION 37.00 ------------- 111.0 0 10461 UHLAND, ROBERT REAL ESTATE TAX VOl D 1065.00 05567 UNITED VISUAL, INC. EQUIP .MAINTENANCE-SONY DSR-11 780.00 D2762 UNIVERSITY OF ILLINOIS - URBANA CHAMPAIGN HOMEOWNERS I GUIDE-GYPSY MOTH 109.50 10531 VCG UNIFORM Various Uniforms & Footwear 301.20 REPORT: APBOARDRPT GENERATED: 12 FEB 08 12:17 RUN: TUESDAY AUG122008 16:45 RELEASE I D : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 01 2008 TO AUGUST 13 2008 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOONT - -.... -......... --.. -_................ ---.................... --...................... --............ -_...................... --.............. --.. -- ---......... --............................................. -... ----.......... --.. -_....- Various Uniforms & Footwear 372.65 Various Uniforms & Footwear 753.45 ------------- 1427.30 02802 VILLAGE OF ARLINGTON HEIGHTS Registration/ Kenneally FAE Ju 450.00 02835 WAREHOUSE DIRECT COPY PAPER & TONERS 514.64 OFFICE SUPPLIES 227 . 49 SUPPLIES 125.89 ------------- 868.02 02876 WILKS I I RVANA REIMBUSEMENT:AT&T BILL-BLACKBE 45.00 09594 WINNING MIND TRAINING INC. VERBAL TRAUMA CONTROL TRAINING 5986.16 10863 YOU I TOM REBATE- 3 SQRS OF PUBLIC WALK 144. 00 TOTAL 200781.57 150 01148 COMMONWEALTH EDISON STREET LIGHTING 27760.56 05709 MEADE ELECTRIC CO. INC. 2008 TRAFFIC SIGNAL MAINTENANC 1832.00 TOTAL 29592.56 170 01050 CEDA NORTHWEST SELF -HELP CTR 2ND QTR '08-DAY CARE PROGRAM 2500.00 2ND QTR '08-EMERGENCY HOUSING 1875.00 ------------- 4375.00 04434 GEWALT HAMILTON ASSOCIATES, INC. ENGINEERING SERVICES ALGONQUIN 6319.8 5 10223 HIGHER UP MINISTRIES 1ST-2ND QTR'08-JOB TRAIN.PROGR 1750.00 02420 RESOURCES FOR COMMUNITY LIVING RCL-2ND QTR 2008 1250.00 TOTAL 13694.85 10 10348 DAVID L.F.WILSON & COMPANY/INC. PROJECT MEETINGS, SITE VISITS 2420.00 02583 SOUND INCORPORATED CISCO WIRELESS EQUIPMENT 10740.50 06406 SRBL ARCHITECHTS, LTD. Archi tectural Services for Fir 31728.35 Professional Services in manag 2500.00 ------------- 34228.35 TOTAL 47388.85 50 08319 CRESCENT ELECTRIC SUPPLY CO HOFFMAN ELECTRICAL HEATER 703.96 REPORT: APBOARDRPT GENERATED: 12 FEB 08 12:17 RUN: TUESDAY AUG122008 16:45 RELEASE rD : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 01 2008 TO AUGUST 13 2008 ...... - --................ - --.. --.. -.. --.... ...... -- ---................. --- --........ -- --...... -.............. ----........ --...... --............ --........ --....... --.............. -_............ -----.. ----.. ---.... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ..................... ---.................. --...... --......... --.... --...... -....... --.. ----.......... --.............. --...... --....... -- --......................... --.............. ---.... --.... --.. --.. ----.. ---.... --..- 06420 GRA YBAR ELECTRIC CO. ELECTR. PARTS-DOWNTOWN STREERSC 1336.24 10432 STERNBERG LIGHTING INC. 12 - STERNBERG 453/5P SLIP 3" 7816.56 10772 TOWN & COUNTRY UNDERGROUND, LLC SPRINKLER SYSTEM PIPE 3800.00 TOTAL 13656.76 560 10729 AUTOMN LANDSCAPING INC STREET RESORFACING/RESTORATION 9359.00 TOTAL 9359.00 590 01838 KRAMER TREE SPECIALISTS REMOVAL OF TREES 5940.00 1025B POWELL TREE CARE, INC. TREE REMOVAL 350,00 TOTAL 6290.00 610 09673 APWA- IPSI REGISTRATION FEE - ANNUAL IPSI 650.00 02451 BADGER METER INC WATER METER REPAIR PARTS 593.69 WATER METER REPAIR PARTS 205.16 ------------- 79B.85 08567 BANK OF NEW YORK REFUND OF FINAL BILL-WATER 121.50 REFUND OF FINAL BILL"SEWER 39.42 ------------- 160.92 06476 BURNS & MCDONNELL ENGINEERING BID DOCS-WATER DISTRICT SYSTE 750.00 06160 ENTERPRISE RENT-A-CAR RENTAL OF 4 CARS $650.00 PER M 2250.00 OB567 ETCHINGHAM, ROBERT REISSUED CHECK 17.82 01544 HBK WATER METER SERVICE WATER METER INSTALLATION 1784.00 WATER METER INSTALLATION 3257.00 ------------- 5041.00 05927 JRC CONSTRUCTION METER FEE REFUND 125.00 WATER TAP FEE REFUND 375.00 ------------- 500.00 08631 LECHNER AND SONS 2008 UNIFORM RENTAL AND CLEANI 116.66 01918 LUNDSTROM I S NURSERY, INC. TURF MOWI NG - VARIOUS LOCAT ION 424.60 IOB52 MCKEWEN, J. REFUND FINAL UTILITY BILL 49.02 09605 MURPHY, DANIEL J. HYDRANT PAINTING SERVICES 830.00 ~EPORT: APBOARDRPT GENERATED: 12 FEB 08 12:17 RUN: TUESDAY AUG122008 16:45 RELEASE ID : PAGE 10 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 01 2008 TO AUGUST 13 2008 - -.. - -................................................. ---....... ---.. --.... ---.... --....... --........ --.................. --.... --................ --........... --...... --................................. -- -- --- -- -- --- --.... --........ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -........ -- --..... --.............................. -- ---.. --.. --.... -_...................................... --............................... -- --........ --......... --................. --................... --... --.......... --......... --...................... 02155 NEXTEL COMMUNICATIONS PHONE SERVICE 688 .3 0 PHONE SERVICE 39.76 ------------- 728.06 09975 OSBURN, LARRY W. OR LOIS I. REFUND FINAL UTILITY BILL 86.32 02655 SUBURBAN LABORATORIES, INC. CONTRACT FOR LAB TESTING - WAT 817.00 TOTAL 13220.25 i60 09676 AMERICAN MESSAGING PAGER MESSAGING SERVICE 63.52 02108 ARLINGTON POWER EQUIPMENT OIL FILLER CAP/WEED WHIP LINE 83.11 10287 ASHLAND, INC. SYNPOWER MOTOR OIL 1749.83 06642 BRISTOL HOSE & FITTING PARKER HYDRAULIC HOSE ASSEMBLY 195.66 01006 BUSSE CAR WASH, INC. CAR WASHES 7/1/08 - 12/31/08 877 . 50 10849 CHICAGO JACK SERVICE, INC REPAIR MILWAUKEE 10l-Z11596 295.00 05579 ELMHURST LINCOLN MERCURY FORD SERVICES/PARTS-V#P-5/P- 34 655.54 REPLACE ABS MODULE-V #P-16 573.43 ------------- 1228.97 01443 FRIES AUTOMOTIVE SERVICES, INC TOW VEHICLES #2722, P-18 & P-9 240.00 00342 GUENTHER, JAMES E. MECHANIC TOOL ALLOWANCE 490.00 04055 HARRIS EQUIPMENT IN LINE AIR$AIR FILTER ELEMENT 159.82 10792 J.RUBIN & CO. STEEL AND ALUMINUM STOCK 52.80 06691 JUST TIRES 12 - P235/55WR17 GOODYEAR EAGL 1150.32 STATE TIRE FEE 30.00 8 - 748-747-188-0 GOODYEAR 976.40 STATE TIRE FEES 20.00 ------------- 2176.72 01872 LATTOF ARLINGTON HEIGHTS MONTHLY PARTS & SERVICE-JULY08 288.00 MONTHLY PARTS & SERVICE-JULY08 168.54 -----------..- 456.54 02155 NEXTEL COMMUNICATIONS PHONE SERVICE 319.58 02327 POMP'S TIRE SERVICE, INC. FIRESTONE TRANSPORT AT 348.24 07663 PRAIRIE INTERNATIONAL TRUCK SALES MUFFLER AND SUPPORT 302.01 OVERAGE ON P.O. #S008574 82.64 IH/NAVISTAR PARTS 1501.04 ------------- REPORT: APBOARDRPT GENERATED: 12 FEB 08 12: 17 RUN: TUESDAY AUG122008 16:45 RELEASE ID : PAGE 11 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AOGUST 01 2008 TO AUGUST 13 2008 -- -.... -........... --.................... --.................... --...................................... -- --................ --.......................... --................ -- -- --...... --..................... ---............ ---- --............ ----...... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ---.. -..-............... --....... --.......... --.................................. --....... --................ --................... --- --.......... --.. --........ --............... -_.................. --............ -- ---..-.................... --- 1885.69 07882 PRECISION SERVICE & PARTS AC DELCO FUEL PUMP MODULE 265.83 02402 REDISTRIP COMPANY MEDIA BLAST SMALL DUMP BODY 2138.40 09423 RONCO INDUSTRIAL SUPPLY ROLOC SANDING/GRINDING DISCS 471.61 02581 SOLVENT SYSTEMS INT I L. INC. WATER BASED PARTS CLEANER 300.00 02684 TERRACE SUPPLY CO. RENTAL OF WELDING GAS CYLINDER 14.40 02684 TERRACE SUPPLY COMPANY HELIUM & ACETYLENE CYLINDERS 348.68 0447 2 TEXOR PETROLEUM CO 87 OCTANE UNLEADED GASOLINE 29006.93 TOTAL 43168.83 670 01045 CATCHING FLUIDPOWER PARKER HYDRAULIC HOSE - FITTIN 5519.39 PARKER HYDRALIC HOSE 347.90 ------------- 5867.29 10792 J.ROBIN & CO. STEEL AND ALUMINUM STOCK 86.09 05721 LINE- X OF BARTLETT SPRAY ON BED LINER - V#4503 380.00 TOTAL 6J3 3.J 8 i80 05005 CDS omCE TECHNOLOGIES PANASONIC CHO RUGGEDIZED LAP 32040.00 TOTAL 32040.00 i90 07052 CHURCH OF THE NAZARENE LIABILITY CLAIMS 1000.00 01236 DAVE & JIM'S AUTO BODY, INC. ACCIDENT DAMAGE REPAIRS-V#P- 33 744.95 ACCIDENT DAMAGE REPAIRS-V#P- J3 934.40 ACCIDENT DAMAGE REPAIRS-V#P-ll 899.30 ------------- 2578.65 01102 GAB ROBINS N.A., INC - CITIBANK PAYMENT OF INSURANCE CLAIMS 9341.99 05943 IL DEPT. OF EMPLOYMENT SECURITY UNEMPLOYMENT BENEFITS-2ND QTR 3321.00 01737 INTERGOVERNMENTAL PER. BEN .COOP CALIMS ADMIN. -MEDICAL 21370.00 HMO MEDICAL 110537.00 LIFE INSURANCE 2859.00 PPO MEDICAL CLAIMS 272199.27 ------------- 406965.27 07052 INTERNATIONAL CHORCH OF THE NAZARENE LIABILITY CLAIMS 20000.00 REPORT: APBOARDRPT GENERATED: 12 FEB 08 12: 17 DEPT VENDOR NBR 10865 770 08178 790 10856 07433 01719 10037 02689 02886 RUN: TUESDAY AUG1220D8 16: 45 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 01 2008 TO AUGUST 13 2008 VENDOR NAME LEON-SOTO SINFORIANO GUARDIAN CARRANZA, NORMAN IMAGETEC L P NCPERS GROUP LIFE PARK, CHRISTINA THIRD DISTRICT CIRCUIT COURT WISCONSIN DEPARTMENT OF REVENUE INVOICE DESCRIPTION LIABILITY CLAIMS LIABILITY CLAIMS PAGE 12 AMOUNT 7500.00 4805.00 TOTAL 455511.91 12305.00 EMPLOYMENT DENTAL PLAN TOTAL 6571.70 6571.70 OVERPAYMENT OF TICKET SN #CUC363345 - COPIER LEASE PREMIUM FOR AUGUST 2008 SUPPLI ES FOR SCHOOL PROGRAM BOND MONEY BOND MONEY BOND MONEY WISC. INCOME TAX FOR JULY '08 TOTAL GRAND TOTAL 5.00 750.00 720.00 45.96 3759.00 2920.00 3080.00 9759.00 1047.09 12327.05 889936.71 lEPORT: APBOARDRPT GENERATED: 12 FEB 08 12: 17 RUN: TUESDAY AUG122008 16:45 RELEASE ID : PAGE 13 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM AUGUST 01 2008 TO AUGUST 13 2008 SUMMARY BY FUND 001 GENERAL FUND 200781.57 050 MOTOR FUEL TAX FUND 29592.56 070 COMMONITY DEVELPMNT BLOCK GRNT 13694.85 510 CAPITAL IMPROVEMENT FUND 47388.85 550 DOWNTOWN REDEVLPMNT CONST 13656.76 560 STREET IMPROVEMENT CONST FUND 9359.00 590 FLOOD CONTROL CONST FUND 6290.00 610 WATER AND SEWER FUND 13220.25 660 VEHICLE MAINTENANCE FUND 43168.83 670 VEHICLE REPLACEMENT FUND 633 3.3 8 680 COMPUTER REPLACEMENT FUND 32040.00 690 RISK MANAGEMENT FUND 455511.91 770 FLEXCOMP ESCROW FUND 6571.70 790 ESCROW DEPOSIT FUND 12327.05 -------------- TOTAL : 889936.71 08/12/08 Village of Mount Prospect Page 1 EMR025 List of Escrow Checks Presented to the Board of Trustees 08/01/08 To 08/13/08 Paid to Permit # Check # Amount AGT ELECTRIC 081122 13008808 125.00 ALTRA CONSTRUCTION 072638 13008298 200.00 081504 13008809 200.00 400.00 * ARK SEWER & DRAIN 081612 13008810 125.00 ARLINGTON SEALCOATING 081578 13008811 150.00 ARROW ROAD CONSTRUCTIO 072729 13008812 1,000.00 BISHOP PLUMBING INC 080032 13008813 125.00 CENTRAL PLUMBING 081688 13008814 125.00 CLARKE, VINCENT M 080519 13008815 500.00 DAVIE, PATRICIA S 081558 13008816 125.00 DI PRIMA, DAVID A 080864 13008817 500.00 FLUSH SEWER 081677 13008818 125.00 FORTIS CONCRETE CO INC 081133 13008819 200.00 FOUR SEASONS INC 081649 13008820 125.00 FRIDMAN, LEON 081724 13008821 125.00 GADGE SIGN CO 081546 13008822 125.00 HIGHLAND PARK ELECTRIC 080643 13008823 375.00 HOLDA-LIVING TRUST, EUGEN X. 081101 13008824 200.00 HOME DEPOT 080213 13008825 200.00 KBE INC 072815 13008826 125.00 KOCH, MARK 072165 13008827 450.00 LESNIAK, KLAUDIA 062270 13008828 500.00 LY, MINH 081424 13008829 200.00 MARIO GAMBINO & SONS LANDSCAPING IN 081192 13008830 200.00 MATECKI, HENRY 081274 13008831 200.00 MONDI, LEONARD 072727 13008832 75.00 MONTESINOS, ABEL 080533 13008833 125.00 MT PROSPECT HEATING & A/C 081682 13008834 125.00 MYRDA, STANISLAW 070688 13008835 200.00 NSI SIGNS INC 080898 13008836 125.00 OLYMPIC SIGNS 080117 13008837 125.00 OUTBACK BUILDERS 080182 13008838 850.00 PAINT IT THE TRUTH INC 080339 13008839 10.00 PSARROS, HARRY 071893 13008840 125.00 RAMEL, FREDERICK J 081392 13008841 200.00 SCHMOLDT, JOHN 080946 13008842 200.00 SEARCH INC 080246 13008843 200.00 STAY FIT 080370 13008844 1,000.00 SUNBRICK PAVERS 080517 13008845 200.00 TONTO CONSTRUCTION 080084 13008846 500.00 U S WATERPROOFING 081523 13008847 125.00 WEATHER SEAL NU-SASH 072519 13008848 400.00 ZIECINA, JERRY 081222 13008850 200.00 08/12/08 EMR025 Paid to Village of Mount Prospect List of Escrow Checks Presented to the Board of Trustees 08/01/08 To 08/13/08 Page 2 Zajac, Bogdan Permit # 081559 Check # 13008849 Amount 200.00 *** TOTAL NUMBER OF CHECKS 44 11,310.00 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES July 1 - July 31, 2008 08/12/2008 09:13:46 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/08 - 07/31/08 Cur Mo Received Y-T-D Received 7 Months 5 Months 2008 Budget 58.3% 41. 6% 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 3,052 871,638 190,781 1,316,122 1,757,592 21,624 -25,704 13,882 228,310 178,638 4,555,935 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,087,785 123,088 113,985 o 10,534 522 35 1,981 58 11 223 563 o o 1,785 o o o 31,824 80,163 o o o 290,760 1,149 134,129 878 777,189 8,516 7,928 129,419 84,628 15,333 589,816 -31,269 94,897 o 1 6,566,224 6,466,996 2,162,708 8,072,568 11,785,432 356,972 -2,199,350 166,411 2,805,749 178,955 36,362,665 18,921,379 2,201,717 791,118 o 158,260 1,707 16,963 9,328 471 32 186,357 441,648 o o 592,559 o o o 109,893 275,483 o o o 588,528 721,896 549,257 8,858 5,729,359 66,918 60,534 908,498 613,367 109,127 3,910,610 -402,558 -208,789 o 13,873,756 15,725,500 3,283,900 17,776,476 22,086,337 598,500 6,702,250 220,000 5,535,386 2,560,000 88,362,105 39,377,831 4,438,000 1,685,000 1,000 746,976 3,000 2,500 21,250 42,500 o 398,500 926,000 o o 1,208,500 o o o 332,288 952,712 o o o 1,438,800 3,921,500 1,693,500 10,000 11,576,500 144,150 156,000 1,568,128 1,212,700 196,699 6,748,271 4,783,500 4,776,300 o 7,307,532 9,258,504 1,121,192 9,703,908 10,300,905 241,528 8,901,600 53,589 2,729,637 2,381,045 51,999,440 20,456,452 2,236,283 893,882 1,000 588,716 1,293 -14,463 11,922 42,029 -32 212,143 484,352 o o 615,941 o o o 222,395 677,229 o o o 850,272 3,199,604 1,144,243 1,142 5,847,141 77,232 95,466 659,630 599,333 87,572 2,837,661 5,186,058 4,985,089 o 52.7 58.9 34.1 54.6 46.6 40.4 132.8 24.4 49.3 93.0 58.8 51. 9 50.4 53.0 100.0 78.8 43.1 -578.5 56.1 98.9 53.2 52.3 51.0 66.9 71.1 59.1 81. 6 67.6 11.4 50.5 53.6 61. 2 42.1 49.4 44.5 42.1 108.4 104.4 08/12/2008 09:13:46 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/08 - 07/31/08 7 Months 5 Months 58.3% 41. 6% Completed Remaining Cur Mo Y-T-D 2008 Unreceived Unreceived Received Received Budget Balance Percent SSA #6 GEORGE/ALBERT B&I 5 145 0 -145 SERIES 2002 LIBRARY BND ESCROW 0 0 0 0 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 4,555,935 36,362,665 88,362,105 51,999,440 58.8 2 08/12/2008 09:14:23 FRRBRR03 SUM021 7 Months 5 Months 58.3% 41. 6% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/08 - 07/31/08 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 3,052 515,830 188,901 1,194,262 135,835 19,235 15,712 11,391 3,278 289 TOTAL GENERAL FUND 2,087,785 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE o 120,836 2,252 o TOTAL REFUSE DISPOSAL FUND 123,088 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 111,329 165 2,491 113,985 TOTAL MOTOR FUEL TAX FUND 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 10,531 3 o TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 10,534 ASSET SEIZURE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 413 109 TOTAL ASSET SEIZURE FUND 522 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 1 Y-T-D Received 4,970,820 3,154,804 2,148,491 7,160,211 792,605 330,294 144,270 146,198 73,080 606 18,921,379 972,684 1,199,783 28,992 258 2,201,717 766,278 14,923 9,917 791,118 o o o 127,329 19 30,912 158,260 878 829 1,707 o 35 16,598 365 2008 Budget 10,490,256 7,493,500 3,260,000 15,192,200 1,730,375 576,500 270,000 207,500 157,500 o 39,377,831 2,075,000 2,278,000 84,000 1,000 4,438,000 1,664,000 14,500 6,500 1,685,000 o o 1,000 o o 1,000 666,976 o 80,000 746,976 1,000 2,000 3,000 1,000 1,500 Unreceived Balance 5,519,436 4,338,696 1,111,509 8,031,989 937,770 246,206 125,730 61,302 84,420 -606 20,456,452 1,102,316 1,078,217 55,008 742 2,236,283 897,722 -423 -3,417 893,882 1,000 o 1,000 539,647 -19 49,088 588,716 122 1,171 1,293 -15,598 1,135 Completed Remaining Unreceived Percent 52.6 57.9 34.1 52.9 54.2 42.7 46.6 29.5 53.6 51. 9 53.1 47.3 65.5 74.2 50.4 53.9 -2.9 -52.6 53.0 100.0 100.0 80.9 61.4 78.8 12.2 58.6 43.1 ****.* 75.7 08/12/2008 09:14:23 FRRBRR03 SUM 021 7 Months 5 Months Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/08 - 07/31/08 Cur Mo Received TOTAL OEA SHARED FUNDS FUND 35 OUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 1,976 5 TOTAL OUI FINE FUND 1,981 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL FOREIGN FIRE TAX BOARD FUND 58 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME TOTAL SERIES 1987A B&I, PW FACILITY 11 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 223 o TOTAL SERIES 2001 B&I, VILLAGE HALL 223 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 563 o TOTAL SERIES 2003 B&I, VILLAGE HALL 563 SERIES 2002B B&I, PUBLIC BLOGS 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 o 1,785 o TOTAL SERIES 1999 B&I, TIF 1,785 2 Y-T-O Received 16,963 9,202 126 9,328 o 58 o o 471 o 471 o 11 184,854 1,503 o 186,357 437,866 3,782 o 441,648 o o o o o 581,243 11,316 o 592,559 2008 Budget 2,500 20,000 1,250 21,250 40,000 2,500 o 42,500 o 32 32 392,500 6,000 o 398,500 916,000 10,000 o 926,000 o o o o o 1,133,500 75,000 o 1,20B,500 o o o o o o Unreceived Balance o o 58.3% 41.6% Completed Remaining Unreceived Percent -14,463 -578.5 10,798 1,124 11,922 40,000 2,029 o 42,029 207,646 4,497 o 212,143 478,134 6,218 o 484,352 552,257 63,684 o 615,941 54.0 89.9 56.1 100.0 81.2 9B.9 o -32 -32 52.9 75.0 53.2 52.2 62.2 52.3 o o o o o 48.7 84.9 51.0 08/12/2008 09:14:23 FRRBRR03 SUM021 7 Months 5 Months 58.3% 41. 6% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/08 - 07/31/08 Cur Mo Y-T-D 2008 Unreceived Unreceived Received Received Budget Balance Percent 0 0 0 0 0 0 0 0 0 0 0 0 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 o o TOTAL SERIES 1998A B&I, FLOOD o SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME o o TOTAL SERIES 1998C B&I, TIF o IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 31,824 o 109,522 371 TOTAL IEPA FLOOD CONTROL LOANS B&I 31,824 109,893 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 79,727 436 274,382 1,101 TOTAL SERIES 2000 B&I, FLOOD CONTROL 80,163 275,483 SERIES 2002B B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o o o TOTAL SERIES 2002B BU, FLOOD o SERIES 1998A B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME o o TOTAL SERIES 1998A B&I, STREET IMP. o SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME o o TOTAL SERIES 2002B B&I, STREET IMP. o CAPITAL IMPROVEMENT FUND 41 OTHER TAXES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 111,551 o 860 383,904 18,750 7,525 3 o o o o o o o o o o o o 332,288 o 332,288 222,766 -371 222,395 947,712 5,000 673,330 3,899 952,712 677,229 o o o o o o o o o o o o o o o o o o o o 1,180,000 252,300 6,500 796,096 233,550 -1,025 Completed Remaining o o o o o o 67.0 66.9 71.0 78.0 71.1 o o o o o o o o o o 67.5 92.6 -15.8 08/12/2008 09:14:23 FRRBRR03 SUM 021. 7 Months 5 Months 58.3% 41. 6% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/08 - 07/31/08 Cur Mo Received 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES o o 178,349 TOTAL CAPITAL IMPROVEMENT FUND 290,760 DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES o 1,149 o o TOTAL DOWNTOWN REDEVLPMNT CONST 1,149 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 132,706 o 1,423 o o TOTAL STREET IMPROVEMENT CONST FUND 134,129 FLOOD CONTROL CONST FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 878 o TOTAL FLOOD CONTROL CONST FUND 878 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 o 1,420 763,497 11,212 o 1,060 o TOTAL WATER AND SEWER FUND 777,189 VILLAGE PARKING SYSTEM FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 460 7,935 121 o TOTAL VILLAGE PARKING SYSTEM FUND 8,516 4 Y-T-D Received o o 178,349 588,528 690,468 31,428 o o 721,896 518,929 o 21,377 8,951 o 549,257 o 8,858 o 8,858 753,744 8,410 4,865,153 78,589 o 23,463 o 5,729,359 o 5,807 59,940 1,171 o 66,918 2008 Budget 1,438,800 1,346,500 75,000 o 2,500,000 3,921,500 1,643,500 o 50,000 o o 1,693,500 o 10,000 o 10,000 1,508,500 16,000 9,780,000 250,000 2,000 20,000 o 11,576,500 45,000 7,900 90,250 1,000 o 144,150 Unreceived Balance o o o o o -178,349 850,272 656,032 43,572 o 2,500,000 3,199,604 1,124,571 o 28,623 -8,951 o 1,144,243 o 1,142 o 1,142 754,756 7,590 4,914,847 171,411 2,000 -3,463 o 5,847,141 45,000 2,093 30,310 -171 o 77,232 Completed Remaining Unreceived Percent 59.1 48.7 58.1 100.0 81.6 68.4 57.2 67.6 11.4 11.4 50.0 47.4 50.3 68.6 100.0 -17.3 50.5 100.0 26.5 33.6 -17.1 53.6 08/12/2008 09:14:23 7 Months 5 Months 58.3% 41. 6% FRRBRR03 SUM02l Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/08 - 07/31/08 Cur Mo Received PARKING SYSTEM REVENUE FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES o o o 7,928 o o o TOTAL PARKING SYSTEM REVENUE FUND 7,928 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 128,596 823 o TOTAL VEHICLE MAINTENANCE FUND 129,419 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 71,058 13,570 o o TOTAL VEHICLE REPLACEMENT FUND 84,628 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 13,886 1,447 TOTAL COMPUTER REPLACEMENT FUND 15,333 RISK MANAGEMENT FUND 44 46 47 48 CHARGES FOR SERVICE INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE 508,021 5,113 o 76,682 TOTAL RISK MANAGEMENT FUND 589,816 POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE -114,886 83,617 TOTAL POLICE PENSION FUND -31,269 FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 31,224 63,673 TOTAL FIRE PENSION FUND 94,897 5 Y-T-D Received o o o 60,534 o o o 60,534 900,162 8,336 o 908,498 497,408 115,959 o o 613,367 97,199 11,928 109,127 3,312.648 49,213 10,296 538,453 3,910,610 -1,514,349 1,111,791 -402,558 -1,227,630 1,018,841 -208,789 2008 Budget 55,000 o o 100,000 1,000 o o 156,000 1,543,128 25,000 o 1,568,128 852,700 300,000 o 60,000 1,212,700 166,699 30,000 196,699 5,545.185 110,000 4,000 1,089,086 6,748,271 2,641,000 2,142,500 4,783,500 2,731,000 2,045,300 4,776,300 Unreceived Balance 55,000 o o 39,466 1,000 o o 95,466 642,966 16,664 o 659,630 355,292 184,041 o 60,000 599,333 69,500 18,072 87,572 2,232,537 60,787 -6,296 550,633 2,837,661 4,155,349 1,030,709 5,186,058 3,958,630 1,026,459 4,985,089 Completed Remaining unreceived Percent 100.0 39.5 100.0 61.2 41.7 66.7 42.1 41.7 61.3 100.0 49.4 41. 7 60.2 44.5 40.3 55.3 -157.4 50.6 42.1 157.3 48.1 108.4 145.0 50.2 104.4 08/12/2008 09:14:23 FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/08 - 07/31/08 7 Months 5 Months 58.3% 4l. 6% Completed Remaining Cur Mo Received Y-T-D Received 2008 Budget Unreceived Balance unreceived Percent ESCROW DEPOSIT FUND 46 INVESTMENT INCOME o o o o TOTAL ESCROW DEPOSIT FUND o o o o SSA #6 GEORGE/ALBERT B&I 41 OTHER TAXES 46 INVESTMENT INCOME o 5 o 145 o o o -145 TOTAL SSA #6 GEORGE/ALBERT B&I 5 145 o -145 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME o o o o TOTAL SERIES 2002 LIBRARY BND ESCROW o o o o 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,645,501 8,645,501 100.0 TOTAL MOUNT PROSPECT LIBRARY FUND o o 8,645,501 8,645,501 100.0 6 08/12/2008 09:12:22 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Budget Expendi.ture Summary 01/01/08 - 07/31/08 Cur Mo Expended 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 2,924,058 624,019 27,660 514,647 1,667,930 32,108 510,192 152,319 55,410 13,675 38,945 52,473 229,558 80,981 9,856 588,482 1,671,355 52,940 550 178,349 9,425,507 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 4,255,021 346,797 8,832 o 46,544 o o 650 3,000 o o 300 o 1,704,650 o o o 19,645 250 o o o 100,126 127,195 423,811 22,687 903,640 5,035 Y-T-D Expended 14,962,991 5,229,016 241,115 3,310,742 8,686,775 289,637 3,715,973 1,115,162 1,508,371 13,675 137,537 71,701 661,078 417,519 87,445 3,613,000 1,911,818 499,038 2,350 178,349 46,653,292 22,593,731 2,238,313 1,600,348 o 160,144 15, 715 4,023 27,448 12,097 o 87,633 208,597 o 1,754,900 o 300 o 326,322 25,013 o o o 383,476 2,470,982 1,531,814 119,951 4,533,228 42,942 2008 Budget 25,805,345 9,580,641 516,915 5,405,350 17,789,805 699,245 7,069,044 1,620,031 3,539,000 75,000 366,556 211,969 1,557,900 2,286,223 2,334,440 6,725,866 4,149,736 890,003 2,400 o 90,625,469 40,179,521 4,135,231 1,837,002 1,000 771,976 1,000 1,000 1,500 10,500 o 385,265 911,594 o 1,754,900 o o o 613,355 999,525 o o o 1,654,575 5,394,950 2,939,500 515,000 12,852,593 122,269 58.3% 41.6% Unexpended Balance 10,842,354 4,351,625 275,800 2,094,608 9,103,030 409,608 3,353,071 504,869 2,030,629 61,325 229,019 140,268 896,822 1,868,704 2,246,995 3,112,866 2,237,918 390,965 50 -178,349 43,972,177 17,585,790 1,896,918 236,654 1,000 611,832 -14,715 -3,023 -25,948 -1,597 o 297,632 702,997 o o o -300 o 287,033 974,512 o o o 1,271,099 2,923,968 1,407,686 395,049 8,319,365 79,327 Completed Remaining Unexpended Percent 42.0 45.4 53.4 38.8 51. 2 58.6 47.4 31.2 57.4 81. 8 62.5 66.2 57.6 81. 7 96 .3 46.3 53.9 43.9 2.1 48.5 43.8 45.9 12.9 100.0 79.3 ****.* -302.3 **** * -15.2 77.3 77 .1 46.8 97.5 76.8 54.2 47.9 76.7 64.7 64.9 08/12/2008 09:12:22 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/08 - 07/31/08 7 Months 5 Months 58.3% 41. 6% Completed Remaining Cur Mo Y-T-D 2008 Unexpended Unexpended Expended Expended Budget Balance Percent PARKING SYSTEM REVENUE FUND 11,484 70,848 142,164 71,316 50.2 VEHICLE MAINTENANCE FUND 174,826 952,922 1,573,128 620,206 39.4 VEHICLE REPLACEMENT FUND 229,558 661,078 1,557,900 896,822 57.6 COMPUTER REPLACEMENT FUND 52,473 53,749 138,500 84,751 61. 2 RISK MANAGEMENT FUND 478,125 3,493,345 6,767,971 3,274,626 48.4 POLICE PENSION FUND 257,355 1,689,724 2,580,050 890,326 34.5 FIRE PENSION FUND 253,503 1,594,649 2,783,500 1,188,851 42.7 SSA #6 GEORGE/ALBERT B&I 0 0 0 0 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 GENERAL LONG-TERM DEBT ACCT GP 0 0 0 0 Total All Funds 9,425,507 46,653,292 90,625,469 43,972,177 48.5 2 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 NON-DEPARTMENTAL Cur Mo Expended Y-T-D Expended 2008 Budget PROGRAM TOTALS 00 ADMINISTRATION o o Totals o o EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES 72 INTEREST EXPENSE o o o o Totals o o SOURCE OF FUNDS 830 SSA #6 GEORGE/ALBERT B&I 930 GENERAL LONG-TERM DEBT ACCT GP o o o o Totals o o 1 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o o o o o 08/12/2008 7 Months 58.3% Completed 09:14:51 VILLAGE OF MOUNT PROSPECT 5 Months 41. 6% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/08 - 07/31/08 Cur Mo Y-T-D 2008 Unexpended Unexpended PUBLIC REPRESENTATION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 8,766 99,554 116,840 17,286 14.8 03 ADVISORY BOARDS & COMMISSIONS 1,359 7,713 14,336 6,623 46.2 Totals 10,125 107,267 131,176 23,909 18.2 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 2,854 19,269 33,170 13,901 41.9 51 EMPLOYEE BENEFITS 526 3,457 5,928 2,471 41. 7 52 OTHER EMPLOYEE COSTS 67 3,699 3,200 -499 -15.6 54 CONTRACTUAL SERVICES 6,551 79,385 81,778 2,393 2.9 55 UTILITIES 43 210 500 290 58.0 57 COMMODITIES & SUPPLIES 84 1,247 6,600 5,353 81.1 Totals 10,125 107,267 131,176 23,909 18.2 SOURCE OF FUNDS 001 GENERAL FUND 10,125 107,267 131,176 23,909 18.2 Totals 10,125 107,267 131,176 23,909 18.2 2 08/12/2008 09:14:51 FRRDBROl SUM03l 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 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 55,977 169,855 33,760 103,589 32,971 Totals 396,152 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 104,110 31,580 3,618 255,622 718 504 o o Totals 396,152 SOURCE OF FUNDS 001 GENERAL FUND 396,152 Totals 396,152 3 Y-T-D Expended 314,614 392,835 178,536 523,725 133,980 1,543,690 543,173 189,333 23,449 766,781 3,528 5,594 11,832 o 1,543,690 1,543,690 1,543,690 2008 Budget 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 513,052 535,500 380,750 1,038,369 206,773 2,674,444 955,561 328,763 51,400 1,285,265 9,860 13,565 28,430 1,600 2,674,444 2,674,444 2,674,444 198,438 142,665 202,214 514,644 72,793 1,130,754 412,388 139,430 27,951 518,484 6,332 7,971 16,598 1,600 1,130,754 1,130,754 1,130,754 38.7 26.6 53.1 49.6 35.2 42.3 43.2 42.4 54.4 40.3 64.2 58.8 58.4 100.0 42.3 42.3 42.3 08/12/2008 7 Months 58.3% Completed 09:14:51 VILLAGE OF MOUNT PROSPECT 5 Months 41.6% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/08 - 07/31/08 Cur Mo Y-T-D 2008 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 21,319 84,219 135,126 50,907 37.7 04 INTERGOVERNMENTAL PROGRAMMING 6,562 27,702 48,038 20,336 42.3 Totals 27,881 111,921 183,164 71,243 38.9 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 14,130 63,113 105,924 42,811 40.4 51 EMPLOYEE BENEFITS 4,120 24,399 41,902 17,503 41. 8 52 OTHER EMPLOYEE COSTS 1,831 2,511 2,850 339 11.9 54 CONTRACTUAL SERVICES 866 7,201 14,838 7,637 51. 5 55 UTILITIES 286 970 1,600 630 39.4 57 COMMODITIES & SUPPLIES 1,740 3,752 6,050 2,298 38.0 67 OTHER EQUIPMENT 4,908 9,975 10,000 25 0.3 Totals 27,881 111,921 183,164 71,243 38.9 SOURCE OF FUNDS 001 GENERAL FUND 27,881 111,921 183,164 71,243 38.9 Totals 27,881 111,921 183,164 71,243 38.9 4 08/12/2008 7 Months 58.3% Completed 09:14:51 VILLAGE OF MOUNT PROSPECT 5 Months 41. 6% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/08 - 07/31/08 Cur Mo Y-T-D 2008 Unexpended Unexpended VILLAGE CLERK'S OFFICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 19,721 118,903 209,499 90,596 43.2 Totals 19,721 118,903 209,499 90,596 43.2 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 13,295 71,918 119,672 47,754 39.9 51 EMPLOYEE BENEFITS 4,290 26,530 45,221 18,691 41.3 52 OTHER EMPLOYEE COSTS 0 105 2,705 2,600 96 .1 54 CONTRACTUAL SERVICES 1,435 16,987 34,926 17,939 51.4 55 UTILITIES 143 512 1,700 1,188 69.9 57 COMMODITIES & SUPPLIES 558 2,851 5,275 2,424 46.0 Totals 19,721 118,903 209,499 90,596 43.2 SOURCE OF FUNDS 001 GENERAL FUND 19,721 118,903 209,499 90,596 43.2 Totals 19,721 118,903 209,499 90,596 43.2 5 08/12/2008 09:14:51 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Departmen t Budget Expenditure Summary 01/01/08 - 07/31/08 FINANCE DEPARTMENT Cur Mo Expended PROGRAM TOTALS 01 FINANCE ADMINISTRATION 02 ACCOUNTING 04 DUPLICATING SERVICES 05 INSURANCE PROGRAMS 06 CUSTOMER SERVICES 07 CASH MANAGEMENT 33,837 42,827 o 30,999 37,938 3,042 Totals 148,643 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 82,973 27,271 335 12,227 625 22,630 2,582 o Totals 148,643 SOURCE OF FUNDS 001 GENERAL FUND 148,643 Totals 148,643 6 Y-T-D Expended 214,859 262,446 o 202,785 238,643 24,986 943,719 513,071 174,816 4,673 80,223 2,399 158,416 10,121 o 943,719 943,719 943,719 2008 Budget 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 380,774 458,802 o 345,219 416,653 51,346 1,652,794 870,558 302,851 12,970 161,825 6,200 271,570 25,020 1,800 1,652,794 1,652,794 1,652,794 165,915 196,356 o 142,434 178,010 26,360 709,075 357,487 128,035 8,297 81,602 3,801 113 , 154 14,899 1,800 709,075 709,075 709,075 43.6 42.8 41.3 42.7 51. 3 42.9 41.1 42.3 64.0 50.4 61. 3 41. 7 59.5 100.0 42.9 42.9 42.9 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 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,932 18,830 19,889 84,866 59,230 13,074 Totals 223,821 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 141,304 47,107 620 32,774 1,581 435 o Totals 223,821 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 223,821 o Totals 223,821 7 Y-T-D Expended 172,910 118,990 67,727 489,378 285,499 68,773 1,203,277 720,457 288,285 18,664 160,664 7,527 7,680 o 1,203,277 1,202,327 950 1,203,277 2008 Budget 301,953 439,812 122,442 903,935 545,299 123,409 2,436,850 1,328,043 513,908 39,519 489,731 19,274 24,375 22,000 2,436,850 2,435,900 950 2,436,850 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 129,043 320,822 54,715 414,557 259,800 54,636 1,233,573 607,586 225,623 20,855 329,067 11,747 16,695 22,000 1,233,573 1,233,573 o 1,233,573 42.7 72.9 44.7 45.9 47.6 44.3 50.6 45.8 43.9 52.8 67.2 60.9 68.5 100.0 50.6 50.6 50.6 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 COMMUNITY DEVELOPMENT - CDBG Cur Mo Expended PROGRAM TOTALS 04 CDBG ADMINISTRATION 05 CDBG COMMUNITY PROGRAMS 06 ACCESSIBLTY & NEIGHBRHD IMPRV 07 CDBG RESIDENTIAL REHAB 8,812 12,750 o 24,982 Totals 46,544 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 6,202 2,061 o 13,242 57 24,982 o o o Totals 46,544 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 46,544 Totals 46,544 8 Y-T-D Expended 44,616 31,148 o 84,380 160,144 31,008 12,318 o 32,381 57 84,380 o o o 160,144 160,144 160,144 2008 Budget 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 93,476 93,500 310,000 275,000 771,976 58,450 21,959 2,165 113,425 977 190,000 25,000 o 360,000 771,976 771,976 771,976 48,860 62,352 310,000 190,620 611,832 27,442 9,641 2,165 81,044 920 105,620 25,000 o 360,000 611,832 611,832 611,832 52.3 66.7 100.0 69.3 79.3 46.9 43.9 100.0 71.5 94.2 55.6 100.0 100.0 79.3 79.3 79.3 08/12/2008 7 Months 58.3% Completed 09:14:51 VILLAGE OF MOUNT PROSPECT 5 Months 41.6% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/08 - 07/31/08 Cur Mo Y-T-D 2008 Unexpended Unexpended HUMAN SERVICES Expended Expended Budget Balance Percent PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 18,961 111,815 186,002 74,187 39.9 02 SOCIAL SERVICES 38,497 205,451 356,138 150,687 42.3 03 NURSING/HEALTH SERVICES 18,734 101,750 201,509 99,759 49.5 04 SENIOR CTR. LEISURE ACTIVITIES 2,853 18,077 46,298 28,221 61. 0 05 YOlITH ACTIVITIES 0 0 0 0 Totals 79,045 437,093 789,947 352,854 44.7 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 56,370 293,585 500,462 206,877 41.3 51 EMPLOYEE BENEFITS 17,089 102,939 176,441 73,502 41.7 52 OTHER EMPLOYEE COSTS 169 1,669 3,750 2,081 55.5 54 CONTRACTUAL SERVICES 2,975 27,153 56,128 28,975 51. 6 55 lITILITIES 1,498 4,364 8,500 4,136 48.7 57 COMMODITIES & SUPPLIES 944 7,383 43,666 36,283 83.1 65 OFFICE EQUIPMENT 0 0 1,000 1,000 100.0 Totals 79,045 437,093 789,947 352,854 44.7 SOURCE OF FUNDS 001 GENERAL FUND 79,045 437,093 789,947 352,854 44.7 Totals 79,045 437,093 789,947 352,854 44.7 9 08/12/2008 09:14:51 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 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 171,459 902,251 31,353 131,902 o 66,022 Totals 1,302,987 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 80 INTERFUND TRANSFERS 1,004,518 173,558 9,542 92,937 4,966 12,388 o 5,078 o Totals 1,302,987 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,302,337 o o o 650 Totals 1,302,987 10 Y-T-D Expended 1,748,014 4,912,421 158,800 718,627 16,608 460,826 8,015,296 5,207,407 1,780,399 96,811 797,984 18,731 69,606 2,560 41,798 o 8,015,296 7,968,110 o 15,715 4,023 27,448 8,015,296 2008 Budget 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 3,137,077 8,548,383 366,082 1,279,958 30,410 790,003 14,151,913 9,004,702 3,362,288 150,000 1,430,903 44,700 123,020 8,300 28,000 o 14,151,913 14,147,413 1,000 1,000 1,000 1,500 14,151,913 1,389,063 3,635,962 207,282 561,331 13,802 329,177 6,136,617 3,797,295 1,581,889 53,189 632,919 25,969 53,414 5,740 -13,798 o 6,136,617 6,179,303 1,000 -14,715 -3,023 -25,948 6,136,617 44.3 42.5 56.6 43.9 45.4 41.7 43.4 42.2 47.0 35.5 44.2 58.1 43.4 69.2 -49.3 43.4 43.7 100.0 ****.* -302.3 ****.* 43.4 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 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 99,919 790,380 1,078 62,678 4,750 48,625 -898 1,395 o 3,000 Totals 1,010,927 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 803,196 126,861 9,935 o 48,336 4,750 14,823 o o 3,026 Totals 1,010,927 SOURCE OF FONDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 1,007,927 3,000 Totals 1,010,927 11 Y-T-D Expended 1,231,319 4,110,772 3,983 307,234 33,270 278,681 12,932 10,700 o 12,097 6,000,988 4,075,461 1,500,282 54,427 473 236,006 21,142 84,455 o 60 28,682 6,000,988 5,988,891 12,097 6,000,988 2008 Budget 58.3% 41.6% Completed Remaining Unexpended Unexpended Balance Percent 2,384,786 7,262,912 14,131 594,663 64,500 473,265 48,503 37,863 o 10,500 10,891,123 7,138,872 2,859,281 156,110 500 432,965 44,200 145,285 3,800 2,150 107,960 10,891,123 10,880,623 10,500 10,891,123 1,153,467 3,152,140 10,148 287,429 31,230 194,584 35,571 27,163 o -1,597 4,890,135 3,063,411 1,358,999 101,683 27 196,959 23,058 60,830 3,800 2,090 79,278 4,890,135 4,891,732 -1,597 4,890,135 48.4 43.4 71. 8 48.3 48.4 41.1 73.3 71. 7 -15.2 44.9 42.9 47.5 65.1 5.4 45.5 52.2 41. 9 100.0 97.2 73.4 44.9 45.0 -15.2 44.9 08/12/2008 09:14:51 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 PUBLIC WORKS - ADMINISTRATION Cur Mo Expended PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 110,014 Totals 110,014 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 27,316 13,724 1,337 64,288 2,288 1,061 o o Totals 110,014 SOURCE OF FUNDS 001 GENERAL FUND 110,014 Totals 110,014 12 Y-T-D Expended 713,928 713,928 142,277 87,995 13,621 448,703 9,726 11,606 o o 713,928 713,928 713,928 2008 Budget 1,252,565 1,252,565 248,300 150,511 34,452 781,810 20,837 14,909 1,123 623 1,252,565 1,252,565 1,252,565 58.3% Completed 41.6% Remaining Unexpended Unexpended Balance Percent 538,637 538,637 106,023 62,516 20,831 333,107 11,111 3,303 1,123 623 538,637 538,637 538,637 43.0 43.0 42.7 41. 5 60.5 42.6 53.3 22.2 100.0 100.0 43.0 43.0 43.0 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 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 14,019 88,667 96,753 14,473 o 24,224 2,970 23,675 5,035 11,484 o 151 Totals 281,451 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 131,416 34,671 26,741 770 155 18,604 o o o 69,094 o Totals 281,451 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 264,932 o 5,035 11,484 Totals 281,451 13 Y-T-D Expended 87,726 528,384 246,795 770,072 o 101,508 38,851 74,692 42,942 70,848 o 151 1,961,969 917,054 246,058 351,769 20,740 1,090 336,167 o o 15,677 73,414 o 1,961,969 1,617,401 230,778 42,942 70,848 1,961,969 2008 Budget 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 149,250 1,018,213 532,591 517,929 o 183,170 72,712 124,792 122,269 142,164 o o 2,863,090 1,163,722 356,349 701,023 109,230 1,868 335,706 o 6,556 18, 770 169,866 o 2,863,090 2,349,225 249,432 122,269 142,164 2,863,090 61,524 489,829 285,796 -252,143 o 81,662 33,861 50,100 79,327 71,316 o -151 901,121 246,668 110,291 349,254 88,490 778 -461 o 6,556 3,093 96,452 o 901,121 731,824 18,654 79,327 71,316 901,121 41.2 48.1 53.7 -48.7 44.6 46.6 40.1 64.9 50.2 31.5 21.2 31.0 49.8 81. 0 41.6 -0.1 100.0 16.5 56.8 31.5 31.2 7.5 64.9 50.2 31.5 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 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,859 69,226 177,445 4,492 Totals 275,022 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 94,303 24,628 o 150,484 2,402 3,205 Totals 275,022 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 275,022 o Totals 275,022 14 Y-T-D Expended 126,425 291,333 446,942 31,732 896,432 423,782 134,249 480 287,763 22,528 27,630 896,432 894,584 1,848 896,432 2008 Budget 221,056 574,903 1,135,698 100,254 2,031,911 721,680 232,423 3,662 957,305 72,594 44,247 2,031,911 2,020,669 11,242 2,031,911 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 94,631 283,570 688,756 68,522 1,135,479 297,898 98,174 3,182 669,542 50,066 16,617 1,135,479 1,126,085 9,394 1,135,479 42.8 49.3 60.6 68.3 55.9 41.3 42.2 86.9 69.9 69.0 37.6 55.9 55.7 83.6 55.9 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 92,226 26,084 118,310 Totals 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 81,805 20,190 o 12,668 20 3,627 o o o Totals 118,310 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 109,478 8,832 Totals 118,310 15 Y-T-D Expended 478,026 221,096 699,122 400,015 116,687 2,716 71,300 88,409 19,221 o o 774 699,122 569,552 129,570 699,122 2008 Budget 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 798,416 552,630 1,351,046 645,250 195,085 5,552 180,120 240,000 32,855 546 1,638 50,000 1,351,046 1,039,176 311,870 1,351,046 320,390 331,534 651,924 245,235 78,398 2,836 108,820 151,591 13,634 546 1,638 49,226 651,924 469,624 182,300 651,924 40.1 60.0 48.3 38.0 40.2 51.1 60.4 63.2 41.5 100.0 100.0 98.5 48.3 45.2 58.5 48.3 08/12/2008 09:14:51 FRRDBROl SUM03l 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 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 116,763 21,745 21,773 60,334 157,281 45,352 31,955 53,616 36,286 72,537 285,998 Totals 903,640 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 211,532 62,546 206 548,232 14,220 6,698 32,350 o o 18,000 9,856 o Totals 903,640 SOURCE OF FUNDS 610 WATER AND SEWER FUND 903,640 Totals 903,640 16 Y-T-D Expended 764,289 98,534 59,020 349,362 457,471 210,319 198,935 375,308 209,168 166,276 1,644,546 4,533,228 986,232 362,077 15,950 2,701,569 110,603 46,881 150,714 o o 71,757 87,445 o 4,533,228 4,533,228 4,533,228 2008 Budget 1,417,560 206,232 127,098 1,378,315 1,788,845 385,082 382,620 643,384 463,757 2,049,700 4,010,000 12,852,593 1,833,971 650,028 44,430 6,353,343 190,944 80,367 232,485 o 7,575 1,125,010 2,334,440 o 12,852,593 12,852,593 12,852,593 58.3% 41.6% Unexpended Balance 653,271 107,698 68,078 1,028,953 1,331,374 174,763 183,685 268,076 254,589 1,883,424 2,365,454 8,319,365 847,739 287,951 28,480 3,651,774 80,341 33,486 81,771 o 7,575 1,053,253 2,246,995 o 8,319,365 8,319,365 8,319,365 Completed Remaining Unexpended Percent 46.1 52.2 53.6 74.7 74.4 45.4 48.0 41. 7 54.9 91. 9 59.0 64.7 46.2 44.3 64.1 57.5 42.1 41. 7 35.2 100.0 93.6 96 .3 64.7 _64.7 64.7 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 332,855 13,942 Totals 346,797 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 20,025 6,038 o 317,902 57 2,584 191 Totals 346,797 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 346,797 Totals 346,797 17 Y-T-D Expended 2,162,182 76,131 2,238,313 102,621 35,730 625 2,069,953 217 18,089 11,078 2,238,313 2,238,313 2,238,313 2008 Budget 3,925,270 209,961 4,135,231 237,697 72,295 1,835 3,766,799 610 31,010 24,985 4,135,231 4,135,231 4,135,231 58.3% 41.6% Completed Remaining Unexpended Unexpended Balance Percent 1,763,088 133,830 1,896,918 135,076 36,565 1,210 1,696,846 393 12,921 13,907 1,896,918 1,896,918 1,896,918 44.9 63.7 45.9 56.8 50.6 65.9 45.0 64.4 41.7 55.7 45.9 45.9 45.9 08/12/2008 09:14:51 FRRDBROl SUM 031. 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 02 VEHICLE MAINTENANCE PROGRAM 17,447 157,379 Totals 174,826 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 82,151 23,211 o 14,943 143 54,378 o o o Totals 174,826 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 174,826 Totals 174,826 18 Y-T-D Expended 109,857 843,065 952,922 402,847 137,844 1,715 59,349 559 350,608 o o o 952,922 952,922 952,922 2008 Budget 225,713 1,347,415 1,573,128 745,697 248,888 2,315 84,056 1,090 482,037 o 545 8,500 1,573,128 1,573,128 1,573,128 58.3% 41.6% Completed Remaining Unexpended Unexpended Balance Percent 115,856 504,350 620,206 342,850 111,044 600 24,707 531 131,429 o 545 8,500 620,206 620,206 620,206 51.3 37.4 39.4 46.0 44.6 25.9 29.4 48.7 27.3 100.0 100.0 39.4 39.4 39.4 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 COMMUNITY SERVICE PROGRAMS Cur Mo Expended PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 03 4TH OF JULY & CIVIC EVENTS,ETC 04 HOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM 10,883 85,900 790 212 Totals 97,785 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 46,558 4,548 41,088 o 5,591 o Totals 97,785 SOURCE OF FUNDS 001 GENERAL FUND 97,785 Totals 97,785 19 Y-T-D Expended 61,342 93,660 15,053 1,422 171,477 49,701 5,618 95,664 o 20,494 o 171,477 171,477 171,477 2008 Budget 126,100 143,442 94,877 2,907 367,326 93,614 16,520 216,065 o 30,127 11,000 367,326 367,326 367,326 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 64,758 49,782 79,824 1,485 195,849 43,913 10,902 120,401 o 9,633 11,000 195,849 195,849 195,849 51.4 34.7 84.1 51.1 53.3 46.9 66.0 55.7 32.0 100.0 53.3 53.3 53.3 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 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 86,451 13,675 127,195 22,687 423,811 229,558 52,473 Totals 955,850 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 24,619 o 30,428 13,675 38,945 52,473 229,558 46,764 519,388 o o o Totals 955,850 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 100,126 127,195 423,811 22,687 o 229,558 52,473 Totals 955,850 20 Y-T-D Expended 369,801 13,675 2,470,032 119,951 2,771,814 661,078 53,749 6,460,100 395,317 o 1,423,991 13 , 675 137,537 57,249 661,078 222,000 3,538,812 o 10,441 o 6,460,100 1,240,000 383,476 2,470,032 1,531,814 119,951 o 661,078 53,749 6,460,100 2008 Budget 1,464,575 90,000 5,394,000 515,000 4,315,200 1,557,900 138,500 13,475,175 598,700 o 3,338,000 50,000 356,200 138,500 1,557,900 912,375 6,146,000 355,000 22,500 o 13,475,175 1,275,700 1,654,575 5,394,000 2,939,500 515,000 o 1,557,900 138,500 13,475,175 58.3% Completed 41.6% Remaining Unexpended Unexpended Balance Percent 1,094,774 76,325 2,923,968 395,049 1,543,386 896,822 84,751 7,015,075 203,383 o 1,914,009 36,325 218,663 81,251 896,822 690,375 2,607,188 355,000 12,059 o 7,015,075 35,700 1,271,099 2,923,968 1,407,686 395,049 o 896,822 84,751 7,015,075 74.8 84.8 54.2 76.7 35.8 57.6 61.2 52.1 34.0 57.3 72.7 61.4 58.7 57.6 75.7 42.4 100.0 53.6 52.1 2.8 76.8 54.2 47.9 76.7 57.6 61. 2 52.1 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 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 300 1,704,650 19,895 o o Totals 1,724,845 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS SOURCE OF FUNDS 140 180 190 230 290 340 350 360 380 390 400 430 440 830 o 1,671,355 52,940 550 o Totals 1,724,845 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. SSA #6 GEORGE/ALBERT B&I o o 300 o 1,704,650 o o o 19,645 250 o o o o Totals 1,724,845 21 Y-T-D Expended 296,230 1,754,900 351,635 o o 2,402,765 o 1,911,818 488,597 2,350 o 2,402,765 o 87,633 208,597 o 1,754,900 o 300 o 326,322 25,013 o o o o 2,402,765 2008 Budget 58.3% 41.6% Completed Remaining Unexpended Unexpended Balance Percent 1,296,859 1,754,900 1,612,880 o o 4,664,639 o 3,794,736 867,503 2,400 o 4,664,639 o 385,265 911,594 o 1,754,900 o o o 613,355 999,525 o o o o 4,664,639 1,000,629 o 1,261,245 o o 2,261,874 o 1,882,918 378,906 50 o 2,261,874 o 297,632 702,997 o o o -300 o 287,033 974,512 o o o o 2,261,874 77.2 78.2 48.5 49.6 43.7 2.1 48.5 77.3 77.1 46.8 97.5 48.5 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 RETIREE PENSIONS Cur Mo Expended PROGRAM TOTALS 01 MISCELLANEOUS PENSIONS 02 POLICE PENSIONS 03 FIRE PENSIONS 3,789 257,355 253,503 Totals 514,647 EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 514,647 o o Totals 514,647 SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FUND 720 FIRE PENSION FUND 3,789 257,355 253,503 Totals 514,647 22 Y-T-D Expended 26,519 1,689,724 1,594,649 3,310,892 3,310,269 623 o 3,310,892 26,519 1,689,724 1,594,649 3,310,892 2008 Budget 45,600 2,580,050 2,783,500 5,409,150 5,404,850 3,800 500 5,409,150 45,600 2,580,050 2,783,500 5,409,150 58.3%- 41. 6%- Completed Remaining Unexpended Unexpended Balance Percent 19,081 890,326 1,188,851 2,098,258 2,094,581 3,177 500 2,098,258 19,081 890,326 1,188,851 2,098,258 41. 8 34.5 42.7 38.8 38.8 83.6 100.0 38.8 41.8 34.5 42.7 38.8 08/12/2008 09:14:51 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 7 Months 5 Months 58.3% 41. 6% Completed Remaining Cur Mo Y-T-D 2008 Unexpended Unexpended RISK MANAGEMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 75,110 667,890 1,182,700 514,810 43.5 02 MEDICAL INSURANCE 403,015 2,823,607 5,574,029 2,750,422 49.3 Totals 478,125 3,491,497 6,756,729 3,265,232 48.3 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 0 0 45,000 45,000 100.0 56 INSURANCE 478,125 3,491,497 6,684,229 3,192,732 47.8 67 OTHER EQUIPMENT 0 0 27,500 27,500 100.0 Totals 478,125 3,491,497 6,756,729 3,265,232 48.3 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 478,125 3,491,497 6,756,729 3,265,232 48.3 Totals 478,125 3,491,497 6,756,729 3,265,232 48.3 23 08/12/2008 09:14:51 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 7 Months 5 Months 58.3% 41. 6% Completed Remaining Cur Mo Y-T-D 2008 Unexpended Unexpended NON-DEPARTMENTAL Expended Expended Budget Balance Percent PROGRAM TOTALS 01 CONTINGENCIES 178,349 178,349 0 -178,349 Totals 178,349 178,349 0 -178,349 EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS 178,349 178,349 0 -178,349 Totals 178,349 178,349 0 -178,349 SOURCE OF FUNDS 001 GENERAL FUND 178,349 178,349 0 -178,349 560 STREET IMPROVEMENT CONST FUND 0 0 0 0 670 VEHICLE REPLACEMENT FUND 0 0 0 0 Totals 178,349 178,349 0 -178,349 24 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 CAPITAL FIXED ASSETS Cur Mo Expended PROGRAM TOTALS 00 CAPITAL FIXED ASSETS Tota~s EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES Tota~s SOURCE OF FUNDS 910 GENERAL FIXED ASSETS ACCT GP Tota~s 25 Y-T-D Expended 2008 Budget o o o o o o o o o o o o 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o 08/12/2008 09:14:51 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/08 - 07/31/08 MOUNT PROSPECT LIBRARY Cur Mo Expended unexpended Unexpended Balance Percent PROGRAM TOTALS 02 LIBRARY SERVICES Totals EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES Totals SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND Totals 26 Y-T-D Expended o o o o o o 2008 Budget o 8,645,501 o 8,645,501 o 8,645,501 o 8,645,501 o 8,645,501 o 8,645,501 58.3% 41.6% Completed Remaining 8,645,501 100.0 8,645,501 100.0 8,645,501 100.0 8,645,501 100.0 8,645,501 100.0 8,645,501 100.0