Loading...
HomeMy WebLinkAbout307140 01/20/17 a"�"fit CITY OF CARMEL, INDIANA VENDOR: 071300 ONE CIVIC SQUARE C L COONROD&COMPANY CHECK AMOUNT: $****26,455.00* :� _� CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE#225 CHECK NUMBER: 307140 9INDIANAPOLIS IN 46240 CHECK DATE: 01/20/17 tj�ION� DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4340303 34499 12168 26,455.00 ACCTG SERVICES FOR 20 z % n < « /$ a Om m/ § 03 qq§ 2 zT o n / 0 q0 z c W 90 O § 0 - z R @ 2 0 / f / 2 � E 2 o CA r / / 0 0 n ■ m CA) e 2 < 0 PI) ® az \ > -n O oO $ E m ( 8 Z ° � c 0 k g / Q \ 0 E F m 2 $ » \ a - ; D 7 k O n � 7 - m f / k \ 7 C + - E C Cl) _ $ \ § & E E E I § k \ / M/ { k /\ CD o � § f f [ � w f E £ % o crC � ƒ \a CL cr j CD / § / 3 / D Cl) ) \ t \ } j3 c ° 0 CD a \ § k k k 03 _ m 0 k = C 2 / © � CL ( I ° W C) g� a£ f \ / T \fo % - � { 9 -n � $o & { 7 D �E g2 $ 2 k U 2 7 \ R F � n / ° a 0 a = ` - 0 / \ / z CD / \ C C CD CD m co / \ c , 3 § \ } \ r CL > \ \ § -N § R.§ 7 ) 8 ¥ \ INVOICE 1216-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 January 4,2017 Professional services from December 1 through December 31,2016,in connection with: Additional Appropriation-draft ordinance to move funds for GAAP statement and 792 audit,determine fees of actuaries,SBOA,and GFOA,obtain engagement letter from actuaries,GAAP statement transfer ordinance review. Appeal-respond to DLGF on appeal,preparation for Council meeting,attend meeting, 2,901 follow up on successful appeal. Budget Consultation-shortfall matters,shortfall follow up,follow up on General Fund 8,898 year-end cash,transfer ordinance,budget matters,ordinance review,review Council agenda,follow up on special census items,cash flow items,census population follow up, budget follow up items,respond to questions regarding reimbursements,appropriation follow up item. CAFR/GAAP-utility capital lease disclosure,reconciliation of utility accounts due in 6,908 more than one year,revise operating lease information;capitol assets received;follow up regarding information still needed,receive Capitol assets reports,review,follow up on capitol assets,follow up on Capitol assets report lack of beginning data-consult Council member-follow up with actuaries on 2016 engagement letter-consult asset consultant- email auditors regarding deadline,follow up-enterprise construction commitments, message Council member-consult GFOA regarding filing CAFR for in-house review, audit committee ordinance,preliminary planning on compensated absences,follow up on 2015 capital assets inventory,follow up on 2016 year-end accounting items, 2016compensated absences,follow upon capital assets,compare to utility statements, follow up with actuaries on 2016 studies,follow up on capital assets,review open items- send template of summaries needed for disclosure,review checklist items-new OPEB GASB statement. Legislation-review new regulations 108 LOIT Analysis-LOIT related follow up items 77 Pensions,PERF-OPEB reporting requirement 216 Fiscal Plan-CAB future payments,CIP,review,revise projected outstanding balances 4,371 of capital appreciation bonds,enter new projection into plan,CIP-correct assumption text,CIP-review,updating of bond payments,review CABS and other debt analysis, review-update-CIP,Debt new budget-year-end update,debt schedules. Other Consulting-email coordination and follow up;coordination/staffing of 2,175 application form for the City of Carmel excess Liability Insurance coverage for 2017; consult Mayor,email and phone coordination of outstanding/pending actions,meeting Mayor,continuing coordination of 2017 insurance coverage matters;long distance overseas call for interview or prospective replacement candidate for senior staff, individual meetings with senior staff,and corporation council;trip to post office to mail information to replacement candidate;and resolution of accumulated emails,conference call with Bloomington City contacts,discussing recommendations on contracting with third party administrator for Worker's Comp self-insured program;meetings with City corporation council,email correspondence,phone call regarding merit board project. Out of pocket expense-mileage 9 Total amount of this invoice. 26,455 Previous balance. 28,693 Payment received. (14,925) Total amount due. $ 40,223 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL January 4,2017 Professional services from December 1 through December 31,2016,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 Coonrod 12/22/2016 Additional Appropriations 240 1.15 276 Coonrod 12/29/2016 Additional Appropriations 240 1.20 288 Coonrod 12/30/2016 Additional Appropriations 240 0.95 228 Additional Appropriations Total 792 Coonrod 12/1/2016 Appeal 240 0.75 180 Coonrod 12/5/2016 Appeal 240 0.95 228 Coonrod 12/5/2016 Appeal 240 3.20 768 Coonrod 12/6/2016 Appeal 240 0.30 72 Coonrod 12/8/2016 Appeal 240 0.45 108 Coonrod 12/19/2016 Appeal 240 0.60 144 Coonrod 12/30/2016 Appeal 240 0.20 48 Roeger 12/5/2016 Appeal 220 1.00 220 Roeger 12/6/2016 Appeal 220 2.30 506 Roeger 12/6/2016 Appeal 220 1.40 308 Roeger 12/6/2016 Appeal 220 0.70 154 Roeger 12/7/2016 Appeal 220 0.75 165 Appeal Total 2,901 Lilly 12/1/2016 Budget Consultation 155 1.75 271 Roeger 12/1/2016 Budget Consultation 220 0.35 77 Roeger 12/1/2016 Budget Consultation 220 2.70 594 Roeger 12/1/2016 Budget Consultation 220 1.50 330 Roeger 12/1/2016 Budget Consultation 220 0.90 198 Roeger 12/2/2016 Budget Consultation 220 1.35 297 Roeger 12/2/2016 Budget Consultation 220 0.50 110 Coonrod 12/5/2016 Budget Consultation 240 0.40 96 Roeger 12/5/2016 Budget Consultation 220 0.40 88 Roeger 12/6/2016 Budget Consultation 220 1.10 242 Roeger 12/7/2016 Budget Consultation 220 1.65 363 Roeger 12/7/2016 Budget Consultation 220 0.20 44 Lilly 12/8/2016 Budget Consultation 155 1.75 271 Roeger 12/8/2016 Budget Consultation 220 0.75 165 Roeger 12/9/2016 Budget Consultation 220 0.30 66 Roeger 12/9/2016 Budget Consultation 220 1.10 242 Roeger 12/9/2016 Budget Consultation 220 0.50 110 Lilly 12/12/2016 Budget Consultation 155 1.75 271 Lilly 12/15/2016 Budget Consultation 155 1.75 271 Coonrod 12/19/2016 Budget Consultation 240 0.30 72 Roeger 12/19/2016 Budget Consultation 220 0.50 110 Roeger 12/19/2016 Budget Consultation 220 0.20 44 Roeger 12/21/2016 Budget Consultation 220 0.55 121 Roeger 12/21/2016 Budget Consultation 220 0.45 99 Coonrod 12/21/2016 Budget Consultation 240 0.90 216 Lilly 12/22/2016 Budget Consultation 155 1.75 272 Coonrod 12/22/2016 Budget Consultation 240 0.35 84 Roeger 12/23/2016 Budget Consultation 220 0.80 176 Roeger 12/23/2016 Budget Consultation 220 1.00 220 Roeger 12/27/2016 Budget Consultation 220 1.40 308 Roeger 12/27/2016 Budget Consultation 220 0.15 33 Roeger 12/27/2016 Budget Consultation 220 0.20 44 Roeger 12/28/2016 Budget Consultation 220 1.20 264 Roeger 12/28/2016 Budget Consultation 220 0.40 88 Roeger 12/28/2016 Budget Consultation 220 0.70 154 Roeger 12/28/2016 Budget Consultation 220 3.25 715 Coonrod 12/28/2016 Budget Consultation 240 0.20 48 Lilly 12/29/2016 Budget Consultation 155 1.75 272 Roeger 12/29/2016 Budget Consultation 220 1.75 385 Roeger 12/29/2016 Budget Consultation 220 0.95 209 Roeger 12/29/2016 Budget Consultation 220 2.50 550 Roeger 12/30/2016 Budget Consultation 220 1.40 308 Budget Consultation Total 8,898 Lilly 12/2/2016 CAFR/GAAP 155 1.90 294 Lilly 12/5/2016 CAFR/GAAP 155 2.05 317 Coonrod 12/5/2016 CAFR/GAAP 240 0.95 228 Lilly 12/6/2016 CAFR/GAAP 155 1.80 279 Coonrod 12/6/2016 CAFR/GAAP 240 0.10 24 Coonrod 12/6/2016 CAFR/GAAP 240 1.95 468 Coonrod 12/7/2016 CAFR/GAAP 240 0.80 192 Coonrod 12/8/2016 CAFR/GAAP 240 0.35 84 Coonrod 12/9/2016 CAFR/GAAP 240 2.75 660 Coonrod 12/12/2016 CAFR/GAAP 240 2.30 552 Coonrod 12/13/2016 CAFR/GAAP 240 0.40 96 Coonrod 12/13/2016 CAFR/GAAP 240 0.20 48 Roeger 12/13/2016 CAFR/GAAP 220 0.35 77 Coonrod 12/14/2016 CAFR/GAAP 240 2.85 684 Lilly 12/15/2016 CAFR/GAAP 155 2.05 318 Coonrod 12/15/2016 CAFR/GAAP 240 0.75 180 Lilly 12/16/2016 CAFR/GAAP 155 1.10 171 Coonrod 12/16/2016 CAFR/GAAP 240 1.80 432 Lilly 12/19/2016 CAFR/GAAP 155 1.50 233 Coonrod 12/19/2016 CAFR/GAAP 240 2.30 552 Lilly 12/20/2016 CAFR/GAAP 155 1.85 287 Coonrod 12/20/2016 CAFR/GAAP 240 1.80 432 Coonrod 12/20/2016 CAFR/GAAP 240 1.25 300 CAFR/GAAP Total 6,908 Coonrod 12/3/2016 Legislation 240 0.45 108 Legislation Total 108 Roeger 12/13/2016 LOIT Analysis 220 0.35 77 LOIT Analysis Total 77 Coonrod 12/21/2016 Pensions,PERF 240 0.90 216 Pensions,PERF Total 216 Hibler 12/2/2016 Plan 80 0.55 44 Coonrod 12/2/2016 Plan 240 0.50 120 Coonrod 12/2/2016 Plan 240 1.50 360 Coonrod 12/5/2016 Plan 240 0.30 72 Coonrod 12/6/2016 Plan 240 0.65 156 Coonrod 12/8/2016 Plan 240 1.70 408 Coonrod 12/12/2016 Plan 240 1.00 240 Hibler 12/12/2016 Plan 80 0.50 39 Coonrod 12/13/2016 Plan 240 0.20 48 Lilly 12/14/2016 Plan 155 2.40 372 Coonrod 12/14/2016 Plan 240 0.60 144 Coonrod 12/15/2016 Plan 240 0.05 12 Roeger 12/19/2016 Plan 220 3.10 682 Coonrod 12/20/2016 Plan 240 0.55 132 Coonrod 12/22/2016 Plan 240 1.85 444 Coonrod 12/23/2016 Plan 240 1.80 432 Coonrod 12/27/2016 Plan 240 1.30 312 Roeger 12/29/2016 Plan 220 0.90 198 Coonrod 12/30/2016 Plan 240 0.65 156 Plan Total 4,371 Engelking 12/1/2016 Other Consulting 150 4.45 667 Engelking 12/2/2016 Other Consulting 150 1.35 203 Engelking 12/5/2016 Other Consulting 150 4.50 675 Engelking 12/6/2016 Other Consulting 150 2.35 352 Engelking 12/7/2016 Other Consulting 150 1.35 203 Engelking 12/8/2016 Other Consulting 150 0.50 75 Other Consulting Total 29175 Meal 0 Mileage 9 TOTAL invoice amount 26,455