Loading...
HomeMy WebLinkAbout164820 10/16/2008 CITY OF CARMEL, INDIANA VENDOR: 00351455 Page 1 of 1 ONE CIVIC SQUARE LONDON WITTE GROUP LLC 0 j CARMEL, INDIANA 46032. ONE AMERICAN SQUARE SUITE 2600 CHECK AMOUNT: $32,128.00 INDIANAPOLIS IN 46282 CHECK NUMBER: 164820 CHECK DATE: 10/16/2008 DE PARTMENT ACCOUNT PO NUMBER INVOICE NUM AMOUNT DESCRIPTION 501 5023990 19170 14,071.25 OTHER EXPENSES 601 5023990 19277 6,651.45 OTHER EXPENSES 6.0; 5023990 19355 4,555.30 OTHER EXPENSES e01 5023990 19559 6,850.00 OTHER EXPENSES gKs LON D0N WG W'.1'.171T G110 u p Carmel Water Ulility Chen! No: 1002.005 760 3rd Avenue Sly Date: 0113112008 Suite 110 Invoice NO. 19170 Carmel, IN 46032 Progress Billing For services rendered as detailed in the attached summary. 14,071.25 Current Amount Due 14,0 fV� W Certified Public A ccounta"r. One .American Square, Suite 2600 Indianapolis, Indiana 46282 Telephone 1317-634-4747 Facsimile 1317-632-2727 Web I London WitteGi'OWJ.COIII London Witte Group, LLC January Billing Detail Carmel Water Utility 1002.005 Employee Date Hours Invoice Memo Haase 1/2/2008 3.00 $510.00 Working on adjusted revenues for change to Indy rates for existing area and also for the growth estimates provided by the Utility personnel. Haase 1/3/2008 4.00 680.00 Time spent working on Revenues, call and discussion with John Duffy regarding same. Beginning incorporation of changes agreed to with John Duffy on the revenue calculations. Higgins 1/3/2008 1.50 337.50 Conversation with John Duffy and follow -up conversations with Sue re: engagement status and related matters Higgins 1/9/2008 0.50 112.50 Correspondence with Sue on engagement status and open issues with client Higgins 1/10/2008 0.50 125.00 Follow -up conversations with Sue re: status of engagement and open issues Haase 1110/2008 6.00 1050.00 Incorporation of additional meter counts and revenue assumptions into the on going analysis of revenues generated into to finance the needed construction. Emails back forth with utility personnel regarding results of analysis. Higgins 1/11/2008 0.75 187.50 Review information prepared by Sue; conversation with Sue re: same; phone call with John Duffy re: open issues and engagement status Haase 1/11/2008 3.00 525.00 Additional Changes to revenues and expenses to the analysis based on conversations with Utility personnel. Higgins 1/14/2008 0.75 187.50 Conversation with John Duffy re: engagement status and open items follow -up e -mails with Sue re: same. Conversation with Judy re: review of expected projections and summaries from John. Follow -up phone conversation with Sue re: same Gemmecke 1/15/2008 2.00 250.00 Reviewed schedules to date. Spoke with Jim Higgins about revenue projections made by John Duffy. Problem in that Carmel is proposing to change their rate structure from a minimum charge volume to a base charge volume and the volume blocks are different. Need Usage information land of meters by month for the test year. We need to determine, if the test year usage was at Indianapolis rate structure and blocks, how much money would we have collected. Gemmecke 1/15/2008 1.50 137.50 Phone call between Carmel (John Carol), and LWG (Sue, Jim, Judy) regarding rate case revenue projections; rate structure changes; time line Higgins 1/15/2008 1.25 312.50 Conference call with John, Carol, Sue and Judy re: enaagement status, open items and .related matters. London Witte Group, LLC January Billing Detail Carmel Water Utility 1002.005 Employee Date Fours Invoice Memo Higgins 1/15/2008 1.00 $250.00 Conversation and follow -up with Judy re: information forwarded from John Duffy; call to Sue at home to review outstanding and open items in advance of conference call with John later in the afternoon. Haase 1/15/2008 1.25 218.75 Discussion with JH regarding Revenues in the current analysis, conference call with the Utility Superintendent and accountant regarding the revenue numbers used. Higgins 1/21/2008 0.50 125.00 Conversations with Sue re: engagement status and open issues Haase 1/21/2008 6.00 1050.00 Working on eight year Pro Forma Income Statement, Cash Flow and Cash Available for use in analysis to determine financing capabilities for the proposed construction. Higgins 1/22/2008 0.50 125.00 Follow -up with Sue on scheduling meeting with the Mayor and PILT related issues and related matters Haase 1/22/2008 8.00 1400.00 Incorporation of the January 2008 meter counts, projected revenues from Utility for 2008 and increased Availability and Connection Fees into the analysis. Creation of additional schedules that include the 4% annual increase to rates along with the growth. Preparation of Cash Flows and available cash schedules for use in Debt analysis. Telephone conversations with John and Carol and email to same. Higgins 1/25/2008 2.00 500.00 Follow -up conversations with Sue re: rate summary and related matters Haase 1/25/2008 4.00 700.00 Additional changes to the analysis as a result of questions and conversations with Utility Personnel. Rerun of the analysis with chan and provision to all parties involved. Higgins 1/26/2008 1.00 250.00 Preliminary review of Sue's rate analysis Higgins 1/28/2008 1.00 250.00 Review and comment- revenue cash flows and debt service potential; conversation with Sue re: same Higgins 1/28/2008 0.25 62.50 Return call to Scott Peck re: BAN status and various open matters Haase 1/28/2008 8.00 1400.00 Preparation of specific work papers for use in analyzing the financial capabilities for the planned construction. Increasing the 8 year analysis to 20 years for PFIS, Cash Flows and Cash Available for both growth only analysis and for the 4% increase and growth analysis. Higgins 1/29/2008 0.50 12.5.00 Review and comment on revised cash flow and cash available for debt analysis from Sue London Witte Group, LLC January Billing Detail Carmel Water Utility 1002.005 Employee Date Hours Irivoice Memo Higgins 1/29/2008 2.00 $500.00 Draft amortization schedule model to incorporate Sue's cash available for debt service; inquiry to trading desks for reasonable interest rate scale assumptions; check with Sue on open items Haase 1/29/2008 3.00 525.00 Extending the 20 year analysis to 25 years for both growth only and 4% increase and growth. Higgins 1/30/2008 0.50 125.00 Follow -up with Sue re: schedules and coverage calculations Higgins 1 /31/2008 1.00 250.00 Meeting with re: outstanding debt service coverage calculations and related items Higgins 1/31/2008 3.00 750.00 Financial review and edit of Sue's schedules of funds available for debt service; prepare and review an estimated debt service amortization for $75 -80 million financing. Review the same with Bob and Sue. Request Sue send schedules prepared to John and Carol; phone call (message) to John re: same Higgins 1/31/2008 0.50 125.00 Phone call and follow -up e -mail with and to John Duffy, re: conference call with John and Brian on Friday afternoon re: project estimates and timeline; follow -up with Sue re: same Haase 1/3112008 5.00 875.00 Reformatting the financial analysis as discussed with JH and provision of same to JH and to the Utility Personnel. 73.75 $14,071.25 Total due this invoice I LONDON L jWG W 17 F; Gxoup Carmel Water Utility Client No: 1002.003 760 3rd Avenue SW Date: 0413012005 Suite 110 Invoice No: 19.559 Carmel, IN 46032 Progress Bill For services rendered as detailed in the attached summary. 6,850.00 Current Amount Due 6,850.00 Certified Publie Accountants One American Square, Suite 2600 Indianapolis, Indiana 46282 Telephone 1 317- 634 -4747 Facsimile 1 317 -632 -2727 Web I LondonWitteGroup.com London Witte Group, LLC April Billing Detail Carmel Water Utility 1001.005 Employee Date Hours Invoice Memo Higgins 4/2/2008 0.25 $62.50 Follow -up with John Duffy and confirm meetings on April 17th and 21st Higgins 4/4/2008 0.25 62.50 Follow -up conversation with Sue on engagement status and information provided to John Haase 4/4/2008 1.75 306.25 Edit to the Option 2 scenario. Provision Of draft for review including changes to client. Higgins 4/7/2008 2.00 500.00 Review revised schedules as prepared by Sue. Follow -up conversations re: same Haase 4/7/2008 1.00 175.00 Discussions with John Duffy pertaining to the Option 1 and Option 2 exhibits for the committee meeting. Discussion with Jim Higgins regarding the exhibits, changes made as requested by Jim Higgins. Higgins 4/8/2008 0.25 62.50 Fallow -up with Sue re: John Duffy's comments pertaining to revised operation analysis and cash flow Haase 4/8/2008 1.25 218.75 Discussion with John Duffy pertaining to the final versions of the analyses to be provided to Council members. Printing to pdf format and emailing to John for final last review before printing appropriate number of copies and sending to him. Higgins 4/10/2008 0.25 62.50 Follow -up conversations with Sue re: PILT and shared cost analysis Haase 4/10/2008 1.50 262.50 Receipt, review and follow up pertaining to PILT and Common Costs questions put forth by John Duffy and Carol McManama. Lawson 4/14/2008 0.00 21.00 Overnight PAK Haase 4/14/2008 2.75 481.25 Final changes to Options schedules and provision of same electronically to Utility. Also preparation and provision of Options reports in proper number for Utility Director to provide to committee for their review. Higgins 4/14/2008 0.25 62.50 Review weekend email traffic between John and Sue and follow -up with Sue on specific questions Higgins 4/15/2008 0.50 125.00 Receive final operational analysis (10 years) from Sue; conversations re: same Lawson 4/15 /2008 0.00 16.92 Overnight Letter London Witte Group, LLC April Billing Detail Carmel Water Utility 1001.005 Employee Date Hours Invoice Memo Haase 4/17/2008 3.00 $525.00 Preparation for and attendance at the Council Committee meeting with JH regarding the Bond Issue Higgins 4/17/2008 0.00 20.20 Travel to and from Carmel for Council Finance Committee Meeting Higgins 4/17/2008 0.50 125.00 Attend Carmel Council Finance Committee re: revenue bond ordinance Higgins 4/17/2008 0.50 125.00 Review schedules and information prior to Council Finance Committee Meeting Higgins 4/17/2008 0.75 187.50 Travel to City Hall for Council Finance Committee re: revenue bonds and related matters Higgins 4/21/2008 0.25 62.50 Conversations with John Duffy and John A. re; questions on rate information. Higgins 4/21/2008 0.75 187.50 Travel to Carmel for City Council Meeting re: bond ordinance Higgins 4/21/2008 0.00 20.20 Mileage travel to and from Carmel re: City Council Meeting re: Bond Ordinance Higgins 4/21/2008 2.00 500.00 Prepare for attend and present to City Council re: Bond Ordinance; follow -up post meeting with councilmen; Mayor and Utility Director Higgins 4/22/2008 0.50 125.00 Return call and conversation with Francesca (Indpls Star) re: clarification on point related to Monday's Council Meeting re: bond ordinance Higgins 4/22/2008 0.25 62.50 Return call to John Duffy to review prior night's meeting and prepare for this evening's council committee meeting Higgins 4/22/2008 0.50 125.00 Follow -up calls with Sue on prior night's meeting and related matters Higgins 4/22/2008 0.50 125.00 Follow -up calls with John Duffy on revised information requested by the Mayor and related matters in advance of the Council's Utility Committee Meeting Higgins 4/22/2008 0.50 125.00 Travel to Carmel for Council Utility Committee Meeting re: IURC opt out Higgins 4/22/2008 2.00 500.00 Attend Council Utility Committee Meeting re: IURC opt out and related matters; conversation subsequent to the meeting with John Duffy re Higgins 4/22/2008 0.00 20.20 Mileage to and from Carmel re: Council Utility Committee Meeting re: IURC opt out Haase 4/23/2008 0.50 87.50 Discussion with JH regarding results of Council meeting and progression of analysis London Witte Group, LLC April Billing Detail Carmel Water Utility 1001.005 Employee Date Hours Invoice Memo Higgins 4/23/2008 0.25 $62.50 Follow -up conversation with Sue re: Council and Committee Meeting actions Higgins 4/23/2008 0.50 125.00 Return call to John Duffy (with Sue) to review status of rates and council /committee meeting schedule and related matters Higgins 4/23/2008 0.25 62.50 Return call to Francesca (Star) re: additional follow -up and clarification on council action re: water rate study Higgins 4/23/2008 0.50 j 125.00 Post Duffy call conversations re: rate analysis option and other matters Higgins 4/25/2008 1.00 250.00 Conversation with Sue re: rate proposal set -up and process Higgins 4/25/2008 0.50 125.00 Review cash flows and work on bond assumptions for Bob Swintz 4/29/2008 1.00 225.00 Work on numbers for debt service Higgins 4/29/2008 1.00 250.00 Follow -up with Bob re: potential bond schedules; review and comment on initial draft; offer suggestions and review revised run; forward to Sue for review and comment. Haase 4/29/2008 0.50 87.50 Discussion with John Duffy pertaining to the pro forma revenues and any additional adjustments to the test year for the determination of rates. Haase 4/30/2008 075 131.25 Preparation and provision of update to JD regarding the amount of bonding that we can issue under Options 1 and 2 Higgins 4/30/2008 0.25 62.50 Follow -up with Sue on getting information to John Duffy re: financing Lawson 4/30/2008 0.00 1.48 31.00 $q,850.00 Total due this invoice f LON DON LWG AVITTE G iwu i) Carmel Water Utility Client No: 1002.005 760 3rd Avenue SW Date: 0212912008 Suite 110 Invoice No. 19277 Carmel, IN 46032 Progress Billing For services rendered as detailed in the attached summary. 6,651.45 Current Amount Due 6,651.45 1 Of U� 1 r� l b� �l Certified Public Acconnlants One American Square, Suite 2600 Indianapolis, Indiana 46282 Telephone 1317-634-4747 Facsimile 1 317- 632 -2727 Web I London WitteGroup.com TM London Witte Group, LLC February Billing Detail Carmel Water Utility 1002.005 Employee Date Hours I nvoice Memo Haase 2/1/2008 1.25 218.75 Preparation for and Participation for Conference call pertaining to next weeks meeting with the Mayor. Discussion of funding available for the construction needs. Haase 2/1/2008 1.25 218.75 Receipt of updated average consumption for 1.5 and 2 inch meters. Incorporation into analysis to ascertain the effects on revenue difference amounts. Discussion of results with JD and discussion that Revenue amount stands as originally provided by JD. Higgins 2/1/2008 0.25 62.50 Call with John Duffy to confirm time of conference call; review call schedule and e -mail out dial in instructions to the participants. Higgins 2/1/2008 0.75 187.50 Prepare for and participate in a conference call with John, Carol, Brian and Sue re: rate analysis and potential debt service; follow -up with Sue re; same Higgins 2/4/2008 1.00 250.00 Follow -up with Sue re: John Duffy's questions over the weekend concerning opting out of the IURC and related matters Higgins 2/4/2008 0.50 125.00 Follow -up conversation with Sue re: information prepared and sent to John and Carol re: IURC opt -out and related matters Mercer 2/4/2008 1.00 250.00 discuss rate case analysis with sue and fees to charge Haase 2/4/2008 2.00 350.00 Preparation of estimated rate case costs if before IURC versus non regulated. Additional reasons for the City to pursue opting out of the IURC jurisdiction. Discussion of same with DM of LWG. Haase 2/5/2008 2.25 393.75 Answering Utility Accountants questions regarding the excel spreadsheets pertaining to Depreciation and to the $35 million BAN. Preparation and provision of the surrounding /other City rates comparison for Utility Superintendent to provide to Mayor for the meeting on Thursday. Haase 2/6/2008 0.25 43.75 Discussion with JPH regarding meeting with Mayor. Higgins 2/6/2008 0.25 62.50 Conversation with John Duffy re: Thursday's meeting with the Mayor; follow -up calls with Sue re: same Higgins 2/7/2008 0.50 125.00 Travel to City Hall for meeting with John Duffy, Randy Seger and Mayor Brainard London Witte Group, LLC February Billing Detail Carmel Water Utility 1002.005 Employee Date Hours Invoice Memo re: water utility matters Higgins 2/7/2008 0.00 20.20 Travel to and from City Hall for meeting with John Duffy, Randy Seger and Mayor Brainard re: water utility matters Higgins 2/7/2008 2.50 625.00 Meeting at city Hall with John Duffy, Randy Seger and Mayor Brainard re: water utility matters Higgins 2/7/2008 1.00 250.00 Prepare for meeting at City Hall with Mayor Brainard, John Duffy and Randy Seger; review information to take with Sue; call with John Duffy re: same Higgins 2/8/2008 1.50 375.00 Follow -up call with John Duffy re: prior day's meeting with the Mayor; review and notes from meeting; meet with Sue and update re: same Haase 2/11/2008 1.25 218.75 Preparation and provision to Utility Superintendent with the analysis on the assumption of a 3percent CPI increase each year since 1993 and comparison of same to the proposed Acquired Area rates. Haase 2/12/2008 1.50 262.50 Concluding the CPI increase analysis and provision of prepared schedule to the Utility Superintendent. Higgins 2/13/2008 0.50 125.00 Conversation with Bryan Collins re: information needed to cover amended Bond ordinance. E -mail message to John Duffy to confirm bond counsel selection. Higgins 2/14/2008 0.25 62.50 Bonds return call to John Duffy re: review of the import of the proposed amended bond ordinance for consideration by the City Council Higgins 2/14/2008 0.50 125.00 Bonds forward a copy of the final official statement for the 2007 BANs to Bryan Collins, along with an explanatory recap for the prior ordinances, project descriptions and related matters, including what is desired in the 2008 amendment to the ordinance. Copy John Duffy re: same Higgins 2/14/2008 0.50 125.00 Follow -up with Bryan Collins on questions pertaining to the timing and structure of the BAN /Bond issuance Haase 2/18/2008 3.00 525.00 Discussion with Util Superintendent and Accountant regarding previous analyses on needed construction, bonding and resulting affects on existing Carmel Area rates. s London Witte Group, LLC February Billing Detail Carmel Water Utility 1002.005 Employee Date Hours Ir'voice Memo Higgins 2/18/2008 0.50 125.00 Follow -up with Sue on additional information and schedules requested by John Duffy Higgins 2/18/2008 1.25 312.50 Bonds review and comment on the form of the revised ordinance as prepared by Bryan Collins; follow -up call with John Duffy on a rate /forecast related matter Haase 2/18/2008 0.75 131.25 Changes made to CPI Analysis schedule as requested by Utility Superintendent and provision of amended schedules. Haase 2/19/2008 3.00 525.00 Finalization of original Acquired Area analysis to isolate needed Carmel area only rate increase with and without the financial effects of the acquired area. Provision of the final schedules to the Utility Superintendent. Higgins 2/20/2008 0.25 62.50 Bonds return call to John Duffy project update and consideration of potential council questions Haase 2/22/2008 1.00 175.00 Receipt, review and research on the question posed regarding fire hydrant revenue and how to book for the year end Dec 31, 2007 financial statements. Discussion with JOH regarding my recommendation and provision of same to Utility Accountant. Higgins 2/28/2008 0.25 62.50 Call with John Duffy to review items (Bond Ordinance) to introduced to the Council on March 3rd; timing of the Council Committee Meeting and related matters; follow -up with Sue on information to be prepared for future presentation to Council. Higgins 2/29/2008 0.50 125.00 Conversation with Sue re: need to contact John Duffy for information to provide to City Council. Follow -up conversation re: review of format etc. over the weekend Haase 2/29/2008 0.75 131.25 Dialogue with JPH and Utility Superintendent regarding the type of official type report needed in case it is needed to answer certain questions posed by Council Members. 32.00 6,651.45 Total due this invoice. LON DO: LWG'M. 1 1'1". G:N.OUF Carmel Water Utility Client No: 1002.005 760 3rd Avenue SW Date: 0313112005' Suite 110 Invoice No: 19355 Carmel, IN 46032 Progress Billing For services rendered as detailed in the attached summary. 4,555.30 Current Amount Due 4555.30 Certified Public Accountants One American Square, Suite 2600 Indianapolis, Indiana 46282 Telephone 1 317 -634 -4747 Facsimile 1 317 -632 -2727 Web I LondonWitteGroup.com London Witte Group, LLC March Billing Detail Carmel Water Utility 1002.005 Employee Date Hours Invoice Memo Higgins 3/5/2008 0.2.5 $62.50 Follow -up with Sue on engagement status Higgins 3/6/2008 0.25 62.50 Return call (message) and subsequent conversation re: availability for attendance at the council's committee meeting Higgins 3/7/2008 0.25 62.50 Phone call with John Duffy re: schedule for Council Committee Meeting and related matters Higgins 3/11/2008 0.75 187.50 Call with John Duffy re: committee meeting preparation; follow -up conversation with Sue re: same Haase 3/12/2008 1.50 262.50 Amending the 10 Year operational analysis and cash available for new debt for the inclusion of additional expense amount due to change and provision of same to Utility Superintendent. Higgins 3/13/2008 0.50 125.00 Call with John Duffy re: additional information for the analysis; set pre- committee meeting with John; follow -up conversation with Sue. Haase 3/13/2008 1.75 306.25 Receipt of comments from JD and incorporation of changes into the operational analysis (both options). Haase 3/14/2008 4.00 700.00 Receipt of JD's comments on the schedules previously provided. Changes made to schedules, after changes cross checked to be certain that all changes flowed through them, provision of new schedules to JD. Discussions with JD regarding the schedules and certain assumptions. Discussions with Util Acctnt regarding schedules. Discussion with JH regarding information on cash available. Higgins 3/14/2008 2.00 500.00 Prepare for City Council Committee Meeting and pre meeting with John Duffy. Review the revised documents and prepare meeting notes and bullet points Higgins 3/14/2008 0.50 125.00 Return to Indianapolis from meeting with City Council Committee Meeting Higgins 3/14/2008 0.00 30.30 Mileage to and from City County Committee meeting Higgins 3/14/2008 1.00 250.00 Meeting with John Duff prior to the City Council Committee Meeting. Higgins 3/14/2008 2.00 500.00 Meeting with City Council Committee Meeting re: utility matters Higgins 3/14/2008 1.00 250.00 Follow -up review of revised schedules prepared by Sue; follow -up conversations re: same London Witte Group, LLC March Billing Detail Carmel Water Utility 1002.005 i Employee Date Hours I nvoice Memo Higgins 3/17/2008 0.25 $62.50 Return call (message) to John Duffy re: follow -up information for City Council; follow -up with Sue re: same Higgins 3/19/2008 0.25 62.50 Follow -up with Sue on information provided for submission to John Duffy. Higgins 3/21/2008 0.25 62.50 Follow -up with Sue on schedules requested by John Duffy Higgins 3/26/2008 1.00 250.00 Review and comment on draft schedules and related assumptions as prepared by Sue; follow -up re: same Haase 3/26/2008 0.50 87.50 Meeting with JPH regarding the assumptions and summaries for the operational analyses and the Calculation of annual cash available. Higgins 3/28/2008 0.50 125.00 Review near final drafts of analysis and summaries as prepared by Sue Haase 3/28/2008 2.75 481.25 Preparation of bullet points depicting the assumptions for the funds available to service debt schedules that the Utility Superintendent wants to provide to Council and Board for the debt issuance, rate increase and opt out discussions. Provision of draft copies to JD and CM and JH for their review and edits. 29.25 $4,555.30 Total due this invoice VOUCHER 083321 WARRANT ALLOWED 00`351455 IN SUM OF LONDON WITTE GROUP 111 Monument Circle, Ste 4700 dndianapolis, IN 46204 i Carmel Water Utility ON ACCOUNT OF APPROPRIATION FOR Board members PO INV ACCT AMOUNT Audit Trail Code 19355 01- 1861 -00 $4,555.30 lq-177 °(•I b1.ao 3 325.73 0 1. 6320.011 -3-325-12 1 g 5 5 9 01.45 bl .00 6$ 50 •oa Ic C 1. 1Y071.2 6 a�55 Do Voucher Total Opst distribution ledger classification if claim paid under vehicle highway fund 1 Prescribed by State Board of Accounts City Form No. 201 (Rev 1995) ACCOUNTS PAYABLE VOUCHER CITY OF CARMEL An invoice or bill to be properly itemized must show, kind of service, where performed, dates of service rendered, by whom, rates per day, number of units, price per unit, etc. Payee 00351455 LONDON WITTE GROUP Purchase Order No. 111 Monument Circle, Ste 4700 Terms Indianapolis, IN 46204 Due Date 10/8/2008 Invoice Invoice Description Date Number (or note attached invoice(s) or bill(s)) Amount 10/8/2008 19355 $4,555.30 hereby certify that the attached invoice(s), or bill(s) is (are) true and ;orrect and I have audited same in accordance with IC 5- 11- 10 -1.6 Date Officer