Loading...
HomeMy WebLinkAbout3. Monthly Financial Report and Bills 02/19/2013Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: FEBRUARY 15, 2013 SUBJECT: MONTHLY FINANCIAL REPORT — JANUARY 2013 Attached hereto are the cash position and investment statements of the Village for the month ended January 31, 2013. These statements provide a snapshot of the Village's cash position as of the month end date noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you receive. The first statement presents the Village's cash position broken down by governmental and enterprise funds and trust and agency funds. The second statement presents the Village's cash position by fund type. The third statement presents the list of investments again broken down by governmental and enterprise funds and trust and agency funds. It is important to note that although we have included the trust and agency funds in the cash position report, these funds are not accessible for Village operations. They are restricted for pension and escrow funding only. Please read the summary that follows for further detail on the cash position of the Village. Cash and Investment Position Report — All Funds (page 1) This report provides a detail summary of cash and investments for the Village broken out by governmental and enterprise funds and trust and agency funds. Governmental funds include the General Fund, Special Revenue Funds, Debt Service 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, Special Service Area 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 Special Service Area Fund and 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 $31.5 million. During January, cash receipts totaled $4,824,182. In addition investment income for the month was $2,457. Reductions in cash and cash equivalents during January totaled $5,766,272. Of this amount, payments to vendors were $3,750,844 and employee payroll and related expenses were $2,015,428. Other disbursements totaled $4,964. Cash and cash equivalents at January 31 were $30.6 million. Monthly Financial Report — January 2013 February 15, 2013 Page 2 There were no funds held- in investments during the_ month - of January: Funds were held in cash money market accounts that currently earn competitive rates of interest. Total cash and investments for Governmental and Enterprise Funds at December 31 were $31,493,055. Cash and investments at January 31 totaled $30,595,296. This is a decrease of $897,759. Trust and Agency Funds - Cash and cash equivalents at December 31 were $5.4 million. During January, cash receipts totaled $325,540. Investment income for the month was $126,593. There was also a net increase in cash due to investment activities of $44,466. Reductions in cash and cash equivalents during January totaled $703,779. Of this amount, payments to vendors were $136,929, payments for employee payroll related expenses were $524,785 and payments related to the flexible spending program totaled $32,901. Other disbursements were $9,164. Cash and cash equivalents at January 31 decreased to $5.1 million. Total investments at January 31 were $92,664,544, an increase of $787,744 from December 31. There were unrealized investment gains of $832,210 and a transfer to cash of $44,466 that accounted for the change. Total cash and investments for Trust and Agency Funds at December 31 were $97,227,821. Cash and investments at January 31 totaled $97,761,546. This is an increase for the month of $533,725. 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,831,584. During January, cash receipts totaled $2,679,160 and investment income was $1,532. Significant cash receipts included sales and telecommunication taxes and building permits. Sales tax revenues for the month totaled $995,118. Of this amount, $896,034 was generated from the 1 % state portion while $99,084 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. Telecommunication tax receipts for January reflect October activity. Total receipts during January were $228,704. H:\ACCT\Treasurer's Report\2013 \Monthly Cash Position Report - January 2013.docx Monthly Financial Report — January 2013 February 15, 2013 Page 3 Building Permit revenue for January totaled $135,928. This accounts for 21.7% of the total budget for 2013. The higher than expected receipts in January were due to a single permit totaling $128,488. Typical permit revenues in January are between $10,000 and $40,000. Disbursements from the General Fund for January included payments to vendors of $1,555,561 and payments for employee wages and benefits of $1,784,258. Other disbursements totaled $4,964. Interfund transfers of $792,966 for health premiums and vehicle lease and maintenance payments were also made during the month. Cash and cash equivalents at January 31 were $6,374,526. There were no investments in the General Fund at January 31. 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 October 31 there were no CD's placed at any bank. This is due to the extremely low interest rates being offered. Money instead has been placed in interest bearing money market accounts 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 pension funds also have a small portion of their portfolio invested in international stocks. Each year the investment mix is evaluated for optimal diversification to meet the pension funds investment policy goals and objectives. Below is a breakdown of how the pension fund portfolios are invested. HAACCT\Treasurer's Report\2013 \Monthly Cash Position Report - January 2013.docx Monthly Financial Report — January 2013 February 15, 2013 Page 4 Maturity Purchase Financial Date Date Institution Investment CUSIP/ Description acct # Interest Market Rate % Value 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 Various Various 23,613,285.73 Various Various 24,288,097.24 47,901,382.97 Wells Fargo Investments Mutual Fund Investments Various Various 20,786,352.82 Various Various 23,976,808.61 44,763,161.43 $ 92,664,544.40 Wells Fargo Investments Mutual Fund Investments 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. David O. Erb Finance Director H:WCCT\Treasurer's Report\2013 \Monthly Cash Position Report - January 2013.docx VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended January 31, 2013 GOVERNMENTAL AND ENTERPRISE FUNDS Disbursements: Accounts payable (3,750,843.91) (3,750,843.91) Payroll (2,015,428.45) (2,015,428.45) Other (4,964.38) (4,964.38) Balance at January 31, 2013 $ 30,595,296.44 $ - $ 30,595,296.44 TRUST AND AGENCY FUNDS Cash and Cash Equivalents Balance at December 31, 2012 $ 5,351,020.10 Cash receipts Cash and Cash Total Cash and 126,592.73 832,210.24 Equivalents Investments Investments Balance at December 31, 2012 $ 31,493,055.01 $ - $ 31,493,055.01 Cash receipts 4,824,182.00 4,824,182.00 Investment income 2,457.26 2,457.26 Transfers from investments to cash _ - - Transfers to investments from cash - - - Interfund activity 46,838.91 46,838.91 Disbursements: Accounts payable (3,750,843.91) (3,750,843.91) Payroll (2,015,428.45) (2,015,428.45) Other (4,964.38) (4,964.38) Balance at January 31, 2013 $ 30,595,296.44 $ - $ 30,595,296.44 TRUST AND AGENCY FUNDS Cash and Cash Equivalents Balance at December 31, 2012 $ 5,351,020.10 Cash receipts 325,540.15 Investment income (loss) 126,592.73 832,210.24 Transfers from investments to cash 2,187,572.93 (2,187,572.93) Transfers to investments from cash (2,143,106.63) 2,143,106.63 Interfund activity (46,838.91) Disbursements: Accounts payable Payroll Flex spending Other (136,928.58) (524,784.86) (32, 900.96) (9,164.21) Balance at January 31, 2013 $ 91, 876, 800.46 $ 97,227, 820.56 Total Cash and Investments Investments 325, 540.15 958, 802.97 (46,838.91) (136, 928.58) (524, 784.86) (32,900.96) (9,164.21) $ 5,097,001.76 $ 92,664,544.40 $ 97,761,546.16 Assets are restricted in purpose and do not represent discretionary assets of the government. 1 X CASH & CASH EQUIVALENTS Beginning balance Cash receipts Investment income Transfers from investments Transfers to investments Interfund Disbursements - other Disbursements - flexible spending Disbursements - payroll Disbursements - accounts payable Ending balance INVESTMENTS Certificates of deposit Wells Fargo investments Mutual fund investments VILLAGE OF MOUNT PROSPECT Summary of Cash Activity by Fund Type For the Month Ended January 31, 2013 GOVERNMENTAL AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS . SPECIAL CAPITAL TOTAL GOVT. FIRE AND OTHER TRUST REVENUE DEBT SERVICE PROJECTS ENTERPRISE INTERNAL AND ENTERPRISE POLICE AND AGENCY GENERAL FUND FUNDS FUNDS FUNDS FUNDS SERVICE FUNDS FUNDS PENSIONS FUNDS TOTAL $ 7,831,584.35 $ 3,199,069.31 $ 9,298.22 $ 6,612,481.10 $ 4,486,409.66 $ 9,354,212.37 $ 31,493,055.01 $ 3,910,843.62 $ 1,440,176.48 $ 36,844,075.11 2,679,159.66 429,242.85 50,326.32 507,058.92 1,049,441.75 108,952.50 4,824,182.00 207,247.18 118,292.97 5,149,722.15 1,532.21 0.87 - 317.07 2.78 604.33 2,457.26 126,443.63 149.10 129,049.99 _ _ - _ - 2,187,572.93 - 2,187,572.93 (792,966.29) 22,694.36 - 190,440.00 (158,606.85) 785,277.69 46,838.91 (2,143,106.63) (36,167.41) (10,671.50) (2,143,106.63) 0.00 (4,964.38) - (4,964.38) (550.00) (8,614.21) (14,128.59) (1,784,258.38) (19,922.85) _ (146,042.82) (65,204.40) (2,015,428.45) (524,784.86) (32,900.96) - (32,900.96) (2,540,213.31) (1,555,560,68) (470,929.90) (19,644.42) (150,024.44)_ (678,560,49) (876.123.98) (3,750,843.91) (99,505.64) (37,422.94) 3,887,772.49) 6,374,526.49 3,160,154.64 39,980.12 7,160,272.65 4,552,644.03 9,307,718.51 30,595 3,627,992.82 1,469,008.94 35,692,298.20 ' - 44,399,638.55 -- 44,399,638.85 a - 48,264,905.85 48,264,905,85 Total investments 92,664.544.40 92.664.544.40 TOTAL CASH AND INVESTMENTS $ 6,374,526.49 $ 3,160,154.64 $ 39,980.12 $ 7,160.272.65 $ 4,552,644.03 $ 9,307,718.51 $ 30,595,296.44 $ 96,292,537.22 $ 1,469,008.94 $128,356,842.60 Assets are restricted in purpose and do not represent discretionary assets of the government. VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of January 31, 2013 GOVERNMENTAL AND ENTERPRISE FUNDS Maturity Purchase Financial Investment CUSIP/ Interest Market Date Date Institution Description Acct # Rate % Value As of January 31, 2013, there were no certificates of deposit held by the Governmental and Enterprise Funds. TRUST AND AGENCY FUNDS * Maturity Purchase Financial Date Date Institution POLICE PENSION FUND (070) Various Various Wells Fargo Various Various Various FIRE PENSION FUND (071) Various Various Wells Fargo Various Various Various Investment CUSIP/ Description Acct # Wells Fargo Investments Various Mutual Fund Investments Various Wells Fargo Investments Various Mutual Fund Investments Various TOTAL TRUST AND AGENCY FUND INVESTMENTS * Assets are restricted in purpose and do not represent discretionary assets of the government. Interest Rate % Various Various Various Various Market 23,613,285.73 24,288,097.24 47,901,382.97 20,786,352.82 23,976,808.61 44,763,161.43 $92,664,544.40 3 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES January 01— January 31, 2013 Revenue Budget by Account Classification Report Account Classification Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactlons Transactions Recd Prior Year YTD Fund 001 - General Fund REVENUE Property Taxes 12,853,668.00 .00 12,853,668.00 .00 .00 .00 12,853,668.00 0 .00 Other Taxes 8,043,000.00 .00 8,043,000.00 90,615.46 .00 90,615.46 7 1 99,780.89 Licenses, Permits & Fees 2,704,000.00 .00 2,704,000.00 183,386.50 .00 183,386.50 2,520,613.50 7 64,578.56 Intergovernmental Revenue 17,690,630.00 .00 17,690,630.00 58,591.82 .00 58,591.82 17,632,038.18 0 52,489.87 Charges For Servlces 1,493,000.00 .00 1,493,000.00 156,454.81 .00 156,454.81 1,336,545.19 10 55,600.55 Fines & Forrelts 480,000.00 .00 480,000.00 20,185.83 .00 20,185.83 459,814.17 4 21,304.56 Investment Income 35,000.00 .00 35,000.00 1,678.71 .00 1,678.71 33,321.29 5 1,862.22 Relmbursements 230,500.00 .00 230,500.00 8,985.67 .00 8,985.67 221,514.33 4 12,682.46 Other Revenue 792,200.00 .00 792,200.00 29,778.89 .00 29,778.89 762,421.11 4 61,119.42 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $44,321,998.00 $0.00 $44,321,998.00 $549,677.69 $0.00 $549,677.69 $43,772,320.31 1% $369,418.53 Fund 001- General Fund Totals $44,321,998.00 $0.00 $44,321,998.00 $549,677.69 $0.00 $549,677.69 $43,772,320.31 $369,418.53 H 71 Account Classification Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 002 - Debt Service Fund REVENUE Property Taxes 1,745,400.00 .00 1,745,400.00 .00 .00 .00 1,745,400.00 0 .00 Other Taxes 613,356.00 00 613,356.00 .00 .00 .00 613,356.00 0 .00 Intergovernmental Revenue 47,258.00 .00 47,258.00 .00 .00 .00 47,258.00 0 00 Investment Income 600.00 .00 600.00 .00 .00 .00 600.00 0 .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... 8,210,0 REVENUE TOTALS $2,406,614.00 $0.00 $2,406,614.00 $0.00 $0.00 $0.00 $2,406,614.00 0% $8,210.00 Fund 002 - Debt Service Fund Totals $2,406,614.00 $0.00 $2,406,614.00 $0.00 $0.00 $0.00 $2,406,61-.00 $8,210.00 Revenue Budget by Account Classification Report Account Classification Fund 020 - Capital Improvement REVENUE Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Other Taxes 1,135,000.00 .00 1,135,000.00 .00 .00 .00 1,135,000.00 0 .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .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 5,000.00 .00 5,000.00 190,440.00 .00 190,440.00 (185,440.00) 3809 ,00 Other Financing Sources .00 .00 .00 .00 .00 00 .00 + ++ .00 REVENUE TOTALS $1,140,50 $0. $1,140,500, $ $0. 00 $ 190,440.00 $ 950, 06 0, 00 17% $0.00 Fund 020 - Capital Improvement Fund Totals $1,140,500.00 $0.00 $1,140,500.00 $190,440.00 $0.00 $190,440.00 $950,060.00 $0.00 W Account Classification Fund 021- Series 2009 Construction Fund REVENUE Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transact ons Recd Prior Year YTD Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 ... .00 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 100 + ++ .00 REVENUE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 + ++ $0.00 Fund 021- Series 2009 Construction Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Revenue Budget by Account Classification Report Account Classification Fund 022 - Downtown Redevelopment Construct REVENUE Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Property Taxes 2,681,000.00 .00 2,681,000.00 .00 .00 .00 2,681,000.00 0 .00 Investment Income 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Reimbursements .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Financing Sources .00 . 0 0 .00 . .00 .00 .00 + ++ .00 REVENUE TOTALS $2,682,000.00 $0.00 $2,682,000.00 $0.00 $0.00 $0.00 $2,682,000.00 0% $0.00 Fund 022 -Downtown Redevelopment Construct Tctals $2,682,000.00 $0.00 $2,682,000.00 $0.00 $0.00 $0.00 $2,682,000.00 $0.00 T Account Classification Fund 023 - Street Improvement Construc Fund REVENUE Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTD Other Taxes 1,545,000,00 .00 1,545,000.00 .00 .00 .00 1,545,000.00 0 .00 Licenses, Permits & Fees .00 .00 .00 .00 .00 .00 .00 + ++ .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 ... .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 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... . REVENUE TOTALS $1,550,500.00 $0.00 $1,550,500.00 $0.00 $0.00 $0.00 $1,550,500.00 0% $0.00 Fund 023 - Street Improvement Construc Fund Totals $1,550,500.00 $0.00 $1,550,500.00 $0.00 $0.00 $0.00 $1,550,500.00 $0.00 Revenue Budget by Account Classification Report )L Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 024 - Flood Control Construction Fund REVENUE Other Taxes 621,644.00 .00 621,644.00 .00 .00 .00 621,644.00 0 .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Charges For Services 7,500.00 .00 7,500.00 .00 .00 .00 7,500.00 0 .00 Investment Income 00 .00 .00 317.07 .00 317.07 (317.07) ... .00 Reimbursements 56,500.00 .00 56,500.00 .00 .00 .00 56,500.00 0 56,521.31 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $685,644.00 $0.00 $685,644.00 $317.07 $0.00 $317.07 $685,326.93 0% $56,521.31 Fund 024 - Flood Control Construction Fund Totals $685,644.00 $0.00 $685,644.00 $317.07 $0.00 $317.07 $685,326.93 $56,521.31 Dc. Account Classification Fund 040 - Refuse Disposal Fund REVENUE Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Property Taxes 1,857,000.00 .00 1,857,000.00 .00 .00 .00 1,857,000.00 0 .00 Charges For Services 2,190,000.00 .00 2,190,000.00 100,138.54 .00 100,138.54 2,089,861-46 5 54,570.41 Fines & Forfeits 45,000.00 .00 45,000.00 8,35 .00 8.35 44,991.65 0 2,886.48 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 366,000.00 . 366,000.00 4. .00 4. 50 3 65, 9 9 5: 50 0 25.00 REVENUE TOTALS $4,458,500.00 $0.00 $4,458,500.00 $100,151.39 $0.00 $100,151.39 $4,358,348.61 2% $57, Fund 040 - Refuse Disposal Fund Totals $4,458,500.00 $0.00 $4,458,500.00 $100,151.39 $0.00 $100,151.39 $4,358,34 &61 $57,481.89 Revenue Budget by Account Classification Report Account Classification Fund 041 - Motor Fuel Tax Fund REVENUE Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Intergovernmental Revenue 1,690,000.00 .00 1,690,000.00 ,00 .00 .00 1,690,000.00 0 .00 Investment Income 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 Reimbursements 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 4,932.51 REVENUE TOTALS $1,705,100.00 $0.00 $1,705,100.00 $0.00 $0.00 $0.00 $1,705,100.00 0% $4,932.51 Fund 041 - Motor Fuel Tax Fund Totals $1,705,100.00 $0.00 $1,705,100.00 $0.00 $0.00 $0.00 $1,705,100.00 $4,932.51 H 0 Account Classlficatlon Fund 042 - Cmmty Development Block Grant REVENUE Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - tiTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Intergovernmental Revenue 230,203.00 .00 230,203.00 .00 .00 .00 230,203.00 0 .00 Investment Income .00 .00 .00 .00 .00 .00 .00 ... .00 Other Revenue 60,000.00 .00 60,000.00 .00 .00 .00 60,OO 0 . REVENUE TOTALS $290,203.00 $0.00 $290,203.00 $0.00 $0.00 $0.00 $290,203.00 0 % $ 0.00 Fund 042 - Cmmty Development Block Grant Totals $290,203.00 $0.00 $290,203.00 $0.00 $0.00 $0.00 $290,203.00 $0.00 r Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Class Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 043 - Asset seizure Fund REVENUE Fines & Forfeits 3,000.00 .00 3,000.00 2,527.14 .00 2,527.14 472.86 84 .00 Investment Income 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 REVENUE TOTALS $ 3,100.00 $0.00 $3,100.00 $2,527.14 $0.00 $2,527.14 $572.86 82% $0.00 Fund 043 - Asset Seizure Fund Totals $3,100.00 $0.00 $3,100.00 $2,527.14 $0.00 $2,527.14 $572.86 $0.00 r N Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Ac Classification Bu dget A Budget T Encumbrances Transactions Transacticns Recd Prior Year YTD Fund 044 - DEA Shared Funds Fund REVENUE Fines & Forfeits 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 OD Investment Income 100.00 .00 100.00 .87 .00 .87 99.1 1 . REVENUE TOTALS $1,100.00 $0.00 $1,100.00 $0.87 $0.00 $0.87 $1,099.13 0% $0.90 Fund 044 - DEA Shared Funds Fund Totals $1,100.00 $Q.Dt1 $1,100.00 $0.87 $0.00 $0.87 $1,099.13 $0.90 Revenue Budget by Account Classification Report Ac Classification Fund 045 - DUI Fine Fund REVENUE Fines & Forfeits Investment Income Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD 20,000.00 .00 20,000.00 .00 .00 .00 20,000.00 0 .00 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 REVENUE TOTALS $20,100.00 $0.00 $20,100.00 $0.00 $0.00 $0.00 $20,100.00 0% $0.00 Fund 045 - DUI Fine Fund Totals $20,100.00 $0.00 $20,100.00 $0.00 '0.00 $0:00 $20,100.00 10.00 r w F- Account Classification Fund 046 - Foreign Fire Tax Board Fund REVENUE Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Other Taxes 55,000.00 .00 55,000.00 .00 ,00 00 55,000.00 0 .00 Investment Income AO .00 .00 .00 .00 .00 .00 + ++ .00 Other Financing Sources .00 .00 .00 .00 .00 .00 . 00 + ++ . REVENUE TOTALS $55,000.00 $ $55,000. $0.0 $ 0. 00 $ $ 55,000. 00 0% $0.00 Fund 046 - Foreign Fire Tax Board Fund Totals $55,000.00 $0.00 $55,000.00 $0.00 $0.00 $0.00 $55,000.00 $0.00 Revenue Budget by Account Classification Report Account Classification Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 047 - ]ustice Assistance Grant Fund REVENUE Intergovern mental Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Investment Income <00 ,00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 + ++ $0.00 Fund 047 - ]ustice Assistance Grant Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 r Ln rn Account Classification Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 048 - Business District Fund REVENUE Other Taxes 671,000.00 .00 671,000.00 .00 .00 .00 671,000.00 0 .00 Investment Income .00 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $671,000.00 $0.00 $671,000.00 $0.00 $0.00 $0.00 $671,000.00 0% $0.00 Fund 048 - Business District Fund Totals $671,000.00 $0.00 $671,000.00 $0.00 $0.00 $0.00 $671,000.00 $0.00 Revenue Budget by Account Classification Report Account Classification Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 050 - Water and Sewer Fund REVENUE Property Taxes 1,516,000.00 .00 1,516,000.00 .00 .00 .00 1,516,000.00 0 .00 Licenses, Permits & Fees 16,000.00 .00 16,000.00 1,440.00 .00 1,440.00 14,560.00 9 550.00 Charges For Services 10,534,000.00 .00 10,534,000.00 1,209,292.17 .00 1,209,292.17 9,324,707.83 11 704,081.81 Fines & Forfeits 125,000.00 .00 125,000.00 280.12 .00 280.12 124,719.88 0 8,494.81 Investment Income 3,000.00 .00 3,000.00 2.78 .00 2.78 2,997.22 0 2.09 Reimbursements 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Other Revenue 25,000.00 .00 25,000.00 499.24 .00 499.24 24,500.76 2 324.05 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $12,220,000.00 $0.00 $12,220,000.00 $1,211,514.31 $0.00 $1,211,514.31 $11,008,485.69 10% $713,452.76 Fund 050 -Water and Sewer Fund Totals $12,220,000.00 $0.00 $12,220,000.00 $1,211,514.31 $0.00 $1,211,514.31 $11,008,485.69 $713,452.76 r F- 00 Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 051 - Village Parking System Fund REVENUE Other Taxes 10,000.00 .00 10,000.00 .00 .00 .00 10,000.00 0 .00 Charges For Services 109,000.00 .00 109,000.00 12,035.15 .00 12,035.15 96,964.85 11 14,867.60 Investment Income 500.00 .00 500.00 .00 .00 .00 500.00 0 ,00 Other Revenue 6,600.00 .00 6,600.00 550.00 .00 550.00 6,050.00 8 .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $126,100.00 $0.00 $126,100.00 $12,585.15 $0.00 $12,585.15 $113,514.85 10% $14,86 Fund 051 - Village Parking System Fund Totals $126,100.00 $0.00 $126,100.00 $12,585.15 $0.00 $12,585.15 $113,514.85 $14,867.60 Revenue Budget by Account Classification Report Account Classification Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec Prior Year YTD Fund 052 - Parking System Revenue Fund REVENUE Other Taxes 90,000.00 .00 90,000.00 .00 .00 .00 90,000.00 0 .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 + ++ 00 Charges For Services 110,000.00 .00 110,000.00 8,687.20 .00 8,687.20 101,312.80 8 7,546.00 Investment Income 500.00 .00 500.00 .00 .00 .00 500.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 $ 200,500.0 0 $0.00 $200,500.00 $8,687.20 $0.00 $8,687.20 $191,812.80 4% $7,546.00 Fund 052 - Parking System Revenue Fund Totals $200,500.00 $0.00 $200,500.00 $8,687.20 $0.00 $8,687.20 $191,812.80 $7,546.00 r -10 N O Account Classification Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactlons Recd Prior Year YTD Fund 060 - Vehicle Maintenance Fund REVENUE Charges For Services 2,193,313.00 .00 2,193,313.00 182,776.10 .00 182,776.10 2,010,53690 8 167,517.07 Investment Income .00 .00 .00 36.63 .00 36.63 (36.63) ... 27.90 Other Revenue .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $2,193,313.00 $0.00 $2,193,313.00 $182,812.73 $0.00 $182,812.73 $2,010,500.27 8% $167,544.97 Fund 060 - Vehicle Maintenance Fund Totals $2,193,313.00 $0.00 $2,193,313.00 $182,812.73 $0.00 $182,812.73 $2,010,50127 $167,544.97 Revenue Budget by Account Classification N Report tpj Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classlflcation Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 061- Vehicle Replacement Fund REVENUE Charges For Services 1,396,600.00 .00 1,396,600.00 116,383.34 .00 116,383.34 1,280,216.66 8 98,649.99 Fines 8L Forfeits 12,750.00 .00 12,750.00 .00 .00 .00 12,750.00 0 .00 Investment Income 3,500.00 .00 3,500.00 366.25 .00 366.25 3,133.75 10 279.98 Other Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Financing Sources 50,000.00 .00 50,000.00 .00 .00 .00 50,000.00 0 00 REVENUE TOTALS $1,462,850.00 $0.00 $1,462,850.00 $116,749.59 $0.00 $116,749.59 $1,346,100.4! 8% $98,929.97 Fund 061 - Vehicle Replacement Fund Totals $1,462,850.00 $0.00 $1,462,850.00 $116,749.59 $0.00 $116,749.59 $1,346,100.41 $98,929.97 N Revenue Budget by Account Classification )LP/ Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classi ication Budget Amendments Budget Transactions Encumbrances Transactions Tran Rec'd Pr Year YTD Fund 062 - Computer Replacement Fund REVENUE Charges For Services .00 .00 .00 .00 .00 ,00 _00 + ++ 00 Investment Income 1,000,00 .00 1,000.00 54.95 ,00 54.95 945.05 5 42.02 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $1,000.00 $0.00 $1,000.00 $54.95 $0.00 $54.95 $945.05 5% $42.02 Fund 062 - Computer Replacement Fund Totals $1,000,00 $0.00 $1,000.00 $54.95 $0.00 $54.95 $945.05 $42.02 Revenue Budget by Account Classification Report Account Classification Fund 063 - Risk Management Fund REVENUE Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prlor Year YTD Charges For Services 6,213,501.00 .00 6,213,501.00 491,781.52 .00 491,781.52 5,721,719.48 8 438,875.21 Investment Income 2,000.00 .00 2,000.00 146.50 .00 146.50 1,853.50 7 112.03 Relmbursements 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 .00 Other Revenue 1,452,000.00 .00 1,452,000.00 105,502.40 .00 105,502.40 1,346,497.60 7 86,736.18 REVENUE TOTALS $7,669,501.00 $0.00 $7,669,501.00 $597,430.42 $0.00 $597,430.42 $7,072,070.58 8% $525,723.42 Fund 063 - Risk Management Fund Totals $7,669,501.00 $0.00 $7,669,501.00 $597,430.42 $0.00 $597,430.42 $7,072,070.58 $525,723.42 N W N �P Account Classification Fund 070 - Police Pension Fund REVENUE Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactlons Encumbrances Transactlons Transactions Rec'd Prlor Year YTD Charges For Services .00 .00 .00 .00 .00 .00 .00 + ++ .00 Investment Income 2,274,500.00 .00 2,274,500.00 1,050,438.92 .00 1,050,438.92 1,224,061.08 46 220,722.33 Other Revenue 3,416,221.00 .00 3,416,221.00 67,684.16 .00 67,684.16 3,348,536.84 2 80,268.85 REVENUE TOTALS $5,690,721.00 $0.00 $5,690,721.00 $1,118,123.08 $0.00 $1,118,123.08 $4,572,597.92 20% $300,991.18 Fund 070 - Police Pension Fund Totals $5,690,721.00 $0.00 $5,690,721.00 $1,118,123.08 $0.00 $1,118,123.08 $4,572,597.92 $300,991.18 Accoun Classification Fund 071- Fire Pension Fund REVENUE Investment Income Other Revenue Revenue Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD 2,255,000.00 .00 2,255,000.00 (92,670.44) .00 (92,670.44) 2,347,670.44 -4 185,648.00 2,932,247.00 .00 2,932,247.00 49,927.28 .00 49,927.28 2,882,319.72 2 75,287.25 REVENUE TOTALS $5,187,247.00 $0.00 $5,187,247.00 ($42,743.16) $0.00 ($42,743.16) $5,229,990.16 -1% $260,935.25 Fund 071 - Fire Pension Fund Totals $5,187,247.00 $0.00 $5,187,247.00 ($42,743.16) $0.00 ($42,743.16) $5,229,990.16 $260,935.25 Grand Totals $94,742,591.00 $0.00 $94,742,591.00 $4,048,328.43 $0.00 $4,048,328.43 $90,694,262.57 $2,586,598.31 N UI Expense Budget by Account Classification Report Account Classification Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 001- General Fund EXPENSE Personal Services, Scheduled Salaries & Wages 23,392,721.00 .00 23,392,721.00 1,543,648.85 .00 1,543,648.85 21,849,072.15 7 937,407.79 Employee Benefits 11,668,453.00 .00 11,668,453.00 469,736.18 .00 469,736.18 11,198,716.82 4 420,160.40 Other Employee Costs 370,429.00 .00 370,429.00 21,264.09 19,134.65 21,264.09 330,030.26 11 29,149.46 Pension Benefits 46,151.00 .00 46,151.00 3,845.81 .00 3,845.81 42,305.19 8 3,833.63 Contractual Services 6,820,106.00 2,000.00 6,822,106.00 555,757.93 430,368.25 555,757.93 5,835,979.82 14 492,291.50 Utilities 254,847.00 .00 254,847.00 5,787.94 .00 5,787.94 249,059.06 2 4,985.93 Insurance 344,875.00 .00 344,875.00 28,756.35 .00 28,756.35 316,118.65 8 13,979.42 Commodities & Supplies 608,056.00 .00 608,056.00 19,086.75 42,455.53 19,086.75 546,513.72 10 13,277.34 Other Expenditures 11,000.00 .00 11,000.00 .00 .00 .00 11,000.00 0 .00 Building Improvements 10,000.00 .00 10,000.00 79.00 1,658.86 79.00 8,262.14 17 .00 Office Equipment 40,356.00 .00 40,356.00 .00 .00 .00 40,356.00 0 .00 Other Equipment 153,614.00 (2,000.00) 151,614.00 914.75 5,611.89 914.75 145,087.36 4 2,252.33 Distribution Systems 95,000.00 .00 95,000.00 .00 .00 .00 95,000.00 0 .00 Infrastructure 506,390.00 .00 506,390.00 495.00 140,600.00 495.00 365,295.00 28 440.00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $ 44,321,998.00 $0.00 $44,321,998.00 $2,649,372.65 $639,829.18 $2,649,372.65 541,0312,796.17 7% $1,917,777.80 Fund 001- General Fund Totals $44,321,998.00 ($0 =00) $44,321,998.00 $2,649,372.65 $639,829.18 $2,649,372.65 $41,032,796.17 $1,917,777.80 N Expense Budget by Account Classification Report Account Classification Fund 002 - Debt Service Fund EXPENSE Contractual Services Other Expenditures Bond Principal Interest Expense Bank & Fiscal Fees Interfund Transfers Other Financing Uses Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD .00 .00 .00 .00 .00 .00 .00 + ++ .00 .00 .00 .00 .00 .00 .00 .00 ... .00 1,512,311.00 .00 1,512,311.00 19, 000.64 .00 19, 000.64 1,493, 310.36 1 18,377.95 891,882.00 .00 891,882.00 643.78 .00 643.78 891,238.22 0 1,266.47 1,284.00 .00 1,284.00 .00 .00 .00 1,284.00 0 1,409.22 .00 .00 .00 .00 .00 .00 .00 + ++ .00 .00 .00 .00 .00 .0 .00 . + ++ .00 EXPENSE TOTALS $2,405,477.00 $0.00 $2, $19,644.42 $0.00 $19, $2,385,832.38 1% $ 21,053.64 Fund 002 - Debt Service Fund Totals $2,405,477.00 ($0.00) $2,405,477.00 $19,644.42 ($0.00) $19,644.42 $2,385,832.58 $21,053.64 Expense Budget by Account Classification Report Account Classification Fund 020 -Capital Improvement Fund EXPENSE Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services .00 .00 .00 6,849.33 (347.01) 6,849.33 (6,502.32) + ++ 3,250.00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 + ++ .00 Land Improvements .00 .00 .00 .00 .00 .00 .00 + ++ .00 Building Improvements 915,500.00 .00 915,500.00 778.04 47,850.00 778.04 866,871.96 5 82,645..00 Office Equipment .00 .00 .00 .00 .00 .00 .00 + ++ .00 Motor Equipment .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Equipment 389,247.00 .00 389,247.00 10,603.91 .00 10,60191 378,643.09 3 .00 Infrastructure 370,000.00 .00 370,000.00 .00 19,974.00 .00 350,026.00 5 .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $1,674,747.00 $ $1,674,747.00 $18,231.28 $67,476.99 $18,231.28 $1,589,038.73 5% $85,895.00 Fund 020 - Capital Improvement Fund Totals $1,674,747.00 ($100) $1,674,747.00 $18,231.28 $67,476.99 $18,231.28 $1,589,038.73 $85,895.00 w ,n Acc Classification Fund 021 - Series 2009 Construction Fund EXPENSE Expense Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Contractual Services 00 .00 .00 .00 .00 .00 .00 + ++ .00 Building Improvements .00 .00 .00 .00 .00 .00 .00 + ++ .00 Office Equipment .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Equipment ,00 .00 .00 .00 .00 . . 00 + ++ .00 EXPENSE TOTALS $ $0.00 $ $ 0.00 $ 0.00 $0.00 $0.00 +++ $0.00 Fund 021 - Series 2009 Construction Fund Totals ($0,00) ($0,00) ($0.00) ($0.00) ($0.00) ($0.00) ($0.00) ($0.00 Expense Budget by Account Classification Report Account Classification Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transacti Transactions Rec'd Prior Year YTD Fund 022 - Downtown Redevelopment Construct EXPENSE Contractual Services 202,990.00 .00 202,990.00 .00 .00 .00 202,990.00 0 .00 Utilities .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Expenditures 2,741,531.00 .00 2,741,531.00 .00 .00 .00 2,741,531.00 0 .00 Infrastructure 348,000.00 .00 348,000.00 .00 .00 .00 348,000.00 0 .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 $3,292,521.00 $10 $ 3 , 292,521.00 $0.00 $0.00 $0.00 $3,292,521.00 0% $0.00 Fund 022 - Downtown Redevelopment Construct Totals $3,292,521.00 ($0.00) $3,292,521.00 ($0.00) ($0.00) ($0.00) $3,292,521.00 ($0.00) ur R17 Account Classifica Fund 023 - Street improvement Construc Fund EXPENSE Expense Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services 30,000.00 .00 30,000.00 .00 .00 100 1 30,000.00 0 ,00 Infrastructure 1,465,500.00 .00 1,465,500.00 .00 3,968.19 .00 1,461,531.81 0 .00 Interfund Transfers .00 .00 .00 .00 . 00 .00 .0 0 + ++ -00 EXPENSE TOTALS $1,495,500.00 $0.00 $1,495,500.00 $0.00 $3,968.19 $ $1, 0% $0.00 Fund 023 - Street Improvement Construc Fund Totals $1,495,500.00 ($0.00) $1,495,500.00 ($0.00) $3,968.19 ($0.00) $1,491,531.81 ($0.00) 0 o S a o + t + + O O O O "D O O O O O O O O O ti � N 111 Cl O R O R O 0 C. 0 0 01 ID 0 0000 O O O o 0 O --L O N Ill c' n O O O O O O O O O O 0 00 0 0 C. CD N Ln O ul n V C 3 �w O' O O V O m V N U C 7 V O a+ C O v 0 M � O u ;> 0 \ 0 m . 0 \ V CL Q /� V N U N O W O 7 W L d C III�� L�}-� t V pi C V um V N_ ° N LL o L t 0 c 0 L a m � V V V a E W C o O G cm U ~ N w N 01 c Q C U/ m O C V M E GJ U w ' C a a x W W v 0 y 0 a m, 0 o S a o + t + + O O O O "D O O O O O O O O O ti � N 111 Cl O R O R O 0 C. 0 0 01 ID 0 0000 O O O o 0 O --L O N Ill c' n O O O O O O O O O O 0 00 0 0 C. CD N Ln O ul n V C 3 �w O' O O V O m V N U C 7 V O a+ C O v 0 O u ;> c t Y C E N W w T Q y N U N O W W 7 W L d C (n V O O 9 H V C N IL Z LU = W 7 r- r- 0 V O L O U O O LL N O v c IL 7 00 Account Classification Expense Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 040 - Refuse Disposal Fund EXPENSE Personal Services, Scheduled Salaries & Wages 230,728.00 .00 230,728.00 15,658.19 .00 15,658.19 215,069.81 7 8,398.06 Employee Benefits 91,728.00 .00 91,728.00 6,699.03 .00 6,699.03 85,028.97 7 4,612.28 Other Employee Costs 1,200.00 .00 1,200.00 .00 .00 .00 1,200.00 0 .00 Contractual Services 4,092,058.00 .00 4,092,058.00 216,945.65 .00 216,945.65 3,875,112.35 5 195,281.66 Utilities 429.00 .00 429.00 15.08 .00 15.08 413.92 4 20.30 Insurance 28,239.00 .00 28,239.00 2,353.25 .00 2,353.25 25,885.75 8 2,277.58 Commodities & Supplies 30,387.00 .00 30,387.00 631.70 .00 631.70 29,755.30 2 299.00 EXPENSE TOTALS $4,474,769.00 $ $4,474,769.00 $242,302.90 $0.00 $242,302.90 $4,232,466.10 5% $21 Fund 040 - Refuse Disposal Fund Totals $4,474,769.00 ($0.00) $4,474,769.00 $242,302.90 ($0.00) $242,302.90 $4,232,466.10 $210,888.88 Expense Budget by Account Classification Report Account Classification Fund 041 - Motor Fuel Tax EXPENSE Contractual Services Utilities Commodities & Supplies Infrastructure Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD 186,302.00 .00 186,302.00 .00 33,794.00 .00 152,508.00 18 ..00 150,000.00 .00 150,000.00 .00 .00 .00 150,000.00 0 .00 263,064.00 .00 263,064.00 .00 131,850.00 100 131,214.00 50 35,234.74 1,165,000.00 .00 1,165,000.00 .00 .00 .00 1,165,000.00 0 .00 EXPENSE TOTALS $ 1, 7 6 4, 366.00 $0.00 $1,764,366.00 $0.00 $165,644.00 $0.00 $1,598,722.00 9% $35,234.74 Fund 041- Motor Fuel Tax Fund Totals $1,764,366.00 ($0.00) $1,764,366.00 ($0.00) $165,644.00 ($0.00) $1,598,722.00 $35,234.74 r 0 Account Classification Fund 042 - Cmmty Development Block Grant EXPENSE Expense Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Personal Services, Scheduled Salaries & Wages 47,094.00 .00 47,094.00 2,893.45 .00 2,893.45 44,200.55 6 2,288.48 Employee Benefits 25,198.00 100 25,198.00 1,932.57 .00 1,932.57 23,265.43 8 1,914.25 Other Employee Costs 1,000.00 ,00 1,000.00 ,00 .00 .00 1,000.00 0 .00 Contractual Services 92,411.00 .00 92,411.00 963.36 .00 963.36 91,447.64 1 1,877.17 Commodities & Supplies 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Other Expenditures 94,000.00 .00 94,000.00 .00 .00 .00 94,000.00 0 .00 Land Improvements .00 .00 .00 .00 .00 .00 .00 ... .00 Building Improvements .00 .00 .00 .00 .00 .00 .00 ... .00 Infrastructure 30,000.00 .00 30,000.00 .00 .00 .00 30,000.00 0 .00 EXPENSE TOTALS $290,203.00 $0.00 $290,203.00 $5,789.38 $0.00 $5,789.3 $284,413.62 2% $6,079.90 Fund 042 - Cmmty Development Block Grant Totals $290,203.00 ($0.00) $290,203.00 $5,789.38 ($0.00) $5,789.38 $284,413.62 $6,079.90 Expense Budget by Account Classification Report Account Classification Fund 043 - Asset Seizure Fund EXPENSE Other Employee Costs Contractual Services Other Equipment Through 01/31/13 Prior Fiscal Year Activity Included 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 1,500.00 .00 1,500.00 .00 .00 .00 1,500.00 0 .00 15,000.00 .00 15,000.00 3,915.00 .00 3,915.00 11,085.00 26 4,059.60 EXPENSE TOTALS $1 7,50 0. 00 $0. $17, $3,915.00 $0.00 $3,915.00 $13,585.00 22% $4,059.60 Fund 043 - Asset Seizure Fund Totals $17,500.00 00.00) $17,500.00 $3,915.00 ($0.00) $3,915.00 $13,585.00 $4,059.60 F1 F- r N Account Class Fund 044 - DEA Shared Funds Fund EXPENSE Expense Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services 1,000.00 ..00 1,000.00 .00 .00 .00 1,000.00 0 .00 Bullding Improvements .00 ,00 .00 .00 .00 .00 .00 + ++ .00 Other Equipment 4,000.00 >00 4,0 .00 . . 00 4,000.00 0 .00 EXPENSE TOTALS $5,000.0 $0.00 $ $ $ 0.00 $ 0.00 $ 5,000.00 0% $0.00 Fund 044 - DEA Shared Funds Fund Totals $5,000.00 ($0.00) $5,000.00 ($0.00) ($0.00) ($0.00) $5,000.00 ($0.00) Expense Budget by Account Classification Report Account Classlfication Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 01/31/13 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Recd Prior Year YTD Fund 045 - DUI Fine Fund EXPENSE Other Employee Costs Contractual Services Other Equipment Interfund Transfers 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 .00 .00 .00 .00 .00 .00 .00 + ++ .00 10,000.00 .00 10,000.00 .00 .00 .00 10,000.00 0 1,744.00 .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $11,000.00 $0.00 $11,000.00 $0.00 $0.00 $0.00 $11,000.00 0% $1,744.00 Fund 045 - DUI Fine Fund Totals $11,000.00 ($0.00) $11,000.00 ($0.00) ($0.00) ($0.00) $11,000.00 $1,744.00 r w Account Classiflcation Expense Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 046 - Foreign Fire Tax Board Fund EXPENSE Contractual Services 10,000.00 .00 10,000.00 2,743.44 .00 2,74144 7,256.56 27 1,974.26 Insurance 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Commodities & Supplies 3,000.00 .00 3,000.00 .00 .00 .00 3,000.00 0 .00 Other Equipment 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 .00 EXPENSE TOTALS $28,500.00 $0.00 $28,500.00 $2,743.44 $0.00 $2,743.44 $25,756.56 10% $1,974.26 Fund 046 - Foreign Fire Tax Board Fund Totals $28,500.00 ($0.00) $28,500.00 $2,743.44 ($0.00) $2,743.44 $25,756.56 $1,974.26 Expense Budget by Account Classification I.- U1 Report up, Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Cla Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 047 - Justice Assistance Grant Fund EXPENSE Commodities & Supplies .00 .00 .00 .00 ,00 .00 .00 + ++ .00 Other Expenditures .00 .00 00 .00 .00 .00 .00 + ++ .00 Office Equipment .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Equipment .00 .00 .00 .00 .00 .00 .00 + ++ .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $0.00 $0.00 $0,00 $0.00 $0.00 $0.00 $0.00 + ++ $0.00 Fund 047 - Justice Assistance Grant Fund Totals ($0.00) ($0.00) ($0.00) ($0.00) ($0.00) ($0.00) ($0.00) ($0.00) I.- U1 rn Account Classification Fund 048 - Business District Fund EXPENSE Expense Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Bond Principal .00 .00 .00 .00 A0 .00 .00 ... .00 Interest Expense 496,521.00 .00 496,521.00 .00 .00 .00 496,521.00 0 .00 EXPENSE TOTALS $496,521.00 $0.00 $496,521.00 $0.00 $0.00 $0.00 $496,521.00 0% $0.00 Fund 048 - Business District Fund Totals $496,521.00 ($0.00) $496,521.00 ($0.00) ($0.00) ($0.00) $496,521.00 ($0.00) Expense Budget by Account Classification r J Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD F=und 050 -Water and Sewer Fund EXPENSE Personal Services, Scheduled Salaries & Wages 1,864,275.00 .00 1,864,275.00 129,197.46 .00 129,197.46 1,735,077.54 7 68,486.69 Employee Benefits 734,286.00 .00 734,286.00 56,260.06 .00 56,260.06 678,025.94 8 57,589.62 Other Employee Costs 35,941.00 .00 35,941.00 103.00 .00 103.00 35,838.00 0 5,100.00 Contractual Services 7,331,906.00 .00 7,331,906.00 478,362.19 279,500.79 478,362.19 6,574,043.02 10 113,729.64 Utilities 168,560.00 .00 168,560.00 1,776.58 .00 1,776.58 166,783.42 1 2,754.39 Insurance 79,383.00 .00 79,383.00 6,615.25 .00 6,615.25 72,767.75 8 5,841.50 Commodities & Supplies 297,963.00 .00 297,963.00 3,200.61 28,048.72 3,200.61 266,713.67 10 1,308.48 Other Expenditures .00 .00 .00 .00 .00 .00 100 + ++ .00 Office Equipment 7,104.00 .00 7,104.00 .00 .00 .00 7,104.00 0 .00 Other Equipment 464,503.00 .00 464,503.00 .00 11,807.52 .00 452,695.48 3 .00 Distribution Systems 1,825,000.00 .00 1,825,000.00 .00 208,917.56 .00 1,616,082.44 11 .00 Infrastructure 34,000.00 .00 34,000.00 .00 .00 .00 34,000.00 0 .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 $12,842,921.00 $0.00 $12,842,921.00 $675,515.15 $528,274.59 $675,515.15 $11,639,131.26 9% $254,810.32 Fund 050 -Water and Sewer Fund Totals $12,842,921.00 ($0.00) $12,842,921.00 $675,515.15 $528,274.59 $675,515.15 $11,639,131.26 $254,810.32 r J r 00 Account Classification Expense Budget by Account classification ' -1 Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 01/31/13 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Recd Prior Year YTD Fund 051 - Village Parking System Fund EXPENSE Personal Services, Scheduled Salaries & Wages 21,875.00 .00 21,875.00 1,516.01 .00 1,516.01 20,358.99 7 808.79 Employee Benefits 9,860.00 .00 9,860.00 667.83 .00 667.83 9,192.17 7 371.56 Contractual Services 92,657.00 .00 92,657.00 11,343.55 20,605,71 11,343.55 60,707.74 34 4,377.00 Insurance 1,158.00 .00 1,158.00 96.50 .00 96.50 1,061.50 8 67.67 Commodities & Supplies 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 ... .00 Building Improvements 6,800.00 .00 6,800.00 .00 .00 .00 6,800.00 0 .00 Infrastructure 163,500.00 .00 163,500.00 .00 5,000..00 .00 158,500.00 3 .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $296,350.00 $0.00 $296,350.00 $13,623.89 $25,605.71 $13,623.89 $257,120.40 13% $5,625.02 Fund 051- Village Parking System Fund Totals $296,350.00 ($0.00) $296,350.00 $13,623.89 $25,605.71 $13,623.89 $257,120.40 $5,625.02 Expense Budget by Account Classification r %D Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Ac Cl assification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 052 - Parking Sim Revenue Fund - EXPENSE Personal Services, Scheduled Salaries & Wages 41,661.00 .00 41,661.00 2,985.27 .00 2,985.27 38,675.73 7 1,678.91 Employee Benefits 21,357.00 .00 21,357.00 1,574.75 .00 1,574.75 19,782.25 7 1,133.15 Contractual Services 110,944.00 .00 110,944.00 9,295.58 2,934.59 9,295.58 98,713.83 it 3,018.66 Utilities 10,317.00 .00 10,317.00 75.94 .00 75.94 10,241.06 1 .00 Insurance 1,387.00 .00 1,387.00 115.58 .00 115.58 1,271.42 8 94.83 Commodities & Supplies 9,586.00 .00 9,586.00 .00 1,700.00 .00 7,886.00 18 156.60 Other Expenditures .00 .00 .00 .00 .00 .00 .00 + ++ .00 Building Improvements 100,000.00 .00 100,000.00 .00 .00 .00 100,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 $ 295,252.00 $0 <00 x295,252.00 $14,047.12 $4,634.59 $14,047.12 $276,57029 60 $6,082.15 Fund 052 - Parking System Revenue Fund Totals $295,252.00 ($0.00) $295,252.00 $14,047.12 $4,634.59 $14,047.12 $276,57129 $6,082.15 r %D N O Account Classification Fund 060 - Vehicle Maintenance Fund EXPENSE Expense Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included 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 954,042.00 .00 954,042.00 56,476.34 ,00 56,476.34 897,565.66 6 35,620.43 Employee Benefits 392,115.00 .00 392,115.00 24,895.61 .00 24,895.61 367,219.39 6 21,006.69 Other Employee Costs 2,315.00 .00 2,315.00 .00 .00 .00 2,315.00 0 .00 Contractual Services 95,738.00 .00 95,738.00 1,305.14 21,748.00 1,305.14 72,684.86 24 1,100.63 Utilities 3,010.00 .00 3,010.00 37.71 .00 37.71 2,972.29 1 50.74 Commodities & Supplies 687,039.00 .00 687,039.00 49,411.19 603,597.04 49,411.19 34,030.77 95 45,773.63 Other Expenditures .00 .00 .00 .00 .00 .00 .00 + ++ .00 OfFlce Equipment 545.00 .00 545.00 .00 .00 .00 545.00 0 .00 Other Equipment 18,500.00 .00 18, 500.00 . 00 .00 .00 18,500.00 0 483.50 EXPENSE TOTALS $2,1 $0.00 $2,1 $ 13 2,1 25.99 $625,3 $ 132,12 5.99 $1,395,832,97 35% $104,035.62 Fund 060 - Vehicle Maintenance Fund Totals $2,153,304.00 ($0.00) $2,153,304.00 $132 $625,345.04 $132,125.99 $1,395,832.97 $104,035.62 Expense Budget by Account Classification Report Account Classification Fund 061- Vehicle Replacement Fund EXPENSE Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Other Expenditures .00 .00 .00 00 .00 .00 .00 +++ 00 Motor Equipment 664,000.00 .00 664,000.00 1,456.56 149,890.00 1,456.56 512,653.44 23 1,471.00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $664,000.00 $0.00 $664,000.00 $1,456.56 $149,890.00 $1,456.56 $512,653.44 23% $1,471.00 Fund 061- Vehicle Replacement Fund Totals $664,000.00 ($0.00) $664,000.00 $1,456.56 $149,890.00 $1,456.56 $512,653.44 $1,471.00 N r NO Expense Budget by Account Classification Report Account Classlficatlon Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 01/31/13 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Recd Prior Year YTD Fund 062 - Computer Replacement Fund EXPENSE Other Expenditures =00 .00 .00 .00 .00 .00 .00 + ++ .00 Office Equipment 246,200.00 .00 246,200.00 734.65 23,232.22 734.65 222,233.13 10 .00 EXPENSE TOTALS $246,200.00 $0.00 $246,200.00 $734.65 $23,232.22 $734.65 $222,233.13 10 % $0.00 Fund 062 - Computer Replacement Fund Totals $246,200.00 ($0.00) $246,200.00 $734.65 $23,232.22 $734.65 $222,233.13 ($0.00) Expense Budget by Account Classification Report Account Classification Fund 063 - Risk Management Fund EXPENSE Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Contractual Services 22,500.00 .00 22,500.00 950.00 .00 950.00 21,550.00 4 .00 Insurance 7,641,862.00 .00 7,641,862.00 850,210.08 .00 850,210.08 6,791,651.92 11 681,544.73 Other Equipment 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 .00 Infrastructure .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $7,666,362.00 $0.00 $7,666,362.00 $851,160.08 $0.00 $851,160.08 $6,815,201.92 11 %_ $681,544.73 Fund 063 - Risk Management Fund Totals $7,666,362.00 ($0.00) $7,666,362.00 $851,160.08 ($0.00) $851,160.48 $6,815,201.52 $681,5 N W N P Account Classification Expense Budget by Account Classification Report Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 070 - Police Pension Fund EXPENSE Pension Benefits 3,847,666.00 .00 3,847,666.00 317,904.71 .00 317,904.71 3,529,761.29 8 303,719.35 Contractual Services 121,250.00 .00 121,250.00 1,903.76 .00 1,903.76 119,346.24 2 10,363..15 Insurance 12,000.00 .00 12,000.00 .00 .00 .00 12,000.00 0 .00 Commodities & Supplies 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 Other Expenditures 12,000.00 .00 12,000.00 225.00 .00 225.00 11,775.00 2 750.00 Office Equipment .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $3,993,416.00 $0.00 $3, $320,033.47 $0.00 $320,0 $3,673,382.53 8% $314,8 Fund 070 - Police Pension Fund Totals $3,993,416.00 ($0.00) $3,993,416.00 $320,033.47 ($0.00) $320,033.47 $3,673,382.53 $314,832.50 Expense Budget by Account Classification Report A cco u n t C lassification Fund 071- Fire Pension Fund EXPENSE Pension Benefits Contractual Services Insurance Commodities & Supplies Other Expenditures Through 01/31/13 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD 3,799,991.00 .00 3,799,991.00 320,361.84 .00 320,361.84 3,479,629.16 8 303,586.29 124,500.00 .00 124,500.00 1,905.77 .00 1,905.77 122,594.23 2 10,061.63 11,500.00 .00 11,500.00 .00 .00 .00 11,500.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 295.00 .00 295.00 11,705.00 2 .00 EXPENSE TOTALS $3,948,991.00 $0.00 $3,948,991.00 $322,562.61 $0.00 $322,562.61 $3,626,428.39 8% $313,647.92 Fund 071- Fire Pension Fund Totals $3,948,991.00 ($0.00) $3,948,991.00 $322,562.61 ($0.00) $322,562.61 53,626,428.35 $313,647.92 Grand Totals $93,142.04&00 00.00) $93,142,048.00 $5,273,258.59 $2,342,970.45 $5,273,258.59 $85,525,818.96 $3,066,757.08 N Un Fund Vendor Name 001 General Fund ACS State & Local Government Solutions Addison Building Material Co. ADT Security Services, Inc. AEC Fire Safety Security Airgas, Inc. Alexian Brothers Medical Center Ali, Alyssa Alpha Terra Science Inc Amer Reprographics Co Llc American Messaging Anderson Lock Company Anderson Pest Solutions Andres Medical Billing, Ltd. Aramark Uniform Services, Inc. ASCE AT &T Avanti Cafe & Sandwich Bar, Inc. B & H Industries 8 & H Photo /video Barnett, Lesley Bedco Mechanical Beyer, Andrew Bolin, Julie A. Bran, Victoria A. Bright Electrical Supply Co. Brown, Donna Busse's Flowers & Gifts Carlson, David J Case Lots, Inc. CBS Awards CDS Office Technologies Century Cleaners VILLAGE OF MOUNT PROSPECT List of Bills January 31- February 13, 2013 Invoice Illinois State Disbursement Unit Illinois State Disbursement Unit Sewer & Basin Maintenance Supplies Maintenance and repair supplies Furniture Replacement Parts Qtly pmnt for equip rental & maint of the Police /Fire security Maintenance of Holmatro Rescue Tools Oxygen Tank Supplies Professional Services Annual Audiograms Annual Audiograms Freelance on camera talent Freelance on air talent Training Equipment Maintenance KIP Maintenance Equipment Maintenance Pager Service Maintenance Repair & Supplies Pest Control Services Ambulance Billing - January 2013 Ambulance Billing- November 2012 Cleaning and rental for uniforms for all public works employees Cleaning and rental for uniforms for all public works employees Uniform cleaning and rental for all public works employees Rental and uniform cleaning for all Public Works employees Membership Dues AT & T Long Distance Service 12/1/12 - 12/31/12 Service 1/16/13 - 2/15/13 Service 1/16/13 - 2/15/13 BOFPC testing expenses Special Events Supplies D -Tap extension Cable Audio Transmitter Wide angle Lens for Boardroom Camera Reimburse training expenses Bi- monthly HVAC checks and services for 8 Public Buildings Building Maintenance and Repair Repairs to Public Works rooftop heat unit #2 Temporary repairs made to HVAC rooftop unit at PW CDL Reimbursement Special Event Supplies Reimburse Victoria Bran for Basic Supervision class Fluorescent lamps and bulbs to used in all buildings Fluorescent bulbs to be used in all buildings Maintenance and repairsupplies Training Expenses Sympathy Arrangement Professional Services Professional Services Professional Services Sympathy Arrangement 1/19/13 Steinmiller Sympathy Reimburse training expenses Custodial supplies to be used in all buildings Custodial Supplies 2013 Celestial supplies Special Events Commission 2012 Officer of the Year plaques Office Supplies Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Page 1 of 12 Amount 3,379.60 3,379.60 21.54 27.91 91.20 3,243.33 659.50 258.02 21.00 462.00 42.00 300.00 150.00 239.68 62.00 62.00 62.00 484.66 155.72 48.00 6,011.20 5,571.06 108.89 108.89 108.89 108.89 255.00 1,354.35 690.99 341.04 137.01 213.15 67.95 328.90 299.00 24.00 2,033.32 383.15 550.00 275.00 30.00 21.30 127.00 1,280.30 144.50 272.05 20.00 85.00 80.00 80.00 68.50 80.00 80.00 24.00 1,112.09 255.80 822.00 140.00 255.00 187.00 3.73 17.13 160.00 16.40 2.73 22.25 11.18 14.90 VILLAGE OF MOUNT PROSPECT List of Bills January 31- February 13, 2013 Fund Vendor Name Invoice Description Amount Uniform Cleaning 11.18 Uniform Cleaning 28.93 Uniform Cleaning 22.25 Chicago Comm. Service, Inc. Radio maintenance agreement - March, 2013 641.10 Chicago Office Technology Group 2013 Toshiba Copier Staples 118.00 Childrens Advocacy Center of Illinois Registration for J. Kane for training conference 199.00 Register M. Landeweer for training conference 199.00 Clark, Sandra M. Travel Expenses 48.00 Meeting Expenses 65.00 Clifford -Wald & Co., Inc. - A KIP Company Engineering Supplies 300.59 Comcast Xfinity Internet 66.00 Commonwealth Edison Electrical Service Delivery 25.94 Electrical Service Delivery 15.75 Electrical Service Delivery 25.78 Electrical Service Delivery 25.78 Community College District 502 Basic Recruit Academy: D. Gryzik 2,984.00 Constellation NewEnergy, Inc. Electrical Service Delivery 309.17 Electrical Service Delivery 180.99 Electrical Service Delivery 152.72 Electrical Service Delivery 384.84 Electrical Service Delivery 163.56 Electrical Service Delivery 196.23 Electrical Service Delivery 212.83 Electrical Service Delivery 135.54 Electrical Service Delivery 95.59 Electrical Service Delivery 304.15 Electrical Service Delivery 169.97 Electrical Service Delivery 3,628.91 Electrical Service Delivery 197.96 Electrical Service Delivery 235.29 Cook County Recorder of Deeds Recording 2012 budget 80.00 Costco Wholesale Costco Purchase 12/27/12 & 12/28/12 99.18 Costco Purchase 1/7/13 - 1/24/13 697.30 Crain Communications Inc. 2013 Crain Subscription Renewal - Cooney 119.00 Professional Services 49.00 Crystal Court Shopping Center Rent for the CCC for February 5,447.00 Crystal Maintenance Services Corp. Building cleaning services in 9 buildings forthe month of Jan. 6,432.96 Building cleaning services in 9 buildings for the month of Feb 6,432.96 Cleaning for the month at 1711 Algonquin for January 205.06 Cleaning bill for the Open House cleaning at the CCC 224.05 Custom Design and Tent Service, Inc. Special Event Supplies 42.00 Dash Medical Gloves Disposable gloves 359.40 Data Media Products, Inc. Compact Discs 89.00 Defranco Plumbing Equipment Maintenance and Repair 397.00 Dennison Leafblad, Deborah Camera for Shining Stars 150.00 Dolan, John Kitchen Ware 64.98 Dreisilker Electric Motors, Inc. Maintenance and repair supplies 159.04 Duncan Carpet Co., Inc. Maintenance and repair supplies 20.00 El Metennani, Maura Contract PIO work completed by Maura 3,480.00 Elite Remodeling Group, Inc. Garnishment 142.22 Enterprise Rent -a -car SIU vehicle rental 602.00 Everbank Commercial Finance, Inc. Copy Machines Usage 2/23/13 2,364.71 Copy Machine Usage 2/24/13 451.02 Experian Background checks - January, 2013 77.00 Federal Express Corp FEDEX - Service (3) Shipments 149.07 Vehicle sticker appl. from Fidelity on 1/15/13 6.90 Vehicle appl. from Fidelity rec'd. 1/22/13 7.25 Fire Pension Fund Fire Pension 21,332.85 Flory, James M Bed Covers 139.93 Gall's, Inc. Disposable emergency blankets 543.99 Garelli Wong & Associates, Inc. Julie DeMaria wk. ending 1/20/13 132.30 Garvey's Office Products Office Supplies 38.95 Gary J. Klein Special Events - Celestial Celebration 1,250.00 GE Capital Period 1/15113 - 2/14/13 853.11 Gerlach, Lillian Refund Street Opening Fee 100.00 Grainger Inc. Special Event Supplies 144.83 Clocks Administration and Fire Prevention Bureau 124.50 Special Events Supplies 62.07 Grant Mangement USA Register T. Griffin for training course 595.00 Page 2 of 12 VILLAGE OF MOUNT PROSPECT List of Bills January 31- February 13, 2013 Fund Vendor Name Invoice Description Amount Grant Writing USA Register T. Griffin for training course 425.00 Great Lakes Snow Systems, Inc. January base contract payment for section snow removal contract 6,625.00 Final retainer for cul -de -sac snow removal contract 2012 -13 4,000.00 Payment for snow and ice control removal contract 6,625.00 Guardian Emp. Dental Plan February 2013 8,802.37 Hastings Air Energy Control Inc. Plymovent Repair- Grabber Assembly 278.93 Hauser, Frank & Barbara Rebate Transfer Stamp 438.00 Healy Asphalt Company,llc. Asphalt patching materials used for street patching 1,072.64 Cold mix asphalt used for street patching 2,114.56 Heinking, Jill Reimburse Jill for gloves forthe Medical Reserve Corp 29.50 Home Depot U.S.A., Inc. Station Maintenance Equipment & Supplies 762.18 Station Maintenance Equipment & Supplies 201.77 IAFSM Training Expenses 330.00 ICMA RHS Sick 24 32,978.79 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 16,913.69 ICMA 457 (flat percent) 18,074.87 Illinois American Water Company Private Fire Service 2/1/13 33.84 Illinois Assoc of Technical Accident Investigators 2013 Membership Renewal - M. Eterno 45.00 2013 Membership Renewal - M. Jolie 45.00 2013 Membership Renewal - M. Evans 45.00 2013 Membership Renewal - B. Tweedie 45.00 2013 Membership Renewal - G. Sill 45.00 Illinois Department of Revenue IL State Withholding 55.17 IL State Withholding 35,796.63 IL State Withholding 36,669.79 Illinois Environmental Health Assc. 2013 Membership Renewal - Roels 45.00 2013 Membership Renewal - Krupa 45.00 Illinois NATOA Illinois NATOA Membership 75.00 Illinois State Toll Hwy Authority Indiana toll charges 1.19 Period 10/1/12 - 12/31/12 83.65 IMRF IMRF 207,873.00 Industrial Systems, Ltd Atanker load ofThermapoint beetjuice de- icingfluid 3,916.00 Internal Revenue Service Federal Withholding 426.82 Federal Withholding 167,840.28 Federal Withholding 178,944.08 Intoximeters, Inc. Breathalyzer supplies 131.95 Janonis, Kathy 2013 Celestial supplies 54.20 Celestial supplies 21.77 Jarzab, Steven & Wioletta Rebate Transfer Stamp 760.00 Kerstein, June Reimbursement January 2013 Food Expense 21.67 Klein, Thorpe and Jenkins, Ltd. September 2012 68,541.53 October 2012 billing 45,225.39 2012 December billing 57,502.59 Kone, Inc. Monthly maintenance to the elevator at Fire Station 14 for Jan 300.58 K -Plus Engineering, L-C. Professional Services 3,003.85 Kroll, Bill Other Equipment 9.81 Kuhn, Keith Travel Expenses 14.00 Laner Muchin August & December 2012 billing 2,105.26 Lexisnexis Risk Data Management Inc. Background checks - January, 2013 204.55 Malcolm, John Ad/ Ambulance for Sale 90.00 McVeigh- Cushing, Cathleen A. Edit Library Life 500.00 Menards Maintenance and Repair Supplies 19.69 Maintenance and repair supplies 9.46 Meridian It Inc. Network Support 175.00 Metro Federal Credit Union MP Fire Local 4119 Dues 2,278.82 Michael Wagner & Sons, Inc. Maintenance and repair supplies 254.95 Mickus, William & Tracy Rebate Transfer Stamp 720.00 Micro Tech Systems, Inc. Equipment Maintenance and Repair 486.20 Mieczkowski, Daniel Refund Overpayment Police Ticket# P3923064 50.00 Mobile Print Inc. Celestial programs 161.00 Mt. Prospect Downtown Merchants Assoc. 2013 DMA Membership Dues 1,000.00 Mueller, Melissa Rebate Transfer Stamp 718.00 Municipal Emergency Services, Inc. Streamlight Batteries 106.43 Murray and Trettel Inc. Weather service warnings & certified site specific reports /2013 2,350.00 Weather forecasting fee for weekend outlooks 2013 200.00 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 13,072.70 Nationwide 457 (flat percent) 13,084.66 NATOA Membership to NATOA 565.00 NCPERS Group Life Ins. IMRF Life Insurance 667.20 Page 3 of 12 VILLAGE OF MOUNT PROSPECT List of Bills January 31 - February 13, 2013 Fund Vendor Name Invoice Description Amount New World Systems Corporation Escrow Billings 1,157.00 NICOR Natural Gas Consumption 40.77 Natural Gas Consumption 76.73 Natural Gas Consumption 118.58 North East Multi Regional Trng Course registration for.]. Garris 50.00 Course registration for J. Garris 50.00 Northern Illinois Funeral Service Inc. Removal services 300.00 Remains removal 375.00 Remains removal: Haughey (1434 S. Busse Rd. #1B) 420.00 Northern Illinois Police Alarm System 2013 Membership assessment 400.00 2013 Emergency Services Team Assessment 3,300.00 2013 Mobile Field Force Assessment 935.00 Northwest Central Dispatch System March 2013 - Member Assessment 49,679.40 Northwest Community Hospital Annual Exam/ 2012 5,121.00 2012 - Annual Exam 323.00 Northwest Suburban United Way United Way 252.10 Northwestern University Registration for Supervision of Police Personnel 900.00 Oshtemo Auto Refund Overpayment Police Ticket # P3922575 30.00 Otis Elevator Company Service contract 3 elevators; VH, Parking Garage & Fire /Police 11,089.54 Overhead Garage Door, Inc. Overhead door repair 1,440.19 Overhead door repair 837.00 Overhead door repair 119.89 Overhead door repair 166.17 P.F. Pettibone & Co. Other supplies 457.55 Paddock Publications, Inc. Bid Notice 45.90 Bid Notice 45.90 Bid Notice 43.20 Bid Notice 37.80 Bid Notice 37.80 Petty Cash Police Department Petty Cash 133.67 Police Department Petty Cash 97.77 Petty -Cash - Fire 101.59 Pierce, Victor Travel Expenses 14.00 Small Tools 32.31 Police Pension Fund Police Pension 29,006.30 Pomp's Tire Service, Inc. Streets Sweeper Supplies 351.33 Rayco Sign Supply Special Events Sign 137.50 Red Wing Shoe Store Safety Shoe Allowance 123.24 Reliable Equipment & Service Co. Other Equipment 269.03 Forestry Equipment 218.11 Ricmar Industries, Inc. Cleaning supplies used in all buildings 742.80 Ronco Industrial Supply Custodial Supplies 3,569.10 Sears Commercial One Account Maintenance and repair supplies 356.34 Secretary of State 2012 License Plate Sticker Renewal 101.00 Serendipity Band Band Appearance at 2013 Celestial Celebration 350.00 Setanta Publishing, LLC. 2013 Subscription Renewal - Roels 164.00 SIGMA Solutions, LP. VMware License Renewal 1,468.00 Skyline Publishing Company Professional Services 195.00 Soter, OmarS Celestial Celebration 150.00 Staples Contract & Commercial, Inc. Office Supplies & toner 360,37 Office Supplies 38.07 State of Illinois Internet Services 1,175.00 T.P.I. 2012 Building Inspections 21,632.00 2013 Building Inspections 23,295.50 Telvent Dtn, Inc. Annual pyt for Televent DTN weather system & equip rental 2013 7,944.00 The Dearborn Inn Lodging for training: Brady & Juhl 461.70 The Fitness Connection Co. Maintenance for fitness equipment 105.00 The Savanna Group, Inc. Professional Services 1,530.00 The T.L.C. Group LTD Grounds Maintenance Services 1,758.24 Third Millennium Assoc.inc. Annual Lockbox /Fulfillment Set Up Maint. 650.00 Vehicle Online System Maint. 2/7/13- 2/6/14 495.00 Vehicle Software Annual Maint. 2/7/13 - 2/6/14 995.00 Thompson Elevator Inspections 2012 Elevator Inspections 225.00 2012 Elevator Inspections 74.00 2012 Elevator Inspections 75.00 2012 Elevator Inspections 518.00 2013 Elevator Inspections 225.00 2013 Elevator Inspection 37.00 TKB Associates, Inc. 2013 Document Imaging Services 9,863.02 Page 4 of 12 VILLAGE OF MOUNT PROSPECT List of Bills January 31- February 13, 2013 Fund Vendor Name Invoice Description Amount TLO, LLC Background checks - January, 2013 112.25 Traffic and Parking Control Co, Inc. Sign posts used for sign replacement or repair 1,011.00 Tran, Michael Refund Overpayment Vehicle License 54.00 Truty, Chris J. Truty/ BOFPC - FF Interview Meals Jan 29 -30 81.63 Conference Room Electrical Connectors 116.84 Tweedie, Bart Reimburse training expenses 24.00 U.S. Bank Equipment Finance, Inc. Copy Machines - Usage 2/ 20/13 1,362.28 Usage 2/ 22/13 -1601 West Golf Road 138.78 United Parcel Service Shipping charges for equipment repairs 31.33 United States Postal Service PIO postage supplies 89.00 Verizon Wireless Services LLC Cellular Service Dec 20 - Jan 19 5,396.02 Victoria Group, Inc. Celestial Celebration 15,984.00 Wal -mart Stores, Inc. Membership Dues 35.00 Warehouse Direct Office Supplies 50.00 Office Supplies 435.30 Office Supplies 281.52 Office Supplies 135.27 Attorney supplies 330.19 Office Supplies 66.72 Office Supplies 818.04 Office Supplies 172.38 Office Supplies 236.71 Photo evidence supplies 131.52 Credit for returned merchandise 33.99 Wayne State University Register J. Juhl for Medicolegal Investigation of Death 495.00 Register M. Brady for Medicolegal Investigation of Death 495.00 White Way Sign & Maintenance Co. Equipment Maintenance and Repair 484.00 Wisconsin Department of Revenue WI State Withholding 669.16 WISCTF Garnishment 542.48 Wood, Michael Reimburse training expenses 24.00 001 General Fund Total $ 1,265,176.91 002 Debt Service Fund Bank of New York Mellon Annual Agency Fee 3/11/13 - 3/10/14 $ 428.00 002 Debt Service Fund Total $ 428.00 020 Capital Improvement Fund Baxter & Woodman, Inc. Detention Pond Improvement $ 4,712.50 Burns & Mcdonnell Engineering Co. Salt Storage Building 4,400.00 Business Office Systems, Inc. Replacement Furniture 17,392.55 EWS Consultants, Inc. Design /Consultation Services 760.00 Meranda Jr., Michael Labor costs for installation of Board Room Cameras 5,755.00 Mercury Partners 90 BI Inc. Building Maintenance 165.00 New World Systems Corporation Travel Expenses January 2013 2,630.77 Northwest Central 9 -1 -1 System Motorola Subscriber Financing - February 2013 10,603. 020 Capital Improvement Fund Total $ 46,419.73 022 Downtown Redevelopment Construction Fund Cook County Government 2012 First Installment Property Tax Bill $ 3,642.20 Northwest Properties LIc NWE Sales Tax Rebates 9/1/12 - 11/30/12 28,917.66 The T.L.C. Group LTD Grounds Maintenance Services 6,332.84 022 Downtown Redevelopment Construction Fund Total $ 38,892.70 023 Street Improvement Construction Fund Arrow Road Construction Streets Resurfacing $ 11,959.34 023 Street Improvement Construction Fund Total $ 11,959.34 024 Flood Control Construction Fund Constellation NewEnergy, Inc. Electrical Service Delivery $ 99.86 Electrical Service Delivery 96.4 024 Flood Control Construction Fund Total $ 196.35 040 Refuse Disposal Fund Alpha Terra Science Inc Training $ 18.15 American Future Systems, Inc. Subscription renewal 299.00 ARC Disposal Company Refuse Disposal Program 208,128.95 AT&T AT & T Long Distance Service 12/1/12 - 12/31/12 7.53 Service 1/16/13 - 2/15/13 3.84 Cylinders, Inc. Repair Maintenance Supplies 217.70 Page 5 of 12 VILLAGE OF MOUNT PROSPECT List of Bills January 31- February 13, 2013 Fund Vendor Name Invoice Description Amount Debris Disposal Services 1,108.49 Debris Disposal 594.61 RHS Sick 24 370.73 ICMA 457 (flat percent) 20.20 ICMA 457 (flat percent) 16.80 IL State Withholding 408.30 IL State Withholding 439.16 IMRF 4,537.88 Federal Withholding 2,768.06 Federal Withholding 3,108.99 Nationwide 457 (flat percent) 45.00 Nationwide 457 (flat percent) 44.99 IMRF Life Insurance 8.00 United Way 3.85 Groot Industries, Inc. ICMA ICMA Retirement Trust - 457 Illinois Department of Revenue IMRF Internal Revenue Service Nationwide Mutual Insurance Company NCPERS Group Life Ins. Northwest Suburban United Way 040 Refuse Disposal Fund Total 041 Motor Fuel Tax Fund Brown Traffic Products, Inc. Cook County Government Illinois State Treasurer Lyons & Pinner Electric Companies Meade Electric Co. Inc. Morton Salt, Inc 041 Motor Fuel Tax Fund Total 042 Community Development Block Grant Everbank Commercial Finance, Inc. GE Capital ICMA Retirement Trust - 457 Illinois Department of Revenue IMRF Internal Revenue Service Life-Span Quill Corporation T.P.I. 042 Community Development Block Grant Total 050 Water and Sewer Fund Addison Building Material Co. Alexian Brothers Medical Center Alpha Terra Science Inc American Waterworks Assoc. Aramark Uniform Services, Inc. Arthur Clesen, Inc. AT &T Baxter & Woodman, Inc. Burns & Mcdonnell Engineering Co. $ 222,150.23 Traffic Signal Device $ 694.00 Traffic Light Maintenance 3,152.25 Traffic Light Maintenance 6,719.70 Traffic Light Maintenance 920.00 Traffic Light Maintenance 244.73 Traffic Light Maintenance 367.10 Traffic Light Maintenance 367.10 Traffic Light Maintenance 115.59 Traffic Light Maintenance 360.32 Traffic Light Maintenance 482.69 Road salt used for de -icing roads 13,488.79 Road salt used for de -icing roads 2,585.31 Salt used for snow and ice control 7,108.82 Road salt used for snow and ice control 2,500.93 $ 39,107.33 Copy Machines Usage 2/23/13 $ 17.60 Period 1/15/13 - 2/14/13 213.27 ICMA 457 (flat percent) 112.50 ICMA 457 (flat percent) 112.51 IL State Withholding 71.53 IL State Withholding 65.63 IMRF 823.40 Federal Withholding 471.51 Federal Withholding 423.92 CDBG 4th Qtr Subrecipient 630.00 2013 Office Supplies 58.99 2013 Building Status Inspection 80.00 Uniform cleaning and rental for all public works employees $ 3,080.86 Building Maintenance and Repair $ 26.76 Building Maintenance and Repair (17.22) Building Maintenance and Repair 43.51 Building Maintenance and Repair 52.73 Building Maintenance and Repair 12.45 Water Meter Repair Parts 3.72 Annual Audiograms 462.00 Annual Audiograms 42.00 Training 1,692.17 Training Expenses 250.00 Cleaning and rental for uniforms for all public works employees 108.90 Cleaning and rental for uniforms for all public works employees 108.90 Uniform cleaning and rental for all public works employees 108.90 Rental and uniform cleaning for all Public Works employees 108.90 Grounds Maintenance Supplies 1,216.00 AT & T Long Distance Service 12/1/12 - 12/31/12 502.86 Service 1/16/13 - 2/15/13 256.59 Engineering Services 35,795.52 Professional Services 1,312.50 Professional Services 225.77 Page 6 of 12 VILLAGE OF MOUNT PROSPECT List of Bills January 31- February 13, 2013 Fund Vendor Name Invoice Description Amount Professional Services 1,732.67 Professional Services 855.95 Lift Station Rehab 492.58 Professional Services 4,331.36 Sewer Improvements 6,597.50 Professional Services 4,932.79 Uniform Cleaning 3.72 Uniform Cleaning 17.12 Uniform Cleaning 160.00 Uniform Cleaning 16.40 Uniform Cleaning 2.72 Uniform Cleaning 22.25 Uniform Cleaning 11.17 Uniform Cleaning 14.90 Uniform Cleaning 11.17 Uniform Cleaning 28.92 Uniform Cleaning 22.25 Electrical Service Delivery 9,058.88 Repair Maintenance Supplies 830.35 Shipping Charges 19.70 Shipping Charges 40.43 Repair Maintenance Supplies 725.17 Building Maintenance (18.17) Building Maintenance and Repair 151.88 Water Meter and Building Inspection Services 131.00 Water Meter and Building Inspection Services 131.00 Water Meter and Building Inspection Services 131.00 Water Meter and Building Inspection Services 165.00 Water Meter and Building Inspection Services 131.00 Water Meter and Building Inspection Services 200.00 Water Meter and Building Inspection Services 393.00 Water Meter and Building Inspection Services 393.00 Water Meter and Building Inspection Services 161.50 Water Meter and Building Inspection Services 374.92 RHS Sick 24 1,303.57 ICMA 457 (flat percent) 1,282.83 ICMA 457 (flat percent) 1,423.93 IL State Withholding 3,340.96 IL State Withholding 4,561.61 Maintenance Supplies 153.00 IMRF 36,899.45 Professional Services 1,387.50 Federal Withholding 21,148.09 Federal Withholding 31,506.09 Equipment Maintenance and Repair 535.20 Water Distribution Maintenance 6,804.72 Sewer System Main Repair 1,200.00 Building Maintenance and Repair 10.26 Emergency Repair 851.12 Nationwide 457 (flat percent) 358.88 Nationwide 457 (flat percent) 358.89 IMRF Life Insurance 57.60 Natural Gas Consumption 129.97 Natural Gas Consumption 28.12 Natural Gas Consumption 241.99 United Way 8.00 Training Expenses 555.20 Repair Maintenance Supplies 540.00 Excavation Restoration 34,421.06 Excavation Restoration 8,063.27 Repair Maintenance Supplies 12.36 Annual IEPA- Required Water Sample Testing 204.50 Annual IEPA- Required Water Sample Testing 262.00 Professional Services 1,765.00 Grounds Maintenance Services 1,797.80 Repair Maintenance Supplies 2,244.00 Copy Machines - Usage 2/ 20/13 137.50 Cellular Service Dec 20 -Jan 19 390.14 Sewer Improvements 257,348.85 Page 7 of 12 Century Cleaners Constellation NewEnergy, Inc. Dreisilker Electric Motors, Inc. Federal Express Corp Grainger Inc. HBK Water Meter Service ICMA ICMA Retirement Trust - 457 Illinois Department of Revenue Illinois Society of Professional Engineers IMRF Industrial Rehab Allies LLC Internal Revenue Service Jjs Global Ventures Inc Julie, Inc. K -Plus Engineering, LLC. Legend Electrical Sales LionHearL Engineering P.C. Nationwide Mutual Insurance Company NCPERS Group Life Ins. NICOR Northwest Suburban United Way Overeem, Matt Prosafety, Inc. Quality Blacktop Inc. South Side Control Supply Company Suburban Laboratories, Inc. Tank Industry Consultants, Inc. The T.L.C. Group LTD Thermastor LLC U.S. Bank Equipment Finance, Inc. Verizon Wireless Services LLC Visu -sewer of Illinois, LLC. VILLAGE OF MOUNT PROSPECT List of Bills January 31- February 13, 2013 Fund Vend Name Invoice Description Amount Warehouse Direct Office Supplies 79.03 Water Environment Federation Membership Dues 103.00 Ziebell Water Service Products Repair Maintenance Supplies 3,725.69 Repair Maintenance and Repair 38.40 Repair Maintenance Supplies 736.90 050 Water and Sewer Fund Total $ 500,602.57 051 Village Parking System Fund Crystal Maintenance Services Corp. Building cleaning services in 9 buildings for the month of Jan. $ 1,782.09 Building cleaning services in 9 buildings forthe month of Feb 1,782.09 Cleaning for the month at 1711 Algonquin for January 56.81 Cleaning bill forthe Open House cleaning at the CCC 62.07 Illinois Department of Revenue IL State Withholding 39.92 IL State Withholding 66.13 IMRF IMRF 438.78 Internal Revenue Service Federal Withholding 261.96 Federal Withholding 482.85 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 21.96 Nationwide 457 (flat percent) 21.95 NCPERS Group Life Ins. IMRF Life Insurance 1.92 Total Parking Solutions, Inc. Annual maintenance contract for 7 Commuter Pay Stations 3,431.75 051 Village Parking System Fund Total $ 8,450.28 052 Parking System Revenue Fund Constellation NewEnergy, Inc. Electrical Service Delivery $ 103.19 Crystal Maintenance Services Corp. Building cleaning services in 9 buildings forthe month of Jan. 254.95 Building cleaning services in 9 buildings forthe month of Feb 254.95 Cleaning forthe month at 1711 Algonquin for January 8.13 Cleaning bill forthe Open House cleaning at the CCC 8.88 Elite Remodeling Group, Inc. Garnishment 142.21 Illinois Department of Revenue IL State Withholding 66.91 IL State Withholding 79.45 IMRF IMRF 880.18 Internal Revenue Service Federal Withholding 411.17 Federal Withholding 528.45 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 14.66 Nationwide 457 (flat percent) 14.67 NCPERS Group Life Ins. IMRF Life Insurance 1.28 NICOR Natural Gas Consumption 296.98 Total Parking Solutions, Inc. Annual maintenance contract for 7 Commuter Pay Stations 5,843.25 Paper supplies for commuter pay stations 1,700.00 052 Parking System Revenue Fund Total $ 10,609.31 060 Vehicle Maintenance Fund Alexander Equip.co., Inc. Vehicle Maintenance Supplies $ 60.40 American Messaging Pager rental 70.02 Arlington Heights Ford Vehicle Maintenance Supplies 37.49 AT & T AT & T Long Distance Service 12/1/12 - 12/31/12 18.86 Service 1/16/13 - 2/15/13 9.60 Barnes Group Bolts, nuts and washers 326.67 WD-40 109.34 Black spray paint 86.72 Botts Welding & Truck Service, Inc. Equipment Maintenance and Repair 21.50 Bridgestone Retail Operations, LLC. Tires 1,617.28 Tires 606.72 Vehicle Maintenance Supplies 38.00 Tires 1,935.54 Busse Car Wash, Inc. 110 Car washes 880.00 Catching Fluidpower Vehicle Maintenance Supplies 12.94 Certified Fleet Services, Inc. Vehicle Maintenance Supplies 102.21 Chicago International Truck 4518 OEM fuel filter housing 344.04 Vehicle Maintenance Supplies 1,828.93 Vehicle Maintenance Supplies 231.82 Vehicle Maintenance Supplies 77.63 Coolant for International trucks 218.76 2727 Oil tubes and parts needed to replace turbo 121.67 Vehicle Maintenance Supplies (199.50) Chicago Parts & Sound Llc Squad Batteries 195.18 Squad Batteries 390.36 Page 8 of 12 VILLAGE OF MOUNT PROSPECT List of Bills January 31- February 13, 2013 Fund Vendor Name Invoice Description Amount Cylinders, Inc. Equipment Maintenance and Repair 325.50 Dave & Jim's Auto Body, Inc. Equipment Maintenance and Repair 100.00 Foster Coach Sales Inc. 526 LED license plate bulb 19.40 524 Air horn trumpet 99.70 Global Emergency Products Vehicle Maintenance Supplies 68.95 Grossinger Chevrolet 1 -23 Evap solenoid 49.85 Hoskins Chevrolet, Inc. Headlight connector 26.75 ICMA RHS Sick 24 594.40 ICMA Retirement Trust -457 ICMA 457 (flat percent) 523.58 ICMA 457 (flat percent) 605.31 Illinois Department of Revenue IL State Withholding 1,455.72 IL State Withholding 1,948.46 IMRF IMRF 16,486.04 Inland Power Group Inc. Fire truck oil filters 150.14 Coolant filters 74.56 Internal Revenue Service Federal Withholding 8,913.89 Federal Withholding 12,934.20 Interstate Battery Batteries 413.66 James Drive Safety Lane LLC Equipment Maintenance and Repair 372.50 Just Tires Vehicle Maintenance Supplies 489.28 Vehicle Maintenance Supplies 174.03 Lund Industries, Inc. Vehicle Maintenance Supplies 1,310.00 Vehicle Maintenance Supplies 202.60 Mcmaster -carr Supply Co. Vehicle Maintenance Supplies 80.66 Small Tools 54.90 Small Tools 118.67 Vehicle Maintenance Supplies 100.86 Vehicle Maintenance Supplies 40.24 Vehicle Maintenance Supplies (21.50) Morton Grove Automotive 4523 Rebuild alternator 125.00 Motion Ind. Inc. Vehicle Maintenance Supplies 143.00 Napa- Heights Automotive Supply Vehicle Maintenance Supplies 54.65 Vehicle Maintenance Supplies 5.38 Wire 6.88 Oil filter and steering shock 52.63 Oil filters 33.75 530 Radiator cap 6.68 524 Light socket 3.77 5 -31 sway bar and spark plug wires 120.47 2759 Plow light bulb 76.98 Headlight bulbs 27.96 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 70.00 Nationwide 457 (flat percent) 70.00 NCPERS Group Life Ins. IMRF Life Insurance 48.00 Northwest Suburban United Way United Way 3.85 Palatine Oil, Inc. Fuel Purchase 23,707.46 Pomp's Tire Service, Inc. Vehicle Maintenance Supplies 850.00 Precision Service & Parts Vehicle Maintenance Supplies (73.96) Vehicle Maintenance Supplies (93.76) 525 Front brake rotors and pads 267.69 P-42 Fuel cap 16.85 505 Power steering pump and stabilizer shock 223.89 Squad front brake rotors 104.96 Squad front brake rotors 94.46 Equipment Maintenance and Repair 263.48 Vehicle Maintenance Supplies (232.05) Batteries 406.25 Vehicle Maintenance Supplies (72.00) 2743 Rear brake pads /rotors 209.94 Ford transmission fluid 282.10 5 -31 Tie rod ends 76.78 Pro Finish Vehicle Maintenance Supplies 430.00 Regional Truck & Equip Vehicle Maintenance Supplies 111.67 Standard Equipment Company 2725 Wireless Vactor transmitter control 2,714.24 Terrace Supply Company Equipment Maintenance and Repair 22.12 Cylinder rental 18.29 Vehicle Maintenance Supplies (104.37) Equipment Maintenance and Repair 15.75 Vehicle Maintenance Supplies 226.32 Page 9 of 12 VILLAGE OF MOUNT PROSPECT List of Bills January 31- February 13, 2013 Fund Vendor Name Invoice Description A _ 2,250.00 Vehicle Maintenance Supplies 88.00 Equipment Maintenance and Repair 18.29 UPS Store #707 Vehicle Maintenance Supplies 11.26 Verizon Wireless Services LLC Cellular Service Dec 20 - Jan 19 394.84 Wal -Mart Community Vehicle Maintenance Supplies 11.80 Warehouse Direct Office Supplies 9.78 Waytek, Inc. Vehicle Maintenance Supplies 216.47 West Side Tractor Sales Equipment Maintenance and Repair 708.12 87.03 Cutting edges 785.86 2719 Door cylinder 76.92 060 Vehicle Maintenance Fund Total $ 89,490.98 061 Vehicle Replacement Fund Care One EMS Refund CK #1078 - Deposit 2006 ForclE450 Classic $ 2,250.00 Catching Fluidpower New truck 4517 fittings 36.56 New Truck 4517 Hydraulic Fittings 198.88 New truck 4517 fittings 13.12 CDS Office Technologies Radio antenna for in -car computers 900.00 Lindco Equipment Sales, Inc. Equipment for Public Works Vehicles 322.86 Equipment Public Works Vehicles 87.03 Equipment Public Works Vehicles 228.40 Mcmaster -carr Supply Co. Equipment Public Works Vehicles 145.87 Pomp's Tire Service, Inc. Vehicle Maintenance Supplies 2,282.92 Redistrip Company New truck 4517 strip and blast various truck components 425.00 Suburban Accents Inc Squad conversion: P -9 995.00 061 Vehicle Replacement Fund Total $ 7,885.64 063 Risk Management Fund American Appraisal Associates, Inc. Insurance Appraisal & Updated Fixed Asset Accounting $ 3,000.00 Botts Welding & Truck Service, Inc. 4509 Accident Repair 2,138.44 Dave & Jim's Auto Body, Inc. #526 Ambulance Accident Repair 853.12 Squad P -38 Accident Repair 397.00 Gallagher Bassett Services, Inc. Liability Claims - January 2013 13,617.89 International Union of Operating Engineers PW Insurance Premiums - April 2013 44,775.00 Municipal Claims and Safety Agreement WC Claim Funding - February 49,854.00 WC Claim Funding 60,000.00 Realwheels Cover Co., Inc. Repair Engine #516 287.87 063 Risk Management Fund Total $ 174,923.32 070 Police Pension Fund Mesirow Financial Investment Management, Inc. Inv Mgmt Fees 10/1/12- 12/31/12 $ 5,475.38 Sawyer Falduto Asset Management, LLC MGMT Fee to Advisor _ 2,550.00 070 Police Pension Fund Total $ 8,025.38 071 Fire Pension Fund Warehouse Direct Office Supplies $ 32.22 Wells Fargo Bank Inv Mgmt Fees 10/1/12- 12/31/12 4,716.62 071 Fire Pension Fund Total $ 4,748.84 073 Escrow Deposit Fund 312 Wraps & Signs Refund Escrow Permit # 12 -0546 $ 125.00 A J Maggio Co Refund Escrow Permit # 12 -0138 125.00 A To Z Plumbing Refund Escrow Permit # 12 -0047 75.00 Able Concrete Correction Inc Refund Escrow Permit # 12 -0969 200.00 ABT Electronics Inc Refund Escrow Permit # 13 -0057 150.00 Accurate Plumbing Doctors Refund Escrow Permit # 11 -2796 125.00 All Clear Sewer & Drainage Refund Escrow Permit # 12 -0520 125.00 AIRS of Illinois Refund Escrow Permit # 12 -0062 125.00 Refund Escrow Permit # 12 -1666 125.00 Associated Heating Group Inc Refund Escrow Permit # 13 -0029 75.00 Avalon Management Services LLC Refund Escrow Permit# 12 -1987 125.00 Bill Goronson Carpentry Refund Escrow Permit # 12 -0026 150.00 Bishop Plumbing Inc Refund Escrow Permit # 12 -0145 125.00 Refund Escrow Permit # 13 -0014 125.00 Burgett Builders Inc Refund Escrow Permit # 12 -1748 75.00 Canopy Construction Inc Refund Escrow Permit# 10 -1330 200.00 Capps Plumbing & Sewer Inc Refund Escrow Permit # 12 -0075 125.00 Refund Escrow Permit # 12 -0509 450.00 Capps Plumbing and Sewer Inc Refund Escrow Permit # 12 -2026 75.00 Page 10 of 12 VILLAGE OF MOUNT PROSPECT List of Bills January 31 - February 13, 2013 Fund Vendor Name Invoice Description Amount Chang, Ang L Refund Escrow Permit # 11 -0524 50.00 Chicago Water Connection Inc Refund Escrow Permit# 12 -2230 75.00 CNC Graphics Inc Refund Escrow Permit # 12 -0285 125.00 Cohen, Susan H Refund Escrow Permit # 12 -1646 200.00 DA Drain Surgeon Inc Refund Escrow Permit # 11 -2783 125.00 Duane Blanton Plumbing Sewer Refund Escrow Permit # 12 -0059 125.00 Edgar Sewell Plumbing Refund Escrow Permit # 12 -1326 125.00 Eggsperience of Glenview Inc Refund Escrow Permit # 12 -0705 125.00 Enk Strathmore LLC Refund Escrow Permit # 12 -0490 475.00 European Concrete & Excavating Inc Refund Escrow Permit # 12 -2085 125.00 Excel Property Investment Refund Escrow Permit # 12 -1248 250.00 Exercise Spa Inc. Refund - License Revocation Bond 2,500.00 Flush Sewer & Drainage Refund Escrow Permit # 13 -0063 75.00 Four Seasons Heating and A/C Refund Escrow Permit# 11 -2701 75.00 Frank, John G Refund Escrow Permit # 13 -0072 125.00 G Cat Construction Co Refund Escrow Permit # 12 -0246 150.00 Galaxy Home Appliance Inc Refund Escrow Permit# 13 -0077 125.00 Gerlach, Lillian Refund Escrow Permit# 11 -2617 500.00 Giordano, Frank Refund Escrow Permit # 12 -1504 500.00 Great Spaces Home Improvement Inc Refund Escrow Permit # 10 -1685 50.00 Greene, Brian Refund Escrow Permit # 11 -2550 125.00 H Borre & Sons Refund Escrow Permit# 11 -2653 200.00 Harris Trust & Savings Refund Escrow Permit # 05R129 35,000.00 Home Alteration & Design Inc Refund Escrow Permit # 12 -1931 100.00 Ibbotson Heating Company Refund Escrow Permit # 12 -1940 125.00 Refund Escrow Permit # 13 -0056 125.00 J & S Plumbing Refund Escrow Permit # 12 -1553 75.00 Refund Escrow Permit # 12 -1808 125.00 Refund Escrow Permit # 12 -1827 125.00 Refund Escrow Permit# 12 -1905 125.00 Refund Escrow Permit # 12 -2209 125.00 John KamyszJLK Enterprises LLC Refund Escrow Permit #12-0067 125.00 Joseph Landscape & Brick Paving Refund Escrow Permit # 11 -1005 200.00 JRC Construction Refund Escrow Permit # 12 -0511 200.00 Kalo, Maria Refund Escrow Permit# 12 -1825 125.00 Kelley, Robert H Refund Escrow Permit# 12 -0043 125.00 Kenoe, Mitchel D Refund Escrow Permit # 12 -1638 200.00 Kensington Professional Center LLC Refund Escrow Permit # 12 -0084 133.00 Lew, Mariusz Refund Escrow Permit # 12 -1459 200.00 Luft, Richard C Refund Escrow Permit # 12 -2110 200.00 Mach 1 Inc Refund Escrow Permit # 12 -1907 300.00 Ness, Alma Refund Escrow Permit# 12 -2201 25.00 Norr Illinois Inc Refund Escrow Permit # 11 -2301 1,500.00 Norton Sons Roofing Co Inc Refund Escrow Permit # 10 -1670 125.00 Perma Seal Basement Systems Refund Escrow Permit # 12 -0097 125.00 Refund Escrow Permit # 12 -1682 200.00 Pro Temp of Illinois Refund Escrow Permit# 13 -0024 75.00 Product Construction Corp Refund Escrow Permit # 12 -0186 200.00 Rick's Sewer& Drainage Refund Escrow Permit# 13 -0005 125.00 RJ Concrete Inc Refund Escrow Permit # 12 -1129 200.00 Roto Rooter Refund Escrow Permit # 12 -1386 75.00 Refund Escrow Permit # 12 -1838 125.00 Refund Escrow Permit # 12 -2088 125.00 Roto Rooter Glenview Refund Escrow Permit # 12 -0021 125.00 Safeguard Basement Technologies Inc Refund Escrow Permit# 12 -1736 200.00 Soderstrom, Daniel A Refund Escrow Permit# 12 -2206 125.00 T.S. Ventures Refund Escrow Permit # 12 -1693A 100.00 The Missner Group LLC Refund Escrow Permit # 11 -2731 125.00 Third District Circuit Court Bond Check 1/31/13 750.00 Band Check 2/5/13 2,710.00 Bond Check 2/7/13 400.00 Bond Check 2/12/13 970.00 Bond Check 2/13/13 250.00 Thorndale Construction Refund Construction Water Meter Deposit 163.04 T -Storm Construction Inc Refund Escrow Permit# 10 -0940 200.00 Tuczak, Joseph Refund Escrow Permit # 12 -0131 25.00 U S Waterproofing Inc Refund Escrow Permit # 10 -2622 125.00 Vega's Landscaping Refund Escrow Permit # 12 -1846 125.00 Vian Construction Refund Escrow Permit # 12 -2226 75.00 Page 11 of 12 VILLAGE OF MOUNT PROSPECT List of Bills January 31- February 13, 2013 Fund Vendor Name In voice Description Amount Village Sewer & Plumbing Refund Escrow Permit# 12 -0105 125.00 Refund Escrow Permit # 12 -0534 125.00 Refund Escrow Permit# 12 -0713 125.00 Refund Escrow Permit # 12 -1092 125.00 Refund Escrow Permit # 12 -1391 500.00 Virgilio, John Refund Escrow Permit # 12 -0154 75.00 073 Escrow Deposit Fund Total $ 57,101.04 Grand Total $ 2,48 Page 12 of 12