The URL can be used to link to this page

Home My WebLink About328034 07/25/18 CITY OF CARMEL, INDIANA VENDOR: 071300 {; ONE CIVIC SQUARE C. L. COONROD & COMPANY CHECK AMOUNT: $****35,671.00* CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 328034 9�'1rsN�O SUITE 225 CHECK DATE: 07/25/18 INDIANAPOLIS IN 46240 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4341999 101207 1150063018 8,763.00 CAFR-RELATED ACCOUNTI 1160 4341999 101207 1150071518 8,280.00 CAFR-RELATED ACCOUNTI 1160 4340303 101208 1160063018, 8,413.00 PROFESSIONAL ACCOUNTI 1160 4340303 101208 1160071518 10,215.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 $17,043.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-063018 43-419.99 $8,763.00 1 hereby certify that the attached invoice(s),or 7/6/18 1150-063018 $8,763.00 1160 101 1160 101 101207 1150-071518 43-419.99 $8,280.00 bill(s)is(are)true and correct and that the 7/17/18 1150-071518 $8,280.00 1160 101 materials or services itemized thereon for 1160 101 which charge is made were ordered and received except Monday,July 23,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-063018 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 July 6,2018 Professional services through June 30,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-Utility disclosure,audit committee follow-up,SBOA adjustments on immaterial matters,questions on utilities,follow-up on SBOA past due schedule, revise utility statements,other SBOA delays,utility refunding disclosure,capital assets, data reivsions. 8,763 Total amount of this invoice. 8,763 Previous balance. $ 18,026 Payment received. - Total amount due. $ 26,789 Call(317)844-4605 with questions CITY OF CARMEL July 6,2018 For Professional Services through June 30,2018 in connection with Performing Service Service Date Services Provided Hourly Rate Hours Total Lilly 6/18/2018 Work outside scope 175 3.20 560 Roeger 6/18/2018 Work outside scope 220 0.60 132 Coonrod 6/18/2018 Work outside scope 240 1.15 276 Roeger 6/19/2018 Work outside scope 220 0.20 44 Lilly 6/20/2018 Work outside scope 175 3.40 595 Lilly 6/22/2018 Work outside scope 175 3.65 639 Coonrod 6/22/2018 Work outside scope 240 0.50 120 Lilly 6/25/2018 Work outside scope 175 4.10 718 Coonrod 6/26/2018 Work outside scope 240 5.15 1,236 Coonrod 6/26/2018 Work outside scope 240 3.55 852 Lilly 6/27/2018 Work outside scope 175 1.55 271 Coonrod 6/27/2018 Work outside scope 240 0.10 24 Lilly 6/28/2018 Work outside scope 175 5.45 954 Coonrod 6/28/2018 Work outside scope 240 3.10 744 Lilly 6/29/2018 Work outside scope 175 5.70 998 Coonrod 6/29/2018 Work outside scope 240 2.50 600 Work outside scope Total -8,763 Publishing&printing 0 Mileage 0 TOTAL invoice amount 8,763 INVOICE 1150-071518 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 July 17,2018 Professional services through July 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 disclosure for water utility refinance,follow-up on auditor delays,review disclosure for IWC refinance transaction,immaterial adjustments from SBOA,enter revised ledger and capital assets data,utility disclosure and stormwater capital asset updates. 8,280 Total amount of this invoice. 8,280 Previous balance. $ 14,697 Payment received. 5,934 Total amount due. $ 17,043 Call(317)844-4605 with questions CITY OF CARMEL July 6,2018 For Professional Services through June 30,2018 in connection with Performing Service Service Date Services Provided Hourly Rate Hours Total Lilly 7/3/2018 Work outside scope 175 2.80 490 Coonrod 7/3/2018 Work outside scope 240 0.65 156 Lilly 7/5/2018 Work outside scope 175 6.20 1,085 Coonrod' 7/5/2018 Work outside scope 240 3.30 792 Lilly 7/6/2018 Work outside scope 175 7.30 1,278 Coonrod 7/6/2018 Work outside scope 240 3.75 900 Lilly 7/9/2018 Work outside scope 175 8.20 1,435 Coonrod 7/9/2018 Work outside scope 240 1.30 312 Lilly 7/12/2018 Work outside scope 175 4.10 718 Lilly 7/12/2018 Work outside scope 175 0.65 114 Coonrod 7/12/2018 Work outside scope 240 0.30 72 Lilly 7/13/2018 Work outside scope 175 4.90 858 Bahler 7/13/2018 Work outside scope 100 0.70 70 Work outside scope Total 8,280 Publishing&printing 0 Mileage 0 TOTAL invoice amount 8,280 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 $18,628.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-063018 43-403.03 $8,413.00 1 hereby certify that the attached invoice(s),or 7/6/18 1160-063018 $8,413.00 1160 101 1160 101 101208 1160-071518 43-403.03 $10,215.00 bill(s)is(are)true and correct and that the 7/17/18 1160-071518 $10,215.00 1160 101 materials or services itemized thereon for 1160 101 which charge is made were ordered and received except Monday,July 23,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-063018 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 July 6,2018 Professional services through June 30,2018,in connection with: Bond/Lease Update GAAP projection in fiscal plan and explain changes, $ 2,458 respond to questions regarding OPEB,review bond presentation in fiscal plan,CIP regarding bond issuance,schedule of construction. Budget Consultation Budget follow-up items,St.Vincent rezone,analysis of parks 1,605 projection,2019 budget matters. Pensions Respond to question regarding actuarial report. 24 Plan Capital imrpovement plan updates,Parks and Recreation plan 2,595 assistance and analysis. Project Parks and Recreation capital improvements and follow-up, 1,721 Food and Beverage tax follow-ups Out of pocket expense 10 Total amount of this invoice. 8,413 Previous balance. $ 12,092 Payment received. - Total amount due. $ 20,505 Call(317)844-4605 with questions CITY OF CARMEL Jury 6,2018 Professional services through June 30,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 6/19/2018 Bond/Lease 240 1.20 288 Coonrod 6/20/2018 Bond/Lease 240 0.50 120 Coonrod 6/21/2018 Bond/Lease 240 3.15 756 Coonrod 6/21/2018 Bond/Lease 240 1.40 336 Coonrod 6/22/2018 Bond/Lease 240 0.60 144 Roeger 6/25/2018 Bond/Lease 220 0.30 66 Roeger 6/27/2018 Bond/Lease 220 0.60 132 Roeger 6/27/2018 Bond/Lease 220 1.80 396 Roeger 6/28/2018 Bond/Lease 220 1.00 220 Bond/Lease Total 2,458 Roeger 6/18/2018 Budget Consultation 220 1.20 264 Coonrod 6/18/2018 Budget Consultation 240 0.15 36 Roeger 6/18/2018 Budget Consultation 220 0.55 121 Roeger 6/19/2018 Budget Consultation 220 0.20 44 Coonrod 6/20/2018 Budget Consultation 240 1.10 264 Roeger 6/21/2018 Budget Consultation 220 0.80 176 Lilly 6/21/2018 Budget Consultation 175 1.75 306 Roeger 6/25/2018 Budget Consultation 220 0.30 66 Lilly 6/28/2018 Budget Consultation 175 1.75 306 Roeger 6/29/2018 Budget Consultation 220 0.10 22 Budget Consultation Total 1,605 Coonrod 6/21/2018 Pensions 240 0.10 24 Pensions Total 24 Coonrod 6/18/2018 Plan 240 1.80 432 Roeger 6/19/2018 Plan 220 0.75 165 Coonrod 6/19/2018 Plan 240 3.50 840 Roeger 6/20/2018 Plan 220 1.50 330 Coonrod 6/22/2018 Plan 240 1.50 360 Coonrod 6/27/2018 Plan 240 1.15 276 Coonrod 6/28/2018 Plan 240 0.80 192 - Plan Total 2,595 Roeger 6/18/2018 Plan 220 1.75 385 Roeger 6/19/2018 Plan 220 1.00 220 Roeger 6/19/2018 Plan 220 0.60 132 Coonrod 6/20/2018 Plan 240 0.10 24 Coonrod 6/22/2018 Plan 240 2.40 576 Bahler 6/27/2018 Plan 100 1.75 175 Roeger 6/28/2018 Plan 220 0.95 209 Project Total 1,721 Publishing&printing 0 Mileage 10 TOTAL invoice amount 8,413 INVOICE 1160-071518 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 July 17,2018 Professional services through July 15,2018,in connection with: Bond/Lease SBOA follow-up,SBOA questions regarding allowability of RDA $ 2,106 lease transactions and payments for non-complete assets,OPEB issues,fiscal plan GAAP projections,GAAP projection in fiscal plan and explanations for GAAP numbers. Budget Consultation Parks and recreation follow-up,2019 budget follow-up,budget 1,732 and property tax collection numbers,questions regarding Carmel commercial tax base and analysis,property tax follow-up. Plan Parks and Recreation analyses,plan analysis,Parks projection 1,760 and review of salary studies for parks and city. Project Food and Beverage tax follow-ups and research,parks follow-ups, 4,617 parks budget matters. Out of pocket expense Total amount of this invoice. 10,215 Previous balance. $ 18,697 Payment received. (10,284) Total amount due. $ 18,628 Call(317)844-4605 with questions CITY OF CARMEL July 17,2018 Professional services through July 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 Lilly 7/2/2018 Bond/Lease 175 1.45 254 Roeger 7/2/2018 Bond/Lease 220 1.60 352 Coonrod 7/2/2018 Bond/Lease 240 1.00 240 Coonrod 7/3/2018 Bond/Lease 240 2.20 528 Coonrod 7/9/2018 Bond/Lease 240 0.40 96 Coonrod 7/10/2018 Bond/Lease 240 1.35 324 Coonrod 7/12/2018 Bond/Lease 240 0.50 120 Coonrod 7/13/2018 Bond/Lease 240 0.80 192 Bond/Lease Total 2,106 Roeger 7/3/2018 Budget Consultation 220 0.70 154 Lilly 7/5/2018 Budget Consultation 175 1.75 306 Roeger 7/9/2018 Budget Consultation 220 0.80 176 Roeger 7/9/2018 Budget Consultation 220 0.25 55 Roeger 7/9/2018 Budget Consultation 220 1.80 396 Coonrod 7/9/2018 Budget Consultation 240 0.15 36 Roeger 7/10/2018 Budget Consultation 220 1.05 231 Coonrod 7/12/2018 Budget Consultation 240 0.30 72 Lilly 7/12/2018 Budget Consultation 175 1.75 306 Budget Consultation Total 1,732 Coonrod 7/2/2018 Plan 240 2.45 588 Lilly 7/5/2018 Plan 175 1.35 236 Coonrod 7/5/2018 Plan 240 0.70 168 Coonrod 7/10/2018 Plan 240 1.15 276 Coonrod 7/11/2018 Plan 240 2.05 492 Plan Total 1,760 Roeger 7/2/2018 Project 220 1.50 330 Roeger 7/2/2018 Project 220 0.80 176 Bahler 7/3/2018 Project 100 1.35 135 Roeger 7/5/2018 Project 220 2.10 462 Bahler 7/9/2018 Project 100 0.85 85 Coonrod 7/9/2018 Project 240 0.20 48 Roeger 7/11/2018 Project 220 4.65 1,023 Lilly 7/12/2018 Project 175 0.40 70 Roeger 7/12/2018 Project 220 2.65 583 Roeger 7/12/2018 Project 220 2.00 440 Roeger 7/13/2018 Project 220 4.00 880 Roeger 7/13/2018 Project 220 1.75 385 Project Total 4,617 Publishing&printing 0 Mileage 10 TOTAL Invoice amount 10,215