HomeMy WebLinkAbout328487 08/09/18 CITY OF CARMEL, INDIANA VENDOR: 071300
ONE CIVIC SQUARE C. L. COONROD&COMPANY CHECK AMOUNT: $****22,733.00*
CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 328487
9 �rpH'c�` SUITE 225 CHECK DATE: 08/09/18
INDIANAPOLIS IN 46240
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION
1160 4341999 101207 1150-073118 7,994.00 CAFR-RELATED ACCOUNTI
1160 4340303 101208 1160-073118 14,739.00 PROFESSIONAL ACCOUNTI
VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201.(Rev.1995)
vendor# oz�3oo 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 225rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc.
.INDIANAPOLIS, IN 46240
Payee:
$14,739.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-073118 43-403.03 $14,739.00I hereby certify that the attached invoice(s),or $/1718 1160-073118. $14,739.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
_Tuesday,August 07,2018'
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
1160-073118
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 1,2018
Professional services through July 31,2018,in connection with:
Assessment Analysis of commercial project impact $ 480
Bond/Lease Coverage on storm water bond,SBOA issues regarding trust 780
account
Budget Consultation Update fiscal plan with 2019 budget draft,follow up, 1,980
plan updates
Plan Parks and Recreation projection GAAP projection,commercial 5,468
property impact on tax rate analysis,CIP planning,P&R salary
analysis,LIT assumption analysis,review plan with 2019 budget
Project Parks analysis follow-up,property tax follow-up items,employee 6,009
compensation matters,F&B follow up on DOR progress,analysis
regarding conversion of Parks salary classifications to City
Out of pocket expense 22
Total amount of this invoice. 14,739
Previous balance. $ 18,628
Payment received. -
Total amount due. $ 33,367
Call(317)844-4605 with questions
CITY OF CARMEL
August 1,2018
Professional services through July 31,2018,in connection with:
Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor.
Performinq Service Service Date Services Provided Hourly Rate Total,
Coonrod 7/18/2018 Assessment 240 2.00 480
Assessment Total 480
Coonrod 7/23/2018 Bond/Lease q 240 1.25 300
Coonrod 7/27/2018 Bond/Lease 240 2.00 480
Bond/Lease Total 780
Lilly 7/19/2018 Budget Consultation 175 1.75 306
Roeger 7/23/2018 Budget Consultation 220 1.45 319
Roeger 7/23/2018 Budget Consultation 220 1.10 242
Roeger 7/26/2018 Budget Consultation 220 0.35 77
Lilly 7/26/2018 Budget Consultation 175 1.75 306
Roeger 7/30/2018 Budget Consultation 220 0.90 198
Roeger 7/30/2018 Budget Consultation 220 0.70 154
Coonrod 7/31/2018 Budget Consultation 240 0.20 48
Roeger 7/31/2018 Budget Consultation 220 1.00 220
Roeger 7/31/2018 Budget Consultation 220 0.50 110
Budget Consultation Total 1,980
Lilly 7/16/2018 Plan 175 1.80 315
Coonrod 7/16/2018 Plan 240 2.20 528
Coonrod 7/16/2018 Plan 240 0.70 168
Coonrod 7/17/2018 Plan 240 1.05 252
Coonrod 7/17/2018 Plan 240 1.15 276
Lilly 7/18/2018 Project 175 2.35 411
Coonrod 7/18/2018 Project 240 1.10 264
Coonrod 7/18/2018 Project 240 1.15 276
Coonrod 7/19/2018 Project 240 1.45 348
Coonrod 7/20/2018 Project 240 1.25 300
Coonrod 7/24/2018 Project 240 2.05 492
Coonrod 7/26/2018 Project 240 2.10 504
Coonrod 7/27/2018 Project 240 1.00 240
Roeger 7/30/2018 Project 220 1.10 242
Coonrod 7/31/2018 Project 240 1.75 420
Coonrod 7/31/2018 Project 240 0.80 192
Coonrod 7/31/2018 Project 240 1.00 240
Plan Total 6,468
Roeger 7/2/2018 Project 220 0.65 143
Roeger 7/2/2018 Project 220 1.90 418
Roeger 7/3/2018 Project 220 3.00 660
Roeger 7/5/2018 Project 220 0.70 154
Roeger 7/9/2018 Project 220 3.60 792
Coonrod 7/9/2018 Project 240 0.20 48
Roeger 7/11/2018 Project 220 2.50 550
Roeger 7/12/2018 Project 220 0.95 209
Roeger 7/12/2018 Project 220 1.20 264
Roeger 7/12/2018 Project 220 3.90 858
Roeger 7/2/2018 Project 220 5.00 1,100
Roeger 7/2/2018 Project 220 2.40 528
Roeger 7/3/2018 Project 220 0.55 121
Bahler 7/5/2018 Project 100 0.20 20
Coonrod 7/9/2018 Project 240 0.60 144
Project Total 6,009
Publishing&printing 0
Mileage 22
Prescribed by State Board of Accounts City Form No.201(Rev.1995)
VOUCHER NO. WARRANT NO.
ALLOWED 20 ACCOUNTSPAYABLE 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 un'ds,price per unit;etc.
INDIANAPOLIS, IN 46.240.
Payee
$7,994.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-073118 43-419.99 $7,994.00 1 hereby certify that the attached invoice(s),,or 8/1/18 1150-073118 $7,994.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
Tuesday,August 07,2018
Kibbe,Sharon
Executive Office Manager
1 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-7/31/208
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 1,2018
Professional services through 7/31/208,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-Utility statements,client-prepared letter of transmittal,immaterial
changes requested by audit team,corrections to letter of transmittal,audit adjustments to
utility statements,SBOA adjustment for immaterial net pension item,preparation and
travel to exit conference,response to C-T regarding GFOA filing
7,994
Total amount of this invoice. 7,994
Previous balance. $ 17,043
Payment received. -
Total amount due. $ 25,037
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
Lilly 7/17/2018 Work outside scope 175 4.05 709
Lilly 7/19/2018 Work outside scope 175 2.70 473
Coonrod 7/19/2018 Work outside scope 240 0.30 72
Coonrod 7/20/2018 Work outside scope 240 2.20 528
Lilly 7/22/2018' Work outside scope 175 5.35 936
Coonrod 7/22/2018 Work outside scope 240 1.05 252
Lilly 7/23/2018 Work outside scope 175 5.10 893
Coonrod 7/23/2018 Work outside scope 240 0.40 96
Lilly 7/24/2018 Work outside scope 175 1.95 341
Lilly 7/25/2018 Work outside scope 175 2.10 368
Coonrod 7/25/2018 Work outside scope 240 2.05 492
Lilly 7/26/2018 Work outside scope 175 3.60 630
Lilly 7/27/2018 175 4.45 779
Lilly 7/30/2018 175 2.30 403
Coonrod 7/31/2018 240 0.70 168
Lilly 7/31/2018 175 4.45 779
Bahler 7/31/2018 100 0.75 75
Work outside scope Total 7,994
Publishing&printing 0
Mileage 0
TOTAL invoice amount 7,994