Loading...
HomeMy WebLinkAbout307581 01/27/17 (9, ) CITY OF CARMEL, INDIANA VENDOR: 071300 ONE CIVIC SQUARE C L COONROD& COMPANY CHECKAMOUNT: S"*'16,983.00" CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE 0225 CHECK NUMBER: 307581 INDIANAPOLIS IN 46240 CHECK DATE: 01/27/17 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4340303 34499 0117 16,983.00 ACCTG SERVICES FOR 20 ® 0 < « k k §� O B $ E % O & $ 2 2 G n 0 C 7 0 0 ■ > 2 0 n e n » 0 X 0 k kq V5 CA) 2 0 z / g k ƒ O # % ƒ 0 -n / D k 0 % k O o S -n > \ q ƒ ƒ T). § % k § �_ m © < T. a z 3 � 0 � a 2 a 2 ) f > -n O M \ / o a | � J a ■ 3 R - > k 0 k ƒ E E k g 7 A F i M \ § ° k k / 0 co 2 $ f } 3 f 3 i J r C— E - 0 SDCL§ m . E I / Cl) § % ¢ § & E E Q ± ; I § / : i k C) I { 5r £ / m -4 » S 5r2. E CL k 7 k ( N � ; ƒ %I / m § e a CD \ § \ g ` \$ i \ ) C7g Ck � \ 0 aMk ƒ 2 'R 20 KIcn _ § 0< a \ \ 0. j > X22 « \ ¢ -n � �k / o i > a7 nq a / k q ƒ § M g / / \ 2 / 7 \ = 0 m 3 \ 2 / # C % M \ § $/ M p B E 2 \ ƒ M # § m f CL } k @ © 7 m z \ \ C? / $ 2 / g M su OD § � ® k INVOICE 0117 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 January 18,2017 Professional services from January 1 through January 15,2017,in connection with: Accounting System-payroll management. 228 Additional Appropriation-Additional appropriation ordinance follow up,final review 1,062 of transfer ordinance,prep docs to council member and follow up on capital assets cost, follow on capital assets fees for CAFR;obtain estimate of annual cost,respond to question regarding adp,follow up on actuary engagement letter. Budget Consultation-Year-end accounting items,budget matters,update to fiscal plan 3,029 items,fixed asset capitalization policy replaced by new capital asset policy,month-end accounting items,budget follow up items. 2015 CAFR/GAAP-work on capital assets list,follow up on capital assets;receive new 5,972 capital assets data,evaluate,contact auditors regarding schedule,review utility numbers, prepare comparison to financial statements,evaluate new capital assets data-determine impact on utility income,evaluate materiality-lack of CII'in Water,capital assets for notes to financial statements,follow up on capital asset data,respond to Board of Accounts regarding schedule,follow up issues with utility capital assets-reconcile capital assets to statement of activities;and fund statements-capital assets statistical section-response from auditors-subsequent events disclosure,follow up on Sewer capital assets variances;update MD&A with new capital assets numbers,organizational chart changes. Clerical-updating of client file for 2017 8 Fiscal Plan-Year-end accounting items,work on corrections needed made to CIP 2,409 portion of plan,update,review CII',plan matters,update CIP,reconcile to official statements and to departmental plans,email city official regarding Streets department 2016 CIP. Other Consulting-census issues and follow-up,telephone class,emails,and 4,275 coordination of 2017insurance coverage,conference calls on census matters with field office,Governor's Council,call with City officials,correspondence production and review,completion of census matters,review of insurance claims,claims-meeting with City officials-processed correspondence,conversations with administrative staff and Mayor regarding replacement of senior staff member,emails and phone calls with senior staff members,meeting with potential senior staff candidate. Out of pocket expense-mileage - Total amount of this invoice. 16,983 Previous balance. 40,223 Payment received. (13,768) Total amount due. $ 43,438 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL January 18,2017 Professional services from January 1 through January 15,2017,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 Lilly 1/9/2017 Accounting System 175 1.30 228 Accounting System Total 228 Roeger 1/3/2017 Additional Appropriations 220 0.80 176 Coonrod 1/3/2017 Additional Appropriations 240 0.40 96 Coonrod 1/4/2017 Additional Appropriations 240 0.60 144 Lilly 1/10/2017 Additional Appropriations 175 0.40 70 Coonrod 1/10/2017 Additional Appropriations 240 0.90 216 Coonrod 1/11/2017 Additional Appropriations 240 0.30 72 Coonrod 1/12/2017 Additional Appropriations 240 1.20 288 Additional Appropriations Total 1,062 Roeger 1/2/2017 Budget Consultation 220 1.00 220 Roeger 1/4/2017 Budget Consultation 220 0.50 110 Roeger 1/4/2017 Budget Consultation 220 1.10 242 Roeger 1/4/2017 Budget Consultation 220 0.35 77 Lilly 1/5/2017 Budget Consultation 175 1.75 306 Roeger 1/6/2017 Budget Consultation 220 1.00 220 Roeger 1/6/2017 Budget Consultation 220 0.55 121 Roeger 1/9/2017 Budget Consultation 220 0.15 33 Roeger 1/9/2017 Budget Consultation 220 0.05 11 Roeger 1/9/2017 Budget Consultation 220 0.20 44 Lilly 1/9/2017 Budget Consultation 175 0.55 96 Roeger 1/10/2017 Budget Consultation 220 1.05 231 Lilly 1/12/2017 Budget Consultation 175 1.75 306 Roeger 1/12/2017 Budget Consultation 220 1.10 242 Roeger 1/12/2017 Budget Consultation 220 1.35 297 Roeger 1/13/2017 Budget Consultation 220 1.45 319 Roeger 1/13/2017 Budget Consultation 220 0.70 154 Budget Consultation Total 3,029 Coonrod 1/3/2017 CAFR/GAAP 240 0.20 48 Lilly 1/5/2017 CAFR/GAAP 175 3.60 630 Coonrod 1/5/2017 CAFR/GAAP 240 1.10 263 Lilly 1/6/2017 CAFR/GAAP 175 2.45 429 Coonrod 1/6/2017 CAFR/GAAP 240 1.25 300 Coonrod 1/6/2017 CAFR/GAAP 240 0.85 204 Lilly 1/9/2017 CAFR/GAAP 175 2.95 516 Coonrod 1/9/2017 CAFR/GAAP 240 3.15 756 Lilly 1/10/2017 CAFR/GAAP 175 2.25 394 Coonrod 1/10/2017 CAFR/GAAP 240 1.35 324 Lilly 1/11/2017 CAFR/GAAP 175 2.50 438 Coonrod 1/11/2017 CAFR/GAAP 240 2.10 504 Lilly 1/12/2017 CAFR/GAAP 175 1.45 254 Coonrod 1/12/2017 CAFR/GAAP 240 0.50 120 Coonrod 1/12/2017 CAFR/GAAP 240 0.85 204 Lilly 1/13/2017 CAFR/GAAP 175 1.30 228 Coonrod 1/13/2017 CAFR/GAAP 240 0.15 36 Coonrod 1/13/2017 CAFR/GAAP 240 1.35 324 CAFR/GAAP Total 5,972 Hibler 1/4/2017 Clerical 155 0.05 8 Clerical Total 8 Roeger 1/3/2017 Plan 220 1.00 220 Hibler 1/3/2017 Plan 155 0.50 77 Coonrod 1/4/2017 Plan 240 1.00 240 Roeger 1/4/2017 Plan 220 0.60 132 Roeger 1/5/2017 Plan 220 2.00 440 Coonrod 1/5/2017 Plan 240 2.15 516 Hibler 1/6/2017 Plan 155 0.10 16 Coonrod 1/10/2017 Plan 240 1.70 408 Coonrod 1/11/2017 Plan 240 1.10 264 Coonrod 1/12/2017 Plan 240 0.40 96 Plan Total 2,409 Engelking 12/27/2016 Other Consulting 150 2.50 375 Engelking 12/28/2016 Other Consulting 150 2.50 375 Engelking 12/29/2016 Other Consulting 150 3.50 525 Engelking 12/30/2016 Other Consulting 150 0.75 112 Engelking 1/3/2017 Other Consulting 150 1.50 225 Engelking 1/4/2017 Other Consulting 150 3.75 562 Engelking 1/5/2017 Other Consulting 150 1.50 225 Engelking 1/6/2017 Other Consulting 150 0.75 113 Engelking 1/9/2017 Other Consulting 150 0.75 113 Engelking 1/10/2017 Other Consulting 150 0.50 75 Engelking 1/11/2017 Other Consulting 150 4.00 600 Engelking 1/12/2017 Other Consulting 150 3.00 450 Engelking 1/13/2017 Other Consulting 150 2.50 375 Engelking 1/14/2017 Other Consulting 150 1.00 150 Other Consulting Total 4,275 Meal 0 Mileage 0 TOTAL invoice amount 16,983