Attachment 9 Price Tables.xlsx

XLSX spreadsheet 56 KB Posted Apr 7, 2021

Attached to: NA-15 Fourth Generation Escort Vehicle (EV4)
Solicitation number: 89233120RNA000089
Issued by: Department of Energy National Nuclear Security Administration

About this file

Written by GovTribe AI · Dec 29, 2023

This file contains a price proposal summary and small business subcontracting plan for the Fourth Generation Escort Vehicle (EV4) solicitation issued by the Department of Energy National Nuclear Security Administration.

The solicitation seeks firm-fixed-price proposals to produce unarmored and armored EV4 vehicles over five years. Pricing is provided for first article vehicles, annual production quantities, chassis sustainment, design changes, modifications, and travel costs. The small business subcontracting plan requires at least 50% of contract costs excluding materials to be performed by the prime contractor. Offerors must identify the dollar values and percentages of work awarded to team members annually.

View the file

Other files

File	Type	Posted
Sol_89233120RNA000089_Amd_0004.pdf	PDF	May 12, 2021
Sol_89233120RNA000089_Amd_0003.pdf	PDF	May 11, 2021
Attachment 15 EV4 Technical Requirements Matrix Changes (Revision 1).xlsx	XLSX spreadsheet	May 11, 2021
Attachment 15 EV4 Technical Requirements Matrix (Revision 1).xlsx	XLSX spreadsheet	May 10, 2021
Attachment 12 89233120RNA000089 QandA.pdf	PDF	May 10, 2021
Attachment 9 - Price Tables (Revision 1).xlsx	XLSX spreadsheet	May 10, 2021
Attachment 14 Estimated EV4 Milestone Schedule.pdf	PDF	May 10, 2021
Sol_89233120RNA000089_Amd_0002.pdf	PDF	May 10, 2021
Attachment 13 Deviated FAR Clauses.pdf	PDF	May 10, 2021
Attachment 11 - EV4 Letter of Intent for UCNI.docx	DOCX document	Apr 14, 2021
Sol_89233120RNA000089_Amd_0001.pdf	PDF	Apr 14, 2021
Attachment 10 Staffing Plan.xlsx	XLSX spreadsheet	Apr 7, 2021
RFP 89233120RNA000089 OST EV4.pdf	PDF	Apr 7, 2021
Attachment 8 Reporting Requirements Checklist EV4.pdf	PDF	Apr 7, 2021

Show all 14

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.

Price Proposal Summary

Offeror's Name:
Escort Vehicle 4 - Unarmored (EV4-U)
Contract Year	First Article	Production Units	Chassis / Sustainment	Design Changes	Modification Changes	Travel	Total

Proposed Price

CLIN Type		FFP	FFP	FFP	NTE/FFP	NTE/FFP	NTE/Cost
CLIN		00001	00002	00003	00004	00005	00006
Year 1		$ - 0	$ - 0	$ - 0	$ - 0	$ 20,000	$ 3,500	$ 23,500
Year 2			$ - 0	$ - 0	$ - 0	$ 20,400	$ 3,500	$ 23,900
Year 3			$ - 0	$ - 0	$ 25,000	$ 20,808	$ 3,500	$ 49,308
Year 4			$ - 0	$ - 0	$ - 0	$ 21,224	$ 3,500	$ 24,724
Year 5			$ - 0	$ - 0	$ 27,500	$ 21,648	$ 3,500	$ 52,648
Total		$ - 0	$ - 0	$ - 0	$ 52,500	$ 104,080	$ 17,500	$ 174,080
Escort Vehicle 4 - Armored (EV4-A)
Contract Year		First Article	Production Units	Chassis / Sustainment	Design Changes	Modification Changes	Travel	Total Proposed Price
CLIN Type		FFP	FFP	FFP	NTE/FFP	NTE/FFP	NTE/Cost
CLIN		00007	00008	00009	00010	00011	00012
Year 1		$ - 0	$ - 0	$ - 0	$ - 0	$ 20,000	$ 3,500	$ 23,500
Year 2			$ - 0	$ - 0	$ - 0	$ 20,400	$ 3,500	$ 23,900
Year 3			$ - 0	$ - 0	$ 35,000	$ 20,808	$ 3,500	$ 59,308
Year 4			$ - 0	$ - 0	$ - 0	$ 21,224	$ 3,500	$ 24,724
Year 5			$ - 0	$ - 0	$ 38,500	$ 21,648	$ 3,500	$ 63,648
Total		$ - 0	$ - 0	$ - 0	$ 73,500	$ 104,080	$ 17,500	$ 195,080
Price Table Instruction (applies to all worksheets in this workbook):
1.	The Price Tables shall be submitted with the Offeror's Proposal as stated in Section L of the RFP. Offeror's may compete for
	the EV4-A, the EV4-U or both EV4 models by proposing under each EV4 model's set of Contract Line Item Numbers (CLINs).
	If an Offeror chooses to only bid on one model, the worksheets/CLINs for the model not being proposed should not be completed.
	If an Offeror chooses to bid on both EV4 models, this entire workbook shall be completed.
