Attachment J-1_SWIFT Pricing Template.xlsx

XLSX spreadsheet 766 KB Posted Feb 25, 2022

Attached to: Scalable Ways to Implement Flexible Tasks (SWIFT) Federal contract opportunity
Solicitation number: 70CTD022R00000002
Issued by: Immigration and Customs Enforcement

About this file

Written by GovTribe AI · Dec 30, 2023

This document includes a pricing template and solicitation for establishing multiple award indefinite delivery/indefinite quantity contracts. The pricing template outlines various contract line item numbers including time and materials and firm fixed price CLINs for platform as a service, hyperautomation, collaborative services, visualization, software licenses, travel, and a minimum guarantee. Labor categories, hours, and rates are included for each CLIN covering a five-year period of performance. The related solicitation from Immigration and Customs Enforcement seeks proposals to provide scalable ways to implement flexible tasks including platform as a service, hyperautomation, collaborative services, and visualization. The $340 million ceiling will be shared among all awardees. Proposals for Phase I are due by the date specified in block 8 of the SF1449 form with Phase II proposals and contract awards to be determined later in 2022. Two domains are set aside for small businesses.

View the file

Other files for this federal contract opportunity

Other files attached to Scalable Ways to Implement Flexible Tasks (SWIFT), newest first.
File	Type	Posted
70CTD022R00000002_RFP_031122.pdf	PDF	Mar 11, 2022
70CTD022R00000002_SF30_Amendment 0002.pdf	PDF	Mar 11, 2022
70CTD022R00000002_RFP_031022.pdf	PDF	Mar 10, 2022
70CTD022R00000002_SF30_Amendment 0001.pdf	PDF	Mar 10, 2022
Attachment J-6_SWIFT_Question Template_031022v1.pdf	PDF	Mar 10, 2022
70CTD022R00000002_SF 1449.pdf	PDF	Feb 25, 2022
Attachment J-4_SWIFT_Small Business Participation Plan.docx	DOCX document	Feb 25, 2022
Attachment J-6_SWIFT_Question Template.xlsx	XLSX spreadsheet	Feb 25, 2022
70CTD022R00000002_Final RFP dated 22522.pdf	PDF	Feb 25, 2022
Attachment J-7_SWIFT LCAT Descriptions.pdf	PDF	Feb 25, 2022
Attachment J-2_SWIFT Performance Work Statement.pdf	PDF	Feb 25, 2022
Attachment J-9_SWIFT Ordering Guide.pdf	PDF	Feb 25, 2022
Attachment J-5_SWIFT Quality Assurance Surveillance Plan.pdf	PDF	Feb 25, 2022
Attachment J-8_SWIFT Task Order 1.pdf	PDF	Feb 25, 2022

Show all 14

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.

CLIN totals

	CLIN type	Description	Totals
CLIN 0001	T&M	PaaS	$ - 0
CLIN 0002	FFP	PaaS	$ - 0
CLIN 0003	T&M	Hyper Automation	$ - 0
CLIN 0004	FFP	Hyper Automation	$ - 0
CLIN 0005	T&M	Collaborative Services	$ - 0
CLIN 0006	FFP	Collaborative Services	$ - 0
CLIN 0007	T&M	Visualization	$ - 0
CLIN 0008	FFP	Visualization	$ - 0
CLIN 0009	FFP	Software Licenses	$ 86,781,323.00
CLIN 0010	T&M	Travel	$ 1,000,000.00
CLIN 0011	FFP	Minimum Guarantee	$ 20,000.00
Total			$ 87,801,323.00

NOTES & ASSUMPTIONS:

The IDIQ will consist of Firm Fixed Price (FFP) and Time and Materials CLINS

T&M CLINs can be split between PRIME and Subcontractor but should not exceed government estimated totals for the labor category

The IDIQs are for a 5 year period of performance from date of award.

Escalation for labor rates shall NTE 2.5% per year

There is no anticipated mark-up fee in connection to travel; the vendor will be reimbursed for travel at cost.

PaaS CLIN 1 (T&M)

Requirement Title: PaaS T&M CLIN

Period of Performance	2022/2023			2023/2024			2024/2025			2025/2026			2026/2027			Total Hours	Total Price
PRIME Labor Category	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total
Senior Project Manager	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman ScrumMaster	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman Management Analyst	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Junior Software Develpoer	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Senior Software Developer	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Senior Software Developer	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman Training and Development Specialist	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Senior Software Quality Assurance Engineer and Tester	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0

SUBCONTRACTOR Labor Category												$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Labor Total	15040	$ - 0	15040	$ - 0	15040	$ - 0	15040	$ - 0	15040	$ - 0	75200	$ - 0

PaaS CLIN 2 (FFP)

Requirement Title: PaaS FFP

