RFP Attachment 1 - Price Proposal Worksheet 01042021_0008.xlsx
XLSX spreadsheet 59 KB Posted
- Solicitation number
- 1605C5-21-R-00001
- Issued by
- Not on record
About this file
This document contains a pricing proposal worksheet for the National Longitudinal Surveys recompete contract from 2021 to 2025. The contractor is required to provide pricing for management and IT security services over the base year and four option years. In addition, the contractor must perform tasks related to survey preparation, data collection, and post-collection activities for the NLSY79 and NLSY97 longitudinal studies. These tasks involve respondent outreach, survey design and planning, cognitive testing, non-response bias analysis, and data processing. Pricing must be proposed separately for each of the 21 contract line items. The incumbent contractor will be recompeted under solicitation number 1605C5-21-R-00001 for the National Longitudinal Surveys contract currently held under number 1625DC-19-C-0004. Pricing proposals are due by January 4, 2021 to support continuation of the longitudinal survey studies conducted by the sponsoring federal agency.
View the file
Other files
Show all 33
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
Instructions Instructions
The Price Volume submitted in response to this solicitation shall include the Contractor’s best pricing for all categories that the Government has listed in RFP Attachment 1 – Pricing Proposal Form. Contractor should provide pricing that is Firm-Fixed-Price and must be based on the Contractor’s own technical proposal, the Government’s specifications, and other contractual requirements. Pricing responses should conform to this Attachment and shall reflect the total compensation based on the periods of performance as shown in the line items (i.e. all costs including labor, overhead, general and administrative (G&A) expenses, and profit).
Although the Government has provided the Excel document with formulas, it is the responsibility of the Contractors to verify the accuracy of all totals. If you experience any technical difficulties with the Excel document and need assistance, contact the Contract Specialist(s).
In Column H, for severable work, calculate the total that would be invoiced each month. For non-severable work, no monthly payment amount in this column is needed, but in a separate document, the Contractor shall state how the progress of the deliverable will be calculated for monthly invoices.
In Column K, the spreadsheet will calculate the CLIN total for the full period of performance for all severable CLINs. The Contractor must insert these CLIN totals for non-severable CLINs.
Column M will calculate the weighted total which will be used for evaluation.
Note: The Government is requesting additional documentation that includes detailed spreadsheet(s) and/or Table(s) (i.e. via MS Excel or Word Doc) that identifies labor categories, rates, hours, and other direct costs (ODCs). The price proposal shall separately identify the detailed pricing for each task as specified in Section H.2 CONTRACT PAYMENT REQUIREMENTS of the solicitation.
CLIN Structure
| NLS CLIN Structure | ||||||||||||||
| # | Base/ Option | Description | PWS Section | Period of Performance | Severability | Funding | Payment Amount | Quantity | Unit of Issue | Total CLIN Amount | Weight | Weighted Total | Six-Month Extension | |
| 0001 | Base | Management (all work/rounds) | Task 1 | 01/31/2021 - 01/30/2022 | Severable | Fully | 12 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 0002 | Base | IT Security Requirements for Data and Systems (all work/rounds) | Task 2 | 01/31/2021 - 01/30/2022 | Severable | Fully | 12 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 1001 | Option | Option Period 1 - Management (all work/rounds) | Task 1 | 01/31/2022 - 01/30/2023 | Severable | Fully | 12 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 1002 | Option | Option Period 1 - IT Security Requirements for Data and Systems (all work/rounds) | Task 2 | 01/31/2022 - 01/30/2023 | Severable | Fully | 12 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 2001 | Option | Option Period 2 - Management (all work/rounds) | Task 1 | 01/31/2023 - 01/30/2024 | Severable | Fully | 12 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 2002 | Option | Option Period 2 - IT Security Requirements for Data and Systems (all work/rounds) | Task 2 | 01/31/2023 - 01/30/2024 | Severable | Fully | 12 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 3001 | Option | Option Period 3 - Management (all work/rounds) | Task 1 | 01/31/2024 - 01/30/2025 | Severable | Fully | 12 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 3002 | Option | Option Period 3 - IT Security Requirements for Data and Systems (all work/rounds) | Task 2 | 01/31/2024 - 01/30/2025 | Severable | Fully | 12 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 4001 | Option | NLSY79, R30 Respondent Outreach Between Rounds Contact | Task 3 | 10/15/2021 - 7/30/2022 | Non-severable | Fully | 1 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 4002 | Base | NLSY79, R30 Design and Planning | Task 4 | 12/31/2020 - 9/14/2021 | Non-severable | Fully | 1 | MONTH | $ - 0 | $ - 0 | ||||
| 4003 | Option | NLSY79, R30 Survey Prep | Task 5 | 09/01/2021- 09/30/2022 | Non-severable | Fully | 1 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 4004 | Option | NLSY79, R30 Data Collection | Task 6 | 7/1/2022 - 8/30/2023 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | |||
| 4005 | Option | NLSY79, R30 Post Data Collection Activities | Task 7 | 05/01/2023 to 12/31/2024 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | |||
| 4006 | Option | NLSY97, R21 Respondent Outreach Between Rounds Contact | Task 8 | 10/15/2022 to 7/30/2023 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | ` | ||
| 4007 | Option | NLSY97, R21 Design & Planning | Task 9 | 9/1/2021 to 8/30/2022 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | |||
| 4008 | Option | NLSY97, R21 Survey Prep | Task 10 | 9/1/2022 to 9/30/2023 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | |||
| 4009 | Option | NLSY97, R21 Data Collection | Task 11 | 7/1/2023 to 8/30/2024 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | |||
| 4010 | Option | NLSY97, R21 Post Data Collection Activities | Task 12 | 5/1/2024 to 12/31/2025 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | |||
| 4011 | Option | Cognitive Testing, NLSY79 | Task 13 | 11/01/2021 to 05/15/2022 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 4012 | Option | Cognitive Testing, NLSY97 | Task 14 | 11/01/2022 to 05/15/2023 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 4013 | Option | Non-response Bias Analysis, NLSY79 | Task 15 | 08/01/2021 to 02/28/2022 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 4014 | Option | Non-response Bias Analysis, NLSY97 | Task 16 | 08/01/2022 to 02/28/2023 | Non-severable | Fully | 1 | s | $ - 0 | 20% | $ - 0 | |||
| 4015 | Option | NLSY97-R21 Cognition Survey Phase 1 | Task 17 | 7/1/2021 to 8/30/2022 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 4016 | Option | NLSY97-R21 Cognition Survey Phase 2 | Task 18 | 9/1/2022 to 9/30/2025 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 4017 | Option | NCEO Matching | Task 19 | 3/1//2021 to 7/15/2021 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 4018 | Option | NDI Coding | Task 20 | 3/15/2021 to 11/15/2021 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 4019 | Option | Census Pik File Creation | Task 21 | 12/31/2020 to 2/28/2021 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 5001 | Option | Option Period 4 - Management (all work/rounds) | Task 1 | 01/31/2025 - 12/31/2025 | Severable | Fully | 12 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 5002 | Option | Option Period 4 - IT Security Requirements for Data and Systems (all work/rounds) | Task 2 | 01/31/2025 - 12/31/2025 | Severable | Fully | 12 | MONTH | $ - 0 | 100% | $ - 0 |
| Notes: |
| * - Cost estimated for a 12 months period. |
| 1 - Base work is CLIN work required to complete associated base CLINS. |
| 2 - CLIN 0009 may only be exercised if CLIN 0008 had already been exercised |
| 3 - CLIN 0010 may only be exercised if CLIN 0009 had already been exercised |
| 4 - CLIN 0012 may only be exercised if CLIN 0011 had already been exercised |
| 5 - CLIN 0013 may only be exercised if CLIN 0012 had already been exercised |
| 6 - CLIN 0016 may only be exercised if CLIN 0015 had already been exercised |
| 7 - CLIN 0017 may only be exercised if CLIN 0016 had already been exercised |
| 8 - CLIN 0018 may only be exercised if CLIN 0017 had already been exercised |
Proposal Total
Proposal Breakdown
CLIN Line Item Unweighted CLIN Total IGCE Difference Difference Percentage Weighted Evaluation Total Weighted IGCE Difference Six-Month Extension Total Base Work Amount Optional Work Amount Six-Month Extension Total
| 0001 | Task 1 - Management (all work/rounds) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| 0002 | Task 2 - IT Security Requirements for Data and Systems (all work/rounds) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 1001 | Option Period 1 - Management (all work/rounds) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 1002 | Option Period 1 - IT Security Requirements for Data and Systems (all work/rounds) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 2001 | Option Period 2 - Management (all work/rounds) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 2002 | Option Period 2 - IT Security Requirements for Data and Systems (all work/rounds) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 3001 | Option Period 3 - Management (all work/rounds) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 3002 | Option Period 3 - IT Security Requirements for Data and Systems (all work/rounds) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4001 | Task 3 - User Services | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | Proposed Total | Weighted Evaluation Total | IGCE* | IGCE - Proposal Difference | Difference Percentage | Proposal Total without Six-Month Extension | |
| 4002 | Task 4 - Advisory Services | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4003 | Task 5 - Respondent Outreach Services | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | |
| 4004 | Task 6 - NLSY97, R19 Data Processing | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4005 | Task 7 - NLSY79, R29 Respondent Outreach Between Rounds Contact | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4006 | Task 8 - NLSY79, R29 Survey Prep | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4007 | Task 9 - NLSY79, R29 Data Collection | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4008 | Task 10 - NLSY79, R29 Post Data Collection Activities | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4009 | Task 11 - NLSY79, R29 Child & Young Adult Surveys - Prep | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4010 | Task 12 - NLSY79, R29 Child & Young Adult Surveys - Data Collection | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4011 | Task 13 - NLSY79, R29 Child & Young Adult Surveys - Post Data Collection Activites | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4012 | Task 14 - NLSY97, R20 Respondent Outreach Between Rounds Contact | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4013 | Task 15 - NLSY97, R20 Design & Planning | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4014 | Task 16 - NLSY97, R20 Survey Prep | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4015 | NLSY97-R21 Cognition Survey Phase 1 | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4016 | NLSY97-R21 Cognition Survey Phase 2 | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4017 | NCEO Matching | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4018 | NDI Coding | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 4019 | Census Pik File Creation | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 5001 | Option Period 4 - Management (all work/rounds) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 5002 | Option Period 4 - IT Security Requirements for Data and Systems (all work/rounds) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
File details come from the government source that posted it. Updated .