RFP_Attachment_11_-_TEP_Workbook.xlsx

XLSX spreadsheet 54 KB Posted Oct 11, 2019

Attached to: Request for Proposal (RFP) Item Master Logistics Capability Initiative (IMLCI) Federal contract opportunity
Solicitation number: FA8770-20-R-0004
Issued by: Department of the Air Force Materiel Command Lifecycle Management Center Maxwell Air Force Base

About this file

Written by GovTribe AI · Dec 31, 2023

This workbook template provides instructions for vendors responding to Request for Proposal FA8770-20-R-0004 for the Item Master Logistics Capability Initiative. The template requires vendors to propose pricing for software licenses, maintenance licenses, and technical support services over a ten-year period to satisfy the Air Force's enterprise item master data management requirements. Vendors must select from one of four licensing strategies for software licenses and corresponding maintenance licenses, and provide fully burdened labor rates for technical support categories. Pricing inputs in the yellow cells will be used to calculate total evaluated price in the source selection process. Proposed license bands and labor rates in specified tabs will become contractual attachments if awarded the indefinite-delivery, indefinite-quantity contract with a first delivery order.

View the file

Other files for this federal contract opportunity

Other files attached to Request for Proposal (RFP) Item Master Logistics Capability Initiative (IMLCI), newest first.
File	Type	Posted
Questions and Answers - 5 Dec 19.pdf	PDF	Dec 5, 2019
Questions and Answers - 26 Nov 19.pdf	PDF	Nov 26, 2019
Questions and Answers - 20 Nov 19.pdf	PDF	Nov 20, 2019
Questions and Answers - 14 Nov 19.pdf	PDF	Nov 14, 2019
Questions_and_Answers_-_4_Nov_19.pdf	PDF	Nov 4, 2019
Questions_and_Answers_-_22_Oct_19.pdf	PDF	Oct 22, 2019
RFP_Attachment_04_-_Technical_Data_Package_(TDP)_Base_Document.docx	DOCX document	Oct 21, 2019
RFP_Attachment_11_-_TEP_Workbook_v.2.xlsx	XLSX spreadsheet	Oct 21, 2019
Questions_and_Answers_-_21_Oct_19.pdf	PDF	Oct 21, 2019
Questions_and_Answers_-_17_Oct_19.pdf	PDF	Oct 17, 2019
Questions_and_Answers_-_16_Oct_19.pdf	PDF	Oct 16, 2019
Questions_and_Answers_-_15_Oct_19.pdf	PDF	Oct 15, 2019
RFP_Attachment_4.F_-_ExecuteProvisioning.pdf	PDF	Oct 11, 2019
RFP_Attachment_6_-_Section_M_-_Evaluation_Factors_for_Award.pdf	PDF	Oct 11, 2019
RFP_Attachment_9_-_Quality_Assurance_Surveillance_Plan_(QASP).pdf	PDF	Oct 11, 2019
RFP_Attachment_4.L_-_Interface_Information.docx	DOCX document	Oct 11, 2019
RFP_Attachment_1_-_Statement_of_Objectives_(SOO).pdf	PDF	Oct 11, 2019
RFP_Attachment_4.H_-_Activities.xlsx	XLSX spreadsheet	Oct 11, 2019
RFP_Attachment_4.J_-_DataReferenceModel.xlsx	XLSX spreadsheet	Oct 11, 2019
RFP_Attachment_5_-_Section_L_-_Instructions,_Conditions,_and_Notices_to_Offerors_or_Respondents.pdf	PDF	Oct 11, 2019
RFP_Attachment_4.B_-_ManageItemMaster.pdf	PDF	Oct 11, 2019
RFP_Attachment_4.D_-_AssignManagementInformationToIM_ARLineItem.pdf	PDF	Oct 11, 2019
RFP_Attachment_10_-_SOO-CLIN_Matrix.xlsx	XLSX spreadsheet	Oct 11, 2019
RFP_Attachment_2_-_ITFR_Capability_Assertion_List.xlsx	XLSX spreadsheet	Oct 11, 2019
RFP_Attachment_4.K_-_TermsDefinitionsAcronyms.docx	DOCX document	Oct 11, 2019
RFP_Attachment_4.M_-_CCE_Services_Description_V4.1_MAR_2019.pdf	PDF	Oct 11, 2019
RFP_Attachment_12_-_Basic_IDIQ_Model_Contract.pdf	PDF	Oct 11, 2019
RFP_Attachment_8_-_Product_Eval_Supplement.xlsx	XLSX spreadsheet	Oct 11, 2019
RFP_Attachment_3_-_Requirements_List.xlsx	XLSX spreadsheet	Oct 11, 2019
RFP_Attachment_4.C_-_ManageItemMasterAssistanceRequest.pdf	PDF	Oct 11, 2019
RFP_Attachment_4.E_-_ManageFederalCatalogAction.pdf	PDF	Oct 11, 2019
RFP_Attachment_4.A_-_IMLCI101Brief.pptx	PPTX presentation	Oct 11, 2019
RFP_Attachment_4.I_-_InformationAssets.xlsx	XLSX spreadsheet	Oct 11, 2019
RFP_Attachment_7_-_Contract_Data_Requirements_List_(CDRL).pdf	PDF	Oct 11, 2019
RFP_Attachment_4.G_-_ProcessNames.xlsx	XLSX spreadsheet	Oct 11, 2019

