HomeMy WebLinkAboutC. L. COONROD & COMPANY -001715 -3/17/2011 .,,,nwicl.ntuEVELOPMENT COMMISSION 0 0 171 E
C. L. Coonrod & Company Check: 1715
56694 Caito Drive#120 Date: 3/17/2011
Indianapolis, IN 46226 Vendor: COONRA1
Prior
Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Pak
CR0211 a 9,148.00 9,148.00 0.00 0.00 9,148.01
Services 2/1 thru 2/15/2011
CR0211b 7,305.00 7,305.00 0.00 0.00 7,305.0(
through 2/28/11
16,453.00 16,453.00 0.00 0.00 16,453.00
...
•
INVOICE
CR0211a
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 18, 2011
Professional services from February 1 through February 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 5,155
Charges related to Accounting system 3, 993
Travel -
Total of this invoice. 9,148
Director of Redevelopment/F 3 G' 3 G 0
(IPA
Payable upon receipt. Call 317-562-4929 with any questions.
CITY OF CARMEL
February 18,2011
Professional services from February 1 through February 15,2011,in connection with
Rates in eccardance vnth Secban 5 1 of Me contract end cur November 2e,2007.utter to the Mayer
Person
Performing Service Hourly Hours
Service Date Services Provided Rate Worked Total
McKee 2 2 2011 Capital Project Planning,Accounting.Finance 105 0 82 87
Study CRC general ledger transactions
McKee 2 3 2011 Capital Project Planning,Accounting.Finance 105 0 49 52
Study CRC general ledger transactions
McKee 2 4 2011 Capital Project Planning,Accounting,Finance 105 0 75 79
Study CRC general ledger transactions
Roeger 2 7 2011 Capital Project Planning,Accounting,Finance 165 0 24 40
Review accounts payable,converse with
Cleveland
Roeger 2 8 2011 Capital Project Planning,Accounting,Finance 165 0 68 113
Matters related to accounts payable
McKee 2 8 2011 Capital Project Planning,Accounting,Finance 105 4.83 508
Study CRC general ledger transactions
Roeger 2 8 2011 Capital Project Planning,Accounting,Finance 165 1 89 312
Meet with Cleveland regarding accounts
payable,reconciliations
Roeger 2 9 2011 Capital Project Planning,Accounting,Finance 165 0 79 131
Work on AP reconciliation
Roeger 2 9 2011 Capital Project Planning,Accounting,Finance 165 0.78 129
Work on AP reconciliation
Roeger 2 10 2011 Capital Project Planning,Accounting,Finance 165 1 83 302
Work on AP reconciliation
Roeger 2 11 2011 Capital Project Planning,Accounting,Finance 165 0,38 63
CRC financial statements and accounts payable
Roeger 2 11 2011 Capital Project Planning,Accounting,Finance 165 1.15 190
CRC financial statements and accounts
payable
McKee 2 14 2011 Capital Project Planning,Accounting,Finance 105 1 29 136
Study CRC general ledger transactions
Roeger 2 14 2011 Capital Project Planning,Accounting,Finance 165 0 91 151
Work on matters related to Regions Bank
loan interest
Roeger 2 14 2011 Capital Project Planning,Accounting,Finance 165 1 13 187
Matters related to Regions Bank loan
interest,determine differences between
Regions calculated interest and CRC,review
balance sheet and accounts payable
Lilly 2 3 2011 Capital Project Planning,Accounting,Finance 143 0 42 61
PPBE needs for CAFR,check files
Roeger 2 7 2011 Capital Project Planning,Accounting,Finance 165 0 95 157
Review matters related to annual report
2010 CRC expenditures
Roeger 2 7 2011 Capital Project Planning,Accounting,Finance 165 0 76 126
Review 2009 annual report,expenditures
making up annual report
Roeger 2 7 2011 Capital Project Planning,Accounting,Finance 165 1 23 203
Matters related to schedule of debt on 2010 report
Roeger 2 8 2011 Capital Project Planning,Accounting,Finance 165 1 67 276
Matters related to schedule of debt on 2010
report
Roeger 2 11 2011 Capital Project Planning,Accounting,Finance 165 1 26 208
Review 2010 report,expenditures by CRC
Roeger 2 14 2011 Capital Project Planning,Accounting,Finance 165 0.78 129
Review balance sheet and statement of capital assets
Coonrod 2 10 2011 Capital Project Planning,Accounting,Finance 215 1 33 286
Follow up on progress
Coonrod 2 14 2011 Capital Project Planning,Accounting,Finance 215 0 31 67
Audit
Lilly 2 1 2011 Capital Project Planning,Accounting,Finance 143 2 30 329
Email from Haas,formulate calculations
from season fo annual,review
correspondence and notes
Lilly 2 3 2011 Capital Project Planning,Accounting,Finance 143 2 70 387
Add revised ticket projections,fiscal plan
update
Coonrod 2 3 2011 Capital Project Planning,Accounting,Finance 215 2.38 512
Review updates
Lilly 2 4 2011 Capital Project Planning,Accounting,Finance 143 2 07 297
Continue revisions to plan per client
meeting,Anker email,Lee regarding board
members
Coonrod 2 4 2011 Capital Project Planning,Accounting,Finance 215 1 50 323
Updates
Lilly 2 7 2011 Capital Project Planning,Accounting,Finance 143 065 93
Review emails,discuss
Coonrod 2 7 2011 Capital Project Planning,Accounting,Finance 215 0 50 108
Updates
Lilly 2 8 2011 Capital Project Planning,Accounting,Finance 143 2 39 342
Go over parking estimates,other revisions
Coonrod 2 8 2011 Capital Project Planning,Accounting,Finance 215 034 74
Parking revenue
Lilly 2 11 2011 Capital Project Planning,Accounting,Finance 143 2 83 405
Document and prepare forecast for packet,
correspondence with client and LWG
Coonrod 2 11 2011 Capital Project Planning,Accounting,Finance 215 4 37 940
Emails regarding debt disclosure,review
drafts at Mayor's request
Coonrod 2 14 2011 Capital Project Planning,Accounting,Finance 215 1 07 231
Updates
Coonrod 2 14 2011 Capital Project Planning,Accounting,Finance 215 2.46 529
Debt disclosure
Coonrod 2 15 2011 Capital Project Planning,Accounting,Finance 215 2 72 585
Update plan,follow up,review
9,148
Travel
TOTAL invoice amount $ 9,148
•
INVOICE
CR0211b
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
March 2, 2011
Professional services from February 16 through February 28, 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 846
Charges related to Accounting system 6,447
Travel 12
Total of this invoice. 7,305
Director of Redevelopment l g3 'O.3679
Payable upon receipt. Call 317-562-4929 with any questions.
Carmel Redevelopment Commission
March 2,2011
Professional services from February 16 through February 28,2011,in connection with
Reins,n scadence win Section 5 t of the wnract aM our No ember 2e,2007,fetter to the Mayor
Person
Performing Service Hourly Hours
Service Date Services Provided Rate Worked Total
Roeger 2 16 2011 Capital Project Planning,Accounting,Finance 165 150 248
Matters related to follow up from 1131 email
to Carolyn. Review Regions documents
McKee 2 16 2011 Capital Project Planning,Accounting,Finance 105 0 75 79
Study CRC general ledger transactions
McKee 2 17 2011 Capital Project Planning,Accounting,Finance 105 3 93 413
Study CRC general ledger transactions
McKee 2 18 2011 Capital Project Planning,Accounting,Finance 105 3 67 386
Study CRC general ledger transactions
McKee 2 21 2011 Capital Project Planning,Accounting,Finance 105 2 08 219
Study CRC general ledger transactions
Lilly 2 22 2011 Capital Project Planning,Accounting,Finance 143 2 46 352
Schedule of assets;correspondence
Roeger 2 22 2011 Capital Project Planning,Accounting,Finance 165 2 50 413
Matters related to Annual Report and review
of schedule of assets
McKee 2 22 2011 Capital Project Planning,Accounting,Finance 105 0 57 60
Study CRC general ledger transactions
McKee 2 23 2011 Capital Project Planning,Accounting,Finance 105 0 17 18
Study CRC general ledger transactions
McKee 2 24 2011 Capital Project Planning,Accounting,Finance 105 3 38 355
Study CRC general ledger transactions
Roeger 2 24 2011 Capital Project Planning,Accounting,Finance 165 2.00 330
Matters related to reimbursements to CRC
from 4CDC,review Energy Center
transaction to determine how proceeds were
spent
Lilly 2 24 2011 Capital Project Planning,Accounting,Finance 143 2 21 317
Assist with accounting procedures and
documents
Coonrod 2 24 2011 Capital Project Planning,Accounting,Finance 215 1 19 256
Asset schedule
McKee 2 25 2011 Capital Project Planning,Accounting.Finance 105 1 54 162
Study CRC general ledger transactions
McKee 2 28 2011 Capital Project Planning,Accounting,Finance 105 0 36 38
Study CRC general ledger transactions
Roeger 2 25 2011 Capital Project Planning,Accounting,Finance 165 3 50 578
Review matters related to CRC schedule and
Capital assets
Roeger 2 25 2011 Capital Project Planning,Accounting,Finance 165 3 00 495
Review emails about annual report,
schedule of assets,calculate 2010 CRC
assets
Coonrod 2 25 2011 Capital Project Planning,Accounting,Finance 215 1.84 396
Fixed assets listing,questions about basis
of accounting
Roeger 2 28 2011 Capital Project Planning,Accounting,Finance 165 067 111
Matters related to annual report preparation
Coonrod 2 16 2011 Capital Project Planning,Accounting,Finance 215 1 17 252
Progress on prep,phone regarding entrance
conference
Coonrod 2 24 2011 Capital Project Planning,Accounting,Finance 215 0 23 50
Discuss progress
Coonrod 2 28 2011 Capital Project Planning,Accounting,Finance 215 0.21 46
Schedule of capital assets
Roeger 2 21 2011 Capital Project Planning,Accounting,Finance 165 1 00 165
Matters related to Energy Center sale proceeds
McKee 2 21 2011 Capital Project Planning,Accounting,Finance 105 1 00 105
Create summary of use of energy center
proceeds per BWR
McKee 2 22 2011 Capital Project Planning,Accounting,Finance 105 0 28 30
Continue to create summary of energy
center proceeds per BWR
McKee 2 24 2011 Capital Project Planning,Accounting,Finance 105 1 41 149
Schedule of capital assets
McKee 2 24 2011 Capital Project Planning,Accounting,Finance 105 0 89 94
Use of energy center proceeds
McKee 2 25 2011 Capital Project Planning,Accounting,Finance 105 1.32 139
Use of energy center proceeds
McKee 2 25 2011 Capital Project Planning,Accounting,Finance 105 1.81 191
Schedule of capital assets
Coonrod 2 16 2011 Capital Project Planning,Accounting,Finance 215 1 50 323
Follow up on report regarding line of credit
and$10 million Regions
Coonrod 2 17 2011 Capital Project Planning,Accounting,Finance 215 0 50 108
Fiscal Plan
Lilly 2 18 2011 Capital Project Planning,Accounting,Finance 143 2 52 361
Fiscal Plan
Coonrod 2 21 2011 Capital Project Planning,Accounting,Finance 215 0 25 54
Fiscal Plan
7,293
Travel 12
TOTAL invoice amount $ 7,305