Loading...
HomeMy WebLinkAbout221132 06/18/2013 CITY OF CARMEL, INDIANA VENDOR: 00351455 Page 1 of 1 ONE CIVIC SQUARE LONDON WITTE GROUP LLC CARMEL, INDIANA 46032 ONE AMERICAN SQUARE CHECK AMOUNT: $9,387.50 1776 N MERIDIAN STREET SUITE 500 CHECK NUMBER: 221132 INDIANAPOLIS IN 46202 CHECK DATE: 6/18/2013 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1801 4340303 26122 3 , 615 . 00 OTHER ACCOUNTING FEES 902 4340303 26122 4, 760 . 00 OTHER ACCOUNTING FEES 1701 4340400 26123 1, 012 . 50 CONSULTING FEES LONDON LWGWITTE GROUP City of Carmel Client No: 715.001 Clerk-Treasurer Date: 051312013 One Civic Square Invoice No: 26123 Third Floor Carmel, IN 46032 For services rendered as detailed in the attached summary. $ 1,012.50 Current Amount Due $ 1.012.50 Certified Public Accountants 1776 N.Meridian Street,Suite 500 Indianapolis,Indiana 46202 Telephone 1317-634-4747 Facsimile 1317-632-2727 Web I LondonWitteGroup.com London Witte Group, LLC May 2013 Billing Detail City of Carmel 715.001 Hourly Employee Date Hours Rate Invoice Memo Lee 5/2/2013 2.00 75.00 150.00 Gathered requested PAC dome repair settlement claims breakdown. Researched when claims were approved, check numbers and accuracy of dollar amounts. Sent email out for review. Higgins 5/2/2013 0.50 325.00 162.50 Review near final draft of the PAC Construction claim summary as prepared by Mike Lee (requested by: Sandy Johnson); follow-up with Mike re: same. Lee 5/9/2013 0.25 75.00 18.75 Sent requested dome repair settlement claims spreadsheet to Clerk-Treasurer's office. Lee 5/15/2013 0.25 75.00 18.75 Responded to email from Luci Snyder RE: CRC reserve funds. Higgins 5/15/2013 0.25 325.00 81.25 Email responses to Luci Snyder and Cindy Sheeks re: CRC reserve and cash flow questions; follow-up with Mike Lee re: same. Higgins 5/20/2013 0.25 325.00 81.25 Follow-up email to Diana re: Replacement Secondary Installment Purchase Contract. Lee 5/23/2013 0.25 75.00 18.75 Researched what REI owes the CRC for energy payments. consumption a ments. P Higgins 5/23/2013 0.50 325.00 162.50 Review email from Luci Snyder concerning amounts needed/due to and available from the CRC; follow-up with Mike and Luci re: same. Lee 5/24/2013 0.75 75.00 56.25 Scanned invoices for CDs. Put financial information packets and claims CDs together for City Councilors and Clerk-Treasurer. Lee 5/24/2013 0.25 75.00 18.75 Delivered financial information packets to Clerk- Treasurer's office. Higgins 5/29/2013 0.75 325.00 243.75 Follow-up to email from Loren (Umbaugh) re: additional information re: energy center, tenant rents and related matters; follow-up with Mike Lee re: same. 6.00 1,012.50 Total Due This Invoice. Prescribed by State Board of Accounts ACCOUNTS PAYABLE VOUCHER City Form No.201(Rev.1995) 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. I �� lPlayee Purchase Order No. Terms Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) / l Total 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. 20 Clerk-Treasurer VOUCHER NO. WARRANT NO. ALLOWED 20 " '�� r IN M OF SU $ 117 n l6o�16 ON ACCOUNT OF APPROPRIATION FOR 074f— Board Members PO#or D PT.# INVOICE NO. ACCT#!TITLE AMOUNT I hereby certify that the attached invoice(s), or 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 20 Signature Title Cost distribution ledger classification if claim paid motor vehicle highway fund LONDON LWGWITTE GROUP Carmel Redevelopment Commission Client No: 1002.004 30 W. Main Street Date: 0513112013 Suite 220 Invoice No: 26122 Carmel, IN 46032 I For services rendered as detailed in the attached summary. Operating $ 3,615.0 Non-Operating 4,760.00 Current Amount Due $ 8.375.00 Certified Public Accountants 1776 N.Meridian Street, Suite 500 Indianapolis,Indiana 46202 Telephone 1317-634-4747 Facsimile 1317-632-2727 Web I LondonWitteGroup.com London Witte Group, LLC May 2013 Billing Detail 1 of 5 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Higgins 05/03/2013 0.25 325.00 81.25 Follow-up with Mike Lee re: availability for a Finance Committee Meeting. Carney 05/20/2013 0.25 70.00 17.50 Printed the May CRC Meeting Packet from e-mail Jim sent to me. 0.50 98.75 Subtotal -Financial Advisory-Finance Committee Higgins 05/13/2013 0.25 325.00 81.25 Follow-up with Lori Danford (SBOA) re: request to review additional CRC claims for 2012; follow-up with Mike Lee to review location of the 2012 claims(CRC vs. Clerk-Treasurer's Office). Lee 05/14/2013 1.50 75.00 112.50 Met with auditor to go over her questions. Made list of what she is requesting. Higgins 05/16/2013 1.00 325.00 325.00 Emails with Matt, Mike, Les, Ben and Ryan re: audit request and follow-ups from the State Board of Accounts. Lee 05/20/2013 1.00 75.00 75.00 Researched for several items requested by state auditor. Reviewed material CRC staff already sent to auditor. Lee 05/21/2013 0.50 75.00 37.50 Searched for items requested by auditor. Lee 05/22/2013 0.50 75.00 37.50 Researched items requested by state auditor. Made notes to discuss. Lee 05/23/2013 0.25 75.00 18.75 Met with Jim Higgins to discuss items requested for CRC audit. Higgins 05/23/2013 0.25 325.00 81.25 Follow-ups with Mike, Matt and Lori re: audit status and related matters. Higgins 05/23/2013 0.50 325.00 162.50 Follow-up with Mike Lee re: open and outstanding audit issues and related matters; follow-up email to Lori Danford at the SBOA re: same. Lee 05/23/2013 1.50 75.00 112.50 Researched for items requested by auditor. Confirmed certain answers with Ryan Wilmering. Lee 05/24/2013 0.50 75.00 37.50 Gathered information for state auditor. Lee 05/28/2013 0.25 75.00 18.75 Compiled audit information requested by SBOA and sent on for review. Emailed CRC attorney rep letters as per SBOA request. Lee 05/28/2013 1.00 75.00 75.00 Researched files for 2012 bond official statement, energy consumption payment contracts and Feinstein build-out promissory note. Higgins 05/29/2013 0.50 325.00 162.50 Follow-up with Mike and Bob re: additional information needed for Lori's request. Lee 05/29/2013 0.75 75.00 56.25 Discussed items for CRC audit with Jim Higgins and Bob Reynolds. Higgins 05/29/2013 1.00 325.00 325.00 Review requested items for audit as prepared by Mike Lee; follow-up meeting with Mike and Bob Reynolds re: same. Reynolds 05/29/2013 1.00 80.00 80.00 Meeting- Met with Jim and Mike to discuss audit related topics. Reynolds 05/29/2013 1.00 80.00 80.00 Meeting with Jim and Mike to discuss all CRC Audit questions outstanding with the SBOA. Higgins 05/30/2013 2.00 325.00 650.00 Review emails from and between Lori (SBOA) and Mike Lee; follow-up directly as needed and with Bob Reynolds re: open items and outstanding matters. Lee 05/30/2013 3.50 75.00 262.50 Researched for items auditor asked for and questioned. Sent emails with responses to auditor. London Witte Group, LLC May 2013 Billing Detail 2 of 5 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 05/31/2013 0.50 75.00 37.50 Discussed CRC audit questions with Bob Reynolds, Lee 05/31/2013 2.00 75.00 150.00 Reviewed emails from auditor and searched for more information as per her request. Lee 05/31/2013 2.00 75.00 150.00 Reconciled TIF register. Created TIF register report for auditor. Reynolds 05/31/2013 1.00 80.00 80.00 Met with Mike to discuss CRC Audit items. 24.25 3,208.75 Subtotal -Financial Advisory-Audit Lee 05/03/2013 1.00 75.00 75.00 Reviewed Clerk-Treasurer audit trail reports to make sure they matched what was given to them. Input April expenditures and revenues into monthly forecast. Updated several line items of forecast. Lee 05/03/2013 1.00 75.00 75.00 Updated expenditure/revenue analysis for May meeting. Researched for differences. Adjusted a few line items to match with forecast. Lee 05/09/2013 1.75 75.00 131.25 Researched difference between summary and forecast. Corrected expenditures in January forecast. Updated summary for May meeting packet. Lee 05/10/2013 0.25 75.00 18.75 Created copies of invoices for monthly information packet. Lee 05/13/2013 1.00 75.00 75.00 Updated forecast for May packet and meeting. Lee 05/14/2013 0.50 75.00 37.50 Reviewed and updated several pages of financial information packet for May meeting. Lee 05/14/2013 2.75 75.00 206.25 Updated each sheet of monthly Financial Information Packet for May. Revised developer bonds. Reviewed CRC monthly packet. Scanned all large invoices per the commission's request. Filed copies of invoices for CRC files. 8.25 618.75 Subtotal -Financial Advisory-Financial Dashboard Lee 05101/2013 0.25 75.00 18.75 Responded to emails from Clerk-Treasurer's office and Matt Worthely RE: Duke energy claims unpaid that are no longer to be paid by the Commission. Lee 05/02/2013 0.50 75.00 37.50 Reviewed CRC and Redevelopment Department invoices to be submitted. Lee 05/02/2013 1.50 75.00 112.50 Prepared Redevelopment Department claims for submission to Clerk-Treasurer. Input previous invoices already paid into CRC computer database. Lee 05/06/2013 0.50 75.00 37.50 Made two deliveries of CRC claims to the Clerk-Treasurer's office for payment. Lee 05/06/2013 1.50 75.00 112.50 Reviewed CRC and Redevelopment Department invoices and input scans into CRC computer database. Lee 05/06/2013 1.50 75.00 112.50 Prepared new claims for the Redevelopment Department and discussed timing of several claims with vendor and CRC employees. Lee 05/10/2013 0.25 75.00 18.75 Discussed billing procedures and other outstanding CRC issues with CRC staff. Lee 05/10/2013 0.25 75.00 18.75 Reviewed CRC emails for possible issues. London Witte Group, LLC May 2013 Billing Detail 3 of 5 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 05/10/2013 2.75 75.00 206.25 Scanned all invoices. Input new CRC and Redevelopment Department invoices into CRC computer database. Lee 05/10/2013 3.00 75.00 225.00 Reviewed new CRC and Redevelopment Department invoices. Created claims forms to submit to Clerk-Treasurer. Lee 05/13/2013 0.50 75.00 37.50 Discussed the Redevelopment Department budget for this year and next year with Les Olds. Reviewed emails and discussed with Les Olds. Lee 05/13/2013 2.75 75.00 206.25 Created approval sheets and input all invoices for the CRC and Redevelopment Department. Created source of funds sheets. Lee 05/13/2013 3.25 75.00 243.75 Reviewed invoices, filled out claim sheets and input invoices into CRC computer database for both the Carmel Redevelopment Commission and the Redevelopment Department. Lee 05/20/2013 0.25 75.00 18.75 Reviewed CRC emails for issues. Forwarded pertinent information on to City employees. Lee 05/20/2013 0.50 75.00 37.50 Reviewed emails from state auditor, Clerk-Treasurer and Les Olds. Lee 05/20/2013 1.50 75.00 112.50 Prepared claims to be submitted to Clerk-Treasurer. Delivered claims to Clerk-Treasurer office. Lee 05/21/2013 0.25 75.00 18.75 Responded to budget inquiry from CRC staff. Lee 05/22/2013 0.25 75.00 18.75 Conversation with Les Olds RE: Sophia Square and vendor contract. Lee 05/22/2013 0.25 75.00 18.75 Emailed CRC vendor RE: status of contract. Lee 05/22/2013 0.50 75.00 37.50 Reviewed email from councilor Snyder and made notes to discuss. Sent email to Ben Roeger RE: anticipated office tenant rents. Lee 05/23/2013 2.25 75.00 168.75 Attended CRC monthly may meetings. Lee 05/23/2013 0.50 75.00 37.50 Printed off documents and prepared for monthly CRC meeting. Higgins 05/23/2013 1.50 325.00 487.50 Prepare for and attend monthly meeting of the CRC. Lee 05/23/2013 0.50 75.00 37.50 Met with Matt Worthley and Les Olds to go over items needed for CRC audit, information requested by Pedcor's auditor, contracts and purchase orders. Higgins 05/23/2013 1.25 325.00 406.25 Attend CRC Executive Session. Lee 05/28/2013 1.00 75.00 75.00 Analysis of net rents owed to CRC in 2013 versus what is anticipated. Lee 05/29/2013 0.25 75.00 18.75 Sent email to Vicki Sponcil with proof of payment for Angela Painting. Lee 05/29/2013 0.25 75.00 18.75 Sent email to Heidi Amspaugh RE: Merchants Square bonds and Parkwood bonds. Lee 05/29/2013 0.25 75.00 18.75 Sent email to Kera RE: invoice for Club Canine. Lee 05/29/2013 0.50 75.00 37.50 Responded to emails from CRC staff RE: contracts and vendor payment inquiries. Lee 05/29/2013 0.50 75.00 37.50 Responded to email from Ben Roeger RE: Energy Center payments. Lee 05/29/2013 0.50 75.00 37.50 Responded to emails from Ryan Wilmering RE: NBI certification Junior Parity Ratio. Lee 05/29/2013 0.50 75.00 37.50 Reviewed email response from Loren Matthes and made notes. Lee 05/29/2013 0.50 75.00 37.50 Reviewed reconciliation attachment from REI. Responded to Ben Roeger's email about check. London Witte Group, LLC May 2013 Billing Detail 4 of 5 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 05/30/2013 0.25 75.00 18.75 Discussion with Ben Roeger RE: Loren Matthes email, ticket surcharge payments and rents. Lee 05/30/2013 0.50 75.00 37.50 Discussed contracts and audit information with CRC employees. Lee 05/30/2013 2.00 75.00 150.00 Reviewed Redevelopment Department invoices. Filled out voucher forms to be submitted to Clerk-Treasurer. Made copies for CRC records. Lee 05/31/2013 1.00 75.00 75.00 Crafted email in response to Loren Matthes email RE: energy payments and tenant rent payments. Lee 05/31/2013 1.00 75.00 75.00 Reviewed expenditure audit trails and updated TIF register as of 5/31/13. 37.00 3,462.50 Subtotal -Financial Advisory-General Higgins 05/06/2013 0.25 325.00 81.25 Follow-up with John Alexander re: Sophia Square payment to Keystone and related matters. Reynolds 05/30/2013 0.50 80.00 40.00 TIF Register - Read through TIF Register for Mike to make sure all items footed and agreed. 0.75 121.25 Subtotal -Financial Advisory-TIF Lee 05/29/2013 0.50 75.00 37.50 Reviewed Redevelopment Department budget and made notes for Thursday. Lee 05/29/2013 2.00 75.00 150.00 Made changes to CRC forecast. Then made changes to revised budget to discuss with Dave Bowers. Lee 05/30/2013 0.50 75.00 37.50 Discussed Redevelopment Department 2014 budget with CRC staff. Reviewed recommendations for 2014 budget. Lee 05/30/2013 0.50 75.00 37.50 Phone discussion with auditor RE: questions to responses given. Lee 05/31/2013 0.25 75.00 18.75 Discussion with Les Olds and Mayor Brainard RE: cash available at the end of the year. Lee 05/31/2013 0.75 75.00 56.25 Phone discussion with Dave Bowers RE: CRC revised budget. 4.50 337.50 Subtotal -Financial Advisory-Budgets Lee 05/01/2013 1.00 75.00 75.00 Researched bank accounts and created spreadsheet showing the analysis of the redemption/defeasance of the 2002 Parkwood East Bonds. Lee 05/07/2013 0.25 75.00 18.75 Revised dome repair spreadsheet and sent email out for review. Lee 05/07/2013 0.25 75.00 18.75 Prepared a budget to actual sheet for the Carmel Redevelopment Department as of 4/30/13. Sent information on to Les Olds for review. Reynolds 05/29/2013 0.50 80.00 40.00 Met with Mike to go over the Restricted Cash and Unrestricted Cash schedule for the CRC. 2.00 152.50 Subtotal -Financial Advisory -Special Projects Lee 05/01/2013 0.25 75.00 18.75 Discussed PAC dome claims with Les Olds and Ryan Wilmering. Lee 05/02/2013 0.50 75.00 37.50 Conversation with Walter P Moore representatives RE: Walter P Moore contracts. London Witte Group, LLC May 2013 Billing Detail 5 of 5 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 05/02/2013 0.50 75.00 37.50 Reviewed contracts still needed to pay CRC invoices. Talked with Matt Worthley about progress in obtaining these contracts. Lee 05/03/2013 0.25 75.00 18.75 Check with Clerk-Treasurer's office RE: check for CRC vendor that had not been released and reasoning for not releasing it. Lee 05/03/2013 0.25 75.00 18.75 Researched to find what requisition several claims in 2010 were paid out of. Lee 05/06/2013 0.25 75.00 18.75 Researched CRC check files to see if three settlement claims were paid with CRC checks for report. Lee 05/06/2013 0.25 75.00 18.75 Discussed Walter P Moore's contract with R. Schein. Lee 05/06/2013 0.75 75.00 56.25 Verified all information was correct for TIF notification. Updated information for 2013 resolution. Lee 05/07/2013 0.25 75.00 18.75 Responded to emails from the Clerk-Treasurer's office RE: property tax bill that should be paid by the CRC. Emailed Matt Worthley RE: same information. Lee 05/07/2013 0.50 75.00 37.50 More correspondence with CRC staff, Village Financial representative and Clerk-Treasurer's office RE: tax bill that is in the wrong name but is owed by the CRC. Lee 05/08/2013 0.25 75.00 18.75 Had conversation with representative from Krieg DeVault RE: billing status and credits. Lee 05/09/2013 0.25 75.00 18.75 Sent monthly reminder to Clerk-Treasurer's office to pay the energy consumption costs to the CRC. Lee 05/09/2013 0.25 75.00 18.75 Reviewed memorandum from Clerk-Treasurer detailing a request for a comprehensive capital asset report. Sent email to Matt Worthely RE: same issue. Lee 05/13/2013 0.50 75.00 37.50 Attended CRC staff meeting by request. 5.00 375.00 Subtotal -Financial Advisory-Other 82.25 8,375.00 Total Invoice Summary: 3,615.00 Operating 4,760.00 Non-Operating 8,375.00 Total 0 Prescribed by State Board of Accounts ACCOUNTS PAYABLE VOUCHER City Form No.207(Rev.1995) 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. Payee L06Joh Vjf� 6rQUb Purchase Order No. Terms Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) 5-3W 2, 612-2, ;F n SerL' �s 3V 6/5.00 i Total 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. 20 Clerk-Treasurer VOUCHER NO. WARRANT NO. Lon �,/ ALLOWED 20 Loll hn ,Y 1#_6-oNp IN SUM OF $ ON ACCOUNT OF APPROPRIATION FOR IM/q3 V02 Board Members PO#or INVOICE NO. ACCT#/TITLE AMOUNT DEPT.# r I hereby certify that the attached invoice(s), or [Al 2 6 X22 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 6 -20U r Cost distribution ledger classification if -���Tit l le e claim paid motor vehicle highway fund LONDON LWGWITTE GROUP Carmel Redevelopment Commission Client No: 1002.004 30 W. Main Street Date: 051312013 Suite 220 Invoice No: 26122 Carmel, IN 46032 For services rendered as detailed in the attached summary. Operating $ 3,615.00 Non-Operating 4 760.00 Current Amount Due $ 8.375.00 Certified Public Accountants 1776 N. Meridian Street,Suite 500 Indianapolis,Indiana 46202 Telephone 1317-634-4747 Facsimile 1317-632-2727 Web I LondonWitteGroup.com London Witte Group, LLC May 2013 Billing Detail 1 of 5 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Higgins 05/03/2013 0.25 325.00 81.25 Follow-up with Mike Lee re: availability for a Finance Committee Meeting. Carney 05/20/2013 0.25 70.00 17.50 Printed the May CRC Meeting Packet from e-mail Jim sent to me. 0.50 98.75 Subtotal -Financial Advisory-Finance Committee Higgins 05/13/2013 0.25 325.00 81.25 Follow-up with Lori Danford(SBOA) re: request to review additional CRC claims for 2012; follow-up with Mike Lee to review location of the 2012 claims (CRC vs. Clerk-Treasurer's Office). Lee 05/14/2013 1.50 75.00 112.50 Met with auditor to go over her questions. Made list of what she is requesting. Higgins 05/16/2013 1.00 325.00 325.00 Emails with Matt, Mike, Les, Ben and Ryan re: audit request and follow-ups from the State Board of Accounts. Lee 05/20/2013 1.00 75.00 75.00 Researched for several items requested by state auditor. Reviewed material CRC staff already sent to auditor. Lee 05/21/2013 0.50 75.00 37.50 Searched for items requested by auditor. Lee 05/22/2013 0.50 75.00 37.50 Researched items requested by state auditor. Made notes to discuss. Lee 05/23/2013 0.25 75.00 18.75 Met with Jim Higgins to discuss items requested for CRC audit. Higgins 05/23/2013 0.25 325.00 81.25 Follow-ups with Mike, Matt and Lori re: audit status and related matters. Higgins 05/23/2013 0.50 325.00 162.50 Follow-up with Mike Lee re: open and outstanding audit issues and related matters; follow-up email to Lori Danford at the SBOA re: same. Lee 05/23/2013 1.50 75.00 112.50 Researched for items requested by auditor. Confirmed certain answers with Ryan Wilmering. Lee 05/24/2013 0.50 75.00 37.50 Gathered information for state auditor. Lee 05/28/2013 0.25 75.00 18.75 Compiled audit information requested by SBOA and sent on for review. Emailed CRC attorney rep letters as per SBOA request. Lee 05/28/2013 1.00 75.00 75.00 Researched files for 2012 bond official statement, energy consumption payment contracts and Feinstein build-out promissory note. Higgins 05/29/2013 0.50 325.00 162.50 Follow-up with Mike and Bob re: additional information needed for Lori's request. Lee 05/29/2013 0.75 75.00 56.25 Discussed items for CRC audit with Jim Higgins and Bob Reynolds. Higgins 05/29/2013 1.00 325.00 325.00 Review requested items for audit as prepared by Mike Lee; follow-up meeting with Mike and Bob Reynolds re: same. Reynolds 05/29/2013 1.00 80.00 80.00 Meeting- Met with Jim and Mike to discuss audit related topics. Reynolds 05/29/2013 1.00 80.00 80.00 Meeting with Jim and Mike to discuss all CRC Audit questions outstanding with the SBOA. Higgins 05/30/2013 2.00 325.00 650.00 Review emails from and between Lori (SBOA) and Mike Lee; follow-up directly as needed and with Bob Reynolds re: open items and outstanding matters. Lee 05/30/2013 3.50 75.00 262.50 Researched for items auditor asked for and questioned. Sent emails with responses to auditor. London Witte Group, LLC May 2013 Billing Detail Carmel Redevelopment Commission 2 of 5 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 05/31/2013 0.50 75.00 37.50 Discussed CRC audit questions with Bob Reynolds. Lee 05/31/2013 2.00 75.00 150.00 Reviewed emails from auditor and searched for more information as per her request. Lee 05/31/2013 2.00 75.00 150.00 Reconciled TIF register. Created TIF register report for auditor. Reynolds 05/31/2013 1.00 80.00 80.00 Met with Mike to discuss CRC Audit items. 24.25 3,208.75 Subtotal -Financial Advisory-Audit Lee 05/03/2013 1.00 75.00 75.00 Reviewed Clerk-Treasurer audit trail reports to make sure they matched what was given to them. Input April expenditures and revenues into monthly forecast. Updated several line items of forecast. Lee 05/03/2013 1.00 75.00 75.00 Updated expenditure/revenue analysis for May meeting. Researched for differences. Adjusted a few line items to match with forecast. Lee 05/09/2013 1.75 75.00 131.25 Researched difference between summary and forecast. Corrected expenditures in January forecast. Updated summary for May meeting packet. Lee 05/10/2013 0.25 75.00 18.75 Created copies of invoices for monthly information packet. Lee 05/13/2013 1.00 75.00 75.00 Updated forecast for May packet and meeting. Lee 05/14/2013 0.50 75.00 37.50 Reviewed and updated several pages of financial information packet for May meeting. Lee 05/14/2013 2.75 75.00 206.25 Updated each sheet of monthly Financial Information Packet for May. Revised developer bonds. Reviewed CRC monthly packet. Scanned all large invoices per the commission's request. Filed copies of invoices for CRC files. 8.25 618.75 Subtotal -Financial Advisory-Financial Dashboard Lee 05/01/2013 0.25 75.00 18.75 Responded to emails from Clerk-Treasurer's office and Matt Worthely RE: Duke energy claims unpaid that are no longer to be paid by the Commission. Lee 05/02/2013 0.50 75.00 37.50 Reviewed CRC and Redevelopment Department invoices to be submitted. Lee 05/02/2013 1.50 75.00 112.50 Prepared Redevelopment Department claims for submission to Clerk-Treasurer. Input previous invoices already paid into CRC computer database. Lee 05/06/2013 0.50 75.00 37.50 Made two deliveries of CRC claims to the Clerk-Treasurer's office for payment. Lee 05/06/2013 1.50 75.00 112.50 Reviewed CRC and Redevelopment Department invoices and input scans into CRC computer database. Lee 05/06/2013 1.50 75.00 112.50 Prepared new claims for the Redevelopment Department and discussed timing of several claims with vendor and CRC employees. Lee 05/10/2013 0.25 75.00 18.75 Discussed billing procedures and other outstanding CRC issues with CRC staff. Lee 05/10/2013 0.25 75.00 18.75 Reviewed CRC emails for possible issues. London Witte Group, LLC May 2013 Billing Detail 3 of 5 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 05/10/2013 2.75 75.00 206.25 Scanned all invoices. Input new CRC and Redevelopment Department invoices into CRC computer database. Lee 05/10/2013 3.00 75.00 225.00 Reviewed new CRC and Redevelopment Department invoices. Created claims forms to submit to Clerk-Treasurer. Lee 05/13/2013 0.50 75.00 37.50 Discussed the Redevelopment Department budget for this year and next year with Les Olds. Reviewed emails and discussed with Les Olds. Lee 05/13/2013 2.75 75.00 206.25 Created approval sheets and input all invoices for the CRC and Redevelopment Department. Created source of funds sheets. Lee 05/13/2013 3.25 75.00 243.75 Reviewed invoices, filled out claim sheets and input invoices into CRC computer database for both the Carmel Redevelopment Commission and the Redevelopment Department. Lee 05/20/2013 0.25 75.00 18.75 Reviewed CRC emails for issues. Forwarded pertinent information on to City employees. Lee 05/20/2013 0.50 75.00 37.50 Reviewed emails from state auditor, Clerk-Treasurer and Les Olds. Lee 05/20/2013 1.50 75.00 112.50 Prepared claims to be submitted to Clerk-Treasurer. Delivered claims to Clerk-Treasurer office. Lee 05/21/2013 0.25 75.00 18.75 Responded to budget inquiry from CRC staff. Lee 05/22/2013 0.25 75.00 18.75 Conversation with Les Olds RE: Sophia Square and vendor contract. Lee 05/22/2013 0.25 75.00 18.75 Emailed CRC vendor RE: status of contract. Lee 05/22/2013 0.50 75.00 37.50 Reviewed email from councilor Snyder and made notes to discuss. Sent email to Ben Roeger RE: anticipated office tenant rents. Lee 05/23/2013 2.25 75.00 168.75 Attended CRC monthly may meetings. Lee 05/23/2013 0.50 75.00 37.50 Printed off documents and prepared for monthly CRC meeting. Higgins 05/23/2013 1.50 325.00 487.50 Prepare for and attend monthly meeting of the CRC. Lee 05/23/2013 0.50 75.00 37.50 Met with Matt Worthley and Les Olds to go over items needed for CRC audit, information requested by Pedcor's auditor, contracts and purchase orders. Higgins 05/23/2013 1.25 325.00 406.25 Attend CRC Executive Session. Lee 05/28/2013 1.00 75.00 75.00 Analysis of net rents owed to CRC in 2013 versus what is anticipated. Lee 05/29/2013 0.25 75.00 18.75 Sent email to Vicki Sponcil with proof of payment for Angela Painting. Lee 05/29/2013 0.25 75.00 18.75 Sent email to Heidi Amspaugh RE: Merchants Square bonds and Parkwood bonds. Lee 05/29/2013 0.25 75.00 18.75 Sent email to Kera RE: invoice for Club Canine. Lee 05/29/2013 0.50 75.00 37.50 Responded to emails from CRC staff RE: contracts and vendor payment inquiries. Lee 05/29/2013 0.50 75.00 37.50 Responded to email from Ben Roeger RE: Energy Center payments. Lee 05/29/2013 0.50 75.00 37.50 Responded to emails from Ryan Wilmering RE: NBI certification Junior Parity Ratio. Lee 05/29/2013 0.50 75.00 37.50 Reviewed email response from Loren Matthes and made notes. Lee 05/29/2013 0.50 75.00 37.50 Reviewed reconciliation attachment from REI. Responded to Ben Roeger's email about check. London Witte Group, LLC May 2013 Billing Detail 4 of 5 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 05/30/2013 0.25 75.00 18.75 Discussion with Ben Roeger RE: Loren Matthes email, ticket surcharge payments and rents. Lee 05/30/2013 0.50 75.00 37.50 Discussed contracts and audit information with CRC employees. Lee 05/30/2013 2.00 75.00 150.00 Reviewed Redevelopment Department invoices. Filled out voucher forms to be submitted to Clerk-Treasurer. Made copies for CRC records. Lee 05/31/2013 1.00 75.00 75.00 Crafted email in response to Loren Matthes email RE: energy payments and tenant rent payments. Lee 05/31/2013 1.00 75.00 75.00 Reviewed expenditure audit trails and updated TIF register as of 5/31/13. 37.00 3,462.50 Subtotal -Financial Advisory-General Higgins 05/06/2013 0.25 325.00 81.25 Follow-up with John Alexander re: Sophia Square payment to Keystone and related matters. Reynolds 05/30/2013 0.50 80.00 40.00 TIF Register - Read through TIF Register for Mike to make sure all items footed and agreed. 0.75 121.25 Subtotal -Financial Advisory-TIF Lee 05/2912013 0.50 75.00 37.50 Reviewed Redevelopment Department budget and made notes for Thursday. Lee 05/29/2013 2.00 75.00 150.00 Made changes to CRC forecast. Then made changes to revised budget to discuss with Dave Bowers. Lee 05/30/2013 0.50 75.00 37.50 Discussed Redevelopment Department 2014 budget with CRC staff. Reviewed recommendations for 2014 budget. Lee 05/30/2013 0.50 75.00 37.50 Phone discussion with auditor RE: questions to responses given. Lee 05131/2013 0.25 75.00 18.75 Discussion with Les Olds and Mayor Brainard RE: cash available at the end of the year. Lee 05/31/2013 0.75 75.00 56.25 Phone discussion with Dave Bowers RE: CRC revised budget. 4.50 337.50 Subtotal -Financial Advisory-Budgets Lee 05/01/2013 1.00 75.00 75.00 Researched bank accounts and created spreadsheet showing the analysis of the redemption/defeasance of the 2002 Parkwood East Bonds. Lee 05/07/2013 0.25 75.00 18.75 Revised dome repair spreadsheet and sent email out for review. Lee 05/07/2013 0.25 75.00 18.75 Prepared a budget to actual sheet for the Carmel Redevelopment Department as of 4/30/13. Sent information on to Les Olds for review. Reynolds 05/29/2013 0.50 80.00 40.00 Met with Mike to go over the Restricted Cash and Unrestricted Cash schedule for the CRC. 2.00 152.50 Subtotal-Financial Advisory-Special Projects Lee 05/01/2013 0.25 75.00 18.75 Discussed PAC dome claims with Les Olds and Ryan Wilmering. Lee 05/02/2013 0.50 75.00 37.50 Conversation with Walter P Moore representatives RE: Walter P Moore contracts. London Witte Group, LLC May 2013 Billing Detail 5 of 5 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Lee 05/02/2013 0.50 75.00 37.50 Reviewed contracts still needed to pay CRC invoices. Talked with Matt Worthley about progress in obtaining these contracts. Lee 05/03/2013 0.25 75.00 18.75 Check with Clerk-Treasurer's office RE: check for CRC vendor that had not been released and reasoning for not releasing it. Lee 05/03/2013 0.25 75.00 18.75 Researched to find what requisition several claims in 2010 were paid out of. Lee 05/06/2013 0.25 75.00 18.75 Researched CRC check files to see if three settlement claims were paid with CRC checks for report. Lee 05/06/2013 0.25 75.00 18.75 Discussed Walter P Moore's contract with R. Schein. Lee 05/06/2013 0.75 75.00 56.25 Verified all information was correct for TIF notification. Updated information for 2013 resolution. Lee 05/07/2013 0.25 75.00 18.75 Responded to emails from the Clerk-Treasurer's office RE: property tax bill that should be paid by the CRC. Emailed Matt Worthley RE: same information. Lee 05/07/2013 0.50 75.00 37.50 More correspondence with CRC staff, Village Financial representative and Clerk-Treasurer's office RE: tax bill that is in the wrong name but is owed by the CRC. Lee 05/08/2013 0.25 75.00 18.75 Had conversation with representative from Krieg DeVault RE: billing status and credits. Lee 05/09/2013 0.25 75.00 18.75 Sent monthly reminder to Clerk-Treasurer's office to pay the energy consumption costs to the CRC. Lee 05/09/2013 0.25 75.00 18.75 Reviewed memorandum from Clerk-Treasurer detailing a request for a comprehensive capital asset report. Sent email to Matt Worthely RE: same issue. Lee 05/13/2013 0.50 75.00 37.50 Attended CRC staff meeting by request. 5.00 375.00 Subtotal -Financial Advisory-Other 82.25 8,375.00 Total Invoice Summary: 3,615.00 Operating 4,760.00 Non-Operating 8,375.00 Total 0 I I Prescribed by State Board of Accounts ACCOUNTS PAYABLE VOUCHER City Form No.201(Rev.1995) 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. I,! ffPayee 4 VY I/ �touk Purchase Order No. Terms Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) Total If 76O,�0 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. , 20 Clerk-Treasurer I VOUCHER NO. WARRANT NO. ��,,// ALLOWED 20 L-0/1 ion �Y j( c 61,0 at IN SUM OF $ $ 4, 16 0.oo ON ACCOUNT OF APPROPRIATION FOR qOz /�3 0303 Board Members PO#or INVOICE NO. ACCT#/TITLE AMOUNT ADEPT.# I hereby certify that the attached invoice(s), or Id2 2-6/Z2, _"4363 �Ada,' 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 20/3 Signature Title Cost distribution ledger classification if 4xf«,7« d 1110t--7012- claim paid motor vehicle highway fund