Loading...
HomeMy WebLinkAbout329919 9/11/2018 CITY OF CARMEL, INDIANA VENDOR: 071300 ® ONE CIVIC SQUARE C. L. COONROD &COMPANY CHECK AMOUNT: $****16,927.00* CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 329919 SUITE 225 CHECK DATE: 09111/18 INDIANAPOLIS IN 46240 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4341999 101207 1150083118 888:00 CAFR-RELATED ACCOUNTI 1160 4340303 101208 1160083118 16,039.00 PROFESSIONAL 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 $888.00 ON ACCOUNT OF APPROPRIATION FOR Purchase Order# 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-083118 43-419.99 $888.00 1 hereby certify that the attached invoice(s),or 8/31/18 1150-083118 $888.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 Wednesday, September 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-083118 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 August 31,2018 Professional services through August 31,2018,in connection with: 2017 CAFR: Subtotal Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17, 2017($70,040). Work outside scope-Respond to questions regarding allocation of city costs to utilities, audit response,utility statements 888 Total amount of this invoice. 888 Previous balance. $ 7,994 Payment received. (7,994) Total amount due. $ 888 Call(317)844-4605 with questions CITY OF CARMEL August 1,2018 For Professional Services through July 31,2018 in connection with Performing Service Service Date Services Provided Hourly Rate Hours Total Bahler 8/1/2018 Work outside scope 100 0.45 45 Coonrod 8/20/2018 Work outside scope 240 0.10 24 Roeger 8/21/2018 Work outside scope 220 0.50 110 Lilly 8/23/2018 Work outside scope 175 1.80 315 Lilly 8/27/2018 Work outside scope 175 2.25 394 Work outside scope Total 888 Publishing&printing 0 Mileage 0 TOTAL invoice amount 888 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 $16,039.00 ON ACCOUNT OF APPROPRIATION FOR Purchase Order# 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-083118 43-403.03 $16,039.00 1 hereby certify that the attached invoice(s),or 8/31/18 1160-083118 $16,039.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 Wednesday, September 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-083118 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 August 31,2018 Professional services through August 31,2018,in connection with: Accounting Prepare for Audit Committee meeting,respond to question from $ 612 Audit Committee and review C-T responses to audit findings Annexation Respond to questions regarding census application 144 Audit Review audit responses,respond to 2017 audit comments including 5,645 utility cost administrative fee,respond to SBOA regarding RDA report findings and exit conference issues,analysis of utility management fee for SBOA,audit committee meeting Bond/Lease Response to OPEB issue,investigate 10 year amortization schedule 252 for LIT bond Budget Consultation LIT follow-up,budget forms follow-up,budget matters 3,198 Economic Development Winamac and Carmel tax comparison analysis 1,271 Legislation Meeting with LIT legislation lobbyists,follow-up analysis for 3,044 proposed LIT legislation. LOIT Analysis Follow-up on IDR explanation for slow income growth,LIT 1,037 anaylsis and follow-up Plan Parks salary estimate,projection of Sewer Utility fees 132 Project Review parks salary estimate,follow up on utility management fees 704 calculation. Out of pocket expense - Total amount of this invoice. 16,039 Previous balance. $ 15,378 Payment received. (15,378) Total amount due. $ 16,039 CITY OF CARMEL August 31,2018 Professional services through August 31,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 8/27/2018 Accounting System 240 1.85 444 Coonrod 8/28/2018 Accounting System 240 0.70 168 Accounting System Total 612 Coonrod - 8/24/2018 Annexation 240 0.60 144 Annexation Total 144 Lilly 8/20/2018 Audit 175 1.45 254 Coonrod 8/20/2018 Audit 240 3.30 792 Lilly 8/21/2018 Audit 175 1.00 175 Coonrod 8/21/2018 Audit 240 1.10 264 Coonrod 8/22/2018 Audit 240 3.10 744 Lilly 8/23/2018 Audit 175 2.10 368 Coonrod 8/23/2018 Audit 240 7.55 1,812 Coonrod 8/30/2018 Audit 240 5.15 1,236 Audit Total 5,645 Coonrod 8/22/2018 Bond/Lease 240 0.45 108 Coonrod 8/28/2018 Bond/Lease 240 0.60 144 Bond/Lease Total 252 Lilly 8/16/2018 Budget Consulation 175 1.80 315 Roeger 8/16/2018 Budget Consulation 220 0.85 187 Lilly 8/16/2018 Budget Consulation 175 1.75 306 Lilly 8/20/2018 Budget Consulation 175 1.55 271 Roeger 8/20/2018 Budget Consulation 220 1.25 275 Roeger 8/20/2018 Budget Consulation 220 0.90 198 Roeger 8/21/2018 Budget Consulation 220 0.60 132 Roeger 8/21/2018 Budget Consulation 220 1.75 385 Roeger 8/22/2018 Budget Consulation 220 1.85 407 Lilly 8/23/2018 Budget Consulation 175 1.75 306 Roeger 8/28/2018 Budget Consulation 220 0.50 110 Lilly 8/30/2018 Budget Consulation 175 1.75 306 Budget Consultation Total 3,198 Lilly 8/27/2018 Budget Consulation 175 2.80 490 Lilly 8/28/2018 Budget Consulation 175 1.85 324 Coonrod 8/28/2018 Budget Consulation 240 0.50 120 Lilly 8/29/2018 Budget Consulation 175 1.10 193 Coonrod 8/29/2018 Budget Consulation 240 0.30 72 Coonrod 8/30/2018 Budget Consulation 240 0.30 72 Budget Consultation Total 1,271 Coonrod 8/20/2018 Legislation 240 0.60 144 Bahler 8/20/2018 Legislation 100 0.20 20 Coonrod 8/21/2018 Legislation 240 2.30 552 Coonrod 8/27/2018 Legislation 240 1.00 240 Coonrod 8/28/2018 Legislation 240 2.00 480 Coonrod 8/29/2018 Legislation 240 3.70 888 Coonrod 8/31/2018 Legislation 240 3.00 720 Legislation Total 3,044 Coonrod 8/16/2018 Project 240 0.10 24 Roeger 8/17/2018 Project 220 3.85 847 Coonrod 8/20/2018 Project 240 0.05 12 Roeger 8/21/2018 Project 220 0.70 154 Project Total 1,037