Loading...
HomeMy WebLinkAbout309747 03/29/17 CITY OF CARMEL, INDIANA VENDOR: 071300 g ONE CIVIC SQUARE C. L. COONROD & COMPANY CHECK AMOUNT: $*****5,482.00* CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 309747 ; ? SUITE 225 CHECK DATE: 03/29/17 M,i roN. INDIANAPOLIS IN 46240 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4340303 34499 0317-C 5,482.00 ACCTG SERVICES FOR 20 n 2 % 0 / « S � � � -C WW W � \ f O O_ a e : O k § @ 2 @ CL $ k % k § © \ q k �_ r k o *k 0 E k q , 2 CL 2 ° 2 § § 0 z / O / $ n ƒ D # $ ƒ / / � � f C) O ¢ k $ O o ¥ / _ > o 0 0 0 0 0 0 0 0 o E_ 0 CD _0 m_ m f § § § § § < & % 2 � w 2 z % 2 ƒ \ f \ f f K O / % \ $ d $ E q CD 8 8 8 § 8 | 6 J a i a R > z k 0 / 0 % A g \ /ƒ CY ° m m • e ? % -nQ a ¥ - n E F - (D R f % f 2CD % 4) ƒ , \ 0 S I ( - CL « a « � % 3 §g G £ E ; a P6 a ± J « § k % Err rL & 2 E - , \ • ;_ su fCL [ I 3 § o � ƒ � k« - / \ \ K % ? _ f «a e & e G e G e G > ( 2 7 CL cr ) \ $ . ; cr CD � D \ ) � # / 2 2 2 § § z k ° 0 k a I o w o w o w o � o � 0 o ° k o > Z > ° \ / _ } 2 PO %« � CL / \ �� � | < 7� ^ D co _}ƒ { o o �E ƒ q $ & / \ q 7 \ m / / } 7 \ \ D # ; = £ E / C m c ® 0 Q , CD m / I � g 2. CD & 2 CD M / G mf L 2 § k 7 2 ( , _ _ \ \ m \ $ g 4 2k P k 2 w o 0 . CD 7 $ § N / C CD 8 S 8 8 8 \ INVOICE 0317a 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 March 16,2017 Professional services from March 1 through March 15,2017,in connection with: Bond/Lease-response to financial advisors regarding COIT projection,bond matters, 3,288 cash account matters,updating of bond debt,debt service matters,bond plan. Budget Consultation-review file,follow up on budget,budget matters,preparation for 2,682 meeting with Council member,questions from CT regarding food and beverage tax collection,respond to question regarding principal value of water line contract-follow up on franchise fee collection. Other Consulting-emails and phone calls with senior staff and City officials,insurance 2,738 discussions,and claims coordination. Plan-plan updates and meeting,review information requested by council member 2,488 Out of pocket expense-mileage - Total amount of this invoice. 11,196 Previous balance. 19,819 Payment received. (12,365) Total amount due. $ 18,650 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL March 16,2017 Professional services from March 1 through March 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 3/2/2017 Bond/Lease 220 3.20 704 Coonrod 3/2/2017 Bond/Lease 240 0.65 156 Roeger 3/2/2017 Bond/Lease 220 1.50 330 Roeger 3/7/2017 Bond/Lease 220 1.20 264 Hibler 3/7/2017 Bond/Lease 155 0.70 109 Roeger 3/7/2017 Bond/Lease 220 0.30 66 Roeger 3/7/2017 Bond/Lease 220 1.60 352 Roeger 3/7/2017 Bond/Lease 220 0.10 22 Roeger 3/8/2017 Bond/Lease 220 1.90 418 Roeger 3/8/2017 Bond/Lease 220 0.50 110 Coonrod 3/8/2017 Bond/Lease 240 1.55 372 Roeger 3/8/2017 Bond/Lease 220 1.00 220 Roeger 3/8/2017 Bond/Lease 220 0.75 165 Bond/Lease Total 3,288 Lilly 3/2/2017 Budget Consultation 175 1.75 306 Coonrod 3/2/2017 Budget Consultation 240 0.90 216 Lilly 3/3/2017 Budget Consultation 175 0.80 140 Coonrod 3/3/2017 Budget Consultation 240 0.50 120 Roeger 3/6/2017 Budget Consultation 220 1.90 418 Coonrod 3/6/2017 Budget Consultation 240 1.45 348 Coonrod 3/6/2017 Budget Consultation 240 2.45 588 Lilly 3/9/2017 Budget Consultation 175 1.75 306 Coonrod 3/9/2017 Budget Consultation 240 0.20 48 Coonrod 3/14/2017 Budget Consultation 240 0.30 72 Roeger 3/15/2017 Budget Consultation 220 0.55 120 Budget Consultation Total 2,682 Engelking 3/1/2017 Other Consulting 150 2.50 375 Engelking 3/2/2017 Other Consulting 150 1.50 225 Engelking 3/3/2017 Other Consulting 150 1.75 263 Engelking 3/6/2017 Other Consulting 150 2.50 375 Engelking 3/7/2017 Other Consulting 150 1.50 225 Engelking 3/8/2017 Other Consulting 150 1.00 150 Engelking 3/9/2017 Other Consulting 150 1.50 225 Engelking 3/10/2017 Other Consulting 150 1.00 150 Engelking 3/13/2017 Other Consulting 150 1.50 225 Engelking 3/14/2017 Other Consulting 150 2.00 300 Engelking 3/15/2017 Other Consulting 150 1.50 225 Other Consulting Total 2,738 Hibler 3/6/2017 Plan 155 1.55 240 Roeger 3/6/2017 Plan 220 4.50 990 Hibler 3/7/2017 Plan 155 0.30 47 Hibler 3/14/2017 Plan 155 1.90 295 Roeger 3/14/2017 Plan 220 1.50 330 Roeger 3/15/2017 Plan 220 2.50 550 Coonrod 3/15/2017 Plan 240 0.15 36 Plan Total 2,488 Publishing&printing 0 Mileage 0 TOTAL invoice amount 11,196 INVOICE 0317-B P.O. Board of Works City of Carmel Attn:Sharon Kibbe One Civic Square Cannel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 March 15,2017 Professional services from March 6 through March 12,2017,in connection with: 2016 CAFR: 2016 Bonds $ 828 AR-Income Tax 36 AR-Property Tax 228 AR-Ambulance 96 GASB 77-Abatement Disclosures 1,150 Budgetary Statements 1,200 Introductory Section,CAFR Prep 560 OPEB 1,675 PERS Pensions 1,421 Setup Trial Balance 166 Trust Cash 1,173 Subtotal. 8,533 Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17,2017. ($68,000) 8,533 Work outside scope-follow up on Capital assets,particularly concern for the work-in- process,utility statement adjustments required to meet GAAP standards-phone conference with utility staff,send utility staff net investment work paper from prior year-consult on calculation of cost of refunding-respond to question regarding cash flow statement,pursue missing trust cash account statements for Legacy TIF project,utility deferred refunding cost calculation-phone call from SBOA issues with CT office-obtain cash accounts not available from CT office,computation of economic gain or loss on refunding.. 2,170 Total amount of this invoice. 10,703 Previous balance. 32,434 Payment received. 11,731 Total amount due. $ 31,406 City of Carmel 2016 CAFR Time Budget Total in CLC BWR SLL ELH Total January February March Future Set up initial TB 240 1240 1480 956 480 632 2068 0 Trust cash 960 2640 620 4220 276 4641 2791 7708 0 AR-property tax 240 700 940 0 599 246 845 AR-income tax 240 220 700 1160 0 473 216 689 AR-ambulance 240 220 460 0 140 262 402 AR-medicaid supplemental 240 220 460 0 396 0 396 Capital assets 240 1400 1640 0 1483 0 1483 Capital leases 240 700 940 0 0 0 0 Accounts payable 240 220 1240 1700 388 3346 185 3919 Accrued wage 240 220 775 1235 0 469 0 469 Compensated absenses 240 220 620 1080 84 272 0 356 Bond premium,deferred rev 240 2100 2340 0 1003 54 1057 Bond principal,debt disclosure 240 2100 2340 0 0 0 0 2016 bond issues 1920 2800 4720 132 1628 2223 3983 Local pensions 720 1050 1770 0 787 0 787 PERS pensions 720 1400 2120 36 1564 1945 3545 OPEB 720 2100 2820 48 148 1796 1992 Enterprise funds 3840 3840 60 0 240 300 GASB 77 0 0 0 0 0 348 888 1150 2386 Net investment in capital assets 480 1050 1530 0 84 0 84 MD&A 480 1400 1880 0 814 0 814 Budgetary statements 240 2480 2720 0 101 1200 1301 Finalize and reconcile statements 2880 700 3580 0 0 0 0 GFOA checklist 1440 350 1790 0 0 155 155 Introductory section,CAFR prep 240 1050 1290 0 376 560 936 Statistical section 480 2100 2580 140 1075 193 1408 Responses to Auditors 3840 440 2800 310 7390 96 1147 312 1555 Total 21840 4400 24500 7285 58025 2564 21914 14160 38638 Work outside of Scope 0 0 0 0 0 180 1849 2471 4500 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 2744 23763 16631 43138 Rates 250 230 175 155 197.71 192.56 243.35 204.44 223.22 Hours 104.83 22.96 168.00 56.40 352.19 14.25 97.65 81.35 193.25 INVOICE 0317-C P.O. 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 March 20,2017 Professional services from March 13 through March 19,2017,in connection with: 2016 CAFR: 2016 Bonds $ 504 Accrued Wage 35 AR-Income Tax 611 AR-Property Tax 24 AR-Ambulance 202 AR-Medicaid Supplemental 24 Bond Principal,Debt Disclosure 184 Capital Assets 280 Enterprise Funds 8 Compensated Absences 219 GASB 77-Abatement Disclosures 12 Budgetary Statements 44 Local Pensions 548 OPEB 819 PERS Pensions 358 Setup Trial Balance 383 Trust Cash 88 Subtotal. 4,343 Out of pocket expense-mileage - Subtotak work within the scope of our engagement letter dated January 17,2017. ($68,000) 4,343 Work outside scope-provide graphics research to utility accountants regarding correct classification of cash flow statement,respond to questions and comments regarding utility GAAP interpretations,follow up on bank statements for audit,respond to actuary request for data-public records request-prior period adjustment for capital assets,provide data to actuary,assistance to utility accountants,follow up on public records request. 1,139 Total amount of this invoice. 5,482 Previous balance. 31,406 Payment received. - Total amount due. $ 36,888 City of Carmel 2016 CAFR Time Budget Total in CLC BWR SLL ELH Total Janua February March Future Set up initial TB 240 1240 1480 956 480 1017 2453 0 Trust cash 960 2640 620 4220 276 4641 2879 7796 0 AR-property tax 240 700 940 0 599 270 869 AR-income tax 240 220 700 1160 0 473 827 1300 AR-ambulance 240 220 460 0 140 464 604 AR-medicaid supplemental 240 220 460 0 396 24 420 Capital assets 240 1400 1640 0 1483 280 1763 Capital leases 240 700 940 0 0 0 0 Accounts payable 240 220 1240 1700 388 3346 185 3919 Accrued wage 240 220 775 1235 0 469 35 504 Compensated absenses 240 220 620 1080 84 272 219 575 Bond premium,deferred rev 240 2100 2340 0 1003 54 1057 Bond principal,debt disclosure 240 2100 2340 0 0 184 184 2016 bond issues 1920 2800 4720 132 1628 2727 4487 Local pensions 720 1050 1770 0 787 548 1335 PERS pensions 720 1400 2120 36 1564 2303 3903 OPEB 720 2100 2820 48 148 2615 2811 Enterprise funds 3840 3840 60 0 248 308 GASB 77 0 0 0 0 0 348 888 1162 2398 Net investment in capital assets 480 1050 1530 0 84 0 84 MD&A 480 1400 1880 0 814 0 814 Budgetary statements 240 2480 2720 0 101 1244 1345 Finalize and reconcile statements 2880 700 3580 0 0 0 0 GFOA checklist 1440 350 1790 0 0 155 155 Introductory section,CAFR prep 240 1050 1290 0 376 560 936 Statistical section 480 2100 2580 140 1075 193 1408 Responses to Auditors 3840 440 2800 310 7390 96 1147 312 1555 Total 21840 4400 24500 7285 58025 2564 21914 18505 42983 Work outside of Scope 0 0 0 0 0 180 1849 3610 5639 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 2744 23763 22115 48622 Rates 250 230 175 155 197.71 192.56 243.35 203.73 220.56 Hours 104.83 22.96 168.00 56.40 352.19 14.25 97.65 108.55 220.45