Attachment 2 - Pricing Spreadsheet_Rev1.xlsx

XLSX spreadsheet 34 KB Posted Dec 2, 2021

Attached to: Role Player Support Services Federal contract opportunity
Solicitation number: H92240-22-Q-2000
Issued by: United States Special Operations Command

View the file

Other files for this federal contract opportunity

Other files attached to Role Player Support Services, newest first.
File	Type	Posted
Attachment 5 - WD 202103071.txt	TXT text file	Dec 22, 2021
RFQ H92240-22-Q-2000- Combined Synopsis Solicitation_Amendment0003.docx	DOCX document	Dec 14, 2021
Attachment 7 - DD Form 254.pdf	PDF	Dec 10, 2021
Questions_Answers_10Dec2021.pdf	PDF	Dec 10, 2021
Attachment 2 - Pricing Spreadsheet_Rev2.xlsx	XLSX spreadsheet	Dec 10, 2021
Questions_Answers 2Dec2021.pdf	PDF	Dec 2, 2021
Attachment 3 - Quality Assurance Surveillance Plan_Rev1.docx	DOCX document	Dec 2, 2021
(CUI) Attachment 1 - PWS - Role Player Support Services_Rev1.pdf	PDF	Dec 2, 2021
RFQ H92240-22-Q-2000- Combined Synopsis Solicitation_Amendment0001.docx	DOCX document	Dec 2, 2021
Attachment 3 - Quality Assurance Surveillance Plan.docx	DOCX document	Nov 22, 2021
Attachment 4 - NSW USSOCOM KTR Vaccine Report_Template_3 NOV 21.xlsx	XLSX spreadsheet	Nov 22, 2021
Attachment 6 - Sample FY22 Role Player TOR.docx	DOCX document	Nov 22, 2021
(CUI) Attachment 1 - PWS - Role Player Support Services.pdf	PDF	Nov 22, 2021
Attachment 2 - Pricing Spreadsheet.xlsx	XLSX spreadsheet	Nov 22, 2021
RFQ H92240-22-Q-2000- Combined Synopsis Solicitation.docx	DOCX document	Nov 22, 2021

Show all 15

On GovTribe

Work with this file on GovTribe

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.

TEP - ELIN Price Sheet

Instructions to Offerors: Please enter prices in yellow highlighted cells																Estimated Hours for Scheduled Training per PWS. Estimates equal number of Role Players x number of days x number of evolutions per year x number or hours (8) per day
Ordering Period One	January 2022 - December 2022															La Posta CA Role Players (10 RP x 5 Days x 6 Evolutions)
Ordering Period Two	January 2023 - December 2023	**APPLICABLE PRICING IS BASED ON THE DATE OF TASK ORDER ISSUANCE.														Niland Role Players (5 RP x 4 Days x 6 Evolutions)
Ordering Period Three	January 2024 - December 2024	QUANTITIES are for evaluation purposes ONLY and will be specified in individual Task Orders														SCI Role Players (10 RP x 10 Days x 6 Evolutions)
Ordering Period Four	January 2025 - December 2025	** ELINs for Travel and ODCs use the additional tabs to calculate price. Spreadsheet is linked to carry the value into this TEP sheet. Prices will be negotiated for travel on each task order as a FFP ELIN.														Fort Hunter Ligget (5 RP X 4 Days X 2 Evolutions)
Ordering Period Five	January 2026 - December 2026	** Rates should be fully burdened to include profit. Overtime rate will be 1.5x regular rate, there is no ELIN for OT rate														SD Role Players (8 RP x 6 Days x 6 evolutions)
																Camp Pendleton (5RP X 4 days X 2 Evolutions)
																Seal Beach (5RP X 4 days X 2 evolutions)
