agenda - wednesday, march 30, 2016...courthouse parapet restoration project c. resolution:...

KANE COUNTY HOSCHEIT, Frasz, Allan, Barreiro, Castro, Smith, Starrett

FINANCE AND BUDGET COMMITTEE

WEDNESDAY, MARCH 30, 2016

County Board Room Agenda 9:00 AM

Kane County Government Center, 719 S. Batavia Ave., Bldg. A, Geneva, IL 60134

Kane County

1. Call to Order

2. Approval of Minutes: February 24th, 2016

3. Public Comment

4. Treasurer's Report (D. Rickert)

A. Monthly Report (attached)

5. Finance Director's Report (J. Onzick)

A. February Finance Director's Report (attached)

B. Consent for Proposed Fiscal Year 2017 Budget Calendar

C. Status of State Delinquencies

6. New Business

A. Resolution: Authorizing Ongoing Transfer of Funds for Outside Agency Services and Support

B. Resolution: Amending the 2016 Fiscal Year Capital Improvement Budget - 3rd Street Courthouse Parapet Restoration Project

C. Resolution: Authorizing Contract for the 3rd Street Courthouse Parapet Restoration Project

D. Resolution: Authorizing Retention of Cordogan Clark & Associates

E. Resolution: Approving Office Supplies Contract

F. Resolution: Authorizing Contract for the Judicial Center Elevator Modernization Project

G. Resolution: Authorizing Contract for the KBC Roofing Project

H. Resolution: Authorizing an Intergovernmental Agreement with Stephenson County

I. Resolution: Authorizing Contract for Electronic Monitoring Extension

J. Resolution: Ratifying Emergency Line of Credit from the General Fund to the Title IV Fund

K. Resolution: Amending Kane County Financial Policies to Revise P-Card & Travel Policy (not included)

7. Old Business

8. Court Case Management Project Report (R. Fahnestock)


Agenda Finance and Budget Committee March 30, 2016

Kane County

9. Auditor's Report (T. Hunt)


10. Reports Placed On File

11. Executive Session (if needed)

12. Adjournment

COUNTY OF KANE

OFFICE OF THE TREASURER

DAVID J. RICKERT, CPA

Geneva, Illinois 60134

Phone: (630) 232-3565

Fax: (630) 208-7549

To: Finance Committee

From: David J. Rickert

Date: March 30, 2016

Subject: Update on Investments

Attached is a copy of the February Weighted Average Investment Yield Report. This chart

includes the rate earned by the 90 Day T-Bill, and State Treasurer on the IPTIP Account. You will

notice the yield on all county investments for February was .74%.

Attached is the Summary of the Kane County Portfolio for the Month of February.

Sincerely,

David J. Rickert, CPA

Treasurer of Kane County

Packet Pg. 3

KANE COUNTY TREASURER - PORTFOLIO SUMMARY 2/29/2016

INTEREST

PURCH CURRENT Rec'd in

ACCOUNT ASSETS VALUE MARKET Current Month

FDIC Savings/Checking Accounts 58,874,984 58,874,984 13,940

Investments 131,545,000 132,543,293 96,681

The Illinois Funds 15,972 15,972

CDARS Program - The Private Bank 19,000,000 19,000,000

GRAND TOTAL 209,435,956 210,434,249 110,621

Packet Pg. 4

0.50%

0.53%

0.59%

0.66% 0.66%0.67%

0.66%0.65%

0.66%0.67%

0.70%

0.74%

0.21%

0.25% 0.25% 0.25%0.26% 0.26% 0.26%

0.21%

0.25%

0.39%

0.48%0.49%

0.02% 0.02%0.01% 0.01%

0.05% 0.05%

0.02% 0.02%

0.14%

0.27%

0.31%

0.33%

0.01%

0.02% 0.02%

0.03%0.04%

0.06%0.05% 0.05%

0.04%

0.11%

0.20%

0.24%

0.0%

0.3%

0.5%

0.8%

Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16

Kane County Weighted Average Investment Yield(Includes all Investment Funds)

Office of David J. Rickert

Kane County Treasurer

Kane County Funds

IMET

90 Day T-Bill

The Illinois Funds

Packet Pg. 5

1

To: Finance Committee

From: Joe Onzick, Executive Finance Director

Date: March 30, 2016

Re: Monthly Report

Introduction of Newest Finance Department Staff Member I am pleased to introduce Juliet Gaber, or newest Accountant who filled the vacancy created by Lynn Carlstrom. Juliet is a Certified Public Accountant who comes to us from the Village of Pingree Grove, where she served as their Assistant Finance Director for the past 4 years. Previously Juliet served as the Manager of Accounting and Financial Operations for the Robert H. Lurie Comprehensive Cancer Center of Northwestern University for over 4 years. Juliet also has prior experience as an accountant in the Kane County Finance Department between 2004 and 2006. We are very happy that Juliet has chosen to return to Kane County and strengthen our team of professionals. Audit Update The auditors completed their final audit fieldwork between February 29th and March 24th. During these 4 weeks, we have been working diligently on completing the remaining audit workpapers, reconciliations, analysis and year-end adjustments, as well as fielding auditor questions. This is the first time Kane County staff has completed all reconciliations and adjustments without outside assistance. This is tangible evidence of how far the Finance Department has come in developing in-house accounting expertise. I am very proud of the Finance staff for accepting this challenge and for achieving this goal. And I am pleased to announce that there were no audit findings. The next phase is preparation of the Comprehensive Annual Financial Report (CAFR). We expect to have a preliminary CAFR by end of April, with the final CAFR presented at May Committee of the Whole. Final Allocation of FY15 General Fund Excess Revenue over Expenditures As a result of final year-end adjustments for FY15, the “excess revenues over expenditures” for the General Fund has increased $130,000: from $5,970,000 to $6,100,000 before required allocations. This increase is the result of a $125,576 adjustment to the Sheriff’s Office Chancery Foreclosure revenue based upon an audited reconciliation of the related bank account. We therefore increased the year-end allocation of excess revenue over expenditures proportionately, as authorized by the resolution approved at the March 8th Board meeting. Required Allocations Original

Allocation Final

Allocation Restore Health Insurance Reserve Used to Cover FY15 Budget Overage 904,000 904,000 Fund Prepayment of One Month's Worth of Health Insurance 1,330,000 1,330,000 Replenish Reserve Used to Subsidize FY16 736,000 800,000 Discretionary Allocations Emergency Reserve Fund 1,000,000 1,022,000 Property Tax Freeze Protection Fund 1,000,000 1,022,000 Capital Fund 1,000,000 1,022,000 Total Required and Discretionary Allocations 5,970,000 6,100,000

Packet Pg. 6

2

Finance and Budget Reports for FY16 Total County Budget, Finance Committee P-Card & Accounts Payable reports are included in the agenda packet for February 2016. The variances appearing are normal for this time of year and are primarily the result of timing of expenditures and transfers. The significantly higher than expected revenue variances seen in some departments are the result of internal transfers that occur at the start of the year. Examples of such transfers include: $3,614,123 of Grand Victoria Elgin Casino internal grants, a $1,000,000 budgeted transfer from the General Fund for capital projects, $731,360 of subscription fees from County Departments for KaneComm, a $552,378 subsidy from the General Fund for Court Security, a $500,000 subsidy from the Public Safety Sales Tax Fund for the Sheriff’s Office, and various transfers of pledged revenue for debt service. The significantly higher than expected expenditure variances seen in some departments are the result of 1) encumbrances for expenses that will occur later in the year or in future years, 2) transfers out for the purposes mentioned above, 3) timing of some payments that are made at the beginning of the year (insurance premiums, maintenance contracts, etc…), and 4) timing of purchases related to large capital projects. Direct Tax Revenue YTD Sales Tax collection through December is -1.99% ($54,954) below prior year. YTD Use Tax collection through December is 8.68% ($22,426) over prior year. YTD RTA Sales Tax collection through December is 1.12% ($33,531) over prior year. YTD Video Gaming Tax collection through December is 10.96% ($3,636) over prior year. YTD Off-Track Wagering Tax collection through February is -29.25% ($8,442) below prior year. Grand Victoria Casino Elgin Revenue We have received word from the Grand Victoria Casino Elgin that their audited contribution payable in April will be $3,205,154, which is $128,758 more than had been budgeted. Shared Tax Revenue YTD State Income Tax revenue through February is 5.18% ($79,903) over prior year. YTD Personal Property Replacement Tax through February is 3.07% ($9,281) over prior year. Court Security Fees Evidence of the increase to the Court Security Fee that went into effect January 1, 2016 was seen immediately in the January collection. YTD Court Security Fees are 29.7% ($98,052) over prior year. State Receivables Probation Salary Reimbursements are about 4 months behind totaling $1,541,967. (Last year at this time Probation Salary Reimbursements were about 8 months behind totaling $2,516,339.) All other state receivables are within the normal range, with the exception of the revenue streams impacted by the state budget impasse. (See separate report on Status of State Delinquencies.) General Fund Contingency Balance $1,002,385 of the General Fund Contingency for FY16 is available for general need. $ 50,000 of the General Fund Contingency for FY16 is reserved for Adult Prisoner Room & Board. $ 125,000 of the General Fund Contingency for FY16 is reserved for Judiciary Juror’s Fee expense.

Packet Pg. 7

3

Capital Fund As of 3/24/2016, 3.9% of the FY16 Capital Budget is expended, leaving $4,228,124 available. FY17 Budget Process We have prepared a tentative calendar for the FY17 budget process. It is included in the agenda packet for your review, and we are seeking your approval so that it may be distributed as soon as possible to all offices and departments. It is basically the same calendar as last year with the dates updated to accommodate the scheduled meeting dates. The only change is that we will be asking for an estimate of FY17 General Fund revenue at the very beginning of the process, so that we may determine as soon as possible the level of increase in expenditures our revenue will support. Procurement Card Policy The Procurement Card policy has been sent to the State’s Attorney’s Office. They are working on making whatever changes are necessary to make it acceptable from their point of view. It will be presented again for your approval once the changes are completed. Purchasing Report The Purchasing Department sent 3 contract expiration notices in February to various departments for upcoming contract expirations in order to begin the procurement process or renewal process. The Purchasing Staff began working on Bids/Request for Proposals for the following services:

• RFP 11-016 Multi-Systemic Therapy for Court Services. This work is to retain the services of qualified and experienced vendor to provide Multi-Systemic Therapy to juveniles in Kane and DeKalb Counties.

• RFP 16-016 Video Wall for the Department of Transportation. This work is to hire a qualified vendor to design, procure and install a video architecture and media wall system for its newly constructed Arterials Operations Center (AOC) located within the Kane County Division of Transportation offices in St. Charles.

• RFP 17-016 Temporary Employee Provider for clerical and labor positions on an as-needed basis to be used countywide for both departments and elected offices.

• RFP 19-016 MISA Assessment and Treatment Services for Court Services. This procurement is to hire qualified treatment providers interested in providing comprehensive outpatient Mental Health and Substance Abuse (MISA) services to individuals referred by the Kane County Drug Rehabilitation Court.

• RFP 20-016 Residential Treatment Services for Court Services. This procurement is to hire qualified treatment providers interested in providing comprehensive substance abuse assessments and group, individual, and family counseling, as well as urine screening, to individuals referred by the Kane County Drug Rehabilitation Court.

• Bid 21-016 Wideview Drainage Improvement Project for the Water Resources. This work is to hire an experienced and licensed Contractor to provide all materials, equipment and labor for the Wideview Drainage Improvement Project, located in the Campton Township, north of IL Rt. 64 off Shady Oak Court.

• 22-016 Temporary Lease Agreement for Workforce Development. This procurement is for a short-term lease for Workforce Development while exploring their options for their current office space located in North Aurora or searching for new office space more centrally located in Kane County for approximately twenty-three employees.

Packet Pg. 8

4

• Bid 23-016 Herbicide Application for Environmental and Water Resources. This bid is to retain the services of qualified and experienced Contractors to complete and improve the overall effectiveness of invasive plant management at the McLean Boulevard Fen, a Kane County Forest Preserve District (District) property.

• RFP 25-016 Juvenile Intervention Services for the Juvenile Justice Council. This RFP is to identify and qualify agency/organization(s) experienced in the delivery of services to intervene with juvenile offenders in an effort to provide alternatives to formal court proceedings.

• RFP 26-016 Workforce Innovation and Opportunity Act Youth Services for Workforce Development. This procurement is to hire qualified organizations to provide Workforce Innovation and Opportunity Act services to eligible participants from Kane, Kendall, and/or DeKalb Counties who are out-of-school youth and/or in-school youth, who can benefit most from the WIOA services.

• Bid 27-016 Building Demolition and Site Restoration Project for the Development Department. This work consists of hiring a qualified demolition and asbestos abatement vendor for the demolition of two (2) single family homes in Montgomery and Aurora Township. Both properties have been determined a “Dangerous and Unsafe Building” under Kane County Code. The Circuit Court in the Sixteenth Judicial Circuit of Kane County ordered the demolition on June 17, 2015.

• Bid 28-016 Draintile Replacement Project for Water Resources. This work includes hiring an experienced and licensed Contractor to provide all materials, equipment and labor for the Lake Charlotte Draintile Replacement Project, located in St. Charles Township, north of Campton Hills Road and west of Peck Road between Bonnie and Glad Lanes.

Currently, 29 bids and 5 contract renewals are at various stages in the procurement process. Cost savings in February from quote requests for Development, Health, I.T. and the Juvenile Justice Center totaled $5,037.13 and bid savings totaled $39,470 ($44,507.13 Feb total) for a FYTD cost savings total of $60,936.99. The Procurement Card Program has 70 cards as of February 29, 2016. There have not been any requests for new cards in February. The Purchasing Department received the procurement card rebate check for $1,374.82, which is unbudgeted revenue, based on the calendar year 2015 annual spend of $250,000. The Purchasing Department received an unbudgeted revenue rebate check from the National IPA Cooperative (National Intergovernmental Purchasing Alliance) for calendar year 2015 purchases at Grainger from various users throughout the County. The 2% rebate check for $786.82 was for $39,340.79 in products purchased, per the terms of the City of Tucson, AZ contract award with Grainger and the Participant Incentive for which the County is eligible. There were no vehicle auctions during the month of February. We are currently working with various departments to re-assign surplus vehicles to other departments requesting vehicles such as Building Management and the Coroner’s Office. Monthly Statistics: Quotations Solicited 20 FOIA Requests 2 Purchase Orders Issued 181 Contractor Disclosures Reviewed 5 Insurance Certificates Reviewed 13 Contracts Prepared 4

Packet Pg. 9

Current Month

Transactions

Total Amended Budget


excluding Cash on Hand

YTD Actual Transactions

Total % Received

000 General Government 1,323,702 62,090,276 62,090,276 3,448,344 5.55%001 General Fund 1,287,645 59,013,708 59,013,708 3,361,191 5.70%010 Insurance Liability 36,057 3,076,568 3,076,568 87,153 2.83%

010 County Board 12,764 6,592,389 4,748,896 404,222 8.51%

001 General Fund 8,150 148,000 148,000 58,450 39.49%120 Grand Victoria Casino Elgin 2,582 4,852,151 3,101,396 31,181 1.01%430 Farmland Preservation 2,032 1,592,238 1,499,500 314,591 20.98%

060 Information Technologies 91,507 2,096,097 1,636,320 335,164 20.48%

001 General Fund 2,270 254,820 254,820 46,534 18.26%101 Geographic Information Systems 89,237 1,841,277 1,381,500 288,630 20.89%

150 Treasurer/Collector 439 1,803,195 1,716,500 2,567 0.15%

001 General Fund 0 1,655,000 1,655,000 0 0.00%150 Tax Sale Automation 439 148,195 61,500 2,567 4.17%

170 Supervisor of Assessments 6,890 88,330 88,330 10,324 11.69%

001 General Fund 6,890 88,330 88,330 10,324 11.69%

190 County Clerk 101,897 1,364,331 1,293,400 276,826 21.40%001 General Fund 86,403 1,122,900 1,122,900 231,296 20.60%160 Vital Records Automation 15,494 241,431 170,500 45,530 26.70%

210 Recorder 309,136 3,451,138 3,209,900 817,415 25.47%

001 General Fund 255,339 2,467,900 2,467,900 646,029 26.18%170 Recorder's Automation 53,797 983,238 742,000 171,386 23.10%

240 Judiciary and Courts 46,331 513,080 513,080 120,652 23.52%

001 General Fund 30,951 331,000 331,000 83,298 25.17%195 Children's Waiting Room 6,640 105,558 105,558 17,681 16.75%196 D.U.I. 2,045 6,204 6,204 3,586 57.79%197 Foreclosure Mediation Fund 6,694 70,318 70,318 16,088 22.88%

250 Circuit Clerk 739,535 9,394,241 8,777,043 1,978,136 22.54%

001 General Fund 493,063 5,967,500 5,967,500 1,322,690 22.16%200 Court Automation 94,894 1,368,439 1,123,270 261,833 23.31%201 Court Document Storage 86,817 1,376,906 1,023,696 237,604 23.21%202 Child Support 13,377 159,781 159,781 35,392 22.15%203 Circuit Clerk Admin Services 41,357 398,776 387,296 93,091 24.04%204 Circuit Clk Electronic Citation 10,028 122,839 115,500 27,526 23.83%

300 State's Attorney 227,351 4,645,553 4,645,553 1,934,633 41.64%

001 General Fund 138,172 1,737,964 1,737,964 343,756 19.78%220 Title IV-D - 687,487 687,487 22,487 3.27%221 Drug Prosecution 31,368 385,149 385,149 232,506 60.37%222 Victim Coordinator Services 7,215 163,696 163,696 89,839 54.88%223 Domestic Violence 385 479,580 479,580 479,610 100.01%224 Environmental Prosecution 94 138,658 138,658 139,171 100.37%225 Auto Theft Task Force 22 - - 167 N/A230 Child Advocacy Center 46,774 993,019 993,019 616,713 62.10%231 Equitable Sharing Program 68 60,000 60,000 517 0.86%

Kane County Revenue Report - SummaryThrough February 29, 2016 (25.0% YTD)

Packet Pg. 10

Current Month

Transactions





Total % Received


