Attachment_J.7_SCOAR_Schedules_CLIN_0100.xlsx

XLSX spreadsheet 81 KB Posted Apr 19, 2019

Attached to: Support for Communications and Operations Research and Analysis (SCOAR) Federal contract opportunity
Solicitation number: 6913G619R200032
Issued by: Department of Transportation Immediate Office of the Secretary Transportation

About this file

Written by GovTribe AI · Dec 31, 2023

This document includes attachments related to a federal solicitation for Support for Communications and Operations Research and Analysis (SCOAR) services. The U.S. Department of Transportation, John A. Volpe National Transportation Systems Center intends to issue a competitive solicitation for comprehensive technical support services including writing and editing, graphics, web design, communications strategy development, conference planning, education and training support, financial and administrative program support, printing and production support, system analysis, industry analysis, strategic framework development, program evaluation, engineering support, and data science and analysis. Independent technical support services in areas such as knowledge management, web design, strategic planning, business process redesign, and customer satisfaction assessment will also be required. The solicitation will result in two Indefinite Delivery/Indefinite Quantity contracts for firms certified under the Small Business Administration's 8(a) Program with a size standard of $15 million. A pre-proposal webinar will be held in April 2019 and proposals will be due approximately 30 days after issuance of the final solicitation. The period of performance for the resulting contracts will be four years.

From the source

Attachment J.7 SCOAR Schedules CLIN 0100

View the file

Other files for this federal contract opportunity

Other files attached to Support for Communications and Operations Research and Analysis (SCOAR), newest first.
File	Type	Posted
Attachment_2_DOT_Weighted_Guidelines_for_Profit_or_Fee_Objective.xlsx	XLSX spreadsheet	May 16, 2019
SCOAR_RFP_6913G619R200032_A0005_May_16,2019.pdf	PDF	May 16, 2019
Attachment_J.8_SCOAR_Schedules_CLIN_0200_Amd_5.xlsx	XLSX spreadsheet	May 16, 2019
Attachment_J.7_SCOAR_Schedules_CLIN_0100_Amd_5.xlsx	XLSX spreadsheet	May 16, 2019
Attachment_J.8_SCOAR_Schedules_CLIN_0200_Amd_4.xlsx	XLSX spreadsheet	May 10, 2019
SCOAR_RFP_6913G619R200032_Amd_4_May_10,_2019_Final.pdf	PDF	May 10, 2019
Attachment_J.7_SCOAR_Schedules_CLIN_0100_Amd_4.xlsx	XLSX spreadsheet	May 10, 2019
SCOAR_RFP_6913G619R200032_A0003_May_7,2019.pdf	PDF	May 8, 2019
SCOAR_RFP_6913G619R200032_A0002_May_3,2019.pdf	PDF	May 3, 2019
6913G619R200032_A0001.pdf	PDF	May 2, 2019
Attachment_J.8_SCOAR_Schedules_CLIN_0200.xlsx	XLSX spreadsheet	Apr 19, 2019
ATTACHMENT_J.10_TECHNICAL_REFERENCE_LIBRARY.docx	DOCX document	Apr 19, 2019
Support_for_Communications_and_Operations_Research_and_Analysis_(SCOAR)_RFP_6913G619R200032.pdf	PDF	Apr 19, 2019
Attachment_J.3_Blank_DD254.pdf	PDF	Apr 19, 2019
SCOAR_Pre_solicitation_QA_April_8.docx	DOCX document	Apr 8, 2019

Show all 15

On GovTribe

Work with this file on GovTribe

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 - SCOAR, CLIN 0100

Offeror or Subcontractor Name: ______________________________________________

CLIN	Contract Type	Description	Estimated Cost	Fixed Fee	Total
0100	Cost Plus Fixed Fee	Comprehensive Technical Support Services (from Schedule 2)
		Period 1 (10/01/2019 - 12/31/2019)	$	$	$
		Period 2 (01/01/2020 - 12/31/2020)	$	$	$
		Period 3 (01/01/2021 - 12/31/2021)	$	$	$
		Period 4 (01/01/2022 - 12/31/2022)	$	$	$
		Period 5 (01/01/2023 - 09/30/2023)	$	$	$
		CLIN 0100 Total	$	$	$

