HomeMy WebLinkAbout309961 04/10/17 CITY OF CARMEL, INDIANA VENDOR: 071300
ONE CIVIC SQUARE C. L. COONROD&COMPANY CHECK AMOUNT: 10,499.00*
CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 309961
SUITE 225
INDIANAPOLIS IN 46240 CHECK DATE: 04/10/17
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION
1160 4340303 100303 0317D 10,499.00 ACCOUNTING SERVICES
G
N P n D CD O
p C o r o C7
m o Z Z N 0 0
rn w� 0 n pv v' � � � Z
o w � �{ pU w O
-G o
OGn z 9 o
n z4 40?I Ze. 0
a y s�'v 'o Nc. S
� n O '0
v0
p0 t _ Z[, A
p jo
ro
n
w Z
m.
0 3
a � �
o O O
0
r N yi 6
m < y N
? N y
fD
-4 �p� N N
CD 3 c, m
o n asyi (D m o
, o
CD o o- `� W
O CL ? o °o
)
a o0 a
o v
N O a0 CD cr
CD
3 N m m
<o m o a
w
v
a p
3 a
0
CDD
°-� o C O -oil oo.
0 o'
o o
CD
O -
o .- In m o
q
CD
m ✓
1 03 p
Q O 7s
N $ o -
co
n.
G
tD
INVOICE
0317-D
P.O. 100303 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
March 29,2017
Professional services from March 20 through March 26,2017,in connection with:
2016 CAFR:
2016 Bonds $ 1,333
AR-Income Tax 149
AR-Property Tax 149
AR-Medicaid Supplemental 258
Bond Principal,Debt Disclosure 846
Bond Premium,Deferred Revenue 1,165
Budgetary Statements 667
Capital Leases 124
Enterprise Funds 438
Finalize and Reconcile Statements 1,080
Compensated Absences 271
GASB 77-Abatement Disclosures 169
Local Pensions 289
MD&A 446
Introductory Section,CAFR Prep 26
PERS Pensions 472
Trust Cash 8
Subtotal. 7,890
Out of pocket expense-mileage -
Subtotal,work within the scope of our engagement letter dated January 17,2017.
($68,000) 7,890
Work outside scope-public records requests,capital assets discrepancies,actuary
deadline and follow up,bank statements follow up,follow up on public records requests-
follow up on capital assets need for revisions-follow up on actuary deadline,email bank
regarding statements,follow up on late actuary and capital assets reports-follow up on
public records request-obtain bank statements for capital lease fund,additional public
records request,receive phone call form C-T office regarding 2015 CAFR,follow up on
CT refusal to provide public records-public record regarding investment disclosure-CT
questions regarding transmittal letter 2015 CAFR,communicate with utility accountants
regarding net investment calculation and economic gain from refunding calculation-CT
office issues regarding 2015 transmittal letter,investigate and respond to CT regarding
"forged"signature,message from CT regarding 2015 CAFR signature issue.
2,609
Total amount of this invoice. 10,499
Previous balance. 36,888
Payment received. 13,451
Total amount due. $ 33,936
Payable upon receipt Call(317)844-4605 with questions.
City of Carmel
2016 CAFR Time Budget
Total in
CLC BWR SLL ELH Total January February March Future
Set up initial TB 240 1240 1480 956 480 1017 2453
0
Trust cash 960 2640 620 4220 276 4641 2887 7804
0
AR-property tax 240 700 940 0 599 419 1018
AR-income tax 240 220 700 1160 0 473 976 1449
AR-ambulance 240 220 460 0 140 464 604
AR-medicaid supplemental 240 220 460 0 396 282 678
Capital assets 240 1400 1640 0 1483 280 1763
Capital leases 240 700 940 0 0 124 124
Accounts payable 240 220 1240 1700 388 3346 185 3919
Accrued wage 240 220 775 1235 0 469 35 504
Compensated absenses 240 220 620 1080 84 272 490 846
Bond premium,deferred rev 240 2100 2340 0 1003 1219 2222
Bond principal,debt disclosure 240 2100 2340 0 0 1030 1030
2016 bond issues 1920 2800 4720 132 1628 4060 5820
Local pensions 720 1050 1770 0 787 837 1624
PERS pensions 720 1400 2120 36 1564 2776 4376
OPER 720 2100 2820 48 148 2615 2811
Enterprise funds 3840 3840 60 0 686 746
GASB 77 0 0 0 0 0 348 888 1331 2567
Net investment in capital assets 480 1050 1530 0 84 0 84
MDBA 480 1400 1880 0 814 446 1260
Budgetary statements 240 2480 2720 0 101 1912 2013
Finalize and reconcile statements 2880 700 3580 0 0 1080 1080
GFOA checklist 1440 350 1790 0 0 155 155
Introductory section,CAFR prep 240 1050 1290 0 376 586 962
Statistical section 480 2100 2580 140 1075 193 1408
Responses to Auditors 3840 440 2800 310 7390 96 1147 312 1555
Total 21840 4400 24500 7285 58025 2564 21914 26397 50875
Work outside of Scope 0 0 0 0 0 180 1849 6219 8248
20%contingency 4368 880 4900 1457 11605
Total with contingency 26208 5280 29400 8742 69630 2744 23763 32616 59123
Rates 250 230 175 155 197.71 192.56 243.35 198.64 214.14
Hours 104.83 22.96 168.00 56.40 352.19 14.25 97.65 164.20 276.10