Loading...
HomeMy WebLinkAbout308059 02/13/17 �f Cqq. %` ''4'•: CITY OF CARMEL, INDIANA VENDOR: 071300 y; .;; ® ai• ONE CIVIC SQUARE C L COONROD &COMPANY CHECK AMOUNT: $""26,833.00' ;_�; CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE#225 CHECK NUMBER: 308059 9q;�__� INDIANAPOLIS IN 46240 CHECK DATE: 02/13/17 �roN�O' DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4340303 34499 0117B 26,833.00 ACCTG SERVICES FOR 20 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#225 An invoice or bill to be properly itemized must show:kind of service,where performed,dates service rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. INDIANAPOLIS, IN 46240 Payee $26,833.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 34499 0117B 43-403.03 $26,833.00 l hereby certify that the attached invoice(s),or 2/3/17 01178 $26,833.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 Tuesday, February 07,2017 Kibbe, Sharon Executive Office Manager 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 0117-B P.O.34499 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 3,2017 Professional services from January 16 through January 31,2017,in connection with: Accounting System-budget matters,supplemental Medicaid reimbursement follow up. 73 Additional Appropriation-follow up on public hearing,pint and take copies of 181 Additional appropriation to C-T office. Budget Consultation-follow up on year-end accounting items,cable franchise fee 7,523 follow up,budget matters,follow up on utility management fees,review progress,plan, email regarding confirmation of appropriation on Council meeting agenda,follow up on 2017 budget, 1782 Notice-preparation for finance committee meeting, 1782 Notice response,attend finance committee meeting,budget restoration items,prepare tax comparison,review of 1782 Notice letter and email,review response to 1782 Notice- prepare comparison as requested. 2015 CAFR/GAAP-respond to schedule question from auditors-respond to C-T 139911 question regarding MD&A;request Letter of Transmittal pages,follow up on capital assets progress-final review of governmental section of CAFR-respond to actuaries, coordinate schedule with SBOA-comments by C-T regarding schedule-clarify schedule with SBOA-respond to auditor comment regarding capital leases-emails regarding details of capital assets reconciliation and differences,call from Council member regarding capital assets progress and transmittal letter-follow-up on letter of transmittal-final review of CAFR-meeting with utility staff and capital assets consultants-review and revise letter of transmittal draft and arrange for completion, work on CAFR final review updates,respond to comments by auditors on utility statements,completion of transmittal letter,finalize utility statements,finalize MD&A with utility information,utility statement adjustment suggested by auditors-final check of internal referencing,prepare final CAFR version,disclose different capitalization policy of utilities-client question regarding frequency of actuarial studies-final review- open GFOA checklist items,finalize document,print document for Council meeting. Fiscal Plan-update and review plan,report year-end results,plan matters. 2,269 Other Consulting-phone calls and emails to administrative and senior staff,meetings, 2,738 correspondence to administrative and senior staff,email follow up,follow up on worker comp insurance matters through insurance company. Out of pocket expense-mileage 138 Total amount of this invoice. 26,833 Previous balance. 43,438 Payment received. (26,455) Total amount due. $ 43,816 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL February 3,2017 Professional services from January 16 through January 31,2017,in connection with: Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. Performinct Service Service Date Services Provided Hourly Rate Total Roeger 1/19/2017 Accounting System 220 0.15 33 Roeger 1/25/2017 Accounting System 220 0.10 22 Lilly 1/27/2017 Accounting System 175 0.10 18 Accounting System Total 73 Coonrod 1/20/2017 Additional Appropriations 240 0.35 84 Coonrod 1/26/2017 Additional Appropriations 240 0.05 12 Hibler 1/27/2017 Additional Appropriations 155 0.55 85 Additional Appropriations Total 181 Roeger 1/16/2017 Budget Consultation 220 2.50 550 Roeger 1/17/2017 Budget Consultation 220 2.25 495 Roeger 1/17/2017 Budget Consultation 220 0.80 176 Roeger 1/18/2017 Budget Consultation 220 2.75 605 Coonrod 1/18/2017 Budget Consultation 240 0.10 24 Coonrod 1/18/2017 Budget Consultation 240 0.45 108 Roeger 1/18/2017 Budget Consultation 220 1.00 220 Lilly 1/19/2017 Budget Consultation 175 1.75 306 Roeger 1/20/2017 Budget Consultation 220 1.20 264 Roeger 1/23/2017 Budget Consultation 220 1.25 275 Roeger 1/23/2017 Budget Consultation 220 2.50 550 Roeger 1/23/2017 Budget Consultation 220 0.30 66 Hibler 1/24/2017 Budget Consultation 155 0.05 8 Coonrod 1/25/2017 Budget Consultation 240 0.35 84 Lilly 1/26/2017 Budget Consultation 175 1.75 306 Roeger 1/27/2017 Budget Consultation 220 0.15 33 Roeger 1/30/2017 Budget Consultation 220 0.40 88 Roeger 1/30/2017 Budget Consultation 220 2.00 440 Roeger 1/30/2017 Budget Consultation 220 0.65 143 Roeger 1/30/2017 Budget Consultation 220 1.05 231 Coonrod 1/30/2017 Budget Consultation 240 2.55 612 Roeger 1/30/2017 Budget Consultation 220 0.95 209 Coonrod 1/30/2017 Budget Consultation 240 2.1 504 Roeger 1/31/2017 Budget Consultation 220 0.15 33 Roeger 1/31/2017 Budget Consultation 220 1.70 374 Lilly 1/31/2017 Budget Consultation 175 0.50 88 Hibler 1/31/2017 Budget Consultation 155 0.20 31 Roeger 1/31/2017 Budget Consultation 220 1.75 385 Roeger 1/31/2017 Budget Consultation 220 0.45 99 Coonrod 1/31/2017 Budget Consultation 240 0.90 216 Budget Consultation Total 7,523 Lilly 1/17/2017 CAFR/GAAP 175 0.65 114 Coonrod 1/17/2017 CAFR/GAAP 240 0.30 72 Coonrod 1/17/2017 CAFR/GAAP 240 0.40 96 Coonrod 1/17/2017 CAFR/GAAP 240 2.30 552 Coonrod 1/18/2017 CAFR/GAAP 240 1.25 300 Lilly 1/19/2017 CAFR/GAAP 175 3.55 621 Coonrod 1/19/2017 CAFR/GAAP 240 3.20 768 Lilly 1/20/2017 CAFR/GAAP 175 3.65 639 Hibler 1/20/2017 CAFR/GAAP 155 2.70 419 Hibler 1/20/2017 CAFR/GAAP 155 2.60 403 Coonrod 1/20/2017 CAFR/GAAP 240 0.85 204 Coonrod 1/20/2017 CAFR/GAAP 240 2.20 528 Lilly 1/23/2017 CAFR/GAAP 175 3.60 630 Hibler 1/23/2017 CAFR/GAAP 155 0.15 23 Coonrod 1/23/2017 CAFR/GAAP 240 2.30 552 Coonrod 1/23/2017 CAFR/GAAP 240 0.50 120 Lilly 1/24/2017 CAFR/GAAP 175 5.15 901 Lilly 1/24/2017 CAFR/GAAP 175 1.95 341 Coonrod 1/24/2017 CAFR/GAAP 240 4.40 1,056 Lilly 1/25/2017 CAFR/GAAP 175 1.30 228 Lilly 1/25/2017 CAFR/GAAP 175 4.05 708 Coonrod 1/25/2017 CAFR/GAAP 240 2.70 648 Lilly 1/26/2017 CAFR/GAAP 175 5.30 927 Coonrod 1/26/2017 CAFR/GAAP 240 3.40 816 Lilly 1/27/2017 CAFR/GAAP 175 4.65 813 Coonrod 1/27/2017 CAFR/GAAP 240 3.70 888 Lilly 1/30/2017 CAFR/GAAP 175 2.70 473 Coonrod 1/30/2017 CAFR/GAAP 240 0.10 24 Hibler 1/30/2017 CAFR/GAAP 155 0.30 47 CAFR/GAAP Total 13,911 Coonrod 1/17/2017 Plan 240 1.00 240 Roeger 1/18/2017 Plan 220 1.00 220 Coonrod 1/18/2017 Plan 240 1.15 276 Coonrod 1/19/2017 Plan 240 0.05 12 Coonrod 1/23/2017 Plan 240 0.60 144 Roeger 1/24/2017 Plan 220 1.60 352 Roeger 1/24/2017 Plan 220 0.85 187 Coonrod 1/24/2017 Plan 240 0.50 120 Coonrod 1/25/2017 Plan 240 0.70 168 Roeger 1/25/2017 Plan 220 1.20 264 Roeger 1/26/2017 Plan 220 1.30 286 Plan Total 2,269 Engelking 1/17/2017 Other Consulting 150 1.00 150 Engelking 1/17/2017 Other Consulting 150 1.00 150 Engelking 1/18/2017 Other Consulting 150 3.50 525 Engelking 1/19/2017 Other Consulting 150 1.00 150 Engelking 1/20/2017 Other Consulting 150 1.00 150 Engelking 1/23/2017 Other Consulting 150 1.00 150 Engelking 1/24/2017 Other Consulting 150 2.50 375 Engelking 1/25/2017 Other Consulting 150 1.50 225 Engelking 1/26/2017 Other Consulting 150 0.50 75 Engelking 1/27/2017 Other Consulting 150 0.75 113 Engelking 1/30/2017 Other Consulting 150 2.00 300 Engelking 1/31/2017 Other Consulting 150 2.50 375 Other Consulting Total 2,738 Publishing&printing 138 Mileage 0 TOTAL invoice amount 26,833