HomeMy WebLinkAbout225446 10/23/2013 ±y, CITY OF CARMEL, INDIANA VENDOR: 363109 Page 1 of 1
ONE CIVIC SQUARE MICHAEL LEE CHECK AMOUNT: $3,710.00
CARMEL, INDIANA 46032 cio CRC
CHECK NUMBER: 225446
CHECK DATE: 10123/2013
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION
902 4340303 31332 201307 650 . 00 FINANCE CONSULT
902 4340303 31332 201308 1, 860 . 00 FINANCE CONSULT
902 4340303 31332 201309 1, 200 . 00 FINANCE CONSULT
Michael Lee
506 W Smokey Row Rd.
Date: 8/1/13 Carmel, IN 46032 Invoice 201307
Date Description of Work Hours
7/22/2013 Communicated budget information with Cindy Sheeks and 0.50
Les Olds. Researched CRC budget.
Reviewed and prepared claims for Redevelopment 0.75
Department invoices.
Reviewed and prepared claims for Redevelopment 1.25
Commission invoices.
7/24/2013 Updated Redevelopment Department year to date 0.25
expenditures.
0.25
Reviewed Redevelopment Department budget with Les Olds.
Created packets for City Councilors. 0.75
Updated CRC budget sheet for public meeting. 0.25
Prepared Redevelopment Department and CRC claims for 1
submission.
Prepared for meeting. 0.75
Updated several tabs for CRC budget. 0.75
Attended CRC monthly meetings. 2
7/30/2013 Reviewed and responded to emails from CRC staff. 0.25
Reviewed CRC and Redevelopment Department invoices for 0.25
payment.
Discussion with Les Olds about contracts and certain vendors 0.25
being paid.
Gathered items for meeting with auditor. 0.25
Researched CRC database for check numbers requested on 4.25
list of claims provided by the Clerk-Treasurer's office.
7/31/2013 Researched CRC database for check numbers requested on 2
list of claims provided by the Clerk-Treasurer's office.
Contacted Regions Bank and Loren Matthes to discuss 0.5
SWAP termination payment calculation documentation for
auditor.
Total Hours 16.25
Total Fee $650.00
I
Michael Lee
506 W Smokey Row Rd.
Date: 9/1/13 Carmel, IN 46032 Invoice 201308
Date Description of Work Hours
8/1/2013 Reviewed 2011 and 2012 Sophia Square garage expense
invoices. Deducted all late fee amounts and calculated
correct total. Prepared claims for each invoice. 2.25
Filled out transfer of funds form for Redevelopment
Department. 0.25
8/2/2013 Researched CRC database for check numbers requested on
list of claims provided by the Clerk-Treasurer's office. 2.5
8/5/2013 Gathered check stubs requested by Clerk-Treasurer's office.
Scanned and sent to Sandy Johnson. 1
Organized files for move from CRC office to temporary office. 2
Conversation with Les Olds RE: exhibits for contracts. 0.25
Compiled purchase orders electronically. 0.25
8/6/2013
Organized files for move from CRC office to temporary office. 2
8/8/2013 Reviewed CRC invoices and filled out claims for approval. 1
8/12/2013 Prepared claims for submission and delivered to Clerk-
Treasurer's office. 0.5
Reviewed CRC budget and adjusted tabs for each line item. 0.5
Update CRC monthly forecast as of 8/1/13. 0.5
8/13/2013 Added detail to budget line item tabs for meeting. 1
Attended meeting with Dave Bowers, Jim Higgins and Matt
Worthley. 2.5
8/15/2013 Worked on revising 2013 budget. 0.5
Updated forecast. 0.25
8/16/2013 Updated Expenditure/Revenue Analysis. 0.5
Updated Summary. 0.5
Updated revised budget. 0.5
Michael Lee
506 W Smokey Row Rd.
Date: 9/1/13 Carmel, IN 46032 Invoice 201308
8/19/2013 Reviewed invoices and prepared claims. 2.5
Attended 4CDC meeting. 0.25
Communicated with vendor to discontinue service. 0.25
Emailed Jim Higgins and Bruce Donaldson RE: defeasance
of bonds. 0.25
8/20/2013 Reviewed invoices and prepared claims for approval. 3.25
Updated revised budget and sent to Dave Bowers and Jim
Higgins for review. 0.5
8/21/2013 Reviewed invoices and prepared claims. 1
Reviewed Carmel Lofts invoices for 2011 and 2012 garage
expenses. 0.5
8/22/2013 Input invoices for CRC and Redevelopment Department on
approval sheets. 1.5
Updated CRC forecast based on anticipated August
expenditures and budget revisions. 1
Researched portions of Carmel Lofts, LLC invoices for
Garage expenses. 1
Reviewed purchase orders and additional invoices. Prepared
claims for approval. 0.75
8/23/2013 Phone conversation with Dave Bowers RE: CRC revised
budget. 0.75
Worked on revising budget. 1
Scanned documents for packet. 0.5
Revised forecast for packet. 1.25
Revised debt sheets for packet. 0.5
Prepped claims for submission to Clerk-Treasurer's office. 0.75
Organized and prepared financial information packet. 2.5
Input purchase order information into spreadsheets. 0.25
8/26/2013
Prepared and delivered claims to the Clerk-Treasurer's office. 1.5
8/28/2013
Reviewed contracts and purchase orders needed to submit
invoices. Discussed this with Les Olds and Matt Worthley. 1.25
Created action item for change orders. 0.25
Prepared for CRC meeting. 0.5
Attended CRC monthly meeting. 2
Michael Lee
506 W Smokey Row Rd.
Date: 9/1/13 Carmel, IN 46032 Invoice 201308
8/29/2013 Input year-to-date information for revised budget tabs. 1.75
Created and emailed Club Canine invoices. 0.25
Total Hours 46.5
Total Fee $1,860.00
Michael Lee
506 W Smokey Row Rd.
Date: 10/1/13 Carmel, IN 46032 Invoice 201309
Date Description of Work Hours
9/3/2013 Input expenditures and revenues into check register. 0.25
Updated summary as of 8/31/13. 0.5
Input expenditures and revenues into CRC forecast. 0.5
Contacted Duke Energy RE: account that needs transferred. 0.25
Reviewed CRC and CRD invoices and purchase orders. 0.5
Discussed payment of two invoices from bond proceeds with
Cindy Sheeks and researched official bond statement for
clarity. 0.5
Prepared packets for City Councilors. 0.5
9/4/2013 Updated Expenditure/Revenue analysis for August. 0.5
Updated Redevelopment Department budget line items as of
8/31/13. 0.25
Revised forecast, check register and summary to account for
bond funds held by Clerk-Treasurer that were used for the
2012 Refunding Bond. 1.25
9/10/2013 Responded to emails RE: vendor invoices, payments and
902 TIF and cash balances. 0.75
Reviewed CRC and Redevelopment Department invoices and
prepared claims. 1.5
Made phone calls RE: escrow for vendor retention and CRC
budget. 0.5
9/11/2013 Reviewed CRC invoices and made copies and scans for
monthly packet. 1.5
9/12/2013 Input invoices into approval sheets. 1
Updated forecast, expenditure/revenue analysis and fund
balances page for packet. 1.75
9/13/2013 Calculated TIF and cash expended year-to-date for Clerk-
Treasurer's office. 0.25
Updated forecast and completed monthly packet for
September meeting. 2.5
Michael Lee
506 W Smokey Row Rd.
Date: 10/1/13 Carmel, IN 46032 Invoice 201309
9/16/2013 Revised 2013 forecast and summary based on meeting with
Cindy Sheeks. 1
9/18/2013
Prepared and reviewed documents for CRC monthly meeting. 2
Attended CRC monthly meeting. 2
9/19/2013 Reviewed CRC and Redevelopment Department invoices.
Called vendors when necessary. 1.5
Prepared claims to be processed. 2
Organized purchase orders and made copies of invoices for
October packet. 0.5
9/20/2013 Reconciled American Structurepoint invoices to correct
purchase orders. 1
Reviewed CRC and Redevelopment Department invoices. 0.75
Conference call with Les Olds and Matt Worthley. Phone call
with vendor. 0.25
Prepared purchase orders and claims to be processed. 1.5
9/23/2013 Prepared claims to be submitted to Clerk-Treasurer's office. 1
Updated 2014 forecast. 1.25
Updated 2013 Redevelopment Department balances. 0.25
9/30/2013 Responded to CRC related emails RE: General Piping,
conference call, meeting dates and checks. 0.25
Total Hours 30
Total Fee $1,200.00
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.
Payee
Mldu � L P Purchase Order No.
50 0 , /o 0 k�R h j / RJ. Terms
Carmel,�./y �o�z Date Due
Invoice Invoice Description Amount
Date Number (or note attached invoice(s) or bill(s))
g—P IOL307 f iAdyi vi o fo.r- Ju( 6SU.00
01-1-13 20)3n hen Wi r I g60.°d
10- —13 301 6 M 5ervites' kir S em er 12UO,a6
Total VIVO
O
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
VOUCHER NO. WARRANT NO.
ALLOWED 20
A Gh�P I L�P IN SUM OF $
ON ACCOUNT OF APPROPRIATION FOR
Cash 9021�3 q 0303
Board Members
PO#or INVOICE NO. ACCT#!TITLE AMOUNT
DEPT.# I hereby certify that the attached invoice(s), or
3133 Z bill(s) is (are) true and correct and that the
31332- ?-01309 I+ x}0303 � R60 materials or services itemized thereon for
N3)2- 2-009 434U3 03 1,200.01 which charge is made were ordered and
received except
2013
ignature
Cost distribution ledger classification if
Title
claim paid motor vehicle highway fund