ATEPS_Section_J_Attachment_J-7_-_Master_Contract_Cost_and_Business_Proposal_Schedules.xlsx

XLSX spreadsheet 55 KB Posted Sep 11, 2015

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 Contract Cost and Pricing Schedules

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
ATEPS_F O_Section_J_Attachment_J.8_-_Master_RFP_Cost_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
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	PMO Support
	Period 1	$	$	$
	Period 2	$	$	$
	Period 3	$	$	$
	Period 4	$	$	$
	Period 5	$	$	$
	Total - CPFF	$	$	$

Contract Type	Descriton	Proposed Cost	Profit	Total
Firm Fixed Price	PMO Support	$
	Period 1		$	$
	Period 2		$	$
	Period 3		$	$
	Period 4		$	$
	Period 5		$	$
Total - FFP			$	$
		$
	Estimated Cost	$
	Proposed Cost	$
	Fixed Fee	$
	Profit	$
	Total Cost Proposal	$

&"Times New Roman,Bold"SECTION J, ATTACHMENT J-7 - 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	Transition
		Period 1	Period 2	Period 3	Period 4	Period 5
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		$0	$0	$0	$0	$0
Offeror-estimated		$	$	$	$	$
ODC Burden (if separate)		$	$	$	$	$
SUBTOTAL		$	$	$	$	$
G&A		$	$	$	$	$
TOTAL ESTIMATED COST		$	$	$	$	$
FIXED FEE (from Schedule 6)		$	$	$	$	$
Cost of Money		$	$	$	$	$
TOTAL	$	$	$	$	$	$

*Cost type subcontracts should be cost-plus-fixed-fee.

&"Times New Roman,Bold"SECTION J, ATTACHMENT J-7 - 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
	Period 1	Period 2	Period 3	Period 4	Period 5
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	$0	$0	$0	$0	$0
Offeror-estimated	$	$	$	$	$
ODC Burden (if separate)	$	$	$	$	$
SUBTOTAL	$	$	$	$	$
G&A	$	$	$	$	$
TOTAL PROPOSED COSTS	$	$	$	$	$
PROFIT (from Schedule 6)	$	$	$	$	$
Cost of Money	$	$	$	$	$
TOTAL	$	$	$	$	$

&"-,Bold"SECTION J, ATTACHMENT J-7 - 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	Period 1	Period 2	Period 3	Period 4	Period 5
Sr. Surveillance Systems Engineer	$	$	$	$	$
Senior Staff	$	$	$	$	$
Middle Staff	$	$	$	$	$
Staff	$	$	$	$	$
Junior Staff	$	$	$	$	$
Senior Technician	$	$	$	$	$
Technician	$	$	$	$	$
Adminsitrative Staff (Specify)	$	$	$	$	$
Total	$	$	$	$	$

B. Unburdened Labor Rates
Labor Category	Period 1	Period 2	Period 3	Period 4	Period 5
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	Period 1	Period 2	Period 3	Period 4	Period 5
Sr. Surveillance Systems Engineer	$	$	$	$	$
Senior Staff	$	$	$	$	$
Middle Staff	$	$	$	$	$
Staff	$	$	$	$	$
Junior Staff	$	$	$	$	$
Senior Technician	$	$	$	$	$
Technician	$	$	$	$	$
Administrative Staff (Specify)	$	$	$	$	$
Total	$	$	$	$	$

Cost Plus Fixed Fee Labor (1) To Schedule 2 90% of Total Direct Labor $

Firm Fixed Price Labor (1) To Schedule 3 10% of Total Direct Labor $

(1) Note that subcontractor costs should be based on these percentages.

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

Schedule 5

SCHEDULE 4

PROPOSED INDIRECT RATES AND ALLOCATION BASES

Offeror or Subcontractor Name: _________________________________________________________

Proposed Indirect Rates
Contract Period	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 combine two fiscal years for the period 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-7 - 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.X 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.
(3) "Percentage" is the fee percentage the Offeror uses to develop fixed fee. These percentages will be incorporated in paragraph H.X 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.

&"-,Bold"SECTION J, ATTACHMENT J-7 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 7

SCHEDULE 7

TABLE OF SUBCONTRACTORS

Offeror or Subcontractor 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.

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

Schedule 8

SCHEDULE 8

ALLOCATION OF LABOR HOURS BETWEEN OFFEROR AND SUBCONTRACTORS

Offeror or Subcontractor 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

&"-,Bold"SECTION J, ATTACHMENT J-7 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 9

SCHEDULE 9

LABOR COST REALISM

Offeror or Subcontractor Name: _________________________________________________________

Labor Category (from Schedules 3 and 4) Resumed Person's Name Company Affiliation Actual Current Labor Rate from Payroll Records Period 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 thanthe 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-7 - 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

&"-,Bold"SECTION J, ATTACHMENT J-7 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Sheet1

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