Period of Performance	2022/2023			2023/2024			2024/2025			2025/2026			2026/2027			Total Hours	Total Price
Labor Category	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total
Senior Project Manager	9400		$ - 0	9400			9400			9400			9400			47000	$ - 0
Journeyman ScrumMaster	9400		$ - 0	9400			9400			9400			9400			47000	$ - 0
Journeyman Management Analyst	9400		$ - 0	9400			9400			9400			9400			47000	$ - 0
Junior Software Develpoer	9400		$ - 0	9400			9400			9400			9400			47000	$ - 0
Senior Software Developer	16920		$ - 0	16920			16920			16920			16920			84600	$ - 0
Senior Software Developer	9400		$ - 0	9400			9400			9400			9400			47000	$ - 0
Journeyman Training and Development Specialist	9400		$ - 0	9400			9400			9400			9400			47000	$ - 0
Senior Software Quality Assurance Engineer and Tester	9400		$ - 0	9400			9400			9400			9400			47000	$ - 0
Labor Total	82720		$ - 0	82720		$ - 0	82720		$ - 0	82720		$ - 0	82720		$ - 0	413600	$ - 0

HyperAutomation CLIN 3 (T&M)

Requirement Title: Hyper Automation T&M CLIN

Period of Performance	2022/2023			2023/2024			2024/2025			2025/2026			2026/2027			Total Hours	Total Price
Labor Category	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total
Senior Project Manager	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman ScrumMaster	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman Management Analyst	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Junior Software Develpoer	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Senior Software Developer	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman Training and Development Specialist	1880		$ - 0	990		$ - 0	990		$ - 0	990		$ - 0	990		$ - 0	5840	$ - 0
Senior Software Quality Assurance Engineer and Tester	1880		$ - 0	990		$ - 0	990		$ - 0	990		$ - 0	990		$ - 0	5840	$ - 0

SUBCONTRACTOR Labor Category
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Labor Total	13160	$ - 0	11380	$ - 0	11380	$ - 0	11380	$ - 0	11380	$ - 0	58680	$ - 0

HyperAutomation CLIN 4 (FFP)

Requirement Title: HyperAutomation FFP CLIN

Period of Performance	2022/2023			2023/2024			2024/2025			2025/2026			2026/2027			Total Hours	Total Price
Labor Category	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total
Journeyman Management Analyst	15040			15040	0	$ - 0	15040	0	$ - 0	15040	0	$ - 0	15040	0	$ - 0	75200	$ - 0
Junior Software Develpoer	15040			15040	0	$ - 0	15040	0	$ - 0	15040	0	$ - 0	15040	0	$ - 0	75200	$ - 0
Senior Software Developer	15040			15040	0	$ - 0	15040	0	$ - 0	15040	0	$ - 0	15040	0	$ - 0	75200	$ - 0
Labor Total	45120			45120		$ - 0	45120		$ - 0	45120		$ - 0	45120		$ - 0	225600	$ - 0

Collaborative CLIN 5 (T&M)

Requirement Title: Collaborative Services T&M CLIN

Period of Performance	2022/2023			2023/2024			2024/2025			2025/2026			2026/2027			Total Hours	Total Price
Labor Category	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total
Senior Project Manager	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman ScrumMaster	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman Management Analyst	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Junior Software Develpoer	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Senior Software Developer	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Senior Software Developer	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman Training and Development Specialist	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Senior Software Quality Assurance Engineer and Tester	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
SME - Scrumaster	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Senior Management Analyst	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0

SUBCONTRACTOR Labor Category
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Labor Total	18800	$ - 0	18800	$ - 0	18800	$ - 0	18800	$ - 0	18800	$ - 0	94000	$ - 0

Collaborative CLIN 6 (FFP)

Requirement Title: Collaborative Services FFP CLIN

Period of Performance	2022/2023			2023/2024			2024/2025			2025/2026			2026/2027			Total Hours	Total Price
Labor Category	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total
Senior Project Manager	7680			7680			7680			7680			7680			38400	$ - 0
Journeyman ScrumMaster	7680			7680			7680			7680			7680			38400	$ - 0
Journeyman Management Analyst	7680			7680			7680			7680			7680			38400	$ - 0
Junior Software Develpoer	7680			7680			7680			7680			7680			38400	$ - 0
Senior Software Developer	11280			11280			11280			11280			11280			56400	$ - 0
Senior Software Developer	7680			7680			7680			7680			7680			38400	$ - 0
Journeyman Training and Development Specialist	7680			7680			7680			7680			7680			38400	$ - 0
Senior Software Quality Assurance Engineer and Tester	7680			7680			7680			7680			7680			38400	$ - 0
Senior Web Developer	7680			7680			7680			7680			7680			38400	$ - 0
Labor Total	72720		$ - 0	72720		$ - 0	72720		$ - 0	72720		$ - 0	72720		$ - 0	363600	$ - 0

Visualization CLIN 7(T&M)

Requirement Title: Visualization T&M CLIN

Period of Performance	2022/2023			2023/2024			2024/2025			2025/2026			2026/2027			Total Hours	Total Price
Labor Category	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total
Senior Project Manager	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman ScrumMaster	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman Management Analyst	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Senior Data Architecht	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Senior Software Developer	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman Training and Development Specialist	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Senior Software Quality Assurance Engineer and Tester	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0
Journeyman Information Security Analyst	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	1880		$ - 0	9400	$ - 0

