The URL can be used to link to this page

312997 6/28/2017 ��'`• CITY OF CARMEL, INDIANA VENDOR: 071300 CHECK AMOUNT: $****20,023.00* i ONE CIVIC SQUARE C. L. COONROD & COMPANY CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 312997 4 r°: SUITE 225 CHECK DATE: 06/28/17 �Me ruH ca' INDIANAPOLIS IN 46240 ` DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4340303 100303 0517B 2,780.00 ACCOUNTING SERVICES 1160 4340303 100303 0617A 4,824.00 ACCACCOOUNTINGTG SERVICES S FOR20 1160 4340400 34499 0617A 12,419.00 n « « k d_ g eq O -q2ƒ 2 \ q% >\ CL ° � n O _� 0 E k - $ o k b O m e ° w z 90 o ( O % f q ■ � � $ � / E > O o Z = A -n > q ƒ ƒ k § $ k \ C m ° © / k �_ % 2 2 z / 2 f _ 2 < > -n O \ } C5 ¥ | Sr J a i 3 R - 2 # k g ( c § % A n ( / ƒ £ _ ° 0 \ / ) § 7 k n 2 ■ - f R k 3 § %0 SD 2 « \ 3 R CD M /k 0 k K O« E § © ig £& 5, E G C? CL a - / , CD ® » G f § % I £CL % o o [ � , ƒ - e = % § m § E s § k k _ /G $ # E D \ , ) & 0 # / E z § Q ( gm k / q ƒ \ C \ � 0 ° R k Z ( kk ` a7 7 \ } � � �E 8 © wo D §0 & _ D «_ ( 7 § 2 CL § E ƒ M / } E G ? $ \ 2 g ] aCD C (D \ c 0 CL - \ 2 m 7 . ] § k 7 0 \ 2 k @ k CD } CD ® k INVOICE 0617a 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 June 20,2017 Professional services from June 1 through June 15,2017,in connection with: Bond/Lease-preparation for meeting with S&P,preparation for rating agency call- $ 7,178 review plan,bond follow up items,plan updates,update fiscal Plan for meeting with bond agency,meeting with S&P-supply documents requested by financial advisors-financial advisors questions,S&P call and follow up. Budget Consultation-budget funding recommendations,funding of 2017 budget. 231 Other Consulting-emails/phone calls,transition and budget matters,insurance issues for 3,900 auditors,insurance claims consultation,and 2018 budget draft,2018 budget matters- coordinate of Council Chamber upgrade construction project,Council Chamber project discussions with Council members,2017 budget claims,personnel matters with HR, additional facility needs matters with street department director,transition coordination, discussions with new Information Systems Director,meetings with senior staff members, budget work,coordination meeting with Clerk-Treasurer staff and claims. Plan-plan updates,update for new paving assumption,CIP review. 1,000 Out of pocket expense- - Total amount of this invoice. 12,419 Previous balance. 35,546 Payment received. (21,186) Total amount due. $ 26,779 Payable upon receipt. Call(317)8444605 with questions. CITY OF CARMEL June 20,2017 Professional services from June 1 through June 15,2017,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 6/1/2017 Additional Appropriations 220 0.50 110 Additional Appropriations Total 110 Coonrod 6/2/2017 Bond/Lease 240 1.05 252 Coonrod 6/6/2017 Bond/Lease 240 4.55 1,092 Coonrod 6/12/2017 Bond/Lease 240 0.10 24 Roeger 6/12/2017 Bond/Lease 220 1.50 330 Roeger 6/12/2017 Bond/Lease 220 0.10 22 Roeger 6/14/2017 Bond/Lease 220 1.00 220 Roeger 6/14/2017 Bond/Lease 220 2.20 484 Coonrod 6/14/2017 Bond/Lease 240 7.70 1,848 Roeger 6/14/2017 Bond/Lease 220 4.50 990 Coonrod 6/15/2017 Bond/Lease 240 1.20 288 Roeger 6/15/2017 Bond/Lease 220 5.00 1,100 Coonrod 6/15/2017 Bond/Lease 240 2.20 528 Bond/Lease Total 7,178 Roeger 6/2/2017 Budget Consultation 220 0.35 77 Roeger 6/2/2017 Budget Consultation 220 0.70 154 Budget Consultation Total 231 Engelking 6/1/2017 Other Consulting 150 2.00 300 Engelking 6/2/2017 Other Consulting 150 2.00 300 Engelking 6/5/2017 Other Consulting 150 2.00 300 Engelking 6/6/2017 Other Consulting 150 2.50 375 Engelking 6/7/2017 Other Consulting 150 2.00 300 Engelking 6/8/2017 Other Consulting 150 2.00 300 Engelking 6/9/2017 Other Consulting 150 2.00 300 Engelking 6/12/2017 Other Consulting 150 2.50 375 Engelking 6/13/2017 Other Consulting 150 3.00 450 Engelking 6/14/2017 Other Consulting 150 3.50 525 Engelking 6/15/2017 Other Consulting 150 2.50 375 Other Consulting Total 3,900 Roeger 6/1/2017 Plan 220 1.35 297 Roeger 6/1/2017 Plan 220 0.35 76 Coonrod 6/1/2017 Plan 240 0.95 228 Roeger 6/1/2017 Plan 220 0.85 187 Hibler 6/7/2017 Plan 155 0.35 55 Coonrod 6/8/2017 Plan 240 0.15 36 Roeger 6/8/2017 Plan 220 0.45 99 Roeger 6/9/2017 Plan 220 0.10 22 Plan Total 1,000 Publishing&printing-Pulication of adoption 0 Mileage 0 TOTAL invoice amount 12,419 n $ 9 @ < « OO-u 0 _ � $ e § O k \ k \ > M n 0 w w # D / e O % n % O m \ q ?$ q 7 O o o k R b 0 f 2 \ 0 w z k a ■ k 7 & q co rl.)0 o k® ko � D to _ / 3 / ƒ k § $ § $ E q § m 8 S © f 7 O � 2 0 Ez < f f -n p OD -40 | m § § m 7 0 0 ¥ « $ 0 2 7 M % § K i n ƒ $ 2 M w g N k ? G _k § \ $ f ; R 3 k 3 a - R G § _ ` & / E U) J 2 @ \ CD 3 / / k % R 0 2 / I § ' K) mI E \ a)G I @ - / 8 C / $ ' � § o m | ; # m § z e q � M k k ■ « ■ � _ 2$ # E U)) & § k 2 2 \ 0 /w G w G w § k ƒ \ C o 2 / © ■ \ 2 n } § N c A # F & � � 7E a & > }_$ { \ ¢ -n � §o ) _ C > ou �E gM E rj)2 k % K M ®0 2 G Q / / } \ \ \ m m ± 3 £ 7 / cz % / \ $ m / A g CL2 / a M # cn CD Gg ¥ } k k ] c � � $ co a CD 2 � \ { 7 R / . CD � � Z \ INVOICE 0517-B P.O.100303 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 48240 June 8,2017 Professional services from May 15 through May 31,2017,in connection with: 2016 CAFR: Work outside scope-preparation for audit committee meeting,Utility statements,net position classification,information request from C-T office,prepare documents for audit committee,attend audit committee meeting,follow upon audit committee question regarding indemnity,audit schedule,follow up regarding scheduling of 2015 and 2016 audits,follow up on Capital assets consultants on discrepancies,work paper of construction in progress requested by capital assets consultants. 2,780 Total amount of this invoice. 2,780 Previous balance. 1,028 Payment received. - Total amount due. $ 3,808 Payable upon receipt. Call(317)8444605 with questions. City of Carmel 2016 CAFR Time Budget Total in CLC BWR SLL ELH Total January February March AgI2 May Future Set up initial TB 240 1240 1480 956 480 1071 0 0 2507 0 Trust cash 960 2640 620 4220 276 4641 2964 0 0 7881 0 AR-property tax 240 700 940 0 599 419 0 0 1018 AR-income tax 240 220 700 1160 0 473 1125 0 0 1598 AR-ambulance 240 220 460 0 140 464 0 0 604 AR-medicaid supplemental 240 220 460 0 396 433 0 0 829 Capital assets 240 1400 1640 0 1483 280 0 0 1763 Capital leases 240 700 940 0 0 244 0 0 244 Accounts payable 240 220 1240 1700 388 3346 290 0 0 4024 Accrued wage 240 220 775 1235 0 469 35 0 0 504 Compensated absenses 240 220 620 1080 84 272 490 0 0 846 Bond premium,deferred rev 240 2100 2340 0 1003 1219 0 0 2222 Bond principal,debt disclosure 240 2100 2340 0 0 2177 0 0 2177 2016 bond issues 1920 2800 4720 132 1628 4611 0 0 6371 Local pensions 720 1050 1770 0 787 1397 0 0 2184 PERS pensions 720 1400 2120 36 1564 2776 0 0 4376 OPEB 720 2100 2820 48 148 2615 0 0 2811 Enterprise funds 3840 3840 60 0 849 1678 0 2587 GASB 77 0 0 0 0 0 348 888 1331 0 0 2567 Net investment in capital assets 480 1050 1530 0 84 312 0 0 396 MD&A 480 1400 1880 0 814 446 1503 0 2763 Budgetary statements 240 2480 2720 0 101 2875 0 0 2976 Finalize and reconcile statements 2880 700 3580 0 0 7376 1989 0 9365 GFOA checklist 1440 350 1790 0 0 155 0 0 155 Introductory section,CAFR prep 240 1050 1290 0 376 901 166 0 1443 Statistical section 480 2100 2580 140 1075 193 440 0 1848 Responses to Auditors 3840 440 2800 310 7390 96 1147 552 0 0 1795 Total 21840 4400 24500 7285 58025 2564 21914 37600 5776 0 67854 Work outside of Scope 0 0 0 0 0 180 1849 8888 5956 3344 16873 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 2744 23763 46488 11732 3344 84727 Rates 250 230 175 155 197.71 192.56 243.35 197.40 197.67 221.46 208.30 Hours 104.83 22.96 168.00 56.40 352.19 14.25 97.65 235.50 59.35 15.10 406.75 INVOICE 06-17-A P.O.100303 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 June 20,2017 Professional services from June 1 through June 15,2017,in connection with: 2016 CAFR: Work outside scope-follow up with SBOA on audit schedule;follow up with fixed assets consultants regarding updated data,respond to SBOA request for duplicate work papers for 2015 audit-respond to request for 2016 information already provided,auditor questions regarding fund balance classification 2015-follow up on 2016 audit schedule- follow up with GFOA on filing,respond to request from SBOA for 2015 compiled CAFR preparation for audit committee meeting,respond to SBOA regarding timing of 2016 audit and plans to file with GFOA-2015 GFOA application,respond to capital assets consultants regarding 2015 CIP-discuss status of capital assets data with consultants, preparation of timeline for 2017 audit requested by audit committee,attend audit committee meeting. 4,824 Total amount of this invoice. 4,824 Previous balance. 3,808 Payment received. (1,028) Total amount due. $ 7,604 Payable upon receipt. Call(317)844-4605 with questions. City of Carmel 2016 CAFR Time Budget Total in CLC BWR SLL LLH Total January February March Anril May lune Future Set up initial TB 240 1240 1480 956 480 1071 0 0 0 2507 0 Trustcash 960 2640 620 4220 276 4641 2964 0 0 0 7881 0 AR-property tax 240 700 940 0 599 419 0 0 0 1018 AR-income tax 240 220 700 1160 0 473 1125 0 0 0 1598 AR-ambulance 240 220 460 0 140 464 0 0 0 604 AR-medicaid supplemental 240 220 460 0 396 433 0 0 0 829 Capital assets 240 1400 1640 0 1483 280 0 0 0 1763 Capital leases 240 700 940 0 0 244 0 0 0 244 Accounts payable 240 220 1240 1700 388 3346 290 0 0 0 4024 Accrued wage 240 220 775 1235 0 469 35 0 0 0 504 Compensated absenses 240 220 620 1080 84 272 490 0 0 0 846 Bond premium,deferred rev 240 2100 2340 0 1003 1219 0 0 0 2222 Bond principal,debt disclosure 240 2100 2340 0 0 2177 0 0 0 2177 2016 bond issues 1920 2800 4720 132 1628 4611 0 0 0 6371 Local pensions 720 1050 1770 0 787 1397 0 0 0 2184 PERS pensions 720 1400 2120 36 1564 2776 0 0 0 4376 OPEB 720 2100 2820 48 148 2615 0 0 0 2811 Enterprise funds 3840 3840 60 0 849 1678 0 0 2587 GASB 77 0 0 0 0 0 348 888 1331 0 0 0 2567 Net investment in capital assets 480 1050 1530 0 84 312 0 0 0 396 MD&A 480 1400 1880 0 814 446 1503 0 0 2763 Budgetary statements 240 2480 2720 0 101 2875 0 0 0 2976 Finalize and reconcile statements 2880 700 3580 0 0 7376 1989 0 0 9365 GFOA checklist 1440 350 1790 0 0 155 0 0 0 155 Introductory section,CAFR prep 240 1050 1290 0 376 901 166 0 0 1443 Statistical section 480 2100 2580 140 1075 193 440 0 0 1848 Responses to Auditors 3840 440 2800 310 7390 96 1147 552 0 0 0 1795 Total 21840 4400 24500 7265 58025 2564 21914 37600 5776 0 0 67854 Work outside of Scope 0 0 0 0 0 180 1849 8888 5956 3344 4824 25041 20%contingency 4368 880 4900 1457 1160 Total with contingency 26208 5280 29400 8742 69630 2744 23763 46488 11732 3344 4824 92895 Rates 250 230 175 155 197.71 192.56 243.35 197.40 197.67 221.46 240.00 210.19 Hours 104.83 22.96 168.00 56.40 352.19 14.25 97.65 235.50 59.35 15.10 20.10 441.95