Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
3. Monthly Financial Report & Approve Bills 08/19/2014
IL Mount Prospect Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: FINANCE DIRECTOR ATE: AUGUST 15, 2014 SUBJECT: MONTHLY FINANCIAL REPORT — JULY 2014 Attached hereto are the cash position and investment statements of the Village for the month ended July 31, 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 (page 1) This report provides a detail summary of cash and investments for the Village broken out by governmental and enterprise funds and trust and agency funds. Governmental funds include the General Fund, Special Revenue Funds, Debt Service Funds, Capital Project Funds and Internal Service Funds. The Enterprise Funds consist of the Water /Sewer Fund and two (2) Parking Funds. Trust funds include the Village's two public safety pensions (Police and Firefighters') while the agency funds include the Escrow Deposit, Flexcomp Escrow, Special Service Area and Library Bonds Escrow Funds. The Escrow Deposit Fund accounts for refundable deposits held by the Village to ensure completion of public improvements. The Flexcomp Escrow Fund accounts for employee payroll deductions pursuant to a Section 125 flexible compensation plan. The Library Bonds Escrow Fund accounts for the accumulation of monies for debt service payments. Governmental and Enterprise Funds - Cash and cash equivalents at June 30 was $41.3 million. During July, cash receipts totaled $8,250,430. In addition investment income for the month was $1,944 and inflows due to Interfund activity totaled $54,098. Reductions in cash and cash equivalents during July totaled $8,712,492. Of this amount, payments to vendors were $6,576,677, employee payroll and related expenses were $2,129,688. There were also other disbursements totaling $6,127. Cash and cash equivalents at July 31 were $42.7 million. Monthly Financial Report — July 2014 August 15, 2014 Page 2 Investments in the Governmental and Enterprise Funds at June 30 were $8.1 million. $1.7 million worth of CD's matured during July. CD's in the Governmental and Enterprise Funds reside in the Street and Flood Control Funds and 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 July 31 were $6.3 million. Total cash and investments for Governmental and Enterprise Funds at June 30 were $49,384,169. Cash and investments at July 31 totaled $48,978,995. This is a decrease of $405,174 for the month. Trust and Agency Funds - Cash and cash equivalents at June 30 was $4.7 million. During July, cash receipts totaled $1,376,506. In addition investment income for the month was $40,528 and outflows due to Interfund activity totaled $54,098. There was also a net decrease in cash due to investment activities of $500,098. Reductions in cash and cash equivalents during July totaled $792,369. Of this amount, payments to vendors were $203,858, employee payroll and related expenses were $570,877, and payments related to the flexible spending program totaled $13,420. Other disbursements during the month were $4,213. Cash and cash equivalents at July 31 were $4.7 million. Total investments at July 31 were $109,371,785, a decrease of $220,588 from the prior month. There was an unrealized investment loss of $720,685 and a transfer from cash of $500,098 that accounted for the change. Total cash and investments for Trust and Agency Funds at June 30 were $114.3 million. Cash and investments at July 31 totaled $114.1 million. This is a decrease for the month of $0.2 million. Summary of Cash Activity by Fund Type (paae 2) This report provides a breakdown of the cash activity for the month broken down by fund type. This breakdown is useful in identifying where the activity (receipts and disbursements) is occurring. There are times during the year when activity in certain funds such as the capital improvement and special revenue funds is higher than normal. This will distort the financial picture of some of the other components of the governmental funds such as the General Fund which tends to be more level and predictable in terms of spending and receipt of revenue. Each month the report will provide detail explanation on activity of the General Fund, the Village's primary operating fund. The report will also provide additional information on fund types that experienced higher than normal activity for the month. Each of these is highlighted below. General Fund — Cash and cash equivalents at June 30 totaled $8,191,437. During July, cash receipts totaled $4,791,844 and investment income was $127. Significant cash receipts included property taxes, sales taxes and the state income tax. The Village began receiving the second installment of 2013 Property faxes during July. A total of $2,997,173 was received in the General Fund during the month. This is the third year in which the second installment property tax will be received by taxing districts on schedule. I believe we can expect this schedule of distribution into the future. H:WCCT\Treasurer's Report\2014 \Monthly Cash Position Report - July 2014.docx Monthly Financial Report — July 2014 August 15, 2014 Page 3 Sales tax revenues for the month totaled $1,175,471. Of this amount, $1,065,629 was generated from the 1% state portion while $109,842 was generated from the .25% home rule portion. The state portion showed an increase of 21.7% from last year same time and is up 17.5% year -to -date. The home rule portion is showing an increase over the prior year of 4.3 %. The difference between the two sales tax sources in their change from prior year is due to the tax being assessed on a different set of goods. We will continue to monitor this important revenue source and report if the positive trend continues. Sales taxes received in July are for April sales as there is a three -month lag in getting this distribution from the state. State income tax receipts for July totaled $818,703. Monthly receipts were 11.4% below the same period last year. For the year, income taxes are tracking at 2013 levels. At this time the State is delinquent two months in remitting this tax to the Village. This is a great improvement from months past where the State has been behind by as many as 4 months. The estimated amount of the delinquent taxes is $795,000 Disbursements from the General Fund for July included payments to vendors of $2,044,424 and payments for employee wages and benefits of $1,877,104. Cash and cash equivalents at July 31 were $8,417,971. There were no investments in the General Fund at July 31. Statement of Investments (Pape 3) This report provides a breakdown of investments by governmental and enterprise funds and trust and agency funds. The report also provides a fund -by fund breakdown of the investments. Government and Enterprise Funds - 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 page three 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. H:\ACCT\Treasurer's Report\2014 \Monthly Cash Position Report - July 2014.docx Monthly Financial Report — July 2014 August 15, 2014 Page 4 Investments in equities consist of mutual funds spread across various sectors (small, mid and large -cap stocks) as well as investment philosophies (value, core and growth). The 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. Maturity Purchase Financial Date Date Institution POLICE PENSION FUND (070) Various Various Wells Fargo Various Various Various Investment CUSIP/ Interest Market Description Acct # Rate % Value Wells Fargo Investments Various Various $ 22,570,950.63 Mutual Fund Investments Various Various 32,238,301.83 54,809,252.46 FIRE PENSION FUND (0711 Various Various Wells Fargo Various Various Various CI Wells Fargo Investments Various Various 20,951,667.71 Mutual Fund Investments Various Various 33,610,864 51 54,562,532.22 $ 109,371,784,68 Investment of the Village's pension funds is governed by an Investment Policy adopted by each Pension Board. The investment policy for both the pension funds was updated in January 2011. Conclusion This cash position report is intended to provide a snapshot of the Village's cash position as of a particular month end date. Maintaining strong cash balances allow the Village to weather delays in receipt of revenues or cover unanticipated /unscheduled expenses. Please review the information and contact me with any questions. David O. Erb Finance Director H:WCCT\Treasurer's Report\2014 \Monthly Cash Position Report - July 2014.docx VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended July 31, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and Cash Total Cash and Equivalents Investments Investments Balance at June 30, 2014 $ 41,305,883.63 $ 8,078,285.08 $ 49,384,168.71 Cash receipts 8,250,43024 8,250,430.24 Investment income 1,944.28 845.52 2,789.80 Transfers from investments to cash 1,750,645.52 (1,750,645.52) - Transfers to investments from cash .. -- Interfund activity 54,098.41 54,098.41 Disbursements: Accounts payable (6,576,677.23) (6,576,677.23) Payroll (2,129,687.69) (2,129,687.69) Other (6,127.00) (6,127.00) Balance at July 31, 2014 $ 42,650,510.16 $ 6,328,485.08 $ 48,978,995.24 TRUST AND AGENCY FUNDS * Cash and Cash Equivalents Investments Balance at June 30, 2014 $ 4,662,489.27 $ 109,592,372.56 Cash receipts 1, 376, 505.66 Investment income (loss) 40,528.24 (720,685.41) Transfers from investments to cash 1,032,190.31 (1,032,190.31) Transfers to investments from cash (1,532,287.84) 1,532,287.84 Interfund activity (54,098.41) Disbursements: Accounts payable Payroll Flex spending Other Balance at July 31, 2014 (203,858.09) (570,876.57) (13,419.99) 4.„ 213.42) 1, 376, 505.66 (680,157.17) (54, 098.41) (203,858.09) (570,876.57) (13,419.99) (4,213.42) $ 4,732,959.16 $ 109 „371 „,784.68 $ 114,104,743.84 * Assets are restricted in purpose and do not represent discretionary assets of the government. Total Cash and Investments $ 114,254,861.83 1 N VILLAGE OF MOUNT PROSPECT Summary of Cash Activity by Fund Type For the Month Ended July 31, 2014 INVESTMENTS =JER'NMENT.A AND EN 1E PRISE FUNDS Certificates of deposit - 6,328,=185.08 Wells Fargo Investments 6,328,485.08 - 6,328,485.08 Mutual fund investments 43,522,618.34 43,522,6'18.34 TRUST AND AGENCY FUNDS " 65, 849,166.34 - 65, 849,166.34 Total investments SPECIAL REVENUE DEBT SERVICE CAPITAL PROJECTS ENTERPRISE INTERNAL TOTAL GOVT AND ENTERPRISE FIRE AND OTHER TRUST CASH & CASH EQUIVALENTS GENERALFUND FUNDS FUNDS FUNDS FUNDS SERVICE FUNDS FUNDS POLICE PENSIONS AND AGENCY FUNDS TOTAL Beginning balance Cash receipts $ 8,191,437 05 4,791,844.33 $ 3,396,381 49 619,63120 $ 47-- 429 4 $ 2 $ o. 13 55 $ ` } 538 u53 38 $ 41,305,883.63 $ 3,232,534 04 $ 1 $ 45,968,372.90 Investment income 12738 59.19 530.041 16 306 89 =1 805.60 52 19 14.940; 35 8,250,430.24 1,300,780.09 75,725,57 9,626,935 90 Transfers From investments - - 1,750.645 52 12147 827 58 1,94428 40,360.56 16768 42,472.52 Transfers to investments _ e 1,750,645.52 1,032,190 31 - 2,782,835 83 interfund Disbursements - other (637,782.76) (6 127 00} 49,524 33 ' 19 30 } - (166,55282} 816A28.96 - 54 ; 09€,41 (1,532,287.84) 39,45746 ( ) - (14,640.95) (1,532,287 84) 000 Disbursements - flexible spending fi,`27:UG} (4,213,42) (10,340 42) Disbursements - payroll (1,877 104:02} 1 1C .29) (162:011-74) (13,419 99 ) (13,4 19.99) Disbursements - accounts payable (2044,424 26) {421. 44 -7 -80) a <� °" (1 9 2.16; s8� °31.621 (fi 1R° 5�; 2,129,687 69 ( } (570,876 57} - (2,700,564.26) „ 89, 17; 179) (6,576.677.23) (98,028.50) (105,829:59) (6,780,535.32 -) Ending balance 8,417,970,72 3,622,739. 12 1,004-473 66 13,104,918.79 5,757,990 03 10,742,417 84 42,650,510,16 _ 3,365,214:63 1,367,744.53 47,383,469.32 INVESTMENTS Certificates of deposit - 6,328,=185.08 Wells Fargo Investments 6,328,485.08 - 6,328,485.08 Mutual fund investments 43,522,618.34 43,522,6'18.34 65, 849,166.34 - 65, 849,166.34 Total investments 6 3'8,485.08 6,328,485 08 109,371,784.68 115,700,269.76 TOTAL CASH AND INVESTMENTS $ 8,417,970.72 $ 3,622,739.12 $ 1,004,473.66 $ 19,433,403.87 $ 5,757,990.03 $ 10,742,417.84 $ 48,978,995.24 $112,736,999.31 $ 1,367,74 $163,083,739.08 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of July 31, 2014 GOVERNMENTAL AND ENTERPRISE FUNDS Maturity Purchase Financial Investment CUSIP/ Interest Market Date Date Institutio Descrip FDI # Rate % Value STREET IMPROVEMENT CONSTRUCTION FUND (23) Various Various 32,238,301.83 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 833985.08 FLOOD CONTROL CONSTRUCTION FUND (024} 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 -IMN4A 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 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% 249,300.00 5,494,500.00 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS $ 6,328,485.08 TRUST AND AGENCY FUNDS * Maturity Purchase Financial Date Date Institution POLICE PENSION D (070) Various Various Wells Fargo Various Various Various FIRE PENSION FUND (071) Various Various Wells Fargo Various Various Various TOTAL TRUST AND AGENCY FUND INVESTMENTS Investment CUSIP/ Interest Market Description Acct # Rate % Value Wells Fargo Investments Various Various $ 22,570,950.63 Mutual Fund Investments Various Various 32,238,301.83 54,809,252.46 Wells Fargo Investments Various Various 20,951,667.71 Mutual Fund Investments Various Various 33,610,864.51 54,562,532.22 $ 109,371,784.68 * Assets are restricted in purpose and do not represent discretionary assets of the government. VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES July 01- July 31, 2014 Account Gass ,ficanon F-I lo 001 - Geoer- Rmd RLVEW�E , �ronoil ,, , a� & & F, :a i, i I a 14,674,466.00 .00 14,674,466.00 2,997,173,13 .00 10,387,699.66 4,286,766.34 71 9,024,670.92 8,241,500.00 M 8,241,500.00 545,330.26 '00 3,356,497.94 4,885,002.06 41 3,283,655.44 1fi21,000.00 M 1,621,000.00 128,495,83 .00 1,072,323.71 548,676.29 66 2,102,375.64 18.083,100.00 .00 18,083,100.00 2,028,287,96 .00 7,510,388.48 10,572,711.52 42 6,874,691.73 1,516,000.00 .00 1,516,000,00 148,021.23 .00 852,748.95 663,251.05 56 836,178.33 491,000.00 .00 491,000.00 24,384.32 .00 259,005.66 231,994.34 53 279,97152 22,500.00 .00 22,500.00 293,33 '00 2,712.12 19,787.88 12 8,230.67 226,000.00 '00 226,000,00 9,996.86 .00 257,080.99 (31,080.99) 114 135,105.81 918,500.00 .00 918,500.00 31,708.72 .00 183,520.55 734,979.45 20 164,727.17 20,000.00 '00 20,000.00 .00 .00 M 20,000.00 0 .00 R E V N.- E' 0 T A.- S $45,814,066M $0.00 $45,814,066.00 $5,913,69L64 $0.00 $23,881,978.06 $21,932,087.94 52% $22,709,609,23 - al� 6.00 $0.00 $45,814,066.00 $5,913,691.64 $0.00 $23,881,978.06 $21,932,087.94 $22,709,609,23 im", 001 - Gene!'W Fund oi� $45,814,06 [a tion Revenue Buda PEA A C-lassificall' 0 _1 'M pr: ra. Year f%t 1VI I r A 9 Adop'ed B d g et d C YTD aet TD Y. -1 % Usea inns b's Rec a v BWget Aei:cnneil� Budge En -3 "°. - , . a isa Y R V ;- N OD2 Debt aj� 2,237,000.00 '00 2,237,000.00 445,887.18 M 1,592,313.84 644,686.16 71 1,238,366.22 1,056,532M 00 1,056,532.00 86,219,65 '00 303,81237 752,719.23 29 201,50537 43,005,00 00 43,005.00 '00 -00 21,927.64 21,07736 51 21,573.2 400.00 00 400.00 3.06 00 36.95 363.05 9 89.14 .00 00 M .00 '00 3,231.19 (3,231°19) ... .00 $3,336,937,00 $0,00 $3,336,937,00 $532,109,89 $0.00 $1,921,322.39 $1,415,614.61 58 $1,461,533.911 $0.00 $3,336,937.00 $532,109.89 $0.00 $1,921,322.39 $'_ $1,461,531911 Revenue Budget by Account Classificati Repo Acco! m Q=sslfi awn �_ ,EVE Nu i,,`i'r i ki REVENUE — OTAL .y s -° Callitel f m ove =t' - -e.. Fum 1,246,000.00 ,00 1,246,000.00 101,681.43 ,00 358,295.53 887,704.47 29 346,977.96 .00 M ,00 .00 M .00 .00 + ++ 91,171.05 1,000.00 M 1,000.00 36.83 .00 326.86 673.14 33 422.34 ,00 ,00 .00 .00 ,00 .00 M + ++ .00 10 ,000.00 ,o0 10,000.00 ,00 .00 89,970.00 (79,970.00) 900 283,23100 00 .60 .00 .00 .00 .00 ,00 + ++ . $1,257,000.00 $0.00 $1,257,000.00 $101,718.26 $0.00 $448,592.39 $808,407.61 36% $721,80 $1,257,000.00 $OQO $1,257,000.00 $101,718,26 $0.00 $448,592.39 $808,407.61 $721,80435 m ■ i ca - Revenue Budgel bv- Nr..coun+l,. Class"k, rim on Rer-)o- t '71- Prior n mar �J 'Alm; cum n. M o n'; D B far Rpc v P - Yca rAo '00 00 00 '00 .00 A '00 '00 .00 -00 00 .00 '00 122. .00 00 00 -00 00 '00 A ++. .00 00 00 00 '00 00 A .00 .00 $0.00 $0.00 $0,0 $0,00 $000 $0.00 $0.00 +++ $-7,22 MOO $0;00 $0.00 $0.00 $0 n'. $0.00 «@ A-CcOunt ClaSsificadon 02 newntuwi- REVENUE RE DowwowwIl k�dl-vidow"f")t; oo- ou mn Revenue Budd by Act-count Classi"cath Re!,)o.rt Thrw,ioh 07131 i o r a Y -ci r A c ty 1 c I t'll d e Sulmmary List-inn Ado-Itea Budge. Annen led m'm Mont M Budget - YTD ' u sed YT D Tra. saction 'EmunioranceS nsacho is . 'ansa lo YID Budget AM-E I Budge'v u ..a Rec e-, 2,671,000.00 -00 2,671,000.00 455,715.68 .00 1,707,807.46 963,192.54 64 1,774,765.36 1,000,00 M 1,000,00 24.89 .00 209.03 790.97 21 404.40 .00 M .00 .00 .00 -00 .00 + ++ .00 M .00 .00 M .00 '00 .00 + ++ .00 M .00 .00 M .00 '00 .00 + +t .00 $2,672,000.00 $0.00 $2,672,000.00 $455,740.57 $0.00 $1,708,016.49 $963,983,51 64% $1,775,169,76 $2,672,000,00 $0,00 $2,672,000.00 $455,740.57 $0.00 $1,708,016.49 $963,983.51 $1,775,169.76 Em A F ul rt'Gasssf car en B J.ar r,jie_ dinents B B °e;d0et ansedti ,4 T :o . ?. an - es '-a, sac..„ Is .'an i` o s , c'd O'OF ear Y .00 2,057,000.00 164,474,76 00 738,859,85 1,318,140,15 36 557,588.06 00 1,045,000.00 26,023,43 .00 964,373093 80,626,07 92 .00 00 .00 .00 .00 000 .00 ... 3,611.52 00 100.00 478,14 00 3,517.49 (3,417049) 3517 56.82. .00 .00 ,00 .00 .00 .00 + ++ .00 ,00 6,000,00 10,484.00 .00 58,420.93 (52,420.93) 974 10,970.09 .00 6,500,000.00 .00 .00 6,540,700082 (40,700.82) 101 .00 !po 00 $9,608,100.00 $201,46033 $0.00 $8,305,87102 $1,302,226.98 86 °p572,226,49 $0.00 $9,608,100.00 $201,460,33 $0,00 $8,305,87102 $1,302,226.98 $572,226.49 A C 0 ON - Hood "Onvol C wisiructior UVENUIE W' -Oz) .F 'jDT�'-,� vENU , L, ,. c 0 24 - M d C-a o i Coa 5; Wuli on � u hd j m Revenue Budget by Account Classification '00 83,238.44 206,229.56 29 176,043.31 M .00 Report M .00 .00 Th 0-00h 07 t.+ .00 r or I iscal C u rl d Yeaw Act vltv Ini M .00 .00 mary 1 On q L A k ern uzoed C"urrend Monm +t+ YTD P U d g e Y . D Q! Ailiencnew Budger ansa �Pt E rn rnmrancles 1,113,23 Tr a P, S ac� o Re 'c Prior Year YrD 289,468,00 .00 289,468.00 23,622.41 '00 83,238.44 206,229.56 29 176,043.31 M .00 -00 M .00 .00 .00 t.+ .00 M '00 M .00 .00 .00 .00 +t+ .00 500,00 .00 500,00 1,113,23 .00 7,589-56 (7,089.56) 1518 2,337.74 .00 .00 .00 M .00 '00 .00 ... .00 .00 .00 M M '00 M .00 ... .00 $289,968.00 $0.00 $289,968.00 $24,735.64 $0.00 $90,828.00 $199,140.00 31% $178,381.05 $289,968.00 $0.00 $289,968.00 $24,735.64 $0m $90,828.00 $199 ; 140.00 $178,381.05 09 ftaw i Revenue Budget bv- Accoum Cl-ssfficaU ion 00 240,778:57 ReDort 70 1:318 2,900,000.0 0 1 1 A 2,700,000,00 20 00 1 1, 57 ear n Ll j 25,000:00 00 231 3,225A7 00 16,248:52 8,74 p I ons am:es Traflsa--C, E; rs I —IsLi Rec a Pnc, �-a, Y." lr� 342,000.00 '00 342,000,00 66,80197 00 240,778:57 101 70 1:318 2,900,000.0 '00 2,700,000,00 20 00 1 1, 57 1J84,401-57 25,000:00 00 231 3,225A7 00 16,248:52 8,74 65 0,766-92 500M M KOM 4 1:x6 00 4I1:93 88.07 82 280-58 .00 '00 OO 1 4 7. 48 00 294:96 (294:96) + ++ 289:18 359 .00 359r000:00 38,59333 00 196,538:98 162,461-02 - 35 2 1- $3,626 $m0 $3,626,500,00 $310 $0.00 $2J08,917,60 $1 58% $2,728 $3,0 $0.00 $- $310-198:72 $0 .00 $2,108,917M AO 5AO $1,a27, $2,728,Q939 mn Remoort 0 =J 3_.,�, � c _ 3 Ae b a- V E n Accau _ C au_, -; a w.. °Bs,c, ;._ Ame t� Budget m sad n_ . .Y °ances s ; M -.w 'u ea , r..D ` El ..v._. ;,,_... -. ;... R_,;:.!; 1,290,000.00 .00 1,290,000.00 105,437.20 .00 905,788.52 384,211.48 70 636,162.04 .,,_....._ e. Cone 100.00 .00 100.00 4.80 .00 16.78 83.22 17 100.39 Rki IT, bu - se o;? nocs 6,000.00 .00 6,000.00 1,219.80 .00 8,090.57 (2,090,57) 135 3,932.52 Rte` A $1,296,100.00 $0.00 $1,296,100.00 $106,661.80 $0.00 $913,895.87 $382,204,13 71% $640,194.95 f 041 Moto Fuel _a °, � $1,296,100.00 $0.00 $1,296,100.00 $106,661.80 $0.00 $913,845.87 $382,204.13 $640,194.95 El v - A ccou nt Ref i i ` , " I - i da r d I11= .Et1L- :=udgje "I ansaci_ons s._ri P _,. <_. : .a: u�_.�.._ = „3_� <�.r� 'Z _Y' N v` .E- - 293,202:aa 97,171:x0 390,373100 -00 .00 .00 390 a 42,505:88 030 0G; ,aa '00 ,00 .xa .00 + ++ :xa 60,000 -00 010 60 29,945:x0 00 128,858,_2 (68,858:12) 215 74,906:18 35 ,102.0 $9.,_..aa 450 $29,945.00 $0 00 $ 128,858-12 $ -- . $321,514:88 2910 117,412:06 X35= - 2.Q0 ST - - - 7; 3._¢ $0.00 $128 $321 i' Account Classi'ication REVE Mul' & I Revenue Buciget by Account C.assification Report. - -j 1� A U rh . B 119-11 'y0ear Adj n iAnA u m m a LIS."ing Ad c ptaa Budget Amiended Current Wnt.. YM `TL Budge' - —,rD 91'(, used/ ftdge kne. dments Budget ^ransact ions Eriajmbrance5 ransac"ons T ransacxions Rey, d L-io Yearm ZMMO M LOOM .00 2,000,00 100.00 .00 .00 62 .00 42,778,96 9.08 (40,778.96) 2139 90,92 9 9,200.37 6.61 � $0.00 $2,100,00 $0.62 $0m $42,788.04 ($40,688.04) 2038% $9,206.98 - 2,100M $mo $2,100.00 $0162 $0.00 $42,788-0 '$-0 $9,206.98 I _E 2 F i 0 Revenume Budget by Akiccount Classification Report ty - Moa Buoqc� A 1 P, de o Cu"Fent Mon YM B-1 - 0 % B�,' Acnemd msie! Buc!"gat 'a�samlors c'd Pr! o. Y�a - L' Tra, -a— c 1� ror�E!Mo 100,00 '00 100.00 .00 00 24,63780 (24,537M) 24638 100.00 M 100.03 1.52 00 12-20 87.80 12 -,W $ Cli 0 0 $200.00 $1.52 $0 oo 124,650:00 ($24,-150.00) 0 / 0 1232 $200.00 $0m $200-00 $1-52 $Ozoo $24 t' 24;450.00) Acccun Classificabof. 04S - DUII Fiml, Fund R -VE _ .J, F: R-1 REVENUE . OTALS d 'Ar 045 - OUX Fine �und folo.� 20,000.00 .00 20,000m 4,392.97 .00 18,212.79 1,787.21 91 12,701,65 100.00 .00 100.00 2.17 .00 25.37 74.63 25 .00 $20,100.00 $0.00 $20,100M $4,395.14 $0.00 $18,238,16 $1,861.84 91% $12,701.65 $20,100.00 $0,00 $20,100.00 $4,395.14 $0.00 $18,238.16 $1,861.84 $12,701.65 m lon t Classificati Revenue by Accauln Reiclort -1 0 1 / J r c sca t d� --d- Pv_ -IV! Ly &Oge Anne ded Curren Mo Y__D M B-leciet - .Sed/ 1 S11 C 0' Mc,'gr-H AffleMMe.-IS Budget annsact'cns curub 'id c'd D'o, l ea , — D . � . � A 13 . R F V E NU- T Fs 70,000,00 '00 70,000.00 28,935.18 AO 30,135.18 35,864.82 43 29,876,35 1,000m M 1,000.00 6.78 )0 70,28 92972 7 .00 M M M M )0 '00 M ... 45M M M .00 .00 _)O 00 '00 ... '00 $71,00100 $0m $71,000.00 $28,941.96 $0.00 $30,205,46 $40,794,54 43% $29,92131 f 3; =0.00 $0,00 $71,000.00 $28,941,96 $0J0 $30,205.46 $40,794.54 �29,K175 k-ounl Oacciricat.o DFVENU 04 - .'E-�tkk Ass'su.Mcu Cizm, T I Revenue Budget by Account Classification Report W �-- l I hrolug Pe :4-y R R y 1V -cai Par Aa 3 H lu marvi Listina k'o 0 c e' A Yl - -I LGI Que-'e'l, yM' YTID B-cice YTD 05� I �ucu ON i �aps�ffors - 0 wsr, c e s - Rec�-Il P Yea; YTD 00 -00 -00 '00 -00 -00 ,00 00 M .00 -00 .00 .00 .00 3 3 .00 $M0 $0;00 $0.00 $0.00 $0.00 $0.00 $0.00 ... $0.00 $0;00 $0;00 $0.00 1',50.00 MOO $0.00 $0.00 $0.00 Revenue Buclllget by Aacount Classification R 1 eport I na clied -xa Ye a cls ull m a ry .-is A z Mlont YTD BA et YTD % - -- D n d mw s6C- a: RecA Ya Y. wj- Ame T e ra �sdd �-� Drd--Ces 943,000.00 -00 943,000,00 111j83122 i%O 415 527,185.62 44 372,576.81 100.00 '00 100,00 1,74 -00 19.29 80,71 19 52.19 .00 -00 M '00 00 .00 M ... .00 $943,100,00 $mo $943,100.00 $111,834.96 'PQ00 $415,833.67 $527,266.33 44% $372 $943,100M $0.00 $943,100.00 $ 111, 834,96 $0,00 $415,833.67 $527,266.33 $372,734.00 Ac-Count C.asc fication n r a d Sawe himl REVENUI I Revenue Budget by Account Classification Renort Th rl) ug h 07 r CIL,-de--1 Pr'or Fiscal Year AcU' IIA .00 1,530,000.00 263,436.25 17,000.00 17,000.00 12,711,000.00 & 100,000.00 997,176.48 1,100.00 100,000.00 1,000.00 R" 25,000.00 115.09 .00 RP, NUE .00 L - Zelmar � wnil .- 5,f .60 I Revenue Budget by Account Classification Renort Th rl) ug h 07 r CIL,-de--1 Pr'or Fiscal Year AcU' IIA .00 1,530,000.00 263,436.25 .00 17,000.00 1,620.00 .00 12,711,000.00 997,176.48 .00 100,000.00 8,404.78 M 1,100.00 115.09 .00 1,000.00 .00 .00 25,000.00 6,493.07 .00 .00 .00 $0.00 $14,385,100.00 $1,277,245.67 ;-0. . o o X14,355,1 =0.99 $1,277 M 1,073,697.27 456,302.73 70 1,070,359.23 '00 11,080.00 5,920.00 65 10,330.00 .00 6,616,806.31 6,094,193.69 52 6,443,077,92 .00 61,543.47 38,456.53 62 68,954.02 .00 1,048.01 51,99 95 554.82 .00 (131.00) 1,131.00 -13 9,834.52 .00 41,089.60 (16,089,60) 164 23,853.28 .00 .00 .00 . ++ '00 $0.00 $7,805,133.66 $6,579,966.34 54% $7,626,963.79 $0,00 $7,805,133.66 $6,579,96634 $7,626,963.79 m Ac_ -- Budget by Alccount Classification Retiort Tk I A Ad Ad oP e c A P Q Acr— fl, YT[) B, - D BL�ooe B U U`g e 5 A 91; -':-� S F W, es a ct i ro m- a:i��ac' ,- Re i � Yea' Y L. ns --�o 10,000.00 .00 10,00mo 816.06 .00 2,875.57 7,124.43 29 3,057.08 115,000.00 .00 115,000,00 10,82.9.56 M 77,297.52 37,702.48 67 73,347.56 100.00 M 100.00 638 .00 58.84 41.16 59 15.69 6,600,00 M 6,600.00 550.00 .00 3,850,00 2,750.00 58 3,850,00 '00 00 M '00 00 M M '00 s 13- - A $mo $131,700.00 $12 $mo $84,081.93 $47,618.07 64% $80,27033 7 0M, $0,00 $131,700,00 $12,202,30 $0m $84,081,93 $47,618.07 $80,27033 Revenue Budget by Account Classification Report Through 01 731/.4 Accoun Cass&k. 092 - Par kin a Swam Revenue in d R-VENL:E g Reven-ie ti es C" P REVENUE TOIA"S ?'umd 052 - Parking System Revenue Fund 90,000.00 .00 90,000.00 7,344,57 M 25,880.11 64,119.89 29 27,513.67 .00 M .00 '00 .00 .00 .00 ... .00 112,000.00 M 112,000.00 11,400.45 M 68,407.01 43,592.99 61 64,934.49 100,00 '00 100.00 .00 M .00 100.00 0 1.62 .00 '00 '00 .00 .00 .00 .00 + ++ .00 .00 .00 .00 M M .00 .00 +++ .00 $202,100.00 $0.00 $202,100.00 $18,745.02 $0.00 $94,287,12 $107,812,88 47% $92,44938 $202,100.00 $0.00 $202,100.00 $18,745.02 $0.00 $94,287.12 $107,812.88 $92,449.78 I I Revenue Budget - by Alc.-count Classification Report sui !e-ari v ry n -; 9 ry 111 0_1 _u U Amendec U-1 nt Mort! Y' - D TD EAq, B- -risactons c,.: - _ # c �s ni R i > rls , Yee V. - 'D 3 <OO uu 2,138,317,56 178,193,07 o 1,247 890 58 1279,432.70 X0 .00 '00 44.60 )0 326.02 289- 9 M 00 .00 US 397,00 (397.00 . . . 1 38A0 3,3 $0:00 $ $178 $0.00 $1,248,074,51 $695,242,49 58% $1,279 $0,00 $2,138�317:00 $178,237:67 $0.00 $1,248,0 $890. $1.279,860:29 - D - sac ions Rec d Prior Year Yl T E ..an Accou.- O ass � cat on Bmaet Amen EP Budget x rnhances Transactions .00 1,346,300A mfid 063 - Vehide Relilalumwnt Fmid .00 REVENUE 560,958.24 58 1,346,300M n e n fe.. 10,000.00 M 5,000,00 5,577.72 .00 56 60,000,00 M REVENUE 'Cf'A,S $1,421,300.00 .00 1,346,300A 112,191.68 .00 785,341.76 560,958.24 58 814,683.38 000 10,000.00 M M 5,577.72 4,422.28 56 6,426.28 M 5,000m 535,73 '00 4,136.72 863.28 83 3,185.98 M .00 .00 '00 .00 .00 + +t .00 .00 60,000.00 .00 '00 31,213.00 28,787.00 52 50,228.00 $0.00 $1,421,300.00 $112,727.41 $0.00 $826,269.20 $595,030,80 58% $874,523.64 .0 061, - Vepic -le Reolacarne'lnt Fund RALFE $1,421,300.00 $0,00 $1,421,300000 $112,727.41 $0.00 $826,269.20 $595,030.80 $874,523.64 t1i F- R evenue Bu _ u C lassi f fic atki .00 13,468.00 9,620.00 58 Rea.-Dort 1,000.00 '00 1,000,00 s 'O y = g - __ . 00 432.42 4 o yY3 --ad -"€ c A �i3 L � 34=', C; ..=mod .00 00 .00 H- -a 7` L - m ` .'t._ `' 00 .00 .00 +t+ .00 .. Bw � t ,....w. . . __. .. .. Y . -� - ...- Cr ..<,... 3..42_ ,..- ��'�'.. _, _..,� .�`.. ...e.,.::5 ` ecc d -... 'P2 � 23,088.00 00 23,088.00 1,924.00 .00 13,468.00 9,620.00 58 .00 1,000.00 '00 1,000,00 61.63 00 432.42 567.58 43 407.24 .00 00 .00 .00 00 .00 .00 +t+ .00 - 088 00 �24,�S�d.t -U 0 :0;; ��.�� ��4_.'�8.�_- ,fi e 6� �. u_.vy '�d,._. n �ly_gom2 K.58 u8°:_ It4y • nL _ u : _.. .w - t - 1 44zO88, . , 985763 s ._0 $ .A< Account Classification j 063 � MU r4apagen vil Fun R E V E N C 5 `. v vesime - "nau". e evenue REVENUE TOTALS F. na 063 - Risk ma".'agwilitit Ful-Al I 6,456,273.00 .00 6,456,273.00 533,716.86 M 3,867,001.32 2,589,271.68 60 3,592,002.55 2,000.00 .00 2,000.00 185.62 .00 1,321.83 678.17 66 971.42 1,000.00 .00 1,000.00 .00 X0 '00 1,000.00 0 .00 1,357,600.00 '00 1,357,600.00 111,246.18 -00 776,032.31 581,567.69 57 749,788.54 $7,816 $0.00 $7,816,873.00 $645 $0.00 $4,644,355.46 $3,172,517.54 59% $4,342,762.51 t7 SOM $7,816,87100 $645,148.66 $0.00 $4,644,355.46 $3,172,517.54 $4,342,762.51 I � Budge � Account «.w.. Reve �- \�c\o- -\C R\_F ..«\ - «§19 h j �. ., � . .. `© Pi- H ©© © - ° - : :C a G m :«dry SV iG\i w m .- ... 2m mnd7b� d9 m « Ga« A Y9 wo a«catran eee . . . . . s s- --ate: «e, s 9w r rwn UE c a « c M .e A ,e .g 2 A + A «x«ur« 3 .e 3,415,900:00 7 821 .6 1:0,313:88 % .aB;J! g ± -7 , A M � 3,742,224-00 3:, A .e a ,802,3 ! 1-3 e 2,31%8229 -� - ®- �- , ... .. _ ... . mm e 825 vx a , - � : c &A $7,158,124M ($95 $0 $ g a $2 ; 59% $6!A .» s« y> - fLa k m m 6w » 17j-58.124:00 w $7,158,!24,00 i$95,909:29) $ 0 $4,194.4 E s .O .6 x Accounr Classiftabon umd 071 - :re- pensiml Fund R E V E NU E 0 Revenue -on - Revenue Btl ge* bv Account Classificatt' Report Thr i ig . 07i-,"11A ou h P Yeat Ad nch P '0 S m m a ry L I s t n - D - D MOD Su ace( Amended (,urge 3f Mcn.- T Y! ffiluger - Yl D I�Io usedi c' r—aget Ame Orrent'. Budget ansact wS Encumbrances Transactions tansacrlonS Re d Prior Year Yr'D 3,165,200.00 .00 3,165,200.00 193,139.93 M 2,450,137.03 715,062.97 77 2,487,688.75 3,079,042M .00 3,079,042.00 551,038.16 M 2,117,361.25 961,680.75 69 2,012,226.99 R-EVMUE TO M S $6,244,242.00 $0.00 $6,244,242.00 $744,178,09 $0.00 $4,567,498.28 $1,676,74172 73% $4,499,915.74 Fund 151 - Fire Paaskwi Fund o flzi $6,244,242.00 $0.00 $6,244,242.00 $744,178.09 $0.00 $4,567,49818 $1,676,743.72 $4,499,915.74 8 -12,217-00 S97, - MM $ 108,909, $1.2 0,715,9971 MOO i �0,517,7141.00 1 - - 45,39L 674,00 $56,230,131,41 E, Account Classiflcarion - j Oull- - General I EXPENSE - l'OTALS , ::i:wa 001 - Cemeral Fund 23,919,744.00 .00 23,919,744.00 2,903,237.15 .00 13,748,625.83 10,171,118.17 57 12,347,651.10 12,344,314.00 .00 12,344,314.00 1,910,657.89 .00 8,130,166.91 4,214,147.09 66 7,398,504.03 415,005.00 (1,275,00) 413,730.00 20,116.85 13,224.62 180,439.66 220,065.72 47 166,494.75 46,301.00 .00 46,301.00 3,858.36 '00 27,008,52 19,292.48 58 26,920,67 7,001,321.00 133,233.68 7,134,554.68 683,997.26 499,914.54 4,067,733.53 2,566,906,61 64 4,192,036.11 262,282.00 .00 262,282.00 7,201.72 .00 96,005.42 166,276.58 37 84,292.16 350,519.00 .00 350,519.00 29,213.15 .00 204,491.75 146,027.25 58 201,327.98 627,855.00 61,600.00 689,455,00 37,898.38 24,099.69 313,065,42 352,289.89 49 242,478.40 11,080.00 .00 11,080.00 .00 .00 .00 11,080.00 0 .00 10,000.00 .00 10,000.00 1.08 675.00 1,084.60 8,240.40 18 7,408.61 49,730.00 .00 49,730.00 951.25 .00 7,427.41 42,302.59 15 1,597.67 165,123.00 4,689.32 169,812.32 6,843.90 14,491.45 79,970.58 75,350.29 56 22,712.04 100,000.00 .00 100,000.00 .00 .00 .00 100,000.00 0 .00 510,792.00 3,400.00 514,192.00 16,195.46 173,825.82 219,333.34 121,032.84 76 228,727.99 .00 .00 .00 .00 .00 .00 .00 ... .00 $45,814,066.00 $201,648.00 $46,015,714.00 $5,620,172.45 $726,231.12 $27,075,352,97 $18,214,129.91 60% $24,920,151.51 $45,814,066.00 $201,648.00 $46,015,714.00 $5,620,172.45 $726,231.12 $27,075,352.97 $18,214,129.91 $24,920,151.51 MR Expense Budget by Account Classification Report -2-! XD-- ENSAL 7C - e Fu -d 3. i OGI � DeM as .00 '00 .00 .00 .00 .00 + ++ .00 as .00 .00 .00 .00 .00 100 + ++ .00 1,532,587.00 .00 1,532,587,00 '00 .00 270,780,49 1,261,806,51 18 281,423.35 1,793,429.00 .00 1,793,429.00 .00 .00 766,300.74 1,027,128.26 43 458,346.08 2,484.00 .00 2,484.00 .00 .00 1,258.20 1,225.80 51 428.00 .00 .00 .00 .00 .00 .00 '00 +t+ .00 .00 .00 .00 .00 .00 .00 .00 + ++ .00 $3,328,500 O $0m $3,328,500.00 $0.00 $0.00 $1,038,339.43 $2,290,160.57 31% $740,197.43 $3,328 $0.00 $3,328,500.00 $0,00 $0.00 $1,038,339.43 $2,290,160.57 $7401197.4-3 EXPENSF TOTALS Fund 020 - Capital Improvement Funa Totals M '00 M .00 .00 .00 .00 ... 22,132.60 '00 M .00 .00 '00 .00 .00 ... '00 240,000.00 M 240,000.00 .00 .00 .00 240,000.00 0 .00 637,000.00 73,600.00 710,600,00 70,174.26 136,323,67 165,904.89 408,371.44 43 80,210,64 '00 M M .00 .00 .00 .00 ... .00 M .00 .00 .00 .00 .00 .00 ... .00 304,247.00 16,600.00 320,847.00 17,581.31 6,977.40 150,123.85 163,745.75 49 99,506,57 515,000.00 104,400.00 619,400,00 452.90 14,333.76 29,149.13 575,917.11 7 81,171.40 M '00 M .00 '00 .00 .00 ... .00 $1,696,247,00 $194,600.00 $1,890,847.00 $88,208,47 $157,63+83 $345,177.87 $1,388,03430 27% $283,021.21 $1,696,247.00 $194,600.00 $1,890,847,00 $88,208.47 $157,634.83 $345,177.87 $1,388,034.30 $283,021,21 In— d�l I o n rlass'fkat .Exoense Budget by -Accoun M Rea--.A,,.ol-t I h - UIQ I" Cl 11 ly 1- 4 $0m $1 $0.00 $0,00 $(),00 $0.00 $0.00 —+++ 50,00 $0,00 $mo $0,00 $0.00 $(),00 $0.00 $mo - $mo v PI i Pcal eae Ac-Mtv n-I ir HE ed S Listina AC,�!Ej SuChel Amerlaed - — D I D Budae - V ("Au useW Budne ..anw*uons 0 n 51 ansactions Zec'd 0 .:o - I'la Y D '00 as '00 '00 as +++ ao as '00 M '00 '00 .00 '00 + ++ 00 '00 .00 '00 M .00 + ++ as -00 M M M 00 '00 + ++ .00 .00 '00 '00 '00 .00 '00 .00 + ++ .00 $0m $1 $0.00 $0,00 $(),00 $0.00 $0.00 —+++ 50,00 $0,00 $mo $0,00 $0.00 $(),00 $0.00 $mo - $mo Account Classiflcation 622 -Dow tovva R,-davdo— n im" Cunlstruc` 1 EXP , INS -. - es pa 203,040,00 .00 M .00 2,803,92100 60,000.00 6 240,000.00 .00 .00 cu .00 Oo .00 77 25,044.32 .00 2 52,225.36 6 .00 .00 + ++ .00 M 7% $77 203,040:00 .00 2,863 355 .00 .00 .00 31,192:88 M 3 -00 .00 '00 .00 106 '00 1, 339:75 .00 .00 .00 50,029.02 .00 61,750.05 9,240.00 .00 M .00 46,042.37 .00 2,802,171.95 334,420.25 .00 .00 .00 PENIS M A S $3,12 21 $300,000,00 $3 $3 $118 $121,0M07 s3 EE I $3 21,962.00 $300,000:00 $3 $35,08 $118 $121 $3,182,634.57 0 $77,269.68 am A -- C asc c p 02-- - rorlstrm Fund HXFENSE `L-n- - - Flm- Uon .Expense Budiget. by Accoumt Classifical Re I r UM' I � i (;i I Iscla j ear Ac-tiviLv '11 _ U-sting - D Budget Arnenae� CL' Mo 'n YT D Mice:_ D usea/ - -samons ar.lacUO: Rec PoW ve-- Y B, ena A, M -.o ; nul Bu d g el, ansactiuo Er ,.b 30,600.00 4 1 0 0, 00 71,600,00 1,895.06 28,701.94 42,595,88 302A8 9,943,280.00 -00 9,943,280,00 1,767,584.08 3,280,74115 5,816,635.40 845,901045 M '00 M .00 . 00 '00 .00 100 4 ,519.00 91 454 + ++ .00 92% $458 EXP. T'O'A S $9,973,880,00 $41,000.00 $10,014,880.00 $1,769,479.14 — $3,309,445.09 $5,859,231.28 $846,203.63 1 0 - St t Impruven non t - ofthisup rune -, c $9,973,880.00 $41,000.00 $10,014,88000 $1,769,479,14 $3,309,445,09 $5,859,231.28 $846,203.63 Expense Budget by Account Classification Report 'Accownt CimsificalUon 9 "ood Con' 'a' Conarvojon F-Und 024 EXPENSE Im M -00 .00 M .00 .00 .00 + +. .00 1,000,00 M 1,000m M M 915.87 84.13 92 .00 '00 M '00 .00 .00 '00 ... .00 ofl xqendkuf— 5,000M M 5m000.00 M A .00 5,000.00 0 1 CXN 5 FFu , : - 1 , a!e: - P , .00 -00 '00 .00 M .00 '00 ... .00 10,805,000,00 83,800,00 1 -0,888,800m 606.96 205,996,86 209 10,473,091.29 4 114,92186 EXPENSE TOTALS $30,811 $83,800.00 $10,894,800.00 $606096 $205,996.86 $210,62732 $10 4% $115,92186 K.nd 02a - Flood Cent_ i ConswjWwn Fund [ota. 0, 8 1 i, 000, -00 S83 1 $606.96 $205,996.86 $210,62732 $10,478,175.42 $115 Im m 46 cl 4-i-on x.o.ense B- get by Alhcclount. Classifica Re r%ol t hr— .0 n 4j nr,! Vea Ac D Bu a g et Y b e d. Adw 'ea B 3 v e t Current Month YTD M. A A end� - . - CUmlra; -,- -es Transactions F n5zill. CS l Rec'd Yea -M, 231,735.00 .00 231,735.00 26,596.88 .00 145,361,11 86,37189 63 113,75E21 75,057.00 .00 75,057.00 11,078.52 M 63,63937 11,417.63 85 62,808.73 1 .00 1,224,00 129,00 M 1,224.00 .00 100 .00 4,157,884.00 M 4,157,884.00 350,626,10 12:412 2,233,928.20 1,911 54 2,230,119.82 438.00 .00 438.00 15.50 .00 170.29 267.71 39 175,53 28,640.00 '00 28,640.00 2,386.67 M 16,706.69 11,93331 58 16,472.75 31,295.00 '00 31,295.00 2,362.99 5,575.x0 13,115,53 12,604,47 60 4 e 481096 $4,526,273,00 $0,00 $4,526,273.00 $393,195.66 $17,981.15 $2,474,145.19 $2,034,140.66 55% $2,427,815.00 $4,526,273.00 $0.00 $4,526,273.00 $393,195.66 $17 $2,474,145.19 $2,034,140.66 $2,427,815,00 a Account Classification Og:' - Motor uem Nrid EXP�NSZE ExDense Buidget by Account Classification Repoft I -'-, - pi Oti-q N y. 201 75,000.00 279,104.00 3,322.25 134,809.66 72,770.48 71,523.86 153,000.00 .00 153,000.00 13,850.29 .00 105,016.06 47,983.94 2 84,796:00 .00 284,796.00 14,569.43 12,247.48 231,459.75 41,088.77 910,000:00 5,000.00 915,000.00 .00 .00 10,056,62 904,943.38 74 36,792.95 69 83,269.63 86 147,195.10 1 1,115,000.00 35% $1,382 - XPENSE TZ -- 51,900 $I .0c.. $80,000,00 $1 $31,741.97 $ $419,302.91 $1,065,539.95 I F $419302-91 $1065: U �) Ll 0 4 to r F 0 (z X iL u n il. rl I s $1 $80 $1,631,9OOzOO $31 $ 14 0 5) 7 � 1 j , f $1,382,257.68 E-1 I Ac-OtIml m. lb(imme Mdcet by,kmounf- Classiffical m & R e h- h (I Ac fi u'd-d P Is ca yea- sumrrlairy Listing D YTD murja.ell � y7l) � used, ArdoMed Bur-laie.- Amended —Me. A .0 S M-M MS Budget Mn sa au -- i - ou—b-inces ansol U. RLc'r- Prior Year YTD 47,930.00 00 47,930,00 6,998.72 '00 27,529.24 20,400.76 57 23,793,12 26,222,00 .00 26,222.00 2,557,76 -00 15,017.72 Il 1, 204.28 57 13,979,75 1,020,00 '00 1,020.00 M 00 151.70 868.30 is 350.50 97,520,00 23,250.00 120,770.00 9,851.31 -00 66,507.68 54,262.32 55 2,973.58 510.00 '00 510.00 M .00 .00 510.00 0 111.37 160,000.00 73,921.00 233,921.00 205.00 M 2,100.00 231,821.00 1 108,847.18 M '00 .00 .00 M .00 .00 ... .00 .00 '00 .00 .00 '00 '00 '00 ... M 20,000.00 '00 20,000.00 M 70,OOC.00 '00 (50,000,00) 350 000 $353,202M $97,171.00 $450,373.00 $19,61239 $70,00CM $111,30634 $269,066.66 40% $150,055.50 $353,202,00 $97,171,00 $450,373,00 $19,61239 $70,OOC,00 $111,306.34 $269,066.66 $150,055.50 Expense Budget by Account Classification Repol Account Classl'i -a on 0431 1 - s t Selzore Fund X��Nffi L - ,.C.` ;i er 6 EXPENSr [`OTT_ S 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 3,000.00 .00 3,000.00 2,500.00 .00 4,000.00 (1,000.00) 133 2,000,00 15 ,000.00 .o0 15,000.00 .00 .00 1,642.29 13,357.71 11 7,477.65 s19,000:00 x,0:00 $19,000.00 $2,500.00 $0.00 $5,642.29 $13,357.71 30% $9,477,65 ti 0,00 si %oomo ,Day.1.0 $0.00 $5,6:2.29 $13,357,71 $9,477.65 il I Exoens.e.., Buidget by AccOM ME Classi - -on fE F I rwough 03131.414 ACco. f - W-Acation 0-44 - DEA Sh�ii�xl F!-.r.j Fund �S_ MrA a Vamis i'l I - fl Yea- Activitv Irauded Pr'o- I-sc6 Summary usting Adorrea Bluaget A-e-ded ull Mouth YTD Buaget YT D Ih Useq/ Budget Amend BuO90 - "Mt) - ces an ransacluo'N, Transaadko. Reca rl 0 Yea YT D 1,000m 00 1,000m -00 '00 .00 1,000.00 0 .00 -00 '00 '00 .00 '00 .00 .00 + ++ M 1,000.00 '00 1,000m '00 M .00 1,000.00 0 -00 $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0,00 $2,000.00 0% $0.00 $2,000M $0,00 $2,000.00 $0.00 $0.00 $0.00 $2,000m q;0.0() ion Expense Buclget by Account Cmassifica. Report Accoat Classifi-Labon A 0�5 - DUl' F Fund EXPENSE I 1,000.00 M 1,000.00 .00 '00 .00 1,000.00 0 .00 M M .00 .00 '00 '00 .00 + ++ 2,187.50 10,000.00 .00 10,000.00 .00 '00 2,767.30 7,232.70 28 7,748.17 00 '00 M .00 .00 .00 .00 + ++ .00 EXPENSE OTAL- $11,000.00 $0.00 $11,000.00 to 00 $0.00 $2,767.30 $8,232.70 25% $9,935.67 Fine Fuml -- " $11,000.00 045 DUR i j-- $0:00 $11,000Z00 $0-00 $0.00 $ 76730 $8,232: $9,935.67 I wa 3 Budget- byAcc - g _f y r 0 ° , Cl - J 3 J. 1 4", - __ s i uded =" v Listina, f ACC O., _ `Pa c.: B g ce ; ,. . E P, a ., a ., Yes Tran a.'6ac Recd o , Yea b w €'; E N SE _ ` =r =- 10,000.00 00 10,000.00 000 .00 3,946.60 6,05140 39 2,938.44 500.00 .00 500.00 .00 00 000 500.00 0 .00 - 5,000.00 00 5,000.00 000 .00 211.65 4,78835 4 2,983,58 <ir 15,000.00 .00 15,0 . ,00 11,688.00 3,312.00 78 9,077.00 X ' S TG £_.`_ $30,500.00 $0.00 $30,500.00 - $0.00 $0.00 $15,846°25 $14,653.75 52% $14,999,02 046 : ._: 30 $0.00 $30,500M $o.Oo $(WO $15,846.25 $14,65175 $14,999.02 Account Classifilcat on, 04 JuslUce Ass'stancce Grant Fund EXPENSE 0, E i Fx.pEf TOTALS F'.end 047 - j�iSbCe AsMstanwei,,an.t Fund F_ U M '00 .00 '00 00 M .00 ++ .00 '00 M M .00 M M .00 + ++ .00 '00 -00 '00 .00 M M .00 ++ 471.84 -00 '00 .00 .00 M M .00 + ++ 66.66 .00 .00 .00 .00 .00 M .00 +++ .00 $0:00 $om $0.00 $0-00 $0:00 $Om $0.00 + ++ $53&50 $Om MOO $0,00 MOO $0.06 $0,00 $538:50 a P - XDEN- - F -O_- _- Expense Budget by Aacount Classification _ gg t_ -s B o r y . ,. d t o E„ :o- - _,. , Y FLU tn 1 .:;Lv§ .00 .ao .00 ,00 .00 ,00 M + ++ M 923,100.00 .00 923,1 .00 .aa .00 9 2 3, 100. 00 0 637,231,78 $92 °, -00.00 $0.00 $923,100.00 $ 0.00 x: .00 $mo $923,100.00 0% $637,231.78 _-L ,lactic $0.00 $923,100.00 $mo t,. a $0.00 $923,100.00 $637,23138 p-D T- E 1,952,664.00 .00 1,952,664.00 238,568.62 .00 1,211,464.17 741,199.83 62 1,025,447.30 787,893.00 M 787,893.00 75,793.44 '00 456,666.94 331,226.06 58 430,636.93 36,660,00 .00 36,660.00 752.23 1,436.50 20,167.99 15,055.51 59 11,923.88 7,457,412.00 32,500.00 7,489,912.00 722,535.28 256,949.08 4,120,366.21 3,112,596.68 58 3,592,503.61 157,758.00 .00 157,758.00 11,861.80 .00 69,295.97 88,462.03 44 58,719.61 80,474.00 M 80,474.00 6,706.16 .00 46,943.12 33,530.88 58 46,306.75 295,722.00 M 295,722.00 9,815.68 51,211.40 89,514.88 154,995.72 48 96,689.95 M .00 .00 .00 '00 .00 .00 + ++ .00 42,500.00 M 42,500.00 .00 4,250.00 .00 38,250.00 10 .00 1,370.00 .00 1,370.00 .00 .00 .00 1,370.00 0 .00 1,244,200.00 1,563,500,00 2,807,700.00 563,919.88 1,672,717.63 768,802.72 366,179.65 87 110,114.94 2,075,000,00 581,500.00 2,656,500.00 47,559.86 1,153,352,78 90,987.68 1,412,159.54 47 474,372.53 '00 '00 .00 '00 .00 .00 .00 ... .00 .00 M .00 .00 .00 .00 '00 + ++ .00 M .00 .00 .00 .00 .00 .00 ... .00 .00 '00 .00 .00 .00 .00 .00 + ++ .00 $14,131,653.00 $2,177,500.00 $16,309,153,00 $1,677,512,95 $3,139,917,39 $6,874 $6,295,025.90 61% $5,846,715.50 $14,131,653.00 $2,177,500,00 $16,309,153.00 $1,677,512.95 $3,139,917.39 $6,874,209,71 $6,295,025,90 $5,846,715.50 I I - B -i R - I r o :_� , . 1.= Activity ind de e ,: v . mn- 35,788.00 ,00 35,788.00 4,266011 .00 22,028.93 13,759.07 62 11,769.29 17,796.00 .00 17,796.00 1,940.37 .00 9,47831 8,317.69 53 5,013,6:3 91,055.00 .00 91,055.00 4,631.97 5,16G.94 34,952.33 50,941.73 44 47,75936 1,175.00 .00 1,175.00 97.92 .00 685.44 489.56 58 675.50 510.00 ,00 510.00 170.00 .00 170.00 340.00 33 .00 .00 .00 ,00 .00 .00 .00 .00 ... .00 6,936.00 .00 6,936.00 .00 2,750.80 M 4,185.20 40 .00 153,500.00 000 153,500.00 .00 46,749.20 .00 106,750.80 30 5,375.00 .00 .00 .00 .00 .00 .00 .00 +t+ .00 $306,760.00 - - $0.00 $306,760.00 $11,106.37 $5 $67,315.01 $184,784.05 40% $70,592.78 $306,760.00 $0.00 $306,760.00 $11 $54,660,94 $67,315.01 $184,784.05 X70,59178 N I M . -on ..xDense BtAidgetby JAccount C assifficat' RePort- q - 7/3 h 1 H 0 H K.Fis—YealAct., AcCQ.,r Aulopired Oudge-L AMended UM e:11 in— th am?actions 'D mrx 0 n C YTD a-sac`oons Bu(Iger - YM Sdi "0 M n kAF, 1 I KII y 0 ,/u used! Re c'd [ Is - o lea Y al WQ 940,529.00 .00 940,529.00 102,697,68 .00 565 374,735.47 60 494329.18 384,627.00 .00 384;627M 33,740.14 M 212,602.78 172,024.22 55 236 V X- 2,361.00 M 2 1,361.00 136,00 '00 820.00 1,541.00 35 830.00 1 00,738.00 '00 100,738,00 8,005.46 18 42,247.41 39,588.07 61 49 3,070M .00 3,070,00 38,75 M 1,24034 1,829.66 40 1 C_ C-_ 701,081.00 .00 701,081.00 76,54988 233,220,11 407,997,85 59,863.04 91 375 M M M '00 M M M ... 00 556,00 M 556.00 M M 132.99 42101 24 M 19,770.00 M 19,770.00 M 14,845.00 870.13 4,054.87 79 .00 exCE SE TMS $2,152,732,00 $0.00 $2,152,732.00 $221,167.91 $266,967.63 $ $654,05934 70 $1,1 _- 15-, 7332;00 $0,00 $2,152,732.00 $221,167.91 266,967�63 31 $654 $1,157,938.40 Adopted Buduet AcCount Classificat"on Budriet Aanm� ents id Rewascealtrit Funw EXPENSE .00 .00 .00 M M .00 .00 ... .00 1,614,000.00 163,700.00 1,777,700.00 495.00 304,485.44 727,101.84 746,112.72 58 369,809.16 T .00 M .00 .00 .00 .00 .00 . .. .00 EXPENSE TOTALS $1 $163, $1,777,700:00 $495.00 $304,485.44 $727,101.84 $746,112.72 58% $369,809.16 Ful'id 061, - VehICIL Replacement Fund I oLais $1,614:000,00 $163 $1,777 $495.00 $304,485.44 $727,101.84 $746,112.72 $369,809.16 I I Expense Budget by AccoUnt Classification Relooilt if !jqh 0 3 /11 Acco.int C.assffc, ion 'ji,i - _E 2 - Con ipowr Rem Cenient fund EXPENSE I 'T, cXP - 'Y)7AL'-:: P Jor F sca I Y e a - A ctivRw H (I e0 WMMar Listing AdOnl"EC BUdqO AmEnded _urrelnt Mon M D YTD Bud(iet ; Y % used/ Bualp A-ervirywr's BudnL[ Tr . Encwpb Hransactlm .an actio-S RecYl D o YEA YTD '00 - 00 -00 '00 .00 .00 — . � t� .00 247,480.00 M 247,480.00 '00 19,648,06 55,687.15 172,144,79 30 54,970.39 $2 $0m $247,480.00 $0.00 $19,648L06 $55,687,15 $172,144.79 30% $54,970,39 $247,480.00 $0.00 $247,480.00 $0.00 $19,648W6 $55,687015 $172,14439 $r _4,,970.39 'XHN -E 5 : , aces EXPENSE Ek 'cc TOTALS N W 27,000000 .00 27,000.00 .00 .00 10,300.00 16,700.00 38 10,950.00 7,812,938.00 .00 7,812,938.00 661,512.59 .00 4,700,477.20 3,112,460,80 60 4,343,069.80 5,000,00 .00 5,000.00 .00 .00 .00 5,000.00 0 2,140.90 .00 .00 .00 000 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 + ++ .00 $7,844,938.00 $0.00 $7,844,938.00 $661,112.59 $U0 $4,710,777,20 $3,134,160M 60% $4,356,160.70 $7,844,938.00 $0.00 $7,844,938.00 $661,11259 $0.00 $4,710,777.20 $3,134,160.80 $4,356,160.70 C LJ 3 4n -C X-ENSE P 3,937,366,00 135,350M 15,000.00 100.00 12,000M M Expense Budget by Accotint Classification Report '00 3,937,366.00 352,365. 12 .00 2,326,025.87 1,611,340.13 59 2,2 M 135,350.00 1,861.74 M 45,463.74 89,886.26 34 31 00 15,000,00 .00 '00 M 15,000.00 0 00 M 100.00 .00 c0 .00 100.00 0 00 00 12,000.00 M 00 8,250,00 3,750,00 69 9 338,9 M .00 .00 00 -00 .00 ... 00 $3 a0 $4,099816.00 $354,226.86 $0.00 $2,379,739,61 $1,720,076.39 58% $2,275,496.26 EXIENSE TOTALS $ M ,k .099,816 0?0 - N2e P ions e' ruild :Dl" $4.099,8161.00 10,00 $4 099 816.00 $354,226.86 $0.00 $2,379,739.61 2 � 27 5,496 26 I I . $1,720,076.39 $� 4f 07i , Fffe P � 'm FumA E X P EN S E Co,nlioca_an 5tli:-Vk'i'-'S K Expense Budget by Account Classification M 2,406,91933 1,614,241,67 Report 2,261,337.56 124,600,00 -00 - f - Fir"ivah 0,7/31/ 11,178.00 .00 ci 'a ACUvi 68,048.89 45 49,190.51 Usti n am. A, 0 D .ed BLICIget Amended Cut -e,it mo, Y. D Y. D bu Y'D, `/b __�eo A� B udia Isar- "'s maalo R-1 Ph& YU1 Y 4,021,161.00 '00 4,021,161.00 342,507.67 M 2,406,91933 1,614,241,67 60 2,261,337.56 124,600,00 -00 124,600.00 11,178.00 .00 56,551A1 68,048.89 45 49,190.51 15,000m .00 15,000.00 '00 .00 .00 15,000.00 0 .00 1,000.00 -00 1,000.00 .00 M M 1,000m 0 32.22 12,000.00 '00 12,000,00 450.00 00 8,450,00 3,550,00 70 9,207.93 . PI . EXPENSE �IAI.c $4,173,761.00 $Om $4,173,761.00 $354,135.67 $0,00 $2,471,920.44 $1,701,840,56 59% $2,319,768.22 W-1 - pt-a's Fund $4,173,761.00 $0.00 $4,173,761.00 $354,135.67 $0.00 $2,471,920.44 $1,701,840.56 $2,319,768.22 Gi and I $116,983,802.00 $3,339,419.00 $120,323,221,00 $11,252,394.91 $8,542,076.84 $56,279 $55,502,138.86 $47,775,758.23 I VILLAGE OF MOUNT PROSPECT List of Bills July 31 - August 13, 2014 Fund Vendor Name Invoice Description A mount 001 General Fund Addison Building Material Co. Maintenance and repair supplies 7.99 Special Events Supplies 91.77 Alexian Brothers Medical Center Pre - Employment Testing - R. Kearney 104.00 Ali, Alyssa Freelance host for inside the park 300.00 Amer Reprographics Co Llc Equipment Maintenance 62.00 American Landscaping Inc. Grass cutting - 305 N. School 216.00 Grass cutting - 2 N. Main 675.00 Grass cutting - 7 N. Wille 648.00 Professional Services 400.00 Anderson Pest Solutions Hornets Nest at 1900 Hopi 75.00 August Pest Control for the CCC 48.00 Anderson, Cheryl Rebate Sidewalk Shared Program Cost 375.00 Andres Medical Billing, Ltd. Ambulance Billing - July 2014 5,631.01 Aramark Uniform Services, Inc. Uniform Cleaning and Rental 116.22 Uniform cleaning and rental for Public Works employees 116.22 AT & T Service 7/16/14 - 8/15/14 732.98 Service 7/16/14 - 8/15/14 341.65 B & H Photo /video Video Supplies 361.35 Bald Eagle Window Cleaning Window cleaning at seven buildings for July 2,450.00 Baldini, Carol Reimbursement for display case items 8.70 Bedco Mechanical HVAC Repairs 687.60 HVAC Repairs 230.00 HVAC Repairs 249.70 HVAC Repairs 920.00 HVAC Repairs 970.00 HVAC Repairs 588.80 Behm Pavement Maintenance Cracking filling contract for 2014 at various locations 6,111.77 BMK Veterinary Associates Strays - July, 2014 126.75 Bonnell Industries Inc. New 11' Snow Plow 11,181.55 Bright Electrical Supply Co. Maintenance and repair supplies 517.40 Brown, Donna Training Expenses 20.00 Busse's Flowers & Gifts Kania memorial 85.00 Sympathy Arrangement 7/9/14 85.00 Kleinstein Get Well 75.00 Niedzwiedz memorial 85.00 Sympathy Arrangement 88.50 Capital One National Association Costco Purchased 6/26/14 - 7/24/14 1,258.95 Case Lots, Inc. Custodial supplies to be used at all buildings 1,942.20 CDW Government, Inc. Microsoft Server Licenses 4,023.88 Microsoft Exchange 2013 Licenses 15,641.20 Century Cleaners Uniform Cleaning 12.30 Uniform Cleaning 4.55 Uniform Cleaning 10.48 Uniform Cleaning 17.30 Uniform Cleaning 52.85 Uniform Cleaning 22.78 Uniform Cleaning 12.30 Comcast Xfinity internet service 08/11- 09/10/14 79.90 Cook County Recorder of Deeds Recording 652.00 Costar Realty Information, Inc. Costar- July and August 1,037.50 Croak, Michael Refund Overpayment Police Ticket #P3935285 10.00 Crystal Court Shopping Center September rent for the CCC 5,723.03 Page 1 of 9 VILLAGE OF MOUNT PROSPECT List of Bills Fund Vendor Name July 31 - August 13, 2014 Invoice Description Amount Crystal Court Shopping Center CAM reconciliation charges for the CCC 2,457.00 D.J.'s Scuba Locker Scuba Buoyancy control device (BCD) 599.96 Dawson, Henry 2014 Fire Uniform Allowance 62.41 Discount Media Products, LLC DVDs and DVD supplies 512.50 Duane Blanton Plumbing & Sewer Refund Plumbing & Sewer Fee Permit # 14 -1468 (620 S Albert St) 61.00 Elite Remodeling Group, Inc. Garnishment 142.22 Eterno, David G. July billing 450.00 Experian Background checks -July, 2014 77.00 Faber, Terry Transfer Stamp Rebate 33.00 Farkas, Tricia L. Mileage Reimbursement - 07/24 IGFOA Event 27.58 Fire Pension Fund Fire Pension 22,636.79 Grandgeorge, Aaron 2014 Fire Uniform Allowance 162.65 Guardian Emp. Dental Plan August 2014 9,259.51 Heart Printing Inc. Police patch cards 102.00 Hernandez, David Refund Overpayment Police Ticket # P3932284 4.00 Home Depot U.S.A., Inc. Electrical Tape 31.84 Homer Tree Care, Inc. Tree Removals 1,589.00 Tree Removals 4,618.40 Tree Removals 638.70 Tree Removals 3,006.00 Tree Removals 198.70 Tree Removals 2,027.45 Tree Removals 1,060.00 Tree Removals 1,624.60 Tree Removals 8,116.60 Tree Removals 3,397.95 Tree Removals 1,502.00 Howe, Kevin J Rebate Transfer Stamp 1,080.00 1/0 Solutions, Inc. Sergeants' exam: Installment 2 - project completion 2,500.00 IACP Conference registration and membership for M. McGuffin 415.00 Register T. Griffin for annual conference 10/25 -28/14 350.00 Register T. Janowick for annual conference 10/25 -28/14 350.00 ILEAS Annual membership dues 360.00 Illinois American Water Company Private Fire Service 8/1/14 - 8/29/14 33.84 Illinois Assoc of Technical Accident Investigators Register B. Tweedie for annual conference 09/17 -19/14 150.00 Register IVI. Jolie for annual conference 09/17 -19/14 150.00 Register G. Sill for annual conference 09/17 -19/14 150.00 Illinois Department of Revenue Garnishment 11 154.93 IL State Withholding 29.18 Illinois State Police Pre- Employment Background Check: J. Slupski 31.50 Pre - Employment Background Check - A. Castrejon 31.50 Background Check for New Hire K. Fiedler 31.50 IMRF IMRF 209,869.00 Internal Revenue Service Federal Withholding 464.70 Federal Withholding 162.80 International Association of Fire Chiefs 2014 FRI Registration for John Malcolm 640.00 International E -Z Up, Inc. Imprinted tent for Crime Prevention events 1,459.38 J.F. New & Associates, Inc. Creek Tree Maintenance 153.32 Kane, Julie K Reimbursement for seminar on FOID requirements 30.00 Keady, Brendan M. 2014 Fire Uniform Allowance 85.00 Kerstein, June Reimbursement - Food Expense 6/5/14 32.70 Reimbursement - Food Expense 7/3/14 30.45 KGI Landscaping Retainage Release 5/29/13 - Invoice# 21816 633.25 Klein, Thorpe and Jenkins, Ltd. June billing 199,324.59 Kleinstein, Howard Conference advance Expense 9/29/14 - 12/2/14 709.96 Krotky, Kevin Safety Shoe Allowance 104.99 L & B Business Services Inc. Smoke Alarm Equipment 179.75 Page 2 of 9 VILLAGE OF MOUNT PROSPECT List of Bills July 31- August 13, 2014 Fund Vendor Name Invoice Description Amount Lauterbach & Amen, LLP Professional Services - Audit of the Financial Statements 2013 7,530.00 Lexisnexis Risk Data Management Inc„ Background checks -July, 2014 134.25 Malcolm, John J. Malcolm Travel Expenses for FRI Conference (Aug 12 -16, 2014) 1,368.24 Meade Electric Co. Inc. Traffic Light Maintenance 721.40 Menards Other Equipment 99.76 Metro Door and Dock, Inc. Repairs to overhead doors at Police and Fire Building 1,285.00 Repairs to overhead doors at Police and Fire Building 630.00 Repairs to overhead garage door at Public Works per proposal 880.00 Overhead door repairs at Fire Station 12 575.30 Overhead door repair 400.00 Metro Federal Credit Union MP Fire Local 4119 Dues 1,847.88 Midwest Brickpaving, Inc. Brick sidewalk repair throughout the Village as needed 8,877.75 Bricks used for brick sidewalk repairs and future stock 1,111.50 Midwest Electrical Appliance Service Inc. Maintenance and repair supplies 185.00 Milieu Design LLC Landscape Maintenance 2,840.30 Miller, David L. 2014 Fire Uniform Allowance 433.30 Miller, James Ice Cream for Creekside Condos Event (7/30/14) 143.15 Misiejuk, Lukasz 2014 Fire Uniform Allowance 324.70 Mobile Print Inc. Business Cards - Schroeder, additional amount owed 10.00 Business Cards & Note Pads (Grandgeorge, Lambel & Seleen) 136.77 Inv# 141189 81.48 National Night Out posters 55.29 Mount Prospect Paint, Inc. Maintenance and repair supplies 69.29 Maintenance and repair supplies 449.46 National Catholic Society of Foresters Rebate Sidewalk Shared Program Cost 250.00 NCPERS Group Life Ins. IMRF Life Insurance 665.60 New World Systems Corporation Logos 2014 Conference - Lynn Jarog 1,895.00 Logos 2014 Conference - Claire Wheatley 1,895.00 NICOR Natural Gas Consumption 23.11 Natural Gas Consumption 24.82 Natural Gas Consumption 23.11 Natural Gas Consumption 165.94 Northeastern III. Pub. Safety Trng. F01 Prev. Principles Reg. for S. Slobe (May 2014) 450.00 Northwest Central Dispatch System September 2014 - Member Assessment 56,811.12 Northwest Police Academy Annual department membership 50.00 Northwest Suburban United Way United Way 233.64 Numbers Automation Inc Annual maintenance agreement for Records' shredder model 4003 275.00 On Time Inc. Uniform supplies For CSO Beskur 32.50 Paddock Publications, Inc. Legal Notice for PZ -21 -14 79.65 Legal Notice for PZ -22 -14 86.40 Professional Services 83.70 Panka, Patricia C Transfer Stamp Rebate 164.00 Parisi, Benjamin & Jill Transfer Stamp Rebate 500.00 Performance Battery Group, Inc. Replace of 40 batteries in the UPS battery back unit @ P &F Dept 7,420.00 Labor to install 40 batteries in the P &F Dept chloride UPS System 2,020.00 Petty Cash Petty Cash - Finance - July, 2014 270.00 Petty Cash 248.25 Police Pension Fund Police Pension 29,128.34 Proforma Customized Graphics Village uniform hats for all public works employees. 664.17 Riccio, Mary Ann Transfer Stamp Rebate 448.00 Ricker, Jeffrey 2014 Fire Uniform Allowance 278.35 Ronco Industrial Supply Custodial supplies to be used in all buildings 718.35 Schmitt, William Refund Overpayment Police Ticket #P3934876 10.00 SHI International Corp. Veeam Backup & Replication for VMware 5,388.00 Sid Tool Co., Inc. Sign Making Materials 453.48 Simic, Zlatko Transfer Stamp Rebate 714.00 Stephen A. Laser Assoc.,p.c. Pre- Employment Testing - J. Schuman 750.00 Page 3 of 9 VILLAGE OF MOUNT PROSPECT List of Bills July 31- August 13, 2014 Fund Vendor Name Invoice Description Amount Stephen A. Laser Assoc.,p.c. Pre - employment testing: Records' clerk candidates 1,100.00 Symbolarts, LLC. Uniform badges - dept. supply 4,400.00 Takoy, Matthew 2014 Fire Uniform Allowance 187.60 Takoy, Torrie 2014 Fire Uniform Allowance 150.70 Teodora, Carmen Refund Overpayment Vehicle License Fee 27.00 The Brickman Group Ltd., LLC Grounds Maintenance 1,772.00 The Cook County State's Attorney's Regional Organi Register G. Sill for CCROC training conference 80.00 The Ups Store Utility Bills from Drop Box sent to Lock Box 29.21 Thompson Elevator Inspections Elevator Inspections 150.00 Elevator Inspections 225.00 Elevator Inspections 148.00 TKB Associates, Inc. Laserfiche Annual Support 12,383.00 TransUnion Risk and Alternative Data Solutions Inc Background checks - July, 2014 133.50 U.S. Bank Equipment Finance, Inc. Fire Station 12 Copier Lease Payment 138.78 United Parcel Service Miscellaneous shipping charges 43.61 Vanopdorp, Teresa Special Event - Family Bike Ride 2014 1,730.00 VCG Uniform Redlin's Promotional Initial Issue 324.40 Skalon's Initial Issue 1,006.80 300 Arm Patches 525.00 Body armor: M. Eterno 820.00 Body armor: T. Griffin 820.00 Vena, Joseph B. 2014 Fire Uniform Allowance 46.75 Verizon Wireless Services LLC Cellular Service & Equipment Charges 6,686.68 W.S. Darley & Co. Hose Gasket & Hose Shipping Charges 131.90 Hose Gasket 17.90 Warehouse Direct Office Supplies 382.94 Office Supplies 177.78 Toner 330.38 Office supplies & toner 200.15 Wisconsin Department of Revenue WI State Withholding 686.40 WISCTF Garnishment 542.48 Wnek, Philip A. 2014 Fire Uniform Allowance 356.50 Woleben, Matt 2014 Fire Uniform Allowance 98.75 Wrena, Harry Refund Overpayment Police Ticket #P3932284 46.00 001 General Fund Total $ 727,688.94 002 Debt Service Fund Bank of New York Mellon 2013 Series GO Bond Bank Fee $ 428.00 002 Debt Service Fund Total $ 428.00 020 Capital Improvement Fund Northwest Central 9 -1 -1 System Motorola Subscriber Financing - August 2014 $ 10,603.91 020 Capital Improvement Fund Total $ 10,603.91 022 Downtown Redevelopment Construction Fund Lauterbach & Amen, LLP Professional Services - Audit of the Financial Statements 2013 $ 980.00 Midwest Brickpaving, Inc. Brick sidewalk repair throughout the Village as needed 6,697.25 Bricks used for brick sidewalk repairs and future stock 838.50 Milieu Design LLC Landscape Maintenance 6,192.88 Northwest Properties Llc NWE Sales Tax Rebate 3/1/14 - 5/31/14 21,472.95 022 Downtown Redevelopment Construction Fund Total $ 36,181.58 023 Street Improvement Construction Fund Arrow Road Construction 2014 Street Resurfacing $ 338,002.21 Baxter & Woodman, Inc. Traffic Improvements 3,118.75 Street Resurfacing Project 13,131.46 Quality Blacktop LLC Asphalt Repairs at Various Locations 25,655.00 Page 4 of 9 VILLAGE OF MOUNT PROSPECT List of Bills July 31 - August 13, 2014 Fund _ Vendor Name Invoice Description $ 75.00 Amount Rubino Engineering, Inc, 2014 Street Resurfacing IMRF 1,072.00 818.98 2014 Street Resurfacing CDBG- FY2014 Action Plan printing expense 2 023 Street Improvement Construction Fund Total CDBG- building inspection 1818 Andoa $ 383,890.42 024 Flood Control Construction Fund 275.00 042 Community Development Block Grant Total Burns & Mcdonnell Engineering Co. Engineering Services $ 61,131.00 J.F. New & Associates, Inc. Creek Tree Maintenance $ 32.18 375.18 024 Flood Control Construction Fund Total 116.23 $ 61,506.18 040 Refuse Disposal Fund AT & T Service 7/16/14 - 8/15/14 272.19 ARC Disposal Company Refuse Disposal Program $ 96.12 AT & T Service 7/16/14 - 8/15/14 4.08 Groot Industries, Inc. Refuse Disposal Program SCADA Wireless 255.96 IMRF IMRF 4,428.43 NCPERS Group Life Ins. IMRF Life Insurance 17.60 Northwest Suburban United Way United Way 3.85 040 Refuse Disposal Fund Total $ 4,806.04 041 Motor Fuel Tax Fund Behm Pavement Maintenance Cracking filling contract for 2014 at various locations $ 53,457.13 Constellation NewEnergy, Inc. Electrical Service Delivery 10,376.06 Electrical Service Delivery 95.73 Electrical Service Delivery 23.31 Electrical Service Delivery 1,896.92 Electrical Service Delivery 16.65 Electrical Service Delivery 87.35 Electrical Service Delivery 169.96 Electrical Service Delivery 165.46 Electrical Service Delivery 96.76 Electrical Service Delivery 112.77 Electrical Service Delivery 83.23 Electrical Service Delivery 46.18 Electrical Service Delivery 180.05 Electrical Service Delivery 234.91 Electrical Service Delivery 159.81 Electrical Service Delivery 53.76 Electrical Service Delivery 45.33 041 Motor Fuel Tax Fund Total $ 67,301.37 042 Community Development Block Grant Chicago Title Insurance CDBG Title Search 1009 Golfview Dr $ 75.00 Elk Grove Township CDBG Subrecipient- CCC 75.00 IMRF IMRF 818.98 Saewert, Janet CDBG- FY2014 Action Plan printing expense 38.10 T.P.I. CDBG- building inspection 1818 Andoa 80.00 The Lead Inspectors, USA Inc CDBG- Lead inspection 115 N. Main 275.00 042 Community Development Block Grant Total $ 1,362.08 050 Water and Sewer Fund Addison Building Material Co. Water Meter Repair Parts $ 32.18 Aramark Uniform Services, Inc. Uniform Cleaning and Rental 116.23 Uniform cleaning and rental for Public Works employees 116.23 AT & T Service 7/16/14 - 8/15/14 272.19 Badger Meter Inc AMR /AMI System 101,061.45 AMR /AMI System 37,510.00 AMR /AMI System 18,000.00 Baxter & Woodman, Inc. SCADA Wireless 7,741.50 Page 5 of 9 Fund Vendor Name Baxter & Woodman, Inc. Century Cleaners Christopher Miller Constellation NewEnergy, Inc. Emily Bisplinghoff Griswold Industries H. G. Smeltzer HBK Water Meter Service Healy Asphalt Company,llc. IMRF Lauterbach & Amen, LLP Martam Construction Mid American Water of Wauconda, Inc. Milieu Design LLC NCPERS Group Life Ins. NICOR Northwest Suburban United Way Putra, Jessica R. Thomason Robin S. O'meara Robinson Engineering, Ltd. Scott Limbers Suburban Laboratories, Inc. Third Millennium Assoc.inc. TigerDirect, Inc. Verizon Wireless Services LLC Ziebell Water Service Products 050 Water and Sewer Fund Total 051 Village Parking System Fund Elite Remodeling Group, Inc. Illinois Department of Revenue IMRF Petty Cash 051 Village Parking System Fund Total VILLAGE OF MOUNT PROSPECT List of Bills July 31 - August 13, 2014 Invoice Descriotion Professional Services Professional Services Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Uniform Cleaning Utility Refund - 1537 Redwood Dr Electrical Service Delivery Utility Refund - 1103 Ardyce Ln # 2 Booster Stations Checkups Utility Refund - 506 S Pine St Water Meter Installations Asphalt materials used for street patching Asphalt Repairs Asphalt materials used for patching streets Asphalt materials used for patching streets Asphalt materials used for patching streets Asphalt materials used for patching streets Asphalt materials used for patching streets IMRF Professional Services - Audit of the Financial Statements 2013 Contractual Hauling Contractual Hauling AMR Systems Landscape Maintenance IMRF Life Insurance Natural Gas Consumption Natural Gas Consumption Natural Gas Consumption United Way Travel and Meeting Expenses Utility Refund - 221 N William St Utility Refund - 416 S Wille St Professional Services Utility Refund - 301 S Elmhurst Ave Water Sample Testing July 2014 - Utility Billing Repair Maintenance Supplies Cellular Service & Equipment Charges Repair Maintenance Supplies Garnishment Garnishment II IMRF Petty Cash - Finance - July, 2014 Amount 121.23 9,449.97 12.30 4.55 127.35 10.47 17.30 52.85 22.77 12.30 38.25 7.39 7,307.14 47.64 1,165.14 6.48 85.95 86.13 107.42 83.16 47.03 78.21 72.27 239.56 37,757.88 2,510.00 3,898.38 3,677.66 9,519.30 2,991.82 52.80 74.96 74.96 74.96 34.73 160.02 73.87 12.4 1,212.00 30.33 307.00 2,389.07 169.73 425.71 1 :In !� Z49,658.5Z $ 78.19 85.18 757.15 10.00 $ 930.52 052 Parking System Revenue Fund Elite Remodeling Group, Inc. Garnishment $ 64.02 Illinois Department of Revenue Garnishment II 69.75 Page 6 of 9 Fund Vendor Name IMRF NICOR Petty Cash 052 Parking System Revenue Fund Total 060 Vehicle Maintenance Fund Addison Building Material Co. American Messaging Arlington Heights Ford AT &T Certified Fleet Services, Inc. Chicago Parts & Sound Llc Dave & Jim's Auto Body, Inc. DJK Technologies, Inc. General Parts Inc. Grossinger Chevrolet IMRF Inland Power Group Inc. Interstate Battery Jackson- hirsh,Inc. Just Tires Lawson Products, Inc. Leach Enterprises, Inc. Lund Industries, Inc. Morton Grove Automotive Napa- Heights Automotive Supply NCPERS Group Life Ins. Northwest Suburban United Way Pomp's Tire Service, Inc. Precision Service & Parts Pro Finish Rush Truck Centers of Illinois, Inc. VILLAGE OF MOUNT PROSPECT List of Bills July 31- August 13, 2014 Invoice De IMRF Natural Gas Consumption Petty Cash - Finance - July, 2014 Vehicle Maintenance Supplies Pager rental Vehicle Maintenance Supplies 2732 Right rear taillight 2742 Front license plate bracket 525 Door latch clip Relay Service 7/16/14 - 8/15/14 Vehicle Maintenance Supplies Vehicle Maintenance Supplies Police Lights Ford Police Explorer headlight bulbs 2729 Rear brake rotors and pads 2729 Rear brake calipers 2729 Rear caliper Rear Ford pickup brake pads Equipment Maintenance and Repair Annual Fuel Island Testing Bulbs 2751 Head gasket and bolts 2757 Oil cooler gasket 2751 Camshaft IMRF Fuel and air filters Transmission filter kits 518 Batteries 4571 Manlift scissor lift batteries Vehicle Maintenance Supplies P -5 Tires Squad Tires Vehicle Maintenance Supplies Vehicle Maintenance Supplies Vehicle Maintenance Supplies Rebuilt alternator 2749 Parking brake cable 2729 Rear caliper bracket 2729 Rear caliper bolt 2751 Camshaft bearings 515 Rear brake light socket IMRF Life Insurance United Way Vehicle Maintenance Supplies Vehicle Maintenance Supplies P -7 Starter Vehicle Maintenance Supplies Vehicle Maintenance Supplies Fire engine air filters 2727 Injector seal kits 2727 Radiator cap Primer fuel pump Equipment Maintenance and Repair on Amount 557.42 23.11 20.00 $ 734.30 $ 9.00 73.91 (29.89) 38.88 23.04 3.85 17.39 10.19 45.31 120.08 313.50 37.44 233.70 261.24 130.62 49.98 60.00 550.00 34.28 84.57 4.83 360.89 16,785.75 178.40 434.00 439.80 439.80 35.80 609.32 1,063.28 241.41 9.00 108.00 185.00 37.35 22.94 8.49 32.38 17.60 48.00 3.85 397.85 (175.00) 184.45 554.09 249.56 252.46 40.66 23.82 125.47 493.78 Page 7 of 9 VILLAGE OF MOUNT PROSPECT List of Bills July 31- August 13, 2014 Fund Vendor Name Invoice Description Amount Rush Truck Centers of Illinois, Inc. Equipment Maintenance and Repair 298.37 2727 Fuel injector seal kits 143.75 Sid Tool Co., Inc. Nuts, bolts, washers, fuses and clamps 189.57 Spring Align of Palatine, Inc. 518 Rear springs 1,751.96 Terrace Supply Company Gas Rental 40.93 Verizon Wireless Services LLC Cellular Service & Equipment Charges 060 Vehicle Maintenance Fund Total $ _ 144.02 27,848.72 061 Vehicle Replacement Fund Astroblast, Inc. Equipment for Public Works Vehicles $ 495.00 Bob Ridings, Inc. 2709 New replacement pickup 24,645.00 GovDeals, Inc. Equipment for Public Works Vehicles 775.87 061 Vehicle Replacement Fund Total $ 25,915.87 063 Risk Management Fund Kadzielawski, Ronald Reimbursement for Medical Premium Payments 3/8/14 - 7/31/14 $ 8,323.90 Wojciechowski, Paul Other Services 3, 180.00 063 Risk Management Fund Total $ 11,503.90 070 Police Pension Fund Mesirow Financial Investment Management, Inc, Inv Mgr Fees 4/1/14- 6/30/14 $ 5,620.26 Reimer & Karlson LLC Legal Services Rendered June 2014 1,864.48 Rosenbarski, Lawrence IPPFA Midwest Pension Trustee Conference 2014 (9/30/14- 10/3/14) 305.00 Segall Bryant & Hamill Inv Mgr Fees 4/1/14- 6/30/14 7,619. 070 Police Pension Fund Total $ 15,409.41 071 Fire Pension Fund Internal Revenue Service Federal Withholding $ 39,615.93 Segall Bryant & Hamill Inv Mgr Fees 4/1/14- 6/30/14 7,792.17 Wells Fargo Bank Inv Mgr Fees 4/1/14 - 6/30/14 4,542. 071 Fire Pension Fund Total $ 51,950.65 073 Escrow Deposit Fund Alonzo, Victor Refund Escrow Permit # 14 -1065 $ 200.00 Austin, Peter Refund Escrow Permit # 14 -0444 200.00 Baeg, Mike Refund Escrow Permit # 14 -0699 (1011 Arbor Court) 200.00 Balmes, Daniel L Refund Escrow Permit # 14 -0924 200.00 Capps Plumbing and Sewer Inc Refund Escrow Permit # 14 -1471 (1309 Lama Ln) 75.00 Cincan, Darius Refund Escrow Permit # 14 -1148 200.00 Diamond Sign and Design Refund Escrow Permit # 13 -1751 (1703 E Kensington Rd) 125.00 Duane Blanton Plumbing & Sewer Refund Escrow Permit # 14 -1468 (620 S Albert St) 125.00 Fortis Concrete Refund Escrow Permit # 14 -1092 (14 S Edward St) 200.00 Hunzinger Williams Inc Refund Escrow Permit # 13 -2285 (730 E Northwest Hwy) 125.00 Iris Construction Refund Escrow Permit # 14 -0826 (1840 S Elmhurst Rd) 500.00 Irv's Luggage Refund Escrow Permit # 14 -1402 125.00 Izzo, Anna Marie Refund Escrow Permit # 14 -1391 125.00 JD Sewer Service & More Refund Escrow Permit # 14 -1448 (506 N Elmhurst Ave) 125.00 Kulesza, John M Refund Escrow Permit # 14 -0283 (617 Russel St) 200.00 Lichterman, Scott Refund Escrow Permit # 14 -0287 250.00 Mathew, Arumpolil V Refund Escrow Permit # 14 -1571 125.00 Mathews, James R Refund Escrow Permit # 14 -1284 200.00 Meade Electric Refund Escrow Permit # 14 -0060 (2312 Terminal Dr) 125.00 Menard Inc Refund Escrow Permit # 14 -0193 (740 E Rand Rd) 125.00 Nastaj, Adam Refund Escrow Permit # 13 -1964 200.00 Northscape Enterprises Inc Refund Escrow Permit # 14 -1228 (7 N William St) 200.00 Olsen, Clark Refund Escrow Permit # 14 -1429 200.00 Paldo Sign and Display Co Refund Escrow Permit # 14 -0221 (521 W Central Rd) 125.00 Page 8 of 9 VILLAGE OF MOUNT PROSPECT List of Bills July 31- August 13, 2014 Fund Vendor Name Invoice Description Amount Pavestone Brick Paving Inc Potucek, Martin Pro Temp of Illinois Provenza, John Robinson, Erin Samano, Fidel Landa Signco Inc Third District Circuit Court Traver Construction Inc VFP Construction Warnick, Jeffrey Windy City RE LLC Zera Construction Company 073 Escrow Deposit Fund Total Refund Escrow Permit # 14 -1244 (602 Na Wa Ta Ave) Refund Escrow Permit # 14 -0836 Refund Escrow Permit # 14 -1393 (414 Deborah Ln) Refund Escrow Permit # 14 -1093 Refund Escrow Permit # 14 -0762 Refund Escrow Permit # 13 -1487 Refund Escrow Permit # 14 -0281 (211 E Rand Rd) Refund Escrow Permit # 14 -0282 (211 E Rand Rd) Bond Check 7/31/14 Bond Check 8/5/14 Bond Check 8/12/14 Refund Escrow Permit # 14 -1374 (1410 Bridgeport Dr) Refund Escrow Permit # 14 -0080 (1322 Columbine Dr) Refund Escrow Permit # 14 -0947 Refund Escrow Permit # 14 -0321 (1976 W Algonquin Rd # 3b) Refund Escrow Permit # 14 -0887 (280 Westgate Rd) 200.00 75.00 125.00 125.00 200.00 75,00 125.00 125.00 120.00 1,090.00 900.00 125.00 450.00 125.00 300.00 75 nn Grand Total 5 8,510.00 $ 1,686,230.41 Page 9 of 9