HomeMy WebLinkAbout258944 05/31/16 �0}_.4�gb
/ ,"� CITY OF CARMEL, INDIANA VENDOR: 071300
® ONE CIVIC SQUARE C L COONROD & COMPANY CHECK AMOUNT: $•"•*27,485.00`
�` a CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE 11225 CHECK NUMBER: 258944
.y,«eN��, INDIANAPOLIS IN 46240 CHECK DATE: 05/31/16
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION
1160 4340303 33612 041GB 4,159.00 ACCTG SERV SEE PO 334
1160 4340303 33612 041GC 16,262.00 ACCTG SERV SEE PO 334
1160 4340303 33612 051GA 7,064.00 ACCTG SERV SEE PO 334
VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995)
C L COONROD&COMPANY ALLOWED 20 ACCOUNTS PAYABLE VOUCHER
3850 PRIORITY WAY SOUTH DRIVE#225 IN SUM OF$ CITY OF CARMEL
An invoice or bill to be properly itemized must show:kind of service,where performed,dates service
INDIANAPOLIS, IN 46240 rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc.
$7,064.00 Payee
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
33612 0516a 43-403.03 $7,064.00 1 hereby certify that the attached invoice(s),or 5/23/16 0516a $7,064.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, May 24,2016
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
0516a
P.O.33612 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
May 23,2016
Professional services from April 28 through May 22,2016,in connection with:
Annexation-Home place court decision. $ 24
Bond/Lease-Plan related updates,size additional proposed bond,bond matters, 1,141
investigate lower debt service for bond than expected,size of proposed new issue,
updated coverage calculation on bond issuance,follow up on revenues from wheel tax,
update bond matters.
Budget Consultation-work on archiving files,scanning,emails;analysis of plan for 2,576
2017 budget,budget matters,update 2016-2017 budget comparison,budget matters,
preparation for 2017 budget,follow up on bank response questions,fund balance policy.
Cumulative Fund-Cumulative Fund items,review notice and ordinance,follow up on 1,615
re-establishment of CCD Fund rate,follow up on Cumulative Capital Development Fund
items,clerical check of re-establishment notice for the Times paper,emailing of notice,C-
T response to CCD ordinance phone call to legal department,receive email of notice to be
ran.
Plan-plan updates,review status preparation for meeting with client,plan related 1,703
updates,adjustments to plan for the Energy Center appropriation,preparation for 2017
budget,adjustments to plan,retiree health projections in fiscal plan.
Out of pocket expense- 5
Total amount of this invoice. 7,064
Previous balance. 10,847
Payment received. (6,688)
Total amount due. $ 11,223
Payable upon receipt. Call(317)844-4605 with questions.
CITY OF CARMEL
May 23,2016
Professional services from April 28 through May 22,2016, 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 5/19/2016 Annexation 240 0.10 24
Annexation Total 24
Roeger 4/29/2016 Bond/Lease 220 2.15 473
Coonrod 4/29/2016 Bond/Lease 240 0.25 60
Roeger 4/29/2016 Bond/Lease 220 0.50 110
Coonrod 4/29/2016 Bond/Lease 240 0.30 72
Coonrod 5/1/2016 Bond/Lease 240 0.05 12
Coonrod 5/2/2016 Bond/Lease 240 0.35 84
Roeger 5/2/2016 Bond/Lease 220 0.50 110
Roeger 5/2/2016 Bond/Lease 220 0.70 154
Roeger 5/3/2016 Bond/Lease 220 0.30 66
Bond/Lease Total 1,141
Roeger 4/29/2016 Budget Consultation 220 0.05 11
Lilly 5/5/2016 Budget Consultation 155 1.75 271
Coonrod 5/11/2016 Budget Consultation 240 1.00 240
Roeger 5/11/2016 Budget Consultation 220 0.95 209
Lilly 5/12/2016 Budget Consultation 155 1.75 271
Roeger 5/12/2016 Budget Consultation 220 1.15 253
Roeger 5/16/2016 Budget Consultation 220 0.55 121
Coonrod 5/16/2016 Budget Consultation 240 1.80 432
Lilly 5/19/2016 Budget Consultation 155 1.75 272
Roeger 5/19/2016 Budget Consultation 220 0.70 154
Coonrod 5/19/2016 Budget Consultation 240 0.05 12
Roeger 5/19/2016 Budget Consultation 220 0.50 110
Roeger 5/19/2016 Budget Consultation 220 1.00 220
Budget Consultation Total 2,576
Roeger 5/12/2016 Cumulative Fund 220 0.45 99
Coonrod 5/12/2016 Cumulative Fund 240 2.30 552
Roeger 5/16/2016 Cumulative Fund 220 1.10 242
Roeger 5/17/2016 Cumulative Fund 220 0.90 198
Hibler 5/17/2016 Cumulative Fund 80 0.20 16
Coonrod 5/17/2016 Cumulative Fund 240 2.10 504
Hibler 5/18/2016 Cumulative Fund 80 0.05 4
Cumulative Fund Total 1,615
Roeger 5/9/2016 Plan 220 0.45 99
Coonrod 5/9/2016 Plan 240 1.00 240
Roeger 5/9/2016 Plan 220 1.80 396
Roeger 5/9/2016 Plan 220 0.55 121
Hibler 5/12/2016 Plan 80 0.35 28
Coonrod 5/13/2016 Plan 240 1.22 293
Roeger 5/18/2016 Plan 220 0.25 55
Hibler 5/18/2016 Plan 80 0.25 20
Roeger 5/18/2016 Plan 220 0.50 110
Roeger 5/18/2016 Plan 220 1.55 341
Plan Total 1,703
Meal 0
Mileage 5
TOTAL invoice amount 7,064
VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201 (Rev.1995)
C L COONROD &COMPANY ALLOWED 20 ACCOUNTS PAYABLE VOUCHER
3850 PRIORITY WAY SOUTH DRIVE#225 IN SUM OF$ CITY OF CARMEL
An invoice or bill to be properly itemized must show:kind of service,where performed,dates service
INDIANAPOLIS, IN 46240 rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc.
$20,421.00 Payee
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
33612 0416b 43-403.03 $4,159.00 1 hereby certify that the attached invoice(s),or 4/29/16 0416b $4,159.00
1160 101 1160 101
33612 0416c 43-403.03 $16,262.00 bill(s)is(are)true and correct and that the 4/29/16 0416c $16,262.00
1160 101 materials or services itemized thereon for 1160 1 101
which charge is made were ordered and
received except
Wednesday, May 18,2016
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
20Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer
INVOICE
0416b Hon. James C. Brainard
P.O. 33612 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 29, 2016
Professional services from April 16 through April 28,2016, in connection with:
April 15, 1998, contract no. 0415.98.05; June 6, 2001, rider no. 0606.01.01:
Current charges, see detail attached as required by contract. $ 4,159
Total of this invoice. 4,159
Prior balance. 12,505
Payment received. (5,817)
Total due under April 15, 1998, contract. $ 10,847
Payable upon receipt. Call(317)844-4605 with any questions.
CITY OF CARMEL
April 29,2016
Professional services from April 16 through April 28,2016,in connection with:
Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor.
0100b
Performing Service Service Date Services Provided Hourly Rate Total
Coonrod 4/27/2016 Accounting System 240 0.65 156
Accounting System Total 156
Roeger 4/19/2016 Bond/Lease 220 1.80 396
Roeger 4/19/2016 Bond/Lease 220 3.05 671
Coonrod 4/19/2016 Bond/Lease 240 0.40 96
Roeger 4/27/2016 Bond/Lease 220 0.60 132
Roeger 4/27/2016 Bond/Lease 220 0.55 121
Coonrod 4/27/2016 Bond/Lease 240 1.70 408
Roeger 4/28/2016 Bond/Lease 220 0.60 132
Bond/Lease Total 1,956
Roeger 4/19/2016 Budget Consultation 220 0.50 110
Roeger 4/20/2016 Budget Consultation 220 1.00 220
Lilly 4/21/2016 155 1.75 271
Roeger 4/21/2016 Budget Consultation 220 1.15 253
Roeger 4/21/2016 Budget Consultation 220 0.15 33
Lilly 4/28/2016 155 1.75 272
Budget Consultation Total 1,159
Roeger 4/20/2016 Cash Management 220 0.70 154
Cash Management Total 154
Coonrod 4/19/2016 Internal Controls 240 1.15 276
Internal Controls Total 276
Roeger 4/28/2016 Plan 220 0.45 99
Hibler 4/28/2016 Plan 80 0.20 16
Hibler 4/28/2016 Plan 80 1.40 112
Roeger 4/28/2016 Plan 220 1.05 231
Plan Total 458
Meal 0
Mileage 0
TOTAL invoice amount 4,159
INVOICE
0416c Hon. Christine Pauley
P.O.33612 Clerk-Treasurer, 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 29,2016
Professional services from April 16 through April 28,2016, in connection with:
April 15, 1998,contract no.0415.98.05;June 6,2001, rider no. 0606.01.01:
Current charges,see detail attached as required by contract. $ 16,262
Total of this invoice. 16,262
Prior balance. 36,089
Payment received. (21,984)
Total due under April 15, 1998, contract. $ 30,367
Payable upon receipt. Call(317)844-4605 with any questions.
CITY OF CARMEL
April 29,2016
Professional services from April 16 through April 28,2016, 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 4/26/2016 Accounting System 240 0.40 96
Coonrod 4/27/2016 Accounting System 240 0.35 84
Accounting System Total 180
Roeger 4/26/2016 Budget Consulting 220 0.15 33
Budget Consulting Total 33
Lilly 4/14/2016 CAFR/GAAP 155 2.85 442
Lilly 4/18/2016 CAFR/GAAP 155 2.40 372
Roeger 4/18/2016 CAFR/GAAP 220 2.10 462
Hibler 4/18/2016 CAFR/GAAP 80 1.55 124
Roeger 4/18/2016 CAFR/GAAP 220 2.50 550
Roeger 4/18/2016 CAFR/GAAP 220 0.50 110
Coonrod 4/18/2016 CAFR/GAAP 240 2.35 564
Roeger 4/18/2016 CAFR/GAAP 220 0.40 88
Coonrod 4/18/2016 CAFR/GAAP 240 0.05 12
Coonrod 4/18/2016 CAFR/GAAP 240 0.05 12
Coonrod 4/18/2016 CAFR/GAAP 240 0.30 72
Coonrod 4/18/2016 CAFR/GAAP 240 0.05 12
Coonrod 4/18/2016 CAFR/GAAP 240 0.15 36
Lilly 4/19/2016 CAFR/GAAP 155 3.25 504
Roeger 4/19/2016 CAFR/GAAP 220 0.70 154
Hibler 4/19/2016 CAFR/GAAP 80 0.75 60
Coonrod 4/19/2016 CAFR/GAAP 240 0.35 84
Coonrod 4/19/2016 CAFR/GAAP 240 0.45 108
Coonrod 4/19/2016 CAFR/GAAP 240 0.10 24
Coonrod 4/19/2016 CAFR/GAAP 240 2.95 708
Lilly 4/20/2016 CAFR/GAAP 155 2.20 341
Roeger 4/20/2016 CAFR/GAAP 220 1.00 220
Hibler 4/20/2016 CAFR/GAAP 80 2.85 228
Hibler 4/20/2016 CAFR/GAAP 80 2.25 180
Roeger 4/20/2016 CAFR/GAAP 220 1.50 330
Coonrod 4/20/2016 CAFR/GAAP 240 0.10 24
Coonrod 4/20/2016 CAFR/GAAP 240 1.45 348
Coonrod 4/20/2016 CAFR/GAAP 240 0.35 84
Coonrod 4/20/2016 CAFR/GAAP 240 0.40 96
Coonrod 4/20/2016 CAFR/GAAP 240 1.40 336
Lilly 4/21/2016 CAFR/GAAP. 155 3.10 481
Hibler 4/21/2016 CAFR/GAAP 80 1.85 148
Coonrod 4/21/2016 CAFR/GAAP 240 0.80 192
Coonrod 4/21/2016 CAFR/GAAP 240 0.85 204
Lilly 4/22/2016 CAFR/GAAP 155 3.35 519
Roeger 4/22/2016 CAFR/GAAP 220 0.50 110
Coonrod 4/22/2016 CAFR/GAAP 240 0.90 216
Coonrod 4/22/2016 CAFR/GAAP 240 0.20 48
Coonrod 4/22/2016 CAFR/GAAP 240 0.65 156
Coonrod 4/22/2016 CAFR/GAAP 240 0.95 228
Coonrod 4/22/2016 CAFR/GAAP 240 0.30 72
Lilly 4/25/2016 CAFR/GAAP 155 3.60 558
Roeger 4/25/2016 CAFR/GAAP 220 0.20 44
Hibler 4/25/2016 CAFR/GAAP 80 1.35 108
Hibler 4/25/2016 CAFR/GAAP 80 1.95 156
Roeger 4/25/2016 CAFR/GAAP 220 0.50 110
Coonrod 4/25/2016 CAFR/GAAP 240 4.55 1,092
Lilly 4/26/2016 CAFR/GAAP 155 2.45 380
Coonrod 4/26/2016 CAFR/GAAP 240 0.95 228
Coonrod 4/26/2016 CAFR/GAAP 240 1.40 336
Coonrod 4/27/2016 CAFR/GAAP 240 1.60 384
Lilly 4/27/2016 CAFR/GAAP 155 1.90 295
Roeger 4/27/2016 CAFR/GAAP 220 0.50 110
Lilly 4/28/2016 CAFR/GAAP 155 3.00 464
Roeger 4/28/2016 CAFR/GAAP 220 0.85 187
Hibler 4/28/2016 CAFR/GAAP 80 0.85 68
Hibler 4/8/2016 CAFR/GAAP 80 0.70 56
Coonrod 4/28/2016 CAFR/GAAP 240 0.30 72
Coonrod 4/28/2016 CAFR/GAAP 240 0.10 24
Roeger 4/28/2016 CAFR/GAAP 220 0.30 66
Coonrod 4/28/2016 CAFR/GAAP 240 4.60 1,104
CAFR/GAAP Total 14,901
Coonrod 4/18/2016 Internal Controls 240 0.20 48
Internal Controls Total 48
Roeger 4/18/2016 Project 220 2.50 550
Roeger 4/21/2016 Project 220 2.00 440
Roeger 4/22/2016 Project 220 0.50 110
Project Total 1,100
Documentation/Meeting 0
Milage 0
TOTAL invoice amount 16,262