Loading...
HomeMy WebLinkAbout3. Monthly Financial Report & Approve Bills 02/17/201511 MOM It I'l"OSI)CO Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM FINANCE DIRECTOR DATE: FEBRUARY 12, 2015 SUBJECT: MONTHLY FINANCIAL REPORT — JANUARY 2015 Attached hereto are the cash position and investment statements of the Village for the month ended January 31, 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, Debt Service Fund, Special Revenue Funds, Capital Project Funds and Internal Service Funds. The Enterprise Funds consist of the Water/Sewer Fund and two (2) Parking Funds. Trust funds include the Village's two public safety pensions (Police and Firefighters') while the agency funds include the Escrow Deposit, Flexcomp Escrow and Library Bonds Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Library Bonds Escrow Fund accounts for the accumulation of monies for debt service payments. Governmental and Enterprise Funds - Cash and cash equivalents at December 31 were $42.8 million. During January, cash receipts totaled $5,239,089 while interest earnings were $1,414. Reductions to cash and cash equivalents during January totaled $4,507,996. Of this amount, payments to vendors were $3,078,965 and employee payroll and related expenses were $1,429,031. Other disbursements totaled $7,803. There was also a net decrease in cash due to interfund activity of $128,972 and a net decrease in cash due to investment activity of $6,137,603. The large decrease for investment activity was the result of investing bond proceeds into CD's carrying various principal amounts and maturities. Cash and cash equivalents at January 31 were $37.3 million. Monthly Financial Report — January 2015 February 12, 2015 Page 2 There were no investments in the Governmental and Enterprise Funds at December 31, 2014. During the month, investments into multiple CD's with various principal amounts and maturities totaled $6,137,603. CD's were purchased using proceeds from the Series 2013 bond issue. The maturity dates of the CD's were laddered to match the revised payout schedule of the underlying flood work. Total investments at January 31 were $6,137,603. Total cash and investments for Governmental and Enterprise Funds at December 31 were $42.8 million. Cash and investments at January 31 totaled $43.4 million. The increase for the month totaled $595,733. Trust and Agency Funds - Cash and cash equivalents at December 31 were $3.5 million. During January, cash receipts totaled $265,266. In addition, investment income for the month was $198,040 and inflows due to interfund activity totaled $128,972. There was also a net increase in cash due to investment activities of $1,131,853. Reductions to cash and cash equivalents during January totaled $768,480. Of this amount, payments to vendors were $128,525, employee payroll and related expenses were $609,610, payments related to the flexible 'L.I.. .J 4-4-1-4 TOn OA .1 ll+L, +., f...- +he +h $'1,0-71. r'ask flexible Jt. endin tlloglc11II LULdICU P,)L/,J`t . Other receipts IUI LI 1U IIIOI1Lll were Ivasll and cash equivalents at January 31 were $4.5 million. Total investments at January 31 were $111,460,602, a decrease of $695,463 from December 31. There were investment gains of $436,390 and a net transfer out totaling $1,131,853 that accounted for the change. Total cash and investments for Trust and Agency Funds at December 31 were $115,670,660. Cash and investments at January 31 totaled $115,934,519. This is an increase from the balance at December 31 of $263,859. Summary of Cash Activity by Fund Type (page 2) This report provides a breakdown of the cash activity for the month broken down by fund type. This breakdown is useful in identifying where the activity (receipts and disbursements) is occurring. There are times during the year when activity in certain funds such as the capital improvement and special revenue funds is higher than normal. This will distort the financial picture of some of the other components of the governmental funds such as the General Fund which tends to be more level and predictable in terms of spending and receipt of revenue. Each month the report will provide detail explanation on activity of the General Fund, the Village's primary operating fund. The report will also provide additional information on fund types that experienced higher than normal activity for the month. Each of these is highlighted below. General Fund — Cash and cash equivalents at December 31 totaled $7.1 million. During January, cash receipts totaled $3,118,846. Investment income for the month was $324. Significant cash receipts included sales and income taxes and the real estate transfer tax. Sales tax revenues for the month totaled $1,274,852. Of this amount, $1,161,005 was generated from the 1% state portion while $113,847 was generated from the .25% home rule portion. Sales taxes received in January are for October sales as there is a normal three-month lag in getting this distribution from the state. H:WCCT\Treasurer's Report\2015\Monthly Cash Position Report -Janauary 2015.docx Monthly Financial Report — January 2015 February 12, 2015 Page 3 State income tax receipts for January totaled $606,765 representing 2 months of activity (October and November). The state continues to be 2-3 months in arrears in remitting these taxes to the Village. Real estate transfer tax receipts for January were $314,627. This is nearly 40% of the total annual budget. Several larger property transfers closed during the month that were not anticipated. January receipts are typically $20,000 - $40,000. The budget for this item may be adjusted at mid -year based on future receipts. Disbursements from the General Fund for January included payments to vendors of $1,187,888 and payments for employee wages and benefits of $1,245,387. Interfund transfers of $839,037 for health premiums and vehicle lease and maintenance payments were also made during the month. Other disbursements totaled $7,803. Cash and cash equivalents at January 31 were $6,947,717. This is a decrease of $160,945 from the previous month. Currently, there are no investments in the General Fund. Statement of Investments (page 3) This report provides a breakdown of investments by governmental and enterprise funds and trust and agency funds. The report also provides a fund -by fund breakdown of the investments. Government and Enterprise Funds - Investments for the governmental and agency funds are typically made up of Certificates of Deposit. At January 31 there was a total of $6,137,603 invested in CD's. These CD's are investing proceeds of the 2013 flood control bond issue. Other surplus funds in the governmental and enterprise funds have been placed in interest bearing money market accounts. Detail on the investments for the Governmental and Enterprise Funds is included as an attachment to this memo. Trust and Agency Funds — The investments for the trust and agency funds are made up of certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in the Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of the reserves for this fund are invested in the more liquid money market account due to the nature of the deposit. Escrow refunds are processed two times per month. Investments for the Police and Firefighter Pension Funds consist of various fixed income securities as well as equity mutual fund accounts. Wells Fargo is the third -party holder of the fixed income securities. The funds are managed by three investment management firms, Galliard, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of the fixed income investments for the two pension funds while Galliard and Mesirow manage the balance of fixed income investments for these two funds. Each manager maintains a small portion of their portfolio in cash to help facilitate liquidity and trading. Investments in equities consist of mutual funds spread across various sectors (small, mid and large -cap stocks) as well as investment philosophies (value, core and growth). The 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 -Janauary 2015.docx Monthly Financial Report — January 2015 February 12, 2015 Page 4 Maturity Purchase Financial Date Date Institution POLICE PENSI67N E NI3 (0M Various Various Wells Fargo Various Various Various FIRE PENS[GN UBD(0711 Various Various Wells Fargo Various Various Various TOTAL TRUST AND AGENCY FUND INVESTMENTS Investment CUSIP/ Interest Market Description Acct 4 Rate % Value Wells Fargo Investments Various Mutual Fund Investments Various Wells Fargo Investments Various Mutual Fund Investments Various Various $ 23,178,320.02 Various 33,437,615.91 56,615,935.93 Various 19,984,808.84 Various 34,859,857.58 54,844,666.42 $ 111,460,602.35 Investment of the Village's pension funds is governed by an Investment Policy adopted by each Pension Board. Conclusion As mentioned earlier, this cash position report is intended to provide a snapshot of the Village's cash position as of a particular month end date. Over time, this report will be able to provide trend information to help in cash management duties, maximizing investment earnings while ensuring availability of funds to meet the Village's commitments. The cash position report will continue to be provided to the Village Board and Finance Commission on a monthly basis. David O. Erb Finance Director H:\ACCT\Treasurer's Report\2015\Monthly Cash Position Report -Janauary 2015.docx VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended January 31, 2015 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and Cash Equivalents Investments Balance at December 31, 2014 $ 42,835,122.31 $ Cash receipts 5,239,089.05 Investment income 1,414.04 Transfers from investments to cash 2,856,033.03 (2,856,033.03) Transfers to investments from cash (6,137,603.36) 6,137,603.36 Interfund activity (128,971.56) Disbursements: Accounts payable Payroll Other Balance at January 31, 2015 Balance at December 31, 2014 (3,078,964.80) (1,429,031.09) (7,803.09) Total Cash and Investments $ 42,835,122.31 5,239,089.05 1,414.04 (128,971.56) (3,078,964.80) (1,429,031.09) (7,803.09) $ 37,293,251.50 $ 6,137,603.36 $ 43,430,854.86 TRUST AND AGENCY FUNDS * Cash and Cash Total Cash and Equivalents Investments Investments $ 3,514,594.91 $ 112,156,064.84 $ 115,670,659.75 Cash receipts 265,265.71 Investment income (loss) 198,040.35 436,390.11 Transfers from investments to cash 2,856,033.03 (2,856,033.03) Transfers to investments from cash (1,724,180.43) 1,724,180.43 Interfund activity 128,971.56 Disbursements: Accounts payable Payroll Flex spending Other Balance at January 31, 2015 (128,525.46) (609,609.72) (30,344.18) 3,670.86 265,265.71 634,430.46 128,971.56 (128,525.46) (609,609.72) (30,344.18) 3,670.86 $ 4,473,916.63 $ 111,460,602.35 $ 115,934,518.98 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 VILLAGE OF MOUNT PROSPECT IMMVIT-akyl mtt - I GOVERNMENTAL AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS * Ending balance 6,947,716.75 4,201,506.56 122,582.62 10,705,592.06 4,758.591 81 10,5572261.70 37293,251z50 3,259,43075 1,214,485.88 41.767,168.13 INVESTMENTS Certificates of deposit 6,137,603.36 6:137,603-36 6.137,603.36 Wells Fargo investments - 43,163,128.86 43,163,128.86 Mutual fund investments - 68.297,473.49 68,297,473-49 Total investments 6,137,60336 6,137,603 36 111.460,602.35_ 117,598205_71 TOTAL CASH AND INVESTMENTS $ 6,947,716.75 $ 4,201,506.56 $ 122,582.62 $ 16,843,195.42 $ 4,758,591.81 $ 10.557.261.70 $ 43.430.854.86 $114,720,033.10 $ 1,214,485.88 $159,365,373.84 * Assets are restricted in purpose and do not represent discretionary assets of the government K) 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 $ 7,108,662.19 $ 4,062,665.64 $ 122,582.62 $ 16,277,670.06 $ 4,842,455.14 $ 10,421,086.66 $ 42,835,12231 2,290,788.12 $ 1,223,806.79 $ 46,349,717.22 Cash receipts 3,118,84633 499,444.63 - 639,164.38 945,069.96 36,563.75 5,239,089.05 213,010.71 52,255.00 5,504,354.76 Investment income 323,91 39.54 445.99 154.09 450.51 1,414.04 197,941.93 98.42 199,454.39 Transfers from investments - - - - - - 2,856,033.03 - 2,856,033.03 Transfers to investments - - (6,137,603.36) a - (6,137,60336) (1,724,180.43) (7,861,783 79) Interfund (839,037 43) 32,83918 (173,569,76) 850,79645 (128,971.56) 137,427.97 (8.456.41) (0.00) Disbursements - other (7,803,09) - - (7,803.09) - 3,670.86 (4,132.23) Disbursements - flexible spending (30:344.18) (30,344.18) Disbursements - payroll (1,245,386.73) (14,693.19) (116,351.44) (52,599.73) (1,429,031.09) (609,609,72) (2,038,640.81) Disbursements -accounts payable _ (1,187,888.43) (378,78924) (74.085.01) (739,166.18) (699,03594) (3.078,964.80) (101,980.86) (26.544.60)L 3,20T490_2�� _ Ending balance 6,947,716.75 4,201,506.56 122,582.62 10,705,592.06 4,758.591 81 10,5572261.70 37293,251z50 3,259,43075 1,214,485.88 41.767,168.13 INVESTMENTS Certificates of deposit 6,137,603.36 6:137,603-36 6.137,603.36 Wells Fargo investments - 43,163,128.86 43,163,128.86 Mutual fund investments - 68.297,473.49 68,297,473-49 Total investments 6,137,60336 6,137,603 36 111.460,602.35_ 117,598205_71 TOTAL CASH AND INVESTMENTS $ 6,947,716.75 $ 4,201,506.56 $ 122,582.62 $ 16,843,195.42 $ 4,758,591.81 $ 10.557.261.70 $ 43.430.854.86 $114,720,033.10 $ 1,214,485.88 $159,365,373.84 * Assets are restricted in purpose and do not represent discretionary assets of the government K) VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of January 31, 2015 Maturity Purchase Financial Date Date Institution POLICE PENSION FUND (070) Various Various Wells Fargo Various Various Various FIRE PENSION FUND (071) Various Various Wells Fargo Various Various Various TOTAL TRUST AND AGENCY FUND INVESTMENTS TRUST AND AGENCY FUNDS * Investment CUSIP/ GOVERNMENTAL AND ENTERPRISE FUNDS Market Description Maturity Purchase Financial Investment CUSIP/ Various 23,178,320.02 Date Date Institution Description FDIC # Net Yield Purch Price FLOOD CONTROL CONSTRUCTION FUND 0�24 06/15115 01/05/15 Landmark Community Bank, TN Certificate of Deposit 34982 0.123% 249,800.00 06/15/15 01/05/15 Farmers St Batik Waterloo, [A Certificate of Deposit 12855 0A23% 249,800.00 06/15/15 01/05/15 Corner Stone Bank, MO Certificate of Deposit 9388 0.120% 249,000.00 06/15/15 01/05/15 Texas Capital Batik, TX Certificate of Deposit 34383 0.120% 249,800.00 06/15/15 01/05/15 The First, NA, ME Certificate of Deposit 4256 0,124% 249,800.00 06/15/15 01/05/15 Banco Popular North America, IL Certificate of Deposit 34967 0.120% 82,800.00 06/15/15 01/05/15 Banco Popular North America, IL Certificate of Deposit 34967 0.120% 84,000.00 06/15/15 01/05/15 Banco Popular North America, IL Certificate of Deposit 34967 0.120% 83,000.00 06/15/15 01/05/15 West Alliance/Torrey Pines, CA Certificate of Deposit 57512 0.120% 249,800.00 07/08/15 01/09/15 0.3%- Bank of India CD Certificate of Deposit 06278CJ89 0.253% 249,057.30 07/13/15 01/13/15 0.4%- Bank of Baroda CD Certificate of Deposit 06062AB81 0.201% 249,246.06 07/15/15 01/05/15 Bank of China, NY Certificate of Deposit 33653 0.216% 249,700.00 07/15/15 01/05/15 Bridgewater Bank, MN Certificate of Deposit 58210 0.216% 249,700.00 07/15/15 01105115 Foothills Bank & Trust, TN Certificate of Deposit 58591 0.203% 249,500.00 07/15/15 01/05/15 Modern Bank Nat'l Assoc, NY Certificate of Deposit 22398 0.203% 249,500.00 07/15/15 01/05/15 Seaside Nat'l Bank &Trust, FL Certificate of Deposit 58328 0.210% 249,500.00 08/17/15 01/05/15 ONB Bank and Trust Co, OK Certificate of Deposit 35348 0.209% 249,400.00 08/17/15 01/05/15 Batik Leumi USA, NY Certificate of Deposit 19842 0.200% 249,400.00 08/17/15 01/05/15 Orrstown Bank, PA Certificate of Deposit 713 0.200% 249,400.00 08/17/15 01/05/15 Private Bank - MI, MI Certificate of Deposit 224 0.206% 249,400.00 09/15/15 01/05/15 Bank of the Ozarks, AR Certificate of Deposit 110 0.262% 249,500.00 09/15/15 01/05/15 Cinewest Bank, NA, CA Certificate of Deposit 58978 0.310% 249,400.00 09/15/15 01/05/15 IDB Bank - NY, NY Certificate of Deposit 19977 0.243% 249,200.00 09/15/15 01/05/15 Enerbank USA, UT Certificate of Deposit 57293 0.250% 249,300.00 10/15/15 01/05/15 United Texas Bank, TX Certificate of Deposit 26626 0.343% 249,300.00 10/15/15 01/05/15 Affiliated Batik. TX Certificate of Deposit 34885 0.343% 249,300.00 10/15/15 01/05/15 Royal Business Bank, CA Certificate of Deposit 58816 0.303% 150,000.00 6,137,603.36 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS 6,137,603.36 Maturity Purchase Financial Date Date Institution POLICE PENSION FUND (070) Various Various Wells Fargo Various Various Various FIRE PENSION FUND (071) Various Various Wells Fargo Various Various Various TOTAL TRUST AND AGENCY FUND INVESTMENTS TRUST AND AGENCY FUNDS * Investment CUSIP/ Interest Market Description Acct # Rate % Value Wells Fargo Investments Various Various 23,178,320.02 Mutual Fund Investments Various Various 33,437,615.91 56,615,935.93 Wells Fargo Investments Various Various 19,984,808.84 Mutual Fund Investments Various Various 34,859,857.58 54,844,666.42 111,460,602.35 * Assets are restricted in purpose and do not represent discretionary assets of the government. VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES January 01— January 31, 2015 Account Classification Revenue Budget by Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Redd Prior Year YTD Fund 001- General Fund REVENUE Property Taxes 15,427,500.00 .00 15,427,500.00 .00 .00 .00 15,427,500.00 0 .00 Other Taxes 7,457,566.00 .00 7,457,566.00 383,190.68 .00 383,190.68 7,074,375.32 5 216,150.84 Licenses, Permits & Fees 1,256,000.00 .00 1,256,000.00 42,132.25 .00 42,132.25 1,213,867.75 3 153,673.81 Intergovernmental Revenue 20,123,200.00 .00 20,123,200.00 58,600.90 .00 58,600.90 20,064,599.10 0 67,593.96 Charges For Services 1,633,223.00 .00 1,633,223.00 138,133.62 .00 138,133.62 1,495,089.38 8 133,217.37 Fines & Forfeits 439,000.00 .00 439,000.00 23,492.15 .00 23,492.15 415,507.85 5 15,542.92 Investment Income 5,918.00 .00 5,918.00 420.98 .00 420.98 5,497.02 7 351.14 Reimbursements 220,000.00 .00 220,000.00 9,262.54 .00 9,262.54 210,737.46 4 10,378.87 Other Revenue 236,000.00 .00 236,000.00 35,004.14 .00 35,004.14 200,995.86 15 49,981.71 Other Financing Sources 20,000.00 .00 20,000.00 .00 .00 .00 20,000.00 0 .00 REVENUE TOTALS $46,818,407.00 $0.00 $46,818,407.00 $690,237.26 $0.00 $690,237.26 $46,128,169.74 1% $646,890.62 Fund 001- General Fund Totals $46,818,407.00 $0.00 $46,818,407.00 $690,237.26 $0.00 $690,237.26 $46,128,169.74 $646,890.62 r Account Classification Fund 002 - Debt Service Fund REVENUE Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Property Taxes 2,254,000.00 .00 2,254,000.00 .00 .00 .00 2,254,000.00 0 .00 Other Taxes 988,508.00 .00 988,508.00 .00 .00 .00 988,508.00 0 .00 Intergovernmental Revenue 42,773.00 .00 42,773.00 .00 .00 .00 42,773.00 0 .00 Investment Income 100.00 00 100.00 .00 .00 .00 100.00 0 _00 Other Revenue .00 .00 .00 .00 .00 .00 .00 ... .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $3,285,381.00 $0.00 $3,285,381.00 $0.00 $0.00 $0.00 $3,285,381.00 0% $0.00 Fund 002 - Debt Service Fund Totals $3,285,381.00 $0.00 $3,285,381.00 $0.00 $0.00 $0.00 $3,285,381.00 $0.00 Account Classification Fund 020 - Capital Improvement Fund REVENUE Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Taxes 1,246,000.00 .00 1,246,000.00 .00 .00 .00 1,246,000.00 0 .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Investment Income 1,000.00 .00 1,000.00 23.70 .00 23.70 976.30 2 .00 Reimbursements ,00 .00 .00 .00 .00 .00 .00 +++ .00 Other Revenue 20,000.00 .00 20,000.00 .00 .00 .00 20,000.00 0 .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $1,267,000.00 $0.00 $1,267,000.00 $23.70 $0.00 $23.70 $1,266,976.30 0% $0.00 Fund 020 - Capital Improvement Fund Totals $1,267,000.00 $0.00 $1,267,000.00 $23.70 $0.00 $23.70 $1,266,976.30 $0.00 W A. Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD Fund 022 - Downtown Redevelopment Construct REVENUE Property Taxes 2,709,000.00 .00 2,709,000.00 ,00 .00 .00 2,709,000.00 0 .00 Investment Income 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Reimbursements .00 .00 .00 .00 .00 .00 ,00 +++ .00 Other Revenue ,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 $0.00 $0.00 $0.00 $2,709,500.00 0% $0.00 Fund 022 -Downtown Redevelopment Construct Totals $2,709,500.00 $0.00 $2,709,500.00 $0.00 $0.00 $0.00 $2,709,500.00 $0.00 Revenue Budget by Account Classification Report X='U Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 023 - Street Improvement Construc Fund REVENUE Other Taxes 2,056,000.00 .00 2,056,000.00 ,00 .00 .00 2,056,000.00 0 .00 Licenses, Permits & Fees 1,540,000.00 .00 1,540,000.00 2,565.00 .00 2,565.00 1,537,435.00 0 .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Fines & Forfeits .00 .00 .00 .00 .00 .00 .00 +++ .00 Investment Income 100.00 .00 100.00 116.10 .00 116.10 (16.10) 116 3.03 Reimbursements .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Revenue 6,000.00 .00 6,000.00 .00 .00 .00 6,000.00 0 .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ 125,500.00 REVENUE TOTALS $3,602,100.00 $0.00 $3,602,100.00 $2,681.10 $0.00 $2,681.10 $3,599,418.90 0% $125,503.03 Fund 023 - Street Improvement Construc Fund Totals $3,602,100.00 $0.00 $3,602,100.00 $2,681.10 $0.00 $2,681.10 $3,599,418.90 $125,503.03 Ln 4 / 'Towel F= i 11F 14 11111 Adopted Budget Amended Current Month YTD Account Classification Budget Amendments Budget Transactions Encumbrances Fund 024 - Flood Control Construction Fund REVENUE Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Recd Prior Year YTD Other Taxes 357,000.00 .00 357,000.00 .00 .00 .00 357,000.00 0 .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Charges For Services .00 .00 .00 .00 .00 .00 .00 +++ .00 Investment Income 1,100.00 .00 1,100.00 1,193.89 .00 1,193.89 (93.89) 109 56154 Reimbursements .00 .00 .00 .00 .00 .00 .00 +++ 56,438.36 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $358,100.00 $0.00 $358,100.00 61,193.89 $0.00 $1,193.89 $356,906.11 0% $57,000.90 Fund 024 - Flood Control Construction Fund Totals $358,100.00 $0.00 $358,100.00 S1,193.89 $0.00 $1,193.89 $356,906.11 $57,000.90 Account Classification Fund 040 - Refuse Disposal Fund REVENUE Property Taxes Charges For Services Fines & Forfeits Investment Income Reimbursements Other Revenue REVENUE TOTALS Fund 040 - Refuse Disposal Fund Totals v Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD .00 .00 .00 .00 .00 .00 .00 ... .00 3,549,000.00 .00 3,549,000.00 235,947.80 .00 235,947.80 3,313,052.20 7 200,178.71 24,000.00 .00 24,000.00 3,692.50 .00 3,692.50 20,307.50 15 2,556.06 500.00 .00 500.00 16.80 .00 16.80 483.20 3 .00 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 371,500.00 .00 371,500.00 (10.84) .00 (10.84) 371,510.84 0 20.00 $3,946,000.00 $0.00 $3,946,000.00 $239,646.26 $0.00 $239,646.26 $3,706,353.74 6% $202,754.77 $3,946,000.00 $0.00 $3,946,000.00 $239,646.26 $0.00 $239,646.26 $3,706,353.74 $202,754.77 M Account Classification Revenue Budget by Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ 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 .00 1,320,000.00 0 .00 Investment Income 200.00 .00 200.00 13.80 .00 13.80 186.20 7 .00 Reimbursements 11,000.00 .00 11,000.00 .00 .00 .00 11,000.00 0 .00 REVENUE TOTALS $1,331,200.00 $0.00 $1,331,200.00 $13.80 $0.00 $13.80 $1,331,186.20 0% $0.00 Fund 041- Motor Fuel Tax Fund Totals $1,331,200.00 $0.00 $1,331,200.00 $13.80 $0.00 $13.80 $1,331,186.20 $0.00 - Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 042 - Cmmty Development Block Grant REVENUE Intergovernmental Revenue 339,264.00 .00 339,264.00 .00 .00 00 339,264.00 0 .00 Investment Income .00 .00 '00 .00 ,00 .00 .00 ... .00 Other Revenue 80,000.00 .00 80,000.00 .00 .00 .00 80,000.00 0 .00 REVENUE TOTALS $419,264.00 $0.00 $419,264.00 $0.00 $0.00 $0.00 $419,264.00 0% $0.00 Fund 042 - Cmmty Development Block Grant Totals $419,264.00 $0.00 $419,264.00 $0.00 $0.00 $0.00 $419,264.00 $0.00 ko F- 0 Account Classification Fund 043 - Asset Seizure Fund REVENUE Fines & Forfeits Investment Income REVENUE TOTALS Fund 043 - Asset Seizure Fund Totals Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD 0/b used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 2,000.00 100.00 X0 .00 2,000.00 100.00 .00 .90 '00 .00 .00 .90 2,000.00 0 99.10 1 -00 .00 $2,100.00 $0.00 $2,100.00 $0.90 $0.00 $0.90 $2,099.10 0% $0.00 $2,100.00 $0.00 $2,100.00 $0.90 $0.00 $0.90 $2,099.10 $0.00 Account Classification Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD runa u44 - urw bnarea Tunas Funa REVENUE Fines & Forfeits 100.00 .00 100.00 .00 .00 .00 100.00 0 ,00 Investment Income 100.00 .00 100.00 1.44 ,00 1.44 98.56 1 .97 REVENUE TOTALS $200.00 $0.00 $200.00 $1.44 $0.00 $1.44 $198.56 1% $0.97 Fund 044 - DEA Shared Funds Fund Totals $200.00 $0.00 $200.00 $1.44 $0.00 $1.44 $198.56 $0.97 r N Account Classification Fund 045 - DUI Fine Fund REVENUE Fines & Forfeits Investment Income Revenue Budget by Account Classification Repoit Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 20,000.00 .00 20,000.00 .00 .00 .00 20,000.00 0 .00 100.00 .00 100.00 2.40 .00 2.40 97.60 2 .00 REVENUE TOTALS $20,100.00 $0.00 $20,100.00 $2.40 $0.00 $2.40 $20,097.60 0% $0.00 Fund 045 - DUI Fine Fund Totals $20,100.00 $0.00 $20,100.00 $2.40 $0.00 $2.40 $20,097.60 $0.00 Account Classification Fund 046 -Foreign Fire Tax Board Fund REVENUE Revenue Budget by Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Other Taxes 70,000.00 .00 70,000.00 .00 '00 .00 70,000.00 0 .00 Investment Income 100.00 .00 100.00 4.20 .00 4,20 95.80 4 .00 Other Revenue .00 .00 .00 .00 ..00 .00 AO +++ .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $70,100.00 $0.00 $70,100.00 $4.20 $0.00 $4.20 $70,095.80 0% $0.00 Fund 046 - Foreign Fire Tax Board Fund Totals $70,100.00 $0.00 $70,100.00 $4.20 $0.00 $4.20 $70,095.80 $0.00 r w Account Classification Fund 048 - Business District Fund REVENUE Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Taxes 1,021,000.00 .00 1,021,000.00 ,00 .00 ,00 1,021,000,00 0 Investment Income .00 .00 .00 ,00 .00 .00 .00 +++ Other Financing Sources ,00 .00 .00 ,00 .00 .00 .00 +++ REVENUE TOTALS $1,021,000.00 $0.00 $1,021,000.010 $0.00 $0.00 $0.00 $1,021,000.00 0% Fund 048 - Business District Fund Totals $1,021,000.00 $0.00 $1,021,000.00 $0.00 $0.00 $0.00 $1,021,000.00 .00 .00 .00 $0.00 Account Classification Fund 050 - Water and Sewer Fund REVENUE Property Taxes Licenses, Permits & Fees Charges For Services Fines & ForFeits Investment Income Reimbursements Other Revenue Other Financing Sources Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD 1,530,000.00 .00 1,530,000.00 .00 .00 .00 1,530,000.00 0 .00 18,000.00 .00 18,000.00 1,860.00 .00 1,860.00 16,140.00 10 920.00 131789,000.00 .00 13,789,000.00 999,882.75 .00 999,882.75 12,789,117.25 7 910,381.75 118,000.00 .00 118,000.00 12,282.38 .00 12,282.38 105,717.62 10 9,080.06 2,100.00 .00 2,100.00 150.79 .00 150.79 1,949.21 7 2.87 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 72,000.00 .00 72,000.00 9,040.00 .00 9,040.00 62,960.00 13 8,478.59 .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $15,529,600.00 Fund 050 - Water and Sewer Fund Totals $15,529,600.00 $0.00 $15,529,600.00 $1,023,215.92 $0.00 $1,023,215.92 $14,506,384.08 7% $928,863.27 $0.00 $15,529;600.00 $1,023,215.92 $0.00 $1,023,215.92 $14,506,384.08 $928,863.27 F, rn Account Classification Fund 051 -Village Parking System Fund REVENUE Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Taxes .00 .00 .00 .00 .00 .00 .00 +++ .00 Charges For Services 124,000.00 .00 124,000.00 9,674.15 .00 9,674.15 114,325.85 8 22,490.05 Investment Income 100.00 .00 100.00 3.30 .00 3.30 96.70 3 .00 Other Revenue 6,600.00 .00 6,600.00 550.00 .00 550.00 6,050.00 8 550.00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $130,700.00 $0.00 $130,700.00 $10,227.45 $0.00 $10,227.45 $120,472.55 8% $23,040.05 Fund 051 - Village Parking System Fund Totals $130,700.00 $0.00 $130,700.00 $10,227.45 $0.00 $10,227.45 $120,472.55 $23,040.05 Account Classification Fund 052 - Parking System Revenue Fund Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD REVENUE Other Taxes 100,000.00 .00 100,000.00 ,00 .00 .00 100,000.00 0 .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Charges For Services 119,000.00 .00 119,000.00 9,046.46 .00 9,046.46 109,953.54 8 17,810.85 Investment Income .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 $219,000.00 $0.00 $219,000.00 $9,046.46 $0.00 $9,046.46 $209,953.54 4% $17,810.85 Fund 052 - Parking System Revenue Fund Totals $219,000.00 $0.00 $219,000.00 $9,046.46 $0.00 $9,046.46 $209,953.54 $17,810.85 r 00 Account Classification Fund 060 - Vehicle Maintenance Fund REVENUE Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Charges For Services 2,157,889.00 .00 2,157,889.00 179,824.09 .00 179,824.09 1,978,064.91 8 178,193.07 Investment Income 600.00 .00 600.00 26.27 .00 26.27 573.73 4 37.84 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $2,158,489.00 $0.00 $2,158,489.00 $179,850.36 $0.00 $179,850.36 $1,978,638.64 8% $178,230.91 Fund 060 - Vehicle Maintenance Fund Totals $2,158,489.00 $0.00 $2,158,489.00 $179,850.36 $0.00 $179,850.36 $1,978,638.64 $178,230.91 Account Classification Fund 061 - Vehicle Replacement Fund REVENUE Charges For Services Fines & Forfeits Investment Income Other Revenue Other Financing Sources REVENUE TOTALS Fund 061- Vehicle Replacement Fund Totals r kD Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTE 1,380,500.00 .00 1,380,500.00 115,041.68 .00 115,041.68 1,265,458.32 8 112,191.68 11,150.00 .00 11,150.00 .00 .00 .00 11,150.00 0 .00 7,200.00 .00 7,200.00 293.40 .00 293.40 6,906.60 4 378.25 .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 5,135.27 .00 5,135.27 (5,135.27) +++ .00 $1,398,850.00 $0.00 $1,398,850.00 $120,470.35 $0.00 $120,470.35 $1,278,379.65 9% $112,569.93 $1,398,850.00 $0.00 $1,398,850.00 $120,470.35 $0.00 $120,470.35 $1,278,379.65 $112,569.93 N O Account Classification Fund 062 - Computer Replacement Fund REVENUE Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Charges For Services 272,307.00 .00 272,307.00 22,692.25 .00 22,692.25 249,614.75 8 1,924.00 Investment Income 1,000.00 .00 1,000.00 35.27 .00 35.27 964.73 4 56.74 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $273,307.00 $0.00 $273,307.00 $22,727.52 $0.00 $22,727.52 $250,579.48 8% $1,980.74 Fund 062 - Computer Replacement Fund Totals $273,307.00 $0.00 $273,307.00 $22,727.52 $0.00 $22,727.52 $250,579.48 $1,980.74 N F- Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 063 - Risk Management Fund REVENUE Charges For Services 6,513,826.00 .00 6,513,826.00 467,932.81 .00 467,932.81 6,045,893.19 7 553,974.41 Investment Income 3,000.00 .00 3,000.00 95.57 .00 95.57 2,904.43 3 151.31 Reimbursements 1,000.00 .00 1,000.00 ,00 .00 .00 1,000.00 0 .00 Other Revenue 1,463,700.00 .00 1,463,700.00 124,246.02 .00 124,246.02 1,339,453.98 8 123,756.79 REVENUE TOTALS $7,981,526.00 $0.00 $7,981,526.00 $592,274.40 $0.00 $592,274.40 $7,389,251.60 7% $677,882.51 Fund 063 - Risk Management Fund Totals $7,981,526.00 $0.00 $7,981,526.00 $592,274.40 $0.00 $592,274.40 $7,389,251.60 $677,882.51 N F- 9 Account Classification Fund 070 - Police Pension Fund REVENUE -��evenue Budget by Account Classification Repo-"-m- Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget -YTD %used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Charges For Services .00 X0 .00 .00 .00 .00 ... .00 Investment Income 4,382,800.00 X0 4,382,800.00 (329,494.84) 00 (329,494.84) 4,712,294.84 -8 (586,969.66) Other Revenue 3,743,175.00 X0 3,743,175.00 61,955.66 '00 61,955.66 3,681,219.34 2 65,876.78 REVENUE TOTALS $8,125,975.00 $0.00 $8,125,975.00 ($267,539.18) $0.00 ($267,539.18) $8,393,514.18 -3% ($521,092.88) Fund 070 - Police Pension Fund Totals $8,125,975.00 $0.00 $8,125,975.00 ($267,539.18) $0.00 ($267,539.18) $8,393,514.18 ($521,092.88) Account Classification Fund 071 - Fire Pension Fund REVENUE Revenue Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Investment Income 4,250,500.00 .00 4,250,500.00 339,527.74 .00 339,527.74 3,910,972.26 8 290,601.41 Other Revenue 3,151,125.00 .00 3,151,125.00 49,059.48 .00 49,059.48 3,102,065.52 2 52,757.52 REVENUE TOTALS $7,401,625.00 $0.00 $7,401,625.00 $388,587.22 $0.00 $388,587.22 $7,013,037.78 5% $343,358.93 Fund 071- Fire Pension Fund Totals $7,401,625.00 $0.00 $7,401,625.00 $388,587.22 $0.00 $388,587.22 $7,013,037.78 $343,358.93 Grand Totals $108,069,524.00 $0.00 $108,069,524.00 $3,012,665.45 $0.00 $3,012,665.45 $105,056,858.55 $2,794,794.60 N W Account Classification Fund 001- General Fund EXPENSE Expense Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 24,232,037.00 .00 24,232,037.00 1,524,570.02 .00 1,524,570.02 22,707,466.98 6 1,680,046.52 Employee Benefits 12,235,287.00 .00 12,235,287.00 494,263.82 .00 494,263.82 11,741,023.18 4 544,904.14 Other Employee Costs 440,543.00 (1,500.00) 439,043.00 46,124.54 10,097.50 46,124.54 382,820.96 13 29,745.93 Pension Benefits 46,456.00 .00 46,456.00 3,871.28 .00 3,871.28 42,584.72 8 3,858.36 Contractual Services 7,528,869.00 .00 7,528,869.00 673,794.91 526,713.77 673,794.91 6,328,360.32 16 595,165.54 Utilities 271,939.00 .00 271,939.00 9,905.99 .00 9,905.99 262,033.01 4 9,963.25 Insurance 415,398.00 .00 415,398.00 34,561.42 .00 34,561.42 380,836.58 8 29,229.37 Commodities & Supplies 641,996.00 1,500.00 643,496.00 37,389.27 15,850.98 37,389.27 590,255.75 8 43,183.53 Other Expenditures 11,140.00 .00 11,140.00 (100.00) .00 (100.00) 11,240.00 -1 .00 Building Improvements 10,200.00 .00 10,200.00 508.55 715.00 508.55 8,976.45 12 .00 Office Equipment 33,520.00 .00 33,520.00 553.00 2,293.69 553.00 30,673.31 8 .00 Other Equipment 184,199.00 .00 184,199.00 12,260.53 17,394.35 12,260.53 154,544.12 16 6,658.93 Distribution Systems 100,000.00 .00 100,000.00 .00 81,191.00 .00 18,809.00 81 .00 Infrastructure 666,823.00 .00 666,823.00 .00 80,000.00 .00 586,823.00 12 .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 t++ .00 EXPENSE TOTALS $46,818,407.00 $0.00 $46,818,407.00 $2,837,703.33 $734,256.29 $2,837,703.33 $43,246,447.38 8% $2,942,755.57 Fund 001 - General Fund Totals $46,818,407.00 $0.00 $46,818,407.00 $2,837,703.33 $734,256.29 $2,837,703.33 $43,246,447.38 $2,942,755.57 r M Account Classification Fund 002 - Debt Service Fund EXPENSE Contractual Services Other Expenditures Bond Principal Interest Expense Bank & Fiscal Fees Interfund Transfers Other Financing Uses Budget by Account Classificatiog R' Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amerded Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 1,893,913.00 .00 1,893,913.00 .00 .00 .00 1,893,913.00 0 .00 1,382,571.00 .00 1,382,571.00 .00 .00 .00 1,382,571.00 0 .00 2,312.00 .00 2,312.00 1,556.64 .00 1,556.64 755.36 67 830.20 .00 .00 .00 .00 .00 .00 .00 +++ AO .00 .00 ,00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $3,278,796.00 $0.00 $3,278,796.00 $1,556.64 $0.00 $1,556.64 $3,277,239.36 0% $830.20 Fund 002 - Debt Service Fund Totals $3,278,796.00 $0.00 $3,278,796.00 $1,556.64 $0.00 $1,556.64 $3,277,239.36 $830.20 Account Classification Fund 020 - Capital Improvement Fund EXPENSE Expense Budget by Account Classification Repoit Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services .00 .00 .00 .00 .00 .00 .00 +++ ,00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Land Improvements 350,000.00 .00 350,000.00 .00 .00 .00 350,000.00 0 .00 Building Improvements 896,000.00 .00 896,000.00 15,950.03 7,249.42 15,950.03 872,800.55 3 .00 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 .00 486,747.00 18,685.63 .00 18,685.63 468,061.37 4 10,603.91 Infrastructure 503,000.00 .00 503,000.00 .00 .00 .00 503,000.00 0 .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $2,235,747.00 $0.00 $2,235,747.00 $34,635.66 $7,249.42 $34,635.66 $2,193,861.92 2% $10,603.91 Fund 020 - Capital Improvement Fund Totals $2,235,747.00 $0.00 $2,235,747.00 $34,635.66 $7,249.42 $34,635.66 $2,193,861.92 $10,603.91 LSV 4�. Expense Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 022 - Downtown Redevelopment Construct EXPENSE Contractual Services 109,201.00 .00 109,201.00 .00 .00 .00 109,201.00 0 .00 Utilities .00 .00 ,00 .00 .00 .00 .00 ... .00 Other Expenditures 3,306,969.00 .00 3,306,969.00 .00 .00 .00 3,306,969.00 0 .00 Infrastructure 342,285.00 .00 342,285.00 .00 .00 .00 342,285.00 0 .00 Bond Principal M .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 $0.00 $3,758,455.00 $0.00 $0.00 $0.00 $3,758,455.00 0% $0.00 Fund 022 -Downtown Redevelopment Construct Totals $3,758,455.00 $0.00 $3,758,455.00 $0.00 $0.00 $0.00 $3,758,455.00 $0.00 Expense Budget by Account Classification Adopted Budget Account Classification Budget Amendments Fund 023 -Street Improvement Construc Fund EXPENSE Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services 107,000.00 .00 107,000.00 .00 .00 .00 107,000.00 0 .00 Infrastructure 4,715,000.00 .00 4,715,000.00 .00 45,000.00 .00 4,670,000.00 1 ,00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ++. .00 EXPENSE TOTALS $4,822,000.00 $0.00 $4,822,000.00 $0.00 $45,000.00 $0.00 $4,777,000.00 1% $0.00 Fund 023 - Street Improvement Construc Fund Totals $4,822,000.00 $0.00 $4,822,000.00 $0.00 $45,000.00 $0.00 $4,777,000.00 $0.00 I: cri Expense Budget by Account Classification Adopted Budget Account Classification Budget Amendments Fund 024 - Flood Control Construction Fund EXPENSE Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 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 .00 .00 .00 2,300.00 0 194.14 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 A0 Other Equipment .00 .00 .00 .00 .00 .00 .00 ... .00 Infrastructure 9,779,960.00 .00 9,779,960.00 .00 .00 .00 9,779,960.00 0 .00 EXPENSE TOTALS $9,804,360.00 $0.00 S9,804,360.00 $0-00 10.00 50,00 59,804,360Z0 0% $194.14 Fund 024 - Flood Control Construction Fund Totals $9,804,360.00 $0.00 $9,804,360.00 $0.00 $0.00 $0.00 $9,804,360.00 $194.14 Account Classification Fund 040 - Refuse Disposal Fuad EXPENSE Expense Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Personal Services, Scheduled Salaries & Wages 236,644.00 .00 236,644.00 17,450.54 .00 17,450.54 219,193.46 7 22,241.08 Employee Benefits 110,436.00 .00 110,436.00 8,429.95 .00 8,429.95 102,006.05 8 8,955.09 Other Employee Costs 1,248.00 .00 1,248.00 .00 .00 .00 1,248.00 0 .00 Contractual Services 4,294,934.00 .00 4,294,934.00 197,825.51 .00 197,825.51 4,097,108.49 5 297,102.78 Utilities 447.00 .00 447.00 19.34 .00 19.34 427.66 4 21.82 Insurance 31,809.00 .00 31,809.00 2,650.75 .00 2,650.75 29,158.25 8 2,386.67 Commodities & Supplies 38,446.00 .00 38,446.00 .00 1,260.00 .00 37,186.00 3 .00 EXPENSE TOTALS $4,713,964.00 $0.00 $4,713,964.00 $226,376.09 $1,260.00 $226,376.09 $4,486,327.91 5% $330,707.44 Fund 040 - Refuse Disposal Fund Totals $4,713,964.00 $0.00 $4,713,964.00 $226,376.09 $1,260.00 $226,376.09 $4,486,327.91 $330,707.44 v 0 Account Classification Fund 041 Motor Fuel Tax Fund EXPENSE -xpenseBudget byAccountClassification R • 1 Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Contractual Services 284,686.00 .00 284,686.00 1,360.00 151,801.40 1,360.00 131,524.60 54 .00 Utilities 156,060.00 .00 156,060.00 100.85 .00 100.85 155,959.15 0 17,654.17 Commodities & Supplies 453,209.00 .00 453,209.00 113,697.12 173,000.00 113,697.12 166,511.88 63 66,049.50 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 .00 .00 .00 663,000.00 0 .00 EXPENSE TOTALS $2,156,955.00 $0.00 $2,156,955.00 $115,157.97 $324,801.40 $115,157.97 $1,716,995.63 20% $83,703.67 Fund 041 - Motor Fuel Tax Fund Totals $2,156,955.00 $0.00 $2,156,955.00 $115,157.97 $324,801.40 $115,157.97 $1,716,995.63 $83,703.67 Expense Budget by Account Classification Report UVThrough 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 042 - Cmmty Development Block Grant EXPENSE Personal Services, Scheduled Salaries & Wages 48,783.00 .00 48,783.00 2,675.87 .00 2,675.87 46,107.13 5 2,787.28 Employee Benefits 25,491.00 .00 25,491.00 1,893.28 .00 1,893.28 23,597.72 7 1,989.90 Other Employee Costs 1,040.00 .00 1,040.00 .00 .00 ,00 1,040.00 0 .00 Contractual Services 154,430.00 .00 154,430.00 909.29 .00 909.29 153,520.71 1 884.74 Commodities & Supplies 520.00 .00 520.00 .00 .00 .00 520.00 0 .00 Other Expenditures 189,000.00 .00 189,000.00 6,720.00 .00 6,720.00 182,280.00 4 .00 Land Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 Building Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 Infrastructure .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $419,264.00 $0.00 $419,264.00 $12,198.44 $0.00 $12,198.44 $407,065.56 3% $5,661.92 Fund 042 - Cmmty Development Block Grant Totals $419,264.06 $0.00 $419,264.00 $12,198.44 $0.00 $12,198.44 $407,065.56 $5,661.92 r 0 Account Classification Fund 043 - Asset Seizure Fund EXPENSE "xpenseBudget by Account ! Reportt Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other 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 .00 3,000.00 0 1,500.00 Other Equipment 15,000.00 .00 15,000.00 1,318.09 .00 1,318.09 13,681.91 9 .00 EXPENSE TOTALS $19,000.00 $0.00 $19,000.00 $1,318.09 $0.00 $1,318.09 $17,681.91 7% $1,500.00 Fund 043 - Asset Seizure Fund Totals $19,000.00 $0.00 $19,000.00 $1,318.09 $0.00 $1,318.09 $17,681.91 $1,500.00 Account Classification Expense Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 044 - DEA Shared Funds Fund 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 00/0 $0.00 Fund 044 - DEA Shared Funds Fund Totals $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 $0.00 r r N Account Classification Fund 045 - DUI Fine Fund EXPENSE Other Employee Costs Contractual Services Other Equipment Interfund Transfers 7!xpense Budget by rClassification Ki r_ •_ _ Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD 1,000.00 .00 1,000.00 .00 .00 ,00 1,000.00 0 .00 .00 .00 .00 .00 .00 00 .00 +++ .00 1,000.00 .00 1,000.00 M .00 ,00 1,000.00 0 95.99 .00 .00 .00 .00 .00 ,00 .00 +++ 00 EXPENSE TOTALS $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $95.99 Fund 045 - DUI Fine Fund Totals $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 $95.99 Account Classification ..................... Expense Budget by Account Classification Report Through 01/31/15 Prior f=iscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 046 - Foreign Fire Tax Board Fund EXPENSE Contractual Services 10,000.00 .00 10,000.00 5,203.16 .00 5,203.16 4,796.84 52 2,704.11 Insurance 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Commodities & Supplies 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 .AO Other Equipment 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 8,856.00 EXPENSE TOTALS $30,500.00 $0.00 $30,500.00 $5,203.16 $0.00 $5,203.16 $25,296.84 17% $11,560.11 Fund 046 - Foreign Fire Tax Board Fund Totals $30,500.00 $0.00 $30,500.00 $5,203.16 $0.00 $5,203.16 $25,296.84 $11,560.11 I.- LO w Account Classification Expense Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD 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 .00 1,021,000.00 0 .00 EXPENSE TOTALS $1,021,000.00 $0.00 $1,021,000.00 $0.00 $0.00 $0.00 $1,021,000.00 0% $0.00 Fund 048 - Business District Fund Totals $1,021,000.00 $0.00 $1,021,000.00 $0.00 $0.00 $0.00 $1,021,000.00 $0.00 Account Classification Fund 050 - Water and Sewer Fund EXPENSE Expense Budget by Account Classification Repoit Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD r Ln 2,006,058.00 .00 2,006,058.00 146,254.60 .00 146,254.60 1,859,803.40 7 190,343.54 Employee Benefits 772,177.00 .00 772,177.00 58,542.65 .00 58,542.65 713,634.35 8 68,632.75 Other Employee Costs 37,393.00 .00 37,393.00 1,085.56 211.75 1,085.56 36,095.69 3 5,733.32 Contractual Services 8,650,244.00 .00 8,650,244.00 616,616.00 122,875.63 616,616.00 7,910,752.37 9 537,543.91 Utilities 160,913.00 .00 160,913.00 3,067.71 .00 3,067.71 157,845.29 2 3,494.48 Insurance 101,312.00 .00 101,312.00 8,484.33 .00 8,484.33 92,827.67 8 6,706.16 Commodities & Supplies 293,516.00 .00 293,516.00 826.67 33,786.35 826.67 258,902.98 12 876.23 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Building Improvements 65,000.00 .00 65,000.00 .00 .00 .00 65,000.00 0 .00 Office Equipment 3,930.00 .00 3,930.00 .00 .00 .00 3,930.00 0 .00 Other Equipment 1,173,744.00 .00 1,173,744.00 155,067.50 900,000.00 155,067.50 118,676.50 90 .00 Distribution Systems 2,300,500.00 .00 2,300,500.00 8,777.38 3,500.00 8,777.38 2,288,222.62 1 .00 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 $0.00 $15,564,787.00 $998,722.40 $1,060,373.73 $998,727.40 $13,505,690.87 13% $813,330.39 Fund 050 - Water and Sewer Fund Totals $15,564,787.00 $0.00 $15,564,787.00 $998,722.40 $1,060,373.73 $998,722.40 513,505,690.87 $813,330.39 r Ln F- 0) Account Classification -Expense Budget by Account i R' +l , Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 051 - Village Parking System Fund EXPENSE Personal Services, Scheduled Salaries & Wages 35,175.00 .00 35,175.00 2,447.37 .00 2,447.37 32,727.63 7 3,351.69 Employee Benefits 17,353.00 .00 17,353.00 1,278.70 .00 1,278.70 16,074.30 7 1,338.88 Contractual Services 94,382.00 .00 94,382.00 4,518.82 11,402.08 4,518.82 78,461.10 17 3,994.83 Insurance 2,156.00 .00 2,156.00 179.67 ,00 179.67 1,976.33 8 97.92 Commodities & Supplies 520.00 .00 520.00 .00 .00 .00 520.00 0 .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Building Improvements 7,074.00 .00 7,074.00 .00 .00 .00 7,074.00 0 .00 Infrastructure 153,500.00 .00 153,500.00 .00 .00 .00 153,500.00 D _00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ 00 EXPENSE TOTALS $310,160.00 $0.00 $310,160.00 $8,424.56 $11,402.08 $8,424.56 $290,333.36 6% $8,783.32 Fund 051- Village Parking System Fund Totals $310,160.00 $0.00 $310,160.00 $8,424.56 $11,402.08 $8,424.56 $290,333.36 $8,783.32 Adopted Budget Account Classification Budget Amendments Fund 052 - Parking System Revenue Fund EXPENSE Repott Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Amended Current Month YTD YTD Budget - YTD % used/ Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 25,830.00 .00 25,830.00 1,798.39 ,00 1,798.39 24,031.61 7 2,393.73 Employee Benefits 13,024.00 .00 13,024.00 946.66 .00 946.66 12,077.34 7 987.36 Contractual Services 114,325.00 .00 114,325.00 3,221.53 11,589.07 3,221.53 99,514.40 13 2,799.83 Utilities 10,733.00 .00 10,733.00 140.39 .00 140.39 10,592.61 1 330.54 Insurance 1,757.00 .00 1,757.00 146.42 .00 146.42 1,610.58 8 117.17 Commodities & Supplies 9,974.00 .00 9,974.00 .00 .00 .00 9,974.00 0 1,746.54 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Building Improvements 75,000.00 .00 75,000.00 .00 .00 .00 75,000.00 0 .00 Infrastructure .00 .00 .00 .00 .00 .00 .00 +++ .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $250,643.00 $0.00 $250,643.00 $6,253.39 $11,589.07 $6,253.39 $232,800.54 7% $8,375.17 Fund 052 - Parking System Revenue Fund Totals $250,643.00 $0.00 $250,643.00 $6,253.39 $11,589.07 $6,253.39 $232,800.54 $8,375.17 r .] e Account Classification Fund 060 - Vehicle Maintenance Fund EXPENSE Budget0111 Account Classification R ,, 4 Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 951,226.00 .00 951,226.00 66,198.67 .00 66,198.67 885,027.33 7 87,858.57 Employee Benefits 379,364.00 .00 379,364.00 26,861.85 ,00 26,861.85 352,502.15 7 30,751.47 Other Employee Costs 2,408.00 .00 2,408.00 174.33 .00 174.33 2,233.67 7 .00 Contractual Services 102,813.00 .00 102,813.00 2,790.33 14,342.00 2,790.33 85,680.67 17 3,220.48 Utilities 3,132.00 .00 3,132.00 136.12 .00 136.12 21995.88 4 198.96 Commodities & Supplies 735,223.00 .00 735,223.00 51,326.51 273,298.59 51,326.51 410,597.90 44 65,931.15 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Office Equipment 567.00 .00 567.00 .00 .00 .00 567.00 0 .00 Other Equipment 20,165.00 .00 20,165.00 55.83 .00 55.83 20,109.17 0 .00 EXPENSE TOTALS $2,194,898.00 $0.00 $2,194,898.00 $147,543.64 $287,640.59 $147,543.64 $1,759,713.77 20% $187,960.63 Fund 060 - Vehicle Maintenance Fund Totals $2,194,898.00 $0.00 $2,194,898.00 $147,543.64 $287,640.59 $147,543.64 $1,759,713.77 $187,960.63 Account Classification Fund 061- Vehicle Replacement EXPENSE Expense Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Expenditures 00 .00 .00 .00 .00 .00 .00 ... _00 Motor Equipment 909,000.00 .00 909,000.00 .00 4,000.00 .00 905,000.00 0 604.84 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $909,000.00 $0.00 $909,000.00 $0.00 $4,000.00 $0.00 $905,000.00 0% $604.84 Fund 061 - Vehicle Replacement Fund Totals $909,000.00 $0.00 $909,000.00 $0.00 $4,000.00 $0.00 $905,000.00 $604.84 r N O Account Classification Expense Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec°d Prior Year YTD Fund 062 - Computer Replacement Fund EXPENSE Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 Office Equipment 429,380.00 .00 429,380.00 32,109.08 .00 32,109.08 397,270.92 7 280.00 EXPENSE TOTALS $429,380.00 $0.00 $429,380.00 $32,109.08 $0.00 $32,109.08 $397,270.92 7% $280.00 Fund 062 - Computer Replacement Fund Totals $429,380.00 $0.00 $429,380.00 $32,109.08 $0.00 $32,109.08 $397,270.92 $280.00 Account Classification Fund 063 - Risk Management Fund EXPENSE Expense Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services 25,000.00 .00 25,000.00 3,800.00 .00 3,800.00 21,200.00 15 .00 Insurance 7,889,896.00 .00 7,889,896.00 695,073.84 .00 695,073.84 7,194,822.16 9 868,936,01 Other Equipment 165,000.00 .00 165,000.00 .00 .00 .00 165,000.00 0 .00 Infrastructure .00 .00 .00 .00 .00 .00 .00 +++ .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $8,079,896.00 $0.00 $8,079,896.00 $698,873.84 $0.00 $698,873.84 $7,381,022.16 9% $868,936.01 Fund 063 - Risk Management Fund Totals $8,079,896.00 $0.00 $8,079,896.00 $698,873.84 $0.00 $698,873.84 $7,381,022.16 $868,936.01 N I-- Account Classification Fund 070 - Police Pension Fund EXPENSE Expense Budget by Account Classification Re •F-10- Account - Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget 'Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Pension Benefits 4,472,170.00 .00 4,472,170.00 370,037.43 .00 370,037.43 4,102,132.57 8 321,954.30 Contractual Services 154,100.00 .00 154,100.00 1,174.64 .00 1,174.64 152,925.36 1 1,121.25 Insurance 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 .00 Commodities & Supplies 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 Other Expenditures 12,000.00 .00 12,000.00 250.00 .00 250.00 11,750.00 2 250.00 Office Equipment .00 .00 .00 .00 ,00 .00 .00 +++ .00 EXPENSE TOTALS $4,653,370.00 $0.00 $4,653,370.00 $371,462.07 $0.00 $371,462.07 $4,281,907.93 8% $323,325.55 Fund 070 - Police Pension Fund Totals $4,653,370.00 $0.00 $4,653,370.00 $371,462.07 $0.00 $371,462.07 $4,281,907.93 $323,325.55 N W Account Classiflcation Fund 071 - Fire Pension Fund EXPENSE Pension Benefits Contractual Services Insurance Commodities & Supplies Other Expenditures Expense Budget by Account Classification Report Through 01/31/15 Prior Fiscal Year Activity Included Summary Listing Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 4,334,168.00 .00 4,334,168.00 370,045.18 .00 370,045.18 3,964,122.82 9 334,563.57 136,100.00 .00 136,100.00 10,139.15 .00 10,139.15 125,960.85 7 10,134.58 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 .00 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 12,000.00 .00 12,000.00 .00 .00 .00 12,000.00 0 .00 EXPENSE TOTALS $4,498,268.00 $0.00 $4,498,268.00 $380,184.33 $0.00 $380,184.33 $4,118,083.67 8% $344,698.15 Fund 071 - Fire Pension Fund Totals $4,498,268.00 $0.00 $4,498,268.00 $380,184.33 $0.00 $380,184.33 $4,118,083.67 $344,698.15 Grand Totals $115,972,850.00 $0.00 $115,972,850.00 $5,877,722.69 $2,487,572.58 $5,877,722.69 $107,607,554.73 $5,943,907.01 Page 1 of 10 Amount 48.95 3,370.00 1,486.00 213.17 220.00 62.00 255.60 48.00 6,262.33 93.55 15.00 67.95 62.95 131.98 180.00 648.54 341.79 140.00 75.82 381.85 731.10 899.90 220.00 100.00 30.00 85.00 93.50 157.71 142.34 619.80 30.00 2,066.01 12.30 14.58 19.92 16.48 12.30 16.40 16.40 180.00 29.58 25.02 199.51 215.00 215.00 100.00 1,250.00 1,325.00 650.00 650.00 650.00 21.37 3,080.00 31.05 31.05 172.00 518.75 119.00 5,839.97 2,417.28 480.00 120.00 VILLAGE OF MOUNT PROSPECT List of Bills January 29 - February 11, 2015 Fund Vendor Name Invoice Description 001 General Fund Addison Building Material Co. Forestry Equipment Affiliated Customer Service, Inc. Equipment Maintenance Air One Equipment, Inc. Fire fighting Helmets Airgas, Inc. Oxygen Maintenance Alexian Brothers Medical Center OSHA Required Drug/Alcohol Screenings Amer Reprographics Co Uc Equipment Maintenance American Future Systems, Inc. Subscription renewal Anderson Pest Solutions February Pest Control - Inv 3239944 Andres Medical Billing, Ltd. Ambulance Billing - January 2015 Aramark Uniform Services, Inc. Uniform Cleaning &. Rental Arbor Day Foundation Membership Dues Ariens Specialty Brands LLC Uniform Expense Uniform Expense Arlington Power Equipment Forestry Equipment Association of Police Social Workers Membership Renewal AT & T Service 1/16/15 - 2/15/15 Service 1/16/15 - 2/15/15 B & H Photo/video Tripod Handle Beckner, Nellie 2015 - Cake for Brian Simmons Farewell Bedco Mechanical HVAC Maintenance HVAC Maintenance HVAC Maintenance Bonnell Industries Inc. Vehicle Maintenance Supplies Bratkowski, Barbara Replacement Check #790666 Brown, Donna CDL Reimbursement Busse's Flowers & Gifts Sympathy Arrangement Sympathy Arrangement Capital One National Association Costco Purchase 12/30/14 - 12/31/14 Costco Purchase 1/5/15 - 1/23/15 Case Lots, Inc. Maintenance and repair supplies Castro, Joe CDL Reimbursement CDW Government, Inc. Microsoft Project Online for PW Century Cleaners Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Celestial Celebration Supplies Uniform Cleaning Uniform Cleaning Certified Power Inc Salt Spreader Supplies Chem -wise Ecological Pest Mgmt Inc December Pest Control Service Equipment Maintenance Chicago Title Insurance Property Research - 1125 N Boxwood Dr Necy Parties for Demolition Lien - 415 E Prospect Foreclosure Proceedings Exam - 3015 Lynn Ct Unit #E Minutes of Demolition - 2-40 N Main St Minutes of Demolition - 111 S Main St Minutes of Demolition - 230 W Northwest Hwy Commonwealth Edison Electrical Service Delivery Community College District 502 Registration for A. Kiess for Basic Recruit Academy 01/05-03/27 Constellation NewEnergy, Inc. Electrical Service Delivery Electrical Service Delivery Cook County Recorder of Deeds Recording Costar Realty Information, Inc. 2015 - ED Program Crain Communications Inc. 2015 - Crain's Renewal Crystal Court Shopping Center March rent for the CCC Cummins -Allison Corp. M-4098ES 2 Pocket Jetsca n Maintenance Contract 3/21/15 - 3/20/16 Dept.of Financial & Professional Regulation License Renewal #180009023 Julia Arteaga Page 1 of 10 Amount 48.95 3,370.00 1,486.00 213.17 220.00 62.00 255.60 48.00 6,262.33 93.55 15.00 67.95 62.95 131.98 180.00 648.54 341.79 140.00 75.82 381.85 731.10 899.90 220.00 100.00 30.00 85.00 93.50 157.71 142.34 619.80 30.00 2,066.01 12.30 14.58 19.92 16.48 12.30 16.40 16.40 180.00 29.58 25.02 199.51 215.00 215.00 100.00 1,250.00 1,325.00 650.00 650.00 650.00 21.37 3,080.00 31.05 31.05 172.00 518.75 119.00 5,839.97 2,417.28 480.00 120.00 Fund VILLAGE OF MOUNT PROSPECT List of Bills January 29 - February 11, 2015 Vendor Name Invoice Description Amount Dow Jones & Co., Inc. 2015 - Wall St. Journal Renewal 125.45 Dreisilker Electric Motors, Inc. Maintenance and repair supplies 41.11 Elite Remodeling Group, Inc. Garnishment 142.22 Emergency Medical Products SAM Splints 98.52 12 Lead cables 555.42 ERLA, Inc. Cot Maintenance 187.00 Eterno, David G. January Adjudication 600.00 Experian Background checks -January, 2015 77.00 Federal Express Corp Shipped HazMat Equipment for Repair 94.21 Fire Pension Fund Fire Pension 22,266.42 Grainger Inc. Storage Cabinet for Station 14 Lt. Office 475.20 GreatAmerica Financial Services Corporation Office equipment 149.47 Griffin, Timothy Reimburse training expenses 53.74 Reimburse expenses: Meeting w/ PRI Management 61.00 Reimburse expenses: MPPD recruiting website renewal 297.73 Guardian Emp. Dental Plan February 2015 9,649.10 Harihar, Nandagopal Refund Overpayment Police Ticket #P3937977 4.00 Heinking, Jill Reimbursement for MRC merchandise 46.99 Home Depot U.S.A., Inc. Silicone and Fabric Protector for FPB 30.37 Home Depot Statement 430.99 Hoskinson, Thomas Reimburse training expenses 40.00 Hull, David Reimbursement 15.00 IESMA Illinois Emergency Services Mgmt Assoc. Annual Dues -Malcolm 65.00 ILEAS Conference registration: Janowick, Eterno & Smith 600.00 ILETSB Executive institute Register Lisa Schaps & M. Witkowska in training course 04/07-08 100.00 Illinois American Water Company Private Fire Service 1/30/15 - 3/2/15 33.84 Illinois Department of Revenue IL State Withholding 54.09 Illinois Dept.of Agriculture Training 20.00 Illinois GFOA Membership Renewal 2015 500.00 IGFOA 2015 First Thursday Webinar Series 55.00 Register for Illinois Public Pension Institute 180.00 Illinois Landscape Contractors Assoc. Training 360.00 Illinois Paper Co. Office Supplies 299.90 Illinois School Resource Officer Association Register S. Filipek for annual conference 06/24-26/15 199.00 Illinois State Police 2014 Sex Offender's Registration Fee 240.00 IMRF IMRF 183,633.26 Internal Revenue Service Federal Withholding 425.99 International Association of Chiefs of Police Membership renewal: T. Janowick 225.00 Membership renewal: S. Burrell 100.00 Membership renewal: M. Eterno 150.00 Membership renewal: T. Griffin 225.00 International Union of Operating Engineers IUOE PW Membership Dues 903.41 Jacobo, Efrain Replacement Refund Check #791392 108.00 Janonis, Kathy Reimbursement - Celestial Celebration Expenses 345.31 Kane, Julie K Reimbursement for parking at Rush 11.75 Kartal, Serdar Refund Overpayment Police Ticket #P39376213 20.00 Kearney, Ryan Membership Renewal 115.00 Membership Renewal 84.00 Kinnucan Holiday Light Removal 3,087.84 Special Events 73.52 Lambel, Brian Food for Training Class Hosted at Station 14 240.00 Law Enforcement Targets Inc. Targets for Range program 586.54 Maxx Contractors Corp Snow Removal Services 900.00 Snow Removal Services 340.00 Snow Removal Services 4,335.00 Snow Removal Services 7,500.00 Mcmaster-carr Supply Co. Maintenance and repair supplies 358.11 Menards Light Pole Banners 42.16 Maintenance and repair supplies 39.90 Maintenance and repair supplies 31.33 Range supplies and training supplies 127.57 Range supplies 91.30 Maintenance and repair supplies 64.96 8 Snow shovels for stations 87.68 Mertes, Eric Refund of Medicare Overpayment in 2014 38.62 Metra Door and Dock, Inc. Building Maintenance 310.40 Building Maintenance 700.00 Maintenance and repair supplies 443.56 Metro Federal Credit Union MP Fire Local 4119 Dues 2,277.99 Page 2 of 10 VILLAGE OF MOUNT PROSPECT List of Bills January 29 - February 11, 2015 Fund Vendor Name Invoice Description Amount Metropolitan Alliance - Police MP Police Association Dues 1,349.50 Micro Tech Systems, Inc. Equipment Maintenance 460.19 Mid -States Organized Crime Information Center 2015 Annual membership dues 250.00 Midwest Medical Supply Company, LLC Cavicide 97.18 Mobile Print Inc. Business Cards, Personalized Note Pads 198.85 Morris, Barry J Fitness equipment maintenance 331.95 Morton Suggestion Co. T shirts for CPU events 652.80 Mount Prospect Paint, Inc. Maintenance and repair supplies 60.77 Maintenance and repair supplies 89.90 Maintenance and Supplies 74.87 Municipal Emergency Services, Inc. Fire Fighting Gloves - 24 Pair 1,381.55 Patch for Anders 19.00 Murphy, Jean P. Postage 62.00 National Assn, of Social Workers NASW Renewal Julie Kane 470.00 NCPERS Group Life Ins. IMRF Life Insurance 673.60 New World Systems Corporation New World System Escrow Fee 1,274.00 NICOR Natural Gas Consumption 139.75 Natural Gas Consumption 134.12 Natural Gas Consumption 93.94 Natural Gas Consumption 4,392.40 Natural Gas Consumption 2,739.10 Natural Gas Consumption 2,584.20 Natural Gas Consumption 2.27 North East Multi Regional Trng Register A. Lietzow for class 12/09-11/14 50.00 Register D. Carlson for class 12/10-11/14 100.00 North Suburban Association of Chiefs of Police Annual membership dues 75.00 Northeastern III. Pub. Safety Trng, Leadership I (Slobe, Wang, Vena) Jan 12-16, 2015 900.00 Northern Illinois Funeral Service Inc. Remains removal: T. Bennin to Cook Co. ME 350.00 Northern Illinois Police Alarm System Membership assessment 400.00 Emergency Services Team Assessment 3,300.00 Mobile Field Force Assessment 935.00 Northwest Central Dispatch System March 2015 - Member Assessment 56,811.12 Northwest Community Hospital Instructor renewals for First Aid 200.00 System Entry for Rady 75.00 New Hire Physical -Anders 922.00 2014 Ambulance Runs 991.76 2015 Annual Fee for Image Trend 1,575.00 2015 Annual Fee for Website Support 40.00 Northwest Electrical Supply Maintenance and Supplies 28.07 Northwest Municipal Conference Legislative Lunch 180.00 Northwest Suburban United Way United Way 105.36 Novak, Todd Kitchen Supplies for Station 12 11.07 Door Hook and Fry Pan for Station 12 43.08 Office of the Attorney General 2014 Sex Offender's Registration Fee 240.00 P.F. Pettibone & Co. Other supplies 348.95 Paddock Publications, Inc. Bid Notice 81.00 Bid Notice 72.90 Bid Notice 70.20 Par -A -Dice Gaming Corporation Lodging for IDEOA Conference 04/21-24/15 665.28 Paul Conway Shields, Inc. Drager Meter 767.50 Pennwell Publishing Company Reading Buildings Books (3) and Reading Smoke DVD (1) 375.25 Petty Cash Petty Cash - PW - January 2015 14.94 Police Department Petty Cash 12/31/14 8.00 Petty Cash January 2015 22.94 January 2015 Petty cash reimbursement 3.27 Petty Cash 340.55 Petty Cash -Dec 2014 -FD 57.05 Jan -2015 -FD -Petty Cash 70.34 Police Pension Fund Police Pension 29,518.21 Porter Lee Corporation Annual BEAST software maintenance agreement 1,555.00 Public Agency Training Council Admin Investigations/Discipline (Dawson/Lambel) 12/10-12/11/14 590.00 Ray O'herron Co., Inc. Gun for range program 453.50 Red Wing Shoe Store Safety Shoe Purchase 180.00 rescueDIRECT, Inc. Rope, prusiks, carabineers, haul system, absorbers 975.34 Ronco Industrial Supply Equipment 223.25 Maintenance and repair supplies 152.00 Sahakian, Rafi Facebook Campaign Reimbursement 9/14 - 11/14 85.37 SDI USA Inc. TN3270 plus maintenance & support for Cook County court computer 317.00 Sears Commercial One Account Maintenance and repair supplies 485.90 Page 3 of 10 VILLAGE OF MOUNT PROSPECT List of Bills January 29 - February 11, 2015 Fund Vendor Name Invoice Description $ 3,484.72 Amount Secretary of State _ Title only - Vehicle#4504 - 2003 Elgin Street Sweeper EWS Consultants, Inc. 95.00 370.00 Title only - Vehicle#4573 -1988 Backer Tractor Leaf Loader Trail Plumbing for Station 13 Kitchen 95.00 Gewalt Hamilton Assoc. 6204102 - 5-31- 2015 License Plate Renewal 4,986.96 101.00 Tile for Kitchen Remodel Title and covert plates for seized 2003 Acura Lund Industries, Inc. 196.00 SHI International Corp. Veeam Backup Software Panasonic Arbitrator installation: P-3 8,080.00 Keyboard/Case for iPad Air - DStrahl 450.00 81.00 Panasonic Arbitrator installation: P-8 Creative Cloud Subscription for CD 540.00 450.00 Adobe InDesign Subscription for KJakupovic Panasonic Arbitrator installation: P-10 198.00 Signs By Tomorrow Banners Experience Mount Prospect Economic Development 450.00 5,760.00 Sound Incorporated Phone System Monthly Support 828.83 Staples Contract & Commercial, Inc. Lexmark toner Panasonic Arbitrator installation: P-15 156.99 State of Illinois 2014 Sex Offender's Registration Fee 450.00 40.00 Systems Forms, Inc. #10 Custom Window Envelopes 1,062.68 T.P.I. 2015 Building Inspections Panasonic Arbitrator installation: P-39 26,404.50 Thanopoulos, Marianthi Planning Meeting 2015 Summer Events 22.34 The Roy Houff Company, LLC White Light Supplies 282.70 The Savanna Group, Inc. Holiday White Lights 1,530.00 Third Millennium Assoc.inc. 2015 vehicle sticker mailing 11,338.05 2014 invoice 263.94 Thompson Elevator Inspections 2015 Elevator Inspections 631.00 2015 Elevator Inspections 37.00 TMDE Calibration Labs, Inc. Radar repairs 297.85 Traffic Brick Networks LLC Special Events Supplies 1,227.78 TransUnion Risk and Alternative Data Solutions Inc Background checks - January, 2015 152.25 U.S. Bank Equipment Finance, Inc. P.W. 431862 Contract Payment 164.98 Fire Sta. 12 Tag# 31906 138.78 Uline Inc. Photo evidence supplies 115.10 United Healthcare Flex Benefit Plan Services - January 2015 1,166.25 Verizon Wireless Services LLC Cellular Service & Equipment Charges 6,127.47 Village Cyclesport Replacement pedals for exercise blkes 54.38 Village of Mount Prospect Flex - Medical 9,398.51 Warehouse Direct Sharpies, Batteries, 100.29 Toner 49.04 Office Supplies 149.03 Office Supplies 251.03 Tabs for Candidate Books, Packing Tape 16.80 Toner for Admin, FPB, Station 12 &14 196.16 Weddle Tool Company Inc. W -tool for E13 1,500.40 Wisconsin Department of Revenue WI State Withholding 740.89 WISCTF Garnishment 542.48 Zboril, David Reimburse expenses: Meeting w/ PRI Management 01/27/15 53.53 001 General Fund Total $ 486,364.94 002 Debt Service Fund Bank of New York Mellon IL General Obligation Bonds Series 2014 Admin. Fee 2/4/15-2/3/16 $ 428.00 VMP General Obligation Bonds Series 2009 3/11/15 - 3/10/16 802.50 002 Debt Service Fund Total $ 1,230.50 020 Capital Improvement Fund American Building Services Improvements to Public Buildings $ 3,484.72 CDW Government, Inc. Dispatch Speakers added to kitchen due to remodel 95.46 EWS Consultants, Inc. Design/Consultation Services 370.00 F.J. Kerrigan Plumbing Co. Plumbing for Station 13 Kitchen 3,652.81 Gewalt Hamilton Assoc. Mt. Prospect KBC Patch Design 4,986.96 Hawkinson Inc. Tile for Kitchen Remodel 1,824.72 Lund Industries, Inc. Panasonic Arbitrator installation: P-2 450.00 Panasonic Arbitrator installation: P-3 450.00 Panasonic Arbitrator installation: P-7 450.00 Panasonic Arbitrator installation: P-8 450.00 Panasonic Arbitrator installation: P-9 450.00 Panasonic Arbitrator installation: P-10 450.00 Panasonic Arbitrator installation: P-11 450.00 Panasonic Arbitrator installation: P-12 450.00 Panasonic Arbitrator installation: P-14 450.00 Panasonic Arbitrator installation: P-15 450.00 Panasonic Arbitrator installation: P-17 450.00 Panasonic Arbitrator installation: P-19 450.00 Panasonic Arbitrator installation: P-34 450.00 Panasonic Arbitrator installation: P-39 450.00 Page 4 of 10 VILLAGE OF MOUNT PROSPECT List of Bills January 29 - February 11, 2015 Fund Vendor Name Invoice Description Amount Lund Industries, Inc. Panasonic Arbitrator installation: P-42 450.00 Monarch Construction Company Kitchen Drywall Work including closing off wall, ceiling work 6,495.00 Northwest Central 9-1-1 System Motorola Subscriber Financing - February 2015 10,603.91 Shawn Martin McGovern Tile Work for Kitchen Floor 7,227.50 020 Capital Improvement Fund Total $ 45,491.08 022 Downtown Redevelopment Construction Fund Cook County Government 2014 First Installment Property Tax Bill $ 4,248.35 022 Downtown Redevelopment Construction Fund Total $ 4,248.35 040 Refuse Disposal Fund AT & T Service 1/16/15 - 2/15/15 $ 3.61 Groot Industries, Inc. Debris Disposal 332.10 IMRF IMRF 3,419.07 International Union of Operating Engineers IUOE PW Membership Dues 99.23 NCPERS Group Life Ins. IMRF Life Insurance 17.60 Village of Mount Prospect Flex - Medical 71,88 040 Refuse Disposal Fund Total $ 3,943.49 041 Motor Fuel Tax Fund Commonwealth Edison Electrical Service Delivery $ 58.22 Electrical Service Delivery 72.07 Electrical Service Delivery 57.10 Constellation NewEnergy, Inc. Electrical Service Delivery 79.17 Electrical Service Delivery 182.43 Electrical Service Delivery 225.12 Electrical Service Delivery 291.45 Electrical Service Delivery 414.77 Electrical Service Delivery 178.38 Electrical Service Delivery 167.39 Electrical Service Delivery 3,328.28 Electrical Service Delivery 252.30 Electrical Service Delivery 194.98 Electrical Service Delivery 104.61 Electrical Service Delivery 181.06 Electrical Service Delivery 157.35 Illinois State Treasurer Other Service 2,523.97 Traffic Signal Maintenance 7,627.79 Industrial Systems, Ltd Salt/De-Icing Agents 3,555.00 Lyons & Pinner Electric Companies Traffic Signal Maintenance 1,606.00 Traffic Light Maintenance 1,360.00 Morton Salt, Inc Salt/De-Icing Agents 5,205.26 Salt/De-Icing Agents 13,276.89 Salt/De-Icing Agent 23,457.76 Salt/De-Icing 30,440.29 SNI Solutions, Inc. Salt/De-Icing Agent 3,095.36 Liquid de-icer used for snow and ice control 3,708.26 Liquid de-icer used for snow and ice control 3,681.40 Liquid de-icer used for snow and ice control 3,654.54 Liquid de-icer used for snow and ice control 3,659.28 Liquid de-icer used for snow and ice control 2,365.26 V3 Companies Pedestrian Signal Project 1,887.50 041 Motor Fuel Tax Fund Total $ 117,049.24 042 Community Development Block Grant Capital One National Association Costco Purchase 1/5/15 - 1/23/15 $ 48.76 IMRF IMRF 531.74 Northwest Compass, Inc. 2014 Invoice- CDBG 1 Qtr Subrecipient 3,750.00 Saewert, Janet CDBG travel expense 47.50 T.P.I. CDBG SFR inspection 80.00 Village of Mount Prospect Flex - Medical 31.25 Wings Program, Inc. 2014 Invoice- CDBG 1 Qtr Subrecipient 2,500.00 042 Community Development Block Grant Total $ 6,989.25 043 Asset Seizure Fund Interstate Battery Battery for Seized Acura $ 87.95 Motorola Solutions, Inc. Radio for seized 2011 Toyota Camry 837.65 Schaumburg Toyota, Inc. Parts for seized Toyota Camry 480.44 043 Asset Seizure Fund Total $ 1,406.04 Page 5 of 10 VILLAGE OF MOUNT PROSPECT List of Bills January 29 - February 11, 2015 Fund Vendor Name Invoice 046 Foreign Fire Tax Board Fund Maestranzi Bros.knife Sharpening Service Station Knives - Annual Billing 2015 046 Foreign Fire Tax Board Fund Total 050 Water and Sewer Fund Addison Building Material Co. Maintenance and repair supplies Maintenance and repair supplies Maintenance and repair supplies Aramark Uniform Services, Inc. Uniform Cleaning & Rental Ariens Specialty Brands LLC Uniform Expense Uniform Expense AT & T Service 1/16/15 - 2/15/15 Bank of NY Mellon Utility Refund -41 Judith Ann Dr Baxter & Woodman, Inc, 2014 Combined Sewer Televising SCADA Support SCADA Bonnell Industries Inc. Snow Plow Blades Burns & Mcdonnell Engineering Co. Engineering Services Professional Services Professional Services Engineering Services Sanitary Sewer Flow Monitoring Capital One National Association Costco Purchase 1/5/15 - 1/23/15 CUW Government, Inc. Microsoft Project Online for PW Century Cleaners Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning CL Graphics, Inc. AMR Easy Read Brochure Constellation NewEnergy, Inc. Electrical Service Delivery Electrical Service Delivery Electrical Service Delivery East Jordan Iron Works, Inc. Maintenance and repairsupplies Maintenance and repair supplies Federal National Mortgage Utility Refund - 503 Blue Jay Ct Federal National Mortgage Corporation Utility Refund - 1710 Bonita Ave Garvey's Office Products Office Supplies Grainger Inc. Maintenance and repair supplies HBK Water Meter Service Meter Installation/Building Inspections Meter Replacements Meter Replacements Illini Power Products Company Equipment Maintenance Equipment Maintenance Equipment Maintenance Illinois Paper Co. Office Supplies IMRF IMRF International Union of Operating Engineers IUOE PW Membership Dues Julie, Inc. Julie Service Charges L & B Business Services Inc. Maintenance and repair supplies Layne Christensen Company Deep Wells Linda Menconi Utility Refund - 143 W Prospect Ave Lutheran Church of Martha & Mary Utility Refund - 915 Can Dota Ave Mazursky, Shelby Envelopes Midwest Well Service, Inc. Deep Well Rehab Deep Well Rehab Mount Prospect Paint, Inc. Maintenance and repair supplies Painting Supplies NCPERS Group Life Ins, IMRF Life Insurance NICOR Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption Northwest Suburban United Way United Way Optical Robotics LLC Training Page 6 of 10 Amount $ 390.00 $ 390.00 31.97 8.09 31.54 93.55 67.95 62.95 240.83 38.03 9,857.38 1,080.00 1,793.76 480.00 3,500.00 6,675.00 5,500.00 4,503.40 5,576.00 36.65 72'3.63 12.30 14.57 19.93 16.47 12.30 16.40 16.40 29.57 25.03 1,204.73 101.17 97.39 9,481.61 2,400.00 40.00 95.64 110.88 96.48 260.00 6,057.00 6,758.07 3,017.20 175.00 1,286.48 1,253.48 299.90 27,623.94 932.90 5,820.59 322.83 8,828.00 346.14 260.78 525.00 43,700.00 70,141.00 97.26 112.61 52.80 158.95 272.56 100.38 21.00 900.00 VILLAGE OF MOUNT PROSPECT List of Bills January 29 - February 11, 2015 Fund Vendor Name Invoice Description Amount Paddock Publications, Inc. Bid Notice 137.70 Pamela Juarez Utility Refund - 13 N Pine St 67.76 Peerless Midwest Inc Motor Pump Repair 30,275.00 Robinson Engineering, Ltd. Professional Services 702.00 Suburban Laboratories, Inc. Water Sampling Testing 1,279.00 Water Sampling 296.00 Tower Works, Inc. Tank Services 1,200.00 Tri-state Electronic Corp Water Meter repair parts 13.40 U.S. Bank Equipment Finance, Inc. P.W. #31862 Contract Payment 164.99 Urban Investments Utility Refund - 807 S Maple St 209.95 USA Bluebook Maintenance and repair supplies 113.21 Verizon Wireless Services LLC Cellular Service & Equipment Charges 408.38 Village of Mount Prospect Flex - Medical 696.27 Water Systems Engineering, Inc. Water Sampling Testing 1,060.00 Water Sampling Testing 110.00 Ziebell Water Service Products Maintenance and repair supplies 110.60 Maintenance and repair supplies 81.00 050 Water and Sewer Fund Total 97.87 $ 270,340.73 051 Village Parking System Fund Elite Remodeling Group, Inc. Garnishment $ 78.19 IMRF IMRF 493.06 International Union of Operating Engineers IUOE PW Membership Dues 15.22 NCPERS Group Life Ins, IMRF Life Insurance 4.40 Total Parking Solutions, Inc. Commuter Pay Station Parking Maintenance 3,431.75 Village of Mount Prospect Flex - Medical 34.64 051 Village Parking System Fund Total $ 4,057.26 052 Parking System Revenue Fund Constellation NewEnergy, Inc. Electrical Service Delivery $ 106.77 Electrical Service Delivery 248.59 Elite Remodeling Group, Inc. Garnishment 64.02 IMRF IMRF 363.26 International Union of Operating Engineers IUOE PW Membership Dues 10.15 NCPERS Group Life Ins. IMRF Life Insurance 3.60 NICOR Natural Gas Consumption 347.06 Petty Cash Petty Cash January 2015 2.00 Total Parking Solutions, Inc. Commuter Pay Station Parking Maintenance 5,843.25 Union Pacific Railroad Metra Land Lease - Dec. 2014 3,306.30 Village of Mount Prospect Flex - Medical 27.44 052 Parking System Revenue Fund Total $ 10,322.44 060 Vehicle Maintenance Fund American Messaging Professional Service $ 97.87 Arlington Heights Ford Vehicle Maintenance Supplies 46.17 Vehicle Maintenance Supplies 106.75 Vehicle Maintenance Supplies 62.38 P-34 Drivers seat lumbar support 49.01 P-34 Seat rivets 3,28 P-2 Spare key 26.23 Equipment Maintenance 339.25 AT & T Service 1/16/15 - 2/15/15 9.02 Atlas First Access, LLC Vehicle Maintenance Supplies 685.52 Certified Power Inc Equipment Maintenance 279.93 Chicago Parts & Sound Llc Vehicle Maintenance Supplies (72.00) Vehicle Maintenance Supplies 319.92 Vehicle Maintenance Supplies 77.04 Vehicle Maintenance Supplies 13.75 Equipment Maintenance 100.00 Cylinders, Inc. Equipment Maintenance 281.35 Equipment Maintenance 283.60 EJ Equipment Equipment Maintenance 20.20 Foster Coach Sales Inc. Vehicle Maintenance Supplies 101.56 IMRF IMRF 12,700.13 International Union of Operating Engineers IUOE PW Membership Dues 474.38 Interstate Battery 2 Batteries 175.90 Liebovich Bros, Inc. Vehicle Maintenance Supplies 404.04 Lindco Equipment Sales, Inc. Vehicle Maintenance Supplies 225.59 Vehicle Maintenance Supplies 432.80 Page 7 of 10 VILLAGE OF MOUNT PROSPECT List of Bills January 29 - February 11, 2015 Fund Vendor Name Invoice Description Amount Luca, Kevin De Reimbursement 141.00 Mcmaster-carr Supply Co. Vehicle Maintenance Supplies 45.65 Plow blade Bolts and nuts 369.15 Plow lift eyes 248.31 Morton Grove Automotive P-3 Rebuild alternator 185.00 Motion Ind. Inc. Vehicle Maintenance Supplies 168.43 Napa -Heights Automotive Supply 4538 Fuel filter 22.61 4510 Trans drain plug 1.49 NCPERS Group Life Ins. IMRF Life Insurance 48.00 Northwest Suburban United Way United Way 4.00 Palatine Oil, Inc. Fuel 13,533.07 Fuel 11,856.90 Petty Cash Petty Cash - PW -January 2015 14.94 Pomp's Tire Service, Inc. Equipment Maintenance 2,893.60 Equipment Maintenance 492.62 Ambulance tires 1,490.46 Equipment Maintenance 148.90 Vehicle Maintenance Supplies (36.00) Precision Service & Parts Vehicle Maintenance Supplies 369.92 Vehicle Maintenance Supplies 175.68 Vehicle Maintenance Supplies 31.24 Vehicle Maintenance Supplies 18.84 Ronco Industrial Supply Vehicle Maintenance 76.18 Rush Truck Centers of Illinois, Inc. Vehicle Maintenance Supplies 242.82 Vehicle Maintenance Supplies 34.48 Vehicle Maintenance Supplies 353.00 Vehicle Maintenance Supplies (31.25) Credit (132.20) Vehicle Maintenance Supplies 51.40 Vehicle Maintenance Supplies 3.46 Vehicle Maintenance Supplies 46.55 Vehicle Maintenance Supplies 3.46 Extended life Coolant 222.84 Sid Tool Co., Inc. Vehicle Maintenance Supplies 454.67 Vehicle Maintenance Supplies 499.54 Solvent Systems Int'l. Inc. Equipment Maintenance 300.00 Terrace Supply Company Equipment Maintenance 26.35 Verizon Wireless Services LLC Cellular Service & Equipment Charges 142.54 Village of Mount Prospect Flex - Medical 350.02 West Side Tractor Sales Vehicle Maintenance Supplies 301.72 Vehicle Maintenance Supplies 234.52 Wholesale Direct Inc. Vehicle Maintenance Supplies 367.89 060 Vehicle Maintenance Fund Total $ 53,015.47 061 Vehicle Replacement Fund Bonnell Industries Inc. PW Vehicles $ 12,838.65 GovDeals, Inc. PW Vehicles 1,901.39 Lund Industries, Inc. Squad conversion: P-38 2014 Charger 8,511.17 Squad conversion: old P-38, removal of equipment 350.00 MPC Communications & Lighting Fire Dept. Vehicles 5,945.10 061 Vehicle Replacement Fund Total $ 29,546.31 062 Computer Replacement Fund Upstate Wholesale Supply, Inc. Fujitsu Stylist Q704 Semi -Ruggedized Tablet $ 2,908.26 062 Computer Replacement Fund Total $ 2,908.26 063 Risk Management Fund Gallagher Bassett Services, Inc. Contract Service Fees 1/1/15-1/1/16 $ 2,390.00 Intergovernmental Per.ben.coop IPBC - February 2015 496,291.84 063 Risk Management Fund Total $ 498,681.84 070 Police Pension Fund Lauterbach & Amen, LLP Pension Services Admin Dec 2014 $ 1,280.00 Mesirow Financial Investment Management, Inc. Inv Mgr Fees 10/1/14-12/31/14 5,696.86 Saviano, Dennis Reimbursement IPPFA Seminars 1/28/15 100.00 Segall Bryant & Hamill, LLC Inv Mgr Fees 10/1/14-12/31/14 7,720.21 070 Police Pension Fund Total $ 14,797.07 Page 8 of 10 Fund Vendor Name 071 Fire Pension Fund Barrington Orthopedic Specialists, Ltd„ Collins & Radja Kathleen W. Bono,csr,ltd. Lauterbach & Amen, LLP Segall Bryant & Hamill, LLC Wells Fargo Bank 071 Fire Pension Fund Total 073 Escrow Deposit Fund 24-7 Plumbing 4 U Inc A Better Plumber VILLAGE OF MOUNT PROSPECT List of Bills January 29 - February 11, 2015 Invoice A-1 Contractors Inc AA Anthony's Incorporated ABC Plumbing & Heating Cooling Electric Adebimpe, Moses Advanced Roofing & Woodworking Inc Aldape, Rafael All Pro Plumbing AP Landscape Corp Aqua Doctors Aspen Heating & Cooling Bishop Plumbing Inc Burger Plumbing Cannella Construction Inc Chmiel, Harold A CIC Corporation Construction Management Corporation of America Cornerstone Commercial Partners Domzralski, Michael Duane Blanton Plumbing & Sewer Dubois Paving Company Duvall, Douglas Eagle Biomass Ex Stink FL RC Management LLC Four Seasons Heating and A/C Frontline Real Estate Geiser Berner Plubing Service Inc Great Spaces Home Improvement Inc Home Depot Illinois State Police In Town Electric Inc J & S Plumbing Inc Jahnke, Dolores Jimmy The Plumber K and L Contractors Kahn, Robert Kerr Mechanical Corp Knorr, Marcia Kwan, Edward LMC Landscaping Main Street Remodeling Marc Realty Millonzi, Joseph Mr Rooter Plumbing Newberg Construction Co Northshore Service Plumbers Inc Pandya, Hina Pantazis, Kiki Parks Plumbing & Sewer Inc Medical Exam - Torrie Takoy 2/12/15 Legal Service - Fire Pension Legal Service - Fire Pension Pension Services Admin Dec 2014 Inv Mgr Fees 10/1/14-12/31/14 Inv Mgr Fees 10/1/14-12/31/14 Refund Escrow Permit # 14-2272 (19 Marcella Rd) Refund Escrow Permit # 15-0010 (1803 Buckthorn Dr) Refund Escrow Permit # 14-1982 (19751 Tano Ln) Refund Escrow Permit #14-1971 (4 S Albert St) Refund Escrow Permit # 14-2521 (1826 Sitka Ln) Refund Escrow Permit # 15-0047 Refund Escrow Permit # 14-2425 (800 Business Center Dr) Refund Escrow Permit # 15-0009 Refund Escrow Permit # 14-2075 (2833 Briarwood Dr E) Refund Escrow Permit # 14-1905 (1419 Bonita Ave) Refund Escrow Permit # 14-2329 (1418 Lowden Ln) Refund Escrow Permit# 14-1069 (1003 Westgate Rd) Refund Escrow Permit # 14-2276 (1605 Rosetree Ln) Refund Escrow Permit # 14-2341 (309 S Emerson St) Refund Escrow Permit # 14-0883 (1800 W Central Rd) Refund Escrow Permit # 14-2455 Refund Escrow Permit # 14-0376 (475 Enterprise Dr) Refund Escrow Permit # 14-1840 (1480 S Elmhurst Rd) Refund Escrow Permit # 14-2417 (1250 W Northwest Hwy) Refund Escrow Permit # 14-2419 (249 E Prospect Ave) Refund Escrow Permit # 15-0015 Refund Escrow Permit # 14-2563 (111 George St) Refund Escrow Permit # 14-2122 (1000 Butternut Ln) Refund Escrow Permit # 15-0004 (903 Persimmon Ln #A) Refund Escrow Permit # 14-1584 (245 Helena Ave) Refund Escrow Permit # 14-2303 Refund Escrow Permit # 15-0002 (101 W Milburn Ave) Refund Escrow Permit # 14-2470 (1100 S Elmhurst Rd) Refund Escrow Permit # 15-0040 (700 S Emerson St) Refund Escrow Permit # 14-2439 (303 E Kensington Rd) Refund Escrow Permit # 15-0035 (900 Greenfield Ln) Refund Escrow Permit # 14-2115 (1405 Plum Ct#B) Refund Escrow Permit # 14-0147 Seized Assets - MPPD Case#14-12301- S.A.O. #14-09-0315 Refund Escrow Permit # 15-0022 (602 Russel St) Refund Escrow Permit # 15-0023 (604 Russel St) Refund Escrow Permit # 14-1401 (1814 Pheasant Trl) Refund Escrow Permit # 14-1811 (815 Na Wa Ta Ave) Refund Escrow Permit # 14-2036 (714 W Busse Ave) Refund Escrow Permit # 14-2242 (216 Forest Ave) Refund Escrow Permit # 14-2408 (313 N Elmhurst Ave) Refund Escrow Permit # 14-1870 Refund Escrow Permit # 14-1783 (607 S Main St) Refund Escrow Permit # 14-2457 (112 N Cathy Ln) Refund Escrow Permit # 14-2484 Refund Escrow Permit # 14-1962 (910 5 Lancaster Ave) Refund Escrow Permit # 14-2243 (107 S Maple St) Refund Escrow Permit # 14-2571 Refund Escrow Permit # 14-1773 (100 N Elm St) Refund Escrow Permit # 14-2502 (1003 Newberry Ln) Refund Escrow Permit # 14-2446 (800 E Northwest Hwy) Refund Escrow Permit # 14-2450 Refund Escrow Permit # 14-2262 (904 Sumac Ln) Refund Escrow Permit # 14-2523 (109 W Sunset Rd) Refund Escrow Permit # 14-1458 (523 N Main St) Refund Escrow Permit # 14-2259 (1772 E Euclid Ave) Refund Escrow Permit # 14-2154 Refund Escrow Permit # 14-2551 Refund Escrow Permit # 14-2568 Page 9 of 10 Amount $ 1,295.00 4,220.48 629.50 1,500.00 7,584.42 4,601.84 $ 19,831.24 125.00 125.00 200.00 125.00 125.00 125.00 75.00 125.00 125.00 200.00 125.00 125.00 125.00 125.00 125.00 25.00 400.00 200.00 125.00 125.00 125.00 125.00 125.00 125.00 500.00 450.00 500.00 125.00 125.00 125.00 125.00 150.00 75.00 5,976.00 125.00 125.00 125.00 125.00 125.00 125.00 500.00 200.00 125.00 200.00 125.00 75.00 200.00 125.00 200.00 125.00 125.00 500.00 125.00 125.00 125.00 125.00 200.00 125.00 125.00 VILLAGE OF MOUNT PROSPECT List of Bills January 29 - February 11, 2015 Fund Vendor Name Invoice Description Amount Pinel Andrews Construction Refund Escrow Permit # 14-1732 (208 N Emerson St) 150.00 Precision Plumbing Services Inc Refund Escrow Permit # 14-2449 125.00 Quality Blacktop Refund Escrow Permit # 14-0505 (1210 W Lonnquist Blvd) 200.00 Ricks Sewer & Drainage Refund Escrow Permit # 14-2507 (1215 W Sunset Rd) 500.00 Robert Schwake Stone Co Inc Refund Escrow Permit # 14-1741(1000 N Prospect Manor Ave) 200.00 Rose Paving Company Refund Escrow Permit # 14-1536 (199 W Rand Rd) 125.00 Roto Rooter Refund Escrow Permit # 14-2163 (1804 Wood Ln) 125.00 Roto Rooter Glenview Refund Escrow Permit # 14-2269 (1304 W Busse Ave) 75.00 Ruppert, Joan A 450.00 Shah, Anjana P Refund Escrow Permit # 14-2469 150.00 Sipruit, Joseph Refund Escrow Permit # 14-2034 200.00 Stevens, Edward Refund Escrow Permit # 14-2420 125.00 Stukin, Andrzej Refund Escrow Permit# 14-2347 125.00 Suburban Sewer & Septic Refund Escrow Permit # 15-0020 (2003 Ivy Ln) 125.00 SWC Concrete Refund Escrow Permit # 14-1729 (513 S Albert St) 200.00 T&T Weidners Sewer Refund Escrow Permit # 14-2338 (1729 W Lincoln St) 125.00 The Patching People Inc Refund Escrow Permit # 14-1416 (55 E Euclid Ave) 125.00 Third District Circuit Court Bond Check 1/29/15 200.00 Bond Check 2/3/15 500.00 Bond Check 2/5/15 200.00 Bond Check 2/10/15 150.00 Toosley, Warren Refund Escrow Permit # 15-0045 125.00 Village Sewer & Plumbing Refund Escrow Permit # 14-2003 (2919 Briarwood Dr W) 125.00 Refund Escrow Permit # 14-2499 (1803 Cree Ln) 125.00 VKR Enterprises Inc Refund Escrow Permit # 14-23619906 Sumac Ln) 125.00 Wal-Mart Real Estate Business Trust Refund Escrow Permit # 14-0198 (930 Mt. Prospect Plaza) 125.00 Water Services Company Refund Escrow Permit # 14-2063 (1327 Columbine Dr) 125.00 Waterguard Plumbing Service Refund Escrow Permit # 14-2081 (20 We Go Trl) 125.00 Weiner, Lawrence 1 Refund Escrow Permit # 15-0013 125.00 White Way Sign & Maintenance Co Refund Escrow Permit # 14-0122 (1441 Business Center Dr) 125.00 Zukich, Salih Refund Escrow Permit # 14-1759 200.00 073 Escrow Deposit Fund Total $ 21,201.00 Grand Total $ 1,591,814.51 Page 10 of 10