HomeMy WebLinkAbout308938 03/07/17 �t t. CITY OF CARMEL, INDIANA VENDOR: 071300
ONE CIVIC SQUARE C. L.COONROD &COMPANY CHECK AMOUNT: $****20,905.00*
=Q CARMEL, INDIANA 46032 PO BOX 46247 CHECK NUMBER: 308938
INDIANAPOLIS IN 46226 CHECK DATE: 03/07/17
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION
1160 4340303 34499 0217D 14,978.00 ACCTG SERVICES FOR 20
1160 4340303 34499 0317A 5,927.00 ACCTG SERVICES FOR 20
Q n < «
/ � / � / � / v0 p b 2 r A 0
> k / k \
0 E k \
2
/ 2 0 § < k o O
/ to / g w 2 o
f > cr o -n # & f q
2 N) @ I
R R o O >
m 2
t t w -n > 2 k I
\ § $ § § § § k ] �
j S S 8 ^ ^ >q / D
CL 2
oa 2
I q q> - O
/ § \ \ \ q
CD § S S Z
to
J a $ 2 E_ � /
- ^ °
{ E §
§ g
% E g i / $ § m
m ¥ C o a -n Q
CD § Q k # ®
E E F F 7 # «
■
% E 2 / w [
O 7 + - C CD® @ % } g ID( � CD N §f
E § ff
7 k W 7
to k (D EP \ /
CD w w § J ƒ E
E - ± ƒ §
Z £ 2
0 7
\/ + e % M Q f 7
E% k k k 2 cl
0 cr
-
� w w w _ m k (
§ } E
f» # 7 > \
1 ) $ ■
) a _ 2 G § � \ CD
\
�ƒ / \ j e 2 3 k ƒ C E
) J > o ® - D ƒ 0 Z »
ro ° 0
} T
9E f 0
}$ ( / 7
0 >
0m
/
2
n D a °r- M 0
E # ± 2 E ] $ cCD
o o ■
Q § E @ 0 n
CD CLk 2 _CD M /
CO) G CD - OL ]
CD 0CD w CD
CL $ q # > CD /
k )
c l § . ®
w � $ 2 E f
/ 8 8 k
INVOICE
0217-D
P.O. Board of Works
City of Cannel
Attn:Sharon Kibbe
One Civic Square
Cannel,IN 46032
Make check payable to:
Tax ID#35-1985559
C.L.Coonrod&Company
3850 Priority Way South Drive,Suite 225
Indianapolis,Indiana 46240
February 27,2017
Professional services from February 20 through February 26,2017,in connection with:
2016 CAFR:
2016 Bonds 455
Accounts Payable $ 36
AR-Property Tax 48
AR-Ambulance 140
AR-Medicaid Supplemental 396
Budgetary Statements 101
Local Pensions 946
Net Investment in Capital Assets 84
OPEB 148
PERS Pensions 293
Response to Auditors 271
Setup Trial Balance 480
Statistical Section 61
Trust Cash 2,980
Subtotal. 6,439
Out of pocket expense-mileage -
Subtotal,work within the scope of our engagement letter dated January 17,2017.
($68,000) 6,439
Work outside scope-analysis of proposal for no OPEB actuarial report for 2016 CAFR,
respond to GASB questions regarding TIF,message requested by GASB regarding
GASB 77 applicability to TIF-conference call GASB:developer TIF's considered
abatement but not other TIF's,CCD fund trail balance out of balance by material amount,
follow up on problems with capital assets-email fix assets,trial balance,Barret law
surplus fund beginning trial balance out of balance,adjustment to worker comp fund,as
there were negative expenditures.
1,085
Total amount of this invoice. 7,524
Previous balance. 18,983
Payment received.
Total amount due. $ 26,507
Payable upon receipt. Call(317)844-4605 with questions.
City of Carmel
2016 CAFR Time Budget
REVISED 2/14/17
In Future
CLC BWR SLL ELH Total January February Total
Set up initial TB 240 1240 1480 956 480 1436
Trust cash 960 2640 620 4220 276 4641 4917
AR-property tax 240 700 940 599 599
AR-income tax 240 220 700 1160 473 473
AR-ambulance 240 220 460 140 140
AR-Medicaid supplemental 240 220 460 396 396
Capital assets 240 1400 1640 1483 1483
Capital leases 240 700 940 0 0
Accounts payable 240 220 1240 1700 388 3346 3734
Accrued wage 240 220 775 1235 469 469
Compensated absences 240 220 620 1080 84 272 356
Bond premium,deferred rev 240 2100 2340 1003 1003
Bond principal,debt disclosure 240 2100 2340 0
2016 bond issues 1920 2800 4720 132 1628 1760
Local pensions 720 1050 1770 787 787
PERS pensions 720 1400 2120 36 1564 1600
OPEB 720 2100 2820 48 148 196
Enterprise funds 3840 3840 60 0 60
GASB 77 0 0 0 0 0 348 888 1236
Net investment in capital assets 480 1050 1530 84 84
MD&A 480 1400 1880 814 814
Budgetary statements 240 2480 2720 101 101
Finalize and reconcile statements 2880 700 3580 0 0
GFOA checklist 1440 350 1790 0 0
Introductory section,CAFR prep 240 1050 1290 376 376
Statistical section 480 2100 2580 140 1075 1215
Responses to Auditors 3840 440 2800 310 7390 96 1147 1243
Total 21840 4400 24500 7285 58025 2564 21914 24478
Work outside of Scope 0 0 0 0 0 180 1849 2029
20%contingency 4368 880 4900 1457 11605
Total with contingency 26208 5280 29400 8742 69630 2564 21914 24478
Rates 250 230 175 155
Fees $ 26.208 $ 4.400 $ 24.500 $ 7.285 $ 62.393 $ 2,744 $ 23,763 $ 26"507
INVOICE
0217b
P.O.34499 Hon.James C.Brainard
Mayor,City of Carmel
Attn:Sharon Kibbe
One Civic Square
Carmel,IN 46032
Make check payable to:
Tax ID#36-1986569
C.L.Coonrod&Company
3860 Priority Way South Drive,Suite 226
Indianapolis,Indiana 46240
March 1,2017
Professional services from February 16 through February 28,2017,in connection with:
Additional Appropriation-preparation for meeting regarding transfer,meeting with 1,850
council member and CT office-follow up,draft amendment;emails form CT office,
respond,questions from Council member regarding additional appropriations ordinance
proposal,follow up on additional appropriation.
Annual Report-annual report matters,annual report follow up,cash balance matters. 1,001
Bond/Lease-information on new bonds,bond follow up items,LIT distribution follow 1,098
up,Financial Advisor questions regarding amount of COIT needed.
Budget Consultation-follow up with auditor,discuss with client,ordinance matters 1,445
Other Consulting-emails and phone calls with senior staff and City officials,insurance 2,025
discussions,meetings with Mayor.
Out of pocket expense-mileage 35
Total amount of this invoice. 7,454
Previous balance. 39,198
Payment received. (26,833)
Total amount due. $ 19,819
Payable upon receipt. Call(317)844-4605 with questions.
CITY OF CARMEL
March 1,2017
Professional services from February 16 through February 28,2017,in connection with:
Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor.
Performina Service Service Date Services Provided Hourly Rate Total
Coonrod 2/16/2017 Additional Appropriations 240 0.25 60
Coonrod 2/17/2017 Additional Appropriations 240 1.55 372
Coonrod 2/17/2017 Additional Appropriations 240 3.60 864
Coonrod 2/28/2017 Additional Appropriations 240 1.85 444
Roeger 2/28/2017 Additional Appropriations 220 0.50 110
Additional Appropriations Total 1,850
Roeger 2/20/2017 Annual Report 220 2.00 440
Roeger 2/27/2017 Annual Report 220 0.25 55
Roeger 2/27/2017 Annual Report 220 0.35 77
Roeger 2/28/2017 Annual Report 220 1.25 275
Roeger 2/28/2017 Annual Report 220 0.70 154
Annual Report Total 1,001
Lilly 2/27/2017 Bond/Lease 175 1.60 280
Roeger 2/27/2017 Bond/Lease 220 1.00 220
Roeger 2/27/2017 Bond/Lease 220 1.30 286
Coonrod 2/27/2017 Bond/Lease 240 0.30 72
Coonrod 2/28/2017 Bond/Lease 240 1.00 240
Bond/Lease Total 1,098
Lilly 2/16/2017 Budget Consultation 175 1.75 306
Lilly 2/16/2017 Budget Consultation 175 2.35 411
Lilly 2/17/2017 Budget Consultation 175 1.15 201
Roeger 2/17/2017 Budget Consultation 220 1.00 220
Lilly 2/23/2017 Budget Consultation 175 1.75 307
Budget Consultation Total 1,445
Engelking 2/16/2017 Other Consulting 150 1.00 150
Engelking 2/17/2017 Other Consulting 150 1.50 225
Engelking 2/20/2017 Other Consulting 150 1.50 225
Engelking 2/21/2017 Other Consulting 150 2.00 300
Engelking 2/22/2017 Other Consulting 150 1.00 150
Engelking 2/23/2017 Other Consulting 150 1.00 150
Engelking 2/23/2017 Other Consulting 150 2.00 300
Engelking 2/27/2017 Other Consulting 150 1.00 150
Engelking 2/28/2017 Other Consulting 150 2.50 375
Other Consulting Total 2,025
Publishing&printing 0
Mileage 35
INVOICE
0317-A
P.O. Board of Works
City of Carmel
Atm:Sharon Kibbe
One Civic Square
Carmel,fN 46032
Make check payable to:
Tax ID#35-1985559
C.L.Coonrod&Company
3850 Priority Way South Drive,Suite 225
Indianapolis,Indiana 46240
March 6,2017
Professional services from February 27 through March 5,2017,in connection with:
2016 CAFR:
2016 Bonds $ 1,395
Accounts Payable 185
AR-Income Tax 180
AR-Property Tax 18
AR-Ambulance 166
Bond Premium,Deferred Revenue 54
Enterprise Funds 240
GFOA Checklist 156
OPEB 120
PERS Pensions 525
Response to Auditors 312
Setup Trial Balance 466
Statistical Section 193
Trust Cash 1,617
Subtotal. 5,627
Out of pocket expense-mileage
Subtotal,work within the scope of our engagement letter dated January 17,2017.
($68,000) 5,627
Work outside scope-issues with format of utility statements,Storm water collections
data contradicts prior year,follow up on errors in Capital assets data,respond regarding
GAAP format of utility statements. 300
Total amount of this invoice. 5,927
Previous balance. 26,507
Payment received.
Total amount due. $ 32,434
Payable upon receipt. Call(317)844-4605 with questions.