360 Public Defender 9,694 154,900 149,900 14,269 9.52%001 General Fund 9,694 154,900 149,900 14,269 9.52%

370 Law Library 26,004 310,754 310,754 68,286 21.97%

250 Law Library 26,004 310,754 310,754 68,286 21.97%

380 Sheriff 331,978 4,987,803 4,987,803 1,437,120 28.81%001 General Fund 148,141 2,503,000 2,503,000 446,827 17.85%259 Transportation Safety Highway HB 138 5,000 5,000 516 10.33%260 Court Security 181,242 2,454,378 2,454,378 982,677 40.04%262 AJF Medical Cost 2,457 25,425 25,425 7,099 27.92%

425 Kane Comm 175 2,009,759 2,009,759 731,570 36.40%

269 Kane Comm 175 2,009,759 2,009,759 731,570 36.40%

430 Court Services 303,059 9,324,225 8,465,726 1,432,558 16.92%001 General Fund 169,653 6,370,073 6,370,073 268,508 4.22%270 Probation Services 111,105 1,388,908 1,163,000 290,829 25.01%271 Substance Abuse Screening 6,433 80,000 80,000 22,616 28.27%273 Drug Court Special Resources 10,329 1,271,051 638,460 677,187 106.07%275 Juvenile Drug Court 4,288 204,193 204,193 170,475 83.49%276 Probation Victim Services 1,252 10,000 10,000 2,943 29.43%277 Victim Impact Panel - - -

490 Coroner 8,474 101,500 86,500 28,511 32.96%

289 Coroner Administration 8,474 101,500 86,500 28,511 32.96%

500 Animal Control 63,800 883,515 823,517 199,997 24.29%290 Animal Control 63,800 883,515 823,517 199,997 24.29%

510 Emergency Management Services - 90,000 90,000 (0) (0.00%)

001 General Fund - 90,000 90,000 (0) (0.00%)

520 Transportation 3,461,913 60,461,425 40,989,795 4,303,649 10.50%300 County Highway 181,215 7,967,596 6,065,076 343,391 5.66%301 County Bridge 316 500,000 329,405 2,604 0.79%302 Motor Fuel Tax 928,337 7,618,230 6,958,580 967,924 13.91%303 County Highway Matching 39 68,000 65,325 292 0.45%304 Motor Fuel Local Option 785,535 13,933,768 9,130,700 848,220 9.29%305 Transportation Sales Tax 1,193,202 19,894,458 15,574,234 1,482,640 9.52%540 Transportation Capital 95,317 3,680,712 282,400 118,846 42.08%550 Aurora Area Impact Fees 671 143,059 141,500 3,340 2.36%551 Campton Hills Impact Fees 2,324 173,607 172,530 12,982 7.52%552 Greater Elgin Impact Fees 20,536 416,804 414,180 25,392 6.13%553 Northwest Impact Fees 2,289 133,390 26,320 9,299 35.33%554 Southwest Impact Fees 4,330 51,820 51,820 14,599 28.17%555 Tri-Cities Impact Fees 12,391 785,192 239,500 27,943 11.67%556 Upper Fox Impact Fees 2,784 705,105 106,100 13,832 13.04%557 West Central Impact Fees 1,506 10,100 10,100 2,232 22.10%558 North Impact Fees 40,007 1,079,584 529,725 75,742 14.30%559 Central Impact Fees 13,494 707,500 152,000 162,766 107.08%560 South Impact Fees 177,621 2,592,500 740,300 191,605 25.88%

Packet Pg. 11

Current Month

Transactions





Total % Received


580 Health 232,330 6,237,827 5,943,305 1,456,283 24.50%

350 County Health 227,103 5,658,830 5,364,308 1,253,943 23.38%351 Kane Kares 5,227 578,997 578,997 202,340 34.95%

660 Veterans' Commission 422 331,071 309,324 3,125 1.01%

380 Veterans' Commission 422 331,071 309,324 3,125 1.01%

670 Environmental Management 11,895 2,245,099 309,199 247,080 79.91%420 Stormwater Management 3,516 417,229 106,199 112,150 105.60%650 Enterprise Surcharge 4,698 1,799,870 175,000 123,720 70.70%651 Enterprise General 3,680 28,000 28,000 11,209 40.03%

690 Development 410,536 5,791,538 5,147,695 1,297,012 25.20%

001 General Fund 229,733 1,322,900 1,297,900 311,365 23.99%400 Economic Development 163 228,858 1,100 1,230 111.83%401 Community Dev Block Program 131,050 1,182,178 1,182,178 599,194 50.69%402 HOME Program 12,465 767,869 767,869 40,805 5.31%403 Unincorporated Stormwater Mgmt 39 - - 296 N/A404 Homeless Management Info Systems 35,778 133,745 133,745 46,878 35.05%405 Cost Share Drainage 558 530,000 262,294 257,440 98.15%406 OCR & Recovery Act Programs - 448,503 443,308 - 0.00%407 Quality of Kane Grants 11 20,000 20,000 12,052 60.26%408 Neighborhood Stabilization Progr - 292,386 292,386 20,000 6.84%409 Continuum of Care Planning Grant - 17,863 17,863 1,762 9.87%435 Growing for Kane 6 - - 44 N/A520 Mill Creek Special Service Area 720 809,179 690,995 5,799 0.84%521 Bowes Creek Special Service Area 1 - - 5 N/A5300 Sunvale SBA SW 37 1 488 488 13 2.64%5301 Middle Creek SBA SW38 1 1,950 1,950 10 0.52%5302 Shirewood Farm SSA SW39 - 2,349 2,349 8 0.33%5303 Ogden Gardens SBA SW40 4 2,540 2,540 36 1.42%5304 Wildwood West SBA SW41 6 9,752 9,752 74 0.76%5305 Savanna Lakes SBA SW42 - 2,843 2,843 - 0.00%5306 Cheval DeSelle Venetian SBA SW43 - 5,009 5,009 - 0.00%5308 Plank Road Estates SBA SW45 - 4,925 4,925 - 0.00%5310 Exposition View SBA SW47 - 4,105 4,105 - 0.00%5311 Pasadena Drive SBA SW48 - 2,881 2,881 - 0.00%5312 Tamara Dittman SBA SW 50 - 1,215 1,215 - 0.00%

760 Debt Service 5,640 7,635,307 6,936,032 6,357,186 91.65%

601 Public Building Commission 1,224 11,000 11,000 9,257 84.15%620 Motor Fuel Tax Debt Service 2,097 3,513,029 3,513,029 3,508,445 99.87%621 Transit Sales Tax Debt Service 96 825 825 726 88.02%622 Recovery Zone Bond Debt Service 563 887,778 887,778 315,598 35.55%623 JJC/AJC Refunding Debt Service 1,660 3,222,675 2,523,400 2,523,161 99.99%

Packet Pg. 12

Current Month

Transactions





Total % Received


800 Other- Countywide Expenses 1,527,171 40,227,637 30,642,212 4,385,819 14.31%100 County Automation 574 52,046 7,046 1,994 28.30%110 Illinois Municipal Retirement 2,804 6,836,586 6,836,586 25,811 0.38%111 FICA/Social Security 1,581 3,754,015 3,453,332 15,719 0.46%112 Special Reserve 8 305,033 33 855 2,589.91%113 Emergency Reserve 2,887 20,900 20,900 18,464 88.35%114 Property Tax Freeze Protection 1,204 5,500 5,500 5,742 104.41%125 Public Safety Sales Tax 126,007 2,642,582 1,493,810 130,111 8.71%126 Transit Sales Tax Contingency 42,243 498,395 498,395 44,054 8.84%127 Judicial Technology Sales Tax 85,487 4,336,405 991,890 98,467 9.93%500 Capital Projects 17,782 3,923,704 1,234,458 1,063,788 86.17%510 Capital Improvement Bond Const 35 - - 267 N/A652 Health Insurance Fund 1,246,560 17,852,471 16,100,262 2,980,547 18.51%

900 Contingency 1,830 15,000 15,000 13,834 92.22%

660 Working Cash 1,830 15,000 15,000 13,834 92.22%

Grand Total 9,254,473 232,845,990 195,935,819 31,304,579 15.98%

Packet Pg. 13

Current Month

Transactions



YTD Encumbrances

Total % Used

010 County Board 169,548 7,728,339 4,575,601 0 59.21%001 General Fund 94,836 1,283,950 334,306 0 26.04%120 Grand Victoria Casino Elgin 73,194 4,852,151 4,236,233 0 87.31%430 Farmland Preservation 1,517 1,592,238 5,062 0 0.32%

040 Finance 66,226 811,765 194,280 86,060 34.53%001 General Fund 66,226 811,765 194,280 86,060 34.53%

060 Information Technologies 274,730 5,477,878 1,409,001 66,269 26.93%001 General Fund 213,161 3,636,601 1,177,165 50,579 33.76%101 Geographic Information Systems 61,569 1,841,277 231,836 15,690 13.44%

080 Building Management 384,804 4,784,074 928,584 23,115 19.89%001 General Fund 384,804 4,784,074 928,584 23,115 19.89%

120 Human Resource Management 308,379 2,370,444 1,277,203 24,155 54.90%001 General Fund 26,825 403,554 88,864 0 22.02%010 Insurance Liability 281,554 1,966,890 1,188,339 24,155 61.65%

140 County Auditor 32,330 325,250 80,680 0 24.81%001 General Fund 32,330 325,250 80,680 0 24.81%

150 Treasurer/Collector 41,640 774,218 160,931 0 20.79%001 General Fund 40,968 626,023 160,020 0 25.56%150 Tax Sale Automation 672 148,195 911 0 0.61%

170 Supervisor of Assessments 78,172 1,270,095 290,351 3,357 23.12%001 General Fund 78,172 1,270,095 290,351 3,357 23.12%

190 County Clerk 153,052 3,269,726 549,308 7,287 17.02%001 General Fund 139,961 3,028,295 506,121 7,287 16.95%160 Vital Records Automation 13,090 241,431 43,187 0 17.89%

210 Recorder 80,664 1,780,478 346,666 0 19.47%001 General Fund 61,259 797,240 210,156 0 26.36%170 Recorder's Automation 19,404 983,238 136,510 0 13.88%

230 Regional Office of Education 21,625 302,134 81,240 0 26.89%001 General Fund 21,625 302,134 81,240 0 26.89%

240 Judiciary and Courts 247,637 3,483,618 761,684 1,147 21.90%001 General Fund 233,785 3,301,538 706,032 1,147 21.42%195 Children's Waiting Room 9,944 105,558 41,410 0 39.23%196 D.U.I. 0 6,204 0 0 0.00%197 Foreclosure Mediation Fund 3,907 70,318 14,242 0 20.25%

Kane County Expenditure Report - SummaryThrough Februay 29, 2016 (25.0% YTD, 26.92% Payroll)

Packet Pg. 14

Current Month

Transactions



YTD Encumbrances

Total % Used


250 Circuit Clerk 571,853 7,974,750 1,864,879 0 23.38%001 General Fund 336,688 4,548,009 1,120,558 0 24.64%200 Court Automation 85,429 1,368,439 328,263 0 23.99%201 Court Document Storage 107,071 1,376,906 279,589 0 20.31%202 Child Support 8,989 159,781 23,221 0 14.53%203 Circuit Clerk Admin Services 25,561 398,776 85,403 0 21.42%204 Circuit Clk Electronic Citation 8,115 122,839 27,845 0 22.67%

300 State's Attorney 693,994 9,351,894 2,288,465 4,362 24.52%001 General Fund 406,769 5,334,627 1,317,828 3,582 24.77%010 Insurance Liability 71,861 1,109,678 211,586 0 19.07%220 Title IV-D 49,886 687,487 171,385 0 24.93%221 Drug Prosecution 27,578 385,149 96,597 0 25.08%222 Victim Coordinator Services 12,874 163,696 43,719 0 26.71%223 Domestic Violence 39,201 479,580 140,142 0 29.22%224 Environmental Prosecution 10,070 138,658 47,034 0 33.92%230 Child Advocacy Center 71,470 993,019 233,334 0 23.50%231 Equitable Sharing Program 4,285 60,000 4,285 780 8.44%490 Kane County Law Enforcement 0 0 22,555 0 0

360 Public Defender 273,826 3,629,188 904,404 227 24.93%001 General Fund 273,826 3,629,188 904,404 227 24.93%

370 Law Library 10,029 310,754 62,223 0 20.02%250 Law Library 10,029 310,754 62,223 0 20.02%

380 Sheriff 2,136,845 28,876,135 7,057,017 0 24.44%001 General Fund 1,962,277 26,391,332 6,461,896 0 24.48%259 Transportation Safety Highway HB 0 5,000 0 0 0.00%260 Court Security 174,568 2,454,378 595,121 0 24.25%262 AJF Medical Cost 0 25,425 0 0 0.00%

420 Merit Commission 4,331 102,084 11,847 0 11.61%001 General Fund 4,331 102,084 11,847 0 11.61%

425 Kane Comm 136,894 2,009,759 507,567 12,031 25.85%269 Kane Comm 136,894 2,009,759 507,567 12,031 25.85%

430 Court Services 1,016,310 15,438,849 3,571,635 22,041 23.28%001 General Fund 903,149 12,484,697 2,965,550 12,956 23.86%270 Probation Services 32,279 1,388,908 316,038 9,085 23.41%271 Substance Abuse Screening 0 80,000 5,409 0 6.76%273 Drug Court Special Resources 76,371 1,271,051 266,542 0 20.97%275 Juvenile Drug Court 4,512 204,193 18,196 0 8.91%276 Probation Victim Services 0 10,000 0 0 0.00%277 Victim Impact Panel 0 0 (100) 0 0

Packet Pg. 15

Current Month

Transactions



YTD Encumbrances

Total % Used


490 Coroner 58,150 970,975 204,612 0 21.07%001 General Fund 57,388 869,475 199,410 0 22.93%289 Coroner Administration 762 101,500 5,202 0 5.13%


510 Emergency Management Services 15,258 203,992 50,699 81 24.89%001 General Fund 15,258 203,992 50,699 81 24.89%

520 Transportation 1,863,816 60,461,425 7,212,433 22,899,772 49.80%300 County Highway 440,656 7,967,596 1,161,481 3,046,043 52.81%301 County Bridge 0 500,000 13,195 352,242 73.09%302 Motor Fuel Tax 366,303 7,618,230 4,456,286 1,310,707 75.70%303 County Highway Matching 0 68,000 0 54,500 80.15%304 Motor Fuel Local Option 392,030 13,933,768 800,822 2,270,796 22.04%305 Transportation Sales Tax 612,833 19,894,458 684,096 10,155,602 54.49%540 Transportation Capital 37,136 3,680,712 54,960 3,695,156 101.89%550 Aurora Area Impact Fees 0 143,059 0 51,059 35.69%551 Campton Hills Impact Fees 0 173,607 0 39,107 22.53%552 Greater Elgin Impact Fees 12,595 416,804 29,579 237,820 64.15%553 Northwest Impact Fees 0 133,390 0 0 0.00%554 Southwest Impact Fees 0 51,820 0 0 0.00%555 Tri-Cities Impact Fees 0 785,192 9,750 1,057,917 135.98%556 Upper Fox Impact Fees 0 705,105 0 622,702 88.31%557 West Central Impact Fees 0 10,100 0 0 0.00%558 North Impact Fees 0 1,079,584 0 0 0.00%559 Central Impact Fees 0 707,500 0 0 0.00%560 South Impact Fees 2,263 2,592,500 2,263 6,121 0.32%

580 Health 391,044 6,237,827 1,283,401 37,613 21.18%350 County Health 354,736 5,658,830 1,165,689 36,945 21.25%351 Kane Kares 36,308 578,997 117,711 668 20.45%

660 Veterans' Commission 21,530 331,071 68,816 107 20.82%380 Veterans' Commission 21,530 331,071 68,816 107 20.82%

670 Environmental Management 63,779 2,245,099 316,323 248,136 25.14%420 Stormwater Management 20,232 417,229 31,534 11,356 10.28%650 Enterprise Surcharge 43,547 1,799,870 284,789 236,780 28.98%651 Enterprise General 0 28,000 0 0 0.00%

Packet Pg. 16

Current Month

Transactions



YTD Encumbrances

Total % Used


690 Development 394,624 5,993,022 1,223,847 104,513 22.17%001 General Fund 122,044 1,524,384 389,781 5,651 25.94%400 Economic Development 14,120 228,858 14,120 0 6.17%401 Community Dev Block Program 80,578 1,182,178 494,443 2,511 42.04%402 HOME Program 40,888 767,869 93,852 0 12.22%404 Homeless Management Info Systems 34,039 133,745 47,823 0 35.76%405 Cost Share Drainage 51,405 530,000 71,081 41,439 21.23%406 OCR & Recovery Act Programs 360 448,503 1,260 0 0.28%407 Quality of Kane Grants 0 20,000 0 0 0.00%408 Neighborhood Stabilization Progr 38,458 292,386 38,458 0 13.15%409 Continuum of Care Planning Grant 1,071 17,863 3,621 0 20.27%520 Mill Creek Special Service Area 11,661 809,179 69,409 54,913 15.36%5300 Sunvale SBA SW 37 0 488 0 0 0.00%5301 Middle Creek SBA SW38 0 1,950 0 0 0.00%5302 Shirewood Farm SSA SW39 0 2,349 0 0 0.00%5303 Ogden Gardens SBA SW40 0 2,540 0 0 0.00%5304 Wildwood West SBA SW41 0 9,752 0 0 0.00%5305 Savanna Lakes SBA SW42 0 2,843 0 0 0.00%5306 Cheval DeSelle Venetian SBA SW43 0 5,009 0 0 0.00%5308 Plank Road Estates SBA SW45 0 4,925 0 0 0.00%5310 Exposition View SBA SW47 0 4,105 0 0 0.00%5311 Pasadena Drive SBA SW48 0 2,881 0 0 0.00%5312 Tamara Dittman SBA SW 50 0 1,215 0 0 0.00%

760 Debt Service 0 7,635,307 6,700,029 0 87.75%601 Public Building Commission 0 11,000 0 0 0.00%620 Motor Fuel Tax Debt Service 0 3,513,029 3,037,000 0 86.45%621 Transit Sales Tax Debt Service 0 825 0 0 0.00%622 Recovery Zone Bond Debt Service 0 887,778 775,504 0 87.35%623 JJC/AJC Refunding Debt Service 0 3,222,675 2,887,525 0 89.60%

