HomeMy WebLinkAbout329919 9/11/2018 CITY OF CARMEL, INDIANA VENDOR: 071300
® ONE CIVIC SQUARE C. L. COONROD &COMPANY CHECK AMOUNT: $****16,927.00*
CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 329919
SUITE 225 CHECK DATE: 09111/18
INDIANAPOLIS IN 46240
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION
1160 4341999 101207 1150083118 888:00 CAFR-RELATED ACCOUNTI
1160 4340303 101208 1160083118 16,039.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
$888.00
ON ACCOUNT OF APPROPRIATION FOR Purchase Order#
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-083118 43-419.99 $888.00 1 hereby certify that the attached invoice(s),or 8/31/18 1150-083118 $888.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, September 05,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-083118
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
August 31,2018
Professional services through August 31,2018,in connection with:
2017 CAFR:
Subtotal
Out of pocket expense-mileage -
Subtotal,work within the scope of our engagement letter dated January 17,
2017($70,040).
Work outside scope-Respond to questions regarding allocation of city costs to utilities,
audit response,utility statements
888
Total amount of this invoice. 888
Previous balance. $ 7,994
Payment received. (7,994)
Total amount due. $ 888
Call(317)844-4605 with questions
CITY OF CARMEL
August 1,2018
For Professional Services through July 31,2018 in connection with
Performing Service Service Date Services Provided Hourly Rate Hours Total
Bahler 8/1/2018 Work outside scope 100 0.45 45
Coonrod 8/20/2018 Work outside scope 240 0.10 24
Roeger 8/21/2018 Work outside scope 220 0.50 110
Lilly 8/23/2018 Work outside scope 175 1.80 315
Lilly 8/27/2018 Work outside scope 175 2.25 394
Work outside scope Total 888
Publishing&printing 0
Mileage 0
TOTAL invoice amount 888
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
$16,039.00
ON ACCOUNT OF APPROPRIATION FOR Purchase Order#
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-083118 43-403.03 $16,039.00 1 hereby certify that the attached invoice(s),or 8/31/18 1160-083118 $16,039.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, September 05,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-083118
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
August 31,2018
Professional services through August 31,2018,in connection with:
Accounting Prepare for Audit Committee meeting,respond to question from $ 612
Audit Committee and review C-T responses to audit findings
Annexation Respond to questions regarding census application 144
Audit Review audit responses,respond to 2017 audit comments including 5,645
utility cost administrative fee,respond to SBOA regarding RDA
report findings and exit conference issues,analysis of utility
management fee for SBOA,audit committee meeting
Bond/Lease Response to OPEB issue,investigate 10 year amortization schedule 252
for LIT bond
Budget Consultation LIT follow-up,budget forms follow-up,budget matters 3,198
Economic Development Winamac and Carmel tax comparison analysis 1,271
Legislation Meeting with LIT legislation lobbyists,follow-up analysis for 3,044
proposed LIT legislation.
LOIT Analysis Follow-up on IDR explanation for slow income growth,LIT 1,037
anaylsis and follow-up
Plan Parks salary estimate,projection of Sewer Utility fees 132
Project Review parks salary estimate,follow up on utility management fees 704
calculation.
Out of pocket expense -
Total amount of this invoice. 16,039
Previous balance. $ 15,378
Payment received. (15,378)
Total amount due. $ 16,039
CITY OF CARMEL
August 31,2018
Professional services through August 31,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
Coonrod 8/27/2018 Accounting System 240 1.85 444
Coonrod 8/28/2018 Accounting System 240 0.70 168
Accounting System Total 612
Coonrod - 8/24/2018 Annexation 240 0.60 144
Annexation Total 144
Lilly 8/20/2018 Audit 175 1.45 254
Coonrod 8/20/2018 Audit 240 3.30 792
Lilly 8/21/2018 Audit 175 1.00 175
Coonrod 8/21/2018 Audit 240 1.10 264
Coonrod 8/22/2018 Audit 240 3.10 744
Lilly 8/23/2018 Audit 175 2.10 368
Coonrod 8/23/2018 Audit 240 7.55 1,812
Coonrod 8/30/2018 Audit 240 5.15 1,236
Audit Total 5,645
Coonrod 8/22/2018 Bond/Lease 240 0.45 108
Coonrod 8/28/2018 Bond/Lease 240 0.60 144
Bond/Lease Total 252
Lilly 8/16/2018 Budget Consulation 175 1.80 315
Roeger 8/16/2018 Budget Consulation 220 0.85 187
Lilly 8/16/2018 Budget Consulation 175 1.75 306
Lilly 8/20/2018 Budget Consulation 175 1.55 271
Roeger 8/20/2018 Budget Consulation 220 1.25 275
Roeger 8/20/2018 Budget Consulation 220 0.90 198
Roeger 8/21/2018 Budget Consulation 220 0.60 132
Roeger 8/21/2018 Budget Consulation 220 1.75 385
Roeger 8/22/2018 Budget Consulation 220 1.85 407
Lilly 8/23/2018 Budget Consulation 175 1.75 306
Roeger 8/28/2018 Budget Consulation 220 0.50 110
Lilly 8/30/2018 Budget Consulation 175 1.75 306
Budget Consultation Total 3,198
Lilly 8/27/2018 Budget Consulation 175 2.80 490
Lilly 8/28/2018 Budget Consulation 175 1.85 324
Coonrod 8/28/2018 Budget Consulation 240 0.50 120
Lilly 8/29/2018 Budget Consulation 175 1.10 193
Coonrod 8/29/2018 Budget Consulation 240 0.30 72
Coonrod 8/30/2018 Budget Consulation 240 0.30 72
Budget Consultation Total 1,271
Coonrod 8/20/2018 Legislation 240 0.60 144
Bahler 8/20/2018 Legislation 100 0.20 20
Coonrod 8/21/2018 Legislation 240 2.30 552
Coonrod 8/27/2018 Legislation 240 1.00 240
Coonrod 8/28/2018 Legislation 240 2.00 480
Coonrod 8/29/2018 Legislation 240 3.70 888
Coonrod 8/31/2018 Legislation 240 3.00 720
Legislation Total 3,044
Coonrod 8/16/2018 Project 240 0.10 24
Roeger 8/17/2018 Project 220 3.85 847
Coonrod 8/20/2018 Project 240 0.05 12
Roeger 8/21/2018 Project 220 0.70 154
Project Total 1,037