Show all 35

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.

Instructions Vendors shall read all directions carefully before completing this workbook.

Any questions or workbook errors need to be communicated to the PCO as soon as possible.

Tab	Instructions
-	General Instructions
	- Tabs A, B, and C do not require direct inputs but pull data from other tabs. Only fill in information in cells shaded yellow, except where otherwise instructed (Tabs E and F)
	- License bands proposed in Tab E and Tab F shall be cumulative over the life of the IDIQ
A	TEP (Total Evaluated Price)
	- No direct inputs should be made on this tab of the workbook.
	- This Tab will populate as the Vendor completes Tabs B-G of the workbook.
	- When the workbook is complete, Figure A-1 (Tab A) will show the Vendor's Total Evaluated Price (TEP) of the effort for Source Selection evaluation purposes only
	- When the workbook is complete, Figure A-2 (Tab A) will show the Vendor's proposed price for Delivery Order 01 (DO01), which will be awarded along with the basic IDIQ
B	Software Licenses - CLIN 1000
	- No direct inputs should be made on this tab of the workbook. All information is pulled from Tab E.
	- License Type Definitions
	- Perpetual License - A type of license that authorizes the Government to use a single license indefinitely for a one-time fee
	- Annual Licenses - A type of license that authorizes the Government to use a single license for one year (12 months) for a one-time fee
	- Enterprise (Annual) Licenses - A type of license that authorizes the Government to use unlimited licenses for one year (12 months) for a one-time fee
	- Enterprise (Perpetual) Licenses - A type of license that authorizes the Government to use unlimited licenses indefinitely for a one-time fee
C	Maintenance Licenses - CLIN 2000
	- No direct inputs should be made on this tab of the workbook. All information is pulled from Tab F.
	- Maintenance Licenses need not be proposed if the proposed software licenses fully meet the Governments requirements. If no Maintenance Licenses are proposed, the vendors Technical Volume shall explicitly identify that the software license proposed fully meets the Governments requirements.
	- Maintenance Licenses proposed by the vendor shall correspond to the Software License Strategy chosen and proposed under Tab B & E.
	- License Type Definitions
	- Perpetual License - A type of license that authorizes the Government to use a single license indefinitely for a one-time fee
	- Annual Licenses - A type of license that authorizes the Government to use a single license for one year (12 months) for a one-time fee
	- Enterprise (Annual) Licenses - A type of license that authorizes the Government to use unlimited licenses for one year (12 months) for a one-time fee
	- Enterprise (Perpetual) Licenses - A type of license that authorizes the Government to use unlimited licenses indefinitely for a one-time fee