800 Other- Countywide Expenses 2,825,280 46,619,940 15,003,361 2,496,117 37.54%001 General Fund 72,325 6,392,303 4,699,121 11,924 73.70%100 County Automation 0 52,046 0 0 0.00%110 Illinois Municipal Retirement 481,811 6,836,586 1,711,871 0 25.04%111 FICA/Social Security 274,000 3,754,015 967,649 0 25.78%112 Special Reserve 0 305,033 305,000 0 99.99%113 Emergency Reserve 0 20,900 0 0 0.00%114 Property Tax Freeze Protection 0 5,500 0 0 0.00%125 Public Safety Sales Tax 91,641 2,642,582 1,195,402 18,690 45.94%126 Transit Sales Tax Contingency 0 498,395 0 0 0.00%127 Judicial Technology Sales Tax 274,982 4,336,405 887,627 1,838,651 62.87%500 Capital Projects 99,423 3,923,704 124,612 626,853 19.15%652 Health Insurance Fund 1,531,098 17,852,471 5,112,080 0 28.64%

900 Contingency 0 1,192,385 0 0 0.00%001 General Fund 0 1,177,385 0 0 0.00%660 Working Cash 0 15,000 0 0 0.00%

Grand Total 12,388,974 232,845,990 59,172,451 26,046,057 36.60%

Packet Pg. 17

Current Month

Transactions



YTD Encumbrances Total % Used

010 County Board 169,548 7,728,339 4,575,601 0 59.21%001 General Fund 94,836 1,283,950 334,306 0 26.04%

Personnel Services- Salaries & Wages 72,692 951,050 254,402 0 26.75%Personnel Services- Employee Benefits 20,383 271,346 60,838 0 22.42%Contractual Services 1,027 52,254 18,078 0 34.60%Commodities 734 9,300 989 0 10.63%

120 Grand Victoria Casino Elgin 73,194 4,852,151 4,236,233 0 87.31%Personnel Services- Salaries & Wages 4,763 62,286 16,670 0 26.76%Personnel Services- Employee Benefits 2,177 88,723 6,930 0 7.81%Contractual Services 63,512 975,719 538,071 0 55.15%Commodities 2,743 3,300 2,743 0 83.11%Capital 0 108,000 57,697 0 53.42%Transfers Out 0 3,614,123 3,614,123 0 100.00%

430 Farmland Preservation 1,517 1,592,238 5,062 0 0.32%Personnel Services- Salaries & Wages 0 30,341 0 0 0.00%Personnel Services- Employee Benefits 0 8,538 0 0 0.00%Contractual Services 1,517 77,209 5,062 0 6.56%Capital 0 1,476,150 0 0 0.00%

040 Finance 66,226 811,765 194,280 86,060 34.53%001 General Fund 66,226 811,765 194,280 86,060 34.53%

Personnel Services- Salaries & Wages 39,017 559,378 142,674 0 25.51%Personnel Services- Employee Benefits 7,961 98,858 23,750 0 24.02%Contractual Services 19,244 148,529 26,345 86,060 75.68%Commodities 4 5,000 1,511 0 30.23%

060 Information Technologies 274,730 5,477,878 1,409,001 66,269 26.93%001 General Fund 213,161 3,636,601 1,177,165 50,579 33.76%

Personnel Services- Salaries & Wages 168,267 2,229,855 587,180 0 26.33%Personnel Services- Employee Benefits 29,263 406,420 87,204 0 21.46%Contractual Services 9,729 900,926 488,048 32,836 57.82%Commodities 5,902 99,400 14,733 17,743 32.67%

101 Geographic Information Systems 61,569 1,841,277 231,836 15,690 13.44%Personnel Services- Salaries & Wages 44,716 599,050 156,358 0 26.10%Personnel Services- Employee Benefits 14,399 190,997 47,110 0 24.67%Contractual Services 2,454 880,411 13,778 15,690 3.35%Commodities 0 31,200 309 0 0.99%Capital 0 125,338 0 0 0.00%Transfers Out 0 14,281 14,281 0 100.00%

080 Building Management 384,804 4,784,074 928,584 23,115 19.89%001 General Fund 384,804 4,784,074 928,584 23,115 19.89%

Personnel Services- Salaries & Wages 93,031 1,268,768 317,591 0 25.03%Personnel Services- Employee Benefits 16,665 242,485 46,535 0 19.19%Contractual Services 109,630 1,536,023 271,493 22,828 19.16%

Kane County Expenditure Report - DetailThrough Februay 29, 2016 (25.0% YTD, 26.92% Payroll)

Packet Pg. 18

Current Month

Transactions





Commodities 165,477 1,736,798 292,965 287 16.88%

120 Human Resource Management 308,379 2,370,444 1,277,203 24,155 54.90%001 General Fund 26,825 403,554 88,864 0 22.02%

Personnel Services- Salaries & Wages 21,063 310,973 73,073 0 23.50%Personnel Services- Employee Benefits 4,789 71,285 14,083 0 19.76%Contractual Services 280 16,400 950 0 5.79%Commodities 693 4,896 758 0 15.49%

010 Insurance Liability 281,554 1,966,890 1,188,339 24,155 61.65%Personnel Services- Salaries & Wages 11,041 144,411 38,644 0 26.76%Personnel Services- Employee Benefits 3,197 42,095 10,086 0 23.96%Contractual Services 267,315 1,780,384 1,139,609 0 64.01%Capital 0 0 0 24,155 0

140 County Auditor 32,330 325,250 80,680 0 24.81%001 General Fund 32,330 325,250 80,680 0 24.81%


150 Treasurer/Collector 41,640 774,218 160,931 0 20.79%001 General Fund 40,968 626,023 160,020 0 25.56%


150 Tax Sale Automation 672 148,195 911 0 0.61%Personnel Services- Salaries & Wages 0 30,000 0 0 0.00%Personnel Services- Employee Benefits 0 2,341 0 0 0.00%Contractual Services 540 46,354 780 0 1.68%Commodities 131 10,000 131 0 1.31%Capital 0 59,500 0 0 0.00%

170 Supervisor of Assessments 78,172 1,270,095 290,351 3,357 23.12%001 General Fund 78,172 1,270,095 290,351 3,357 23.12%

Personnel Services- Salaries & Wages 62,501 874,058 230,226 0 26.34%Personnel Services- Employee Benefits 15,011 183,037 44,721 0 24.43%Contractual Services 491 190,000 14,910 3,108 9.48%Commodities 170 23,000 494 249 3.23%

190 County Clerk 153,052 3,269,726 549,308 7,287 17.02%001 General Fund 139,961 3,028,295 506,121 7,287 16.95%

Personnel Services- Salaries & Wages 89,193 1,263,869 307,689 0 24.34%Personnel Services- Employee Benefits 15,166 269,006 44,238 0 16.45%Contractual Services 15,606 1,102,770 113,388 0 10.28%Commodities 19,997 392,650 40,806 7,287 12.25%

Packet Pg. 19

Current Month

Transactions





160 Vital Records Automation 13,090 241,431 43,187 0 17.89%Personnel Services- Salaries & Wages 5,139 64,201 16,017 0 24.95%Personnel Services- Employee Benefits 1,751 21,821 5,300 0 24.29%Contractual Services 6,200 66,258 14,446 0 21.80%Commodities 0 18,000 61 0 0.34%Contingency and Other 0 41,151 0 0 0.00%Capital 0 30,000 7,364 0 24.55%

210 Recorder 80,664 1,780,478 346,666 0 19.47%001 General Fund 61,259 797,240 210,156 0 26.36%


170 Recorder's Automation 19,404 983,238 136,510 0 13.88%Personnel Services- Salaries & Wages 12,818 202,522 43,882 0 21.67%Personnel Services- Employee Benefits 5,415 68,504 17,175 0 25.07%Contractual Services 20 324,412 66,033 0 20.35%Commodities 1,150 66,800 9,420 0 14.10%Capital 0 321,000 0 0 0.00%

230 Regional Office of Education 21,625 302,134 81,240 0 26.89%001 General Fund 21,625 302,134 81,240 0 26.89%

Personnel Services- Salaries & Wages 19,746 252,532 74,123 0 29.35%Personnel Services- Employee Benefits 1,880 32,027 7,117 0 22.22%Contractual Services 0 17,575 0 0 0.00%

240 Judiciary and Courts 247,637 3,483,618 761,684 1,147 21.90%001 General Fund 233,785 3,301,538 706,032 1,147 21.42%

Personnel Services- Salaries & Wages 103,359 1,442,918 361,905 0 25.08%Personnel Services- Employee Benefits 26,391 385,145 76,426 0 19.84%Contractual Services 94,493 1,395,975 255,720 0 18.32%Commodities 9,543 77,500 11,981 1,147 16.94%

195 Children's Waiting Room 9,944 105,558 41,410 0 39.23%Contractual Services 9,944 93,000 29,410 0 31.62%Contingency and Other 0 558 0 0 0.00%Transfers Out 0 12,000 12,000 0 100.00%

196 D.U.I. 0 6,204 0 0 0.00%Contractual Services 0 6,000 0 0 0.00%Contingency and Other 0 204 0 0 0.00%

197 Foreclosure Mediation Fund 3,907 70,318 14,242 0 20.25%

Packet Pg. 20

Current Month

Transactions





Personnel Services- Salaries & Wages 2,885 32,686 9,945 0 30.43%Personnel Services- Employee Benefits 1,023 12,029 3,287 0 27.32%Contractual Services 0 9,301 0 0 0.00%Commodities 0 4,000 1,011 0 25.27%Contingency and Other 0 12,302 0 0 0.00%

250 Circuit Clerk 571,853 7,974,750 1,864,879 0 23.38%001 General Fund 336,688 4,548,009 1,120,558 0 24.64%

Personnel Services- Salaries & Wages 264,790 3,474,230 907,574 0 26.12%Personnel Services- Employee Benefits 69,629 902,463 205,728 0 22.80%Contractual Services 1,712 100,175 4,974 0 4.97%Commodities 557 57,000 2,282 0 4.00%Capital 0 14,141 0 0 0.00%

200 Court Automation 85,429 1,368,439 328,263 0 23.99%Personnel Services- Salaries & Wages 47,553 653,323 166,159 0 25.43%Personnel Services- Employee Benefits 16,116 232,463 52,534 0 22.60%Contractual Services 21,759 340,753 109,570 0 32.16%Commodities 0 37,400 0 0 0.00%Capital 0 104,500 0 0 0.00%

201 Court Document Storage 107,071 1,376,906 279,589 0 20.31%Personnel Services- Salaries & Wages 40,406 607,447 141,108 0 23.23%Personnel Services- Employee Benefits 20,002 279,699 63,233 0 22.61%Contractual Services 30,034 411,133 50,470 0 12.28%Commodities 7,356 53,833 15,505 0 28.80%Capital 9,273 24,794 9,273 0 37.40%

202 Child Support 8,989 159,781 23,221 0 14.53%Personnel Services- Salaries & Wages 4,186 55,986 14,579 0 26.04%Personnel Services- Employee Benefits 1,736 26,532 5,536 0 20.86%Contractual Services 3,067 75,763 3,067 0 4.05%Commodities 0 1,500 39 0 2.63%

203 Circuit Clerk Admin Services 25,561 398,776 85,403 0 21.42%Personnel Services- Salaries & Wages 18,479 225,167 63,125 0 28.03%Personnel Services- Employee Benefits 6,653 81,808 21,256 0 25.98%Contractual Services 195 21,711 195 0 0.90%Commodities 234 70,090 826 0 1.18%

204 Circuit Clk Electronic Citation 8,115 122,839 27,845 0 22.67%Personnel Services- Salaries & Wages 5,588 73,633 19,557 0 26.56%Personnel Services- Employee Benefits 2,488 32,792 7,953 0 24.25%Contractual Services 40 15,183 40 0 0.26%Commodities 0 1,231 294 0 23.88%

300 State's Attorney 693,994 9,351,894 2,288,465 4,362 24.52%001 General Fund 406,769 5,334,627 1,317,828 3,582 24.77%

Packet Pg. 21

Current Month

Transactions





Personnel Services- Salaries & Wages 283,295 4,069,120 993,650 0 24.42%Personnel Services- Employee Benefits 57,532 771,164 170,449 0 22.10%Contractual Services 61,223 372,122 86,115 0 23.14%Commodities 4,719 63,550 8,943 3,582 19.71%Transfers Out 0 58,671 58,671 0 100.00%

010 Insurance Liability 71,861 1,109,678 211,586 0 19.07%Personnel Services- Salaries & Wages 45,790 632,643 153,523 0 24.27%Personnel Services- Employee Benefits 15,118 204,105 42,237 0 20.69%Contractual Services 10,953 266,080 15,409 0 5.79%Commodities 0 6,850 417 0 6.09%

220 Title IV-D 49,886 687,487 171,385 0 24.93%Personnel Services- Salaries & Wages 35,110 466,041 123,285 0 26.45%Personnel Services- Employee Benefits 14,671 190,699 47,608 0 24.97%Contractual Services 81 23,447 351 0 1.50%Commodities 24 7,300 141 0 1.93%

221 Drug Prosecution 27,578 385,149 96,597 0 25.08%Personnel Services- Salaries & Wages 20,922 284,262 73,228 0 25.76%Personnel Services- Employee Benefits 6,655 88,777 23,369 0 26.32%Contractual Services 0 11,315 0 0 0.00%Commodities 0 795 0 0 0.00%

222 Victim Coordinator Services 12,874 163,696 43,719 0 26.71%Personnel Services- Salaries & Wages 9,857 122,739 33,029 0 26.91%Personnel Services- Employee Benefits 3,017 34,225 10,516 0 30.73%Contractual Services 0 5,937 175 0 2.95%Commodities 0 795 0 0 0.00%

223 Domestic Violence 39,201 479,580 140,142 0 29.22%Personnel Services- Salaries & Wages 29,161 336,657 104,075 0 30.91%Personnel Services- Employee Benefits 9,992 119,857 35,632 0 29.73%Contractual Services 48 20,990 435 0 2.07%Commodities 0 2,076 0 0 0.00%

224 Environmental Prosecution 10,070 138,658 47,034 0 33.92%Personnel Services- Salaries & Wages 7,289 97,722 35,605 0 36.43%Personnel Services- Employee Benefits 2,781 37,045 11,429 0 30.85%Contractual Services 0 3,891 0 0 0.00%

230 Child Advocacy Center 71,470 993,019 233,334 0 23.50%Personnel Services- Salaries & Wages 45,574 625,184 160,466 0 25.67%Personnel Services- Employee Benefits 15,974 211,734 54,631 0 25.80%Contractual Services 6,903 140,801 15,110 0 10.73%Commodities 3,018 15,300 3,128 0 20.44%

231 Equitable Sharing Program 4,285 60,000 4,285 780 8.44%Contractual Services 0 20,000 0 0 0.00%Commodities 4,285 40,000 4,285 780 12.66%

Packet Pg. 22

Current Month

Transactions





490 Kane County Law Enforcement 0 0 22,555 0 0Personnel Services- Salaries & Wages 0 0 2,700 0 0Personnel Services- Employee Benefits 0 0 206 0 0Contractual Services 0 0 19,649 0 0

360 Public Defender 273,826 3,629,188 904,404 227 24.93%001 General Fund 273,826 3,629,188 904,404 227 24.93%

Personnel Services- Salaries & Wages 223,056 2,939,288 764,544 0 26.01%Personnel Services- Employee Benefits 44,353 554,351 131,026 0 23.64%Contractual Services 997 76,264 2,113 0 2.77%Commodities 5,420 59,285 6,722 227 11.72%

370 Law Library 10,029 310,754 62,223 0 20.02%250 Law Library 10,029 310,754 62,223 0 20.02%

Personnel Services- Salaries & Wages 12,753 167,754 44,624 0 26.60%Personnel Services- Employee Benefits 4,549 58,464 14,739 0 25.21%Contractual Services 0 17,975 2,808 0 15.62%Commodities -7,272 66,561 51 0 0.08%

380 Sheriff 2,136,845 28,876,135 7,057,017 0 24.44%001 General Fund 1,962,277 26,391,332 6,461,896 0 24.48%

Personnel Services- Salaries & Wages 1,432,561 19,430,311 5,092,274 0 26.21%Personnel Services- Employee Benefits 257,995 3,603,198 764,904 0 21.23%Contractual Services 181,247 2,036,378 372,352 0 18.29%Commodities 90,474 1,321,445 232,366 0 17.58%

259 Transportation Safety Highway HB 0 5,000 0 0 0.00%Personnel Services- Salaries & Wages 0 5,000 0 0 0.00%

260 Court Security 174,568 2,454,378 595,121 0 24.25%Personnel Services- Salaries & Wages 121,541 1,652,706 427,467 0 25.86%Personnel Services- Employee Benefits 48,945 655,084 158,042 0 24.13%Contractual Services 4,000 124,488 9,130 0 7.33%Commodities 81 22,100 480 0 2.17%

262 AJF Medical Cost 0 25,425 0 0 0.00%Contractual Services 0 25,425 0 0 0.00%

420 Merit Commission 4,331 102,084 11,847 0 11.61%001 General Fund 4,331 102,084 11,847 0 11.61%

Personnel Services- Salaries & Wages 3,366 75,534 10,461 0 13.85%Contractual Services 965 21,800 1,386 0 6.36%Commodities 0 4,750 0 0 0.00%

425 Kane Comm 136,894 2,009,759 507,567 12,031 25.85%269 Kane Comm 136,894 2,009,759 507,567 12,031 25.85%

Personnel Services- Salaries & Wages 101,903 1,328,710 353,580 0 26.61%Personnel Services- Employee Benefits 34,537 502,463 111,891 0 22.27%Contractual Services 370 142,103 10,148 11,786 15.44%Commodities 84 6,500 1,965 244 33.99%

Packet Pg. 23

Current Month

Transactions





Transfers Out 0 29,983 29,983 0 100.00%