2.	The Price Tables shall be submitted using Microsoft Excel. Do not convert to a portable document forma (PDF).
3.	All formulas and links shall remain intact and NO cells shall be protected.
4.	Offeror's are to enter all information as required in the yellow highlighted cells.
5.	Offeror's shall assume a contract start date of August 1, 2021 in accordance RFP Section B.4.
6.	Offerors are solely responsible for verifying the accuracy of all formulas, amounts, and links.

Cost Element Summary

	Year 1	Year 2	Year 3	Year 4	Year 5	Total
Labor	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Fringe	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Overhead	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Materials	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
ODC	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Equipment	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Subcontracts	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
G&A	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Profit	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Baselined	3,500	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
Total	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	$ - 0	$ - 0	$ - 0
	CLIN1	CLIN2	CLIN3	CLIN4	CLIN5	CLIN6	CLIN7	Total
Year 1	ERROR:#REF!	- 0	20,000	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	3,500	ERROR:#REF!	ERROR:#REF!
Year 2	- 0	- 0	20,400	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	3,500	ERROR:#REF!
Year 3	- 0	- 0	45,808	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	3,500	ERROR:#REF!
Year 4	- 0	- 0	21,224	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	3,500	ERROR:#REF!
Year 5	- 0	- 0	49,148	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	3,500	ERROR:#REF!
Total	ERROR:#REF!	- 0	156,580	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	17,500	ERROR:#REF!

CLIN 00001

CLIN 00001 - First Article Escort Vehicle 4 - Unarmored (EV4-U)

Please enter all information as required in the yellow highlighted cells.

Category	Year 1
Best Estimated Quantity	1
Unit Price
Extended Price	$ - 0

CLIN 00002

CLIN 00002 - Escort Vehicle 4 - Unarmored (EV4-U) Production Units

Please enter all information as required in the yellow highlighted cells.

Category	Year 1	Year 2	Year 3	Year 4	Year 5
Best Estimated Quantity	3	8	9	10	10
Unit Price
Extended Price	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

CLIN 00003

CLIN 00003 - Escort Vehicle 4 - Unarmored (EV4-U) Chassis/Sustainment

Please enter all information as required in the yellow highlighted cells.

Category	Year 1	Year 2	Year 3	Year 4	Year 5
Best Estimated Quantity	3	8	9	10	10
Unit Price
Extended Price	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

CLIN 00004

CLIN 00004 - Escort Vehicle 4 - Unarmored (EV4-U) Design Changes
	Year 1	Year 2	Year 3	Year 4	Year 5	Total
Government Baselined Amount*	$ - 0	$ - 0	$ 25,000	$ - 0	$ 27,500	$ 52,500
*Note: CLIN 00004 is a Government baselined not-to-exceed (NTE) amount. Design changes will be negotiated during contract administration based on the technical requirements of each requested change. The Contractor will provide a firm-fixed price for each requested design change in accordance with Section B.5, Ordering Procedures, of the contract.

CLIN 00005

CLIN 00005 - Escort Vehicle 4 - Unarmored (EV4-U) Modification Changes

	Year 1	Year 2	Year 3	Year 4	Year 5	Total
Government Baselined Amount*	$ 20,000	$ 20,400	$ 20,808	$ 21,224	$ 21,648	$ 104,080
*Note: CLIN 00005 is a Government baselined not-to-exceed (NTE) amount. Modifications requests will be negotiated during contract administration based on the technical requirements of each requested modification. The Contractor will provide a firm-fixed price for each requested modification in accordance with Section B.5, Ordering Procedures, of the contract.

CLIN 00006

CLIN 00006 - Travel for the Escort Vehicle 4 - Unarmored (EV4-U)

	Year 1	Year 2	Year 3	Year 4	Year 5