TASK ORDER 0001	Contract Type	Description	Total
CLIN 0100	Firm Fixed Price	Transition - Comprehensive Technical Support Services IAW Section C.4.2 To Meet The Minimum Guarantee	$

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

Schedule 2

SCHEDULE 2

SUMMARY OF PROPOSED COSTS AND FIXED FEE BY COST ELEMENT - SCOAR CLIN 0100

Offeror or Subcontractor Name: __________________________________________________

Element of Proposal	CLIN 0100	CLIN 0100
		Period 1	Period 2	Period 3	Period 4	Period 5
Direct Labor (from Schedule 3 & 4)		$	$	$	$	$
Fringe Benefits (if separate from overhead)		$	$	$	$	$
Government-Site Overhead*		$	$	$	$	$
Subcontracts**:
Subcontractor A		$	$	$	$	$
Subcontractor B		$	$	$	$	$
Subcontractor C		$	$	$	$	$
Subcontractor D		$	$	$	$	$
Total Subcontracts		$	$	$	$	$
Subcontract Burden (if separate)		$	$	$	$	$
Other Direct Costs:
RFP-stipulated		$250,000	$1,000,000	$1,000,000	$1,000,000	$750,000
Offeror-estimated		$	$	$	$	$
ODC Burden (if separate)		$	$	$	$	$
SUBTOTAL		$	$	$	$	$
G&A		$	$	$	$	$
TOTAL ESTIMATED COST		$	$	$	$	$
FIXED FEE (from Schedule 6)		$	$	$	$	$
Cost of Money		$	$	$	$	$
TOTAL	$	$	$	$	$	$
*Offeror shall propose using Government-site overhead only.
**Cost type subcontracts should be cost-plus-fixed-fee.

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

Schedule 3

SCHEDULE 3

CALCULATION OF DIRECT LABOR COST - SCOAR CLIN 0100

Offeror or Subcontractor Name: _________________________________________________________

A. Labor Hours
Key Personnel Position	Employee Name	Period 1	Period 2	Period 3	Period 4	Period 5

