The URL can be used to link to this page

Home My WebLink About323100 03/21/18 CITY OF CARMEL, INDIANA VENDOR: 071300 .,_ � i;• ONE CIVIC SQUARE C. L. COONROD & COMPANY CHECK AMOUNT: $****32,916.00* CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 323100 SUITE 225 CHECK DATE: 03/21/18 INDIANAPOLIS IN 46240 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4341999 101207 1150022818 1,300.00 CAFR-RELATED ACCOUNTI 1160 4341999 101207 1150031518 13,680.00 CAFR-RELATED ACCOUNTI 1160 4340303 101208 1160031518 17,936.00 PROFESSIONAL ACCOUNTI 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 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 $17,936.00 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Mayor's Office Terms 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-031518 43-403.03 $17,936.00 1 hereby certify that the attached invoice(s),or 3/19/18 1160-031518 $17,936.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 Monday,March 19,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 Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer INVOICE 1160-031518 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 March 19,2018 Professional services through March 15,2018,in connection with: Annual Report Consultation on annual report $ 70 Audit Review draft rating report 156 Bond/Lease Review Moody's press release 24 Budget Consultation Legislation follow-up,LIT analysis,budget matters,fiscal plan updates,debt items 3,667 Legislation Analysis of FIB 1104 proposal to freeze Carmel LIT,compromise plan development,prepare for/attend conference committee hearing, discuss projection and compromise plan with Fishers'accountant, respond to questions about HB 1104,analysis of additional compromise proposals. 7,500 LOIT Alternative LIT formula based on population and per capita income 144 Plan Debt worksheet updates 55 Project COIT analysis and follow-up,LIT distributions and follow-up, follow-up with DOR regarding Food and Beverage tax 6,320 Out of pocket expense Total amount of this invoice. 17,936 Previous balance. 22,798 Payment received. - Total amount due. $ 40,734 Call(317)844-4605 with questions CITY OF CARMEL March 19,2018 Professional services through March 15,2018,in connection with: Rates In accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. Performing Service Service Date Services Provided Hourly Rate Total Bahler 3/9/2018 Annual report 100 0.70 70 Annual report Total 70 Coonrod 3/1/2018 Audit 240 0.65 156 Audit Total 156 Coonrod 3/5/2018 Bond/Lease 240 0.10 24 Bond/Lease Total 24 Lilly 2/22/2018 Budget consultation 175 1.75 306 Lilly 3/1/2018 Budget consultation 175 1.75 306 Roeger 3/2/2018 Budget consultation 220 5.05 1,111 Roeger 3/5/2018 Budget consultation 220 2.15 473 Roeger 3/6/2018 Budget consultation 220 0.90 198 Roeger 3/6/2018 Budget consultation 220 0.40 88 Roeger 3/7/2018 Budget consultation 220 0.45 99 Lilly 3/8/2018 Budget consultation 175 1.75 306 Roeger 3/12/2018 Budget consultation 220 0.05 11 Roeger 3/13/2018 Budget consultation 220 1.10 242 Roeger 3/15/2018 Budget consultation 220 1.00 220 Lilly 3/15/2018 Budget consultation 175 1.75 306 Budget consultation Total 3,667 Coonrod 3/2/2018 Legislation 240 4.10 984 Coonrod 3/5/2018 Legislation 240 2.50 600 Coonrod 3/6/2018 Legislation 240 2.70 648 Coonrod 3/7/2018 Legislation 240 4.10 984 Coonrod 3/8/2018 Legislation 240 6.70 1,608 Coonrod 3/8/2018 Legislation 240 5.25 1,260 Coonrod 3/8/2018 Legislation 240 4.05 972 Coonrod 3/10/2018 Legislation 240 0.40 96 Coonrod 3/12/2018 Legislation 240 1.45 348 Legislation Total 7,500 Coonrod 3/15/2018 LOIT Analysis 240 0.60 144 LOIT Analysis Total 144 Roeger 3/13/2018 Plan Total 220 0.25 55 Plan Total 55 Roeger 3/5/2018 Project 220 0.15 33 Roeger 3/5/2018 Project 220 3.40 748 Roeger 3/6/2018 Project 220 1.45 319 Roeger 3/7/2018 Project 220 8.10 1,782 Roeger 3/8/2018 Project 220 8.80 1,936 Roeger 3/9/2018 Project 220 1.00 220 Roeger 3/9/2018 Project 220 2.70 594 Roeger 3/12/2018 Project 220 2.15 473 Roeger 3/12/2018 Project 220 0.15 33 Roeger 3/12/2018 Project 220 0.60 132 Bahler 3/14/2018 Project 100 0.50 50 Project Total 6,320 Publishing&printing 0 Mileage 0 TOTAL invoice amount 17,936 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 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 $13,680.00 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Mayor's Office Terms 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-031518 43-419.99 $13,680.00 1 hereby certify that the attached invoice(s),or 3/19/18 1150-031518 $13,680.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 Monday, March 19,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 Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer INVOICE 1150-031518 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 March 19,2018 Professional services through March 15,2018,in connection with: 2017 CAFR: Accounts payable $ 919 AR-property tax 158 Budgetary statements 473 Capital Assets 192 Enterprise funds 394 Finalize and reconcile statements 1,785 GFOA checklist 132 Introductory section,CAFR prep 324 Net investment in capital assets 344 MD&A 394 OPEB 1,864 PERS pensions 700 Trust cash 24 Subtotal 7,700 Publishing&printing Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17, 2017($70,040). 7,700 Work outside scope-follow-up on actuary reports and errors in cap assets,prepare for audit committee meeting,follow-up on GFOA comment on utility statements,pursue format ommissions in utility statements,report to audit committee,update capital assets database,adjustments and reclassifications to utility statements. 5,979 Total amount of this invoice. 13,680 Previous balance. 18,481 Payment received. - Total amount due. $32,161 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL March 19,2018 Professional services through March 15,2018, in connection with: Performing Service Date Services Provided Hourly Rate Hours Total Service Lilly 3/8/2018 Accounts payable 175 2.15 376 Lilly 3/10/2018 Accounts payable 175 3.10 543 Accounts payable Total 919 Lilly 3/13/2018 AR-property tax 175 0.90 158 AR-property tax Total 158 Lilly 3/7/2018 Budgetary statements 175 2.70 473 Budgetary statements Total 473 Coonrod 3/13/2018 Capital assets 240 0.50 120 Coonrod 3/14/2018 Capital assets 240 0.30 72 Capital assets Total 192 Lilly 3/14/2018 Enterprise funds 175 2.25 394 Enterprise funds Total 394 Lilly 3/11/2018 Finalize and recogncile statements 175 5.85 1,024 Lilly 3/15/2018 Finalize and recogncile statements 175 3.25 569 Coonrod 3/15/2018 Finalize and recogncile statements 240 0.80 192 Finalize and recogncile statements Total 1,785 Coonrod 3/15/2018 GFOA checklist 240 0.55 132 GFOA checklist Total 132 Lilly 3/6/2018 Introduction section, CAFR prep 175 1.85 324 Introduction section,CAFR prep Total 324 Lilly 3/1/2018 MD&A 175 2.25 394 MD&A Total 394 Lilly 3/15/2018 Net investment in capital assets 175 1.35 236 Coonrod 3/15/2018 Net investment in capital assets 240 0.45 108 Net investment in capital assets Total 344 Lilly 3/5/2018 OPEB 175 5.10 893 Lilly 3/6/2018 OPEB 175 1.70 298 Lilly 3/7/2018 OPEB 175 2.30 403 Lilly 3/7/2018 OPEB 175 0.50 88 Lilly 3/8/2018 OPEB 175 1.05 184 OPEB Total 1,864 Lilly 3/9/2018 PERS pensions 175 2.30 403 Lilly 3/14/2018 PERS pensions 175 1.70 298 PERS pensions Total 700 Coonrod 3/1/2018 Trust cash 240 0.10 24 Trust cash Total 24 Coonrod 3/1/2018 Work outside scope 240 0.15 36 Coonrod 3/1/2018 Work outside scope 240 3.35 804 Lilly 3/2/2018 Work outside scope 175 1.05 184 Lilly 3/5/2018 Work outside scope 175 2.85 499 Coonrod 3/5/2018 Work outside scope 240 2.40 576 Coonrod 3/6/2018 Work outside scope 240 2.40 576 Lilly 3/7/2018 Work outside scope 175 2.30 403 Coonrod 3/8/2018 Work outside scope 240 0.35 84 Lilly 3/9/2018 Work outside scope 175 5.55 971 Lilly 3/12/2018 Work outside scope 175 3.10 543 Lilly 3/13/2018 Work outside scope 175 1.90 333 Coonrod 3/13/2018 Work outside scope 240 1.10 264 Coonrod 3/14/2018 Work outside scope 240 0.40 96 Coonrod 3/14/2018 Work outside scope 240 2.00 480 Coonrod 3/15/2018 Work outside scope 240 0.55 132 Work outside scope Total 5,979 Publishing&printing 0 Mileage 0 TOTAL invoice amount 13,680 VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) ALLOWED 20 ACCOUNTS PAYABLE VOUCHER Vendor# 071300 IN SUM OF$ CITY OF CARMEL C. L. COONROD&COMPANY 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 .$1,300.00 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Mayor's Office Terms 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- 43-419.99 $1,300.00 1 hereby certify that the attached introice(s),or 3/14/18 1150- $1,300.00 022818'16CAFR 022818:16CAFR 1160 101 bill(s)is(are)true and correct and that the 1160 101 materials or services itemized thereon for Which charge is made were ordered and received except Thursday, March 15,2018 }09`1 Kibbe, Sharon Executive Office Manager 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 Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer INVOICE 1150-022818:16CAFR P.O.101207 Board of Works City of Carmel Attn:Sharon Kibbe One Civic Square Carmel,IN 46032 Make check payable to: Tax ID#36-1986669 C.L.Coonrod&Company 3860 Priority Way South Drive,Suite 226 Indianapolis,Indiana 46240 March 14,2018 Professional services through February 28,2018,in connection with: 2016 CAFR: Within scope $ Subtotal - Publishing&printing - Subtotal,work within the scope of our engagement letter for 2016,dated - January 17,2017($68,000). Out of pocket expense-2016 CAFR review by GFOA 580 Work outside scope-prepare for GFOA call regarding utility bond call rights waiver 720 Total amount of this invoice. 1,300 Previous balance. 840 Payment received. (840) Total amount due. $ 1,300 Payable upon receipt Call(317)844-4605 with questions. CITY OF CARMEL March 14,2018 Professional services through February 28,2018, in connection with: Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. !rforminct Servi Service Date Services Provided Hourly Rate Total Coonrod 2/6/2018 Work Outside Scope 240 3.00 720 Coonrod 2/28/2018 Reimburseable:2016 CAFR review by GFOA 580 Work Outside Scope Total 1,300 Publishing&printing 0 Mileage 0 TOTAL invoice amount 1,300