The URL can be used to link to this page

Home My WebLink About3. Monthly Financial Report & Approve Bills 12/16/2014Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: DECEMBER 12, 2014 SUBJECT: MONTHLY FINANCIAL REPORT — NOVEMBER 2014 Attached hereto are the cash position and investment statements of the Village for the month ended November 30, 2014. These statements provide a snapshot of the Village's cash position as of the month end date noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you receive. The first statement presents the Village's cash position broken down by governmental and enterprise funds and trust and agency funds. The second statement presents the Village's cash position by fund type. The third statement presents the list of investments again broken down by governmental and enterprise funds and trust and agency funds. It is important to note that although we have included the trust and agency funds in the cash position report, these funds are not accessible for Village operations. They are restricted for pension and escrow funding only. Please read the summary that follows for further detail on the cash position of the Village. Cash and Investment Position Report — All Funds (page 1) This report provides a detail summary of cash and investments for the Village broken out by governmental and enterprise funds and trust and agency funds. Governmental funds include the General Fund, Special Revenue Funds, Debt Service Fund, Capital Project Funds and Internal Service Funds. The Enterprise Funds consist of the Water/Sewer Fund and two (2) Parking Funds. Trust funds include the Village's two public safety pensions (Police and Firefighters') while the agency funds include the Escrow Deposit, Flexcomp Escrow and Library Bonds Escrow Fund. The Escrow Deposit Fund accounts for refundable deposits held by the Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Library Bonds Escrow Fund accounts for the accumulation of monies for debt service payments. Governmental and Enterprise Funds - Cash and cash equivalents at October 31 were $49.8 million. During November, cash receipts totaled $4,255,805. In addition, inflows due to interfund activity totaled $45,450 and investment income for the month was $1,904. There was also a net transfer in from investment activity of $749,460. Reductions in cash and cash equivalents during November totaled $5,657,844. Of this amount, payments to vendors were $4,362,383 and employee payroll and related expenses were $1,291,713. Other disbursements of $3,748 accounted for the balance of the change during November. Cash and cash equivalents at November 30 were $49.2 million. Monthly Financial Report — November 2014 December 12, 2014 Page 2 Investments in the Governmental and Enterprise Funds at October 31 were $1.2 million. One CD with a market value of $748,400 matured during November. 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 November 30 were $498,500 million. Total cash and investments for Governmental and Enterprise Funds at October 31 were $51,064,310. Cash and investments at November 30 totaled $49,710,685. This is a decrease of $1,353,625. Trust and Agency Funds - Cash and cash equivalents at October 31 were $5.3 million. During November, cash receipts totaled $228,883. Investment income for the month was $78,134. There was also a net increase in cash due to investment activities of $163,708 while outflows due to Interfund activity totaled $45,450. Reductions in cash and cash equivalents during November totaled $954,587. Of this amount, payments to vendors were $362,604, employee payroll and related expenses were $578,539 and payments related to the flexible spending program totaled $10,347. Other disbursements reflect totaled $3,097. Cash and cash equivalents at November 30 were $4.8 million. Total investments at November 30 were $111,985,518, an increase of $654,292 from October 31. There were unrealized investment gains of $818,000 and a net transfer to cash of $163,708 that accounted for the change. Total cash and investments for Trust and Agency Funds at October 31 were $116,676,486. Cash and investments at November 30 totaled $116,801,466. This is a decrease of $124,980. Summary of Cash Activity by Fund Type (page 2) This report provides a breakdown of the cash activity for the month broken down by fund type. This breakdown is useful in identifying where the activity (receipts and disbursements) is occurring. There are times during the year when activity in certain funds such as the capital improvement and special revenue funds is higher than normal. This will distort the financial picture of some of the other components of the governmental funds such as the General Fund which tends to be more level and predictable in terms of spending and receipt of revenue. Each month the report will provide detail explanation on activity of the General Fund, the Village's primary operating fund. The report will also provide additional information on fund types that experienced higher than normal activity for the month. Detail on the activity of the General Fund is highlighted below. General Fund — Cash and cash equivalents at October 31 totaled $9,808,478. During November, cash receipts totaled $2,298,553 and investment income was $109. There was also interfund activity that decreased cash by $641,728. Significant cash receipts included sales and telecommunication taxes. Sales tax revenues for the month totaled $1,282,382. Of this amount, $1,154,477 was generated from the 1% state portion while $127,905 was generated from the .25% home rule portion. Sales taxes received in November are for August sales as there is a three- month lag in getting this distribution from the state. H:\NCCT\Treasurer's Report\2014\Monthly Cash Position Report - November 2014.docx Monthly Financial Report — November 2014 December 12, 2014 Page 3 Telecommunication fax receipts for November also reflect August activity. Total receipts for the month were $183,454. Disbursements from the General Fund for November included payments to vendors of $1,309,986, payments for employee wages and benefits of $1,145,305 and other disbursements of $3,748 Cash and cash equivalents at November 30 were $9,006,374. There were no investments in the General Fund at November 30. Statement of Investments (page 3) This report provides a breakdown of investments by governmental and enterprise funds and trust and agency funds. The report also provides a fund -by fund breakdown of the investments. Government and Enterprise Funds - Investments for the governmental and agency funds are typically made up of Certificates of Deposit. At November 30 there was a total of $498,500 invested in CD's. These CD's are investing proceeds of the 2013 flood control bond issue. Other surplus funds in the governmental and enterprise funds have been placed in interest bearing money market accounts. Maturity Purchase Financial Date Date Institution FLOOD CONTROL CONSTRUCTION FUND (024) 12/18/14 01/21/14 Far East National Bank, CA 12/18/14 01/21/14 Onewest Bank FSB, CA 1 Investment C3SIP/ Interest Market Description FDIC # Rate % Value Certificate of Deposit 21851 0.350% 249,200.00 Certificate of Deposit 58978 0.300% 249,300,00 498,500.00 $ 498,500.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:WCCT\Treasurer's Report\2014\Monthly Cash Position Report - November 2014.docx Monthly Financial Report — November 2014 December 12, 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 Date Date Institution POLICE PENSION FUND (070) Various Various Wells Fargo Various Various Various FI PENSION FUND (0711 Various Various Wells Fargo Various Various Various TOTAL TRUST AND AGENCY FUND INVESTMENTS Investment CUSIP( Interest Market Description --------------- Acct # Rate % Value Wells Fargo Investments Various Various $ 23,195,990.27 Mutual Fund Investments Various Various 34,175,089.18 57,371,079.45 Wells Fargo Investments Various Various 21,192,019.26 Mutual Fund Investments Various Various 33,422,419,39 54,614,438.65 $ 111,985,518,10 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 - November 2014.docx VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended November 30, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and Cash Equivalents Investments Balance at October 31, 2014 $ 49,817,409.55 $ 1,246,900.00 Cash receipts Investment income Transfers from investments to cash Transfers to investments from cash Interfund activity Disbursements: Accounts payable Payroll Other Balance at November 30, 2014 Balance at October 31, 2014 4,255,804.73 1,903.98 749,460.32 45,449.65 (4,362,382.66) (1,291,713.28) (3,747.58) 1,060.32 (749,460.32) Total Cash and Investments $ 51,064,309.55 4,255,804.73 2,964.30 45,449.65 (4, 362, 382.66) (1,291,713.28) (3,747.58) $ 49,212,184.71 $ 498,500.00 $ 49,710,684.71 TRUST AND AGENCY FUNDS '° Cash and Cash Equivalents Investments $ 5,345,259.79 $ 111,331,226.16 Cash receipts 228,882.52 Investment income (loss) 78,134.39 817,999.67 Transfers from investments to cash 1,655,576.89 (1,655,576.89) Transfers to investments from cash (1,491,869.16) 1,491,869.16 Interfund activity (45,449.65) Disbursements: Accounts payable Payroll Flex spending Other Balance at November 30, 2014 (362,604.22) (578,538.99) (10,347.02) (3,097.10 Total Cash and Investments $ 116,676,485.95 228,882.52 896,134.06 (45,449.65) (362,604.22) (578,538.99) (10,347.02) (3„097.10) $ 4,815,947.45 $ 111,985,518.10 $ 116,801,465.55 Assets are restricted in purpose and do not represent discretionary assets of the government. 1 CASH & CASA EQUIVALENTS Beginning balance Cash receipts Investment income Transfers from investments Transfers to investments Interfund Disbursements - other Disbursements - payroll Disbursements - accounts l I== VILLAGE OF MOUNT PROSPECT Summary of Cash Activity by Fund Type For the Month Ended November 30, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS SPECIAL CAPITAL REVENUE DEBT SERVICE PROJECTS ENTERPRISE INTERNAL GENERAL FUND FUNDS FUNDS FUNDS FUNDS SERVICE FUNDS TRUST AND AGENCY FUNDS * TOTAL GOVT. FIRE AND OTHER TRUST AND ENTERPRISE POLICE AND AGENCY FUNDS PENSIONS FUNDS TOTAL $ 9;808,47$14 $ 4,157,307.97 $ 1,906,849,70 $ 17,799,867.76 $ 6,106,545.98 $ 105038,360.00 $ 49,817,409.55 $ 2,600,345.56 $ 2,744,914.23 $ 55,162,669.34 2,298,553.46 438,906.40 130,815,12 335,64959 954,567-45 97,31271 4,255,804.73 116,967.34 111,915.18 4,484,68725 109.29 61.57 14.23 85775 114.18 746.96 1,903.98 77,970.55 163.84 80,038.37 - - - 749,460.32 - - 749,460.32 1,655,576.89 - 2,405,037.21 - - - - (1,491,869.16) (1,491,869.16) (641,727.69) 34,691.80 (3,231.19) 3,231.19 (163,680.54) 816,166.08 45,44965 (39,795.10) (5,654.55) 0.00 (3,747.58) - - (3,747.58) (3,09710) (6,844-68) (10,347-02) (10,347-02) (1,145,304.75) (12,99772) (90,24459) (43,166.22) (1,291,713.23) (578,538.99) (1,870,252 27) (1,309,986-39) (497,157.22) (40,376,29) (187,634A7) (1,457,876.14) (869,352 15) (4,362,382.66) (11 9.510.22) (243.094,00) (4,724,986-88) 9.006.374A8 4,120,812.80 1,994.071.57 18.701,432-14 5,349,426,34 10,040,067.38 49.212,184-71 2,221,146.87 2,594,800758 54,028,132416 INVESTMENTS Certificates of deposit 498,500.00 498,500.00 498,500.00 Wells Fargo investments - - 44,388,009.53 441388,009.53 Mutual fund investments - - 67;597,508.57 87 597,508 57 Total investments 498,50000 s 498,500.00 111,985,518.10 111484,018.10 TOTAL CASH AND INVESTMENTS $ 9,006,374.48 $ 4,120,812.80 $ 1,994,071.57 $ 19,199,932.14 $ 5,349,426.34 $ 10,040,067.38 $ 49,710,684.71 $114,206,664.97 $ 2,594,800.58 $166,512,150.26 Ili VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of November 30, 2014 Maturity Purchase GOVERNMENTAL AND ENTERPRISE FUNDS Date Maturity Purchase Financial Investment CUSIP/ Date Date Institution Dewfi1xion FDIC # FLOOD CONTROL CONSTRUCTION FUND (024) Various Wells Fargo 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 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 TRUST AND AGENCY FUNDS * Investment CUSIP/ Description Acct # 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. Interest Market Rate % Value 0.350% 249,200.00 0.300% 249,300.00 498,500.00 $ 498,500.00 Interest Market Rate % Value Various $ 23,195,990.27 Various __34-1-15.�.089 18 57,371,079.45 Various 21,192,019.26 Various _13,42 419.39 2_, 54,614,438.65 $ 111,985,518-10 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES November 01— November 30, 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 Revenue Budget by Account Classification Repoit Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD 14,674,466.00 .00 14,674,466.00 56,799.49 .00 14,458,097.51 216,368.49 99 12,572,992.61 8,241,500.00 .00 8,241,500.00 747,665.44 .00 6,119,749.79 2,121,750.21 74 5,804,304.66 1,621,000.00 .00 1,621,000.00 70,946.37 .00 1,618,445.91 2,554.09 100 2,726,132.02 18,083,100.00 .00 18,083,100.00 1,239,123.97 .00 13,948,732.01 4,134,367.99 77 12,512,351.96 1,516,000.00 .00 1,516,000.00 127,774.82 .00 1,426,365.34 89,634.66 94 1,367,616.44 491,000.00 .00 491,000.00 31,712.87 .00 420,654.05 70,345.95 86 385,776.78 22,500.00 .00 22,500.00 264.07 .00 4,052.67 18,447.33 18 6,477.70 226,000.00 .00 226,000.00 24,832.67 .00 328,261.83 (102,261.83) 145 185,537.96 918,500.00 .00 918,500.00 11,716.29 .00 251,987.53 666,512.47 27 251,370.60 20,000.00 .00 20,000.00 .00 .00 20,000.00 .00 100 37,413.30 REVENUE TOTALS $45,814,066.00 $0.00 $45,814,066.00 $2,310,835.99 $0.00 $38,596,346.64 $7,217,719.36 84% $35,849,974.03 Fund 001 - General Fund Totals $45,814,066.00 $0.00 $45,814,066.00 $2,310,835.99 $0.00 $38,596,346.64 $7,217,719.36 $35,849,974.03 NJ Revenue Budget by Account Classification Repoit Through 11/3 /1 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 002 - Debt Service Fund REVENUE Property Taxes 2,237,000.00 .00 2,237,000.00 10,114.68 M 2,216,862.61 20,137.39 99 1,724,739.25 Other Taxes 1,056,532.00 .00 1,056,532.00 100,398.33 M 690,732.65 365,799.35 65 444,475.53 Intergovernmental Revenue 43,005.00 .00 43,005.00 21,904.01 .00 43,831.65 (826.65) 102 43,500.85 Investment Income 400,00 .00 400.00 14.23 .00 81.76 318.24 20 489.31 Other Revenue .00 .00 .00 112.38 ,00 112.38 (112.38) ... .00 Other Financing Sources .00 .00 .00 (3,231.19) ,00 .00 .00 ... .00 REVENUE TOTALS $3,336,937.00 $0.00 $3,336,937.00 $129,312.44 $0:00 $2,951,621.05 $385,315.95 88% $2,213,204.94 Fund 002 - Debt Service Fund Totals $3,336,937.00 $0.00 $3,336,937,00 $129,312.44 $0.00 $2,951,621.05 $385,315.95 $2,213,204.94 Account Classification Fund 020 - Capital Improvement Fund REVENUE Revenue Budget by Account Classification Repoit Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'cl Prior Year YTD 01T I axes 1,246,000.00 .00 1,246,000.00 118,402.77 .00 814,601.78 431,398.22 65 765,273.14 Intergovernmental Revenue '00 .00 .00 .00 .00 .00 .00 +++ 91,171.05 Investment Income 1,000.00 .00 1,000.00 34.70 .00 469.05 530.95 47 718.86 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 REVENUE TOTALS $1,257,000.00 $0.00 $1,257,000.00 $118,437.47 $0.00 $955,251.83 $301,748.17 76% $1,164,396.05 Fund 020 - Capital Improvement Fund Totals $1,257,000.00 $0.00 $1,257,000.00 $118,437.47 $0.00 $955,251.83 $301,748.17 $1,164,396.05 LO IT Account Classification Revenue Budget by Account Classification Report Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 021 ® Series 2009 Construction Fund REVENUE Intergovernmental Revenue ,00 .00 '00 .00 .00 00 .00 +++ .00 Investment Income .00 .00 .00 .00 '00 .00 .00 ... 7.84 Other Revenue .00 .00 .00 .00 .00 .00 .00 ... .00 Other Financing Sources ,00 .00 .00 ,00 .00 .00 .00 +++ .00 REVENUE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ... $7.84 Fund 021 - Series 2009 Construction Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.84 Adopted Budget Account Classification Budget Amendments Fund 022 - Downtown Redevelopment Construct REVENUE lolf.=im, 41811, Repoit Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Property Taxes 2,671,000.00 .00 2,671,000.00 .00 .00 2,295,862.29 375,137.71 86 2,398,608.07 Investment Income 1,000.00 .00 1,000.00 32.71 .00 332.20 667.80 33 825.20 Reimbursements .00 .00 .00 .00 .00 .00 .00 ... .00 Other Revenue .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 $32.71 $0.00 $2,296,194.49 $375,805.51 86% $2,399,433.27 Fund 022 -Downtown Redevelopment Construct Totals $2,672,000.00 $0.00 $2,672,000.00 $32.71 $0.00 $2,296,194.49 $375,805.51 - $2,399,433.27 Al Ho Repoit Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amerded Current Month YTD YTD Budget - YTD used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 023 - Street Improvement Construc Fund REVENUE Other Taxes 2,057,000.00 .00 2,057,000.00 183,847.00 .00 1,457,722.95 599,277.05 71 1,127,264.76 Licenses, Permits & Fees 1,045,000.00 .00 1,045,000.00 5,892.75 .00 1,012,706.52 32,293.48 97 .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 120.41 .00 4,222.14 (4,122.14) 4222 134.65 Reimbursements .00 .00 .00 .00 .00 .00 .00 ... .00 Other Revenue 6,000.00 .00 6,000.00 23,749.50 .00 103,821.33 (97,821.33) 1730 11,726.29 Other Financing Sources 6,500,000.00 .00 6,500,000.00 43,995.93 .00 6,584,696.75 (84,696.75) 101 .00 REVENUE TOTALS $9,608,100.00 $0.00 $9,608,100.00 $257,605.59 $0.00 $9,280,669.69 $327,430.31 97% $1,142,737.22 Fund 023 - Street Improvement Construc Fund Totals $9,608,100.00 $0.00 $9,608,100.00 $257,605.59 $0.00 $9,280,669.69 $327,430.31 $1,142,737.22 Fri FnEli 4 -woolit-1 1,41 FrM11!Pr1!1q [11IL Adopted Budget Amended Current Month YTD Account Classification Budget Amendments Budget Transactions Encumbrances Fund 024 - Flood Control Construction Fund REVENUE Repott Through 11/30/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 27,507.07 .00 189,246.50 100,221.50 65 388,222.53 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 867.29 .00 11,445.40 (10,945.40) 2289 5,384.14 Reimbursements .00 .00 .00 .00 .00 .00 .00 ... 52,000.00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... 9,741,700.46 REVENUE TOTALS $289,968.00 $0.00 $289,968.00 $28,374.36 $0.00 $200,691.90 $89,276.10 69% $10,187,307.13 Fund 024- Flood Control Construction Fund Totals $289,968.00 $0.00 $289,968.00 $28,374.36 $0.00 $200,691.90 $89,276.10 $10,187,307.13 -_j �D- Account Classification Fund 040 - Refuse Disposal Fund REVENUE Property Taxes Charges For Services Fines & Forfeits Investment Income Reimbursements Other Revenue Revenue Budget by Account Classification Repoit Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTD 342,000.00 '00 342,000.00 4,061.89 .00 339,442.21 2,557.79 99 1,836,916.73 2,900,000.00 .00 2,900,000.00 199,176.60 ,00 2,579,022.59 320,977.41 89 1,917,262.44 25,000.00 .00 25,000.00 1,843.61 .00 25,218.15 (218.15) 101 17,266.26 500.00 .00 500.00 36.90 566.13 (66.13) 113 482.12 .00 ,00 00 147.48 M 884.88 (884.88) ... 867.54 359,000.00 .00 359,000.00 16,838.32 .00 321,766.05 37,233.95 90 329,467.36 REVENUE TOTALS $3,626,500.00 $0.00 $3,626,500.00 $222,104.80 $0.00 $3,266,900.01 $359,599.99 90% $4,102,262.45 Fund 040 - Refuse Disposal Fund Totals $3,626,500.00 $0.00 $3,626,500.00 $222,104.80 $0.00 $3,266,900.01 $359,599.99 $4,102,262.45 Fund 041 - Motor Fuel Tax Fund REVENUE Revenue Budget by Account Classification Report Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD 0/b used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD In er—gG7Lrrn —Men7Meven u e 1,290,000.00 .00 1,290,000.00 117,431.47 .00 1,575,118.36 (285,118.36) 122 1,332,061.47 Investment Income 100.00 .00 100.00 9.30 .00 44.68 55.32 45 103.91 Reimbursements 6,000.00 .00 6,000.00 813.20 .00 13,762.96 (7,762.96) 229 9,580.18 REVENUE TOTALS $1,296,100.00 $0.00 $1,296,100.00 $118,253.97 $0.00 $1,588,926.00 ($292,826.00) 123% $1,341,745.56 Fund 041 - or Fuel Tax Fund Totals $1,296,100.00 $0.00 $1,296,100.00 $118,253.97$0.00 $1,588,926.00 ($292,826.00) $1,341,745.56 %D Adopted Budget Amended Current Month YTD Account Classification Budget Amendments Budget Transactions Encumbrances Fund 042 - Cmmty Development Block Grant REVENUE Report Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Intergovernmental Revenue 293,202.00 97,171.00 390,373.00 .00 .00 52,998.37 337,374.63 14 154,849.07 Investment Income '00 .00 .00 .00 .00 X0 .00 +++ .00 Other Revenue 60,000.00 .00 60,000.00 52,182.50 .00 225,231.12 (165,231.12) 375 133,656.18 REVENUE TOTALS $353,202.00 $97,171.00 $450,373.00 $52,182.50 $0.00 $278,229.49 $172,143.51 62% $288,505.25 Fund 042 ® Cmmty Development Block Grant Totals $353,202.00 $97,171.00 $450,373.00 $52,182.50 $0.00 $278,229.49 $172,143.51 $288,505.25 Account Classification Fund 043 - Asset Seizure Fund REVENUE %It -Aevenue Budget by Account Classification Reportm Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTC Fines & Forfeits 2,000.00 .00 2,000.00 825.50 44,146.56 (42,146.56) 2207 16,457.30 Investment Income 100.00 .00 100.00 1.22 .00 13.61 86.39 14 17.05 REVENUE TOTALS $2,100.00 $0.00 $2,100.00 $826.72 $0.00 $44,160.17 ($42,060.17) 2103% $16,474.35 Fund 043 -Asset Seizure Fund Totals $2,100.00 $0.00 $2,100.00 $826.72 $0.00 $44,160.17 ($42,060.17) $16,474.35 F- N) INNER= 7!z',.evenue Budget by Account Classification Repoif"al Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 044 - DEA Shared Funds Fund REVENUE Fines & Forfeits 100.00 .00 100.00 '00 .00 24,637.80 (24,537.80) 24638 .00 Investment Income 100.00 '00 100.00 1.48 .00 18.20 81.80 18 8,93 REVENUE TOTALS $200.00 $0.00 $200.00 $1.48 $0.00 $24,656.00 ($24,456.00) 12328% $8.93 Fund 044 - DEA Shared Funds Fund Totals $200.00 $0.00 $200.00 $1.48 $0.00 $24,656.00 ($24,456.00) $8.93 Fund 045 - DUI Fine Fund REVENUE Fines & Forfeits Investment Income r LJ [-;`,�evenue Budget by Account Classification Report Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 20,000.00 .00 20,000.00 .00 .00 30,813.43 (10,813.43) 154 28,266.50 100.00 .00 100.00 2.10 -00 34.06 65.94 34 60.84 REVENUE TOTALS $20,100.00 $0.00 $20,100.00 $2.10 $0.00 $30,847.49 ($10,747.49) 153%® $28,327.34 Fund 045 - DUI Fine Fund Totals $20,100.00 $0.00 $20,100.00 $2.10 $0.00 $30,847.49 ($10,747.49) $28,327.34 F� Oh 212MMUM kevenue Budget by Account Classification Repc6- Through 11/30/14 P,nor Rscal Year Activity Indu Summary esting Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTD Fund 046 - Foreign Fire Tax Board Fund REVENUE Other Taxes 70,000.00 M 70,000.00 .00 .00 67,576.50 2,423.50 97 63,321.98 Investment Income 1,000.00 M 1,000.00 6.64 .00 96.78 903.22 10 214.00 Other Revenue M .00 .00 45.00 Other Financing Sources M X0 '00 M .00 M .00 +++ .00 REVENUE TOTALS $71,000.00 MOO $71,000.00 $6.64 $0.00 $67,673.28 $3,326.72 95% $63,580.98 Fund 046 - Foreign Fire Tax Board Fund Totals $71,000.00 $0.00 $71,000.00 $6.64 $0.00 $67,673.28 $3,326.72 $63,580.98 r Ul Revenue Budget by Account Classification Report Tru 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD a/m used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 047 - Justice Assistance Grant Fund REVENUE Intergovernmental Revenue .00 .00 ,00 .00 .00 .00 .00 +++ ,00 Investment Income .00 .00 .00 .00 .00 ,00 ,00 +++ 00 REVENUE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++ $0.00 Fund 047 - Justice Assistance Grant Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 r Ul rn Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances REVENUE , =7, Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Other Taxes 943,000.00 '00 943,000.00 91,441.87 .00 772,391.20 170,608.80 82 729,012.17 Investment Income 100.00 .00 100.00 3.93 .00 31.18 68.82 31 73.52 Other Financing Sources .00 -00 .00 .00 X0 .00 .00 +++ .00 REVENUE TOTALS $943,100.00 $0.00 $943,100.00 $91,445.80 $0.00 $772,422.38 $170,677.62 82% $729,085.69 Fund 048 - Business District Fund Totals $943,100.00 $0.00 $943,100.00 $91,445.80 $0.00 $772,422.38 $170,677.62 $729,085.69 Account Classification Fund 050 ® Water and Sewer Fund REVENUE 77;r�,evenue Budget by Account Classification Report Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Property Taxes 1,530,000.00 ,00 1,530,000.00 5,749.88 .00 1,503,416.20 26,583.80 98 1,500,162.25 Licenses, Permits & Fees 17,000.00 .00 17,000.00 1,200.00 .00 16,630.00 370.00 98 17,280.00 Charges For Services 12,711,000.00 .00 12,711,000.00 956,067.91 .00 10,825,363.54 1,885,636.46 85 10,501,910.59 Fines & Forfeits 100,000.00 ,00 100,000.00 10,373.04 .00 102,258.33 (2,258.33) 102 107,721.92 Investment Income 1,100.00 .00 1,100.00 108.50 .00 3,224.08 (2,124.08) 293 1,139.59 Reimbursements 1,000.00 .00 1,000.00 8,268.41 .00 8,137.41 (7,137.41) 814 9,572.52 Other Revenue 25,000.00 .00 25,000.00 8,052.24 .00 61,916.04 (36,916.04) 248 47,972.97 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $14,385,100.00 $0.00 $14,385,100.00 $989,819.98 $0.00 $12,520,945.60 $1,864,154,40 87% $12,185,759.84 Fund 050 -Water and Sewer Fund Totals $14,385,100.00 $0.00 $14,385,100.00 $989,819.98 $0.00 $12,520,945.60 51,864,154.40 $12,185,759.84 r MR. Account Classification kevenue Budget by Account Classification Report Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTC Fund 051 - Village Parking System Fund REVENUE Other Taxes 10,000.00 .00 10,000.00 950.26 .00 6,537.74 3,462.26 65 6,742.50 Charges For Services 115,000.00 .00 115,000.00 9,898.50 .00 118,779.22 (3,779.22) 103 110,511.05 Investment Income 100.00 .00 100.00 5,75 .00 83.17 16.83 83 326.99 Other Revenue 6,600.00 .00 6,600.00 .00 .00 5,500.00 1,100.00 83 6,050.00 Other Financing Sources .00 .00 .00 '00 .00 .00 .00 ... .00 REVENUE TOTALS $131,700.00 $0.00 $131,70000 $10,854.51 $0.00 $130,900.13 $799.87 99% $123,630.54 Fund 051 - Village Parking System Fund Totals $131,700.00 $0.00 $131,700.00 $10,854.51 $0.00 $130,900.13 $799.87 $123,630.54 Account Classification Fund 052 - Parking System Revenue Fund REVENUE lr;�evenue Budget by Account Classcation Report - Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget -YTD %used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Taxes 90,000.00 .00 90,000.00 8,552.36 .00 58,839.62 31,160.38 65 60,682.45 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 100 ... .00 Charges For Services 112,000.00 .00 112,000.00 9,785.35 .00 109,560.67 2,439.33 98 101,341.56 Investment Income 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 Other Revenue .00 .00 .00 .00 .00 .00 .00 ... .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $202,100.00 $0.00 $202,100.00 $18,337.71 $0.00 $168,400.29 $33,699.71 83% $162,024.01 Fund 052 - Parking System Revenue Fund Totals $202,100.00 $0.00 $202,100.00 $18,337.71 $0.00 $168,400.29 $33,699.71 $162,024.01 O Account Classification Fund 060 - Vehicle Maintenance Fum; REVENUE 7!,evenue Budget by Account Classification Reporr") Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Charges For Services 2,138,317.00 .00 2,138,317.00 178,193.07 .00 1,960,123.77 178,193.23 92 2,010,537.10 Investment Income .00 .00 .00 41.75 .00 514.12 (514.12) ... 457.66 Other Revenue .00 ,00 .00 .00 525.88 (525.88) +++ 138.40 REVENUE TOTALS $2,138,317.00 $0.00 $2,138,317.00 $178,234.82 $0.00 $1,961,163.77 $177,153.23 92% $2,011,133.16 Fund 060 - Vehicle Maintenance Fund Totals $2,138,317,00 $0.00 $2,138,317.00 $178,234.82 $0.00 $1,961,163.77 $177,153.23 $2,011,133.16 Account Classification Fund 061- Vehicle Replacement Fund REVENUE 1,1" 1 U47;IUM4#3Z, T-TMM;K*1 F -Mg maq 1#11 Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTC Charges For Services 1,346,300.00 .00 1,346,300.00 112,191.68 .00 1,234,108.48 112,191.52 92 1,280,216.74 Fines & Forfeits 10,000.00 .00 10,000.00 1,220.00 .00 12,797.72 (2,797.72) 128 11,763.44 Investment Income 5,000.00 .00 5,000.00 493.49 .00 6,327.62 (1,327.62) 127 7,087.17 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Financing Sources 60,000.00 .00 60,000.00 1,691.12 .00 77,176.12 (17,176.12) 129 98,584.12 REVENUE TOTALS $1,421,300.00 $0.00 $1,421,300.00 $115,596.29 $0.00 $1,330,409.94 $90,890.06 94% $1,397,651.47 Fund 061 - Vehicle Replacement Fund Totals $1,421,300.00 $0.00 $1f421,300.00 $115,596.29 $0.00 $1,330,409.94 $90,890.06 $1,397,651.47 K) Nj Fund 062 - Computer Replacement Fund REVENUE li 111171111 r�� I :Iipiiiliiiii� I 1 Adopted Budget Amended Current Month YTD Budget Amendments Buccet Transactions Encumbrances Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Charges For Services 23,088.00 r00 23,088.00 1,924.00 .00 21,164.00 1,924.00 92 00 Investment Income 1,000.00 '00 1,000.00 56.94 ,00 690.66 309.34 69 789.27 Other Financing Sources .00 .00 .130 '00 .00 .00 ,00 ... REVENUE TOTALS $24,088.00 $0.00 $24,088.00 $1,980.94 $0.00 $21,854.66 $2,233.34 91% $789.27 Fund 062 - Computer Replacement Fund Totals $24,088.00 $0.00 $24,088.00 $1,980.94 $0.00 $21,854.66 $2,233.34 $789.27 Account Classification Fund 063 ® Risk Management Fund REVENUE ;�evenue Budget by Account Classification Repor-1.1 Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTE Charges For Services 6,456,273.00 .00 6,456,273.00 535,755.14 .00 5,929,634.87 526,638.13 92 5,589,203.08 Investment Income 2,000.00 .00 2,000.00 170.54 .00 2,087.16 (87.16) 104 3,492.25 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 94,711.30 .00 1,200,162.19 157,437.81 88 1,196,599.70 REVENUE TOTALS $7,816,873.00 $0.00 $7,816,873.00 $630,636.98 $0.00 $7,131,884.22 $684,988.78 91% $6,789,295.03 Fund 063 - Risk Management Fund Totals $7,816,873.00 $0.00 $7,816,873.00 $630,636.98 $0.00 $7,131,884.22 $684,988.78 $6,789,295.03 Account Classification Fund 070 - Police Pension Fund REVENUE n venue oudget by Account Classification Reporli'i Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTC Charges For Services .00 .00 .00 .00 .00 .00 '00 +++ .00 Investment Income 3,415,900.00 .00 3,415,900.00 788,185.42 .00 3,986,884.90 (570,984.90) 117 6,266,878.78 Other Revenue 3,742,224.00 .00 3,742,224.00 66,114.35 .00 3,609,633.24 132,590.76 96 3,304,369.05 REVENUE TOTALS $7,158,124.00 $0.00 $7,158,124.00 $854,299.77 $0.00 $7,596,518.14 ($438,394.14) 106% $9,571,247.83 Fund 070 - Police Pension Fund Totals $7,158,124.00 $0.00 $7,158,124.00 $854,299.77 $0.00 $7,596,518.14 1%9435,394.1-4, $9,571,247.83 N Ln Account Classification Fund 071 - Fire Pension Fund REVENUE Investment Income Other Revenue Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTE 3,165,200.00 .00 3,165,200.00 99,008.02 .00 2,608,325.27 556,874.73 82 4,986,447.02 3,079,042.00 .00 3,079,042.00 52,851.96 .00 2,973,603.40 105,438.60 97 2,862,419.81 REVENUE TOTALS tfi,244,242.00 $0.00 $6,244,242.00 $151,859.98 $0.00 $5,581,928.67 $662,313.33 89% $7,848,866.83 Fund 071 - Fire Pension Fund Totals 66,244,24100 $0.00 $6,244,242.00 $151,859.98 $0.00 $5,581,928.67 $662,313.33 $7,848,866.83 Grand Totals $108,812,217.00 $9-7,171.00 $15-8,909,388.00 $6,281,043.55 $0.00 $96,798,595.84 $12,110,792.16 $99,617,449.01 Account Classification Fund 001- General Fund EXPENSE Expense Budget by Account Classification 1,786,431.10 .00 20,967,245.61 Repoit 88 20,302,220.64 Employee Benefits Through 11/30/14 .00 12,344,314.00 Prior Fiscal Year Activity Included .00 11,742,854.25 601,459.75 Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 23,919,744.00 .00 23,919,744.00 1,786,431.10 .00 20,967,245.61 2,952,498.39 88 20,302,220.64 Employee Benefits 12,344,314.00 .00 12,344,314.00 521,056.72 .00 11,742,854.25 601,459.75 95 10,947,301.20 Other Employee Costs 415,005.00 (5,675.00) 409,330.00 19,800.40 7,373.00 276,956.65 125,000.35 69 244,958.51 Pension Benefits 46,301.00 .00 46,301.00 3,858.36 .00 42,441.96 3,859.04 92 42,303.91 Contractual Services 7,001,321.00 143,785.68 7,145,106.68 513,406.29 243,099.73 6,408,746.64 493,260.31 93 6,317,675.57 Utilities 262,282.00 '00 262,282.00 18,035.35 .00 157,794.90 104,487.10 60 130,668.23 Insurance 350,519.00 .00 350,519.00 29,210.63 .00 321,318.52 29,200.48 92 316,388.12 Commodities & Supplies 627,855.00 61,600.00 689,455.00 55,625.72 9,458.76 513,869.21 166,127.03 76 432,195.47 Other Expenditures 11,080.00 .00 11,080.00 32,502.72 .00 113,047.44 (101,967.44) 1020 6,937.67 Building Improvements 10,000.00 .00 10,000.00 4,368.86 410.00 7,376.54 2,213.46 78 9,761.57 Office Equipment 49,730.00 .00 49,730.00 7,105.68 689.99 26,182.11 22,857.90 54 12,325.09 Other Equipment 165,123.00 8,637.32 173,760.32 24,516.71 14,368.35 134,266.57 25,125.40 86 61,636.35 Distribution Systems 100,000.00 .00 100,000.00 .00 22,221.22 49,227.30 28,551.48 71 33,936.30 Infrastructure 510,792.00 (6,700,00) 504,092.00 22,339.25 111,998.20 346,259.78 45,834.02 91 387,259.84 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $45,814,066.00 $201,648.00 $46,015,714.00 $3,038,257,79 5409,619,25 $41,107,587.48 84,498,507.27 90% $39,245,568.47 Fund 001 - General Fund Totals $45,814,066.00 $201,648.00 $46,015,714.00 $3,038,257.79 $409,619.25 54-1j07'587.48 $4,498,507,27 $39,245,568.47 F- 3E Account Classification Fund 002 ® Debt Service Fund EXPENSE Contractual Services Other Expenditures Bond Principal Interest Expense Bank & Fiscal Fees Interfund Transfers Other Financing Uses TICK III t � Liu -9 1910;14, it] I I Repo Through 11/30/1 Prior Fiscal Year Activity Includ Summary Listi Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD .00 .00 .00 ,00 .00 .00 .00 ... .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 1,532,587.00 315,000.00 1,847,587.00 36,518.41 .00 307,298.90 1,540,288.10 17 1,405,278.45 1,793,429.00 (315,000.00) 1,478,429.00 3,857,88 .00 770,158.62 708,270.38 52 890,682.58 2,484.00 .00 2,484.00 .00 .00 1,686.20 797.80 68 428.00 .00 .00 .00 .00 .00 .00 .00 ... .00 .00 .00 .00 .00 .00 .00 .00 ... '00 EXPENSE TOTALS $3,328,500.00 $0.00 $3,328,500.00 $40,376.29 $0.00 $1,079,143.72 $2,249,356.28 32% $2,296,389.03 Fund 002 ® Debt Service Fund Totals $3,328,500.00 $0.00 $3,328,500.00 $40,376.29 $0.00 $1,079,143.72 $2,249,356.28 $2,296,389.03 Fund 020 - Capital Improvement EXPENSE -xpense Budget by Account Classification Repoit Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Con-Lructua -i.-,)ervi ces .00 .00 .00 .00 .00 .00 .00 +++ 22,132.60 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Land Improvements 240,000.00 .00 240,000.00 .00 91,139.86 .00 148,860.14 38 .00 Building Improvements 637,000.00 83,800,00 720,800.00 4,842.70 58,338.72 345,275.40 317,185.88 56 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 14,081.79 33r000.00 207,710.54 80,136.46 75 324,970.71 Infrastructure 515,000.00 94,200.00 609,200.00 42,199.66 111,092.76 70,895.89 427,211.35 30 278,701.43 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... ,00 EXPENSE TOTALS $1,696,247.00 $194,600.00 $1,890,847.00 S61,124-15 $293,571.34 5623,881.83 $973,.393,83 49% $1,350,235.17 Fund 020 - Capital Improvement Fund Totals $1,696,247.00 $194,600.00 $1,890,847.00 $61,124.15 $293,571.34 $623,881.83 $973,393.83 $1,350,235.17 w A. Account Classification Fund 021 - Series 2009 Construction Fund EXPENSE k A '41" t4i" Repo Through 11/30/1 (1 Prior Fiscal Year Activity Includ 4 Summary Listin, 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 ++t .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 Constructs®n Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $36,865.05 Expense Budget by Account Classification Repoit Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD rung Uzz - Downtown Redevelopment Construct - EXPENSE Contractual Services 203,040.00 .00 203,040.00 6,192.88 25,603.39 180,196.24 (2,759.63) 101 165,088.64 Utilities .00 .00 .00 .00 .00 A0 .00 ... .00 Other Expenditures 2,803,922.00 60,000.00 2,863,922.00 .00 .00 109,241,63 2,754,680.37 4 77,138.41 Infrastructure 115,000.00 240,000.00 355,000.00 .00 3,675.00 16,775,75 334,549.25 6 21,670.31 Bond Principal .00 .00 .00 .00 .00 .00 .00 ... .00 Interest Expense .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 $6,192.88 $29,278.39 $306,213.62 $3,086,469.99 10% $263,897.36 Fund 022 -Downtown Redevelopment Construct Totals $3,121,962.00 $300,000.00 $3,421,962.00$6,192.88 $29,278.39 $306,213.62 $3,086,469.99 $263,897.36 Ln 0) Account Classification Fund 023 - Street Improvement Construc Fund EXPENSE -xpense Budget by Account Classification Repona, Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services 30,600.00 41,000.00 71,600.00 40,764.74 24,006.27 88,056.29 (40,462.56) 157 26,337.78 Infrastructure 9,943,280.00 .00 9,943,280.00 89,207.09 1,797,913.08 7,424,127.21 721,239.71 93 616,223.44 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $9,973,880.00 $41,000.00 $10,014,880.00 $129,971.83 $1,821,919.35 $7,512,183.50 $680,777.15 93% $642,561.22 Fund 023 - Street Improvement Construc Fund Totals $9,973,880.00 $41,000.00 $10,014,880.00 $129,971.83 $1,821,919.35 $7,512,183.50 $680,777.15 $642,561.22 • so= F.xpense Budget by Account Classification Repor-s Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD run® U24 -Flood Control Construction Fund - - EXPENSE Contractual Services .00 .00 .00 .00 .00 .00 .00 +++ .00 Utilities Ir000.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 2,556.00 52,921.64 499,324.37 10,336,553.99 5 1,573,632.55 EXPENSE TOTALS $10,811,000.00 $83r800.00 $10,894,800.00 $2,556.00 $52,921.64 $500,240.24 S10f341,638,12 5% $1,575,632.55 Fund 024 - Flood Control Construction Fund Totals $10,811,000.00 $83,800.00 $10,894,800.00 $2,556.00 $52,921.64 $500,240.24 $10,341,638.12 $1,575,632.55 1j EE Account Classification Fund 040 ®Refuse Disposal Fund EXPENSE N Repor, Through 11/30/1 Prior Fiscal l Year Activity Includev. Summary Ustin , Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 231,735.00 .00 231,735.00 18,875.10 '00 218,420.82 13,314.18 94 166,745.67 Employee Benefits 75,057.00 .00 75,057.00 8,615.42 .00 97,815.86 (22,758.86) 130 86,575.44 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 322,734.95 12,412.15 3,584,354.27 555,517.58 87 3,518,035.95 Utilities 438.00 .00 438.00 17.95 .00 244.93 193.07 56 249.71 Insurance 28,640.00 -00 28,64C.00 2,386.67 .00 26,253.37 2,386.63 92 25,885.75 Commodities & Supplies 31,295.00 5,600.00 36,895.00 7,724.16 .00 36,289.84 605.16 98 24,269.09 EXPENSE TOTALS $4,526,273.00 $0.00 $4,526,273.00 $360,354.25 $12,412.15 $3,964,603.09 $549,257.76 88% $3,822,961.61 Fund 040 - Refuse Disposal Fund Totals $4,526,273.00 $0.00 $4,526,273.00 $360,354.25 $12,412.15 $3,964,603.09 $549,257.76 $3,822,961.61 Account Classification Fund 041- Motor Fuel Tax Fund EXPENSE 11�1111 i v . Repoit Through 11/30/14 Prior Fiscal Year Activity Included Summary a 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 17,492.56 25,203.93 220,069.61 33,830.46 88 167,120.84 Utilities 153,000.00 .00 153,000.00 2,735.01 .00 153,156.83 (156.83) 100 149,896.61 Commodities & Supplies 284,796.00 97,000.00 381,796.00 16,054.87 8,729.52 273,965.47 99,101.01 74 147,195.10 Building Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 Infrastructure 910,000.00 (92,000.00) 818,000.00 .00 .00 10,056.62 807,943.38 1 1,115,000.00 EXPENSE TOTALS $1,551,900.00 $80,000.00 $1,631,900.00 $36,282.44 $33,933.45 $657,248.53 $940,718.02 42% $1,579,212.55 Fund 041 - Motor Fuel Tax Fund Totals $1,551,900.00 $80,000.00 $1,631,900.00 $36,282.44 $33,933.45 $657,248.53 $940,718,02 $1,579,212.55 kD Repo Through 11/30/1 (I Prior Fiscal Year Activity Includ 11 Summary Listi ," Adopted Budget Amended Current Month YT -D YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 042 - Cmmty Development Block Grant EXPENSE Personal Services, Scheduled Salaries & Wages 47,930.00 '00 47,930.00 3,279.14 .00 41,620.81 6,309.19 87 40,355.36 Employee Benefits 26,222.00 '00 26,222.00 2,073.39 .00 23,385.87 2,836.13 89 22,417.24 Other Employee Costs 1,020.00 ,00 1,020.00 .00 .00 178.32 841.68 17 745.50 Contractual Services 97,520.00 23,250.00 120,770.00 (522.89) .00 95,608.52 25,161.48 79 42,218.01 Commodities & Supplies 510.00 .00 510.00 .00 .00 .00 510.00 0 111.37 Other Expenditures 160,000.00 73,921.00 233,921.00 .00 .00 43,064.00 190,857.00 18 136,517.56 Land Improvements .00 00 .00 .00 .00 .00 .00 ... .00 Building Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 Infrastructure 20,000.00 ,00 20,000.00 51,092.00 18,908.00 51,092.00 (50,000.00) 350 37,500.00 EXPENSE TOTALS $353,202.00 $97,171.00 $450,373.00 $55,921.64 $18,908.00 $254,949.52 $176,515.48 61% $279,865.04 Fund 042 - Cmmty Development Block Grant Totals $353,202.00 $97,171.00 $450,373.00 $55,921.64 $18,908.00 $254,949.52 $176,515.48 $279,865.04 r r Expense Budget by Account Classification Report Throe 11/30/14 Prior Fiscal Year Activity Include Summary Listing Adopted Budget Amended Current Month YT -D YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Ree°d Prior Year YTD Fund 043 ®Asset Seizure Fund EXPENSE Other Employee Costs 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Contractual Services 3,000.00 .00 3,000.00 2,000.00 .00 6,000.00 (3,000.00) 200 4,000.00 Other Equipment 15,000.00 .00 15,000.00 .00 .00 1,859.57 13,140.43 12 9,385.75 EXPENSE TOTALS $19,000.00 $0.00 $19,000.00 $2,000.00 $0.00 $7,859.57 $11,140.43 41% $13,385.75 Fund 043 ® Asset seizure Fund Totals $19,000.00 $0.00 $19,000.00 $2,000.00 $0.00 $7,859.57 $11,140.43 $13,385.75 r r I - N3 Account Classification Fund 044 - DEA Shared Funds Fund EXPENSE P "11111 Repor' ' Through 11/30/1 11 Prior Fiscal Year Activity Includ Summary Listim, 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 Interl'und Transfers xpense Budget by Account Classification Repor--*L- Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year 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 18,064.33 .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS SMG00.00 $0.00 $11,000.00 $0.00 $0.00 $2,767.30 $8,232.70 25% $25,251.83 Fund 045 - DUI Fine Fund Totals $11,000.00 $0.00 $11,000.00 $0.00 $0.00 $2,767.30 $8,232.70 $25,251.83 MEMO= M" -xpense Budget by Account Classification R Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 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,143.29 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 A0 15,000.00 .00 17,565.00 15,948.60 (18,513.60) 223 11,327.00 EXPENSE TOTALS $30,500.00 $0.00 $30,500.00 $0.00 $20,250.00 $20,127.52 ($9,877.52) 132% $17,503.27 Fund 046 - Foreign Fire Tax Board Fund Totals $30,500.00 $0.00 $30,500.00 $0.00 $20,250.00 $20,127.52 ($9,877.52) $17,503.27 Account Classification Fund 047 - Justice Assistance Grant Fund EXPENSE IIIIIII&A 5 1 1 F. ; I M - I t T-40(all Mi 161 F77 -T-11 il I F 1 -1 F a I s RepEwl Through 11/30/ Prior Fiscal Year Activity Includ Summary l Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YFD ommo6ltles upp les .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 $0.00 $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 LIP! r ON Fund 048 - Business District Fund EXPENSE 1111�111q 11,11111 11111111lilillilli K-1 Fmnlll� AU"I Repo Through 11/30/ Prior Fiscal Year Activity Includ Summary Listi F Adopted Budget Amended Current Month YTD YTD Budget - YTD 0/b used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Bond Principal .00 �00 '00 .00 '00 .00 .00 +++ .00 Interest Expense 923,100.00 .00 923,100.00 ,00 -00 .00 923,100.00 0 637,231.78 EXPENSE TOTALS $923,100.00 $0.00 $923,100.00 $0.00 $0.00 $0.00 $923,100.00 0% $637,231.78 Fund 048 - Business District Fund Totals $923,100.00 $0.00 $923,100.00 $0.00 $0.00 $0.00 $923,100.00 $637,231.78 Account Classification Fund 050 - Water and Sewer Fund EXPENSE 12V'01:4irmiMe- a .110101#11 M1141 =-IRF141#11 Repo Through 11/30/1 (I Prior Fiscal Year Activity Includ 11 Summary Listini Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 1,952,664.00 .00 1,952,664.00 134,003.51 .00 1,756,352.25 196,311.75 90 1,673,278.63 Employee Benefits 787,893.00 .00 787,893.00 55,483.39 .00 686,230.80 101,662.20 87 691,682.33 Other Employee Costs 36,660.00 .00 36,660.00 141.00 172.50 28,962.74 7,524.76 79 22,780.96 Contractual Services 7,457,412.00 32,500.00 7,489,912.00 617,444.77 215,691.36 6,744,385.01 529,835.63 93 6,153,636.72 Utilities 157,758.00 .00 157,758.00 11,175.18 .00 108,548.04 49,209.96 69 97,274.01 Insurance 80,474.00 .00 80,474.00 6,706.16 .00 73,767.76 6,706.24 92 72,767.75 Commodities & Supplies 295,722.00 .00 295,722.00 4,285.83 32,816.37 144,081.64 118,823.99 60 170,365.03 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 235,809.69 1,193,400.23 1,326,881.45 287,418.32 90 118,450.72 Distribution Systems 2,075,000.00 581,500.00 2,656,500.00 607,152.08 1,238,631.73 924,898.64 492,969.63 81 917,964.78 Infrastructure .00 .00 .00 .00 .00 .00 .00 +++ .00 Bond Principal .00 .00 .00 .00 .00 .00 .00 ... .00 Interest Expense .00 .00 .00 .00 .00 .00 .00 ... .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $14,131,653.00 $2,177,500.00 $16,309,153.00 $1,672,201.61 $2,684,637.19 $11,795,458.33 $1,829,057.48 89% $9,918,200.93 Fund 050 - Water and Sewer Fund Totals $14,131,653.00 $2,177,500.00 $16,309,153.00 $1,672,201.61 $2,684,637.19 $11,795,458.33 $1,829,057.48 $9,918,200.93 Account Classification Fund 051 - Village Parking System Fund EXPENSE Repo Through 11/30/1 11 Prior Fiscal Year Activity Includ Summary Listi Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 35,788.00 -00 35,788.00 2,495.65 .00 32,156.17 3,631.83 90 22,913.78 Employee Benefits 17,796.00 00 17,796.00 1,289.26 .00 14,664.00 3,132.00 82 9,877.18 Contractual Services 91,055-00 .00 91,055.00 4,323.24 331.85 66,694.14 24,029.01 74 75,397.66 Insurance 1,175.00 -00 1,175.00 97.92 .00 1,077.12 97.88 92 1,061.50 Commodities & Supplies 510.00 .00 510.00 .010 .00 499.35 10.65 98 .00 Other Expenditures .00 '00 .00 .00 .00 .00 ... .00 Building Improvements 6,936.00 .100 6,936.00 .00 647.33 2,103.47 4,185.20 40 2,750.80 Infrastructure 153,500.00 A0 153,500.00 ,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 $8,206.07 $11,606.85 $153,315.78 $141,837.37 54% $161,125.12 Fund 051 - Village Parking System Fund Totals $306,760.00 $0.00 $306,76C.00 $8,206.07 $11,606.85 $153,315.78 $141,837.37 $161,125.12 q Report Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 052 - Parking System Revenue Fund EXPENSE Personal Services, Scheduled Salaries & Wages 28,598.00 .00 28,598.00 1,835.89 .00 23,452.34 5,145.66 82 32,391.15 Employee Benefits 13,772.00 .00 13,772.00 956.00 .00 10,869.40 2,902.60 79 15,875.78 Contractual Services 110,954.00 .00 110,954.00 13,513.01 280.85 89,033.56 21,639.59 80 96,849.22 Utilities 10,523.00 .00 10,523.00 301.38 .00 5,718.16 4,804.84 54 5,976.93 Insurance 1,406.00 .00 1,406.00 117.17 .00 1,288.87 117.13 92 1,271.38 Commodities & Supplies 9,779.00 .00 9,779.00 .00 1,345.00 6,309.76 2,124.24 78 3,647.72 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 .010 .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 $16,723.45 $1,625.85 $136,672.09 $111,734.06 55% $156,012.18 Fund 052 - Parking System Revenue Fund Totals $250,032,00 $0.00 $250,032.00 $16,723.45 $1,625.85 $136,672.09 $111,734.06 $156,012.18 O Account Classification Fund 060 - Vehicle Maintenance Fund EXPENSE Personal Services, Scheduled Salaries & Wages Employee Benefits Other Employee Costs Contractual Services Utilities Commodities & Supplies Other Expenditures Office Equipment Other Equipment Expense Budget by Account Classification Repoit Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 940,529.00 .00 940,529000 65,498.24 .00 833,757.40 106,771.60 89 796,814.51 384,627.00 .00 384,627.00 29,924.73 .00 326,689.29 57,937.71 85 362,569.27 2,361.00 .00 2,361.00 127.72 .00 2,359.00 2.00 100 2,275.59 100,738.00 .00 100,738.00 4,240.59 11,619.42 64,719.85 24,398.73 76 64,947.67 3,070.00 .00 3,07100 44.87 .00 2,016.85 1,053.15 66 2,675.55 701,081.00 .00 701,081.00 42,902.74 117,212.54 589,420.46 (5,552.00) 101 537,573.13 .00 .00 .00 .00 .00 .00 .00 ... .00 556.00 .00 556.00 .00 .00 267.80 288.20 48 195.65 19,770,00 .00 19,770000 1,244.46 .00 17,603.63 2,166.37 89 16,828.84 EXPENSE TOTALS $2,152,732.00 $0.00 $2,152,732.00 $143,983.35 $128,831.96 $1,836,834.28 $187,065.76 91% $1,783,880.21 Fund 060 - Vehicle Maintenance Fund Totals $2,152,732.00 $0.00 $2,152,732.00 $143,983.35 $128,831.96 $1,836,834.28 $187,065.76 $1,783,880.21 Account Classification '1- 111111 ;E41F,=grMq14j11 liq �::q� 1111111111 111, a=, I Repoit Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD 0% used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD tuna U51 - 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 120,593.41 19,899.59 1,099,578.57 658,221.84 63 483,444.58 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $1,614,000.00 $163,700.00 $1,777,700.00 $120,593.41 $19,899.59 $1,099,578.57 $658,221.84 63% $483,444.58 Fund 061 - Vehicle Replacement Fund Totals $1,614,000.00 $163,700.00 $1,777,700.00 $120,593.41 $19,899.59 $1,099,578.57 $658,221.84 $483,444.58 Account Classification Fund 062 - Computer Replacement Fund EXPENSE III IIIIIIIIIII 1,111111111qr-111 1111liq iq�piii li"i"I"7171 Repo Through 11/30/1�11, Prior Fiscal Year ActiviM, Includ"Z Summary Ustinv Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Expenditures .00 .00 .00 .00 .00 .00 .00 +t+ -00 Office Equipment 247,480.00 .00 247,480.00 .00 .00 140,812.99 106,667.01 57 221,786.72 EXPENSE TOTALS $247,480.00 $0.00 $247,480.00 $0.00 $0.00 $140,812.99 $106,667.01 57% $221,786.72 Fund 062 - Computer Replacement Fund Totals $247,480.00 $0.00 $247,480.00 $0.00 soioa $140,812.099 $1-06,667.01 $221,786.72 Fund 063 - Risk Management Fund EXPENSE xpense Budget by Account Classification Repor-m Through 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD on ractual Services 27,000.00 .00 27,000.00 .00 7,000.00 10,300.00 9,700.00 64 10,950.00 Insurance 7,812,938.00 .00 7,812,938.00 599,54110 .00 7,873,754.18 (60,816.18) 101 6,941,742.90 Other Equipment 5,000.00 .00 5,000.00 .00 .00 58.25 4,941.75 1 2,140.90 Infrastructure .00 .00 .00 �00 .00 .00 .00 ... .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $7,844,938.00 $0.00 $7,844,938,00 $599,542.10 $7,000.00 $7,884,112.43 ($46,174.43) 101% $6,954,833.80 Fund 063 - Risk Management Fund Totals $7,844,938.00 $0.00 $7,844,938.00 $599,542.10 $7,000.00 $7,884,112.43 ($46,174.43) $6,954,833.80 Account Classification Fund 070 - Police Pension Fund EXPENSE Repo Through 11/30/1 f Prior Fiscal Year Activity Includ Summary Listi�li Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Pec'd Prior Year YTD Pension Benefits 3,937,366.00 .00 3,937,366.00 357,104.77 .00 3,754,263.45 183,102.55 95 3,505,778.60 Contractual Services 135,350.00 .00 135,350.00 15,877.98 '00 109,139.96 26,210.04 81 92,505.95 Insurance 15,000.00 .00 15,000.00 .00 .00 11,960.00 3,040.00 80 11,500.00 Commodities & Supplies 100.00 .00 10C.00 .00 .00 .00 100.00 0 .00 Other Expenditures 12,000,00 .00 12,00G.00 .00 .00 8,702.84 3,297.16 73 10,635.15 Office Equipment .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $4,099,816.00 $0.00 $4,099,816.00 $372,982.75 $0.00 $3,884,066.25 $215,749.75 95% $3,620,419.70 Fund 070 - Police Pension Fund Totals $4,099,816.00 $0.00 $4,099,816.00 $372,982.75 $0.00 $3,884,066.25 $215,749.75 $3,620,419.70 f. i Account Classification Fund 071 ® Fire Pension Fund EXPENSE Pension Benefits Contractual Services Insurance Commodities & Supplies Other Expenditures Expense Budget byAccount Re po1 it 11/30/14 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget °/a used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD 4,021,161.00 .00 4,021,161.00 348,120.05 .00 3,797,908.68 223,252.32 94 3,566,762.98 124,600.00 .00 124,600.00 17,185.51 .00 104,916.54 19,683.46 84 90,302.76 15,000.00 .00 15,000.00 .00 .00 13,100.00 1,900.00 87 12,600.00 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 230.29 12,000.00 .00 12,000.00 .00 .00 8,450.00 3,550.00 70 9,562.93 EXPENSE TOTALS $4,173,761.00 $0.00 $4,173,761.00 $365,305.56 $0.00 53,924,375.22 5249,38538 94% $3,679,458.96 Fund 071 - Fire Pension Fund Totals $4,173,761.00 $0.00 $4,173,761.00 $365,305.56 $0.00 $3,924,375.22 $249,385.78 $3,679,458.96 Grand Totals 5116,983,802.00 3,339,419.00 $120,323,221.00 57,032,575.57 S5,546,415.01 $86,892,031.86 $27,884,774.1.3 578,767,052.20 Fund Vendor Name 001 General Fund Aamstrand Ropes & Twines Inc. ACS State & Local Government Solutions Aetna Inc Air One Equipment, Inc. Airgas, Inc. Amer Reprographics Co Llc American Planning Association Anderson Lock Company Anderson Pest Solutions Andres Medical Billing, Ltd. Anton/Renate Schoenauer Family Trust Apostrophe Design, Inc. Aramark Uniform Services, Inc. ASCE Aspen, Kurt AT&T Avanti Cafe & Sandwich Bar, Inc. B & H Photo/video Baldini, Carol Bedco Mechanical Besse Medical Supply Blue Cross Blue Shield of Illinois Busse's Flowers & Gifts Capital One National Association Case Lots, Inc. CDW Government, Inc. Central Continental Bakery Century Cleaners Channing Bete Company, Inc. Chem -wise Ecological Pest Mgmt Inc Constellation NewEnergy, Inc. Costar Realty Information, Inc. Crystal Court Shopping Center Crystal Maintenance Services Corp. CVS Pharmacy, Inc. D.J.'s Scuba Locker VILLAGE OF MOUNT PROSPECT List of Bills November 27 - December 10, 2014 Invoice Des Grounds Maintenance Supplies Illinois State Disbursement Unit Refund for Ambulance Services - 10/1/13 Air Quality Tests and Compressor Maintenance for 2014 Oxygen Supplies Equipment Maintenance 2015 APA membership -Bill Cooney 2015 APA membership -Brian Simmons Maintenance and repair supplies Wasp Nest at 1802 Beech Professional Services Ambulance Billing - November 2014 Refund Building Fee Permit #14-2328 Equipment Maintenance and Repair Uniform rental and cleaning for Public works employees Uniform rental and cleaning for Public works employees Office Supplies Safety Shoe Allowance Service 11/16/14 - 12/15/14 Employee Recognition - Awards Display Mount for Battalion 3 Reimbursement for items from Therapy Shoppe Services to Police/Fire second floor computer room AC Hot water combustion test at Public Works Cholesterol Supplies Refund for Ambulance Services Refund for Ambulance Services - 9/27/12 Sympathy Arrangement Get Well Arrangement Funeral Flowers 11/23/14 Munoz Sympathy Costco Purchased 10/29/14 - 11/24/14 Custodial Supplies Microsoft Office 2013 Pro Power BI for CD/IT Maintenance and repair supplies Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Educational information brochures Equipment Maintenance and Repair Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery ED Program January 2015 rent for the CCC Janitorial services for 8 buildings for the month of December Prisoner medication ERD Prep Swat 9-3-14 Page 1 of 9 Amount 765.10 4,645.52 230.79 135.00 369.48 62.00 755.00 638.00 277.10 75.00 48.00 5,661.97 50.00 1,900.00 99.35 99.35 24.00 63.98 341.79 459.00 149.99 37.42 749.10 287.50 381.43 77.47 366.32 135.00 80.00 85.00 85.00 907.80 255.00 661.94 32.40 12.30 18.68 14.13 25.03 14.58 8.65 28.70 405.04 215.00 62.76 939.71 106.84 99.28 123.97 34.37 113.53 35.18 110.75 236.78 518.75 5,839.97 7,181.81 61.41 253.00 Fund VILLAGE OF MOUNT PROSPECT List of Bills November 27 - December 10, 2014 Vendor Name Invoice Description Amount D.J.'s Scuba Locker ERD 1 Diver Swat 9-9,9-11.9-12 370.00 Dow Jones & Co., Inc. Wall Street Journal Subscription 113.75 Elite Remodeling Group, Inc. Garnishment 142.22 Elk Grove Township Fire Dept. ARC Annexation Agreement 2014 44,841.60 Emergency Medical Products AED Pads, Thermometers, Thermometer Covers 297.18 Monitor pads, cavicide 1,371.42 Environmental Monitoring and Technologies, Inc. Sewer/Basin Maintenance 1,544.00 Eterno, David G. November billing 600.00 Eurich, Julie K 2014 Property Tax Relief Grant 100.00 Father and Sons Plumbing and Sewer Refund Street Opening Fee Permit #14-2128 100.00 Federal Express Corp Federal Express Postage 10/30/14 20.11 Subpoena Response 18.42 Fire Pension Fund 410 - Fire Pension 30,393.71 Flavin, Patrick J. 2014 Fire Uniform Allowance 61.45 Fleck's Landscaping Grounds Maintenance 2,506.00 Grounds Maintenance 50.00 Flink Company Salt Spreader Parts 418.76 Flory, James M Computer cables for stations 12&14 59.66 Fulton Technologies, Inc. 2014 Maintenance for Disaster Warning System 2,214.32 Gabriel Healthcare Supply Maintenance of lending closet equipment 391.00 Garvey's Office Products Office Supplies 89.28 Giannopoulls, Effie Refund for Ambulance Services - 9/15/14 77.47 Guardian Emp. Dental December 2014 9,043.59 Hatgenbush, John Rebate Sidewalk Shared Program 375.00 HD Supply Waterworks, Ltd. Other Equipment (166.32) Small Tools 826.32 Heinking, Jill Reimbursement for client supplies 11.99 Home Depot U.S.A., Inc. Home Depot Statement 145.09 Homer Tree Care, Inc. Tree Removals 2,675.80 Tree Removals 2,840.30 Tree Removals 4,908.10 Huffman, William W. Fall 2014 Parkway Tree Planting 200.00 Fall 2014 Parkway Tree Planting 55,912.25 Hull, David Other Employee Expenses 17.38 Humana Health Care Plans Refund for Ambulance Services - 8/5/14 463.41 IACE Scherbaum Membership 25.00 ICMA 2015 membership dues 1,156.00 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 21,446.67 Illinois American Water Company Private Fire Service 12/2/14 - 12/31/14 33.84 Illinois Assn. of Chiefs of Police 2015 membership renewal: M. Eterno 95.00 2015 membership: T. Griffin 95.00 2015 Membership renewal: T. Janowick 220.00 2015 Membership renewal: M. McGuffin 95.00 2015 Membership: R. Smith 95.00 2015 Membership: E. Szmergalski 95.00 2015 Membership: D. Zboril 95.00 Illinois Department of Revenue IL State Withholding 71.56 IL State Withholding 44,886.46 Illinois Dept.of Agriculture Professional Services 200.00 Ingebrigtsen, James 2014 Fire Uniform Allowance 124.99 Institute of Transportation Eng. Membership Dues 280.00 Internal Revenue Service Federal Withholding 426.81 Federal Withholding 464.70 Federal Withholding 219,022.61 International Union of Operating Engineers IUOE PW Membership Dues 959.25 ISA Professional Services 200.00 J.F. New & Associates, Inc. Sewer and Basin Maintenance 1,740.00 Kane, Julie K Reimbursement for webinar clinical documentation 85.00 Kearney, Ryan Travel and Meeting Expenses 55.00 Kerstein, June Reimbursement Food Expense - 11/6/14 19.46 Kinnucan Holiday Decorations 17,497.76 Klein, Thorpe and Jenkins, Ltd. October billing 29,585.23 Kleinstein, Howard Howard Kleinstein Reimbursements 554.71 Kowalczyk, Michele Cake for Lt. Ghawaly Promotion 38.99 Kramer Tree Specialists Parkway Stump Removals 58,357.80 Page 2 of 9 Fund Vendor Name Laner Muchin Lee n' Eddies LLC Meade Electric Co. Inc. Melissa Finn Mema, Ferdinant Menards Metro Door and Dock, Inc. Metro Federal Credit Union Metropolitan Alliance - Police Michael Wagner & Sons, Inc. Midwest Medical Supply Company, LLC Morton Grove Automotive Moser, Cynthia Mount Prospect Paint, Inc. Municipal Emergency Services, Inc. Nationwide Mutual Insurance Company NCPERS Group Life Ins. Neopost USA Inc. NFPA NGS Medicare Illinois NICOR Northeastern III. Pub. Safety Trng, Northwest Central Dispatch System Northwest Municipal Conference Northwest Suburban United Way Novak & Parker Inc. Novak, Todd Pacific Telemanagement Services Paddock Publications, Inc. Peterson Roofing Petty Cash Police Pension Fund Randant, Gary Real Graphix, Inc. Red Wing Shoe Store Rittle, John Seleen, Wendy Signs By Tomorrow Slobe, Steve Snap On Industrial Div of IDSC Holdings Inc. Sound Incorporated State of Illinois Symbolarts, LLC. Teevan, Allison Thanopoulos, Marianthi Tharp, Brian J VILLAGE OF MOUNT PROSPECT List of Bills November 27 - December 10, 2014 Invoice Des November billing Maintenance and Custodial Supplies Traffic Light Maintenance Celestial Celebration Refund Overpayment Police Ticket #C62570 Lumber for SCBA confidence course Lumber for SCBA confidence course Electrical testers, utility knife blades, electrical tape Overhead door repair Overhead door repair MP Fire Local 4119 Dues MP Police Association Dues Maintenance and repair supplies Maintenance and repair supplies Maintenance and repair supplies Cot mattresses, caviside Leaf Machine Parts Transfer Stamp Rebate Maintenance and repair supplies Patches -Investigator (2) POC Clothing Equipment-RSX Coat and Pant Turnout Gear -Coats and Patches Nationwide 457 (flat percent) IMRF Life Insurance Postage Machine Replenishment - 12/02/14 Neopost Annual Fee Postage Machine Replenishment Reference Materials Refund for Ambulance Services - 9/18/14 Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Instructor II Ghawaly 8/11-8/13, 8/18, 8/19 Leadership II Class Novak 9.15.14-9.19.14 January 2015 - Member Assessment Municipal Conference lunch United Way Refrigerator for Station 12 2014 Fire Uniform Allowance Period 12/01/14 - 12/31/14 Chamber Ad Legal notice for PZ -35-14 Building Maintenance and Repair 2014 Petty Cash -FD -Oct November petty cash 405 - Police Pension Transfer Stamp Rebate Shining Stars Posters Safety Shoe Allowance Refund building fee Permit #14-2388 (Cancelled) Tri State EMS Conference -Seleen Maintenance and repair supplies 2014 Fire Uniform Allowance Small Tools December maintenance contract for phones, switches & servers Monthly Internet Fees Chief's off duty wallet badge Reimburse expenses: Pre-employment background check - A. Kiess Tree Lighting 2014 Green Room Transfer Stamp Rebate Page 3 of 9 Amount 1,737.55 572.35 209.06 1,495.00 25.00 979.66 7.50 138.96 687.43 1,050.00 2,007.18 1,367.50 25.04 28.11 15.56 495.30 215.00 674.00 68.96 64.00 1,514.00 1,682.00 11,585.20 665.60 3,000.00 50.00 3,000.00 105.03 303.70 74.32 71.83 53.70 2,665.13 1,466.41 2,110.66 633.08 676.03 350.00 450.00 56,811.12 15.20 230.64 1,444.00 114.00 78.00 1,895.00 86.40 850.00 69.29 485.30 35,951.12 620.00 182.00 314.99 50.00 138.00 78.50 42.49 14.66 72.00 1,166.25 75.00 195.74 34.98 234.00 VILLAGE OF MOUNT PROSPECT List of Bills November 27 - December 10, 2014 Fund Vendor Name . �.. �,.m, Invoice Description Amount _....._,,_,m__ .... -. . ... The File Mart _....................... ............_...... _ _ .. Tabs 109.83 The Manfred Group, LLC Photography Tree Lighting 2014 200.00 Thompson Elevator Inspections Elevator Inspections 333.00 Elevator Inspections 1,222.00 Elevator Inspections 112.00 Elevator Inspections 74.00 Elevator Inspections 111.00 Elevator Inspections 75.00 Elevator Inspections 37.00 Elevator Inspections 705.00 TM Production Services, Inc. Supplies 1,729.80 United Healthcare Flex Benefit Plan Services - November 2014 609.50 United States Postal Service CAPS Postage 33.65 CAPS Postage -Nov 3.93 University of Illinois Management I -Novak, VMO- Lossoff 700.00 Vanopdorp, Teresa Special Events Activities 316.00 Reimbursement Celestial Celebration Expense 94.06 VCG Uniform Uniform for Lt. Ghawaly Promotion 385.45 Verizon Wireless Services LLC Cellular Service & Equipment Charges 6,937.18 Village of Mount Prospect Flex - Medical 8,627.92 Warehouse Direct 4 Boxes of paper and 2 boxes of white out tape 126.46 Office Supplies 43.34 Hole punchers, binders, coffee, markers, post its, flash drives 439.04 Windy City RE LLC Refund building & plan review fee #14-1879(2006 W Algonquin Rd #713) 50.00 Refund building & plan review fee #14-1877(2030 W Algonquin Rd #713) 90.00 Wisconsin Department of Revenue WI State Withholding 531.31 WISCTF Garnishment 542.48 001 General Fund Total $ 766,314.60 002 Debt Service Fund Bank of New York Mellon GO Series 2009 Interest Payment 208,631.25 GO Refunding Bond 2009B Principal & Interest 337,862.50 GO Bond 2009C Principal & Interest 92,511.25 GO Bonds Series 2013 Interest Payment 184,978.13 GO Bonds 2014 Principal & Interest 409,350.00 Glenview State Bank GO Installment Note 2012 Principal & Interest 146,262.00 Illinois EPA IEPA L17-1087 Principal & Interest Payments 58,252.79 IEPA L17-0857 Principal & Interest Payments 60,150.73 J.P. Morgan Chase Bank N.A. Principal and Interest Payments 2011A, 2011B, 2012 750,236.50 002 Debt Service Fund Total $ 2,248,235.15 020 Capital Improvement Fund GLC Industries, Inc. Down Payment for Station 13 Kitchen Countertops 3,245.00 Northwest Central 9-1-1 System Motorola Subscriber Financing - December 2014 10,603.91 020 Capital Improvement Fund Total $ 13,848.91 022 Downtown Redevelopment Construction Fund Cook County Government Return of Surplus Incremental Taxes Year 2013 2,000,000.00 Return of Surplus Incremental Taxes Year 2013 629,922.00 022 Downtown Redevelopment Construction Fund Total $ 2,629,922.00 023 Street Improvement Construction Fund Ciorba Group Inc Street Improvements 1,396.23 Ozinga Materials, Inc. Bin Blocks 6,225.00 Bin Blocks 1,500.00 Bin Blocks 180.00 Bin Blocks 605.00 023 Street Improvement Construction Fund Total $ 9,906.23 024 Flood Control Construction Fund Constellation NewEnergy, Inc. Electrical Service Delivery $ 90.67 Electrical Service Delivery 81.47 024 Flood Control Construction Fund Total $ 172.14 Page 4 of 9 VILLAGE OF MOUNT PROSPECT List of Bills November 27 - December 10, 2014 Fund Vendor Name Invoice Description $ Amount 040 Refuse Disposal Fund IL State Withholding 67.19 ARC Disposal Company Refuse Disposal Program $ 263.88 Diamond Coring Co., Inc. Street Sweeper Rental 7,660.00 Groot Industries, Inc. Refuse Disposal Program 27.54 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 65.83 Illinois Department of Revenue IL State Withholding $ 518.53 Internal Revenue Service Federal Withholding 3,709.79 International Union of Operating Engineers IUOE PW Membership Dues $ 99.23 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 295.00 NCPERS Group Life Ins. IMRF Life Insurance 17.60 Northwest Suburban United Way United Way 3.85 United States Postal Service CAPS Postage 1,281.84 Village of Mount Prospect Flex - Medical 79.38 040 Refuse Disposal Fund Total Professional Services $ 14,022.47 041 Motor Fuel Tax Fund Other Services 4,465.60 Constellation NewEnergy, Inc. Electrical Service Delivery $ 74.89 Burns & Mcdonnell Engineering Co. Electrical Service Delivery 94.18 Century Cleaners Electrical Service Delivery 1,610.16 Electrical Service Delivery 156.83 Lyons & Pinner Electric Companies Traffic Light Maintenance 1,360.00 Maxx Contractors Corp 1st retainer pmt for 2014-15 Cul-de-sac snow removal contract 4,000.00 First installment for 2014-2015 section snow removal contract 7,500.00 Morton Salt, Inc Street Salt/De-icing Agents 11,763.37 Street Salt/De-icing Agents 10,285.46 Dakota Security Systems, Inc. Street Salt/De-icing Agents 16,573.00 Street Salt/De-icing Agents 18,403.33 Garvey's Office Products Street Salt/De-icing Agents 16,363.82 Hansen, Donald E. Streets Salt/Calcium Chloride 3,167.26 HBK Water Meter Service Street Salt/De-icing Agents 3,381.75 Street Salt/De-icing Agents 1,574.91 041 Motor Fuel Tax Fund Total $ 96,308.96 042 Community Development Block Grant ICMA Retirement Trust - 457 ICMA 457 (flat percent) $ 375.05 Illinois Department of Revenue IL State Withholding 67.19 Internal Revenue Service Federal Withholding 476.45 Paddock Publications, Inc. CDBG legal notice 114.75 CDBG legal notice 49.95 Village of Mount Prospect Flex - Medical 78.14 042 Community Development Block Grant Total $ 1,161.53 050 Water and Sewer Fund Aramark Uniform Services, Inc. Uniform rental and cleaning for Public works employees $ 99.35 Uniform rental and cleaning for Public works employees 99.35 Badger Meter Inc AMR/AMI System 60,664.32 AMR/AMI System 2,862.00 Baxter & Woodman, Inc. Sewer System Improvements 6,303.02 Sewer System Improvements 711.40 Professional Services 3,266.25 Other Services 4,465.60 Professional Services 1,020.00 Burns & Mcdonnell Engineering Co. Professional Services 652.00 Century Cleaners Uniform Cleaning 12.30 Uniform Cleaning 18.67 Uniform Cleaning 14.12 Uniform Cleaning 25.02 Uniform Cleaning 14.57 Uniform Cleaning 8.65 Uniform Cleaning 28.70 Dakota Security Systems, Inc. Tank Repair 1,012.00 Tank Repair 590.00 Garvey's Office Products Office Supplies 89,29 Hansen, Donald E. Safety Shoe Allowance 180.00 HBK Water Meter Service Water Meter Installations 1,764.00 Page 5 of 9 Fund Vendor Name ... .......... Hutchinson Design Group,ltd. ICMA Retirement Trust - 457 Illinois Department of Revenue Innovyze, Inc. Internal Revenue Service International Union of Operating Engineers K -Plus Engineering, LLC. L & B Business Services Inc. Mazursky, Shelby Michael A. Klancnik Nationwide Mutual Insurance Company NCPERS Group Life Ins. NICOR Northwest Electrical Supply Northwest Suburban United Way Red Investments LLC TM Production Services, Inc. Tri-state Electronic Corp United States Postal Service Verizon Wireless Services LLC Village of Mount Prospect Warehouse Direct Water Environment Federation 050 Water and Sewer Fund Total 051 Village Parking System Fund Crystal Maintenance Services Corp. Elite Remodeling Group, Inc. ICMA Retirement Trust - 457 Illinois Department of Revenue Internal Revenue Service International Union of Operating Engineers Nationwide Mutual Insurance Company Village of Mount Prospect 051 Village Parking System Fund Total 052 Parking System Revenue Fund Crystal Maintenance Services Corp. Elite Remodeling Group, Inc. ICMA Retirement Trust - 457 Illinois Department of Revenue Internal Revenue Service International Union of Operating Engineers Nationwide Mutual Insurance Company NICOR Union Pacific Railroad Village of Mount Prospect 052 Parking System Revenue Fund Total 060 Vehicle Maintenance Fund American Messaging Arlington Heights Ford Breitzman, James Brett Equipment Chicago Parts & Sound Llc VILLAGE OF MOUNT PROSPECT List of Bills November 27 - December 10, 2014 Invoice Des Building Improvements ICMA 457 (flat percent) IL State Withholding GIS Maintenance Federal Withholding IUOE PW Membership Dues Professional Services Professional Services Water Meter Repair Parts Office Supplies Utility Refund - 970 E Northwest Hwy Nationwide 457 (flat percent) IMRF Life Insurance Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Repair Maintenance Supplies United Way Utility Refund - 1417 Chestnut Dr Supplies Repair Maintenance Supplies Repair Maintenance Supplies CAPS Postage CAPS Postage -Nov Cellular Service & Equipment Charges Flex - Medical Office Supplies Membership Dues Janitorial services for 8 buildings for the month of December Garnishment ICMA 457 (flat percent) IL State Withholding Federal Withholding IUOE PW Membership Dues Nationwide 457 (flat percent) Flex - Medical Janitorial services for 8 buildings for the month of December Garnishment ICMA 457 (flat percent) IL State Withholding Federal Withholding IUOE PW Membership Dues Nationwide 457 (flat percent) Natural Gas Consumption Metra Land Lease - Oct. 2014 Flex - Medical Pager rental Police front brake rotors Seat buckle and air bag jewel P-33 window switch and wiring 524 Shifter bushings, lever and solenoid Equipment Maintenance and Repair Tool Allowance Other supplies Vehicle Maintenance Supplies Vehicle Maintenance Supplies Page 6 of 9 Amount 7,850.00 1,340.00 3,651.60 5,000.00 22,629.80 932.90 604.00 604.00 55.98 195.00 23.88 420.90 52.80 111.20 88.25 174.28 21.06 34.73 8.76 1,960.05 114.39 (95.19) 4,406.50 4,405.78 432.86 625.45 75.72 141.00 $ 139,766.31 $ 318.57 78.19 9.00 62.35 379.27 15.22 9.96 _ 34.64 $ 907.20 $ 269.62 64.02 6.01 46.00 279.08 10.15 6.64 182.85 3,866.03 27.44 $ 4,757.84 $ 73.94 254.00 97.56 58.35 129.06 100.00 1,140.00 7.99 25.94 46.00 Fund Vendor Name Chicago Parts & Sound Llc Deluca, Kevin P. Eisen, Sean General Parts Inc. Global Emergency Products Hydrotex ICMA Retirement Trust - 457 Illinois Department of Revenue Inland Power Group Inc. Internal Revenue Service International Union of Operating Engineers Jeffrey S. Siegmund K & K Sales & Services Inc Lund Industries, Inc. Mark, John Menards Napa -Heights Automotive Supply NCPERS Group Life Ins. Northwest Suburban United Way Palatine Oil, Inc. Precision Service & Parts Ronco Industrial Supply Rush Truck Centers of Illinois, Inc. Sid Tool Co., Inc. Snap On Industrial Div of IDSC Holdings Inc. Source North America Verizon Wireless Services LLC Village of Mount Prospect, West Side Tractor Sales 060 Vehicle Maintenance Fund Total 061 Vehicle Replacement Fund Interstate Battery Liebovich Bros, Inc. Monroe Truck & Equipment Suburban Accents Inc Ziebart of Illinois 061 Vehicle Replacement Fund Total VILLAGE OF MOUNT PROSPECT List of Bills November 27 - December 10, 2014 Invoice Des Vehicle Maintenance Supplies Vehicle Maintenance Supplies 4 Ford Batteries Vehicle Maintenance Supplies Vehicle Maintenance Supplies Vehicle Maintenance Supplies Tool Allowance Tool Allowance 2730 Battery tray Defroster Tab Glue 517 Seat cushion 518 Repair Kit for Valve actuator 518 Water seat for 5" valve 518 5" Water valve seal kit Vehicle Maintenance Supplies ICMA 457 (flat percent) IL State Withholding Air filters 4512 Transmission pan Transmission Filters Federal Withholding IUOE PW Membership Dues 4541 Annual Safety Inspection Annual Vehicle Lift Inspections Vehicle Maintenance Supplies Vehicle Maintenance Supplies Tool Allowance Small Tools Vehicle Maintenance Supplies Latches IMRF Life Insurance United Way 8,002 Gallons Gasoline 6,500 Diesel Fuel 4542 Belt tensioner Vehicle Maintenance Supplies Small Tools Small Tools Lower mirror brackets Fuel and oil filters 4537 Instrument cluster circuit board Vehicle Maintenance Supplies Nuts, bolts, washers, grease fittings, cable ties and spray pain Nuts, bolts, washers, cotter pins Small Tools Equipment Maintenance and Repair Cellular Service & Equipment Charges Flex - Medical 2739 water pump, belt and seals Equipment for Public Works Vehicles Equipment for Public Works Vehicles Equipment for Public Works Vehicles New 2730 graphics Equipment for Public Works Vehicles Equipment for Police Dept. Vehicles Page 7 of 9 Amount (46.00) (313.08) 417.44 473.30 21.18 227.90 1,140.00 1,052.93 17.16 32.34 331.18 228.18 296.71 105.42 403.60 886.99 1,899.56 225.04 217.57 434.00 12,354.08 474.38 795.00 500.00 177.60 33.00 1,059.78 73.96 14.06 14.54 48.00 3.85 18,906.41 19,782.82 103.55 195.99 67.58 24.35 174.76 342.00 365.38 33.00 426.06 419.19 340.00 379.14 146.98 195.84 441.33 $ 67,876.89 $ 92.95 460.04 1,195.50 750.00 450.00 100.00 $ 3,048.49 VILLAGE OF MOUNT PROSPECT List of Bills November 27 - December 10, 2014 Fund Vendor Name Invoice Description $ 200.00 Amount 063 Risk Management Fund 200.00 Anton/Renate Schoenauer Family Trust Refund Escrow Permit # 14-2328 American Appraisal Associates, Inc. Professional Valuation Consulting Services - 11/10/14 $ 3,800.00 Gallagher Bassett Services, Inc. Liability Claims 125.00 12,351.74 Refund Escrow Permit # 14-0793 (2911 Briarwood Dr W) Liability Claims Chicago Sign & Light Company 1,152.30 Intergovernmental Per.ben.coop IPBC - December 2014 Refund Escrow Permit # 14-2020 (601 Dempster St) 497,343.84 063 Risk Management Fund Total Refund Escrow Permit # 14-2021 (1743 Linneman Rd) $ 514,647.88 070 Police Pension Fund 200.00 Culkin, Winifred Refund Escrow Permit# 14-0917 INSPE Associates Ltd. Medical Expense - Rose, Michael Claim # 1096 $ 909.60 Internal Revenue Service Federal Withholding 125.00 45,803.43 Lauterbach & Amen, LLP Preparation of the Municipal Compliance Report 12/31/13 550.00 National Conf. of Public Employers Retirement Sys Membership Renewal 2015 Refund Escrow Permit # 14-2223 (224 Autumn Ln) 250.00 Wells Fargo Bank Bank Admin Fee 11/1/14-1/31/15 200.00 1,102.43 070 Police Pension Fund Total 125.00 $ 48,615.46 071 Fire Pension Fund Flush Sewer & Drainage Refund Escrow Permit # 14-2378 (1415 Columbine Dr) 125.00 Internal Revenue Service Federal Withholding $ 40,643.30 Lauterbach & Amen, LLP Preparation of the Municipal Compliance Report 12/31/13 550.00 Wells Fargo Bank Bank Admin Fee 11/1/14-1/31/15 Refund Escrow Permit # 14-2032 (518 S Pine St) 1,006.04 071 Fire Pension Fund Total Refund Escrow Permit # 14-2412 $ 42,199.34 073 Escrow Deposit Fund A & B Landscaping Services LLC Refund Escrow Permit # 14-2282 (704 Dresser Dr) $ 200.00 Amaro, Steven Refund Escrow Permit# 14-1761 200.00 Anton/Renate Schoenauer Family Trust Refund Escrow Permit # 14-2328 125.00 ARS of Illinois Refund Escrow Permit # 14-2374 (613 Forest Ave) 125.00 Ben Franklin Plumbing Refund Escrow Permit # 14-2315 (511 S Owen St) 125.00 Chicago Roof Deck & Garden Refund Escrow Permit # 14-0793 (2911 Briarwood Dr W) 100.00 Chicago Sign & Light Company Refund Escrow Permit # 14-1975 (1010 Mt Prospect Plz) 125.00 Colliers Bennett's & Kahnweiler Refund Escrow Permit # 14-2020 (601 Dempster St) 125.00 Refund Escrow Permit # 14-2021 (1743 Linneman Rd) 125.00 Collins, Samuel Refund Escrow Permit # 14-1008 200.00 Culkin, Winifred Refund Escrow Permit# 14-0917 250.00 Cushman & Wakefield of Illinois Inc Refund Escrow Permit # 14-1995 (1061 Feehanville Dr) 125.00 Daubecooper, Jacqueline L Refund Escrow Permit # 14-0594 125.00 Dubois Paving Company Refund Escrow Permit # 14-1618 (1455 N Picadilly Circle) 125.00 Refund Escrow Permit # 14-1620 (1455 Picadilly Cir) 125.00 Espinoza Twin Brothers Landscaping Inc Refund Escrow Permit # 14-2223 (224 Autumn Ln) 200.00 Refund Escrow Permit # 14-2232 (309 Eric Ct) 200.00 Fastsigns of Carpenterville Refund Escrow Permit # 14-1098 (709 E Rand Rd) 125.00 Father and Sons Plumbing and Sewer Refund Escrow Permit # 14-2128 (1406 Robert Dr) 450.00 Flush Sewer & Drainage Refund Escrow Permit # 14-2378 (1415 Columbine Dr) 125.00 Fojtik, Jane Refund Escrow Permit # 13-0684 525.00 Fortis Concrete Refund Escrow Permit # 14-1436 (200 E Bershire Ln) 200.00 Refund Escrow Permit # 14-2028 (1403 Barberry Ln) 150.00 Refund Escrow Permit # 14-2032 (518 S Pine St) 200.00 Gates, Jeanne E Refund Escrow Permit # 14-2412 125.00 Gorski, Anna Refund Escrow Permit # 14-2013 200.00 J & J Remodeling & Asset Services Refund Escrow Permit # 14-1225 (906 Willow Ln) 200.00 JLS Construction Inc Refund Escrow Permit # 14-1064 (400 S Main St) 200.00 Johnson, Michael Refund Escrow Permit # 14-1230 (557 Dempster St) 75.00 Kaplan Pavement Services LLC Refund Escrow Permit # 14-1014 (911 S Maple St) 150.00 Kensington Business Center Holdings -1, LLC Refund Escrow Permit # 14-0148 (1500 Bishop Ct) 200.00 Kilian, Lynette Refund Escrow Permit # 14-2447 125.00 Kosek, Michal Refund Escrow Permit # 14-2277 75.00 Refund Escrow Permit # 14-2277A 375.00 Koszyk, Jan Refund Escrow Permit # 13-2224 200.00 Leibforth Landscape Inc Refund Escrow Permit # 14-1685 (708 See Gwun Ave) 200.00 M.A. Mortenson Co Refund Escrow Permit # 12-1136 (1540 W Algonquin Rd) 50,000.00 Maloney, Terry Refund Escrow Permit # 14-1965 200.00 Manansala, Joel Refund Escrow Permit # 14-2407 125.00 Mazur, Ziemowit Refund Escrow Permit # 14-2055 200.00 Meilinger, Joann M Refund Escrow Permit # 14-2162 125.00 Michael & Sheryl Jun Junius Investments Refund Escrow Permit # 14-1410 (1709 Chariot Ct) 125.00 Midwest Roofing Contractor Refund Escrow Permit # 14-1666 (1003 Alder Ln) 150.00 Page 8 of 9 074 Series 2002 Library Bond J.P. Morgan Chase Bank N.A. Principal and Interest Payments 2011A, 2011B, 2012 Wells Fargo Bank GO Bonds 2006 Library Principal & Interest 074 Series 2002 Library Bond Total Grand Total Page 9 of 9 $ 1,110,462.50 246,726.25 $ 1,357,188.75 $ 8,022,445„15 VILLAGE OF MOUNT PROSPECT List of Bills November 27 - December 10, 2014 Fund Vendor Name Invoice Description Amount My Sign Guy Refund Escrow Permit # 14-0054 (4 Randhurst Village Dr) 75.00 National Shopping Plazas Inc Refund Escrow Permit # 14-2171 (1698 S Elmhurst Rd) 125.00 Netrix Building LLC Refund Escrow Permit # 14-0461 (1331 Business Center Dr) 700.00 Ochab, Alan Refund Escrow Permit # 14-1615 200.00 Penco Electric Inc Refund Escrow Permit # 14-2225 (1813 Sitka Ln) 125.00 Perma Seal Basement Systems Refund Escrow Permit # 14-1012 (201 E Berkshire Ln) 125.00 Refund Escrow Permit # 14-1013 (1305 Mulberry Ln) 125.00 Picket Fence Realty Refund Escrow Permit # 14-1446 25.00 Pro Temp of Illinois Refund Escrow Permit # 14-2413 (111 S Elmhurst Ave) 125.00 Ricks Sewer & Drainage Refund Escrow Permit # 14-2423 (19 S Owen St) 125.00 Rize Properties LLC Refund Escrow Permit # 13-2215 (302 N Elm St) 50.00 Ruelas, Thomas Refund Escrow Permit # 14-1686 200.00 Schlueter, Paul A Refund Escrow Permit # 14-2298 125.00 Sheehy, Mary Claire Refund Escrow Permit # 14-0081 400.00 Sign Outlet Inc Refund Escrow Permit # 14-1583 (1500 Bishop Ct) 125.00 Strugacz, Andrzej Refund Escrow Permit # 14-2369 500.00 Sultan, Aga Ali Refund Escrow Permit # 14-0894 (533 Dempster St) 75.00 The Sign Authority Refund Escrow Permit # 14-2316 (1000 Mt Prospect Plaza) 250.00 Third District Circuit Court Bond Check 12/2/14 1,425.00 Bond Check 12/04/14 270.00 Bond Check12/9/14 250.00 Urban Investment Group LLC Refund Escrow Permit # 14-1406 (807 S Maple St) 100.00 Windy City RE LLC Refund Escrow Permit # 14-1877 (2030 W Algonquin Rd #713) 300.00 Refund Escrow Permit # 14-1879 (2006 W Algonquin Rd #56) 300.00 073 Escrow Deposit Fund Total $ 63,545.00 074 Series 2002 Library Bond J.P. Morgan Chase Bank N.A. Principal and Interest Payments 2011A, 2011B, 2012 Wells Fargo Bank GO Bonds 2006 Library Principal & Interest 074 Series 2002 Library Bond Total Grand Total Page 9 of 9 $ 1,110,462.50 246,726.25 $ 1,357,188.75 $ 8,022,445„15