ATEPS_F O_Section_J_Attachment_J.8_-_Master_RFP_Cost_Proposal_Schedules.xlsx

XLSX spreadsheet 56 KB Posted Feb 10, 2016

Attached to: Air Traffic Engineering and Program Support (ATEPS) Full and Open (F&O)
Solicitation number: DTRT5715R20014
Issued by: Department of Transportation Immediate Office of the Secretary Transportation

About this file

From the source

Master RFP Cost/Business Proposal Schedules Attachment J.8

View the file

Other files

File	Type	Posted
Amendment_00004.pdf	PDF	Mar 15, 2016
Amendment_00003.pdf	PDF	Mar 10, 2016
Amendment_000002.pdf	PDF	Mar 1, 2016
ATEPS_RFP_Amendment_00001.pdf	PDF	Feb 29, 2016
ATEPS_F O_Attachment_J.12_-_TO_0001_Price_Proposal_Schedules.xlsx	XLSX spreadsheet	Feb 10, 2016
DTRT5716R20004_FINAL.pdf	PDF	Feb 10, 2016
ATEPS_FO_Draft_RFP_Industry_Questions_and_Government_Responses.pdf	PDF	Oct 20, 2015
Corrected_Attachment_J.3_ATEPS_F O_Labor_Category_Descriptions.docx	DOCX document	Oct 5, 2015
ATEPS_Preliminary_Webinar_Attendance_Report_2015-09-30.xlsx	XLSX spreadsheet	Sep 30, 2015
ATEPS_Pre-Solicitation_Slides_Final.pdf	PDF	Sep 30, 2015
Attachment_J-3_ATEPS_F O_Labor_Category_Descriptions.docx	DOCX document	Sep 11, 2015
ATEPS_Section_J_Attachment_J-7_-_Master_Contract_Cost_and_Business_Proposal_Schedules.xlsx	XLSX spreadsheet	Sep 11, 2015
TMIS_NextGen_SOWs.pdf	PDF	Sep 11, 2015
ATEPS_Section_J_Atachment_J-12_-_Task_Order_0001_Cost_and_Business_Proposal_Schedules.xlsx	XLSX spreadsheet	Sep 11, 2015
Attachment_J-2_-_TMIS_Prime_and_Subcontractor__List.xls	XLS spreadsheet	Sep 11, 2015
ATEPS_15R20014_Draft_RFP.pdf	PDF	Sep 11, 2015

Show all 16

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.

Schedule 1

SCHEDULE 1

SUMMARY OF PROPOSED COSTS AND FIXED FEE

Offeror or Subcontractor Name: ______________________________________________

Contract Type	Description	Estimated Cost	Fixed Fee	Total
Cost Plus Fixed Fee	ATEPS Support - CPFF Task Orders
	Contract Year 1	$	$	$
	Contract Year 2	$	$	$
	Contract Year 3	$	$	$
	Contract Year 4	$	$	$
	Contract Year 5	$	$	$
	Total - CPFF*	$	$	$

Contract Type	Descriton	Proposed Cost	Profit	Total
Firm Fixed Price	ATEPS Support - FFP Task Orders	$
	Contract Year 1		$	$
	Contract Year 2		$	$
	Contract Year 3		$	$
	Contract Year 4		$	$
	Contract Year 5		$	$
Total - FFP**			$	$
		$
	Estimated Cost	$
	Proposed Cost	$
	Fixed Fee	$
	Profit	$
	Total Cost Proposal	$
*Totals from Schedule 2
**Totals from Schedule 3

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.8 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 2

SCHEDULE 2

SUMMARY OF PROPOSED COSTS AND FIXED FEE BY COST ELEMENT

Offeror or Subcontractor Name: __________________________________________________

Element of Proposal
	Period 1	Period 2	Period 3	Period 4	Period 5	Totals