Government Baselined Amount*	$ 3,500	$ 3,500	$ 3,500	$ 3,500	$ 3,500
*Note: CLIN 00006 is a Government baselined NTE amount. Travel will be approved based on actual costs incurred in accordance with the Federal Travel Regulation. This CLIN is non-fee bearing and no indirect costs are allowed.

SB Performance Plan (EV4-U)

Escort Vehicle 4 - Unarmored (EV4-U) Small Business Performance Plan
In accordance with FAR 52.219-6, Notice of Total Small Business Set-Aside, this acquisition has been set-aside for small business.
As a result, in accordance with FAR 52.219-4(c), at least 50% of the costs incurred (not including material costs) shall be performed
by the prime contractor. Offeror's shall outline in the table below, by contract period, the amount (in dollars) of work being performed
by each Team Member. A Team Member includes any members of a joint venture or partnership, limited liability company or
partnership, and any subcontractor.
Note: Government baselined amounts CLINs shall not be included in this calculation since they are unknown at time of proposal.
Offeror's Performance Plan (U.S. Dollars)
Team Member	CLIN	Contract Type	Year 1		Year 2		Year 3		Year 4		Year 5		Total
			Personnel	Materials	Personnel	Materials	Personnel	Materials	Personnel	Materials	Personnel	Materials	Personnel	Materials
Prime Contractor Name (Example)	00001	Hybrid (FFP, LH)	$ 10,000	$ 3,000	$ 25,000	$ 5,000	$ 10,000	$ 1,200	$ 11,000	$ 3,000	$ 20,000	$ 8,000	$ 76,000	$ 20,200
Subcontractor 1 Name	00002		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subcontractor 2 Name			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Etc.			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL			$ 10,000	$ 3,000	$ 25,000	$ 5,000	$ 10,000	$ 1,200	$ 11,000	$ 3,000	$ 20,000	$ 8,000	$ 76,000	$ 20,200

Annual Total (Check Figure)	$ 13,000	$ 30,000	$ 11,200	$ 14,000	$ 28,000	$ 96,200
Note: The "TOTAL" row, adding personnel and materials together, should match the total price proposed for each contract period under the "Price Proposal Summary" worksheet. The "Annual Total

(Check Figure)" row has been added to validate the amount identified in this table is correct.

Offeror's Performance Plan (Percentage)
Team Member	CLIN	Contract Type	Year 1		Year 2		Year 3		Year 4		Year 5		Total
			Personnel	Materials	Personnel	Materials	Personnel	Materials	Personnel	Materials	Personnel	Materials	Personnel	Materials
Prime Contractor Name (Example)	00001	Hybrid (FFP, LH)	76.92%	23.08%	83.33%	16.67%	89.29%	10.71%	78.57%	21.43%	71.43%	28.57%	79.00%	21.00%
Subcontractor 1 Name	00002	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Subcontractor 2 Name	0	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Etc.	0	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
0	0	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
0	0	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
0	0	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
0	0	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
TOTAL			76.92%	23.08%	83.33%	16.67%	89.29%	10.71%	78.57%	21.43%	71.43%	28.57%	79.00%	21.00%

Annual Total (Check Figure) 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

CLIN 00007

CLIN 00007 - First Article Escort Vehicle 4 - Armored (EV4-A)

Please enter all information as required in the yellow highlighted cells.

Category	Year 1
Best Estimated Quantity	1
Unit Price
Extended Price	$ - 0

CLIN 00008

CLIN 00008 - Escort Vehicle 4 - Armored (EV4-A) Production Units

Please enter all information as required in the yellow highlighted cells.

Category	Year 1	Year 2	Year 3	Year 4	Year 5
Best Estimated Quantity	3	8	9	10	10
Unit Price
Extended Price	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

CLIN 00009

CLIN 00009 - Escort Vehicle 4 - Armored (EV4-A) Chassis/Sustainment

Please enter all information as required in the yellow highlighted cells.

Category	Year 1	Year 2	Year 3	Year 4	Year 5
Best Estimated Quantity	3	8	9	10	10
Unit Price
Extended Price	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

CLIN 00010

CLIN 000010 - Escort Vehicle 4 - Armored (EV4-A) Design Changes
	Year 1	Year 2	Year 3	Year 4	Year 5	Total
