The URL can be used to link to this page

Home My WebLink About4. Monthly Report & Approve Bills 12/15/2015Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: DECEMBER 9, 2015 SUBJECT: MONTHLY FINANCIAL REPORT — NOVEMBER 2015 Attached hereto are the cash position and investment statements of the Village for the month ended November 30, 2015. 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 was $48.2 million. During November, cash receipts totaled $5,249,356. In addition, investment income for the month was $1,904. Outflows due to interfund activity totaled $358,908. Reductions in cash and cash equivalents during November totaled $12,159,670. Of this amount, payments to vendors were $10,855,792 and employee payroll and related expenses were $1,301,519. The reason for the large amount of payments to vendors during the month was due to the significant completion of a single large capital project. Other disbursements of $2,359 accounted for the balance of the change during November. Cash and cash equivalents at November 30 were $41.0 million. Monthly Financial Report — November 2015 December 9, 2015 Page 2 There was no cash of the Governmental or Enterprise Funds held in investments during the month of November. Funds were held in liquid money market accounts that are currently earning competitive rates of interest. Total cash and investments for Governmental and Enterprise Funds at October 31 were $48,218,201. Cash and investments at November 30 totaled $40,950,468. This is a decrease of $7,267,733. Trust and Agency Funds - Cash and cash equivalents at October 31 was $2.7 million. During November, cash receipts totaled $166,521. Investment income for the month was $115,181. There was also a net decrease in cash due to investment activities of $339,500 while inflows due to Interfund activity totaled $358,908. Reductions in cash and cash equivalents during November totaled $830,267. Of this amount, payments to vendors were $176,266, employee payroll and related expenses were $639,434 and payments related to the flexible spending program totaled $12,080. Other disbursements reflect totaled $2,487. Cash and cash equivalents at November 30 were $2.1 million. Total investments at November 30 were $113,910,431, an increase of $367,776 from October 31. There were interest income and unrealized investment gains of $28,276 and a net transfer from cash of $339,500 that accounted for the change. Total cash and investments for Trust and Agency Funds at October 31 were $116,202,665. Cash and investments at November 30 totaled $116,041,285. This is a decrease of $161,380. 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 $13,737,187. During November, cash receipts totaled $2,890,906 and investment income was $398. There was also interfund activity that decreased cash by $1,072,260. Significant cash receipts included sales, income and telecommunication taxes. Sales tax revenues for the month totaled $1,527,357. Of this amount, $1,393,931 was generated from the 1% state portion while $133,426 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:WCCT\Treasurer's Report\2015\Monthly Cash Position Report - November 2015.docx Monthly Financial Report — November 2015 December 9, 2015 Page 3 State income tax receipts for November totaled $314,461 and were for the month of August. Receipts of this revenue source are now consistent with sales tax in that there is a three-month lag in getting this distribution from the state. Telecommunication tax receipts for November also reflect August activity. Total receipts for the month were $166,689. Year-end estimates for this revenue are $2.1 million. This reflects a positive variance over the original budget of $500,000. Disbursements from the General Fund for November included payments to vendors of $1,229,737, payments for employee wages and benefits of $1,139,189 and other disbursements of $2,362. Cash and cash equivalents at November 30 were $13,184,942. 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 — Surplus funds for the governmental and agency funds are placed in money market accounts due to the lack of viable alternatives in the marketplace. Prior to the decline in interest rates, the Village utilized certificates of deposit to place funds short-term. At November 30 there were no CD's placed at any bank. Maturity Purchase Financial Investment CUSIP/ Date Date Institution Description FDIC # Net Yield Purch Price As of November 30, 2015, there were no certificates of deposit held by the Governmental and Enterprise Funds. Trust and Agency Funds — The investments for the trust and agency funds are made up of certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in the Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of the reserves for this fund are invested in the more liquid money market account due to the nature of the deposit. Escrow refunds are processed two times per month. Investments for the Police and Firefighter Pension Funds consist of various fixed income securities as well as equity mutual fund accounts. Wells Fargo is the third -party holder of the fixed income securities. The funds are managed by three investment management firms, Galliard, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of the fixed income investments for the two pension funds while Galliard and Mesirow manage the balance of fixed income investments for these two funds. Each manager maintains a small portion of their portfolio in cash to help facilitate liquidity and trading. H:\ACCT\Treasurer's Report\2015\Monthly Cash Position Report - November 2015.docx Monthly Financial Report — November 2015 December 9, 2015 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 Investment CUSIP/ Interest Market Date Date Institution Description Acct Rate % Value POLICE PENSION FUND (070) Various Various Wells Fargo Wells Fargo Investments Various Various $ 23,549,47523 Various Various Various Mutual Fund Investments Various Various 35,197,279.91 58,746,755.14 FIRE PENSION FUND (071) Various 5/26/2015 Principal Life Insurance Company Group Annuity Contract 8-10810 Variable 2,637,65331 Various Various Wells Fargo Wells Fargo Investments Various Various 20,666,62522 Various Various Various Mutual Fund Investments Various Various 31,859,397.41 55,163,675.94 TOTAL TRUST AND AGENCY FUND INVESTMENTS $113,910,431.08 Investment of the Village's pension funds is governed by an Investment Policy adopted by each Pension Board. Conclusion This cash position report is intended to provide a snapshot of the Village's cash position as of a particular month end date. Maintaining strong cash balances allow the Village to weather delays in receipt of revenues or cover unanticipated/unscheduled expenses. Please review the information and contact me with any questions. David O. Erb Finance Director H:WCCT\Treasurer's Report\2015\Monthly Cash Position Report - November 2015.docx VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended November 30, 2015 GOVERNMENTAL AND ENTERPRISE FUNDS Balance at October 31, 2015 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, 2015 Cash and Cash Total Cash and Equivalents Investments Investments $ 48,218,200.73 $ - $ 48,218,200.73 5,249,356.01 5,249,356.01 1,488.70 - 1,488.70 (358,908.21) (358,908.21) (10,855,791.92) (10,855,791.92) (1,301,518.85) (1,301,518.85) (2,358.94) (2,358.94) 28,276.31 $ 40,950,467.52 $ - $ 40,950,467.52 TRUST AND AGENCY FUNDS * Disbursements: Accounts payable Payroll Flex spending Other Balance at November 30, 2015 (176,265.95) (639,433.90) (12,079.80) (2,487.32) (176,265.95) (639,433.90) (12,079.80) (2,487.32) $ 2,130,853.88 $ 113,910,431.08 $ 116,041,284.96 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 Cash and Cash Total Cash and Equivalents Investments Investments Balance at October 31, 2015 $ 2,660,010.36 $ 113,542,654.96 $ 116,202,665.32 Cash receipts 166,520.88 166,520.88 Investment income (loss) 115,181.21 28,276.31 143,457.52 Transfers from investments to cash 878,138.24 (878,138.24) - Transfers to investments from cash (1,217,638.05) 1,217,638.05 - Interfund activity 358,908.21 358,908.21 Disbursements: Accounts payable Payroll Flex spending Other Balance at November 30, 2015 (176,265.95) (639,433.90) (12,079.80) (2,487.32) (176,265.95) (639,433.90) (12,079.80) (2,487.32) $ 2,130,853.88 $ 113,910,431.08 $ 116,041,284.96 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 N VILLAGE OF MOUNT PROSPECT Summary of Cash Activity by Fund Type For the Month Ended November 30. 2015 INVESTMENTS Certificates of deposit _ _ _ Wells Fargo investments - - 44,216,100.45 44,216,10045 Mutual fund investments - 69,694.330.63 69,694,330.63 Total investments - - - - - 113,910,431.08 113,910,431,08 TOTAL CASH AND INVESTMENTS $ 13,184,941.81 $ 3,695,696.49 $ (160,769.62) $ 9,078,548.03 $ 3,563,588.04 $ 11,588,462.77 $ 40,950,467.52 $114,917,167.09 $ 1,124,117.87 $156,991,752.48 * Assets are restricted in purpose and do not represent discretionary assets of the government. GOVERNMENTAL AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS* SPECIAL CAPITAL TOTAL GOVT. FIRE AND OTHER TRUST REVENUE DEBT SERVICE PROJECTS ENTERPRISE INTERNAL AND ENTERPRISE POLICE AND AGENCY GENERAL FUND FUNDS FUNDS FUNDS FUNDS SERVICE FUNDS FUNDS PENSIONS FUNDS TOTAL CASH & CASH EQUIVALENTS Beginning balance $ 13,737,186,77 $ 3,568,053.39 $ 3,512,604.79 $ 12,336,704.88 $ 3,571,548.08 $ 11,492,102.82 $ 48,218,200.73 $ 1,525,301.56 $ 1,134,708.80 $ 50,878,211.09 Cash receipts 2,890,905,53 601,368.88 125,710.09 368,074.36 1,173,005.99 90,291.16 5,249,356.01 110,909.87 55,611.01 5,415,876.89 Investment income 398.06 90.00 82.42 527.62 163.77 226.83 1,488.70 115,16839 12.82 116,669.91 Transfers from investments - - - - - - - 878,138.24 - 878,138,24 Transfers to investments - - - - (1,217,638.05) (1,217,638.05) Interfund (1,072,259.94) 27,080,17 - (173,432.73) 859,704.29 (358,908.21) 361,220.85 (2,312.64) 0.00 Disbursements - other (2,362.19) - - - 3.25 (2,358.94) - (2,487.32) (4,846.26) Disbursements - flexible spending - - - - - (12,079.80) (12,079.80) Disbursements -payroll (1,139,189.25) (13,857.85) (102,296.95) (46,17480) (1,301,518.85) (639,433.90) (1,940,952,75) Disbursements - accounts payable (1,229,737.17) (487,038.10) (3,799,166.92) (3,626,758.83) (905.403 37) (807,687.53) (10,855.791.92) (126,930,95) (49.335.00) (11,032,05787) Ending balance 13,184,941,81 3,695,696.49 ___(160,769 62) 9,078,548.03 3,563,588.04 11,588,462,77 40,950,467.52 1,006,736,01 1.124.117.87 43 .081,321.40 INVESTMENTS Certificates of deposit _ _ _ Wells Fargo investments - - 44,216,100.45 44,216,10045 Mutual fund investments - 69,694.330.63 69,694,330.63 Total investments - - - - - 113,910,431.08 113,910,431,08 TOTAL CASH AND INVESTMENTS $ 13,184,941.81 $ 3,695,696.49 $ (160,769.62) $ 9,078,548.03 $ 3,563,588.04 $ 11,588,462.77 $ 40,950,467.52 $114,917,167.09 $ 1,124,117.87 $156,991,752.48 * Assets are restricted in purpose and do not represent discretionary assets of the government. VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of November 30, 2015 Maturity Purchase Financial Date Date Institution GOVERNMENTAL AND ENTERPRISE FUNDS Investment CUSIP/ Description FDIC # Net Yield Purch Price As of November 30, 2015, there were no certificates of deposit held by the Governmental and Enterprise Funds. Maturity Purchase Financial Date Date Institution POLICE PENSION FUND (070) Various Various Wells Fargo Various Various Various TRUST AND AGENCY FUNDS Investment Description CUSIP/ Interest Acct # Rate % Wells Fargo Investments Various Mutual Fund Investments Various FIRE PENSION FUND (071) Various 5/26/2015 Principal Life Insurance Company Group Annuity Contract Various Various Wells Fargo Wells Fargo Investments Various Various Various Mutual Fund Investments TOTAL TRUST AND AGENCY FUND INVESTMENTS * Assets are restricted in purpose and do not represent discretionary assets of the government. 8-10810 Various Various Market Various $ 23,549,475.23 Various 35,197,279.91 58,746,755.14 Variable 2,637,653.31 Various 20,666,625.22 Various 31,859,397.41 55,163,675.94 $ 113,910,431.08 K VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES November 01 — November 30, 2015 Revenue Budget by Account Classification )L Account Classification Adopted Budget Budget Amendments Amended Budget Current Month YTD Transactions Encumbrance Report Through 11/30/15 Prior Fiscal Year Activity Included YTD Budget- YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 001 - General Fund REVENUE Property Taxes 15,427,500.00 .00 15,427,500.00 17,235.26 .00 15,245,807.08 181,692.92 99 14,458,097.51 Other Taxes 7,457,566.00 980,000.00 8,437,566.00 764,562.03 .00 6,417,060.34 2,020,505.66 76 6,119,749.79 Licenses, Permits & Fees 1,256,000.00 214,000.00 1,470,000.00 113,286.50 .00 1,611,250.31 (141,250.31) 110 1,618,445.91 Intergovernmental Revenue 20,123,200.00 614,404.00 20,737,604.00 1,708,391.68 .00 15,612,958.41 5,124,645.59 75 13,948,732.01 Charges For Services 1,633,223.00 126,000.00 1,759,223.00 132,591.78 .00 1,476,693.90 282,529.10 84 1,426,365.34 Fines & Forfeits 439,000.00 50,000.00 489,000.00 32,621.18 .00 451,452.28 37,547.72 92 420,654.05 Investment Income 5,918.00 .00 5,918.00 410.70 .00 7,681.19 (1,763.19) 130 4,052.67 Reimbursements 220,000.00 .00 220,000.00 7,020.32 .00 167,942.61 52,057.39 76 328,261.83 Other Revenue 236,000.00 .00 236,000.00 21,753.53 .00 259,095.43 (23,095.43) 110 251,987.53 Other Financing Sources 20,000.00 .00 20,000.00 .00 .00 (11,102.14) 31,102.14 -56 20,000.00 REVENUE TOTALS $46,818,407.00 $1,984,404.00 $48,802,811.00 $2,797,872.98 $0.00 $41,238,839.41 $7,563,971.59 85% $38,596,346.64 Fund 001 - General Fund Totals $46,818,407.00 $1,984,404.00 $48,802,811.00 $2,797,872.98 $0.00 $41,238,839.41 $7,563,971.59 $38,596,346.64 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 002 - Debt Service Fund REVENUE Property Taxes 2,254,000.00 .00 2,254,000.00 5,785.77 .00 2,242,518.14 11,481.86 99 2,216,862.61 Other Taxes 988,508.00 .00 988,508.00 98,024.48 .00 642,420.85 346,087.15 65 690,732.65 Intergovernmental Revenue 42,773.00 1,568,856.00 1,611,629.00 21,899.84 .00 1,612,537.19 (908.19) 100 43,831.65 Investment Income 100.00 .00 100.00 40.64 .00 239.49 (139.49) 239 81.76 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ 112.38 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $3,285,381.00 $1,568,856.00 $4,854,237.00 $125,750.73 $0.00 $4,497,715.67 $356,521.33 93% $2,951,621.05 Fund 002 - Debt Service Fund Totals $3,285,381.00 $1,568,856.00 $4,854,237.00 $125,750.73 $0.00 $4,497,715.67 $356,521.33 $2,951,621.05 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 020 - Capital Improvement Fund REVENUE Other Taxes 1,246,000.00 .00 1,246,000.00 123,513.25 .00 809,466.15 436,533.85 65 814,601.78 Intergovernmental Revenue .00 48,000.00 48,000.00 .00 .00 47,273.72 726.28 98 .00 Investment Income 1,000.00 .00 1,000.00 60.13 .00 455.88 544.12 46 469.05 Reimbursements .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Revenue 20,000.00 28,000.00 48,000.00 .00 .00 47,520.00 480.00 99 140,181.00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $1,267,000.00 $76,000.00 $1,343,000.00 $123,573.38 $0.00 $904,715.75 $438,284.25 67% $955,251.83 Fund 020 - Capital Improvement Fund Totals $1,267,000.00 $76,000.00 $1,343,000.00 $123,573.38 $0.00 $904,715.75 $438,284.25 $955,251.83 w Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 022 -Downtown Redevelopment Construct REVENUE Property Taxes 2,709,000.00 .00 2,709,000.00 1,593.89 .00 2,306,464.33 402,535.67 85 2,295,862.29 Investment Income 500.00 .00 500.00 58.89 .00 393.04 106.96 79 332.20 Reimbursements .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $2,709,500.00 $0.00 $2,709,500.00 $1,652.78 $0.00 $2,306,857.37 $402,642.63 85% $2,296,194.49 Fund 022 -Downtown Redevelopment Construct Totals $2,709,500.00 $0.00 $2,709,500.00 $1,652.78 $0.00 $2,306,857.37 $402,642.63 $2,296,194.49 M Account Classification Fund 023 - Street Improvement Construc Fund REVENUE Other Taxes Licenses, Permits & Fees Intergovernmental Revenue Fines & Forfeits Investment Income Reimbursements Other Revenue Other Financing Sources REVENUE TOTALS Fund 023 - Street Improvement Construc Fund Totals Revenue Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD 2,056,000.00 .00 2,056,000.00 195,735.25 .00 1,436,584.11 619,415.89 70 1,457,722.95 1,540,000.00 .00 1,540,000.00 12,587.50 .00 1,477,252.75 62,747.25 96 1,012,706.52 .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ 117,500.00 100.00 .00 100.00 19.91 .00 1,342.25 (1,242.25) 1342 4,222.14 .00 .00 .00 .00 .00 .00 .00 +++ .00 6,000.00 49,000.00 55,000.00 .00 .00 52,327.12 2,672.88 95 103,821.33 .00 .00 .00 .00 .00 .00 .00 +++ 6,584,696.75 $3,602,100.00 $49,000.00 $3,651,100.00 $208,342.66 $0.00 $2,967,506.23 $683,593.77 81% $9,280,669.69 $3,602,100.00 $49,000.00 $3,651,100.00 $208,342.66 $0.00 $2,967,506.23 $683,593.77 $9,280,669.69 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 024 - Flood Control Construction Fund REVENUE Other Taxes 357,000.00 .00 357,000.00 35,401.57 .00 232,010.49 124,989.51 65 189,246.50 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Charges For Services .00 30,000.00 30,000.00 1,997.50 .00 31,670.50 (1,670.50) 106 .00 Investment Income 1,100.00 .00 1,100.00 388.69 .00 11,860.36 (10,760.36) 1078 11,445.40 Reimbursements .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $358,100.00 $30,000.00 $388,100.00 $37,787.76 $0.00 $275,541.35 $112,558.65 71% $200,691.90 Fund 024- Flood Control Construction Fund Totals $358,100.00 $30,000.00 $388,100.00 $37,787.76 $0.00 $275,541.35 $112,558.65 $200,691.90 Cn7 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 040 - Refuse Disposal Fund REVENUE Property Taxes .00 .00 .00 .00 .00 .00 .00 +++ 339,442.21 Charges For Services 3,549,000.00 .00 3,549,000.00 237,024.78 .00 3,115,738.23 433,261.77 88 2,579,022.59 Fines & Forfeits 24,000.00 .00 24,000.00 1,739.50 .00 31,295.68 (7,295.68) 130 25,218.15 Investment Income 500.00 .00 500.00 25.23 .00 217.40 282.60 43 566.13 Reimbursements 1,000.00 .00 1,000.00 150.43 .00 3,716.40 (2,716.40) 372 884.88 Other Revenue 371,500.00 .00 371,500.00 30,269.69 .00 372,918.20 (1,418.20) 100 321,766.05 REVENUE TOTALS $3,946,000.00 $0.00 $3,946,000.00 $269,209.63 $0.00 $3,523,885.91 $422,114.09 89% $3,266,900.01 Fund 040 - Refuse Disposal Fund Totals $3,946,000.00 $0.00 $3,946,000.00 $269,209.63 $0.00 $3,523,885.91 $422,114.09 $3,266,900.01 v Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 041 - Motor Fuel Tax Fund REVENUE Intergovernmental Revenue 1,320,000.00 .00 1,320,000.00 .00 .00 596,472.32 723,527.68 45 1,575,118.36 Investment Income 200.00 .00 200.00 36.58 .00 277.94 (77.94) 139 44.68 Reimbursements 11,000.00 .00 11,000.00 1,219.80 .00 13,133.24 (2,133.24) 119 13,762.96 REVENUE TOTALS Fund 041 - Motor Fuel Tax Fund Totals C.7 $1,331,200.00 $0.00 $1,331,200.00 $1,256.38 $0.00 $609,883.50 $721,316.50 46% $1,588,926.00 $1,331,200.00 $0.00 $1,331,200.00 $1,256.38 $0.00 $609,883.50 $721,316.50 $1,588,926.00 Account Classification Fund 042 - CDBG REVENUE Intergovernmental Revenue Investment Income Other Revenue Cr.7 Revenue Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD 339,264.00 253,527.00 592,791.00 241,623.29 .00 241,623.29 351,167.71 41 52,998.37 .00 .00 .00 .00 .00 .00 .00 +++ .00 80,000.00 .00 80,000.00 25,000.00 .00 84,693.50 (4,693.50) 106 225,231.12 REVENUE TOTALS $419,264.00 $253,527.00 $672,791.00 $266,623.29 $0.00 $326,316.79 $346,474.21 49% $278,229.49 Fund 042 - CDBG Totals $419,264.00 $253,527.00 $672,791.00 $266,623.29 $0.00 $326,316.79 $346,474.21 $278,229.49 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 043 -Asset Seizure Fund REVENUE Fines & Forfeits 2,000.00 .00 2,000.00 .00 .00 15,495.19 (13,495.19) 775 44,146.56 Investment Income 100.00 .00 100.00 2.48 .00 19.63 80.37 20 13.61 REVENUE TOTALS $2,100.00 $0.00 $2,100.00 $2.48 $0.00 $15,514.82 ($13,414.82) 739% $44,160.17 Fund 043 -Asset Seizure Fund Totals $2,100.00 $0.00 $2,100.00 $2.48 $0.00 $15,514.82 ($13,414.82) $44,160.17 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 044 - Federal Equitable Share Funds REVENUE Fines & Forfeits 100.00 .00 100.00 .00 .00 2,687.50 (2,587.50) 2688 24,637.80 Investment Income 100.00 .00 100.00 .81 .00 9.64 90.36 10 18.20 REVENUE TOTALS $200.00 $0.00 $200.00 $0.81 $0.00 $2,697.14 ($2,497.14) 1349% $24,656.00 Fund 044- Federal Equitable Share Funds Totals $200.00 $0.00 $200.00 $0.81 $0.00 $2,697.14 ($2,497.14) $24,656.00 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 045 - DUI Fine Fund REVENUE Fines & Forfeits 20,000.00 .00 20,000.00 989.02 .00 27,496.94 (7,496.94) 137 30,813.43 Investment Income 100.00 .00 100.00 2.48 .00 27.05 72.95 27 34.06 REVENUE TOTALS $20,100.00 $0.00 $20,100.00 $991.50 $0.00 $27,523.99 ($7,423.99) 137% $30,847.49 Fund 045 - DUI Fine Fund Totals $20,100.00 $0.00 $20,100.00 $991.50 $0.00 $27,523.99 ($7,423.99) $30,847.49 N Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 046 - Foreign Fire Tax Board Fund REVENUE Other Taxes 70,000.00 .00 70,000.00 .00 .00 82,425.42 (12,425.42) 118 67,576.50 Investment Income 100.00 .00 100.00 8.99 .00 80.37 19.63 80 96.78 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Fund 046 - Foreign Fire Tax Board Fund Totals $70,100.00 $0.00 $70,100.00 $8.99 $0.00 $82,505.79 ($12,405.79) 118% $67,673.28 $70,100.00 $0.00 $70,100.00 $8.99 $0.00 $82,505.79 ($12,405.79) $67,673.28 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 048 - Business District Fund REVENUE Other Taxes 1,021,000.00 .00 1,021,000.00 84,488.76 .00 831,484.03 189,515.97 81 772,391.20 Investment Income .00 .00 .00 13.43 .00 88.99 (88.99) +++ 31.18 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Fund 048 - Business District Fund Totals $1,021,000.00 $0.00 $1,021,000.00 $84,502.19 $0.00 $831,573.02 $189,426.98 81% $772,422.38 $1,021,000.00 $0.00 $1,021,000.00 $84,502.19 $0.00 $831,573.02 $189,426.98 $772,422.38 81, Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 050 -Water and Sewer Fund REVENUE Property Taxes 1,530,000.00 .00 1,530,000.00 (6,161.88) .00 (3,452.83) 1,533,452.83 0 1,503,416.20 Licenses, Permits & Fees 18,000.00 .00 18,000.00 940.00 .00 17,100.00 900.00 95 16,630.00 Charges For Services 13,789,000.00 (1,165,000.00) 12,624,000.00 877,774.01 .00 11,372,573.94 1,251,426.06 90 10,825,363.54 Fines & Forfeits 118,000.00 .00 118,000.00 9,586.22 .00 106,545.23 11,454.77 90 102,258.33 Investment Income 2,100.00 .00 2,100.00 155.40 .00 1,593.75 506.25 76 3,224.08 Reimbursements 500.00 .00 500.00 .00 .00 .00 500.00 0 8,137.41 Other Revenue 72,000.00 .00 72,000.00 5,651.87 .00 69,468.97 2,531.03 96 61,916.04 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Fund 050 -Water and Sewer Fund Totals $15,529,600.00 ($1,165,000.00) $14,364,600.00 $887,945.62 $0.00 $11,563,829.06 $2,800,770.94 81% $12,520,945.60 $15,529,600.00 ($1,165,000.00) $14,364,600.00 $887,945.62 $0.00 $11,563,829.06 $2,800,770.94 $12,520,945.60 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 051 - Village Parking System Fund REVENUE Other Taxes .00 .00 .00 .00 .00 .00 .00 +++ 6,537.74 Charges For Services 130,600.00 .00 130,600.00 10,079.35 .00 128,812.18 1,787.82 99 124,279.22 Investment Income 100.00 .00 100.00 8.37 .00 76.16 23.84 76 83.17 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Fund 051 - Village Parking System Fund Totals 8 $130,700.00 $0.00 $130,700.00 $10,087.72 $0.00 $128,888.34 $1,811.66 99% $130,900.13 $130,700.00 $0.00 $130,700.00 $10,087.72 $0.00 $128,888.34 $1,811.66 $130,900.13 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 052 - Parking System Revenue Fund REVENUE Other Taxes 100,000.00 .00 100,000.00 9,912.78 .00 64,965.19 35,034.81 65 58,839.62 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Charges For Services 119,000.00 .00 119,000.00 9,796.00 .00 110,765.88 8,234.12 93 109,560.67 Investment Income .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Revenue .00 .00 .00 .25 .00 .25 (.25) +++ .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $219,000.00 $0.00 $219,000.00 $19,709.03 $0.00 $175,731.32 $43,268.68 80% $168,400.29 Fund 052 - Parking System Revenue Fund Totals $219,000.00 $0.00 $219,000.00 $19,709.03 $0.00 $175,731.32 $43,268.68 $168,400.29 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 060 - Vehicle Maintenance Fund REVENUE Charges For Services 2,157,889.00 .00 2,157,889.00 179,824.09 .00 1,978,064.99 179,824.01 92 1,960,123.77 Investment Income 600.00 .00 600.00 13.64 .00 322.12 277.88 54 514.12 Other Revenue .00 .00 .00 756.11 .00 1,879.81 (1,879.81) +++ 525.88 REVENUE TOTALS Fund 060 - Vehicle Maintenance Fund Totals 8 $2,158,489.00 $0.00 $2,158,489.00 $180,593.84 $0.00 $1,980,266.92 $178,222.08 92% $1,961,163.77 $2,158,489.00 $0.00 $2,158,489.00 $180,593.84 $0.00 $1,980,266.92 $178,222.08 $1,961,163.77 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 061 - Vehicle Replacement Fund REVENUE Charges For Services 1,380,500.00 .00 1,380,500.00 115,041.68 .00 1,265,458.48 115,041.52 92 1,234,108.48 Fines & Forfeits 11,150.00 .00 11,150.00 2,260.00 .00 10,539.00 611.00 95 12,797.72 Investment Income 7,200.00 .00 7,200.00 194.68 .00 3,951.62 3,248.38 55 6,327.62 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Financing Sources .00 .00 .00 (2,394.13) .00 38,236.49 (38,236.49) +++ 77,176.12 REVENUE TOTALS $1,398,850.00 $0.00 $1,398,850.00 $115,102.23 $0.00 $1,318,185.59 $80,664.41 94% $1,330,409.94 Fund 061 - Vehicle Replacement Fund Totals $1,398,850.00 $0.00 $1,398,850.00 $115,102.23 $0.00 $1,318,185.59 $80,664.41 $1,330,409.94 8 Account Classification Fund 062 - Computer Replacement Fund REVENUE Charges For Services Investment Income Other Financing Sources REVENUE TOTALS Fund 062 - Computer Replacement Fund Totals IV O Revenue Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD 272,307.00 .00 272,307.00 22,692.25 .00 249,614.75 22,692.25 92 21,164.00 1,000.00 .00 1,000.00 8.68 .00 420.02 579.98 42 690.66 .00 .00 .00 .00 .00 .00 .00 +++ .00 $273,307.00 $0.00 $273,307.00 $22,700.93 $0.00 $250,034.77 $23,272.23 91% $21,854.66 $273,307.00 $0.00 $273,307.00 $22,700.93 $0.00 $250,034.77 $23,272.23 $21,854.66 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 063 - Risk Management Fund REVENUE Charges For Services 6,513,826.00 .00 6,513,826.00 550,967.22 .00 5,999,550.09 514,275.91 92 5,929,634.87 Investment Income 3,000.00 .00 3,000.00 9.83 .00 1,039.55 1,960.45 35 2,087.16 Reimbursements 1,000.00 .00 1,000.00 .00 .00 859.40 140.60 86 .00 Other Revenue 1,463,700.00 .00 1,463,700.00 93,519.67 .00 1,189,662.19 274,037.81 81 1,200,162.19 REVENUE TOTALS Fund 063 - Risk Management Fund Totals IV $7,981,526.00 $0.00 $7,981,526.00 $644,496.72 $0.00 $7,191,111.23 $790,414.77 90% $7,131,884.22 $7,981,526.00 $0.00 $7,981,526.00 $644,496.72 $0.00 $7,191,111.23 $790,414.77 $7,131,884.22 Revenue Budget by Account Classification )L Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 070 - Police Pension Fund REVENUE Charges For Services .00 .00 .00 .00 .00 .00 .00 +++ .00 Investment Income 4,382,800.00 (2,175,000.00) 2,207,800.00 153,148.36 .00 1,446,838.06 760,961.94 66 3,986,884.90 Other Revenue 3,743,175.00 .00 3,743,175.00 62,876.86 .00 3,550,785.29 192,389.71 95 3,609,633.24 REVENUE TOTALS Fund 070 - Police Pension Fund Totals fV fV $8,125,975.00 ($2,175,000.00) $5,950,975.00 $216,025.22 $0.00 $4,997,623.35 $953,351.65 84% $7,596,518.14 $8,125,975.00 ($2,175,000.00) $5,950,975.00 $216,025.22 $0.00 $4,997,623.35 $953,351.65 $7,596,518.14 Revenue Budget by Account Classification IL Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget- YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrance Transactions Transactions Rec'd Prior Year YTD Fund 071 - Fire Pension Fund REVENUE Investment Income 4,250,500.00 (2,365,000.00) 1,885,500.00 (24,961.84) .00 20,120.54 1,865,379.46 1 2,608,325.27 Other Revenue 3,151,125.00 .00 3,151,125.00 48,033.01 .00 3,005,762.61 145,362.39 95 2,973,603.40 REVENUE TOTALS $7,401,625.00 ($2,365,000.00) $5,036,625.00 $23,071.17 $0.00 $3,025,883.15 $2,010,741.85 60% $5,581,928.67 Fund 071 - Fire Pension Fund Totals $7,401,625.00 ($2,365,000.00) $5,036,625.00 $23,071.17 $0.00 $3,025,883.15 $2,010,741.85 $5,581,928.67 Grand Totals $108,069,524.00 ($1,743,213.00) $106,326,311.00 $6,037,308.04 $0.00 $88,242,630.47 $18,083,680.53 $96,798,595.84 N W Account Classification Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 001 - General Fund EXPENSE Personal Services, Scheduled Salaries & Wages 24,232,037.00 317,674.00 24,549,711.00 1,781,562.57 .00 20,657,357.68 3,892,353.32 84 20,967,245.61 Employee Benefits 12,235,287.00 187,999.00 12,423,286.00 515,602.45 .00 11,581,817.25 841,468.75 93 11,742,854.25 Other Employee Costs 440,543.00 870.00 441,413.00 24,106.65 8,203.63 348,763.96 84,445.41 81 276,956.65 Pension Benefits 46,456.00 .00 46,456.00 3,871.28 .00 42,584.08 3,871.92 92 42,441.96 Contractual Services 7,528,869.00 235,603.00 7,764,472.00 560,954.60 229,104.07 6,302,944.70 1,232,423.23 84 6,408,746.64 Utilities 271,939.00 .00 271,939.00 22,838.32 .00 145,998.44 125,940.56 54 157,794.90 Insurance 415,398.00 .00 415,398.00 34,600.13 .00 380,543.24 34,854.76 92 321,318.52 Commodities & Supplies 641,996.00 14,893.00 656,889.00 37,645.13 32,089.97 443,616.85 181,182.18 72 513,869.21 Other Expenditures 11,140.00 33,632.00 44,772.00 5,133.06 .00 5,133.06 39,638.94 11 116,145.71 Building Improvements 10,200.00 .00 10,200.00 1,620.88 .00 8,774.11 1,425.89 86 7,376.54 Office Equipment 33,520.00 19,000.00 52,520.00 12,582.30 365.00 18,881.11 33,273.89 37 26,182.11 Other Equipment 184,199.00 12,305.00 196,504.00 16,796.39 24,343.04 144,306.67 27,854.29 86 131,168.30 Distribution Systems 100,000.00 .00 100,000.00 .00 805.10 99,152.70 42.20 100 49,227.30 Infrastructure 666,823.00 .00 666,823.00 10,615.80 128,416.29 267,485.06 270,921.65 59 346,259.78 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $46,818,407.00 $821,976.00 $47,640,383.00 $3,027,929.56 $423,327.10 $40,447,358.91 $6,769,696.99 86% $41,107,587.48 Fund 001 - General Fund Totals $46,818,407.00 $821,976.00 $47,640,383.00 $3,027,929.56 $423,327.10 $40,447,358.91 $6,769,696.99 $41,107,587.48 ON Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 002 -Debt Service Fund EXPENSE Contractual Services .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Bond Principal 1,893,913.00 1,155,000.00 3,048,913.00 2,907,581.42 .00 2,996,429.87 52,483.13 98 307,298.90 Interest Expense 1,382,571.00 413,356.00 1,795,927.00 891,585.50 .00 1,790,156.76 5,770.24 100 770,158.62 Bank & Fiscal Fees 2,312.00 500.00 2,812.00 .00 .00 3,715.14 (903.14) 132 1,686.20 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Financing Uses .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $3,278,796.00 $1,568,856.00 $4,847,652.00 $3,799,166.92 $0.00 $4,790,301.77 $57,350.23 99% $1,079,143.72 Fund 002 -Debt Service Fund Totals $3,278,796.00 $1,568,856.00 $4,847,652.00 $3,799,166.92 $0.00 $4,790,301.77 $57,350.23 $1,079,143.72 ON Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 020 - Capital Improvement Fund EXPENSE Contractual Services .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ 16,227.37 Land Improvements 350,000.00 236,250.00 586,250.00 895.07 393,280.81 48,093.32 144,875.87 75 .00 Building Improvements 896,000.00 555,440.00 1,451,440.00 12,345.07 149,335.49 957,567.09 344,537.42 76 345,275.40 Office Equipment .00 .00 .00 .00 .00 .00 .00 +++ .00 Motor Equipment .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Equipment 486,747.00 52,118.00 538,865.00 14,268.61 71,978.38 184,400.11 282,486.51 48 191,483.17 Infrastructure 503,000.00 284,861.00 787,861.00 37,264.85 95,484.09 146,684.72 545,692.19 31 70,895.89 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 W EXPENSE TOTALS $2,235,747.00 $1,128,669.00 $3,364,416.00 $64,773.60 $710,078.77 $1,336,745.24 $1,317,591.99 61% $623,881.83 Fund 020 - Capital Improvement Fund Totals $2,235,747.00 $1,128,669.00 $3,364,416.00 $64,773.60 $710,078.77 $1,336,745.24 $1,317,591.99 $623,881.83 Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 022 - Downtown Redevelopment Construct EXPENSE Contractual Services 109,201.00 90,000.00 199,201.00 6,338.17 11,172.15 132,347.07 55,681.78 72 180,196.24 Utilities .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Expenditures 3,306,969.00 710,000.00 4,016,969.00 2,713,410.28 .00 3,166,219.09 850,749.91 79 109,241.63 Infrastructure 342,285.00 3,675.00 345,960.00 63,477.31 1,783.81 71,877.31 272,298.88 21 16,775.75 Bond Principal .00 .00 .00 .00 .00 .00 .00 +++ .00 Interest Expense .00 .00 .00 .00 .00 .00 .00 +++ .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $3,758,455.00 $803,675.00 $4,562,130.00 $2,783,225.76 $12,955.96 $3,370,443.47 $1,178,730.57 74% $306,213.62 Fund 022 - Downtown Redevelopment Construct Totals $3,758,455.00 $803,675.00 $4,562,130.00 $2,783,225.76 $12,955.96 $3,370,443.47 $1,178,730.57 $306,213.62 wamePft",] Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 023 -Street Improvement Construc Fund EXPENSE Contractual Services 107,000.00 .00 107,000.00 511.00 5,352.00 84,564.00 17,084.00 84 88,056.29 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Land Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 Infrastructure 4,715,000.00 2,041,886.00 6,756,886.00 657,120.92 514,189.22 5,594,733.44 647,963.34 90 7,424,127.21 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $4,822,000.00 $2,041,886.00 $6,863,886.00 $657,631.92 $519,541.22 $5,679,297.44 $665,047.34 90% $7,512,183.50 Fund 023 -Street Improvement Construc Fund Totals $4,822,000.00 $2,041,886.00 $6,863,886.00 $657,631.92 $519,541.22 $5,679,297.44 $665,047.34 $7,512,183.50 ci Cn7 Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 024 - Flood Control Construction Fund EXPENSE Contractual Services 12,000.00 .00 12,000.00 .00 .00 .00 12,000.00 0 .00 Utilities 2,300.00 .00 2,300.00 169.57 .00 2,104.06 195.94 91 915.87 Commodities & Supplies 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 .00 Other Expenditures 5,100.00 .00 5,100.00 .00 .00 .00 5,100.00 0 .00 Other Equipment .00 .00 .00 .00 .00 .00 .00 +++ .00 Distribution Systems .00 .00 .00 .00 .00 .00 .00 +++ .00 Infrastructure 9,779,960.00 868,591.00 10,648,551.00 2,087,630.25 2,556,053.36 7,349,918.46 742,579.18 93 499,324.37 EXPENSE TOTALS $9,804,360.00 $868,591.00 $10,672,951.00 $2,087,799.82 $2,556,053.36 $7,352,022.52 $764,875.12 93% $500,240.24 Fund 024 - Flood Control Construction Fund Totals $9,804,360.00 $868,591.00 $10,672,951.00 $2,087,799.82 $2,556,053.36 $7,352,022.52 $764,875.12 $500,240.24 Cn7 v Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 040 - Refuse Disposal Fund EXPENSE Personal Services, Scheduled Salaries & Wages 236,644.00 .00 236,644.00 18,678.62 .00 213,904.70 22,739.30 90 218,420.82 Employee Benefits 110,436.00 .00 110,436.00 8,671.72 .00 103,756.20 6,679.80 94 97,815.86 Other Employee Costs 1,248.00 .00 1,248.00 .00 .00 .00 1,248.00 0 1,224.00 Contractual Services 4,294,934.00 4,742.00 4,299,676.00 314,830.67 9,200.00 3,528,222.68 762,253.32 82 3,584,354.27 Utilities 447.00 .00 447.00 22.69 .00 230.03 216.97 51 244.93 Insurance 31,809.00 .00 31,809.00 2,650.75 .00 29,158.25 2,650.75 92 26,253.37 Commodities & Supplies 38,446.00 .00 38,446.00 5,015.30 .00 36,466.23 1,979.77 95 36,289.84 EXPENSE TOTALS $4,713,964.00 $4,742.00 $4,718,706.00 $349,869.75 $9,200.00 $3,911,738.09 $797,767.91 83% $3,964,603.09 Fund 040 - Refuse Disposal Fund Totals $4,713,964.00 $4,742.00 $4,718,706.00 $349,869.75 $9,200.00 $3,911,738.09 $797,767.91 $3,964,603.09 v 0 Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 041 - Motor Fuel Tax Fund EXPENSE Contractual Services 284,686.00 .00 284,686.00 12,391.69 10,724.35 181,994.90 91,966.75 68 220,069.61 Utilities 156,060.00 .00 156,060.00 10,333.63 .00 156,060.00 .00 100 153,156.83 Commodities & Supplies 453,209.00 .00 453,209.00 52,912.50 178,765.14 274,443.86 .00 100 273,965.47 Building Improvements 600,000.00 .00 600,000.00 .00 .00 .00 600,000.00 0 .00 Infrastructure 663,000.00 .00 663,000.00 49.21 17,187.29 29,045.90 616,766.81 7 10,056.62 EXPENSE TOTALS $2,156,955.00 $0.00 $2,156,955.00 $75,687.03 $206,676.78 $641,544.66 $1,308,733.56 39% $657,248.53 Fund 041 - Motor Fuel Tax Fund Totals $2,156,955.00 $0.00 $2,156,955.00 $75,687.03 $206,676.78 $641,544.66 $1,308,733.56 $657,248.53 0 rR Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 042 - CDBG EXPENSE Personal Services, Scheduled Salaries & Wages 48,783.00 4,800.00 53,583.00 3,750.00 .00 45,199.24 8,383.76 84 41,620.81 Employee Benefits 25,491.00 919.00 26,410.00 2,094.19 .00 23,328.68 3,081.32 88 23,385.87 Other Employee Costs 1,040.00 .00 1,040.00 125.00 .00 258.32 781.68 25 178.32 Contractual Services 154,430.00 853.00 155,283.00 12,293.20 1,776.25 89,902.02 63,604.73 59 95,608.52 Commodities & Supplies 520.00 .00 520.00 .00 .00 .00 520.00 0 .00 Other Expenditures 189,000.00 6,955.00 195,955.00 .00 .00 46,985.00 148,970.00 24 43,064.00 Land Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 Building Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 Infrastructure .00 240,000.00 240,000.00 .00 .00 216,938.72 23,061.28 90 51,092.00 EXPENSE TOTALS $419,264.00 $253,527.00 $672,791.00 $18,262.39 $1,776.25 $422,611.98 $248,402.77 63% $254,949.52 Fund 042 - CDBG Totals $419,264.00 $253,527.00 $672,791.00 $18,262.39 $1,776.25 $422,611.98 $248,402.77 $254,949.52 Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 043 - Asset Seizure Fund EXPENSE Other Employee Costs 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Contractual Services 3,000.00 .00 3,000.00 .00 .00 2,000.00 1,000.00 67 6,000.00 Other Equipment 15,000.00 .00 15,000.00 .00 .00 7,043.89 7,956.11 47 1,859.57 EXPENSE TOTALS $19,000.00 $0.00 $19,000.00 $0.00 $0.00 $9,043.89 $9,956.11 48% $7,859.57 Fund 043 - Asset Seizure Fund Totals $19,000.00 $0.00 $19,000.00 $0.00 $0.00 $9,043.89 $9,956.11 $7,859.57 Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 044 - Federal Equitable Share Funds EXPENSE Contractual Services 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Building Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Equipment 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 EXPENSE TOTALS $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $0.00 Fund 044 - Federal Equitable Share Funds Totals $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 $0.00 fV Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 045 - DUI Fine Fund EXPENSE Other Employee Costs 1,000.00 .00 1,000.00 .00 .00 640.30 359.70 64 .00 Contractual Services .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Equipment 1,000.00 20,000.00 21,000.00 .00 8,749.23 11,832.50 418.27 98 2,767.30 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $2,000.00 $20,000.00 $22,000.00 $0.00 $8,749.23 $12,472.80 $777.97 96% $2,767.30 Fund 045 - DUI Fine Fund Totals $2,000.00 $20,000.00 $22,000.00 $0.00 $8,749.23 $12,472.80 $777.97 $2,767.30 fV Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 046 - Foreign Fire Tax Board Fund EXPENSE Contractual Services 10,000.00 .00 10,000.00 2,255.09 .00 9,743.97 256.03 97 3,967.27 Insurance 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Commodities & Supplies 5,000.00 .00 5,000.00 .00 .00 444.26 4,555.74 9 211.65 Other Equipment 15,000.00 .00 15,000.00 .00 .00 38,741.08 (23,741.08) 258 15,948.60 EXPENSE TOTALS $30,500.00 $0.00 $30,500.00 $2,255.09 $0.00 $48,929.31 ($18,429.31) 160% $20,127.52 Fund 046 - Foreign Fire Tax Board Fund Totals $30,500.00 $0.00 $30,500.00 $2,255.09 $0.00 $48,929.31 ($18,429.31) $20,127.52 Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 048 - Business District Fund EXPENSE Bond Principal .00 .00 .00 .00 .00 .00 .00 +++ .00 Interest Expense 1,021,000.00 .00 1,021,000.00 .00 .00 571,738.46 449,261.54 56 .00 EXPENSE TOTALS $1,021,000.00 $0.00 $1,021,000.00 $0.00 $0.00 $571,738.46 $449,261.54 56% $0.00 Fund 048 - Business District Fund Totals $1,021,000.00 $0.00 $1,021,000.00 $0.00 $0.00 $571,738.46 $449,261.54 $0.00 31 Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 050 - Water and Sewer Fund EXPENSE Personal Services, Scheduled Salaries & Wages 2,006,058.00 .00 2,006,058.00 151,868.59 .00 1,726,299.11 279,758.89 86 1,756,352.25 Employee Benefits 772,177.00 .00 772,177.00 61,327.96 .00 704,594.26 67,582.74 91 686,230.80 Other Employee Costs 37,393.00 .00 37,393.00 6,660.10 3,815.78 28,729.97 4,847.25 87 28,962.74 Contractual Services 8,650,244.00 (359,790.00) 8,290,454.00 709,943.46 149,778.11 7,342,941.40 797,734.49 90 6,744,385.01 Utilities 160,913.00 .00 160,913.00 9,814.87 .00 95,392.91 65,520.09 59 108,548.04 Insurance 101,312.00 .00 101,312.00 8,442.67 .00 92,869.32 8,442.68 92 73,767.76 Commodities & Supplies 293,516.00 .00 293,516.00 6,139.24 29,259.08 190,528.15 73,728.77 75 144,081.64 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Building Improvements 65,000.00 37,225.00 102,225.00 .00 49,700.00 49,458.64 3,066.36 97 1,350.00 Office Equipment 3,930.00 .00 3,930.00 .00 .00 .00 3,930.00 0 .00 Other Equipment 1,173,744.00 1,546,434.00 2,720,178.00 78,895.16 314,563.90 2,259,639.18 145,974.92 95 1,326,881.45 Distribution Systems 2,300,500.00 620,279.00 2,920,779.00 22,382.59 806,623.00 1,402,737.19 711,418.81 76 924,898.64 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 $15,564,787.00 $1,844,148.00 $17,408,935.00 $1,055,474.64 $1,353,739.87 $13,893,190.13 $2,162,005.00 88% $11,795,458.33 Fund 050 - Water and Sewer Fund Totals $15,564,787.00 $1,844,148.00 $17,408,935.00 $1,055,474.64 $1,353,739.87 $13,893,190.13 $2,162,005.00 $11,795,458.33 8 wamePft",] Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 051 - Village Parking System Fund EXPENSE Personal Services, Scheduled Salaries & Wages 35,175.00 .00 35,175.00 2,850.16 .00 30,342.14 4,832.86 86 32,156.17 Employee Benefits 17,353.00 .00 17,353.00 1,371.64 .00 14,845.55 2,507.45 86 14,664.00 Contractual Services 94,382.00 .00 94,382.00 4,200.25 1,371.30 67,504.67 25,506.03 73 66,694.14 Insurance 2,156.00 .00 2,156.00 179.67 .00 1,976.37 179.63 92 1,077.12 Commodities & Supplies 520.00 .00 520.00 .00 .00 .00 520.00 0 499.35 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Building Improvements 7,074.00 .00 7,074.00 .00 .00 3,500.00 3,574.00 49 2,103.47 Infrastructure 153,500.00 .00 153,500.00 .00 106,683.00 .00 46,817.00 70 36,121.53 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $310,160.00 $0.00 $310,160.00 $8,601.72 $108,054.30 $118,168.73 $83,936.97 73% $153,315.78 Fund 051 - Village Parking System Fund Totals $310,160.00 $0.00 $310,160.00 $8,601.72 $108,054.30 $118,168.73 $83,936.97 $153,315.78 Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 052 - Parking System Revenue Fund EXPENSE Personal Services, Scheduled Salaries & Wages 25,830.00 .00 25,830.00 2,075.70 .00 22,281.61 3,548.39 86 23,452.34 Employee Benefits 13,024.00 .00 13,024.00 1,012.95 .00 10,996.70 2,027.30 84 10,869.40 Contractual Services 114,325.00 .00 114,325.00 10,023.06 1,048.63 98,916.72 14,359.65 87 89,033.56 Utilities 10,733.00 .00 10,733.00 366.19 .00 4,906.49 5,826.51 46 5,718.16 Insurance 1,757.00 .00 1,757.00 146.42 .00 1,610.62 146.38 92 1,288.87 Commodities & Supplies 9,974.00 .00 9,974.00 .00 1,345.00 4,966.92 3,662.08 63 6,309.76 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Building Improvements 75,000.00 .00 75,000.00 .00 .00 .00 75,000.00 0 .00 Infrastructure .00 .00 .00 .00 .00 .00 .00 +++ .00 v Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $250,643.00 $0.00 $250,643.00 $13,624.32 $2,393.63 $143,679.06 $104,570.31 58% $136,672.09 Fund 052 - Parking System Revenue Fund Totals $250,643.00 $0.00 $250,643.00 $13,624.32 $2,393.63 $143,679.06 $104,570.31 $136,672.09 Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 060 - Vehicle Maintenance Fund EXPENSE Personal Services, Scheduled Salaries & Wages 951,226.00 .00 951,226.00 70,855.83 .00 828,298.10 122,927.90 87 833,757.40 Employee Benefits 379,364.00 .00 379,364.00 30,015.25 .00 319,426.18 59,937.82 84 326,689.29 Other Employee Costs 2,408.00 .00 2,408.00 .00 .00 1,737.33 670.67 72 2,359.00 Contractual Services 102,813.00 31,844.00 134,657.00 9,571.24 29,433.63 97,733.95 7,489.42 94 64,719.85 Utilities 3,132.00 .00 3,132.00 291.71 .00 3,013.12 118.88 96 2,016.85 Commodities & Supplies 735,223.00 7,295.00 742,518.00 37,611.08 126,895.64 470,074.01 145,548.35 80 589,420.46 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Office Equipment 567.00 .00 567.00 .00 .00 54.67 512.33 10 267.80 Other Equipment 20,165.00 .00 20,165.00 2,524.65 .00 19,790.37 374.63 98 17,603.63 EXPENSE TOTALS $2,194,898.00 $39,139.00 $2,234,037.00 $150,869.76 $156,329.27 $1,740,127.73 $337,580.00 85% $1,836,834.28 Fund 060 - Vehicle Maintenance Fund Totals $2,194,898.00 $39,139.00 $2,234,037.00 $150,869.76 $156,329.27 $1,740,127.73 $337,580.00 $1,836,834.28 8 Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 061 - Vehicle Replacement Fund EXPENSE Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Motor Equipment 909,000.00 273,406.00 1,182,406.00 186,863.27 54,575.89 636,185.85 491,644.26 58 1,099,578.57 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $909,000.00 $273,406.00 $1,182,406.00 $186,863.27 $54,575.89 $636,185.85 $491,644.26 58% $1,099,578.57 Fund 061 - Vehicle Replacement Fund Totals $909,000.00 $273,406.00 $1,182,406.00 $186,863.27 $54,575.89 $636,185.85 $491,644.26 $1,099,578.57 8 a Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 062 - Computer Replacement Fund EXPENSE Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Office Equipment 429,380.00 .00 429,380.00 53,954.16 552.80 162,479.74 266,347.46 38 140,812.99 EXPENSE TOTALS $429,380.00 $0.00 $429,380.00 $53,954.16 $552.80 $162,479.74 $266,347.46 38% $140,812.99 Fund 062 - Computer Replacement Fund Totals $429,380.00 $0.00 $429,380.00 $53,954.16 $552.80 $162,479.74 $266,347.46 $140,812.99 a N Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 063 - Risk Management Fund EXPENSE Contractual Services 25,000.00 .00 25,000.00 .00 9,500.00 12,150.00 3,350.00 87 10,300.00 Insurance 7,889,896.00 .00 7,889,896.00 582,034.67 .00 7,194,150.95 695,745.05 91 7,873,754.18 Other Equipment 165,000.00 .00 165,000.00 .00 .00 199.05 164,800.95 0 58.25 Infrastructure .00 .00 .00 .00 .00 .00 .00 +++ .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $8,079,896.00 $0.00 $8,079,896.00 $582,034.67 $9,500.00 $7,206,500.00 $863,896.00 89% $7,884,112.43 Fund 063 - Risk Management Fund Totals $8,079,896.00 $0.00 $8,079,896.00 $582,034.67 $9,500.00 $7,206,500.00 $863,896.00 $7,884,112.43 N Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 070 - Police Pension Fund EXPENSE Pension Benefits 4,472,170.00 107,133.00 4,579,303.00 377,910.66 .00 4,149,406.32 429,896.68 91 3,754,263.45 Contractual Services 154,100.00 .00 154,100.00 13,603.80 .00 98,628.72 55,471.28 64 109,139.96 Insurance 15,000.00 .00 15,000.00 .00 .00 12,558.00 2,442.00 84 11,960.00 Commodities & Supplies 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 Other Expenditures 12,000.00 .00 12,000.00 189.60 .00 9,558.02 2,441.98 80 8,702.84 Office Equipment .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $4,653,370.00 $107,133.00 $4,760,503.00 $391,704.06 $0.00 $4,270,151.06 $490,351.94 90% $3,884,066.25 Fund 070 - Police Pension Fund Totals $4,653,370.00 $107,133.00 $4,760,503.00 $391,704.06 $0.00 $4,270,151.06 $490,351.94 $3,884,066.25 N N N W Expense Budget by Account Classification Report Through 11/30/15 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 071 - Fire Pension Fund EXPENSE Pension Benefits 4,334,168.00 250,653.00 4,584,821.00 401,554.19 .00 4,190,300.77 394,520.23 91 3,797,908.68 Contractual Services 136,100.00 .00 136,100.00 11,090.75 .00 102,028.27 34,071.73 75 104,916.54 Insurance 15,000.00 .00 15,000.00 .00 .00 13,493.00 1,507.00 90 13,100.00 Commodities & Supplies 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Other Expenditures 12,000.00 .00 12,000.00 .00 .00 8,000.00 4,000.00 67 8,450.00 EXPENSE TOTALS $4,498,268.00 $250,653.00 $4,748,921.00 $412,644.94 $0.00 $4,313,822.04 $435,098.96 91% $3,924,375.22 Fund 071 - Fire Pension Fund Totals $4,498,268.00 $250,653.00 $4,748,921.00 $412,644.94 $0.00 $4,313,822.04 $435,098.96 $3,924,375.22 Grand Totals $115,972,850.00 ######### ########## $15,722,373.38 $6,133,504.43 ########## ######### $86,892,031.86 N W VILLAGE OF MOUNT PROSPECT List of Bills November 26 - December 9, 2015 Fund Vendor Name Invoice Description Amount 001 General Fund Bradley Peterson 2015 Fire Uniform Allowance $ 189.70 3CMA 3CMA Membership 390.00 A Stars & Stripes Flag Corporation Special Events Supplies 105.50 Aaron Grandgeorge 2015 Fire Uniform Allowance 54.75 ACS State & Local Government Solutions Illinois State Disbursement Unit 7,780.37 Air One Equipment, Inc. NY Hooks 308.00 Alexian Brothers Medical Center Pre -Employment Testing: K. Hegel 69.00 Alexian Brothers Medical Center Pre -Employment Testing: W. Eckert 108.00 Alexian Brothers Medical Center Pre -Employment Testing - K. Enderle 189.00 American Landscaping Inc. Remove boards on windows -Rt 12 230.00 American Landscaping Inc. 815 S Owen 330.00 Anderson Lock Company Maintenance and Repair Supplies 447.00 Anderson Lock Company Maintenance and Repair Supplies 18.50 Andres Medical Billing, Ltd. Ambulance Billing - November 2015 6,284.51 Aramark Uniform Services, Inc. Uniform Cleaning and Rental 94.54 Aramark Uniform Services, Inc. Uniform Cleaning and Rental 94.54 Ara mark Uniform Services, Inc. Uniform rental and cleaning for all public works employees 96.74 ARC Document Solutions, LLC Equipment Maintenance 62.00 Ariens Specialty Brands LLC Shipping Expenses 59.00 AT & T Service 11/10/15 - 12/9/15 3,636.19 AT & T Service 11/16/15 - 12/15/15 688.18 Avanti Cafe & Sandwich Bar, Inc. Holiday luncheon 487.00 Back On Track Fitness Inc. Preventative Maintenance on Fitness Repair -Stations 12,13,14 270.00 Bartlett Tree Experts Other Services 1,327.86 Base Online LLC/Brynjar Aclipen Plaque engraving for Station 13 bell 239.80 Bound Tree Medical, LLC. BP Cuffs, ECG paper 491.77 Brendan M. Keady 2015 Fire Uniform Allowance 59.50 Brian Lambel 2015 Fire Uniform Allowance 293.55 Brian R. Halverson 2015 Fire Uniform Allowance 448.25 Busse's Flowers & Gifts Office Supplies 80.00 Capital One National Association Costco Purchase 10/28/15 - 11/23/15 709.61 Capps Plumbing and Sewer Inc Refund Building Fee Permit #15-2262 (1405 Cottonwood Ln) 50.00 Cardno, Inc. Professional Services 539.36 Carol Baldini Reimbursement for refreshments for volunteers 11.25 Case Lots, Inc. Custodial supplies to be used in all buildings 1,988.45 CDW Government, Inc. Office Supplies 34.98 Century Cleaners Uniform Cleaning 46.03 Century Cleaners Uniform Cleaning 16.60 Century Cleaners Uniform Cleaning 15.28 Century Cleaners Uniform Cleaning 18.60 Century Cleaners Uniform Cleaning 12.45 Century Cleaners Uniform Cleaning 16.10 Century Cleaners Uniform Cleaning 23.75 Century Cleaners Uniform Cleaning 10.13 Charles M. Lindelof Membership Dues 61.50 Chem -wise Ecological Pest Mgmt Inc Pest control at Public Works for the month of November 215.00 Clesen Wholesale Inc. Grounds Beautification 330.90 Clifford -Wald & Co., Inc. - A KIP Company Color toner for printer 534.46 Comcast Office Equipment 13.64 Commonwealth Edison Electrical Service Delivery 39.87 Commonwealth Edison Electrical Service Delivery 48.32 Commonwealth Edison Electrical Service Delivery 65.44 Commonwealth Edison Electrical Service Delivery 791.12 Constellation NewEnergy, Inc. Electrical Service Delivery 75.20 Constellation NewEnergy, Inc. Electrical Service Delivery 2,608.80 Constellation NewEnergy, Inc. Electrical Service Delivery 111.92 Constellation NewEnergy, Inc. Electrical Service Delivery 111.72 Constellation NewEnergy, Inc. Electrical Service Delivery 127.21 Constellation NewEnergy, Inc. Electrical Service Delivery 106.20 Page 1 of 11 VILLAGE OF MOUNT PROSPECT List of Bills November 26 - December 9, 2015 Fund Vendor Name Invoice Description Amount Constellation NewEnergy, Inc. Electrical Service Delivery 68.87 Constellation NewEnergy, Inc. Electrical Service Delivery 105.51 Constellation NewEnergy, Inc. Electrical Service Delivery 242.42 Constellation NewEnergy, Inc. Electrical Service Delivery 118.52 Constellation NewEnergy, Inc. Electrical Service Delivery 155.41 Constellation NewEnergy, Inc. Electrical Service Delivery 37.93 Constellation NewEnergy, Inc. Electrical Service Delivery 75.79 Constellation NewEnergy, Inc. Electrical Service Delivery 101.37 Constellation NewEnergy, Inc. Electrical Service Delivery 75.47 Constellation NewEnergy, Inc. Electrical Service Delivery 70.34 Constellation NewEnergy, Inc. Electrical Service Delivery 139.14 Constellation NewEnergy, Inc. Electrical Service Delivery 76.18 Constellation NewEnergy, Inc. Electrical Service Delivery 245.23 Constellation NewEnergy, Inc. Electrical Service Delivery 130.33 Constellation NewEnergy, Inc. Electrical Service Delivery 115.08 Constellation NewEnergy, Inc. Electrical Service Delivery 35.09 Constellation NewEnergy, Inc. Electrical Service Delivery 168.98 Costar Realty Information, Inc. Costar 542.09 Crain Communications Inc. 2016 publication renewal 119.00 Crain Communications Inc. Office Supplies 119.00 Crystal Maintenance Services Corp. Custodial Services 7,187.24 Dane R. Phenegar 2015 Fire Uniform Allowance 116.90 David L. Miller 2015 Fire Uniform Allowance 127.00 David Novak Transfer Stamp Rebate 945.00 David Zboril Reimburse training expenses 128.00 De Lage Landen Financial Services, Inc. CCC 260.55 De Lage Landen Financial Services, Inc. Copier Lease Payment 1,690.20 Dow Jones & Co., Inc. The Wall Street Journal Subscription (6 months) 2016 197.94 Elite Remodeling Group, Inc. Garnishment 142.22 Elk Grove Township Fire Dept. ARC Annexation Agreement 2015 33,631.20 Eric Schmitt 2015 Fire Uniform Allowance 350.00 Eric Schmitt Reimbursement for Boater Education Certificate -Schmitt 29.50 Fawley's Inc. 6 Fireman ID Tags & 3 Name Plates 56.40 Fire Department Training Network, Inc. Department Membership -2015/2016 240.00 Fire Pension Fund Fire Pension 29,212.51 Firefighting Services LLC Ghawaly/5.13.15/Company Officer Leadership Training 99.00 Fleck's Landscaping Parkway Restoration 2,414.25 Fleck's Landscaping Stump Removal 7,979.25 Frederick Rasmussen Refund Overpayment Police Ticket #P3942413 50.00 G & J Associates, Inc. Special Events Supplies 3,296.50 Gambino Landscaping and Brick Paving, Inc. Sprinkler Maintenance 595.00 Garvey's Office Products Office Supplies 189.26 Garvey's Office Products Office Supplies 108.14 Gewalt Hamilton Assoc. Records Management 2,550.00 Grainger Inc. Maintenance and Repair Supplies 313.50 Guardian Emp. Dental Plan December 2015 10,156.28 Hastings Air Energy Control Inc. Plymovent Boots 901.38 Healy Asphalt Company,llc. Streets Patching Materials 382.52 Herrera Landscape, Inc. Grounds Maintenance 3,834.03 Herrera Landscape, Inc. Grounds Maintenance 45.60 Home Depot U.S.A., Inc. November Home Depot Supply Statement 59.73 Homer Tree Care, Inc. Tree Removals 4,463.95 Homer Tree Care, Inc. Tree Removals 3,061.20 Homer Tree Care, Inc. Tree Removals 2,742.60 Howard Kleinstein Reimbursements 306.28 ICMA Retirement Trust - 457 ICMA 457 22,419.26 Illinois Department of Revenue STATE - IL - IL State Withholding 73.87 Illinois Department of Revenue IL State Withholding 34,750.38 Illinois Municipal League 2016 membership dues 3,500.00 Illinois Society of Fire Service Instructors Mandatory Training Manager Course-Wilson-Nov.16-20 300.00 Page 2 of 11 VILLAGE OF MOUNT PROSPECT List of Bills November 26 - December 9, 2015 Fund Vendor Name Invoice Description Amount Illinois State Police Pre -Employment Testing: K. Hegel 29.75 Illinois State Police New Hire Background Checks -Eckert, Wojnowski, OSullivan, Gabl 119.00 Internal Revenue Service Federal Withholding 375.97 Internal Revenue Service Federal Withholding 458.45 Internal Revenue Service Federal Withholding 235,503.87 International Union of Operating Engineers IUOE PW Membership Dues 994.21 James East 2015 Fire Uniform Allowance 288.12 James Kuhar 2015 Fire Uniform Allowance 55.90 Janet Abernethy Reimbursement for Ethics and Risk Management class 39.00 Jeff Bondora Transfer Stamp Rebate 1,000.00 Jeffrey Wulbecker Safety Shoe Allowance 115.27 John Dolan 2015 Fire Uniform Allowance 82.80 Joseph Knoll 2015 Fire Uniform Allowance 144.69 Joseph Reschke 2015 Fire Uniform Allowance 169.20 Julie K Kane Reimbursement for Coffee w/Council refreshements 22.61 Julie K Kane Reimbursement for Interfaith Council Meeting 77.27 June Kerstein Reimbursement Food Exp - November 2015 29.27 Karlstedt Landscape Group, Inc. Parkway restoration 268.10 Karlstedt Landscape Group, Inc. Parkway restoration 281.04 Kenneth S. Dix 2015 Fire Uniform Allowance 448.39 Kinnucan Holiday Decoration Lights 37,423.30 Klein, Thorpe and Jenkins, Ltd. Legal 65.52 Klein, Thorpe and Jenkins, Ltd. October billing 49,783.36 Kyle Laurinaitis 2015 Fire Uniform Allowance 210.75 Lands' End Business Outfitters Logowear 139.80 Lands' End Business Outfitters Building VOMP clothes 719.91 Lands' End Business Outfitters Clothing for the MP MRC 263.85 Lands' End Business Outfitters Caps for Employee Go -Kits 25.00 Laner Muchin October billing 2,605.95 Life Assist Glucometers 266.46 Lindco Equipment Sales, Inc. Salt Spreader Parts 1,821.96 Lukasz Misiejuk 2015 Fire Uniform Allowance 233.20 M Lopez Concrete Inc Refund Building Fee Permit#15-1989 (622 S Albert St) 50.00 Matt Woleben 2015 Fire Uniform Allowance 129.99 MECO Consulting LLC Professional Services 964.00 MECO Consulting LLC Professional Services 499.95 Menard Inc. Special Events Supplies 151.16 Metro Federal Credit Union MP Fire Local 4119 Dues 2,200.77 Metropolitan Alliance - Police MP Police Association Dues 1,380.50 Meyer Laboratory, Inc. Custodial Supplies 1,290.15 Michael J Laturno Transfer Stamp Rebate 590.00 Michael B. Fonseca 2015 Fire Uniform Allowance 387.40 Michael C. Hayes 2015 Fire Uniform Allowance 230.80 Michael Ghawaly 2015 Fire Uniform Allowance 341.45 Michael Wagner & Sons, Inc. Maintenance and Repair Supplies 82.67 Micro Tech Systems, Inc. Tech support for BC printer 216.20 Mobile Print Inc. Business Cards & Notepads- Eckert 76.05 Mokijewski, Maxwell CDL Reimbursement 30.00 Municipal Emergency Services, Inc. Liebgott & McCrory Turn -Out Gear 333.80 Municipal Emergency Services, Inc. Liebgott & McCrory Turn -Out Gear 26.00 Municipal Emergency Services, Inc. New Officer Name Tags for Turn Out Gear 158.00 Nationwide Mutual Insurance Company Nationwide 457 12,167.24 NCPERS Group Life Ins. IMRF Life Insurance 617.60 Neopost USA Inc. Postage Machine Replenishment - 11/25 3,000.00 NICOR Natural Gas Consumption 34.55 NICOR Natural Gas Consumption 46.71 NICOR Natural Gas Consumption 39.91 NICOR Natural Gas Consumption 1,569.78 NICOR Natural Gas Consumption 377.25 NICOR Natural Gas Consumption 1,352.22 Page 3 of 11 VILLAGE OF MOUNT PROSPECT List of Bills November 26 - December 9, 2015 Fund Vendor Name Invoice Description Amount NICOR Natural Gas Consumption 185.09 Nina Persino Reimbursement for Professional License 61.50 Northshore University Healthsystem Medical exam: M. Angarola 496.00 Northwest Central Dispatch System January 2016 - Member Assessment 56,340.50 Northwest Community Hospital New Hire Physicals-Filpi & Kincaid 1,904.00 Northwest Suburban United Way United Way 139.86 Nova Fire Protection, Inc. Sprinkler repairs made in the EOC 880.00 Office Depot Office Supplies - November 2015 118.66 Paddock Publications, Inc. Legal notice 302.40 Paddock Publications, Inc. Annexation legal notice 113.40 Patrick B. Clarke 2015 Fire Uniform Allowance 67.99 Patrick B. Clarke 2015 Fire Uniform Allowance 378.34 Paula Randant Reimbursement - Sister Cities - Wine Tasting 78.99 Peggy Ann Kerr Transfer Stamp Rebate 300.00 Petty Cash Petty Cash 295.25 Philip A. Wnek 2015 Fire Uniform Allowance 232.20 Philip A. Wnek Reimbursement for Boater Education Certificate-Wnek 29.50 Phillip Buffalo 2015 Fire Uniform Allowance 29.95 Police Pension Fund Police Pension 36,047.21 Proforma Customized Graphics Uniforms 510.30 Randi Lamb Refund Driveway Permit #14-0530 (1000 n Prospect Manor Ave) 25.00 Raymar Hydraulic Salt spreader auger motors 1,266.65 RC Topsoil Inc. EAB Ash Reduction 660.00 Reliance Standard Life Insurance Co. Short Term Disability 2,930.96 Richard Christensen 2015 Fire Uniform Allowance 61.73 Ronald Redlin 2015 Fire Uniform Allowance 97.95 Ronco Industrial Supply Cleaning supplies to be used in all buildings 485.97 Ronco Industrial Supply Degreaser to be used in all buildings 215.61 Ryan Kast Reimbursement for Holiday Grab Bag for 2015 Luncheon 150.00 Scott Skindingsrude 2015 Fire Uniform Allowance 447.28 Sean Dorsey Travel and Meeting Expenses 22.52 Sean Dorsey Travel and Meeting Expenses 332.00 SHI International Corp. Logitech Type + Keyboard/Case for iPad Air 162.00 Sigman, Christian Reimbursement - Expenses for Village Manager Candidate 657.53 Sound Incorporated Phone System Monthly Support 828.83 Sound Incorporated Akkadian Telephone Console Support/Maintenance 2,250.00 South Side Control Supply Company Maintenance and Repair Supplies 716.59 State of Illinois Internet Service 724.00 Steiner Electric Company Street Light Supplies 391.28 Steve Slobe 2015 Fire Uniform Allowance 263.72 Swat, Kevin 2015 Fire Uniform Allowance 237.67 Taylor Rental Center Custodial Supplies 721.62 Tennant Sales and Service Company Floor Scrubber Maintenance/Repair 366.50 Tennant Sales and Service Company Floor Scrubber Maintenance/Site Visit 353.00 Teresa Vanopdorp Special Event Supplies 71.72 The Carroll -Keller Group Bertolucci training 245.00 The Carroll -Keller Group Bertolucci training 245.00 The Manfred Group, LLC Tree Donor Cutting Ceremony Photos Video 2015 110.00 The Savanna Group, Inc. Professional Services 1,800.00 Thompson Elevator Inspections Elevator inspection -various adderesses 925.00 Thompson Elevator Inspections Elevator inspection -ca rson piere scott 75.00 Thompson Elevator Inspections Elevator inspection -various addresses 296.00 Tim Skalon 2015 Fire Uniform Allowance 126.05 Township High School Dist. 214 Special Events Supplies 360.00 Tri-state Electronic Corp Maintenance and Repair Supplies 274.65 U.S. Bank Equipment Finance, Inc. Copier Lease #500-0413635-000 & 500-0431295-000 2,410.85 United Health Care Insurance Company Refund for Ambulance Serv.11/9/13,5/29/14&7/19/14 511.09 United Healthcare Refund for Ambulance Service 8/3/15 145.73 VCG Uniform B/C Wilson Uniform 605.80 VCG Uniform FF/PM Inital Issue -Seth McCrory 1,595.40 Page 4 of 11 VILLAGE OF MOUNT PROSPECT List of Bills November 26 - December 9, 2015 Fund Vendor Name Invoice Description Amount VCG Uniform FF/PM Inital Issue -John Liebgott 1,598.95 Vera Micic Rebate 2015 Property Tax Relief Grant 100.00 Verizon Wireless Services LLC Cellular Service & Equipment Charges - 10/20-11/19 7,366.46 Victoria A. Bran Reimbursement for Prof License 61.50 Village of Mount Prospect Flex - Medical 9,068.39 Wal-Mart Community Office Supplies 5.38 Warehouse Direct Replacement toner for defective toner cartridge 160.69 Warehouse Direct Credit for defective toner cartridge (160.69) Warehouse Direct Office supplies 253.81 Warehouse Direct Photo evidence supplies 232.08 Wendy Seleen HIPAA Update Training 199.00 Wide Open West Fire Main - Data & Internet Services (T1) 11/20/15-12/19/15 233.00 Wide Open West Fire ST#14 - Data & Internet Services (T1) 11/20/15-12/19/15 233.00 William J. Cooney Mileage reimbursement 175.15 Willkalt LLC Strategic planning meeting 248.00 Wisconsin Department of Revenue WI State Withholding 631.35 WISCTF Garnishment 542.48 Wolf, Lisa Truco & Emerson's interviews 800.00 Wolf, Lisa Photos interview 400.00 Z Search Recruiting, Inc. Treelighting 2015 Photographs 200.00 Z Search Recruiting, Inc. Photographic Services 2,805.00 001 General Fund Total $ 725,552.04 002 Debt Service Fund Bank of New York Mellon Bank of New York Mellon Bank of New York Mellon Bank of New York Mellon Bank of New York Mellon Glenview State Bank Illinois EPA Illinois EPA J.P. Morgan Chase Bank N.A. J.P. Morgan Chase Bank N.A. J.P. Morgan Chase Bank N.A. Wells Fargo Bank 002 Debt Service Fund Total 020 Capital Improvement Fund American Building Services American Building Services American Building Services B & H Photo/video Business Office Systems, Inc. Business Office Systems, Inc. Full Compass Systems Ltd. Gewalt Hamilton Assoc. Howard Kleinstein Marvin Feig and Associates, LTD. Northwest Central 9-1-1 System Olsson Roofing Companry, Inc. Parenti & Raffaelli,ltd. 020 Capital Improvement Fund Total G.O. Bond Series 2014 - Principal & Interest G.O. Refunding Bond Series 2009B - Principal & Interest G.O. Bond Series 2009 - Interest Only G.O. Bond Series 2013 - Interest Only G.O. Bond Series 2009C - Principal & Interest G.O. Installment Note 2012 - Principal & Interest IEPA #4 L17-0855 Principal & Interest IEPA Loan #5 L17-1087 Principal & Interest G.O Refunding Bond Series 2012 - Interest Only G.O. Refunding Bond Series 2011B - Principal & Interest G.O. Bond Series 2011A - Library G.O. Bonds Series 2006 - Library Replacement of PW office door Replacement of PW office door Replacement of PW office door Boardroom Upgrade Equipment Office Furniture Office Furniture Boardroom Upgrade Equipment Engineering Design services Reimbursements Solar shades installed at Public Works Motorola Subscriber Financing - December 2015 Roofing contract for PW File top installed in the Village Hall 022 Downton Redevelopment Construction Fund Gewalt Hamilton Assoc. 83 & Busse crossing V3 Companies Central Plaza Remediation & SRP Valerio Dewalt Train Associates, Inc. Dowtown wayfinding 022 Downton Redevelopment Construction Fund Total Page 5 of 11 $ 379,625.00 344,175.00 208, 631.25 184,978.13 107,136.25 410, 647.00 40, 376.29 58,252.79 27,047.50 734,873.00 1,115,968.75 245, 708.75 $ 3,857,419.71 $ 2,100.67 2,262.10 7,880.30 1,419.86 6,057.91 1,149.76 376.00 10, 502.01 92.54 2,557.00 10, 603.91 1,215.00 750.00 $ 46,967.06 $ 3,959.55 16,045.43 11, 633.28 $ 31,638.26 VILLAGE OF MOUNT PROSPECT List of Bills November 26 - December 9, 2015 Fund Vendor Name Invoice Description $ Amount 023 Street Improvement Construction Fund Service 11/16/15 - 12/15/15 3.83 Ciorba Group Inc Traffic Improvement $ 3,386.16 Ciorba Group Inc 2015 Bridge Inspections 2,382.68 Rubino Engineering, Inc. Resurfacing Testing 511.00 023 Street Improvement Construction Fund Total IL State Withholding $ 6,279.84 024 Flood Control Construction Fund Federal Withholding 4,441.70 A Lamp Concrete Isabella Drainage Improvements Project $ 1,626,280.06 Burns & Mcdonnell Engineering Co. Engineering Service 129,023.41 Canyon Contracting Inc. Flood Control 72,835.20 Cardno, Inc. Professional Services 4,073.74 Cardno, Inc. Creek Bank Stabilization $ 834.00 Cardno, Inc. Professional Services 1,105.53 Constellation NewEnergy, Inc. Electrical Service Delivery $ 87.77 Constellation NewEnergy, Inc. Electrical Service Delivery 81.80 Rubino Engineering, Inc. Isabella Combined Sewer Project 1,002.00 024 Flood Control Construction Fund Total Thermapoint anticing liquid used for snow and ice control $ 1,835,323.51 040 Refuse Disposal Fund AT & T Service 11/10/15 - 12/9/15 $ 20.03 AT & T Service 11/16/15 - 12/15/15 3.83 Botts Welding & Truck Service, Inc. Equipment Maintenance and Repair 25.59 Elgin Sweeping Services Inc Street Sweeper 8,160.00 ICMA Retirement Trust - 457 ICMA 457 70.51 Illinois Department of Revenue IL State Withholding 471.53 Internal Revenue Service Federal Withholding 4,441.70 International Union of Operating Engineers IUOE PW Membership Dues 104.10 Nationwide Mutual Insurance Company Nationwide 457 379.92 NCPERS Group Life Ins. IMRF Life Insurance 17.60 Village of Mount Prospect Flex - Medical 71.88 040 Refuse Disposal Fund Total $ 13,766.69 041 Motor Fuel Tax Fund Lyons & Pinner Electric Companies Traffic Light Maintenance $ 13,925.60 Morton Salt, Inc Salt/De-Icing Agents 25,742.88 Morton Salt, Inc Salt/De-Icing Agents 9,722.45 SNI Solutions, Inc. Thermapoint anticing liquid used for snow and ice control 3,733.54 SNI Solutions, Inc. Street Salt Calcium Chlorde 3,739.86 041 Motor Fuel Tax Fund Total $ 56,864.33 042 Community Development Block Grant De Lage Landen Financial Services, Inc. Copier Lease Payment $ 94.80 ICMA Retirement Trust - 457 ICMA 457 450.00 Illinois Department of Revenue IL State Withholding 56.83 Internal Revenue Service Federal Withholding 556.64 Northwest Compass, Inc. CDBG PY2015 public facility rehab 12,140.00 Paddock Publications, Inc. CDBG PY2015 Legal Notice 51.30 Village of Mount Prospect Flex - Medical 31.25 042 Community Development Block Grant Total $ 13,380.82 050 Water and Sewer Fund All Star Power Wash II Inc. Building Maintenance $ 5,117.00 Aramark Uniform Services, Inc. Uniform Cleaning and Rental 94.54 Aramark Uniform Services, Inc. Uniform Cleaning and Rental 94.54 Aramark Uniform Services, Inc. Uniform rental and cleaning for all public works employees 96.74 AT & T Service 11/10/15 - 12/9/15 1,292.91 AT & T Service 11/10/15 - 12/9/15 689.49 AT & T Service 11/10/15 - 12/9/15 1,337.15 AT & T Service 11/16/15 - 12/15/15 255.56 Baxter & Woodman, Inc. Professional Services 1,675.00 Page 6 of 11 VILLAGE OF MOUNT PROSPECT List of Bills November 26 - December 9, 2015 Fund Vendor Name Invoice Description Amount Baxter & Woodman, Inc. Professional Services 718.75 Burns & Mcdonnell Engineering Co. Emergency Generators 7,453.00 Cardinal Fence & Supply Inc. Repair split rail fence along Weller Creek/flood damage 508.00 Century Cleaners Uniform Cleaning 46.02 Century Cleaners Uniform Cleaning 16.60 Century Cleaners Uniform Cleaning 15.27 Century Cleaners Uniform Cleaning 18.60 Century Cleaners Uniform Cleaning 12.45 Century Cleaners Uniform Cleaning 16.10 Century Cleaners Uniform Cleaning 23.75 Century Cleaners Uniform Cleaning 10.12 Evelyn Ceglarek Utility Refund 20.83 Garvey's Office Products Office Supplies 38.76 HBK Water Meter Service Meter Installation AMR 808.85 HBK Water Meter Service Meter Installation AMR 84.00 Huntington Commons Master Association Utility Refund 18,705.61 ICMA Retirement Trust - 457 ICMA 457 1,437.27 Illinois Department of Revenue IL State Withholding 3,310.61 Internal Revenue Service Federal Withholding 29,620.79 International Union of Operating Engineers IUOE PW Membership Dues 975.80 James Atha ns Utility Refund 40.93 Jeffrey Wulbecker Safety Shoe Allowance 3.25 John Schnittker Uniform Expense 130.80 Karlstedt Landscape Group, Inc. Parkway restoration 2,530.40 Karlstedt Landscape Group, Inc. Parkway restoration 2,652.56 Lands' End Business Outfitters Replacement Garments 1,656.75 Lands' End Business Outfitters Uniform Expense 154.75 MECO Consulting LLC Professional Services 271.00 MECO Consulting LLC Professional Services 1,000.05 Mount Prospect Park Districtu Utility Refund 2,010.05 Nationwide Mutual Insurance Company Nationwide 457 340.89 NCPERS Group Life Ins. IMRF Life Insurance 44.80 NICOR Natural Gas Consumption 83.65 NICOR Natural Gas Consumption 119.01 Northwest Suburban United Way United Way 21.00 Paddock Publications, Inc. Bid Notice 129.60 Proforma Customized Graphics Uniforms 1,329.86 Red Wing Shoe Store Safety Shoe Allowance 8.00 Reliance Standard Life Insurance Co. Short Term Disability 118.92 Tank Industry Consultants, Inc. Water distribution tank repair 2,650.00 Tank Industry Consultants, Inc. Tank Repair 629.88 Third Millennium Assoc.inc. November Utility Billing w/Insert 3,311.61 U.S. Bank Equipment Finance, Inc. Copier Lease #500-0413635-000 & 500-0431295-000 297.00 Verizon Wireless Services LLC Cellular Service & Equipment Charges - 10/20-11/19 430.57 Village of Mount Prospect Flex - Medical 715.03 Wal-Mart Community Office Supplies 98.00 William Plath Utility Refund 133.09 050 Water and Sewer Fund Total $ 95,405.56 051 Village Parking System Fund Crystal Maintenance Services Corp. Custodial Services $ 330.23 Elite Remodeling Group, Inc. Garnishment 78.19 ICMA Retirement Trust - 457 ICMA 457 8.99 Illinois Department of Revenue IL State Withholding 55.40 Internal Revenue Service Federal Withholding 471.25 International Union of Operating Engineers IUOE PW Membership Dues 16.07 Nationwide Mutual Insurance Company Nationwide 457 9.96 NCPERS Group Life Ins. IMRF Life Insurance 4.40 Village of Mount Prospect Flex - Medical 34.64 051 Village Parking System Fund Total $ 1,009.13 Page 7 of 11 VILLAGE OF MOUNT PROSPECT List of Bills November 26 - December 9, 2015 Fund Vendor Name Invoice Description Amount 052 Parking System Revenue Fund Crystal Maintenance Services Corp. Custodial Services Elite Remodeling Group, Inc. Garnishment ICMA Retirement Trust - 457 ICMA 457 Illinois Department of Revenue IL State Withholding Internal Revenue Service Federal Withholding International Union of Operating Engineers IUOE PW Membership Dues Nationwide Mutual Insurance Company Nationwide 457 NCPERS Group Life Ins. IMRF Life Insurance NICOR Natural Gas Consumption Village of Mount Prospect Flex - Medical 052 Parking System Revenue Fund Total 060 Vehicle Maintenance Fund Addison Building Material Co. Vehicle Maintenance Supplies Alpha Prime Communications Radio Equipment American Messaging Pager rental Arlington Heights Ford P-18 left front seat belt buckle Arlington Heights Ford 2743 drivers seat cushion and cover Arlington Heights Ford P-12 front brake calipers Arlington Heights Ford P-18 windshield washer hoses and nozzles Arlington Heights Ford P-5 rearwiperarm Arlington Heights Ford P-15 drivers seat lumbar support Arlington Heights Ford Vehicle Maintenance Supplies Arlington Heights Ford Vehicle Maintenance Supplies Arlington Heights Ford Equipment Maintenance and Repair Arlington Heights Ford Vehicle Maintenance Supplies Arlington Heights Ford Vehicle Maintenance Supplies Arlington Heights Ford Vehicle Maintenance Supplies Arlington Power Equipment Vehicle Maintenance Supplies Arlington Power Equipment Vehicle Maintenance Supplies Arlington Power Equipment Vehicle Maintenance Supplies AT & T Service 11/10/15 - 12/9/15 AT & T Service 11/16/15 - 12/15/15 Atlas First Access, LLC Vehicle Maintenance Supplies Atlas First Access, LLC Vehicle Maintenance Supplies Botts Welding & Truck Service, Inc. Equipment Maintenance and Repair BP Gas Purchased 11/20/15 Brett Equipment Vehicle Maintenance Supplies Bridgestone Retail Operations, LLC. Vehicle Maintenance Supplies Chicago Parts & Sound Llc 526 front brake pads and grease seals Chicago Parts & Sound Llc P-12 A/C condensor Chicago Parts & Sound Llc Wiper blades David Ristow Tool Allowance Garvey's Office Products Office Supplies General Parts Inc. Fuel filters, tire valves and brake hardware kit General Parts Inc. Salt spreader bulbs General Parts Inc. P-11 rear axle bearings and seals General Parts Inc. P-19 hood struts Grossinger Chevrolet S-41 extra ignition keys Grossinger Chevrolet Equipment Maintenance and Repair Helm Inc. Professional Services ICMA Retirement Trust - 457 ICMA 457 Illinois Department of Revenue IL State Withholding Internal Revenue Service Federal Withholding International Union of Operating Engineers IUOE PW Membership Dues Interstate Power Systems, Inc. Vehicle Maintenance Supplies James Breitzman Tool Allowance John Mark Tool Allowance Page 8 of 11 9 252.53 64.02 6.01 40.36 341.37 10.71 6.65 3.60 91.34 27.44 844.03 4.44 24.00 79.67 234.64 368.40 262.76 57.56 9.73 53.28 (100.00) 145.05 132.79 263.04 55.82 158.22 58.40 24.44 11.96 50.08 9.57 330.67 682.47 1,470.11 19.80 266.47 498.64 85.80 256.49 275.20 1,140.00 108.14 36.89 43.64 57.30 32.74 44.74 171.98 650.00 1,500.87 1,602.99 14, 340.39 501.02 481.86 232.06 1,122.96 VILLAGE OF MOUNT PROSPECT List of Bills November 26 - December 9, 2015 Fund Vendor Name Invoice Description Amount K & K Sales & Services Inc Equipment Maintenance 500.00 Kevin Krotky Tool Allowance 1,140.00 Leach Enterprises, Inc. Vehicle Maintenance Supplies 7.20 Lindco Equipment Sales, Inc. Vehicle Maintenance Supplies (55.70) Mansfield Oil Company 6,502 gallons diesel fuel 12,255.00 Mcmaster-carr Supply Co. Stainless hex head bolts 29.48 Mcmaster-carr Supply Co. Chain links 133.89 Morton Grove Automotive Rebuild Ford truck alternator 110.00 Napa -Heights Automotive Supply Vehicle Maintenance Supplies (42.68) Napa -Heights Automotive Supply Snow blower spark plugs 21.44 Napa -Heights Automotive Supply Vehicle Maintenance Supplies 46.32 Napa -Heights Automotive Supply Thread lock selant 27.98 Napa -Heights Automotive Supply P-7 rear axle lock bolt 2.88 Napa -Heights Automotive Supply Rear axle lock bolt 5.76 Napa -Heights Automotive Supply 506 radiator cap 10.98 NCPERS Group Life Ins. IMRF Life Insurance 48.00 Nichols, Keith Tool Allowance 1,140.00 Nichols, Keith Training Expenses 73.00 Northwest Suburban United Way United Way 4.00 Pomp's Tire Service, Inc. 4504 flat repair 45.00 Precision Service & Parts Vehicle Maintenance Supplies 158.84 Professional Finish Inc. Vehicle Maintenance Supplies 490.78 Raymar Hydraulic Salt spreader auger motors 0.25 Reliance Standard Life Insurance Co. Short Term Disability 97.34 Ronco Industrial Supply Vehicle Maintenance Supplies 270.85 Ronco Industrial Supply Vehicle Maintenance Supplies 8.85 Ronco Industrial Supply Vehicle Maintenance Supplies 78.00 Ronco Industrial Supply Vehicle Maintenance Supplies 181.25 Rush Truck Centers of Illinois, Inc. Vehicle Maintenance Supplies 52.77 Rush Truck Centers of Illinois, Inc. 4528 crank and cam sensor 172.96 Rush Truck Centers of Illinois, Inc. International pre -air filters 315.32 Rush Truck Centers of Illinois, Inc. Fuel filter screens 108.92 Rush Truck Centers of Illinois, Inc. 4528 cab height valve 121.91 Rush Truck Centers of Illinois, Inc. Leaf trucks pre -cabin filters 121.42 Rush Truck Centers of Illinois, Inc. Leaf trucks fuel filters 356.14 Rush Truck Centers of Illinois, Inc. 4513 upper radiator hose 17.11 Rush Truck Centers of Illinois, Inc. 2728 tie rod boot 16.89 Rush Truck Centers of Illinois, Inc. International plow mirror brackets 109.94 Rush Truck Centers of Illinois, Inc. 4528 highway truck EGR coolers and coolant switch 3,239.71 Rush Truck Centers of Illinois, Inc. International mirror bracket 178.92 Rush Truck Centers of Illinois, Inc. Seat belt assembly 248.56 Rush Truck Centers of Illinois, Inc. Washer tank caps 13.67 Rush Truck Centers of Illinois, Inc. 4522 washer tank cap 13.67 Shelby Mazursky Printing Expenses 749.00 Sid Tool Co., Inc. Machine screws, washers, elctrical connectors and cable ties 489.15 Sid Tool Co., Inc. Vehicle Maintenance Supplies 187.34 Sid Tool Co., Inc. Vehicle Maintenance Supplies 174.60 Solvent Systems Int'I. Inc. Parts washer rental 185.64 Terrace Supply Company Gas tank rental 25.50 Triangle Radiator Service Inc Equipment Maintenance and Repair 225.00 Verizon Wireless Services LLC Cellular Service & Equipment Charges - 10/20-11/19 233.64 Village of Mount Prospect Flex - Medical 350.02 060 Vehicle Maintenance Fund Total $ 52,353.59 061 Vehicle Replacement Fund Altec Industries, Inc. New Vehicles $ 182,500.00 Altec Industries, Inc. Equipment for Public Works Vehicles 500.00 Bonnell Industries Inc. Equipment for Public Works Vehicles 499.00 Bonnell Industries Inc. Equipment for Public Works Vehicles 132.59 Catching Fluidpower New 2728 hydraulic fittings 56.61 Page 9 of 11 VILLAGE OF MOUNT PROSPECT List of Bills November 26 - December 9, 2015 Fund Vendor Name Invoice Description Amount Catching Fluidpower New 2728 hydraulic hose fittings 163.35 Catching Fluidpower Equipment for Public Works Vehicles 72.09 Catching Fluidpower Equipment for Public Works Vehicles 4.21 Catching Fluidpower New 2728 hydraulic fittings 97.72 Catching Fluidpower Equipment for Public Works Vehicles 886.31 Catching Fluidpower Equipment for Public Works Vehicles 958.72 Inlad Truck & Van Equipment Co., Inc. Equipment for Public Works Vehicles 244.48 Leach Enterprises, Inc. Equipment for Public Works Vehicles 84.78 Leach Enterprises, Inc. Equipment for Public Works Vehicles 72.55 Leach Enterprises, Inc. Equipment for Public Works Vehicles 43.92 Leach Enterprises, Inc. Equipment for Public Works Vehicles 80.64 Mcmaster-carr Supply Co. Equipment for Public Works Vehicles 92.92 West Side Tractor Sales New 2726 pavement breaker 15,247.00 061 Vehicle Replacement Fund Total 1,123.81 $ 201,736.89 062 Computer Replacement Fund $ 51,244.47 157 - Verizon Wireless Services LLC Cellular Service & Equipment Charges - 10/20-11/19 $ 597.48 062 Computer Replacement Fund Total Internal Revenue Service $ 597.48 063 Risk Management Fund American Appraisal Associates, Inc. Professional Services Property Insurance Appraisal (12/31/15) $ 5,310.00 Arlington Heights Ford P#12 Replacement Parts For Accident 473.96 Bridgestone Retail Operations, LLC. Repair Vehicle P-12 Tires 210.76 D and B Auto Glass, Inc. Repair Windshield #P-36 75.00 Dave & Jim's Auto Body, Inc. Vehicle Repair #4514 1,165.56 IntergovernmentalPer.ben.coop IPBC- December 2015 487,892.78 063 Risk Management Fund Total $ 495,128.06 070 Police Pension Fund Internal Revenue Service Federal Withholding $ 48,805.66 Lauterbach & Amen, LLP Pension Services Administration - October 2015 1,315.00 Wells Fargo Bank Admin Fees 11/1/15-1/31/16 1,123.81 070 Police Pension Fund Total $ 51,244.47 071 Fire Pension Fund Internal Revenue Service Federal Withholding $ 47,111.89 Lauterbach & Amen, LLP Pension Services Administration - October 2015 1,500.00 Wells Fargo Bank Admin Fees 11/1/15-1/31/16 1,875.00 071 Fire Pension Fund Total $ 50,486.89 073 Escrow Deposit Fund 3D Brick Paving Inc Refund Escrow Permit # 15-1981 (1822 E Cree Ln) $ 200.00 Archadeck of Chicagoland Refund Escrow Permit # 15-1889 (1105 Oakwood Dr) 200.00 ARS of Illinois Refund Escrow Permit # 15-2080 (1012 Hemlock Ln) 125.00 Arthur A Block Refund Escrow Permit # 15-2139 (926 N Quince Ln) 200.00 Bhupendra D Patel Refund Escrow Permit # 15-2170 (200 E Highland St) 75.00 C3D Architects Refund Escrow Permit # 15-0390 (1106 S Beechwood Dr) 250.00 Capital Shield Financial LLC Refund Escrow Permit # 15-1114 (600 N Wille St) 300.00 Capps Plumbing and Sewer Inc Refund Escrow Permit # 15-2262 (1405 W Cottonwood Ln) 125.00 Capps Plumbing and Sewer Inc Refund Escrow Permit # 15-2148 (905 Wa Pella Ave) 75.00 Christopher & Amanda Manna Refund Escrow Permit # 15-1714 (122 S Elmhurst Ave) 25.00 Christopher Westgor Refund Escrow Permit # 15-2252 (406 N Elmhurst Ave) 200.00 Clement Popovici Refund Escrow Permit # 14-2428 (1816 E Apache Ln) 500.00 Crystal Court Shopping Center Refund Escrow Permit # 14-1914 (1729 W Algonquin Rd) 150.00 David F Werner Refund Escrow Permit # 15-1405 (1770 E Euclid Ave) 200.00 David Paulson Refund Escrow Permit # 15-1699 (7 S Maple St) 200.00 Dean Nichols Concrete Refund Escrow Permit # 15-1897 (1801 E Camp McDonald Rd) 200.00 Design Build by Cochran Refund Escrow Permit # 14-2418 (422 S Main St) 200.00 Dominic Fong Refund Escrow Permit # 15-2283 (1172 N Boxwood Dr) 125.00 Douglas Fuller Refund Escrow Permit # 15-1996 (217 N Stratton Ln) 200.00 Page 10 of 11 VILLAGE OF MOUNT PROSPECT List of Bills November 26 - December 9, 2015 Fund Vendor Name Invoice Description Amount Edward Chen Refund Escrow Permit # 15-1861 (1410 S Hickory Dr) 200.00 Fisher Commercial Construction Co Inc Refund Escrow Permit # 15-1262 (1660 Wall St) 350.00 Fortis Concrete Refund Escrow Permit # 15-1318 (1211 W Robin Ln) 200.00 Gabriel's Landscape & Tree Services Inc Refund Escrow Permit # 15-1516 (937 Quince Ct) 200.00 Gambino Landscaping and Brick Paving Refund Escrow Permit # 15-1269 (13 N Owen St) 200.00 Giuseppe Jospeh Ungaro Refund Escrow Permit # 15-1376 (425 Dempster St) 200.00 Heitman Architects Inc Refund Escrow Permit # 15-0283 (1780 Wall St) 700.00 Ibbotson Heating Company Refund Escrow Permit # 15-2248 (611 S Noah Ter) 125.00 Iris Construction Refund Escrow Permit # 15-1298 (601 Dempster St) 400.00 Irma A Terry Refund Escrow Permit # 15-1943 (1624 E Cedar Ln) 200.00 J&J Pavement Repairs Inc Refund Escrow Permit # 15-1372 (348 S Maple St) 125.00 John Arciszewski Refund Escrow Permit # 15-2172 (1322 N Columbine Dr) 200.00 John Johanson Refund Escrow Permit # 15-2072 (315 S Beverly Ln) 200.00 Juliane Pearson Refund Escrow Permit # 15-1822 (804 N Burning Bush Ln) 200.00 K and L Contractors Refund Escrow Permit # 15-2084 (1200 W Northwest Hwy) 200.00 Kara Eilken Refund Escrow Permit # 15-2087 (315 N Owen St) 200.00 Kettler Concrete Construction Refund Escrow Permit # 15-2048 (113 S Bobby Ln) 200.00 Lawrence laccino Refund Escrow Permit # 15-2146 (645 S Meier Rd) 150.00 M Lopez Concrete Inc Refund Escrow Permit # 15-1989 (622 S Albert St) 200.00 Marie G Sassan Refund Escrow Permit # 15-2310 (1450 N Elmhurst Rd #102) 125.00 Matthew Tombs Refund Escrow Permit # 15-1152 (122 S Pine St) 200.00 Midwest Property Services Inc Refund Escrow Permit # 14-2125 (1101 S Hunt Club Dr) 200.00 Neighborhood Remodelers LLC Refund Escrow Permit # 15-1472 (415 N Prospect Manor Ave) 250.00 New Age Care Refund Escrow Permit # 15-1978 (2015 E Euclid Ave) 125.00 Paul S Wood Refund Escrow Permit # 15-2155 (421 N Maple St) 200.00 Peter A Roggeman Refund Escrow Permit # 15-1751 (310 N Elmhurst Ave) 125.00 Piotr Adamczyk Refund Escrow Permit # 15-1273 (902 S Edward St) 200.00 Rafal Kenar Refund Escrow Permit # 15-1252 (1807 E Wood Ln) 150.00 Randi Lamb Refund Escrow Permit # 14-0530 (1000 N Prospect Manor Ave) 200.00 Russel J Lokun Landscape & Design Refund Escrow Permit # 15-2258 (1642 E Barberry Ln) 200.00 Sara Feifarek Refund Escrow Permit # 15-2265 (303 S Albert St) 125.00 Saturn Electrical Services Refund Escrow Permit # 15-1867 (230 S Prairie Ave) 75.00 Scenic Greens Landscape Contractors Inc Refund Escrow Permit # 15-1985 (917 S Elm St) 200.00 Sebastian Cieslak Refund Escrow Permit # 15-1997 (1106 S Robert Dr) 125.00 Third District Circuit Court Bond Check 11/23/15 350.00 Third District Circuit Court Bond Check 11/25/15 1,075.00 Third District Circuit Court Bond Check 12/3/15 150.00 Third District Circuit Court Bond Check 12/8/15 1,425.00 Trinidad Construction Refund Escrow Permit # 15-0429 (1701 E Kensington Rd) 200.00 Veselin Dimitrov Refund Escrow Permit # 15-0769 (1719 Catalpa Ln) 75.00 Vincor Ltd Refund Escrow Permit # 15-0734 (1331 Business Center Dr) 250.00 Xclusive Concrete Refund Escrow Permit # 15-2041 (809 S Lancaster Ave) 200.00 073 Escrow Deposit Fund Total $ 14,225.00 Grand Total $ 7,550,223.36 Page 11 of 11