The URL can be used to link to this page

Home My WebLink About3. BILLS & FINANCIALS 12/19/06 VILLAGE OF MOUNT PROSPECT CASH POSITION December 01 - 13, 2006 Cash & Invstmt Receipts Disbursements Other Cash & Invstmt Balance 12/01/06 Per Attached Credits/ Balance 12/01/06 12/13/06 List of Bills Debits 12/13/06 General Fund 7,748,028 885,619 588,559 8,045,088 Special Revenue Funds Refuse Disposal Fund 1,499,431 36,636 256,540 1,279,527 Motor Fuel Tax Fund 1,201,161 142,363 34,719 1,308,805 Local Law Enforcement Block Grant Fund 737 737 Community Development Blk Grant Fund (19,282) 19,020 6,364 (6,626) Asset Seizure Fund 71,955 1,360 73,315 DEA Shared Funds 49,367 49,367 DUI Fine Fund 33,568 1,350 34,918 Foreign Fire Tax Board Fund 55,209 55,209 Debt Service Funds 567,602 6,264 573,866 Capital Proiects Funds Capital Improvement Fund 1,249,542 240,103 1,009,439 Downtown Redevelopment Const Fund 1,739,108 63,287 1,675,821 Street Improvement Construction Fund 1,515,378 6,264 14,187 1,507,455 Flood Control Construction Fund 625,090 1 ,460 623,630 Enterprise Funds Water & Sewer Fund 4,056,283 453,891 306,806 4,203,368 Village Parking System Fund 65,544 2,108 3,870 63,782 Parking System Revenue Fund 24,906 1,883 129,665 (102,876) Internal Service Funds Vehicle Maintenance Fund 562,615 346 11,345 551,616 Vehicle Replacement Fund 6,223,742 1,096 6,222,646 Computer Replacement Fund 701,447 3,589 697,858 Risk Management Fund 3,103,674 91,220 434,702 2,760,192 Trust & Aaencv Funds Police Pension Fund 38,778,080 23,099 41 ,446 38,759,733 Fire Pension Fund 39,363,063 18,945 35,564 39,346,444 Flexcomp Trust Fund 38,143 10,901 11 ,412 37,632 Escrow Deposit Fund 1,603,996 30,339 19,723 1,614,612 110,858,387 1,731,608 2,204,437 110,385,558 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RIlN: WEDNESDAY DEC132006 11: 16 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 001 08366 ABT ELECTRONI CS REPAIR PARTS - THERMOSTAT 193.95 09863 ACCLAIM SHIPPING 42.00 1- YR MAINT. 1700.00 .--------..--- 1742.00 01071 ADDISON BUILDING MATERIAL CO. BLDG MATLS & HARDWllRE SUPPLIES 209.47 BLDG MATLS & HARDWARE SUPPLIES 7.64 BLDG MATLS & HARDWARE SUPPLIES 143 . 77 BLDGMATLS & HARDWARE SUPPLIES 62.61 BLDG MATLS & HARDWARE SUPPLIES 26.97 BLDG MATLS & HARDWARE SUPPLIES 44.66 BLDG MATLS & HARDWARE SUPPLIES 17.28 BLDG MATLS & HARDWARE SUPPLIES 168.87 BLDG AND HARDWARE MATLS 4.90 BLDG AND HARDWARE MATLS 163.67 BLDG. AND HARDWARE MATLS 8.70 B100 AND HARDWARE MATLS 33.18 ------------- 891.72 01246 AIRGAS NORTH CENTRAL OXYGEN RENTAL & SUPPLIES 177 .25 01670 AMERICAN PLANNING ASSOCIATION 2007 APA MEMBERSHIP-J.ZAWlLA 88.00 01752 AMERICAN SOCIETY SANITARY ENG. MEMBERSHIP DUES 85.00 01833 ANDERSON LOCK COMPANY 24VDC ELECTRIC STRIKE OPENER F 317 .10 00372 ANDLER I GLEN APW ASSOCIATION MEETING 96.68 REIMBURSEMENTS 63.25 REIMBURSEMENT PIBLIC MEETINGS 230.51 --_......---_..--- 390 .44 09544 ANDRES MEDICAL BILLING,LTD AMBULANCE BILLING FEES 2397.58 02001 ARAMARK IlNIFORM SERVICES, INC. IlNIFORM EXPENSE MECHANICS 52.96 02167 ARROW ROAD CONSTRUCTION 7.14 TON OF UPM 678.30 3.36 TON OF SURFACE 141.12 ------------.. 819.42 02261 ASSOCIATED ATTRACTIONS ENT.!NC RENTAL OF WINTER FESTIVAL FLOA 6150.00 02270 AT&T MONTHLY SERVICE 290.83 06287 BEDCO MECHANI CAL REPAIRS TO ROOF TOP 5839.25 08914 BERTUCA, ANGELINE TAX RELIEF GRANT 100.00 02757 BESSE MEDICAL SUPPLY FLU SHOT SUPPLIES 2247.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY DEC132006 11:16 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 .......... ......... --...................... -........................................................................ --..................................-......... -......-........ ......................................... .."...... .......................- -........- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -- -.... -... --.. -.....--.. ....._--...... --.. ---- -.... --...... -...... -.... ........-............ -- -oO- __ __............ ...................__.. __ ___.._...... .......... .._.. __ __.. ......__ _.... _......... __ __ ___.. .....___ 00468 BOLIN, JULIE A. REIMBURSEMENT 277.55 REIMBURSEMENT 180.76 ---..---......-.... 458.31 09891 BRENNER, PEARLE RI-INSPECTION REFUND 50.00 08573 BUSH, JOE & AMY REAL ESTATE TAX REBATE 576.00 09075 CASCADE CONSULTING ASSOCIATES, INC. STRUCALC 7.0 UPGRADE FOR COM D 255.00 MANUAL & CD FOR STRUCALC 35.00 -------..-....-- 290.00 01049 CDW GOVERNMENT, INC TRIPP LITE KVM CABLES - CDW # 330.00 SHI PPING 0.11 HP DLT VS1 160 GB . TAPE - CDW # 276.00 3COM GIGIBIT NIC - CDW # 52238 220.00 SHIPPING 12.99 TRIPP LITE UPS - CDW # 582532 544.00 TRIPP LITE USE CONNECTORS FOR 550.00 SHIPPING 24.03 VERITAS BACKUP EXEC REMOTE AGE 1690.00 COLOR PRINTER 221.99 VERITAS BACKUP EXEC MAINT 1383.21 --..-----....--- 5252 .33 01077 CHICAGO COMM. SERVICE, INC. RADIO RACK CHARGER REPAIR 207.00 08573 CHONG KI MIN & CHERI CHO-MIN REAL ESTATE TAX REBATE 740.00 08566 CHYNEK, RENATA OVERPAYMENT 66.00 07281 CL GRAPHICS, INC. PRINTING OF POSTERS 130.00 01147 COMMONWEALTH EDISON SPECIAL EVENTS/MELAS 181.07 01153 COMMUNITY CAB CO. NOVEMBER BILLING 543.80 08146 DELL MARKETING L.P. DELL 1950 SERVER - DUAL CORE X 3589.48 05538 DILTZ, TOM SNOW REMOVAL 160.00 05577 DR.KING DINNER/ICDHR GOLDEN SPONSOR-DINNER, 1/12/07 750.00 09892 DURAJ I MICHAL BUILDING REFUND 25.00 06343 EDDINGTON, RICHARD REIMBURSE EXPENSES 347.46 01328 EL-COR INDUSTRIES, INC. REPAIR PARTS 28.54 09653 ETERNO, DAVID G. ADMINISTRATIVE SERVICES 437 .50 01377 FEDERAL EXPRESS CORP SHIPPING 40.28 DELIVERY TO KTJ 17.65 -..----------.. REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY DECl3200'6 11:16 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION 00102 FIRE PENSION FUND PAYROLL FOR - 120706 07482 FLEETWOOD. FINANCIAL CORP. MAINTENANCE AGREEMENT 08918 FRIES, MARIE E. TAX RELIEF GRANT 01456 GABZDYL, BOZENA TAX RELIEF GRANT 08154 GLOBAL EMERGENCY PRODUCTS 6 MAGNETIC SWITCHES 04489 GOER INGER , CAROL D. TAX RELIEF GRANT 01522 GRAINGER INC. ELECTRICAL PARTS & SUPPLIES ELECTRICAL PARTS & SUPPLIES 04448 GROSELAK, JUDITH R. TAX RELIEF GRANT 01548 HAIGES MACHINERY, INC. WASHER REPAIR PARTS & LABOR 09876 HAMPTON INN AT U OF I LODGING FOR COMBAT CHALLENGE 08573 HAZEN, JOAN REAL ESTATE TAX REBATE 09205 HEALTH ENDEAVORS MEDICAL EXAMINIATIONS/POC 09113 HEALY ASPHALT COMPANY,LLC. PATCHING & PAVING MATERIALS 08573 HEIMDAL, ERIC REAL ESTATE TAX REBATE 03600 HENGLER, RI CHARD TAX RELIEF GRANT 09754 HLP SYSTEMS, INC. LIGHTNING PROTECTION AT PUBLIC 01609 HOLY FAMILY MEDICAL CENTER PRE EMPLOYMENT PHYSI CALS 01610 HOME DEPOT CREDIT SERVICES 24 ROLLS OF DUCK TAPE 09879 HULL, DAVID CLOTHING ALLOWANCE 01636 lACE BOB ROELS, HERNANDEZ, GARCIA 01650 ICMA I CMA MEMBERSHIP 00106 ICMA RETIREMENT TRUST - 401 EDDINGTON-401K 12/5/06 PAYROLL FOR - 120706 00107 PAYROLL FOR - 120706 I CMA RETIREMENT TRUST - 457 01689 IGFOA LUNCHEON 06690 ILLINOIS AMERICAN WATER CO. WATER SERVI CE PAGE AMOUNT 57.93 18944.58 3082.37 100.00 78.39 487.13 100.00 187.70 171.28 358.98 100.00 301.67 891.33 560.00 5840.00 1167.58 1338.00 100.00 16530.00 115.00 71.35 139 .43 11 0 .00 944.00 389.04 850.00 1239.04 17371.60 30.00 202.36 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY DEC132006 11: 16 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR. 120706 21918.39 01681 ILLINOIS FIRE CHIEFS ASSOC. 5 - Promotional Workshops Sept 425.00 01698 ILLINOIS MUNICIPAL LEAGUE MEMBERSHIP DUES 2496.00 09897 ILLINOIS NOTARY FEDERATION RENEWAL OF NOTARY 64.95 01701 ILLINOIS PAPER CO. 10 BOXES OF COPY PAPER 270.00 09898 ILLINOIS PUBLIC SAFETY AGENCY NETWORK PIMS SERVICE JAN-JULY 07 1200.00 01122 ILLINOIS STATE DISBURSEMENT UNIT PAYROLL FOR . 120706 800.00 PAYROLL FOR . 120706 116.31 PAYROLL FOR - 120706 520.75 PAYROLL FOR . 120706 1169.24 ..----......-..--.. 2606.30 07433 IMAGETEC LP ID #90133420787-COPIER LEASE 275.75 ID #90133643931 COPIER LEASE 586.13 .................----.. 861.88 09562 IMRF PAYROLL FOR . 120706 322.09 PAYROLL FOR . 120706 37524.49 PAYROLL FOR - 120706 16835.52 ---..-...---_.._- 54682.10 09889 INFECTION CONTROL/EMERGING CONCEPTS, INC. REGISTRATION JAN.11-12,2007 275.00 09832 INTERNATIONAL UNION OF OPERATING ENGINEERS PAYROLL FOR - 120706 760.12 PAYROLL FOR - 120706 235.62 .......---....-........ 995.74 09563 IRS PAYROLL FOR - 120706 169863.04 01896 J. C. LI CHT COMPANY MISC. PAINT AND SUPPLIES 144.83 01813 J.J. KELLER & ASSOCIATES, INC 2 - EMERGENCY RESPONSE GUIDES 56.95 00353 JANONIS, MICHAEL E. HOLIDAY RECEPTION 316.84 01783 JOURNAL & TOPICS NEWSPAPERS LEGAL NOTICE 371.48 06691 JUST TIRES Tires for #505 297.41 OVERAGE FROM POS006491 201.18 ......----...---..- 498.59 01818 KERSTEIN, JUNE BLOOD DRIVE REIMBURSEMENT 52.30 01856 LAGERHOLM, GLORIA TAX RELIEF GRANT 100.00 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY DEC132006 11:16 RELEASE ID : PAGE 5 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 .. ~ ................ --......................................................................... -- -.............................-.......... --..................... --........................................................................................................ DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ........................ --.................................... -- ............................... -- --......... --.....-.... --.. -- --..........................-.... --.. ................................................. -- --.................................... 01861 LANDS I END BUSINESS OUTFITTERS SHIRT & ONE LOGO CHARGE 39.50 CLOTHING SUPPLIES 233.45 CLOTHING SUPPLIES 150.00 SHIRTS 197.55 --------..-..-- 620.50 09766 LANER MUCHIN LABOR LEGAL SERVI CES 2310.00 01897 LIFE ASSIST Suction Wall Bracket 240.00 3 SG7001A Bfp CUFF 1 SG7001XL 96.99 ---....-------- 336.99 06403 LINDCO EQUIPMENT SALES, INC. SHOCK PLATE 608.34 00379 LINDELOF, CHARLES M. CLOTHING ALLOWANCE 122.20 09293 LOOPNET PREMIUM MEMBERSHIP 479.40 08573 MC ALCON, FRANK & CHARISSE REAL ESTATE TAX REBATE 1468.00 01990 MCMASTER-CARR SUPPLY CO. HOSE COUPLING PLUGS 22.41 08348 MEISTER, JACQUE SNOW REMOVAL 240.00 05021 MENARDS MISC.SUPPLIES & HARDWARE 251.09 MISC. SUPPLIES & HARDWARE 203.91 MISC.SUPPLIES & HARDWARE 182.04 ......--...-......-.... 637.04 00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 120706 2230.00 00117 METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - 120706 69B . 50 02007 MEYER MATERIAL CO. 20.25 TON - WASH GRAVEL 953.98 09523 MI CRO TECH SYSTEMS, INC. CLEAN LJ 4500N 172.45 02017 MIDDLETON, JOAN HOLIDAY RAFFLE ITEMS 105.85 BOOKS 103.25 BOOK 54.32 ------------- 263.42 02046 MOBILE PRINT INC. CONTRACTOR CARDS 105.37 500 Incident Business Cards 57.88 ...-------.......... 163.25 00399 MORGAN, NANCY REIMBURSEMENT HOLIDAY GIFTS 89.97 02057 MORTON ARBORETUM REGISTER -CLARK, HULL, SCHULTZ,AN 476.00 02066 MOUNT PROSPECT CHAMBER OF COMMERCE MEMBERSHIP DUES-JANONIS 310.00 -- _._-----~~._-- EPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY DEC132006 11:16 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .. - _................. oW.... __ ....................... ............................. __.......... __ __..........................._.............................................................................................._.. __.................................... 09885 N.HENRY & SON INC. 1 SAFETY BANNER 120.00 00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 120706 15483.35 02148 NEOPOST INC. MONEY ENTERED INTO POSTAGE MAC 3000.00 09502 NERADT HARDWARE CORP. REPAIR PARTS OF VEHICLE 8.98 05236 NFPA Reference Materials 314.69 05256 NI COR GAS SERVICE 49331.52 02172 NORTH SUB. ASSOC. OF CHIEFS OF POLICE MEMBERSHIP 50.00 02181 NORTHEASTERN ILLINOIS PLNG.COMM ANNUAL CONTRIBUTION 4750.00 02189 NORTHWEST CENTRAL DISPATCH SYS JANUARY 2007 ASSESSMENT 53003.31 02193 NORTHWEST ELECTRICAL SUPPLY ELECTRICAL/STREET LIGHT SUPPLI 3261.52 ELECTRICAL/STREET LIGHT SUPPLI 1272 .66 ELECTRI CAL/STREET LIGHT SUPPLI 198.18 ELECTRICAL/STREET LIGHT SUPPLI 3022.11 ELECTRICAL/STREET LIGHT SUPPLI 414.14 --------..--_... 8168.61 02199 NORTHWEST STATIONERS INC. SUPPLIES 8.96 TRAINING 12.60 BOOKRACK FOR NANCY 99.94 --..........-......--- 121. 50 08376 O'NEAL, TOM SNOW REMOVAL 225.00 02228 OAKTON PAVILLION HEALTHCARE HOME DELIVERED MEALS 1442.50 02229 OFFICE DEPOT OFFI CE SUPPLIES PLANNING 4.09 OFFICE SUPPLIES ECONOMIC 11.55 OFFICE SUPPLIES BUILDING 22.85 OFFICE SUPPLIES 10.56 OFFICE SUPPLIES ECONOMIC 27.23 OFFICE SUPPLIES #356070020001 47.49 OFFICE SUPPLIES #356070020001 19.47 Office Supplies for CERT TEAM 252.45 OFFICE SUPPLIES 357352471 12.65 OFFICE SUPPLIES357352471 10.28 OFFI CE SUPPLIES 31.39 OFFICE SUPPLIES #357352471001 24.44 OFFICE SUPPLIES #357352471001 14.96 OFFICE SUPPLIES #357352471001 82.72 ......-..--..-........ 572.13 08930 OTIS ELEVATOR COMPANY ELEVATOR MAINTENANCE AGREEMENT 702 . 09 07863 PACON CORPORATION WINTER FEST FLOAT DECORATING 637.03 R~PORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY DEC132006 11:16 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 ..-.... --...----.. ---........ --.... .._-...- -.. --- ----.. --..-.. -..-...-..-.. .....-- ----- -..-...... ..--...... -- ---.......... ..--- --- -- -- -_......- --- ........- -.....-.. -_...- --.. -.. ...-....-...-.... --.. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT --................... -..- .......-- --.. ---- ..--..- ..--...... ....----......-- .........- _....-- ..------.... ........-- --- -- ---.... ...--....- ----...-.. ----- --.....-...... --...... .......... -...-- --..- .......---- - . 02256 PADDOCK PUBLI CATIONS SUBSCRIPTION 260.00 SUBSCRIPTION DUES 260.00 SUBSCRIPTION 47.00 ------------.. 567.00 02256 PADDOCK PUBLICATIONS, INC. LEVY NOTI CE 495.84 02301 PETTY CASH - FINANCE DEFT. MISCELLANEOUS 51.60 MISCELLANEOUS 100.00 MISCELLANEOUS 42.71 MISCELIJ\NEOUS 3.11 MISCELLANEOUS 48.00 MISCELLANEOUS 48.60 MISCELLANEOUS 32.00 MISCELLANEOUS 146.13 MISCELLANEOUS 10.79 MISCELLANEOUS 91.00 ------..------ 573.94 02305 PETTY CASH - PUBLIC WORKS TRAVEL & SUPPLIES 31.00 TRAVEL & SUPPLIES 63.80 TRAVEL & SUPPLIES 5.48 TRAVEL & SUPPLIES 3.48 -----------...- 103.76 00124 POLICE PENSION FUND PAYROLL FOR - 120706 22823.60 06041 POPE, BRANDEN SNOW REMOVAL 225.00 04921 POPE, ELIZABETH A. PAYROLL FOR - 120706 923.08 02334 POSTMASTER BUSINESS REPLY RENEWAL 4000,01 660.00 POSTAGE STAMPS 390.00 --..-----...---.. 1050.00 06825 PUBLI C SAFETY CENTER, INC. 5 - Nomex Hoods 129.12 03918 REAL ESTATE INDEX INC. ORD nR1l82501 TITLE SEARCH 65.00 ORD nR1l82502 TITLE SETlRCH 65.00 .....----------- 130.00 02429 RIC M1\R INDUSTRIES, INC. CUSTODIAN SUPPLIES 408.18 09277 ROSEN I JUDY PIZZA PTlRTY 63.50 PROGRAM SUPPLIES 10.43 PROGRAM SUPPLIES 14.00 ------------- 87.93 02465 ROTTlRY LUNCH CLUB MT. PROSPECT !PROSPECT HTS QUARTERLY DUES 47.00 ROTARY MAGAZINE 6.00 QUARTERLY MEALS 190.00 lEPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY DEC132006 11: 16 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 PAGE DEPT VENDOR NBR INVOICE DESCRIPTION .......... .......... -................ - -..................... --..................... -_...........-.................. --......-...................................................................... --......................................................-..-.. -.... AMOUNT VENDOR NAME ... --- -.. ..--_.. -......-............... --........ -- ...--...... ....... --.. -- -..- -- ..-.. --.. ..........---.... -_.....- ...-- -.... ----- -..... ........-..... ----.. ......... ..--- -.....-..- ..........--- -........--.. -..---- 02468 ROUTE 12 RENTAL CO., INC. RENTAL OF GENERATORS 03917 RUNCO OFFICE SUPPLY & EQUIPMENT OFFI CE EQUIPMENT REPAIR 09857 SAVE ABANDONED BABIES FOUNDATION 4 SAVE HAVEN SIGNS 07529 SCHAMBACH SOFTWARE SOLUTIONS, INC. CONSULTING SERVICES 08573 SCHOBER, GEORGE REAL ESTATE TAX REBATE 02514 SCHWANDT, ALAN REIMBURSEMENT 09877 SKIC, ANDREW INSPECTION SUPPLIES 06853 SOCIETY FOR HUMAN RESOURCE MGMT JlR PROFESSIONAL MEMBERSHIP 02627 STEINER ELECTRIC COMPANY STREET LIGHT REPAIR & SUPPLIES PHILLIPS CDM35 LAMP BLR- 3 300V FUSES 02652 SUBURBAN BUILDING OFFICIALS CO DUES & MEMBERSHIPS 02672 SYSTEMS FORMS, INC. BLANK PERF PAPER TICKETS 13930/13929/13923 ENVELOPES #9 ENVELOPES #10 09668 T.P.r. PLUMBING INSPECTIONS BUILDING INSPECTIONS 04532 TAYLOR RENTAL CENTER RENTAL OF TENT, TABLES 02684 TERRACE SUPPLY COMPANY REPAIR PARTS 08854 THORNE, ONEIDA B. TAX RELIEF GRANT 09888 TRADE DIMENSIONS INTERNATIONAL, INC. 2006 RETAIL TENANT DIRECTORY 06975 TRI-ANIM HEALTH SERVICES, INC. 1 Box ET Holder Pediatric 08821 UNIFORMITY INCORPORATED 20 - 20 Sets of Badges, 100 Ba Various Uniforms & Workout Wea 00127 UNITED WAY PAYROLL FOR - 120706 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 120706 243.00 1008.25 79.00 120.00 6292.50 726.00 125.00 24.08 160.00 1204.6 8 140.00 100.66 1445.34 75.00 513 .13 1466.48 140.75 624.30 2744.66 280.00 1760.00 2040.00 1932.98 411.5 5 100.00 350.00 100.61 550.00 852.12 1402.12 366.05 23333.09 RepORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY DEC132006 11: 16 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 PAGE DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION ..................................................................................... ................. --........... --........................................................................-..............-...... --....................................................... AMOUNT .................................. --............................................................... -............................................................. -........................................... --...... -........ --........................................ PAYROLL FOR - 120906 WATER SEWER SERVI CE 04314 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES PAYROLL FOR - 120706 PAYROLL FOR - 120906 04381 WELCH, JOHN SNOW REMOVAL 05476 WGN FLAG & DECORATING CO. FESTOONING FOR WINTER FESTIVAL 08573 WHITESIDE, JOSEPH & CAROLE REAL ESTATE TAX REBATE 05746 WISCTF PAYROLL FOR - 120706 05269 WORLD POINT ECC, INC. CPR POCKET REFERNCE CARDS & MA SHIPPING 701.81 10.41 24045.31 1677 .11 200.00 1877 .11 240.00 392.11 810.00 542.48 170.00 9.75 TOTAL 588558.63 179.75 ~PORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 VILLAGE OF MOUNT PROSPECT RUN: WEDNESDAY DEC132006 11:16 RELEASE ID : LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 PAGE 12 lEPT VENDOR NBR .... ....- .-_.. -- --.. --....- --...... ---.. -.. -----.... --....- -- ---........ -.. ...-.. --.. -- -.......-....... -.... ............ -... ....._ -.._ __... .......... .............. __ --00-.. ........... ___ __.. __ ....._..... __ __.. AMOUNT VENDOR NAME INVOICE DESCRIPTION . ---- --- ---......- --- --- -...... -.. --.. -- ---........- ..-..-----.. .......-.. -... ---.... --......-.. .......... ---.... --- 00- __ ......... _.._...... ........_.... __........... _.._ .._____.._.. __...... __ ___"_00 08567 07797 08399 08567 01965 08567 05021 02162 HEARTH AND HOME, INC. REFUND FINAL SEWER BILL 02256 PADDOCK PUBLICATIONS, INC. ANNUAL SUBSCRIPTION FEE 02305 PETTY CASH - PUBLIC WORKS TRAVEL & SUPPLIES 02334 POSTMASTER UTILITY BILLING POSTAGE #4678 08567 QUANTRO I ANTHONY REFUND FINAL WATER BILL 02379 QUILL CORPORATION REPLACEMENT TONER CARTIRDGES - 08567 RUEGGEBERG, ERNA M. REFUND FINAL WATER BILL 08567 THIREY, WILLIAM REFUND FINAL WATER BILL 02775 USA BLUEBOOK GLOVES TOTAL IRON AGE CORP. SAFETY SHOE PURCHASE - MATT OV SAFETY SHOE PURCHASE - DAVE BO JP MORGAN CHASE BANK - JAWA WATER POWER o & M FIXED KASZUBA, WIESLAW REFUND FINAL WATER BILL MARTAM CONSTRUCTION HAULING OUT OF SWEEPINGS HAULING OUT OF SWEEPINGS HAULING OUT OF SWEEPINGS CONTRACTUAL HAULING CONTRACTUAL HAULING CONTRACTUAL HAULING EMERGENCY REPLACEMENT WATER MA MC NEILLY I SCOTT REFUND FINAL WATER BILL MENARDS MISC. SUPPLIES & HARDWARE NICOR 117 N WA VERL Y - ACCT# 112 E HIGHLAND ACCT# GAS SERVICE 1452.74 5.00 115.00 106.99 221.99 148118.00 9377.00 15588.00 81274.00 254357.00 216.40 4502.90 1660.59 1200.00 1490.60 400.00 1062.00 8650.00 18966.09 64.91 114.4 8 149.78 201.69 2681.59 3033.06 244.40 69.70 10000.00 21. 64 772 .17 10.82 33.63 108.32 306806.09 RE.PORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY DEC132006 11: 16 RELEASE 10 : PAGE 13 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ................................... --................................................-.... ................................-................ -..... --"'.'" -..... ........................................... _.............................................-....... --............................ --........... 620 02301 PETTY CASH - FINANCE DEPT. MISCELLANEOUS LOO 09280 TOTAL PARKING SOLUTIONS, INC. REPLACEMENT OF LOCK W/KEYS 460.00 PARKING MAINTENANCE CONTRACT 3408.56 ..-..........................- 3868.56 TOTAL 3869.56 630 01071 ADDISON BUILDING MATERIAL CO. BLDG AND HARDWARE MATLS 7.64 05256 NICOR GAS SERVI CE 117 .70 02301 PETTY CASH - FlNAMCE DEPT. MISCELLANEOUS 20.00 MISCELLANEOUS 22.00 ..........-----....- 42.00 02624 TREASURER, STATE OF ILLINOIS TRAIN DEPOT PARKING LOT REHAB 129455.00 02806 VILLAGE OF MOUNT PROSPECT WATER SEWER SERVI CE 42.87 TOTAL 129665.21 660 01071 ADDISON BUILDING MATERIAL CO. BLOG MATLS & HARDWARE SUPPLIES 33.98 BLOG AND HARDWARE MATLS 32.93 ----.................... 66.91 04036 AERIAL- LIFT INC. ANNUAL OSHA AERIAL LIFT 592.03 09676 AMERICAN MESSAGING PAGER MESSAGING SERVICE 53.46 02095 ARLINGTON MUFFLER SHOP REPLACE EXHAUST FLANGES 80.00 02108 ARLINGTON POWER EQUI PMENT PARTS 144.19 02938 BOWMAN DISTRIBUTION CENTER NUTS/BOLTS & HARDWARE 756.02 06468 BP GASOLINE 126.54 00302 CASTELLANOS, SAL MECHANIC TOOL ALLOWANCE 840.00 01045 CATCHING FLUIDPOWER PARKER HYDRAULIC FITTING 111.78 PARKER HYDRAULI C FITTING 70.34 _oo_----..----- 182.12 01236 DAVE & JIM'S AUTO BODY, INC. RECHARGE AIR CONDITIONING 35.00 01276 DIRTBUSTERS AUTO DETAILING, INC. HAND WAX 350.00 00322 EISEN, BARRY MECHANIC TOOL ALLOWANCE 840.00 R~PORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY DEC132006 11:16 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION PAGE 15 AMOUNT REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 , RUN: WEDNESDAY DECl32006 11: 16 RELEASE ID : PAGE 17 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 DEPT VENDOR NBR VENDOR NAME INVOI CE DESCRI PTI ON AMOUNT 09880 ISPEN, JAMES OVERPAYMENT ALARM LICENSE 10.00 06641 MANZO I S BANQUETS RETIREMENT DINNER 1/26/07 200.00 02072 MOUNT PROSPECT PUBLIC LIBRARY PPRT 8TH ALLOCATION 2226.09 09890 NOBLES I RON OVERPAYMENT 10.00 09882 PARKWAY BANK & TRUST CO. DUPLICATE PAYMENT 75.00 02689 THIRD DISTRICT CIRCUIT COURT BOND MONEY 1350.00 BOND MONEY 1350.00 BOND MONEY 650.00 BOND MONEY 1800.00 _w_______...__.. 5150.00 02808 VILLAGE OF MOUNT PROSPECT DUMPSTER 50.00 INSPECTION' 11650.00 ...----..-..----- 11700.00 09884 WIREFORMS, INC. OVERPAYMENT ALARM LICENSE 10.00 TOTAL 19723.09 GRAND TOTAL 2204435.55 REPORT: APBOARDRPT GENERATED: 09 AUG 06 16:39 RUN: WEDNESDAY DEC132006 11: 16 RELEASE ID : PAGE 18 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 30 2006 TO DECEMBER 13 2006 ~... -----------.... --.... --.. -- ----...... --............ --.... ---- -- -- -- --- ---.. --...... -- -- ----.... ---.... --..--.. --...... --- -- -- --...... --.......... ---.. --...... --.. ---.... --.. SUMMARY BY FUND ...... -- --- --.... --.. --- -......... --- --......- --........ --...... -- --- --- --.... -- --..... --- ---- -- ---................ -- --.... -- ---.. -- --.............. --.. ---...... --- -- -- ----........ --.. 001 GENERAL FUND 588558.63 030 REFUSE DISPOSAL FUND 256539.68 050 MOTOR FUEL TAX FUND 34718.81 070 COMMUNITY DEVELPMNT BLOCK GRNT 6364.3 5 510 CAPITAL IMPROVEMENT FUND 240102.80 550 DOWNTOWN REDEVLPMNT CONST 63286.88 560 STREET IMPROVEMENT CONST FUND 14186.70 590 FLOOD CONTROL CONST FUND 1460.00 610 WATER AND SEWER FUND 306806.09 620 VILLAGE PARKING SYSTEM FUND 3869.56 630 PARKING SYSTEM REVENUE FUND 129665.21 660 VEHICLE MAINTENANCE FUND 11345.31 670 VEHI CLE REPLACEMENT FUND 1095.53 680 COMPUTER REPLACEMENT FUND 3589.48 690 RI SK MANAGEMENT FUND 434 701. 77 710 POLICE PENSION FUND 41446.08 720 FIRE PENSION FUND 35563.52 770 FLEXCOMP ESCROW FUND 11412 .06 790 ESCROW DEPOSIT FUND 19723.09 ._-_00--------- TOTAL : 2204435,55 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES November 1- November 30, 2006 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/06 11/30/06 12/14/2006 15:11:36 Cur Mo Received Y-T-D Received 11 Months 1 Month 2006 Budget 91. 6% 8.3% Unreceived Balance Completed Remaining Unreceived Percent REVENUE BY CLASSIFICATION PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES Total All Funds -10,896 829,886 204,338 1,513,326 1,747,619 27,364 626,103 22,089 171,583 o 5,131,412 REVENUE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND SERIES 2003 PROJECT FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND POLICE PENSION FUND FIRE PENSION FUND 2,240,881 281,423 160,872 28 12,492 1,442 130 2,140 38,376 1,880 1,219 2,767 o o 1,585 17,638 5,825 809 55,138 38,230 o o o 8,211 o 7,853 167,760 2,745 677,348 8,062 7,530 146,347 114,512 19,143 588,731 270,178 245,550 10,362,203 12,546,366 3,058,955 12,598,397 18,609,931 457,797 5,067,664 312,661 4,836,244 484,113 68,334,331 29,254,011 3,832,248 1,425,162 63 381,833 12,224 1,434 17,627 83,183 426,303 398,225 855,726 9,434 o 782,677 183,744 60,938 136,018 552,458 375,900 25,703 o o 204,026 o 1,265,874 1,784,069 34,027 9,466,262 89,816 95,831 1,454,826 1,160,328 184,025 6,288,345 3,785,005 3,688,853 1 10,441,909 14,566,963 2,880,166 16,052,627 20,422,428 547,200 4,211,275 347,788 4,762,088 375,000 74,607,444 34,161,176 4,033,827 1,639,215 1,000 49,9,317 1,100 2,500 23,300 o 413,338 391,298 916,469 5,000 o 893,750 195,211 64,145 152,500 627,541 425,000 o o o 52,626 o 1,367,911 1,769,955 27,250 10,512,211 102,756 238,455 1,450,058 1,083,413 180,020 6,316,682 3,654,043 3,406,377 79,706 2,020,597 -178,789 3,454,230 1,812,497 89,403 -856,389 35,127 -74,156 -109,113 6,273,113 4,907,165 201,579 214,053 937 117,484 -11,124 1,066 5,673 -83,183 -12,965 -6,927 60,743 -4,434 o 111,073 11,467 3,207 16,482 75,083 49,100 -25,703 o o -151,400 o 102,037 -14,114 -6,777 1,045,949 12,940 142,624 -4,768 -76,915 -4,005 28,337 -130,962 -282,476 0.8 13.9 -6.2 21.5 8.9 16.3 -20.3 10.1 -1. 6 -29.1 8.4 14.4 5.0 13 .1 93.7 23.5 **** * 42.6 24.3 -3.1 -1. 8 6.6 -88.7 12.4 5.9 5.0 10.8 12.0 11.6 -287.7 7.5 -0.8 -24.9 9.9 12.6 59.8 -0.3 -7.1 -2.2 0.4 -3.6 -8.3 12/14/2006 15:11:36 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/06 - 11/30/06 11 Months 1 Month 91. 6% 8.3% Completed Remaining Cur Mo Y-T-D 2006 Unreceived Unreceived Received Received Budget Balance Percent ESCROW DEPOSIT FUND 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 69 14,848 0 -14,848 SERIES 2002 LIBRARY BND ESCROW 4,498 3,285 0 -3,285 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 5,131,412 68,334,331 74,607,444 6,273,113 8.4 2 12/14/2006 15:11:55 FRRBRR03 SUM 021 11 Months 1 Month 91.6% 8.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/06 - 11/30/06 Cur Mo Received GENERAL FUND 40 PROPERTY TAXES 41. OTHER TAXES 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 45 FINES AND FORFEITS 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES -10,904 515,217 203,478 1.352,058 73,029 24,186 56,017 11,795 16,005 o TOTAL GENERAL FUND 2,240,881 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE o 276,368 5,305 -250 TOTAL REFUSE DISPOSAL FUND 281,423 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 155,798 5,074 o TOTAL MOTOR FUEL TAX FUND 160,872 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME TOTAL LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 48 OTHER REVENUE 5,470 6 7,016 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 12,492 ASSET ,SEIZURE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 1,144 298 TOTAL ASSET SEIZURE FUND 1,442 DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME Y-T-D Received 7,021,568 6,090,146 3,046,655 10,769,800 1,115,548 431,418 428,634 193,521 156,721 o 29,254,011 1,917,576 1,839,810 64,272 10,590 3,832,248 1,368,218 47,798 9,146 1,425,162 o 28 28 332,379 107 49,347 381,833 9,476 2,748 12,224 o 130 o 1,434 1 2006 Budget 7,136,332 7,601,250 2,858,750 13,847,740 1,517,817 523,000 204,700 284,662 186,925 o 34,161,176 1,910,472 2,077,355 45,000 1,000 4,033,827 1,625,115 9,100 5,000 1,639,215 o 63 63 1,000 o 1,000 449,317 o 50,000 499,317 100 1,000 1,100 1,000 1,500 Unreceived Balance 114,764 1,511,104 -187,905 3,077,940 402,269 91,582 -223,934 91,141 30,204 o 4,907,165 -7,104 237,545 -19,272 -9,590 201,579 256,897 -38,698 -4,146 214,053 Completed Remaining unreceived Percent 1.6 19.9 -6.6 22.2 26.5 17.5 -109.4 32.0 16.2 14.4 -0.4 11.4 -42.8 -959.0 5.0 15.8 -425.3 -82.9 13.1 1,000 100.0 -63 116,938 -107 653 117,484 -9,376 -1,748 -11,124 937 93.7 26.0 1.3 23.5 ****.* -174.8 ****.* 1,000 66 100.0 4.4 12/14/2006 15:11:55 FRRBRR03 SUM 021 11 Months 1 Month Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary . . . 01/01/06 11/30/06 Cur Mo Received TOTAL DEA SHARED FUNDS FUND 130 DUI FINE FUND 45 FINES AND FORFEITS . 46 INVESTMENT INCOME 2,034 106 TOTAL DUI FINE FUND 2,140 FOREIGN FIRE TAX BOARD FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 38,307 69 o TOTAL FOREIGN FIRE TAX BOARD FUND 38,376 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME 8 1,872 TOTAL SERIES 1987A B&I, PW FACILITY 1,880 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 1,219 o TOTAL SERIES 2001 B&I, VILLAGE HALL 1,219 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 2,767 o TOTAL SERIES 2003 B&I, VILLAGE HALL 2,767 SERIES 2002B B&I, PUBLIC BLOGS 40 PROPERTY TAXES 46 INVESTMENT INCOME TOTAL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 1,585 o 2 Y-T-D Received 1,434 16,903 724 17,627 38,307 674 44,202 83,183 416,768 9,535 426,303 391,836 6,389 o 398,225 605,021 14,455 236,250 855,726 o o 9,434 o o 9,434 o o o o 764,990 17,687 o 2006 Budget 2,500 23,100 200 23,300 o o o o 405,338 8,000 413,338 387,298 4,000 o 391,298 597,469 4,000 315,000 916,469 5,000 o 5,000 o o o o o o 880,000 13,750 o Unreceived Balance 91. 6% 8.3% 1,066 6,197 -524 5,673 -38,307 -674 -44,202 -83,183 -11,430 -1,535 -12,965 ~4,538 -2,389 o -6,927 Completed' Remaining Unreceived Percent 42.6 26.8 -262.0 24.3 -2.8 -19.2 -3.1 -1.2 -59.7 -1.8 -7,552 -1.3 -10,455 -261.4 78,750 25.0 60,743 6.6 -4,434 -88.7 o -4,434 -88.7 115,010 -3,937 o o o o 13.1 -28.6 , 12/14/2006 15:11:55 FRRBRR03 SUM on 11 Months 1 Month 91.6% 8.3% Budget VILLAGE OF MOORT PROSPECT Revenue by Category within Fund Summary 01/01/06 - 11/30/06 Cur Mo Received Y-T-:-D Received 2006 Budget Unreceived Balance Completed Remaining Unreceived Percent TOTAL SERIES 1999 B&I, TIF 1,585 12.4 SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 17,015 623 TOTAL SERIES 1996A B&I, FLOOD 17,638 SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 5,593 232 TOTAL SERIES 1998A BU, FLOOD 5,825 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME o 809 TOTAL SERIES 1998C B&I, TIF 809 IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 55,138 o TOTAL IEPA FLOOD CONTROL LOANS B&I 55,138 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 36,908 1,322 TOTAL SERIES 2000 BU, FLOOD CONTROL 38,230 SERIES 2002B B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 2002B B&I, STREET IMP. 3 782,677 180,216 3,528 183,744 59,487 1,451 60,938 130,395 5,623 136,018 552,458 o 552,458 367,987 7,913 375,900 o o 25,703 o o 25,703 o o o o o o 893,750 193,611 1,600 195,211 63,645 500 64,145 150,000 2,500 152,500 627,441 100 627,541 420,000 5,000 425,000 o o o o o o 111,073 13,395 -1,928 11,467 6.9 -120.5 5.9 4,158 6.5 -951 -190.2 3,207 19,605 -3,123 16,482 74,983 100 75,083 52,013 -2,913 49,100 o o -25,703 o o -25,703 o o o o o o 5.0 13.1 -124.9 10.8 12.0 100.0 12.0 12.4 -58.3 11.6 o o o o o o 12/14/2006 15:11:55 FRRBRR03 SUM 021 11 Months 1 Month 91.6% 8.3% Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/06 - 11/30/06 Cur Mo Received CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES o 5,311 o 2,900 o TOTAL CAPITAL IMPROVEMENT FUND 8,2J.J. SERIES 2003 PROJECT FUND 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 2003 PROJECT FUNI> DOWNTOWN REDEVLPMNT CONST 4J. OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES o 7,853 o o TOTAL DOWNTOWN REDEVLPMNT CONST 7,853 STREET IMPROVEMENT CONST FUND 4 J. OTHER TAXES 42 LICENSES, PERMITS & FEES 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 161,708 o 6,052 o o TOTAL STREET IMPROVEMENT CONST FUND 167,760 FLOOD CONTROL CONST FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 2,745 o TOTAL FLOOD CONTROL CONST FUND 2,745 WATER AND SEWER FUND 4 J. OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES o 860 646,934 21,011 o 8,543 o TOTAL WATER AND SEWER FUND 677,348 4 Y-T-D Received 128,000 66,626 o 9,400 o 204,026 o o o 1,189,133 60,228 o 16,513 J.,265,874 1,612,411 o 51,045 o 120,613 J.,784,069 o 34,027 o 34,027 1,520,873 12,300 7,734,795 167,021 o 31,273 o 9,466,262 2006 Budget o 30,000 8,126 14,500 o 52,626 o o o 1,367,911 o o o J.,367,9J.J. J.,739,005 o 30,950 () o J.,769,955 o 27,250 o 27,250 J.,524,J.00 14,000 8,846,6J.1 J.02,500 o 25,000 o J.0,5J.2,2J.J. Unreceived Balance -128,000 -36,626 8,J.26 5,100 o Completed " Remaining Unreceived Percent -122.1 100.0 35.2 -J.5J.,400 -287.7 o o o J.78,778 -60,228 o -16,513 102,037 126,594 o -20,095 o -120,613 -14,114 o -6,777 o -6,777 3,227 1,700 J.,J.11,816 -64,521 o -6,273 o J.,045,949 o o o 13.J. 7.5 7.3 -64.9 -0.8 -24.9 -24.9 0.2 12.1 J.2.6 -62.9 -25.J. 9.9 12/14/2006 15:11:55 FRRBRR03 SUM 021 11 Months 1 Month Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/06 - 11/30/06 Cur Mo Received VILLAGE PARKING SYSTEM FUND 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES o 7,813 249 o TOTAL VILLAGE PARKING SYSTEM FUND 8,062 PARKING SYSTEM REVENUE FUND 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES o o 7,424 106 o o TOTAL PARKING SYSTEM REVENUE FUND 7,530 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 143,689 2,658 o TOTAL VEHICLE MAINTENANCE FUND 146,347 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 89,540 24,972 o o TOTAL VEHICLE REPLACEMENT FUND 114,512 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 15,563 3,580 TOTAL COMPUTER REPLACEMENT FUND 19,143 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 487,259 14,290 10,294 76,888 588,731 TOTAL RISK MANAGEMENT FUND POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 210,821 59,357 TOTAL POLICE PENSION FUND 270,178 5 Y-T-D Received o 83,597 6,219 o 89,816 o o 94,073 1,758 o o 95,831 1,436,858 16,969 999 1,454,826 895,413 198,380 o 66,535 1,160,328 155,620 28,405 184,025 5,254,217 92,549 109,994 831,585 6,288,345 1,791,808 1,993,197 3,785,005 2006 Budget 7,416 94,240 1,100 o 102,756 o 129,455 108,000 1,000 o o 238,455 1,436,858 13,200 o 1,450,058 895,413 128,000 o 60,000 1,083,413 155,620 24,400 180,020 5,290,514 32,500 50,000 943,668 6,316,682 1,802,925 1,851,118 3,65~,043 Unreceived Balance 91. 6% 8.3% 7,416 10,643 -5,119 o 12,940 o 129,455 13,927 -758 o o 142,624 o -3,769 -999 -4,768 o -70,380 o -6,535 -76,915 Completed Remaining Unreceived Percent 100.0 11.3 -465.4 12.6 100.0 12.9 -75.8 59.8 -28.6 -0.3 -55.0 -10.9 -7.1 o -4,005 -16.4 -4,005 36,297 -60,049 -59,994 112,083 28,337 11,117 -142,079 -130,962 -2.2 0.7 -184.8 -120.0 11.9 0.4 0.6 -7.7 -3.6 12/14/2006 15:11:55 FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/06 - 11/30/06 11 Months 1 Month 91. 6% 8.3% Completed Remaining FIRE PENSION FUND 46 INVESTMENT INCOME .48 OTHER REVENUE Cur Mo Y-T-D 2006 Unreceived Unreceived Received Received Budget Balance Percent 244,426 1,935,721 1,716,500 -219,221 -12.8 1,124 1,753,132 1,689,877 -63,255 -3.7 245,550 3,688,853 3,406,377 -282,476 -8.3 TOTAL FIRE PENSION FUND ESCROW DEPOSIT FUND 46 INVESTMENT INCOME o o o o TOTAL ESCROW DEPOSIT FUND o o o o SSA #6 GEORGE/ALBERT B&1 41 OTHER TAXES 46 INVESTMENT INCOME o 69 14,260 588 o o -14,260 -588 TOTAL SSA #6 GEORGE/ALBERT B&I 69 14,848 o -14,848 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME 4,498 3,285 o -3,285 TOTAL SERIES 2002 LIBRARY BND ESCROW 4,498 3,285 o -3,285 GENERAL FIXED ASSETS ACCT GP 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES o o o o o o o o TOTAL GENERAL FIXED ASSETS ACCT GP o o o o MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES o o 8,113,291 8,113,291 100.0 8,113,291 100.0 TOTAL MOUNT PROSPECT LIBRARY FUND o o 8,113,291 6 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/06 11/30/06 12/14/2006 15:10:41 Cur Mo Expended Y-T-D Expended 2006 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,816,094 552,602 30,833 424,837 1,326,914 28,161 538,884 119,242 28,418 o 825 40,966 4,036 9,835 267,253 53,353 1,582,270 426,471 300 o 7,251,294 EXPENDITURE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND FOREIGN FIRE TAX BOARD FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND SERIES 2003 PROJECT FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND 2,671,929 336,101 54,344 o 21,609 o o o 1,969 o 291,026 688,353 o o o 209,408 62,673 147,838 168,629 441,114 o o o 20,698 o 49,654 22,820 o 20,479,197 5,762,417 331,163 4,590,307 12,935,285 366,369 6,062,752 1,163,660 443,795 4,360 105,215 200,859 420,678 614,648 929,828 2,977,595 2,478,383 1,117,476 3,450 1,266,203 62,253,640 30,506,807 3,381,335 1,897,993 o 379,557 o 5,629 1,267 27,974 o 387,053 912,306 o 16,513 840,400 214,265 65,645 155,975 494,950 492,828 o 80,810 39,803 711,469 o 501,336 798,442 298,400 1 23,535,274 6,069,522 413,562 4,949,171 15,288,720 590,695 7,102,323 1,383,502 5,416,282 54,360 390,635 264,670 1,175,680 675,560 1,773,523 5,603,118 2,605,398 1,245,623 4,200 315,000 78,856,818 33,445,888 3,960,243 2,538,717 1,000 691,200 1,100 2,500 1,000 o 151,000 387,053 912,308 o o 840,400 214,715 65,645 156,275 613,353 492,828 o o o 1,658,901 o 6,046,726 1,597,657 527,538 3,056,077 307,105 82,399 358,864 2,353,435 224,326 1,039,571 219,842 4,972,487 50,000 285,420 63,811 755,002 60,912 843,695 2,625,523 127,015 128,147 750 -951,203 16,603,178 2,939,081 578,908 640,724 1,000 311,643 1,100 -3,129 -267 -27,974 151,000 o 2 o -16,513 o 450 o 300 118,403 o o -80,810 -39,803 947,432 o 5,545,390 799,215 229,138 13.0 5.1 19.9 7.3 15.4 38.0 14.6 15.9 91. 8 92.0 73.1 24.1 64.2 9.0 47.6 46.9 4.9 10.3 17.9 -302.0 21.1 8.8 14.6 25.2 100.0 45.1 100.0 -125.2 -26.7 100.0 0.2 0.2 19.3 57.1 91. 7 50.0 43.4 12/14/2006 15:10:41 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/06 - 11/30/06 11 Months 1 Month 91. 6% 8.3% Completed Remaining Cur Mo Y-T-D 2006 Unexpended Unexpended Expended Expended Budget Balance Percent WATER AND SEWER FUND 1,007,547 8,240,112 10,229,607 1,989,495 19.4 VILLAGE PARKING SYSTEM FUND 11,596 124,444 152,798 28,354 18.6 PARKING SYSTEM REVENUE FUND 15,280 120,170 260,865 140,695 53.9 VEHICLE MAINTENANCE FUND 118,213 1,228,034 1,450,029 221,995 15.3 VEHICLE REPLACEMENT FUND 3,886 364,199 1,030,680 666,481 64.7 COMPUTER REPLACEMENT FUND 24,386 138,517 162,800 24,283 14.9 RISK MANAGEMENT FUND 461,018 5,275,302 6,367,780 1,092,478 17.2 POLICE PENSION FUND 201,005 2,210,156 2,375,461 165,305 7.0 FIRE PENSION FUND 220,198 2,341,949 2,520,751 178,802 7.1 SSA #6 GEORGE/ALBERT B&I 0 0 0 0 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 7,251,294 62,253,640 78,856,818 16,603,178 21.1 2 12/14/2006 15,12:37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 NON-DEPARTMENTAL Cur Mo Expended o PROGRAM TOTALS 00 ADMINISTRATION Totals EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS Totals SOURCE OF FUNDS 230 SERIES 2002A B&I, TIF 430 SERIES 1998A B&I, STREET IMP. 440 SERIES 2002B B&I, STREET IMP. Totals Y-T-D Expended 2006 Budget o o o o o o o o o o o o o o o o 1 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 12/14/2006 15,12,37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 PUBLIC REPRESENTATION Cur Mo Expended PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 03 ADVISORY BOARDS & COMMISSIONS 5,373 1,351 Totals 6,724 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 2,859 543 o 2,858 18 446 Totals 6,724 SOURCE OF FUNDS 001 GENERAL FUND 6,724 Totals 6,724 2 Y-T-D Expended 96,730 14,451 1.1.1.,1.81. 31,996 5,892 2 67,886 380 5,025 11.1,181. 111,181 1.11,1.81. 2006 Budget 102,581 16,312 11.8,893 35,077 6,948 2,000 68,768 500 5,600 118,893 118,893 118,893 91.6% Completed 8.3% Remaining Unexpended Balance 5,851 1,861 7,712 3,081 1,056 1,998 882 120 575 7,712 7,712 7,712 Unexpended Percent 5.7 11.4 6.5 8.8 15.2 99.9 1.3 24.0 10.3 6.5 6.5 6.5 12/14/2006 15,12,37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 11/30/06 VILLAGE MANAGER'S OFFICE Cur Mo Expended PROGRAM TOTALS 01 VILLAGE MANAGER'S OFFICE 02 LEGAL SERVICES 03 PERSONNEL SERVICES 04 INFORMATION TECHNOLOGY 05 PUBLIC INFORMATION 30,168 50,295 20,153 77,961 7,976 Totals 186,553 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 56,422 20,265 1,190 91,924 666 774 15,312 o Totals 186,553 SOURCE OF FUNDS 001 GENERAL FUND 186,553 186,553 Totals Y-T-D Expended 444,612 343,011 214,120 706,124 107,574 1,815,441 695,011 233,442 31,580 815,461 4,961 9,288 19,708 5,990 1,815,441 1,815,441 1,815,441 3 2006 Budget 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 471,554 340,000 270,849 827,226 139,883 2,049,512 796,864 251,559 44,950 894,434 8,005 11,100 30,600 12,000 2,049,512 2,049,512 2,049,512 26,942 -3,011 56,729 121,102 32,309 234,071 101,853 18,117 13,370 78,973 3,044 1,812 10,892 6,010 234,071 234,071 234,071 5.7 -0.9 20.9 14.6 23.1 11.4 12.8 7.2 29.7 8.8 38.0 16.3 35.6 50.1 11.4 11.4 11.4 12/14/2006 11 Months 91. 6% Completed. 15:12:37 VILLAGE OF MOUNT PROSPECT 1 Month 8.3% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/06 - 11/30/06 Cur Mo Y-T-D 2006 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 15,165 122,218 130,787 8,569 6.6 04 INTERGOVERNMENTAL PROGRAMMING 3,406 37,722 38,564 842 2.2 Totals 18,571 159,940 169,351 9,411 5.6 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 7,733 92,115 98,168 6,053 6.2 51 EMPLOYEE BENEFITS 3,609 38,286 39,576 1,290 3.3 52 OTHER EMPLOYEE COSTS 0 555 2,650 2,095 79.1 54 CONTRACTUAL SERVICES 342 9,934 9,357 -577 -6.2 55 UTILITIES 123 1,810 1,500 -310 -20.7 57 COMMODITIES & SUPPLIES 1,321 7,345 4,800 -2,545 -53.0 67 OTHER EQUIPMENT 5,443 9,895 13,300 3,405 25.6 Totals 1.8,571. 1.59,940 169,351 9,41.1. 5.6 SOURCE OF FUNDS 001 GENERAL FUND 1.8,571 159,940 169,351 9,411 5.6 Totals 1.8,571 1.59,940 169,351 9,41.1 5.6 4 . 12/14/2006 15,12,37 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 11 Months 1 Month 91.6% Completed 8.3% Remaining Cur Mo Y-T-D 2006 Unexpended Unexpended VILLAGE CLERK'S OFFICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 14,135 177,566 203,826 26,260 12.9 Totals 14,135 177,566 203,826 26,260 12.9 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES Totals 8,154 100,325 107,135 6,810 6.4 3,760 40,895 42,329 1,434 3.4 -112 1,865 2,812 947 33.7 2,216 26,808 41,635 14,827 35.6 62 1,299 1,600 301 18.8 55 6,374 8,315 1,941 23.3 14,135 177,566 203,826 26,260 12.9 SOURCE OF FUNDS 001 GENERAL FUND 14,135 177,566 203,826 26,260 12.9 Totals 14,135 177,566 203,826 26,260 12.9 5 12/14/2006 11 Months 91.6% Completed 15:12:37 VILLAGE OF MOUNT PROSPECT 1 Month 8.3% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/06 - 11/30/06 Cur Mo Y-T-D 2006 Unexpended Unexpended FINANCE DEPARTMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 21,869 242,724 227,700 -15,024 -6.6 02 ACCOUNTING 35,299 392,415 428,676 36,261 8.5 04 DUPLICATING SERVICES 0 0 0 0 05 INSURANCE PROGRAMS 53,119 539,890 545,817 5,927 1.1 06 CUSTOMER SERVICES 33,715 352,399 386,536 34,137 8.8 07 CASH MANAGEMENT 2,675 30,302 48,032 17,730 36.9 Totals 146,677 1,557,730 1,636,761 79,031 4.8 EXPE~ITURE CLASSIFICATION 50 PERSONAL SERVICES 57,385 674,826 760,021 85,195 11.2 51 EMPLOYEE BENEFITS 24,742 268,655 284,593 15,938 5.6 52 OTHER EMPLOYEE COSTS 250 10,005 8,255 -1,750 -21. 2 54 CONTRACTUAL SERVICES 8,230 89,825 72 ,145 -17,680 -24.5 55 UTILITIES 234 4,693 5,400 707 13.1 56 INSURANCE 47,763 477,625 477,622 -3 57 COMMODITIES & SUPPLIES 8,073 22,301 23,725 1,424 6.0 65 OFFICE EQUIPMENT 0 9,800 5,000 -4,800 -96.0 Totals 146,677 1,557,730 1,636,761 79,031 4.8 SOURCE OF FUNDS 001 GENERAL FUND 146,677 1,557,730 1,636,761 79,031 4.8 Totals 146,677 1,557,730 1,636,761 79,031 4.8 6 12/14/2006 15:12:37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure SUmmary 01/01/06 - 11/30/06 COMMUNITY DEVELOPMENT Cur Mo Expended PROGRAM TOTALS 01 COMMUNITY DEVELOPMENT ADMIN 02 PLANNING & ZONING 03 ECONOMIC DEVELOPMENT 05 BUILDING INSPECTIONS 06 HOUSING INSPECTIONS 07 HEALTH INSPECTIONS 15,979 21,279 6,732 59,175 28,633 9,710 Totals 141,508 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 81,766 38,206 3,519 16,433 1,034 550 o Totals 141,508 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 141,508 o Totals 141,508 Y-T-D Expended 191,593 237,327 94,900 685,717 290,565 110,597 1,610,699 982,471 414,842 25,626 161,318 13,492 12,950 o 1,610,699 1,609,899 800 1,610,699 7 2006 Budget 91.6% 8.3% Completed Remaining Unexpended unexpended Balance Percent 218,003 247,795 105,934 786,878 322,751 124,170 1,805,531 1,135,033 443,987 27,660 165,322 18,015 15,514 o 1,805,531 1,804,731 800 1,805,531 26,410 10,468 11,034 101,161 32,186 13,573 194,832 152,562 29,145 2,034 4,004 4,523 2,564 o 194,832 194,832 o 194,832 12.1 4.2 10.4 12.9 10.0 10.9 10.8 13.4 6.6 7.4 2.4 25.1 16.5 10.8 10.8 10.8 12/14/2006 15:12:37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 COMMUNITY DEVELOPMENT - CDBG Cur Mo Expended PROGRAM TOTALS 04 CDBG ADMINISTRATION 05 CDBG COMMUNITY PROGRAMS 06 ACCESSIBLTY & NEIGHBRHD IMPRV 07 CDBG RESIDENTIAL REHAB 6,729 12,187 o 2,693 Totals 21,609 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 64 BUILDING IMPROVEMENTS 69 INFRASTRUCTURE 4,152 1,876 o 12,394 592 2,595 o o Totals 21,609 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 21,609 21,609 Totals 8 Y-T-D Expended 76,236 107,886 96,614 98,821 379,557 52,599 20,480 1,878 121,106 886 85,994 1,156 95,458 379,557 379,557 379,557 2006 Budget 76,000 148,200 225,000 242,000 691,200 47,545 20,389 4,230 166,115 921 227,000 o 225,000 691,200 691,200 691,200 91.6% 8.3% Unexpended Balance -236 40,314 128,386 143,179 311,643 -5,054 -91 2,352 45,009 35 141,006 -1,156 129,542 311,643 311,643 311,643 Completed. Remaining Unexpended Percent -0.3 27.2 57.1 59.2 45.1 -10.6 -0.4 55.6 27.1 3.8 62.1 57.6 45.1 45.1 45.1 12/14/2006 15:12:37 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 HUMAN SERVICES Cur Mo Expended PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 02 SOCIAL SERVICES 03 NURSING/HEALTH SERVICES 04 SENIOR CTR. LEISURE ACTIVITIES 05 YOUTH ACTIVITIES 12, 904 27,871 28,325 2,749 37 Totals 71.886 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 36,766 14,304 3 3,678 382 16,753 o Totals 71.886 SOURCE OF FUNDS 001 GENERAL FUND 71,886 Totals 71.886 Y-T-D Expended 162,355 303,128 162,199 30,735 37 658.454 427,575 152,474 2,693 43,070 6,089 25,560 993 658.454 658,454 658.454 9 2006 Budget 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 172,399 333,069 183,827 44,266 o 733.561 466,733 162,525 3,750 56,485 8,000 35,068 1,000 733.561 733,561 733.561 10,044 29,941 21,628 13,531 -37 75,107 39,158 10,051 1,057 13,415 1,911 9,508 7 75.107 75,107 75,107 5.8 9.0 11.8 30.6 10.2 8.4 6.2 28.2 23.7 23.9 27.1 0.7 10.2 10.2 10.2 12/14/2006 15,12,37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 11/30/06 POLICE Cur Mo Expended PROGRAM TOTALS 01 POLICE ADMINISTRATION 02 PATROL & TRAFFIC ENFORCEMENT 03 CRIME PREVTN & PUBLIC SERVICES 04 INVESTIGATIVE & JUVENILE PRGM 05 CROSSING GUARDS 06 EQUIPMENT MAINTENANCE 111,164 600,014 20,007 96,313 2,803 60,279 Totals 890,580 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 608,873 160,150 2,329 105,705 2,943 9,718 64 798 Totals 890,580 SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND 890,580 o o o o Totals 890,580 10 Y-T-D Expended 1,360,090 6,969,550 215,259 1,065,437 21,649 626,990 10,258,975 7,078,233 1,632,044 107,217 1,236,948 35,616 117,023 24,685 27,209 10,258,975 10,252,079 o o 5,629 1,267 10,258,975 2006 Budget 1,609,916 7,803,636 249,161 1,183,690 28,317 658,208 11,532,928 8,182,686 1,676,051 125,985 1,319,758 47,400 133,723 16,975 30,350 11,532,928 11,527,328 1,000 1,100 2,500 1,000 11,532,928 91. 6% 8.3% Unexpended Balance 249,826 834,086 33,902 118,253 6,668 31,218 1,273,953 1,104,453 44,007 18,768 82,810 11,784 16,700 -7,710 3,141 1,273,953 1,275,249 1,000 1,100 -3,129 -267 1,273,953 Completed Remaining Unexpended Percent 15.5 10.7 13 .6 10.0 23.5 4.7 11.0 13.5 2.6 14.9 6.3 24.9 12.5 -45.4 10.3 11.0 11.1 100.0 100.0 -125.2 -26.7 11.0 12/14/2006 15:12:37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 FIRE Cur Mo Expended PROGRAM TOTALS 01 FIRE ADMINISTRATION 02 FIRE DEPARTMENT OPERATIONS 03 FIRE TRAINING ACADEMY 04 FIRE PREVENTION 05 FIRE COMMUNICATIONS 06 EQUIPMENT MAINTENANCE 07 EMERGENCY PREPARDENESS PRGM 08 PAID-ON-CALL PROGRAM 09 EMERGENCY ASSISTANCE PROGRAM 10 FOREIGN FIRE INSURANCE 109,911 560,145 3,050 41,046 7,277 44,861 353 1,664 o 1,969 Totals 770,276 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 556,251 126,579 19,221 o 51,408 2,822 11,751 642 o 1,602 Totals 770,276 SOURCE OF FUNDS 001 GENERAL FUND 095 FOREIGN FIRE TAX BOARD FUND 768,307 1,969 Totals 770,276 Y-T-D Expended 868,403 6,017,543 9,895 460,421 54,651 461,483 11,323 22,024 o 27,974 7,933,717 5,859,416 1,283,554 91,418 o 453,885 39,197 106,774 3,857 o 95,616 7,933,717 7,905,743 27,974 7,933,717 11 2006 Budget 91. 6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 940,046 6,670,175 13,331 518,822 62,800 472,257 12,295 32,700 o o 8,722,426 6,579,098 1,312,812 117,195 o 484,741 42,500 104,910 4,000 4,000 73,170 8,722,426 8,722,426 o 8,722,426 71,643 652,632 3,436 58,401 8,149 10,774 972 10,676 o -27,974 788,709 719,682 29,258 25,777 o 30,856 3,303 -1,864 143 4,000 -22,446 788,709 816,683 -27,974 788,709 7.6 9.8 25.8 11.3 13.0 2.3 7.9 32.6 9.0 10.9 2.2 22.0 6.4 7.8 -1. 8 3.6 100.0 -30.7 9.0 9.4 9.0 12/14/2006 11 Months 91.6% Completed 15:12:37 VILLAGE OF MOUNT PROSPECT 1 Month 8.3% Remaining FRRDBROl SUM031 Department Budget Expenditure Summary 01/01/06 - 11/30/06 Cur Mo Y-T-D 2006 Unexpended Unexpended PUBLIC WORKS - ADMINISTRATION Expended Expended Budget Balance Percent PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 108,047 1,141,347 1,184,708 43,361 3.7 Totals 108,047 1,141,347 1,184,708 43,361 3.7 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 17,787 208,538 237,711 29,173 12.3 51 EMPLOYEE BENEFITS 11,570 125,217 130,504 5,287 4.1 52 OTHER EMPLOYEE COSTS 2,354 24,501 28,660 4,159 14.5 54 CONTRACTUAL SERVICES 74,956 755,614 754,403 -1,211 -0.2 55 UTILITIES 1,104 12,743 18,040 5,297 29.4 57 COMMODITIES & SUPPLIES 61 13,084 13,740 656 4.8 65 OFFICE EQUIPMENT 215 1,060 1,060 0 67 OTHER EQUIPMENT 0 590 590 0 Totals 108,047 1,141,347 1,184,708 43,361 3.7 SOURCE OF FUNDS 001 GENERAL FUND 108,047 1,141,347 1,184,708 43,361 3.7 Totals 108,047 1,141,347 1,184,708 43,361 3.7 12 12/14/2006 15:12,37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 PUBLIC WORKS - STREETS/BLDGS Cur Mo Expended PROGRAM TOTALS 01 STREET DIVISION ADMINISTRATION 02 MAINTENANCE - PUBLIC BUILDINGS 04 STREET MAINTENANCE 05 SNOW REMOVAL 06 LEAF REMOVAL 07 STORM SEWER & BASIN MAINT 08 MAINTENANCE OF STATE HIGHWAYS 09 TRAFFIC SIGN MAINTENANCE 10 VILLAGE PARKING LOT MAINT 11 PARKING LOT MAINTENANCE 12 FLOOD CONTROL 9,292 58,110 55,873 9,764 o 13,521 6,984 16,924 11,596 15,280 o Totals 197,344 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 64 BUILDING IMPROVEMENTS 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 80 INTERFUND TRANSFERS 64,012 26,334 81,434 1,128 2,027 20,879 o o o 1,530 o Totals 197,344 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 127,574 42,894 11,596 15,280 Totals 197,344 13 Y-T-D Expended 124,442 736,310 401,930 241,368 o 145,165 54,429 107,258 124,444 120,170 o 2,055,516 904,062 308,702 510,523 18,654 20,265 191,935 o 958 7,830 92,587 o 2,055,516 1,683,090 127,812 124,444 120,170 2,055,516 2006 Budget 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 164,731 924,909 461,847 412,733 o 176,027 68,010 115,918 152,798 131,410 o 2,608,383 1,092,076 341,627 624,949 109,205 20,265 277,081 o 6,180 8,000 129,000 o 2,608,383 2,107,495 216,680 152,798 131,410 2,608,383 40,289 188,599 59,917 171,365 o 30,862 13,581 8,660 28,354 11,240 o 552,867 188,014 32,925 114,426 90,551 o 85,146 o 5,222 170 36,413 o 552,867 424,405 88,868 28,354 11,240 552,867 24.5 20.4 13.0 41.5 17.5 20.0 7.5 18.6 8.6 21.2 17.2 9.6 18.3 82.9 30.7 84.5 2.1 28.2 21.2 20.1 41.0 18.6 8.6 21.2 12/14/2006 15:12:37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 11/30/06 PUBLIC WORKS - FORESTRY/GRNDS Cur Mo Expended PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 02 MAINTENANCE OF GROUND 03 FORESTRY PROGRAM 04 PUBLIC GROUNDS BEAUTIFICATION 15,803 35,184 47,945 2,356 Totals 101,288 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 46,838 18,733 47 31,569 4,101 o Totals 101,288 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 101,288 o Totals 101,288 14 Y-T-D Expended 176,415 413,395 576,974 64,280 1,231,064 592,184 206,947 2,504 364,085 51,044 14,300 1,231,064 1,230,868 196 1,231,064 2006 Budget 209,915 480,375 784,110 78,862 1,553,262 679,609 223,268 3,455 569,710 51,920 25,300 1,553,262 1,542,662 10,600 1,553,262 91. 6% 8.3% Unexpended Balance 33,500 66,980 207,136 14,582 322,198 87,425 16,321 951 205,625 876 11,000 322,198 311,794 10,404 322,198 Completed Remaining Unexpended Percent 16.0 13.9 26.4 18.5 20.7 12.9 7.3 27.5 36.1 1.7 43.5 20.7 20.2 98.2 20.7 12/14/2006 15:12:37 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 45,391 14,166 Totals 59,557 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 32,808 15,751 o 7,866 2,914 218 o o o Totals 59,557 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 57,082 2,475 Totals 59,557 15 Y-T-D Expended 663,319 503,597 1,166,916 517,688 180,341 5,268 108,102 121,690 13,727 490 o 219,610 1,166,916 794,797 372,119 1,166,916 2006 Budget 740,696 625,266 1,365,962 586,406 192,442 5,235 172,314 165,270 22,625 515 1,545 219,610 1,365,962 935,197 430,765 1,365,962 91.6% 8.3% Unexpended Balance 77,377 121,669 199,046 68,718 12,101 -33 64,212 43,580 8,898 25 1,545 o 199,046 140,400 58,646 199,046 Completed Remaining Unexpended Percent 10.4 19.5 14.6 11. 7 6.3 -0.6 37.3 26.4 39.3 4.9 100.0 14.6 15.0 13.6 14.6 12/14/2006 15:12:37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 11/30/06 PUBLIC WORKS - WATER/SEWER 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 Totals 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 Totals SOURCE OF FUNDS 610 WATER AND SEWER FUND Totals Cur Mo Expended 126,940 21,653 4,791 97,737 45,558 22,384 18,868 66,476 58,445 271,660 273,035 1,007,547 120,679 52,693 1,507 515,755 14,234 28,293 4,352 o 989 1,792 267,253 o 1,007,547 1,007,547 1,007,547 16 Y-T-D Expended 1,398,236 156,832 76,516 515,629 517,844 280,263 252,590 664,756 350,238 1,126,286 2,900,922 8,240,112 1,446,692 568,396 25,451 4,684,819 104,213 282,929 161,432 o 5,606 30,746 929,828 o 8,240,112 8,240,112 8,240,112 2006 Budget 1,579,384 194,788 87,442 842,279 666,185 320,041 330,083 664,756 475,576 1,844,873 3,224,200 10,229,607 1,751,202 626,178 32,990 5,368,535 163,655 282,929 173,910 o 7,205 49,480 1,773,523 o 10,229,607 10,229,607 10,229,607 91.6% 8.3% Unexpended Balance 181,148 37,956 10,926 326,650 148,341 39,778 77,493 o 125,338 718,587 323,278 1,989,495 304,510 57,782 7,539 683,716 59,442 o 12,478 o 1,599 18,734 843,695 o 1,989,495 1,989,495 1,989,495 Completed Remaining Unexpended Percent 11.5 19.5 12.5 38.8 22.3 12.4 23.5 26.4 39.0 10.0 19.4 17.4 9.2 22.9 12.7 36.3 7.2 22.2 37.9 47.6 19.4 19.4 19.4 12/14/2006 15:12:37 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 276,637 59,464 Totals 336,101 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 52,843 12,529 o 267,590 25 783 2,331 Totals 336,101 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 336,101 Totals 336,101 Y-T-D Expended 3,206,375 174,960 3,381,335 186,021 65,499 o 3,102,819 312 7,827 18,857 3,381,335 3,381,335 3,381,335 17 2006 Budget 91. 6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 3,763,240 197,003 3,960,243 212,298 70,041 1,735 3,648,971 575 7,827 18,790 3,960,243 3,960,243 3,960,243 556,865 22,043 578,908 26,277 4,542 1,735 546,158 263 o -67 578,908 578,908 578,908 14.8 11.2 14.6 12.4 6.5 100.0 15.0 45.7 -0.4 14.6 14.6 14.6 12/14/2006 15,12,37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 02 VEHICLE MAINTENANCE PROGRAM 13,185 105,028 118,213 Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 59,613 20,654 525 5,765 62 31,394 o o 200 Totals 118,213 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 118,213 118,213 Totals 18 Y-T-D Expended 152,671 1,075,363 1,228,034 571,650 209,098 600 65,600 810 377,095 o o 3,181 1,228,034 1,228,034 1,228,034 2006 Budget 91. 6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 188,374 1,261,655 1,450,029 681,460 228,477 2,000 75,982 1,030 452,240 o 515 8,325 1,450,029 1,45(),029 1,450,029 35,703 186,292 221,995 109,810 19,379 1,400 10,382 220 75,145 o 515 5,144 221,995 221,995 221,995 19.0 14.8 15.3 16.1 8.5 70.0 13.7 21.4 16.6 100.0 61.8 15.3 15.3 15.3 12/14/2006 15:12:37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 COMMUNITY SERVICE PROGRAMS Cur Mo Expended PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 03 4TH OF JULY & CIVIC EVENTS,ETC 04 HOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM 9,556 2,266 17,322 219 Totals 29,363 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 1,153 304 20,400 410 5,873 1,223 Totals 29,363 SOURCE OF FUNDS 001 GENERAL FUND 29,363 Totals 29,363 Y-T-D Expended 104,226 98,727 34,391 2,276 239,620 57,795 7,653 144,044 410 22,960 6,758 239,620 239,620 239,620 19 2006 Budget 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 123,500 132,533 80,003 2,792 338,828 86,152 16,216 197,140 o 29,320 10,000 338,828 338,828 338,828 19,274 33,806 45,612 516 99,208 28,357 8,563 53,096 -410 6,360 3,242 99,208 99,208 99,208 15.6 25.5 57.0 18.5 29.3 32.9 52.8 26.9 21. 7 32.4 29.3 29.3 29.3 12/14/2006 15:12:37 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 CAPITAL IMPROVEMENT PROJECTS .Cur Mo Expended PROGRAM TOTALS 01 VILLAGE IMPROVEMENTS & EQUIP 02 COMMUNITY IMPROVEMENT PROJECTS 03 DOWNTOWN REDEVELOPMENT CONST 04 FLOOD CONTROL PROJECTS 06 STREET IMPROVEMENT PROJECTS 09 MOTOR EQUIPMENT REPLACEMENT 10 COMPUTER REPLACEMENT 20,698 o 49,654 o 31,795 3,886 24,386 Totals 130,419 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 25,391 o 24,600 o 183 24,386 4,036 o 51,823 o Totals 130,419 SOURCE OF FUNDS 050 MOTOR FUEL TAX FUND 510 CAPITAL IMPROVEMENT FUND 526 SERIES 2003 PROJECT FUND 550 DOWNTOWN REDEVLPMNT CONST 560 STREET IMPROVEMENT CONST FUND 590 FLOOD CONTROL CONST FUND 630 PARKING SYSTEM REVENUE FUND 670 VEHICLE REPLACEMENT FUND 680 COMPUTER REPLACEMENT FUND 8,975 20,698 o 49,654 22,820 o o 3,886 24,386 130,419 Totals 20 Y-T-D Expended 705,657 5,812 500,536 298,400 2,196,504 364,199 138,517 4,209,625 170,665 o 351,043 4,360 99,244 138,517 420,678 419,291 2,569,940 35,887 4,209,625 1,398,062 711,469 o 500,536 798,442 298,400 o 364,199 138,517 4,209,625 2006 Budget 1,548,955 113,401 6,045,926 527,538 3,614,929 1,030,680 162,800 13,044,229 552,000 o 5,179,282 54,360 380,455 197,800 1,175,680 453,500 5,029,508 21,644 13,044,229 1,891,272 1,658,901 o 6,045,926 1,597,657 527,538 129,455 1,030,680 162,800 13,044,229 91.6% 8.3% Unexpended Balance 843,298 107,589 5,545,390 229,138 1,418,425 666,481 24,283 8,834,604 381,335 o 4,828,239 50,000 281,211 59,283 755,002 34,209 2,459,568 -14,243 8,834,604 493,210 947,432 o 5,545,390 799,215 229,138 129,455 666,481 24,283 8,834,604 Completed Remaining Unexpended Percent 54.4 94.9 91. 7 43.4 39.2 64.7 14.9 67.7 69.1 93.2 92.0 73.9 30.0 64.2 7.5 48.9 -65.8 67.7 26.1 57.1 91. 7 50.0 43.4 100.0 64.7 14.9 67.7 12/14/2006 15:12:37 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 DEBT SERVICE Cur Mo Expended PROGRAM TOTALS 02 DEBT SERVICE - PROPERTY TAXES 03 DEBT SERVICE - TAX INCREMENT 04 DEBT SERVICE - H/R SALES TAX 1 05 DEBT SERVICE - H/R SALES TAX 2 06 SPECIAL SERVICE AREA B & I 979,379 147,838 881,824 o o Totals 2,009,041 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS SOURCE OF FUNDS 140 180 190 200 230 290 340 350 360 380 390 400 430 440 830 1,582,270 426,471 300 o Totals 2,009,041 SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. SSA #6 GEORGE/ALBERT B&I o 291,026 688,353 o o o 209,408 62,673 147,838 168,629 441,114 o o o o Totals 2,009,041 Y-T-D Expended 1,299,359 1,012,888 1,267,688 120,613 o 3,700,548 o o 2,478,383 1,081,589 3,450 137,126 3,700,548 o 387,053 912,306 o 16,513 840,400 214,265 65,645 155,975 494,950 492,828 o 80,810 39,803 o 3,700,548 21 2006 Budget 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 1,450,361 996,675 1,386,541 o o 3,833,577 o 2,605,398 1,223,979 4,200 o 3,833,577 151,000 387,053 912,308 o o 840,400 214,715 65,645 156,275 613,353 492,828 o o o o 3,833,577 151,002 -16,213 118,853 -120,613 o 133,029 o 127,015 142,390 750 -137,126 133,029 151,000 o 2 o -16,513 o 450 o 300 118,403 o o -80,810 -39,803 o 133,029 10.4 -1.6 8.6 3.5 4.9 11.6 17.9 3.5 100.0 0.2 0.2 19.3 3.5 12/14/2006 15,12,37 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 11 Months 1 Month 91. 6% 8.3% Completed Remaining Totals Cur Mo Y-T-D 2006 Unexpended Unexpended Expended Expended Budget Balance Percent 3,634 39,975 55,609 15,634 28.1 201,005 2,210,156 2,375,461 165,305 7.0 220,198 2,341,949 2,520,751 178,802 7.1 424,837 4,592,080 4,951,821 359,741 7.3 RETIREE PENSIONS PROGRAM TOTALS 01 MISCELLANEOUS PENSIONS 02 POLICE PENSIONS 03 FIRE PENSIONS EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES Totals 424,837 4,590,307 4,949,171 358,864 7.3 0 1,773 2,450 677 27.6 0 0 200 200 100.0 424,837 4,592,080 4,951,821 359,741 7.3 SOURCE OF 001 710 720 FUNDS GENERAL FUND POLICE PENSION FUND FIRE PENSION FUND Totals 3,634 39,975 55,609 15,634 28.1 201,005 2,210,156 2,375,461 165,305 7.0 220,198 2,341,949 2,520,751 178,802 7.1 424,837 4,592,080 4,951,821 359,741 7.3 22 12/14/2006 15:12:37 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 11 Months 1 Month 91.6% 8.3% Completed Remaining Totals Cur Mo Y-T-D 2006 Unexpended Unexpended Expended Expended Budget Balance Percent 80,333 1,115,487 1,325,485 209,998 15.8 380,685 4,159,619 5,031,695 872,076 17.3 461,018 5,275,106 6,357,180 1,082,074 17.0 RISK MANAGEMENT PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 1,000 460,018 1,000 5,274,106 43,500 6,313,680 42,500 1,039,574 97.7 16.5 Totals 461,018 5,275,106 6,357,180 1,082,074 17.0 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 461,018 5,275,106 6,357,180 1,082,074 17.0 Totals 461,018 5,275,106 6,357,180 1,082,074 17.0 23 12/14/2006 15:12:37 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 11 Months 1 Month 9l. 6% 8.3% Completed Remaining Cur Mo Y-T-D 2006 Unexpended Unexpended NON-DEPARTMENTAL Expended Expended Budget Balance Percent PROGRAM TOTALS 01 CONTINGENCIES 0 1,129,077 315,000 -814,077 -258.4 Totals 0 1,129,077 315,000 -814,077 -258.4 EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS o 1,129,077 315,000 -814,077 -258.4 Totals o 1,129,077 315,000 -814,077 -258.4 SOURCE OF 001 560 670 FUNDS GENERAL FUND STREET IMPROVEMENT CaNST FUND VEHICLE REPLACEMENT FUND 0 1,129,077 315,000 -814,077 -258.4 0 0 0 0 0 0 0 0 0 1,129,077 315,000 -814,077 -258.4 Totals 24 12/14/2006 15,12,37 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 CAPITAL FIXED ASSETS Cur Mo Expended Y-T-D Expended 2006 Budget Unexpended Unexpended Balance Percent 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 91.6% Completed 8.3% Remaining o o o o o o o o o o o o 12/14/2006 15,12:37 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/06 - 11/30/06 11 Months 1 Month 91.6% Completed 8.3% Remaining Totals Cur Mo Y-T-D 2006 Unexpended Unexpended Expended Expended Budget Balance Percent 0 0 8,113,291 8,113,291 100.0 0 0 8,113,291 8,113,291 100.0 MOUNT PROSPECT LIBRARY PROGRAM TOTALS 02 LIBRARY SERVICES EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES o o 8,113,291 8,113,291 100.0 Totals o o 8,113,291 8,113,291 100.0 SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND o o o 8,113,291 8,113,291 8,113,291 100.0 Totals o 8,113,291 100.0 26