The URL can be used to link to this page

Home My WebLink AboutC. L. COONROD & COMPANY -001549 -1/27/2011 CARMEL REDEVELOPMENT COMMISSION 001549 C. L. Coonrod & Company Check: 1549 56694 Caito Drive#120 Date: 1/27/2011 Indianapolis, IN 46226 Vendor: COONRA1 Prior Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paic CR1210A 12,389.00 12,389.00 0.00 0.00 12,389.0( Services 12.1 thru 12.15.2010 CR1210b 11,362.00 11,362.00 0.00 0.00 11,362.0( Services 12/16 thru 12/31/2010 23,751.00 . 23,751.00 0.00 0.00 23,751.00 INVOICE CR1210b 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.Coon rod&Company 5664 Caito Drive#120 Indianapolis,Indiana 46226 January 4, 2010 Professional services from December 16 through December 31, 2010, 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 4CDC $ 198 Charges related to Fiscal Plan 879 Charges related to Accounting system 10,285 Travel - Total of this invoice. 11,362 Payable upon receipt. Call 317-562-4929 with any questions. Director of Redevelopment 3 9 G C/C/ rt CITY OF CARMEL January 4,2010 Professional services from December 16 through December 31,2010,in connection with: Rates In ecco.nca vim Sedlon 51 d a,e tuned and our Novena 28,2007,I,M to.Meyer Person Performing Service Hourly Hours k_rac± ServiCee Provided Rate Worked Total Roeger 12 16 2010 Capital Project Planning,Accounting,Finance 165 0.18 30 Review matters related to parking revenue Roeger 12 16 2010 Capital Project Planning.Accounting,Finance 165 0.93 154 Review matters related to Energy Center and Journal Entry recording Roeger 12 16 2010 Capital Project Planning,Accounting,Finance 165 1.36 225 Audit pep,review payments made to contractors as shown on CRC balance sheet. Ensure balance sheet is current Roeger 12 17 2010 Capital Project Planning,Accounting,Finance 165 1.95 322 Matters related to contractor payments and Journal entry recording Lilly 12 17 2010 Capital Project Planning,Amounting,Finance 143 1.49 214 Lee regarding trustee info and TIF allocation,follow up Roeger 12 17 2010 Capital Project Planning,Accounting,Finance 165 0.50 83 Email to Cleveland about retainage payable, review on balance sheet and ledger McKee 12 17 2010 Capital Project Planning,Accounting,Finance 85 0.82 70 Study CRC general ledger transactions Roeger 12 17 2010 Capital Project Planning,Accounting,Finance 165 1.83 302 Meet with Cleveland to discuss balance sheet,update balance sheet to Mellow,NB/ accounts McKee 12 20 2010 Capital Project Planning,Accounting,Finance 85 1.48 126 Study CRC general ledger transactions Roeger 12 21 2010 Capital Project Planning,Accounting,Finance 165 1.83 302 Review spreadsheet regarding payables made on IPC,review agreements to determine if land purchases are authorized McKee 12 21 2010 Capital Project Planning,Accounting,Finance 85 5.58 475 Study CRC general ledger transactions Roeger 12 21 2010 Capital Project Planning,Accounting,Finance 165 2.83 467 Meet with Cleveland to discuss matters related to payables to vendors.Review ledger payable to vendors,email to Cleveland McKee 12 22 2010 Capital Project Planning,Accounting.Finance 85 4.11 350 Study CRC general ledger transactions Roager 12 22 2010 Capital Project Planning,Accounting,Finance 165 2 24 370 Review previous and current payments made to vendors Roeger 12 22 2010 Capital Project Planning,Accounting,Finance 165 1.20 198 Review and revise!CDC balance sheet, update with info from REI regarding invoices Roeger 12 22 2010 Capital Project Planning.Accounting,Finance 185 1 00 165 Most with Cleveland to discuss accounts payabldmtainage payable to contractors Roeger 12 23 2010 Capital Project Planning,Accounting,Finance 165 2.14 354 Review CRC accounting transactions McKee 12 23 2010 Capital Project Planning,Accounting.Finance 85 5.78 492 Study CRC general ledger transactions Lilly 12 27 2010 Capital Project Planning,Accounting,Finance 143 1.68 241 Review installment purchase contracts Roeger 12 27 2010 Capital Project Planning,Accounting,Finance 165 1.98 327 Work on matters preparing for CRC audit Reivew bank statements,reimbursements made to CRC from installment purchase contracts McKee 12 28 2010 Capital Project Planning,Accounting,Finance 85 5.69 484 Study CRC general ledger transactions McKee 12 29 2010 Capital Project Planning,Accounting,Finance 85 8.17 695 Study CRC general ledger transactions Lilly 12 29 2010 Capital Project Planning,Accounting,Finance 143 2 69 385 Ledger transactions and implementation of controls McKee 12 30 2010 Capital Project Planning,Accounting,Finance 85 7.60 646 Study CRC general lodger transactions Roeger 12 31 2010 Capital Project Planning,Accounting,Finance 165 1.00 165 Discuss and review matters related to audit, payments made for installment purchase contracts Coonrod 12 17 2010 Capital Project Planning,Accounting,Finance 215 1 62 349 Follow up on audit progress Coonrod 12 17 2010 Capital Project Planning,Accounting,Finance 215 0.43 93 Review audit progress Coonrod 12 17 2010 Capital Project Planning,Accounting,Finance 215 0.83 179 SBOA memo Coonrod 12 20 2010 Capital Project Planning,Accounting,Finance 215 0.79 170 • Review audit progress Coonrod 12 21 2010 Capital Project Planning,Accounting,Finance 215 1.43 308 Audit prep,report to commission Idly 12 21 2010 Capital Project Planning,Accounting.Finance 143 1.18 169 Commission report Coonrod 12 22 2010 Capital Project Planning,Accounting,Finance 215 1.02 220 Audit prep-follow up on report to commission-progress Coonrod 12 22 2010 Capital Project Planning,Accounting.Finance 215 3 01 648 Follow up on auditable records project,review individual transactions Coonrod 12 28 2010 Capital Project Planning,Accounting,Finance 215 0.96 207 Review audit progress Coor rod 12 30 2010 Capital Project Planning,Accounting,Finance 215 1.24 267 Review audit progress Coonrod 12 31 2010 Capital Project Planning,Accounting,Finance 215 1.07 231 Review regions agreement filly 12 16 2010 Capital Project Planning,Accounting,Finance 143 2.21 317 Follow up on fiscal plan items Coonrod 12 20 2010 Capital Project Planning,Accounting,Finance 215 0.20 43 Fiscal plan Ully 12 23 2010 Capital Project Planning,Accounting,Finance 143 2 81 402 Heidi Amsbaugh at Umbaugh regarding TIF breakdown,revise Coonrod 12 27 2010 Capital Project Planning,Accounting,Finance 215 0.54 117 Follow up on plan updates 11,362 Travel TOTAL invoice amount $11,362 INVOICE CR1210a 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 December 21, 2010 Professional services from December 1 through December 15, 2010, 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 4CDC $ 3,036 Charges related to Fiscal Plan 3,203 Charges related to Accounting system 6,150 Travel - Total of this invoice. 12,389 Director of Redevelopment / 3 6-16' Payable upon receipt. Call 317-562-4929 with any questions. ioIoG CITY OF CARMEL December 21,2010 Professional services from December 1 through December 15,2010,in connection with Rates in accordance rxth Section 5 1 of the content and our Nosember 28,2007,letter to the Mayo Person Performing Service Hourly Hours Service Date Services Provided Rate Worked Total McKee 12 1 2010 Capital Project Planning,Accounting,Finance 85 0.58 50 Audit of CRC ledger and email to Lee regarding questions McKee 12 I 2010 Capital Project Planning,Accounting,Finance 85 2 18 186 Review energy center transaction and develop JE McKee 12 2 2010 Capital Project Planning,Accounting,Finance 85 044 38 Review energy center transaction and develop JE Roeger 12 3 2010 Capital Project Planning,Accounting,Finance 165 2.00 330 Conference w/Cleveland to discuss LCB account balance,review materials Roeger 12 3 2010 Capital Project Planning,Accounting,Finance 165 1 00 165 Review and discuss CRC audit matters McKee 12 3 2010 Capital Project Planning,Accounting,Finance 85 3 28 279 Study CRC general ledger transactions Roeger 12 3 2010 Capital Project Planning,Accounting,Finance 165 0.17 29 Work on 4CDC statement and balance Coonrod 12 3 2010 Capital Project Planning,Accounting,Finance 215 097 209 4CDC review status and latest balance sheet Coonrod 12 6 2010 Capital Project Planning,Accounting,Finance 215 0.48 104 4CDC energy transaction Roeger 12 6 2010 Capital Project Planning,Accounting,Finance 165 1 00 165 Review 4CDC balance sheet and revise for meeting w/board members McKee 12 6 2010 Capital Project Planning,Accounting,Finance 85 0 38 33 Study CRC general ledger transactions Roeger 12 6 2010 Capital Project Planning,Accounting,Finance 165 5 00 825 SLL notes on issues w/CRC transactions. Discuss matters with Cleveland regarding audit matters Roeger 12 7 2010 Capital Project Planning,Accounting,Finance 165 2 33 385 Review 4CDC balance sheet and prep for meeting. Roeger 12 7 2010 Capital Project Planning,Accounting,Finance 165 0.47 78 Work on creating JE to show energy sale on behalf of CRC McKee 12 7 2010 Capital Project Planning,Accounting,Finance 85 0 80 68 Audit of CRC general ledger transactions Roeger 12 7 2010 Capital Project Planning,Accounting,Finance 165 0 05 9 Review CRC energy center transaction Coonrod 12 7 2010 Capital Project Planning,Accounting,Finance 215 1 51 325 4CDC prep for meeting,meeting with Carter Roeger 12 7 2010 Capital Project Planning,Accounting,Finance 165 1 00 165 Meeting w/Cleveland to discuss accounting for Energy Center sale,Oppenheimer funding Roeger 12 7 2010 Capital Project Planning,Accounting,Finance 165 0.47 78 Work on return email to London Witte regarding Energy Center proceeds McKee 12 8 2010 Capital Project Planning,Accounting,Finance 85 1.82 155 Study CRC general ledger transactions Roeger 12 8 2010 Capital Project Planning,Accounting,Finance 165 1.50 248 Matters related to 4CDC balance sheet Roeger 12 8 2010 Capital Project Planning,Accounting,Finance 165 0 25 42 Meet w/Taylor to discuss 4CDC statements Roeger 12 9 2010 Capital Project Planning,Accounting,Finance 165 1.71 283 Review EC sale transaction. Determine how to record transaction for accounting purposes. Review CRC cash accounts Roeger 12 10 2010 Capital Project Planning,Accounting,Finance 165 0 39 65 Matters related to CRC financial statements McKee 12 10 2010 Capital Project Planning,Accounting,Finance 85 0 52 45 Review EC transaction and JE from Ben Roeger 12 10 2010 Capital Project Planning,Accounting,Finance 165 0 86 142 Recording of JE associated w/EC sale Roeger 12 13 2010 Capital Project Planning,Accounting,Finance 165 0 53 88 Preparation of 4CDC financial statements Roeger 12 13 2010 Capital Project Planning,Accounting,Finance 165 2 33 385 Work on 4CDC statements. Financing and change orders Roeger 12 13 2010 Capital Project Planning,Accounting,Finance 165 1 43 236 Review Oppenheimer and EC transactions Roeger 12 14 2010 Capital Project Planning,Accounting,Finance 165 0 17 29 Review 4CDC invoice payments for October Roeger 12 14 2010 Capital Project Planning,Accounting,Finance 165 0 91 151 Review CRC balance sheet account related documentation Roeger 12 14 2010 Capital Project Planning,Accounting,Finance 165 1 33 220 Review JE and documents related to EC sale. Prepare JE for 4CDC Roeger 12 14 2010 Capital Project Planning,Accounting,Finance 165 2 00 330 Prepare for and attend 4CDC meeting Roeger 12 14 2010 Capital Project Planning,Accounting,Finance 165 1 50 248 Review documentation associated w/ proposed LCB finacing for 4CDC. Emails to Teresa and Mike regarding 2011 budget and proposed LCB financing Roeger 12 15 2010 Capital Project Planning,Accounting,Finance 165 1 50 248 Meeting w/Cleveland to discuss CRC accounting issues associated w/EC. Travel to and attend meeting Roeger 12 15 2010 Capital Project Planning,Accounting,Finance 165 1 38 228 Matters related to accounting for Oppenheimer transactions Roeger 12 15 2010 Capital Project Planning,Accounting,Finance 165 1.00 165 Matters related to CRC accounting.Oppenheimer transactions Coonrod 12 15 2010 Capital Project Planning,Accounting,Finance 215 0 78 168 4CDC EC transaction entries Roeger 12 15 2010 Capital Project Planning,Accounting,Finance 165 3.00 495 Matters related to CRC Energy sale. Oppenheimer documents in preparation for audit. Coonrod 12 2 2010 Capital Project Planning,Accounting,Finance 215 0 05 11 Phone call with Carter regarding meeting to review audit progress Coonrod 12 3 2010 Capital Project Planning,Accounting,Finance 215 1 24 267 Review progress,prep for meeting with Carter Coonrod 12 3 2010 Capital Project Planning,Accounting,Finance 215 1 74 375 Audit Coonrod 12 3 2010 Capital Probed Planning,Accounting,Finance 215 0 57 123 Follow up on progress and report Coonrod 12 3 2010 Capital Project Planning,Accounting,Finance 215 1 01 218 Prep for meeting with Carter Coonrod 12 7 2010 Capital Project Planning,Accounting,Finance 215 1 51 325 Prep for and attend meeting with Carter Coonrod 12 15 2010 Capital Project Planning,Accounting,Finance 215 0 96 207 Review progress Clerical 12 7 2010 Capital Project Planning,Accounting,Finance 70 0 50 35 Prepare outline for CLC meeting Genoa! 12 7 2010 Capital Project Planning,Accounting,Finance 70 0 25 18 Format worksheet for BWR meeting Clencal 12 7 2010 Capital Project Planning,Accounting,Finance 70 0.42 30 Review and compare Umbaugh report to budget Clencal 12 7 2010 Capital Project Planning,Accounting,Finance 70 0.33 24 Revisions to meeting outline Lilly 12 2 2010 Capital Project Planning,Accounting,Finance 143 054 78 Phone call from Les Olds,2011 budget Lilly 12 2 2010 Capital Project Planning,Accounting,Finance 143 2.60 372 Receive and incorporate 2011 budget into plan,prep reconciliation worksheet,prep for meeting Coonrod 12 3 2010 Capital Protect Planning,Accounting,Finance 215 0 20 43 Review status Coonrod 12 6 2010 Capital Project Planning,Accounting,Finance 215 0 12 26 Review progress Lilly 12 7 2010 Capital Project Planning,Accounting,Finance 143 0 42 61 4CDC discussion,meeting with Carter and Anker Lilly 12 7 2010 Capital Project Planning,Accounting,Finance 143 2 10 301 Prep for and attend meeting with Carter and Anker,follow up per CLC Coonrod 12 7 2010 Capital Project Planning,Accounting,Finance 215 2 03 437 Attend meeting with Carter and Anker,follow up on client requested info Coonrod 12 8 2010 Capital Project Planning,Accounting,Finance 215 004 9 Plan Lilly 12 8 2010 Capital Project Planning,Accounting,Finance 143 1.45 208 Receive check register from LWG, correspondence,follow up on meeting items Lilly 12 9 2010 Capital Project Planning,Accounting,Finance 143 3.10 444 Prepare forecast w/actuals,review forecast and projections,reconcile to LWG figures and balances,discuss bond reserves Lilly 12 10 2010 Capital Project Planning,Accounting,Finance 143 0 41 59 Correct forecast per Lee;copy to Carusillo Coonrod 12 14 2010 Capital Project Planning,Accounting,Finance 215 0 63 136 Dec settlement,energy center transaction Lilly 12 14 2010 Capital Project Planning,Accounting,Finance 143 2 86 409 Correspondence with Olds,Cleveland,Lee, Carusillow,Amsbaugh,and Roeger,prep worksheet regard TIF districts Coonrod 12 15 2010 Capital Project Planning,Accounting,Finance 215 0 62 134 Phone call from Les,change line,discussed w/SLL,follow up Lilly 12 15 2010 Capital Project Planning,Accounting,Finance 143 382 547 Discuss with CLC changes requested by client;phone call conference with Olds regarding changes;revision and transmittal of plan and forecast for meeting 12,389 Travel TOTAL invoice amount $12,389