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