Attachment_J.8_SCOAR_Schedules_CLIN_0200.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 contains schedules and attachments related to a solicitation for communications and operations research and analysis support services. The U.S. Department of Transportation intends to issue a competitive solicitation for comprehensive technical support services including writing, graphics, web design, communications strategy development, conference planning, education support, financial administration, printing, systems analysis, industry analysis, data science and analysis, and independent technical support services including knowledge management, web design, strategic planning, business process redesign, and customer satisfaction assessment. The solicitation will result in two Indefinite Delivery/Indefinite Quantity contracts with the ability to issue firm fixed price, cost-plus-fixed-fee, cost-plus-fixed-term, and time and material/labor hour task orders over a four-year period of performance. The solicitation is set aside for small businesses certified under SBA's 8(a) Program with a size standard of $15 million. Proposals are due approximately 30 days following issuance of the final solicitation in mid-April 2019.

From the source

Attachment J.8 SCOAR Schedules CLIN 0200

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
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_2_DOT_Weighted_Guidelines_for_Profit_or_Fee_Objective.xlsx	XLSX spreadsheet	May 16, 2019
Attachment_J.7_SCOAR_Schedules_CLIN_0100_Amd_5.xlsx	XLSX spreadsheet	May 16, 2019
SCOAR_RFP_6913G619R200032_Amd_4_May_10,_2019_Final.pdf	PDF	May 10, 2019
Attachment_J.8_SCOAR_Schedules_CLIN_0200_Amd_4.xlsx	XLSX spreadsheet	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.10_TECHNICAL_REFERENCE_LIBRARY.docx	DOCX document	Apr 19, 2019
Attachment_J.7_SCOAR_Schedules_CLIN_0100.xlsx	XLSX spreadsheet	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 0200

Offeror or Subcontractor Name: ______________________________________________

CLIN	Contract Type	Description	Estimated Cost	Fixed Fee	Total
0200	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 0200 Total	$	$	$

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

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

Schedule 2

SCHEDULE 2

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

Offeror or Subcontractor Name: __________________________________________________

Element of Proposal	CLIN 0200	CLIN 0200
		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		$31,250	$125,000	$125,000	$125,000	$93,750
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.8 - COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 3

SCHEDULE 3

CALCULATION OF DIRECT LABOR COST - SCOAR CLIN 0200

Offeror or Subcontractor Name: _________________________________________________________

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

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

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

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

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

Schedule 4

SCHEDULE 4

CALCULATION OF DIRECT LABOR COST - SCOAR CLIN 0200

Offeror or Subcontractor Name: _________________________________________________________

A. Labor Hours
Labor Category	Period 1	Period 2	Period 3	Period 4	Period 5
Program Manager	470	1,880	1,880	1,880	1,410
PMO Support	470	1,880	1,880	1,880	1,410
Professional Analyst	470	1,880	1,880	1,880	1,410
Professional Specialist	235	940	940	940	705
Senior Analyst	1,175	4,700	4,700	4,700	3,525
Senior Specialist	1,292	5,170	5,170	5,170	3,878
Middle Analyst	235	940	940	940	705
Middle Specialist	705	2,820	2,820	2,820	2,115
Junior Analyst	235	940	940	940	705
Junior Specialist	235	940	940	940	705
Total	5,522	22,090	22,090	22,090	16,568
B. Unburdened Labor Rates
Labor Category	Period 1	Period 2	Period 3	Period 4	Period 5
Program 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
Program Manaager
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.8 - COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 5

SCHEDULE 5

PROPOSED INDIRECT RATES AND INDIRECT RATE CEILINGS AND ALLOCATION BASES - SCOAR CLIN 0200

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.8 - 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 0200

Offeror Name: _________________________________________________________

FIXED FEE - SCOAR CLIN 0200
	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.8 - COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 7

SCHEDULE 7

TABLE OF SUBCONTRACTORS - SCOAR CLIN 0200

Offeror or Subcontractor Name: _________________________________________________________

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

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

Schedule 8

SCHEDULE 8

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

Offeror or Subcontractor Name: _________________________________________________________

	Prime	Sub A	Sub B	Sub C	Sub D	Total	RFP Total
Program Manager							7,520
PMO Support							7,520
Professional Analyst							7,520
Professional Specialist							3,760
Senior Analyst							18,800
Senior Specialist							20,680
Middle Analyst							3,760
Middle Specialist							11,280
Junior Analyst							3,760
Junior Specialist							3,760
Total							88,360

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

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

Schedule 9

SCHEDULE 9

LABOR COST REALISM - SCOAR CLIN 0200

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.8 - COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 10

SCHEDULE 10

RESUME CHECKLIST - SCOAR CLIN 0200

Offeror or Subcontractor Name: _________________________________________________________

Labor Category	No. of Resumes	Employee Name	Prime or Subcontractor Name
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.8 - COST AND BUSINESS PROPOSAL SCHEDULES

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