The URL can be used to link to this page

Home My WebLink About325263 05/15/18 u .S•Iq . CITY OF CARMEL, INDIANA VENDOR: 071300 j; el ONE CIVIC SQUARE C. L. COONROD&COMPANY CHECK AMOUNT: $****27,971.00* CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 325263 SUITE 225 CHECK DATE: 05/15/18 INDIANAPOLIS IN 46240 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4341999 101207 1150041518 8,994.00 CAFR—RELATED ACCOUNTI 1160 4341999 101207 1150043018 3,048.00 CAFR—RELATED ACCOUNTI 1160 4340303 101208 1160041518 8,693.00 PROFESSIONAL ACCOUNTI 1160 4340303 101208 1160043018 7,236.00 PROFESSIONAL ACCOUNTI VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts city Form No.201(Rev.1996) 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,042.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-041518 43-419.99 $8,994.00 1 hereby certify that the attached invoice(s),or 4/27/18 1150-041518 $8,994.00 1160 101 1160 101 101207 1150-043018 43-419.99 $3,048.00 bill(s)is(are)true and correct and that the 5/3/18 1150-043018 $3,048.00 1160 1 101 1 materials or services itemized thereon for 1160 101 which charge is made were ordered and received except Wednesday, May 09,2018 1o.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 Clerk-Treasurer INVOICE 1150-041518 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 April 27,2018 Professional services through April 15,2018,in connection with: 2017 CAFR: Finalize and reconcile statements $ 1,795 Local pensions 420 Subtotal 2,215 Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17, 2017($70,040). 2,215 Work outside scope-Follow-up on utility statements,respond regarding C-T concerns about delivery of draft report,follow-up on local pension studies and utility statements,consider proper treatment of water company refinancing transatcion,receive bond bank statements for reconciliation to city statements, utility transfers,revise sewer statements,follow-up on audit committee question regarding 2016 sudit finding 6,779 Total amount of this invoice. 8,994 Previous balance. 27,263 Payment received. - Total amount due. $ 36,257 CITY OF CARMEL April 27,2018 Professional services through April 15,2018, in connection with: Performing Service Date Services Provided Hourly Rate Hours Total Service Lilly 4/3/2018 Finalize and reconcile statements 175 4.10 718 Lilly 4/3/2018 AR-medicaid supplemental 175 2.85 499 Lilly 4/13/2018 AR-medicaid supplemental 175 3.30 578 AR-medicaid supplemental Total 1,795 Coonrod 4/5/2018 Bond premiums 240 1.45 348 Coonrod 4/5/2018 Bond premiums 240 0.30 72 Bond premiums Total 420 Lilly 4/2/2018 Work outside scope 175 4.20 735 Coonrod 4/2/2018 Work outside scope 240 3.15 756 Coonrod 4/3/2018 Work outside scope 240 0.95 228 Coonrod 4/4/2018 Work outside scope 240 0.20 48 Lilly 4/5/2018 Work outside scope 175 3.15 551 Lilly 4/6/2018 Work outside scope 175 1.35 236 Lilly 4/8/2018 Work outside scope 175 2.60 455 Coonrod 4/8/2018 Work outside scope 240 3.35 804 Lilly 4/9/2018 Work outside scope 175 2.70 473 Coonrod 4/9/2018 Work outside scope 240 0.25 60 Lilly 4/10/2018 Work outside scope 175 1.90 333 Coonrod 4/10/2018 Work outside scope 240 0.65 156 Lilly 4/11/2018 Work outside scope 175 1.70 298 Lilly 4/12/2018 Work outside scope 175 2.25 394 Lilly 4/13/2018 Work outside scope 175 2.90 508 Coonrod 4/13/2018 Work outside scope 240 3.10 744 Work outside scope Total 6,779 Publishing&printing 0 Mileage 0 TOTAL invoice amount 8,994 INVOICE 1150-043018 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 May 3,2018 Professional services through April 30,2018,in connection with: 2017 CAFR: Work within scope- $ - Work outside scope-Follow-up on 2016 finding at request of audit committee,disc progrss and updates on utility statements,update pension information from prior year study,review drafts of Water and Sewer statements,utility transfers,Enterprise Fund follow-up,utility statement revisions 3,048 Total amount of this invoice. 3,048 8,994 Previous balance. Payment received. - Total amount due. $ 12,042 CITY OF CARMEL May 3,2018 Professional services through April 30,2018, in connection with: Performing Service Date Services Provided Hourly Rate Hours Total Service Coonrod 4/16/2018 Work outside scope 240 0.90 216 Lilly 4/17/2018 Work outside scope 175 1.55 271 Lilly 4/17/2018 Work outside scope 175 1.35 236 Lilly 4/17/2018 Work outside scope 175 1.55 271 Coonrod 4/17/2018 Work outside scope 240 0.20 48 Coonrod 4/17/2018 Work outside scope 240 0.25 60 Coonrod 4/17/2018 Work outside scope 240 1.00 240 Lilly 4/18/2018 Work outside scope 175 1.80 315 Coonrod 4/18/2018 Work outside scope 240 0.45 108 Lilly 4/19/2018 Work outside scope 175 2.15 376 Lilly 4/23/2018 Work outside scope 175 1.90 333 Roeger 4/24/2018 Work outside scope 220 0.50 110 Lilly 4/26/2018 Work outside scope 175 2.65 464 Work outside scope Total 3,048 Publishing&printing 0 Mileage 0 TOTAL invoice amount 3,048 Prescribed by State Board of Accounts City Form No.201(Rev.1995) VOUCHER NO. WARRANT NO. 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,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. -INDIANAPOLIS, IN 46240 Payee $15,929.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-041518 43-403.03 $8,693.00 1 hereby certify that the attached invoice(s),or 4/27/18 1160-041518 $8,693.00 1160 101 1160 101 101208 1160-043018 43-403.03 $7,236.00 bill(s)is(are)true and correct and that the 5/3/18 1160-043018 $7,236.00 1160 101 1 materials or services itemized thereon.for 1160 1 101 which charge is made were ordered and received except Wednesday, May 09,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-041528 P.O.101208 Hon.James C.Brainard Mayor,City of Carmel Attn:Sharon Kibbe One Civic Square Cannel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 April 27,2018 Professional services through April 15,2028,in connection with: Accounting Follow-up on SBOA comment and audit regarding $ 72 establishment of funds Budget Consultation Plan updates,reconciliation of open items,budget follow-up, 2,719 research on communter tax,cable fees Legislation Alternative LIT allocation for Hamilton County,communter tax, 1,392 LIT alternative language Plan Rate cap credit updates,plan review 559 Project Follow-up on amendments to Indiana Code regarding Income 3,951 Tax Distributions,drafting legislation language,update HB for LIT commuter tax follow-up,plan updates,road monies Out of pocket expense - Total amount of this invoice. 8,693 Previous balance. 22,979 Payment received. - Total amount due. $ 31,672 Call(317)844-4605 with questions CITY OF CARMEL April 27,2018 Professional services through April 15,2028,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 4/2/2018 Assessment 240 0.10 24 Coonrod 4/3/2018 Assessment 240 0.20 48 Assessment Total 72 Roeger 4/2/2018 Budget consultation 220 1.05 231 Roeger 4/2/2018 Budget consultation 220 1.85 407 Roeger 4/3/2018 Budget consultation 220 0.60 132 Coonrod 4/5/2018 Budget consultation 240 3.45 828 Lilly 4/5/2018 Budget consultation 175 1.75 306 Coonrod 4/10/2018 Budget consultation 240 0.90 216 Roeger 4/10/2018 Budget consultation 220 1.00 220 Coonrod 4/12/2018 Budget consultation 240 0.30 72 Lilly 4/12/2018 Budget consultation 175 1.75 306 Budget Consultation Total 2,719 Coonrod 4/3/2018 Legislation 240 0.50 120 Coonrod 4/9/2018 Legislation 240 1.50 360 Coonrod 4/11/2018 Legislation 240 0.45 108 Coonrod 4/11/2018 Legislation 240 3.30 792 Coonrod 4/13/2018 Legislation 240 0.05 12 Legislation Total 1,392 Coonrod 4/12/2018 Plan 240 2.10 504 Roeger 4/13/2018 Plan 220 0.25 55 Plan Total 559 Roeger 4/3/2018 Project 220 1.35 297 Roeger 4/3/2018 Project 220 1.80 396 Lilly 4/5/2018 Project 175 2.40 420 Roeger 4/5/2018 Project 220 3.35 737 Roeger 4/9/2018 Project 220 0.65 143 Roeger 4/10/2018 Project 220 0.50 110 Roeger 4/10/2018 Project 220 0.25 55 Roeger 4/10/2018 Project 220 0.40 88 Roeger 4/11/2018 Project 220 3.40 748 Roeger 4/11/2018 Project 220 1.40 308 Roeger 4/11/2018 Project 220 1.00 220 Roeger 4/12/2018 Project 220 0.35 77 Roeger 4/12/2018 Project 220 0.70 154 Roeger 4/13/2018 Project 220 0.90 198 Project Total 3,951 Publishing&printing 0 Mileage 0 TOTAL invoice amount 8,693 INVOICE 1160-043018 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 May 3,2018 Professional services through April 30,2018,in connection with: Budget Consultation Special census requirements,Homeplace population determination, $ 869 Cable Franchise Fee follow-up,budget report for chief of staff, follow-up on 2018-2019 budget comparison,SBOA audit of grant Legislation Provide information regarding commuter tax,draft legislation for 1,336 alternative allocation of LIT,alternative LIT language LOIT Analysis LIT supplemental deposit into General fund and follow-up 500 Plan Review and determine status of CRC special reserve,GAAP 2,309 projection,retiree health follow-up Project Gas tax monies and cable franchise fees,follow-up on annexation population,census population follow-up,City special census 2,222 Out of pocket expense - Total amount of this invoice. 7,236 Previous balance. 31,672 Payment received. - Total amount due. $ 38,908 Call(317)844-4605 with questions CITY OF CARMEL May 3,2018 Professional services through April 30,2018,in connection with: Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. Performina Service Service Date Services Provided Hourly Rate Total Coonrod 4/17/2018 Budget consultation 240 0.40 96 Coonrod 4/18/2018 Budget consultation 240 0.20 48 Roeger 4/19/2018 Budget consultation 220 0.45 99 Coonrod 4/23/2018 Budget consultation 240 0.90 216 Coonrod 4/24/2018 Budget consultation 240 0.25 60 Roeger 4/24/2018 Budget consultation 220 0.50 110 Coonrod 4/25/2018 Budget consultation 240 1.00 240 Budget Consultation Total 869 Coonrod 4/16/2018 Legislation 240 1.55 372 Coonrod 4/16/2018 Legislation 240 1.65 396 Bahler 4/18/2018 Legislation 100 3.40 340 Coonrod 4/23/2018 Legislation 240 0.95 228 Legislation Total 1,336 Coonrod 4/19/2018 LOIT Analysis 240 1.35 324 Roeger 4/20/2018 LOIT Analysis 220 0.80 176 LOIT Analysis Total Soo Coonrod 4/17/2018 Plan 240 0.85 204 Coonrod 4/20/2018 Plan 240 1.85 444 Coonrod 4/23/2018 Plan 240 2.15 516 Roeger 4/24/2018 Plan 220 1.35 297 Coonrod 4/24/2018 Plan 240 2.00 480 Coonrod 4/25/2018 Plan 240 1.00 240 Coonrod 4/26/2018 Plan 240 0.20 48 Coonrod 4/27/2018 Plan 240 0.15 36 Roeger 4/30/2018 Plan 220 0.20 44 Plan Total 2,309 Roeger 4/16/2018 Plan 220 2.00 440 Roeger 4/16/2018 Plan 220 1.50 330 Roeger 4/17/2018 Plan 220 3.00 660 Roeger 4/20/2018 Plan 220 0.80 176 Roeger 4/20/2018 Plan 220 0.25 55 Roeger 4/23/2018 Plan 220 1.55 341 Roeger 4/23/2018 Plan 220 0.25 55 Roeger 4/24/2018 Plan 220 0.25 55 Roeger 4/24/2018 Plan 220 0.50 110 Plan Total 2,222 Publishing&printing 0 Mileage 0 TOTAL invoice amount 7,236