The URL can be used to link to this page

Home My WebLink About3. BILLS & FINANCIALS 8/16/05 VILLAGE OF MOUNT PROSPECT CASH POSITION August 01 -10,2005 Cash & Invstmt Receipts Disbursements Other Cash & Invstmt Balance 08/01105 Per Attached Credits/ Balance 08/01/05 08/10/05 List of Bills Debits 08/10/05 General Fund 6,054,717 1 ,383,354 506,442 6,931,629 Special Revenue Funds Refuse Disposal Fund 1,590,589 51,292 281,635 1,360,246 Motor Fuel Tax Fund 1,075,175 148,696 14,410 1,209,461 Local Law Enforcement Block Grant Fund 667 667 Community Development Blk Grant Fund 52,679 32,186 20,493 Asset Seizure Fund 50,632 50,632 DEA Shared Funds 55,550 55,550 DUI Fine Fund 13,147 13,147 Debt Service Funds 778,439 130,842 300 908,981 Capital Proiects Funds Capital Improvement Fund 1,786,409 2,768 1,783,641 Series 2003 Fund (870,313) (870,313) Downtown Redevelopment Const Fund 708,228 708,228 Street Improvement Construction Fund 474,880 73,164 33,149 514,895 Flood Control Construction Fund 983,702 10,978 972,724 Enterprise Funds Water & Sewer Fund 3,007,386 230,882 34,847 3,203,421 Village Parking System Fund 160,911 960 2,149 159,722 Parking System Revenue Fund 61 ,443 671 60,772 Internal Service Funds Vehicle Maintenance Fund 394,381 23 11,641 382,763 Vehicle Replacement Fund 5,214,899 8,915 5,205,984 Computer Replacement Fund 666,472 666,472 Risk Management Fund 1,884,038 53,801 8,098 1,929,741 Trust & AQencv Funds Police Pension Fund 35,407,427 21,836 3,708 35,425,555 Fire Pension Fund 36,596,100 17,646 4,891 36,608,855 Flexcomp Trust Fund 21,117 9,642 5,216 25,543 Escrow Deposit Fund 1,309,183 13,528 18,030 1,304,681 97,477,858 2,135,666 980,034 98,633,490 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16: 28 RUN: THURSDAY AUG112005 09:42 RELEASE lD : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 --............. --.. --................................................................................................ --........................................................................................................ --.................... -- --.. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT --............................................................................................................... --............................................................................................................................................... ---....... 001 08702 1 800 GOT JUNK CLEAN UP PROPERTY 41l GARWOOD 574.00 02919 303 CAB ASSOCIATION, INC. 103 SENIOR TAXI RIDES 303.00 02572 ABM OFFICE EQUIPMENT XEROX TONER FOR FAX MACHINE 39.15 07728 ADVANCED RADIOLOGY CONSULTANTS, S. C. PRE-EMPLOYMENT/WOLEBEN MATT 113.00 01227 AIR ONE EQUIPMENT, INC. HELMETS 259.16 06838 ALTURA COMMUNICATION MAC TO ADD/FINANCE CREDIT CARD 176.00 01620 AMERICAN LANDSCAPING INC. CLEAN UP PROPERTY 41l GARWOOD 225.00 01699 AMERICAN PUBLIC WORKS ASSOC. JOB AD/WATER MAINT. & ELECTRICI 1188.00 08042 AMERICAN SOLUTIONS FOR BUSINESS PARKING TICKETS 698.20 01833 ANDERSON LOCK COMPANY 25 KEYS 107.50 00372 ANDLER, GLEN REIMBURSEMENT 750.00 01968 APA-CMS AMERICAN PLANNING ASSOCIATION 15.00 02001 ARAMARK UNIFORM SERVICES, INC. UNI FORM RENTAL 75.60 07633 ARBOR GREEN I LTD 2005 TREE REMOVAL CONTRACT 2325.47 2005 TREE TRIMMING CONTRACT 8443.73 ------------- 10769.20 01124 ARTHUR CLESEN, INC. 100 I 1" HOSE WITH REEL AND ASS 631.73 50" PLANT MARVEL FERTILIZER 38.40 50# AMMONIUM SULFATE 366.16 ------... ----- 1036.29 02848 ARTHUR WEILER, INC. RELEASE OF SPRING RETAINAGE 373.50 04228 BALOGH, STEVE REIMBURSEMENT FOR THE PURCHASE 125.00 02566 BASIC FIRE PROTECTION INC. FIRE EXTINGUISHER INSPECTED 5.75 07793 BAY I SUSAN REAL ESTATE TAX REBATE 840.00 06287 BEDCO MECHANI CAL REPAIRS TO LENOX - 10 SPINE 375.00 REPAIR TO ROOF TOP UNIT #7. PU 234.00 REPAIR/REPLACEMENT OF DUCT HEA 1038.00 REPAIRS TO YORK UNIT IN PW 458.80 CONDENSOR FAN MOTOR AND CAPACI 525.80 BLOWER MOTOR REPLACED - MECHAN 435.40 ------------- 3067.00 02757 BESSE MED I CAL SUPPLY MEDICAL SUPPLIES #120850672 87.13 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: THURSDAY AUGl12005 09:42 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 . ~____ ___________ _____ - _._ ____ - ___ ______ __ __ __ - ___ .__ ___ - _________ ___ ____ - - __ __ - ___ __ - - __ _.. - - __ - ___ ___ - a_ ____ _ __ _ __ __ _ _ ____________ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .---- .---------- -- ----.... -- --- -.. ----- -- - - - ---- - - --- ---- -- ----- ---- -- -- ---.. -- - -.. -- ---- -- -- .-- - -- -- ---- ----..-...-.. ---- -------.. .-------- MEDICAL SUPPLIES #120850673 154.74 MEDICAL SUPPLIES #120850671 36.95 MEDICAL SUPPLIES #120852661 14.94 MEDICAL SUPPLIES #120856605 11.75 -- ----.... --..-- 305.51 01008 BUSSE'S FLOWERS & GIFTS FLORAL ARRANGEMENTS 72.70 01014 CADE INDUSTRIES CUSTODIAL SUPPLIES FOR THE MON 736.60 CUSTODIAL SUPPLIES FOR THE MON 883.92 CUSTODIAL SUPPLIES FOR THE MON 736.60 CUSTODIAL SUPPLIES 474.76 CUSTODIAL SUPPLIES 474.76 CUSTODIAL SUPPLIES 474.76 CUSTODIAL SUPPLIES 474.76 CUSTODIAL SUPPLIES 474.76 CUSTODIAL SUPPLIES FOR THE MON 1393.60 -----.------.. 6124.52 01049 COW GOVERNMENT I INC CISCO E-SMARTNET 8X5XNBD CAT 4 299.00 OMNIPAGE PRO OFFICE VER 14 UPG 13 9.0 0 ADOBE PHOTOSHOP FOR COM DEV - 515.00 PHOTOSHOP MEDIA 20.00 ADOBE ACROBAT PRO FOR J ZAWlLA 185.00 OMNIPAGE PRO OFFICE 14 MEDIA C 25.00 --- --.. ---- _.... 1183.00 01084 CHICAGO TRIBUNE ANNUAL SUBSCRIPTION 228.34 07377 CLARKE, PATRICK HEATING AIR CONDITIONING SUPP 255.28 01118 CLERK OF THE CIRCUIT COURT PAYROLL FOR - 080405 442.31 08865 CLOSED CIRCUIT INNOVATIONS, INC. IVACS MAINTENANCE AGREEMENT 427 .00 00308 CONNOLLY I JUDY APA PARKING SEMINAR EXPENSES 40.60 OB813 CURTIS, SHAHYL PAYROLL FOR - 0 B0405 226.15 OB146 DELL COMPUTER CORPORATION OPTIPLEX GX2BO PC FOR CD 1406.96 SURGE PROTECTOR 20.00 -- -- --- --- --- 1426.96 08573 DOHENY, VIRGINIA REAL ESTATE TRANSFER STAMP 610.00 OB573 DOMINI CK, MI CHAEL REAL ESTATE TAX HEBATE 626.00 01287 DOOR SYSTEMS, INC. REPAIRS TO DOOR #69 PUBLIC WOR 315.87 01320 DYNAMIC GRAPHICS MAGAZINE MAGAZINE SUBSCRI PTION 36.00 06343 EDD INGTON / R I CHARD HEIMBURSEMENT 30.00 REPORI': APBOARDRPT GENERATED: 20 MAR OS 16:28 RUN: THURSDAY AUG1l200S 09: 42 RELEASE ID : PAGE VILLAGE OF MOmo'! PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 .. -............. -- -.................................. --.. -........................ --.................................. -- -_......................;"..;.;_...;, --.. ;';'.. ,.'...;"..';;' ~ .;,..;.......... '....... -................ --.................. --......... --.. DEFT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION kl10UNT --- -----.........-............................ --............ --......................................................... --................ --........ ---..................................... --........ -- --.... --................ --............... 05127 ELEMENT K JOURNALS SUBSCRIPTION 87.00 01342 EMERGENCY MEDICAL PRODUCTS Paramedic Supplies Stethoscope 158.22 06160 ENTERPRISE RENT-A-CAR RENTAL CARS FOR THREE MONTHS 552.00 08573 EURICH, DAVID J. REAL ESTATE TRANSFER STAMP 810.00 08573 FABIOLA CARDENAS & JESUS CONTRERAS REAL ESTATE TAX REBATE 640.00 08573 FALAGARIO, MICHAEL AND ELIZABETH REAL ESTATE TRANSFER STAMP 1090.00 01377 FEDERAL EXPRESS CORP SERVI CES 42.04 OVERNIGHT SHIPMENT 119.8 5 FEDEX PICK-UP 23.46 ----.....------.. 185.35 08573 FEIGN, CORY REAL ESTATE TRANSFER STAMP 800.00 00102 FIRE PENSION FUND PAYROLL FOR - 080405 17646.12 01485 GIERMAN AND ASSOCIATES, INC. BOND NOTARY PUBLIC 30.00 08154 GLOBAL EMERGENCY PRODUCTS REPAIR PARTS 827.23 01516 GOVERNMENT FINANCE OFFCR ASSOC TRAINING-TRICIA SCHRAEDER 1295.00 09207 HARTRAY I JOE BUILDING FEE 40.00 CERT/OCCUPANCY 20.00 --..-_.. -- ----- 60.00 09205 HEALTH ENDEAVORS PRE-EMPLOYMENT/EXAM 802.00 01610 HOME DEPOT CREDIT SERVI CES SUPPLIES FOR SMOKE DETECTOR 270.75 DUCT WORK SUPPLIES 263.11 ---..------....... 533.86 00106 I CMA RET IREMENT TRUST - 401 PAYROLL FOR - 080405 750.00 EDDINGTON 401K P/R 8/4/5 373.37 ....-....... ----..-.. 1123.37 00107 ICMA RETIREMENT TRUST - 457 PAYROLL FOR - 080405 15846.12 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 080405 21184.02 09201 ILLINOIS SECRETARY OF STATE RENEWAL NOTARY STAMP/HEREDIA 10.00 01122 ILLINOIS STATE DISBURSEMENT UNIT PAYROLL FOR - 080405 357.69 PAYROLL FOR - 080405 116.31 PAYROLL FOR - 080405 520.75 PAYROLL FOR - 080405 116 9.9 8 ------....-........ 2164.73 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: THURSDAY AUG1120C5 09:42 RELEASE IO : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 -_..-- ---------- -----.... ...--- --...... --.... "'-----..----.. -- -----.. --.... ..-..-.. ---........ -.. --"'.. --.. -- ---...... -- "'.. .....--_.. --........ ------ --..-- -- ---....... -----.._- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ...---- ...-..-- ----- -- -..-- ...-.._..-- --.......... --- -- ---- ---.. --- --.. --- -----_.....- ---------- ----.... -- ---- ...-- ---.... ..----..-.. ---.... ...-- --.. --- ----- -------.. 07433 lMAGETEC L P IO" 90132779607 219.42 IO" 90132779607 100.00 IO "90132780238 638.84 IO# 90133508731 345.89 ...--- --- ------ 1304.15 07433 lMAGETEC LP IO #90132780236 319.42 06260 INR REGISTRATION FOR SEMINAR 79.00 01753 IPELRA Registration for Carol Widmer 150.00 00353 JANONIS, MICHAEL E. LUNCH/MTG. 68.08 01783 JOURNAL & TOPICS NEWSPAPERS SOOSCRIPTION/FIGOLAH 69.00 AD FOR BLOCK PARTY 305.00 ------------- 374.00 07821 KELLY, ERIN REIMBURSEMENT FOR COL RENEWAL 50.00 09211 KERRIGAN, MAUREEN REIMBURSEMENT 377 . 77 06995 KGI LANDSCAPING RELEASE OF SPRING RETAINAGE 237.80 04219 KIWANIS CLUB OF MT. PROSPECT MEMBERSHIP /VALENTINE 260.00 09lB8 KOSTYRA, JOZEF REBATE FOR 6 SQUARES OF POOLI C 255.00 01849 KUSTOM SIGNALS, INC. PARTS/LABOR FOR RECORDER 144.74 01861 LANDS' END BUSINESS OUTFITTERS 1 WORK SHIRT (JASMINE) 36.55 01866 LARRY ROESCH FORD BRAKE SWITCH/SCREEN FILTER ASS 35.45 REBUILD TRANSMISSION 2956.90 ----- ---- ---- 2992.35 08631 LEOlNER AND SONS 2005 UNIFORM RENTAL AND CLEANI 225.49 09108 LERCHBACKER, ERIN REIMBURSEMENT 50.00 09215 LOOMI S, BRYAi'i REIMB EXPENSES 47.30 01914 LUND INDUSTRIES I INC. INSTALL SIDE MIRROR 443.00 01918 LUNDSTROM I S NURSERY, INC. 2005 TURF MOWING CONTRACT 3789.32 LANDSCAPE MAINTENANCE - VARIOU 4047.22 LANDSCAPE MAINTENANCE - VARIOU 2.22 _a __... ._____ 7838.76 07800 MAGNUM FITNESS SYSTEMS Physical Training Equipment 7031.48 08731 MALKO TECH SERVI CES REPAIR DEFECTIVE STROBE 108.00 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: THURSDAY AUGl12005 09:42 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOMD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 ................ --.......... --.................. -............................................. -_.... --...... ---.... -........................ --....................................... --...................................................... --............ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ... -..-..... ---.. --........................ --.. --............... --................ --- --.................... --.............. --... -_..... --................................. --...... --...... -_............... -- -.............. -....... --..-- 05021 MENARDS TOOLS & CONNECTORS 16.68 00116 METRO FEDERAL CREDIT UNION PAYROLL FOR. 080405 1250.00 00117 METROPOLITAN ALLIANCE. POLICE PAYROLL FOR - 080405 702.00 08258 METROPOLITAN EMERGENCY SUPPORT SERV. MEMBERSHIP 400.00 06643 MICROSYSTEMS I INC. ACCIDENT REPORTS /DOCUMEllTS 1153.94 08574 MIKE GRECO LANDSCAPING, IIlC RELEASE OF SPRING RETAINAGE 231.50 00396 MILLER, JAMES SUPPLIES/CHILD SAFETY DAY 60.10 REIMB EXPENSES 65.23 REIMB EXPENSES 88.87 RE I MB EXPENSES 29.79 -------.. ----- 243.99 02046 MOBILE PRINT INC. COMMUNITY RELATIONS COMMISSION 89.30 08573 MONARREZ, AGUSTIN R/E TRANSFER STAMP REBATE 682.00 02067 MOUNT PROSPECT HISTORICAL SOC. 2005 BUDGET ALLOCATION 3125.00 00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 080405 15861.70 04581 NELS J. JOHNSON TREE EXPERTS REMOVAL/DISPOSAL ELM TREE 820.00 02148 NEOPOST INC. POSTAGE MACHINE SUPPLIES 164.90 02155 NEXTEL COMMUNICATIONS FIRE DEPT 5/18-6/17 582.84 VILLAGE MANAGER I S OFFICE 95.52 COMMUNITY DEVELOPMENT 545.47 HUMAN SERVICES 164.55 POLl CE DEPT. STANDARD FEES 1016.2 5 POLICE DEPT .MCAT NEXTEL I S 120.00 IT DIVISION 109.30 PUBLIC WORKS/GUENTHER 246.39 PUBLIC WORK 31.13 PUBLIC WORKS 344.20 -----..---- -..- 3255.65 02160 NFPA 1 FPW IN A BOX FIRE I S FURY PKG 405.50 TO BALANCE ADDITIONAL CHARGE 1.16 Learn Not To Bum Curriculum B 130.59 -------- ----- 537.25 02162 NI COR SERVICE FOR METER 4086742 5306.39 02189 NORTHWEST CENTRAL DISPATCH SYS MEMBER ASSESSMENT 43294.48 MEMBER ASSESSMENT 10823.62 ------.. ----- 54118.10 REPORT: APBOARDRPT GENERATED: 20 MAR OS 16:28 RUN: THURSDAY AUG1l200S 09 :42 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 . - -....... -...... --......................................................................................................................................... -..................... --.................................................................................................................. --........................................................................ DEFT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOulIT ............ --............................................................... --............ --.............................. --............... -................................... --...................................................... --..................... --............................................................... --..............................-- 02196 NORTHWEST MUNICIPAL CONFERENCE NWMC GOLF TOURNAMENT ELECTED 0 490.00 02210 NlJ1IillERS AUTOMATION INC ANNUAL PAPER SHREDDER AGREEMNT 275.00 07039 O.C.TANNER RECOGNITION CO. RETIREMENT GIFT 158.24 02228 OAKTON PAVILLION HEALTHCARE 775 HOME DELIVERED MEALS 1937.50 02256 PADDOCK PUBLICATIONS JOB ADS 1880.00 02256 PADDOCK PUBLICATIONS, INC. PUBLICATION OF CREEK CLEANING 29.19 PUBLICATION OF HVAC BID 38.92 ------ ------- 68.11 09203 PETERSON KYLE REIMBURSEMENT 50.00 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS 6.11 MISCELLANEOUS 21. 94 MISCELLANEOUS 14.69 MISCELLANEOUS 31.67 MISCELLANEOUS 45.00 MISCELLANEOUS 17.06 MISCELLANEOUS 15.30 MISCELLANEOUS 41.69 MISCELLANEOUS 2.18 MI SCELLANEOUS 275.19 -- -- ------ --- 470.83 02315 PIONEER PRESS SUBSCRIPTION 14.00 00124 POLICE PENSION FUND PAYROLL FOR - 080405 21571.31 04921 POPE, ELIZABETH A. PAYROLL FOR - 080405 92 3.0 8 09005 POSITIONING SOLUTIONS CO. MARKING PAINT 38.00 0871l QUALITY 1 MAINTENANCE, INC. 2005 CONTRACT FOR CUSTODIAL SE 8326.67 08573 RUDNICK, SUSANNE REAL ESTATE TAX REBATE 920.00 04673 SAN BERNARDINO COUNTY CHILD SUPPORT PAYMENTS PAYROLL FOR - 080405 115.38 07529 SCHAMBACH SOFTWARE SOLUTIONS, INC. CONSULTING SERVICES 5248.75 00125 SEIU LOCAL 73 PAYROLL FOR - 080405 802.90 02544 SHRED FIRST INC. SHREDDER BAGS 84.85 02618 STARS & STRIPES FLAG CO. 7 - 4 I X 6' VILLAGE FLAGS 1102.30 07282 STEINWEG, ANDREW REIMB FOR PURCHASE OF PIZZAS 45.72 07347 SUAREZ I MARINA REBATE-SENIOR RATE 24. CO REPORT: APBOARDRPT GENERATED: 20 M.~R 05 16:28 RUN: THURSDAY AUG1l2005 09:42 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOP.RD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 ...... ~_......... --.................. ~................................................... --.......... -_................-.................. --............. --......................................................................................... --.. --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT --....... --......... --....................................................... --...... -- --............................................... --................... --.......................................................................................... -.. -..-........ 08566 SWISTAK, DARIUSZ REFUND- DUP . PMT 63.00 02672 SYSTEMS FORMS, INC. ENVELOPES 300.00 ENVELOPES 198.75 CIP COMBS 190.65 AP CHECKS ENDING #4099 222.85 ---- ----.. ---.. 912.25 04532 TAYLOR RENTAL CENTER TENTS AND LIGHTS 733.50 08573 TAYLOR, TERRY L. REAL ESTATE TAX REBATE 1060.00 05378 THE SMILE PLACE 25 HATS/CITIZEN'S CORP 250.00 02691 THOMPSON ELEVATOR INSPECTIONS ELEVATOR INSPECTIONS 60.00 ELEVATOR INSPECTI ONS 60.00 ELEVATOR INSPECTIONS 420.00 ELEVATOR INSPECTIONS 70.00 ------..------ 610.00 08821 UNIFORMITY INCORPORATED DRESS HAT 29.50 04813 UNITED RENTAL HIGHWAY TECHNOLOGIES RENTAL OF 325 TYPE I BARR I CAnE 1537.50 02836 UNITED RENTALS HWY TECHNOLOGIES, INC. RENTAL OF WATER TRUCK 1654.10 DELIVERY CHARGE/PICKUP CHARGE 1654.10 RENTAL OF WATER TRUCK 157 4.1 0 CHARGE AND RENTAL PROTECTION 1574.10 --- ------.. --.. 6456.40 00127 UNITED WAY PAYROLL FOR - 080405 375.80 08893 'lID TECH 2 SPEAKER SOUND SYSTEM WITH MI 195.00 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 080405 20278.09 04314 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES PAYROLL FOR - 080405 129.15 PAYROLL FOR - 080405 167698.89 PAYROLL FOR - 080405 31896.47 PAYROLL FOR - 080405 16728.95 PAYROLL FOR - 080405 2187.52 --- --- -..----- 218640.98 09210 VITAS DONATION IN MEMORY G. WALTER 50.00 08573 WASSENAAR, CHARLES REAL ESTATE TRANSFER REBATE 610.00 00461 WIDMER, CAROL OFFICE SUPPLIES 64.40 05746 WISCTF PAYROLL FOR - 080405 542.48 09202 WOMENC.I\RE COUNSELING CE1>l"TER SEMINAR REGISTRATION 200.00 REPORT: APBOARDRPT GENERATED: 20 MAR OS 16: 28 RUN: THURSDAY AUG1l2005 09:42 PAGE RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 ~.............. __.. w_.. __.................................................................................. --.. ..--........ --.............................................................. --.......... --.......................... --........ --.. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ................ --........ --.................................... -- --........................ --.................................................. --.......... -_......................................................................................_- TOTAL : 506442.44 030 02016 ARC DISPOSAL COMPANY JULY SERVICE 62934.60 JULY SERVICE 12509.55 JULY SERVICE 37932.19 JULY SERVI CE 25678.99 JULY SERVICE 4267.44 JULY SERVICE m8.52 JULY SERVI CE 35046.00 --- --.. ---.. --- 180547 .29 08399 JP MORGAN CHASE BANK TIPPING FEES 94484.00 FIXED COSTS 6577.54 ----------....- 101061.54 02155 NEXTEL COMMUNICATIONS PUBLIC WORKS 26.17 TOTAL 281635. DO 050 01302 ALDRIDGE ELECTRIC, INC. 2005 TRAFFIC SIGNAL MAINTENANC 688.00 04952 CIORBA GROUP INC. 2005 BRIDGE REHABILITATION 752.00 PROFESSIONAL DESIGN SERVICES 3160.00 2005 BRIDGE REHABILITATION PRO 1079.45 ------------- 4991.4 5 01147 COMMONWEALTH EDISON MUNICIPAL STREET LIGHTING - 8730.80 TOTAL 14410.25 070 08678 ACE REMODLING CO. SFR REHAB - BOWMAN 4000.00 09206 AMERICAN CLASSIC EXTERIORS REHAB 1105 S CHERRYWOOD 13461.00 09214 C & J HOME IMPROVEMENTS REHAB -12 0 II' RUSSEL 13000.00 01090 CHI LDREN' S ADVOCACY CENTER CDBG SUB-RECIPIENT 1125.00 08509 PROPERTY INSIGHT ORDER #S9614675 (505 W LONNQUIS 60.00 02830 WAIST UP SPORTSWEAR MENTOR PROGRAM 540.00 TOTAL 32186.00 390 08399 JP MORGAN CHASE BANK BANK FEES 300.00 TOTAL 300.00 510 09216 UTILITY DYNAMICS CORP. INSTALL REPLACEMENT FOUNDATION 2768.00 REPORt': APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: THURSDAY AUG11200S 09: 42 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 DEPT VENDOR NBR 1JlIJIDOR NAME INVOICE DESCRIPTION ._ _ 8 _ _ _ _ _ _ _ _. _ _ _ _ _ _ _ _ _ _ __ _ _ _ _ _ _ _ _ _ _ _ _ _ __ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ __ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ___ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ __ _ _ _ _ _ _ _ _ _ _ _ _ _ _ __ _ ___ AMOUNT PAGE 560 TOTAL: 2768.00 02167 ARROW ROAD CONSTRUCTION 2005 STREET RESURFACING PROGRA TOTAL 33148.50 33148.50 590 04952 CIORBA GROUP mc. 2005 POND REHABILITATION PROJE 04621 STANLEY CONSULTANTS NPDES PHASE 2 STORM SEWER SURV TOTAL 1097B .19 6405.85 610 01124 ARTHUR CLESEN, INC. 45 - TREEGATOR WATER RESERVOIR 2 - l' NOZZLES 01147 COMMONWEALTH EDISON 203 E EVERGREEN - ACCOUNT BOOSTER PUMPING STATIONS - ACC 01283 DIXON ENGINEERING MAINTENANCE INSPECTION AND 08567 DORNQUAST I DORTHY G. REFUND FINAL WATER BILL 09050 ELAN INDUSTRIES, INC. SANITARY SEWER FLOW MONITORING 06160 ENTERPRISE RENT-A-CAR RENTAL CARS FOR THREE MONTHS 01377 FEDERAL EXPRESS CORP COURIER CHARGES 1/1/05 - 12/31 08567 GRENDZINSKI I GLENN REFUND OVERPAYMENT 01544 IlBK WATER METER SERVICE WATER METER INSTALLATION SERVI WATER METER READING SERVICES WATER METER TEST & REPAIR SERV SEWER INSPECTION SERVI CES 02325 JOSEPH G. POLLARD CO., INC. 1 - ECONOMY HYDRANT SHUT - OFF 08631 LECHNER AND SONS 2005 UNIFORM RENTAL AND CLEANI 01918 LUNDSTROM I S NURSERY I INC. 2005 TURF MOWING CONTRACT 01965 MARTAM CONSTRUCTION EMERGENCY REPAIRS 02155 NEXTEL COMMUNICATIONS PUBLIC WORKS PUBLIC WORKS 4572 .34 633.60 63.98 697.58 90.66 4121.02 4211.6 8 2670.00 17.96 3465.00 738.00 350.03 103.27 5215.00 608.60 208.00 960.00 6991.60 32.22 225.49 408.77 7488.00 283.76 33.99 317.7 5 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16: 28 RUN: THURSDAY AUG1l2005 09: 42 RELEASE JD : PAGE 10 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 08567 NIGLIACCIO, VITO REFUND FINAL WATER BILL 4.49 09208 PHILLIPS I JACOB REFUND 10.00 05119 PHOENI X I RR I GATI ON 12 - 30'-51' NELSON PRO 6000 R 158.04 04417 QUALITY BLACKTOP INC. 2005 ASPHALT RESTORATION CONTR 154.99 2005 ASPHALT RESTORATION CONTR 173.77 w ~.......... ~.. _.... 328.76 04621 STANLEY CONSULTANTS CONSTRUCTION ENGINEERING SERVI 737.30 07139 STRADA CONSTRUCTION CO. CONCRETE ROSTORATION CONTRACT 2712.13 04838 THIRD MILLENNIUM ASSOC. INC. UTILITY BILL PRINTING MAILING 1679.42 04054 WHITE SANDS SANBLASTING SANDBLASTING OF EXTERIOR SURFA 1500.00 TOTAL 34847.49 620 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS 26.00 08711 QUALITY 1 MAINTENANCE, INC. 2005 CONTRACT FOR CUSTODIAL SE 1780.00 07917 UTS GLOBAL, INC. RENTAL OF TEMP. PARKING MACHINE 343.00 TOTAL 2149.00 630 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS 34.50 MISCELLANEOUS 3.00 .. .-....... ............ 37.50 08711 QUALITY 1 MAINTENANCE, INC. 2005 CONTRACT FOR CUSTODIAL SE 290.00 07917 UTS GLOBAL, INC. SERVICE CALL 343.00 TOTAL 670.50 660 01937 ANTIOCH TIRE, INC. DISMOUNT & MOUNT TIRES 61.90 02108 ARLINGTON POWER EQUIPMENT ECHO MOTOR HOUSING ADAPTER 122.08 01014 CADE INDUSTRIES CUSTODIAL SUPPLIES FOR THE MON 589.28 CUSTODIAL SUPPLIES FOR THE MON 1616.60 ---.. --........ ..-- 2205.88 01851 LAB SAFETY SUPPLY BODY HARENSS VEST 129.80 01872 LATTOF A.%INGTON HEIGHTS PARTS & SERVICE FOR JULY 2005 315. CO PARTS & SERVICE FOR JULY 2005 295.26 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: THURSDAY AUG1l200S 09: 42 RELEASE!D : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BO.1l1m OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 PAGE 11 DEPT VENDOR NBR INVOICE DESCRIPTION - --.......... -- --...... - -........ -... - - -.. - -.... - - - - - - - -..... -- - - -- - -.. - - - -- -..... - - - - - -- -.. - - - -- - - - - -.. - - -............ - - - - - - - - - - - - - - - - - - - -.. -- -... - - - - - - -.. - - -- _.. - -- -- AMOUNT VENDOR NAME --.. --.. ---- --.. -.................. --................................................... --.. --................................................................................................................... --........ -_.... -- -.. ---..-- 06470 LYNCH AUTO GROUP - FORD FORD REPAIR PARTS 01990 MCMASTER-CARR SUPPLY CO. SCHEDULE 80 PVC PIPE 08599 METRO TAN!( AND PUMP CO. SERVICE CALL om5 MORRELL 10-415-6405 CJEN HYDRAULIC QUI 10-415-1405 CJEN HYDRAULIC QUI ESTIMATED FREIGHT om5 NEXTEL COMMUNI CATI ONS PUBLIC WORKS 05675 RUBBER INC. REMA REPAIR SEALANT 02575 SNAP-ON INDUSTRIAL EESP300D12 SNAP-ON MODIS ADDITIONAL CHARGE 02610 STANDARD EQUIPMENT COMPANY ELGIN SWEEPER REPAIR PARTS 02684 TERRACE SUPPLY COMPANY RENTAL OF GAS CYCLINDERS - 05004 VERIZON WIRELESS PAGER MESSAGING SERVICE 09217 WAYTEK, INC. PARTS TOTAL 11641.30 456.60 670 04579 CUSTOM VEHI CLE SYSTEMS, I NC . TRUCK VAULT P-1 MAGNUM MODEL 0 SHIPPING COST LABOR COST 800MHZ ANTENNA CABLE SET VHF ANTENA CABLE SET PAD FOR CAMERA ANTENA CIRCUIT BREAKER DYNAMAX GRILL MOUNT SIREN SPEA MAG LI GHT SYSTEM, 1- FRONT, 2 - R HEADLIGHT FLASHER A-2 LED PAR 36 ULTRABRITES FOR BRAKE/REVERSE STROBE UNIT A-2 LED DASH LIGHT FOR SIDE WI A- 2 LED 42' R/B/R LIGHT FOR A-2 LED MICROLITE SPLIT KIT FO D + R ARM REST (CA-01l9) DUAL BEVERAGE HOLDER JOTTO DESK CONSOLE FOR TAHOE JOTTO DESK COMPUTER ARM WITH G JOTTO DESK 28' FLOOR PLATE FOR 75 AMP RELAY 50 AMP RELAY 610.26 2511.5 5 316.03 337.50 510,75 852.00 18.42 1381.1 7 319.11 243.76 795.95 1. 00 796.95 2091. 02 12.90 44.79 1557.00 160.00 150.00 51.90 25.95 25.00 45.00 189.00 312.00 44.95 269.00 399.00 398.00 350.00 199.00 75.00 25.00 315.00 300,00 130.00 25.00 25.00 REPORT: APBOARDRPT GENERATED: 20 MAR OS 16: 28 RUN: THURSDAY AUG11200S 09: 42 RELEASE ID : PAGE 12 VI LLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 .. __....._ _Oo ___.._........ __ __ __ - ____.... _..____ WOo""" ....__ ___ ___ _wOo.... _____.. __........_ __.. __.... ___...___.... __........ wOo.... --- --- -- _..-.. -- -- -..--- -------- --....... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ___.. ..__.. ......___ ..___ __.... __ _____........ __ ____...... .._...... __ __.. __ ___.. ____ ....___ ......_.._ ...._ "__"""""Oo" __............ __.. __........ __.. w.... __.. ..__ ..___.... ..__ ...._..--.. 50 A."IP BREAKER 28.50 20 AMP RELAY 19.00 A-2 LED MICRO LIGHT A FOR ARRO 300.00 A-2 LED MICRO LIGHT KIT RRBB 333 .00 INSTALLATION UPGRADE FOR LED L 225.00 6 OUTLET POWER SUPPLY 226.00 A-2 LED BY THE INCH 18' Rim 398.00 FRONT CORNER STROBE KIT 219.00 CROSS BAR FOR GUN RACK FOR TRU 179,00 3 OUTLET ACCESSARY BOX, FRONT 49,90 TRUCK VAULT P-2 MAGNUM MODEL 0 1557.00 SHIPING COST 160.00 INSTALLATION COST 150.00 8915.20 TOTAL 8915.20 690 01102 CITIBANK, N.A. INS CLAIMS-GAB 6525.35 09205 HEALTH ENDEAVORS FINGER SPRAIN : ANTHONY MINARCIK HERNIA: TODD NOVAK 50.00 50.00 100.00 02192 NORTHWEST COMMUNITY HOSPITAL RI CHARD SCHWEGLER JOHN MURPHY - LOWER BACK STRAIN 833,14 639.93 1473.07 TOTAL 8098.42 no 08567 CHONG SUK YUM APRIL 2005-POLICE FUND 1847.64 MAY 2005- POLICE FUND 1860.75 .. ..--- ----.. --- 3708.39 TOTAL 3708.39 APRIL 2005- FIRE FUND 2437.56 MAY 2005-FIRE FUND 2453.22 ------- ..-- -..- 4890.78 TOTAL 4890.78 EMPLOYER DENTAL PLAN 5215.51 TOTAL 5215.51 OVERPAYMENT/FINAL BILL 98.78 01027 CAPITAL GAINS INC. 720 01027 CAPITAL GAINS INC. 770 08178 GUARDIAN 790 REPORT: APBOARDRPT GENERATED: 2D MAR 05 16:28 RUN: THURSDAY AUG1l2005 09:42 RELEASE in : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 PAGE 13 DEPT VENDOR NBR INVOICE DESCRIPTION --- -.... -- -- ---... - - - - - - - -... - - - -- - - - - -... - -...... -......... - - - -- - -................................................ -... --................................. -- --................................................................................. -......... ---............... -- --............ AMOUNT VENDOR NAME --... --........................ -.................................... --... -......... --... --.................................... -...... --...... -............... -.... --................ --... --... -- --..................... ---.................. --......... -........................................................................... 08567 GEORGE ASSELIN OVERPAYMENT FINAL BILL 02072 MOUNT PROSPECT PUBLI C LIBRARY PPRT 6TH ALLOCATION 01719 NCPERS GROUP LIFE PREMIUM-AUGUST 2005 08572 SHAH, NALIN K. OVERPAYMENT 02622 STATE OF ILLINOIS FINGERPRINT RECORD CHECK 02689 THIRD DISTRICT CIRCUIT COURT BOND MONEY BOND MONEY BOND MONEY BOND MONEY 02808 VILLAGE OF MOUNT PROSPECT INSPECTION TOTAL GRAND TOTAL 4.49 5537.16 368.00 5.00 88.00 600.00 2900.00 842.00 2687.00 7029.00 4900.00 18030.43 980035.40 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: THURSDAY AUG1l2005 09:42 RELEASE lD : PAGE 14 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JULY 28 2005 TO AUGUST 10 2005 .... --.. ~.. --............ --.... -.. -- --............................................................................................................................................................ --........ --...................... --.. -.... --.. SUMMARY BY FUND .... -- --.......... ---...... --.. --- -- -- --........................ --.................................................................. --_.. --................ --.................................................................. -_........ 001 GENERAL FUND 506442.44 030 REFUSE DISPOSAL FUND 281635.00 050 MOTOR FUEL TAX FUND 14410.25 070 COMMUNITY DEVELPMNT BLOCK GRNT 32186.00 390 SERIES 2000 B&I I FLOOD CONTROL 300.00 510 CAPITAL IMPROVEMENT FUND 2768.00 560 STREET IMPROVEMENT CONST FUND 33148.50 590 FLOOD CONTROL CONST FUND 10978.19 610 WATER AND SEWER FUND 34847.49 620 VILLAGE PARKING SYSTEM FUND 2149.00 630 PARKING SYSTEM REVENUE FUND 670.50 660 VEHI CLE MAINTENANCE FUND 11641.30 670 VEHI CLE REPLACEMENT FUND 8915.20 690 RISK MANAGEMENT FUND 8098.42 710 POLICE PENSION FUND 3708.39 720 FIRE PENSION FUND 4890.78 770 FLEXCOMP ESCROW FUND 5215.51 790 ESCROW DEPOSIT FUND 18030.43 -------------- TOTAL : 980035.40 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES July 1 - July 31, 2005 08/11/2005 09:31:15 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/05 07/31/05 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 59,663 1,135,702 100,460 920,335 1,527,147 68,289 637,543 11,452 222,965 321,695 5,005,251 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 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 1996B B&I, TIF SERIES 1998B 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 2001 PROJECT 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 2,038,859 106,209 128,779 1 76,457 130 128 2,371 959 2,196 1,041 3,509 331 o o 7,800 18,209 6,065 1,370 47,677 31,548 8,921 -121,748 -40,065 4,139 o o 7,210 522,302 2,470 639,763 8,944 10,595 131,032 96,966 16,416 564,525 1 Y-T-D Received 5,877,513 5,769,445 2,305,033 6,374,568 9,114,438 331,121 1,863,098 292,695 2,482,147 2,307,345 36,717,403 16,825,371 1,772,553 837,282 53 284,298 1,027 968 13,609 74,693 194,556 455,105 268,410 14,471 o o 354,633 63,136 21,062 60,252 165,001 109,131 31,839 86,519 29,136 103,996 o o 1,388,339 700,346 24,320 4,457,762 61,578 62,017 788,733 640,667 102,151 3,509,326 7 Months 5 Months 2005 Budget 11,980,598 12,838,924 2,801,736 15,620,370 16,118,285 527,100 4,591,120 452,592 4,325,383 2,205,000 71,461,108 33,124,588 3,341,773 1,669,600 10,000 499,000 500 12,250 10,100 151,700 390,128 927,912 521,626 36,150 o o 888,500 186,083 61,961 151,000 492,844 323,779 89,508 252,000 83,000 231,276 o o 2,122,075 1,365,165 12,000 8,493,217 116,236 236,825 1,309,945 1,058,035 161,201 5,679.931 58.3% 41.6% Unreceived Balance 6,103,085 7,069,479 496,703 9,245,802 7,003,847 195,979 2,728,022 159,897 1,843,236 -102,345 34,743,705 16,299,217 1,569,220 832,318 9,947 214,702 -527 11,282 -3,509 77,007 195,572 472,807 253,216 21,679 o o 533,867 122,947 40,899 90,748 327,843 214,648 57,669 165,481 53,864 127,280 o o 733,736 664,819 -12,320 4,035,455 54,658 174,808 521,212 417,368 59,050 2,170,605 Completed Remaining Unreceived Percent 50.9 55.1 17.7 59.2 43.5 37.2 59.4 35.3 42.6 -4.6 48.6 49.2 47.0 49.9 99.5 43.0 -105.4 92 .1 -34.7 50.8 50.1 51.0 48.5 60.0 60.1 66.1 66.0 60.1 66.5 66.3 64.4 65.7 64.9 55.0 34.6 48.7 -102.7 47.5 47.0 73.8 39.8 39.4 36.6 38.2 08/11/2005 09:31:15 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/05 07/31/05 7 Months 5 Months 58.3% 41. 6% Completed Remaining Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent POLICE PENSION FUND 535,597 1,523,486 3,686,073 2,162,587 58.7 FIRE PENSION FUND 145,258 1,671,727 3,740,910 2,069,183 55.3 BENEFIT TRUST #2 FUND 0 0 0 0 ESCROW DEPOSIT FUND -1,035 0 0 0 SSA #6 GEORGE/ALBERT B&I 314 18,679 24,217 5,538 22.9 SERIES 2002 LIBRARY BND ESCROW 8 1,171 0 -1,171 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 5,005,251 36,717,403 71,461,108 34,743,705 48.6 2 008jnj2005 7 Months 58.3% Completed 09:31:35 5 Months 41.6% Remaining FRRBRR03 VILLAGE OF MOUNT PROSPECT SUM on Budget Revenue by Category within Fund Summary 01/01/05 07/31/05 Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent GENERAL FUND 40 PROPERTY TAXES 42,430 4,180,580 8,533,459 4,352,879 51. 0 41 OTHER TAXES 654,231 3,289,915 6,855,967 3,566,052 52.0 42 LICENSES, PERMITS & FEES 91,089 2,094,604 2,569,500 474,896 18.5 43 INTERGOVERMENT REV. 767,188 5,365,252 13,272,415 7,907,163 59.6 44 CHARGES FOR SERVICE 72,050 423,216 769,431 346,215 45.0 45 FINES AND FORFEITS 65,949 317,393 505,000 187,607 37.1 46 INVESTMENT INCOME 10,235 87,890 156,000 68,110 43.7 47 REIMBURSEMENTS 5,629 135,819 285,116 149,297 52.4 48 OTHER REVENUE 8,363 109,007 177,700 68,693 38.7 49 OTHER FINANCING SOURCES 321,695 821,695 0 -821,695 TOTAL GENERAL FUND 2,038,859 16,825,371 33,124,588 16,299,217 49.2 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 11,320 1,114,956 2,266,973 1,152,017 50.8 44 CHARGES FOR SERVICE 90,738 623,827 1,044,800 420,973 40.3 46 INVESTMENT INCOME 4,151 33,088 30,000 -3,088 -10.3 48 OTHER REVENUE 0 682 0 -682 TOTAL REFUSE DISPOSAL FUND 106,209 1,772,553 3,341,773 1,569,220 47.0 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 126,716 810,521 1,647,100 836,579 50.8 46 INVESTMENT INCOME 2,063 22,053 20,000 -2,053 -10.3 47 REIMBURSEMENTS 0 4,708 2,500 -2,208 -88.3 TOTAL MOTOR FUEL TAX FUND 128,779 837,282 1,669,600 832,318 49.9 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 0 0 10,000 10,000 100.0 46 INVESTMENT INCOME 1 53 0 -53 TOTAL LAW ENFORCEMENT BLOCK GRANT 1 53 10,000 9,947 99.5 COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 26,431 198,795 449,000 250,205 55.7 46 INVESTMENT INCOME 26 30 0 -30 48 OTHER REVENUE 50,000 85,473 50,000 -35,473 -70.9 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 76,457 284,298 499,000 214,702 43.0 ASSET SEIZURE FUND 45 FINES AND FORFEITS 0 288 100 -188 -188.0 46 INVESTMENT INCOME 130 739 400 -339 -84.8 TOTAL ASSET SEIZURE FUND 130 1,027 500 -527 -105.4 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 0 0 12,000 12,000 100.0 46 INVESTMENT INCOME 128 968 250 -718 -287.2 1 08/11/2005 09:31:35 FRRBRR03 SUM 021 7 Months 5 Months Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/05 07/31/05 Cur Mo Received TOTAL DEA SHARED FUNDS FUND 128 DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 2,340 31 TOTAL DUI FINE FUND 2,371 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME 757 202 TOTAL SERIES 1987A B&I, PW FACILITY 959 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 1,958 238 o TOTAL SERIES 2001 B&I, VILLAGE HALL 2,196 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 508 533 o TOTAL SERIES 2003 B&I, VILLAGE HALL 1,041 SERIES 2002B B&I, PUBLIC BLDGS 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 2,690 819 o TOTAL SERIES 2002B B&I, PUBLIC BLDGS 3,509 SERIES 2002A B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 253 78 o TOTAL SERIES 2002A B&I, TIF 331 SERIES 1996B B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 1996B B&I, TIF SERIES 1998B B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 2 Y-T-D Received 968 13,440 169 13,609 73,840 853 74,693 192,949 1,607 o 194,556 50,478 2,127 402,500 455,105 264,710 3,700 o 268,410 14,077 394 o 14,471 o o o o o o 2005 Budget 12,250 10,000 100 10,100 151,500 200 151,700 389,628 500 o 390,128 121,912 1,000 805,000 927,912 517,126 4,500 o 521,626 36,050 100 o 36,150 o o o o o o o unreceived Balance o o o o o 58.3% 41.6% 11,282 -3,440 -69 -3,509 77,660 -653 77,007 196,679 -1,107 o 195,572 71,434 -1,127 402,500 472,807 252,416 800 o 253,216 21,973 -294 o 21,679 Completed Remaining Unreceived Percent 92.1 -34.4 -69.0 -34.7 51.3 -326.5 50.8 50.5 -221.4 50.1 58.6 -112.7 50.0 51.0 48.8 17.8 48.5 61.0 -294.0 60.0 o o o o o o 08/11/2005 09:31:35 FRRBRR03 SUM 021 7 Months 5 Months Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/05 - 07/31/05 Cur Mo Received TOTAL SERIES 1998B B&I, TIF SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 6,220 1,580 o TOTAL SERIES 1999 B&I, TIF 7,800 SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 17,957 252 TOTAL SERIES 1996A B&I, FLOOD 18,209 SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 5,986 79 o TOTAL SERIES 1998A B&I, FLOOD 6,065 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 1,054 316 TOTAL SERIES 1998C B&I, TIF 1,370 IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 47,677 o TOTAL IEPA FLOOD CONTROL LOANS B&I 47,677 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 31,309 239 o TOTAL SERIES 2000 B&I, FLOOD CONTROL 31,548 SERIES 2002B B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 8,564 357 o TOTAL SERIES 2002B B&I, FLOOD 8,921. SERIES 1998A B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES -121,909 161 o 3 Y-T-D Received o 345,577 9,056 o 354,633 62,118 1,018 63,1.36 20,706 356 o 21.,062 58,572 1,680 60,252 164,929 72 1.65,001. 108,307 824 o 109,131 29,625 2,214 o 31,839 84,348 2,171. o 2005 Budget o 885,000 3,500 o 888,500 185,583 500 186,083 61,861 100 o 61,961 150,000 1,000 151,000 492,744 100 492,844 323,579 200 o 323,779 88,508 1,000 o 89,508 252,000 o o o unreceived Balance 58.3% 41.6% 539,423 -5,556 o 533,867 123,465 -518 122,947 41,155 -256 o 40,899 91,428 -680 90,748 327,81.5 28 327,843 215,272 -624 o 214,648 58,883 -1,214 o 57,669 167,652 -2,171 o Completed Remaining unreceived Percent o 61.. 0 -158.7 60.1 66.5 -103.6 66.1 66.5 -256.0 66.0 61.. 0 -68.0 60.1 66.5 28.0 66.5 66.5 -312.0 66.3 66.5 -121. 4 64.4 66.5 FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT Revenue by Category 01/01/05 PROSPECT within Fund Summary 07/31/05 7 Months 5 Months 58.3% Completed Remaining 08/11/2005 09:31:35 41.6% Cur Mo Received Y-T-D Received 2005 Budget Unreceived Balance Unreceived Percent TOTAL SERIES 1998A B&I, STREET IMP. -121,748 86,519 252,000 165,481 65.7 SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES -40,153 27,781 83,000 55,219 66.5 46 INVESTMENT INCOME 88 1,355 0 -1,355 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2002B B&I, STREET IMP. -40,065 29,136 83,000 53,864 64.9 CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 0 0 112,400 112,400 100.0 46 INVESTMENT INCOME 4,139 34,390 15,000 -19,390 -129.3 47 REIMBURSEMENTS 0 35,356 78,876 43,520 55.2 48 OTHER REVENUE 0 34,250 25,000 -9,250 -37.0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL CAPITAL IMPROVEMENT FUND 4,139 103,996 231,276 127,280 55.0 SERIES 2001 PROJECT FUND 46 INVESTMENT INCOME 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2001 PROJECT FUND 0 0 0 0 SERIES 2003 PROJECT FUND 46 INVESTMENT INCOME 0 0 0 0 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2003 PROJECT FUND 0 0 0 0 DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 5,229 290,509 743,975 453,466 61.0 46 INVESTMENT INCOME 1,981 8,593 2,000 -6,593 -329.7 47 REIMBURSEMENTS 0 36,087 36,100 13 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 1,053,150 1,340,000 286,850 21.4 TOTAL DOWNTOWN REDEVLPMNT CONST 7,210 1,388,339 2,122,075 733,736 34.6 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 513,119 465,356 1,124,715 659,359 58.6 42 LICENSES, PERMITS & FEES 8,061 205,519 225,000 19,481 8.7 46 INVESTMENT INCOME 1,122 16,471 15,450 -1,021 -6.6 48 OTHER REVENUE 0 13,000 0 -13,000 TOTAL STREET IMPROVEMENT CONST FUND 522,302 700,346 1,365,165 664,819 48.7 FLOOD CONTROL CaNST FUND 41 OTHER TAXES 0 0 0 0 43 INTERGOVERMENT REV. 0 0 0 0 46 INVESTMENT INCOME 2,470 24,320 12,000 -12,320 -102.7 4 '08/11/2005 09:31:36 FRRBRR03 SUM 021 7 Months 5 Months Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/05 07/31/05 Sununary Cur Mo Received 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES TOTAL FLOOD CONTROL CONST FUND 2.470 WATER AND SEWER FUND 4 1 OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 4 8 OTHER REVENUE 49 OTHER FINANCING SOURCES 5,923 710 621,436 5,082 o 6,612 o TOTAL WATER AND SEWER FUND 639.763 VILLAGE PARKING SYSTEM FUND 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 600 7,838 506 o TOTAL VILLAGE PARKING SYSTEM FUND 8.944 PARKING SYSTEM REVENUE FUND 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 4 8 OTHER REVENUE 49 OTHER FINANCING SOURCES o o 10,444 151 o o TOTAL PARKING SYSTEM REVENUE FUND 10.595 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 130,245 787 o TOTAL VEHICLE MAINTENANCE FUND 131.032 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 88,303 8,663 o o TOTAL VEHICLE REPLACEMENT FUND 96.966 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 14,921 1,495 5 Y-T-D Received o o 24.320 789.297 710 3,583.923 53,638 o 30,194 o 4.457.762 4,200 54,205 3,173 o 61,578 o o 61,144 873 o o 62.017 781.467 7,266 o 788.733 529,820 80,847 o 30,000 640.667 89,521 12,630 2005 Budget o o 12.000 1,531,825 o 6,892,392 54,000 o 15,000 o 8.493.217 7,236 108,000 1,000 o 116.236 o 129,455 103,250 4,120 o o 236.825 1,302,445 7,500 o 1.309.945 883,035 115,000 o 60,000 1.058,035 149,201 12,000 58.3% 41.6% unreceived Balance o o Completed Remaining unreceived Percent o o -12.320 -102.7 742,528 -710 3,308,469 362 o -15,194 o 4.035,455 3,036 53,795 -2,173 o 54.658 o 129,455 42,106 3,247 o o 174,808 520.978 234 o 521,212 353,215 34,153 o 30,000 417.368 59,680 -630 48.5 48.0 0.7 -101. 3 47.5 42.0 49.8 -217.3 47.0 100.0 40.8 78.8 73.8 40.0 3.1 39.8 40.0 29.7 50.0 39.4 40.0 -5.3 08/11/2005 09,31,36 FRRBRR03 SUM 021 7 Months 5 Months 58.3% 41. 6% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/05 07/31/05 Cur Mo Received TOTAL COMPUTER REPLACEMENT FUND 16,416 RISK MANAGEMENT FUND 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE o 491,172 3,072 5,823 64,458 TOTAL RISK MANAGEMENT FUND 564,525 POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 485,561 50,036 TOTAL POLICE PENSION FUND 535,597 FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 101,762 43,496 TOTAL FIRE PENSION FUND 145,258 BENEFIT TRUST #2 FUND 46 INVESTMENT INCOME TOTAL BENEFIT TRUST #2 FUND ESCROW DEPOSIT FUND 46 INVESTMENT INCOME -1,035 TOTAL ESCROW DEPOSIT FUND -1,035 SSA #6 GEORGE/ALBERT B&I 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SSA #6 GEORGE/ALBERT B&I 314 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME TOTAL SERIES 2002 LIBRARY END ESCROW GENERAL FIXED ASSETS ACCT GP 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES TOTAL GENERAL FIXED ASSETS ACCT GP 6 Y-T-D Received 102,151 o 2,967,315 19,344 80,725 441,942 3,509,326 643,000 880,486 1,523,486 784,614 887,113 1,671,727 o o 242 72 18,328 351 18,679 8 1,171 8 1,171 o o o 2005 Budget 161,201 o 4,865,731 20,000 50,000 744,200 5,679,931 2,002,000 1,684,073 3,686,073 2,111,500 1,629,410 3,740,910 o o o o 24,117 100 24,217 o o o Unreceived Balance 59,050 o 1,898,416 656 -30,725 302,258 2,170,605 1,359,000 803,587 2,162,587 1,326,886 742,297 2,069,183 o o o o Completed Remaining unreceived Percent 36.6 39.0 3.3 -61. 5 40.6 38.2 67.9 47.7 58.7 62.8 45.6 55.3 o o o o 5,789 24.0 -251 -251.0 5,538 o -1,171 o -1,171 o o o 22.9 o o o '08/11/2005 09,31:36 FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/05 - 07/31/05 7 Months 5 Months 58.3% 41. 6% Completed Remaining Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES 0 0 8,536,993 8,536,993 100.0 TOTAL MOUNT PROSPECT LIBRARY FUND 0 0 8,536,993 8,536,993 100.0 7 7 Months 5 Months 08/11/2005 09:30:20 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/05 07/31/05 Cur Mo Expended Y-T-D Expended 2005 Budget 58.3% 4l.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 IW",OVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS INFRASTRUCTURE BOND PRINCIPAL INTEREST EXPENSE BANK AND FISCAL FEES INTERFUND TRANSFERS Total All Funds 1,745,720 521,874 21,965 385,566 1,339,750 28,392 518,062 86,587 4,314 1,616 7,177 2,628 80,659 39,082 10,620 211,583 694,799 117,645 1,050 o 5,819,089 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 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 1996B B&I, TIF SERIES 1998B 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 2001 PROJECT FUND SERIES 2003 PROJECT FUND DOWNTOWN REDEVLPMNT CONST 2,497,581 428,036 20,927 o 33,064 o 21,472 7,013 o o o o o o o 792,800 450 300 300 19,644 o o o o 7,296 o 2,760 16,582 11,976,065 4,315,162 137,963 2,703,128 7,216,178 169,720 3,564,517 629,219 210,529 7,971 48,586 174,425 812,098 216,867 515,430 2,266,889 913,628 752,623 2,850 437,083 37,070,93J. 18,288,732 1,983,561 1,400,393 769 227,844 o 27,852 23,227 o 100,064 230,966 9,176 825 o o 905,900 9,050 4,141 11,648 326,321 56,049 3,581 o o 56,130 o 56,271 247,924 1 22,294,318 7,809,507 339,313 4,746,868 13,655,851 539,816 6,401,091 1,142,134 468,577 21,030 505,305 346,085 1,339,635 566,500 1,175,000 3,986,891 3,344,867 1,3J.5,860 6,000 805,000 70,809,648 33,989,385 3,634,727 2,161,672 o 743,473 7,000 1,000 1,000 67,000 390,128 911,932 6J.0,05J. 36,650 o o 906,200 213,100 62,983 153,295 613,355 292,098 246,46J. o o 665,914 o 22,000 291,064 10,318,253 3,494,345 201,350 2,043,740 6,439,673 370,096 2,836,574 512,915 258,048 13,059 456,719 171,660 527,537 349,633 659,570 1,720,002 2,431,239 563,237 3,150 367,917 33,738,717 15,700,653 J.,65J.,166 761,279 -769 5J.5,629 7,000 -26,852 -22,227 67,000 290,064 680,966 600,875 35,825 o o 300 204,050 58,842 141,647 287,034 236,049 242,880 o o 609,784 o -34,271 43,140 46.3 44.7 59.3 43.1 47.2 68.6 44.3 44.9 55.1 62.1 90.4 49.6 39.4 6l. 7 56.1 43.1 72.7 42.8 52.5 45.7 47.6 46.2 45.4 35.2 69.4 100.0 **** * **** * 100.0 74.4 74.7 98.5 97.7 95.8 93.4 92.4 46.8 80.8 98.5 91.6 -155.8 14.8 .08/11/2005 09:30:20 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/05 07/31/05 7 Months 5 Months 58.3% 41.6% Completed Remaining Cur Mo Y-T-D 2005 Unexpended Unexpended Expended Expended Budget Balance Percent STREET IMPROVEMENT CONST FUND 159,994 767,570 1,165,709 398,139 34.2 FLOOD CONTROL CONST FUND 19,877 144,255 583,413 439,158 75.3 WATER AND SEWER FUND 761,142 4,619,566 9,279,528 4,659,962 50.2 VILLAGE PARKING SYSTEM FUND 12,469 93,797 262,485 168,688 64.3 PARKING SYSTEM REVENUE FUND 9,752 77,917 266,069 188,152 70.7 VEHICLE MAINTENANCE FUND 102,396 700,730 1,275,883 575,153 45.1 VEHICLE REPLACEMENT FUND 80,659 812,098 1,339,635 527,537 39.4 COMPUTER REPLACEMENT FUND 2,549 107,440 199,700 92,260 46.2 RISK MANAGEMENT FUND 440,988 3,102,675 5,683,550 2,580,875 45.4 POLICE PENSION FUND 185,182 1,330,694 2,366,440 1,035,746 43.8 FIRE PENSION FUND 195,856 1,342,365 2,328,948 986,583 42.4 BENEFIT TRUST #2 FUND 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 0 1,400 37,800 36,400 96.3 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 GENERAL LONG-TERM DEBT ACCT GP 0 0 0 0 Total All Funds 5,819,089 37,070,931 70,809,648 33,738,717 47.6 2 06/11/2005 09,32,02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 NON-DEPARTMENTAL Cur Mo Expended 2005 Budget Unexpended Unexpended Balance Percent Y-T-D Expended PROGRAM TOTALS 00 ADMINISTRATION o o Totals o o EXPENDITURE CLASSIFICATION 72 INTEREST EXPENSE 80 INTERFUND TRANSFERS o o o o Totals o o SOURCE OF FUNDS 270 SERIES 1996B B&I, TIF 280 SERIES 1998B B&I, TIF 930 GENERAL LONG-TERM DEBT ACCT GP o o o o o o Totals o o 1 58.3% Completed 41.6% Remaining o o o o o o o o o o o o o o o o o o '0.8/11/2005 09:32:02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 PUBLIC REPRESENTATION Cur Mo Expended PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 03 ADVISORY BOARDS & COMMISSIONS 4,805 1,114 Totals 5,919 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 2,830 448 o 1,889 15 737 o Totals 5,919 SOURCE OF FUNDS 001 GENERAL FUND 5,919 Totals 5,919 2 Y-T-D Expended 78,719 8,758 87,477 19,962 3,358 o 62,090 30 2,037 o 87,477 87,477 87,477 2005 Budget 101,845 15,538 117,383 34,690 5,891 2,000 68,702 500 5,600 o 117,383 117,383 117,383 58.3% 41. 6% Unexpended Balance 23,126 6,780 29,906 14,728 2,533 2,000 6,612 470 3,563 o 29,906 29,906 29,906 Completed Remaining Unexpended Percent 22.7 43.6 25.5 42.5 43.0 100.0 9.6 94.0 63.6 25.5 25.5 25.5 '08/11/2'0'05 '09:32:'02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 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 INFOR~~TION 31,829 27,436 6,779 48,732 13,817 Totals 128,593 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 46,569 18,496 981 61,336 340 792 79 o Totals 128,593 SOURCE OF FUNDS 001 GENERAL FUND 128,593 Totals 128,593 3 Y-T-D Expended 242,012 151,586 108,780 333,812 64,209 900,399 368,722 126,004 10,105 378,986 1,672 3,973 10,937 o 900,399 900,399 900,399 ;:005 Budget 425,909 350,000 274,710 764,071 133,062 1,947,752 768,341 231,423 35,800 876,908 7,530 10,850 16,900 o 1,947,752 1,947,752 1,947,752 58.3% 41.6% Unexpended Balance 183,897 198,414 165,930 430,259 68,853 1,047,353 399,619 105,419 25,695 497,922 5,858 6,B77 5,963 o 1,047,353 1,047,353 1,047,353 Completed Remaining Unexpended Percent 43.2 56.7 60.4 56.3 51. 7 53.8 52.0 45.6 n.B 56.8 77.B 63.4 35.3 53.8 53.8 53.8 .008/11/2005 09:32:02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 07/31/05 TV SERVICES DIVISION Cur Mo Expended PROGRAM TOTALS 02 CABLE TV OPERATIONS 03 OTHER SERVICES 04 INTERGOVERNMENTAL PROGRAMMING 10,211 o 3,159 Totals 13,370 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 7,873 3,344 o 896 102 584 571 Totals 13,370 SOURCE OF FUNDS 001 GENERAL FUND 13,370 Totals 13,370 4 Y-T-D Expended 102,422 o 23,750 126,172 52,295 21,234 555 3,499 528 3,551 44,510 126,172 126,172 126,172 2005 Budget 167,850 o 45,907 213,757 95,469 36,767 2,450 11,471 2,000 7,850 57,750 213,757 213,757 213,757 58.3% 41.6% Unexpended Balance 65,428 o 22,157 87,585 43,174 15,533 1,895 7,972 1,472 4,299 13,240 87,585 87,585 87,585 Completed Remaining Unexpended Percent 39.0 48.3 41.0 45.2 42.2 77 .3 69.5 73.6 54.8 22.9 41.0 41.0 41.0 08/11/2005 7 Months 58.3% Completed 09:32:02 VILLAGE OF MOUNT PROSPECT 5 Months 41.6% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/05 - 07/31/05 Cur Mo Y-T-D 2005 Unexpended unexpended VILLAGE CLERK'S OFFICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 10,844 92,601 171,874 79,273 46.1 Totals 10,844 92,601 171,874 79,273 46.1 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 5,287 50,968 93,550 42,582 45.5 51 EMPLOYEE BENEFITS 3,068 21,466 37,464 15,998 42.7 52 OTHER EMPLOYEE COSTS 240 548 1,700 1,152 67.8 54 CONTRACTUAL SERVICES 1,274 15,895 33,160 17,265 52.1 55 UTILITIES 51 266 1,600 1,334 83.4 57 COMMODITIES & SUPPLIES 924 3,458 4,400 942 21. 4 Totals 10,844 92,601 171,874 79,273 46.1 SOURCE OF FUNDS 001 GENERAL FUND 10,844 92,601 171,874 79,273 46.1 Totals 10,844 92,601 171,874 79,273 46.1 5 0~/1l/2005 09:32:02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 FINANCE DEPARTMENT Cur Mo Expended PROGRAM TOTALS 01 FINANCE ADMINISTRATION 02 ACCOUNTING 03 DATA PROCESSING 04 DUPLICATING SERVICES 05 INSURANCE PROGRAMS 06 CUSTOMER SERVICES 07 CASH MANAGEMENT 17,864 32,984 o o 51,926 28,061 2,547 Totals 133,382 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 55,073 23,236 1,023 4,587 194 46,647 2,622 o Totals 133,382 SOURCE OF FUNDS 001 GENERAL FUND 133,382 Totals 133,382 6 Y-T-D Expended 130,804 211,190 o 660 316,290 204,963 17,671 881,578 400,526 149,154 4,350 38,539 1,010 279,884 8,165 -50 881,578 881,578 881,578 2005 Budget 214,409 408,087 o o 530,277 371,829 45,753 1,570,355 730,343 262,358 7,850 70,450 6,200 466,474 24,680 2,000 1,570,355 1,570,355 1,570,355 58.3% 41.6% Unexpended Balance 83,605 196,897 o -660 213,987 166,866 28,082 688,777 329,817 113,204 3,500 31,911 5,190 186,590 16,515 2,050 688,777 688,777 688,777 Completed Remaining Unexpended Percent 39.0 48.2 40.4 44.9 61. 4 43.9 45.2 43.1 44.6 45.3 83.7 40.0 66.9 102.5 43.9 43.9 43.9 08/11/2005 09,32,02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 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 15,642 19,062 5,031 58,554 24,378 9,168 Totals 131,835 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 84,269 36,584 510 7,494 996 1,982 o Totals 131,835 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 131,835 o Totals 131,835 7 Y-T-D Expended 113,036 105,551 37,714 403,366 160,815 63,472 883,954 570,784 230,943 10,915 57,846 4,814 8,652 o 883,954 883,154 800 883,954 2005 Budget 200,832 218,429 100,765 747,150 309,779 116,969 1,693,924 1,085,973 408,210 15,523 142,738 25,776 12,704 3,000 1,693,924 1,693,426 498 1,693,924 58.3% 41.6% Unexpended Balance 87,796 112,878 63,051 343,784 148,964 53,497 809,970 515,189 177,267 4,608 84,892 20,962 4,052 3,000 809,970 810,272 -302 809,970 Completed Remaining Unexpended Percent 43.7 51. 7 62.6 46.0 48.1 45.7 47.8 47.4 43.4 29.7 59.5 81.3 31. 9 100.0 47.8 47.8 -60.6 47.8 08/11/2005 09,32,02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 COMMUNITY DEVELOPMENT - CDBG Cur Mo Expended PROGRAM TOTALS 04 CDBG ADMINISTRATION OS CDBG COMMUNITY PROGRAMS 06 ACCESSIBLTY & NEIGHBRHD IMPRV 07 CDBG RESIDENTIAL REHAB 6,50B 17,313 4,417 4,B26 Totals 33,064 EXPENDITURE CLASSIFICATION SO PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 64 BUILDING IMPROVEMENTS 69 INFRASTRUCTURE 5,lBB 1,832 o 17,313 o 4,314 4,417 o Totals 33.064 SOURCE OF FUNDS 001 GENERAL FUND 070 COMMUNITY DEVELPMNT BLOCK GRNT o 33,064 Totals 33.064 8 Y-T-D Expended 32,606 67,490 69,695 5B,053 227.844 21,904 9,952 82 68,104 566 57,541 4,417 65,278 227.844 o 227,844 227,844 2005 Budget 71,623 105,500 26B,350 298,000 743.473 48,263 18,475 1,075 122,915 1,395 283,000 55,850 212,500 743.473 o 743,473 743.473 58.3% 41.6% Unexpended Balance 39,017 38,010 198,655 239,947 515.629 26,359 8,523 993 54,811 829 225,459 51,433 147,222 515,629 o 515,629 515,629 Completed Remaining Unexpended Percent 54.5 36.0 74.0 BO.5 69.4 54.6 46.1 92.4 44.6 59.4 79.7 92.1 69.3 69.4 69.4 69.4 OS/11/2005 09,32,02 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 07/31/05 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 12,929 25,025 14,310 2,815 481 Totals 55,560 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 34,331 13,067 671 6,527 424 540 o o Totals 55,560 SOURCE OF FUNDS 001 GENERAL FUND 55,560 55,560 Totals 9 Y-T-D Expended 85,571 171,710 85,958 18,902 4,178 366,319 243,146 84,427 1,420 30,231 2,161 4,725 209 o 366,319 366,319 366,319 2005 Budget 171,969 316,070 185,598 46,896 o 720,533 453,200 150,028 4,200 59,740 11,500 40,365 1,500 o 720,533 720,533 720,533 58.3% 41.6% Unexpended Balance 86,398 144,360 99,640 27,994 -4,178 354,214 210,054 65,601 2,780 29,509 9,339 35,640 1,291 o 354,214 354,214 354,214 Completed Remaining Unexpended Percent 50.2 45.7 53.7 59.7 49.2 46.3 43.7 66.2 49.4 81.2 88.3 86.1 49.2 49.2 49.2 OB/11/2005 09,32,02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 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 98,215 571,260 20,666 89,632 o 67,274 Totals 847,047 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 581,141 149,837 2,332 74,530 2,356 5,951 o o 30,900 Totals 847,047 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUl FINE FUND 818,562 o o 21,472 7,013 Totals 847,047 10 Y-T-D Expended 1,234,821 3,959,021 125,646 630,986 12,818 393,640 6,356,932 4,013,769 1,423,369 40,594 767,935 12,964 38,828 o 1,119 58,354 6,356,932 6,305,084 769 o 27,852 23,227 6,356,932 2005 Budget 2,529,382 6,993,502 234,701 1,219,752 27,575 659,571 11,664,483 7,573,190 2,593,654 90,500 1,242,191 46,400 86,148 o 1,150 31,250 11,664,483 11,655,483 o 7,000 1,000 1,000 11,664,483 58.3% 41.6% Unexpended Balance 1,294,561 3,034,481 109,055 588,766 14,757 265,931 5,307,551 3,559,421 1,170,285 49,906 474,256 33,436 47,320 o 31 -27,104 5,307,551 5,350,399 -769 7,000 -26,852 -22,227 5,307,551 Complet.ed Remaining Unexpended Percent 51.2 43.4 46.5 48.3 53.5 40.3 45.5 47.0 45.1 55.1 38.2 72 .1 54.9 2.7 -86.7 45.5 45.9 100.0 **** * **** * 45.5 08/11/2005 09,32,02 FRRDBROl SUM 031 7 Months 5 ["1onths VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 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 78,520 489,756 46 40,389 2,667 48,549 66 1,700 Totals 661,693 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 478,710 120,581 13,961 34,396 2,412 8,845 o o 2,788 Totals 661,693 SOURCE OF FUNDS 001 GENERAL FUND 661,693 Totals 661,693 Y-T-D Expended 1, 064 ,291 3,466,224 1,472 252,805 28,210 270,000 3,182 9,587 5,095,771 3,402,802 1,285,427 38,103 259,354 18,878 56,025 4,061 1,111 30,010 5,095,771 5,095,771 5,095,771 11 2005 Budget 2,107,956 6,223,820 13,131 495,231 62,100 443,968 10,180 31,680 9,388,066 6,284,864 2,380,065 102,865 417,872 42,500 91,050 4,000 4,000 60,850 9,388,066 9,388,066 9,388,066 58.3% 41. 6% Unexpended Balance 1,043,665 2,757,596 11,659 242,426 33,890 173,968 6,998 22,093 4,292.295 2,882,062 1,094,638 64,762 158,518 23,622 35,025 -61 2,889 30,840 4,292,295 4,292,295 4,292,295 Completed Remaining Unexpended Percent 49.5 44.3 88.8 49.0 54.6 39.2 68.7 69.7 45.7 45.9 46.0 63.0 37.9 55.6 38.5 -1. 5 72 .2 50.7 45.7 45.7 45.7 08/11/2005 7 Months 58.3% Completed 09,32,02 VILLAGE OF MOUNT PROSPECT 5 Months 41.6% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/05 - 07/31/05 Cur Mo Y-T-D 2005 Unexpended Unexpended PUBLIC WORKS - ADMINISTRATION Expended Expended Budget Balance Percent PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 99,282 640,195 1,104,481 464,286 42.0 Totals 99,282 640,195 1,1.04,481 464,286 42.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 17,273 129,652 230,282 100,630 43.7 51 EMPLOYEE BENEFITS 11,149 71,110 119,906 48,796 40.7 52 OTHER EMPLOYEE COSTS 1,143 13,172 29,545 16,373 55.4 54 CONTRACTUAL SERVICES 68,182 408,793 685,268 276,475 40.3 55 UTILITIES 1,041 6,800 18,490 11,690 63.2 57 COMMODITIES & SUPPLIES 494 10,543 13,915 3,372 24.2 65 OFFICE EQUIPMENT 0 0 6,500 6,500 100.0 67 OTHER EQUIPMENT 0 125 575 450 78.3 Totals 99,282 640,195 1,104,481 464,286 42.0 SOURCE OF FUNDS 001 GENERAL FUND 99,282 640,195 1,104,481 464,286 42.0 Totals 99,282 640,1.95 1.,104,481. 464,286 42.0 12 08/11/2005 09:32:02 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 PUBLIC WORKS - STREETS/BLDGS Cur Mo Expended PROGRAM TOTALS 01 STREET DIVISION ADMINISTRATION 02 MAINTENANCE - PUBLIC BUILDINGS 04 STREET f1AINTENANCE 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 8,779 58,567 49,176 9,361 637 16,308 2,639 6,236 12,469 9,752 o Totals 173,924 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 EQUI PMENT 69 INFRASTRUCTURE 80 INTERFUND TRANSFERS 74,674 26,545 27,991- 442 1,981 10,364 o o o 31,927 o Totals 173,924 SOURCE OF 001 050 620 630 FUNDS GENERAL FUND MOTOR FUEL TAX FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND 151,703 o 12,469 9,752 Totals 173,924 13 Y-T-D Expended 72,286 430,667 190,541 347,955 4,716 85,476 31,763 55,683 93,797 77,917 o 1,390,801 685,603 198,281 244,568 4,069 11,885 174,560 o 414 o 71,421 o 1,390,801 1,136,374 82,713 93,797 77,91-7 1,390,801 2005 Budget 158,323 782,108 445,142 398,744 o 168,614 66,161 111,105 262,485 136,614 o 2,529,296 1,050,768 319,648 588,478 19,205 19,808 263,171 o 6,000 10,100 252,118 o 2,529,296 1,919,827 210,370 262,485 136,614 2,529,296 58.3% 41.6% Unexpended Balance 86,037 351,441 254,601 50,789 -4,716 83,138 34,398 55,422 168,688 58,697 o 1,138,495 365,165 121,367 343,910 15,136 7,923 88,611 o 5,586 10,100 180,697 o 1,138,495 783,453 127,657 168,688 58,697 1,138,495 Completed Remaining Unexpended Percent 54.3 44.9 57.2 12.7 49.3 52.0 49.9 64.3 43.0 45.0 34.8 38.0 58.4 78.8 40.0 33.7 93.1 100.0 71.7 45.0 40.8 60.7 64.3 43.0 45.0 D8/11/2005 09:32:02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 07/31/05 PUBLIC WORKS - FORESTRY/GRNDS Cur Mo Expended PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 02 MAINTENANCE OF GROUND 03 FORESTRY PROGRAM 04 PUBLIC GROUNDS BEAUTIFICATION 17,196 62,072 61,641 8,655 Totals 149,564 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 76,347 21,645 o 44,938 6,634 o Totals 149,564 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 149,564 o Totals 149,564 14 Y-T-D Expended 10B,132 253,261 318,733 26,638 706,764 372,685 118,953 943 189,817 16,415 7,951 706,764 706,764 o 706,764 2005 Budget 202,791 430,352 770,401 44,449 1,447,993 659,194 205,772 3,350 546,437 24,440 B,800 1,447,993 1,433,793 14,200 1,447,993 58.3%- 41.6% Unexpended Balance 94,659 177,091 451,668 17,811 741,229 286,509 86,819 2,407 356,620 8,025 849 741,229 727,029 14,200 741,229 Completed Remaining Unexpended Percent 46.7 41. 2 58.6 40.1 51.2 43.5 42.2 71. 9 65.3 32.8 9.6 51. 2 50.7 100.0 51.2 08/11/2005 09,32,02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 56,692 29,110 Totals 85,802 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 42,715 15,267 o 9,736 17,045 544 o 495 o Totals 85,802 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 64,875 20,927 Totals 85,802 15 Y-T-D Expended 370,097 148,498 518,595 297,281 98,949 405 46,004 64,851 10,610 o 495 o 518,595 444,703 73,892 518,595 2005 Budget 702,066 600,001 1,302,067 560,670 175,489 5,100 175,548 196,380 17,270 500 1,500 169,610 1,302,067 916,577 385,490 1,302,067 58.3% 41.6% Completed Remaining Unexpended Unexpended Balance Percent 331,969 451,503 783,472 263,389 76,540 4,695 129,544 131,529 6,660 500 1,005 169,610 783,472 471,874 311,598 783,472 47.3 75.3 60.2 47.0 43.6 92 .1 73 .8 67.0 38.6 100.0 67.0 100.0 60.2 51. 5 80.8 60.2 08/11/2005 09,32,02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 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 118,392 23,074 12,527 32,539 43,226 21,420 27,680 61,159 46,994 15,056 359,075 Totals 761,142 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 128,945 50,678 1,104 527,803 2,903 27,681 7,080 o o 4,328 10,620 o Totals 761,142 SOURCE OF FUNDS 610 WATER AND SEWER FUND 761,142 Totals 761,142 16 Y-T-D Expended 819,287 92,233 42,406 248,514 285,077 168,712 171,961 366,953 191,075 557,392 1,675,956 4,619,566 864,090 320,204 16,696 2,543,314 51,071 166,085 71,754 1,194 4,163 65,565 515,430 o 4,619,566 4,619,566 4,619,566 2005 Budget 1,663,809 168,464 84,534 522,659 737,969 302,796 313,319 611,589 496,389 1,303,000 3,075,000 9,279,528 1,686,400 574,345 32,370 4,809,354 159,775 276,808 168,186 13,500 13,335 266,425 1,175,000 104,030 9,279,528 9,279,528 9,279,528 58.3% 41.6% Unexpended Balance 844,522 76,231 42,128 274,145 452,892 134,084 141,358 244,636 305,314 745,608 1,399,044 4,659,962 822,310 254,141 15,674 2,266,040 108,704 110,723 96,432 12,306 9,172 200,860 659,570 104,030 4,659,962 4,659,962 4,659,962 Completed Remaining Unexpended Pe!:cent 50.8 45.3 49.8 52.5 61. 4 44.3 45.1 40.0 61. 5 57.2 45.5 50.2 48.8 44.2 48.4 47.l 68.0 40.0 57.3 91. 2 68.8 75.4 56.1 100.0 50.2 50.2 50.2 08/11/2005 09,32,02 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 07/31/05 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 419,327 8,709 Totals 428,036 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 9,565 4,629 o 412,957 20 765 100 Totals 428,036 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 428,036 Totals 428,036 17 Y-T-D Expended 1,922,984 60,577 1,983,561 83,993 31,869 o 1,855,329 165 4,591 7,614 1.,983,561 1,983,561 1.,983,561 2005 Budget 3,446,873 187,854 3,634.727 216,953 66,276 1,685 3,320,897 560 7,651 20,705 3,634,727 3,634,727 3,634,727 58.3% 41.6% Unexpended Balance 1,523,889 127,277 1,651,166 132,960 34,407 1,685 1,465,568 395 3,060 13,091 1,651,166 1,651,166 1,651.,1.66 Completed Remaining Unexpended Percent 44.2 67.8 45.4 61.3 51. 9 100.0 44.1 70.5 40.0 63.2 45.4 45.4 45.4 cJ8/11/2005 7 Months 58.3% Completed 09,32,02 VILLAGE OF MOUNT PROSPECT 5 Months 41.6% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/05 - 07/31/05 Cur Mo Y-T-D 2005 Unexpended Unexpended PUBLIC WORKS - VEHICLE MAl NT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 11,678 105,367 184,150 78,783 42.8 02 VEHICLE MAINTENANCE PROGRAM 90,718 595,363 1,091,733 496,370 45.5 Totals 102,396 700,730 1,275,883 575,153 45.1 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 42,588 342,122 658,948 316,826 48.1 51 EMPLOYEE BENEFITS 17,192 115,154 212,513 97,359 45.8 52 OTHER EMPLOYEE COSTS 0 75 3,300 3,225 97.7 54 CONTRACTUAL SERVICES 5,463 42,309 72,502 30,193 41.6 55 UTILITIES 51 441 1,000 559 55.9 57 COMMODITIES & SUPPLIES 37,102 198,255 323,870 125,615 38.8 59 OTHER EXPENDITURES 0 0 0 0 65 OFFICE EQUIPMENT 0 0 500 500 100.0 67 OTHER EQUIPMENT 0 2,374 3,250 876 27.0 Totals 102,396 700,730 1,275,883 575,153 45.1 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 102,396 700,730 1,275,883 575,153 45.1 Totals 102,396 700,730 1,275,883 575,153 45.1 18 '08/11/2005 09:32:02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 07/31/05 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 7,463 60,007 112 260 Totals 67,842 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 52,342 4,276 9,961 o 1,263 o Totals 67,842 SOURCE OF FUNDS 001 GENERAL FUND 67,842 Totals 67,842 19 Y-T-D Expended 64,948 79,156 7,516 1,536 153,156 55,761 5,308 83,340 o 8,747 o 153,156 153,156 153,156 2005 Budget 91,400 103,431 78,825 2,792 276,448 63,220 11,223 168,770 400 25,335 7,500 276,448 276,448 276,448 58.3% 41.6% Unexpended Balance 26,452 24,275 71,309 1,256 123,292 7,459 5,915 85,430 400 16,588 7,500 123,292 123,292 123,292 Completed Rpmaining Unexpended Percent 28.9 23.5 90.5 45.0 44.6 11.8 52.7 50.6 100.0 65.5 100.0 44.6 44.6 44.6 0"8/11/2005 09:32:02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 07/31/05 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 2,760 7,296 16,582 19,877 159,994 80,659 2,549 Totals 289,717 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 55 UTILITIES 59 OTHER EXPENDITURES 62 LAND IMPROVEMENTS 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 66 MOBILE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 72 INTEREST EXPENSE 80 INTERFUND TRANSFERS SOURCE OF 050 060 510 525 526 550 560 590 630 670 680 690 22,477 o o 1,616 2,760 2,549 80,659 o 179,656 o o Totals 289,717 FUNDS MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT CAPITAL IMPROVEMENT FUND SERIES 2001 PROJECT FUND SERIES 2003 PROJECT FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND PARKING SYSTEM REVENUE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND o o 7,296 o 2,760 16,582 159,994 19,877 o 80,659 2,549 o Totals 289,717 20 Y-T-D Expended 96,673 15,728 247,124 144,255 2,011,358 812,098 107,440 3.434,676 118,530 o 151,794 7,971 39,694 156,936 812,098 7.483 2,130.190 9.980 o 3,434.676 1,243,788 o 56,130 o 56,271 247,124 767,570 144,255 o 812,098 107,440 o 3,434.676 2005 Budget 662,455 100,914 290,566 583,413 2,785,521 1,339,635 199,700 5.962,204 200,500 o 164,577 21,030 439,455 296,700 1,339,635 126,000 3,352,663 21,644 o 5,962,204 1,565,812 o 665,914 o 22,000 290,566 1,165,709 583,413 129,455 1,339,635 199,700 o 5.962.204 58.3% 41. 6% CompletE:d Remaining Unexpended Unexpended Balance Percent 565,782 85,186 43,442 439,158 774,163 527,537 92,260 2,527.528 81,970 o 12,783 13,059 399,761 139,764 527,537 118,517 1,222,473 11,664 o 2,527,528 322,024 o 609,784 o -34,271 43,442 398,139 439,158 129,455 527,537 92,260 o 2,527,528 85.4 84.4 15.0 75.3 27.8 39.4 46.2 42.4 40.9 7.8 62.1 91. 0 47.1 39.4 94.1 36.5 53.9 42.4 20.6 91.6 -155.8 15.0 34.2 75.3 100.0 39.4 46.2 42.4 08/11/2005 09,32,02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 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 793,100 20,394 o o Totals 813,494 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS o 694,799 117,645 1,050 o Totals 813,494 SOURCE OF FUNDS 140 180 190 200 230 270 280 290 340 350 360 380 390 400 430 440 830 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 1996B B&I, TIF SERIES 1998B 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 o o 792,800 450 300 300 19,644 o o o o o Totals 813,494 21 Y-T-D Expended o 340,206 918,373 399,142 o 1,400 1,659,121 o 913,628 742,643 2,850 o 1,659,121 o 100,064 230,966 9,176 825 o o 905,900 9,050 4,141 11,648 326,321 56,049 3,581 o o 1,400 1,659,121 2005 Budget 1,979,111 1,096,145 1,427,997 o 37,800 4,541,053 o 3,240,837 1,294,216 6,000 o 4,541,053 67,000 390,128 911,932 610,051 36,650 o o 906,200 213,100 62,983 153,295 613,355 292,098 246,461 o o 37,800 4,541,053 58.3% 41. 6% Unexpended Balance 1,638,905 177,772 1,028,855 o 36,400 2,881,932 o 2,327,209 551,573 3,150 o 2,881,932 67,000 290,064 680,966 600,875 35,825 o o 300 204,050 58,842 141,647 287,034 236,049 242,880 o o 36,400 2,881,932 Completed Remaining Unexpended Percent 82.8 16.2 72.0 96.3 63.5 71.8 42.6 52.5 63.5 100.0 74.4 74.7 98.5 97.7 95.8 93.4 92.4 46.8 80.8 98.5 96.3 63.5 08/11/2005 7 Months 58.3% Completed 09:32:02 VILLAGE OF MOUNT PROSPECT 5 Months 41.6% Remaining FRRDBROl SUM031 Department Budget Expenditure Swnmary 01/01/05 - 07/31/05 Cur Mo Y-T-D 2005 Unexpended Unexpended RETIREE PENSIONS Expended Expended Budget Balance Percent PROGRAM TOTALS 01 MISCELLANEOUS PENSIONS 4,557 31,902 54,630 22,728 41.6 02 POLICE PENSIONS 185,182 1,330,694 2,366,440 1,035,746 43.8 03 FIRE PENSIONS 195,856 1,342,365 2,328,948 986,583 42.4 Totals 385,595 2,704,961 4,750.018 2,045,057 43.1 EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 385,566 2,703,128 4,746,868 2,043,740 43.1 54 CONTRACTUAL SERVICES 0 1,092 2,950 1,858 63.0 57 COMMODITIES & SUPPLIES 29 741 200 -541 -270.5 65 OFFICE EQUIPMENT 0 0 0 0 Totals 385,595 2,704,961 4,750,018 2,045,057 43.1 SOURCE OF FUNDS 001 GENERAL FUND 4,557 31,902 54,630 22,728 41.6 710 POLICE PENSION FUND 185,182 1,330,694 2,366,440 1,035,746 43.8 720 FIRE PENSION FUND 195,856 1,342,365 2,328,948 986,583 42.4 730 BENEFIT TRUST #2 FUND 0 0 0 0 Totals 385,595 2,704,961 4,750,018 2,045,057 43.1 22 08/11/2005 09,32,02 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 07/31/05 7 Months 5 Months 58.3% 41.6% Completed Remaining Totals Cur Mo Y-T-D 2005 Unexpended Unexpended Expended Expended Budget Balance Percent 63,226 699,634 1,260,047 560,413 44.5 377,762 2,403,041 4,409,303 2,006,262 45.5 440,988 3,102,675 5,669,350 2,566,675 45.3 RISK MANAGEMENT PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE o 440,988 603 3,102,072 39,000 5,630,350 38,397 2,528,278 98.5 44.9 Totals 440,988 3,102,675 5,669,350 2,566,675 45.3 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 440,988 3,102,675 5,669,350 2,566,675 45.3 Totals 440,988 3,102,675 5,669,350 2,566,675 45.3 23 08/11/2005 09:32:02 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 07/31/05 7 Months 5 Months 58.3% 41.6% Completed Remaining Cur Mo Y-T-D 2005 Unexpended Unexpended NON-DEPARTMENTAL Expended Expended Budget Balance Percent PROGRAM TOTALS 01 CONTINGENCIES 0 437,083 805,000 367,917 45.7 Totals 0 437,083 805.000 367.917 45.7 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 0 0 0 0 53 PENSION BENEFITS 0 0 0 0 54 CONTRACTUAL SERVICES 0 0 0 0 59 OTHER EXPENDITURES 0 0 0 0 80 INTERFUND TRANSFERS 0 437,083 805,000 367,917 45.7 Totals 0 437.083 805.000 367.917 45.7 SOURCE OF FUNDS 001 GENERAL FUND 0 437,083 805,000 367,917 45.7 560 STREET IMPROVEMENT CONST FUND 0 0 0 0 670 VEHICLE REPLACEMENT FUND 0 0 0 0 Totals 0 437.083 805,000 367.917 45.7 24 08/11/2005 09,32,02 FRRDBROl SUM031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 CAPITAL FIXED ASSETS Cur Mo Expended Y-T-D Expended 2005 Budget 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 25 58.3% 41.6% Completed Remaining Unexpended Balance Unexpended Percent o o o o o o o o o o o o 0'8/11/2005 09032,02 FRRDBROl SUM 031 7 Months 5 Months VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 07/31/05 MOUNT PROSPECT LIBRARY Cur Mo Expended Y-T-D Expended Unexpended Percent PROGRAM TOTALS 02 LIBRARY SERVICES o Totals o EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES o Totals o SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND o Totals o 26 2005 Budget o 8,536,993 o 8,536,993 o 8,536,993 o 8,536,993 o 8,536,993 o 8,536,993 58.3% 41.6% Unexpended Balance Completed Remaining 8,536,993 100.0 8,536,993 100.0 8,536,993 100.0 8,536,993 100.0 8,536,993 100.0 8,536,993 100.0