S02 - 537-24-105 Construction Project Tracker.xlsx
XLSX spreadsheet 71 KB Posted
- Attached to
- Z2DA--537-24-105 OR Suite Lighting Replacement Federal contract opportunity
- Solicitation number
- 36C25225B0018
About this file
This Excel file is a comprehensive project tracking document for a Department of Veterans Affairs construction project at the Jesse Brown VAMC in Chicago, Illinois, focusing on an OR Suite Lighting Replacement. The project tracking spreadsheet includes detailed sections for construction performance periods, Request for Information (RFI) log, submittal log, punchlist, payment log, contract modifications, and meeting minutes. The construction period of performance is structured across five key tasks: Project Kick-Off Submittals, Coordination Submittals, Pre-Construction Submittals, Mobilization and Performance of the Work, and Closeout Submittals, with a total projected timeline spanning 428 calendar days after the Notice to Proceed (NTP). The project involves key personnel including a Contracting Officer (CO), Contract Specialist (CS), Contracting Officer's Representative (COR), and Engineering Supervisor, with ongoing tracking of project progress, daily logs, and contract modifications.
View the file
Other files for this federal contract opportunity
Show all 23
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
POP
| Department of Veterans Affairs | |||||||
| 537-19-124 Project Title | |||||||
| Jesse Brown VAMC | |||||||
| Chicago, Illinois | |||||||
| NTP Date: | TBD | ||||||
| CONSTRUCTION PERIOD OF PERFORMANCE CHART (IN CALENDAR DAYS AFTER NTP) | |||||||
| Level Complete | Calendar Days for the Work | Planned Date | Actual Date | VA Review | Planned Date | Revised Date | Total days after NTP |
| Task 1 – Project Kick-Off Submittals | 7 | 7 | 14 | ||||
| Task 2 – Coordination Submittals | 45 | 21 | 80 | ||||
| Task 3 – Pre-Construction Submittals | 21 | 14 | 115 | ||||
| Task 4 – Mobilization and Performance of the Work | 271 | 0 | 386 | ||||
| Task 5 – Closeout Submittals | 21 | 21 | 428 |
RFI LOG
| Department of Veterans Affairs | |||||||
| 537-24-105 OR Suite Lighting | |||||||
| Jesse Brown VAMC | |||||||
| Chicago, Illinois | |||||||
| REQUEST FOR INFORMATION LOG | |||||||
| REQUEST FOR INFORMATION | VA RESPONSE | ||||||
| RFI # | ISSUE DATE | RESOLUTION ON THE FOLLOWING | NEED REPLY BY DATE | DATE | BY | REQUEST FOR INFORMATION RESPONSE | VA DAYS TO REPLY |
SUBMITTAL LOG
| Department of Veterans Affairs | ||||||||||||
| 537-24-105 OR Suite Lighting | ||||||||||||
| Jesse Brown VAMC | ||||||||||||
| Chicago, Illinois | ||||||||||||
| SUBMITTAL LOG | ||||||||||||
| REQUEST FOR SUBMITTAL REVIEW | DESIGNER OF RECORD RESPONSE | VA ACCEPTANCE / RESOLUTION | TIME ANALYTICS | |||||||||
| ID | ISSUE DATE | SUMBITTAL BY SECTION OF WORK | NEED REPLY BY DATE | REPLY DATE | REPLY FROM | AE RECOMMENDATION | DATE | REVIEW BY | VA ACTION | DAYS TO REVIEW | DAYS TO RESUBMIT | SUBMITTAL STATUS |
PUNCHLIST
| Department of Veterans Affairs | |||||||
| 537-24-105 OR Suite Lighting | |||||||
| Jesse Brown VAMC | |||||||
| Chicago, Illinois | |||||||
| CONSTRUCTION PUNCHLIST | |||||||
| ID | DATE | DESCRIPTION | LOCATION | DIVISION | CONTRACTOR ACTION TAKEN | VA RESPONSE | COMPLETION DATE |
PAYMENT LOG
| Department of Veterans Affairs | |||||||||
| 537-24-105 OR Suite Lighting | |||||||||
| Jesse Brown VAMC | |||||||||
| PENCIL COPY REVIEW | IPPS PAYMENT HISTORY | ||||||||
| PAY APP # | SUBMITTAL DATE | AMOUNT | COR APPROVAL DATE | SP | DLN | Invoice Number | Amount | Check Number | Check Date |
| CONTRACT MODIFICATIONS | CONTRACT AMOUNT | |||
| Number | Amount | Date | PO Number | |
| P00001 | Original P.O. Amount | |||
| P00002 | Contract Modifications | $0.00 | ||
| P00003 | Current PO Amount | $0.00 | ||
| P00004 | Payments Issued | $0.00 | ||
| P00005 | Outstanding PO Amount | $0.00 | ||
| P00006 | ||||
| P00007 | ||||
| TOTAL | $0.00 | - |
MTG MINUTES
| Department of Veterans Affairs | ||
| 537-24-105 OR Suite Lighting | ||
| Jesse Brown VAMC | ||
| Chicago, Illinois | ||
| Meeting Date: | % Complete: | |
| General Contractor: | Completion Date: | |
| Prepared by: | Days Remaining in Contract: |
ID Date Description Responsible Party Due Date Status
MTG ATTENDANCE
| Department of Veterans Affairs | ||||||
| 537-24-105 OR Suite Lighting | ||||||
| Jesse Brown VAMC | ||||||
| Key P = Present, A = Absent | ||||||
| ATTENDEE | PROGRESS MEETING DATE | |||||
| NAME | PROJECT ROLE | xx/xx/xx | xx/xx/xx | xx/xx/xx | xx/xx/xx | xx/xx/xx |
| Ryan McMillin | CO | |||||
| Rich Goodman | CS | |||||
| Eloy Cerda | COR | |||||
| Jeremy Hsu | Eng. Supervisor |
DAILY LOGS
| Department of Veterans Affairs |
| 537-24-105 OR Suite Lighting |
| Jesse Brown VAMC |
DAILY REPORT LOG
DAILY REPORT # REPORT DATE SUBMITTAL DATE SUMMARY OF WORK PERFORMED (INCLUDE ROOM NUMBERS) image1.jpeg
File details come from the government source that posted it. Updated .