The URL can be used to link to this page

Home My WebLink About3. Financial Report and Approve Bills - June 2012Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM Tom: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: JULY 13, 2012 SUBJECT: MONTHLY FINANCIAL REPORT — JUNE 2012 Attached hereto are the cash position and investment statements of the Village for the month ended June 30, 2012. 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 were $29.6 million. During June, cash receipts totaled $4,129,274. In addition investment income for the month was $2,632 and inflows due to Interfund activity totaled $43,780. Reductions in cash and cash equivalents during June totaled $4,962,845. Of this amount, payments to vendors were $3,586,977 and employee payroll and related expenses were $1,375,868. Other receipts totaled $11,127. Cash and cash equivalents at June 30 were $28.9 million. Monthly Financial Report — June 2012 July 13, 2012 Page 2 There were no funds held in investments during the month of June. Funds were held in cash money market accounts that currently earn competitive rates of interest. Total Lash and : Investmel lts for Governmental and Enterprise Funds at May 3 1 1 were $29,649,204. Cash and investments at June 30 totaled $28,873,171. This is a decrease of $776,033. Trust and Agency Funds - Cash and cash equivalents at May 31 were $7.1 million. During June, cash receipts totaled $178,077. In addition investment income for the month was $179,438 and outflows due to Interfund activity totaled $43,780. There was also a net increase in cash due to investment activities of $83,994. Reductions in cash and cash equivalents during June totaled $678,268. Of this amount, payments to vendors were $141,316 employee payroll and related expenses were $513,989, and payments related to the flexible spending program totaled $22,196. Other disbursements were $766. Cash and cash equivalents at June 30 were $6.6 million. Total investments at June 30 were $86,910,085, a decrease of $2,288,864 from May 31, 2012. There were unrealized investment losses of $2,372,858, solely from equities, and a transfer from cash of $83,994 that accounted for the change. Total cash and investments for Trust and Agency Funds at May 31 were $96.3 million. Cash and investments at June 30 totaled $93.6 million. This is a decrease for the month of $2.7 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,002,747. During June, cash receipts totaled $2,511,085 and investment income was $2,191. Significant cash receipts included sales taxes, state income tax and telecommunication tax. Sales tax revenues for the month totaled $1,053,260. Of this amount, $953,182 was generated from the 1% state portion while $100,077 was generated from the .25% home rule portion. The state portion shows an increase of 12.0% over the same period last year. The home rule portion also grew from the prior year by 8.5 %. The difference between the two sales tax sources in their change from prior year is due to the tax being assessed on a different set of goods. 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\Treasurers Report\2012 \Monthly Cash Position Report - June 2012.docx Monthly Financial Report - June 2012 July 13, 2012 Page 3 State income tax receipts for June totaled $301,902. These monies were actually to be received by the Village in March. Income taxes are above the prior year by 4.1 % based on the first three months receipts. The state is 90+ days delinquent in making these remittances to the Village. The state is currently $1.5 million in arrears in remitting income taxes to the Village April - June Receipts). Telecommunication tax receipts for June reflect March activity. Total receipts during June were $506,987. Telecommunications taxes were above the same month prior year by 181 %. This anomaly was due to catch -up payments from prior periods. Disbursements from the General Fund for June included payments to vendors of $1,329,992 and payments for employee wages and benefits of $1,218,086. Interfund transfers of $523,864 for health premiums and vehicle lease and maintenance payments were also made during June. Cash and cash equivalents at June 30 were $7,453,024. There were no investments in the General Fund at June 30. Statement of Investments (page 3) This report provides a breakdown of investments by governmental and enterprise funds and trust and agency funds. The report also provides a fund -by fund breakdown of the investments. Government and Enterprise Funds - Investments for the governmental and agency funds are typically made up of Certificates of Deposit. At June 31 there were no CD's placed at any bank. This is due to the extremely low interest rates being offered. Money instead has been placed in interest bearing money market accounts 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. Below is a breakdown of how the pension fund portfolios are invested. HAACCnTreasurer's Report\2012 \Monthly Cash Position Report - June 2012.docx Monthly Financial Report — June 2012 July 13, 2012 Page 4 Maturity Purchase Financial Investment CUSIP/ Date Date Institution Description Acct It POLICE PENSION FUND (070) Various Vzrirnis Wells Fargo Various Various Various FIRE PENSION FUND (071) Various Various Wells Fargo Various Various Various Wells Fargo Investment - Mutual Fund Investments Wells Fargo Investments Mutual Fund Investments TOTAL TRUST AND AGENCY FUND LNVESTNIENTS Interest Market Rate % Value Varin— Venous '27 630 7669 38 Various Various 21,299,810.91 43,930,580.29 Various Various 20,659,286.46 Various Various 22,320,218.50 42,979,504.96 $ 86,910,085.25 Investment of the Village's pension funds is governed by an Investment Policy adopted by each Pension Board. The policy was last amended in 2011. Conclusion As mentioned earlier, this cash position report is intended to provide a snapshot of the Village's cash position as of a particular month end date. Over time, this report will be able to provide trend information to help in cash management duties, maximizing investment earnings while ensuring availability of funds to meet the Village's commitments. The cash position report will continue to be provided to the Village Board and Finance Commission on a monthly basis. David O. Erb Finance Director HAACCT\Treasurer's Report\20121Monthly Cash Position Report - June 2012.docx VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended June 30, 2012 GOVERNMENTAL AND ENTERPRISE FUNDS Disbursements: Accounts payable (3,586,976.66) (3,586,976.66) Payroll (1,375,868.71) (1,375,868.71) Other 1 1,126.90 11,126.90 Balance at June 30, 2012 $ 28,873,171.05 $ - $ 28,873,171.05 TRUST AND AGENCY FUNDS Cash and Cash Equivalents Balance at May 31, 2012 $ 7,091,238.03 Investments Total Cash and Investments $ 89,198, 949.32 $ 96,290,187.35 Cash receipts Cash and Cash Total Cash and 179,437.64 (2,372,858.43) (2,193,420.79) Equivalents Investments Investments Balance at May 31, 2012 $ 29,649,203.66 $ - $ 29,649,203.66 Cash receipts 4,129,273.66 4,129,273.66 Investment income 2,632.30 2,632.30 Transfers from investments to cash - - - Transfers to investments from cash - - - Interfund activity 43,779.90 43,779.90 Disbursements: Accounts payable (3,586,976.66) (3,586,976.66) Payroll (1,375,868.71) (1,375,868.71) Other 1 1,126.90 11,126.90 Balance at June 30, 2012 $ 28,873,171.05 $ - $ 28,873,171.05 TRUST AND AGENCY FUNDS Cash and Cash Equivalents Balance at May 31, 2012 $ 7,091,238.03 Investments Total Cash and Investments $ 89,198, 949.32 $ 96,290,187.35 Cash receipts 178,077.05 178,077.05 Investment income (loss) 179,437.64 (2,372,858.43) (2,193,420.79) Transfers from investments to cash 3,385,013.60 (3,385,013.60) - Transfers to investments from cash (3,469,007.96) 3,469,007.96 - Interfund activity (43,779.90) (43,779.90) Disbursements: Accounts payable Payroll Flex spending Other Balance at June 30, 2012 (141,316.44) (513,989.26) (22,196.21) (766.28) (141,316.44) (513,989.26) (22,196.21) (766.28) $ 6,642,710.27 $ 86,910,085.25 $ 93,552,795.52 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 N VILLAGE OF MOUNT PROSPECT Summary of Cash Activity by Fund Type For the Month Ended June 30, 2012 _ GOVER AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS SPECIAL CAPITAL TOTAL GOVT, FIRE AND OTHER TRUST REVENUE DEBT SERVICE PROJECTS ENTERPRISE INTERNAL AND ENTERPRISE POLICE AND AGENCY GENERAL FUND FUNDS FUND — FUNDS SERVICE FUNDS FUNDS PENSIONS FUND TOTAL CASH 8, CASH EQUIVALENTS _ — — —•— — l3eginning balance $ 8,002,747.09 $ 2,837,783.27 $ 601,660.60 $ 5,338,015.31 $ 3,229,892.04 $ 9,639,105.35 $ 29,649,203.66 $ 5,813,033.38 $ 1,278,204.65 $ 36,740,441.69 Cash receipts 2,511,084.86 235,202.83 50,520.92 278,228.39 886,016.33 168,220.33 4,129,273.66 111,232.85 66,844.20 4,307,35011 Investment income 2,190.75 0.82 - - 2.03 438.70 2,632.30 179,329.82 107.82 182,069.94 Transfers from investments - - - - - 3,385,013.60 3,385,013.60 transfers to investments - - - (3,469,007,96) (3,469,007.96) nterfund (523,863.97) 101,222.43 (228,111.14) 694,532.58 43,7790 (33,247.11) (10,532.79) (0.00) )isbursements - other 8,943.33 131.74 1,395.17 656.66 11,126.90 (766.28) 10,360.62 )isbursements - flexible spending - - _ _ (22,196.21) (22,196.21) )isbursements - payroll (1,218,086.38) (13,797.47) (99,051.61) (44,933.25) (1,375,868.71) (513,989.26) (1,889,857.97) )isbursements - accounts payable (1,329,991.97) — 48 6,426.81) (220,518. _(322,441.93) (572,138.78) (655,458.82) (3,586,976.66) (76,338. (64,977.91) (3,728,293 Ending balance 7,453,023.71 _2_67 4,116.81 431,663. 5,293,801.77 3,218,004.04 9,802,561.55 28,873,171.05 5,396,026. 1,246,683. 35,515,881 _ NVESTMENTS ;ertificates of deposit _ Hells Fargo investments 43,290,055.84 43,290,055.84 Mutual fund investments _— 43,620,029. 43,620,029 — 'otal investments - 86,910,085. — 86,910,085 TOTAL CASH AND INVESTMENTS $ 7,453,023.71 $ 2,674,116.81 $ 431,6 $ 5,293,801.77 $ 3,218,004.04 $ 9,802,561.55 $ 28,873,171.05 $ 92,306,112. $ 1,246,683.48 $122,425,966 Assets are restricted in purpose and do not represent discretionary assets of the government. VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of June 30, 2012 Maturity Purchase Financial Date Date Institution GOVERNMENTAL AND ENTERPRISE FUNDS Investment CUSIP/ Interest Description Acct # Rate % Market Weighted Avg Yield As of June 30, 2012, there were no certificates of deposit held by the Governmental and Enterprise Funds. Weighted Avg Yield * Assets are restricted in purpose and do not represent discretionary assets of the government. 3 TRUST AND AGENCY FUNDS Maturity Purchase Financial Investment CUSIP/ Interest Market Date Date Institution Description Acct # Rate % Value POLICE PENSION FUND (070) Various Various Wells Fargo Wells Fargo Investments Various Various 22,630,769.38 Various Various Various Mutual Fund Investments Various Various 21,299,810.91 43,930,580.29 FIRE PENSION FUND (071) Various Various Wells Fargo Wells Fargo Investments Various Various 20,659,286.46 Various Various Various Mutual Fund Investments Various Various 22,320,218.50 42,979,504.96 TOTAL TRUST AND AGENCY FUND INVESTMENTS $86,910,085.25 Weighted Avg Yield * Assets are restricted in purpose and do not represent discretionary assets of the government. 3 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES June 01— June 30, 2012 Revenue Budget by Account Classification Report Account Classification Fund 001- General Fund REVENUE Property Taxes Other Taxes Licenses, Permits & Fees Intergovernmental Revenue Charges For Services Fines & Forfeits Investment Income Reimbursements Other Revenue Other Financing Sources Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 12,206,500.00 .00 12,206,500.00 6.48 .00 6,168,779.02 6,037,720.98 51 6,064,910.47 7,603,000.00 .00 7,603,000.00 843,085.82 .00 2,681,642.60 4,921,357.40 35 2,383,458.86 2,495,000.00 .00 2,495,000.00 86,095.20 .00 1,859,834.61 635,165.39 75 1,819,996.99 16,731,619.00 .00 16,731,619.00 1,335,173.61 .00 4,435,722.41 12,295,896.59 27 3,826,621.98 1,518,125.00 .00 1,518,125.00 140,745.00 .00 638,478.75 879,646.25 42 650,752.88 507,000.00 .00 507,000.00 26,069.28 .00 142,308.69 364,691.31 28 234,551.59 25,000.00 .00 25,000.00 2,297.10 .00 12,585.70 12,414.30 50 14,989.04 169,500.00 .00 169,500.00 1,771.60 .00 90,150.27 79,349.73 53 37,645.42 290,738.00 .00 290,738.00 29,700.70 .00 134,013.65 156,724.35 46 153,711.99 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 659.14 REVENUE TOTALS $41,547,482.00 $0.00 $41,547,482.00 $2,464,944.79 $0.00 $16,163,515.70 $25,383,966.30 39% $15,187,298.36 Fund 001 - General Fund Totals $41,547,482.00 $0.00 $41,547,482.00 $2,464,944.79 $0.00 $16,163,515.70 $25,383,966.30 $15,187,298.36 r Im Revenue Budget toy Account Classification I Report Through 06/30/.12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YrD % used/ Account Classiflcatlon Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 002 - Debt Service Fund REVENUE: Property Taxes 1,749,000.00 .00 1,749,000.00 (305.63) .00 868,522.41 880,477.59 50 1,013,483.85 Other Taxes 613,354.00 .00 613,354.00 50,520.92 .00 136,321.13 477,032.87 22 152,809.38 Intergovernmental Revenue 47,258.00 .00 47,258.00 .00 .00 23,628.93 23,629.07 50 23,628.93 Investment Income 600.00 .00 600.00 .00 .00 .00 600.00 0 .00 Other Financing Sources .00 .00 .00 .00 .00 8,210.00 (8,210.00) ... .00 REVENUE TOTALS $2,410,212.00 $0.00 $2,410,212.00 $50,215.29 $0.00 $1,036,682.47 $1,373,529.53 43% $1,189,922.16 Fund 002 - Debt Service Fund Totals $2,410,212.00 $0.00 $2,410,212.00 $50,215.29 $0.00 $1,036,682.47 $1,373,529.53 $1,189,922.16 Account Classification Fund 020 - Capital Improvement Fund REVENUE Revenue Budget by Account Classification Report Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Taxes 1,115,000.00 .00 1,115,000.00 91,840.63 .00 247,814.56 867,185.44 22 226,525.34 Intergovernmental Revenue .00 .00 .00 10,113.00 .00 22,054.00 (22,054.00) ... 40,185.79 Investment Income 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Reimbursements .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Revenue 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 14,494.00 Other Financing Sources 937,000.00 .00 937,000.00 .00 .00 .00 937,000.00 0 .00 REVENUE TOTALS $2,068,000.00 $0.00 $2,068,000.00 $101,953.63 $0.00 $269,868.56 $1,798,131.44 13% $281,205.13 Fund 020 - Capital Improvement Fund Totals $2,068,000.00 $0.00 $2,068,000.00 $101,953.63 $0.00 $269,868.56 $1,798,131.44 $281,205.13 w A. Revenue Budget by Account classification Report Through 06/30/12 Prior Fiscal Year Activibi Included 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 ... .88 Other Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 + ++ $0.88 Fund 021- Series 2009 Construction Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.88 Revenue Budget by Account Classification Report Through 06/30/12 Prior Fiscal Year Activity Included 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 Redevelopment Construct REVENUE Property Taxes 2,604,000.00 .00 2,604,000.00 .94 .00 1,374,661.40 1,229,338.60 53 1,423,849.33 Investment Income 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 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,605,000.00 $0.00 $2,605,000.00 $0.94 $0.00 $1,374,661.40 $1,230,338.60 53% $1,423,849.33 Fund 022 -Downtown Redevelopment Construct Totals $2,605,000.00 $0.00 $2,605,000.00 $0.94 $0.00 $1,374,661.40 $1,230,338.60 $1,423,849.33 Ul W Revenue Budget by Account Classification ' 1 Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 06/30/12 Prior Fiscal Year Activit`/ Included YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 023 •• Street Improvement Construc Fund REVENUE Other Taxes 1,550,000.00 .00 1,550,000.00 126,467.27 .00 398,162.75 1,151,837.25 26 381,917.85 Licenses, Permits & Fees .00 .00 .00 .00 .00 .00 .00 ... .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Investment Income 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Reimbursements .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Revenue 5,000.00 .00 5,000.00 250.00 .00 4,106.84 893.16 82 4,171.37 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $1,555,500.00 $0.00 $1,555,500.00 $126,717.27 $0.00 $402,269.59 $1,153,230.41 26% $386,089.22 Fund 023 - Street Improvement Construc Fund Totals $1,555,500.00 $0.00 $1,555,500.00 $126,717.27 $0.00 $402,269.59 $1,153,230.41 $386,089.22 Revenue Budget by Account Classification IVIM Report Through 06/30/12 Prior Fiscal Year Activity Included 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 024 - Flood Control Construction Fund REVENUE Other Taxes 601,646.00 .00 601,646.00 49,556.55 .00 133,718.96 467,927.04 22 96,122.04 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Charges For Services 7,500.00 .00 7,500.00 .00 .00 .00 7,500.00 0 3,695.00 Investment Income .00 .00 .00 .00 .00 .00 .00 + ++ .00 Reimbursements 56,500.00 .00 56,500.00 .00 .00 56,521.31 (21.31) 100 56,744.17 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $665,646.00 $0.00 $665,646.00 $49,556.55 $0.00 $190,240.27 $475,405.73 29% $156,561.21 Fund 024 - Flood Control Construction Fund Totals $665,646.00 $0.00 $665,646.00 $49,556.55 $0.00 $190,240.27 $475,405.73 $156,561.21 v .. Revenue Budget toy Account Classification Report Through 06/30/12 Prior Fiscal Year Activity Included 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 040 •• Refuse Disposal Fund REVENUE Property Taxes 1,807,000.00 .00 1,807,000.00 (301.72) .00 895,898.32 911,101.68 50 1,012,060.15 Charges For Services 2,258,000.00 .00 2,258,000.00 306,186.11 .00 1,090,603.83 1,167,396.17 48 980,910.58 Fines & Forfeits 21,500.00 .00 21,500.00 6,003.98 .00 27,660.99 (6,160.99) 129 11,552.53 Investment Income 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Other Revenue 381,650.00 .00 381,650.00 44,652.68 .00 163,568.87 218,081.13 43 147,232.13 REVENUE TOTALS $4,469,150.00 $0.00 $4,469,150.00 $356,541.05 $0.00 $2,177,732.01 $2,291,417.99 49% $2,151,755.39 Fund 040 - Refuse Disposal Fund Totals $4,469,150.00 $0.00 $4,469,150.00 $356,541.05 $0.00 $2,177,732.01 $2,291,417.99 $2,151,755.39 Revenue Budget by Account Classification Report Account Classification Fund 041 - Motor Fuel Tax Fund REVENUE Through 06/30/12 Prior Fiscal Year Activity Included 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,690,000.00 .00 1,690,000.00 117,139.68 .00 552,114.22 1,137,885.78 33 586,579.73 Investment Income 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Reimbursements 20,500,00 .00 20,500.00 .00 .00 3,141.19 17,358.81 15 4,932.51 REVENUE TOTALS $1,711,000.00 $0.00 $1,711,000.00 $117,139.68 $0.00 $555,255.41 $1,155,744.59 32% $591,512.24 Fund 041- Motor Fuel Tax Fund Totals $1,711,000.00 $0.00 $1,711,000.00 $117,139.68 $0.00 $555,255.41 $1,155,744.59 $591,512.24 0 r 0 Revenue Budget by Account Classification Report Account Classification Fund 042 - Cmmty Development Block Grant REVENUE Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Intergovernmental Revenue 353,543.00 :115,013.00 468,556.00 .00 .00 65,524.75 403,031.25 14 114,913.47 Investment Income .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Revenue 60,000.00 .00 60,000.00 24,254.00 .00 41,435.00 18,565.00 69 22,206.50 REVENUE TOTALS $413,543.00 $115,013.00 $528,556.00 $24,254.00 $0.00 $106,959.75 $421,596.25 20% $137,119.97 Fund 042 - Cmmty Development Block Grant Totals $413,543.00 $115,013.00 $528,556.00 $24,254.00 $0.00 $106,959.75 $421,596.25 $137,119.97 ro Revenue Budget by Account Classification \!V Report Through 06/30/12 Prior Fiscal Year Activity Included 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 043 - Asset Seizure Fund REVENUE Fines & Forfeits 3,000.00 .00 3,000.00 .00 .00 593.48 2,406.52 20 3,120.62 Investment Income 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 REVENUE TOTALS $3,500.00 $0.00 $3,500.00 $0.00 $0.00 $593.48 $2,906.52 17% $3,120.62 Fund 043 - Asset Seizure Fund Totals $3,500.00 $0.00 $3,500.00 $0.00 $0.00 $593.48 $2,906.52 53,120.62 ro N Account Classification Fund 044 - DEA St REVENUE Fines & Forfeits Investment Income Funds Fund Revenue Budget by Account Classification Report Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 2,500.00 .00 2,500.00 .00 .00 .00 2,500.00 0 .00 500.00 .00 500.00 .82 .00 5.15 494.85 1 26.99 REVENUE TOTALS $3,000.00 $0.00 $3,000.00 $0.82 $0.00 $5.15 $2,994.85 0% $26.99 Fund 044 - DEA Shared Funds Fund Totals $3,000.00 $0.00 $3,000.00 $0.82 $0.00 $5.15 $2,994.85 $26.99 Revenue Budget by Account Classification �. Report Through 06/30/12 Prior Fiscal Year Activity Included 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 045 - DUI Fine Fund REVENUE Fines & Forfeits 9,000.00 .00 9,000.00 3,100.53 .00 5,983.64 3,016.36 66 2,672.00 Investment Income 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 REVENUE TOTALS $9,500.00 $0.00 $9,500.00 $3,100.53 $0.00 $5,983.64 $3,516.36 63% $2,672.00 Fund 045 - DUI Fine Fund Totals $9,500.00 $0.00 $9,500.00 $3,100.53 $0.00 $5,983.64 $3,516.36 $2,672.00 r w F- Revenue Budget by Account Classification Report Account Classification Fund 046 .. Foreign Fire Tax Board REVENUE Through 06/30/12 Prior Fiscal Year Activity Inclluded Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Taxes 55,000.00 .00 55,000.00 .00 .00 .00 55,000.00 0 .01 Investment Income 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Other Financing Sources .00 .00 .00 .00 .00 00 .00 ... .00 REVENUE TOTALS $55,500.00 $0.00 $55,500.00 $0.00 $0.00 $0.00 $55,500.00 0% -T- - $0.01 Fund 046 - Foreign Fire Tax Board Fund Totals $55,500.00 $0.00 $55,500.00 $0.00 $0.00 $0.00 $55,500.00 $0.01 Revenue Budget by Account Classification Report Account Classification Fund 048 - Business District Fund REVENUE Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Other Taxes .00 .00 .00 60,351.10 .00 185,802.25 (185,802.25) + ++ .00 REVENUE TOTALS $0.00 $0.00 $0.00 $60,351.10 $0.00 $185,802.25 ($185,802.25) + ++ $0.00 Fund 048 - Business District Fund Totals $0.00 $0.00 $0.00 $60,351.10 $0.00 $185,802.25 ($185,802.25) $0.00 F- U1 r rn Revenue Budget by Account Classification ' t Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 06/30/12 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 050 - Water and Sewer Fund REVENUE: Property Taxes 1,516,000.00 .00 1,516,000.00 (249.11) .00 795,866.10 720,133.90 52 809,143.35 Licenses, Permits & Fees 15,000.00 .00 15,000.00 1,510.00 .00 7,930.00 7,070.00 53 7,650.00 Charges For Services 9,937,000.00 .00 9,937,000.00 891,184.81 .00 4,535,263.81 5,901,736.19 46 4,219,362.04 Fines & Forfeits 120,000.00 .00 120,000.00 15,521.02 .00 63,596.75 56,403.25 53 56,705.51 Investment Income 3,000.00 .00 3,000.00 2.03 .00 12.29 2,987.71 0 14.51 Reimbursements 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Other Revenue 35,000.00 .00 35,000.00 10,721.72 .00 11,103.84 23,896.16 32 28,361.66 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $11,627,000.00 $0.00 $11,627,000.00 $918,690.47 $0.00 $5,413,772.79 $6,213,227.21 47% $5,121,237.07 Fund 050 - Water and Sewer Fund Totals $11,627,000.00 $0.00 $11,627,000.00 $918,690.47 $0.00 $5,413,772.79 $6,213,227.21 $5,121,237.07 Revenue Budget by Account Classification Report Account Classification Fund 051- Village Parking System Fund REVENUE Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Taxes 45,000.00 .00 45,000.00 3,706.57 .00 10,001.49 34,998.51 22 10,082.73 Charges For Services 105,000.00 .00 105,000.00 8,043.35 .00 58,505.45 46,494.55 56 55,584.33 Investment Income 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Other Revenue 6,600.00 .00 6,600.00 .00 .00 .00 6,600.00 0 1,650.00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $157,100.00 $0.00 $157,100.00 $11,749.92 $0.00 $68,506.94 $88,593.06 44% $67,317.06 Fund 051 - Village Parking System Fund Totals $157,100.00 $0.00 $157,100.00 $11,749.92 $0.00 $68,506.94 $88,593.06 $67,317.06 F- -j OD Revenue Budget by Account Classification Report Account Classification Fund 052 • Parking System Revenue Fu REVENUE Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Taxes 55,000.00 .00 55,000.00 4,530.26 .00 12,224.03 42,775.97 22 12,323.34 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Charges For Services 108,000.00 .00 108,000.00 8,960.60 .00 56,188.13 51,811.87 52 54,734.12 Investment Income 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Other Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $163,500.00 $0.00 $163,500.00 $13,490.86 $0.00 $68,412.16 $95,087.84 42% $67,057.46 Fund 052 - Parking System Revenue Fund Totals $163,500.00 $0.00 $163,500.00 $13,490.86 $0.00 $68,412.16 $95,087.84 $67,057.46 Revenue Budget by Account Classification Report Account Classification Fund 060 - Vehicle Maintenance Fund REVENUE Through 06/30/12 Prior Fiscal Year Activity Included 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 2,010,205.00 .00 2,010,205.00 167,517.07 .00 1,005,102.42 1,005,102.58 50 951,401.04 Investment Income 500.00 .00 500.00 26.59 .00 163.58 336.42 33 192.29 Other Revenue 500.00 .00 500.00 .00 .00 797.96 (297.96) 160 275.00 REVENUE TOTALS $2,011,205.00 $0.00 $2,011,205.00 $167,543.66 $0.00 $1,006,063.96 $1,005,141.04 50% $951,868.33 Fund 060 - Vehicle Maintenance Fund Totals $2,011,205.00 $0.00 $2,011,205.00 $167,543.66 $0.00 $1,006,063.96 $1,005,141.04 $951,868.33 r W N O Revenue Budget by Account Classification Report Account Classification Fund 061 - Vehicle Replacement Fund Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD REVENUE: Charges For Services 1,183,800.00 .00 1,183,800.00 98,649.99 .00 591,899.94 591,900.06 50 348,800.04 Fines & Forfeits 24,000.00 .00 24,000.00 17,769.10 .00 21,347.57 2,652.43 89 10,223.86 Investment Income 10,00().00 .00 10,000.00 265.88 .00 1,635.66 8,364.34 16 1,922.76 Other Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Financing Sources 50,00().00 .00 50,000.00 .00 .00 27,250.00 22,750.00 54 44,703.00 REVENUE TOTALS $1,267,800.00 $0.00 $1,267,800.00 $116,684.97 $0.00 $642,133.17 $625,666.83 51% $405,649.66 Fund 061 - Vehicle Replacement Fund Totals $1,267,800.00 $0.00 $1,267,800.00 $116,684.97 $0.00 $642,133.17 $625,666.83 $405,649.66 Revenue Budget by Account Classification Report Account Classification Fund 062 - Computer Replacement Fund REVENUE Through 06/30/12 Prior Fiscal Year Activity Included 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 .00 .00 .00 .00 .00 .00 .00 + ++ 115,960.50 Investment Income 1,000.00 .00 1,000.00 39.88 .00 245.35 754.65 25 288.53 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $1,000.00 $0.00 $1,000.00 $39.88 $0.00 $245.35 $754.65 25% $116,249.03 Fund 062 - Computer Replacement Fund Totals $1,000.00 $0.00 $1,000.00 $39.88 $0.00 $24535 $754.65 $116,249.03 N 1-' rV N Revenue Budget by Account Classification Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 06/30/12 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 063 • Risk Management Fund REVENUE Charges For Services 5,271,967.00 .00 5,271,967.00 493,256.89 .00 2,661,724.07 2,610,242.93 50 2,623,598.62 Investment Income 2,000.00 .00 2,000.00 106.35 .00 654.21 1,345.79 33 769.01 Reimbursements 6,000.00 .00 6,000.00 .00 .00 .00 6,000.00 0 727.10 Other Revenue 1,160,392.00 100 1,160,392.00 101,203.54 .00 554,922.10 605,469.90 48 547,544.86 REVENUE TOTALS $6,440,359.00 $0.00 $6,440,359.00 $594,566.78 $0.00 $3,217,300.38 $3,223,058.62 50% $3,172,639.59 Fund 063 - Risk Management Fund Totals $6,440,359.00 $0.00 $6,440,359.00 $594,566.78 $0.00 $3,217,300.38 $3,223,058.62 $3,172,639.59 Revenue Budget by Account Classification Report Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 06/30/12 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 070 - Police Pension Fund REVENUE Charges For Services .00 .00 .00 .00 .00 .00 .00 + ++ .00 Investment Income 2,622,500.00 .00 2,622,500.00 (1,139,304.08) .00 2,257,458.47 365,041.53 86 1,904,152.00 Other Revenue 3,244,500.00 .00 3,244,500.00 64,351.13 .00 1,716,384.53 1,528,115.47 53 1,495,981.38 REVENUE TOTALS $5,867,000.00 $0.00 $5,867,000.00 ($1,074,952.95) $0.00 $3,973,843.00 $1,893,157.00 68% $3,400,133.38 Fund 070 - Police Pension Fund Totals $5,867,000.00 $0.00 $5,867,000.00 ($1,074,952.95) $0.00 $3,973,843.00 $1,893,157.00 $3,400,133.38 N W N .P Revenue Budget by Account Classification Report Account Classification Fund 071- Fire Pension Fund REVENUE Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Investment Income 2,531,000.00 .00 2,531,000.00 (1,104,740.82) .00 2,255,072.94 275,927.06 89 1,646,622.26 Other Revenue 2,841,300.00 .00 2,841,300.00 46,881.72 .00 1,452,443.21 1,388,856.79 51 1,276,256.71 REVENUE TOTALS $5,372,300.00 $0.00 $5,372,300.00 ($1,057,859.10) $0.00 $3,707,516.15 $1,664,783.85 69% $2,922,878.97 Fund 071 - Fire Pension Fund Totals $5,372,300.00 $0.00 $5,372,300.00 ($1,057,859.10) $0.00 $3,707,516.15 $1,664,783.85 $2,922,878.97 Grand Totals $90,424,297.00 $115,013.00 $90,539,310.00 $3,044,730.14 $0.00 $40,567,363.58 $49,971,946.42 $37,736,164.06 Expense Budget by Account Classification Report Account Classification Fund 001- General Fund EXPENSE Through 06/30/12 Prior Fiscal Year Activity Included 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 22,938,376.00 (2,800.00) 22,935,576.00 1,824,753.04 .00 10,320,676.03 12,614,899.97 45 10,238,602.66 Employee Benefits 10,472,944.00 .00 10,472,944.00 535,038.25 .00 5,433,897.44 5,039,046.56 52 4,909,891.16 Other Employee Costs 379,154.00 4,694.00 383,848.00 11,403.23 13,839.72 114,625.44 255,382.84 33 133,622.04 Pension Benefits 46,005.00 .00 46,005.00 3,833.63 .00 23,001.78 23,003.22 50 22,930.80 Contractual Services 6,372,180.00 143,753.00 6,515,933.00 581,565.37 408,002.80 3,049,766.62 3,058,163.58 53 2,803,351.82 Utilities 263,151.00 1,489.87 264,640.87 7,697.60 .00 52,686.15 211,954.72 20 49,754.83 Insurance 159,712.00 .00 159,712.00 13,337.44 .00 80,740.33 78,971.67 51 159,737.62 Commodities & Supplies 628,472.00 28,493.00 656,965.00 46,390.07 20,723.53 248,710.84 387,530.63 41 209,160.72 Other Expenditures 11,000.00 .00 11,000.00 .00 .00 .00 11,000.00 0 .00 Building Improvements 10,000.00 .00 10,000.00 3,44113 96.00 6,806.78 3,097.22 69 10,12531 Office Equipment 51,612.00 3,064.13 54,676.13 1,133.55 .00 11,238.20 43,437.93 21 .00 Other Equipment 140,493.00 3,500.00 143,993.00 1,342.06 10,844.58 23,355.83 109,792.59 24 53,417.86 Distribution Systems .00 .00 .00 .00 .00 .00 .00 ... .00 Infrastructure 74,383.00 4,720.00 79,103.00 13,690.21 .00 44,593.48 34,509.52 56 1,100.00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $41,547,482.00 $186,914.00 $41,734,396.00 $3,043,627.58 $453,506.63 $19,410,098.92 $21,870,790.45 48% $18,591,694.82 Fund 001 - General Fund Totals $41,547,482.00 $186,914.00 $41,734,396.00 $3,043,627.58 $453,506.63 $19,410,098.92 $21,870,790.45 $18,591,694.82 r Im Expense Budget by Account Classification t1i Through 06/30/12 Prior Fiscal Year Activity Included 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 002 - Debt Service Fund EXPENSE Contractual Services .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Bond Principal 1,479,732.00 .00 1,479,732.00 102,332.60 .00 272,703.17 1,207,028.83 18 264,255.42 Interest Expense 928,179.00 .00 928,179.00 118,182.64 .00 462,153.17 466,025.83 50 553,117.33 Bank & Fiscal Fees 1,28 .00 1,284.00 .00 .00 1,837.22 (553.22) 14:3 1,584.00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Financing Uses .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $2,409,195.00 $0.00 $2,409,195.00 $220,515.24 $0.00 $736,693.56 $1,672,501.44 31% $818,956.75 Fund 002 - Debt Service Fund Totals $2,409,195.00 $0.00 $2,409,195.00 $220,515.24 $0.00 $736,693.56 $1,672,501.44 $818,956.75 Expense Budget by Account Classification Report Account Classification Fund 020 - Capital Improvement Fund EXPENSE Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services 218,000.00 66,238.00 284,238.00 5,948.36 154,908.06 52,641.08 76,688.86 73 73,532.50 Other Expenditures .00 .00 .00 .00 .00 .00 .00 ... .00 Land Inprovements .00 .00 .00 .00 .00 .00 100 + ++ 4,034.00 Building Improvements 387,500.00 222,590.00 610,090.00 1,557.36 19,841.76 63,816.67 526,431.57 14 26,338.38 Office Equipment .00 7,775.00 7,775.00 3,250.24 .00 3,250.24 4,524.76 42 .00 Motor Equipment .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Equipment 1,210,500.00 8,718.00 1,219,218.00 43,233.91 50,665.25 51,951.91 1,116,600.84 8 48,749.83 Infrastructure 360,000.00 234,226.00 594,226.00 12,390.50 77,509.74 41,417.70 475,298.56 20 14,547.00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $2,176,000.00 $539,547.00 $2,715,547.00 $66,380.37 $302,924.81 $213,077.60 $2,199,544.59 19% $167,201.71 Fund 020 - Capital Improvement Fund Totals $2,176,000.00 $539,547.00 $2,715,547.00 $66,380.37 $302,924.81 $213,077.60 $2,199,544.59 $167,201.71 w Expense Budget by Account classification =1 Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 06/30/12 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Recd Prior Year YTD Fund 021 - Series 2009 Construction Fund EXPENSE Contractual Services .00 .00 .00 .00 .00 .00 .00 + ++ 350.13 Building Improvements .00 .00 .00 .00 .00 .00 .00 + ++ .00 Office Equipment .00 .00 .00 .00 .00 .00 .00 + ++ 2,123.61 Other Equipment .00 .00 .00 .00 .00 .00 .00 + ++ 95,900.00 EXPENSE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++ $98,373.74 Fund 021 - Series 2009 Construction Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $98,373.74 Expense Budget by Account Classification Report Through 06/30/12 Prior Fiscal Year Activity Included 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 022 - Downtown Redevelopment Construct EXPENSE Contractual Services 88,000.00 .00 88,000.00 6,332.85 37,997.05 19,998.55 30,004.40 66 100,705.47 Utilities 00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Expenditures 2,660,000.00 .00 2,660,000.00 .00 .00 29,087.33 2,630,912.67 1 2,461,739.47 Infrastructure .00 26,300.00 26,300.00 .00 2,512.24 .00 23,787.76 10 201,547.50 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 $2,748,000.00 $26,300.00 $2,774,300.00 $6,332.85 $40,509.29 $49,085.88 $2,684,704.83 3% $2,763,992.44 Fund 022 - Downtown Redevelopment Construct Totals $2,748,000.00 $26,300.00 $2,774,300.00 $6,332.85 $40,509.29 $49,085.88 $2,684,704.83 $2,763,992.44 to Expense Budget by Account classification Deport Account Classification Fund 023 - Street Improvement Construc Fund EXPENSE! Contractual Services Infrastructure Interfund Transfers EXPENSE TOTALS Fund 023 - Street Improvement Construc Fund Totals Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 20,000.00 43,828.00 63,828.00 .00 19,000.00 471.00 44,357.00 31 .00 1,197,000.00 527,411.00 1,724,411.00 264,924.44 920,172.85 311,882.22 492,355.93 71 464,117.25 .00 .00 .00 .00 .00 .00 .00 +++ .00 $1,217,000.00 $571,239.00 $1,788,239.00 $264,924.44 $939,172.85 $312,353.22 $536,712.93 70 $464,117.25 $1,217,000.00 $571,239.00 $1,788,239.00 $264,924.44 $939,172.85 $312,353.22 1;536,712.93 $464,117.25 Expense Budget by Account Classification J Report up Through 06/30/12 Prior Fiscal Year Activity Included 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 024 - Flood Control Construction Fund EXPENSE Contractual Services .00 .00 .00 .00 .00 00 .00 + ++ .00 Utilities .00 .00 .00 292.57 .00 461.71 (461,71) + ++ .00 Other Expenditures 5,150.00 .00 5,150.00 .00 .00 .00 5,150.00 0 .00 Other Equipment .00 .00 .00 .00 .00 .00 .00 + ++ .00 Infrastructure 675,000.00 50,000.00 725,000.00 4,774.50 .00 7,835.43 717,164.57 1 .00 EXPENSE TOTALS $680,150.00 $50,000.00 $730,150.00 $5,067.07 $0.00 $8,297.14 $721,852.86 1% $0.00 Fund 024 - Flood Control Construction Fund Totals $680,150.00 $50,000.00 $730,150.00 $5,067.07 $0.00 $8,297.14 $721,852.86 $0.00 J M l 1� Account Classification Expense Budget Iby Account classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 06/30/12 Prior Fiscal Year Activity Included YTD Budget - YTD % used,/ Transactions Transactions Rec'd Prior Year YTD Fund 040 - Refuse Disposal Fund EXPENSE Personal Services, Scheduled Salaries & Wages 237,856.00 .00 237,856,00 17,475.00 .00 101,670.20 136,185,80 43 90,095.88 Employee Beneflts 86,851.00 .00 86,851.00 6,314.21 .00 39,662.53 47,188.47 46 39,617.46 Other Employee Costs 1,200.00 .00 1,200.00 .00 .00 .00 1,200.00 0 .00 Contractual Services 4,022,673,00 .00 4,022,673.00 322,999.88 6,720.00 1,866,424.75 2,,149,528.25 47 1,760,223.96 Utilities 572.00 .00 572.00 19.82 .00 164.49 407.51 29 104.00 Insurance 27,331.00 .00 27,331.00 2,277.58 .00 13,665.48 13,665.52 50 12,587.52 Commodities & Supplies 33,737.00 .00 33,737.00 14.02 51.64 15,334.05 18,351.31 46 14,402.64 EXPENSE TOTALS $4,410,220.00 $0.00 $4,410,220.00 $349,100.51 $6,771.64 $2,036,921.50 $2,366,526.86 46°/o $1,917,031.46 Fund 040 - Refuse Disposal Fund Totals $4,410,220.00 $0.00 $4,410,220.00 $349,100.51 $6,771.64 $2,036,921.50 $2,366,526.86 $1,917,031.46 Expense Budget by Account Classification Report Account Classification Fund 041 - Motor Fuel Tax Fund EXPENSE Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Contractual Services 186,302.00 .00 186,302.00 1,387.34 70,544.74 20,445.63 95,311.63 49 25,161.72 Utilities 150,000.00 .00 150,000.00 4,226.12 .00 65,187.23 84,812.77 43 30,995.30 Commodities & Supplies 200,000.00 .00 200,000.00 9,080.83 59,065.48 140,658.26 276.26 100 212,551.69 Infrastructure 1,044,000.00 17,161.00 1,061,161.00 104,953.96 599,693.77 411,466.71 50,000.52 95 570,863.90 EXPENSE TOTALS $1,580,302.00 $17,161.00 $1,597,463.00 $119,648.25 $729,303.99 $637,757.83 $230,401.18 86% $899,572.61 Fund 041- Motor Fuel Tax Fund Totals $1,580,302.00 $17,161.00 $1,597,463.00 $119,648.25 $729,303.99 $637,757.83 $230,401.18 $899,572.61 ff.] F- CD Expense Budget by Account classification " - I 1 1 Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions (Encumbrances Through 06/30/12 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Recd Prior Year YTD Fund 042 - Cmmty Development Block Grant EXPENSE Personal Services, Scheduled Salaries & Wages 65,019.00 .00 65,019.00 3,826.79 25.00 23,467.11 41,526.89 36 29,808.40 Employee Benefits 29,838.00 .00 29,838.00 1,828.65 .00 12,412.29 17,425.71 42 12,232.09 Other Employee Costs 1,000.00 .00 1,000.00 175.00 .00 217.75 782.25 22 253.56 Contractual Services 107,186.00 29,556.00 136,742.00 327.16 .00 27,090.83 109,651.17 20 15,148.67 Commodities & Supplies 500.00 .00 500.00 .00 .00 9.26 490.74 2 56.99 Other Expenditures 160,000.00 85,457.00 245,457.00 10,087.71 .00 66,897.61 178,559.39 27 90,368.75 Land Inprovements .00 .00 .00 .00 .00 .00 .00 + ++ .00 Building Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 Infrastructure 50,000.00 .00 50,000.00 .00 .00 .00 50,000.00 i) .00 EXPENSE TOTALS $413,543.00 $115,013.00 $528,556.00 $16,245.31 $25.00 $130,094.85 $398,436.15 25% $147,868.46 Fund 042 - Cmmty Development Block Grant Totals $413,543.00 $115,013.00 $528,556.00 $16,245.31 $25.00 $130,094.85 $398,436.15 $147,868.46 Expense Budget by Account Classification Report Account Classification Fund 043 -Asset Seizure Fund EXPENSE Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Other Employee Costs 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Contractual Services 1,500.00 .00 1,500.00 .00 .00 500.00 1,000.00 33 .00 Other Equipment 1,000.00 4,000.00 5,000.00 5,990.20 .00 12,181.18 (7,181.18) 244 .00 EXPENSE TOTALS $3,500.00 $4,000.00 $7,500.00 $5,990.20 $0.00 $12,681.18 ($5,181.18) 169% $0.00 Fund 043 - Asset Seizure Fund Totals $3,500.00 $4,000.00 $7,500.00 $5,990.20 $0.00 $12,681.18 ($5,181.18) $0.00 r r N Expense Budget by Account Classification Report Account Classification Fund 044 - DEA Shared Funds Fund EXPENSE Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Contractual Services 1,000.00 .00 1,000.00 66.00 .00 66.00 934.00 7 375.00 Building Improvements 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 5,423.00 Other Equipment 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 6,076.78 EXPENSE TOTALS $3,000.00 $0.00 $3,000.00 $66.00 $0.00 $66.00 $2,934.00 2% $11,874.78 Fund 044 - DEA Shared Funds Fund Totals $3,000.00 $0.00 $3,000.00 $66.00 $0.00 $66.00 $2,934.00 $11,874.78 Expense Budget by Account Classification Report Account Classification Fund 045 - DUI Fine EXPENSE Other Employee Costs Other Equipment Interfund Transfers Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 7,500.00 .00 7,500.00 .00 2,957.58 5,241.75 (699.33) 109 .00 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 EXPENSE TOTALS $9,500.00 $0.00 $9,500.00 $0.00 $2,957.58 $5,241.75 $1,300.67 86% $0.00 Fund 045 - DUI Fine Fund Totals $9,500.00 $0.00 $9,500.00 $0.00 $2,957.58 $5,241.75 $1,300.67 $0.00 w F- Expense Budget Iby Account classification Report Account Classification Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used, Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 046 - Foreign Fire Tax Board Fund EXPENSE: Contractual Services 10,00(1.00 .00 10,000.00 .00 .00 2,372.70 7,627.30 24 2,532.53 Insurance 500.00 .00 500.00 .00 .00 417.54 82.46 84 417.21 Commodities & Supplies 3,000.00 .00 3,000.00 .00 .00 413.22 2,586.78 141 822.92 Other E=quipment 15,000.00 .00 15,000.00 .00 .00 1,059.00 13,941.00 7 .00 EXPENSE TOTALS $28,500.00 $0.00 $28,500.00 $0.00 $0.00 $4,262.46 $24,237.54 15 °/) $3,772.66 Fund 046 - Foreign Fire Tax Board Fund Totals $28,500.00 $0.00 $28,500.00 $0.00 $0.00 $4,262.46 $24,237.54 $3,772.66 Expense Budget by Account Classification .`' Report Through 06/30/12 Prior Fiscal Year Activity Included 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 050 - Water and Sewer Fund EXPENSE Personal Services, Scheduled Salaries & Wages 1,856,769.00 .00 1,856,769.00 143,621.02 .00 817,273.89 1,039,495.11 44 746,314.80 Employee Benefits 684,136.00 .00 684,136.00 51,149.32 .00 333,874.84 350,261.16 49 320,066.44 Other Employee Costs 35,941.00 .00 35,941.00 180.00 1,126.78 16,869.32 17,944.90 50 8,558.72 Contractual Services 5,924,961.00 68,392.00 5,993,353.00 568,154.04 272,949.46 2,559,112.20 3,161,291.34 47 2,291,664.80 Utilities 198,006.00 .00 198,006.00 14,258.47 .00 60,055.57 137,950.43 30 49,903.72 Insurance 70,098.00 .00 70,098.00 5,841.50 .00 35,049.00 35,049.00 50 38,418.96 Commodities & Supplies 312,616.00 .00 312,616.00 13,739.82 24,165.91 76,971.61 211,478.48 32 97,221.53 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Office Equipment 6,544,00 .00 6,544.00 .00 .00 .00 6,544.00 0 .00 Other Equipment 1,004,503.00 697,561.00 1,702,064.00 24,749.50 36,880.10 83,030.50 1,582,153.40 7 73,318.09 Distribution Systems 1,883,600.00 44,995.00 1,928,595.00 10,382.76 788,338.00 27,513.59 1,112,743.41 42 979,129.17 Infrastructure 30,000.00 .00 30,000.00 .00 .00 .00 30,000.00 0 .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 $12,007,174.00 $810,948.00 $12,818,122.00 $832,076.43 $1,123,460.25 $4,009,750.52 $7,684,911.23 40% $4,614,596.23 Fund 050 - Water and Sewer Fund Totals $12,007,174.00 $810,948.00 $12,818,122.00 $832,076.43 $1,123,460.25 $4,009,750.52 $7,684,911.23 $4,614,596.23 F- cn F rn Expense Budget Iby Account classification Report Account Classification Fund 051 •• Village Parking System Fund EXPENSE Through 06/30/12 Prior Fiscal Year Activity Included 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 21,729.00 .00 21,729.00 1,650.03 .00 9,509.36 12,219.64 44 7,459.45 Employee Benefits 6,265.00 .00 6,265.00 494.80 .00 2,968.56 3,296.44 47 4,069.34 Contractual Services 94,796.00 .00 94,796.00 6,422.85 1.3,774.49 53,431.64 27,589.87 71. 34,043.28 Insurance 812.00 .00 812.00 67.67 .00 406.02 405.98 50 377.52 Commodities & Supplies 500.00 .00 500.00 .00 .00 .00 500.00 fl .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Building Improvements 6,800.00 .00 6,800.00 .00 .00 .00 6,800.00 (I 5,000.00 Infrastructure 50,000.00 73,500.00 123,500.00 .00 5,000.00 .00 118,500.00 41. .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $180,902,.00 $73,500.00 $254,402.00 $8,635.35 $18,774.49 $66,315.58 $169,311.93 33% $50,949.59 Fund 051- Village Parking System Fund Totals $180,902,.00 $73,500.00 $254,402.00 $8,635.35 $18,774.49 $66,315.58 $169,311.93 $50,949.59 Expense Budget by Account Classification Report Account Classification Fund 052 - Parking System Revenue Fund EXPENSE Personal Services, Scheduled Salaries & Wages Employee Benefits Contractual Services Utilities Insurance Commodities & Supplies Other Expenditures Building Improvements Infrastructure Interfund Transfers EXPENSE TOTALS Fund 052 - Parking System Revenue Fund Totals Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 41,031.00 .00 41,031.00 3,234.42 .00 18,451.14 22,579.86 45 16,555.30 17,443.00 .00 17,443.00 1,402.23 .00 8,283.77 9,159.23 47 5,659.16 112,063.00 .00 112,063.00 6,021.92 3,758.70 39,265.09 69,039.21 38 36,745.01 10,317.00 .00 10,317.00 387.17 .00 2,162.07 8,154.93 21 3,906.30 1,138.00 .00 1,138.00 94.83 .00 568.98 569.02 50 505.50 9,586.00 .00 9,586.00 629.55 .00 2,486.15 7,099.85 26 239.67 .00 .00 .00 .00 .00 .00 .00 ... .00 25,000.00 25,000.00 50,000.00 .00 .00 .00 50,000.00 0 .00 .00 34,070.00 34,070.00 .00 .00 27,018.81 7,051.19 79 .00 .00 .00 .00 .00 .00 .00 .00 ... .00 $216,578.00 $59,070.00 $275,648.00 $11,770.12 $3,758.70 $98,236.01 $173,653.29 37% $63,610.94 $216,578.00 $59,070.00 $275,648.00 $11,770.12 $3,758.70 $98,236.01 $173,653.29 $63,610.94 r 00 Expense Budget by Account classification Deport Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 060 - Vehicle Maintenance Fund EXPENSE Personal Services, Scheduled Salaries & Wages 936,976.00 .00 936,976.00 68,520.67 .00 428,296.64 508,679.36 46 407,285.79 Employee Benefits 367,789.00 .00 367,789.00 27,255.21 .00 170,579.83 197,209.17 46 154,782.68 Other Employee Costs 2,315.00 .00 2,315.00 .00 .00 451.00 1,864.00 19 320.00 Contractual Services 95,738.00 .00 95,738.00 5,695.42 13,866.22 30,767.71 51,104.07 47 43,780.45 Utilities 993.00 .00 993.00 71.41 .00 432.96 560.04 44 260.23 Commodities & Supplies 603,349.00 .00 603,349.00 46,366.26 51,669.16 292,825.57 258,854.27 57 330,304.20 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Office Equipment 545.00 .00 545.00 .00 .00 .00 545.00 0 .00 Other Equipment 3,500.00 .00 3,500.00 149.50 .00 919.42 2,580.58 26 3,054.67 EXPENSE TOTALS $2,011,205.00 $0.00 $2,011,205.00 $148,058.47 $65,535.38 $924,273.13 $1,021,396.49 49% $939,788.02 Fund 060 - Vehicle Maintenance Fund Totals $2,011,205.00 $0.00 $2,011,205.00 $148,058.47 $65,535.38 $924,273.13 $1,021,396.49 $939,788.02 Expense Budget by Account Classification = Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transaction Encumbrance Through 06/30/12 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 061 - Vehicle Replacement Fund EXPENSE Other Expenditures .00 .00 .00 .00 .00 .00 .00 + ++ .00 Motor Equipment 1,321,800.00 .00 1,321,800.00 23,712.00 561,268.74 245,394.87 515,136.39 61 52,996.30 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $1,321,800.00 $0.00 $1,321,800.00 $23,712.00 $561,268.74 $245,394.87 $515,136.39 61% $52,996.30 Fund 061 - Vehicle Replacement Fund Totals $1,321,800.00 $0.00 $1,321,800.00 $23,712.00 $561,268.74 $245,394.87 $515,136.39 $52,996.30 r N O Expense Budget by Account classification A:eport Account Classification Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 062 - Computer Replacement Fund EXPENSE Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Office Equipment 233,900.00 .00 233,900.00 .00 .00 35,244.77 198,655.23 15 24,414.35 EXPENSE TOTALS $233,900.00 $0.00 $233,900.00 $0.00 $0.00 $35,244.77 $198,655.23 15% $24,414.35 Fund 062 - Computer Replacement Fund Totals $233,900.00 $0.00 $233,900.00 $0.00 $0.00 $35,244.77 $198,655.23 $24,414.35 Expense Budget by Account Classification Report Account Classification Fund 063 - Risk Management Fund EXPENSE Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Contractual Services 13,500.00 11,000.00 24,500.00 .00 .00 11,000.00 13,500.00 45 500.00 Insurance 6,831,455.00 .00 6,831,455.00 539,343.94 1,970.00 3,641,047.67 3,188,437.33 53 3,287,569.56 Other Equipment .00 .00 .00 .00 .00 .00 .00 +++ .00 Infrastructure .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $6,844,955.00 $11,000.00 $6,855,955.00 $539,343.94 $1,970.00 $3,652,047.67 $3,201,937.33 53% $3,288,069.56 Fund 063 - Risk Management Fund Totals $6,844,955,00 $11,000.00 $6,855,955.00 $539,343.94 $1,970.00 $3,652,047.67 $3,201,937.33 $3,288,069.56 N Expense Budget by Account Classification Report Through 06/30/12 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 070 - Police Pension Fund EXPENSE Pension Benefits 3,646,470.00 .00 3,646,470.00 309,021.63 .00 1,819,608.22 1,826,861.78 50 1,782,058.08 Contractual Services 125,500.00 .00 125,500.00 2,267.42 .00 37,126.84 88,373.16 30 50,761.58 Insurance 10,000.00 .00 10,000.00 .00 .00 .00 10,000.00 U .00 Commodities & Supplies 500.00 .00 500.00 .00 .00 .00 500.00 U 61.11 Other Expenditures 12,000.00 .00 12,000.00 .00 .00 902.12 11,097.88 8 8,319.88 Office Equipment .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $3,794,470.00 $0.00 $3,794,470.00 $311,289.05 $0.00 $1,857,637.18 $1,936,832.82 49% $1,841,200.65 Fund 070 - Police Pension Fund Totals $3,794,470.00 $0.00 $3,794,470.00 $311,289.05 $0.00 $1,857,637.18 $1,936,832.82 $1,841,200.65 Expense Budget by Account Classification Report Through 06/30/12 Prior Fiscal Year Activity Included 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 071- Fire Pension Fund EXPENSE Pension Benefits 3,647,069.00 .00 3,647,069.00 311,314.08 .00 1,829,245.53 1,817,823.47 50 1,771,764.69 Contractual Services 124,000.00 .00 124,000.00 971.77 .00 35,473.80 88,526.20 29 53,916.63 Insurance 11,000.00 .00 11,000.00 .00 .00 .00 11,000.00 0 .00 Commodities & Supplies 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 2.00 Other Expenditures 12,000.00 .00 12,000.00 .00 .00 875.00 11,125.00 7 8,120.00 EXPENSE TOTALS $3,795,069.00 $0.00 $3,795,069.00 $312,285.85 $0.00 $1,865,594.33 $1,929,474.67 49% $1,833,803.32 Fund 071- Fire Pension Fund Totals $3,795,069.00 $0.00 $3,795,069.00 $312,285.85 $0.00 $1,865,594.33 $1,929,474.67 $1,833,803.32 Grand Totals $87,632,445.00 $2,464,692.00 $90,097,137.00 $6,285,069.03 $4,249,939.35 $36,311,125.95 $49,536,071.70 $38,583,885.64 N W Fund Vendor Name VILLAGE OF MOUNT PROSPECT List of Bills June 28 - -- July 11, 2012 Invoice Description 001 General Fund A Stars & Stripes Flag Corporation Civic Events ACS State & Local Government Solutions Illinois State Disbursement Unit Active Alarm Company, Inc. 3rd Quarter alarm monitoring at the CCC Addison Building Material Co. Street Basin Supplies Streets Supplies Credit Maintenance and repair supplies Maintenance and repair supplies Civic Events Supplies Alexander Equip.co., Inc. Equipment maintenance supplies Forestry Equipment and Supplies Ali, Alyssa Alyssa Ali, talent for inside the park Allen, Douglas Sign Making Materials Amer Reprographics Co Llc Equipment Maintenance American Landscaping Inc. 2011 Grass Cutting - 1 S. Albert Abatement - 10 Stevenson Abatement -48 Judith Ann Anderson Pest Solutions July pest control at the CCC Andres Medical Billing, Ltd. Ambulance Billing -June 2012 Applied Controls, Inc. Equipment Maintenance and Repair Aramark Uniform Services, Inc. Uniform Cleaning & Rental Uniform Cleaning & Rental ARC Disposal Company Debris Disposal Arrowhead Scientific Inc. Evidence collection supplies Arte Verde Garden Center & Landscape Co. Forestry Tree /Bush /Flower Replacement Forestry Tree /Bush /Flower Replacement AT & T Service 6/16/12 - 7/15/12 B & H Photo /video Video Supplies Baldini, Carol Supplies for Medical Reserve Corp Supplies for the MRC/ CCC Health Fair Barnes Group Sign Making Materials Baudville, Inc. Certificate supplies Bedco Mechanical Replacement of high pressure switch at Public Works hvac system Inspect Liebert ac unit at Police /Fire, compressor tested bad Besse Medical Supply Medical supplies for CCC Health Fair Blue Saints Drum & Bugle Corps 4th of July Parade 2012 Bound Tree Medical, LLC. Gloves and Intubation Kits Gloves and Intubation Kits Gloves and Intubation Kits Bright Electrical Supply Co. Maintenance and repair supplies Maintenance and repair supplies Brownells, Inc. Range equipment Bures, Paul Clothing Allowance Clothing Allowance Busse's Flowers & Gifts Sympathy Arrangement Case Lots, Inc. Paper towels to be used in all buildings Cash Surveillance expenses CDW Government, Inc. Replacement Printer Trays Equipment maintenance supplies Central Continental Bakery Maintenance and repair supplies Central Service Center Radar repair & certification Century Cleaners Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Chem -wise Ecological Pest Mgmt Inc Monthly pest control at all buildings Chicago Title Insurance 3015 Lynn Court 223 N. Maple 2004 Scott Terrace Chicago Tribune Acct # 000030634923 Newspaper subscription Chichizola, Maria Gabriela Magic show at the Community Connection Center CL Graphics, Inc. Printing - Appointed Boards and Commissions brochure Printing - Village Board Brochure Clark, Sandra M. Clothing Reimbursement Comcast Xfinity Internet service Cook County Recorder of Deeds Recording Page 1 of 8 - Amount 194.34 2,899.36 73.50 (39.56) 167.49 (5.94) 23.06 29.94 184.54 216.05 195.50 300.00 1,214.40 62.00 250.00 718.00 179.00 48.00 4,552.83 1,980.00 110.24 110.24 268.35 392.34 535.50 1,471.47 340.96 1,116.19 268.72 57.78 73.44 29.00 220.00 330.00 269.49 1,500.00 173.82 76.92 76.92 (53.37) 276.30 859.89 107.64 192.36 88.50 1,672.25 1,000.00 240.55 163.00 84.42 162.00 22.35 26.07 11.18 11.90 15.58 185.01 725.00 650.00 650.00 390.00 150.00 645.93 586.42 180.21 66.00 238.00 VILLAGE OF MOUNT PROSPECT List of Bills June 28 - July 11, 2012 Fund Vendor Name Invoice Description Amount Costa, Frank Rebate Transfer Stamp 958.00 Costco Wholesale Purchase 5/25/12 - 6/19/12 465.23 Crystal Court Shopping Center July rent for the CCC - Invoice 4999 5,447.00 Davis, Laura Reimburse training expenses 40.00 Elite Remodeling Group, Inc. Garnishment 142.22 Emigh, Michael Rebate Sidewalk Shared Cost Program 365.20 Enterprise Rent -a -car Toll violation fee 15.75 Toll violation fee 1.10 Toll violation fee 1.10 Entersect Corporation Entersect Police Online service 88.95 Everbank Commercial Finance, Inc. Copy Machines Usage 7/23/12 2,364.71 Copy Machine Usage 7/24/12 423.04 Evident Crime Scene Products Evidence collection supplies 145.00 Experian Background checks 77.72 Federal Express Corp Postage Expense June 2012 5.96 FedEx (3) Pick -ups - 109.61 Postage Expense June 2012 5.96 Fire Pension Fund Fire Pension 21,322.81 Fleck's Landscaping Grounds Maintenance 5,859.70 Flink Company Replace salt spreader to match fleet with trade 947.00 Frizane, Kenneth 4th of July Parade 2012 300.00 Gall's, Inc. Disposable emergency blankets 798.49 Antiseptic biohand cleaner 77.05 GE Capital Period 6/15/12 - 7/14/12 853.11 Glenn Stearns Chapter 13 Trustee Garnishment 200.00 Grainger Inc. 1 -5NY99 canopy shelter and 5 -1F099 key rings 11/4 in. 14.90 1 -5NY99 canopy shelter and 5 -11`099 key rings 11/4 in. 122.50 Maintenance and repair supplies 19.04 Maintenance Repair and Supplies 11.76 Maintenance and repair supplies 145.54 Guardian Emp. Dental Plan July 2012 8,912.57 Guziel, Fran Marketing services - April- may -June 3,000.00 Hastings Air Energy Control Inc. Service & Repair 209.95 Healy Asphalt Company,llc. Asphalt materials and prime for street patching 92.38 Asphalt materials for street patching 35.02 Patching materials for street repairs 34.51 Patching materials for street repairs 57.17 Asphalt materials for street patching 13.39 Asphalt patching materials for streets 33.48 Heinking, Jill Reimburse Jill Heinking for Health Fair Supplies 25.25 Homer Tree Care, Inc. Tree Removals 1,871.65 Streetscape Corridor Maintenance 675.00 Streetscape Corridor Maintenance 675.00 Streetscape Corridor Maintenance 675.00 Streetscape Corridor Maintenance 675.00 House of Szechwan Special Manual Check 6/28/12 246.70 IACE Quarterly Meeting - 7.11.12 105.00 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 16,996.55 Illinois American Water Company Service 5/14/12 - 6/15112 1,524.58 Illinois Department of Revenue June Monthly Payroll void /reissue eft's 56.43 IL State Withholding 34,466.54 Illinois Region - Marc 4th of July Parade 2012 300.00 IMRF IMRF 144,418.95 Independence Winter Guard 4th of July Parade 2012 150.00 Initial Tropical Plants Inc. Equipment Maintenance 955.80 Internal Revenue Service June Monthly Payroll void /reissue eft's 863.85 Federal Withholding 155,878.14 International Union of Operating Engineers IUOE PW Membership Dues 578.23 Jackson - hirsh, Inc. Office Supplies 261.00 Journal & Topics Newspapers 2011 Treasurer's Report 1,071.00 Kidd, Daniel Reimburse training expenses 80.00 Kuhn, Keith CDL Reimbursement 30.00 Lands' End Business Outfitters Clothing 493.47 Liebovich Bros, Inc. Salt Spreader Parts 260.74 Life Assist Instakool cold packs 89.27 Ice Packs- MRC Grant Funds 182.50 Luxottica Retail North America Prescription lenses for gas mask 36.00 Maclin, Wendell 4th of July Parade 2012 1,500.00 PaaP 7 of R VILLAGE OF MOUNT PROSPECT List of Bills June 28 - July 11, 2012 Fund Vendor Name Invoice Description Amount Malcolm, John Malcolm/ Photo Supplies 83.05 Martello, Madeline Rebate Sidewalk Shared Cost Program 275.00 Martini, Stephen P Petty Cash 37.43 McDonald's Corporation Prisoner meals - May, 2012 333.58 McGuffin, Mark Reimburse training expenses 50.00 Menards Building Maintenance and Repair 11.59 Wire Brush and 2 Files 22.55 Metro Federal Credit Union MP Fire Local 4119 Dues 2,318.11 Metropolitan Alliance - Police MP Police Association Dues 1,198.50 Meyer Laboratory, Inc. Cleaning supplies to be used in all buildings 597.14 Micro Tech Systems, Inc. Equipment Maintenance and Repair 238.45 Midwest Brickpaving, Inc. Brick Repair 7,599.69 Mobile Print Inc. Business Cards /Sheets - Garcia, Beckner 92.15 Friday on the Green Postcard & poster 1,205.71 Butterfly posters & postcards 173.63 Mount Prospect Park District 4th of July Parade 2012 350.00 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 12,341.47 NCPERS Group Life Ins. IMRF Life Insurance 642.40 New Generation Fancy Drill Team 4th of July Parade 2012 2,000.00 Nextel Communications Air card 39.99 NICOR Natural Gas Consumption 18.39 Natural Gas Consumption 21.98 Natural Gas Consumption 19.24 Northwest Central Dispatch System August 2012 - Member Assessment 49,679.40 Northwest Suburban United Way United Way 260.25 Northwestern University Griffin's graduation luncheon 165.00 Numbers Automation Inc Admin shredder maintenance agreement 150.00 Office Depot Office Supplies 651.26 Office Supplies - May 88.95 Office Supplies for Humans Services and the CCC 123.56 PIO office supplies 120.07 Pacific Telemanagement Services Service 7/1/12 - 7/31/12 78.00 Pacon Corporation Special Events Supplies 1,995.85 Paddock Publications, Inc. Legal notice 64.80 Legal notice 81.00 Pastori, Matthew Expenses/ Pastori June 7 &8 2012 Sch "B" Only 300.00 Paul Hall Community Center 4th of July Parade 2012 900.00 Paulding, Christine C Refund Overpayment Police Ticket #C53983 20.00 Pesche's Flower Shop Forestry Tree /Bush /Flower Replacements 404.73 Petty Cash Petty Cash 181.29 Petty Cash 6/1/12- 7/6/12 419.34 Police Pension Fund Police Pension 28,132.61 Pope, Elizabeth A. Garnishment 923.08 Prairie Brass Band 4th of July Parade 2012 2,000.00 Prendo Forensics Llc Evidence collection supplies 596.05 Prosafety, Inc. Coveralls & swat shirts 4 PW employees as needed by replacement 155.00 Restocking of first aid kits for all Public Works employees 426.48 Proviso West High School Marching Band 4th of July Parade 2012 800.00 Randolph, Daniel CDL Reimbursement 30.00 Red Wing Shoe Store Safety Shoe Expense 118.99 Reinders, Inc. Irrigation Parts 57.03 Ricmar Industries, Inc. Janitorial supplies for all buildings 651.40 Ronco Industrial Supply Supplies for 4th of July float decorating 109.90 Degreaser to be used in all buildings 139.14 Special Event Supplies 158.07 Forestry Supplies 19.75 Sound Incorporated Maintenance Contract for phones, switches & server 72.00 South Shore Drill Team &performing Arts 4th of July Parade 2012 3,500.00 Stanard & Associates, Inc. Recruitment Testing /Smith, Patrick 6/7/12 375.00 Staples Contract & Commercial, Inc. Office Supplies 497.60 State of Illinois Monthly Internet Service Fee 755.00 Stephen A. Laser Assoc.,p.c. Pre - employment testing 550.00 Suburban Accents Inc Printing of "We Care Logos" 63.00 "We Care" Logos on Clear 45.00 T.P.I. Building Inspections 23,548.00 The Mosquitos, Ltd. Friday on the Green Performance - 08/03/12 550.00 Township High School Dist. 214 4th of July Parade 2012 2,000.00 Trugreen Limited Partnership Contractual Spraying 5,236.00 Page 3 u( 8 VILLAGE OF MOUNT PROSPECT List of Bills June 28 - July 11, 2012 Fund Vendor Name Invoice Description Amount U.S. Bank Equipment Finance, Inc. Usage 7/16/12 - 1700 W Central Rd 167.50 $ Copy Machines - Usage 7/20/12 1,362.28 Design /Consultation Services Usage 7/20/12 - 1601 West Golf Road 138.78 Ultra Strobe Communications, Inc. Squad Emergency Equipment 123.00 United States Postal Service CAPS Postage June 3,510.74 University of Illinois Registration/ Ricker MGMT IV May 14 -18 Lockport IL 250.00 EECBG - MP Sust Ed Program 2nd Qtr 2012 (Library partner) Registration/ Pastori, Murphy FF Core Comp Class June 7 & 8 2012 300.00 UPS Store #707 Shipping Charges 10.53 Verizon Wireless Services LLC Cellular Service /Equipment May 20 -June 19 13,449.51 Village of Mount Prospect Flex - Parking 11,394.49 Walega, Joseph A 4th of July Parade 2012 800.00 Warehouse Direct 1 WHO TONER / B/C OFFICE 113.49 32,607.08 Office Supplies 227.06 Office Supplies 99.83 Wenzel, Paul M. Friday on the Green Performance- 07/06/12 1,000.00 West Publishing Corporation Training reference materials 76.00 Wilks, Irvana Cellular Telephone Service Fees 45.00 W ISCTF Garnishment 542.48 Wizniak, Stephanie Refund Overpayment Vehicle License 18.00 001 General Fund Total IL State Withholding $ 639,360.99 020 Capital Improvement Fund Bright Electrical Supply Co. Improvements to Public Buildings $ 390.36 EWS Consultants, Inc. Design /Consultation Services 160.00 Gewalt Hamilton Assoc. Kensington Road Phase II Reconstruction 12,390.50 Menards Improvements to Public Buildings 57.31 Mount Prospect Public Library EECBG - MP Sust Ed Program 2nd Qtr 2012 (Library partner) 555.00 New World Systems Corporation ERP - Installation Services and Travel Time (NexGen) 5,200.00 ERP Software License and Installation Services 3,250.00 Northwest Central 9 -1 -1 System Motorola Subscriber Financing -July 2012 Obligation 10,603.91 020 Capital Improvement Fund Total $ 32,607.08 023 Street Improvement Construction Fund Midwest Brickpaving, Inc. Brick Repair $ 11,300.31 023 Street Improvement Construction Fund Total $ 11,300.31 040 Refuse Disposal Fund ICMA Retirement Trust -457 ICMA 457 (flat percent) $ 17.22 Illinois Department of Revenue IL State Withholding 382.34 IMRF IMRF 2,792.50 Internal Revenue Service Federal Withholding 2,420.86 International Union of Operating Engineers IUOE PW Membership Dues 61.98 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 45.00 NCPERS Group Life Ins. IMRF Life Insurance 8.00 Northwest Suburban United Way United Way 3.00 Village of Mount Prospect Flex - Parking 67.50 040 Refuse Disposal Fund Total $ 5,798.40 041 Motor Fuel Tax Fund Commonwealth Edison Electrical Service Delivery $ 9,200.00 Electrical Service Delivery 20.44 Exelon Corporation Electrical Service Delivery 20.65 Electrical Service Delivery 83.22 Electrical Service Delivery 232.67 Electrical Service Delivery 86.75 Electrical Service Delivery 2,840.13 Electrical Service Delivery 81.49 Electrical Service Delivery 98.43 Electrical Service Delivery 60.09 Electrical Service Delivery 152.04 Electrical Service Delivery 19.66 Electrical Service Delivery 93.18 Electrical Service Delivery 96.71 Electrical Service Delivery 117.87 Lyons & Pinner Electric Companies Traffic Light Maintenance 1,740.81 Morton Salt, Inc Salt /De -Icing Agents - Complete minimum State Contract Order 1,329.62 Salt /De -Icing Agents - Complete minimum State Contract Order 7,751.21 Salt /De -Icing Agents 11,561.27 Page 4 of 8 Fund Vendor Name VILLAGE OF MOUNT PROSPECT List of Bills June 28 - July 11, 2012 Invoice Desci Addison Building Material Co. Road salt to fulfill minimum order for 2012. Alexander Chemical Salt /De -Icing Agents Amber Realty Inc Salt /De -Icing Agents American Landscaping Inc. Salt /De -Icing Agents 041 Motor Fuel Tax Fund Total Grounds Maintenance 042 Community Development Block Grant Uniform Cleaning & Rental Chicago Title Insurance CDBG Title Search- Gates Baxter & Woodman, Inc. CDBG Title Search- McDonnell Becker, Carl G CDBG SFR Title Search- Plikas Energy 360 Solutions, Inc. CDBG SFR -1718 Magnolia Everbank Commercial Finance, Inc. Copy Machines Usage 7/23/12 GE Capital Period 6/15/12 - 7/14/12 Greater Wheeling Youth Outreach Inc. CDBG- Summer Adventure Camp North ICMA Retirement Trust - 457 ICMA 457 (flat percent) Illinois Department of Revenue IL State Withholding IMRF IMRF Internal Revenue Service Federal Withholding Northwest Center Against Sexual Assualt CDBG first quarter The Lead Inspectors, USA Inc CDBG 1103 Hunt Club #230 Village of Mount Prospect Flex - Parking 042 Community Development Block Grant Total 050 Water and Sewer Fund Addison Building Material Co. Maintenance and Repair Supplies Alexander Chemical Sewer /Water System Treatment Chemical Amber Realty Inc Refund Final Utility Bill Acct# 914102 American Landscaping Inc. Grounds Maintenance Grounds Maintenance Aramark Uniform Services, Inc. Uniform Cleaning & Rental Uniform Cleaning & Rental Baxter & Woodman, Inc. Engineering Services Becker, Carl G Refund Final Utility Bill Acct #487901 Breitzman, James Reimbursement Century Cleaners Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Exelon Corporation Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery Federal Express Corp Shipping Expense Grainger Inc. Hydrant Maintenance and Repair Hansen, Donald E. Safety Shoe Reimbursement HBK Water Meter Service Water Meter and Building Inspection Services Water Meter and Building Inspection Services Water Meter and Building Inspection Services Hesch, Marion Refund Final Utility Bill Acct# 636602 ICMA Retirement Trust - 457 ICMA 457 (flat percent) Illinois Department of Revenue IL State Withholding Illinois Dept.of Public Health Repair Maintenance Supplies IMRF IMRF Internal Revenue Service Federal Withholding International Union of Operating Engineers IUOE PW Membership Dues Jackson - hirsh, Inc. Office Supplies Manhard Consulting Ltd. Engineering Mcmaster -carr Supply Co. Hydrant Maintenance and Repair National Power Rodding Corp. Emergency Repair Nationwide Mutual Insurance Company Nationwide 457 (flat percent) NCPERS Group Life Ins. IMRF Life Insurance NICOR Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Northwest Suburban United Way United Way Page 5 of 8 Amount 6,334.59 7,969.29 9,072.98 1,265.59 $ 60,228.69 75.00 75.00 75.00 7,185.00 17.60 213.27 5,040.00 112.50 101.85 503.64 570.37 210.00 275.00 56.25 14,510.48 41.90 216.00 30.76 888.00 3,125.75 110.24 110.24 2,377.02 361.43 369.68 22.35 26.08 11.17 11.90 15.57 723.09 73.68 1,247.36 39.22 71.28 76.00 87.32 122.45 180.00 25.00 5,215.00 4,502.00 32.19 1,102.65 3,111.02 80.00 21,930.60 17,721.79 492.63 255.50 2,259.90 31.46 1,590.05 258.89 34.40 63.66 60.27 81.53 25.00 VILLAGE OF MOUNT PROSPECT List of Bills June 28 - July 11, 2012 Fund Vendor Name Invoice Description Amount Paddock Publications, Inc. Legal notice 79.65 Peerless Midwest Inc Maintenance and repair supplies 1,000.00 IMRF Equipment Booster Pump 14,127.50 Prosafety, Inc. Restocking of first aid kits for all Public Works employees 426.47 217.25 Repair and Maintenance Supplies 264.60 Red Wing Shoe Store Safety Shoe Expenses 180.00 RMS Asset Management Refund Final utility Bill Acct# 1035901 199.94 Slack, L. E Refund Final Utility Bill Acct# 624501 156.85 Smart Roofing, Inc. Building Maintenance 671.00 Building Maintenance 260.00 Flex - Parking Building Maintenance 2,548.00 051 Village Parking System Fund Total Building Maintenance 3,458.00 Staples Contract & Commercial, Inc. Office Supplies 118.14 Suburban Laboratories, Inc. Annual IEPA- Required Water Sample Testing 397.00 Tank Industry Consultants, Inc. Professional Services 3,800.00 U.S. Bank Equipment Finance, Inc. Usage 7/16/12 - 1700 W Central Rd 167.50 142.21 Copy Machines - Usage 7/20/12 137.50 United States Postal Service CAPS Postage June 2,150.61 Verizon Wireless Services LLC Cellular Service /Equipment May 20 -June 19 813.00 Village of Mount Prospect Flex - Parking 754.56 Ziebell Water Service Products Maintenance and repair supplies 332.06 Maintenance and repair supplies 385.46 050 Water and Sewer Fund Total $ 101,639.87 051 Village Parking System Fund Chem -wise Ecological Pest Mgmt Inc Monthly pest control at all buildings $ 29.99 Illinois Department of Revenue IL State Withholding 36.16 IMRF IMRF 263.64 Internal Revenue Service Federal Withholding 217.25 International Union of Operating Engineers IUOE PW Membership Dues 9.92 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 21.95 NCPERS Group Life Ins. IMRF Life Insurance 1.92 Petty Cash Petty Cash 6/1/12- 7/6/12 20.00 Village of Mount Prospect Flex - Parking 23.50 051 Village Parking System Fund Total $ 624.33 052 Parking System Revenue Fund Anderson Lock Company Maintenance and repair supplies $ 462.55 Elite Remodeling Group, Inc. Garnishment 142.21 Illinois Department of Revenue IL State Withholding 58.52 IMRF IMRF 516.92 Internal Revenue Service Federal Withholding 327.07 International Union of Operating Engineers IUOE PW Membership Dues 6.62 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 14.67 NCPERS Group Life Ins. IMRF Life Insurance 1.28 Petty Cash Petty Cash 6/1/12- 7/6/12 11.00 Union Pacific Railroad May Land Lease 4,243.57 Village of Mount Prospect Flex - Parking 78.20 052 Parking System Revenue Fund Total $ 5,862.61 060 Vehicle Maintenance Fund ACS State & Local Government Solutions Addison Building Material Co. Illinois State Disbursement Unit Small Tools Vehicle Maintenance Supplies Vehicle Maintenance Supplies Equipment Maintenance Professional Service 2708 Right rear taillight assy Equipment Maintenance Vehicle Maintenance Supplies Vehicle Maintenance Supplies Screws, cable ties, washers, fuel line, fuses, etc Reimbursement Equipment Maintenance Telephone Equipment and Supplies Vehicle Maintenance Supplies Vehicle Maintenance Supplies 515 Pump shift kit 480.24 11.99 55.71 271.80 279.00 99.96 50.72 6.47 13.38 7.44 447.65 369.68 62.40 21.84 192.02 617.30 68.04 Alexander Equip.co., Inc. Allstar Auto Glass American Messaging Arlington Heights Ford Arlington Power Equipment Barnes Group Breitzman, James Bristol Hose & Fitting Castro, Joe Catching Fluidpower Enterprise Oil Co Global Emergency Products P.- F. of R VILLAGE OF MOUNT PROSPECT List of Bills June 28 - July 11, 2012 Fund Vendor Name Invoice Description Amount Grainger Inc. Vehicle Maintenance Supplies 8.81 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 537.66 Illinois Department of Revenue IL State Withholding 1,441.84 IMRF IMRF 10,903.57 Internal Revenue Service Federal Withholding 8,068.89 International Union of Operating Engineers IUOE PW Membership Dues 304.09 Just Tires Vehicle Maintenance Supplies 172.50 L & B Business Services Inc. Telephone Equipment and Supplies 17.98 114.00 Vehicle Maintenance Supplies 40.65 MPC Communications & Lighting Vehicle Maintenance Supplies 174.93 Napa- Heights Automotive Supply 550 Oil filter 4.36 063 Risk Management Fund Total P -9 Exhaust gasket 10.98 42,523.44 P -9 Spark plugs 15.92 Air hose couplers and adapters 31.90 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 210.00 NCPERS Group Life Ins. IMRF Life Insurance 64.00 Northwest Suburban United Way United Way 12.69 Parkside Auto Body Inc Equipment Maintenance and Repair 809.50 Prairie International Truck Sales 4541 Fan clutch drive 402.26 Werderitch, Randall C. Credit (52.87) Precision Service & Parts Credit (75.00) $ Police Impala wiper blades 58.52 P -15 Squad fan, relay and trans fluid 468.08 Addante, Frank Police squad spark plugs and boots 82.94 125.00 24 Squad oil filters 90.00 P -42 Tire sensor 39.86 Ronco Industrial Supply Small Tools Maintenance Supplies 190.85 Bradley, Ronald H Small Tools Maintenance 34.83 Sto -away Power Cranes, Inc. Vehicle Maintenance Supplies 289.88 Vehicle Maintenance Supplies 39.47 Superior Signals, Inc. Vehicle Maintenance Supplies 137.42 Verizon Wireless Services LLC Cellular Service /Equipment May 20 -June 19 405.10 Village of Mount Prospect Flex - Parking 531.66 Warehouse Direct Office Supplies 99.84 Waytek, Inc. Vehicle Maintenance Supplies 258.32 West Side Tractor Sales Vehicle Maintenance Supplies 178.85 060 Vehicle Maintenance Fund Total $ 29,065.92 061 Vehicle Replacement Fund Flink Company 2 new salt spreaders for new trucks 4517 and 4522 split equally $ 6,088.00 Prairie International Truck Sales New truck replacement for 4517 73,299.00 New truck replacement for 4522 71,449.00 061 Vehicle Replacement Fund Total $ 150,836.00 063 Risk Management Fund Cannon Cochran Management Services, Inc. W/C Claims -June 2012 $ 41,693.44 Gab Robins N.a., Inc. - Citibank Liability Claims 114.00 Lefevre, Paul Replace Damaged Gutter on side of House (Inv #2211) 260.00 Reliance Plumbing, Sewer & Drainage, Inc Inside Cleanout - Mainline Rod (Inv #429333) 456.00 063 Risk Management Fund Total $ 42,523.44 070 Police Pension Fund Becker, Burke Associates Inc Consulting Services 7/1/12 - 9/30/12 $ 9,000.00 070 Police Pension Fund Total $ 9,000.00 071 Fire Pension Fund Becker, Burke Associates Inc Consulting Services 7/1/12 - 9/30/12 $ 9,000.00 Werderitch, Randall C. 2012 2nd Quarter Admin Assistance Fee 350.00 071 Fire Pension Fund Total $ 9,350.00 073 Escrow Deposit Fund Addante, Frank Refund Escrow Permit # 12 -1007 $ 125.00 Babal, Victor Refund Escrow Permit# 12 -0441 200.00 Baghdassarian, Rimon Refund Escrow Permit # 12 -0962 200.00 Bradley, Ronald H Refund Escrow Permit # 12 -0810 200.00 Bruno's Maintenance Refund Escrow Permit # 12 -0652 200.00 Concrete Construction Refund Escrow Permit # 12 -0932 200.00 Demarco, Linda 1 Refund Escrow Permit # 12 -1026 125.00 Paao 7 of R VILLAGE OF MOUNT PROSPECT List of Bills June 28 - July 11, 2012 Fund Vendor Name Invoice Description Amount Discount Heating Refund Escrow Permit # 11 -2687 200.00 Elite Remodeling Group, Inc. Arciszewski - 06/21/12 278.74 Faust, Irmgard Refund Escrow Permit # 12 -1009 125.00 Geiser Berner Plumbing Service Inc Refund Escrow Permit # 12 -1081 125.00 Giambalvo, Karen G Refund Escrow Permit # 12 -0687 200.00 House, Judith Refund Escrow Permit # 12 -1001 125.00 Ibbotson Heating Company Refund Escrow Permit # 12 -0956 125.00 Infinity Property Services Refund Escrow Permit # 12 -0350 350.00 Iversen, Laura Refund Escrow Permit # 12 -0853 125.00 Lacey, Pat Refund Escrow Permit # 12 -0721 75.00 Mount Prospect Heating & AC Refund Escrow Permit # 12 -0348 75.00 Okon, David Replacement Check# 764160 35.22 P & R Diversity Group Inc Refund Escrow Permit # 12 -0708 75.00 Precision Plumbing Services Inc Refund Escrow Permit # 11 -1933 125.00 Prestige Electric LLC Refund Escrow Permit # 12 -0973 125.00 Quality Blacktop LLC Refund Escrow Permit # 12 -1002 200.00 Ravenswood Special Events, Inc. Block Party 2012 5,500.00 Regency Garages Refund Escrow Permit # 12 -0379 350.00 Rick's Sewer & Drainage Refund Escrow Permit # 12 -1034 125.00 Schwartz, Steven G Refund Escrow Permit # 12 -0380 200.00 Refund Escrow Permit # 12 -0387 125.00 Shola, Sarah Elizabeth Refund Escrow Permit # 12 -0680 200.00 Sundstrom, James E Refund Escrow Permit # 12 -0925 200.00 Tejani, Aziz Refund Escrow Permit # 12 -0844 200.00 Third District Circuit Court Bond Check 6/28/12 570.00 Bond Check 7/3/2012 670.00 Bond Check 7/6/12 570.00 Bond Check 7/10/12 440.00 TMW Enterprises Paving & Maintenance Refund Escrow Permit # 12 -0284 150.00 073 Escrow Deposit Fund Total $ 12,913.96 074 Series 2002 Library Bond Bank of New York Mellon Admin Fee GO Library Bonds, Series 2002 $ 300.00 074 Series 2002 Library Bond Total $ 300.00 Grand Total $ 1,125,922.08 VILLAGE OF MOUNT PROSPECT List of Bills June 14 - June 27, 2012 Fund Vendor Name Invoice Description Amount 001 General Fund ACS State & Local Government Solutions Illinois State Disbursement Unit $ 2,899.36 Airgas, Inc. Oxygen & Cylinder Rental 161.07 Oxygen & Cylinder Rental 185.13 Oxygen & Cylinder Rental 200.16 Oxygen & Cylinder Rental 144.97 Alexian Brothers Medical Center Pre employment testing Joseph Gruensfelder 69.00 Pre employment testing Michelle Cusack 69.00 Pre employment testing Fairburn, Kiess, Madejczyk, Sepulveda 276.00 Pre -emp testing Bakker, Enter, Lello, Papke, .Shaffer, Snyder 414.00 Pre - employment testing Krystina Leazer, Eric Rusk 138.00 Pre - employment testing Natalie Pacini 69.00 Anderson Pest Solutions Pest Control Services 95.00 Andres Medical Billing, Ltd. Medicare's Revalidation Fee 523.00 Apex Textilgraphics Inc. Crime Free Housing supplies 899.00 Aramark Uniform Services, Inc. Uniform Cleaning & Rental 112.89 Uniform cleaning and rentals for Public Works employees 110.24 ARC Disposal Company Debris Contract Hauling 994.56 AT & T AT & T Long Distance 5/1/12 - 5/31/12 1,260.45 Service 6/10/12 - 7/9/12 2,356.71 Service 6/7/12 - 7/6/12 290.57 Bedco Mechanical Building Maintenance and Repair 422.50 Briscoe, Deborah Training registration: J. Juhl 185.00 Briski, Justin Safety Shoe Expense 180.00 C.B.M.T. Greenhouse, Inc. Forestry Flowers Replacements 285.95 CDW Government, Inc. Equipment maintenance supplies 206.72 Smartnet Renewals 3,774.65 Equipment maintenance supplies 22.96 Central Continental Bakery Cake 42 Century Cleaners Uniform Cleaning 14.90 Uniform Cleaning 24.47 Uniform Cleaning 21.63 Uniform Cleaning 18.62 Uniform Cleaning 22.35 Uniform Cleaning 22.25 Uniform Cleaning 8.17 Uniform Cleaning 18.63 Uniform Cleaning 18.62 Uniform Cleaning 15.58 Uniform Cleaning 5.95 Uniform Cleaning 14.18 Cogan, Kevin Rebate Transfer Stamp 830.00 Commonwealth Edison Electrical Service Delivery 26.09 Electrical Service Delivery 16.75 Electrical Service Delivery 25.62 Electrical Service Delivery 25.84 Compudata Products, Inc. Office supplies & copy paper 633.33 Consery F /S, Inc. Grounds Maintenance Supplies 776.30 Cook County Recorder of Deeds Recording 182.00 Costar Realty Information, Inc. ED Site Software 475.03 Crystal Court Shopping Center June rent for CCC 5,447.00 Crystal Maintenance Services Corp. Cleaning services for one month for all Village owned buildings 6,163.62 CVS Pharmacy, Inc. Prisoner medication Case #12 -8282 1.30 Cygnus Business Media, Inc. Subscription/ Malcolm Firehouse Magazine 29.95 D.J.'s Scuba Locker BCD Parts & Labor / AGA Regulator Service 727.80 Debajyoti, Mahanta Refund Overpayment of Ticket #P3918206 10.00 Dirtbusters Auto Detailing, Inc. Full detail for D/C Wagner's vehicle, S -26 193.50 Display Supply & Lighting, Inc. Maintenance and repair supplies 246.16 Dupage Topsoil Inc. Pulverized Topsoil Delivery 199.87 Entersect Corporation Entersect Police Online service 88.95 Eterno, David G. May adjudication 412.50 Evident Crime Scene Products Evidence collection supplies 397.50 Federal Express Corp Shipping Charges 35.80 Ferno Washington Inc. 2 Cot Mattresses 217.85 2 Cot Mattresses 217.85 Fifth Third Bank Credit Card 99.83 Fire Pension Fund Fire Pension 21,640.54 Fire Pension (317.73) Page 1 of 8 VILLAGE OF MOUNT PROSPECT List of Bills June 14 -June 27, 2012 Fund Vendor Name Invoice Description Amount Fulton Technologies, Inc. Warning Siren System Monitoring fee 07/01/12 to 06/30/2013 414.00 Glenn Stearns Chapter 13 Trustee Garnishment 200.00 Healy Asphalt Company,llc. Street Patching Materials 34.51 Street Patching Materials 42.23 Street Patching Materials 38.63 Street Patching Materials 22.66 Street Patching Materials 29.36 Asphalt patching materials used for street repairs 32.45 Hispanic Illinois State Law Enforcement Membership: M. Semkiu 40.00 Home Depot U.S.A., Inc. Maintenance and repair supplies 499.65 Homer Tree Care, Inc. Tree Removals 4,903.90 Tree Removals 2,068.00 Tree Removal 6,230.35 Streetscape Corridar Maintenance 675.00 Streetscape Corridar Maintenance 750.00 IACP Membership: M. Semkiu 50.00 ICMA Membership Fees 1,400.00 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 17,211.35 ICMA 457 (flat percent) (100.00) Icon Identity Refund Plan Review Fees 650.00 Illinois Department of Revenue IL State Withholding 34,888.66 IL State Withholding 56.43 Illinois State Police Pre -emp bg check for 15 interns and 1 FT emp @ $31.50 ea 504.00 Internal Revenue Service Federal Withholding 157,687.62 Federal Withholding 481.26 Federal Withholding 382.59 International Association of Fire Chiefs Membership/ Malcolm 2012 204.00 International Union of Operating Engineers IUOE PW Membership Dues 578.25 1 and N Enterprises, Inc. Sensit Gold "4" Gas Parts/ Labor 346.97 J.G. Uniforms, Inc. Ballistic vests 9,666.00 John E. Reid and Associates Pre - Employment Testing/ NEW HIRE Smith, Patrick 200.00 Journal & Topics Newspapers PZ -11 -12 Legal Notice 126.96 PZ -14 -12 Legal Notice 132.48 PZ -16 -12 Legal Notice 126.96 K. Fish Color LLC Purchase of Various Annual Flowers 4,706.05 Karlstedt Landscape, Inc. Forestry Tree /Bush /Flower Replacement 900.00 Kathleen W. Bono,csr,ltd. Legal 179.00 Kerstein, June Reimb May 2012 Food Expense & June 2012 Phone Expense 63.15 Klein, Thorpe and Jenkins, Ltd. April billing 70,120.60 May Billing 58,246.93 Kleinstein, Howard Video supplies - Batteries 402.67 Kone, Inc. Equipment Maintenance & Repair 289.00 Lund Industries, Inc. Computer antenna for squad cars 97.02 Mcmaster -carr Supply Co. Maintenance & Repair Supplies 625.14 McVeigh- Cushing, Cathleen A. Edit of Library Life 425.00 Mele Sr, Robert Rebate Sidewalk Shared -Cost Program 275.00 Menards ET Equipment 204.18 Maintenance and repair supplies 8.47 Mercury Partners 90 BI Inc. Vehicle Maintenance Supplies 105.00 Metro Federal Credit Union MP Fire Local 4119 Dues 2,396.69 MP Fire Local 4119 Dues (39.29) Metropolitan Alliance - Police MP Police Association Dues 1,198.50 Michael Wagner & Sons, Inc. Maintenance and repair supplies 261.90 Mobile Print Inc. Chiefs letterhead 192.06 Moore Landscapes, Inc. Grounds Maintenance Service 1,305.00 Mortimer, Kyle Safety Shoe Expense 131.09 Mount Prospect Historical Soc. July 2012 Budget Allocation 3,333.33 Mount Prospect Public Library Comm.Connections Center Study - Professional Services Fee 3/1 -3/6 3,200.00 Nacrelli, Tina Training Supplies 149.00 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 13,341.48 Neopost USA Inc. Ink cartridges 462.00 Postage Machine Replenishment - 06/08 3,000.00 Nextel Communications Air cards 159.96 Wireless cards - invoice 984298104 -054 239.94 Nexus Office Systems, Inc. Semi - Annual Maintenance 4/14/12- 10/14/12 4,656.93 North East Multi Regional Trng Course registration fee 50.00 Training registrations 100.00 Northshore University Healthsystem Pre - employment testing 860.00 Page 2 of 8 VILLAGE OF MOUNT PROSPECT List of Bills June 14 -June 27, 2012 Fund Vendor Name Invoice Description Amount Northwest Suburban United Way United Way 248.75 Novak & Parker Inc. Item # 0094 Refrigerator Tray Station #13 33.18 OCSI Training Inc. Training registration: A. Lietzow 75.00 Otto Engineering, Inc. Radio supplies 230.90 Overhead Garage Door, Inc. Building Maintenance 851.61 Paddock Publications, Inc. Legal notice 32.40 Legal notice 310.50 Bid Notice 58.05 Legal notice 39.15 Pesche's Flower Shop Forestry Annual Flowers Replacement 139.65 Petty Cash Petty -Cash Fire Department 152.83 Police Pension Fund Police Pension 27,793.25 Pope, Elizabeth A. Garnishment 923.08 Powell Tree Care, Inc. Parkway Tree Stump Removal 9,012.67 Professional Cardiac Services Cardiac Stress Test for POC Todd Sulak 204.00 Rebel's Trophies, Inc. Resolution Plaque John Dahlberg 275.00 San Filippo Landscape Inc. Release Retainage 2011 270.94 Security Research Inc Replacement Check #769081 25.00 Security Solutions dba Avrio RMS Group Switch configuration /installation 775.00 Seymour, Lindsey Rebate Sidewalk Shared -Cost Program 302.00 Sound Incorporated Monthly phone system support 828.83 Southern WI Northern IL Fire Rescue Association Membership/ Malcolm MAY 1- APRIL 30, 2013 25.00 Standard Equipment Company 4502 Steering pins 211.65 Steiner Electric Company Streetlight Supplies 2,053.44 Streetlights Supplies 377.56 Task Force 1 Inc. Registration/ Lambel, Uidl, Mertes Arpil 4 -5 Mayday Event 570.00 Teevan, Allison Reimburse training expenses 80.00 The T.L.C. Group LTD Grounds Maintenance 1,758.24 Thompson Elevator Inspections Elevator Inspections 928.00 Elevator Inspections 408.00 Trane US Inc. Maintenance and repair supplies 24.00 Tri -state Electronic Corp Maintenance and repair supplies 32.01 Maintenance and repair supplies 47.05 Uline Inc. Evidence collection supplies 81.59 United Parcel Service Shipping charges for equipment repairs 41.82 Shipping charges for equipment repairs 13.13 Usalis, Dan Rebate Sidewalk Shared Program 275.00 Vantagepoint Transfer Agents Payroll 6/21/2012 Dahlberg RHS 40,304.44 RHS - Willming 4,458.36 VCG Uniform Uniform supplies: R. Smith 227.00 Verizon Wireless Services LLC Air cards for squad cars 1,294.89 Village of Mount Prospect Flex - Medical 11,798.45 Flex - Medical (75.00) Flex Deductions 11,584.08 Garnishment 139.37 Service 5/1/12 - 6/4/12 28.07 Wal -Mart Community Maintenance and repair supplies 182.46 Warehouse Direct Office Supplies 366.63 Wide Open West WOW Internet for MPTV Video Stream 59.50 Wilks, Irvana April /May billing 45.00 March /April billing 45.00 Wisconsin Department of Revenue WI State Withholding 873.48 W ISCTF Garnishment 542.48 001 General Fund Total $ 588,999.44 002 Debt Service Fund Cook County Government Agency 03- 0820 -105 refunds $ 3.11 J.P. Morgan Chase Bank N.A. 2012 Bond Interest 37,914.72 2011B Bond Interest 64,197.00 002 Debt Service Fund Total $ 102,114.83 020 Capital Improvement Fund Guziel, Fran Design /Layout of Station 14 LEED Brochure $ 840.00 Northwest Central 9 -1 -1 System Motorola Subscriber Financing - June 2012 Obligation 10,603.91 020 Capital Improvement Fund Total $ 11,443.91 022 Downtown Redevelopment Construction Fund The T.L.C. Group LTD Grounds Maintenance $ 6,332.85 Page 3 of 8 VILLAGE OF MOUNT PROSPECT List of Bills June 14 - June 27, 2012 Fund Vendor Name Invoice Description Amount 022 Downtown Redevelopment Construction Fund Total $ 6,332.85 023 Street Improvement Construction Fund Arrow Road Construction Street Resurfacing Program $ 243,931.25 Ciorba Group Inc Engineering Services 2,190.84 023 Street Improvement Construction Fund Total $ 246,122.09 024 Flood Control Construction Fund Fleck's Landscaping Creek Raking $ 3,510.00 024 Flood Control Construction Fund Total $ 3,530.00 040 Refuse Disposal Fund ARC Disposal Company Refuse Disposal Services $ 248,691.96 AT&T AT & T Long Distance 5/1/12 - 5/31/12 7.01 Service 6/10/12 - 7/9/12 12.81 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 17.22 Illinois Department of Revenue IL State Withholding 360.88 Internal Revenue Service Federal Withholding 2,253.97 International Union of Operating Engineers IUOE PW Membership Dues 61.98 Jewel Food Stores # 3476 Refund Damaged Yard Waste Stickers ($31.50) & Com miss ion( -$.70) 30.80 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 44.99 Northwest Suburban United Way United Way 3.00 Village of Mount Prospect Flex - Medical 67.49 Flex Deductions 67.49 Wells Fargo Bank SWAN CC -July 2012 97,436.84 040 Refuse Disposal Fund Total $ 349,056.44 041 Motor Fuel Tax Fund Arrow Road Construction Street Resurfacing Program $ 95,533.96 Exelon Corporation Electrical Service Delivery 5439 041 Motor Fuel Tax Fund Total $ 95,588.75 042 Community Development Block Grant ICMA Retirement Trust - 457 ICMA 457 (flat percent) $ 112.50 Illinois Department of Revenue IL State Withholding 98.10 Internal Revenue Service Federal Withholding 549.17 Klein, Thorpe and Jenkins, Ltd. April billing 95.00 May Billing 2,582.71 Paddock Publications, Inc. Legal Notice Soliciting Apps for 2013 Funding 62.10 Saewert, Janet Energy & Environmental Building Association Builders Guide 35.00 Houses That Work Chicago Seminar 140.00 Village of Mount Prospect Flex - Medical 56.25 Flex Deductions 56.25 042 Community Development Block Grant Total $ 3,787.08 043 Asset Seizure Fund LeadsOnline LLC LeadsOnline TotalTrack service package $ 5,158.00 043 Asset Seizure Fund Total $ 5,158.00 047 Justice Assistance Grant Fund Armadillo Truck Vault Inc. Equipment storage /work surface in P -5 $ 2,920.57 Equipment for P -5 475.00 047 Justice Assistance Grant Fund Total $ 3,395.57 050 Water and Sewer Fund ADT Security Services, Inc. Building Maintenance $ 90.00 Building Maintenance 90.00 Building Maintenance 3,161.88 Building Maintenance 90.00 Aramark Uniform Services, Inc. Uniform Cleaning & Rental 112.90 Uniform cleaning and rentals for Public Works employees 110.24 Arof, Rob Refund Final Utility Bill Acct# 782002 30.76 AT & T AT & T Long Distance 5/1/12 - 5/31/12 468.01 Service 6/10/12 - 7/9/12 451.62 Service 6/10/12 - 7/9/12 855.27 Service 6/10/12 - 7/9/12 263.39 Bank of New York Mellon JAWA - May 2012 405,859.00 Breitzman, James Cell phone supplies 196.24 Page 4 of 8 VILLAGE OF MOUNT PROSPECT List of Bills June 14 - June 27, 2012 Fund Vendor Name Invoice Description Amount Carlson, Lisa Refund Final Utility Bill Acct# 837502 123.04 Century Cleaners Uniform Cleaning 14.90 Uniform Cleaning 24.48 Uniform Cleaning 21.62 Uniform Cleaning 18.63 Uniform Cleaning 22.35 Uniform Cleaning 22.25 Uniform Cleaning 8.18 Uniform Cleaning 18.62 Uniform Cleaning 18.63 Uniform Cleaning 15.57 Uniform Cleaning S.95 Uniform Cleaning 14.17 Costello, Cheryl L Refund Overpayment Utility Bill Acct #802001 72.80 Dupage Topsoil Inc. Pulverized Topsoil Delivery 85.13 Exelon Corporation Electrical Service Delivery 1,330.18 Electrical Service Delivery 192.25 Electrical Service Delivery 1,164.28 Electrical Service Delivery 46.52 Electrical Service Delivery 70.19 Electrical Service Delivery 1,868.82 Electrical Service Delivery 74.43 Electrical Service Delivery 109.77 Electrical Service Delivery 43.66 Electrical Service Delivery 55.08 French, Charlene Refund Final Utility Bill Acct# 1065507 15.38 Gewalt Hamilton Assoc. Engineering Services 2,200.00 HBK Water Meter Service Water Meter and Building Inspection Services 2,766.00 Water Meter and Building Inspection Services 1,034.26 Water Meter and Building Inspection Services 337.50 Water Meter and Building Inspection Services 4,869.00 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 1,132.37 Illinois Department of Revenue IL State Withholding 3,130.69 Internal Revenue Service Federal Withholding 17,893.34 International Union of Operating Engineers IUOE PW Membership Dues 492.63 Jaro, Chester Refund Final Utility Bill Acct# 301701- Replacement Check 152.92 Kieft Brothers Inc. Sewer Water Valves 181.S0 Sewer Water Valves 286.00 Sewer Water Valves 227.70 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 258.89 Nexus Office Systems, Inc. Semi - Annual Maintenance 4/14/12- 10/14/12 1,625.26 Northwest Suburban United Way United Way 25.00 Orsinger, Jaillee Refund Final Utility Bill Acct# 509501 30.76 Paddock Publications, Inc. Bid Notice 66.15 San Filippo Landscape Inc. Release Retainage 2011 9.81 Suburban Laboratories, Inc. Annual IEPA- Required Water Sample Testing 600.00 The T.L.C. Group LTD Grounds Maintenance 1,797.80 Village of Mount Prospect Flex - Medical 7S4.S6 Flex Deductions 754.56 Ziebell Water Service Products Sewer Water Valves 259.45 050 Water and Sewer Fund Total $ 458,122.34 051 Village Parking System Fund Crystal Maintenance Services Corp. Cleaning services for one month for all Village owned buildings $ 2,015.86 Illinois Department of Revenue IL State Withholding 36.11 Internal Revenue Service Federal Withholding 216.92 International Union of Operating Engineers IUOE PW Membership Dues 9.92 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 21.95 Village of Mount Prospect Flex - Medical 23.50 Flex Deductions 23.50 051 Village Parking System Fund Total $ 2,347.76 052 Parking System Revenue Fund Crystal Maintenance Services Corp. Cleaning services for one month for all Village owned buildings $ 290.52 Des Plaines Glass Company Maintenance and repair supplies 167.00 Exelon Corporation Electrical Service Delivery 249.66 Electrical Service Delivery 109.44 Illinois Department of Revenue IL State Withholding 58.50 Page 5 of 8 Fund Vendor Name Internal Revenue Service International Union of Operating Engineers Nationwide Mutual Insurance Company Village of Mount Prospect 052 Parking System Revenue Fund Total 060 Vehicle Maintenance Fund ACS State & Local Government Solutions Arlington Heights Ford AT &T Barnes Group Breitzman, lames Chicago Parts & Sound Lic Computerized Fleet Analysis Dave & Jim's Auto Body, Inc. Enginemasters, Inc. Equipment Depot of Illinois Geib Industries, Inc. Grossinger Chevrolet ICMA Retirement Trust - 457 Illinois Department of Revenue Inland Power Group Inc. Internal Revenue Service International Union of Operating Engineers J. P. Simons & Company James Drive Safety Lane LLC Mcmaster -carr Supply Co. Messick Farm EQ Napa- Heights Automotive Supply Nationwide Mutual Insurance Company Northwest Suburban United Way Petersens Hydraulic Jack, Inc. Pomp's Tire Service, Inc. Prairie International Truck Sales Precision Service & Parts Ronco Industrial Supply Terrace Supply Company Village of Mount Prospect VILLAGE OF MOUNT PROSPECT List of Bills June 14 - June 27, 2012 Invoice Federal Withholding IUOE PW Membership Dues Nationwide 457 (flat percent) Flex - Medical Flex Deductions Garnishment Service 5/1/12 - 6/4/12 Illinois State Disbursement Unit 503 Shift lever Squad air bag jewels ABS ring for escape S -26 Rubber floor mats 2718 Shift lever AT & T Long Distance S/1/12 - 5/31/12 Service 6/10/12 - 7/9/12 Electrical terminals, tape, washers, nuts, bolts, threaded rod Small Tool Expense Brake pads P -1 Blower motor Equipment Maintenance and Repair Equipment Maintenance and Repair Vehicle Maintenance Supplies Vehicle Maintenance Supplies Equipment Maintenance and Repair 2736 Tailgate bezel S -25 Front floor mats 2710 Steering intermediate shaft ICMA 457 (flat percent) IL State Withholding 12 oil filters for fire trucks Federal Withholding IUOE PW Membership Dues Vehicle Maintenance Supplies Equipment Vehicle Maintenance Supplies Vehicle Maintenance Supplies 503 Ball joint P -13 Stabilizer link Headlight bulbs 2758 Sway bar link Brakleen 2732 Sway bar bushing 2732 Steering Stabilizer shock Small eq spark plugs Nationwide 457 (flat percent) United Way Equipment Maintenance and Repair 4536 Tire repair Vehicle Maintenance Supplies Vehicle Maintenance Supplies 2754 Coolant sensor 2754 Temp sensor P -1 Blower motor Squad brake pads 24 Oil filters 2759 Front brake pads and rotors 2708 Spark plugs 2709 Power steering pump A/C freon P -34 Blower motor P -42 Spark plugs Small Tools Vehicle Maintenance Supplies Flex - Medical Flex Deductions Page 6 of 8 Amount 326.90 6.60 14.67 217.57 78.20 139.37 28.07 $ 1,686.50 $ 480.24 46.71 23.44 6.23 70.40 54.69 17.53 32.04 438.37 102.47 76.98 71.80 695.00 50.00 74.60 348.66 9.96 58.06 59.50 75.79 515.81 1,388.24 149.96 7,733.82 304.09 51.59 384.00 24.02 313.48 69.49 69.14 13.34 62.98 358.80 11.88 41.38 15.92 210.00 12.69 581.00 105.00 1,504.30 103.91 52.87 23.16 59.00 157.44 72.00 241.44 20.40 121.63 374.04 41.12 46.88 31.84 53.46 531.66 531.66 VILLAGE OF MOUNT PROSPECT List of Bills June 14 - June 27, 2012 Fund Vendor Name Invoice Description Amount West Side Tractor Sales Vehicle Maintenance Supplies 303.76 Wholesale Direct Inc. Vehicle Maintenance Supplies 120.52 Credit for wrong part (110.94) 060 Vehicle Maintenance Fund Total $ 19,489.25 061 Vehicle Replacement Fund Bonnell Industries Inc. New truck dump bodies for 4517 and 4522 $ 18,442.00 061 Vehicle Replacement Fund Total $ 18,442.00 063 Risk Management Fund Cannon Cochran Management Services, Inc. Take Over Claims Fee 1/1/12- 12/31/12 $ 200.00 Intergovernmental Per.ben.coop IPBC - June 2012 491,572.52 The Cima Companies, Inc. Volunteer Insurance Renewal 7 /1/12 - 7/1/13 2,102.00 063 Risk Management Fund Total $ 493,874.52 070 Police Pension Fund Internal Revenue Service Federal Withholding $ 37,192.36 Richard Reimer & Assoc., LLC. Legal Services Rendered 4/4/12 - 5/23/12 1,184.55 070 Police Pension Fund Total $ 38,376.91 071 Fire Pension Fund Internal Revenue Service Federal Withholding $ 35,906.98 071 Fire Pension Fund Total $ 35,906.98 073 Escrow Deposit Fund Aarons, David Refund Escrow Permit # 12 -0981 $ 200.00 Alaimo, Michael Refund Escrow Permit # 11 -2698 125.00 Amari, Daniel / Rafat Refund Escrow Permit # 11 -1320 25.00 Anchor Sign Inc Refund Escrow Permit # 12 -0662 125.00 Andoniadis, Martha Refund Escrow Permit # 12 -0858 200.00 Batalia, Donald Refund Escrow Permit # 12 -0375 200.00 Benedetto, Tony Di Refund Escrow Permit # 12 -0892 200.00 Brik, Mak Refund Escrow Permit # 12 -0965 200.00 Calliari, Therese Refund Escrow Permit # 12 -0374 125.00 Casto Lifestyle Randhurst Shopping Center LLC Refund Escrow Permit # 12 -0061 125.00 Clexton, Cheryl Refund Escrow Permit # 12 -0886 200.00 Complete Building Maintenance Co Refund Escrow Permit # 11 -1146 200.00 Refund Escrow Permit # 12 -0364 125.00 Custom Outdoor Designs Inc Refund Escrow Permit # 12 -0795 200.00 Danley Lumber Company Refund Escrow Permit # 12 -0262 250.00 Das, Subhasis Refund Escrow Permit # 12 -0678 150.00 Dynek, Robert Refund Escrow Permit # 11 -0760 125.00 Expert Concrete Solution Inc Refund Escrow Permit # 12 -0938 200.00 F & F Cement Construction Co Refund Escrow Permit # 12 -0851 200.00 Fortis Concrete Refund Escrow Permit # 12 -0473 200.00 Four Seasons Heating and A/C Refund Escrow Permit # 12 -0971 125.00 Friar, Michael Brendan Refund Escrow Permit # 12 -0296 150.00 Fritz Konstruction Inc Refund Escrow Permit # 12 -0951 15.00 Harmony Construction Inc Refund Escrow Permit # 12 -0169 250.00 Hernandez, Peter Refund Escrow Permit # 12 -0868 125.00 Hess, Robert & Julie Refund Escrow Permit # 09 -0475 500.00 Ibbotson Heating Company Refund Escrow Permit # 12 -0888 125.00 Refund Escrow Permit # 12 -0928 125.00 Issel, William J Refund Escrow Permit# 12 -0701 125.00 J8,J General Cement LLC Refund Escrow Permit # 12 -0289 200.00 1NL Climate Control Inc Refund Escrow Permit # 12 -0904 125.00 Kaikaris, John Refund Escrow Permit # 11 -1800 150.00 Keene, Janine Refund Escrow Permit # 12 -0944 125.00 Kmiecik, James Refund Escrow Permit # 12 -0551 200.00 Martello, Robert Refund Escrow Permit # 12 -0881 200.00 Martinez, Jose Cruz Refund Escrow Permit # 12 -0517 150.00 Martire, Peter Refund Escrow Permit # 12 -0201 150.00 McKee, Patrick Refund Escrow Permit # 12 -0843 75.00 MFenini Concrete Refund Escrow Permit # 12 -0794 200.00 Milewski, Janusz Refund Escrow Permit # 12 -0839 200.00 Molinare Construction Refund Escrow Permit # 12 -0575 150.00 O'Hare, Margaret J Refund Escrow Permit # 12 -0864 75.00 Penco Electric Inc Refund Escrow Permit # 11 -2745 125.00 Page 7 of 8 VILLAGE OF MOUNT PROSPECT List of Bills June 14 - June 27, 2012 Fund Vendor Name Invoice Description Amount Pinas, James C Refund Escrow Permit # 12 -0682 200.00 Preferred Electrical Construction Corporation Refund Escrow Permit # 11 -2214 350.00 Renovations Refund Escrow Permit # 12 -0408 250.00 Richer, Thomas J Refund Escrow Permit # 12 -0710 125.00 Rick's Sewer & Drainage Refund Escrow Permit # 12 -0905 125.00 Roof Pros Corp Refund Escrow Permit # 12 -0912 125.00 Roongphornchai, Pat Refund Escrow Permit # 12 -0529 75.00 Sandacz, Ralph M Refund Escrow Permit # 12 -0389 200.00 Scaravalle Construction Inc Refund Escrow Permit # 12 -0659 150.00 Sultan, Sheikh S Refund Escrow Permit # 12 -0902 125.00 SWC Construction Refund Escrow Permit # 12 -0305 150.00 Refund Escrow Permit # 12 -0835 200.00 Third District Circuit Court Bond Check 6/19/12 2,910.00 Bond Check 6/20/12 320.00 Bond Check 6/26/12 1,970.00 US Waterproofing Inc Refund Escrow Permit # 12 -0510 125.00 Village Sewer & Plumbing Refund Escrow Permit # 12 -0281 125.00 Water Works Inc Refund Escrow Permit # 11 -2593 375.00 Wizniak, Stephanie A Refund Escrow Permit # 12 -0777 125.00 Xclusive Concrete & Brick Paving Refund Escrow Permit # 12 -0671 150.00 Z Best Ladscaping Refund Escrow Permit # 12 -0600 200.00 073 Escrow Deposit Fund Total $ 15,415.00 074 Series 2002 Library Bond J.P. Morgan Chase Bank N.A. 074 Series 2002 Library Bond Total 2011A Bond Interest $ 35,306.25 $ 35,306.25 Grand Total Page 8 of 8 $ 2,534,476.47