Loading...
HomeMy WebLinkAbout3. BILLS & FINANCIALS 5/17/05 VILLAGE OF MOUNT PROSPECT CASH POSITION May 01 -11,2005 Cash & Invstmt Receipts Disbursements Other Cash & Invstmt Balance 05/01/05 Per Attached Credits/ Balance 05/01/05 05/11/05 List of Bills Debits 05/11/05 General Fund 5,068,550 1,000,546 480,933 5,588,163 Special Revenue Funds Refuse Disposal Fund 2,144,120 64,087 101,091 2,107,116 Motor Fuel Tax Fund 837,840 135,595 399,738 573,697 Local Law Enforcement Block Grant Fund 619 619 Community Development Blk Grant Fund 12,998 14,064 ( 1 ,066) Asset Seizure Fund 50,267 50,267 DEA Shared Funds 82,824 3,915 78,909 DUI Fine Fund 13,907 1,600 15,507 Debt Service Funds 2,347,723 178,433 2,526,156 Capital Projects Funds Capital Improvement Fund 1,721,298 1,721,298 Series 2003 Fund Downtown Redevelopment Const Fund 1,069,035 36,087 1,105,122 Street Improvement Construction Fund 1,061,403 1,576 1,062,979 Flood Control Construction Fund 1,040,359 1,040,359 Enterprise Funds Water & Sewer Fund 3,529,358 207,796 381,972 3,355,182 Village Parking System Fund 182,370 3,213 346 185,237 Parking System Revenue Fund 69,438 2,614 122 71,930 Internal Service Funds Vehicle Maintenance Fund 297,567 1,171 296,396 Vehicle Replacement Fund 5,148,321 68,940 5,079,381 Computer Replacement Fund 617,475 617,475 Risk Management Fund 1,504,094 49,742 406,530 1,147,306 Trust & AQencv Funds Police Pension Fund 35,229,477 21,000 300 35,250,177 Fire Pension Fund 36,351,417 17,904 36,369,321 Flexcomp Trust Fund 6,214 10,030 5,050 11,194 Escrow Deposit Fund 1,191,874 14,035 14,126 1,191,783 99,578,548 1,744,258 1,878,298 99,444,508 REPORT: àPBOARDRPT GENERATED: 23 NOV 04 lU5 RUN: THURSDAY MAY122005 09:06 RELEASE ID : PAGE VILLAGE OF ~10UNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM .~PRIL 28 2005 TO !fJAY 11 2005 ----------------------------------------------------------------------------------------------------------------------------------- DEPT VENDOR NBR VENDOR NÞ..ME INVOICE DESCRIPTION Þ.JvIOUNT ----- - -- ----------------------- - - ----- - - ------ ------------------------------------- -------- -----------_u_- ---- -- ---- ------ -------- 001 02184 ABBOTT RUBBER CO., INC. CHEMICAL SUCTION HOSE 27.74 01010 ACTIVE Þ.1Þ.RM COMPANY, INC. SERVICE CALL - FIRE ALÞ.RM 10 S 80.00 05205 AIRGAS NORTH CENTRAL OXYGEN/CYLINDER RENTAL 101. 95 08397 ALLEN, BRANDON WORK CLOTHES/SHOES 150.30 01620 Þ.MERICAN LANDSCAPING INC. 2005 PARKWAY RESTORATION CONTR 151. 79 01830 ANDER.SON ELEVATOR CO. MAINENANCE/INSPECTION FOR ELEV 140.00 07633 ARBOR GREEN, LTD 2005 TREE REMOVAL CONTRACT 13671.05 2005 TREE TRIMMING CONTRACT 3677. 55 u_--_u_---- 17348.60 02138 ARMOR SYSTEMS CORPORATION COLLECTION SERVICES 792.79 07718 AUTOMOTIVE RENTALS, INC. REFUND-VEHICLES SOLD 252.00 02405 B & H PHOTO !VIDEO SONY LC-400 CAMCORDER SOFT CAS 299.95 PANASONI C DMR - E55S DVD RECORDE 659.85 SHIPPING 17.55 PRICE ADJ. FOR DMR-S10S SO03919 90.00 u_-_uuu_- 1067.35 06287 BEDCO MECHANICAL REPAIRS TO #7 ROOFTOP UNIT - 1230.95 REPAIRS TO A/C UNIT - 1700 W 864.00 REPAIRS TO TRANE UNIT IN BOlLE 1021.15 _u---------- 3116.10 07280 BERG, CHRISTOPHER REIMBURSE EXPENSES 100.02 02757 BESSE MEDICÞ.L SUPPLY MEDICAL SUPPLIES 126.73 08023 BLAINE WINDOW HARDWARE, INC. REPLACEMENT CASE ROTO OPERATOR 379.66 09060 BOYLE, TOM REBATE FOR 13 SQUARES OF PUBLI 552.50 05987 BURKEMPER, LISA REINBIJRSE-MICROSOFT ACCESS TRN 65.00 01008 BUSSE'S FLOWERS & GIFTS FLORAL ARR.à.NGEMENTS DELIVERED 118.60 01014 CA.DE INDUSTRIES REPLAWIENT EXTERIOR CARPET RU 797.00 01031 CÞ.REER TRACK REGISTER=SAR.A.H KLASSY 99.00 05707 CASH RETIREMENT GIFT-DOOLITTLE 500.00 RETIREMENT GIFT-J . RORAY 500.00 -------n--.- 1000.00 REPORT: APBOARDRPT GENERATED: 23 tiOV 04 14: 15 RUN: THURSDAY MÞ,Y122005 09:06 RELEASE ID : PAGE VILL.~GE OF HOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOA.RD OF TRUSTEES FRO~1 .~PRIL 28 2005 TO ~1AY 11 2005 --------- -_u- --- --- _u -- ---- -- -- u -- -.. - ---- -- -- -. -- --- -- _uu_- -- ---_u- --_u- --_u- ---- --- - -_u------ ---- --- -- _u- -- ------- ----- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT ------ - - -- -- -- -- ----- --. ---- -- - --- ---- -- ---- --- -- -- -- -- -- .------- -------_u- ---- --- --------. -- _u -- -- ------_u_-------------------- 01049 CDW GOVERN~1ENT, INC TONER CÞ.RTRIDGES 6903.40 QUI CKBOOKS FOR DAVE ERB 202.99 1 Camera Digital IiI Memory Car lì9. 99 --------_u-- 7286.38 01056 CENTRAL CONTINENTAL BAKERY PASTRY 111.50 05375 CENTURY CLEANERS UNIFORM CLEANING 161.08 01069 CHE~ RITE PRODUCTS COHPANY MISC. CUSTODIAL SUPPLIES 577.95 01075 CHICAGO METRO CHAPTER APWÞ. REGISTRATION FEE FOR 42 EMPLOY 525.00 01097 CINTAS CORP R.EPLACEMENT IJIH FORM PANTS FOR 444.80 03800 CLARK, SllliDRA M. CLOTHING ALLOWANCE 58.05 01118 CLERK OF THE CIRCUIT COURT PAYROLL FOR - 042805 442.31 08865 CLOSED CIRCUIT INNOVATIONS, INC. MÞ.INT . AGREEMENT 427.00 01147 COMMONWEALTH EDISON MUNICIPAL STREET LIGHTING 8768.46 12 W NORTHWEST HIGHW.~Y - ACCT# 21. 49 ------------- 8ì89.95 01186 COONEY, WILLIÞ.\1 J. ADMIN.ASST DAY EXPENSES 59.17 REMOTE FOR PROJECTER 54.24 LUNCH W/ZANDER,DIVITA 39.86 ST.m MEETING EXPENSE 18.54 ------_u---- 171.81 08589 CRITICAL REACH 2005 SUPPORT FEES 250.00 08813 CURTIS, SHARYL PAYROLL FOR - 042805 226.15 08065 CVS-PHARMA.CY, INC. PRISONER MEDICATION 9.99 01241 DAWSON, HENRY C. EXPENSES IDAWSON, HENRY 122.08 08533 DEERFIELD Þ.CTIVEWEAP. EMBROIDERY ON BIKE PATROL UNIF 31.00 01253 DES PLAINES GLASS COMPANY GLÞ.SS AND GLAZING TO REGLAZE 225.00 01278 DISPLAY SUPPLY & LIGHTING, iNC. BLACK LOOP VELCRO 68.50 09084 DIVIETRO, DONATO REAL ESTÞ.TE TRA.NSFER STAMP 760.00 01303 DREISILKER ELECTRIC MOTORS, rNC V-BELT 39.88 06343 EDDINGTON, RICHARD NORTHiJEST POLICE .~CADEMY 30.00 DOJ LIJIJCH 40.00 POLICE SNIPER REPORT 17 .00 --_uu------ 87.00 REPORT: ,APBOARDRPT GENERmD: 23 NOV 04 14:15 RUN: 09: 06 RELEÞ.SE ID : VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOAÞ.öÕFTÞUST@§' . FROM APRIL 28 2005 TO MAY 11 2005 PAGE DEPT INVOICE DESCRIPTION --- ---__00 ----------- -- ------ - - ---- -----------h__- ------- - --- - --- --- -- -- ---- ---------- --- -- ----00____--_--- ----- -----_u_--------- -".MOUNT VENDOR NBR VENDOR NAME - -- ------ --_u_------------- -- - -- - --------- ----------- ------------ -- - - ---- -- ---- --------_u_------------"u_----"---------------_u 01328 EL-COR INDUSTRIES, INC. 01342 EI~ERGENCY MEDIC.~L PRODUCTS 01377 FEDERAL EXPRESS CORP Repair Parts 1 PS - 10 PRO SPLINT OVERNIGHT SHIP~!ENT FEDEX PICK UP 00329 FELL, JUDITH B. SUPPLIES FOR NEW RESIDENTS BÞ.TTERIES FOR MEDICAL EQUIP COOLERS FOR HOME DELIVERD MEAL 08765 FIFTH THIRD BANK 00102 FIRE PENSION FUND 01422 FOLGERS FLA.G & DECORATING, INC 01522 GRAINGER INC. ISSA ANNUAL MEMBERSHIP PAYROLL FOR - 042805 BANNER INSTALLATION - TREE CIT 12 - HAND SOAP CARTRIDGES MOP BUCKETS WITH RINGERS (5) 01551 HALL SIGNS, INC. 01610 HOME DEPOT CREDIT SERVICES 00106 ICMA RETIREMENT TRUST - 401 50 - 18" X 24" SPEED LIMIT SIG KEYS/STATION #13 PAYROLL FOR - 042805 EDDINGTON-401K 5/12/05 P/R 00107 ICMA RETIREMENT TRUST - 457 05444 IICLE 01658 I LCMÞ- 00108 ILLINOIS DEPARTMENT OF REVENUE PAYROLL FOR - 042805 MUNICIPAL LAW & PRACTICE CONFERENCE REGISTRATION PAYROLL FOR - 042805 VOID PR FOR - 042805 PÞ.YROLL FOR - 042905 PAYROLL FOR - 043005 01685 ILLINOIS FIRE INSPECTORS ASSN. 25 HÞ.ZNAT FIRST RESPONDER 00109 ILLINOIS MUNICIPÞ.L RETIREMENT FUND PAYROLL FOR - 042805 01122 ILLINOIS STATE DISBURSENENT UNIT PAYROLL FOR - 042805 PÞ.YROLL FOR - 042805 P.~YROLL FOR. 042805 PAYROLL FOR - 042805 485.00 33.29 12.42 213.49 u__u_------ 225.91 25.00 11.96 35.88 u_---------- 72.84 120.00 17903.93 1155.00 53.42 353.41 ---Uh--_--- 406.83 253.50 27.95 750.00 373.37 ---h__h__h 1123.37 18375.30 99.50 240.00 19586.80 67.71- 192.40 67.71 _U--U_----- 19779.20 807.50 237.00 357.69 125.25 520.75 1169.98 REPORT: Þ.PBO,~RDRPT GENERATED: 23 NOV 04 14:15 RUN: THURSDAY 11AYl2200S 09:06 RELEASE ID : VILLAGE OF l.jOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOÞ.F.D OF TRUSTEES FROl1 APRIL 28 2005 TO [.l"Y 11 2005 PAGE DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION - _u_U- - -- --_u -- n_--- ---- - - --n - --- - -- u- - -- ------ - --- - -_u-- -- n ---- -- -- - - - - -- ---- -- -- ---- -- --- _u----- ----- uu_- n- ---------- ANOu'NT - --- - ------ - ------------- ------ -------- -- --- ---- ----------- -------- -- -- --- -- - --- - -- -. - ------------ --u_--------------- n_--- ------- 04993 ILLINOIS STATE TOLL HWY .~UTHORITY 07433 INAGETEC L P 08615 INFOCODE CORPORATION ORGÞ.NIPTION.,L MEMBERSHIPS ID#90 132 7 802 3B r1.~p UPDATE FOR DCC, INV#1O404 SHIPPING 06557 INSTITUTE OF TRANSPORTATION ENG. ~l~NUÞ.L ON UNIFORM TRAFFIC CONT 7TH EDITION "TRIP GENERATION" 3RD EDITION "PARKING GENERATIO FREIGHT CHARGES 01600 JACKSON-HIRSH, INC. 00353 JANONIS, 11ICHAEL E. 02408 JOHN E. REID AND ASSOCIATES 01818 KERSTEIN, JUNE 06995 KGI LANDSCAPING LÞ.MIN.~TING SUPPLIES LUNCH/MEETING POLYGRAPH EXÞ.M ~IONTHLY REIMB SPRING TREE PLA.1IJTING PROGRAM SPRING TREE PLANTING PROGRAM 01849 KUSTOM SIGNALS, INC. 01861 LANDS' END BUSINESS OUTFITTERS OB631 LECHNER AND SONS 01918 LUNDSTROM'S NURSERY, INC. PARTS & LABOR REPLACEMENT GARNENTS FOR PUBLI 2005 UNIFORN RENTAL Þ.ND CLEAN I 2005 TURF MO'~ING CONTRACT LANDSC.~PE MAINTENANCE - VARIOU LA.NDSCAPE ~ A.INTENANCE - VARIOU INSTALL MULCH AT NOEHLING PARK 01941 11Þ1COLM, JOHN EXPENSES/I'l~LCOLI'1 05709 MEÞ]E ELECTRIC CO. INC. REPAIRS TO EVP, ~¡OLF AND KENSI 00116 METRO FEDERAL CREDIT UNION PAYROLL FOP - 042B05 00117 METROPOLITAN Þ.LLIA.NCE - POLICE PÞ:!ROLL FOE - 042BQ5 02057 MORTON A"~BORETUI'I THEE BOOKLETS 08302 MOUNT PROSPECT FLOWERS FLOWER þ"qRÞ1JGE~!ENT -_u_-------- 2173.67 50.00 638.84 3000.00 10.00 ----_u------ 3010.00 190.40 225.00 95.00 38.40 _u---------- 548.80 6B.47 40.39 175.00 54.11 474.75 3805.00 ------------- 427 9.7 5 950.00 1180.70 122.07 3554.03 8094.44 4.44 210.00 _u---------- 11B62.91 197.B4 618. BO 1250.00 702.00 llJ.OO 37.00 REPORT: .APBOÞ.RDPPT GENERÞ.TED: 23 ¡¡OV 04 14:15 RUN: THURSDP,Y MAYl2200S 09:06 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BoARD ðF FROM APRIL 28 2005 TO /.1AY 11 2005 ------------------------------------------------------------------------------------------------------.---------------------------- DEPT VENDOR NBP. VENDOR NÞ.ME INVOICE DESCRIPTION AMOUNT ------ ---- -- -- ------ -- -------- - --------------------------_0._---------_0._---- ---- -- --- - ---- ---- ------ 00______---_0._------0._----- 02067 ~IOUNT PROSPECT HISTORICAL SOC. MAY 2005 BUDGET Þ.LLOCATION 3125.00 00123 N.à.TIONíHDE WùTUAL INSURANCE COMPANY P.WROLL FOR - 042805 15981.70 VOID PR FOR - 042805 250.00- PÞ..YROLL FOR - 043005 250.00 ----------00- 15981.70 02155 NEXTEL COMMUNICATIONS ACCT#157600518 454.44 ACCT#15 7600518 212.99 Þ.CCTnl57600518 80.52 ACCT#157600518 423.73 ACCT#157600518 166.57 ACCTnl57600518 848.08 ACCTnl57600518 105.98 Þ.CCTnl57600518 149.74 ACCTn157600518 97.97 ACCT#157600518 187.23 ACCT#157600518 14.00 ACCT# 157600518 332.99 ----_-__h_-- 3074.24 02189 NORTHWEST CENTRAL DISPATCH SYS SERVICE RENDERED-JUNE 2005 43294.48 SERVICE RENDERED-JUNE 2005 10823.62 ---_0._-_0._- 54118.10 05124 NORTHWESTERN UNIVERSITY REGISTRATION 1700.00 09085 ODDO, DOLORES REFUND 12.00 02230 OFFICEMAX CREDIT PLÞ.N OFFICE SUPP. & INV#6985J097 353.41 08580 OKLAHDr4A STATE UNIVERSITY PHYSICAL FOR FD INTER 55.00 02256 PÞ.DDOCK PUBLICATIONS, INC. AD FOR HR DIRECTOR 475.00 08566 PARRILLI, LEE OV:ERP.~YMENT 24.00 08566 PATEL, BHUPENDRA REFUND UNINCORPORATED 72.00 05026 mFORMÞ.NCE CORP. WILKS LOGO 790.00 02303 PETTY CASH - FIRE DEPT. TRNG, ~ EETINGS, SUPPLIES 45.00 TRNG, MEETINGS, SUPPLIES 6.05 TRNG, MEETINGS, SUPPLI ES 3.18 TRNG, MEETINGS, SUPPLIES 13.92 TRNG,¡~EETINGS, SUPPLIES 62.93 TRNG, ~IEETINGS, SUPPLIES 18.63 ----------_0. 149.71 00124 POLICE PE!{SION FUND PÞ.YROLL FOR - 042805 20760.69 VOID PR FOR - 042805 257.65- PAYROLL FOR - 043005 257.65 - - - -- - - - -- - -- REPORT: mOARDRPT GENEPmc: 23 NOV 04 14:15 RUN: THURSDAY M.mmOS 09:06 RELEASE ID : PAGE DEPT VENDOR NBR ____00--_00___-------- ------------- ---- __00----__---_.--0._-------- -- --------------------------------------- --.- ---------_0._------ ANOUNT VILLAGE OF MOm-¡T PROSPECT LIST OF BILLS PRESENTED TO THE BO~J..D OF TRUSTEES FROM APRIL 28 2005 TO ~!AY 11 2005 VENDOR NAJ.IE INVOICE DESCRIPTION -------------- ------- -- ---- -- - - - --- -- ------- ------------ ---------- - - - - ---- ---- -- ------------------- ---- ----- --- - - -- ---- -______n--- 04921 06661 08573 08573 04673 02495 01780 07529 00125 02546 00433 04559 00441 09007 POPE, ELIUIBETH A. PAYROLL FOR - 042805 PRIME OFFICE PROD. SUPPLIES SUPPLIES PRUS, ANNA REAL ESTATE TRANSFER STAMP ROSS, KA.THLEEN REAL ESTATE TRANSFER STAMP SAN BERNÞ-.RDINO COUNTY CHILD SUPPORT PAYMENTS PAYROLL FOR - 042805 SAYERS CDr4PUTER SOURCE LJ 8100 PRINTER CLEANING SBC SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SERVICE SCHAMBA.CH SOFTWARE SOLUTIONS, INC. CONOSULTING SERVICES SEIU LOCAL 73 PAYROLL FOR - 042805 SIDWELL CŒPANY ACCT.#3514015 CODE SLS SMITH, ROBERT REINE EXP&'1SES SP.àJ.R, STEVÞ..N REI!~B EXPENSES STRABL, DÞ.VID P<.DVANCE-ILCMA CONF/D.STRÞJJL TIGHTPO?E ¡~EDIA SYSTEM FOUR ŒÞlJNEL MPEG2 SERVER W/24 FOUR CHÞ.NNEL MPEG2 SERVER W/24 FOUR CHANNEL MPEG2 SERVER W/24 SHIPPING 20750.69 923.08 133.73 31.92 ------------- 165.65 720.00 440.00 115.38 95.00 15.25 50.84 10.17 15.25 101.69 50.84 193.20 50.84 75.26 132 .19 40.67 40.67 183.04 1032.12 1011.78 650.79 621.74 248.00 150.56 ------------- 4675.90 4275.00 871.72 482.50 22.00 30.00 439.56 2910.00 1000.00 1066.00 45.00 ____00--__--- 5021.00 REPORT: .~PBOARDRPT GENERATED: 2) NCV 04 14:15 . RUN: THURSDAY NAYl22005 09: 06 RELEASE ID : PAGE VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOMb at fRUŠTE~Š . FROM APRIL 28 2005 TO MÞ.Y 11 2005 -- - -- -- -- -- ---- ------- ---- --- - - - -- -- -- - -- ---- ---- --------------------- ----- -- ------- --- -- --------------- --- - ---- -- -- -- ---- ---- ----- DEPT VENDOR NBR VENDOR NANE INVOICE DESCRIPTION AMClJ1JT ----- - _0._-- ------------------- ---- -- ----- -- -0._00--000.___---------- ---- ----- ----0._- - ----------00____- - -_0. ------0._- -- -- -------- 09079 TRAVEL ADVISORS AIRFÞ.RE/LÞ.MBEL, BRIA.!'I 372.40 02722 TRI -STATE ELECTRONIC CORP BATTERIES 85.44 07033 TWEEDIE, BlIRT REIMB EXPENSES 42.00 05686 ULINE INC VIDEO MAILERS 69.46 08821 UNIFORMITY INCORPORATED UNIFORM SUPPLIES 142.95 00127 UNITED WAY PAYROLL FOR - 042805 453.80 02760 UNIVERSITY OF ILLINOIS SUBSCRIPTION RENEWAL TO 'HOME, 20.00 02784 V./ill DRIEL'S MEDIC.% SURGICAL REPAIRS FOR MEDI CAL EQUIPMENT 68.50 00128 VILLAGE OF MOUNT PROSPECT PAYROLL FOR - 042805 20173.59 VOID PR FOR - 042805 19.32 ------_0._--- 20192.91 04314 VILLAGE OF !~OUNT PROSPECT - PAYROLL WIRES PAYROLL FOR - 042805 162.29 PAYROLL FOR - 042805 152601.29 PAYROLL FOR - 042805 30193.72 PAYROLL FOR - 042805 15835.85 PAYROLL FOR - 042805 1916.69 VOID PR FOR - 042805 443.46- PAYROLL FOR - 042905 1260.81 PAYROLL FOR - 042905 652.08 p_mOLL FOR - 042905 342.00 PAYROLL FOR - 043005 423.52 --_0._------- 202944.79 02843 WAVE PRINTING TRAINING ACADEMY/SUPPLIES 329.00 05746 WISCTF PAYROLL FOR - 042805 542.48 TOTAL : 480933 .40 030 08399 JP MORGAN CHASE BANK TIPPING FEES 94484.00 FIXED COSTS 6577.54 --u--------- 101061.54 02155 NEXTEL COMI,rc~1I c.:>.TI ONS ACCT#157600518 8.72 01780 SBC SEP'lICE 20.34 TOTAL : 101090.60 050 01302 ALDRIDGE ELECTRIC, INC. 2005 TRAFFIC SIGNAL MAINTENÞlIC 2064.00 02167 Þ.RROH ROAD CONSTRUCTION 2005 STREET RESURFÞ.CING PROGRA 390503.39 REPORT: APBOARDRPT GENERATED: 23 NOV 04 14: 15 RUN: THURSDAY 1'1.mm05 09: Of RELEASE ID : PAGE VILLÞ.GE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 28 2005 TO 1>IAY 11 2005 ------ -- --- --- --- -- -- --------- - --- ---- -- ------ - -- --- -- - -- -- - --- - ---- -- ----------- -- --- ---- ------------ ------- -- ---- --- --- ----- ----- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION Þ140UNT ------ --- -- --- -------------- - -- -------- -- ----- -- -- -- ---- - - -- -- -- -- - -- ------ -------- -- ---------------- -- -- ---- -- --- ---- -- --- --- ----- 01148 COMMONWEALTH EDISON VILLAGE STREET LIGHTING #08170 3337.80 VILLAGE STREET 1823.21 ------------- 5161.01 07661 ~1ATERIAL TESTING LABORATORIES INC. MATERIAL TESTING SERVICES 2010.00 TOTAL : 399738.40 070 05467 LEÞ] INSPECTORS, INC. INV#3187 HOFFMAN RESIDENCE 250.00 01965 ~ ARTAN CONSTRUCTION WALLSTREET WATER MAIN REPLACEN 776.40 02420 RESOURCES FOR COMMUNITY LIVING RESOURCES FOR COMMUNITY LIVING 1437.50 06944 WHITE EAGLE RENODELING INC. REHAB 2110 JODY COURT 11600.00 TOTAL : 14063.90 085 09038 IRON GRIP BARBELL COMPANY ASSOSRTED FITNESS WEIGHT/FRT 1915.20 09039 VETERANS TRUCKING TRUCKING FEE-LIFE FIITNESS EQP 750.00 TRUCKING FEE-LIFE FITNESS EQP 1250.00 --------_0.0. 2000.00 TOTAL : 3915.20 610 03956 A - K UNDERGROUND, INC. 2004 STORM, CATCH BÞ.sIN&INLET 3555.80 04391 ALEXANDER CHEMICAL CHLORINE TANK RENTAL 90.00 01568 ANERICAN COMPUTER & CONNUN. INC REPROGRAMMED OF MODEM - HAYES 529.00 01620 Þ.MERICAN LANDSCAPING INC. 2005 PARKWÞ._Y RESTORATION CONTR 1612.74 2005 PARK'~AY F.ESTORATION CONTR 948.67 --_u_------- 2561.41 01699 AJ.IERIC.~ PUBLIC WORKS ASSOC. OPEN HOUSE GIVE-A-WÞ.YS 522.50 01124 ARTHUR CLESEN, INC. 3 GALLON INDUSTRIAL SPRÞ.YER 53 40 OPENHEAD REPÞ..IR KIT 8.93 ------------- 62.33 02451 BÞ..DGER ~!ETER INC WIRE SEÞ.LS .~D RUBBER WASHERS 215.43 BATTERY PACK 139.74 ---- --- - ----- 356.17 01049 CDí¡ GOVERNNENT, INC 400 BG DICK Fii400/800 fu\!D SITG 45907 REPORT:, APBOARDRPT GENERATED: 23 NOV 0414:15 RUN: THURSDAY MAY122005 09:06 RELE.~SE ID : PAGE VILLAGE OF ~10UNT PROSPECT LIST OF BILLS PRESE!ì':ED TO THE80Þ:RDÕffÆuSTÊE:S FROM Þ.PRIL 28 2005 TO ~iAY 11 2005 -- ------ --_0._--_0." --- --- --- - ---- ------- ----------. ---. ----- - ----- - - - -- -- --- ---- -------.--------- ---------- ---- -- ---- -- ---------- DEPT VENDOR NBR VENDOR NAME HìVOICE DESCRIPTION ANOUNT --_0._--------_. n_- -- - ------- ---- -- -----_0.---__00_--_- -- -- ---. - -- - - - -. --- -- - -- -----------00____--_-----------------_00__--___---- 05375 CENTURY CLEA1JERS UNIFORM CLEANING 161.07 01075 CHICAGO METRO ŒAPTER APWA REGISTRATION FEE FOR 42 EMPLOY 525.00 01097 CINTAS CORP REPLACEMENT UNIFORM PANTS FOR 444.80 01147 COMMONWEALTH EDISON 203 E EVERGREEN #4475624003 31.78 BOOSTER STATIONS #0770712000 5428.72 -----'---00-- 5460.50 05434 CORRPRO COMPANIES, INC. Þ.NN!JAL CATHODIC MAINTENANCE FO 1890.00 08146 DELL COMPUTER CORPORATION 130W Þ.C ADAPTER 78.62 01313 DUPAGE TOPSOIL INC. 2 SE14I LOADS OF PULVERIZED TOP 420.00 09050 ELAN INDUSTRIES, INC. SANITARY SEIlER FLOW MONITORING 7000.00 08829 ENGLEWOOD ELECTRICAL SUPPLY REPLACEMENT BACKLIGHT LAMP 137.43 08425 F.~NSWORTH GROUP PROFESSIONAL SERVICES SCADA 1137.00 01377 FEDERAL EXPRESS CORP COURIER CHARGES 1/1/05 - 12/31 220.36 01757 ISAWWÞ. REGISTRATION FEE FOR MATT OVER 85.00 01861 LA.NDS' END BUS !NESS OUTFITTERS REPLACEMENT GARMENTS FOR PUBLI 1180.70 08631 LECHNER AND SONS 2005 UNIFORM RENTAL fu\[) CLEANI 122.07 01918 LUNDSTROM'S NURSERY, INC. 2005 TURF MOWING CONTRACT 383.39 01965 I4ARTAM CONSTRUCTION PROSPECT MEADOWS WATER l.jAIN 77981.13 WALLSTREET WATER 14AIN REPLACEM 843.60 ---------.--- 78824.73 02155 NEXTEL COl4M1JNICATIONS ACCT#157600518 277.69 ACCT#157600518 11. 92 -------0.'--- 289.61 02160 NFPA STALLCUP'S ELECTRICAL REFERENC 79.90 02384 RA.DIO SHACK SPEAKERS FOR SCÞ.DA ROOM 88.48 09087 SACCONE, RICHARD A. WATER SYSTEM REPAIRS 65.00 01780 sac SER'IICE 1357.51 SERVICE 167.64 ----_0._----. 1525.15 04838 TH:RD ~!!LWITnuM ASSOC. INC. PRINTING & MÞJLING 1719.10 02773 U.S. B~.NK TRUST \'iÞ.TER 159891. 00 REPORT: ~.PBOARDRPT GENERATED: 23 NOV 04 14:1) RUN: THURSDAY MAYl22005 09:06 RELEASE ID : PAGE 10 VILLAGE OF !~OmJT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 28 2005 TO MF.Y 11 2005 - --- -- --------- ----_0. ------ --u --- -- -- --- -- ------------ ----- -----_0.- -- - -- -- -- - --- --n -- -- -- - -- -- ------ ------ -_u------ -- ---- - ---- DEPT VENDOR NBR VENDOR NÞ.ME INVOICE DESCRIPTION AMOUNT - ------ -- ------_0._- ----------- - -------- ---------------------------- -- ----- - - - -- ---------------------- -- ---------------- --- -------- POi'iER 0 HI FIXED 10201.00 21751. 00 80148.00 ------------- 271991.00 02832 WALMÞ.RT COMMUNITY PHOTO DEVELOPING 7.28 TOTAL : 381972.47 620 08731 MALKO ELECTRIC COMPANY STROBE LIGHT FOR PARKING GARAG 346.00 TOTAL : 346.00 630 01147 COMMONWEALTH EDISON 13 E NORTHWEST HIGHWAY #447577 121.73 TOTAL : 121.73 660 02796 ALPHÞ. PRIME COMMUNICATIONS PAGER BATTERY 100.00 02920 BLS ENTERPRISES / INC. RUBBER TRACK PAD 47.42 02940 BRAKE ALIGN COMPANY BRAKE DRUM AND SUPPLIES 301.32 01990 MCMASTER-CARR SUPPLY CO. FLANGE/GASKET 86.28 02826 MI CHÞ.EL WAGNER & SONS I INC. PIPE SUPPLIES 122.84 02018 i@WAY TRUCK PARTS GOODYEAR BELT/WARRANTY CREDIT 24.65 02155 NEXTEL COMMUNICATIONS ACCTm7600518 230.64 02402 REDI -STRIP COMP.I\¡'IY HYDRAULI C TANK BRACKETS 162.00 01780 SBC SERVICE 50.88 05004 IJERIZON WIRELESS PAGER MESSAGING SERVICE 44.82 TOTAL : 117 Q.8 5 670 02030 MILES CHEVROLET, INC. 2 - 2005 CHEVROLET TAHOE 2 í!HE 51607.76 2005 CHEVROLET iMPALA POLICE 17332.54 --_u-------- 68940.30 TOTAL : 68940.30 690 08109 CÞ.MBR.IDGE INTEGRATED SERVICE CLÞ.It.IS Þ.DMIN 600.00 06461 HELP HELP EXCESS LIABILiTY 67977.00 05943 iL DIRECTOR OF EMPLOYMENT SECURITY ACCT «03008395 407.07 REPORT:. APBOARDRPT GENERATED: 23 NOV 04 14: 15 RUt~: THURSDAY MÞ.Yl22005 09: 06 RELEASE ID : PAGE 11 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRtJSTÉÊS FROM APRIL 28 2005 TO MAY 11 2005 _--00_- -- ---- ---- -- - ---_0._--------- 00___--0.00_0.____------------ --_0._-- -------------- -- -- ---" ----- - -----_0._- ---__00___--__----- DEPT VENDOR NBR VENDOR NAME INVOICE DESCRIPTION AMOUNT --__00-- --- - ---- ----"- --- ------ - _00__--___----- -----_0._------_0._---___00__--___------ ---------- ------------------------_0._------ 01737 INTERGOVERNMENTAL PER. BEN. COOP INSURANCE MA.Y 2005 7600.50 INSURANCE MAY 2005 101387.52 INSURÞ.NCE MAY 2005 1924.62 INSURANCE MAY 2005 226633.78 --_0._------- 337546.42 TOm : 406530.49 no 043l4 VILLAGE OF MOUNT PROSPECT - PAYROLL ílIRES PAYROLL FOR" 050105 300.00 TOTAL : 300.00 770 08178 GUARDIAN EMPLOYER DENTAL PLAN 5049.99 TOTÞL : 5049.99 790 00111 INDIANA DEPT OF REVEN1Æ ADAM GILBERT 4/14/05 10.45 02028 MIGHTY MITES AWARDS & SONS PLSQUE FOR J. FÞ.RLEY 95.00 02046 MOBILE PRINT INC. PROGRAM FOR MAYOR-RET . DINNER 297.68 02689 THIRD DISTRICT CIRCUIT COURT BOND Þ10NEY 1688.00 BOND MONEY 1541.00 BOND MONEY 1100.00 BOND MONEY 1275.00 -----------u 5604.00 02808 VILLAGE OF MOUNT PROSPECT DEMOLITION 100.00 INSPECTION 7035.00 OTHER 400.00 -----------00 7535.00 02886 WISCONSIN DEPARTMENT OF REVENUE T .CORR/R.REDLIN APRIL 05 583.42 TOTAL : 14125.55 GRAND TOTAL : 1878298.88 mORT: APSOARDRPT GENERmD: 23 :WV 04 14:15 RUN: THURSDAY tiAYI2200S 09: 06 RELEASE ID : PAGE 12 VILLAGE OF MOUNT PROSPECT LIST OF BILLS PRESENTED TO THE BOARD OF TRUSTEES FROM APRIL 28 2005 TO MAY 11 2005 ------------------------------------------------------------_u_------------------------------------------------------------------- SUMW\RY BY FUND ------------------- -- -- -------- -- ------- ------------------u_----- --------------- ------- -- -------- --- ------ ---- -- u_- -------------- 001 GE¡JERAL FUND 480933.40 030 REFUSE DISPOSAL FUND 101090.60 050 f.IOTOR FUEL TAX FUND 399738.40 070 COMMUNITY DEVELPMNT BLOCK GRJ~T 14063.90 085 DEA SHARED FUNDS FUND 3915.20 610 WATER AND SEWER FUND 381972.47 620 VILLAGE PARKING SYSTEM FUND 346.00 630 P,a.P.KING SYSTEri REVENUE FUND 121. 73 660 VERI CLE MAINTENÞ.NCE FUND 117 o.s 5 670 VEHI CLE REPL.~CEMENT FUND 68940.30 690 RISK MANAGEMENT FUND 406530.49 710 POLICE PENSION FUND 300.00 770 FLEXCOMP ESCROW FUND 5049.99 790 ESCROW DEPOSIT FUND 14125.55 ---0._--_0._-- TOTAL : 1878298,88 ~ VILLAGE OF MOUNT PROSPECT BUDGET REVENUE & EXPENDITURE SUMMARIES April! - April 30, 2005 ,05/12/2005 VILLAGE OF MOUNT PROSPECT 4 Months ( 33.3% ) Completed 18:52:06 Budget 8 Months ( 66.6% ) Remaining Revenue Summary 01/01/05 04/30/05 Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent REVENUE BY CLASSIFICATION PROPERTY TAXES 666,476 5,649,775 11,980,598 6,330,823 52.8 OTHER TAXES 776,134 4,181,491 12,838,924 8,657,433 67.4 LICENSES, PERMITS & FEES 628,132 1,429,998 2,801,736 1,371,738 49-0 INTERGOVERMENT REV. 1,594,139 2,791,112 15,376,615 12,585,503 81. 8 CHARGES FOR SERVICE 1,427,257 4,741,584 16,118,285 11,376,701 70.6 FINES AND FORFEITS 49,081 157,034 527,100 370,066 70.2 INVESTMENT INCOME 86,135 351,088 4,591,12'0 4,240,032 92.4 REIMBURSEMENTS 71,711 199,916 337,616 137,700 40.8 OTHER REVENUE 251,204 1,805,366 4,325,383 2,520,017 58.3 OTHER FINANCING SOURCES o 1,284,400 2,205,000 920,600 41. 8 Total All Funds 5,550,269 22,59J.,764 7J.,J.02,377 48,510,6J.3 68.2 REVENUE BY FUND GENERAL FUND 3,152,125 9,661,021 33,122,688 23,461,667 70.8 REFUSE DISPOSAL FUND 234,549 1,408,169 3,341,773 1,933,604 57.9 MOTOR FUEL TAX FUND 143,204 459,753 1,669,600 1,209,847 72.5 LAW ENFORCEMENT BLOCK GRANT 0 5 10,000 9,995 100.0 COMMUNITY DEVELPMNT BLOCK GRNT 91,575 114,439 499,000 384,561 77.1 ASSET SEIZURE FUND 106 661 500 -161 -32.2 DEA SHARED FUNDS FUND o 390 12,250 11,860 96.8 DUI FINE FUND 22 6,699 10,100 3,401 33.7 SERIES 1987A 8&1, PW FACILITY 8,669 71,263 151,700 80,437 53.0 SERIES 19938 8&1, PUBLIC BLDGS o o ° 0 SERIES 2001 B&I, VILLAGE HALL 22,274 186,186 390,128 203,942 52.3 SERIES 2003 B&I, VILLAGE HALL 6,473 250,781 927,912 677,131 73.0 SERIES 2002B B&I, PUBLIC 8LDGS 30,519 255,852 521,626 265,774 51. o SERIES 2002A B&I, TIF 323 13,361 36,150 22,789 63.0 SERIES 1993A B&I, TIF o o 0 o SERIES 1994B B&I, TIF o o ° o SERIES 1996B B&I, TIF o o ° 0 SERIES 1998B 8&1, TIF 0 o ° 0 SERIES 1999 8&1, TIF 7,781 327,976 888,500 560,524 63.1 SERIES 1992A B&I, FLOOD o o ° o SERIES 1993B 8&1, FLOOD o o ° o SERIES 1994A 8&1, FLOOD o o ° o SERIES 1996A B&I, FLOOD 16,508 81,401 186,083 104,682 56.3 SERIES 1998A B&I, FLOOD 6,845 33,730 61,961 28,231 45.6 SERIES 1998C B&I, TIF 1,354 55,635 151,000 95,365 63.2 IEPA FLOOD CONTROL LOANS B&I 8,648 42,742 492,844 450,102 91.3 SERIES 2000 8&1, FLOOD CONTROL 12,079 59,583 323,779 264,196 81. 6 SERIES 2002B B&I, FLOOD 44,288 218,392 89,508 -128,884 -144. o SERIES 1994A 8&1, STREET IMP. o o ° o SERIES 1996A 8&1, STREET IMP. o o ° 0 SERIES 1998A B&I, STREET IMP. 52,951 261,115 252,000 - 9,115 -3.6 SERIES 2002B 8&1, STREET IMP. 35,458 174,847 83,000 -91,847 -110.7 CAPITAL IMPROVEMENT FUND 43,273 56,589 40,000 -16,589 -41.5 POLICE & FIRE 8LDG CONST FUND o o o o SERIES 2001 PROJECT FUND 0 0 0 0 SERIES 2003 PROJECT FUND 0 0 o 0 2002 LIBRARY PROJECT FUND 0 0 0 0 1 05/12/2005 18,52:06 VILLAGE OF MOUNT PROSPECT Budget Revenue S~ary 01/01/05 - 04/30/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent CAPITAL IMPROVEMENT CONST FUND o o ° o DOWNTOWN REDEVLPMNT CONST 6,897 1,327,249 2,085,975 758,726 36.4 STREET IMPROVEMENT CONST FUND -5,868 520,636 1,365,165 844,529 61. 9 FLOOD CONTROL CONST 1998A o o ° o FLOOD CONTROL CONST FUND 4,834 8,462 12,000 3,538 29.5 WATER AND SEWER FUND 611,851 2,732,230 8,493,217 5,760,987 67.8 VILLAGE PARKING SYSTEM FUND 8,835 36,805 116,236 79,431 68.3 PARKING SYSTEM REVENUE FUND 8,500 35,346 107,370 72,024 67.1 VEHICLE MAINTENANCE FUND 131,962 393,517 1,309,945 916,428 70.0 VEHICLE REPLACEMENT FUND 103,162 335,258 1,058,035 722,777 68.3 COMPUTER REPLACEMENT FUND 17,093 49,969 161,201 111,232 69.0 RISK MANAGEMENT FUND 552,142 1,784,789 5,679,931 3,895,142 68.6 POLICE PENSION FUND 96,304 773,341 3,686,073 2,912,732 79.0 FIRE PENSION FUND 94,264 835,534 3,740,910 2,905,376 77.7 BENEFIT TRUST #2 FUND 0 0 0 0 ESCROW DEPOSIT FUND 0 0 0 0 SSA #1 PROSPECT MEADOWS B&I 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 1,196 17,956 24,217 6,261 25.9 SERIES 2002 LIBRARY BND ESCROW 73 82 0 -82 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 Total All Funds 5,550,269 22,591,764 71,102,377 48,510,613 68.2 2 -05/12/2005 18:53:56 FRRBRRO3 SUM 021 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/05 ~ 04/30/05 40 41 42 Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent 474,035 4,018,598 8,533,459 4,514,861 52.9 574,526 1,540,626 6,855,967 5,315,341 77.5 552,149 1,257,184 2,569,500 1,312,316 51.1 1,387,173 2,283,085 13,270,515 10,987,430 82.8 57,736 200,701 769,431 568,730 73.9 49,081 150,146 505,000 354,854 70.3 21,614 27,693 156,000 128,307 82.2 29,272 90,626 285,116 194,490 68.2 6,539 92,362 177,700 85,338 48.0 o o o o 3,152,125 9,661,021 33,122,688 23,461,667 70.8 GENERAL FUND 43 44 45 46 47 48 49 PROPERTY TAXES OTHER TAXES LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE FINES AND FORFEITS INVESTMENT INCOME REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES TOTAL GENERAL FUND REFUSE DISPOSAL FUND 40 44 126,213 1,071,756 2,266,973 1,195,217 52.7 100,184 320,626 1,044,800 724,174 69.3 8,152 15,252 30,000 14,748 49.2 o 535 o -535 234,549 1,408,169 3,341,773 1,933,604 57.9 PROPERTY TAXES CHARGES FOR SERVICE INVESTMENT INCOME OTHER REVENUE 46 48 TOTAL REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND 43 46 47 INTERGOVERMENT REV. INVESTMENT INCOME REIMBURSEMENTS 136,743 414,941 1,647,100 1,232,159 74.8 6,461 9,456 20,000 10,544 52.7 0 35,356 2,500 -32,856 **** * 143,204 459,753 1,669,600 1,209,847 72.5 TOTAL MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT 43 46 INTERGOVERMENT REV. INVESTMENT INCOME ° ° 0 5 10,000 0 10,000 -5 100.0 TOTAL LAW ENFORCEMENT BLOCK GRANT 0 5 10,000 COMMUNITY DEVELPMNT BLOCK GRNT 9,995 100.0 43 46 48 INTERGOVERMENT REV. INVESTMENT INCOME OTHER REVENUE 70,223 93,086 449,000 355,914 79.3 0 1 o -1 21,352 21,352 50,000 28,648 57.3 91,575 114,439 499,000 384,561 77.1 TOTAL COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND 45 46 FINES AND FORFEITS INVESTMENT INCOME o 106 288 373 100 400 -188 -188. o 27 6.8 TOTAL ASSET SEIZURE FUND 106 661 500 -161 -32.2 DEA SHARED FUNDS FUND 45 46 100.0 -56.0 FINES AND FORFEITS INVESTMENT INCOME ° ° o 390 12,000 250 12,000 -140 1 05/12/2005 4 Months ( 33.3% ) Completed 18,53,56 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6% ) Remaining FRRBRRO3 SUM 021 Budget Revenue by Category within Fund Summary 01/01/05 - 04/30/05 Cur Mo Y-T-D 2005 Unreceived unreceived Received Received Budget Balance Percent TOTAL DEA SHARED FUNDS FUND 0 390 12,250 11,860 96.8 DUI FINE FUND 45 FINES AND FORFEITS a 6,600 10,000 3,400 34.0 46 INVESTMENT INCOME 22 99 100 1 1.0 TOTAL DUI FINE FUND 22 6,699 10,100 3,401 33.7 SERIES 1987A B&I, PW FACILITY 40 PROPERTY TAXES 8,517 70,972 151,500 80,528 53.2 46 INVESTMENT INCOME 152 291 200 -91 -45.5 TOTAL SERIES 1987A B&I, PW FACILITY 8,669 71,263 151,700 80,437 53.0 SERIES 1993B B&I, PUBLIC BLDGS 40 PROPERTY TAXES a a ° ° 46 INVESTMENT INCOME a a ° a 49 OTHER FINANCING SOURCES 0 a ° a TOTAL SERIES 1993B B&I, PUBLIC BLDGS 0 0 ° 0 SERIES 2001 B&I, VILLAGE HALL 40 PROPERTY TAXES 21,892 185,473 389,628 204,155 52.4 46 INVESTMENT INCOME 382 713 500 -213 -42.6 49 OTHER FINANCING SOURCES 0 a a 0 TOTAL SERIES 2001 B&I, VILLAGE HALL 22,274 186,186 390,128 203,942 52.3 SERIES 2003 B&I, VILLAGE HALL 40 PROPERTY TAXES 5,941 48,522 121,912 73,390 60.2 46 INVESTMENT INCOME 532 1,009 1,000 -9 -0.9 49 OTHER FINANCING SOURCES a 201,250 805,000 603,750 75.0 TOTAL SERIES 2003 B&I, VILLAGE HALL 6,473 250,781 927,912 677,131 73.0 SERIES 2002B B&I, PUBLIC BLDGS 40 PROPERTY TAXES 29,878 254,454 517,126 262,672 50.8 46 INVESTMENT INCOME 641 1,398 4,500 3,102 68.9 49 OTHER FINANCING SOURCES a a a a TOTAL SERIES 2002B B&I, PUBLIC BLDGS 30,519 255,852 521,626 265,774 51.0 SERIES 2002A B&I, TIF 41 OTHER TAXES 260 13,184 36,050 22,866 63.4 46 INVESTMENT INCOME 63 177 100 -77 -77.0 49 OTHER FINANCING SOURCES a a a a TOTAL SERIES 2002A B&I, TIF 323 13,361 36,150 22,789 63.0 SERIES 1993A B&I, TIF 41 OTHER TAXES a a a a 46 INVESTMENT INCOME a a 0 a 2 ,05/12/2005 18:53:56 FRRBRRO3 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/05 ~O4/jO/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% } Remaining 49 OTHER FINANCING SOURCES Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent 0 0 0 0 0 0 0 0 TOTAL SERIES 1993A B&:I, TIF SERIES 1994B B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 TOTAL SERIES 1994B B&I, TIF 0 0 0 0 SERIES 1996B B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL SERIES 1996B B&:I, TIF SERIES 1998B B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 TOTAL SERIES 1998B B&I, TIF 0 0 0 0 SERIES 1999 B&I, TIF 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 6,380 323,665 885,000 561,335 63.4 1,401 4,311 3,500 -811 -23.2 0 0 0 0 7,781 327,976 888,500 560,524 63.1 TOTAL SERIES 1999 B&I, TIF SERIES 1992A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 TOTAL SERIES 1992A B&:I, FLOOD 0 0 0 0 SERIES 1993B B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 49 OTHER FINANCING SOURCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL SERIES 1993B B&:I, FLOOD SERIES 1994A B&I, FLOOD 41 OTHER TAXES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 46 49 INVESTMENT INCOME OTHER FINANCING SOURCES TOTAL SERIES 1994A B&:I, FLOOD SERIES 1996A B&I, FLOOD 41 OTHER TAXES 46 INVESTMENT INCOME 16,345 163 81,050 351 185,583 500 104,533 149 56.3 29.8 3 05/12/2005 4 Months ( 33.3~) Completed 18:53:56 VILLAGE 8 Months ( 66.6~ ) Remaining FRRBRRO3 OF MOUNT PROSPECT SUM 021 Budget Revenue by Category within Fund Summary 01/01/05 04/30/05 Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent TOTAL SERIES 1996A B&I, FLOOD 16,508 81,401 186,083 104,682 56.3 SERIES 1998A B&I, FLOOD 41 OTHER TAXES 6,777 33,606 61,861 28,255 45.7 46 INVESTMENT INCOME 68 124 100 -24 -24.0 49 OTHER FINANCING SOURCES 0 o ° 0 TOTAL SERIES 1998A B&I, FLOOD 6,845 33,730 61,961 28,231 45.6 SERIES 1998C B&I, TIF 41 OTHER TAXES 1,081 54,858 150,000 95,142 63.4 46 INVESTMENT INCOME 273 777 1,000 223 22.3 TOTAL SERIES 1998C B&I, TIF 1,354 55,635 151,000 95,365 63.2 IEPA FLOOD CONTROL LOANS B&I 41 OTHER TAXES 8,605 42,670 492,744 450,074 91. 3 46 INVESTMENT INCOME 43 72 100 28 28.0 TOTAL IEPA FLOOD CONTROL LOANS B&I 8,648 42,742 492,844 450,102 91.3 SERIES 2000 B&I, FLOOD CONTROL 41 OTHER TAXES 11,959 59,305 323,579 264,274 81. 7 46 INVESTMENT INCOME 120 278 200 -78 -39.0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2000 B&I, FLOOD CONTROL 12,079 59,583 323,779 264,196 81.6 SERIES 2002B B&I, FLOOD 41 OTHER TAXES 43,851 217,452 88,508 -128,944 -145.7 46 INVESTMENT INCOME 437 940 1,000 60 6.0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2002B B&I, FLOOD 44,288 218,392 89,508 -128,884 -144. o SERIES 1994A B&I, STREET IMP. 41 OTHER TAXES 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 1994A B&I, STREET IMP. 0 0 ° 0 SERIES 1996A B&I, STREET IMP. 41 OTHER TAXES 0 0 0 0 46 INVESTMENT INCOME 0 0 0 0 TOTAL SERIES 1996A B&I, STREET IMP. 0 0 0 o SERIES 1998A B&I, STREET IMP. 41 OTHER TAXES 52,429 259,990 252,000 -7,990 -3.2 46 INVESTMENT INCOME 522 1,125 0 -1,125 49 OTHER FINANCING SOURCES 0 0 0 0 4 ,05/12/2005 4 Months ( 33.3%) Completed 18,53,56 MOUNT 8 Months ( 66.6%) Remaining FRRBRRO3 VILLAGE OF PROSPECT SUM 021 Budget Revenue by Category within Fund Sununary " " 01/01/05 - 04/30/05 Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent TOTAL SERIES 1998A B&I, STREET IMP. 52,951 261,115 252,000 -9,115 -3.6 SERIES 2002B B&I, STREET IMP. 41 OTHER TAXES 35,108 174,094 83,000 -91,094 -109.8 46 INVESTMENT INCOME 350 753 0 -753 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2002B B&I, STREET IMP. 35,458 174,847 83,000 -91,847 -110.7 CAPITAL IMPROVEMENT FUND 43 INTERGOVERMENT REV. 0 o 0 0 46 INVESTMENT INCOME 7,917 13,983 15,000 1,017 6.8 47 REIMBURSEMENTS 35,356 35,356 0 -35,356 48 OTHER REVENUE 0 7,250 25,000 17,750 71. 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL CAPITAL IMPROVEMENT FUND 43,273 56,589 40,000 -16,589 -41. 5 POLICE & FIRE BLDG CONST FUND 46 INVESTMENT INCOME 0 0 0 0 TOTAL POLICE & FIRE BLDG CONST FUND 0 0 0 0 SERIES 2001 PROJECT FUND 46 INVESTMENT INCOME 0 o 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2001 PROJECT FUND 0 0 0 0 SERIES 2003 PROJECT FUND 46 INVESTMENT INCOME 0 o 0 o 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL SERIES 2003 PROJECT FUND 0 0 0 0 2002 LIBRARY PROJECT FUND 46 INVESTMENT INCOME 0 0 ° 0 48 OTHER REVENUE 0 0 0 0 49 OTHER FINANCING SOURCES 0 0 0 0 TOTAL 2002 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 o DOWNTOWN REDEVLPMNT CONST 41 OTHER TAXES 5,363 272,089 743,975 471,886 63.4 46 INVESTMENT INCOME 1,534 2,010 2,000 -10 -0.5 5 05/12/2005 18,53,56 FRRBRRO3 SUM 021 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/05 04/30/05 47 48 49 REIMBURSEMENTS OTHER REVENUE OTHER FINANCING SOURCES Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent 0 0 0 0 0 0 0 0 0 1,053,150 1,340,000 286,850 21.4 6,897 1,327,249 2,085,975 758,726 36.4 TOTAL DOWNTOWN REDEVLPMNT CaNST STREET IMPROVEMENT CONST FUND 41 42 46 48 OTHER TAXES LICENSES, PERMITS INVESTMENT INCOME OTHER REVENUE & FEES -85,015 331,620 1,124,715 793,095 70.5 75,383 170,414 225,000 54,586 24.3 3,764 5,602 15,450 9,848 63.7 0 13,000 0 -13,000 -5,868 520,636 1,365,165 844,529 61. 9 TOTAL STREET IMPROVEMENT CONST FUND FLOOD CONTROL CONST 1998A TOTAL FLOOD CONTROL CONST 1998A 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 FLOOD CONTROL CONST FUND 41 43 46 OTHER TAXES INTERGOVERMENT REV. INVESTMENT INCOME REIMBURSEMENTS OTHER FINANCING SOURCES 0 0 0 0 0 0 0 0 4,834 8,462 12,000 3,538 29.5 0 0 0 0 0 0 0 0 4,834 8,462 12,000 3,538 29.5 47 49 TOTAL FLOOD CONTROL CONST FUND WATER AND SEWER FUND 41 OTHER TAXES 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 49 OTHER FINANCING SOURCES 97,328 759,474 1,531,825 772,351 50.4 498,417 1,921,982 6,892,392 4,970,410 72.1 15,534 '26,537 54,000 27,463 50.9 0 0 0 0 572 24,237 15,000 -9,237 -61. 6 0 0 0 0 611,851 2,732,230 8,493,217 5,760.987 67.8 TOTAL WATER AND SEWER FUND VILLAGE PARKING SYSTEM FUND 42 44 46 49 LICENSES, PERMITS & FEES CHARGES FOR SERVICE INVESTMENT INCOME OTHER FINANCING SOURCES 600 2,400 7,236 4,836 66.8 7,793 32,870 108,000 75,130 69.6 442 1,535 1,000 -535 -53.5 . 0 0 0 0 8,835 36,805 116,236 79,431 68.3 TOTAL VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND 42 43 44 46 LICENSES, PERMITS & FEES INTERGOVERMENT REV. CHARGES FOR SERVICE o 0 8,341 159 0 0 0 0 0 0 34,774 103,250 572 4,120 0 0 0 0 0 0 68,476 3,548 0 0 66.3 86.1 INVESTMENT INCOME OTHER REVENUE OTHER FINANCING SOURCES 48 49 6 005/12/2005 18:53:56 FRRBRRO3 SUM 021 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/05 04/30/05 Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent 8.500 35,346 107,370 72,024 6701 TOTAL PARKING SYSTEM REVENUE FUND VEHICLE MAINTENANCE FUND 44 46 48 CHARGES FOR SERVICE INVESTMENT INCOME OTHER REVENUE 130,245 390,733 1,302,445 911,712 70.0 1,717 2,784 7,500 4,716 62.9 0 0 0 0 131,962 393,517 1,309,945 916,428 70.0 TOTAL VEHICLE MAINTENANCE FUND VEHICLE REPLACEMENT FUND 44 46 48 49 CHARGES FOR SERVICE INVESTMENT INCOME OTHER REVENUE OTHER FINANCING SOURCES 88,303 264,912 883,035 618,123 70.0 14,859 40,346 115,000 74,654 64.9 0 0 0 0 0 30,000 60,000 30,000 50.0 103,162 335,258 1,058,035 722,777 6803 TOTAL VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND TOTAL COMPUTER REPLACEMENT FUND 44 46 CHARGES FOR SERVICE INVESTMENT INCOME 14,921 2,172 44,761 5,208 149,201 12,000 104,440 6,792 70.0 56.6 17,093 49,969 69.0 161,201 111,232 RISK MANAGEMENT FUND 43 INTERGOVERMENT REV. 44 CHARGES FOR SERVICE 46 INVESTMENT INCOME 47 REIMBURSEMENTS 48 OTHER REVENUE 0 0 0 0 521,317 1,530,225 4,865,731 3,335,506 68.6 4,327 8,490 20,000 11,510 57.6 7,083 38,578 50,000 11,422 22.8 19,415 207,496 744,200 536,704 72.1 552,142 1,784,789 5,679,931 3,895,142 6806 TOTAL RISK MANAGEMENT FUND POLICE PENSION FUND TOTAL POLICE PENSION FUND 46 48 -5,588 101,892 96 .6 58.1 68,010 705,331 INVESTMENT INCOME OTHER REVENUE 2,002,000 1,684,073 1,933,990 978,742 96,304 773,341 3,686,073 2,912,732 79.0 FIRE PENSION FUND TOTAL FIRE PENSION FUND 46 48 INVESTMENT INCOME OTHER REVENUE -7,170 101,434 101,731 733,803 2,111,500 1,629,410 2,009,769 895,607 95.2 55.0 94,264 835,534 3,740,910 2,905,376 77.7 BENEFIT TRUST #2 FUND TOTAL BENEFIT TRUST #2 FUND 46 INVESTMENT INCOME 0 0 0 0 0 0 0 0 ESCROW DEPOSIT FUND 46 0 INVESTMENT INCOME 0 0 0 7 05/12/2005 18,53,56 FRRBRRO3 SUM 021 Budget VILLAGE OF MOUNT PROSPECT Revenue by Category within Fund Summary 01/01/05 04/30/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining TOTAL ESCROW DEPOSIT FUND Cur Mo Y-T-D 2005 Unreceived Unreceived Received Received Budget Balance Percent 0 0 0 0 SSA #1 PROSPECT MEADOWS B&I 41 46 OTHER TAXES INVESTMENT INCOME 0 0 0 0 0 0 0 0 TOTAL SSA #1 PROSPECT MEADOWS B&I 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 41 OTHER TAXES 46 INVESTMENT INCOME 1,137 59 17,808 148 24,117 100 6,309 -48 26.2 -48.0 TOTAL SSA #6 GEORGE/ALBERT B&I 1,196 17,956 24,217 6,261 25.9 SERIES 2002 LIBRARY BND ESCROW 46 INVESTMENT INCOME 73 82 0 -82 TOTAL SERIES 2002 LIBRARY BND ESCROW 73 82 0 -82 GENERAL FIXED ASSETS ACCT GP 47 49 REIMBURSEMENTS OTHER FINANCING SOURCES 0 0 0 0 0 0 0 0 TOTAL GENERAL FIXED ASSETS ACCT GP 0 0 0 0 MOUNT PROSPECT LIBRARY FUND 49 OTHER FINANCING SOURCES 0 0 8,536,993 8,536,993 8,536,993 100.0 TOTAL MOUNT PROSPECT LIBRARY FUND 0 0 8,536,993 100.0 8 4 Months ( 8 Months ( VILLAGE OF MoUNT PROSPECT Budget Expenditure Summary 01/01/05 04/30/05 .05/12/2005 18,50,51 Cur Mo Expended Y-T-D Expended 2005 Budget 33.3% ) Completed 66.6% ) Remaining Unexpended Balance Unexpended Percent EXPENDITURE BY CLASSIFICATION PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS PENSION BENEFITS CONTRACTUAL SERVICES 1,559,287 628,752 28,099 383,090 1,207,308 11,616 526,319 79,586 33,481 6,355 35,806 12,863 165,335 38,745 13,600 525,591 121,258 47,371 900 34,583 o UTILITIES INSURANCE COMMODITIES & SUPPLIES OTHER EXPENDITURES LAND IMPROVEMENTS BUILDING IMPROVEMENTS OFFICE EQUIPMENT MOBILE EQUIPMENT OTHER EQUIPMENT DISTRIBUTION SYSTEMS INFRASTRUCTURE BOND PRINCIPAL INTEREST EXPENSE BANK AND FISCAL FEES INTERFUND TRANSFERS OTHER FINANCING USES Total All Funds 5,459,945 EXPENDITURE BY FUND GENERAL FUND REFUSE DISPOSAL FUND MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT COMMUNITY DEVELPMNT BLOCK GRNT ASSET SEIZURE FUND DEA SHARED FUNDS FUND DUI FINE FUND SERIES 1987A B&I, PW FACILITY SERIES 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, FLOOD 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 2,567,756 305,834 522,129 o 9,263 o o 15,556 o o 1 6,885,477 2,745,765 75,212 1,525,750 3,588,475 81,971 1,967,613 364,979 118,701 6,355 40,502 164,603 573,265 93,444 399,918 664,928 135,813 175,241 1,800 235,833 o 19,845,645 10,581,697 1,071,908 660,492 769 97,668 o o 300 o 300 300 o 15,556 o o 300 300 300 300 o o ° ° ° ° ° ° ° ° ° ° o 113,100 o o ° ° ° ° 22,283,173 7,809,507 339,313 4,746,868 13,566,726 539,816 6,401,091 1,139,534 468,577 o 332,000 321,085 1,275,335 541,500 1,125,000 3,433,038 3,344,867 1,315,860 6,000 805,000 o 69,794,290 33,927,415 3,634,727 1,871,750 o 724,623 7,000 1,000 1,000 67,000 o 390,128 911,932 610,051 36,650 o o ° ° 0 906,200 0 0 ° ° ° 0 0 o 213,100 62,983 153,295 ° 15,397,696 5,063,742 264,101 3,221,118 9,978,251 457,845 4,433,478 774,555 349,876 -6,355 291,498 156,482 702,070 448,056 725,082 2,768,110 3,209,054 1,140,619 4,200 569,167 0 49,948,645 23,345,718 2,562,819 1,211,258 -769 626,955 7,000 1,000 -14,556 67,000 0 389,828 911,632 609,751 36,350 o 0 0 0 o 793,100 o o 0 0 213,100 62,983 153,295 69.1 64.8 77.8 67.9 73.5 84.8 69.3 68.0 74.7 87.8 48.7 55.0 82.7 64.5 80.6 95.9 86.7 70.0 70.7 71.6 68.8 70.5 64.7 86.5 100.0 100.0 **** * 100.0 99.9 100.0 100.0 99.2 87.5 100.0 100.0 100.0 05/12/2005 18,50:51 VILLAGE OF MOUNT PROSPECT Budget Expenditure Summary 01/01/05 04/30/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining Cur Mo Y-T-D 2005 Unexpended Unexpended Expended Expended Budget Balance Percent IEPA FLOOD CONTROL LOANS B&I 168,629 188,274 613,355 425,081 69.3 SERIES 2000 B&I, FLOOD CONTROL 0 300 292,098 291,798 99.9 SERIES 2002B B&I, FLOOD 0 0 246,461 246,461 100.0 SERIES 1994A B&I, STREET IMP. 0 0 0 0 SERIES 1996A B&I, STREET IMP. 0 0 0 0 SERIES 1998A B&I, STREET IMP. 0 0 0 0 SERIES 2002B B&I, STREET IMP. 0 0 0 0 CAPITAL IMPROVEMENT FUND 8,432 48,834 575,000 526,166 ' 91.5 POLICE & FIRE BLDG CONST FUND 0 0 0 0 SERIES 2001 PROJECT FUND 0 0 0 0 SERIES 2003 PROJECT FUND 34,229 51,604 0 -51,604 2002 LIBRARY PROJECT FUND 0 0 0 0 CAPITAL IMPROVEMENT CONST FUND 0 0 0 0 DOWNTOWN REDEVLPMNT CONST 72,410 172,198 251,719 79,521 31. 6 STREET IMPROVEMENT CONST FUND -801 -34,315 1,004,000 1,038,315 103.4 FLOOD CONTROL CONST FUND 1,623 71,739 547,538 475,799 86.9 WATER AND SEWER FUND 628,377 2,395,417 9,204,528 6,809,111 74.0 VILLAGE PARKING SYSTEM FUND 9,651 45,661 240,367 194,706 81.0 PARKING SYSTEM REVENUE FUND 16,897 41,695 136,614 94,919 69.5 VEHICLE MAINTENANCE FUND 102,649 398,010 1,275,883 877,873 68.8 VEHICLE REPLACEMENT FUND 165,335 573,265 1,275,335 702~070 55.0 COMPUTER REPLACEMENT FUND 2,548 104,256 199,700 95,'444 47.8 RISK MANAGEMENT FUND 449,245 1,736,993 5,679,650 3,942,657 69.4 POLICE PENSION FUND 189,299 758,470 2,366,440 1,607,970 67.9 FIRE PENSION FUND 189,984 750,854 2,328,948 1,578,094 67.8 BENEFIT TRUST #2 FUND 0 0 0 0 SSA #1 PROSPECT MEADOWS B&I 0 0 0 0 SSA #6 GEORGE/ALBERT B&I 0 0 37,800 37,800 100.0 GENERAL FIXED ASSETS ACCT GP 0 0 0 0 GENERAL LONG-TERM DEBT ACCT GP 0 0 0 0 Total All Funds 5,459,945 19,845,645 69,794,290 49,948,645 71.6 2 .°5/12/2005 18:54:54 FRRDBROl SUM 031 """""" . - VILLAGE OF MOUNT PROSPECT Department Budget Expehditure Summary 01/01/05 - 04/30/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining NON-DEPARTMENTAL Cur Mo Expended Y-T-D Expended 2005 Budget Unexpended Unexpended Balance Percent PROGRAM TOTALS 00 ADMINISTRATION 0 0 0 0 Totals 0 0 0 0 EXPENDITURE CLASSIFICATION 72 80 INTEREST EXPENSE INTERFUND TRANSFERS 0 0 0 0 0 0 0 0 Totals 0 0 0 0 SOURCE OF FUNDS 270 SERIES 1996B B&I, TIF 280 SERIES 1998B B&I, TIF 930 GENERAL LONG-TERM DEBT ACCT GP 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Totals 1 05/12/2005 18:54:54 FRRDBROl SUM 031 4 Months ( 8 Months ( 33.3% ) Completed 66.6% } Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 04/30/05 MAYOR AND BOARD OF TRUSTEES ADVISORY BOARDS & COMMISSIONS Cur Mo Y-T-D 2005 Unexpended Unexpended Expended Expended Budget Balance Percent 3,104 25,257 101,845 76,588 75.2 1,453 5,384 15,538 10,154 65.3 4,557 30,641 117,383 86,742 73.9 PUBLIC REPRESENTATION PROGRAM TOTALS 02 03 Totals EXPENDITURE CLASSIFICATION 50 51 52 54 55 57 65 SOURCE OF FUNDS PERSONAL SERVICES EMPLOYEE BENEFITS OTHER EMPLOYEE COSTS CONTRACTUAL SERVICES UTILITIES COMMODITIES & SUPPLIES OFFICE EQUIPMENT 2,830 11,471 34,690 23,219 66.9 509 1,892 5,891 3,999 67.9 0 0 2,000 2,000 100.0 1,203 17,142 68,702 51,560 75.0 15 -17 500 517 103.4 0 153 5,600 5,447 97.3 0 0 ° 0 4,557 30,641 117,383 86,742 73.9 Totals 001 GENERAL FUND 4,557 30,641 117,383 73.9 86,742 Totals 4,557 30,641 117,383 86,742 73.9 2 05/12/2005 18:54:54 FRRDBROl SUM 031 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining VILLAGE OF MOUNT.PROSPECT Department BudgetE:xperiditure Sununary 01/01/05 - 04/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended VILLAGE MANAGER'S OFFICE Expended Expended Budget Balance Percent PROGRAM TOTALS 01 VILLAGE MANAGER'S OFFICE 30,296 144,134 425,909 281,775 66.2 02 LEGAL SERVICES 31,437 52,189 350,000 297,811 85.1 03 PERSONNEL SERVICES 18,049 73,955 274,710 200,755 73.1 04 INFORMATION TECHNOLOGY 56,326 179,142 764,071 584,929 76.6 05 PUBLIC INFORMATION 12,097 39,316 133,062 93,746 70.5 Totals 148,205 488,736 1,947,752 1,459,016 74.9 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 45,330 227,281 768,341 541,060 70.4 18,429 69,989 231,423 161,434 69.8 1,646 4,154 35,800 31,646 88.4 77,555 178,760 876,908 698,148 79.6 321 804 7,530 6,726 89.3 438 2,103 10,850 8,747 80.6 4,486 5,645 16,900 11,255 66.6 0 0 0 0 148,205 488,736 1,947,752 1,459,016 74.9 SOURCE OF FUNDS 001 GENERAL FUND 148,205 488,736 1,947,752 1,459,016 74.9 Totals 148,205 488,736 1,947,752 1,459,016 74.9 3 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 04/30/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining 05/12/2005 18,54,54 Totals Cur Mo Y-T-D 2005 Unexpended Unexpended Expended Expended Budget Balance Percent 8,476 34,307 167,850 133,543 79.6 0 0 0 0 2,898 11,531 45,907 34,376 74.9 11,374 45,838 213,757 167,919 78.6 TV SERVICES DIVISION PROGRAM. TOTALS 02 03 04 CABLE TV OPERATIONS OTHER SERVICES INTERGOVERNMENTAL PROGRAMMING EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 67 OTHER EQUIPMENT Totals 6,942 29,030 95,469 66,439 69.6 3,285 11,137 36,767 25,630 69.7 0 555 2,450 1,895 77.3 336 1,534 11,471 9,937 86.6 102 216 2,000 1,784 89.2 679 1,574 7,850 6,276 79.9 30 1,792 57,750 55,958 96.9 11,374 45,838 213,757 167,919 78.6 SOURCE OF FUNDS 001 GENERAL FUND 11,374 45,838 213,757 167,919 78.6 Totals 11,374 45,838 213,757 167,919 78.6 4 " ""1 .°5/12/2005 18,54:54 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget:E:xpenditure Summary 01/01/05 - 04/30/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining Totals Cur Mo Y-T-D 2005 Unexpended Unexpended Expended Expended Budget Balance Percent 12,512 54,960 171,874 116,914 68.0 12,512 54,960 171,874 116,914 68.0 VILLAGE CLERK'S OFFICE PROGRAM TOTALS 02 VILLAGE CLERK'S OFFICE EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES Totals 7,146 30,952 93,550 62,598 66.9 3,359 11,602 37,464 25,862 69.0 7 302 1,700 1,398 82.2 1,207 10,423 33,160 22,737 68.6 51 110 1,600 1,490 93.1 742 1,571 4,400 2,829 64.3 12,512 54,960 171,874 116,914 68.0 SOURCE OF FUNDS 001 GENERAL FUND 12,512 54,960 171,874 116,914 68.0 Totals 12,512 54,960 171,874 116,914 68.0 5 05/12/2005 4 Months ( 33.3%) Completed 18:54:54 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6%) Remaining FRRDBROI SUM 031 Department Budget Expenditure Summary 01/01/05 - 04/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended FINANCE DEPARTMENT Expended Expended. Budget Balance Percent PROGRAM TOTALS 01 FINANCE ADMINISTRATION 14,909 79,878 214,409 134,531 62.7 02 ACCOUNTING 33,026 111,796 408,087 296,291 72.6 03 DATA PROCESSING o 210 o -210 04 DUPLICATING SERVICES o 963 o -963 OS INSURANCE PROGRAMS 51,828 160,708 530,277 369,569 69.7 06 CUSTOMER SERVICES 27,773 123,814 371,829 248,015 66.7 07 CASH MANAGEMENT 2,547 10,031 45,753 35,722 78.1 Totals 130,083 487,400 1,570,355 1,082,955 69.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 56,005 234,861 730,343 495,482 67.8 51 EMPLOYEE BENEFITS 23,396 79,346 262,358 183,012 69.8 52 OTHER EMPLOYEE COSTS 230 1,669 7,850 6,181 78.7 54 CONTRACTUAL SERVICES 2,851 27,236 70,450 43,214 61.3 55 UTILITIES 193 417 6,200 5,783 93.3 56 INSURANCE 46,647 139,943 466,474 326,531 70.0 57 COMMODITIES & SUPPLIES 761 3,978 24,680 20,702 83.9 65 OFFICE EQUIPMENT 0 -50 2,000 2,050 102.5 Totals 130,083 487,400 1,570,355 1,082,955 69.0 SOURCE OF FUNDS 001 GENERAL FUND 130,083 487,400 1,570,355 1,082,955 69.0 Totals 130,083 487,400 1,570,355 1,082,955 69.0 6 05/12/2005 18:54:55 FRRDBROl SUM 031 VILLAGE O~ MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 04/30/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining Cur Mo Y-T-D 2005 Unexpended Unexpended COMMUNITY DEVELOPMENT Expended Expended Budget Balance Percent PROGRAM TOTALS 01 COMMUNITY DEVELOPMENT ADMIN 15,429 63,758 200,832 137,074 68.3 02 PLANNING & ZONING 14,229 55,773 221,429 165,656 74.8 03 ECONOMIC DEVELOPMENT 6,241 20,595 77,915 57,320 73.6 05 BUILDING INSPECTIONS 60,815 224,412 743,450 519,038 69.8 06 HOUSING INSPECTIONS 23,669 92,727 309,779 217,052 70.1 07 HEALTH INSPECTIONS 9,168 36,378 116,969 80,591 68.9 Totals 129,551 493,643 1,670,374 1.,1.76,731. 70.4 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 52 OTHER EMPLOYEE COSTS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 65 OFFICE EQUIPMENT Totals 79,325 329,226 1,088,973 759,747 69.8 36,017 122,852 408,210 285,358 69.9 1,757 5,789 15,523 9,734 62.7 10,843 29,208 119,888 90,680 75.6 802 2,126 25,776 23,650 91. 8 807 4,442 12,004 7,562 63.0 o o ° 0 1.29,551 493,643 1,670,374 1,176,731 70.4 SOURCE OF FUNDS 001 GENERAL FUND 550 DOWNTOWN REDEVLPMNT CONST Totals 129,551 o 493,643 0 1,669,876 498 1,176,233 498 70.4 100.0 129,551 493,643 1,670,374 1,176,731 70.4 7 05/12/2005 4 Months ( 33.3%) Completed 18:54:55 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/05 04/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended COMMUNITY DEVELOPMENT - CDBG Expended Expended Budget Balance Percent PROGRAM TOTALS 04 CDBG ADMINISTRATION 5,446 14,232 71,623 57,391 80.1 as CDBG COMMUNITY PROGRAMS 2,971 16,677 105,500 88,823 84.2 06 ACCESSIBLTY & NEIGHBRHD IMPRV a 64,502 249,500 184,998 74.1 07 CDBG RESIDENTIAL REHAB 846 2,257 298,000 295,743 99.2 Totals 9,263 97,668 724,623 626,955 86.5 EXPENDITURE CLASSIFICATIO~ 50 PERSONAL SERVICES 3,462 8,444 48,263 39,819 82.5 51 EMPLOYEE BENEFITS 1,665 4,688 18,475 13,787 74.6 52 OTHER EMPLOYEE COSTS 0 50 1,075 1,025 95.3 54 CONTRACTUAL SERVICES 3,222 17,161 122,915 105,754 86.0 57 COMMODITIES & SUPPLIES 68 566 1,395 829 59.4 59 OTHER EXPENDITURES 846 2,257 283,000 280,743 99.2 64 BUILDING IMPROVEMENTS a a 37,000 37,000 100.0 69 INFRASTRUCTURE a 64,502 212,500 147,998 69.6 Totals 9,263 97,668 724,623 626,955 86.5 SOURCE OF FUNDS 070 COMMUNITY DEVELPMNT BLOCK GRNT 9,263 97,668 724,623 626,955 86.5 Totals 9,263 97,668 724,623 626,955 86_5 8 05/12/2005 18:54:55 FRRDBROl SUM 031 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining VILLAGE OF MÒ~ PROSPECT Department Budget Expenditure Summary 01/01/05 - 04/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended HUMAN SERVICES Expended Expended Budget Balance Percent PROGRAM TOTALS 01 HUMAN SERVICES ADMINISTRATION 12,779 48,416 171,969 123,553 71. 8 02 SOCIAL SERVICES 24,096 96,490 316,070 219,580 69.5 03 NURSING/HEALTH SERVICES 12,770 46,963 185,598 138,635 74.7 04 SENIOR CTR. LEISURE ACTIVITIES 2,446 10,332 46,896 36,564 78.0 05 YOUTH ACTIVITIES 635 2,858 0 -2,858 Totals 52,726 205,059 720,533 515,474 71.5 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 33,493 140,197 453,200 313,003 69.1 12,992 45,253 150,028 104,775 69.8 20 527 4,200 3,673 87.5 5,189 15,375 59,740 44,365 74.3 342 949 11,500 10,551 91. 7 690 2,549 40,365 37,816 93.7 0 209 1,500 1,291 86.1 0 0 0 0 52,726 205,059 .720,533 515,474 71.5 SOURCE OF FUNDS 001 GENERAL FUND 52,726 205,059 205,059 720,533 515,474 71.5 Totals 52,726 720,533 515,474 71.5 9 05/12/2005 4 Months ( 33.3%) Completed 18,54,55 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6% ) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/05 04/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended POLICE Expended Expended Budget Balance Percent PROGRAM TOTALS 01 POLICE ADMINISTRATION 161,043 927,272 2,529,382 1,602,110 63.3 02 PATROL & TRAFFIC ENFORCEMENT 593,201 2.252,222 6,993,502 4,741,280 67.8 03 CRIME PREVTN & PUBLIC SERVICES 15,879 67,257 234,701 167,444 71.3 04 INVESTIGATIVE & JUVENILE PRGM 86,024 354,758 1,219,752 864,994 70.9 05 CROSSING GUARDS 2,392 8,286 27,575 19,289 70.0 06 EQUIPMENT MAINTENANCE 59,688 194,514 659,571 465,057 70_5 Totals 918,227 3,804,309 11,664,483 7,860,174 67.4 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 520,377 2,289,409 7,573,190 5,283,781 69.8 51 EMPLOYEE BENEFITS 204,251 967,599 2,593,654 1,626,055 62.7 52 OTHER EMPLOYEE COSTS 12,803 29,781 90,500 60,719 67.1 54 CONTRACTUAL SERVICES 154,004 467,003 1,242,191 775,188 62.4 55 UTILITIES 2,308 5,871 46,400 40,529 87.3 57 COMMODITIES & SUPPLIES 8,663 23,829 86,148 62,319 72.3 59 OTHER EXPENDITURES 0 0 0 0 65 OFFICE EQUIPMENT 265 1,119 1,150 31 2.7 67 OTHER EQUIPMENT 15,556 19,698 31,250 11,552 37.0 Totals 918,227 3,804,309 11,664,483 7,860,174 67.4 SOURCE OF FUNDS 001 GENERAL FUND 902,671 3,787,984 11,655,483 7,867,499 67.5 060 LAW ENFORCEMENT BLOCK GRANT 0 769 0 -769 080 ASSET SEIZURE FUND 0 0 7,000 7,000 100.0 085 DEA SHARED FUNDS FUND 0 0 1,000 1,000 100.0 086 DUI FINE FUND 15,556 15,556 1,000 -14,556 **** * Totals 918,227 3,804,309 11,664,483 7,860,174 67.4 10 .05/12/2005 4 Months ( 33.3%) Completed 18:54:55 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Sununary 01/01/05 04/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended FIRE Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FIRE ADMINISTRATION 132,562 843,229 2,107,956 1,264,727 60.0 02 FIRE DEPARTMENT OPERATIONS 481,302 1,972,278 6,209,675 4,237,397 68.2 03 FIRE TRAINING ACADEMY o -222 13,131 13,353 101.7 04 FIRE PREVENTION 35,991 133,339 493,331 359,992 73.0 05 FIRE COMMUNICATIONS 4,665 17,636 62,100 44,464 71.6 06 EQUIPMENT MAINTENANCE 36,971 133,485 443,968 310,483 69.9 07 EMERGENCY PREPARDENESS PRGM 657 1,549 10,180 8,631 84.8 08 PAID-ON-CALL PROGRAM 1,696 5,661 31,680 26,019 82.1 Totals 693,844 3,106,955 9,372,021 6,265,066 66.8 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 446,729 1,978,861 6,270,719 4,291,858 68.4 51 EMPLOYEE BENEFITS 180,803 916,358 2,380,065 1,463,707 61. 5 52 OTHER EMPLOYEE COSTS 5,640 13,235 102,865 89,630 87.1 54 CONTRACTUAL SERVICES 46,092 145,720 417,872 272,152 65.1 55 UTILITIES 2,091 10,643 42,500 31,857 75.0 57 COMMODITIES & SUPPLIES 5,106 25,731 89,150 63,419 71.1 64 BUILDING IMPROVEMENTS 2,027 4,061 4,000 -61 -1. 5 65 OFFICE EQUIPMENT 1,111 1,111 4,000 2,889 72.2 67 OTHER EQUIPMENT 4,245 11,235 60,850 49,615 81.5 Totals 693,844 3,106,955 9,372,021 6,265,066 66.8 SOURCE OF FUNDS 001 GENERAL FUND 693,844 3,106,955 9,372,021 6,265,066 66.8 Totals 693,844 3,106,955 9,372,021 6,265,066 66.8 11 05/12/2005 4 Months ( 33.3%) Completed 18:54:55 VILLAGE OF MOUNT PROSPECT 8 Months ( 66 - 6% ) Remaining FRRDBROI SUM 031 Department Budget Expenditure Swnmary 01/01/05 04/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended PUBLIC WORKS - ADMINISTRATION Expended Expended Budget Balance Percent PROGRAM TOTALS 01 PUBLIC WORKS ADMINSTRATION 99,779 336,553 1,104,481 767,928 69.5 Totals 99,779 336,553 '1,104,481 767,928 69.5 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 16,655 78,642 230,282 151,640 65.8 51 EMPLOYEE BENEFITS 11,048 37,799 119,906 82,107 68.5 52 OTHER EMPLOYEE COSTS 3, III 6,928 29,545 22,617 76.6 54 CONTRACTUAL SERVICES 67,455 204,859 685,268 480,409 70.1 55 UTILITIES 1,080 3,935 18,490 14,555 78.7 57 COMMODITIES & SUPPLIES 430 4,265 13,915 9,650 69.3 65 OFFICE EQUIPMENT 0 0 6,500 6,500 100.0 67 OTHER EQUIPMENT 0 125 575 450 78.3 Totals 99,779 336,553 1,104,481 767,928 69.5 SOURCE OF FUNDS 001 GENERAL FUND 99,779 336,553 1,104,481 767,928 69.5 Totals 99,779 336,553 1,104,481 767,928 69.5 12 .05/12/2005 18,54,55 FRRDBROl SUM 031 4 Months { 8 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 04/30/05 PUBLIC WORKS - STREETS/BLDGS Cur Mo Expended PROGRAM TOTALS 01 02 04 05 06 07 08 09 10 11 12 STREET DIVISION ADMINISTRATION MAINTENANCE - PUBLIC BUILDINGS STREET MAINTENANCE SNOW REMOVAL LEAF REMOVAL STORM SEWER & BASIN MAINT MAINTENANCE OF STATE HIGHWAYS TRAFFIC SIGN MAINTENANCE VILLAGE PARKING LOT MAINT PARKING LOT MAINTENANCE FLOOD CONTROL 8,778 75,163 24,708 34,568 637 11,281 2,071 11,635 9,651 16,897 0 Totals 195,389 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 56 INSURANCE 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES 64 BUILDING IMPROVEMENTS 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 80 INTERFUND TRANSFERS 81,960 28,256 62,793 773 1,981 19,063 0 0 0 563 Totals 195,389 SOURCE OF FUNDS 001 050 620 GENERAL FUND MOTOR FUEL TAX FUND VILLAGE PARKING SYSTEM FUND PARKING SYSTEM REVENUE FUND 168,841 0 9,651 16,897 630 Totals 195,389 13 Y-T-D Expended 45,951 249,077 75,491 315,927 2,806 42,767 24,216 31,200 45,661 41,695 0 874,791 0 442,802 115,140 146,441 2,772 5,943 145,722 0 68 0 15,903 0 874,791 705,294 82,141 45,661 41,695 874,791 2005 Budget 33.3% ) Completed 66.6% ) Remaining Unexpended Unexpended Balance Percent 158,323 782,108 445,142 398,744 0 168,614 66,161 111,105 240,367 136,614 0 2,507,178 1,050,768 319,648 588,478 19,205 19,808 263,171 0 6,000 10,100 230,000 o 2.507,178 1,919,827 210,370 240,367 136,614 2,507.178 112,372 533,031 369,651 82,817 -2,806 125,847 41,945 79,905 194,706 94.919 0 1,632.387 607,966 204.508 442,037 16,433 13,865 117.449 0 5,932 10,100 214,097 0 1,632,387 1,214,533 128,229 194,706 94,919 1,632.387 71.0 68.2 83.0 20.8 74.6 63.4 71.9 81. o 69.5 65.1 57_9 64.0 75.1 85.6 70.0 44.6 98.9 100.0 93.1 65.1 63-3 61.0 81. o 69.5 65.1 U~/.LLI¿UU~ 4 Months ( 33.3%) Completed 18:54:55 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6%) Remaining FRRDBROI SUM031 Department Budget Expenditure Summary 01/01/05 04/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended PUBLIC WORKS - FORESTRY/GRNDS Expended Expended Budget Balance Percent PROGRAM TOTALS 01 FORESTRY DIVISION ADMIN 15,131 60,676 202,791 142,115 70.1 02 MAINTENANCE OF GROUND 37,942 97,170 430,352 333,182 77.4 03 FORESTRY PROGRAM 48,437 122,156 751,126 628,970 83.7 04 PUBLIC GROUNDS BEAUTIFICATION 2,287 9,485 44,449 34,964 78.7 Totals 103,797 289,487 1,428,718 1,139,231 79.7 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 46,029 184,598 659,194 474,596 72.0 51 EMPLOYEE BENEFITS 17,627 59,740 205,772 146,032 71.0 52 OTHER EMPLOYEE COSTS 0 543 3,350 2,807 83.8 54 CONTRACTUAL SERVICES 32,020 32,971 527,162 494,191 93.7 57 COMMODITIES & SUPPLIES 1,580 5,094 24,440 19,346 79.2 67 OTHER EQUIPMENT 6,541 6,541 8,800 2,259 25.7 Totals 103,797 289,487 1,428,718 J.,J.39,231 79.7 SOURCE OF FUNDS 001 GENERAL FUND 103,797 289,487 1,418,418 1,128,931 79.6 690 RISK MANAGEMENT FUND 0 0 10,300 10,300 100.0 Totals 103,797 289,487 J.,428,718 1,139,231 79.7 14. _O5/12/2005 18:54:55 FRRDBROl SUM031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 04/30/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining Cur Mo Y-T-D 2005 Unexpended Unexpended PUBLIC WORKS - ENGINEERING Expended Expended Budget Balance Percent PROGRAM TOTALS 01 ENGINEERING SERVICES 50,449 204,510 702,066 497,556 70.9 05 TRAFFIC CNTRL & STREET LGHTNG 9,650 57,890 406,391 348,501 85.8 Totals 60,099 262,400 1,108,457 846,057 76.3 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 38,523 170,019 560,670 390,651 69.7 14,739 53,173 175,489 122,316 69.7 0 155 5,100 4,945 97.0 4,166 12,681 135,548 122,867 90.6 0 21,857 196,380 174,523 88.9 2,671 4,515 17,270 12,755 73.9 0 0 500 500 100.0 0 0 1,500 1,500 100.0 0 0 16,000 16,000 100.0 60,099 262,400 1,108,457 846,057 76.3 SOURCE OF FUNDS 001 050 GENERAL FUND MOTOR FUEL TAX FUND 60,099 0 239,623 22,777 916,577 191,880 676,954 169,103 73.9 88.1 Totals 60,099 262,400 1,108,457 846,057 76.3 15 O~/1414UO~ 4 Months ( 33.3%) Completed 18:54:55 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6%) Remaining FRRDBROI SUM 031 Department Budget Expenditure Summary 01/01/05 - 04/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended PUBLIC WORKS - WATER/SEWER Expended Expended Budget Balance Percent PROGRAM TOTALS 01 WATER & SEWER DIVISION ADMIN 125,357 443,234 1,663,809 1,220,575 73.4 02 MAINTENANCE OF BUILDINGS 12,412 44,950 168,464 123,514 73.3 03 MAINTENANCE OF GROUNDS 3,865 18,026 84,534 66,508 78.7 04 WATER SUPPLY MAINT & REPAIR 33,653 139,225 522,659 383,434 73.4 05 WATER DISTRBT MAINT & REPAIR 38,438 141,397 710,969 569,572 80.1 06 WATER VALVE!HYDRNT MAINT & REP 19,147 71,317 302,796 231,479 76.4 07 WATER METER MAINT & REPL 22,907 96,678 313,319 216,641 69.1 08 EQUIPMENT MAINTENANCE 61,159 183,477 611,589 428,112 70.0 09 SANITARY SEWER MAINT & REPAIR 28,538 85,157 496,389 411,232 82.8 10 WATER & SEWER SYSTEM IMPROV 34,728 428,758 1,255,000 826,242 65.8 12 LAKE MICHIGAN WATER SUPPLY 248,173 743,198 3,075,000 2,331,802 75.8 Totals 628,377 2,395,417 9,204,528 6,809,111 74.0 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 115,688 482,520 1,686,400 1,203,880 71.4 51 EMPLOYEE BENEFITS 49,035 168,503 574,345 405,842 70.7 52 OTHER EMPLOYEE COSTS 2,885 11,524 32,370 20,846 64.4 54 CONTRACTUAL SERVICES 397,190 1,145,987 4,809,354 3,663,367 76.2 55 UTILITIES 3,467 31,901 159,775 127,874 80.0 56 INSURANCE 27,681 83,042 276,808 193,766 70.0 57 COMMODITIES & SUPPLIES 4,715 23,549 168,186 144,637 86.0 59 OTHER EXPENDITURES 0 0 13,500 13,500 100.0 65 OFFICE EQUIPMENT 4,003 4,163 13,335 9,172 68.8 67 OTHER EQUIPMENT 10,113 44,310 241,425 197,115 81. 6 68 DISTRIBUTION SYSTEMS 13,600 399,918 1,125,000 725,082 64.5 71 BOND PRINCIPAL 0 0 104,030 104,030 100.0 Totals 628,377 2,395,417 9,204,528 6,809,111 74.0 SOURCE OF FUNDS 610 WATER AND SEWER FUND 628,377 2,395,417 9,204,528 6,809,111 74 - 0 Totals 628,377 2,395,417 9,204,528 6,809,111 74.0 16 ,05/12/2005 4 Months ( 33.3%) Completed 18,54,55 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/05 - 04/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended PUBLIC WORKS - REFUSE DISPOSAL Expended Expended Budget Balance Percent PROGRAM TOTALS 01 REFUSE DISPOSAL PROGRAM 297,135 1,037,722 3,446,873 2,409,151 69.9 02 REFUSE LEAF REMOVAL PROGRAM 8,699 34,186 187,854 153,668 81. 8 Totals 305,834 1.071.908 3,634,727 2.562,819 70.'5 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 12,093 49,237 216,953 167,716 77.3 51 EMPLOYEE BENEFITS 5,029 17,018 66,276 49,258 74.3 52 OTHER EMPLOYEE COSTS o 0 1,685 1,685 100.0 54 CONTRACTUAL SERVICES 287,927 1,000,581 3,320,897 2,320,316 69.9 55 UTILITIES 20 102 560 458 81. 8 56 INSURANCE 765 2,295 7,651 5,356 70.0 57 COMMODITIES & SUPPLIES a 2,675 20,705 18,030 87.1 Totals 305.834 1.071,908 3,634.727 2,562,819 70.5 SOURCE OF FUNDS 030 REFUSE DISPOSAL FUND 305,834 1,071,908 3,634,727 2.562,819 70.5 Totals 305,834 1.071.908 3,634,727 2,562.819 70.5 17 05/12/2005 4 Months ( 33.3%) Completed 18:54:55 VILLAGE OF MOUNT PROSPECT 8 Months ( 66.6%) Remaining FRRDBROl SUM 031 Department Budget Expenditure Summary 01/01/05 04/30/05 Cur Mo Y-T-D 2005 Unexpended Unexpended PUBLIC WORKS - VEHICLE MAINT Expended Expended Budget Balance P",rcent PROGRAM TOTALS 01 VEHICLE DIVISION ADMINSTRATION 11,629 54,114 184,150 130,036 70.6 02 VEHICLE MAINTENANCE PROGRAM 91,020 343,896 1,091,733 747,837 68.5 Totals 102.649 398,010 1,275,883 877,873 68.8 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 46,113 195,663 658,948 463,285 70.3 51 EMPLOYEE BENEFITS 18,118 63,027 212,513 149,486 70.3 52 OTHER EMPLOYEE COSTS 0 0 3,300 3,300 100.0 54 CONTRACTUAL SERVICES 5,762 28,214 72,502 44,288 61.1 55 UTILITIES 51 285 1,000 715 71. 5 57 COMMODITIES & SUPPLIES 30,345 108,561 323,870 215,309 66.5 59 OTHER EXPENDITURES 0 0 0 0 65 OFFICE EQUIPMENT 0 0 500 500 100.0 67 OTHER EQUIPMENT 2,260 2,260 3,250 990 30.5 Totals 102,649 398,010 1,275,883 877,873 68.8 SOURCE OF FUNDS 660 VEHICLE MAINTENANCE FUND 102,649 398,010 1,275,883 877,873 68.8 Totals 102,649 398,010 1,275,883 877,873 68.8 18 .05/12/2005 18,54,55 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 04/30/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining Cur Mo Y-T-D 2005 Unexpended Unexpended COMMUNITY SERVICE PROGRAMS Expended Expended Budget Balance Percent PROGRAM TOTALS 02 COMMUNITY GROUPS & MISC 6,520 45,664 91,400 45,736 50.0 03 4TH OF JULY & CIVIC EVENTS,ETC 2,711 2,757 103,431 100,674 97.3 04 HOLIDAY DECORATIONS 1,132 6,197 71,825 65,628 91.4 05 BLOOD DONOR PROGRAM 214 843 2,792 1,949 69.8 Totals 10,577 55,461 269,448 213,987 79.4 EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 51 EMPLOYEE BENEFITS 54 CONTRACTUAL SERVICES 55 UTILITIES 57 COMMODITIES & SUPPLIES 59 OTHER EXPENDITURES Totals 587 2,264 63,220 60,956 96.4 194 649 11,223 10,574 94.2 6,968 49,158 161,770 112,612 69.6 0 0 400 400 100.0 2,828 3,390 25,335 21,945 86.6 0 0 7,500 7,500 100.0 10,577 55,461 269,448 213,987 79.4 SOURCE OF FUNDS 001 GENERAL FUND 10,577 55,461 269,448 213,987 79.4 Totals 10,577 55,461 269,448 213,987 79.4 19 05/12/2005 18:54:55 FRRDBROl SUM 031 4 Months ( 8 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 04/30/05 CAPITAL IMPROVEMENT PROJECTS Cur Mo Expended PROGRAM TOTALS 01 02 34,229 8,432 72,410 1,623 521,328 165,335 2,548 VILLAGE IMPROVEMENTS & EQUIP COMMUNITY IMPROVEMENT PROJECTS DOWNTOWN REDEVELOPMENT CONST FLOOD CONTROL PROJECTS STREET IMPROVEMENT PROJECTS MOTOR EQUIPMENT REPLACEMENT COMPUTER REPLACEMENT 03 04 06 09 10 Totals 805,905 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 55 UTILITIES 59 OTHER EXPENDITURES 62 LAND IMPROVEMENTS 64 BUILDING IMPROVEMENTS 65 OFFICE EQUIPMENT 66 MOBILE EQUIPMENT 67 OTHER EQUIPMENT 69 INFRASTRUCTURE 72 INTEREST EXPENSE 80 INTERFUND TRANSFERS 39,775 0 32,635 6,355 33,779 2,998 165,335 0 525,028 0 0 Totals 805,905 SOURCE OF FUNDS 050 060 510 520 525 526 527 530 550 560 MOTOR FUEL TAX FUND LAW ENFORCEMENT BLOCK GRANT 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 PARKING SYSTEM REVENUE FUND VEHICLE REPLACEMENT FUND COMPUTER REPLACEMENT FUND RISK MANAGEMENT FUND 522,129 0 8,432 0 0 34,229 0 0 72,410 -801 1,623 0 165,335 2,548 0 590 630 670 680 690 Totals 805,905 20 Y-T-D Expended 92,006 8,432 172,198 71,739 521,259 573,265 104,256 1,543.155 56,326 0 116,444 6,355 36,373 152,406 573,265 7,483 584,523 9,980 0 '1,543.155 555,574 0 48,834 0 0 51,604 0 0 172,198 -34,315 71,739 0 573,265 104,256 0 1.543,155 2005 Budget 486,000 35,000 251,221 547,538 2,527,500 1,275,335 199,700 5.322,294 200,500 0 164,577 0 285,000 274,700 1,275,335 126,000 2,974,538 21,644 0 5,322,294 1,469,500 0 575,000 0 0 0 0 0 251,221 1,004,000 547,538 0 1,275,335 199,700 0 5,322.294 33.3% ) Completed 66.6% ) Remaining Unexpended Unexpended Balance Percent 393,994 26,568 79,023 475,799 2,006,241 702,070 95,444 3,779,139 144,174 0 48,133 -6,355 248,627 122,294 702,070 118,517 2,390,015 11,664 0 3.779.139 913,926 0 526,166 0 0 -51,604 0 0 79,023 1,038,315 475,799 0 702,070 95,444 0 3.779,139 81.1 75.9 31. 5 86.9 79.4 55.0 47.8 71.0 71.9 29.2 87.2 44.5 55.0 94.1 80.3 53.9 71.0 62.2 91. 5 31. 5 103.4 86.9 55.0 47.8 71.0 05/12/2005 4 Months ( 33.3%) Completed . 1B:54:55 8 Months ( 66.6% ì Remaining FRRDBROl VILLAGE OF MOUNT PROSPECT SUM 031 Department Budget Expenditure Summary 01/01/05 - 04/30/05 Cur Me Y-T-D 2005 Unexpended Unexpended DEBT SERVICE Expended Expended Budget Balance Percent PROGRAM TOTALS 02 DEBT SERVICE - PROPERTY TAXES 600 900 1,979,111 1,978,211 100.0 03 DEBT SERVICE - TAX INCREMENT 300 113,400 1,096,145 982,745 89.7 04 DEBT SERVICE - H/R SALES TAX 1 168,629 188,574 1,427,997 1,239,423 86.8 05 DEBT SERVICE - H/R SALES TAX 2 0 0 0 0 06 SPECIAL SERVICE AREA B & I 0 0 37,800 37,800 100.0 Totals 169,529 302,874 4,541,053 4,238,179 93.3 EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 0 0 0 0 59 OTHER EXPENDITURES 0 0 0 0 71 BOND PRINCIPAL 121,258 135,813 3,240,837 3,105,024 95.8 72 INTEREST EXPENSE 47,371 165,261 1,294,216 1,128,955 87.2 73 BANK AND FISCAL FEES 900 1,800 6,000 4,200 70.0 80 INTERFUND TRANSFERS 0 0 0 0 81 OTHER FINANCING USES 0 0 0 0 Totals 169,529 302,874 4,541,053 4,238,179 93.3 SOURCE OF FUNDS 140 SERIES 1987A B&I, PW FACILITY 0 0 67,000 67,000 100.0 170 SERIES 1993B B&I, PUBLIC BLDGS 0 0 0 0 180 SERIES 2001 B&I, VILLAGE HALL 300 300 390,128 389,828 99.9 190 SERIES 2003 B&I, VILLAGE HALL 0 300 911,932 911,632 100.0 200 SERIES 2002B B&I, PUBLIC BLDGS 300 300 610,051 609,751 100.0 230 SERIES 2002A B&I, TIF 300 300 36,650 36,350 99.2 240 SERIES 1992B B&I, TIF 0 0 0 0 250 SERIES 1993A B&I, TIF 0 0 0 0 260 SERIES 1994B B&I, TIF 0 0 0 0 270 SERIES 1996B B&I, TIF 0 0 0 0 280 SERIES 1998B B&I, TIF 0 0 0 0 290 SERIES 1999 B&I, TIF 0 113,100 906,200 793,100 87.5 300 SERIES 1991A B&I, FLOOD 0 0 0 0 310 SERIES 1992A B&I, FLOOD 0 0 0 0 320 SERIES 1993B B&I, FLOOD 0 0 0 0 330 SERIES 1994A B&I, FLOOD 0 0 0 0 340 SERIES 1996A B&I, FLOOD 0 0 213,100 213,100 100.0 350 SERIES 1998A B&I, FLOOD 0 0 62,983 62,983 100.0 360 SERIES 1998C B&I, TIF 0 0 153,295 153,295 100.0 380 IEPA FLOOD CONTROL LOANS B&I 168,629 188,274 613,355 425,081 69.3 390 SERIES 2000 B&I, FLOOD CONTROL 0 300 292,098 291,798 99.9 400 SERIES 2002B B&I, FLOOD 0 0 246,461 246,461 100.0 410 SERIES 1994A B&I, STREET IMP. 0 0 0 0 420 SERIES 1996A B&I, STREET IMP. 0 0 0 0 430 SERIES 1998A B&I, STREET IMP. 0 0 0 0 440 SERIES 2002B B&I, STREET IMP. 0 0 0 0 810 SSA #1 PROSPECT MEADOWS B&I 0 0 0 0 830 SSA #6 GEORGE/ALBERT B&I 0 0 37,800 37,800 100.0 Totals 169,529 302,874 4,541,053 4,238,179 93.3 21 05/12/2005 18:54:55 FRRDBROl SUM031 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 04/30/05 01 02 03 Cur Mo Y-T-D 2005 Unexpended Unexpended Expended Expended Budget Balance Percent 4,557 18,230 54,630 36,400 66.6 189,299 758,470 2,366,440 1,607,970 67.9 189,984 750,854 2,328,948 1,578,094 67.8 383,840 1,527,554 4,750,018 3,222,464 67.8 PROGRAM TOTALS RETIREE PENSIONS MISCELLANEOUS PENSIONS POLICE PENSIONS FIRE PENSIONS Totals EXPENDITURE CLASSIFICATION 53 54 383,090 1,525,750 4,746,868 3,221,118 67.9 750 1,092 2,950 1,858 63.0' 0 712 200 -512 -256.0 0 o ° o 383,840 1,527,554 4,750,018 3,222,464 67.8 PENSION BENEFITS CONTRACTUAL SERVICES COMMODITIES & SUPPLIES OFFICE EQUIPMENT 57 65 Totals SOURCE OF FUNDS 001 710 720 730 GENERAL FUND POLICE PENSION FUND FIRE PENSION FUND BENEFIT TRUST #2 FUND 4,557 18,230 54,630 36,400 66.6 189,299 758,470 2,366,440 1,607,970 67.9 189,984 750,854 2,328,948 1,578,094 67.8 o 0 ° o 383,840 1,527,554 4,750,018 3,222,464 67.8 Totals 22 .05/12/2005 18:54:55 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 04/30/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining Totals Cur Mo Y-T-D 2005 unexpended Unexpended Expended Expended Budget Balance Percent 111,697 386,808 1,260,047 873,239 69.3 337,548 1,350,185 4,409,303 3,059,118 69.4 449,245 1,736,993 5,669,350 3,932,357 69.4 RISK MANAGEMENT PROGRAM TOTALS 01 02 CASUALTY & PROPERTY INSURANCE MEDICAL INSURANCE EXPENDITURE CLASSIFICATION 54 CONTRACTUAL SERVICES 56 INSURANCE o 449,245 603 1,736,390 39,000 5,630,350 38,397 3,893,960 98.5 69.2 Totals 449.245 1,736,993 5.669.350 3,932.357 69.4 SOURCE OF FUNDS 690 RISK MANAGEMENT FUND 449,245 1,736,993 5,669,350 3,932,357 69.4 . ' Totals 449.245 1.736,993 5,669.350 3,932.357 69.4' ~;.' 23 05/12/2005 18,54,55 FRRDBROl SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 04/30/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining Totals Cur Me Y-T-D 2005 Unexpended Unexpended Expended Expended Budget ,.Balance Percent 34,583 235,833 805,000 569,167 70.7 34,583 235,S33 805,000 569,167 70.7 NON-DEPARTMENTAL PROGRAM TOTALS 01 CONTINGENCIES EXPENDITURE CLASSIFICATION 50 PERSONAL SERVICES 53 PENSION BENEFITS 54 CONTRACTUAL SERVICES 59 OTHER EXPENDITURES 80 INTERFUND TRANSFERS Totals 0 a 0 a a 0 a a 0 0 a 0 0 a a a 34,583 235,833 805,000 569,167 70.7 34,583 235,833 805,000 569,167 70.7 SOURCE OF FUNDS 001 560 670 GENERAL FUND STREET IMPROVEMENT CONST FUND VEHICLE REPLACEMENT FUND Totals 34,583 235,833 805,000 569,167 70.7 a a a a a 0 0 a 34,583 235,833 805,000 569,167 70.7 24 ,O5/12/2005 18,54,55 FRRDBROl SUMO3l 4 Months ( 8 Months ( VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 04/30/05 CAPITAL FIXED ASSETS Cur Mo Expended 0 PROGRAM TOTALS 00 CAPITAL FIXED ASSETS Totals EXPENDITURE CLASSIFICATION 59 OTHER EXPENDITURES Totals SOURCE OF FUNDS 910 GENERAL FIXED ASSETS ACCT GP Totals Y-T-D Expended 2005 Budget 0 0 0 0 0 0 0 0 0 0 0 0 25 33.3% ) Completed 66.6% ) Remaining Unexpended Unexpended Balance Percent 0 0 0 0 0 0 0 0 0 0 0 05/12/2005 18,54,55 FRRDBROI SUM 031 VILLAGE OF MOUNT PROSPECT Department Budget Expenditure Summary 01/01/05 - 04/30/05 4 Months ( 8 Months ( 33.3% ) Completed 66.6% ) Remaining MOUNT PROSPECT LIBRARY Cur Mo Expended Y-T-D Expended 2005 Budget Unexpended Unexpended Balance Percent PROGRAM TOTALS 02 LIBRARY SERVICES 0 0 8,536,993 8,536,993 100.0 Totals 0 0 8,536,993 8,536,993 100.0 EXPENDITURE CLASSIFICATION 90 COMPONENT UNIT EXPENDITURES 0 0 8,536,993 8,536,993 100.0 Totals 0 0 8,536,993 8,536,993 100.0 SOURCE OF FUNDS 950 MOUNT PROSPECT LIBRARY FUND 0 0 8,536,993 8,536,993 100.0 Totals 0 0 8,536,993 8,536,993 100.0 26