430 Court Services 1,016,310 15,438,849 3,571,635 22,041 23.28%001 General Fund 903,149 12,484,697 2,965,550 12,956 23.86%

Personnel Services- Salaries & Wages 627,666 8,624,164 2,219,721 0 25.74%Personnel Services- Employee Benefits 125,794 1,699,155 370,156 0 21.78%Contractual Services 121,998 1,900,078 299,110 8,775 16.20%Commodities 27,690 261,300 65,777 3,887 26.66%Capital 0 0 10,787 294 0

270 Probation Services 32,279 1,388,908 316,038 9,085 23.41%Contractual Services 32,279 1,171,500 112,126 0 9.57%Commodities 0 25,300 11,805 9,085 82.57%Transfers Out 0 192,108 192,108 0 100.00%

271 Substance Abuse Screening 0 80,000 5,409 0 6.76%Contractual Services 0 75,000 5,312 0 7.08%Commodities 0 5,000 98 0 1.95%

273 Drug Court Special Resources 76,371 1,271,051 266,542 0 20.97%Personnel Services- Salaries & Wages 31,170 396,065 107,827 0 27.22%Personnel Services- Employee Benefits 12,683 161,782 40,421 0 24.98%Contractual Services 31,435 694,406 114,341 0 16.47%Commodities 713 18,798 3,583 0 19.06%Capital 370 0 370 0 0

275 Juvenile Drug Court 4,512 204,193 18,196 0 8.91%Personnel Services- Salaries & Wages 3,374 43,833 11,808 0 26.94%Personnel Services- Employee Benefits 1,046 13,625 3,424 0 25.13%Contractual Services 92 144,235 2,963 0 2.05%Commodities 0 2,500 0 0 0.00%

276 Probation Victim Services 0 10,000 0 0 0.00%Contractual Services 0 10,000 0 0 0.00%

277 Victim Impact Panel 0 0 (100) 0 0Contractual Services 0 0 (100) 0 0

490 Coroner 58,150 970,975 204,612 0 21.07%001 General Fund 57,388 869,475 199,410 0 22.93%


289 Coroner Administration 762 101,500 5,202 0 5.13%Contractual Services 0 20,000 1,467 0 7.34%Commodities 762 51,500 3,735 0 7.25%Capital 0 30,000 0 0 0.00%

Packet Pg. 24

Current Month

Transactions






Personnel Services- Salaries & Wages 33,144 434,254 113,929 0 26.24%Personnel Services- Employee Benefits 12,643 139,905 38,409 0 27.45%Contractual Services 4,575 77,683 12,069 0 15.54%Commodities 2,245 67,400 11,357 7,222 27.57%Capital 0 11,000 9,600 2,445 109.50%Transfers Out 0 153,273 0 0 0.00%

510 Emergency Management Services 15,258 203,992 50,699 81 24.89%001 General Fund 15,258 203,992 50,699 81 24.89%

Personnel Services- Salaries & Wages 12,398 162,152 43,391 0 26.76%Personnel Services- Employee Benefits 1,658 20,532 4,951 0 24.11%Contractual Services 347 8,680 1,049 0 12.08%Commodities 857 12,628 1,308 81 10.99%

520 Transportation 1,863,816 60,461,425 7,212,433 22,899,772 49.80%300 County Highway 440,656 7,967,596 1,161,481 3,046,043 52.81%

Personnel Services- Salaries & Wages 178,740 2,607,410 623,485 0 23.91%Personnel Services- Employee Benefits 63,557 921,933 204,942 0 22.23%Contractual Services 85,166 1,777,653 126,608 1,974,828 118.21%Commodities 38,625 751,700 98,705 295,560 52.45%Capital 74,568 1,908,900 107,741 775,655 46.28%

301 County Bridge 0 500,000 13,195 352,242 73.09%Contractual Services 0 500,000 13,195 352,242 73.09%

302 Motor Fuel Tax 366,303 7,618,230 4,456,286 1,310,707 75.70%Personnel Services- Salaries & Wages 202,158 2,547,374 644,743 0 25.31%Personnel Services- Employee Benefits 70,392 976,593 223,977 0 22.93%Contractual Services 93,753 100,450 93,753 32,186 125%Capital 0 500,000 0 1,278,521 255.70%Transfers Out 0 3,493,813 3,493,813 0 100.00%

303 County Highway Matching 0 68,000 0 54,500 80.15%Commodities 0 68,000 0 54,500 80.15%

304 Motor Fuel Local Option 392,030 13,933,768 800,822 2,270,796 22.04%Contractual Services 321,563 11,624,660 404,233 672,306 9.26%Commodities 70,467 1,785,200 346,028 1,261,122 90.03%Capital 0 470,000 200 337,368 71.82%Transfers Out 0 53,908 50,361 0 93.42%

305 Transportation Sales Tax 612,833 19,894,458 684,096 10,155,602 54.49%Contractual Services 381,933 4,474,996 449,596 1,828,429 50.91%Capital 230,899 15,419,462 234,499 8,327,173 55.53%

540 Transportation Capital 37,136 3,680,712 54,960 3,695,156 101.89%Contractual Services 37,136 644,691 54,960 2,233,078 354.90%

Packet Pg. 25

Current Month

Transactions





Capital 0 3,036,021 0 1,462,078 48.16%

550 Aurora Area Impact Fees 0 143,059 0 51,059 35.69%Capital 0 136,059 0 51,059 37.53%Transfers Out 0 7,000 0 0 0.00%

551 Campton Hills Impact Fees 0 173,607 0 39,107 22.53%Capital 0 169,107 0 39,107 23.13%Transfers Out 0 4,500 0 0 0.00%

552 Greater Elgin Impact Fees 12,595 416,804 29,579 237,820 64.15%Contractual Services 12,595 192,804 29,579 237,820 138.69%Capital 0 220,000 0 0 0.00%Transfers Out 0 4,000 0 0 0.00%

553 Northwest Impact Fees 0 133,390 0 0 0.00%Contractual Services 0 109,600 0 0 0.00%Capital 0 22,540 0 0 0.00%Transfers Out 0 1,250 0 0 0.00%

554 Southwest Impact Fees 0 51,820 0 0 0.00%Capital 0 49,320 0 0 0.00%Transfers Out 0 2,500 0 0 0.00%

555 Tri-Cities Impact Fees 0 785,192 9,750 1,057,917 135.98%Contractual Services 0 200,000 9,750 409,695 209.72%Capital 0 581,442 0 648,222 111.49%Transfers Out 0 3,750 0 0 0.00%

556 Upper Fox Impact Fees 0 705,105 0 622,702 88.31%Contractual Services 0 700,105 0 619,312 88.46%Capital 0 0 0 3,390 0Transfers Out 0 5,000 0 0 0.00%

557 West Central Impact Fees 0 10,100 0 0 0.00%Capital 0 9,600 0 0 0.00%Transfers Out 0 500 0 0 0.00%

558 North Impact Fees 0 1,079,584 0 0 0.00%Capital 0 1,053,334 0 0 0.00%Transfers Out 0 26,250 0 0 0.00%

559 Central Impact Fees 0 707,500 0 0 0.00%Capital 0 700,000 0 0 0.00%Transfers Out 0 7,500 0 0 0.00%

560 South Impact Fees 2,263 2,592,500 2,263 6,121 0.32%Contractual Services 2,263 810,000 2,263 6,121 1.04%Capital 0 1,760,000 0 0 0.00%Transfers Out 0 22,500 0 0 0.00%

Packet Pg. 26

Current Month

Transactions





580 Health 391,044 6,237,827 1,283,401 37,613 21.18%350 County Health 354,736 5,658,830 1,165,689 36,945 21.25%

Personnel Services- Salaries & Wages 223,000 3,128,786 779,736 0 24.92%Personnel Services- Employee Benefits 84,649 1,274,286 272,323 0 21.37%Contractual Services 41,860 943,824 102,007 34,584 14.47%Commodities 5,226 286,934 11,623 2,360 4.87%Capital 0 25,000 0 0 0.00%

351 Kane Kares 36,308 578,997 117,711 668 20.45%Personnel Services- Salaries & Wages 23,562 315,113 80,998 0 25.70%Personnel Services- Employee Benefits 9,640 151,732 30,556 0 20.14%Contractual Services 3,065 88,339 5,942 550 7.35%Commodities 42 23,813 215 118 1.40%

660 Veterans' Commission 21,530 331,071 68,816 107 20.82%380 Veterans' Commission 21,530 331,071 68,816 107 20.82%


670 Environmental Management 63,779 2,245,099 316,323 248,136 25.14%420 Stormwater Management 20,232 417,229 31,534 11,356 10.28%

Personnel Services- Salaries & Wages 2,535 23,982 8,889 0 37.07%Personnel Services- Employee Benefits 711 5,891 2,358 0 40.03%Contractual Services 16,985 385,856 20,286 11,356 8.20%Commodities 0 1,500 0 0 0.00%

650 Enterprise Surcharge 43,547 1,799,870 284,789 236,780 28.98%Personnel Services- Salaries & Wages 12,647 167,812 46,896 0 27.95%Personnel Services- Employee Benefits 3,568 46,119 12,268 0 26.60%Contractual Services 27,160 1,393,952 53,618 236,525 20.81%Commodities 171 19,100 (880) 256 (3.27%)Transfers Out 0 172,887 172,887 0 100.00%

651 Enterprise General 0 28,000 0 0 0.00%Contingency and Other 0 28,000 0 0 0.00%

690 Development 394,624 5,993,022 1,223,847 104,513 22.17%001 General Fund 122,044 1,524,384 389,781 5,651 25.94%

Personnel Services- Salaries & Wages 89,835 1,156,792 314,926 0 27.22%Personnel Services- Employee Benefits 15,669 197,573 46,647 0 23.61%Contractual Services 12,794 137,294 20,775 4,500 18.41%Commodities 3,745 32,725 7,432 1,151 26.23%

400 Economic Development 14,120 228,858 14,120 0 6.17%Personnel Services- Salaries & Wages 0 133,301 0 0 0.00%

Packet Pg. 27

Current Month

Transactions





Personnel Services- Employee Benefits 0 43,329 0 0 0.00%Contractual Services 14,120 51,828 14,120 0 27.24%Commodities 0 400 0 0 0.00%

401 Community Dev Block Program 80,578 1,182,178 494,443 2,511 42.04%Personnel Services- Salaries & Wages 8,137 116,155 28,138 0 24.22%Personnel Services- Employee Benefits 2,743 43,212 8,835 0 20.45%Contractual Services 69,698 996,861 446,899 0 44.83%Commodities 0 2,150 0 0 0.00%Capital 0 2,000 0 2,511 125.54%Transfers Out 0 21,800 10,571 0 48.49%

402 HOME Program 40,888 767,869 93,852 0 12.22%Personnel Services- Salaries & Wages 3,541 46,309 12,392 0 26.76%Personnel Services- Employee Benefits 947 14,138 3,151 0 22.29%Contractual Services 36,401 704,872 78,308 0 11.11%Commodities 0 1,050 0 0 0.00%Capital 0 1,500 0 0 0.00%

404 Homeless Management Info Systems 34,039 133,745 47,823 0 35.76%Personnel Services- Salaries & Wages 2,511 32,839 8,788 0 26.76%Personnel Services- Employee Benefits 808 10,657 2,641 0 24.78%Contractual Services 15,762 71,627 21,437 0 29.93%Commodities 0 200 0 0 0.00%Capital 14,958 18,422 14,958 0 81.20%

405 Cost Share Drainage 51,405 530,000 71,081 41,439 21.23%Contractual Services 37,405 215,000 53,721 24,465 36.37%Capital 14,000 315,000 17,360 16,974 10.90%

406 OCR & Recovery Act Programs 360 448,503 1,260 0 0.28%Personnel Services- Salaries & Wages 304 75,113 1,065 0 1.42%Personnel Services- Employee Benefits 56 29,462 195 0 0.66%Contractual Services 0 334,585 0 0 0.00%Commodities 0 5,843 0 0 0.00%Capital 0 3,500 0 0 0.00%

407 Quality of Kane Grants 0 20,000 0 0 0.00%Contractual Services 0 20,000 0 0 0.00%

408 Neighborhood Stabilization Progr 38,458 292,386 38,458 0 13.15%Contractual Services 38,458 292,386 38,458 0 13.15%

409 Continuum of Care Planning Grant 1,071 17,863 3,621 0 20.27%Personnel Services- Salaries & Wages 703 9,195 2,460 0 26.76%Personnel Services- Employee Benefits 368 4,607 1,161 0 25.20%Contractual Services 0 4,061 0 0 0.00%

Packet Pg. 28

Current Month

Transactions





520 Mill Creek Special Service Area 11,661 809,179 69,409 54,913 15.36%Personnel Services- Salaries & Wages 4,378 45,200 15,323 0 33.90%Personnel Services- Employee Benefits 897 8,891 3,050 0 34.30%Contractual Services 4,780 668,548 36,560 54,913 13.68%Commodities 1,605 74,140 2,076 0 2.80%Transfers Out 0 12,400 12,400 0 100.00%

5300 Sunvale SBA SW 37 0 488 0 0 0.00%Transfers Out 0 488 0 0 0.00%

5301 Middle Creek SBA SW38 0 1,950 0 0 0.00%Contractual Services 0 200 0 0 0.00%Transfers Out 0 1,750 0 0 0.00%

5302 Shirewood Farm SSA SW39 0 2,349 0 0 0.00%Transfers Out 0 2,349 0 0 0.00%

5303 Ogden Gardens SBA SW40 0 2,540 0 0 0.00%Transfers Out 0 2,540 0 0 0.00%

5304 Wildwood West SBA SW41 0 9,752 0 0 0.00%Contractual Services 0 1,000 0 0 0.00%Transfers Out 0 8,752 0 0 0.00%

5305 Savanna Lakes SBA SW42 0 2,843 0 0 0.00%Transfers Out 0 2,843 0 0 0.00%

5306 Cheval DeSelle Venetian SBA SW43 0 5,009 0 0 0.00%Contingency and Other 0 86 0 0 0.00%Transfers Out 0 4,923 0 0 0.00%

5308 Plank Road Estates SBA SW45 0 4,925 0 0 0.00%Contractual Services 0 1,575 0 0 0.00%Contingency and Other 0 92 0 0 0.00%Transfers Out 0 3,258 0 0 0.00%

5310 Exposition View SBA SW47 0 4,105 0 0 0.00%Contractual Services 0 466 0 0 0.00%Contingency and Other 0 62 0 0 0.00%Transfers Out 0 3,577 0 0 0.00%

5311 Pasadena Drive SBA SW48 0 2,881 0 0 0.00%Contractual Services 0 476 0 0 0.00%Contingency and Other 0 40 0 0 0.00%Transfers Out 0 2,365 0 0 0.00%

Packet Pg. 29

Current Month

Transactions





5312 Tamara Dittman SBA SW 50 0 1,215 0 0 0.00%Transfers Out 0 1,215 0 0 0.00%

760 Debt Service 0 7,635,307 6,700,029 0 87.75%601 Public Building Commission 0 11,000 0 0 0.00%

Contingency and Other 0 11,000 0 0 0.00%

620 Motor Fuel Tax Debt Service 0 3,513,029 3,037,000 0 86.45%Debt Service 0 3,513,029 3,037,000 0 86.45%

621 Transit Sales Tax Debt Service 0 825 0 0 0.00%Debt Service 0 825 0 0 0.00%

622 Recovery Zone Bond Debt Service 0 887,778 775,504 0 87.35%Contractual Services 0 500 450 0 90.00%Contingency and Other 0 7,400 0 0 0.00%Debt Service 0 879,878 775,054 0 88.09%

623 JJC/AJC Refunding Debt Service 0 3,222,675 2,887,525 0 89.60%Contractual Services 0 350 0 0 0.00%Debt Service 0 3,222,325 2,887,525 0 89.61%

800 Other- Countywide Expenses 2,825,280 46,619,940 15,003,361 2,496,117 37.54%001 General Fund 72,325 6,392,303 4,699,121 11,924 73.70%

Personnel Services- Salaries & Wages 5,539 110,513 19,387 0 17.54%Personnel Services- Employee Benefits 1,890 62,473 5,608 0 8.98%Contractual Services 3,342 713,357 197,699 0 27.71%Commodities 61,554 1,265,000 235,466 11,924 19.56%Transfers Out 0 4,240,960 4,240,960 0 100.00%

100 County Automation 0 52,046 0 0 0.00%Contingency and Other 0 2,046 0 0 0.00%Capital 0 50,000 0 0 0.00%

110 Illinois Municipal Retirement 481,811 6,836,586 1,711,871 0 25.04%Personnel Services- Employee Benefits 481,811 6,824,059 1,711,871 0 25.09%Contingency and Other 0 12,527 0 0 0.00%

111 FICA/Social Security 274,000 3,754,015 967,649 0 25.78%Personnel Services- Employee Benefits 274,000 3,754,015 967,649 0 25.78%

112 Special Reserve 0 305,033 305,000 0 99.99%Contingency and Other 0 33 0 0 0.00%Transfers Out 0 305,000 305,000 0 100.00%

113 Emergency Reserve 0 20,900 0 0 0.00%Contingency and Other 0 20,900 0 0 0.00%

114 Property Tax Freeze Protection 0 5,500 0 0 0.00%Contingency and Other 0 5,500 0 0 0.00%

Packet Pg. 30

Current Month

Transactions





125 Public Safety Sales Tax 91,641 2,642,582 1,195,402 18,690 45.94%Contractual Services 0 538,201 27,500 0 5.11%Capital 91,641 1,052,003 115,524 18,690 12.76%Transfers Out 0 1,052,378 1,052,378 0 100.00%

126 Transit Sales Tax Contingency 0 498,395 0 0 0.00%Contingency and Other 0 498,395 0 0 0.00%

127 Judicial Technology Sales Tax 274,982 4,336,405 887,627 1,838,651 62.87%Personnel Services- Salaries & Wages 25,775 336,818 90,166 0 26.77%Personnel Services- Employee Benefits 8,571 110,241 27,883 0 25.29%Contractual Services 41,406 849,406 112,663 109,648 26.17%Commodities 420 11,680 522 0 4.47%Capital 198,811 3,028,260 656,394 1,729,003 78.77%

