Loading...
HomeMy WebLinkAbout3. BILLS & FINANCIALS 7/15/03VILLAGE OF MOUNT PROSPECT CASH POSITION 9-Jul-03 General Fund Special Revenue Funds Refuse Disposal Fund Motor Fuel Tax Fund Community Development BIk Grant Fund Asset Seizure Fund DEA Shared Funds DUI Fine Fund Debt Service Funds Capital Proiects Funds Capital Improvement Fund Series 2001 Project Fund Series 2003 Fund Downtown Redevelopment Const Fund Street Improvement Construction Fund Flood Control Construction Fund Enterprise Funds Water & Sewer Fund Parking System Revenue Fund Internal Service Funds Vehicle Maintenance Fund Vehicle Replacement Fund Computer Replacement Fund Risk Management Fund Trust & A,qenc¥ Funds Police Pension Fund Fire Pension Fund Flexcomp Trust Fund Escrow Deposit Fund Cash & Invstmt Receipts Disbursements Other Balance 07/01/03 Per Attached Credits/ 07/01103 07109103 List of Bills Debits 8,096,754 991,035 488,738 2,109,286 50,953 29 1,202,646 122,646 156,854 70,105 14 28,951 48,757 60,776 18,014 2,223,022 231,657 1,800 2,151,505 105,594 963,338 25 186,595 12,141,284 683,317 636,832 17,285 3,391,335 30,222 412,105 1,562,378 4,274,495 194,832 48,509 490,195 4,488 10,414 396,695 12,542 5,236,188 214,565 472,166 2,228,754 37,766 4,776 31,265,908 469 33,284,781 375 27,716 67 3,939 1,173,573 16,572 19,726 113,526,503 1,680,277 2,396,583 Cash &lnvstmt Balance 07~09~03 8,599,051 2,160,210 1,168,438 41,168 48,757 60,776 18,014 2,452,879 2,045,911 776,768 ' 11,457,967 619,547 3,009,452 1,562,378 4,420,818 484,269 384,153 5,021,623 472,166 2,261,744 31,265,439 33,284,406 23,844 1,170,419 112,810,197 REPOT: APBOARDRPT GENERATED: 31 ~L 02 07:58 RUN: WEDNESDAY JUL092003 16:36 REL~SE ID : VIL~GE OF MOUNT PRosPEcT PAGE 1 LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 26 2003 TO JULY 09 2003 DER VENDOR NBR VENDOR NAME INVOICE DESCRI~TIUN AMOUNT 001 02012 AACE 04926 AIR CYCLE COKP 01246 AIRGAS NORTH CENTRAL 04546 ALPINE CAMERA CO. 01561 AMERICAN CHARGE SERVICE 05222 AMERICAN INDUSTRIAL 01620 kMERICANLANDSCA?ING INC. 07903 kMERICANOS 05082 AMG/AENC (12) 01830 ANDERSON ELEVATOR CO. 01840 ANDERSON PEST CONTROL 02001 ARAMA~ UNIFORM SERVICES, INC. 07057 ARLINGTONE$-SOUP KITCHEN QUARTET 02261 ASSOCIATED ATTRACTIONS ENT.INC 02270 AT & T 02270 AT&T DUES & MRMBERSHIPS 60.00 PICK UP AND DISPOSAL OF CRUSHE 375.00 OXYGEN TANK SUPPLIES 222.31 FII/q PROSESSING 45.22 SENIOR TAXI RIDES 145.90 UNIFORM RENTAL & CLEANING 118.03 4TH OF JULY PARADE 1500.00 NON DNTY iNJURY 135.00 MAINTENANCE OF PASSENGER ELEVA 170.4I AVITROL ON ROOF TOPS OF PUBLIC 66.25 UNIFORM RENTAL 97.20 4TH OF JIILY PARADE 200,00 4TN OF JULY PARADE 1400.00 ACCT#052 012 3141 001 11.95 ACCT#052 371 5848 001 4.I5 ACCT'052 371 5848 001 13.84 ACCT#052 371 5848 001 2.77 ACCT#052 371 5848 001 4.15 ACCT#052 371 5848 001 27.69 ACCT#052 371 5848 001 13.84 ACCT#052 371 5848 001 52.61 ACCT,052 371 5848 001 13.84 ACC7#052 371 5848 001 20.77 ACCT#052 371 5848 001 36.00 ACCT#052 371 5848 001 11.08 ACCT#052 371 5848 001 11.08 ACCT#052 371 5848 001 49.84 ACCT#052 371 5848 001 281.05 ACCT#052 371 5848 001 275.52 ACCT#052 371 5848 001 177.2I ACCT#052 377 1810 001 51.65 1059.04 ACCT#020 724 4120 002 0.98 ACCT#U20 724 4120 002 3.27 ACCT#020 724 4120 002 0.65 ACCT#020 724 4120 002 0.98 ACCT#020 724 4120 002 6.54 ACCT#020 724 4120 002 3.27 PARKWAY RESTORATION 299.00 P, EPORT: AREOARDRPT GENE~TED: 31 JUL 02 07:58 RUN: WEDNESDAY ~L092003 16:36 PAGE 2 REL~SE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO TEE BOARD OF TRUSTEES FROM JUNE 26 2003 TO ~JLY 09 2003 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ACCT#020 724 4120 002 12.43 ACCT#020 724 4120 002 3.27 ACCT#020 724 4120 002 4.91 ACCT#020 724 4120 002 8.51 ACCT#020 724 4120 002 2.62 ACCT#020 724 4120 002 2.62 ACCT#020 724 4120 002 tl.78 ACCT#020 724 4120 002 66.41 ACCT#020 724 4120 002 65.10 ACCT#020 724 4120 002 41.88 235.22 05044 AVIS RENT A CAR SYSTEM TAC UNIT LEASE 788.49 02405 B & H PHOTO/VIDEO UPGRADE XPRESS DV BASE 1/2/3 T 299.95 BORIS FX6.1 & GRAFFITI 2.1 UPG 399.95 SHIPPING 25.20 725.10 02579 BATTERY ZONE, INC. LAPTOP BATTERIES FOR FIRE 537.00 SNIPPING 7.00 544.00 06287 BEDCO MECHAMNICAL REPAIRS TO ROOFTOP CARRIER UNI REPAIRS TO COOLING TOWER - VIL REPAIRS TO CAREIER ROOF-TOP UN 179.50 2280.00 297.40 2756.90 07906 BEFORE & AFTER MAGAZINE DESIGN MAGAZINE 36.00 05051 BLUE SAINTS 4TH OF JULY PARADE 1480.00 00468 BOLIN, ~LtE A. RELMBURSEMEMT 198.69 07794 BRESSIE, WILLIAM REBATE FOR 3 SQUARES OF PUBLIC i20.00 0101I C4 IMAGING SYSTEMS, INC. TONER CARTRIDGE FOR 3035 PLAN 430.00 FREIGHT 5.57 435~57 05268 CADN INDUSTRIES JAMES RIVER BIG FOLD TOWELS 988.50 GEORGIA PACIFIC 2 PLY T.P. 340.00 MAIN STREET ROLL TOWELING I83.00 LONG SHOT BEE & WASP sPRay 64.00 JOI GLASS CLEANER 88.00 MR. FOAMY 104.00 3-M SCRUB & SPONGES 52.00 DAILY CLEANER 38.00 CO~ENTCLEANSER 28.00 24OZ - MOPHEADS 58.00 1943.50 RELEASE ID : VILLARE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 26 2003 TO JULY 09 100~ .... ~ DE~T VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 01518 CANON BUSINESS SOLUTIONS-CENTRAL 06150 CASHMAN, JOHN R. 01046 CAVALIERS DR~M & BUGLE CORP. 01049 CDW GOVEEW~ENT, INC 05375 CENTURY CLEANERS 07904 CHICAGO AND DISTRICT JR.PIPE BAND 01077 CHICAGO CO~4. SERVICE, INC. 01088 CHIEF SUPPLY CORP. 07281 CL GRAPHICS, INC. 01118 CLERK OF THE CIRCUIT COURT 01138 COLLEGE OF DUPAGE 07852 COMCAST 01147 CO}~ONWEALTH EDISON 01163 CONCANE INC. 07915 COPPOk~, DENISE 05574 COSTELLO, ELAINE 06411 DACRA 07888 DAYDOTS 01279 DISTINCTIVE BUSINESS PRODUCTS MICRO LABOR ON MICRDPRiNTER 108.00 SUBSCRIPTION 47.00 4TH OF JULY PARADE 3000.00 BROTHER LASER FAX MFC-4800 269.00 BROTBER IASER FAX TONER 100.00 SIMPLE 6 IN ONE USB FLASH CARD 70.00 PINNACLE STUDIO NVVER 8 85.00 CDW ELECTRONIC COUPON 100.00- KODAK PHOTOLIF~ NINN BATTERIES 15.75 SHIPPING 14.99 454.74 ~NI~OR~ CLEANING 102.80 4TM OF JULY PARADE 800.00 P~EMOVAL AND INSTALL OF RADIOS 1074.52 AA BATTERIES 18.72 PRINTING NEWSLETTER 8234.00 PAYROLL FOR - 062603 700.00 PAYROLL FOR - 062603 300.00 1000.00 REGISTER E.SZMERSALSKI 550.00 INTERNET SERVICE 45.95 12 W NORTHWEST HIGHLY #447576 31.81 PATON AND SEAL (3) TRENCH DRAI 2980.00 STRIP AND SEAL FLOOR WITH NON- 2235.00 5215.00 REAL ESTATE TRANSFER TAX REBAT 700.00 EXERCISE CLASS Sb~ER SESSION 460.00 DATABASE PROG~ING 1540.00 T~PERATURE SENSOR LABEL 45.36 MAINT~ANCE AGREEMENT 874.00 TASHIBACOPIER~AINT. 234.50 TASHtBACOPIER~INT. 234.50 1343.00 REPORT: APBOARDRPT GENERATED: 31 JUL 02 07:58 RUN: WEDNESDAY JUL092003 16:36 PAGE 4 ~ELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 26 2003 TO JULY 09 2003 DE~T VENDOR NBR VENDOR NANE INVOICE DESCRIPTION AMOUNT 07909 DUNN, THOMAS SUPPLIES 25.40 01313 DUPAGE TOPSOIL INC. 3 SEMI LOADS OF PULVERIZED TOP 260.28 3 SEMI LOADS OF PULVERIZED TOP 309.72 570.00 07907 DYCNAMGEO, REYNALDO O~RPAYWENT 12.00 01320 DYNAMIC GRAPHICS,INC. ADVANCED DESIGN 595.00 01328 EL-COR INDUSTRIES, INC. REPAIR PARTS 344.02 01342 EMERGENCY MEDICAL PRODUCTS PS- 15" CA~ING CASE 45.00 05154 EMSAN CHICAGO/MILWAUKeE REPAIR OF AMBULANCE 12 COT 489.71 01369 FAINVIEW PRINTING SERVICE BUILDING DIVISION FILE FOLDERS 379.00 01372 FASTFREAK, FREESTYLE TRICK TEAM 4TN OF JULY PARADE 475.00 01374 FAWLEY AND ASSOC. PASSPORT TAGS i71.60 00329 FELL, JUDITH B. REIMBURSEMENT 37.06 05341 FIRE INVESTIGATORS STRIKE FORCE MEMBERSHIP 40.00 00102 FIRE PENSION FOND PAYROLL FOR - 062603 14650.55 VOID PR FOR - 062603 205.47- PAYROLL FOR - 062703 222.60 14667.68 01422 FOLGERS FLAG & DECORATING, IWE SETS OF BANNER HARDWARE i134.00 INSTALL OF 4TH OF JULY BANNERS 805.50 1939.50 07914 GADOW, KAREM & DA~IE5 REAL ESTATE TRANSFER TAX RSBAT 860.00 05989 GAREIS, JOSEPH REIMBURSE EXPENSES 30.00 01469 GATEMAY COMPANIES INC. Seagate 36G Drive 518.00 07691 GLOBAL INDUSTRIAL EQUIPMENT 2' X 12' ANTI-FATIGUE ~TS 396.27 01522 GRAINGER INC. TAPER PIPE 64.31 01610 HOME DEPOT CRC/GECF RATCHET TIES 25.41 01622 HOWELL TRACTOR & EQUIPMENT CO. 5/8" X 8" X I0 PLOW BLADES 660.00 07916 HUFFMJ%~ ENTERPRISES, INC. ~EE FOR DIDC PROFILE TESTS 500.00 00106 ICMA RETIREMENT TRUST - 401 PAYROLL FOR - 062603 400.00 ICMA 401 PLAN 346.87 REPORT: APBOARERPT GENERATED: 31 JUL 02 07:58 ~UN ~D~DAY ~L092003 16:36 PAGE 5 REL~SE ID : VILLAGE OF MOUNT P~OSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUST~ES FRO~ JUNE 26 2003 TO JULY 0'~ ~ ...... ~"'= DEPT VENDOR WBR VENDOR NAME I~OICE DESCRIPTION AMOUNT 746.87 00107 ICMA RETIRF/4ENT TRUST - 457 PAYROLL FOR - 062603 14217.59 VOID PR FOR- 062603 69.23- PAYROLL FOR - 062703 69.23 14217.59 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL POR - 062603 18603.88 VOID PR FOR - 062603 56.50- PAYROLL FOR - 062703 62.88 18610.26 01691 ILLINOIS GMIS GMIS CONFERENCE 175.00 00109 ILLINOIS h'UNICIPAL RETIRRMRNT PAYROLL FOR - 062603 437.00 01122 ILLINOIS STATE DISBURSEMENT U~IT PAYROLL FOR - 062603 357.69 PAYROLL FOR - 062603 195.50 PAYROLL FOR - 062603 116.31 PAYROLL FOR - 062603 520.75 1190.25 07433 IMAGETEC L P STAPLES FOR INTERNAL STAPLER 90.15 07433 I~GETEC LP PAYmENT/INSTALLMENT 319.42 LEASE PAYMENTS FOR COPIERS 638.84 958.26 01725 INLAND DETROIT DEISEL-ALLtSON OIL SAMPLE KITS I01.10 01753 IPELRA REGISTRATION 50.00 01772 JESSE W~ITE T~BLERE 4TH OF JULY PARADE 850.00 01783 JOURNAL & TOPICS NEWSPAPERS PRINTING OF TREASURERS REPORT 460.00 06691 JUST TIRES NEW TIRES MOUNTED & BALANCED 907.82 01794 KALE UNIFORMS, INC. UNIFORM SUPPLIES CSO MC KILLOP 336.75 06100 KEANE, JOHN EMERGENCY RESPONSE 50.49 06025 KIRBY, MAUREEN ' REIMBURERMENT FOR CDL RENEWAL 50.00 01827 KLEIN, THORPE AND JENKINS,LTD. LEGAL SERVICES 26416.90 05336 KLEINSTEIN, HOWARD REImBURSEmENT 96.47 04590 K~TZMER, ROBERT P. CLASS SESSION 360.00 07297 LAKE COOK LAND SURVEY BUSINESS CE,~TER DRIVE SURVEY 372.00 02960 LAKE COUNTY MOUNTED POSSE 4TH OF J~LY PARADE 350.00 REPORT: APBOARDRPT GENERATED: 31 JUL 02 07:58 RUN: WEDNESDAY JUL092003 16:36 PAGE 6 RELEASE ID : VILLAGE OF MOUNT RROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 26 2003 TO JULY 09 2003 DE~T ~NDON NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 01861 LANDS' END CORPORATE SALES WORK SHIRTS 225.45 01872 LATTOF CHEVROLET, INC. SAFETY INSPECTIONS 63.00 05678 LEIB, JASON REIMBUREF/~ENT FOR OBTAINING CD 50.00 05176 LIBERTY Fk~G & SPECIALTY CO. FLOAT DECORATING SUPPLIES FOR 439.90 FRT. 14.95 454.85 01897 LIFE ASSIST OXYGEN SUPPLIES -GASKETS LOCKS 220.00 01914 LUND INDUSTRIES, INC. 1 MAGLITE AND CHARGER 89.95 01972 MASTER HITCH, INC. TRAILER HITCH PANTS 165.55 00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 062603 1225.00 VOID PR FOR - 062603 25.00- PAYROLL FOR - 062703 25.00 1225.00 00117 METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - 062603 604.00 07895 MID CITY PLUMBING RE,ND PLOMBING FEE 33.00 02046 MOBILE PRINT !NC. BUSINESS CARDS-BRIAN WILK 27.00 BUSINESS CARDS-CSO FLORES 54.00 81.00 06142 MODEL "A" RESTORERS CLUB 4TN OF ~LY PARADE 450.00 02067 MOUNT PROSPECT HISTORICAL SOC. 2003 BUDGET ALLOCATION 3166.67 06003 MT.RKOSPECT PARK DISTRICT 4TH OF JULY PARADE 350.00 07913 MYK, JENNIFER REAL ESTATE TRANSFER T~X REBAT 660.00 00123 NATIO~IDE PAYROLL FOR - 062603 15857.57 VOID PR FOR - 062603 238.46- PAYROLL FOR - 062703 238.46 15857.57 07905 NEW GENERATION FANCY DRILL TEAM 4TN OF JULY PARADE 1500.00 02155 NEXTEL CO~9~UNICATIONS ACCT#136720519 145.92 ACCT#157600518 587.15 ACCT#157600518 342.46 ACCT#432030512 337.85 ACCT#684010511 871.39 ACCT~684010511 120.00 ACCT#684920512 429.06 ACCT#741030517 71.5I RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRU~TRES FROM J'~E 26 2003 TO J'JLY 09 2003 ON~T ~HDOR NBR VENDOR NAME IRVOICE DESCRIPTION AMOUNT ACCT'7413305!0 215.20 ACCT9964640517 85.49 3206.03 02170 NORTH EAST ~LTI REGIONAL T~G MEMBERSHIP FEES 6970.00 02189 NORTHWEST CENTRAL DISPATCH SYS SERVICES RENDERED-AUGUST 37054.94 SERVICES RENDERED-AUGUST 9263.73 46318.67 02229 OFFICE DEPOT OFFICE SUPPLIES 82.62 07863 PACON CORPORATION ~LOAT DECORATING SUPPLIES FOR 414.40 ~?,EIGHT 71.68 486.08 07908 PATEL, A~VINDBHAI R. REFUND ~EH STICKER 54.00 05026 PAYFOI~/[NCE CORP. LASER CHECKS P~T #8009042 672.00 FREIGHT CHARGES 67.15 739.15 02285 PEDERSEN & HOUPT REAL ESTATE T~X TRANSACTIONS 10.00 FOR SERVICES 05/31/03 909.50 919.50 05257 RESCHE'S FLOWER SHOP ~LOWERING ANNUALS FOR VARIOUS 2720.00 ADDITIONAL CHARGES 60.00 2780.00 00124 POLICE PENSION FOND PAYROLL FOR - 062603 20184.04 02327 POMP'S TIRE SERVICE, INC. TIRES MOUNTED & BAk~NCED 4905.20 04921 POPE, ELIZABETH a. PAYROLL FOR - 062603 923.08 07894 POZNANSKI, FHANCIS M. REFOND HE~tT RE 50.00 02338 PRAIRIE BRASS BAND 4TH OF ~LY RA~DE 1200.00 06661 PRIME OFFICE PROD. SUPPLIES 59.31 02363 PROSPECT ~RCHING K~IGHTB 4TH OF ~LY. PARADE 2000.00 02408 REID AND ASSOCIATES, JOHN E. PRE-~PLO~ENT TESTING 175.00 00418 ROSCOP, WILLI~ REIMEURSE EXPENSES 68.86 07047 ROSRAN, MICHAEL REtMEURS~ENT FOR OBTAINING CD 50.00 04673 SAN BERNARDINO COUNTY CHILD SUPPORT PAYMENTS PAYROLL FOR - 062603 115.38 ~PORT: APBOARDRPT GENERATED: 31 ~L 02 07:58 RUN: WEDNESDAY JUL092003 I6:36 PAGE 8 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF SILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 26 2003 TO JULY 09 2003 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 01780 SBC 07480 SBC DATAC(i~4 07529 SCHAMBACH SOFTWARE SOLUTIONS, INC. 07898 SC}5~EIZER EMBLEM C~PANY 00125 SEIU LOCAL 73 02542 SHEPP PEST CONTROL 06989 SIKICE GARDNER & CO., LLP 07911 SILVEP~A~t, JOEL 06947 SIMONS, GERALD 05673 SKYL!NEDIS?LAYS OF CHICAGO 02619 STAT TECHNOLOGIES, INC. 00441 STRAHL, DAVID 06163 SZABO'S MASONRY SEALING 07875 SZADY, BOZENA 02691 TRO~PSON ELEVATOR INSPECTIONS 01291 THYSSENKRUPP ELEVATOR 02722 TRI STATE ELECTRONIC CORP. 00127 UNITED WAY ACCT#847 253-t137 349 4 i6.77 ACCT#847 253-1137 349 4 55.89 ACCT#847 253-1137 349 4 11.18 ACCT#847 253-1137 349 4 I6.77 ACCT#847 253-1137 349 4 111.78 ACCT#847 253-1137 349 4 55.89 ACCT#847 253-1137 348 4 55.89 ACCT#847 253-1137 349 4 83.83 ACCT#847 253-1137 349 4 145.31 ACCT#847 253-1137 349 4 44.70 ACCT#847 253-1137 349 4 44.70 ACCT#847 253-1137 349 4 201.20 ACCT#847 253-1137 349 4 I134.52 ACCT#847 253-1137 349 4 1112.17 ACCT#847 253-1137 349 4 715.36 ACCT#847 253-1137 349 4 212.37 ACCT#847 253-2141 577 2 642.86 ACCT#847 25302151 752 8 226.54 847 392-1070 416 6 12.41 4900.I4 SMART NET CONTRACT 274.40 CONSULTING SERVICES-JUNE 4050.00 BLUES BROTHERS PATCHES 246.49 PAYROLL FOR - 062603 669.60 PEST CONTROL SERVICES 310.00 SERVICES 800.00 PEAL ESTATE TRANSFER TAX REBAT 346.00 REAL ESTATE TAX REFUND 50.00 DISPLAY 2408.00 CHOLESTEROL SUPPLIES 513.50 LUNCH MWETING 33.91 CLEAN CALCI~ CARBONATE FRO~ S 4313.00 ~BATE FOR2 SQUARES OF PUBLIC 80.00 SERVICE CONTMACT 585.00 MAINTENANCE OF ELEVATOR AT PUB 674.89 BATTERIES & VIDEO CONNECTORS i36.01 PAYROLL FOR - 062603 421.55 REPORT: ARBOARDRPT GENERATED: 31 JUL 02 07:58 RUN:~b~SDAY J~L09z003 16:36 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF ~Ui~ DE~ ~NDOR X~BK VEN~K N~E I~OICE DRSCRt~ION ~OU~ ................................................................................................................................... 02467 U~AN ~TAIL PROPERTIES CO. BUDGET ALLOCATION ~NT-AUG 2000.00 PAGE 9 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 062603 16984.70 VOID PR FOR - 062603 258.17- PAYROLL FOR - 062703 231.17 16957.70 04314 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES PAYROLLFOR - 062603 151791.59 PAYROLL FOR- 062603 15049.56 PAYROLL FOR- 062603 13849.29 VOID PR FOR - 062603 198.55- PAYROLL FOR - 062703 230.43 PAYROLL FOR - 062703 19963.33 200685.65 02832 WALMART STORES, INC. MISC, SUPPLIES 95.16 02835 WAREHOUSE DIRECT DISK MAILERS 79.76 07726 ~EBER SCIEN~TIFIC TESTING SUPPLIES 52.08 SHIPPING 5.16 TESTING SUPP 0.71 57.95 06001 WINKLER'S TREE SERVICE 2003 PARKWAY TREE REMOVAL CONT 2003 PARKWAY TREE REMOVAL CONT 335.28 419.t0 754.38 05746 WISCTF PAYROLL FOR - 062603 542.48 07912 WOLF, JOHN R. ESTATE TRANSFER T~ REBAT 750.00 TOTAL : 488738.I3 O3O 02270 AT i T ACCT#052 371 5848 001 5.54 02270 AT&T ACCT,020 724 4120 002 1.31 01780 SBC ACCT#847 253-1137 349 4 22.36 TOTAL : 29.21 05O 02167 ARROW ROAD CONSTRUCTION 2003 STREET RESURFACING CONTRA 143949.75 07661 MATERIAL TESTING LABORATORIES INC. MATERIAL TESTING SERVICES FOR MATERIAL TESTING SERVICES FOR 1415.28 11488.72 12904.00 TOTAL : 156853.75 REPORT: APBOARDRPT GENERATED: 31 JUL 02 07:58 RUN: ~DNESDAY JUL092003 16:36 PAGE 10 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 26 2003 TO ~LY 09 2003 DEPT VENDOR NBR VENDOR NAME I~OICE DESCRIPTION ~OUNT 070 340 350 43O 510 525 01021 CAMP FIRE USA C~P FIRE SUi~4ER PROGRAM 4500.00 00335 FOLEY, APRIL B. REIMBURSEMENT 92.43 01490 GI~ SCOUTS CONTEMPORARY PROGP4~ 1250.00 01827 KLEIN, THORPE AND JENKINS,LTD. LEGAL SERVICES 409.20 05467 LEAD INSPECTORS, INC. L~D INSPECTION 250.00 07890 MATA CONCRETE CONSTRUCTION CO.INC. CONCRETE DRIVE & WALK 11100.00 02256 PADDOCK PUBLICATIONS, INC. LEGAL NOTICE 56.40 05258 PETE~ON ROOFING SINGLE FAMILY REHAB LOAN 6076.80 02659 SUBUREAN PRIF~RY HEALTH COUNCIL ACCESS TO CARE ACTIVITY #149 916.66 04559 TANGNEY & SONS SEWER REPAIR 4300.00 TOTAL : 28951.49 07306 BANK ONE PAYING AGENT FEES TOTAL : 900.00 900.00 07306 HANK ONE PAYING AGENT FEES TOTAL : 600.00 600.00 07306 BANK ONE PAYING AGENT FEES TOTAL : 300.00 300.00 01108 CITY OF PROSPECT HEIGHTS 02027 MIDWEST WATERPROOFING 07358 NEPCO INC. 05777 V3 INFRASTRECTURE SERVICES REIMBURSEMENT 13569.50 FIRE STATION #2 - INSTALLATION 2250.00 ~OVE & REPLACE MAIN ENTRY 6212.00 STAT 12 IMPROVEMENTS 77806.32 84018.32 ENGINEERING SERVICE 5755.72 TOTAL : 105593.54 06310 DLK ARCHITECTURE, INC. 07798 H~RT RATE INC. ADDITIONAL ARCHITECTUUAL SERV. 8'VARIABLE ~SISTAN£E VERSE CL 54671.00 3676.63 ~PO. NT: APHOAMDRPT GENERATED: 31 JUL 02 05:58 '~f~'~JN~J~Y'~J~09~03 I~:36 PAGE 11 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF SILLS PRESENTED TO TEE BOARD O~ TRbSTEES FRO~ JUNE 26 2003 TO SJLY DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 07358 NEPCO INC. STAT 12 IMPROVEMENTS 26765.68 07045 W.B.OLSUN, INC. VILLAGE HALL CONSTRUCTION 101482.00 526 550 560 610 TOTAL 186595.31 06310 DLK ARCHITECTURE, INC. 07045 W.B.OLSUN, INC. ADDITIONAL ARCHITECTUUAL RERV. PARKING GARAGE CONSTRUCTION TOTAL 126329.00 556988.00 683317.00 01302 ALDRIDGE ELECTRIC, iNC. 07147 CARDINAL FENCE & SUPPLY INC. 01716 ILLINOIS TAX INCREMENT ASSOC. 07307 REIDESIGNE 05777 V3 INFRASTRUCTURE SERVICES ELECTRICAL IMPROVEMENTS STREETSCAPE FENCE REPAIR SPRING 2003 CONFERENCE FEE PLANTING OF PLANT MATERIAL FOR SERVICES TOTAL 9248.02 390.00 185.00 2935.00 4527.00 17285.02 01620 AMERICAN LANDSCAPING INC. 02167 A~OW ROAD CONSTRUCTION 03284 DES ?LAINES AUTOMATIC SPRINKLER, INC. 07736 SETOM ENGINEERING SERV. CORP. 211 N. OWEN STREET - RESTORATI PARKWAY RESTORATION STREET RESURFACtNG PROGRAM 2003 STREET RESURFACING CONTRA REPAIR SPRINKLER SYSTF/4 CONSTRUCTION INSPECTION TOTAL 411.60 7661.00 8072.60 45737.60 353055.68 398793.28 439.50 4800.00 412105.38 01568 ANERICAN COMPUTER & COMMUN.INC 05222 AMERICAN INDUSTRIAL 01620 AMERICAN LANDSCAPING INC. 07889 AMGELL, BRIAN 01124 ARTHUR CLESEN, INC. 02270 AT & T 02270 AT&T J.U.L.I.E. LOCATING MANAGEMENT UNIFO~ RENTAL & CLEANING PARKWAY RESTORATION AT VARIOUS PAINTING SERVICES CASE ~ ROUND-UP PRO ACCT#052 371 5848 001 ACCT%020 724 4120 002 9697.50 118.03 781.20 154.00 345.39 369.66 87.35 REPORT: APBOARDRPT GEME~.TED: 31 JUL 02 07:58 RUN: WEDNESDAY J]3L092003 16:36 PAGE 12 RELEASE tD : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOA~D OF TRUSTEES FROM J~NE 26 2003 TO ~LY 09 2003 DEPT VENDOR NBR VENDOR NME INVOICE DESCRIPTION A~ONNT 630 05773 BAXTER & WOODMAN, INC. COMBINED SEWER SYSTEM EVALUATI 840t.90 01049 CDW GOVERNMENT, INC REPLACEMENT PRINTER FOR J.U.L. 389.00 HP IPAQ H3950 DATALOGGER DATA 385.00 10BASE-T ETHE~ET COMPACTFLASB 85.00 FRT. 14.99 873.99 05375 CENTURY CLEANERS UNIFOR~ CLEANING 102.80 01147 CO~ONWEALTH EDISON 203 E EVERGREEN #4475624003 31.35 04543 CORPORATE EXPRESS MISC. OFFICE SUPPLIES 49.63 MISC. OFFICE SUPPLIES 13.65 63.28 01377 FEDERAL EXPRESS CORP COURIER CHARGES FOR 2003 66.49 01622 HOWELL TRACTOR & EQUIPMENT CO. 5/8" X 8" X 10 PLOW BLADES 932.60 3/4" X 8" 5CDR PLOW BLADES 141.48 1074.08 07910 IRTBA REGISTRATION FEE 90.00 07892 SANCHEZ, ORYSIA RE~/1ND FINAL WATER BILL 2.25 01780 SBC ACCT#847 253-01198 2325.88 ACCT#847 253-1137 349 4 1492.20 ACCT#847 253-9377 070 8 210.55 ACCT#847 259-0894 58.69 ACCT#847 392-6053 89t 0 45.89 4133.2I 07686 SIMPLEX SYSTEMS CONTROL SUPPLY ELECTRICAL CONTROL PANE 21948.00 07893 STANIAK, WtTOLD REFUND FINAL WATER BILL 107.90 07891 VAN BUSKIRK, JOYCE RE,ND FINAL WATER RILL 61.09 TOTAL : 48509.47 01147 CO~4ONWEALTH EDISON 13 E NORTHWEST BWY #4475770000 127.80 07307 ~EIDESIGNE PLANTING OF PLANT ~TERIAL FOR 5255.75 07917 UTS GLOBAL, INC. VILLAGE PARKING DEBIT CAD 5030.00 TOTAL : 10413.55 01937 ANTIOCH TIRE, INC. REPAIR TRACTOR TIRE - FILL WIT 286.00 ~PO. RT: APBOARDRPT GENERATED: 3I J"JL 02 07:58 RUN: WEDNESDAY J~L092003 16:36 PAGE !3 RELD. SE iD : VILLAGE OF MOUNT PROSPECT LIST OF HILLS PRESENTED TO THE BOLD OF ~T~ FROM J]~$ 26 2003 TO J]LY 09 200~ DEPT VENDOR NBR VENDOR NME INVOICE DESCRIPTION MOUNT 670 02270 AT & T ACCT#052 371 5848 001 13.84 02270 AT&T ACCTff020 724 4t20 002 3.28 06468 BP SERVICE 37.98 05268 CADE INDUSTRIES SOLVENT DEGRRASER 58.00 01045 CATCHING FLUIDPOWER F77C0606-16-16-16-114.5" PARKE 85.39 F77C0606-16-16-16 Ii4" PARKER 85.13 CFP OIL DRY - 50~ BAGS 67.90 4 - 6-4 CLOX-S PAP. KER HYDRAULI 20.04 258.46 04579 cusTOM VEHICLE SYSTEMS, INC. REPAIR DYNAMARN SPEAKERS 178.00 03958 FREUND INTERNATIONAL %1671734C1 ~DIATOR HOSE 16.62 125407H1 RADIATOR VALVE 4.81 21.43 06691 JUST TIRES P225-60R16 GOODYEAR EAGLE RSA 463.92 STATE TIRE FEE 8.00 P225/60R16 GOODYEAR EAGLE REA 231.96 STATE TIRE EME 4.00 707.88 01990 MC~STER-CARR 5' #8538K26 1 3/8" NYLON ROD 29.65 5' #8538K25 1 1/4" NYLUN ROD 22.35 FREIGHT I8.98 70.98 07296 MIDPACK CORPORATION NAPA/WIX FILTERS VARIOUS SIZES 208.20 02424 REX RADIATOR & WELDING CO, INC. REOORE RADIATOR VENICLE ~4527 489.00 01780 SBC ACCT8847 253-1137 349 4 55.89 02684 TERRACE SUPPLY CO,PANT GAS CYLINDER RENTAL 13.00 04472 TEXOR PETROLEOM CO ~NLEADED GASOLINE 10095.56 05004 VERIZON WIRELESS SERVICE FOR 10 VERIZON PHONE P 44.71 TOTAL : 12542.21 04579 CUSTOM VEHICLE SYSTEMS, INC. P,~4OVE POLICE EQUIPMENT P-3 INSTALL POLICE EQUIPMENT 100.00 1767.40 1867.40 06914 HI-LiNE AP604102-1 WP BLUE ELECTRICAL 220.00 REPORT: APBOARDRPT GENERATED: 31 JUL 02 07:58 RUN: WEDNESDAY JUL092003 i6:36 PAGE i4 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM JUNE 26 2003 TO JULY 09 2003 DEPT VENDOR NBR VENDOR NAME I~OICE DESCRIPTION A~OUNT AP604152-1 AMP YELLOW ELECTRIC 125.00 69O 710 720 06691 JUST TIRES 05007 LANDMARK FORD 05721 LINE-X OF BARTLETT 02311 PIERCEMANUFACTURING INC. 02610 STANDARD EQUIPMENT COMPANY 02870 ~OLESALE DIRECT INC. 770 790 345.00 MOUNT & BAIJu~CE 454.68 2003 FORD WINDSTAR PASSENGER V 19863.00 SP~AY-ON LINER - 3 TOOL BOXES 768.00 1 PIERECE QUAMTOM P~PER fl522 189928.00 UACTORALUMINOM TOOL BOXES t224.00 #44007 REESE TRAILER HITCH 99.48 ESTIMATED FREIGHT 15.00 114.48 TOTAL : 214564.56 01236 DAVE & JIM'S AUTO BODY, INC. 01966 MARTIN BOYER COMPANY, INC FRAME & RADIATOR REPAIRS 526.48 W/C SERVICE FEE 4250.00 TOTAL : 4776.48 05037 LASALLE BANK NA SAFEKEEPING FEES 450.00 SAFEKEEPING FEES 18.75 468.75 TOTAL : 468.75 05037 LASALLE BANK NA SAFEKEEPING FEES 356.25 SAFEKEEPING FEES t8.75 375.00 TOTAL : 375.00 01405 FIRST CO~94ONWEALTH DENTAL PL~/q TOTAL : 3939.04 3939.04 00111 INDIANA DEPT OF REVENUE 07895 MID CITY PL~BING 02689 THIRD DISTRICT CIRCUIT COURT INDIANA INCOME TAX 70.16 REFUND INSPECTION BOND 100.00 BOND MONEY 980.00 BOND MONEY 4437.00 BOND MONEY I270.00 ~PQRT: APBOARDRPT G~ERATED: 31 JUL 02 07:58 RUN: ~DNESDAY JUL092003 16:36 PAGE 15 ~ELEASE ID : VILLAGE OF MOUN~ PROSPECT LIST OF BILLS PP~$ENTED TO THE BOARD OF TRUSTEES MOM JL~E 26 2003 TO JULY 09 2003 DE~T VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT BOND MONEY 2328.00 02808 VILLAGE OF MOUNT PROSPECT DISBURSEMENTS DISBURSEMENTS WISC.INCOME TAX TOTAL GRAND TOTAL 02886 NISC~SIN DEPARTMENT OFREVENUE 9015.00 9952.00 100.00 10052.00 488.62 19725.78 2396583.67 P,E~ORT: AEMOARDRPT GENERATED: 31 JUL 02 07:58 RUN: WEDNESDAY J1]L092003 16:36 PAGE 16 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESEMTED TO THE BOARD OF TRUSTEES FROM J~NE 26 2003 TO SJLY 09 2003 S[~ARY BY ~D .......................................................................................... r ........................................ 001 GENERAL FUND 488738.i3 030 REFUSE DISPOSAL FUND 29.2I 050 MOTOR FUEL TAX FUND 156853.75 070 CO}~UNITY DEVELPMNT BLOCK GEMT 28951.49 340 SERIES 1996A B&I, FLOOD 900.00 350 SERIES 1998A B&I, FLOOD 600.00 430 SERIES 1998A B&I, STREET IMP. 300.00 5t0 CAPITAL IMPROVEMENT FUND 105593.54 525 SERIES 2001 PROJECT FUND 186595.31 526 SERIES 2003 PROJECT FUND 683317.00 550 DOWETO~ REDEVLPMNT CONST 17285.02 560 STREET IMPROV~ENT CONST FUND 412105.38 610 WATER AND SEWER FUND 48509.47 630 PARKING SYST~ REVENUE FUND 10413.55 660 VEHICLE MAINTENANCE FUND 12542.21 670 VENICLE REPLACEMENT FUND 214564.56 690 RISE ~NAGEMENT FUND 4776.48 710 POLICE PENSION FUND 468.75 720 FIRE PENSION FUND 375.00 770 FLEXCOMP ESCROW FUND 3939.04 790 ESCROW DEPOSIT FUND 19725.78 TOTAL: 2396583.67 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES January 1 - June 30, 2003 '07/10/2003 15:05:52 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/03 06/30/03 6 Months 6 Months 50.0% ) Completed 50.0% ) Remainin9 Cur Mo Y-T-D 2003 Received Received Budget Unreceived Unreceived Balance Percent REVENUE BY CLASSIFICATION PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CMARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FIND/~CING SOURCES Total Ail Funds REVEN"JE BY FUND GENEP~AL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GR/qT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND SERIES 1987A B&I SERIES 1993E B&I SERIES 2001 B&I SERIES 2003 B&I SERIES 2002B B&I SERIES 2002A B&I SERIES 1993A B&I SERIES 1994B B&I SERIES 1996B B&I SERIES 1998B B&I SERIES 1999 B&I SERIES 1992A B&I SERIES 1993B B&I SERIES 1994A B&I SERIES 1996A B&I SERIES 1998A B&I SERIES 1998C B&I PW FACILITY PUBLIC BLDGS VILLAGE HALL VILLAGE HALL PUBLIC BLDGS TIF TIF TIF TIF TIF TIF FLOOD FLOOD FLOOD FLOOD FLOOD TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1994A B&I, STREET IMP. SERIES 1996A B&I, STREET IMP. SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND POLICE & FIRE BLDG CONST FUND SERIES 2001 PROJECT FUlTD SERIES 2003 PROJECT FUND 0 ~,039,476 10,930,576 1,035,906 4,911,536 10,606,790 162,469 2,265,181 2,767,330 1,501,898 7,790,301 15,302,469 1,168,828 6,658,266 14,367,886 47,948 247,382 512,960 2,636,361 3,635,512 4,555,565 68,462 402,675 683,404 147,678 2,084,573 3,748,855 0 14,050,839 13,391,677 6,769,550 47,085,741 76,867,512 5,891,100 53.9 5,695,254 53.7 502,149 18.1 7,512,168 49.1 7,709,620 53.7 265,578 51.8 920,053 20.2 280,729 41.1 1,664,282 44.4 -659,162 -4.9 29,781,771 38.7 2,394,732 15,563,254 28,903,815 120,292 1,564,098 3,280,673 143,406 829,028 1,641,250 0 19 12,173 13,917 240,583 563,457 91 429 7,200 0 1,899 12,000 1,109 6,161 6,050 29 31,681 67,128 0 0 0 73 189,176 395,057 276 463,968 932,977 429 257,128 557,353 62 28,936 87,231 0 0 0 0 0 0 3 12 0 1 4 0 291 203,986 611,452 0 0 0 0 0 0 0 0 0 14,838 102,484 215,452 4,638 17,224 67,520 80 58,511 176,150 34,131 260,578 495,833 4,876 22,676 71,295 30,878 160,384 449,061 0 0 0 0 0 0 52,108 358,993 757,251 37,547 204,914 546,423 2,397 114,517 622,200 0 0 0 1,401 18,898 20,366 9,648 12,283,521 12,355,102 13,340,561 46.2 1,716,575 52.3 812,222 49.5 12,154 99.8 322,874 57.3 6,771 94.0 10,101 84.2 -111 -1.8 35,447 52.8 0 205,881 52.1 469,809 50.3 300,225 53.9 58,295 66.8 0 0 -12 407,466 66.6 0 0 0 112,968 52.4 50,296 74.5 117,639 66.8 235,255 47.4 48,619 68.2 288,677 64.3 0 0 398,258 52.6 341,509 62.5 507,683 81.6 0 1,468 7.2 71,581 0.6 07/10/2003 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/03 - 06/30/03 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining Cur MO Y-T-D 2003 Received Received Budget Unreceived Unreceived Balance Percent 2002 LIBRARY PROJECT FUND CAPITAL IMPROVEMENT CONST FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST 1998A FLOOD CONTROL CONST FLrND WATER AND SEWER FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTEND~NCE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND POLICE PENSION FUND FIRE PENSION FUND BENEFIT TRUST #2 FUND ESCROW DEPOSIT FUND SSA #1 PROSPECT MEADOWS B&I SSA #8 GEORGE/ALBERT B&I SERIES 2002 LIBRARY BND ESCROW Total All Funds 0 0 0 0 534 1,483,896 t75,108 923,344 0 0 2,224 15,117 512,930 3,577,234 13,858 86,543 95,645 573,603 80,229 528,051 18,930 113,892 359,647 2,234,250 1,424,636 2,272,001 1,218,526 2,275,855 0 28 0 0 0 0 29 17,993 1 872 6,769,550 47,085,741 0 0 427,884 1,820,765 0 20,000 8,212,925 189 200 1,144 297 1,027 561 227 476 4,529 130 3~108 033 3,272 100 0 0 33,531 0 76,867,512 0 0 -1,056,012 897,421 0 4,883 4,635 691 102 657 570 694 499.510 113.584 2,294.880 836032 996286 0 0 15,538 -872 29,781,771 -246.8 49.3 24.4 56.4 54.3 49.9 48.6 49.9 50.7 26.9 30.4 72.0 46.3 38 .? · 07/10/2003 FRRBRR03 SUM 021 6 Months ( 50.0% ) Completed 6 Months ( 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Budget Revenue by Category within Fund Summary o /o /o3 06/30/03 Cur MO Y-T-D 2003 Received Received Budget Unreceived Unreceived Balance Percent GENERAL FUND 40 PROPERTY TAXES 0 3,600,746 7,811 41 OTHER TAXES 692,001 1,957,665 3,785 42 LICENSES, PERMITS & FEES 156,422 2,068,763 2,532 43 INTERGOVERMENT REV. 1,359,964 6,838,882 12,785 44 CHARGES FOR SERVICE 63,573 405,003 797 45 FINES AND FORFEITS 46,848 239,513 487 46 INVESTMENT INCOME 12,411 95,782 265 47 REIMBURSEMENTS 56,592 181,390 300 48 OTHER REVENUE 6,921 175,510 139 TOTAL GENERAL FUND 655 4,210,909 53.9 058 1,827,393 48.3 130 463,367 18.3 239 5,946,357 46.5 053 392,050 49.2 960 248,447 50.9 000 169,218 63.9 570 119,180 39.7 150 -36,360 -26.1 2,394,732 15,563,254 28,903,815 13,340,561 46.2 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 0 1,048,394 2,278,373 1,229,979 54.0 44 CHARGES FOR SERVICE 117,962 496,402 972,300 475,898 48.9 46 INVESTMENT INCOME 2,330 17,863 30,000 12,137 40.5 48 OTHER REVENUE 0 1,439 0 -1,439 TOTAL REFUSE DISPOSAL FUND 120,292 1,564,098 3,280,673 1,716,575 52.3 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS TOTAL MOTOR FUEL TAX FD'ND LAW ENFORCEMENT BLOCK GRANT 43 ~NTERGOVERMENT REV. 46 INVESTMENT INCOME TOTAL LAW ENFORCEMENT BLOCK GRA~T COMMUNITY DEVELpMNT BLOCK GRNT 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 48 OTRER REVENUE TOTAL COMMUNITY DEVELPM~T BLOCK GRNT ASSET SEIZURE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME TOTAL ASSET SEIZURE FUND DEA SHARED FUNDS FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME 141,934 812,461 1,611,000 798,539 49.6 1,472 14,423 30,000 15,577 51.9 0 2,144 250 -1,894 -757.6 143,406 829,028 1,641,250 812,222 49.5 0 0 12,Y73 i2,173 100.0 0 19 0 -19 0 19 12,173 12,154 99.8 0 138,958 506,657 367,699 72.6 0 162 0 -162 13,917 101,463 56,800 -44,663 -78.6 13,917 240,583 563,457 322,874 57.3 0 110 7,000 6,890 98.4 91 319 200 -119 -59.5 91 429 7,200 6,771 94.0 0 1,659 12,000 10,341 86.2 0 240 0 -240 07/10/2003 FRRBRR 0 3 SUM 021 6 Months ( 50.0% ) Completed 6 Months ( 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Budget Revenue by Category within Fund Summary 01/01/03 06/30/03 Cur Mo Y-T-D 2003 Received Received Budget Unreceived Unreceived Balance Percent TOTAL DEA EHARED FUNDS FUND DUI FINE FUND 45 FINES AND FORFEITS 46 INVESTMENT INCOME TOTAL DUI FINE FUND SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 46 INVESTMENT INCOME TOTAL SERIES 1987A B&I, PW FACILITY SERIES 19938 B&I, PUBLIC BLDGS 40 PROPERTY T~LXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 19938 B&I, PUBLIC BLDGS SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 2003 B&I, VILLAGE HALL SERIES 20028 B&I, PUBLIC BLDGS 40 PROPERTY TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL 8ERIEE 20028 B&I, PUBLIC BLDG8 SERIES 2002A B&I, TIF 41 OTHER TAXES 46 IN-VESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 2002A B&I, SERIES 1993A B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 0 1,899 12,000 10~101 84.2 1,100 9 1,109 6,100 6,000 -100 -1.7 61 50 -11 -22.0 6,161 6,050 -111 -1.8 0 31,544 66,500 34,956 52.6 29 137 628 491 78.2 29 31,681 67,128 35,447 52.8 0 0 0 0 0 0 0 0 0 0 0 0 o o o ~0 0 103,781 223,048 119,267 53.5 73 395 2,009 1,614 80.3 0 85,000 170,000 85,000 50.0 73 189,176 395,057 205,881 52.1 276 629 6,300 5,671 90.0 0 463,339 926,677 463,338 50.0 276 463,968 952~977 469,009 0 255,011 551,000 295,989 53.7 429 2,117 6,353 4,236 66.7 0 0 0 0 429 257,128 557,353 300,225 53~9 0 28,596 86,000 57,404 66.7 62 340 1,231 891 72.4 0 0 0 0 62 28,936 87,231 58,295 66.8 0 0 0 0 0 0 0 0 0 0 0 0 · 07/10/2003 15:06:50 FRRBRR0 3 S~M 021 6 Months ( 50.0% ) Completed 6 Months ( 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Budget Revenue by Category within Fund Summary 01/01/03 - 06/30/03 Cur Mo Y-T-D 2003 Unreceived Unreceived Received Received Budget Balance Percent TOTAL SERIES 1993A B&I, TIF SERIES 1994B B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1994B B&I, SERIES 1996B B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 1996B B&I, TIF SERIES 1998B B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1998B B&I, TIF SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 1999 B&I, TIF SERIES 1992A B&I, FLOOD 41 OTEER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1992A B&I, FLOOD SERIES 1993B B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 1993B B&I, FLOOD SERIES 1994A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 1994A B&I, FLOOD SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 12 0 -12 0 0 0 0 3 12 0 -12 0 0 0 0 1 4 0 -4 I 4 0 -4 0 202,169 608,000 405,831 291 1,817 3,452 1,635 0 0 0 0 66.7 47.4 291 203,986 611,452 407,466 66.6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 14,758 102,i61 2i3,640 80 323 1,812 111,479 52.2 1,489 82.2 07/10/2003 15:06:50 FRRBRR03 SUM 02t 6 Months ( 50.0% ) Completed 6 Months ( 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Budget Revenue by Category within Fund Summary 01/01/03 06/30/03 TOTAL SERIES 1996A B&I, FLOOD Cur Mo Y-T-D 2003 Unreceived Unreceived Received Received Budget Balance Percent 14,838 102,484 215,452 112,968 52.4 SERIES 1998A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 1998A B&I, FLOOD 4,630 17,195 67,031 49,836 74.3 8 29 489 460 94.1 0 0 0 0 4,638 17,224 67,520 50,296 74.5 SERIES 1998C B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1998C B&I, TIF 0 58,063 174,617 116,554 66.7 80 448 1,533 1,085 70.8 80 58,511 176,150 117,639 66.8 IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL IEPA FLOOD CONTROL LOANS B&I 34,131 260,114 494,100 233,986 47.4 0 464 1,733 1,269 73.2 34,131 260,578 495,833 235,255 47.4 SERIES 2000 E&I, FLOOD CONTROL 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 2000 B&I, FLOOD CONTROL 4,873 22,451 70,540 48,089 68.2 3 225 755 530 70.2 0 0 0 0 4,876 22,676 71,295 48,619 68.2 SERIES 2002B B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 2002B B&I, FLOOD 30,738 159,869 444,989 285,120 64.1 140 515 4,072 3,557 87.4 0 0 0 0 30,878 160,384 449,061 288,677 64.3 SERIES 1994A B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 1994A B&I, STREET IMP. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 SERIES 1996A B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SERIES 1996A B&I, STREET IMP. 0 0 0 0 0 0 0 0 0 0 0 0 SERIES 1998A B&I, STREET IMP. 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 51,825 357,902 750,256 392,354 283 1,091 6,995 5,904 0 0 0 0 52.3 84 .4 07/10/2003 15:06:50 FRRBRR 0 3 SUM o2I 6 Months ( 50.0% ) Completed VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining Budget Revenue by Category within Fund Summary 01/01/03 06/30/03 Cur MO Y-T-D 2003 .Received Received Budget Unreceived Unreceived Balance Percent TOTAL SERIES 1998A B&I, STREET IMP. 52,108 358,993 757,251 398,258 52.6 SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES 37,305 203,888 540,044 336,156 62.2 46 INVESTMENT INCOME 242 1,026 6,379 5,353 83.9 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2002B B&I, STREET IMP. 37,547 204,914 546,423 341,509 62.5 CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 0 0 387,400 387,400 100.0 46 INVESTMENT INCOME 2,397 17,317 40,000 22,683 56.7 47 REIMBURSEMENTS 0 0 154,300 154,300 100.0 48 OTHER REVENUE 0 97,200 40,500 -56,700 -140.0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL CAPITAL IMPROVEMENT FUND 2,397 114,517 622,200 507,683 81.6 POLICE & FIRE BLDG CONST FUND 46 INVESTMENT INCOME TOTAL POLICE & FIRE BLDG CONST FUND 0 0 0 0 0 0 0 0 SERIES 2001 PROJECT FUND 46 INVESTMENT INCOME 1,401 18,898 20,366 1,468 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2001 PROJECT FUND 1,401 18,898 20,366 7.2 1,468 7.2 SERIES 2003 PROJECT FUND 46 INVESTMENT INCOME 9,648 48,521 120,102 71,581 49 OTHER FINANCING SOURCES 0 12,235,000 12,235,000 0 TOTAL SERIES 2003 PROJECT FUND 9,648 12,283,521 12,355,102 71,581 2002 LIBP~ARY PROJECT FUND 46 INVESTMENT INCOME 0 0 0 0 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL2002 LIBRARY PROJECT FUND 0 0 0 0 CAPITAL IMPROVEMENT CONST FUND 43 INTERGOVERMENT REV. 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 TOTAL CAPITAL IMPROVEMENT CONST FUND 0 0 0 0 DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 0 86,321 259,600 173,279 46 INVESTMENT INCOME 534 2,985 0 -2,985 47 REIMBURSEMENTS 0 168,284 168,284 0 59.6 0.6 66.7 07/10/2003 15:06:50 FRRBRR 03 SUM 021 6 Months ( 50.0% ) Completed VILLAGE OF MOUNT PROSPECT 6 Months ( 5o.0% ) Remaining Budget Revenue by Category within Fund Summary 01/01/03 - 06/30/03 Cur Mo Y-T-D 2003 Unreceived Unreceived Received Received Budget Balance Percent 48 OTHER REVENUE 0 1,306 0 -1,306 49 OTHER FINANCING SOURCES 0 1,225,000 0 -1,225,000 TOTAL DOWNTOWN RBDEVLPMNT CONST 534 1,483,896 427,884 -1,056,012 -246.8 STREET IMPROVEMENT CONST FUND 41 OTHER TAXES 165,645 701,156 1,542,765 841,609 54.6 42 LICENSES, PERMITS & FEES 6,047 196,418 228,000 31,582 13.9 46 INVESTMENT INCOME 3,416 25,770 50,000 24,230 48.5 48 OTHER REVENUE 0 0 0 0 TOTAL STREET IMPROVEMENT CONST FUND 175,108 923,344 1,820,765 897,421 49.3 FLOOD CONTROL CONST 1998A 46 INVESTMENT INCOME TOTAL FLOOD CONTROL CONST 1998A 0 0 0 0 0 0 0 0 FLOOD CONTROL CONST FUND 41 OTHER TAXES 0 0 0 0 43 INTERGOVERMENT REV. 0 0 0 0 46 INVESTMENT INCOME 2,224 15,117 20,000 4,883 24.4 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL FLOOD CONTROL CONST FUND 2,224 15,117 20,000 4,883 24.4 WATER AND SEWER FUND 41 OTHER TAXES 0 736,158 1,537,125 800,967 52.1 44 CHARGES FOR SERVICE 507,639 2,799,975 6,590,800 3,790,825 57.5 46 INVESTMENT INCOME 5,088 36,342 70,000 33,658 48.1 47 REIMBURSEMENTS 0 0 0 0 48 OTHER REVENUE 203 4,759 15,000 10,241 68.3 TOTAL WATER ~ SEWER FUATD 512,930 3,577,234 8,212,925 4,635,691 56.4 PARKING SYSTEM REVENUE FUND 42 LICENSES, PERMITS & FEES 0 0 7,200 43 INTERGOVERMENT REV. 0 0 0 44 CHARGES FOR SERVICE 12,597 78,805 164,000 46 INVESTMENT INCOME 1,261 7,618 18,000 48 OTHER REVENUE 0 120 0 TOTAL PARKING SYSTEM REVENtrE FUND 13,858 86,543 189,200 VEHICLE MAINTENANCE FUND 44 CFJLRGES FOR SERVICE 94,902 569,401 46 INVESTMENT INCOME 743 4,202 48 OTHER REVENUE 0 0 TOTAL VEHICLE MAINTENANCE FUND 95,645 573,603 7,200 100.0 0 85,195 51.9 10,382 57.7 -120 102,657 54.3 1,138,797 569,396 50.0 5,500 1,298 23.6 0 0 1,144,297 570,694 49.9 07/10/2003 15:06:50 FRRBRR03 SUM 021 Budget 6 Months ( 50.0% ) Completed 6 Months ( 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/03 06/30/03 Cur MO Y-T-D 2003 Unreceived Unreceived Received Received Budget Balance Percent VEHICLE REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FIND/~CING SOURCES TOTA~VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME TOTAL COMPUTER REPLACEMENT FU~rD RISK MA/qAGEMENT FUND 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE TOTAL RISK MAI~AGEMENT FUND POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVEbVJE TOTAL POLICE PENSION FUND FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE TOTAL FIRE PENSION FUND BENEFIT TRUST #2 FUND 46 INVESTMENT INCOME TOTAL BENEFIT TRUST #2 FLrND ESCROW DEPOSIT FUND 46 INVESTMENT INCOME TOTAL ESCROW DEPOSIT FUND SSA #1 PROSPECT MEADOWS B&I 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL SSA #1 PROSPECT MEADOWS B&I 66,466 398,780 797,561 398,781 50.0 13,763 86,771 170,000 83,229 49.0 0 0 0 0 0 42,500 60,000 17,500 29.2 80,229 528,051 1,027,561 499,510 48.6 0 0 0 0 287,732 1,802,161 3,691,899 1,889,738 S1.2 3,224 20,710 45,000 24,290 54.0 11,870 50,857 60,000 9,143 15.2 56,821 360,522 732,231 371,709 50.8 359,647 2,234,250 4,529,130 2,294,880 50.7 1,384,285 1,572,118 1,688,000 115,882 6.9 40,351 699,883 1,420,033 720,150 50.7 1,424,636 2,272,001 3,108,033 836,032 26.9 1,189,061 1,633,484 1,927,000 293,516 15.2 29,465 642,371 1,345,141 702,770 52.2 1,218,526 2,275,855 3,272,141 996,286 30.4 0 28 100 72 72.0 0 28 100 72 72.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o7/10/2o03 15:06:5o FRRBRR03 SUM 021 6 Months ( 50.0% ) Completed~ 6 Months ( 50.0% ) Remaining VILLAGE OF MOUNT PROSPECT Budget Revenue by Category within Fund Suaunary 01/01/03 06/30/03 Cur Mo Y-T-D 2003 Received Received Budget Unreceived Unreceived Balance Percent SSA #8 GEORGE/ALBERT B&I 41 OTHER TDSfES 0 17,828 33,025 15,197 46.0 46 INVESTMENT INCOME 29 165 506 341 67.4 TOTAL SSA #6 ~EORGE/ALBERT B&I 29 17,993 33,531 15,538 46.3 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME TOTAL SERIES 2002 LIBP. AR¥ BND ESCROW MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES TOTAL MOUNT PROSPECT LIBRARY FUND 1 872 0 -872 1 872 0 -872 0 0 26,171,713 26,171,713 100.0 0 0 26,171,713 26,171,713 100.0 · 07/10/2003 15:04:19 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/03 . 06/30/03 6 Months ( 6 Months ( Cur Mo Y-T-D 2003 Expended Expended Budget 50,0% ) 50.0% ) Unexpended Balance Completed Remaining Unexpended Percent EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS PENSION BENEFITS CONTP, ACTUAL SERVICES UTILITIES INSUR3%NCE COMMODITIES & SUPPLIES OTHER EXPENDITURES LJLND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT DISTRIBLVfION SYSTEMS INFRASTRUCTURE BOND PRINCIPAL INTEREST EXPENSE BA/~K AND FISCAL FEES INTERFUND TRANSFERS OTHER FINANCING USES Total All Fund~ EXPENDITURE BY FL~gD 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 SERIES SERIES SERIES SERIES SERIES SERIES SERIES SERIES SERIES SERIES SERIES SERIES SERIES SERIES SERIES SERIES 1993B B&I, PUBLIC BLDGS 2001 B&I, VILLAGE ~3%LL 2003 B&I, VILLAGE HALL 2002B B&I PUBLIC BLDGS 2002A B&I TIF 1992B B&I TIF 1993A B&I TIF 1994B B&I TIF 1996B B&I TIF 1998B B&I TIF 1999 B&I, TIF 1991A B&I, FLOOD 1992A B&I, FLOOD 1993B B&I, FLOOD 1994A B&I, FLOOD 1996A B&I, FLOOD 1998A B&I, FLOOD 1,485,068 9,536,387 20,590,795 339,722 2,903,640 6,073,186 17,766 88,713 290,662 333,971 2,048,404 4,108,225 1,177,339 6,187,150 14,176,500 35,443 194,193 534,165 423,148 2,769,664 5,063,598 60,358 470,866 1,092,486 -36,691 36,853 703,718 135,348 178,384 428,734 1,012,293 3,324,447 14,781,705 6,723 215,263 737,700 404,528 950,366 1,879,554 25,735 89,547 876,455 63,753 274,730 1,651,700 859,195 1,858,749 6,799,541 113,683 243,267 4,362,028 54,947 750,650 1,590,264 0 1,725 9,200 0 548,339 1,096,677 0 0 0 6,512,329 32,671,337 86,846,893 11,054 408 3,169 546 201 949 2,059 821 7,989 350 339 972 2,293 934 621 620 666 865 250 350 11,457258 522 437 929 188 786 908 1,376,970 4,940,792 4,118,761 839,614 7,475 548,338 0 54,175,556 2,070,448 13,867,850 30,050,838 16,182,988 274,905 1,460,264 3,307,863 1,847,599 567,239 1,487,791 2,505,655 1,017,864 0 12,201 12,173 -28 31,487 100,437 563,457 463,020 0 0 8,850 8,850 0 617 5,225 4,608 0 690 12,000 11,310 0 112,000 112,000 0 0 0 0 0 0 107,608 390,616 283,008 0 t47,913 927,677 779,764 0 22,454 625,760 603,306 0 2,450 105,800 103,350 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 134,400 523,800 389,400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 16,370 213,640 t97,270 0 6,110 67,520 61,410 53.7 52.2 69.5 50.1 56.4 63.6 45.3 56.9 94 .8 58.4 77.5 70.8 49.4 89.8 83.4 72.7 94 · 4 52.8 81.3 50.0 62.4 53.9 55.9 40.6 -0.2 82.2 100.0 88.2 94.3 72.5 84.1 96.4 97.7 74.3 92.3 91.0 07/i0/2003 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/03 - 06/30/03 6 Months ( 6 Months ( 50.0% ) Completed 50.0% ) Remaining Cur MO Y-T-D 2003 Expended Expended Budget Unexpended Unexpended Balance Percent SERIES 1998C E&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1994A B&I, STREET IMP. SERIES 1996A B&I, STREET IMP. SERIES 1998A B&I, STREET IMP. SERIES 2002B B&I, STREET IMP. CAPITAL IMPROVEMENT FUND POLICE & FIRE BLDG CONST FUND SERIES 2001 PROJECT FUND SERIES 2003 PROJECT FUND 2002 LIBRARY PROJECT FUND CAPITAL IMPROVEMENT CONST FUND DOWNTOWN REDEVLPMNT CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FUND WATER AND SEWER FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK M/~NAGEMENT FUND POLICE PENSION FUND FIRE PENSION FUND BENEFIT TRUST #2 FUND SSA #1 PROSPECT MEADOWS B&I SSA #6 GEORGE/ALBERT B&I Total All Funds 0 168,630 0 0 0 0 0 0 165,224 0 1,084,779 0 0 0 -26 852 196 872 86 856 678 286 14 055 75 998 404 528 6,371 386,840 160,729 168,837 -2,903 0 0 6,512,329 17,693 306,676 56,049 14,087 0 0 34,856 13,088 442,779 0 3,305,140 142,238 0 0 64,389 765,793 197,744 3,494,908 78,911 519,038 950,366 186,458 2,562,592 1,043,638 979,286 12,565 0 3,888 32,671,337 150,985 613,358 112,098 480,924 0 0 900,013 596,826 1,331,092 0 4,145,010 11,143,963 0 0 1,178,218 4,173,174 518,027 9,604,119 387,472 1,193,397 1,879,554 211,250 4,683,096 2,071,900 1,988,650 13,118 0 37,775 86,846,893 133,292 88.3 306,682 50.0 56,049 50.0 466,837 97.1 0 0 865,157 96.1 583,738 97.8 888,313 66.7 0 839,870 20.3 11,001,725 98.7 0 0 1,113,829 94.5 3,407,381 81.6 320,283 61.8 6,109,211 63.6 308,561 79.6 674,359 56.5 929,188 49.4 24,792 11.7 2,120,504 45.3 1,028,262 49.6 1,009,364 50.8 553 4.2 0 33,887 89.7 54,175,556 62.4 07/10/2003 FRRDBR01 SUm 031 6 Months VILLAGE OF MOUNT PROSPECT 6 Mo~t~s Department Budget Expenditure Summary 01/01/03 ~ 06/30/03 PUBLIC REPRESENTATION C~r Mo Y-T-D 2003 Expended Expended Budget 50.0% ) Completed 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 MAYOR AND BOARD OF TRUSTEES 03 ADVISORY BOARDS & COMMISSIONS Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 2,756 63,303 89,653 946 6,803 14,514 3,702 26,350 29.4 7,711 53.1 70,106 104,167 34,061 2,779 16,918 34,050 394 2,395 4,854 0 6 200 507 49,290 59,138 22 131 475 0 1,366 S,450 0 0 0 3,702 70,106 104,167 3,702 70,106 104,167 3,702 70,106 104,167 32.7 34,061 32.7 34,061 32.7 17,132 50.3 2,459 50.7 194 97.0 9,848 16.7 344 72.4 4,084 74.9 0 34,061 32.7 15:07:29 FRRDBR01 SUM 031 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remainin9 Department Budget Expenditure Summary 01/01/03 - 06/30/03 VILLAGE MANAGER'S OFFICE Cur Mo Y-T-D 2003 Expended Expended Budget Unexpended Unexpended Balance Percent FROGP, AM TOTALS 01 VILLAGE MANAGER'S OFFICE 02 LEGAL SERVICES 03 PERSONNEL SERVICES 04 INFORMATION TECHNOLOGY 05 PUBLIC INFORMATION Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 26,156 184,716 367,130 182,414 49.7 33,918 154,754 360,000 205,246 57.0 26,222 112,131 255,512 143,381 56.1 37,815 277,614 656,498 378,884 57.7 8,124 53,109 154,226 101,117 65.6 132,235 782,324 1,793,366 1,011,042 56.4 49,860 317,929 655,520 337,591 51.5 12,839 79,392 158,588 79,196 49.9 1,497 11,368 26,427 15,059 57.0 67,624 368,896 917,224 548,328 59.8 400 1,637 5,230 3,593 68.7 15 2,517 12,200 9,683 79.4 0 585 18,177 17,592 96.8 132,235 782,324 1,793,366 1,011,042 56.4 132,235 782,324 1,793,366 1,011,042 56.4 132,235 782,324 1,793,366 1,011,042 56.4 07/10/2003 15:07:29 FRRDBR01 SLIM 031 6 Months VILLAGE OF MOUNT PROSPECT 6 Mont~s Department Budget Expenditure Summary 01/01/03 ~ 06/30/03 TV SERVICES DIVISION Cur MO Y-T-D 2003 Expended Expended Budget 50.0% ) Completed 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 03 OTHER SERVICES 04 INTERGOVERNMENTAL PROGRAMMING Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 9,747 60,576 130,241 0 0 0 2,780 19,626 51,148 12,527 80,202 181,389 69,665 53.5 0 31,522 61.6 101,187 55.8 6,939 40,733 102,770 2,298 13,862 30,116 0 555 2,600 2,085 9,785 24,678 603 1,658 2,000 602 3,127 7,975 0 10,482 11,250 12,827 80,202 181,389 621'037 60.4 i6,254 54.0 2,045 78.7 14,893 60.3 342 17.1 4,848 60.8 768 6.8 101,187 55.8 12,527 80,202 181,389 101,187 55.8 12,527 80,202 181,389 101,187 55.8 15:07:29 FRRDBR0 1 SUM 031 VILLAGE OF MOUNT PROSPECT 6 Department Budget Expenditure Summary 01/01/03 - 06/30/03 VILLAGE CLERK'S OFFICE Cur MO Y-T-D 2003 Expended Expended Budget 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES S5 UTILITIES 57 COMMODITIES & SUPPLIES Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 10,163 76,600 165,792 89,192 53.8 10,163 76,600 165,792 89,192 53.8 6,554 41,827 93,610 2,306 14,145 29,192 7 166 2,300 827 18,160 32,840 75 440 1,600 394 1,862 6,250 10,163 76,600 165,792 51,783 55.3 15,047 51.5 2,134 92.8 14,680 44.7 1,160 72.5 4,388 70.2 89,192 53.8 10,163 76,600 165,792 10,163 76,600 165,792 89,192 53.8 89,192 53.8 .o7/lo/2oo3 15:o7:29 FRRDBR01 SUM o31 6 Months ( 50.0% ) Completed VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining Department Budget EXpenditure Summary 01/01/03 - 06/30/03 FINANCE DEPARTMENT Cur MO Y-T-D 2003 Expended Expended Budget Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 02 ACCOUNTING 03 DATA PROCESSING 04 DUPLICATING SERVICES 05 INSUPJ%NCE PROGRAMS 06 CUSTOMER SERVICES 07 CASH MANAGEMENT Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 6,642 89,224 208,465 27,645 173,644 360,061 0 9 0 872 5,524 15,140 24,358 160,135 325,094 22,533 165,243 343,520 3,054 19,268 40,806 119,241 57.2 186,417 51.8 -9 9,616 63.5 164,959 50.7 178,277 51.9 21,538 52.8 85,104 613,047 1,293,086 680,039 52.6 43,782 326,446 699,940 15,147 98,956 203,293 479 1,897 5,550 2,128 43,177 83,728 283 1,672 7,600 22,010 132,060 264,120 1,275 6,148 24,555 0 2,691 4,300 373,494 53.4 104,337 51.3 3,653 65.8 40,551 48.4 5,928 78.0 132,060 50.0 18,407 75.0 1,609 37%4 85,104 613,047 1,293,086 680,039 52.6 85,104 613,047 1,293,086 680,039 52.6 85,104 613,047 1,293,086 680,039 52.6 15:07:29 FRRDBR0 1 SLTM 031 VILLAGE OF MOUNT PROSPECT 6 Mo~tns Department Budget Expenditure Summary 01/01/03 - 06/30/03 COMI~TJNITY DEVELOPMENT Cur Mo ¥-T-D 2003 Expended Expended Budget 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGR3~M TOT;tLS 01 COMMUNITY DEVELOPMENT ADMIN 02 PLJ~NING & ZONING 03 ECONOMIC DEVELOPMENT 05 BUILDING INSPECTIONS 06 HOUSING INSPECTIONS 07 HEALTH INSPECTIONS Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST Totals 13,321 86,315 176,386 14,555 83,798 236,854 5,691 31,079 81,584 41,677 284,593 671,303 22,539 134,465 275,107 8,024 49,069 105,184 90,071 51,1 153,056 64.6 50,485 61.9 386,710 57.6 140,642 51.1 56,115 53.3 105,807 669,319 1,546,398 877,079 56.7 71,958 457,777 1,047,590 24,673 151,909 323,1tl 15 3,605 14,065 7,110 44,501 125,257 1,364 7,906 24,060 687 3,621 12,315 0 0 0 589,813 56.3 171,202 53.0 10,460 74.4 80,756 64.5 16,154 67.1 8,694 70.6 0 105,807 669,319 1,546,398 877,079 56.7 105,807 669,319 1,545,933 0 0 465 876,614 56.7 465 100.0 105,807 669,319 1,546,398 877,079 56.7 .07/10/2003 FRRDBR01 SUM 6 Months VILLAGE OF MOUNT PROSPECT 6 Mo~ths Department Budget Expenditure Summary 01/01/03 , 06/30/03 COM/4UNITY DEVELOPMENT - CDBG 50.0% ) Completed 50.0% ) Remainin9 Cur Mo Y-T-D 2003 Unexpended Unexpended Expended Expended Budget Balance Percent PROGRAM TOTALS 04 CDBG ADMINISTRJ%TION 05 CDBG COMMUNITY PROGRAMS 06 ACCESSIBLTY & NEIGHBRHD IMPRV 07 CDBG RESIDENTIAL REKAB Totals 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 Totals SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT Totals 2,545 19,557 44~951 25,394 56.5 10,717 20,318 91,050 70,732 77.7 14,916 52,313 190,506 138]193 72.5 3,309 8,249 236,950 228,701 96.5 31,487 100,437 563,457 463,020 82.2 1,856 11,245 27,530 16,285 59.2 681 4,093 9,036 4,943 54.7 0 4,208 4,575 367 8.0 10,725 20,329 93,465 73,136 78.2 0 0 1,395 1,395 10O.0 3,309 8,249 236,950 228,701 96.5 0 25,000 75,000 50,000 66.7 14,916 27,313 115,506 88,193 76.4 31,4s7 100.~7 s63.4s7 ~'~,'0~° 8~.2 31,487 100,437 563,457 463,020 82.2 31,487 100,437 563,457 463,020 82.2 15:07:29 FRRDBR01 SUM o31 HUMAN' SERVICES VILLAGE OF MOUNT PROSPECT 6 ~onths Department Budget Expenditure Summary 01/Ol/O3 - 06/30/03 Cur Mo Y-T-D 2003 Expended Expended Budget 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 02 SOCIAL SERVICES 03 NURSING/HEALTH SERVICES 04 SENIOR CTR. LEISURE ACTIVITIES 05 YOUTH ACTIVITIES 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 14,821 96,687 218,530 21,225 127,921 264,590 4,470 43,845 167,065 6,237 26,159 56,458 4,170 18,566 51,642 121,843 55.8 136,669 51.7 123,220 73.8 30,299 53.7 33,076 64.0 50,923 313,178 758,285 445,107 58.7 30,681 200,491 461,730 8,905 55,769 119,687 12 1,159 4,200 10,069 47,770 126,963 1,114 5,553 9,180 142 2,186 35,025 0 250 1,500 0 0 0 261,239 56.6 63,918 53.4 3,041 72.4 79,193 62.4 3,627 39.5 32,839 93.8 1,250 83.3 0 50,923 313,178 758,285 445,107 58.7 50,923 313,178 758,285 445,107 58,7 50,923 313,178 758,285 445,107 58.7 .07/10/2003 15:07:29 FRRDBR01 SUM 031 POLICE 6 Months VILLAGE OF MOUNT PROSPECT 6 Months Department Budget EXpenditure Summary 01/01/03 - 06/30/03 Cur Mo Y-T-D 2003 Expended Expended Budget 50.0% ) Completed 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTAL8 01 POLICE ADMINISTRATION 02 PATROL & TRAFFIC ENFORCEMENT 03 CRIME PREVTN & PUBLIC SERVICES 04 I~IVESTIGATIVE & JUVENILE PRGM 05 CROSSING GUARDS 06 EQUIPMENT MAINTENANCE 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 Totals SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GR3~NT 080 ASSET SEIZURE FUND 085 DEA SHARED FUNDS FUND 086 DUI FINE FUND Totals 70,748 960,836 2,042,335 1,081,499 53.0 470,881 3,091,331 6,518,778 3,427,447 52.6 13,938 86,661 227,501 140,840 61.9 78,424 504,917 1,114,221 609,304 54.7 988 12,148 26,090 13,942 53.4 38,799 270,278 554,804 284,526 51.3 673,778 4,926,171 10,483,729 5,557,558 53.0 489,164 3,241,154 7,020,540 3,779,386 53.8 97,230 991,612 2,072,604 1,080,992 52.2 2,294 20,504 64,545 44,041 68.2 79,734 611,450 1,138,937 527,487 46.3 2,596 14,856 53,000 38,144 72.0 2,561 27,343 74,315 46,972 63.2 0 0 0 0 0 12,201 13,323 1,122 8.4 199 7,051 46,465 39,414 84.8 673,778 4,926,171 10,483,729 5,557'558 53.0 673,778 4,912,663 10,445,481 5,532,818 53.0 0 12,201 12,173 -28 -0.2 0 0 8,850 8,850 100.0 0 617 5,225 4,608 88.2 0 690 12,000 11,310 94.3 673,778 4,926,171 10,483,729 5,557,558 53.0 15:07:29 FRRDBR01 SUM 031 FIRE VILLAGE OF MOUNT PROSPECT 6 Mo~ths Department Budget Expenditure Summary 01/01/03 - 06/30/03 Cur MO Y-T-D 2003 Expended Expended Budget 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 FIRE ADMINISTRATION 02 FIRE DEPARTMENT OPERATIONS 03 FIRE TPJ%INING ACADEMY 04 FIRE PREVENTION 05 FIRE COMMUNICATIONS 06 EQUIPMENT MAINTENANCE 07 EMERGENCY PREPARDENESS PRGM 08 PAID-ON-CALL PROGPJ%M Totals 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 Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 66,476 801,057 1,734,672 933,615 53.8 449,191 2,750,648 5,620,489 2,869,841 51.1 1,286 3,190 13,140 9,950 75.7 31,304 192,193 449,209 257,016 57.2 4,575 27,322 66,400 39,078 58.9 31,041 229,445 422,713 193,268 45.7 372 1,643 10,850 9,207 84.9 1,674 8,629 36,365 27,736 76.3 585,919 4,014,127 8,353,838 4,339,711 51.9 443,484 2,786,557 5,784,450 77,364 887,837 1,856,871 7,717 26,612 106,915 33,893 229,794 403,417 2,120 19,990 49,300 5,557 35,756 83,635 1,882 2,772 4,000 0 341 10,500 13,902 24,468 54,750 2,997,893 51.8 969,034 52.2 80,303 75.1 173,623 43.0 29,310 59.5 47,879 57.2 1,228 30.7 10,159 96.8 30,282 55.3 585,919 4,014,127 8,353,838 4,339,711 51.9 585,919 4,014,127 81353,838 4,339,711 51.9 585,919 4,014,127 8,353,838 4,339,711 51.9 10 D7/10/2003 15:07:29 FRRDBR01 SUM 031 PUBLIC WORKS 6 Months VILLAGE OF MOUNT PROSPECT 6 Mot. tbs Department Budget EXpenditure Summary 01/01/03 - 06/30/03 - ADMINISTRATION Cur Mo Y-T-D 2003 Expended Expended Budget 50.0% ) Completed 50.0% ) Remainin~ Unexpended Unexpended Balance Percent 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 79,456 474,556 969,874 495,318 51.1 79,456 474,556 969,874 495'318 51.1 15,546 103,315 210,685 107,370 51~0 7,041 43,525 87,070 43,545 50.0 3,107 6,705 25,065 18,360 73.2 50,776 306,526 619,519 312,993 50.5 1,278 8,935 17,775 8,840 49.7 1,332 5,174 8,200 3,026 36.9 0 0 1,000 1,000 100.0 376 376 560 184 32.9 79,456 474,556 969,874 495,3i8 51.1 79,456 474,556 969,874 495,318 51.1 79,456 474,556 969,874 495,318 51.1 11 FRRDBR0t SUM 031 PUBLIC WORKS VILLAGE OF MOUNT PROSPECT 6 Months ( Department Budget Expenditure Summary 01/01/03 06/30/03 Cur Mo Y-T-D 2003 STREETS/BLDGS Expended Expended Budget 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 02 04 05 06 O7 O8 09 11 STREET DIVISION ~DMINISTRATION MAINTENANCE - PUBLIC BUILDINGS STREET MAINTENANCE SNOW REMOVAL LEAF REMOVAL STORM SEWER & BASIN MAINT ~LAINTENANCE OF STATE HIGHWAYS TRAFFIC SIGN MAINTENANCE PARKING LOT MAINTENANCE Totals ~XPEArDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 67 OTHER EQUIPMENT 69 INFR3%STRUCTURE Totals SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 630 PARKING SYSTEM REVENUE FUND Totals 7,684 56,402 126,194 69,792 55.3 62,512 316,308 641,510 325,202 50.7 29,828 115,182 422,605 307,423 72.7 7,041 219,757 342,970 123,213 35.9 8,502 51,376 161,931 110,555 68.3 10,255 62,620 150,909 88,289 58.5 5,625 35,112 62,664 27,552 44.0 8,496 48,981 100,624 51,643 51.3 14,055 78,911 287,472 178,561 69.4 153,998 984,649 2,266,879 1,282,230 56.6 77,997 519,716 1,057,455 537,739 50.9 20,338 130,768 262,435 131,667 50.2 39,413 172,375 482,286 309,911 64.3 323 1,869 18,480 16,611 89.9 927 5,564 11,128 5,564 50.0 11,050 148,558 266,595 118,037 44.3 0 0 0 0 0 0 0 0 3,950 5,799 168,500 162,701 96.6 153,998 984,649 2,266,879 1,282,230 56.6 139,943 824,238 1,811,897 987,659 54.5 0 81,500 197,510 116,010 58.7 14,055 78,911 257,472 178,561 69.4 153,998 984,649 2,266,879 1,282,230 56.6 12 .07/~0/2003 15:07:29 FRRDBR01 SUM 03I PUBLIC WORKS 6 Months VILLAGE OF MOUNT PROSPECT 6 Months Department Budget EXpenditure Summary 01/01/03 06/30/03 Cur Mo Y-T-D 2003 - FORESTR¥/GRNDS Expended Expended Budget ( 50.0% ) Completed ( 50.0% ) Remainin~ Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 02 MAINTENANCE OF GROUND 03 FORESTRY pROGRAM 04 PUBLIC GROUNDS BEAUTIFICATION Totals ~XPBNDITURB CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND Totals 13,183 87,256 184,248 48,684 155,028 374,414 48,718 269,196 725,362 4,307 21,117 40,189 96,992 52.6 219,386 58.6 456,166 62,9 19,072 47,5 114,892 532,597 1,324,213 791,616 59.8 55,017 300,937 664,395 14,015 82,701 1'2,963 0 760 750 36,484 126,916 448,530 3,478 15,385 26,035 5,898 5,898 11,540 363,458 54.7 90,262 52.2 -10 -1.3 321,614 71.7 10,650 40.9 5,642 48.9 114,892 532,597 1,324,213 791,616 59.8 114,892 532,597 1,314,213 0 0 10,000 781,616 59.5 10,000 100.0 114,892 532,597 1,324,213 791,616 59.8 13 15:07:29 FRRDBR01 SUM 031 PUBLIC WORKS VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remainin~~ Department Budget Expenditure Summary 01/01/03 - 06/30/03 Cur Mo Y-T-D 2003 ENGINEERING Expended Expended Budget Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGMTNG 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 69 INFRASTRUCTURE Totals SOURCE OF FD'NDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND Totals 45,835 265,426 22,143 127,826 67,978 393,252 624,448 359,022 57.5 583.671 455,845 76.1 1,208,119 814,867 67.4 38,186 222,903 517,380 10,166 61,094 131,651 629 2,614 4,690 6,017 38,502 205,953 12,246 62,219 192,850 734 5,910 13,095 0 0 750 0 10 1,750 O 0 140,000 67,978 393,252 1,208,119 294,477 56.9 70,557 53.6 2,076 44.3 167,451 81.3 130,631 67.7 7,185 54.9 750 100.0 1,740 99.4 140,000 100.0 814,867 67.4 53,573 323,278 823,269 14,405 69,974 384,850 67,978 393,252 1,208,119 499,991 60.7 314,876 81.8 814,867 67.4 14 15:07:29 FRRDBR 01 SUM 031 PUBLIC WORKS 6 Months VILLAGE OF MOUNT PROSPECT 6 Months Department Budget Expenditure Sununary 01/01/03 - 06/30/03 Cur Mo Y-T~D 2003 WATER/SEWER Expended Expended Budget ( 50.0% ) Completed ( 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGP~ TOT~LS 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 MA!NT & REPL 08 EQUIPMENT MAINTENANCE 09 SANITARY SEWER MAINT & REPAIR 10 WATER & SEWER SYSTEM IMPROV 12 ~KE MICHIGAN WATER SUPPLY Totals EXPEA~DITURE CLJ~ESIFICATION 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 EQUIPME~ 68 DISTRIBUTION SYSTEMS 71 BOND PRINCIPAL Totals SOURCE OF FUNDS 610 WATER AND SEWER FUND Totals 104,561 6,199 9,622 34,144 54,330 15,599 21,375 45,165 35,151 83,607 268,533 613,650 32,806 30,679 189 918 243 985 109 100 123 284 270 984 112 012 302 384 1,465 106 1,379,119 146,108 77,747 427,780 1,015,795 286,177 292,220 541,970 337,613 2,001,700 3,097,890 765,469 113,302 47,068 237 862 771 810 177 077 168 936 270 986 225 601 1,698 316 1,632,784 55.5 77.5 60.5 55.6 76.0 61.9 57.8 50.0 66.8 84 .8 52.7 678,286 3,494,908 9,604,119 6,109,211 63.6 105,397 647,777 1,496~990 849,213 56.7 32,700 200,249 426,451 226,202 53.0 1,934 8,019 26,030 18,011 69.2 433,163 2,123,403 4,813,174 2,689,771 55.9 12,914 66,484 150,670 84,186 55.9 13,013 78,078 156,156 78,078 50.0 9,700 52,348 166,185 113,837 68.5 0 3,559 17,226 13,667 79.3 352 352 6,400 6,048 94.5 5,360 39,909 590,437 550,528 93.2 63,753 274,730 1,651,700 1,376,970 83.4 0 0 102,700 102,700 100.0 678,286 3,494,908 9,604,1~9 6,109,2~ 63.6 678,286 3,494,908 9,604,119 6,109,211 63.6 678,286 3,494,908 9,604,119 6,109,211 63.6 15 FRRDBR01 SUM o31 PUBLIC WORKS VILLAGE OF MOUNT PROSPECT 6 Months ( so.o% ) Eemaiui~g Department Budget Expenditure Summary 01/01/03 06/30/03 - REFUSE DISPOSAL Cur MO Y-T-D 2003 Unexpended Unexpended Expended Expended Budget Balance Percent PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES Totals SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND Totals 274,905 1,460,264 3,307,863 1,847,599 55.9 274,905 1,460,264 3,307,863 1,847,599 55.9 5,596 35,902 74,150 38,248 51.6 1,630 10,094 20,563 10,469 50.9 0 315 750 435 58.0 267,291 1,409,705 3,200,707 1,791,002 56.0 30 233 545 312 57.2 358 2,149 4,298 2,149 50.0 0 1,866 6,850 4,984 72.8 274,905 1,460,264 3,307,863 1,847,599 55.9 274,905 i,460,264 3,307,863 1,845,599 55.9 274,905 1,460,264 3,307,863 1,847,599 55.9 16 ,07/10/2003 FRRDBR01 SUM 031 6 Months VILLAGE OF MOUNT PROSPECT 8 Months DePartment Budget Expenditure summary 01/01/03 06/30/03 PUBLIC WORKS - VEHICLE MAINT Cur Mo Y-T-D 2003 Expended Expended Budget 50.0% ) CompLeted 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 02 VEHICLE MAINTENANCE PROGR3~M 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 Totals SOURCE OF FUI~DS 660 VEHICLE MAINTENANCE FUND Totals 9 959 69,378 146,498 66 039 449 660 1,046,899 77,120 52.6 597,239 57.0 674,359 56.5 75,998 519,038 1,193,397 39,748 261,497 592,400 11,863 74,427 157,635 75 220 2,000 4,165 30,324 71,021 75 610 1,000 20,072 151,960 316,491 0 0 0 0 0 500 0 0 52,350 75,998 519,038 1,193,397 330,903 55.9 83,208 5~.8 1,780 89.0 40,697 87.3 390 39.0 164,531 52.0 0 500 100.0 52,350 100.0 674,359 56.5 75,998 519,038 1,193,397 674,359 56.5 75,998 519,038 1,193,397 674,389 56.5 FRRDBRO1 SUM031 VILLAGE OF MOUNT PROSPECT 6 ~o~s Department Budget Expenditure Summary 01/01/03 - 06/30/03 COMMUNITY SERVICE PROGRAMS Cur Mo Y-T-D 2003 Expended Expended Budget 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 03 4TH OF JULY & CIVIC EVENTS,ETC 04 HOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 5,003 53,292 96,900 43,608 45.0 9,366 24,994 114,010 89,016 78.1 490 3,202 66,781 63,579 95.2 259 1,263 2,800 1,537 54.9 15,118 82,751 280,491 197,740 70.5 524 3,263 49,610 46,347 93.4 132 812 7,066 6,254 88.5 11,703 72,937 189,695 116,758 61.6 0 0 400 400 100.0 2,759 5,739 25,720 19,981 77.7 0 0 8,000 8,000 100.0 15,118 82,751 280,491 197,740 70.5 15,118 82,751 280,491 197,740 70.5 15,118 82,751 280,491 197,740 70.5 18 ~7/10/2003 15:07:29 FRRDBR0 1 SUM 031 CAPITAL 6 Months VILLAGE OF MOUNT PROSPECT 6 Months Department Budget Expenditure SUmmary 01/01/03 - 06/30/03 Cur Mo Y-T-D 2003 IMPROVEMENT PROJECTS Expended Expended Budget 50.0% ) Completed 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGPO~MTOTALS 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 Totals EXPENDITURE CLASSIFICATION 54 CONTP~ACTUAL SERVICES 55 UTILITIES 59 OTHER EXPENDITURES 62 L~/~D IMPROVEMENTS 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 66 MOBILE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE Totals 1,094,735 3,691,853 16,058,531 12,366,678 77.0 155,268 198,304 623,534 425,230 68.2 -26,852 64,389 1,177,753 1,113,364 94.5 86,856 197,744 518,027 3~0,283 61.8 749,706 1,638,771 5,237,792 3,599,021 68.7 404,528 950,366 1,879,554 929,188 49.4 6,371 186,458 211,250 24,792 11.7 2,470,612 6,927,885 25,706,441 18,778,556 73.1 113,625 451,582 0 0 -40,000 25,045 135,348 178,384 1,010,411 3,296,675 6,371 198,843 404,528 950,366 0 1,353 840,329 1,825,637 1,089,768 638,186 58.6 0 0 441,542 416,497 94.3 428,734 250,350 58.4 14,702,705 11,406,030 77.6 681,250 482,407 70.8 1,879,554 929,188 49.4 107,353 106,000 98.7 6,375,535 4,549,898 71.4 2,470,612 6,927,885 25,706,441 18,778,556 73.1 SOURCE OF FUNDS 050 MOTOR FUEL TAX FUND 060 LAW ENFORCEMENT BLOCK GRANT 510 CAPITAL IMPROVEMENT FUND 520 POLICE & FIRE BLDG CONST FUND 525 SERIES 2001 PROJECT FUND 526 SERIES 2003 PROJECT FUND 527 2002 LIBRARY PROJECT FUND 530 CAPITAL IMPROVEMENT CONST FUND 550 DOWNTOWN REDEVLPMNT CONST 560 STREET IMPROVEMENT CONST FUND 590 FLOOD CONTROL CONST FUND 630 PARKING SYSTEM REVENUE FUND 670 VEHICLE REPLACEMENT FUNqD 680 COMPUTER REPLACEMENT FUND 690 RISK M~AGEMENT FUND Totals 552,834 1,336,317 1,923,295 586,978 0 0 0 0 165,224 442,779 1,331,092 '888,313 0 0 0 0 1,084,779 3,305,140 4,145,010 839,870 0 142,238 1i,143,963 11,00i,725 0 0 0 0 0 0 0 ~ 0 -26,852 64,389 1,177,753 1,113,364 196,872 302,454 3,246,497 2,944,043 86,856 197,744 518,027 320,283 0 0 130,000 i30,000 404,528 950,366 1,879,554 929,188 6,371 186,458 211,250 24,792 0 0 0 0 30.5 66.7 20.3 98.7 94.5 90.7 61.8 100.0 49.4 11.7 19 15:07:29 FRRDBR01 SUM 031 DEBT SERVICE VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining Department Budget Expenditure Sununary 01/01/03 - 06/30/03 Cur Mo Y-T-D Expended Expended 2003 Unexpended Unexpended Budget Balance Percent PROORA~ TOTALS 02 DEBT SERVICE - PROPERTY TAXES 03 DEBT SERVICE - TAX INCREMENT 04 DEBT SERVICE - M/R SALES TAX 1 05 DEBT SERVICE - H/R SALES TAX 2 06 SPECIAL SERVICE AREA B & I Totals EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 59 OTHER EXPENDITURES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BD~NK AND FISCAL FEES 80 INTERFUND TRANSFERS 81 OTHER FINANCING USES Totals SOURCE OF FUNDS 140 SERIES 170 SERIES 180 SERIES 190 SERIES 200 SERIES 230 SERIES 240 SERIES 250 SERIES 260 SERIES 270 SERIES 280 SERIES 290 SERIES 300 SERIES 310 SERIES 320 SERIES 330 SERIES 340 SERIES 350 SERIES 1987A B&I, PW FACILITY 1993B B&I, PUBLIC BLDGS 2001 B&I, VILLAGE HALL 2003 B&I, VILLAGE HALL 2002B B&I PUBLIC BLDGS 2002A B&I TIF 1992B B&I TIF 1993A B&I TIF 1994B B&I TIF 1996B B&I TIF 1998B B&I TIF 1999 B&I, TIF 1991A B&I, FLOOD 1992A B&I, FLOOD 1993B B&I, FLOOD 1994A B&I, FLOOD 1996A B&I, FLOOD 1998A B&I, FLOOD 360 SERIES 1998C B&I, TIF 380 IEPA FLOOD CONTROL LOANS B&I 390 SERIES 2000 B&I, FLOOD CONTROL 400 SERIES 2002B B&I, FLOOD 410 SERIES 1994A B&I, STREET IMP. 420 SERIES 1996A B&I, STREET IMP. 430 SERIES 1998A B&I, STREET IMP. 440 SERIES 2002B B&I, STREET IMP. 810 SSA #1 PROSPECT MEADOWS B&I 830 SSA #6 GEORGE/ALBERT B&I 0 389,975 2,056,053 1,666,078 81.0 0 154,543 780,585 626,042 80.2 168,630 399,292 1,487,540 1,088,248 73.2 0 47,944 1,496,839 1,448,895 96.8 0 3,888 37,775 33,887 89.7 168,630 995,642 5,858,792 4,863,150 83.0 0 0 0 0 0 0 0 0 113,683 243,267 4,259,328 4,016,061 94.3 54,947 750,650 1,590,264 839,614 52.8 0 1,725 9,200 7,475 81.3 0 0 0 0 0 0 0 0 168,630 995,642 5,858,792 4,863,150 83.0 0 112,000 112,000 0 0 0 0 0 0 107,608 390,616 283,008 72.5 0 147,913 927,677 779,764 84.1 0 22,454 625,760 603,306 96.4 0 2,450 105,800 103,350 97.7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 134,400 523,800 389,400 74.3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 16,370 213,640 197,270 92.3 0 6,110 67,520 61,410 91.0 0 17,693 150,985 133,292 88.3 168,630 306,676 613,358 306,682 50.0 0 56,049 112,098 56,049 50.0 0 14,087 480,924 466,837 97.1 0 0 0 0 0 0 0 0 0 34,856 900,013 865,157 96.1 0 13,088 596,826 583,738 97.8 0 0 0 0 0 3,888 37,775 33,887 89.7 2O FRRDBR01 SUM o 3~ DEBT SERVICE 6 Months ( 50.0% ) Completed VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining Department Budget Expenditure Summary 01/01/03 - 06/30/03 Cur Mo Y-T-D 2003 Expended Expended Budget Unexpended Unexpended Balance Percent Totals 168,630 995,642 5,858,792 4,863,150 83.0 21 FRRDBR 01 SUM 031 VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remainin9 Department Budget Expenditure Summary 01/01/03 - 06/30/03 RETIREE PENSIONS Cur MO Y-T-D 2003 Expended Expended Budget Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 MISCELLJ%NEOUS PENSIONS 02 POLICE PENSIONS 03 FIRE PENSIONS Totals EXPENDITURE CLASSIFICATION 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND 710 POLICE PENSION FLTND 720 FIRE PENSION FUND 730 BENEFIT TRUST #2 FUND Totals 4,405 26,429 52,875 26,446 50.0 160,729 1,043,638 2,071,900 1,028,262 49.6 168,837 979,286 1,988,650 1,009,364 50.8 333;971 2,049,353 4,113,425 2,064,072 50.2 333,971 2,048,404 4,108,225 2~059,821 50.1 0 949 5,000 4,051 81.0 0 0 200 200 100.0 0 0 0 0 333,971 2,049,353 4,113,425 2,064,072 50.2 7,308 13,864 39,757 25,893 65.1 160,729 1,043,638 2,071,900 1,028,262 49.6 168,837 979,286 1,988,650 1,009,364 50.8 -2,903 12,565 13,118 553 4.2 333,971 2,049,353 4,113,425 2,064,072 50.2 . 22 ~7/10/2003 15:07:29 FRRDBR01 SUM 031 6 Months ( 50.0% ) Completed VILLAGE OF MOUNT PROSPECT 6 Months ( 50.0% ) Remaining DePartment Budget ExPenditure Summary 01/01/03 06/30/03 RISK MANAGEMENT Cur Mo Y-T-D 2003 Expended Expended Budget Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 CAsuALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE Totals 106,555 880,890 955,013 74,123 7.8 280,285 1,681,702 3,718,083 2,036,381 54.8 386,840 2,562,592 4,673,096 2,110,504 45.2 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE Totals 386,840 2,562,592 4,673,096 2,116'504 45.2 SOURCE OF FUNDS 690 RISK M~NAGEMENT FUND Totals 386,840 2, 562,592 4,673,096 2,110,504 45.2 386,840 2,562,592 4,673,096 2,110,504 45.2 23 15:07:29 FRRDBR 01 SUM o31 VILLAGE OF MOUNT PROSPECT 6 Mo=th~ < Department Budget Expenditure Sununary 01/01/03 06/30/03 NON- DEPARTMENTAL Cur Mo Y-T-D 2003 Expended Expended Budget 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 CONTINGENCIES Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 59 OTHER EXPENDITURES INTERFUI~D TRANSFERS Totals SOURCE OF FUNDS 001 GENERAL FUND 560 STREET IMPROVEMENT CONST FUND 670 VEHICLE REPLACEMENT FUND Totals 0 548,339 1,096,677 548,338 50.0 0 548,339 1,096,677 548,338 50.0 0 0 0 0 0 0 0 0 0 0 0 0 0 548,339 1,096,677 0 548,339 1,096,677 0 0 0 0 548,338 50.0 548,338 50.0 0 85,000 170,000 0 463,339 926,677 0 0 0 0 548,339 1,096,677 85,000 50.0 463,338 50.0 0 548,338 50.0 24 ~07/10/2003 15:07:29 FRRDBR01 SUM 031 MOUNT VILLAGE OF MOUNT PROSPECT 6 Months Department Budget Expenditure Summary 01/01/03 - 06/30/03 PROSPECT LIBRARY Cur Mo Y-T-D 2003 Expended Expended Budget 50.0% ) Remaining Unexpended Unexpended Balance Percent PROGP3tMTOTALS 02 LIBRARY SERVICES Totals EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES Totals SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND Totals 0 26,171,713 26,171,713 100.0 0 26,171,713 26,171,713 100.0 0 26,171,713 26,171,713 100.0 0 26,171,713 26,171,713' 100.0 0 26,171,713 26,171,713 100.0 0 26,171,713 26,171,713 I00.0 25