Loading...
HomeMy WebLinkAbout3. Monthly Financial Report & Approve Bills 07/15/2014MoL" Prospe Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE; JULY 9, 2014 SUBJECT: MONTHLY FINANCIAL REPORT — JUNE 2014 Attached hereto are the cash position and investment statements of the Village for the month ended June 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 are not funds 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 Funds, 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, Special Service Area and Library Bonds Escrow Funds. 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 Special Service Area Fund and Library Bonds Escrow Fund accounts for the accumulation of monies for debt service payments. Governmental and Enterprise Funds - Cash and cash equivalents at May 31 totaled $44.1 million. During June, cash receipts totaled $4,685,604. In addition investment income for the month was $1,829 and inflows due to Interfund activity totaled $45,225. Reductions in cash and cash equivalents during June totaled $7,518,716. Of this amount, payments to vendors were $6,106,334 and employee payroll and related expenses were $1,407,972. Other disbursements totaled $4,410. Cash and cash equivalents at June 30 were $41.3 million. Monthly Financial Report — June 2014 July 9, 2014 Page 2 Investments in the Governmental and Enterprise Funds at May 31 were $8.1 million. No CD's matured during June. CD's in the Governmental and Enterprise Funds reside in the Street and Flood Control Funds and were purchased using proceeds from the Series 2013 and Series 2014 bond issues. The maturity dates of the CD's are laddered to match the expected payout schedule of the underlying flood control and street resurfacing work. Total investments at June 30 were $8,078,285. Total cash and investments for Governmental and Enterprise Funds at May 31 were $52,170,227. Cash and investments at June 30 totaled $49,384,169. This is a decrease of $2,786,058 for the month. Trust and Agency Funds - Cash and cash equivalents at May 31 totaled $5.8 million. During June, cash receipts totaled $326,191. In addition investment income for the month was $173,569 and outflows due to Interfund activity totaled $45,225. There was also a net decrease in cash due to investment activities of $609,022. Reductions in cash and cash equivalents during June totaled $939,152. Of this amount, payments to vendors were $361,093 employee payroll and related expenses were $552,253, and payments related to the flexible spending program totaled $20,760. Other disbursements totaled $5,045. Cash and cash equivalents at June 30 were $4.7 million. Total investments at June 30 were $109,592,373, an increase of $2,374,574 from May 31, 2014. There was investment income of $1,765,552, primarily from equity growth, and a transfer from cash of $609,022 that accounted for the change. Total cash and investments for Trust and Agency Funds at May 31 were $113.0 million. Cash and investments at June 30 totaled $114.3 million. This is an increase for the month of $1.3 million. 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. The report will also provide additional information on fund types that experienced higher than normal activity for the month. Each of these is highlighted below. General Fund — Cash and cash equivalents at May 31 totaled $8,888,984. During June, cash receipts totaled $2,675,539 and investment income was $188. Significant cash receipts included sales taxes and the state income tax. Sales tax revenues for the month totaled $1,162,822. Of this amount, $1,054,630 was generated from the 1% state portion while $108,192 was generated from the .25% home rule portion. Sales taxes received in June are for March 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 - June 2014.docx Monthly Financial Report — June 2014 July 9, 2014 Page 3 State income tax receipts for June totaled $527,523. These monies were actually to be received by the Village in April. The state continues to be 60 and 90 days delinquent in making these remittances to the Village. The state is currently $1.2 million in arrears in remitting income taxes to the Village May and June Receipts. Disbursements from the General Fund for June included payments to vendors of $1,485,181 and payments for employee wages and benefits of $1,244,305. Interfund transfers of $639,324 for health premiums and vehicle lease and maintenance payments were also made during June. Cash and cash equivalents at June 30 were $8,191,437. There were no investments in the General Fund at June 30. Statement of Investments (panes 3 -4) 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 - The investments for the governmental and agency funds are made up solely of certificates of deposit. Certificates of deposit have maturities of between 56 and 331 days from date of purchase and are currently placed with several banks through our financial advisor, PMA. A detailed listing of the CD's currently held can be found on pages three and four of the financials following this summary write -up. Return on the portfolio of CD's range from 10 to 35 basis points. The portfolio return remains low on all types of investments available to municipalities (typically certificate of deposits, money market accounts and short -term treasuries). 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. 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 pension funds also have a small portion of their portfolio invested in international stocks. Each year the investment mix is evaluated for optimal diversification to meet the pension funds 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. H:WCCT\Treasurer's Repo rt\2014\Month ly Cash Position Report - June 2014.docx Monthly Financial Report — June 2014 July 9, 2014 Page 4 Maturity Purchase Financial Date Date Institution POLICE PENSION FUND M9j Various Various Wells Fargo Various Various Various Investment CUS[P/ Interest Market Description Aect,# Rate % Value Wells Fargo Investments Various Various $ 22,787,280,26 Mutual Fund Investments Various Various 33,033,367,97 55,820,648,23 FIRE PENSION FUND (071) Various Various Wells Fargo Various Various Various TOTAL TRUST AND AGENCY FUND INVESTMENTS Wells Fargo Investments Various Various 20,412,06679 Mutual Fund Investments Various Various 33,359,65754 53,771,72433 —$ 109,592,372 56 Investment of the Village's pension funds is governed by an Investment Policy adopted by each Pension Board. The investment policy for both the pension funds was updated in January 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:\ACCT\Treasurer's Report\2014\Monthly Cash Position Report - June 2014.docx VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended June 30, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS Balance at May 31, 2014 Cash receipts Investment income Transfers from investments to cash Transfers to investments from cash Interfund activity Disbursements: Accounts payable Payroll Other Balance at June 30, 2014 Cash and Cash Total Cash and Equivalents Investments Investments $ 44,091,942.37 $ 8,078,285.08 $ 52,170,227.45 4,685,603.54 4,685,603.54 1,828.84 - 1,828.84 45,225.09 45,225.09 (6,106,334.05) (6,106,334.05) (1,407, 971.70) (1,407, 971.70) (4,410.46) (4,410.46) 1,765,551.27 $ 41,305,883.63 $ 8,078,285.08 $ 49,384,168.71 TRUST AND AGENCY FUNDS * Disbursements: Accounts payable Payroll Flex spending Other Balance at June 30, 2014 (361,092.72) (552,253.47) (20, 760.45) (5,045.82) (361,092.72) (552,253.47) (20,760.45) (5,045.82) $ 4,662,489.27 $ 109,592,372.56 $ 114,254,861.83 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 Cash and Cash Total Cash and Equivalents Investments Investments Balance at May 31, 2014 $ 5,756,127.87 $ 107,217,799.36 $ 112,973,927.23 Cash receipts 326,191.41 326,191.41 Investment income (loss) 173,569.47 1,765,551.27 1,939,120.74 Transfers from investments to cash 1,384,016.13 (1,384,016.13) Transfers to investments from cash (1,993,038.06) 1,993,038.06 - Interfund activity (45,225.09) (45,225.09) Disbursements: Accounts payable Payroll Flex spending Other Balance at June 30, 2014 (361,092.72) (552,253.47) (20, 760.45) (5,045.82) (361,092.72) (552,253.47) (20,760.45) (5,045.82) $ 4,662,489.27 $ 109,592,372.56 $ 114,254,861.83 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 VILLAGE OF MOUNT PROSPECT Summary of Cash Activity by Fund type For the Month Ended June 30, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS _ TRUST AND AGENCY FUNDS * Ending balance 8191 43705 3,396,381,49 474,429.44 12,507368;72 6,067713 55 10,668,553,38 41,305,88163 3,232,53404 1.429,95523 45,968372 9C INVESTMENTS Certificates of deposit 8,078,285 08 8 78,285 08 8,078,285 08 Wells Fargo investments - 43,199,347 05 43,199,347 05 Mutual fund investments - 66,393,025, 51 66.393. Total investments - 8.078,285 08 8,078,285 08 109,592,372 11 7,670,657 64 TOTAL CASH AND INVESTMENTS 8,191,437.05 $ 3,396,381.49 $ 474,429.44 $ 20,585,653.80 $ 6,067,713.55 $ 10,668,553.38 $ 49,384,168.71 $112,824,906.60 $ 1,429,955.23 $163,639,030.54 SPECIAL CAPITAL TOTAL GOVT FIRE AND OTHER TRUST REVENUE DEBT SERVICE PROJECTS ENTERPRISE INTERNAL AND ENTERPRISE POLICE AND AGENCY GENERAL FUND FUNDS FUNDS FUNDS FUNDS SERVICE FUNDS FUNDS PENSIONS FUNDS TOTAL, CASH & CASH EQUIVALENTS - -- Beginning balance $ 8,888,984,01 $ 3,231,616,17 507,901 $ 14,664,186 60 $ 6,218,91980 $ 10,580.334 58 $ 44,091,942 37 $ 4,245,238 21 $ '1,510,88966 $ 49,848,070-24 Cash receipts 2,675,539 14 539,617 17 84,92424 347,619,34 943,778 93 94,12472 4,685,603 54 115,781.22 210,41019 5,01 1,794 95 Investment income 18753 52,26 7 4' 69451 109,37 777 76 1,82884 173,411 10 15837 175,398 31 Transfers from investments - - - - - - 1,384,016 13 1,384,016 13 Transfers to investments - - (1,993,038.06) (1,993,038 06) Interfund (639,323,73) 34,34670 (169,029 46) 8 58 45,225.09 (39,74780) (5,47729) 000 Disbursements - other (4,46444) 5198 (4,41046) (5,045,82) (9,456,28) Disbursements - flexible spending - ( 20�760-45) (20,76045) Disbursements - payroll (1,244,304 80) (1 ' 3:88 89 (104,497 95) (45,28106) (1 �407,971 70) (552,253 47) (1,960,225 17) Disbursements - accounts payable (1,485180.66) (395.362 92) (118,403 - 52} .. 12,505,131,63 (821,567 14) (780 (6,106,334 05) (100.873.29} (6,467,426.77) Ending balance 8191 43705 3,396,381,49 474,429.44 12,507368;72 6,067713 55 10,668,553,38 41,305,88163 3,232,53404 1.429,95523 45,968372 9C INVESTMENTS Certificates of deposit 8,078,285 08 8 78,285 08 8,078,285 08 Wells Fargo investments - 43,199,347 05 43,199,347 05 Mutual fund investments - 66,393,025, 51 66.393. Total investments - 8.078,285 08 8,078,285 08 109,592,372 11 7,670,657 64 TOTAL CASH AND INVESTMENTS 8,191,437.05 $ 3,396,381.49 $ 474,429.44 $ 20,585,653.80 $ 6,067,713.55 $ 10,668,553.38 $ 49,384,168.71 $112,824,906.60 $ 1,429,955.23 $163,639,030.54 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of June 30, 2014 GOVERNNIENTAL AND ENTERPRISE FUNDS Maturity Purchase Financial Date Date Institution STREET IMP CONSTRUCTION FUND (23 08/01/14 02/05/14 Citizens Community Bank, VA 08/12/14 02/12/14 Compass Bank 08/14/14 02/14/14 Bank of Baroda 09/02/14 02/05/14 Bar Harbor Bank & Trust, ME 07/01/14 01/22/14 Citibank -IMMA Term- IL 07/22/14 01/21/14 Bank of Virginia, VA 08/01/14 01/22/14 Citibank -I PAA Term, IL 09/02/14 01/22/14 Citibank -I MI A Tema, IL 09/18/14 01/21/14 Banco Popular North Amer, IL 09/18/14 01/21/14 Banco Popular North Amer, IL 09/18/14 01/21/14 Banco Popular North Amer, [L 09/18/14 01/21/14 Essex Bank, VA 09/18/14 01/21/14 Landmark Community Bank, TN 09/18/14 01/21/14 Orrstown Bank- PA 10/20/14 01/21/14 Bank Leumi USA, NY 10/20/14 01/21/14 Cole "Taylor Bank (N), lL 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 of China, NY 1 1/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 Clnewest Bank FSB, CA TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS Investment CUSIP/ Interest Market Description FDIC ,# Rate % Value Certificate of Deposit 35326 0.140% 249,800,00 Certificate of Deposit N/A 0.150% 240,000.00 Certificate of Deposit N/A 0.150% 249,185.08 Certificate of Deposit 11971 0.154% 95,000.00 833,985.08 Certificate of deposit 7213 0.100% 1,500,000.00 Certificate of Deposit 57627 0.151% 249,800.00 Certificate of Deposit 7213 0, 120% 1,750,000.00 Certificate of Deposit 7213 0.120% 500,000.00 Certificate of Deposit 34967 0.120% 84,000.00 Certificate of Deposit 34967 0.120% 83,000,00 Certificate of Deposit 34967 0.120% 82,700.00 Certificate of Deposit 8675 0.120% 249,800.00 Certificate of Deposit 34982 0.121% 249,700.00 Certificate of Deposit 713 0,120% 249,700.00 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 0207% 249,200.00 Certificate of Deposit 57965 0 t50% 249,600.00 Certificate of Deposit 33682 0159% 249,600.00 Certificate of Deposit 21851 0350% 249,200.00 Certificate of Deposit 58978 0,300% 249,300,00 TRUST AND AGENCY FUNDS * Maturity Purchase Financial Date Date Institution , i t Various Various Various Wells Fargo Various Various FIRE PENSION FUND (071) Various Various Wells Fargo Various Various Various Investment Description Wells Fargo Investments Mutual Fund Investments CUSIP/ Acct # Interest Rate % Various Various Various Various 7,244,300.00 $ 8,078,2,85.08 Market Value $ 22,787,280.26 33,033,367.97 55,820,648.23 20,412,066.79 33,359,657.54 53,771,724.33 $ 109,592,372.56 TOTAL TRUST AND AGENCY FUND INVESTMENTS Wells Fargo Investments Mutual Fund Investments Various Various Various Various " Assets are restricted in purpose and do not represent discretionary assets of the government. VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES June 01— June 30, 2014 Revenue Budget by Account Classification Report Through 06/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 14,674,466.00 .00 14,674,466.00 (14,610.36) .00 7,390,526.53 7,283,939.47 50 6,470,785.61 8,241,500.00 .00 8,241,500.00 608,656.94 .00 2,811,167.68 5,430,332.32 34 2,701,146.02 1,621,000.00 .00 1,621,000.00 63,961.65 .00 943,827.88 677,172.12 58 2,036,685.62 18,083,100.00 .00 18,083,100.00 1,689,665.57 .00 5,482,100.52 12,600,999.48 30 4,924,296.77 1,516,000.00 .00 1,516,000.00 136,801.85 .00 704,727.72 811,272.28 46 712,375.71 491,000.00 .00 491,000.00 77,031.28 .00 234,621.34 256,378.66 48 240,262.91 22,500.00 .00 22,500.00 344.11 .00 2,418.79 20,081.21 it 7,357.77 226,000.00 .00 226,000.00 23,825.34 .00 247,084.13 (21,084.13) 109 119,951.55 918,500.00 .00 918,500.00 22,324.77 .00 151,811.83 766,688.17 17 143,663.82 20,000.00 .00 20,000.00 .00 .00 .00 20,000.00 0 .00 REVENUE TOTALS $45,814,066.00 $0.00 $45,814,066.00 $2,608,001.15 $0.00 $17,968,286.42 $27,845,779.58 39% $17,356,525.78 Fund 0011- General Fund Totals $45,814,066.00 $0.00 $45,814,066.00 $2,608,001.15 $0.00 $17,968,286.42 $27,845,779.58 $17,356,52538 r M Revenue Budget by Account Classification Report Through 06/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,237,000.00 .00 2,237,000.00 (2,065.67) 100 1,146,426.66 1,090,573.34 51 893,824.54 1,056,532.00 .00 1,056,532.00 84,924.24 .00 217,593.12 838,938.88 21 145,307.70 43,005.00 .00 43,005.00 .00 .00 21,927.64 21,077.36 51 21,573.21 400.00 .00 400.00 7.41 .00 33.89 366.11 8 84.70 .0 0 . . . . 00 3,231.19 (3,231.19) + ++ .00 REVENUE TOTALS $3,336,937.00 $0.0 $ 3,336,937.00 $ 82,8 6 5.98 $0.00 $1,389,212.50 $1,947,724.50 42% $1,060,790.15 Fund 002 -Debt service Fund Totals $3,336,937.00 $0.00 $3,336,937.00 $82,865.98 $0.00 $1,389,212.50 $1,937,724.50 $1,060,790.15 Revenue Budget by Account Classification Report Account Classification Through 06/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 Redd Prior Year YTD Fund 020 - Capital Improvement Fund REVENUE Other Taxes 1,246,000.00 .00 1,246,000.00 100,153.71 .00 256,614.10 989,385.90 21 250,228.57 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 ... 91,171.05 Investment Income 1,000.00 .00 1,000.00 31.62 .00 290.03 709.97 29 385.19 Reimbursements .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Revenue 10,000.00 .00 10,000.00 .00 .00 89,970.00 (79,970,00) 900 283,233.00 Other FIriancing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $1,257,000.00 $0.00 $1,257,000.00 $100,185.33 $0.00 $346,874.13 $910,125.87 28% $625,017.81 Fund 020 - Capital Improvement Fund Totals $1,257,000.00 $0.00 $1,257,000.00 $100,185.33 - $MO $346,874.13 $910,125.87 $625,017.81 w !0 Revenue Budget by Account Classification Report Through 06/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 + ++ 6.62 Ocher 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 - -+++ $6.62 Fund 021 - Series 20 09 Construction Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.62 Revenue Budget by Account Classification ' • 1 Adopted Budget Amended Current Month YTD Ac c o unt Classification Budget Amendments Budget Transactions Encumbrances Fund 022 - Downtown Redevelopment Construct REVENUE Through 05/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Recd Prior Year YTD Property Taxes 2,671,000.00 .00 2,671,000.00 .55 .00 1,252,091.78 1,418,908.22 47 1,318,679.45 Investment Income 1,000.00 .00 1,000.00 2102 .00 184.14 815.86 18 365.40 Reimbursements .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $2,672,000.00 $0.00 $2,672,000.00 $22.57 $0.00 $1,252,275.92 $1,419,724.08 47% $1,319,044.85 Fund 022 -Downtown Redevelopment Construct Totals $2,672,000.00 $0.00 $2,672,000.00 $22.57 $0.00 $1,252,275.92 $1,419,724.08 $1,319,044.85 Ln M Account Classification Revenue Budget by Account Classification Report Through 06/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 023 - Street Improvement Construc Fund REVENUE Other Taxes 2,057,000.00 .00 2,057,000.00 169,598.89 .00 574,385.09 1,482,614.91 28 420,967.12 Licenses, Permits & Fees 1,045,000.00 .00 1,045,000.00 35,057.25 .00 938,350.50 106,649.50 90 .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 ... 3,611.52 Investment Income 100.00 .00 100.00 489.63 .00 3,039.35 (2,939.35) 3039 48.32 Reimbursements .00 .00 .00 .00 .00 .00 .00 ... .00 Other Revenue 6,000.00 .00 6,000.00 19,541.45 .00 47,936.93 (41,936.93) 799 10,515.09 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 $224,687.22 $0.00 $8,104,412.69 $1,503,687.31 84% $435,142.05 Fund 023 -Street Improvement Construc Fund Totals $9,608,100.00 $0.00 $9,608,100.00 $224,687.22 $0.00 $8,104,412.69 $1,503,68731 $435,142.05 Revenue Budget by Account Classification J Report up Through 06/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 Reed Prior Year YTD Fund 024 - Hood Control Construction Fur} REVENUE Other Taxes 289,468.00 .00 289,468.00 23,267.49 .00 59,616.03 229,851.97 21 126,967.42 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 1,099.24 .00 6,476.33 (5,976.33) 1295 2,006.04 Reimbursements .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Financing Sources .00 .00 .00 .00 .00 .00 100 + ++ .00 REVENUE TOTALS $ 289,968.00 $0.00 $289,968.00 $24,366.73 $0.00 $66,092.36 $223,875.64 23% $128,973.46 Fund 024 - Flood Control Construction Fund Totals $289,968.00 $0.00 $289,968.00 $24,366.73 $0.00 $66,092.36 $223,875.64 $128,973.46 J 2C. Account Classification Fund 040 -Refuse Disposalft- REVENUE Revenue Budget by Account Classification Report Through 06/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 Redd Prior Year YTD ftropE — Ilyl axes 342,000.00 .00 342,000.00 (2,201.74) .00 173,974.60 168,025.40 51 951,911.17 Changes For Services 2,900,000.00 .00 2,900,000.00 327,485.27 .00 1,453,257.83 1,446,742.17 50 1,105,232.90 Fines & Forfeits 25,000.00 .00 25,000.00 1,861.02 .00 13,023.35 11,976.65 52 8,436.24 Investment Income 500.00 .00 500.00 38.35 .00 370.37 129.63 74 256.58 Reirnbursements .00 .00 .00 147.48 '00 147.48 (147.48) ... 144.59 Other Revenue 359,000.00 .00 359,000.00 35,116.23 .00 157,945.25 201,054.75 44 161,604.59 REVENUE TOTALS $3,626,500.00 $0.00 $3,626,500.00 $362,446.61 $0.00 $1,798,718.88 $1,827,781.12 50% $2,227,586.07 Fund 040 - Refuse Disposal Fund Totals $3,626,500.00 $0.00 $3,626 00.00 $362,446.61 $0.00 $1,798,718.88 $1,827,781.12 $2,227,586.07 Account Classlflcatlon Fund 041 - Motor Fuel Tax Fund REVENUE Revenue Budget by Account Classification Report Through 06/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 Intergovernmental Revenue 1,290,000.00 .00 1,290,000.00 140,208.81 .00 800,351.32 489,648.68 62 543,503.15 Investment Income 100.00 .00 100.00 2.50 .00 11.98 88.02 12 98.64 Reimbursements 6,000.0 .00 6,000.00 .00 .00 6,870.77 (870.77) 115 1,782.51 REVENUE TOTALS $1,296,100.00 $0.00 $1,296,100.00 $140,211.31 $0.00 $807,234.07 $488,865.93 62% $545,384.30 Fund 041 - Motor Fuel Tax Fund Totals $1,296,100.00 $0.00 $1,296,100.00 $140,211.31 $0.00 $807,234.07 $488,865.93 $545,384.30 n- Revenue Budget by Account Classification ' k- iIiji I Adopted Budget Amended Current Month YTD Account Classiflcation Budget Amendments Budget Transactions Encumbrances Fund 042 - Cmmty Development Block Grant REVENUE Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Intergovernmental Revenue 293,202.00 97,171.00 390,373.00 .00 .00 .00 390,373.00 0 9,719.00 Investment Income .00 .00 .00 '00 .00 .00 .00 ... .00 Other Revenue 60,000.00 .00 60,000.00 49,281.60 .00 98,913.12 (38,913.12) 165 53,086.18 REVENUE TOTALS $353,202.00 $97,171.00 $450,373.00 $49,281.60 $0.00 $98,913.12 $351,459.88 22% $62,805.18 Fund 4142 - Cmmty Development Block Grant Totals $353,202.00 $97,171.00 $450,373.00 $49,281.60 $0.00 $98,913.12 $351,459.88 $62,805.18 Revenue Budget by Account Classification Report Account Classification Fund 043 -Asset Se Fund REVENUE Fines & Fwfeits Investment Income Through 06/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 42,778.96 .00 42,778.96 (40,778.96) 2139 5,977.67 100.00 .00 100.00 .60 .00 8.46 91.54 8 6.01 REVENUE TOTALS $ $ 0.00 $2,100.00 $42,779.56 $0.00 $42,787.42 ($40,687.42) 2037% $5,983.68 Fund 043 - Asset Seizure Fund Totals $2,100.00 $0.00 $2,100.00 $42,779.56 $0.00 $42,787.42 ($40,687.42) $5,983.68 H H F N Revenue Budget by Account Classification Report Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing Account Classification Adopted Budg Budget A m e ndments Amended Budget Current Month Transactions YTD Encumbrances YTD Transactions Budget - YTD % used/ Transactions Rec'd Prior Year YTD Fund 044 m AEA Sh Funds fund REVENUE Fines & Forfeits 100.00 .00 100.00 .00 .00 24,637.80 (24,537.80) 24638 .00 Investment Income 100.00 .00 100.00 1.48 .00 10.68 89.32 11 5.09 REVENUE TOTALS $200.00 $0.00 $200.00 $1.48 $0.00 $24,648.48 ($24,448.48) 12324% $5.09 Fund 044 - PEA Shared Funds fund Totals $200.00 $0.00 $200.00 $1.48 $0.00 $24,648.48 ($24,448.48) $5.09 Revenue Budget by Account Classification Report Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 045 - DUI Fine Fund REVENUE Fines & Forfeits Investment Income 20,000.00 .00 20,000.00 4,240.09 .00 13,819.82 6,180.18 69 12,701.65 100.00 .00 100.00 2.10 .00 23.20 76.80 23 .00 REVENUE TOTALS $20,100.00 $0.00 $20,100.00 $4,242.19 $0.00 $13,843.02 $6,256.98 69% $12,701.65 Fund 045 - DUI Fine Fund Totals $20,100.00 $0.00 $20,100.00 $4,242.19 $0.00 $13,843.02 $6,256.98 $12,701.65 r w UKK&MA wXFwWlJKJi Fund 046 - Foreign Fire Tax Board Fund REVENUE Revenue Budget by Account Classification Report Through 06/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 her Taxes 70,000.00 .00 70,000.00 1,200.00 .00 1,200.00 68,800.00 2 919.90 Investment Income 1,000.00 .00 1,000.00 6.33 .00 63.50 936.50 6 .00 Other Revenue .00 .00 .00 .00 .00 .00 .00 ... 45.00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $71,000.00 $0.00 $71,000.00 $1,206.33 $0.00 $1,263.50 $69,736.50 2% $964.90 Fund 846 - Foreign Fire Tax Board Fund Totals $71,000.00 $0.00 $71,000.00 $1,206.33 $0.00 $1,263.50 $69,736.50 $96470 Revenue Budget by Account Classification Report Account Classification Through 06/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 047 - .justice Assistance Grant Fund 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 Ln r rn Revenue Budget by Account Classification Report Through 06/30/14 - Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments B udg et T Encumbran Transactions Transactions Rec'd Prior Year YTD Fund 048 « Business District Fund REVENUE Other Taxes 943,000.00 .00 943,000.00 65,231.75 .00 303,981.16 639,018.84 32 282,863.71 Investment Income 100.00 .00 100.00 .90 .00 17.55 82.45 18 60.59 Other Financing Sources .00 .00 .00 . .00 .00 .00 ... .00 REVENUE TOTALS $943,100.00 $0.00 $943,100.00 $65,232.65 $0.00 $303,998.71 $639,101.29 32% $282,924. Fund 048 - Business District Fund Totals $943,100.00 $0.00 $943,100.00 $65,232.65 $0.00 $303,998.71 $639,101.29 $282,924.30 Revenue Budget by Account Classification Report Through 06/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 Redd Prior Year YTD Fund 050 - Water and Sewer Fund REVENUE Property Taxes 1,530,000.00 .00 1,530,000.00 (2,111.65) .00 810,261.02 719,738.98 53 807,844.78 Licenses, Permits & Fees 17,000.00 .00 17,000.00 2,700.00 .00 9,460.00 7,540.00 56 8,870.00 Charges For Services 12,711,000.00 .00 12,711,000.00 968,640.35 .00 5,619,629.83 7,091,370.17 44 5,502,948.73 Fines & Forfeits 100,000.00 .00 100,000.00 8,771.13 .00 53,138.69 46,861.31 53 61,200.80 Investment Income 1,100.00 .00 1,100.00 103.62 .00 932.92 167.08 85 510.27 Reimbursements 1,000.00 .00 1,000.00 .00 .00 (131.00) 1,131.00 -13 9,834.52 Other Revenue 25,000.00 .00 25,000.00 5,060.00 .00 34,596.53 (9,596.53) 138 16,333.28 Other Financing Sources .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $14,385,100.00 $0.00 $14,385,100.00 $983,163.45 $0.00 $6,527,887.99 $7,857,212.01 45% $6,407,542.38 Fund 050 -Water and Sewer Fund Totals $14,385,100.00 $0.00 $14,385,100.00 $983,163.45 $0.00 $6,527,887.99 $7,857,212.01 $6,407,542.38 F� OD Account Classification Revenue Budget by Account Classification Report Through 06/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 051- Village Parking System Fund — REVENUE Other Taxes 10,000.00 .00 10,000.00 803.80 .00 2,059.51 7,940.49 21 2,204.66 Charges For Services 115,000.00 100 115,000.00 10,103.80 .00 66,467.66 48,532.34 58 62,707.16 Investment Income 100.00 .00 100.00 5.75 .00 52.46 47.54 52 14.59 Other Revenue 6,600.00 .00 6,600,00 550.00 .00 3,300.00 3,300.00 50 3,300.00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $131,700.00 $0.00 $131,700.00 $11,463.35 $0.00 $71,879.63 $59,820.37 55% $68,226.41 Fund 051 - Village Parking System Fund Totals $131,700.00 $0.00 $131,700.00 $11,463.35 $0.00 $71,879.63 $59,820.37 $68,226.41 Revenue Budget by Account Classification Report Account Classification Fund 052 - Parking System Revenue Fund REVENUE Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YrD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Other Taxes 90,000.00 .00 90,000.00 7,234.22 .00 18,535.54 71,464.46 21 19,841.91 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Charges For Services 112,000.00 .00 112,000.00 10,648.46 .00 57,006.56 54,993.44 51 54,419.34 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,100.00 $0.00 $202,100.00 $17,882.68 $0.00 $75,542.10 $126,557.90 37% $74,262.87 Fund 052 - Parking System Revenue Fund Totals $202,100.00 $0.00 $202,100.00 $17,882.68 $0.00 $75,542.10 $126,557.90 $74,262.87 r K) C3 Account Classification Fund 060 - Vehicle Maintenance Fund REVENUE Revenue Budget by Account Classification Report Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD Y1'D Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTD ... iarges or ervices 2,138,317.00 .00 2,138,317.00 178,193.07 .00 1,069,158.42 1,069,158.58 50 1,096,656.60 Investment Income .00 .00 .00 41.50 .00 281.42 (281.42) ... 252.08 Other Revenue .00 .00 .00 397.00 .00 397.00 (397.00) ... 138.40 REVENUE TOTALS $2,138,317.00 $0.00 $2,138,317.00 $178,631.57 $0.00 $1,069,836.84 $1,068,480 16 50% $1,097,047.08 Fund 060 -Vehicle Maintenance Fund Totals $2,138,317.00 $0.00 $2,138,317.00 $178,631.57 $0.00 $1,069,836.84 $1,068,480.16 $1,097,047.08 Revenue Budget by Account Classification Report MEMMUM&M Through 06/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 061 - Vehicle Replacement Fund REVENUE Charges For Services 1,346,300.00 .00 1,346,300.00 112,191.68 .00 673,150.08 673,149.92 50 698,300.04 Fines & Forfeit's 10,000.00 .00 10,000.00 1,377.72 .00 5,577.72 4,422.28 56 4,220.00 Investment Income 5,000.00 .00 5,000.00 505.66 .00 3,600.99 1,399.01 72 2,779.63 Other Revenue .00 .00 .00 .00 .00 .00 .00 ... .00 Other Financing Sources 60,000.00 .00 60,000.00 (341.47) .00 31,213.00 28,787.00 52 34,750.84 REVENUE TOTALS $1,421,300.00 $0.00 $1,421,300.00 $113,733.59 $0.00 $713,541.79 $707,758.21 50% $740,050.51 Fund 061- Vehicle Replacement Fund Totals $1,421,300.00 $0.00 $1,421,300.00 $113,733.59 $0.00 $713,541.79 $707,758.21 $740,050.51 Account Classification Fund 062 - Computer Replacement REVENUE Revenue Budget by Account Classification Report Through 06/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 Charges For Services 23,088.00 .00 23,088.00 1,924.00 .00 11,544.00 11,544.00 so .00 Investm,ent Income 1,000.00 .00 1,000.00 58.27 .00 370.79 629.21 37 352.20 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 + ++ REVENUE TOTALS $24,088.00 $0.00 $24,088.00 $1,982.27 $0.00 $11,914.79 $12,173.21 49% $352.26 Fund 062 - Computer Replacement Fund Totals $24,088.00 $0.00 $24,088.00 $1,982.27 $0.00 $11,914.79 $12,173.21 $352.20 Revenue Budget by Account Classification Report Account Classification Through 06/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 063 - Risk Management Fund REVENUE Charges For Services 6,456,273.00 .00 6,456,273.00 536,536.93 .00 3,333,284.46 3,122,988.54 52 3,033,532.23 investment income 2,000.00 .00 2,000.00 172.33 .00 1,136.21 863.79 57 832.18 Reimbursements 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Other Revenue 1,357,600.00 .00 1,357,600.00 96,894.52 .00 664,786.13 692,813.87 49 636,243.49 REVENUE TOTALS $7,816,873.00 $0.00 $7,816,873.00 $633,603.78 $0.00 $3,999,206.80 $3,817,666.20 51% $3,670,607.90 Fund 063 - Risk Management Fund Totals $7,816,873.00 $0.00 $7,816,873.00 $633,603.78 $0.00 $3,999,206.80 $3,817,666.20 $3,670,607.90 N W N �P Revenue Budget by Account Classification Report Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classlficatlon Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd 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 831,527.06 .00 2,491,327.63 924,572.37 73 2,373,205.50 Other Revenue 3,742,224.00 .00 3,742,224.00 6 .00 1,798,697.81 1,943,526.19 48 1,718,447.05 REVENUE TOTALS $7,158,124.00 $0.00 $7,158,124.00 $8 $ 0.00 $4,290,025.44 $2,868,098.56 60% $4,091,652.55 Fund 070 - Police Pension Fund "Totals $7,158 $0.00 $7,158,124.00 � $895 606.93 � $0.00 $4,290 025.44 $ 2,868 098.56 $4,091,652.55 Revenue Budget by Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Report Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 071- Fire Pension Fund REVENUE Investment Income Other Revenue 3,165,200.00 .00 3,165,200.00 1,049,155.28 .00 2,256,997.10 908,202.90 71 2,453,522.25 3,079,042.00 .00 3,079,042.00 46,338.82 .00 1,566,323.09 1,512,718.91 51 1,484,580.07 REVENUE TOTALS $6,24 4,242.00 $0.00 $6,244,242.00 $1,095,494.10 $0.00 $3,823,320.19 $2,420,921.81 61% $3,938,102.32 Fund 071 - Fire Pension Fund Totals $6,244,242.00 $0.00 $6,244,242.00 $1,095,494.10 $0.00 $3,823,320.19 $2,420,921.81 $3,938,102.32 Grand Totals $108,812,217.00 $97,171.00 $108,909,388.00 $7,637,092.43 $0.00 $52,801,716.79 $56,107,671.21 $44,151,700.11 N Ul Expense Budget by Account Classification Report Account Classification Fund 001 - General Fund EXPENSE Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactlons Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 23,919,744.00 .00 23,919,744.00 1,884,016.89 .00 10,845,388.68 13,074,355.32 45 10,425,285.66 Employee Benefits 12,344,314.00 .00 12,344,314.00 599,215.07 .00 6,219,509.02 6,124,804.98 50 5,837,716.61 Other Employee Costs 415,005.00 (1,000.00) 414,005.00 22,563.87 9,762.55 160,322.81 243,919.64 41 140,487.92 Pension Benefits 46,301.00 .00 46,301.00 3,858.36 .00 23,150.16 23,150.84 50 23,074.86 Contractual Services 7,001,321.00 134,548.00 7,135,869.00 552,170.57 557,584.07 3,383,736.27 3,194,548.66 55 3,562,899.84 Utilities 262,282.00 .00 262,282.00 25,435.99 .00 88,803.70 173,478.30 34 76,081.81 Insurance 350,519.00 .00 350,519.00 29,212.70 .00 175,278.60 175,240.40 50 172,564.07 Commodities & Supplies 627,855.00 61,600.00 689,455.00 81,949.81 26,380.37 275,167.04 387,907.59 44 219,214.79 Other Expenditures 11,080.00 .00 11,080.00 .00 .00 .00 11,080.00 0 .00 Building Improvements 10,000.00 .00 10,000.00 .00 675.00 1,083.52 8,241.48 18 5,728.41 Office Equipment 49,730.00 .00 49,730.00 99.99 .00 6,476.16 43,253.84 13 1,546.81 Other Equipment 165,123.00 3,100.00 168,223.00 12,974.90 20,402.55 73,126.68 74,693.77 56 18,145.09 Distribution Systems 100,000.00 .00 100,000.00 .00 .00 .00 100,000.00 0 .00 Infrastructure 510,792.00 3,400.00 514,192.00 98,160.78 119,896.28 203,137.88 191,157.84 63 191,151.89 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... EXPENSE TOTALS $45,814,066.00 $201,648.00 $46,015,714.00 $3,309,658.93 $734,700.82 $21,455,180.52 $23,825,832.66 48% $20,673,897.76 Fund 001 - General Fund Totals $45,814,066.00 $201,648.00 $46,015,714.00 $3,309,658.93 $734,700.82 $21,455,180.52 $23,825,832.66 $20,673,897.76 W Expense Budget by Account Classification Report A ccount Classification Fund 002 - Debt S, EXPENSE Contractual Services Other Expenditures - Bond Principal Interest Expense Bank & Fiscal Fees Interfund Transfers Other Financing Uses Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactlons Transactions Recd 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 108,648.33 .00 270,780.49 1,261,806.51 18 281,423.35 1,793,429.00 .00 1,793,429.00 9,755.19 .00 766,300.74 1,027,128.26 43 458,346.08 2,484.00 .00 2,484.00 .00 .00 1,258.20 1,225.80 51 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 $118,403.52 $0.00 $1,038,339.43 $2,290,160.57 31% $740,197.43 Fund 002 . Debt Service Fund Totals $3,328,500.00 $0.00 $3,328,500.00 $118,403.52 $0.00 $1,038,339.43 $2,290,160.57 $740,197.43 Expense Budget by Account Classification w Report up Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ A cc oun t C Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 020 -Capital Improvement Fuse EXPENSE Contractual Services .00 .00 .00 .00 .00 .00 .00 + ++ 19,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 68,469.03 114,442.69 95,730.63 500,426.68 30 80,210.64 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 10,603.91 13,954.80 132,542.54 174,349.66 46 77,721.21 Infrastructure 515,000.00 104,400.00 619,400.00 1,157.17 14,786.66 28,696.23 575,917.11 7 5,291.39 Interfund Transfers .00 . 00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $1,696,247.00 $194,600.00 $1,890,847.00 $80,230.11 $143,184.15 $256,969.40 $1,490,693.45 21% $182,355.84 Fund 020 - Capital Improvement Fund Totals $1,696,247.00 $194,600.00 $1,890,847.00 $80,230.11 $143,184.15 $256,969.40 $1,490,693.45 $182,355.84 w 4�- Account Classification Fund 021 Series 2009 Construction Fund EXPENSE Expense Budget by Account Classification Report Through 06/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 Redd 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 ln 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 ... $0.00 Fund 021 - SeFies 2009 Construction Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Expense Budget by Account Classification )L Report Through 06/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 Recd Prior Year YTD Fund 022 - Downtown Redeveiparit Construct EXPENSE Contractual Services 203,040.00 .00 203,040.00 6,192.88 113,161.49 18,836.14 71,042.37 65 12,522.16 Utilities .00 .00 .00 .00 .00 .00 AO + ++ .00 Other Expenditures 2,803,922.00 60,000.00 2,863,922.00 .00 .00 57,858.93 2,806,063.07 2 25,053.44 Infrastructure 115,000.00 240,000.00 355,000.00 .00 11,339.75 9,240.00 334,420.25 6 .00 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 EXPENSE TOTALS $ 3,121,962.00 $300,000.00 $3,421,962.00 $6,192.88 $124,501.24 $85,935.07 $3,211,525.69 6% $37,575.60 Fund 022 - Downtown Redevelopment Construct Totals $3,121,962.00 $300,000.00 $3,421,962.00 $6,192.88 $124,501.24 $85,935.07 $3,211,525.69 $37,575.60 to aN Expense Budget by Account Classification Adopted Budget Amended Current Month YTD Accou Classification Budget Amendments Budget Transactions Encumbrances Fund 023 - Street improvement Construc Fund EXPENSE Report Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Redd Prior Year YTD Contractual Services 30,600.00 41,000.00 71,600.00 .00 30,597.00 40,700.82 302.18 100 .00 Infrastructure 9,943,280.00 .00 9,943,280.00 2,295,856.80 4,990,915.36 4,049,051.32 903,313.32 91 367,553.19 Interrund Transfers .00 .00 .00 .00 .00 .00 . 00 . .00 EXPENSE TOTALS $9,973,880.00 $41,000.00 $10,014, $2,295,8 $5,021,512. $4,089,75 $903,615.50 91% $367,553.19 Fund 023 - Street Improvement Construc Fund Totals $9,973,880.00 $41,000.00 $10,014,880.00 $2,295,856.80 $5,021,512.36 $4,089,752.14 $903,615.50 $367,553.19 Expense Budget by Account Classification Report up Through 06/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 Recd Prior Year YTD EXPENSE Contractual Services Utilities Other Expenditures Other Equipment Infrastructure Fund .00 .00 .00 .00 .00 .00 .00 + ++ .00 1,000.00 .00 1,000.00 .00 .00 915.87 84.13 92 .00 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 1,000.00 .00 .00 .00 .00 .00 .00 .00 ... .00 10,805,000.00 83,800.00 10,888,800.00 30,084.68 188,309.86 209,104.89 10,491,385.25 4 101,930.72 EXPENSE TOTALS $10,811,000.00 $83,800.00 $10,894,800.00 $30,084.68 $188,309.86 $210,020.76 $10,496,469.38 4% $102,930.72 024 - Hood Control Construction Fund'Totals $10,811,000.00 $83,800.00 $10,894,800.00 $30,084.68 $188,309.86 $210,020.76 $10,496,469.38 $102,930.72 v OD Account Classification Fund 040 - Refuse Disposal Fund EXPENSE Expense Budget by Account Classification Report Through 06/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 Redd Prior Year YTD Personal Services, Scheduled Salaries & Wages 231,735.00 .00 231,735.00 17,746.43 .00 118,764.23 112,970.77 51 102,407.07 Employee Benefits 75,057.00 .00 75,057.00 8,044.27 .00 52,560.85 22,496.15 70 58,501.75 Other Employee Costs 1,224.00 .00 1,224.00 .00 .00 1,095.00 129.00 89 .00 Contractual Services 4,157,884.00 .00 4,157,884.00 348,065.40 12,412.15 1,883,302.10 2,262,169.75 46 1,893,262.49 Utilities 438.00 .00 438.00 53.10 .00 154.79 283.21 35 151.54 Insurance 28,640.00 .00 28,640.00 2,386.67 .00 14,320.02 14,319.98 50 14,119.50 Commodities & Supplies 31,295.00 .00 31,295.00 299.00 1,260.00 10,752.54 19,282.46 38 4,310.38 EXPENSE TOTALS $4,526,273.00 $0.00 $4,526,273.00 $376,594.87 $13,672.15 $2,080,949.53 $2,431,651.32 46% $2,072,752.73 Fund 040 - Refuse Disposal Fund Totals $4,526,273.00 $0.00 $4,526,273.00 $376,594.87 $13,672.15 $2,080,949.53 $2,431,651.32 $2,072,752.73 Expense Budget by Account Classification Report Through 06/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 041 - Motor Fuel Tax Fund EXPENSE Contractual Services 204,104.00 75,000.00 279,104.00 614.00 134,979.66 69,448.23 74,676.11 73 26,960.31 Utilities 153,000.00 .00 153,000.00 17,686.84 .00 91,165.77 61,834.23 60 60,433.31 Commodities & Supplies 284,796.00 .00 284,796.00 .00 26,944.69 216,890.32 40,960.99 86 147,195.10 Infrastructure 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,000.00 $1,631,900.00 $18,300.84 $161,924.35 $387,560.94 $1,082,414.71 34% $1,349,588.72 Fund 041 - Motor Fuel Tax Fund Totals $1,551,900.00 $80,000.00 $1,631,900.00 $18,300.84 $161,924.35 $387,560.94 $1,082,414.71 $1,349,588.72 0 F- 0 Expense Budget by Account Classification Report Adopted Budget Amended Current Month YTD Account Classification Budget Amendments Budget Transactions Encumbrances Fund 042 - Cmnity Development Block Grant EXPENSE Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 47,930.00 .00 47,930.00 4,626.64 .00 20,530.52 27,399.48 43 19,268.18 Employee Benefits 26,222.00 .00 26,222.00 2,176.48 .00 12,459.96 13,762.04 48 11,892.20 Other Employee Costs 1,020.00 .00 1,020.00 .00 .00 151.70 868.30 15 350.50 Contractual Services 97,520.00 23,250.00 120,770.00 5,311.93 .00 56,656.37 64,113.63 47 2,507.75 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 75.00 .00 1,895.00 232,026.00 1 108,825.60 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 .00 .00 20,000.00 0 .00 EXPENSE T9TALS $353,202.00 $97,171.00 $450,373.00 $12,190.05 $0.00 $91,693.55 $358,679.45 20% $142,955 Fund 042 - Cmmty Development Block Grant'l $353,202.00 $97,171,00 $450,373.00 $12,190.05 $0.00 $91,693.55 $358,679.45 $142,95 Expense Budget by Account Classification Report Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing Account Classification Adopted Budget Budget Amendments Amended Budget Current Month Transactions YTD Encumbrances YTD Transactions Budget - YTD % used/ Transactions Reed Prior Year YTD Fund 043 -Asset Seizure Fund EXPENSE Other Employee Costs 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Contractual Services 3,000.00 .00 3,000.00 .00 .00 1,500.00 1,500.00 so .00 Other Equipment 15,000.00 .00 15,000.00 .00 .00 1,642.29 13,357.71 11 5,735.00 EXPENSE TOTALS $19,000.00 $0.00 $19,000.00 $0.00 $0.00 $3,142.29 $15,857.71 17% $5,735.00 Fund 043 -Asset Seizure Fund Totals $19,000.00 $0.00 $19,000.00 $0.00 $0.00 $3,142.29 $15,857.71 $5,735.00 F- F- F- NJ Expense Budget by Account Classification Report MENEM= Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD HnO 044 - DEA Snared Funds Fund EXPENSE Contractual Services 1,000.00 M 1,000.00 .00 .00 .00 1,000.00 0 .00 Building Improvements .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 Expense Budget by Account Classification Report Account Classification Fund 0 - DUI Fine Fund EXPENSE Other Employee Costs Contractual Services Other Equipment Interfund Transfers Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Redd 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 + ++ 2,187.50 10,000.00 .00 10,000.00 2,671.31 .00 2,767.30 7,232.70 28 7,748.17 .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $11,000.00 $0.00 $11,000.00 $2,671.31 $0.00 $2,767.30 $8,232.70 25% $9,935.67 Fund 045 - DUI Fine Fund Totals $11,000.00 $0.00 $11,000.00 $2,671.31 $0.00 $2,767.30 $8,232.70 $9,935.67 LJ r Expense Budget by Account Classification UV Report Through 06/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 ur. 046 - Foreign Fire Tax Board Fund EXPENSE Contractual Services 10,000.00 .00 10,000.00 .00 .00 3,946.60 6,053.40 39 2,938.44 Insurance 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Commodities & Suppiies 5,000.00 .00 5,000.00 .00 .00 211.65 4,788.35 4 1,713.58 Other EduPpment 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 $0.00 $0,00 $15,846.25 $14,653.75 52% $13,729.02 Fund 046 - Foreign Fire Tax Bayard Fund Totals $30,500.00 $0.00 $30,500.00 $0.00 $0.00 $15,846.25 $14,653.75 $13,729.02 Expense Budget by Account Classification Report Account Clas5lfication Fund 047 - Justice Assistance Grant Fund EXPENSE Through 06/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 Redd 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 ... 471.84 Other Equipment .00 .00 .00 .00 .00 .00 .00 ... 66.66 Interfund 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 ... $538.50 Fund 047 - Justice Assistance Grant Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $538.50 F- U1 F_ CA Account Classification Fund 048 -business District Fund EXPENSE Expense Budget by Account Classification Report Through 06/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 Bond Principal .00 .00 .00 .00 .00 .00 .00 ... .00 Interest Expense 923,100.00 .00 923,100.00 .00 . 00 .00 923,100. 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. Fund 043 - Business District Fund Totals $923,100.00 $0.00 $923,100.00 $0.00 $0.00 $0.00 $923,100.00 $637,231.78 Expense Budget by Account Classification Report Account Classification Fund 050 ® Water and Sewer Fund EXPENSE Through 06/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 Personal Services, Scheduled Salaries & Wages 1,952,664.00 .00 1,952,664.00 155,384.47 .00 972,895.55 979,768.45 50 875,419.21 Employee Benefits 787,893.00 .00 787,893.00 58,985.49 .00 380,873.50 407,019.50 48 370,258.40 Other Employee Costs 36,660.00 .00 36,660.00 5,811.87 1,694.55 19,415.76 15,549.69 58 11,607.01 Contractual Services 7,457,412.00 32,500.00 7,489,912.00 678,823.10 341,712.83 3,397,830.96 3,750,368.21 50 3,002,274.13 Utilities 157,758.00 .00 157,758.00 15,387.71 .00 57,434.17 100,323.83 36 49,724.18 Insurance 80,474.00 .00 80,474.00 6,706.16 .00 40,236.96 40,237.04 50 39,691.50 Commodities & Supplies 295,722.00 .00 295,722.00 10,372.14 42,491.15 79,699.20 173,531.65 41 80,222.58 Other Expenditures .00 .00 .00 .00 .00 .00 .00 + ++ .00 Building Improvements 42,500.00 .00 42,500.00 .00 4,250.00 .00 38,250.00 10 .00 Office Equipment 1,370.00 .00 1,370.00 .00 .00 .00 1,370.00 0 .00 Other Equipment 1,244,200.00 1,563,500.00 2,807,700.00 123,702.84 2,055,578.21 204,882.84 547,238.95 81 93,152.41 Distribution Systems 2,075,000.00 581,500.00 2,656,500.00 13,765.83 1,168,192.64 43,427.82 1,444,879.54 46 310,430.84 Infrastructure .00 .00 .00 .00 .00 .00 .00 ... .00 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 $14,131,653.00 $2,177,500.00 $16,309,153.00 $1,068,939.61 $3,613,919.38 $5,196,696.76 $7,498,536.86 54% $4,832,780.26 Fund 050 - Water and Sewer Fund Totals $14,131,653.00 $2,177,500.00 $16,309,153.00 $1,068,939.61 $3,613,919.38 $5,196,696.76 $7,498,536.86 $4,832,780.26 r a I.- OD Account Classification Fund 051 . Village Parking System Fund EXPENSE Expense Budget by Account Classification Report Through 06/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 ersonaMervices, S e7e o i e - i arcs ages 35,788.00 .00 35,788.00 2,831.25 .00 17,762.82 18,025.18 so 10,223.24 Employee Benefits 17,796.00 .00 17,796.00 1,229.73 .00 7,537.94 10,258.06 42 4,340.92 Contractual Services 91,055.00 .00 91,055.00 4,346.61 5,798.08 30,320.36 54,936.56 40 41,716.45 Insurance 1,175.00 .00 1,175.00 97.92 .00 587.52 587.48 so 579.00 Commodities & Supplies 510.00 .00 510.00 .00 .00 .00 510.00 0 .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 ... .00 Building Improvements 6,936.00 .00 6,936.00 .00 2,750.80 .00 4,185.20 40 .00 Infrastructure 153,500.00 .00 153,500.00 .00 46,749.20 .00 106,750.80 30 875.00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $306,760.00 $0.00 $306,760.00 $8,505.51 $55,298.08 $56,208.64 $195,253.28 36% $57,734.61 Fund 051 - Village Parking System Frond Totals $306,760.00 $0.00 $306,760.00 $8,505.51 $55,298.08 $56,208.64 $195,253.28 $57,734.61 Expense Budget by Account Classification Report Account Classificatlon Fund 052 - Parking System Revenue Fu EXPENSE Through 06/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 Redd Prior Year YTD Personal Services, Scheduled Salaries & Wages 28,598.00 .00 28,598.00 2,072.59 .00 12,874.91 15,723.09 45 19,068.02 Employee Benefits 13,772.00 .00 13,772.00 918.83 .00 5,604.98 8,167.02 41 9,708.42 Contractual Services 110,954.00 .00 110,954.00 7,140.91 4,276.07 40,834.04 65,843.89 41 47,891.78 UtIlitles 10,523.00 .00 10,523.00 863.13 .00 3,541.97 6,981.03 34 2,871.32 Insurance 1,406.00 .00 1,406.00 117.17 .00 703.02 702.98 50 693.48 Commodities & Supplies 9,779.00 .00 9,779.00 .00 .00 6,195.65 3,583.35 63 3,300.43 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 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $250,032.00 $0.00 $250,032.00 $11,112.63 $4,276.07 $69,754.57 $176,001.36 30% $83,533.45 Fund 052 - Parking System Revenue Fund Totals $250,032.00 $0.00 $250,032.00 $11,112.63 $4,276.07 $69,754.57 $176,001.36 $83,533.45 r1j CD Account Classification . rund 060 ® Vehicle Maintenance Fund EXPENSE Expense Budget by Account Classification Report Through 06/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 Redd Prior Year YTD Personal Services, Scheduled Salaries & Wages 940,529.00 .00 940,529.00 67,991.21 .00 463,095.85 477,433.15 49 422,384.55 Employee Benefits 384,627.00 .00 384,627.00 26,927.38 .00 178,862.64 205,764.36 47 200,508.42 Other Employee Costs 2,361.00 .00 2,361.00 .00 .00 684.00 1,677.00 29 740.00 Contractual Services 100,738.00 .00 100,738.00 4,659.56 19,082.41 34,241.95 47,413.64 53 41,689.35 Utilities 3,070.00 .00 3,070.00 423.31 .00 1,201.59 1,868.41 39 1,832.27 Camrnodities & Supplies 701,081.00 .00 701,081.00 31,117.97 71,070.66 331,447.97 298,562.37 57 320,170.02 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 Offier Equipment 19,770.00 .00 19,770.00 520.13 14,845.00 870.13 4,054.87 79 .00 EXPENSE TOTALS $2,152,732,00 $0.00 $2,152,732.00 $131,639.56 $104,998.07 $1,010,537.12 $1,037,196.81 52% $987,324.61 Fund 060 - Vehicle Maintenance Fund Totals $2,152,732.00 $0.00 $2,152,732.00 $131,639.56 $104,998.07 $1,010,537.12 $1,037,196.81 $987,324.61 Expense Budget by Account Classification Report Account Classification Through 06/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 Fund 061- Vehicle Replacement Fund EXPENSE Other Expenditures .00 .00 .00 .00 .00 .00 .00 ... .00 Motor Equipment 1,614,000.00 163,700.00 1,777,700.00 2,778.74 812,427.94 726,606.84 238,665.22 87 216,807.21 Interrund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $1,614,000.00 $163,700.00 $1,777,700.00 $2,778.74 $812,427.94 $726,606.84 $238,665.22 87% $216,807.21 Fund 061 - Vehicle Replacement Fund Totals $1,614,000.00 $163,700.00 $1,777,700.00 $2,778.74 $812,427.94 $726,606.84 $238,665.22 $216,807.21 N K) t1j Account Classification Fund 062 - Computer Replacement Func EXPENSE Expense Budget by Account Classification Report Through 06/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 Redd Prior Year YTD Other Expenditures .00 .00 .00 '00 .00 .00 .00 + ++ .00 Office Equipment 247,480.00 .00 247,480.00 .00 .00 55,687.15 191,792.85 23 54,970.39 EXPENSE TOTALS $247,480.00 $0.00 $247,480.00 $0.00 $0.00 $55,687.15 $191,792.85 23% $54,970.39 Fund 062 - Computer Replacement Fund Totals $247,480.00 $0.00 $247,480.00 $0.00 $0.00 $55,687.15 $191,792.85 $54,970.39 Expense Budget by Account Classification Report Account Classification Through 06/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 Fund 063 - Risk Management Fund EXPENSE Contractual Services 27,000.00 .00 27,000.00 .00 .00 10,300.00 16,700.00 38 10,950.00 Insurance 7,812,938.00 .00 7,812,938.00 694,328.04 .00 4,039,364.61 3,773,573.39 52 3,677,636.93 Other Equipment 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 2,140.90 Infrastructure .00 .00 .00 .00 .00 .00 .00 ... .00 Into =rfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $7,844,938.00 $0.00 $7,844,938.00 $694,328.04 $0.00 $4,049,664.61 $3,795,273.39 52% $3,690,727.83 Fund 063 - disk Management Fund 'Totals $7,844,938.00 $0.00 $7,844,938.00 $694,328.04 $0,00 $4 $3,795,273.39 $3,690,727.83 N W Account Classification Fund 070 - Police Pension Fund EXPENSE Expense Budget by Account Classification Report Through 06/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 Redd Prior Year YTD Pension Benefits 3,937,366.00 .00 3,937,366.00 344,889.55 .00 1,973,660.75 1,963,705.25 50 1,915,272.42 ContraLtual Services 135,350.00 .00 135,350.00 6,190<61 .00 43,602.00 91,748.00 32 29,283.53 Insurance 15,000.00 .00 15,000.00 00 .00 .00 15,000.00 0 .00 Cornmoditles & Supplies 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 Other Expenclitureq 12,000.00 .00 12,000.00 ,00 .00 8,250.00 3,750,00 69 9,338.95 Office Equipment .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $4,099,816.00 $0.00 $4,099,816.00 $351,080.16 $0.00 $2,025,512.75 $2,074,303.25 49% $1,953,894.90 Fund 070 - Police Pension Fund Totals $4,099,816.00 $0.00 $4,099,816.00 $351,080.16 $0.00 $2,025,512.75 $2,074,303.25 $1,953,894.90 Account Classification Expense Budget by Account Classification Report Through 06/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactons Encumbrances Transactions Transactions Recd Prior Year YTD Fund 071 - Fire Pension (Fund EXPENSE Pension Benefits Contractual Services Insurance Commodities & Supplies Other Expenditures 4,021,161.00 .00 4,021,161.00 340,841.23 .00 2,064,411.66 1,956,749.34 51 1,933,706.65 124,600.00 .00 124,600.00 953.17 .00 45,373.11 79,226.89 36 37,060.11 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 .00 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 32.22 12,000 . 00 12,000.00 .00 .00 8,000.00 4,000.00 67 8,457.93 EXPENSE TOTALS $4,173,761.00 $0.00 $4,173,761.00 $341,794.40 $U .UU 1,11I $2,0)5,`MZJ Sl'yo �1,919,[5b.91 Fund 071 - Fire Pension Fund Totals $4,173,761.00 $0.00 $4,173,761.00 $341,794.40 $0.00 $2,117,784.77 $2,055,976.23 $1,979,256.91 Grand ToWis $116,983,802,00 $3,339,419.00 $120,323,221,00 $8,860.,362.64 $10,978,724.47 $45,O26,610.39 $64,317,886.14 $40,114,007.73 N Ln VILLAGE OF MOUNT PROSPECT List of Bills June 26 - July 09, 2014 Fund Vendor Name Invoice Description Amount 001 General Fund A Stars & Stripes Flag Corporation Special Events Supplies $ 359.80 Accutrack Recording & Sound, Inc. Special Events Supplies 48.00 Special Events Supplies 261.82 ACS State & Local Government Solutions Illinois State Disbursement Unit 3,379.60 Active Alarm Company, Inc. Service call for Investigations' cameras 210.00 Amer Reprographics Co Llc Equipment Maintenance 62.00 American Landscaping Inc. Grass Cutting - 311 S. Main 263.00 Grass cutting - 2 N. Main 150.00 American Soccer Company, Inc. Jerseys for Kickin' it with the Cops Program 298.71 American Solutions For Business Parking tickets 2,317.43 Andres Medical Billing, Ltd. Ambulance Billing - June 2014 5,278.03 Angarola, Michael Reimburse training expenses 32.00 Aramark Uniform Services, Inc. Uniform rental and cleaning for all public works employees 116.22 Rental and uniform cleaning for all Public Works employees 116.22 Uniform Cleaning and Rental 133.22 Arlington Heights Park District Refund Plan Review Permit # 14 -0923 50.00 Associated Attractions Ent. Inc 4th of July Parade 2014 200.00 AT & T Service 6/16/14 - 7/15/14 714.17 Service 7/16/14 - 7/15/14 341.65 Bechtold, Mark Reimburse training expenses 40.00 Bedco Mechanical Emergency services to HVAC unit at Public Works 345.00 TXV valve replaced on HVAC unit at Public Works 1,612.55 Blue Saints Drum & Bugle Corps 4th of July Parade 2014 1,600.00 Bright Electrical Supply Co. Light bulbs for replacement and stock 289.06 Carlson, David J Reimburse training courses 40.00 Case Lots, Inc. Custodial Supplies 390.00 CDW Government, Inc. Office Supplies 97.71 Century Cleaners Uniform Cleaning 18.68 Uniform Cleaning 14.12 Uniform Cleaning 14.58 Uniform Cleaning 14.13 Uniform Cleaning 16.85 Uniform Cleaning 16.40 Uniform Cleaning 14.58 Uniform Cleaning 14.58 Uniform Cleaning 20.95 Uniform Cleaning 18.68 Chem -wise Ecological Pest Mgmt Inc Equipment Maintenance and Repair 215.00 Equipment Maintenance and Repair 215.00 Chicago Title Insurance Properly Address : 740 East Rand Road 2,000.00 Property Address : 720 East Rand Road 1,500.00 Property Address : 700 East Rand Road 1,500.00 CIGNA Health and Life Insurance Company Refund for Ambulance Services - James Pena 10/25/13 448.87 CL Graphics, Inc. Postage Prep Summer Newsletter 2014 390.00 Summer Newsletter 2014 Printing 8,678.00 Commonwealth Edison Electrical Service Delivery 17.80 Community College District 502 Training DVD: Active Shooter 495.00 Conrad Polygraph, Incorporated Polygraph for New Hire Fiedler 160.00 Constellation NewEnergy, Inc. Electrical Service Delivery 156.92 Electrical Service Delivery 29.42 Electrical Service Delivery 29.42 Electrical Service Delivery 29.48 Cornejo, Francisco Reimburse training expenses 32.00 Page 1 of 12 VILLAGE OF MOUNT PROSPECT List of Bills June 26 - July 09, 2014 Fund Vendor Name Invoice Description Amount Crystal Court Shopping Center August rent for the CCC 5,723.03 Crystal Maintenance Services Corp. Special cleaning at the VH after carpeting & painting projects 480.64 Cleaning services in all buildings for the month of July 7,181.81 CVS Pharmacy, Inc. Prisoner medication (14- 6208B, 7437 & 8220) 91.33 Dawson, Henry Storage for Chrome Plate Axes (Honor Guard) 129.97 Storage for Chrome Plate Pike Rogs (Honor Guard) 69.99 De Lage Landen Financial Services, Inc. Copier Lease Payment 1,690.20 CCC Copier Monthly Lease 260.55 Dundee Scottish Pipe Band 4th of July Parade 2014 1,000.00 Elite Remodeling Group, Inc. Garnishment 142.22 Emergency Medical Products Peds splints 16.62 MRx batteries 664.00 Enterprise Rent -a -car SIU vehicle rental 04/29- 06/27/14 1,241.18 Experian Pre - employment background checks - June, 2014 77.72 Fire Pension Fund Fire Pension 22,328.11 Force Science Institute, Ltd. Register 2 officers for training course 3,000.00 Forestry Suppliers Inc. Other Equipment 274.13 Frizane, Kenneth 4th of July Parade 2014 350.00 G.H. Woodworking and Sawmill Professional Services 425.00 Garofalo, Lisa Refund Overpayment Vehicle License Fee 27.00 Garvey's Office Products Office Supplies 143.21 Office Supplies 48.00 Office Supplies 299.60 Grainger Inc. Maintenance and repair supplies 18.29 Grainger Invoice 193.73 Custodial Supplies 108.55 Special Events Supplies 58.37 Extension Cords for Bus 70.16 Special Events Supplies 112.91 Grainger Invoice 70.84 Griffin, Timothy Refreshments for Outlaw funeral strategic planning 67.51 Guardian Emp. Dental Plan July 2014 9,149.27 Guitar Center Stores, Inc. Special Events Supplies 616.00 Halim, Fakher Refund Overpayment Police Ticket # C61060 20.00 Healy Asphalt Company,llc. Asphalt material used for street patching 54.95 Asphalt materials used for street patching 116.33 Asphalt material used for street patching 233.64 Street Patching Materials 47.03 Street Patching Materials 42.08 Street Patching Materials 45.05 Asphalt material used for street patching 54.45 Asphalt material used for street patching 158.40 Street Patching Materials 67.82 Street Patching Materials 144.54 Hernandez, Philip Reimburse Basic Recruit Academy 03/31- 06/20/14 480.00 Home Depot U.S.A., Inc. Maintenance and repair supplies 318.17 Homer Tree Care, Inc. Tree Removals 3,168.15 Tree Removals 3,340.00 Tree Removals 2,274.15 Tree Removals 4,527.50 Tree Removals 956.00 Tree Removals 2,955.00 Tree Removals 5,067.50 Tree Removals 3,351.00 Tree Removals 2,598.60 Tree Removals 3,231.75 Tree Removals 5,383.75 Page 2of12 VILLAGE OF MOUNT PROSPECT List of Bills June 26 - July 09, 2014 Fund Vendor Name Invoice Description Amount Homer Tree Care, Inc. Tree Removals 1,275.00 Tree Removals 4,539.70 Grounds Maintenance 610.00 Hoskinson, Thomas Reimburse training expenses 40.00 Huffman, William W. Spring 2014 Parkway Tree Planting 30,566.25 Spring 2014 Parkway Tree Planting 300.00 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 19,026.10 Illinois American Water Company Private Fire Service 7/2/14 - 7/31/14 33.84 Illinois Chamber of Commerce Annual Business leader luncheon tickets 1,639.00 Illinois Convenience & Safety Corp Block Party 2014 Bus Poster 395.00 Illinois Department of Revenue IL State Withholding 71.56 IL State Withholding 29.18 IL State Withholding 35.71 IL State Withholding 37,772.18 Garnishment II 154.93 IL State Withholding 29.18 IL State Withholding 27.60 Illinois EPA IEPA- Required Fee 1,000.00 Illinois Homicide Investigators Association Register T. Hoskinson for Annual training conference 10/13 -15/14 195.00 Illinois Municipal Retirement Fund Accelerated Payment - Sandra M Clark 15,318.08 Illinois Region - Marc 4th of July Parade 2014 330.00 IMRF IMRF 160,451.84 Indyk, Grzegorz & Olga Transfer Stamp Rebate 450.00 Internal Revenue Service Federal Withholding 426.83 Federal Withholding 464.70 Federal Withholding 162.80 Federal Withholding 178.57 Federal Withholding 178,439.84 Federal Withholding 162.82 International Union of Operating Engineers IUOE PW Membership Dues 1,028.52 Irish News Inc. Irish Fest Ad 2014 600.00 J.F. New & Associates, Inc. Professional Services 508.00 Jakupovic, Kristina Travel and Meeting Expenses 254.00 Training Expenses 19.25 Journal & Topics Newspapers 2013 Treasurer's Report 1,025.00 Karlstedt Landscape Group, Inc. Forestry Tree /Bush /Flower Replacement 950.00 Parkway Restoration 297.29 Kowalczyk, Michele Supplies for Wisniewski Retirement Party 74.66 Kramer Tree Specialists Tree Trimming 663.00 Law Enforcement Records Managers of Illinois Membership renewal: M. Pickett 25.00 LeClere, Thomas Safety Shoe Allowance 163.48 Life Assist Emergency Blankets 204.00 Oxygen Regulators 236.46 Maclin, Wendell 4th of July Parade 2014 1,500.00 Malek, Mariusz Refund Plumbing Permit Cancelled # 140893 33.00 Mario Gambino & Sons Landscaping Other Equipment 500.00 Metro Door and Dock, Inc. Overhead door repair 302.50 Overhead door repair 247.50 Equipment Maintenance and Repair 317.08 Building Maintenance Supplies 275.00 Metro Federal Credit Union MP Fire Local 4119 Dues 2,318.11 Metropolitan Alliance - Police MP Police Association Dues 1,311.50 Milieu Design LLC Landscape Maintenance 2,840.30 Mobile Print Inc. Summer Events Sign Front Lobby 2014 105.73 Mobile Print Inc. Business Cards - Intern 54.32 Printing: Chief's letterhead 213.40 Printing: memo pads & business cards for various employees 486.94 Page 3 of 12 VILLAGE OF MOUNT PROSPECT List of Bills June 26 - July 09, 2014 Fund Vendor Name Invoice Description Amount Mount Prospect Paint, Inc. Building Maintenance 108.98 Building Maintenance 123.08 Building Maintenance Supplies 44.95 Mount Prospect Park District 4th of July Parade 2014 350.00 Mr. Beef & Pizza of Mt. Prospect Refreshments for Outlaw funeral detail 06/28/14 508.75 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 37,527.62 NCPERS Group Life Ins. IMRF Life Insurance 665.60 Nemerow, Jason Reimburse training expenses 32.00 Neopost USA Inc. Postage Machine Replenishment - 06/26/14 3,000.00 New Generation Fancy Drill Team 4th of July Parade 2014 2,500.00 Nichols, Keith CDL Reimbursement 30.00 NICOR Natural Gas Consumption 23.17 Natural Gas Consumption 26.61 Natural Gas Consumption 27.50 Natural Gas Consumption 178.84 Natural Gas Consumption 1,955.47 Natural Gas Consumption 119.46 Natural Gas Consumption 405.07 Natural Gas Consumption 269.59 Northern Tool & Equipment Company, Inc. 3 Ton floor jack 278.68 Northshore University Healthsystem Vaccination: J. Henderson 41.00 Pre - employment physical: E. Nordin 860.00 Pre - employment physical: E. Knippel 621.00 Pre - employment physical: B. Giera 860.00 Northwest Central Dispatch System August 2014 - Member Assessment 56,811.12 Northwest Electrical Supply Maintenance and repair supplies 164.83 Building Maintenance Supplies 160.38 Northwest Suburban United Way United Way 243.64 Pacific Telemanagement Services Period 7/1/14 - 7/31/14 78.00 Paddock Publications, Inc. Bid Notice 59.40 Bid Notice 47.25 Legal notice PZ -14 -14 95.85 Legal notice PZ -16 -14 89.10 Legal notice PZ -17 -14 87.75 Legal notice PZ -19 -14 101.25 Paul Hall Community Center 4th of July Parade 2014 900.00 Petty Cash Metra Tickets 6/25/14 1,417.00 Petty Cash - 6/5/14 - 6/25/14 886.14 Petty Cash - Finance 128.62 Phoenix Irrigation Supply Inc Other Equipment /Sprinkler System 43.92 Police Pension Fund Police Pension 29,417.80 Pope, Jill Friedrichs Renew PO Box 2014 62.00 Prairie Brass Band 4th of July Parade 2014 2,000.00 Proviso West High School Marching Band 4th of July Parade 2014 1,000.00 RC Topsoil Inc. Restoration Materials 653.40 Ricmar Industries, Inc. Custodial supplies to be used in all buildings 742.00 Roger C. Merriman Headsets for Customer Service 1,556.90 Russo Power Equipment Grounds Maintenance Supplies 180.00 Sanches, Jose Refund Overpayment Police Ticket # P3930943 10.00 Saric, Ognjen Reimburse Basic Recruit Academy 03/31- 06/20/14 480.00 Schwartz, Steven G Permit Cancelled # 140102 50.00 Signs By Tomorrow Special Events Supplies 702.00 Sound Incorporated July maint agreement for phones, switches and servers 72.00 Staples Contract & Commercial, Inc. Banner for ChiefJanowick's promotion reception 55.99 State of Illinois Monthly Internet Fees 1,166.25 Steiner Electric Company Street light supplies 80.42 Swank Motion Pictures, Inc. Rental of Enders Game 100.00 Page 4 of 12 VILLAGE OF MOUNT PROSPECT List of Bills June 26 - July 09, 2014 Fund Vendor Name Invoice Descriotion Symbolarts, LLC. Officers' shirt badges #276 & 277 Systems Forms, Inc. Printing 4,400 Inspection Report Forms Taylor Rental Center Maintenance and repair supplies Taylor, Jeffrey Reimburse training expenses Tee Jay Service Company, Inc. Equipment Maintenance and Repair The Cook County State's Attorney's Regional Organi Register J. Juhl for Annual Training Conference 09/04 -05/14 The Ups Store Theodore Polygraph Service Inc. Third Millennium Assoc.inc. Thompson Elevator Inspections Township High School Dist. 214 Traffic and Parking Control Co, Inc. TransUnion Risk and Alternative Data Solutions In Trugreen Limited Partnership U.S. Bank Equipment Finance, Inc. Uline Inc. United Health Care 1 Vantagepoint Transfer Agents VCG Uniform Verizon Wireless Services LLC Vidakovic, Rado Village of Mount Prospect Village of Romeoville W.S. Darley & Co. Wagner, John R. Walega, Joseph A Wal -Mart Community Warehouse Direct WGN Flag & Decorating Co. Wisconsin Department of Revenue WISCTF Witmer Public Safety Group, Inc. Wulbecker, Jeffrey Z Search Recruiting, Inc. Register D. 011ech for Annual Training Conference 09/04 -05/14 KTJ mailing Pre - employment testing: Polygraphs for 3 new officers Post Lockbox Fulfillment Elevator Inspections Elevator Inspections Elevator Inspections Elevator Inspections 4th of July Parade 2014 Sign Making Materials Inc Background checks - June, 2014 Contractual Contract Spraying Contractual Contract Spraying PW Copy 1 Lease Payment Fire Sta. #12 Lease Payment Gatorade for Lions Carnival detail Refund Ambulance Services - Elizabeth Sorensen 12/4/13 RHS M. Semkiu 7/3/14 payroll RHS D. Wisniewski 7/3/14 payroll Uniform supplies: CSO Arciszewski Body armor: R. Nava Body armor: M. Angarola Body armor: Z. Falco Cellular Service & Equipment Charges Refund Overpayment Police Ticket # P3931614 Flex - Medical Haz Mat Registration- Murphy 8 Large fire hoses Reimburse expenses: New recruit lunch 4th of July Parade 2014 Office Supplies Clipboard, paper, interoffice envelopes, labels Stapler for station 12, colored file folders 3 Packages of Mailing Labels 5AA, 5AAA, 6C Batteries Toner for Report Room Parade supplies for the 4th of July WI State Withholding Garnishment Helmet Shield for BC Engineering Supplies Professional Services Friday on the Green Concert June 20 2014 001 General Fund Total 020 Capital Improvement Fund All American Commerical Roofing Inc. Christopher B. Burke Engineering Ltd Public Building Improvements Building Maintenance Release Retainage Job ID# 17130640 Street Light Improvements Page 5of12 Amount 150.00 449.68 35.80 32.00 200.00 80.00 80.00 14.21 525.00 18,417.15 150.00 962.00 37.00 75.00 2,000.00 138.40 110.50 5,259.25 517.75 167.50 138.78 111.63 51.91 42,958.99 32,085.68 165.95 800.00 800.00 800.00 6,020.13 30.00 8,669.60 555.00 4,271.60 30.55 850.00 254.73 168.62 82.52 32.12 180.49 135.84 1,597.00 439.07 542.48 173.99 38.14 150.00 100.00 $ 882,088.64 $ 1,078.00 19,856.10 38,934.57 1,157.17 VILLAGE OF MOUNT PROSPECT List of Bills June 26 - July 09, 2014 Fund Vendor Name Invoice Description Amount Northwest Central 9 -1 -1 System Motorola Subscriber Financing - July 2014 10,603.91 020 Capital Improvement Fund Total $ 71,629.75 022 Downtown Redevelopment Construction Fund Milieu Design LLC Landscape Maintenance 022 Downtown Redevelopment Construction Fund Total 023 Street Improvement Construction Fund $ 6,192.88 $ 6,192.88 Arrow Road Construction 2014 Street Resurfacing $ 1,104,547.13 Baxter & Woodman, Inc. Street Resurfacing Project 12,347.50 CL Graphics, Inc. Street Resurfacing Project 247.01 023 Street Improvement Construction Fund Total $ 1,117,141.64 024 Flood Control Construction Fund ICMA 457 (flat percent) Ciorba Group Inc Flood Improvements $ 1,556.88 Constellation NewEnergy, Inc. Electrical Service Delivery 95.91 IMRF Electrical Service Delivery 176.48 Internal Revenue Service Electrical Service Delivery 78.67 024 Flood Control Construction Fund Total International Union of Operating Engineers $ 1,907.94 040 Refuse Disposal Fund ARC Disposal Company Debris Disposal $ 92.95 AT & T Service 6/16/14 - 7/15/14 3.97 Groot Industries, Inc. Debris Disposal 1,012.50 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 45.20 Illinois Department of Revenue IL State Withholding 374.00 IMRF IMRF 2,954.82 Internal Revenue Service Federal Withholding 2,531.59 International Union of Operating Engineers IUOE PW Membership Dues 99.23 Jakupovic, Kristina Travel and Meeting Expenses 129.00 Menards Maintenance and repair supplies 339.64 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 110.00 NCPERS Group Life Ins. IMRF Life Insurance 17.60 Northwest Suburban United Way United Way 3.85 Village of Mount Prospect Flex - Medical 79.38 040 Refuse Disposal Fund Total $ 7,793.73 041 Motor Fuel Tax Fund Commonwealth Edison Electrical Service Delivery $ 97.65 Constellation NewEnergy, Inc. Electrical Service Delivery 180.91 Electrical Service Delivery 258.82 Electrical Service Delivery 185.14 Electrical Service Delivery 107.01 Electrical Service Delivery 121.88 Electrical Service Delivery 22.44 Electrical Service Delivery 107.07 Electrical Service Delivery 26.04 Electrical Service Delivery 1,936.32 Electrical Service Delivery 87.84 Electrical Service Delivery 50.58 Electrical Service Delivery 190.50 Constellation NewEnergy, Inc. Electrical Service Delivery 94.55 Electrical Service Delivery 56.20 Lyons & Pinner Electric Companies Traffic Light Maintenance 170.00 Morton Salt, Inc Road salt used for snow and ice control 1,149.21 Road salt used for snow and ice control 13,420 041 Motor Fuel Tax Fund Total $ 18,262.38 Page 6 of 12 VILLAGE OF MOUNT PROSPECT List of Bills June 26 - July 09, 2014 Fund Vendor Name Invoice Description Amount 042 Community Development Block Grant De Lage Landen Financial Services, Inc. Copier Lease Payment $ 94.80 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 112.50 Illinois Department of Revenue IL State Withholding 103.48 IMRF IMRF 545.98 Internal Revenue Service Federal Withholding 621.30 Village of Mount Prospect Flex - Medical 78.13 042 Community Development Block Grant Total $ 1,556.19 050 Water and Sewer Fund Aramark Uniform Services, Inc. Uniform rental and cleaning for all public works employees $ 116.23 Rental and uniform cleaning for all Public Works employees 116.23 Uniform Cleaning and Rental 133.23 AT&T Service 6/16/14 - 7/15/14 265.21 Badger Meter Inc AMR /AMI System 14,421.12 AMR /AMI System 6,572.40 Baxter & Woodman, Inc. Professional Services 870.00 Burns & Mcdonnell Engineering Co. Professional Services 680.00 Emergency Generators 2,640.28 Carmelo Blacconiere Utility Refund - 62 N Albers: St 5.23 Century Cleaners Uniform Cleaning 18.67 Uniform Cleaning 14.13 Uniform Cleaning 14.57 Uniform Cleaning 14.12 Uniform Cleaning 16.85 Uniform Cleaning 16.40 Uniform Cleaning 14.57 Uniform Cleaning 14.57 Uniform Cleaning 20.95 Uniform Cleaning 18.67 Compass RE Services Utility Refund - 9 S Emerson St 15.60 Utility Refund -13 S Emerson St # A 25.65 Daniel Puzerewski Utility Refund - 215 Stevenson Ln 1.82 Defranco Plumbing Backflow program 2,250.00 Eaton Corporation Building Maintenance and Repair 800.00 Fehr - Graham & Associates LLC Training Expenses 1,760.00 Fredriksen Fire Equipment Co., Inc. Repair Maintenance Supplies 79.20 Garvey's Office Products Office Supplies 175.80 Office Supplies 48.00 Grainger Inc. Repair Maintenance Supplies 108.89 Water System Treatment Chemicals 293.44 HBK Water Meter Service Water Meter Installations 25.40 Water Meter Installations 25.40 Water Meter Installations 41.00 HD Supply Waterworks, Ltd. Repair Maintenance Supplies 740.40 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 1,295.06 Illini Power Products Company Equipment maintenance supplies 1,035.50 Equipment maintenance supplies 2,117.50 Equipment maintenance supplies 1,243.83 Page 7 of 12 VILLAGE OF MOUNT PROSPECT List of Bills June 26 - July 09, 2014 Fund Vendor Name Invoice Description Amount Illini Power Products Company Equipment maintenance supplies 665.00 Equipment maintenance supplies 1,598.00 Equipment maintenance supplies 1,598.00 Equipment maintenance supplies 890.00 Equipment maintenance supplies 890.00 Equipment maintenance supplies 961.50 Equipment maintenance supplies 921.50 Equipment maintenance supplies 921.50 Equipment maintenance supplies 925.00 Illinois Department of Revenue IL State Withholding 3,479.69 Illinois EPA IEPA Required Fee 20,000.00 IMRF IMRF 24,757.60 Internal Revenue Service Federal Withholding 21,685.12 International Union of Operating Engineers IUOE PW Membership Dues 932.91 Jones, Daniel G. Membership Dues 10.00 Karlstedt Landscape Group, Inc. Parkway Restoration 2,809.21 Kramer Datapower, Inc. Repair Maintenance Supplies 1,510.00 L & B Business Services Inc. Maintenance Supplies 17.94 Martam Construction Contractual Hauling 1,214.88 Restoration Materials 3,722.09 Restoration Materials 2,217.17 Milieu Design LLC Landscape Maintenance 2,991.82 Mobile Print Inc. Professional Services 38.34 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 420.89 NCPERS Group Life Ins. IMRF Life Insurance 52.80 NH Environmental Group, Inc. Sewer Contractual Services 1,500.00 Sewer Contractual Services Sewer Cleaning 1,500.00 NICOR Natural Gas Consumption 78.71 Natural Gas Consumption 134.03 Natural Gas Consumption 90.57 Natural Gas Consumption 88.77 Natural Gas Consumption 74.97 Natural Gas Consumption 163.69 Northwest Suburban United Way United Way 34.73 Paddock Publications, Inc. Bid Notice 64.80 Prosafety, Inc. Repair Maintenance Supplies 210.00 Quill Corporation Office Supplies 194.98 R. A. Stavoe Utility Refund - 208 S Pine St 992.78 Raymond E. Rauba Utility Refund - 710 S Busse Rd 195.09 RC Topsoil Inc. Restoration Materials 336.60 Robinson Engineering, Ltd. Professional Services 808.75 Signs By Tomorrow Sign Making for AMR 452.50 Suburban Laboratories, Inc. Water Sample Testing 503.00 Water Sample Testing 682.00 Tank Industry Consultants, Inc. Tank Repair Rehab 5,549.01 Tank Repair Rehab 3,734.27 Tank Repair Rehab 3,855.76 Tank Repair Rehab 4,677.82 Third Millennium Assoc.inc. June 2014 - Utility Billing 3,181.80 Tower Works, Inc. Elevated Water Tank Repair 320.00 U.S. Bank Equipment Finance, Inc. PW Copy 1 Lease Payment 167.50 Verizon Wireless Services LLC Cellular Service & Equipment Charges 466.57 Village of Mount Prospect Flex - Medical 625.45 Water Products Company of Aurora, Inc. Sewer Improvements 695.50 Ziebell Water Service Products Repair Maintenance Supplies 614.16 Repair Maintenance Supplies 4,381.30 050 Water and Sewer Fund Total $ 169,671.99 Page 8 of 12 Fund Vendor Name 051 Village Parking System Fund Crystal Maintenance Services Corp. Elite Remodeling Group, Inc. ICMA Retirement Trust - 457 Illinois Convenience & Safety Corp Illinois Department of Revenue IMRF Internal Revenue Service International Union of Operating Engineers Nationwide Mutual Insurance Company Petty Cash Village of Mount Prospect 051 Village Parking System Fund Total 052 Parking System Revenue Fund Constellation NewEnergy, Inc. Crystal Maintenance Services Corp. Elite Remodeling Group, Inc. ICMA Retirement Trust - 457 Illinois Department of Revenue IMRF Internal Revenue Service International Union of Operating Engineers Nationwide Mutual Insurance Company NICOR Petty Cash Village of Mount Prospect 052 Parking System Revenue Fund Total 060 Vehicle Maintenance Fund American Messaging Arlington Heights Ford Arlington Power Equipment AT &T Atlas Bobcat Inc. Brake Align Company Busse Car Wash, Inc. Certified Fleet Services, Inc. Chicago Parts & Sound Llc VILLAGE OF MOUNT PROSPECT List of Bills June 26 - July 09, 2014 Invoice Description Amount Special cleaning at the VH after carpeting & painting projects $ 21.32 Cleaning services in all buildings for the month of July 318.57 Garnishment 78.22 ICMA 457 (flat percent) 6.00 Easy Park Posters 170.00 IL State Withholding 55.03 Garnishment II 85.21 IMRF 471.36 Federal Withholding 337.25 IUOE PW Membership Dues 15.21 Nationwide 457 (flat percent) 9.96 Petty Cash - Finance 5.00 Flex - Medical 34.65 $ 1,607.78 Electrical Service Delivery $ 105.27 Electrical Service Delivery 248.02 Electrical Service Delivery 243.36 Electrical Service Delivery 105.16 Special cleaning at the VH after carpeting & painting projects 18.04 Cleaning services in all buildings for the month of July 269.62 Garnishment 63.99 ICMA 457 (flat percent) 4.00 IL State Withholding 39.73 Garnishment II 69.72 IMRF 345.14 Federal Withholding 242.47 IUOE PW Membership Dues 10.17 Nationwide 457 (flat percent) 6.65 Natural Gas Consumption 109.61 Petty Cash - Finance 3.00 Flex - Medical 27.43 $ 1,911.38 Pager rentals $ 73.91 P -2 Fuel filler tube 174.98 524 HVAC motor 46.76 314 Transmission filter 28.57 Vehicle Maintenance Supplies 114.70 Vehicle Maintenance Supplies 8.24 Vehicle Maintenance Supplies 8.24 Vehicle Maintenance Supplies 45.25 Service 6/16/14 - 7/15/14 9.93 Vehicle Maintenance Supplies 333.08 Equipment Maintenance and Repair 212.97 58 Ext car washes & 39 full car washes 602.00 Vehicle Maintenance Supplies 278.49 2722 Front /rear brake pads /rotors 469.88 P -21 Thermostat housing 33.97 Fuel Filters 138.00 Battery 100.33 Vehicle Maintenance Supplies 501.65 Diesel exhaust fluid, engine oil 331.04 Page 9of12 VILLAGE OF MOUNT PROSPECT List of Bills June 26 - July 09, 2014 Fund Vendor Name Invoice Description Amount Chicago Parts & Sound Llc Vehicle Maintenance Supplies 90.44 P -1 Spark plugs 60.48 Computerized Fleet Analysis Equipment Maintenance and Repair 895.00 General Parts Inc. 526 Ball joints 167.66 P -39 Lower ball joint 52.70 Global Emergency Products 530 Water tank level sensor 267.59 530 Hydraulic Filters 362.61 Grossinger Chevrolet 2751 Exhaust gasket 12.34 4526 Front suspension bumpers 57.84 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 556.50 Illinois Department of Revenue IL State Withholding 1,464.41 IMRF IMRF 11,088.77 Inland Power Group Inc. 4512 Transmission cover 5.08 Internal Revenue Service Federal Withholding 8,863.74 International Union of Operating Engineers IUOE PW Membership Dues 474.38 Keystone Automotive Industries, Inc. 2740 Radiator 648.00 Leach Enterprises, Inc. Vehicle Maintenance Supplies 566.77 Vehicle Maintenance Supplies 220.98 Mcmaster -carr Supply Co. Washers and wire 133.39 530 Ladder grease 115.10 Napa- Heights Automotive Supply Epoxy, JB Weld 46.64 2722 Wheel seals 11.14 P21 Rear wipers 9.58 1 -32 Exhaust 178.31 2734 Drain plug 4.68 2749 U- joints 52.43 2749 U joint 22.49 NCPERS Group Life Ins. IMRF Life Insurance 48.00 Northwest Suburban United Way United Way 3.85 Petroliance, LLC. Vehicle Maintenance Supplies 259.50 Pomp's Tire Service, Inc. Vehicle Maintenance Supplies 456.12 4550 rear tires 1,616.48 2719 Flat repair 142.00 Precision Service & Parts 4540 Reman engine 2,870.00 P -52 02 sensor 41.96 2709 DRL socket 43.34 P -21 Thermostat and gaskets 43.84 4503 Rear brake calipers 218.32 P -7 Sway bar links 91.92 P -38 Blower motor 44.03 Vehicle Maintenance Supplies 225.68 526 OEM Starter 414.85 309 Blower motor 44.03 Quill Corporation Office Supplies 44.99 Ronco Industrial Supply Vehicle Maintenance Supplies 247.43 Rush Truck Centers of Illinois, Inc. 4513 Keys 4.68 2750 Exhaust Pipe 89.73 Vehicle Maintenance Supplies 1,959.33 2750 Exhaust pipe and clamp 123.44 4513 Keys 4.68 Vehicle Maintenance Supplies (89.73) Sid Tool Co., Inc. Bolts, nuts, roll pins, heat shrink, cable ties, tape and washer 420.72 Nuts, bolts, washers, pins 479.05 Standard Equipment Company 2750 Rodder Hose 1,272.87 Vehicle Maintenance Supplies (281.03) Standard Industrial Auto Equip Equipment Maintenance and Repair 815.56 Suburban Accents Inc Other supplies 450.00 The Standard Companies Vehicle Maintenance Supplies 557.10 Page 10 of 12 VILLAGE OF MOUNT PROSPECT List of Bills June 26 - July 09, 2014 Fund Vendor Name Invoice Description Amount Verizon Wireless Services LLC Cellular Service & Equipment Charges 146.76 Village of Mount Prospect Flex - Medical 195.84 Wholesale Direct Inc. Vehicle Maintenance Supplies 227.01 060 Vehicle Maintenance Fund Total $ 43,173.39 063 Risk Management Fund Azarjew, Ewa S Reimbursement Mailbox Damaged by Snow Removal Operations $ 125.00 International Union of Operating Engineers Wagner - Family Coverage May -July 2014 3,150.00 John, Gus Reimbursement Mailbox Damaged by Snow Removal Operations 84.94 Municipal Claims and Safety Agreement Installment 2 2014 14,954.00 063 Risk Management Fund Total $ 18,313.94 070 Police Pension Fund Internal Revenue Service Federal Withholding $ 41,593.61 Reimer & Karlson LLC Legal Services Rendered May 2014 1,861.74 070 Police Pension Fund Total $ 43,455.35 071 Fire Pension Fund Bogdahn Consulting, LLC Performance Evaluation and Consulting Services 7/1/14- 10/31/14 $ 9,000.00 Buffalo Grove Orthopaedic Associates Medical Exam -Jeffrey Ricker (6/16/14) 1,000.00 Collins & Radja 2nd Quarter Retainer 2014 (April, May, June) 800.00 Internal Revenue Service Federal Withholding 38,992.40 Lutheran General Hospital Medical Exam - Eric Mertes (02/14/14) 178.00 The Center for Sports Orthopaedics, S.C. Medical Exam - Eric Mertes Report (5/8/14) 200.00 071 Fire Pension Fund Total $ 50,170.40 073 Escrow Deposit Fund A Moises Landscaping Refund Escrow Permit # 14 -0895 (503 S William St) $ 150.00 Alpha & Omega Concrete Inc Refund Escrow Permit # 0511787 19,500.00 ARS of Illinois Refund Escrow Permit # 14 -1115 (303 S Waverly PI) 125.00 Borre, Kenneth G Refund Escrow Permit # 14 -0599 150.00 Bruzek, Robert Refund Escrow Permit # 14 -0543 200.00 Capps Plumbing and Sewer Inc Refund Escrow Permit # 14 -1089 (209 Withorn Ln) 75.00 Dave Pate & Sons Construction LTD Refund Escrow Permit # 14 -0733 (205 N Owen St) 125.00 Decancq, Richard Refund Escrow Permit # 14 -0604 200.00 Demstrom, Michael B Refund Escrow Permit # 14 -0015 150.00 Dihiansan, Amasaco K Refund Escrow Permit # 14 -0312 200.00 DLS Landscaping Inc Refund Escrow Permit # 13 -2335 (702 Wilshire Dr) 125.00 Emerald Landscape Refund Escrow Permit # 14 -0788 (1414 Cypress Dr) 125.00 Envy Home Services Refund Escrow Permit # 14 -0445 (1307 Lama Ln) 400.00 Four Seasons Heating and A/C Refund Escrow Permit # 14 -0781 (219 S Main St) 125.00 Four Star Lane Refund Escrow Permit # 14 -0091 (1400 Yarmouth PI #402 100.00 Gastineau, G.W. Refund Escrow Permit # 14 -0863 200.00 Greene, Paulette Refund Escrow Permit # 14 -0816 125.00 Hiro LLC Refund Escrow Permit # 13 -2221 (1001 S Busse Rd) 125.00 Johnson, Ross C Refund Escrow Permit # 14 -0698 200.00 JRC Construction Refund Escrow Permit # 13 -1603 (416 1 Oka Ave) 250.00 K Lowe Plumbing Inc Refund Escrow Permit # 14 -1111 (1721 Estates Dr) 125.00 K &K Concrete Refund Escrow Permit # 14 -0610 (126 Bobby Ln) 200.00 Klairmont Investments LLC Refund Escrow Permit # 13 -0110 (1699 Wall St) 1,000.00 Lasko, Anna Pawel Refund Escrow Permit # 14 -0014 125.00 Magnesen, Eric S Refund Escrow Permit # 14 -0259 200.00 Malek, Mariusz Refund Escrow Permit # 14 -0893 125.00 Mid - Cities Parners Inc Refund Escrow Permit # 14 -0974 (215 Marcella Rd) 100.00 MiclCity Plumbing Refund Escrow Permit # 14 -0786 (200 E Evergreen Ave) 125.00 Midwest Comfort Heating & Cooling Refund Escrow Permit # 14 -0926 (408 E Kensington Rd # F) 125.00 Norb & Sons Electric Refund Escrow Permit # 14 -0759 (1819 E Euclid Ave) 75.00 North Shore Sign Co Refund Escrow Permit # 14 -0292 (1721 W Golf Rd) 125.00 Northscape Enterprises Inc Refund Escrow Permit # 14 -0372 (217 N Owen St) 200.00 Page 11 of 12 VILLAGE OF MOUNT PROSPECT List of Bills June 26 - July 09, 2014 Fund Vendor Name Invoice Description Amount Penco Electric Inc Refund Escrow Permit # 14- 0891(516 Hi Lusi Ave) 125.00 Rick's Sewer & Drainage Refund Escrow Permit # 14 -1067 (1306 Dogwood Ln) 125.00 Rosenberg, Kevin Refund Escrow Permit # 14 -0525 125.00 Ross Jr, Eugene D Refund Escrow Permit # 14 -1118 125.00 S &S Electrical Services Inc Refund Escrow Permit # 14 -0723 (817 S Waverly Ave) 125.00 Splitt, loan Reissue Escrow Refund Check #787406 (Permit #14 -0827) 200.00 Taylor, Terry Refund Escrow Permit # 14 -0639 150.00 Tempco Heating & Air Conditioning Refund Escrow Permit # 14 -0121 (208 N Emerson St) 125.00 Third District Circuit Court Bond Check 6/25/14 120.00 Bond Check 7/1/14 945.00 Bond Check 7/3/14 440.00 Bond Check 7/8/14 3,295.00 Vergara, Aida Refund Escrow Permit # 14 -0870 200.00 Waterguard Plumbing Service Refund Escrow Permit # 13 -2238 75.00 073 Escrow Deposit Fund Total $ 31,350.00 Grand Total $ 2,466,227.38 Page 12 of 12