RFP Attachment 1 - Price Proposal Worksheet_updated.xlsx
XLSX spreadsheet 37 KB Posted
- Solicitation number
- 1605C5-21-R-00001
- Issued by
- Not on record
About this file
This document contains a pricing proposal worksheet for a National Longitudinal Surveys recompete contract solicitation. The solicitation involves multiple contract line item numbers for management, IT security, respondent outreach, survey design and planning, data collection, post-data collection activities, cognitive testing, non-response bias analysis, cognition surveys, matching, coding, and file creation for the National Longitudinal Surveys of Labor Market Experience 1979 and 1997 cohorts. The period of performance spans from December 2020 through December 2025. Pricing is to be proposed on a firm-fixed-price basis according to the structure and instructions in the worksheet, with separate identification of labor categories, rates, hours and other direct costs for each task. Weighted evaluation will be based on total proposed price.
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 |
| (For CLINS 0001 and 0002, see Columns P - T for yearly rates. The totals for all years are added to Columns K and M) | Quantity | Unit of Issue | Total CLIN Amount | Weight | Weighted Total | Six-Month Extension | Monthly Payment Amount |
| 9/15/2020 - 9/14/2021 | Monthly Payment Amount | ||||||
| 9/15/2021 - 9/14/2022 | Monthly Payment Amount | ||||||
| 9/15/2022 - 9/14/2023 | Monthly Payment Amount | ||||||
| 9/15/2023 - 9/14/2024 | Monthly Payment Amount | ||||||
| 9/15/2024 - 9/14/2025 | Monthly Payment Amount |
9/14/2025 - 12/31/2025
| 0001 | Base | Management (all work/rounds) | Task 1 | 12/31/2020 to 12/31/2025 | Severable | See note 2 | NA | NA | NA | $ - 0 | 100% | $ - 0 | $ - 0 | |
| 0002 | Base | IT Security Requirements for Data and Systems (all work/rounds) | Task 2 | 12/31/2020 to 12/31/2025 | Severable | See note 2 | NA | NA | NA | $ - 0 | 100% | $ - 0 | $ - 0 | |
| 0003 | Option | NLSY79, R30 Respondent Outreach Between Rounds Contact | Task 3 | 10/15/2021 - 7/30/2022 | Non-severable | Fully | 1 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 0004 | Base | NLSY79, R30 Design and Planning | Task 4 | 12/31/2020 - 9/14/2021 | Non-severable | Fully | MONTH | $ - 0 | $ - 0 | |||||
| 0005 | Option | NLSY79, R30 Survey Prep | Task 5 | 09/01/2021- 09/30/2022 | Non-severable | Fully | 1 | MONTH | $ - 0 | 100% | $ - 0 | |||
| 0006 | Option | NLSY79, R30 Data Collection | Task 6 | 7/1/2022 - 8/30/2023 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | |||
| 0007 | Option | NLSY79, R30 Post Data Collection Activities | Task 7 | 05/01/2023 to 12/31/2024 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | |||
| 0008 | 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 | ` | ||
| 0009 | Option | NLSY97, R21 Design & Planning | Task 9 | 9/1/2021 to 8/30/2022 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | |||
| 0010 | Option | NLSY97, R21 Survey Prep | Task 10 | 9/1/2022 to 9/30/2023 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | |||
| 0011 | Option | NLSY97, R21 Data Collection | Task 11 | 7/1/2023 to 8/30/2024 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | |||
| 0012 | Option | NLSY97, R21 Post Data Collection Activities | Task 12 | 5/1/2024 to 12/31/2025 | Non-severable | Fully | 1 | EA | $ - 0 | 100% | $ - 0 | |||
| 0013 | Option | Cognitive Testing, NLSY79 | Task 13 | 11/01/2021 to 05/15/2022 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 0014 | Option | Cognitive Testing, NLSY97 | Task 14 | 11/01/2022 to 05/15/2023 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 0015 | Option | Non-response Bias Analysis, NLSY79 | Task 15 | 08/01/2021 to 02/28/2022 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 0016 | Option | Non-response Bias Analysis, NLSY97 | Task 16 | 08/01/2022 to 02/28/2023 | Non-severable | Fully | 1 | s | $ - 0 | 20% | $ - 0 | |||
| 0017 | Option | NLSY97-R21 Cognition Survey Phase 1 | Task 17 | 7/1/2021 to 8/30/2022 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 0018 | Option | NLSY97-R21 Cognition Survey Phase 2 | Task 18 | 9/1/2022 to 9/30/2025 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 0019 | Option | NCEO Matching | Task 19 | 3/1//2021 to 7/15/2021 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 0020 | Option | NDI Coding | Task 20 | 3/15/2021 to 11/15/2021 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 | |||
| 0021 | Option | Census Pik File Creation | Task 21 | 12/31/2020 to 2/28/2021 | Non-severable | Fully | 1 | EA | $ - 0 | 20% | $ - 0 |
| Notes: |
| * - Cost estimated for a 12 months period. |
| 1 - Base work is CLIN work required to complete associated base CLINS. |
| 2 - Work is exercise/funded through the length of the active/exercised CLIN with the period of performance the furthest in the future. |
| 3 - CLIN 0009 may only be exercised if CLIN 0008 had already been exercised |
| 4 - CLIN 0010 may only be exercised if CLIN 0009 had already been exercised |
| 5 - CLIN 0012 may only be exercised if CLIN 0011 had already been exercised |
| 6 - CLIN 0013 may only be exercised if CLIN 0012 had already been exercised |
| 7 - CLIN 0016 may only be exercised if CLIN 0015 had already been exercised |
| 8 - CLIN 0017 may only be exercised if CLIN 0016 had already been exercised |
| 9 - 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 | $ - 0 | |||
| 0002 | Task 2 - IT Security Requirements for Data and Systems (all work/rounds) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| 0003 | 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 | |
| 0004 | Task 4 - Advisory Services | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 0005 | Task 5 - Respondent Outreach Services | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | |
| 0006 | Task 6 - NLSY97, R19 Data Processing | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 0007 | Task 7 - NLSY79, R29 Respondent Outreach Between Rounds Contact | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 0008 | Task 8 - NLSY79, R29 Survey Prep | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 0009 | Task 9 - NLSY79, R29 Data Collection | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 0010 | Task 10 - NLSY79, R29 Post Data Collection Activities | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 0011 | Task 11 - NLSY79, R29 Child & Young Adult Surveys - Prep | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 0012 | Task 12 - NLSY79, R29 Child & Young Adult Surveys - Data Collection | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 0013 | Task 13 - NLSY79, R29 Child & Young Adult Surveys - Post Data Collection Activites | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 0014 | Task 14 - NLSY97, R20 Respondent Outreach Between Rounds Contact | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 0015 | Task 15 - NLSY97, R20 Design & Planning | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 0016 | Task 16 - NLSY97, R20 Survey Prep | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | |||||||
| 0017 | NLSY97-R21 Cognition Survey Phase 1 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | ||||||||
| 0018 | NLSY97-R21 Cognition Survey Phase 2 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | ||||||||
| 0019 | NCEO Matching | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | ||||||||
| 0020 | NDI Coding | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 | ||||||||
| 0021 | Census Pik File Creation | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | $ - 0 |
File details come from the government source that posted it. Updated .