The URL can be used to link to this page

Home My WebLink About324679 04/30/18 - �y"...,'''c. . CITY OF CARMEL, INDIANA VENDOR: 071300 ?; ONE CIVIC SQUARE C. L. COONROD & COMPANY CHECK AMOUNT: $****38,088.00* =Q CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 324679 cMi[goN� SUITE 225 CHECK DATE: 04/30/18 INDIANAPOLIS IN 46240 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4341999 101207 1150033118 27,263.00 CAFR—RELATED ACCOUNTI 1160 4340303 101208 1160033118 10,825.00 PROFESSIONAL ACCOUNTI -t. VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) Vendor# 071300 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER C. L. COONROD&COMPANY IN SUM OF$ CITY OF CARMEL 3850 PRIORITY WAY SOUTH DRIVE An invoice or bill to be property itemized must show:kind of service,where performed,dates service SUITE 225 rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. INDIANAPOLIS, IN 46240 Payee $10,825.00 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Terms Mayor's Office Date Due PO# ACCT# DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 101208 1160-033118 43-403.03 $10,825.00 1 hereby certify that the attached invoice(s),or 4/5/18 1160-033118 $10,825.00 1160 101 1160 101 bill(s)is(are)true and correct and that the materials or services itemized thereon for which charge is made were ordered and received except Wednesday,April 25,2018 Kibbe, Sharon Executive Office Manager I hereby certify that the attached invoice(s),or bill(s),is(are)true and correct and I have audited same in accordance with IC 5-11-10-1.6 ,20 Clerk-Treasurer INVOICE 1160-033118 P.O.101208 Hon.James C.Brainard Mayor,City of Carmel Attn:Sharon Kibbe One Civic Square Carmel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 April 5,2018 Professional services through March 31,2018,in connection with: Assessment Respond to questions from Council regarding certain assessments, $ 276 review assessment analysis for council request Budget Consultation Prepare for Council meeting,follow-up on conference committee 3,628 LIT report formulas,follow-up on bond debt service and Legacy Project,TIF bonds,Abstract follow-up Legislation Devise LIT formula based on population and income 360 Plan Determine impact of Legacy TIF defeasement 1,405 Project 2019 LIT distribution,NAV analysis and follow-up,AV follow-up, Carmel AV analysis and follow-up,follow-up on City AV and Sycamore Project 5,060 TIF Review TIF proposal 96 Out of pocket expense - Total amount of this invoice. 10,825 Previous balance. 12,154 Payment received. - Total amount due. $ 22,979 Call(317)844-4605 with questions CITY OF CARMEL April 5,2018 Professional services through March 31,2018,in connection with: Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. Performina Service Service Date Services Provided Hourly Rate Total Coonrod 3/23/2018 Assessment 240 0.40 96 Coonrod 3/38/2018 Assessment 240 0.75 180 Assessment Total 276 Roeger 3/16/2018 Budget consultation 220 0.40 88 Coonrod 3/17/2018 Budget consultation 240 0.10 24 Coonrod 3/19/2018 Budget consultation 240 1.95 468 Roeger 3/19/2018 Budget consultation 220 3.15 693 Roeger 3/19/2018 Budget consultation 220 1.20 264 Coonrod 3/20/2018 Budget consultation 240 2.95 708 Roeger 3/20/2018 Budget consultation 220 2.00 440 Lilly 3/22/2018 Budget consultation 175 1.75 306 Lilly 3/29/2018 Budget consultation 175 1.75 306 Roeger 3/20/2018 Budget consultation 220 0.90 198 Roeger 3/30/2018 Budget consultation 220 0.60 132 Budget consultation Total 3,627 Coonrod 3/16/2018 Legislation 240 1.50 360 Legislation Total 360 Roeger 3/20/2018 Plan 220 3.55 781 Coonrod 3/20/2018 Plan 240 0.90 216 Coonrod 3/21/2018 Plan 240 1.70 408 Plan Total 1,405 Roeger 3/16/2018 Project 220 4.00 880 Roeger 3/19/2018 Project 220 1.25 275 Roeger 3/26/2018 Project 220 1.75 385 Roeger 3/27/2018 Project 220 0.60 132 Roeger 3/27/2018 Project 220 0.50 110 Roeger 3/27/2018 Project 220 1.45 319 Roeger 3/27/2018 Project 220 2.75 605 Roeger 3/28/2018 Project 220 3.65 803 Roeger 3/28/2018 Project 220 2.80 616 Roeger 3/29/2018 Project 220 1.65 363 Roeger 3/29/2018 Project 220 2.60 572 Project Total 5,060 Coonrod 3/29/2018 TIF 240 0.40 96 Legislation Total 96 Publishing&printing 0 Mileage 0 TOTAL invoice amount 10,825 VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) Vendor# 071300 ALL 20 ACCOUNTS PAYABLE VOUCHER C. L. COONROD&COMPANY IN SUM OF$ CITY OF CARMEL 3850 PRIORITY WAY SOUTH DRIVE An invoice or bill to be properly itemized must show:kind of service,where performed,dates service SUITE 225. rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. INDIANAPOLIS, IN 46240 Payee $27,263.00 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Terms Mayor's Office Date Due PO# ACCT# DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT. 101207 1150-033118 43-419.99 $27,263.00 1 hereby certify that the attached invoice(s),or 4/11/18 1150-033118 $27,263.00 1160 101 1160 101 bill(s)is(are)true and correct and that the materials or services itemized thereon for which charge is made were ordered and received except Wednesday,April 25,2018 Kibbe, Sharon Executive Office Manager I hereby certify that the attached invoice(s),or bill(s),is(are)true and correct and I have audited same in accordance with IC 5-11-10-1.6 ,20 Clerk-Treasurer INVOICE 1150-033118 P.O.101207 Board of Works City of Carmel Attn:Sharon Kibbe One Civic Square Carmel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 April 11,2018 Professional services through March 31,2018,in connection with: 2017 CAFR: AR -Medicaid supplemental $ 77 Bond premium 348 Bond principal,debt disclosure 520 Enterprise funds 1,166 Finalize and reconcile statements 15,355 Local pensions 240 MD&A 231 Net investment in capital assets 480 OPEB 1,623 PERS pensions 2,914 Subtotal 22,954 Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17, 2017($70,040). 22,954 Work outside scope-Utility statement changes,preparation for audit committee meeting,follow-up on C-T issues regarding actuary reports,work on utility statement updates,follow-up on utility statements and related reconciliation problem 4,309 Total amount of this invoice. 27,263 Previous balance. Payment received. - Total amount due. $ 27,263 CITY OF CARMEL April 11,2018 Professional services through March 31,2018, in connection with: Performing Service Date Services Provided Hourly Rate Hours Total Service Roeger 3/19/2018 AR-medicaid supplemental 220 0.35 77 AR-medicaid supplemental Total 77 Coonrod 3/22/2018 Bond premiums 240 1.45 348 Bond premiums Total 348 Roeger 3/22/2018 Bond principal 220 0.40 88 Coonrod 3/23/2018 Bond principal 240 0.20 48 Coonrod 3/28/2018 Bond principal 240 1.60 384 Bond principal Total 520 Coonrod 3/20/2018 Enterprise funds 240 0.25 60 Lilly 3/26/2018 Enterprise funds 175 2.80 490 Coonrod 3/26/2018 Enterprise funds 240 0.10 24 Roeger 3/27/2018 Enterprise funds 220 0.85 187 Coonrod 3/27/2018 Enterprise funds 240 1.00 240 Roeger 328/2018 Enterprise funds 220 0.75 165 Enterprise funds Total 1,166 Lilly 3/19/2018 Finalize and recogncile statements 175 6.50 1,138 Coonrod 3/19/2018 Finalize and recogncile statements 240 2.35 564 Lilly 3/20/2018 Finalize and recogncile statements 175 1.70 298 Lilly 3/21/2018 Finalize and recogncile statements 175 2.80 490 Lilly 3/22/2018 Finalize and recogncile statements 175 4.85 849 Lilly 2/23/2018 Finalize and recogncile statements 175 3.90 683 Lilly 3/24/2018 Finalize and recogncile statements 175 6.20 1,085 Coonrod 3/24/2018 Finalize and recogncile statements 240 1.80 432 Coonrod 3/25/2018 Finalize and recogncile statements 240 1.15 276 Lilly 3/26/2018 Finalize and recogncile statements 175 5.55 971 Coonrod 3/26/2018 Finalize and recogncile statements 240 1.35 324 Lilly 3/27/2018 Finalize and recogncile statements 175 6.75 1,181 Coonrod 3/27/2018 Finalize and recogncile statements 240 1.70 408 Lilly 3/28/2018 Finalize and recogncile statements 175 8.20 1,435 Coonrod 3/28/2018 Finalize and recogncile statements 240 1.30 312 Coonrod 3/28/2018 Finalize and recogncile statements 240 2.85 684 Lilly 3/29/2018 Finalize and recogncile statements 175 8.85 1,549 Lilly 3/30/2018 Finalize and recogncile statements 175 8.35 1,461 Coonrod 3/30/2018 Finalize and recogncile statements 240 2.00 480 Lilly 3/31/2018 Finalize and recogncile statements 175 4.20 735 Finalize and recogncile statements Total 15,355 Coonrod 3/30/2018 Local pensions 240 1.00 240 Local pensions Total 240 Roeger 3/30/2018 MD&A 220 1.05 231 MD&A Total 231 Coonrod 3/30/2018 Net investment in capital assets 240 2.00 480 Net investment in capital assets Total 480 Lilly 3/21/2018 OPEB 175 3.85 674 Coonrod 3/23/2018 OPEB 240 0.05 12 Lilly 3/27/2018 OPEB 175 2.25 394 Lilly 3/29/2018 OPEB 175 3.10 543 OPEB Total 1,623 Lilly 3/20/2018 PERS pensions 175 4.80 840 Lilly 3/23/2018 PERS pensions 175 3.55 621 Lilly 3/26/2018 PERS pensions 175 5.10 893 Lilly 3/28/2018 PERS pensions 175 3.20 560 PERS pensions Total 2,914 Lilly 3/20/2018 Work outside scope 175 2.55 446 Coonrod 3/20/2018 Work outside scope 240 2.20 528 Coonrod 3/21/2018 Work outside scope 240 3.30 792 Coonrod 3/21/2018 Work outside scope 240 2.00 480 Lilly 3/22/2018 Work outside scope 175 1.60 280 Coonrod 3/22/2018 Work outside scope 240 0.65 156 Coonrod 3/23/2018 Work outside scope 240 0.20 48 Lilly 3/28/2018 Work outside scope 175 3.40 595 Coonrod 3/29/2018 Work outside scope 240 4.10 984 Work outside scope Total 4,309 Publishing&printing 0 Mileage 0 TOTAL invoice amount 27,263