The URL can be used to link to this page

Home My WebLink About321131 01/25/18 f C_qq CITY OF CARMEL, INDIANA VENDOR: 071300 ONE CIVIC SQUARE C. L. COONROD &COMPANY CHECK AMOUNT: $****43,496.00" CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 321 131 ?y.. SUITE 225 t-cruri°O CHECK DATE: 01/25/18 INDIANAPOLIS IN 45240 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER...; AMOUNT DESCRIPTION 1160 4341999 101207 0108-A 4,443.00 CAFR-RELATED ACCOUNTI 1160 4340303 101208 1217A 8,096.00 PROFESSIONAL ACCOUNTI 1160 4341999 101207 1217-A 9,735.00 CAFR-RELATED ACCOUNTI 1160 4340303 101208 1217B 11,222.00 PROFESSIONAL ACCOUNTI 1160 4341999 101207 COMP-B 10,000.00 CAFR-RELATED ACCOUNTI VOUCHER NO. WARRANT NO. Prescribed by state Board of Accounts City Form No.201(Rev.1995) Vendor# 071300 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER C. L. COONROD&COMPANY IN SUM OF$ CITY OF CARMEL 3850 PRIORITY WAY SOUTH DRIVE An invoice or bill to be properly itemized must show:kind of service,where performed,dates service SUITE 225 rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. INDIANAPOLIS, IN 46240 Payee $19,318.00 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Mayor's Office Terms Date Due PO# ACCT# DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 101208 1217a 43-403.03 $8,096.00 1 hereby certify that the attached invoice(s),or 12/29/17 1217a $8,096.00 1160 101 Prior Year 1160 101 101208 1217b 43-403.03 $11,222.00 bill(s)is(are)true and correct and that the 1/5/18 1217b $11,222.00 1160 1 1 101 1 materials or services itemized thereon for 1160 1 101 which charge is made were ordered and received except Tuesday,January 23,2018 Kibbe, Sharon Executive Office Manager hereby certify that the attached invoice(s),or bill(s),is(are)true and correct and I have audited same in accordance with IC 5-11-10-1.6 ,20— Cost 20Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer INVOICE 1217a P.O.101208 Hon.James C.Brainard Mayor,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 December 29,2017 Professional services from December 1 through December 15,2017,in connection with: Appeal-levy appeal follow up,review of levy appeal,follow up on filing of appeal. 1,466 Audit-Respond regarding audit finding,follow up on audit findings,prepare for exit 1,128 conference. Budget Consultation-budget matters,budget follow up items,budget amounts to be 1,584 approved by DLGF Plan- GAAP projection,review retirement health care,plan updates 3,808 Project-CAFR follow up,plan matters. 110 Out of pocket expense-travel to meeting. - ` Total amount of this invoice. 8,096 Previous balance. 38,592 Payment received. Total amount due. $ 46,688 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL December 29,2017 Professional services from December 1 through December 15,2017, in connection with: Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. Performinq Service Service Date Services Provided Hourly Rate Total Coonrod 12/5/Z017 Appeal 240 0.70 168 Roeger 12/6/2017 Appeal 220 1.05 231 Coonrod 12/6/2017 Appeal 240 0.40 96 Roeger 12/6/2017 Appeal 220 1.10 242 Coonrod 12/7/2017 Appeal 240 0.50 120 Roeger 12/7/2017 Appeal 220 1.55 341 Roeger 12/8/2017 Appeal 220 1.00 220 Coonrod 12/8/2017 Appeal 240 0.20 48 Appeal Total 1,466 Coonrod 12/4/2017 Audit 240 1.65 396 Coonrod 12/5/2017 Audit 240 0.35 84 Coonrod 12/8/2017 Audit 240 0.50 120 Coonrod 12/11/2017 Audit 240 2.20 528 Audit Total 1,128 Roeger 12/4/2017 Budget Consultation 220 1.50 330 Roeger 12/4/2017 Budget Consultation 220 0.20 44 Roeger 12/4/2017 Budget Consultation 220 0.30 66 Roeger 12/5/2017 Budget Consultation 220 4.00 880 Roeger 12/5/2017 Budget Consultation 220 0.65 143 Roeger 12/11/2017 Budget Consultation 220 0.55 121 Budget Consultation Total 1,584 Coonrod 12/4/2017 Plan 240 1.80 432 Coonrod 12/5/2017 Plan 240 1.60 384 Coonrod 12/7/2017 Plan 240 4.50 1,080 Roeger 12/12/2017 Plan 220 1.00 220 Coonrod 12/13/2017 Plan 240 3.90 936 Coonrod 12/14/2017 Plan 240 1.85 444 Coonrod 12/15/2017 Plan 240 1.30 312 Plan Total 3,808 Roeger 12/4/2017 Project 220 0.15 33 Roeger 12/4/2017 Project 220 0.35 77 Project Total 110 Publishing&printing-Pulication of adoption 0 Mileage 0 TOTAL invoice amount 8,096 INVOICE 1217b P.O.101208 Hon.James C.Brainard Mayor,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 January 5,2018 Professional services through December 31,2017,in connection with: Annexation-response to revenue estimates for Home Place,follow up on SW Clay annexation items,annexation impact. $ 1,494 Audit-follow up on compliance audit issues. 120 Bond/Lease-Review City advisor letter regarding bond,follow up on bond closing. 1,265 Budget Consultation-file archival and review,follow up on 2018 budget and other matters. 2,304 Plan-revision of fiscal plan,capital improvement plan,and GAAP projection. 3,768 Project-research food and beverage tax issues. 456 TIF-TIF projection template and analysis. 1,815 Out of pocket expense. - Total amount of this invoice. 11,222 Previous balance. 46,688 Payment received. (15,430) Total amount due. $ 42,480 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL January 5,2018 Professional services through December 31,2017, in connection with: Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. Performing Service Service Date Services Provided Hourly Rate Total Coonrod 12/19/2017 Annexation 240 1.55 372 Roeger 12/19/2017 Annexation 220 0.45 99 Roeger 12/20/2017 Annexation 220 1.00 220 Roeger 12/22/2017 Annexation 220 0.60 132 Roeger 12/28/2017 Annexation 220 2.90 638 Roeger 12/28/2017 Annexation 220 0.15 33 Annexation Total 1,494 Coonrod 12/20/2018 Audit 240 0.50 120 Audit Total 120 Coonrod 12/18/2017 Bond/Lease 240 0.10 24 Lilly 12/21/2017 Bond/Lease 175 1.40 245 Coonrod 12/21/2017 Bond/Lease 240 1.05 252 Coonrod 12/22/2017 Bond/Lease 240 0.70 168 Coonrod 12/26/2017 Bond/Lease 240 2.20 528 Coonrod 12/27/2017 Bond/Lease 240 0.20 48 Bond/Lease Total 1,265 Lilly 12/7/2017 Budget Consultation 175 1.75 306 Lilly 12/14/2017 Budget Consultation 175 1.75 306 Coonrod 12/20/2017 Budget Consultation 240 0.45 108 Coonrod 12/21/2017 Budget Consultation 240 1.20 288 Lilly 12/21/2017 Budget Consultation 175 1.75 306 Coonrod 12/27/2017 Budget Consultation 240 0.20 48 Coonrod 12/28/2017 Budget Consultation 240 2.65 636 Lilly 12/28/2017 Budget Consultation 175 1.75 306 Budget Consultation Total 2,304 Lilly 12/15/2017 Plan 175 0.60 105 Lilly 12/18/2017 Plan 175 2.40 420 Coonrod 12/18/2017 Plan 240 3.75 900 Coonrod 12/19/2017 Plan 240 1.30 312 Coonrod 12/19/2017 Plan 240 0.50 120 Lilly 12/19/2017 Plan 175 2.10 368 Roeger 12/19/2017 Plan 220 1.00 220 Coonrod 12/20/2017 Plan 240 1.05 252 Coonrod 12/20/2017 Plan 240 0.95 228 Lilly 12/21/2017 Plan 175 2.35 411 Coonrod 12/27/2017 Plan 240 1.80 432 Plan Total 3,768 co 00 0 0 N 0 W - W O O N IT IT N � N M L � r OTO N r r T N N O0D � LN LO 0 N 0 0 C C CL C NNNNNNN c (6 N N N N N N N N 4. ^2 O F- V O m N F- O O LL LL LL LL. LL. LL. LL. w M a F- F F- F- F- F F- 0000000 -0000000 N N N N N N N N N N M M M a N N N N N N N r C 7 O E co d v O C 0 0 0 0 0 0 0 0 p VOUCHER NO. WARRANT NO. Prescribed by state Board of Accounts City Form No.201(Rev.1995) Vendor# 071300 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER C. L. COONROD&COMPANY IN SUM OF$ CITY OF CARMEL 3850 PRIORITY WAY SOUTH DRIVE An invoice or bill to be properly itemized must show:kind of service,where performed,dates service SUITE 225 rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. INDIANAPOLIS, IN 46240 Payee $24,178.00 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Mayor's Office Terms Date Due PO# ACCT# DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 101207 COMPILATION-13 43-419.99 $10,000.00 1 hereby certify that the attached invoice(s),or 9/15/17 COMPILATION-13 $10,000.00 1160 101 Prior Year 1160 101 101207 1217-A 43-419.99 $9,735.00 bill(s)is(are)true and correct and that the 1/5/18 1217-A $9,735.00 1160 101 materials or services itemized thereon for 1160 101 101207 0108-A 43-419.99 $4,443.00 1/19/18 0108-A $4,443.00 1160 101 which charge is made were ordered and 1160 101 received except Tuesday,January 23,2018 �a1o.a� Kibbe, Sharon Executive Office Manager I hereby certify that the attached invoice(s),or bill(s),is(are)true and correct and I have audited same in accordance with IC 5-11-10-1.6 ,20 Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer INVOICE COMPILATION-B P.O.` t o 1 a O-'I Board of Works City of Carmel Attn:Andrew O.Mouser 8365 Keystone Crossing,Ste.300 Indianapolis,Indiana 46240-2687 Make check payable to: C.L.Coonrod&Company Tax ID#35-1985559 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 September 15,2017 2015 CAFR: Compilation of certain 2016 Financial Statements in accordance with engagement letter dated May 11th,2017. $ 10,000 Out of pocket expense-mileage to meeting - Total amount of this invoice. 10,000 Previous balance. 10,000 Payment received. 10,000 Total amount due. $ 10,000 Payable upon receipt. Call(317)844-4605 with questions. INVOICE 1217-A P.O.101207 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 January 5,2018 Professional services through December 31,2017,in connection with: 2017 CAFR: New bond issues $ 156 Capital assets 674 Compensated absences 210 Reformat and bring forward statements to new year. 3,920 GFOA checklist 576 Introductory section,CAFR prep 479 Updates to accommodate previous year Auditor comments. 2,007 Statistical section 262 Subtotal 8,284 Publishing&printing Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17, 2017($70,004). 8,284 Work outside scope-audit committee meeting and plan for 2017 cap assets,follow up, respond to C-T question regarding requirement to add bond-related accounts to the ledger. 1,451 Total amount of this invoice. 9,735 Previous balance. - Payment received. - Total amount due. $ 9,735 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL January 5,2018 Professional services through December 31,2017,in connection with: Rates in accordance with Section 5.1 ofthe contract and our October 5,2012,tetter to the Mayor. uformina Servl Services Provided Hourly Rate Total Coonrod New bond issues 240 0.65 156 New bond Issues Total 156 Lilly Capital assets 175 3.85 674 Capital assets Total 674 Lilly Compensated absences 175 1.20 210 Lilly Compensated absences 175 0 Compensated absences Total 210 Lilly Reformat and bring forward statements to new year 175 5.70 997 Lilly Reformat and bring forward statements to new year 175 2.80 490 Coonrod Reformat and bring forward statements to new year 240 1.35 324 Lilly Reformat and bring forward statements to new year 175 2.55 446 Lilly Reformat and bring forward statements to new year 175 9.50 1,663 Reformat and bring forward statements to new year Total 3,920 Coonrod GFOA checklist 240 0.75 160 Coonrod GFOA checklist 240 1.65 396 GFOA checklist Total 576 Coonrod Introductory section,CAFR prep 240 0.90 216 Lilly Introductory section,CAFR prep 175 1.50 263 Introductory section,CAFR prep Total 479 Coonrod Updates to accommodate previous year Auditor comments 240 1.75 420 Lilly Updates to accommodate previous year Auditor comments 175 1.80 315 Coonrod Updates to accommodate previous year Auditor comments 240 0.55 132 Coonrod Updates to accommodate previous year Auditor comments 240 0.15 36 Coonrod Updates to accommodate previous year Auditor comments 240 1.70 408 Coonrod Updates to accommodate previous year Auditor comments 240 0.90 216 Coonrod Updates to accommodate previous year Auditor comments 240 1.00 240 Coonrod Updates to accommodate previous year Auditor comments 240 1.00 240 Updates to accommodate previous year Auditor comments Total 2,007 Lilly Statistical section 175 1.50 262 Statistical section Total 262 Lilly Work outside scope 175 1.55 271 Coonrod Work outside scope 240 0.45 108 Lilly Work outside scope 175 1.60 280 Coonrod Work outside scope 240 0.30 72 Coonrod Work outside scope 240 0.50 120 Coonrod Work outside scope 240 0.25 60 Lilly Work outside scope 175 1.30 228 Coonrod Work outside scope 240 0.30 72 Coonrod Work outside scope 240 1.00 240 Work outside scope Total 1,451 Publishing&printing 0 Mileage 0 TOTAL Invoice amount 9,735 INVOICE 0108-A P.O.101207 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 January 19,2018 Professional services through January 15,2018,in connection with: 2017 CAFR: Budgetary statements $ 911 Compensated absences 114 Introductory section,CAFR prep 403 MID&A 342 Set up initial TB 2,034 Subtotal 3,804 Publishing&printing - Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17, 2017($70,004). 3,804 Work outside scope-reconcile TB account to determine discrepancies between reports, add in journal entry for adjustments after reports run 639 Total amount of this invoice. 4,443 Previous balance. 9,735 Payment received. - Total amount due. $ 14,178 Payable upon receipt. Call(317)8444605 with questions. CITY OF CARMEL January 19,2018 Professional services through January 15,2018,in connection with: Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. !rforming Servi Service Date Services Provided Hourly Rate Total Lilly 1/8/2018 Budgetary statements 175 1.90 333 Lilly 1/9/2018 Budgetary statements 175 1.90 333 Lilly 1/15/2018 Budgetary statements 175 1.40 245 Budgetary statements Total 911 Lilly 1/8/2018 Compensated absences 175 0.65 114 Compensated absences Total 114 Lilly 1/8/2018 Introductory section,CAFR prep 175 2.30 403 Introductory section,CAFR prep Total 403 Lilly 1/9/2018 MD&A 175 0.85 149 Lilly 1/9/2018 MD&A 175 1.10 193 MD&A Total 342 Lilly 1/10/2018 Set up initial TB 175 3.15 551 Lilly 1/11/2018 Set up initial TB 175 3.85 674 Coonrod 1/11/2018 Set up initial TB 240 0.20 48 Lilly 1/12/2018 Set up initial TB 175 1.20 210 Lilly 1/12/2018 Set up initial TB 175 3.15 551 Set up initial TB Total 2,034 Lilly 1/13/2018 Work Outside Scope 175 3.65 639 Work Outside Scope Total 639 Publishing&printing 0 Mileage 0 TOTAL invoice amount 4,443