The URL can be used to link to this page

308495 02/28/17 CITY OF CARMEL, INDIANA VENDOR: 071300 i` CHECK AMOUNT: $*""24,096.00* .�; ® �'• ONE CIVIC SQUARE C. L COONROD & COMPANY CARMEL, INDIANA 46032 PO BOX 46247 CHECK NUMBER: 308495 MtruN�, INDIANAPOLIS IN 46226 CHECK DATE: 02/28/17 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4340303 34499 0217-A 14,929.00 ACCTG SERVICES FOR 20 1160 4340303 34499 0217-B 9,167.00 ACCTG SERVICES FOR 20 VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) Vendor# 071300 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER C L COONROD&COMPANY IN SUM OF$ CITY OF CARMEL 3850 PRIORITY WAY SOUTH DRIVE#225 An invoice or bill to be property itemized must show:kind of service,where performed,dates service rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. INDIANAPOLIS, IN 46240 Payee $24,096.00 ON ACCOUNT OF APPROPRIATION FOR Purchase Order# Mayor's Office Terms Date Due PO# ACCT# DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 34499 0217-A 43-403.03 $2,564.00 1 hereby certify that the attached invoice(s),or 2/7/17 0217-A $2,564.00 1160 101 1160 101 34499 0217-B 43-403.03 $9,167.00 bill(s)is(are)true and correct and that the 2/14/17 0217-B $9,167.00 1160 1 101 1 materials or services itemized thereon for 1160 101 34499 0217A 43-403.03 $12,365.00 2/16/17 0217A $12,365.00 1160 101 which charge is made were ordered and 1160 101 received except Tuesday, February 21,2017 Kibbe, Sharon Executive Office Manager I hereby certify that the attached invoice(s),or bill(s),is(are)true and correct and I have audited same in accordance with IC 5-11-10-1.6 20 Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer INVOICE 0217a 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-1986559 C.L.Coonrod S Company 3860 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 February 16,2017 Professional services from February 1 through February 15,2017,in connection with: Additional Appropriation-analysis of C-T budget,preparation for Council meeting, 1,212 preparation and attend hearing follow up,follow up on amendment to transfer ordinance- contact Council members. Assessment-respond to question regarding arts&design revenue. 60 Bond/Lease-respond to questions about future available cash flow. 330 Budget Consultation-pursue DLGF error regarding lack of levy to service property tax 6,773 bonds,tax comparison report,1782 Notice response,budget matters,2017 budget matters, cable franchise fees,follow up on cable fees,follow up on City construction proceeds, Annual report follow up,DLGF questions regarding 1782 Notice,budget follow up matters,property tax arts&design district,corrections to 1782,meeting matters. Fiscal Plan-phone Umbaugh regarding cash flow available to support new debt, 1,140 preparation for meeting with Mayor. Other Consulting-respond and check emails,meetings with senior staff members, 2,850 meeting with settling insurance claim issues,meetings with City officials. Out of pocket expense-mileage - Total amount of this invoice. 12,365 Previous balance. 43,816 Payment received. (16,983 Total amount due. $ 39,198 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL February 16,2017 Professional services from February 1 through February 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 2/6/2017 Additional Appropriations 240 1.10 264 Coonrod 2/6/2017 Additional Appropriations 240. 2.00 480 Coonrod 2/7/2017 Additional Appropriations 240 0.80 192 Coonrod 2/13/2017 Additional Appropriations 240 0.25 60 Coonrod 2/15/2017 Additional Appropriations 240 0.90 216 Additional Appropriations Total 1,212 Coonrod 2/14/2017 Assessment 240 0.25 60 Assessment Total s0 Roeger 2/13/2017 Bond/Lease 220 1.50 330 Bond/Lease Total 330 Lilly 2/1/2017 Budget Consultation 175 0.55 96 Roeger 2/1/2017 Budget Consultation 220 0.70 154 Roeger 2/1/2017 Budget Consultation 220 0.25 55 Roeger 2/1/2017 Budget Consultation 220 0.25 55 Roeger 2/1/2017 Budget Consultation 220 0.60 132 Coonrod 2/1/2017 Budget Consultation 240 0.25 60 Roeger 2/1/2017 Budget Consultation 220 1.35 297 Lilly 2/2/2017 Budget Consultation 175 1.75 306 Roeger 2/6/2017 Budget Consultation 220 1.50 330 Roeger 2/6/2017 Budget Consultation 220 2.65 583 Roeger 2/7/2017 Budget Consultation 220 0.10 22 Roeger 2/7/2017 Budget Consultation 220 1.50 330 Roeger 2/7/2017 Budget Consultation 220 0.80 176 Roeger 2/8/2017 Budget Consultation 220 2.00 440 Roeger 2/8/2017 Budget Consultation 220 1.05 231 Roeger 2/8/2017 Budget Consultation 220 4.50 990 Coonrod 2/8/2017 Budget Consultation 240 0.05 12 Lilly 2/9/2017 Budget Consultation 175 1.75 306 Roeger 2/9/2017 Budget Consultation 220 1.20 264 Roeger 2/10/2017 Budget Consultation 220 0.90 198 Coonrod 2/10/2017 Budget Consultation 240 0.05 12 Coonrod 2/13/2017 Budget Consultation 240 0.05 12 Roeger 2/14/2017 Budget Consultation 220 0.20 44 Roeger 2/14/2017 Budget Consultation 220 0.35 77 Roeger 2/14/2017 Budget Consultation 220 0.80 176 Roeger 2/14/2017 Budget Consultation 220 2.50 550 Lilly 2/15/2017 Budget Consultation 175 0.10 18 Roeger 2/15/2017 Budget Consultation 220 1.50 330 Roeger 2/15/2017 Budget Consultation 220 1.30 286 Roeger 2/15/2017 Budget Consultation 220 1.05 231 Budget Consultation Total 6,773 Coonrod 2/13/2017 Plan 240 0.15 36 Coonrod 2/14/2017 Plan 240 1.75 420 Coonrod 2/14/2017 Plan 240 0.20 48 Coonrod 2/15/2017 Plan 240 2.65 636 Plan Total 1,140 Engelking 2/1/2017 Other Consulting 150 0.50 75 Engelking 2/2/2017 Other Consulting 150 0.50 75 Engelking 2/3/2017 Other Consulting 150 2.00 300 Engelking 2/6/2017 Other Consulting 150 2.25 338 Engelking 2/6/2017 Other Consulting 150 1.00 150 Engelking 2/7/2017 Other Consulting 150 2.50 375 Engelking 2/8/2017 Other Consulting 150 2.75 412 Engelking 2/9/2017 Other Consulting 150 1.00 150 Engelking 2/10/2017 Other Consulting 150 1.50 225 Engelking 2/13/2017 Other Consulting 150 1.00 150 Engelking 2/14/2017 Other Consulting 150 1.00 150 Engelking 2/15/2017 Other Consulting 150 3.00 450 Other Consulting Total 2,850 Publishing&printing 0 Mileage 0 TOTAL invoice amount 12,365 INVOICE 0217-A 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 February 7,2017 Professional services from December 29 through February 5,2017,in connection with: Compensated Absences $ 84 2016 Bond Issues 132 Accounts Payable 388 Enterprise Funds 60 GASB 77 348 OPEB 48 PERS Pensions 36 Response to Auditors 96 Trial Balance 956 Statistical Section 140 Trust Cash 276 Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17,2017. ($68,000) 2,564 Work outside scope-correct out-of-balance client ledger 180 Total amount of this invoice. 2,744 Previous balance. - Payment received. - Total amount due. $ 2,744 Payable upon receipt. Call(317)844-4605 with questions. City of Carmel 2016 CAFR Time Budget REVISED 2/8/17 CLC BWR SLL ELH Total January Set up initial TB 240 1240 1480 956 0 Trust cash 960 2640 620 4220 276 0 AR-property tax 240 700 940 AR-income tax 240 220 700 1160 AR-ambulance 240 220 460 AR-Medicaid supplemental 240 220 460 Capital assets 240 1400 1640 Capital leases 240 700 940 Accounts payable 240 220 1240 1700 388 Accrued wage 240 220 775 1235 Compensated absences 240 220 620 1080 84 Bond premium,deferred rev 240 2100 2340 Bond principal,debt disclosure 240 2100 2340 2016 bond issues 1920 2800 4720 132 Local pensions 720 1050 1770 PERS pensions 720 1400 2120 36 OPEB 720 2100 2820 48 Enterprise funds 3840 3840 60 GASB 77 0 0 0 0 0 348 Net investment in capital assets 480 1050 1530 MD&A 480 1400 1880 Budgetary statements 240 2480 2720 Finalize and reconcile statements 2880 700 3580 GFOA checklist 1440 350 1790 Introductory section,CAM prep 240 1050 1290 Statistical section 480 2100 2580 140 Responses to Auditors 3840 440 2800 310 7390 96 Total 21840 4400 24500 7285 58025 2564 Work outside of Scope 0 0 0 0 0 180 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 Rates 250 230 175 155 810 Fees ?.5 S 4.400 S 24.500 S 7.285 S 62.393 $ 2,744 INVOICE 0217-B P.O. Board of Works 30`01 City of Carmel Attn:Sharon Kibbe One Civic Square Cannel,IN 46032 Make check payable to: Tax ID#36-1986669 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 226 Indianapolis,Indiana 46240 i February 14,2017 Professional services from February 6 through February 12,2017,in connection with: 2016 CAFR: 2016 Bonds 1,173 Accounts Payable 2,744 Accrued Wage 36 Bond Premium,Deferred Revenue 1,003 Capital Assets 394 GASB 77 516 Local Pensions 787 MD&A 814 PERS Pensions 314 Response to Auditors 348 Statistical Section 796 Trust Cash 242 Subtotal. 9,167 Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17,2017. ($68,000) 9,167 Work outside scope- - Total amount of this invoice. 9,167 Previous balance. 2,744 Payment received. - Total amount due. $ 11,911 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL February 14,2017 Professional services from February 6 through February 12,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 Lilly 2/6/2017 2016 Bonds 175 1.90 333 Lilly 2/9/2017 2016 Bonds 175 4.80 840 2016 Bonds Total 1,173 Hibler 2/6/2017 Accounts Payable 155 3.50 543 Hibler 2/7/2017 Accounts Payable 155 2.30 357 Hibler 2/7/2017 Accounts Payable 155 2.10 325 Hibler 2/8/2017 Accounts Payable 155 1.05 163 Hibler 2/8/2017 Accounts Payable 155 1.25 194 Hibler 2/9/2017 Accounts Payable 155 2.85 442 Hibler 2/9/2017 Accounts Payable 155 1.50 232 Hibler 2/10/2017 Accounts Payable 155 2.20 341 Hibler 2/10/2017 Accounts Payable 155 0.95 147 Accounts Payable Total 2,744 Coonrod 2/7/2017 Accrued Wage 240 0.15 36 Accrued Wage Total 36 Lilly 2/7/2017 Bond Premium,Deferred Revenue 175 3.15 551 Coonrod 2/9/2017 Bond Premium,Deferred Revenue 240 0.50 120 Lilly 2/10/2017 Bond Premium,Deferred Revenue 175 1.35 236 Coonrod 2/10/2017 Bond Premium,Deferred Revenue 240 0.40 96 Bond premium,deferred revenue Total 1,003 Lilly 2/2/2017 Capital Assets 175 0.50 88 Lilly 2/6/2017 Capital Assets 175 1.75 306 Capital Assets Total 394 Coonrod 2/6/2017 GASB 77 240 0.30 72 Coonrod 2/8/2017 GASB 77 240 1.00 240 Coonrod 2/10/2017 GASB 77 240 0.85 204 GASB 77 Total 516 Lilly 2/2/2017 Local Pensions 175 2.10 367 Lilly 2/6/2017 Local Pensions 175 2.40 420 Local Pensions Total 787 Lilly 2/3/2017 MD&A 175 4.65 814 MD&A Total 814 Coonrod 2/9/2017 PERS Pensions 240 0.25 60 Lilly 2/10/2017 PERS Pensions 175 1.45 254 PERS Pensions Total 314 Coonrod 2/9/2017 Response to Auditors 240 1.05 252 Coonrod 2/10/2017 Response to Auditors 240 0.40 96 Response to Auditors Total 348 Lilly 2/8/2017 Statistical Section 175 4.55 796 Statistical Section Total 796 Roeger 2/9/2017 Trust Cash 220 1.00 220 Roeger 2/10/2017 Trust Cash 220 0.10 22 Trust Cash Total 242 Publishing&printing 0 Mileage 0 TOTAL invoice amount 9,167 City of Carmel 2016 CAFR Time Budget REVISED 2/14/17 CLC BWR SLL ELH Total January February Set up initial TB 240 1240 1480 956 0 Trust cash 960 2640 620 4220 276 242 0 AR-property tax 240 700 940 AR-income tax 240 220 700 1160 AR-ambulance 240 220 460 AR-Medicaid supplemental 240 220 460 Capital assets 240 1400 1640 394 Capital leases 240 700 940 Accounts payable 240 220 1240 1700 388 2744 Accrued wage 240 220 775 1235 36 Compensated absences 240 220 620 1080 84 Bond premium,deferred rev 240 2100 2340 1003 Bond principal,debt disclosure 240 2100 2340 2016 bond issues 1920 2800 4720 132 1173 Local pensions 720 1050 1770 787 PERS pensions 720 1400 2120 36 314 OPEB 720 2100 2820 48 Enterprise funds 3840 3840 60 GASB 77 0 0 0 0 0 348 516 Net investment in capital assets 480 1050 1530 MD&A 480 1400 1880 814 Budgetary statements 240 2480 2720 Finalize and reconcile statements 2880 700 3580 GFOA checklist 1440 350 1790 Introductory section,CAFR prep 240 1050 1290 Statistical section 480 2100 2580 140 796 Responses to Auditors 3840 440 2800 310 7390 96 348 Total 21840 4400 24500 7285 58025 2564 9167 Work outside of Scope 0 0 0 0 0 180 0 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 Rates 250 230 175 155 810 Fees $ 26.208 $ 4.400 $ 24.500 $ 7.285 $ 62.393 $ 2,744 $ 9,167