CLIN	Description	Estimated Training Hours	Hourly Rate for Ordering Period 1	Total Period 1	Estimated Training Hours	Hourly Rate for Ordering Period 2	Total Period 2	Estimated Training Hours	Hourly Rate for Ordering Period 3	Total Period 3	Estimated Training Hours	Hourly Rate for Ordering Period 4	Total Period 4	Estimated Training Hours	Hourly Rate for Ordering Period 5	Total Period 5	Total Price per CLIN to include all ELINs and Ordering periods
0001	Role Players And Support - La Posta California
A001	Role Player Support- Category I	1200		$ - 0	1200		$ - 0	1200		$ - 0	1200		$ - 0	1200		$ - 0
A002	Role Player Support- Category II	0		$ - 0	0		$ - 0	0		$ - 0	0		$ - 0	0		$ - 0
A003	Role Player Support- Category III	240		$ - 0	240		$ - 0	240		$ - 0	240		$ - 0	240		$ - 0
A004	Role Player Support- Category IV	0		$ - 0	0		$ - 0	0		$ - 0	0		$ - 0	0		$ - 0
A005	Role Player Support- Category V	240		$ - 0	240		$ - 0	240		$ - 0	240		$ - 0	240		$ - 0
A006	Role Player Support- Category VI	240		$ - 0	240		$ - 0	240		$ - 0	240		$ - 0	240		$ - 0
A007	Role Player Support- Category VII	240		$ - 0	240		$ - 0	240		$ - 0	240		$ - 0	240		$ - 0
A008	Role Player Support- Category VIII	24		$ - 0	24		$ - 0	24		$ - 0	24		$ - 0	24		$ - 0
A009	Role Player Support- Category IX	240		$ - 0	240		$ - 0	240		$ - 0	240		$ - 0	240		$ - 0
A010	Travel to La Posta CA	Price is linked to Travel sheet		$ - 0
A011	ODCs for La Posta CA	Price is linked to ODC sheet		$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
	Total for CLIN 0001			$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0

0002	Role Players And Support - Niland, California
B001	Role Player Support- Category I		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
B002	Role Player Support- Category II	384	$ - 0	384	$ - 0	384	$ - 0	384	$ - 0	384	$ - 0
B003	Role Player Support- Category III		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
B004	Role Player Support- Category IV	192	$ - 0	192	$ - 0	192	$ - 0	192	$ - 0	192	$ - 0
B005	Role Player Support- Category V		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
B006	Role Player Support- Category VI		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
B007	Role Player Support- Category VII	192	$ - 0	192	$ - 0	192	$ - 0	192	$ - 0	192	$ - 0
B008	Role Player Support- Category VIII		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
B009	Role Player Support- Category IX	192	$ - 0	192	$ - 0	192	$ - 0	192	$ - 0	192	$ - 0
B010	Travel to NIland CA	Price is linked to Travel sheet	$ - 0
B011	ODCs for Niland CA	Price is linked to ODC sheet	$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
	Total for CLIN 0002		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0

0003	Role Players And Support - San Clemente Island
C001	Role Player Support- Category I	3360	$ - 0	3360	$ - 0	3360	$ - 0	3360	$ - 0	3360	$ - 0
C002	Role Player Support- Category II		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
C003	Role Player Support- Category III	480	$ - 0	480	$ - 0	480	$ - 0	480	$ - 0	480	$ - 0
C004	Role Player Support- Category IV		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
C005	Role Player Support- Category V		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
C006	Role Player Support- Category VI	480	$ - 0	480	$ - 0	480	$ - 0	480	$ - 0	480	$ - 0
C007	Role Player Support- Category VII		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
C008	Role Player Support- Category VIII		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
C009	Role Player Support- Category IX	480	$ - 0	480	$ - 0	480	$ - 0	480	$ - 0	480	$ - 0
C010	Travel to San Clemente Island	Price is linked to Travel sheet	$ - 0
C011	ODCs for San Clemente Island	Price is linked to ODC sheet	$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
	Total for CLIN 0003		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0

0004	Role Players And Support - Fort Hunter Ligget, CA
D001	Role Player Support- Category I	256	$ - 0	256	$ - 0	256	$ - 0	256	$ - 0	256	$ - 0
D002	Role Player Support- Category II		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
D003	Role Player Support- Category III		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
D004	Role Player Support- Category IV		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
D005	Role Player Support- Category V		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
D006	Role Player Support- Category VI		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
D007	Role Player Support- Category VII		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
D008	Role Player Support- Category VIII		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
D009	Role Player Support- Category IX	64	$ - 0	64	$ - 0	64	$ - 0	64	$ - 0	64	$ - 0
D010	Travel to Fort Hunter Ligget, CA	Price is linked to Travel sheet	$ - 0
D011	ODCs for Fort Hunter Ligget, CA	Price is linked to ODC sheet	$ - 0
	Total for CLIN 0004		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0

