The URL can be used to link to this page

Home My WebLink About303969 10/10/16 ,�a,ur..4�q'wF J� .,. - CITY OF CARMEL, INDIANA VENDOR: 071300 '' ONE CIVIC SQUARE C L COONROD &COMPANY CHECK AMOUNT: $..•'15,269.00' •4q\ ,�: CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE#225 CHECK NUMBER: 303969 '�'��r6ri"�°' INDIANAPOLIS IN 46240 CHECK DATE: 10/10/16 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1701 4340300 0816A 15,269.00 ACCOUNTING FEES VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) C L COONROD &COMPANY ALLOWED 20 ACCOUNTS PAYABLE VOUCHER 3850 PRIORITY WAY SOUTH DRIVE#225 IN SUM OF$ CITY OF CARMEL An invoice or bill to be properly itemized must show:kind of service,where performed,dates service INDIANAPOLIS, IN 46240 rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. $15,269.00 Payee Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Clerk Treasurer 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 0816a 43-403.00 $15,269.00 1 hereby certify that the attached invoice(s),or 8/22/16 0816a Budget Consulting $15,269.00 1701 101 1701 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, October 04,2016 e�� Linda Harvey Chief Deputy Clerk Treasurer 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 0816a P.O.33612 Hon.Christine Pauley Clerk-Treasurer,City of Carmel Attn: Christine Pauley 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 22,2016 Professional services from July 29 through August 21,2016,in connection with: Budget Consulting-2017 budgeting and transfer of appropriations. 44 CAFR-explain to auditors and further document COIT estimate,explain to auditors 15,220 the internal balances,complete MM&A based on statements that include actuarial values,review with GFOA checklist,respond to questions regarding trust cash reconciliations;respond to questions about differences between ledger and actuary report,explain OPEB entry in governmental and business activities;additional pension information not necessarily required,respond to questions about pensions and OPEB, additional pension disclosures requested by auditors previously considered optional or immaterial;assist auditors in understanding pension entries;respond to comments regarding pension disclosures,reclassify investment income on cash flow statement prepared by other accountants in order to meet GFOA checklist requirement;reconcile actuarial pension expense to general ledger at auditors'request,identify discrepancies between actuary and ledger data to assist auditors;respond to question regarding how the actuary rolled forward information from the measurement date to year end, reconciliation of pension expenses per actuary to City financials,PERF numbers support,investigate variance between ledger and actuary report for civilian PERF, follow up on pension obligations,assist with cap lease information,revise CAFR Financial Section for revised actuarial report for'25 and'37 plans:fiduciary net position equal to the ledger,alignment adjustments to verbiage throughout document, update Basic Financial Statements for revised actuarial reports,respond to questions from auditors regarding utility statements;respond to questions regarding CIP, alignment,formatting of document,investigate and explain treatment of CAB's by utilities. Out of pocket expense-travel to client meeting to discuss CAFR 5 Total amount of this invoice. 15,269 Previous balance. - Payment received. - Total amount due. $ 15,269 Payable upon receipt. Call(317)844-4605 with questions. Lilly 8/10/2016 CAFR/GAAP , 155 3.10 481 Roeger 8/10/2016 CAFR/GAAP 220 0.75 165 Coonrod 8/10/2016 . CAFR/GAAP 240 1.20 288 Lilly 8/11/2016 CAFR/GAAP 155 2.40 372 Coonrod 8/11/2016 CAFR/GAAP 240 1.45 348 Coonrod 8/11/2016 CAFR/GAAP 240 0.40 96 Lilly 8/12/2016 CAFR/GAAP 155 1.80 279 Lilly 8/13/2016 CAFR/GAAP 155 3.20 496 Lilly 8/14/2016 CAFR/GAAP 155 9.25 1,434 Coonrod 8/15/2016 CAFR/GAAP 240 0.05 12 Hibler 8/16/2016 CAFR/GAAP 80 2.05 164 Coonrod 8/16/2016 CAFR/GAAP 240 1.05 252 Roeger 8/16/2016 CAFR/GAAP 220 1.10 242 Coonrod 8/16/2016 CAFR/GAAP 240 1.65 396 Hibler 8/17/2016 CAFR/GAAP 80 0.60 48 Hibler 8/18/2016 CAFR/GAAP 80 1.25 100 Coonrod 8/19/2016 CAFR/GAAP 240 0.65 156 CAFR/GAAP Total 15,220 Documentation/Meeting 0 Mileage 5 TOTAL invoice amount 15,269 CITY OF CARMEL August 22,2016 Professional services from July 29 through August 21,2016, 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 Roeger 8/15/2016 Budget Consulting 220 0.20 44 Budget Consulting Total 44 Lilly 7/29/2016 CAFR/GAAP 155 2.50 388 Hibler 7/29/2016 CAFR/GAAP 80 0.15 12 Coonrod 7/29/2016 CAFR/GAAP 240 1.70 408 Coonrod 7/30/2016 CAFR/GAAP 240 1.00 240 Lilly 7/31/2016 CAFR/GAAP 155 4.20 651 Coonrod 7/31/2016 CAFR/GAAP 240 2.05 492 Lilly 8/1/2016 CAFR/GAAP 155 1.85 286 Coonrod 8/1/2016 CAFR/GAAP 240 1.00 240 Coonrod 8/1/2016 CAFR/GAAP 240 1.00 240 Hibler 8/1/2016 CAFR/GAAP 80 0.15 12 Roeger 8/1/2016 CAFR/GAAP 220 0.45 99 Lilly 8/2/2016 CAFR/GAAP 155 2.35 364 Coonrod 8/2/2016 CAFR/GAAP 240 1.05 252 Lilly 8/3/2016 CAFR/GAAP 155 2.80 434 Coonrod 8/3/2016 CAFR/GAAP 240 1.00 240 Hibler 8/4/2016 CAFR/GAAP 80 1.45 116 Coonrod 8/4/2016 CAFR/GAAP 240 1.45 348 Coonrod 8/4/2016 CAFR/GAAP 240 0.45 108 Lilly 8/5/2016 CAFR/GAAP 155 2.15 333 Coonrod 8/5/2016 CAFR/GAAP 240 2.64 633 Lilly 8/6/2016 CAFR/GAAP 155 2.10 326 Coonrod 8/6/2016 CAFR/GAAP 240 0.30 72 Coonrod 8/6/2016 CAFR/GAAP 240 1.50 360 Coonrod 8/7/2016 CAFR/GAAP 240 2.75 660 Lilly 8/8/2016 CAFR/GAAP 155 1.90 295 Roeger 8/8/2016 CAFR/GAAP 220 3.35 737 Roeger 8/8/2016 CAFR/GAAP 220 2.30 506 Roeger 8/8/2016 CAFR/GAAP 220 0.50 110 Coonrod 8/8/2016 CAFR/GAAP 240 1.70 408 Lilly 8/9/2016 CAFR/GAAP 155 2.60 403 Roeger 8/9/2016 CAFR/GAAP 220 0.50 110 Hibler 8/9/2016 CAFR/GAAP 80 0.10 8