Loading...
HomeMy WebLinkAbout311637 5/30/2017 CITY OF CARMEL, INDIANA VENDOR: 071300 e ONE CIVIC SQUARE C. L. COONROD & COMPANY CHECK AMOUNT: $****22,214.00* =4 CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 311637 M�,or�° ININ 46240 ITE 225 CHECK DATE: 05/30/17 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4340303 100303 0417B 464.00 ACCOUNTING SERVICES 1160 4340303 34499 0417B 11,211.00 ACCTG SERVICES FOR 20 1160 4340303 100303 0517A 564.00 ACCOUNTING SERVICES 1160 4340303 34499 0517A 9,975.00 ACCTG SERVICES FOR 20 o - @ 9 @ < « k k k ) 3 z k 2 k ? 1 A m m n 0 n w w ■ D / r O % 2 \ 0 / k -4 z 2 § k � z / � / O § q q D 0k ® 2 � q > V e CA) _ / 3 \ i § \ $ E \ � < T. � z 2 z 2 $ 2 2 3 §f $ / m | \ E EZ k a i 3 R / z k g ( k ƒ / E { A 0 ƒ J m m e a ; k § § 0 2 2 E 7 E $# / / f i o / + - C 7 s « 4 % 3 2 \ ƒ M 0 O 0 E 2 I § ' § CDI E » co 2 w i s - / 2 CD k « \ \ = f C C 2 3 [ » - < ƒ %I \ \_ § § E ! ƒ2 2 -4 § ) \ \ k t7 0 > \ (D ) 0 # § k 2 \ C \0 CD 0 } w w C3 0 \ g } o § k / ƒ f \ = C a 2 �:6 � � © o %k a \ & (in 0. � � D §) } = a 7 � � ;Ur » 2 0 / k � � G Q j E \ \ r- 0 E / z E ] % E 2 C _ ® m % $ / CD / k / 2 CD M \ G (Df \ ] § f 2 ° 0— » & z ) \ 7 2 \ § # f $ C ° E 0 \ INVOICE 0417-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 May 3,2017 Professional services from April 16 through April 30,2017,in connection with: 2016 CAFR: Work outside scope-create formulas to extract data from newest version of the capital assets listing for financial statements,ensuring the numbers match the 2015 report. 464 Total amount of this invoice. 464 Previous balance. 24,992 Payment received. - Total amount due. $ 25,456 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 April Future Set up initial TB 240 1240 1480 956 480 1071 0 2507 0 Trust cash 960 2640 620 4220 276 4641 2964 0 7881 0 AR-property tax 240 700 940 0 599 419 0 1018 AR-income tax 240 220 700 1160 0 473 1125 0 1598 AR-ambulance 240 220 460 0 140 464 0 604 AR-medicaid supplemental 240 220 460 0 396 433 0 829 Capital assets 240 1400 1640 0 1483 280 0 1763 Capital leases 240 700 940 0 0 244 0 244 Accounts payable 240 220 1240 1700 388 3346 290 0 4024 Accrued wage 240 220 775 1235 0 469 35 0 504 Compensated absenses 240 220 620 1080 84 272 490 0 846 Bond premium,deferred rev 240 2100 2340 0 1003 1219 0 2222 Bond principal,debt disclosure 240 2100 2340 0 0 2177 0 2177 2016 bond issues 1920 2800 4720 132 1628 4611 0 6371 Local pensions 720 1050 1770 0 787 1397 0 2184 PERS pensions 720 1400 2120 36 1564 2776 0 4376 OPEB 720 2100 2820 48 148 2615 0 2811 Enterprise funds 3840 3840 60 0 849 1678 2587 GASB 77 0 0 0 0 0 348 888 1331 0 2567 Net investment in capital assets 480 1050 1530 0 84 312 0 396 MD&A 480 1400 1880 0 814 446 1503 2763 Budgetary statements 240 2480 2720 0 101 2875 0 2976 Finalize and reconcile statements 2880 700 3580 0 0 7376 1989 9365 GFOA checklist 1440 350 1790 0 0 155 0 155 Introductory section,CAFR prep 240 1050 1290 0 376 901 166 1443 Statistical section 480 2100 2580 140 1075 193 440 1848 Responses to Auditors 3840 440 2800 310 7390 96 1147 552 0 1795 Total 21840 4400 24500 7285 58025 2564 21914 37600 5776 67854 Work outside of Scope 0 0 0 0 0 180 1849 8888 5956 16873 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 2744 23763 46488 11732 84727 Rates 250 230 175 155 197.71 192.56 243.35 197.40 197.67 208.30 Hours 104.83 22.96 168.00 56.40 352.19 14.25 97.65 235.50 59.35 406.75 INVOICE 0517-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 May 16,2017 Professional services from May 1 through May 14,2017,in connection with: 2016 CAFR: Work outside scope-respond regarding possible compilation report,follow up with SBOA on 2015 audit completion and follow up on possible compilation report-pursue option of modified report for 2015,follow up with SBOA on timing of their 2015 report, council member regarding audit committee meeting,preparation for audit committee meeting. 564 Total amount of this invoice. 564 Previous balance. 25,456 Payment received. 24,992 Total amount due. $ 1,028 Payable upon receipt. Call(317)844-4605 with questions. City of Carmel 2016 CAM Time Budget Total in CLC BWR SLL ELH Total January February March April May Future Set up initial TB 240 1240 1480 956 480 1071 0 0 2507 0 Trust cash 960 2640 620 4220 276 4641 2964 0 0 7881 0 AR-property tax 240 700 940 0 599 419 0 0 1018 AR-income tax 240 220 700 1160 0 473 1125 0 0 1598 AR-ambulance 240 220 460 0 140 464 0 0 604 AR-medicaid supplemental 240 220 460 0 396 433 0 0 829 Capital assets 240 1400 1640 0 1483 280 0 0 1763 Capital leases 240 700 940 0 0 244 0 0 244 Accounts payable 240 220 1240 1700 388 3346 290 0 0 4024 Accrued wage 240 220 775 1235 0 469 35 0 0 504 Compensated absenses 240 220 620 1080 84 272 490 0 0 846 Bond premium,deferred rev 240 2100 2340 0 1003 1219 0 0 2222 Bond principal,debt disclosure 240 2100 2340 0 0 2177 0 0 2177 2016 bond issues 1920 2800 4720 132 1628 4611 0 0 6371 Local pensions 720 1050 1770 0 787 1397 0 0 2184 PERS pensions 720 1400 2120 36 1564 2776 0 0 4376 OPEB 720 2100 2820 48 148 2615 0 0 2811 Enterprise funds 3840 3840 60 0 849 1678 0 2587 GASB 77 0 0 0 0 0 348 888 1331 0 0 2567 Net investment in capital assets 480 1050 1530 0 84 312 0 0 396 MD&A 480 1400 1880 0 814 446 1503 0 2763 Budgetary statements 240 2480 2720 0 101 2875 0 0 2976 Finalize and reconcile statements 2880 700 3580 0 0 7376 1989 0 9365 GFOA checklist 1440 350 1790 0 0 155 0 0 155 Introductory section,CAFR prep 240 1050 1290 0 376 901 166 0 1443 Statistical section 480 2100 2580 140 1075 193 440 0 1848 Responses to Auditors 3840 440 2800 310 7390 96 1147 552 0 0 1795 Total 21840 4400 24500 7285 58025 2564 21914 37600 5776 0 67854 Work outside of Scope 0 0 0 0 0 180 1849 8888 5956 564 16873 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 2744 23763 46488 11732 564 84727 Rates 250 230 175155 197.71 192.56 243.35 197.40 197.67 240.00 208.30 Hours 104.83 22.96 168.00 56.40 352.19 14.25 97.65 235.50 59.35 2.35 406.75 nE w 0 < « a � k -{ m k k ? E S E S � © 0 k n \ © / O # 2 0 E k q 2 2 \ 0 2 / 90 0 U) @ k SI) O e % f 0 U) © � \ [ \ o Cl) / @ 2 \ § to ƒ 0 R e § e $ a \ CD _0 m . f S S ^ © ¢ � \ # 2 rl) w 2 z % 2 / to > -n 9 « ) oO -4 c | § § § m % £ 2 7 « § § ` 0 $ c o % A 0 ƒ / ƒ o m C ƒ 2 2 0 7 % = @ E F E ) f $ $ f 2 7 § J / 7 0 - 7 s@ f $ 3 § K G E f E / ; o ƒ & k § \ a « E - E c w CL@ - 2 0) C \ / $ E f = & ) CY! ƒ _0 K£ # a mu § s ! � a 0ƒ ) \ 2 ; \ i D \ ) \ C t \ } - § ) \ D \ 4k mm CD C a � 2) D ( « § m {§ E g e< \f % 0 > f } ) C) D =r \ \ CL 2 o @ 0 / j E / r- 0 U) % ) / \ ƒ C TCD\ § $ / CD p BCL 2 pff n co8 m f \ � ] § k \ E § E _ » > E k k 0 < a E ' k n INVOICE 0417b 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 May 3,2017 Professional services from April 16 through April 30,2017,in connection with: Bond/Lease-questions from Council member regarding proposed bond,follow up with $ 2,645 financial advisor regarding current bond proposal to put into plan,Capital Improvement plan,review existing obligations,bond matters,follow up on OPEB items,update plan for bond and CIP. Budget Consultation-Prepare 2018 proposed budget analysis for chief of staff,budget 2,045 comparison,road funding follow up,review budget comparison,budget matters. Cumulative Fund-emailed client for ordinance number,corrected document,follow up 139 on council member questions,email to client to provide notice in news papers,Carmel Council meeting items. Other Consulting-emails regarding transition of new staff,claims discussions,separate 3,075 meetings with senior staff on Energy Center review and data requested;legal bill discussions;transition coordination;meeting on staff realignment plans. Plan-plan updates,review of plan,updates for retiree health,capital improvement plan, 3,209 review expenditure formulas. Out of pocket expense-publishing of CCD Fund notices. 98 Total amount of this invoice. 11,211 Previous balance. 13,830 Payment received. - Total amount due. $ 25,041 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL May 3,2017 Professional services from April 16 through April 30,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 4/26/2017 Bond/Lease 240 0.05 12 Coonrod 4/26/2017 Bond/Lease 240 1.80 432 Roeger 4/27/2017 Bond/Lease 220 1.80 396 Roeger 4/27/2017 Bond/Lease 220 2.45 539 Coonrod 4/27/2017 Bond/Lease 240 1.25 300 Roeger 4/28/2017 Bond/Lease 220 0.80 176 Roeger 4/28/2017 Bond/Lease 220 2.50 550 Coonrod 4/28/2017 Bond/Lease 240 1.00 240 Bond/Lease Total 2,645 Lilly 4/20/2017 Budget Consultation 175 1.75 306 Coonrod 4/21/2017 Budget Consultation 240 0.55 132 Coonrod 4/24/2017 Budget Consultation 240 0.65 156 Hibler 4/25/2017 Budget Consultation 155 1.50 233 Roeger 4/25/2017 Budget Consultation 220 0.10 22 Coonrod 4/25/2017 Budget Consultation 240 1.20 288 Hibler 4/26/2017 Budget Consultation 155 0.45 69 Hibler 4/26/2017 Budget Consultation 155 0.70 109 Lilly 4/27/2017 Budget Consultation 175 1.75 306 Coonrod 4/28/2017 Budget Consultation 240 0.85 204 Roeger 4/28/2017 Budget Consultation 220 1.00 220 Budget Consultation Total 2,045 Hibler 4/18/2017 Cumulative Fund 155 0.35 54 Coonrod 4/18/2017 Cumulative Fund 240 0.10 24 Hibler 4/19/2017 Cumulative Fund 155 0.25 39 Roeger 4/26/2017 Cumulative Fund 220 0.10 22 Cumulative Fund Total 139 Engelking 4/17/2017 Other Consulting 150 2.00 300 Engelking 4/18/2017 Other Consulting 150 2.00 300 Engelking 4/19/2017 Other Consulting 150 3.50 525 Engelking 4/20/2017 Other Consulting 150 1.50 225 Engelking 4/21/2017 Other Consulting 150 1.50 225 Engelking 4/24/2017 Other Consulting 150 1.50 225 Engelking 4/25/2017 Other Consulting 150 1.50 225 Engelking 4/26/2017 Other Consulting 150 4.00 600 Engelking 4/27/2017 Other Consulting 150 2.00 300 Engelking 4/28/2017 Other Consulting 150 1.00 150 Other Consulting Total 3,075 Coonrod 4/18/2017 Plan 240 2.15 516 Coonrod 4/19/2017 Plan 240 1.25 300 Hibler 4/20/2017 Plan 155 0.45 70 Coonrod 4/20/2017 Plan 240 1.90 456 Coonrod 4/21/2017 Plan 240 1.85 444 Roeger 4/25/2017 Plan 220 0.10 22 Coonrod 4/25/2017 Plan 240 0.10 24 Roeger 4/26/2017 Plan 220 2.10 462 Coonrod 4/26/2017 Plan 240 0.05 12 Roeger 4/26/2017 Plan 220 1.05 231 Roeger 4/26/2017 Plan 220 1.80 396 Coonrod 4/27/2017 Plan 240 1.15 276 Plan Total 3,209 Publishing&printing-CCD advertisement 98 Mileage 0 TOTAL invoice amount 11,211 INVOICE 0517a 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 May 14,2017 Professional services from May 1 through May 14,2017,in connection with: Bond/Lease-Review fiscal position. $ 770 Budget Consultation-Budget matters,update to projection for budget purposes,budget 2,474 comparison,road funding,IWC line proposal-respond to question,COIT data follow up, pre-budget review worksheets,funding for items. Cumulative Fund-respond to question from Council member,preparation for Finance 972 Committee meeting,attend Finance Committee meeting,follow up on meeting. Legislation-HB1002 impact,legislation follow up. 682 Other Consulting-emails/phone calls,review of correspondence for energy center, 3,375 meetings with senior staff about energy center,meeting with senior staff about personnel matters and 2018 budget. Plan-call client regarding funding for bond and newly available MVH revenue,update 1,702 MVH revenue assumptions for new legislation-impact of bond totals proposed,plan updates,review capital improvement plan. Out of pocket expense- - Total amount of this invoice. 9,975 Previous balance. 25,041 Payment received. (13,830) Total amount due. $ 21,186 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL May 14,2017 Professional services from May 1 through May 14,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 5/1/2017 Bond/Lease 240 1.65 396 Roeger 5/11/2017 Bond/Lease 220 1.70 374 Bond/Lease Total 770 Roeger 5/1/2017 Budget Consultation 220 1.25 275 Lilly 5/2/2017 Budget Consultation 175 1.45 254 Roeger 5/2/2017 Budget Consultation 220 0.40 88 Hibler 5/2/2017 Budget Consultation 155 0.55 85 Coonrod 5/2/2017 Budget Consultation 240 0.65 156 Roeger 5/2/2017 Budget Consultation 220 1.00 220 Coonrod 5/4/2017 Budget Consultation 240 1.20 288 Coonrod 5/4/2017 Budget Consultation 240 1.10 264 Lilly 5/4/2017 Budget Consultation 175 1.75 306 Roeger 5/9/2017 Budget Consultation 220 0.25 55 Roeger 5/11/2017 Budget Consultation 220 0.50 110 Roeger 5/11/2017 Budget Consultation 220 0.30 66 Lilly 5/11/2017 Budget Consultation 175 1.75 307 Budget Consultation Total 2,474 Coonrod 5/1/2017 Cumulative Fund 240 1.70 408 Coonrod 5/4/2017 Cumulative Fund 240 0.05 12 Coonrod 5/4/2017 Cumulative Fund 240 2.30 552 Cumulative Fund Total 972 Roeger 5/2/2017 Legislation 220 2.40 528 Roeger 5/2/2017 Legislation 220 0.70 154 Legislation Total 682 Engelking 5/1/2017 Other Consulting 150 2.00 300 Engelking 5/2/2017 Other Consulting 150 1.50 225 Engelking 5/3/2017 Other Consulting 150 3.50 525 Engelking 5/4/2017 Other Consulting 150 2.00 300 Engelking 5/5/2017 Other Consulting 150 1.50 225 Engelking 5/8/2017 Other Consulting 150 3.50 525 Engelking 5/9/2017 Other Consulting 150 3.50 525 Engelking 5/10/2017 Other Consulting 150 2.00 300 Engelking 5/11/2017 Other Consulting 150 1.50 225 Engelking 5/12/2017 Other Consulting 150 1.50 225 Other Consulting Total 3,375 Coonrod 5/1/2017 Plan 240 0.45 108 Coonrod 5/2/2017 Plan 240 2.50 600 Hibler 5/3/2017 Plan 155 0.80 124 Coonrod 5/3/2017 Plan 240 0.40 96 Roeger 5/3/2017 Plan 220 0.35 77 Roeger 5/4/2017 Plan 220 0.80 176 Roeger 5/4/2017 Plan 220 0.50 110 Roeger 5/8/2017 Plan 220 1.05 231 Coonrod 5/8/2017 Plan 240 0.40 96 Coonrod 5/12/2017 Plan 240 0.35 84 Plan Total 1,702 Publishing&printing-CCD advertisement 0 Mileage 0 TOTAL invoice amount 9,975