0005	Role Players And Support - San Diego, CA
E001	Role Player Support- Category I	1440	$ - 0	1440	$ - 0	1440	$ - 0	1440	$ - 0	1440	$ - 0
E002	Role Player Support- Category II		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
E003	Role Player Support- Category III		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
E004	Role Player Support- Category IV		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
E005	Role Player Support- Category V		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
E006	Role Player Support- Category VI	288	$ - 0	288	$ - 0	288	$ - 0	288	$ - 0	288	$ - 0
E007	Role Player Support- Category VII	288	$ - 0	288	$ - 0	288	$ - 0	288	$ - 0	288	$ - 0
E008	Role Player Support- Category VIII		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
E009	Role Player Support- Category IX	288	$ - 0	288	$ - 0	288	$ - 0	288	$ - 0	288	$ - 0
E010	Travel to San Diego, CA	Price is linked to Travel sheet	$ - 0
E011	ODCs for San Diego, CA	Price is linked to ODC sheet	$ - 0
	Total for CLIN 0005		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0

0006	Role Players And Support - Camp Pendleton, CA
F001	Role Player Support- Category I	192	$ - 0	192	$ - 0	192	$ - 0	192	$ - 0	192	$ - 0
F002	Role Player Support- Category II		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
F003	Role Player Support- Category III		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
F004	Role Player Support- Category IV		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
F005	Role Player Support- Category V		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
F006	Role Player Support- Category VI		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
F007	Role Player Support- Category VII	64	$ - 0	64	$ - 0	64	$ - 0	64	$ - 0	64	$ - 0
F008	Role Player Support- Category VIII	24	$ - 0	24	$ - 0	24	$ - 0	24	$ - 0	24	$ - 0
F009	Role Player Support- Category IX	64	$ - 0	64	$ - 0	64	$ - 0	64	$ - 0	64	$ - 0
F010	Travel to Camp Pendleton, CA	Price is linked to Travel sheet	$ - 0
F011	ODCs for Camp Pendleton, CA	Price is linked to ODC sheet	$ - 0
	Total for CLIN 0006		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0

0007	Role Players And Support - Seal Beach, CA
G001	Role Player Support- Category I	256	$ - 0	256	$ - 0	256	$ - 0	256	$ - 0	256	$ - 0
G002	Role Player Support- Category II		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
G003	Role Player Support- Category III		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
G004	Role Player Support- Category IV		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
G005	Role Player Support- Category V		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
G006	Role Player Support- Category VI		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
G007	Role Player Support- Category VII		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
G008	Role Player Support- Category VIII		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
G009	Role Player Support- Category IX	64	$ - 0	64	$ - 0	64	$ - 0	64	$ - 0	64	$ - 0
G010	Travel to Seal Beach, CA	Price is linked to Travel sheet	$ - 0
G011	ODCs for Seal Beach, CA	Price is linked to ODC sheet	$ - 0
	Total for CLIN 0006		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0

TOTAL Evaluated Price $ - 0

Travel Expense detail

TRAVEL ELIN Expense Detail:				Travel will be negotiated for each task order on a firm fixed price basis.
				Number of Role players and number of days are only for calculation of Total Evaluated Price.
				Offeror to provide explanation of calculation for equation/rate used in box below titled, 'Travel Explanation'
				For purposes of evaluation, the TEP will only include travel estimation for Ordering Period 1.
ELIN	Description	Rate	Days	Ordering Period 1
A010	Travel to La Posta CA, calculate for 5 days of training for 10 personnel				Travel Explanation
	Air Expense			$ - 0
	Hotel			$ - 0
	Rental Car			$ - 0
	MI&E			$ - 0
	Other expenses			$ - 0
	Total Travel Price for A010			$ - 0

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

