Attachment J.6 MITS Schedules Amendment 3.xlsx

XLSX spreadsheet 92 KB Posted Apr 11, 2021

Attached to: Mission Information Technology Support Services (MITS)
Solicitation number: 6913G621R200004
Issued by: Department of Transportation Immediate Office of the Secretary Transportation

About this file

Written by GovTribe AI · Dec 31, 2023

This document package includes cost proposal schedules and templates for a federal solicitation seeking Mission Information Technology Support Services. The solicitation is being conducted by the Department of Transportation on behalf of the John A. Volpe National Transportation Systems Center located in Cambridge, Massachusetts. The requirement includes technology assessments and modernization, systems analysis and development, architecture and framework support, lab facility operations support, and management services. Offerors must submit cost proposals using the provided templates, which require detailing direct labor costs by category and period, indirect rates, fee percentages, subcontractor information, and resumes of key personnel. The period of performance is five years consisting of four 12-month base periods and one 12-month option period.

View the file

Other files

File	Type	Posted
Amendment 0004 6913G621R200004.pdf	PDF	Apr 16, 2021
Amendment 0003 6913G621R200004.pdf	PDF	Apr 11, 2021
Amendment 0002 6913G621R200004.pdf	PDF	Apr 2, 2021
Attachment J.6 MITS Schedules Amendment 2.xlsx	XLSX spreadsheet	Apr 2, 2021
Amendment 0001 MITS Pre-Proposal Webinar Slides.pdf	PDF	Mar 19, 2021
Amendment 0001 6913G621R200004.pdf	PDF	Mar 19, 2021
Amendment 0001 MITS Pre-Proposal Webinar Attendance List.pdf	PDF	Mar 19, 2021
Attachment J.6 MITS Schedules.xlsx	XLSX spreadsheet	Feb 25, 2021
Attachment J.8 SCA Wage Determination 2015-4047.pdf	PDF	Feb 25, 2021
6913G621R200004 MITS Solicitation.pdf	PDF	Feb 25, 2021

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 - MITS

Offeror or Subcontractor Name: ______________________________________________

CLIN	Contract Type	Description	Estimated Cost	Fixed Fee	Total
00100	Cost Plus Fixed Fee	Mission Information Technology Support Services (from Schedule 2)
		Period 1 (10/01/2021 - 09/30/2022)	$	$	$
		Period 2 (10/01/2022 - 09/30/2023)	$	$	$
		Period 3 (10/01/2023 - 09/30/2024)	$	$	$
		Period 4 (10/01/2024 - 09/30/2025)	$	$	$

		Total CPFF	$	$	$
00100	Time & Materials and Labor Hour	Mission Information Technology Support Services (from Schedules 4 and 5)
		Period 1 (10/01/2021 - 09/30/2022)			$
		Period 2 (10/01/2022 - 09/30/2023)			$
		Period 3 (10/01/2023 - 09/30/2024)			$
		Period 4 (10/01/2024 - 09/30/2025)			$

Total T&M/LH $

00100 - TOTAL COMBINED CPFF AND T&M/LH (Sum of cells F13 and F20) $

TRANSITION TASK ORDER	Contract Type	Description	Total
CLIN 0100	Firm Fixed Price	Transition - Mission Information Technology Support Services IAW Section C.4.1 To Meet The Minimum Guarantee	$

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

Schedule 2

SCHEDULE 2

SUMMARY OF PROPOSED COSTS AND FIXED FEE BY COST ELEMENT - MITS

Offeror or Subcontractor Name: __________________________________________________

Element of Proposal	CLIN 0100	CLIN 0100
		Period 1	Period 2	Period 3	Period 4
CPFF Direct Labor (from Schedule 3)		$	$	$	$
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		$100,000	$100,000	$100,000	$100,000
Offeror-estimated		$	$	$	$
ODC Burden (if separate)		$	$	$	$
SUBTOTAL		$	$	$	$
G&A		$	$	$	$
TOTAL ESTIMATED COST		$	$	$	$
FIXED FEE (from Schedule 7)		$	$	$	$
Cost of Money		$	$	$	$
T&M/LH Direct Labor (from Schedule 4)
TOTAL	$	$	$	$	$
*Offeror shall propose using Government-site overhead only.
**Cost type subcontracts should be cost-plus-fixed-fee. Time and Material subcontractors should not add indirect rates on this schedule. Their rates should be fully burdened using Schedule 11.

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