D	Technical Support Services - CLIN 3000
	- Fill in the proposed Hours and Price for each technical support service category to satisfy the Government's requirements outlined in this Request for Proposal (RFP) for Delivery Order 01 (yellow highlighed cells). Reference RFP Attachment 1, SOO, and RFP Attachment 10, SOO-CLIN Matrix.
	- The Hours and Prices for years 2-5 of the IDIQ ordering period will be populated based on the pre-determined burn down rates identified in Tab D, Row 3. These Hours and Prices are for Source Selection evaluation purposes only.
	- If the vendor selected "Core Dev" for any ITFR assertions during the Gate, the vendor shall propose the Hours and Price under "Development Support" in order to bring those assertions up to SDK Dev or OOTB
E	Software License Matrices
	- Vendors shall propose only one of four licensing strategies. Only the prices and/or bands for the licensing strategy proposed should be present in this workbook.
	- Depending on the license strategy proposed, vendors shall fill in the yellow highlighed cells for that specific Figure.
	- Prices for all years (1-10) shall be included for each proposed band.
	- Software License prices and bands will flow to the corresponding Figure in Tab B
	- The proposed licensing strategy matrices under Tab E & F will become a contractual attachment.

F	Maintenance License Matrices
	- Maintenance Licenses need not be proposed if the software licenses proposed fully meet the Governments requirements. If no Maintenance Licenses are proposed, the vendors Technical Volume shall explicitly identify that the software license proposed fully meets the Governments requirements.
	- Vendors shall propose only one of four licensing strategies. Only the prices and/or bands for the licensing strategy proposed should be present in this workbook.
	- Depending on the license strategy proposed, vendors shall fill in the yellow highlighed cells for that specific Figure.
	- Prices for all years (1-10) shall be included for each proposed band.
	- Maintenance License prices and bands will flow to the corresponding Figure in Tab C
	- The proposed licensing strategy matrices under Tab E & F will become a contractual attachment.

G	Labor Rate Matrices
	- For each technical support service category, vendors shall provide one fully burdened compositve labor rate (Rows 7-14) and one profit percentage rate per year (Row 5) in Figure G-1 (Tab G)
	- Figure G-1 will become a contractual attachment to be used for all Delivery Orders containing technical support services

Tab A - TEP Figure A-1. Total Evaluated Price (TEP)

CLIN	Description	Type	DO01	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10	Total
1000	Software Licenses	FFP
	Perpetual Software Licenses		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0						$ - 0
	Annual Software Licenses		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Enterprise (Annual) Software License		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Enterprise (Perpetual) Software License		$ - 0										$ - 0
2000	Maintenance Licenses	FFP
	Perpetual Software Licenses		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0						$ - 0
	Annual Software Licenses		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Enterprise (Annual) Software License		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Enterprise (Perpetual) Software License		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3000	Technical Support Services	Various	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0						$ - 0
4000	Travel	CR	$ 20,000	$ 20,000	$ 20,000	$ 20,000	$ 20,000						$ 100,000
5000	Other Direct Costs (ODC)	CR	$ 25,000	$ 25,000	$ 25,000	$ 25,000	$ 25,000						$ 125,000
6000	Data	NSP	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0						$ - 0
TEP			$ 45,000	$ 45,000	$ 45,000	$ 45,000	$ 45,000	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ 225,000
Figure A-2. Delivery Order 01 (DO01)

CLIN	Description	Type	PoP	DO01	Vendors shall only propose one (1) licensing strategy!
1001	Software Licenses	FFP
	Perpetual Software Licenses			$ - 0
	Annual Software Licenses			$ - 0
	Enterprise (Annual) Software License			$ - 0
	Enterprise (Perpetual) Software License			$ - 0
2001	Maintenance Licenses	FFP
	Perpetual Software Licenses			$ - 0
	Annual Software Licenses			$ - 0
	Enterprise (Annual) Software License			$ - 0
	Enterprise (Perpetual) Software License			$ - 0
3000	Technical Support Services	-
3001	Hosting Support	FFP	12 mos.	$ - 0
3002	Formal Product Training	FFP	12 mos.	$ - 0
3003	Program Support	FFP	12 mos.	$ - 0
3004	Development Support	FFP	12 mos.	$ - 0
4001	Travel	CR	12 mos.	$ 20,000
5001	Other Direct Costs (ODC)	CR	12 mos.	$ 25,000
6001	Data	NSP	12 mos.	$ - 0
Delivery Order 01 Price				$ 45,000