500 Capital Projects 99,423 3,923,704 124,612 626,853 19.15%Contractual Services 4,275 100,000 4,275 0 4.28%Capital 95,148 3,823,704 120,337 626,853 19.54%

652 Health Insurance Fund 1,531,098 17,852,471 5,112,080 0 28.64%Contractual Services 1,531,098 17,852,471 5,112,080 0 28.64%

900 Contingency 0 1,192,385 0 0 0.00%001 General Fund 0 1,177,385 0 0 0.00%

Contingency and Other 0 1,177,385 0 0 0.00%

660 Working Cash 0 15,000 0 0 0.00%Contingency and Other 0 15,000 0 0 0.00%

Grand Total 12,388,974 232,845,990 59,172,451 26,046,057 36.60%

Packet Pg. 31

Vendor Invoice No. Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice AmountFund 001 - General Fund

Department 040 - FinanceSub-Department 040 - Finance

Account 50130 - Certified Audit Contract9795 - Baker Tilly Virchow Krause, LLP BT917781 Outside Audit Services

Project 841779Paid by EFT # 32827

01/28/2016 02/09/2016 02/09/2016 02/22/2016 19,000.00

Account 50130 - Certified Audit Contract Totals Invoice Transactions 1 $19,000.00Account 52140 - Repairs and Maint- Copiers

4371 - Toshiba Business Solutions, Inc. 12535270 11.02.15-02.01.16 Copier Charges 871956-304

Paid by Check # 349932

02/01/2016 02/09/2016 02/09/2016 02/22/2016 196.03

Account 52140 - Repairs and Maint- Copiers Totals Invoice Transactions 1 $196.03Account 53130 - General Association Dues

1009 - Government Finance Officers Assn (GFOA)

0153003 2016 Membership Renewal 03.01.16-02.28.17


01/07/2016 01/28/2016 01/28/2016 02/08/2016 1,305.00

Account 53130 - General Association Dues Totals Invoice Transactions 1 $1,305.00Account 60000 - Office Supplies

1024 - Ready Refresh by Nestle (Ice Mountain)

16A8106207791 Finance Water January Paid by EFT # 32967

02/03/2016 02/09/2016 02/09/2016 02/22/2016 3.96

Account 60000 - Office Supplies Totals Invoice Transactions 1 $3.96Account 60020 - Computer Related Supplies

5459 - Moore Wallace - An RR Donnelley Co.

544927141 FY15 Tax Forms Finance & HR


01/18/2016 01/28/2016 01/28/2016 02/08/2016 1,133.33

Account 60020 - Computer Related Supplies Totals Invoice Transactions 1 $1,133.33Sub-Department 040 - Finance Totals Invoice Transactions 5 $21,638.32

Department 040 - Finance Totals Invoice Transactions 5 $21,638.32Department 140 - County Auditor

Sub-Department 140 - County AuditorAccount 50150 - Contractual/Consulting Services

10059 - OpenGov, Inc. 1937 OpenGov Web App 1/26/16 -1/25/17


01/31/2016 02/08/2016 02/08/2016 02/22/2016 12,500.00

Account 50150 - Contractual/Consulting Services Totals Invoice Transactions 1 $12,500.00Account 52140 - Repairs and Maint- Copiers

4371 - Toshiba Business Solutions, Inc. 12489725 Maintenance Invoice 11/18 - 12/17/2015


01/14/2016 01/28/2016 01/28/2016 02/08/2016 17.53

4371 - Toshiba Business Solutions, Inc. 12490399 Maintenance Invoice 12/18 - 1/17/2016


01/14/2016 01/28/2016 01/28/2016 02/08/2016 11.33

Account 52140 - Repairs and Maint- Copiers Totals Invoice Transactions 2 $28.86Account 53100 - Conferences and Meetings

4185 - Metro West Council of Government (COG)

Terry Hunt 206 Legislative Dinner Paid by EFT # 32715

01/21/2016 02/03/2016 02/03/2016 02/08/2016 45.00

Account 53100 - Conferences and Meetings Totals Invoice Transactions 1 $45.00

Run by Finance Reports on 03/03/2016 10:58:06 AM Page 1 of 2

Finance Accounts Payable by GL DistributionPayment Date Range 02/01/16 - 02/29/16

Packet Pg. 32

Vendor Invoice No. Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice AmountFund 001 - General Fund

Department 140 - County AuditorSub-Department 140 - County Auditor

Account 60000 - Office Supplies1024 - Ready Refresh by Nestle (Ice Mountain)

16A8104122430 Drinking Water Paid by EFT # 32967

02/03/2016 02/08/2016 02/08/2016 02/22/2016 1.98

3578 - Warehouse Direct Office Products 2968383-0 Office Supplies Paid by EFT # 33016

02/05/2016 02/08/2016 02/08/2016 02/22/2016 22.03

Account 60000 - Office Supplies Totals Invoice Transactions 2 $24.01Sub-Department 140 - County Auditor Totals Invoice Transactions 6 $12,597.87

Department 140 - County Auditor Totals Invoice Transactions 6 $12,597.87Fund 001 - General Fund Totals Invoice Transactions 11 $34,236.19

Grand Totals Invoice Transactions 11 $34,236.19

Run by Finance Reports on 03/03/2016 10:58:06 AM Page 2 of 2

Finance Accounts Payable by GL DistributionPayment Date Range 02/01/16 - 02/29/16

Packet Pg. 33

Kane County Purchasing Card Information

Finance & Budget Committee

February 2016 Statement

Transaction Date Merchant Name Additional Information Transaction Amount

Department Total

Committee Total

Page 1 of 13/7/2016 Packet Pg. 34

% Change % Change % Change % Change % Change 2011 2012 2011 - 2012 2013 2012 - 2013 2014 2013-2014 2015 2014-2015 2016 2015-2016

December February 1,102,413 1,130,410 2.54% 1,180,263 4.41% 1,173,522 -0.57% 1,274,606 8.61% 1,256,577 -1.41%January March 1,296,226 1,352,657 4.35% 1,337,410 -1.13% 1,342,430 0.38% 1,488,784 10.90% 1,451,859 -2.48%February April 882,932 909,267 2.98% 950,903 4.58% 950,674 -0.02% 1,006,954 5.92% -100.00%March May 871,825 958,681 9.96% 940,338 -1.91% 914,908 -2.70% 967,857 5.79% -100.00%April June 1,062,170 1,150,398 8.31% 1,117,808 -2.83% 1,197,141 7.10% 1,201,155 0.34% -100.00%May July 1,080,810 1,105,568 2.29% 1,152,723 4.27% 1,208,957 4.88% 1,253,480 3.68% -100.00%June August 1,192,032 1,162,022 -2.52% 1,427,157 22.82% 1,388,052 -2.74% 1,392,695 0.33% -100.00%July September 1,249,827 1,260,570 0.86% 1,286,113 2.03% # 1,349,798 4.95% 1,409,824 4.45% -100.00%August October 1,166,142 1,119,549 -4.00% 1,230,419 9.90% 1,343,111 9.16% 1,375,061 2.38% -100.00%September November 1,181,741 1,217,032 2.99% 1,281,943 5.33% 1,326,671 3.49% 1,404,575 5.87% -100.00%October December 1,152,580 1,137,137 -1.34% 1,195,146 5.10% 1,300,252 8.79% 1,337,629 2.87% -100.00%November January 1,102,047 1,160,080 5.27% 1,173,614 1.17% 1,270,844 8.28% 1,313,275 3.34% - -100.00%

TOTAL 13,340,746 13,663,373 2.42% 14,273,837 4.47% 14,766,361 3.45% 15,425,897 4.47% 2,708,436 -82.44%

2016 YTD 2,763,390 2,708,436 -1.99%

SALES TAX ANALYSIS 2011-2016001.000.000.30100

State Collection

Month

County Receipt Month

Packet Pg. 35

Department Revenue GL Revenue Account Name Payer Feb-16 Jan-16 Dec-15 Nov-15 Oct-15 Sep-15 Aug-15July 15 &

Older Total Notes

KDOT XXX.520.000.37XXX Various Reimbursements IDOT & ISTHA $ 251,802 $ 140,446 $ - $ - $ 15,224 $ - $ - $ - $407,472 Per IDOT Vouchers

County Clerk 001.190.000.XXXXX Various Grants State of Illinois $ - $ - $ - $ - $ - $ - $ - $ - $0 Not budgeted in FY15

Public Defender 001.360.000.37050 Public Defender Salary Reimbursement State of Illinois $ 8,324 $ - $ - $ - $ - $ - $ - $ - $8,324 Per reimbursement analysis

Court Services 001.430.000.37080 Probation Salary Reimbursement State of Illinois $ 391,060 $ 393,390 $ 430,586 $ 326,931 $ - $ - $ - $ - 1,541,967$ Per Carron Johnson

Supervisor of Assessments 001.170.000.37020 Supervisor of Assessment

Salary Reimbursement State of Illinois $ 5,068 $ - $ - $ - $ - $ - $ - $ - $5,068 Per reimbursement analysis

Kane Comm 269.425.000.37070 Cell 911 Surcharge Reimbursement State of Illinois $ 43,000 $ 43,000 $ 43,000 $ 43,000 $ 43,000 $ 43,000 $ - $ - $258,000

Exact amount is unknown until reimbursement is received; average is $43,000.

Environmental Management N/A Environmental /

DevelopmentState of Illinois $ - $ - $ - $ - $ - $ - $ - $ - $0 Per Es Mora

Health Department 35X.580.000.3XXXX Various Grants & Reimbursements State of Illinois $ 59,602 $ 20,922 $ 148,066 $ 242,598 $ - $ - $ - $ - $471,189 Per Kinnell Snowden

State's Attorney Office 001.300.000.37030 State's Attorney's Salary

Reimbursement State of Illinois $ 14,890 $ - $ - $ - $ - $ - $ - $ - $14,890 Per Eloise Fara

State's Attorney Office 220.300.000.32020 Title IV-D Grant State of Illinois $ 436,968 $ - $ - $ - $ - $ - $ - $ - $436,968 Per Eloise Fara

State's Attorney Office 220.300.000.32050 Atty General Victim Coord

GrantState of Illinois $ - $ - $ - $ - $ - $ - $ - $ - $0 Per Eloise Fara

State's Attorney Office 230.300.000.32000 Attorney General CAC Grant State of Illinois $ - $ - $ - $ - $ - $ - $ - $ - $0 Per Eloise Fara

Kane County 001.000.000.30110 Income Tax State of Illinois $ 650,471 $ - $ - $ - $ - $ - $ - $ - $650,471 Per Tax Analysis WS

Kane County 001.000.000.30120 Local Use Tax State of Illinois $ - $ - $ - $ - $ - $ - $ - $ - $0 Per Tax Analysis WS

TOTAL $1,861,185 $597,758 $621,652 $612,529 $58,224 $43,000 $0 $0 $3,794,349

STATE REIMBURSEMENTS RECEIVABLETotal by Department as of February 29, 2016

Packet Pg. 36

of 1

Kane County Beginning Bal Beginning Bal Beginning Bal Beginning Bal Beginning Bal Beginning Bal

FY 16 Supplemental Budget Request - Source Fund Analysis as of 12/01/2015 as of 12/01/2015 as of 12/01/2015 as of 12/01/2015 as of 12/01/2015 as of 12/01/2015

For March 30th, 2016 Finance/Budget Committee Meeting Net Budgeted Net Budgeted Net Budgeted Net Budgeted Net Budgeted

Expenditures Expenditures Expenditures Expenditures Expenditures

Department Description Reason Res. #

Contingency Allowance for Budget

Expense 001.900.900.85000

Capital Reserve Fund 500

Public Safety Sales Tax Fund 125

Transit Sales Tax Contingency Fund

126

Judicial Public Safety Sales Tax

Fund 127

Enterprise Surcharge Fund

650

Beginning Balance 1,002,385 3,104,585.00 332,129 443,154 1,403,313 6,154,402

Requests Approved as of March 8th, 2016 County Board Meeting

Judicial TechnologyItems budgeted but not spent in FY15 & additional project scope

FY15 Rollover & Increased project scope not budgeted 16-11 (1,348,260)

IT Cityview Project Rollover FY15-FY16Rollover of unspent budget from FY15 to FY16 16-46 (101,859)

IT Fiber Optics Project Rollover FY15-FY16Rollover of unspent budget from FY15 to FY16 16-47 (172,003)

Building Management Capital- Sidewalk & JJC Tile Project Rollover FY15-FY16Rollover of unspent budget from FY15 to FY16 16-48 (84,000.00)

Environmental Management Recycling Program Rollover FY15-FY16Rollover of unspent budget from FY15 to FY16 16-50 (11,272.00)

Building Management

Capital - Architectural Programming, Energy Efficiency & Govt Ctr Carpet Replacement projects not completed in FY15

Rollover of unspent budget from FY15 to FY16 16-68 (475,000)

Balance as of March 8th, 2016 County Board Meeting 1,002,385 2,443,726.00 160,126 443,154 55,053 6,143,130

Currently Being Considered

Building Management Capital - Amending the FY16 3rd Street Parapet Project Project increase after bids -266,534.00

Balance After All Anticipated Budget Adjustments for Fiscal Year 2016 1,002,385 2,177,192 160,126 443,154 55,053 6,143,130

Total Budget Adjustments Funded by Contingency & Special Reserve during FY 2016 -

Packet Pg. 37

Project Name Adopted Budget

Project Adjustment

Adjusted Project

Expensed Remaining

Budget Government Center Security Upgrades - Swipe Card Access $ 65,000 $ - 65,000$ -$ 65,000$ County Jail/Sheriff Office HVAC Controls Upgrade $ 281,500 $ - 281,500$ 48,404$ 233,097$ One Person Man Lifts for County Jail $ 32,000 $ - 32,000$ -$ 32,000$ JC Elevator Upgrades To Infrastructure $ 400,000 $ - 400,000$ 58$ 399,942$ 3rd Street Courthouse - Brick Parapet Repairs $ 400,000 $ - 400,000$ 3,119$ 396,881$ Architectural Programming and Engineering $ 200,000 $ 150,000 350,000$ 23,703$ 326,298$ Energy Efficiency Program $ 100,000 $ 300,000 400,000$ 4,275$ 395,725$ Government Center Demolition of Maintenance Storage Facility $ 45,000 $ - 45,000$ -$ 45,000$ All Campus Sidewalk Repairs $ 24,000 $ 24,000 48,000$ -$ 48,000$ JC Judiciary Carpet and Furniture Replacement $ 100,000 $ - 100,000$ -$ 100,000$ JJC Floor Tile Replacement $ 25,000 $ 60,000 85,000$ -$ 85,000$ 3rd Street Courthouse - JC Carpet Replacement $ 150,000 $ - 150,000$ -$ 150,000$ Government Center Carpet Replacement $ 60,000 $ 25,000 85,000$ -$ 85,000$ Randall Road CIC Facility Roof Replacement Phase 1 $ 800,000 $ - 800,000$ 58$ 799,942$ Contingency $ 300,000 $ - 300,000$ 26,109$ 273,891$

Digital Surveillance Cameras for Corrections (Xray Machines) $ 100,000 $ - 100,000$ -$ 100,000$ Development Vehicle Replacement $ 27,000 $ - 27,000$ -$ 27,000$ IT Vehicle Replacement $ 30,000 $ - 30,000$ -$ 30,000$

IT PC/Monitor/Server/Driver/UPS & Battery Replacement Program $ 338,345 $ - 338,345$ 38,530$ 299,815$ IT Enterprise Document Management Software $ 30,000 $ 101,859 131,859$ -$ 131,859$ IT Time & Attendance Software $ 30,000 $ - 30,000$ -$ 30,000$ IT NWS Module Implementation & Upgrades $ 20,000 $ - 20,000$ -$ 20,000$ IT Printer Replacement Program $ 30,000 $ - 30,000$ -$ 30,000$ IT Firewall Upgrades, Network Switches & Routers $ 100,000 $ - 100,000$ 21,777$ 78,223$ IT Copier Replacement Program $ 50,000 $ - 50,000$ 4,547$ 45,453$ Total 2016 Capital Projects Fund $3,737,845 $ 660,859 $ 4,398,704 170,580$ 4,228,124$

2016 Capital Projects Fund - Project Summaryas of 03.24.2016

Packet Pg. 38

PROPOSED FY2017 BUDGET CALENDAR

March – April Finance Department reviews budget process, refines budget requirements, determines

budget calendar, and prepares preliminary budget guidelines. March 30 Finance Committee approves Budget Calendar to be distributed. April 15 FY17 General Fund preliminary revenue estimates are due in Finance Department. April 29 Finance Committee approves Preliminary Budget Guidelines to be distributed. May 2 – May 6 Finance Department completes & distributes required budget forms and instructions and

initializes budget in New World System. May 9 – June 15 Departments and offices enter estimated revenues and proposed expenditures into the

New World system, providing itemized detail and justification for each line item. Departments complete required forms.

May 13 New World budget training sessions are provided. June 15 ALL BUDGETS MUST BE ENTERED INTO NEW WORLD SYSTEM. ALL FORMS

ARE DUE IN THE FINANCE DEPARTMENT (except Departmental Mission & Goals and Mandate forms).

June 15 – July 12 Finance works with departments to ensure their budget data is complete and that their

budget reports are ready for committee budget presentations. June 28 – July 15 Finance Advisory Group reviews department budget requests and makes

recommendations. July 6 Departmental Mission & Goals and Mandate forms due in Finance Department. July 15 Mid-Year Projections are due in Finance Department. July 13-28 Departments present preliminary budgets to their respective committees for initial

consideration and recommendations. July 26 Preliminary Capital Budget is presented to Committee of the Whole. July 27 Preliminary County budget presented to Finance Committee for initial consideration and

recommendations. August 1-16 Finance Advisory Group meets with selected departments & offices to review budget

requests in more detail and makes recommendations as needed. August 10-25 Departments present their revised budgets to their respective committees for final

recommendations. August 30 Update on County budget presented to Committee of the Whole. August 31 Revised County budget presented to Finance Committee. Finance Committee establishes