Schedule 3

SCHEDULE 3

CALCULATION OF CPFF DIRECT LABOR COSTS - MITS

Offeror or Subcontractor Name: _________________________________________________________

A. Labor Hours
Labor Category	Period 1	Period 2	Period 3	Period 4
Contract Program Manager	1,692	1,692	1,692	1,692
Contract Manager	1,692	1,692	1,692	1,692
Financial Manager	1,692	1,692	1,692	1,692
HR Manager	1,692	1,692	1,692	1,692
Project Manager	16,200	12,600	13,500	13,950
Subject Matter Expert	16,200	12,600	13,950	13,950
Senior General Engineer	27,000	22,500	24,300	24,750
Mid-Level General Engineer	22,500	18,000	20,250	20,250
Junior General Engineer	13,500	11,250	13,500	13,950
Senior IT Engineer	23,400	20,250	21,150	22,050
Mid-Level IT Engineer	18,900	16,650	18,900	18,900
Junior IT Engineer	9,000	7,650	9,000	9,495
Senior Application Developer	21,600	18,450	19,800	20,250
Mid-Level Application Developer	15,750	14,850	15,300	16,200
Junior Application Developer	9,450	7,200	7,650	7,650
Senior Analyst	25,200	21,600	22,950	23,895
Mid-Level Analyst	22,500	18,000	20,250	20,250
Junior Analyst	13,500	9,900	11,250	11,250
Senior Technician	2,779	2,779	2,779	2,779
Mid-Level Technician	1,818	1,818	1,818	1,818
Junior Technician	1,350	1,350	1,350	1,350

Total	267,415	224,215	244,465	249,505
B. Unburdened Labor Rates
Labor Category	Period 1	Period 2	Period 3	Period 4
Contract Program Manager	$	$	$	$
Contract Manager	$	$	$	$
Financial Manager	$	$	$	$
HR Manager	$	$	$	$
Project Manager	$	$	$	$
Subject Matter Expert	$	$	$	$
Senior General Engineer	$	$	$	$
Mid-Level General Engineer	$	$	$	$
Junior General Engineer	$	$	$	$
Senior IT Engineer	$	$	$	$
Mid-Level IT Engineer	$	$	$	$
Junior IT Engineer	$	$	$	$
Senior Application Developer	$	$	$	$
Mid-Level Application Developer	$	$	$	$
Junior Application Developer	$	$	$	$
Senior Analyst	$	$	$	$
Mid-Level Analyst	$	$	$	$
Junior Analyst	$	$	$	$
Senior Technician	$	$	$	$
Mid-Level Technician	$	$	$	$
Junior Technician	$	$	$	$
C. Extended Labor Cost (A times B)
Labor Category	Period 1	Period 2	Period 3	Period 4
Contract Program Manager	$	$	$	$
Contract Manager	$	$	$	$
Financial Manager	$	$	$	$
HR Manager	$	$	$	$
Project Manager	$	$	$	$
Subject Matter Expert	$	$	$	$
Senior General Engineer	$	$	$	$
Mid-Level General Engineer	$	$	$	$
Junior General Engineer	$	$	$	$
Senior IT Engineer	$	$	$	$
Mid-Level IT Engineer	$	$	$	$
Junior IT Engineer	$	$	$	$
Senior Application Developer	$	$	$	$
Mid-Level Application Developer	$	$	$	$
Junior Application Developer	$	$	$	$
Senior Analyst	$	$	$	$
Mid-Level Analyst	$	$	$	$
Junior Analyst	$	$	$	$
Senior Technician	$	$	$	$
Mid-Level Technician	$	$	$	$
Junior Technician	$	$	$	$

Total $ $ $ $

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

Schedule 4

SCHEDULE 4

CALCULATION OF DIRECT LABOR COST FOR TIME AND MATERIAL/LABOR HOUR PRIME OFFEROR - MITS

Offeror: _________________________________________________________

