Loading...
HomeMy WebLinkAbout308938 03/07/17 �t t. CITY OF CARMEL, INDIANA VENDOR: 071300 ONE CIVIC SQUARE C. L.COONROD &COMPANY CHECK AMOUNT: $****20,905.00* =Q CARMEL, INDIANA 46032 PO BOX 46247 CHECK NUMBER: 308938 INDIANAPOLIS IN 46226 CHECK DATE: 03/07/17 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4340303 34499 0217D 14,978.00 ACCTG SERVICES FOR 20 1160 4340303 34499 0317A 5,927.00 ACCTG SERVICES FOR 20 Q n < « / � / � / � / v0 p b 2 r A 0 > k / k \ 0 E k \ 2 / 2 0 § < k o O / to / g w 2 o f > cr o -n # & f q 2 N) @ I R R o O > m 2 t t w -n > 2 k I \ § $ § § § § k ] � j S S 8 ^ ^ >q / D CL 2 oa 2 I q q> - O / § \ \ \ q CD § S S Z to J a $ 2 E_ � / - ^ ° { E § § g % E g i / $ § m m ¥ C o a -n Q CD § Q k # ® E E F F 7 # « ■ % E 2 / w [ O 7 + - C CD® @ % } g ID( � CD N §f E § ff 7 k W 7 to k (D EP \ / CD w w § J ƒ E E - ± ƒ § Z £ 2 0 7 \/ + e % M Q f 7 E% k k k 2 cl 0 cr - � w w w _ m k ( § } E f» # 7 > \ 1 ) $ ■ ) a _ 2 G § � \ CD \ �ƒ / \ j e 2 3 k ƒ C E ) J > o ® - D ƒ 0 Z » ro ° 0 } T 9E f 0 }$ ( / 7 0 > 0m / 2 n D a °r- M 0 E # ± 2 E ] $ cCD o o ■ Q § E @ 0 n CD CLk 2 _CD M / CO) G CD - OL ] CD 0CD w CD CL $ q # > CD / k ) c l § . ® w � $ 2 E f / 8 8 k INVOICE 0217-D P.O. Board of Works City of Cannel 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 February 27,2017 Professional services from February 20 through February 26,2017,in connection with: 2016 CAFR: 2016 Bonds 455 Accounts Payable $ 36 AR-Property Tax 48 AR-Ambulance 140 AR-Medicaid Supplemental 396 Budgetary Statements 101 Local Pensions 946 Net Investment in Capital Assets 84 OPEB 148 PERS Pensions 293 Response to Auditors 271 Setup Trial Balance 480 Statistical Section 61 Trust Cash 2,980 Subtotal. 6,439 Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17,2017. ($68,000) 6,439 Work outside scope-analysis of proposal for no OPEB actuarial report for 2016 CAFR, respond to GASB questions regarding TIF,message requested by GASB regarding GASB 77 applicability to TIF-conference call GASB:developer TIF's considered abatement but not other TIF's,CCD fund trail balance out of balance by material amount, follow up on problems with capital assets-email fix assets,trial balance,Barret law surplus fund beginning trial balance out of balance,adjustment to worker comp fund,as there were negative expenditures. 1,085 Total amount of this invoice. 7,524 Previous balance. 18,983 Payment received. Total amount due. $ 26,507 Payable upon receipt. Call(317)844-4605 with questions. City of Carmel 2016 CAFR Time Budget REVISED 2/14/17 In Future CLC BWR SLL ELH Total January February Total Set up initial TB 240 1240 1480 956 480 1436 Trust cash 960 2640 620 4220 276 4641 4917 AR-property tax 240 700 940 599 599 AR-income tax 240 220 700 1160 473 473 AR-ambulance 240 220 460 140 140 AR-Medicaid supplemental 240 220 460 396 396 Capital assets 240 1400 1640 1483 1483 Capital leases 240 700 940 0 0 Accounts payable 240 220 1240 1700 388 3346 3734 Accrued wage 240 220 775 1235 469 469 Compensated absences 240 220 620 1080 84 272 356 Bond premium,deferred rev 240 2100 2340 1003 1003 Bond principal,debt disclosure 240 2100 2340 0 2016 bond issues 1920 2800 4720 132 1628 1760 Local pensions 720 1050 1770 787 787 PERS pensions 720 1400 2120 36 1564 1600 OPEB 720 2100 2820 48 148 196 Enterprise funds 3840 3840 60 0 60 GASB 77 0 0 0 0 0 348 888 1236 Net investment in capital assets 480 1050 1530 84 84 MD&A 480 1400 1880 814 814 Budgetary statements 240 2480 2720 101 101 Finalize and reconcile statements 2880 700 3580 0 0 GFOA checklist 1440 350 1790 0 0 Introductory section,CAFR prep 240 1050 1290 376 376 Statistical section 480 2100 2580 140 1075 1215 Responses to Auditors 3840 440 2800 310 7390 96 1147 1243 Total 21840 4400 24500 7285 58025 2564 21914 24478 Work outside of Scope 0 0 0 0 0 180 1849 2029 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 2564 21914 24478 Rates 250 230 175 155 Fees $ 26.208 $ 4.400 $ 24.500 $ 7.285 $ 62.393 $ 2,744 $ 23,763 $ 26"507 INVOICE 0217b 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#36-1986569 C.L.Coonrod&Company 3860 Priority Way South Drive,Suite 226 Indianapolis,Indiana 46240 March 1,2017 Professional services from February 16 through February 28,2017,in connection with: Additional Appropriation-preparation for meeting regarding transfer,meeting with 1,850 council member and CT office-follow up,draft amendment;emails form CT office, respond,questions from Council member regarding additional appropriations ordinance proposal,follow up on additional appropriation. Annual Report-annual report matters,annual report follow up,cash balance matters. 1,001 Bond/Lease-information on new bonds,bond follow up items,LIT distribution follow 1,098 up,Financial Advisor questions regarding amount of COIT needed. Budget Consultation-follow up with auditor,discuss with client,ordinance matters 1,445 Other Consulting-emails and phone calls with senior staff and City officials,insurance 2,025 discussions,meetings with Mayor. Out of pocket expense-mileage 35 Total amount of this invoice. 7,454 Previous balance. 39,198 Payment received. (26,833) Total amount due. $ 19,819 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL March 1,2017 Professional services from February 16 through February 28,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 Coonrod 2/16/2017 Additional Appropriations 240 0.25 60 Coonrod 2/17/2017 Additional Appropriations 240 1.55 372 Coonrod 2/17/2017 Additional Appropriations 240 3.60 864 Coonrod 2/28/2017 Additional Appropriations 240 1.85 444 Roeger 2/28/2017 Additional Appropriations 220 0.50 110 Additional Appropriations Total 1,850 Roeger 2/20/2017 Annual Report 220 2.00 440 Roeger 2/27/2017 Annual Report 220 0.25 55 Roeger 2/27/2017 Annual Report 220 0.35 77 Roeger 2/28/2017 Annual Report 220 1.25 275 Roeger 2/28/2017 Annual Report 220 0.70 154 Annual Report Total 1,001 Lilly 2/27/2017 Bond/Lease 175 1.60 280 Roeger 2/27/2017 Bond/Lease 220 1.00 220 Roeger 2/27/2017 Bond/Lease 220 1.30 286 Coonrod 2/27/2017 Bond/Lease 240 0.30 72 Coonrod 2/28/2017 Bond/Lease 240 1.00 240 Bond/Lease Total 1,098 Lilly 2/16/2017 Budget Consultation 175 1.75 306 Lilly 2/16/2017 Budget Consultation 175 2.35 411 Lilly 2/17/2017 Budget Consultation 175 1.15 201 Roeger 2/17/2017 Budget Consultation 220 1.00 220 Lilly 2/23/2017 Budget Consultation 175 1.75 307 Budget Consultation Total 1,445 Engelking 2/16/2017 Other Consulting 150 1.00 150 Engelking 2/17/2017 Other Consulting 150 1.50 225 Engelking 2/20/2017 Other Consulting 150 1.50 225 Engelking 2/21/2017 Other Consulting 150 2.00 300 Engelking 2/22/2017 Other Consulting 150 1.00 150 Engelking 2/23/2017 Other Consulting 150 1.00 150 Engelking 2/23/2017 Other Consulting 150 2.00 300 Engelking 2/27/2017 Other Consulting 150 1.00 150 Engelking 2/28/2017 Other Consulting 150 2.50 375 Other Consulting Total 2,025 Publishing&printing 0 Mileage 35 INVOICE 0317-A P.O. Board of Works City of Carmel Atm:Sharon Kibbe One Civic Square Carmel,fN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 March 6,2017 Professional services from February 27 through March 5,2017,in connection with: 2016 CAFR: 2016 Bonds $ 1,395 Accounts Payable 185 AR-Income Tax 180 AR-Property Tax 18 AR-Ambulance 166 Bond Premium,Deferred Revenue 54 Enterprise Funds 240 GFOA Checklist 156 OPEB 120 PERS Pensions 525 Response to Auditors 312 Setup Trial Balance 466 Statistical Section 193 Trust Cash 1,617 Subtotal. 5,627 Out of pocket expense-mileage Subtotal,work within the scope of our engagement letter dated January 17,2017. ($68,000) 5,627 Work outside scope-issues with format of utility statements,Storm water collections data contradicts prior year,follow up on errors in Capital assets data,respond regarding GAAP format of utility statements. 300 Total amount of this invoice. 5,927 Previous balance. 26,507 Payment received. Total amount due. $ 32,434 Payable upon receipt. Call(317)844-4605 with questions.