ATEPS_SBSA_CLIN_0100_Section_J_Attachment_J.5_-_Master_Contract_Cost_and_Business_Proposal_Schedules_DRAFT.xlsx

XLSX spreadsheet 55 KB Posted Oct 2, 2015

Attached to: Air Traffic Engineering and Program Support (ATEPS) Small Business Set-Aside (SBSA)
Solicitation number: DTRT5715R20015
Issued by: Department of Transportation Immediate Office of the Secretary Transportation

About this file

From the source

DRAFT CLIN 0100 Master Contract Cost Schedules

View the file

Other files

File	Type	Posted
DTRT5716R200005_Amendment_000003.pdf	PDF	May 6, 2016
J.8_Master_Cost_and_Business_Proposal_Schedules_Amendment_2.xlsx	XLSX spreadsheet	Apr 19, 2016
DTRT5716R20005_SF33_Amendment_000002.pdf	PDF	Apr 19, 2016
DTRT5716R20005_Amendment_000002.pdf	PDF	Apr 19, 2016
J.11_Organizational_Chart_for_Transition_Amendment_2.xlsx	XLSX spreadsheet	Apr 19, 2016
Amendment_000001.pdf	PDF	Mar 29, 2016
J.13_Technical_Reference_Library_TMIS_SOW_and_Task_Order_SOWs.pdf	PDF	Mar 10, 2016
Executive_Summary_DTRT5716R20005.pdf	PDF	Mar 10, 2016
J.15_TO_0001_Cost_and_Business_Proposal_Schedules.xlsx	XLSX spreadsheet	Mar 10, 2016
J.4_DOT_Order_1630_2B.pdf	PDF	Mar 10, 2016
J.3_DD_Form_254.pdf	PDF	Mar 10, 2016
ATEPS-SBSA_DTRT5716R20005_FINAL_RFP.pdf	PDF	Mar 10, 2016
J.8_Master_Cost_and_Business_Proposal_Schedules.xlsx	XLSX spreadsheet	Mar 10, 2016
J.11_Organizational_Chart_for_Transition.xlsx	XLSX spreadsheet	Mar 10, 2016
20151218__ATEPS_SBSA_SECOND_Draft_RFP_Q A.pdf	PDF	Dec 22, 2015
20151204_ATEPS-SBSA_15R20015_Second_Draft_RFP.pdf	PDF	Dec 4, 2015
ATEPS_SBSA_DRAFT_RFP_Q A_through_16_October_2015_.pdf	PDF	Oct 29, 2015
ATEPS_SBSA_CLIN_0200_Section_J_Attachment_J.11_-_Task_Order_0001_Cost_and_Business_Proposal_Schedules_DRAFT.xlsx	XLSX spreadsheet	Oct 2, 2015
ATEPS_SBSA_CLIN_0100_Section_J_Attachment_J.11_-_Task_Order_0001_Cost_and_Business_Proposal_Schedules_DRAFT.xlsx	XLSX spreadsheet	Oct 2, 2015
ATEPS_SBSA_CLIN_0200_Section_J_Attachment_J.5_-_Master_Contract_Cost_and_Business_Proposal_Schedules_DRAFT.xlsx	XLSX spreadsheet	Oct 2, 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.9_-_TMIS_Prime_and_Subcontractor__List.xls	XLS spreadsheet	Sep 25, 2015
Attachment_J.6_-_CLIN_0100_-_Sample_Deliverables.pdf	PDF	Sep 25, 2015
Attachment_J.7_-_CLIN_0200_RIO_Process_Executive_Summary.pdf	PDF	Sep 25, 2015
ATEPS-SBSA_15R20015_Draft_RFP.pdf	PDF	Sep 25, 2015

Show all 26

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	Strategic Planning & Management Development
	Period 1	$	$	$
	Period 2	$	$	$
	Period 3	$	$	$
	Period 4	$	$	$
	Period 5	$	$	$
	Total - CPFF	$	$	$

Contract Type	Descriton	Proposed Cost	Profit	Total
Firm Fixed Price	Strategic Planning & Management Development	$
	Period 1		$	$
	Period 2		$	$
	Period 3		$	$
	Period 4		$	$
	Period 5		$	$
Total - FFP			$	$

Enter Totals from Above
Estimated Cost	$
Proposed Cost	$
Fixed Fee	$
Profit	$
Total Cost Proposal	$

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.5 - CLIN 0100 - 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
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.5 - CLIN 0100 - 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	$	$	$	$	$

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.5 - CLIN 0100 - 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
Senior Staff	$	$	$	$	$
Middle Staff	$	$	$	$	$
Staff	$	$	$	$	$
Junior Staff	$	$	$	$	$
Adminsitrative Staff (Specify)	$	$	$	$	$
Total	$	$	$	$	$

B. Unburdened Labor Rates
Labor Category	Period 1	Period 2	Period 3	Period 4	Period 5
Senior Staff	$	$	$	$	$
Middle Staff	$	$	$	$	$
Staff	$	$	$	$	$
Junior Staff	$	$	$	$	$
Administrative Staff (Specify)	$	$	$	$	$
Total	$	$	$	$	$

C. Extended Labor Cost (A times B)
Labor Category	Period 1	Period 2	Period 3	Period 4	Period 5
Senior Staff	$	$	$	$	$
Middle Staff	$	$	$	$	$
Staff	$	$	$	$	$
Junior Staff	$	$	$	$	$
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.5 - CLIN 0100 - 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 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"&10SECTION J, ATTACHMENT J.5 - CLIN 0100 - 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 2 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.15 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.

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.5 - CLIN 0100 - 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.5 - CLIN 0100 - 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
Senior Staff
Middle Staff
Staff
Junior Staff
Administrative Staff (Specify)
Total

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

&"Times New Roman,Bold"SECTION J, ATTACHMENT J.5 - CLIN 0100 - 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 Period 1 Unburdened Labor Rate (from Schedule 4)

*If the current labor rate for the person whose resume is submitted is more than 5% higher than the Schedule 4 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.5 - CLIN 0100 - 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.5 - CLIN 0100 - MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Sheet1

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