Loading...
HomeMy WebLinkAbout3. BILLS & FINANCIALS 12/17/02VILLAGE OF MOUNT PROSPECT CASH POSITION 11-Dec-02 General Fund Special Revenue Funds Refuse Disposal Fund Motor Fuel Tax Fund Local Law Enfrcmt BIk Grant Fd 1997 Community Development BIk Grant Fund Asset Seizure Fund DEA Shared Funds DUI Fine Fund Debt Service Funds Capital Prolects Funds Capital Improvement Fund Series 2001 Project Fund Capital Improvement Const 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.qency Funds Police Pension Fund Fire Pension Fund Flexcomp Trust Fund Escrow Deposit Fund Benefit Trust Funds Cash & Invstmt Receipts Disbursements Other Balance 12/01102 Per Attached Credits/ 12/01/02 12/11102 List of Bills Debits 8,230,145 889,739 537,687 2,136,864 51,204 129,929 1,827,860 141,932 13,872 12,173 40,668 48,290 59,452 11,933 745,081 205,294 5,710 2,958,726 200,000 254,112 4,566,286 t62,272 48 (24,684) 575,000 3,753 3,538,709 21,040 376,534 945,254 857,214 4,335,225 311,944 302,951 498,385 4,643 8,877 360,350 77 16,186 5,556,454 312 532,723 2,639,304 4,991 323,382 29,492,221 10,127 5,422 31,554,391 11,076 5,000 29,694 46 3,217 1,226,029 11,262 62,177 15,550 101,324,958 3,307,762 2,211,393 Cash & Invstmt Balance 12/1t/02 8,582,197 2,058,139 1,955,920 12,173 34,958 48,290 59,452 11,933 950,375 2,904,614 4,404,014 48 546,563 3,183,215 1,802,468 4,344,218 494,151 344,241 5,556,142 532,723 2,320,913 29,496,926 31,560,467 26,523 1,175,t14 15,550 102,421,327 REPORT: APBOANDRPT GENERATED: 31 JUL 02 07:58 RUN: WEDNESDAY DECl12002 16:08 PAGE 1 RELEASE ID : VILLAGE OF MDONT PROSPEC? LIST OF RILLS PRESENTER TO THE BOARD OF TRUSTEES FRC~ NOVE~BER 26 2002 TO DECEMBER I1 2002 DEPT VENDOR UBR VENDOR NkME IEVOICE DESCRIPTION AMOUNT 001 05452 AAA ERPLOYMERT SECRETARIAL SERVICES 323.15 02955 ACME TRUCK BRAKE & SUPPLY CO. REPAIR PARTS 127.13 04594 AEC FIRE SAFETY SECURITY EMERGENCY EQUIP. 01227 AIR ONE EQUIPMENT, INC. ADAPTOR KIT REPAI~ 617.15 705.36 764.90 1470.26 05222 AMERICAN INDUSTRIAL ERIFO~ CLE,~NING & RENTAL 464.39 01620 AF~/{ICAR LANDSCAPING IWE. 01699 AMERICAN PUBLIC WORKS ASSOC. FaANTIi~G OF 3,800 DAPODIL ROLR 1200.00 UERICLE ARPLACEMERT GUIDE AND 94.15 01780 AERRITECE SERVICE 31.50 SERVICE 10.30 SERVICE 15.05 SERVICE 50.16 SERNTCE 10.03 SERVICE 15.05 SRENTCE 100.32 SERVICE 50.16 SERVICE 190.61 SERVICE 50.16 SERVICE 75.24 SERVICE 130.4t SERVICE 40.13 SERVICE 40.13 SERVICE 180.57 SERVICE 1018.24 SERVICE 990.17 SERVICE 642.04 SERVICE 342.71 3990.98 01830 ANDERSON ELEVATOR CO. MAINT.OF PASSENGER ELEVATOR 165.45 01840 ARDERSON PEST CONTROL AVITROL ON ROOF TOPS 66.25 01890 .?'2'IDUB~KI, ELHANORE D. PTRG 2002 100.00 01973 APWA CHICAGO METRO CHANTER RE$INTRATION 25.00 02224 ASCE-UB&DG RERISTRE-,Y.WUARECENR 25.00 02270 AT & T SERVICE 6.50 SERVICE 21.98 SERVICE 4.40 SERVICE 6.59 SERVICE 43.95 SERVICE 21.98 REPORT: APROARDRPT GENERATED: 31 JUL 02 07:58 RUN: WEDNESDAY DECll2002 16:08 PAGE 2 RELEASE ID : VILLAGE OF MDO~ PROSPECT LIST OF BILLS PRESENTED TO TEE BOARD OF TRUSTEES FROM NOVEMBER 26 2002 TO DEC~REER 11 2002 DE~T VENDOR NBR VENDOR NAME INVOICE DESCRIFTION AMOUNT DEMVICE 83.51 SERVICE 21.98 SERVICE 32.97 SERVICE 57.14 SERVICE 17.58 SERVICE 17.58 SERVICE 79.12 SERVICE 446.13 SERVICE 437.34 SERVICE 281.00 052 377 1810 001 129.04 1709.17 05044 ANTSEMNTACARNTSTEM TLC CA, LEASE 788.49 05520 AWARDS PLUS CERTIFICATE ~S 314.02 04363 BAN~L~TANK, RICHARD& ADELINE F1RG2002 100.00 04503 BER~, GLORIA ~TRE2002 65.00 02959 BRRE~R4BE, EF~iA ~RG2002 100.00 03661 BUFFALO GROVE FIRE DEPT. VA~ENTINE,REIMBECRER 100.00 01518 CANON BUSINESS SOLUTIONS-CEMTREL CARTRIDGE 120.67 TOMER 802.02 922.69 01049 CEM GOVEIL~NT, tEC AN}H]ALCRECKPOINTSO~ARE/SOP 3010.00 ADOBE ACROBAT V.5 UPGRADE 08.00 MS PROOEC? 2002 STD. 529.00 SHFRPIEGCHGS 10.99 RETURE ~O ~90212 DUE ?0 INCORE 900.00 Rinzip0.X 28.00 ROXIO Easy CD C~eator 5.0 79.00 Global Intervideo ~INDVD 39.00 Symntec Internet Security 65.00 HP LJ 8100 Tone~ Castridges 310.00 10 Pack Disk Mailers 12.00 SHIPPING CHGS 2.52 8081.51 053T5 CENTURY CLFANERE UNIFO~CLEANTEG 72.25 01118 CLERK OF THE CIRCUIT COURT PRIROLLFOR - 112702 700.00 PAYROLLFOR- 121202 700.00 PAYRO~ FOR - 112702 300.00 PAYROLL FOR - 121202 300.00 2000.00 01141 COLU~91OFFIUNEQ~FRFf24T, INC. ANNUAL MAI~.AGRELMEMTFOR %77 2514.95 REPORT: AREOABDRPT GENERATED: 3I JUL 02 07:58 ROM: WEDNESDAY DECl12002 16:08 PAGE 3 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO TEE BONED OF TRUSTEES FROM NOVE~ER 26 2002 TO DECEMBER 1i 2002 DE~T VENDOR NNE VENDOR NAME INVOICE DESCRIPTION AMOUNT 04504 CORTESI, VICTORIA J. PTBG 2002 34.98 05503 CRYSTAL MGMT.&RAINTENAMCE CUSTODIAL SERVICES 1210.00 07421 CUPR-ROTGEES BDOK OF DRV.DEFINITIONS 54.95 01270 DI FRANCESCA, JAMINE PTRG 2002 100.00 07403 DISTNEAMO, FRANK PTRG 2002 62.42 01279 DISTINCTIVE BUSINESS PRODUCTS VILL }{GP~ OFFICE 212.90 CO~ DRV-PLAN&ZOM 212.90 1% DISCOONT 4.26- 421.54 03553 DORNQUAST, DOROTHY PTRG 2002 85~72 04447 DNEEC, ANNA RITA PTRG 2002 77.89 06343 EDDINGTON, RIC~L~RD REINEUP~E ~PD~SES 129.97 01340 ~ESSY COFFEE SERVICE COFREE 57.00 07331 E~ERGENCY SERVICES SUPPLY HEADLIGHTS 125.00 01350 ~DRAVOR ~US ANNUAL NEALTN EVALUATION 766.00 07413 ENTERFEIZ COOK COUNTY ~]i~ICIPAL MNEB~HIP FEE 100.00 06198 F & F OFFICE PROOWOTS OFFICE SUPPLIES 177.63 01369 NEIRVIEW PRINTIX{G SERVICE ~OOKS & ~I~D ID KITS 680.00 01377 FEDERAL EXPRESS CORV ~ISC.SKIFEIX{G CEERGES 155.74 ~ BILL 40.14 S/E CRA~GES 11.70 S/H CRARGES 46.04 253.62 00102 FI~E PENSION FOND PAYROLL FOR - 112702 16726.64 PAYNOLL FOR - 121202 14266.50 30993.I4 01422 POI~ENE FLAG & D~CORATING, INC ANNEAL X-~AS ~CORATIOES 8718.00 01444 FE~ES A~T~OTIVE TOW 212.50 01461 GALL'S, INC. TEST KITS 62.80 SUPPLIES 334.98 SUPPLIES 177.86 SNEPLIES 87.96 SUPPLIES 18.18 SUPP~tES 21.99 REPORT: APBOARDRPT GENERATED: 31 JUL 02 07:58 RUN: WEDNESDAY DECl12002 16:08 PAGE 4 RELEASE ID : VILLAGE OF MOUNT PDOSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FR~ NOVEMBER 26 2002 TO DECEMBER 11 2002 DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT 703,77 01504 GLUCZYNSKI, LEONA NTRG 2002 99.32 04489 DOERINGER, CAROL D. PTRG 2002 i00.00 05549 GOLIK, JAM PTRG 2002 95.78 04377 GOSZCZYNSKI, LORETTA a. NTRG 2002 100.00 01515 GOVEEMING SUBSCRIPTION 48.00 SUBSCRIPTION 32 80.00 06305 GOVE~4~{T E-MAMAG~NV ORACLE MAIHY-2003 9240.00 04448 GROSELAK, ~DITN R. NTRG 2002 100.00 06589 GUARDIAN QUEST CUSTO~R SERVICE TRAINING 5151.54 01547 ~, WILLIAM A. NTRG 2002 56.13 07415 BANNA, STEPH~ & SNA~YL ~EAL ESTATE TAX REBATE 582.00 05729 NKINRICN, LAREY REIMBURSEMENT 96.00 01578 HENDRICKSEN, ROBERT W. PAPAg~AY TREE TRI~9~ING 7403.00 03600 HEMGLER, RICRARE NTRG 2002 100.00 01585 BERPEL, ~EWDOKIA ~TRG 2002 I00.00 01609 HOLY FAMILY MEDICAL CENTER PRE-~PLPYMEM? PHYSICALS 195.00 PRE-EMPLOYMENT PHYSICALS 204.00 399.00 01610 HC~E DEPNT/GECF MISC ND~E/BLDO SUPP 113.77 00106 ICMA RETIREMENT TRUST - 401 PAYROLL FOR - 112702 400.00 ICMA 401-R.EDDINGTON 335.10 PAYROLL FOR - 121202 400.00 ICMA 40I PLAN 335.10 1470.20 00107 ICt~A RETIP~EMENT TRUST - 457 PAYROLL FOR - 112702 16360.46 00108 ILLINOIS DEPARTMENT OF ~E PAYROLL FOR - 112702 20209.13 01675 ILLINOIS DEVELO~.MD~7 COONCIL 2003 DUES-~I.COOWEY 150.00 00109 ILLINOIS M~NICIPAL RETI~I~? PAYROLL FOR - 112702 437.00 05445 ILLINOIS OFFICE SUPPLY NOMI~TION KITS 71.79 REPORT: HEBOARDRIT G~ERATRD: 31 JUL 02 07:58 RUN: WEDNESDAY UNClt2002 16:08 PAGE 5 ~5EARE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILL8 PRESENTED TO THE BOARD OF TR~ETEES FRDMNOVF14RER 26 2002 TO DHEf~BER 11 2002 DEPT VENDOR NBR VENDOR NAF~ INVOICE DEDOR!~TIUN AMOUNT 01701 ILLINOIS PAPER CO. PAPER 178.00 PAPER 1071.19 t249.19 01121 ILLINOIS STATE DISBURSE~UNT UNIT PAYROLL FOR- 112702 25.03 PAYRDLLFOR- 121202 67.11 PAYROLL FUN- 112702 357.69 PAYROLL fO~- 121202 357.69 PAYROLL FON- 112702 195.50 PAYROLL FUN- 121202 195.50 PA~OLL ~- 112702 116.31 PAYROLL F~- 121202 t16.31 PAYROLLS- 112702 520.75 PAYROLL}OR- 121202 520.75 2472.64 07337 INFOCUS 1 ANALOG CONPUTER CABLE UNDVIA 38.00 01725 INLAND DETROIT DBISEL-ALLIBON REPLACE CRDUN~T CYLINDER HEAD 4924.85 06697 IETEGRATEDCONPUTHE SOLUTIONS PROFESSIONALRERVICBS 3453.60 00353 JANONIS, MICHAEL E. LUNCH/HEETmE 90.28 RAFFLE PRIZES 173.32 263.60 04565 ~ERON1MUS, DELORES 06691 ~JETTIRES PTRD2002 59.85 TIRES MOUNTED/BALANCED 225.67 01794 KA~B UNIFORMS, INC. 01825 K~EIN, CATHERINE 01072 LNTTOF CHEVROLET, INC. 07427 LIFE HOSPICEHOUSB POLICADHET RETCHES 375.70 PT~2002 43.65 113977 71.27 DONATION-LEON KASHI4ERE 50.00 01911 LUNBCRE, ANNAM. t~RD2002 91.10 01918 LUNDSTRUN'SRUNSENT LAMDSCAUNMAINT. 2201.33 04502 LYP, ARDEHE P. 06479 M & B LANDSCAPING ETRD 2002 BULBS B~ 100.00 2664.50 703.84 3368.34 05757 MAGNUSSUN, MIRE 01945 MALONE, MARIE 01965 MRETAM CONSTRUCTION TESTHEGIETRATIUN 96.00 ~TRG2002 100.00 SUNERREPNTUN 9986.00 REPORT: APBOARDRPT GENERATED: 31 JUL 02 07:58 RUN: WEDNESDAY DECl12002 16:08 PAGE 6 RELEASE ID : VIL~GE OF MOUN~ PROSPECT LIST OF DILLS PRESENTED TO THE BOARD OF TRUSTEES FR~ NOVEMBER 26 2002 TO DECEMBER 11 2002 DE~T VENDOR NBR VENDOR NANE INVOICE DESCRIPTION REOUNT 05921 MENARDS MISC.ITEMS 38.81 01502 ME$, INC./GLOBAL AIR CLEANER 127.73 01998 MESSMER, RATRARIRA ~TRG 2002 100.00 00116 METRO FEDERAL CREDIT UNION PAYROLL FOR - 112702 1365.00 PAYROLLFOR - 121202 1365.00 2730.00 00117 METROPOLITAN ALLIANCE - POLICE PAYROLL FOR - 112702 602.00 PAYROLL FOR - 121202 596.00 1198.00 02014 MID-AMERICA TR. & EQUIP.CO.INC INSTALL FRONT SWITCHES 239.31 02022 MIDWEST HOMICIDE INVEST. ASSN. ANN]AL DUES 25.00 02028 MIGETY MITES AWARDS & BUNS FAM RIRE T-SHIRTS 500.00 02036 MILNER, WM. E. PTRG2002 100.00 06489 MIOUUSZEWSRA, ELZBIETA PTRG 2002 89.24 02046 MOBILE PRINT INC. ENVELOPES 96.97 WINTER PARADE POSTERS 19.74 116.71 02065 M(IfT, GRACE F. NTRG 2002 90.82 02066 ~OUNT PROSPECT CHAMEER OF CC~ERCE ~ERE~IP-INV4009 300.00 02067 MOUNT PROSPECT RISTORICA~ SOC. DEMEMEER PMTS 3333.37 02069 MOUNT PROSPECT RARKDISTRICT UN LEASE 1023.00 07406 MYRON CORPORATIOU SUPRDIRS 230.32 02134 NATIONAL PUBLIC EMPLOYER LABOR MEMEERSNIP-DAVE STRAHL 190.00 00123 NATIONWIDE PAYROk~ FOR - 112702 14848.15 02148 NEOPOST INC. POSTAGE TAPE 89.40 02155 NEMTEA C(i'~JJNICATIO~S ACCT#684010511 899.66 ACCT%684010511 120.00 ACCT#684920512 482.58 LOUT#741030517 235.06 LOUT#741330510 699.96 ACCT,982210515 108.71 2595.97 REPORT: AFEOARDRDT GENERATED: 31 JUL 02 07:58 RUN: ~EDNESDAY DECll2002 16:08 PAGE 7 RELEASE ID : VILLAGE OF MOUNT ?RO~PECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVENRER 26 2002 TO DECE~EN II 2002 DEPT VENDOR NBR VENDOR NAME INTOICE DESCRIPTION AMOUNT 02170 NORTH fAST MOLTI REGIONAL T~G RE~ISTER D.OKON 10.00 02195 NORThT~EST FORD TRUCK CENTER PARKING BRAKE ASSEMBLY 124.20 02196 NONTH~EST MUNICIPAL CONFERENCE FRAINING 130.00 02199 NORTHWEST STATIONERS INC. NTSC.OFFICE SUPPAIES 20.52 02249 OTTOSEN TREVARTNEN BRITZ KELLY & ~EGAL EXPENSES 345.00 06033 PADDOCK PUBLICATIONS AD FOR P/T NURSE 421.50 02256 PADDOCK ENULICATICES, IKC. ~SBLIC NOTICES 505.27 02258 PAERE, FRANCESCO PTRE2002 100.00 05026 PAYFOREANCE CORD. ]~moal Software Support Servic 1850.00 02285 PEDE~SEN & EOU~T SERVICES 706.45 06619 RETERDONSEWER REFUND 50.00 REF(IRD 33.00 83.00 02303 PETTY CASH - FIRDDEPT. I~TINGSTPJqGSUPP 34.03 }~"~INGS TENGSURD i9.80 RENTINGS TENG SUPP 6.60 MENTINGSTRNGSUPE 8.64 MEETINGS TENGSUPP 7.99 ~]i{GS TEN~ SUPP 9.66 ~INGSY~GSUPP 43.28 ~INGS T~G SUPP 27.49 ~INGS ~G SUPP 10.20 167.69 02304 RETTYCASH -POLICEDEPT. OTBRESERVlCES 5.60 TRAIKINGE~PENRES 284.61 B~UIPMAINT 24.35 OFFICE SOPP 2.10 316.66 07410 PLANNED LIGHTING, INC. 00124 POLICE PENSIOM ESND L~OTALLATIOM OF HOLIDAY LIGHTS REYROLL FOR - 112702 ?AFROLL FOR- 121202 18962.19 20978.50 19116.23 40084.73 04921 PORE, ELIZABETH A. ?AYROLLFOR- 112702 923.08 PAYROLL FOR - 121202 923.08 1846.16 06661 ?~OFRICE PROD. SUPPLIES 127.37 REPORT: ANBOARDRET GENERATED: 31 JUL 02 07:58 ~UN: WEDNESDAY DECl12002 16:08 PAGE 8 WEL~SE ID : VILLAGE OF MOUNT PROSPECT LIST OF PILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2002 TO DECemBeR 11 2002 DENT VENDOR NBR VENDOR NAME IN{OICE DESCRIPTION ~OUN? 02350 PRIMEDIA WORKPLACE LEA~ING TRAI~ING VIDEO 136.00 02536 PROFORMA SAN~A NATS 449.82 02379 QUILL CORPORATION OFFICE SUPPLIES 159.10 02393 RAY O'PERRON CO. L~{IFO~ EXPENSE 480.00 ~HI~OR~ ~/RENRE 84.90 564.90 02428 RIB~DO, VIO~ K. ~ 2002 100.00 07395 S~ED, PUR~Z ~TE FOR 4 S~A~S OF PUBLIC 308.00 04673 S~ BE~DINO CO~Y CHILD SUPPORT PAINTS P~LL FOR - 112702 115.38 P~OLL DR - 121202 115.38 230.76 02490 SARGE'S ~GE SERVICE S~CE 550.00 02495 SAYE~ C~P~ER SOURCE H~ ~E~T 95.00 07313 SC~ SO~ INC. S~ UPG~DE 112.89 02497 SOMI~SKI, HEL~ T. ~ 2002 I9.71 06073 SDER, PATRICK, J. ~ 398.52 00125 SEIU L~L 73 P~O~ FOR - 112702 6~7.54 P~LA DR- 121202 591.t2 1198.66 02542 SHREP PEST C~ROL ~ C~ROL SERVIC~ 295.00 02554 SIMPL~ TIME ~ODER CO. ~ SERVICE CO~ 1488.50 02592 SPECIAL T ~LIMITED Y~H C~ISSIOM T-SHIRTS 548.70 04454 ST. VIATOR HIGH SCH~L ~ PR~ ~NATIOM 200.00 02650 STROMC~, ~CES ~ 2002 100.00 05463 S~R~ELD F~ ~D~R ~ 700.00 02672 SYST~S ~S, INC. ~TIC C~DS 210.60 ~R S~S 295.00 505.60 06163 SZABO'S ~SONRY S~5ING ~SSI~ C5~ 9950.00 04532 TAYLOR ~ CE~ER ~ EQUIP 378.00 REPORT: APBOARUNRT GENERATED: 3t UNL 02 07:58 RUN: ~EDNRODAY DECl12002 16:08 PAGE 9 RELEASE ID : VILLAGE OF MOUNT PROSPFA~T LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOV~MRER 26 2002 TO DEC,AR 11 2002 UNiT VAR~OR NBR VENDOR NAME INVOICE DESCRINTION AMOUNT 02680 TELETRAC, INC. 02684 TERRACE SUPPLY COMPANY 02691 THOMPSON ELEVATOR INSPECTIONS 02701 TONER, VIOLET E. 00127 UNITED WAY 02467 URBAN RETAIL PROPERTIES CO. 00128 VIL~AUN OF MOON~ ~ROSUNCT 04314 VILLAGE OF MOUNT PROSPECT - PAYROLL WIRES 07418 VITAROA 02832 I{AI~fANT CO~9~]NITY ARC 02835 ~P, ENOUNE DIRECT 02848 ROILAR AN~NOR, INC. 06544 WUNUT, BIRDELL L. 02870 ROOLROADE DIRECT INC. 02877 WILL COUNTY GO~AD LEAGUE 06001 WINKLER'S TRUNSARVICE 05746 WIECTF 02891 WO,TWICKI, WA~TAR SERVICES 1213.95 MISC.BODY REPAIR SUPPLIES 242.22 REIROPECTIUNS 315.00 ~RG2002 82.34 PAYROLL FOR - 112702 394.18 PAYROLL FOR - 121202 330.26 724.44 DEC 2002 2000.00 ?~g~L~OM- 112702 16663.99 VOIUERFOR- 112702 23.30- PAYROIJ~ FOR - 112902 0.30 PAYI~)~L FOR - 121202 16611.27 33252.26 PAYROI&FOR - 112702 164846.13 PAYROI, I, FOR - 112702 14581.26 PAYRO~FOR - 112702 14946.65 194374.04 OVRE~A~I~A'~ 25.00 FIARREOCESSING/SUP? $9.66 UNF~IES 250.69 6750.00 600.00 12600.00 19950.00 ~TRG2002 96.72 REPAIR PARTS 117.86 2003-2004 TADS 335.18 VE~ICI~ STICKERS 5046.00 5381.I8 NTUN~R]9~OVA~S 4634.58 PAYROLL~OR- 112702 542.48 PAUNOLL FOR - 121202 542.48 1084.96 PT~2002 100.00 REPORT: AREOARDRPT GENERATED: 31 JUL 02 07:58 RUN: WEDNESDAY DECl12002 16:08 PAGE 10 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM NOVEMBER 26 2002 TO DECEMiBER 11 2002 DEPT VENDOR NBR VENDOR NANE INVOICE DESCRIPTION 02896 WORLD WINDOW CLEANING CO INTERIOR/EXTERIOR 2399.00 TOTAL 537686.60 030 01639 AMERICAN NATIONAL BANK TIPFING FEES 97453.69 FIXED COSTS 32446.92 129900.61 01780 AMERITECH SERVICE 20.06 02270 AT & T SERVICE TOTAL 8.79 129929.46 O5O 01382 ALDRIDGE ELECTRIC, INC. TRAFFIC SIGNAL 2140.00 06136 AMERICAN GEOENGINEERING,tNC. MATERIALS TESTING SERVICES 2550.00 01718 NORTH AMERICAN SALT COMPANY ROAD SALT 7180.13 ROAD SALT 2001.97 9182.I0 TOTAL 13872.10 O70 01090 CHILDREN'S ADVOCACY CENTER APRIL-JUNE BILLING 750.00 00335 FOLEY, APRIL B. REIMBURSEMENT 109.71 RE~MESEMEMT 144.00 REI~UREE~/~ 129.00 EMI)~OESEMENT 35.00 REIMBURSEMENT 36.59 REIMBUESEME?{T 18.66 REIMUESEMENT 22.00 REIMBURSEMENT 200.00 691.46 08945 JOBRNEY'S FROM PADS TO HOPE SERVICE 625.00 04621 STANLEY CONSULTANTS ENGINEERING SERVICES 3644.0i TOTAL : 5710.47 510 04952 CIOREA GROOP INC. REHABILITATION PROJECT 3607.23 PROFERSIONALSERVICRS 715.34 ENGINEERING SERVICES I272.00 5594.57 06420 UNAYBAR ELECTRIC CO. POLES 5280.00 ~PORT: AREOARDRPT GENERATED: 31 JUL 02 07:58 RUN: ~CEESDAY DECll2002 16:08 PAGE 11 REL~SE ID : VILLAGE OF MOENT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES RECE NOVEMBER 26 2002 TO DECEMBER 11 2002 DUPT VENDOR NB}{ VENDOR NAME INVOICE NESCEIFIION AMOUNT 525 550 860 610 01965 MARTAM CONSTRUCTION CORRIDOE IMPROVERENT 73536.42 PARK ~OND 94249.92 167706.34 05777 V3 INFRASTRUCTURE SERVICES ENGINEERING SERVICES 07299 ZO.LL EEDICAL CORPORATICE 4 ZOAL M SRKIES 3 BDUER CHARG FRT 937.33 74428.00 85.70 74513.70 TOTAL 254111.94 06310 DLK ARCHITECTURE, INC. ARCHITRCTRAL FEES 111282.10 07102 ENGINEERING CONSULTING SENVtcES PHASE II TESTING 45.00 07350 NS ENVIRCEIg/F1AL ASSOCIATES ADDITIONAL ASBESTOS TESTING 250.00 07416 LVI ENVIRONMENTAL INC. ASBESYOS R~4OVAL 12973.00 07045 V;.B.ULSCE, INC. SENIOR CTE DEM. 37722.00 TOTAL 162272.10 07267 I, RE BAV54ENT CO. INSTALL BRICK 05777 V3 INFRASTRUCTURE SERVICES ENGINEERING SERVICES TOTAL 1100.00 2652.73 3752.73 01620 AMERICAN LAMDSCAPIRG lng. 02167 ARRORROAD CONSTRECTI~ PAREl%%Y NENTORATION 2002 STREET RESORERCING 2002 NTREETRESURFACINE 9888.75 240779.42 125865.52 366644.94 T~AL 376533.69 05222 ANERICAN INDUSTRIAL 01620 AMERICAMIANDUCAPINEINC. 01780 AMERITECH UNIFORN ULEAMING & RENTAL PAREi~%Y RESTORATION PARAMAY RESTORATION PARA, AY NESTOP~TION 464.40 2930.05 3840.75 2605.20 9376.80 SERVICE t239.05 SERVICE 223.88 SERVICE 1339.26 REPORT: APBOARERPT GENERATED: 31 JUL 02 07:58 RUN: WEDNESDAY DEC112002 16:08 PAGE 12 RELEASE ID : VILLAGE OF MOUNT PROSPECT LIST OF RILLS PRESENTED TO THE ROARD OF TRUSTEES FROM NOVOMBEN 26 2002 TO DECEMBER 11 2002 DE~T VENDOR NBR VENDOR RA~E INVOICE DESCRIPTION AMOUNT 2801.89 02270 AT & T SERVICE 586.78 07414 BOSE, DAVID RE,ND 7.98 05375 CENTURY CLEANERS UNIFORM CLEANING 72.25 04991 G & M INC. CONCRETE RESTORATION 1076.23 CONCRETE RESTORATION 107.95 1184.18 07396 GEOANALYTICS INC. WEB IMPLEmeNTATION 9050.46 01544 HEN WATER METER SERVICE HBK WATER~ETER 1260.00 HBK WATERMEN 594.I0 REKWATER]~TER 300.00 ENKWATER~ER 487.00 HBKWATER~NTER 79.00 REK WATER}~'~ER 155.00 REK~AT~ER 37.50 ENKHATEB~ETEN 415.10 3327.70 01787 JULIE, INC. 07412 I~RMORE, SHARON 07260 MACKOW, MICHAEL 02042 MIN~TENAM PRESS RERVICESCHARGES 307.20 REFUND 19.95 REFUND 47.88 PRINTING OF1000 DOOR HAMGER N 179.39 05517 PADDOCK PUENICANTOMS PUBLICNTIOM OF 7 BID NOTICES 289.20 04838 THIRD MILLENNIUMASSDO.INC. UTILITY BILLING SERVICES 1663.05 02773 U.S. BAMK TRUST WATER 125934.00 POWER 11515.00 O & M 18058.00 FIXED 93674.00 249181.00 07411 UDE, ERIC OVERPAYMENT 48.28 07126 WOODARD & CENHAN INC. SERVICES 24343.00 TOTAL : 302951.39 630 05503 CRYSTAL MGMT. &MAINTENANCE CUSTODIAL SERVICES 5760.00 06479 M & B LANDSCAPING BULBS 1331.66 R~PORT: APBOARDRPT GENERATED: 31 JUL 02 07:58 REN: WEDNESDAY DRCl12002 16:08 PAGE 13 RELEASE ID : VILLAGE OF MO[~{~ PRO~RECT LIST OF BILLS PRESENTED TO TEE BOARD OF TRUSTEES FRC~NOVEMBER 26 2002 TO DECEWRERll 2002 DENT VENDOR NBR VENDOR ~E INVOICE DESCRIPTION AMOUNT 02754 UNION PACIFIC k~ILROAD MD LEASE 1785.23 66O 670 TOTAL : 8876.89 05048 965-PREXAIR DISTRIBUTDON,INC. OXYG~ CUTTING TORCH 14.50 OXYGEWC~TING TORCH 444.61 459.11 01780 ~RITECH SE~/CE 50.15 02270 AT & T S~REICE 21,98 01236 DAW & JIM'S AUTO BODY, INC. REZ~I~T PATROL CA~S 2124.00 05579 EIM}~RST LINCOEW ~ERC~Y FO~) CRO~9~ VICDORIA mD FORD T 1804.27 03958 FREUND I~ERNATI~ I~'EW~ATtONAL REPAIR PA~TS 751.78 06691 JUST TI~ES P225/75~6 DOODYEA~ EAGLE ~a 695.76 ST~ TI~ ~E t2.00 707.76 01914 f~D tNDUST~RE, INC. P~C SALTY CODE 372.15 01974 ~TCO T~ S~00B ~T~ SOLD~NG IRON 85.95 ~CE IM~ICE 0.20- 85.75 02402 ~DI-ST~P ~IONC~ROL SURE,GE 44.80 ~T ~I~R - ~EICLE 94 560.00 604.80 02610 S~gP~ EQUI~ C~P~ 5A845~C~SS ~TER CYLIMDE 174.02 4~25 T~C~ESS B~ S~TCH I5.32 6~3344 E~IN ~R CYLINDER 444.95 634.29 ~2684 TE~CE SUPREYC~P~Y ~CREINDER~ 6.40 04472 T~O~ PETROL~CO ~AI~ 8500.44 05004 ~REZ~SS S~ 63.61 T~ : 16186.49 02525 NBORETA~Y OF ETATE uCEWSB PLATE RENEWAL 70.00 ALREHEW PLATE RENEWAL 234.00 312.00 REPORT: APBOARDRPT GENERATED: 31 JUL 02 07:58 RUN: ~EDNEGDAY DECl12002 i6:08 PAGE 14 RELLASD ID : VILLAGE OF MCUNT PROSPECT LIST OF DILLS PRESENTED TO THE BOARD OF TRUSTRES FROM NOVEMBER 26 2002 TO DECEMBER 11 2002 REPT VENDOR NBR VENDOR NEME INVOICE DESCRIPTION AMOUNT TOTAL 312.00 690 710 720 770 79O 01102 CITIBANK, N.A. 01737 INTERGOVERlqt4ENTAL PER.BEN.COOP INS CLAIMS-GAB 7407.06 INSURARCE 7777.50 INSURANCE 68618.01 IEGENARCE 1801.70 INSURANCE 202086.52 280283.73 01966 MARTIN BOYER COMPANY,INC MORKEEGCOMP X-NOV WOkKENS COMP X 7829.89 27861.42 35691.31 TOTAL 323382.I0 02637 BECEMR, BURKE ASSDOIATEG INC POLICE PENSION 05987 BURKE~4RER, LISA PENSION FUND FILING 07263 RICHARD REIMER & ASSDO.,LLC. LEGAL FEES TOTAL 5000.00 156.25 265.70 5421.95 02637 BECENR, BURKE ASSOCIATES INC FIRE PENRION TOTAL 5000.00 5000.00 01405 FIRST CC{~YOMWEALTN PRENIOMFOR12/2002 TOT~ 3216.71 3216.71 07409 ALGONQUIN-BUDGE CURRENCY EXCHANGE <NEREAYMENT 00111 INDIANA DEPT OF REVEMUE INCOME TAX NOV.02 05340 JAKOBOWSKI, ERIC RE~)ND 07408 MID-CITY NATIONAL BANK REFUND 05368 NAUERTBUILDEEG, INC. REFUND 06619 PETEEGONSENER REFUND 07212 PIRRONE, CRISTOFARO REF~ND~OMD 07417 RAINCOAT ROOFING REFUND 02529 SEMARNOMEBUILDERE REFUND 36.00 I49.09 25.00 7733.00 2554.00 500.00 450.00 t00.00 13330.00 'REPORT: AREOARERPT GENE~TED: 31 JUL 02 07:58 RDN: ~EDNESDAY DBClt2002 i6:08 PAGE 15 RELEASE ID : VILLAGE OF MOUNT PRONUECT LIST OF BILLS PRESENTED TO TEE BOARD OF TRUSTEES FRON NOVEMBER 26 2002 TO DECEMBER I1 2002 DEPT VENDOR NBR VENDOR NA~E INUOICE DESCRIPTION A~OUNT 07407 SKLEPINSKI, JOHN RE~D BOND 100.00 ~EFU~D DEMOLITION 25.00 125.00 02622 STATE OF ILLINOIS LIQDOB APPLICANT 38.00 LIQUOR APNEICANT-PU SAN 30.00 76.00 02689 TEIRDDISTRICTCIROUIT COURT 02808 VILAARE OF MOUNT PROSPECT 07405 WILKIE, IDA 04990 WISCONSIN DEPARTMENT OF REVENUE 05354 WOLFSON-YOUNG BOND MONEY 2400.00 BOND MONEY 725.00 BOND MONET 2150.00 BOND MONEY 050.00 EOND MONEY 1051.00 7976.00 NESTORETION DEP 6355.00 DONPSTER DEPOSIT 100.00 6455.00 BONDNENUND 02-2101 100.00 NESC. INCONE TAX 584.36 REFUND 21984.00 TOTAL : 62177.45 GRAND TOTAL : 2211394.07 REPORT: APROARDRPT GENERATED: 31 JUL 02 07:58 RUN: WEDNESDAY DECli2002 16:08 RELEASE ID : VILLAGE OF MOUNT PROSPECT PAGE 16 LIST OF BILLS PP~ESENTED TO THE BOARD OF TRUSTEES FROM NOVLMBER 26 2002 TO DECEMBER 11 2002 $~%~ARY BY FUND 001 GENERAL F~3ND 537686.60 030 REFUSE DISPOSAL FUND 129929.46 050 MOTOR FUEL TAX FUND 13872.10 070 CC~NITY DE~ELP~T BLOCK GRNT 5710.47 510 CAPITAL IMPROVL~ENT FOMD 254111.94 525 SERIES 2001 PROJECT FUND 162272.10 550 DOWETOWN~DEVL[~{ffCOMST 3752.73 560 STREET IMPROVL~ENT CONST ~ND 376533.69 610 WATERED S~R ~D 302951.39 630 PA~IRO SYST~VENUE ~ND 8876.89 660 VEHICLE ~I~EN~CE ~ND 16186.49 670 VEHICLE ~P~C~ ~ND 312.00 690 RISK~AG~ ~WE 323382.10 710 POLICE PENSIONED 5421.95 720 FI~ PENSION~RO 5000.00 770 5~C~P ESCR~ ~RO 3216.71 790 ESCROW DEPOSIT~D 62177.45 TOTAL: 2211394.07 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES January 1 ~ November 30, 2002 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary os/os/o2 - sS/ o/o2 11 Months ( i Month ( 91.6% ) Completed 8.3% ) Remaining Cur Mo Y-T-D 2002 Received Received Budget Unreceived Unreceived Balance Percent REVEN~ BY CL~SIFICATION PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CF~%RGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS RE%~END~ BY FUND GENEP~ FUND REFUSE DISEOSltL FUND MOTOR FUEL TAX FUND LAW ENFORCEMBNT BLOCK GRANT COMMUNITY DEVELP~T BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND SERIES 1987A B&I, PW FACILITY SERIES 1993B B&I, PUBLIC BLDGS SERIES 2001 B&I, VILLAGE F=~LL SERIES 2003 E&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BI~S SERIES 2002A E&I, TIF SERIES 1993A B&I, TIF SERIES 1994B B&I, TIF SERIES 1996B B&I, TIF SERIES 1998B B&I, TIF SERIES 1999 B&I, TIF SERIES 1992A B&I, FLOOD SERIES 1993B B&I, FLOOD SERIES 1994A B&I, FLOOD 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 1994A B&I, SERIES 1996A B&i, SERIES 1998A B&I, STREET IMP. STREET IMP. STREET IMP. SERIES 2002B B&I, STREET IMP. SERIES 2002 LIBRARY BONDS B&I CAPITAL IMPROVEMENT FDI~D POLICE & FIRE BLDG CONST FUND SERIES 2001 PROJECT FUND 4,191,352 10,286,008 10,477,382 191,374 1.8 2,197,827 16,269,635 18,307,694 2,038,059 11.1 107,431 3,019,756 3,000,200 -19,556 -0.7 725,484 6,169,537 8,893,630 2,724,093 30.6 1,147,839 12,070,495 13,358,904 1,288,049 9.6 29,249 536,153 434,400 -101,753 -23.4 283,343 -928,451 5,194,738 6,123,189 117.9 20,029 564,707 561,410 -3,297 -0.6 789,774 3,302,044 3,408,988 106,944 3.1 0 8,732,348 8,742,463 10,115 0.1 9,488,324 60,022,192 72,$79,409 12,867,217 17.1 4,520,295 26,089,962 28,382,315 2,292,353 8.1 1,115,030 3,374,873 3,457,972 83,099 2.4 134,851 1,496,816 1,624,395 127,579 7.9 12,167 38,597 18,410 -20,187 -109.7 103,933 656,500 461,265 -195,235 -42.3 657 34,199 0 -34,195 0 20,316 0 -20,316 208 8,084 0 -8,084 44,968 111,840 111,509 -331 -0.3 0 2,535,838 561,009 -1,974,829 -352.0 9,060 391,023 393,592 2,569 0.7 0 0 0 0 221,649 759,819 0 -759,819 63,773 505,405 0 -505,405 0 734,552 244,025 -490,527 -201.0 0 0 0 0 33,107 120,631 124,188 3,557 2.9 13,950 50,673 81,990 1,317 2.5 100,104 367,175 378,736 11,561 3.1 0 0 0 0 0 1,119,541 281,814 -837,727 -297.3 0 574,428 249,947 -324,481 -129.8 18,767 182,829 213,904 31,075 14.5 1,300 69,298 104,285 34,987 33.5 41,293 150,420 154,985 4,565 2.9 50,398 564,912 686,259 121,347 17.7 2,820 36,769 46,802 10,033 21.4 22,845 515,369 0 -515,369 0 1,844,888 692,671 -1,152,217 -166.3 0 0 0 0 65,793 728,811 908,999 180,188 19.8 30,880 742,304 0 -742,304 0 0 0 0 101,228 257,878 1,048,150 790,272 75.4 0 0 0 0 5,628 76,216 139,588 59,372 43.8 VILLAGE OF MOUNT PROSPECT Budget Revenue Summary 01/01/02 - 11/30/02 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining Cur MO Y-T-D 2002 Received Received Budget Unreceived Unreceived Balance Percent SERIES 2003 PROJECT FUND 2002 LIBRARy PROJECT FLrND CAPITAL IMPROVEMENT CONST FUND DOWNTOWN REDEVLP~T CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST 1998A FLOOD CONTROL CONST FUND WATER ~/~D SEWER FUND PARKING SYSTEM REVENUE FUND VENICLE MAINTENANCE 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 ME~DOWS B&I SSA #6 GEORGE/ALBERT B&I Total All Funds 0 0 8,388,293 8,388,293 100.0 0 0 0 0 48 2,397 0 -2,357 0 626,533 1,000 -625,533 ****.* 160,623 1,627,060 1,854,992 227,932 12.3 0 0 0 0 2,168 52,659 1,075,000 1,022,341 98.1 1,156,309 7,303,815 8,042,712 730,897 9.2 13,524 167,149 202,200 35,051 17.3 96,631 1,062,045 1,155,478 93,433 8.1 82,169 973,407 1,060,651 87,244 8.2 16,750 183,806 200,053 16,247 8.1 294,214 3,421,288 3,831,663 410,375 10.7 452,835 -86,536 3,093,939 3,180,075 102.8 484,265 491,421 3,103,370 2,611,949 84.2 21 836 1,100 264 24.0 0 0 0 0 0 0 0 0 14,063 36,390 36,548 158 0.4 9,488,324 60,022,192 72,379,409 12,357,217 17.1 FRRBRR03 SUM 021 ll Months ( 91.6% ) Completed 1 Month ( 8.3% ) Remaining VILLAGE OF MOUNT PROSPECT Budget Revenue by category within Fund S%ur~aary 01/01/02 - 11/30/02 C~r MO Y-T-D 2002 Received Received Budget Unreceived Unreceived Balance Percent GENERAL FUND 40 PROPERTY TAXES 2,923,211 7,172,997 7,305,151 132,154 1.8 41 OTHER TAXES 967,593 10,082,996 11,124,618 1,041,522 9.4 42 LICENSES, PERMITS & FEES 105,594 2,792,823 2,755,000 -27,823 -1.0 43 INTERGOVERMENT REV. 390,848 3,968,743 5,189,410 1,220,667 23.5 44 CHARGES FOR SERVICE 78,074 695,175 780,176 85,001 10.9 45 FINES AND FORFEITS 24,408 474,521 434,400 -40,121 -9.2 46 INVESTMENT INCOME 13,036 254,706 345,000 90,294 26.2 47 REIMBURSEMENTS 14,660 437,517 307,710 -129,807 -42.2 48 OTHER REVENUE 2,871 210,484 130,850 -79,634 -60.9 TOT~LOENERAL FUND 4,520,295 26,089,962 28,382,315 2,292,353 8.1 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 993,649 2,439,017 2,493,722 54,705 2.2 44 CHARGES FOR SERVICE 118,135 899,541 915,250 15,709 1.7 46 INVESTMENT INCOME 3,182 36,244 49,000 12,756 26.0 48 OTHER REVENUE 64 71 0 -71 TOTAL REFUSE DISPOSAL FUND 1,11S,030 3,374,873 3,457,972 83,099 2.4 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 130,948 1,453,116 1,554,245 101,129 6.5 46 INVESTMENT INCOME 2,817 40,216 70,000 29,784 42.5 47 REIMBURSEMENTS 1,086 3,484 150 -3,334 ****.* TOTAL MOTOR FUEL TAX F~ 1~4,851 1,496,816 1,624,39S 127,879 ?.9 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVERMENT REV. 12,173 38,531 18,410 -20,121 -109.3 46 INVESTMENT INCOMH -6 66 0 -66 TOTALLAW ENFORCEMENT BLOCK G~ 12,167 38,597 18,410 -20,187 -109.7 CO~4UNITY DEVELP~gT BLOCK GRNT 43 INTERGOVERMENT REV. 103,915 621,547 404,465 -217,082 -53.7 46 INVESTMENT INCOME 18 34 0 -34 48 OTHER REVENUE 0 34,919 86,800 21,881 38.5 TOTAL COMMUNITY DEVELPMNT BLO(IK GRNT 103,933 656,800 461,265 -195,238 -42.3 ASSET SEIZURE FUND 45 FINES A~D FORFEITS 637 33,887 0 -33,887 46 INVESTMENT INCOME 20 308 0 -308 TOTAL ASSET SEIZURE F~ND 687 34,195 0 -34,195 DHA SHARED FUNDS FUND 45 FINES AND FORFEITS 0 19,745 0 -191745 46 INVESTMENT INCOME 0 571 0 -571 FRRBRR03 SUM 02i Budget 11 Month~ ( 91.6% ) Compl~eted 1 Month ( 8.3% ) Remaining VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/02 - 11/30/02 Cur MO Y-T-D 2002 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 E&I, TIF SERIES 1996B B&I, TIF 41 OTRER TAXES 46 IErVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 1996B B&I, TIF SERIES 1998B B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME TOTAL EERIES 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 OTHER 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 OTMER FINANCING SOURCES TOTAL SERiES 1994A B&I, FLOOD SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 IN~ESTMHNT INCOME 0 734,552 244,025 -490,527 -201.0 0 0 0 0 0 0 0 0 0 0 0 0 32,960 119,336 122,097 2,761 2.3 147 1,295 2,091 796 38,1 0 0 0 0 93,107 120,651 124,198 3,557 2.9 13,904 50,341 SI,SOS 1,164 2.3 46 332 485 153 31.9 13,960 50,679 51,990 1,317 2.5 99,882 361,634 370,000 8,366 2.3 222 5,541 8,736 3,195 36.6 0 0 0 0 100,104 367,176 978,736 11,661 9.1 0 0 0 0 0 0 0 0 0 0 0 0 0 68,377 276,000 207,623 75.2 0 459 5,814 5,355 92.1 0 1,060,709 0 -1,050,705 0 1,119,541 281,814 -837,727 -297.3 0 49,151 245,698 196,547 80.0 0 224 4,249 4,025 94.7 0 525,053 0 -525,053 0 674,428 249,947 -324,481 -129.8 18,580 181,079 210,000 28,921 13.8 187 1,750 3,904 2,154 95.2 3 .12/11/2002 16:02:00 FRRBRR03 SUM 02i 11 Months ( 91.6% ) Completed i Month ( 8.3% ) Remaining VILLAGE OF MOUNT PROSPECT Budget Revenue by category within Fund summary 01/01/02 - 11/30/02 Cur Mo Y-T-D 2002 Received Received Budget Unreceived Unreceived Balance Percent TOTAL SERiES 1998A B&I, STP~EET IMP. 85,793 728,811 908,999 180,188 19.8 SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES 30,201 338,991 0 -338,991 46 INVESTMENT INCOME 679 5,461 0 -5,461 49 OTHER FINANCING SOURCES 0 397,852 0 -397,852 TOTAL SERIES 2002B BRI, STREET IMP. 30,880 742,304 0 -742,304 SERIES 2002 LIBRARY BONDS B&I 43 INTERGOVERMENT REV. 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 TOTAL SERIES 2002 LIBPJ%RY BONDS B&I 0 0 0 0 CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 87,600 87,600 727,100 639,500 46 INVESTMENT INCOME 4,178 58,553 87,000 28,447 47 REIMBURSEMENTS 0 56,375 193,550 137,178 48 OTHER REVENUE 9,450 55,350 40,500 -14,850 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL CAPITAL IMPROVEMENT FUND 101,228 287,878 1,048,150 790,272 POLICE & FIRE BLDG CoNsT FUND 46 INVESTMENT INCOME 0 0 0 0 TOTAL POLICE & FIRE BLD(~ OONST FUND 0 0 0 0 88.0 32.7 70.9 -36.7 75.4 CAPITAL IMPROVEMENT CONST FUND 43 INTERGOVERMENT REV. 0 0 0 0 46 INVESTMENT INCOME 48 2,357 0 -2,357 2002 LIBRARY 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 LIBP-%RY PROJECT FUND 0 0 0 0 SERIES 2003 PROJECT FUND 46 INVESTMENT INCOME 0 0 73,293 73,293 100.0 49 OTHER FINANCING SOURCES 0 0 8,315,000 8,315,000 100.0 TOTAL SERIES 2009 PROJECT FUND 0 0 8,988,293 8,388,293 100.0 SERIES 2001 PROJECT FUND 46 INVESTMENT INCOME 5,628 76,216 135,588 59,372 43.8 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL EERIES 2001 PROJECT FUND 5,628 76,216 135,588 S9,372 43.8 12/11/2002 15:02:00 FRRBRR03 SUM021 Budget 11 Months ( 91.6% ) Compl-eted VILLAGE OF MOUNT PROSPECT i Month ( 8.3% ) Remaining Revenue by Category within Fund Summary 01/01/02 - 11/30/02 Cur MO Y-T-D 2002 Unreceived Unreceived Received Received Budget Balance Percent VEHICLE MAINTENANCE FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE TOTAL VENICLE F~%INTEN~NCE FUND VEHICLE REPLACEMENT FUND 44 C~ARGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES TOTAL VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME RISK MANAGEMENT FUND 43 INTERGOVERM~T REV. 44 CH~.RGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE TOTAL POLICE PENSION FUND FIRE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENq3E TOTAL FIRE PENSION FU~D BENEFIT TRUST #2 FUND 46 INVESTMENT INCOME TOT~BENEFIT TRUST #2 FUND ESCROW DEPOSIT FUND 46 INVESTMENT INCOME 95,918 1,055,070 1,150,978 95,908 $.3 713 6,975 4,600 -2,475 -55.0 0 0 0 0 96,631 1,062,045 1,155,478 93,433 8.1 67,555 743,098 810,651 67,553 8.3 14,614 186,309 190,000 3,691 1.9 0 0 0 0 0 44,000 60,000 16,000 26.7 82,169 973,407 1,060,651 87,244 8.2 15,685 172,528 187,053 14,525 7.8 1,065 11,278 13,000 1,722 13.2 16,750 183,806 200,053 16,247 8.1 0 0 0 0 232,731 2,676,296 3,002,984 326,688 10.9 4,307 68,083 105,750 37,667 35.6 4,283 67,331 60,000 -7,331 -12.2 52,893 609,678 662,929 53,361 8.0 294,214 3,421,288 3,831,663 410,375 10,7 103,020 -1,288,493 1,824,000 3,112,493 170.6 349,816 1,201,957 1,269,539 67,582 452,835 -86,536 3,093,539 3,180,075 102.8 111,497 -682,376 1,880,000 2,562,376 136.3 372,768 1,173,797 1,222,370 49,573 4.1 484,265 491,421 3,103,370 2,611,949 84.2 21 836 1,100 264 24.0 21 836 1,100 264 24.0 0 0 0 0 0 0 0 0 12/11/2002 16:02:04 FRRBRR03 SUM 021 il Months ( 91.6% ) Completed i Month ( 8.3% ) Remaining VILLAGE OF MOUNT PROSPECT Budget Revenue by catego~ Within Fund Summary ol/oi/o2 - il/3o/o2 Cur MO Y-T-D 2002 Unreceived Unreceived Received Received Budget Balance Percent GENERAL FUND 40 PROPERTY TAXES 2,923,211 7,172,997 7,305,151 132,154 1.8 41 OTHER TAXES 967,893 10,082,996 11,124,618 1,041,622 9.4 42 LICENSES, PERMITS & FEES 105,594 2,792,823 2~765,000 -27,823 -1.0 43 INTERGOVERMENT REV. 390,848 3,968,743 5,189,410 1,220,667 23.5 44 CHARGES FOR SERVICE 78,074 695,175 780,176 85,001 10.9 45 FINES AND FORFEITS 24,408 474,521 434,400 -40,121 -9.2 46 INVESTMENT INCOME 13,036 254,706 345,000 90,294 26.2 47 REIMBURSEMENTS 14,660 437,817 307,710 -129,807 -42.2 48 OTHER REVENUE 2,871 210,484 130,850 -79,634 -60.9 TOTAL GENERAL FUND 4,520,295 26,089,962 28,382,315 2,292,363 8.1 REFUSE DISPOSAL FUND 40 PROPERTY TAXES 993,649 2,439,017 2,493,722 54,705 2.2 44 CHARGES FOR SERVICE 118,135 899,541 915,250 15,709 1.7 46 IN1~STMBNT INCOME 3,182 36,244 49,000 12,756 26.0 48 OTHER REVENUE 64 71 0 -71 TOTAL REFUSE DISPOSAL F~ND 1,115,030 3,374,873 3,45?,972 83,099 2.4 MOTOR FUEL TAX FUND 43 INTERGOVERMENT REV. 130,948 1,483,116 1,554,245 101,129 6.5 46 INVESTMENT INCOME 2,817 40,216 70,000 29,784 42.5 47 REIMBURSEMENTS 1,086 3,484 150 -3,334 ****.* 134,851 1,496,816 1,624,395 127,879 7.9 CO~JNITY DEVELPMBT BLOCK GRNT 43 INTERGOVERMENT REV. 103,915 621,547 404,465 -217,082 -53.7 46 INVESTMENT INCOME 18 34 0 -34 48 OTHER REVENUE 0 34,919 56,800 21,881 38.5 TOTAL COMMUNITY DEUELPMNT BLOCK GRNT 103,933 656,500 461,268 -195,235 -42.3 ASSET SEIZURE FUND 48 FINES AND FORFEITS 637 33,887 0 -33,887 46 INVESTMENT INCOME 20 308 0 -308 TOT~ASSET SEIZURE FUND 657 34,195 0 -34,198 D~A SHARED FUNDS FUND 45 FINES AND FORFEITS 0 19,745 0 -19,745 46 INVESTMENT INCOME 0 571 0 -571 LAW ENFORCEMENT BLOCK GRANT 43 INTERGOVEP~ENT REV. 12,173 38,531 18,410 -20,121 -109.3 46 INVESTMENT INCOME -6 66 0 -66 TOTAL LAW ENFORCEMENT B~OCK GRANT 12,167 38,597 18,410 -20,187 -109.7 16:02:04 FRRBRR03 SUM o2i 11 Months ( 91.6% ) Comp.leted 1 Month ( 8.3% ) Remaining VILLAGE OF MOUNT PROSPECT Budget Revenue bY Category within Fund Surmmary 01/01/02 - 11/30/02 C~r Mo Y-T-D 2002 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, TIF SERIES 1996B B&I, TIF 41 OT~ER 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 OTHER TAXES 46 INVESTM~ INCOME TOTAL SRRIES 1992A B&I, FLOOD SERIES 1993B E&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTaL SERIES 1993E B&I, FLOOD SERIES 1994A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIEE 1994A E&I, FLOOD SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 0 734,552 244,025 -490,827 -201.0 0 0 0 0 0 0 0 0 0 0 0 0 32,960 119,336 122,097 2,761 2.3 147 1,295 2,091 796 38.1 0 0 0 0 33,107 120,631 124,188 3,557 2.9 13,904 50,341 51,505 1,164 2.3 46 332 485 153 31.5 13,950 50,673 81,990 1,317 2.5 99,882 361,634 370,000 8,366 2.3 222 5,541 8,736 3,195 36.6 0 0 0 0 100,104 367,175 378,736 11,861 3.1 0 0 0 0 0 0 0 0 0 0 0 0 0 68,377 276,000 207,623 75.2 0 459 5,814 5,385 92.1 0 1,050,705 0 -1,050,705 0 1,119,541 281,814 -837,727 -297.3 0 49,151 245,698 196,547 80.0 0 224 4,249 4,025 94.7 0 825,053 0 -525,053 0 574,428 249,947 -324,481 -129,8 18,580 181,079 210,000 28,921 13.8 187 1,750 3,904 ~,154 55.2 16:02:04 FRRBRR03 SUM 021 11 Months ( 91.6% ) Completed i Month ( 8.3% ) Remaining VILLAGE OF MOUNT PROSPECT Budget Revenue by CategOry within Fund Summary 01/01/02 11/30/02 Cur Mo Y-T-D 2002 Unreceived Unreceived Received Received Budget Balance Percent TOTAL SERIES 1998A B&I, STREET IMP. 65,793 728,811 908,999 180,188 19.8 SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES 30,201 338,991 46 INVESTMENT INCOME 679 5,461 49 OTHER FINANCING SOURCES 0 397,852 TOTAL SERIES 2002B B&i, STREET IMP. 30,880 742,304 0 -338,991 0 -5,461 0 -397,852 0 -742,304 SERIES 2002 LIBRARY BONDS B&I 43 INTERGOVERMENT REV. 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 TOTAL SSRIES 2002 LIBRARY BONDS B&I 0 0 0 0 CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 47 REIMBURSEMENTS POLICE & FIRE BLDG CONST FUND 46 INVESTMENT INCOME TOTAL POLICE & FIRE BLDG CONST FUND SERIES 2001 PROJECT FUND 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 2001 PROJECT FUND SERIES 2003 PROJECT FUND 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES TOTAL SERIES 2003 PROJECT FUND 2002 LIBRARY PROJECT FUND 46 INVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES TOTAL2002 LIBRARY PROJECT FUND CAPITAL IMPROVEMENT CONST FUND 43 INTERGOVERMENT REV. 46 INVESTMENT INCOME 87,600 87,600 727,100 639,500 88.0 4,178 58,553 87,000 28,447 32.7 0 56,375 193,550 137,175 70.9 9,450 55,350 40,500 -14,850 -36.7 0 0 0 0 101,228 257,878 1,048,150 790,272 75.4 0 0 0 0 S 0 0 0 5,628 76,216 135,588 59,372 43.8 0 0 0 0 5,628 76,216 135,588 59,372 43.8 0 0 73,293 73,293 100.0 0 0 8,315,000 8,315,000 100.0 0 0 8,388,293 8,388,298 100.0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 48 2,357 0 -2,357 16:02:04 FRRBRR03 SUMO2i Budget ii Months ( 91.6% ) Complgted VILLAGE OF MOUNT PROSPECT i Month ( 8.3% ) Remainlng Revenue by Category within Fund Summary 01/01/02 - 11/30/02 Cur MO Y-T-D 2002 Unreceived Unreceived Received Received Budget Balance Percent VEHICLE MAINTENANCE FUND 44 CH/~RGES FOR SERVICE 46 INVESTMENT INCOME 48 OTHER REVENUE TOTAL VE~ICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND 44 C~GES FOR SERVICE 46 IgTVESTMENT INCOME 48 OTHER REVENUE 49 OTHER FINANCING SOURCES TOTALVEHICLE REPLACEMENT FU~ COMPUTER REPLACEMENT FD1TD 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME TOTAL COM~UTER REPLACEMENT FUND RISK MANAGEMENT FUND 43 INTERGOVERMENT REV. 44 CF~GES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE TOTAL RISK MANAGEMENT FUND POLICE PENSION FUND 46 INVESTMENT INCOME 48 OTHER REVENUE TOTAL POLICE PENSION F~ FIRE PENSION FUND 46 IN-v~STMENT INCOME 48 OTHER REVENUE TOTAL FIEE PHNEION BENEFIT TRUST %2 FUND 46 INVESTMENT INCOME TOTAL BENEFIT TRUST %2 F%~ND ESCROW DEPOSIT FUND 46 IN~;ESTMENT INCOME ~TOTALESCROW DEPOEIT FUND 95,918 1,055,070 1,150,978 95,908 8.3 713 6,975 4,500 -2,475 -55.0 0 0 0 0 96,631 1,062,045 1,155,478 93,433 8.1 67,555 743,098 810,651 67,553 8.3 14,614 186,309 190,000 3,691 1.9 0 0 0 0 0 44,000 60,000 16,000 26.7 82,169 973,407 1,060,651 87,244 8.2 15,685 172,528 187,053 14,525 7.8 1,065 11,878 13,000 1,722 13.2 16,750 ~83,506 200,053 16,247 8.1 0 0 0 0 232,731 2,676,296 3,002,984 326,688 10.9 4,307 68,083 105,750 37,667 35.6 4,283 67,331 60,000 -7,331 -12.2 82,893 609,578 662,929 53,351 8.0 294,214 3,421,288 3,831,665 410,375 10.7 103,020 -1,288,493 1,824,000 3,112,493 170.6 349,815 1,801,957 1,269,539 67,582 5.3 452,835 -86,536 3,093,539 3,180,075 102.8 111,497 -688,376 1,880,000 2,562,376 136.3 372,768 1,173,797 1,223,370 49,573 4.1 484,265 491,421 3,103,570 2,611,949 84.2 21 836 1,100 264 24.0 21 836 1,100 264 24.0 0 0 0 0 o o o o VILLAGE OF MOIINT PROSPECT Budget Expenditure Summary 01/01/02 w 11/30/02 11 Months ( 1 Month ( Cur Mo Y-T-D 2002 Ex"pended Ex~ended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent EXPE~F~ITb'RE BY C~SIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS PENSION BENEFITS CONTRACTUAL SERVICES UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES LA~D IMPROVEMENTS BUILDING IMPRO~rEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS INFRASTRUCTURE BOND PRINCIPAL INTEREST EXPENSE BANK~/~D FISCltL FEES INTERFUNDTPJ%NSFERS OTHER FIN~/~CING USES Total 2%11 Funds EXPENDITURE BY FUND GEMERAL FUND REPUSE DISPOSAL FUND MOTOR FUEL TAX F~%~D LAW EMFORCEMF/~T BLOCK GRANT CO~UNITY D~LP~9~T BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND SERIES 1987A B&I, PW FACILITY SERIES 1993B B&I, PUBLIC BLDGS SERIES 2001 B&I, VILLAGE HALL SERIES 2003 B&I, VILLAGE HALL SERIES 2002B B&I, PUBLIC BLDGS SERIES 2002A B&I, TIF SERIES 1992B B&I, TIF SERIES 1993A B&I, TIF SERIES 1994B B&I, TIF SERIES 1996B B&I, TIF SERIES 1998B B&I, TIF SERIES 1999 B&I, TIF SERIES 1991A B&I, F~DOD SERIES 1992A B&I, FLOOD SERIES 1993B B&I, FLOOD SERIES 1994A B&!, FLOOD SERIES 1996A B&I, FLOOD SERIES 1998A B&I, FLOOD 1,527,000 17,561,293 19,718,477 2,157,184 10.9 933,830 4,740,998 8,120,038 379,037 7.4 25,740 236,192 319,532 83,340 26.1 298,735 3,338,338 ~,945,967 607,629 15.4 1,127,531 11,134,725 14~168,094 3,033,369 21.4 18,599 343,907 539,580 195,673 36.3 964,056 4,080,395 4,215,564 135,169 3.2 54,519 894,534 1,219,099 324,565 26.6 33,956 222,061 905,936 683,875 75.5 7,313 76,214 616,678 540,464 87.6 128,611 1,020,584 4,695,491 3,674,907 78.3 1,393 107,396 370,670 263,274 71.0 118,357 865,944 1,427,957 562,013 39.4 21,024 369,473 922,191 552,718 59,9 8,880 11,767 1,115,000 1,103,233 98,9 352,931 5,370,365 10,032,642 4,662,277 46,5 3,616,864 4,108,774 4,165,829 57,055 1,4 401,~13 1,301,485 1,416,011 114,826 8.1 0 5,914 11,000 5,086 46.2 0 1,865,927 367,463 -1,498,464 -407.8 0 6,196,800 0 -6,196,800 9,040,948 63,883,086 79,293,216 11,440,130 15.2 2,786,248 25,247,815 28,594,265 272,491 2,930,832 3,408,871 25,675 1,879,118 2,716,206 0 26,587 18,410 121,320 638,301 756,851 0 8,094 0 558 1,951 0 0 700 0 0 121,000 121,000 0 2,781,184 601,033 255,389 403,174 390,582 0 0 0 525,461 547,196 0 456,650 463,386 0 0 0 0 0 1,014,451 458,990 0 0 0 153,150 156,750 157,300 51,021 52,363 52,764 0 517,900 518,050 0 0 0 0 0 0 0 1,240,599 304,392 0 629,958 178,260 189,940 210,330 210,380 57,141 64,432 64,784 3,346,450 11.7 478,039 14.0 837,088 30.8 -8,177 -44.4 118,550 15.7 -8,094 -1,981 -700 0 -2,180,151 -362.7 -12,592 -3.2 0 -547,196 -463,386 0 -555,521 -121.0 0 550 0.3 401 0.8 150 0 0 -936,207 -307.6 -451,698 -253.4 5O 352 0.5 14:31:50 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/02 - 11/30/02 11 Months ( 1 Month ( 91.6% ) Completed 8.3% ) Remaining Cur Mo Y-T~D 2002 Expended EXpended Budget unexpended Unexpended Balance Percent SERIES 1998C B&I, TIE IBPA FLOOD CONTROL LOD/~S 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. SERIES 2002 LIBRARy BONDS B&I 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 REDEVLPF~T CONST STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST FIIND WATER AND SEWER FUND PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND COMPLetER REPLACEMENT FUND RISK MANAGEMENT FUND POLICE PENSION FUND FIRE pENSION FUND BENEFIT TRUST #2 FUND SSA #1 PROSPECT MEADOWS B&I SSA #6 GEORGE/ALBERT B&I To~al All Funds 130,663 151,625 152,076 451 0.3 168,630 494,982 613,388 118,406 19,3 55,749 112,098 112,488 400 0,4 430,132 444,931 0 -444,931 0 2,123,232 619,178 -1,504,054 -242.9 0 0 0 0 841,150 892,450 893,300 860 0.1 563,483 579,035 0 -579,035 0 0 0 0 85,511 998,314 2,188,865 1,190,551 54.4 0 0 0 0 41,169 346,876 4,655,420 4,308,544 92.5 0 0 102,705 102,705 100.0 0 0 0 0 61,936 154,146 150,000 -4,146 -2.8 10,467 486,476 1,552,422 1,065,946 68.7 74,872 1,038,014 2,856,788 1,824,774 63.9 127,073 1,852,349 2,704,099 851,750 31.5 669,466 5,904,905 9,063,162 3,158,257 34.8 17,317 343,828 508,318 164,490 32.4 85,717 958,902 1,168,979 210,077 18.0 118,357 865,944 1,427,957 562,013 39.4 0 75,346 106,725 31,379 29.4 331,761 3,734,595 3,888,093 153,498 3.9 148,832 1,662,907 1,979,010 316,103 16.0 145,574 1,628,689 1,921,800 293,111 15.3 3,027 33,296 36,330 8,034 8.4 0 0 0 0 35,028 40,055 40,055 0 9,040,948 63,853,086 75,293,216 11,440,130 15.2 12/11/2002 FRRDBR01 SUM o31 11 Months VI~.LAGE OF MOUNT PROSPECT i Nonth Department Budget Expenditure summary 01/01/02 11/30/02 PUBLIC REPRESENTATION Cur No Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) 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 66 OFFICB EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 4,490 83,793 90,356 889 11,710 15,112 5,379 95,803 105,468 6,563 7.3 3,402 22.5 9,965 9.4 2,755 30,915 360 4,034 0 78 439 55,828 38 639 1,787 4,013 0 0 5,379 98,803 33,698 2,783 8.3 4,397 363 8.3 400 322 80.5 58,698 2,870 4.9 475 -160 -33.7 7,800 3,787 48.6 0 0 105,468 9,965 9.4 5,379 99~503 109,468 9,965 9.4 5,379 95,503 105,468 9,965 9.4 12/11/2002 14:32:50 FRRDBR01 SUM 031 11 Months VILLAGW. OF MOUNT PROSPECT I Month Department Budget Expenditure Summary 01/01/02 - 11/30/02 VILLAGE MANAGER'S OFFICE Cur MO Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remai~in~ Unexpended Unexpended Balance Percent PROGRAM 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 CO~4ODITIES & SUPPLIES 65 OFFICE EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 29,284 339,248 375,614 30,496 270,703 270,380 19,800 205,676 271,485 24,944 155,928 185,418 12,044 132,697 180,747 36,366 9.7 -323 -0.1 65,809 24.2 29,490 15.9 48,050 26.6 110,568 1,104,252 1,283,644 179,392 14.0 42,581 493,944 568,162 74,218 13.1 8,062 100,268 1~2,926 12,658 11.2 1,228 29,023 47,692 18,669 39.1 87,267 466,340 531,289 64,949 12.2 190 4,417 5,230 813 15.5 1,240 6,260 13,650 7,390 54.1 0 4,000 4,695 695 14.8 110,568 1,104,252 1,283,644 179,392 14.0 110,568 1,104,252 1,283,644 179,392 14.0 110,568 1,104,252 1,283,644 179,392 14,0 FRRDBR01 SUM 031 11 Months VILLAGE OF MOUNT PROSPECT 1 Mo=th Department Budget EXpenditure Summary 01/01/02 11/30/02 TV SERVICES DIVISION Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 CABLE TV OPERATIONS 03 OTHER SERVICES 04 INTERGOVERNMENTAL PROGRAND4ING Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SRRVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 67 OTEER EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 7,313 116,020 152,164 0 0 0 1,882 36,015 53,064 9,195 152,035 205,228 36,144 23.8 0 17,049 32.1 53,193 25.9 5,254 84,681 104,005 19,324 18.6 1,776 22,479 26,361 3,882 14.7 0 2,129 3,000 871 29.0 1,916 19,049 39,762 20,713 52.1 254 6,334 5,500 -834 -15.2 -5 3,754 8,600 4,846 56.3 0 13,609 18,000 4,391 24.4 9,195 152,035 205,228 53,193 25.9 9,195 152,035 205,228 53,193 25.9 9,195 152,035 205,228 53,193 25.9 14:32:50 FRRDBR01 SUM osi 11 Months VILLAGE OF MOUNT PROSPECT i Month Department Budget Expenditure Summary 01/01/02 - 11/30/02 VILLAGE CLERK'S OFFICE Cur Mo Y-T-D 2002 EXpended EXpended Budget 91.6% ) Compieted 8.3% ) Remai~in9 Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 VIL~GE CLERK'S OFFICE Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES SOURCE OF FUNDS 001 GENERAL FUND Totals 10,433 127,107 144,504 17,397 12.0 10,433 127,107 144,504 17,397 12.0 6,329 75,972 84,985 9,013 10.6 1,918 21,864 24,390 2,526 10.4 0 1,667 2,300 633 27.5 1,946 19,911 23,029 3,118 13.5 127 2,503 1,600 -903 -56.4 113 5,190 8,200 3,010 36.7 10,433 127,107 144,504 17,397 12.0 10,433 127,107 144,504 17,397 12.0 10,433 127,107 144,504 17,397 12.0 FRRDBR01 SUM031 11 Months VILLAGE OF MOUNT PROSPECT i Mo~th Department Budget Expenditure Summary os/os/o~ - s~./3o/o2 FINANCE DEPARTMENT Cur Mo Y-T-D 2002 Expended Expended Budget 91,6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 02 ACCOUNTING 03 DATA PROCESSING 04 DUPLICATING SERVICES 05 INSURANCE PROGRAMS 06 CUSTOMER SERVICES 07 CASH MANAGEMENT Totals EXPENDITURE CLA8 SIFI~ATION 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 18,056 202,754 218,757 22,919 264,480 300,159 10,424 179,870 205,023 0 7,732 11,600 24,051 269,393 293,512 23,200 289,891 327,136 2,867 33,857 37,016 16,003 7.3 35,679 11.9 25,153 12.3 3,868 33.3 24,119 8.2 37,245 11.4 3,159 8.5 101,517 1,247,977 1,393,203 145,226 10.4 53,630 665,253 732,001 14,047 167,396 185,215 797 5,129 6,300 10,428 164,137 190,426 482 8,056 6,100 19,723 216,959 236,682 2,410 17,017 30,279 0 4,030 6,200 66,748 9.1 17,819 9.6 1,171 18.6 26,289 13.8 -1,956 -32.1 19,723 8.3 13,262 43.8 2,170 35.0 101,517 1,247,977 1,393,203 145,226 10.4 101,517 1,247,977 1,393,203 145,226 10.4 101,517 1,247,977 1,393,203 145,226 10.4 FP. RD~P-.0 '1 SUM 03I 11 Months VILLAGE OF MOUNT PROSPECT i Month Department Budget Expenditure Summary 01/01/02 11/30/02 COMMUNITY DEVELOPMENT Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent 02 03 05 06 O7 COMMUNITY DEVELOPMENT ADMIN PI~NNING & ZONING ECONOMIC DEVELOPMENT BUILDING INSPECTIONS HOUSING INSPECTIONS HEALTH INSPECTIONS Totals EXPENDITURE CI~%SSIFICATION 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,142 152,402 190,978 12,425 185,113 225,690 3,700 47,846 72,300 45,627 538,399 665,296 19,274 232,574 258,902 7,025 91,241 101,223 38,576 20.2 40,577 18.0 24,454 33.8 126,897 19.1 26,328 10.2 9,982 9.9 101,193 1,247,575 1,514,389 266,814 17.6 67,757 851,604 1,050,744 20,251 238,095 275,270 91 13,840 16,265 11,924 109,116 134,330 849 22,680 24,060 321 12,240 13,720 0 0 0 199,140 19.0 37,175 13.5 2,425 14.9 25,214 18.8 1,380 5.7 1,480 10.8 0 101,193 1,247,575 1,514,389 266,814 17.6 101,193 1,247,575 1,513,944 0 0 445 266,369 17.6 445 100.0 101,193 1,247,575 1,514,389 266,814 17.6 12/11/2002 FRRDBR01 SUM 031 11 Months VILLAGE OF MOUNT PROSPECT i Month Department Budget Expenditure Suaunary 01/01/02 11/30/02 COMMTJNITY DEVELOPMENT - CDBG Cur MO Y-T-D 2002 EXpended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 04 05 O6 07 CDBG ADMINISTRATION CDBG COMMUNITY PROGRAMS ACCESSIBLTY & NEIGNBRHD IMPRV CDBG RESIDENTIAL REF=~B Totals EXPENDITURE C~ASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTMER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 64 BUILDING IMDROVEMENTS 69 INFRASTRUCTURE Totals SOURCE OF FUNDS 070 COV~UNITYDEVELPMNT BLOCK GRNT Totals 1,053 32,987 43,265 10,278 23.8 2,717 35,963 95,200 19,237 34.8 91,050 428,436 480,586 52,150 10.9 26,500 140,915 177,800 36,085 20.7 121,320 638,301 756,851 118,550 15.7 498 21,891 27,720 411 6,487 7,660 49 743 1,075 2,812 36,650 57,615 0 3,179 4,395 26,500 140,915 177,800 0 89,492 137,111 91,050 338,944 343,475 121,320 638,301 756,851 5,829 21.0 1,173 15.3 332 30.9 20,965 36.4 1,216 27.7 36,885 20.7 47,619 34.7 4,531 1.3 118,550 15.7 121,320 638,301 756,851 118,550 15.7 121,320 638,301 756,851 118,550 15.7 12/11/2002 14:32:$0 FRRDBR01 SUM031 HUMAN SERVICES I1 Months VILLAGE OF MOUNT PROSPECT i Month Department .Budget Expenditure Summary 01/01/02 - 11/30/02 Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROORAM TOTALS 0I R~4AN 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 OTNER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 16,669 187,952 299,221 111,269 37.2 18,787 222,268 253,379 31,111 12.3 -9,278 127,965 150,045 22,080 14.7 8,241 88,395 70,003 11,608 16.6 3,637 80,187 88,838 8,651 14.7 35,056 646,767 831,486 184,719 22.2 32,506 426,461 468,071 7,779 93,373 104,119 294 2,148 5,200 10,450 88,293 205,641 933 12,677 7,280 -16,906 23,238 37,675 0 577 2,000 0 0 1~500 41,610 8.9 10,746 10.3 3,052 58.7 117,348 57.1 -5,397 -74.1 14,437 38.3 1,423 71.2 1,500 100.0 35,056 646,767 831,486 184,719 22.2 35,056 646,767 831,486 184,719 22.2 35,056 646,767 831,466 184,719 22.2 12/11/2002 FRRDBR01 SUM 08i POLICE 11 Months VILLAGE OF MOUNT PROSPECT i Month Department Budget Expenditure Summary 01/01/02 11/30/02 Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS O2 03 O4 O5 06 POLICE ADMINISTRATION PATROL & TRAFFIC ENFORCEMENT CRIME PREVTN & PUBLIC SERVICES INVESTIGATIVE & JUVENILE PRGM CROSSING GUARDS EQUIPMENT MAINTENANCE Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 92 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 69 OFFICE EQUIPMENT 67 OTHER EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND 060 LAW ENFORCEMENT BLOCK GRANT 080 ADSET SEIZURE FUND 085 DRA SHARED FUNDS FUND 086 DUI FINE FUND Totals 379,809 1,884,921 1,965,027 476,958 5,489,948 9,984,798 13,632 162,666 217,607 78,969 897,808 1~046,827 2,412 19,495 24,972 44,107 520,897 600,180 80,106 4.1 498,850 8.3 54,941 25.2 148,519 14.2 5,477 21.9 79,288 13.2 995,883 8,971,785 9,838,911 867,176 8.8 512,750 6,040,909 6,616,533 ~88,789 1,609,082 1,706,601 -5,526 59,961 64,600 89,389 1,113,478 1,284,462 2,573 47,687 53,000 6,011 61,068 77,415 0 0 0 1,393 9,257 11,550 558 30,283 24,750 998,888 8,971,735 9,838,911 575,624 8.7 97,519 5~7 4,639 7.2 170,984 13.3 5,303 10.0 16,347 21.1 0 2,293 19.9 -5,933 -22.4 867,176 8.8 995,325 8,960,990 9,838,911 877,921 0 0 0 0 0 8,094 0 -8,094 558 1,951 0 -1,951 0 700 0 -700 995,888 8,971,785 9,838,911 867,176 8.9 8.8 FRRDBR01 SUM 03i FIRE 11 Months VILLAGE OF MOUNT PROSPECT i Month Department Budget Expenditure Summary 01/01/02 - 11/30/02 Cur MO Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 FIRE ADMINISTRATION 02 FIRE DEPARTMENT OPERATIONS 03 FIRE TRAINING ACADEMY 04 FIRE PREVENTION 08 FIRE COMMUNICATIONS 06 EQUIPMENT MAINTENANCE 07 EMERGENCY PREPARDENESS PRGM 08 PAID-ON-CALL PROGRAM Totals 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICE5 58 UTILITIES 57 COMMODITIES & SUPPLIES 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 446,476 1,505,533 1,619,942 431,584 4,768,438 5,283,853 0 4,092 4,135 35,505 389,138 427,983 5,562 64~698 61,600 31,091 353,984 400,488 1,140 8,733 14,550 2,347 18,228 38,057 114,409 7.1 515,415 9.8 38,845 9.1 -3,098 -5.0 46,904 11.7 5,817 40.0 19,829 52.1 955,675 7,112,414 7,850,578 738,164 9.4 470,748 4,980,145 5,523,900 404,883 1,502,933 1,573,798 27,172 74,728 111,165 36,616 378,959 425,205 3,536 44,458 44,100 7,094 77,809 94,210 0 7,442 10,500 3,626 45,929 61,700 543,785 9.8 70,865 4.5 36,437 32.8 46,246 10.9 -388 -0.8 16,401 17.4 5,989 99.8 3,058 29.1 18,771 25.6 955,675 7,112,414 7,850,578 738,164 9.4 953,675 7,112,414 7,850,578 738,164 9.4 959,675 7,112,414 7,850,578 738,164 9.4 12/11/2002 FRRDBR01 SUM031 PUBLIC WORKS 11 Mont h~ VILLAGE OF MOUNT PROSPECT ~ Month Department Budget Expenditure Summary 01/01/02 11/30/02 Cur Mo Y-T-D 2002 - ADMINISTRATION Ex~p ended Expended Budget 91.6% ) Co~91eted 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION Totals EXPENDITURE CLASSIFICATION 90 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 74,101 74,101 14,567 5,916 381 51,614 1,623 0 0 0 74,101 869,045 970,640 101,595 10.5 869,045 970,640 101,999 10.8 176,675 204,258 27,583 13.5 70,008 77,944 7,936 10.2 20,750 25,765 5,019 19.5 572,227 629,618 57,391 9.1 19,711 17,775 -1,936 -10.9 9,674 10,220 546 5.3 0 4,500 4,500 100,0 0 560 560 100,0 869,045 970,640 i01,595 i0.5 74,101 869,045 970,640 101,595 10.5 74.~0~ 869.0~s 9,0.~40 ~0~.89s 10.5 12/I1/2002 14:32:50 FRRDBR01 SUM03i PUBLIC WORKS 11 Months VILLAGE OF MOUNT PROSPECT i Month Department Budget Expenditure Summary 01/01/02 - 11/30/02 - STREETS/BLDGS Cur Mo Y-T-D 2002 EXpended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 04 05 06 07 08 09 STREET DIVISION ADMINISTRATION MAINTENANCE - PUBLIC BUILDINGS STREET MAINTENANCE SNOW REMOVAL LEAF REMOVAL STORM SEWER & BASIN MAINT MAINTENANCE OF STATE HIGHWAYS TP~AFFIC SIGN MAINTENANCE PARKING LOT MAINTENANCE Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTCJAL SERVICES 55 UTILITIES 56 INSURANCE 57 COM~4ODITIES & SUPPLIES 59 OTHER EXPENDITURES 67 OTHER EQUIPMENT 69 INFRASTRUCTURE Totals SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND 630 PARKING SYSTEM REVENUE FUND Totals 7,260 103,458 119,690 38,345 590,887 682,072 11,467 435,531 949,808 6,982 260,802 324,558 51,406 145,372 156,313 8,797 108,705 145,984 1,711 46,841 61,741 5,424 83,795 97,569 17,317 343,828 378,318 16,232 13.6 91,185 13.4 114,274 20.8 63,786 19.6 10,941 7.0 37,279 25.5 14,900 24.1 13,774 14.1 34,490 9.1 148,709 2,119,219 2,516,050 396,831 15.8 101,879 943,955 1,069,475 21,292 214,123 237,173 20,683 369,986 436,288 324 4,292 18,420 829 9,120 9,949 2,472 196,649 279,245 0 0 0 0 0 0 1,260 381,094 465,500 125,520 11.7 23,050 9.7 66,302 15.2 14,128 76.7 829 8.3 82,596 29.6 0 0 84,406 18.1 148,709 2,119,219 2,516,050 396,831 15.8 131,392 1,631,131 1,950,047 0 144,260 187,685 17,317 343,828 378,318 318,916 16.4 43,425 23.1 34,490 9.1 148,709 2,119,219 2,516,050 396,831 15.8 FRRDBR01 SUM 031 PUBLIC WORKS 11 Months VILLAGE OF MOUNT PROSPECT i No~th Department Budget Expenditure Summary 01/01/02 11/30/02 Cur Mo Y-T-D 2002 - FORESTRY/GRNDS Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 03 04 FORESTRY DIVISION ADMIN MAINTENANCE OF GROUND FORESTRY PROGRAM pUBLIC GROUNDS BEAUTIFICATION EXPENDITURE CLASSIFICATION 12,446 148,946 174,585 25,639 14.7 33,664 296,460 342,985 46,525 13.6 126,038 635,304 747,523 112,219 15.0 8,900 39,344 47,438 8,094 17.1 Totals 181,048 1,120,054 1,312,S$1 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTR2%CTUAL SERVICES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT Totals SOURCE OF FUNDS 001 GENERAL FUND 690 RISK MANAGEMENT FUND Totals 192,477 14.7 42,458 560,250 635,791 11,021 132,094 146,482 0 436 1,335 122,134 398,328 491,118 5,435 28,945 32,035 0 0 5,770 181,048 1,120,054 1,312,531 75,541 11.9 14,388 9.8 899 67.3 92,789 18.9 3,090 9.6 5,770 100.0 192,477 14.7 181,048 1,112,295 1,294,763 0 7,759 17,768 182,468 14.1 10,009 56.3 181,048 .1,120,054 1,312,531 192,477 14.7 FRRDBR01 SUM 03i PUBLIC WORKS 11 Months VILLAGE OF MOUNT PROSP~.CT i Mo=th DePartment Budget Expenditure Summary 0i/0i/02 ii/30/02 - ENGINEERING Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 ENGINEERING SERVICES 05 TRAFFIC CNTRL & STREET LGHTNG Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 CO~ODITIES & SUPPLIES 65 OFFICE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE Totals SOURCE OF FUNDS 001 GENERAL FUND 050 MOTOR FUEL TAX FUND Totals 57,640 587,661 673,919 86,258 12.8 12,223 164,611 585,618 371,007 69.3 69,863 752,272 1,209,537 457,265 37.8 34,641 482,247 527,789 9,224 113,130 126,579 90 1,726 5,335 25,383 77,643 197,914 -32 64,293 209,800 577 11,931 13,110 0 0 1,750 0 1,302 2,260 0 0 125,000 45,542 8.6 13,449 10.6 3,609 67.6 120,271 60.8 145,507 69.4 1,179 9.0 1,750 100.0 958 42.4 125,000 100.0 69,863 ?52,272 1,209,597 457,285 S7.8 63,830 730,553 892,737 162,184 18.2 6,033 21,719 316,800 295,081 93.1 69,863 752,272 1,209,537 457,265 37.8 FRRDBR01 SLTM 031 11 Months VILLAGE OF MOUNT PROSPECT I Mo.th Department Budget Expenditure Summary 01/01/02 11/30/02 PUBLIC WORKS - WATER/SEWER Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM 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 & RBPL 08 EQUIPMENT MAINTENANCE 09 SANITARY SEWER MAINT & REPAIR 10 WATER & SEWER SYSTEM IMPROV 12 LAKE MICHIGAN WATER SUPPLY Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 65 OPFICE EQUIPMENT 67 OTHER EQUIPMENT 68 DISTRIBUTION SYSTEMS 71 BOND PRINCIPAL Totals SOURCE OF FUNDS 610 WATER AND SEWER FUND Totals 205,290 1,172,812 1,458,190 285,678 19.6 1,005 14,608 81,746 67,138 82.1 14,820 74,403 78,472 4,069 5.2 26,872 344,097 428,089 83,992 19.6 61,804 493,666 1,037,937 544,271 52.4 14,978 227,400 286,878 99,478 20.7 21,070 185,261 276,783 91,492 33.1 47,194 519,128 566,322 47,194 8.3 20,772 306,304 349,915 43,611 12.5 19,280 37,077 1,385,000 1,347,923 97.3 246,381 2,530,449 3,113,860 583,411 18.7 669,466 5,904,905 9,063,162 3,158,257 34.8 91,480 1,125,723 1,400,755 275,032 19.6 26,061 304,429 383,432 49,003 13.9 1,164 21,272 25,600 4,328 16.9 388,646 3,734,901 4,895,996 1,161,095 23.7 7,524 104,517 143,480 38,963 27.2 11,648 128,118 139,765 11,647 8.3 7,790 150,597 202,995 52,398 25.8 4,833 11.916 27,234 15,318 56.2 0 0 2,250 2,250 100.0 16,840 206,765 651,755 444,990 68.3 8,880 11,767 1,115,000 1,103,233 98.9 104,900 104,900 104,900 0 669,466 5,904,905 9,063,162 3,158,287 34.6 669,466 5,904,905 9,063,162 3,158,257 34.8 669,466 5,904,905 9,063,162 3,158,257 34.8 12/11/2002 FRRDBR01 SUM031 PUBLIC WORKS - 11 Months VILLAGE OF MOUNT PROSPECT i Month Department Budget Expenditure Summary 01/01/02 - 11/30/02 REFUSE DISPOSAL Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM Totals EXPENDITURE CLASSIFICATION 80 PERSONAL SERVICES 81 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 86 INSURANCE 57 CO~40DITIES & SUPPLIES Totals SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND Totals 272,491 2,930,832 3,408,871 272,491 2,930,832 3,408,871 478,039 14.0 478,039 14.0 5,394 64,296 71,633 1,396 16,003 17,670 0 175 1,500 265,330 2,843,595 3,307,180 51 460 625 320 3,523 3,843 0 2,780 6,520 7,337 10.2 1,667 9.4 1,325 88.3 463,585 14.0 65 12.4 320 8.3 3,740 57.4 272,491 2,930,832 3,408,871 478,039 14.0 272,491 2,930,832 3,408,871 478,039 14.0 272,491 2,930,882 3,408,871 478,039 14.0 12/11/2002 FRRDBR01 SUM 031 11 Months ( VILLAGE OF MOUNT PROSPECT i Month ( Department Budget Expenditure Summary 01/01/02 - 11/30/02 PUBLIC WORKS - VEHICLE MAINT Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexp~nded Unexpended Balance Percent PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 02 VEHICLE MAINTENANCE PROGRAM 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 F~NDS 660 VEHICLE MAINTENANCE FUND Totals 9,471 125,082 141,528 16,446 11.6 76,246 833,820 1,027,451 193,631 18.8 85,717 958,902 1,168,979 210,077 18.0 41,006 488,971 544,929 55,958 10.3 10,500 120,575 132,896 12,321 9.3 0 2,387 2,000 -387 -19.4 4,603 69,729 72,829 3,100 4.3 127 1,177 1,000 -177 -17.7 29,481 260,076 348,975 88,899 25.5 0 0 0 0 0 0 500 500 100.0 0 15,987 65,850 49,863 75.7 85,717 958,902 1,168,979 210,077 18.0 85,717 958,902 1,168,979 210,077 18.0 8~,717 958,902 1,168,979 210,077 18.0 12/11/2002 14:32:50 FRRDBR01 SUM03i 11 Months VILLAGE OF MOUNT PROSPECT i Month Department Budget Expenditure Summary 01/0i/02 11/30/02 COMMUNITY SERVICE PROGRAMS Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remainin9 Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 03 4TH OF JULY & CIVIC EVENTS,ETC 04 MOLIDAY DECORATIONS 05 BLOOD DONOR PROGRAM Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 CO~ODITIES & SUPPLIES 59 OTMER EXPENDITURES Totals SOURCE OF FUNDS 001 GENERAL FUND Totals 4,243 68,646 101,900 33,254 32.6 385 109,659 123,828 14,169 11.4 7,359 19,094 74,843 59,749 79.8 247 2,448 2,914 466 16.0 12,234 195,847 303,488 107,638 35.5 767 47,401 54,028 6,627 12.3 144 4,625 7,122 2,497 35.1 1,705 120,421 202,045 81,624 40.4 0 0 1,235 1,235 100.0 6,695 20,008 30,055 10,047 33.4 2,923 3,392 9,000 5,608 62.3 12,234 198,847 303,485 107,638 35.5 12,234 195,847 303,485 107,638 35.5 12,234 195,847 903,485 107,638 38.8 FRRDBR01 SUM031 11 Months VILLAGE OF MOI/NT PROSPECT i Mo~th Department Budget Expenditure Summary 01/01/02 11/30/02 CAPITA3~ IMPROVEMENT PROJECTS Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Re~ining Unexpend~d Unexpended Balance Percent 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 Totals EXPENDITURE CLAES IFICATION 54 CONTRACTUAL SERVICES 55 UTILITIES 59 OTHER EXPENDITURES 62 LA~D IMPROVEMENTS 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 66 MOBILE EQUIPMENT 67 OTNER EQUIPMENT 69 INFP3%STRUCTURE Totals SOURCE OF FUNDS 050 MOTOR FUEL TAX FUND 060 LAW ENFORCEMENT BLOCK GRART 510 CAPITAL IMPROVEMENT FUND 520 POLICE & FIRE B~G CONST FUND 525 SERIES 2001 PROJECT FUND 526 SERIES 2003 PROJECT FUND 527 2002 LIBPJ%RY pROJECT FUND 530 CAPITAL IMPRO~MENT CONST FUND 550 DOWNTOWN RED~VLPMNT CONST 560 STREET IMPROVEMENT CONST FUND 590 FLOOD C05V~ROL CONST FUND 630 PARKING SYSTEM RBVES~JE FUND 670 VEHICLE REPLACEMENT FUND 680 COMPUTER REPLACEMENT FUND 690 RISK MANAGEMENTFUND Totals 149,786 1,310,431 5,S20,551 4,810,120 76.3 32,091 168,901 1,490,849 1,321,948 88.7 10,467 486,476 1,551,977 1,065,501 68.7 133,047 1,874,073 2,844,099 970,026 34.1 95,279 2,402,557 4,795,046 2,392,489 49.9 118,357 865,944 1,427,957 562,013 39.4 0 75,346 106,725 31,379 29.4 539,027 7,183,728 17,737,204 10,553,476 59.5 24,125 457,350 932,849 475,499 51.0 0 0 0 0 0 65,838 691,902 626,064 90.5 7,313 76,214 616,678 540,464 87.6 128,611 931,081 4,552,380 3,621,299 79.5 0 81,376 326,725 245,349 75.1 118,357 565,944 1,427,957 562,013 39.4 0 55,598 90,046 34,448 38.3 260,621 4,650,327 9,098,667 4,448,340 48.9 539,027 7,183,728 17,737,204 10,553,476 59.5 19,642 1,713,139 2,211,721 498,582 22.5 0 26,587 18,410 -8,177 -44.4 85,511 998,314 2,188,865 1,190,551 54.4 0 0 0 0 41,169 346,876 4,655,420 4,308,544 92.5 0 0 102,705 102,705 100.0 0 0 0 0 61,936 154,146 150,000 -4,146 -2.8 10,467 486,476 1,551,977 1,065,501 68.7 74,872 664,551 2,489,325 1,824,774 73.3 127,073 1,852,349 2,704,099 851,750 31.5 0 0 130,000 130,000 100.0 118,357 865,944 1,427,957 562,013 39.4 0 75,346 106,725 31,379 29.4 0 0 0 0 539,027 7,183,728 17,737,204 10,553,476 59.5 12/11/2002 FRRDBR01 SUM o31 DEBT SERVICE 11 Months VILLAGE OF MOUNT PROSPECT i Honth Department Budget Expenditure Summary o ./os/o2 - ss/ o/o2 Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent 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 07 LIBP3~RY DEBT SERVICE Totals BXPEKDITURE CI~%ESiFICATION 54 CONTRACTUAL SERVICES 59 OTHER EXPENDITURES 71 BOND PRINCIPAL 72 INTEREST EXPENSE 73 BD/~K kND FISCAL FEES 80 INTERFL~D TRANSFERS 81 OTHER FINANCING USES Totals SO~PRCE OF FUNDS 140 SERIES 1987A E&I, PW FACILITY 170 SERIES 1993B B&I, PUBLIC BLDGS 180 SERIES 2001 B&I, VILLAGE F~%LL 190 SERIES 2003 B&I, VIL~GB ~ALL 200 SERIES 2002B B&I, PUBLIC BLDGS 230 SERIES 2002A B&I, TIF 240 SERIES 1992B B&I, TIF 250 SERIES 1993A B&I, TIF 260 SERIES 1994B B&I, TIF 270 SERIES 1996B B&I, TIF 280 SERIES 1998B B&I, TIF 290 SERIES 1999 B&I, TIF 300 SERIES 1991A H&I, FI~DOD 310 SERIES 1992A H&I, FL~DOD 320 SERIES 1993B B&I, FLOOD 330 SERIES 1994A E&I, FLOOD 340 SERIES 1998A B&I, FLOOD 350 SERIES 1998A E&I, FLOOD 360 380 390 400 410 420 430 440 480 810 830 SERIES 1998C B&I, TIF IEPA FLOOD CONTROL LOANS B&I SERIES 2000 B&I, FLOOD CONTROL SERIES 2002B B&I, FLOOD SERIES 1994A SERIES 1996A H&I, SERIES 1998A B&I, STREET IMP. STREET IMP. STREET IMP. SERIES 2002B B&I, STREET IMP. SERIES 2002 LIBP~RY BONDS B&I SSA #1 PROSPECT MEADOWS B&I SSA #6 GEORGE/ALBERT B&I 780,850 3,892,554 1,112,615 -2,739,939 -246.3 791,494 2,356,475 1,339,120 -1,017,355 -76.0 901,592 3,197,300 1,483,679 -1,713,628 ~115.5 1,404,613 3,594,717 1,912,478 -2,082,239 -137.7 35,028 40,055 40,055 0 0 0 0 0 3,913,577 19,041,101 6,487,940 -7,553,161 -137.6 0 34,564 0 ~34,564 0 0 0 0 3,511,964 4,003,874 4,060,929 57,055 1.4 401,613 1,301,485 1,416,011 114,526 8.1 0 9,914 11,000 5,086 46.2 0 1,498,464 0 -1,498,464 0 6,196,800 0 -6,196,800 3,919,577 19,041,101 5,487,940 -7,$53,161 -137.6 0 121,000 121,000 0 0 2,781,184 601,033 -2,180,151 -362.7 255,389 403,174 390,582 ~12,592 -3.2 0 0 0 0 525,461 547,196 0 -547,196 456,650 463,386 0 -463,386 0 0 0 0 0 1,014,451 458,930 -555,521 -121.0 0 0 O 0 153,150 156,750 157,300 590 0.3 51,031 52,363 92,764 401 0.8 0 517,900 518,050 150 0 0 0 0 0 0 0 0 0 1,240,599 304,392 -938,207 -307.6 0 629,998 178,260 -451,698 -253.4 189,940 210,330 210,380 50 57,14I 64,432 64,784 392 0.5 130,663 151,625 152~076 451 0.3 168,630 494,992 613,358 118,406 19.3 55,749 112,098 112,498 400 0.4 430,132 444,931 0 -444,931 0 2,123,232 619,178 -1,604,054 -242.9 0 0 0 0 841,150 892,450 893,300 850 0.1 963,463 579,035 0 -579,035 0 0 0 0 0 0 0 0 35,028 40,055 40,055 0 2O FRRDBR01 SUM 033 DEBT SERVICE 11 Months VILLAGE OF MOUNT PROSPECT i Month Department Budget Expenditure Summary 01/01/02 - 11/30/02 Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent Totals 3,913,577 13,041,101 $,487,940 -7,553,161 -137.6 14:32:50 FRRDBR01 SUM 031 11 Months VILLAGE OF MOUNT PROSPECT i Mont~ Department Budget Expenditure Summary 01/01/02 - 11/30/02 RETIREE PENSIONS Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 MISCELLANEOUS 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 FUND 720 FIRE PENSION FUND 730 BENEFIT TRUST #2 FUND Totals 4,329 47,620 51,957 148,832 1,662,907 1,979,010 148,574 1,628,689 1,921,800 4,337 8.3 316,103 16.0 293,111 15.3 298,735 3,339,216 3,952,767 613,551 15.5 298,735 3,338,338 3,945,967 0 58 6,800 0 106 0 0 714 0 607,629 15.4 6,742 99.1 -106 -714 298,735 3,339,216 3,952,767 613,551 15.8 1,302 14,324 15,627 148,832 1,662,907 1,979,010 145,574 1,628,689 1,921,800 3,027 33,296 36,330 1,303 8.3 316,103 16.0 293,111 15.3 3,034 8.4 298,735 3,339,216 3,952,767 613,551 15.8 22 FRRDBR01 SUM03i 11 Months VILLAGE OF MOUNT PROSPECT i Month Department Budget Expenditure Summary Oi/Oi/02 il/3o/o2 RISK MANAGEMENT Eur MO Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGRAM TOTALS 01 CASUALTY & PROPERTY INSURANCE 02 MEDICAL INSURANCE Totals ~XPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE Totals SOURCE OF ~JNDS 690 RISK MANAGEMENT FUND Totals 51,476 847,364 775,315 280,285 2,879,472 3,095,010 331,761 3,726,836 3,~70,325 -72,049 -9.3 215,538 7.0 143,489 3.7 225 4,161 45,000 331,536 3,722,675 3,825,325 391,761 9,726,836 3,870,325 40,839 90.8 102,650 2.7 143,489 3.7 331,761 3,726,836 3,870,325 143,489 3.7 331,761 3,726,836 3,870,325 143,489 3.7 23 14:32:50 FRRDBR01 SUM o31 11 Months VILLAGE OF MOUNT PROSPECT i Nonth Department Budget Expenditure Summary 01/01/02 - 11/30/02 NON- DEPARTMENTAL Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remainin9 Unexpended Unexpended BalaRce Percent PRO~P.%M TOTALS 01 CONTINGENCIES Totals EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 59 OTHER EXPENDITURES 80 INTERFUND TRANSFERS Totals SOURCE OF FUNDS 001 GENERAL FUND 560 STREET IMPROVEMENT CONST FUND 670 VEHICLE REPLACEMENT FUND Totals 0 367,463 367,463 0 367,463 367,463 0 0 0 0 0 0 0 0 0 0 0 0 0 367,463 367,463 0 367,463 367,463 0 0 0 0 367,463 367,463 0 0 0 0 367,463 367,463 24 ~RRDBRO1 SUM o31 11 Months VILLAGE OF MOUNT PROSP~.CT i Mo=tn Department Budget Expenditure Summary 01/01/02 11/30/02 MOUNT PROSPECT LIBRARY Cur Mo Y-T-D 2002 Expended Expended Budget 91.6% ) Completed 8.3% ) Remaining Unexpended Unexpended Balance Percent PROGP~%M TOTALS 02 LIBRARY SERVICES Totals EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES Totals SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND Totals 0 5,382,877 5,382,877 100.0 0 5,382,877 5,382,877 100.0 0 5,382,877 5,382,877 100.0 0 5,382,877 5,382,877 100.0 0 9,382,877 5,382,877 100.0 0 5,382,877 5,382,877 100.0 25