Tab B - CLIN 1000

- License Type Definitions	Vendors shall only propose one (1) licensing strategy!
- Perpetual License - A type of license that authorizes the Government to use a single license indefinitely for a one-time fee
- Annual Licenses - A type of license that authorizes the Government to use a single license for one year (12 months) for a one-time fee
- Enterprise (Annual) Licenses - A type of license that authorizes the Government to use unlimited licenses for one year (12 months) for a one-time fee
- Enterprise (Perpetual) Licenses - A type of license that authorizes the Government to use unlimited licenses indefinitely for a one-time fee

Figure B-1. Perpetual Software Licenses

	DO01	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10	Total
Quantity - New	130	7,900	100	11,900	100	0	0	0	0	0
Unit Price	INVALID	INVALID	INVALID	INVALID	INVALID
Total Price	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Figure B-2. Annual Software Licenses

	DO01	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10	Total
Quantity - New	130	7,900	100	11,900	100	0	0	0	0	0
Quantity - Current	0	130	8,030	8,130	20,030	20,130	20,130	20,130	20,130	20,130
Unit Price	INVALID	INVALID	INVALID	INVALID	INVALID	INVALID	INVALID	INVALID	INVALID	INVALID
Total Price	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Figure B-3. Enterprise (Annual) Software License

	DO01	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10	Total
Quantity	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited
Price	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Price	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Figure B-4. Enterprise (Perpetual) Software License

	DO01	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10	Total
Quantity	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited
Price	$ - 0
Total Price	$ - 0										$ - 0

Tab C - CLIN 2000

- License Type Definitions	Vendors shall only propose one (1) licensing strategy!
- Perpetual License - A type of license that authorizes the Government to use a single license indefinitely for a one-time fee
- Annual Licenses - A type of license that authorizes the Government to use a single license for one year (12 months) for a one-time fee
- Enterprise (Annual) Licenses - A type of license that authorizes the Government to use unlimited licenses for one year (12 months) for a one-time fee
- Enterprise (Perpetual) Licenses - A type of license that authorizes the Government to use unlimited licenses indefinitely for a one-time fee

Figure C-1. Maintenance Licenses (Perpetual Software Licenses [Figure B-1])

	DO01	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10	Total
Quantity - New	130	7,900	100	11,900	100	0	0	0	0	0
Unit Price	INVALID	INVALID	INVALID	INVALID	INVALID
Total Price	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Figure C-2. Maintenance Licenses (Annual Software Licenses [Figure B-2])

	DO01	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10	Total
Quantity - New	130	7,900	100	11,900	100	0	0	0	0	0
Quantity - Current	0	130	8,030	8,130	20,030	20,130	20,130	20,130	20,130	20,130
Unit Price	INVALID	INVALID	INVALID	INVALID	INVALID	INVALID	INVALID	INVALID	INVALID	INVALID
Total Price	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Figure C-3. Maintenance License (Enterprise (Annual) License [Figure B-3])
	5
	DO01	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10	Total
Quantity	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited
Price	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Total Price	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -

Figure C-4. Maintenance License (Enterprise (Perpetual) Software License [Figure B-4])

	DO01	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10	Total
Quantity	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited	Unlimited
Price	$ -
Total Price	$ -										$ -

Tab D - CLIN 3000

Figure D-1. Technical Support Services
Burn Down Rate		70%	40%	25%	10%
	DO01	Y2	Y3	Y4	Y5	Total
Hosting Support
Hours		-	-	-	-	-
Price		$ -	$ -	$ -	$ -	$ -

Formal Product Training
Hours	-	-	-	-	-
Price	$ -	$ -	$ -	$ -	$ -

Program Support
Hours	-	-	-	-	-
Price	$ -	$ -	$ -	$ -	$ -

Development Support
Hours	-	-	-	-	-
Price	$ -	$ -	$ -	$ -	$ -

