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 12/18/07
VILLAGE OF MOUNT PROSPECT CASH POSITION Oecemberr 01 - 12, 2007 Cash & Invstmt Receipts Disbursements Disbursements Cash & Invstmt Balance 12/01/07 Per Attached Per Attached Balance 12/01/07 12/12/07 List of Bills List of Bills 12/12/07 General Fund 5,526,122 1,729,213 760,005 6,495,330 Special Revenue Funds Refuse Disposal Fund 1,544,607 203,193 182,444 1,565,356 Motor Fuel Tax Fund 1,066,637 122,866 1,189,503 Community Development Blk Grant Fund 13,590 111 13,479 Asset Seizure Fund 79,779 7,550 72,229 DEA Shared Funds 43,133 43,133 DUI Fine Fund 33,127 2,265 765 34,627 Foreign Fire Tax Board Fund 87,459 87,459 Debt Service Funds (23,638) 216,153 118,404 74,111 Capital Proiects Funds Capital Improvement Fund 544,498 4,183 540,315 Downtown Redevelopment Const Fund 1,833,125 85,702 11,531 1,907,296 Street Improvement Construction Fund 1,345,481 106,974 1,452,455 Flood Control Construction Fund 644,125 644,125 Enterprise Funds Water & Sewer Fund 4,393,535 528,650 117,654 4,804,531 Village Parking System Fund 94,745 3,431 98,176 Parking System Revenue Fund (54,200) 2,050 22 (52,172) Internal Service Funds Vehicle Maintenance Fund 714,729 54,332 660,397 Vehicle Replacement Fund 6,629,454 3,113 6,626,341 Computer Replacement Fund 723,238 723,238 Risk Management Fund 3,325,784 74,401 8,698 3,391,487 Trust & A~ency Funds Police Pension Fund 43,026,441 181,411 837 43,207,015 Fire Pension Fund 43,265,294 140,452 35,960 43,369,786 Flexcomp Trust Fund 77,941 10,698 88,639 Escrow Deposit Fund 1,813,044 23,166 15,329 21,270 1,799,611 116,748,050 3,430,625 1,320,938 21,270 118,836,467 TOTAL DISBURSEMENTS PER ATTACHED LISTS OF BILLS 1,342,208 ~PORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 RUN: TUESDAY DECll2007 16:38 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 29 2007 TO DECEMBER 12 2007 . - - ~ - - - -.... -- - -.... -.. - - - --...... -............ --.................................... --.............. --.................................................................................................................................... )EPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ................... --............................................................................................................................................................................................................................................ II 01419 A.R.D.C. ARDC REGISTRATION-JANONIS 105.00 05452 AM EMPLOYMENT TEMPORARY EMPLOYEE 708.75 TEMPORARY EMPLOYEE 425.25 ------------- 1134.00 08366 ABT ELECTRONI CS S-620 Appliance Station #l3 1286.00 10447 ACE CERTIFICATION RENEWAL CERTIFICATION RENEWAL FEE 276.00 01227 AIR ONE EQUIPMENT, INC. Bunker Coat Name Tags 160.00 10 HYDRO/CASCADE 820.00 -----..------- 980.00 01246 AIRGAS NORTH CENTRAL OXYGEN SUPPLIES 229.94 01335 ALEXIAN BROTHERS MEDI CAL CENTR AHA CPR CARDS 144.00 01409 ALLIANCE FOR COMMUNITY MEDIA ALLIANCE MEMBERSHIP 100.00 01561 AMERICAN CHARGE SERVICE SENIOR TAXI DISCOUNT PROGRAM 17.50 10428 AMERICAN INSTITUTE OF ARCHTECTS 2008 MEMBERSHIP-JANET SAEWERT 617.00 09676 AMERI CAN MESSAGING QUARTERLY PAYMENTS 1314.99 09544 ANDRES MEDICAL BILLING,LTD AMBULANCE COLLECT I ON FEES 4575.80 02001 ARAMARK UNI FORM SERVI CES, INC. OPEN PURCHASE ORDER/ Uniform 52.96 07785 ARNDT, JOHN REIMBURSE EXPENSES 356.19 02270 AT&T ACCT#8472 53 -113 7 20.56 ACCT#847253-1137 68.52 ACCT#847253-1137 13.70 ACCT#847253-1137 20.56 ACCT#847253-1137 137 . 04 ACCT#847253-1137 68.52 ACCT#84 7253 -113 7 260.38 ACCT#847253-1137 68.52 ACCT#8472 53 -113 7 102.78 ACCT#847253-1137 178.16 ACCT#84 7253 -113 7 54.82 ACCT#847253 -1137 54.82 ACCT#847253-1137 246.68 ACCT#847253-1137 1391. 00 ACCT#8472 53 -113 7 1363.59 ACCT#847253-1137 877.09 -----.------- 4926.74 02405 B & H PHOTO/VIDEO CANON ZR- 830 MINI DV CAMCORDER 349.95 MACKIE 1402-VLZ3 14 CHANNEL MI 399.99 REPORT: APBOARDRPT GENERATED: 09 FEB 07 18: 58 RUN: TUESDAY DECll2007 16:38 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 29 2007 TO DECEMBER 12 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 01200 CRAINS CHICAGO BUSINESS 2008 SUBSCRIPTION 94.95 08065 CVS - PHARMACY I I NC . PRISONER MEDICATION 07-21888 36.79 09115 D. J . I S SCUBA LOCKER DRYSUIT PLUG 48.00 2 - Water Recovery Equi prnent- 1794.15 .-------.---- 1842.15 06411 DACRA COMPUTER SERVI CE ACCESS DATABASE PROGRAMMING 125.00 01218 DAHLBERG, JOHN HOLIDAY 8REAKFAST ROTARY 100.00 05153 DIALOGIC COMMUNICATIONS CORP. EMERGENCY CALL OUT AUG 2007 6572.40 01333 ELGIN REGIONAL FIRE ACADEMY Registration/New Hire FFII Aca 2000.00 01356 ENVIRONMENTAL SAFETY GROUP, INC OVERAGE 5 BASOFIL ENSEMBLES 100.55 STRUCTURAL FF COAT & PANT 1460.11 - - - - - - - ~ - - - - - 1560.66 01360 ERSKINE, CON REIMBURSEMENT 125.00 08374 ESG 7 Protective Outer Wear 8760.66 09653 ETERNO, DAVID G. NOVEMBER 07 ADMIN ADJUDICATION 400.50 10346 EVANSTON FIRE & LIFE SAFETY SERVICES Registration/Nov 30,2007 Schwe 95.00 10393 EXPERTPAY PAYROLL FOR - 120607 2956.8 5 04501 FAVIA, CORRINE M. TAX RELIEF GRANT 2007 100.00 01377 FEDERAL EXPRESS CORP FED EX SHIPPING 26.14 FEDEX SERVICE FOR 8601 2006 38 19.26 PASSPORT DELIVERY 20.50 -------- - .--- 65.90 08242 FERRARO, MARY S. TAX TRLIEF GRANT 2007 86.68 05563 FERSTAND, BARBARA TAX RELIEF GRANT 2007 100.00 00331 FIGOLAH, MICHAEL LUNCH MEETING 50.25 00102 FIRE PENSION FUND PAYROLL FOR - 120607 20043.23 00334 FLOYD, BRIAN COURSE REIMBURSEMENT 40.00 09363 GARCIA, RAFAELA LODING 12/3/07 - 12/04/07 262.00 10451 GIL HERBARD GUNS, INC. MISC AMMUNITION 4258.30 06530 GOLATZ, JESSIE A. TAX RELIEF GRANT 2007 100.00 REPORT: APBOARDRPT GENERATED: 09 FEB 07 18: 58 RUN: TUESDAY DEC1l2oo7 16:38 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 29 2007 TO DECEMBER 12 2007 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - __ - ___ - __. _... ___._ - - __ __ ___ - _.. _____ ____e. a__._.. _ ._. ___ _ _ ___ __ _ _____ _ ____ _________ __._._ _ __ _ ____ _ _ _ _ _ _ __ __ _ _ _ _ _ -__ ______ -- ------ 1O#9013375982B 356.00 MONTHLY LEASE PAYMENT FOR TOSH 236.00 ID #90133643910 220.35 10 #90133643910 100.00 OPEN PURCHASE ORDER/ Copier Le 320.35 COPIER LEASE PAYMENT FOR FEB. D 586.13 INVESTIGATIONS COPIER LEASE 169.00 ------------- 2927.83 09562 IMRF PAYROLL FOR - 120607 427.31 PAYROLL FOR - 120607 42470.63 PAYROLL FOR. 120607 20224.09 PAYROLL FOR - 120707 1190.98 PAYROLL FOR - 120707 567 .13 ___________w_ 64880.14 07694 INTERNATIONAL CODE COUNCIL 2007 ICC CERTIFICATION 50.00 09832 INTERNATIONAL UNION OF OPERATING ENGINEERS PAYROLL FOR - 120607 841.86 PAYROLL FOR - 120607 263.34 ------------- 1105.20 09563 IRS PAYROLL FOR - 120607 193658.63 PAYROLL FOR. 120707 2908.71 ----- -- -- ---- 196567.34 06691 JUST TIRES REPAIR AUTO TIRE FLAT 25.00 01794 KALE UNIFORMS I mc. ACADEMY UNIFORM SUPPLIES 139.85 ACADEMY UNI FORM - WOOD 41. 90 - --- ---. - .--- 181.75 09788 KARLSTEDT LANDSCAPE I INC. PLANTING OF BULBS AT VARIOUS B 1980.00 PLANTING OF BULBS AT VARIOUS B 2620.00 -----.- ------ 4600.00 08458 K10D I DANI EL COURSE REIMBURSEMENT 40.00 01838 KRAMER TREE SPECIALISTS TRIMMING AND WOUND REPAIR OF 25984.80 09508 L- 3 COMMUNICATIONS USB 128MB KEYS 1705.00 01851 LAB SAFETY SUPPLY GAS ALERT MICRO CLIP CONFINED 1116.2 5 MOTORIZED SAMPLING PUMP 280.25 25' TUBE 107.50 2sl" TUBE 107.50- - - - - - - - ------ 1396 . 50 10454 LAWRENCE MANAGEMENT OVERPMT ALARM LICENSE 10.00 :EPORT: APBOARDRPT GENERATED: 09 FEB 07 18 :58 RUN: TUESDAY DEC112007 16:38 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 29 2007 TO DECEMBER 12 2007 - - -- - -.... - - - -.. - - - - - - -.... - - -.. - - -.. - - - - - - -.. - - - - - - -.... - - - -.. - - -.. - - - -.. - - - - - - - - - - - - - - - - - - - - - - - - - -.. - - - - -.. - - - - - - -.. - -.. -- - - - - - - -.. - - - - - - - - - - - -.. -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - - - - - - - --.. - - -- - - - --- -- --- -- ---.- - -.. _.---- - ---.... - -- - - --- -- ------ -- - ---- --. - -- ----- -- -- -- - - - - - - -- .-- - ------- - ----- - --- --- --- - - - -- 9471.50 02046 MOBILE PRINT INC. MEMO PADS 18.43 MEMO PADS 36.86 BUS lNESS CARDS 49.25 BUS INESS CARDS 157.14 NOTE SHEETS 67.89 MPDMA NEWSLETTER 348.23 PRINTING PARADE POSTERS 63.70 CHIEF I S LETTERHEAD/LYONS CARDS 202.73 SURVEY CARDS 285.18 ----------_.- 1229.41 09374 MORNER, PATRI CK TAX RELIEF GRANT 2007 100.00 02066 MOUNT PROSPECT CHAMBER OF COMMERCE 2008 MEMBERSHI P 320.00 02067 MOUNT PROSPECT HISTORI CAL SOC. 2007 DECEMBER PMT 3333.33 02072 MOUNT PROSPECT PUBLIC LIBRARY OTHER SERVI CES 2.00 09088 MT . PROSPECT DOWNTOWN MERCHANTS ASSOC. 2008 MPDMA MEMBERSHIP 1000.00 10429 MUSHFIELD, CORINNE REBATE FOR 5 SQ OF PUBLI C WALK 382.00 07406 MYRON CORPORATION POCKET CALENDARS 2008 484.50 00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 120607 17201.81 02148 NEOPOST INC. POSTAGE MACHINE 3000.00 04368 NESTERUK, JOAN TAX RELIEF GRANT 2007 100.00 02155 NEXTEL COMMUNICATIONS ACCT#157600518 1l18.41 ACCT#l57600518 137 .28 ACCT#157600518 677.36 ACCT#157600518 34.35 ACCT#l57600518 143.06 ACCT#157600518 1325.52 ACCT#157600518 120.00 ACCT#157600518 22.94 ACCT#157600518 180.18 ACCT#157600518 37.42 ACCT#157600518 70.67 EQUIPMENT CHARGES FOR OCTOBEOR 207.96 -- ----------- 4075.15 02170 NORTH EAST MULTI REGIONAL TRNG JANOWI CK PPCT CLASS 125.00 02189 NORTHWEST CENTRAL DISPATCH SYS DECEMBER 2007 39390.57 DECEMBER 2007 2 9847.60 ------ -- --.. -- 49238.17 02190 NORTHWEST COMMUNITY EMS DEPT 3 Paramedi c Text Books and 3 615.00 EPORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 RUN: TUESDAY DEC1l2007 16: 38 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 29 2007 TO DECEMBER 12 2007 -. -. -.. - ~...... -.... --.......... -- --.................................................. -- --.... --.................................................................. --.. ---.................................................................. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .................... ___.. ____ _______ ______ ___...... __.. ____ ____ __ ______ ____ __ ___ __ __.. __............ ___.. __.. ___.. __ ________ ____ ____.... ___...... ___.... __ a___........ 08566 PREDICK, PAUL R. DUPLICATE VEH.LICENSE 18.00 02344 PREISER ANIMAL HOSPITAL STRAYS OCT. NOV. 2007 666.00 04954 PRO MIX AUDIO AND LIGHTING Microphone Stands 65.00 1 Elite Screen 60 x 80 399.95 ------------- 464.95 04359 PUBLIC AGENCY TRAINING COUNCIL Registration/ Valentine 250 .00 04417 QUALITY BLACKTOP INC. BUILDING REFUND 25.00 02393 RAY 0 I HERRON CO. MISC. AMMUNITION 1392.00 07964 RMS BUSINESS SYSTEMS, INC. CONFIGURE NEW SWITCH 231.2 5 00418 ROSCOP, WILLIAM REIMBURSEMENT EXPENSE 238.46 REPLACES PAYROLL CHECK 85727 579.42 ------------- 817.88 07529 SCHAMBACH SOFTWARE SOLUTIONS / INC. CONSULTING SERVICES NOV 2007 2998.75 10445 SCHERBAUM / CHERYL LODGING 12/3/07 - 12/04/07 262.00 09058 SELEEN / WENDY EXPENSES 764.16 10215 SEMINARS INC HOMEBUYER COUNSELING 99.00 00429 SEMKIU / MI CHAEL J. REIMBURSEMENT EXPENSE 21.49 08950 SETANTA PUBLISHING,LLC SUBSCRIPTION RENEWAL-B.ROELS 164.00 02542 SHEPP PEST CONTROL MONTHLY PEST CONTROL SERVICES 425.00 08181 SOBOTKA, EDWARD TAX RELIEF GRANT 2007 100.00 09620 SPRINT WIRELESS SERVICE 898.80 04139 STANARD & ASSOCIATES PRE EMP. MCCULLOUCH BARNETT 750.00 09165 STAPLES BUSINESS ADVANTAGE SUPPLIES 12.78 10356 STAY FIT PHYSICAL THERAPY/INC. 9 - Physical Fitness Lectures 1200.00 10283 STEVE PIPER & SONS / INC. PARKWAY TREE STUMP REMOVALS FR 43552.20 STUMP REMOVAL CONTRACT PER BID 8041. 40 __ a__ ..____...... 51593.60 04951 SUBURBAN ACCENTS INC. KEYSTONE LOGOS ON REFLECTIVE 33.00 TOY DRIVE BANNER 150 . 00 ---.....-..----- 183.00 :EPORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 RUN: TUESDAY DEC112007 16: 38 RELEASE JD : PAGE 11 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 29 2007 TO DECEMBER 12 2007 ~ ~ - - - - - - - - - - - - - - - - -. - ~ - - - -.. - - - -. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - -- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT - - - - --. - - ---- - - - - - - - - - - - - - -- - -- - -- - - --- ---- -- -. -- ------ - - - - - - -- -- --- - - - -- -- - - -- ------ --- -- -- -- - -- - - -- -- - - - - - - - - --- - -- ----- - - - ----- 02876 WILKS, IRVANA US CONFERENCE OF MAYORS REGIST 942.00 02878 WILLIAM RAINEY HARPER COLLEGE Regi st ration/ Fall Oet, Nov, Dee 4110.00 05746 WI SCTF PAYROLL FOR - 120607 542.48 10456 WOODBUR Y, CL I FFORD REPLACES P /R CHECKS 88090,8823 55.64 TOTAL 760004.98 30 02016 ARC DISPOSAL COMPANY NOVEMBER COLLECTIONS 90983.18 NOVEMBER COLLECTI ONS 46164.54 NOVEMBER COLLECTIONS 32592.73 NOVEMBER COLLECTIONS 4157.64 NOVEMBER COLLECT IONS 6828.77 - - - - - --- -.--- 180726.86 02270 AT&T ACCT#847253-1137 27.41 02756 UNITED STATES POSTAL SERVICE POSTAGE 10/27/07 - 12/05/07 1595.74 02769 UPTOWN AUTO SUPPLY BATTERY REPLACEMENT 94.18 TOTAL 182444.19 70 01377 FEDERAL EXPRESS CORP FED EX SHIPPING 19.16 09448 HUTH, JESSICA SUPPLIES FOR PROGRAM 15.56 09277 ROSEN, JUDY SUPPLIES FOR PROGRAM 75.93 TOTAL 11 D.6 5 80 02323 POLICE EXECUTIVE RESEARCH FORUM SMIP COURSE REGISTER-M.SEMKIU 7550.00 TOTAL 7550.00 86 01739 INTOXIMETERS, INC. PRINTER 220-P FOR BREATH MACHI 765.00 TOTAL 765.00 80 06752 ILLINOIS EPA LOAN L17-1087 P LOAN L17 -1087 I LOAN#1 L170857 P LOAN#1 L170857 I 42599.45 15653.34 46849.81 13300.92 118403.52 TOTAL 118403.52 10 lEPORT: APBOARDRPT GENERATED: 09 FEB 07 18: 58 RUN: TUESDAY DEcm007 16: 38 PAGE 13 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 29 2007 TO DECEMBER 12 2007 - - - - - - ~ -, - - - - - -. - - - - - - - - - - -........................ - - - - -... - - - - - -......... - - - --... - - - -...... - - - -......... -- -.................................... -........................ -...... -...... - -................................................ -......... - -..................... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -......... ---............ - - -... -... -- - ---- - -- -- --...... ----... ---- -- ---... -... -- - - -... - - -... - ------ ------ ----- ---... --- - --...... ---......... --- -- -...... --- -...... --- - -- -- -- - -- --- -......... 917.00 10453 HP MT. PROSPECT I LLC REIMBURSEMENT FOR REPL/RELOCAT 33477.60 07433 lMAGETEC LP MONTHLY LEASE PAYMENT FOR TOSH 236.00 06874 JOHN DEERE LANDSCAPES SPRINKLER SYSTEM REPAIR PARTS 286.71 08567 JURCZAK, HENRY REFUND FINAL BILL 45.44 09788 KARLSTEDT LANDSCAPE, INC. PLANTING OF BULBS AT VARIOUS B 3195.00 08631 LECHNER AND SONS 2007 UNIFORM RENTAL AND CLEANI 380.44 01918 LUNDSTROM I S NURSERY, INC. TURF MOWING AT VARIOUS LOCATIO 330.53 01265 LYNWooD SIGN CO. REPAINT AND INSTALLATION OF 990.00 05021 MENARDS HARDWARE & BUILDING SUPPLIES 415.80 HARDWARE & BUILDING SUPPLIES 34.97 HARDWARE & BUILDING SUPPLIES 21.58 ---...... - - -----... 472.35 10155 MIDAMERICAN TECHNOLOGY, INC. HCTX DIRECT CONNECT LEADS 57.75 02155 NEXTEL COMMUNICATIONS ACCTfi157600518 1045.72 ACcrfi157600518 440.68 ---- - - - -- -- -... 1486.40 04417 QUALITY BLACKTOP INC. 2007 ASPHALT RESTORATION CONTR 2893.87 2007 ASPHALT RESTORATION CONTR 2324.15 ------------- 5218.02 02962 REDWOOD APT. PARTNERS REFUND FINAL BILL 11.36 08567 SLOTA, ZYGMUNT REFUND FINAL BILL 10.00 02655 SUBURBAN LABORATORIES, INC. 2007 ANNUAL CONTRACT FOR LAB 757.50 04838 THIRD MILLENNIUM ASSOC. INC. UTILITY BILLING 1443.44 02756 UNITED STATES POSTAL SERVI CE POSTAGE 10/27/07 - 12/05/07 2915.47 POSTAGE 10/27/07 - 12/05/07 1595.74 ---- ---- ----- 4511.21 08567 WERDERITCH, RONALD E. REFUND FINSL BILL 4.30 TOTAL 117653.98 02806 VILLAGE OF MOUNT PROSPECT METER NUMBER:00185455 22.04 TOTAL 22.04 RUN: TUESDAY DEC112007 16:38 RELEASE ID : mORT: APSOARDRPT GENERATED: 09 FES 07 18:58 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 29 2007 TO DECEMBER 12 2007 PAGE 15 DEPT VENDOR NBR -. - - -. - - - -... - - - - - - - -- - -. - -. - - - - - - - - - - - - - - - - - - - -. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- AMOUNT VENDOR NAME INVOICE DESCRIPTION TOTAL: 3112.80 . - - - - -- - - - - -- - ________________. - --- - -- -- - ---- - - - - - - -- - ---- ----_.- - ----- - - - - - - - - -- - -- - - - - - --- - - - -- -- -- -- -.--- __A - - - ___ - __ - - __ __ - - ___ 590 08161 10258 710 09635 720 00128 04314 09635 790 02072 01719 08579 02689 ARLINGTON RIDGE PATHOLOGY, S. C. M.HAYES DOA 10/7/07 POWELL TREE CARE, INC. REMOVAL OF HAZARDOUS TREES TOTAL 8698.00 8583.00 WELLS FARGO BANK, N.A. POLICE PENSION BANK CHANGES TOTAL 837.39 837.39 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 120807 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES PAYROLL FOR - 120807 WELLS FARGO BANK, N .A. FIRE PENSION BANK CHANGES TOTAL 35960.33 946.93 MOUNT PROSPECT PUBLIC LIBRARY PPRT 8TH ALLOCATION NCPERS GROUP LI FE PREMIUM FOR DEC 2007 RUGEL I ALFREDO OVERPMT TICKET P3870694 THIRD DISTRICT CIRCUIT COURT BOND MONEY BOND MONEY BOND MONEY BOND MONEY TOTAL GRAND TOTAL 115.00 14060.99 20952.41 3784.23 540.00 5.00 1075.00 5545.00 1575.00 2805.00 11000.00 15329.23 1320937 .96 REPORT: APBOARDRPT GENERATED: 09 FEB 07 18:58 RUN: TUESDAY DEC1l2007 16: 38 RELEASE ID : PAGE 16 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 29 2007 TO DECEMBER 12 2007 -----------------------------------------------------------------------..---------------------------------------------------------- SUMMARY BY FUND -------------------------------------------------------------------.--------------------------------------------------------------- 001 GENERAL FUND 760004.98 030 REFUSE DISPOSAL FUND 182444.19 070 COMMUNITY DEVELPMNT BLOCK GRNT 110.65 080 ASSET SEIZURE FUND 7550.00 086 DUI FINE FUND 765.00 380 IEPA FLOOD CONTROL LOANS B&I 118403.52 510 CAPITAL IMPROVEMENT FUND 4182.89 550 DOWNTOWN REDEVLPMNT CONST 11531. 00 610 WATER AND SEWER FUND 117653.98 630 PARKING SYSTEM REVENUE FUND 22.04 660 VEHI CLE MAINTENANCE FUND 54331.96 670 VEHI CLE REPLACEMENT FUND 3112.80 690 RISK MANAGEMENT FUND 8698.00 710 POLl CE PENS I ON FUND 837.39 720 FIRE PENSION FUND 35960.33 790 ESCROW DEPOSIT FUND 15329.23 -----------_.- TOTAL : 1320937.96 J.L./J.;,!:/UI Village of M.ount Prospect t'd~'" J. EMR025 List of Escrow Checks Presented to the Board of Trustees 11/29/07 To 12/12/07 Paid to Permit # Check # Amount ALTERNATE POWER 072223 13003654 150.00 ALTRA CONSTRUCTION 072931 13003655 200.00 ARCHADECK OF LAKE COOK 072558 13003656 200.00 ARMCOR DESIGN & BUILD 071630 13003657 500.00 BISHOP PLUMBING INC 071643 13003658 125.00 BLUE PRAIRIE GROUP 072073 13003659 200.00 BODUCH, ANDY 071317 13003660 225.00 BOGUSZ, KAREN 072810 13003661 200.00 BRALEN BUILDING FOUR 071833 13003662 200.00 BRANDYS, MAREK 071620 13003663 150.00 CADY, FRED 071652 13003664 200.00 CEDAR CREEK LANDSCAPE 072822 13003665 200.00 072823 13003666 200.00 400.00 * CK GENERAL CONSTRUCTION 070946 13003667 325.00 COLONY APARTMENTS 072635 13003668 200.00 COMET NEON 072693 13003669 125.00 CONOSCENTI, DEANNA 071215 13003670 350.00 CORY, DAWN M 073004 13003671 125.00 DIMODA HOMES 071907 13003672 450.00 DOBNER, ALFRED 073016 13003673 125.00 DOVE, STEPHEN 071634 13003674 200.00 DZIADUS, MICHAEL 072687 13003675 200.00 E DOC COMMUNICATIONS 072754 13003676 500.00 FORTIS CONCRETE CO 070293 13003677 200.00 FOUR SEASONS INC 072766 13003678 75.00 FREEDOM HOME CONSTRUCTION 072381 13003679 200.00 HEINZ, STEPHEN 072805 13003680 125.00 JOSEPH LANDSCAPE & BRICK PAVING 072751 13003681 200.00 072922 13003682 200.00 400.00 * JUNIUS INVESTMENTS, MICHAEL & SHERYL 072493 13003683 125.00 KELLY LAND 05R538 13003684 5,020.00 KIM, I C 072710 13003685 75.00 KJE INSTALLATION SERVICES 072901 13003686 125.00 072919 13003687 ' 125.00 250.00 * KNITTER, EDITH 072964 13003688 125.00 KOLLENG, JOHN 072882 13003689 200.00 KOUJAIAN, H 072776 13003690 200.00 L J KEEFE CO 072711 13003691 500.00 LACHMAN, JOHN C 072634 13003692 200.00 LIBERTY SIGN COMPANY 073010 13003693 125.00 LOUCOPOULOS, TIM 071984 13003694 500.00 MARTENSEN, DAVID 072615 13003695 200.00 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES November 1 - November 30, 2007 12/11/2007 13:37:04 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/07 11/30/07 Cur Mo Received REVENUE BY CLASSIFICATION PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES Total All Funds 2,907,190 1,896,701 203,270 1,276,656 1,800,965 83,050 1,066,908 12,770 818,895 105 10,066,510 REVENUE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND POLICE PENSION FUND FIRE PENSION FUND ESCROW DEPOSIT FUND 4,199,160 505,747 171,003 -36 269,173 572 95 20 35,909 90,051 85,574 132,046 o o 279,201 o 4,460 23,477 51,279 65,291 o o o 2,006 314,794 152,294 3, III 1,067,059 11,153 9,590 157,947 110,252 18,488 632,363 779,255 895,120 o 1 Y-T-D Received 9,431,306 10,658,025 3,272,307 12,390,634 19,809,668 625,685 9,312,405 229,962 4,110,716 72,596 69,913,304 29,526,042 3,393,278 1,443,434 o 417,753 15,922 1,394 18,139 37,948 307,421 287,726 445,128 o o 866,685 o 32,047 74,122 370,118 466,972 o o o 69,081 1,017,890 1,233,806 30,036 9,436,707 102,876 94,434 1,577,395 1,223,731 194,798 6,456,442 5,229,952 5,541,287 o 11 Months 1 Month 2007 Budget 13,374,952 15,384,659 2,954,888 16,480,809 21,409,733 553,000 5,501,950 271,240 4,972,704 60,000 80,963,935 38,420,223 4,300,751 1,628,750 1,000 549,809 2,600 2,500 20,350 51,500 1,000 394,500 926,250 o o 1,076,500 o 49,367 88,507 582,933 735,250 o o o 262,800 1,220,052 1,711,100 32,000 11,149,100 96,738 111,100 1,573,353 1,093,626 189,547 6,473,939 4,125,500 4,093,290 o 91. 6% 8.3% Unreceived Balance 3,943,646 4,726,634 -317,419 4,090,175 1,600,065 -72,685 -3,810,455 41,278 861,988 -12,596 11,050,631 8,894,181 907,473 185,316 1,000 132,056 -13,322 1,106 2,211 13,552 -306,421 106,774 481,122 o o 209,815 o 17,320 14,385 212,815 268,278 o o o 193,719 202,162 477,294 1,964 1,712,393 -6,138 16,666 -4,042 -130,105 -5,251 17,497 -1,104,452 -1,447,997 o Completed Remaining unreceived Percent 29.5 30.7 -10.7 24.8 7.5 -13 .1 -69.3 15.2 17.3 -21.0 13.6 23.1 21.1 11. 4 100.0 24.0 -512.4 44.2 10.9 26.3 **** * 27.1 51. 9 19.5 35.1 16.3 36.5 36.5 73.7 16.6 27.9 6.1 15.4 -6.3 15.0 -0.3 -11.9 -2.8 0.3 -26.8 -35.4 12/11/2007 13:37:27 FRRBRR03 SUM 021 11 Months 1 Month 91. 6% 8.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 11/30/07 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 2,184,818 671,206 201,772 851,708 158,180 82,706 26,498 11,091 11,076 105 TOTAL GENERAL FUND 4,199,160 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 416,594 84,322 4,831 o TOTAL REFUSE DISPOSAL FUND 505,747 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 166,138 3,806 1,059 TOTAL MOTOR FUEL TAX FUND 171,003 LAW ENFORCEMENT BLOCK GRANT 43 46 INTERGOVERMENT REV. INVESTMENT INCOME TOTAL LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 48 OTHER REVENUE 258,810 53 10,310 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 269,173 ASSET SEIZURE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME TOTAL ASSET SEIZURE FUND DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 1 Y-T-D Received 7,033,130 5,679,932 3,250,033 10,692,178 1,548,952 595,687 453,538 182,266 90,221 105 29,526,042 1,381,264 1,943,673 68,181 160 3,393,278 1,380,560 55,367 7,507 1,443,434 o -36 -36 299,146 1,991 116,616 417,753 344 228 12,790 3,132 572 15,922 o 95 o 1,394 2007 Budget 10,050,926 8,447,000 2,935,250 14,162,700 1,551,507 531,000 397,000 189,740 155,100 o 38,420,223 2,016,276 2,211,475 72,000 1,000 4,300,751 1,587,500 34,750 6,500 1,628,750 o o 1,000 o o 1,000 489,809 o 60,000 549,809 1,000 1,600 2,600 1,000 1,500 Unreceived Balance 3,017,796 2,767,068 -314,783 3,470,522 2,555 -64,687 -56,538 7,474 64,879 -105 8,894,181 635,012 267,802 3,819 840 907,473 206,940 -20,617 -1,007 185,316 1,000 o Completed Remaining unreceived Percent 30.0 32.8 -10.7 24.5 0.2 -12.2 -14.2 3.9 41. 8 23.1 31.5 12.1 5.3 84.0 21.1 13.0 -59.3 -15.5 11.4 100.0 1,000 100.0 190,663 38.9 -1,991 -56,616 -94.4 132,056 24.0 -11,790 **** * -1,532 -95.8 -13,322 -512.4 1,000 106 100.0 7.1 12/11/2007 13,37,27 FRRBRR03 SUM 021 11 Months 1 Month Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 11/30/07 Cur Mo Received SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 4,295 165 TOTAL SERIES 1998A B&I, FLOOD 4,460 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 23,113 364 TOTAL SERIES 1998C B&I, TIF 23,477 IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 51,025 254 TOTAL IEPA FLOOD CONTROL LOANS B&I 51,279 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 63,723 1,568 TOTAL SERIES 2000 B&I, FLOOD CONTROL 65,291 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. CAPITAL IMPROVEMENT FUND 41 OTHER TAXES 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS o o 2,006 o 3 Y-T-D Received o o o 30,850 1,197 32,047 70,060 4,062 74,122 366,513 3,605 370,118 457,723 9,249 466,972 o o o o o o o o o o 18,750 35,940 o 2007 Budget o o o o o o 49,067 300 49,367 87,307 1,200 88,507 582,933 o 582,933 728,000 7,250 735,250 o o o o o o o o o o o o o o o o o o o 239,800 8,500 o Unreceived Balance 91.6% 8.3% 18,217 -897 17,320 17,247 -2,862 14,385 216,420 -3,605 212,815 270,277 -1,999 268,278 o 221,050 -27,440 o Completed Remaining unreceived Percent o o o 37.1 -299.0 35.1 19.8 -238.5 16.3 37.1 36.5 37.1 -27.6 36.5 o o o o o o o o o 92.2 -322.8 12/11/2007 13:37:27 FRRBRR03 SUM02l 11 Months 1 Month 91. 6% 8.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/07 11/30/07 Cur Mo Received 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 9,590 o o o TOTAL PARKING SYSTEM REVENUE FUND 9,590 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 155,595 2,352 o TOTAL VEHICLE MAINTENANCE FUND 157,947 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 84,963 25,289 o o TOTAL VEHICLE REPLACEMENT FUND 110,252 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 15,872 2,616 18,488 TOTAL COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 544,965 9,374 620 77,404 TOTAL RISK MANAGEMENT FUND 632,363 POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 453,579 325,676 TOTAL POLICE PENSION FUND 779,255 FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 501,047 394,073 TOTAL FIRE PENSION FUND 895,120 ESCROW DEPOSIT FUND 46 INVESTMENT INCOME TOTAL ESCROW DEPOSIT FUND 5 Y-T-D Received 94,434 o o o 94,434 1,555,953 21,340 102 1,577,395 849,626 301,614 o 72,491 1,223,731 161,547 33,251 194,798 5,450,450 101,745 39,106 865,141 6,456,442 3,710,085 1,519,867 5,229,952 4,064,294 1,476,993 5,541,287 o o 2007 Budget 110,000 1,100 o o 111,100 1,555,953 17,400 o 1,573,353 849,626 184,000 o 60,000 1,093,626 159,547 30,000 189,547 5,463,125 92,000 75,000 843,814 6,473,939 2,131,000 1,994,500 4,125,500 2,204,500 1,888,790 4,093,290 o o Unreceived Balance 15,566 1,100 o o 16,666 o - 3, 940 -102 -4,042 o -117,614 o -12,491 Completed Remaining Unreceived Percent 14.2 100.0 15.0 -22.6 -0.3 -63.9 -130,105 -11.9 -20.8 -2,000 -3,251 -5,251 12,675 -9,745 35,894 -21,327 17,497 -1,579,085 474,633 -1. 3 -10.8 -2.8 0.2 -10.6 47.9 -2.5 0.3 -74.1 23.8 -1,104,452 -26.8 -1,859,794 -84.4 411,797 21.8 -1,447,997 -35.4 o o o o 12/11/2007 13,36,19 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/07 11/30/07 Cur Mo Expended Y-T-D Expended 2007 Budget 91. 6% 8.3% Unexpended Balance Completed Remaining Unexpended Percent EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS PENSION BENEFITS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES LAND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS INFRASTRUCTURE BOND PRINCIPAL INTEREST EXPENSE BANK AND FISCAL FEES INTERFUND TRANSFERS Total All Funds 1,857,119 1,212,444 18,448 427,347 1,299,506 16,890 527,275 116,023 14,818 o o 30,394 20,757 23,609 6,590 486,637 1,666,444 391,022 o 105 8,115,428 EXPENDITURE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CaNST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND 3,439,835 337,316 8,979 -565 248,419 o o 908 o o 291,583 695,797 o o o 66,398 148,988 168,629 686,071 o o o 3,198 20,953 244,118 o 658,963 14,983 21,903,642 8,079,567 334,736 4,771,128 14,042,073 433,342 6,553,430 1,421,709 179,172 o 126,466 254,190 953,449 297,098 1,056,180 2,912,210 3,134,746 1,317,409 2,700 105 67,773,352 34,155,311 3,526,841 1,718,992 105 487,221 5,332 7,754 20,786 3,022 405,000 383,465 912,194 o 916,100 o 68,095 153,275 494,952 727,743 o o o 450,274 611,144 1,317,234 12,308 8,226,904 82,396 24,621,815 9,104,278 450,138 5,131,797 16,311,037 728,159 7,174,552 1,619,982 1,978,000 50,000 318,220 371,035 1,566,810 1,418,958 2,134,134 4,585,585 2,874,195 1,329,033 3,000 o 81,770,728 38,192,984 4,029,607 1,764,301 1,000 752,309 1,000 1,000 1,000 10,473 405,000 383,765 896,594 o 916,100 o 67,795 153,575 613,356 727,743 o o o 1,026,993 2,455,187 2,258,907 244,000 11,675,919 123,154 2,718,173 1,024,711 115,402 360,669 2,268,964 294,817 621,122 198,273 1,798,828 50,000 191,754 116,845 613,361 1,121,860 1,077,954 1,673,375 -260,551 11,624 300 -105 13,997,376 4,037,673 502,766 45,309 895 265,088 -4,332 -6,754 -19,786 7,451 o 300 -15,600 o o o -300 300 118,404 o o o o 576,719 1,844,043 941,673 231,692 3,449,015 40,758 11.0 11.3 25.6 7.0 13.9 40.5 8.7 12.2 90.9 100.0 60.3 31. 5 39.1 79.1 50.5 36.5 -9.1 0.9 10.0 17.1 10.6 12.5 2.6 89.5 35.2 -433.2 -675.4 **** * 71.1 0.1 -1. 7 -0.4 0.2 19.3 56.2 75.1 41. 7 95.0 29.5 33.1 12/11/2007 13,37,58 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 11/30/07 PUBLIC REPRESENTATION Cur Mo Expended PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 03 ADVISORY BOARDS & COMMISSIONS 8,442 945 Totals 9,387 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 2,718 518 247 5,883 o 21 Totals 9,387 SOURCE OF FUNDS 001 GENERAL FUND 9,387 Totals 9,387 1 Y-T-D Expended 102,130 16,288 118,418 34,297 6,261 992 73,488 410 2,970 118,418 118,418 118,418 2007 Budget 111,270 17,010 128,280 35,466 6,361 3,000 77,353 500 5,600 128,280 128,280 128,280 91. 6% 8.3% Unexpended Balance 9,140 722 9,862 1,169 100 2,008 3,865 90 2,630 9,862 9,862 9,862 Completed Remaining Unexpended Percent 8.2 4.2 7.7 3.3 1.6 66.9 5.0 18.0 47.0 7.7 7.7 7.7 12/11/2007 13,37,58 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 11/30/07 TV SERVICES DIVISION Cur Mo Expended PROGRAM TOTALS 02 CABLE TV OPERATIONS 04 INTERGOVERNMENTAL PROGRAMMING 9,541 3,896 Totals 13,437 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 7,856 3,683 o 1,434 2 40 422 Totals 13,437 SOURCE OF FUNDS 001 GENERAL FUND 13,437 Totals 13,437 3 Y-T-D Expended 110,240 36,711 146,951 88,958 38,874 1,500 7,763 2,141 4,915 2,800 146,951 146,951 146,951 2007 Budget 130,245 48,322 178,567 102,484 41,133 2,650 13,150 1,600 7,050 10,500 178,567 178,567 178,567 91.6% 8.3% Unexpended Balance 20,005 11,611 31,616 13,526 2,259 1,150 5,387 -541 2,135 7,700 31,616 31,616 31,616 Completed Remaining Unexpended Percent 15.4 24.0 17 .7 13 .2 5.5 43.4 41.0 -33.8 30.3 73.3 17.7 17.7 17.7 12/11/2007 11 Months 91. 6% Completed 13,37,58 VILLAGE OF MOUNT PROSPECT 1 Month 8.3% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/07 11/30/07 Cur Mo Y-T-D 2007 Unexpended Unexpended FINANCE DEPARTMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 25,197 292,439 301,287 8,848 2.9 02 ACCOUNTING 35,578 406,266 444,679 38,413 8.6 04 DUPLICATING SERVICES 0 0 0 0 05 INSURANCE PROGRAMS 50,649 515,432 521,445 6,013 1.2 06 CUSTOMER SERVICES 33,231 353,601 409,237 55,636 13.6 07 CASH MANAGEMENT 3,945 44,023 49,732 5,709 11.5 Totals 148,600 1,611,761 1,726,380 114,619 6.6 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 58,419 697,994 796,825 98,831 12.4 51 EMPLOYEE BENEFITS 25,423 276,992 295,144 18,152 6.2 52 OTHER EMPLOYEE COSTS' 121 8,404 10,640 2,236 21. 0 54 CONTRACTUAL SERVICES 12,115 146,326 137,776 -8,550 -6.2 55 UTILITIES 74 5,265 5,150 -115 -2.2 56 INSURANCE 45,061 450,605 450,605 0 57 COMMODITIES & SUPPLIES 7,387 22,333 24,240 1,907 7.9 65 OFFICE EQUIPMENT 0 3,842 6,000 2,158 36.0 Totals 148,600 1,611,761 1,726,380 114,619 6.6 SOURCE OF FUNDS 001 GENERAL FUND 148,600 1,611,761 1,726,380 114,619 6.6 Totals 148,600 1,611,761 1,726,380 114,619 6.6 5 12/11/2007 13:37:58 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 11/30/07 COMMUNITY DEVELOPMENT - CDBG Cur Mo Expended PROGRAM TOTALS 04 CDBG ADMINISTRATION 05 CDBG COMMUNITY PROGRAMS 06 ACCESSIBLTY & NEIGHBRHD IMPRV 07 CDBG RESIDENTIAL REHAB 4,056 7,172 225,000 12,191 Totals 248,419 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 62 LAND IMPROVEMENTS 64 BUILDING IMPROVEMENTS 69 INFRASTRUCTURE 2,310 1,589 75 7,254 o 12,191 o o 225,000 Totals 248,419 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 248,419 Totals 248,419 7 Y-T-D Expended 73,575 49,715 310,000 53,931 487,221 48,788 20,096 2,609 51,797 o 53,931 o o 310,000 487,221 487,221 487,221 2007 Budget 83,309 134,000 310,000 225,000 752,309 52,004 20,697 6,020 147,639 949 190,000 o o 335,000 752,309 752,309 752,309 91.6% 8.3% Unexpended Balance 9,734 84,285 o 171,069 265,088 3,216 601 3,411 95,842 949 136,069 o o 25,000 265,088 265,088 265,088 Completed Remaining Unexpended Percent 11.7 62.9 76.0 35.2 6.2 2.9 56.7 64.9 100.0 71.6 7.5 35.2 35.2 35.2 12/11/2007 13:37:58 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 11/30/07 POLICE Cur Mo Expended PROGRAM TOTALS 01 POLICE ADMINISTRATION 02 PATROL & TRAFFIC ENFORCEMENT 03 CRIME PREVTN & PUBLIC SERVICES 04 INVESTIGATIVE & JUVENILE PRGM 05 CROSSING GUARDS 06 EQUIPMENT MAINTENANCE 388,111 630,260 23,510 95,940 2,909 73,523 Totals 1,214,253 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 80 INTERFUND TRANSFERS 626,648 450,260 1,313 119,432 1,490 8,672 -670 7,003 105 Totals 1,214,253 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND 1,213,910 -565 o o 908 Totals 1,214,253 Y-T-D Expended 2,439,758 7,221,423 259,880 1,051,870 23,752 765,422 11,762,105 7,396,139 2,699,169 115,123 1,350,046 39,517 102,121 9,875 50,010 105 11,762,105 11,728,128 105 5,332 7,754 20,786 11,762,105 9 2007 Budget 2,946,090 8,219,929 342,746 1,207,078 29,380 807,753 13,552,976 8,592,849 3,185,309 123,000 1,420,145 49,200 122,423 14,000 46,050 o 13,552,976 13,548,976 1,000 1,000 1,000 1,000 13,552,976 91. 6% 8.3% Unexpended Balance 506,332 998,506 82,866 155,208 5,628 42,331 1,790,871 1,196,710 486,140 7,877 70,099 9,683 20,302 4,125 -3,960 -105 1,790,871 1,820,848 895 -4,332 -6,754 -19,786 1,790,871 Completed Remaining Unexpended Percent 17.2 12.1 24.2 12.9 19.2 5.2 13 .2 13.9 15.3 6.4 4.9 19.7 16.6 29.5 -8.6 13.2 13 .4 89.5 -433.2 -675.4 **** * 13.2 12/11/2007 13,37,58 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 11/30/07 PUBLIC WORKS - ADMINISTRATION Cur Mo Expended PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 104,634 Totals 104,634 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 17,161 11,991 888 74,488 106 o o o Totals 104,634 SOURCE OF FUNDS 001 GENERAL FUND 104,634 Totals 104,634 11 Y-T-D Expended 1,207,112 1,207,112 219,439 132,101 18,475 809,298 13,957 13,195 o 647 1,207,112 1,207,112 1,207,112 2007 Budget 1,259,759 1,259,759 237,193 135,476 30,095 821,835 18,990 14,475 1,090 605 1,259,759 1,259,759 1,259,759 91.6% 8.3% Unexpended Balance 52,647 52,647 17,754 3,375 11,620 12,537 5,033 1,280 1,090 -42 52,647 52,647 52,647 Completed Remaining Unexpended Percent 4.2 4.2 7.5 2.5 38.6 1.5 26.5 8.8 100.0 -6.9 4.2 4.2 4.2 12/11/2007 13,37,58 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 11/30/07 PUBLIC WORKS - FORESTRY/GRNDS Cur Mo Expended PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 02 MAINTENANCE OF GROUND 03 FORESTRY PROGRAM 04 PUBLIC GROUNDS BEAUTIFICATION 16,420 35,126 34,950 2,415 Totals 88,911 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 52,060 19,712 2,380 14,597 162 o Totals 88,911 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 88,166 745 Totals 88,911 13 Y-T-D Expended 191,978 438,519 769,059 76,892 1,476,448 642,075 217,160 2,866 531,207 63,090 20,050 1,476,448 1,475,703 745 1,476,448 2007 Budget 216,107 543,385 958,108 84,679 1,802,279 697,162 228,406 3,555 764,291 70,470 38,395 1,802,279 1,789,016 13,263 1,802,279 91. 6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 24,129 104,866 189,049 7,787 325,831 55,087 11,246 689 233,084 7,380 18,345 325,831 313,313 12,518 325,831 11.2 19.3 19.7 9.2 18.1 7.9 4.9 19.4 30.5 10.5 47.8 18.1 17.5 94.4 18.1 12/11/2007 13,37,58 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 11/30/07 PUBLIC WORKS - WATER/SEWER Cur Mo Expended PROGRAM TOTALS 01 WATER & SEWER DIVISION ADMIN 02 MAINTENANCE OF BUILDINGS 03 MAINTENANCE OF GROUNDS 04 WATER SUPPLY MAINT & REPAIR 05 WATER DISTRBT MAINT & REPAIR 06 WATER VALVE/HYDRNT MAINT & REP 07 WATER METER MAINT & REPL 08 EQUIPMENT MAINTENANCE 09 SANITARY SEWER MAINT & REPAIR 10 WATER & SEWER SYSTEM IMPROV 12 LAKE MICHIGAN WATER SUPPLY 106,409 13,575 6,884 42,262 49,157 24,522 15,251 60,609 33,565 43,924 262,805 Totals 658,963 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 121,258 53,447 291 440,850 12,640 13,566 5,321 o o 5,000 6,590 o Totals 65B,963 SOURCE OF FUNDS 610 WATER AND SEWER FUND 658,963 Totals 658,963 15 Y-T-D Expended 1,288,213 162,245 71,642 596,56B 564,105 309,986 280,649 606,091 380,243 1,195,991 2,771,171 B,226,904 1,505,381 583,144 18,428 4,547,322 114,886 135,664 178,957 o 4,709 82,233 1,056,180 o 8,226,904 8,226,904 8,226,904 2007 Budget 1,468,391 193,622 102,407 947,524 1,456,252 349,297 355,821 606,091 524,861 2,223,348 3,448,305 11,675,919 1,783,337 633,956 33,625 5,738,343 202,875 135,664 205,285 o 7,415 801,285 2,134,134 o 11,675,919 11,675,919 11,675,919 91.6% 8.3% Unexpended Balance 180,178 31,377 30,765 350,956 892,147 39,311 75,172 o 144,618 1,027,357 677,134 3,449,015 277,956 50,812 15,197 1,191,021 87,989 o 26,328 o 2,706 719,052 1,077,954 o 3,449,015 3,449,015 3,449,015 Completed Remaining Unexpended Percent 12.3 16.2 30.0 37.0 61. 3 11. 3 21.1 27.6 46.2 19.6 29.5 15.6 8.0 45.2 20.8 43.4 12.8 36.5 89.7 50.5 29.5 29.5 29.5 12/11/2007 13:37:58 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 11/30/07 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 02 VEHICLE MAINTENANCE PROGRAM 12,716 116,658 Totals 129,374 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 47,591 20,020 o 8,752 1 51,945 o o 1,065 Totals 129,374 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 129,374 Totals 129,374 17 Y-T-D Expended 158,478 1,130,581 1,289,059 583,720 217,432 770 57,120 861 427,591 o o 1,565 1,289,059 1,289,059 1,289,059 2007 Budget 185,783 1,392,570 1,578,353 695,541 237,031 2,250 78,151 1,060 555,370 o 530 8,420 1,578,353 1,578,353 1,578,353 91.6% 8.3% Unexpended Balance 27,305 261,989 289,294 111,821 19,599 1,480 21,031 199 127,779 o 530 6,855 289,294 289,294 289,294 Completed Remaining Unexpended Percent 14.7 18.8 18.3 16.1 8.3 65.8 26.9 18.8 23.0 100.0 81. 4 18.3 18.3 18.3 12/11/2007 13,37,58 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 11/30/07 CAPITAL IMPROVEMENT PROJECTS Cur Mo Expended PROGRAM TOTALS 01 VILLAGE IMPROVEMENTS & EQUIP 02 COMMUNITY IMPROVEMENT PROJECTS 03 DOWNTOWN REDEVELOPMENT CONST 04 FLOOD CONTROL PROJECTS 06 STREET IMPROVEMENT PROJECTS 09 MOTOR EQUIPMENT REPLACEMENT 10 COMPUTER REPLACEMENT 3,198 o 20,953 o 244,118 20,607 24,751 Totals 313,627 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 55 UTILITIES 59 OTHER EXPENDITURES 62 LAND IMPROVEMENTS 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 66 MOBILE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 71 BOND PRINCIPAL 72 INTEREST EXPENSE 80 INTERFUND TRANSFERS 10,840 o o o o 24,751 20,757 1,570 255,709 o o o Totals 313,627 SOURCE OF FUNDS 050 MOTOR FUEL TAX FUND 510 CAPITAL IMPROVEMENT FUND 550 DOWNTOWN REDEVLPMNT CONST 560 STREET IMPROVEMENT CONST FUND 590 FLOOD CONTROL CONST FUND 630 PARKING SYSTEM REVENUE FUND 670 VEHICLE REPLACEMENT FUND 680 COMPUTER REPLACEMENT FUND o 3,198 20,953 244,118 o o 20,607 24,751 Totals 313,627 19 Y-T-D Expended 450,274 o 610,244 12,308 2,551,754 815,011 173,245 4,612,836 262,872 o 122,703 o 122,460 200,745 953,449 65,861 2,490,715 350,000 44,031 o 4,612,836 1,234,520 450,274 610,244 1,317,234 12,308 o 815,011 173,245 4,612,836 2007 Budget 891,993 60,000 2,454,287 244,000 3,591,698 1,406,810 249,050 8,897,838 386,100 o 1,778,000 50,000 307,855 294,050 1,566,810 396,138 4,076,585 o 42,300 o 8,897,838 1,257,791 1,026,993 2,454,287 2,258,907 244,000 o 1,406,810 249,050 8,897,838 91. 6% 8.3% Unexpended Balance 441,719 60,000 1,844,043 231,692 1,039,944 591,799 75,805 4,285,002 123,228 o 1,655,297 50,000 185,395 93,305 613,361 330,277 1,585,870 -350,000 -1,731 o 4,285,002 23,271 576,719 1,844,043 941,673 231,692 o 591,799 75,805 4,285,002 Completed Remaining Unexpended Percent 49.5 100.0 75.1 95.0 29.0 42.1 30.4 48.2 31. 9 93.1 100.0 60.2 31.7 39.1 83.4 38.9 -4.1 48.2 1.9 56.2 75.1 41. 7 95.0 42.1 30.4 48.2 12/11/2007 13,37,58 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 11/30/07 11 Months 1 Month 91.6% 8.3% Completed Remaining Totals Cur Mo Y-T-D 2007 Unexpended Unexpended Expended Expended Budget Balance Percent 3,711 40,821 44,533 3,712 8.3 204,658 2,287,778 2,465,133 177,355 7.2 218,978 2,442,875 2,627,958 185,083 7.0 427,347 4,771,474 5,137,624 366,150 7.1 RETIREE PENSIONS PROGRAM TOTALS 01 MISCELLANEOUS PENSIONS 02 POLICE PENSIONS 03 FIRE PENSIONS EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 427,347 o o 4,770,655 750 69 5,131,324 5,800 500 360,669 5,050 431 7.0 87.1 86.2 Totals 427,347 4,771,474 5,137,624 366,150 7.1 SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FUND 720 FIRE PENSION FUND Totals 3,711 40,821 44,533 3,712 8.3 204,658 2,287,778 2,465,133 177,355 7.2 218,978 2,442,875 2,627,958 185,083 7.0 427,347 4,771,474 5,137,624 366,150 7.1 21 12/11/2007 13,37,58 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 11/30/07 NON-DEPARTMENTAL Cur Mo Expended Y-T-D Expended 2007 Budget PROGRAM TOTALS 01 CONTINGENCIES o o Totals o o EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS o o Totals o o SOURCE OF FUNDS 001 GENERAL FUND 560 STREET IMPROVEMENT CONST FUND 670 VEHICLE REPLACEMENT FUND o o o o o o Totals o o 23 91. 6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent o o o o o o o o o o o o o o o o 12/11/2007 13,37,58 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/07 - 11/30/07 MOUNT PROSPECT LIBRARY Cur Mo Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 LIBRARY SERVICES Totals EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES Totals SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND Totals 25 Y-T-D Expended o o o o o o 2007 Budget o 8,572,028 o 8,572,028 o 8,572,028 o 8,572,028 o 8,572,028 o 8,572,028 91.6% Completed 8.3% Remaining 8,572,028 100.0 8,572,028 100.0 8,572,028 100.0 8,572,028 100.0 8,572,028 100.0 8,572,028 100.0