guidelines for finalizing budget. September 27 Final draft of County budget presented to Committee of the Whole. September 28 Final draft of County budget presented to Finance Committee for approval. October 11 County Board approves budget to be placed on public display. October 21 Final draft of budget must be placed on public display per statutory requirements. November 8 Truth-in-Taxation Hearing held if needed. County Board approves County budget.

Packet Pg. 39

Status of State Delinquencies The following is the list of revenue streams that have been impacted by the State of Illinois budget impasse along with their outstanding receivable balances as of 2/29/2016:

Description Annual Budget

Current Outstanding

Last Payment Received

Last Period for Which We

Rcvd Payment

State’s Attorney’s Title IV Grant (The state normally reimburses the County on a monthly basis based on the actual expense incurred. The last payment was received in August 2015 for expenses incurred in June 2015. No payment has been received to reimburses expenses incurred since July 1, 2015.)

700,000 436,968 Aug 2015 June 2015

Kane County Health Department Local Health Protection Grant (The state normally makes one payment each year. The last payment was received in December 2014 to cover the period July 1, 2014 through June 30, 2015. No payment has been received yet to cover the period July 1, 2015 through June 30, 2016.)

348,470 $179,034 Dec 2014 July 1, 2014 thru June 30,

2015

County Engineer Salary Reimbursement (The state normally makes one payment each year. The last payment received was in October 2014 for Fiscal Year 2014. No payment has been received yet for Fiscal Year 2015.)

69,160 69,160 Oct 2014 Fiscal Year 2014

Total 1,117,630 685,162

Packet Pg. 40

RESOLUTION/ORDINANCE EXECUTIVE SUMMARY

Resolution No.

Authorizing Ongoing Transfer of Funds for Outside Agency Services and Support

Committee Flow: Administration Committee, Finance and Budget Committee, Executive Committee, County Board Contact: Bill Lake, 630.232.5976

Budget Information:

Was this item budgeted? No Appropriation Amount: $46,000

If not budgeted, explain funding source: Miscellaneous Other

Summary:

The County Information Technologies Department is responsible to maintain and

support County computers.

The purchase and lease of New World public safety software for the County has given

agencies the ability to share public safety data. As a result, it has become necessary for outside

agencies (policing and fire) to configure various computer devices that enable access to the

records management and computer aided dispatch.

The Information Technologies Department has neither been funded nor given the

responsibility to work on outside agency computers. The outside agencies shall be charged a

mutually agreed upon fee for a scope of work (setup, troubleshooting and maintenance) when

requesting the County to assist. These funds will be used to compensate County employees for

each unit of support performed outside of their normal required duties.

To accomplish this, we are asking that information Technologies Department be

permitted to invoice the agencies for the agreed upon scope of work, receive the funds into a

miscellaneous revenue account, transfer the funds into salary and compensate our employees

according to the units of support invoiced.

Packet Pg. 41

STATE OF ILLINOIS

COUNTY OF KANE

RESOLUTION NO.

AUTHORIZING ONGOING TRANSFER OF FUNDS FOR OUTSIDE AGENCY SERVICES AND SUPPORT

WHEREAS, the Kane County Information Technologies Department receives requests from agencies requiring special assistance; and

WHEREAS, the Information Technologies Department is the only department having access to applications required to perform special assistance for Illinois law enforcement agencies, fire departments, park and forest preserve; and

WHEREAS, the assistance requested by these agencies is outside of the Information Technologies employees required duties and responsibilities.

NOW, THEREFORE, BE IT RESOLVED by the Kane County Board that the Information Technologies Department employees receive appropriate compensation for units of work performed with a transfer of funds received from outside agencies and that the FY2016 budget adjustment be made to reflect this transfer.

001.060.000.38900 Miscellaneous Other $46,000

001.060.060.40000 Salaries and Wages $37,876

001.800.808.99000 Transfer to Other Funds $ 8,124

110.800.000.39000 Transfer From Other Funds $ 4,605

110.800.802.45200 IMRF $ 4,605

111.800.000.39000 Transfer From Other Funds $ 3,519

111.800.803.45100 FICA/SS $ 3,519

Line Item Line Item Description Was Personnel/Item/Service approved

in original budget or a subsequent

budget revision?

Are funds currently available for this

Personnel/Item/Service in the specific

line item?

If funds are not currently available

in the specified line item, where

are the funds available?

001.060.060.40000

001.800.808.99000

Salaries and Wages

Transfer to other funds

no no 001.060.000.38900 Miscellaneous

Other

Passed by the Kane County Board on April 12, 2016.

________________________________ _____________________________ John A. Cunningham Christopher J. Lauzen Clerk, County Board Chairman, County Board Kane County, Illinois Kane County, Illinois

Vote:

16-04 Outside Agency Support

Packet Pg. 42


Resolution No.

Amending the 2016 Fiscal Year Capital Improvement Budget - 3rd Street Courthouse Parapet Restoration Project

Committee Flow: Finance and Budget Committee, Executive Committee, County Board Contact: Don Biggs, 630.208.5175

Budget Information:

Was this item budgeted? No Appropriation Amount:$266,534

If not budgeted, explain funding source: Cash on Hand - Capital Improvements

Summary:

Bids have been solicited for the 3rd Street Courthouse Parapet Restoration Project at the 3rd

Street Courthouse Facility, 100 S. 3rd. Geneva, IL. 60134. A total of eight (8) bids were

received and publicly opened on February 25, 2016.

The lowest responsive and responsible bidder for the Base bid is Otto Baum Company Inc. of

Morton, IL 61550, for a total Base bid of $555,445. This project will also include a 20%

Contingency valued at $111,089, for a total project cost of $666,534.

The 20% contingency for this project is due to the inherent challenges that this restoration project poses relative to the potential for managing unforeseen conditions that are possible when dealing with a 115 year-old building. The original Board approved budget for this project was $400,000. This was an estimated

budget that was established last year before testing of the structure was completed. Upon

testing results, the scope of work increased to include flexible flashing through the entire flat

surface of all the parapet walls. In addition, there are only two (2) manufactures of the Terra

Cotta copings within the United States, which may have contributed into the additional costs for

this project.

Implementation of this project will require a budget adjustment to the FY2016 Capital Improvement Budget in the amount of $266,534.

Packet Pg. 43

STATE OF ILLINOIS

COUNTY OF KANE

RESOLUTION NO.

AMENDING THE 2016 FISCAL YEAR CAPITAL IMPROVEMENT BUDGET - 3RD STREET COURTHOUSE PARAPET RESTORATION PROJECT

WHEREAS, bids have been solicited for the 3rd Street Courthouse Parapet Restoration Project at the 3rd Street Courthouse Facility, 100 S. 3rd Geneva, IL 60134; and

WHEREAS, implementation of this project will require a budget adjustment to the

FY2016 Capital Improvement Budget in the amount of $266,534; NOW, THEREFORE, BE IT RESOLVED by the Kane County Board that the following

FY2016 budget adjustment for Two hundred Sixty-Six thousand, Five Hundred Thirty-Four Dollars ($266,534) be granted for the FY2016 Capital Budget / 3rd Street Courthouse Parapet Restoration Project.

500.800.805.72010 Building Improvements + $266,534 500.800.000.39900 Cash on Hand + $266,534

Line Item

Line Item Description Was Personnel/Item/Service approved


budget revision?



line item?




500.800.805.72010 Building Improvements No Yes 500.800.000.39900



Vote:

16-04 Amend the 2016 Fiscal Year Budget-3rd St. Parapet Project

Packet Pg. 44


Resolution No.

Authorizing Contract for the 3rd Street Courthouse Parapet Restoration Project

Committee Flow: Finance and Budget Committee, Contact: Don Biggs, 630.208.5175

Budget Information:

Was this item budgeted? Yes Appropriation Amount: $400,000

If not budgeted, explain funding source: Additional Cash on Hand-Capital Improvements $266,534

Summary:

Bids have been solicited for the 3rd Street Courthouse Parapet Restoration Project at the 3rd Street Courthouse Facility, 100 S. 3rd. Geneva, IL. 60134. A total of eight (8) bids were received and publicly opened on February 25, 2016. The lowest responsive and responsible bidder for the Base bid is Otto Baum Company Inc. of Morton, IL 61550, for a total Base bid of $555,445. Alternate #1 is for additional Site Mobilization, if required. The total cost of Alternate #1 is $2,500. This Alternate will not be approved as part of the project. However, if additional mobilizations are required during the project, it will be funded through contingency dollars for the project. This project will also include a 20% Contingency valued at $111,089, for a total project cost of $666,534. The 20% contingency for this project is due to the inherent challenges that this restoration project poses relative to the potential for managing unforeseen conditions that are possible when dealing with a 115 year-old building. The Contingency amount will be held by Kane County and is not part of the contract. The original Board approved budget for this project was $400,000. This was an estimated budget that was established last year before testing of the structure was completed. Upon testing results, the scope of work increased to include flexible flashing through the entire flat surface of all the parapet walls. In addition, there are only two (2) manufactures of the Terra Cotta copings within the United States, which may have contributed into the additional costs for this project.

Packet Pg. 45

STATE OF ILLINOIS

COUNTY OF KANE

RESOLUTION NO.

AUTHORIZING CONTRACT FOR THE 3RD STREET COURTHOUSE PARAPET RESTORATION PROJECT

WHEREAS, bids have been solicited for the 3rd Street Courthouse Parapet Restoration Project at the 3rd Street Courthouse Facility, 100 S. 3rd Geneva, IL 60134; and

WHEREAS, the lowest responsive and responsible bidder, as per bid documents and

specifications, is Otto Baum Company Inc. of Morton, IL. 61550, for a total Base bid of $555,445; and

WHEREAS, the total project cost will also include a 20% Contingency valued at

$111,089.00, for a total project cost of $666,534.

NOW, THEREFORE, BE IT RESOLVED by the Kane County Board, that the Chairman is hereby authorized to execute a contract for the 3rd Street Courthouse Parapet Restoration Project to Otto Baum Company Inc. of Morton, IL, for the base bid amount of Five Hundred Fifty-Five Thousand, Four Hundred Forty-Five Dollars ($555,445). In addition, a twenty percent (20%) project contingency of One Hundred-Eleven Thousand, Eighty-Nine Dollars ($111,089), for a total project cost of Six Hundred Sixty-Six Thousand, Five Hundred Thirty-Four Dollars ($666,534).

Line Item



budget revision?



line item?




500-800-805-72010

500.800.000.39900

Building Improvements

Cash on Hand

Partial

No

Yes

Yes

500.800.000.39900



Vote:

3rd St. Parapet Project

Packet Pg. 46

March 9, 2016 Mr. Don Biggs Executive Director of Building Management 719 Batavia Avenue Geneva, IL 60134 Re: Kane County 3rd Street Courthouse Parapet Restoration Project Bidder Recommendation Dear Don: The Third Street Courthouse Parapet Restoration project was put out to Bid on February 9, 2016. Over ten contractors were notified of the project and eight of them obtained bidding documents. There was a walk-through scheduled to allow prospective bidders access to the site. At the bid opening date of February 29, 2016 we received five bids which were opened publicly for the aforementioned project. The attached Bid Tabulation document illustrates the recorded bids and the plan holders. The lowest responsive and responsible bidder for the project was Otto Baum Company, Inc. for a total bid of $555,445.00. There was one alternate that was bid to provide an additional mobilization. After discussion with the Owner the team felt that the inclusion of this alternate was not recommended. The project is based on allowance and unit prices as included in the base bid price and is captured on the Bid Form for each work area so that the project cost can be monitored on a unit cost basis. All allowances shall be managed by the Owner and construction manager. We proceeded to do a project scope review with Otto Baum Company on 3/9/16 and learned at this meeting that a terra cotta plant has the potential to produce the terra cotta parapet caps in 2016 so t the project could possibly be completed this year. Thus, we respectfully request that the project be approved at the April County Board Meeting. We also reviewed the contractual requirements and bid documents with Otto Baum at this meeting to ensure that they fully understood the project and the contract requirements. They acknowledged full understanding and acceptance of the terms and conditions. We also reviewed their qualification statement and references and are satisfied that they meet our recommended standards. As such, it is our recommendation that Otto Baum Company, Inc. be awarded the Contract for the bid total of $555,445.00 in accordance with the bidding documents for the aforementioned project. We also recommend that the project include a contingency on 20% or $111,089.00 for this project due to the inherent challenges that this restoration project has relative to the potential for managing unforeseen conditions that are possible when dealing with a 115 year-old building. Thus the total recommended budget for the project is $666,534.00 Thank you for this opportunity to serve Kane County on this critical project that will benefit all of tax payers of the County. Should you require any additional information or clarifications, please do not hesitate to contact me. Respectfully submitted, Cordogan Clark & Associates

Brian Kronewitter, AIA, DBIA Executive Vice President

Packet Pg. 47

KANE COUNTY

Bid Tabulations

February 29, 2016

Bidder's Name AddressBid

Bond

Signed

BFAddendum Base Bid Alternate 1

Total Base Bid +

Accepted Alts.

Restoration Prime Contractor

Berglund Construction Company8410 S. South Chicago Avenue

Chicago, IL 60617X X 1, 2, 3 $965,000.00 $50,000.00 $1,015,000.00

Grove Masonry Maintenance Inc.4234 W. 124th Place

Alsip, IL 60803X X 1, 2, 3 $849,000.00 $70,000.00 $919,000.00

Bi-State Masonry3511 8th Street

Rock Island, IL 61201

Otto Baum Company Inc.866 N. Main Street

Morton, IL 61550X X 1, 2, 3 $555,445.00 $2,500.00 $555,445.00

Mertes Contracting Corporation2665 S 25th Avenue

Broadview, IL 60155

April Building Services Inc.22W274 Irving Park Road

Roselle, IL 60172

Golf Construction120 W. Madison Street, Ste 505

Chicago, IL 60602X X 1, 2, 3 $1,379,550.00 N/A $1,379,550.00

Western Specialty2658 West Van Buren St

Chicago, IL 60612X X 1, 2, 3 $984,025.00 N/A $984,025.00

$0.00

$0.00

$0.00

$0.00

$0.00

$555,445.00

20% $111,089.00

$666,534.00

Third Street Courthouse Parapet Restoration Project

Total Apparent Lowest Responsive & Responsible Bidder:

NO BID

NO BID

NO BID

Recommended Project Budget:

Contingency:

Packet Pg. 48


Resolution No.

Authorizing Retention of Cordogan Clark & Associates

Committee Flow: Administration Committee, Finance and Budget Committee, Executive Committee, County Board Contact: Don Biggs, 630.208.5175

Budget Information:

Was this item budgeted? Yes Appropriation Amount: $ 350,000

If not budgeted, explain funding source:

Summary:

The County Board approved utilizing Cordogan Clark & Associates at the February 10, 2015,

Board meeting to perform professional architectural, construction management and engineering

services required to complete future capital projects for the County on an as needed basis per

project.

This will be a two (2) year contract for FY2016 and FY2017. Cordogan Clark has agreed to hold the 2015 rates for services for FY2016 and FY2017.

Packet Pg. 49

STATE OF ILLINOIS

COUNTY OF KANE

RESOLUTION NO.

AUTHORIZING RETENTION OF CORDOGAN CLARK & ASSOCIATES

WHEREAS, the County of Kane is engaged in long range planning in the construction, demolition, and usage of government assets; and

WHEREAS, the County Board received a 5-Year Capital Project Update in December 2015;

and WHEREAS, it is in the best interests of the County of Kane to engage professional

architectural, construction management and engineering services to facilitate the completion of

those planned capital projects; and

WHEREAS, the County of Kane has a an excellent relationship for professional

architectural, construction management and engineering services with Cordogan Clark &

Associates; and

WHEREAS, the County Board approved utilizing Cordogan Clark & Associates at the

February 10, 2015, Board meeting for capital projects for the County.

NOW, THEREFORE, BE IT RESOLVED by the Kane County Board that it hereby approves

retaining Cordogan Clark & Associates to perform professional architectural, construction

management and engineering services required to complete future capital projects for the FY2016

and FY2017 on an as needed basis per project.

BE IT FURTHER RESOLVED, by the Kane County Board, that the Chairman of the Kane County Board is hereby authorized and delegated the authority to execute all documents necessary to retain Cordogan Clark & Associates to perform those professional services recited above on an as needed basis per project.



Vote:

16-04 Contract-Cordogan Clark

Packet Pg. 50

January 26, 2016 Mr. Don Biggs Operations Staff Executive 719 Batavia Avenue Geneva, IL 60134 Re: Kane County Task Order Proposal (2 Year Renewal) Dear Don: Cordogan Clark has been providing continuous professional services to Kane County as a result of a QBS selection process undertaken by Kane County in 2013 and through successful execution of previous work, has been asked to continue to provide professional services for future upcoming work with the County. We again thank you for choosing Cordogan Clark (CCA) as your partner to provide architectural, engineering and construction professional services for Kane County on your capital improvement and maintenance projects. We are very excited to have the chance to continue to work with you and your team at Kane County. CCA will provide professional advice, program management, design, programming, building assessment, engineering, procurement and construction services as required to assist Kane County in their implementation of various capital improvements, maintenance and deferred maintenance projects. Our services will be performed on a time and material basis in accordance with the attached Hourly Billing Rate Schedule or in accordance with the attached Fee Schedule. This approved work shall abide by the approved rates and fees established in this document through January 2018. We will identify the projects separately and track our time and expenses accordingly or agree to a fixed fee on a specific project basis and bill accordingly. Thank you for this opportunity to serve Kane County on this critical project that will benefit all of tax payers of the County. Should you require any additional information or clarifications, please do not hesitate to contact me. Respectfully submitted, Cordogan Clark & Associates


Packet Pg. 51

CCA AEC Cost of Services Proposal Kane County Task Order Work Proposal 1/26/2016 Page 2 of 2

Upon approval of this agreement please forward a copy of the signed proposal letter back to our office.

Cordogan Clark & Associates, Inc. Kane County

BY:_______________________________ BY:____________________________

Its representative Its representative

DATE:____________________________ DATE:___________________________

CC: Michael Konopka; Dawn Barry

Packet Pg. 52

EXHIBIT A

Position RateArchitecturalPrincipal $225.00Executive Vice President $200.00Vice President $180.00Associate $150.00Project Manager $130.00Interior Designer $115.00Architect $110.00Architect II $100.00Architect I $85.00Tech I $75.00

