Loading...
HomeMy WebLinkAbout3. Monthly Financial Report & Approve Bills 05/20/2014Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO; VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR DATE: MAY 14, 2014 SUBJECT: MONTHLY FINANCIAL REPORT — APRIL 2014 Attached hereto are the cash position and investment statements of the Village for the month ended April 30, 2014. These statements provide a snapshot of the Village's cash position as of the month end date noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you receive. The first statement presents the Village's cash position broken down by governmental and enterprise funds and trust and agency funds. The second statement presents the Village's cash position by fund type. The third statement presents the list of investments again broken down by governmental and enterprise funds and trust and agency funds. It is important to note that although we have included the trust and agency funds in the cash position report, these are not funds 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 (pane 1) This report provides a detailed 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 and 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 account for the accumulation of monies for debt service payments. Governmental and Enterprise Funds - Cash and cash equivalents at March 31 were $39.3 million. During April, cash receipts totaled $5,449,222. In addition investment income for the month was $1,723. Reductions to cash and cash equivalents during April totaled $5,641,346. Of this amount, payments to vendors were $4,354,358 and employee payroll and related expenses were $1,279,043. Other disbursements reflect miscellaneous outflows of cash totaling $7,945. Cash and cash equivalents at April 30 were $39.4 million. Monthly f=inancial Report — April 2014 May 14, 2014 Page 2 Investments in the Governmental and Enterprise Funds at March 31 were $15.9 million. One CD matured returning $200,048 to cash. CD's were purchased using proceeds from the Series 2013 and Series 2014 bond issues. The maturity dates of the CD's are laddered to match the expected payout schedule of the underlying flood control and street resurfacing work. Total investments at April 30 were $15,668_,285. - - Total cash and investments for Governmental and Enterprise Funds at March 31 were $55,185,474. Cash and investments at April 30 totaled $55,042,866. This is a decrease of $142,608 for the month. Trust and Agency Funds - Cash and cash equivalents at March 31 were $5.5 million. During April, cash receipts totaled $480,120. In addition investment income was $95,630. There was also a net increase in cash due to investment activities of $678,010. Reductions to cash and cash equivalents during April totaled $724,113. Of this amount, payments to vendors were $157,138 employee payroll and related expenses were $542,357, and payments related to the flexible spending program totaled $20,278. In addition, other disbursements totaled $4,340. Cash and cash equivalents at April 30 were $6.0 million. Total investments at April 30 were $106,455,750, a decrease of $643,054 from March 31. There were investment income of $34,956 and a net transfer out totaling $678,010 that accounted for the change. Total cash and investments for Trust and Agency Funds at March 31 were $112,640,116. Cash and investments at April 30 totaled $112,478,962. This is a decrease of $161,154 from the prior month. 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 further explanation on the 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. Activity for the General Fund is highlighted below. General Fund — Cash and cash equivalents at March 31 totaled $9,594,114. During April, cash receipts totaled $3,048,544 and investment income was $192. Significant cash receipts included sales and income taxes. Sales tax revenues for the month totaled $1,069,985. Of this amount, $985,496 was generated from the 1 % state portion while $84,489 was generated from the .25% home rule portion. Sales taxes received in April are for January sales. There is a normal three -month lag in getting this distribution from the state. H:\ACCT\Treasurers Report\2014 \Monthly Cash Position Report -April 2014.docx Monthly Financial Report — April 2014 May 14, 2014 Page 3 State income tax receipts for April totaled $528,162. Income taxes received in April were due to the Village in February. The state is consistently 2 -3 months in arrears in remitting these taxes to the Village. The total amount in arrears for March and April is approximately $790,000 million. Disbursements from the General Fund for April included payments to vendors of $1,266,871, payments for employee wages and benefits of $1,136,405 and other disbursements of $8,035. Cash and cash equivalents at April 30 were $9,597,294. There were no investments in the General Fund at April 30. Statement of Investments (panes 3-4) 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 - The investments for the governmental and agency funds are made up solely of certificates of deposit. Certificates of deposit have maturities of between 56 and 331 days from date of purchase and are currently placed with several banks through our financial advisor, PMA. A detailed listing of the CD's currently held can be found on pages three and four of the financials following this summary write -up. Return on the portfolio of CD's range from 10 to 35 basis points. The portfolio return remains low on all types of investments available to municipalities (typically certificate of deposits, money market accounts and short-term treasuries). 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. Equity investments held by the Police Pension Fund are managed by Sawyer Falduto Asset Management. Below is a breakdown of how the pension fund portfolios are invested. HAACCT\Treasurers Report\2014 \Monthly Cash Position Report -April 2014.docx Monthly Financial Report — April 2014 May 14, 2014 Page 4 Maturity Purchase Financial Date Date Institution Various Various Wells Fargo Various Various Various F1RE PENSION FUND (071) Various Various Wells Fargo Various Various Various TOTAL TRUST AND AGENCY FUND INVESTMENTS Investment CUSIP/ Description Acct # 54,058,031.61 Wells Fargo Investments Various Mutual Fund Investments Various Wells Fargo Investments Various Mutual Fund Investments Various Interest Market Rate % Value Various $ 22,539,182.01 Various 31,518,849.60 54,058,031.61 Various 20,066,764.66 Var 32,330,953.29 52,397,717.95 $ 106,455,749.56 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:\ACC RTreasurers Report\2014 \Monthly Cash Position Report -April 2014.docx 0 VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended April 30, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS Disbursements: Accounts payable Payroll Flex spending Other Balance at April 30, 2014 (157,137.91) (542,357.49) (20,277.75) (4,339.69) (157,137.91) (542,357.49) (20,277.75) (4,339.69) $ 6,023,212.35 $ 106,455,749.56 $ 112,478,961.91 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 Cash and Cash Total Cash and Equivalents Investments Investments Balance at March 31, 2014 $ 39,317,188.61 $ 15,868,285.08 $ 55,185,473.69 Cash receipts 5,449,221.77 5,449,221.77 Investment income 1,722.50 48.12 1,770.62 Transfers from investments to cash 200,048.12 (200,048.12) - Transfers to investments from cash - - - Interfund activity 47,746.27 47,746.27 Disbursements: Accounts payable (4,354,357.92) (4,354,357.92) Payroll (1,279,043.20) (1,279,043.20) Other (7,945.03) (7,945.03) Balance at April 30, 2014 $ 39,374,581.12 $ 15,668,285.08 $ 55,042,866.20 TRUST AND AGENCY FUNDS * Disbursements: Accounts payable Payroll Flex spending Other Balance at April 30, 2014 (157,137.91) (542,357.49) (20,277.75) (4,339.69) (157,137.91) (542,357.49) (20,277.75) (4,339.69) $ 6,023,212.35 $ 106,455,749.56 $ 112,478,961.91 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 Cash and Cash Total Cash and Equivalents Investments Investments Balance at March 31, 2014 $ 5,541,311.75 $ 107,098,803.81 $ 112,640,115.56 Cash receipts 480,119.96 480,119.96 Investment income (loss) 95,629.69 34,955.81 130,585.50 Transfers from investments to cash 2,474,989.88 (2,474,989.88) - Transfers to investments from cash (1,796,979.82) 1,796,979.82 Interfund activity (47,746.27) (47,746.27) Disbursements: Accounts payable Payroll Flex spending Other Balance at April 30, 2014 (157,137.91) (542,357.49) (20,277.75) (4,339.69) (157,137.91) (542,357.49) (20,277.75) (4,339.69) $ 6,023,212.35 $ 106,455,749.56 $ 112,478,961.91 * Assets are restricted in purpose and do not represent discretionary assets of the government. 1 N VILLAGE OF MOUNT PROSPECT Summary of Cash Activity by Fund Type For the Month Ended April 30, 2014 INVESTTMENTS Certificates of deposit s - - 15,668,285.08 - 15,668,285.08 15,668,285.08 Wells Fargo investments - - _ - 42,605,946.67 42,605,946.67 Mutual fund investments - _ - - - - 63,849,802.89 - 63,849,802.89 Total investments - s s 15,668,285.08 _ 15,668,285.0 106,455,749.56 122,124,034.64 TOTAL CASH AND INVESTMENTS $ 9,597,294.04 $ 2,768,270.52 $ 1,163,695.99 $ 24,187,802.04 $ 6,257,751.06 $ 11,068,052.55 $ 55,042,866.20 $110,962,213.62 $ 1,516,748.29 $167,521,828.11 " Assets are restricted in purpose and do not represent discretionary assets of the government. GOVERNMENTAL AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS " SPECIAL CAPITAL TOTAL GOVT. FIRE AND OTHER TRUST REVENUE DEBT SERVICE PROJECTS ENTERPRISE INTERNAL AND ENTERPRISE POLICE AND AGENCY GENERAL FUND FUNDS FUNDS FUNDS FUNDS SERVICE FUNDS FUNDS PENSIONS FUNDS TOTAL CASH 8 CASH EQUIVALENTS Beginning balance $ 9,594,113.59 $ 3,661,920.37 $ 1,244,057.95 $ 7,754,548.42 $ 6,149,855.37 $ 10,912,692.91 $ 39,317,188.61 $ 4,276,190.16 $ 1,265,121.59 $ 44,858,500.36 Cash receipts 3,048,544.47 450,185.79 88,255.66 654,382.84 1,063,957.62 143,895.39 5,449,221.77 155,076.04 325,043.92 5,929,341.73 Investment income 192.48 107,05 11.56 260.53 202.33 948.55 1,722,50 95,459.51 170.18 97,352.19 Transfers from investments - - - 200,048.12 - - 200,048.12 2,474,989,88 - 2,675,038.00 Transfers to investments (1,796,979.82) - (1,796,979.82) Interfund (634,245.73) 28,899.70 - (165,442.18) 818,534.48 47,746.27 (40,109.72) (7,636.55) 0.00 Disbursements - other (8,035.28) 4.44 - 85.81 (7,945.03) (10.48) (4,329.21) (12,284.72) Disbursements - Flexible spending - - z _ - a (20,277.75) (20,277.75) Disbursements - payroll (1,136,404.82) (12,633.98) - (86,828.81) (43,175.59) (1,279,043.20) (542,357.49) - (1,821,400.69) Disbursements - accounts payable (1,266,870.67) (1.360,21285) ____(168,629.18) (89,72295) (704,079.08) (764.843.19) (4,354,357.92) (115,794.02) 41,343.89') (4,.511,495.83) Ending balance 9,597,294.04 2,768,270.52 1,163,695.99 8,519,516.96 6,257,751.06 11,066,052.55 39..374.581.12 4,506,464.06 1.516,748.29 45,397,793.47 INVESTTMENTS Certificates of deposit s - - 15,668,285.08 - 15,668,285.08 15,668,285.08 Wells Fargo investments - - _ - 42,605,946.67 42,605,946.67 Mutual fund investments - _ - - - - 63,849,802.89 - 63,849,802.89 Total investments - s s 15,668,285.08 _ 15,668,285.0 106,455,749.56 122,124,034.64 TOTAL CASH AND INVESTMENTS $ 9,597,294.04 $ 2,768,270.52 $ 1,163,695.99 $ 24,187,802.04 $ 6,257,751.06 $ 11,068,052.55 $ 55,042,866.20 $110,962,213.62 $ 1,516,748.29 $167,521,828.11 " Assets are restricted in purpose and do not represent discretionary assets of the government. VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of April 30, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS Maturity Purchase Financial Date Date Institution Investment Description CUSIP/ Interest Market FDIC # Rate % Value 05/01/14 02/13/14 Comm Bank of Chesapeake, MD Certificate of Deposit 30903 0.100% $ 237,923.01 05/01/14 02/13/14 First Trust & Saviing Bank, IA Certificate of Deposit 8752 0.100% 12,008.58 05/01/14 02/13/14 NCB, FSB, OH Certificate of Deposit 32612 0.100% 235,630.53 05/01/14 02/13/14 NewBridge Bank, NC Certificate of Deposit 16799 0.100% 238,189.49 05/01/14 02/13/14 Park Nall Bank, OH Certificate of Deposit 6653 0.100% 161,087.75 05/01/14 02/13/14 Regent Bank, FL Certificate of Deposit 26713 0.100% 18,927.90 05/01/14 02/13/14 Rockland Trust Co, MA Certificate of Deposit 9712 0.100% 46,437.00 05/01/14 02/13/14 Western Alliance Bank, CA Certificate of Deposit 57512 0.100% 163,616.22 05/15/14 02/13/14 Access National Bank, VA Certificate of Deposit 35189 0.120% 248,676.64 05/15/14 02/13/14 BB &T Bank, NC Certificate of Deposit 9846 0.120% 248,676.64 05/15/14 02/13/14 Cass Commercial Bank, MO Certificate of Deposit 1068 0.120% 248,676.64 05/15/14 02/13/14 Citizens Bank of OK, OK Certificate of Deposit 14899 0.120% 248,676.64 05/15/14 02/13/14 Citizens Business Bank, CA Certificate of Deposit 21716 0.120% 248,676.64 05/15/14 02/13/14 Cornhusker Bank, NE Certificate of Deposit 14264 0.120% 248,676.64 05/15/14 02/13/14 Dime Bank, PA Certificate of Deposit 9888 0.120% 248,676.64 05/15/14 02/13/14 Farm Bureau Bank, FSB, NV Certificate of Deposit 35157 0.120% 248,676.64 05/15/14 02/13/14 First Commonwealth Bank, PA Certificate of Deposit 7468 0.120% 248,676.64 05/15/14 02/13/14 First Southern Bank, FL Certificate of Deposit 27044 0.120% 248,676.64 05/15/14 02/13/14 Gorham Savings Bank, ME Certificate of Deposit 17748 0.120% 248,676.64 05/15/14 02/13/14 Heritage Bank Natl Assn, MN Certificate of Deposit 19254 0.120% 248,676.64 05/15/14 02/13/14 Mauch Chunk Trust Co, PA Certificate of Deposit 2359 0.120% 248,676.64 05/15/14 02/13/14 St. Louis Bank, TN Certificate of Deposit 58018 0.120% 248,676.64 05/15/14 02/13/14 Talmer Bank and Trust, MI Certificate of Deposit 58132 0.120% 248,676.64 05/15/14 02/13/14 Two Rivers Bank & Trust, IA Certificate of Deposit 58013 0.120% 248,676.64 05/15/14 02/13/14 United Bank, WV Certificate of Deposit 6784 0.120% 248,676.64 05/15/14 02/13/14 WesBanco Bank, Inc., WV Certificate of Deposit 803 0.120% 248,676.64 08/01/14 02/05/14 Citizens Community Bank, VA Certificate of Deposit 35326 0.140% 249,800.00 08/12/14 02/12/14 Compass Bank Certificate of Deposit N/A 0.150% 240,000.00 08/14/14 02/14/14 Bank ofBaroda Certificate of Deposit N/A 0.150% 249,185.08 09/02/14 02/05/14 Bar Harbor Bank & Trust, ME Certificate of Deposit 11971 0.154% 95,000.00 6,423,985.08 FLOOD CONTROL CONSTRUCTION FUND (024) 05/01/14 01/30/14 BBCN Bank, CA Certificate of Deposit 26610 0.100% 248,689.04 05/01/14 01/30/14 Commercial Bank of CA, CA Certificate of Deposit 57417 0.100% 248,689.04 05/01/14 01/30/14 Everbank, FL Certificate of Deposit 34775 0.100% 248,689.04 05/01/14 01/30/14 F &M Bank and Trust, OK Certificate of Deposit 16390 0.100% 248,689.04 05/01/14 01/30/14 Genesse Regional Bank, NY Certificate of Deposit 26333 0.100% 248,689.04 05/01/14 01/30/14 New Bridge Bank, NC Certificate of Deposit 16799 0.100% 10,487.68 05/01/14 01/30/14 S &T Bank, PA Certificate of Deposit 11124 0.100% 248,689.04 05/01/14 01/30/14 Santander Bank N.A., PA Certificate of Deposit 29950 0.100% 248,689.04 05/01/14 01/30/14 Washington Trust Co of Westerly, RI Certificate of Deposit 23623 0.100% 248,689.04 07/01/14 01/22/14 Citibank -IMMA Term, IL Certificate of Deposit 7213 0.100% 1,500,000.00 07/22/14 01/21/14 Bank of Virginia, VA Certificate of Deposit 57627 0.151% 249,800.00 08/01/14 01/22/14 Citibank -IMMA Term, IL Certificate of Deposit 7213 0.120% 1,750,000.00 09/02/14 01/22/14 Citibank -IMMA Term, IL Certificate of Deposit 7213 0.120% 500,000.00 09/18/14 01/21/14 Banco Popular North Amer, IL Certificate of Deposit 34967 0.120% 84,000.00 09/18/14 01/21/14 Banco Popular North Amer, IL Certificate of Deposit 34967 0.120% 83,000.00 09/18/14 01/21/14 Banco Popular North Amer, IL Certificate of Deposit 34967 0.120% 82,700.00 09/18/14 01/21/14 Essex Bank, VA Certificate of Deposit 8675 0.120% 249,800.00 09/18/14 01/21/14 Landmark Community Bank, TN Certificate of Deposit 34982 0.121% 249,700.00 09/18/14 01/21/14 Orrstown Bank, PA Certificate of Deposit 713 0.120% 249,700.00 10/20/14 01/21 /14 Bank Leumi USA, NY Certificate of Deposit 19842 0.150% 249,700.00 VILLAGE OF MOUNT PROSPECT STATEMENT OFLN'VESTMENTS As of April 30, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS Maturity Purchase Financial Investment CUS1P/ Interest Market Date Date Institution Description_ _ _ _ _ _ _ _ _ _ _ _ _ FDIC # Rate % Value FLOOD CONTROL CONSTRUCTION FUND (024) - continued 10/20/14 01/21/14 Cole Taylor Bank (N), IL Certificate of Deposit 22599 0.200% 249,600.00 10/20/14 01/21/14 IDB Bank, NY Certificate of Deposit 19977 0.151% 249,700.00 10/20/14 01/21/14 Republic Bank of Chicago, IL Certificate of Deposit 19333 0.150% 249,700.00 11/18/14 01/21/14 Bank of China, NY Certificate of Deposit 33653 0.207% 249,200.00 11/18/14 01/21/14 Bank of Houston, TX Certificate of Deposit 57965 0.150% 249,600.00 11/18/14 01/21/14 State Bank of India, NY Certificate of Deposit 33682 0.159% 249,600.00 12/18/14 01/21/14 Far East National Bank, CA Certificate of Deposit 21851 0.350% 249,200.00 12/18/14 01/21/14 Onewest Bank FSB, CA Certificate of Deposit 58978 0.300% 249300.00 9244,300.00 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS $ 15,,668 „285.08 TRUST AND AGENCY FUNDS Maturity Purchase Financial Investment CUSIP/ Interest Market Date Date Institution Description Acct # Rate % Value POLICE PENSION FUND (070) Various Various Wells Fargo Wells Fargo Investments Various Various $ 22,539,182.01 Various Various Various Mutual Fund Investments Various Various 31,518,849.60 54,058,031.61 FIRE PENSION FUND (071) Various Various Wells Fargo Wells Fargo Investments Various Various 20,066,764.66 Various Various Various Mutual Fund Investments Various Various 32,330,953.29 52 397117.95 TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 106,455,749.56 * Assets are restricted in purpose and do not represent discretionary assets of the government. 4 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES April 01- April 30, 2014 Revenue Budget by Account Classification Report Through 04/30/14 L Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactlons Transactions Rec'd Prior Year YTD Fund 001® General and REVENUE Property Taxes 14,674,466.00 .00 14,674,466.00 142,963.35 .00 7,367,083.33 7,307,382.67 50 6,371,109.87 Other Taxes 8,241,500.00 .00 8,241,500.00 584,976.68 .00 1,434,631.83 6,806,868.17 17 1,172,030.93 Licenses, Permits & Fees 1,621,000.00 .00 1,621,000.00 290,105.00 .00 751,835.34 869,164,66 46 1,721,417.62 Intergovernmental Revenue 18,083,100.00 .00 18,083,100.00 1,700,727.66 .00 2,491,013.51 15,592,086.49 14 2,266,523.26 Charges For Services 1,516,000.00 .00 1,516,000.00 148,923.21 .00 433,756.25 1,082,243.75 29 439,583.91 Fines & Forfeits 491,000.00 .00 491,000.00 31,990.58 .00 101,699.17 389,300.83 21 183,828.12 Investment Income 22,500.00 .00 22,500.00 362.45 .00 1,780.73 20,719.27 8 5,773.01 Reimbursements 226,000.00 .00 226,000.00 145,562.03 .00 196,846.95 29,153.05 87 84938.80 Other Revenue 918,500.00 .00 918,500.00 19,204.66 .00 110,205.57 808,294.43 12 86:311.77 Other Financing Sources 20,000.00 .00 20,000.00 .00 .00 .00 20,000.00 0 .00 REVENUE TOTALS $45,814,066.00 $0.00 $45,814,066.00 $3,064,815.62 $0.00 $12,888,852.68 $32,925,213.32 28% $12,331,517.29 Fund 001 - General Fund Totals $45,814,066.00 $0.00 $45,814,066.00 $3,064,815.62 $0.00 $12,888,852.68 $32,925,213.32 $12,331,517.29 H 7 Revenue Budget by Account Classification Report Through 04/30/14 ) L p / Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTD Fund 002 -Debt Service Fund REVENUE Property Taxes 2,237,000.00 .00 2,237,000.00 21,936.60 .00 1,142,525.23 1,094,474.77 51 880,394.22 Other Taxes 1,056,532.00 .00 1,056,532.00 66,319.06 .00 66,319.06 990,212.94 6 45,782.95 Intergovernmental Revenue 43,005.00 .00 43,005.00 .00 .00 .00 43,005.00 0 .00 Investment Income 400.00 .00 400.00 11.56 .00 17.19 382.81 4 33.87 Other Financing Sources .00 .00 .00 .00 .00 3,231.19 (3,231.19) ... .00 REVENUE TOTALS $3,336,937.00 $0.00 $3,336,937.00 $88,267.22 $0.00 $1,212,092.67 $2,124,844.33 36% $926,211.04 Fund 002 - Debt Service Fund Totals $3,336,937.00 $0.00 $3,336,937.00 $88,267.22 $0.00 $1,212,092.67 $2,124,844.33 $926,211.04 Account Classification Revenue Budget by Account Classification Report Through 04/30/14 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 020 -Capital Improvement Fury REVENUE Other Taxes 1,246,000.00 .00 1,246,000.00 78,212.06 .00 78,212.06 1,167,787.94 6 78,887.68 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Investment Income 1,000.00 .00 1,000.00 59.70 .00 215.58 784.42 22 253.87 Relmburserrients .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Revenue 10,000.00 .00 10,000.00 .00 .00 65,496.00 (55,496.00) 655 191,890.00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $1,257,000.00 $0.00 $1,257,000.00 $78,27136 $0.00 $143,923.64 $1,113,476.36 11% $271,031.55 Fund 020 - Capital Improvement Fund Totals $1,257,004,00 $0.00 $1,257,000.00 $78,271.76 $0.00 $143,92164 $1,113,07636 $271,031.55 W lr� Revenue Budget by Account Classification Report Through 04/30/14 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 Fund 021 - Series 2009 Construction Fund REVENUE Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 ... .00 Investment Income .00 '00 .00 .00 .00 .00 .00 ... 4.50 Other Revenue .00 .00 .00 .00 .00 .00 .00 ... .00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS $0.00 $0.00 $uo $0.00 $0.00 $0.00 $0.00 ... $4.50 Fund 021 - Series 2009 Construction Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.50 Revenue Budget by Account Classification Report - Through 04/30/14 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 022 = Downtown Redevelopment Construct REVENUE Property Taxes 2,671,000.00 .00 2,671,000.00 7,249.75 .00 1,242,655.34 1,428,344.66 47 1,317,313.00 Investment Income 1,000.00 .00 1,000,00 42.45 .00 131.27 868.73 13 214.98 Reimbursements .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Financing Sources .0 0 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $2,672,000.00 $ 0.00 $2,672,000.00 $7,292.20 $0.00 $1,242,786.61 $1,429,213.39 47% $1,317,527.98 Fund 022 - Downtown Redevelopment Construct Totals $2,672,000.00 $0.00 $2,672,000.00 $7,292.20 $0.00 $1,242,786.61 $1,429,213.39 $1,317,527.98 0 • Revenue Budget by Account Classification Report Through 04/30/14 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTD Fund 023 - Street Improvement Construe Fund REVENUE Other Taxes 2,057,000.00 2,057,000.00 142,414.74 .00 263,338.19 1,793,661.81 13 173,300.49 Licenses, Permits & Fees 1,045,000.00 00 1,045,000.00 398,106.00 .00 818,437.50 226,562.50 78 .00 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 ... 3,611.52 InvestmentIncorne 100.00 .00 100.00 713.10 .00 1,981.71 (1,881.71) 1982 24.46 Reimbursements .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Revenue 6,000.00 '00 6,000.00 10,230.23 .00 10,230.23 (4,230.23) 171 20.00 Other Financing Sources 6,500,000.00 .00 6,500,000.00 .00 .00 6,540,700.82 (40,700.82) 101 REVENUE TOTALS $9,608,100.00 $0.00 $9,608,100.00 $551,464.07 $0.00 $7,634,688.45 $1,973,411.55 79% $176,956.47 Fund 023 - Street Improvement Construe Fund Totals $9,608,100.00 $0.00 $9,608,100.00 $551,464.07 $0.00 $7,634,688.45 $1,973,411.55 $176,956.47 Revenue Budget by Account Classification Report Through Through 04/30/14 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Redd Prior Year YTD Fund 024 - Flood Control Construction Fund REVENUE Other Taxes 289,468.00 .00 289,468.00 18,170,06 .00 18,170.06 271,297.94 6 40 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 ... .00 Charges For Services .00 .00 .00 .00 .00 .00 ... .00 Investment Income 500.00 .00 500.00 1,140.55 .00 4,23128 (3,733.28) 847 1,329.40 Reimbursements .00 .00 .00 .00 .00 .00 .00 ... .00 Other Financing Sources .00 .00 .00 .00 .00 ... .00 REVENUE TOTALS t289,968.00 $0.00 $289,968.00 $19,310.61 $0.00 $22,403.34 $267,564.66 8% $41,384.58 Fund 024 - Flood Control Construction Fund Totals $289,968.00 $0.00 $289,968.00 $19,310.61 $0.00 $22,403.34 $267,564.66 $41,384.58 -4 00 Revenue Budget by Account Classification Report Account Classification Fund 040 m Refuse REVENUE Property Taxes Charges For Services Fines & Forfeits Investment .Income Reimbursements Other Revenue Through 04/30/14 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 342,000.00 .00 342,000.00 1,558.36 .00 176,290.78 165,709.22 52 937,544.28 2,900,000.00 .00 2,900,000.00 199,886.82 .00 925,577.00 1,974,423.00 32 673,424.59 25,000.00 .00 25,000.00 3,289.32 .00 9,508.45 15,491.55 38 5,559.88 500.00 .00 500.00 76.15 .00 278.13 221.87 56 157.28 00 .00 .00 .00 .00 .00 100 + ++ .00 359,000.00 .00 359,000.00 13,322.00 .00 42,577.07 316,422.93 12 60,031.57 REVENUE TOTALS $3,626,500.00 $0.00 $3,626,500.00 $218,132.65 $0.00 $1,154,231.43 $2,472,268.57 32% $1,676,717.60 Fund 040 - Refuse Disposal Fund Totals $3,626,500.00 $0.00 $3,626,500.00 $218,132.65 $0.00 $1,154,231.43 $2,472,268.57 $1,676,717.60 Revenue Budget by Account Classification Report Account Classlflcation Through 04/30/14 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 Fund 041 - Motor Fuel Tax Fund REVENUE Intergovernmental Revenue 1,290,000.00 .00 1,290,000.00 86,495.87 .00 315,942.41 974,057.59 24 312,608.68 Investment Income 100.00 .00 100.00 2.96 .00 7.53 92.47 8 62.31 Reimbursements 6,000.00 .00 6,000.00 6,870.77 .00 6,870.77 (870.77) 115 1,782.51 REVENUE TOTALS $1,296,100.00 $0.00 $1,296,100.00 $93,369.60 $0,00 $322,82031 $973,279.29 25% $314,453.50 Fund 041 - Motor Fuel Tax Fund Totals $1,296,100.00 $0.00 $1,296,100.00 $93,369.60 $0.00 $322,820.71 $973,279.29 $314,453.50 %.0 r 0 Revenue Budget by Account Classification Report Account Classification Through 04/30/14 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 293,202.00 97,171.00 390,373.00 .00 .00 .00 390,373.00 0 QO .00 .00 .00 .00 .00 .00 .00 + ++ .00 60,000.00 .00 60,000.00 .00 .00 42,285.52 17,714.48 70 53,086.18 $353,202.00 $97,171.00 $450,373.00 $0.00 $0.00 $42,285.52 $408,087.48 9% $53,086.18 $353,202.00 $97,171.00 $450,373.00 0.00 $0.00 $42,285.52 $408,087.48 $53,086.18 Revenue Budget by Account Classification Report Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 04/30/14 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Recd Prior Year YTD Fund 043 -Asset Seizure Fund REVENUE Fines & Forfeits 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 4,238.27 Investment Income 100.00 .00 100.00 1.81 .00 6.93 93.07 7 4.19 REVENUE TOTALS $2,100.00 $0.00 $2,100.00 $1.81 $0.00 $6.93 $2,093.07 0% $4,242.46 Fund 043 - Asset Seizure Fund Totals $2,100.00 $0.00 $2,100 ®00 $1.81 WG0 $6.93 $2,093.07 _ $4,242.46 r r r N Revenue Budget by Account Classification Report i Through 04/30/14 L Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classiflcation Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 044 - DEA Shams Funds Fund REVENUE Fines & Forfeits 100.00 .00 100.00 .00 .00 24,637.80 (24,537.80) 24638 .00 Investment Income 100.00 .00 100.00 2.96 .00 7.13 92.87 7 3.36 REVENUE TOTALS $200.00 $0.00 $200.00 $2.96 $0.00 $24,644.93 ($24,444.93) 12322% $3.36 Fund 044 - DEA Shared Funds Fund Totals $200.00 $0.00 $200.00 $2.96 $0.00 $24,644.93 ($24,444.93) $3.36 Revenue Budget by Account Classification Report Through 04/30/14 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 045 - DUI Fine Fund REVENUE Fines & Forfeits 20,000.00 .00 20,000.00 6,429.98 .00 6,429.98 13,570.02 32 3,813.95 Investment Income 100.00 .00 10 4.50 .00 18.00 82.00 18 .00 REVENUE TOTALS $20, 1 0 0.00 $0.00 $20,100.00 $6,434.48 $0.00 $6,447.98 $13,652.02 32% $3,813.95 Fund 045 - DUI Fine Fund Totals $20,100.00 $0.00 $20,100000 $6,434.48 $0.00 $6,447a98 $13,652.02 $3,813.95 r w Fund 046 - Foreign Fire Tax Board Fund REVENUE Other Taxes 70,000.00 .00 70,000.00 M .00 .00 70,000.00 0 .00 Investment Income 1,000m .00 1,000.00 1166 .00 48.13 951.87 5 .00 Other Revenue .00 .00 .00 .00 .00 .00 .00 ... 45.00 Other Financing Sources .00 .00 .00 .00 .00 .00 M ... '00 REVENUE TOTALS $71,000.00 $0.00 $71,000.00 $12.66 $0.00 $48.13 $70,951.87 0% $45.00 Fund 046 - Foreign Fire Tax and Fund Totals $71,000.00 $0.00 $71,000.00 $12.66 $0.00 $48.13 $70,951.87 $45.00 Revenue Budget by Account Classification Report Account Classification Fund 047 - Justice Assistance Grant Fund REVENUE Through 04/30/14 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 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Investment Income .00 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++ $0.00 Fund 047 - Justice Assistance Grant Fund Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 r Ln rn Revenue Budget by Account Classification Report Account Classification Fund 048 - Business District Fund REVENUE Through 04/30/14 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 943,000.00 .00 943,000.00 73,011.14 .00 166,959.78 776,040.22 18 138,756.75 InvestmentSncome 100.00 .00 100.00 6.01 .00 12.92 87.08 13 37.26 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $943,100.00 $0.00 $943,100.00 $73,017.15 $0.00 $166,972.70 $776,127.30 18% $138,794.01 Fund 048 -Business District Fund Totals $943,100.00 $0.00 $943,100.00 $73,017.15 $0.00 $166,972.70 $776,127.30 $138,794.01 Revenue Budget by Account Classification r v Report Through 04/30/14 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 050 - Water and Sewer Fund REVENUE Property Taxes 1,530,000.00 .00 1,530,000.00 17,660.62 .00 808,834.40 721,165.60 53 794,339.76 Licenses, Permits & Fees 17,000.00 .00 17,000.00 1,330.00 .00 5,110.00 11,890.00 30 5,610.00 Charges For Services 12,711,000.00 .00 12,711,000.00 912,552.99 .00 3,733,390.67 8,977,609.33 29 3,884,348.41 Fines & Forfeits 100,000.00 .00 100,000.00 8,898.03 .00 35,837.00 64,163.00 36 36,879.91 Investment Income 1,100.00 .00 1,100.00 191.70 .00 689.45 410.55 63 324.91 Reimbursements 1,000.00 .00 1,000.00 (131.00) .00 (131.00) 1,131.00 -13 6,226.68 Other Revenue 25,000.00 .00 25,000.00 4,679.35 .00 24,876.31 123.69 100 514.11 Other Financing Sources .00 .00 .00 . 00 .00 .00 .00 + ++ .00 REVENUE TOTALS $14,385,100.00 $0.00 $14,385,10.00 $945,181.69 $0.00 $4,608,606,83 $9,776,493.17 32% $4,728,243.78 Fund 050 -Water and Sewer Fund Totals $14,385,100.00 $0.00 $14,385,100.00 $945,181.69 $0.00 $4,608,606.83 $9,776,493.17 $4,728,243.78 r v M Revenue Budget by Account Classification Report Through 04/30/14 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 Other Taxes 10,000.00 .00 10,000.00 627.71 .00 627.71 9,372.29 6 695.05 Charges For Services 115,000.00 .00 115,000.00 2,887.55 .00 45,322.46 69,677.54 39 42,776.80 investment Income 100.00 .00 100.00 10.63 .00 38.93 61.07 39 10.35 Other Revenue 6,600.00 .00 6,600.00 550.00 .00 2,200.00 4,400.00 33 2,200.00 Other Financing Sources .00 .00 .00 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $131,700.00 $0.00 $131,700.00 $4,075.89 $0.00 $48,189.10 - $83,510.90 37% $45,682.20 Fund 051 - Village Parking System Fund Totals $131,700.00 $0.00 $131,700.00 $4,075.89 $0.00 $48,189.10 $83,510.90 $45,682.20 Revenue Budget by Account Classification I.- Report Through 04/30/14 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classlfication Budget Amendments Budget Transactions Encumbrances Transactlons Transactlons Recd Prior Year YTD Fund 052 - Parking Sys tern Revenue Fund _ REVENUE Other Taxes 90,000.00 .00 90,000.00 5,649.35 .00 5,649.35 84,350.65 6 6,255.41 Intergovernmental Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Charges For Services 112,000.00 .00 112,000.00 (2,491.40) .00 34,582.92 77,417.08 31 35,182.18 Investment Income 100.00 .00 100.00 .00 .00 .00 100.00 0 1.62 Other Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Financing sources .00 .00 .0 0 .00 .00 .00 .00 + ++ .00 REVENUE TOTALS $202,100.00 $ 0.00 $202,100.00 $3,157.95 $0.00 $40,232.27 $161,867.73 20% $41,439.21 Fund 052 - Parking System Revenue Fund Totals $202,100.00 $0.00 $202,100.00 $3,157.95 X0:00 $40,232.27 $161,867.73 $41,43921 I.- O Revenue Budget by Account Classification Fund 060 - Vehicle Maintenance Fund REVENUE Charges For Servlces 2,138,317.00 .00 2,138,317.00 178,193.07 X0 712,772.28 1,425,544.72 33 731,104.40 Investment Income .00 .00 .00 48.45 .00 195.42 (195,42) ... 167.97 Other Revenue .00 .00 .00 .00 100 .00 .00 + ++ 138.40 REVENUE TOTALS $2,138,317.00 $0.00 $2,138,317.00 $178,241.52 $0.00 $712,967.70 $1,425,349.30 33% $731,410.77 Fund 060 - Vehicle Maintenance Fund Totals $2,138,317.00 $0.00 $2,138,317.00 $178,241.52 $0.00 $712,967.70 $1,425,349.30 $731,410,77 Revenue Budget by Account Classification Report Account Classification Fund 061 - Vehicle Replacement Fund REVENUE Through 04/30/14 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 Charges For Services 1,346,300.00 100 1,346,300.00 112,191.68 .00 448,766.72 897,533.28 33 465,533.36 Fines & Forfeits 10,000.00 .00 10,000.00 1,200.00 .00 1,200.00 8,800.00 12 3,180.00 Investment Income 5,000.00 .00 5,000.00 642.12 .00 2,527.77 2,472.23 51 1,870.54 Other Revenue .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Financing Sources 60,000.00 .00 60,000.00 31,554.47 .00 31,554.47 28,445.53 53 16,974.24 REVENUE TOTALS $ 1,421,30 0. 00 $0.00 $1,421,300.00 $145,588.27 $0.00 $484,048.96 $937,251.04 34 a $487,558.14 Fund 061 - Vehicle Replacement Fund Totals $1,421,300.00 $0.00 $1,421,300.00 $145,588.27 $0.00 $484,048.96 $937,251.04 $487,558.14 N r Revenue Budget by Account Classification Report Account Classification Fund 062 - Computer Replacement Fund REVENUE Through 04/30/14 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prlor Year YTD Charges For Services 23,088.00 .00 23,088.00 1,924.00 .00 7,696.00 15,392.00 33 .00 Investment Income 1,000.00 .00 1,000.00 62.22 .00 251.52 748.48 25 237.70 Other Financing Sources . .00 . _ .00 .00 .0 0 . 00 + ++ .00 REVENUE TOTALS $24,088.00 $0.00 $24,088.00 $1,986.22 $0.00 $7,947.52 $16,140.48 33% $237.70 rund 062 - Computer Replacement Fund Totals $24,088.00 $0.00 $24,088.00 $1,986.22 $0.00 $7,947.52 $16,140.48 $237.70 Revenue Budget by Account Classification Report Account Classification Through 04/30/14 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 063 - Risk Management Fund REVENUE Charges For Services 6,456,273.00 .00 6,456,273.00 538,960.49 .00 2,183,252.92 4,273,020.08 34 1,964,134.58 Investment Income 2,000.00 .00 2,000.00 195.76 .00 780.75 1,219.25 39 553.41 Reimbursements 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Other Revenue 1,357,600.00 .00 1,357,600.00 112,852.34 .00 444,845.09 912,754.91 33 422,090.88 REVENUE TOTALS $7,8 $0.00 $7,8 $ 652,00 8.5 9 $ 0.00 $2,628,8 $ 34% $2,386,778.87 Fund 063 - Risk Management Fund Totals $7,816,873.00 $0.00 $7,816,873.00 $652,008.59 $0.00 $2,628,878.76 $5,187,994.24 $2,386,778.87 N W N �P Revenue Budget by Account Classification Report Account Classification Fund 070 m Police Pension Fund REVENUE Through 04/30/14 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 Charges For Services .00 .00 .00 .00 .00 00 .00 + ++ .00 Investment Income 3,415,900.00 .00 3,415,900.00 (14,256.88) .00 741,195.21 2,674,704.79 22 2,894,968.71 Other Revenue 3,742,224.00 .00 3,742,224.00 86,909.64 .00 1,668,549,51 2,073,674.49 45 1,572,646.84 REVENUE TOTALS - $7,158,124.00 50.00 $7,158,124.00 $722,652,76 $0.00 $2,409,744472 $4,748,379.28 34% '$4,467,615.55 Fund 070 - Police Pension Fund Totals $7,158,124.00 $0.00 $7,158,124.00 $72,652.76 $0.00 $2,409,744.72 $4,748,379.28 $4,467,615.55 Revenue Budget by Account Classification Report Account Classification Fund 071 - Fite Pension Fund REVENUE Through 04/30/14 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 Investment Income 3,165,200.00 .00 3,165,200.00 150,501.97 .00 997,064.49 2,168,135.51 32 2,379,504.90 Other Revenue 3,0 7 9, 0 4 2.00 .00 3,079,042.00 68,166.40 .00 1,469,036.74 1,610,005.26 48 1,375,675.15 REVENUE TOTALS $6,244,242.00 $ 0.00 $6,244,242.00 $218,668.37 $0.00 $2,466,101.23 $3,778,540.77 39% $3,756,180.05 Fund 071 - Fire Pension Fund Totals $6,244,242.00 $0.00 $6, 244,242.00 $218,668.37 $0.00 $2,466,101.23 $3,778,140.77 $3,755,180.05 Grand Totals $108,812,217.00 $97,171.00 $108,909,388.00 $6,421,964.05 $0.00 $38,268,92181 $70,640,466.19 $33,899,936.74 N Ln Expense ���=����� ���� ^� ���� mm Budget ��U� by ��N������ V� Classification V�� ������ 0��| ��N� Accountoassiflcation Adopted Budget Amended Current Month nn Budget Amendments Budget Transactions Encumbrances Through 0 Prior Fiscal Year Activi Included no Budget YrD %used/ Transactions Transactions nac'u Prior Year nD Furtd 001 - General Fund EXPENSE Personal Services, Scheduled Salaries aWages 23,919,74*.00 .00 23,919,744.00 1,762,141.48 .00 7,211,181.36 16,708,e62.64 30 6,840,277.43 Employee Benefits 12,344,3e.00 .00 12,344,314.00 56a,8a .14 .00 5,096,753.43 7,2*7560.57 41 4,717\246a2 Other Employee Costs +15,005.00 (1,000.00) 41*,005.00 23,875.06 12,450.00 97,656.*0 303,898.60 zr 91,297.03 Pension Benefits +6,301.00 .00 46,301.00 s,oso.u* .00 15,+33.++ 30,867.56 sa 15,383.24 Contractual Services 7,001,321.00 134,5*8u0 7,135,869.00 561,011.05 61+,099.17 2,218,632.55 4,303,137.28 +o 2,059,956.05 uu|m,s 262,282.00 .00 zou 22,763.87 .00 56,029.18 zo» zz +6 Insurance »so,szy.00 .00 350,519»0 29,:05.95 .00 116,862.20 233,656.80 »» zzs,ozs.*o Commodities &yupp||es 627,855.00 61,600.00 689,455.00 25,244.12 95,7*6.*5 142,893a9 +50,814.56 ys 131,730.00 omwrcxpenuxo/es 11,080.00 .00 11 .00 .00 .00 11,080.00 o .00 Building Improvements 10,000.00 .00 10,000.00 240.23 .00 1,028.91 8,971.09 m *,0*7.03 Office Equipment 49,730.00 .00 49 1,86+.71 1,75*.58 3,996.60 43,978.82 12 1,119.96 Other Equipment 165,123.00 3,100.00 168,223.00 26,126.85 33,579.18 45,556.13 89,087a9 47 9,726.37 Distribution Systems 100,000.00 .nn 100,000.00 .00 .00 .00 100,000.00 o .on Infrastructure 510,792.00 s,*oo.00 514,192.00 331.00 293,+40.05 26,062.40 1*4,689.55 82 85,088.10 zmwrfundTmnsfea .00 .Oo .00 .Oo .00 .VV .oV +++ .ou EXPENSE TOTALS $*5,814,066u0 $201,648.00 y*6,015,714.00 $3,026,500.82 $1,051,069.*3 $15,034086.59 929,932,557.:8 uurm $14,117,*893* Fund oot' General Fund Totals $*5,81*,066.00 $zoz,*m.00 $*6,015,714.00 $3 $1,054069.43 $15,034086.5: 929,932,557.:8 »14,117,589.33 ir- N Expense Budget by Account Classification Report U Through 04/30/14 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 F.:nd 002 -Debt Service Fund EXPENSE Contractual Services .00 .00 .00 .00 .00 .00 .00 +++ .00 ;)then Expenditures .00 .00 .00 .00 .00 .00 .00 + ++ .00 Bona Principal 1,532,587.00 .00 1,532,587.00 162,132.16 .00 162,132.16 1,370,454.84 it 19,000.64 interest. Expense 1,793,429.00 .00 1,793,429.00 6,497.02 .00 6,497.02 1,786,931.98 0 643.78 Bank & Fiscal Fees 2,484.00 00 2,484.00 .00 .00 1,258.20 1,225.80 51 428.00 tnterfund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 Other Financing Uses .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $3,328,500.00 $0.00 $3,328,500.00 $168,629.18 $0.00 $169,887.38 $3,158,612.62 5 0 % $20,072.42 Fund 002 - Debt Service Fund Totals $3,328,500.00 $0.00 $3,328,500.00 $168,629.18 $0.00 $169,887.38 $3,158,612.62 $20,072.42 Expense Budget by Account Classification Report Account Classification ;Fund 020 -Capital ImprovementFunC EXPENSE Through 04/30/14 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 .00 .00 .00 .00 + ++ 19,132.60 Other Expenditures .00 .00 .00 .00 .00 .00 .00 + ++ .00 Land Improvements 240,000.00 .00 240,000.00 .00 .00 .00 240,000.00 0 .00 Building improvements 637,000.00 73,600.00 710,600.00 3,945.00 91,934.57 26,761.60 591,903.83 17 57,752,64 Office Equipment .00 .00 .00 .00 .00 .00 .00 + ++ .00 Motor Equipment .00 .00 .00 .00 .00 .00 .00 ... .00 Other Equipment 304,247.00 16,600.00 320,847.00 10,603.91 65,000.00 46,334.72 209,512.28 35 55,443.39 Infrastructure 515,000.00 104,400.00 619,400.00 7,605.00 25,733.50 7,605.00 586,061.50 5 1,748.75 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $1,696,247.00 $194,600.00 $1,890,847.00 $22,153.91 $182,668.07 $80,701.32 $1,627,477.61 14% $134,077.38 Fund 020 - Capital Improvement Fund l'btals $1,696,247.00 $194,600.00 $1,890,847.00 $22,153.91 $182,668.07 $80,70132 $1,627,477.61 $134,077.38 w A. Expense Budget by. Account Classification Report Account Classification 021 -Series 2009 Construction Fund EXPENSE Through 04/30/14 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 .00 .00 .00 .00 +++ .00 Building Improvement- .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 + ++ 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 021 ® Series 20 09 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 Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Fund 022 - Downtown Redevelop Construct EXPENSE Contractual Services 203,040.00 .00 203,040.00 6,192.88 125,804.75 6,192.88 71,042.37 65 6,261.08 Utilities .00 .00 .00 .00 .00 .00 + ++ .00 Other Expenditures 2,803,922.00 60,000.00 2,863,922.00 19,025.77 32,858.93 2,831,063.07 1 25,053.44 Infrastructure 115,000m 240,000.00 355,000.00 .00 3,675.00 9,240.00 342,085.00 4 .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 ... EXPENSE TOTALS $3,121,962.00 $300,000.00 $3,421,962.00 $25,218.65 $129,479.75 $48,291.81 $3,244,190.44 5% $31,314.52 Fund 022 -Downtown Redevelop Construct Totals $3,121,962.00 $300,000.00 $3,421,962.00 $25,218.65 $129,479.75 $48,291.81 $3,244,190.44 $31,314.52 LTI ON Expense Budget by Account Classification Report Account Classiflcation Fund 02 Stree q ! I m pr ov Constr � Funi EXPENSE Through 04/30/14 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,600.00 41,000.00 71,600.00 .00 30,597.00 40,700.82 302.18 100 .00 Infrastructure 9,943,280.00 .00 9,943,280.00 466,377.90 8,524,277.66 468,102.51 950,899.83 90 9,107.68 fnteifundfiransfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $9,973,880.00 $41,000.00 $10,014,880.00 $466,377.90 $8,554,874.66 $508,803.33 $951,202.01 91% $9,107.68 Rind 023 - Street Improv Construc Fund Totals $9,973,880.00 $41,000.00 $10,014,880.00 $466,377.90 $8,554,874.66 $508,803.33 $951,202.01 $9,107.68 Expense Budget by Account Classification Report - Through 04/30/14 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 024 - Flood Control ConstruLdon Fun EXPENSE Contractual Services .00 .00 .00 .00 .00 .00 .00 ... .00 Utilities 1,000.00 .00 1,000.00 189.70 .00 739.07 260.93 74 .00 Other Expenditures 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 .00 Other Equipment .00 .00 .00 .00 .00 .00 .00 + ++ .00 Infrastructure 10,805,000.00 83,800.0 10,888,800.00 40,754.00 231,565.46 140,893.00 10,516,341.54 3 79,932.66 EXPENSE TOTALS $10,811,000.00 $ 83,800.00 $10,894,800.00 $40,943.70 $231,565.46 $141,632.07 $10,521,602.47 3% $79,932.66 Fund 024 - Flood Control Construction Fund Totals $10,811,000.00 583,800.30 $10,894,800.00 $40,943.70 $231,56141 $141,632.07 $10,521,602.47 $79,932.66 10 Expense Budget by Account Classification Report Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 04/30/14 Prior Fiscal Year Activity Included YTD Budget -YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 040 ® Refuse Disposal Fund EXPENSE Personal SeRkes, Scheduled Salaries & Wages 231,735.00 .00 231,735.00 17,358.33 .00 84,244.55 147,490.45 36 70,521.40 Employee Benefits 75,057.00 .00 75,057.00 7,967.44 .00 36,665.03 38,391.97 49 29,749.46 Other Employee Costs 1,224.00 .00 1,224.00 1,095.00 .00 1,095.00 129.00 89 .00 Contractual SeRkes 4,157,884.00 100 4,157,884.00 348,325.21 5,010.00 1,173,522.13 2,979,351,87 28 1,196,898.53 Ultilitles 438.00 .00 438.00 38.22 .00 100.87 337.13 23 99.76 insurance 28,640.00 .00 28,640.00 2,386.67 .00 9,546.68 19,093.32 33 9,413.00 Commodities & Supplies 31,295.00 .00 31,295.00 7,796.35 175.33 10,278.19 20,841.48 33 2,457.91 EXPENSE TOTALS $4,526,273.00 $0.00 $4,526,273.00 $384,967.22 $5,185.33 $1,315,452.45 $3,205,635.22 29% $1,309,140.06 Fund 040 - Refuse Disposal Fund Totals $4,526,273.00 $0.00 $4,526,273.00 $384,967.22 $5,185.33 $1,315,452.45 $3,205,635.22 $1,309,140.06 Expense Budget by Account Classification Report Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budge Transactions Encumbrances Through 04/30/14 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 041 - Motor Fuel Tax Fund EXPENSE Contractual Services 204,104.00 75,000,00 279,104.00 12,472.90 140,600.11 60,675.53 77,828.36 72 4,092.54 Utilities 153,000.00 .00 153,000.00 15,089.05 .00 59,299.39 93,700.61 39 42,323.67 Commodities & Supplies 284,796.00 .00 284,796.00 .00 26,944.69 216,890.32 40,960.99 86 147,195.10 Infrastructure 910,000. 5,000.00 915,000.00 .00 .00 10,056.62 904,943.38 1 .00 EXPENSE TOTALS $1,551,900.00 $ 8 0, 000.00 $1,631,900.00 $27,561.95 $167,544.80 $346,921.86 $1,117,433.34 32% $193,611.31 Fund 041 - Motor Fuel Tax Fund Totals $1,551,900.00 $80,000.00 $1,631,900.00 $27,561.95 $167,544.80 $346,921.86 $1,117,433.34 $193,611.31 e F- 0 Expense Budget by Account Classification Report Through 04/30/14 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 D Prior Year YT Fund 042 - Cninity Development Block Grant EXPEIN5E Persaillal Services 5&ed;A;;ed Salaries; & Wages 47,930.00 .00 47,930.00 3,279.15 .00 12,624.72 35,305.28 26 12,538.28 employee Benefts 26,222.00 .00 26,222.00 2,073.40 .00 8,210.08 18,011.92 31 7,894.57 Other Employee Costs 1,020.00 .00 1,020.00 125.00 .00 125.00 895.00 12 342.50 cof a, Services 97,520.00 23,250.00 120,770.00 7,413.80 24,820.00 24,010.61 71,939.39 40 2,085.09 'Commodities & Supplies 510.00 .00 510.00 .00 .00 .00 510.00 0 111.37 Other Eve.-ndftres 160,000.00 73,921.00 233,921.00 1,500.00 .00 1,820.00 232,101.00 1 33,529.60 Land Improvements .00 .00 .00 .00 .00 +++ .00 Building Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 ;fr 'n astruature 20,000.00 .00 20,000.00 .00 .00 .00 20,000.00 0 .00 EXPENSE TOTAI: S $353,202.00 $97,171.00 $450,373.00 $14,391.35 $24,820.00 $46,790.41 $378,762.59 16' $56,501.41 Fund 042 - Cminty Development Block Grant'! btals $353,202.00 $97,171.00 $450,373.00 $14,391.35 $24,820.00 $46,7 $378,762.59 $56,501.41 Expense Budget by Account Classification r F1 Report - Through 04/30/14 Prior Fiscal Year Activity Included Adapted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 0413 -Asset Seizure Fund EXPENSE Other Employee Costs 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Contractual Services 3,000.00 .00 3,000.00 .00 .00 1,500.00 1,500.00 50 .00 Other Equipment 15,000.00 .00 15,000.00 .00 .00 1,642.29 13,357.71 11 3,915.00 EXPENSE TOTALS $19,000.00 $ 0.00 $19,000.00 $0.00 $0.00 $3,142.29 $15,857.71 17% $3,915.00 Fund 043 - Asset Seizure Fund Totals $19,000.00 $0.00 $19,000.00 $0.00 $0.00 $3,142.29 $15,857,71 $3,915.00 r F1 Expense Budget by Account Classification Report Account Classification Fund 044 - D Shared Funds Fund EXPENSE Through 04/30/14 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 Sewices 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Building Improvements .00 .00 .00 .00 .00 .00 .00 + ++ Other Equipment 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 EXPENSE TOTALS $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $0.00 Fund 044 - DEA Shared Funds Fund Totals $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 $0.00 Expense Budget by Account Classification r w Report Through 04/30/14 Prior Fiscal Year Activity Included Adapted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Recd Prior Year YTD Fund 045 - DUI Fine Fund EXPENSE Other Employee Costs 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Contractual Services .00 .00 .00 .00 .00 .00 .00 ... .00 Other Equipment 10,000.00 .00 10,000.00 .00 .00 95.99 9,904.01 1 1,585.00 Interfund Transfers .00 . 00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $11,000.00 $0 =00 $11,000.00 $0.00 $0.00 $95.99 $10,904.01 1% $1,58S.00 Fund 045 - DUI Fine Fund Totals $11,000.00 $0.00 $11,000.00 $0.00 $0.00 $95.99 $10,904.01 $1,585.00 r w F 1 Expense Budget by Account Classification Report 1111111ilm Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 04/30/14 Prior Fiscal Year Activity Included YTD Budget -YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 046 -Foreign Fire Tax Board Fund EXPENSE Contractual Services 10,000.00 .00 10,000.00 .00 .00 3,094.11 6,905.89 31 2,938.44 Insurance 500.00 .00 500.00 .00 .00 :00 500.00 0 .00 Commodities & Supplies 5,000.00 .00 5,000.00 211.65 .00 211.65 4,788.35 4 1,304.24 Other Equipment 15,000.00 .00 15,000.00 2,832.00 .00 11,688.00 3,312.00 78 9,077.00 EXPENSE TOTALS $30,500.00 $0.00 $30,500.00 $3,043.65 $0.00 $14,993.76 $15,506.24 49 $13,319.68 Fund 046 - Foreign Fire Tax Board Fund Totals $30,500.00 $0.00 $30,500.00 $3,043.65 $0.00 $14,993.76 $15,506.24 $13,319.68 Expense Budget by Account Classification Report Account Classification Fund 047 Justice Assisunce Grant Fund EXPENSE Through 04/30/14 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 Commodities Fx 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.04 $0.00 $0.00 $0.00 $0.00 $0.00 r Ln F- 0) Expense Budget by Account Classification W,(' • Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 04/30/14 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 048 - Business District Fund EXPENSE Bond Principal .00 .00 .00 .00 .00 .00 .00 ... .00 Interest Expense 923,100.00 .00 923,100.00 .00 .00 .00 923,100.00 0 585,171.00 EXPENSE TOTALS $923,100.00 $0.00 $923,100.00 $0.00 $0.00 $0.00 $923,100.00 0% $585,171.00 Fund 048 - Business District Fund Totals $923,100.00 $0.00 $923,100.00 $0.00 $0.00 $0.00 $923,100.00 $585,171.00 Expense Budget by Account Classification Report Fund 0 Water p e r and Sewer Fund EXPENSE I Through 04/30/14 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 Salarles & Wages 1,952,664.00 .00 1,952,664.00 129,492.80 .00 678,206.18 1,274,457.82 35 591,421.18 Employee Benefits 787,893.00 .00 787,893.00 54,570.80 .00 265,301.66 522,591.34 34 249,044.41 Other Employee Costs 36,660.00 .00 36,660.00 804.08 400.00 11,284.77 24,975.23 32 5,589.45 Contractual Services 7,457,412.00 47,000.00 7,504,412.00 641,253.70 238,438.30 2,022,488.33 5,243,485.37 30 1,736,187.10 Utilities 157,758.00 .00 157,758.00 12,303.67 .00 33,602.66 124,155.34 21 30,221.10 Insurance 80,474.00 .00 80,474.00 6,706.16 .00 26,824.64 53,649.36 33 26,461.00 Commodities & Supplies 295,722.00 .00 295,722.00 14,388.94 37,738.20 61,484.69 196,499.11 34 34,665.05 Other Expenditures .00 .00 .00 .00 .00 .00 .00 + ++ .00 Building Improvements 42,500.00 .00 42,500.00 .00 4,250.00 .00 38,250.00 10 .00 Office Equipment 1,370.00 .00 1,370.00 .00 .00 .00 1,370.00 0 .00 Other Equipment 1,244,200.00 1,563,500.00 2,807,700.00 36,027.89 1,938,520.77 36,027.89 833,151.34 70 25,986.69 Distribution Systems 2,075,000.00 567,000.00 2,642,000.00 10,210.00 973,677.79 12,996.21 1,655,326.00 37 186,080.47 Infrastructure .00 .00 .00 .00 .00 .00 .00 + ++ .00 Bond Principal .00 .00 .00 .00 .00 .00 .00 + ++ .00 Interest Expense 00 .00 .00 .00 .00 .00 .00 + ++ .00 Interfund Transfers .00 .00 . 00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $14,13 1,653.00 $2,177,500.00 $1 $905,758.04 $3,193,025.06 $3,148,217.03 $9,967,910.91 39% $2,885,656.45 Fund 050 - Water and Sewer Fund Totals $14,131,653.00 $2,177,500.00 $16,309,15100 $905,758.04 $3,193,025.06 $3,148,217.03 $9,967,910.91 $2,885,656.45 r I.- 00 Expense Budget by Account Classification Report up- Through 04/30/14 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fund 051 - Village Parking System f=und EXPENSE Personal Services, Scheduled Salaries & Wages 35,788.00 .00 35,788.00 2,490.88 .00 12,252.57 23,535.43 34 7,165.09 Employee Benefits 17,796.00 .00 17,796.00 1,162.32 00 5,108.63 12,687.37 29 2,937.22 Contractual Services 91,055.00 .00 91,055.00 4,313.40 6,468.43 21,660.35 62,926.22 31 27,756.48 Insurance 1,175.00 .00 1,175.00 97.92 .00 391.68 783.32 33 386.00 Commodities & Supplies 510.00 .00 510.00 .00 .00 .00 510.00 0 .00 Other Expenditures .00 .00 .00 .00 .00 .00 .00 + ++ .00 Building Improvements 6,936.00 .00 6,936.00 ,00 2,750.80 .00 4,185.20 40 .00 Infrastructure 153,500.00 .00 153,500.00 .00 46,749.20 .00 106,750.80 30 .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $306,760.00 $0.00 $306,760.00 $8,064.52 $55,968.43 $39,413.23 $211,378.34 31% $38,244.79 Fund 051 - Village Parking .System Fund Totals $306,760.00 $0.00 $306,760.00 $8,064.52 $55,968.43 $39,413.23 $211,378.34 $38,244.79 Expense Budget by Account Classification Report 29=211= Adopted Budget Amended Current Month YTD Budget Amendments Budget Transactions Encumbrances Through 04/30/14 Prior Fiscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Rec'd Prior Year YTD Fund 032 - Parking System Revenue Fund EXPENSE Personal Services, Scheduled Salaries & Wages 28,598.00 .00 28,598.00 1,832.75 .00 8,844.15 19,753.85 31 12,826.97 Employee Benefits 13,772.00 .00 13,772.00 871.34 .00 3,789.97 9,982.03 28 6,480.09 Contractual Services 110,954.00 .00 110,954.00 6,247.58 4,843.41 26,954.15 79,156.44 29 30,496.37 Utilities 10,523.00 .00 10,523.00 784.78 .00 2,554.58 7,968.42 24 1,833.81 Insurance 1,406.00 .00 1,406.00 117.17 .00 468.68 937.32 33 462.32 Commodities & Supplies 9,779.00 .00 9,779.00 .00 1,025.00 5,176.44 3,577.56 63 1,854.14 Other Expenditures .00 .00 .00 .00 .00 .00 ... .00 Building Irn prove rnenLs 75,000.00 .00 75,000.00 .00 .00 .00 75,000.00 0 .00 Infrastructure '00 .00 .00 .00 .00 .00 .00 ... .00 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 ... .00 EXPENSE TOTALS $250,032.00 $0.00 $250,032.00 $9,853.62 $5,868.41 $47,787.97 $196,375.62 21% $53,953.70 Fund 052 - Parking System Revenue Fund Totals $250,031G0 $0.00 $250,032.00 $9,853.62 $5,M-41 $47,787.97 $196,375.62 $53,953.70 %D N) CD Expense Budget by Account Classification Report Through 04/30/14 Prior Fiscal Year Activity Included Adopted Budge Amended Current Month YTD YTD Budget - YTD % used/ Account Classifica Budget Amendments Budget Transactions Encumbrances Transactions Transactlons Rec'd Prior Year YTD Fund 060 - Vehicle Maintenance Fund EXPENSE Personal Services, Scheduled Salarles & Wages 940,529.00 .00 940,529.00 64,600.73 .00 324,941.74 615,587.26 35 277,644.02 Employee Benefits 384,627.00 .00 384,627.00 26,425.21 .00 124,418.03 260,208.97 32 119,229.86 Other Employee Costs 2,361.00 .00 2,361.00 174.00 .00 549.00 1,812.00 23 740.00 Contractual Services 100,738.00 .00 100,738.00 4,744.77 17,225.35 22,590.01 60,922.64 40 19,194.65 (julitles 3,070.00 .00 3,070.00 385.67 .00 776.22 2,293.78 25 1,225.65 Commodities & Supplies 701,081.00 .00 701,081.00 47,499.09 144,286.39 251,016.43 305,778.18 56 144,114.35 Other Expenditures .00 .00 .00 .00 .00 .00 .00 ... .00 Office EqUipinent 556.00 .00 556.00 .00 .00 132.99 423.01 24 .00 Other Equipment 19,770.00 .00 19,770.00 .00 520.14 350.00 18,899.86 4 .00 EXPENSE TOTALS $2,152,732.00 $0.00 $2,152,732.00 $143,829.47 $162,031.88 $724,774.42 $1,265,925.70 41% $562,148.53 Fund 060 - 'Vehicle Maintenance Fund Petals $2,152,732.00 $0.00 $2,152,732.00 $143,829.47 $162,031.88 $724,774.42 $1,265,925.70 $562,148.53 Expense Budget by Account Classification Report Account Classification Adopted Budget Amended Current Month YTD Budget Amendments Budget Tran En Through 04/30/14 Prior f=iscal Year Activity Included YTD Budget - YTD % used/ Transactions Transactions Recd Prior Year YTD Fund 061 -Vehicle Replacement Fund EXPENSE Other Expenditures .00 .00 .00 .00 .00 .00 .00 + ++ .00 Motor Equipment 1,614,000.00 163,700.00 1,777,700.00 3,308.15 365,465.13 24,151.06 1,388,083.81 22 16,821.09 Interfund Transfers .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $1,614,000.00 $163,700.00 $1,777,700.00 $3,308.15 $365,465.13 $24,151.06 $1,388,083.81 22% $16,821.09 Fund 061 - Vehicle Replacement Fund Totals $1,614,000.00 $163,700.00 $1,777,700.00 $3,308.15 $365,465.13 $24,151.06 $1,388,083.81 $16,821.09 N r N N Expense Budget by Account Classification Report - Through 04/30/14 Prior Fiscal Year Activity Included Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactlons Rec'd Prior Year YTD Fund 062 - Computer Replacement Fund EXPENSE Other Expenditures .00 .00 .00 .00 .00 .00 .00 ... .00 Office Equipment 247,480.00 .00 247,480.00 4,502.92 .00 55,687.15 191,792.85 23 31,041.97 EXPENSE TOTALS $247,480.00 $0.00 $247,480.00 $4,502.92 $0.00 $55,687.15 $191,792.85 23% $31,041.97 Fund 062 - Computer Replacement Fund Totals $247,480.00 $0.00 $247,480.00 $4,502.92 $0.00 $55,687.15 $191,792.85 $31,041.97 Expense Budget by Account Classification Report Account Classiflcatlon Fund 063 - Risk Management EXPENSE Through 04/30/14 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 27,000.00 .00 27,000.00 .00 .00 .00 27,000.00 0 10,950.00 Insurance 7,812,938.00 .00 7,812,938.00 646,408.05 5,566,60 2,698,418.99 5,108,952.41 35 2,531,798.80 Other Equipment 5,000.00 .00 5,000.00 .00 .00 .00 5,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 $7,84- $0.00 $7,844,938.00 S646,408.05 $5,566.60 $2,698 $5,140,95141 34% $2,542,748.80 Fund 063 -Risk Management Fund Totals $7,844,938.00 $0.00 $7,844,938.00 $646,408.05 $5,566.60 $2,698,418.99 $5,140,952.41 $2,542,748.80 t-j lA Expense Budget by Account Classification =1 Account Classification Fund 070 - Police Pension EXPENSE Through 04/30/14 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 Pension Benefits 3,937,366.00 .00 3,937,366.00 327,495.88 .00 1,301,275.32 2,636,090.68 33 1,276,470.16 Contractual Services 135,350.00 .00 135,350.00 10,509.17 .00 12,976.00 122,374.00 10 13,116.29 TFISUrance 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 .00 Commodities & Supplies 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 Other Expenditures 12,000.00 .00 12,000.00 .00 .00 250.00 11,750.00 2 520.00 Office Equipment .00 .00 .00 .00 .00 .00 .00 + ++ .00 EXPENSE TOTALS $4,099,816.00 $0.00 $4,099,816.00 $338,005.05 $0.00 $1,314,501.32 $2,785,314.68 32% $1,290,106.45 Fund 070 - Police Pension Fund Totals $4,099,816.00 $0.00 $4,099,816.00 $338,005.05 $0.00 $1,314,501.32 $2,785,314.68 $1,290,106.45 Expense Budget by Account Classification Report Account Classification Fund 071 - Fire Pension Fund EXPENSE Through 04/30/14 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 Pension Benefits 4,021,161.00 .00 4,021,161.00 335,094.12 .00 1,338,784.83 2,682,376.17 33 1,281,371.28 Contractual Services 124,600.00 .00 124,600.00 25,172.54 .00 38,664.28 85,935.72 31 30,235.55 Insurance 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 .00 Commodities & Supplies 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 32.22 Other Expenditures 12,000.00 .00 12,000.00 .00 .00 .00 12,000.00 0 25.00 EXPENSE TOTALS $4,173,761.00 $0 $4,173,761.00 $360,266.66 $0.00 $1,377,449.11 $2,796,311.89 33% $1,321,664.05 Fund 071 - Fire Pension Fund 'T'otals $4,173,761.00 $0.00 $4,173,761.00 $360,266.66 $0.00 $1,377,449.11 $2,796,311.89 $1,311,664.05 Oran o. Tnrals $116,983,802.00 $3,339,419.00 $120,323,221,00 $6,599,78U $ 14,135,133.01 $27,139,199.54 $79,048,888.45 $25,287,723.28 N U1 Fund Vendor Name VILLAGE OF MOUNT PROSPECT List of Bills May 01- May 14, 2014 Invoice Description 001 General Fund ACS State & Local Government Solutions Illinois State Disbursement Unit Air One Equipment, Inc. Items needed to repair cascade system on 544 Misc parts to repair cascade system on 544 Flow meter Airgas, Inc. Oxygen Alexian Brothers Medical Center OSHA Required Annual Audiometric Testing Amer Reprographics Co Llc Equipment Maintenance American Landscaping Inc. Professional Services American Public Works Assoc. Other supplies Other Employee Expense American Waterworks Assoc. Training Expense Anderson Pest Solutions Professional Services Andres Medical Billing, Ltd. Ambulance Billing -April 2014 Anita Goshali, Rabin Pradhan & Refund Vehicle License Fee Aramark Uniform Services, Inc. Uniform cleaning and rental for all public works employees Uniform rental and cleaning for all public works employees Arrowhead Scientific Inc. ET Supplies Arthur Weiler, Inc. Retainage Release Inv#30629 - 5/24/13 Avanti Cafe & Sandwich Bar, Inc. Dinner for FF Oral Interviews on 5/5/14 Dinner for FF Oral Interviews on 5/6/14 B & H Photo /video Power Supply Video Supplies Bedco Mechanical Repairs to the Reznor heating unit in the hose tower at Fire Sta Bronner's Display and Sign Advertising Civic Events Supplies Brownells, Inc. NIPAS supplies Business Office Systems, Inc. Desk Chairs Busse's Flowers & Gifts Eilering Sympathy Rogers Sympathy Sympathy Arrangement Sympathy Arrangement Capital One National Association Costco Purchased 3/25/14 - 4/7/14 Case Lots, Inc. Custodial supplies to be used in all buildings Custodial Supplies Castellanos, Sal Safety Shoe Allowance CDW Government, Inc. Computer equipment USB to DB25 printer cables Office Supplies Century Cleaners Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning CL Graphics, Inc. Set Up Postage for Mailing Summer Postcards Summer Events 2014 Postcard Comcast Xfinity internet service: 05/11- 06/10/14 Commonwealth Edison Electrical Service Delivery Constellation NewEnergy, Inc. Electrical Service Delivery Electrical Service Delivery Cooney, William J. Reimbursement for winter forum Reimbursement for mileage Reimbursement for Travel Costar Realty Information, Inc. Costar Crystal Court Shopping Center June rent for the CCC Crystal Maintenance Services Corp. Cleaning services for the month of May at all public buildings Data Media Products, Inc. Recording Media and Accessories Deluca, Kevin P. Safety Shoe Allowance Dennison Leafblad, Deborah Freelance Camera Page 1 of 9 Amount 3,379.60 1,529.05 36.30 789.00 317.43 493.50 62.00 750.00 40.00 295.00 58.00 48.00 5,731.42 90.00 122.72 116.22 187.34 949.85 64.15 68.15 14.59 672.32 441.95 1,674.30 41.00 1,167.02 55.00 95.00 80.00 83.50 178.50 1,988.70 285.55 153.54 5,496.40 83.63 102.51 16.85 8.20 12.30 20.95 21.88 27.30 26.45 19.20 14.25 430.00 1,654.00 68.95 17.81 29.37 29.37 95.00 231.78 1,094.20 518.75 5,723.03 7,181.81 654.49 180.00 450.00 VILLAGE OF MOUNT PROSPECT List of Bills May 01- May 14, 2014 Fund Vendor Name Invoice Description Amount Dolan, John Electric Griddle for station 12 54.61 2014 Fire Uniform Allowance 76.49 Elite Remodeling Group, Inc. Garnishment 142.22 Enterprise Rent -a -car SIU vehicle rental 02/28 - 04/29/14 1,241.41 Experian Pre- employment background checks: Police candidates 78.20 Federal Express Corp FeclEx Express Shipment - 4/18/14 24.26 Shipping Charges 55.55 Fire Pension Fund Fire Pension 22,199.77 Flory, James M 2014 Fire Uniform Allowance 100.00 Foehring, William 2014 Fire Uniform Allowance 23.96 Fonseca, Michael B. 2014 Fire Uniform Allowance 125.00 Forrest Keeling Nursery Tree Replacement 81.00 Garris, Joseph Reimburse expenses: IDEOA annual conference 04/23 -25/14 110.73 Reimburse expenses: Cellphone minutes 27.13 Grabowski, Tadeusz Refund Vehicle License Fee 36.00 Grainger Inc. Additional stanchions for forming lines for finance at the VH 1,403.00 Custodial Supplies 158.76 Storage cabinet, cart and other misc. fire prevention equipment 98.69 Grandgeorge, Aaron 2014 Fire Uniform Allowance 93.49 HD Supply Const Supply Ltd Engineering Supplies and Material 127.95 Healy Asphalt Company,llc. Asphalt materials used for street patching 36.63 Asphalt materials used for street patching 47.03 Streets Patching Materials 54.45 Asphalt material used for street patching 55.45 Asphalt material used for street patching 31.68 Asphalt material used for street patching 86.63 Asphalt materials for patching streets 49.50 Asphalt materials used for patching roads 67.82 Home Depot U.S.A., Inc. Maintenance and repair supplies 363.18 Home Depot Statement 555.99 Homer Tree Care, Inc. Tree Removals 1,711.97 Grounds Maintenance 610.00 Grounds Maintenance 610.00 Grounds Maintenance 610.00 Grounds Maintenance 610.00 Huizar, Carlos Reimburse expenses: Patches on uniform shirts 32.00 ICMA Retirement Trust -457 ICMA457 (flat percent) 18,495.08 Illinois American Water Company Private Fire Service 5/1/14 - 5/30/14 33.84 Illinois Department of Revenue IL State Withholding 35,833.24 Garnishment II 154.93 Illinois Municipal League Renewal Subscription 2014 - 2015 15.00 Illinois State Toll Hwy Authority Period 1/1/14 - 3/31/14 25.85 IMRF IMRF 158,438.23 Internal Revenue Service Federal Withholding 168,486.58 International Association of Fire Chiefs Annual Membership Dues for John Malcolm 209.00 International Union of Operating Engineers IUOE PW Membership Dues 959.23 J.P. Morgan Chase Bank N.A. Charges for subpoenaed bank records #13 -17962 47.35 Subpoenaed bank records charges #13 -19043 54.31 Jakubczyk, Kazimiera Refund Vehicle License Fee 36.00 Janonis, Michael E. Meeting regarding Cook County Hwy. 33.97 Kanupke, Joseph Reimburse expenses: Supervision of Police Personnel 03/03 -14/14 160.00 Karlstedt Landscape Group, Inc. Parkway Restoration 556.40 Kerstein, June Reimbursement - Food Expense 4/3/14 23.74 Klein, Thorpe and Jenkins, Ltd. Match 2014 Billing 49,657.50 Konica Minolta Business Solutions USA Inc Annual maintenance agreement for microfilm reader in Records 901.92 Kramer Tree Specialists Tree Trimming 12,055.00 Tree Removal 630.00 Tree Trimming 5,039.00 LeadsOnline LLC LeadsOnline TotalTrack service package renewal 5,158.00 Lee Jensen Sales Co. Inc. Portable Electric Generator rental 300.00 Leith, Duane Refund Vehicle License Fee 36.00 Lexisnexis Risk Data Management Inc. Background checks - April, 2014 109.10 Life Assist Restraints and penlights 166.35 Loomis, Christina Women's Legacy Conference Registration - C. Loomis 75.00 Losoff, Aaron 2014 Fire Uniform Allowance 125.00 Page 2 of 9 VILLAGE OF MOUNT PROSPECT List of Bills May 01- May 14, 2014 Fund Vendor Name Invoice Description Amount Maloney, Patricia A Refund Vehicle License Fee 36.00 Martin, Jefferey E Refund Overpayment Police Ticket# P3928986 50.00 Mcmaster -carr Supply Co. Maintenance and repair supplies 81.31 Maintenance and repair supplies 97.50 Meade Electric Co. Inc. Traffic Signal Improvements 387.85 Menards Large TV mount for supervisors' office 42.49 Other supplies 88.99 Menards Tools & tool box for Admin. services 72.86 Metro Federal Credit Union MP Fire Local 4119 Dues 2,318.11 Metropolitan Alliance - Police MP Police Association Dues 1,347.50 Michael Wagner & Sons, Inc. Maintenance and repair supplies 162.32 Michalik, Joel Safety Shoe Allowance 180.00 Middleton, Joan Reimbursement 98.58 Milewski, Janusz Refund Vehicle License Fee 36.00 Miller, Lloyd 2014 Fire Uniform Allowance 50.99 Moczisko, Michael Refund Overpayment Vehicle License Fee 24.00 Moore Medical Cholesterol Supplies 156.62 Morton Suggestion Co. Supplies for CPU ice cream event 1,189.52 Mount Prospect Paint, Inc. Maintenance and repair supplies 107.52 Maintenance and repair supplies 52.99 Municipal Emergency Services, Inc. Drop down name panel for Lt. Miller 35.00 Murphy, Randy Rebate Sidewalk Shared Cost Program 437.50 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 13,139.24 NCPERS Group Life Ins. IMRF Life Insurance 665.60 Nexus Office Systems, Inc. Copier Staples for PW 31413 and 31862 43.00 NICOR Natural Gas Consumption 1,369.42 Natural Gas Consumption 2,739.94 Natural Gas Consumption 533.40 Natural Gas Consumption 832.20 Natural Gas Consumption 164.17 Natural Gas Consumption 174.41 Natural Gas Consumption 12.25 Natural Gas Consumption 81.54 Natural Gas Consumption 405.88 North East Multi Regional Trng Course registration for Cornejo & Anzalone 03/25 -27/14 100.00 Northeastern III. Pub. SafetyTrng. Basic Firefighter Academy 3,995.00 Northshore University Healthsystem Medical exam: M. Weger 494.00 Medical exam: D. Zboril 431.00 Northwest Assoc. of Provider Ems Coordinators 2014 Annual Dues 50.00 Northwest Central Dispatch System June 2014 - Member Assessment 56,811.12 Northwest Electrical Supply Maintenance and repair supplies 64.33 Northwest Suburban United Way United Way 258.64 Novak, Todd 2014 Fire Uniform Allowance 125.00 Olague, Amelia Refund Overpayment Police Ticket # P3930964 30.00 Ortiz, Jose A Refund Overpayment Police Ticket # C59459 5.00 Petty Cash Petty Cash April 2014 358.87 Police Department Petty Cash 325.88 Petty Cash 437.88 Phenegar, Dane R. 2014 Fire Uniform Allowance 468.39 Pikora, Cory 2014 Fire Uniform Allowance 324.60 Police Pension Fund Police Pension 29,481.69 Police Technical, Inc. Register G. Sill & P. Lyons for PowerPoint for Public Safety 700.00 Proforma Customized Graphics Open House Supplies 221.29 Open House Supplies 240.63 Open House Supplies 689.21 Quality Craft, Inc. Repairs to the Village Hall walls from flooding event 12,690.72 Ray O'herron Co., Inc. Autolock supergrip batons 733.38 RC Topsoil Inc. Restoration Materials 217.80 Record -A -Hit, Inc. Special Events 1,000.00 Red Wing Shoe Store Safety Shoe Allowance 610.96 Safety Shoe Allowance 492.21 Safety Shoe Allowance 341.49 Reschke, Joseph 2014 Fire Uniform Allowance 125.00 Ricker, Jeffrey 2014 Fire Uniform Allowance 93.48 Rodewald, Craig R. 2014 Fire Uniform Allowance 184.50 Page 3 of 9 VILLAGE OF MOUNT PROSPECT List of Bills May 01- May 14, 2014 Fund Vendor Name Invoice Description Amount Russo Power Equipment Other Equipment 450.00 Safety Service Systems, Inc. Special Events Activities 299.25 111.75 Special Events Activities 595.70 Schlenbecker, Nicolas 2014 Fire Uniform Allowance 85.00 Schmitz, Jeffrey Reimburse expenses for training & range supplies 773.08 Morel - RHS due to Retirement Reimburse expenses: Range supplies 328.93 Secretary of State G536403 -160 - 2013 License Plate Renewal 101.00 Sill, Gregory Reimburse expenses: public relations supplies 53.26 18.90 Reimburse CPU expenses 17.42 Skindingsrude, Scott 2014 Fire Uniform Allowance 125.00 Sound Incorporated Phone System Upgrade 26,776.78 2014 Fire Uniform Allowance Voice mail support 222.00 South Side Control Supply Company Maintenance and repair supplies 744.15 Staples Contract & Commercial, Inc. Printer cartridges for photo printer 47.95 58.82 Ink cartridge for photo printer 55.99 Reimbursement - Springfield Lobby Days 4/29/14 - 5/1/14 Office Supplies 14.49 State of Illinois Monthly Internet Fees 1,166.25 Streicher's Inc. Training ammunition 1,191.00 Tartol, Sharon Refund Vehicle License Fee 36.00 Thakkar, Nayana Refund Vehicle License Fee 36.00 The Ups Store Thorne, Judy TigerDirect, Inc. Toma, David TransUnion Risk and Alternative Data Solutions Inc Tweedie, Bart U.S. Bank Equipment Finance, Inc. United Healthcare Vantagepoint Transfer Agents Village of Mount Prospect Wal -Mart Community Warehouse Direct Werner, Michael T. Wilson, Kevin B. Winter Equipment Company Inc Wisconsin Department of Revenue W ISCTF Wisniewski, Donald Wulbecker, Jeffrey Zadel, Michael Ziolkowski, Joseph 001 General Fund Total 002 Debt Service Fund Illinois EPA Illinois EPA 002 Debt Service Fund Total 020 Capital Improvement Fund Hutchinson Design Group,ltd. Northwest Central 9 -1 -1 System Sullivan Roofing, Inc. 020 Capital Improvement Fund Total 022 Downtown Redevelopment Construction Fund 25365 Corporation 022 Downtown Redevelopment Construction Fund Total 023 Street Improvement Construction Fund Arrow Road Construction Postage 12.76 Sister Cities pot luck 24.00 UPSes, hard drives 762.61 Refund Overpayment Vehicle License Fee 18.00 Background checks - April, 2014 111.75 Reimburse expenses: Supervision of Police Personnel 03/03 -14/14 160.00 PW Copy 1 #31862 Contract Payment 167.50 5/22/14 Contract Payment 138.78 Flex Benefit Plan Services - March 2014 613.25 Morel - RHS due to Retirement 608.77 Flex - Medical 8,502.93 Repair Maintenance Supplies 323.52 Mailing labels and legal pads 82.99 Binders 18.90 Office Supplies 81.35 Paper, labels, dry erase markers 137.62 Goldenrod Paper 13.54 2014 Fire Uniform Allowance 207.30 2014 Fire Uniform Allowance 125.00 Snow Plow Blades 103.82 WI State Withholding 590.27 Garnishment 542.48 Refreshments for 3 day training 58.82 Safety Shoe Allowance 141.36 Reimbursement - Springfield Lobby Days 4/29/14 - 5/1/14 279.59 Reimburse expenses: Replacement uniform pants 70.03 $ 722,206.31 L17 -0744 Principal & interest Payment $ 128,252.89 L17 -0855 Principal & interest 40,376.29 $ 168,629.18 Roof Replacement $ 1,995.00 Motorola Subscriber Financing - May 2014 10,603.91 Retainage Release 12/31/13 8,358.00 $ 20,956.91 Facade improvement $ 25,000.00 $ 25,000.00 2014 Street Resurfacing $ 464,734.76 Page 4 of 9 VILLAGE OF MOUNT PROSPECT List of Bills May 01- May 14, 2014 Fund Vendor Name Invoice Description Amount Arrow Road Construction 2014 Street Resurfacing 652,920.35 023 Street Improvement Construction Fund Total $ 1,117,655.11 024 Flood Control Construction Fund Burns & Mcdonnell Engineering Co. Professional Services $ 6,825.00 Constellation NewEnergy, Inc. Electrical Service Delivery 88.64 Electrical Service Delivery 101.06 024 Flood Control Construction Fund Total $ 7,014.70 040 Refuse Disposal Fund ARC Disposal Company Refuse Disposal Program $ 1,442.28 ICMA Retirement Trust - 457 ICMA 457 (flat percent) IMRF 37.92 Illinois Department of Revenue IL State Withholding Federal Withholding 377.68 IMRF IMRF 78.13 2,890.19 Internal Revenue Service Federal Withholding 2,573.78 International Union of Operating Engineers IUOE PW Membership Dues 99.23 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 110.00 NCPERS Group Life Ins. IMRF Life Insurance 17.60 Northwest Suburban United Way United Way 3.85 Proforma Customized Graphics Open House Supplies 117.06 Open House Supplies 127.29 Open House Supplies 175.35 Village of Mount Prospect Flex - Medical 79.38 040 Refuse Disposal Fund Total $ 8,051.61 041 Motor Fuel Tax Fund Commonwealth Edison Electrical Service Delivery $ 216.79 Constellation NewEnergy, Inc. Electrical Service Delivery 44.96 Electrical Service Delivery 215.31 Electrical Service Delivery 2,190.02 Electrical Service Delivery 135.64 Electrical Service Delivery 103.65 Electrical Service Delivery 27.78 Electrical Service Delivery 83.67 Electrical Service Delivery 87.78 Electrical Service Delivery 109.24 Electrical Service Delivery 96.23 Electrical Service Delivery 102.16 Electrical Service Delivery 123.46 Electrical Service Delivery 69.36 Illinois State Treasurer Traffic Signal Improvements 7,729.44 041 Motor Fuel Tax Fund Total $ 11,335.49 042 Community Development Block Grant ICMA Retirement Trust - 457 ICMA 457 (flat percent) $ 112.50 Illinois Department of Revenue IL State Withholding 65.98 IMRF IMRF 545.99 Internal Revenue Service Federal Withholding 424.49 Village of Mount Prospect Flex - Medical 78.13 042 Community Development Block Grant Total $ 1,227.09 050 Water and Sewer Fund Alexian Brothers Medical Center Amanda Berman American Waterworks Assoc. Aramark Uniform Services, Inc. Burns & Mcdonnell Engineering Co. Century Cleaners OSHA Required Annual Audiometric Testing OSHA Required Audiometric Testing Utility Refund -1806 Locust Ln Training Expense Uniform cleaning and rental for all public works employees Uniform rental and cleaning for all public works employees Emergency Generators Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning 493.50 21.00 31.98 58.00 122.73 116.23 836.00 16.85 8.20 12.30 20.95 21.87 27.30 Page 5 of 9 VILLAGE OF MOUNT PROSPECT List of Bills May 01- May 14, 2014 Fund Vendor Name Invoice Description Amount Century Cleaners Uniform Cleaning 26.45 ICMA Retirement Trust - 457 Uniform Cleaning 19.20 Illinois Department of Revenue Uniform Cleaning 14.25 Charles N. Mickelson Utility Refund - 8 N Waverly PI 7.27 DenDorBres LLC Utility Refund -1808 Pheasant Trl 28.34 Frank Babb Jr. Utility Refund - 909 S Emerson St 2.04 Gloria Pearson Utility Refund - 202 Westgate Rd # 2 1.25 Hansen, Donald E. Safety Shoe Allowance 180.00 HBK Water Meter Service Building Sewer Inspection 41.00 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 1,284.93 Illinois Department of Revenue IL State Withholding 3,131.68 IMRF IMRF 21,560.56 Internal Revenue Service Federal Withholding 19,560.68 International Union of Operating Engineers IUOE PW Membership Dues 927.52 Karlstedt Landscape Group, Inc. Parkway Restoration 5,257.60 K -Plus Engineering, LLC. Professional Services 604.00 L & B Business Services Inc. Maintenance Supplies 358.76 Maintenance Supplies 46.57 Latitude Geographics Group Ltd. GIS Maintenance 172.50 Martam Construction Contractual Hauling 4,338.62 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 420.89 NCPERS Group Life Ins. IMRF Life Insurance 52.80 Nexus Office Systems, Inc. Copier Staples for PW 31413 and 31862 43.00 NICOR Natural Gas Consumption 168.41 Natural Gas Consumption 92.58 Northwest Suburban United Way United Way 34.73 Paddock Publications, Inc. Bid Notice 67.50 Piotr Wiktorczyk Utility Refund -1420 Chestnut Dr 19.12 Proforma Customized Graphics Open House Supplies 176.65 Open House Supplies 192.08 Open House Supplies 264.61 RC Topsoil Inc. Restoration Materials 112.20 Tank Industry Consultants, Inc. Tank Repair Rehab 1,118.44 Third Millennium Assoc.inc. April 2014 - Utility Billing 2,388.97 U.S. Bank Equipment Finance, Inc. PW Copy 1 #31862 Contract Payment 167.50 UPS Store #707 Shipping Expenses 16.96 Village of Mount Prospect Flex - Medical 625.45 W. Michael Mundt Utility Refund - 207 E Hiawatha Trl 96.06 Wal -Mart Community Repair Maintenance Supplies 295.88 Warehouse Direct Office Supplies 81.35 Water Products Company of Aurora, Inc. Hydrant Maintenance and Repair 4,700.00 Winter Equipment Company Inc Snow Plow Blades 177.28 ZBATTERY.COM INC Maintenance Supplies 1,582.20 050 Water and Sewer Fund Total $ 72,244.79 051 Village Parking System Fund Crystal Maintenance Services Corp. Cleaning services for the month of May at all public buildings $ 318.57 Elite Remodeling Group, Inc. Garnishment 78.19 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 6.00 Illinois Department of Revenue IL State Withholding 57.83 ICMA Retirement Trust - 457 Garnishment II 85.18 IMRF IMRF 414.68 Internal Revenue Service Federal Withholding 360.23 International Union of Operating Engineers IUOE PW Membership Dues 15.21 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 9.96 Petty Cash Petty Cash April 2014 23.00 Village of Mount Prospect Flex - Medical 34.64 051 Village Parking System Fund Total $ 1,403.49 052 Parking System Revenue Fund Constellation NewEnergy, Inc. Electrical Service Delivery $ 207.82 Electrical Service Delivery 97.64 Crystal Maintenance Services Corp. Cleaning services for the month of May at all public buildings 269.62 Elite Remodeling Group, Inc. Garnishment 64.02 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 4.00 Page 6 of 9 VILLAGE OF MOUNT PROSPECT List of Bills May 01 -May 14,2014 Fund Vendor Name Invoice Description Amount Illinois Department of Revenue IL State Withholding 41.60 Garnishment II 69.75 IMRF IMRF 305.25 Internal Revenue Service Federal Withholding 257.90 International Union of Operating Engineers IUOE PW Membership Dues 10.17 Nationwide Mutual Insurance Company Nationwide 457 (flat percent) 6.65 NICOR Natural Gas Consumption 124.26 Village of Mount Prospect Flex - Medical 27.44 052 Parking System Revenue Fund Total $ 1,486.12 060 Vehicle Maintenance Fund American Messaging Pager rental $ 72.80 Arlington Heights Ford 4503 Hub seals 30.44 P -1 Power steering line, oil 135.89 P -1 Heater Hose 59.87 Equipment Maintenance and Repair 238.05 Arlington Power Equipment Vehicle Maintenance Supplies 34.18 Vehicle Maintenance Supplies 23.38 Catching Fluidpower Vehicle Maintenance Supplies 2.31 Chicago Parts & Sound Llc Police tire sensors 94.54 Air filters 122.82 P -36 Radiator fan and relay 307.49 4503 Brake rotors and pads 189.94 P -14 A/C compressor and clutch 450.79 Vehicle Maintenance Supplies 239.92 Dave & Jim's Auto Body, Inc. Equipment Maintenance and Repair 50.00 Dultmeier Sales Davenport Inc Vehicle Maintenance Supplies 45.23 Vehicle Maintenance Supplies 60.94 Foster Coach Sales Inc. Ambulance Door latch 30.53 General Parts Inc. 4503 Front shocks 111.52 A/C oil and dye 72.07 Bulbs and thread sealant 37.66 Oil, power steering and brake fluid 95.28 WD -40 and lube 90.15 Grossinger Chevrolet 4540 Intake gasket 82.23 Headco Industries, Inc. Vehicle Maintenance Supplies 40.94 ICMA Retirement Trust - 457 ICMA 457 (flat percent) 556.50 Illinois Department of Revenue IL State Withholding 1,478.82 IMRF IMRF 10,756.05 Internal Revenue Service Federal Withholding 9,089.83 International Union of Operating Engineers IUOE PW Membership Dues 411.13 Leach Enterprises, Inc. Vehicle Maintenance Supplies 29.40 Vehicle Maintenance Supplies 13.28 Lund Industries, Inc. Vehicle Maintenance Supplies 103.50 Vehicle Maintenance Supplies 67.70 Mcmaster -carr Supply Co. Vehicle Maintenance Supplies 35.13 Vehicle Maintenance Supplies 36.59 Vehicle Maintenance Supplies 53.07 Morton Grove Automotive 4513 Rebuild alternator 175.00 Napa- Heights Automotive Supply Headlight bulbs 32.64 Pipe sealant 27.98 NCPERS Group Life Ins. IMRF Life Insurance 48.00 Northwest Suburban United Way United Way 3.85 Overhead Material Handling II., Inc. Annual OSHA crane inspections 392.15 Patten Industries, Inc. Vehicle Maintenance Supplies 164.96 Pomp's Tire Service, Inc. 530 Rear tires 1,556.20 Precision Service & Parts Air filters 172.08 GM coolant 123.60 P -14 A/C lines and seals 96.50 P -14 A/C line 114.51 4540 Fuel injector 103.97 4565 Power steering pump 110.20 Ronco Industrial Supply Vehicle Maintenance Supplies 243.24 Rush Truck Centers of Illinois, Inc. 2719 Brake sensor 15.61 Solvent Systems Int'l. Inc. Parts washer rental 300.00 Page 7 of 9 VILLAGE OF MOUNT PROSPECT List of Bills May 01- May 14, 2014 Fund Vendor Name Invoice Descr Amount Standard Equipment Company Vehicle Maintenance Supplies 86.68 EJ Equipment Vehicle Maintenance Supplies (0.94) Vehicle Maintenance Program Inc. Vehicle Maintenance Supplies 584.90 Village of Mount Prospect Flex - Medical 195.84 West Side Tractor Sales 2726 Steering bushings and pins 394.53 Mcmaster -carr Supply Co. 2726 Mirror clamps 28.09 Contract Service Fees 1/1/14 - 1/1/15 Backhoe, OEM air, fuel, oil and fuel filters 492.60 Napa- Heights Automotive Supply 2739 King pins and steering parts 409.01 060 Vehicle Maintenance Fund Total Equipment for Public Works Vehicles $ 31,221.17 061 Vehicle Replacement Fund Bonnell Industries Inc. Equipment for Public Works Vehicles $ 98.66 Catching Fluidpower Equipment for Public Works Vehicles 328.65 EJ Equipment Equipment for Public Works Vehicles 116,017.00 Leach Enterprises, Inc. Equipment for Public Works Vehicles 153.64 Dent Specilaties, Inc. Equipment for Public Works Vehicles 237.18 310.00 Equipment for Public Works Vehicles 61.32 Mcmaster -carr Supply Co. Equipment for Public Works Vehicles 56.80 Contract Service Fees 1/1/14 - 1/1/15 Equipment for Public Works Vehicles 58.70 Napa- Heights Automotive Supply Equipment for Public Works Vehicles 25.66 Suburban Accents Inc Equipment for Public Works Vehicles 450.00 061 Vehicle Replacement Fund Total 498.00 $ 117,487.61 063 Risk Management Fund American Appraisal Associates, Inc. Professional Valuation Consulting Services $ 9,270.00 Professional Valuation Consulting Services 1,030.00 Dave & Jim's Auto Body, Inc. Vehicle Repair # P -15 892.89 Dent Specilaties, Inc. S -27 Hail Damage Repair 5/1/14 310.00 Gallagher Bassett Services, Inc. Liability Claims 505.74 Contract Service Fees 1/1/14 - 1/1/15 2,373.00 Intergovernmental Per.ben.coop IPBC - May 2014 497,343.84 Parkside Auto Body Inc Vehicle Repair - VIN #1FMEU73838UB33601 498.00 Pulitini, Rebecca Reimbursement for Mailbox Damaged by Snow Removal 0 107.58 The Cima Companies, Inc. Volunteer Insurance Renewal 7 /1/14 - 7/1/15 2,311.00 063 Risk Management Fund Total $ 514,642.05 070 Police Pension Fund Mesirow Financial Investment Management, Inc. Inv Mgr Fees 1/1/14- 3/31/14 $ 5,524.96 Reimer & Karlson LLC Legal Service - Disability application - March 2014 1,668.43 070 Police Pension Fund Total $ 7,193.39 071 Fire Pension Fund Kenneally, Brennan M. Rollover of Fire Pension Contributions $ 49,691.48 Wells Fargo Bank Inv Mgr Fees 1/1/14- 3/31/14 4,460.66 071 Fire Pension Fund Total $ 54,152.14 073 Escrow Deposit Fund 3D Brick Paving Refund Escrow Permit # 13 -1302 (2113 Jody Ct) $ 150.00 ABC Plumbing & Heating Co Refund Escrow Permit # 13 -0659 (119 N Main St) 125.00 Accurate Plumbing Doctors Refund Escrow Permit # 14 -0480 (1174 Wheeling Rd) 125.00 AHS Plumbing Refund Escrow Permit # 14- 0551(700 E Busse Ave) 125.00 Akkathara, Sunny A Refund Escrow Permit # 14 -0412 200.00 ARS of Illinois Refund Escrow Permit # 14 -0462 (1109 Oakwood Dr) 125.00 Bertog Landscape Company Refund Escrow Permit # 13- 0741(1209 W Lincoln St) 125.00 Bishop Plumbing Inc Refund Escrow Permit # 14 -0082 (911 S Lancaster Ave) 125.00 Capdsey, Phil Refund Payment- Wrong PO Box 36.91 Delahunty, Sean Refund Escrow Permit # 14 -0521 125.00 Economakos, Harry Refund Escrow Permit # 14 -0384 150.00 Enders, James R Refund Escrow Permit # 14 -0349 200.00 Flush Sewer & Drainage Refund Escrow Permit # 14 -0524 (201 Westgate Rd) 125.00 Refund Escrow Permit # 14 -0570 (405 E Berkshire Ln) 500.00 Four Seasons Heating and A/C Refund Escrow Permit # 13 -2275 (906 S William St) 75.00 Refund Escrow Permit # 14 -0285 (1701 Robbie Ln) 125.00 Greenfield, Stacy Refund Overpayment Vehicle License Fee 36.00 Hargadon, Sean Refund Escrow Permit # 14 -0364 200.00 Page 8 of 9 VILLAGE OF MOUNT PROSPECT List of Bills May 01- May 14, 2014 Fund Vendor Name Invoice Description Amount Heights Glass and Mirror Refund Escrow Permit # 14- 0431(318 1 Oka Ave) 125.00 Jaacks, Jeri Refund Escrow Permit # 14 -0163 200.00 Janowska, Agnieszka Refund Escrow Permit # 13 -2281 400.00 Kapps, Kenneth J Refund Escrow Permit # 14 -0600 125.00 Kern, Jeffrey Refund Escrow Permit # 14 -0383 125.00 Lasarsky, Phil Refund Escrow Permit # 14 -0601 125.00 Norb & Sons Electric Refund Escrow Permit # 13 -1998 (415 Hi Lusi Ave) 125.00 Parvin Clauss Sign Company Refund Escrow Permit # 14 -0138 (111 E Busse Ave) 125.00 R &G Development Group Inc Refund Duplicate Payment 250.00 Regal Roofing Service Refund Escrow Permit # 14 -0355 (1516 River West Ct) 125.00 Rick's Sewer & Drainage Refund Escrow Permit # 13 -2392 (350 We Go Trl) 125.00 Suh, Duckin Third District Circuit Court US Waterproofing Inc Vanguard Heating & Air Condition Inc Welch, Janet Yarwood, Corbin Your Plumbing 073 Escrow Deposit Fund Total Grand Total Refund Escrow Permit # 14 -0199 (1402 Small Ln) Refund Escrow Permit # 14 -0540 (1480 Brownstone Ct) Refund Escrow Permit # 13 -2393 Bond Check 5/1/14 Bond Check 5/6/14 Bond Check 5/8/14 Bond Check 5/13/14 Refund Escrow Permit # 13 -0667 (1020 S Lancaster Ave) Refund Escrow Permit # 13- 1071(404 Mac Arthur Blvd) Refund Escrow Permit # 14 -0188 (415 Hi Lusi Ave) Refund Escrow Permit # 13 -1427 Refund Escrow Permit # 14 -0437 Refund Escrow Permit # 14 -0400 (204 S Pine St) 125.00 125.00 125.00 690.00 1,920.00 840.00 2,545.00 125.00 125.00 125.00 100.00 125.00 125.00 $ 11,617.91 $ 2,893,525.07 Page 9 of 9