Program Manager		470	1880	1880	1880	1410
TBD (in accordance with Contractor's proposal)
	Total

B. Unburdened Labor Rates
Key Personnel Position	Employee Name	Period 1	Period 2	Period 3	Period 4	Period 5

Program Manager	$	$	$	$	$
TBD (in accordance with Contractor's proposal)	$	$	$	$	$

C. Extended Labor Cost (A times B)
Key Personnel Position	Employee Name	Period 1	Period 2	Period 3	Period 4	Period 5

Program Manager		$	$	$	$	$
TBD (in accordance with Contractor's proposal)		$	$	$	$	$
	Total	$	$	$	$	$

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

Schedule 4

SCHEDULE 4

CALCULATION OF DIRECT LABOR COST - SCOAR CLIN 0100

Offeror or Subcontractor Name: _________________________________________________________

A. Labor Hours
Labor Category	Period 1	Period 2	Period 3	Period 4	Period 5
Financial Manager	470	1,880	1,880	1,880	1,410
ORA Department Manager	118	470	470	470	353
Communications Department Manager	118	470	470	470	353
Human Resource Manager	470	1,880	1,880	1,880	1,410
Contracts Manager	470	1,880	1,880	1,880	1,410
PMO Support	1,400	5,600	5,600	5,600	4,200
Professional Analyst	7,500	30,000	30,000	30,000	22,500
Professional Specialist	5,000	20,000	20,000	20,000	15,000
Senior Analyst	10,000	40,000	40,000	40,000	30,000
Senior Specialist	10,000	40,000	40,000	40,000	30,000
Middle Analyst	8,750	35,000	35,000	35,000	26,250
Middle Specialist	7,500	30,000	30,000	30,000	22,500
Junior Analyst	10,000	40,000	40,000	40,000	30,000
Junior Specialist	6,250	25,000	25,000	25,000	18,750
Total	68,046	272,180	272,180	272,180	204,136
B. Unburdened Labor Rates
Labor Category	Period 1	Period 2	Period 3	Period 4	Period 5
Financial Manager
ORA Department Manager
Communications Department Manager
Human Resource Manager
Contracts Manager
PMO Support
Professional Analyst
Professional Specialist
Senior Analyst
Senior Specialist
Middle Analyst
Middle Specialist
Junior Analyst
Junior Specialist
C. Extended Labor Cost (A times B)
Labor Category	Period 1	Period 2	Period 3	Period 4	Period 5
Financial Manager	$	$	$	$	$
ORA Department Manager	$	$	$	$	$
Communications Department Manager	$	$	$	$	$
Human Resource Manager	$	$	$	$	$
Contracts Manager	$	$	$	$	$
PMO Support	$	$	$	$	$
Professional Analyst	$	$	$	$	$
Professional Specialist	$	$	$	$	$
Senior Analyst	$	$	$	$	$
Senior Specialist	$	$	$	$	$
Middle Analyst	$	$	$	$	$
Middle Specialist	$	$	$	$	$
Junior Analyst	$	$	$	$	$
Junior Specialist	$	$	$	$	$
Total	$	$	$	$	$

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

Schedule 5

SCHEDULE 5

PROPOSED INDIRECT RATES AND ALLOCATION BASES - SCOAR CLIN 0100

Offeror or Subcontractor Name: _________________________________________________________

Proposed Indirect Rates
Period	Contractor Fiscal Year (1)	Fringe Benefits (2)	Government-site Overhead	Contractor-site Overhead (3)	Material Handling (4)	G&A	Other (5)
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 used in proposal.

(4) If different from G&A.

(5) Specify

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

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

Schedule 6

SCHEDULE 6

ESTABLISHMENT OF MAXIMUM FACTORS FOR THE MASTER CONTRACT AND CALCULATION OF PROPOSED FIXED FEE FOR SCOAR CLIN 0100

Offeror Name: _________________________________________________________

FIXED FEE - SCOAR CLIN 0100
	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)			$

(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 contracts 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 for CLIN 0100 on Schedule 2 should be calculated based on the tables above.

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

Schedule 7

SCHEDULE 7

TABLE OF SUBCONTRACTORS - SCOAR CLIN 0100

Offeror or Subcontractor Name: _________________________________________________________

	CLIN 0100
	Type	Value
Subcontractor A
Subcontractor B
Subcontractor C
Subcontractor D
Subcontractor E

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

Schedule 8

SCHEDULE 8

ALLOCATION OF LABOR HOURS BETWEEN OFFEROR AND SUBCONTRACTORS - SCOAR CLIN 0100

Offeror or Subcontractor Name: _________________________________________________________

	Prime	Sub A	Sub B	Sub C	Sub D	Total	RFP Total
Program Manager							7,520
Financial Manager							7,520
ORA Department Manager							1,880
Communication Department Manager							1,880
Human Resource Manager							7,520
Contracts Manager							7,520
PMO Support							22,400
Professional Analyst							120,000
Professional Specialist							80,000
Senior Analyst							160,000
Senior Specialist							160,000
Middle Analyst							140,000
Middle Specialist							120,000
Junior Analyst							160,000
Junior Specialist							100,000
Total							1,096,240

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

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

Schedule 9

SCHEDULE 9

LABOR COST REALISM - SCOAR CLIN 0100

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 under CLIN 0002.

***The Transition Manager shall not be included in this table because CLIN 0001 is a firm fixed price CLIN

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

Schedule 10

SCHEDULE 10

RESUME CHECKLIST - SCOAR CLIN 0100

Offeror or Subcontractor Name: _________________________________________________________

Labor Category	No. of Resumes	Employee Name	Prime or Subcontractor Name
Program Manager	1
Transition Manager (for Task Order 0001)	1
Any additional staff regarded by the Offeror as key personnel under SCOAR CLIN 0100	As proposed by Offeror

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

File details come from the government source that posted it. Updated Dec 31, 2023.