EngineeringElectrical Engineer $135.00Electrical Designer $120.00Electrical Tech $100.00Mechanical Engineer $135.00Mechanical Designer $120.00Mechanical Tech $95.00

Structural EngineeringPrincipal Structural $155.00Senior Structural $135.00Structural Engineer I $100.00Structural Technician $95.00Clerical $70.00

Construction ManagementPrincipal $225.00Project Executive $200.00Vice President $190.00Senior Project Manager $165.00Project Manager $125.00Project Engineer $85.00Senior Estimator $100.00Estimator $90.00Preconstruction Manager $110.00Senior Superintendent $175.00Superintendent $125.00MEP Superintendent $110.00Assistant Superintendent $90.00MEP Engineer $90.00Safety Director $110.00Safety Engineer $90.00Project Accountant $70.00Administrative Assistant $55.00

2016 Hourly Rate Schedule

For additional services, which would fall beyond the scope of the Standard Agreement between Owner Contract we would charge a flat hourly rate for any such services if deemed necessary. Hourly rates shall be

adjusted annually. Hourly Rate Schedule for additional work if requested by the Owner is as follows:

Packet Pg. 53

Kane County Task Work Fee Schedule

Project Value Hourly AE Fee % CM Fee %General

Conditions< $100,000 X 15.00% 10.00% Cost of the work$100,000 to $200,000 X 14.00% 9.75% Cost of the work$200,000 to $300,000 X 13.00% 9.50% Cost of the work$300,000 to $400,000 X 12.50% 9.50% Cost of the work$400,000 to $500,000 X 12.00% 9.25% Cost of the work$500,000 to $600,000 X 11.50% 9.00% Cost of the work$600,000 to $700,000 X 11.00% 8.75% Cost of the work$700,000 to $800,000 X 10.50% 8.50% Cost of the work$800,000 to $900,000 X 10.25% 8.25% Cost of the work$900,000 to $1,000,000 X 10.00% 8.00% Cost of the work$1,000,000 to $1,500,000 9.75% 8.00% Cost of the work$1,500,000 to $2,000,00 9.50% 7.50% Cost of the work$2,000,000 to $2,500,000 9.50% 7.00% Cost of the work$2,500,000 to $3,000,000 9.25% 6.75% Cost of the work$3,000,000 to $4,000,000 9.00% 6.50% Cost of the work$4,000,000 to $5,000,000 8.75% 6.25% Cost of the work

January 25, 2016

Packet Pg. 54


Resolution No.

Approving Office Supplies Contract

Committee Flow: Finance and Budget Committee, Executive Committee, County Board Contact: Maria Calamia, 630.444.3186

Budget Information:

Was this item budgeted? Yes Appropriation Amount:


Summary:

This resolution approves the contract extension for office supplies for the County for 2016. The County has spent approximately $87,303 with its current vendor, Warehouse Direct, on office supplies in 2015. The County Board approved the original contract on February 11, 2014, per Resolution 14-32 and option year one on February 10, 2015, per Resolution 15-23. This extension is for the period March 4, 2016 through March 3, 2017, with no cost increase, which was negotiated by Purchasing staff. Staff is recommending a one (1) year contract extension with the current office supply vendor, Warehouse Direct, with no cost increase, for the 2016 award.

Packet Pg. 55

STATE OF ILLINOIS

COUNTY OF KANE

RESOLUTION NO.

APPROVING OFFICE SUPPLIES CONTRACT

WHEREAS, the office supply contract, approved by Resolution 14-32, Warehouse Direct Office Products for supplying the County's Office Supplies and offering a 55% discount on catalog items for fiscal year 2016; and

WHEREAS, the existing contract can be extended for one final option year. The vendor

has provided the highest quality and lowest cost office supplies to meet the County's requirements, and staff recommends the contract be extended for the final option year; and

NOW, THEREFORE, BE IT RESOLVED by the Kane County Board that the current vendor

for office supplies, Warehouse Direct Office Products of Des Plaines, Illinois be accepted and approved for a final one year contract extension, at no cost increase. Funding shall be paid from the Office Supplies fund for various departments.



Vote:

Approving Office Supplies Contract

Packet Pg. 56

County of Kane PURCHASING DEPARTMENT

KANE COUNTY GOVERNMENT CENTER 719 S. Batavia Avenue, Bldg. A. Telephone: (630) 232-5929 Geneva, Illinois 60134 Fax: (630) 208-5107

February 19, 2016

PROCUREMENT SYNOPSIS

Requesting Department: Finance Department

Procurement Name: 47-013 Office Supplies

Recommended Vendor: Warehouse Direct

NOTIFICATION AND RESPONSE Public Notices: Kane County Web Site and the Chronicle.

Advertising Date: October 10, 2013 Notices sent: 45/20

Bid Due Date: October 30, 2010 Bids Received: 10

PURPOSE

This contract will provide County’s departments and staffs with the highest quality and lowest cost office supplies. This is a one year contract with option to extend for two (2) additional one (1) year renewal periods, if mutually agreed. BID TABULATION

Vendor Location

Catalog Discount

Core Bid Total

Vendor Location

Catalog Discount

Core Bid Total

Garveys Office 40% $41,921.65 Quill 10% $38,696.72

Office Max 68% $38,158.60 Quick Delivery Office 15-85% $25,795.97 (1)

School Specialty No Bid Staples 55% $36,150.92

Document Imaging 10-50% $51,042.47 Warehouse Direct 55% $27,336.85

Runco Office Supply 50% $41,087.05 Office Depot 55% $28.146.76

Staff has determined that Warehouse Direct is the most responsible responsive bidder. They are the current vendor and have been servicing this contract superbly the last seven years. (1) Quick Delivery Office of Kennesaw, GA. submitted 22 non-brand office supply items to the core group of bid items, including markers, highlighters, labels, pens, glues, tapes, and note pads which are substandard in grade and performance when compared to core bid items as specified. The 5% cost difference of approximately $1,500 reflect an inferior office supply items submitted, which are unacceptable. The Purchasing Department recommends the renewal of the County’s office supply contract to Warehouse Direct of Des Plaines, IL pending approval by the Finance Committee. This contract will be from March 4, 2016 through March 3, 2017.

Submitted By:

Maria C. Calamia

Assistant Purchasing Direct

Packet Pg. 57

Packet Pg. 58


Resolution No.

Authorizing Contract for the Judicial Center Elevator Modernization Project


Budget Information:



Summary:

Bids have been solicited for the Kane County Judicial Center Elevator Modernization Project at the Judicial Center Facility, 37W777 Rt. 38, St Charles, IL, 60175. A total of 2 bids were received and publicly opened on February 25, 2016. The lowest responsive and responsible bidder for the project was Urban Elevator Service for a total bid of $346,416.48. There are also two allowances that must be included in the project. An allowance of $20,500 for miscellaneous electrical, fire service and general work required for this project. An additional $20,000 allowance will be included for HVAC work required for the project. All allowances shall be managed by Building Management Services. This project will also include a 10%Contingency valued at $34,641.65 for a total project cost of $421,558.13. The Contingency amount will be held by Kane County and not part of the contract.

Packet Pg. 59

STATE OF ILLINOIS

COUNTY OF KANE

RESOLUTION NO.

AUTHORIZING CONTRACT FOR THE JUDICIAL CENTER ELEVATOR MODERNIZATION PROJECT

WHEREAS, Bids have been solicited for the Judicial Center Elevator Modernization Project at the Judicial Center Facility, 37W777 Rt. 38, St Charles, IL, 60175; and


specifications, was Urban Elevator Service, 4830 W. 16th Street, Cicero, IL 60804, for a total bid of $346,416.48; and

WHEREAS, there are also two allowances for miscellaneous electrical, fire service and

general work required for an allowance of $20,500; and

WHEREAS, an additional $20,000 allowance will be included for HVAC work required for the

project. All allowances shall be managed by Building Management Services; and WHEREAS, the total project cost will also include a 10% Contingency valued at $34,641.65,

an allowance of $40,500, for a total project cost of $421,558.13.

NOW, THEREFORE, BE IT RESOLVED by the Kane County Board that the Chairman is

hereby authorized to execute a contract for the Judicial Center Elevator Modernization Project to Urban Elevator Service of Cicero, IL for the base bid amount of Three Hundred Forty-Six Thousand, Four Hundred Sixteen Dollars and Forty-Eight Cents ($346,416.48). In addition, authorizing the approval of an allowance of Forty Thousand Five Hundred Dollars ($40,500) and a ten percent (10%) project contingency of Thirty-Four Thousand, Six Hundred Forty-One Dollars and Sixty-Five Cents ($34,641.65), for a total project cost of Four Hundred Twenty-One Thousand, Five Hundred Fifty-Eight Dollars and Thirteen Cents ($421,558.13).

Line Item



budget revision?



line item?




500-800-805-72010 Building Improvements Yes Yes



Vote:

16-04 JC Elevator Project

Packet Pg. 60

February 26, 2016 Mr. Don Biggs Executive Director of Building Management 719 Batavia Avenue Geneva, IL 60134 Re: Kane County JC Elevator Modernization Project Bidder Recommendation Dear Don: The Justice Center Elevator Modernization project was put out to Bid on February 9, 2016. Over 6 contractors were notified of the project and 4 of them obtained bidding documents. There was a walk-through scheduled to allow prospective bidders access to the site. At the bid opening date of February 25, 2016 we received 2 bids which were opened publicly for the aforementioned project. The attached Bid Tabulation document illustrates the recorded bid and the plan holders. There were no alternates that were required for the project The lowest responsive and responsible bidder for the project was Urban Elevator Service for a total bid of $346,416.48. There are also two allowances that must be included in the project. An allowance of $20,500.00 for miscellaneous electrical, fire service and general work required for this project and an additional $20,000 allowance shall be included for HVAC work required for the project. All allowances shall be managed by the Owner and construction manager. We proceeded to do a project scope review with Urban Elevator Service after the Bid Opening to ensure that they fully understood the project and the contract requirements. They acknowledged full understanding and acceptance of the terms and conditions. We also reviewed their qualification statement and references and are satisfied that they meet our recommended standards. As such, it is our recommendation that Urban Elevator Service be awarded the Contract for the bid total of $346,416.48 in accordance with the bidding documents for the aforementioned project. Thank you for this opportunity to serve Kane County on this critical project that will benefit all of tax payers of the County. Should you require any additional information or clarifications, please do not hesitate to contact me. Respectfully submitted, Cordogan Clark & Associates


Packet Pg. 61

KANE COUNTY

Bid TabulationsFebruary 25, 2015


BondSigned

BFAddendum Base Bid

Voluntary Alternate

Total Base Bid + Accepted Alts.

Elevator Prime Contractor

Urban Elevator Service4830 W. 16th StreetCicero, IL 60804

X X 1 $346,416.48 $346,416.48

Thyssen Krupp Elevator355 Eisenhower Lane SouthLombard, IL 60148

X X NONE $359,188.00 $359,188.00

$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

$346,416.48

$20,500.00 $20,000.00

Contingency: 10.00% $34,641.65 $421,558.13

Justice Center Elevator Modernization Project


Elevator Contractor Allowances:HVAC Allowance:


Packet Pg. 62


Resolution No.

Authorizing Contract for the KBC Roofing Project


Budget Information:



Summary:

Bids have been solicited for the Kane County Branch Court Roofing Project at the Kane County Branch Court Facility, 530 S. Randall Rd., St. Charles 60174. A total of 10 bids were received and publicly opened on February 25, 2016. The lowest responsive and responsible bidder for the project, including Base bid $365,765, Alternate #1 ($36,500) and Alternate #3 ($97,595) was Malcor Roofing, Montgomery IL, for a total bid of $499,860. Alternate #1 is to install an additional 2” of polyisocyanurate insulation over existing insulation over roof area A. The membrane installation was included in the base bid. Total cost of Alternate #1 is $36,500. Alternate #3 is to install an additional 2” of polyisocyanurate insulation over existing insulation over roof area C and the installation of the new membrane. Total cost of Alternate #3 is $97,595. This project will also include a 15% Contingency valued at $74,979 for a total project cost of $574,839. The Contingency amount will be held by Kane County and not part of the contract.

Packet Pg. 63

STATE OF ILLINOIS

COUNTY OF KANE

RESOLUTION NO.

AUTHORIZING CONTRACT FOR THE KBC ROOFING PROJECT

WHEREAS, bids have been solicited for the Kane County Branch Court Roofing Project at the Kane County Branch Court Facility, 530 S. Randall Rd., St. Charles 60174; and


specifications, including; Base bid ($365,765), Alternate #1 ($36,500) and Alternate #3 ($97,595) was Malcor Roofing, 1793 Commerce Drive, Montgomery, IL 60538, for a total bid of $499,860; and

WHEREAS, the total project cost will also include a 15% Contingency valued at $74,979 for

a total project cost of $574,839.

NOW, THEREFORE, BE IT RESOLVED by the Kane County Board that the Chairman is

hereby authorized to execute a contract for the Kane County Branch Court Roofing Project to Malcor Roofing of Montgomery, IL for the base bid amount of Three Hundred Sixty-Five Thousand, Seven Hundred Sixty-Five Dollars ($365,765). In addition, authorizing the approval of Alternate #1 for Thirty-Six Thousand, Five Hundred Dollars ($36,500), Alternate #3 for Ninety-Seven Thousand, Five Hundred Ninety-Five Dollars ($97,595) and a fifteen percent (15%) project contingency of Seventy-Four Thousand, Nine Hundred Seventy-Nine Dollars ($74,979), for a total project cost of Five Hundred Seventy-Four Thousand, Eight Hundred Thirty-Nine Dollars ($574,839).

Line Item



budget revision?



line item?




500-800-805-72010 Building Improvements Yes Yes



Vote:

16-04 KBC Roofing Project

Packet Pg. 64

February 26, 2016 Mr. Don Biggs Executive Director of Building Management 719 Batavia Avenue Geneva, IL 60134 Re: Kane County KBC Roofing Project Bidder Recommendation Dear Don: The KBC Roofing project was put out to Bid on February 9, 2016. Over 18 contractors were notified of the project and 13 of them obtained bidding documents. There were two walk-throughs scheduled to allow prospective bidders access to the site. At the bid opening date of February 25, 2016 we received 10 bids which were opened publicly for the aforementioned project. The attached Bid Tabulation document illustrates the recorded bid and the plan holders. There were three alternates that were required for the project. After discussion with the County it was desired to include Alternates #1 and #3. The lowest bidder for the base bid plus the preferred alternates was Malcor Roofing of Illinois for a total bid of $365,765 and Alternate #1 for an additional $36,500.00 which will add an additional 2" of insulation to the main roof area plus Alternate #3 for an additional $97,595.00 which adds the section of the roof that includes the roof are that is 16 years old for a total bid amount of $499,860.00. Accepting both of these alternates will replace the entire KBC Building roof and provide added insulation to the entire roof for improved energy efficiency.. We proceeded to do a project scope review with Malcor Roofing after the Bid Opening to ensure that they fully understood the project and the contract requirements. They acknowledged full understanding and acceptance of the terms and conditions. We also reviewed their qualification statement and references and are satisfied that they meet our recommended standards. As such, it is our recommendation that Malcor Roofing of Illinois be awarded the Contract for the bid total of $499,860.00 in accordance with the bidding documents for the aforementioned project. Thank you for this opportunity to serve Kane County on this critical project that will benefit all of tax payers of the County. Should you require any additional information or clarifications, please do not hesitate to contact me. Respectfully submitted, Cordogan Clark & Associates


Packet Pg. 65

KANE COUNTY

Bid Tabulations

February 25, 2016


Bond

Signed

BFAddm. Base Bid Alternate #1 Alternate #2 Alternate #3

Total Base Bid +

Accepted Alts.

Roofing Prime Contractor

Elens & Maichin Roofing1621 Manhattan Road

Joliet, IL 60434X X 1,2 $393,500.00 $77,400.00 $122,800.00 $105,600.00 $576,500.00

Anthony Roofing Tecta America2555 White Oak Circle

Aurora, IL 60502X X 1,2 $352,350.00 $130,500.00 $193,000.00 $35,850.00 $518,700.00

G.E. Riddiford Roofing Company2333 Hamilton Road

Arlington Heights, IL 60005X X 1,2 $443,600.00 $72,500.00 $159,000.00 $109,700.00 $625,800.00

A-1 Roofing Company1425 Chase Avenue

Elk Grove Village, IL 60007

Crowther Roofing & Sheet Metal,

Inc.

18958 Airport Road

Romeoville, IL 60446X X 1,2 $415,800.00 $88,000.00 $258,000.00 $100,000.00 $603,800.00

Olsson Roofing740 S. Lake Street

Aurora, IL 60506X X 1,2 $454,200.00 $70,770.00 $186,400.00 $95,880.00 $620,850.00

Metalmaster Roofmaster Inc.4800 Metalmaster Way

McHenry, IL 60050

All American Exterior Solutions150 Oakwood Road

Lake Zurich, IL 60047X X 1,2 $423,000.00 $78,000.00 $299,000.00 $127,000.00 $628,000.00

Combined Roofing Services LLC621 W. Washington Street

West Chicago, IL 60185X X 1,2 $424,800.00 $82,200.00 $280,000.00 $125,000.00 $632,000.00

L. Marshall Inc.2100 Lehigh Avenue

Glenview, IL 60026X X 1,2 $780,000.00 $150,000.00 $1,150,000.00 $290,000.00 $1,220,000.00

Malcor Roofing of Illinois1793 Commerce Drive

Montgomery, IL 60538X X 1,2 $365,765.00 $36,500.00 $115,730.00 $97,595.00 $499,860.00

Solaris Roofing31W023 North Ave

West Chicago, IL 60185

DCG Roofing Solutions1285 Rand Rd,

Des Plaines, IL 60016X X 1,2 $384,900.00 $104,500.00 $174,000.00 $147,900.00 $637,300.00

$499,860.00

15% $74,979.00

$574,839.00

KBC Roofing Project


Contingency:


NO BID

NO BID

NO BID

Packet Pg. 66


Resolution No.

Authorizing an Intergovernmental Agreement with Stephenson County