A. Labor Hours
Labor Category (Offerors shall edit as necessary)	Period 1	Period 2	Period 3	Period 4
Contract Program Manager	188	188	188	188
Contract Manager	188	188	188	188
Financial Manager	188	188	188	188
HR Manager	188	188	188	188
Project Manager	1,800	1,400	1,500	1,550
Subject Matter Expert	1,800	1,400	1,550	1,550
Senior General Engineer	3,000	2,500	2,700	2,750
Mid-Level General Engineer	2,500	2,000	2,250	2,250
Junior General Engineer	1,500	1,250	1,500	1,550
Senior IT Engineer	2,600	2,250	2,350	2,450
Mid-Level IT Engineer	2,100	1,850	2,100	2,100
Junior IT Engineer	1,000	850	1,000	1,055
Senior Application Developer	2,400	2,050	2,200	2,250
Mid-Level Application Developer	1,750	1,650	1,700	1,800
Junior Application Developer	1,050	800	850	850
Senior Analyst	2,800	2,400	2,550	2,655
Mid-Level Analyst	2,500	2,000	2,250	2,250
Junior Analyst	1,500	1,100	1,250	1,250
Senior Technician	309	309	309	309
Mid-Level Technician	202	202	202	202
Junior Technician	150	150	150	150

Total	29,713	24,913	27,163	27,723
B. Fully Burdened Fixed Labor Rates
Labor Category (Offerors shall edit as necessary)	Period 1	Period 2	Period 3	Period 4
Contract Program Manager	$	$	$	$
Contract Manager	$	$	$	$
Financial Manager	$	$	$	$
HR Manager	$	$	$	$
Project Manager	$	$	$	$
Subject Matter Expert	$	$	$	$
Senior General Engineer	$	$	$	$
Mid-Level General Engineer	$	$	$	$
Junior General Engineer	$	$	$	$
Senior IT Engineer	$	$	$	$
Mid-Level IT Engineer	$	$	$	$
Junior IT Engineer	$	$	$	$
Senior Application Developer	$	$	$	$
Mid-Level Application Developer	$	$	$	$
Junior Application Developer	$	$	$	$
Senior Analyst	$	$	$	$
Mid-Level Analyst	$	$	$	$
Junior Analyst	$	$	$	$
Senior Technician	$	$	$	$
Mid-Level Technician	$	$	$	$
Junior Technician	$	$	$	$
C. Extended Labor Cost (A times B)
Labor Category (Offerors shall edit as necessary)	Period 1	Period 2	Period 3	Period 4
Contract Program Manager	$	$	$	$
Contract Manager	$	$	$	$
Financial Manager	$	$	$	$
HR Manager	$	$	$	$
Project Manager	$	$	$	$
Subject Matter Expert	$	$	$	$
Senior General Engineer	$	$	$	$
Mid-Level General Engineer	$	$	$	$
Junior General Engineer	$	$	$	$
Senior IT Engineer	$	$	$	$
Mid-Level IT Engineer	$	$	$	$
Junior IT Engineer	$	$	$	$
Senior Application Developer	$	$	$	$
Mid-Level Application Developer	$	$	$	$
Junior Application Developer	$	$	$	$
Senior Analyst	$	$	$	$
Mid-Level Analyst	$	$	$	$
Junior Analyst	$	$	$	$
Senior Technician	$	$	$	$
Mid-Level Technician	$	$	$	$
Junior Technician	$	$	$	$

Total $ $ $ $

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

Schedule 5

SCHEDULE 5

CALCULATION OF DIRECT LABOR COST FOR TIME AND MATERIAL/LABOR HOUR SUBCONTRACTORS ONLY - MITS

Subcontractor Name: _________________________________________________________

A. Labor Hours
Labor Category (Offerors shall edit as necessary)	Period 1	Period 2	Period 3	Period 4
Contract Program Manager
Contract Manager
Financial Manager
HR Manager
Project Manager
Subject Matter Expert
Senior General Engineer
Mid-Level General Engineer
Junior General Engineer
Senior IT Engineer
Mid-Level IT Engineer
Junior IT Engineer
Senior Application Developer
Mid-Level Application Developer
Junior Application Developer
Senior Analyst
Mid-Level Analyst
Junior Analyst
Senior Technician
Mid-Level Technician
Junior Technician

