Loading...
HomeMy WebLinkAbout3. Monthly Financial Report & Approve Bills 01/19/2016 Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO:VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM:FINANCE DIRECTOR DATE:JANUARY12,2016 SUBJECT:MONTHLY FINANCIALREPORT –DECEMBER2015 Attached hereto are the cash position and investment statements of the Village for the month endedDecember31,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 andtwo (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 November30were $41.0million. During December,cash receipts totaled $5,568,980. In addition,inflows due to interfund activity totaled $448,776and investment income for the month was $4,017. Reductions in cash and cash equivalents during Decembertotaled $10,767,570.Of this amount, payments to vendors were $8,622,697andemployee payroll and related expenses were $2,144,873.Other receipts of $2,125accounted for the balance of the change during December.Cash and cash equivalents at December31were $36.2million. Monthly FinancialReport –December2015 January12,2016 Page 2 There was no cash of the Governmental or Enterprise Fundsheld in investments during the month of December. 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 November 30 were $40,950,468. Cash and investments at December 31totaled $36,206,796. This isa decrease of $4,743,672. Trust and Agency Funds -Cash and cash equivalents at November30were $2.1million. During December,cash receipts totaled $252,228.Investment income for the month was $115,746.There was also a net increase in cash due to investment activities of $2,063,197 while outflows due to Interfund activity totaled$448,776.Reductions in cash and cash equivalents duringDecembertotaled $808,521. Of this amount, payments to vendors were $142,183, employee payroll and related expenses were $646,803andpayments related to the flexible spending program totaled $15,993. Other disbursements during the monthtotaled $3,542.Cash and cash equivalents at December31were $3.3million. Total investments at December31were $112,854,848,adecreaseof $1,055,583from November30.There were unrealized investment gains of $1,007,614andanet transfertocash of $2,063,197that accounted for the change. Total cash and investments for Trust and Agency Funds at November30were $116,041,285. Cash and investments at December31totaled $116,159,576. This is anincrease of $118,291. 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 November30totaled $13,184,942.During December, cash receipts totaled $2,990,658and investment income was$1,601.There was also interfund activity that decreased cash by $271,802.Significant cash receipts included the state sales andstate income taxes. State sales tax revenues for the month totaled $1,360,390.Of this amount, $1,245,909 was generated from the 1% state portion while $114,483 wasgenerated from the .25% home rule portion. Sales taxes received in Decemberare for Septembersales as there is a three-month lag in getting this distribution from the state. H:\\ACCT\\Treasurer's Report\\2015\\Monthly Cash Position Report -December 2015.docx Monthly FinancialReport –December2015 January12,2016 Page 3 State income taxreceipts for December totaled $552,679. Income tax revenue received by the village during this month was to be received in October. The state is 2 months in arrears in remitting these taxes to the Village. The total amount in arrears is approximately $600,000. Disbursements from the General Fund for Decemberincluded payments to vendors of $1,841,786,and payments for employee wages and benefits of $1,879,552. Cash and cash equivalents at December31were $12,186,164.There were no investments in the General Fund at December31. 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 –There was no cash in investments during the month of December. Funds were held in liquid money market accounts that are currently earning competitive rates of interest. MaturityPurchaseFinancial InvestmentCUSIP/ DateDateInstitutionDescriptionFDIC #Net YieldPurch Price As of December 31, 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 Galliardand Mesirow manage the balance of fixed income investments for these two funds. Each manager maintains a small portion of their portfolio in cash to help facilitate liquidity and trading. Investments in equities consist of mutual funds spread across various sectors (small, mid and large-cap stocks) as well as investment philosophies (value, core and growth). The 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. H:\\ACCT\\Treasurer's Report\\2015\\Monthly Cash Position Report -December 2015.docx Monthly FinancialReport –December2015 January12,2016 Page 4 MaturityPurchaseFinancial InvestmentCUSIP/InterestMarket DateDateInstitutionDescriptionAcct #Rate %Value POLICE PENSION FUND (070) VariousVariousWells FargoWells Fargo InvestmentsVariousVarious$22,838,590.98 VariousVariousVariousMutual Fund InvestmentsVariousVarious34,459,259.92 57,297,850.90 FIRE PENSION FUND (071) Various5/26/2015Principal Life Insurance CompanyGroup Annuity Contract8-10810Variable2,710,468.79 VariousVariousWells FargoWells Fargo InvestmentsVariousVarious19,144,802.36 VariousVariousVariousMutual Fund InvestmentsVariousVarious33,701,725.90 55,556,997.05 TOTAL TRUST AND AGENCY FUND INVESTMENTS$112,854,847.95 Investment of the Village’s pension funds is governed by an Investment Policy adopted by each Pension Board. Conclusion Thiscash 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 delaysin receipt of revenues or cover unanticipated/unscheduled expenses. Please review the information and contact me with any questions. David O. Erb Finance Director H:\\ACCT\\Treasurer's Report\\2015\\Monthly Cash Position Report -December 2015.docx VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended December 31, 2015 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and CashTotal Cash and EquivalentsInvestmentsInvestments Balance at November 30, 2015$40,950,467.52$-$40,950,467.52 Cash receipts5,568,980.145,568,980.14 Investment income4,017.29-4,017.29 Transfers from investments to cash--- Transfers to investments from cash--- Interfund activity448,776.23448,776.23 Disbursements: Accounts payable(8,622,697.16)(8,622,697.16) Payroll(2,144,872.96)(2,144,872.96) Other2,125.202,125.20 Balance at December 31, 2015$36,206,796.26$-$36,206,796.26 TRUST AND AGENCY FUNDS * Cash and CashTotal Cash and EquivalentsInvestmentsInvestments Balance at November 30, 2015$2,130,853.88$113,910,431.08$116,041,284.96 Cash receipts252,228.48252,228.48 Investment income (loss)115,746.081,007,614.071,123,360.15 Transfers from investments to cash4,117,841.00(4,117,841.00)- Transfers to investments from cash(2,054,643.80)2,054,643.80- Interfund activity(448,776.23)(448,776.23) Disbursements: Accounts payable(142,183.05)(142,183.05) Payroll(646,802.73)(646,802.73) Flex spending(15,993.24)(15,993.24) Other(3,541.94)(3,541.94) Balance at December 31, 2015$3,304,728.45$112,854,847.95$116,159,576.40 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 2 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of December 31, 2015 GOVERNMENTAL AND ENTERPRISE FUNDS MaturityPurchaseFinancial InvestmentCUSIP/ DateDateInstitutionDescriptionFDIC #Net YieldPurch Price As of December 31, 2015, there were no certificates of deposit held by the Governmental and Enterprise Funds. TRUST AND AGENCY FUNDS * MaturityPurchaseFinancial InvestmentCUSIP/InterestMarket DateDateInstitutionDescriptionAcct #Rate %Value POLICE PENSION FUND (070) VariousVariousWells FargoWells Fargo InvestmentsVariousVarious$ 22,838,590.98 VariousVariousVariousMutual Fund InvestmentsVariousVarious 34,459,259.92 57,297,850.90 FIRE PENSION FUND (071) Various5/26/2015Principal Life Insurance CompanyGroup Annuity Contract8-10810Variable 2,710,468.79 VariousVariousWells FargoWells Fargo InvestmentsVariousVarious 19,144,802.36 VariousVariousVariousMutual Fund InvestmentsVariousVarious 33,701,725.90 55,556,997.05 TOTAL TRUST AND AGENCY FUND INVESTMENTS$112,854,847.95 * Assets are restricted in purpose and do not represent discretionary assets of the government. 3 VILLAGE OF MOUNT PROSPECT EXPENDITURE SUMMARIES 5 1 20 , BUDGET REVENUE 1 3 December & 1 0 December Prior Year YTD14,602,584.338,149,884.911,638,700.6520,068,468.351,691,056.43479,646.66(64,970.07)416,127.01286,389.1020,000.00$47,287,887.37$47,287,887.37 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 9911694102161127-56 Rec'd819399 94% (235,537.58)(8,063.34)(3,618.89)(64,330.05) Transactions 152,181.82122,172.261,889.4731,102.14 1,591,226.001,281,212.93$2,868,234.76$2,868,234.76 Budget - YTD (11,102.14) Transactions 15,275,318.186,846,340.001,705,537.5819,456,391.071,637,050.74497,063.349,536.89218,110.53300,330.05$45,934,576.24$45,934,576.24 YTD .00.00.00.00.00.00.00.00.00.00$0.00$0.00 YTD Encumbrance Transactions 29,511.10429,279.6694,287.27160,356.8445,611.061,855.7050,167.9241,234.62 Current Month3,843,432.66.00$4,695,736.83$4,695,736.83 Budget Amended15,427,500.008,437,566.001,470,000.0020,737,604.001,759,223.00489,000.005,918.00220,000.00236,000.0020,000.00$48,802,811.00$48,802,811.00 Budget Amendments 980,000.00214,000.00614,404.00126,000.0050,000.00 .00.00.00.00.00$1,984,404.00$1,984,404.00 AdoptedBudget15,427,500.007,457,566.001,256,000.0020,123,200.001,633,223.00439,000.005,918.00220,000.00236,000.0020,000.00$46,818,407.00$46,818,407.00 REVENUE TOTALS Totals 001 - General Fund Fund 001 - General Fund Intergovernmental Revenue Licenses, Permits & Fees Other Financing Sources Account Classification Charges For Services Investment Income Reimbursements Fines & Forfeits Property Taxes Other Revenue REVENUE Other Taxes Fund 1 Prior Year YTD2,237,000.001,056,532.001,618,709.1595.48112.38.00$4,912,449.01$4,912,449.01 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 100100100306 Rec'd ++++++ 100% (908.19)(205.73)(47.60)($1,161.52)($1,161.52) Transactions .00.00.00 Budget - YTD Transactions 2,254,000.00988,508.001,612,537.19305.7347.60.00$4,855,398.52$4,855,398.52 YTD .00.00.00.00.00.00$0.00$0.00 YTD Encumbrance Transactions 11,481.86346,087.15$357,682.85$357,682.85 Current Month.0066.2447.60.00 Budget Amended2,254,000.00988,508.001,611,629.00100.00.00.00$4,854,237.00$4,854,237.00 Budget Amendments .00.001,568,856.00.00.00.00$1,568,856.00$1,568,856.00 AdoptedBudget2,254,000.00988,508.0042,773.00100.00.00.00$3,285,381.00$3,285,381.00 REVENUE TOTALS Totals 002 - Debt Service Fund Fund 002 - Debt Service Fund Intergovernmental Revenue Other Financing Sources Account Classification Investment Income Property Taxes Other Revenue REVENUE Other Taxes Fund 2 Prior Year YTD1,254,676.38.00515.16.00140,181.00.00$1,395,372.54$1,395,372.54 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 989899 Rec'd54 ++++++ 98% Transactions 21,873.17$23,541.04$23,541.04 726.28461.59.00480.00.00 Budget - YTD Transactions 1,224,126.8347,273.72538.41.0047,520.00.00$1,319,458.96$1,319,458.96 YTD .00.00.00.00.00.00$0.00$0.00 YTD Encumbrance Transactions 414,660.68$414,743.21$414,743.21 Current Month.0082.53.00.00.00 Budget Amended1,246,000.0048,000.001,000.00.0048,000.00.00$1,343,000.00$1,343,000.00 Budget Amendments 48,000.0028,000.00$76,000.00$76,000.00 .00.00.00.00 AdoptedBudget1,246,000.00.001,000.00.0020,000.00.00$1,267,000.00$1,267,000.00 REVENUE TOTALS Totals 020 - Capital Improvement Fund 020 - Capital Improvement Fund Intergovernmental Revenue Fund Other Financing Sources Account Classification Investment Income Reimbursements Other Revenue REVENUE Other Taxes Fund 3 Prior Year YTD2,564,115.09359.96.00.00.00$2,564,475.05$2,564,475.05 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 85 Rec'd87 +++++++++ 85% Transactions 401,422.41$401,487.72$401,487.72 65.31.00.00.00 Budget - YTD Transactions 2,307,577.59434.69.00.00.00$2,308,012.28$2,308,012.28 YTD .00.00.00.00.00$0.00$0.00 YTD Encumbrance Transactions 1,113.26$1,154.91$1,154.91 Current Month41.65.00.00.00 Budget Amended2,709,000.00500.00.00.00.00$2,709,500.00$2,709,500.00 Budget Amendments .00.00.00.00.00$0.00$0.00 AdoptedBudget2,709,000.00500.00.00.00.00$2,709,500.00$2,709,500.00 REVENUE TOTALS Totals 022 - Downtown Redevelopment Construct 022 - Downtown Redevelopment Construct Other Financing Sources Account Classification Investment Income Reimbursements Property Taxes Other Revenue Fund REVENUE Fund 4 Prior Year YTD2,054,871.901,019,321.52.00117,500.004,349.59.00103,821.336,584,696.75$9,884,561.09$9,884,561.09 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 97139495 Rec'd73 ++++++++++++ 83% (1,294.13) Transactions 563,045.1853,334.252,672.88$617,758.18$617,758.18 .00.00.00.00 Budget - YTD Transactions 1,492,954.821,486,665.75.00.001,394.13.0052,327.12.00$3,033,341.82$3,033,341.82 YTD .00.00.00.00.00.00.00.00$0.00$0.00 YTD Encumbrance Transactions 56,370.719,413.00$65,835.59$65,835.59 Current Month.00.0051.88.00.00.00 Budget Amended2,056,000.001,540,000.00.00.00100.00.0055,000.00.00$3,651,100.00$3,651,100.00 Budget Amendments 49,000.00$49,000.00$49,000.00 .00.00.00.00.00.00.00 AdoptedBudget2,056,000.001,540,000.00.00.00100.00.006,000.00.00$3,602,100.00$3,602,100.00 REVENUE TOTALS Totals 023 - Street Improvement Construc Fund 023 - Street Improvement Construc Fund Intergovernmental Revenue Licenses, Permits & Fees Other Financing Sources Account Classification Investment Income Reimbursements Fines & Forfeits Fund Other Revenue REVENUE Other Taxes Fund 5 Prior Year YTD298,840.76.00.0012,273.52.00.00$311,114.28$311,114.28 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 1001101115 Rec'd +++++++++ 104% (2,981.00)(11,163.46)($14,144.46)($14,144.46) Transactions .00.00.00.00 Budget - YTD Transactions 357,000.00.0032,981.0012,263.46.00.00$402,244.46$402,244.46 YTD .00.00.00.00.00.00$0.00$0.00 YTD Encumbrance Transactions 124,989.511,310.50$126,703.11$126,703.11 Current Month.00403.10.00.00 Budget Amended357,000.00.0030,000.001,100.00.00.00$388,100.00$388,100.00 Budget Amendments 30,000.00$30,000.00$30,000.00 .00.00.00.00.00 AdoptedBudget357,000.00.00.001,100.00.00.00$358,100.00$358,100.00 REVENUE TOTALS Totals 024 - Flood Control Construction Fund 024 - Flood Control Construction Fund Intergovernmental Revenue Other Financing Sources Account Classification Charges For Services Investment Income Fund Reimbursements REVENUE Other Taxes Fund 6 Prior Year YTD342,000.002,922,407.7526,715.39604.10884.88353,520.93$3,646,133.05$3,646,133.05 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 99130387105 Rec'd53 +++ 100% (7,200.45)(2,866.83)(17,200.99) Transactions 28,007.05 .00235.30$974.08$974.08 Budget - YTD Transactions .003,520,992.9531,200.45264.703,866.83388,700.99$3,945,025.92$3,945,025.92 YTD .00.00.00.00.00.00$0.00$0.00 YTD Encumbrance (95.23) Transactions 405,254.7215,782.79$421,140.01$421,140.01 Current Month.0047.30150.43 Budget Amended.003,549,000.0024,000.00500.001,000.00371,500.00$3,946,000.00$3,946,000.00 Budget Amendments .00.00.00.00.00.00$0.00$0.00 AdoptedBudget.003,549,000.0024,000.00500.001,000.00371,500.00$3,946,000.00$3,946,000.00 REVENUE TOTALS Totals 040 - Refuse Disposal Fund 040 - Refuse Disposal Fund Fund Account Classification Charges For Services Investment Income Reimbursements Fines & Forfeits Property Taxes Other Revenue REVENUE Fund 7 Prior Year YTD1,830,551.7867.3019,102.78$1,849,721.86$1,849,721.86 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 100166119 Rec'd 100% (4,242.17)(132.38)(2,133.24)($6,507.79)($6,507.79) Transactions Budget - YTD Transactions 1,324,242.17332.3813,133.24$1,337,707.79$1,337,707.79 YTD .00.00.00$0.00$0.00 YTD Encumbrance Transactions 727,769.85$727,824.29$727,824.29 Current Month54.44.00 Budget Amended1,320,000.00200.0011,000.00$1,331,200.00$1,331,200.00 Budget Amendments .00.00.00$0.00$0.00 AdoptedBudget1,320,000.00200.0011,000.00$1,331,200.00$1,331,200.00 REVENUE TOTALS Totals 041 - Motor Fuel Tax Fund 041 - Motor Fuel Tax Fund Fund Intergovernmental Revenue Account Classification Investment Income Reimbursements REVENUE Fund 8 Prior Year YTD83,298.32.00196,884.29$280,182.61$280,182.61 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 41106 Rec'd +++ 49% (4,693.50) Transactions 351,167.71$346,474.21$346,474.21 .00 Budget - YTD Transactions 241,623.29.0084,693.50$326,316.79$326,316.79 YTD .00.00.00$0.00$0.00 YTD Encumbrance Transactions Current Month.00.00.00$0.00$0.00 Budget Amended592,791.00.0080,000.00$672,791.00$672,791.00 Budget Amendments 253,527.00$253,527.00$253,527.00 .00.00 AdoptedBudget339,264.00.0080,000.00$419,264.00$419,264.00 REVENUE TOTALS Totals 042 - CDBG Fund Intergovernmental Revenue Account Classification 042 - CDBG Investment Income Other Revenue REVENUE Fund 9 Prior Year YTD49,039.4415.15$49,054.59$49,054.59 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 900 Rec'd24 858% (15,995.19)($15,919.11)($15,919.11) Transactions 76.08 Budget - YTD Transactions 17,995.1923.92$18,019.11$18,019.11 YTD .00.00$0.00$0.00 YTD Encumbrance Transactions 2,500.004.29$2,504.29$2,504.29 Current Month Budget Amended2,000.00100.00$2,100.00$2,100.00 Budget Amendments .00.00$0.00$0.00 AdoptedBudget2,000.00100.00$2,100.00$2,100.00 REVENUE TOTALS Totals 043 - Asset Seizure Fund 043 - Asset Seizure Fund Fund Account Classification Investment Income Fines & Forfeits REVENUE Fund 10 Prior Year YTD24,637.8019.72$24,657.52$24,657.52 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ Rec'd013 6% Transactions 100.0087.47$187.47$187.47 Budget - YTD Transactions .0012.53$12.53$12.53 YTD .00.00$0.00$0.00 YTD Encumbrance (2,687.50)($2,684.61)($2,684.61) Transactions 2.89 Current Month Budget Amended100.00100.00$200.00$200.00 Budget Amendments .00.00$0.00$0.00 AdoptedBudget100.00100.00$200.00$200.00 REVENUE TOTALS Totals 044 - Federal Equitable Share Funds 044 - Federal Equitable Share Funds Account Classification Fund Investment Income Fines & Forfeits REVENUE Fund 11 Prior Year YTD38,523.3936.23$38,559.62$38,559.62 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 147 Rec'd35 146% (9,366.87)($9,301.98)($9,301.98) Transactions 64.89 Budget - YTD Transactions 29,366.8735.11$29,401.98$29,401.98 YTD .00.00$0.00$0.00 YTD Encumbrance Transactions 1,869.938.06$1,877.99$1,877.99 Current Month Budget Amended20,000.00100.00$20,100.00$20,100.00 Budget Amendments .00.00$0.00$0.00 AdoptedBudget20,000.00100.00$20,100.00$20,100.00 REVENUE TOTALS Totals 045 - DUI Fine Fund Fund 045 - DUI Fine Fund Account Classification Investment Income Fines & Forfeits REVENUE Fund 12 Prior Year YTD67,576.50103.85.00.00$67,680.35$67,680.35 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 11899 Rec'd ++++++ 118% (12,425.42)($12,424.25)($12,424.25) Transactions 1.17 .00.00 Budget - YTD Transactions 82,425.4298.83.00.00$82,524.25$82,524.25 YTD .00.00.00.00$0.00$0.00 YTD Encumbrance Transactions Current Month.0018.46.00.00$18.46$18.46 Budget Amended70,000.00100.00.00.00$70,100.00$70,100.00 Budget Amendments .00.00.00.00$0.00$0.00 AdoptedBudget70,000.00100.00.00.00$70,100.00$70,100.00 REVENUE TOTALS Totals 046 - Foreign Fire Tax Board Fund 046 - Foreign Fire Tax Board Fund Other Financing Sources Fund Account Classification Investment Income Other Revenue REVENUE Other Taxes Fund 13 Prior Year YTD1,014,312.2141.17.00$1,014,353.38$1,014,353.38 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 93 Rec'd +++ +++ 93% (102.13) Transactions 66,575.34$66,473.21$66,473.21 .00 Budget - YTD Transactions 954,424.66102.13.00$954,526.79$954,526.79 YTD .00.00.00$0.00$0.00 YTD Encumbrance Transactions 122,940.63$122,953.77$122,953.77 Current Month13.14.00 Budget Amended1,021,000.00.00.00$1,021,000.00$1,021,000.00 Budget Amendments .00.00.00$0.00$0.00 AdoptedBudget1,021,000.00.00.00$1,021,000.00$1,021,000.00 REVENUE TOTALS Totals 048 - Business District Fund 048 - Business District Fund Fund Other Financing Sources Account Classification Investment Income REVENUE Other Taxes Fund 14 Prior Year YTD1,508,703.7217,450.0011,852,388.82110,154.783,099.56381,635.7762,018.03(2,001.60)$13,933,449.08$13,933,449.08 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 99103978986106 Rec'd0 +++ 97% (600.00)(4,049.80) Transactions 19,014.69380,021.0812,432.77$407,611.45$407,611.45 292.71500.00.00 Budget - YTD Transactions 1,510,985.3118,600.0012,243,978.92105,567.231,807.29.0076,049.80.00$13,956,988.55$13,956,988.55 YTD .00.00.00.00.00.00.00.00$0.00$0.00 YTD Encumbrance (978.00) Transactions 1,500.00871,404.986,580.83 Current Month1,514,438.14213.54.00.00$2,393,159.49$2,393,159.49 Budget Amended1,530,000.0018,000.0012,624,000.00118,000.002,100.00500.0072,000.00.00$14,364,600.00$14,364,600.00 Budget (1,165,000.00)($1,165,000.00)($1,165,000.00) Amendments .00.00.00.00.00.00.00 AdoptedBudget1,530,000.0018,000.0013,789,000.00118,000.002,100.00500.0072,000.00.00$15,529,600.00$15,529,600.00 REVENUE TOTALS Totals 050 - Water and Sewer Fund 050 - Water and Sewer Fund Fund Licenses, Permits & Fees Other Financing Sources Account Classification Charges For Services Investment Income Reimbursements Fines & Forfeits Property Taxes Other Revenue REVENUE Fund 15 Prior Year YTD10,069.65135,304.4290.05.00$145,464.12$145,464.12 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 10892 Rec'd ++++++ 108% (10,116.34)($10,108.16)($10,108.16) Transactions 8.18 .00.00 Budget - YTD Transactions .00140,716.3491.82.00$140,808.16$140,808.16 YTD .00.00.00.00$0.00$0.00 YTD Encumbrance Transactions 11,904.16$11,919.82$11,919.82 Current Month.0015.66.00 Budget Amended.00130,600.00100.00.00$130,700.00$130,700.00 Budget Amendments .00.00.00.00$0.00$0.00 AdoptedBudget.00130,600.00100.00.00$130,700.00$130,700.00 REVENUE TOTALS Totals 051 - Village Parking System Fund 051 - Village Parking System Fund Other Financing Sources Fund Account Classification Charges For Services Investment Income REVENUE Other Taxes Fund 16 Prior Year YTD90,626.72.00119,479.57.00.00.00$210,106.29$210,106.29 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 100102 Rec'd ++++++++++++ 101% (2,028.38)(.25)($2,028.63)($2,028.63) Transactions .00.00.00.00 Budget - YTD Transactions 100,000.00.00121,028.38.00.25.00$221,028.63$221,028.63 YTD .00.00.00.00.00.00$0.00$0.00 YTD Encumbrance Transactions 35,034.8110,262.50$45,297.31$45,297.31 Current Month.00.00.00.00 Budget Amended100,000.00.00119,000.00.00.00.00$219,000.00$219,000.00 Budget Amendments .00.00.00.00.00.00$0.00$0.00 AdoptedBudget100,000.00.00119,000.00.00.00.00$219,000.00$219,000.00 REVENUE TOTALS Totals 052 - Parking System Revenue Fund 052 - Parking System Revenue Fund Intergovernmental Revenue Other Financing Sources Account Classification Fund Charges For Services Investment Income Other Revenue REVENUE Other Taxes Fund 17 Prior Year YTD2,138,317.00550.11525.88$2,139,392.99$2,139,392.99 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 100 Rec'd67 +++ 100% (1,879.81)($1,679.69)($1,679.69) Transactions .00200.12 Budget - YTD Transactions 2,157,889.00399.881,879.81$2,160,168.69$2,160,168.69 YTD .00.00.00$0.00$0.00 YTD Encumbrance Transactions 179,824.01$179,901.77$179,901.77 Current Month77.76.00 Budget Amended2,157,889.00600.00.00$2,158,489.00$2,158,489.00 Budget Amendments .00.00.00$0.00$0.00 AdoptedBudget2,157,889.00600.00.00$2,158,489.00$2,158,489.00 REVENUE TOTALS Totals 060 - Vehicle Maintenance Fund 060 - Vehicle Maintenance Fund Fund Account Classification Charges For Services Investment Income Other Revenue REVENUE Fund 18 Prior Year YTD1,346,300.0016,249.726,763.82.0065,033.60$1,434,347.14$1,434,347.14 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 100107 Rec'd68 ++++++ 103% (743.28)(40,842.74)($39,270.81)($39,270.81) Transactions 2,315.21 .00.00 Budget - YTD Transactions 1,380,500.0011,893.284,884.79.0040,842.74$1,438,120.81$1,438,120.81 YTD .00.00.00.00.00$0.00$0.00 YTD Encumbrance Transactions 115,041.521,354.282,606.25$119,935.22$119,935.22 Current Month933.17.00 Budget Amended1,380,500.0011,150.007,200.00.00.00$1,398,850.00$1,398,850.00 Budget Amendments .00.00.00.00.00$0.00$0.00 AdoptedBudget1,380,500.0011,150.007,200.00.00.00$1,398,850.00$1,398,850.00 REVENUE TOTALS Totals 061 - Vehicle Replacement Fund 061 - Vehicle Replacement Fund Fund Other Financing Sources Account Classification Charges For Services Investment Income Fines & Forfeits Other Revenue REVENUE Fund 19 Prior Year YTD23,088.00736.66.00$23,824.66$23,824.66 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 10053 Rec'd +++ 100% Transactions .00473.83.00$473.83$473.83 Budget - YTD Transactions 272,307.00526.17.00$272,833.17$272,833.17 YTD .00.00.00$0.00$0.00 YTD Encumbrance Transactions 22,692.25$22,798.40$22,798.40 Current Month106.15.00 Budget Amended272,307.001,000.00.00$273,307.00$273,307.00 Budget Amendments .00.00.00$0.00$0.00 AdoptedBudget272,307.001,000.00.00$273,307.00$273,307.00 REVENUE TOTALS Totals 062 - Computer Replacement Fund 062 - Computer Replacement Fund Other Financing Sources Fund Account Classification Charges For Services Investment Income REVENUE Fund 20 Prior Year YTD6,461,362.622,220.1831,213.001,308,420.90$7,803,216.70$7,803,216.70 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 10186 Rec'd4488 98% (37,304.69) Transactions 1,684.81169,080.52$133,601.24$133,601.24 140.60 Budget - YTD Transactions 6,551,130.691,315.19859.401,294,619.48$7,847,924.76$7,847,924.76 YTD .00.00.00.00$0.00$0.00 YTD Encumbrance Transactions 551,580.60104,957.29$656,813.53$656,813.53 Current Month275.64.00 Budget Amended6,513,826.003,000.001,000.001,463,700.00$7,981,526.00$7,981,526.00 Budget Amendments .00.00.00.00$0.00$0.00 AdoptedBudget6,513,826.003,000.001,000.001,463,700.00$7,981,526.00$7,981,526.00 REVENUE TOTALS Totals 063 - Risk Management Fund 063 - Risk Management Fund Fund Account Classification Charges For Services Investment Income Reimbursements Other Revenue REVENUE Fund 21 Prior Year YTD.003,948,388.133,775,588.61$7,723,976.74$7,723,976.74 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 2998 Rec'd +++ 72% Transactions 90,701.07 .001,556,865.45$1,647,566.52$1,647,566.52 Budget - YTD Transactions .00650,934.553,652,473.93$4,303,408.48$4,303,408.48 YTD .00.00.00$0.00$0.00 YTD Encumbrance (795,903.51)($694,214.87)($694,214.87) Transactions 101,688.64 Current Month.00 Budget Amended.002,207,800.003,743,175.00$5,950,975.00$5,950,975.00 Budget (2,175,000.00)($2,175,000.00)($2,175,000.00) Amendments .00.00 AdoptedBudget.004,382,800.003,743,175.00$8,125,975.00$8,125,975.00 REVENUE TOTALS Totals 070 - Police Pension Fund 070 - Police Pension Fund Fund Account Classification Charges For Services Investment Income Other Revenue REVENUE Fund 22 Prior Year YTD4,048,519.943,110,548.73$7,159,068.67$7,159,068.67$113,899,048.71 Revenue Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 10098 Rec'd 99% (1,075.54) Transactions 65,180.18$64,104.64$64,104.64 $6,465,941.95 Budget - YTD Transactions 1,886,575.543,085,944.82$4,972,520.36$4,972,520.36$99,860,369.05 YTD .00.00$0.00$0.00$0.00 YTD Encumbrance Transactions 80,182.21 Current Month1,866,455.00$1,946,637.21$1,946,637.21$11,617,738.58 Budget Amended1,885,500.003,151,125.00$5,036,625.00$5,036,625.00$106,326,311.00 Budget (2,365,000.00)($2,365,000.00)($2,365,000.00)($1,743,213.00) Amendments .00 AdoptedBudget4,250,500.003,151,125.00$7,401,625.00$7,401,625.00$108,069,524.00 Grand Totals REVENUE TOTALS Totals 071 - Fire Pension Fund Fund 071 - Fire Pension Fund Account Classification Investment Income Other Revenue REVENUE Fund 23 Prior Year YTD24,262,837.8612,566,567.11341,613.4646,300.327,058,825.20222,753.08350,531.40582,120.63187,935.528,212.2427,781.58150,237.8570,223.40444,907.85.00$46,320,847.50$46,320,847.50 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 96988610089718786448899 Rec'd1007850 +++ 94% Transactions 235,432.8161,448.61879,262.2578,662.79142,643.915,946.411,425.8929,634.5323,012.53333,882.12 1,003,228.75.64254.67847.30.00$2,795,683.21$2,795,683.21 Budget - YTD Transactions 379,864.3946,455.36193,276.21415,143.33513,596.0938,825.598,774.1122,885.47168,596.4799,152.70332,940.88 23,546,482.2512,187,853.196,890,853.75.00$44,844,699.79$44,844,699.79 YTD Encumbrances .00.00.00.00.00.00.00.00.00.00.00.00.00.00.00$0.00$0.00 YTD Transactions Current Month2,889,124.57606,035.9431,100.433,871.28587,764.0547,277.7734,600.0969,979.2433,692.53.004,004.3622,314.62.0065,455.82.00$4,395,220.70$4,395,220.70 Budget Amended441,313.0046,456.00271,939.00415,398.00656,240.0044,772.0010,200.0052,520.00191,609.00100,000.00666,823.00 24,549,711.0012,423,286.007,770,116.00.00$47,640,383.00$47,640,383.00 Budget Amendments 317,674.00187,999.00770.00.00241,247.00.00.0014,244.0033,632.00.0019,000.007,410.00.00.00.00$821,976.00$821,976.00 AdoptedBudget24,232,037.0012,235,287.00440,543.0046,456.007,528,869.00271,939.00415,398.00641,996.0011,140.0010,200.0033,520.00184,199.00100,000.00666,823.00.00$46,818,407.00$46,818,407.00 EXPENSE TOTALS Totals 001 - General Fund Fund Personal Services, Scheduled Salaries & Wages 001 - General Fund Commodities & Supplies Building Improvements Other Employee Costs Account Classification Distribution Systems Contractual Services Interfund Transfers Other Expenditures Employee Benefits Office Equipment Other Equipment Pension Benefits Infrastructure EXPENSE Insurance Fund Utilities 1 Prior Year YTD.00.002,987,587.191,912,482.982,234.56.00.00$4,902,304.73$4,902,304.73 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ Rec'd100100189 ++++++++++++ 100% (.30)(2,508.14)($2,507.56)($2,507.56) Transactions .00.00.88.00.00 Budget - YTD Transactions 5,320.14 .00.003,048,912.121,795,927.30.00.00$4,850,159.56$4,850,159.56 YTD Encumbrances .00.00.00.00.00.00.00$0.00$0.00 YTD Transactions Current Month.00.0052,482.255,770.541,605.00.00.00$59,857.79$59,857.79 Budget Amended2,812.00 .00.003,048,913.001,795,927.00.00.00$4,847,652.00$4,847,652.00 Budget Amendments .00.001,155,000.00413,356.00500.00.00.00$1,568,856.00$1,568,856.00 AdoptedBudget.00.001,893,913.001,382,571.002,312.00.00.00$3,278,796.00$3,278,796.00 EXPENSE TOTALS Totals 002 - Debt Service Fund Fund 002 - Debt Service Fund Account Classification Other Financing Uses Contractual Services Interfund Transfers Other Expenditures Bank & Fiscal Fees Interest Expense Bond Principal EXPENSE Fund 2 Prior Year YTD.0020,727.3711,394.75380,381.50.00.00217,893.6787,955.14.00$718,352.43$718,352.43 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 5019 Rec'd6850 +++++++++++++++ 50% Transactions 292,470.54466,973.25271,853.06636,996.13 .00.00.00.00.00$1,668,292.98$1,668,292.98 Budget - YTD Transactions 293,779.46984,466.75267,011.94150,864.87 .00.00.00.00.00$1,696,123.02$1,696,123.02 YTD Encumbrances .00.00.00.00.00.00.00.00.00$0.00$0.00 YTD Transactions Current Month.00.00245,686.1426,899.66.00.0082,611.834,180.15.00$359,377.78$359,377.78 Budget Amended586,250.00538,865.00787,861.00 .00.001,451,440.00.00.00.00$3,364,416.00$3,364,416.00 Budget Amendments .00.00236,250.00555,440.00.00.0052,118.00284,861.00.00$1,128,669.00$1,128,669.00 AdoptedBudget.00.00350,000.00896,000.00.00.00486,747.00503,000.00.00$2,235,747.00$2,235,747.00 EXPENSE TOTALS Totals 020 - Capital Improvement Fund 020 - Capital Improvement Fund Fund Building Improvements Account Classification Contractual Services Land Improvements Interfund Transfers Other Expenditures Office Equipment Motor Equipment Other Equipment Infrastructure EXPENSE Fund 3 Prior Year YTD196,419.12.002,764,810.5116,775.75.00.00.00$2,978,005.38$2,978,005.38 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 9121 Rec'd79 ++++++++++++ 75% Transactions 17,918.55838,615.23272,298.88 .00.00.00.00$1,128,832.66$1,128,832.66 Budget - YTD Transactions 181,282.4573,661.12 .003,178,353.77.00.00.00$3,433,297.34$3,433,297.34 YTD Encumbrances .00.00.00.00.00.00.00$0.00$0.00 YTD Transactions Current Month48,935.38.0012,134.681,783.81.00.00.00$62,853.87$62,853.87 Budget Amended199,201.00345,960.00 .004,016,969.00.00.00.00$4,562,130.00$4,562,130.00 Budget Amendments 90,000.00.00710,000.003,675.00.00.00.00$803,675.00$803,675.00 AdoptedBudget109,201.00.003,306,969.00342,285.00.00.00.00$3,758,455.00$3,758,455.00 EXPENSE TOTALS Totals 022 - Downtown Redevelopment Construct 022 - Downtown Redevelopment Construct Account Classification Fund Contractual Services Interfund Transfers Other Expenditures Interest Expense Bond Principal Infrastructure EXPENSE Fund Utilities 4 Prior Year YTD89,153.29.00.007,733,639.79.00$7,822,793.08$7,822,793.08 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 8391 Rec'd +++++++++ 91% Transactions 17,776.00627,693.50$645,469.50$645,469.50 .00.00.00 Budget - YTD Transactions 89,224.00 .00.006,129,192.50.00$6,218,416.50$6,218,416.50 YTD Encumbrances .00.00.00.00.00$0.00$0.00 YTD Transactions Current Month4,660.00.00.00534,459.06.00$539,119.06$539,119.06 Budget Amended107,000.00 .00.006,756,886.00.00$6,863,886.00$6,863,886.00 Budget Amendments .00.00.002,041,886.00.00$2,041,886.00$2,041,886.00 AdoptedBudget107,000.00.00.004,715,000.00.00$4,822,000.00$4,822,000.00 EXPENSE TOTALS Totals 023 - Street Improvement Construc Fund 023 - Street Improvement Construc Fund Fund Account Classification Contractual Services Land Improvements Interfund Transfers Other Expenditures Infrastructure EXPENSE Fund 5 Prior Year YTD.00915.87.00.00.00.00555,393.51$556,309.38$556,309.38 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 0083 Rec'd0100 ++++++ 83% Transactions 12,000.005,000.005,100.00 .00.00.001,784,292.33$1,806,392.33$1,806,392.33 Budget - YTD Transactions 2,300.00 .00.00.00.00.008,864,258.67$8,866,558.67$8,866,558.67 YTD Encumbrances .00.00.00.00.00.00.00$0.00$0.00 YTD Transactions Current Month.00195.94.00.00.00.001,514,340.21$1,514,536.15$1,514,536.15 Budget Amended12,000.002,300.005,000.005,100.00 .00.0010,648,551.00$10,672,951.00$10,672,951.00 Budget Amendments .00.00.00.00.00.00868,591.00$868,591.00$868,591.00 AdoptedBudget12,000.002,300.005,000.005,100.00.00.009,779,960.00$9,804,360.00$9,804,360.00 EXPENSE TOTALS Totals 024 - Flood Control Construction Fund 024 - Flood Control Construction Fund Fund Commodities & Supplies Account Classification Distribution Systems Contractual Services Other Expenditures Other Equipment Infrastructure EXPENSE Fund Utilities 6 Prior Year YTD250,101.70108,875.781,224.004,013,048.02261.2928,640.0036,289.84$4,438,440.63$4,438,440.63 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 0905710095 Rec'd104104 91% (8,736.98)(4,316.03) Transactions 1,248.00428,573.071,954.18$418,915.80$418,915.80 193.56.00 Budget - YTD Transactions 245,380.98114,752.0331,809.0036,491.82 .003,871,102.93253.44$4,299,790.20$4,299,790.20 YTD Encumbrances .00.00.00.00.00.00.00$0.00$0.00 YTD Transactions Current Month31,476.2810,995.83.00342,880.2523.412,650.7525.59$388,052.11$388,052.11 Budget Amended236,644.00110,436.001,248.0031,809.0038,446.00 4,299,676.00447.00$4,718,706.00$4,718,706.00 Budget Amendments .00.00.004,742.00.00.00.00$4,742.00$4,742.00 AdoptedBudget236,644.00110,436.001,248.004,294,934.00447.0031,809.0038,446.00$4,713,964.00$4,713,964.00 EXPENSE TOTALS Totals 040 - Refuse Disposal Fund Personal Services, Scheduled Salaries & Wages Fund 040 - Refuse Disposal Fund Commodities & Supplies Other Employee Costs Account Classification Contractual Services Employee Benefits EXPENSE Insurance Fund Utilities 7 Prior Year YTD247,989.62156,036.73375,111.97.0012,079.12$791,217.44$791,217.44 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 8004 Rec'd10073 35% Transactions 57,671.14121,239.68600,000.00633,436.03 .00$1,412,346.85$1,412,346.85 Budget - YTD Transactions 227,014.86156,060.00331,969.3229,563.97$744,608.15$744,608.15 .00 YTD Encumbrances .00.00.00.00.00$0.00$0.00 YTD Transactions Current Month45,019.96.0057,525.46.00518.07$103,063.49$103,063.49 Budget Amended284,686.00156,060.00453,209.00600,000.00663,000.00 $2,156,955.00$2,156,955.00 Budget Amendments .00.00.00.00.00$0.00$0.00 AdoptedBudget284,686.00156,060.00453,209.00600,000.00663,000.00$2,156,955.00$2,156,955.00 EXPENSE TOTALS Totals 041 - Motor Fuel Tax Fund Fund 041 - Motor Fuel Tax Fund Commodities & Supplies Building Improvements Account Classification Contractual Services Infrastructure EXPENSE Fund Utilities 8 Prior Year YTD47,495.3625,966.03178.32111,988.90.0043,462.00.00.0051,092.00$280,182.61$280,182.61 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 959833582490 Rec'd0 ++++++ 64% Transactions 2,458.7665,269.59148,970.0023,061.28$241,552.80$241,552.80 571.49701.68520.00.00.00 Budget - YTD Transactions 51,124.2425,838.5190,013.4146,985.00216,938.72$431,238.20$431,238.20 338.32.00.00.00 YTD Encumbrances .00.00.00.00.00.00.00.00.00$0.00$0.00 YTD Transactions Current Month5,925.002,509.8380.00111.39.00.00.00.00.00$8,626.22$8,626.22 Budget Amended53,583.0026,410.001,040.00155,283.00195,955.00240,000.00$672,791.00$672,791.00 520.00.00.00 Budget Amendments 4,800.00919.00.00853.00.006,955.00.00.00240,000.00$253,527.00$253,527.00 AdoptedBudget48,783.0025,491.001,040.00154,430.00520.00189,000.00.00.00.00$419,264.00$419,264.00 EXPENSE TOTALS Totals 042 - CDBG Fund Personal Services, Scheduled Salaries & Wages Commodities & Supplies Building Improvements Other Employee Costs Account Classification Contractual Services Land Improvements 042 - CDBG Other Expenditures Employee Benefits Infrastructure EXPENSE Fund 9 Prior Year YTD.006,000.002,038.72$8,038.72$8,038.72 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 06747 Rec'd 48% Transactions 1,000.001,000.007,956.11$9,956.11$9,956.11 Budget - YTD Transactions 2,000.007,043.89$9,043.89$9,043.89 .00 YTD Encumbrances .00.00.00$0.00$0.00 YTD Transactions Current Month.00.00.00$0.00$0.00 Budget Amended1,000.003,000.0015,000.00$19,000.00$19,000.00 Budget Amendments .00.00.00$0.00$0.00 AdoptedBudget1,000.003,000.0015,000.00$19,000.00$19,000.00 EXPENSE TOTALS Totals 043 - Asset Seizure Fund Fund 043 - Asset Seizure Fund Other Employee Costs Account Classification Contractual Services Other Equipment EXPENSE Fund 10 Prior Year YTD.00.0016,232.70$16,232.70$16,232.70 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 00 Rec'd +++ 0% Transactions 1,000.001,000.00$2,000.00$2,000.00 .00 Budget - YTD Transactions .00.00.00$0.00$0.00 YTD Encumbrances .00.00.00$0.00$0.00 YTD Transactions Current Month.00.00.00$0.00$0.00 Budget Amended1,000.001,000.00$2,000.00$2,000.00 .00 Budget Amendments .00.00.00$0.00$0.00 AdoptedBudget1,000.00.001,000.00$2,000.00$2,000.00 EXPENSE TOTALS Totals 044 - Federal Equitable Share Funds 044 - Federal Equitable Share Funds Fund Building Improvements Account Classification Contractual Services Other Equipment EXPENSE Fund 11 Prior Year YTD.00.002,767.30.00$2,767.30$2,767.30 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 6456 Rec'd ++++++ 57% Transactions 9,167.50$9,527.20$9,527.20 359.70.00.00 Budget - YTD Transactions 11,832.50$12,472.80$12,472.80 640.30.00.00 YTD Encumbrances .00.00.00.00$0.00$0.00 YTD Transactions Current Month.00.00.00.00$0.00$0.00 Budget Amended1,000.0021,000.00$22,000.00$22,000.00 .00.00 Budget Amendments .00.0020,000.00.00$20,000.00$20,000.00 AdoptedBudget1,000.00.001,000.00.00$2,000.00$2,000.00 EXPENSE TOTALS Totals 045 - DUI Fine Fund Fund 045 - DUI Fine Fund Other Employee Costs Account Classification Contractual Services Interfund Transfers Other Equipment EXPENSE Fund 12 Prior Year YTD3,967.27.00211.6548,869.95$53,048.87$53,048.87 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 1009349 Rec'd0 206% (37,396.07)($32,313.25)($32,313.25) Transactions 4,555.74 27.08500.00 Budget - YTD Transactions 9,972.9252,396.07$62,813.25$62,813.25 .00444.26 YTD Encumbrances .00.00.00.00$0.00$0.00 YTD Transactions Current Month228.95.00.0013,654.99$13,883.94$13,883.94 Budget Amended10,000.005,000.0015,000.00$30,500.00$30,500.00 500.00 Budget Amendments .00.00.00.00$0.00$0.00 AdoptedBudget10,000.00500.005,000.0015,000.00$30,500.00$30,500.00 EXPENSE TOTALS Totals 046 - Foreign Fire Tax Board Fund 046 - Foreign Fire Tax Board Fund Fund Commodities & Supplies Account Classification Contractual Services Other Equipment EXPENSE Insurance Fund 13 Prior Year YTD.001,014,436.24$1,014,436.24$1,014,436.24 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ Rec'd56 +++ 56% Transactions 449,261.54$449,261.54$449,261.54 .00 Budget - YTD Transactions 571,738.46$571,738.46$571,738.46 .00 YTD Encumbrances .00.00$0.00$0.00 YTD Transactions Current Month.00.00$0.00$0.00 Budget Amended .001,021,000.00$1,021,000.00$1,021,000.00 Budget Amendments .00.00$0.00$0.00 AdoptedBudget.001,021,000.00$1,021,000.00$1,021,000.00 EXPENSE TOTALS Totals 048 - Business District Fund 048 - Business District Fund Fund Account Classification Interest Expense Bond Principal EXPENSE Fund 14 Prior Year YTD1,999,314.32766,919.9329,513.227,894,570.77134,745.2580,474.00220,724.73466,877.325,275.00.00813,780.371,367,303.05.00.00.00.00$13,779,497.96$13,779,497.96 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 9810298666995556 Rec'd10310084 +++++++++++++++ 88% (12,705.62)(1,046.90) Transactions 32,595.98195,230.5355,062.1989,546.955,066.363,722.68437,776.77 .00.001,294,448.06.00.00.00.00$2,099,697.00$2,099,697.00 Budget - YTD Transactions 784,882.6238,439.90105,850.81101,312.00203,969.0597,158.64 1,973,462.028,095,223.47.00207.322,282,401.231,626,330.94.00.00.00.00$15,309,238.00$15,309,238.00 YTD Encumbrances .00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00$0.00$0.00 YTD Transactions Current Month247,162.9180,288.369,709.93752,282.0710,457.908,442.6813,440.90.0047,700.00207.3222,762.05223,593.75.00.00.00.00$1,416,047.87$1,416,047.87 Budget Amended772,177.0037,393.00160,913.00101,312.00293,516.00102,225.003,930.00 2,006,058.008,290,454.00.002,720,178.002,920,779.00.00.00.00.00$17,408,935.00$17,408,935.00 Budget (359,790.00) Amendments .00.00.00.00.00.00.0037,225.00.001,546,434.00620,279.00.00.00.00.00$1,844,148.00$1,844,148.00 AdoptedBudget2,006,058.00772,177.0037,393.008,650,244.00160,913.00101,312.00293,516.00.0065,000.003,930.001,173,744.002,300,500.00.00.00.00.00$15,564,787.00$15,564,787.00 EXPENSE TOTALS Totals 050 - Water and Sewer Fund Personal Services, Scheduled Salaries & Wages 050 - Water and Sewer Fund Fund Commodities & Supplies Building Improvements Other Employee Costs Account Classification Distribution Systems Contractual Services Interfund Transfers Other Expenditures Employee Benefits Office Equipment Other Equipment Interest Expense Bond Principal Infrastructure EXPENSE Insurance Fund Utilities 15 Prior Year YTD36,903.2417,749.3670,702.131,175.00499.35.002,699.3845,490.62.00$175,219.08$175,219.08 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 9995764914 Rec'd1000 ++++++ 48% Transactions 22,346.853,574.00132,475.00$159,938.35$159,938.35 223.64798.86.00520.00.00.00 Budget - YTD Transactions 34,951.3616,554.1472,035.152,156.003,500.0021,025.00$150,221.65$150,221.65 .00.00.00 YTD Encumbrances .00.00.00.00.00.00.00.00.00$0.00$0.00 YTD Transactions Current Month4,609.221,708.594,530.48179.63.00.00.0021,025.00.00$32,052.92$32,052.92 Budget Amended35,175.0017,353.0094,382.002,156.007,074.00153,500.00$310,160.00$310,160.00 520.00.00.00 Budget Amendments .00.00.00.00.00.00.00.00.00$0.00$0.00 AdoptedBudget35,175.0017,353.0094,382.002,156.00520.00.007,074.00153,500.00.00$310,160.00$310,160.00 EXPENSE TOTALS Totals 051 - Village Parking System Fund Personal Services, Scheduled Salaries & Wages 051 - Village Parking System Fund Fund Commodities & Supplies Building Improvements Account Classification Contractual Services Interfund Transfers Other Expenditures Employee Benefits Infrastructure EXPENSE Insurance Fund 16 Prior Year YTD26,973.6012,892.0798,412.617,430.401,406.007,654.76.00.00.00.00$154,769.44$154,769.44 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 9994904850 Rec'd1000 +++++++++ 61% Transactions 10,955.695,621.635,007.0875,000.00$97,518.09$97,518.09 169.36764.33.00.00.00.00 Budget - YTD Transactions 25,660.6412,259.67103,369.315,111.371,757.004,966.92$153,124.91$153,124.91 .00.00.00.00 YTD Encumbrances .00.00.00.00.00.00.00.00.00.00$0.00$0.00 YTD Transactions Current Month3,379.031,262.974,452.59204.88146.38.00.00.00.00.00$9,445.85$9,445.85 Budget Amended25,830.0013,024.00114,325.0010,733.001,757.009,974.0075,000.00$250,643.00$250,643.00 .00.00.00 Budget Amendments .00.00.00.00.00.00.00.00.00.00$0.00$0.00 AdoptedBudget25,830.0013,024.00114,325.0010,733.001,757.009,974.00.0075,000.00.00.00$250,643.00$250,643.00 EXPENSE TOTALS Totals 052 - Parking System Revenue Fund 052 - Parking System Revenue Fund Personal Services, Scheduled Salaries & Wages Fund Commodities & Supplies Building Improvements Account Classification Contractual Services Interfund Transfers Other Expenditures Employee Benefits Infrastructure EXPENSE Insurance Fund Utilities 17 Prior Year YTD953,685.84348,324.172,365.6783,889.252,260.28640,826.383,186.52267.8018,388.63$2,053,194.54$2,053,194.54 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 9675691131098 Rec'd9972 +++ 88% (407.78) Transactions 8,566.9015,337.3546,755.72204,918.54$276,655.36$276,655.36 597.67.00512.33374.63 Budget - YTD Transactions 942,659.10364,026.651,810.33103,901.283,539.78521,599.4619,790.37 .0054.67$1,957,381.64$1,957,381.64 YTD Encumbrances .00.00.00.00.00.00.00.00.00$0.00$0.00 YTD Transactions Current Month114,361.0044,600.4773.006,167.33526.6651,525.45.00.00.00$217,253.91$217,253.91 Budget Amended951,226.00379,364.002,408.00150,657.003,132.00726,518.0020,165.00 .00567.00$2,234,037.00$2,234,037.00 Budget (8,705.00) Amendments .00.00.0047,844.00.00.00.00.00$39,139.00$39,139.00 AdoptedBudget951,226.00379,364.002,408.00102,813.003,132.00735,223.00.00567.0020,165.00$2,194,898.00$2,194,898.00 EXPENSE TOTALS Totals 060 - Vehicle Maintenance Fund Personal Services, Scheduled Salaries & Wages 060 - Vehicle Maintenance Fund Fund Commodities & Supplies Other Employee Costs Account Classification Contractual Services Other Expenditures Employee Benefits Office Equipment Other Equipment EXPENSE Fund Utilities 18 Prior Year YTD575,112.785,960.00.00$581,072.78$581,072.78 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ Rec'd58 ++++++ 58% Transactions 490,856.59$490,856.59$490,856.59 .00.00 Budget - YTD Transactions 691,549.41$691,549.41$691,549.41 .00.00 YTD Encumbrances .00.00.00$0.00$0.00 YTD Transactions Current Month.0055,363.56.00$55,363.56$55,363.56 Budget Amended .001,182,406.00.00$1,182,406.00$1,182,406.00 Budget Amendments .00273,406.00.00$273,406.00$273,406.00 AdoptedBudget.00909,000.00.00$909,000.00$909,000.00 EXPENSE TOTALS Totals 061 - Vehicle Replacement Fund 061 - Vehicle Replacement Fund Fund Account Classification Interfund Transfers Other Expenditures Motor Equipment EXPENSE Fund 19 Prior Year YTD13,050.53142,362.29$155,412.82$155,412.82 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ Rec'd39 +++ 39% Transactions 263,051.12$263,051.12$263,051.12 .00 Budget - YTD Transactions 166,328.88$166,328.88$166,328.88 .00 YTD Encumbrances .00.00$0.00$0.00 YTD Transactions Current Month.003,849.14$3,849.14$3,849.14 Budget Amended429,380.00$429,380.00$429,380.00 .00 Budget Amendments .00.00$0.00$0.00 AdoptedBudget.00429,380.00$429,380.00$429,380.00 EXPENSE TOTALS Totals 062 - Computer Replacement Fund 062 - Computer Replacement Fund Fund Account Classification Other Expenditures Office Equipment EXPENSE Fund 20 Prior Year YTD15,987.507,384,676.46130.87.00.00$7,400,794.83$7,400,794.83 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 70980 Rec'd ++++++ 96% Transactions 7,540.00137,538.02164,800.95$309,878.97$309,878.97 .00.00 Budget - YTD Transactions 17,460.00 7,752,357.98199.05.00.00$7,770,017.03$7,770,017.03 YTD Encumbrances .00.00.00.00.00$0.00$0.00 YTD Transactions Current Month5,310.00558,207.03.00.00.00$563,517.03$563,517.03 Budget Amended25,000.00165,000.00 7,889,896.00.00.00$8,079,896.00$8,079,896.00 Budget Amendments .00.00.00.00.00$0.00$0.00 AdoptedBudget25,000.007,889,896.00165,000.00.00.00$8,079,896.00$8,079,896.00 EXPENSE TOTALS Totals 063 - Risk Management Fund 063 - Risk Management Fund Fund Account Classification Contractual Services Interfund Transfers Other Equipment Infrastructure EXPENSE Insurance Fund 21 Prior Year YTD4,117,119.91142,170.8111,960.00.008,776.84.00$4,280,027.56$4,280,027.56 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 99678480 Rec'd0 +++ 98% Transactions 49,340.8550,304.482,442.002,341.98$104,529.31$104,529.31 100.00.00 Budget - YTD Transactions 103,795.5212,558.009,658.02 4,529,962.15.00.00$4,655,973.69$4,655,973.69 YTD Encumbrances .00.00.00.00.00.00$0.00$0.00 YTD Transactions Current Month380,555.835,166.80.00.00100.00.00$385,822.63$385,822.63 Budget Amended154,100.0015,000.0012,000.00 4,579,303.00100.00.00$4,760,503.00$4,760,503.00 Budget Amendments 107,133.00.00.00.00.00.00$107,133.00$107,133.00 AdoptedBudget4,472,170.00154,100.0015,000.00100.0012,000.00.00$4,653,370.00$4,653,370.00 EXPENSE TOTALS Totals 070 - Police Pension Fund Fund 070 - Police Pension Fund Commodities & Supplies Account Classification Contractual Services Other Expenditures Office Equipment Pension Benefits EXPENSE Insurance Fund 22 Prior Year YTD4,158,988.05126,606.4713,100.00.008,450.00$4,307,144.52$4,307,144.52$111,456,495.69 Expense Budget by Account Classification Report Through 12/31/15Prior Fiscal Year Activity Included % used/ 1007990067 Rec'd 99% (10,054.86) Transactions 29,021.731,507.001,000.004,000.00$25,473.87$25,473.87 $14,381,008.83 Budget - YTD Transactions 107,078.2713,493.008,000.00 4,594,875.86.00$4,723,447.13$4,723,447.13$111,618,242.17 YTD Encumbrances .00.00.00.00.00$0.00$0.00$0.00 YTD Transactions Current Month404,575.095,050.00.00.00.00$409,625.09$409,625.09$10,537,569.11 Budget Amended136,100.0015,000.001,000.0012,000.00 4,584,821.00$4,748,921.00$4,748,921.00$125,999,251.00 Budget Amendments 250,653.00.00.00.00.00$250,653.00$250,653.00$10,026,401.00 AdoptedBudget4,334,168.00136,100.0015,000.001,000.0012,000.00$4,498,268.00$4,498,268.00$115,972,850.00 Grand Totals EXPENSE TOTALS Totals 071 - Fire Pension Fund Fund 071 - Fire Pension Fund Commodities & Supplies Account Classification Contractual Services Other Expenditures Pension Benefits EXPENSE Insurance Fund 23 VILLAGE OF MOUNT PROSPECT List of Bills December 31, 2015 - January 12, 2016 Fund Vendor Name Invoice DescriptionAmount 001 General Fund ACS State & Local Government SolutionsIllinois State Disbursement Unit7,780.37 Addison Building Material Co.Maintenance and repair supplies52.15 Maintenance and repair supplies14.79 Maintenance and repair supplies50.11 Alpha Prime CommunicationsRepair of Radio Handsets2,943.50 American Solutions For BusinessParking tickets962.77 Anderson Lock CompanyMaintenance and repair supplies526.38 Andres Medical Billing, Ltd.Ambulance Billing - December 20156,901.11 Aramark Uniform Services, Inc.Uniform Expense98.14 ARC Document Solutions, LLCOther Equipment62.00 Arlington Power EquipmentPrice Difference for Grinder/Grinder Stand83.93 Chain Loop & Fuel320.08 Other Equipment60.40 Other Equipment418.36 AT & TService 12/16/15 - 1/15/16666.69 B & H Photo/videoBoardroom Upgrade Equipment35.80 CPU camera case146.00 CPU camera supplies149.95 Bedco MechanicalBuilding Maintenance and Repair172.50 Building Maintenance230.45 Bozio, IgorRefund Overpayment Police Ticket #P394525320.00 Business Office Systems, Inc.Replacement chair for PIO583.39 Busse's Flowers & GiftsMemorial Arrangement85.00 Custodial Supplies85.00 Custodial Supplies85.00 Capital One National AssociationCostco Purchase 12/2/15 - 12/22/151,673.66 Carhartt Retail, LLCCustodial Supplies931.99 Custodial Supplies289.98 Uniform Expense139.99 CashSister Cities Trivia Night 2016 Cash Register200.00 Castellanos, SalSafety Shoe Allowance180.00 CDW Government, Inc.Custodial Supplies98.99 Laptop Dock185.12 Century CleanersUniform Cleaning14.78 Uniform Cleaning27.23 Uniform Cleaning8.30 Uniform Cleaning23.25 CL Graphics, Inc.Newsletter 2016 Postage Set Up390.00 Newsletter Winter 2016 Print8,430.00 Constellation NewEnergy, Inc.Electrical Service Delivery135.29 Electrical Service Delivery31.22 Electrical Service Delivery31.20 Electrical Service Delivery84.60 Electrical Service Delivery206.65 Electrical Service Delivery137.74 Electrical Service Delivery136.93 Electrical Service Delivery134.68 Electrical Service Delivery236.73 Electrical Service Delivery323.88 Electrical Service Delivery151.51 Electrical Service Delivery147.78 Electrical Service Delivery3,018.60 Electrical Service Delivery190.15 Electrical Service Delivery170.33 Electrical Service Delivery104.72 Critical Reach2016 Fee for APBNet crime bulletin685.00 Crystal Court Shopping CenterFebruary 2016 rent for the CCC5,914.97 D.R. Myers Distributing Co, Inc.U.S. Identification Manual update service82.50 De Lage Landen Financial Services, Inc.Copier Lease Payments1,690.20 CCC Copier Lease Payment260.55 Dirtbusters Auto Detailing, Inc.Interior detail for P-1 & P-2225.00 Elite Remodeling Group, Inc.Garnishment142.22 Federal Express CorpShipping Expenses50.50 Page 1 of 8 VILLAGE OF MOUNT PROSPECT List of Bills December 31, 2015 - January 12, 2016 Fund Vendor Name Invoice DescriptionAmount Fire Pension FundFire Pension22,328.09 Fitzgerald, Ryan & JoellenTransfer Stamp Rebate840.00 Fouch, Javed & AmandaTransfer Stamp Rebate658.00 Fulton Technologies, Inc.Siren PM (6), Shared Control Center & RTU Batteries (2)2,418.52 Grainger Inc.Street light supplies232.48 Street light supplies911.42 Custodial Supplies710.14 Small Tools330.00 Graybar Electric Co.Street light supplies984.83 Street light supplies540.21 Street light supplies748.33 Street light supplies43.40 GreatAmerica Financial Services CorporationOffice equipment149.47 GuardianEmp. Dental Plan January 201610,166.56 ICMA Retirement Trust - 457ICMA 45720,851.68 Illinois Assoc of Technical Accident Investigators2016 Membership renewal: M. Eterno45.00 2016 Membership: B. Tweedie45.00 2016 Membership: M. Jolie45.00 2016 Membership: G. Sill45.00 2016 Membership: M. Evans45.00 2016 Membership: A. Weissberg45.00 Illinois City Management2016 winter conference200.00 Illinois Department of RevenueIL State Withholding28,297.37 IL State Withholding73.87 Illinois Dept.of AgricultureMembership Dues15.00 Illinois GFOAThe 2016 Fraud Awareness Seminar 1/28/1670.00 IMRFIMRF248,363.73 IMRF Accelerated Pymt. Janonis22,101.97 IMRF Accelerated Payment Huffman 201528,082.52 Infor Public Sector, Inc.Hansen Quarterly Support/Maintenance11,980.90 Internal Revenue ServiceFederal Withholding458.45 Federal Withholding177,506.64 Federal Withholding375.97 International Assoc for Property & Evidence, Inc.2016 Membership renewal: D. Okon50.00 International Assoc of Arson Investigators IL Chap2016 Training course registration for Raus, Landeweer, Hoskinson225.00 JLJ Contracting, Inc.Professional Services650.00 Juracek, Arlene2015 Centennial mayoral reimbursement112.82 Kane, Julie KReimbursment for license renewal61.50 Reimbursement for Il Elder Law Seminar199.99 Kathleen W. Bono,csr,ltd.Legal280.00 Klein, Thorpe and Jenkins, Ltd.2015 November billing45,115.67 Lands' End Business OutfittersFinance Dept - Employee Clothing43.00 Finance Dept - Employee Clothing556.00 Lund Industries, Inc.Squad equipment4,150.00 Malgorzata Wroblewska, Witold Wroblewski &Transfer Stamp Rebate540.00 Maxx Contractors CorpContractual Snow Removal87.36 Contractual Snow Removal21.06 Contractual Snow Removal159.90 Mcmaster-carr Supply Co.Custodial Supplies300.34 Menard Inc.Other Equipment9.99 Metro Door and Dock, Inc.Overhead door repair412.50 Building Maintenance and Repair650.00 Metro Federal Credit UnionMP Fire Local 4119 Dues2,239.38 Metropolitan Mayors CaucusTravel and Meeting Expenses100.00 Michael Wagner & Sons, Inc.Maintenance and repair supplies467.03 Building Maintenance and Repair176.93 Motorola Solutions, Inc.RADIO EQUIPMENT176.29 RADIO EQUIPMENT1,371.72 Mount Prospect Chamber of Commerce2016 Chamber breakfast150.00 Mount Prospect Paint, Inc.Building Maintenance and Repair181.34 Maintenance and repair supplies28.96 Mount Prospect Public LibraryFiber Optic for Village Hall 7/16/15 - 10/15/151,385.49 Fiber Optic for CCC 7/16/15 - 10/15/15975.20 Fiber Optic for Village Hall 10/16/15 - 1/15/16396.13 Fiber Optic for CCC 10/16/15 - 1/15/16252.78 2016 Annual Lease Payment - Parking Garage1.00 Nationwide Mutual Insurance CompanyNationwide 45710,972.95 NCPERS Group Life Ins.IMRF Life Insurance665.60 New World Systems CorporationGASB & Project - Travel Time & Expenses600.00 GASB & Project - Travel Time & Expenses1,503.19 NICORNatural Gas Consumption68.11 Page 2 of 8 VILLAGE OF MOUNT PROSPECT List of Bills December 31, 2015 - January 12, 2016 Fund Vendor Name Invoice DescriptionAmount Natural Gas Consumption84.03 Natural Gas Consumption2,117.08 Natural Gas Consumption1,342.18 Natural Gas Consumption459.05 Natural Gas Consumption415.10 Natural Gas Consumption311.51 NIOA2016 Membership renewal: G.Sill80.00 Northern Illinois Police Alarm SystemLanguage line - November, 2015112.50 Northshore University HealthsystemLead test55.00 Lead test55.00 Northwest Central Dispatch SystemFebruary 2016 - Member Assessment56,340.50 Northwest Police AcademyTraining Registration125.00 Northwest Suburban United WayUnited Way141.36 Otis Elevator CompanyEquipment Maintenance and Repair11,995.60 Perrce, Paul J.Equipment Maintenance and Repair448.00 Pesche's Flower ShopTree/Bush/Flower Replacement39.96 Tree/Bush/Flower Replacement150.89 Petty CashPetty Cash425.76 2015 petty cash415.62 Petty Cash 12/201569.78 FD's Petty Cash-December 201538.11 Police Pension FundPolice Pension29,498.93 Promos 911, Inc.Retractable Pens (500) & Memobooks (2,000)1,198.36 Prosafety, Inc.Custodial Supplies838.50 Street light supplies145.95 Purple Rose Florist Inc.Angell arrangement59.00 Quality BlacktopRefund Building Fee Permit #15-1688 (1104 Westgate Rd)50.00 Ray O'herron Co., Inc.Shipping charges for CSO Trejo's uniforms10.00 Red Wing Shoe StoreSafety Shoe Allowance364.64 Reliance Standard Life Insurance Co.Short Term Disability2,997.60 rescueDIRECT, Inc.Stearns Search and Rescue & Inflatable PFD616.65 Resource Management Assoc.Fire Lieutenant Examination5,179.56 Rkon Inc.Firewall Upgrade3,150.00 Sound IncorporatedVoice Mail Upgrade1,580.00 Staples Contract & Commercial, Inc.Copy Paper897.60 Steiner Electric CompanyStreet light supplies399.04 Sterling Codifiers, Inc.Recording500.00 Sullivans Law Directory9/17/15 Judgment 15CH 7881 Bulletin600.00 The Carroll-Keller GroupCoaching & Couseling-Dolan/Lambel-11/16/15430.00 Third Millennium Assoc.inc.Annual Lockbox & Fulfillment Center Set Up/Maintenance Fee650.00 Vehicle Online Payment System - Annual Maintenance Fee495.00 Vehicle Sticker Software Annual Maintenance Fee995.00 TransUnion Risk and Alternative Data Solutions IncBackground checks - December, 2015210.50 Tyler Technologies, Inc.Assist with Upgrade Ref#2179977 12/17/151,200.00 United States Postal ServiceCAPS Postage Dec4,869.74 Usnik, RobertReimbursement - Postage Expense 1/5/166.28 VCG UniformEckert Uniform901.10 Socks for Liebgott13.90 Uniform Chest Badges (6)269.70 CERT Uniform Expense 2015496.65 Verizon Wireless Services LLCCellular Service & Equipment Charges - 11/20/15 - 12/19/157,095.80 Warehouse Direct3 Boxes of Folders61.71 Paper, Sugar & Creamers119.61 Replacement for defective toner cartridge145.99 Credit for defective toner purchased in 2015(145.99) Parts & labor for Records printer533.87 Water Environment FederationSubscription renewal158.00 Waterway IllinoisAnnual Ground Ladder Testing-2015261.25 Wide Open WestMonthly Backup Internet233.00 Fire ST#14 - Data & Internet Services (T1) 12/20/15-1/19/16233.00 Wisconsin Department of RevenueWI State Withholding990.58 WISCTFGarnishment542.48 001 General Fund Total848,541.92 Page 3 of 8 VILLAGE OF MOUNT PROSPECT List of Bills December 31, 2015 - January 12, 2016 Fund Vendor Name Invoice DescriptionAmount 002 Debt Service Fund Bank of New York MellonPaying Agent Fee - GO Bonds Series 2009B802.50 Paying Agent Fee - GO Bonds Series 2009C802.50 002 Debt Service Fund Total1,605.00 020 Capital Improvement Fund B & H Photo/videoBoardroom Upgrade Equipment306.49 Capital One National AssociationCostco Purchase 12/2/15 - 12/22/15348.98 Northwest Central 9-1-1 SystemMotorola Subscriber Financing - January 201610,603.91 020 Capital Improvement Fund Total11,259.38 023 Street Improvement Construction Fund Arrow Road ConstructionStreet Resurfacing Project363,006.01 Ciorba Group Inc2015 Bridge Inspections1,090.60 O'Brien, MelindaRefund Overpayment Vehicle Sticker#3289080.00 Rubino Engineering, Inc.Professional Services863.00 Professional Services1,617.00 Resurfacing Testing1,112.00 Resurfacing Testing1,068.00 023 Street Improvement Construction Fund Total368,836.61 040 Refuse Disposal Fund AT & TService 12/16/15 - 1/15/163.71 Groot Industries, Inc.Refuse Disposal Program259.65 ICMA Retirement Trust - 457ICMA 45770.05 Illinois Department of RevenueIL State Withholding280.07 IMRFIMRF5,310.38 Internal Revenue ServiceFederal Withholding2,294.36 Nationwide Mutual Insurance CompanyNationwide 457165.77 NCPERS Group Life Ins.IMRF Life Insurance17.60 United States Postal ServiceCAPS Postage Dec1,413.86 040 Refuse Disposal Fund Total9,815.45 041 Motor Fuel Tax Fund Maxx Contractors CorpContractual Snow Removal5,289.76 Contractual Snow Removal1,275.21 Contractual Snow Removal9,682.15 Morton Salt, IncSalt/De-Icing Agents14,645.19 Salt/De-Icing Agents4,298.46 041 Motor Fuel Tax Fund Total35,190.77 042 CDBG De Lage Landen Financial Services, Inc.Copier Lease Payments94.80 Federal Express CorpCDBG delivery charge26.05 ICMA Retirement Trust - 457ICMA 457450.00 Illinois Department of RevenueIL State Withholding50.27 IMRFIMRF945.60 Internal Revenue ServiceFederal Withholding484.11 042 CDBG Total2,050.83 046 Foreign Fire Tax Board Fund ComcastService 12/1/15-12/31/15 (2000 E Kensington Rd)80.87 Service 1/1/16-1/31/16 (2000 E Kensington Rd)93.71 La-Z-Boy Showcase Shopps, Inc.La-Z Boy Recliner Chairs Station #12 & #1313,654.99 046 Foreign Fire Tax Board Fund Total13,829.57 050 Water and Sewer Fund Addison Building Material Co.Repair Maintenance Supplies97.68 American Landscaping Inc.Parkway Restoration27,070.00 Aramark Uniform Services, Inc.Uniform Expense98.14 Ariens Specialty Brands LLCUniform Expense59.27 AT & TService 12/16/15 - 1/15/16247.57 Badger Meter IncAMR Systems Supplies37.95 Baxter & Woodman, Inc.Combined Sewer Improvements3,550.00 Bill's Commercial Painting Inc.Building Maintenance and Repair3,310.00 Painting Services2,752.00 Burns & Mcdonnell Engineering Co.Professional Services17,197.59 Century CleanersUniform Cleaning14.77 Uniform Cleaning27.22 Uniform Cleaning8.30 Uniform Cleaning23.25 Page 4 of 8 VILLAGE OF MOUNT PROSPECT List of Bills December 31, 2015 - January 12, 2016 Fund Vendor Name Invoice DescriptionAmount Devdatt PatelUtility Refund125.60 HBK Water Meter ServiceAMR Systems1,885.45 ICMA Retirement Trust - 457ICMA 4571,303.99 Illinois Department of RevenueIL State Withholding2,505.11 Illinois Pump, Inc.Panel Replacement145.83 Panel Replacement333.33 Panel Replacement2,128.00 Panel Replacement3,201.43 IMRFIMRF40,764.34 Internal Revenue ServiceFederal Withholding20,430.37 Michelle KolasaUtility Refund61.03 Nationwide Mutual Insurance CompanyNationwide 457340.89 NCPERS Group Life Ins.IMRF Life Insurance44.80 NICORNatural Gas Consumption169.62 Natural Gas Consumption38.03 Natural Gas Consumption173.86 Natural Gas Consumption116.52 Natural Gas Consumption82.37 Natural Gas Consumption1,542.04 NMZ Properties LLCUtility Refund20.83 Northwest Suburban United WayUnited Way21.00 Proforma Customized GraphicsUniform Expense454.67 Red Wing Shoe StoreSafety Shoe Allowance332.99 Safety Shoe Allowance1,387.52 Reliance Standard Life Insurance Co.Short Term Disability118.92 Safiullah MohammedUtility Refund149.69 Seiler Instrument & Mfg.co.incGIS Maintenance2,495.00 Slesicki, KyleSafety Shoe Allowance180.00 Tank Industry Consultants, Inc.Professional Services3,850.00 The Eye SiteUtility Refund55.22 Third Millennium Assoc.inc.December Utility Billing2,391.83 United States Postal ServiceCAPS Postage Dec4,483.82 Verizon Wireless Services LLCCellular Service & Equipment Charges - 11/20/15 - 12/19/15401.37 050 Water and Sewer Fund Total146,229.21 051 Village Parking System Fund Elite Remodeling Group, Inc.Garnishment78.19 ICMA Retirement Trust - 457ICMA 4578.99 Illinois Department of RevenueIL State Withholding46.64 IMRFIMRF737.45 Internal Revenue ServiceFederal Withholding388.47 Nationwide Mutual Insurance CompanyNationwide 4579.96 NCPERS Group Life Ins.IMRF Life Insurance4.40 Petty CashPetty Cash 12/201521.00 051 Village Parking System Fund Total1,295.10 052 Parking System Revenue Fund Elite Remodeling Group, Inc.Garnishment64.02 ICMA Retirement Trust - 457ICMA 4576.01 Illinois Department of RevenueIL State Withholding33.78 IMRFIMRF541.72 Internal Revenue ServiceFederal Withholding279.76 Maxx Contractors CorpContractual Snow Removal222.88 Contractual Snow Removal53.73 Contractual Snow Removal407.95 Nationwide Mutual Insurance CompanyNationwide 4576.65 NCPERS Group Life Ins.IMRF Life Insurance3.60 Petty CashPetty Cash 12/20154.00 052 Parking System Revenue Fund Total1,624.10 060 Vehicle Maintenance Fund American MessagingProfessional Services79.74 Arlington Heights FordVehicle Maintenance Supplies188.45 AT & TService 12/16/15 - 1/15/169.27 Bridgestone Retail Operations, LLC.Vehicle Maintenance Supplies379.24 Vehicle Maintenance Supplies1,294.56 Vehicle Maintenance Supplies403.08 Cylinders, Inc.Equipment Maintenance and Repair336.05 Dave & Jim's Auto Body, Inc.Equipment Maintenance and Repair120.00 ICMA Retirement Trust - 457ICMA 4571,364.56 Illinois Department of RevenueIL State Withholding1,118.48 Page 5 of 8 VILLAGE OF MOUNT PROSPECT List of Bills December 31, 2015 - January 12, 2016 Fund Vendor Name Invoice DescriptionAmount IMRFIMRF18,251.98 Internal Revenue ServiceFederal Withholding9,229.52 Interstate Power Systems, Inc.Vehicle Maintenance Supplies45.72 Mcmaster-carr Supply Co.Vehicle Maintenance Supplies169.48 Morton Grove AutomotiveVehicle Maintenance Supplies145.00 Motion Ind. Inc.Vehicle Maintenance Supplies1,075.78 NCPERS Group Life Ins.IMRF Life Insurance48.00 Northwest Suburban United WayUnited Way4.00 Reliance Standard Life Insurance Co.Short Term Disability97.34 Ronco Industrial SupplyVehicle Maintenance Supplies89.90 Rubber Inc.Small Tools452.00 Rush Truck Centers of Illinois, Inc.Vehicle Maintenance Supplies374.00 Vehicle Maintenance Supplies80.92 Vehicle Maintenance Supplies223.40 Sid Tool Co., Inc.Vehicle Maintenance Supplies32.14 Terrace Supply CompanyEquipment Maintenance and Repair26.35 Vehicle Maintenance Supplies102.33 Verizon Wireless Services LLCCellular Service & Equipment Charges - 11/20/15 - 12/19/15234.50 West Side Tractor SalesVehicle Maintenance Supplies246.41 060 Vehicle Maintenance Fund Total36,222.20 061 Vehicle Replacement Fund Bonnell Industries Inc.Equipment for Public Works Vehicles858.00 Wholesale Direct Inc.Equipment for Public Works Vehicles619.04 061 Vehicle Replacement Fund Total1,477.04 062 Computer Replacement Fund SHI International Corp.MS Surface Pro 41,532.00 062 Computer Replacement Fund Total1,532.00 063 Risk Management Fund Arthur J. Gallagher Rms, Inc.Excess Workers Comp Policy #SP405433995,302.00 Risk Management Fee - Policy# VILMOUPR12,382.00 Property Policy #35826710&Equip.Floater Policy#6613532- Renewal112,920.00 Public Officials Bond Policy#404019123 100.00 Intergovernmental Per.ben.coopIPBC - January 2016487,892.78 063 Risk Management Fund Total724,136.85 070 Police Pension Fund Internal Revenue ServiceFederal Withholding48,850.03 070 Police Pension Fund Total48,850.03 071 Fire Pension Fund Collins & RadjaQuarterly Retainer Fee - Oct , Nov & Dec 2015800.00 Internal Revenue ServiceFederal Withholding47,149.98 071 Fire Pension Fund Total47,949.98 073 Escrow Deposit Fund A Better PlumberRefund Escrow Permit # 15-2373 (1612 Cedar Ln)500.00 A Lamp Concrete ContractorsRefund Escrow Permit # 15-1359 (420 Dempster St)125.00 Advantage 1Refund Escrow Permit # 14-2312 (311 S Leonard Ln)150.00 American Deck Builders IncRefund Escrow Permit # 15-0535 (221 N Maple St)200.00 Associated Heating GroupRefund Escrow Permit # 15-2278 (400 S Mt Prospect Rd)25.00 Bancare IncRefund Escrow Permit # 15-0989 (1080 S Elmhurst Rd)350.00 Refund Escrow Permit # 15-1026 (200 E Kensington Rd)200.00 Refund Escrow Permit # 15-1028 (1080 S Elmhurst Rd)200.00 Borscha, John FRefund Escrow Permit # 15-1796 (1719 E Aztec Ln)125.00 Bose, Dwayne WRefund Escrow Permit # 15-2145 (547 Dempster St)125.00 Bowman, KennethRefund Escrow Permit # 15-2448 (613 N Pine St)125.00 Bozek, JoeRefund Escrow Permit # 15-2429 (2018 E Wintergreen Ave)125.00 Brett Winandy IncRefund Escrow Permit # 15-1841 (1006 Butternut Ln #A)200.00 Castello, AdamRefund Escrow Permit # 14-0848 (1201 Feehanville Dr)125.00 Central Continental BakeryRefund Escrow Permit # 14-1790 (101 S Main St)125.00 Chahal, MandeepRefund Escrow Permit # 15-2107 (543 Dempster St #1E)125.00 Chowaniec, MichaelRefund Escrow Permit # 15-2117 (622 N Eastwood Ave)200.00 CNC Graphics LtdRefund Escrow Permit # 15-1551 (1061 Feehanville Dr)125.00 Comerford, ThomasRefund Escrow Permit # 15-0033 (16 N William St)300.00 Cook, William ERefund Escrow Permit # 15-2250 (1714 N Aspen Dr)200.00 Cummins Allison CorpRefund Escrow Permit # 15-1565 (851 Feehanville Dr)125.00 Davis, RyanRefund Escrow Permit # 15-1196 (605 S Na Wa Ta Ave)125.00 Page 6 of 8 VILLAGE OF MOUNT PROSPECT List of Bills December 31, 2015 - January 12, 2016 Fund Vendor Name Invoice DescriptionAmount Diego, EliseoRefund Escrow Permit # 15-1455 (561 Dempster Dr)125.00 Dietz, KellyRefund Escrow Permit # 15-1194 (221 Raleigh Pl)200.00 DM Services IncRefund Escrow Permit # 15-1806 (407 N Dale Ave)125.00 Refund Escrow Permit # 15-2063 (514 S William St)125.00 Dotman, ThurmanRefund Escrow Permit # 15-1267 (1801 E Wood Ln)125.00 Draintech Sewer & SepticRefund Escrow Permit # 15-1200 (1321 N Columbine Dr)125.00 Dubois Paving CompanyRefund Escrow Permit # 15-0572 (801 Butternut Ln)200.00 Refund Escrow Permit # 15-0573 (803 Butternut Ln)200.00 Eugenia, PipilasRefund Escrow Permit # 15-1814 (567 Dempster St)125.00 Evolution Plumbing IncRefund Escrow Permit # 15-2503 (1409 W Busse Ave)125.00 Finn, Patrick ARefund Escrow Permit # 14-1699 (507 N Forest Ave)700.00 Fortis ConcreteRefund Escrow Permit # 15-2218 (1531 W Blackhawk Dr)150.00 Four Seasons Heating and A/CRefund Escrow Permit # 15-2492 (1108 E Linden Ln)125.00 Four Seasons Home Services LLCRefund Escrow Permit # 14-2532 (1108 E Linden Ln)125.00 Frisch, CindyRefund Escrow Permit # 15-2438 (540 Lois Ct)125.00 Gale, SallyRefund Escrow Permit # 15-2491 (1503 W Willow Ln)125.00 GHC MechanicalRefund Escrow Permit # 15-2017 (20 S Main St)125.00 Refund Escrow Permit # 15-2018 (11 S Wille St)125.00 Giersten Company of ILRefund Escrow Permit # 15-1547 (1444 S Busse Rd)125.00 Grant & Power Landscaping IncRefund Escrow Permit # 15-1881 (408 N Wille St)200.00 Higland Park ElectricRefund Escrow Permit # 15-2167 (1112 N Greenfield Ln)125.00 Hong, NancyRefund Escrow Permit # 15-1966 (901 S Albert St)200.00 Hoppesch, DorthyRefund Escrow Permit # 15-2050 (422 E Northwest Hwy)125.00 Hunzinger Williams IncRefund Escrow Permit # 15-2093 (878 E Northwest Highway)125.00 Ibbotson Heating CompanyRefund Escrow Permit # 15-2485 (1108 Barberry Ln)125.00 Innovative Home Services IncRefund Escrow Permit # 15-1377 (609 S Main St)250.00 Integrity Sign CompanyRefund Escrow Permit # 15-0284 (13 W Rand Rd)125.00 International PavingRefund Escrow Permit # 15-1644 (539 E Lincoln St)125.00 J & S Plumbing IncRefund Escrow Permit # 15-2412 (1921 Burr Oak Dr)500.00 Kang, Chang GeunRefund Escrow Permit # 15-1482 (900 Harvest Ln)200.00 Kenilworth Condominium Assoc.Refund Escrow Permit # 15-1933 (1255 W Prospect Ave)125.00 Knoll, KennethRefund Escrow Permit # 15-2164 (1406 N Boro Ln)200.00 Koczwara, DarekRefund Escrow Permit # 15-0975 (622 N Fairview Ave)250.00 Kosirog, MarkRefund Escrow Permit # 15-2192 (500 S Na Wa Ta Ave)125.00 Langos CorpRefund Escrow Permit # 15-2030 (100 W Rand Rd)500.00 Larson, DavidRefund Escrow Permit # 15-0512 (8 N Maple St)200.00 Leo's Plumbing IncRefund Escrow Permit # 15-2305 (571 Huntington Commons Rd)125.00 Lies, Richard LRefund Escrow Permit # 15-1378 (403 S Hi Lusi Ave)125.00 Lorusso, MichaelRefund Escrow Permit # 15-2127 (14 N Pine St)200.00 Mastercat TeamRefund Escrow Permit # 15-0235 (2009 E Seminole Ln)125.00 Mehmet, AstritRefund Escrow Permit # 15-2409 (207 S Emerson St)125.00 Midwest Comfort Heating & CoolingRefund Escrow Permit # 15-2461 (508 S George St)75.00 Mieling, Jonathan BRefund Escrow Permit # 15-2370 (8 N Waverly Pl)125.00 Mihlbauer, James GRefund Escrow Permit # 15-1315 (503 Dempster St)125.00 Mostafa, HalaRefund Escrow Permit # 15-2443 (1825 W Palm Dr)125.00 Mt Prospect Pancake HouseRefund Escrow Permit # 15-2211 (401 E Euclid Ave)125.00 Mt Prospect Public LibraryRefund Escrow Permit # 15-1170 (10 S Emerson St)500.00 Northscape EnterprisesRefund Escrow Permit # 15-2217 (1302 N Lama Ln)200.00 Northwest Landscape ContractorRefund Escrow Permit # 15-2058 (700 E Busse Ave)200.00 Olympic Signs IncRefund Escrow Permit # 15-1096 (909 N Elmhurst Rd)125.00 Panther ConstructionRefund Escrow Permit # 15-1154 (1000 Mt prospect Plz)125.00 Patel, Alpana ARefund Escrow Permit # 15-1972 (1115 N Greenfield Ln)125.00 Pena Group IncRefund Escrow Permit # 15-0985 (1511 W Blackhawk Dr)200.00 Plaza, DarrickRefund Escrow Permit # 15-1626 (1720 Bonita Ave)200.00 Popp, RonaldRefund Escrow Permit # 15-2288 (500 W Central Rd)125.00 Prestige RenovationsRefund Escrow Permit # 15-1100 (1404 Orange Ct #B)250.00 Quality Blacktop LLCRefund Escrow Permit # 15-1688 (1104 N Westgate Rd)200.00 QWR Services IncRefund Escrow Permit # 15-0961 (405 S Ojibwa Trl)125.00 Ricks Sewer & DrainageRefund Escrow Permit # 15-2452 (407 N Prospect Manor Ave)125.00 Refund Escrow Permit # 15-1865 (107 S Elm St)125.00 Refund Escrow Permit # 15-2380 (314 S Beverly Ln)125.00 Refund Escrow Permit # 15-2405 (1200 W Pendleton Pl)500.00 Refund Escrow Permit # 15-2453 (1722 Myrtle Dr)125.00 Refund Escrow Permit # 15-2501 (1713 W Myrtle Dr)125.00 Roberts Drapery CenterRefund Escrow Permit # 15-1885 (504 E Northwest Hwy)125.00 Rodriguez, JuliosRefund Escrow Permit # 15-1438 (808 W Lincoln St)200.00 Page 7 of 8 VILLAGE OF MOUNT PROSPECT List of Bills December 31, 2015 - January 12, 2016 Fund Vendor Name Invoice DescriptionAmount S Haines Paving and ExcavatingRefund Escrow Permit # 15-2306 (999 N Elmhurst Rd)125.00 Salinas, NoeRefund Escrow Permit # 15-0072 (121 N Wille St)50.00 Scaravalle Construction IncRefund Escrow Permit # 15-2163 (1721 W Rusty Dr)200.00 Scott General ContractingRefund Escrow Permit # 15-1715 (301 E Euclid Ave)700.00 Solar One LLCRefund Escrow Permit # 15-1670 (1427 S Busse Rd)125.00 Taylor Plumbing IncRefund Escrow Permit # 15-1358 (225 W Rand Rd)125.00 The Plumbing SmithRefund Escrow Permit # 15-1937 (280 N Westgate Rd)125.00 Third District Circuit CourtBond Check 12/31/15150.00 Bond Check 1/5/161,000.00 Bond Check 1/7/16525.00 Tu, LuhuiRefund Escrow Permit # 14-2200 (1002 W Lincoln St)100.00 Versa Core Construction Services LLCRefund Escrow Permit # 15-0025 (13 W Rand Rd)25,030.00 Village Sewer & PlumbingRefund Escrow Permit # 15-2462 (1777 W Crystal Ln)125.00 Wadhwani, Keloo SRefund Escrow Permit # 15-2489 (1805 W Willow Ln)125.00 Walk In BathtubsRefund Escrow Permit # 15-1970 (1400 N Elmhurst Rd #114)150.00 Weiler, EdwardRefund Escrow Permit # 15-0894 (110 N Elm St)200.00 Wilfing, HelgaRefund Escrow Permit # 15-2214 (205 S Weller Ln)125.00 Zalewski, KrzysztofRefund Escrow Permit # 15-2460 (545 Dempster St)125.00 073 Escrow Deposit Fund Total44,805.00 Grand Total2,345,251.04 Page 8 of 8