Government Baselined Amount*	$ - 0	$ - 0	$ 35,000	$ - 0	$ 38,500	$ 73,500
*Note: CLIN 00010 is a Government baselined not-to-exceed (NTE) amount. Design changes will be negotiated during contract administration based on the technical requirements of each requested change. The Contractor will provide a firm-fixed price for each requested design change in accordance with Section B.5, Ordering Procedures, of the contract.

CLIN 00011

CLIN 00011 - Escort Vehicle 4 - Armored (EV4-A) Modification Changes

	Year 1	Year 2	Year 3	Year 4	Year 5	Total
Government Baselined Amount*	$ 20,000	$ 20,400	$ 20,808	$ 21,224	$ 21,648	$ 104,080
*Note: CLIN 00011 is a Government baselined not-to-exceed (NTE) amount. Modifications requests will be negotiated during contract administration based on the technical requirements of each requested modification. The Contractor will provide a firm-fixed price for each requested modification in accordance with Section B.5, Ordering Procedures, of the contract.

CLIN 00012

CLIN 00012 - Travel for the Escort Vehicle 4 - Armored (EV4-A)

	Year 1	Year 2	Year 3	Year 4	Year 5
Government Baselined Amount*	$ 3,500	$ 3,500	$ 3,500	$ 3,500	$ 3,500
*Note: CLIN 00012 is a Government baselined NTE amount. Travel will be approved based on actual costs incurred in accordance with the Federal Travel Regulation. This CLIN is non-fee bearing and no indirect costs are allowed.

SB Performance Plan (EV4-A)

Escort Vehicle 4 - Armored (EV4-A) Small Business Performance Plan
In accordance with FAR 52.219-6, Notice of Total Small Business Set-Aside, this acquisition has been set-aside for small business.
As a result, in accordance with FAR 52.219-4(c), at least 50% of the costs incurred (not including material costs) shall be performed
by the prime contractor. Offeror's shall outline in the table below, by contract period, the amount (in dollars) of work being performed
by each Team Member. A Team Member includes any members of a joint venture or partnership, limited liability company or
partnership, and any subcontractor.
Note: Government baselined amounts CLINs shall not be included in this calculation since they are unknown at time of proposal.
Offeror's Performance Plan (U.S. Dollars)
Team Member	CLIN	Contract Type	Year 1		Year 2		Year 3		Year 4		Year 5		Total
			Personnel	Materials	Personnel	Materials	Personnel	Materials	Personnel	Materials	Personnel	Materials	Personnel	Materials
Prime Contractor Name (Example)	00001	Hybrid (FFP, LH)	$ 10,000	$ 3,000	$ 25,000	$ 5,000	$ 10,000	$ 1,200	$ 11,000	$ 3,000	$ 20,000	$ 8,000	$ 76,000	$ 20,200
Subcontractor 1 Name	00002		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subcontractor 2 Name			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Etc.			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL			$ 10,000	$ 3,000	$ 25,000	$ 5,000	$ 10,000	$ 1,200	$ 11,000	$ 3,000	$ 20,000	$ 8,000	$ 76,000	$ 20,200

Annual Total (Check Figure)	$ 13,000	$ 30,000	$ 11,200	$ 14,000	$ 28,000	$ 96,200
Note: The "TOTAL" row, adding personnel and materials together, should match the total price proposed for each contract period under the "Price Proposal Summary" worksheet. The "Annual Total

(Check Figure)" row has been added to validate the amount identified in this table is correct.

Offeror's Performance Plan (Percentage)
Team Member	CLIN	Contract Type	Year 1		Year 2		Year 3		Year 4		Year 5		Total
			Personnel	Materials	Personnel	Materials	Personnel	Materials	Personnel	Materials	Personnel	Materials	Personnel	Materials
Prime Contractor Name (Example)	00001	Hybrid (FFP, LH)	76.92%	23.08%	83.33%	16.67%	89.29%	10.71%	78.57%	21.43%	71.43%	28.57%	79.00%	21.00%
Subcontractor 1 Name	00002	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Subcontractor 2 Name	0	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
Etc.	0	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
0	0	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
0	0	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
0	0	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
0	0	0	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%
TOTAL			76.92%	23.08%	83.33%	16.67%	89.29%	10.71%	78.57%	21.43%	71.43%	28.57%	79.00%	21.00%

Annual Total (Check Figure) 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

File details come from the government source that posted it. Updated Apr 7, 2021.