Total Technical Support Services $ - $ - $ - $ - $ - $ -

Tab E - SW License Matrices

- License Type Definitions	Vendors shall only propose one (1) licensing strategy!
- Perpetual License - A type of license that authorizes the Government to use a single license indefinitely for a one-time fee
- Annual Licenses - A type of license that authorizes the Government to use a single license for one year (12 months) for a one-time fee
- Enterprise (Annual) Licenses - A type of license that authorizes the Government to use unlimited licenses for one year (12 months) for a one-time fee
- Enterprise (Perpetual) Licenses - A type of license that authorizes the Government to use unlimited licenses indefinitely for a one-time fee

Figure E-1. Perpetual Software Licenses (Contractual Attachment)
License Band (Cumulative)		Y1	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10
Low	High
ex. 1	ex. 2000	$ 25.00	$ 27.50	$ 30.00	$ 32.50	$ 35.00	$ 37.50	$ 40.00	$ 42.50	$ 45.00	$ 47.50
1
1
1
1
1
1
1
1
1
1
1
1
1
Figure E-2. Annual Software Licenses (Contractual Attachment)
License Band (Cumulative)		Y1	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10
Low	High
1
1
1
1
1
1
1
1
1
1
1
1
1
Figure E-3. Enterprise (Annual) Software License (Contractual Attachment)
License Band		Y1	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10
Unlimited
Figure E-4. Enterprise (Perpetual) Software License (Contractual Attachment)
License Band		Y1	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10
Unlimited

Tab F - Mx License Matrices

- License Type Definitions	Vendors shall only propose one (1) licensing strategy!
- Perpetual License - A type of license that authorizes the Government to use a single license indefinitely for a one-time fee
- Annual Licenses - A type of license that authorizes the Government to use a single license for one year (12 months) for a one-time fee
- Enterprise (Annual) Licenses - A type of license that authorizes the Government to use unlimited licenses for one year (12 months) for a one-time fee
- Enterprise (Perpetual) Licenses - A type of license that authorizes the Government to use unlimited licenses indefinitely for a one-time fee

Figure F-1. Annual Maintenance Licenses (Perpetual Software Licenses [Figure C-1]) (Contractual Attachment)
License Band (Cumulative)		Y1	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10
Low	High
ex. 1	ex. 2,000	$ 25.00	$ 27.50	$ 30.00	$ 32.50	$ 35.00	$ 37.50	$ 40.00	$ 42.50	$ 45.00	$ 47.50
1
1
1
1
1
1
1
1
1
1
1
1
1
Figure F-2. Annual Maintenance Licenses (Annual Software Licenses [Figure C-2]) (Contractual Attachment)
License Band (Cumulative)		Y1	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10
Low	High
1
1
1
1
1
1
1
1
1
1
1
1
1
Figure F-3. Enterprise (Annual) Maintenance License (Enterprise (Annual) License [Figure C-3]) (Contractual Attachment)
License Band		Y1	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10
Unlimited
Figure F-4. Annual Maintenance License (Enterprise (Perpetual) Software License [Figure C-4]) (Contractual Attachment)
License Band		Y1	Y2	Y3	Y4	Y5	Y6	Y7	Y8	Y9	Y10
Unlimited

Tab G - Labor Rate Matrices Figure G-1. Fully Burdened Composite Annual Labor Rates (Contractual Attachment)

Category	Y1		Y2		Y3		Y4		Y5
Annual Profit %
Rates	Fully Burdened Composite Rate	Fully Burdened Composite Rate + Profit	Fully Burdened Composite Rate	Fully Burdened Composite Rate + Profit	Fully Burdened Composite Rate	Fully Burdened Composite Rate + Profit	Fully Burdened Composite Rate	Fully Burdened Composite Rate + Profit	Fully Burdened Composite Rate	Fully Burdened Composite Rate + Profit
Cyber Security Support		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Hosting Support		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Product Training		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Integration and Inter-Operability Support		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Program Support		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Development Support		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Configuration Support		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
FIAR Auditability Support		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0

File details come from the government source that posted it. Updated Dec 31, 2023.