The URL can be used to link to this page

Home My WebLink About3. Monthly Financial Report & Approve Bills 11/18/2014Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM i TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: NOVEMBER 14, 2014 SUBJECT: MONTHLY FINANCIAL REPORT — OCTOBER 2014 Attached hereto are the cash position and investment statements of the Village for the month ended October 31, 2014. These statements provide a snapshot of the Village's cash position as of the month end date noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you receive. The first statement presents the Village's cash position broken down by governmental and enterprise funds and trust and agency funds. The second statement presents the Village's cash position by fund type. The third statement presents the list of investments again broken down by governmental and enterprise funds and trust and agency funds. It is important to note that although we have included the trust and agency funds in the cash position report, these funds are not accessible for Village operations. They are restricted for pension and escrow funding only. Please read the summary that follows for further detail on the cash position of the Village. Cash and Investment Position Report — All Funds (Pape 1) This report provides a detail summary of cash and investments for the Village broken out by governmental and enterprise funds and trust and agency funds. Governmental funds include the General Fund, Special Revenue Funds, Debt Service Fund, Capital Project Funds and Internal Service Funds. The Enterprise Funds consist of the Water/Sewer Fund and two (2) Parking Funds. Trust funds include the Village's two public safety pensions (Police and Firefighters') while the agency funds include the Escrow Deposit, Flexcomp Escrow and Library Bonds Escrow Fund. The Escrow Deposit Fund accounts for refundable deposits held by the Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Library Bonds Escrow Fund accounts for the accumulation of monies for debt service payments. Governmental and Enterprise Funds - Cash and cash equivalents at September 30 was $49.5 million. During October, cash receipts totaled $5,232,249. In addition investment income for the month was $2,090, and inflows due to investment activity added $999,910 to the balance. Reductions in cash and cash equivalents during October totaled $5,931,993. Of this amount, payments to vendors were $4,567,561 and employee payroll and related expenses were $1,304,155. Other disbursements of $60,277 accounted for the balance of the change during October. Cash and cash equivalents at October 31 were $49.8 million. Monthly Financial Report — October 2014 November 14, 2014 Page 2 Investments in the Governmental and Enterprise Funds at September 30 were $2.2 million. $1.0 million worth of CD's matured during October. CD's in the Governmental and Enterprise Funds reside in the Flood Control Fund and were purchased using proceeds from the Series 2013 bond issue. The maturity dates of the CD's are laddered to match the expected payout schedule of the underlying flood control work. Total investments at October 31 were $1.2 million. Total cash and investments for Governmental and Enterprise Funds at September 30 were $51,755,211. Cash and investments at October 31 totaled $51,064,310. This is a decrease of $690,901. Trust and Agency Funds - Cash and cash equivalents at September 30 was $4.7 million. During October, cash receipts totaled $1,570,735. Investment income for the month was $79,491 while outflows due to Interfund activity totaled $5,542. There was also a net decrease in cash due to investment activities of $242,453. Reductions in cash and cash equivalents during October totaled $802,723. Of this amount, payments to vendors were $193,879, employee payroll and related expenses were $578,983, payments related to the flexible ending program totaled $13,404. Other disbursements were $16,457. Cash and cash equivalents at October 31 were $5.3 million. Total investments at October 31 were $111,331,226, an increase of $1,433,682 from September 30. There was an unrealized investment gain of $1,191,229 and a transfer from cash of $242,453 that accounted for the change. Total cash and investments for Trust and Agency Funds at September 30 were $114,643,296. Cash and investments at October 31 totaled $116,676,486. This is an increase for the month of $2,033,190. Summary of Cash Activity by Fund Type (pape 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 September 30 totaled $10.0 million. During October, cash receipts totaled $2,897,580 and investment income was $159. Significant cash receipts included sales and state income taxes. Sales tax revenues for the month totaled $1,246,833. Of this amount, $1,128,234 was generated from the 1% state portion while $118,599 was generated from the .25% home rule portion. Sales taxes received in October are for July sales as there is a three-month lag in getting this distribution from the state. HAACC-Ureasurer's Report\20141Monthly Cash Position Report - October 2014.docx Monthly Financial Report — October 2014 November 14, 2014 Page 3 State income tax receipts for October totaled $582,320. Income tax revenue received by the village during this month was to be received in August and September. The state is 1 month in arrears in remitting these taxes to the Village. The total amount in arrears is approximately $510,000. Disbursements from the General Fund for October included payments to vendors of $1,254,524 and payments for employee wages and benefits of $1,158,312. Interfund transfers of $628,724 were also disbursed by the General Fund during October to cover employee health coverage and capital program costs. Cash and cash equivalents at October 31 were $9,808,478. There were no investments in the General Fund at October 31. Statement of Investments (paae 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 October 31 there was a total of $1.2 million invested in CD's. These CD's are investing proceeds of the 2013 flood control bond issue. Other surplus funds in the governmental and enterprise funds have been placed in interest bearing money market accounts. Maturity Purchase Financial Date Date Institution I 1 1 :1 1 !:: 1 1 I 1► ► II I <, 11/18/14 01/21/14 Bank of China, NY 11/18/14 01/21/14 Bank of Houston, TX 11/18/14 01/21/14 State Bank of India, NY 12/18/14 01/21/14 Far East National Bank, CA 12/18/14 01/21/14 Onewest Bank FSB, CA Investment CUSIP/ Interest Market Description FDIC # Rate % Value Certificate of Deposit 33653 0.207% 249,200.00 Certificate of Deposit 57965 0.150% 249,600.00 Certificate of Deposit 33682 0.159% 249,600,00 Certificate of Deposit 21851 0.350% 249,200.00 Certificate of Deposit 58978 0.300% 249,300.00 1,246,900.00 $ 1,246,900.00 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. H:\ACCT\Treasurer's Report\2014\Monthly Cash Position Report - October 2014.docx Monthly Financial Report — October 2014 November 14, 2014 Page 4 Investments in equities consist of mutual funds spread across various sectors (small, mid and large -cap stocks) as well as investment philosophies (value, core and growth). The funds also invest a small amount in international stocks. Each year the investment mix is evaluated for optimal diversification to meet pension fund investment policy goals and objectives. Equity investments held by the Police Pension Fund are managed by Sawyer Falduto Asset Management. Below is a breakdown of how the pension fund portfolios are invested. Maturity Purchase Financial DateDate Institution .......... ... POLICE PENSION FUND (070} Various Various Wells Fargo Various Various Various FIRE PENSION FUND (071) Various Various Wells Fargo Various Various Various 11141II11ftIM1117st= ►1`I17� ► II 1.\ ul Investment CUSIP/ Interest Market Description Acct # Rate % Value Wells Fargo Investments Various Various $ 23,209,065.23 Mutual Fund Investments Various Various 33,520,024,92 56,729,090.15 Wells Fargo Investments Various Various 21,179,716.62 Mutual Fund Investments Various Various 33,422,419,39 54,602,136.01 $ 111,331,226.16 Investment of the Village's pension funds is governed by an Investment Policy adopted by each Pension Board. 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 H:\ACCT\Treasurer's Report\2014\Monthly Cash Position Report - October 2014.docx VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended October 31, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS * Cash and Cash Total Cash and Equivalents Investments Investments Balance at September 30, 2014 $ 4,745,752.21 $ 109,897,544.06 $ 114,643,296.27 Cash receipts Cash and Cash Investment income (loss) Total Cash and Transfers from investments to cash Equivalents Investments Investments Balance at September 30, 2014 $ 49,509,611.03 $ 2,245,600.00 $ 51,755,211.03 Cash receipts 5,232,248.96 5,232,248.96 Investment income 2,089.56 1,210.30 3,299.86 Transfers from investments to cash 999,910.30 (999,910.30) - Transfers to investments from cash - _ - Interfund activity 5,541.84 5,541.84 Disbursements: Accounts payable (4,567,560.95) (4,567,560.95) Payroll (1,304,154.52) (1,304,154.52) Other (60,276.67) (60,276.67) Balance at October 31, 2014 $ 49,817,409.55 $ 1,246,900.00 $ 51,064,309.55 TRUST AND AGENCY FUNDS * Cash and Cash Total Cash and Equivalents Investments Investments Balance at September 30, 2014 $ 4,745,752.21 $ 109,897,544.06 $ 114,643,296.27 Cash receipts 1,570,734.98 Investment income (loss) 79,490.67 1,191,228.63 Transfers from investments to cash 1,881,356.76 (1,881,356.76) Transfers to investments from cash (2,123,810.23) 2,123,810.23 Interfund activity (5,541.84) Disbursements: Accounts payable Payroll Flex spending Other Balance at October 31, 2014 (193,879.47) (578,982.99) (13,403.66) (16,456.64) 1,570,734.98 1,270,719.30 (5,541.84) (193,879.47) (578,982.99) (13,403.66) (16,456.64) $ 5,345,259.79 $ 111,331,226.16 $ 116,676,485.95 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 VILLAGE OF MOUNT PROSPECT N Summary of Cash Activity by Fund Type For the Month Ended October 31, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS * INVESTMENTS Certificates of deposit - - - 1,246,900.00 - 1,246,900.00 c - 1,246,900.00 Wells Fargo investments o - a a - 44,388,781.85 - 44,388,781.85 Mutual fund investments - - - 66.942.444.31 66,942,444.31 Total investments - 1,246,900.00 - - 1,246.900.00 111,331,226.16 112,578,126.16 TOTAL CASH AND INVESTMENTS $ 9,808,478.14 $ 4,157,307.97 $ 1,906,849.70 $ 19.046,767.76 $ 6,106,545.98 $ 10,038,360.00 $ 51,064,309.55 $113,931,571.72 $ 2,744,914.23 $167,740,795.50 * Assets are restricted in purpose and do not represent discretionary assets of the government SPECIAL CAPITAL TOTAL GOVT. FIRE AND OTHER TRUST REVENUE DEBT SERVICE PROJECTS ENTERPRISE INTERNAL AND ENTERPRISE POLICE AND AGENCY GENERALFUND FUNDS FUNDS FUNDS FUNDS SERVICE FUNDS FUNDS PENSIONS FUNDS TOTAL CASH 8. CASH EQUIVALENTS Beginning balance $ 9,957,236.56 $ 4,005,506.64 $ 1,805,471.24 $ 17,317,222.52 $ 5,921,158.81 $ 10,503,015.26 $ 49,509,611.03 $ 3,320,459.21 $ 1,425,293.00 $ 54,255,363.24 Cash receipts 2,897,580.34 549,726.59 101,362.63 351,796.99 1,187,337.91 144,444.50 5,232,248.96 146,079.65 1,424,655.33 6,802,983.94 Investment income 158.58 62.54 15.83 826.05 121.14 905.42 2,089.56 79,298.83 191.84 81,580.23 Transfers from investments - - 999,910.30 - 999,910.30 1,881,356.76 - 2,881,267.06 Transfers to investments - - (2,123,810.23) - (2,123,810.23) Interfund (628,723.71) 22,697.17 - (163,764.82) 775,333.20 5,541.84 (5,541.84) (0.00) Disbursements - other (4,937.49) - - (252.78) (55,086.40) (60,276.67) (16,456.64) (76,733.31) Disbursements - flexible spending - - a - _ - - (13,403.66) (13,403.66) Disbursements -payroll (1,158,312.02) (12,459.50) - (89,053.83) (44,329.17) (1,304,154.52) (578,982.99) (1,883,137.51) Disbursements - accounts payable (1,254,524.12) (408,225.47) - (869.888.10) (749,000.45) (1,285,922.81) (4,567.560.95) (124,055.67) (69,823.80) (4,761.440,42) Ending balance 9,808,478,14 4,157,307.97 1,906,849.70 17,799,867.76 6,106.545.98 10,038,360.00 49,817,409.55 2,600,345.56 2,744,914.23 55,162,669.34 INVESTMENTS Certificates of deposit - - - 1,246,900.00 - 1,246,900.00 c - 1,246,900.00 Wells Fargo investments o - a a - 44,388,781.85 - 44,388,781.85 Mutual fund investments - - - 66.942.444.31 66,942,444.31 Total investments - 1,246,900.00 - - 1,246.900.00 111,331,226.16 112,578,126.16 TOTAL CASH AND INVESTMENTS $ 9,808,478.14 $ 4,157,307.97 $ 1,906,849.70 $ 19.046,767.76 $ 6,106,545.98 $ 10,038,360.00 $ 51,064,309.55 $113,931,571.72 $ 2,744,914.23 $167,740,795.50 * Assets are restricted in purpose and do not represent discretionary assets of the government VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of October 31, 2014 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS Maturity Purchase GOVERNMENTAL AND ENTERPRISE FUNDS Date Maturity Purchase Financial Investment CUSIP/ Date Date _ Institution Description FDIC # FLOOD CONTROL CONSTRUCTION FUND (024) Various Wells Fargo 11/18/14 01/21/14 Bank of China, NY Certificate of Deposit 33653 11/18/14 01/21/14 Bank of Houston, TX Certificate of Deposit 57965 11/18/14 01/21/14 State Bank of India, NY Certificate of Deposit 33682 12/18/14 01/21/14 Far East National Bank, CA Certificate of Deposit 21851 12/18/14 01/21/14 Onewest Bank FSB, CA Certificate of Deposit 58978 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS Maturity Purchase Financial Date Date Institution POLICE PENSION FUND (070) Various Various Wells Fargo Various Various Various FIRE PENSION FUND (071) Various Various Wells Fargo Various Various Various Interest Market Rate % Value 0.207% 249,200.00 0.150% 249,600.00 0.159% 249,600.00 0.350% 249,200.00 0.300% 249,300.00 1,246,900.00 $ 1246,900.00 TRUST AND AGENCY FUNDS * Investment CUSIP/ Interest Market Description Acct # Rate % Value TOTAL TRUST AND AGENCY FUND INVESTMENTS Wells Fargo Investments Various Mutual Fund Investments Various Wells Fargo Investments Various Mutual Fund Investments Various * Assets are restricted in purpose and do not represent discretionary assets of the government. Various $ 23,209,065.23 Various 33,520,024.92 56,729,090.15 Various 21,179,716.62 Various 33,422,419.39 54,602,136.01 $ 111.331,226.16 3 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES October 01— October 31, 2014 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 r Revenue Budget by Account Classification Repoit Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 14,674,466.00 .00 14,674,466.00 42,652.15 .00 14,401,298.02 273,167.98 98 12,554,400.45 8,241,500.00 .00 8,241,500.00 564,716.31 .00 5,372,084.35 2,869,415.65 65 5,146,093.56 1,621,000.00 .00 1,621,000.00 87,649.65 .00 1,547,499.54 73,500.46 95 2,612,813.38 18,083,100.00 .00 18,083,100.00 1,877,735.71 .00 12,709,608.04 5,373,491.96 70 10,849,138.14 1,516,000.00 .00 1,516,000.00 162,962.11 .00 1,298,590.52 217,409.48 86 1,227,369.23 491,000.00 .00 491,000.00 46,543.13 .00 388,941.18 102,058.82 79 347,899.74 22,500.00 .00 22,500.00 352.34 .00 3,788.60 18,711.40 17 11,257.95 226,000.00 .00 226,000.00 13,436.78 .00 303,429.16 (77,429.16) 134 184,222.53 918,500.00 .00 918,500.00 19,089.22 .00 240,271.24 678,228.76 26 333,764.24 20,000.00 .00 20,000.00 .00 .00 20,000.00 .00 100 36,865.05 REVENUE TOTALS $45,814,066.00 $0.00 $45,814,066.00 $2,815,137.40 $0.00 $36,285,510.65 $9,528,555.35 79% $33,303,824.27 Fund 001- General Fund Totals $45,814,066.00 $0.00 $45,814,066.00 $2,815,137.40 $0.00 $36,285,510.65 $9,528,555.35 $33,303,824.27 3E 111211911M Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances 11111 1111 r � L;t MR 511 P :,(A 11910 Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Redd Prior Year YTD Fund 002 - Debt Service Fund REVENUE Property Taxes 2,237,000.00 .00 2,237,000.00 6,451.11 .00 2,206,747.93 30,252.07 99 1,721,906.32 Other Taxes 1,056,532.00 .00 1,056,532.00 93,093.70 .00 590,334.32 466,197.68 56 381,077.47 Intergovernmental Revenue 43,005.00 .00 43,005.00 00 .00 21,927.64 21,077.36 51 21,573.21 Investment Income 400.00 .00 400.00 15.83 .00 67.53 332.47 17 111.25 Other Financing Sources .00 .00 .00 .00 .00 3,231.19 (3,231.19) ... .00 REVENUE TOTALS $3,336,937.00 $0.00 $3,336,937.00 599,560.64 $0.00 $2,822,308.61 $514,628.39 85% $2,124,668.25 Fund 002 - Debt Service Fund Totals $3,336,937.00 $0.00 $3,336,937.00 599,560.64 $0.00 $2,822,308.61 $514,628.39 $2,124,668.25 Account Classification Fund 020 - Capital Improverrmnt Fund REVENUE Revenue Budget by Account Classification Repoit Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Taxes 1,246,000.00 .00 1,246,000.00 109,788.20 .00 696,199.01 549,800.99 56 656,127.63 Intergovernmental Revenue '00 .00 .00 .00 .00 .00 ... 91,171.05 Investment Income 1,000.00 .00 1,000.00 36.53 .00 434.35 565.65 43 501.08 Reimbursements .00 .00 .00 .00 .00 .00 .00 ... .00 Other Revenue 10,000.00 .00 10,000.00 .00 .00 140,181.00 (130,181.00) 1402 307,233.00 Other Financing Sources .00 .00 '00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $1,257,000.00 $0.00 $1,257,000.00 $109,824.73 $0.00 $836,814.36 $420,185.64 67% $1,055,032.76 Fund 020 - Capital Improvement Fund Totals $1,257,000.00 $0.00 $1,257,000.00 $109,824.73 $0.00 $836,814.36 $420,185.64 $1,055,032.76 w .0.. Adopted Budget Amended Current Month YTD Account Classification Budget Amendments Budget Transactions Encumbrances Fund 021- Series 2009 Construction Fund REVENUE :4 till 10 Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD Transactions Transactions Rec'd Prior Year YTD Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 ... .00 Investment Income .00 .00 .00 .00 .00 .00 .00 +++ 7.85 Other Revenue .00 .00 .00 .00 .00 .00 ... .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ... $7.85 Fund 021 - Series 2009 Construction Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.85 137, 1619111 T11;K* I I u�t; 14 111] 1' Adopted Budget Amended Current Month YTD Account Classification Budget Amendments Budget Transactions Encumbrances Fund 022 - Downtown Redevelopment Construct REVENUE Repott Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec°d Prior Year YTD Property Taxes 2,671,000.00 .00 2,671,000.00 27,659.93 .00 2,295,862.29 375,137.71 86 2,406,998.13 Investment Income 1,000.00 .00 1,000.00 36.18 .00 299.49 700.51 30 500.38 Reimbursements .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Revenue .00 .00 .00 .00 .00 .00 .00 ... .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $2,672,000.00 $0.00 $2,672,000.00 $27,696.11 $0.00 $2,296,161.78 $375,838.22 86% $2,407,498.51 Fund 022 -Downtown Redevelopment Construct Totals $2,672,000.00 $0.00 $2,672,000.00 $27,696.11 $0.00 $2,296,161.78 $375,838.22 $2,407,498.51 Ln Budget Account, Repotl Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactlons Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 023 - Street Improvement Construc Fund REVENUE Other Taxes 2,057,000.00 .00 2,057,000.00 173,509.97 .00 1,273,875.95 783,124.05 62 980,264.91 Licenses, Permits & Fees 1,045,000.00 .00 1,045,000.00 11,552.25 .00 1,006,813.77 38,186.23 96 .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 +++ 3,611.52 Fines & Forfeits .00 .00 .00 .00 .00 117,500.00 (117,500.00) +++ .00 Investment Income 100.00 .00 100.00 124.37 .00 4,101.73 (4,001.73) 4102 71.81 Reimbursements .00 .00 .00 .00 .00 .00 .00 ... .00 Other Revenue 6,000.00 .00 6,000.00 744.00 .00 80,071.83 (74,071.83) 1335 11,726.29 Other Financing Sources 6,500,000.00 .00 6,500,000.00 .00 .00 6,540,700.82 (40,700.82) 101 .00 REVENUE TOTALS $9,608,100.00 $0.00 $9,608,100.00 $185,930.59 $0.00 $9,023,064.10 $585,035.90 94% $995,674.53 Fund 023 - Street Improvement Construc Fund Totals $9,608,100.00 $0.00 $9,608,100.00 $185,930.59 $0.00 $9,023,064.10 $585,035.90 $995,674.53 y •s - • ' • • Adopted Budget Amended Current Month YTD Account Classification Budget Amendments Budget Transactions Encumbrances Fund 024 - Flood Control Construction Fund REVENUE Repoit Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Other Taxes 289,468,00 .00 289,468.00 25,505.75 .00 161,739.43 127,728.57 56 332,858.74 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 ... .00 Charges For Services .00 .00 .00 .00 .00 .00 .00 +++ .00 Investment income 500,00 .00 500.00 962.11 .00 10,578.11 (10,078.11) 2116 4,426.54 Reimbursements .00 .00 .00 .00 .00 .00 .00 +++ 135,093.35 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ 9,741,700.46 REVENUE TOTALS $289,968.00 $0.00 $289,968.00 $26,467.86 $0.00 $172,317.54 $117,650.46 59% $10,214,079.09 Fund 024 - Flood Control Construction Fund Totals $289,968.00 $0.00 $289,968.00 $26,467.86 $0.00 $172,317.54 $117,650.46 $10,214,079.09 J IR Repocoiiaj Through 10/31/11 Prior Fiscal Year Activity Included Summary Listing Account Classification Adopted Budget Budget Amendments Amended Budget Current Month Transactions YTD Encumbrances YTD Transactions Budget YTD Transactions % used/ Rec'u Prior Year YTD Fund 040 - Refuse Disposal fund nsysmus Property Taxes 342,000.00 .00 u+z,000uo (2,941.63) .00 335,380.32 6,619.68 yx 1,833,814.83 Charges For Services 2,900,000.00 .00 2,900,000u0 199,*59.79 .00 2,379,845.99 520,15*.01 xz 1,756,089.32 Fines &Forfeits 25,000.00 .00 25,000u0 3,249.37 .00 23,374.5* 1,625.46 os 16,117.e4 Investment Income 500.00 .00 500.00 39.36 .00 529.23 (29.23) 106 345.70 Reimbursements .00 .00 .00 xo*.yo oo 737.40 (737.*0) +++ 722.95 Other Revenue 359,000.00 .00 ssy'000.uo 39,528.39 uo 304,927.73 54,072.27 85 304,237y6 REVENUE TOTALS $3,626,500.00 $0.00 $3,626,500.00 $239,630.2* $ouo $3'0*4,795.21 $581'70*.79 84% $3,911'328a0 Fund u40 -Refuse Disposal Fund Totals $»,ozo,soo.00 $ouo $a,»zo,soo.00 $239'630.2+ $0.00 $3'0+4,795.21 $581'704.79 $3,911,328.60 %D Repott Through /31/14 Prior Fiscal Year Activity Included Summary istin 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 041 -(Motor Fuel Tax Fund REVENUE Intergovernmental Revenue 1,290,000.00 .00 1,290,000.00 109,108.95 .00 1,457,686.89 (167,686.89) 113 969,383.27 Investment Income 100.00 .00 100.00 8.00 .00 35.38 64.62 35 102.15 Reimbursements 6,000.00 .00 6,000.00 1,245.72 .00 12,949.76 (6,949.76) 216 8,360.38 REVENUE TOTALS $1,296,100.00 $0.00 $1,296,100.00 $110,362.67 $0.00 $1,470,672.03 ($174,572.03) 113% $977,845.80 Fund 041- Motor Fuel Tax Fund Totals $1,296,100.00 $0.00 $1,296,100.00 $110,362.67 $0.00 $1,470,672.03 ($174,572.03) $977,845.80 %D L!�V-1T17M![47;1U[;rsM- =,-,[�f;jq5jjj Repo Through 10/31/1 f Prior Fiscal Year Activity Includ Summary Listi 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 042 - Cmmty Development Block Grant REVENUE Intergovernmental Revenue 293,202.00 97,171.00 390,373.00 .00 .00 52,998.37 337,374.63 14 114,623.08 Investment Income .00 .00 .00 .00 .00 .00 .00 ... .00 Other Revenue 60,000.00 .00 60,000.00 20,231.50 .00 173,048.62 (113,048.62) 288 108,656.18 REVENUE TOTALS $353,202.00 $97,171.00 $450,373.00 $20,231.50 $0.00 $226,046.99 $224,326.01 50% $223,279.26 Fund 042 - Cmmty Development Block Grant Totals $353,202.00 $97,171.00 $450,373.00 $20,231.50 $0.00 $226,046.99 $224,326.01 $223,279.26 Account Classification Fund 043 -Asset Seizure Fund REVENUE Revenue Budget by Account Classification Report Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fines & ForFeits 2,000.00 .00 2,000.00 .00 .00 43,321.06 (41,321.06) 2166 15,525.52 Investment Income 100.00 .00 100.00 1.22 .00 12.39 87.61 12 7.53 REVENUE TOTALS $2,100.00 $0.00 $2,100.00 $1.22 $0.00 $43,333.45 ($41,233.45) 2063% $15,533.05 Fund 043 - Asset Seizure Fund Totals $2,100.00 $0.00 $2,100.00 $1.22 -$MO $43,333.45 ($41,233.45) $15,533.05 r r Account Classification Fund 044 - DEA Shared Funds Funf REVENUE Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances ■ itq 914191 Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fines & Forfeits 100.00 .00 100.00 .00 .00 24,637.80 (24,537.80) 24638 .00 Investment Income 100.00 .00 100.00 1.52 .00 16.72 83.28 17 8.33 REVENUE TOTALS $200.00 $0.00 $200.00 $1.52 $0.00 $24,654.52 ($24,454.52) 12327% $8.33 Fund 044 - DEA Shared Funds Fund Totals $200.00 $0.00 $200.00 $1.52 $0.00 $24,654.52 ($24,454.52) $8.33 Account Classification Fund 045 - DUI Fine Fund REVENUE Fines & Forfeits Investment Income Revenue Budget by Account Classification Report Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 20,000.00 ,00 20,000.00 8,589.21 .00 30,813.43 (10,813.43) 154 25,873.82 100.00 .00 100.00 2.17 .00 31.96 68.04 32 .00 REVENUE TOTALS $20,100.00 $0.00 $20,100.00 $8,591.38 $0.00 $30,845.39 ($10,745.39) 153% $25,873.82 Fund 045 - 131.111 Fine Fund Totals $20,100.00 $0.00 $20,100.00 $8,591.38 $0.00 $30,845.39 ($10,745.39) $25,873.82 Account Classification Fund 046 - Foreign Fire Tax Board Fund REVENUE Other Taxes Investment Income Other Revenue Other Financing Sources REVENUE TOTALS Fund 046 - Foreign Fire Tax Board Fund Totals Revenue Budget by Account Classification Repoit Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 70,000.00 .00 70,000.00 4,311.86 .00 67,576.50 2,423.50 97 63,321.98 1,000m .00 1,000.00 6.78 .00 90.14 909.86 9 .98 00 .00 .00 .00 .00 .00 .00 ... 45.00 .00 .00 .00 .00 .00 .00 .00 ... .00 $71,000.00 $0.00 $71,000.00 $4,318.64 $0.00 $67,666.64 $3,333.36 95% $63,367.96 $71,000.00 $0.00 $71,000.00 $4,318.64 $0.00 $67,666.64 $3,333.36 $63,367.96 Adopted Budget Amended Current Month YTD Account Classification Budget Amendments Budget Transactions Encumbrances Fund 047 - Justice Assistance Grant Fund REVENUE gel F= i fmr; I m I # I i Report Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year 11-1: Intergovernmental Revenue .00 X0 .00 .00 ,00 .00 .00 +++ .00 Investment Income .00 .00 .00 .00 .00 _00 .00 +++ ,00 REVENUE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++ $0.00 Fund 047 - Justice Assistance Grant Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 r U11 Fund 048 - Business District Fund REVENUE 4 #37.,TKK#ll rillel F.771i -1411111 Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances �:f-q ell] - Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Other Taxes 943,000.00 .00 943,000.00 78,953.55 .00 680,949.33 262,050.67 72 655,264.27 Investment Income 100.00 .00 100.00 3.49 .00 27.25 72.75 27 67.18 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $943,100.00 $0.00 $943,100.00 $78,957.04 $0.00 $680,976.58 $262,123.42 72% $655,331.45 Fund 048 - Business District Fund Totals $943,100.00 $uo $943,100.00 $78,957.04 $0.00 $680,976.58 $262,123.42 $655,331.45 Account Classification Fund 050 - Water and Sewer Fund REVENUE Revenue Budget by Account Classification Repoit Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Property Taxes 1,530,000.00 .00 1,530,000.00 3,780.28 .00 1,497,666.32 32,333.68 98 1,498,203.23 Licenses, Permits & Fees 17,000.00 .00 17,000.00 1,740.00 .00 15,430.00 1,570.00 91 16,200.00 Charges For Services 12,711,000.00 .00 12,711,000.00 1,027,112.56 .00 9,869,295.63 2,841,704.37 78 9,558,102.50 Fines & Forfeits 100,000.00 .00 100,000.00 8,888.88 .00 91,885.29 8;114.71 92 97,840.55 Investment Income 1,100.00 .00 1,100.00 1,850.83 .00 3,115.58 (2,015.58) 283 694.88 Reimbursements 1,000.00 .00 1,000.00 .00 .00 (131.00) 1,131.00 -13 9,572.52 Other Revenue 25,000.00 .00 25,000.00 5,060.00 .00 53,863.80 (28,863.80) 215 41,572.97 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $14,385,100.00 $0.00 $14,385,100.00 $1,048,432.55 $0.00 $11,531,125.62 $2,853,974.38 80% $11,222,186.65 Fund 050 - Water and Sewer Fund Totals $14,385,100.00 $0.00 $14,385,100.00 $1,048,432.55 $0.00 $11,531,125.62 $2,853,974.38 $11,222,186.65 r 00 Account Classification Fund 051 - Village Parking System Fund REVENUE Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Other Taxes 10,000.00 .00 10,000.00 881.13 .00 5,587.48 4,412.52 56 5,780.87 Charges For Services 115,000.00 .00 115,000.00 11,809.85 .00 108,880.72 6,119.28 95 101,569.15 Investment Income 100.00 .00 100.00 6.39 .00 77.42 22.58 77 19.65 Other Revenue 6,600.00 .00 6,600.00 550.00 .00 5,500.00 1,100.00 83 5,500.00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $131,700.00 $0.00 $131,700.00 $13,247.37 $0.00 $120,045.62 $11,654.38 91% $112,869.67 Fund 051 - Village Parking System Fund Totals $131,700.00 $0.00 $131,700.00 $13,247.37 $0.00 $120,045.62 $11,654.38 $112,869.67 Account Classification Fund 052 -Parking System Revenue Fund REVENUE Revenue Budget by Account Classification Report Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Taxes 90,000.00 .00 90,000.00 7,930.13 .00 50,287.26 39,712.74 56 52,027.74 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Charges For Services 112,000.00 .00 112,000.00 11,599.05 .00 99,775.32 12,224.68 89 92,900.61 Investment Income 100.00 .00 100.00 .00 .00 .00 100.00 0 1.62 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $202,100.00 $0.00 $202,100.00 $19,529.18 $0.00 $150,062.58 $52,037.42 74% $144,929.97 Fund 052 - Parking System Revenue Fund Totals $202,100.00 $0.00 $202,100.00 $19,529.18 $0.00 $150,062.58 $52,037.42 $144,929.97 Account Classification at4w-171 14:111;Me- 4 1 Jr., 7,61KIT I 1 0 111 11111t; Adopted Budget Amended Current Month YTI Budget Amendments Budget Transactions Encumbrance-- --- -- ------- - Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Redd Prior Year YTD Fund 060 - Vehicle Maintenance Fund REVENUE Charges For Services 2,138,317.00 .00 2,138,317.00 178,193.07 .00 1,781,930.70 356,386.30 83 1,827,761.00 Investment Income .00 .00 .00 52.04 .00 472.37 (472.37) +++ 399.51 Other Revenue .00 .00 .00 .00 .00 525.88 (525.88) ... 138.40 REVENUE TOTALS $2,138,317.00 $0.00 $2,138,317.00 $178,245.11 $0.00 $1,782,928.95 $355,388.05 83% $1,828,298.91 Fund 060 - Vehicle Maintenance Fund Totals $2,138,317.00 $0.00 $2,138,317.00 $178,245.11 $0.00 $1,782,928.95 $355,388.05 $1,828,298.91 Account Classification Fund 061 - Vehicle Replacement Fund REVENUE Revenue Budget by Account Classification Repoit Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD Charges For Services 1,346,300.00 .00 1,346,300.00 112,191.68 .00 1,121,916.80 224,383.20 83 1,163,833.40 Fines & Forfeits 10,000.00 .00 10,000.00 2,580.00 .00 11,577.72 (1,577.72) 116 11,763.44 Investment Income 5,000.00 .00 5,000.00 595.10 .00 5,834.13 (834.13) 117 4,356.37 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Financing Sources 60,000.00 .00 60,000.00 21,231.25 .00 75,485.00 (15,485.00) 126 98,584.12 REVENUE TOTALS $1,421,300.00 $0.00 $1,421,300.00 $136,598.03 $0.00 $1,214,813.65 $206,486.35 85% $1,278,537.33 Fund 061- Vehicle Replacement Fund Totals $1,421,300.00 $0.00 $1,421,300.00 $136,598.03 $0.00 $1,214,813.65 $206,486.35 $1,278,537.33 N r REVENUE TATMIPTIRMme , —."tefelei'Maell Adopted Budget Amended Current Month Budget Amendments Budget Transactions Encumbran] I Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - Y -FD % used/ Transactions Transactions Rec'd Prior Year YTD Charges For Services 23,088.00 .00 23,088.00 1,924.00 .00 19,240.00 3,848.00 83 .00 Investment Income 1,000.00 .00 1,000.00 71.49 .00 633.72 366.28 63 570.99 Other Financing Sources .00 .00 .00 .00 .00 .00 100 ... .00 REVENUE TOTALS $24,088.00 $0.00 $24,088.00 $1,995.49 $0.00 $19,873.72 $4,214.28 83% $570.99 Fund 062 - Computer Replacement Fund Totals $24,088.00 $0.00 $24,088.00 $1,995.49 $0.00 $19,873.72 $4,214.28 $570.99 Account Classification Fund 063 - Risk Management Fund REVENUE Revenue Budget by Account Classification Reporit Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Charges For Services 6,456,273.00 .00 6,456,273.00 534,777.62 .00 5,393,879.73 1,062,393.27 84 5,069,937.84 Investment Income 2,000.00 .00 2,000.00 206.89 .00 1,916.62 83.38 96 1,396.62 Reimbursements 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Other Revenue 1,357,600.00 .00 1,357,600.00 122,115.27 .00 1,105,450.89 252,149.11 81 1,068,593.65 REVENUE TOTALS $7,816,873.00 $0.00 $7,816,873.00 $657,099.78 $0.00 $6,501,247.24 $1,315,625.76 83% $6,139,928.11 Fund 063 - Risk Management Fund Totals $7,816,873.00 $0.00 $7,816,873.00 $657,099.78 $0.00 $6,501,247.24 $1,315,625.76 $6,139,928.11 N W N Ob Account Account Classification Fund 070 - Police Pension Fund REVENUE :MV7111 I rza ; I fro' SIKIIM11;941 =,M1419111 Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Redd Prior Year YTD Charges For Services .00 .00 .00 .00 .00 .00 .00 ... .00 Investment Income 3,415,900.00 <00 3,415,900.00 1,115,334.60 .00 3,198,699.48 217,200.52 94 5,679,932.58 Other Revenue 3,742,224.00 .00 3,742,224.00 91,522.42 .00 3,543,518.89 198,705.11 95 3,241,677.53 REVENUE TOTALS $7,158,124.00 $0.00 $7,158,124.00 $1,206,857.02 $0.00 $6,742,218.37 $415,905.63 94% $8,921,610.11 Fund 070 - Police Pension Fund Totals $7,158,124.00 $0.00 $7,158,124.00 $1,206,857.02 $0.00 $6,742,218.37 $415,905.63 $8,921,610.11 Account Classification Fund 071- Fire Pension Fund REVENUE M Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances -A' 4 9,141 it I Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTJ Investment Income 3,165,200.00 .00 3,165,200.00 163,189.55 .00 2,509,317.25 655,882.75 79 5,007,907.89 Other Revenue 3,079,042.00 .00 3,079,042.00 52,558.26 .00 2,920,751.44 158,290.56 95 2,815,141.68 REVENUE TOTALS $6,244,242.00 $0.00 $6,244,242.00 $215,747.81 $0.00 $5,430,068.69 $814,173.31 87% $7,823,049.57 Fund 071 - Fire Pension Fund Totals $6,244,242.00 $0.00 $6,244,242.00 $215,747.81 $0.00 $5,430,068.69 $814,173.31 $7,823,049.57 Grand Totals $108,812,217.00 $97,171-00 $108,909,388.00 $7,204,463.88 $0.00 $90,517,552.29 $18,391,835.71 $93,445,334.84 K) Ul Adopted Budget Account Classification Budget Amendments Fund 001 - General Fund EXPENSE Repoit Through 1/31/1 Prior Fiscal Year Activity Included Summary Listing Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 23,919,744.00 .00 23,919,744.00 1,790,782.58 .00 19,180,814.51 4,738,929.49 80 18,559,092.13 Employee Benefits 12,344,314.00 .00 12,344,314.00 524,769.47 .00 11,221,797.53 1,122,516.47 91 10,447,331.34 Other Employee Costs 415,005.00 (5,675,00) 409,330.00 22,757.48 10,660.00 257,156.25 141,513.75 65 221,585.32 Pension Benefits 46,301.00 .00 46,301.00 3,858.36 .00 38,583.60 7,717.40 83 38,458.10 Contractual Services 7,001,321.00 143,785.68 7,145,106.68 489,693.04 318,966.92 5,890,540.35 935,599.41 87 5,891,717.85 Utilities 262,282.00 .00 262,282.00 11,420.89 .00 139,759.55 122,522.45 53 120,334.15 Insurance 350,519.00 .00 350,519.00 29,206.13 .00 292,107.89 58,411.11 83 287,621.96 Commodities & Supplies 627,855.00 61,600.00 689,455.00 68,013.51 39,377.58 458,243.49 191,833.93 72 403,388.34 Other Expenditures 11,080.00 .00 11,080.00 26,848.24 .00 80,544.72 (69,464.72) 727 .00 Building Improvements 10,000.00 .00 10,000.00 497.83 4,665.20 3,007.68 2,327.12 77 9,761.57 Office Equipment 49,730.00 .00 49,730.00 11,470.07 1,804.32 19,076.43 28,849.25 42 11,576.84 Other Equipment 165,123.00 8,637.32 173,760.32 6,031.20 35,168.95 109,749.86 28,841.51 83 55,105.95 Distribution Systems 100,000.00 .00 100,000.00 49,227.30 22,221.22 49,227.30 28,551.48 71 .00 Infrastructure 510,792.00 (6,700.00) 504,092.00 65,485.89 131,884.35 323,920.53 48,287.12 90 374,466.20 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $45,814,066.00 $201,648.00 $46,015,714.00 $3,100,061.99 $564,748.54 $38,064,529.69 $7,386,435.77 84% $36,420,439.75 Fund 001- General Fund Totals $45,814,066.00 $201,648.00 $46,015,714.00 $3,100,061.99 $564,748.54 $38,064,529.69 $7,386,435.77 $36,420,439.75 H NJ Fund 002 - Debt Service Fund EXPENSE !-xpense Budget by Account Classification Repor-1 Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget -YTD %used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTC Contractual Services .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Bond Principal 1,532,587.00 .00 1,532,587.00 .00 .00 270,780.49 1,261,806.51 18 460,278.45 Interest Expense 1,793,429.00 .00 1,793,429.00 .00 .00 766,300.74 1,027,128.26 43 467,764.58 Bank & Fiscal Fees 2,484.00 .00 2,484.00 .00 .00 1,686.20 797.80 68 428.00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 Other Financing Uses .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $3,328,500.00 $0.00 $3,328,500.00 $0.00 $0.00 $1,038,767.43 $2,289,732,57 31% $928,471.03 Fund 002 - Debt Service Fund Totals $3,328,500.00 $0.00 $3,328,500.00$0.00 $0.00 $1,038,767.43 $2,289,732.57 $928,471.03 Account Classification Fund 020 - Capital Improvement Fund EXPENSE Expense Budget by Account Classification Repoit Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget -YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services .00 .00 .00 .00 .00 .00 .00 +++ 22,132.60 Other Expenditures .AO .00 .00 00 .00 .00 .00 ... .00 Land Improvements 240,000,00 .00 240,000.00 .00 .00 .00 240,000.00 0 .00 Building Improvements 637,000.00 73,600,00 710,600.00 73,556.16 17,168.42 340,432.70 352,998.88 50 724,430.43 Office Equipment 00 .00 .00 .00 .00 .00 .00 +++ .00 Motor Equipment .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Equipment 304,247,00 16,600.00 320,847.00 11,224.60 36,477.88 193,628.75 90,740.37 72 287,396.80 Infrastructure 515,000.00 104,400.00 619,400.00 .00 14,333.76 28,696.23 576,370.01 7 260,552.80 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $1,696,247.00 $194,600.00 $1,890,847.00 $84,780.76 $67,980.06 $562,757.68 $1,260,109.26 33% $1,294,512.63 Fund 020 - Capital Improvement Fund Totals $1,696,247.00 $194,600.00 $1,890,847.00 $84,780.76 $67,980.06 $562,757.68 $1,260,109.26 $1,294,512.63 w A. Adopted Budget Account Classification Budget Amendments Fund 021 - Series 2009 Construction Fund EXPENSE ma- a 1816141MMUSI Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTD Contractual Services '00 .00 .00 .00 .00 .00 .00 ... .00 Building Improvements 00 .00 .00 .00 .00 .00 .00 ... .00 Office Equipment .00 .00 .00 .00 .00 .00 .00 ... .00 Other Equipment .00 .00 .00 .00 .00 .00 .00 ... .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ 36,865.05 EXPENSE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ... $36,865.05 Fund 021 - Series 2009 Construction Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $36,865.05 Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 022 - Downtown Redevelopment Construct EXPENSE Contractual Services 203,040.00 .00 203,040.00 41,801.46 31,796.27 174,003.36 (2,759.63) 101 158,827.56 Utilities 00 .00 .00 .00 .00 .00 .00 +++ .00 Other Expenditures 2,803,922.00 60,000.00 2,863,922.00 26,018.63 .00 109,241.63 2,754,680.37 4 77,138.41 Infrastructure 115,000.00 240,000.00 355,000.00 .00 3,804.00 16,775.75 334,420.25 6 21,670.31 Bond Principal .00 .00 .00 .00 .00 .00 .00 +++ .00 Interest Expense .00 .00 .00 .00 .00 .00 .00 +++ .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $3,121,962.00 $300,000,00 $3,421,962.00 $67,820.09 $35,600.27 $300,020.74 $3,086,340.99 10% $257,636.28 Fund 022 -Downtown Redevelopment Construct Totals $3,121,962.00 $300,000.00 $3,421,962.00 $67,820.09 $35,600.27 $300,020.74 $3,086,340.99 $257,636.28 Ln Ch MEMNON= [ M Wxpense Budget by Account Classification Reporli, Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 023 - Street Improvement Construc Fund EXPENSE Contractual Services 30,600.00 41,000.00 71,600.00 2,366.39 24,006.27 47,291.55 302.18 100 24,882.78 Infrastructure 9,943,280.00 .00 9,943,280.00 566,823.06 1,882,686.77 7,334,920.12 725,673.11 93 614,360.06 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $9,973,880.00 $41,000.00 $10,014,880.00 $569,189.45 $1,906,693.04 $7,382,211.67 $725,975.29 93% $639,242.84 Fund 023 - Street Improvement Construc Fund Totals $9,973,880.00 $41,000.00 $10,014,880.00 $569,189.45 $1,906,693.04 $7,382,211.67 $725,975.29 $639,242.84 if A 91:4 1 �*4 -71FT-9 'Me �, � , • * •.: Adopted Budget Account Classification Budget Amendments Fund 024 - Flood Control Construction Fund EXPENSE Repoit Tru 1/31/14 Prior Fiscal Year Activity Included Summary isi Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Contractual Services .00 .00 .00 .00 .00 .00 .00 +++ .00 Utilities 1,000.00 .00 1,000.00 .00 .00 915.87 84.13 92 .00 Commodities & Supplies .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Expenditures 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 2,000.00 Other Equipment .00 .00 .00 .00 .00 .00 .00 +++ .00 Infrastructure 10,805,000.00 83,800.00 10,888,800.00 119,449.36 23,505.64 496,768.37 10,368,525.99 5 1,557,252.77 EXPENSE TOTALS $10,811,000.00 $83,800.00 $10,894,800.00 $119,449.36 $23,505.64 $497,684.24 $10,373,610.12 5% $1,559,252.77 Fund 024 - Flood Control Construction Fund Totals $10,811,000.00 $83,800.00 $10,894,800.00 $119,449.36 $23,505.64 $497,684.24 $10,373,610.12 $1,559,252.77 v 14A 9 1 Z4 1 L�A :115 M 4 JK4101MILS] Adopted Budget Account Classification Budget Amendments Fund 040 - Refuse Disposal Fund EXPENSE iV4 fill ILI Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Amended Current Month Y -Fl) YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 231,735.00 .00 231,735.00 17,655.47 .00 199,545.72 32,189.28 86 148,966.00 Employee Benefits 75,057.00 .00 75,057.00 8,427.33 .00 89,200.44 (14,143.44) 119 78,745.66 Other Employee Costs 1,224.00 .00 1,224.00 .00 .00 1,224.00 .00 100 1,200.00 Contractual Services 4,157,884.00 (5,600.00) 4,152,284.00 344,934.71 12,412.15 3,261,619.32 878,252.53 79 3,199,723.47 Utilities 438.00 .00 438.00 14.19 .00 226.98 211.02 52 231.79 Insurance 28,640.00 .00 28,640.00 2,386.67 .00 23,866.70 4,773.30 83 23,532.50 Commodities & Supplies 31,295.00 5,600,00 36,895.00 2,686.76 7,427.00 28,565.68 902.32 98 23,447.77 EXPENSE TOTALS $4,526,273.00 $0.00 $4,526,273.00 $376,105.13 $19,839.15 $3,604,248.84 $902,185.01 80% $3,475,847.19 Fund 040 - Refuse Disposal Fund Totals $4,526,273.00 $0.00 $4,526,273.00 $376,105.13 $19,839.15 $3,604,248.84 $902,185.01 $3,475,847.19 Account Classification Fund 041- Motor Fuel Tax Fund EXPENSE mxpenseBudgetAccount i "` i i 1 Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Contractual Services 204,104.00 75,000.00 279,104.00 8,144.63 12,337.45 202,577.05 64,189.50 77 158,616.52 Utilities 153,000.00 .00 153,000.00 15,501.06 .00 150,421.82 2,578.18 98 137,714.63 Commodities & Supplies 284,796.00 .00 284,796.00 26,450.85 26,506.63 257,910.60 378.77 100 147,195.10 Building Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 Infrastructure 910,000.00 5,000.00 915,000.00 .00 .00 10,056.62 904,943.38 1 1,115,000.00 EXPENSE TOTALS $1,551,900.00 $80,000.00 $1,631,900.00 $50,096.54 $38,844.08 $620,966.09 $972,089.83 40% $1,558,526.25 Fund 041 - Motor Fuel Tax Fund Totals $1,551,900.00 $80,000.00 $1,631,900.00 $50,096.54 $38,844.08 $620,966.09 $972,089.83 $1,558,526.25 u 0 Account Classification Fund 042 - Cmmty Development Block Grant EXPENSE Personal Services, Scheduled Salaries & Wages Employee Benefits Other Employee Costs Contractual Services Commodities & Supplies Other Expenditures Land Improvements Building Improvements Infrastructure EXPENSE TOTALS Fund 042 - Cmty Development Block Grant Totals Expense Budget by Account Classification Repoit Through /31/14 Prior Fiscal Year Activity Included Summary isin Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 47,930.00 .00 47,930.00 3,279.14 .00 38,341.67 9,588.33 80 37,140.42 26,222.00 .00 26,222.00 2,073.39 .00 21,312.48 4,909.52 81 20,429.90 1,020.00 >00 1,020.00 .00 .00 178.32 841.68 17 745.50 97,520.00 23,250,00 120,770.00 25,858.46 .00 96,131.41 24,638.59 80 40,332.67 510.00 <00 510.00 .00 .00 .00 510.00 0 111.37 160,000.00 73,921.00 233,921.00 30,220.00 .00 43,064.00 190,857.00 18 136,517.56 .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 20,000.00 .00 20,000.00 .00 70,000.00 .00 (50,000.00) 350 37,500.00 $353,202.00 $97,171.00 $450,373.00 $61,430.99 $70,000.00 $199,027.88 $181,345.12 60% $272,777.42 $353,202.00 $97,171.00 $450,373.00 $61,430.99 $70,000.00 $199,027.88 $181,345.12 $272,777.42 Account Classification Fund 043 - Asset Seizure Fund EXPENSE -7wxpense Budget by Account Classification R er-,po 2 1 Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD D/b used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTC Other Employee Costs 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Contractual Services 3,000.00 .00 3,000.00 .00 .00 4,000.00 (1,000.00) 133 4,000.00 Other Equipment 15,000.00 .00 15,000.00 217.28 .00 1,859.57 13,140.43 12 8,132.49 EXPENSE TOTALS $19,000.00 $0.00 $19,000.00 $217.28 $0.00 $5,859.57 $13,140.43 31% $12,132.49 Fund 043 -Asset Seizure Fund Totals $19,000.00 $0.00 $19,000.00 $217.28 $0.00 $5,859.57 $13,140.43 $12,132.49 Fund 044-- DEAi r Shared Fun s EXPENSE R!= -xpense Budget by Account Classification Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTD Contractual Services 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 493,87 Building Improvements .00 .00 .00 .00 .00 .00 .00 ... .00 Other Equipment 1,000.00 .00 1,000.00 .00 ,00 .00 1,000.00 0 .00 EXPENSE TOTALS $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $493.87 Fund 044 - DEA Shared Funds Fund Totals $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 $493.87 Account Classification Fund 045 - DUI Fine Fund EXPENSE Other Employee Costs Contractual Services Other Equipment Interfund Transfers Expense Budget by Account Classcation Repor-12- Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTC 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 .00 .00 ,00 .00 .00 .00 .00 ... 7,187.50 10,000.00 .00 10,000.00 .00 .00 2,767.30 7,232.70 28 17,068.17 X0 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $11,000.00 $0.00 $11,000.00 $0.00 $0.00 $2,767.30 $8,232.70 25% $24,255.67 Fund 045 - DUI Fine Fund Totals $11,000.00 $0.00 $11,000.00 $0.00 $0.00 $2,767.30 $8,232.70 $24,255.67 oil -xpense Budget by Account Classification R e p o rrtt Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 046 - Foreign Fire Tax Board Fund EXPENSE Contractual Services 10,000.00 .00 10,000.00 .00 2,685.00 3,967.27 3,347.73 67 3,030.47 Insurance 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Commodities & Supplies 5,000.00 .00 5,000.00 .00 .00 211.65 4,788.35 4 3,032.98 Other Equipment 15,000.00 .00 15,000.00 4,260.60 17,565.00 15,948.60 (18,513.60) 223 11,327.00 EXPENSE TOTALS $30,500.00 $0.00 $30,500.00 $4,260.60 $20,250.00 $20,127.52 ($9,877.52) 132% $17,390.45 Fund 046 - Foreign Fire Tax Board Fund Totals $0.00 $30,500.00 $4,260.60 $20,250.00 $20,127.52 ($9,877.52) $17,390.45 Adopted Budget Account Classification Budget Amendments Fund 047 - Justice Assistance Grant Fund EXPENSE Its a I ikel I I 1 11111 DST! 14 [$111' Repoit Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Amended Current Month YTD YTD Budget -YTD %used/ Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Commodities & Supplies .00 .00 .00 .00 .00 .00 .00 ... .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 ... .00 Office Equipment .00 .00 .00 .00 .00 .00 .00 ... 768.79 Other Equipment .00 .00 .00 .00 .00 .00 .00 ... 66.66 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $0,00 $uo $0.00 $0.00 $0.00 -$0.00 $0.00 ... $835.45 Fund 047 - Justice Assistance Grant Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $835.45 r 0% Account Classification Fund 048 - Business District Fund EXPENSE Expense Budget by Account Classification RepoijL Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Bond Principal .00 .00 .00 .00 .00 .00 .00 +++ .00 Interest Expense 923,100.00 .00 923,100.00 .00 .00 .00 923,100.00 0 637,231.78 EXPENSE TOTALS $923,100.00 $0.00 $923,100.00 $0.00 $0.00 $0.00 $923,100.00 0% $637,231.78 Fund 048 - Business District Fund Totals $923f100.00 $0.00 $923,100.00 $0.00 $0.00 $0.00 $923,100.00 $637,231.78 Adopted Budget Account Classification Budget Amendments Fund 050 - Water and Sewer Fund EXPENSE Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTC Personal Services, Scheduled Salaries & Wages 1,952,664.00 .00 1,952,664.00 132,174.71 .00 1,622,348.74 330,315.26 83 1,534,603.28 Employee Benefits 787,893.00 .00 787,893.00 55,191.83 .00 630,747.41 157,145.59 80 633,273.66 Other Employee Costs 36,660.00 .00 36,660.00 3,717.73 172.50 28,821.74 7,665.76 79 19,191.92 Contractual Services 7,457,412.00 32,500.00 7,489,912.00 659,280.60 217,759.56 6,126,940.24 1,145,212.20 85 5,557,530.03 Utilities 157,758.00 .00 157,758.00 7,835.07 .00 97,372.86 60,385.14 62 88,208.16 Insurance 80,474.00 .00 80,474.00 6,706.16 .00 67,061.60 13,412.40 83 66,152.50 Commodities & Supplies 295,722.00 .00 295,722.00 14,071.14 28,156.51 139,795.81 127,769.68 57 156,594.05 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Building Improvements 42,500.00 .00 42,500.00 .00 3,925.00 1,350.00 37,225.00 12 .00 Office Equipment 1,370.00 .00 1,370.00 .00 .00 .00 1,370.00 0 .00 Other Equipment 1,244,200.00 1,563,500.00 2,807,700.00 39,816.74 1,445,476.64 1,091,071.76 271,151.60 90 116,389.71 Distribution Systems 2,075,000.00 581,500.00 2,656,500.00 27,106.31 1,806,769.51 317,746.56 531,983.93 80 915,193.49 Infrastructure .00 .00 .00 .00 .00 .00 .00 +++ .00 Bond Principal .00 .00 .00 .00 .00 .00 .00 +++ .00 Interest Expense .00 .00 .00 .00 .00 .00 .00 ... .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $14,131,653.00 $2,177,500.00 $16,309,153.00 $945,900.29 $3,502,259.72 $10,123,256.72 $2,683,636.56 84% $9,087,136.80 Fund 050 - Water and Sewer Fund Totals $14,131,653.00 $2,177,500.00 $16,309,153.00 $945,900.29 $3,502,259.72 $10,123,256.72 $2,683,636.56 $9,087,136.80 F� 00 -#A$1-41 1-14;Pr; MM 4MUCK41411r,1161 Adopted Budget Account Classification Budget Amendments Fund 051- Village Parking System Fund EXPENSE UL+.1 Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 35,788.00 .00 35,788.00 2,457.39 .00 29,660.52 6,127.48 83 20,698.21 Employee Benefits 17,796.00 .00 17,796.00 1,281.68 .00 13,374.74 4,421.26 75 8,803.75 Contractual Services 91,055.00 .00 91,055.00 15,264.12 677.58 62,370.90 28,006.52 69 69,354.75 Insurance 1,175.00 .00 1,175.00 97.92 .00 979.20 195.80 83 965.00 Commodities & Supplies 510.00 .00 510.00 329.35 .00 499.35 10.65 98 .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 ... .00 Building Improvements 6,936.00 .00 6,936.00 .00 647.33 2,103.47 4,185.20 40 2,750.80 Infrastructure 153,500.00 .00 153,500.00 10,627.67 36,121.53 106,750.80 30 49,124.20 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $306,760.00 $0.00 $306,760.00 $19,430.46 $11,952.58 $145,109.71 $149,697.71 51% $151,696.71 Fund 051 - Village Parking System Fund Totals $306,760.00 $0.00 $306,760.00 $19,430.46 $11,952.58 $145,109.71 $149,697.71 $151,696.71 11741 F.= 14AA 91:4 1 w I LISA - 1011-1 Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 052 - Pa ng System Revenue Fund EXPENSE Personal Services, Scheduled Salaries & Wages 28,598.00 .00 28,598.00 1,818.50 .00 21,616.45 6,981.55 76 30,640.88 Employee Benefits 13,772.00 .00 13,772.00 952.54 .00 9,913.40 3,858.60 72 15,019.80 Contractual Services 110,954.00 .00 110,954.00 12,314.73 3,854.37 75,520.55 31,579.08 72 90,069.80 Utilities 10,523.00 .00 10,523.00 322.39 .00 5,416.78 5,106.22 51 5,589.30 Insurance 1,406.00 .00 1,406.00 117.17 .00 1,171.70 234.30 83 1,155.80 Commodities & Supplies 9,779.00 .00 9,779.00 59.20 .00 6,309.76 3,469.24 65 3,308.86 Other Expenditures .00 .00 .00 .00 .00 .00 .00 ... .00 Building Improvements 75,000.00 .00 75,000.00 .00 .00 .00 75,000.00 0 .00 Infrastructure .00 .00 .00 .00 .00 .00 .00 ... .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $250,032.00 $0.00 $250,032.00 $15,584.53 $3,854.37 $119,948.64 $126,228.99 50% $145,784.44 Fund 052 - Parking System Revenue Fund Totals $250,032.00 $0.00 $250,032.00 $15,584.53 $3,854.37 $119,948.64 $126,228.99 $145,784.44 r %D N O Adopted Budget Account Classification Budget Amendments Fund 060 - Vehicle Maintenance Fund EXPENSE ra=AT4141111 I im, 4 Is] I I ,(:4918111 Through /31/14 Prior Fiscal Year Activity Included Summary Listing Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD Personal Services, Scheduled Salaries & Wages 940,529.00 .00 940,529.00 67,114.33 .00 768,259.16 172,269.84 82 727,032.67 Employee Benefits 384,627.00 .00 384,627.00 26,922.88 .00 296,764.56 87,862.44 77 329,372.46 Other Employee Costs 2,361.00 .00 2,361.00 95.00 .00 2,231.28 129.72 95 2,150.59 Contractual Services 100,738.00 .00 100,738.00 5,572.55 11,985.14 60,479.26 28,273.60 72 61,667.41 Utilities 3,070.00 .00 3,070.00 179.65 .00 1,971.98 1,098.02 64 2,484.81 Commodities & Supplies 701,081.00 .00 701,081.00 47,935.51 117,161.39 546,517.72 37,401.89 95 509,214.79 Other Expenditures .00 .00 .00 .00 .00 .00 .00 ... .00 Office Equipment 556.00 .00 556.00 134.81 .00 267.80 288.20 48 .00 Other Equipment 19,770.00 .00 19,770.00 .00 1,244.46 16,359.17 2,166.37 89 16,828.84 EXPENSE TOTALS $2,152,732.00 $0.00 $2,152,732.00 $147,954.73 $130,390.99 $1,692,850.93 $329,490.08 85% $1,648,751.57 Fund 060 - Vehicle Maintenance Fund Totals $2,152,732.00 $0.00 $2,152,732.00 $147,954.73 $130,390.99 $1,692,850.93 $329,490.08 $1,648,751.57 r Repoit up Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 061- Vehicle Replacement Fund EXPENSE Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ 00 Motor Equipment 1,614,000.00 163,700.00 1,777,700.00 170,033.99 127,557.42 978,985.16 671,157.42 62 475,663.61 Interfund Transfers AO M .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $1,614,000.00 $163,700.00 $1,777,700.00 $170,033.99 $127,557.42 $978,985.16 $671,157.42 62% $475,663.61 Fund 061- Vehicle Replacement Fund Totals $1,614,000.00 $163,700.00 $1,777,700:00 $170,033.99 $127,557.42 $978,985.16 $671,157.42 $475,663.61 r K) NJ MIA 9 1 :J Ir Ma aelelol I rills] F=i RIM 5111 Adopted Budget Account Classification Budget Amendments Fund 062 - Computer Replacement Fund EXPENSE Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Expenditures .00 .00 .00 .00 .00 .00 ... .00 Office Equipment 247,480.00 .00 247,480.00 64,736.26 .00 140,812.99 106,667.01 57 197,631.76 EXPENSE TOTALS $247,480.00 $0.00 $247,480.00 $64,736.26 $0.00 $140,812.99 $106,667.01 57% $197,631.76 Fund 062 - Computer Replacement Fund Totals $247,480.00 $0.00 $247,480.00 $64,736.26 $0.00 $140,812.99 $106,667.01 $197,631.76 Account Classification Fund 063 - Risk Management Fund EXPENSE Contractual Services Insurance Other Equipment Infrastructure Interfund Transfers EXPENSE TOTALS Fund 063 - Risk Management Fund Totals NJ LJ Expense Budget by Account Classification Repoit Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget -YTD %used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 27,000.00 .00 27,000.00 00 7,000.00 10,300.00 9,700.00 64 10,950.00 7,812,938.00 .00 7,812,938.00 979,403.42 .00 7,274,212.08 538,725.92 93 6,315,833.94 5,000.00 .00 5,000.00 .00 .00 58.25 4,941.75 1 2,140.90 .00 .00 .00 .00 .00 .00 .00 ... .00 .00 .00 .00 .00 .00 .00 .00 ... .00 $7,844,938.00 $0.00 $7,844,938.00 $979,403.42 $7,000.00 $7,284,570.33 $553,367.67 93% $6,328,924.84 $7,844,938.00 $0.00 $7,844,938.00 $979,403.42 $7f000.00 $7,284,570.33 $553,367.67 $6,328,924.84 Fund 070 - Police Pension Fund EXPENSE 11111W "xpense Budget by Account Classification Reporrmi Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD °/® used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Pension Benefits 3,937,366.00 .00 3,937,366.00 357,104.77 .00 3,397,158.68 540,207.32 86 3,187,759.88 Contractual Services 135,350.00 .00 135,350.00 19,111.10 .00 93,261.98 42,088.02 69 56,306.73 Insurance 15,000.00 .00 15,000.00 .00 11,960.00 3,040.00 80 11,500.00 Commodities & Supplies 100.00 '00 100.00 .00 .00 .00 100.00 0 .00 Other Expenditures 12,000.00 .00 12,000.00 147.84 .00 8,702.84 3,297.16 73 9,633.95 Office Equipment .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $099,816.00 $0.00 $4,099,816.00 $376,363.71 $0.00 $3,511,083.50 $588,732.50 86% $3,265,200.56 Fund 070 - Police Pension Fund Totals $4,099,816.00 $0.00 $4,099,816.00 $376,363.71 $0.00 $3,511,083.50 $588,732.50 $3,265,200.56 Account Classification Fund 071 - Fire Pension Fund EXPENSE f-xpenseBudget i Account i Rep i 1 Through 10/31/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD Pension Benefits 4,021,161.00 .00 4,021,161.00 348,120.05 .00 3,449,788.63 571,372.37 86 3,240,351.68 Contractual Services 124,600.00 .00 124,600.00 16,800.00 .00 87,731.03 36,868.97 70 73,047.95 Insurance 15,000.00 .00 15,000.00 .00 .00 13,100.00 1,900.00 87 12,600.00 Commodities & Supplies 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 32.22 Other Expenditures 12,000.00 .00 12,000.00 .00 .00 8,450.00 3,550.00 70 9,207.93 EXPENSE TOTALS $4,173,761.00 $0.00 $4,173,761.00 $364,920.05 $0.00 $3,559,069.66 $614,691.34 85% $3,335,239.78 Fund 071 - Fire Pension Fund Totals $4,173,761.00 $0.00 $4,173,761.00 $364,920.05 $0.00 $3,559,069.66 $614,691.34 $3,335,239.78 Grand Totals $116,983,802.00 $3,339,419.00 s120,323,221.00 $7,517,739.63 $6,530,475.86 $79,854,656.29 $33,938,088.85 $71,771,940.99 N 'S Page 1 of 10 Amount 894.01 4,782.08 31.69 62.00 315.00 48.00 1,920.00 1,240.00 99.35 99.35 99.35 2,750.00 705.15 341.79 30.00 319.92 689.00 115.00 253.50 194.70 80.00 80.00 1,713.69 1,982.85 2,670.50 117.85 60.65 78.90 61.47 12.30 20.50 10.03 10.48 14.58 25.03 12.30 215.00 367.41 276.37 3,080.00 19,804.18 6,602.10 1,023.00 221.83 7,181.81 150.00 54.00 24.94 328.04 123.30 142.22 11.50 487.50 32.00 77.24 109.82 23,319.39 VILLAGE OF MOUNT PROSPECT List of Bills October 30 - November 12, 2014 Fund Vendor Name Invoice Description 001 General Fund 4imprint, Inc. Crime Prevention supplies ACS State & Local Government Solutions Illinois State Disbursement Unit Addison Building Material Co. Maintenance and repair supplies Amer Reprographics Co Llc Equipment Maintenance American Landscaping Inc. Grass cutting -1768 E. Euclid Anderson Pest Solutions Professional Services Apostrophe Design, Inc. Removal of Forbo vinyl sheet flooring in preparation for replace Equipment Maintenance and Repair Aramark Uniform Services, Inc. Uniform Expense Uniform Expense Uniform cleaning and rental for all public works employees Arthur Weiler, Inc. Tree Replacement AT & T Service 10/16/14 -11/15/14 Service 10/16/14 -11/15/14 Balazs, Judith CDL Reimbursement Bartlett Tree Experts Professional Services Bedco Mechanical Repairs to HVAC at Public Works - exhaust fan Repairs to HVAC at the Community Connections Center BMK Veterinary Associates Strays - September & October, 2014 Buffalo, Phillip 2014 Fire Uniform Allowance Busse's Flowers & Gifts Sympathy Arrangement Sympathy Arrangement Capital One National Association Costco Purchased 9/29/14 -10/22/14 Case Lots, Inc. Custodial supplies to be used in all buildings Custodial Supplies CDW Government, Inc. 15' patch cables 5' Patch cables HDMI cables Equipment maintenance supplies Century Cleaners Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Chem -wise Ecological Pest Mgmt Inc Maintenance and repair supplies Chief Supply Corp. Traffic safety vests Lock out tools Community College District 502 Basic Recruit Training Academy: C. Stearns 09/29-12/19/14 Concare Inc. Flooring sealing completed at PW in the main garage area Repairs to flooring coating around vehicle maint. hoist repairs Cook County Government Annual agreement for 2014 T1 data line for WAN & CABS Crystal Maintenance Services Corp. Extra cleaning at Public Works and Village Hall Building cleaning for the month of November at all buildings Dennison Leafblad, Deborah Freelance Camera Devincenzo, Jennifer / Betty Refund Overpayment Police Ticket P3934714 Diebel, Diane Reimbursement Pumpkin Expenses 2014 Dix, Kenneth S. 2014 Fire Uniform Allowance Dreisilker Electric Motors, Inc. Equipment Maintenance and Repair Elite Remodeling Group, Inc. Garnishment Enterprise Rent -a -car Toll violations for SIU rental vehicle Eterno, David G. Legal Evans, Margaret Reimburse training expenses Experian Background checks - October, 2014 Federal Express Corp Shipping for Sierra Modems Fire Pension Fund Fire Pension Page 1 of 10 Amount 894.01 4,782.08 31.69 62.00 315.00 48.00 1,920.00 1,240.00 99.35 99.35 99.35 2,750.00 705.15 341.79 30.00 319.92 689.00 115.00 253.50 194.70 80.00 80.00 1,713.69 1,982.85 2,670.50 117.85 60.65 78.90 61.47 12.30 20.50 10.03 10.48 14.58 25.03 12.30 215.00 367.41 276.37 3,080.00 19,804.18 6,602.10 1,023.00 221.83 7,181.81 150.00 54.00 24.94 328.04 123.30 142.22 11.50 487.50 32.00 77.24 109.82 23,319.39 VILLAGE OF MOUNT PROSPECT List of Bills October 30 - November 12, 2014 Fund Vendor Name Invoice Description Amount Fleck's Landscaping Grounds Maintenance 5,012.00 Grounds Maintenance 100.00 Friedman, Miriam Refund Overpayment Police Ticket P3936117 4.00 Gambino Landscaping and Brick Paving, Inc. Contractual Sprinkler Maintenance 1,315.00 Government Finance Officers Assoc Membership Renewal 12/1/14 -11/30/15 595.00 Grainger Inc. Other Equipment 180.90 Small Tools 154.58 Safety Glasses 157.40 Partial Shipment of Tyvek Suits and Face Shields 379.80 Head gear and face shields 332.00 Custodial Supplies 600.04 2 Boxes of Tyvek Suits and 3 Boxes of Face Shields 379.80 Maintenance and repair supplies 135.13 Graybar Electric Co. Street light supplies 783.80 Street light supplies 828.69 GreatAmerica Financial Services Corporation Office equipment 149.47 Guardian Emp. Dental November 2014 9,176.19 Hayes, Michael C. 2014 Fire Uniform Allowance 450.00 Heinking, Jill Reimbursement for supplies for program at the CCC 66.68 Homer Industries, LLC Grounds Maintenance 762.50 Homer Tree Care, Inc. Tree Removals 2,464.90 Tree Removals 2,338.15 Tree Removals 1,594.45 Tree Removals 898.45 Tree Removals 1,914.00 Tree Removals 4,959.75 Hoskinson, Thomas Reimburse training expenses 101.19 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 20,817.78 Illinois American Water Company Private Fire Service 10/30/14 -12/1/14 33.84 Illinois Department of Revenue IL State Withholding 71.56 IL State Withholding 36,065.48 Illinois Paper Co. Copy Paper 1,265.60 Illinois Society of Fire Service Instructors Incident Safety Officer Class for Lambel and Dolan 300.00 Incident Safety Officer Class for Lambel and Dolan 300.00 IMRF IMRF 155,524.08 Internal Revenue Service Federal Withholding 426.93 Federal Withholding 464.70 Federal Withholding 167,101.66 International Union of Operating Engineers IUOE PW Membership Dues 1,028.52 Ivankeyych, Crest Refund Overpayment Police Ticket P3936641 20.00 Karlstedt Landscape Group, Inc. Parkway Restoration 273.65 Kearney, Ryan Office Supplies 35.00 Kerstein, June Reimbursement Food Expense - 9/4/14 24.88 Reimbursement Food Expense -10/2/14 17.58 Kiesler Police Supply, Inc. Ammunition 1,026.04 Klein, Thorpe and Jenkins, Ltd. KTJ September billing 33,830.17 Lands' End Business Outfitters Clothing 435.72 Landscape Forms, Inc. Other Equipment 14,330.00 Lexington Corporate Enterprises, Inc. Maintenance and repair supplies 562.85 Maintenance and repair supplies 196.92 Lexisnexis Risk Data Management Inc. Background checks - October, 2014 40.00 Logsdon Consultation Services, Inc. Nims 30010/16 and 10/23, Nims 40010/28 and 11/4 Lambel/Uidl 320.00 Losoff, Aaron 2014 Fire Uniform Allowance 316.25 Luggage Limited Inc. Repair boot strap 15.00 Repair FF boot straps 25.00 Mcmaster-carr Supply Co. Key -Access box for fire trucks to store knox box keys 200.71 Metro Door and Dock, Inc. New radio control equipment to replace equip @ Fire Station #14 1,550.00 Metro Federal Credit Union MP Fire Local 4119 Dues 2,007.18 Metropolitan Alliance - Police MP Police Association Dues 1,367.50 Michael Wagner & Sons, Inc. Maintenance and repair supplies 154.27 Milieu Design LLC Landscape Maintenance 2,840.30 Mobile Print Inc. Business cards 37.18 Page 2 of 10 Fund Vendor Name Mobile Print Inc. Moder, Jenna Mond! Construction Inc. Moore Wallace North America Morton Salt, Inc Morton Suggestion Co. Mount Prospect Paint, Inc. Municipal Emergency Services, Inc. Murray and Trettel Inc. Nationwide Mutual Insurance Company NCPERS Group Life Ins. Neopost USA Inc. Nexus Office Systems, Inc. NFPA NICOR North East Multi Regional Trng Northern Illinois Funeral Service Inc. Northshore University Healthsystem Northwest Central Dispatch System Northwest Community Hospital Northwest Suburban United Way Novak & Parker Inc. NWBOCA Chapter 35 Paddock Publications, Inc. Pellegrino, Joseph PESI Petty Cash Phillips, Serena Police Pension Fund Ramirez Compost Service, Inc. Red Wing Shoe Store Redlin, Ronald Retro Bistro, Inc. Rezek, Tom Safety Service Systems, Inc. Schweppe Incorported Sebert Landscaping Co. Secretary of State Seleen, Wendy Sharpe, Timothy W. Skoog, Matthew T. Smith, Robert Society For Human Resource Mgmt Staples Contract & Commercial, Inc. State of Illinois Stevens, Christina L Steward, Dale R. Symbolarts, LLC. VILLAGE OF MOUNT PROSPECT List of Bills October 30 - November 12, 2014 Invoice Description Business Cards - Simmons, Schroeder Tree Lighting Poster FD Letterhead and Envelopes (5000 of each) Business Cards for Victoria Bran Reimbursement for EDC Budget 2014 Shared Cost Sidewalk Program 2014 Tax Forms Salt/De-Icing Agents Salt/De-Icing Agents Crime Prevention supplies Maintenance and repair supplies Suspenders Weather forecasting for the up coming winter season 2014-2015 Nationwide 457 (flat percent) IMRF Life Insurance Postage Machine Replenishment Meter Rental Annual Maintenance for 7 Copiers Membership Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Register S. Santi for training course 10/03/14 Remains removal: #14-15424 D. O'Hara from NWCH to ME PEPP Course for Schlenbecker/Swat Pre-employment testing: Physical for E. Knippel December 2014 - Member Assessment New Hire Physical for Johnson and Annual Physical for Misiejuk United Way Replacement refrigerator for the Village Hall 2014 Fall School registration Bid Notice Refund Permit Cancelled # 14-1603 Registration for Jan Abernethy Elder Law Petty Cash Finance October 2014 Petty Cash reimbursement Freelance Camera for FD Open House Police Pension Refuse Disposal Safety Shoe Allowance 2014 Fire Uniform Allowance Sister Cities Event 10/5/14 Rebate Sidewalk Shared Program Special Events Activities Maintenance and repair supplies 2014 Fall Perennial and Shrub Planting Rain Garden Planting Title & registration fees for seized vehicle: 2011 Toyota Camry Trademark registration PPE Bags Services Rendered 8/1/14 -10/31/14 Freelance Drone Flyover Reimburse expenses: Airfare for training conference SHRM Membership Annual Fee Toner for LIVESCAN Monthly Internet Fees Refund Reinspection Fee Permit#14-1893 2014 Fire Uniform Allowance Replacement badge for Sgt. Garris Page 3 of 10 Amount 74.37 113.49 743.02 49.46 73.88 50,403.50 268.29 6,589.38 5,294.34 590.00 63.99 106.22 2,801.00 11,482.97 665.60 3,000.00 1,222.07 3,612.00 165.00 740.30 360.31 142.29 1,639.99 232.12 22.99 50.00 300.00 200.00 239.00 56,811.12 1,232.00 233.14 998.00 240.00 55.35 50.00 199.99 439.41 8.15 465.54 29,247.95 600.00 85.49 450.00 600.00 875.00 635.91 796.60 17,722.00 110.00 196.00 5.00 201.24 2,700.00 300.00 328.10 170.00 206.99 1,166.25 50.00 67.95 85.00 VILLAGE OF MOUNT PROSPECT List of Bills October 30 - November 12, 2014 Fund Vendor Name Invoice Description Amount SysAid Technologies, Ltd. IT Help Desk maintenance agreement 90.00 The Ups Store Sister Cities mailing 36.45 Thompson Elevator Inspections Elevator Inspections 296.00 Kensington Road Improvements Elevator Inspections 930.00 6,667.70 Elevator Inspections 445.00 Motorola Subscriber Financing - November 2014 Elevator Inspections 2,627.00 4,497.70 Elevator Inspections 407.00 TKB Associates, Inc. Conversion of 20111 ncident/Acci dent reports to CD -Rom 6,425.86 TransUnion Risk and Alternative Data Solutions Inc Background checks - October, 2014 110.75 U.S. Bank Equipment Finance, Inc. Lease Contract 500-0413635-000 1,971.50 Public Works Contract Payment & Late Fee 170.02 Fire Station 12 Contract Payment 138.78 United Maintenance Company, Inc. Special Events Supplies 1,529.25 University of Illinois Registration for M. Weger for MFI Recertification 10/24/14 100.00 VCG Uniform Sabre Red OC spray 149.50 Sabre Red OC spray 373.75 Firefighter hat badges 293.70 Village of Mount Prospect Flex - Medical 8,523.75 Warehouse Direct Office supplies & toner 829.95 Weger, Mark Reimburse training expenses 217.28 Weissberg, Andrea Reimburse training expenses 32.00 Wheatley, Claire Headset Battery 33.03 WISCTF Garnishment 542.48 001 General Fund Total $ 799,283.70 020 Capital Improvement Fund EWS Consultants, Inc. Flooring Resources Corp. Gewalt Hamilton Assoc. Northwest Central 9-1-1 System Signs By Tomorrow Tommy Guns 020 Capital Improvement Fund Total 022 Downtown Redevelopment Construction Fund Milieu Design LLC 022 Downtown Redevelopment Construction Fund Total 023 Street Improvement Construction Fund Healy Asphalt Company,llc. Rubino Engineering, Inc. Traffic and Parking Control Co, Inc. 023 Street Improvement Construction Fund Total 024 Flood Control Construction Fund American Landscaping Inc. Burns & Mcdonnell Engineering Co. Constellation NewEnergy, Inc. Sebert Landscaping Co. 024 Flood Control Construction Fund Total Design for Customer Service Area $ 345.00 Removal and installation of new flooring tile at Public Works in 3,954.00 Kensington Road Improvements 19,946.09 Kensington Road Improvements 526.80 Kensington Road Improvements 1,027.80 Kensington Road Improvements 4,444.56 Kensington Road Improvements 2,145.36 Kensington Road Improvements 6,667.70 Kensington Road Improvements 7,441.35 Motorola Subscriber Financing - November 2014 10,603.91 Replacement outdoor message board for the Village Hall 4,497.70 Electro Paint Station 13 Gear Lockers 1,826.00 $ 63,426.27 Landscape Maintenance $ 6,192.88 $ 6,192.88 Asphalt materials for used for street patching $ 933.12 2014 Street Resurfacing 493.00 2014 Street Resurfacing 2,396.00 2014 Street Resurfacing 746.00 Traffic Improvements 255.00 Traffic Improvements 4,600.00 Traffic Improvements 590.40 $ 10,013.52 Creek bank stabilization per quote 200 E. Hiawatha $ 1,900.00 Engineering Services 20,377.00 Electrical Service Delivery 84.58 Backyard Drainage Rain Gardens 2,556.00 $ 24,917.58 Page 4 of 10 Fund Vendor Name 040 Refuse Disposal Fund ARC Disposal Company AT&T Groot Industries, Inc. ICMA Retirement Trust - 457 Illinois Department of Revenue IMRF Internal Revenue Service International Union of Operating Engineers Nationwide Mutual Insurance Company NCPERS Group Life Ins. Northwest Suburban United Way Schaefer Systems International, Inc. Village of Mount Prospect Wells Fargo Bank 040 Refuse Disposal Fund Total 041 Motor Fuel Tax Fund Constellation NewEnergy, Inc. Illinois State Treasurer Morton Salt, Inc 041 Motor Fuel Tax Fund Total 042 Community Development Block Grant Copenhaver Construction Inc ICMA Retirement Trust - 457 Illinois Department of Revenue IMRF Internal Revenue Service Peterson Roofing The American Institute of Architects Village of Mount Prospect 042 Community Development Block Grant Total 043 Asset Seizure Fund General Parts Inc. 043 Asset Seizure Fund Total 050 Water and Sewer Fund American Water Works Assoc. Aramark Uniform Services, Inc. AT&T Badger Meter Inc VILLAGE OF MOUNT PROSPECT List of Bills October 30 - November 12, 2014 Invoice Description Amount Refuse Disposal Program $ 115.16 Service 10/16/14 -11/15/14 3.92 Refuse Disposal Program 285.12 ICMA 457 (flat percent) 66.28 IL State Withholding 394.77 IMRF 2,939.66 Federal Withholding 2,665.31 IUOE PW Membership Dues 99.25 Nationwide 457 (flat percent) 207.11 IMRF Life Insurance 17.60 United Way 3.85 Recycling Carts 7,427.00 Flex - Medical 79.39 SWANCC - November 2014 104,761.52 $ 119,065.94 Electrical Service Delivery $ 154.43 Electrical Service Delivery 229.24 Electrical Service Delivery 103.84 Electrical Service Delivery 23.02 Electrical Service Delivery 31.03 Electrical Service Delivery 121.10 Electrical Service Delivery 94.62 Electrical Service Delivery 74.69 Electrical Service Delivery 2,544.43 Electrical Service Delivery 98.75 Electrical Service Delivery 46.45 Electrical Service Delivery 109.01 Electrical Service Delivery 109.69 Electrical Service Delivery 144.04 Traffic Light Maintenance 5,662.56 Salt/De-Icing Agents 14,666.68 Salt/De-Icing Agents 11,784.17 $ 35,997.75 2014 CDBG Sidewalk Program $ 51,092.00 ICMA 457 (flat percent) 375.00 IL State Withholding 52.85 IMRF 545.98 Federal Withholding 366.10 CDBG- rehab grant for Search Inc 15,000.00 CDBG annual membership dues 694.00 Flex - Medical 78.13 $ 68,204.06 Parts for seized 2011 Toyota Camry $ 50.72 $ 50.72 Office Supplies $ 76.00 Uniform Expense 99.35 Uniform Expense 99.35 Uniform cleaning and rental for all public works employees 99.35 Service 10/16/14 -11/15/14 261.85 AMR/AMI System 3,727.44 AMR/AMI System 6,191.20 AMR/AMI System 3,197.60 AMR/AMI System 969.15 Page 5 of 10 VILLAGE OF MOUNT PROSPECT List of Bills October 30 - November 12, 2014 Fund Vendor Name Invoice Description Amount AMR/AMI System 73,724.00 AMR/AMI System 16,267.23 AMR/AMI System 70,240.03 Bank of New York Mellon JAWA - September 2014 475,453.00 Baxter & Woodman, Inc. Professional Services 2,775.32 Bessie Nelson Utility Refund - 2707 Elayne Ct 23.32 Burns & Mcdonnell Engineering Co. Professional Services 165.00 Cardinal Fence & Supply Inc. Landscape and Fence Maintenance 406.00 Century Cleaners Uniform Cleaning 12.30 Uniform Cleaning 20.50 Uniform Cleaning 10.02 Uniform Cleaning 10.47 Uniform Cleaning 68.90 Uniform Cleaning 14.57 Uniform Cleaning 25.02 Uniform Cleaning 12.30 Constellation NewEnergy, Inc. Electrical Service Delivery 8,810.54 Corrpro Companies, Inc. Water Distribution Tank Repair Inspection 2,595.00 Dr D F Hoeg Utility Refund - 313 S Elmhurst Ave 365.28 Edmond Hughes Utility Refund -1505 Redwood Dr 273.10 HBK Water Meter Service Water Meter Installations 2,060.80 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 1,265.55 Illinois Department of Revenue IL State Withholding 2,879.71 IMRF IMRF 22,007.05 Internal Revenue Service Federal Withholding 17,375.25 International Union of Operating Engineers IUOE PW Membership Dues 932.89 Karlstedt Landscape Group, Inc. Parkway Restoration 2,585.85 Kimberly Gasparaitis Utility Refund - 209 Withorn Ln 49.62 Latitude Geographics Group Ltd. GIS Maintenance 181.70 LC United Painting Co., Inc. Tank Repair Rehab 570,131.15 Melody Metzger Utility Refund -120 Yates Ln 14.34 Mercury Partners 90 BI Inc. Building Maintenance and Repair 525.00 Milieu Design LLC Landscape Maintenance 2,991.82 MUNIPLY LLC. AMR Systems 28,750.00 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 420.89 NCPERS Group Life Ins. IMRF Life Insurance 52.80 Nexus Office Systems, Inc. Annual Maintenance for 7 Copiers 518.00 NICOR Natural Gas Consumption 74.09 Natural Gas Consumption 104.19 Natural Gas Consumption 91.69 Northwest Suburban United Way United Way 34.73 Ray E. Snyder Utility Refund - 518 Can Dota Ave 113.92 Safeday, Inc. Sewer Lift Station 1,517.25 TigerDirect, Inc. Repair Maintenance Supplies 406.40 Repair Maintenance Supplies 464.47 Repair Maintenance Supplies 195.86 U.S. Bank Equipment Finance, Inc. Lease Contract 500-0413635-000 177.50 Public Works Contract Payment & Late Fee 170.01 UPS Store #707 Shipping Expenses 24.07 Village of Mount Prospect Flex - Medical 625.45 Warehouse Direct Office Supplies 110.73 050 Water and Sewer Fund Total $ 1,322,845.97 051 Village Parking System Fund Cardinal Fence & Supply Inc. Landscape and Fence Maintenance $ 130.25 Crystal Maintenance Services Corp. Extra cleaning at Public Works and Village Hall 9.84 Building cleaning for the month of November at all buildings 318.57 Elite Remodeling Group, Inc. Garnishment 78.19 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 8.99 Illinois Department of Revenue IL State Withholding 51.09 IMRF IMRF 409.12 Internal Revenue Service Federal Withholding 305.49 Page 6 of 10 VILLAGE OF MOUNT PROSPECT List of Bills October 30 - November 12, 2014 Fund Vendor Name Invoice Description Amount International Union of Operating Engineers IUOE PW Membership Dues 15.21 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 9.96 Village of Mount Prospect Flex - Medical 34.64 051 Village Parking System Fund Total $ 1,371.35 052 Parking System Revenue Fund Cardinal Fence & Supply Inc. Landscape and Fence Maintenance Crystal Maintenance Services Corp. Extra cleaning at Public Works and Village Hall American Messaging Building cleaning for the month of November at all buildings Elite Remodeling Group, Inc. Garnishment ICMA Retirement Trust - 457 ICMA 457 (flat percent) Illinois Department of Revenue IL State Withholding IMRF IMRF Internal Revenue Service Federal Withholding International Union of Operating Engineers IUOE PW Membership Dues Nationwide Mutual Insurance Company Nationwide 457 (flat percent) Petty Cash Petty Cash Finance October 2014 Sebert Landscaping Co. 2014 Fall Perennial and Shrub Planting Union Pacific Railroad Metra Land Lease - Aug 2014 Village of Mount Prospect Flex - Medical 052 Parking System Revenue Fund Total 530 Window switches 060 Vehicle Maintenance Fund Addison Building Material Co. Vehicle Maintenance Supplies American Messaging Pager rental Arlington Heights Ford Equipment Maintenance and Repair AT & T Service 10/16/14 - 11/15/14 Chicago Parts & Sound Llc Vehicle Maintenance Supplies 526 Spark plugs Vehicle Maintenance Supplies Police rear brake rotors and pads 4 Police batteries Concare Inc. Repairs to flooring coating around vehicle maint. hoist repairs Cylinders, Inc. Equipment Maintenance and Repair Foster Coach Sales Inc. Vehicle Maintenance Supplies General Parts Inc. Bulbs Global Emergency Products 530 Window switches 518 Lighting ECU Module 518 Roll up door handle and bracket 518 Light switches Grossinger Chevrolet 2709A Gasket ICMA Retirement Trust - 457 ICMA 457 (flat percent) Illinois Department of Revenue IL State Withholding IMRF IMRF Inland Power Group Inc. Cabin Filters Internal Revenue Service Federal Withholding International Union of Operating Engineers IUOE PW Membership Dues Liebovich Bros, Inc. Vehicle Maintenance Supplies Mcmaster-carr Supply Co. Antiseize lubricant Sanding discs Morton Grove Automotive 4570 Rebuild alternator Napa -Heights Automotive Supply 518 Relays Power outlets Dielectric grease Fuel system cleaner NCPERS Group Life Ins. IMRF Life Insurance Northwest Suburban United Way United Way Palatine Oil, Inc. 6,503 Gallons diesel fuel 8,009 Gallons of gasoline Precision Service & Parts P-11 spark plugs and wires Rush Truck Centers of Illinois, Inc. Vehicle Maintenance Supplies Vehicle Maintenance Supplies Page 7 of 10 11 236.75 8.33 269.62 64.02 6.03 37.12 302.86 221.41 10.17 6.65 13.00 3,284.00 3,285.20 27.44 7,772.60 8.20 73.94 309.35 9.81 (104.36) 12.60 (59.70) 319.84 417.44 1,244.46 466.25 101.17 69.90 44.62 1,010.38 52.17 62.96 5.63 832.69 1,443.02 11,174.51 37.44 8,800.26 474.38 97.65 152.55 89.56 125.00 54.28 38.35 25.96 23.96 48.00 3.85 19,393.96 20,396.61 108.22 235.56 (235.56) VILLAGE OF MOUNT PROSPECT List of Bills October 30 - November 12, 2014 Fund Vendor Name Invoice Description $ Amount Rush Truck Centers of Illinois, Inc. Small Tools 353.00 McNabola Law Group, P.C. Turbo clamps 78.31 Medicare, Wps 2750 HVAC motor 31.41 Municipal Claims and Safety Agreement Turbo clamp 8.75 Solvent Systems Int'I. Inc. Parts washer rental and maintenance 300.00 Village of Mount Prospect Flex - Medical 195.84 Waytek, Inc. Vehicle Maintenance Supplies 27.51 063 Risk Management Fund Total Vehicle Maintenance Supplies _ $ 1,402,031.28 419.55 West Side Tractor Sales 4506 Roll pins 15.22 Wholesale Direct Inc. Vehicle Maintenance Supplies 45,803.43 243.60 060 Vehicle Maintenance Fund Total $ 69,038.10 061 Vehicle Replacement Fund 7,616.02 SFAM, LLC Catching Fluidpower Equipment for Public Works Vehicles $ 30.98 Dultmeier Sales Davenport Inc Equipment for Public Works Vehicles 1,350.00 35.94 Liebovich Bros, Inc. Equipment for Public Works Vehicles 72,620.41 130.00 MacNeil Automotive Products Ltd. Equipment for Public Works Vehicles 94.79 Rush Truck Centers of Illinois, Inc. Equipment for Public Works Vehicles 40,643.30 85.94 Waytek, Inc. Equipment for Public Works Vehicles 7,789.47 295.46 061 Vehicle Replacement Fund Total $ 673.11 063 Risk Management Fund Intergovernmental Per.ben.coop IPBC - October 2014 $ 497,343.84 IPBC- November 2014 497,343.84 McNabola Law Group, P.C. Caputo Settlement - Date of Incident 02/01/13 163,934.80 Medicare, Wps Caputo Settlement #330424748A 1,065.20 Municipal Claims and Safety Agreement WC Settlement - Stephenson 30,970.85 WC Settlement - Hanneman 125,000.00 WC Settlement - Swat 35,627.50 WC Claims - September 2014 50,745.25 063 Risk Management Fund Total _ $ 1,402,031.28 070 Police Pension Fund Internal Revenue Service Federal Withholding $ 45,803.43 Mesirow Financial Investment Management, Inc. Inv Mgr Fees 7/1/14 - 9/30/14 5,631.96 Segall Bryant & Hamill Inv Mgr Fees 7/1/14 - 9/30/14 7,616.02 SFAM, LLC Inv Mgr Fees 6/30/14 - 9/30/14 12,219.00 Sharpe, Timothy W. Services Rendered 8/1/14 -10/31/14 1,350.00 070 Police Pension Fund Total $ 72,620.41 071 Fire Pension Fund Internal Revenue Service Federal Withholding $ 40,643.30 Segall Bryant & Hamill Inv Mgr Fees 7/1/14 - 9/30/14 7,789.47 Sharpe, Timothy W. Services Rendered 8/1/14 -10/31/14 1,350.00 Wells Fargo Bank Inv Mgr Fees 7/1/14 - 9/30/14 4,546.04 071 Fire Pension Fund Total $ 54,328.81 073 Escrow Deposit Fund A & Vega's Landscaping Inc All Way Sign American National Sprinkler AML Systems Inc Archadeck of Chicagoland Associated Heating Group Inc Associated Restoration & Cons Service Beach Builders Inc Bednarek, David I Belter Landscaping Inc Blatz, Louis Campesino Landscaping Capps Plumbing and Sewer Inc Refund Escrow Permit # 14-2062 Refund Escrow Permit # 14-2165 (102 S Emerson St) Refund Escrow Permit # 14-1947 (124 Stratton Ln) Refund Escrow Permit # 14-2310 (505 S Wille St) Refund Escrow Permit # 14-0806 (301 S William St) Refund Escrow Permit # 14-1782 (109 N Elmhurst Ave) Refund Escrow Permit # 14-2181 (510 S William St) Refund Escrow Permit # 14-1524 (107 We Go Trail) Refund Escrow Permit # 14-1767 (1202 Greenwood Dr) Refund Escrow Permit # 12-1867 Refund Escrow Permit # 14-2212 (220 S William St) Refund Escrow Permit # 14-0334 Refund Escrow Permit # 14-2076 (509 N Pine St) Refund Escrow Permit # 14-2230 (1112 Oakwood Dr) Page 8 of 10 200.00 125.00 125.00 125.00 350.00 200.00 150.00 150.00 400.00 400.00 200.00 200.00 150.00 125.00 VILLAGE OF MOUNT PROSPECT List of Bills October 30 - November 12, 2014 Fund Vendor Name Invoice Description Amount Cascade Renovation & Construction Inc Refund Escrow Permit # 13-2185 (800 Butternut Lane) 1,000.00 Cassata, Rosario Refund Escrow Permit # 14-1902 (207 Eric Ave) 200.00 Cassata, Salvatore Refund Escrow Permit # 14-0881 200.00 CB Home Improvement Refund Escrow Permit # 14-0950 (1411 Lama Ln) 75.00 Cedro, Marek Refund Escrow Permit # 14-2141 (111 Fairview Ave) 125.00 CNC Graphics Inc Refund Escrow Permit # 14-1980 (1471 Business Center Dr) 125.00 Compass RE Services Refund Escrow Permit # 12-1364 (3 S Emerson St # A) 7,364.00 Refund Escrow Permit # 12-1848 (9 S Emerson St) 5,475.00 Complete Lawn and Snow Services Inc Refund Escrow Permit # 14-1869 (1004 Greenfield Ln) 200.00 Condon, John Refund Escrow Permit # 14-2050 185.00 Crystal Court Shopping Center Refund Escrow Permit # 14-2015 125.00 Danley Lumber Co Refund Escrow Permit # 14-1108 (412 N Maple St) 100.00 Del Porte, Jeffrey Refund Escrow Permit # 13-2316 300.00 Dire Electric Refund Escrow Permit # 14-2167 (602 E Council Trl) 125.00 Dolan, Patrick R Refund Escrow Permit # 14-2105 200.00 Elmwood Park Masonry & Concrete Refund Escrow Permit # 14-2065 (206 N School St) 200.00 Envy Home Services Refund Escrow Permit # 14-0789 (1111 Sprucewood Dr) 250.00 Flush Sewer & Drainage Refund Escrow Permit # 14-1726 (1518 Mura Ln) 125.00 Refund Escrow Permit # 14-2044 (16 N William St) 125.00 Refund Escrow Permit # 14-2219 (1758 Tano Ln) 125.00 Hartgenbush, John M Refund Escrow Permit # 13-1972 200.00 Hayes, Lawrence Refund Escrow Permit # 14-2253 125.00 Heisler, Jefferey G Refund Escrow Permit # 14-1296 200.00 Hertfordshire Refund Escrow Permit # 14-2324 (419 E Euclid Ave) 125.00 Hoefert, Paul M Refund Escrow Permit # 14-1858 200.00 Hogan, James A Refund Escrow Permit # 14-0613 150.00 Ibbotson Heating Company Refund Escrow Permit # 14-2236 (508 Eastwood Ave) 125.00 Refund Escrow Permit # 14-2294 125.00 Refund Escrow Permit # 14-2295 (1714 Mura Ln) 125.00 Ibbotson, Gregory Refund Escrow Permit # 14-1344 200.00 Infinity Property Services Refund Escrow Permit # 14-1492 (905 E Rand Rd) 125.00 Isbell, Ron Refund Escrow Permit # 14-2358 125.00 JNL Climate Control Inc Refund Escrow Permit # 14-1294 (402 E Kensington Rd # A) 125.00 Refund Escrow Permit # 14-2156 (910 S Waverly Ave) 75.00 Karkut, Marek Refund Escrow Permit # 14-2196 200.00 Kensington Professional Center LLC Refund Escrow Permit # 14-2073 (411 Business Center Dr) 125.00 Kieffer & Co. Inc Refund Escrow Permit # 14-0918 (1002 5 Elmhurst Rd) 125.00 Leads Construction Company LLC Refund Escrow Permit # 14-1375 (1613 Cedar Ln) 500.00 Lee, Rita H Refund Escrow Permit # 14-2330 125.00 Lincoln, James L Refund Escrow Permit # 14-0931 125.00 Luke Butler Improvements LLC Refund Escrow Permit # 14-1669 (502 N Elm St) 125.00 Manning, Peter T Refund Escrow Permit # 14-1350 200.00 Midcity Plumbing Inc Refund Escrow Permit # 14-1681 (1502 E Emmerson Ln) 75.00 Modern View Enterprise Inc Refund Escrow Permit # 14-1656 (2 N Kenilworth Ave) 200.00 Mount Prospect Greens LLC Refund Escrow Permit # 14-1496 (1968 W Algonquin rd. # 4C) 600.00 Refund Escrow Permit # 14-1004 (2016 W Algonquin Rd # 8A) 200.00 Refund Escrow Permit # 14-1493 (2030 W Algonquin Rd # 613) 300.00 Norb & Sons Electric Refund Escrow Permit # 14-1854 (110 N Lancaster St) 125.00 O Neil, Edward Refund Escrow Permit # 14-1623 200.00 Oberhardt, Dorothy Refund Escrow Permit # 14-2193 75.00 O'Grady, John Refund Escrow Permit # 14-2247 200.00 Okon, David A Refund Escrow Permit # 14-2183 200.00 Pellegrino, Joseph Refund Escrow Permit # 14-1603 200.00 Perles, Tom Refund Escrow Permit # 14-1248 200.00 Peterson, Maureen Refund Escrow Permit # 14-1607 200.00 Preston, Earl Refund Escrow Permit # 14-1318 200.00 Principal Construction Corp Refund Escrow Permit # 13-1142 (800 Biermann Ct) 500.00 Quality Plumbing Services Inc Refund Escrow Permit # 14-2292 (313 N Elmhurst Ave) 125.00 Raincoat Roofing Systems Inc Refund Escrow Permit # 14-1364 (1092 Tamarack Dr) 125.00 Rappa, Giuseppe Refund Escrow Permit # 14-1541 200.00 Roberts, Scott Refund Escrow Permit # 14-2169 200.00 Rustic Wood Fence Refund Escrow Permit # 14-0967 (1038 Arbor Ct) 150.00 Page 9 of 10 VILLAGE OF MOUNT PROSPECT List of Bills October 30 - November 12, 2014 Fund Vendor Name Invoice Description Amount Sahagian, Donald R Refund Escrow Permit # 14-0575 200.00 Sawidis, John Refund Escrow Permit # 14-0930 (1720 Dempster St) 125.00 Sijapati, Shashi Refund Escrow Permit # 14-2339 125.00 Sokol, Gregory Refund Escrow Permit # 14-1865 200.00 Spotlight Inc Refund Escrow Permit # 14-2288 (701 Forest Ave) 125.00 Swenson, Sharon Refund Escrow Permit # 14-1770 (410 S Albert St) 200.00 The Cutting Edge of Palatine Inc Refund Escrow Permit # 14-2155 (1404 Plum Ct # B) 200.00 Third District Circuit Court Bond Check 10/30/14 2,210.00 Toptec Heating Cooling Plumbing and Electrical TS Landscaping United Structural Systems of Illinois Windy City RE LLC Yoder, Scott 073 Escrow Deposit Fund Total Grand Total Bond Check 11/4/14 Bond Check 11/6/14 Bond Check 11/11/14 Refund Escrow Permit # 14-2123 (1905 Cholo Ln) Refund Escrow Permit # 14-2124 (1928 Cholo Ln) Refund Escrow Permit # 14-2146 (501 S Edward St) Refund Escrow Permit # 14-2099 (518 Can Dota Ave) Refund Escrow Permit # 14-0450 (2016 W Algonquin Rd # 9B) Refund Escrow Permit # 11-2484 Refund Escrow Permit # 14-2018 Page 10 of 10 845.00 830.00 890.00 75.00 25.00 200.00 125.00 300.00 175.00 200.00 $ 34,399.00 $ 4,092,233.05