Loading...
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