This cell is linked to TEP Tab.

B010	Travel to Niland CA, calculate for 5 days of training for 5 personnel
	Air Expense	$ - 0
	Hotel	$ - 0
	Rental Car	$ - 0
	MI&E	$ - 0
	Other expenses	$ - 0
	Total Travel Price for B010	$ - 0

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

This cell is linked to TEP Tab.

C010	Travel to San Clemente Island, calculate for 10 days of training for 10 personnel
	Air Expense	$ - 0
	Hotel	$ - 0
	Rental Car	$ - 0
	MI&E	$ - 0
	Other expenses	$ - 0
	Total Travel Price for C010	$ - 0

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

This cell is linked to TEP Tab.

D010	Travel to Fort Hunter Ligget, CA, calculate 5 10 days of training for 4 personnel
	Air Expense	$ - 0
	Hotel	$ - 0
	Rental Car	$ - 0
	MI&E	$ - 0
	Other expenses	$ - 0
	Total Travel Price for D010	$ - 0

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

This cell is linked to TEP Tab.

E010	Travel to San Diego CA, calculate for 6 days of training for 8 personnel
	Air Expense	$ - 0
	Hotel	$ - 0
	Rental Car	$ - 0
	MI&E	$ - 0
	Other expenses	$ - 0
	Total Travel Price for E010	$ - 0

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

This cell is linked to TEP Tab.

F010	Travel to Camp Pendleton CA, calculate for 4 days of training for 5 personnel
	Air Expense	$ - 0
	Hotel	$ - 0
	Rental Car	$ - 0
	MI&E	$ - 0
	Other expenses	$ - 0
	Total Travel Price for F010	$ - 0

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

This cell is linked to TEP Tab.

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

This cell is linked to TEP Tab.

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

This cell is linked to TEP Tab.	G010	Travel to Seal Beach CA, calculate for 4 days of training for 5 personnel
		Air Expense	$ - 0
		Hotel	$ - 0
		Rental Car	$ - 0
		MI&E	$ - 0
		Other expenses	$ - 0
		Total Travel Price for G010	$ - 0

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

This cell is linked to TEP Tab.

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

This cell is linked to TEP Tab.

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

This cell is linked to TEP Tab.

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

This cell is linked to TEP Tab.

ODCs Detail

Prices for ODC items will be the same across locations, therefore, prices only need to reflect the 5 ordering periods.

The spreadsheet is set up to link the total ODC ELIN price to each ELIN in the TEP Tab.

Quantities required will be identified in each Task order. The below quantities or only for evaluation of TEP.

ODC ELIN		Ordering Period 1			Ordering Period 2			Ordering Period 3			Ordering Period 4			Ordering Period 5
	Description	Est Quantity	Price	Total	Quantity	Price	Total	Quantity	Price	Total	Quantity	Price	Total	Quantity	Price	Total
	Bump Helmet	10		$ - 0	10		$ - 0	10		$ - 0	10		$ - 0	10		$ - 0
	Gloves	10		$ - 0	10		$ - 0	10		$ - 0	10		$ - 0	10		$ - 0
	Throat Guard	10		$ - 0	10		$ - 0	10		$ - 0	10		$ - 0	10		$ - 0
	Groin Guard	10		$ - 0	10		$ - 0	10		$ - 0	10		$ - 0	10		$ - 0
	Pyrotechnics Package (6 IED, 6 RPG, 6 IDF, Smoke Effects)	3		$ - 0	3		$ - 0	3		$ - 0	3		$ - 0	3		$ - 0
	Moulage Supplies (package to provide makeup for 1 person)	10		$ - 0	10		$ - 0	10		$ - 0	10		$ - 0	10		$ - 0
				$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
		ELIN TOTAL		$ - 0

Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

ELIN Total is linked to TEP Tab. ELIN TOTAL $ - 0 Simpson, Stephanie E CIV USSOCOM NSW (USA): Simpson, Stephanie E CIV USSOCOM NSW (USA):

ELIN Total is linked to TEP Tab.

File details come from the government source that posted it. Updated Dec 2, 2021.