HomeMy WebLinkAboutC. L. COONROD & COMPANY -001621 -2/17/2011 i CARMEL REDEVELOPMENT COMMISSION 001621
C. L. Coonrod & Company Check: 1622
56694 Caito Drive#120 Date: 2/17/2011
Indianapolis, IN 46226 Vendor: COONRA1
Prior
Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paic
CR0111a 14,391.00 14,391.00 0.00 0.00 14,391.0(
Accounting 1/1 thru 1/15/2011
CR0111b 24,319.00 24,319.00 0.00 0.00 24,319.0(
1/16- 1/31 2011
38,710.00 38,710.00 0.00 0.00 38,710.0C
INVOICE
CR0111b
Carmel Redevelopment Commission
Attn: Don Cleveland
30 West Main Street, Suite 220
Carmel, IN 46032
Make check payable to:
Tax ID#35-1985559
C.L.Coonrod&Company
5664 Caito Drive#120
Indianapolis, Indiana 46226
February 2, 2011
Professional services from January 16 through January 31, 2011, in connection with:
April 15, 1998, contract no. 0415.98.05, June 6, 2001, rider:
Current charges, see detail attached as required by contract.
Charges related to Fiscal Plan 6,096
Charges related to Accounting system 18,138
Travel 85
Total of this invoice. 24,319
Director of Redevelopment/ S 3 03d
Payable upon receipt. Call 317-562-4929 with any questions.
CITY OF CARMEL
February 2,2011
Professional services from January 16 through January 31,2011,in connedion with
Reins in accordance oils sector 5 1 0l Me connect and our November 28,2001,leirer to the Mayor
Person
Performing Service Hourly Hours
Service Date Services Provided Rate Worked Total
McKee 1 17 2011 Capital Project Planning,Accounting,Finance 105 6 58 691
Study CRC general ledger transactions
Roeger 1 17 2011 Capital Project Planning,Accounting,Finance 165 2 00 330
Review CRC balance sheet and updates
since 1/7 meeting. Prep for 1/21 meeting
Roeger 1 18 2011 Capital Project Planning,Accounting,Finance 165 0 85 141
Matters related to meeting on 1/21,work on
agenda
McKee 1 18 2011 Capital Project Planning,Accounting,Finance 105 601 632
Study CRC general ledger transactions
Roeger 1 18 2011 Capital Project Planning,Accounting,Finance 165 1 50 248
Discussion of CRC accounting issues
Roeger 1 18 2011 Capital Project Planning,Accounting,Finance 165 1 29 213
Matters related to PAC costs,balance sheet
Roeger 1 19 2011 Capital Project Planning,Accounting,Finance 165 3 00 495
Accounting related matters,prep for meeting
McKee 1 19 2011 Capital Project Planning,Accounting,Finance 105 7 36 773
Study CRC general ledger transactions
Roeger 1 19 2011 Capital Project Planning,Accounting,Finance 165 0.17 29
Accounting systm
Roeger 1 19 201 t Capital Project Planning,Accounting,Finance 165 2 73 451
Review CRC items,phone conversation with
Cleveland
Roeger 1 20 2011 Capital Project Planning,Accounting.Finance 165 4 50 743
Updates to balance sheet,prep for meeting
McKee 1 20 2011 Capital Project Planning,Accounting,Finance 105 4 68 492
Study CRC general ledger transactions
Roeger 1 21 2011 Capital Project Planning,Accounting,Finance 165 3 67 606
Attend meeting
Roeger 1 24 2011 Capital Project Planning,Accounting.Finance 165 0 50 83
Review balance sheet from Cleveland and
email from CLC about balance sheet
McKee 1 24 2011 Capital Project Planning,Accounting,Finance 105 1 02 108
Study CRC general ledger transactions
McKee 1 25 2011 Capital Project Planning,Accounting,Finance 105 0 75 79
Study CRC general ledger transactions
Roeger 1 25 201 I Capital Project Planning,Accounting,Finance 165 067 111
Conference with Cleveland to discuss CRC
balance sheet
Roeger 1 25 2011 Capital Project Planning,Accounting,Finance 165 0 33 55
Review email from Taylor,converse with
Cleveland about check from NBI account
Roeger 1 26 2011 Capital Project Planning,Accounting,Finance 165 0 79 131
Matters related to project cost reconciliation
Roeger 1 27 2011 Capital Project Planning,Accounting,Finance 165 0 84 139
Matters related to recording EC transaction,
follow up to meeting at CRC
McKee 1 27 2011 Capital Project Planning,Accounting,Finance 105 2 64 278
Study CRC general ledger transactions
Roeger 1 27 2011 Capital Project Planning,Accounting,Finance 165 2 33 385
Work on CRC accounting journal entries
Roeger 1 28 2011 Capital Project Planning,Accounting,Finance 165 1 29 213
Matters related to project cost reconciliation
McKee 1 28 2011 Capital Project Planning,Accounting,Finance 105 5 91 621
Study CRC general ledger transactions
Roeger 1 28 2011 Capital Project Planning,Accounting,Finance 165 2 72 449
Matters related to CRC balance sheet and
construction costs
Roeger 1 31 2011 Capital Project Planning,Accounting,Finance 165 3 02 499
follow up with Regions Bank and RE!
Meeting
Roeger 1 31 2011 Capital Project Planning,Accounting,Finance 165 2 50 413
Matters related to reconciling project cost
from balance sheet to other documents.
Follow up with board.
McKee 1 31 2011 Capital Project Planning,Accounting,Finance 105 2 16 227
Study CRC general ledger transactions
Coonrod 1 17 2011 Capital Project Planning,Accounting,Finance 215 0 51 110
Prep for meeting
Coonrod 1 18 2011 Capital Project Planning,Accounting,Finance 215 1 87 403
Review,prep for meeting
Coonrod 1 19 2011 Capital Project Planning,Accounting,Finance 215 4.13 888
Prep for meeting
Coonrod 1 20 2011 Capital Project Planning,Accounting,Finance 215 1 16 250
Look at balance sheet,support for fixed assets
Coonrod 1 20 2011 Capital Project Planning,Accounting,Finance 215 1 37 295
Review items for meeting
Coonrod 1 21 2011 Capital Project Planning,Accounting,Finance 215 6 01 1293
Meeting at CRC to resolve issues
Lilly 1 21 2011 Capital Project Planning,Accounting,Finance 143 5 89 843
Prep and attend meeting at CRC
Coonrod 1 24 2011 Capital Project Planning,Accounting,Finance 215 2 65 570
Audit
Lilly 1 26 2011 Capital Project Planning,Accounting,Finance 143 3 23 462
Coonrod,Anker and Heck regarding public
documents,review and create summary
explanation
Lilly 1 27 2011 Capital Project Planning,Accounting,Finance 143 3 42 490
Project costs,contracts and fiscal plan;
revisionof documents and review;work on
new analysis to compare all versions of PAC
costs in public realm
Coonrod 1 27 2011 Capital Project Planning,Accounting,Finance 215 2 54 547
Review progress
Coonrod 1 28 2011 Capital Project Planning,Accounting,Finance 215 1 20 258
Follow up on progress
Coonrod 1 28 2011 Capital Project Planning,Accounting,Finance 215 2 38 512
Energy center entry,other accounting
issues-prep report on progress
Coonrod 1 30 2011 Capital Project Planning,Accounting,Finance 215 1 01 218
Review progress
Coonrod 1 31 2011 Capital Project Planning,Accounting,Finance 215 4 39 944
Prep report
McKee 1 21 2011 Capital Project Planning,Accounting,Finance 105 4.00 420
Attend CRC meeting
Coonrod 1 17 2011 Capital Project Planning,Accounting,Finance 215 1 43 308
Review work
Lilly 1 17 2011 Capital Project Planning,Accounting,Finance 143 2 18 312
Discuss revision,further changes
Lilly 1 19 2011 Capital Project Planning,Accounting,Finance 143 3 31 474
Prep for meeting,work on plan update
Coonrod 1 19 2011 Capital Project Planning,Accounting,Finance 215 1 47 317
Plan
Lilly 1 20 2011 Capital Project Planning,Accounting,Finance 143 8 21 1175
Report for Mayor regarding PAC,
correspondence regarding TIF,plan,Pac
financing,etc.
Coonrod 1 20 2011 Capital Project Planning,Accounting,Finance 215 2 67 575
Brainard regarding debt questions WSJ
Lilly 1 24 2011 Capital Project Planning,Accounting,Finance 143 1 68 241
Reconciliation of project cost breakdowns,
°mails
Coonrod 1 25 2011 Capital Project Planning,Accounting,Finance 215 0 39 84
Review projection
Lilly 1 25 2011 Capital Project Planning,Accounting,Finance 143 1 57 225
Review old documents,palladium
Coonrod 1 26 2011 Capital Project Planning,Accounting,Finance 215 2 74 590
Plan
Coonrod 1 27 2011 Capital Project Planning,Accounting,Finance 215 0 56 121
Work on simplified versions of cost analysis
Lilly 1 28 2011 Capital Project Planning,Accounting,Finance t43 7 65 1094
Complete analysis including layman
versions,create new illustrated palladium
and performing arts center documents
Coonrod 1 28 2011 Capital Project Planning,Accounting,Finance 215 1 68 362
Review reconciliation of various public cost
lists-review projections update
Coonrod 1 30 2011 Capital Project Planning,Accounting,Finance 215 1 01 218
Review update
24,234
Travel 85
TOTAL invoice amount $24,319
INVOICE
CR0lila
Carmel Redevelopment Commission
Attn: Don Cleveland
30 West Main Street, Suite 220
Carmel, IN 46032
Make check payable to:
Tax ID#35-1985559
C.L.Coonrod&Company
5664 Caito Drive#120
Indianapolis, Indiana 46226
January 21, 2011
Professional services from January 1 through January 15, 2011, in connection with:
April 15, 1998, contract no. 0415. 98.05, June 6, 2001, rider:
Current charges, see detail attached as required by contract.
Charges related to Fiscal Plan 3,128
Charges related to Accounting system 11,263
Travel -
Total of this invoice. 14,391
Director of Redevelopment/ & '/ 96,0
Payable upon receipt. Call 317-562-4929 with any questions.
CITY OF CARMEL
January 21,2011
Professional services from January 1 through January 15,2011,in connection with
Rates in accordance wah Sensor 5 1 of the contract and cur November 28,2007,letter to the Meyer
Person
Performing Service Hourly Hours
Service Date Services Provided Rate Worked Total
McKee 1 3 2010 Capital Project Planning,Accounting,Finance 105 8 38 880
Study CRC general ledger transactions
Roeger 1 3 2010 Capital Project Planning,Accounting,Finance 165 3 25 537
Matters related to CRC financial statements
Roeger 1 3 2010 Capital Project Planning,Accounting,Finance 165 1 60 264
Review CRC financial statements. Review
Energy Center transaction
Roeger 1 4 2010 Capital Project Planning,Accounting,Finance 165 1 67 276
Discuss and review CRC accounting issues
McKee 1 4 2010 Capital Project Planning,Accounting,Finance 105 9 50 998
Study CRC general ledger transactions
Lilly 1 4 2010 Capital Project Planning,Accounting,Finance 143 3 17 454
Review and research transactions
Roeger 1 4 2010 Capital Project Planning,Accounting,Finance 165 0 68 113
Matters related to CRC sale of Energy Center
Roeger 1 4 2010 Capital Project Planning,Accounting,Finance 165 1 02 169
Review reimbursement JE with Don,review
payments to vendors for CRC items
Roeger 1 5 2010 Capital Project Planning,Accounting,Finance 165 1 35 223
Review JE in preparation of CRC audit
Roeger 1 5 2010 Capital Project Planning,Accounting,Finance 165 1 38 228
Discuss status of audit
McKee 1 5 2010 Capital Project Planning,Accounting,Finance 105 6,51 684
Study CRC general ledger transactions
Roeger 1 6 2010 Capital Project Planning,Accounting,Finance 165 1 50 248
Meet with Cleveland to discuss CRC matters
Roeger 1 6 2010 Capital Project Planning,Accounting,Finance 165 0 25 42
Matters related to CRC balance sheet
McKee 1 6 2010 Capital Project Planning,Accounting,Finance 105 5 18 544
Study CRC general ledger transactions
Roeger 1 7 2010 Capital Project Planning,Accounting,Finance 165 1 50 248
Meet with Cleveland to discuss accounting
for Oppenheimer accrued interest on
financial statements. Email to CLC
regarding Oppenheimer's accounting
McKee 1 10 2010 Capital Project Planning,Accounting,Finance 105 2 22 234
Draft email to Don and Mike regarding
issues found when reviewing general ledger
transactions
Roeger 1 10 2010 Capital Project Planning,Accounting,Finance 165 0 50 83
Discuss letter to Mike Lee and Don
Cleveland,energy sale
McKee 1 11 2010 Capital Project Planning,Accounting,Finance 105 1 26 133
Study CRC general ledger transactions
Lilly 1 11 2010 Capital Project Planning,Accounting.Finance 143 1 51 216
Matters related to PPBE list;search files
Roeger 1 12 2010 Capital Project Planning,Accounting,Finance 165 0 24 40
Accounting System
Roeger 1 12 2010 Capital Project Planning,Accounting,Finance 165 0.30 50
Work on CRC accounting issues
McKee 1 12 2010 Capital Project Planning,Accounting,Finance 105 1 21 128
Study CRC general ledger transactions
Roeger 1 13 2010 Capital Project Planning,Accounting,Finance 165 0 15 25
Review follow up items regarding Oppenheimer
Roeger 1 14 2010 Capital Project Planning,Accounting,Finance 165 0 50 83
CRC entries to balance sheet related to
Oppenheimer financing,MB line of credit
Roeger 1 14 2010 Capital Project Planning,Accounting,Finance 165 1 62 268
Discussion of CRC audit matters
McKee 1 14 2010 Capital Project Planning,Accounting,Finance 105 0 55 58
Study CRC general ledger transactions
Coonrod 1 4 2010 Capital Project Planning,Accounting,Finance 215 1 01 218
Review balance sheet,progress on audit
prep,prep for meeting with commission
member
Coonrod 1 5 2010 Capital Project Planning,Accounting,Finance 215 1,64 353
Review progress,prep for meeting with
commission member
Coonrod 1 6 2010 Capital Project Planning,Accounting,Finance 215 606 1303
Review progress,prep for meeting
Coonrod 1 7 2010 Capital Project Planning,Accounting,Finance 215 0 39 84
Oppenheimer balances
Coonrod 1 7 2010 Capital Protect Planning,Accounting,Finance 215 2 03 437
Meeting with commissioner,follow up
Coonrod 1 10 2010 Capital Project Planning,Accounting,Finance 215 045 97
Review email to staff
Coonrod 1 11 2010 Capital Project Planning,Accounting,Finance 215 0 57 123
Review progress
Coonrod 1 12 2010 Capital Project Planning,Accounting.Finance 215 2 17 467
Review unusual transactions-review progress
Coonrod 1 13 2010 Capital Project Planning,Accounting,Finance 215 2 51 540
$1.4 Oppenheimer transactions accounting
Coonrod 1 14 2010 Capital Project Planning,Accounting,Finance 215 1.93 415
Review progress,prep for meeting
McKee 1 7 2010 Capital Project Planning,Accounting,Finance 105 2 08 219
Efforts on CRC study of GL project
Lilly 1 6 2010 Capital Project Planning,Accounting,Finance 143 5 20 744
Review and update to fiscal plan;
correspondence with Carusillo,entry of
check register items,revise formula
Coonrod 1 11 2010 Capital Project Planning,Accounting,Finance 215 1 71 368
Review plan
Lilly 1 12 2010 Capital Project Planning,Accounting,Finance 143 6 26 896
Update fiscal plan,review items
Lilly 1 13 2010 Capital Project Planning,Accounting,Finance 143 4 52 647
Additional update items;correspondence
with Lee Worthley and Carussilo,transmittal
of plan and forecast
Lilly 1 14 2010 Capital Project Planning,Accounting,Finance 143 1 77 254
Follow up with Carssillo and Lee on items
transmitted and new 8M financing
14,391
Travel
TOTAL invoice amount $14,391