Loading...
HomeMy WebLinkAbout317253 10/11/2017 CITY OF CARMEL, INDIANA VENDOR: 071300 CHECK AMOUNT: $****14,071.00' ONE CIVIC SQUARE C. L. COONROD&COMPANY r� 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 317253 CARMEL, INDIANA 46032 SUITE CHECK DATE: 10/1 1/17 INDIANAPOLIS IN 46240 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4340303 34499 0917B 8,068.00 ACCTG SERVICES FOR 20 1160 4340303 100303 09-17B 6,003.00 ACCOUNTING SERVICES 2 @ c000 A « « / » m O Q a E : O ( k \ 2 m i nCL 0 A ° ® » > o 2 \ 0 � g 2 / § 0 z / 90 -n 7 k (n q 0 S o q a R § 9 G ® 2 CP > \ § $ k \ C M ƒ . / > m k 3 O ® \ 0) > O CD § \ q CD § Z � � f ( f E C U) r, i g [ / ƒ E 2 m 2 ; q =r m R,) x K 2 ) k 2 / � ® CD � 2 A � CD k Cr k + - CL Er k ¢ o ! 7 G © CD M E0 E n C = 9 C Z - ca % ƒ % J k -4 CL7 - k (D § E £ � o (D » - > EZ e qO _ a a / § - = w * m k » g q 2 & E $ \ 0 & k \ _ $ � \ CD � ( a� S � k ƒ � � C R g - ( E 20 z » CD 0- � R OC � \[ 5 � } � � 90 ; / m o o ` o D �/ % 2 2 / kCL § / M q / } j/ e 0 CD 3 2 z CD2 ƒ / $ c ƒ # D CD CD / / / D M \ kk / 2 \ § \ ® > pr _ $ KCDc 2 $ ' (D 8 ¥ / INVOICE 09-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 October 9,2017 Professional services from September 16 through September 30,2017,in connection with: 2016 CAFR: Work outside scope-prepare draft of CAFR as requested,CAFR notes and adjustments, SBOA messages regarding utility and capital assets,response to SBOA regarding water utility bond-SBOA issue with utility statements accrual of$400,000 management fee, assist SBOA with bond bank audited statements-evaluate changes in SIP in comparison to bond expenditures,review new capital assets data from SBOA and expenditures of bond proceeds-determine amount of bond proceeds to compare to CIP,review discrepancies in SBOA capital assets data,comments to SBOA-preparation for audit committee meeting,follow up on capital assets,respond to SBOA regarding utility bond- review progress on capital assets,look up host for conference call,SBOA utility bond concerns,conference call regarding utility bond,conference call regarding SBOA questions 2016 water bonds,follow up on capital assets. 5,755 Out of pocket expense-2016 CAFR GASB publications 248 Total amount of this invoice. 6,003 Previous balance. 28,616 Payment received. - Total amount due. $ 34,619 Payable upon receipt. Call(317)8444605 with questions. City of Carmel 2016 CAFR Time Budget Total in CLC BWR SLL ELH Total April Mav June July Aug. Sem 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 MDBA 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 310 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 15330 92972 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 11732 3344 15308 20482 21635 15330 160826 Rates 250 230 175 155 197.71 197.67 221.46 204.79 214.81 205.46 208.86 208.69 Hours 104.83 22.96 168.00 S" 352.19 59.35 15.10 74.75 95.35 105.30 73.40 770.65 City of Carmel 2016 CAFR Time Budget Total in CLC BWR SLL ELH Total April May lune July Aug. Sep. 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 MDBA 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 310 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 15330 92972 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 11732 3344 15308 20482 21635 15330 160826 Rates 250 230 175 155 197.71 197.67 221.46 204.79 214.81 205.46 208. 6 208.69 Hours 104.83 22.96 Lk" 56.a0 352.19 59.35 15.10 74.75 95.35 105.30 73.40 770.65 O 2 t 0 $ < � m � O O m E = O \ i j - 2 k q ° / > m O # 2 \ p b g 2 o K 7 O � p e 2 90 o SI) 0 -< k & OD K) ± ( T O E D / # 2 E ? (P » > k § § E ] � 0) >_ m k O K ® Ln z \ 7 > O C \\ . =r _ ± K3 L- r- \ a - Z co r k ; 0 / CD c/ K 2 m =rm D a m -n § - ` K # - k � f Z \ $ 3 \ k k 0 $ 3 § \ CD ■ m / k n E $ ƒ =r § k m 2 § k 2 # 8 CD / \ -42 C 7 K ro CD § E � � - ƒ E Z Q _ a SL ;w 0 -4 j m k » 2 q � i 7 D $ 57 )c $ 0 § � 8 § g ■ - ° W 0 k U m k � C K go (D* (D ƒ 2 0 Z k (D � ° 2 �\ 7 da �0 \_ƒ CD / 7 � 9- & , - D . imR: n2 > a) } q / / M . n / 0 j (D c Si * CD ¥ / 2 E § ¢ f # � / o v � ■ m ® ° 2 gk k M \ Q f L ] k k 2 ° ƒ � \\ � § e > - 2 K & § 5 ƒ % 2 ' f 8 ¥ / INVOICE 0917b 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 October 3,2017 Professional services from September 16 through September 30,2017,in connection with: Appeal-progress on draft of levy appeal to DLGF. $ 310 Budget Consultation-budget forms follow up,2018 budget,rate resolution,budget 5,898 matters,rate resolution-review budget,follow upon 2018 budget forms,work on draft of City's budget ordinance,follow up on debt matters related to budget,follow-up on bond matters,review email regarding 4CDC operations-review rate cap resolution. Budget Forms-budget forms and review. 1,024 Budget Hearing-preparation for budget hearing. 156 Other Consulting-emails and phone calls on REI and Palladium cost overruns; 675 leadership seminar with firefighters. Out of pocket expense-travel to meeting. 5 Total amount of this invoice. 8,068 Previous balance. 10,517 Payment received. - Total amount due. $ 18,585 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL October 3,2017 Professional services from September 16 through September 30,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 Hibler 9/29/2017 Appeal 155 1.00 155 Hibler 9/29/2017 Appeal 155 1.00 155 Assessment Total 310 Roeger 9/18/2017 Budget Consultation 220 0.50 110 Roeger 9/18/2017 Budget Consultation 220 0.40 88 Coonrod 9/18/2017 Budget Consultation 240 0.05 12 Roeger 9/18/2017 Budget Consultation 220 1.95 429 Roeger 9/19/2017 Budget Consultation 220 0.40 88 Coonrod 9/19/2017 Budget Consultation 240 0.60 144 Roeger 9/19/2017 Budget Consultation 220 0.15 33 Roeger 9/20/2017 Budget Consultation 220 0.85 187 Roeger 9/21/2017 Budget Consultation 220 3.25 715 Roeger 9/22/2017 Budget Consultation 220 3.25 715 Roeger 9/25/2017 Budget Consultation 220 2.50 550 Roeger 9/25/2017 Budget Consultation 220 1.05 231 Roeger 9/26/2017 Budget Consultation 220 3.85 847 Roeger 9/27/2017 Budget Consultation 220 0.75 165 Roeger 9/27/2017 Budget Consultation 220 0.55 121 Roeger 9/27/2017 Budget Consultation 220 0.30 66 Roeger 9/28/2017 Budget Consultation 220 0.15 33 Roeger 9/28/2017 Budget Consultation 220 0.70 154 Roeger 9/28/2017 Budget Consultation 220 2.20 484 Coonrod 9/28/2017 Budget Consultation 240 0.75 180 Roeger 9/29/2017 Budget Consultation 220 0.90 198 Coonrod 9/29/2017 Budget Consultation 240 1.45 348 Budget Consultation Total 5,898 Roeger 9/18/2017 Budget Forms 220 0.20 44 Roeger 9/20/2017 Budget Forms 220 4.10 902 Roeger 9/25/2017 Budget Forms 220 0.30 66 Coonrod 9/26/2017 Budget Forms 240 0.05 12 Budget Forms Total 1,024 Coonrod 9/22/2017 Budget Hearing 240 0.65 156 Budget Hearing Total 156 Engelking 9/19/2017 Other Consulting 150 1.00 150 Engelking 9/20/2017 Other Consulting 150 3.50 525 Other Consulting Total 675 Publishing&printing-Pulication of adoption 0 Mileage 0 TOTAL invoice amount 7,907