RFP Exhibit A - Price Workbook - Rev 2_041222.xlsx

XLSX spreadsheet 141 KB Posted

Attached to
Solicitation - Defense Personnel and Security Research Center (PERSEREC) Research Support Indefinite Delivery, Indefinite Quantity contract
Solicitation number
47QFPA22R0009
Issued by

About this file

Written by GovTribe AI ·

This solicitation requests proposals for research and support services to improve security, suitability, and credentialing programs. The General Services Administration, on behalf of the Defense Human Resources Activity and Defense Personnel Assessment Center, will award an Indefinite Delivery, Indefinite Quantity contract with a five-year base period to provide behavioral research, data analysis, program evaluation, technical writing and editing, software development, and project management support. The incumbent contractor is Northrop Grumman Systems Corporation. Questions are due by March 31st and proposals are due April 25th. The solicitation incorporates FAR provisions and clauses from 2005-97. Pricing will be Time and Materials or Firm Fixed Price.

View the file

Other files

File Type Posted
47QFPA22R0009_RFP_Attachment 7_Draft DD-254_041222.pdf PDF
47QFPA22R0009- RFP Question and Answer_041222.xlsx XLSX spreadsheet
47QFPA22R0009- RFP Question and Answer_041122.xlsx XLSX spreadsheet
47QFPA22R0009- RFP Question and Answer_040622.xlsx XLSX spreadsheet
PWS Attachment C _Labor Category Description and Key Personnel Requirement Summary and Matrix - Rev. 1_040522 (1).pdf PDF
RFP Exhibit A - Price Workbook - Rev 1_040622.xlsx XLSX spreadsheet
47QFPA22R0009 _RFP_PERSEREC_Amend 1_040622co.pdf PDF
47QFPA22R0009_D.1_PWS_Rev. 1_040622 (1).pdf PDF
RFP Attachment 4 - Task Order 1 - Rev. 1_040522 (1).pdf PDF
47QFPA22R0009_SF1449_04062022.pdf PDF
PWS Attachment F_MONTHLY QCP SURVEILLANCE SUMMARY (2) (3).xlsx XLSX spreadsheet
RFP Attachment 4 - Task Order 1 PWS (1).pdf PDF
47QFPA22R0009 PERSEREC_Final_032422 (1).pdf PDF
47QFPA22R0009_D.1_PWS_032222 (1).pdf PDF
RFP Attachment 6 - Quality Assurance Surveillance Plan_031622 (2).pdf PDF
PWS Attachment E_ Travel Authorization Request (2) (1).pdf PDF
PWS Attachment B_Monthly Status Report (3) (1).pdf PDF
RFP Attachment 5 - Sample Task Order A PWS (1) (2).pdf PDF
RFP Attachment 2 - Small Business Participation Information Sheet (1) (1) (2).pdf PDF
RFP Exhibit A - Price Workbook (1).xlsx XLSX spreadsheet
PWS Attachment C _Labor Category Description and Key Personnel Requirement Summary and Matrix (1) (1).docx DOCX document
RFP Attachment 3 - Reference Information Sheet (1) (1).pdf PDF
PWS Attachment A_Problem Notification Report (3) (1).pdf PDF
PWS Attachment D_Non-disclosure Agreement (2) (2).pdf PDF
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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

47QFPA22R0009 RFP Exhibit A - INSTRUCTIONS TO OFFERORS
General Instructions:
1Insert Offeror Name
2Fill out all applicable yellow highlighted cells on all tabs of this Excel workbook.
3Include all applicable prices and costs for the IDIQ contract on the Price Input Tab, including both prime and suboffer (subcontract) amounts. Task order pricing shall go on the subsequent task order tabs of the workbook.
4Ensure all formulas are functional and intact on the proposal submission.
Price Input Tab Instructions:
1Column C - If offeror nomenclature differs from Government provided labor category name, add offeror's equivalent or alternative name for each Government provided labor category. Otherwise, leave blank.
2Column D - Indicate if information in this row will be for the prime contractor or a subcontractor. Provide subcontractor name if applicable.
3Columns F, J, N, R, V - Enter a fully burdened labor rate for each labor category. If proposing subcontractor labor, a separate fully burdened labor rate may be proposed that differs from the rate proposed for prime contractor labor. Provide labor rates that are fair, reasonable, and realistic for the work to be accomplished in the PWS.
4If proposing to add indirect burdens to the Government's other direct cost or travel estimate for the IDIQ contract, provide a description of the burden type, applicable rate, and amount for each type of indirect burden in the price narrative, not in this spreadsheet.
5Enter any escalation rate used or applied to develop option year labor rates in row 54.
6Do not edit Column B labor categories, labor hours per labor category, total labor hours per year, or other direct cost amounts. These are provided for proposal consistency purposes and to help develop realistic maximum IDIQ contract amounts.
Subcontracts Tab Instructions:
1If applicable, provide detail related to subcontract pricing amounts for the IDIQ contract on the Subcontracts tab. If proposing no subcontracts, leave blank.
2Include only subcontract prices and costs that are also included on the Price Input Tab. (See General Instructions #3 Above)
3Small business subcontract amounts shall support information proposed in the Small Business Participation Information Sheet and Small Business Subcontracting Plan (if large business concern)
Contract Price Summary Tab Instructions:
1Table should fill in automatically if all data is inserted properly in the price input tab. Ensure formulas are correct and the chart accurately fills in all blanks and accurately reflects proposed prices.
Task Order 0001 and Sample Task Order A Price Tab Instructions
1Fill in applicable direct labor hours and fully burdened hourly labor rates for each labor category proposed for the task order. If a labor category is not used, leave rate and hour information blank.
2Fill in any applicable other direct costs and direct travel cost information, as well as any proposed indirect cost burdens. If proposing indirect costs, provide the name of the indirect burden, the indirect rate (%) used. No fee or profit is allowed on ODC or travel.
3Ensure totals for Labor hours, labor price, other direct costs, and overall total price are accurate.
Task Order 0001 and Sample Task Order A Backup Tab Instructions
1If ODC is proposed, include a description of each other direct cost item proposed for the task order with any applicable quantities and unit price amounts, and a total price for ODC.
2If travel costs are proposed, include a summary of any proposed travel costs to include identification of number of travelers, destination, duration, and price for airfare, car rental, subtotal cost for each trip, and total travel cost for the task order.
3If no ODC or travel is proposed, leave blank.

Price Input

Base Ordering Period ( 60 Months)
Year 1 (Jun 2022 - May 2023)Year 2 (Jun 2023 - May 2024)Year 3 (Jun 2024 - May 2025)Year 4 (Jun 2025 - May 2026)Year 5 (Jun 2026 - May 2027)Contract Total
CLIN 0001/0002 - Labor Category (LCAT) - Government SitePWS Cross Walk SectionProvide offeror's equivalent or alternate LCAT name (if different than LCAT Name in Column B, otherwise leave blank)Indicate if labor proposed is from prime or subofferor (sub) (If sub, also include name of sub)Estimated Labor HoursFully Burdened Labor RateYear 1 TotalEstimated Labor HoursFully Burdened Labor RateYear 2 TotalEstimated Labor HoursFully Burdened Labor RateYear 3 TotalEstimated Labor HoursFully Burdened Labor RateYear 4 TotalEstimated Labor HoursFully Burdened Labor RateYear 5 Total
(HIST) Behavioral Research Scientist 1 (entry)Tasks 2,3,4,510,400$0.0010,400$0.0010,400$0.0010,400$0.0010,400$0.00
(HIST) Behavioral Research Scientist 2 (Journeyman)Tasks 2,3,4,58,320$0.008,320$0.008,320$0.008,320$0.008,320$0.00
(HIST) Behavioral Research Scientist 3 (senior)Tasks 2,3,4,56,240$0.006,240$0.006,240$0.006,240$0.006,240$0.00
(HIST) Behavioral Research Scientist 4 (master)Tasks 2,3,4,54,160$0.004,160$0.004,160$0.004,160$0.004,160$0.00
(HIST) Behavioral Research Scientist 5Tasks 2,3,4,52,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(HIST) Behavioral Sciences Manager 1Tasks 1,2,3,4,52,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(HIST) Behavioral Sciences Manager 2Tasks 1,2,3,4,50$0.000$0.000$0.000$0.000$0.00
(HIST) Behavioral Sciences Manager 3Tasks 1,2,3,4,52,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
Behavioral Sciences Deputy Program ManagerTask 12,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(127G) Data Scientist 1Tasks 2,3,4,52,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(111G) Data Scientist 2Tasks 2,3,4,52,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(111G) Data Scientist 3Tasks 2,3,4,51,040$0.001,040$0.001,040$0.001,040$0.001,040$0.00
(111G) Data Scientist 4Tasks 2,3,4,51,040$0.001,040$0.001,040$0.001,040$0.001,040$0.00
(111G) Data Scientist 5Tasks 2,3,4,52,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(112G) Manager, Database AdministratorTask 52,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(112G) Data Management Analyst 1Tasks 2,3,4,52,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(112G) Data Management Analyst 2Tasks 2,3,4,52,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(112G) Data Management Analyst 3Tasks 2,3,4,52,0802,0802,0802,0802,080
(112G) Data Management Analyst 4Tasks 2,3,4,51,0401,0401,0401,0401,040
(112G) Data Management Analyst 5Tasks 2,3,4,52,0802,0802,0802,0802,080
Program Support SME 1Tasks 2,3,4,51,0401,0401,0401,0401,040
Program Support SME 2Tasks 2,3,4,51,0401,0401,0401,0401,040
Program Support SME 3Tasks 2,3,4,51,0401,0401,0401,0401,040
Program Support SME 4Tasks 2,3,4,51,040$0.001,040$0.001,040$0.001,040$0.001,040$0.00
Program Support SME 5Tasks 2,3,4,51,0401,0401,0401,0401,040
(102G) Engineer Systems/Software 4Tasks 2,3,4,52,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(128G) Project managerTasks 2,3,4,500000
(134G) Technical Editor and Writer 3Tasks 2,3,4,52,0802,0802,0802,0802,080
(102G) Manager Software Development 2Tasks 2,3,4,5
CLIN 0001/0002 - Labor Category - Offsite ( Contractor Facility)
(101G) Admin Functional Support 4Task 12,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(HIST) Program Cost, Schedule & Control Analyst 3Task 11,040$0.001,040$0.001,040$0.001,040$0.001,040$0.00
(HIST) Contracts Administrator 5Task 12,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(HIST) Subcontracts Administrator 3Task 11,040$0.001,040$0.001,040$0.001,040$0.001,040$0.00
(128G) Project managerTasks 2,3,4,50$0.000$0.000$0.000$0.000$0.00
(134G) Technical Editor and Writer 3Tasks 2,3,4,52,080$0.002,080$0.002,080$0.002,080$0.002,080$0.00
(102G) Manager Software Development 2Tasks 2,3,4,50$0.000$0.000$0.000$0.000$0.00
Total Labor Hours74,88074,88074,88074,88074,880374,400
Total Labor Price$0.00$0.00$0.00$0.00$0.00$0.00
CLIN 0003 - Total Other Direct Costs$10,000.00$11,000.00$12,100.00$13,310.00$14,641.00$61,051.00
CLIN 0004 - Travel$168,000.00$184,800.00$203,280.00$223,608.00$245,968.80$1,025,656.80

Totals Total Base Year $178,000.00 Total Year 2 $11,000.00 Total Year 3 $12,100.00 Total Year 4 $13,310.00 Total Year 5 $14,641.00 $229,051.00 Grand Total

Indicate Any Escalation (Esc.) Rate Applied to labor rates from one year to the next in this row as a percentage (example: 2.0%) Esc. rate for Year 2 Esc. rate for Year 3 Esc. rate for Year 4 Esc. rate for Year 5

Subcontracts 47QFPA22R0009 RFP Exhibit A - INSTRUCTIONS TO OFFERORS

Subcontractor NameYear 1 AmountYear 2 AmountYear 3 AmountYear 4 AmountYear 5 AmountTotal Amount
Subcontract 1Labor$0.00
Other Direct Costs/ Travel$0.00
Total Subcontract$0.00
Subcontract 2Labor$0.00
Other Direct Costs/ Travel$0.00
Total Subcontract$0.00
Subcontract 3Labor$0.00
Other Direct Costs/ Travel$0.00
Total Subcontract$0.00
(Offerors may add or subtract rows as necessary to enter all subcontract pricing information)

Task Order 0001 and Sample Task Order A Price Tab Instructions

Contract Price Summary

Contract PeriodCLINDescriptionPrice
Base Ordering Period0001FFP - Services in accordance with PWS$ - 0
0002T&M - Services in accordance with PWS$ - 0
0003Other Direct Costs$ 61,051.00
0004Travel$ 1,025,656.80
TOTAL Price for 5 years$ 1,086,707.80

TOTAL IDIQ Contract $ 1,086,707.80

Task Order 0001 Price

CLIN 0002 - Labor Category (LCAT) - Government SiteEstimated LaborLabor HoursFully Burdened Labor RatePrice
(HIST) Behavioral Research Scientist 1 (entry)6$ - 0
(HIST) Behavioral Research Scientist 2 (Journeyman)6
(HIST) Behavioral Research Scientist 3 (senior)6
(HIST) Behavioral Research Scientist 4 (master)6
(HIST) Behavioral Research Scientist 56
(HIST) Behavioral Sciences Manager 16
(HIST) Behavioral Sciences Manager 26$ - 0
(HIST) Behavioral Sciences Manager 36
Behavioral Sciences Deputy Program Manager6$ - 0
(127G) Data Scientist 16
(111G) Data Scientist 26
(111G) Data Scientist 36
(111G) Data Scientist 46
(111G) Data Scientist 56$ - 0
(112G) Manager, Database Administrator6$ - 0
(112G) Data Management Analyst 16$ - 0
(112G) Data Management Analyst 26$ - 0
(112G) Data Management Analyst 36$ - 0
(112G) Data Management Analyst 46$ - 0
(112G) Data Management Analyst 56$ - 0
Program Support SME 16$ - 0
Program Support SME 26$ - 0
Program Support SME 36$ - 0
Program Support SME 46$ - 0
Program Support SME 56$ - 0
(102G) Engineer Systems/Software 46$ - 0
(128G) Project manager6$ - 0
(134G) Technical Editor and Writer 36$ - 0
(102G) Manager Software Development 26$ - 0
CLIN 0002 - Labor Category (LCAT) - Contractor Site
(101G) Admin Functional Support 41$ - 0
(HIST) Program Cost, Schedule & Control Analyst 31$ - 0
(HIST) Contracts Administrator 51$ - 0
(HIST) Subcontracts Administrator 31$ - 0
(128G) Project manager1$ - 0
(134G) Technical Editor and Writer 31$ - 0
(102G) Manager Software Development 21$ - 0
Total Labor Hours1810
Total Labor Price (CLIN 0002)$ - 0
CLIN 0003 - Other Direct Costs (if applicable)
Name of Indirect burden (if Applicable):Rate
Total Other Direct Costs (CLIN 0003)$ - 0
CLIN 0004 - Travel (if applicable)
Name of Indirect burden (if Applicable):Rate

Total Travel (CLIN 0004) $ - 0

Total Price for Task Order $ - 0

Task Order 0001 Backup

If proposed, provide quantity and description and unit prices of any ODCs and travel related to Task Order 1 here:

Sample Task A Price

CLIN 0001or 0002 - Labor Category (LCAT) - Government SiteLabor Hrs. Govt Est.Labor Hours (Offeror)Fully Burdened Labor RatePrice
(HIST) Behavioral Research Scientist 1 (entry)6$ - 0
(HIST) Behavioral Research Scientist 2 (Journeyman)6
(HIST) Behavioral Research Scientist 3 (senior)6
(HIST) Behavioral Research Scientist 4 (master)6
(HIST) Behavioral Research Scientist 56
(HIST) Behavioral Sciences Manager 16
(HIST) Behavioral Sciences Manager 26$ - 0
(HIST) Behavioral Sciences Manager 36
Behavioral Sciences Deputy Program Manager6$ - 0
(127G) Data Scientist 16
(111G) Data Scientist 26
(111G) Data Scientist 36
(111G) Data Scientist 46
(111G) Data Scientist 56$ - 0
(112G) Manager, Database Administrator6$ - 0
(112G) Data Management Analyst 16$ - 0
(112G) Data Management Analyst 26$ - 0
(112G) Data Management Analyst 36$ - 0
(112G) Data Management Analyst 46$ - 0
(112G) Data Management Analyst 56$ - 0
Program Support SME 16$ - 0
Program Support SME 26$ - 0
Program Support SME 36$ - 0
Program Support SME 46$ - 0
Program Support SME 56$ - 0
(102G) Engineer Systems/Software 46$ - 0
(128G) Project manager6$ - 0
(134G) Technical Editor and Writer 36$ - 0
(102G) Manager Software Development 26$ - 0
CLIN 0001 or 0002 - Labor Category (LCAT) - Contractor Site
(101G) Admin Functional Support 41$ - 0
(HIST) Program Cost, Schedule & Control Analyst 31$ - 0
(HIST) Contracts Administrator 51$ - 0
(HIST) Subcontracts Administrator 31$ - 0
(128G) Project manager1$ - 0
(134G) Technical Editor and Writer 31$ - 0
(102G) Manager Software Development 21$ - 0
Total Labor Hours1810
Total Labor Price (CLIN 0001)$ - 0
Total Labor Price (CLIN 0002)$ - 0
CLIN 0003 - Other Direct Costs (if applicable)
Name of Indirect burden (if Applicable):Rate
Total Other Direct Costs (CLIN 0003)$ - 0
CLIN 0004 - Travel (if applicable)
Name of Indirect burden (if Applicable):Rate

Total Travel (CLIN 0004) $ - 0

Total Price for Task Order $ - 0

Sample Task A Backup

If proposed, provide quantity and description and unit prices of any ODCs and travel related to Sample Task A here:

Sheet1

File details come from the government source that posted it. Updated .