Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
3. BILLS & FINANCIALS 8/15/06
VILLAGE OF MOUNT PROSPECT CASH POSITION August 01 - 09, 2006 Cash & Invstmt Receipts Disbursements Other Cash & Invstmt Balance 08/01/06 Per Attached Credits/ Balance 08/01/06 08/09/06 List of Bills Debits 08/09/06 General Fund 6,711,677 883,165 471,460 7,123,382 Special Revenue Funds Refuse Disposal Fund 997,712 55,497 57 1,053,152 Motor Fuel Tax Fund 955,4 72 138,450 1,000 1,092,922 Local Law Enforcement Block Grant Fund 695 695 Community Development Blk Grant Fund (23,546) 16,875 (40,421 ) Asset Seizure Fund 69,372 69,372 DEA Shared Funds 49,842 999 48,843 DUI Fine Fund 28,759 28,759 Foreign Fire Tax Board Fund 41,134 41,134 Debt Service Funds 664,772 664,772 Capital Proiects Funds Capital Improvement Fund 1,310,370 4,135 1,306,235 Downtown Redevelopment Const Fund 1,102,486 7,497 1,094,989 Street Improvement Construction Fund 1,183,439 1,183,439 Flood Control Construction Fund 727,179 727,179 Enterprise Funds Water & Sewer Fund 3,535,036 346,261 81,824 3,799,473 Village Parking System Fund 85,525 2,292 87,817 Parking System Revenue Fund 49,940 2,031 51,971 Internal Service Funds Vehicle Maintenance Fund 455,341 33,939 421 ,402 Vehicle Replacement Fund 5,776,608 17,267 5,759,341 Computer Replacement Fund 666,048 666,048 Risk Management Fund 2,524,481 54,881 93,984 2,485,378 Trust & Aaencv Funds Police Pension Fund 37,592,324 22,680 7,103 37,607,901 Fire Pension Fund 38,051,605 19,088 6,733 38,063,960 Flexcomp Trust Fund 29,388 10,761 6,278 33,871 Escrow Deposit Fund 1,390,594 28,502 26,166 1,392,930 103,976,253 1,563,608 775,317 104,764,544 REPORT: APBOARDRPT GENERATED: 12 APR 05 17: 4 5 RUN: THURSDAY AUG102006 11: 53 RELEASE 10 : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO TIlE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 PAGE DEPT VENDOR NBR ........ -........................................................... --..... -...... --......... -- -.. -...-..... -... -................. -... -- --........... -........... -.. -.......... --....................................................................... -................... -..... -.............................. AMOUNT VENDOR NAME INVOICE DESCRIPTION ........... -- -............... --........... -... --.... .......-..... --........... --......... -..................... --..... -- -....................................... ---... -.... --.................................... --................................................................... -.......... 001 02919 303 CAB ASSOCIATION, INC. JULY INVOI CE 09517 ACCURATE LOCATING SERVICES, INC. 2006 CATCH BASIN AND INLET 01169 AERIAL EQUIPMENT, INC. CHAIN SAW BAR OIL AND CHAIN 05128 AIIM INTERNATIONAL MEMBERSHIP RENEWAL-K.DEWIS 01227 AIR ONE EQUIPMENT, INC. 1 Helmet 4 Shields SHIPPING CHARGES 01246 07423 02012 09380 01620 09417 05004 05560 01833 04958 07633 06714 06287 AIRGAS NORTH CENTRAL OXYGEN SUPPLIES ALEXANDER EQUIP.CO.,INC. MORBARK CHIPPER REPLACEMENT PA ESTIMATED FREIGHT AMERICAN ASSOC.OF CODE ENFORCEMENT ANNUAL MEMBERSHIPDUES-R.ROELS AMERICAN BUILDING SOLUTIONS INSTALLATION OF HANDICAP THRES AMERICAN LANDSCAPING INC. LANDSCAPE SERVICES AMERI CAN MATTRESS INC. 4 Sets Extra Long Twin Mattres ADD'L CHARGES AMERICAN MESSAGING 108 - Alpha pagers Plus FCC Ta AMERICAN QUICKPRINT SANITATION REPORTS ANDERSON LOCK COMPANY REPLACEMENT SCIlLAGE EVEREST APPDEV PRODUCTS LLC MICROSOFT SQL SERVER 2005 TRAI MCSE: SECURITY ON WIN SERVER 2 ARBOR GREEN, LTD TREE REMOVAL 2006 TREE REMOVAL CONTRACT ASSOCIATED TECIlNI CAL SERVI CE SERVICE TO LOCATE UNDREGROUND BEDCO MECIlANI CAL REPAIR/REPLACE CONDENSOR - 170 REPAIR OF ROOFTOP UNIT - PUBLI REAIRS TO A/C UNIT #2 - PUBLIC 390.00 707.16 577.16 125.00 300.00 9.79 309.79 120.44 311.40 1.48 312 .88 75.00 378.00 1360.00 956.00 3.96 959.96 1638.51 224.77 157.50 2463.81 0.00 2463.81 500.00 6155.70 6655.70 652.50 555.35 212.50 587.45 1355.30 REPORT: APBOARDRPT GENERATED: 12 APR 05 17: 45 RUN: THURSDAY AUG102006 11:53 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 ....... -.............. --............................................ --............ --....................................................... --............... ...... ............................................................................ -- --.....-....... --...... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .............................-.. ........... -- --.. --............................. --.................-....................... --....................-........................ ............................................. -....-..-....... ....-.................... 08978 BIRD-X, INC. 2 - ULTRASONIC BIRD REPELLERS 1119.00 FREI GHT 19.00 ------......--..-- 1138.00 01014 CADE INDUSTRIES CUSTODIAL SUPPLIES 2977 .30 04267 CARDINAL CARTRIDGE INC. TONER CARTRIDGES 650.16 01049 COW GOVERNMENT, INC PIONEER DVD- RW 64.72 SYMANTEC ANTIVIRUS ENTERPRISE 4750.00 ADOBE ACROBAT PRO - COW # 7302 376.00 HP DLT VS160 TAPE - COW # 7553 276.00 ADAPTEC EXT SCSI CABLE - COW . 50.00 USB KEYBOARD FOR PW - COW . 72 18.00 SHIPPING 12.99 REPLACEMENT DIGITAL CAMERAS (2 578.99 ..-----......-..-- 6126.70 09654 CEV MULTIMEDIA, LTD. DVD - "ELEMENTS OF PRUNING' 88.00 01097 CINTAS CORP REPLACEMENT GARMENTS - FOREMAN 188.44 01136 COLEMAN, ALAN J. 1 - 50 I INNER CORE ROD CABLE 1 196.63 01153 COMMUNITY CAB CO. JULY RIDES 792.00 06345 CONSERV F Is I INC. STRAW BALES - 4TH OF JULY FLOA 254.00 12 - 24' POLY RAKE 106.08 ......-..--........-.. 360.08 0875l COSTCO DUES & MEMBERSHI PS 330.00 08567 CUMMINS- ALLISON CORP. REIMBURSEMENT ON PARKING TICKE 10.00 05153 DIALOGIC COMMUNICATIONS CORP. DCC ANNUAL SUPPORT 3070.00 01287 DOOR SYSTEMS, INC. REPAIRS TO ELECTRI C OPERATOR - 494.93 REPLACE CONTROL CYLINDER - 170 390.00 --....--....---..- 884.93 01328 EL-COR INDUSTRIES, INC. Repair Parts 256.02 06160 ENTERPRISE RENT - A- CAR 4 - RENTAL CARS FOR 3 MONTHS, 1420.00 09671 ERC WIPING PRODUCTS INC. Vehicle Towels and Kitchen Tow 316.44 08374 ESG SHIPPING 35.05 1 Sensit Gold Calibration Kit 449.00 ........-.......----- 484.05 09001 EVIDENT CRIME SCENE PRODUCTS ET SUPPLIES 130 .45 \POR~: APBOARDRPT GENERATED: 12 APR 05 17:45 RON: THURSDAY AUG102006 11:53 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 PAGE 3 )EPT VENDOR NBR INVOICE DESCRIPTION ................................... --............ ---....oo........................................ __ __...... __ _.................. __ ........................................................ __.............._.................. __...... __................ AMOUNT VENDOR NAME ........................................ --.......................................... --...............-........ ...-- --..... --......................................... --..-............................... ....oo........... _.. __...... __ __ _..................... 09674 FAIRWAY GOLF CARS, INC. RENTAL OF 3 GOLF CARTS - JULY 01374 FAWLEY'S INC. OVERAGE FROM PO#S006119 Passports 01377 FEDERAL EXPRESS CORP SHIPPING SERVICE SHIPPING TO KTJ 00102 FIRE PENS I ON FOND PAYROLL FOR - 080306 01031 FRED PRYOR SEMINAR CREATE LEADERSHIP WORKSHOP 08573 FURA, BETTINA REAL ESTATE TAX REBATE 04537 GALETON GLOVES 24 - DOZEN BROWN JERSEY GLOVES 08573 GOLDMAN, LINDA REAL ESTATE TAX REFOND- VOID 03962 GOLEMO, MICHAEL SPECIAL EVENTS COMMISSION 05519 GRAPHIC ENTERPRISES K & E 3036 PLAN COPIER - MONTH ADJUST PRI CE 08566 GRINlOUK, OKSANA REFOND FOR VERI CLE STI CKER 04836 HEALTH ED LLC. SEMINAR REGISTRATION-LIVELY SEMINAR REGISTRATION-MORGAN SEMINAR REGISTRATION-ROSEN 09205 HEALTH ENDEAVORS RETURN TO DUTY EVALUATION/mOL MEDICAL EXAMINATION/CLARKE 09113 HEALY ASPHALT COMPANY,LLC. PATCIlING MATERIALS 08638 HELM, MARTHA SPECIAL EVENTS COMMISSION 01610 HOME DEPOT CREDIT SERVICES MISC. HARDWARE AND SUPPLIES MISC. HARDWARE AND SUPPLIES MAYTAG DISHWASHER/GE MICROWAVE TOTEBAGS AND TOOLS 09675 HOOS- AHHS, LLC FIELD TOWELS FOR SQUAD CAR TRU 01618 HOUSE OF SZECIlWAN LUNCH FOR COMPREHENSIVE PLAN W 330.00 122.80 100.00 222.80 36.58 19.72 40.83 97.13 18824.61 3800.00 798.00 100.43 999.00 400.00 19.38 0.06- 19.32 63.00 139.00 139.00 139.00 417.00 50.00 50.00 100.00 49.08 36.60 101.83 43.75 488.99 45.29 679.86 74.80 230.00 REPORT: APBOARDRPT GENERATED: 12 APR 05 17:45 RUN: THORSDAY AOG102006 11:53 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 .. --................-..-................. ~_..........................................-................... --..................................-.... ..--..- ......................... --............................. -.................. -............. --......-.. DEFT VENDOR NBR VENDOR NAME INVOI CE DESCRIPTION AMOUNT ........................... --...-.......... --........................................ --.... --..............-.... -............................-...... --........................................-......-.................... --............................ --..... 01647 IAMMA RISING COST OF HEALTH INSURANC 20.00 00106 I CMA RETIREMENT TRUST - 401 EDDINGTON-401K P/R 8/3/06 389.04 PAYROLL FOR - 080306 850.00 -..-----....---- 1239.04 00107 leMA RETIREMENT TRUST - 457 PAYROLL FOR - 080306 17962.66 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 080306 21576.66 01122 ILLINOIS STATE DISBURSEMENT UNIT PAYROLL FOR - 080306 800.00 PAYROLL FOR - 080306 19.38 PAYROLL FOR - 080306 520.7S PAYROLL FOR - 080306 1169.24 ............------.. 2509.37 04993 ILLINOIS STATE TOLL HIGHWAY AUTHORITY TRAVEL * MEETINGS 9.55 TRAVEL * MEETINGS D.25 .....-..----....--- 9.80 07433 lMAGETEC L P STAPLES FOR COPIERS 131.00 09562 IMRF PAYROLL FOR - 080306 322.09 PAYROLL FOR - 080306 37462.45 PAYROLL FOR - 080306 16807.65 --.........------.. 54592 .19 09563 IRS PAYROLL FOR - 080306 170270.95 00353 JANONIS, MICHAEL E. LUNCH/MEETING 30.80 06874 JOHN DEERE LANDSCAPES SPRINKLER SYSTEM PARTS 93.45 01818 KERSTEIN, JUNE BLOOD DRIVE REIMBURSEMENT 124.06 05062 KRM INFORMATION SERVICE REGISTER-VALENTINE AUG 9,2006 105.00 01866 LARRY ROESCH FORD Repair parts/ Fuel System Part 110.49 08631 LECHNER AND SONS UNIFORM RENTAL AND CLEANING 128.82 UNI FORM RENTAL AND CLEANING 137 .83 ---..........-.....--- 266.65 05176 LIBERTY FLAG & SPECIALTY CO. AMERICAN FLAGS AND FLOAT DECOR 1498.87 01897 LIFE ASSIST 4 FS950P Alpha I pak and Strap 608.00 Batteries and Other Ambulance 339.52 ....----......-......- 947. S2 09665 LINDGREN, DAVID REBATE FOR 6 SQUARES OF PUBLI C 441.00 REPo.~T: APBOARDRPT GENERATED: 12 APR 05 17: 45 RUN: THURSDAY AUG102006 11:53 PAGE 5 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 ... -_... -- --.......................... -............ --..... --............... --........... -................. --..................................... --............... --.... -........... -................-........... -................................................. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ..... -............... -............................... -- -.. ........................ -............................ -........................ -................... --..... -...................... --...... -- --.......................... --.... --................................. 05521 LORMAN EDUCATION SERVICES ATTENDANCE FOR CONST . LIEN LAW 658.00 01918 LUNDSTROM'S NURSERY, INC. 2006 LANDSCAPE MAINTENANCE 5006.34 TURF MOWING AT VARIOUS LOCATIO 3480.18 .........-------.... 8486.52 07078 LURVEY LANDSCAPE SUPPLY REPLACEMENT PLANTINGS - VlLAGE 199.20 08573 MALISZEWSKI, JACEK & RENATA REAL ESTATE TAX REBATE 670.00 01965 MARTAM CONSTRUCTION HAULING AND DUMPING OF SWEEPIN 668.40 HAULING AND DUMPING OF SWEEPIN 1252.3 5 "---00___..._-.. 1920.75 08573 MC GUIRE, PATRI CK REAL ESTATE TAX REBATE 860.00 05021 MENARDS MISC. HARDWARE AND BUILDING 162.87 MISC. HARDWARE AND BUILDING 55.37 MISC. HARDWARE AND BUILDING 21. 58 MISC. HARDWARE AND BUILDING 25.94 MISC. HARDWARE AND BUILDING 14.00 MISC. HARDWARE AND SUPPLIES 53.13 MISC. HARDWARE AND SUPPLIES 45.53 MISC. HARDWARE AND SUPPLIES 44.34 MISC. HARDWARE AND SUPPLIES 127.32 .........-----..--- 550.08 06719 METEORLOGIX RENTAL OF WEATHER MONITORING 768.00 00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 080306 2240.00 00117 METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - 080306 731.50 01058 MEYER LABORATORY, INC. CUSTODIAL SUPPLIES 142.81 02826 MI CHARL WAGNER & SONS, INC. PLUMBING REPAIR SUPPLIES 58.34 02017 MIDDLETON, JOAN REIMBURSEMENT 45.98 02028 MIGHTY MITES AWARDS & SONS DODGEBALL TROPHIES 138.00 02067 MOUNT PROSPECT HISTORICAL SOC. 2 HISTORICAL SOCIETY BOOKS 30.00 2006 BUDGET ALLOCATION 3333.33 2006 BUDGET ALLOCATION-JULY 3333.33 --......----.--... 6696.66 07475 MT. PROSPECT HEATING & AIC AIR CONDITIONING FEE 25.00 02107 NAPA. HEIGHTS AUTOMOTIVE SUPPLY Repair Parts - July 2006 437.22 02112 NATIONAL ASSN. OF SOCIAL WORKERS RENEWAK MEMBERSHIP-MORGAN 250.00 REPORT: APBOARDRPT GENERATED: 12 APR 05 17: 4 5 RUN: THURSDAY AUG102006 11: 53 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 ~................................. -........................................................... --.................-....................................................-..... --...... --.............................-................. -...................................-..... --..... ............................................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ............ ---... --...................................................-...........................................................-................................... -....................................................... --.....................-....................... --................ --............................. 02117 NATIONAL CRIME PREVENTION CNCL POLICE OFFI CER COLORINT BOOK 423.38 04661 NATIONAL POWER RODDING CORP. SEALING OF LEAK IN STORM SEWER 1690.00 SEALING OF LEAK IN STORM SEWER 635.50 ..------..----... 2325.50 00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 080306 15865.27 04581 NELS J. JOHNSON TREE EXPERTS REMOVAL OF PRIVATE OED ELMS 740.00 02155 NEXTEL COMMUNICATIONS ACCT#157600518-053 704.30 ACCT#157600518-053 74.98 ACCT#157600518-053 92.24 ACCTlI157600518-053 476.38 ACCT#157600518-053 159.64 ACCT#157600518-053 1107.42 ACCT#157600518-053 120.00 ACCT#157600518 - 053 109.39 ACCT#157600518-053 246.83 ACCT#157600518-053 24.54 ACCTlI157600518-053 344.87 ACCT1157600518-053 30.00 EGUIP.CHARGES DEC 05-JUN 06 31.99 EGUIP.CHARGES DEC 05-JIlN 06 107.96 EGUIP . CHARGES DEC 05~JUN 06 187.10 EGUIP.CHARGES DEC 05-JUN 06 371.96 ------...-..---- 4189.60 08517 NI CHOLS, GREG CLOTHING ALLOWANCE 64.78 REIMBURSEMENT FOR SAFETY SHOES 99.70 -....----.............- i64 .48 02199 NORTHWEST STATIONERS INC. CUTTING BOARD 120.93 02210 NUMBERS AUTOMATION INC ANNUAL PAPER SHREDDER SERV.AGR 150.00 08573 O'BRIEN, MAUREEN REAL ESTATE TAX REBATE 906.00 04541 OSU SERETEAN WELLNESS CENTER PRE - EMPLOYMENT/STUCKEY 510.00 09200 P & R Indust rial Supply 20 PCS - BOTTLE ADAPTERS AND P 71.00 05257 PESCHE'S FLOWER SHOP FLOWERS FOR SISTER I S CITY PARA 156.00 02315 PIONEER PRESS SUBSCRIPTION RENEWAL - MT. 39.95 00124 POLICE PENSION FUND PAYROLL FOR - 080306 22404.71 04921 POPE, ELIZABETH A. PAYROLL FOR - 080306 923.08 02358 PRO-SAFETY, INC REPLACEMENT RAlNiIEAR AND SAFET 259.50 ADDT I L CHARGES 0.90 3 BOXES - DECI DAMP EARS PLUGS 59.85 .._.--..------ REPORT: APBOARDRPT GENERATED: 12 APR 05 17: 45 RUN: THURSDAY AUG102006 11: 53 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 PAGE DEPT VENDOR NBR INVOICE DESCRIPTION ........................ --..... ................ --........... --...... --.. -... -............... -........................................... --.......-...... -- -.......... -................ -........................................................ --............. -............ AMOUNT VENDOR NAME ......................... -....................................... --............ -- -....... --........................ --................................. --............ -........................... --.................................. -...................................... 02394 RAYCO SIGN SUPPLY 100FT IS" COMPU-CUT SIGN MATER 02429 RIC MAR INDUSTRIES, INC. "REFRESH" AIR DEODORIZER "HARMONY" SOAP "POWER FOAM" CLEANER FRT 08573 RISSETTO, DELORES REAL ESTATE TAX REBATE 02444 RIVER TRAILS PARK DISTRICT SPECIAL EVENTS COMMISSION 05486 SAFETY SOURCE, INC SAFETY SHOE PURCHASES - JOHN SAFETY SHOE PURCHASE - MIKE HO 07529 SCIlAMBACH SOFTWARE SOLUTIONS, INC. CONSULTING SERVICES 02515 SCHWEPPE & SONS 1 Coffee Brewer Station #14 02525 SECRETARY OF STATE PLATE STICKER RENEWAL 2708 00125 SEIU LOCAL 73 PAYROLL FOR - 080306 09672 SHILVOCK, MICKEY REBATE FOR 5 DQUARES OF PUBLIC 06989 SIKICH LLP AUDITING SERVI CES 09681 SKC COMMUNI CATIN PRODUCTS, INC . AC ADAPTER FOR PLANTRONIES PHO 02627 STEINER ELECTRIC COMPANY POWERTRON SERVICE AND REPAIR T REGULATOR FOR POWERTRON GENERA REPLACEMENT FUSES 09680 STERLING LEDET ADOBE INDESIGN!PHOTOSHOP CLASS 04951 SUBURBAN ACCENTS INC. STICKERS FOR BIKE HELMETS 02660 SUBURBAN PRINTING PRINTING 2800 EMERALD ASH BORE 04276 TRUGREEN-CHEMLAWN APPLY HERBICIDES AT VARIOUS APPLY HERBICIDES AT VARIOUS 08821 UNIFORMITY INCORPORATED Various Uniforms & Workout Wea Various Uniforms & Workout Wea 04813 UNITED RENTALS HIGHWAY TECHNOLOGIES RENTAL OF 325 TYPE I BARRICADE 320.25 93.00 88.50 118.00 88.80 18.59 313 .89 620.00 500.00 125.00 80.00 205.00 5557.50 604.69 78.00 757.02 212.50 3885.00 15.01 802.47 237.60 317 .28 1417.35 1590.00 36.00 145.00 2813.00 3349.50 6162.50 536.59 7850.00 8386.59 1902.50 REPORT: APBOARDRPT GENERATED: 12 APR 05 17: 45 RUN: THURSDAY AUG102006 11:53 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 PAGE DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION --- ----.. ---......... --- -_..-............. -- -.. ....- -.. --.. -... ..-.. -- ---..-...... --- ----.....-......- -..... -- ........- ------ ..-....... .....--..--.... .....-- --................ ........... _.......- -- ....... ----- AMOUNT REPCRT: APBOARDRPT GENERATED: 12 APR 05 17: 45 RUN: THURSDAY AUG102006 11: 53 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 --........................................................ --.............. --............... --.... --................ --.. --................-.. -.. -- --................ --......... -.............................. --........................... 00............ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT REPORT: APBOARDRPT GENERATED: 12 APR 05 17: 45 RUN: THURSDAY AUGI02006 11: 53 PAGE 10 RELEASE 10 : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 .................. -- ...................................... -...................................... --........... --...................................... --.................. --...............-............................................................................................................ --................ --............. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .......................... .....................................................-................................. --.................................... --................ --.................. --........................................................ --............... --............................. ---.... --... -......... 08631 LECHNER AND SONS UNIFORM RENTAL AND CLEANING 128.82 UNIFORM RENTAL AND CLEANING 137 .83 ......----................. 266.65 01918 LUNDSTROM'S NURSERY, INC. TURF MOWING AT VARIOUS LOCATIO 403.77 09636 MAGID GLOVE & SAFETY MFG. CO. LLC MANHOLE AND VALVE VAULT ENTRY 2165.39 MANHOLE AND VALVE VAULT ENTRY 1462.35 MANHOLE AND VALVE VAULT ENTRY 3334.61 MANHOLE AND VALVE VAULT ENTRY 2251.97 ------------- 9214.32 01965 MARTAM CONSTRUCTION HAULING AND DUMPING OF StlEEPIN 1088.00 HAULING AND DUMPING OF StlEEPIN 615.00 HAULING AND DUMPING OF StlEEPIN 549.50 ---....-.....----- 2252.50 05021 MENARDS MISC. HARDWARE AND BUILDING 42.50 MISC. HARDWARE AND BUILDING 58.33 MISC. HARDWARE AND BUILDING 97.63 MISC. HARDWARE AND SUPPLIES 252.66 --...---------... 451.12 02007 MEYER MATERIAL CO. 3 - LOADS OF WASH STONE 694.48 02046 MOBILE PRINT INC. PRINTING OF BUSINESS CARDS - L 27.00 09605 MURPHY, DANIEL J. CONTRACTUAL HYDRANT PAINITING 320.00 02735 NATIONAL WATERWORKS 20 - 89980 MUELLER LIDS 210.74 02143 NEENAIl FOUNDRY COMPANY WATER COVERS SEAL-TIGHT wi VIL 276.00 02155 NEXTEL COMMUNICATIONS ACCTm7600518-053 299.28 ACCTm7600518-053 33.96 -...-----.....---- 333.24 02247 ORR SAFETY TWO BIOSYSTEM PHD5 150.00 02256 PADDOCK PUBLICATIONS, INC. PUBLICATION OF BID NOTICE 48.75 00406 PATRASSO l TONY REIMBURSEMENT FOR SAFETY SHOE 103.08 02358 PRO-SAFETY, INC MARKING PAINT 144.00 REPLACEMENT RAINtIEAR AND SAFET 259.50 ---_....-......._-- 403.50 05486 SAFETY SOURCE, INC SAFETY SHOE PURCHASES . JOHN 125.00 06989 SIKICH LLP AUDITING SERVICES 2590.00 :EPORT: APBOARDRPT GENERATED: 12 APR 05 11 :45 RUN: THURSDAY AUG102006 11:53 PAGE 12 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 .............................................................. --..............................................- --........................... --.... --........ --.................. --........... -.. -- -_.........- -- --.......................................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ......................... __............_........_.........._....................................._......._...... __............00.......... __................................................... -... --.......................................................... 02155 NEXTEL COMMUNI CATIONS ACCT#157600518-053 260.68 02327 POMP'S TIRE SERVICE, INC. TIRES/MISC SUPPLIES 30.50 TIRES/MISC SUPPLIES 205.50 TIRES 989.88 ---..........-...--- 1225.88 02402 REDISTRIP COMPANY SNOW PLOW PARTS, TOOL BOX BRACK 842.40 02610 STANDARD EQUIPMENT COMPANY CRRIER ASSEMBLY/LIFT CYLINDERS 1117.60 07859 STARR AUTO MARINE REUPHOLSTER SEAT CUSHION/REPAI 350.00 02684 TERRACE SUPPLY COMPANY RENTAL OF WELDING GAS CYLINDER 12.90 HELIUM CYLINDERS 187.35 ----..-..--..--- 200.25 04472 TEXOR PETROLEUM CO GASOLINE 23289.36 TOTAL 33938.54 70 05596 DON'S WELDING & FABRICATING, INC. FLOOR PLATES 627.60 05007 LANDMARK FORD 10 - 2006 FORD CROWN VICTORIA 16538.40 01872 LATTOF ARLINGTON HEIGHTS PARTS FOR JULY 2006 INV#125367 101.20 TOTAL 17267.20 90 08109 CAMBRIDGE INTEGRATED SERVICE W/C REIMBURSEMENT 7673.63 W/C REIMBURSEMENT 7872 .49 W/C REIMBURSEMENT 37719.01 W/C REIMBURSEMENT 23950.42 ..----------_.. 77215.55 01102 CITIBANK, N .A. INSURANCE CLAIMS-GAB 8959.18 01451 GAB ROBINS N.A. INC LIABILITY CLAIMS 10.67 05943 IL DIRECTOR OF EMPLOYMENT SECURITY UNEMPLOYMENT COMPENSATION 7798.2 8 TOTAL 93983.68 LO 09677 INSPE ASSOCIATES LTD. SERVI CES 780.00 04890 SEGALL BRYANT & HAMILL INVESTMENT ADVISORS 6322.88 TOTAL 7102.88 !O 01703 ILLINOIS PROFESSIONAL FIREFIGHTERS ASSOC. BAAS, BURGER, ERB, FIGOLAH 100.00 REPORT: APBOARDRPT GENERATED: 12 APR 05 17: 45 RON: THURSDAY AUG102006 11:53 RELEASE ID : VI LLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 PAGE 13 DEPT VENDOR NBR INVOICE DESCRIPTION --.. .................... -..... --........................ --- -.. -............................................................................ -.............. --........................................................................................................ AMOUNT VENDOR NAME .............................. "'-.................................................................. ............ -............. --........................ __.............00............................................ __................................................... REPORT: APBOARDRPT GENERATED: 12 APR 05 17:45 RUN: THURSDAY AUG102006 11: 53 RELEASE ID : PAGE 14 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 27 2006 TO AUGUST 09 2006 ...................... ............................................................................................................ ............................................. --................................................ --.................................. SUMMARY BY FUND ................................. --...... ...................................................................................................................... -- --.............................................................. --................................ 001 GENERAL FUND 471459.57 030 REFUSE DISPOSAL FUND 57.35 050 MOTOR FUEL TAX FUND 1000.00 070 COMMUNITY DEVELPMNT BLOCK GRNT 16875.00 085 DEA SHARED FUNDS FUND 999.40 510 CAPITAL IMPROVEMENT FUND 4134.60 550 DOWNTOWN REDEVLPMNT CONST 7497.06 610 WATER AND SEWER FUND 81824.44 660 VEHICLE MAINTENANCE FUND 33938.54 670 VEHI CLE REPLACEMENT FUND 17267.20 690 RI SK MANAGEMENT FUND 93983.68 710 POLICE PENSION FUND 7102.88 720 FIRE PENSION FUND 6732.62 770 FLEXCOMP ESCROW FUND 6278.26 790 ESCROW DEPOSIT FUND 26166.25 -------------.. TOTAL : 775316.85 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES July 1 - July 31, 2006 . 08/10/2006 09,42,45 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/06 07/31/06 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 26,022 883,057 104,835 1,530,905 1,875,818 48,118 -63,644 13,410 181,647 o 4,600,168 REVENUE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND SERIES 2003 PROJECT FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND POLICE PENSION FUND FIRE PENSION FUND 2,271,476 313,132 152,041 2 18,696 302 135 2,967 63 1,318 1,467 1,035 1,420 72 2,810 18,169 5,999 542 57,604 39,329 o 350 173 7,009 o 5,552 168,973 3,084 715,144 8,690 10,132 145,305 107,177 18,188 613,833 -62,973 -29,127 1 Y-T-D Received 4,691,791 6,883,223 2,224,910 7,238,666 10,797,419 276,872 2,020,933 204,150 2,519,151 147,952 37,005,067 16,761,433 1,734,304 836,050 21 165,259 9,641 908 12,578 44,265 184,095 178,010 346,712 9,434 451 248,020 115,379 38,357 42,653 338,132 227,756 25,703 75,026 25,068 48,274 o 395,364 939,430 22,143 5,431,628 57,216 61,330 871,578 677,264 109,757 3,822,338 1,706,261 1,430,063 7 Months 5 Months 2006 Budget 10,441,909 14,566,963 2,880,166 16,052,627 20,422,428 547,200 4,211,275 347,788 4,762,088 375,000 74,607,444 34,161,176 4,033,827 1,639,215 1,000 499,317 1,100 2,500 23,300 o 413,338 391,298 916,469 5,000 o 893,750 195,211 64,145 152,500 627,541 425,000 o o o 52,626 o 1,367,911 1,769,955 27,250 10,512,211 102,756 238,455 1,450,058 1,083,413 180,020 6,316,682 3,654,043 3,406,377 58.3% 41.6% Unreceived Balance 5,750,118 7,683,740 655,256 8,813,961 9,625,009 270,328 2,190,342 143,638 2,242,937 227,048 37,602,377 17,399,743 2,299,523 803,165 979 334,058 -8,541 1,592 10,722 -44,265 229,243 213,288 569,757 -4,434 -451 645,730 79,832 25,788 109,847 289,409 197,244 -25,703 -75,026 -25,068 4,352 o 972,547 830,525 5,107 5,080,583 45,540 177,125 578,480 406,149 70,263 2,494,344 1,947,782 1,976,314 Completed Remaining Unreceived Percent 55.1 52.7 22.8 54.9 47.1 49.4 52.0 41.3 47.1 60.5 50.4 50.9 57.0 49.0 97.9 66.9 -776.5 63.7 46.0 55.5 54.5 62.2 -88.7 72 .2 40.9 40.2 72 .0 46.1 46.4 8.3 71.1 46.9 18.7 48.3 44.3 74.3 39.9 37.5 39.0 39.5 53.3 58.0 OS/10/2006 09,42,45 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/06 - 07/31/06 7 Months 5 Months 58.3% 41. 6% Completed Remaining Cur Mo Y-T-D 2006 Unreceived Unreceived Received Received Budget Balance Percent ESCROW DEPOSIT FUND 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 68 14,571 0 -14,571 SERIES 2002 LIBRARY BND ESCROW 11 -1,405 0 1,405 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 4,600,168 37,005,067 74,607,444 37,602,377 50.4 2 OB/10/2006 09:43:24 7 Months 5 Months 58.3% 41.6% FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/06 - 07/31/06 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 16,668 593,847 104,245 1,366,315 93,185 45,262 42,118 7,127 2,709 o TOTAL GENERAL FUND 2,271,476 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 6,040 302,095 4,997 o TOTAL REFUSE DISPOSAL FUND 313,132 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 145,901 4,202 1,938 152,041 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 18,689 7 o TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 18,696 ASSET SEIZURE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME o 302 TOTAL ASSET SEIZURE FUND 302 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME o 135 1 Y-T-D Received 3,198,729 3,729,157 2,218,160 6,297,945 617,204 256,490 231,864 120,772 91,112 o 16,761,433 865,101 826,712 41,945 546 1,734,304 801,173 28,572 6,305 836,050 o 2 2 139,548 81 25,630 165,259 8,103 1,538 9,641 o 908 2006 Budget 7,136,332 7,601,250 2,858,750 13,847,740 1,517,817 523,000 204,700 284,662 186,925 o 34,161,176 1,910,472 2,077,355 45,000 1,000 4,033,827 1,625,115 9,100 5,000 1,639,215 o 21 1,000 o 21 1,000 449,317 o 50,000 499,317 100 1,000 1,100 1,000 1,500 Unreceived Balance 3,937,603 3,872,093 640,590 7,549,795 900,613 266,510 -27,164 163,890 95,813 o 17,399,743 1,045,371 1,250,643 3,055 454 2,299,523 823,942 -19,472 -1,305 803,165 1,000 -21 309,769 -81 24,370 334,058 -8,003 -538 Completed Remaining Unreceived Percent 55.2 50.9 22.4 54.5 59.3 51. 0 -13.3 57.6 51.3 50.9 54.7 60.2 6.8 45.4 57.0 50.7 -214.0 -26.1 49.0 100.0 979 97.9 68.9 48.7 66.9 ****.* -8,541 -776.5 -53.8 1,000 592 100.0 39.5 08/10/2006 7 Months 58.3% Completed 09:43:24 VILLAGE OF MOUNT PROSPECT 5 Months 4l. 6% Remaining FRRBRR03 SUM 021 Budget Revenue by Category within Fund Swmnary 01/01/06 - 07/31/06 Cur Mo Y-T-D 2006 Unreceived unreceived Received Received Budget Balance Percent TOTAL DEA SHARED FUNDS FUND J.35 908 2,500 J.,592 63.7 DUI FINE FUND 45 FINES AND FORFEITS 2,856 12,279 23,100 10,821 46.8 46 INVESTMENT INCOME 111 299 200 -99 -49.5 TOTAL DUI FINE FUND 2,967 J.2,578 23,300 10,722 46.0 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 0 0 0 0 46 INVESTMENT INCOME 63 63 0 -63 49 OTHER FINANCING SOURCES 0 44,202 0 -44,202 TOTAL FOREIGN FIRE TAX BOARD FUND 63 44,265 0 -44,265 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 548 180, 724 405,338 224,614 55.4 46 INVESTMENT INCOME 770 3,371 8,000 4,629 57.9 TOTAL SERIES 1987A B&:I, PW FACILITY 1,318 184,095 413,338 229,243 55.5 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 1,050 175,542 387,298 211,756 54.7 46 INVESTMENT INCOME 417 2,468 4,000 1,532 38.3 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2001 B&:I, VILLAGE HALL 1,467 178,010 391,298 213,288 54.5 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 296 262,261 597,469 335,208 56.1 46 INVESTMENT INCOME 739 5,701 4,000 -1,701 -42.5 49 OTHER FINANCING SOURCES 0 78,750 315,000 236,250 75.0 TOTAL SERIES 2003 B&.I, VILLAGE HALL 1,035 346,712 916,469 569,757 62.2 SERIES 2002B B&I, PUBLIC BLDGS 40 PROPERTY TAXES 1,420 9,434 5,000 -4,434 -88.7 46 INVESTMENT INCOME 0 0 0 0 TOTAL SERIES 2002B B&.I, PUBLIC BLDGS 1,4-20 9,434 5,000 -4,434 -88.7 SERIES 2002A B&I, TIF 41 OTHER TAXES 0 0 0 0 46 INVESTMENT INCOME 72 451 0 -451 TOTAL SERIES 2002A B&.I, TIF 72 45J. 0 -451 SERIES 1999 B&I, TIF 41 OTHER TAXES 413 234,483 880,000 645,517 73.4 46 INVESTMENT INCOME 2,397 13,537 13,750 213 l.5 49 OTHER FINANCING SOURCES 0 0 0 0 2 08/10/2006 09:43:24 FRRBRR03 SUM 021 7 Months 5 Months Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/06 07/31/06 Cur Mo Received Y-T-D Received 2006 Budget Unreceived Balance 58.3% 41. 6% Completed Remaining Unreceived Percent TOTAL SERIES 1999 B&I, TIF 2,810 72.2 SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 17,775 394 TOTAL SERIES 1996A B&I, FLOOD 18,169 SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 5,843 156 TOTAL SERIES 1998A B&I, FLOOD 5,999 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1998C B&1, TIF IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 57,604 o TOTAL 1EPA FLOOD CONTROL LOANS B&I 57,604 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 38,559 770 TOTAL SERIES 2000 B&I, FLOOD CONTROL 39,329 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 70 472 542 o 350 350 o 173 173 248,020 114,079 1,300 115,379 37,748 609 38,357 39,968 2,685 42,653 338,132 o 338,132 224,522 3,234 227,756 o o 25,703 o o 25,703 73,183 1,843 75,026 24,104 964 25,068 893,750 193,611 1,600 195,211 63,645 500 64,145 150,000 2,500 152,500 627,441 100 627,541 420,000 5,000 425,000 645,730 79,532 300 79,832 25,897 -109 25,788 110,032 -185 109,847 289,309 100 289,409 195,478 1,766 o o 197,244 -25,703 o o o o -25,703 -73,183 -1,843 o o o -75,026 -24,104 -964 o -25,068 41.1 18.8 40.9 40.7 -21. 8 40.2 73 .4 -7.4 72.0 46.1 100.0 46.1 46.5 35.3 46.4 08/10/2006 09:43:24 FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/06 07/31/06 7 Months 5 Months 58.3% 41. 6% Completed Remaining TOTAL CAPITAL IMPROVEMENT FUND Cur Mo Y-T-D 2006 Unreceived Unreceived Received Received Budget Balance Percent 0 0 0 0 6,309 44,674 30,000 -14,674 -48.9 0 0 8,126 8,126 100.0 700 3,600 14,500 10,900 75.2 0 0 0 0 7,009 48,274 52,626 4,352 8.3 CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES SERIES 2003 PROJECT FUND 46 INVESTMENT INCOME 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 642 364,491 1,367,911 1,003,420 73.4 4,910 30,873 0 -30,873 0 0 0 0 0 0 0 0 5,552 395,364 1,367,911 972,547 71.1 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 46 INVESTMENT INCOME 48 OTHER REVENUE 164,258 916,067 1,739,005 822,938 47.3 0 0 0 0 4,715 23,363 30,950 7,587 24.5 0 0 0 0 168,973 939,430 1,769,955 830,525 46.9 TOTAL STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 3,084 o o 22,143 o o 27,250 o o 5,107 o 18.7 TOTAL FLOOD CONTROL CONST FUND 3,084 22,143 27,250 5,107 18.7 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 4,046 747,326 1,524,100 776,774 51. 0 590 6,750 14,000 7,250 51.8 692,156 4,577,873 8,846,611 4,268,738 48.3 15,707 93,859 102,500 8,641 8.4 0 0 0 0 2,645 5,820 25,000 19,180 76.7 0 0 0 0 715,144 5,431,628 10,512,211 5,080,583 48.3 TOTAL WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 8,325 365 o o 52,254 4,962 o 7,416 94,240 1,100 o 7,416 41,986 -3,862 o 100.0 44.6 -351.1 4 . 08/10/2006 09,43,24 FRRBRR03 SUM 021 7 Months 5 Months 58.3% 41. 6% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/06 07/31/06 TOTAL VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES TOTAL PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE TOTAL VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES TOTAL VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME TOTAL COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE TOTAL RISK MANAGEMENT FUND POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE TOTAL POLICE PENSION FUND FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE Cur Mo Received 8,690 o o 9,929 203 o o 10,132 143,689 1,616 o 145,305 89,540 17,637 o o 107,177 15,563 2,625 18,188 521,336 7,702 4,345 80,450 613,833 -113,389 50,416 -62,973 -73,854 44,727 5 Y-T-D Received 57,216 o o 60,194 1,136 o o 61,330 862,115 8,520 943 871,578 537,249 115,015 o 25,000 677,264 93,371 16,386 109,757 3,170,447 47,133 77,073 527,685 3,822,338 706,499 999,762 1,706,261 566,010 864,053 2006 Budget 102,756 o 129,455 108,000 1,000 o o 238,455 1,436,858 13,200 o 1,450,058 895,413 128,000 o 60,000 1,083,413 155,620 24,400 180,020 5,290,514 32,500 50,000 943,668 6,316,682 1,802,925 1,851,118 3,654,043 1,716,500 1,689,877 Unreceived Balance 45,540 o 129,455 47,806 -136 o o 177,125 574,743 4,680 -943 578,480 358,164 12,985 o 35,000 406,149 62,249 8,014 70,263 2,120,067 -14,633 -27,073 415,983 2,494,344 1,096,426 851,356 1,947,782 1,150,490 825,824 Completed Remaining Unreceived Percent 44.3 100.0 44.3 -13.6 74.3 40.0 35.5 39.9 40.0 10.1 58.3 37.5 40.0 32.8 39.0 40.1 -45.0 -54.1 44.1 39.5 60.8 46.0 53.3 67.0 48.9 FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/06 - 07/31/06 7 Months 5 Months 58.3% Completed Remaining 08/10/2006 09,43,24 41. 6% Cur Mo Received Y-T-D Received 2006 Budget Unreceived Balance unreceived Percent TOTAL FIRE PENSION FUND -29,127 1,430,063 3,406,377 1,976,314 58.0 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 68 14,260 311 o o -14,260 -311 TOTAL SSA #6 GEORGE/ALBERT B&I 68 14,571 o -14,571 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME 11 -1,405 o 1,405 TOTAL SERIES 2002 LIBRARY BND ESCROW 11 -1,405 o 1,405 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,113,291 8,113,291 100.0 TOTAL MOUNT PROSPECT LIBRARY FUND o o 8,113,291 8,113,291 100.0 6 . 08/10/2006 09:41:16 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/06 - 07/31/06 Cur Mo Expended Y-T-D Expended 7 Months 5 Months 2006 Budget 58.3% 41. 6% Unexpended Balance Completed Remaining Unexpended Percent EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS PENSION BENEFITS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES LAND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS INFRASTRUCTURE BOND PRINCIPAL INTEREST EXPENSE BANK AND FISCAL FEES INTERFUND TRANSFERS Total All Funds EXPENDITURE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND SERIES 2003 PROJECT FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND 1,922,813 562,767 24,466 401,986 1,319,059 23,742 483,595 99,462 47,634 o 15,300 39,585 17,196 230,929 143,678 61,683 670,301 96,744 1,050 o 6,161,990 2,819,310 318,981 69,091 o 33,471 o 1,000 1,027 3,130 o o o o o 747,400 450 300 300 19,645 o o o o 223,050 o 54,287 o o 1 12,601,162 3,486,501 181,012 2,892,455 7,630,451 201,074 3,864,603 716,553 242,536 o 50,825 139,654 377,716 472,692 219,669 1,925,494 896,113 672,917 2,250 122,952 36,696,629 18,056,077 2,095,759 1,552,633 o 167,151 o 4,630 1,027 3,130 o 96,026 223,653 o o 840,100 4,858 2,973 8,138 326,322 51,414 o o o 494,891 o 267,449 285,739 184,425 23,535,274 6,069,522 413,562 4,949,171 15,306,220 590,695 7,102,323 1,366,002 5,416,282 54,360 390,635 264,670 1,175,680 675,560 1,773,523 5,603,118 2,605,398 1,245,623 4,200 315,000 78,856,818 33,445,888 3,960,243 2,538,717 1,000 691,200 1,100 2,500 1,000 o 151,000 387,053 912,308 o o 840,400 214,715 65,645 156,275 613,353 492,828 o o o 1,658,901 o 6,046,726 1,597,657 527,538 10,934,112 2,583,021 232,550 2,056,716 7,675,769 389,621 3,237,720 649,449 5,173,746 54,360 339,810 125,016 797,964 202,868 1,553,854 3,677,624 1,709,285 572,706 1,950 192,048 42,160,189 15,389,811 1,864,484 986,084 1,000 524,049 1,100 -2,130 -27 -3,130 151,000 291,027 688,655 o o 300 209,857 62,672 148,137 287,031 441,414 o o o 1,164,010 o 5,779,277 1,311,918 343,113 46.5 42.6 56.2 41.6 50.1 66.0 45.6 47.5 95.5 100.0 87.0 47.2 67.9 30.0 87.6 65.6 65.6 46.0 46.4 61.0 53.5 46.0 47.1 38.8 100.0 75.8 100.0 -85.2 -2.7 100.0 75.2 75.5 97.7 95.5 94.8 46.8 89.6 70.2 95.6 82.1 65.0 08/10/2006 09:41:16 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/06 - 07/31/06 7 Months 5 Months 58.3% 41. 6% Completed Remaining Cur Mo Y-T-D 2006 Unexpended Unexpended Expended Expended Budget Balance Percent WATER AND SEWER FUND 907,834 4,470,642 10,229,607 5,758,965 56.3 VILLAGE PARKING SYSTEM FUND 9,816 69,840 152,798 82,958 54.3 PARKING SYSTEM REVENUE FUND 15,812 58,979 260,865 201,886 77 .4 VEHICLE MAINTENANCE FUND 109,721 743,253 1,450,029 706,776 48.7 VEHICLE REPLACEMENT FUND 6,511 328,270 1,030,680 702,410 68.2 COMPUTER REPLACEMENT FUND 17,577 99,649 162,800 63,151 38.8 RISK MANAGEMENT FUND 404,925 3,391,612 6,367,780 2,976,168 46.7 POLICE PENSION FUND 191,867 1,398,108 2,375,461 977,353 41.1 FIRE PENSION FUND 206,485 1,469,881 2,520,751 1,050,870 41. 7 SSA #6 GEORGE/ALBERT B&I 0 0 0 0 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 6,161,990 36,696,629 78,856,818 42,160,189 53.5 2 . 08/10/2006 7 Months 58.3% Completed 09:44:35 VILLAGE OF MOUNT PROSPECT 5 Months 41. 6% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/06 - 07/31/06 Cur Mo Y-T-D 2006 Unexpended Unexpended PUBLIC REPRESENTATION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 4,084 76,064 102,581 26,517 25.8 03 ADVISORY BOARDS & COMMISSIONS 1,156 8,886 16,312 7,426 45.5 Totals 5,240 84,950 118,893 33,943 28.5 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 2,859 20,170 35,077 14,907 42.5 51 EMPLOYEE BENEFITS 543 3,650 6,948 3,298 47.5 52 OTHER EMPLOYEE COSTS 0 0 2,000 2,000 100.0 54 CONTRACTUAL SERVICES 1,254 56,695 68,768 12,073 17.6 55 UTILITIES 18 117 500 383 76.6 57 COMMODITIES & SUPPLIES 566 4,318 5,600 1,282 22.9 Totals 5,240 84,950 118,893 33,943 28.5 SOURCE OF FUNDS 001 GENERAL FUND 5,240 84,950 118,893 33,943 28.5 Totals 5,240 84,950 118,893 33,943 28.5 1 08/10/2006 09:44:35 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 07/31/06 VILLAGE MANAGER'S OFFICE Cur Mo Expended PROGRAM TOTALS 01 VILLAGE MANAGER I S OFFICE 02 LEGAL SERVICES 03 PERSONNEL SERVICES 04 INFORMATION TECHNOLOGY 05 PUBLIC INFORMATION 42,429 95,018 22,205 66,391 13,246 Totals 239,289 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 62,225 22,151 8,707 144,359 291 1,556 o o Totals 239,289 SOURCE OF FUNDS 001 GENERAL FUND 239,289 Totals 239,289 2 Y-T-D Expended 285,617 174,413 135,401 406,934 64,768 1,067,133 427,056 144,482 21,614 455,997 1,800 5,945 4,249 5,990 1,067,133 1,067,133 1,067,133 2006 Budget 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 470,054 340,000 272,349 827,226 139,883 2,049,512 796,864 251,559 44,950 894,434 8,005 11,100 30,600 12,000 2,049,512 2,049,512 2,049,512 184,437 165,587 136,948 420,292 75,115 982,379 369,808 107,077 23,336 438,437 6,205 5,155 26,351 6,010 982,379 982,379 982,379 39.2 48.7 50.3 50.8 53.7 47.9 46.4 42.6 51.9 49.0 77.5 46.4 86.1 50.1 47.9 47.9 47.9 08/10/2006 7 Months 58.3% Completed 09:44:35 VILLAGE OF MOUNT PROSPECT 5 Months 41.6% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/06 - 07/31/06 Cur Mo Y-T-D 2006 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 13,485 73,891 130,787 56,896 43.5 04 INTERGOVERNMENTAL PROGRAMMING 3,057 24,177 38,564 14,387 37.3 Totals 16,542 98,068 169,351 71,283 42.J. EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 9,574 58,210 98,168 39,958 40.7 51 EMPLOYEE BENEFITS 3,751 23,424 39,576 16,152 40.8 52 OTHER EMPLOYEE COSTS 0 555 2,650 2,095 79.1 54 CONTRACTUAL SERVICES 2,620 6,402 9,357 2,955 31.6 55 UTILITIES 118 827 1,500 673 44.9 57 COMMODITIES & SUPPLIES 444 4,197 4,800 603 12.6 67 OTHER EQUIPMENT 35 4,453 13,300 8,847 66.5 Totals J.6,542 98,068 169,35J. 71,283 42.1 SOURCE OF FUNDS 001 GENERAL FUND 16,542 98,068 169,351 71,283 42.1 Totals J.6,542 98,068 J.69,35J. 71,283 42.J. 3 08/10/2006 7 Months 58.3% Completed 09:44:35 VILLAGE OF MOUNT PROSPECT 5 Months 41. 6% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/06 - 07/31/06 Cur Mo Y-T-D 2006 Unexpended Unexpended VILLAGE CLERK'S OFFICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 13,381 101,835 203,826 101,991 50.0 Totals 1.3,381. 1.01.,835 203,826 1.01.,991. 50.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 8,154 60,823 1.07,135 46,312 43.2 51 EMPLOYEE BENEFITS 3,760 24,638 42,329 17,691 41.8 52 OTHER EMPLOYEE COSTS 40 321 2,812 2,491 88.6 54 CONTRACTUAL SERVICES 1,141 12,386 44,635 32,249 72 .3 55 UTILITIES 59 389 1,600 1,211 75.7 57 COMMODITIES & SUPPLIES 227 3,278 5,315 2,037 38.3 Totals 1.3,381. 1.01,835 203,826 101,991. 50.0 SOURCE OF FUNDS 001 GENERAL FUND 13,381 101,835 203,826 101,991 50.0 Totals 1.3,381. 1.01.,835 203,826 1.01.,991- 50.0 4 . 08/10/2006 7 Months 58.3% Completed 09:44:35 VILLAGE OF MOUNT PROSPECT 5 Months 41. 6% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/06 - 07/31/06 Cur Mo Y-T-D 2006 Unexpended Unexpended FINANCE DEPARTMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 29,985 150,033 227,700 77,667 34.1 02 ACCOUNTING 36,489 247,224 428,676 181,452 42.3 04 DUPLICATING SERVICES 0 0 0 0 05 INSURANCE PROGRAMS 53,468 324,818 545,817 220,999 40.5 06 CUSTOMER SERVICES 29,058 219,560 386,536 166,976 43.2 07 CASH MANAGEMENT 2,675 18,556 48,032 29,476 61.4 Totals 151,675 960,191 1,636,761 676,570 41.3 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 59,235 423,388 760,021 336,633 44.3 51 EMPLOYEE BENEFITS 25,315 164,629 284,593 119,964 42.2 52 OTHER EMPLOYEE COSTS 484 6,313 8,255 1,942 23.5 54 CONTRACTUAL SERVICES 6,784 57,867 72,145 14,278 19.8 55 UTILITIES 223 1,477 5,400 3,923 72.6 56 INSURANCE 47,763 286,575 477,622 191,047 40.0 57 COMMODITIES & SUPPLIES 2,071 10,142 23,725 13,583 57.3 65 OFFICE EQUIPMENT 9,800 9,800 5,000 -4,800 -96.0 Totals 151,675 960,191 1,636,761 676,570 41.3 SOURCE OF FUNDS 001 GENERAL FUND 151,675 960,191 1,636,761 676,570 41.3 Totals 151,675 960,191 1,636,761 676,570 41.3 5 08/10/2006 09:44:35 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 07/31/06 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 17,811 21,710 8,350 60,324 26,108 10,085 Totals 144,388 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 87,224 39,577 2,236 11,054 872 3,425 o Totals 144,388 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 144,388 o Totals 144,388 6 Y-T-D Expended 118,669 143,410 58,931 419,468 169,201 66,818 976,497 608,061 252,498 11,362 89,016 5,463 10,097 o 976,497 975,697 800 976,497 2006 Budget 58.3% 41.6% Completed Remaining Unexpended Unexpended Balance Percent 218,003 247,795 105,934 786,878 322,751 124,170 1,805,531 1,135,033 443,987 27,660 165,322 18,015 15,514 o 1,805,531 1,804,731 800 1,805,531 99,334 104,385 47,003 367,410 153,550 57,352 829,034 526,972 191,489 16,298 76,306 12,552 5,417 o 829,034 829,034 o 829,034 45.6 42.1 44.4 46.7 47.6 46.2 45.9 46.4 43.1 58.9 46.2 69.7 34.9 45.9 45.9 45.9 .08/10/2006 09:44:35 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 COMMUNITY DEVELOPMENT - CDBG Cur Mo Expended PROGRAM 04 05 06 07 TOTALS CDBG ADMINISTRATION CDBG COMMUNITY PROGRAMS ACCESSIBLTY & NEIGHBRHD CDBG RESIDENTIAL REHAB IMPRV 7,631 16,575 o 9,265 Totals 33,471 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 64 BUILDING IMPROVEMENTS 69 INFRASTRUCTURE 6,140 2,111 50 18,103 260 6,807 o o Totals 33,471 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 33 ,471 Totals 33,471 7 Y-T-D Expended 46,229 61,993 1,156 57,773 167,151 32,522 12,454 1,610 66,188 294 52,927 1,156 o 167,151 167,151 167,151 2006 Budget 76,000 148,200 225,000 242,000 691,200 47,545 20,389 4,230 166,115 921 227,000 o 225,000 691,200 691,200 691,200 58.3% 41. 6% Unexpended Balance 29,771 86,207 223,844 184,227 524,049 15,023 7,935 2,620 99,927 627 174,073 -1,156 225,000 524,049 524,049 524,049 Completed Remaining Unexpended Percent 39.2 58.2 99.5 76.1 75.8 31.6 38.9 61.9 60.2 68.1 76.7 100.0 75.8 75.8 75.8 08/10/2006 09:44:35 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 HUMAN SERVICES Cur Mo Expended PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 02 SOCIAL SERVICES 03 NURSING/HEALTH SERVICES 04 SENIOR CTR. LEISURE ACTIVITIES 05 YOUTH ACTIVITIES 13,082 26,768 12,915 3,097 o Totals 55,862 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 36,046 14,268 359 4,185 96 908 o Totals 55,862 SOURCE OF FUNDS 001 GENERAL FUND 55,862 Totals 55,862 8 Y-T-D Expended 104,873 185,040 90,436 18,661 o 399.010 268,948 92,663 1,155 28,749 2,359 5,136 o 399,010 399,010 399,010 2006 Budget 172,399 333,069 183,827 44,266 o 733,561 466,733 162,525 3,750 56,485 8,000 35,068 1,000 733,561 733,561 733,561 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 67,526 148,029 93,391 25,605 o 334,551 197,785 69,862 2,595 27,736 5,641 29,932 1,000 334,551 334,551 334,551 39.2 44.4 50.8 57.8 45.6 42.4 43.0 69.2 49.1 70.5 85.4 100.0 45.6 45.6 45.6 . 08/10/2006 09:44:35 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 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 109,692 647,550 20,141 101,070 o 62,984 941,437 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 642,385 160,247 4,846 117,030 2,609 4,418 7,875 2,027 Totals 941,437 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND 939,410 o o 1,000 1,027 Totals 941,437 Y-T-D Expended 812,399 4,324,735 127,886 642,112 13,893 378,154 6,299,179 4,343,411 981,345 62,697 781,846 16,302 75,542 20,539 17,497 6,299,179 6,293,522 o o 4,630 1,027 6,299,179 9 2006 Budget 1,609,916 7,803,636 249,161 1,183,690 28,317 658,208 11,532,928 8,182,686 1,676,051 125,985 1,319,758 47,400 133,723 16,975 30,350 11,532,928 11,527,328 1,000 1,100 2,500 1,000 11,532,928 58.3% 41.6% Unexpended Balance 797,517 3,478,901 121,275 541,578 14,424 280,054 5,233,749 3,839,275 694,706 63,288 537,912 31,098 58,181 -3,564 12,853 5,233,749 5,233,806 1,000 1,100 -2,130 -27 5,233,749 Completed Remaining Unexpended Percent 49.5 44.6 48.7 45.8 50.9 42.5 45.4 46.9 41.4 50.2 40.8 65.6 43.5 -21. 0 42.3 45.4 45.4 100.0 100.0 -85.2 -2.7 45.4 08/10/2006 09:44:35 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 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 62,913 589,169 589 44,725 2,611 44,589 o 2,321 o 3,130 Totals 750,047 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 544,138 126,825 5,934 o 36,797 2,611 11,167 o o 22,575 Totals 750,047 SOURCE OF FUNDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 746,917 3,130 Totals 750,047 10 Y-T-D Expended 446,966 3,747,710 3,325 280,949 32,674 282,032 642 13,119 o 3,130 4,810,547 3,596,650 772,444 41,380 o 260,191 23,962 64,330 1,066 o 50,524 4,810,547 4,807,417 3,130 4,810,547 2006 Budget 940,046 6,670,995 13,331 518,822 62,800 472,257 12,295 31,880 o o 8,722,426 6,579,098 1,312,812 117,195 o 484,741 42,500 104,910 4,000 4,000 73,170 8,722,426 8,722,426 o 8,722,426 58.3% 41. 6% Unexpended Balance 493,080 2,923,285 10,006 237,873 30,126 190,225 11,653 18,761 o -3,130 3,911,879 2,982,448 540,368 75,815 o 224,550 18,538 40,580 2,934 4,000 22,646 3,911,879 3,915,009 -3,130 3,911,879 Completed Remaining Unexpended Percent 52.5 43.8 75.1 45.8 48.0 40.3 94.8 58.8 44.8 45.3 41.2 64.7 46.3 43.6 38.7 73.4 100.0 30.9 44.8 44.9 44.8 . 08/10/2006 09;44;35 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 PUBLIC WORKS - ADMINISTRATION Cur Mo Expended PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 107,959 Totals 107,959 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 18,400 12,061 566 75,771 996 165 o o Totals 107,959 SOURCE OF FUNDS 001 GENERAL FUND 107,959 Totals 107,959 11 Y-T-D Expended 690,396 690,396 127,992 76,275 12,939 455,079 8,308 8,958 845 o 690,396 690,396 690,396 2006 Budget 1,181,208 1,181,208 237,711 130,504 28,660 754,403 18,040 10,240 1,060 590 1,181,208 1,181,208 1,181,208 58.3% 41.6% Completed Remaining Unexpended Unexpended Balance Percent 490,812 490,812 109,719 54,229 15,721 299,324 9,732 1,282 215 590 490,812 490,812 490,812 41.6 41.6 46.2 41.6 54.9 39.7 53.9 12.5 20.3 100.0 41.6 41.6 41.6 08/10/2006 09:44:35 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 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 11,556 62,277 28,396 9,580 o 11,356 2,114 11,502 9,816 15,812 o Totals 162,409 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 90,464 30,085 32,131 480 2,027 6,202 o o o 1,020 o Totals 162,409 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 136,781 o 9,816 15,812 Totals 162,409 12 Y-T-D Expended 78,067 450,405 159,824 198,343 o 83,749 33,837 65,650 69,840 58,979 o 1,198,694 595,893 194,918 237,922 2,881 12,159 134,227 o 958 7,830 11, 906 o 1,198,694 1,029,244 40,631 69,840 58,979 1,198,694 2006 Budget 164,731 928,409 461,847 412,733 o 176,027 68,010 115,918 152,798 131,410 o 2,611,883 1,092,076 341,627 628,449 109,205 20,265 277,081 o 6,180 8,000 129,000 o 2,611,883 2,110,995 216,680 152,798 131,410 2,611,883 58.3% 41. 6% Unexpended Balance 86,664 478,004 302,023 214,390 o 92,278 34,173 50,268 82,958 72,431 o 1,413,189 496,183 146,709 390,527 106,324 8,106 142,854 o 5,222 170 117,094 o 1,413,189 1,081,751 176,049 82,958 72,431 1,413,J.89 Completed Remaining Unexpended Percent 52.6 51. 5 65.4 51. 9 52.4 50.2 43.4 54.3 55.1 54.1 45.4 42.9 62.1 97.4 40.0 51.6 84.5 2.1 90.8 54.1 51.2 81. 2 54.3 55.1 54.J. 08/10/2006 09:44:35 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 PUBLIC WORKS - FORESTRY/GRNDS Cur Mo Expended PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 02 MAINTENANCE OF GROUND 03 FORESTRY PROGRAM 04 PUBLIC GROUNDS BEAUTIFICATION 18,187 53,939 45,320 9,349 Totals 126,795 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 63,987 20,897 o 27,294 9,957 4,660 Totals 1.26,795 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 126,599 196 Totals 1.26,795 13 Y-T-D Expended 105,159 239,040 357,691 36,970 738,860 356,920 124,397 327 215,592 27,324 14,300 738,860 738,664 196 738,860 2006 Budget 209,915 480,375 784,110 78,862 1.,553,262 679,609 223,268 3,455 569,710 51,920 25,300 1.,553,262 1,542,662 10,600 1.,553,262 58.3% 41.6% Completed Remaining Unexpended Unexpended Balance Percent 104,756 241,335 426,419 41,892 814,402 322,689 98,871 3,128 354,118 24,596 11,000 81.4,402 803,998 10,404 814,402 49.9 50.2 54.4 53.1 52.4 47.5 44.3 90.5 62.2 47.4 43.5 52.4 52.1 98.2 52.4 08/10/2006 09:44:35 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 58,753 21,568 Totals 80,321 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 46,802 16,841 250 4,430 11,888 110 o o o Totals 80,321 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 67,433 12,888 Totals 80,321 14 Y-T-D Expended 422,999 397,438 820,437 330,410 110,960 4,814 76,388 73,608 4,647 o o 219,610 820,437 502,799 317,638 820,437 2006 Budget 740,696 625,266 1,365,962 586,406 192,442 5,235 172,314 165,270 22,625 515 1,545 219,610 1,365,962 935,197 430,765 1,365,962 58.3% 41. 6% Unexpended Balance 317,697 227,828 545,525 255,996 81,482 421 95,926 91,662 17,978 515 1,545 o 545,525 432,398 113,127 545,525 Completed Remaining Unexpended Percent 42.9 36.4 39.9 43.7 42.3 8.0 55.7 55.5 79.5 100.0 100.0 39.9 46.2 26.3 39.9 . 08/10/2006 09,44,35 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 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 129,674 12,441 14,289 35,200 39,733 29,562 33,355 66,476 52,041 170,067 324,996 Totals 907,834 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 133,724 54,487 994 511,850 3,398 28,293 22,510 o 4,333 4,567 143,678 o Totals 907,834 SOURCE OF FUNDS 610 WATER AND SEWER FUND 907,834 Totals 907,834 15 Y-T-D Expended 863,030 83,879 50,461 257,825 306,535 184,286 130,069 398,853 196 , 766 303,356 1,695,582 4,470,642 873,626 341,481 15,925 2,667,912 62,796 169,757 103,949 o 4,572 10,955 219,669 o 4,470,642 4,470,642 4,470,642 2006 Budget 58.3% 41. 6% Completed Remaining Unexpended Unexpended Balance Percent 1,575,384 179,788 87,442 842,279 670,185 320,041 330,083 664,756 490,576 1,844,873 3,224,200 10,229,607 1,751,202 626,178 32,990 5,379,535 163,655 282,929 162,910 o 7,205 49,480 1,773,523 o 10,229,607 10,229,607 10,229,607 712,354 95,909 36,981 584,454 363,650 135,755 200,014 265,903 293,810 1,541,517 1,528,618 5,758,965 877,576 284,697 17,065 2,711,623 100,859 113,172 58,961 o 2,633 38,525 1,553,854 o 5,758,965 5,758,965 5,758,965 45.2 53.3 42.3 69.4 54.3 42.4 60.6 40.0 59.9 83.6 47.4 56.3 50.1 45.5 51. 7 50.4 61.6 40.0 36.2 36.5 77.9 87.6 56.3 56.3 56.3 08/10/2006 7 Months 58.3% Completed 09:44:35 VILLAGE OF MOUNT PROSPECT 5 Months 41. 6% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/06 07/31/06 Cur Mo Y-T-D 2006 Unexpended Unexpended PUBLIC WORKS - REFUSE DISPOSAL Expended Expended Budget Balance Percent PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 308,507 2,024,850 3,763,240 1,738,390 46.2 02 REFUSE LEAF REMOVAL PROGRAM 10,474 70,909 197,003 126,094 64.0 Totals 318,981 2,095,759 3,960,243 1,864,484 47.1 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 13,232 85,221 212,298 127,077 59.9 51 EMPLOYEE BENEFITS 5,565 34,813 70,041 35,228 50.3 52 OTHER EMPLOYEE COSTS 0 0 1,735 1,735 100.0 54 CONTRACTUAL SERVICES 299,377 1,961,122 3,648,977 1,687,855 46.3 55 UTILITIES 24 216 575 359 62.4 56 INSURANCE 783 4,696 7,827 3,131 40.0 57 COMMODITIES & SUPPLIES 0 9,691 18,790 9,099 48.4 Totals 318,981 2,095,759 3,960,243 1,864,484 47.1 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 318,981 2,095,759 3,960,243 1,864,484 47.1 Totals 318,981 2,095,759 3,960,243 1,864,484 47.1 16 08/10/2006 09,44:35 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 02 VEHICLE MAINTENANCE PROGRAM 12,256 97,465 109,721 Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 50,368 19,565 o 4,856 59 34,873 o o o Totals 109,721 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 109,721 109,721 Totals 17 Y-T-D Expended 94,876 648,377 743,253 342,501 125,640 o 39,945 569 232,672 o o 1,926 743,253 743,253 743,253 2006 Budget 188,374 1,261,655 1,450,029 681,460 228,477 2,000 75,982 1,030 452,240 o 515 8,325 1,450,029 1,450,029 1,450,029 58.3% 41.6% Completed Remaining Unexpended Unexpended Balance Percent 93,498 613,278 706,776 338,959 102,837 2,000 36,037 461 219,568 o 515 6,399 706,776 706,776 706,776 49.6 48.6 48.7 49.7 45.0 100.0 47.4 44.8 48.6 100.0 76.9 48.7 48.7 48.7 OB/10/2006 09:44:35 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 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 8,522 55,345 167 166 Totals 64,200 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 47,856 4,718 11,023 o 603 o Totals 64,200 SOURCE OF FUNDS 001 GENERAL FUND 64,200 Totals 64,200 18 Y-T-D Expended 64,013 80,179 13,183 1,385 J.58,760 49,360 5,790 91,804 o 11,806 o J.58,760 158,760 J.58,760 2006 Budget J.23,500 132,533 80,003 2,792 338,828 86,152 J.6,216 197,140 o 29,320 10,000 338,828 338,828 338,828 58.3% 41.6% Unexpended Balance 59,487 52,354 66,820 1,407 J.80,068 36,792 10,426 105,336 o J.7,514 10,000 J.80,068 180,068 180,068 Completed Remaining Unexpended Percent 48.2 39.5 83.5 50.4 53.J. 42.7 64.3 53.4 59.7 100.0 53.J. 53.1 53.J. . 08/10/2006 09,44,36 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 07/31/06 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 223,050 o 54,287 o 56,203 6,511 17,577 Tota1.s 357,628 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 9,000 o 40,827 o 15,300 17,577 17,196 197,065 60,663 o Totals 357,628 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 56,203 223,050 o 54,287 o o o 6,511 17,577 Totals 357,628 19 Y-T-D Expended 493,439 1,452 266,649 184,425 1,480,103 328,270 99,649 2,853,987 68,377 o 189,609 o 47,645 99,649 377,716 359,217 1,693,978 17,796 2,853,987 1,194,364 494,891 o 266,649 285,739 184,425 o 328,270 99,649 2,853,987 2006 Budget 1,548,955 113,401 6,045,926 527,538 3,614,929 1,030,680 162,800 13,044,229 552,000 o 5,179,282 54,360 380,455 197,800 1,175,680 453,500 5,029,508 21,644 13,044,229 1,891,272 1,658,901 o 6,045,926 1,597,657 527,538 129,455 1,030,680 162,800 13,044,229 58.3% 41. 6% Unexpended Balance 1,055,516 111,949 5,779,277 343,113 2,134,826 702,410 63,151 10,190,242 483,623 o 4,989,673 54,360 332,810 98,151 797,964 94,283 3,335,530 3,848 10,190,242 696,908 1,164,010 o 5,779,277 1,311,918 343,113 129,455 702,410 63,151 10,190,242 Completed Remaining Unexpended Percent 68.1 98.7 95.6 65.0 59.1 68.2 38.8 78.1 87.6 96.3 100.0 87.5 49.6 67.9 20.8 66.3 17 .8 78.1 36.8 70.2 95.6 82.1 65.0 100.0 68.2 38.8 78.1 08/10/2006 09:44:36 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 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 o 747,700 20,395 o o Totals 768,095 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES SOURCE OF 140 180 190 200 230 290 340 350 360 380 390 400 430 440 830 o 670,301 96,744 1,050 768,095 Totals FUNDS SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. SSA #6 GEORGE/ALBERT B&I o o o o o 747,400 450 300 300 19,645 o o o o o Totals 768,095 20 Y-T-D Expended 319,679 848,238 385,567 o o 1,553,484 o 896,113 655,121 2,250 1,553,484 o 96,026 223,653 o o 840,100 4,858 2,973 8,138 326,322 51,414 o o o o 1,553,484 2006 Budget 1,450,361 996,675 1,386,541 o o 3,833,577 o 2,605,398 1,223,979 4,200 3,833,577 151,000 387,053 912,308 o o 840,400 214,715 65,645 156,275 613,353 492,828 o o o o 3,833,577 58.3% 41. 6% Unexpended Balance 1,130,682 148,437 1,000,974 o o 2,280,093 o 1,709,285 568,858 1,950 2,280,093 151,000 291,027 688,655 o o 300 209,857 62,672 148,137 287,031 441,414 o o o o 2,280,093 Completed Remaining Unexpended Percent 78.0 14.9 72 .2 59.5 65.6 46.5 46.4 59.5 100.0 75.2 75.5 97.7 95.5 94.8 46.8 89.6 59.5 . 08/10/2006 09:44:36 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 7 Months 5 Months 58.3% 41. 6% Completed Remaining Totals Cur Mo Y-T-D 2006 Unexpended Unexpended Expended Expended Budget Balance Percent 3,634 25,439 55,609 30,170 54.3 191,867 1,398,108 2,375,461 977,353 41.1 206,485 1,469,881 2,520,751 1,050,870 41. 7 401,986 2,893,428 4,951,821 2,058,393 41.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 401,986 2,892,455 4,949,171 2,056,716 41.6 0 973 2,450 1,477 60.3 0 0 200 200 100.0 401,986 2,893,428 4,951,821 2,058,393 41.6 SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FUND 720 FIRE PENSION FUND Totals 3,634 25,439 55,609 30,170 54.3 191,867 1,398,108 2,375,461 977,353 41.1 206,485 1,469,881 2,520,751 1,050,870 41. 7 401,986 2,893,428 4,951,821 2,058,393 41.6 21 08/10/2006 09:44:36 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 7 Months 5 Months 58.3% 41.6% Completed Remaining Cur Mo Y-T-D 2006 Unexpended Unexpended RISK MANAGEMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 26,967 747,078 1,325,485 578,407 43.6 02 MEDICAL INSURANCE 377,762 2,644,338 5,031,695 2,387,357 47.4 Totals 404,729 3,391,416 6,357,180 2,965,764 46.7 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE o 404,729 o 3,391,416 43,500 6,313,680 43,500 2,922,264 100.0 46.3 Totals 404,729 3,391,416 6,357,180 2,965,764 46.7 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 404,729 3,391,416 6,357,180 2,965,764 46.7 Totals 404,729 3,391,416 6,357,180 2,965,764 46.7 22 . 08/10/2006 09,44,36 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 NON-DEPARTMENTAL Cur Mo Expended Y-T-D Expended 2006 Budget 58.3% 41.6% Completed Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 CONTINGENCIES Totals EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS SOURCE OF 001 560 670 Totals FUNDS GENERAL FUND STREET IMPROVEMENT CONST VEHICLE REPLACEMENT FUND FUND Totals o 122,952 o 122,952 o 122,952 o 122,952 o o o 122,952 o o o 122,952 23 315,000 315,000 315,000 315,000 315,000 o o 315,000 192,048 192,048 192,048 192,048 192,048 o o 192,048 61.0 61.0 61. 0 61.0 61.0 61.0 08/10/2006 09:44:36 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 CAPITAL FIXED ASSETS Cur Mo Expended 2006 Budget Unexpended Balance Unexpended Percent Y-T-D Expended PROGRAM TOTALS 00 CAPITAL FIXED ASSETS o o Totals o o EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES o o Totals o o SOURCE OF FUNDS 910 GENERAL FIXED ASSETS ACCT GP o o Totals o o 24 58.3% Completed 41.6% Remaining o o o o o o o o o o o o · 08/10/2006 09:44:36 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 07/31/06 7 Months 5 Months 58.3% 41. 6% Completed Remaining Cur Mo Y-T-D 2006 Unexpended Unexpended MOUNT PROSPECT LIBRARY Expended Expended Budget Balance Percent PROGRAM TOTALS 02 LIBRARY SERVICES 0 0 8,113,291 8,113,291 100.0 Totals 0 0 8,113,291 8,113,291 100.0 EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES o o 8,113,291 8,113,291 100.0 Totals o o 8,113,291 8,113,291 100.0 SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND o o 8,113,291 8,113,291 100.0 Totals o o 8,113,291 8,113,291 100.0 25