693KA9-22-R-00016 Section B Workbook.xlsx

XLSX spreadsheet 54 KB Posted Oct 26, 2023

Attached to: System of Airports Reporting (SOAR) / Request for Proposal (RFP)_Amendment 4
Solicitation number: 693KA9-22-R-00016
Issued by: Department of Transportation Federal Aviation Administration Headquarters

About this file

Written by GovTribe AI · Dec 21, 2023

This document outlines the requirements for a System of Airports Reporting (SOAR) indefinite delivery requirements contract solicitation issued by the Department of Transportation Federal Aviation Administration Headquarters. The solicitation seeks proposals for a contractor to provide all necessary services and deliver required materials and documentation to support SOAR as described in the contract line item numbers, including a one year base period of performance with three optional two-year extension periods for a total potential period of seven years. Services include program management, operations and maintenance, reporting, help desk support, security, and transforming and migrating legacy SOAR modules. Pricing is requested using both fixed price and cost plus fixed fee contract types. The total estimated ceiling price for the contract is $515,879.32 over the potential seven year period. The Section B workbook provides templates for offerors to propose pricing for the fixed price and cost reimbursable contract line items.

View the file

Other files

File	Type	Posted
SIR_693KA9-22-R-00016_Section B thru M_FinalRev_Amend 3.pdf	PDF	Nov 21, 2023
Attachment S-3_Question and Comments - Government Response.pdf	PDF	Nov 21, 2023
693KA9-22-R-00016 Section B Workbook.xlsx	XLSX spreadsheet	Nov 21, 2023
SIR_693KA9-22-R-00016_Section B thru M_FinalRev.pdf	PDF	Nov 6, 2023
SIR_693KA9-22-R-00016_Section B thru M_Final.pdf	PDF	Oct 25, 2023
Attachment S-6 BusinessDeclarationForm.pdf	PDF	Oct 25, 2023
Attachment S-8 Industry QandC.xlsx	XLSX spreadsheet	Oct 25, 2023
Attachment S-2 Example Quality Assurance Surveillance Plan.xlsx	XLSX spreadsheet	Oct 25, 2023
Attachment S-1 Section C - SOAR Statement of Objectives.pdf	PDF	Oct 25, 2023
Attachment S-5_ PP Questionairre.docx	DOCX document	Oct 25, 2023
Attachment S-7 SOO Artifacts Workbook.xlsx	XLSX spreadsheet	Oct 25, 2023
Attachment S-3_Question and Comments Form.doc	DOC document	Oct 25, 2023
Section A_SolOfferAwardSF33.pdf	PDF	Oct 25, 2023
Attachment S-4 CLIENT AUTHORIZATION LETTER.docx	DOCX document	Oct 25, 2023

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.

Instructions

