Loading...
HomeMy WebLinkAbout223555 08/27/2013 �,\Mf CITY OF CARMEL, INDIANA VENDOR: 00351455 Page 1 of 1 s 0 ONE CIVIC SQUARE LONDON WITTE GROUP LLC CARMEL, INDIANA 46032 ONE AMERICAN SQUARE CHECK AMOUNT: $1,156.25 1776 N MERIDIAN STREET SUITE 500 CHECK NUMBER: 223555 INDIANAPOLIS IN 46202 CHECK DATE: 8/27/2013 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 902 4340303 26280 1, 156 . 25 OTHER ACCOUNTING FEES I LONDON LWGWITTE GROUP Carmel Redevelopment Commission Client No: 1002.004 30 6V Main Street Date: 0713112013 Suite 220 Invoice No: 26280 Carmel, IN 16032 For services rendered as detailed in the attached summary. Operating $ 9,108.75 Non-Operating 1,156.25 Current Amount Due $___1 0,265.00 __ 10.265.00 I Certified Public Accountants 1776 N. Meridian Street,Suite 500 Indianapolis, Indiana 46202 Telephone 1317-634-4747 Facsimile 1317-632-2727 Web I London WitteGroup.corn London Witte Group, LLC July 2013 Billing Detail Carmel Redevelopment Commission 1 of 6 1002.004 Hourly Employee Date Hours Rate Invoice Memo Higgins 07/08/2013 0.50 325.00 162.50 Review email from Les Olds re: transfer of funds from CRC to cover 2013 Department of Redevelopment Budget; follow-up with Mike Lee re: same. Carney 07/22/2013 0.25 70.00 17.50 Printed monthly finance committee meeting information per JPH. Higgins 07/31/2013 0.50 325.00 162.50 Retrieve message and return call to Dave Bowsers re: 2013 and 2014 Budgets, Sophia Square Garage and Pedcor financings and related matters. 1.25 342.50 Subtotal -Financial Advisory-Finance Committee Higgins 07/02/2013 0.50 325.00 162.50 Call with Lori Danford (SBOA) re: audit question and open matters; follow-up with Mike Lee re: same. Lee 07/03/2013 0.25 75.00 18.75 Responded to auditor's question RE: SWAP agreements. Higgins 07/03/2013 0.25 325.00 81.25 Follow-ups with Mike Lee re: outstanding questions and draft responses from SBOA Examiner. Lee 07/03/2013 1.50 75.00 112.50 Reviewed questions from auditor. Researched expenditures she had questions on and formed initial responses. Higgins 07/07/2013 1.00 325.00 325.00 Review email from SBOA Examiner and proposed response from Mike Lee; revise Mike's comments and respond to Lori with copies to Mike and Bob Reynolds. Lee 07/11/2013 0.25 75.00 18.75 Forwarded email with attorney rep letter to auditor. Higgins 07/11/2013 0.25 325.00 81.25 Follow-up with Mike Lee re: request for additional information/follow-up on CRC attorney letters. Lee 07/18/2013 0.25 75.00 18.75 Responded to emails from Rob Schein RE: rep letter for state auditor. Higgins 07/23/2013 0.50 325.00 162.50 Follow-ups with the SBOA Auditor re: timing/scheduling of a preliminary exit conference. Higgins 07/24/2013 0.50 325.00 162.50 Follow-ups with the SBOA Examiner re: scheduling exit conferences. Higgins 07/25/2013 0.25 325.00 81.25 Follow-ups with Lori Danford, Bill Hammer and Mike Lee re: CRC Exit Conferences. Higgins 07/30/2013 4.00 325.00 1,300.00 Prepare for and attend preliminary exit conference with the State Board of Accounts Examiners at the CRC Offices; follow-up email to the Mayor, Bill Hammer and Karl Haas re: same. Higgins 07/31/2013 0.25 325.00 81.25 Retrieve message and return call to Bill Hammer re: 2012 audit comments and related matters. Higgins 07/31/2013 0.50 325.00 162.50 Follow-up emails and calls with Lori Danford. Mike Lee and Ryan Wilmering re: open audit issues. 10.25 2,768.75 Subtotal -Financial Advisory-Audit London Witte Group, LLC July 2013 Billing Detail Carmel Redevelopment Commission 2 of 6 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 07/03/2013 0.50 75.00 37.50 Updated Summary as of June 30th for packet. Lee 07/08/2013 0.25 75.00 18.75 Revised and updated expenditure/revenue analysis. Lee 07/08/2013 0.50 75.00 37.50 Updated monthly forecast. Lee 07/08/2013 1.50 75.00 112.50 Began updating TIF register as of the end of June with all TIF collections and developer pass-through payments. Lee 07/09/2013 0.25 75.00 18.75 Updated balance sheet based on TIF register updates. Lee 07/09/2013 0.50 75.00 37.50 Updated monthly summary and reconciled it to the monthly forecast. Lee 07/15/2013 2.00 75.00 150.00 Updated monthly packet documents for July meeting. Lee 07/18/2013 1.25 75.00 93.75 Updated forecast and made adjustments based on what has been paid in July and phone discussion with Dave Bowers. Lee 07/18/2013 2.25 75.00 168.75 Created additional sheets for packet. Updated all parts of the financial information packet. Uploaded items to CRC server for electronic delivery. Higgins 07/31/2013 1.00 325.00 325.00 Review revised 2013 and 2014 budget information as prepared by Mike Lee 10.00 1,000.00 Subtotal- Financial Advisory- Financial Dashboard Lee 07/01/2013 0.25 75.00 18.75 Discussed contracts and change orders needed to get vendor paid with CRC staff. Lee 07/01/2013 0.50 75.00 37.50 Prepared Redevelopment Department claims for submission. Lee 07/01/2013 1.75 75.00 131.25 Input invoices into CRC computer data base. Lee 07/01/2013 2.00 75.00 150.00 Worked on reconciling debt portion of report due to DLGF by August 1 st. Lee 07/02/2013 0.75 75.00 56.25 Updated TIF register for June 2013. Lee 07/02/2013 0.25 75.00 18.75 Responded to emails from CRC staff RE: capital assets. Higgins 07/02/2013 0.25 325.00 81.25 Review and follow-up to email from Luci re: Mike Lee and part-time help and related matters Lee 07/03/2013 0.25 75.00 18.75 Communication with CRC staff RE: vendor checks. Lee 07/03/2013 0.25 75.00 18.75 Phone conversation with CRC staff RE: claims that the Clerk-Treasurer had questions on. Lee 07/08/2013 0.25 75.00 18.75 Researched payment status for vendor as per request from meeting. Lee 07/08/2013 0.25 75.00 18.75 Researched budget amount for rent line item to determine how much will be available from October through December. Lee 07/08/2013 0.25 75.00 18.75 Reviewed invoices and budget information with Les Olds. Lee 07/08/2013 1.50 75.00 112.50 Attended meeting with CRC staff and Les Olds RE: contracts, budgets, assets and purchase orders. Lee 07/08/2013 0.25 75.00 18.75 Reviewed and responded to emails RE: payment for vendor and explanation for why it was delayed. Lee 07/08/2013 0.50 75.00 37.50 Researched invoices paid per project for specific vendor as per request from meeting. London Witte Group, LLC July 2013 Billing Detail 3 of 6 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 07/08/2013 1.50 75.00 112.50 Input invoices into CRC computer database. Lee 07/09/2013 2.00 75.00 150.00 Finished updating TIF register as of the end of June 2013. Lee 07/09/2013 0.25 75.00 18.75 Responded to inquiries RE: vendor payments and invoices. Lee 07/09/2013 0.50 75.00 37.50 Researched assessed value amounts for buildings owned by the CRC, CRA and 4CDC. Lee 07/10/2013 0.25 75.00 18.75 Responded to emails from Clerk's office RE: wires for July bond payments. Lee 07/10/2013 0.25 75.00 18.75 Responded to Les Olds'email RE: Meridian and Main TIF advance. ` Lee 07/10/2013 0.25 75.00 18.75 Conversation with Les Olds Re: historical cost basis for capital assets. Reynolds 07/10/2013 0.50 80.00 40.00 Fixed Assets-Went over Historical Cost with Mike Lee so he could update the Fix Assets. Lee 07/10/2013 0.75 75.00 56.25 Prepared claims forms to be submitted to Clerk-Treasurer's office for payment. Lee 07/10/2013 1.50 75.00 112.50 Reviewed invoices for Redevelopment Department and CRC. Confirmed payments had been received for a couple of vendors that submitted statement. Lee 07/10/2013 2.25 75.00 168.75 Worked on reconciling check register to TIF register from December 2012 through June 2013. Lee 07/11/2013 0.25 75.00 1875 Responded to email from CRC staff RE: grants given by the CRC. Lee 07/11/2013 0.25 75.00 18.75 Discussed Meridian & Main TIF advance with Les Olds. Lee 07/11/2013 0.25 75.00 18.75 Looked for specific information in October 2011 forecast as per CRC legal counsel's request. Lee 07/12/2013 0.25 75.00 18.75 Returned phone call to Scott Hagwell RE: COPS, Series 2010C July payment. Reynolds 07/12/2013 0.25 80.00 20.00 Merchant Square and Parkwood- Reviewed Mikes analysis for the payoff of the Parkwood and Merchant Square Bonds. Lee 07/12/2013 1.00 75.00 75.00 Researched Merchants Square bond documents. Updated bond defeasance analysis scenarios. Lee 07/12/2013 2.00 75.00 150.00 Researched Parkwood 2002 and 2006 bond documents. Updated defeasance analysis scenarios for both bonds. Lee 07/15/2013 0.25 75.00 18.75 Responded to email from Vicki Sponcil RE: payment for vendor. Lee 07/15/2013 2.25 75.00 168.75 Worked on reconciling TIF register to summary page in monthly financial information packet. Lee 07/16/2013 0.50 75.00 37.50 Prepared sheet with anticipated revenues and debt service for 2014. Lee 07/16/2013 1.50 75.00 112.50 Second revision to August 1 st report due to DLGF. Lee 07/16/2013 2.75 75.00 206.25 Worked on first revisions of August 1st report due to DLGF. Lee 07/16/2013 0.25 75.00 18.75 Responded to emails from CRC staff RE: 2014 budget. Lee 07/17/2013 5.25 75.00 393.75 Worked on revising entire Redevelopment report due to DLGF August 1st. Created exhibits for every allocation area. Updated information for each area in body of report. London Witte Group, LLC July 2013 Billing Detail 4 of 6 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 07/18/2013 0.25 75.00 18.75 Discussion with Les Olds RE: CRC budget and possible resolution to transfer money to the City of Carmel. Lee 07/18/2013 0.25 75.00 18.75 Phone discussion with Ben Roeger RE: resolution to transfer money from CRC to City of Carmel. Lee 07/18/2013 0.25 75.00 18.75 Researched Redevelopment Department expenditures to date as requested by Les Olds. Lee 07/18/2013 0.75 75.00 56.25 Phone conversation with Dave Bowers RE: 2013 revised budget. Lee 07/18/2013 0.25 75.00 18.75 Created two more exhibits for report due August 1 st to DLGF. Lee 07/18/2013 1.75 75.00 131.25 Input invoices into approval sheets and scanned for CRC computer database. Lee 07/18/2013 2.25 75.00 168.75 Reviewed CRC and Redevelopment Department invoices and contacted vendors with any questions. Lee 07/19/2013 3.50 75.00 262.50 Revisions to Redevelopment Report due August 1 St. Reynolds 07/22/2013 1.25 80.00 100.00 Redevelopment Commission Report- Reviewed Mike Lee's final redevelopment commission report in the summary format. Made any needed changes to the report and updated the parcel listing to be in the correct format. Higgins 07/24/2013 1.25 325.00 406.25 Prepare for and attend the Executive Meeting of the CRC. Higgins 07/24/2013 1.25 325.00 406.25 Prepare for and attend the regular monthly meeting of the CRC. 49.25 4,391.25 Subtotal -Financial Advisory-General Higgins 07/09/2013 0.25 325.00 81.25 Follow-up emails with Mike Lee and Les Olds re: special projects and related matters. Higgins 07/10/2013 0.25 325.00 81.25 Review email from Les re: advance draw for Meridian and Main EDA and questions raised by Rick Sharp; follow-up with Les and Mike Lee re: same. Reynolds 07/10/2013 0.50 80.00 40.00 Advance Refund (Meridian and Main) - Discussed with Mike Lee what we need to do in order to obtain the Advance refund. Reynolds 07/11/2013 0.25 80.00 20.00 RDC Report-Went over redevelopment commission report with Mike Lee. Higgins 07/11/2013 0.25 325.00 81.25 Follow-ups with Mike Lee and Bob Reynolds re: Indiana Spine Group, advance, wire and related matters. Higgins 07/12/2013 0.25 325.00 81.25 Follow-up with Mike Lee and Bob Reynolds on the status of the early redemption/final maturities of the Merchant Square and Parkwood Bonds. Lee 07/17/2013 0.25 75.00 18.75 Reviewed TIF appeals sheet from County Auditor's office and sent copy to Les Olds and CRC staff. Reynolds 07/18/2013 0.50 80.00 40.00 Redevelopment Commission Report- Discussed with Jim the CRC Redevelopment Commission Report. Went over changes that need to be made to the Report with Mike Lee. London Witte Group, LLC July 2013 Billing Detail Carmel Redevelopment Commission 5 of 6 1002.004 Hourly Employee Date Hours Rate Invoice Memo Reynolds 07/18/2013 1.25 80.00 100.00 Redevelopment Commission Reports- Final Review of Mike Lees work on the Redevelopment Commission Report. Made final changes to the report in preparation for Jim's review. Higgins 07/18/2013 0.50 325.00 162.50 Review and comment on the initial draft of the TIF report; follow-up with Bob Reynolds re: suggested changes and related matters. Lee 07/19/2013 0.25 75.00 18.75 Responded to Heidi Amspaugh's email RE: Parkwood and Merchants Square bonds. Reynolds 07/23/2013 0.50 80.00 40.00 Redevelopment Commission Report- Made Jim's changes to the Redevelopment Commission Report. Higgins 07/23/2013 0.25 325.00 81.25 Review and comment on the draft of the August 1 RDC Report; follow-up with Bob Reynolds re: same. Reynolds 07/24/2013 0.75 80.00 60.00 Redevelopment Commission Report- Made changes to the Exhibit A and Exhibit B of the Redevelopment Commission Report, per the request of the mayor. Printed 8 copies for Jim. Higgins 07/24/2013 0.25 325.00 81.25 Follow-ups with Bob Reynolds re: status of the August 1 st Commission Report and related matters. 6.25 987.50 Subtotal - Financial Advisory-TIF Lee 07/01/2013 0.50 75.00 37.50 Made revisions to CRC 2014 forecast based on discussion with Les Olds. Lee 07/01/2013 0.50 75.00 37.50 Discussed 2014 budget and preliminary forecast with Les Olds. Lee 07/08/2013 0.25 75.00 18.75 Created rough draft of 2014 Budget based on 2014 forecast and meeting. Lee 07/08/2013 0.25 75.00 18.75 Revised 2014 forecast based on meeting. Lee 07/09/2013 1.50 75.00 112.50 Worked on updating 2013, 2014 and 2015 budgets/forecasts based on different scenarios RE: grant to the City in 2013. Lee 07/10/2013 0.25 75.00 18.75 Discussed budget scenarios two years out with Les Olds. Lee 07/17/2013 0.50 75.00 37.50 Updated 2014 and 2015 budget drafts and sent to Jim Higgins for review. Lee 07/18/2013 0.50 75.00 37.50 Prepared Redevelopment Department year to date spreadsheet and altered expenditure analysis to show just year to date information for CRC. Sent both sheets for review. Lee 07/19/2013 0.25 75.00 18.75 Discussed resolution with Ben Roeger RE: grant to City. 4.50 337.50 Subtotal -Financial Advisory-Budgets Lee 07/05/2013 2.50 75.00 187.50 Reviewed CRC capital asset lists and CTAR report. Modified spreadsheets for capital asset listing and sent information to CRC staff to fill in some details. Discussed with CRC staff. London Witte Group, LLC July 2013 Billing Detail Carmel Redevelopment Commission 6 of 6 1002.004 Hourly Employee Date Hours Rate Invoice Memo Higgins 07/10/2013 0.25 325.00 81.25 Review emails for Les, Karl and Curt Coonrod re: grants to the City; follow-up with Mike Lee re: same. 2.75 268.75 Subtotal - Financial Advisory-Special Projects Lee 07/05/2013 0.25 75.00 18.75 Emailed Clerk-Treasurer's office request to Hamilton County Auditor's office RE: Meridian and Main advance. Lee 07/08/2013 0.25 75.00 18.75 Computed and created invoice for Club Canine's share of utilities. Lee 07/10/2013 0.50 75.00 37.50 Communicated with Clerk's office to get Meridian and Main TIF advance completed. Lee 07/11/2013 0.25 75.00 18.75 Contacted Carmel Theater, LLC to get bank statements requested by CRC's legal counsel. Lee 07/11/2013 0.75 75.00 56.25 Talked with Meridian and Main bond trustee RE: bond debt service due and what is still owed. Communicated in several emails regarding the same issue with bond trustee and Jim Higgins. Lee 07/12/2013 0.25 75.00 18.75 Forwarded requested bank statements to CRC's legal counsel. 2.25 168.75 Subtotal -Financial Advisory-Other 86.50 10,265.00 Total Invoice Summary: 9,108.75 Operating 1,156.25 Non-Operating 10,265.00 Total 0 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 service rendered, by whom, rates per day, number of hours, rate per hour, number of units, price per unit, etc. II Payee Purchase Order No. Terms Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) 31-13 4AJ 6,< ser .(P f f Total 1 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 Clerk-Treasurer I VOUCHER NO. WARRANT NO. ALLOWED 20 London V111 ��OUa — IN SUM OF $ ON ACCOUNT OF APPROPRIATION FOR 90 2/q 3` 0343 Board Members Po#or INVOICE NO. ACCT#/TITLE AMOUNT DEPT.# I hereby certify that the attached invoice(s), or '2 62, 0 43 1 is6, bill(s) is (are) true and correct and that the materials or services itemized thereon for which charge is made were ordered and received except 9-20- 201 (/A Ld Sianature Cost distribution ledger classification if Title claim paid motor vehicle highway fund