Committee Flow: Judicial/Public Safety Committee, Finance and Budget Committee, Executive Committee, County Board Contact: Rick Anselme, 630.406.7468

Budget Information:

Was this item budgeted? N/A Appropriation Amount: N/A

If not budgeted, explain funding source: N/A

Summary:

This resolution is for an Intergovernmental Agreement between Kane County and Stephenson County. Kane County will guarantee housing for up to five (5) Stephenson County minors at a time at the Kane County Juvenile Justice Center with a per diem charge of $120.00 per day, per minor. The agreement will commence upon the date of approval and will continue for a period of two (2) years from that date. This agreement may be amended with written consent of all parties hereto and, provided a need continues to exist, may be renewed thirty (30) days prior to the expiration date for a period not to exceed one (1) year for each renewal.

Packet Pg. 67

STATE OF ILLINOIS

COUNTY OF KANE

RESOLUTION NO.

AUTHORIZING AN INTERGOVERNMENTAL AGREEMENT WITH STEPHENSON COUNTY

WHEREAS, the Constitution of the State of Illinois of 1970, Article VII, Section 10, provides that units of local government may contract or otherwise associate among themselves to obtain or share services and to exercise, combine or transfer any power of function in any manner not prohibited by law or by ordinance and may use their credit, revenues and other resources to pay costs related to intergovernmental activities; and

WHEREAS, the Intergovernmental Cooperation Act, 5 ILCS 220/1 et seq, provides that any

county may participate in an intergovernmental agreement under this Act notwithstanding the absence of specific authority under the State law to perform the service involved provided that the unit of local government contracting with the county has authority to perform the service; and

WHEREAS, Stephenson County desires to enter into an intergovernmental agreement with

Kane County wherein Kane County will guarantee housing for five (5) Stephenson County minors at its Juvenile Justice Center with a per diem charge of $120.00 (one hundred and twenty dollars) per day, per minor; and

WHEREAS, the intergovernmental agreement with Stephenson County commences upon

the date of approval and acceptance by all parties hereto and will continue for a period of two (2) years from that date. This agreement may be amended with written consent of all parties hereto and, provided a need continues to exist, may be renewed thirty (30) days prior to the expiration date for a period not to exceed one (1) year for each renewal.

NOW, THEREFORE, BE IT RESOLVED by the Kane County Board that the Chairman

thereof is hereby authorized to enter into an agreement with the County of Stephenson (a copy of which shall be filed with the Kane County Clerk) for Juvenile Detention Services.



Vote:

16-04 IGA Stephenson Cty

Packet Pg. 68


Resolution No.

Authorizing Contract for Electronic Monitoring Extension

Committee Flow: Finance and Budget Committee, Executive Committee, County Board Contact: Mary Smith, 630.232.5803

Budget Information:

Was this item budgeted? Yes Appropriation Amount:


Summary:

To enter into a two-year contract extension with BI Incorporated for continued provision of electronic monitoring equipment and services.

Packet Pg. 69

STATE OF ILLINOIS

COUNTY OF KANE

RESOLUTION NO.

AUTHORIZING CONTRACT FOR ELECTRONIC MONITORING EXTENSION

WHEREAS, Kane County has contracted with BI Incorporated to provide electronic monitoring equipment and services effective March 7, 2014; and

WHEREAS, Resolution #14-105 allows for an option to extend the contract for up to an

additional two years; and WHEREAS, the parties wish to execute an extension of said contract to March 6, 2018, with

no cost increase to Kane County over the amount as approved in 2014 of One Dollar and Ninety Three Cents ($1.93) per radio frequency land line unit per day and Three Dollars and Fifty Cents ($3.50) per radio frequency cellular unit per day.

NOW, THEREFORE, BE IT RESOLVED by the Kane County Board that the Chairman

thereof be, and hereby is, authorized to enter into a contract extension with BI Incorporated for the provision of electronic monitoring equipment and services for a two year contract renewal period of March 7, 2016 through March 6, 2018, subject to appropriation.



Vote:

16-04 Electronic Monitoring

Packet Pg. 70


Resolution No.

Ratifying Emergency Line of Credit from the General Fund to the Title IV Fund

Committee Flow: Judicial/Public Safety Committee, Finance and Budget Committee, Executive Committee, County Board Contact: Joseph Onzick, 630.208.5113

Budget Information:

Was this item budgeted? See Summary Appropriation Amount: $310,000

If not budgeted, explain funding source: See Summary

Summary:

The State of Illinois budget impasse has resulted in the suspension of Title IV payments which fund the Child Support division of the State’s Attorney’s Office. This has resulted in an outstanding receivable balance of $335,403 as of 1/31/2016 which has the potential to grow to $900,000 by the end of Fiscal Year 2016. The suspension of payments also resulted in a negative cash balance of $16,730 as of 1/31/16 that has the potential of growing to $587,000 by the end of Fiscal Year 2016. Since it is in the best interest of Kane County to continue operation of the Child Support Unit, an emergency line of credit not to exceed $310,000 was extended from the General Fund to the Title IV Fund in accordance with the emergency purchase provision of the Procurement Ordinance. This emergency line of credit now needs to be ratified by the County Board. This line of credit will be in place until June 30, 2016 and shall be repaid from Title IV payments when resumed by the State.

Packet Pg. 71

STATE OF ILLINOIS

COUNTY OF KANE

RESOLUTION NO.

RATIFYING EMERGENCY LINE OF CREDIT FROM THE GENERAL FUND TO THE TITLE IV FUND

WHEREAS, the Child Support Unit of the Kane County State’s Attorney’s Office provides

legal representation to the State of Illinois Department of Healthcare and Family Services, pursuant

to a contractual relationship under the authority of 305 ILCS 5/10-1 and Title IV-D of the Social

Security Act; and for which an annual budget has been approved by the County Board; and

WHEREAS, the State of Illinois budget impasse has caused the suspension of Title IV

funding for the Child Support Unit of Kane County as of July 1, 2015 creating an outstanding

receivable balance of $335,403 and a negative cash balance of $16,730 as of 1/31/2016; and

WHEREAS, it is in the best interest of Kane County to continue operation of the Child

Support Unit and therefore requires a temporary source of cash until the state budget impasse is

resolved, in order to avoid the loss of federal and state funds due when the budget impasse is

resolved; and

WHEREAS, the total amount of cash required to sustain the cost of operation through June

30, 2016 is $310,000.

NOW, THEREFORE, BE IT RESOLVED by the Kane County Board that a line of credit from the General Fund be extended to the Title IV Fund in an amount not to exceed $310,000 for the purpose of sustaining the cost of operation of the Child Support Unit of the State’s Attorney’s Office through June 30, 2016 with the understanding that the Title IV Fund will repay any outstanding balance on the line of credit from the General Fund from any proceeds from Title IV payments received from the state.



Vote:

16-04 CSU LOC

Packet Pg. 72

Packet Pg. 73

Packet Pg. 74

Court Case Management Project Report March 2016

Submitted by: Bob Enright, CMS Project Manager and Barb Garza, ITD Project Manager Project Sponsor: Roger Fahnestock, ITD Chief Information Officer Project Overview: The Kane County Court Case Management Project is a joint effort between the Judiciary, Circuit Clerk, States Attorney Office and Public Defenders Office to implement the full-featured commercial court case management system provided by Tyler Technologies called Odyssey. Once implemented, Odyssey will enable information sharing between Kane County Justice Partners in a timely, accurate and efficient manner. Project Status: Work has begun on the additional development work that had been identified by the stakeholders as being necessary for operations. The new modules will begin to be incorporated into Odyssey releases in April, May and June. Bi-weekly meetings are held that demonstrate the progress on the particular development item that has been worked on during the previous weeks. Work continues on the following:

Circuit Clerk Conversion – The third conversion of Circuit Clerk data is scheduled to begin the second week of April. IT staff is working with Tyler’s conversion team developing the business rules that will be applied to the States Attorney’s data. The first States Attorney conversion is scheduled together with the next Circuit Clerk conversion. Security – A working group consisting of staff from the Circuit Clerk, States Attorney, Public Defender and

Judiciary are working together on joint security issues and cross domain business processes. Infrastructure – Tyler staff will be on site the second week of April to work with Kane County IT staff on building out the Odyssey production and development environments. Training – Staff from IT, States Attorney and Public Defender will be attending Odyssey training the first week of April. Each department is continuing to work on forms, reports, configuration and testing.

No additional items have been identified that will effect scope or cost. Go-live is currently scheduled for Labor Day Weekend 2016.

Packet Pg. 75

Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year TotalFund 127 - Judicial Technology Sales Tax

REVENUEDepartment 800 - Other- Countywide Expenses

Sub-Department 000 - Revenues30105 Sales Tax- RTA 989,640.00 .00 989,640.00 83,807.10 .00 83,807.10 905,832.90 8 1,009,070.2638000 Investment Income 2,250.00 .00 2,250.00 .00 .00 11,289.54 (9,039.54) 502 22,066.3939000 Transfer From Other Funds .00 .00 .00 .00 .00 .00 .00 +++ 2,000,000.0039900 Cash On Hand 1,996,255.00 1,348,260.00 3,344,515.00 .00 .00 .00 3,344,515.00 0 .00

Sub-Department 000 - Revenues Totals $2,988,145.00 $1,348,260.00 $4,336,405.00 $83,807.10 $0.00 $95,096.64 $4,241,308.36 2% $3,031,136.65Department 800 - Other- Countywide Expenses Totals $2,988,145.00 $1,348,260.00 $4,336,405.00 $83,807.10 $0.00 $95,096.64 $4,241,308.36 2% $3,031,136.65

REVENUE TOTALS $2,988,145.00 $1,348,260.00 $4,336,405.00 $83,807.10 $0.00 $95,096.64 $4,241,308.36 2% $3,031,136.65EXPENSE

Department 800 - Other- Countywide ExpensesSub-Department 812 - Judicial Technology Sales Tax

40000 Salaries and Wages 336,818.00 .00 336,818.00 25,774.62 .00 90,165.85 246,652.15 27 305,891.1745000 Healthcare Contribution 48,663.00 .00 48,663.00 4,160.32 .00 12,238.65 36,424.35 25 43,224.5045009 Healthcare Subsidy .00 .00 .00 (206.42) .00 (516.05) 516.05 +++ .0045010 Dental Contribution 2,095.00 .00 2,095.00 180.36 .00 534.01 1,560.99 25 1,878.1945019 Dental Subsidy .00 .00 .00 (4.84) .00 (12.10) 12.10 +++ .0045100 FICA/SS Contribution 25,767.00 .00 25,767.00 1,923.93 .00 6,748.95 19,018.05 26 22,913.0945200 IMRF Contribution 33,716.00 .00 33,716.00 2,517.44 .00 8,889.35 24,826.65 26 30,711.5150150 Contractual/Consulting Services 280,000.00 .00 280,000.00 31,403.15 .00 97,491.15 182,508.85 35 247,176.1050340 Software Licensing Cost 455,000.00 .00 455,000.00 669.00 109,647.86 669.00 344,683.14 24 28,882.2653000 Liability Insurance 6,299.00 .00 6,299.00 .00 .00 .00 6,299.00 0 5,945.0053010 Workers Compensation 6,467.00 .00 6,467.00 .00 .00 .00 6,467.00 0 5,749.0053020 Unemployment Claims 640.00 .00 640.00 .00 .00 .00 640.00 0 752.0053100 Conferences and Meetings 50,000.00 .00 50,000.00 8,892.80 .00 10,137.16 39,862.84 20 21,500.2653110 Employee Training 50,000.00 .00 50,000.00 423.63 .00 4,313.83 45,686.17 9 20,160.9253120 Employee Mileage Expense 1,000.00 .00 1,000.00 17.28 .00 51.93 948.07 5 276.7453130 General Association Dues .00 .00 .00 .00 .00 .00 .00 +++ 129.0060000 Office Supplies 1,500.00 .00 1,500.00 .00 .00 101.56 1,398.44 7 98.7560020 Computer Related Supplies 3,100.00 .00 3,100.00 420.00 .00 420.00 2,680.00 14 2,214.6260070 Computer Hardware- Non Capital 3,000.00 .00 3,000.00 .00 .00 .00 3,000.00 0 4,490.3264000 Telephone 960.00 .00 960.00 .00 .00 .00 960.00 0 .0064010 Cellular Phone 3,120.00 .00 3,120.00 .00 .00 .00 3,120.00 0 .0070000 Computers 200,000.00 .00 200,000.00 .00 .00 .00 200,000.00 0 465,364.2370020 Computer Software- Capital 1,480,000.00 1,348,260.00 2,828,260.00 198,811.00 1,729,002.74 656,394.00 442,863.26 84 1,426,936.5970060 Communications Equipment .00 .00 .00 .00 .00 .00 .00 +++ 13,250.0070080 Office Furniture .00 .00 .00 .00 .00 .00 .00 +++ 3,525.86

Sub-Department 812 - Judicial Technology Sales Tax Totals

$2,988,145.00 $1,348,260.00 $4,336,405.00 $274,982.27 $1,838,650.60 $887,627.29 $1,610,127.11 63% $2,651,070.11

Run by Enright, Bob on 03/21/2016 08:07:39 AM Page 1 of 2

Budget Performance ReportFiscal Year to Date 02/29/16

Include Rollup Account and Rollup to Account

Packet Pg. 76

Adopted Budget Amended Current Month YTD YTD Budget - YTD % used/Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year TotalFund 127 - Judicial Technology Sales Tax

EXPENSEDepartment 800 - Other- Countywide Expenses Totals $2,988,145.00 $1,348,260.00 $4,336,405.00 $274,982.27 $1,838,650.60 $887,627.29 $1,610,127.11 63% $2,651,070.11

EXPENSE TOTALS $2,988,145.00 $1,348,260.00 $4,336,405.00 $274,982.27 $1,838,650.60 $887,627.29 $1,610,127.11 63% $2,651,070.11

Fund 127 - Judicial Technology Sales Tax TotalsREVENUE TOTALS 2,988,145.00 1,348,260.00 4,336,405.00 83,807.10 .00 95,096.64 4,241,308.36 2 3,031,136.65EXPENSE TOTALS 2,988,145.00 1,348,260.00 4,336,405.00 274,982.27 1,838,650.60 887,627.29 1,610,127.11 63 2,651,070.11

Fund 127 - Judicial Technology Sales Tax Totals $0.00 $0.00 $0.00 ($191,175.17) ($1,838,650.60) ($792,530.65) $2,631,181.25 $380,066.54

Grand TotalsREVENUE TOTALS 2,988,145.00 1,348,260.00 4,336,405.00 83,807.10 .00 95,096.64 4,241,308.36 2 3,031,136.65EXPENSE TOTALS 2,988,145.00 1,348,260.00 4,336,405.00 274,982.27 1,838,650.60 887,627.29 1,610,127.11 63 2,651,070.11

Grand Totals $0.00 $0.00 $0.00 ($191,175.17) ($1,838,650.60) ($792,530.65) $2,631,181.25 $380,066.54

Run by Enright, Bob on 03/21/2016 08:07:39 AM Page 2 of 2

Budget Performance ReportFiscal Year to Date 02/29/16

Include Rollup Account and Rollup to Account

Packet Pg. 77

1

OFFICE OF THE KANE COUNTY AUDITOR TERRY HUNT, KANE COUNTY AUDITOR

March 30, 2016

FINANCE and BUDGET COMMITTEE REPORT

Updates from the Auditor’s Office

• The internal audit of the Office of the Circuit Clerk is currently in progress. To minimize any interference with operations, we have scheduled as much of our work as possible to be done during the same time as the external auditors are performing their field work. We will provide a draft copy of our report, including any findings and recommendations to the Circuit Clerk and his designated staff members for management responses before the final report is issued.

• The internal audit of the County’s purchasing process is also currently in progress. It should be noted that this audit addresses the process as opposed to the department. The audit of the Finance Department, including the Purchasing Department will be done at a later date. We will provide a draft copy of our report, including any findings and recommendations to both the Finance Director and the Purchasing Director for management responses before the final report is issued.

• In October the County Board passed Resolution 15-277 authorizing the County Auditor to make inquiries of area financial institutions for the purpose of discovering unrecorded bank accounts. We contacted seventy-four financial institutions doing business through main and/or branch offices in Kane County. As a result of that search, seven bank accounts not previously known or reported were found to be using the FEIN assigned to Kane County. The resulting details have been provided to the Finance Department for further consideration.

• Agency Funds, as defined in GAAP, are a specific type of fiduciary funds used to account for resources held by the county in a purely custodial capacity for other governments, private organizations or individuals. Agency funds do not have revenue or expense activity. To ensure that all county funds currently being categorized as agency funds meet the required criteria, we plan to send questionnaires to all stakeholders responsible for those funds asking for details about the purpose of the fund, and the activities associated with the accounting for the fund.

ANDREA RICH DEPUTY AUDITOR MARGARET TODD-CAVE STAFF AUDITOR

719 S.BATAVIA AVENUE GENEVA, ILLINOIS 60134

630-232-5915

630-208-3838 (FAX)

Packet Pg. 78

Accounts Payable Claims Paid Report

• 1,751 invoices were processed in February 2016 which resulted in payments of $6,335,595. The detailed report is available on the County Auditor’s section of the Kane County website at

http://www.kanecountyauditor.com/Documents/Monthly%20Claims%20Paid%20Reports/February%202016.pdf

That same information in a user friendly format is available on the Kane County OpenGov platform. Click on the link below to see the online checkbook for February 2016.

https://kanecountyil.opengov.com/data#/1401/query=D30493E118B137209DB3C12F658EA420&isVisible=0&breakdown=department&showBy=_sum&graphType=bar

The following chart illustrates the comparison between accounts payable claims paid by month for fiscal years 2016, 2015, 2014, 2013 and 2012.

Packet Pg. 79

http://www.kanecountyauditor.com/Documents/Monthly%20Claims%20Paid%20Reports/February%202016.pdf

https://kanecountyil.opengov.com/data%23/1401/query=D30493E118B137209DB3C12F658EA420&isVisible=0&breakdown=department&showBy=_sum&graphType=bar

https://kanecountyil.opengov.com/data%23/1401/query=D30493E118B137209DB3C12F658EA420&isVisible=0&breakdown=department&showBy=_sum&graphType=bar