The URL can be used to link to this page

Home My WebLink About3. Monthly Financial Report & Approve Bills 10/21/2014Fund Vendor Name 001 General Fund ACS State & Local Government Solutions Affiliated Customer Service, Inc. Air One Equipment, Inc. Airgas, Inc. Amer Reprographics Co Llc American Landscaping Inc. Anderson Pest Solutions Andrade, Consuelo Andres Medical Billing, Ltd. Appliance Marshall Repair, Inc. Aramark Uniform Services, Inc. Assured Construction Corp. Avi, Michelle Baldini, Carol Bedco Mechanical Business Oriented Software Solutions, Inc. Busse's Flowers & Gifts Capital One National Association CDW Government, Inc. Century Cleaners Clia Laboratory Program Comcast Cook County Recorder of Deeds Cooney, William J. Costar Realty Information, Inc. Crain Communications Inc. Crystal Court Shopping Center Dawson, Henry Didier Farms Elite Remodeling Group, Inc. Emergency Medical Products Eterno, David G. EWS Consultants, Inc. Experian Fawley's Inc. Federal Express Corp Fire Pension Fund Fleck's Landscaping VILLAGE OF MOUNT PROSPECT List of Bills October 01- October 15, 2014 Invoice I Illinois State Disbursement Unit Fire Alarm testing @ 9 buildings & fire system repairs at PW, VH Hydra Ram Kit Oxygen Supplies Equipment Maintenance Grass cutting - 21 N. Lancaster Wasp Nest at 319 N. School Wasp Nest at Ivy/Kiowa Wasp Nest at 719 Dresser October pest control at the CCC - Invoice 3116295 Consuelo-Reimbursement Ambulance Billing -September 2014 Repair of Station 14 stove Cleaning and rental for all Public Works employees Maintenance and repair supplies Refund Overpayment Vehicle License Fee Reimbursement for mileage Reimbursement for supplies for the CCC Reimbursement for items for the MRC Reimbursement for MRC supplies Replace expansion tank for Village Hall boiler DiagWin Support Renewal Sympathy Arrangement 9/4/14 Costco Purchased 8/25/14 - 9/18/14 Websense Renewal Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Certificate Fee Xfinity internet service 10/11-11/10/14 Recording 2014 Mileage Reimbursement Reimbursement -Raffle prizes Costar Periodicals & Publications November rent for the CCC DC adapter and extension cord for laptop Acer PC Civic Events Supplies Garnishment Medical supplies for the MRC Thermometers, Thermometer Covers Legal Professional Services Background checks - September, 2014 Passports / Nametags for Rady/Johnson Shipping for 2 Separate Sierra Wireless Modem Repairs Shipping Expenses Fire Pension Grounds Maintenance Grounds Maintenance Page 1 of 9 Amount 4,782.08 5,690.00 1,630.00 271.08 62.00 270.00 75.00 75.00 75.00 48.00 306.00 5,534.33 381.80 99.35 336.00 27.00 119.28 21.99 260.91 32.91 1,357.80 3,360.00 80.00 2,136.49 10,760.00 12.30 14.58 25.05 15.93 12.30 22.75 150.00 82.90 172.00 229.60 223.93 518.75 97.95 5,839.97 36.60 338.16 1,130.00 142.22 221.78 965.10 300.00 200.00 77.00 119.70 161.78 54.62 22,644.69 5,012.00 100.00 Fund Vendor Name Fleck's Landscaping Gall's, Inc. Grainger Inc. Graybar Electric Co. Griffin, Timothy Guardian Heart Rate Inc. Heinking, Jill Hill, David IACE ICMA Retirement Trust - 457 Illinois American Water Company Illinois Arborist Association Illinois Department of Revenue Illinois Division of I.A.I. Illinois Environmental Health Assc. Illinois Fire Chiefs Educ. & Research Foundation Illinois Society of Fire Service Instructors Illinois State Police IMRF Infection Control/emerging Concepts, Inc. Internal Revenue Service International Code Council, Inc. International Union of Operating Engineers Janowick, Timothy Karlstedt Landscape Group, Inc. Kiesler Police Supply, Inc. Kowalczyk, Michele Lambel, Brian Lands' End Business Outfitters Lojewski, Jeffrey McDonald's Corporation Menards Metro Federal Credit Union Metropolitan Alliance - Police Meyer Laboratory, Inc. Michael Wagner & Sons, Inc. Microsystems Inc. Middleton, Joan Milieu Design LLC Mobile Print Inc. Monahan, Timothy & Katherine Motorola Solutions, Inc. Mount Prospect Chamber of Commerce Mt. Prospect Volunteer Fire Dept VILLAGE OF MOUNT PROSPECT List of Bills October 01- October 15, 2014 Invoice Description Amount Plow Damage Seeding Contract 1,500.00 Disposable emergency blankets 477.94 Inspection Supplies 226.07 Sign Making Materials 31.77 Street light supplies 253.50 Reimburse expenses: SMIP course deposit 250.00 Reimburse airfare for IACP Conference 853.94 Emp. Dental October 2014 9,097.92 Replacement Parts for the Versaclimber 23.00 Reimbursement for MRC supplies 41.98 Rebate Sidewalk Shared Program Cost 250.00 Sept. 10th training session 80.00 ICMA 457 (flat percent) 19,285.42 Private Fire Service 10/2/14 -10/29/14 33.84 Travel and Meeting Expenses 2,165.26 IL State Withholding 35,882.85 2015 Membership renewal: D. Okon 20.00 2015 Membership- Frank Krupa 45.00 Tactics and Strategy I Sept. 8-12 Laurinaitis 300.00 Training Fire Folders 637.50 Rady-Background Check 31.50 Johnson -Background Check 31.50 IMRF 165,803.45 2014 Infection Control Update 90.00 Federal Withholding 167,647.13 Robert Roels-Member renewal 50.00 IUOE PW Membership Dues 1,028.52 Reimburse expenses: Airfare for IACP conference 10/24-28/14 1,231.54 Forestry Tree/Bush/Flower Replacement 820.00 Parkway Restoration 554.58 Ammunition 3,140.22 Decorations for C. Loomis Shower and Sternos for the Dept. 47.84 Lunch for Admin -FF Exam 61.91 Purchase of Training Smoke Liquid 299.88 Uniform Expense 78.50 Refund Overpayment Vehicle License Fee 36.00 Prisoner meals - August, 2014 265.24 Citizens Police Academy supplies 8.31 Padlock for SMART trailer 10.49 MP Fire Local 4119 Dues 1,816.02 MP Police Association Dues 1,349.50 Custodial supplies to be used in all buildings 874.11 Maintenance and repair supplies 559.99 Maintenance and repair supplies 16.53 Maintenance and repair supplies 368.00 Records Management 812.48 Records Management 3,732.30 Reimbursement 205.85 Landscape Maintenance 2,840.30 EDC invite mailing 1,214.26 Community Service Orders 176.54 Business cards for J. Heinking & J. Arteaga 75.66 Refund Overpayment Vehicle License Fee 72.00 Transfer Stamp Rebate 1,215.00 CERT radio battery replacements 1,677.26 Radio accessories: antenna, carry strap 406.20 Golf outing 600.00 Reimbursement -2014 Monroe Fire School Class 850.00 Page 2 of 9 Fund Vendor Name Mt. Prospect Volunteer Fire Dept Municipal Fleet Managers Assoc Nationwide Mutual Insurance Company NCPERS Group Life Ins. Neopost USA Inc. Newport Township Fire Protection District NICOR N IOA Northern Illinois Police Alarm System Northwest Central Dispatch System Northwest Community Hospital Northwest Electrical Supply Northwest Suburban United Way Novak & Parker Inc. Office Depot Okon, David Paddock Publications, Inc. Perrce, Paul J. Petty Cash Police Executive Research Forum Police Pension Fund Power Systems Inc. Proforma Customized Graphics PSS World Medical Inc. Quality Blacktop LLC RC Topsoil Inc. Reliance Standard Life Insurance Co. Relias Learning, LLC Retro Bistro, Inc. Russo Power Equipment Schroeder, William Shamon, Najiya SHI International Corp. Sid Tool Co., Inc. Signs By Tomorrow Skoskiewicz, Bogdan Sound Incorporated Stanard & Associates, Inc. State of Illinois Tesla, Dragoslav & Bijana The Brickman Group Ltd., LLC The Ups Store Thompson Elevator Inspections VILLAGE OF MOUNT PROSPECT List of Bills October 01- October 15, 2014 Invoice 1 Reimbursement -Hotel Expense Register M. Eterno & T. Grifffin for Chrysler presentation 10/21 Nationwide 457 (flat percent) IMRF Life Insurance Postage Machine Replenishment -10/08/14 Class Registration B. Bocox, Veh Mach Tech 9/29 -10/3 Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption 2015 Membership renewal: G. Sill NIPAS equipment for R. LaBarbera November 2014 - Member Assessment Medical for Rady Maintenance and repair supplies Maintenance and repair supplies United Way Maintenance and repair supplies Maintenance and repair supplies Office Supplies Office Supplies - August 2014 Office Supplies Missed item on billing Reimburse expenses: Repairs to evidence scanner & cradle PZ -28-14 legal notice PZ -29-14 legal notice PZ -30-14 legal notice Bid Notice Maintenance and repair supplies Petty Cash September 2014 Registration for SMIP course for T. Griffin 05/29-06/18/15 Police Pension Misc. replacement exercise equip (resistance bands, BOSU ball) Special Events Supplies Pulse OX finger Retainage Release 2013 Restoration Materials Short Term Disability Department online training 2014 Employee recognition luncheon Other Equipment WMS Reimbursement -Training WMS Reimbursement - Office/Inspection Supplies Rebate Sidewalk Shared Program Cost Smartnet Renewals Street light supplies Sign Making Materials Transfer Stamp Rebate SMARTnet Renewals for Phone Switches Personality Test for Johnson Monthly Internet Fees Transfer Stamp Rebate Grounds Maintenance Shipment of utility payments to lockbox 4297 Elevator Inspections Elevator Inspections Elevator Inspections Page 3 of 9 Amount 861.56 50.00 10,975.50 665.60 3,000.00 500.00 228.17 329.71 160.52 1,934.52 228.34 80.00 1,531.14 56,811.12 930.00 164.27 205.33 233.14 155.55 157.49 127.25 137.18 145.99 19.36 200.00 82.35 85.05 86.40 83.70 1,428.00 24.43 8,900.00 29,300.90 287.58 408.57 369.59 443.82 435.60 1,155.25 1,776.39 945.00 475.00 336.07 96.43 250.00 9,064.65 236.70 610.80 634.00 11,968.00 395.00 1,166.25 572.00 2,215.00 36.45 75.00 336.00 150.00 VILLAGE OF MOUNT PROSPECT List of Bills October 01 - October 15, 2014 Fund Vendor Name Invoice Description Amount Thompson Elevator Inspections Elevator Inspections 75.00 EWS Consultants, Inc. Elevator Inspections 75.00 Public Building Improvements Elevator Inspections 37.00 Traffic and Parking Control Co, Inc. Replacement signs for stock 242.27 TransUnion Risk and Alternative Data Solutions Inc Background checks - September, 2014 112.00 Travis Sound Installations, Inc. 2 New amplifiers for station 13 including parts for installation 1,650.50 Move 800 trunking radio from under water pump 72.50 Trugreen Limited Partnership Contractual Contract Spraying 436.00 U.S. Bank Equipment Finance, Inc. PW Copy 1 Contract Payment 167.50 Fire Station 12 Contract Payment 138.78 Uline Inc. Photo evidence supplies 109.87 United Healthcare Flex Benefit Plan Services 611.00 University of Illinois Fire Prevention Principles Class Novak 9/8/14-9/11/14 300.00 Uram Ruppen Enterprises, Inc. Windscreen replacements for Headsets 101.00 VCG Uniform Body armor: Nordin, Knippel, Giera 2,460.00 Lt. Peterson promotional uniform items 298.45 "Fire Investigator" T -Shirts 430.80 Village of Mount Prospect Flex - Medical 8,523.76 W.S. Darley & Co. Intake Relief Valves 1,559.32 Warehouse Direct Office Supplies 33.76 101" binders, 6x9 envelopes, AA batteries, 9V batteries 106.73 Batteries 10.20 4 Boxes of Copy Paper/ 2 12 tab binders 132.14 WISCTF Garnishment 542.48 001 General Fund Total $ 680,756.06 020 Capital Improvement Fund Business Office Systems, Inc. Replacement Furniture Office Chairs for Staff Chair Cylinders EWS Consultants, Inc. Design for Customer Service Area Grainger Inc. Public Building Improvements Mercury Partners 90 BI Inc. Public Building Improvements Northwest Central 9-1-1 System Motorola Subscriber Financing - October 2014 Nova Fire Protection, Inc. Sprayer adjust at Public Works lunch room & front lobby Zepole Restaurant Supply Co. Replacement Appliances 020 Capital Improvement Fund Total 022 Downtown Redevelopment Construction Fund Bill's Commercial Painting Inc. Streetscape Furnishing Maintenance Milieu Design LLC Landscape Maintenance Sullivans Law Directory Demolition -Suburban 9/12/14 022 Downtown Redevelopment Construction Fund Total 023 Street Improvement Construction Fund Arrow Road Construction Weglarz, Janet 023 Street Improvement Construction Fund Total 024 Flood Control Construction Fund Burns & Mcdonnell Engineering Co. 024 Flood Control Construction Fund Total 040 Refuse Disposal Fund 2014 Street Resurfacing Refund Reduction in the size of apron Upgrade Engineering Services $ 11,056.25 9,591.96 174.66 390.00 109.35 248.41 10,603.91 4,050.00 9,694.22 $ 45,918.76 $ 14,653.00 6,192.88 609.00 $ 21,454.88 $ 495,603.65 71.20 $ 495,674.85 $ 48,904.80 $ 48,904.80 ARC Disposal Company Refuse Disposal Program $ 6,688.12 Groot Industries, Inc. Refuse Disposal Program 341.28 Headco Industries, Inc. Leaf Machine Parts 416.04 Repair Maintenance Supplies 85.00 Page 4 of 9 Fund Vendor Name ICMA Retirement Trust - 457 Illinois Department of Revenue IMRF Internal Revenue Service International Union of Operating Engineers Messick Farm EQ Nationwide Mutual Insurance Company NCPERS Group Life Ins. Northwest Suburban United Way Reliance Standard Life Insurance Co. Village of Mount Prospect 040 Refuse Disposal Fund Total 041 Motor Fuel Tax Fund Constellation NewEnergy, Inc. Lyons & Pinner Electric Companies 041 Motor Fuel Tax Fund Total 042 Community Development Block Grant Bran, Victoria A. C+S General Contractors, Inc. Federal Express Corp ICMA Retirement Trust - 457 Illinois Department of Revenue IMRF Internal Revenue Service Northwest Center Against Sexual Assualt Office Depot Pads to Hope, Inc. Reliance Standard Life Insurance Co. Suburban Primary Health Care Council T. P. 1. The Lead Inspectors, USA Inc Village of Mount Prospect 042 Community Development Block Grant Total 046 Foreign Fire Tax Board Fund Foster Coach Sales Inc. 046 Foreign Fire Tax Board Fund Total 050 Water and Sewer Fund Aramark Uniform Services, Inc. Badger Meter Inc Baxter & Woodman, Inc. Buck Sales, Inc. Century Cleaners VILLAGE OF MOUNT PROSPECT List of Bills October 01 - October 15, 2014 Invoice Description Amount ICMA 457 (flat percent) 37.92 IL State Withholding 414.21 IMRF 3,244.67 Federal Withholding 2,904.03 IUOE PW Membership Dues 99.23 Leaf machine transition 873.21 Nationwide 457 (flat percent) 231.17 IMRF Life Insurance 17.60 United Way 3.85 Short Term Disability 27.92 Flex - Medical 79.38 $ 15,463.63 Electrical Service Delivery $ 53.61 Traffic Light Maintenance 1,642.38 $ 1,695.99 CDBG Subrecipient 3rd Qtr $ 33.08 CDBG- 3rd Qtr Invoice 536.48 CDBG SFR -1415 Lama Ln 29,590.00 CDBG delivery expense 22.56 ICMA 457 (flat percent) 112.50 IL State Withholding 65.98 IMRF 545.98 Federal Withholding 424.47 CDBG- 3rd Qtr Subrecipient 1,233.34 CDBG Subrecipient CCC -3rd Qtr 302.59 CDBG- 3rd Qtr Sub recipient 2,250.00 Short Term Disability 39.36 CDBG- 3rd Qtr Subrecipient 1,000.00 CDBG- SFR building inspections 80.00 CDBG SFR- lead inspections 550.00 Flex - Medical 78.13 $ 36,864.47 Pole/Ped MT WHT & Sensor $ 4,260.60 $ 4,260.60 Cleaning and rental for all Public Works employees $ 99.35 AMR/AMI System 25,276.80 AMR/AMI System 15,478.00 AMR/AMI System 1,237.50 AMR Systems (448.70) AMR Systems (2,692.20) AMR Systems (5,219.76) ARM Systems (2,237.04) SCADA Wireless 1,985.00 Professional Services 1,350.00 Equipment Maintenance and Repair 1,423.48 Uniform Cleaning 12.30 Uniform Cleaning 14.57 Uniform Cleaning 25.05 Uniform Cleaning 15.92 Uniform Cleaning 42.80 Page 5 of 9 Fund Vendor Name Century Cleaners Eaton Corporation Garvey's Office Products HBK Water Meter Service Healy Asphalt Company,llc. ICMA Retirement Trust - 457 I1-13 Property Illinois Illinois Arborist Association Illinois Department of Revenue IMRF Internal Revenue Service International Union of Operating Engineers Joseph Oster Karlstedt Landscape Group, Inc. Lutheran Church, St Pauls Manubhai Patel Maxx Contractors Corp Mcmaster-carr Supply Co. Menards Microsystems Inc. Milieu Design LLC Nationwide Mutual Insurance Company NCPERS Group Life Ins. NICOR Northwest Suburban United Way Quality Blacktop LLC RC Topsoil Inc. Reliance Standard Life Insurance Co. Sid Tool Co., Inc. Suburban Laboratories, Inc. Teledesign Systems, Inc. Third Millennium Assoc.inc. U.S. Bank Equipment Finance, Inc. Village of Mount Prospect Warehouse Direct 050 Water and Sewer Fund Total 051 Village Parking System Fund VILLAGE OF MOUNT PROSPECT List of Bills October 01- October 15, 2014 Invoice I Uniform Cleaning Uniform Cleaning Repair and Maintenance Supplies Office Supplies Water Meter Installations Water Meter Installations Water Meter Installations Water Meter Installations Water Meter Installations Asphalt Repairs Asphalt material used for street patching Asphalt material used for street patching Asphalt materials used for street patching ICMA 457 (flat percent) Utility Refund - 718 Crestwood Ln Utility Refund - 611 N Prospect Manor Ave Travel and Meeting Expenses IL State Withholding IMRF Federal Withholding IUOE PW Membership Dues Utility Refund -17 N Pine St Parkway Restoration Utility Refund -17 S Elm St Utility Refund -1854 Phillip Dr Catch basin & inlet repairs @ various locations per 2014 Repair Repair Maintenance Supplies Repair Maintenance Supplies Repair Maintenance Supplies Repair Maintenance Supplies Repair Maintenance Supplies Records Management Records Management Landscape Maintenance Nationwide 457 (flat percent) IMRF Life Insurance Natural Gas Consumption Natural Gas Consumption United Way Retainage Release 2013 Restoration Materials Short Term Disability Repair Maintenance Supplies Water Sample Testing SCADA Radio Repair/Maintenance September 2014 - Utility Billing PW Copy 1 Contract Payment Flex- Medical Office Supplies Amount 12.30 22.75 7,075.00 315.97 308.75 478.25 621.60 1,024.80 240.50 339.08 41.58 42.08 18.32 1,249.45 53.72 33.57 234.74 2,795.37 23,683.20 16,849.01 932.91 69.89 5,240.42 10.58 38.63 15,806.00 87.07 23.51 26.85 95.90 7.98 400.18 1,579.82 2,991.82 420.89 52.80 74.96 86.46 34.73 5,842.07 224.40 38.87 192.80 376.00 447.43 3,187.11 167.50 625.45 311.83 $ 131,197.97 Bright Electrical Supply Co. Other supplies $ 329.35 Elite Remodeling Group, Inc. Garnishment 78.19 Garelli Pavement Services Inc. Parking lot sealing at Public Works 10,820.47 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 6.00 Illinois Department of Revenue IL State Withholding 50.03 IMRF IMRF 434.46 Page 6 of 9 VILLAGE OF MOUNT PROSPECT List of Bills October 01- October 15, 2014 Fund Vendor Name Invoice Description Internal Revenue Service Federal Withholding International Union of Operating Engineers IUOE PW Membership Dues Nationwide Mutual Insurance Company Nationwide 457 (flat percent) Petty Cash Petty Cash September 2014 Village of Mount Prospect Flex - Medical 051 Village Parking System Fund Total 052 Parking System Revenue Fund Elite Remodeling Group, Inc. Garnishment Garelli Pavement Services Inc. Parking lot sealing at Public Works ICMA Retirement Trust - 457 ICMA 457 (flat percent) Illinois Department of Revenue IL State Withholding IMRF IMRF Internal Revenue Service Federal Withholding International Union of Operating Engineers IUOE PW Membership Dues Nationwide Mutual Insurance Company Nationwide 457 (flat percent) Quality Blacktop LLC Retainage Release 2013 Village of Mount Prospect Flex - Medical 052 Parking System Revenue Fund Total 060 Vehicle Maintenance Fund Alexander Equip.co., Inc. Equipment Maintenance and Repair Equipment Maintenance and Repair Vehicle Maintenance Supplies American Messaging Pager rental Arlington Heights Ford Squad Power Steering hose and relays Vehicle Maintenance Supplies Vehicle Maintenance Supplies 2758 Shifter lever 506 Front spring Bumpers 506 Glow plug harness 2742 Washer nozzles P-7 Relay P-38 Intake manifold Transmission seals P-38 Fuel injector O -Rings Equipment Maintenance and Repair Bridgestone Retail Operations, LLC. Vehicle Maintenance Supplies Busse Car Wash, Inc. Equipment Maintenance & Repair Catching Fluidpower Equipment Maintenance and Repair Chicago Parts & Sound Llc Ford batteries 610A Front wheel bearing Ford batteries P-13 Sway bar links Police transmission filters Oil filters General Parts Inc. Washer solvent Oil Global Emergency Products Fire engine door magnets Fire engine rear door switches ICMA Retirement Trust - 457 ICMA 457 (flat percent) Illinois Department of Revenue IL State Withholding IMRF IMRF Inland Power Group Inc. Air filters Air filters Air, fuel filters Air filters Internal Revenue Service Federal Withholding Page 7 of 9 Amount 298.63 15.21 9.96 21.00 34.64 $ 12,097.94 64.02 6,195.53 4.00 36.79 320.54 219.14 10.17 6.65 666.66 27.44 7,550.94 1,600.00 1,400.00 106.35 97.84 149.48 (205.72) (300.00) 53.03 45.00 44.87 10.24 17.39 349.15 12.15 37.40 110.00 259.16 763.00 56.52 417.44 152.87 417.44 54.06 72.44 225.36 243.60 34.74 44.24 426.41 685.24 1,429.79 11,510.23 85.40 22.14 298.25 33.64 8,700.88 VILLAGE OF MOUNT PROSPECT List of Bills October 01- October 15, 2014 Fund Vendor Name Invoice Description Amount International Union of Operating Engineers IUOE PW Membership Dues 474.38 James Drive Safety Lane LLC 549 State Safety Lane 24.00 Johnson, Tom C Training Expenses 95.00 Leach Enterprises, Inc. Vehicle Maintenance Supplies 471.02 37.03 Vehicle Maintenance Supplies 485.28 Lund Industries, Inc. Vehicle Maintenance Supplies 108.00 New 4509 fittings Vehicle Maintenance Supplies 48.00 Mcmaster-carr Supply Co. Police light cart wheels 93.56 201.80 Paint mask film covers 21.17 Morton Grove Automotive 530 Primer pump Motor 275.00 NCPERS Group Life Ins. IMRF Life Insurance 48.00 Northwest Suburban United Way United Way 3.85 Parent Petroleum, Inc. Vehicle Maintenance Supplies 341.84 Pomp's Tire Service, Inc. Equipment Maintenance and Repair 257.50 Reliance Standard Life Insurance Co. Short Term Disability 54.27 Runnion Equipment Co Vehicle Maintenance Supplies 44.79 Rush Truck Centers of Illinois, Inc. 4528 Wiper transmission 306.14 4513 Air brake modulator valve 235.56 Fire Engine 518 body panel damage noticed on 8/22/14 4513 Air brake fittings and alarm buzzer 57.06 Sid Tool Co., Inc. Machine screws, washers, cable ties and bolts 407.55 Spring Align of Palatine, Inc. Equipment Maintenance 1,698.90 Vehicle Maintenance Supplies 35.55 Suburban Accents Inc Vehicle Maintenance Supplies 40.00 Terrace Supply Company Equipment Rental 37.56 862.50 Vehicle Maintenance Supplies 203.34 $ Vehicle Maintenance Supplies 33.60 Village of Mount Prospect Flex- Medical 195.84 060 Vehicle Maintenance Fund Total Performance Evaluation and Consulting Services 10/1/14-12/31/14 $ 35,556.79 061 Vehicle Replacement Fund Catching Fluidpower Equipment for Public Works Vehicles $ 44.75 New truck 4509 hydraulic fittings 65.47 New truck 4509 suction hose 271.26 New truck 4509 hyd fittings 37.03 New truck 4509 hyd fittings 45.68 New 4509 fittings 5.99 Finishmaster, Inc. Equipment for Public Works Vehicles 201.80 Equipment for Public Works Vehicles 252.25 GovDeals, Inc. Equipment for Public Works Vehicles 2,367.00 Leach Enterprises, Inc. Equipment for Public Works Vehicles 41.92 Midwest Transit Equipment, Inc. New Fire Bus 549 49,970.75 The Color Shoppe Equipment for Public Works Vehicles 232.86 061 Vehicle Replacement Fund Total $ 53,536.76 063 Risk Management Fund Global Emergency Products Fire Engine 518 body panel damage noticed on 8/22/14 $ 371.05 063 Risk Management Fund Total $ 371.05 070 Police Pension Fund IPPFA (il Public Pension Fund) IPPFA 2015 Annual Membership Dues $ 775.00 Reimer & Karlson LLC Legal Services Rendered August 2014 862.50 070 Police Pension Fund Total $ 1,637.50 071 Fire Pension Fund Bogdahn Consulting, LLC Performance Evaluation and Consulting Services 10/1/14-12/31/14 $ 9,000.00 IPPFA (il Public Pension Fund) IPPFA 2015 Annual Membership Dues 775.00 071 Fire Pension Fund Total $ 9,775.00 Page 8 of 9 VILLAGE OF MOUNT PROSPECT List of Bills October 01- October 15, 2014 Fund Vendor Name 073 Escrow Deposit Fund Alaimo, Michael J All American HVAC Co Bergeron, Jennifer C/O A & R Katz Management Inc, Huntington SquareAPT C3 Construction Services Colliers International Designers Concrete LLC Duran Concrete Inc Ellsworth, Marian B Espinoza Twin Brothers Landscaping Fijor, Carmella First Industrial Lp Four Seasons Heating and A/C Gadge Signs Inc Groenwald, Thomas H2O Plumbing and Sewer Services I1-12 Property Illinois a Delaware Ltd Partners I1-12 Property Illinois a Delaware Ltd Partnership IHC Construction Companies Illinois State Treasurer J & S Plumbing Inc JNL Climate Control Inc Knudsen Construction Inc Korbel Family Revocable Trust Lenberg, Tom J Lewis, Jonoy Lukowicz, David Maher, John Martam Construction Masciola, Robert Mc Donald, Mark/ Mary Beth Mc Ghee, James Mount Prospect Public Library National Power Rodding Parvin Clauss Sign Company Presidential Construction Principle Construction Corp Prus, Marek Quality Plumbing Services Inc Randco Construction Salinas, Harley Shell Pipeline Company Third District Circuit Court West Shore Pipeline Co Western Utility Contractors Inc Zyluk, Bartosz 073 Escrow Deposit Fund Total Grand Total Invoice Refund Escrow Permit # 14-1903 (1810 Andoa Ln) Refund Escrow Permit # 14-0537 (201 N Pine St) Replacement Check #782313 (Permit 13-1242) Refund Overpayment Business License Refund Escrow Permit # 1402PW (Demolition of Sakura) Refund Escrow Permit # 14-1677 (700 Business Center Dr) Refund Escrow Permit # 14-1679 (1050 Business Center Dr) Refund Escrow Permit # 14-1796 (509 N Pine St) Refund Escrow Permit # 14-1964 (606 George St) Refund Escrow Permit # 14-1839 Refund Escrow Permit # 14-1628 (402 Craig Court) Refund Escrow Permit # 14-1197 Refund Escrow Permit # 14-1734 Refund Escrow Permit # 14-1641(415 N Prospect Manor Ave) Refund Escrow Permit # 14-1779 (900 Business Center Dr) Refund Escrow Permit # 14-1780 (799 Biermann Ct) Refund Escrow Permit # 14-1929 Refund Escrow Permit # 14-1958 (904 S Maple St) Refund Escrow Permit # 14-1959 (907 S Maple St) Refund Escrow Permit # 14-1123 (400 Walnut St) Refund Escrow Permit # 14-0876 (1709 Seminole Ln) Refund Escrow Permit # 2014M006 (1221 Business center Dr) Unclaimed Property Remittance for 2014 Refund Escrow Permit # 14-1280 (710 N Pine St) Refund Escrow Permit # 14-1177 Refund Escrow Permit # 13-0108 (2100 S Elmhurst Rd) Refund Escrow Permit # 14-1717 Refund Escrow Permit # 14-1831 Refund Overpayment Business License Refund Escrow Permit # 14-0689 (201 N Pine St) Refund Escrow Permit # 14-1867 Refund Escrow Permit # 1304PW (Kensington Road Project) Refund Escrow Permit # 14-1900 (320 Russel St) Refund Escrow Permit # 14-1676 Refund Escrow Permit # 14-1927 2014 PPRT-7th Allocation Refund Escrow Permit # 1302PW Refund Escrow Permit # 14-1764 (1660 Feehanville Dr) Refund Escrow Permit # 14-1829 (335 Hawthorne Cir) Refund Escrow Permit # 13-1142 (800 Biermann Ct) Refund Escrow Permit # 14-0840 (400 E Kensington Rd # B) Refund Escrow Permit # 14-1943 (107 N Maple St) Refund Escrow Permit # 14-0125 (2 N Maple St) Refund Escrow Permit # 14-0731 Refund Escrow Permit # 131OPW Bond Check 10/2/14 Bond Check 10/7/14 Bond Check 10/9/14 Refund Escrow Permit # 1303PW Refund Escrow Permit # 2013MO10 (1702 W Algonquin Rd) Refund Escrow Permit # 14-1823 Page 9 of 9 Amount 200.00 125.00 75.00 960.00 151.69 125.00 125.00 200.00 200.00 125.00 200.00 200.00 125.00 125.00 125.00 125.00 200.00 500.00 500.00 300.00 75.00 500.00 5,613.99 500.00 125.00 950.00 125.00 200.00 37.50 125.00 200.00 200.00 150.00 200.00 200.00 8,633.12 200.00 125.00 125.00 8,790.00 250.00 125.00 100.00 200.00 200.00 100.00 620.00 320.00 200.00 500.00 ?nn nn 5 34,576.30 $ 1,637,294.29 lk Mount Prospcct Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: OCTOBER 17, 2014 SUBJECT: MONTHLY FINANCIAL REPORT — SEPTEMBER 2014 Attached hereto are the cash position and investment statements of the Village for the month ended September 30, 2014. These statements provide a snapshot of the Village's cash position as of the month end date noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you receive. The first statement presents the Village's cash position broken down by governmental and enterprise funds and trust and agency funds. The second statement presents the Village's cash position by fund type. The third statement presents the list of investments again broken down by governmental and enterprise funds and trust and agency funds. It is important to note that although we have included the trust and agency funds in the cash position report, these funds are not accessible for Village operations. They are restricted for pension and escrow funding only. Please read the summary that follows for further detail on the cash position of the Village. Cash and Investment Position Report — All Funds (page 1) This report provides a detail summary of cash and investments for the Village broken out by governmental and enterprise funds and trust and agency funds. Governmental funds include the General Fund, Special Revenue Funds, Debt Service Fund, Capital Project Funds and Internal Service Funds. The Enterprise Funds consist of the Water/Sewer Fund and two (2) Parking Funds. Trust funds include the Village's two public safety pensions (Police and Firefighters') while the agency funds include the Escrow Deposit, Flexcomp Escrow and Library Bonds Escrow Fund. The Escrow Deposit Fund accounts for refundable deposits held by the Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Library Bonds Escrow Fund accounts for the accumulation of monies for debt service payments. Governmental and Enterprise Funds - Cash and cash equivalents at August 31 was $47.9 million. During September, cash receipts totaled $5,273,473. In addition investment income for the month was $2,016, interfund activity was $192,775 and inflows due to investment activity added $1,595,140 to the balance. Reductions in cash and cash equivalents during September totaled $5,408,222. Of this amount, payments to vendors were $4,010,985, employee payroll and related expenses were $1,392,155 and other disbursements were $5,082. Cash and cash equivalents at September 30 were $49.5 million. Monthly Financial Report — September 2014 October 17, 2014 Page 2 Investments in the Governmental and Enterprise Funds at August 31 were $3.8 million. $1.6 million worth of CD's matured during September. CD's in the Governmental and Enterprise Funds reside in the Flood Control Fund and were purchased using proceeds from the Series 2013 bond issue. The maturity dates of the CD's are laddered to match the expected payout schedule of the underlying flood control work. Total investments at September 30 were $2.2 million. Total cash and investments for Governmental and Enterprise Funds at August 31 was $51,693,930. Cash and investments at September 30 totaled $51,755,211. This is an increase of $61,281 for the month. Trust and Agency Funds - Cash and cash equivalents at August 31 was $5.5 million. During September, cash receipts totaled $322,770. In addition investment income for the month was $83,507. There was a net decrease in cash due to investment activities of $226,890 and outflows due to interfund activity were $192,775. Reductions in cash and cash equivalents during September totaled $746,556. Of this amount, payments to vendors were $151,798, employee payroll and related expenses were $579,866, payments related to the flexible ending program totaled $11,985. Other disbursements totaled $2,907. Cash and cash equivalents at September 30 were $4.7 million. Total investments at September 30 were $109,897,544, a decrease of $1,133,020 from August 31. There were unrealized investment losses of $1,359,912 and a transfer from cash of $226,890 that accounted for the change. Total cash and investments for Trust and Agency Funds at August 31 were $116,536,260. Cash and investments at September 30 totaled $114,643,296. This is a decrease for the month of $1,892,964. Summary of Cash Activity by Fund Type (page 2) This report provides a breakdown of the cash activity for the month broken down by fund type. This breakdown is useful in identifying where the activity (receipts and disbursements) is occurring. There are times during the year when activity in certain funds such as the capital improvement and special revenue funds is higher than normal. This will distort the financial picture of some of the other components of the governmental funds such as the General Fund which tends to be more level and predictable in terms of spending and receipt of revenue. Each month the report will provide detail explanation on activity of the General Fund, the Village's primary operating fund. Detail on the significant activity of the General Fund is highlighted below. General Fund — Cash and cash equivalents at August 31 totaled $10,127,993. During September, cash receipts totaled $3,035,000 and investment income was $186. Significant cash receipts included sales taxes, state income tax and landlord/tenant Fees. Sales tax revenues for the month totaled $1,309,456. Of this amount, $1,182,644 was generated from the 1% state portion while $126,812 was generated from the .25% home rule portion. Sales taxes received in September are for June sales as there is a three- month lag in getting this distribution from the state. H:\ACCT\Treasurer's Report\2014\Monthly Cash Position Report - September 2014.docx Monthly Financial Report — September 2014 October 17, 2014 Page 3 State income tax receipts for September totaled $504,690. Income tax revenue received by the village during this month was to be received in July. The state is 2 months in arrears in remitting these taxes to the Village. The total amount in arrears is approximately $590,000. Revenue from the Landlord/Tenant fee received in September totaled $225,064. This license fee is an annual billing to rental property owners. The license period runs from September 1 to August 30. Disbursements from the General Fund for September included payments to vendors of $1,355,570, payments for employee wages and benefits of $1,238,006 and other disbursements of $5,088. Interfund transfers of $607,279 were also made during September. Cash and cash equivalents at September 30 was $9,957,237. There were no investments in the General Fund at September 30. Statement of Investments (page 3) This report provides a breakdown of investments by governmental and enterprise funds and trust and agency funds. The report also provides a fund -by fund breakdown of the investments. Government and Enterprise Funds - Investments for the governmental and agency funds are typically made up of Certificates of Deposit. At September 30 there was a total of $2.2 million invested in CD's. These CD's are investing proceeds of the 2013 flood control bond issue. Other surplus funds in the governmental and enterprise funds have been placed in interest bearing money market accounts. Maturity Purchase Financial Date Date Institution FLOOD CONTROL CONSTRUCTION FUND (024} 10/20/14 01/21/14 Bank Leumi USA, NY 10/20/14 01/21/14 Cole Taylor Bank (N), IL 10/20/14 01/21/14 IDB Bank, NY 10/20/14 01/21/14 Republic Bank of Chicago, IL 11/18/14 01/21/14 Bank or China, NY 11/18/14 01/21/14 Bank of Houston, TX 11/18/14 01/21/14 State Bank of India, NY 12/18/14 01/21/14 Far East National Bank, CA 12/18/14 01/21/14 Onewest Bank FSB, CA TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS Investment CUSIP/ Interest Market Dcsoij)liort FDIC # Rate % Value Certificate of Deposit 19842 0.150% 249,700.00 Certificate of Deposit 22599 0.200% 249,600.00 Certificate of Deposit 19977 0.151% 249,700.00 Certificate of Deposit 19333 0,150% 249,700.00 Certificate of Deposit 33653 0.207% 249,200.00 Certificate of Deposit 57965 0.150% 249,600.00 Certificate of Deposit 33682 0.159% 249,600.00 Certificate of Deposit 21851 0.350% 249,200.00 Certificate of Deposit 58978 0.300% 249,300.00 2,245,600.00 $ 2,245,600.04} Trust and Agency Funds — The investments for the trust and agency funds are made up of certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in the Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of the reserves for this fund are invested in the more liquid money market account due to the nature of the deposit. Escrow refunds are processed two times per month. H:WCCT\Treasurer's Report\2014\Monthly Cash Position Report - September 2014.docx Monthly Financial Report — September 2014 October 17, 2014 Page 4 Investments for the Police and Firefighter Pension Funds consist of various fixed income securities as well as equity mutual fund accounts. Wells Fargo is the third -party holder of the fixed income securities. The funds are managed by three investment management firms, Galliard, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of the fixed income investments for the two pension funds while Galliard and Mesirow manage the balance of fixed income investments for these two funds. Each manager maintains a small portion of their portfolio in cash to help facilitate liquidity and trading. Investments in equities consist of mutual funds spread across various sectors (small, mid and large -cap stocks) as well as investment philosophies (value, core and growth). The funds also invest a small amount in international stocks. Each year the investment mix is evaluated for optimal diversification to meet pension fund investment policy goals and objectives. Equity investments held by the Police Pension Fund are managed by Sawyer Falduto Asset Management. Below is a breakdown of how the pension fund portfolios are invested. Maturity Purchase Financial Date Date Institution POLICE PENSION FUND (070} Various Various Wells Fargo Various Various Various FIRE PENSION FUND(071) Various Various Wells Fargo Various Various Various TOTAL TRUST AND AGENCY FUND INVESTMENTS Investment CUSIP/ Interest Market Description Acct # Rate % Value Wells Fargo Investments Various Various $ 22,880,733.10 Mutual Fund Investments Various Various 32,567,632.56 55,448,365.66 Wells Fargo Investments Various Various 21,026,759.01 Mutual Fund Investments Various Various :13,422,419.39 54,449,178.40 $ 109,897,544.06 Investment of the Village's pension funds is governed by an Investment Policy adopted by each Pension Board. The investment policies for both the pension funds were last updated in 2011. Conclusion This cash position report is intended to provide a snapshot of the Village's cash position as of a particular month end date. Maintaining strong cash balances allow the Village to weather delays in receipt of revenues or cover unanticipated/unscheduled expenses. Please review the information and contact me with any questions. David O. Erb Finance Director H:WCCT\Treasurer's Report\2014\Monthly Cash Position Report - September 2014.docx VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended September 30, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and Cash Equivalents Investments Balance at August 31, 2014 $ 47,854,429.72 $ 3,839,500.00 Cash receipts Investment income Transfers from investments to cash Transfers to investments from cash Interfund activity Disbursements: Accounts payable Payroll Other Balance at September 30, 2014 Balance at August 31, 2014 5,273,473.05 2,015.80 1,595,139.76 192,774.82 (4,010,984.97) (1,392,155.10) 5,082.05) 1,239.76 (1,595,139.76) Total Cash and Investments $ 51,693,929.72 5,273,473.05 3,255.56 192,774.82 (4,010,984.97) (1,392,155.10) 5,082.05) $ 49,509,611.03 $ 2,245,.600.00 $ 51,755,211.03 TRUST AND AGENCY FUNDS * Cash and Cash Equivalents Investments $ 5,505,695.00 $ 111,030,564.98 Cash receipts 322,770.13 Investment income (loss) 83,507.13 (1,359,911.58) Transfers from investments to cash 3,850,827.82 (3,850,827.82) Transfers to investments from cash (4,077,718.48) 4,077,718.48 Interfund activity (192,774.82) Disbursements: Accounts payable Payroll Flex spending Other Balance at September 30, 2014 (151,797.68) (579,865.73) (11,984.54) (2,906.62) Total Cash and Investments $ 116,536,259.98 322, 770.13 (1,276,404.45) (192,774.82) (151,797.68) (579, 865.73) (11, 984.54) (2,906.62) $ 4,745,752.21 $ 109,897,544.06 $ 114,643,296.27 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 AE VILLAGE OF MOUNT PROSPECT Summary of Cash Activity by Fund Type For the Month Ended September 30, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS * Ending balance 9,957,236.56 4.005,506,64 1,805,471 24 17,317,222.52 5.921.158 81 10,503.015.26 49,509,611.03 3,320_45R21 1,425,293.00 54,255.363 24 INVESTMENTS Certificates of deposit 2,245,600-00 2,245,600.00 - 2,245,600.00 Wells Fargo investments 43,907,492-11 - 43,907.492,11 Mutual fund investments 65,990,051.95 - 66,990,051.95 Total investments 2,245,60000 2,245.600. 00 109,897,544-06 - 112143,144,06 TOTAL CASH AND INVESTMENTS $ 9,957,236.56 $ 4,005,506.64 $ 1,805,471.24 $ 19,562,822.52 $ 5,921,158.81 $ 10,503,015.26 $ 51,755.211.03 $113,218,003.27 $ 1.425,293.00 $166,398,507.30 * Assets are restricted in purpose and do not represent discretionary assets of the government SPECIAL CAPITAL TOTAL GOVT. FIRE AND OTHER TRUST REVENUE DEBT SERVICE PROJECTS ENTERPRISE INTERNAL AND ENTERPRISE POLICE AND AGENCY GENERALFUND FUNDS FUNDS FUNDS FUNDS SERVICE FUNDS FUNDS PENSIONS FUNDS TOTAL CASH & CASH EQUIVALENTS Beginning balance $ 10,127,993.27 $ 3,937,066.19 $ 1,678,802.80 $ 15,680,680.78 $ 6,040,177,38 $ 10,389,709-30 $ 47,854,429-72 $ 4,019,608.36 $ 1,486,086.64 $ 53,360,12472 Cash receipts 3,034.999.99 439,681.07 126,780.19 386,983.70 1,178,453.27 106,574.83 5,273,473.05 177,929.18 144,840.95 5,596,243.18 Investment income 186.14 58.84 11,30 795-68 115,79 848.05 2,015-80 83,332.08 175.05 85,52293 Transfers from investments - - - 1,595,139.76 - - 1,595,139.76 3,850,827.82 - 5,445,967,58 Transfers to investments - - - s - - (4,077,718.48) (4,077,718,48) Interfund (607,278.98) 37,240.84 (12305) 117,50000 (167,949.25) 813,385.26 192,77482 (38,912.36) (153,862.46) Disbursements - other (5,087.93) - - - 5-88 - (5,082,05) (2,906.62) (7,98867) Disbursements -flexible spending - (11,984.54) (11,98454) Disbursements- payroll (1,238,006,23) (13,729,57) (94,960-61) (45,458.69) (1,392,155-10) (579,865.73) - (1,972,020 83) Disbursements - accounts payable (1,355,569,70) (394,810.73) (463.877,40) (1,034,683.65) .....(Z62,043 49) (4,010,984-97) (114.741.66) (37,056.02) (4,162,782.65) Ending balance 9,957,236.56 4.005,506,64 1,805,471 24 17,317,222.52 5.921.158 81 10,503.015.26 49,509,611.03 3,320_45R21 1,425,293.00 54,255.363 24 INVESTMENTS Certificates of deposit 2,245,600-00 2,245,600.00 - 2,245,600.00 Wells Fargo investments 43,907,492-11 - 43,907.492,11 Mutual fund investments 65,990,051.95 - 66,990,051.95 Total investments 2,245,60000 2,245.600. 00 109,897,544-06 - 112143,144,06 TOTAL CASH AND INVESTMENTS $ 9,957,236.56 $ 4,005,506.64 $ 1,805,471.24 $ 19,562,822.52 $ 5,921,158.81 $ 10,503,015.26 $ 51,755.211.03 $113,218,003.27 $ 1.425,293.00 $166,398,507.30 * Assets are restricted in purpose and do not represent discretionary assets of the government VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of September 30, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS Maturity Purchase Financial Investment CUSIP/ Interest Market Date Date Institution1 - cri Ilir FDIC # Rate % Value FLOOD CONTROL CONSTRUCTION FUND (024) 10/20/14 01/21/14 Bank Leumi USA, NY Certificate of Deposit 19842 0.150% 249,700.00 10/20/14 01/21/14 Cole Taylor Bank (N), IL Certificate of Deposit 22599 0.200% 249,600.00 10/20/14 01/21/14 IDB Bank, NY Certificate of Deposit 19977 0.151% 249,700.00 10/20/14 01/21/14 Republic Bank of Chicago, IL Certificate of Deposit 19333 0.150% 249,700.00 11/18/14 01/21/14 Bank of China, NY Certificate of Deposit 33653 0.207% 249,200.00 11/18/14 01/21/14 Bank of Houston, TX Certificate of Deposit 57965 0.150% 249,600.00 11/18/14 01/21/14 State Bank of India, NY Certificate of Deposit 33682 0.159% 249,600.00 12/18/14 01/21/14 Far East National Bank, CA Certificate of Deposit 21851 0.350% 249,200.00 12/18/14 01/21/14 Onewest Bank FSB, CA Certificate of Deposit 58978 0.300% 2+1rQ1;)0.00 2j.�„600.00 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS $ 2,245,600.00 TRUST AND AGENCY FUNDS Maturity Purchase Financial Investment CUSIP/ Interest Market Date Date Institution Description Acct # Rate % Value POLICE PENSION FUND (070) Various Various Wells Fargo Wells Fargo Investments Various Various $ 22,880,733.10 Various Various Various Mutual Fund Investments Various Various X2,567„567 63;? 56 55,448,365.66 FIRE PENSION FUND (071) Various Various Wells Fargo Wells Fargo Investments Various Various 21,026,759.01 Various Various Various Mutual Fund Investments Various Various 33,422,419.39 54,449,178.40 TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 109,897,544.06 * Assets are restricted in purpose and do not represent discretionary assets of the government 3 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES September 01— September 30, 2014 Through 09/30/1 Summary • Account Classification Adopted Budget Budget Amendments Amended Budget Current Month Transactions YTD Encumbrances YTD Transactions Budget - YTD % used/ Transactions Rec'd Prior Year YTD Fund 001 - General Fund REVENUE Property Taxes 14,674,466.00 .00 14,674,466.00 183,438.96 .00 14,358,645.87 315,820.13 98 12,533,085.03 Other Taxes 8,241,500.00 .00 8,241,500.00 656,683.66 .00 4,807,368.04 3,434,131.96 58 4,480,858.84 Licenses, Permits & Fees 1,621,000.00 .00 1,621,000.00 327,462.08 .00 1,459,849.89 161,150.11 90 2,483,581.54 Intergovernmental Revenue 18,083,100.00 .00 18,083,100.00 1,779,027.78 .00 10,831,872.33 7,251,227.67 60 9,744,675.56 Charges For Services 1,516,000.00 .00 1,516,000.00 154,189.53 .00 1,135,628.41 380,371.59 75 1,077,344.16 Fines & Forfeits 491,000.00 .00 491,000.00 31,959.28 .00 342,398.05 148,601.95 70 387,361.87 Investment Income 22,500.00 .00 22,500.00 359.62 .00 3,436.26 19,063.74 15 10,012.78 Reimbursements 226,000.00 .00 226,000.00 7,904.13 .00 289,992.38 (63,992.38) 128 165,543.78 Other Revenue 918,500.00 .00 918,500.00 16,928.24 .00 221,182.02 697,317.98 24 210,101.01 Other Financing Sources 20,000.00 .00 20,000.00 20,000.00 .00 20,000.00 .00 100 36,865.05 REVENUE TOTALS $45,814,066.00 $0.00 $45,814,066.00 $3,177,953.28 $0.00 $33,470,373.25 $12.343,692.75 73% $31,129,429.62 Fund 001- General Fund Totals $45,814,066.00 $0.00 $45,814,066.00 $3,177,953.28 $0.00 $33,470,373.25 $12,343,692,75 $31,129,429.62 r N Account Classification Fund 002 - Debt Service Fund REVENUE Property Taxes Other Taxes Intergovernmental Revenue Investment Income Other Financing Sources :114TIZI I• Dt;lq 1! ThroughRepo 09/30/1 Prior Fiscal Year Activity Includ_ Summary Listi r Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 2,237,000.00 .00 2,237,000.00 27,116.77 .00 2,200,296.82 36,703.18 98 1,719,599.31 1,056,532.00 .00 1,056,532.00 99,540.37 .00 497,240.62 559,291.38 47 324,570.96 43,005.00 .00 43,005.00 .00 .00 21,927.64 21,077.36 51 21,573.21 400.00 .00 400.00 11.30 .00 51.70 348.30 13 102.60 .00 .00 .00 .00 .00 3,231.19 (3,231.19) +++ .00 REVENUE TOTALS $3,336,937.00 $0.00 $3,336,937.00 $126,668.44 $0.00 $2,722,747.97 $614,189.03 82% $2,065,846.08 Fund 002 - Debt Service Fund Totals $3,336,937.00 $0.00 $3,336,937.00 $126,668.44 $0.00 $2,722,747.97 $61449.03 $2,065,846.08 Account Classification Fund 020 - Capital Improvement Fund REVENUE Repoit Through 09/30/14 Prior Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Taxes 1,246,000.00 .00 1,246,000.00 117,390.96 .00 586,410.81 659,589.19 47 558,846.54 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 ... 91,171.05 Investment Income 1,000.00 .00 1,000.00 35.49 .00 397.82 602.18 40 484.69 Reimbursements .00 ,00 .00 .00 .00 .00 .00 +++ .00 Other Revenue 10,000.00 .00 10,000.00 .00 .00 140,181.00 (130,181.00) 1402 307,233.00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $1,257,000.00 $0.00 $1,257,000.00 $117,426.45 $0.00 $726,989.63 $530,010.37 58% $957,735.28 Fund 020 - Capital Improvement Fund Totals $1,257,000.00 $0.00 $1,257,000.00 $117,426.45 $0.00 $726,989.63 $530,010.37 $957,735.28 W 0. Revenue Budget by Account Classification Repoit Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 021 - Series 2009 Construction Fund REVENUE Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Investment Income .00 .00 .00 .00 .00 .00 .00 +++ 7.84 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++ $7.84 Fund 021 - Series 2009 Construction Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.84 Account Classification Fund 022 - Downtown Redevelopment Construct REVENUE Property Taxes Investment Income Reimbursements Other Revenue Other Financing Sources REVENUE TOTALS Fund 022 - Downtown Redevelopment Construct Totals Ln !ntevenue Budget by Account Classification Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD 2,671,000.00 .00 2,671,000.00 32,064.52 .00 2,268,202.36 402,797.64 85 2,407,858.30 1,000.00 .00 1,000.00 31.32 .00 263.31 736..69 26 473.49 .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 $2,672,000.00 90.00 $2,672,000.00 $32,095.84 $0.00 $2,268,465.67 $403,534.33 85% $2,408,331.79 $2,672,000.00 $0.00 $2,672,000.00 $32,095.84 $0.00 $2,268,465.67 $403,534.33 $2,408,331.79 ON ' : a;- M, U9111 Repo Through 09/30/1 '�-'rior Fiscal Year Activity Summary s Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 023 - Street Improvement Construc Fund REVENUE Other Taxes 2,057,000.00 .00 2,057,000.00 185,819.46 .00 1,100,365.98 956,634.02 53 847,151.93 Licenses, Permits & Fees 1,045,000.00 .00 1,045,000.00 15,702.75 .00 995,261.52 49,738.48 95 .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 +++ 3,611.52 Fines & Forfeits .00 .00 .00 117,500.00 .00 117,500.00 (117,500.00) +++ .00 Investment Income 100.00 .00 100.00 185.03 00 3,977.36 (3,877.36) 3977 68.27 Reimbursements .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Revenue 6,000.00 .00 6,000.00 8,734.00 .00 79,327.83 (73,327.83) 1322 11,726.29 Other Financing Sources 6,500,000.00 .00 6,500,000.00 .00 .00 6,540,700.82 (40,700.82) 101 .00 REVENUE TOTALS $9,608,100.00 $0.00 $9,608,100.00 $327,941.24 $0.00 $8,837,133.51 $770,966.49 92% $862,558.01 Fund 023 - Street Improvement Construc Fund Totals $9,608,100.00 $0.00 $9,608,100.00 $327,941.24 $0.00 $8,837,133.51 $770,966.49 $862,558.01 L:V.ITP4 I -BM= a NFrMMnq11T Adopted Budget Account Classification Budget Amendments Fund 024 - Flood Control Construction Fund REVENUE Through 09/30/ :' Priord_� Summary r Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD Other Taxes 289,468,00 .00 289,468.00 27,272.01 .00 136,233.68 153,234,32 47 283,513.14 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Charges For Services .00 .00 .00 .00 .00 ,00 .00 +++ .00 Investment Income 500.00 .00 500.00 982,80 .00 9,616.00 (9,116.00) 1923 3,438.86 Reimbursements ,00 .00 .00 00 .00 .00 .00 +++ 83,093.35 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ 9,741,700.46 REVENUE TOTALS $289,968.00 $0.00 $289,968.00 $28,254.81 $0.00 $145,849.68 $144,118.32 50% $10,111,745.81 Fund 024 - Flood Control Construction Fund Totals $289,968.00 $0.00 $289,968.00 $28,254.81 $0.00 $145,849.68 $144,118.32 $10,111,745.81 v w Account Classification Fund 040 - Refuse Disposal Fund REVENUE Repo Through 09/30/1 Prior•-• •: Summary Listin Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Property Taxes 342,000.00 .00 342,000.00 10,589.01 .00 338,321.95 3,678.05 99 1,831,199.43 Charges For Services 2,900,000.00 .00 2,900,000.00 327,057.99 .00 2,180,386.20 719,613.80 75 1,594,897.04 Fines & Forfeits 25,000.00 ,00 25,000.00 1,413.07 .00 20,125.17 4,874.83 81 13,969.93 Investment Income 500.00 .00 500.00 39.08 .00 489.87 10.13 98 326.67 Reimbursements .00 .00 .00 147.48 .00 442.44 (442.44) ... 578.36 Other Revenue 359,000.00 .00 359,000.00 34,232.90 .00 265,399.34 93,600.66 74 268,537.12 REVENUE TOTALS $3,626,500.00 $0.00 $3,626,500.00 $373,479.53 $0.00 $2,805,164.97 $821,335.03 77% $3,709,508.55 Fund 040 - Refuse Disposal Fund Totals $3,626,500.00 $0.00 $3,626,500.00 $373,479.53 $0.00 $2,805,164.97 $821,335.03 $3,709,508.55 Account Classification Fund 041 - Motor Fuel Tax Fund REVENUE Repor,111 Through 09/30/1 or Fiscal Year Activity Includea Summary Listirlm Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Intergovernmental Revenue 1,290,000.00 .00 1,290,000.00 80,256.65 .00 1,348,577.94 (58,577.94) 105 877,269.41 Investment Income 100.00 .00 100.00 5.92 .00 27.38 72.62 27 101.31 Reimbursements 6,000.00 .00 6,000.00 .00 .00 11,704.04 (5,704.04) 195 6,372.12 REVENUE TOTALS $1,296,100.00 $0.00 $1,296,100.00 $80,262.57 $0.00 $1,360,309.36 ($64,209.36) 105% $883,742.84 Fund 041 - Motor Fuel Tax Fund Totals $1,296,100.0 i $0.00 $1,296,100.00 $80,262.57 $0.00 $1,360,309,36 ($64,209.36) $883,742.84 ;F� O Account Classification Fund 042 - Cmmty Development Block Grant REVENUE Intergovernmental Revenue Investment Income Other Revenue Revenue Budget by Account Classcation R F-,epo l I Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 293,202.00 97,171.00 390,373.00 31,605.50 .00 52,998.37 337,374.63 14 96,331.59 '00 .00 .00 .00 .00 .00 .00 +++ .00 60,000.00 .00 60,000.00 23,959.00 .00 152,817.12 (92,817.12) 255 99,906.18 REVENUE TOTALS $353,202.00 $97,171.00 $450,373.00 $55,564.50 $0.00 $205,815.49 $244,557.51 46% $196,237.77 Fund 042 - Cmmty Development Block Grant Totals $353,202.00 $97,171.00 $450,373.00 $55,564.50 $0.00 $205,815.49 $244,557.51 $196,237.77 Account Classification Fund 043 - Asset Seizure Fund REVENUE Fines & Forfeits Investment Income r H Wo If5mill !1414111 Repoit Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 2,000.00 .00 2,000.00 .00 .00 43,321.06 (41,321.06) 2166 14,726.02 100.00 .00 100.00 1.22 .00 11.17 88.83 11 7.23 REVENUE TOTALS $2,100.00 $0.00 $2,100.00 $1.22 $0.00 $43,332.23 ($41,232.23) 2063% $14,733.25 Fund 043 - Asset Seizure Fund Totals $2,100.00 $0.00 $2,100.00 $1.22 $0.00 $43,332.23 ($41,232.23) $14,733.25 Account Classification Fund 044 - DEA St REVENUE Fines & Forfeits Investment Income levenue IrJ Budget by Account Classification R e p o -FILL, Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 100.00 .00 100.00 .00 .00 24,637.80 (24,537.80) 24638 .00 100.00 .00 100.00 1.48 .00 15.20 84.80 15 7.70 REVENUE TOTALS $200.00 $0.00 $200.00 $1.48 $0.00 $24,653.00 ($24,453.00) 12326% $7.70 Fund 044 - DEA Shared Funds Fund Totals $200.00 $0.00 $200.00 $1.48 $0.00 $24,653.00 ($24,453.00) $7.70 Account Classification Fund 045 - DUI Fine Fund REVENUE Fines & Forfeits Investment Income r W Repoft Through 09/30/14 Priorde Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD 20,000.00 .00 20,000.00 .00 .00 22,224.22 (2,224.22) 111 25,873.82 100.00 X0 100.00 2.10 .00 29.79 70.21 30 .00 REVENUE TOTALS $20,100.00 $0.00 $20,100.00 $2.10 $0.00 $22,254.01 ($2,154.01) 111% $25,873.82 Fund 045 - DUI Fine Fund Totals $20,100.00 $0.00 $20,100.00 $2.10 $0.00 $22,254.01 ($2,154.01) $25,873.82 F1 A Account Classification Fund 046 - Foreign Fire Tax Board Fund REVENUE 1:C--1TfA ill 14;115Ms- 437,1-ozel,• Repo Through 09/30/1 Prior Fiscal Year Activikn Indxd- Summary Listin Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Taxes 70,000.00 .00 70,000.00 9,664.12 .00 63,264.64 6,735.36 90 63,227.46 Investment Income 1,000.00 .00 1,000.00 6.33 .00 83.36 916.64 8 .08 Other Revenue .00 .00 ,00 .00 .00 .00 .00 ... 45.00 Other Financing Sources .00 .00 .00 X0 .00 .00 .00 +++ .00 REVENUE TOTALS $71,000.00 $0.00 $71,000.00 $9,670.45 $0.00 $63,348.00 $7,652.00 89% $63,272.54 Fund 046 - Foreign Fire Tax Board Fund Totals $71,000.00 $0.00 $71,000.00 $9,670.45 $0.00 $63,348.00 $7,652.00 $63,272.54 Account Classification Fund 047 -3usticeAssistance Grant Fund -'ZevenueBudget Account Repo Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD REVENUE Intergovernmental Revenue ,00 .00 .00 .00 ,00 .00 .00 ... .00 Investment Income .00 .00 .00 .00 ,00 .00 .00 +++ .00 REVENUE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++ $0.00 Fund 047 - Justice Assistance Grant Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 r U1 F - 4M Account Classification Fund 048 - Business District Fund REVENUE I —-, 4 T41614 I I M tiq F= VRI r Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances ;L1 Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Other Taxes 943,000.00 .00 943,000.00 92,795.81 .00 601,995.78 341,004.22 64 579,695.19 Investment Income 100.00 .00 100.00 2.71 .00 23.76 76.24 24 65.14 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $943,100.00 $0.00 $943,100.00 $92,798.52 $0.00 $602,019.54 $341,080.46 64% $579,760.33 Fund 043 - Business District Fund Totals $943,100.00 $0.00 $943,100.00 $92,798.52 $0.00 $602,019.54 $341,080.46 $579,760.33 Account Classification Fund 050 - Water and Sewer Fund REVENUE Repoit Through 09/30/14 Prior FiscalYear Activityi ;.; Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Property Taxes 1,530,000.00 .00 1,530,000.00 19,568.59 .00 1,493,886.04 36,113.96 98 1,496,261.07 Licenses, Permits & Fees 17,000.00 .00 17,000.00 1,610.00 .00 13,690.00 3,310.00 81 13,490.00 Charges For Services 12,711,000.00 .00 12,711,000.00 1,156,548.45 .00 8,842,183.07 3,868,816.93 70 8,484,842.22 Fines & Forfeits 100,000.00 .00 100,000.00 8,503.74 .00 82,996.41 17,003.59 83 89,657.98 Investment Income 1,100.00 .00 1,100.00 109.50 .00 1,264.75 (164.75) 115 653.34 Reimbursements 1,000.00 .00 1,000.00 .00 .00 (131.00) 1,131.00 -13 9,572.52 Other Revenue 25,000.00 .00 25,000.00 7,526.64 .00 48,803.80 (23,803.80) 195 34,230.97 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $14,385,100.00 $0.00 $14,385,100.00 $1,193,866.92 $0.00 $10,482,693.07 $3,902,406.93 73% $10,128,708.10 Fund 050 - Water and Sewer Fund Totals $14,385,100.00 $0.00 $14,385,100.00 $1,193,866.92 $0.00 $10,482,693,07 53,902,406.93 $10,128,708.10 I-- 00 00 Account Classification Fund 051 - Village Parking System Fund REVENUE Other Taxes Charges For Services Investment Income Other Revenue Other Financing Sources REVENUE TOTALS Fund 051 - Village Parking System Fund Totals ClassificationRevenue Budget by Account Report Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD 10,000.00 .00 10,000.00 942.14 .00 4,706.35 5,293.65 47 4,923.77 115,000.00 .00 115,000.00 10,103.55 .00 97,070.87 17,929.13 84 90,137.79 100.00 .00 100.00 6.29 .00 71.03 28.97 71 18.48 6,600.00 .00 6,600.00 550.00 00 4,950.00 1,650.00 75 4,950.00 .00 .00 .00 .00 .00 .00 .00 +++ .00 $131,700.00 $0.00 $131,700.00 $11,601.98 $0.00 $106,798.25 $24,901.75 81% $100,030.04 $131,700.00 $0.00 $131,700.00 $11,601.98 $0.00 $106,798.25 $24,901.75 $100,030.04 Account Classification Fund 052 Parking System Revenue Fund Repoit Through 09/30/14 Prior Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD REVENUE Other Taxes 90,000.00 .00 90,000.00 8,479.28 .00 42,357.13 47,642.87 47 44,313.82 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 +++ AO Charges For Services 112,000.00 .00 112,000.00 9,854.65 .00 88,176.27 23,823.73 79 82,130.10 Investment Income 100.00 .00 100.00 .00 .00 .00 100.00 0 1.62 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ ,00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $202,10000 $0.00 $202,100.00 $18,333.93 $0.00 $130,533.40 $71,566.60 65% $126,445.54 Fund 052 - Parking System Revenue Fund Totals $202,100.00 $0.00 $202,100.00 $18,333.93 $0.00 $130,533.40 $71,566.60 $126,445.54 N O Account Classification Fund 060 - Vehicle Maintenance Fund REVENUE Repo Through 09/30/1 ILI• +, � Summary Listi Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Charges For Services 2,138,317.00 .00 2,138,317.00 178,193.07 .00 1,603,737.63 534,579.37 75 1,644,984.90 Investment Income .00 .00 .00 46.50 .00 420.33 (420.33) +++ 363.58 Other Revenue .00 .00 .00 .00 .00 525.88 (525.88) +++ 138.40 REVENUE TOTALS $2,138,317.00 $0.00 $2,138,317.00 $178,239.57 $0.00 $1,604,683.84 $533,633.16 75% $1,645,486.88 Fund 060 - Vehicle Maintenance Fund Totals $2,138,317.00 $0.00 $2,138,317,00 $178,239.57 $0.00 $1,604,683.84 $533,633.16 $1,645,486.88 Account Classification Fund 061- Vehicle Replacement REVENUE Repoit Through09/30/14 Prior Fiscal Year Activity Included ListingSummary Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Charges For Services 1,346,300.00 .00 1,346,300.00 112,191.68 .00 1,009,725.12 336,574.88 75 1,047,450.06 Fines & Forfeits 10,000.00 .00 10,000.00 .00 .00 8,997.72 1,002.28 90 10,325.72 Investment Income 5,000.00 .00 5,000.00 545.11 .00 5,239.03 (239.03) 105 3,982.69 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Financing Sources 60,000.00 .00 60,000.00 11,919.88 .00 54,253.75 5,746.25 90 87,929.54 REVENUE TOTALS $1,421,300.00 $0.00 $1,421,300.00 $124,656.67 $0.00 $1,078,215.62 $343,084.38 76% $1,149,688.01 Fund 061 - Vehicle Replacement Fund Totals $1,421,300.00 $0.00 $1,421,300.00 $124,656.67 $0.00 $1,078,215.62 $343,084.38 $1,149,688.01 N r Account Classification Fund 062 - Computer Replacement Fund REVENUE Repo Through 09/30/1 f Prior Fiscal Year Activity Includ Summary Listi Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Charges For Services 23,088.00 .00 23,088.00 1,924.00 .00 17,316.00 5,772.00 75 .00 Investment Income 1,000.00 .00 1,000.00 64.39 .00 562.23 437.77 56 517.92 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $24,088.00 $0.00 $24,088.00 $1,988.39 $0.00 $17,878.23 $6,209.77 74% $517.92 Fund 062 - Computer Replacement Fund Totals $24,088.00 $0.00 $24,088.00 $1,988.39 $0.00 $17,878.23 $6,209.77 $517.92 Account Classification Fund 063 - Risk Management Fund REVENUE Charges For Services Investment Income Reimbursements Other Revenue REVENUE TOTALS Fund 063 - Risk Management Fund Totals N W Accountevenue Budget by • Repor-mi Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 6,456,273.00 .00 6,456,273.00 534,422.83 .00 4,859,102.11 1,597,170.89 75 4,554,265.24 2,000.00 .00 2,000.00 192.05 .00 1,709.73 290.27 85 1,256.34 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 1,357,600.00 .00 1,357,600.00 94,336.41 .00 983,335.62 374,264.38 72 963,341.60 $7,816,873.00 $0.00 $7,816,873.00 $628,951.29 $0.00 $5,844,147.46 $1x972,725.54 75% $5,518,863.18 $7,816,873.00 $0.00 $7,816,873.00 $628,951.29 $0.00 $5,844,147.46 $1,972,725.54 $5,518,863.18 N P Account Classification levenue Budget by Account Classification Repo -"-'L Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 070 - Police Pension Fund REVENUE Charges For Services .00 .00 .00 .00 .00 .00 .00 ... .00 Investment Income 3,415,900.00 .00 3,415,900.00 (984,132.07) .00 2,083,364.88 1,332,535.12 61 4,391,360.74 Other Revenue 3,742,224.00 .00 3,742,224.00 97,240.64 .00 3,451,996.47 290,227.53 92 3,174,552.01 REVENUE TOTALS $7,158,124.00 $0.00 $7,158,124.00 ($886,891.43) $0.00 $5,535,361.35 $1,622,762.65 77% $7,565,912.75 Fund 070 - Police Pension Fund Totals $7,158,124.00 $0.00 $7,158,124.00 ($886,891.43) $0.00 $5,535,361.35 $1,622,762.65 $7,565,912.75 Account Classification Fund 071- Fire Pension Fund REVENUE Investment Income Other Revenue N Ul Revenue Budget by Account Classification Report Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 3,165,200.00 .00 3,165,200.00 (273,609.38) .00 2,346,127.70 819,072.30 74 4,870,121.23 3,079,042.00 .00 3,079,042.00 80,688.54 .00 2,868,193.18 210,848.82 93 2,766,373.15 REVENUE TOTALS $6,244,242.00 $0.00 $6,244,242.00 ($192,920.84) $0.00 55,214,320.88 91,029,921.12 84% $7,636,494.38 Fund 071 - Fire Pension Fund Totals $6,244,242.00 $0.00 $6,244,242.00 ($192,920.84) $0.00 $5,214,320.88 $1,029,921.12 $7,636,494.38 Grand Totals $108,812,217.00 $97,171.00 $108,909,388.00 $5,499,946.91 $0.00 $83,313,088.41 $25,596,299.59 $86,880,938.03 Account Classification Fund 001 - General Fund EXPENSE Personal Services, Scheduled Salaries & Wages Employee Benefits Other Employee Costs Pension Benefits Contractual Services Utilities Insurance Commodities & Supplies Other Expenditures Building Improvements Office Equipment Other Equipment Distribution Systems Infrastructure Interfund Transfers I.- Fund �f ! . 14 ll ;: Repott Through 09/30/14 PriorFiscal .a Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 23,919,744.00 00 23,919,744.00 1,848,898.77 .00 17,390,031.93 6,529,712.07 73 16,776,450.71 12,344,314.00 .00 12,344,314.00 654,983.84 .00 10,697,028.06 1,647,285.94 87 9,936,534.72 415,005.00 (3,275.00) 411,730.00 19,993.41 10,703.33 234,398.77 166,627.90 60 203,033.31 46,301.00 .00 46,301.00 3,858.36 .00 34,725.24 11,575.76 75 34,612.29 7,001,321.00 135,233.68 7,136,554.68 565,894.10 365,220.41 5,400,847.31 1,370,486.96 81 5,269,643.60 262,282.00 .00 262,282.00 13,245.63 .00 128,338.66 133,943.34 49 105,649.02 350,519.00 .00 350,519.00 29,201.63 .00 262,901.76 87,617.24 75 258,858.05 627,855.00 61,600.00 689,455.00 38,389.72 69,565.67 390,229.98 229,659.35 67 334,998.96 11,080.00 .00 11,080.00 31,322.95 .00 53,696.48 (42,616.48) 485 .00 10,000.00 .00 10,000.00 727.95 3,788.40 2,509.85 3,701.75 63 9,761.57 49,730.00 .00 49,730.00 .00 11,156.18 7,606.36 30,967.46 38 11,123.91 165,123.00 4,689.32 169,812.32 8,860.19 34,254.75 103,718.66 31,838.91 81 50,917.17 100,000.00 .00 100,000.00 .00 71,448.52 .00 28,551.48 71 .00 510,792.00 3,400.00 514,192.00 4,779.70 137,339.52 258,434.64 118,417.84 77 278,644.79 .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $45,814,066.00 $201,648.00 $46,015,714.00 $3,220,156.25 $703,476278 $34,964,467.70 $10,347,769.52 78% $33,270,228.10 001 - General Fund Totals $45,814,066.00 $201,648.00 $46,015,714.00 $3,220,156.25 $703,476.78 534,964,467..70 510,347,769.52 $33,270,228.10 Account Classification Fund 002 - Debt Service Fund EXPENSE Contractual Services Other Expenditures Band Principal Interest Expense Bank & Fiscal Fees Interfund Transfers Other Financing Uses Repo Through 1' 1i • - �;-� Summary Listi a Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 1,532,587.00 .00 1,532,587.00 .00 .00 270,780.49 1,261,806.51 18 300,743.18 1,793,429.00 .00 1,793,429.00 .00 .00 766,300.74 1,027,128.26 43 458,670.67 2,484.00 .00 2,484.00 ,00 .00 1,686.20 797.80 68 428.00 .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $3,328,500.00 $0.00 $3,328,500.00 $0.00 $0.00 $1,038,767.43 $2,289,732.57 31% $759,841.85 Fund 002 - Debt Service Fund Totals $3,328,500.00 $0.00 $3,328,500.00 $0.00 $0.00 $1,038,767.43 $2,289,732.57 $759,841.85 Account Classification Fund 020 - Capital Improvement Fund EXPENSE Report Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Contractual Services .00 .00 .00 .00 .00 .00 .00 +++ 22,132.60 Other Expenditures .00 .00 .00 .00 .00 .00 ,00 +++ .00 Land Improvements 240,000.00 .00 240,000.00 .00 .00 00 240,000.00 0 .00 Building Improvements 637,000.00 73,600.00 710,600.00 100,971.65 80,921.38 266,876.54 362,802.08 49 640,967.83 Office Equipment .00 .00 .00 .00 .00 .00 .00 +++ .00 Motor Equipment .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Equipment 304,247.00 16,600,.00 320,847.00 12,428.91 33,000.00 182,404.15 105,442.85 67 276,792.89 Infrastructure 515,000.00 104,400.00 619,400.00 (452.90) 14,333.76 28,696.23 576,370.01 7 218,989.39 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $1,696,247.00 $194,600.00 $1,890,847.00 $112,947.66 $128,255.14 $477,976.92 $1,284,614.94 32% $1,158,882.71 Fund 020 - Capital Improvement Fund Totals $1,696,247.00 $194,600.00 $1,890,847.00 $112,947.66 $128,255.14 $477,976.92 $1,284,614.94 $1,158,882.71 W lr� Account Classification Fund 021 - Series 2009 Construction Fund EXPENSE Expense Budget by Account Classification Repo Through t• • Fiscal Year Activity Includ is Summary List�jine Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services .00 .00 .00 .00 .00 .00 .00 ... .00 Building Improvements .00 .00 <00 .00 .00 ,00 .00 +++ .00 Office Equipment .00 .00 '00 .00 .00 .00 .00 +++ .00 Other Equipment .00 .00 .00 .00 .00 00 ,00 +++ .00 Interfund Transfers .00 .00 .00 .00 ,00 .00 .00 +++ 36,865,05 EXPENSE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++ $36,865.05 Fund 021 - Series 2009 Construction Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $36,865.05 iz. 4 9 T:JZ3=alsl� M M161 F-T-MiTaq M 11 Adopted Budget Account Classification Budget Amendments Fund 022 - Downtown Redevelopment Construct EXPENSE Repoit Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services 203,040.00 .00 203,040.00 75,000.00 72,988.73 132,201.90 (2,150.63) 101 152,566.48 Utilities .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Expenditures 2,803,922.00 60,000.00 2,863,922.00 .00 .00 83,223.00 2,780,699.00 3 52,265.36 Infrastructure 115,000.00 240,000.00 355,000.00 .00 3,804.00 16,775.75 334,420.25 6 21,670.31 Bond Principal .00 .00 .00 .00 .00 .00 .00 +++ .00 Interest Expense .00 .00 .00 .00 .00 .00 .00 +++ .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $3,121,962.00 $300,000.00 $3,421,962.00 $75,000.00 $76,792.73 $232,200.65 $3,112,968.62 9% $226,502.15 Fund 022 -Downtown Redevelopment Construct Totals $3,121,962.00 $300,000.00 $3,421,962.00 $75,000.00 $76,792.73 $232,200.65 $3,112,968.62 $226,502.15 Ln RAI Account Classification Fund 023 - Street Improvement Construc Fund EXPENSE Repo Through 09/30/1�' Prior -,a i' Summary s Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Contractual Services 30,600.00 41,000.00 71,600.00 1,631.41 26,372.66 44,925.16 302.18 100 9,277.00 Infrastructure 9,943,280.00 .00 9,943,280.00 232,669.75 2,448,474.03 6,768,097.06 726,708.91 93 601,640.84 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $9,973,880.00 $41,000.00 $10,014,880.00 $234,301.16 $2,474,846.69 $6,813,022.22 $727,011.09 93% $610,917.84 Fund 023 - Street Improvement Construc Fund Totals $9,973,880.00 $41,000.00 $10,014,880.00 $234,301.16 $2,474,846.69 $6,813,022.22 $727,011.09 $610,917.84 Account Classification Fund 024 - Flood Control Constructiton Fund EXPENSE 4A 11 Zlj I:< ira r4 FT-Mimn e Repoit Through 09/30/14 Prior Fiscal Year Activity Included Summary tI Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Contractual Services .00 .00 .00 .00 .00 .00 .00 +++ .00 Utilities 1,000.00 .00 1,000.00 .00 .00 915.87 84.13 92 .00 Commodities & Supplies .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Expenditures 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 2,000.00 Other Equipment .00 .00 <00 .00 00 .00 .00 ... .00 Infrastructure 10,805,000.00 83,800.00 10,888,800.00 54,138.53 143,855.17 377,319.01 10,367,625.82 5 761,982.90 EXPENSE TOTALS $10,811,000.00 $83,800.00 $10,894,800.00 $54,138.53 $143,855.17 $378,234.88 $10,372,709.95 5% $763,982.90 Fund 024 - Flood Control Construction Fund Totals $10,811,000.00 $83,800.00 $10,894,800.00 $54,138.53 $143,855.17 $378,234.88 $10,372,709.95 $763,982.90 EE Account Classification Fund 040 - Refuse Disposal Fund EXPENSE Personal Services, Scheduled Salaries &Wages Employee Benefits Other Employee Costs Contractual Services Utilities Insurance Commodities & Supplies Fxpense Budget by Account Classification Repor) Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 231,735.00 .00 231,735.00 19,487.38 75,057.00 .00 75,057.00 8,808.96 1,224.00 ,00 1,224.00 .00 4,157,884.00 (5,600.00) 4,152,284.00 345,357.40 438.00 '00 438.00 22.22 28,640.00 .00 28,640.00 2,386.67 31,295.00 5,600.00 36,895.00 12,361.68 .00 181,890.25 49,844.75 78 138,871.40 .00 80,773.11 (5,716.11) 108 73,533.45 .00 1,224.00 .00 100 1,200.00 12,412.15 2,916,684.61 1,223,187.24 71 2,879,624.94 .00 212.79 225.21 49 212.95 .00 21,480.03 7,159.97 75 21,179.25 8,330.96 25,878.92 2,685.12 93 19,941.56 EXPENSE TOTALS $4,526,273.00 $0.00 $4,526,273.00 $388,424.31 $20,743.11 $3,228,143.71 $1,277,386.18 72% $3,134,563.55 Fund 040 - Refuse Disposal Fund Totals $4,526,273.00 $0.00 $4,526,273.00 $388,424.31 $20,743.11 $3,228,143.71 $1,277,386.18 $3,134,563.55 Account Classification Fund 041 - Motor Fuel Tax Fund EXPENSE Contractual Services Utilities Commodities & Supplies Building Improvements Infrastructure w r • UN ralool I I • Report Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD 204,104.00 75,000.00 279,104.00 6,752.56 17,279.83 194,432.42 67,391.75 76 151,844.43 153,000.00 .00 153,000.00 27,252.01 .00 134,920.76 18,079.24 88 109,832.45 284,796.00 .00 284,796.00 .00 52,957.48 231,459.75 378.77 100 147,195.10 .00 .00 .00 .00 .00 .00 .00 +++ .00 910,000.00 5,000.00 915,000.00 .00 .00 10,056.62 904,943.38 1 1,115,000.00 EXPENSE TOTALS $1,551,900.00 $80,00.00 $1,631,900.00 $34,004.57 $70,237.31 $570,869.55 $990,793.14 39% $1,523,871.98 Fund 041 - Motor Fuel Tax Fund Totals $1,551,900.00 $80,000.00 $1,631,900.00 $34,004.57 $70,237.31 $570,869.55 $990,793.14 $1,523,871.98 r 0 Account Classification Fund 042 - Cmmty Development Block Grant EXPENSE 4:49.1gi-TTEMP 9:7, i i ThroughRepo 09/30/1. Prior -� Summary a Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Personal Services, Scheduled Salaries & Wages 47,930.00 .00 47,930.00 3,279.15 .00 35,062.53 12,867.47 73 33,925.46 Employee Benefits 26,222.00 .00 26,222.00 2,073.39 .00 19,239.09 6,982.91 73 18,442.56 Other Employee Costs 1,020.00 .00 1,020.00 26.62 .00 178.32 841.68 17 745.50 Contractual Services 97,520.00 23,250.00 120,770.00 3,500.76 .00 70,272.95 50,497.05 58 31,483.55 Commodities & Supplies 510.00 .00 510.00 .00 .00 .00 510.00 0 111.37 Other Expenditures 160,000.00 73,921.00 233,921.00 9,614.00 .00 12,844.00 221,077.00 5 130,214.56 Land Improvements .00 00 .00 .00 .00 .00 .00 +++ .00 Building Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 Infrastructure 20,000.00 _00 20,000.00 .00 70,000.00 .00 (50,000.00) 350 .00 EXPENSE TOTALS $353,202.00 $97,171.00 $450,373.00 $18,493.92 $70,000.00 $137,596.89 $242,776.11 46% $214,923.00 Fund 042 - Cmmty Development Block Grant Totals $353,202.00 $97,171.00 $450,373.00 $18,493.92 $70,000.00 $137,596.89 $242,776.11 $214,923.00 Account Classification Fund 043 - Asset Seizure Fund EXPENSE Other Employee Costs Contractual Services Other Equipment r F1 4AIN 1 1�-1 I ". 11P no =11419191, 1 40 11 lmri Repoit • 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 3,000.00 .00 3,000.00 .00 .00 4,000.00 (1,000.00) 133 2,000.00 15,000.00 .00 15,000.00 .00 .00 1,642.29 13,357.71 11 8,065.28 EXPENSE TOTALS $19,000.00 Mao $19,000.00 $0.00 $0.00 $5,642.29 $13,357.71 30% $10,065.28 Fund 043 - Asset Seizure Fund Totals $19,000.00 $0.00 $19,000.00 $0.00 $0.00 $5,642.29 $13,357.71 $10,065.28 Account Classification Fund 044 - DEA Shared Funds Fund EXPENSE 1 WA 91:4 1 F-TA:11re Repor Through 09/30/1 fj Prior Fiscal Year Activity Includ Summary Listiiine Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services 1,000.00 .00 1,000.00 ,00 .00 .00 1,000.00 0 .00 Building Improvements 00 .00 .00 .00 .00 .00 .00 ... .00 Other Equipment 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 EXPENSE TOTALS $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $0.00 Fund 044 - DEA Shared Funds Fund Totals $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 $0.00 Account Classification Fund 045 - DUI Fine Fund EXPENSE Other Employee Costs Contractual Services Other Equipment Interfund Transfers r LJ EXPENSE TOTALS Fund 045 - DUI Fine Fund Totals PM Mxpense Budget by Account Classification Report Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 00 .00 .00 .00 .00 .00 .00 ... 7,187.50 10,000.00 .00 10,000.00 .00 .00 2,767.30 7,232.70 28 13,629.17 .00 .00 ,00 .00 .00 .00 .00 ... .00 $11,000.00 60.00 $11,000.00 $0.00 $0.00 $2,767.30 $8,232.70 25% $20,816.67 $11,000.00 $0.00 $11,000.00 $0.00 $0.00 $2,767.30 $8,232.70 -$20,816.67 Account Classification Fund 046 - Foreign Fire Tax Board Fund EXPENSE wolgim- i i # ` sMilelFrMyRRIVeli Repo Through09/30/1 '' • Activity Summary Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD Contractual Services 10,000.00 .00 10,000.00 20.67 .00 3,967.27 6,032.73 40 2,998.44 Insurance 500.00 .00 500.00 ,00 .00 .00 500.00 0 .00 Commodities & Supplies 5,000.00 .00 5,000.00 .00 .00 211.65 4,788.35 4 3,032.98 Other Equipment 15,000.00 .00 15,000.00 .00 .00 11,688.00 3,312.00 78 9,077.00 EXPENSE TOTALS $30,500.00 $0.00 $30,500.00 $20.67 $0.00 $15,866.92 $14,633.08 52% $15,108.42 Fund 046 - Foreign Fire Tax Board Fund Totals $30,500.00 $0.00 $30,500.00 $20.67 $0.00 $15,866.92 $14,633.08 $15,108.42 Account Classification Fund 047 -Justice Assistance Grant Fund EXPENSE r ! 11-11011 • Through • , PriorFiscal Year Activityalei ListingSummary Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Commodities & Supplies .00 .00 .00 .00 .00 .00 .00 ... .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 ... .00 Office Equipment .00 .00 .00 .00 .00 .00 .00 ... 836.00 Other Equipment .00 .00 .00 .00 .00 .00 .00 ... 66.66 dnterfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ... $902.66 Fund 047 - Justice Assistance Grant Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $902.66 r U1 I.- (71 rn Account Classification Fund 048 - Business District Fund EXPENSE i 437ii-eliKel, 1 1 . 51 Il Through 09/30/1 . • Year Activity Include � Summary r; Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Bond Principal .00 .00 .00 .00 ,00 .00 .00 +++ .00 Interest Expense 923,100.00 .00 923,100.00 .00 .00 .00 923,100.00 0 637,231.78 EXPENSE TOTALS $923,100.00 $0.00 $923,100.00 $0.00 $0.00 $0.00 $923,100.00 0% $637,231.78 Fund 048 - Business District Fund Totals $923,100.00 $0.00 $923,100.00 $0.00 $0.00 $0.00 $923,100.00 $637,231.78 Account Classification Fund 050 - Water and Sewer Fund EXPENSE Personal Services, Scheduled Salaries & Wages Employee Benefits Other Employee Costs Contractual Services Utilities Insurance Commodities & Supplies Other Expenditures Building Improvements Office Equipment Other Equipment Distribution Systems Infrastructure Bond Principal Interest Expense Interfund Transfers EXPENSE TOTALS Fund 050 - Water and Sewer Fund Totals r ThroughRep t• Prior Fiscal Year d_� Summary o Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD 1,952,664.00 .00 1,952,664.00 137, 516.37 787,893.00 .00 787,893.00 62,062.31 36,660.00 .00 36,660.00 1,824.63 7,457,412.00 32,500.00 7,489,912.00 661,468.33 157,758.00 .00 157,758.00 9,622.90 80,474.00 .00 80,474.00 6,706.16 295,722.00 .00 295,722.00 20,864.10 .00 .00 .00 .00 42,500.00 .00 42,500.00 .00 1,370.00 .00 1,370.00 .00 1,244,200.00 1,563,500.00 2,807,700.00 108,497.83 2,075,000.00 581,500.00 2,656,500.00 172,709.54 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 $14,131,653.00 $2,177,500.00 $16,309,153.00 $1,181,272.17 $14,131,653.00 $2,177,500.00 $16,309,153.00 $1,181,272.17 .00 .00 .00 248,467.36 .00 .00 33,196.90 .00 3,925.00 .00 1,454,346.93 1,441,504.72 .00 .00 .00 .00 $3,181,440.91 $3,181,440.91 1,490,174.03 462,489.97 575,555.58 212,337.42 25,104.01 11,555.99 5,467,659.64 1,773,785.00 89,537.79 68,220.21 60,355.44 20,118.56 125, 724.67 136, 800.43 .00 .00 1,350.00 37,225.00 .00 1,370.00 1,051,255.02 302,098.05 290,640.25 924,355.03 .00 .00 00 .00 .00 .00 .00 .00 $9,177,356.43 $3,950,355.66 $9,177,356.43 $3,950,355.66 76 1,392,996.26 73 574,068.35 68 18,159.00 76 4,900,762.14 57 77,738.88 75 59,537.25 54 139,560.77 +++ .00 12 .00 0 .00 89 112,766.94 65 882,293.92 +++ .00 ... .00 +++ .00 +++ .00 76% $8,157,883.51 $8,157,883.51 Account Classification Fund 051 - Village Parking System Fund EXPENSE 14A fri M4, 410]11 eN i I Repo Ir Through 09/30/1 PM k C� 111111M, !147 Summary Usti g Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 35,788.00 .00 35,788.00 2,609.59 .00 27,203.13 8,584.87 76 18,150.19 Employee Benefits 17,796.00 .00 17,796.00 1,311.83 .00 12,093.06 5,702.94 68 7,561.67 Contractual Services 91,055.00 .00 91,055.00 4,956.89 11,946.87 47,106.78 32,001.35 65 61,467.68 Insurance 1,175.00 .00 1,175.00 97.92 .00 881.28 293.72 75 868.50 Commodities & Supplies 510.00 .00 510.00 .00 .00 170.00 340.00 33 .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 ... .00 Building Improvements 6,936.00 .00 6,936.00 416.21 647.33 2,103.47 4,185.20 40 .00 Infrastructure 153,500.00 .00 153,500.00 9,593.79 10,627.67 36,121.53 106,750.80 30 5,875.00 Interfund Transfers .00 .00 .00 .00 ,00 .00 .00 +++ .00 EXPENSE TOTALS $306,760.00 $0.00 $306,760.00 $18,986.23 $23,221.87 $125,679.25 $157,858.88 49% $93,923.04 Fund 051 - Village Parking System Fund Totals $306,760.00 $0.00 $306,760.00 $18,986.23 $23,221.87 $125,679.25 $157,858.88 $93,923.04 Account Classification Fund 052 - Parking System Revenue Fund EXPENSE Repo Through s i + +Surrin nj - Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 28,598.00 .00 28,598.00 1,924.83 .00 19,797.95 8,800.05 69 28,556.13 Employee Benefits 13,772.00 .00 13,772.00 973.58 .00 8,960.86 4,811.14 65 14,003.62 Contractual Services 110,954.00 .00 110,954.00 10,661.12 13,369,27 63,205.82 34,378.91 69 74,703.67 Utilities 10,523.00 .00 10,523.00 917.94 .00 5,094.39 5,428.61 48 5,159.28 Insurance 1,406.00 .00 1,406.00 117.17 .00 1,054.53 351.47 75 1,040.22 Commodities & Supplies 9,779.00 .00 9,779.00 .00 .00 6,250.56 3,528.44 64 3,308.86 Other Expenditures ,00 .00 .00 .00 .00 .00 .00 +++ .00 Building Improvements 75,000.00 .00 75,000.00 .00 .00 .00 75,000.00 0 .00 Infrastructure .00 .00 ,00 .00 .00 .00 .00 +++ .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $250,032.00 somi $250,032.00 $14,594.64 $13,369.27 $104,364.11 $132,298.62 47% $126,771.78 Fund 052 - Parking System Revenue Fund Totals $250,032.00 $0.00 $250,032.00 $14,594.64 $13,369.27 $104,364.11 $132,298.62 $126,771.78 r �O N O Account Classification Fund 060 - Vehicle Maintenance Fund EXPENSE Repoft Through 09/30/14 P,rior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Personal Services, Scheduled Salaries & Wages 940,529.00 .00 940,529.00 67,362.06 .00 701,144.83 239,384.17 75 661,630.03 Employee Benefits 384,627.00 .00 384,627.00 30,230.42 .00 269,841.68 114,785.32 70 301,057.29 Other Employee Costs 2,361.00 .00 2,361.00 1,046.28 .00 2,136.28 224.72 90 2,021.59 Contractual Services 100,738.00 .00 100,738.00 6,826.02 13,399.73 54,906.71 32,431.56 68 56,903.51 Utilities 3,070.00 .00 3,070.00 200.36 .00 1,792.33 1,277.67 58 2,289.10 Commodities & Supplies 701,081.00 .00 701,081.00 43,302.68 157,636.65 498,582.21 44,862.14 94 460,326.59 Other Expenditures .00 .00 .00 .00 ..00 .00 .00 +++ .00 Office Equipment 556.00 .00 556.00 .00 .00 132.99 423.01 24 .00 Other Equipment 19,770.00 .00 19,770.00 15,489.04 .00 16,359.17 3,410.83 83 14,217.00 EXPENSE TOTALS $2,152,732.00 $0.00 $2,152,732.00 $164,456.86 $171,036.38 51,544,896.20 $436,799.42 80% $1,498,445.11 Fund 060 - Vehicle Maintenance Fund Totals $2,152,732.00 $0.00 $2,152,732.00 $154,456.86171,036.38 . � 51,544896.20 , $436,799. 42 $1,498,445.11 Account Classification Fund 061 - Vehicle Replacement Fund EXPENSE 4101 F= i fmn 14 1 # Repott Through 09/30/14 • Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Motor Equipment 1,614,000.00 163,700.00 1,777,700.00 8,272.15 291,185.39 808,951.17 677,563.44 62 407,681.25 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $1,614,000.00 $163,700.00 $1,777,700.00 $8,272.15 $291,185.39 $808,951.17 $677,563.44 62% $407,681.25 Fund 061- Vehicle Replacement Fund Totals $1,614,000.00 $163,700.00 $1,777,700.00 $8,272.15 $291,185.39 $808,951.17 $677,563.44 $407,681.25 z N N Account Classification Fund 062 - Computer Replacement Fund EXPENSE OVAi i t i ' i i R " it i Through09/30/14 -�,rior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Expenditures .00 ,00 .00 .00 AO .00 .00 +++ .00 Office Equipment 247,480.00 ..00 247,480.00 741.52 82,600.00 76,076.73 88,803.27 64 134,464.38 EXPENSE TOTALS $247,480.00 $0.00 $247,480.00 $741.52 $82,600.00 $76,076.73 $88,803.27 64% $134,464.38 Fund 062 - Computer Replacement Fund Totals $247,480.00 $0.00 $247,480.00 $741.52 $82,600.00 $76,076.73 $88,803.27 $134,464.38 Account Classification Fund 063 - Risk Management Fund EXPENSE Repoit Through 09/30/14 • • tM j6 Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services 27,000.00 .00 27,000.00 .00 7,000.00 10,300.00 9,700.00 64 10,950.00 Insurance 7,812,938.00 .00 7,812,938.00 545,211.94 .00 6,294,808.66 1,518,129.34 81 5,484,263.46 Other Equipment 5,000.00 .00 5,000.00 .00 .00 58.25 4,941.75 1 2,140.90 Infrastructure .00 .00 .00 .00 .00 .00 .00 ... .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $7,844,938.00 $0.00 $7,844,938.00 $545,211.94 $7,000.00 $6,305,166.91 $1,532,771.09 80% $5,497,354.36 Fund 063 - Risk Management Fund Totals $7,844,938.00 $0.00 $7,844,938.00 $545,211.94 $7,000.00 $6,305,166.91 $1,532,771.09 $5,497,354.36 N W Account Classification Fund 070 - Police Pension Fund EXPENSE Pension Benefits Contractual Services Insurance Commodities & Supplies Other Expenditures Office Equipment EXPENSE TOTALS Fund 070 - Police Pension Fund Totals Expense Budget by Account Classification Repoft Through 09/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 3,937,366.00 .00 3,937,366.00 357,104.77 .00 3,040,053.91 897,312.09 77 2,869,741.16 135,350.00 .00 135,350.00 1,189.73 .00 74,150.88 61,199.12 55 56,306.73 15,000.00 .00 15,000.00 11,960.00 .00 11,960.00 3,040.00 so .00 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 12,000.00 .00 12,000.00 .00 .00 8,555.00 3,445.00 71 9,633.95 .00 .00 .00 .00 .00 .00 .00 ... .00 $4,099,816.00 $0.00 $4,099,816.00 $370,254.50 $0.00 $3,134,719.79 $965,096.21 76% $2,935,681.84 $4,099,816.00 $0.00 $4,099,816.00 $370,254.50 $0.00 $3,134,719.79 $965,096.21 $2,935,681.84 Account Classification Fund 071- Fire Pension Fund EXPENSE Pension Benefits Contractual Services Insurance Commodities & Supplies Other Expenditures N N "� i 1 Through09/30/14 Priory Year +-t ListingSummary Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD 4,021,161.00 .00 4,021,161.00 348,120.05 .00 3,101,668.58 919,492.42 77 2,913,940.38 124,600.00 .00 124,600.00 2,045.20 .00 70,931.03 53,668.97 57 63,272.95 15,000.00 .00 15,000.00 13,100.00 .00 13,100.00 1,900.00 87 12,600.00 1,000.00 .00 1,000.00 .00 .00 ,00 1,000.00 0 32.22 12,000.00 .00 12,000.00 .00 .00 8,450.00 3,550.00 70 9,207.93 EXPENSE TOTALS $4,173,761.00 $0.00 $4,173,761.00 $363,265.25 $0.00 $3,194,149.61 $979,611.39 77% $2,999,053.48 Fund 071 - Fire Pension Fund Totals $4,173,761.00 $0.00 $4,173,761.00 $363,265.25 $0.00 $3,194,149.61 $979,611.39 $2,999,053.48 Grand Totals $116,983,802.00 $.3,339,419.00 $120,323,221<0 $6,804,5-42.33 7,458,060.75 $72,336,916:66 $40,523,24159 $€4,235,962.69