The URL can be used to link to this page

Home My WebLink About326706 06/29/18 CITY OF CARMEL, INDIANA VENDOR: 071300 ONE CIVIC SQUARE C. L. COONROD &COMPANY CHECK AMOUNT: $****34,075.00* CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 326706 �"lioN c� SUITE 225 CHECK DATE: 06/29/18 INDIANAPOLIS IN 46240 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4341999 101207 1150053118 12,092.00 CAFR-RELATED ACCOUNTI 1160 4341999 101207 1150061518 5,934.00 CAFR-RELATED ACCOUNTI 1160 4340303 101208 1160053118 5,765.00 PROFESSIONAL ACCOUNTI 1160 4340303 101208 1160061518 10,284.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 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, IN46240 Payee $18,026.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-053118 43-419.99 $12,092.00 I hereby certify that the attached invoice(s),or 6/11/18 1150-053118 $12,092.00 1160 101 1160 101 101207 1150-061518 43-41.9.99 $5,934.00 bill(s)is(are)true and correct and that the 6/18/18 1150-061518 $5,934.00 1160 1 101 1 materials or services itemized thereon for 1160 1 101 which charge is made were ordered and received except Thursday,June 21,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-053118 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 June 11,2018 Professional services through May 31,2018,in connection with: 2017 CAFR: Response to Auditors $ _ Subtotal Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17, 2017($70,040). Work outside scope-Follow-up on 2016 GFOA utility comments,follow-up items for 2015 CAFR,assemble bank reconciliation check list,roll-forward prior year actuarial study,Audit committee responses,Pension actuarial,prep for meeting with SBOA on immaterial items,follow-up on utility statements,immaterial adjustments and revisions to ledger,changes per Audit Committee,adjustments to water cash flow,GFOA extension request 12,092 Total amount of this invoice. 12,092 Previous balance. 3,941 Payment received. 3,941 Total amount due. $ 12,092 Call(317)844-4605 with questions 1 CITY OF CARMEL May 18,2018 For Professional Services through May 15,2018 in connection with Performing Service Date Services Provided Hourly Rate Hours Total Service Coonrod 5/16/2018 Work outside scope 240 1.10 264 Coonrod 5/16/2018 Work outside scope 240 0.40 96 Lilly 5/17/2018 Work outside scope 175 0.50 88 Roeger 5/17/2018 Work outside scope 220 1.00 220 Coonrod 5/17/2018 Work outside scope 240 0.25 60 Lilly 5/18/2018 Work outside scope 175 1.85 324 Coonrod 5/18/2018 Work outside scope 240 0.80 192 Lilly 5/21/2018 Work outside scope 175 1.55 271 Coonrod 5/21/2018 Work outside scope 240 0.80 192 Lilly 5/22/2018 Work outside scope 175 3.60 630 Coonrod 5/22/2018 Work outside scope 240 0.55 132 Lilly 5/23/2018 Work outside scope 175 6.55 1,146 Coonrod 5/23/2018 Work outside scope 240 4.20 1,008 Lilly 5/24/2018 Work outside scope 175 3.40 595 Coonrod 5/24/2018 Work outside scope 240 4.00 960 Lilly 5/25/2018 Work outside scope 175 4.70 823 Coonrod 5/25/2018 Work outside scope 240, 3.40 816 Coonrod 5/29/2018 Work outside scope 240 3.10 744 Lilly 5/29/2018 Work outside scope 175 4.15 726 Lilly 5/30/2018 Work outside scope 175 3.20 560 Coonrod 5/30/2018 Work outside scope 240 4.55 1,092 Lilly 5/31/2018 Work outside scope 175 1.10 193 Coonrod 5/31/2018 Work outside scope 240 0.70 168 Coonrod 5/31/2018 Work outside scope 240 3.30 792 Work outside scope Total 12,092 Publishing&printing 0 Mileage 0 TOTAL invoice amount 12,092 INVOICE 1150-061518 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 June 18,2018 Professional services through June 15,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-Prepare for audit committee;follow-up on utility statements, pension reports,actuary issues and ledger omitting agency fund transactions,follow-up on audit committee question regarding Water Utility cash deficit,immaterial item detail 5,934 Total amount of this invoice. 5,934 Previous balance. $ 12,092 Payment received. - Total amount due. $ 18,026 Call(317)844-4605 with questions CITY OF CARMEL May 18,2018 For Professional Services through May 15,2018 in connection with Performing Service Date Services Provided Hourly Rate Hours Total Service Lilly 6/4/2018 Work outside scope 175 1.95 341 Coonrod 6/4/2018 Work outside scope 240 0.05 12 Lilly 6/5/2018 Work outside scope 175 3.65 639 Coonrod 6/5/2018 Work outside scope 240 2.90 696 Lilly 6/6/2018 Work outside scope 175 7.10 1,243 Coonrod 6/6/2018 Work outside scope 240 5.75 1,380 Roeger 6/12/2018 Work outside scope 220 0.15 33 Coonrod 6/12/2018 Work outside scope 240 0.05 12 Lilly 6/13/2018 Work outside scope 175 1.25 219 Lilly 6/13/2018 Work outside scope 175 2.30 403 Coonrod 6/13/2018 Work outside scope 240 2.45 588 Lilly 6/14/2018 Work outside scope 175 2.10 368 Work outside scope Total 5,934 Publishing&printing 0 Mileage 0 TOTAL invoice amount 5,934 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,049.00 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Mayor's Office Terms Date Due e PO# ACCT.# DATE INVOICE# DESCRIPTION .DEPT# INVOICE# Fund# AMOUNT . Board Members DEPT#. FUND# . (or note attached invoice(s)or bill(s)) AMOUNT 101208 1160-053118 43403.03 $5,765.00 1 hereby certify that the attached invoice(s),or 6/11/18 1160-053118 $5,765.00 1160 101 1160 101 101208 1160-061518 43403.03 $10,284.00 bill(s)is(are)true and correct and that the 6/18/18 1160-061518 $10,284.00 1160 101 materials or services itemized thereon for 1160 101 which charge is made were ordered and received except Thursday,June 21,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 20Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer INVOICE 1160-061518 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 June 18,2018 Professional services through June 15,2018,in connection with: Additional Approprations Illinois Street land cash transfer,appropration follow-up $ 605 Bond/Lease Bond closing,COIT projections,Fiscal Plan updates regarding debt issuance,plan review 3,707 Budget Consultation 2019 budget progress,GAAP projection,budget follow-up, meeting with parks consultants,follow=up on St.Vincent project 4,217 Plan Meeting regarding parks projection,parks revenue options 1,249 Project Follow-up on City census population,parks plan 506 Out of pocket expense - Total amount of this invoice. 10,284 Previous balance. $ 5,765 Payment received. - Total amount due. $ 16,049 Call(317)8444605 with questions CITY OF CARMEL June 18,2018 5/21/2018 Professional services through June 15,2018,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 6/7/2018 Additional Appropration 240 0.40 96 Coonrod 6/11/2018 Additional Appropration 240 1.25 300 Roeger 6/12/2018 Additional Appropration 220 0.95 209 Appeal Total 605 Lilly 6/4/2018 Bond/Lease 175 1.80 315 Coonrod 6/4/2018 Bond/Lease 240 0.55 132 Coonrod 6/7/2018 Bond/Lease 240 0.20 48 Lilly 6/8/2018 Bond/Lease 175 2.25 394 Coonrod 6/8/2018 Bond/Lease 240 1.10 264 Roeger 6/11/2018 Bond/Lease 220 1.55 341 Roeger 6/12/2018 Bond/Lease 220 1.90 418 Roeger 6/13/2018 Bond/Lease 220 0.30 66 Roeger 6/13/2018 Bond/Lease 220 2.35 517 Coonrod 6/13/2018 Bond/Lease 240 0.05 12 Coonrod 6/14/2018 Bond/Lease 240 1.85 444 Coonrod 6/15/2018 Bond/Lease 240 3.15 756 Bond/Lease Total 3,707 Coonrod 6/1/2018 Budget Consultation 240 1.35 324 Lilly 6/5/2018 Budget Consultation 175 3.10 543 Roeger 6/5/2018 Budget Consultation 220 0.20 44 Roeger 6/5/2018 Budget Consultation 220 1.50 330 Lilly 6/7/2018 Budget Consultation 175 1.75 306 Coonrod 6/11/2018 Budget Consultation 240 2.50 600 Roeger 6/11/2018 Budget Consultation 220 2.00 440 Coonrod 6/13/2018 Budget Consultation 240 0.20 48 Roeger 6/14/2018 Budget Consultation 220 1.80 396 Lilly 6/14/2018 Budget Consultation 175 1.75 306 Roeger 6/15/2018 Budget Consultation 220 4.00 880 Budget Consultation Total 4,217 Coonrod 6/4/2018 Budget Consultation 240 0.35 84 Coonrod 6/4/2018 Budget Consultation 240 0.70 168 Roeger 6/4/2018 Budget Consultation 220 0.50 110 Roeger 6/4/2018 Budget Consultation 220 1.20 264 Coonrod 6/5/2018 Budget Consultation 240 1.45 348 Roeger 6/11/2018 Budget Consultation 220 1.25 275 Plan Total 1,249 Roeger 6/1/2018 Project 220 0.50 110 Roeger 6/12/2018 Project 220 1.80 396 Project Total 506 Publishing&printing 0 Mileage INVOICE 1160-053118 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 June 11,2018 Professional services through May 31,2018,in connection with: Appeal Questions regarding 2019 appeal,other budget items and follow-up $ 264 Bond/Lease Follow-up on OPEB concern,respond to request for documents regarding OPEB issue 1,528 Budget Consultation Review of 2019 budget status,supplemental Medicaid reimbursement, supplemental LIT distribution follow-up,tax collection update 3,387 LOIT Review supplemental distribution and follow-up 420 Plan Update Fiscal Plan based on LIT distributions 88 Project Follow-up on special census,Food and Beverage tax 33 Out of pocket expense-travel to meetings 45 Total amount of this invoice. 5,765 Previous balance. $ 17,105 Payment received. (17,105) Total amount due. $ 5,765 Call(317)844-4605 with questions r CITY OF CARMEL June 11,2018 5/21/2018 Professional services through May 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 5/22/2018 Appeal 240 1.10 264 Appeal Total 264 Lilly 5/17/2018 Bond/Lease 175 1.55 271 Coonrod 5/17/2018 Bond/Lease 240 1.95 468 Coonrod 5/21/2018 Bond/Lease 240 1.90 456 Lilly 5/21/2018 Bond/Lease 175 1.90 333 Bond/Lease Total 1,528 Lilly 5/16/2018 Budget Consultation 175 1.80 315 Coonrod 5/16/2018 Budget Consultation 240 2.00 480 Coonrod 5/17/2018 Budget Consultation 240 0.60 144 Lilly 5/17/2018 Budget Consultation 175 1.75 306 Coonrod 5/18/2018 Budget Consultation 240 0.35 84 Roeger 5/21/2018 Budget Consultation 220 0.40 88 Roeger 5/21/2018 Budget Consultation 220 3.00 660 Roeger 5/22/2018 Budget Consultation 220 1.05 231 Coonrod 5/22/2018 Budget Consultation 240 1.35 324 Roeger 5/22/2018 Budget Consultation 220 0.50 110 Lilly 5/24/2018 Budget Consultation 175 1.75 306 Roeger 5/29/2018 Budget Consultation 220 0.15 33 Lilly 5/31/2018 Budget Consultation 175 1.75 306 Budget Consultation Total 3,387 Coonrod 5/21/2018 LOIT 240 1.35 324 Coonrod 5/22/2018 LOIT 240 0.40 96 LOIT total 420 Roeger 5/29/2018 Plan 220 0.40 88 Plan Total 88 Roeger 5/31/2018 Project 220 0.15 33 Project Total 33 Publishing&printing 0 Mileage 45 TOTAL invoice amount 5,765