The URL can be used to link to this page

Home My WebLink About316196 9/26/2017 (9) CITY OF CARMEL, INDIANA VENDOR: 071300CHECK AMOUNT: S"""20,093.00' ONE CIVIC SQUARE C. L. COONROD & COMPANYCARMEL, INDIANA 46032 SU0 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 316196 INDIANAPOLIS IN 46240 225 CHECK DATE: 09/26/17 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4340303 34499 0817B 8,859.00 ACCTG SERVICES FOR 20 1160 4340303 100303 0917A 9,576.00 ACCOUNTING TG SERVICES SERVICES 1160 4340303 34499 0917A 1,658.00 n E % 0 $ « k � 4 m0 O c ar- O $ k § k § § > -0 0 0 o J / 0 # 2 o 0 E k g 2 \ 2 2 0 z / 90 C g 2@ m ƒ O # % f q ■ © -n C) K) $ \ T 2o E D \ o -0 0 =r _ 0 7 3 / ƒ § $ e $ Cl. q m m ■ # m T). ° ? � 2 \ 6 7 >q a O p CF) 00 / q D § 8 Z | � $ 0 2 7 « % § f £ @ E 2 / k§ f F 2 0 m m m \ 7 k _ / fCL k / (D ® Z 2 - / § @ 2 7 , J 0 7 2 + - E « 0 $\ CD 3 Q & CD m 7 / E ; E § E & , « CD E g » 03G i ig - / ; CDo , G J @ w E fN) I k 3 N) ' |; ■ � e � # 7 £ 7 m § e _ /£ \ § m \ ( gor 0 {$ # E D \ � - 00 C ° 0 0) g/ k0) M ƒ \ 1? C � ( / © \ E % 0 Z t � fi CD \ e< f \ \ T e° 0- �o o � � � 0 > § ) Q , _ �E ƒ § $ f » 2 0 { M 0 / j E \ f ? Z % C CD / c m 0 kCD / / \ M \ Q Q m CL ] k K \ { CDl > \ § a / D @ ƒ ƒ § $ /. CD INVOICE 0917a 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 September 18,2017 Professional services from September 1 through September 15,2017,in connection with: Budget Consultation-budget follow up items,review of client file. $ 668 Other Consulting-phone calls and emails to senior staff members. 825 Plan-Fiscal plan updates,bond refunding transaction. 165 Out of pocket expense- - Total amount of this invoice. 1,658 Previous balance. 8,859 Payment received. - Total amount due. $ 10,517 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL September 18,2017 Professional services from September 1 through September 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 Roeger 9/7/2017 Budget Consultation 220 0.25 56 Lilly 9/7/2017 Budget Consultation 175 1.75 306 Lilly 9/14/2017 Budget Consultation 175 1.75 306 Budget Consultation Total 668 Engelking 9/5/2017 Other Consulting 150 1.00 150 Engelking 9/6/2017 Other Consulting 150 1.00 150 Engelking 9/7/2017 Other Consulting 150 1.00 150 Engelking 9/11/2017 Other Consulting 150 1.50 225 Engelking 9/12/2017 Other Consulting 150 1.00 150 Other Consulting Total 825 Roeger 9/5/2017 Plan 220 0.60 132 Roeger 9/5/2017 Plan 220 0.15 33 Plan Total 165 Publishing&printing-Pulication of adoption 0 Mileage 0 TOTAL invoice amount 1,658 INVOICE 0817b 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 September 8,2017 Professional services from August 16 through August 31,2017,in connection with: Assessment-respond to question from public. $ 552 Bond/Lease-follow up on bond payment items,review source of debt payments on 1,232 outstanding City bonds,compare revenue to debt. Budget Consultation-tax rate comparisons,tax bill comparison analysis,budget matters, 5,200 plan and budget follow up items,budget and rate matters revenue items,special census follow up,new census not applied to river boat. Other Consulting-phone calls and emails,meetings with senior staff members. 1,875 Out of pocket expense- - Total amount of this invoice. 8,859 Previous balance. 37,006 Payment received. (37,006) Total amount due. $ 8,859 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL September 8,2017 Professional services from August 16 through August 31,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 Coonrod 8/28/2017 Assessment 240 2.30 552 Assessment Total 552 Roeger 8/23/2017 Bond/Lease 220 1.30 286 Roeger 8/25/2017 Bond/Lease 220 4.30 946 Bond/Lease Total 1,232 Lilly 8/3/2017 Budget Consultation 175 1.75 306 Lilly 8/4/2017 Budget Consultation 175 2.30 404 Lilly 8/8/2017 Budget Consultation 175 3.00 525 Lilly 8/10/2017 Budget Consultation 175 1.75 306 Roeger 8/16/2017 Budget Consultation 220 2.00 440 Lilly 8/17/2017 Budget Consultation 175 1.75 306 Roeger 8/21/2017 Budget Consultation 220 1.30 286 Roeger 8/21/2017 Budget Consultation 220 0.65 143 Roeger 8/21/2017 Budget Consultation 220 1.35 297 Roeger 8/24/2017 Budget Consultation 220 1.90 418 Roeger 8/24/2017 Budget Consultation 220 1.40 308 Roeger 8/24/2017 Budget Consultation 220 2.50 550 Lilly 8/24/2017 Budget Consultation 175 1.75 306 Roeger 8/29/2017 Budget Consultation 220 0.15 33 Roeger 8/29/2017 Budget Consultation 220 0.30 66 Roeger 8/30/2017 Budget Consultation 220 0.80 176 Coonrod 8/30/2017 Budget Consultation 240 0.10 24 Lilly 8/31/2017 Budget Consultation 175 1.75 306 Budget Consultation Total 5,200 Engelking 8/16/2017 Other Consulting 150 2.00 300 Engelking 8/17/2017 Other Consulting 150 1.00 150 Engelking 8/18/2017 Other Consulting 150 1.00 150 Engelking 8/23/2017 Other Consulting 150 2.00 300 Engelking 8/30/2017 Other Consulting 150 2.00 300 Engelking 8/31/2017 Other Consulting 150 4.50 675 Other Consulting Total 1,875 Publishing&printing-Pulication of adoption 0 Mileage 0 TOTAL invoice amount 8,859 0 — 2 � @ « « k km0 O o 7 E � O Ll 9 E ) © z > M n 0 > r') � R m % o O ° < k / / \ \ k w z / � o . © k ƒ 0 s � ® 2 \ (1) _0 9 o E > > \ , 2 Z 0 3 / / # e $ 1 @ -0 X m \ ° ° �_ 2 O ® a 2 / $ > q O \ / t ƒ t RCh r, § $ 0 / E g 7 E § m m $� j o a ; n 0 ƒ R _ CD E 2 \ � ® � a � E & 0 7 2 E ± k £ a @ £ % « Q » \ CD_ 0 ICD. 0m E _ 2 $ Z E / E % \ % 2 0 g w E f I / 3 a o � | # m § � 2 CL CD \ § ) \ 2 CA /3 i = \ nk § 2 -n < / 0 \ i/ o § § m ƒ \ =� \ 2 / » © a \ 2 Z > acn 0 \ \ �E GD § CD � :Ec) D o & �E 77 k E 2 r\ M /& 0 R / 0 § # E � � § / 7 $ C { c o0 CD CD CL a0 k M § m } § \ \ § 0 CL _ > \ \ \ C P g f { (, § 8 ¥ \ INVOICE 09-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 September 18,2017 Professional services from September 1 through September 15,2017,in connection with: 2016 CAFR: Work outside scope-reconcile bond bank trial balance audited by other accountants to City trial balance as requested by SBOA,2015 changes in balances and other capital asset considerations,SBOA questions regarding utility cross over refinancing not previously disclosed,investigate utility bond refunding transactions,follow up on status of capital assets adjustments,follow up on utility cross-over refunding-follow up on storm water asset identification,follow up on 2016 utility bond transaction disclosure and adjustment and draft disclosure,follow up on capital assets adjustment-C-T request regarding documents to SBOA,review adjustments needed to CAFR-make changes and correct notes,follow up on capital assets-additional disclosure on 2016 water bond transaction. 9,576 Out of pocket expense- - Total amount of this invoice. 9,576 Previous balance. 52,971 Payment received. 33,931 Total amount due. $ 28,616 Payable upon receipt. Call(317)844-4605 with questions. City of Carmel 2016 CAFR Time Budget Total in CLC BWR SLL ELH Total April May June July Aug. Seo. Future Set up initial TB 240 1240 1480 0 0 0 0 0 0 2507 0 Trust cash 960 2640 620 4220 0 0 0 0 0 0 7881 0 AR-property tax 240 700 940 0 0 0 0 0 0 1018 AR-income tax 240 220 700 1160 0 0 0 0 0 0 1598 AR-ambulance 240 220 460 0 0 0 0 0 0 604 AR-medicaid supplemental 240 220 460 0 0 0 0 0 0 829 Capital assets 240 1400 1640 0 0 0 0 0 0 1763 Capital leases 240 700 940 0 0 0 0 0 0 244 Accounts payable 240 220 1240 1700 0 0 0 0 0 0 4024 Accrued wage 240 220 775 1235 0 0 0 0 0 0 504 Compensated absenses 240 220 620 1080 0 0 0 0 0 0 846 Bond premium,deferred rev 240 2100 2340 0 0 0 0 0 0 2222 Bond principal,debt disclosure 240 2100 2340 0 0 0 0 0 0 2177 2016 bond issues 1920 2800 4720 0 0 0 0 0 0 6371 Local pensions 720 1050 1770 0 0 0 0 0 0 2184 PERS pensions 720 1400 2120 0 0 0 0 0 0 4376 OPEB 720 2100 2820 0 0 0 0 0 0 2811 Enterprise funds 3840 3840 1678 0 0 0 0 0 2587 GASB 77 0 0 0 0 0 0 0 0 0 0 0 2567 Net investment in capital assets 480 1050 1530 0 0 0 0 0 0 396 MD&A 480 1400 1880 1503 0 0 0 0 0 2763 Budgetary statements 240 2480 2720 0 0 0 0 0 0 2976 Finalize and reconcile statements 2880 700 3580 1989 0 0 0 0 0 9365 GFOA checklist 1440 350 1790 0 0 0 0 0 0 155 Introductory section,CAFR prep 240 1050 1290 166 0 0 0 0 0 1443 Statistical section 480 2100 2580 440 0 0 0 0 0 1848 Responses to Auditors 3840 440 2800 11Q 7390 0 0 0 0 0 0 1795 Total 21840 4400 24500 7285 58025 5776 0 0 0 0 0 67854 Work outside of Scope 0 0 0 0 0 5956 3344 15308 20482 21635 9576 87218 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 11732 3344 15308 20482 21635 9576 155072 Rates 250 230175 155 197.71 197.67 221.46 204.79 214.81 205.46 197.04 207.91 Hours 104.83 22.96 168.00 56.40 352.19 59.35 15.10 74.75 95.35 105.30 48.60 745.85