SUBCONTRACTOR Labor Category
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Labor Total	15040	$ - 0	15040	$ - 0	15040	$ - 0	15040	$ - 0	15040	$ - 0	75200	$ - 0

Visualization CLIN 8 (FFP)

Requirement Title: Visualization FFP CLIN

Period of Performance	2022/2023			2023/2024			2024/2025			2025/2026			2026/2027			Total Hours	Total Price
Labor Category	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total
Journeyman Management Analyst	15040		$ - 0	15040		$ - 0	15040		$ - 0	15040		$ - 0	15040		$ - 0	75200	$ - 0
Junior Software Develpoer	15040		$ - 0	15040		$ - 0	15040		$ - 0	15040		$ - 0	15040		$ - 0	75200	$ - 0
Journeyman Data Architect	15040		$ - 0	15040		$ - 0	15040		$ - 0	15040		$ - 0	15040		$ - 0	75200	$ - 0
Labor Total	45120		$ - 0	45120		$ - 0	45120		$ - 0	45120		$ - 0	45120		$ - 0	225600	$ - 0

CLIN 9 Licenses (FFP)

Requirement Title: Licences and Professional Services

Period of Performance

2022/2023

2023/2024

2024/2025

2025/2026

2026/2027

Total Price

Labor Category

Units

FFP

Total

Units

Rate

Total

Units

Rate

Total

Units

Rate

Total

Units

Rate

Total

Subtotal LOT $ 16,900,000.00 $ - 0 LOT $ 17,122,500.00 $ - 0 LOT $ 17,350,563.00 $ - 0 LOT $ 17,584,326.00 $ - 0 LOT $ 17,823,934.00 $ - 0 $ 86,781,323.00

CLIN 10 Travel

Requirement Title:Travel

2022/2023 Rates

2023/2024 Rates

2024/2025 Rates

2025/2026 Rates

2026/2027 Rates

Total Price

Travel

Subtotal

200,000

NTE

$ - 0

200,000

NTE

$ - 0

200,000

NTE

$ - 0

200,000

NTE

$ - 0

200,000.00

NTE

$ - 0

$ 1,000,000.00

CLIN 11 Min Guarante(FFP)

Requirement Title:Minimum Guarantee

Period of Performance 2022/2027
Description	Quantity	Rate	TOTAL
Minimum Guarantee	8	$ 2,500.00	$ 20,000.00

SWIFT Labor Categories

		Rates
		2022	2023	2024	2025	2026	2027
Labor Category
Information Security Analyst
	Junior Information Security Analyst
	Journeyman Information Security Analyst
	Senior Information Security Analyst
	SME - Information Security Analyst
Information Technology Project Manager
	Junior Information Technology Project Manager
	Journeyman Information Technology Project Manager
	Senior Information Technology Project Manager
	SME - Information Technology Project Manager
ScrumMaster
	Junior ScrumMaster
	Journeyman ScrumMaster
	Senior Scrumaster
	SME - Scrumaster
Management Analyst
	Junior Management Analyst
	Journeyman Management Analyst
	Senior Management Analyst
	SME - Management Analyst
Network and Computer Systems Administrator
	Junior Network and Computer Systems Administrator
	Journeyman Network and Computer Systems Administrator
	Senior Network and Computer Systems Administrator
	SME - Network and Computer Systems Administrator
Software Developer, Applications
	Junior Software Developer, Applications
	Journeyman Software Developer, Applications
	Senior Software Developer, Applications
	SME - Software Developer, Applications
Software Developer, Systems Software
	Junior Software Developer, Systems Software
	Journeyman Software Developer, Systems Software
	Senior Software Developer, Systems Software
	SME - Software Developer, Systems Software
Software Quality Assurance Engineer and Tester
	Junior Software Quality Assurance Engineer and Tester
	Journeyman Software Quality Assurance Engineer and Tester
	Senior Software Quality Assurance Engineer and Tester
	SME - Software Quality Assurance Engineer and Tester
Technical Writer
	Junior Technical Writer
	Journeyman Technical Writer
	Senior Technical Writer
	SME - Technical Writer
Training and Development Specialist
	Junior Training and Development Specialist
	Journeyman Training and Development Specialist
	Senior Training and Development Specialist
	SME - Training and Development Specialist
Web Administrator
	Junior Web Administrator
	Journeyman Web Administrator
	Senior Web Administrator
	SME - Web Administrator
Web Developer
	Junior Web Developer
	Journeyman Web Developer
	Senior Web Developer
	SME - Web Developer
Database Administrator
	Junior Database Administrator
	Journeyman Database Administrator
	Senior Database Administrator
	SME - Database Administrator
Database Architect
	Junior Database Architect
	Journeyman Database Architect
	Senior Database Architect
	SME - Database Architect
Document Management Specialist
	Junior Document Management Specialist
	Journeyman Document Management Specialist
	Senior Document Management Specialist
	SME - Document Management Specialist

Sheet2

File details come from the government source that posted it. Updated Feb 25, 2022.