Loading...
HomeMy WebLinkAbout315451 08/30/17 CITY OF CARMEL, INDIANA VENDOR: 071300 v,. ONE CIVIC SQUARE C. L. COONROD &COMPANY CHECK AMOUNT: $""""70,937.00* CARMEL, INDIANA 46032 SU50 PZR2ORITY WAY SOUTH DRIVE CHECK NUMBER: 315451 ITEINDIANAPOLIS IN 46240 CHECK DATE: 08/30/17 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4340303 100303 0617B 10,494.00 ACCOUNTING SERVICES 1160 4340303 100303 0717A 9,891.00 ACCOUNTING SERVICES 1160 4340303 100303 0717B 10,591.00 ACCOUNTING SERVICES 1160 4340303 34499 0717B 23,420.00 ACCTG SERVICES FOR 20 1160 4340303 100303 0817A 2,955.00 ACCOUNTING SERVICES 1160 4340303 34499 0817A 13,586.00 ACCTG SERVICES FOR 20 n % n $ « \ 0) / / 70 9 / q 0 \ O \ o co o 2 ® ® O ° n e © / O # m 0 E k q 2 \ . \ § 2 / 90 C ƒ > / ) ƒ O # A f q ; © % 0 T o R S f $ C k 0 O o ® CA) t - > ::40 7 7 § $ § $ E \ C ;om / S S ^ © 7 / &q 2 � § » f19. 2 a 2 < 2 7 > -n O OD / q . CD Z 8 o | =r ) a i 3 SE > . ; g © I # 2 r k A 0 / / ƒ 2 x 2 ] a / k / • 0 $ k / m R . 3 J & A : \ 0 G CD - E ( Cl) k § & \ 07 ; § � CD C 2 _a £ E - o 2 CL @ - < , $ C \ / § f § a § o E |; , - _ = a y @ K« $ , p m § I e CLj § m \ / 17 a Cr 0 ° (D > / - ) / K , , 8 > 2 ) § \ k Q \ k / e § ° q ƒ C o ( / © A D k Z a � f(=D } — § S k } | �< / 7- % © 0 }ƒ_ ( / 9/ ) o j « �7 gcn m / / X 0CD 0 S / 0 ° I CA ) / r C � \ 0 CD a E $ 0- k 2 §r Cl>� \ k 2 m ] § 8 / \ { k » # > \ CD § 7 < / N E 8 k . \ INVOICE 0817a P.O.34499 Hon.James C.Brainard Mayor,City of Carmel Atlas: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 August 16,2017 Professional services from August 1 through August 15,2017,in connection with: Assessment-respond to question from Council member. $ 372 Bond/Lease-newsletter issue responses,TIF issue responses. 1,111 Budget Consultation-obtain data needed for fire comparison,prepare analysis for 6,200 Council member,receive fire department data filter for those needed for analysis,respond to questions regarding AN growth-prepare rate comparison charts as requested,General Fund revenue chart for Hamilton County cities,obtain receipts and disbursement from Gateway and categorize-create graphics to show ratios,revenues chart,follow up on debt scenarios,resend tax rate comparison charts,respond to questions regarding debt,respond to questions regarding newsletter debt article including conference call,follow up on 2018 budget matters,update budget comparison. Budget Hearing-budget dates. 110 Cumulative Fund-anticipate remonstrance. 48 Other Consulting-transition and budget,email and phone calls. 2,475 Plan-plan updates for tax rates,taxing district rate comparison,plan updates to the 2018 2,324 budget,update pan for proposed budget,response regarding impact of level rate-response to Council member regarding revenue to debt ratio for other cities-develop revenue verse rate analysis for other cities,tax rate comparison-fire comparison,revenue comparison for Council-gathered revenues of similar cities to compare to Carmel,district tax rate comparison,review update of district tax rates. Project-graph follow up,chart and plan updates,debt follow up items. 946 Out of pocket expense- - Total amount of this invoice. 13,586 Previous balance. 54,046 Payment received. (30,626) Total amount due. $ 37,006 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL August 16,2017 Professional services from August 1 through August 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 Coonrod 8/10/2017 Assessment 240 0.35 84 Coonrod 8/11/2017 Assessment 240 1.20 288 Assessment Total 372 Roeger 8/8/2017 Bond/Lease 220 4.10 902 Roeger 8/8/2017 Bond/Lease 220 0.95 209 Bond/Lease Total 1,111 Lilly 8/1/2017 Budget Consultation 175 0.50 88 Coonrod 8/1/2017 Budget Consultation 240 1.00 240 Lilly 8/2/2017 Budget Consultation 175 2.75 481 Lilly 8/2/2017 Budget Consultation 175 2.90 508 Coonrod 8/2/2017 Budget Consultation 240 1.80 432 Lilly 8/3/2017 Budget Consultation 175 6.35 1,111 Roeger 8/3/2017 Budget Consultation 220 2.05 451 Roeger 8/3/2017 Budget Consultation 220 1.20 264 Roeger 8/3/2017 Budget Consultation 220 0.15 33 Roeger 8/4/2017 Budget Consultation 220 1.05 231 Roeger 8/4/2017 Budget Consultation 220 0.40 88 Coonrod 8/4/2017 Budget Consultation 240 1.65 396 Coonrod 8/7/2017 Budget Consultation 240 0.50 120 Roeger 8/7/2017 Budget Consultation 220 0.60 132 Coonrod 8/8/2017 Budget Consultation 240 3.15 756 Roeger 8/10/2017 Budget Consultation 220 0.60 132 Roeger 8/10/2017 Budget Consultation 220 0.40 88 Roeger 8/10/2017 Budget Consultation 220 0.20 44 Roeger 8/11/2017 Budget Consultation 220 1.00 220 Roeger 8/14/2017 Budget Consultation 220 1.20 264 Roeger 8/14/2017 Budget Consultation 220 0.55 121 Budget Consultation Total 6,200 Roeger 8/7/2017 Budget Hearing 220 0.50 110 Budget Hearing Total 110 Coonrod 8/4/2017 Cumulative Fund 240 0.20 48 Cumulative Fund Total 48 Engelking 8/1/2017 Other Consulting 150 2.50 375 Engelking 8/2/2017 Other Consulting 150 3.50 525 Engelking 8/3/2017 Other Consulting 150 2.50 375 Engelking 8/4/2017 Other Consulting 150 2.00 300 Engelking 8/7/2017 Other Consulting 150 1.00 150 Engelking 8/8/2017 Other Consulting 150 1.00 150 Engelking 8/9/2017 Other Consulting 150 1.00 150 Engelking 8/10/2017 Other Consulting 150 1.00 150 Engelking 8/11/2017 Other Consulting 150 1.00 150 Engelking 8/15/2017 Other Consulting 150 1.00 150 Other Consulting Total 2,475 Hibler 8/1/2017 Plan 155 0.50 78 Hibler 8/2/2017 Plan 155 0.75 116 Hibler 8/2/2017 Plan 155 0.75 116 Roeger 8/2/2017 Plan 220 1.65 363 Coonrod 8/2/2017 Plan 240 0.65 156 Coonrod 8/3/2017 Plan 240 3.15 756 Hibler 8/3/2017 Plan 155 1.60 248 Hibler 8/4/2017 Plan 155 0.50 77 Hibler 8/8/2017 Plan 155 2.05 318 Coonrod 8/8/2017 Plan 240 0.40 96 Plan Total 2,324 Roeger 8/1/2017 Project 220 0.15 33 Roeger 8/2/2017 Project 220 4.00 880 Roeger 8/7/2017 Project 220 0.15 33 Project Total 946 Publishing&printing-Pulication of adoption 0 Mileage 0 TOTAL invoice amount 13,586 INVOICE 0717b 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 August 4,2017 Professional services from July 16 through July 31,2017,in connection with: Bookkeeping-compiling estimates for amounts to be paid for remainder of year. $ 78 Bond/Lease-bond follow up items,bond expenditure,bond matters,respond to public 4,682 question regarding fiscal plan,update to fiscal plan regarding bonds,2015 CAFR follow up,follow up on bond matters,debt schedules update to plan,respond to questions from public regarding debts,assist in response to public questions,debt schedule follow up. Budget Consultation-plan matters,respond to question from public about State 7,609 allocation of road money and impact on Carmel,budget follow up items,preparation for meeting with Council member,budget follow up items,review proposed additional appropriation,plan related items regarding budget items,meeting matters,preparation for and attend meeting with director of administration to discuss plan,plan updates for level tax rate,respond to Council member. Loan-provide requested debt information in response to public request. 612 Other Consulting-budget,transition items,emails and phone calls,meeting with senior 6,450 staff,work on budget spread sheet;meeting with mayor,personnel matters. Plan-plan related updates,2018 budget updates and debt schedule updates of 2017 2,157 bonds,printing and binding of fiscal plan for meeting,respond to Council member questions and revise assumption to level rate,new level rate assumption-respond to question regarding rates. TIF-of vs general revenue chart for Mayor,hypothetical TIF impact on general revenues 617 chart. Project-road funding,budget matters. 1,144 Out of pocket expense- 71 Total amount of this invoice. 23,420 Previous balance. 30,626 Payment received. - Total amount due. $ 54,046 CITY OF CARMEL August 4,2017 Professional services from July 16 through July 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 Roeger 7/17/2017 Bond/Lease 220 1.80 396 Hibler 7/17/2017 Bond/Lease 155 0.45 70 Roeger 7/17/2017 Bond/Lease 220 1.40 307 Roeger 7/17/2017 Bond/Lease 220 0.25 55 Hibler 7/17/2017 Bond/Lease 155 0.50 78 Hibler 7/17/2017 Bond/Lease 155 0.45 70 Hibler 7/17/2017 Bond/Lease 155 0.50 78 Roeger 7/19/2017 Bond/Lease 220 0.60 132 Coonrod 7/19/2017 Bond/Lease 240 0.95 228 Roeger 7/20/2017 Bond/Lease 220 1.00 220 Roeger 7/21/2017 Bond/Lease 220 2.10 462 Hibler 7/21/2017 Bond/Lease 155 1.50 233 Coonrod 7/21/2017 Bond/Lease 240 1.70 408 Coonrod 7/24/2017 Bond/Lease 240 1.50 360 Roeger 7/24/2017 Bond/Lease 220 0.95 209 Roeger 7/25/2017 Bond/Lease 220 3.90 858 Coonrod 7/25/2017 Bond/Lease 240 0.60 144 Roeger 7/27/2017 Bond/Lease 220 1.70 374 Bond/Lease Total 4,682 Hibler 7/31/2017 Bookkeeping 155 0.50 78 Bookkeeping Total 78 Roeger 7/18/2017 Budget Consultation 220 1.40 306 Roeger 7/18/2017 Budget Consultation 220 0.90 198 Lilly 7/20/2017 Budget Consultation 175 1.75 306 Coonrod 7/20/2017 Budget Consultation 240 0.50 120 Roeger 7/21/2017 Budget Consultation 220 1.20 264 Coonrod 7/24/2017 Budget Consultation 240 0.25 60 Roeger 7/25/2017 Budget Consultation 220 1.50 330 Roeger 7/26/2017 Budget Consultation 220 3.75 825 Coonrod 7/26/2017 Budget Consultation 240 3.35 804 Coonrod 7/26/2017 Budget Consultation 240 0.20 48 Roeger 7/26/2017 Budget Consultation 220 1.45 319 Lilly 7/27/2017 Budget Consultation 175 1.75 306 Roeger 7/27/2017 Budget Consultation 220 3.50 770 Coonrod 7/27/2017 Budget Consultation 240 2.10 504 Roeger 7/28/2017 Budget Consultation 220 3.50 770 Coonrod 7/28/2017 Budget Consultation 240 3.20 768 Roeger 7/31/2017 Budget Consultation 220 0.85 187 Roeger 7/31/2017 Budget Consultation 220 2.20 484 Coonrod 7/31/2017 Budget Consultation 240 1.00 240 Budget Consultation Total 7,609 Coonrod 7/17/2017 Loan 240 2.55 612 Loan Total 612 Engelking 7/18/2017 Other Consulting 150 9.00 1,350 Engelking 7/19/2017 Other Consulting 150 4.50 675 Engelking 7/20/2017 Other Consulting 150 4.00 600 Engelking 7/21/2017 Other Consulting 150 2.00 300 Engelking 7/22/2017 Other Consulting 150 2.00 300 Engelking 7/24/2017 Other Consulting 150 3.00 450 Engelking 7/24/2017 Other Consulting 150 4.50 675 Engelking 7/25/2017 Other Consulting 150 2.00 300 Engelking 7/26/2017 Other Consulting 150 4.00 600 Engelking 7/27/2017 Other Consulting 150 3.50 525 Engelking 7/28/2017 Other Consulting 150 2.00 300 Engelking 7/31/2017 Other Consulting 150 2.50 375 Other Consulting Total 6,450 Roeger 7/24/2017 Plan 220 0.80 176 Roeger 7/25/2017 Plan 220 0.30 66 Hibler 7/27/2017 Plan 155 2.40 372 Hibler 7/27/2017 Plan 155 0.90 140 Hibler 7/27/2017 Plan 155 1.00 155 Coonrod 7/30/2017 Plan 240 0.85 204 Coonrod 7/31/2017 Plan 240 4.15 996 Coonrod 7/31/2017 Plan 240 0.20 48 Plan Total 2,157 Lilly 7/17/2017 TIF 175 2.15 377 Coonrod 7/17/2017 TIF 240 1.00 240 TIF Total 617 Roeger 7/20/2017 Project 220 2.50 550 Roeger 7/31/2017 Project 220 2.70 594 Project Total 1,144 Publishing&printing-Pulication of adoption 0 Mileage 0 TOTAL invoice amount 23,349 o « w 0 < « G G m / k \ k \ / / n 0 ID 7 J o w ■ D / o k 2 \ 0 / k -4 X 2 0 0 < k R k 0 m 7 k g w z 90 C) . ( § $ 2 ƒ q $ f Q /T -/ k S R a } § 0 \ / 3 e $ e $ :* m 2 m m 7 ^ D k E g 2 \ f 2 2 ; 7 @ > -n 9 / § § z 2 | % 8 § ± R - z > § \ \ k \ / § FL CD & FD* E x , 8 k q § \ 3 CD f 3 k CD =r 0 S cc CD Co } 7 $ k§ § & / a m , e 2 o E R ° q � - k k -4 0) 0 \ 0 / f k Q B I / } | C =r06 CD a o m /cr CD C a i$ # D \ ID) \ # � \ $ § C \ o m ) o \ G % § q ƒ � k 2 / ^ _ / D > CD / } �_ § %Z , . _ § E c ( ( �< > 9. 9§ D § & o > } X o CD M . 0j U K { G k_ z E ] �_ S z co\ 0 \ E @ CD G / k ° CD o \ \ \ 2 ) f CD } § k ® z g � rL # 2 k \ g CD \ � CD $ \ / 6 C) INVOICE 07-17-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 46240 August 4,2017 Professional services from July 16 through July 31,2017,in connection with: 2016 CAFR: Work outside scope-meeting requested by SBOA regarding 2015 financial statements, respond to SBOA reversed position on$5 million CRC bond payment,revise MD&A for bond payment,discuss SBOA issues with audit committee member,changes to 2015 CAFR for CRC new categorization as pending nonexchange transactions,create new set of pdfs and revise engagement letter per SBOA email,4CDC work paper items,contact SBOA regarding adjustment to recognize 2015 CRC bond payment resolution,review revised CAFR showing 2015 CRC transaction,submit 2015 CAFR to SBOA for final review,explain to auditors need to balance 2015 audit adjustment entry,receive and evaluate new 2015 entry from auditors,respond to mayor and audit committee member, rewrite 2015 disclosures regarding transfer adjustment requested by SBOA,reversing their previous instructions,changer journal entries in CAFR per SBOA,produce new 2015 CAFR,progress on new adjustments reversing SBOA position,revise CAFR again and produce all documents after SBOA change for transfer,review CAFR after SBOA change in recommendation regarding 2015 transfer,C-T request for change in transmittal letter,check the fixed assets database provided by Ann-analyze and discuss,review new 2016capital assets data and identify and report problems. 10,011 Out of pocket expense-GFOA charge for 580 Total amount of this invoice. 10,591 Previous balance. 20,385 Payment received. - Total amount due. $ 30,976 i Payable upon receipt. Call(317)844-4605 with questions. City of Carmel 2016 CAFR Time Budget Total in CLC BWR SLL ELH Total Jan. Feb. Mar. ADnI May June July Future Set up initial TB 240 1240 1480 956 480 1071 0 0 0 0 2507 0 Trust cash 960 2640 620 4220 276 4641 2964 0 0 0 0 7881 0 AR-property tax 240 700 940 0 599 419 0 0 0 0 1018 AR-income tax 240 220 700 1160 0 473 1125 0 0 0 0 1598 AR-ambulance 240 220 460 0 140 464 0 0 0 0 604 AR-medicaid supplemental 240 220 460 0 396 433 0 0 0 0 829 Capital assets 240 1400 1640 0 1483 280 0 0 0 0 1763 Capital leases 240 700 940 0 0 244 0 0 0 0 244 Accounts payable 240 220 1240 1700 388 3346 290 0 0 0 0 4024 Accrued wage 240 220 775 1235 0 469 35 0 0 0 0 504 Compensated absenses 240 220 620 1080 84 272 490 0 0 0 0 846 Bond premium,deferred rev 240 2100 2340 0 1003 1219 0 0 0 0 2222 Bond principal,debt disclosure 240 2100 2340 0 0 2177 0 0 0 0 2177 2016 bond issues 1920 2800 4720 132 1628 4611 0 0 0 0 6371 Local pensions 720 1050 1770 0 787 1397 0 0 0 0 2184 PERS pensions 720 1400 2120 36 1564 2776 0 0 0 0 4376 OPEB 720 2100 2820 48 148 2615 0 0 0 0 2811 Enterprise funds 3840 3840 60 0 849 1678 0 0 0 2587 GASB 77 0 0 0 0 0 348 888 1331 0 0 0 0 2567 Net investment in capital assets 480 1050 1530 0 84 312 0 0 0 0 396 MD&A 480 1400 1880 0 814 446 1503 0 0 0 2763 Budgetary statements 240 2480 2720 0 101 2875 0 0 0 0 2976 Finalize and reconcile statements 2880 700 3580 0 0 7376 1989 0 0 0 9365 GFOA checklist 1440 350 1790 0 0 155 0 0 0 0 155 Introductory section,CAM prep 240 1050 1290 0 376 901 166 0 0 0 1443 Statistical section 480 2100 2580 140 1075 193 440 0 0 0 1848 Responses to Auditors 3840 440 2800 310 7390 96 1147 552 0 0 0 0 1795 Total 21840 4400 24500 7285 58025 2564 21914 37600 5776 0 0 0 67854 Work outside of Scope 0 0 0 0 0 180 1849 8888 5956 3344 15308 20482 56007 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 2744 23763 46488 11732 3344 15308 20482 123861 Rates 250 230 175 155 197.71 192.56 243.35 197.40 197.67 221.46 204.79 214.81 209.24 Hours 104.83 22.96 168.00 56.40 352.19 14.25 97.65 235.50 59.35 15.10 74.75 95.35 591.95 INVOICE 08-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 August 16,2017 Professional services from August 1 through August 15,2017,in connection with: 2016 CAFR: Work outside scope-receive 2015 audit report,arrange for inclusion on CAFR and preparation of final 2015 CAFR,review revised capital assets data for 2016-SBOA request for unsecure 2015 CAFR document and our response,respond to SBOA questions,evaluate revised capital assets,evaluate new 2016 capital assets data-provide unlocked copy of 2015 pdf file as requested-email from C-T regarding another set of new capital assets data-phone call to senior staff member regarding deadlines and status of capital assets,save 2015 pdf to CD for SBOA and take to City of Carmel office, respond to C-T request for changes to transmittal letter and organizational chart,debt follow up items. 2,955 Out of pocket expense- - Total amount of this invoice. 2,955 Previous balance. 31,336 Payment received. - Total amount due. $ 34,291 Payable upon receipt. Call(317)844-4605 with questions. City of Carmel 2016 CAM Time Budget Total in CLC BWR SLL ELH Total Mar. Ap!2 Mav June JuIv Aug. Future Set up initial TB 240 1240 1480 1071 0 0 0 0 0 2507 0 Trust cash 960 2640 620 4220 2964 0 0 0 0 0 7881 0 AR-property tax 240 700 940 419 0 0 0 0 0 1018 AR-income tax 240 220 700 1160 1125 0 0 0 0 0 1598 AR-ambulance 240 220 460 464 0 0 0 0 0 604 AR-medicaid supplemental 240 220 460 433 0 0 0 0 0 829 Capital assets 240 1400 1640 280 0 0 0 0 0 1763 Capital leases 240 700 940 244 0 0 0 0 0 244 Accounts payable 240 220 1240 1700 290 0 0 0 0 0 4024 Accrued wage 240 220 775 1235 35 0 0 0 0 0 504 Compensated absenses 240 220 620 1080 490 0 0 0 0 0 846 Bond premium,deferred rev 240 2100 2340 1219 0 0 0 0 0 2222 Bond principal,debt disclosure 240 2100 2340 2177 0 0 0 0 0 2177 2016 bond issues 1920 2800 4720 4611 0 0 0 0 0 6371 Local pensions 720 1050 1770 1397 0 0 0 0 0 2184 PERS pensions 720 1400 2120 2776 0 0 0 0 0 4376 OPEB 720 2100 2820 2615 0 0 0 0 0 2811 Enterprise funds 3840 3840 849 1678 0 0 0 0 2587 GASB 77 0 0 0 0 0 1331 0 0 0 0 0 2567 Net investment in capital assets 480 1050 1530 312 0 0 0 0 0 396 MD&A 480 1400 1880 446 1503 0 0 0 0 2763 Budgetary statements 240 2480 2720 2875 0 0 0 0 0 2976 Finalize and reconcile statements 2880 700 3580 7376 1989 0 0 0 0 9365 GFOA checklist 1440 350 1790 155 0 0 0 0 0 155 Introductory section,CAFR prep 240 1050 1290 901 166 0 0 0 0 1443 Statistical section 480 2100 2580 193 440 0 0 0 0 1848 Responses to Auditors 3840 440 2800 310 7390 552 0 0 0 0 0 1795 Total 21840 4400 24500 7285 58025 37600 5776 0 0 0 0 67854 Work outside of Scope 0 0 0 0 0 8888 5956 3344 15308 20482 2955 58962 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 46488 11732 3344 15308 20482 2955 126816 Rates 250 230 175 155 197.71 197.40 197.67 221.46 204.79 214.81 231.76 209.72 Hours 104.83 22.96 168.00 56.40 352.19 235.50 59.35 15.10 74.75 95.35 12.75 604.70 0 e % @ « « \ » » m O E E k ? $ S % S o $ o000� © m 0 0 q e w w ■ D I O # 2 / 0 7 $ / -4q § $ k R b 0 o w z k 9 . ( \ / 2 ƒ q / n 2 « } 0 D 3 % S ■ $ » 0 O a ® 2 S S ƒ > q k } $ § $ E \ � X ). S S ^ © R m 3 O ® 2 49 o / 9 $ § § 0 O , in § k | & & R - e > & 6 2 p E m r, k C 0 E f i 2 CL g ƒ x CD ƒ § § / 7 i \ § 2 2 - (D #f / � CL a f \ 0 0 Cr C -+ - CL I a @ c ■ E \ 0 / § o Q ° 2 £ 3 i a $8 kC e � § o cr C | ; ZD' CL § k% / -1 \k ® \ = Ef \C\> \\ t7/ /- 4 $ c \ CD 0 m ƒ0 o Q » & 0 0 ƒ 0 ) / ° ® D k Z f� N [ § _ . § E } 32 E 2 T \f % 0 > � 6 0 > §/ & % q > ? E §/ 3 o \ R $ ? / \ \ ° k # . � I 0 � E E 3 C § R c0 kCD CD 0 \ / / ° \ ; \ _ # 2 § k / \ \ _ > \ } § @ 7 ƒ 2 $ E CD ° 0 8 INVOICE 06-17-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 46240 July 2,2017 Professional services from June 16 through June 30,2017,in connection with: 2016 CAFR: Work outside scope-SBOA request for work papers for 2015 audit-detail out information previously provided,auditor questions regarding fund balance classification 2015;follow up on 2016 audit schedule;follow up with GFOA on filing,2015 GFOA application,follow up on member status of City,complete and send in application- capital assets data consult regarding changes in Kieser capital assets data for 2015, respond to auditors regarding changes in capital assets data for 2015,respond to auditor questions regarding revisions in 2015 capital assets,auditor questions regarding 2015 net investment in capital assets,SBOA request for 4CDC documents,4CDC questions regarding compliance,provide documents requested by SBOA on beginning net position, carrying value of capital assets,provide SBOA with copies of lease and commitment information that had been previously provided,SBOA questions regarding refunded and defeased bonds prior to 2011 and impact on 2015 statements-provide documents requested by audit committee-provide documents requested by SBOA on refunded and defeased bonds,follow up on SBOA questions,4CDC Board concerns regarding 2016 records request.-explain to SBOA the 2015 beginning net position,respond to SBOA question regarding CRC bond payment reimbursement in 2016,update transmittal letter per CT request,follow with client and financial advisors regarding transmittal letter, follow up on further CT request for transmittal letter changes-respond to auditors regarding TIF disclosure,review of transmittal letters,phone call from financial advisors regarding transmittal letter,respond to further SBOA questions regarding operating leases with Carmel as lessor. 10,484 Out of pocket expense-mileage to meeting 10 Total amount of this invoice. 10,494 Previous balance. 8,632 Payment received. 1,028 Total amount due. $ 18,098 Payable upon receipt. Call(317)844-4605 with questions. City of Carmel 2016 CAFR Time Budget Total in CLC BWR SLL ELH Total January February March Aril May . June Future Set up initial TB 240 1240 1480 956 480 1071 0 0 0 2507 0 Trust cash 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,CAM 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 7285 58025 2564 21914 37600 5776 0 0 67854 Work outside of Scope 0 0 0 0 0 180 1849 8888 5956 3344 15308 35525 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 2744 23763 46488 11732 3344 15308 103379 Rates 250 230 175 155 197.71 192.56 243.35 197.40 197.67 221.46 204.79 208.17 Hours 104.83 22.96 168.00 56.40 352.19 14.25 97.65 235.50 59.35 15.10 74.75 496.60 INVOICE 07-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 July 18,2017 Professional services from July 1 through July 15,2017,in connection with: 2016 CAFR: Work outside scope-follow up on documents requested by SBOA,prepare CAFR for audit committee meeting,follow up on capital assets revised data for 2016,respond to audit committee member,prepare agenda and plan audit committee meeting,including arrange for report on auditors schedule,draft audit committee resolution on cyber security,follow up on 4CDC documents for SBOA,follow up on cash accounts not included in City ledger,audit committee and SBOA questions,respond to audit committee member regarding 2015 lease payments from GF to CRC-contact IT director on behalf of audit committee,follow up with IT director on cyber security for committee, follow up on 2016 constructions in response to questions from C-T,prepare for audit committee meeting by producing CAFRs,updating agenda,updating cyber security resolution,follow up on capital assets,preparing S&P report-respond to SBOA questions regarding reconciling budget comparisons,printing and binding CAFRs for the audit committee meeting,attend audit committee meeting,SBOA follow up,follow up on 2015 CRC reimbursement transactions with legal and DLGF and SBOA,respond to C-T regarding SBOA issues including 2015 CRC debt payment including phone call from chief examiner,audit questions and plan for fmal. 9,891 Out of pocket expense-mileage to meeting - Total amount of this invoice. 9,891 Previous balance. 18,098 Payment received. 7,604 Total amount due. $ 20,385 Payable upon receipt. Call(317)844-4605 with questions. City of Cannel 2016 CAM Time Budget Total in CLC BWR SLL ELH Total Jan. Feb. Mar. Aril May June July Future Set up initial TB 240 1240 1480 956 480 1071 0 0 0 0 2507 0 Trust cash 960 2640 620 4220 276 4641 2964 0 0 0 0 7881 0 AR-property tax 240 700 940 0 599 419 0 0 0 0 1018 AR-income tax 240 220 700 1160 0 473 1125 0 0 0 0 1598 AR-ambulance 240 220 460 0 140 464 0 0 0 0 604 AR-medicaid supplemental 240 220 460 0 396 433 0 0 0 0 829 Capital assets 240 1400 1640 0 1483 280 0 0 0 0 1763 Capital leases 240 700 940 0 0 244 0 0 0 0 244 Accounts payable 240 220 1240 1700 388 3346 290 0 0 0 0 4024 Accrued wage 240 220 775 1235 0 469 35 0 0 0 0 504 Compensated absenses 240 220 620 1080 84 272 490 0 0 0 0 846 Bond premium,deferred rev 240 2100 2340 0 1003 1219 0 0 0 0 2222 Bond principal,debt disclosure 240 2100 2340 0 0 2177 0 0 0 0 2177 2016 bond issues 1920 2800 4720 132 1628 4611 0 0 0 0 6371 Local pensions 720 1050 1770 0 787 1397 0 0 0 0 2184 PERS pensions 720 1400 2120 36 1564 2776 0 0 0 0 4376 OPEB 720 2100 2820 48 148 2615 0 0 0 0 2811 Enterprise funds 3840 3840 60 0 849 1678 0 0 0 2587 GASB 77 0 0 0 0 0 348 888 1331 0 0 0 0 2567 Net investment in capital assets 480 1050 1530 0 84 312 0 0 0 0 396 MDBA 480 1400 1880 0 814 446 1503 0 0 0 2763 Budgetary statements 240 2480 2720 0 101 2875 0 0 0 0 2976 Finalize and reconcile statements 2880 700 3580 0 0 7376 1989 0 0 0 9365 GFOA checklist 1440 350 1790 0 0 155 0 0 0 0 155 Introductory section,CAM prep 240 1050 1290 0 376 901 166 0 0 0 1443 Statistical section 480 2100 2580 140 1075 193 440 0 0 0 1848 Responses to Auditors 3840 440 2800 310 7390 96 1147 552 0 0 0 0 1795 Total 21840 4400 24500 7285 58025 2564 21914 37600 5776 0 0 0 67854 Work outside of Scope 0 0 0 0 0 180 1849 8888 5956 3344 15308 9891 45416 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 2744 23763 46488 11732 3344 15308 9891 113270 Rates 250 230 175 155 197.71 192.56 243.35 197.40 197.67 221.46 204.79 206.49 208.03 Hours 104.83 22.96 168.00 56.40 352.19 14.25 97.65 235.50 59.35 15AO 74.75 47.90 544.50