HomeMy WebLinkAbout320408 01/11/18 CITY OF CARMEL, INDIANA VENDOR: 071300
.I;_ � :;• ONE CIVIC SQUARE C. L. COONROD & COMPANY CHECK AMOUNT: $****17,716.00*
?4 CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 320408
9M,�TON. SUITE 225 CHECK DATE: 01/11/18
INDIANAPOLIS IN 46240
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION
1160 4341999 101207 11-17-A 11,753.00 CAFR-RELATED ACCOUNTI
1160 4340303 101208 11173 5,963.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.
IN SUM OF$ - CITY OF CARMEL
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,1,753.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 11-17-A. 43419.99 $11,753.00 1 hereby certify that the attached invoice(s),or 12/28/17 11-1.7-A $11,753.00
1160 101 Prior Year 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,January 08,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
11-17-A
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
December 28,2017
Professional services from November 1 through November 30,2017,in connection with:
2016 CAFR:
Work outside scope-CAFR revisions with new capital assets,plan of action for
accounting for 2017 capital asset data,assist in preparing analyses needed to prepare for
audit committee,proposed utility adjustments for call waiver rights,resolve utility
statement audit issue regarding call rights waiver,rebalance statements and review after
utility audit adjustment,certificate of achievement application,rebalance statement due
to changes in lease numbers and capital assets,complete application for certificate of
achievement,changes in utility bond payable,utility leases and transmittal letter,follow
up on transmittal letter,review changes in capital leases and utility bonds payable,follow
up on GFOA application,respond to SBOA questions regarding capital assets,arrange for
actuarial studies for 2017,questions from SBOA regarding version revised for capital
assets and net investment in capital assets,final review after all revised data and letter of
transmittal provided.
11,753
Out of pocket expense-
Total amount of this invoice. 11,753
Previous balance. 45,983
Payment received.
Total amount due. $ 57,736
Payable upon receipt Call(317)8444605 with questions.
x m o 0 0 o ; T m o m D o v m 0 D o o o Q D o o 2 m
w m o o o c c D F' m 0. m�� rnna v �-iir nn
v9 v mID
g b' iA N i9 'z N w o.J m N m 8 = c M
CL �2 n N Yn' �i, 3 m
$ CCD e m N fes+ co yvc M.
J O-w D N i fD w LL w N C m 3 N N Q N to C y r03
3
C J x px1
m 2 �, � = S. 8 3 s N w �� c m
8 a �. 8 »� CD
2 m w Dn N f0 _n
`71 p1 e1, N G. N 7 i
A 0
y C �
(D N N
9 � N
IWp I� A IA OD A ? OOD A OAD
O w OO O O O A N N N NAA AAA A A AAAA W A In
O O O O O O O O O O O O O O O .00
0 0 O O 0000 O O
p AA pyo OO
{ IO co IO O O IO O 000 O co O p
I~ C IW O IW O W V A O A8 (C"DD V A V V I�
V O O O O O OI 0 O
O O N O O 0 O O O O O O O
In O O O O O O O O O O O O O O O O O O O 00
N A N W A 0 V N T N r
IV-, N IV O N IO O O O O O O
AV WO NW v WW Mo lW (O7D O (O OMD w W O AW co(� AN
AO
O n O O O O O O O 0 O O O O000 wo—
�
O O O O O 0 C A 0 O O 0 0 0 0 0 0 0 0
I� 10")
AWW0 I10 10 O O O O O O O O O 000 O O O 000 O O 0000 O O 3
N
A A co w Im
U O OOD I00 10 IO O O O O O O 0 O O O O 0 O O O 000 O O 0000 O O
I� IA N O K
W N IN IO 10 O O O O O O O O O O O O O O O 000 O O 0000 O O
N ID
O OA1 O
N {WJ110 10 O O O O O O O O O O O O 000 O O O O O 0000 O O
W b
g �
O O O 10 10 O O O O O 0 0 O 0 O O O 000 OOO 00 0000 O O
I0 IO
Ij OWO N ONO .�
tr A V 10 10 O O O O O O O O O O O O O O O O O O O O Coco O O O O
I
t` 2
to � IF+ I<
O f'' W Ln
10 10 O O O O O O O O O 000 OOO 0 0 0 00 O O O O O O
to CO M w
V _ NOw
IN
Im VI� � � � � � ��� ;�N �A �� ���m � g
VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995)
ALLOWED 20 ACCOUNTS PAYABLE VOUCHER .
Vendor# 071300
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
$5,963.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 1117B 43-403.03 $5,963.00 1 hereby certify that the attached invoice(s),or 12/28/17 1117B $5,963.00
1160 101 Prior Year 1160 101
bills)is(are)true and correct and that the
materials or services itemized thereon for
which charge is made were ordered and
received except
Monday,January 08,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
1117b
P.O.101208 Hon:James C.Brainard
Mayor,City of Carmel
Atm: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
December 28,2017
Professional services from November 16 through November 30,2017,in connection with:
Accounting System-property management expense issues for Mohawk Place. $ 264 "
Annexation-respond to question regarding Home Place impact,analysis of Home Place 252
impact.
Bond/Lease-follow up on bond closing matters,follow up on S&P responses regarding 1,026
GAAP statements.
Budget Consultation-accounting for expenditures related to rental property activity, 3,461
budget review,follow up on 2018 budget,.draft levy appeal petition,plan updates,respond
to question regarding funds,tax rate analysis.
Plan-review plan,follow up on CIP,GAAP projection. 960
Out of pocket expense--travel to meeting. -
Total amount of this invoice.. 5,963
Previous balance. 23,498..
Payment received: (8,068)
Total amount due. $ 21,393
Payable upon receipt. Call(317)844-4605 with questions.
CITY OF CARMEL
December 28,2017
Professional services from November 16 through November 30,2017, 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- -11/21/2017 . Accounting System 240 1.10 264
Accounting System Total 264
Coonrod 11/29/2017 Annexation 240 0:35, 84
Coonrod- 11/30/2017 Annexation 240 0.70 168 .
Annexation Total 252
Coonrod 11/16/2017 Bond/Lease 240 . 1.10 . 26.4:
Lilly - 11/29/2017 Bond/Lease 175- 9.90 332
Lilly 11/29%2017 Bond/Lease 175 2.25 394
Coonrod 11/29/2017 Bond/Lease 240 0.15 36
Bond/Lease Total 1,026
Roeger 11/21/2017 Budget Consultation 220 2.40 528
Roeger 11/21/2017 Budget Consultation 220 1.00 220
Coonrod 11/24/2017 Budget Consultation 240 1.00 . 24.0
Roeger 11/27/2017 Budget Consultation 220 2.10 462
Coonrod_ 11/27/2017 Budget Consultation -240 1:00 240
Roeger 11/28/2017 Budget Consultation 220 - 2.50 550
Coonrod 11/28/2017 Budget Consultation . .240 U5 , -- 132
Roeger 11/29/2017 Budget Consultation 220 2.70' 594
Roeger 11/30/2017 Budget Consultation 220 2.25 495
Budget Consultation Total 3,461
Coonrod 11/22/2017 Plan : 240, 1.00 240
Coonrod 11/27/2017 . Plan . 240 0.70 168
Coonrod 11/29%2017 Plan 240 2.00' 480
Coonrod 11/30/2017 Plan 240. .0.30- 72:
Plan Total 960
Publishing&printing-Pulication of adoption 0
Mileage 0
TOTAL invoice amount 5,963