Direct Labor (from Schedule 4 )	$	$	$	$	$	$
Fringe Benefits (if separate from overhead)	$	$	$	$	$	$
Overhead	$	$	$	$	$	$
Subcontracts:
Subcontractor A	$	$	$	$	$	$
Subcontractor B	$	$	$	$	$	$
Subcontractor C	$	$	$	$	$	$
Subcontractor D	$	$	$	$	$	$
Total Subcontracts	$	$	$	$	$	$
Subcontract Burden (if separate)	$	$	$	$	$	$
Other Direct Costs:
RFP-stipulated	$960,000	$960,000	$960,000	$960,000	$960,000	$4,800,000
Offeror-estimated *	$	$	$	$	$	$
ODC Burden (if separate)	$	$	$	$	$	$
SUBTOTAL	$	$	$	$	$	$
G&A	$	$	$	$	$	$
TOTAL ESTIMATED COST	$	$	$	$	$	$
FIXED FEE (from Schedule 6)	$	$	$	$	$	$
Cost of Money	$	$	$	$	$	$
TOTAL**	$	$	$	$	$	$

*Offerors shall provide a detailed breakout for any proposed Offeror Estimated Other Direct Costs

** The Totals for Estimated Cost and Fixed Fee must be entered in the CPFF Totals for Schedule 1

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.8 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 3

SCHEDULE 3

SUMMARY OF PROPOSED COSTS AND PROFIT BY COST ELEMENT

Offeror or Subcontractor Name: __________________________________________________

Element of Proposal
	Contract Year 1	Contract Year 2	Contract Year 3	Contract Year 4	Contract Year 5	Totals
Direct Labor (from Schedule 4 )	$	$		$	$	$
Fringe Benefits (if separate from overhead)(from Schedule 5)	$	$	$	$	$	$
Overhead (from Schedule 5)	$	$	$	$	$	$
Subcontracts:
Subcontractor A	$	$	$	$	$	$
Subcontractor B	$	$	$	$	$	$
Subcontractor C	$	$	$	$	$	$
Subcontractor D	$	$	$	$	$	$
Total Subcontracts	$	$	$	$	$	$
Subcontract Burden (if separate)	$	$	$	$	$	$
Other Direct Costs:
RFP-stipulated	$0	$0	$0	$0	$0	$0
Offeror-estimated*	$	$	$	$	$	$
ODC Burden (if separate) (from Schedule 5)	$	$	$	$	$	$
SUBTOTAL	$	$	$	$	$	$
G&A	$	$	$	$	$	$
TOTAL PROPOSED COSTS	$	$	$	$	$	$
PROFIT (from Schedule 6)	$	$	$	$	$	$
Cost of Money	$	$	$	$	$	$
TOTAL**	$	$	$	$	$	$
* Offerors shall provide a detailed breakout for any proposed Offeror Estimated Other Direct Costs
** The Totals for Estimated Cost and Profit must be entered in the FFP Totals for Schedule 1

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.8 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 4

SCHEDULE 4

CALCULATION OF DIRECT LABOR COST

Offeror or Subcontractor Name: _________________________________________________________

A. Labor Hours
Labor Category	Contract Year 1	Contract Year 2	Contract Year 3	Contract Year 4	Contract Year 5	Totals
Sr. Surveillance Systems Engineer
Senior Staff
Middle Staff
Staff
Junior Staff
Senior Technician
Technician
Administrative Staff (Specify)
Total

B. Unburdened Labor Rates
Labor Category	Contract Year 1	Contract Year 2	Contract Year 3	Contract Year 4	Contract Year 5	Totals
Sr. Surveillance Systems Engineer	$	$	$	$	$	$
Senior Staff	$	$	$	$	$	$
Middle Staff	$	$	$	$	$	$
Staff	$	$	$	$	$	$
Junior Staff	$	$	$	$	$	$
Senior Technician	$	$	$	$	$	$
Technician	$	$	$	$	$	$
Administrative Staff (Specify)	$	$	$	$	$	$
Total	$	$	$	$	$	$

C. Extended Labor Cost (A times B)
Labor Category	Contract Year 1	Contract Year 2	Contract Year 3	Contract Year 4	Contract Year 5	Totals
Sr. Surveillance Systems Engineer	$	$	$	$	$	$
Senior Staff	$	$	$	$	$	$
Middle Staff	$	$	$	$	$	$
Staff	$	$	$	$	$	$
Junior Staff	$	$	$	$	$	$
Senior Technician	$	$	$	$	$	$
Technician	$	$	$	$	$	$
Administrative Staff (Specify)	$	$	$	$	$	$
Total*	$	$	$	$	$	$

*Note: 90% of Offeror labor costs shall be entered on Schedule 2. The remaining 10% is entered on Schedule 3.

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.8 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 5

SCHEDULE 5

PROPOSED INDIRECT RATES AND ALLOCATION BASES