The FAA has password protected cells that do not require contractor input. The cells requiring input from the Offerors are green colored.
Fixed Priced CLINs	For each FFP CLIN (X001, X002, X003, X004, X005, and X006, the Offerors must input the proposed monthly price in the Base and Option Period Tabs of the Section B Workbook.

Cost Plus Fixed Fee The Cost-Type CLINs worksheet (CPFF Detail CLINs 0007, and 1007) of the cost/price workbook is for cost detail summary information organized by CLIN. The proposed pricing for the Cost Type CLINs must match and be linked to the corresponding CLIN pricing in the Base and Option Period I Tabs. The provided Cost-Type CLIN worksheets are templates containing the required level of detail for each Cost CLIN. However, the Offeror can submit its own format if it includes the required level of detail, and it is linked to the corresponding Base and Option Periods Tabs in the Section B Workbook. The Cost/Price date must be provided in Excel format with all formulas visible and unprotected. Failure to do so could possibly result in your proposal being determined as non-responsive.

Sect. B.1 and B.2 Introduction

B.1	General
	The Contractor must provide all necessary services and deliver all required materials and documentation as described in the Contract Line Item Numbers (CLIN), the terms and conditions of the contract schedule and any supporting attachments. The base period of performance for System of Airports Reporting (SOAR) is one (1) year from contract award, with the option to exercise three (3), two (2) year option periods for a maximum performance period of seven (7) years. Offerors should refer to Section C – Statement of Objectives (SOO) and Section J – Appendices for related attachments and artifacts applicable to each CLIN. The Government may at any time before the dates set forth in Section F exercise any or all options by giving written notice to the Contractor. The Contractor must update all documentation and modify other support (e.g., training and maintenance) to reflect the most current configuration of the SOAR system when any options are exercised.
B.2	Contract Type
	This is an Indefinite Delivery Requirements contract which will utilize fixed price, cost plus fixed fee (CPFF), and cost reimbursable contract types to meet the requirements of the Performance Work Statement (PWS). This contract is not an order for supplies or services. Orders for supplies and services under this contract will be ordered by issuance of separate delivery/task orders. See Section I for ordering instructions. Delivery/task orders may consist of varying contract types such as fixed price, and cost reimbursable. All work must be performed at the Contractor work location or approved telework site with equivalent security and connectivity, with the exception of meetings requiring onsite participation.

Section B.7 and B.8 Summary

B.7	Contract Price Summary Table
	B.3 - Base Period	$ 90,985.16
	B.4 - Option Period I	$ 184,591.68
	B.5 - Option Period II	$ 115,996.42
	B.6 - Option Period III	$ 124,306.06
	Total Contract Price	$ 515,879.32

B.8	Ceiling Price	$ 515,879.32
	The ceiling price for this contract, inclusive of options, is $TBD. The Contractor is not authorized to exceed this ceiling price without the authorization of the Contracting Officer. The Federal Aviation Administration (FAA) reserves the right to exercise some, none or all options.

End Section B

Section B.3 Base Period

B.3	Contract Line Item Numbers (CLINs) Base Period 2024 - 2025
	CLIN	Description	Contract Type	Qty	Monthly Unit Price	Total Price
	Work Area 1
	0001	Transition In and Out	FFP	12	$ - 0	$ - 0
	0002	Program Management	FFP	12	$ - 0	$ - 0
	Work Area 2
	0003	Operations and Maintenance	FFP	12	$ - 0	$ - 0
	0004	Reporting	FFP	12	$ - 0	$ - 0
	0005	Help Desk	FFP	12	$ - 0	$ - 0
	0006	Security	FFP	12	$ - 0	$ - 0
	Work Area 3
	CLIN	Description	Contract Type	Total Estimated Cost	Fixed Fee	Total Estimated Cost Plus Fixed Fee (CPFF)
	0007	Transform and Migrate Legacy SOAR modules	CPFF	$ - 0	$ - 0	$ - 0
	Note see Section G for detailed CLIN description and invoicing instructions

CLIN	Description	Contract Type	Qty/Unit	Total Price
0008	Travel and Other Direct Cost (ODCs)	CR	1 lot	$90,985.16
BASE PERIOD TOTAL PRICE				$ 90,985.16

Section B.4 Option Period 1

B.4	Contract Line Item Numbers (CLINs) Option Period I 2025 - 2027
	CLIN	Description	Contract Type	Qty	Monthly Unit Price	Total Price
	Work Area 1
	1001	Transition In and Out	FFP	12	$ - 0	$ - 0
	1002	Program Management	FFP	12	$ - 0	$ - 0
	Work Area 2
	1003	Operations and Maintenance	FFP	12	$ - 0	$ - 0
	1004	Reporting	FFP	12	$ - 0	$ - 0
	1005	Help Desk	FFP	12	$ - 0	$ - 0
	1006	Security	FFP	12	$ - 0	$ - 0
	Work Area 3
	CLIN	Description	Contract Type	Total Estimated Cost	Fixed Fee	Total Estimated Cost Plus Fixed Fee (CPFF)
	1007	Transform and Migrate Legacy SOAR modules	CPFF	$ - 0	$ - 0	$ - 0
	Note see Section G for detailed CLIN description and invoicing instructions

CLIN	Description	Contract Type	Qty/Unit	Total Price
1008	Travel and Other Direct Cost (ODCs)	CR	1 lot	$ 184,591.68
OPTION PERIOD I TOTAL PRICE				$ 184,591.68

Section B.5 Option Period 2

B.5	Contract Line Item Numbers (CLINs) Option Period II 2027 - 2029
	CLIN	Description	Contract Type	Qty	Monthly Unit Price	Total Price
	Work Area 1
	2001	Transition In and Out	FFP	24	$ - 0	$ - 0
	2002	Program Management	FFP	24	$ - 0	$ - 0
	Work Area 2
	2003	Operations and Maintenance	FFP	24	$ - 0	$ - 0
	2004	Reporting	FFP	24	$ - 0	$ - 0
	2005	Help Desk	FFP	24	$ - 0	$ - 0
	2006	Security	FFP	24	$ - 0	$ - 0
	Work Area 3
	Reserved

CLIN	Description	Contract Type	Qty/Unit	Total Price
2008	Travel and Other Direct Cost (ODCs)	CR	1 lot	$ 115,996.42
OPTION PERIOD I TOTAL PRICE				$ 115,996.42

Section B.6 Option Period 3

B.6	Contract Line Item Numbers (CLINs) Option Period III 2029 - 2031
	CLIN	Description	Contract Type	Qty	Monthly Unit Price	Total Price
	Work Area 1
	3001	Transition In and Out	FFP	24	$ - 0	$ - 0
	3002	Program Management	FFP	24	$ - 0	$ - 0
	Work Area 2
	3003	Operations and Maintenance	FFP	24	$ - 0	$ - 0
	3004	Reporting	FFP	24	$ - 0	$ - 0
	3005	Help Desk	FFP	24	$ - 0	$ - 0
	3006	Security	FFP	24	$ - 0	$ - 0
	Work Area 3
	Reserved

CLIN	Description	Contract Type	Qty/Unit	Total Price
3008	Travel and Other Direct Cost (ODCs)	CR	1 lot	$ 124,306.06
OPTION PERIOD I TOTAL PRICE				$ 124,306.06

CLIN 0007 Transf. and Migrate

*Contractor may add/move rows (but not columns) based on contractor’s accounting practice or to include additional cost elements.
CLIN 0007	Insert POP Period
Direct Labor Category / Skill Level		SOAR WBS	Direct Labor Rate	Hours	Total Dollars

	$ - 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
	$ - 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 DIRECT LABOR		- 0	$ - 0

	Cost Base	Rate	Total
Fringe Benefits	$ - 0	0.00%	$ - 0
Labor Overhead	$ - 0	0.00%	$ - 0
G&A	$ - 0	0.00%	$ - 0
TOTAL INDIRECTS			$ - 0

CLIN 0007	Insert POP Period
Subcontractor Labor		SOAR WBS	Total Dollars
Subcontractor 1			$ - 0
Subcontractor 2			$ - 0
Subcontractor 3			$ - 0
Subcontractor 4			$ - 0
Subcontractor 5			$ - 0
Subcontractor 6			$ - 0
Subcontractor 7			$ - 0
Subcontractor 8			$ - 0
Subcontractor 9			$ - 0
Subcontractor 10			$ - 0
			$ - 0
TOTAL SUBCONTRACTOR LABOR			$0.00

Material Handling*	Cost Base	Rate	Indirect Cost	Total
Subcontractor Material Handling	$ - 0	0.00%	$ - 0	$ - 0
Materials	$ - 0		$ - 0	$ - 0
Subtotal				$ - 0

G&A*
G&A	$ - 0	0.00%	$ - 0	$ - 0

Subtotal Costs (Fee Base) $ - 0

				Total
FIXED FEE				$ - 0
	Cost	$0.00	$ - 0
	Fixed Fee %	0%	$ - 0

	Total
CLIN 0007	$ - 0

CLIN 1007 Transf. and Migrate

*Contractor may add/move rows (but not columns) based on contractor’s accounting practice or to include additional cost elements.
CLIN 1007	Insert POP Period
Direct Labor Category / Skill Level		SOAR WBS	Direct Labor Rate	Hours	Total Dollars

	$ - 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
	$ - 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
	$ - 0	- 0	$ - 0
TOTAL DIRECT LABOR		- 0	$0.00

	Cost Base	Rate	Total
Fringe Benefits	$ - 0	0.00%	$ - 0
Labor Overhead	$ - 0	0.00%	$ - 0
G&A	$ - 0	0.00%	$ - 0
TOTAL INDIRECTS			$ - 0

CLIN 1007	Insert POP Period
Subcontractor Labor		SOAR WBS	Total Dollars
Subcontractor 1			$ - 0
Subcontractor 2			$ - 0
Subcontractor 3			$ - 0
Subcontractor 4
Subcontractor 5
Subcontractor 6
Subcontractor 7
Subcontractor 8
Subcontractor 9
Subcontractor 10

TOTAL SUBCONTRACTOR LABOR $0.00

Material Handling*	Cost Base	Rate	Indirect Cost	Total
Subcontractor Material Handling	$ - 0	0.00%	$ - 0	$ - 0
Materials	$ - 0		$ - 0	$ - 0
Subtotal				$ - 0

G&A*
G&A	$ - 0	0.00%	$ - 0	$ - 0

Subtotal Costs (Fee Base) $ - 0

				Total
FIXED FEE				$ - 0
	Cost	$ - 0	$ - 0
	Fixed Fee %	0%	$ - 0

	Total
CLIN 1007	$ - 0

Indirect Rate (CR CLINs) Indirect Rate (Name) Base Year Option Period 1 Option Period 2 Option Period 3

File details come from the government source that posted it. Updated Oct 26, 2023.