Loading...
HomeMy WebLinkAbout3. BILLS & FINANCIALS 12/20/05 VILLAGE OF MOUNT PROSPECT CASH POSITION December 01 - 14, 2005 Cash & Invstmt Receipts Disbursements Other Cash & Invstmt Balance 12/01/05 Per Attached Credits/ Balance 12/01/05 12/14/05 List of Bills Debits 12/14/05 General Fund 6,637,125 1,445,881 867,533 7,215,473 Special Revenue Funds Refuse Disposal Fund 1,728,155 78,417 181,716 1,624,856 Motor Fuel Tax Fund 669,873 99,669 14,265 755,277 Local Law Enforcement Block Grant Fund 672 672 Community Development Blk Grant Fund (17,176) 18,928 29,507 (27,755) Asset Seizure Fund 59,559 59,559 DEA Shared Funds 53,443 53,443 DUI Fine Fund 17,193 17,193 Debt Service Funds 426,758 140,389 567,147 Capital Proiects Funds Capital Improvement Fund 1,775,046 89,100 31,852 1,832,294 Series 2003 Fund (870,052) (870,052) Downtown Redevelopment Const Fund 1,010,286 525 1,009,761 Street Improvement Construction Fund 619,676 79,133 698,809 Flood Control Construction Fund 887,537 887,537 Enterprise Funds Water & Sewer Fund 3,378,658 403,671 47,952 3,734,377 Village Parking System Fund 117,070 5,512 3,463 119,119 Parking System Revenue Fund 36,693 3,836 289 40,240 Internal Service Funds Vehicle Maintenance Fund 456,659 629 4,964 452,324 Vehicle Replacement Fund 5,483,288 9,275 5,474,013 Computer Replacement Fund 657,380 657,380 Risk Management Fund 2,475,104 49,499 70,837 2,453,766 Trust & Aaencv Funds Police Pension Fund 36,505,944 24,238 47,415 36,482,767 Fire Pension Fund 37,490,164 17,700 42,342 37,465,522 Flexcomp Trust Fund 22,805 9,605 9,364 23,046 Escrow Deposit Fund 1,267,607 68,405 15,508 1,320,504 100,889,467 2,534,612 1,376,807 102,047,272 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16 :28 RUN: .tlEDNESDAY DEC142005 16:56 RELEASE ID : PAGE 1 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 001 02919 303 CAB ASSOCIATION, INC. SENIOR TAXI RIDES 327.00 02955 ACME TRUCK BRAKE & SUPPLY CO. 5 BATTERIES 349.75 07730 ADVANCED PAVEMENT TECHNOLOGIES 2005 BRICK PAVER SEALING CONTR 10000.00 04594 AEC FIRE SAFETY SECURITY SERVI CECALL 156.25 01227 AIR ONE EQUIPMENT, INC. 3 Battery Assembly Repaired an 300.00 SHIPPING CHARGES 13.24 REFURBISHED ICM 2000 H/P 237 .50 ........--..------ 550.74 01335 ALEXIAN BROTHERS MEDICAL CENTR CPR CARDS 312.00 01561 AMERICAN CHARGE SERVICE SENIOR TAXI RIDES 90.70 08824 AMERICAN NATIONAL SKYLINE, INC. INTERIOR AND EXTERIOR WINDOW 1305.00 01699 AMERICAN PUBLIC WORKS ASSOC. OPEN HOOSE SUPPLIES 440.00 09389 ANDREIiS I DEANNA FREELANCE CAMERA FOR PARADE 100.00 01890 ANDRZEJEWSKI, ELEANORE D. TAX RELIEF GRANT 100.00 02001 ARAMARK UNIFORM SERVICES, INC. UNIFORM RENTAL/MECHANICS 100.80 07633 ARBOR GREEN, LTD INSTALLATION OF HOLIDAY LIGHTS 29161. 70 07785 ARNDT, JOHN REIMBURSE EXPENSES 219.52 09379 ASPIRE SPORTSliEAR MENTOR PROGRAM SHIRTS 1275.00 02261 ASSOCIATED ATTRACTIONS ENT. INC CONTRACTUAL CllRI STMAS DECOR 6150.00 05044 AVIS RENT A CAR SYSTEM TAC UNIT LEASE 730.99 02573 BAAS, liILL R. REBATE FOR 4 SQUARE OF PUBLIC 170.00 06287 BEDCO MECHANICAL REPAIRS TO PNEUMATIC THERMOSTA 1393.95 REPAIRS TO AIR HANDLER - PUBLI 557.90 REPAI~S TO CARRIER UNIT #4 - 111Q.25 .....................---- 3062 .10 09392 BEELER, SCHAD & DIAMOND IMF ESCROW 239857.70 08453 BELOW H2O Diving Dry Suit, Under garment 1499.00 07280 BERG, CHRISTOPHER REIMBURSE EXPENSES 24.00 02757 BESSE MEDICAL SUPPLY MEnI CAL SUPPLIES 711.96 09278 BOATER I S WORLD MARINE CENTERS 5 - Kent type I Life Vests 157.50 REPORT: APBOARDRPT GgNERATED: 20 MAR 05 16:28 RUN: WEDNESDAY DEC142005 16:56 PAGE 2 RELEASE 10 : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 .........-.... ......-...-..... -- --................... --..-......................... --......... --... --......... -............. --- -- -- -- --....... --........-........... --............................................ ----........ ......... ...--...-- -- ---- DEFT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ...... ..-----......-.. --- --.. --.. -.... --................. .....-- ....-..- -- -....... --.-.................. -_..-...... --..... --.. ---- ---.......... --... -- -- -..-............. --"''' --...................... -- --.. ---.. .............. 05774 BOUNDTREE CORP. 1 Pressure Cable 40.00 FREI GHT 4.27 --..--..-.....---- 44.27 02937 BOWEN ACE HARDWARE CO PADDLOCK 26.65 CABLE TIES & PLUMBING SUPP 3.77 ...-..--- ....-.. ...-- 3D .42 01009 BYRNE, WANDA TAX RELIEF GRANT 100.00 01035 CARNEY, MAUREEN PURCHASED GIFTS FOR COM.DEV. 132.59 OB251 CATENAZZO, JERRY J. TAX RELIEF GRANT 6B.53 01049 COW GOVERNMENT, INC USB SWITCHES 118 . 99 MS ISA SERVER STD 2004 - COW # 806.4B 1 LP600 XGA PROJECTOR STATION 1700.8 5 WINTERNALS ADMIN PAK III DONGLE 1431.01 SYMANTECGHOST - COW # 718502 2700. DO SYMANTEC GHOST 2ND YR EXT - CO 705. DO ADD'L CHARGE FREIGHT 30.99 BACKUP EXEC WIN 100 UPGRADES - 2655. DO ...-------.......... 1014B.32 09353 CHARTER RESEARCH GROUP,LTD. EVALUATION SAFETY TACTICS CLAS 750. DO 01088 CHIEF SUPPLY CORP. AA BATTERIES 34. B9 07377 CLARKE, PATRICK VACUUM BAGS, FILTERS 3UB 07954 CLEAVER CONSULTING WEB SITE REDESIGN 247.50 01118 CLERK OF THE CIRCUIT COURT PAYROLL FOR -12 080S 442.31 08865 CLOSED CIRCUIT INNOVATIONS I INC. MAIN! . AGREEMENT 427. DO 01148 COMMONWEALTH EDISON MUlIICIPAL STREET LIGHTING ACCT B720.0 5 D1l53 COMMUNITY CAB CO. SENIOR TAXI RIDES 1709.45 OmB DAHLBERG I JOHN REIMBURSE EXPENSES B1. 91 0126B DICKSON DICKSON TEMPERATURE DATA LOGGE 135. DO 0448B DIFRANCESCA, JANlNE H. TAX RELIEF GRANT 100.00 04042 DIGITAL COMBUSTION 1 Fire Studio 3.0 Upgrade 231.78 01276 DIRTBUSTERS AUTO DETAILING, INC. HAND IIAX 27 VEHICLES 8S0.00 01293 OOIiNERS GROVE FIRE DEPT Registration/z10 lIojcik, Dolan 300.00 09378 EBIA CAFETERIA PLANS 342. DO REPORT: APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: WEDNESDAY DEC142005 16:56 PAGE 3 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 -.o.- _____..... _.. __.......... __...... __.......... __ _o. _.. ___.. __ _.._..... __..... __ _........... .._........... ___.. __.. _____.... __...... ___ __.... __....... ____ __...... __ _.. __.... __ ___.. _..___..o._.. DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .....-.. ...........--.... ................................................... --- --- .......- .....-..... -...... ------- --- --- --............... --- -- --.... -- -..-.. -- -............. --- -- --...........-..-.... --..... ...-..- --- . . 06343 EDDINGTON, RICHARD REIMBURSE EXPENSES 82.00 01828 EL METENNANI, MAURA ON- LINE TRAININIG SUBSCRIPTION 59.00 05579 ELMHURST LINCOLN MERCURY REFINISH 2003 FORD VICTORIA 2041.30 01354 ENTENMANN-ROVIN CO. AWARD PINS 29.60 07496 EUL, KATHLEEN LODGING OW.MADISON EXPENSES 374.44 01366 EXPERIAN MINIMUM SERVICE CHARGE 5D.OO 08m FARACI ,ANTHONY & CINDY REAL ESTATE TAX REBATE 640.00 01377 FEDERAL EXPRESS CORP FEDEX PICK UP 52.94 B & F TECHNICAL PLAN REVIEII 31.90 FEDEX SHI PP ING 46.82 FED EX CHARGE 15.22 DELIVERY 18.09 .......-......---_...... 164.97 06311 FEDERAL SIGNAL- EMERG. PROD. REPAIR & LABOR FOR SPEAKER 332.16 00329 FELL, JUDITH B. REFRESIIMEIITS FOR NEIl RESIDENTS 29.45 00102 FIRE PENSION FUND PAYROLL FOR - 120805 17700.47 01422 FOLGERS FLAG & DECORATING, INC INSTALLATION CHRISTMAS BANNERS 577.50 01428 FOREMOST PROMOTIONS 400 KITCHEN SAFETY JAR GIPPERS 196.24 500 Printed Fire Safety Magnet 157.10 ............------- 353.34 04440 FRACASSI, LOUIS P. TAX RELIEF GRANT 90.54 01456 GABZDYL, BOZENA TAX RELIEF GRANT 75.92 01461 GALL'S, INC. REPLACEMENT BULBS 201.08 08154 GLOBAL EMERGENCY PRODUCTS PRIMING PUMP MOTOR 641.06 01504 GLUCZYNSKI, LEONA TAX RELIEF GRANT 91.04 03143 GRABE, JUNE M. TAX RELIEF GRANT 14.74 04448 GROSELAK, JUDITH R. TAX RELIEF GRANT 10D.OO 07356 HAACK, SCOTT & KIMBERLY EREAL ESTATE TAX REBATE 606.00 01549 HAINES & C(J4PANY INC. CHICAGO NEAR NORTH DIR & PKG C 301. 50 CHICAGO NEAR NORTH DIR &. PKG C 301.50 -.......--............... 603.00 REPORT: A~BOARDRPT GENERATED: 20 MAR 05 16:28 RUN: WEDNESDAY DEC142005 16:56 RELEASE 10 : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO TIlE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 --_....... -.. .........-_......... -- --..... --.................. --.. --........ -- --............ --.. -- -- -- --.. -.... -.. --.. --.. -- -.. -......... --........ ---........... ---...... --...... --................ -- ---- --.... --- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -- ---........ --.... -.. -........ --..... -_..-........ _..-- -- --..... -........ --.... -- --................. ---.. ......... -.... .....-........-.... --.............. -- --..-.. -- -- -........- ...--- ----.... ...... ................-.. 01559 HANSEN INFORMATION TECHNOLOGY QUARTERLY MAINT. 6964.00 09006 HAROLD WASHINGTON COLLEGE CAREER FAIR REGISTRATION 100.00 09205 HEALTH ENDEAVORS Medical Exams - Sworn Members 15800.00 Medical Exams - P.O.C. 's 5775.00 ADD'L CHARGE MEDICAL EXAMS 5.00 ------.......---- 21580.00 08431 HOPKINS MEDICAL PRODUCTS MEDICAL SUPPLIES 404.00 00106 lOO RETIREMENT TRUST - 401 PAYROLL FOR - 120805 850.00 EDD1NGTON 401K 373 .3 7 ------------- 1223.37 00107 lOO RETIREMENT TRUST - 457 PAYROLL FOR - 120805 15564.90 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 120805 21061.82 01680 ILLINOIS FIRE & POLICE COMM. ASSOC. REGISTER J . ARNDT FALL . SEMINAR 385.00 01122 ILLINOIS STATE DISBURSEMENT UNIT PAYROLL FOR - 120805 357.69 PAYROLL FOR - 120805 116.31 PAYROLL FOR - 120805 520.75 PAYROLL FOR - 120805 1169.98 ------......----- 2164.73 07433 lMAGETEC L P 2 BOXES OF STAPLES-POLICE 248.00 STAPLES 149.34 10#90133508733 275.75 10 #90132779607 219.42 10 #90132779607 100.00 ID #90132780238 638.84 ID #90133508731 345.89 ID '90133627542 169.00 10 190133420787 275.75 ------------- 2421. 99 07433 lMAGETEC LP ID#901327B0236 319.42 07694 INTERNATIONAL CODE COUNCIL, INC. IPMC COMMENTARY FOR HEALTIl DIV 38.25 IC 03 PERMIT TECH CERT EXAM 49.00 ----................... 87.25 00353 JANONIS, HI CHAEL E. REIMB-HOLIDAY RECEPT .11/29/05 273.74 RAFFLE PRIZES-EMF. LUNCHEON 413.75 LUNCH/MEETING 47.74 ------------- 735.23 06691 JUST TIRES TIRE MOUNTED & BALANCED FRONT 353.64 REPORT": APBOARDRPT GENERATED: 20 MAR 05 16: 28 RON: WEDNESDAY DEC142005 16:56 PAGE 5 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO TIlE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 ... ---...... --..- -_._--..- --......... -- --.............. -- --.... ---....- -.. -- ---..-_... -.......... --.......................- --- -----..-.... .....-- --...- -- _.- -- -......... --... -... ..--- --......... -............... -...... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .....-......-...... --..... --- -- --.... -- --...........-...... ....... -- -- -.. -.. ........... ----..............- -- -----...- -.. -...-.... -- -...-...-... -----...- ...-------............. --...... --........... -- --- --....... ---..- 01794 KALE UNI FORMS, INC. BODY ARMOR J.BEACH 525.00 09384 KDH BUILDERS INSPECTION BOND 400.00 01818 KERSTEIN, JUNE SUPPLIES 15.13 01825 KLEIN, CATHERINE TAX RELIEF GRANT 37.77 06231 KROLL, BILL SAFETY SHOE PURCHASE 125.00 01849 KUSTOM SIGNALS, INC. PARTS & LABOR 209.56 01856 LAGERHOLM, GLORIA TAX RELIEF GRANT 100.00 04436 LAKE, KAREN TAX RELIEF GRANT 100; 00 01861 LANDS' END BUSINESS OUTFITTERS IIORK SHIRT FOR J . HERNANDEZ 37.60 SHIRTS 221.45 .........---.....-..-- 259.05 05037 LASALLE BANK NA BANK CHGS- INTERNAL 23.22 08631 LECHNER AND SONS 2005 UNIFORM RENTAL AND CLEANI 363.71 01897 LIFE ASSIST 1 - Pro splint Case for Statio 37.50 LARYNGOSCOPE BULB, SMALL 9.48 FREIGHT 7.50 Holdsters, Back Boards 506.20 ..--......--......--... 560.68 00379 LINDELOF, CHARLES M. CLOTHING ALLOWANCE 53.98 01903 LOCKWOOD, BARBARA B. TAX RELIEF GRANT 100.00 09293 LOOPNET PREMIUM MEMBERSHIp.INDIVIDIUAL 514 .40 07267 LPS PAVEMENT CO. SIDEWALK REPAIRS 9715.00 01918 LUNDSTROM t S NURSERY, INC. 2005 TURF MOWING CONTRACT 1762.48 08267 MAGGI, BRIAN & LINDA REAL ESTATE TAX REBATE 790.00 05654 MAGNUSSEN, MIKE REGISTRATION FEE 695.00 LODGING, MEAL, TRANSPORTATION 375.15 ....--.......... -........- 1070.15 01941 MALCOLM, JOHN PORTABLE (J DEMAND STORAGE UN! 266.00 06004 MCDONALD'S CORPORATION PRISONER MEALS OCT. 2005 198.70 03090 MCKILLOP, ROBERT REIMBURSE EXPENSES 436.72 08894 MEETINGHOUSE COMPANIES. INC. HOLIDAY LIGHT INSTALLATION 4455.00 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16:28 RON: IiEDNESDAY DEC142005 16:56 PAGE 6 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 .... -.. ..---- --- ---.... ---..- --........ -- .. --.... --.......................... --.. ...............- --...... --.......... --..... ..--_.......... ..-......- ...---- ---...... -- --.... --.......... --...... -....- -- --- DEPT . VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT __.. __..... ........_ ___..... __.... __............._................... ___.... __..... __...._........... ____............ "'''00'' __.... __............... ___...... _.. __................ --.. -- -- --..-.....................-.. ...........- 09388 MEHTA, MALINI TAX RELIEF GRANT 100.00 09387 MENNA, FELICIA TAX RELIEF GRANT 100.00 01998 MESSMER r KATHARINA TAX RELIEF GRANT 97.74 00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 120805 1550.00 00117 METROPOLITAN ALLIANCE . POLICE PAYROLL FOR- 120805 735.00 06~43 MI CROSYSTEMS, INC. DOCUMENT PREP 3500.00 02017 MIDDLETON I JOAN BOOKS 121. 72 02046 MOBILE PRINT INC. CONTRACTOR CARDS 2006 99.08 08025 MORTON SUGGESTION CO. KEY CHAINS FOR CHRISTMAS PARAD 400.00 02066 MOUNT PROSPECT CHAMBER OF COMMERCE MEMBERSHIP DUES 2006 310.00 02067 MOUNT PROSPECT HISTORICAL SOC. 32 DIGITAL IMAGES OF HISTORlCA 64.00 2005 BUDGET ALLOCATION 3125.00 --.....- --.. ........... 3189.00 00123 NATIONWIDE MUTUAL INSURANCE COMPANY PAYROLL FOR - 120805 15581.32 04201 NELSON, ANINA REIMBURSEMENT/NELSON 18.11 02148 NEOPOST INC. UPDATED SOFTWARE FOR ELEC. SCAL 174.00 02170 NORTH EAST MULTI REGIONAL TRNG REGISTRATION 100.00 02189 NORTHWEST CENTRAL DISPATCH SYS JANUARY 2006 43294.48 JANUARY 2006 10823.62 ......--.......----- 54118.10 05124 NORTHWESTERN UNIVERSITY REGISrER-M.WEGER 1/9/06 725.00 REGISTER-ETERNO,SMITH,WEGER 2475.00 ......_................-.. 3200.00 02211 NURSING 2005 SIlBSCRIPTION RENEWAL NURSING 29.95 02228 OARTON PAVILLION HEALTHCARE HOME DELIVERED MEALS 1505.00 02229 OFFICE DEPOT 10 BOXES OF COPY PAPER 229.90 02235 OLESZCZUK, MARIA TAX RELIEF GRANT 85.87 08930 OTIS ELEVATOR C<x.lPANY ELEVATOR MAINTENANCE - 50 S EM 276.61 02256 PADDOCK PIlBLlCATIONS SUBSCRIPTION/FlGOLAH 37.60 DAILY HERALD AD 2519.00 ------..------ 2556.60 REPORT:' APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: WEDNESDAY DEC142005 16:56 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 PAGE DEPT VENOORNBR INVOICE DESCRIPTION --- --...- ........--- -- --...... ---..... ---... --..... --- --- -- - --... --........ -- ----... --..... -- -- -- -- ---................. -- --- --................ -- ---........ --......... -- -- --...... -- -- -- ---- ----- ......... AMOUNT VENDOR NAME ---.......... ....... -.. ........ -- ---..-_........ -- -...... -- --...... --........ --...... --............. --.. -... --......... --........ -- -- -.... --..... --... -...- ..--_..... ----... --- ---...... -............-..... -- -- -.........- -- -......... 02256 PADDOCK PUBLICATIONS, INC. TAX LEVY NOTI CE 02275 PATTERSON, PRISCILLA M. TX RELIEF GRANT 05026 PAYFORMANCE CORP. SDS BUSINESS EDITION ANNUAL SDDW32 ANNUAL MAINTENANCE 02303 PETTY CASH - FIRE. DEPT . MEETING TRNG SUPP MEETING TRNG SUPP MEETING TRNG SUPP MEETING TRNG SUPP MEETING TRNG SUPP MEETING TRNG SUPP MEETING TRNG SUPP MEETING TRNG SUPP 02315 PIONEER PRESS PIONEER PRESS SUBSCRIPTION 00124 POLICE PENSION FUND PAYROLL FOR - 120805 04921 POPE, ELIZABETH A. PAYROLL FOR - 120805 06661 PRIME OFFICE PROD. SUPPLIES 09391 PRlMECO/US CELLULAR STATEliIDE IMF ESCROW 02358 PRO-SAFETY, INC 3 Season Waterproof Jackets ADD I L CHARGE 08711 QUALITY 1 MAINTENANCE, IRC. 2005 CONTRACT FOR CUSTODIAL SE SUPPLIES .08573 RADEBAUGH, BARBARA & JEFF REAL ESTATE TAX REBATE 02393 RAY O'HERRON CO. BODY ARMOR-KADZIELAliSKI 09385 RHODE, DIANE REIMBURSE 02428 RIBANIJO, VIOLA K. TAX RELIEF GRANT 05559 ROADTECH MFG. IRC. TRAFFIC CONES 09169 ROB ROY GOLF COURSE lEMS MEETING 02008 ROGER MEYER TRUCKING CONTRACTUAL HAULING/DEBRIS CONTRACTUAL HAULING/DEBRIS 476.80 47.73 1500.00 350.00 1850.00 8.71 23.82 9.72 31.93 9.61 7.50 20.00 3.00 114.29 21.95 . 23973.44 923.08 188.56 21615.50 1945.00 156.00 210 1.00 8289.03 47.00 8336.03 686.00 624.25 44.72 96.32 345.00 31.25 3995.00 278.27 4273.27 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: IIEDNESDAY DEC142005 16:56 PAGE 8 RELEASE ID : VI LLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 ....-------.... --- --... --................. -- -- ........ -- --...... ......................- --........... -----...... ---........ --........ ...-..-.. -- --- --.. --- ---....-.. --....... --...... -- -- --..- -.........'" -.... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -- ---_.............- -- -- --.. --...... --.... --........ --.... --- ---.. -- --- -- -- ...--_.. --.... ........... --.... -- -- --..-- ----..... -......--... -- --...- -........ --.............. ----.... -- ..--.....- --'"' 09277 ROSEN, JUDY REIMBURSEMENT 60.00 01780 SBC PHONE SERVI CE 290.97 07529 SCHAMBACH SOFTWARE SOLUTIONS, INC. CONSULTING SERVICES 6650.00 ANNUAL MAINT. VEHICLE/DOG 450.00 ------------- 7100.00 09383 SCHNITTKER, JOHN REIMBURSEMENT 50.00 02524 SEARS COMMERCIAL ONE REPLACEMENT ICE MAKER WITH 50# 1107.86 00125 SEIU LOCAL 73 PAYROLL FOR - 120805 779.96 03803 SHORE GALLERIES, INC. AMMUNITION FOR RANGE 908.64 02559 SIRCHIE FINGER PRINT LABORATOR 4 PKGS.OF PLASTIC BAGS 68.67 02560 SISTER CITIES INTERNATIONAL ANNUAL DUES 615.00 09258 SOLES AND SPOKES WORKSHOPS REGISTRATION FEE FOR PAUL BURE 98.00 04454 ST. VIATOR HIGH SCHOOL POST PROM DONATION 200.00 08183 STATE SURPLUS PROPERTY REVOLVING FUND-FED LESO PROGRAM ANNUAL MEMBERSHI P 900.00 02660 SUBURBAN PRINTING 400 - Not Approved Stickers 40 112 . 00 00442 SZMERGALSKI, EDWARD RElMBURSE EXPENSES 84.00 02691 THOMPSON ELEVATOR INSPECTIONS ELEVATOR INSPECTlONS 2065.00 08854 THORNE, ONEIDA B. TAX RELIEF GRANT 100.00 09275 TOTAL SECURITY, INC. MOVE EQUIPMENT 120.00 02624 TREASURER, STATE OF ILLINOIS PIMS USER FEES 9960.00 08917 TRIPP, RALPH L. TAX RELIEF GRANT 100.00 02756 UNITED STATES POSTAL SERVICE WINTER 2006 NEWSLETTER 3242.78 05567 UNITED VISUAL, INC. EQUIPMENT MAINT. 294.00 EQUIPMENT MAINT. 225.00 REPAIR PF EQUIP 245.00 REPAIR OF PD/FD TRAINING 250.00 .--...--..--.....-- 1014.00 00127 UNITED WAY PAYROLL FOR - 120805 355.80 07860 UPS MISe .SHIPPING CHARGES 16.94 07860 UPS STORE MISC .SHIPPING CHARGES 10.63 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: WEDNESDAY DECl42005 16:56 RELEASE 10: PAGE VILLAGE OF MOUNT PROSPEct LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 ..~ --.. ---- --.. -- -- --......... ---.... --.. -.. ----.................... -_.... -- --.. -- --- --- --.. --.. --........ ---................ -........... -.... --...... --........ --........ -...... --..... -......-..---.... REPORT: APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: IIEDNESDAY IlEC142005 16:56 RELEASE In: PAGE 10 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 ......... --- -- ......- ~ --....... --.......... -- ---.......... --.... --... -----.... --.. --.... -- --.. --... --- ..-....... ..-...- ---- ----........ --............... --.... --....... -_....- --........-.... --......- --..... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT -... --.... .....- ---- --.. --........ ---............. --..... -.. ..-..... -- --........ --....... _..-...-.... -- -- --- --.... -- -- --.. -- -- --.. --.. ---.............. --................ --_......-........ -- ---.................. 09316 ANDERSON, JANET PHOTO FOR MENTOR CHILDREN 15.20 09381 AReO CONSTRUCTION REHAB-803 CEDAR LANE 18366.00 09214 C & J HOME IMPROVEMENTS REHAB-1928. YUMA LN 1275.00 01114 CLAYGROUND, INC. CDBG SUB-RECIPIENT CLAYGROUND 2500.110 05271 GEISER BERNER ERP-I05 SGEORGE (McELLIGATT) 3954.00 09317 MARTINO, CONNIE ART SUPPLIES - MENTOR PROG 8.47 03918 REAL ESTATE INDEX INC. 307 N ELM ORDER #Rl169870 65.00 1902 YUMA ORDER #Rl170083 65.00 124 N RUSSEL ORDER #Rl171659 65.00 623 S EDWARD ORDER#Rl173050 65.00 ......---------... 260.00 08955 REFLEJOS PUBLICATIONS SFR CONOTRACTORS AD 290.00 09277 ROSEN, JUDY MENTOR PROGRAM SUPPLIES 107093 09237 SLOAN, CLARE ROTARY BREAKFAST REIMBURSEMENT 105000 03657 T oZ. CONSTRUCTION & ROOFING INC. 106 E. LONNQUIST-RooF REPL 1500.00 08443 liINGS PROGRAM, INC 0 CDBG SUB-RECIPIENT 2ND QTR 562.50 CDBG SUB-RECIPIENT 3RD QTR 562.50 ...---..-------- 1125.00 TOTAL 29506.60 510 08695 2/90 SIGN SYSTEMS REPLACEMENT SIGN GARAGE DOOR 15.48 09346 BOSS DIAGliIN PROFESSIONAL DESKTOP 7800.00 01049 CDW GOVERNMENT, INC MS OFFICE PRO LICS - COli # 529 5110.02 MS XP PROFESSIONAL UPGRADE - C 1505.14 MS W2003 SVR STD - CDli # 48417 447.25 ---....---............. 7062.41 01163 CONCARE INC. SEAL PARKING GARAGE ELEVATOR 6837.28 CONCRETE SEALING OF PARKING DE 1300.00 ..-----...----- 8137 .28 09369 UNI PRESS SOFTliARE INC. FOOTPRINTS V7 STARTER PACK (HE 2996.25 FOOTPRINT V7 ADD' L FIXED AGENT 1492.50 FOOTPRINTS CIlSTOMER LIC - ITEM 1496.2 5 FOOTPRINT LDAP LINK - ITEM # 1496.2 5 ANNUAL MAINTENANCE 1346.63 SHIPPING 9.00 ..........-..........-.... REPORT": APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: WEDNESDAY DEC142005 16:56 RELEASE ID : PAGE 11 VILLAGE OF MOUNT PROSPEcr LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 -..... --.. --- -.. -... -. -----.. ---.......... --.. --........... --..... -............... --..... ....--..... ....... --...-.............. ---......... --- ---.. -- -- -- --..... --............. --..............-........ -...... -- --- -....... DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .. --... -- -.. -_...- ...... --... -- --...................... - -........... --.... ---.. ---.. -- --... --.. -.. -- -----........ --..-.... -- -- -........ ---.. -... -... -- -- --..-.._.. -_.........-....... ...--............... -- --............ 8836.8 8 TOTAL 31852.05 550 09281 CHRIS I LANDSCAPING, INC. STREETS CAPE " PLANT/BUSH 525.00 TOTAL 525.00 610 07730 ADVANCED PAVEMENT TECHNOLOGIES CLEAN SIDEWALK 1262.60 01620 AMERICAN LANDSCAPING INC. 2005 PARKWAY RESTORATION 2435.80 08425 FARNSWORTH GROUP DESIGN ENGINEERING FOR VFD 9500.00 01377 FEDERAL EXPRESS CORP COURIER CHARGES 1/1/05- 12/31 143.79 01559 HANSEN INFORMATION TECHNOLOGY HANSEN V7 SOFTWARE GIS INTEGRA 20071.94 08567 KRAWCZYK, ADAM REFUND 3.47 08631 LECHNER AND SONS 2005 UNIFORM RENTAL AND CLEANI 363.71 01918 LUNDSTROM'S NURSERY, INC. 2005 TURF MOWING CONTRAcr 190.13 01965 MARTAM CONSTRUCTION TRUCKING/MATERIALS WATER MAIN 376 9.0 8 02334 POSTMASTER UTILITY BILLING POSTAGE 5000.00 02008 ROGER MEYER TRUCKING CONTRACTUAL HAULING/DEBRIS 3152.00 08567 SKOLMOSKI, ROBERT REFllNIi FINAL WATER BILL 3.47 02655 SUBURBAN LABORATORIES I INC. MONTHLY COLLECTION OF WATER 60.00 04838 THIRD MILLENNIUM ASSOC. INC. UTILITI BILLING 1995.54 TOTAL 47951.53 620 08711 QUALITY 1 MAINTENANCE, INC. 2005 CONTRACT FOR CUSTODIAL SE 1771.95 02554 SIMPLEX GRINNELL EQUI PMENT MAINT. CONTRAcr 1691.50 TOTAL 3463.45 630 08711 QUALITY 1 MAINTENANCE, INC. 2005 CONTRACT FOR CUSTODIAL SE 288.69 TOTAL 288.69 660 07423 ALEXANDER EQUIP. CO., INC. PARTS 101.90 06468 BP GASOLINE 143.93 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: IiEDNESDAY DEC142005 16:56 RELEASE ID : PAGE 12 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FRa! DECEMBER 01 2005 TO DECEMBER 14 2005 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT .. -- --.. ...-.. --..... -- -- --........ --......... -- .......... -- -_........................-.............. ---- ---.... ---.. --.. -.......... -- ---.. --........ --...... -- --.......... --.............. --.. _.- -- ----.. --.. 04424 BRETT EQUIPMENT RUBBER MUD FLAP 258.64 01236 DAVE & JIM'S AUTO BODY, INC. FRONT WHEEL ALl GNMENT 35.00 05579 ELMHURST LINCOLN MERCURY COOLANT TEMPERATURE SENSOR 13.07 08705 GENUINE PARTS Ca4PANY -NAPA AUTO REPAIR PARTS NOV. 2005 518.19 01725 INLAND DIESEL,INC. TRANSMISSION FILTER KIT 290.00 01914 LUND INDUSTRIES, INC. LIGHT BAR,REPLACEMENT 213.93 06470 LYNCH AUTO GROUP - FORD FORb REPAIR PARTS 160.63 01990 MCMASTER-CARR SUPPLY CO. SUPPLIES 80.40 02018 MIDWAY TRUCK PARTS GOODYEAR BELT 108.52 02058 MORTON GROVE AUTOMOTIVE REBUILT STARTERS & ALTERNATORS 420.00 08184 SNAP ON "INDUSTRIAL SOCKET/SOLDRING GUN 313.40 02581 SOLVENT SYSTEMS INT I L. INC. SERVICE PARTS WASHER 1/1/05 - 98.55 04951 SUBURBAN ACCENTS INC. REPLACEMENT VEHI CLE DECALS 150.00 02684 TERRACE SUPPLY COMPANY GREEN GRINDING DISC 24 GRIT 118 . 77 02782 VALVOLlNE, INC. 2- AW32 VALVOLlNE HYDRAULIC 0 650.21 UNITRAC HYDRAULIC FLUID 803.44 ..-...._-.......---.. 145 3.6 5 05004 mIZON WIRELESS PAGER MESSAGING SERVICE 44.57 02861 lIEST S IDE TRACTOR SALES STABILIZER STREET PADS 441. 09 TOTAL 4964.24 670 09382 ADAMSON INDUSTRIES CORP. REPLACEMENT ANTENNA 230.55 09187 ARMADILLO TRUCK VAULT IRC. coounand Center/ Operation Cent 4995.00 Shipping 300.00 ADDITIONAL SHIPPING 41.48 ..--------.......- 5336.4 8 08904 ENVIRONMENTAL GROUP SERVICES, IRC. 2 Sensi t Gold and 4 gas meters 3185.34 02018 MIDIIAY TRUCK PARTS TRAILER RECEPTICAL 117.4 8 02491 SAUBER MFG. CO. 4 - 1" X 10' NYLON TY STRAP w/ 36.00 l'X 10 I NYLON TY STRAP Ii/RATC 44.00 2' X 5 I NYLON TY STRAP Ii/RATCH 56.00 2' X 20' NYLON TY STRAP Ii/RATC 84.00 FREIGHT 9.84 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16: 28 RON: i1EDNESDAY DEC142005 16:56 PAGE 14 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 -- --_:.... -- --.. --............... --......-........ - --.... -----.. -------.. --............ ---.. --.................. --...... --...... --.... -- -- --.. -- ---.... ....... --........ --.... --........ -- -- -... -- -...-- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ........- ---..... ..--.. --.. -- --.. --.......... --....... -- --- ----.. ----........................ -- --.. --.................... --............ -,_.......... --................. --...... --.. -- --............ ---- .......--.. ......... 01219 DAHLBERG, JOHN K. FLEX COMP 80.60 01241 DAWSON, HENRY C. FLEX COMP 71.53 01282 OIX, KENNETH S. FLEX COMP 202.00 00322 EISEN, BARRY FLEX COMP 520.00 05121 GHAWAL Y, HI CHARL FLEX COMP 566.97 {)0343 GUTIERREZ, JULIE M. FLEX COMP 493.00 00357 KADZIELAWSKI, RONALD FLEX COMP 868.50 01826 KLEIN, GARY FLEX COMP 450.49 0lB52 LABBE, ALAN L. FLEX COMP 703.75 02034 HI LLER, JAMES FLEX COMP 190.00 00399 MORGAN, NANCY FLEX COMP 224.58 Om5 PHENEGAR, DANE FLEX COMP 446.00 06040 REDLIN, RON FLEX COMP 212.40 02473 RUMORE, CINDY JO FLEX COMP 385.80 02635 STEWARD, DALE R. FLEX COMP 759.54 02828 WAGNER, JOHN R. FLEX COMP 285.00 02901 WULBECKER, JEFFREY A. FLELX COMP 220.00 TOTAL 9364.15 790 02945 BRISTOL COURT MAYOR I S PRAYER BREAKFAST - DEP . 300.00 08567 MALLIN I GREGORY OVERPAYMENT 50.97 08567 MILLER I STEVE OVERPAYMENT 4.94 02046 MOBILE PRINT INC. WINTER PARADE POSTERS 89.17 08567 MUNRO I EMMERSON OVERPAYMENT 5.49 08567 PETRONEC I RENE OVERPAYMENT 17.96 09390 THE KOHEN FOUNDATION DONATION IN HEM.OF VELMA LOWE 500.00 02689 THIRD DISTRICT CIRCUIT COURT BOND MONEY 850.00 BOND MONEY 1930.00 BOND MONEY 1025.00 BOND MONEY 1240.00 ...._---.........--...... REPORT: APBOARDRPT GEREIWED: 20 MAR 05 16:28 DEPT VENDOR NBR RUN: WEDNESDAY DEC142D05 16:56 RELEASE ID : VILLAGE OF MOUNT PROSPECT . LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 VENOOR NAME INVOICE DESCRIPTION PAGE 15 AMOUNT ........... ~__...................._........... ............ ....... ...... ..0......................................................_........................................... _,_..... ..._............. ................................... _................................ _.... _...._.... 5045.00 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 120905 INSPECTION TOTAL GRAND TOTAL 576.81 8917;50 9494.31 15507.84 1376806.21 REPORT: APBOARDRPT GENERATED: 20 MAR 05 16:28 RUN: WEDNESDAY DEC142005 16:56 REL&ASE 10 : PAGE 16 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM DECEMBER 01 2005 TO DECEMBER 14 2005 ............. ---.. -- --.... ----.. -----........ --............................ -_........ --.............................. --............ --.......................... --...... --........ -_............ --.... ---........................ SUMMARY BY FUND .. --...... --.................. --- ....................... -........................ --.................................................... ---........ --...... --.................................. --.. --.. --.... --........ -_.... --.... ---- 001 GENERAL FUND 867532.77 030 REFUSE DISPOSAL FUND 181716.06 050 MOTOR FUEL TAX FUND 14265.49 070 COMMUNITY DEVELPMNT BLOCK GRNT 29506.60 510 CAPITAL IMPROVEMENT FUND 31852.05 550 DOWNTOWN REDEVLPMNT CONST 525.00 610 WATER AND SEWER FUND 47951.53 620 VILLAGE PARKING SYSTEM FUND 3463.45 630 PARKING SYSTEM REVENUE FUND 288.69 660 VEHI CLE MAINTENANCE FUND 4964.24 670 VEHI CLE REPLACEMENT FUND 9274.69 690 RISK MANAGEMENT FUND 70836.57 710 POLICE PENSION FUND 47415.05 720 FIRE PENSION FUND 42342.03 770 FLEXCOMP ESCROW FUND 936 4.15 790 ESCROW DEPOSIT FUND 15507.84 -------- -- -..-- TOTAL : 1376806.21 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES November 1 - November 30, 2005 12/13/2005 16:42:58 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/05 11/30/05 Cur Mo Received REVENUE BY CLASSIFICATION PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES Total All Funds 3,880,752 2,138,428 158,623 918,911 1,603,717 40,806 357,536 12,176 956,498 402,500 10,469.947 REVENUE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 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 ESCROW DEPOSIT FUND 4,500,487 821,218 148,543 1 50,562 5,765 117 14 50,838 128,160 438,690 175,386 13,078 318,450 18,902 6,296 54,408 48,868 32,730 9,287 24,992 8,247 10,571 o 270,018 118,378 3,018 1,206,781 9,180 8,392 131,501 104,327 16,870 636,871 516,365 570,795 o 1 Y-T-D Received 11,199,980 11,484,090 2,929,646 11,101,034 15,771,149 528,166 4,299,382 413,897 4,292,174 3,216,692 65,236,210 29,069,039 3,127,958 1,454,878 58 431,547 9,954 1,428 20,627 145,100 370,905 1,076,010 511,241 36,293 880,867 133,691 44,589 151,018 347,925 231,246 66,564 181,325 59,964 266,504 o 1,839,584 1,160,871 26,929 8,226,347 95,510 95,041 1,311,815 1,070,820 165,966 5,797,451 3,401,103 3,394,518 o 11 Months 1 Month 2005 Budget 11,980,598 12,838,924 2,801,736 15,620,370 16,118,285 527,100 4,591,120 452,592 4,325,383 2,205,000 71,461,108 33,124,588 3,341,773 1,669,600 10,000 499,000 500 12,250 10,100 151,700 390,128 927,912 521,626 36,150 888,500 186,083 61,961 151,000 492,844 323,779 89,508 252,000 83,000 231,276 o 2,122,075 1,365,165 12,000 8,493,217 116,236 236,825 1,309,945 1,058,035 161,201 5,679,931 3,686,073 3,740,910 o 91.6% 8.3% Unreceived Balance 780,618 1,354,834 -127,910 4,519,336 347,136 -1,066 291,738 38,695 33,209 -1,011,692 6,224,898 4,055,549 213,815 214,722 9,942 67,453 -9,454 10,822 -10,527 6,600 19,223 -148,098 10,385 -143 7,633 52,392 17,372 -18 144,919 92,533 22,944 70,675 23,036 -35,228 o 282,491 204,294 -14,929 266,870 20,726 141,784 -1,870 -12,785 -4,765 -117,520 284,970 346,392 o Completed Remaining Unreceived Percent 6.5 10.6 -4.6 28.9 2.2 -0.2 6.4 8.5 0.8 -45.9 8.7 12.2 6.4 12.9 99.4 13 .5 **** * 88.3 -104.2 4.4 4.9 -16.0 2.0 -0.4 0.9 28.2 28.0 29.4 28.6 25.6 28.0 27.8 -15.2 13 .3 15.0 -124.4 3.1 17.8 59.9 -0.1 -1. 2 -3.0 -2.1 7.7 9.3 12/13/2005 16:42:58 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/05 - 11/30/05 11 Months 1 Month 91. 6% 8.3% Completed Remaining Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent SSA #6 GEORGE/ALBERT B&I 8,513 28,196 24,217 -3.979 -16.4 SERIES 2002 LIBRARY BND ESCROW 3,328 3,328 0 -3,328 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 10,469,947 65,236,210 71,461,108 6,224,898 8.7 2 12/13/2005 11 Months 91.6% Completed 16,43,26 1 Month 8.3% Remaining FRRBRR03 VILLAGE OF MOUNT PROSPECT SUM 021 Budget Revenue by Category within Fund Summary 01/01/05 11/30/05 Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent GENERAL FUND 40 PROPERTY TAXES 2,759,685 7,965,372 8,533,459 568,087 6.7 41 OTHER TAXES 710,145 6,272,066 6,855,967 583,901 8.5 42 LICENSES, PERMITS & FEES 155,313 2,692,367 2,569,500 -122,867 -4.8 43 INTERGOVERMENT REV. 725,076 9,335,135 13,272,415 3,937,280 29.7 44 CHARGES FOR SERVICE 60,664 677,860 769,431 91,571 11.9 45 FINES AND FORFEITS 35,200 499,154 505,000 5,846 1.2 46 INVESTMENT INCOME 27,357 150,577 156,000 5,423 3.5 47 REIMBURSEMENTS 9,033 207,994 285,116 77,122 27.0 48 OTHER REVENUE 18,014 171,839 177,700 5,861 3.3 49 OTHER FINANCING SOURCES 0 1,096,675 0 -1,096,675 TOTAL GENERAL FUND 4,500.487 29.069.039 33.124,588 4.055,549 12.2 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 734,630 2,122,527 2,266,973 144,446 6.4 44 CHARGES FOR SERVICE 80,511 960,527 1,044,800 84,273 8.1 46 INVESTMENT INCOME 5,874 43,814 30,000 -13,814 -46.0 48 OTHER REVENUE 203 1,090 0 -1,090 TOTAL REFUSE DISPOSAL FUND 821,218 3.127,958 3,341.773 213.815 6.4 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 143,284 1,384,921 1,647,100 262,179 15.9 46 INVESTMENT INCOME 2,116 26,627 20,000 -6,627 -33.1 47 REIMBURSEMENTS 3,143 43,330 2,500 -40,830 **** * TOTAL MOTOR FUEL TAX FUND 148,543 1,454.878 1,669.600 214,722 12.9 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 0 0 10,000 10,000 100.0 46 INVESTMENT INCOME 1 58 0 -58 TOTAL LAW ENFORCEMENT BLOCK GRANT 1 58 10,000 9,942 99.4 COMMUNITY DEVELPMNT BLOCK GRNT 43 INTERGOVERMENT REV. 50,551 268,578 449,000 180,422 40.2 46 INVESTMENT INCOME 11 281 0 -281 48 OTHER REVENUE 0 162,688 50,000 -112,688 -225.4 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT 50.562 431.547 499,000 67.453 13 .5 ASSET SEIZURE FUND 45 FINES AND FORFEITS 5,606 8,623 100 -8,523 **** * 46 INVESTMENT INCOME 159 1,331 400 -931 -232.8 TOTAL ASSET SEIZURE FUND 5.765 9,954 500 -9,454 ****.* DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 0 0 12,000 12,000 100.0 46 INVESTMENT INCOME 117 1,428 250 -1,178 -471.2 1 12/13/2005 16:43:26 FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund 01/01/05 11/30/05 Cur Mo Received TOTAL DEA SHARED FUNDS FUND 117 DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME o 14 TOTAL DUI FINE FUND 14 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME 50,398 440 TOTAL SERIES 1987A B&I, PW FACILITY 50,838 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 127,458 702 o TOTAL SERIES 2001 B&I, VILLAGE HALL 128,160 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 34,739 1,451 402,500 TOTAL SERIES 2003 B&I, VILLAGE HALL 438,690 SERIES 2002B B&I, PUBLIC BLDGS 40 PROPERTY TAXES 46 INVESTMENT INCOME 173,842 1,544 TOTAL SERIES 2002B B&I, PUBLIC BLDGS 175,386 SERIES 2002A B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 12,929 149 TOTAL SERIES 2002A B&I, TIF 13,078 SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 317,385 1,065 o TOTAL SERIES 1999 B&I, TIF 318,450 SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 18,405 497 TOTAL SERIES 1996A B&I, FLOOD 18,902 2 Y-T-D Received 1,428 20,389 238 20,627 143,106 1,994 145,100 367,748 3,157 o 370,905 98,062 5,124 972,824 1,076,010 503,165 8,076 511,241 35,477 816 36,293 870,944 9,923 o 880,867 131,012 2,679 133,691 11 Months 1 Month Summary 2005 Budget 12,250 10,000 100 10,100 151,500 200 151,700 389,628 500 o 390,128 121,912 1,000 805,000 927,912 517,126 4,500 521,626 36,050 100 36,150 885,000 3,500 o 888,500 185,583 500 186,083 91. 6% 8.3% unreceived Balance 10,822 -10,389 -138 Completed Remaining Unreceived Percent 88.3 -103.9 -138.0 -10,527 -104.2 8,394 -1,794 6,600 21,880 -2,657 o 19,223 23,850 -4,124 -167,824 -148,098 13,961 -3,576 10,385 14,056 -6,423 o 7,633 54,571 -2,179 52,392 5.5 -897.0 4.4 5.6 -531.4 4.9 19.6 -412.4 -20.8 -16.0 2.7 -79.5 2.0 573 -716 1.6 -716.0 -143 -0.4 1.6 -183.5 0.9 29.4 -435.8 28.2 12/13/2005 16:43: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/05 11/30/05 Cur Mo Received SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 6,135 161 TOTAL SERIES 1998A B&I, FLOOD 6,296 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 53,794 614 TOTAL SERIES 1998C B&I, TIF 54,408 IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME 48,868 o TOTAL IEPA FLOOD CONTROL LOANS B&I 48,868 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 32,091 639 TOTAL SERIES 2000 B&I, FLOOD CONTROL 32,730 SERIES 2002B B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 8,778 509 TOTAL SERIES 2002B B&I, FLOOD 9,287 SERIES 1998A B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME 24,992 o TOTAL SERIES 1998A B&I, STREET IMP. 24,992 SERIES 2002BB&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME 8,232 15 TOTAL SERIES 2002B B&I, STREET IMP. 8,247 CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES o 6,221 o 4,350 o TOTAL CAPITAL IMPROVEMENT FUND 10,571 3 Y-T-D Received 43,671 918 44,589 147,617 3,401 151,018 347,853 72 347,925 228,431 2,815 231,246 62,482 4,082 66,564 177,899 3,426 181,325 58,594 1,370 59,964 112,400 45,685 35,356 42,950 30,113 266,504 2005 Budget 61,861 100 61,961 150,000 1,000 151,000 492,744 100 492,844 323,579 200 323,779 88,508 1,000 89,508 252,000 o 252,000 83,000 o 83,000 112,400 15,000 78,876 25,000 o 231,276 Unreceived Balance 18,190 -818 17,372 2,383 -2,401 144,891 28 144,919 95,148 -2,615 92,533 26,026 -3,082 22,944 74,101 -3,426 70,675 24,406 -1,370 23,036 o -30,685 43,520 -17,950 -30,113 -35,228 Completed Remaining Unreceived Percent 29.4 -818.0 28.0 1.6 -240.1 -18 29.4 28.0 29.4 29.4 **** * 28.6 29.4 -308.2 25.6 29.4 28.0 29.4 27.8 -204.6 55.2 -71.8 -15.2 FRRBRR03 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/05 11/30/05 11 Months 1 Month 91.6% 8.3% Completed Remaining 12/13/2005 16,43,27 Cur Mo Received Y-T-D Received 2005 Budget Unreceived Balance unreceived Percent SERIES 2003 PROJECT FUND 46 INVESTMENT INCOME o o o o TOTAL SERIES 2003 PROJECT FUND o o o o DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 46 INVESTMENT INCOME 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES TOTAL DOWNTOWN REDEVLPMNT CONST 266,809 732,158 743,975 11,817 1.6 3,209 18,189 2,000 -16,189 -809.5 0 36,087 36,100 13 0 1,053,150 1,340,000 286,850 21.4 270,018 1,839,584 2,122,075 282,491 13.3 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 46 INVESTMENT INCOME 48 OTHER REVENUE TOTAL STREET IMPROVEMENT CONST FUND 115,070 902,522 1,124,715 222,193 19.8 1,500 226,349 225,000 -1,349 -0.6 1,808 17,250 15,450 -1,800 -11.7 0 14,750 0 -14,750 118,378 1,160,871 1,365,165 204,294 15.0 FLOOD CONTROL CONST FUND 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 0 0 0 0 3,018 26,929 12,000 -14,929 -124.4 0 0 0 0 3,018 26,929 12,000 -14,929 -124.4 TOTAL FLOOD CONTROL CONST FUND WATER AND SEWER FUND 41 OTHER TAXES 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES TOTAL WATER AND SEWER FUND 506,389 1,445,871 1,531,825 85,954 5.6 1,210 4,330 0 -4,330 686,603 6,655,291 6,892,392 237,101 3.4 12,509 86,441 54,000 -32,441 -60.1 0 0 0 0 70 34,414 15,000 -19,414 -129.4 0 0 0 0 1,206,781 8,226,347 8,493,217 266,870 3.1 VILLAGE PARKING SYSTEM FUND 42 LICENSES, PERMITS & FEES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL VILLAGE PARKING SYSTEM FUND 600 6,600 7,236 636 8.8 7,921 83,301 108,000 24,699 22.9 659 5,609 1,000 -4,609 -460.9 0 0 0 0 9,180 95,510 116,236 20,726 17.8 PARKING SYSTEM REVENUE FUND 42 LICENSES, PERMITS & FEES 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 0 0 0 0 0 0 129,455 129,455 100.0 8,297 93,717 103,250 9,533 9.2 95 1,324 4,120 2,796 67.9 0 0 0 0 4 12/13/2005 11 Months 91. 6% Completed 16:43:27 1 Month 8.3% Remaining FRRBRR03 VILLAGE OF MOUNT PROSPECT SUM 021 Budget Revenue by Category within Fund Swnmary 01/01/05 11/30/05 Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL PARKING SYSTEM REVENUE FUND 8,392 95,041 236,825 141,784 59.9 VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 130,245 1,302,445 1,302,445 0 46 INVESTMENT INCOME 1,256 9,370 7,500 -1,870 -24.9 48 OTHER REVENUE 0 0 0 0 TOTAL VEHICLE MAINTENANCE FUND 131,501 1,311,815 1,309,945 -1,870 -0.1 VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 88,303 883,035 883,035 0 46 INVESTMENT INCOME 16,024 123,855 115,000 -8,855 -7.7 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 63,930 60,000 -3,930 -6.6 TOTAL VEHICLE REPLACEMENT FUND 104,327 1,070,820 1,058,035 -12,785 -1.2 COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 14,921 149,201 149,201 0 46 INVESTMENT INCOME 1,949 16,765 12,000 -4,765 -39.7 TOTAL COMPUTER REPLACEMENT FUND 16,870 165,966 161,201 -4,765 -3.0 RISK MANAGEMENT FUND 44 CHARGES FOR SERVICE 526,252 4,965,772 4,865,731 -100,041 -2.1 46 INVESTMENT INCOME 3,392 35,503 20,000 -15,503 -77.5 47 REIMBURSEMENTS 0 91,130 50,000 -41,130 -82.3 48 OTHER REVENUE 107,227 705,046 744,200 39,154 5.3 TOTAL RISK MANAGEMENT FUND 636,871 5,797,451 5,679,931 -117,520 -2.1 POLICE PENSION FUND 46 INVESTMENT INCOME 112,911 1,823,523 2,002,000 178,477 8.9 48 OTHER REVENUE 403,454 1,577,580 1,684,073 106,493 6.3 TOTAL POLICE PENSION FUND 516,365 3,401,103 3,686,073 284,970 7.7 FIRE PENSION FUND 46 INVESTMENT INCOME 147,615 1,812,701 2,111,500 298,799 14.2 48 OTHER REVENUE 423,180 1,581,817 1,629,410 47,593 2.9 TOTAL FIRE PENSION FUND 570,795 3,394,518 3,740,910 346,392 9.3 ESCROW DEPOSIT FUND 46 INVESTMENT INCOME 0 0 0 0 TOTAL ESCROW DEPOSIT FUND 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 41 OTHER TAXES 8,406 27,493 24,117 -3,376 -14.0 46 INVESTMENT INCOME 107 703 100 -603 -603.0 5 12/13/2005 16,43,27 FRRBRR03 SUM 021 Budget Cur Mo Received Y-T-D Received 11 Months 1 Month 2005 Budget 91.6% 8.3% Unreceived Balance Completed Remaining unreceived Percent TOTAL SSA #6 GEORGE/ALBERT B&I 8,513 -3,979 -16.4 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME 3,328 TOTAL SERIES 2002 LIBRARY BND ESCROW 3,328 GENERAL FIXED ASSETS ACCT GP 47 REIMBURSEMENTS 49 OTHER FINANCING SOURCES TOTAL GENERAL FIXED ASSETS ACCT GP MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES TOTAL MOUNT PROSPECT LIBRARY FUND 6 28,196 3,328 3,328 o o o o o 24,217 o o o o 8,536,993 o 8,536,993 o o o o o -3,328 -3,328 o o o 8.536,993 100.0 8,536,993 100.0 . 12/13/2005 16:41:52 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/05 11/30/05 Cur Mo Expended Y-T-D Expended 11 Months 1 Month 2005 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 EXPENDITURE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1996B B&I, TIF SERIES 1998B B&I, TIF SERIES 1999 B&I, TIF SERIES 1996A B&I, FLOOD SERIES 1998A B&I. FLOOD SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND SERIES 2001 PROJECT FUND SERIES 2003 PROJECT FUND DOWNTOWN REDEVLPMNT CONST 1,753,674 1,245,640 31,063 405,865 1,342,338 29,152 532,202 123,215 16,591 8,700 70,361 11,359 27,854 75,599 3,214 250,267 2,303,230 469,749 900 402,500 9,103,473 3,727,474 473,624 47,366 o 21,212 o o o o 290,064 680,666 600,876 35,825 o o o 203,600 58,841 141,348 168,629 235,749 242,281 o o 79,881 o -261 46,913 1 19,611.838 7,423,820 252,948 4,321,887 12,183,356 320,321 5,705,163 1,034,527 347.031 16,670 217,498 279,243 973,861 342,017 653,290 2,879,132 3,216,858 1,233,431 4,650 1,024,102 62,041,643 30,520,515 3,207,992 1,820,148 769 444,423 o 30,420 26,199 o 390,128 911,931 610,051 36,650 o o 906,200 212,650 62,983 152,995 494,950 292,098 245,861 o o 230,000 o 56.011 360.242 22,311,518 7.812,307 339,313 4,746,868 13,622,838 539,816 6,401,091 1,138,334 448,577 21,030 505,305 346,085 1,339,635 566,500 1,248,188 3,979,016 3,344,867 1,315,860 6,000 805,000 70,838,148 33,989,385 3,634,727 2,186.672 o 746,973 7,000 1,000 1,000 67,000 390,128 911,932 610.051 36,650 o o 906,200 213,100 62,983 153,295 613,355 292,098 246,461 o o 665,914 o 22,000 291,064 2,699,680 388,487 86,365 424,981 1,439,482 219,495 695,928 103,807 101,546 4,360 287,807 66,842 365,774 224,483 594,898 1,099,884 128,009 82,429 1,350 -219,102 8,796,505 3,468,870 426,735 366,524 -769 302,550 7,000 -29,420 -25,199 67,000 o 1 o o o o o 450 o 300 118,405 o 600 o o 435,914 o -34,011 -69,178 12.1 5.0 25.5 9.0 10.6 40.7 10.9 9.1 22.6 20.7 57.0 19.3 27.3 39.6 47.7 27.6 3.8 6.3 22.5 -27.2 12.4 10.2 11.7 16.8 40.5 100.0 **** * **** * 100.0 0.2 0.2 19.3 0.2 65.5 -154.6 -23.8 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/05 11/30/05 12/13/2005 16:41:52 Cur Mo Expended Y-T-D Expended 2005 Budget 91.6% 8.3% Unexpended Balance Completed Remaining Unexpended Percent 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 SSA #6 GEORGE/ALBERT B&I GENERAL FIXED ASSETS ACCT GP GENERAL LONG-TERM DEBT ACCT GP Total All Funds 108,566 58,724 802,818 27,004 7,103 112,402 27,854 10,578 455,628 195,073 207,235 36,400 o o 9,103,473 1,083,298 243,029 7,822,417 173,289 137,350 1,162,886 973,861 180,348 4,937,560 2,105,829 2,170,760 37,800 o o 62,041,643 2 1,165,709 583,413 9,279,528 262,485 266,069 1,275,883 1,339,635 199,700 5,683,550 2,366,440 2,328,948 37,800 o o 70,838,148 82,411 340,384 1,457,111 89,196 128,719 112,997 365,774 19,352 745,990 260,611 158,188 o o o 8,796,505 7.1 58.3 15.7 34.0 48.4 8.9 27.3 9.7 13 .1 11.0 6.8 12.4 . 12/13/2005 16:44:43 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 NON-DEPARTMENTAL Cur Mo Expended 2005 Budget Y-T-D Expended PROGRAM TOTALS 00 ADMINISTRATION o o Totals o o EXPENDITURE CLASSIFICATION 72 INTEREST EXPENSE o o Totals o o SOURCE OF FUNDS 930 GENERAL LONG-TERM DEBT ACCT GP o o Totals 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 12/13/2005 16:44:44 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 11/30/05 11 Months 1 Month 91.6% 8.3% Completed Remaining Totals Cur Mo Y-T-D 2005 Unexpended Unexpended Expended Expended Budget Balance Percent 5,217 94,584 101,845 7,261 7.1 1,219 14,168 15,538 1,370 8.8 6,436 108,752 117,383 8,631 7.4 PUBLIC REPRESENTATION PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 03 ADVISORY BOARDS & COMMISSIONS EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES Totals 2,830 31,658 34,690 3,032 8.7 509 5,334 5,891 557 9.5 0 3,017 2,000 -1,017 -50.9 2,353 65,369 68,702 3,333 4.9 9 272 500 228 45.6 735 3,102 5,600 2,498 44.6 6,436 108,752 117,383 8,631 7.4 SOURCE OF FUNDS 001 GENERAL FUND 6,436 108,752 117,383 8,631 7.4 Totals 6,436 108,752 117,383 8,631 7.4 2 " 12/13/2005 16:44:44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 VILLAGE MANAGER'S OFFICE Cur Mo Expended PROGRAM TOTALS 01 VILLAGE MANAGER'S OFFICE 02 LEGAL SERVICES 03 PERSONNEL SERVICES 04 INFORMATION TECHNOLOGY 05 PUBLIC INFORMATION 32,181 32,313 16,512 79,873 7,738 Totals 168,617 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 57,087 18,884 2,624 89,270 245 507 o o Totals 168,617 SOURCE OF FUNDS 001 GENERAL FUND 168,617 Totals 168,617 3 Y-T-D Expended 411,851 277,124 176,550 618,745 99,967 1,584,237 627,226 206,487 16,997 689,929 4,072 10,152 29,374 o 1,584,237 1,584,237 1,584,237 2005 Budget 425,909 350,000 274,710 764,071 133,062 1,947,752 768,341 231,423 35,800 876,908 7,530 10,850 16,900 o 1,947,752 1,947,752 1,947,752 91. 6% 8.3% Unexpended Balance 14,058 72,876 98,160 145,326 33,095 363,515 141,115 24,936 18,803 186,979 3,458 698 -12,474 o 363.515 363,515 363.515 Completed Remaining Unexpended Percent 3.3 20.8 35.7 19.0 24.9 18.7 18.4 10.8 52.5 21.3 45.9 6.4 -73.8 18.7 18.7 18.7 12/13/2005 11 Months 91. 6% Completed 16,44,44 VILLAGE OF MOUNT PROSPECT 1 Month 8.3% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/05 - 11/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended TV SERVICES DIVISION Expended Expended Budget Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 9,855 150,176 167,850 17,674 10.5 04 INTERGOVERNMENTAL PROGRAMMING 3,123 38,125 45,907 7,782 17.0 Totals 12,978 188,301 213,757 25,456 11.9 EXPENDITURE CLASSIFICATION SO PERSONAL SERVICES 7,156 84,843 95,469 10,626 11.1 51 EMPLOYEE BENEFITS 3,314 35,033 36,767 1,734 4.7 52 OTHER EMPLOYEE COSTS 985 2,055 2,450 395 16.1 54 CONTRACTUAL SERVICES 1,258 7,535 11,471 3,936 34.3 55 UTILITIES 58 1,507 2,000 493 24.7 57 COMMODITIES & SUPPLIES 207 5,426 7,850 2,424 30.9 67 OTHER EQUIPMENT 0 51,902 57,750 5,848 10.1 Totals 12,978 188,301 213,757 25,456 11.9 SOURCE OF FUNDS 001 GENERAL FUND 12,978 188,301 213,757 25,456 11.9 Totals 12,978 188,301 213,757 25,456 11.9 4 . 12/13/2005 16,44,44 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 11 Months 1 Month 91. 6% 8.3% Completed Remaining VILLAGE CLERK'S OFFICE Cur Mo Expended Y-T-D Expended 2005 Budget Unexpended Balance Unexpended Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE 12,956 154,410 171,874 17,464 10.2 Totals 12,956 154,410 171,874 17,464 10.2 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES Totals 7,717 86,746 93,550 6,804 7.3 3,454 36,078 37,464 1,386 3.7 135 1,885 1,700 -185 -10.9 1,090 20,810 33,160 12,350 37.2 29 1,103 1,600 497 31.1 531 7,788 4,400 -3,388 -77.0 12,956 154,410 171,874 17,464 10.2 SOURCE OF FUNDS 001 GENERAL FUND 12,956 154,410 171,874 17,464 10.2 Totals 12,956 154,410 171,874 17,464 10.2 5 12/13/2005 11 Months 91.6% Completed 16,44,44 VILLAGE OF MOUNT PROSPECT 1 Month 8.3% Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/05 11/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended FINANCE DEPARTMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 16,454 214,513 214,409 -104 02 ACCOUNTING 34,216 360,354 408,087 47,733 11. 7 04 DUPLICATING SERVICES 0 0 0 0 05 INSURANCE PROGRAMS 51,725 525,680 530,277 4,597 0.9 06 CUSTOMER SERVICES 27,834 324,962 371,829 46,867 12.6 07 CASH MANAGEMENT 2,547 28,854 45,753 16,899 36.9 Totals 132,776 1,454,363 1,570,355 115,992 7.4 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 55,428 648,214 730,343 82,129 11.2 51 EMPLOYEE BENEFITS 22,895 246,192 262,358 16,166 6.2 52 OTHER EMPLOYEE COSTS 721 10,342 7,850 -2,492 -31.7 54 CONTRACTUAL SERVICES 3,982 61,186 70,450 9,264 13.1 55 UTILITIES 110 4,128 6,200 2,072 33.4 56 INSURANCE 46,647 466,474 466,474 0 57 COMMODITIES & SUPPLIES 2,349 15,137 24,680 9,543 38.7 65 OFFICE EQUIPMENT 644 2,690 2,000 -690 -34.5 Totals 132,776 1,454,363 1,570,355 115,992 7.4 SOURCE OF FUNDS 001 GENERAL FUND 132,776 1,454,363 1,570,355 115,992 7.4 Totals 132,776 1,454,363 1,570,355 115,992 7.4 6 . 12/13/2005 16,44,44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 COMMUNITY DEVELOPMENT Cur Mo Expended PROGRAM TOTALS 01 COMMUNITY DEVELOPMENT ADMIN 02 PLANNING & ZONING 03 ECONOMIC DEVELOPMENT 05 BUILDING INSPECTIONS 06 HOUSING INSPECTIONS 07 HEALTH INSPECTIONS 16,165 19,984 7,700 66,145 23,305 9,573 Totals 142,872 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 85,867 36,290 3,824 14,976 669 1,246 o Totals 142,872 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST 142,872 o Totals 142,872 7 Y-T-D Expended 182,658 186,329 65,586 670,683 262,293 105,526 1,473,075 944,435 382,754 17,483 100,957 11,937 13,263 2,246 1,473,075 1,472,275 800 1,473,075 2005 Budget 200,832 218,429 100,765 747,150 309,779 116,969 1,693,924 1,085,973 408,210 15,523 142,738 25,776 12,704 3,000 1,693,924 1,693,426 498 1,693,924 91. 6% 8.3% Unexpended Balance 18,174 32,100 35,179 76,467 47,486 11,443 220,849 141,538 25,456 -1,960 41,781 13,839 -559 754 220,849 221,151 -302 220,849 Completed Remaining Unexpended Percent 9.0 14.7 34.9 10.2 15.3 9.8 13.0 13 .0 6.2 -12.6 29.3 53.7 -4.4 25.1 13.0 13 .1 -60.6 13.0 12/13/2005 16:44:44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 COMMUNITY DEVELOPMENT - CDBG Cur Mo Expended PROGRAM TOTALS 04 CDBG ADMINISTRATION 05 CDBG COMMUNITY PROGRAMS 06 ACCESSIBLTY & NEIGHBRHD IMPRV 07 CDBG RESIDENTIAL REHAB 5,340 4,975 o 10,897 Totals 21.212 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 3,879 1,733 o 4,986 o 10,614 o o Totals 21.212 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 21,212 21.212 Totals 8 Y-T-D Expended 57,434 84,330 156,946 145,713 444.423 39,710 17,127 232 85,189 302 144,917 35,617 121,329 444.423 444,423 444.423 2005 Budget 71,623 109,000 268,350 298,000 746,973 65,463 21,275 1,075 126,415 1,395 263,000 55,850 212,500 746.973 746,973 746,973 91. 6% 8.3% Unexpended Balance 14,189 24,670 111,404 152,287 302.550 25,753 4,148 843 41,226 1,093 118,083 20,233 91,171 302,550 302,550 302.550 Completed Remaining Unexpended Percent 19.8 22.6 41. 5 51.1 40.5 39.3 19.5 78.4 32.6 78.4 44.9 36.2 42.9 40.5 40.5 40.5 "12/13/2005 16,44,44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 HUMAN SERVICES Cur Mo Expended PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 02 SOCIAL SERVICES 03 NURSING/HEALTH SERVICES 04 SENIOR CTR. LEISURE ACTIVITIES 05 YOUTH ACTIVITIES 13,472 28,032 35,684 2,133 -979 Totals 78,342 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 35,730 13,207 420 3,135 264 25,586 o Totals 78,342 SOURCE OF FUNDS 001 GENERAL FUND 78,342 Totals 78,342 9 Y-T-D Expended 142,018 289,804 162,804 30,089 o 624,715 398,119 139,707 2,567 45,525 5,464 33,124 209 624,715 624,715 624,715 2005 Budget 174,169 316,070 185,598 44,696 o 720,533 453,200 150,028 4,200 58,540 11,500 41,565 1,500 720,533 720,533 720,533 91. 6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 32,151 26,266 22,794 14,607 o 95,818 55,081 10,321 1,633 13,015 6,036 8,441 1,291 95,818 95,818 95,818 18.5 8.3 12.3 32.7 13.3 12.2 6.9 38.9 22.2 52.5 20.3 86.1 13.3 13 .3 13.3 12/13/2005 16:44:44 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 11/30/05 11 Months 1 Month 91. 6% 8.3% Completed Remaining Cur Mo Y-T-D 2005 Unexpended Unexpended POLICE Expended Expended Budget Balance Percent PROGRAM TOTALS 01 POLICE ADMINISTRATION 468,514 2,278,331 2,529,382 251,051 9.9 02 PATROL & TRAFFIC ENFORCEMENT 591,179 6,453,436 6,993,502 540,066 7.7 03 CRIME PREVTN & PUBLIC SERVICES 18,834 206,810 234,701 27,891 11.9 04 INVESTIGATIVE & JUVENILE PRGM 88,684 1,020,580 1,219,752 199,172 16.3 05 CROSSING GUARDS 2,567 20,632 27,575 6,943 25.2 06 EQUIPMENT MAINTENANCE 59,073 631,367 659,571 28,204 4.3 Totals 1,228,851 10,611,156 11,664,483 1,053,327 9.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 590,887 6,652,236 7,573,190 920,954 12.2 51 EMPLOYEE BENEFITS 497,686 2,499,021 2,593,654 94,633 3.6 52 OTHER EMPLOYEE COSTS 11,150 89,561 90,500 939 1.0 54 CONTRACTUAL SERVICES 114,140 1,200,823 1,242,191 41,368 3.3 55 UTILITIES 1,817 29,954 46,400 16,446 35.4 57 COMMODITIES & SUPPLIES 13,010 67,620 86,148 18,528 21. 5 65 OFFICE EQUIPMENT 0 2,593 1,150 -1,443 -125.5 67 OTHER EQUIPMENT 161 69,348 31,250 -38,098 -121.9 Totals 1,228,851 10,611,156 11,664,483 1,053,327 9.0 SOURCE OF FUNDS 001 GENERAL FUND 1,228,851 10,553,768 11,655,483 1,101,715 9.5 060 LAW ENFORCEMENT BLOCK GRANT 0 769 0 -769 080 ASSET SEIZURE FUND 0 0 7,000 7,000 100.0 085 DEA SHARED FUNDS FUND 0 30,420 1,000 -29,420 **** * 086 DUI FINE FUND 0 26,199 1,000 -25,199 **** * Totals 1,228,851 10,611,156 11,664,483 1,053,327 9.0 10 .12/13/2005 16:44:44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 FIRE Cur Mo Expended PROGRAM TOTALS 01 FIRE ADMINISTRATION 02 FIRE DEPARTMENT OPERATIONS 03 FIRE TRAINING ACADEMY 04 FIRE PREVENTION 05 FIRE COMMUNICATIONS 06 EQUIPMENT MAINTENANCE 07 EMERGENCY PREPARDENESS PRGM 08 PAID-ON-CALL PROGRAM 09 EMERGENCY ASSISTANCE PROGRAM 446,228 541,983 o 36,548 3,198 43,434 2,811 816 o Totals 1,075,018 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 509,556 500,385 6,605 36,146 1,865 14,922 21 137 5,381 Totals 1,075,018 SOURCE OF FUNDS 001 GENERAL FUND 1,075,018 Totals 1,075,018 11 Y-T-D Expended 1,860,656 5,660,624 3,853 420,728 46,819 444,321 17,631 15,384 35,559 8,505,575 5,553,182 2,283,344 62,312 411,458 32,896 105,484 4,600 1,814 50,485 8,505,575 8,505,575 8,505,575 2005 Budget 2,107,956 6,223,820 13,131 495,231 62,100 443,968 10,180 31,680 o 9,388,066 6,284,864 2,380,065 102,865 417,872 42,500 91,050 4,000 4,000 60,850 9,388,066 9,388,066 9,388,066 91.6% 8.3% Unexpended Balance 247,300 563,196 9,278 74,503 15,281 -353 -7,451 16,296 -35,559 882,491 731,682 96,721 40,553 6,414 9,604 -14,434 -600 2,186 10,365 882,491 882,491 882,491 Completed Remaining Unexpended Percent 11. 7 9.0 70.7 15.0 24.6 -0.1 -73 .2 51.4 9.4 11.6 4.1 39.4 1.5 22.6 -15.9 -15.0 54.7 17.0 9.4 9.4 9.4 12/13/2005 16,44,44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 PUBLIC WORKS - ADMINISTRATION Cur Mo Expended PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 96,705 96,705 15,846 10,268 2,513 67,188 617 273 o o 96,705 96,705 96,705 12 Y-T-D Expended 1,045,143 1,045,143 206,120 115,566 19,741 681,019 10,193 12,213 o 291 1,045,143 1,045,143 1,045,143 2005 Budget 1,104,481 1,104,481 230,282 119,906 29,545 685,268 18,490 13,915 6,500 575 1,104,481 1,104,481 1,104,481 91.6% 8.3% Unexpended Balance 59,338 59,338 24,162 4,340 9,804 4,249 8,297 1,702 6,500 284 59,338 59,338 59,338 Completed Remaining Unexpended Percent 5.4 5.4 10.5 3.6 33.2 0.6 44.9 12.2 100.0 49.4 5.4 5.4 5.4 '12/13/2005 16:44:44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 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 10,906 57,177 22,987 9,372 o 9,872 2,774 5,974 27,004 7,103 o Totals 153,169 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 63,272 24,495 27,898 4,788 1,981 3,059 o 287 o 27,389 o Totals 153,169 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 620 VILLAGE PARKING SYSTEM FUND 630 PARKING SYSTEM REVENUE FUND 119,062 o 27,004 7,103 Totals 153,169 13 Y-T-D Expended 121,232 684,372 393,239 385,501 o 132,280 57,959 92,245 173,289 137,350 o 2,177,467 976,641 304,077 494,968 21,224 19,808 212,061 o 701 o 147,987 o 2,177,467 1,693,349 173,479 173,289 137,350 2,177,467 2005 Budget 158,323 782,108 445,142 398,744 o 168,614 66,161 111,105 262,485 136,614 o 2,529,296 1,050,768 319,648 596,353 19,205 19,808 263,171 o 6,000 10,100 244,243 o 2,529,296 1,919,827 210,370 262,485 136,614 2,529,296 91.6% 8.3% Unexpended Balance 37,091 97,736 51,903 13,243 o 36,334 8,202 18,860 89,196 -736 o 351,829 74,127 15,571 101,385 -2,019 o 51,110 o 5,299 10,100 96,256 o 351,829 226,478 36,891 89,196 -736 351,829 Completed Remaining Unexpended Percent 23.4 12.5 11.7 3.3 21.5 12.4 17.0 34.0 -0.5 13.9 7.1 4.9 17.0 -10.5 19.4 88.3 100.0 39.4 13 .9 11.8 17.5 34.0 -0.5 13 .9 12/13/2005 16:44:44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 PUBLIC WORKS - FORESTRY/GRNDS Cur Mo Expended PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 02 MAINTENANCE OF GROUND 03 FORESTRY PROGRAM 04 PUBLIC GROUNDS BEAUTIFICATION 10,470 40,223 94,049 2,246 Totals 146,988 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT 43,098 16,922 1,280 84,749 939 o Totals 146,988 SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND 146,988 o Totals 146,988 14 Y-T-D Expended 169,359 447,161 628,713 36,200 1,281,433 631,547 200,538 2,223 417,351 21,823 7,951 1,281,433 1,281,433 o 1,281,433 2005 Budget 91.6% 8.3% Completed Remaining Unexpended Unexpended Balance Percent 202,791 434,492 766,261 44,449 1,447,993 659,194 205,772 3,350 546,437 24,440 8,800 1,447,993 1,433,793 14,200 1,447,993 33,432 -12,669 137,548 8,249 166,560 27,647 5,234 1,127 129,086 2,617 849 166,560 152,360 14,200 166,560 16.5 -2.9 18.0 18.6 11.5 4.2 2.5 33.6 23.6 10.7 9.6 11.5 10.6 100.0 11.5 . 12/13/2005 16,44,44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 11/30/05 PUBLIC WORKS - ENGINEERING Cur Mo Expended PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG 53,291 26,863 Totals 80,154 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 40,119 14,915 256 12,358 12,298 208 o o o Totals 80,154 SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 73,512 6,642 Totals 80,154 15 Y-T-D Expended 610,408 294,226 904,634 485,612 163,218 1,758 119,777 118,007 15,767 o 495 o 904,634 737,768 166,866 904,634 2005 Budget 702,066 625,001 1,327,067 560,670 175,489 5,100 200,548 196,380 17,270 500 1,500 169,610 1,327,067 916,577 410,490 1,327,067 91.6% 8.3% Unexpended Balance 91,658 330,775 422,433 75,058 12,271 3,342 80,771 78,373 1,503 500 1,005 169,610 422,433 178,809 243,624 422,433 Completed Remaining Unexpended Percent 13 .1 52.9 31.8 13.4 7.0 65.5 40.3 39.9 8.7 100.0 67.0 100.0 31.8 19.5 59.3 31.8 12/13/2005 16:44:44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 11/30/05 PUBLIC WORKS - WATER/SEWER Cur Mo Expended PROGRAM TOTALS 01 WATER & SEWER DIVISION ADMIN 02 MAINTENANCE OF BUILDINGS 03 MAINTENANCE OF GROUNDS 04 WATER SUPPLY MAINT & REPAIR 05 WATER DISTRBT MAINT & REPAIR 06 WATER VALVE/HYDRNT MAINT & REP 07 WATER METER MAINT & REPL 08 EQUIPMENT MAINTENANCE 09 SANITARY SEWER MAINT & REPAIR 10 WATER & SEWER SYSTEM IMPROV 12 LAKE MICHIGAN WATER SUPPLY 202,195 11,662 4,283 33,958 136,927 22,400 13,272 61,159 23,217 7,707 286,038 Totals 802,818 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 131,371 50,710 550 421,084 6,342 27,681 11,072 1,194 o 70,000 3,214 79,600 Totals 802,818 SOURCE OF FUNDS 610 WATER AND SEWER FUND 802,818 Totals 802,818 16 Y-T-D Expended 1,417,145 147,714 65,956 406,985 618,132 261,050 269,684 611,589 307,962 728,459 2,987,741 7,822,417 1,434,676 529,908 22,525 4,458,038 78,695 276,808 126,347 2,388 8,511 151,631 653,290 79,600 7,822,417 7,822,417 7,822,417 2005 Budget 1,663,809 168,464 84,534 522,659 737,969 302,796 313,319 611,589 496,389 1,303,000 3,075,000 9,279,528 1,686,400 574,345 32,370 4,736,166 159,775 276,808 168,186 13,500 13,335 266,425 1,248,188 104,030 9,279,528 9,279,528 9,279,528 91. 6% 8.3% Unexpended Balance 246,664 20,750 18,578 115,674 119,837 41,746 43,635 o 188,427 574,541 87,259 1,457,111 251,724 44,437 9,845 278,128 81,080 o 41,839 11,112 4,824 114,794 594,898 24,430 1,457,111 1,457,111 1,457,111 Completed Remaining Unexpended Percent 14.8 12.3 22.0 22.1 16.2 13 .8 13.9 38.0 44.1 2.8 15.7 14.9 7.7 30.4 5.9 50.7 24.9 82.3 36.2 43.1 47.7 23.5 15.7 15.7 15.7 . 12/13/2005 16:44:44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 PUBLIC WORKS - REFUSE DISPOSAL Cur Mo Expended PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 02 REFUSE LEAF REMOVAL PROGRAM 413,483 60,141 Totals 473,624 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 55,228 11,436 o 405,305 12 765 878 Totals 473,624 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 473,624 Totals 473,624 17 Y-T-D Expended 3,032,391 175,601 3,207,992 194,330 61,335 o 2,927,250 240 7,651 17,186 3,207,992 3,207,992 3,207,992 2005 Budget 3,446,873 187,854 3,634,727 216,953 66,276 1,685 3,320,897 560 7,651 20,705 3,634,727 3,634,727 3,634,727 91.6% 8.3% Unexpended Balance 414,482 12,253 426.735 22,623 4,941 1,685 393,647 320 o 3,519 426,735 426,735 426.735 Completed Remaining Unexpended Percent 12.0 6.5 11. 7 10.4 7.5 100.0 11.9 57.1 17.0 :1.1.7 11.7 11.7 12/13/2005 16:44:44 FRRDBROl SUM031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 PUBLIC WORKS - VEHICLE MAINT Cur Mo Expended PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 02 VEHICLE MAINTENANCE PROGRAM 11,605 100,797 Totals 112.402 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 48,218 18,376 o 5,433 29 40,346 o o o Totals 1.1.2.402 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 112,402 Totals 112.402 18 Y-T-D Expended 158,884 1,004,002 1.162.886 553,414 191,214 250 67,856 629 347,149 o o 2,374 1.1.62.886 1,162,886 1.162,886 2005 Budget 184,150 1,091,733 1.275.883 658,948 212,513 3,300 77,502 1,000 318,870 o 500 3,250 1.275.883 1,275,883 1.275.883 91. 6% 8.3% Unexpended Balance 25,266 87,731 112.997 105,534 21,299 3,050 9,646 371 -28,279 o 500 876 112.997 112,997 11.2,997 Completed Remaining Unexpended Percent 13.7 8.0 8.9 16.0 10.0 92.4 12.4 37.1 -8.9 100.0 27.0 8.9 8.9 8.9 . 12/13/2005 16,44,44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 COMMUNITY SERVICE PROGRAMS Cur Mo Expended PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 03 4TH OF JULY & CIVIC EVENTS,ETC 04 HOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM 5,473 693 19,931 207 Totals 26,304 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 385 161 13,628 o 7,347 4,783 Totals 26,304 SOURCE OF FUNDS 001 GENERAL FUND 26,304 Totals 26,304 19 Y-T-D Expended 86,564 95,907 28,223 2,323 213,017 63,129 6,887 116,951 o 19,842 6,208 213,017 213,017 213,017 2005 Budget 91,400 103,431 78,825 2,792 276,448 63,220 11,223 168,770 400 25,335 7,500 276,448 276,448 276,448 91. 6% 8.3% Unexpended Balance 4,836 7,524 50,602 469 63,431 4,336 51,819 400 5,493 1,292 63,431 63,431 63,431 Completed Remaining Unexpended Percent 5.3 7.3 64.2 16.8 22.9 91 0.1 38.6 30.7 100.0 21. 7 17.2 22.9 22.9 22.9 12/13/2005 16:44:44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 11/30/05 CAPITAL IMPROVEMENT PROJECTS Cur Mo Expended PROGRAM TOTALS 01 VILLAGE IMPROVEMENTS & EQUIP 02 COMMUNITY IMPROVEMENT PROJECTS 03 DOWNTOWN REDEVELOPMENT CONST 04 FLOOD CONTROL PROJECTS 06 STREET IMPROVEMENT PROJECTS 09 MOTOR EQUIPMENT REPLACEMENT 10 COMPUTER REPLACEMENT 70,110 9,510 46,913 58,724 149,290 27,854 10,578 Totals 372,979 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 32,859 o o 8,700 70,053 10,578 27,854 57 222,878 o Totals 372,979 SOURCE OF FUNDS 050 MOTOR FUEL TAX FUND 510 CAPITAL IMPROVEMENT FUND 525 SERIES 2001 PROJECT 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 40,724 79,881 o -261 46,913 108,566 58,724 o 27,854 10,578 Totals 372,979 20 Y-T-D Expended 235,578 50,433 359,442 243,029 2,395,277 973,861 180,348 4,437,968 207,135 o 193,518 16,670 176,580 231,806 973,861 7,540 2,609,816 21,042 4,437,968 1,479,803 230,000 o 56,011 359,442 915,474 243,029 o 973,861 180,348 4,437,968 2005 Budget 662,455 100,914 290,566 583,413 2,785,521 1,339,635 199,700 5,962,204 200,500 o 164,577 21,030 439,455 296,700 1,339,635 126,000 3,352,663 21,644 5,962,204 1,565,812 665,914 o 22,000 290,566 1,165,709 583,413 129,455 1,339,635 199,700 5,962,204 91.6% 8.3% Unexpended Balance 426,877 50,481 -68,876 340,384 390,244 365,774 19,352 1,524,236 -6,635 o -28,941 4,360 262,875 64,894 365,774 118,460 742,847 602 1,524,236 86,009 435,914 o -34,011 -68,876 250,235 340,384 129,455 365,774 19,352 1,524,236 Completed Remaining Unexpended Percent 64.4 50.0 -23.7 58.3 14.0 27.3 9.7 25.6 -3.3 -17.6 20.7 59.8 21. 9 27.3 94.0 22.2 2.8 25.6 5.5 65.5 -154.6 -23.7 21. 5 58.3 100.0 27.3 9.7 25.6 . 12/13/2005 16:44:44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 DEBT SERVICE Cur Mo Expended PROGRAM TOTALS 02 DEBT SERVICE - PROPERTY TAXES 03 DEBT SERVICE - TAX INCREMENT 04 DEBT SERVICE - H/R SALES TAX 1 05 DEBT SERVICE - H/R SALES TAX 2 06 SPECIAL SERVICE AREA B & I 1,571,606 177,173 909,100 o 36,400 Totals 2,694,279 EXPENDITURE CLASSIFICATION 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BANK AND FISCAL FEES 80 INTERFUND TRANSFERS 2,223,630 469,749 900 o Totals 2,694,279 SOURCE OF FUNDS 140 180 190 200 230 270 280 290 340 350 360 380 390 400 430 440 830 SERIES 1987A B&I, PW FACILITY SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1996B B&I, TIF SERIES 1998B B&I, TIF SERIES 1999 8&1, 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 290,064 680,666 600,876 35,825 o o o 203,600 58,841 141,348 168,629 235,749 242,281 o o 36,400 Totals 2,694,279 21 Y-T-D Expended 1,912,110 1,095,845 1,308,542 o 37,800 4,354,297 3.137,258 1,212,389 4,650 o 4,354,297 o 390,128 911,931 610,051 36,650 o o 906,200 212,650 62,983 152,995 494,950 292,098 245,861 o o 37,800 4,354,297 2005 Budget 1,979,111 1,096,145 1,427,997 o 37,800 4,541,053 3,240,837 1,294,216 6,000 o 4,541,053 67,000 390,128 911,932 610,051 36,650 o o 906,200 213,100 62,983 153,295 613,355 292,098 246,461 o o 37,800 4,541,053 91.6% 8.3% Unexpended Balance 67,001 300 119,455 o o 186,756 103,579 81,827 1,350 o 186,756 67,000 o 1 o o o o o 450 o 300 118,405 o 600 o o o 186,756 Completed Remaining Unexpended Percent 3.4 8.4 4.1 3.2 6.3 22.5 4.1 100.0 0.2 0.2 19.3 0.2 4.1 12/13/2005 16,44,44 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 11 Months 1 Month 91. 6% 8.3% Completed Remaining Totals Cur Mo Y-T-D 2005 Unexpended Unexpended Expended Expended Budget Balance Percent 3,557 47,131 54,630 7,499 13.7 195,073 2,105,829 2,366,440 260,611 11.0 207,235 2,170,760 2,328,948 158,188 6.8 405,865 4,323,720 4,750,018 426,298 9.0 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 405,865 4,321,887 4,746,868 424,981 9.0 0 1,092 2,950 1,858 63.0 0 741 200 -541 -270.5 405,865 4,323,720 4,750,018 426,298 9.0 SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FUND 720 FIRE PENSION FUND Totals 3,557 47,131 54,630 7,499 13.7 195,073 2,105,829 2,366,440 260,611 11.0 207,235 2,170,760 2,328,948 158,188 6.8 405,865 4,323,720 4,750,018 426,298 9.0 22 . 12/13/2005 16:44:44 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 11 Months 1 Month 91.6% 8.3% Completed Remaining Cur Mo Y-T-D 2005 Unexpended Unexpended RISK MANAGEMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 77,866 1,019,900 1,260,047 240,147 19.1 02 MEDICAL INSURANCE 377,762 3,917,660 4,409,303 491,643 11.2 Totals 455,628 4,937,560 5,669,350 731,790 12.9 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE 500 455,128 3,138 4,934,422 39,000 5,630,350 35,862 695,928 92.0 12.4 Totals 455,628 4,937,560 5,669,350 731,790 12.9 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 455,628 4,937,560 5,669,350 731,790 12.9 Totals 455,628 4,937,560 5,669,350 731,790 12.9 23 12/13/2005 16:44:44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 NON-DEPARTMENTAL Cur Mo Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 CONTINGENCIES 402,500 Totals 402,500 EXPENDITURE CLASSIFICATION 80 INTERFUND TRANSFERS 402,500 Totals 402,500 SOURCE OF FUNDS 001 GENERAL FUND 560 STREET IMPROVEMENT CONST FUND 402,500 o Totals 402,500 24 Y-T-D Expended 1,024,102 1,024,102 1,024,102 1,024,102 856,278 167,824 1,024,102 2005 Budget 805,000 805,000 805,000 805,000 805,000 o 805,000 91. 6% 8.3% Completed Remaining -219,102 -27.2 -219,102 -27.2 -219,102 -27.2 -219,102 -27.2 -51,278 -6.4 -167,824 -219,102 -27.2 < 12/13/2005 16,44:44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 CAPITAL FIXED ASSETS Cur Mo Expended Unexpended Percent PROGRAM TOTALS 00 CAPITAL FIXED ASSETS Totals EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES Totals SOURCE OF FUNDS 910 GENERAL FIXED ASSETS ACCT GP Totals 25 Y-T-D Expended 2005 Budget o o o o o o o o o o o o 91.6% 8.3% Unexpended Balance o o o o o o Completed Remaining o o o o o o 12/13/2005 16:44:44 FRRDBROl SUM 031 11 Months 1 Month VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 11/30/05 MOUNT PROSPECT LIBRARY Cur Mo Expended Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 LIBRARY SERVICES Totals EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES Totals SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND Totals 26 Y-T-D Expended o o o o o o 2005 Budget o 8,536,993 o 8,536,993 o 8,536,993 o 8,536,993 o 8,536,993 o 8,536,993 91. 6% 8.3% Completed Remaining 8,536,993 100.0 8,536,993 100.0 8,536,993 100.0 8,536,993 100.0 8,536,993 100.0 8,536,993 100.0