Offeror or Subcontractor Name: _________________________________________________________

Proposed Indirect Rates
Contract Year	Contractor Fiscal Year (1)	Fringe Benefits (2)	Overhead	Material Handling (3)	G&A	Other (4)
1	CFY__
	CFY__
2	CFY__
	CFY__
3	CFY__
	CFY__
4	CFY__
	CFY__
5	CFY__
	CFY__

(1) Offeror shall calculate a weighted average for two fiscal years for the contract year unless its fiscal year coincides with planned performance period.

(2) If separate from overhead.

(3) If different from G&A.

(4) Specify

Indirect Rate	Allocation Base
Example: Material Handling	Subcontract and equipment cost
Example: G&A	All costs except subcontract and equipment cost
Fringe Benefits
Contractor-site Overhead
Material Handling
G&A
Other

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.8 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 6

SCHEDULE 6

ESTABLISHMENT OF MAXIMUM FACTORS FOR THE MASTER CONTRACT AND CALCULATION OF PROPOSED FIXED FEE & PROFIT

Offeror Name: _________________________________________________________

FIXED FEE
	Estimated Cost	Percentage (3)	Fixed Fee Dollars
Subcontracts and Other Direct Cost from Schedule 2 (1)	$	%	$
All Other Costs from Schedule 2 (2)	$	%	$
Total	$
Total Fixed Fee Dollars (4)			$

PROFIT
	Estimated Cost	Percentage (3)	Profit Dollars
Subcontracts and Other Direct Cost from Schedule 3 (1)	$	%	$
All Other Costs from Schedule 3 (2)	$	%	$
Total	$
Total Profit Dollars (5)			$
(1) "Subcontracts and Travel Cost” should not include any Prime indirect burden.
(2) "All Other Costs" should include remaining costs from Schedule 1 except Cost of Money, if proposed.
(3) "Percentage" is the fee percentage the Offeror uses to develop fixed fee. These percentages will be incorporated in paragraph H.14 of the resulting contract and will be used to
calculate the maximum fixed fee that an Offeror may propose for subsequent task orders. Offerors may always bid less than the calculated maximum for subsequent task orders.
(4) Fixed fee Schedule 2 should be calculated based on the tables above.

Offerors shall enter the costs for the entire 5 year performance period for this schedule.

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.8 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 7

SCHEDULE 7

TABLE OF SUBCONTRACTORS

Offeror Name: _________________________________________________________

	Subcontract		Total
	Type	Value	Technical Hours
Subcontractor A
Subcontractor B
Subcontractor C
Subcontractor D
Subcontractor E
Total		*

* 90% of the total value of subcontractors goes to schedule 2 and 10% to Schedule 3.

Note: The subcontract values for Schedule 7 are for the full 5 year performance period.

Offerors must enter the subcontract value for each year of performance on Schedules 2 and 3 using the same 90/10 ratio.

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.8 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 8

SCHEDULE 8

ALLOCATION OF LABOR HOURS BETWEEN OFFEROR AND SUBCONTRACTORS

Offeror Name: _________________________________________________________

	Prime	Sub A	Sub B	Sub C	Sub D	Total	RFP Total
Sr. Surveillance Systems Engineer
Senior Staff
Middle Staff
Staff
Junior Staff
Senior Technician
Technician
Administrative Staff (Specify)
Total

	Sub A	Sub B	Sub C	Sub D
Value	$	$	$	$
Type of Subcontract

Note: Offerors shall provide this table for each year of contract performance

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.8 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 9

SCHEDULE 9

LABOR COST REALISM

Offeror or Subcontractor Name: _________________________________________________________

Labor Category (from Schedule 4) Resumed Person's Name Company Affiliation Actual Current Labor Rate from Payroll Records Contract Year 1 Unburdened Labor Rate (from Schedules 3 and 4)

*If the current labor rate for the person whose resume is submitted is more than 5% higher than the Schedule 5 labor rate for that category, explain why the proposed labor rate for the labor category is still realistic.

**The Offeror may modify the schedule to include additional rows if additional Key Personnel are proposed.

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.8 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 10

SCHEDULE 10

RESUME CHECKLIST

Offeror or Subcontractor Name: _________________________________________________________

Labor Category No. of Resumes Employee Name Prime or Subcontractor Name

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.8- MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Sheet1

File details come from the government source that posted it. Updated Nov 14, 2017.