The URL can be used to link to this page

Home My WebLink About322660 03/12/18 CITY OF CARMEL, INDIANA VENDOR: 071300;: . <.; d ONE CIVIC SQUARE C. L COONROD & COMPANY CHECK AMOUNT: $ *41,269.00` CARMEL, INDIANA 46032 S3850 UITE PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 322660 c>sN225 CHECK DATE: 03/12/18 INDIANAPOLIS IN 46240 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER:, AMOUNT DESCRIPTION 1160 4340303 101208 022818 12,154.00 PROFESSIONAL ACCOUNTI 1160 4341999 101207 1150-021518 12,768.00 CAFR-RELATED ACCOUNTI 1160 4341999 101207 1150-022818 5,703.00 CAFR-RELATED ACCOUNTI 1160 4340303 101208 1160021518 10,644.00 PROFESSIONAL ACCOUNTI VOUCHER NO. WARRANT NO. Prescribed by state Board of Accounts City Form No.201(Rev.1995) ALLOWED 20 ACCOUNTS PAYABLE VOUCHER Vendor# 071300 IN SUM OF$ CITY OF CARMEL C. L. COONROD&COMPANY 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,bywhom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. INDIANAPOLIS, IN 46240 Payee $12,768.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 1150-021518 43-419.99 $12,768.00 I hereby certify that the attached invoice(s),or 2/26/18 1150-021518 $12,768.00 1160 101 1160 101 bill(s)is(are)true and correct and that the materials or services itemized thereon for which charge is made were ordered and received except Monday, March 05,2018 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 1150-021518 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 February 26,2018 Professional services through February 15,2018,in connection with: 2017 CAFR: Accounts payable $ 1,426 Accrued wage 429 AR-property tax 193 Bond principal 2,050 Capital assets 72 Capital leases 578 Local pensions 144 New bond issues 4,756 Statistical section 66 Trust cash 1,251 Subtotal 10,965 Publishing&printing - Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17, 2017($70,040). 10,965 Work outside scope 1,803 Total amount of this invoice. 12,768 Previous balance. 9,735 Payment received. 9,735 Total amount due. $ 12,768 Call(317)8444605 with questions. CITY OF CARMEL February 26,2018 Professional services through February 15,2018,in connection with: Rales in accordance with Section 5.1 of the contract and our October 5,2012,latter to the Mayor. rforming Seryi Service Date Services Provided Hourly Rate Total Lilly 2/11/2018 Accounts payable 175 2.75 481 Lilly 2/13/2018 Accounts payable 175 2.10 368 Lilly 2/15/2018 Accounts payable 175 3.30 578 Accounts Payable Total 1,426 Lilly 2/3/2018 Accrued wage 175 2.45 429 Accrued wage Total 429 Lilly 2/15/2018 AR-property tax 175 1.10 193 AR-property tax total 193 Lilly 2/1/2018 update CAFR with bond information 175 2.60 455 Lilly 2/5/2018 update CAFR with bond information 175 2.45 429 Coonrod 2/5/2018 update CAFR with bond information 240 0.25 60 Lilly 2/6/2018 update CAFR with bond information 175 1.80 315 Lilly 2/7/2018 update CAFR with bond information 175 1.30 228 Lilly 2/12/2018 update CAFR with bond information 175 2.40 420 Coonrod 2/12/2018 update CAFR with bond information 240 0.40 96 Coonrod 2/13/2018 update CAFR with bond information 240 0.20 48 Bond principal total 2,050 Coonrod 2/12/2018 Capital Assets 240 0.25 60 Coonrod 2/15/2018 Capital Assets 240 0.05 12 Capital Assets Total 72 Lilly 2/3/2018 Capital leases 175 3.30 578 Capital leases Total 578 Lilly 2/8/2018 Local pensions 175 0.55 96 Coonrod 2/8/2018 Local pensions 240 0.20 48 Local pensions Total 144 Lilly 2/2/2018 New bond issues 175 5.20 910 Coonrod 2/2/2018 New bond issues 240 0.20 48 Lilly 2/6/2018 New bond issues 175 3.85 674 Lilly 2/8/2018 New bond issues 175 3.70 648 Lilly 2/9/2018 New bond issues 175 4.10 718 Lilly 2/13/2018 New bond issues 175 5.65 989 Lilly 2/15/2018 New bond issues 175 4.40 770 New bond Issues Total 4,766 Roeger 2/9/2018 Statistical section 220 0.30 66 Statistical section Total 66 Lilly 01/26/2018 Trust cash 175 4.55 796 Lilly 01/17/2018 Trust cash 175 2.60 455 Trust cash Total 1,261 Lilly 2/2/2018 Work Outside Scope 175 6.85 1,199 Lilly 2/14/2018 Work Outside Scope 175 3.45 604 Work Outside Scope Total 1,803 Publishing&printing 0 Mileage 0 TOTAL Invoice amount 12,768 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 $10,644.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 1160-021518 43-403.03 $10,644.00 1 hereby certify that the attached invoice(s),or 2/23/18 1160-021518 $10,644.00 1160 101 1160 101 bill(s)is(are)true and correct and that the materials or services itemized thereon for which charge is made were ordered and received except Monday, March 05,2018 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 1160-021518 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 February 23,2018 Professional services through February 15,2018,in connection with: Annexation: Follow up with Home Place filing $ 108 Appeal Consider and review response to DLGF 672 Bond/Lease Moody and S&P conference calls,preparation and analysis 5,429 Budget Consultation Consult on questions regarding 1782 response,budget follow-up 3,408 plan updates Plan Review and update 651 Project Food and beverage tax follow-up with DOR 375 Out of pocket expense - Total amount of this invoice. 10,644 Previous balance. 25,879 Payment received. - Total amount due. $ 36,523 Call(317)844-4605 with questions CITY OF CARMEL February 23,2018 Professional services through February 15,2018,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 2/12/2018 Annexation 240 0.45 108 Annexation Total 108 Coonrod 2/1/2018 Appeal 240 2.80 672 Appeal Total 672 Coonrod 2/5/2018 Bond/Lease 240 0.20 48 Coonrod 2/12/2018 Bond/Lease 240 0.20 48 Roeger 2/13/2018 Bond/Lease 220 4.50 990 Coonrod 2/13/2018 Bond/Lease 240 4.40 1,056 Roeger 2/13/2018 Bond/Lease 220 1.15 253 Coonrod 2/14/2018 Bond/Lease 240 5.95 1,428 Roeger 2/14/2018 Bond/Lease 220 5.50 1,210 Coonrod 2/15/2018 Bond/Lease 240 1.65 396 Bond/Lease Total 5,429 Lilly 2/1/2018 Budget Consultation 175 1.75 306 Roeger 2/1/2018 Budget Consultation 220 1.00 220 Roeger 2/1/2018 Budget Consultation 220 0.45 99 Roeger 2/1/2018 Budget Consultation 220 0.90 198 Roeger 2/1/2018 Budget Consultation 220 0.90 198 Roeger 2/1/2018 Budget Consultation 220 1.10 242 Roeger 2/1/2018 Budget Consultation 220 0.65 143 Roeger 2/5/2018 Budget Consultation 220 1.85 407 Roeger 2/5/2018 Budget Consultation 220 1.85 407 Lilly 2/8/2018 Budget Consultation 175 1.75 306 Coonrod 2/9/2018 Budget Consultation 240 0.95 228 Coonrod 2/12/2018 Budget Consultation 240 0.30 72 Roeger 2/15/2018 Budget Consultation 220 1.20 264 Lilly 2/15/2018 Budget Consultation 175 1.75 306 Budget Consultation Total 3,396 Coonrod 2/5/2018 Budget Hearing 240 0.05 12 Budget Hearing Total 12 Coonrod 2/6/2018 Plan 240 0.10 24 Roeger 2/9/2018 Plan 220 0.10 22 Roeger 2/14/2018 Plan 220 2.75 605 Plan Total 651 Roeger 2/6/2018 Project 220 0.20 44 Coonrod 2/6/2018 Project 240 0.50 120 Bahler 2/6/2018 Project 100 0.65 65 Bahler 2/6/2018 Project 100 0.50 50 Coonrod 2/7/2018 Project 240 0.40 96 Project Total 375 Publishing&printing 0 Mileage 0 TOTAL invoice amount 10,644 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 $12,154.00 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Terms Mayor's Office 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 1160-022818 43-403.03 $12,154.00 1 hereby certify that the attached invoice(s),or 3/2/18 1160-022818 $12,154.00 1160 101 1160 101 bill(s)is(are)true and correct and that the materials or services itemized thereon for which charge is made were ordered and received except Monday, March 05,2018 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 Clerk-Treasurer INVOICE 1160-022818 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 March 2,2018 Professional services through February 28,2018,in connection with: Accounting Follow-up with SBOA regarding recommendations on trust $ 228 cash accounting and recording GAAP funds,consult on grant reimbursement Annual Report Year-end accounting follow-up 209 Bond/Lease S&P conference calls and follow-up,prepare GAAP/budget 9,853 analysis for S&P conference calls on Midtownbonds,analysis of 2015/2016 statements,responses to follow-up questions from Moody's Budget Consultation Consult on budget matters and plan updates 319 Plan Update draft of Fiscal Plan,updates to debt schedule in Fiscal 1,545 Plan,plan revisions Out of pocket expense - Total amount of this invoice. 12,154 Previous balance. 10,644 Payment received. - Total amount due. $ 22,798 Call(317)844-4605 with questions CITY OF CARMEL March 2,2018 Professional services through February 28,2018,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 2/22/2018 Accounting system 240 0.55 132 Coonrod 2/23/2018 Accounting system 240 0.10 24 Coonrod 2/28/2018 Accounting system 240 0.30 72 Accounting system Total 228 Roeger 2/27/2018 Annual report 220 0.95 209 Annual report Total 209 Roeger 2/16/2018 Bond/Lease 220 1.25 275 Coonrod 2/12/2018 Bond/Lease 240 6.75 1,620 Coonrod 2/18/2018 Bond/Lease 240 1.50 360 Coonrod 2/19/2018 Bond/Lease 240 4.00 960 Lilly 2/19/2018 Bond/Lease 175 6.85 1,199 Roeger 2/19/2018 Bond/Lease 220 0.05 11 Roeger 2/19/2018 Bond/Lease 220 0.65 143 Roeger 2/19/2018 Bond/Lease 220 0.95 209 Lilly 2/20/2018 Bond/Lease 175 2.05 359 Coonrod 2/20/2018 Bond/Lease 240 2.20 528 Roeger 2/20/2018 Bond/Lease 220 2.00 440 Coonrod 2/21/2018 Bond/Lease 240 3.85 924 Roeger 2/21/2018 Bond/Lease 220 1.20 264 Roeger 2/22/2018 Bond/Lease 220 3.45 759 Coonrod 2/22/2018 Bond/Lease 240 1.10 264 Coonrod 2/23/2018 Bond/Lease 240 0.35 84 Roeger 2/27/2018 Bond/Lease 220 2.30 506 Coonrod 2/27/2018 Bond/Lease 240 3.95 948 Bond/Lease Total 9,853 Roeger 2/21/2018 Budget Consultation 220 0.40 88 Roeger 2/26/2018 Budget Consultation 220 0.10 22 Roeger 2/28/2018 Budget Consultation 220 0.95 209 Budget Consultation Total 319 Roeger 2/16/2018 Plan 220 0.20 44 Roeger 2/19/2018 Plan 220 0.85 187 Roeger 2/19/2018 Plan 220 2.05 451 Roeger 2/21/2018 Plan 220 0.95 209 Roeger 2/23/2018 Plan 220 0.40 88 Roeger 2/23/2018 Plan 220 0.70 154 Coonrod 2/26/2018 Plan 240 0.80 192 Roeger 2/27/2018 Plan 220 1.00 220 Plan Total 1,545 Publishing&printing 0 Mileage 0 TOTAL invoice amount 12,154 VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) ALLOWED 20 ACCOUNTS PAYABLE VOUCHER Vendor# 071300 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 $5,703.00 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Terms Mayor's Office 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 1150-022818 43-419.99 $5,703.00 1 hereby certify that the attached invoice(s),or 3/5/18 1150-022818 $5,703.00 1160 101 1160 101 bill(s)is(are)true and correct and that the materials or services itemized.thereon,for which charge is made were ordered and received except Monday, March 05,2018 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. Clerk-Treasurer INVOICE 1150-022818 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 March 5,2018 Professional services through February 28,2018,in connection with: 2017 CAFR: Accounts payable $ 411 AR-medicaid supplemental 446 Local pensions 236 PERS pensions 36 Trust cash 3,304 Subtotal 4,433 Publishing&printing - Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17,2017 ($70,040). 4,433 Work outside scope 1,270 Total amount of this invoice. 5,703 Previous balance. 12,778 Payment received. - Total amount due. $ 18,481 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL March 5,2018 Professional services through February 28,2018, in connection with: Performing Service Date Services Provided Hourly Rate Hours Total Service Lilly 2/16/2018 Accounts payable 175 2.35 411 Accounts payable Total 411 Lilly 2/21/2018 AR-medicaid supplemental 175 2.55 446 AR-medicaid supplemental Total 446 Lilly 2/22/2018 Local pensions 175 1.35 236 Local pensions Total 236 Coonrod 2/22/2018 PERS pensions 240 0.15 36 PERS pensions Total 36 Lilly 2/16/2018 Trust cash 175 2.25 394 Lilly 2/17/2018 Trust cash 175 6.10 1,068 Lilly 2/22/2018 Trust cash 175 2.40 420 Coonrod 2/22/2018 Trust cash 240 0.20 48 Lilly 2/23/2018 Trust cash 175 0.80 140 Lilly 2/26/2018 Trust cash 175 1.30 228 Lilly 2/27/2018 Trust cash 175 1.05 184 Lilly 2/28/2018 Trust cash 175 2.50 438 Coonrod 2/28/2018 Trust cash 240 1.60 384 Trust cash Total 3,304 Lilly 2/21/2018 Work Outside Scope 175 2.70 473 Lilly 2/22/2018 Work Outside Scope 175 1.85 324 Lilly 2/27/2018 Work Outside Scope 175 2.70 473 Work Outside Scope Total 1,270 Publishing&printing 0 Mileage 0 TOTAL invoice amount 5,703