Total
B. Fully Burdened Fixed Labor Rates
Labor Category (Offerors shall edit as necessary)	Period 1	Period 2	Period 3	Period 4
Contract Program Manager	$	$	$	$
Contract Manager	$	$	$	$
Financial Manager	$	$	$	$
HR Manager	$	$	$	$
Project Manager	$	$	$	$
Subject Matter Expert	$	$	$	$
Senior General Engineer	$	$	$	$
Mid-Level General Engineer	$	$	$	$
Junior General Engineer	$	$	$	$
Senior IT Engineer	$	$	$	$
Mid-Level IT Engineer	$	$	$	$
Junior IT Engineer	$	$	$	$
Senior Application Developer	$	$	$	$
Mid-Level Application Developer	$	$	$	$
Junior Application Developer	$	$	$	$
Senior Analyst	$	$	$	$
Mid-Level Analyst	$	$	$	$
Junior Analyst	$	$	$	$
Senior Technician	$	$	$	$
Mid-Level Technician	$	$	$	$
Junior Technician	$	$	$	$
C. Extended Labor Cost (A times B)
Labor Category (Offerors shall edit as necessary)	Period 1	Period 2	Period 3	Period 4
Contract Program Manager	$	$	$	$
Contract Manager	$	$	$	$
Financial Manager	$	$	$	$
HR Manager	$	$	$	$
Project Manager	$	$	$	$
Subject Matter Expert	$	$	$	$
Senior General Engineer	$	$	$	$
Mid-Level General Engineer	$	$	$	$
Junior General Engineer	$	$	$	$
Senior IT Engineer	$	$	$	$
Mid-Level IT Engineer	$	$	$	$
Junior IT Engineer	$	$	$	$
Senior Application Developer	$	$	$	$
Mid-Level Application Developer	$	$	$	$
Junior Application Developer	$	$	$	$
Senior Analyst	$	$	$	$
Mid-Level Analyst	$	$	$	$
Junior Analyst	$	$	$	$
Senior Technician	$	$	$	$
Mid-Level Technician	$	$	$	$
Junior Technician	$	$	$	$

Total $ $ $ $

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

Schedule 6

SCHEDULE 6

PROPOSED INDIRECT RATES AND ALLOCATION BASES - MITS

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__

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

Schedule 7

SCHEDULE 7

ESTABLISHMENT OF MAXIMUM FACTORS FOR THE MASTER CONTRACT AND CALCULATION OF PROPOSED FIXED FEE FOR CPFF - MITS

Offeror Name: _________________________________________________________

FIXED FEE - MITS
	Estimated Cost	Percentage (3)	Fixed Fee Dollars
Subcontracts and Other Direct Costs from Schedule 2 (1)	$	%	$
All Other Costs from Schedule 2 (2)	$	%	$
Total	$
Total Fixed Fee Dollars (4)			$

(1) "Subcontracts and Other Direct Costs” 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.6 - COST AND BUSINESS PROPOSAL SCHEDULES

Schedule 8

SCHEDULE 8

TABLE OF SUBCONTRACTORS - MITS

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

Schedule 9

SCHEDULE 9

ALLOCATION OF LABOR HOURS BETWEEN OFFEROR AND SUBCONTRACTORS - MITS

Offeror or Subcontractor Name: _________________________________________________________

	Prime	Sub A	Sub B	Sub C	Sub D	Total	RFP Total
Contract Program Manager							7,520
Contract Manager							7,520
Financial Manager							7,520
HR Manager							7,520
Project Manager							62,500
Subject Matter Expert							63,000
Senior General Engineer							109,500
Mid-Level General Engineer							90,000
Junior General Engineer							58,000
Senior IT Engineer							96,500
Mid-Level IT Engineer							81,500
Junior IT Engineer							39,050
Senior Application Developer							89,000
Mid-Level Application Developer							69,000
Junior Application Developer							35,500
Senior Analyst							104,050
Mid-Level Analyst							90,000
Junior Analyst							51,000
Senior Technician							12,352
Mid-Level Technician							8,080
Junior Technician							6,000

Total 1,095,112

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

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

Schedule 10

SCHEDULE 10

LABOR COST REALISM - MITS

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 than the Schedule 3 or 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.

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

Schedule 11

SCHEDULE 11

RESUME CHECKLIST - MITS

Offeror or Subcontractor Name: _________________________________________________________

Labor Category	No. of Resumes	Employee Name	Prime or Subcontractor Name
Contract Program Manager (Key Personnel	1
Transition Manager (for first Task Order; Key Personnel)	1
Project Manager	2
Subject Matter Expert	2
Senior General Engineer	1
Senior IT Engineer	1
Senior Application Developer	1

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

File details come from the government source that posted it. Updated Apr 13, 2021.