Attachment S-4 Manpower Performance Data Sheet.xlsx
XLSX spreadsheet 577 KB Posted
- Solicitation number
- N0002424R4425
About this file
This document is an attachment titled "Attachment S-4 Manpower Performance Data Sheet.xlsx" related to a federal contract opportunity for the USS BOXER (LHD 4) FY25 Selected Restricted Availability. The attachment requires offerors to provide monthly EV project-level data, including ACWP, ETC, BCWP, and BCWS, for all projects ongoing or completed between October 2022 and August 2026. The attachment provides detailed instructions on how to fill out the data sheet, including definitions of key earned value management terms. Offerors are required to provide this data to demonstrate their capabilities in accordance with Factor 2, Subfactor A of the solicitation. The related federal contract opportunity is solicitation N00024-24-R-4425 issued by the Naval Sea Systems Command for the USS BOXER (LHD 4) FY25 Selected Restricted Availability, which includes maintenance, modernization, and repair work. The government anticipates making a single award on or around December 2024, with the work beginning in April 2025 and completing in August 2026.
View the file
Other files
Show all 24
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Monthly EV
| Project level data IAW Factor 2, Subfactor A (Section L, Para V.B.2.a.): OFFERORS MUST PROVIDE DATA, FROM PROJECT START TO PROJECT COMPLETE, FOR ALL PROJECTS ONGOING OR COMPLETED BETWEEN THE WEEK COMMENCING 10/01/2022 & CONCLUDING 8/06/2026. | FY | FY 2023 | FY 2024 | FY 2025 | FY 2026 | ||||||||||||||||||||||||||||||||||||||||||||
| Month | Oct-22 | Nov-22 | Dec-22 | Jan-23 | Feb-23 | Mar-23 | Apr-23 | May-23 | Jun-23 | Jul-23 | Aug-23 | Sep-23 | Oct-23 | Nov-23 | Dec-23 | Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | Jun-24 | Jul-24 | Aug-24 | Sep-24 | Oct-24 | Nov-24 | Dec-24 | Jan-25 | Feb-25 | Mar-25 | Apr-25 | May-25 | Jun-25 | Jul-25 | Aug-25 | Sep-25 | Oct-25 | Nov-25 | Dec-25 | Jan-26 | Feb-26 | Mar-26 | Apr-26 | May-26 | Jun-26 | Jul-26 | Aug-26 | Sep-26 | |
| Month Start |
Simei: Change as required to match EVM reporting timeframe.
| To include the full availability duration for all projects not yet completed that fall before the first month identified in Attachment S-4 (Oct 2022), type the 1st of the month for the corresponding FY. Subsequent dates will adjust accordingly. | 10/1/22 | 11/1/22 | 12/1/22 | 1/1/23 | 2/1/23 | 3/1/23 | 4/1/23 | 5/1/23 | 6/1/23 | 7/1/23 | 8/1/23 | 9/1/23 | 10/1/23 | 11/1/23 | 12/1/23 | 1/1/24 | 2/1/24 | 3/1/24 | 4/1/24 | 5/1/24 | 6/1/24 | 7/1/24 | 8/1/24 | 9/1/24 | 10/1/24 | 11/1/24 | 12/1/24 | 1/1/25 | 2/1/25 | 3/1/25 | 4/1/25 | 5/1/25 | 6/1/25 | 7/1/25 | 8/1/25 | 9/1/25 | 10/1/25 | 11/1/25 | 12/1/25 | 1/1/26 | 2/1/26 | 3/1/26 | 4/1/26 | 5/1/26 | 6/1/26 | 7/1/26 | 8/1/26 | 9/1/26 | 10/1/26 |
| Month End |
Simei: Change as required to match EVM reporting timeframe.
| The defualt end is the last day of the month. | 10/31/22 | 11/30/22 | 12/31/22 | 1/31/23 | 2/28/23 | 3/31/23 | 4/30/23 | 5/31/23 | 6/30/23 | 7/31/23 | 8/31/23 | 9/30/23 | 10/31/23 | 11/30/23 | 12/31/23 | 1/31/24 | 2/29/24 | 3/31/24 | 4/30/24 | 5/31/24 | 6/30/24 | 7/31/24 | 8/31/24 | 9/30/24 | 10/31/24 | 11/30/24 | 12/31/24 | 1/31/25 | 2/28/25 | 3/31/25 | 4/30/25 | 5/31/25 | 6/30/25 | 7/31/25 | 8/31/25 | 9/30/25 | 10/31/25 | 11/30/25 | 12/31/25 | 1/31/26 | 2/28/26 | 3/31/26 | 4/30/26 | 5/31/26 | 6/30/26 | 7/31/26 | 8/31/26 | 9/30/26 | 10/31/26 |
| Cumulative Hours | Working Days (Calculated) -> | ||||||||||||||||||||||||||||||||||||||||||||||||
| Simei: Calculates the the # of working days for given month using provided Month Start/End and Holidays dates. | 21 |
Simei: Formula: Calculate Net Work days in month and subtracts Holidays
| =NETWORKDAYS(F3,F4,'Holiday Calendar'!$A:$A) | 22 | 22 | 22 | 20 | 23 | 20 | 23 | 22 | 21 | 23 | 21 | 22 | 22 | 21 | 23 | 21 | 21 | 22 | 23 | 20 | 23 | 22 | 21 | 23 | 21 | 22 | 23 | 20 | 21 | 22 | 22 | 21 | 23 | 21 | 22 | 23 | 20 | 23 | 22 | 20 | 22 | 22 | 21 | 22 | 23 | 21 | 22 | 22 | 21 |
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 1 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 1 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 1 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 1 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 1 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 2 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 2 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 2 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 2 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 2 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 3 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 3 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 3 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 3 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 3 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 4 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 4 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 4 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 4 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 4 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 5 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 5 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 5 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 5 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 5 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 6 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 6 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 6 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 6 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 6 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 7 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 7 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 7 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 7 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 7 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 8 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 8 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 8 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 8 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 8 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 9 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 9 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 9 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 9 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 9 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 10 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 10 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 10 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 10 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 10 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 11 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 11 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 11 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 11 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 11 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 12 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 12 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 12 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 12 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 12 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 13 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 13 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 13 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 13 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 13 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 14 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 14 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 14 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 14 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 14 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 15 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 15 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 15 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 15 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 15 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 16 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 16 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 16 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 16 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 16 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 17 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 17 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 17 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 17 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 17 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 18 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 18 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 18 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 18 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 18 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 19 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 19 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 19 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 19 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 19 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 20 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 20 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 20 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 20 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 20 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 21 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 21 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 21 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 21 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 21 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 22 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 22 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 22 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 22 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 22 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 23 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 23 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 23 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 23 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 23 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 24 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 24 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 24 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 24 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 24 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 25 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 25 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 25 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 25 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 25 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 26 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 26 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 26 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 26 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 26 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 27 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 27 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 27 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 27 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 27 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 28 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 28 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 28 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 28 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 28 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 29 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 29 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 29 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 29 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 29 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Project 30 | Project Name (Replace) | ACWP from Actual / Forecast Start Date to Time-Now (Fill in current Period Hours) -> | 0 | ACWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 30 | Project Name (Replace) | ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 30 | Project Name (Replace) | Remaining Growth ETC to Actual / Forecast Completion Date (Fill in current Period Hours) - > | 0 | GROWTH ETC | |||||||||||||||||||||||||||||||||||||||||||||
| Project 30 | Project Name (Replace) | BCWP from Contract Start Date to Time-Now (Fill in current Period Hours) -> | 0 | BCWP | |||||||||||||||||||||||||||||||||||||||||||||
| Project 30 | Project Name (Replace) | BCWS from Contract Start Date to Contract Completion Date (Fill in current Period Hours) -> | 0 | BCWS | |||||||||||||||||||||||||||||||||||||||||||||
| - | |||||||||||||||||||||||||||||||||||||||||||||||||
| Offeror may add or delete project fields, as necessary. Directions to add project fields: Step 1: Select rows 179-184-> Step 2: Copy-> Step 3: Right Click Row 185-> Step 4: Insert Copied Cells. Repeat Steps 1-4 as necessary (increase row reference by 6 each time). | |||||||||||||||||||||||||||||||||||||||||||||||||
| *Note: The Navy understand that Growth Options are not authorized work. Growth Options are not yet exercised. |
Cumulative EV
| *Provide cumulative EVM in production hours. **Offeror may add or reduce project and/or growth fields, as required. ***Note: The Navy understand that Growth Options and New Work are not authorized work. Growth Options are not yet exercised and New Work reflect estimates. | *Contract Start of Project | *Contract Completion of Project | *Actual or Scheduled Start of Project | *Actual or Scheduled Completion of Project | *The status of the project, either: Completed, In-Progress, Awarded, Proposed or Anticipated. | *Budget At Complete (BAC). The total production budget. **Verify the cumulative hour values calculated align with internal earned value information. If the cumulative calculation does not align with the internal earned value information, then enter the value manually and “Insert Comment” to the manually adjusted cell that describes the discrepancy. | *Estimate at Complete (EAC). The total estimated production hours spent at completion. **Verify the cumulative hour values calculated align with internal earned value information. If the cumulative calculation does not align with the internal earned value information, then enter the value manually and “Insert Comment” to the manually adjusted cell that describes the discrepancy. | *Budget Cost of Work Scheduled (BCWS). The total production budget scheduled up until "time-now". This value must align to the sum of the Timephased BCWS during the historical range prior to "time-now". | *Budget Cost of Work Performed (BCWP). The total production budget earned. **Verify the cumulative hour values calculated align with internal earned value information. If the cumulative calculation does not align with the internal earned value information, then enter the value manually and “Insert Comment” to the manually adjusted cell that describes the discrepancy. | *Budget To Complete (BTC). The total production budget remaining. **Verify the cumulative hour values calculated align with internal earned value information. If the cumulative calculation does not align with the internal earned value information, then enter the value manually and “Insert Comment” to the manually adjusted cell that describes the discrepancy. | *Actual Cost of Work Performed (ACWP). The total production hours spent. **Verify the cumulative hour values calculated align with internal earned value information. If the cumulative calculation does not align with the internal earned value information, then enter the value manually and “Insert Comment” to the manually adjusted cell that describes the discrepancy. | *Estimate to Complete (ETC). The total estimated production hours remaining. **Verify the cumulative hour values calculated align with internal earned value information. If the cumulative calculation does not align with the internal earned value information, then enter the value manually and “Insert Comment” to the manually adjusted cell that describes the discrepancy. | *Estimate to Complete (ETC) the Remaining Growth Options. **Verify the cumulative hour values calculated align with internal earned value information. If the cumulative calculation does not align with the internal earned value information, then enter the value manually and “Insert Comment” to the manually adjusted cell that describes the discrepancy. | *Cost Performance Index (CPI). CPI = BCWP/ACWP | *To-Complete Cost Performance Index (TCPI). TCPI = BTC/ETC | *Schedule Performance Index (CPI). SPI = BCWS/ACWS | *Performance Based ETC is auto-calculated by applying the CPI to the BTC. Perfmance Based ETC = BTC/CPI | |
| Project # | Project Name | Contract Start Date | Contract Completion Date | Actual / Forecast Start Date | Actual / Forecast Completion Date | Project Status | BAC | EAC | BCWS | BCWP | BTC | ACWP | ETC | GROWTH ETC | CPI | TCPI | SPI | Performance Based ETC |
| Project 1 | Project Name (Replace) | [Enter Date] | [Enter Date] | [Enter Date] | [Enter Date] | [Enter Project Status] | 0 | 0 | [Enter BCWS at Time-now] | 0 | 0 | 0 | 0 | 0 | - | - | - | - |
| Project 2 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 3 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 4 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 5 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 6 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 7 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 8 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 9 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 10 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 11 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 12 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 13 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 14 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 15 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 16 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 17 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 18 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 19 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 20 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 21 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 22 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 23 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 24 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 25 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 26 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 27 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 28 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 29 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Project 30 | Project Name (Replace) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | ||||||
| Yard | Yard Wide | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - |
| Offeror may add or delete project fields, as necessary. Directions to add project fields: Step 1: Select row 32-> Step 2: Copy-> Step 3: Right Click Row 33-> Step 4: Insert Copied Cells. Repeat Steps 1-4 as necessary (increase row reference by 1 each time). |
| *Note: The Navy understand that Growth Options are not authorized work. Growth Options are not yet exercised. |
Holiday Calendar List holidays (within the specified time range) in the cells in column A
Definitions
| Remaining Growth Options – The number of unused and unexercised growth hours, time phased over usage rates prescribed in Section B Note F. |
| New Work – The number of unused New Work hours, time phased over usage rates using the same phasing as assumed for growth from Section B Note F. |
| Prime Contractor Labor – Laborers hired by the prime contractor to perform as an agent of the prime without a specific employment end date. |
| Overtime Labor – Labor provided by employees covered by the Fair Labor Standards Act in excess of 40 hours in a work week |
| Subcontractor Labor – Subcontractors are labor provided by a company contracted by the prime contractor to perform as an independent contractor and not as an agent of the prime to deliver a product or service by a specified deadline. |
| Temporary Labor –Laborers contracted by the prime contractor to perform as an agent of the prime to work for one year or less with a specific end date. The prime contractor may directly hire temporary labor or through a third-party employment agency. |
| Full Time Equivalents (FTE) – A normalized representation of full-time workers based on the number of hours spent/scheduled during a finite period of time. An FTE unit assumes an 8-hour work day and a 5-day work week (Monday-Friday) except when accounting for holidays. For example, if the hours spent or scheduled during a week with one holiday was 160 hours, then the FTE value representing that week would be equal to 5 FTE (160 hours divided by 8-hour days divided by 4 works days equals 5 FTE). |
| Time-now – The latest date within a dataset containing historical values such as actuals or earnings (ACWP & BCWP). Time-now must be no earlier than the date of RFP release. |
| Cumulative Earned Value – the cumulative earned values as of Time-now |
| Time-phased Earned Value – periodic allocations of earned values representing work scheduled/earned/spent/or estimated during a given period of time |
| Contract Start Date – The contractually agreed start of contractor project execution. |
| Contract Completion Date - The contractually agreed contractor completion date |
| Actual / Forecast Start Date – The date the project started (if the project started prior to the last date identified in Attachment S-4) or the contractor’s estimated start date (if expected to occur after the last date identified in Attachment S-4) |
| Actual / Forecast Completion Date - The date the project completed (if project completed prior to last date identified in Attachment S-4) or the contractor’s currently estimated completion date. |
| Project Status – The status of a project either: completed, in-progress, awarded, proposed, or anticipated. |
| Budget at Complete (BAC) – The total budgeted production hours earned at completion of the project. The BAC equals the cumulative BCWP plus the cumulative BTC. |
| Estimate at Complete (EAC) – The total estimated production hours spent at completion of the project. The EAC equals the cumulative ACWP plus the cumulative ETC. |
| Budgeted Cost of Work Scheduled (BCWS) – The scheduled completion of budgeted weekly production work. The sum of the weekly BCWS values equals the BAC. |
| Budgeted Cost of Work Performed (BCWP) - The measurement of the budgeted weekly production work completed, BCWP is the value of work performed, or “earned,” by both prime and subcontractor within a week. |
| Budget to Complete (BTC) - The budgeted total production hours remaining to complete the project. |
| Actual Cost of Work Performed (ACWP) – The production hours actually incurred and recorded, prime and subcontractor. The offeror may estimate actual subcontracting hours based on prime contractor outlays. |
| Estimate to Complete (ETC) – The estimated total production hours remaining to complete the project. |
| Cost Performance Index (CPI) - An index representing the cumulative production labor efficiency realized for the earned budget of a project. The CPI equals the BCWP divided by the ACWP. |
| To-Complete Cost Performance Index (TCPI) – An index representing the production labor efficiency required of the remaining budget to achieve the project’s EAC. The TCPI the BTC divided by the ETC. |
| Schedule Performance Index (SPI) – An index representing the cumulative schedule adherence for a project. The SPI equals the BCWP divided by the BCWS. |
Manpower Charts Format
| Requirements for all 4 Manpower Charts required in: |
| (Section L, Factor 2 - Resource Capacity & Schedule, Emphasis Area A - Manpower, Manpower Charts) |
| 1. A Time-now line must be included that separates Historical FTE (ACWP) from Forecasted FTE (ETC) |
| a) ACWP FTE values are charted to the left of Time-now |
| b) ETC FTE values are charted to the right of Time-now |
| 2. The chart must align with the data provided in Attachment S-4 |
| 3. Offerors shall clearly delineate prime and subcontractor FTE, even though this is not a requirement of Attachment S-4. |
| 4. Growth Work options shall be totaled for each set of project curves required and displayed as a single curve within each chart. |
| 5. Sand chart layers representing Subcontracting must all be same color of light gray |
| 6. Sand chart layers representing Growth Work Options must all be same color of dark gray |
| 7. Two additional FTE lines representing ACWP / ETC values must be plotted for: |
| a) Prime labor (FTE) |
| b) Prime labor + Subcontractor labor (FTE) |
| c) Prime labor + Subcontractor labor + Temp labor FTE |
| 1. The top of the sand chart layers must align with the “Prime labor + Subcontractor labor + Temp labor (FTE)” |
image1.png
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .