RFP Exhibit A - Price Workbook.xlsx

XLSX spreadsheet 548 KB Posted Mar 15, 2022

Attached to: Pre-Solicitation Synopsis - Defense Personnel and Security Research Center (PERSEREC) Research Support Indefinite Delivery, Indefinite Quantity contract
Solicitation number: 47QFPA21K0005
Issued by: General Services Administration Federal Acquisition Service Assisted Acquisition Services Region 9

About this file

Written by GovTribe AI · Dec 30, 2023

This document includes a pre-solicitation synopsis and draft performance work statement for a research support indefinite delivery, indefinite quantity contract. The General Services Administration intends to issue a request for proposal on behalf of the Defense Human Resources Activity to obtain research and support services dedicated to improving security, suitability, credentialing, reliability, counter-insider threat, and risk management programs. Technical support is required in areas including security, suitability, and credentialing programs; counter-insider threat programs; and workplace risk management and mitigation. The contract would have a single award with a five-year ordering period. Interested offerors are encouraged to review beta.sam.gov where the draft solicitation and any amendments would be posted. Responses to the anticipated April 2022 solicitation release would be due 30 days thereafter. The estimated contract award date is June 1, 2022. The incumbent contractor is Northrop Grumman Systems Corporation.

View the file

Other files

File	Type	Posted
RFP Attachment 3 - Reference Information Sheet (1) (1) (1).pdf	PDF	Mar 15, 2022
RFP Attachment 4 - Task Order 1 PWS (1) (1).pdf	PDF	Mar 15, 2022
RFP 47QFPA22R0009-_Draft RFP Posting_031522.pdf	PDF	Mar 15, 2022
RFP Attachment 6 - Quality Assurance Surveillance Plan (1) (1).pdf	PDF	Mar 15, 2022
RFP Attachment 2 - Small Business Participation Information Sheet (1) (1) (1) (1).pdf	PDF	Mar 15, 2022
RFP Attachment 5 - Sample Task Order A PWS (1) (1) (1).pdf	PDF	Mar 15, 2022
PWS Attachment C _Labor Category Description and Key Personnel Requirement Summary and Matrix (1).docx	DOCX document	Mar 15, 2022
PWS Attachment D_Non-disclosure Agreement (2).pdf	PDF	Mar 15, 2022
47QFPA22R0009_D.1_PWS_031122 (1).docx	DOCX document	Mar 15, 2022
PWS Attachment E_ Travel Authorization Request (2).pdf	PDF	Mar 15, 2022
PWS Attachment F_MONTHLY QCP SURVEILLANCE SUMMARY (2).xlsx	XLSX spreadsheet	Mar 15, 2022
PWS Attachment B_Monthly Status Report (2).docx	DOCX document	Mar 15, 2022
PWS Attachment A_Problem Notification Report (2).docx	DOCX document	Mar 15, 2022

Show all 13

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:
1	Insert Offeror Name
2	Fill out all applicable yellow highlighted cells on all tabs of this Excel workbook.
3	Include 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.
4	Ensure all formulas are functional and intact on the proposal submission.

	Price Input Tab Instructions:
1	Column 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.
2	Column D - Indicate if information in this row will be for the prime contractor or a subcontractor. Provide subcontractor name if applicable.
3	Columns 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.
4	If 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.
5	Enter any escalation rate used or applied to develop option year labor rates in row 54.
6	Do 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:
1	If applicable, provide detail related to subcontract pricing amounts for the IDIQ contract on the Subcontracts tab. If proposing no subcontracts, leave blank.
2	Include only subcontract prices and costs that are also included on the Price Input Tab. (See General Instructions #3 Above)
3	Small 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:
1	Table 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
1	Fill 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.
2	Fill 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.
3	Ensure totals for Labor hours, labor price, other direct costs, and overall total price are accurate.

	Task Order 0001 and Sample Task Order A and B Backup Tab Instructions
1	If 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.
2	If 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.
3	If 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 Site	PWS Cross Walk Section	Provide 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 Hours	Fully Burdened Labor Rate	Year 1 Total	Estimated Labor Hours	Fully Burdened Labor Rate	Year 2 Total	Estimated Labor Hours	Fully Burdened Labor Rate	Year 3 Total	Estimated Labor Hours	Fully Burdened Labor Rate	Year 4 Total	Estimated Labor Hours	Fully Burdened Labor Rate	Year 5 Total
(HIST) Behavioral Research Scientist 1 (entry)	Tasks 2,3,4,5			10,400		$0.00	10,400		$0.00	10,400		$0.00	10,400		$0.00	10,400		$0.00
(HIST) Behavioral Research Scientist 2 (Journeyman)	Tasks 2,3,4,5			8,320		$0.00	8,320		$0.00	8,320		$0.00	8,320		$0.00	8,320		$0.00
(HIST) Behavioral Research Scientist 3 (senior)	Tasks 2,3,4,5			6,240		$0.00	6,240		$0.00	6,240		$0.00	6,240		$0.00	6,240		$0.00
(HIST) Behavioral Research Scientist 4 (master)	Tasks 2,3,4,5			4,160		$0.00	4,160		$0.00	4,160		$0.00	4,160		$0.00	4,160		$0.00
(HIST) Behavioral Research Scientist 5	Tasks 2,3,4,5			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(HIST) Behavioral Sciences Manager 1	Tasks 1,2,3,4,5			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(HIST) Behavioral Sciences Manager 2	Tasks 1,2,3,4,5			0		$0.00	0		$0.00	0		$0.00	0		$0.00	0		$0.00
(HIST) Behavioral Sciences Manager 3	Tasks 1,2,3,4,5			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
Behavioral Sciences Deputy Program Manager	Task 1			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(127G) Data Scientist 1	Tasks 2,3,4,5			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(111G) Data Scientist 2	Tasks 2,3,4,5			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(111G) Data Scientist 3	Tasks 2,3,4,5			1,040		$0.00	1,040		$0.00	1,040		$0.00	1,040		$0.00	1,040		$0.00
(111G) Data Scientist 4	Tasks 2,3,4,5			1,040		$0.00	1,040		$0.00	1,040		$0.00	1,040		$0.00	1,040		$0.00
(111G) Data Scientist 5	Tasks 2,3,4,5			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(112G) Manager, Database Administrator	Task 5			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(112G) Data Management Analyst 1	Tasks 2,3,4,5			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(112G) Data Management Analyst 2	Tasks 2,3,4,5			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(112G) Data Management Analyst 3	Tasks 2,3,4,5			2,080			2,080			2,080			2,080			2,080
(112G) Data Management Analyst 4	Tasks 2,3,4,5			1,040			1,040			1,040			1,040			1,040
(112G) Data Management Analyst 5	Tasks 2,3,4,5			2,080			2,080			2,080			2,080			2,080
Program Support SME 1	Tasks 2,3,4,5			1,040			1,040			1,040			1,040			1,040
Program Support SME 2	Tasks 2,3,4,5			1,040			1,040			1,040			1,040			1,040
Program Support SME 3	Tasks 2,3,4,5			1,040			1,040			1,040			1,040			1,040
Program Support SME 4	Tasks 2,3,4,5			1,040		$0.00	1,040		$0.00	1,040		$0.00	1,040		$0.00	1,040		$0.00
Program Support SME 5	Tasks 2,3,4,5			1,040			1,040			1,040			1,040			1,040
(102G) Engineer Systems/Software 4	Tasks 2,3,4,5			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(128G) Project manager	Tasks 2,3,4,5			0			0			0			0			0
(134G) Technical Editor and Writer 3	Tasks 2,3,4,5			2,080			2,080			2,080			2,080			2,080
(102G) Manager Software Development 2	Tasks 2,3,4,5
CLIN 0001/0002 - Labor Category - Offsite ( Contractor Facility)
(101G) Admin Functional Support 4	Task 1			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(HIST) Program Cost, Schedule & Control Analyst 3	Task 1			1,040		$0.00	1,040		$0.00	1,040		$0.00	1,040		$0.00	1,040		$0.00
(HIST) Contracts Administrator 5	Task 1			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(HIST) Subcontracts Administrator 3	Task 1			1,040		$0.00	1,040		$0.00	1,040		$0.00	1,040		$0.00	1,040		$0.00
(128G) Project manager	Tasks 2,3,4,5			0		$0.00	0		$0.00	0		$0.00	0		$0.00	0		$0.00
(134G) Technical Editor and Writer 3	Tasks 2,3,4,5			2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00	2,080		$0.00
(102G) Manager Software Development 2	Tasks 2,3,4,5			0		$0.00	0		$0.00	0		$0.00	0		$0.00	0		$0.00

Total Labor Hours	74,880		74,880		74,880		74,880		74,880		374,400
Total Labor Price		$0.00		$0.00		$0.00		$0.00		$0.00	$0.00

CLIN 0003 - Total Other Direct Costs	$168,000.00	$184,800.00	$203,280.00	$223,608.00	$245,968.80	$1,025,656.80
CLIN 0004 - Travel	$10,000.00	$11,000.00	$12,100.00	$13,310.00	$14,641.00	$61,051.00

Totals Total Base Year $178,000.00 Total Year 2 $184,800.00 Total Year 3 $203,280.00 Total Year 4 $223,608.00 Total Year 5 $245,968.80 $1,035,656.80 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 Name		Year 1 Amount	Year 2 Amount	Year 3 Amount	Year 4 Amount	Year 5 Amount	Total Amount
Subcontract 1		Labor						$0.00
		Other Direct Costs/ Travel						$0.00
							Total Subcontract	$0.00
Subcontract 2		Labor						$0.00
		Other Direct Costs/ Travel						$0.00
							Total Subcontract	$0.00
Subcontract 3		Labor						$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 Period	CLIN	Description	Price
Base Ordering Period	0001	FFP - Services in accordance with PWS	$ - 0
	0002	T&M - Services in accordance with PWS	$ - 0
	0003	Other Direct Costs	$ 1,025,656.80
	0004	Travel	$ 61,051.00
		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 Site	Labor Hours	Fully Burdened Labor Rate	Price
(HIST) Behavioral Research Scientist 1 (entry)			$ - 0
(HIST) Behavioral Research Scientist 2 (Journeyman)
(HIST) Behavioral Research Scientist 3 (senior)
(HIST) Behavioral Research Scientist 4 (master)
(HIST) Behavioral Research Scientist 5
(HIST) Behavioral Sciences Manager 1
(HIST) Behavioral Sciences Manager 2			$ - 0
(HIST) Behavioral Sciences Manager 3
Behavioral Sciences Deputy Program Manager			$ - 0
(127G) Data Scientist 1
(111G) Data Scientist 2
(111G) Data Scientist 3
(111G) Data Scientist 4
(111G) Data Scientist 5			$ - 0
(112G) Manager, Database Administrator			$ - 0
(112G) Data Management Analyst 1			$ - 0
(112G) Data Management Analyst 2			$ - 0
(112G) Data Management Analyst 3			$ - 0
(112G) Data Management Analyst 4			$ - 0
(112G) Data Management Analyst 5			$ - 0
Program Support SME 1			$ - 0
Program Support SME 2			$ - 0
Program Support SME 3			$ - 0
Program Support SME 4			$ - 0
Program Support SME 5			$ - 0
(102G) Engineer Systems/Software 4			$ - 0
(128G) Project manager			$ - 0
(134G) Technical Editor and Writer 3			$ - 0
(102G) Manager Software Development 2			$ - 0
CLIN 0002 - Labor Category (LCAT) - Contractor Site
(101G) Admin Functional Support 4			$ - 0
(HIST) Program Cost, Schedule & Control Analyst 3			$ - 0
(HIST) Contracts Administrator 5			$ - 0
(HIST) Subcontracts Administrator 3			$ - 0
(128G) Project manager			$ - 0
(134G) Technical Editor and Writer 3			$ - 0
(102G) Manager Software Development 2			$ - 0
Total Labor Hours	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 0002)		$ - 0
CLIN 0004 - Travel (if applicable)
Name of Indirect burden (if Applicable):	Rate

Total Travel (CLIN 0003) $ - 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 Site	Labor Hours	Fully Burdened Labor Rate	Price
(HIST) Behavioral Research Scientist 1 (entry)			$ - 0
(HIST) Behavioral Research Scientist 2 (Journeyman)
(HIST) Behavioral Research Scientist 3 (senior)
(HIST) Behavioral Research Scientist 4 (master)
(HIST) Behavioral Research Scientist 5
(HIST) Behavioral Sciences Manager 1
(HIST) Behavioral Sciences Manager 2			$ - 0
(HIST) Behavioral Sciences Manager 3
Behavioral Sciences Deputy Program Manager			$ - 0
(127G) Data Scientist 1
(111G) Data Scientist 2
(111G) Data Scientist 3
(111G) Data Scientist 4
(111G) Data Scientist 5			$ - 0
(112G) Manager, Database Administrator			$ - 0
(112G) Data Management Analyst 1			$ - 0
(112G) Data Management Analyst 2			$ - 0
(112G) Data Management Analyst 3			$ - 0
(112G) Data Management Analyst 4			$ - 0
(112G) Data Management Analyst 5			$ - 0
Program Support SME 1			$ - 0
Program Support SME 2			$ - 0
Program Support SME 3			$ - 0
Program Support SME 4			$ - 0
Program Support SME 5			$ - 0
(102G) Engineer Systems/Software 4			$ - 0
(128G) Project manager			$ - 0
(134G) Technical Editor and Writer 3			$ - 0
(102G) Manager Software Development 2			$ - 0
CLIN 0001 or 0002 - Labor Category (LCAT) - Contractor Site
(101G) Admin Functional Support 4			$ - 0
(HIST) Program Cost, Schedule & Control Analyst 3			$ - 0
(HIST) Contracts Administrator 5			$ - 0
(HIST) Subcontracts Administrator 3			$ - 0
(128G) Project manager			$ - 0
(134G) Technical Editor and Writer 3			$ - 0
(102G) Manager Software Development 2			$ - 0
Total Labor Hours	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 0002)		$ - 0
CLIN 0004 - Travel (if applicable)
Name of Indirect burden (if Applicable):	Rate

Total Travel (CLIN 0003) $ - 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 Mar 15, 2022.