Loading...
HomeMy WebLinkAbout332162 11/13/18 CITY OF CARMEL, INDIANA VENDOR: 00351669 y; ONE CIVIC SQUARE H J UMBAUGH &ASSOCIATES CHECK AMOUNT: $****32,050.00* 3 CARMEL, INDIANA 46032 8365 KEYSTONE CROSSING STE 300 CHECK NUMBER: 332162 9yy�TON c�a' INDIANAPOLIS IN 46240 CHECK DATE: 11/13/18 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 601 5023990 155124 32,050.00 OTHER EXPENSES VOUCHER NO. 183267 WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev 1995) ALLOWED 20 Vendor# 00351669 IN SUM OF$ ACCOUNTS PAYABLE VOUCHER H 3 UMBAUGH &ASSOC CITY OF CARMEL 6113(� y J An invoice or bill to be properly itemized must show: kind of service,where performed, r�o11 49459 - k-, dates service rendered, by whom, rates per day, number of hours, rate per hour, INDIANAPOLIS, IN 46240 a�87 numbers of units, price per unit,etc. Payee $32,050.00 00351669 Purchase Order No. ON ACCOUNT OF APPROPRATION FOR H I UMBAUGH &ASSOC Terms Carmel Water Utility 20 E 91ST STREET Due Date BOARD MEMBERS P O BOX 40458 I hereby certify that that attached invoice(s), INDIANAPOLIS, IN 46240 or bill(s)is(are)true and correct and that PO# ACCT# the materials or services itemized thereon for DATE INVOICE# Description DEPT# INVOICE# Fund# AMOUNT which charge is made were ordered and DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 155124 01-6320-08 $32,050.00 and received except 11/2/2018 155124 $32,050.00 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 Cost distribution ledger classification if claim paid motor vehicle highway fund. 20_ Clerk-Treasurer H. J. Umbaugh & Associates Certified Public Accountants,LLP 8365 Keystone Crossing, Suite 300 Indianapolis,IN 46240-2687 (317)465-1500 Carmel Municipal Water Utility Ms. Christine Pauley, Clerk-Treasurer Purchase Order No. W10045 One Civic Square Carmel, IN 46032 cpauley@carrneLin.gov Invoice No. 155124 Please Include Invoice Number with Remittance Date 09/2812018 Client No. C00625.WAT4 For professional services rendered in connection with the analysis of the Water Utility rates and charges, the financial planning associated with the issuance of Waterworks Revenue Bonds through the State Revolving Fund and other related matters. The fees payable are billed pursuant to an Agreement for Professional Services and Purchase Order No.W 10045. DATE SERVICE STAFF HOURS 03/23/2018 Meeting Miller 0.25 Conference w/L.Matthes 03/26/2018 Engagement Planning Hadler 0.75 Kickoff meeting 03/26/2018 Engagement Planning Miller 0.25 Review proposed agreement 03/26/2018 Meeting Miller 0.50 Engagement kickoff w/C.De Witt&S.Hadler 03/26/2018 Meeting DeWitt 0.75 Planning meeting w/S.Miller&S.Hadler 03/27/2018 Engagement Planning Miller 0.25 Finalize&send engagement letter 04/03/2018 Engagement Planning DeWitt 1.00 Discussion/work w/S.Hadler to prepare&circulate data request 04/03/2018 Correspondence Hadler 1.00 Data request 04/10/2018 Correspondence DeWitt 0.50 Correspondence w/S.Hadler&client re: data received 04/11/2018 Correspondence DeWitt 0.50 Correspondence w/S Miller&J.Duffy 04/11/2018 Meeting Miller 0.50 Conference w/C.De Witt re: status&next steps 04/13/2018 Correspondence DeWitt 0.25 Correspondence w/S.Hadler 04/16/2018 Umbaugh Reports-Prep Hadler 5.75 Input trial balance 04/19/2018 Correspondence DeWitt 0.25 Conference call planning; discussion w/S.Hadler 04/19/2018 Umbaugh Reports-Prep Hadler 3.25 AR 04/20/2018 Teleconference DeWitt 0.50 Conference call w/J.Duffy&T.Spearman H. J. Umbaugh&Associates Carmel Municipal Water Utility Invoice No. 155124 Page 2 DATE SERVICE STAFF HOURS 04/20/2018 Teleconference Hadler 1.25 Phone call re: outstanding items 04/20/2018 Teleconference Miller 1.00 Conference call&discussion 04/20/2018 Umbaugh Reports-Prep DeWitt 0.75 Work w/S.Hadler on rate analysis 04/25/2018 Umbaugh Reports-Prep Hadler 3.75 Pres gen 04/25/2018 Umbaugh Reports-Prep DeWitt 0.50 Work w/S.Hadler on payroll analysis 04/27/2018 Correspondence DeWitt 0.25 Correspondence w/S.Hadler 04/27/2018 Umbaugh Reports-Prep Hadler 1.00 Pres gen 04/30/2018 Umbaugh Reports-Prep Hadler 2.50 Pres gen 05/01/2018 Correspondence DeWitt 0.25 Correspondence re: meeting w/SRF 05/01/2018 Umbaugh Reports- Prep Hadler 3.50 Pres gen 05/02/2018 Correspondence DeWitt 0.25 Work w/S.Hadler on rate study questions 05/02/2018 Correspondence Miller 0.25 Working group emails 05/02/2018 Umbaugh Reports- Prep Hadler 4.00 Pres gen 05/03/2018 Correspondence DeWitt 0.25 . Correspondence w/S.Miller 05/03/2018 Umbaugh Reports- Prep DeWitt 1.00 Work w/S.Hadler on Carmel report scenarios 05/03/2018 Umbaugh Reports- Prep Hadler 4.00 Pres gen 05/04/2018 Correspondence DeWitt 0.25 Rate study questions/discussion w/S.Hadler 05/04/2018 Umbaugh Reports-Prep Hadler 2.50 Pres gen 05/07/2018 Engagement Planning Miller 0.25 Finalize agreement&send to J.Duffy 05/07/2018 Umbaugh Reports-Prep DeWitt 0.50 Work w/S.Hadler on proposed bond structuring 05/07/2018 Umbaugh Reports-Prep Hadler 4.25 Pres gen 05/10/2018 Correspondence Miller 0.25 Emails w/J.Duffy 05/11/2018 Correspondence DeWitt 0.25 05/14/2018 Umbaugh Reports-Prep DeWitt 1.25 Work w/S. adler on rate report prep. 05/14/2018 Umbaugh Reports-Prep Hadler 1.75 Pres gen 05/14/2018 Umbaugh Reports-Review DeWitt 1.50 Review rate report 05/15/2018 Umbaugh Reports-Review DeWitt 0.50 Review rate report H. J. Umbaugh &Associates Carmel Municipal Water Utility Invoice No. 155124 Page 3 DATE SERVICE STAFF HOURS 05/16/2018 Umbaugh Reports-Prep Hadler 0.50 Discuss outstanding questions 05/16/2018 Umbaugh Reports-Review DeWitt 1.00 Review draft of rate report; correspondence re: open items 05/18/2018 Correspondence DeWitt 0.25 05/22/2018 Umbaugh Reports- Prep Hadler 1.00 Financials 05/24/2018 Umbaugh Reports- Prep Hadler 0.50 Pres gen 05/24/2018 Umbaugh Reports-Review DeWitt 3.75 Review rate report 05/29/2018 Umbaugh Reports-Prep Hadler 2.50 Pres gen 05/30/2018 Meeting Hadler 0.75 Discuss pension expense 05/30/2018 Umbaugh Reports- Review DeWitt 0.75 Review revised rate report; correspondence w/S.Hadler&S.Miller 06/04/2018 Correspondence DeWitt 0.25 07/10/2018 Communications DeWitt 0.25 07/11/2018 Financial Analysis DeWitt 0.50 07/12/2018 Financial Analysis DeWitt 6.25 Review revised rate report&detailed analysis 07/13/2018 Financial Analysis Hadler 2.50 Report-rate study 07/17/2018 Financial Analysis Hadler 2.00 Report-add URT adjustment; email to Ted re: outstanding items 07/17/2018 Financial Analysis DeWitt 0.50 Report-discuss revisions w/S.Hadler 07/18/2018 Financial Analysis Hadler 1.25 Report-update revenue requirements 07/18/2018 Financial Analysis - DeWitt 0.50 Prepare report/revisions discussion w/S.Hadler 07/19/2018 Financial Analysis DeWitt 1.75 Report-review revised rate report 07/19/2018 Financial Analysis Hadler 0.75 Report-adjust revenue requirements 07/20/2018 Financial Analysis DeWitt 1.75 Report-review discussion w/S.Miller 07/20/2018 Financial Analysis Miller 6.00 Report-review draft rate study 07/20/2018 Financial Analysis Hadler 0.25 Report-rate study 07/23/2018 Financial Analysis Hadler 2.00 Report-update amortization schedules 07/23/2018 Financial Analysis DeWitt 0.50 Report-prep revision discussion w/S.Hadler 07/23/2018 Communications Miller 0.25 Working group emails 07/24/2018 Communications DeWitt 0.25 07/25/2018 Financial Analysis Miller 0.25 Prep-discussions w/S.Hadler re: report revisions H. J. Umbaugh&Associates Carmel Municipal Water Utility Invoice No. 155924 Page 4 DATE SERVICE STAFF HOURS 07/25/2018 Financial Analysis Miller 1.00 Report-review draft rate report 07/25/2018 Financial Analysis Hadler 5.00 Report-update project costs/revenue requirements 07/25/2018 Financial Analysis DeWitt 0.75 Report-review revised rate report 07/26/2018 Financial Analysis Hadler 0.50 Report-discuss changes following meeting w/City 07/26/2018 Financial Analysis DeWitt 1.50 Report: revising report for meeting 07/26/2018 Communications DeWitt 0.50 Meeting follow up discussion of revisions w/S.Hadler 07/26/2018 Meetings DeWitt 2.50 Meeting &round trip travel to discuss draft of rate& financing report 07/26/2018 Meetings Miller 1.75 Prep for working group meeting 07/26/2018 Meetings Miller 2.00 Working group meeting to discuss draft rate analysis 07/26/2018 Travel Miller 0.50 Travel to utility office 07/27/2018 Financial Analysis Morris 0.25 Feasibility-project costs for alternatives one&two 07/30/2018 Communications Miller 0.25 Email to SRF re: proposed meeting 07/31/2018 Financial Analysis Hadler 2.50 Report-update project alternatives 07/31/2018 Financial Analysis Morris 0.75 Report-edit/proof final report 08/01/2018 Communications Miller 0.25 Emails re: SRF status 08/06/2018 Communications Miller 0.25 Emails w/SRF 08/07/2018 . Communications Miller 0.25 Phone call w/B.Harkins 08/08/2018 Financial Analysis DeWitt 0.25 Report:follow up re: revisions to report 08/14/2018 Financial Analysis Hadler 1.00 Report-prep for meeting w/SRF 08/14/2018 Meetings j Hadler 1.50 Meeting w/SRF to discuss financing scenarios 08/14/2018 Meetings Miller 1.50 Working group meeting w/SRF 08/14/2018 Travel Hadler 1.00 Travel to/from meeting 08/14/2018 Travel Miller 1.00 Round trip travel to utility office 08/17/2018 Financial Analysis Hadler 1.00 Report-update pro forma operating expenses 08/17/2018 Communications Miller 0.50 Phone calls&emails w/working group 08/20/2018 Financial Analysis Miller 3.00 Feasibility-gather data&email SRF re: ability to access program H. J. Umbaugh &Associates Carmel Municipal Water Utility Invoice No. 155124 Page 5 DATE SERVICE STAFF HOURS 08/29/2018 Communications Hilt 0.25 Report request from B.Harkins 08/30/2018 Communications Hadler 0.75 Conference call w/SRF 08/30/2018 Communications Miller 0.75 Phone call w/SRF re: program feasibility 08/31/2018 Financial Analysis Hadler 3.25 Report-update project costs&alternatives 08/31/2018 Communications Miller 0.50 Status email to J Duffy summarizing SRF discussion 09/05/2018 Financial Analysis Miller 0.75 Report-review revisions&discuss w/S.Hadler 09/05/2018 Financial Analysis Miller 1.00 Report-finalize updated draft&send to J.Duffy 09/05/2018 Financial Analysis Hadler 1.00 Report-update rate study for new interest rates 09/06/2018 Communications Miller 1.00 Conference call w/J.Duffy, T.Spearman&S.Hadler 09/06/2018 Communications Hadler 1.50 Call to discuss updated rate report&SRF conversation 09/11/2018 Communications Hadler 0.50 Conference call w/J.Duffy to discuss SRF process 09/11/2018 Communications Miller 0.50 Phone call w/J.Duffy 09/18/2018 Financial Analysis Hadler 0.50 Report-update test year Current Amount Due $ 32.050.00 PLEASE REMIT TO: UMBAUGH 8365 KEYSTONE CROSSING, SUITE 300 INDIANAPOLIS, IN 46240-2687