Attachment_J_6_Schedules_1-10_(revised).xlsx

XLSX spreadsheet 52 KB Posted Jun 15, 2016

Attached to: Transportation, Planning, Measurement, Modeling, and Assessment (TPMMA)
Solicitation number: DTRT5716R20007
Issued by: Department of Transportation Immediate Office of the Secretary Transportation

About this file

From the source

Attachment J.6 Schedules 1-10 (revised)

View the file

Other files

File	Type	Posted
Attachment_J_6_Schedules_1-10_(Revision_4).xlsx	XLSX spreadsheet	Jun 29, 2016
Amendment_A00006.pdf	PDF	Jun 29, 2016
Attachment_J_6_Schedules_1-10_(Revision_3).xlsx	XLSX spreadsheet	Jun 21, 2016
Amendment_A00005.pdf	PDF	Jun 21, 2016
Attachment_J_6_Schedules_1-10_(Revision_2).xlsx	XLSX spreadsheet	Jun 21, 2016
Amendment_A00004.pdf	PDF	Jun 21, 2016
TPMMA_Amendment_A000003.pdf	PDF	Jun 15, 2016
TPMMA_Amendment_A000002.pdf	PDF	Jun 15, 2016
DTRT5716R20006_A000001.pdf	PDF	May 26, 2016
TPMMA_Pre-Proposal_Attendees_List_5-13-16.pdf	PDF	May 16, 2016
TPMMA_Pre-Proposal_Slides_5-10-16.pdf	PDF	May 16, 2016
Revised_TPMMA_Pre-Proposal_Slides_5-10-16.pdf	PDF	May 10, 2016
TPMMA_Pre-Proposal_Slides.pdf	PDF	May 5, 2016
Attachment_J_6_Schedules_1-10.xlsx	XLSX spreadsheet	May 5, 2016
Attachment_J.11_TAR.xls	XLS spreadsheet	May 5, 2016
Attachment_J.9_TO_Invoice_Cover_Sheet.xlsx	XLSX spreadsheet	May 5, 2016
DTRT5716R20007_Solicitation.pdf	PDF	May 5, 2016

Show all 17

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	TPMMA - CPFF Task Orders
	Contract Year One (1)	$	$	$
	Total - CPFF*	$	$	$

Contract Type	Descriton	Proposed Cost	Profit	Total
Firm Fixed Price	TPMMA - FFP Task Orders	$
	Contract Year One (1)		$	$
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.6 - 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
	Year One (1)	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	$63,000	$63,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.6 - 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 One (1)	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
TRAVEL	50,000	50,000
DOCUMENTS	$13,000	$13,000
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.6 - 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	Totals
Program Manager	120
Senior Staff	1,580
Middle Staff	15,000
Junior Staff	14,000
Senior Technician
Junior Technician	2,000
Administrative Staff (Specify)
Total	32,700

B. Unburdened Labor Rates
Labor Category	Contract Year 1	Totals
Program Manager	$	$
Senior Staff	$	$
Middle Staff	$	$
Junior Staff	$	$
Senior Technician	$	$
Junior Technician	$	$
Administrative Staff (Specify)	$	$
Total		$

C. Extended Labor Cost (A times B)
Labor Category	Contract Year 1	Totals
Program Manager	$	$
Senior Staff	$	$
Middle Staff	$	$
Junior Staff	$	$
Senior Technician	$	$
Junior 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.6 - 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__

(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.6 - 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.6 - 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.6 - 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
Program Manager							120
Senior Staff							1,580
Middle Staff							15,000
Junior Staff							14,000
Senior Technician
Junior Technician							2,000
Administrative Staff (Specify)
Total							32,700

	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.56- 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 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.6 - 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.6- MASTER CONTRACT COST AND BUSINESS PROPOSAL SCHEDULES

Sheet1

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